Question
Kelson Sporting Equipment, Inc. produces two different types of baseball gloves: a regular model and a catcher's model. The company has 900 hours of production
Kelson Sporting Equipment, Inc. produces two different types of baseball gloves: a regular model and a catcher's model. The company has 900 hours of production time available in its cutting and sewing department, and 350 hours available in its finishing department.
The production time requirements and the profit contribution per glove are:
- Cutting and Sewing Department: 1 hours to produce one regular model, and 2.25 hours to produce one catcher's model.
- Finishing Department: 0.75 hours to produce one regular model, and 2.25 hours to produce one catcher's model.
- Profit Contribution per glove: $7 for a regular model, and $5 for a catcher's model.
Kelson would like to maximize its profit contribution subject to two constraints (Cutting and Sewing Department, and Finishing Department). Using Excel Solver or graphical approach, answer the following (1.0 point each):
- Determine the number of regular model and catcher's model to produce in order to maximize total profit contribution.
- Calculate the total profit contribution based on your answers above.
- Calculate the usage (production hours) and slack in the Cutting and Sewing Department, and Finishing Department.
- Suppose the profit contribution for regular model is increased by $0.1 per unit, what will the new optimal solution and total profit contribution be?
- Identify the range of feasibility for the right-hand-side values (constraints). Note: This is the lower limit and upper limit for your two constraints.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started