Multiple Choice
Consider the scenario given below.Use Excel solver to answer the following question(s) .
Peca Inc.is a small manufacturer of two types of office chairs,the swivel and no-swivel models.The manufacturing process consists of two principal departments: fabrication and finishing.The fabrication department has 24 skilled workers,each of whom works 7 hours per day.The finishing department has 6 workers,who also work a 7-hour shift.A swivel type requires 7 labor hours in the fabricating department and 2 labor hours in finishing.The no-swivel model requires 8 labor hours in fabricating and 3 labor hours in finishing.Peca Inc.makes a net profit of $100 on the swivel model,and $130 on the no-swivel model.The company anticipates selling at least twice as many no-swivel models as swivel models.The company wants to determine how many of each model should be produced on a daily basis to maximize net profit.
-The optimal values of the decision variables will change if the ________.
A) unit profit for no-swivel chairs either increases by more than 20 or decreases by more than 180
B) unit profit for swivel chairs either increases by more than 80 or decreases by more than 20
C) unit profit for no-swivel chairs either increases by more than 45 or decreases by more than 21
D) unit profit for swivel chairs either increases by more than 45 or decreases by more than 21
Correct Answer:

Verified
Correct Answer:
Verified
Q39: Consider the scenario given below.Use Excel solver
Q40: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB2972/.jpg" alt=" S&N wants to
Q41: In the context of linear optimization problems,define
Q42: Use the case below to answer the
Q43: Use the data given below to answer
Q45: In linear optimization,the phrase "must contain exactly"
Q46: The slack on a binding constraint will
Q47: Consider the scenario given below.Use Excel solver
Q48: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB2972/.jpg" alt=" S&N wants to
Q49: The reduced cost associated with a bounded