Question: Help doing this in Excel is wanted. Thanks! SABA, Inc. blends two different types of gasoline (regular and premium) from three refining streams (1, 2,


Help doing this in Excel is wanted. Thanks!
SABA, 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 18,000, 14,000, and 10,000 barrels per week. The gasoline types are sold at prices of $110 and $120 per barrel, respectively. Any output of the three streams not used in the production of gasoline are treated with an additive and are sold at prices of $121, $110, and $122 , respectively. At least 8,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. For example the octane for Regular Barrel will be: (X1/(X1+X2+X3))*75+((X2/(X1+X2+X3))*85+(X3/(X1+X2+X3))*95 >= 80 The octane ratings of the three streams are 75, 85, and 95. For detailed explanation, See the diagram below. The company wants to maximize revenues. Develop the LP model that will indicate the optimum weekly volumes of regular and premium gasoline to produce. By-Products Stream B1 Stream 2 B2 Stream 3 B3 Regular Premium Solve the problem and write your final answers in the spaces provided below. Be sure that your Solver includes all the requres parameters and I can solve it by clicking "Solve.". Hint: There are 9 decision variables in this problem as shown in the tables below. Optimum Objective Function Value Z= $ Optimum Solution: Regular Premium Stream 1 Stream 2 Stream 3 Byproduct 1 Byproduct 2 Byproduct 3Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
