1. Use the following table to calculate project schedule variance based on the units listed. (Figures are in thousands.)
Schedule Variance Work Units
A |
B |
C |
D |
E |
F |
Total |
|
Planned Value |
20 |
15 |
10 |
25 |
20 |
20 |
110 |
Earned Value |
10 |
10 |
10 |
20 |
25 |
25 |
|
Schedule variance |
|
|
|
|
|
|
|
2. Using the data in the table below, complete the table by calculating the cumulative planned and cumulative actual monthly budgets through the end of June. Complete the earned value column on the right. Assume the project is planned for a 12-month duration and $250,000 budget.
Activity Jan Feb Mar Apr May Jun Plan % C Value
Staffing 8 7 15 100
Blueprinting 4 6 10 100
Prototype
Development 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
3. Using the data from Problem 2, calculate the following values:
Schedule Variances
Planned Value (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