PLEASE SOLVE THIS USING EXCEL. PLEASE DO NOT WRITE IT ON PAPER. PLEASE HELP UNDERSTAND THE SOLUTION STEP BY STEP

PLEASE USE EXCEL OR DO NOT SOLVE IT

1- A factory makes a solvent and a fuel additive that is derived from HPDTC (deemed as toxic). Given: Production cost of solvent is $8 per gallon Profit contribution of solvent $12 per gallon Production cost of fuel additive $4 per gallon Profit contribution of fuel additive $15 per gallon Each gallon of solvent needs 4 pounds (lbs) of HPDTC and about 2.5 labor hours Each gallon of fuel additive needs 1 pound (lbs) of HPDTC and about 4 labor hours per gallon Based on the legal contract, the factory will get 600 pounds (lbs) of HPDTC for the coming week's production need. Moreover, 1200 labor hours will be made available for next week. The terms have listed 4 goals: Goal 1. as HPDTC is toxic, there can be no leftover amount of this Goal 2. no labor overtime hours will be given Goal 3a. there a need to get a min weekly profit of $3,600 Goal 3b. the weekly production target cost should not go above $1,000 for both solvent and fuel additive NOTE: Goal 3a. and 3b. hold equal priority a. Please type up a LPP model with clearly defined variables b. Solve this model using EXCEL SOLVER