| EarthMover Project |
| "Current project has a critical path of 30 days. You must complete the job by at least day 26!" |
| | | NORMAL | | | CRASH |
| | Activity | Time (weeks) | Cost | | Best Time (weeks) | Activity Crash Cost ($) | Time reduction (weeks) | Crash Cost ($/week) |
| | A | 6 | $ 80,000 | | 5 | $ 20,000 | 1 | $ 20,000 |
| | B | 4 | $ 100,000 | | 4 | $ - 0 | 0 |
|
| | C | 3 | $ 50,000 | | 2 | $ 50,000 | 1 | $ 50,000 |
| | D | 6 | $ 150,000 | | 3 | $ 150,000 | 3 | $ 50,000 |
| | E | 3 | $ 180,000 | | 2 | $ 70,000 | 1 | $ 70,000 |
| | F | 10 | $ 300,000 | | 7 | $ 180,000 | 3 | $ 60,000 |
| | G | 2 | $ 100,000 | | 2 | $ - 0 | 0 |
|
| | H | 6 | $ 450,000 | | 5 | $ 350,000 | 1 | $ 350,000 |
| | I | 8 | $ 350,000 | | 4 | $ 300,000 | 4 | $ 75,000 |
| | | Goal to complete by: | 30 | weeks | <---- Change this goal from the currect 30 weeks to the new 26 week target! |
| Objective Function | | | | | Then run SOLVER to find the least expensive way to reach your goal !!! |
| | Min cost to CRASH | | $ - 0 |
| Xi = earliest finish time for activity i | | | EF-limit | | Yi = the amount of time activity i is crashed | | | Max crash available | | New time |
| A | 6 | = | 6 | | A | 0 | <= | 1 | A | 6 |
| B | 10 | = | 10 | | B | 0 | <= | 0 | B | 4 |
| C | 9 | = | 9 | | C | 0 | <= | 1 | C | 3 |
| D | 16 | = | 16 | | D | 0 | <= | 3 | D | 6 |
| E | 13 | = | 13 | | E | 0 | <= | 1 | E | 3 |
| F | 20 | = | 20 | | F | 0 | <= | 3 | F | 10 |
| G | 22 | = | 22 | | G | 0 | <= | 0 | G | 2 |
| H | 28 | = | 28 | | H | 0 | <= | 1 | H | 6 |
| I | 30 | = | 30 | | I | 0 | <= | 4 | I | 8 |
| | | Note: | EF = EF of previous + t | | | | Non-negativity constraints |
| | | | New t = Original t - Crash |
| | New Finish time | | Goal |
| H | 28 | <= | 30 |
| I | 30 | <= | 30 |
Yuzhi Zhao
Week2-EarthmoverProjectPlan.xlsx
