Question 2 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. Assembly Rocking Chair Dining 180 Room Table Armoire Available 100 120 3,600 (minutes) Finishing 60 80 80 2,000 (minutes) Wood 30 180 120 4,000 (pounds) 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 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. 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?……………… h) Is the problem degenerate? Explain!❤ i) Are there alternative optima in this problem? Explaine i) What value should be in the slack column that is given by ????◄
Question 2 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. Assembly Rocking Chair Dining 180 Room Table Armoire Available 100 120 3,600 (minutes) Finishing 60 80 80 2,000 (minutes) Wood 30 180 120 4,000 (pounds) 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 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. 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?……………… h) Is the problem degenerate? Explain!❤ i) Are there alternative optima in this problem? Explaine i) What value should be in the slack column that is given by ????◄
Chapter19: Pricing Concepts
Section: Chapter Questions
Problem 6DRQ
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
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
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
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