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 over the next week. These products go through two stages of production (assembly and finishing). The table in the next column gives the time required for each item to go through these two stages, the amount of wood required (fine cherry wood), and the corresponding unit profits, along with the amount of each resource available next week. Dining Assembly (minutes) Finishing (minutes) Wood (pounds) Unit Profit Rocking Chair 100 60 30 $240 Room Table 180 80 180 $720 Armoire 120 80 120 $600 a) What is the optimal solution in words? b) 350 pounds of wood were lost. Evaluate the effect. c) An extra 4 hour of finishing was available. Evaluate the effect. Available 3.600 2,000 A linear programming model has been formulated in a spreadsheet to determine the production levels that would maximize profit. The solved spreadsheet model and corresponding sensitivity report are shown below. Answer the following questions (a-i) using the output please be brief. If there are two possible answers one will suffice. Where necessary a range analysis must be shown. 4,000 d) Because of sickness of I worker in the assembly dept, 4 hours of assembly was lost, evaluate the effect. h) Is the problem degenerate? Explain! i) Are there alternative optima in this problem? Explain i) What value should be in the slack column that is given by ???? e) If the profit of armoire decrease by $50.00. Evaluate the effect? f) What is the situation if the company want to produce Chair ? Evaluate the effect g) If the profit of table decrease by $60.00 and profit of armoire increase by 90. Evaluate the effect?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
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 over the next week.
These products go through two stages of production (assembly and finishing). The table in
the next column gives the time required for each item to go through these two stages, the
amount of wood required (fine cherry wood), and the corresponding unit profits, along with
the amount of each resource available next week.
Dining
Assembly
(minutes)
Finishing
(minutes)
Wood
(pounds)
Unit Profit
Rocking
Chair
100
60
30
$240
Room Table
180
80
180
$720
Armoire
120
80
120
$600
Available
3,600
2,000
4,000
A linear programming model has been formulated in a spreadsheet to determine the
production levels that would maximize profit. The solved spreadsheet model and
corresponding sensitivity report are shown below.
Answer the following questions (a-i) using the output please be brief. If there are two
possible answers one will suffice. Where necessary a range analysis must be shown.
a) What is the optimal solution in words?
b) 350 pounds of wood were lost. Evaluate the effect.
c) An extra 4 hour of finishing was available. Evaluate the effect.
d) Because of sickness of 1 worker in the assembly dept, 4 hours of assembly was lost,
evaluate the effect.
h) Is the problem degenerate? Explain!
i) Are there alternative optima in this problem? Explain
i) What value should be in the slack column that is given by ????
e) If the profit of armoire decrease by $50.00. Evaluate the effect?
f) What is the situation if the company want to produce Chair ? Evaluate the effect
g) If the profit of table decrease by $60.00 and profit of armoire increase by 90.
Evaluate the effect?
Transcribed Image Text: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 over the next week. These products go through two stages of production (assembly and finishing). The table in the next column gives the time required for each item to go through these two stages, the amount of wood required (fine cherry wood), and the corresponding unit profits, along with the amount of each resource available next week. Dining Assembly (minutes) Finishing (minutes) Wood (pounds) Unit Profit Rocking Chair 100 60 30 $240 Room Table 180 80 180 $720 Armoire 120 80 120 $600 Available 3,600 2,000 4,000 A linear programming model has been formulated in a spreadsheet to determine the production levels that would maximize profit. The solved spreadsheet model and corresponding sensitivity report are shown below. Answer the following questions (a-i) using the output please be brief. If there are two possible answers one will suffice. Where necessary a range analysis must be shown. a) What is the optimal solution in words? b) 350 pounds of wood were lost. Evaluate the effect. c) An extra 4 hour of finishing was available. Evaluate the effect. d) Because of sickness of 1 worker in the assembly dept, 4 hours of assembly was lost, evaluate the effect. h) Is the problem degenerate? Explain! i) Are there alternative optima in this problem? Explain i) What value should be in the slack column that is given by ???? e) If the profit of armoire decrease by $50.00. Evaluate the effect? f) What is the situation if the company want to produce Chair ? Evaluate the effect g) If the profit of table decrease by $60.00 and profit of armoire increase by 90. Evaluate the effect?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 6 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.