Answer all parts except (b). Be sure to include the formulation in a textbox along with the original optimal solution and optimal value. Create and include the Sensitivity Report. Use it to answer parts d, and e.

BathBros Inc. produces tubs and showers. Each product requires manufacturing and testing. Tubs require 18 minutes for manufacturing and 9 minutes for testing. Showers require 9 minutes for manufacturing and 18 minutes for testing. The capacity of the facility is 9,090 minutes of manufacturing and 7,110 minutes of testing. The unit profit from tubs and showers are \$200 each. a. Formulate the LP model. b. Solve this problem graphically. Do not use Excel Solver. How many of each should BathBros Inc. produce to maximize profit? tubs = showers = What is the maximum profit? For parts ce, set up a spreadsheet model and use Solver to find the optimal solution. Use the Solver output and sensitivity reports to answer the questions. Answer d and e independent of each other without resolving the problem. Turn in your spreadsheet model and reports. c. How many of each type should BathBros Inc. produce to maximize profit? tubs=showers= What is the maximum profit? d. Due to a change in marketing strategy, showers are priced differently such that the unit profit changed to $250. Would the optimal product mix change? How will this affect the optimal value? At what minimum increased profit for showers would the company consider changing its production plan? e. An electrical outage in one of the testing bays has reduced the available testing time to 6,000 minutes. Without resolving the problem: Will the optimal solution change? How will this affect the optimal value