Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Operations Management Creating Value Along the Supply Chain

Authors: Roberta S. Russell, Bernard W. Taylor

7th Edition

9781118139523, 0470525908, 1118139526, 978-0470525906

More Books

Students also viewed these Accounting questions

Question

Use a calculator to evaluate log 15 71 to four decimal places.

Answered: 1 week ago