Question: Kelson Sporting Equipment, Inc., makes two types of baseball gloves: a regular model and a catchers model. The firm has 900 hours of production time

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:

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?

b. Develop a spreadsheet model and find the optimal solution using Excel Solver. How many of each model should Kelson manufacture?

c. What is the total profit contribution Kelson can earn with the optimal production quantities?

d. How many hours of production time will be scheduled in each department?

e. What is the slack time in each department?

Production Time (hours) Cutting and Sewing Finishing and Shipping Profit/Glove Packaging Model Regular model Catcher's model $5 $8

Step by Step Solution

★★★★★

3.38 Rating (176 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Let R number of units of regular model C number of units of catchers model Max 5 R 8 C st 1 ... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

611-M-S-S-M (728).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

Cascade Company was trying to sell some of its old oil and gas drilling equipment. On January 1, 2021, Cascade Company sold equipment to Yukon Oil and Gas Company The equipment cost $250,000 and had...

Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catchers model. The firm has 900 hours of production time available in its cutting and sewing...

Refer to the computer solution of the Kelson Sporting Equipment problem in Figure. THE MANAGEMENT SCIENTIST SOLUTION FOR THE KELSON SPORTING EQUIPMENT PROBLEM a. Determine the objective coefficient...

Refer to the Kelson Sporting Equipment problem (Chapter 2, Problem 24). Letting R = number of regular gloves C = number of catcher's mitts Leads to the following formulation: Max 5R + 8C s.t. R +...

PROBLEMS $5 1. Sporting Goods Product Mix. Kelson Sporting Equipment, Inc. makes two types of baseball gloves: a regular model and a catcher's model. The firm has 900 hours of produc- tion time...

pLEASE ANSWER IN EXCEL 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...

1. (50 points) 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...

Question 2 8 pts Chapter 12, question 1, part a (what is the cutting and sewing constraint?): 0 x1 + 3/2x2 3 900 03/2x1 + x2 3 900 O 3/2x1 + x2 > 900 O x1 + 3/2x2 900 PROBLEMS 1. Kelson Sporting...

1 1/2 1/8 $5 3/2 1/3 1/4 $8 Question 9 8 pts Chapter 12, question 1, part e (use MS Excel to solve the problem): O Cutting and sewing = 55 Finishing = 125 Packing and Shipping = 75 O Cutting and...

1. Sporting Goods Product Mix. Kelson Sporting Equipment, Inc. makes two types of baseball gloves: a regular model and a catchers model. The firm has 900 hours of production time available in its...

Sporting Goods Product Mix. Kelson Sporting Equipment, Inc. makes two types of baseball gloves: a regular model and a catchers model. The firm has 900 hours of production time available in its...

An accountant made the following adjustments at December 31, the end of the accounting period: a. Prepaid insurance, beginning, $800. Payments for insurance during the period, $2,400. Prepaid...

Courtney Company uses a periodic inventory system. Data for 2020 are as follows: beginning merchandise inventory (December 31, 2019), 3,450 units at $35.90; purchases, 12,900 units at $39.20;...

" If I withdraw $ 1 0 0 0 from my savings account and deposit it in my checking account which of the following will occur? "

Gerhard News collects payments from customers for newspaper subscriptions on a yearly basis (specifically, in one- year subscriptions). Each month, Gerhard must record an adjusting entry to recognize...

With inflation, what are the implications of using LIFO and FIFO inventory methods? How do they affect the cost of goods sold?

Adjusting Journal Entries; T- accounts. Using the information provided in BE4- 11, prepare the t- accounts for Rent Expense and Prepaid Rent for Barnard and Associates as of December 31 after...

Discuss the relative merits of internal versus external recruitment. Give an example of a situation in which each of these approaches might be particularly effective.

The records of Alyssa Company show the following amounts in its December 31 financial statements: Alyssa Company made the following errors in determining its ending inventory : 1. The ending...

What does this story say to you about the relationship between the individual and the organization?

Tunningley Services is establishing a new business to serve customers in the Ohio, Kentucky, and Indiana region around the Cincinnati Ohio area. The company has identified 15 key market areas and...

Tindall Bookstores is a major national retail chain with stores located principally in shopping malls. For many years, the company has published a Christmas catalog that was sent to current customers...

Solve the Rosenberg Land Development Rosenberg Land Development (RLD) is a developer of condominium properties in the Southwest United States. RLD has recently acquired a 40.625 acre site outside...

Problem 20-3 Warrants Maese Industries Inc. has warrants outstanding that permit the holders to purchase 1 share of stock per warrant at a price of $27. Calculate the exercise value of the firm's...

In a recent 5-year period, mutual fund manager Diana Sauros produced the following percentage rates of return for the Mesozoic Fund. Rates of return on the market index are given for comparison. 1 2...

A catch of five fish of a certain species yielded the following ounces of protein per pound: 3.1, 3.5, 3.2, 2.8 and 3.4.If the weights for this species was known to be normally distributed, find a...