Question

You are building a bus stop shelter and have been working on it for 20 days. Your boss has asked for a status report for the project after 20 days.

a) Fill in the missing values in the following Status Report.

b) For the entire project, what is the current

a. Cost Performance Index, CPI = ________,

b. Schedule Performance Index, SPI = _________,

c. Cost Variance, CV = _________,

d. Schedule Variance, SV = __________.

c) Suppose that the work from this date forward will progress at planned rates whether or not these rates have prevailed to date. What is the forecasted cost at completion (FAC) for the entire project?

item	total budget($)	planned progress	BCWS($)	ACWP($)	ACTUAL PROGRESS	BCWP($)	CV	SV	FAC($)
excavation	9600	100%		9000	100%
cast slab	1800	100%		2000	100%
curb	1500	100%		1500	100%
walls	2700	80%		2500	100%
paving	1200	40%		300	20%
roof trusses	1000	40%		500	60%
roofing	600	10%		0	0%
lights	500	20%		250	40%
seating	500	0%		0	0%
paint	1000	0%		0	0%

Answer 1

We complete the given table as shown below:

The columns highlighted in green are calculated by us.

The above table in the form of formulas is shown below for better understanding and reference:

Based on the above, we find the answers as shown below:

For the entire project, the current

a. Cost Performance Index, CPI = 1.037

b. Schedule Performance Index, SPI = 1.034

c. Cost Variance, CV = $590

d. Schedule Variance, SV = $540

c) The forecasted cost at completion (FAC) for the entire project, considering that the work from this date forward will progress at planned rates = $19810

-----------------------------------------------------------------------------------------------------------------------

In case of any doubt, please ask through the comment section before Upvote/downvote.

If you liked the answer, please give an upvote. This will be quite encouraging for me, thank-you!!!