| 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 |
gysgtclarke
Week2-EarthmoverProjectPlan.xlsx
