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 :
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, minutes are available for cutting,
minutes are available for gluing, and minutes are available for finishing.
The goal is to maximize profit. Excel solver has generated the following solutionreport 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 minutes of cutting time is
available? How much additional profit you can get if additional 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 $ to be $ how would
this change your decision?Please provide reasoning by citing info from the sensitivity
report instead of rerunning the solver
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
