Please Use Solver Model on Excel with the formulas.

Braxton oil company produces four brands of oil: regular, multigrade, supreme, and extreme. Each brand of oil is composed of one or more of four crude stocks, each having a different lubrication index. The relevant data concerning the crude stocks are as follows.

(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 the production to exceed the daily commitments. What is the optimal profit

2) Braxton oil company produces four brands of oil: regular, multigrade, supreme, and extreme. Each brand of oil is composed of one or more of four crude stocks, each having a different lubrication index. The relevant data concerning the crude stocks are as follows. Each brand of oil must meet a standard for a lubrication index, and each brand thus sells at a different price. The relevant data concerning the four 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 the production to exceed the daily commitments. What is the optimal profit