management Information system.

Topic: management Information system.
Order Description
Formulate the problem above as a linear programming problem and determine the optimised solution to the problem using Excel. Create Answer and Sensitivity reports. Write a short report covering the following
a) Statement of your linear program problem,
b) Recommended investment strategy, giving the return in dollars for the first year,
c) The implications of a 10% increase or decrease in the individual investment returns (while keeping the returns on the others constant), including the effect on the objective function amount, and
d) The implications of a 10% increase or decrease in the constraint right hand side amounts, including the effect on the value of the objective function.
I will provide the model file(.xlsx) in additional file as well as more instruction including the report structure

WE ACCEPT