PLEASE COMPLETE WORK IN EXCEL SPREADSHEET ONLY. SHOW ALL FORMULAS/FUNCTIONS TO SHOW ANSWERS (SCREENSHOTS) AND EXPLAIN TO ME HOW YOU GOT THE ANSWER. DO NOT WRITE IT DOWN IN A PIECE OF PAPER.

Question: The Jean-Pierre Amor Company manufactures two lines of designer yard gates, called Model A and Model B. Every gate requires blending a certain amount of steel and zinc; the company has available a total of 25,000 lb of steel 6,000 lb of zinc. Each model A gate requires a mixture of 125 lb of steel and 20 lb of zinc. , and each yields a pofit of $90 . Each model B gate requires 100 lb of steel and 30 lb of zinc and can be sold for a profit of $70.

a. State the objective function

b. State the constraints

c. Solve the quantity for A & B that would yield the highest profit.