零售链培训手册

TY
0 0.00 0.00
LY
100,259 30.41 1.71 205,493 179,112
Diff
(39%) 1.34% (1%) (64%) 62.81%
LY
Diff
LY
Diff
LY
Diff
LY
Diff
LY
Diff
LY
Diff
460,912 (28%) 28.16 0.37% 1.85 (0%)
16.01%
7.6515.08%
8.66% 0.68
16.05% 14.74% 8.91% 68.13% 0.72
7.46
0.17
17.26% (100%)
-1%
Maintain Margin % GMROII
29.12% 0.17
0.95
0.79
0.53
IM%=(Gross ship retail-Gross 1,108,148 795,271 39.34%ship cost) 3,583,900 Gross ship retail 944,321 679,653 38.94% 3,034,191
6.57%
(1%) 4.67%
3,082,300
3.43% 2,990,972 260,557 12.77%
2,876,766
2,831,448
9,271,031 (100%)
5,265,579 (100%)
7.14%
5,014,677 747,373 366,525
2.01% 5,398,633 714,022 428,491
98.34% 7.47
96.41% 2.00%
12.11%
(6%)
(5%)
97.57% 7.62
5,687,053
97.58% (0%) 7.88 (3%) 401,395 1.13%
(2%)
98.03% 7.37
5,135,725
源自文库
220,152 82.33%
310,580 (100%)
97.14% 0.91% 7.46 (1%) 220,152
EDI Pickup Rate
3.11%
6.01%
(48%)
0.00% (6%) 0.00% 0.00% 0.00% 0.00%
10.49%
0.00 68.79% 99.89% 0.00% 0.00 0.00 0.43
11.62% (10%)
0.00 76.05% 99.93% 0.00% 0.00 0.00
4.40% 3.74% 5.38%
3,082,300 2,876,766 7.14% 2,990,972 2,831,448 5.63% 5,687,053 5,135,725 10.74% 4,862,146 4,381,629 10.97% 401,395
0 0 0 0 0
9,394,241 (100%)
1,108,148
944,321 14.78% 12.14%
795,271
679,653 14.54% 9.40%
39.34% 3,583,900 3,347,204 7.07% 25,727,929 26,211,084
38.94% 3,034,191 2,870,681 5.70% 21,516,123 22,014,901 15.34% 6.45% 14.24% 7.74% 4.27% 51.00% 0.36
165,494 96.43%
9.90 (100%) 5.25 (100%)
TY
342,255
396,090
LY
(14%)
495,687
Diff
609,145 (19%)
194,107
TY
253,988
(24%)
325,080
165,494 96.43%
0
Diff
310,696 (100%)
STORE
772,140 747,373 724,540 714,022 All Comp Store Sales Retail Dollar Inventory Cost Dollar Inventory Cost On Order 5,927,002 5,286,924 5,109,606 4,505,415 356,649 166,644
4,382,048 (100%)
5.63%
114.02%
Instock %
98.06%
97.42%
0.67% 1.02%
98.03% 7.37
97.14% 0.91% 7.46
5,927,002
(1%) 356,649
97.96% 7.52
97.01%
5,286,924
0.98% (2%)
(2%)
671,523 (36%)
323,439
334,158
14.24%
4.27% 0.00% 0.36
(10%) (0%) 0.00% 0.00% 0.00%
(3%)
603,110 (100%)
7.74%
Percent To Sales VENDOR SUMMARY Avg Lead Time(Cal Days) Repl Order Fill Rate % Non-Repl Order Fill Rate % Invoice Match Rate % Prepaid Transit(Cal Days) Collect Transit(Cal Days)
0.00% 0.00 0
0 0.00% 0.00% 0.00
98.55% (100%)
10.74%
Store Weeks On Hand Ships At Retail
Ships At Cost
7.73
7.65
7.99
(6%) 166,644
8.25 (9%) 114.02%
7.38 (100%) 82.33%
TY
3,454,774 21.32 2.44
Quarter 2 (201810-201822 / 201710-201722)
TY
1,972,509 11.76 4.42
Quarter 3 (201823-201826 / 201723-201726)
TY
330,558 28.26 1.84
Quarter 4 (201836-201848 / 201736-201748)
12.14% 0.00%
(10%) (0%) 0.00% 0.00% 0.00%
(3%)
1,524,538
1,928,285
14.54%
(23%)
(2%) (1%) 0.00% 0.00% 0.00%
(21%)
798,023
815,093
(2%)
403,076
779,034
15.34%
(50%)
(48%)
6.42% (100%)
0.00 0.00 69.23% 73.91% 100.00% 100.00% 0.00% 0.00% 0.00 0.00 0.00 0.00 0.38 0.31
98.06%
97.42%
2.26%
12,472,096 13,300,360
10,591,471 11,115,949 16.42%
0.67%
(8%) 1.02%
9,671,933 9,563,520
7,890,461 8,028,271 18.42% 14.98%
98.03%
7.37
0.50
3,583,900 3,347,204 7.07%
6.57%
0.00 67.55% 91.02% 0.00% 0.00 0.00 0.47
8.54%
0.00 68.96% 91.60% 0.00% 0.00 0.00 0.49
7.56%
0.00 71.81% 92.19% 0.00% 0.00 0.00 0.41
7.72%
(2%)
4.22%
0.00 61.38% 85.73% 0.00% 0.00 0.00 0.54
零售链报告解读及AMS
Retail Link Report & AMS
Merchandising Training Team
沃尔玛大卖场采购部
大卖场采购部培训组
培训内容
• 供应商表现积分卡报告 • 购物篮分析报告 • 进销存报告 • 订单分货报告 • AMS系统收费/折扣
沃尔玛大卖场采购部
2
沃尔玛日历
6.57% 3,082,300 2,876,766 7.14% 23,190,228 22,584,824 4.67% 2,990,972 2,831,448 5.63% 22,635,571 22,104,058
2.68% 2.40% 1.94%
10,552,266 10,554,754
(0%)
9,555,662 9,153,304 9,301,421 8,965,823 5,664,794 5,375,508 4,677,654 4,522,519 293,830
8.51%
0.00 74.85% 99.15% 0.00% 0.00 0.00
10.49%
0.00 68.79% 99.89% 0.00% 0.00 0.00 0.43
11.62% (10%)
0.00 76.05% 99.93% 0.00% 0.00 0.00
0.00%
0.00 0.00% 0.00% 0.00% 0.00 0.00 0.00
3,034,191 2,870,681 5.70% 15.34% 6.45% 0.53 14.24% 7.74%
97.14%
4.27% 51.00% 0.36
9,026,719 (100%)
7,468,434 (100%)
0.91%
Initial Margin %
7.7316.37%
10.87% 0.87
Sales
STORE Sales All Comp Store Sales Retail Dollar Inventory Cost On Order Instock % Store Weeks On Hand Ships At Retail Ships At Cost MARKDOWNS Initial Margin % Maintain Margin % GMROII MARKDOWNS 沃尔玛大卖场采购部 Dollars
8.84% 23.02% 0.70 9.97% (13%) 0.17 0.17 0.77 (0.09) 1.22 334,158
3,347,204 2,870,681
11.95% (100%) 1.02
7.07%
(1.02)
5.70%
0
Dollars
23,994
43,574
(45%)
323,439
14.78%
Last Week
3,750,781 53.51% 25.80 (33%) 2.02 50.15% 17.18 3.03
2,387,880 44.68% 25.85 (18%) 2.01 21.28%
901,989 118.68% 24.81 (53%) 2.10 110.98%
Month LY
460,912 (28%) 28.16 0.37% 1.85 (0%)
Month (201836-201836 / 201736-201736)
TY
330,558 28.26 1.84 159,128 325,080
Year (201749-201836 / 201649-201736)
TY
5,757,841
Quarter 1 (201749-201809 / 201649-201709)
1,349,359 (100%)
(201836-201836 / 201736-201736) (201836-201836 /241,766 201736-201736) 241,766 (34%) 649,307 293,273 121.40% 711,313 415,762 71.09% 738,126 186,632 295.50% 159,128 (34%) 0 736,010 (100%)
沃尔玛大卖场采购部
3
沃尔玛日历
• 沃尔玛月WM Month
沃尔玛大卖场采购部
4
供应商表现积分卡
Last Week (201836-201836 / 201736-201736)
TY
WAREHOUSE Ships At Cost Instock % Warehouse Turns Warehouse Weeks On Hand Cost On Hand Cost On Order 61,194 30.82 1.69 73,655 291,612
12.11% 5,687,053 5,135,725 10.74% 13.41% 4,862,146 4,381,629 10.97% 401,395 220,152 82.33%
772,140
5,959,634
5,846,081 4,915,779 433,255
724,540
(15%)
10,343,177 10,306,787 0.35% 6,338,344 6,535,225 5,473,392 (3%)