Answer Question 3: Instructions : You are preparing a status report for your pro
ID: 410037 • Letter: A
Question
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
Explanation / Answer
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 0Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.