The data presented below and on the following pages have been collected for the Solar project for periods 1 though 5. The completed network diagram is given. Enter the missing network values into the baseline table below and calculate the cumulative baseline for the project. Complete the status report tables given for periods 1-5. Compute the CPI, SPI, and PCIB values in the table given. Calculate the EAC & TCPI in the space provided and plot the EV, PV and AC values on the summary graph provided. Make your project status report on the final page, providing the information and analysis requested. Network Diagram: 2 B5 2 2 4 3 7 0 A 2 2 C 7 7 E 10 10 G 12 0 0 0 0 0 0 0 0 0 2 2 2 5 7 3 10 10 2 12 7 2 D 6 6 F 7 1 1 Budget Rules: 1 = % Complete 3 4 7 2=50/50 3=0/100 3 3 9 1 10 Baseline Time-Phased Budget Calculation Table (to be completed): Budget Work Task Early Late Rule Package Duration Start Finish Slack Planned 0 1 2 3 4 5 6 7 8 9 10 11 12 Value 1 A 2 0 20 20 10 10 1 B 3 2 7 2 9 3 3 3 2 C 5 2 7 0 20 3 D 4 2 7 1 20 10000 10 00020 2 E 30 1 F 10 3 G 30 Total PV by period Cumulative PV by period Status Reports (to be completed): Status Report: Ending Period 1 Task A %Complete 20% Cumulative Totals EV = % of original budget earned; CV = EV-AC; SV = EV - PV EV AC PV CV SV 6 Status Report: Ending Period 2 Task A %Complete 80% EV Cumulative Totals Status Report: Ending Period 3 SPI = EV/PV; CPI = EV/AC; PCIB = EV/BAC Period SPI CPI PCIB 1 2 3 AC PV CV SV 4 18 5 Task %Complete EV AC PV 2 A 100% 18 B 33.3% 5 20% 10 D 30% 6 Cumulative Totals Status Report: Ending Period 4 Task %Complete A 100% B 66.7% 50% D 60% CV SV EV AC PV CV SV 18 9 11 12 Cumulative Totals Status Report: Ending Period 5 Task % Complete EV AC PV CV SV A 100% 18 B 100% 14 80% 22 D 100% 18 Cumulative Totals EACf: (Show Calculations) TCPI: (Show Calculations) Summary Graph (EV, AC & PV) 140 Dollars 130 120 110 100 90 80 70 60 50 40 30 20 10 0 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Time Periods How has the project progressed through Period 5? Address total variances and indexes for each period. Address task performance by period using variances. Address schedule of critical tasks completed and/or in progress (i.e., is the critical path on schedule?). Finally, give an overall summary of the project performance and its current completion status in a single sentence. (Use an extra sheet if needed). Comment on the EAC & TCPI values in relation to project completion: