Question

Instructions: You are preparing a status report for your project sponsor and stakeholders and it's important to share the project progress using the Earned Value technique. You are preparing your status report for the period ending October 28th. Your project started February 27th. Assume that the project is executed 5 days per week and 8 hours per day with some additional hours that amount to 8 hours every Saturday and Sunday. The project manager's table of activities are noted below.

ID	Activity	Original Duration (days)	Actual Duration (days)	Actual Start Date	Actual Finish Date	% Complete	Original Budget	Actual Budget
10	Site Prep	8	9	2/27	4/26	100	$500,000	$600,000
20	Substructure	12	11	5/1	7/18	100	$1,500,000	$1,350,000
30	Super Substructure	18	-	7/20	-	75	$2,000,000	$1,450,000
40	Exterior	6	-	-	-	0	$400,000	-
50	Interior	14	-	8/31	-	50	$1,800,000	$1,000,000
60	Services	10	-	-	-	0	$1,000,000	-
70	Cleanup	4	-	-	-	0	$200,000

Question 2: Calculate the Planned Value (BCWS) based on the original budget, the original duration, and the number of weeks between the planned early start date and the status date (October 28th for the activities that are in progress. This calculation will provide the amount of money the project has spent up to October 28th?

Activity 30 - Super substructure

Original Budget = $2,000,000

Original Duration = 18 Weeks

Number of Weeks between Planned Start Date and Status State = ______ #Weeks to status date (From Question 1.

BCWS = #Weeks to status date / Original Duration * Original Budget

BCWS = ______________________________

Activity 50 - Interior

Original Budget = $1,800,000

Original Duration = 14 Weeks

Number of Weeks between Planned Start Date and Status State =_______ #Weeks to status date (From Question 1).

BCWS = #Weeks to status date / Original Duration * Original Budget

BCWS = ______________________________

Answer 1

Activity 30 - Super substructure

Original Budget = $2,000,000

Original duration = 18 weeks

Number of weeks between planned start date and status state = 13.5

BCWS = Weeks to status date / Original Duration * Original Budget

BCWS = (13.5/18) X $2,000,000

= $1,500,000

Activity 50 - Interior

Original Budget = $1,800,000

Original Duration = 14 Weeks

Number of weeks between planned start date and status state = 8

BCWS = Weeks to status date / Original Duration * Original Budget

BCWS = (8/14) X $1,800,000

= $1,028,571.43

*If you like the answer, please give it a thumbs-up. It will be highly appreciated*