Question: Please use excel with formulas Use the information contained below to pompress one time unit per move using the least cost method. Reduce the schedule

Please use excel with formulas
Use the information contained below to pompress 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 Microsott 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 duratlon for the project? What is the total direct cost at the optimum cost-ime 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 8 ? Enter appropriate uniks and round unswer to wo decinkal places. Vpload a spreadsheet showing calculations for each step
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
