Microsoft Project

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                                                           

 

 

 

Leave a Reply