Question

You are appointed as a site engineer representing a consulting firm to supervise a construction project. The project will start on the 1 January and is expected to be completed in 10 month. The cost break down for the project is as shown in Table 1 below. Table 1. Cost Breakdown of the Project Work Cost Rd Seart Finish 100 000 Jan 31 Jan piling 300 000 Feb 1 March Sub-structure 300 000 15 Feb 15 May Beams Stab-deck 80 000 15. April 30 June Earthwork 50 000 ruy 31 Aug Road work 100 000 1 Sept. 31 October Prepare the financial S-curve for the project.. is marks) b) Your boss told you that the financial S-curve cannot be used to monitor the overall progress of the project because it does not give a true picture of time taken and effort to perform the activities involved in the project. He assigned Weight Multipliers as shown in Table 2 to help you to prepare the planned Physical Progress of the project. Show the S-Curve for the physical progress on the same graph as in (a) Table 2 Weight Multiplier for Physical Progress Work Weightage multipliers 0.1 piling 0.25 Sub-structure 0.2 Seams 0.15 Slab-deck Earthwork Road work 0.1 0.2 marks) Physical progress at site at the end of June is 60% and actual cost has reached RM 700,000. Evaluate the status of the project and give recommendation on the action to be taken on the project. Your evaluation must include:- Whether the project is ahead or behind schedule. State the estimated number of days. - Is there a cost overrun or underrun? State the amount Estimated total cost of the project Show your calculation in your analysis and use graph (a) and (b) to enhance your explanation.

Answer 1

(a) Here in this table work and cost is written down and based on commutative cost and time graph is drawn which is of blue Colour.

Time	Work	Cost	Comulative Cost
01-Jan	Piling	100000	100000
01-Feb	Sub Structure	3,00,000	4,00,000
15-Feb	Beams	3,00,000	7,00,000
15-Apr	Slab-Deck	80,000	7,80,000
01-Jul	Earthwork	50,000	8,30,000
01-Sep	Road Work	1,00,000	9,30,000

(b)Here in the given data weightage of each work is given. to match this graph to financial graph , we multiply this weightage to 1,00,000 . And than commutative progress of work is calculated. Based on this Comulative progress of work and Tim graph is located which is of orange colour.

Time	Work	Weightage	Physical work done	Comulative
01-Jan	Piling	0.1	100000	100000
01-Feb	Sub Structure	0.25	250000	350000
15-Feb	Beams	0.2	200000	550000
15-Apr	Slab-Deck	0.15	150000	700000
01-Jul	Earthwork	0.1	100000	800000
01-Sep	Road Work	0.2	200000	1000000

Blue Colour - Financial S curve

Orange Colour - Physical Progress S curve.

S Curve 26-Sep 07-Aug 18-Jun 29-Apr 10-Mar 20-Jan 01-Dec 0 200000 400000 600000 800000 1000000 1200000

(C) As per given data:

At the end of June work complete by (30th June) is 60%

And Actual total cost up to this time is RM 7,00,000.

While from the graph and given data we can observe that from the 1st July earth work will start and before earthwork 70% work is completed. While here on the 30th June only 60% work is completed thus our work is behind the schedule.

15th April to 1st July work of slab deck is running whose weightage is 15% and cost is 80,000.

but we have completed only 60% work that means we have done only 5% work of slab deck.

thus cost of slab deck = (0.5*80,0000)/0.15 = 26,667 RM

so total cost up to end of the June = cumulative up to 15th April +26,667 = 7,00,000+26,667 = 7,26,667 RM.

7,26,667 RM is estimated cost of work up to 30th June. But our actual cost is 7,00,000 Rm

thus Project is UnderRun.

Toatl cost of project is commulative cost of each and every work =  9,30,000 RM.