table.

Max

s$.$t$.$

cutting and sewing

finishing

packaging and shipping

$R,C0$

$($b$)$ Develop a spreadsheet model and find the optimal solution using Excel Solver. How many of each model should Kelson manufacture?

regular model

gloves

catcher's model

gloves

$($c$)$ What is the total profit contribution $($in dollars$)$ Kelson can earn with the optimal production quantities?

$

$($d$)$ How many hours of production time will be scheduled in each department?

cutting and sewing

finishing

packaging and shipping

hours

hours

hours

$($e$)$ What is the slack time $($or unused time$)$ in hours in each department?

cutting and sewing

hours

finishing

$|$ hours

packaging and shipping

$]$hours