Question: Use the following to answer questions 5 - 7 : A wood products firm uses available time at the end of each week to make

Use the following to answer questions 5-7:
A wood products firm uses available time at the end of each week to make goods for stock.
Currently, two products on the list of items are produced for stock: a chopping board and a
knife holder. Both items require three operations: cutting, gluing, and finishing. The manager
of the firm has collected the following data on these products.
The manager has also determined that, during each week, 56 minutes are available for cutting,
650 minutes are available for gluing, and 360 minutes are available for finishing.
The goal is to maximize profit. Excel solver has generated the following solution/report for us.
Based on the report above, please answer the following questions:
Which resources are not completely used by your solution? How much of each resources
is unused?
How much additional profit you can get if additional 24 minutes of cutting time is
available? How much additional profit you can get if additional 100 minutes of gluing
time is available? Please provide reasoning by citing info from the sensitivity report
(instead of rerunning the solver).
If the profit per unit for knife holder has been changed from $6 to be $5.5, how would
this change your decision?_Please provide reasoning by citing info from the sensitivity
report (instead of rerunning the solver).
 Use the following to answer questions 5-7: A wood products firm

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!