ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI
1
2
LYPLANACTVolumeMixPriceVolumeMixPrice
3
BrandUnits% totalPriceTurnoverUnits% totalPriceTurnoverUnits% totalPriceTurnoverDev ACT vs PLAN (+ favorable / - unfavorable)Dev ACT vs LY (+ favorable / - unfavorable)Actual volume at plan mixActual Turnover at plan mixVolume EffectMix effect on volumeMix effectPrice effectActual volume at LY mixActual Turnover at LY mixVolume EffectMix effect on volumeMix effectPrice effect
4
Brand 2 17 4% 5,705 96,985 13 3% 6,900 89,700 10 3% 6,500 65,000 -24,700-31,985 11 76,175 - 13,525 - 1 - 7,175 - 4,000 14 79,540 - 17,445 - 4 - 22,490 7,950
5
Brand 5 16 3% 9,375 150,000 24 5% 7,000 168,000 20 5% 8,000 160,000 -8,00010,000 20 142,670 - 25,330 - 0 - 2,670 20,000 13 123,019 - 26,981 7 64,481 - 27,500
6
Brand 6 2 0% 5,500 11,000 9 2% 5,555 49,995 7 2% 5,500 38,500 -11,49527,500 8 42,457 - 7,538 - 1 - 3,572 - 385 2 9,021 - 1,979 5 29,479 -
7
Brand 11 38 8% 5,263 199,994 45 10% 6,666 299,970 37 10% 8,000 296,000 -3,97096,006 38 254,742 - 45,228 - 1 - 8,100 49,358 31 164,021 - 35,973 6 30,710 101,269
8
Brand 13 22 5% 6,000 132,000 23 5% 7,500 172,500 34 9% 6,800 231,200 58,70099,200 20 146,491 - 26,009 14 108,509 - 23,800 18 108,257 - 23,743 16 95,743 27,200
9
Brand 14 9 2% 4,333 38,997 - 0% - - - 0% - - 0-38,997 - - - - - - 7 31,983 - 7,014 - 7 - 31,983 -
10
Brand 16 3 1% 17,000 51,000 8 2% 16,800 134,400 2 1% 19,500 39,000 -95,400-12,000 7 114,136 - 20,264 - 5 - 80,536 5,400 2 41,827 - 9,173 - 0 - 7,827 5,000
11
Brand 17 18 4% 13,250 238,500 24 5% 14,000 336,000 23 6% 13,000 299,000 -37,00060,500 20 285,339 - 50,661 3 36,661 - 23,000 15 195,601 - 42,899 8 109,149 - 5,750
12
Brand 21 20 4% 7,850 157,000 30 7% 8,500 255,000 20 5% 8,500 170,000 -85,00013,000 25 216,552 - 38,448 - 5 - 46,552 - 16 128,760 - 28,240 4 28,240 13,000
13
Brand 22 6 1% 4,250 25,500 11 2% 4,700 51,700 7 2% 5,000 35,000 -16,7009,500 9 43,905 - 7,795 - 2 - 11,005 2,100 5 20,913 - 4,587 2 8,837 5,250
14
Brand 23 11 2% 6,227 68,497 11 2% 6,500 71,500 8 2% 6,500 52,000 -19,500-16,497 9 60,720 - 10,780 - 1 - 8,720 - 9 56,176 - 12,321 - 1 - 6,360 2,184
15
Brand 24 3 1% 10,833 32,499 7 2% 14,900 104,300 4 1% 13,800 55,200 -49,10022,701 6 88,574 - 15,726 - 2 - 28,974 - 4,400 2 26,653 - 5,846 2 16,679 11,868
16
Brand 26 69 15% 7,246 499,974 92 20% 8,500 782,000 73 19% 8,000 584,000 -198,00084,026 78 664,093 - 117,907 - 5 - 43,593 - 36,500 57 410,043 - 89,931 16 118,915 55,042
17
Brand 31 1 0% 4,000 4,000 1 0% 9,000 9,000 - 0% - - -9,000-4,000 1 7,643 - 1,357 - 1 - 7,643 - 1 3,281 - 719 - 1 - 3,281 -
18
Brand 37 3 1% 9,000 27,000 3 1% 10,000 30,000 6 2% 9,000 54,000 24,00027,000 3 25,477 - 4,523 3 34,523 - 6,000 2 22,143 - 4,857 4 31,857 -
19
Brand 39 72 15% 4,861 349,992 53 12% 6,000 318,000 39 10% 6,000 234,000 -84,000-115,992 45 270,053 - 47,947 - 6 - 36,053 - 59 287,038 - 62,954 - 20 - 97,459 44,421
20
Brand 40 10 2% 4,150 41,500 2 0% 5,700 11,400 2 1% 5,500 11,000 -400-30,500 2 9,681 - 1,719 0 1,719 - 400 8 34,035 - 7,465 - 6 - 25,735 2,700
21
Brand 61 147 31% 3,741 549,927 95 21% 4,900 465,500 91 24% 4,900 445,900 -19,600-104,027 81 395,314 - 70,186 10 50,586 - 121 451,011 - 98,916 - 30 - 110,580 105,469
22
 467 100%2,674,365 451 100% 3,348,965 383 100% 2,769,800 -579,16595,435 383 2,844,021 - 504,944 0 - 52,594 - 21,627 383 2,193,323 - 481,042 0 228,374 348,103
23
24
25
PLAN 3,349
26
Volume- 505
27
Mix- 53
28
Price- 22
29
ACT 2,770
30
 -
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
LY 2,674
59
Volume- 481
60
Mix 228
61
Price 348
62
ACT 2,770
63
 -
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100