(c) What is the total profit contribution Kelson can earn with the given production quantities?(d) How many hours of production time will be scheduled in each department?DepartmentProduction Time (Hours)Cutting and SewingFinishingPacking and Shipping(e) What is the slack time in each department? If your answer is zero, enter "0".DepartmentSlack Time (Hours)Cutting and SewingFinishingPacking and Shipping 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)MaxCutting ands.t.Sewing Finishing13/21/23/2Assuming 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.R+R+R+R+Packaging andShipping1/63/4R, CunitsCCCProfit/Glove$4$8сSelect your answer -Select your answer -Select your answer -Select your answer -Cutting and SewingFinishingPacking and Shipping(b) Develop a spreadsheet model and find the optimal solution using Solver. How many gloves of each model should Kelson manufacture?Regular Model =unitsCatcher's Model =

Answered: Image /qna-images/answer/b53cc2f8-c478-4fc8-b4e4-b59ab316ae3b.jpg

Answered: (c) What is the total profit…

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

Which of the following terms describes: "the flow of goods, services, and information from the initial sources of materials and services to the delivery of products to consumers"? a. enterprise resource planning (ERP). b. customer list. c. supply chain. d. material requirements planning (MRP).
Your Corporation manufactures four products that use the same raw material and production machine. Your Company is experiencing a shortage of pounds of the raw material. Information related to the four products are shown below. Products A B C D Selling price $40 $32 $35 $65 Variable cots $34 $22 $27 50 Machine hours per unit 6 8 5 7 Pounds per unit 18 20 28 38 To maximize profit next month, in what order would it be best to schedule production (first to last)? a. A, B, C, D b. A, D, B, C c. B, D, A, C d. D, A, C, B
Manufacturing overhead applied is added to direct labor incurred and to what other items to equal total manufacturing costs for the period? a. Goods available for sale. b. Raw materials purchased. c. Work in process. d. Direct materials used.
Please do not give solution in image format thanku XYZ Mobile makes phones in multiple production lines. The daily production run is for 820 phones. Each phone has a standard time of 5.1 minutes. Each production line operates for 9 hours per day. Do not include commas in your answer and enter percentages as decilmal points. For example enter 1,402 as 1402 and 67.5% as 0.675. How many production lines are needed to meet the daily demand? What is the utilization of the production lines? What is the maximum daily output of the system?
Please answer in excel format A bike company receives bike orders every week and fulfills them according to order’s type. The following table shows frequency and price of the company's products. a) Assuming each order is for only one product, simulate 12 orders using the following table. Fill out gray areas with appropriate Excel functions. NOTE: Use the random numbers shown in the table. b) Calculate average and total price.
Please do not give solution in image formate thanku. Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 10,000; winter, 8,000; spring, 7,000; summer, 12,000. Inventory at the beginning of fall is 500 units. At the beginning of fall, you currently have 30 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. In addition, you have negotiated with the union an option to use the regular workforce on overtime during winter or spring if overtime is necessary to prevent stock outs at the end of those quarters. Overtime is not available during the fall. Relevant costs are hiring, $100 for each temp; layoff, $200 for each worker laid off; inventory holding, $5 per unit-quarter; backorder, $10 per unit; straight time, $5 per hour; overtime, $8 per hour. Assume that the productivity is 0.5 unit per worker hour, with eight hours per day and 60 days per season.
Quick Response is generally referred to as O a. Quick forecasting of demand O b. Quick Order entry O c. Quick production of goods O d. Quick supplies to Retailer
I need correct and non plagiarised answer. I will rate accordingly. What is the difference between Quantity Production and Flow Line Production?
1) Which of the following translates business plan into productionplanningAPPMPSMRPNone of the Above2) Master production schedule is a medium-range planning and it isused for quantity and timing ofcomponents and raw materialFinished goodsBoth A & B3) The manufacturing strategy which deploys hiring and laying ofworkers in order to match its production rate to demand is calledLevel Production StrategyChase Production StartegyHybrid StrategyNone of the above4) "In a level production strategy, if the firm makes annual 120,00units per annum, the permonth production can be estimatted by""120,00 /12""120,00 / 365"The information is not complete5) The Bill of material is an engineering documments that showsinclusive listing and sub-components to be used for end productTRUEFALSE6) A lead capacity usually increases or decreases its capacity in anticipation of demand, this is known as "Match strategyLead Capacity StrategyLag capacity strategy7) The most important output of MRP isBOMPlanned…
(b) Develop a spreadsheet model and find the optimal solution using Solver. How many gloves of each model should Kelson manufacture? Regular Model = 120 units Catcher's Model = 720 (c) What is the total profit contribution Kelson can earn with the given production quantities? Finishing Packing and Shipping 600 (d) How many hours of production time will be scheduled in each department? Department Production Time (Hours) Cutting and Sewing Hide Feedback units Partially Correct 700 300 (e) What is the slack time in each department? If your answer is zero, enter "0". Department Slack Time (Hours) Cutting and Sewing Finishing Packing and Shipping 200 62.5 Hint(s) Check My Work (No more tries available)
Finance manager does not have to deal with other functional department Select one: True False
Which of the following is a performance measure used to measure customer service for a build to stock customer strategy? Select all that apply! - Group of answer choices - Line item fill rate - Return Rate - Inventory Values - Return on Sales

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