Question: optimal decisions and optimal profit. [15 points] Problem 2 [30 points]: An oil company produces three brands of oils: Regular, Multigrade, and Supreme. Each brand

optimal decisions and optimal profit. [15 points]
optimal decisions and optimal profit. [15 points] Problem 2 [30 points]: An oil company produces three brands of oils: Regular, Multigrade, and Supreme. Each brand of oil is composed of one or more of four crude stocks, each having a different viscosity index. The relevant data concerning the crude stocks are: Crude Stock Viscosity Index Cost ($/barrel) Supply Per Day (barrels) 20 7.10 1,000 40 8.50 1,100 30 7.70 1,200 55 9.00 1,100 Each brand of oil must meet a minimum standard for viscosity index, and each brand sells at a different price. The relevant data concerning the three brands of oil are: Brand Minimum Selling price Daily Maximum Sales Viscosity Index ($/barrel) (barrels) Regular 25 8.50 2,000 Multigrade 30 9.00 1,500 Supreme 50 10.00 800 a) Define the decision variables and write down the detailed mathematical formulation of the oil company's problem to maximize its total profit for a single day. [15 points] b) Solve the optimization problem by Excel Solver. Write down the company's optimal production plan and optimal total profit. [15 points]

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 Mathematics Questions!