Consider the Following Sensitivity Report from Excel for the Model

question 36

Essay

Consider the following sensitivity report from Excel for the model in question 3, which has a profit of $5,400.

A.If Jungle Figures eliminates its policy of not producing more than twice the number of large giraffes as small giraffes, how will this affect the optimal solution?
B.Suppose 50 pounds of extra stuffing could be purchased for $200.Should Jungle do this? Would the optimal solution change?
C.Jungle is considering diverting 10 hours of machine time from the production of other products to produce giraffes.It figures it will lose $225 in gross profits from those products by this action.Should Jungle do this? Would the optimal solution change?
D.Suppose that demand is such that Jungle could effectively raise its prices to $15 on each giraffe (large or small).Would the optimal production schedule change?
E.Suppose demand for small giraffes waned, and Jungle cut its process so that its profit on small giraffes was reduced by 50% to $4.50.Would the optimal solution change?

---

Definitions:

Fearful Avoidant Attachment

Style of attachment in which people have both high anxiety and high avoidance; they have low opinions of themselves and keep others from getting close.

Narcissism

A personality trait characterized by an inflated sense of self-importance, a deep need for excessive attention and admiration, and a lack of empathy for others.

Self-Love

Self-love is the regard for one’s own well-being and happiness, often considered as a crucial part of mental health and emotional resilience.

Fearful Avoidant Attachment

A type of attachment characterized by a desire for close relationships but a fear of getting too close or being too dependent on others.