(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

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
Mazoon Company sells 500 units resulting in $150,000 of sales revenue, $50,000 of variable costs, and $36,000 of :fixed costs. Breakeven point in units is None of the given answers .a O units 180 b O units 300 .c O units 72 d O units 100 .e O
Pls do fast within 5 minutes and i will give like for sure Solution must be in typed form Taylor Supply is a wholesaler of office supplies and equipment. Taylor purchases cartons of staples from Barker Manufacturing. Barker offers a price of $7 per carton of staples. Taylor incurs a fixed charge of $90 per order to cover order equipment and clerical costs. Each order takes 3 days to arrive . Taylor has projected sales to be 603 boxes per day. Taylor's accounting department has determined the holding costs relevant for inventory decisions are 28% of unit cost. Assume Q=3000. What is the demand for staples during lead time? 1) Assume Q=3000. What is the demand for staples during lead time? 2) Assume Q=3000. What z value is associated with a 90% confidence level? 3) Assume Q=3000. If Taylor wants a 90% service level, and the standard deviation in daily demand is 250, what is the appropriate reorder point? 4) Assume Q=3000. If Taylor wants to improve their service level to 95%, and…
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.
A busness is aunchng a new product. The aunch wil require a number of related actvties as follows hre (7 weeks) select an advertising agency (2 weeks), plan an advertising campaign wth the agency (4 weeks),products from the manufacturer (13 weeks) select distributors for the product (9 weeks), take initial orders fromoperation (12 weeks), pack enough products for the launch stock (8 weeks), order the launch quantty ofthe distrbutors (3 weeks), dispatch the initial orders to the distrbutors (2 weeks). (a) What is the earest timeconduct the advertsing campaign (10 weeks), design the packaging of the product (4 weeks), set up packinga sales manager (5 weeks), requre the sales manager to recruit saes peope (4 weeks), tran the sales people that the new product can be ntroduced to the market? (b) If the company hre traned salesmen who do notneed further training, coud the product be introduced 7 weeks earler? (c) How long could one delay selectngthe advertising agency? In the example above,…
Suppose that an organization is engaged in manufacturing and sales of a seasonal product. Based on a sales forecast of 1000, 500, 500, and 2000 per quarter, calculate a level production plan, quarterly ending inventory, and average quarterly inventory. If inventory carrying costs are $7 per unit per quarter, what is the annual cost of carrying inventory? Assume that the opening and ending inventories are zero. (without using Excel)
Develop a spreadsheet for question. What would your recommendation be if the weight for the safety went down to 10 and the weight of profitability went up to 25?
Help me
David Austin recently purchased a chain of dry cleaners innorthern Wisconsin. Although the business is making amodest profit now, David suspects that if he invests in a newPROBLEMS • GO Tutorialpress, he could recognize a substantial increase in profits.The new press costs $15,400 to purchase and install and canpress 40 shirts an hour (or 320 per day). David estimatesthat with the new press, it will cost $0.25 to launder andpress each shirt. Customers are charged $1.10 per shirt.a. How many shirts will David have to press to break even?b. So far, David’s workload has varied from 50 to 200shirts a day. How long would it take to break even onthe new press at the low-demand estimate? at the highdemand estimate?c. If David cuts his price to $0.99 a shirt, he expects to beable to stabilize his customer base at 250 shirts per day.How long would it take to break even at the reducedprice of $0.99? Should David cut his price and buy thenew press?
Demand forecasting and planning is not a part of inventory management function. Select one : 1.True 2.Fales
How the Use of HLOOKUP function to determine sales for a particular day, be useful and applicable in business and other transactions?
Power O Exponential Logarithmic O Polynomial QUESTION 9 If you try different startinng values for the changing cells and obtain different solutions: you can be confident there is no solution you can keep the best solution you have found and hope that it is indeed optimal O there must be a mistake in your objective function O there must be a mistake in one of your constraints QUESTION 10 In pricing models (i.e., Example 7.1), elasticity of demand is an input with specifies the: sensitivity of price to changes in demand O sensitivity of demand to changes in price range of demand lovol

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