1 Introduction
2 Collection and preprocessing of order data
2.1 Collection of order data
2.2 Preprocessing of order data
3 Clustering and association analysis of the ordered goods
3.1 Clustering analysis of the ordered goods
Clustering results | Category 1 | Category2 | Category 3 |
---|---|---|---|
Category | B | A | C |
Quantity | 15 | 12 | 85 |
Cluster center | |||
Sales volume | − 0.100210 | 2.483434 | − 0.332918 |
Price | 2.075549 | − 0.496433 | − 0.296189 |
Goods | Type | Goods | Type | Goods | Type |
---|---|---|---|---|---|
Cooking appliances | B | Pillows | C | Teapots | C |
Juicers | B | Sheets | C | Paper towels | A |
Rice cookers | B | Blankets | C | Laundry products | A |
Electric pressure cookers | B | Mattresses | C | Cleaning supplies | C |
Soy milk | B | Mosquito netting | C | Deworming supplies | C |
Coffee machines | B | Cushions | C | Family cleaning supplies | A |
Microwave ovens | B | Bath towels | C | Leather care | C |
Electric ovens | B | Electric blankets | C | Hand and foot skin care | C |
Induction cookers | B | Curtains/screens | C | Weight loss products | C |
Bread machines | B | Home decoration fabrics | C | Body care | C |
Egg boilers | C | Summer sleeping mats | C | Nursing clothing | C |
Yogurt machines | C | Heat protection | C | Massage oil | C |
Electric cookers | C | Storage supplies | C | Hairdressing tools | C |
Thermoses | C | Umbrellas and rain gear | C | Hair dye | C |
Electric baking pans | C | Bathroom supplies | C | Aromatherapy oil | C |
Multipurpose pots | C | Knitting supplies | C | Bath salts | C |
Electric grills | C | Laundry/ironing supplies | C | Handmade soap | C |
Fruit and vegetable processing machines | C | Decontamination products | C | Shampoo | A |
Health pots | C | Kitchen knives | C | Conditioner | A |
Electric lunchboxes | C | Scissors | C | Hair coloring | C |
Shavers | C | Tool sets | C | Scrubs | A |
Shavers/epilators | C | Cutting boards | C | Soap | A |
Oral care | A | Fruit knives/planes | C | Toothpaste/dental powder | C |
Hair dryers | C | Multifunction knives | C | Toothbrushes/floss | C |
Beauty equipment | B | Plastic cups | C | Mouthwash | A |
Barbering supplies | A | Sports bottles | C | Nursing supplies | A |
Volumizer/hair straightener | C | Glasses | C | Dusters | C |
Massagers | B | Porcelain cups | C | Ottomans | C |
Foot tubs | C | Insulated cups | C | Seat cushions | B |
Sphygmomanometers | B | Insulated pots | C | Seat covers | B |
Electronic scales | C | Wine glasses/wine | C | Headrests and lumbar support | A |
Blood glucose meters | A | Bowls/plates | C | ||
Thermometers | C | Chopsticks/spoons, knives and forks | C | ||
Tablecloths | C | Fruit baskets | C | ||
Carpets and floor mats | C | Cups | C | ||
Sofa cushion covers | C | Teapots | C | ||
Bedding kits | C | Tea trays | C | ||
Quilts | C | Earmuffs | C |
Clustering results | Category 1 | Category2 | Category 3 |
---|---|---|---|
Category | A | B | C |
Quantity | 13 | 37 | 59 |
Sales volume | 2.228878 | − 0.233553 | − 0.341001 |
Cluster center | |||
Price | − 0.514112 | 1.035768 | − 0.484728 |
Favorable rate | 1.077490 | 0.214221 | − 0.352542 |
Free shipping | − 0.717296 | 1.234126 | − 0.555239 |
Cash on delivery | 1.262652 | 0.227063 | − 0.399372 |
Goods | Type | Goods | Type | Goods | Type |
---|---|---|---|---|---|
Cooking appliances | B | Pillows | B | Teapots | C |
Juicers | B | Sheets | B | Paper towels | A |
Rice cookers | B | Blankets | C | Laundry products | A |
Electric pressure cookers | B | Mattresses | B | Cleaning supplies | C |
Soy milk | B | Mosquito netting | C | Deworming supplies | C |
Coffee machines | B | Cushions | C | Family cleaning supplies | A |
Microwave ovens | B | Bath towels | C | Leather care | C |
Electric ovens | B | Electric blankets | C | Hand and foot skin care | C |
Induction cookers | B | Curtains/screens | C | Weight loss products | C |
Bread machines | B | Home decoration fabrics | C | Body care | C |
Egg boilers | C | Summer sleeping mats | C | Nursing clothing | C |
Yogurt machines | B | Heat protection | C | Massage oil | C |
Electric cookers | B | Storage supplies | C | Hairdressing tools | A |
Thermoses | B | Umbrellas and rain gear | C | Hair dye | C |
Electric baking pans | B | Bathroom supplies | C | Aromatherapy oil | C |
Multipurpose pots | B | Knitting supplies | C | Bath salts | C |
Electric grills | B | Laundry/ironing supplies | C | Handmade soap | C |
Fruit and vegetable processing machines | B | Decontamination products | C | Shampoo | A |
Health pots | B | Kitchen knives | C | Conditioner | A |
Electric lunchboxes | B | Scissors | C | Hair coloring | C |
Shavers | C | Tool sets | B | Scrubs | A |
Shavers/epilators | B | Cutting boards | C | Soap | A |
Oral care | A | Fruit knives | C | Toothpaste/dental powder | C |
Hair dryers | A | Multifunction knives | C | Toothbrushes/floss | C |
Beauty equipment | B | Plastic cups | C | Mouthwash | A |
Barbering supplies | B | Sports bottles | C | Nursing supplies | A |
Volumizer/hair straightener | B | Glasses | C | Dusters | C |
Massagers | B | Porcelain cups | C | Ottomans | B |
Foot tubs | B | Insulated cups | C | Seat cushions | B |
Sphygmomanometers | B | Insulated pots | B | Seat covers | B |
Electronic scales | C | Wine glasses/wine | B | Headrests and lumbarsupport | C |
Blood glucose meters | A | Bowls/plates | B | ||
Thermometers | C | Chopsticks/spoons, knives and forks | C | ||
Tablecloths | C | Fruit baskets | C | ||
Carpets and floor mats | C | Cups | C | ||
Sofa cushion covers | C | Teapots | C | ||
Bedding kits | B | Tea trays | C | ||
Quilts | B | Earmuffs | C |
Goods | Code | Goods | Code | Goods | Code |
---|---|---|---|---|---|
Cooking appliances | G1 | Pillows | G39 | Teapots | G40 |
Juicers | G2 | Sheets | G40 | Paper towels | G41 |
Rice cookers | G3 | Blankets | G41 | Laundry products | G42 |
Electric pressure cookers | G4 | Mattresses | G42 | Cleaning supplies | G43 |
Soy milk | G5 | Mosquito netting | G43 | Deworming supplies | G44 |
Coffee machines | G6 | Cushions | G44 | Family cleaning supplies | G40 |
Microwave ovens | G7 | Bath towels | G45 | Leather care | G41 |
Electric ovens | G8 | Electric blankets | G46 | Hand and foot skin care | G42 |
Induction cookers | G9 | Curtains/screens | G47 | Weight loss products | G43 |
Bread machines | G10 | Home decoration fabrics | G48 | Body care | G44 |
Egg boilers | G11 | Summer sleeping mats | G49 | Nursing clothing | G40 |
Yogurt machines | G12 | Heat protection | G50 | Massage oil | G41 |
Electric cookers | G13 | Storage supplies | G51 | Hairdressing tools | G42 |
Thermoses | G14 | Umbrellas and rain gear | G52 | Hair dye | G43 |
Electric baking pans | G15 | Bathroom supplies | G53 | Aromatherapy oil | G44 |
Multipurpose pots | G16 | Knitting supplies | G54 | Bath salts | G40 |
Electric grills | G17 | Laundry/ironing supplies | G55 | Handmade soap | G41 |
Fruit and vegetable processing machines | G18 | Decontamination products | G56 | Shampoo | G42 |
Health pots | G19 | Kitchen knives | G57 | Conditioner | G43 |
Electric lunchboxes | G20 | Scissors | G58 | Hair coloring | G44 |
Shavers | G21 | Tool sets | G59 | Scrubs | G40 |
Shavers/epilators | G22 | Cutting boards | G60 | Soap | G41 |
Oral care | G23 | Fruit knives | G61 | Toothpaste/dental powder | G42 |
Hair dryers | G24 | Multifunction knives | G62 | Toothbrushes/floss | G40 |
Beauty equipment | G25 | Plastic cups | G63 | Mouthwash | G41 |
Barbering supplies | G26 | Sports bottles | G64 | Nursing supplies | G42 |
Volumizer/hair straightener | G27 | Glasses | G65 | Dusters | G43 |
Massagers | G28 | Porcelain cups | G66 | Ottomans | G44 |
Foot tubs | G29 | Insulated cups | G67 | Seat cushions | G40 |
Sphygmomanometers | G30 | Insulated pots | G68 | Seat covers | G41 |
Electronic scales | G31 | Wine glasses/wine | G69 | Headrests and lumbar support | G42 |
Blood glucose meters | G32 | Bowls/plates | G70 | ||
Thermometers | G33 | Chopsticks/spoons, knives and forks | G71 | ||
Tablecloths | G34 | Fruit baskets | G72 | ||
Carpets and floor mats | G35 | Cups | G73 | ||
Sofa cushion covers | G36 | Teapots | G74 | ||
Bedding kits | G37 | Tea trays | G75 | ||
Quilts | G38 | Earmuffs | G76 |
3.2 Association analysis of the ordered goods
Product name | Product code |
---|---|
Thermos | G14 |
Mattress | G42 |
Cushion | G44 |
Bath towel | G45 |
Home decoration fabric | G48 |
Decontamination product | G56 |
Glass | G65 |
Chopsticks/spoon, knife and fork | G71 |
Teapot | G77 |
Cleaning supplies | G80 |
Electric cooker | G13 |
Knitting supplies | G54 |
Electric grill | G17 |
Bedding kit | G37 |
Cup | G73 |
Handmade soap | G93 |
Insulated cup | G67 |
Pillow | G39 |
Teapot | G101 |
4 Improved warehousing strategy
4.1 Goods placement principle in the traditional class-based storage strategy
Frequent 2-item sets | Support | Frequent 3-item sets | Support | Frequent 4-item sets | Support | Frequent 5-item sets | Support |
---|---|---|---|---|---|---|---|
G32-G19 | 342 | G65-G43-G15 | 231 | G65-G43-G15-G1 | 89 | G65-G43-G15-G1-G100 | 25 |
G78-G81 | 316 | G78-G81-G80 | 209 | G78-G81-G80-G79 | 74 | G78-G81-G80-G79-G74 | 19 |
G51-G56 | 298 | G51-G56-G53 | 187 | G51-G56-G53-G15 | 63 | G51-G56-G53-G15-G96 | 19 |
G98-G45 | 273 | G98-G45-G61 | 176 | G98-G45-G61-G34 | 54 | G98-G45-G61-G34-G10 | 12 |
G23-G21 | 254 | G23-G21-G57 | 164 | G23-G21-G57-G22 | 46 | G23-G21-G57-G22-G83 | 11 |
G82-G103 | 231 | G82-G103-G53 | 151 | G82-G103-G53-G43 | 41 | G82-G103-G53-G43-G16 | 11 |
G24-G95 | 224 | G24-G95-G35 | 143 | G24-G95-G35-G51 | 32 | G24-G95-G35-G51-G69 | 8 |
G24-G95 | 197 | G24-G95-G16 | 124 | G24-G95-G16-G43 | 21 | G24-G95-G16-G43-G102 | 8 |
G101-G65 | 167 | G101-G65-G80 | 112 | G101-G65-G80-G15 | 16 | G101-G65-G80-G15-G24 | 5 |
... | ... | ... | ... | ... | ... | ... | ... |
Frequent2-item sets | Support | Frequency of X occurrence | Confidence, P(X \(\vert \) Y) (%) | Frequency of Y occurrence | Frequency of Y occurrence (%) | Higher degree of confidence (%) |
---|---|---|---|---|---|---|
G32-G19 | 342 | 628 | 54.46 | 723 | 47.30 | 54.46 |
G78-G81 | 316 | 908 | 34.80 | 810 | 39.01 | 39.01 |
G51-G56 | 298 | 1123 | 26.54 | 794 | 37.53 | 37.53 |
G98-G45 | 273 | 987 | 27.66 | 881 | 30.99 | 30.99 |
G23-G21 | 254 | 782 | 32.48 | 890 | 28.54 | 32.48 |
G82-G103 | 231 | 617 | 37.44 | 574 | 40.24 | 40.24 |
G24-G95 | 224 | 792 | 28.28 | 681 | 32.89 | 32.89 |
G24-G95 | 197 | 510 | 38.63 | 656 | 30.03 | 38.63 |
G101-G65 | 182 | 623 | 29.21 | 1092 | 16.67 | 29.21 |
G14-G50 | 167 | 962 | 17.36 | 642 | 26.01 | 26.01 |
G57-G60 | 163 | 491 | 33.20 | 673 | 24.22 | 33.20 |
G68-G33 | 152 | 552 | 27.54 | 527 | 28.84 | 28.84 |
G49-G43 | 140 | 709 | 19.75 | 792 | 17.68 | 19.75 |
... | ... | ... | ... | ... | ... | ... |
Related product code-1 | Related product code-2 | Support | Confidence (%) |
---|---|---|---|
G32 | G19 | 342 | 54.46 |
G78 | G81 | 316 | 39.01 |
G51 | G56 | 298 | 37.53 |
G98 | G45 | 273 | 30.99 |
G23 | G21 | 254 | 32.48 |
G82 | G103 | 231 | 40.24 |
G24 | G95 | 224 | 32.89 |
G101 | G65 | 197 | 38.63 |
G14 | G50 | 182 | 29.21 |
G57 | G60 | 167 | 26.01 |
G68 | G33 | 163 | 33.20 |
G73 | G75 | 130 | 24.57 |
G79 | G74 | 109 | 33.18 |
4.2 Improved class-based storage strategy
5 Order picking efficiency test
5.1 Picking environment
Parameter(unit: m) | Parameter description |
---|---|
\(W = 3 \) | Cross-aisle width |
\(Z = 1.5 \) | Picking aisle width |
\(S = 1 \) | Width of the opening |
\(L = 3 \) | Width of each double row of back-to-back shelves |
\(d = 2 \) | Distance from the cross-aisle to a picking aisle |
\(e = 0.75\) | Distance walked from the picking aisle for a picking operation |
\(g = 1 \) | Distance from a picking aisle to the cross-aisle |
5.2 Picking distance calculation formulas
Traditional simulation results | 1\(\hbox {st}\) improvement simulation results | 2\(\hbox {nd}\) improvement simulation results |
---|---|---|
70.83 | 66.72 | 60.63 |
75.30 | 70.25 | 62.42 |
76.83 | 73.83 | 66.15 |
77.45 | 74.42 | 63.43 |
79.39 | 73.75 | 67.95 |
78.83 | 75.75 | 65.66 |
73.76 | 69.48 | 62.54 |
75.14 | 72.21 | 62.59 |
75.85 | 71.90 | 64.32 |
75.22 | 72.29 | 62.36 |
74.72 | 71.43 | 62.24 |
71.62 | 67.47 | 61.31 |
70.35 | 67.60 | 59.65 |
73.85 | 69.86 | 62.62 |
71.37 | 67.66 | 60.09 |
73.49 | 67.54 | 63.27 |
73.92 | 70.07 | 60.54 |
76.08 | 72.12 | 63.37 |
74.76 | 70.42 | 62.28 |
72.94 | 70.10 | 60.47 |
75.91 | 71.96 | 65.36 |
74.17 | 69.86 | 61.78 |
70.22 | 66.57 | 58.49 |
74.91 | 69.89 | 64.49 |
71.08 | 68.31 | 58.21 |
75.64 | 72.31 | 64.75 |
76.64 | 72.19 | 65.98 |
80.81 | 76.60 | 66.18 |
79.15 | 76.06 | 64.82 |