Product Annual Code Demand Frequency Pick List Weighted Weighted Volume Percentage Cumulative Weight ABC Percentage Category A001 20000 2200 A002 19000 1700 A003 7800 700 A004 9840 1400 A005 16000 1300 A006 12000 2000 A007 9950 400 A008 10500 1700 A009 8200 515 A010 4700 258 A011 5100 367 A012 8800 800 A013 8900 711 A014 15000 1900 A015 7900 350 A016 9620 2000 A017 8800 550 A018 25000 2000 A019 9950 380 A020 10500 1100
Product Annual Code Demand Frequency Pick List Weighted Weighted Volume Percentage Cumulative Weight ABC Percentage Category A001 20000 2200 A002 19000 1700 A003 7800 700 A004 9840 1400 A005 16000 1300 A006 12000 2000 A007 9950 400 A008 10500 1700 A009 8200 515 A010 4700 258 A011 5100 367 A012 8800 800 A013 8900 711 A014 15000 1900 A015 7900 350 A016 9620 2000 A017 8800 550 A018 25000 2000 A019 9950 380 A020 10500 1100
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
Classify the items in a warehouse inventory using the ABC method, where Group A contributes 80%, Group B contributes 15%, and Group C contributes 5% to the total inventory value
| Product Code | Annual Demand | Pick List Frequenscy | Weighted Volume | Weighthed Percentage | Comulative Weight Percentage | ABC Category |
| A001 | 20000 | 2200 | ||||
| A002 | 19000 | 1700 | ||||
| A003 | 7800 | 700 | ||||
| A004 | 9840 | 1400 | ||||
| A005 | 16000 | 1300 | ||||
| A006 | 12000 | 2000 | ||||
| A007 | 9950 | 400 | ||||
| A008 | 10500 | 1700 | ||||
| A009 | 8200 | 515 | ||||
| A010 | 4700 | 258 | ||||
| A011 | 5100 | 367 | ||||
| A012 | 8800 | 800 | ||||
| A013 | 8900 | 711 | ||||
| A014 | 15000 | 1900 | ||||
| A015 | 7900 | 350 | ||||
| A016 | 9620 | 2000 | ||||
| A017 | 8800 | 550 | ||||
| A018 | 25000 | 2000 | ||||
| A019 | 9950 | 380 | ||||
| A020 | 10500 | 1100 |
Transcribed Image Text:Product
Annual
Code
Demand
Frequency
Pick List Weighted Weighted
Volume Percentage
Cumulative Weight
ABC
Percentage
Category
A001
20000
2200
A002
19000
1700
A003
7800
700
A004
9840
1400
A005
16000
1300
A006
12000
2000
A007
9950
400
A008
10500
1700
A009
8200
515
A010
4700
258
A011
5100
367
A012
8800
800
A013
8900
711
A014
15000
1900
A015
7900
350
A016
9620
2000
A017
8800
550
A018
25000
2000
A019
9950
380
A020
10500
1100
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
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.