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.50   insert answer   insert answer   2347 300   4.00   1,200   37.83   2349 120   2.50   300   9.46   2363 75   1.30   insert answer   insert answer   2394 60   1.75   105   3.31   2395 25   2.00   insert answer   insert answer   6782 20   1.15   23   0.73   7844 12   2.05   25   0.78   8210 5   2.00   insert answer   insert answer   8310 7   2.00   14   0.44   9111 6   3.00   18   0.57             3,172       For 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).   1. Based on the percentages of dollar​ volume, item number 1289 should be classified as A B or C   2. Item numbe 2349 should be classified as A B or C     3. Item number 8210 should be classified as A B or C

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...
icon
Related questions
icon
Concept explainers
Topic Video
Question
100%
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.50
 
insert answer
 
insert answer
 
2347
300
 
4.00
 
1,200
 
37.83
 
2349
120
 
2.50
 
300
 
9.46
 
2363
75
 
1.30
 
insert answer
 
insert answer
 
2394
60
 
1.75
 
105
 
3.31
 
2395
25
 
2.00
 
insert answer
 
insert answer
 
6782
20
 
1.15
 
23
 
0.73
 
7844
12
 
2.05
 
25
 
0.78
 
8210
5
 
2.00
 
insert answer  
insert answer
 
8310
7
 
2.00
 
14
 
0.44
 
9111
6
 
3.00
 
18
 
0.57
 
 
 
 
 
 
3,172
 
 
 
For 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).
 
1. Based on the percentages of dollar​ volume, item number 1289 should be classified as A B or C
 
2. Item numbe 2349 should be classified as A B or C
 
 
3. Item number 8210 should be classified as A B or C
 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.