(b) Develop a spreadsheet model and find the optimal solution using Solver. How many gloves of each model should Kelson manufacture?Regular Model =120unitsCatcher's Model =720(c) What is the total profit contribution Kelson can earn with the given production quantities?FinishingPacking and Shipping600(d) How many hours of production time will be scheduled in each department?DepartmentProduction Time (Hours)Cutting and SewingHide FeedbackunitsPartially Correct700300(e) What is the slack time in each department? If your answer is zero, enter "0".DepartmentSlack Time (Hours)Cutting and SewingFinishingPacking and Shipping20062.5Hint(s) Check My Work (No more tries available) Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 700 hours of productiontime available in its cutting and sewing department, 300 hours available in its finishing department, and 200 hours available in its packaging and shippingdepartment. The production time requirements and the profit contribution per glove are given in the following table:ModelRegular modelCatcher's modelProduction Time (Hours)Cutting andMaxs.t.Sewing Finishing13/23/21/2Profit/Glove$4$8Assuming 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. If theconstant is "1" It must be entered in the box. Do not round intermediate calculation. If an amount is zero, enter "0".Let R= number of units of regular model.C number of units of catcher's model.11.5167R+R+Packaging andShipping1/63/4+R, C1.5.5.75S•#✔Cutting and SewingFinishing300200 Packing and Shipping700(b) Develco a soreadsheet model and find the optimal solution using Solver, How many gloves of each model should Kelson manufacture?

ModelCutting & sewing timeFinishing timePacking & shipping timeProfitRegular 1 hours3/2…

Answered: (b) Develop a spreadsheet model and…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Give typed full explanation
16. All merchandise planning starts with and is based on: Group of answer choices Planned sales Planned OTB Actual sales Planned stocks
is the ability of the customer to track the order from placement to delivery: Select one: a. Order visibility b. Flexibility c. Response time d. Returnability
QUESTION 3 Samoto Limited (SL) relies on an external supplier for production capacity. In order to gain access to a certain level of production capacity, SL will have to commit to an annual contract before the start of the operating period. The contract will stipulate the production capacity entitlement of SL. SL has a choice of three contracts: Contract Mega, Contract Upper, and Contract Soso. Regardless of the choice of contract, the company will be subject to three states of nature: high demand, medium demand and low demand. The net profits generated by each of the contracts under the three states of nature are as follows: Net profit (£000) Medium demand High demand Low demand Contract Mega Contract Upper Contract Soso 20,000 17,000 16,500 15,500 16,000 15,000 11,000 12,000 13,000 The probabilities of the states of nature are as follows: High demand Medium demand Low demand 25% 45% 30% Probability
?Which of the following statements is not a right description of process focus strategy low volume, high variety finished goods are not usually made to a forecast and stored operators are modestly skilled low fixed costs, high variable costs .most appropriate for hospitals
Please don't give image format
As part of their responsibilities, all managers get involved in planning, scheduling, and monitoring the design, development, production, and delivery of the organization's products and services. True € se
Well water inc. wants to produce and sell a new flavored water in order topenetrate the market, the product will have to sell at 2.60 per 12 oz bottle thefollowing data has been collected: Annual sales 50,000 bottlesProjected selling and administrative costs 8,000Desired profit 80,000The target cost per bottle is _____ per bottle (2 decimal places)
Increases in lead time ________reorder points. Group of answer choices Decrease Have no effect on Increase
U-RIDE, Inc. currently produces the electric engines that are used in golf carts made and sold by the Company. Electco has offered to sell the electric engines to U-RIDE at a price of $277 each. Current production information follows: Unit-level material and labor 2$ 230 Facility-level depreciation of manufacturing equip. Product-level engine production supervisor's salary Annual facility-level utilities $ 6,100/month $ 3,100/month $20,500 Buying the engines will free up manufacturing capacity that could be used to make a new economy line golf cart that would produce an additional $11,600 profit per year. U-RIDE is currently operating profitably producing and selling 3,100 engines annually. Based on this information, which of the following is true? Multiple Choice The $111,600 is not relevant because it is an estimate. Buying the units would increase U-RIDE's cost by $35 per unit. of 10
It has been theoretically and empirically generalized that Recency is always the most important factor for classification of customers in RFM analysis. True False
perform an LCA of a hamburger. life cycle stages… show how “sub-cycles” spin off of the main hamburger life cycle, I.e. the life cycle for the lettuce; life cycle for the truck that brings the lettuce; life cycle for the metals to produce the truck… to illustrate how large the system can be and WHY you’ll always need to draw boundaries.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS