Question: Please explain this using excel solver. I'm so confused. A Inear programming computer package is needed Seastrand Oil Company produces two grades of gasoline regular

Please explain this using excel solver. I'm so confused.
A Inear programming computer package is needed Seastrand Oil Company produces two grades of gasoline regular and high octane. Both gasolines are produced by blending two types of crude oil. Although both types of crude or contain the two important ingredients required to produce both gasolines, the percentage of important ingredients in each type of crude oil differs, as does the cost per gallon. The percentage of ingredients A and B in each type of crude oil and the cost per gallon are shown. Crude Oil Cost Ingredient A Ingredient 1 50.30 20% 2 50.35 30% Each gallon of regular gasoline must contain at least 40% of ingredient, whereas each gallon of high octane can contain at most 50% of ingredient B. Dally demand for regular and high-octane gasoline is 800,000 and 500,000 gallons, respectively. How many gallons of each type of crude oil should be used in the two gasolines to satisfy ally demand at a minimum cost? (Round your answers to the nearest gallon) Sallons of crude I used to produce regular 226572 gallons of crude I used to produce high-octane 250000 Sallons of crude 2 used to produce regular 571428 Sallons of crude 2 used to produce high-octane 250000 What is the total minimum cost on s) for the gallons? (Round your answer to the nearest dollar) $415000Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
