1. A company blends two gasolines from Avalon Energy and Bonavista Petroleum (in- puts) into two...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
Related Book For
Operations Management Creating Value Along the Supply Chain
ISBN: 978-0470525906
7th Edition
Authors: Roberta S. Russell, Bernard W. Taylor
Posted Date:
Students also viewed these accounting questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
A researcher wanted to find out if there was difference between older movie goers and younger movie goers with respect to their estimates of a successful actors income. The researcher first...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Estimates have been presented to Holly Farms, which is considering two environmental chambers for a project that will detail laboratory confirmations of on-line bacteria tests in chicken meat for the...
-
A diffraction grating has n lines per meter. Show that the angular separation of two lines of wavelengths and + meters isapproximately AO = V(1/nm)? - 22
-
In Problem find the matrix product. Note that each product can be found mentally, without the use of a calculator or pencil-and-paper calculations. [3 o][1 3 3][5 7
-
a. What alternatives exist when a book value is unacceptable? b. What factors affect the amount of any proposed adjustment?
-
Given the following financing project being considered by a venture firm, find the critical path probability of completion by 17 weeks. By 24 weeks. By what date is management 90 percent sure...
-
What are some developmental and lifespan areas of interest to keep in mind when caring for a person with Autism?
-
Ivanhoe Company ended its fiscal year on July 31, 2020. The company's adjusted trial balance as of the end of its fiscal year is as follows. Ivanhoe Company Adjusted Trial Balance July 31, 2020 No....
-
QUESTION 1 Description: In your homework you had to create a linked list and a hash table using your linked list class. In that solution you used a linked list class within a hash table class. For...
-
1. The Wilson Motel borrowed $50,000 two year ago from the Wilmore Savings and Loan. On June 30, 20X6, the first non-interest payment is made to Wilmore of $10,000. The funds were borrowed at an...
-
For this question "Macro Corporation issued 50-year $80million of face value bonds that have a coupon rate of 6% paid semi-annually. The bonds were issued at 97. Given this information, calculate the...
-
Default risk and market risk Credit quality and inflation risk Credit quality, or default risk Interest rate and default risk. What does a bond rating measure?
-
If you currently can afford a $250,000 home loan with monthly payments of $1500, what needs to change in order for you to only be able to afford a $225,000 home loan with monthly payments of $1500?
-
If you were about to receive a 30 year fixed interest mortgage for $280,000 at 3.3% interest, what would your monthly payments be?
-
An ideal differentiator is placed in series with an ideal lowpass filter with a gain of 10 and a cutoff frequency of 25 Hz. Find the overall frequency response and plot its magnitude. H (w) H(w) -...
-
QUESTION 2 The CEO of Farisha Hijab Sdn Bhd insisted on further investigation to be carried out that he also required Mr Muaz to conduct the analysis of variance for the material and labour of the...
-
The Baytown Post Office has four stations for service. Customers line up in single file for service on an FIFO basis. The mean arrival rate is 40 per hour, Poisson distributed, and the mean service...
-
Give an example of a fixed-position layout for producing a product and providing a service.
-
Amber Ale use a simple five-step process to prepare its products for shipment. Because of recent increases in demand, the company is setting up an assembly line to do the work. How should the line be...
-
Top Catch Ltd purchased 2 refrigerated display units, to display fresh fish, on 1 January 2023 for \($23\) 000 per unit or total cost of \($46\) 000. The refrigerated display units will be...
-
On 2 January 2024, Omega Ltd purchased, by exchanging \($420\) 000 cash and a \($250\) 000, 12%, 18-month finance company loan, assets with the following independently determined appraised values....
-
Over a 5-year period, Eureka Ltd completed the following transactions affecting non-current assets in financial years ending 30 June. The company uses straight-line depreciation on all depreciable...
Study smarter with the SolutionInn App