PLEASE SEND ANSWERS IN EXCEL,

QUESTION 1 Table 1: Project activities, times and costs Activity Immediate Normal Predecessor(s) Time (weeks) none 10 B none 4 C AB 6 D 7 E B 14 F C, D, E 3 G F 4 H F 2 F 5 J HI 2 K J 5 L K 10 Normal Cost (R) 16,000 6,000 12,000 7,000 28,000 4,500 7,200 5,000 15,000 7,000 10,000 24,000 Crash Time (weeks) 8 3 3 5 12 3 3 2 4 2 4 10 Crash Cost (R) 20,000 9,000 24,000 10,000 34,000 4,500 9,000 5,000 18,000 7,000 11,000 24,000 1.1 Use the data from table 1 to draw the network diagram. 1.2 Determine the normal time it will take to complete this project. 1.3 Determine the critical path for the project. 1.4 Calculate the cost of completing the project in normal time. 1.5 Determine the absolute minimum time it will take to complete the project if the project is crashed as far as possible. 1.6 Calculate the cost associated with this approach to the project. 1.7 If the company wants to complete the project in 40 weeks, which activities should be crashed? 1.8 Calculate the additional cost incurred to complete the project in 40 weeks