Supply Chain Management Excel problems
Problem 5
| transportation costs: | To | |||||||
| From | Project 1 | Shipped | Project 2 | Shipped | Project 3 | Shipped | Excess capacity | |
| Central | 9 | 0 | 8 | 0 | 7 | 1100 | 3000.0 | 1100 |
| Rock | 7 | 250 | 11 | 0 | 6 | 3750 | 4000.0 | 4000 |
| Acme | 4 | 2250 | 3 | 3750 | 12 | 0 | 6000.0 | 6000 |
| Unmet demand | 2500.0 | 2500.0 | 3750.0 | 3750.0 | 4850.0 | 4850.0 | ||
| 10750 | 11250 | 30200 | ||||||
| Total cost = | $52,200 |
Problem 6 Brevard
| Shipments: | To | |||||||
| From | Charlotte | Shipped | Greenville | Shipped | Atlanta | Shipped | Excess capacity | |
| Wise | 20.0 | 50.0 | 25.0 | 0.0 | 22.0 | 250.0 | 300.0 | 300.0 |
| Humbolt | 17.0 | 200.0 | 27.0 | 0.0 | 25.0 | 0.0 | 200.0 | 200.0 |
| Cleveland | 21.0 | 0.0 | 20.0 | 150.0 | 22.0 | 0.0 | 150.0 | 150.0 |
| Brevard | 29.0 | 0.0 | 30.0 | 50.0 | 30.0 | 100.0 | 150.0 | 150.0 |
| Unmet demand | 250.0 | 250.0 | 200.0 | 200.0 | 350.0 | 350.0 | ||
| 4400 | 4500 | 8500 | ||||||
| Total cost = | $17,400.00 |
Problem 6 Laurens
| Shipments: | To | |||||||
| From | Charlotte | Shipped | Greenville | Shipped | Atlanta | Shipped | Excess capacity | |
| Wise | 20.0 | 0.0 | 25.0 | 0.0 | 22.0 | 300.0 | 300.0 | 300.0 |
| Humbolt | 17.0 | 200.0 | 27.0 | 0.0 | 25.0 | 0.0 | 200.0 | 200.0 |
| Cleveland | 21.0 | 0.0 | 20.0 | 100.0 | 22.0 | 50.0 | 150.0 | 150.0 |
| Laurens | 27.0 | 50.0 | 28.0 | 100.0 | 31.0 | 0.0 | 150.0 | 150.0 |
| Unmet demand | 250.0 | 250.0 | 200.0 | 200.0 | 350.0 | 350.0 | ||
| 4750 | 4800 | 7700 | ||||||
| Total cost = | $17,250.00 | |||||||
| Laurens is the cheaper choice to use. |