please use excel and mosel/xpress if needed for the question thank you

7. Chest Tech Plc is a small company that have a project to develop a new game product. The project lead have identified activities that will take place during the project. Activity dependen- cies and estimated activity duration and resource requirement are given in the following table. Activity Dependencies Duration Resource (months) usage A 6 2 B 2 2 B 1 5 D A 3 E A,B 6 5 F E 3 G 2 2 Table 1: Project planning information NO - 4 NW 01 W NN CA (a) Draw the project network based on the information in Table 1. (b) Identify any critical activities and estimate the project duration given no restriction on re- source available. (c) Draw the Gantt chart and resource histogram for the project, ignoring resource constraints. (d) Total resource available is eight. Explain how the resource constraints effects your esti- mated completion time for the project? (e) The game designer is also in charge of the art and sound team. He falls sick with a virus for a month, which means that activities A and D are delayed by a month. How will this effect the duration of the project. Marks [18]: 5(a), 2(b), 6(c), 3(d), 2(e)