Formulate an algebraic model for the problem. Use LINGO or the Excel Solver to solve this model, with your name and student number included in a comment line. Copy-and-paste the model and solution LINGO files. If you solve the models in Excel Solver, you will have to write them in standard form, i.e. all variables on the left-hand side, and a number of the right-hand side. If you use LINGO, you are not bound by this restriction.

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) ($ per m3) Avalon 105 35 25,000 310 Bonavista 82 38,000 240 66 For the Premium and Regular gasolines the requirements are: Output Minimum Gasoline Octane Rating Premium 95 Regular Maximum Minimum Selling Vapour Amount Price Pressure (kPa) Required (m) ($ per m) 43 19,000 350 58 27,000 290 87 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