Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use MS Project to solve this Earned Value Analysis . The following data have been collected for a British healthcare IT project for two-week reporting
Use MS Project to solve this Earned Value Analysis
.
The following data have been collected for a British healthcare IT project for two-week reporting periods 2 through 12 . Compute the SV, CV, SPI, and CPI for each period. \begin{tabular}{lcccccc} \hline Status Report: Ending Perlod 2 & & & \multicolumn{2}{c}{ (\$00) } \\ Task & % Complete & EV & AC & PV & CV & SV \\ 1 & 50% & - & 4 & - & - & - \\ Cumulatlve Totals & & - & 4 & - & - & - \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Status Report: Ending Perlod 4} & \multicolumn{2}{|c|}{($00)} \\ \hline Task & \%Complete & EV & AC & PV & cV & Sv \\ \hline 1 & Finished & - & 10 & - & - & - \\ \hline \multicolumn{2}{|c|}{ Cumulatlve Totals } & - & 10 & - & - & - \\ \hline \multicolumn{5}{|c|}{ Status Report: Ending Perlod 6} & \multicolumn{2}{|c|}{($00)} \\ \hline Task & \%Complete & EV & AC & PV & CV & sv \\ \hline 1 & Finished & - & 10 & - & - & - \\ \hline 2 & 25% & & 15 & - & - & - \\ \hline 3 & 33% & - & 12 & - & - & - \\ \hline 4 & 0% & & 0 & - & - & - \\ \hline \multicolumn{2}{|c|}{ Cumulative Totals } & - & 37 & - & & - \\ \hline \multicolumn{5}{|c|}{ Status Report: Ending Perlod 8} & \multicolumn{2}{|c|}{($00)} \\ \hline Task & \%Complete & EV & AC & PV & cV & sv \\ \hline 1 & Finished & - & 10 & - & - & - \\ \hline 2 & 30% & - & 20 & - & - & - \\ \hline 3 & 60% & - & 25 & - & - & - \\ \hline 4 & 0% & - & 0 & - & - & - \\ \hline Cumul & & - & 55 & - & - & - \\ \hline \multicolumn{5}{|c|}{ Status Report: Ending Perlod 10} & \multicolumn{2}{|c|}{($00)} \\ \hline Task & \%Complete & EV & AC & PV & CV & sv \\ \hline 1 & Finished & - & 10 & - & - & - \\ \hline 2 & 60% & - & 30 & - & - & - \\ \hline 3 & Finished & - & 40 & - & - & - \\ \hline 4 & 50% & - & 20 & - & - & - \\ \hline 5 & 0% & - & 0 & - & - & - \\ \hline 6 & 30% & - & 24 & - & - & - \\ \hline Cumul & & - & 124 & - & - & - \\ \hline \multicolumn{5}{|c|}{ Status Report: Ending Perlod 12} & \multicolumn{2}{|c|}{($00)} \\ \hline Task & \%Complete & EV & AC & PV & CV & sv \\ \hline 1 & Finished & - & 10 & - & - & - \\ \hline 2 & Finished & - & 50 & - & - & - \\ \hline 3 & Finished & - & 40 & - & - & - \\ \hline 4 & Finished & - & 40 & - & - & \\ \hline 5 & 50% & - & 30 & - & - & - \\ \hline 6 & 50% & & 40 & - & - & - \\ \hline Cumul & & - & 210 & - & - & \\ \hline \end{tabular} The following data have been collected for a British healthcare IT project for two-week reporting periods 2 through 12 . Compute the SV, CV, SPI, and CPI for each period. \begin{tabular}{lcccccc} \hline Status Report: Ending Perlod 2 & & & \multicolumn{2}{c}{ (\$00) } \\ Task & % Complete & EV & AC & PV & CV & SV \\ 1 & 50% & - & 4 & - & - & - \\ Cumulatlve Totals & & - & 4 & - & - & - \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Status Report: Ending Perlod 4} & \multicolumn{2}{|c|}{($00)} \\ \hline Task & \%Complete & EV & AC & PV & cV & Sv \\ \hline 1 & Finished & - & 10 & - & - & - \\ \hline \multicolumn{2}{|c|}{ Cumulatlve Totals } & - & 10 & - & - & - \\ \hline \multicolumn{5}{|c|}{ Status Report: Ending Perlod 6} & \multicolumn{2}{|c|}{($00)} \\ \hline Task & \%Complete & EV & AC & PV & CV & sv \\ \hline 1 & Finished & - & 10 & - & - & - \\ \hline 2 & 25% & & 15 & - & - & - \\ \hline 3 & 33% & - & 12 & - & - & - \\ \hline 4 & 0% & & 0 & - & - & - \\ \hline \multicolumn{2}{|c|}{ Cumulative Totals } & - & 37 & - & & - \\ \hline \multicolumn{5}{|c|}{ Status Report: Ending Perlod 8} & \multicolumn{2}{|c|}{($00)} \\ \hline Task & \%Complete & EV & AC & PV & cV & sv \\ \hline 1 & Finished & - & 10 & - & - & - \\ \hline 2 & 30% & - & 20 & - & - & - \\ \hline 3 & 60% & - & 25 & - & - & - \\ \hline 4 & 0% & - & 0 & - & - & - \\ \hline Cumul & & - & 55 & - & - & - \\ \hline \multicolumn{5}{|c|}{ Status Report: Ending Perlod 10} & \multicolumn{2}{|c|}{($00)} \\ \hline Task & \%Complete & EV & AC & PV & CV & sv \\ \hline 1 & Finished & - & 10 & - & - & - \\ \hline 2 & 60% & - & 30 & - & - & - \\ \hline 3 & Finished & - & 40 & - & - & - \\ \hline 4 & 50% & - & 20 & - & - & - \\ \hline 5 & 0% & - & 0 & - & - & - \\ \hline 6 & 30% & - & 24 & - & - & - \\ \hline Cumul & & - & 124 & - & - & - \\ \hline \multicolumn{5}{|c|}{ Status Report: Ending Perlod 12} & \multicolumn{2}{|c|}{($00)} \\ \hline Task & \%Complete & EV & AC & PV & CV & sv \\ \hline 1 & Finished & - & 10 & - & - & - \\ \hline 2 & Finished & - & 50 & - & - & - \\ \hline 3 & Finished & - & 40 & - & - & - \\ \hline 4 & Finished & - & 40 & - & - & \\ \hline 5 & 50% & - & 30 & - & - & - \\ \hline 6 & 50% & & 40 & - & - & - \\ \hline Cumul & & - & 210 & - & - & \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started