Question

Based on the information provided for a one-year project, answer the following questions.

PV =$100,000     AC =$60,000     BAC=$125,000    ETC = $100,000

1. If 75% of the Planned Value was completed to date, what is the Earned Value of the work completed (round to nearest whole number)?

2. What is the Cost Variance (round to nearest whole number)?

3. What is the Schedule Variance (round to nearest whole number)?

4. What is the Cost Performance Index (round to 2 decimals)?

5. What is the Schedule Performance Index (round to 2 decimals)?

6. How is the project progressing in terms of schedule (ahead, behind or on-schedule) and budget (under, over or on-budget)?

7. If spending remains the same as the current rate to date, what is the Estimate at Completion for this project (round to nearest whole number)?

8. If spending varies from current rate to date, what is the Estimate at Completion for this project (round to nearest whole number)?

9. If spending remains the same as the current rate to date, what is the Variance at Completion (round to nearest whole number)?

10. What is the % of the Project Complete (round to nearest whole %)?

11. What is the % of budget spent (round to nearest whole %)?

12. What is the To-Complete Performance Index required to achieve the original budget plan (round to 2 decimals)?
    
    
13. Is the To-Complete Performance Index required to achieve the original budget plan harder, easier or the same as the efficiency performance to date?

14. What is the To-Complete Performance Index required to achieve the revised budget plan if spending is the same as the current rate to date (round to 2 decimals)?

15. Is the To-Complete Performance Index required to achieve the revised budget plan harder, easier or the same as the efficiency performance to date?

Answer 1

Since you have asked a question with numerous sub parts, I will address first five. Please post the balance sub parts as separate question.

This is a fairly formula driven question. Let's address them one by one.

PV = $100,000 AC = $60,000 BAC = $125,000 ETC = $100,000

===================

If 75% of the Planned Value was completed to date, what is the Earned Value of the work completed (round to nearest whole number)?

EV = % complete x Planned Value = 75% x 100,000 = $75,000

====================

What is the Cost Variance (round to nearest whole number)?

Cost Variance, CV = Earned Value, EV – Actual Cost, AC = 75,000 - 60,000 = $15,000

================

What is the Schedule Variance (round to nearest whole number)?

Schedule Variance, SV = Earned Value, EV – Planned Value, PV = 75,000 - 100,000 = - $ 25,000

================
What is the Cost Performance Index (round to 2 decimals)?

Cost Performance Index, CPI = EV / AC = 75,000 / 60,000 = 1.25

===================
What is the Schedule Performance Index (round to 2 decimals)?

Schedule Performance Index, SPI = EV / PV = 75,000 / 100,000 = 0.75

Please post the balance sub parts as separate question.