Please use excel to help with this problem, Thank you!

Please also type your name and date in an Excel flle while you working on the problem. Hint: Given the information above, use Solver to assist Bo in his decisionmaking analysis. PDC Spa, Inc. manufactures and sells two spa models: The Premium and the Lifestyle. PDC Spa receives spa body part assemblies from other producers and then adds tubing and a pump circulate the water. The Premium model demands 14.75 hours of labor and 13.65 feet of tubing. The Lifestyle model requires 11.45 hours of labor and uses 18.95 feet of tubing. According to the selling records, the owner, Bo Fan, has determined that the Premium model generates a profit of $450 per unit, and the Lifestyle model generates $380 profit. Although Bo would like to maximize the utilization of labor capacity and sufficient tubing and pumps to build any number of spas, his resources are limited. For the next production period, Bo has 2,760 labor hours, 3,654 feet of tubing, and 230 pumps available. Question: Bo needs your assistance in figuring out how many Premium and Lifestyle models to build in order to maximize his profit? Make Unconstrained Variables Non-Negative Select a Solving Method: Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth