Question: Earned value management dashboard

• Based on the question 2 data, represent the projects earned value status in a visual format.
• Your image need only include your AC, EV, and PV over the four-week project (see example chart at right).
• This chart can be done in Excel (or equivalent), or it can be drawn by hand (and then digitally scanned or photographed, and included in your assignment).

Question 2 Data

\begin{tabular}{|l|l|r|r|r|} \hline Cost Variance (CV) & (EV - AC) & 4050 & 5800 & 9200 \\ \hline Schedule Variance (SV) & EV - PV & 5000 & 500 & 4000 \\ \hline Cost Performance Index & CPI = EV / AC & 2.50 & 1.37 & 1.24 \\ \hline Schedule Performance Index (SPI) & SPI=EV/PV & 0.57 & 0.98 & 1.09 \\ \hline EAC (Estimate at completion) & BAC/CPI & 56000.00 & 102232.56 & 112595.74 \\ \hline ETC (Estimate to complete) & ETC = EAC - AC & 53300.00 & 86532.56 & 74795.74 \\ \hline \end{tabular}