Home / Questions / In the Microsoft Excel, add a new worksheet called Earned Value with the exception of the ...

In the Microsoft Excel, add a new worksheet called Earned Value with the exception of the following Instead of BAC $200000 use the total project cost for your project.Instead of

In the Microsoft Excel, add a new worksheet called “Earned Value.” with the exception of the following:Instead of BAC=$200,000, use the total project cost for your project.Instead of PV=$100,000, use the Week 16 Cumulative Cost from your Project Cash Flow Report generated above.Assume that you have completed three months of the project. The BAC was $200,000 for this six-month project. You can also make the following assumptions:PV ¼ $120,000EV ¼ $100,000AC ¼ $90,000a. What is the cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for the project?b. How is the project doing? Is it ahead of schedule or behind schedule? Is it under budget or over budget?c. Use the CPI to calculate the estimate at completion (EAC) for this project. Is the project performing better or worse than planned?d. Use the SPI to estimate how long it will take to finish this project.e. Sketch an earned value chart using the preceding information. See Figure 7-5 as a guide.Term FormulaEarned value (EV) EV ¼ PV to date * RPCost variance (CV) CV ¼ EV _ ACSchedule variance (SV) SV ¼ EV _ PVCost performance index (CPI) CPI ¼ EV/ACSchedule performance index (SPI) SPI ¼ EV/PVEstimate at completion (EAC) EAC ¼ BAC/CPIEstimated time to complete Original time estimate/SPI

Aug 09 2020 Read more Less More

Answer (Solved)

question Subscribe To Get Solution

Recent Questions

Chat Now

Welcome to Live Chat

Welcome to MyCourseHelp Services, World's leading Academic solutions provider with Millions of Happy Students.

Please fill in the form