The Skimmer Boat Company manufactures three kinds of molded fiberglass recreational boats--a bass fishing boat, a ski boat, and a speedboat

Subject:BusinessPrice:4.86 Bought9

Share With

The Skimmer Boat Company manufactures three kinds of molded fiberglass recreational boats--a bass fishing boat, a ski boat, and a speedboat. The profit for a bass boat is $20,500, the profit for a ski boat is $12,000, and the profit for a speedboat is $22,300. The company believes it will sell more bass boats than the other two boats combined but no more than twice as many. The ski boat is its standard production mode, and bass boats and speedboats are modifications. The company has production capacity to manufacture 210 standard (ski-type) boats; however, a bass boat requires 1.3 times the standard production capacity, and a speedboat requires 1.5 times the normal production capacity. In addition, only 160 of the high-powered engines that are installed in the bass boats and 2 of those installed in the speedboats are available. The company wants to know how many boats of each type to produce to maximize profit. Formulate and solve an integer programming model for this problem.

Please provide screenshots of excel used to solve the problem and show formulas used. Also provide a screenshot of the solver parameters showing constraints.