Using the following data, calculate the planned and actual monthly budgets throu
ID: 2451077 • Letter: U
Question
Using the following data, calculate the planned and actual monthly budgets through the end of June. Assume the project is planned for a 12-month duration and $250,000 budget. All costs are in $000.
Activity
Jan
Feb
Mar
Apr
May
Jun
Plan
% C
Value
Staffing
8
7
15
100
Blueprinting
4
6
10
100
Prototype Devlpmt
2
8
10
70
Full Design
3
8
10
21
67
Construction
2
30
32
25
Transfer
10
10
0
Monthly Plan
Cumulative
Monthly Actual
10
15
6
14
9
40
Cumul. Actual
Using the data from above, calculate the following values (show your work):
Schedule Variances
Planned Value of Work Scheduled (PV)
Earned Value (EV)
Schedule Performance Index (SPI)
Estimated Time to Completion
Cost Variances
Actual Cost of Work Performed (AC)
Earned Value (EV)
Cost Performance Index (CPI)
Estimated Cost to Completion
Activity
Jan
Feb
Mar
Apr
May
Jun
Plan
% C
Value
Staffing
8
7
15
100
Blueprinting
4
6
10
100
Prototype Devlpmt
2
8
10
70
Full Design
3
8
10
21
67
Construction
2
30
32
25
Transfer
10
10
0
Monthly Plan
Cumulative
Monthly Actual
10
15
6
14
9
40
Cumul. Actual
Explanation / Answer
Answer:
Schedule Variances
Planned Value (PV) 88
Earned Value (EV) 54.07
Schedule Performance Index EV/PV = 54.07/88 = .6144
Estimated Time to Completion (1/.6144 x 6) = 9.77 months
Cost Variances
Actual Cost of Work (AC) 94
Earned Value (EV) 54.07
Cost Performance Index EV/AC = 54.07/94 = .5752
Estimated Cost to Completion (1/.5752 x $250,000) = $434631.4325
Activity Jan Feb Mar Apr May Jun Plan % C Value Staffing 8 7 15 100 15 Blueprinting 4 6 10 100 10 Prototype Devlpmt 2 8 10 70 7 Full Design 3 8 10 21 67 14.07 Construction 2 30 32 25 8 Transfer 10 10 0 0 Monthly Plan 8 11 8 11 10 50 98 54.07 Cumulative 8 19 27 38 48 98 Monthly Actual 10 15 6 14 9 40 Cumul. Actual 10 25 31 45 54 94Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.