MAT 540 Problem - The Lakeside Boatworks

The Lakeside Boatworks is planning to manafacture three types of molded fiber glass recreational boats-a 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 costs of $2,800,000 to set up its manufacturing operations and begin production. Lakeside has also 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 the 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 it must sell to break even while minimizing its total variable cost.
a. Formulate a linear programming model for this problem.
b. Solve the linear programming model that you formulated.
• (Show work in Excel spreadsheet)

-
Rating:
5/
Solution: MAT 540 Problem - The Lakeside Boatworks (Sol)