In the pension fund problem, suppose James has been asked to see how the optimal solution will change if the required payments in years 2017 through 2024 all increase by the same percentage, where this percentage could be anywhere from 5% to 25%. Use an appropriate one-way SolverTable to help him out, and write a memo describing the results.
Answer to relevant QuestionsOur 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 ...In the capital budgeting model in Figure 14.40, we supplied the NPV for each investment. Suppose instead that you are given only the streams of cash inflows from each investment shown in the file S14_49.xlsx. This file also ...How difficult is it to expand the Great Threads model to accommodate another type of clothing? Answer by assuming that the company can also produce sweatshirts. The rental cost for sweatshirt equipment is $1100, the variable ...How hard is it to expand a set-covering model to accommodate new cities? Answer this by modifying the model in Figure 14.55. Add several cities that must be served: Memphis, Dallas, Tucson, Philadelphia, Cleveland, and ...In the portfolio optimization model, stock 2 is not in the optimal portfolio. Use SolverTable to see whether it ever enters the optimal portfolio as its correlations with stocks 1 and 3 vary. Specifically, use a two-way ...
Post your question