Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. A company blends two gasolines from Avalon Energy and Bonavista Petroleum (in- puts) into two commercial products, Premium and Regular gasoline (outputs). For
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.
Step by Step Solution
★★★★★
3.47 Rating (150 Votes )
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started