Question: Given the data in table below: Stores NY DC Charlotte Philadelphia Chicago Boston Capacity Pennsylvania $30 $10 $24 $24 $25 $21 21,000 Virginia $16 $13
Given the data in table below:
| Stores | ||||||||
|
| NY | DC | Charlotte | Philadelphia | Chicago | Boston | Capacity | |
| Pennsylvania | $30 | $10 | $24 | $24 | $25 | $21 | 21,000 | |
| Virginia | $16 | $13 | $30 | $22 | $10 | $24 | 28,000 | |
| Distribution Centers | North Carolina | $25 | $22 | $21 | $10 | $20 | $11 | 19,000 |
| South Carolina | $19 | $23 | $29 | $22 | $13 | $26 | 24,000 | |
| Georgia | $19 | $12 | $17 | $23 | $11 | $22 | 28,000 | |
| Ohio | $21 | $26 | $28 | $17 | $13 | $26 | 25,000 | |
| Demand | 25,400 | 32,000 | 24,500 | 25,000 | 18,500 | 19,500 |
a) Find the fesible solution using the north west strategy.
The number of shipments made from Pennsylvania to NY is
enter your response here.
The number of shipments made from South Carolina to Philadelphia is
enter your response here.
The total cost of the feasible plan is
enter your response here.
b) Using the solver in Excel with the optimal cost, the optimal plan is
enter your response here
cheaper than the feasible plan obtained using the north west strategy above.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
