Be sure to show all calculations, preferably in an EXCEL file. Each problem is of equal value. Each part of a problem is equal.

Problem 2.A project has just completed its 87^th item in the project plan. It was scheduled to have spent $300,000at this point in the plan, but has actually spent only $250,000. The project manager estimates that the value of the work actually finished is nearly $200,000. What are the spending and schedule variances for the project? What are the SPI and CPI? What is the Critical Ratio?

1. CV =
2. SV =
3. SPI =
4. CPI =
5. CR =