Project Control Reporting On Lump Sum Project
Project Control Reporting On Lump Sum Project
The detail level of the tasks can vary depending After the reviews of the project performance are
on the project. For example, a task might be all complete, forecast-to-complete hours and costs
electrical drawings or all one line diagrams or should be developed to compare with the budget
each one line diagram. The tasks can then be put amount.
into a schedule with a weighting assigned to each
1986/-MCETRWNSACTIONS 8.7.1
Design Change Notice Monitoring during the design phase.
Throughout the engineering phase, the cost The pending changes include all changes to the
engineer must keep a log of all changes to the contract that have not been committed, including
proposal design. These changes can result from escalation allowances, known client changes, and
omissions in the base bid, proposed changes to the design advancements.
scope of work developed by value engineering
studies, or by client requests. The changes once The variances between the budget and forecast,
approved will then show up as deviations in the if great enough, should be explained by the use of
project management reports or as changes to the a design change notice report (which is discussed
budget amount. Design change notice monitoring in a later paragraph). The monitoring index
will be discussed later in the management section. which would compare the budget and current is:
CONSTRUCTION
Materials
Cost Monitoring
Materials include all commodity type bulk-bought
The monitoring of construction costs in a de- items. They can be prepurchased or bought during
sign/construct project has two stages. The first the construction phase. The establishment of a
would be to compare the bid with the design phase monitoring system consists of a system for tracking
advancements, procurements and changes. The second. both quantities and the price of materials. The
occurs during construction when the actual quanti- document for monitoring materials during the design
ties, workhours, and costs are compared to the phase would be similar to that of equipment and
status at the end of the design phase and to the would contain the following detail for each item:
budget. The basis of comparison changes from the
bid amount to the total estimated at the end of the 0 System and description
design phase, although it still has to.be compared 0 Budget amount (including authorized
to the contract total. (The contract amount can changes)
be different than the amount estimated at the end Committed amount
of design.) Forecast total (includes committed plus
pending changes or current design status)
The next few sections will deal with the Variance between budget and forecast
establishment of documents that can be used to amount
monitor the construction cost of:
The detail that would be monitored can vary.
0 Equipment For example, electrical materials can be total
' Materials and temporary construction electrical, or total wire and cable, or each size
facilities and equipment or type of wire and cable. For each selected
' Craft labor commodity, both the quantity and the delivered cost
o Field management of each must be tracked.
O Change Orders
For the bid, some items would have been quanti-
Equipment
fied based on drawings or preliminary designs and
others would have been estimated as an allowance.
The equipment that will be prepurchased by the
This lump sum should be listed on the table rather
use of an engineering specification is discussed in
than guessing quantities.
this section.
During the time of the preparation of the bid, During design, as systems are completed, bills
quotations will have been obtained from vendors for of material will be developed for purchasing
this equipment. These prices with the necessary purposes. From these lists, commodities can be
additions for escalation, contingencies, and compared both for quantities and estimated for
omissions would be the budget amount for each item. costs. When the purchase orders are placed, the
A table would be developed to monitor each purchase actual costs can then be compared to the est,imated
order. Included for each order would be: amounts. Also the overall costs of the item can be
tracked based on the quantity installed. Table 1
" shows the detail of a material monitoring report.
Purchase order no. and description
' Budget amount (including authorized As shown, costs are compared from the bid, through
changes) design and construction by the use of columns for
' Committed amount budget/bid, current forecast, and installed quan-
0 tities and costs. The index of comparison between
Forecast total (includes committed
plus pending changes) the budget cost and current would be:
' Variance between budget and forecast
amount Imc = Budget $/Forecast $ and Actual $
8.7.2 1986AACETRANSACTlONS
TABLE 1: MATERIAL COSTS COMPARISONS
BUDGET
BUDGET AMOUUT APPROVED SCOPE CHARGES REV I SED BUDGE1 AUOUPT
IlEtl OUAUTITV COSIS WJAUl IIV COSTS OUAUTIIV COSlS
(Al (81 (Cl (01 (E:AtC) lF:B+Dl
----e-s-____________ ____________ ________---- ____________ ________---- ______-___-_ _________---
UMIT 5
tlEtlRiCA;
t71rt A cable-if 30,900 63,000 36,810 22,340 61.670 105,340
Cable tray-11 1,100 2l.IlO 0 1.100 11,510
Condolt-If 1,200 5,790 254 I.200 6,644
nltc rtr!N-I, 1 15.800 15,661 1 29,461
lUSTfiUMEl1 6 Cl15
Ttiblng-if 13,100 34,800 1,500 1,920 14,600 37.720
fllsc cquto.-ls I 62,300 0 29,372 1 91,672
TOTAL lt4SlR A CltS 91,100 32,292 119,392
TOTAL ElECTRlCAt 124,100 36,235 162,355 ~
__COtlIJIlf.lE#lS A#Dt!EI FORECAST
PURCHASED COSlS KMOWN CHAUGES COUllTtlEUIS CHAUGES OF OUEARUI
COSlS OUA#l I IV COSTS COSTS COSTS COSTS IUlJDERRU#l
(HI (1) (II (K:H*Ji (11 itl:KOrF*Ll lil-H-F)
---------- ---------_-- ---------__- ------------ ____________ __________ ___________ ___________
effort of the craft labor or productivity units would be reviewed and redefined as necessary. The
using a quantity of material. Once again there can labor of the tasks would occur similarly to the
be different levels of detail to develop the esti- bid but will be in more detail. The resulting
mate. The level of effort can be determined for craft labor loading would then be costed on a time-
the entire project or for various tasks within the phased basis and compared to the current budget.
scope of the work and then summed to calculate the The results of the comparison between the current
entire job. Productivity units can also be for forecast and the budget reveal to management the
various levels of detail based on the information problem areas so corrective action can be taken if
available. The labor is then costed and included possible. This revised craftloading would be the
in the bid. The prevailing wages would be used basis of the planning for the construction period.
to cost the labor with the necessary adders for (The indirect facilities would be based on these
travel, benefits, insurance and taxes. Allowances totals.) For productivity unit estimates, review
for escalation must also be included. There are of the quantities and assumptions for the units
two facets of craft labor that will have to be must occur and revised workhours determined. The
monitored during the project: craft hours and resulting workhours will be compared to the budget.
wage rates.
During construction, craft labor hours need to
During the design phase, variances to the craft be tracked by task in order to compare actuals with
labor estimate are tracked by design change notices scheduled and earned. A tracking report similar to
which may or may not be additive to budget amount Table 2 would be used to monitor actual hour expen-
but are added to the forecast total. A table can ditures and productivity against each task. The
be developed which would contain the following budget amount shown is the craft hours from the cur-
items: rent budget allocated for each task. The earned-
to-date figure would be the result of multiplying
- Budget amount (including all changes) the budget total by the actual percentage complete
- Forecast at completion total of the task. The scheduled complete workhours are
- Variance amount similar but are based on the scheduled percentage
complete times the budget workhours. The perfor-
Near the end of the design phase and prior to mance indices would compare earned with actual and
the start of construction, the schedule and tasks scheduled with actual. The report could be relist-
4986AACETRAfflSACTIONS 8.7.3
TABLE 2: MONITORING OF ACTUAL HOUR EXPENDITURE AND PRODUCTIVITY AGAINST EACH TASK
AK1 Clwl 8111 MAN YHR x HAN % MAN YIN YHR tAANl tARW/
no OEScA1rll0n CODE CODE OUARI HOURS U/C COUP1 OUAUl HOURS COUP1 OUAWI HOURS OUANI HOURS u/c AClUAl SIHEO
_____ _____.___.__________----..---. ._____ ___ .____ ____ _.____.__ ____. ________ _____ ..L..- _.----- ----. ---_-- ._____. _.____ _____.- .._..__- _----_. -._____
10010 AFCCIVE 6UHLOAO PUlvERlZfR PIS FOR 9102 450 1901 110
13011 REClIVE ; UIILOAD PULV.FARlA FOR 9 10 I 150 7601 120
1001: RECEIVE 6 UNLOAD PULVEAIZER PIS FOR 9101 450 1101 240
10013 RECFIVI 6 UllOAD PUlVER1ZIA PlS FOR 6101 450 1601 160
1QOlQ RECEIVE 6 UNLOAD PULV.PAAIS FOR I ID I 450 1591 120
10015 RECtIVt (UNLOAD PUlV. PARIS FOR 1 10 I 450 1101 1)Q
IJQZI RECEIVE 6 UXLDAD PA FAN PARIS 450 1101 20
10022 UN1010 PA FAN YOIOR 450 2101 IO
10Ql0 ASStUBlE SPRIYS FilLIfS 550 1902 I10
10015 ASSEYBLE SPRING FRAMES 550 1102 I20
IO936 ASSLY5lt PYRllES HOPPER 6 CAIE VAlVtS 550 1102 110
10031 ASStlBlt PIRIlE NOPPLRS i CAIE VAlVtS 550 I902 119
10040 ASStYBlf PA FAN INlFl HOUSINGS 06 SHAFF 550 2402 I60
IQ045 ASStlBIE P& FAJI IIlFF HDUSJIGS ON SHAFF 550 2501 160
___ __._.___ _ ___ __.______ ___.____- _.._._ __.___
IO SUB 10111 0 0
___ .___._._. ___ _________ --._-.--- _.--.- . ..___
6.7.4 1986AACETRANSACTlONS
During the design phase, the schedule detail MANAGEMENT REPORTS
can be increased. More information will be
developed on the commodity quantities and the During the life of the project, corporate man-
entire scope of the project so that level of agement must be kept aware of the status of the
detail and confidence of the plan and project. The report should describe to management
schedule can increase. the problem areas , potential cost and schedule
variances, and recovery plans. Through use of the
At the conclusion of the design phase (prior indices developed in each section, management can
to construction), a revised plan and schedule be concisely shown the status of the project with a
should be developed to reflect the current scope table and a chart which would include the following
of the project. The schedule can be a detailed already discussed indices:
CPM chart, a milestone schedule or a bar chart
listing the tasks. showing durations, and per- " Idc - Compares earned engineering workhours
centages complete.for each. with actual
”
Ids - Compares earned engineering percent
Also at this time the labor loading of the complete with scheduled
tasks should occur. This forecasting will allow a 0 Iec - Compares equipment budget costs with
comparison to be developed to the bid and to ac- forecast/actual costs
tuals during construction. It will also aid in 0 Imc - Compares material budget costs with
the planning of support facilities for the crafts. forecast/actual costs
o Ilc - Compares the craft labor budget with
During construction, the schedule should be up- the forecast/actual
dated at set intervals which can be daily, weekly, o UC - Similar to Imc but for construction
etc. The tasks or activities listed on the sched- indirects
ule need to be weighted. This weighting can be o Isc - Compares for construction the
based on the estimated workhours to complete the percentage complete of earned versus
task, durations, or costs. The percentage com- scheduled
plete of each task can be determined and a weighted
percent can be calculated. The weighted percents An index which would represent the entire
would be summed for the entire project to deter- project is:
mine an overall complete of the project. For each
task, the actual and scheduled completeness must ^ _
" IPC - Compares the budget cost for the
be compared. Areas of concern should be noted and
recovery plans established as necessary. The project with the forecast and actual
scheduled versus actual comparison can be shown amount
as a management index:
Table 3 is an example of the index report.
Isc = Z Actual/% Scheduled
CONST MGT 2.00% 1.60% 1.90% 17 I4 16 1.214 1.063 I.290 8.9% 0.115
EOU I PMENT n/e n/e n/a 3065 NA 2990 n/e 1 .032 1 032 17.3% 0.176
MATFRIALS n/e n/a n/a 2699 NA 2769 n/a 0.975 0.975 14.1% 0.137
CRAFT LABOR n/a n/s n/s 6067 NA 6144 n/a 0.991 0.991 47.3% 0.469
CONST IND n/.9 n/e n/a 1017 NA 1024 n/a 0.993 0.993 6.2% 0.062
TOTAL 1.020
n INDICES CALCULATIONS:
PRODUCT. (PRODUCTIVITY) = EARNED MANHRSl ACTUAL MANHRS
COST (ENGINEERING) = EARNED DOLLARS/ ACTUAL DOLLARS
COST (CONSTRUCTION ITEMS) = BUDGET DOLLARS/ACTUAL DOLLARS (FORECAST)
ENGINEERING SCHEDULE INDEX = EARNED %I SCHEDULED %
PERF. (PERFORMANCE) = PRODUCT. JNDEX n COST INDEX
1986WACETRWNSWCTIONS 8.7.5
A summary cost table should also be included as material and equipment escalation rate would be
part of the management report. Table 4 is an tracked utilizing indices from a source such as
example of the document. Included as part of the the Producer Price Index published by the Bureau
report would be: of Labor Statistics. The base index would be the
date of the present day of the bid. Craft labor
Current budget amount could be tracked using the prevailing wage rates
Committed amount in the area. The local unions could be requested
Forecast/actual cost of committed,items to supply this information. The escalation
Budget for committed items increase would be calculated for each segment and
Forecast/actual cost 'of all items then based on the weighted value, determined for
Variance to the budget from forecast/actual the project.
PROJECTED TOT9L
Tcl?*L BUDGET FOR BVPiE7 EXPEND’TURES ALLOW =DR FlNAi COSTS C”RREN7 OVEF4VN
BUDGET COMM. i TEMS NOT COMM. 6 CDMM’TMTS CliAN;ES FOR CDMM~TMTS FORECAST (LINDEFRUN)
DESCRIPTION
(Al (81 (C-A-6) (D) (El (F=D-E! (01 tH=G-C,
________________________________________________~_~-~~----------------------------~~------~--~__~__________________________~
ENGlNEERlNG
BASE s1.40c.000 L1.325.000 s1.450.500 l5C.500
FEE 130.000 98.000 130.000 0
________-_-- ____:___.z___ _____________________-__ __________ --__--______ ____________ __________--
CONSTRUCTION
CONS, MOT 18?6.000 662.254 162.25. s850.000 1626.000)
1.305 6@1 43.819 1.227.161 22.000 1 .249.16‘ 1.266.161 (61 ,339)
EOU I PMENT 1.349.500
MATERIALS 1.266.000 I.013 22r 274.779 925.291 90.000 l.Of5.29f 1.316.918 26.919
TOTAL. PROJECT 110.463.500 S2.176.902 t5.580.598 13.706.665 61~2.000 t2.395.685 110.446.560 (614.920)
6.7.6 1986AACETRANSACTlONS