Find the solutions of the linear programming models given below using the Microsoft Excel Solver add-in. 1. While Mr. Ayhan is reading his daily newspaper on a weekend, he wants to make the best use of his 160 million TL in the bank. It examines the various mutual funds in the newspaper and the annual returns of companies in the Istanbul Stock Exchange and selects the following 7 investments with stable high returns: - Ege Fertilizer - 30% annual return - Fertilizer mills (factories) - 22.2% annual return - Textile company - 28% annual return - A energy - 18.5\% annual return - Z energy - 10.9% annual return - Treasury bills - 24% annual return - Bank - annual net interest rate 22% Mr. Ayhan is not interested in the selling prices of the shares of the 5 companies on the stock exchange, but he made the following decisions according to the risk levels: 1. The total investment in the fertilizer exchange will not exceed 60 million TL. 2. The total investment to be made in the energy sector will not exceed 80 million TL. 3. The investment to be made in the textile company will be 8 million TL at the most. 4. The maximum investment to be made in Ege fertilizer will be 40 million TL. 5. The total investment in fertilizer and textile companies will be less than the investment in energy companies. 6. Treasury bills and the money deposited in the bank will be at least 30 million TL. 7. The maximum amount of money invested in A energy will be 50 million TL. 8. The investment made in Ege fertilizer and textile company will be less than the money invested as treasury bills and interest in the bank. By solving the given problem with the Microsoft Excel Solver add-in, determine how much money Mr. Ayhan will invest in which type of investment. (Linear programming model of the problem is given below.) Zmax=0.30x1+0.222x2+0.28x3+0.185x4+0.109x5+0.24x6+0.22x7 x1+x2+x3+x4+x5+x6+x7=160 (total investment amount) x1+x260(1st decision) x4+x580(2nd decision) x38(3rd decision) x140(4th decision) x1+x2+x3x4x50 (5 decision) x6+x730(6th decision) x450(7th decision) x1+x3x6x70 (8 decision) x1,x2,x3,x4,x5,x6,x70