# The Classic Furniture Company is trying to determine the optimal quantities to make of six possible products:

## Question:

The Excel layout and LP Sensitivity Report for Classic Furniture’s problem are shown in Screenshots 4-13A and 4-13B, respectively. The objective function coefficients in the Screenshots refer to unit profit per item. Each of the following questions is independent of the others.

(a) What is the profit represented by the objective function, and what is the production plan?

(b) Which constraints are binding?

(c) What is the range over which the unit profit for oak chairs can change without changing the production plan?

(d) What is the range over which the amount of available oak could range without changing the combination of binding constraints?

(e) Does this Sensitivity Report indicate the presence of multiple optima? How do you know?

(f) After production is over, how many pounds of cherry wood will be left over?

(g) According to this report, how many more chairs were made than were required?

Fantastic news! We've Found the answer you've been seeking!

## Step by Step Answer:

**Related Book For**

## Managerial Decision Modeling With Spreadsheets

**ISBN:** 718

3rd Edition

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