SOLUTION WITH EXCEL SOLVER

You can use the Excel-Solver plug-ins to solve the programming models given below. Find using. 1. While Mr. Ayhan was reading his daily newspaper at the weekend, he was reading 160 He wants to make the best use of his million TL. Various investments in the newspaper its funds and annual returns on the Istanbul Stock Exchange. examines and uses the following 7 investment forecasts with high returns: - Ege Fertilizer-annual return 30% - Fertilizer Factories-annual return 22.2% - Textile Company-annual return 28% - A Energy-annual return 18.5% - Z Energy-annual return 10.9% - Treasury Bills-annual yield 24\% - Bank-annual net interest rate 22% Mr. Ayhan is not interested in the selling prices of the shares of the companies in the stock market, but some made the following decisions according to the risk group: 1) Its total investment in the fertilizer exchange shall 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 settlement will be 8 million TL at the most. 4) Ege's investment in fertilizer will be 40 million TL at most. 5) The total investment he invested in the fertilizer and textile company was made in the energy company. will be less than the investment. 6) Treasury bills and the money to be deposited in the bank will be at least 30 million TL. 7) The maximum amount of money to be invested in energy will be 50 million TL. 8) Aegean fertilizer and textile investment, treasury bills and bank interest will be less than the amount invested. By solving the given problem with the Microsoft Excel Solver add-in, Ayhan brain We determine the type of investment and how much to invest. (The usage programming model of the problem is given below. Zmaks =0.301+0.2222+0.283+0.1854+0.1095+0.246+0.227 x1+x2+x3+x4+x5+x6+x7=160 (total investment amount) x1+x260 (1. decision) x4+x580 (2. decision) x38 (3. decision) x140 (4. decision) x1+x2+x3x4x50 (5. decision) x6+x730 (6. decision) x450(7. decision) x1+x3x6x70 (8. decision) x1,x2,x3,x4,x5,x6,x70