PRACTICE ASSIGNMENT- Quantitative Methods for Business Decision

I'm needing help setting up the problem in Excel. Could you do it in Excel and send the picture to me?

It costs a company 50 cents to produce a gallon of regular gasoline and 70 cents to produce a gallon of premium gasoline. The company's minimum weekly production capacity is 3000 gallons. There are three ingredients that go into production. For ingredient P, there are 2200 gallons available. Each regular gallon requires 0.6 gallons of ingredient P and each premium gallon requires 0.8 gallons of ingredient P. There are 1100 gallons available of ingredient E. For each gallon of regular, 0.3 gallon of ingredient E are used and for each gallon of premium, 0.1 gallon of ingredient E are used. For ingredient S, there are 250 gallons available. A gallon of regular and a gallon of premium require 0.1 and 0.05 gallons of ingredient S in production, respectively. Write the Linear Program.

Here's an example of what the Excel sheet is supposed to look like.... (just an example, not for this problem)

Stocks Mutual Funds Gold Bond Crypto

Invest in

Return 0.15 0.12 0.1 0.07 0.18 0

s.t.

Total fund 1 1 1 1 1 0 <= 10

Max. Crypto 1 0 <= 2

Min. Mutal Fund 1 0 >= 1

Min. gold + bond -0.3 -0.3 0.7 0.7 -0.3 0 >= 0.3

Min. stock 0.75 -0.25 -0.25 -0.25 -0.25 0 >= 0.25