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