Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, could anyone help me to solve this question? Problem 2: Furniture making ( 25 marks) Westport Furniture produces a line of furniture that replicates
Hi, could anyone help me to solve this question?
Problem 2: Furniture making ( 25 marks) Westport Furniture produces a line of furniture that replicates some classic designs from the late 1800 s. Currently the company makes a rocking chair, formal dining tables and armoires. A production plan for the next week is being formulated. The company has no problem selling everything in this line that it makes. Furniture goes through two production stages - cutting/assembly and finishing. The wood used is a fine grade of cherry and its supply is limited. The table below gives the resources required for each item and the availability of each resource over the next week. Over the next week the company has available 3600 minutes of cutting/assembly time, 2000 minutes of finishing time and 4000Kg of wood. 1) Formulate the problem as a linear program. Clearly define your decision variables as a first step. 2) Enter the problem in Excel and use Solver to get the optimal solution. Include both the answer report and sensitivity report with your submission (well labeled). 3) What is the optimal profit represented by the objective function and what is the optimal production plan? 4) What are the binding constraints? 5) The company owner has promised his mother a rocking chair. What will the new profit be if tis promise is honoured? 6) The selling price of tables has suddenly decreased by $110 dollars (nothing else has changed). What will be the effect on the optimal solution? 7) An additional 100 minutes of finishing time can be purchased for an amount that is $2 above what it currently costs? Should the extra time be bought and if so, what will be the effect upon the optimal solution? 8) A fire in the wood warehouse has reduced the amount of wood by 500Kg. What will be the effect upon the optimal solutionStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started