1. It costs a company 50 cents to product a gallon of regular gasoline and 70 cents to produce a gallon of premium gasoline. The companys 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 gallon of ingredient S in production, respectively.
   1. Write the Linear Program.

All in Excel please!