EXCEL EXAMPLE PLEASE As well

MO Oil, Inc. blends two different types of gasoline (regular and premium) from three refining streams (1, 2, and 3). The streams operate at fixed capacities of 9,000, 7,000, and 5,000 barrels per week. The gasoline types are sold at prices of $100 and $120 per barrel, respectively, and any output of the three streams not used in the production of gasoline is sold at prices of $30, $35, and $40, respectively. At least 4,000 barrels of regular gasoline must be produced per week to satisfy a contract. The minimum octane numbers are 80 on regular and 90 on premium. Assume that each stream contributes to the octane number an amount equal to the product of its octane number and its fraction of the total volume of the mixture. The octane ratings of the three streams are 75, 85, and 95.

Assuming the company wants to maximize revenues, develop the LP model that will indicate the optimum weekly volumes of regular and premium gasoline to produce. (15 points)

Formulate an LP problem to determine the highest Revenue. Write your problem formulation. Be sure to define your variables.

Variables:

b. Solve the problem and write your final answers below.