management science. please explain step by step

3) Arctic Spas, Inc. produces three types of hot tubs Aqua Plunge, Artesian, and Clearwater. Marketing wants no more than 250 Clearwater tubs made. The tubs are produced in the welding depertincnt usine pumps and tubing. Adjustable Cells Constraints Using the LP formulation and the solution provided by Excel's solver to answer the following: (30 points) Do not run or try re-solve this problem, you will get wrong numbers. This is to be done all manually. Show your calculations a. Aretic Spas can increase the available welding hours by 115 by hiring temporary workers. Temporary workers are usually paid $10/ hour. Should Arctic Spa hire these workers? If so what is the impact on the current profit number? b. Marketing has suggested a new product- the Deck Spa tub that would require 2.5 hours of welding time, 1 pumps, and 2.3lbs. of metal tubing. What contribution (profit) must this new product have to make it attractive to produce this season? c. If the profit from the Aqua Plunge decreases by $5.00, what will be the impact? What is the new total profit number? number? d. Marketing wants to increase the maximum number of Clearwater tubs from 250 to 264 . How will this affect the solution? Management found out that the profit margin for Clearwater is actually $56/ unit, instead of $60/ unit and the profit margin for Artesian is \$34/unit instead of \$28/unit and wants to know how the new (correct) profit margins will affect the solution. Will the quantities change? What is the new profit number