In: Operations Management
Construct the following network(AOA) and determine the minimum total cost to complete the project if indirect cost is Rs.1500 per day.
|
Activity |
NT |
CT |
NC |
CC |
|
1-2 |
6 |
4 |
6000 |
7800 |
|
1-3 |
7 |
4 |
3000 |
4200 |
|
2-3 |
4 |
1 |
5000 |
9200 |
|
2-5 |
6 |
5 |
6000 |
7500 |
|
3-4 |
7 |
3 |
2000 |
6800 |
|
4-5 |
3 |
1 |
2000 |
4000 |
|
4-6 |
7 |
3 |
4000 |
5600 |
|
5-6 |
5 |
4 |
3000 |
4100 |
AOA network is as follows:

Create Excel model as follows:

Enter Solver Parameters as follows:

Click Solve to generate the solution. After that, values appear automatically in yellow cells

Click OK
-------------
Minimum total crash cost and indirect cost = 11100+22500 = Rs 33,600
Minimum total cost to complete the project = Rs 64,600 (note that this includes the normal cost of Rs 31,000)