(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 = (c) What is the total profit contribution Kelson can earn with the given production quantities? 2700 (d) How many hours of production time will be scheduled in each department? Department Time Used (Hours) Cutting and sewing Finishing Packing and Shipping units Packing and Shipping 800 300 200 (e) What is the slack time in each department? Department Slack Time (Hours) Cutting and sewing Finishing 312.5 50 0

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter12: Queueing Models
Section: Chapter Questions
Problem 59P
icon
Related questions
Question

Plz complete  it or leave  it hanging if u complete  it I vill give 4 upvotes. 

(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 =
0
(c) What is the total profit contribution Kelson can earn with the given production quantities?
2700
(d) How many hours of production time will be scheduled in each department?
Department
Time Used (Hours)
Cutting and sewing
Finishing
Packing and Shipping
Finishing
Packing and Shipping
units
800
300
200
(e) What is the slack time in each department?
Department
Slack Time (Hours)
Cutting and sewing
312.5 X
50
0
Transcribed Image Text:(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 = 0 (c) What is the total profit contribution Kelson can earn with the given production quantities? 2700 (d) How many hours of production time will be scheduled in each department? Department Time Used (Hours) Cutting and sewing Finishing Packing and Shipping Finishing Packing and Shipping units 800 300 200 (e) What is the slack time in each department? Department Slack Time (Hours) Cutting and sewing 312.5 X 50 0
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:
Model
Regular model
Catcher's model
Sewing Finishing
Profit/Glove
1/8
1
$5
1/2
1/2
$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
Production Time (Hours)
s.t.
Cutting and
5
1/8
1
1/2
R
✓R
+
+
OR +
OR +
Packaging and
Shipping
R, C
7 c
.5
1/2
1/2
3/2
3/2
Sc
Sc
≤
S
S
>
+
#
✔
SO
400
300
200
Cutting and sewing
✔Finishing
✔ Packing and Shipping
Transcribed Image Text: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: Model Regular model Catcher's model Sewing Finishing Profit/Glove 1/8 1 $5 1/2 1/2 $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 Production Time (Hours) s.t. Cutting and 5 1/8 1 1/2 R ✓R + + OR + OR + Packaging and Shipping R, C 7 c .5 1/2 1/2 3/2 3/2 Sc Sc ≤ S S > + # ✔ SO 400 300 200 Cutting and sewing ✔Finishing ✔ Packing and Shipping
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 8 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,