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

Time \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}