Consider the Scenario Given Below

question 44

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

---

Definitions:

Symbolic Attributes

Qualities or features of an object or entity that represent or stand for something else, carrying additional meaning beyond their inherent traits.

Gestalt

A psychological theory that emphasizes the human mind and behavior as being organized into wholes, where the perceived whole is different from and often more than the sum of its parts.

Stimuli

External events or occurrences that can elicit responses from sensory organs, leading to various forms of responses in an organism.

Gestalt Psychology

A psychological approach that emphasizes the holistic and intrinsic properties of perceptual phenomena, focusing on patterns and configurations.