Answer Question 3 Instructions You are preparing a status re

Answer Question 3:

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 3 - Calculate the BCWP (Earned Value). This is based on the original budget and the actual work completed for the activities that are in progress. This calculation will provide the budgeted cost of the work completed to date.

Activity 30: Super Sub Structure

Original Budget: = $2,000,000

Actual Percent Complete = 75%

Earned Value = 75% * Original Budget   _____________________

Activity 50: Interior

Original Budget = $1,800,000

Actual Percent Complete = 50%

Earned Value = 50% * Original Budget ______________________

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

Solution

Question 3

BCWP = Original budget * %Complete/100

BCWP (Earned Value) = 500000*100/100 + 1500000*100/100 + 2000000*75/100 + 400000*0 + 1800000*50/100 + 1000000*0 + 200000*0

= $ 4,400,000

Activity 30: Super Sub Structure

Original Budget: = $2,000,000

Actual Percent Complete = 75%

Earned Value = 75% * Original Budget = 75%*2000000 = $ 1,500,000

_____________________

Activity 50: Interior

Original Budget = $1,800,000

Actual Percent Complete = 50%

Earned Value = 50% * Original Budget = 50%*1800000 = $ 900,000

_____________________

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