Use a spreadsheet and the SORT(filter) tool (under the Data menu item) and make
ID: 351200 • Letter: U
Question
Use a spreadsheet and the SORT(filter) tool (under the Data menu item) and make an appropriate sort to apply the ABC identification sorting appropriately high to low (repeat the in class handout procedure.) Print the one page spreadsheet with the resulting sort and identification. Be sure to Print Preview first to ensure you only print one clean page. Feel free to copy/paste the initial data below.
Item
Annual Demand
Unit Cost
A2
3000
50
B8
4000
12
C7
1500
45
D1
6000
10
E9
1000
20
F3
500
500
G2
300
1500
H2
600
20
I5
1750
10
J8
2500
5
Item
Annual Demand
Unit Cost
A2
3000
50
B8
4000
12
C7
1500
45
D1
6000
10
E9
1000
20
F3
500
500
G2
300
1500
H2
600
20
I5
1750
10
J8
2500
5
Explanation / Answer
Item Annual Demand Unit Cost Total Cost % of Total Cost Cumulative % Classification G2 300 1500 450000 41.38% 41.38% A F3 500 500 250000 22.99% 64.37% A A2 3000 50 150000 13.79% 78.16% A C7 1500 45 67500 6.21% 84.37% B D1 6000 10 60000 5.52% 89.89% B B8 4000 12 48000 4.41% 94.30% B E9 1000 20 20000 1.84% 96.14% C I5 1750 10 17500 1.61% 97.75% C J8 2500 5 12500 1.15% 98.90% C H2 600 20 12000 1.10% 100.00% C
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.