Kelson makes two types of baseball gloves: a regular model and a catcher's model. The firm

has $800$ hours of production time available in its cutting and sewing department, $200$ hours

available in its finishing department, and $80$ hours available in its packaging and shipping

department. The production time requirements and the profit contribution per glove are

given in the following table:

Assuming that the company is interested in maximizing the total profit contribution, develop

a spreadsheet model and find the optimal solution using Excel Solver.

How many Regular and Catchers gloves should Kelson manufacture? Please answer as

an integer with no decimal place.

Regular:

Catcher:

What is the maximum total profit contribution Kelson can earn with the optimal production

quantities $($integer dollar value without the dollar sign$)?$

Max Total Profit Contribution:

Please interpret the shadow price of the Finishing Time constraint. if you increased the

available finishing time by $1$ hour, then the profit will increase by $($integer value only, no

dollar sign$)$:

Profit increase: