Linear Programming Problem in EXCEL Solver

MathematicsExpert
 (Not rated)
 (Not rated)
Chat

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 oil 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 B 

1               $0.15         40%               40% 

2               $0.20         70%               10% 

Each gallon of regular gasoline must contain at least 60% of ingredient A, whereas each gallon of high octane can contain at most 30% of ingredient B. Daily demand for regular and high-octane gasoline is 700000 and 400000 gallons, respectively. How many gallons of each type of crude oil should be used in the two gasolines to satisfy daily demand at a minimum cost? Round your answers to the nearest whole number. Round the answers for cost to the nearest dollar. 

    • 7 years ago
    LP Model Solution in EXCEL Solver
    NOT RATED

    Purchase the answer to view it

    • LPModelinEXCELSolver.xlsx
    • LPModelSolution.docx