Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

5 Homework Each year, Data Corporal produces up to 10,000 computers in Boston and up to 6,000 computers in Charlotte. There are customers in Los

image text in transcribed
image text in transcribed
image text in transcribed
5 Homework Each year, Data Corporal produces up to 10,000 computers in Boston and up to 6,000 computers in Charlotte. There are customers in Los Angeles, New York, and Seattle who must receive 5,300,6,700, and 3,300 computers, respectively. Producing a computer costs $150 in Boston and $175 in Charlotte. Computers are transported by plane and can be sent through Chicago. The costs of sending a computer between pairs of cities are shown in the file POS_58.xlsx. a. Determine how to minimize the total (production plus shipping) cost of meeting Data Corporal's annual demand. If your answer is zero, enter "O". Flows (number of units): To Chicago Los Angeles New York Seattle From Boston 0 Charlotte X 0 Chicago Why doesn't it make sense to ship any computers through Chicago? with the given unit shipping costs shipping through Chicago is always more expensive than shipping directly to the customers, so it never makes sense to ship through Chicago b. Modify the model so that no more than 3,000 computers can be shipped between any two cities, and find the optimal solution to this modified model. If your answer is zero, enter "0". Flows (number of units): Chicago Los Angeles New York Seattle From Boston 3 X er 5 Homework Why doesn't it make sense to ship any computers through Chicago? With the given unit shipping costs shipping through Chicago is always more expensive than shipping directly to the customers, so it never makes sense to ship through Chicago. b. Modify the model so that no more than 3,000 computers can be shipped between any two cities, and find the optimal solution to this modified model. If your answer is zero, enter "O". Flows (number of units): To Chicago Los Angeles Seattle New York From Boston Charlotte Chicago Why are computers now shipped through Chicago? The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank B D E F G 1 Data General data 2. 3 Unit shipping costs 4 5 6 From Boston 7 Charlotte 8 Chicago 9 Chicago $40 $45 Los Angeles $80 $75 $65 New York $30 $55 $45 Seattle $75 $85 $60 9 10

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: C. William Thomas, Wendy M Tietz

13th Edition

013689903X, 9780136899037

More Books

Students also viewed these Accounting questions

Question

Explain why employees join unions.

Answered: 1 week ago

Question

Discuss breakdowns in the negotiations process.

Answered: 1 week ago