1. A company blends two gasolines from Avalon Energy and Bonavista Petroleum (in- puts) into two...

Transcribed Image Text:

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 Gasoline Rating Pressure (kPa) Available (m³) Avalon 105 Bonavista 82 35 66 For the Premium and Regular gasolines the requirements are: Output Minimum Maximum Gasoline Octane Vapour Premium Regular Business 2400, Winter 2021, Assignments written by Dr. David M. Tulett 25,000 38,000 Rating Pressure (kPa) 95 87 43 58 Buying Price ($ per m³) 310 240 Minimum Amount Selling Price Required (m³) ($ per m³) 350 290 19,000 27,000 2 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. (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. 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 Gasoline Rating Pressure (kPa) Available (m³) Avalon 105 Bonavista 82 35 66 For the Premium and Regular gasolines the requirements are: Output Minimum Maximum Gasoline Octane Vapour Premium Regular Business 2400, Winter 2021, Assignments written by Dr. David M. Tulett 25,000 38,000 Rating Pressure (kPa) 95 87 43 58 Buying Price ($ per m³) 310 240 Minimum Amount Selling Price Required (m³) ($ per m³) 350 290 19,000 27,000 2 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. (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.