Question: A new order filling system needs to be installed as soon as possible. The following table lists the projects activities and their predecessors. Also provided
A new order filling system needs to be installed as soon as possible. The following table lists the projects activities and their predecessors. Also provided is the cost information to reduce the standard activity times. Set up and solve an LP model using Excel to crash this project to 24 weeks. What is the total crashing cost?
| Activity | Immediate Predecessors | Standard Time (WKS) | Standard Cost | Crash Time (WKS) | Crash Cost |
| A | - | 7 | $2000 | 5 | $3500 |
| B | A | 10 | $3000 | 8 | $4700 |
| C | A | 8 | $3400 | 7 | $3700 |
| D | C | 6 | $1600 | 4 | $2600 |
| E | C | 7 | $1900 | 4 | $4000 |
| F | D, E | 5 | $1200 | 3 | $2800 |
| G | B, C | 11 | $8200 | 8 | $10900 |
| H | F, G | 4 | $2600 | 3 | $3800 |
PLEASE USE TEMPLATE ABOVE. THANK YOU.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock