Question: Question 3 Consider the following data for an 8-month project. At present, 4 months have elapsed since the project started. Budgeted Costs (Rs. '000) Month
Question 3 Consider the following data for an 8-month project. At present, 4 months have elapsed since the project started. Budgeted Costs (Rs. '000) Month 3 4 5 6 7 1 65 8 Activity A B 2 210 280 145 820 205 TBC 275 1,100 565 1,000 1,190 315 4,445 D 215 250 190 250 250 370 E F 250 630 40 920 3,920 60 Total Cumulative 65 65 635 700 1,475 2,175 825 3,000 310 4,230 95 95 4,325 120 120 4,445 Actual Costs (Rs. '000) Month Activity 1 2 3 4 A 52 191 B 484 142 218 197 D 240 E 186 F 72 Total 52 817 458 +X 695 Cumulative 52 869 1,327 + 2,022 + x Progress Report (Cumulative % Complete) Month Activity 1 2 3 4 A 20 90 100 100 B 40 100 C 30 55 70 D 25 50 E Y F 10 100 240 Notes: X = the last 3 digits of your SAP ID (e.g. if your SAP ID is 12345, then X = 345) Y = the last 2 digits of your SAP ID (e.g. if your SAP ID is 12345, then Y = 45) Using the information presented in the tables above, calculate the following at the end of month 4: (a) PV, AC, and EV for the overall project. (2 marks) (b) CV, SV, CPI, SPI, and CSI for the overall project. Interpret your answers. (4 marks) Furthermore, you are required to: (c) Conduct a variance analysis of the activities and identify the activity that is the most significant contributor to the project's variance. (4 marks) Question 3 Consider the following data for an 8-month project. At present, 4 months have elapsed since the project started. Budgeted Costs (Rs. '000) Month 3 4 5 6 7 1 65 8 Activity A B 2 210 280 145 820 205 TBC 275 1,100 565 1,000 1,190 315 4,445 D 215 250 190 250 250 370 E F 250 630 40 920 3,920 60 Total Cumulative 65 65 635 700 1,475 2,175 825 3,000 310 4,230 95 95 4,325 120 120 4,445 Actual Costs (Rs. '000) Month Activity 1 2 3 4 A 52 191 B 484 142 218 197 D 240 E 186 F 72 Total 52 817 458 +X 695 Cumulative 52 869 1,327 + 2,022 + x Progress Report (Cumulative % Complete) Month Activity 1 2 3 4 A 20 90 100 100 B 40 100 C 30 55 70 D 25 50 E Y F 10 100 240 Notes: X = the last 3 digits of your SAP ID (e.g. if your SAP ID is 12345, then X = 345) Y = the last 2 digits of your SAP ID (e.g. if your SAP ID is 12345, then Y = 45) Using the information presented in the tables above, calculate the following at the end of month 4: (a) PV, AC, and EV for the overall project. (2 marks) (b) CV, SV, CPI, SPI, and CSI for the overall project. Interpret your answers. (4 marks) Furthermore, you are required to: (c) Conduct a variance analysis of the activities and identify the activity that is the most significant contributor to the project's variance. (4 marks)
Study Help