Use MS Project to solve this Earned Value Analysis.

After 6 time periods the project is roughly 66% complete and so far work on the project has taken 1,600 hours less work than planned. There is 400 hours worth of work on Activity 4 which was suppose to have been done that has not done. Since Activity 4 is on the critical path, the project is behind schedule. If schedule is the number priority, the project manager may want to consider investing some of the savings on accelerating critical activities. The following labor hours data have been collected for a nanotechnology project for periods 1 through 6 . Compute the SV, CV, SPI, and CPI for each period. Determine the CPI and SPI for each period \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ Schedule information } & \multicolumn{14}{|c|}{ Baseline budget needs-labor hours (00)} \\ \hline \multirow{2}{*}{\begin{tabular}{l} ACT/ \\ WP \end{tabular}} & \multirow[t]{2}{*}{ DUR } & \multirow[t]{2}{*}{ ES } & \multirow[t]{2}{*}{ LF } & \multirow[t]{2}{*}{ SL } & \multirow{2}{*}{\begin{tabular}{l} Total \\ PV \end{tabular}} & \multicolumn{14}{|c|}{ Time period } \\ \hline & & & & & & & & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10 & 11 & 12 & 314 \\ \hline 1 & 2 & 0 & 2 & 0 & 20 & 10 & 10 & & & & & & & & & & & & \\ \hline 2 & 2 & 2 & 7 & 3 & 24 & & & 16 & 8 & & & & & & & & & & \\ \hline 3 & 6 & 2 & 11 & 3 & 30 & & & 5 & 5 & 10 & 3 & 2 & 5 & & & & & & \\ \hline 4 & 5 & 2 & 7 & 0 & 25 & & & 10 & 10 & 2 & 2 & 1 & & & & & & & \\ \hline 5 & 4 & 4 & 11 & 3 & 16 & & & & & 4 & 4 & 4 & 4 & & & & & & \\ \hline 6 & 4 & 7 & 11 & 0 & 20 & & & & & & & & 5 & 5 & 6 & 4 & & & \\ \hline 7 & 2 & 11 & 13 & 0 & 10 & & & & & & & & & & & & 5 & 5 & \\ \hline & & & & PVB & period & 10 & 10 & 31 & 23 & 16 & 9 & 7 & 14 & 5 & 6 & 4 & 5 & 5 & \\ \hline & & & mula & PV b & period & 10 & 20 & 51 & 74 & 90 & 99 & 106 & 120 & 125 & 131 & 135 & 140 & 145 & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Status Report: Ending Perlod 1} \\ \hline Task & \%Complete & EV & AC & PV & CV & sv \\ \hline 1 & 50% & - & 500 & 1000 & & \\ \hline Cumulative Totals & & - & 500 & 1000 & & - \\ \hline \multicolumn{7}{|c|}{ Status Report: Ending Perlod 2} \\ \hline Task & \%Complete & EV & AC & PV & CV & sv \\ \hline 1 & Finished & - & 1500 & 2000 & & - \\ \hline Cumulatlve Totals & & - & 1500 & 2000 & & - \\ \hline \multicolumn{7}{|c|}{ Status Report: Ending Perlod 3} \\ \hline Task & \%Complete & EV & AC & PV & CV & sv \\ \hline 1 & Finished & 2000 & 1500 & 2000 & & \\ \hline 2 & 0% & - & 0 & - & & \\ \hline 3 & 10% & - & 200 & - & - & \\ \hline 4 & 20% & - & 500 & & & - \\ \hline Cumulatlve Totals & & - & 2200 & & & - \\ \hline \multicolumn{7}{|c|}{ Status Report: Ending Perlod 4} \\ \hline Task & \%Complete & EV & AC & PV & cv & sv \\ \hline 1 & Finished & 2000 & 1500 & 2000 & & - \\ \hline 2 & 50% & - & 1000 & - & & \\ \hline 3 & 30% & - & 800 & - & & - \\ \hline 4 & 40% & - & 1500 & & & \\ \hline Cumulative Totals & & - & 4800 & - & & - \\ \hline \multicolumn{7}{|c|}{ Status Report: Ending Perlod 5} \\ \hline Task & \%Complete & EV & AC & PV & cV & sv \\ \hline 1 & Finished & 2000 & 1500 & 2000 & & \\ \hline 2 & Finished & - & 2000 & - & & - \\ \hline 3 & 50% & - & 800 & & & \\ \hline 4 & 60% & - & 1500 & & & \\ \hline 5 & 25% & - & 400 & & & - \\ \hline Cumulative Totals & & - & 6200 & - & - & - \\ \hline \multicolumn{7}{|c|}{ Status Report: Ending Perlod 6} \\ \hline Task & \%Complete & EV & AC & PV & cV & sv \\ \hline 1 & Finished & 2000 & 1500 & 2000 & & \\ \hline 2 & Finished & - & 2000 & - & & \\ \hline 3 & 80% & - & 2100 & & & \\ \hline 4 & 80% & & 1800 & & & \\ \hline 5 & 50% & - & 600 & - & & - \\ \hline Cumulative Totals & & - & 8000 & & & \\ \hline \end{tabular}