Question 8 4 points Save Answer (For this question you MUST show your work on Excel to get points) The following provides information about a project, including a list of activities and precedence relationships, activity durations (normal and "crash" times), direct activity costs (normal and "crash"), indirect costs for the project, as well as calculated crash costs/day and the maximum amount that each activity can be shortened (crashed) by. There are no penalty costs for this project. Total project cost (using normal times), a network diagram, and the four paths and durations have also been provided. Your job is to "crash" the project to find the minimum cost schedule. Please provide: The new project duration in days The new project cost $ (Please enter only the amount, without commas or dollar sign.) Acitvity Immed Pred(s) Crash Time (days) 5 Crash Cost ($) 2 0 6 Normal Time (days) 7 6 9 7 3 6 8 6 10 B D E F G H 1 Normal Cost ($) 60000 120000 16000 50000 90000 45000 80000 15000 100000 Crash Max Cost per Crash Day (days) 1000 N/A 6000 8000 6000 5000 12000 2500 2000 BD 62000 120000 22000 58000 96000 50000 92000 20000 102000 8 6 2 5 7 4 9 1 1 1 1 1 D G E,F,H 2 1 A (7) B(6) E {3} Start C (9) D(7) F(6) 1 (10) Finish (6) Indirect project costs $10.000 per day Immed Preds Normal Time (day Acitvity Max Crash (days 2 1.000 7 0 B A 0 9 D E 1 1 BD 7 3 Direct Costs - Crash Time Direct Costs - Crash Cost Normal (days Crashed per Day S 60.000 5 $ 62,000S S 120.000 $ 120,000 NA $ 18.000 8 $ 22,000 $ 6.000 50.000 $ 58,000 $ 8.000 S 90.000 2 $ 90,000 $ 0.000 46.000 5 $ 50,000 $ 5.000 $ 80.000 7 $ 92,000 $ 12.000 $ 15.000 4 $ 20,000 $ 2.500 $ 100.000 9 $ 102,000 $ 2.000 $ 576,000 F D 6 1 G 8 1 8 2 1 1 E.F.H 10 Total Project Costs Direct Indirect $ 330,000 $ 578.000 S 906.000 "Crash" the project to find the MINIMUM COST schedule Activity Additional Cost Net to Crash Cost Savings Savings C-GHI 33 PATH Durations C-D-F-1 C-D-E-I 32 ABEI 26