Operating Management Solver Chapter 4

305 Words2 Pages
Assignments Answers No 4 Problem 5-6: Question: what happened to the total optimal total cost? How can you explain this “more for less” paradox? Answer: The original model uses arc (plan 2, region 1) which is costly route to satisfy region 1. Now the model uses the cheaper arc (plan 1, region 1) to satisfy the extra automobile unit demanded in region 1. Problem 5-14: Question: discuss the pros and cons of these two approaches for this particular example? Answer: the standard tables-wise approach is easier to construct. However, we need to put hypotheses high number 999,999 on empty cells in order to prevent solver from selecting these cells (which means 0 in excel) in order to model the problem correctly. The alternative model is little bit longer to construct but requires no workarounds like the standard model (the 999,999 cells). Problem 5-20: Question: How much does the total cost increase because of these disallowed routes? Answer: After eliminating plant to plan and customer to customer routes, the total goes from $3,260 to $4,160 which means a $900 increase in cost. Problem 5-30: The optimal solution still the same. Problem 5-48: a. Shipping through Chicago is more expensive comparing to direct shipping from production city either Boston or Charlotte. Example, shipping direct from Boston to Los Angeles will cost only $80, however shipping indirect through Chicago will cost: Boston to Chicago cost is $40, plus Chicago to Los Angeles cost is 65. The total indirect shipment will be 40 + 65 = $105 which is greater than the cost of direct shipment which is only $80 b. As the max (low cost) shipment direct route to New York and Seattle is reached. The solution is forced to use the indirect shipment through Chicago (yields higher
Open Document