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

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?

a.CV =

b.SV =

c.SPI =

d.CPI =

e.CR =