2020 Current Pricing File.xlsx

	B	C	D	E	F	G	H	I	J	K	L	Q
1
2
3
4
5
6
7
8
9
10
11	TOTAL ISSUES				TOP 25 BRAND ROLLUP				STATE ITEM COMBINATION ISSUES
12	#REF!				RANK	ITEM GROUP	ERRORS		STATE	ITEM	ERRORS
13					1	PINNACLE BSE/WHP 750ML	622	#REF!	FL	PINNACLE BSE/WHP 750ML	430	<<<<NOTES HIDDEN FOR QUICK ANSWERS
14	TOP 10 STATE ROLLUP				2	JIM BEAM WH/FL 750ML	584	#REF!	FL	MAKERS MARK 750ML	357
15	RANK	STATE	ERRORS		3	EFFEN 750ML	447	#REF!	OH	DEKUYPER SCHNAPPS 750ML 6PK	331
16	1	FL	2,275	#REF!	4	DEKUYPER SCHNAPPS 750ML 6PK	395	#REF!	FL	MAKERS MARK 1.75L	267
17	2	OH	585	#REF!	5	KNOB CREEK BSE/FLV 750ML	365	#REF!	AZ	JIM BEAM WH/FL 750ML	259
18	3	IN	577	#REF!	6	MAKERS MARK 750ML	360	#REF!	FL	PINNACLE FLV 750ML 6PK	233
19	4	AZ	550	#REF!	7	JIM BEAM PREMIUM 750ML	290	#REF!	FL	KNOB CREEK BSE/FLV 750ML	228
20	5	NE	396	#REF!	8	MAKERS MARK 1.75L	289	#REF!	IN	JIM BEAM PREMIUM 750ML	228
21	6	NM	395	#REF!	9	PINNACLE FLV 750ML 6PK	273	#REF!	FL	CRUZAN 1.75L	218
22	7	WA	265	#REF!	10	CRUZAN 1.75L	218	#REF!	OH	KAMCHATKA 750ML	216
23	8	CA	212	#REF!	11	KAMCHATKA 750ML	216	#REF!	FL	EFFEN 750ML	196
24	9	IL	184	#REF!	12	PINNACLE BSE/WHP 1.75L	204	#REF!	IN	CANADIAN CLUB 1.75L	166
25	10	SD	164	#REF!	13	JIM BEAM WH/FL 50ML	203	#REF!	NE	JIM BEAM WH/FL 750ML	128
26	TTL	SUM OF TOP 10 ERRORS	5,603		14	AGUA FUERTE 4PK	184	#REF!	NM	PINNACLE BSE/WHP 750ML	101
27					15	CANADIAN CLUB 1.75L	183	#REF!	AZ	EFFEN 750ML	98
28	TYPES OF ISSUES				16	JIM BEAM WH/FL 1.75L	153	#REF!	NM	PINNACLE BSE/WHP 1.75L	93
29	1	COST			17	KESSLER 1.75L	101	#REF!	NM	EFFEN 750ML	93
30	2	HO RETAIL			18	TRES GEN PLATA/REPO 750ML	78	#REF!	IN	JIM BEAM WH/FL 750ML	87
31	3	STORE SPECIFIC RETAIL			19	PINNACLE FLV 750ML 12PK	74	#REF!	WA	JIM BEAM WH/FL 1.75L	84
32	4	PUSH TO STORE			20	WINDSOR 1.75L	64	#REF!	NE	PINNACLE BSE/WHP 1.75L	74
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
59
60
61
62
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