Please solve using excel and show screenshots for formulas and formatting

Will downvote if not done on excel

Thank you!

20. Photo Chemicals produces two types of photograph-developing fluids at a cost of $1.00 per gallon. Let Xi = gallons of product 1 x2 = gallons of product 2 Photo Chemicals management requires that at least 30 gallons of product 1 and at least 20 gallons of product 2 be produced. They also require that at least 80 pounds of a perish- able raw material be used in production. A linear programming formulation of the problem is as follows: Min 1x; + 1x2 s.t. 1x1 > 30 Minimum product 1 1x2 = 20 Minimum product 2 1x; + 2x2 = 80 Minimum raw material X1, X2 20 a. c. Write the dual problem. b. Solve the dual problem. Use the dual solution to show that the optimal production plan is x = 30 and x2 = 25. The third constraint involves a management request that the current 80 pounds of a perishable raw material be used. However, after learning that the optimal solution calls for an excess production of five units of product 2, management is reconsidering the raw material requirement. Specifically, you have been asked to identify the cost effect if this constraint is relaxed. Use the dual variable to indicate the change in the cost if only 79 pounds of raw material have to be used