(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
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
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.
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
The manager of the main laboratory facility at MetroHealth Center is interested in being able to predict the overhead costs each month for the lab. The manager that varies with the of lab performed but that some costs same each month of the lab tests performed. The lab manager collected the following data for the first seven months of the year. (Click the icon to view the data.) Read the requirements. Requirement 1. Prepare a scatter plot of the lab's volume (number of lab tests performed) and total laboratory overhead costs. Plot the points on the graph. (Enlarge the graph and use the point tool button displayed below to draw the graph.) Relationship of Total Laboratory Overhead Costs to Number of Lab Q Tests Performed Total Laboratory Overhead Co $36.000 $34.000- $32.000 $30,000 $28.000 $26.000 $24.000 $24,000 $22.000- $20,000- $18,000 $16.000 $14,000 $12,000 1,0001.7502 5003,2504,0004,750 Number of Lab Tests Performed Click to enlarge graph Data table Month January..... February....…
Based on the information, which of the following themes are related to: PRODUCT ☐ ORDER PRODUCT-ORDERED NONE OF THE ABOVE ☐ CUSTOMER
Which item would be considered an order winner in an automobile developed for high-end users? Voice-activated music system Compact disc players Full-sized spare tire Air bags

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