Plz complete it or leave it hanging if u complete it I vill give 4 upvotes. (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 =0(c) What is the total profit contribution Kelson can earn with the given production quantities?2700(d) How many hours of production time will be scheduled in each department?DepartmentTime Used (Hours)Cutting and sewingFinishingPacking and ShippingFinishingPacking and Shippingunits800300200(e) What is the slack time in each department?DepartmentSlack Time (Hours)Cutting and sewing312.5 X500 Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 400 hours of production time availablein its cutting and sewing department, 300 hours available in its finishing department, and 200 hours available in its packaging and shipping department. The productiontime requirements and the profit contribution per glove are given in the following table:ModelRegular modelCatcher's modelSewing FinishingProfit/Glove1/81$51/21/2$7Assuming 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.Let R = number of units of regular model.C = number of units of catcher's model.MaxProduction Time (Hours)s.t.Cutting and51/811/2R✓R++OR +OR +Packaging andShippingR, C7 c.51/21/23/23/2ScSc≤SS>+#✔SO400300200Cutting and sewing✔Finishing✔ Packing and Shipping

For this question, first, I would formulate the LP, and after formulating the LP, I would solve this…

(b) Develop a spreadsheet model and find the optimal solution using Solver. How many gloves of each model should Kelson manufacture? Regular Model = units Catcher's Model = (c) What is the total profit contribution Kelson can earn with the given production quantities? 2700 (d) How many hours of production time will be scheduled in each department? Department Time Used (Hours) Cutting and sewing Finishing Packing and Shipping units Packing and Shipping 800 300 200 (e) What is the slack time in each department? Department Slack Time (Hours) Cutting and sewing Finishing 312.5 50 0

(b) Develop a spreadsheet model and find the optimal solution using Solver. How many gloves of each model should Kelson manufacture? Regular Model = units Catcher's Model = (c) What is the total profit contribution Kelson can earn with the given production quantities? 2700 (d) How many hours of production time will be scheduled in each department? Department Time Used (Hours) Cutting and sewing Finishing Packing and Shipping units Packing and Shipping 800 300 200 (e) What is the slack time in each department? Department Slack Time (Hours) Cutting and sewing Finishing 312.5 50 0

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

21- Find the critical Path for the following business netwerk activity/ pre-ActDuration activity pre-Act/Buration 24 CB of of 20 PQUS 7t to 36 40 TM to 36 20 い| o
Brief description of flexible Approach
STYLE# STYLE DESCRIPTION 9562 URIT C/B JERSEY CREW W/STRIPES Current Retail: $28.00 Cost: $11.00 IMU: 60.7% CUR SALES ST% 114 14.9% STD SALES ST% 247 27.4% ON HAND $ 653 16978 ON ORDER $ WK 1 SALES ST% 133 14.8% WK 2 SALES ST% WK 3 SALES ST% WK 4 SALES ST% What is the WOS for the item: "Jersey Crew w/Stripes" which only has had selling for two weeks? (express your number one place to the right of the decimal: #.# do not add any verbiage) If your plan for this item is 9.5 WOS, how many more units should you order? (express in a whole #, do not add any verbiage)
Can you help me do the analysis of TOWS Matrix? This is my TWOS table and please explain every points in details. Please also provide in-text citations and references too. Please expain in 600 words. I also provide you a sample in image how to do so you can take a reference from there. Sheng Siong Singapore Opportunities Threats Strengths SO: 1. Since Sheng Siong is already a strong brand recognition, it can expand product offerings to attract more customers (S1, O1) 2. Develops new features for an existing Sheng Siong app to keep the update and follow the trends of products with technology advancements (S4, S5 and O2) 3. As Sheng Siong is recognized as a strong brand, it is easier to expand retail network in Singapore by opening new stores in central areas (S1, O4) 4. It is easy to do international expansion because of Sheng Siong’s brand recognition (S1, O3) ST: 1. With an increment in intensity of competition amongst the rivals and Sheng…