Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a

Question

Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 400 hours of production time available in its cutting and sewing department, 300 hours available in its finishing department, and 200 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table:

Assuming that the company is interested in maximizing the total profit contribution, answer the following:

Production Time (Hours)
Model Cutting and
Sewing
Finishing Packaging and
Shipping
Profit/Glove Regular model 1/8 1 1/2 $5 Catcher's model 1/2 1/2 3/2 $7

Explanation / Answer

(a) Maximise Cost = 5R + 7C

COnstraint to:

R/8 + C/2 400 ....(i)

R + C/2    300...(ii)

R/2 + 3C/2 200 ...(iii)

R,C >= 0

(b) Answer Report by Excel

Regular model = 280 units

Catcher's Model = 40 units

(c) Total Profit = 280 * 5 + 40 * 7 = $ 1680

(d)

(e)

Target Cell (Max) Cell Name Original Value Final Value $G$2 Profit Max $0 $1,680 Adjustable Cells Cell Name Original Value Final Value $C$1 R 0 280 $E$1 C 0 40 Constraints Cell Name Cell Value Formula Status Slack $F$4 C Profit 55 $F$4<=$G$4 Not Binding 345 $F$5 C Profit 300 $F$5<=$G$5 Binding 0 $F$6 C Profit 200 $F$6<=$G$6 Binding 0 $F$1 C 0 $F$1>=$G$8 Binding 0 $C$1 R 280 $C$1>=$G$7 Not Binding 280

Related Questions

Navigate

• Browse (All)
• Browse K
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.