Question: PLEASE SHOW STEPS AND EQUATIONS BEHIND THE CELLS AND SHOW WHAT TO PUT INTO SOLVER ADD IN. Thank you so much. already got an answer

2.5 Oil Blending: An oil company produces three brands of oil: regular, multigrade, and supreme. Each brand of oil is composed of one or more of four crude stocks, each having a different lubrication index. The relevant data cmnnarnino the ernde stocks are as follows. Each brand of oil must meet a minimum standard for a lubrication index, and eacn brand thus sells at a different price. The relevant data concerning the three brands of oil are as follows. The task is to determine an optimal output plan for a single day, assuming that production can be either sold or else stored at negligible cost. The daily demand figures are subject to alternative interpretations. Investigate the following. a. The daily demands represent potential sales. In other words, the model should contain demand ceilings (upper limits). What is the optimal profit? b. The daily demands are strict obligations. In other words, the model should contain demand constraints that are met precisely. What is the optimal profit? c. The daily demands represent minimum sales commitments, but all output can be sold. In other words, the model should permit production to exceed the daily commitments. What is the optimal profit
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
