Question

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 available in its cutting and sewing department, 150 hours available in its finishing department, and 400 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table Production Time (Hours) Cutting and Packaging and Model Regular model Catcher's model Sewing Finishing Shipping Profit/Glove 1/2 1/6 $5 1/2 1/4 $7 Assuming that the company is interested in maximizing the total profit contribution, answer 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 Let R = number of units of regular model C number of units of catcher's model Max C 1 -Select your answer- # C 1 -Select your answer- # C | -Select your answer- Cutting and sewing Finishing Packing and Shipping R, C -Select your answer- (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

Answer 1

(a)
Decision variables:
R = Number of regular type gloves
C = Number of catcher type gloves
P = Profit in dollars
Objective function:
Maximize P = 5R + 7C
Constraints:
R + (1/2)C ≤ 800
(1/4)R + (1/2)C ≤ 150
(1/2)R + (1/4)C ≤ 400
R, C ≥ 0
(b)
R =	0
C =	600
P =	4200
Cutting and sewing	300
Finishing	150
Packaging and shipping	150
Optimum solution: R = 0, C = 600, P = 4200

Solver Parameters Set Target Cell: F$6 Solve Equal To: ⓔMaxOMín O Value of: 0 Close By Changing Cells: SF$4:$F$5 Subject to the Constraints: Guess Options SF$ 10 <= 400 SFS8 <= 800 SFS9 <= 150 Add Change Delete Reset All Help