Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Colonial Furniture produces hand-crafted colonial style furniture. Plans are now being made for the production of rocking chairs, dining room tables, and/or armoires for the

Colonial Furniture produces hand-crafted colonial style furniture. Plans are now being made for the production of rocking chairs, dining room tables, and/or armoires for the next week. These products go through two stages of production (assembly and finishing). The following table gives the time required for each item to go through these two stages, the amount of wood required, and the corresponding unit profits, along with the amount of each resource available next week.

Rocking Chair

(RC)

Dining Room Table (DRT) Armoire (ARM) Available
Assembly (minutes) 100 180 120 3,600
Finishing (minutes) 60 80 80 2,000
Wood (pounds) 30 180 120 4,000
Unit Profit $240 $720 $600

A linear programming model has been formulated in a spreadsheet to determine the production levels that would maximize profit. The Answer Report and the Sensitivity Report from that analysis are shown here:

Answer Report:

Sensitivity Report:

For each of the following parts, answer the question as specifically and completely as possible without re-solving the problem with Solver. Note: Each part is independent (i.e., any change made in one problem part does not apply to any other parts).

  1. Suppose the profit per armoire decreases by $50. Will this change the optimal production quantities? Why? Why not? Will it change the overall profit? If so, by how much?
  2. Suppose that a part-time worker in the assembly department calls in sick, so that now 4 fewerhours are available that day in the assembly department. How much would this affect total profit? Would it change the optimal production quantities? Why? Why not?
  3. The shadow price for the wood constraint is zero. Why is that?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting For Non-Accountants

Authors: David Horner

12th Edition

1789664306, 9781789664300

More Books

Students also viewed these Accounting questions