Your company produces regular and supreme gasoline. Each barrel of regular sells for $21 and must have an octane rating of at least 90. Each barrel of supreme sells for $27 and must have an octane rating of at least 97. Both of these products are manufactured by simply missing different quantities of the following three input fuels. Octane Rating 100 2 87 3 110 Your company has an order to produce exactly 300,000 barrels of regular and exactly 450,000 barrels of supreme. How should the company allocate the available inputs t the production of regular and supreme gasoline if you want to maximize profits? Input 1 Cost / Barrel $17.25 $15.75 $17.25 Barrels Available 180,000 350,000 320,000

Have to use excel Solver & please provide formula put in solver.

Your company produces regular and supreme gasoline. Each barrel of regular sells for $21 and must have an octane rating of at least 90 . Each barrel of supreme sells for $27 and must have an octane rating of at least 97 . Both of these products are manufactured by simply missing different quantities of the following three input fuels. Your company has an order to produce exactly 300,000 barrels of regular and exactly 450,000 barrels of supreme. How should the company allocate the available inputs t the production of regular and supreme gasoline if you want to maximize profits