Question: please out the answer in excel form! i need to know how to put it into excel PROBLEMS 1. Kelson Sporting Equipment, Inc., makes two

please out the answer in excel form! i need to know how to put it into excel

PROBLEMS 1. 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: Cutting Model and Sewing Regular model Catcher's model 2 Production Time (hours) Packaging Finishing and Shipping % 4 Profit/Glove $5 $8 1 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 cach department? e. What is the slack time in each department

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 General Management Questions!

please answer clearly ! 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-...

please answer this question clearly in chronological order. 1. Sporting Goods Product Mix. Kelson Sporting Equipment, Inc. makes two types of Sol baseball gloves: a regular model and a catcher's...

PROBLEMS 1. 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 cut- ting and sewing...

1 1/2 1/8 $5 3/2 1/3 1/4 $8 Question 4 8 pts Chapter 12, question 1, part a (what is the packaging and shipping constraint?): 1/8x1 + 1/4x2 s 100 O 1/4x1 + 1/8x2 2 100 1/4x1 + 1/8x2 s 100 1/8x1 +...

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 12 PES Chapter 12, question 1, what are the extreme points (plot the constraints and use the geometry of the problem)? O (0,0) (600,0) (500,150) (360,360) (0,600)...

1 1/2 1/8 $5 3/2 1/3 1/4 $8 Question 5 8 pts Chapter 12, question 1, part a (what are the nonnegativity constraints?): 0 x1,x220 X1, X230 0x120.x250 O x1 s 0,x220 PROBLEMS 1. Kelson Sporting...

1 1/2 1/8 $5 3/2 1/3 1/4 $8 Question 8 8 pts Chapter 12, question 1, (Does the problem have other "feasible solutions"?): yes, but with higher profits O yes, but with lower profits No other feasible...

Question 3 8 pts Chapter 12, question 1, part a (what is the finishing constraint?): 0 1/2x1 + 1/3x2 300 O 1/3x1 + 1/2x2 300 PROBLEMS 1. Kelson Sporting Equipment, Inc. makes two types of baseball...

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,...

Consider a multidatabase system in which it is guaranteed that at most one global transaction is active at any time, and every local site ensures local serializability. a. Suggest ways in which the...

Bob Smith opens a new retail business operation on January 1, 2016. Relevant information for 2016 and the subsequent three taxation years follows. Year Ending December 31, 2016 During this first year...

6. Use either indirect proof or conditional proof (or both) and the eighteen rules of inference to derive the conclusions of the following symbolized arguments. Having done so, attempt to derive the...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...