Include formulas for correct answers

Note: The color of some cells changes to green if you get the correct answers after running the Solver. Regular model Catcher's model Time available Production Time (hours) Cutting and Sewing Finishing Packaging and Shipping Profit/Glove 1 0.5 0.125 $5 1.5 0.33333 0.25 $8 900 300 100 Decision Variables Regular Catchers Number of Gloves Produced Constraints Time Used Sign Time Available Cutting and Sewing Finishing Packaging and Shipping Objective Profit Provide answer to the following questions using Excel. Once finished, make sure you have saved your works and they are closed, then submit your Excel file to the Blackboard. Please note that your Excel file should contain all the required formula that you used to get the answer. 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 % Production Time (hours) Packaging Finishing and Shipping / 8 Yo 14 Profit/Glove $5 $8 Develop a spreadsheet model to determine the production quantities for each glove with the aim of maximizing the profit. Note: The color of some cells changes to green if you get the correct answers after running the Solver. Regular model Catcher's model Time available Production Time (hours) Cutting and Sewing Finishing Packaging and Shipping Profit/Glove 1 0.5 0.125 $5 1.5 0.33333 0.25 $8 900 300 100 Decision Variables Regular Catchers Number of Gloves Produced Constraints Time Used Sign Time Available Cutting and Sewing Finishing Packaging and Shipping Objective Profit Provide answer to the following questions using Excel. Once finished, make sure you have saved your works and they are closed, then submit your Excel file to the Blackboard. Please note that your Excel file should contain all the required formula that you used to get the answer. 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 % Production Time (hours) Packaging Finishing and Shipping / 8 Yo 14 Profit/Glove $5 $8 Develop a spreadsheet model to determine the production quantities for each glove with the aim of maximizing the profit