Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sanderson Manufacturing produces ornate, decorative wood frame doors and windows. Each item produced goes through three manufacturing processes: cutting, sanding, and finishing. Each door produced

Sanderson Manufacturing produces ornate, decorative wood frame doors and windows. Each item produced goes through three manufacturing processes: cutting, sanding, and finishing. Each door produced requires 1 hour in cutting, 30 minutes in sanding, and 30 minutes in finishing. Each window requires 30 minutes in cutting, 45 minutes in sanding, and 1 hour in finishing. In the coming week Sanderson has 40 hours of cutting capacity available, 40 hours of sanding capacity, and 60 hours of finishing capacity. Assume all doors produced can be sold for a profit of $550 and all windows can be sold for a profit of $350. Formulate an LP model, then use Solver to create Answer and Sensitivity Reports for your model and answer the following questions. (a) If the profit on doors increased to $600 would the optimal solution change? Yes No (b) If the profit on windows decreased to $225 would the optimal solution change? Yes No (c) Explain the shadow price (in dollars) for the finishing process. The shadow price for the finishing process is $ This is because in the optimal solution not all of the available finishing time has been used up. So, we would expect an increase to the amount of time available for finishing to result in no change to the optimal profit. (d) If 24 additional hours of cutting capacity became available, how much additional profit (in dollars) could the company earn? $ (e) Suppose another company wanted to use 14 hours of Sanderson's sanding capacity and was willing to pay $250 per hour to acquire it? Should Sanderson agree to this? (Enter your answer as a positive number in dollars.) Sanderson should agree to this since it would increase Sanderson's total profit by $ . How (if at all) would your answer change if the company instead wanted 25 hours of sanding capacity? (Enter your answer as a positive number in dollars.) Our answer be the opposite since this would decrease Sanderson's total profit by $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Lets break this problem down into steps to formulate the Linear Programming LP model solve it using a solver and address each of the questions Step 1 Define Variables Let x be the number of doors prod... 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

Step: 3

blur-text-image

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

Getting Clinical Audit Right To Benefit Patients

Authors: Healthcare Quality

1st Edition

1873543069, 978-1873543061

More Books

Students also viewed these Accounting questions

Question

Describe the various types of research designs.

Answered: 1 week ago