2024年9月19日发(作者:燕山兰)
序
号
商品名称
1
大王牌大豆酶解蛋白粉
黄桃水果罐头
2
3
蜂圣牌蜂皇浆冻干粉片
兴华苦杏仁
4
5
爱牧云南优质小粒咖啡
联广酶解可可豆
6
7
8
9
脆香饼干
吉欧蒂亚干红葡萄酒
利鑫达板栗
隆达葡萄籽油
神奇松花蛋
诚诚油炸花生仁
玫瑰红酒
物动量
4235
2586
1689
1145
590
498
355
230
200
200
186
160
149
136
124
100
80
77
70
69
68
63
62
60
50
48
45
25
20
10
13330
品目比重
物动量比
重
累计品目
比重
3.3333%
6.6667%
10.0000%
13.3333%
16.6667%
20.0000%
23.3333%
26.6667%
30.0000%
33.3333%
36.6667%
40.0000%
43.3333%
46.6667%
50.0000%
53.3333%
56.6667%
60.0000%
63.3333%
66.6667%
70.0000%
73.3333%
76.6667%
80.0000%
83.3333%
86.6667%
90.0000%
93.3333%
96.6667%
------
累计物动量
比重
31.7704%
51.1703%
63.8410%
72.4306%
76.8567%
80.5926%
83.2558%
84.9812%
86.4816%
87.9820%
89.3773%
90.5776%
91.6954%
92.7157%
93.6459%
94.3961%
94.9962%
95.5739%
96.0990%
96.6167%
97.1268%
97.5994%
98.0645%
98.5146%
98.8897%
99.2498%
99.5874%
99.7749%
99.9250%
100%
------
分类
A 3.3333%
31.7704%
3.3333%
19.3998%
3.3333%
12.6707%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
100%
8.5896%
4.4261%
3.7359%
2.6632%
1.7254%
1.5004%
1.5004%
1.3953%
1.2003%
1.1178%
1.0203%
0.9302%
0.7502%
0.6002%
0.5776%
0.5251%
0.5176%
0.5101%
0.4726%
0.4651%
0.4501%
0.3751%
0.3601%
0.3376%
0.1875%
0.1500%
100%
B
10
11
12
13
14
金谷精品杂粮营养粥
15
乐纳可茄汁沙丁鱼罐头
16
17
18
19
20
21
22
23
24
25
早苗栗子西点蛋糕
轩广章鱼小丸子
梦阳奶粉
日月腐乳
休闲黑瓜子
鹏泽海鲜锅底
小师傅方便面
好娃娃薯片
大牛牛奶
金多多婴儿营养米粉
C
26
华冠芝士微波炉爆米花
大厨方便面
27
28
29
30
大嫂什锦水果罐头
山地玫瑰蒸馏果酒
雅比沙拉酱
合计
0.0750%
100%
-----
周转量 周转量比品目比重
序号
货品名称
(箱)
重(%)
(%)
1
2
3
4
5
6
7
8
9
10
巧克力
王老吉
方便面
色拉油
洗发水
花露水
香皂
漱口水
葡萄酒
沐浴露
合计
1000
250
200
160
100
80
50
20
10
5
1875
53.3333%
10.0000%
13.3333%
10.0000%
10.6667%
10.0000%
8.5333%
10.0000%
5.3333%
10.0000%
4.2667%
10.0000%
2.6667%
10.0000%
1.0667%
10.0000%
0.5333%
10.0000%
0.2667%
10.0000%
100% 100%
累计周转量比
重(%)
53.3333%
66.6667%
77.3333%
85.8667%
91.2000%
95.4667%
98.1333%
99.2000%
99.7333%
100.0000%
——
累计品目
比重(%)
10.0000%
20.0000%
30.0000%
40.0000%
50.0000%
60.0000%
70.0000%
80.0000%
90.0000%
100.0000%
——
分类
A
B
C
共
种
物
品
物品编
序号
号
1
2
3
4
5
6
7
8
9
10
10
年消耗
金额
95000
75000
25000
15000
13000
7500
1500
800
425
225
233450
22
68
27
3
82
54
36
19
23
41
合计
占全部
累计品目
资金的累计比重 品目比重
比重
比重
40.69% 40.69%
10.00%
10.00%
32.13% 72.82%
10.00%
20.00%
10.71% 83.53%
10.00%
30.00%
6.43% 89.96%
10.00%
40.00%
5.57% 95.52%
10.00%
50.00%
3.21% 98.74%
10.00%
60.00%
0.64% 99.38%
10.00%
70.00%
0.34% 99.72%
10.00%
80.00%
0.18% 99.90%
10.00%
90.00%
0.10% 100.00%
10.00%
100.00%
100.00% --- 100.00% ---
分类
A
B
C
序
号
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
货品名称
胡姬花花生油
旺旺雪饼
康师傅方便面
青食钙奶饼干
上好佳薯片
清风面巾纸
雅培精装奶粉
赤霞珠干红葡萄酒
乐开怀开心果
莎当妮干白葡萄酒
空心牌玻璃杯
青岛纯生啤酒
青松五香牛肉干
牛栏山二锅头
百事可乐
正航牛奶饼干
乐事薯片
金龙鱼调和油
哇哈哈八宝粥
银鹭花生牛奶
海天苹果醋
崂山可乐
山西老陈醋
望乡挂面
白猫洗衣粉
徐福记沙琪玛
华龙粉丝
丘比沙拉酱
山里红山楂片
统一方便面
涪陵榨菜
米老头米饼
海天葱伴侣黄豆酱
雀巢威化巧克力饼干
菲力普电子节能灯
出入库总
量(箱)
10345
9902
9450
8930
6730
5776
3270
2620
2600
2075
1750
1662
1350
672
607
570
497
460
350
342
238
230
200
197
189
161
150
145
138
130
103
83
79
55
19
品目比重 出入库量比重 累计品目比重
累计出入库量比
重
分
类
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
14.3531%
13.7385%
13.1113%
12.3899%
9.3375%
8.0139%
4.5369%
3.6351%
3.6074%
2.8789%
2.4280%
2.3059%
1.8730%
0.9324%
0.8422%
0.7908%
0.6896%
0.6382%
0.4856%
0.4745%
0.3302%
0.3191%
0.2775%
0.2733%
0.2622%
0.2234%
0.2081%
0.2012%
0.1915%
0.1804%
0.1429%
0.1152%
0.1096%
0.0763%
0.0264%
2.8571%
5.7143%
8.5714%
11.4286%
14.2857%
17.1429%
20.0000%
22.8571%
25.7143%
28.5714%
31.4286%
34.2857%
37.1429%
40.0000%
42.8571%
45.7143%
48.5714%
51.4286%
54.2857%
57.1429%
60.0000%
62.8571%
65.7143%
68.5714%
71.4286%
74.2857%
77.1429%
80.0000%
82.8571%
85.7143%
88.5714%
91.4286%
94.2857%
97.1429%
100.0000%
14.3531%
28.0916%
41.2029%
53.5928%
62.9303%
70.9442%
75.4811%
79.1162%
82.7236%
85.6025%
88.0305%
90.3365%
92.2095%
93.1419%
93.9840%
94.7749%
95.4644%
96.1027%
96.5883%
97.0628%
97.3930%
97.7121%
97.9896%
98.2629%
98.5251%
98.7485%
98.9566%
99.1578%
99.3493%
99.5297%
99.6726%
99.7877%
99.8973%
99.9736%
100.0000%
A
B
C
合计 72075
序
号
货品名称
出入库总
量(箱)
品目比重
出入库量
比重
累计品目比
重
累计出入
库量比重
分类
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
胡姬花花生油
旺旺雪饼
青食钙奶饼干
上好佳薯片
清风面巾纸
雅培精装奶粉
赤霞珠干红葡萄酒
莎当妮干白葡萄酒
空心牌玻璃杯
青松五香牛肉干
牛栏山二锅头
百事可乐
乐事薯片
金龙鱼调和油
银鹭花生牛奶
海天苹果醋
崂山可乐
望乡挂面
徐福记沙琪玛
华龙粉丝
丘比沙拉酱
统一方便面
涪陵榨菜
米老头米饼
海天葱伴侣黄豆酱
雀巢威化巧克力饼干
菲力普电子节能灯
10345
9902
8930
6730
5776
3270
2620
2075
1750
1350
672
607
497
460
342
238
230
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
18.1759%
17.3976%
15.6898%
11.8244%
10.1483%
5.7453%
4.6033%
3.6457%
3.0747%
2.3719%
1.1807%
1.0665%
0.8732%
0.8082%
0.6009%
0.4182%
0.4041%
0.3461%
0.2829%
0.2635%
0.2548%
0.2284%
0.1810%
0.1458%
0.1388%
0.0966%
0.0334%
100.0000%
3.7037%
7.4074%
11.1111%
14.8148%
18.5185%
22.2222%
25.9259%
29.6296%
33.3333%
37.0370%
40.7407%
44.4444%
48.1481%
51.8519%
55.5556%
18.1759%
35.5735%
51.2633%
63.0877%
73.2360%
78.9813%
83.5846%
87.2303%
90.3050%
92.6769%
93.8576%
94.9241%
95.7973%
96.6055%
97.2064%
A
B
合计
3.7037%
3.7037%
197
3.7037%
161
3.7037%
150
3.7037%
145
3.7037%
130
3.7037%
103
3.7037%
83
3.7037%
79
3.7037%
55
3.7037%
19
3.7037%
56916 100.0000%
59.2593% 97.6246%
62.9630% 98.0287%
66.6667% 98.3748%
70.3704% 98.6577%
74.0741% 98.9212%
77.7778% 99.1760%
81.4815% 99.4044%
85.1852% 99.5854%
88.8889% 99.7312%
92.5926% 99.8700%
96.2963% 99.9666%
100.0000% 100.0000%
C
根据ABC分类原则,现将27种商品按照出入库量进行分类,具体分类如下:
2024年9月19日发(作者:燕山兰)
序
号
商品名称
1
大王牌大豆酶解蛋白粉
黄桃水果罐头
2
3
蜂圣牌蜂皇浆冻干粉片
兴华苦杏仁
4
5
爱牧云南优质小粒咖啡
联广酶解可可豆
6
7
8
9
脆香饼干
吉欧蒂亚干红葡萄酒
利鑫达板栗
隆达葡萄籽油
神奇松花蛋
诚诚油炸花生仁
玫瑰红酒
物动量
4235
2586
1689
1145
590
498
355
230
200
200
186
160
149
136
124
100
80
77
70
69
68
63
62
60
50
48
45
25
20
10
13330
品目比重
物动量比
重
累计品目
比重
3.3333%
6.6667%
10.0000%
13.3333%
16.6667%
20.0000%
23.3333%
26.6667%
30.0000%
33.3333%
36.6667%
40.0000%
43.3333%
46.6667%
50.0000%
53.3333%
56.6667%
60.0000%
63.3333%
66.6667%
70.0000%
73.3333%
76.6667%
80.0000%
83.3333%
86.6667%
90.0000%
93.3333%
96.6667%
------
累计物动量
比重
31.7704%
51.1703%
63.8410%
72.4306%
76.8567%
80.5926%
83.2558%
84.9812%
86.4816%
87.9820%
89.3773%
90.5776%
91.6954%
92.7157%
93.6459%
94.3961%
94.9962%
95.5739%
96.0990%
96.6167%
97.1268%
97.5994%
98.0645%
98.5146%
98.8897%
99.2498%
99.5874%
99.7749%
99.9250%
100%
------
分类
A 3.3333%
31.7704%
3.3333%
19.3998%
3.3333%
12.6707%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
3.3333%
100%
8.5896%
4.4261%
3.7359%
2.6632%
1.7254%
1.5004%
1.5004%
1.3953%
1.2003%
1.1178%
1.0203%
0.9302%
0.7502%
0.6002%
0.5776%
0.5251%
0.5176%
0.5101%
0.4726%
0.4651%
0.4501%
0.3751%
0.3601%
0.3376%
0.1875%
0.1500%
100%
B
10
11
12
13
14
金谷精品杂粮营养粥
15
乐纳可茄汁沙丁鱼罐头
16
17
18
19
20
21
22
23
24
25
早苗栗子西点蛋糕
轩广章鱼小丸子
梦阳奶粉
日月腐乳
休闲黑瓜子
鹏泽海鲜锅底
小师傅方便面
好娃娃薯片
大牛牛奶
金多多婴儿营养米粉
C
26
华冠芝士微波炉爆米花
大厨方便面
27
28
29
30
大嫂什锦水果罐头
山地玫瑰蒸馏果酒
雅比沙拉酱
合计
0.0750%
100%
-----
周转量 周转量比品目比重
序号
货品名称
(箱)
重(%)
(%)
1
2
3
4
5
6
7
8
9
10
巧克力
王老吉
方便面
色拉油
洗发水
花露水
香皂
漱口水
葡萄酒
沐浴露
合计
1000
250
200
160
100
80
50
20
10
5
1875
53.3333%
10.0000%
13.3333%
10.0000%
10.6667%
10.0000%
8.5333%
10.0000%
5.3333%
10.0000%
4.2667%
10.0000%
2.6667%
10.0000%
1.0667%
10.0000%
0.5333%
10.0000%
0.2667%
10.0000%
100% 100%
累计周转量比
重(%)
53.3333%
66.6667%
77.3333%
85.8667%
91.2000%
95.4667%
98.1333%
99.2000%
99.7333%
100.0000%
——
累计品目
比重(%)
10.0000%
20.0000%
30.0000%
40.0000%
50.0000%
60.0000%
70.0000%
80.0000%
90.0000%
100.0000%
——
分类
A
B
C
共
种
物
品
物品编
序号
号
1
2
3
4
5
6
7
8
9
10
10
年消耗
金额
95000
75000
25000
15000
13000
7500
1500
800
425
225
233450
22
68
27
3
82
54
36
19
23
41
合计
占全部
累计品目
资金的累计比重 品目比重
比重
比重
40.69% 40.69%
10.00%
10.00%
32.13% 72.82%
10.00%
20.00%
10.71% 83.53%
10.00%
30.00%
6.43% 89.96%
10.00%
40.00%
5.57% 95.52%
10.00%
50.00%
3.21% 98.74%
10.00%
60.00%
0.64% 99.38%
10.00%
70.00%
0.34% 99.72%
10.00%
80.00%
0.18% 99.90%
10.00%
90.00%
0.10% 100.00%
10.00%
100.00%
100.00% --- 100.00% ---
分类
A
B
C
序
号
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
货品名称
胡姬花花生油
旺旺雪饼
康师傅方便面
青食钙奶饼干
上好佳薯片
清风面巾纸
雅培精装奶粉
赤霞珠干红葡萄酒
乐开怀开心果
莎当妮干白葡萄酒
空心牌玻璃杯
青岛纯生啤酒
青松五香牛肉干
牛栏山二锅头
百事可乐
正航牛奶饼干
乐事薯片
金龙鱼调和油
哇哈哈八宝粥
银鹭花生牛奶
海天苹果醋
崂山可乐
山西老陈醋
望乡挂面
白猫洗衣粉
徐福记沙琪玛
华龙粉丝
丘比沙拉酱
山里红山楂片
统一方便面
涪陵榨菜
米老头米饼
海天葱伴侣黄豆酱
雀巢威化巧克力饼干
菲力普电子节能灯
出入库总
量(箱)
10345
9902
9450
8930
6730
5776
3270
2620
2600
2075
1750
1662
1350
672
607
570
497
460
350
342
238
230
200
197
189
161
150
145
138
130
103
83
79
55
19
品目比重 出入库量比重 累计品目比重
累计出入库量比
重
分
类
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
2.8571%
14.3531%
13.7385%
13.1113%
12.3899%
9.3375%
8.0139%
4.5369%
3.6351%
3.6074%
2.8789%
2.4280%
2.3059%
1.8730%
0.9324%
0.8422%
0.7908%
0.6896%
0.6382%
0.4856%
0.4745%
0.3302%
0.3191%
0.2775%
0.2733%
0.2622%
0.2234%
0.2081%
0.2012%
0.1915%
0.1804%
0.1429%
0.1152%
0.1096%
0.0763%
0.0264%
2.8571%
5.7143%
8.5714%
11.4286%
14.2857%
17.1429%
20.0000%
22.8571%
25.7143%
28.5714%
31.4286%
34.2857%
37.1429%
40.0000%
42.8571%
45.7143%
48.5714%
51.4286%
54.2857%
57.1429%
60.0000%
62.8571%
65.7143%
68.5714%
71.4286%
74.2857%
77.1429%
80.0000%
82.8571%
85.7143%
88.5714%
91.4286%
94.2857%
97.1429%
100.0000%
14.3531%
28.0916%
41.2029%
53.5928%
62.9303%
70.9442%
75.4811%
79.1162%
82.7236%
85.6025%
88.0305%
90.3365%
92.2095%
93.1419%
93.9840%
94.7749%
95.4644%
96.1027%
96.5883%
97.0628%
97.3930%
97.7121%
97.9896%
98.2629%
98.5251%
98.7485%
98.9566%
99.1578%
99.3493%
99.5297%
99.6726%
99.7877%
99.8973%
99.9736%
100.0000%
A
B
C
合计 72075
序
号
货品名称
出入库总
量(箱)
品目比重
出入库量
比重
累计品目比
重
累计出入
库量比重
分类
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
胡姬花花生油
旺旺雪饼
青食钙奶饼干
上好佳薯片
清风面巾纸
雅培精装奶粉
赤霞珠干红葡萄酒
莎当妮干白葡萄酒
空心牌玻璃杯
青松五香牛肉干
牛栏山二锅头
百事可乐
乐事薯片
金龙鱼调和油
银鹭花生牛奶
海天苹果醋
崂山可乐
望乡挂面
徐福记沙琪玛
华龙粉丝
丘比沙拉酱
统一方便面
涪陵榨菜
米老头米饼
海天葱伴侣黄豆酱
雀巢威化巧克力饼干
菲力普电子节能灯
10345
9902
8930
6730
5776
3270
2620
2075
1750
1350
672
607
497
460
342
238
230
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
3.7037%
18.1759%
17.3976%
15.6898%
11.8244%
10.1483%
5.7453%
4.6033%
3.6457%
3.0747%
2.3719%
1.1807%
1.0665%
0.8732%
0.8082%
0.6009%
0.4182%
0.4041%
0.3461%
0.2829%
0.2635%
0.2548%
0.2284%
0.1810%
0.1458%
0.1388%
0.0966%
0.0334%
100.0000%
3.7037%
7.4074%
11.1111%
14.8148%
18.5185%
22.2222%
25.9259%
29.6296%
33.3333%
37.0370%
40.7407%
44.4444%
48.1481%
51.8519%
55.5556%
18.1759%
35.5735%
51.2633%
63.0877%
73.2360%
78.9813%
83.5846%
87.2303%
90.3050%
92.6769%
93.8576%
94.9241%
95.7973%
96.6055%
97.2064%
A
B
合计
3.7037%
3.7037%
197
3.7037%
161
3.7037%
150
3.7037%
145
3.7037%
130
3.7037%
103
3.7037%
83
3.7037%
79
3.7037%
55
3.7037%
19
3.7037%
56916 100.0000%
59.2593% 97.6246%
62.9630% 98.0287%
66.6667% 98.3748%
70.3704% 98.6577%
74.0741% 98.9212%
77.7778% 99.1760%
81.4815% 99.4044%
85.1852% 99.5854%
88.8889% 99.7312%
92.5926% 99.8700%
96.2963% 99.9666%
100.0000% 100.0000%
C
根据ABC分类原则,现将27种商品按照出入库量进行分类,具体分类如下: