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

write elaborately 8 main discussion "Reasearch methodology" course?
Pls answer everything asap I really need help
Product plan?
please answer thank you
W AutoSave Off H 2.0 = PDPMT_PL102_06 June 2023_1 No Label ✓ Mailings Review File Home Insert Draw Design X (6 Paste Clipboard F Page 7 of 7 ■ Arial B I U U 79 of 954 words Q Search V ✓11 ab ab X₂ X x² A A Layout References A A Aa A A D Font English (South Africa) 10° View Help E✓ F✓ ≤ = AT ==== 스 1:15-16- E G QUESTION FOUR 4.2 Text Predictions: On Search Paragraph 5 Normal Ethical behaviour is necessary within a project organisation and is crucial in project business relationships with the customer, suppliers and subcontractors. Customers and suppliers want to do business with a project organisation that they can trust. Throughout any project, situations may arise that can provide an opportunity for unethical behaviour. With regard to the above statements: 4.1 Provide five examples of unethical behaviour in a project context. Accessibility: Unavailable No Spacing END OF QUESTION PAPER Styles Heading 1 Discuss the ways in which project managers can promote ethical behaviour. R A Thembi…
1. In internet of things, how smart pillow works. 2. What are benefits of smart pillow. 3. What are drawbacks of smart pillow.
Make a milestone/bar graph, possible using excel
W AutoSave Off H 2.0 = PDPMT_PL102_06 June 2023_1 No Label ✓ File Home Insert Draw Design X Paste Clipboard F Page 4 of 6 ▬ Arial B I U U 961 words Q Search V ✓11 Layout References A A A Aa A D x² A✓ ✓ A. А ab ab X₂ X Font 9° 1.1 Questions: 1.2 Review Mailings View Help EE F✓ = = £↓¶ 스 1.3 === Search Paragraph 5 Normal No Spacing 3 Styles Heading 1 "Project, programme and portfolio managers need be as well-versed in leadership skills as they are in technical skills, _._." Do you agree with this statement? Motivate your answer. ".. not just classic leadership skills like communication, problem solving and team building." "..skills like communication, empathy and problem solving are all still integral to project leadership." ".. classic leadership skills like communication, problem solving and team building." In terms of the reference to team building, explain the role of team cohesiveness in team building and discuss the steps involved in the development of the cohesiveness English…
Question 2: What are the components of B2B? Draw a flow diagram of all components.detils explantion
Question 1 Strategy is an action that managers take to attain one or more of the organization’s goals. Strategy can also be defined as a general direction set for the company and its various components to achieve a desired state in the future. Strategy results from the detailed strategic planning process. A strategy is all about integrating organizational activities and utilizing and allocating the scarce resources within the organizational environment so as to meet the present objectives. Discuss the requirements to do a strategy from external and internal analyses perspectives in the case of ONE (1) logistics company after the end of COVID-19 pandemic.
4
TASKS TO BE COMPLETED 1. BUSINESS NAME 2. LOGO 3. TAGLINE 4. BRAND FASCINATION