Use lingo and please help me solve it, this is a practice question

question, do the following: (a) Formulate an algebraic model for the problem. Submit this in Word or pdf. (b) Use LINGO or the Excel Solver to solve this model, including your name and student number on the model. If using LINGO, submit files for the model and the solution for each question. If using the Excel Solver, submit one file for all questions, using tabs for the model and the Answer Report (a total of ten tabs.) (c) State the solution in words. Submit this in Word or pdf. When you attempt to solve these models, you might receive a message about the solution being infeasible. While this is a theoretical possibility, it won't happen for any of these questions. It means that a mistake has been made in formulating the model. Each question is worth 20 marks. 1. A company blends two gasolines from Avalon Energy and Bonavista Petroleum (in- puts) into two commercial products, Premium and Regular gasoline (outputs). For the inputs, the octane ratings, the vapour pressures in kilopascals, and the amounts available in cubic metres (m) and their prices are known. These are: Input Octane Vapour Amount Buying Price Gasoline Rating Pressure (kPa) Available (m) (S per ma Avalon 105 25,000 310 Bonavista 82 38,000 240 For the Premium and Regular gasolines the requirements are: Output Minimum Maximum Minimum Selling Gasoline Octane Vapour Amount Price Rating Pressure (kPa) Required (m) (5 per me') Premium 95 43 19.000 350 Regular 87 58 27,000 290 We define the variables as follows: A and B are respectively the amount of gasoline in or' purchased from Avalon Energy/Bonavista Petroleum. P and R are respec- tively the amount of Premium/Regular gasoline in or' blended and sold. AP, AR, BP, and BR are respectively the amounts in a" of Avalon/Bonavista gasoline used to make Premium/Regular gasoline