Question
Re-consider the Riverside Oil Company problem. Assume further that the Riverside Oil Co. also has available 100,000 barrels of Middle Oil to help them satisfy
Re-consider the Riverside Oil Company problem. Assume further that the Riverside Oil Co. also has available 100,000 barrels of Middle Oil to help them satisfy their necessary production of both Regular and Supreme Gasoline. Middle Oil has an octane level of 8.5, and has a cost of $17 per barrel.
a) How would the possibility of using Middle Oil will change your formulation of the problem discussed in class? Feel free to state only the parts of the Linear Programming formulation that actually change. Clearly state any decision variables, constraints, etc. that you might use.
b) Write the necessary AMPL (or Excel) files to solve the modified version of the problem you stated in part a) of this question with AMPL (or Excel). In particular, provide the optimal production quantities for the problems decision variables, and provide a print-out of your AMPL(or Excel) files.
1. (15 points) Linear Programmingl Modeling (with more than two variables!): Riverside Oil Company in eastern Kentucky produces regular and supreme gasoline. Each barrel of regular gasoline sells for $21 and must have an octane rating (a measure of the "explosiveness" of the gasoline) of at least 8. Each barrel of supreme gasoline sells for $25 and must have an octane rating of at least 9. Each of these types of gasoline are manufactured by mixing different quantities of two classes of Oil: Heavy Oil, and Light Oil. The cost, octane rating, and available supply of these two classes of Oil are given in the table below. Oil Cost per Barrel Octane Rating Barrels Available thousands of barrels) 10 Heavy $16 430 Light $18 370 Riverside has orders for 300 thousand barrels of regular gasoline and 450 thousand barrels of supreme gasoline. 1. (15 points) Linear Programmingl Modeling (with more than two variables!): Riverside Oil Company in eastern Kentucky produces regular and supreme gasoline. Each barrel of regular gasoline sells for $21 and must have an octane rating (a measure of the "explosiveness" of the gasoline) of at least 8. Each barrel of supreme gasoline sells for $25 and must have an octane rating of at least 9. Each of these types of gasoline are manufactured by mixing different quantities of two classes of Oil: Heavy Oil, and Light Oil. The cost, octane rating, and available supply of these two classes of Oil are given in the table below. Oil Cost per Barrel Octane Rating Barrels Available thousands of barrels) 10 Heavy $16 430 Light $18 370 Riverside has orders for 300 thousand barrels of regular gasoline and 450 thousand barrels of supreme gasoline
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started