X13-7 (Algo) The following data have been collected... he following data have been collected for a British health care IT project for two-week reporting periods 2 through 12 . Compute the V,CV,SPI,CPI, and PClB for each period. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{18}{|c|}{\begin{tabular}{c} Baseline (PV) \\ ($00) \end{tabular}} & \\ \hline Task & DUR & ES & LF & SL & \begin{tabular}{c} PV \\ ($00) \end{tabular} & & 2 & 4 & 6 & 8 & 10 & 12 & 214 & 1416 & 161 & 182 & 20 & 22 \\ \hline 1 & 4 & 0 & 4 & 0 & 8 & 4 & 4 & & & & & & & & & & & \\ \hline 2 & 8 & 4 & 14 & 2 & 40 & & & 10 & 10 & 10 & \begin{tabular}{l|l} 0 & 1 \end{tabular} & 10 & & & & & & \\ \hline 3 & 6 & 4 & 10 & 0 & 30 & & & 10 & 15 & 5 & 5 & & & & & & & \\ \hline 4 & 4 & 4 & 10 & 2 & 20 & & & 10 & 10 & & & & & & & & & \\ \hline 5 & 4 & 10 & 14 & 0 & 40 & & & & & & & 20 & 20 & & & & & \\ \hline 6 & 8 & 8 & 18 & 2 & 60 & & & & & 20 & & 20 & 10 & 10 & & & & \\ \hline 7 & 4 & 14 & 18 & 0 & 20 & & & & & & & & & 10 & 10 & & & \\ \hline 8 & 4 & 18 & 22 & 0 & 30 & & & & & & & & & & & 20 & 10 & \\ \hline \multicolumn{6}{|c|}{ Period PV total } & 4 & 4 & 30 & 35 & \begin{tabular}{l|l} 5 & 35 \\ \end{tabular} & & 50 & 30 & 20 & 10 & 20 & 10 & \\ \hline \multicolumn{6}{|c|}{ Cumulative PV total } & 4 & 8 & 38 & 73 & \begin{tabular}{l|l} 3 & 10 \\ \end{tabular} & & \begin{tabular}{l|l} 158 & 1 \\ \end{tabular} & 188 & 208 & 218 & 238 & 3248 & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ End of Period 2} \\ \hline Task & \begin{tabular}{l} Actual % \\ Complete \end{tabular} & EV & AC & PV & CV & SV \\ \hline 1 & 45 & 3.60 & 3.00 & 3.00x & 0.60 & 0.60 \\ \hline \begin{tabular}{l} Cumulative \\ Totals \end{tabular} & & 3.60 & 3.00 & 3.00 & 0.60 & 0.60x \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|l|}{ End of Period 4} \\ \hline Task & Actual % Complete & EV & AC & PV & CV & SV \\ \hline 1 & 100 & 8.000 & 11.00 & 8.000 & (3.00) & 0.00 \\ \hline Cumulative Totals & & 8.000 & 11.000 & 8.000 & (3.00) & 0.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|l|}{\begin{tabular}{l} End of Period \\ 6 \end{tabular}} \\ \hline Task & \begin{tabular}{l} Actual \% \\ Complete \end{tabular} & EV & AC & PV & CV & SV \\ \hline 1 & 100 & 8.000 & 11.00 & 8.000 & (3.00) & 0.00 \\ \hline 2 & 30 & 9.00x & 15.00 & 9.00x & (6.00) & 0.00x \\ \hline 3 & 25 & 10.00x & 13.00 & 9.00x & (2.00) & (1.00)X \\ \hline 4 & 0 & 0.000 & 0.00 & 9.00x & 0.000 & (9.00) \\ \hline Cumulative & & 27.00 & 39.00 & 35.00x & (11.00) & (10.00)x \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|l|}{\begin{tabular}{l} End of Period \\ 8 \end{tabular}} \\ \hline Task & \begin{tabular}{l} Actual % \\ Complete \end{tabular} & EV & AC & PV & CV & SV \\ \hline 1 & 100 & 8.000 & 11.00 & 8.00 & (3.00) & 0.00 \\ \hline 2 & 30 & 14.00 & 18.00 & 18.00 & (4.00) & (4.00) \\ \hline 3 & 70 & 16.00 & 20.00 & 20.00x & (4.00)x & (4.00) \\ \hline 4 & 0 & 0.000 & 0.00 & 20.00 & 0.000 & (20.00) \\ \hline \begin{tabular}{l} Cumulative \\ Totals \end{tabular} & & 38.00x & 49.00 & 66.00x & (11.00)x & (28.00) \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|l|}{\begin{tabular}{l} End of Period \\ 10 \end{tabular}} \\ \hline Task & \begin{tabular}{l} Actual % \\ Complete \end{tabular} & EV & AC & PV & CV & SV \\ \hline 1 & 100 & 8.00 & 11.00 & 8.00 & (3.00) & 0.008 \\ \hline 2 & 70 & 28.00 & 35.00 & 30.00 & 3.00x & (2.00) \\ \hline 3 & 100 & 30.000 & 35.00 & 30.000 & (10.00)x & 0.008 \\ \hline 4 & 45 & 9.000 & 21.00 & 20.000 & (13.00) & 11.00x \\ \hline 5 & 0 & 0.00 & 0.00 & 0.00 & 0.00 & 0.00 \\ \hline 6 & 35 & 75.00 & 23.00 & 108.00x & (28.00) & (13.00) \\ \hline \begin{tabular}{l} Cumulative \\ Totals \end{tabular} & & 150.00x & 150.00x & 196.00 & (51.00)x & (4.00) \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|l|}{\begin{tabular}{l} End of Period \\ 12 \end{tabular}} \\ \hline Task & Actual \% Complete & EV & AC & PV & CV & SV \\ \hline 1 & 100 & 8.000 & 11.00 & 8.000 & (3.00) & 0.00 \\ \hline 2 & 100 & 40.00 & 50.00 & 40.00 & (10.00) & 0.00 \\ \hline 3 & 100 & 30.00 & 40.00 & 30.00 & (10.00) & 0.000 \\ \hline 4 & 100 & 20.000 & 40.00 & 20.00 & (20.00) & 0.000 \\ \hline 5 & 50 & 30.00 & 25.00 & 20.00 & (10.00) & (10.00) \\ \hline 6 & 40 & 24.00 & 35.00 & 40.00 & (11.00) & (16.00) \\ \hline \begin{tabular}{|l|} Cumulative \\ Totals \\ \end{tabular} & & 152.00x & 201.00 & 158.00 & (42.00) & (26.00)x \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Performance Indexes Summary } \\ \hline Period & EV & AC & PV & SPI & CPI & PClB \\ \hline 2 & 3.60 & 3.00 & 3.00 & 1.20x & 1.20 & 0.02 \\ \hline 4 & 8.00 & 11.00 & 8.00 & 1.000 & 0.72 & 0.02 \\ \hline 6 & 27.00 & 39.00 & 35.00x & 0.77 & 0.69 & 0.12 \\ \hline 8 & 38.00 & 49.00 & 66.00 & 0.57 & 0.77 & 0.11 \\ \hline 10 & 35.00 & 23.00 & 108.00 & 0.32 & 1.52 & 0.22 \\ \hline 12 & 150.00 & 201.00 & 158.00 & 0.94 & 0.74 & 0.42x \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Performance Indexes Summary } \\ \hline Period & EV & AC & PV & SPI & CPI & PCI-B \\ \hline 2 & 3.60 & 3.00 & 3.00x & 1.20x & 1.20 & 0.02 \\ \hline 4 & 8.00 & 11.00 & 8.00 & 1.00 & 0.72 & 0.02 \\ \hline 6 & 27.00 & 39.00 & 35.00 & 0.77 & 0.69 & 0.12 \\ \hline 8 & 38.00 & 49.00 & 66.00 & 0.57 & 0.77 & 0.11 \\ \hline 10 & 35.00 & 23.00x & 108.00 & 0.32 & 1.52 & 0.22 \\ \hline 12 & 150.00x & 201.00 & 158.00 & 0.94 & 0.74 & 0.42 \\ \hline \end{tabular} EACf =474.39 VACf =(133.39)