solve this problem using Excel Solver, and submit the model and solution worksheet. What is the optimum profit?

Answer the following questions using the sensitivity report regenerated for the optimum solution:

Does the optimum solution change if the selling price per barrel of Diesel reduces to $$8\mathrm{.}55?$

If the purchasing department finds a new supplier that sells an extra $1000$ barrels of Component $1$ for $$10,5$ a barrel, what would be your decision? To buy from this new supplier, too or no$?$A refinery blends four petroleum components into three grades of gasoline$-$regular, premium,

and diesel. The maximum quantities available of each component and the cost per barrel are as

follows:

To ensure that each gasoline grade retains certain essential characteristics, the refinery has put

limits on the percentages of the components in each blend. The limits as well as the selling

prices for the various grades are as follows:

The refinery wants to produce at least $3,000$ barrels of each grade of gasoline. Management

wishes to determine the optimal mix of the four components that will maximize profit.