1. (50 points) Kelson Sporting Equipment, Inc. makes two 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 the profit contribution per glove are given in the following table: Model Regular model Catcher's model Cutting and Sewing 1 3/ Production Time (hours) Packaging Finishing and Shipping Y % V 4 Profit/Glove $5 $8 Develop a spreadsheet model to determine the production quantities for each glove with the aim of maximizing the profit. A B D E F G Note: The color of some cells changes to green if you get the correct answers after running the 1 Solver. 2 Production Time (hours) 3 Cutting and Sewing Finishing Packaging and Shipping Profit/Glove 4 Regular model 1 0.5 0.125 $5 5 Catcher's model 1.5 0.333333 0.25 $8 6 Time available 900 300 100 7 8 Decision Variables 9 Regular Catchers 10 Number of Gloves Produced 11 12 Constraints 13 Time Used Sign Time Available 14 Cutting and Sewing 15 Finishing 16 Packaging and Shipping 17 18 Objective 19 Profit 20 21 22