Please use EXCEL to solve this problem

(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. 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 Gasoline Avalon Bonavista Octane Vapour Amount Rating Pressure (kPa) Available (m) 105 35 25,000 82 66 38,000 Buying Price ($ per m) 310 240 For the Premium and Regular gasolines the requirements are: Output Gasoline Minimum Octane Rating 95 87 Maximum Minimum Selling Vapour Amount Price Pressure (kPa) Required (m) ($ per m3) 43 19,000 350 58 27,000 290 Premium Regular We define the variables as follows: A and B are respectively the amount of gasoline in m purchased from Avalon Energy/Bonavista Petroleum. P and R are respec- tively the amount of Premium/Regular gasoline in m blended and sold. AP, AR, BP, and BR are respectively the amounts in m of Avalon/Bonavista gasoline used to make Premium/Regular gasoline