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:

Discrimination

Unjust or prejudicial treatment of different categories of people, especially on the grounds of race, age, sex, or disability.

Servicemen

Members of the armed forces who are serving their country, including personnel from the army, navy, air force, and other military branches.

Black Recruits

African American individuals who were enlisted into military service, often highlighting their participation in conflicts such as the Civil War and World Wars despite facing discrimination.

Union Army

The military land force that fought for the Northern states during the American Civil War, opposing the Confederate Army.