Please use formulas for all calculations Data by period 1 2 3 4 Period Baseline EV PV AC EV Data Budget PV AC EV PV AC EV PV AC EV PV AC 0 0 0 0 0 5 5 5 5 0 0 0 0 WP2 15 10 8 11 5 0 0 0 0 0 WP 15 0 0 0 15 17 15 7 0 0 WP4 30 0 0 0 0 0 0 25 24 23 5 4 0 0 0 0 0 30 30 30 10 8 10 0 0 0 WP5 40 0 0 0 0 0 4 WP6 5 0 0 Calculate the Period PV, AC, EV and the CV and SV. Also, calculate the Project(Cumulative) PV, AC, EV and the CV, CPI, SV and SPI. Comment on the Status for the period and the Project. Period info CV SV Status Cumulative info CV CPI SV SPI Status What is the % complete of WP1 and WP2 at the end of period 1? WP1 WP2 What is the % complete of the Total Project at the end of Period 1.Student Name & ID Student Name & ID Please use formulas for all calculations Cumulative Period 2 3 4 5 6 7 8 9 10 PV $10 $20 $30 $60 $120 $240 $300 $340 $360 $380 AC $8 $19 $31 $66 $120 $235 $310 $350 $365 $385 EV $9 $20 $30 $65 $110 $225 $280 $330 $355 $375 CV CPI SV SPI Project Status Budget Surplus/Deficit/On Schedule: Ahead/Behind/On