Problems:
Transportation Optimization Problem
1. Steel mills in three cities produce the following amounts of steel weekly
| location |
|
weekly production (tons) |
| Ashville |
|
210 |
|
|
| Birmingham |
|
150 |
|
|
| columbus |
|
320 |
|
|
2. These mills supply steel to four cities where manufacturing plants have the following demand
| city |
|
weekly demand |
| Detroit |
|
130 |
|
| St Louis |
|
180 |
|
| chicago |
|
70 |
|
| Norfolk |
|
240 |
|
3. Shipping costs ($) per ton of steel are as follows
| |
|
detroit |
st louis |
chicago |
norfolk |
| Ashville |
|
$9 |
14 |
18 |
16 |
| birmingham |
|
8 |
11 |
16 |
7 |
| columbus |
|
12 |
16 |
22 |
10 |
4. Because of the strike shipments are prohibited form birmingham to chicago. Use linear programming in excel to determine the best
shipping schedule.
Please fill the answers into the following table (number of tons to be shipped form each mill to the four cities
| |
|
detroit |
st. louis |
chicago |
norfolk |
| Ashville |
|
|
|
|
|
| birmingham |
|
|
|
|
|
| columbus |
|
|
|
|
|