Note: Fill up the table on this question sheet and do a remaining portion at the back of the question paper. CLO 4 Using the 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. (02 Marks). Assume that the project is planned for an 8- month duration and a $ 195,000 budget. Feb Mar Apr May Jun Plan Value Jan 10 8 18 6 4 7 Activity Staffing Blueprinting Prototype dev. Full Design Construction Transfer Monthly Plan Cumulative Monthly Actual Cumulative Actual 5 5 % Comp 90 100 80 60 50 12 8 10 12 25 20 15 8 12 15 0 12 15 9 13 20 30 After calculating all the missing information as asked in the above table, calculate the following as well. (04 Marks) 1. Schedule variances a) Planned value (PV) b) Earned Value (EV) c) Schedule Performance Index (SPI) d) Estimated Time to Completion Grading Criteria: complete the table 02 Schedule variances 04 Cost variances 04 2. Cost Variances (04 Marks) a) Actual Cost of Work Performed (AC) b) Earned Value (EV) c) Cost Performance Index (CPI) d) Estimated Cost of Completion