Purchase Solution

Integer programming: The Skimmer Boat Company

Not what you're looking for?

Ask Custom Question

Using excel, please solve the following

The Skimmer Boat Company manufacturer's 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 that the other two boats combined, but no more than twice as many. The ski boat is its standard production model, and bass boats and speedboats are modifications. The company has production capacity to manufacturer 210 standard (ski-type) boats, however, a bass boat requires 1.3 times the standard production capacity, and 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 two pf which are 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.

Attachments
Purchase this Solution

Solution Summary

Logic and calculations show you how to solve for this.

Solution Preview

Hello!
The formulation of the integer programming problem is the following.

We have to maximize total profits. Calling X1 to the number of bass boats produced, X2 to the number of ski boats and X3 to the number of speedboats, we have:

Max 20500*X1 + 12000*X2 + 22300*X3

Now let's write the ...

Purchase this Solution


Free BrainMass Quizzes
Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.