please solve in excel and show step by step

Q7, (15 points) North West Miramichi Contractors Inc. has hired you as a summer student who is majoring in management sciences during her BBA degree program. Going into your third year of study in September, you are excited to be getting relevant work experience in 2021. The following table provides the information necessary for you to construct a project network and project crash data. Activity Activity Time (weeks) Cost ($) Activity Activity Normal Crash Normal Crash Predecessor 20 8 1000 1480 W N - 24 20 1200 1400 14 7 700 1190 1 10 6 500 820 3 11 5 550 730 Your initial assignment is to begin a project management with the following tasks. a. Construct a project model. b. What is the normal project completion time and cost? c. Construct a linear programming model to determine which activities should be crashed to achieve the following deadlines and determine the total project cost including crash costs. Project Crash A? Crash B? Crash C? Crash D? Crash E? Total completion project cost time(day) 20 24 25 26