Continuing the previous problem (with capacity 300 at plant 2), suppose you want to see how much extra capacity and extra demand you can add to plant 1 and region 2 (the same amount to each) before the total shipping cost stops decreasing and starts increasing. Use SolverTable appropriately to find out. Can you explain intuitively what causes the total cost to stop decreasing and start increasing?
Answer to relevant QuestionsModify the original Grand Prix example by increasing the demand at each regions by 200, so that total demand is well above total plant capacity. However, now interpret these “demands” as “maximum sales,” the most ...Continuing the previous problem, develop a sample model with your own choices of N, M, and L that barely stay within Solver’s limit. You can make up any input data. The important point here is the layout and formulas of ...You saw that the “natural” way to model SureStep’s backlogging problem, with IF functions, leads to a non-smooth model that Solver has difficulty handling. There is another version of the problem that is also difficult ...Our pension fund model is streamlined, perhaps too much. It does all of the calculations concerning cash flows in row 20. James decides he would like to break these out into several rows of calculations: Beginning cash ...As it currently stands, investment 7 in the capital budgeting model in Figure 14.40 has the lowest ratio of NPV to cash requirement, 2.5. Keeping this same ratio, can you change the cash requirement and NPV for investment 7 ...
Post your question