Please, i need the answer for question #3 in excel workbook. thank you.

SHOW ALL WORK IN EXCEL WORKBOOK 3. The Marriott Tub Company manufactures two lines of bathtubs, called model A and model B. Every tub requires blending a certain amount of steel and zinc; the company has available a total of 25,000 pounds of steel and 6,000 pounds of zinc. Each model A bathtub requires a mixture of 125 pounds of steel and 20 pounds of zinc, and each yields a profit to the firm of $90. Each model B tub produced can be sold for a profit of $70; it in turn requires 100 pounds of steel and 30 pounds of zinc. Given information can be set up as shown below: The Marriott Tub Company BATHTUBS Blending Steel Zinc Model A Model B 125 100 20 30 Max Capacity Model A Model B Total Decision Variable Contribution(Profit) 90 70 Steel Zinc 125 20 100 30 25000 6000 Using Solver, find the optimal production mix of bathtubs to maximize the Contribution (Profit). 4. Given the table below, use Goal Seek to find the Revenue for Product C, given a Total Target Contribution of $150,000: PRODUCTS PRODUCTA PRODUCTB PRODUCTC REVENUE $ 300,000.00 $180,000.00 %CONTRIBUTION CONTRIBUTION 20% 25% 15% TOTAL TARGET $ 150,000.00