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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Introduction To Information Systems Supporting And Transforming Business
Authors: R Kelly Rainer, R Kelly Rainer Jr, Brad Prince
6th Edition
1119107997, 9781119107996
