Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started