Globex Investment Capital Corporation, a financial firm, owns six assets that have the following estimated returns ($ million) if sold in one of the next three years. For example, if asset 1 is sold in year 2, the firm receives $20 million.
Sold in
Assets Year 1 Year 2 Year 3
1 15 20 24
2 16 18 21
3 22 30 36
4 10 20 30
5 17 19 22
6 19 25 29
To generate operating funds and maintain a regular cash flow, Globex must sell at least $20 million worth of assets in year 1, $25 million in year 2, and $35 million in year 3. Globex wants to develop a plan for selling these companies during the next three years that will maximize return. Develop and formulate an appropriate linear programming model for this problem, clearly indicating the decision variables, objective function and the constraints. Then, solve it using Excel solver. A printout of Excel.