1. Review this first: Introduction to Excel Solver. ExcelSolverNew.pptx
2. Follow the assignment instruction to finish the assignment.Solver Introduction.docx
Questions: 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 tub¬ing. Based on selling patterns, the owner, Deborah Gibson, has determined that the Steamboat model generates a profit of $400 per unit, and the Classic model generates $345 profit While 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, Debo¬rah 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 max¬imize her profit. Given the constraints above, assist Deborah in her what-if analysis.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|