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
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
Study Help