(b) Develop a spreadsheet model and find the optimal solution using Solver. How many gloves of each model should Kelson manufacture? Regular Model = Catcher's Model = (c) What is the total profit contribution Kelson can earn with the given production quantities? * Finishing units (d) How many hours of production time will be scheduled in each department? Department Production Time (Hours) * Cutting and Sewing Packing and Shipping units Finishing (e) What is the slack time in each department? If your answer is zero, enter "0". Department Slack Time (Hours) Cutting and Sewing **

(b) Develop a spreadsheet model and find the optimal solution using Solver. How many gloves of each model should Kelson manufacture? Regular Model = units Catcher's Model = units (c) What is the total profit contribution Kelson can earn with the given production quantities? (d) How many hours of production time will be scheduled in each department? (e) What is the slack time in each department? If your answer is zero, enter " 0 ". (b) Develop a spreadsheet model and find the optimal solution using Solver. How many gloves of each model should Kelson manufacture? Regular Model = units Catcher's Model = units (c) What is the total profit contribution Kelson can earn with the given production quantities? (d) How many hours of production time will be scheduled in each department? (e) What is the slack time in each department? If your answer is zero, enter " 0