My difficulty is specifically what formulas need to be put into excel to produce the answer.

PROJECT 1 HotSprings Spas manufactures and sells two spa models: the Steamboat and the Classic. HotSprings Spas receives spa bodies from another manufacturer and then adds a pump and tubing to circulate the water. The Steamboat model demands 15.5 hours of labor and 14.5 feet of tubing. The Classic model requires 10.5 hours of labor and uses 20 feet of tubing. Based on selling patterns, the owner Deborah Liebson, has determined that the Steamboat model generates a profit of $400 per unit, and each Classic model generates $345 profit. Although Deborah would like a large labor capacity and sufficient tubing and motors to build any number of spas, her resources are limited. For the next production period, Deborah has 2,650 labor hours, 3,450 feet of tubing, and 231 pumps available. Deborah needs assistance in figuring out how many Steamboat and Classic models to build in order to maximize her profit. Given the constraints above, use Solver to assist Deborah in her what-if analysis. Deborah has provided you with a screen shot of a template you can use to get started Arial Number Delete Format 2Fiter- Select Paste Sort & Find & Font ?32 HotSprings Spas Steamboat Clossic 5 400 S 345 Quantty to produce 5 Profit per unit Total Profit 9 Constraints 10 11 Piping required (feet) 12 Pumpa required 13 15.50 10.50 14.50 20 00 Labor to build (hours) 14 Pool of evailable resources Allocated Aveilable 15 Labor 16 Piping 17 Pumps 2 650 3 450 231 19 MSpa Data2