Homework Help is Here – Start Your Trial Now!
Business
Management
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 ????◄

Understanding Business
Understanding Business
12th Edition
ISBN:9781259929434
Author:William Nickels
Publisher:William Nickels
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
See similar textbooks
icon
Related questions
Question
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 ????◄
Transcribed Image Text: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 ????◄
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Understanding Business
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
Business Essentials (12th Edition) (What's New in…
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON
SEE MORE TEXTBOOKS