In the Barney-Jones investment problem, increase the maximum amount allowed in any investment to $150,000. Then run a one-way sensitivity analysis to the money market rate on cash. Capture one output variable: the maximum amount of cash ever put in the money market account. You can choose any reasonable range for varying the money market rate.
Answer to relevant QuestionsWe claimed that our model for Barney-Jones is generalizable. Try generalizing it to the case where there are two more potential investments, F and G. Investment F requires a cash outlay in year 2 and returns $0.50 in each of ...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 ...Solve Problem 49 with the extra assumption that the investments can be grouped naturally as follows: 1–4, 5–8, 9–12, 13–16, and 17–20.a. Find the optimal investments when at most one investment from each group can ...In the optimal solution to the Great Threads model, the labor hour and cloth constraints are both binding—the company is using all it has. a. Use SolverTable to see what happens to the optimal solution when the amount of ...In the last sheet of the finished version of the Fixed Cost Manufacturing file, we illustrated one way to model the Great Threads problem with IF functions, but saw that this approach doesn’t work. Try a slightly different ...
Post your question