NOTE: All Linear Programming models must be "complete" and written in standard form, and describe every term and coefficient in all Excel Solver spreadsheets.

4 of 5 4. A refinery blends four petrolcum components into three grades of gasoline -regular, premium and low-lead. The maximum shown below; quantities available of each component and the cost per barrel are Maximum Barrels Available Cost Barrel 5000 2400 4000 1500 To ensure that each gasoline grade retains certain essential characteristics, the refinery has put limits on the percentage of the components in each blend. The limits as well as the selling prices for the various are as follows Grade Regular ifications Selling Price Barrel (S) 12 Not less than 40% of I Not more than 20% of 2 Not more than 30% of 3 Not less than 40% of 3 Not more than 50% of 2 Not less than 10% of Premaum Low-Lead 10 The refinery wants to produce at least 3000 barrels of each grade of gasoline. Management wishes to determine the optimal mix of the four components that will maximize profit. Formulate a linear programming model for this problem, and solve using the computer