please show any formulas needed to complete the excel sheet

The table below provides project work activities, precedence relationships, and costs. Activities Regular Immediate Time Predecessors (weeks) none 4 Crash Normal Crash Time Cost Cost (weeks) Estimate Estimate 3 $ 30,250 $ 33,700 10 $ 53,000 $ 58,000 15 $ 60,000 $ 70,000 5 $ 48,000 $ 58,200 A 12 . 19 B ON un D 4 4 $ 38,000 $ 38.000 ID Description A Conceptual design B Preliminary design C Final design D Environmental permit application preparation E Environmental permit review and approval F Building permit application preparation G Building permit review and approval H Property acquisition 1 Bid project Construction start (dummy activity E 2 1 $ 35,000 $37.500 4 4 $ 6,000 $ 6,000 B 20 18 CH 2 4 $ 90,000 $112.000 $ 6.000 $ 6.000 sa $ 0 GU The project will begin with the development of a conceptual design (Activity Al During the conceptual design engineers confirm the applicable regulations and laws for the project including SERLIN As Mr. Andrews simultaneously manages multiple engineering projects like this. he has requested your professional assistance to analyze this project for ways to complete it in 35 weeks. You analysis should include: 1. Project network diagram using normal time for every activity. 2. Project duration and cost. 3. Identification of the critical activities. 4. Incremental cost to complete the project in 35 weeks. Include your Excel file with all calculations