Hello, I need help with solving this in Excel using Solver. Please use screenshots so I can understand formulas and Solver inputs. Thank you.

Problem 6. (10 froinn) _I week. The gasoline types are sold at prices of $1 10 and $120 _per barrel, respectively, and: any output of the .. Persion Petroleum, Inc. blends two dierent types of gasoline (regular and premium) 'om three I three streams not used In the production of gasoline are treated with an additive and are sold at prices of $121, _1__1__{_}_, and $122, respectively. At _least 8 ,000 barrels of regular gasoline_ must be _produced per wee]; to satisfy 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 753_85_,_and 95. For detailed explanation? See the diagram below. "_f"__'"_'_f' _ Assuming the company wants to maximize revenues, develop the_ LP model that will indicate the optimum Hint: There are 9 decision variables 111 this problem as shown m the tables below. weekly volumes of regular and _premium gasoline to produce. Solve the problem and write your nal answers below. Optimum Objective Function Value Z = S Optimum Solution: Regular Premium Stream 1 Stream 2 Stream 3 Byproduct 1 Byproduct 2 Byproduct 3