Question: Please solve this using and showing excel procedure Question 2: [20 points] Riverside Oil Company in eastern Kentucky produces regular and supreme gasoline. Each barrel

Please solve this using and showing excel procedure

Please solve this using and showing excel procedure Question 2: [20 points]

Question 2: [20 points] Riverside Oil Company in eastern Kentucky produces regular and supreme gasoline. Each barrel of regular sells for \$21 and mst have an octane rating of at least 90 . Each barrel of supreme sells for $25 and must have an octane rating of at least 97 . Each of these types of gasoline are manufactured by mixing different quantities of the following 3 inputs: Riverside has orders for 300,000 barrels of regular and 450,000 barrels of supreme. How should the company allocate the available inputs to the production of regular and supreme gasoline to maximize profits? a. Formulate an LP model for this problem. b. Create a spreadsheet model for this problem and solve it using Solver. Report the optimal solution (i.e. values for all the decision variables) and the value of the objective function in your report. In addition, save your work in Excel and upload the file along with your report

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!