The following data have been collected for a British healthcare IT project for 2-week reporting periods 2 through 12. Compute the SV, CV, SPI, and CPI for each period. Plot the EV and the AC on the summary Excel worksheet provided. Plot the SPI, CPI, and PCIB on the same plot with the EV and AC. But do so on a secondary axis you create. What is your assessment of the project at the end of period 12? Choose 2 of these 4 responses: On time / Late / Under budget / Over budget.

2 12 14 18 2 14 14 18 10 10 5 14 18 8 22 0 0 0 4 10 10 4 14 4 22 4 G 16 2 TIN 10 10 B 18 ES ID EF LS DUR LF Schedule Information Baseline PV ($00) Total Planned Value Planned Value up to the end of the Time period below Activity / Work Package Duration Earliest Start Latest Finish Slack ($00) 2 4 6 8 10 12 14 16 18 20 22 4 0 4 A A 8 4 14 40 10 10 10 10 6 4 10 30 10 15 5 4 4 10 2 20 10 10 4 10 14 0 40 20 20 18 60 20 20 10 10 14 18 20 10 10 18 22 30 20 10 Total PV by period 4 4 30 35 35 50 30 20 10 20 10 Cummulative PV by period 4 8 3.8 73 108 158 188 208 218 238 248Status Report: Ending Period 2 Task % Complete EV AC PV CV 50 SV CPI 4 SPI Cumulative totals A Status Report: Ending Period 4 Task % Complete EV 1 AC PV 100 CV SV CPI SPI Cumulative totals 10 10 Status Report: Ending Period 6 Task % Complete EV AC PV 1 CV 100 SV CPI 10 SPI 2 25 3 15 33 12 0 Cumulative totals 37 Status Report: Ending Period 8 Task % Complete EV AC 1 PV CV 100 SV CPI SPI 10 2 30 3 20 60 A 25 0 0 Cumulative totals 55 Status Report: Ending Period 10 Task % Complete EV 1 AC PV CV 100 SV CPI 10 SPI 2 60 30 3 100 40 4 50 5 20 0 6 0 30 24 Cumulative totals 124 Status Report: Ending Period 12 Task % Complete EV AC 1 PV CV 100 SV CPI 10 SPI 2 100 50 3 100 40 4 100 5 40 50 30 50 40 Cumulative totals 210\f\f