Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Riverside Oil Company in eastern Kentucky produces regular and supreme gasoline. Each barrel of regular sells for $21 and must have an octane rating of

image text in transcribed

Riverside Oil Company in eastern Kentucky produces regular and supreme gasoline. Each barrel of regular sells for $21 and must 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 three inputs: Riverside has orders for 300,000 barrels of regular and 450,000 barrels of supreme. Solve this problem using Excel's Solver and choose ALL the answers which are CORRECT. There are 6 correct answers; penalty for wrong answers. To achieve the maximum profit ( optimal solution ), Input 3 is not required to make Regular gasoline In case of achieving the maximum profit (optimal solution), the total quantity of barrels of Input 3 used to make both Regular and Supreme gasoline is 300,000 To achieve the maximum profit (optimal solution), the number of barrels of Input 2 required to make Supreme gasoline are 230,769 To achieve the maximum profit ( optimal solution ), Input 3 is not required to make Supreme gasoline To achieve the maximum profit (optimal solution), the number of barrels of Input 1 required to make Regular gasoline are 80,769 The maximum profit is $5,012.5 The maximum profit is $5,012,500 To achieve the maximum profit (optimal solution), the number of barrels of Input 2 required to make Supreme gasoline are 119,231 To achieve the maximum profit ( optimal solution ), the number of barrels of Input 1 required to make Regular gasoline are 69,231 In case of achieving the maximum profit (optimal solution), the total quantity of barrels of Input 3 used to make both Regular and Supreme gasoline is 250,000 To achieve the maximum profit ( optimal solution ), the number of barrels of Input 3 required to make Regular gasoline are 250,000 To achieve the maximum profit ( optimal solution ), the number of barrels of Input 3 required to make Supreme gasoline are 250,000

Step by Step Solution

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

Step: 3

blur-text-image

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

An Introduction to Management Science Quantitative Approach to Decision Making

Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran

15th edition

978-1337406529

More Books

Students also viewed these General Management questions