Question: I need to know the dollar amount for question E Sanderson's profit for both parts of this question. Sanderson Manufacturing produces ornate, decorative wood frame

I need to know the dollar amount for question E Sanderson's profit for both parts of this question. 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 $450 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
Correct: Your answer is correct.
(b)
If the profit on windows decreased to $175 would the optimal solution change?
Yes
No
Correct: Your answer is correct.
(c)
Explain the shadow price (in dollars) for the finishing process.
The shadow price for the finishing process is $
0
Correct: Your answer is correct.
. This is because in the optimal solution
not all of
Correct: Your answer is correct.
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
Correct: Your answer is correct.
change to the optimal profit.
(d)
If 18 additional hours of cutting capacity became available, how much additional profit (in dollars) could the company earn?
$5853.60
Incorrect: Your answer is incorrect.
(e)
Suppose another company wanted to use 16 hours of Sanderson's sanding capacity and was willing to pay $350 per hour to acquire it? Should Sanderson agree to this? (Enter your answer as a positive number in dollars.)
Sanderson
should
Correct: Your answer is correct.
agree to this since it would
increase
Correct: Your answer is correct.
Sanderson's total profit by $
5600
Incorrect: Your answer is incorrect.
.
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
Correct: Your answer is correct.
since this would
decrease
Correct: Your answer is correct.
Sanderson's total profit by $
8750
Changed: Your submitted answer was incorrect. Your current answer has not been submitted.
.Machine Country Contemporary Total Machine Minutes
Available per Week
Router 1.52.01,000
Sander 3.04.52,000
Polisher 2.51.51,500

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!