ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
Subtotal 90,290 17,054,920 119,222 24,048,897 3,253,898 (492,624) Value
2
20212022 Old business not repeated (2,198,100)
3
Row Labels Qty Sales Qty Sales Price '21 Price '22 Category Volume variance Price variance New business 6,430,803
4
Code1 7,550 1,513,492 8,200 1,507,438 200.46 183.83 Repeat business 130,301 (136,355)
5
Code2 7,700 966,350 7,700 997,019 125.50 129.48 Repeat business - 30,669 Value
6
Code3 2,600 702,858 1,800 446,148 270.33 247.86 Repeat business (216,264) (40,446) Sales in '22 but not in '23 (2,198,100)
7
Code4 2,680 647,676 3,598 773,217 241.67 214.90 Repeat business 221,853 (96,311)
New business - Sales in '23 and not in '22
6,430,803
8
Code5 4,100 589,186 5,200 782,187 143.70 150.42 Repeat business 158,074 34,926 Repeat business - volume variance 3,253,898
9
Code6 2,400 587,770 3,300 790,614 244.90 239.58 Repeat business 220,414 (17,569) Repeat business - price variance (492,624)
10
Code7 1,800 585,562 2,200 700,128 325.31 318.24 Repeat business 130,125 (15,558)
11
Code8 2,650 495,645 4,100 810,191 187.04 197.61 Repeat business 271,202 43,344 Waterfall Chart Working
For graph label
12
Code9 1,900 480,350 4,850 1,175,512 252.82 242.37 Repeat business 745,807 (50,645)'21 Sales - 17,054,920 17,054,920 $ 17.1
13
Code10 2,315 449,238 3,365 634,107 194.06 188.44 Repeat business 203,758 (18,888)Sales in '21 but not in '22 14,856,820 2,198,100 (2,198,100) $ (2.2)
14
Code11 2,350 391,798 2,600 424,055 166.72 163.10 Repeat business 41,681 (9,424)
New business - Sales in '22 and not in '21
 14,856,820 6,430,803 6,430,803 $ 6.4
15
Code12 1,100 332,786 600 177,574 302.53 295.96 Repeat business (151,266) (3,946)Repeat business - volume variance 21,287,623 3,253,898 3,253,898 $ 3.3
16
Code13 1,650 315,349 800 149,573 191.12 186.97 Repeat business (162,453) (3,324)Repeat business - price variance 23,556,272 492,624 (492,624) $ (0.5)
17
Code14 1,650 308,837 1,800 329,589 187.17 183.11 Repeat business 28,076 (7,324)'22 sales - 24,048,897 24,048,897 $ 24.0
18
Code15 4,050 306,277 1,000 73,980 75.62 73.98 Repeat business (230,653) (1,644)
19
Code16 734 284,968 515 195,597 388.24 379.80 Repeat business (85,025) (4,347)
20
Code17 432 248,003 343 192,629 574.08 561.60 Repeat business (51,093) (4,281)
21
Code18 1,050 221,069 1,800 370,737 210.54 205.96 Repeat business 157,907 (8,239)
22
Code19 1,300 211,393 1,000 159,075 162.61 159.08 Repeat business (48,783) (3,535)
23
Code20 1,109 199,930 1,115 195,181 180.28 175.05 Repeat business 1,082 (5,831)
24
Code21 385 196,708 910 453,276 510.93 498.10 Repeat business 268,239 (11,672)
25
Code22 1,450 288,913 199.25 Only sold LY
No sales in both years
No sales in both years
26
Code23 1,200 170,789 500 69,615 142.32 139.23 Repeat business (99,627) (1,547)
27
Code24 388 170,375 600 257,634 439.11 429.39 Repeat business 93,091 (5,832)
28
Code25 599 160,948 999 262,267 268.69 262.53 Repeat business 107,478 (6,158)
29
Code26 950 160,458 1,150 190,016 168.90 165.23 Repeat business 33,781 (4,223)
30
Code27 700 156,556 500 109,395 223.65 218.79 Repeat business (44,730) (2,431)
31
Code28 445 150,250 143 47,233 337.64 330.30 Repeat business (101,967) (1,050)
32
Code29 2,200 141,417 1,800 113,190 64.28 62.88 Repeat business (25,712) (2,515)
33
Code30 173 140,628 81 64,276 812.88 793.53 Repeat business (74,785) (1,567)
34
Code31 1,600 139,634 1,200 102,449 87.27 85.37 Repeat business (34,908) (2,277)
35
Code32 566 135,405 149 34,651 239.23 232.56 Repeat business (99,760) (994)
36
Code33 157 127,312 422 334,528 810.90 792.72 Repeat business 214,889 (7,673)
37
Code34 800 124,038 1,500 227,515 155.05 151.68 Repeat business 108,533 (5,056)
38
Code35 587 119,977 827 164,051 204.39 198.37 Repeat business 49,054 (4,980)
39
Code36 372 117,380 502 154,425 315.54 307.62 Repeat business 41,020 (3,975)
40
Code37 750 116,286 155.05 Only sold LY
No sales in both years
No sales in both years
41
Code38 486 114,144 991 225,874 234.86 227.93 Repeat business 118,606 (6,877)
42
Code39 1,000 113,454 900 99,889 113.45 110.99 Repeat business (11,345) (2,220)
43
Code40 750 110,614 750 108,209 147.49 144.28 Repeat business - (2,405)
44
Code41 296 104,301 722 248,029 352.37 343.53 Repeat business 150,109 (6,381)
45
Code42 500 100,211 650 127,442 200.42 196.06 Repeat business 30,063 (2,832)
46
Code43 302 94,118 335 101,274 311.65 302.31 Repeat business 10,284 (3,129)
47
Code44 293 92,004 584 179,393 314.01 307.18 Repeat business 91,376 (3,987)
48
Code45 400 91,087 227.72 Only sold LY
No sales in both years
No sales in both years
49
Code46 502 90,818 471 82,449 180.91 175.05 Repeat business (5,608) (2,761)
50
Code47 800 89,976 700 77,018 112.47 110.03 Repeat business (11,247) (1,711)
51
Code48 350 87,636 250.39 Only sold LY
No sales in both years
No sales in both years
52
Code49 500 85,077 170.15 Only sold LY
No sales in both years
No sales in both years
53
Code50 1,000 83,196 83.20 Only sold LY
No sales in both years
No sales in both years
54
Code51 417 79,068 508 94,229 189.61 185.49 Repeat business 17,255 (2,094)
55
Code52 550 78,278 142.32 Only sold LY
No sales in both years
No sales in both years
56
Code53 410 74,233 1,066 186,603 181.06 175.05 Repeat business 118,773 (6,403)
57
Code54 229 71,667 312.96 Only sold LY
No sales in both years
No sales in both years
58
Code55 500 71,162 800 111,384 142.32 139.23 Repeat business 42,697 (2,475)
59
Code56 350 71,162 203.32 Only sold LY
No sales in both years
No sales in both years
60
Code57 294 69,532 370 85,604 236.50 231.36 Repeat business 17,974 (1,902)
61
Code58 300 68,315 227.72 Only sold LY
No sales in both years
No sales in both years
62
Code59 700 65,792 700 64,039 93.99 91.48 Repeat business - (1,753)
63
Code60 400 65,062 162.66 Only sold LY
No sales in both years
No sales in both years
64
Code61 850 64,958 400 29,448 76.42 73.62 Repeat business (34,389) (1,120)
65
Code62 300 63,163 210.54 Only sold LY
No sales in both years
No sales in both years
66
Code63 304 62,648 343 68,041 206.08 198.37 Repeat business 8,037 (2,644)
67
Code64 300 62,216 207.39 Only sold LY
No sales in both years
No sales in both years
68
Code65 303 61,890 55 10,939 204.26 198.90 Repeat business (50,656) (295)
69
Code66 173 59,994 539 182,252 346.79 338.13 Repeat business 126,925 (4,667)
70
Code67 350 59,554 700 116,519 170.15 166.46 Repeat business 59,554 (2,589)
71
Code68 285 57,791 357 70,818 202.78 198.37 Repeat business 14,600 (1,574)
72
Code69 368 55,319 54 7,932 150.32 146.88 Repeat business (47,202) (186)
73
Code70 251 54,994 219.10 Only sold LY
No sales in both years
No sales in both years
74
Code71 250 50,830 1,000 198,900 203.32 198.90 Repeat business 152,490 (4,420)
75
Code72 370 50,050 169 22,184 135.27 131.26 Repeat business (27,189) (677)
76
Code73 135 46,953 85 28,921 347.80 340.24 Repeat business (17,390) (642)
77
Code74 544 42,931 224 16,934 78.92 75.60 Repeat business (25,254) (743)
78
Code75 200 39,851 850 165,684 199.25 194.92 Repeat business 129,515 (3,682)
79
Code76 156 38,499 141 34,041 246.79 241.42 Repeat business (3,702) (756)
80
Code77 328 38,410 51 5,786 117.10 113.45 Repeat business (32,438) (187)
81
Code78 50 36,296 725.93 Only sold LY
No sales in both years
No sales in both years
82
Code79 96 35,556 370.37 Only sold LY
No sales in both years
No sales in both years
83
Code80 200 35,023 530 89,938 175.12 169.69 Repeat business 57,788 (2,873)
84
Code81 281 33,582 537 62,781 119.51 116.91 Repeat business 30,594 (1,395)
85
Code82 200 32,522 162.61 Only sold LY
No sales in both years
No sales in both years
86
Code83 104 31,603 303.88 Only sold LY
No sales in both years
No sales in both years
87
Code84 166 31,396 49 8,983 189.13 183.33 Repeat business (22,129) (284)
88
Code85 262 29,175 111.35 Only sold LY
No sales in both years
No sales in both years
89
Code86 73 29,087 398.45 Only sold LY
No sales in both years
No sales in both years
90
Code87 78 28,970 371.40 Only sold LY
No sales in both years
No sales in both years
91
Code88 30 28,160 938.68 Only sold LY
No sales in both years
No sales in both years
92
Code89 56 26,471 472.70 Only sold LY
No sales in both years
No sales in both years
93
Code90 154 24,900 370 58,525 161.69 158.17 Repeat business 34,925 (1,301)
94
Code91 100 23,644 292 67,540 236.44 231.30 Repeat business 45,397 (1,501)
95
Code92 102 23,422 60 13,478 229.63 224.64 Repeat business (9,645) (299)
96
Code93 63 23,398 232 79,803 371.40 343.98 Repeat business 62,767 (6,362)
97
Code94 38 22,480 591.59 Only sold LY
No sales in both years
No sales in both years
98
Code95 86 21,778 75 18,579 253.23 247.72 Repeat business (2,786) (413)
99
Code96 155 21,461 209 28,309 138.46 135.45 Repeat business 7,477 (629)
100
Code97 136 21,347 32 4,837 156.96 151.16 Repeat business (16,324) (186)