Bloomington Bounce Co produces three models of trampolines for home use, a Round trampoline, a Rectangle trampoline, and a Square trampoline. Due to recent events, they are expecting a high demand for this product this summer. There are several resources that go into producing trampolines. The first, and most expensive resource, is labor assembling these trampolines to the highest safety standards is critical, and it requires skilled labor. There are 750 hours of labor available, at a cost of $12.00 per hour. Steel tubing is used to make the frames and legs for the trampolines. There are 2500 units of steel tubing available, at a cost of $3.00 per unit. Each trampoline will require lots of springs to attach the mat to the steel tubing frame. There are 3000 springs available at a cost of $1.00 each, and finally each trampoline will require a mat. There are 10,000 square feet of mat available, at a cost of $0.75 per square foot. In addition to the material constraints, they already have 5 orders for Square trampolines, so make sure the production plan includes at least 5 Square trampolines.

Build a linear programming model and use Solver to determine the optimal mix of trampolines to produce to generate the maximum profit within the given constraints.

Reference to Total Profit Reference to Total Labor Hours Used Reference to Total Steel Tubing Used Reference to Total Springs Used Reference to Total Cost Total Square Trampolines produced Inputs Labor hours per Item Steel Tubing Springs Trampoline Mat Materials Available Cost per Unit of Material 750 $ 12.00 2500 $ 3.00 3000 $ 1.00 10000 $ 0.75 Round Rectangle 9 8 Square 10 30 40 30 Labor hours per Item Steel Tubing Springs Trampoline Mat Selling Price per Unit 40 50 45 75 375.00 $ 85 139 $ 325.00 $ 400.00 Reference to Total Profit Reference to Total Labor Hours Used Reference to Total Steel Tubing Used Reference to Total Springs Used Reference to Total Cost Total Square Trampolines produced Inputs Labor hours per Item Steel Tubing Springs Trampoline Mat Materials Available Cost per Unit of Material 750 $ 12.00 2500 $ 3.00 3000 $ 1.00 10000 $ 0.75 Round Rectangle 9 8 Square 10 30 40 30 Labor hours per Item Steel Tubing Springs Trampoline Mat Selling Price per Unit 40 50 45 75 375.00 $ 85 139 $ 325.00 $ 400.00