BUSA2

Kelson Sporting Equipment, Inc, makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 800 hours of production time wilable in its cutting and sewing department, 350 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 tables 1/2 Production Time (Hours) Cutting and Packaging and Model Sewing Finishing Shipping Profit/Glove Regular model 1 1/4 1/6 $5 Catcher's model 1/2 1/4 $7 Assuming that the company is interested in maximizing the total profit contribution, arawer the following: (a) What is the linear programming model for this problem? If required, round your answers to 3 decimal places or enter your answers as a fraction. If the constant is it must be entered in the box. Do not found intermediate calculation. If an amount is zero, entero Let - number of units of regular model C-number of units of catcher's model Max R+ R+ Cutting and Sewing Finishing C Select your answer Select your answer Select your answer Select your answer R. c Packing and Shipping RC (b) Develop a spreadsheet model and find the optimal solution using solver. How many gloves of each model should also madacture? Regular Model units Catchers Model (c) What is the total profit contribution Kelion can earn with the given production quantities? Max IR + sit. R + Select your answer Cutting and Sewing R+ Select your answer V Finishing R+ c Select your answer V Packing and Shipping RC Select your answer Select your answer VIA (b) Develop a spreadsheet model and find the opL Regular Model - units bw many gloves of each model should Catcher's Model units (c) What is the total profit contribution Kelson can earn with thehoiven production quantities? (d) How many hours of production time will be scheduled in each department? Department Production Time (Hours) Cutting and Sewing Finishing Packing and Shipping (e) What is the slack time in each department? If your answer is zero, enter"0" Department Slack Time (Hours) Cutting and Sewing Finishing Packing and Shipping