Modify the Barney-Jones investment problem so that there is a minimum amount that must be put into any investment, although this minimum can vary by investment. For example, the minimum amount for investment A might be $0, whereas the minimum amount for investment D might be $50,000. These minimum amounts should be inputs; you can make up any values you like. Run Solver on your modified model.
Answer to relevant QuestionsIn 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 ...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 ...Solve the previous problem using the input data in the file P14_50.xlsx.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 ...In the Great Threads model, the production quantities in row 16 were not constrained to be integers. Presumably, any fractional values could be safely rounded to integers. See whether this is true. Constrain these quantities ...In the Great Threads model, we found an upper bound on production of any clothing type by calculating the amount that could be produced if all of the resources were devoted to this clothing type.a. What if you instead use a ...
Post your question