CID arned Value Management A. Using the plan data in the table below, complete the table by calculating the cumulative planned and cumulative actual monthly budgets through the end of June. Complete the earned value column on the right. Assume the project is planned for a 12-month duration and $250,000 budget. Activity | Jan Feb Mar Apr May Jun Plan % Complete Earned Value Staffing 8 7 Blueprinting Prototype Full Design Construction Transfer Monthly Plan: Cumulative 15 10 10 3 8 10 21 2 30 32 10 10 100% 100% 70% 6796 25% 096 cHint this one is computed for you Total: Monthly Actual: 10 15 6 14 9 40 Cumul. Actual: B. Using the above data, calculate the following values: Schedule Variances Planned Value Earned Value Schedule Performance Index Sheet1