Earned Value Management: Given the following information for a one-year project, answer the following questions. Recall that PV is the planned value, EV is the earned value, AC is the actual cost, and BAC is the budget at completion. PV=$77,000 EV=$61,000 AC=$49,000 BAC=$119,000

show how to do it in excel. What is the cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for this project? How is the project doing? Is it ahead of schedule or behind schedule? Is it under budget or over budget? Use the CPI to calculate the estimate at completion (EAC) for this project. Is the project performing better or worse than planned? Use the schedule performance index (SPI) to estimate how long it will take to finish this project. Apply what you've read about planning for the unexpected and include two hypothetical scenarios that could a) reduce costs or b) reduce time.