Answered step by step
Verified Expert Solution
Link Copied!

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?

image text in transcribed 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 solution

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_2

Step: 3

blur-text-image_3

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

Fundamentals Of Futures And Options Markets

Authors: John C. Hull

5th Edition

0131445650, 9780131445659

More Books

Students also viewed these Finance questions