Question: Need spreadsheet for this Question. Kelson Sporting Equipment, Inc., makes two types of baseball gloves: a regular model and a catcher's model. The firm has

Need spreadsheet for this Question.

Need spreadsheet for this Question. Kelson

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: Production Time (hours) Cutting and Packaging Model Finishing Profit/Glove Sewing and Shipping Regular model 1 1/2 1/8 $5 Catcher's model 3/2 1/3 1/4 $8 The linear program for this problem is as follows: Let R = number of regular model produced, C = number of catcher's model produced MAX 5 R + 8 C 1R + 1.5 C=0 Implement this problem in Solver. Once you have a solution, complete the following chart: Regular Catchers Qty $ $ Profit $3,700 Constraints Used Available C&s Finishing P&s

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!