Refer to the Kelson Sporting Equipment problem $($Chapter $2,$ Problem $24$ in the recommended textbook$).$

Kelson Sporting Equipment, Inc. makes two different types of baseball gloves: a regular model and a catcher's model. The firm has $900$ hours of production time available in its cutting and sewing department, $300$ hours available in its finishing department, and $100$ hours available in its packaging and shipping department. The production time requirements and profit contribution per glove are given in the following table:

Production Time $($hours$)$

Model Cutting and Sewing Finishing Packaging and Shipping Profit$/$Glove

Regular model $11/21/8$ $$5$

Catcher's model $3/21/31/4$ $$8$

Let R $=$ number of regular gloves

C $=$ number of catcher's mitts

leads to the following formulation:

Max $5$R $+8$C

s$.$t$.$ R $+3/2$C $<=900$ Cutting and sewing

$1/2$R $+1/3$C $<=300$ Finishing

$1/8$R $+1/4$C $<=100$ Packaging and shipping

R$,$ C $>=0$

The LP model is entered and solved via Excel Solver. Use the attached Excel file to generate the computerized sensitivity analysis report.