A furniture maker sells three different styles of cabinets, including an Italian model, a French Country model,

Question:

A furniture maker sells three different styles of cabinets, including an Italian model, a French Country model, and a Caribbean model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table at the top of this page contains all relevant information concerning production times (hours per cabinet), production capacities for each operation per day, and profit ($ per unit). The owner has an obligation to deliver a minimum of 60 cabinets in each style to a furniture distributor. He would like to determine the product mix that maximizes his daily profit. Formulate the problem as an LP model and solve using Excel.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Managerial Decision Modeling With Spreadsheets

ISBN: 9780136115830

3rd Edition

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

Question Posted: