View the step-by-step solution to:

The Lakeside Boatworks is planning to manufacture three types of molded fiber glass recreational boats-a fishing (bass) boat, a ski boat, and a small...

I am having problems with how to set up the constraints in the excel format

The Lakeside Boatworks is planning to manufacture 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 operation and begin production. Lakeside has also entered into agreement with several boat dealers in the region to provide a minimum of 70 bass boats, 50 ski boats, and 50 speed boats. 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 it 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.
Background image of page 1

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question