ABC分类法的应用实例
发布时间:2020-08-03 08:30:10
发布时间:2020-08-03 08:30:10
物品 名称 | 品目数累计 | 累计百分比 | 物品单价(百元) | 平均库存 | 物品平均资金占用额 | 平均资金占用额累计 | 平均资金占用额累计百分数 | 分类结果 |
1 | 2 | 3 | 4 | 5 | 6=4×5 | 7 | 8 | 9 |
a | 1 | 3.85 | 48 | 380 | 18240 | 18240 | 48.02 | A |
b | 2 | 7.69 | 25 | 258 | 6450 | 24690 | 64.99 | A |
c | 3 | 11.54 | 5 | 592 | 2960 | 27650 | 72.79 | A |
d | 4 | 15.38 | 4.5 | 520 | 2340 | 29990 | 78.95 | B |
e | 5 | 19.23 | 3 | 350 | 1050 | 31040 | 81.71 | B |
f | 6 | 23.08 | 4.6 | 200 | 920 | 31960 | 84.13 | B |
g | 7 | 26.92 | 1.5 | 580 | 870 | 32830 | 86.42 | B |
h | 8 | 30.77 | 1.4 | 560 | 784 | 33614 | 88.49 | B |
i | 9 | 34.62 | 1.1 | 660 | 726 | 34340 | 90.40 | B |
j | 10 | 38.46 | 0.8 | 840 | 672 | 35012 | 92.17 | B |
k | 11 | 42.31 | 2.1 | 250 | 525 | 35537 | 93.55 | B |
l | 12 | 46.15 | 2.5 | 156 | 390 | 35927 | 94.58 | C |
m | 13 | 50.00 | 0.6 | 552 | 331.2 | 36258.2 | 95.45 | C |
n | 14 | 53.85 | 0.3 | 920 | 276 | 36534.2 | 96.17 | C |
o | 15 | 57.69 | 0.1 | 2620 | 262 | 36796.2 | 96.86 | C |
p | 16 | 61.54 | 0.4 | 530 | 212 | 37008.2 | 97.42 | C |
q | 17 | 65.38 | 1.0 | 200 | 200 | 37208.2 | 97.95 | C |
r | 18 | 69.23 | 0.3 | 550 | 165 | 37373.2 | 98.38 | C |
s | 19 | 73.08 | 0.7 | 215 | 150.5 | 37523.2 | 98.78 | C |
t | 20 | 76.92 | 0.6 | 180 | 108 | 37823.7 | 99.06 | C |
u | 21 | 80.77 | 0.8 | 120 | 96 | 37727.7 | 99.32 | C |
v | 22 | 84.62 | 0.5 | 150 | 75 | 37802.7 | 99.52 | C |
w | 23 | 88.46 | 0.9 | 80 | 72 | 37874.7 | 99.70 | C |
x | 24 | 92.31 | 0.3 | 210 | 63 | 37937.7 | 99.87 | C |
y | 25 | 96.15 | 0.2 | 150 | 30 | 36967.7 | 99.95 | C |
z | 26 | 100 | 0.1 | 200 | 20 | 37987.7 | 100.00 | C |