Question: Please show all work in Excel. A B D E F G H J M N 0 P Q R S 1 C Oly, Inc.

Please show all work in Excel.

Please show all work in Excel. A B D E F G H J M

A B D E F G H J M N 0 P Q R S 1 C Oly, Inc. blends two different types of gasoline (regular and premium) from three refining streams (1.2 and 3). 2 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. 3 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. Alleast 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. 5 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: ((XP(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. 4 6 7 8 9 10 By-Products 11 Stream 31 12 Steam B2 Steam > BJ 13 14 15 16 17 18 19 20 21 Regular Premium Solve the problem and write your final answers in the spaces provided below. 22 Be sure that your Solver includes all the reques parameters and I can solve it by clicking "Solve.? 23 Hint There are 9 decision variables in this problem as shown in the tables below. 24 25 Optimum Objective Function Value2= $ 26 27 Optimum Solution: 28 29 Regule Premium 30 Stream 1 31 Stream 2 32 Stream 3 33 34 35 Byproduct 1 36 Byproduct 2 37 Byproduct 3 38 39 40

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!