QUESTION 1 Use the information contained below to compress one time unit per move using the least cost method. Reduce the schedule until you reach the crash point of the network. Create a table in Microsoft Excel that clearly identifies the following information for each move what activity was crashed, the crash cost of the activity, the adjusted total direct cost of the project, and the project duration. Note: The correct normal project duration, critical path, and total direct cost are provided. What is the optimum cost-time duration for the project? What is the total direct cost at the optimum cost-time duration? What is the total direct cost when you reduce the project schedule to a duration of 10? What is the total direct cost when you reduce the project schedule to a duration of 87 Enter appropriates and round answer to two decimal places. Upload a spreadsheet showing calculations for each step. Activity Crash Cost (Slope) Maximum Crash Time Normal Time Normal Cost A 55 3 120 B 40 1 3 150 80 2 4 180 D 65 1 3 150 E 50 2 4 200 F 0 0 1 200 A 3 B D 3 3 4 Initial project duration: 12 E 4 1x Total direct cost: 1,000