Question: 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

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 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)

Model Cutting and Sewing Finishing Packaging and Shipping Profit/Glove

Regular model 1 1/2 1/8 $5

Catcher's model 3/2 1/3 1/4 $8

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?

Parameters
	Department (Production Time- hours)
	Regular	Catchers	Time Available		Regular	Catchers
C&S				Profit/Glove
Finishing
P&S


Model
		Regular	Catchers
Number of Gloves Produced

		Hours
	Time Used	Time Available	Slack Time
C&S
Finishing
P&S

Profit

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 Mathematics Questions!

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 cutting and sewing department,...

Kelson Sporting Equipment, Inc., makes two different 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...

Don't need you to tell me how you got it. Just need the answer please

Consider a cube that has 5cm length sides. What is the surface area to volume ratio of this cube? Report your answer in cm/cm Report your answer to one decimal place. QUESTION 12 Consider a cube that...

Let C (t) be the concentration of a drug in the bloodstream. As the body eliminates the drug, C (t) decreases at a rate that is proportional to the amount of the drug that is present at the time....

The following frequency distribution has a sample mean of -3.5 and a sample standard deviation of 9.7. Class ............................ Frequency Less than -10 ....................... 70 -10 up to...

=+Use a Wilcoxon signed-rank test to see whether the ERP system seems to be effective. M22_SHAR8696_03_SE_C22.indd 831 14/07/14 7:36 AM 832 CHAPTER 22 Nonparametric Methods

On January 1, 2017, Schipper Ltd. had the following shareholders' equity accounts: Common shares (1,000,000 issued)......................$1,500,000 Retained...

Firm A and Firm B have debttotal asset ratios of 31 percent and 21 percent and returns on total assets of 7 percent and 13 percent, respectively. What is the return on equity for Firm A and Firm B

Refer to the figure for Prob. 5/177. Car A is traveling along the straightaway with speed v, and this speed is decreasing at a rate a. Car C is moving along the circular off-ramp with speed v/2, and...

Find a." correct to 2 decimal places. NOTE: The triangle is NOT drawn to scale Find c correct to 2 decimal places. NOTE: The triangle is NOT drawn to scale. 420 410

The following accounts and their balances appear in the general ledger of NEWBERRY PROPERTIES INC. on June 30, 2017: Preferred stock, 2%, $75 par...........................................1,350,000...

Problem 11: The principal stresses at a point in a solid: = 60 MPa, = 35 MPa, 3 = 15 MPa Obtain (a) the maximum shearing stress and (b) the normal and shearing stresses on the octahedral plane.

Julia works with you at Happyville Community Centre. You have been friends with Julia for many years, whom you met at high school. You have worked together for about five years. Julia gets on well...

Discuss reasons why therapists tend to avoid the unspoken emotional messages in clients' narratives, and "embedded messages" about the therapeutic relationship, rather than approach and address them?...

Toward the end of a game of Scrabble, you hold five tiles with the letters A, E, P, R, and S. In how many ways can you arrange these five letters (whether or not they form actual words)

If a binary search tree has items x1 Answered: 1 week ago

The baseball player A hits the ball from a height of 3.36 ft with an initial velocity of 34.8 ft/s. 0.14 seconds after the ball is hit, player B who is standing 15 ft away from home plate begins to...

5.1 How do we get buy-in to appraisal during the design stage?

5.2 Who should contribute to the appraisal of an individual employee? Is there a role for self-assessment if so, how much reliance should we place on it?

6.4 Critically evaluate the systems for making promotion decisions and for identifying high potential amongst existing staff in either your own organisation or one you are familiar with. What changes...