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 fileP05_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 "0".
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".
Chrome File Edit t View History Bookmarks People Tab Window Help ) 52% Mon 5:36:29 PM Q MindTap - Cengage Learning ng.cengage.com Harris v KK CENGAGE |MINDTAP Q Search this course ? My Home Chapter 5 Homework X Courses 3. Spreadsheet eBook Catalog and Study Tools 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 P05_58.xisx. A-Z Partner Offers a. Determine how to minimize the total (production plus shipping) cost of meeting Data Corporal's annual demand. If your answer is zero, enter "0". Rental Options Flows (number of units): To College Success Tips Chicago Los Angeles New York Seattle Career Success Tips From Boston 40 80 x X Charlotte 45 X 75 X RECOMMENDED FOR YOU Chicago 1 2 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 Vthan shipping directly to the customers, so it never V|makes sense to ship through Chicago. pongo 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): Giving Effective Feedback To Chicago Los Angeles New York Seattle ? Help From Boston X Give Feedback Charlotte X X Chicago X X X 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 Hide Feedback ec88f3 9 NOV 3141593 dad5-4...5 2 ... W XExcel File Edit View Insert Format Tools Data Window Help ())) 52% Mon 5:36:40 PM AutoSave O OFF H X 6 . 5 - P05 58 (1) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri V 11 VA A = E ab General Conditional Formatting Insert v EV AC Format as Table v Ex Delete v V v Paste BIUVV LAV $ ~ % 9 Cell Styles v Format v Sort & Find & Ideas Sensitivity Filter Select H20 fx A B C D E F G H I J K L M N P Q R S T U V 1 Data General data 1AWN Unit shipping costs To Chicago Los Angeles New York Seattle From Boston $40 $80 $30 $75 4 00 Charlotte $45 $75 $55 $85 Chicago $65 $45 $60 10 11 12 13 14 15 16 18 19 20 21 24 25 26 28 29 30 31 Data + - + 100% ec88f3 9009 NOV dad5-4...5 2 W X
