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 plant classify 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.)### L. Houts Plastics Charlotte Inventory Levels| Item Code | Avg. Inventory (units) | Value ($/unit) | Dollar Volume | % of Dollar Volume ||-----------|------------------------|----------------|---------------|--------------------|| 1289 | 380 | 3.75 | 1,425 | 43.22 || 2347 | 300 | 4.00 | 1,200 | 36.39 || 2349 | 120 | 2.50 | 300 | 9.10 || 2363 | 75 | 1.50 | 113 | 3.43 || 2394 | 60 | 1.75 | 105 | 3.18 || 2395 | 30 | 2.25 | 68 | 2.06 || 6782 | 20 | 1.15 | 23 | 0.70 || 7844 | 12 | 2.05 | 25 | 0.75 || 8210 | 5 | 1.60 | 8 | 0.24 || 8310 | 7 | 2.00 | 14 | 0.42 || 9111 | 6 | 3.00 | 18 | 0.55 |**Total Dollar Volume:** 3,298This table displays the average inventory units and their corresponding value per unit for different item codes. The table also calculates the dollar volume of each item (obtained by multiplying average inventory by the value per unit) and the percentage of the total dollar volume each item represents. These are critical metrics for using the ABC classification system to prioritize inventory management efforts, with a focus on items with the highest dollar volume percentages

Ans) Formula: Item is classified A if the cumulative percent is less than or equal to 80% Item is…

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

Discuss what is VED classification and FSND classification in inventory management?
2. (Quantity Discount) County Hospital orders syringes from a hospital supply firm. The hospital expects to use 40,000 per year. The cost to order and have the syringes delivered is $800. The annual carrying cost is $1.90 per syringe because of security and theft. The hospital supply firm offers the following quantity discount pricing schedule. Qty 0-9,999 10,000-19,999 20,000-29,999 30,000-39,999 40,000-49,999 50,000+ Price $ 3.40 $ 3.20 $ 3.00 $ 2.80 $ 2.60 $ 2.40 What is best order quantity for syringes that minimize total cost?
Alpha Products, Inc., is having a problem trying to control inventory. There is insufficient time to devote to all its items equally. The following is a sample of some items stocked, along with the annual usage of each item expressed in dollar volume.in Table 3 (below): Table 3. Item Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Annual Dollar Usage ($) 7,000 1,000 14,000 2,000 24,000 68,000 17,000 900 1,700 2,300 80,000 400 1,100 30,000 1,900 800 90,000 12,000 300 32,000 a) As an Operations Management specialist, what system would you recommend for allocating control time for this inventory.
Define each of the following terms: c. Economic Ordering Quantity (EOQ); EOQ model; EOQ range
what is PARQ
After applying the NWC Rule for the initial tableau of the given transportation model, evaluate the vacant cells. What is the cell which has the most negative evaluation value and what is the cell evaluation value? DESTINATION SOURCE DEMAND X Y N OX-R; 1 OY-S; -1 OX-S; -1 OY-S; -2 P 75 8 12 EI 11 Q 80 5 8 11 R 120 7 10 10 S 50 11 13 14 SUPPLY 100 125 100 325
ca/d21/le/content/775993/viewContent/6496162/View YouTube W Maps 4. Retaining Walls R Us has received numerous complaints from its major customer Humungous Warehouse about the accuracy and reliability of its shipments. You decide to collect data on the defective shipments REASON FOR DEFECTIVE SHIPMENT No. OF INCORRECT No. OF SHIPMENTS BILL OF INCORRECT DAMAGED TRUCKS WEEK SHIPMENTS WITH DEFECTS LADING TRUCKLOAD PRODUCT LATE 1 23 31 8. 1 4. 1 3 28 6 3 1 4 37 11 4. 4 35 10 4 1. 6. 40 14 6. 3. 7. 41 12 3 1 8. 44 15 Heizer and Render, 2006 You have consistently exceeded your regular output of 30 shipments per week and wonder if that may have something to do with the number of defects. Develop a scatter diagram using total number of shipments and number of defective shipments. Does there appear to be a relationship? Civon thatunurwnrlıforco isc onal unu choclvour omnloumont rocorde for the last O vinolke 2. 13 View as
Help me to solve all this question
Given the following information for a purchased component, what is the total annual cost for the item? Annual demand = 500,000 Purchase price = $10 per unit Order quantity 100,000 • Order cost = $5 per order • Annual holding cost per unit = = $2 . $2.510,100 O $510,025 $510,250 O $5,100,250 O $5,100,025
Part 1 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 plant classify 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.) For the following three questions, consider only items 1289, 2349,8210 from the above table for relative classification (these are some of the items for which you computed the metrics) A) Based on the percentages of follar colume, item number 1289 should be classified as _ (A,B,C) B) Item number 2349 should be classified as _ (A,B,C) c) Item number 8210 should be classified as _ (A.B, C)
In the retail coffee industry, with many mom-and-pop coffee stores and retail coffee shows, the number of competitors in the industry is high. In such a case, most coffee houses use beans and other ingredients to create different blends of coffee. Many suppliers provide the beans required by these firms. Moreover, there is not a significant difference in the quality of the product from different suppliers. In addition, with many suppliers offering similar commodity-type products, the switching costs for the focal firms would below. Referring to the second part of the above scenario, all of the mentioned factors combined will result in ____________. * high threat of new entrants to the industry high bargaining power of the suppliers low threat of new entrants to the industry low bargaining power of the suppliers
Can ABC inventory classification be applied to manufacturing component inventories? Discuss.

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