QUESTION 3 (weight 20%) A road construction project that consists of 6 activities is planned to be completed within 14 weeks. The project has a budget based on the following estimated costs. Assume that costs are linear for each activity. Activities Estimated costs Measuring Blasting Filling of gravel and flattening Asphalt spreading Install light and crash barriers Install signposts and finish 20 000 160 000 200 000 160 000 40 000 10 000 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Activity/week Measuring Blasting Filling of gravel and flattening Asphalt spreading Install light and crash barriers Install signposts and finish a) Develop a table where you summarize total cost for each week and calculate accumulated cost. What is the total planned cost for this project (the budget)? b) Find/calculate PC, AC, EV, CV, BV, SV, CPI and SPI and comment the development: i. ii. After 3 weeks: Measuring is finished, and Blasting can start. Actual cost so far is 25 000. After 6 weeks: 50% of the Blasting activity is completed. Actual cost for this work is 100 000. After 9 weeks: Blasting is finished, 50% of Filling of gravel and flattening is completed and Install light and crash barriers is finished. Actual cost for all the completed work is now 350 000