Table 1 Tasks DB Design System Integration Web Design Win Design & Development Deploy, Test & Maintain Total Cumulative Amounts in thousands of Rands Table 2 Tasks DB Design 6 System Integration Web Design Win Design & Development Deploy, Test & Maintain Total 6 Cumulative Amounts in thousands of Rands TBC 1 2 3 4 5 10 6 4 40 10 10 10 10 70 20 30 20 60 90 270 6 14 10 30 40 50 20 Month 4 14 10 6 14 20 3 2 6 8 Month 6 24 7 8 30 20 10 4 10 14 9 40 40 50 40 2 10 12 10 10 10 10 30 40 Table 3 Tasks 2 3 DB Design 80 100 System Integration 10 20 Web Design Win Design & Development Deploy, Test & Maintain Amounts are cumulative percent complete Table 4 Tasks TBC 1 DB Design System Integration Web Design Win Design & Development Deploy, Test & Maintain Total 1 30 10 40 70 60 90 270 N 3 Month 4 100 30 10 4 5 100 50 15 Month 6 100 80 30 6 7 100 90 45 20 1.1 Using the table 1, what is the cumulative budgeted cost at the end of Month 7? (3) 1.2 Using the table 2, what is the cumulative actual cost at the end of Month 7? Determine whether there is a cost over-run or under-run? Which Month and task might be a problem? (5) 1.3 Using the Table 3 (contains the cumulative percentages worked) above, complete Table 4 with the cumulative earned value of the project at the end of Month 7? (4) Table 4 Month Tasks 5 6 DB Design 10 3 10 10 System Integration 40 20 32 Web Design 70 7 10.5 10.5 Win Design & 60 Development Deploy, Test & 90 Maintain Total 270 3 12 18 29 40.5 52.5 Cumulative 1.4 What is the Cost Performance Index at the end of Month 7? What is your evaluation of the calculated amount? (4) 1.5 What is the Cost Variance? (4) 1.6 What is the Estimate Cost at Completion? What is your evaluation of the calculated amount? (5) TBC 2 3 8 10 4 8 4 10 12 7 10 36 31.5 12 89.5 Table 1 Tasks DB Design System Integration Web Design Win Design & Development Deploy, Test & Maintain Total Cumulative Amounts in thousands of Rands Table 2 Tasks DB Design 6 System Integration Web Design Win Design & Development Deploy, Test & Maintain Total 6 Cumulative Amounts in thousands of Rands TBC 1 2 3 4 5 10 6 4 40 10 10 10 10 70 20 30 20 60 90 270 6 14 10 30 40 50 20 Month 4 14 10 6 14 20 3 2 6 8 Month 6 24 7 8 30 20 10 4 10 14 9 40 40 50 40 2 10 12 10 10 10 10 30 40 Table 3 Tasks 2 3 DB Design 80 100 System Integration 10 20 Web Design Win Design & Development Deploy, Test & Maintain Amounts are cumulative percent complete Table 4 Tasks TBC 1 DB Design System Integration Web Design Win Design & Development Deploy, Test & Maintain Total 1 30 10 40 70 60 90 270 N 3 Month 4 100 30 10 4 5 100 50 15 Month 6 100 80 30 6 7 100 90 45 20 1.1 Using the table 1, what is the cumulative budgeted cost at the end of Month 7? (3) 1.2 Using the table 2, what is the cumulative actual cost at the end of Month 7? Determine whether there is a cost over-run or under-run? Which Month and task might be a problem? (5) 1.3 Using the Table 3 (contains the cumulative percentages worked) above, complete Table 4 with the cumulative earned value of the project at the end of Month 7? (4) Table 4 Month Tasks 5 6 DB Design 10 3 10 10 System Integration 40 20 32 Web Design 70 7 10.5 10.5 Win Design & 60 Development Deploy, Test & 90 Maintain Total 270 3 12 18 29 40.5 52.5 Cumulative 1.4 What is the Cost Performance Index at the end of Month 7? What is your evaluation of the calculated amount? (4) 1.5 What is the Cost Variance? (4) 1.6 What is the Estimate Cost at Completion? What is your evaluation of the calculated amount? (5) TBC 2 3 8 10 4 8 4 10 12 7 10 36 31.5 12 89.5