I'm not really sure how to structure this problem on Excel solver

1 Oil Refinery Optimization An oil refinery produces four types of raw gasoline: Alkylate, Catalytic-cracked, straight-run, and isopentane. Two important characteristics of each gasoline are its performance number PN (indicating its anti-knock properties) and its vapor pressure RVP (indicating its volatility). These two characteris- tics, together with the production levels in barrels per day are as follows: PN RVP Barrels Produced Alkylate 107 5 3814 Catalytic-Cracked 93 8 2666 Straight-Run 87 4 4016 Isopentane 108 21 1300 These gasolines can either be sold raw, at $4.83 a barrel, or blended into aviation gasolines (Avgas A and/or Avgas B). Quality standards impose certain requirements on the aviation gasolines; these requirements, together with the selling prices, are as follows: PN RVP Avgas A at least 100 at most 7 Avgas B at least 91 at most 7 Price/Barrel $6.45 $5.91 Petroleum engineers tell you that the PN and the RVP of each mixture are simply the weighted averages of the PNs and RV Ps of its constituents. 1-1 Problem [This part was done in Assignment 3. You do not need to do it again. (You can look online at assignment 3 solutions for an example solution. It is restated here just as a reminder.] Formulate a linear programming instance that will yield the largest possible profit for the refinery. (You may write a model specific for this instance. That is, a general model is not required for this problem, although you are allowed to write as much of the model as you want in general, e.g., if it is more compact. You must define any sets and parameters you use and specify their values for this instance.) 1-2 Problem Model the instance from Problem 1-1 in Excel Solver and solve it. State the optimal objective function value and describe the optimal solution