L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the table below. How would the plantclassify these items according to an ABC classification system? (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.)Item number 2349 should be classified asItemCode12892347234923632394239567827844821083109111Item number 8210 should be classified asL. Houts Plastics Charlotte Inventory LevelsAvg.Inventory (units)Value($/unit)3.75420300120606032257620124.002.501.801.752.251.152.052.002.003.00DollarVolume1,2003001052325% of DollarVolume34.728.683.040.670.7114183,456For the following three questions, consider only items 1289, 2349, and 8210 from the above table for relative classification (these are some of the items for which you computed the metrics).Based on the percentages of dollar volume, item number 1289 should be classified as0.410.52

The A-B-C approach classifies inventory items according to some measure of importance, usually…

Answered: L. Houts Plastics is a large…

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

Given the information below, conduct an ABC analysis and determine which items should be classified as A, B, and C. Which items do you suggest the firm keep the tightest control over? Explain. Item Part Number Item Cost Quantity In Stock 142-AZ $546.00 318 4392-GF $45.00 1250 86935-ES $15.35 3546 173-DC $653.00 1876 999-BA $199.00 526 7846-NM $23.00 973 2765-OP $385.00 790 103-VX $12.50 4875 2648-YT $16.75 5185
An organization can use ABC analysis as a way of classifying its existing inventory. Explain how the ABC can be applied
26 Which of the following statements is true with regard to cycle stock? a It is also called surplus stock. b It is received from a downstream supply chain partner. c It is seasonal in nature d It is also referred to as base stock. 27 Inventories that are in transit in containers or trucks ______. a are known as pipeline inventories b are known as in-house inventories c are relatively small in global supply chain (as compared to domestic supply chains) d are known as en route inventories
Discuss why is it not necessary to include product cost in the EQQ model, but the quantity inventory system, discount model requires this information ?
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Question: One of Fisher-Price’s managers felt…
4) Rane Brake Linings gathered information for its brake lining components as presented in the table below. How would the firm classify these items according to an ABC classification system? Initial Information Part # Unit Cost Annual Demand 10 10 200 11 30 125 12 9 100 13 12 5000 14 50 195 15 6 300 16 100 70
Algro Inc. keeps a wide range of parts and materials on hand for use in its production processes. Management has recently had difficulty managing parts inventory as demand for its finished goods has increased; they frequently run out of some critical parts while having an endless supply of others. They would like to classify their parts inventory according to the ABC approach to better control inventory. The following is a list of parts, along with their annual usage and unit value: Item Annual Unit Item Annual Unit Number Usage Cost Number Usage Cost 1 36 $350 2 510 30 3 50 23 4 300 45 5 18 1900 6 500 8 7 710 4 8 80 26 9 344 28 10 67 440 11 510 2 12 682 35 13 1216 95 50 14 10 3 15 820 1 KARAN2222222222 16 60 $610 17 120 20 18 270 15 19 45 50 20 19 3200 21 910 3 12 4750 23 30 2710 24 24 1800 25 870 105 26 244 30 27 750 15 28 45 110 29 46 160 30 165 25 a. Classify the inventory items according to the ABC approach using the dollar value of annual demand. b. Clearly explain why you…
Suppose that we would like to determine Reorder Point for the product. From the historical data the manager determined demand during lead-time for that product fits Normal distribution with a mean of 200 and standard deviation of 10 products. The maximum stock out risk is 10%. Answer the following questions according to the (Q, R) system. a) Find the safety stock if the lead time is 2 weeks. b) Find the reorder point. c) Find the reorder point if the stock out risk decreases to 1%. Comment on the result.
Problem 7 Lynne Chappell manages the inventory of supplies in a large hospital. To determine which items should be closely monitored, Lynne decided to use the ABC classification schemeto group the items on the basis of their value. Asthe following table shows, she took a random sample of20 items and recorded the annual usage and unit cost ofeach. How should each item be classified?Inventory Item Unit cost(in U.S.dollars) AnnualUsageP21 $80 800A12 $400 70K43 $50 100S54 $60 90C25 $50 130D76 $30 170E27 $20 200F38 $300 90H19 $520 120Q10 $10 100R82 $20 80G65 $80 70L71 $220 200M94 $70 80V45 $15 60T62 $30 180I17 $20 80W22 $300 90O37 $700 85N88 $5 100
Sh29

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