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
Q24: Consider the scenario given below.Use Excel solver
Q25: Use the data given below to answer
Q26: Consider the scenario given below.Use Excel solver
Q27: The statement,"The amount invested in online advertising
Q28: Consider the scenario given below.Use Excel solver
Q30: Consider the scenario given below.Use Excel solver
Q31: Consider the scenario given below.Use Excel solver
Q32: Use the scenario given below to answer
Q33: Consider the scenario given below.Use Excel solver
Q34: Consider the scenario given below.Use Excel solver
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents