Schriever Cabinet Specialties produces wall shelves, bookends, and shadow boxes. It is necessary to plan the production schedule for next week. The wall shelves, bookends, and shadow boxes are made of oak, of which the company currently has 600 board feet. A wall shelf requires 4 board feet, bookends require 2 board feet, and a shadow box requires 3 board feet. The company has a power saw for cutting the oak boards; a wall shelf requires 30 minutes, bookends require 15 minutes, and a shadow box requires 15 minutes. The power saw is available for 32 hours next week. After cutting, the pieces are hand-finished in the finishing department, which consists of four skilled and experienced craftsmen, each of whom can complete any of the products. A wall shelf requires 30 minutes of finishing, bookends require 60 minutes, and a shadow box requires 90 minutes. The finishing department is expected to operate for 80 hours next week. Wall shelves sell for $29.95 and have a unit variable cost of $17.95; bookends sell for $11.95 and have a unit variable cost of $4.95; a shadow box sells for $16.95 and has a unit variable cost of $8.95. The company has a commitment to producing 10 wall shelf units for the Languages and Literature Department. The firm normally operates to achieve maximum contribution.

a. What are the decision variables of this problem (name them)?
b. What are the constraints of this problem (name them)?
c. Write out the objective and the constraints for this problem.
d. Solve the problem using Excel Solver

Answer rating: 100% (QA)

Let the number of wall shelves produced be ... View the full answer