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 How would according to an ABC places) and percentage em Code Avg Inventory (units) 1289 2347 2349 2363 2394 2395 6782 7844 L. Houts Plastics Charlotte Inventory Levels 8210 8310 9111 360 300 120 65 60 25 20 12 10 7 6 Value (unit) 3.50 4.00 2.50 1.80 1.75 2.25 1.15 2.05 1.60 2.00 3.00 Dollar Volume 1,200 300 105 23 25 14 18 3,134 % of Dollar Volume 38.29 9.57 3.35 0.73 0.78 0.45 0.57
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 How would according to an ABC places) and percentage em Code Avg Inventory (units) 1289 2347 2349 2363 2394 2395 6782 7844 L. Houts Plastics Charlotte Inventory Levels 8210 8310 9111 360 300 120 65 60 25 20 12 10 7 6 Value (unit) 3.50 4.00 2.50 1.80 1.75 2.25 1.15 2.05 1.60 2.00 3.00 Dollar Volume 1,200 300 105 23 25 14 18 3,134 % of Dollar Volume 38.29 9.57 3.35 0.73 0.78 0.45 0.57
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...
Related questions
Question

Transcribed Image Text: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)
Item Code Avg. Inventory
(units)
1289
2347
2349
2363
2394
2395
L. Houts Plastics Charlotte Inventory Levels
Value
Dollar
Volume
(S/unit)
3.50
6782
7844
8210
8310
9111
360
300
120
65
60
25
222216
20
10
7
4.00
2.50
1.80
1.75
2.25
1.15
2.05
1.60
2.00
3.00
1,200
300
105
23
25
14
18
3,134
% of Dollar Volume
38.29
9.57
3.35
0.73
0.78
0.45
0.57
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
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
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


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.