Project Management and Project Crash
Four Steps to Project Crashing
Find the normal critical path and identify the critical activities.
Compute the crash cost per week (or other time period) for all activities in the network using the formula:
Select the activity on the critical path with the smallest crash cost per week and crash this activity to the maximum extent possible or to the point at which your desired deadline has been reached.
Check to be sure that the critical path you were crashing is still critical. If the critical path is still the longest path through the network, return to step 3. If not, find the new critical path and return to step 2.
Crash cost/Time period =
Crash cost – Normal cost
Normal time – Crash time
Start Excel QM
Select Excel QM Tab
Select Alphabetical
Select Display All Models
Select Alphabetical
Select Project Management
Select Crashing
Enter the number of activities (must be 9 or fewer in Excel)
Project Crashing
Enter the data in the shaded area. Then go to the DATA Tab on the ribbon, click on Solver in the Data Analysis Group and then click SOLVE.
This is where your crashing cost and new crashed time are located