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 hour in cutting, minutes in sanding, and minutes in finishing. Each window requires minutes in cutting, minutes in sanding, and hour in finishing. In the coming week Sanderson has hours of cutting capacity available, hours of sanding capacity, and hours of finishing capacity. Assume all doors produced can be sold for a profit of $ and all windows can be sold for a profit of $
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 $ would the optimal solution change?
Yes
No
Correct: Your answer is correct.
b
If the profit on windows decreased to $ 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 $
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 additional hours of cutting capacity became available, how much additional profit in dollars could the company earn?
$
Incorrect: Your answer is incorrect.
e
Suppose another company wanted to use hours of Sanderson's sanding capacity and was willing to pay $ 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 $
Incorrect: Your answer is incorrect.
How if at all would your answer change if the company instead wanted 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 $
Changed: Your submitted answer was incorrect. Your current answer has not been submitted.
Machine Country Contemporary Total Machine Minutes
Available per Week
Router
Sander
Polisher
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
