# Solved-Lakeside-Boatworks-is-planning-to-manufacture-three-types-of-molded-fiberglass-recreational-boats-fishing-(bass-boat),-a

#### ByDr. Raju Chaudhari

Oct 6, 2020

Lakeside Boatworks is planning to manufacture three types of molded fiberglass recreational boats-fishing (bass boat), a ski boat, and a small speedboat. The estimated selling price and variable cost for each type of boat are summarized in the following table:

boat Variable cost selling price
Bass \$12,500 \$23,000
Ski \$8,500 \$18,000
Speed \$13,700 \$26,000

The company has incurred fixed cost of \$2,800,000 to set up its manufacturing operation and begin production. Lakeside has entered into agreements with several boat dealers in the region to provide a minimum of 70 bass boats, 50 ski boats, and 50 speedboats. Alternatively, the company is unsure of what actual demand will be, so it has decided to limit production to no more than 120 of any one boat. The company wants to determine the number of boats that is must sell to break even while minimizing its total variable cost. a. Formulate a linear programming model for this problem. b. Solve the model by using the computer. #### Solution Let$X_1$= number of bass boats,$X_2$= number of ski boats ,$X_3$= number of speed boats. Number to manufacture$X_1\geq 70$and$X_1\leq 120X_2\geq 50$and$X_2\leq 120X3\geq 50$and$X_3\leq 120$In order to break even, the total revenue must equal total cost:$23,000X_1 + 18,000X_2 + 26,000X_3 = 12,500X_1 + 8,500X_2 + 13,700X_3 + 2,800,000$. That is$10,500 X_1 + 9,500X_2 + 12,300X_3 = 2,800,000$That is$105X_1 + 95X_2 + 123X_3 = 28000$The objective function is Minimize$Z = 12500 X_1 + 8500 X_2 + 13700 X_3So the formulated LPP is  \begin{aligned} \text{Minimize } Z &= 12500 X_1 + 8500 X_2 + 13700 X_3\\ \text{Subject to} & \\ & 105X1 + 95X2 + 123X3 = 28000\\ & X_1\geq 70 \\ & X_1\leq 120 \\ & X_2\geq 50 \\ & X_2\leq 120 \\ & X_3\geq 50 \\ & X_3\leq 120 \end{aligned}  See the attached Excel file for complete solution using Solver.X_1$= number of bass boats = 70$X_2$= number of ski boats = 120$X_3$= number of speed boats = 75.203$\approx$75 The minimum value of the objective function is Z = \$2925285

Excel Solver file : Boat LPP