Question: Consider the problem described in the attached Distribution Centers.docx file. According to the optimal solution ( make sure that your numeric responses contain NO commas

Consider the problem described in the attached "Distribution Centers.docx" file. According to the optimal solution (make sure that your numeric responses contain NO commas):
The number of units shipped annually from Las Vegas to the East Customer Zone is
Blank 1. Fill in the blank, read surrounding text.
The number of units shipped annually from Las Vegas to the West Customer Zone is
Blank 2. Fill in the blank, read surrounding text.
The number of units shipped annually from Las Vegas to the South Customer Zone is
Blank 3. Fill in the blank, read surrounding text.
The number of units shipped annually from Kansas City to the West Customer Zone is
Blank 4. Fill in the blank, read surrounding text.
The number of units shipped annually from Kansas City to the South Customer Zone is
Blank 5. Fill in the blank, read surrounding text.
The number of units shipped annually from Atlanta to the East Customer Zone is
Blank 6. Fill in the blank, read surrounding text.
The number of units shipped annually from Atlanta to the West Customer Zone is
Blank 7. Fill in the blank, read surrounding text.
The number of units shipped annually from Atlanta to the South Customer Zone is
Blank 8. Fill in the blank, read surrounding text.
The number of units shipped annually from Dallas to the East Customer Zone is
Blank 9. Fill in the blank, read surrounding text.
The number of units shipped annually from Dallas to the West Customer Zone is
Blank 10. Fill in the blank, read surrounding text.
The number of units shipped annually from Dallas to the South Customer Zone is
Blank 11. Fill in the blank, read surrounding text.
The total annual fixed and shipping cost is $
Blank 12. Fill in the blank, read surrounding text.A company needs to decide on the number and locations of new distribution centers to open in
order to minimize total annual fixed and shipping costs. The candidate cities in which to open
distribution centers are Las Vegas, Kansas City, Atlanta, and Dallas. The following table
provides the annual capacities and annual fixed costs for operating distribution centers at each
city.
The distribution centers will need to ship to three customer zones: East, West, and South.
Annual requirements are 2,400 units for East, 2,160 units for West, and 1,440 units for South.
The following table provides the cost to ship one unit between each city and the customer zones.
In addition the following conditions must be met by the final decision: 1) a distribution center
must be opened in either Las Vegas or Dallas, and 2) if a distribution center is opened in Kansas
City, then one must also be opened in Atlanta.
Note: Make sure to set the Integer Optimality (%) tolerance at 0.05 in Solver Options as shown
in Screenshot 6-2A page 218 of the textbook, prior to solving the problem.
 Consider the problem described in the attached "Distribution Centers.docx" file. According

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!