PLEASE SHOW FORMULA IF USING EXCEL

Problem 3. (Chapter 5 Project Management) Table below contains information about an environmental clean-up project. Shorten the project three weeks by finding the minimum-cost schedule. Assume that project indirect costs and penalty costs are negligible. Identify activities to crash while minimizing the additional crash costs. (Hint: This problem is similar to the example of Crashing a project in Slides 30-40 of Chapter 5) Activity Normal Time (weeks) 7 Crash Time (weeks) 6 Cost to Crash ($ per week) 200 Immediate Predecessors None A B 12 9 250 None A 7 6 250 D 6 5 300 A An E 1 1 F 1 1 B CD DE F G 3 3 1 200 2 350 H I 3 2 2 G 2