FMFLJUL21.xlsx

	A	B	C	D	E	F	G	H	I
1	WHCODE	SHOPNO	PRDCODE	DESCP	UOM	OPBAL	RCPT	SALE	CLBAL
2	013	01011	52316089Z	TEACHER'S HIGHLAND CREAM	1000	23	420	372	71
3	013	01011	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	16	60	76
4	013	01011	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	28	60	61	27
5	013	01011	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	43	240	283
6	021	01022	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	0	6	4	2
7	021	01022	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	16	24	24	16
8	001	02003	52316089Z	TEACHER'S HIGHLAND CREAM	1000	153	120	137	136
9	001	02003	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	100	72	81	91
10	018	02025	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	26		0	26
11	011	03001	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	26		4	22
12	011	03001	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	36		7	29
13	011	03001	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	1	12	0	13
14	014	03012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	32	48	51	29
15	014	03013	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	8		8
16	014	03013	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	1	60	26	35
17	008	04003	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	11		0	11
18	008	04003	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	36		2	34
19	008	04012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	19		0	19
20	006	05002	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	24		0	24
21	006	05013	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	36		26	10
22	006	05015	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	0	24	3	21
23	006	05017	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	17		0	17
24	006	05020	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	24		20	4
25	019	05026	52316089Z	TEACHER'S HIGHLAND CREAM	1000	91	144	176	59
26	019	05026	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	49	96	37	108
27	019	05026	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	147	144	163	128
28	007	06001	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	35		5	30
29	007	06002	52316089Z	TEACHER'S HIGHLAND CREAM	1000	111		111
30	007	06002	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	110		80	30
31	007	06010	52316089Z	TEACHER'S HIGHLAND CREAM	1000	48	48	21	75
32	007	06010	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	22		4	18
33	007	06010	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	25	24	12	37
34	007	06012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	17		1	16
35	007	06017	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	17		0	17
36	007	06020	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	35		1	34
37	007	06021	52316089Z	TEACHER'S HIGHLAND CREAM	1000	72		11	61
38	007	06021	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	78		10	68
39	007	06022	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	20		15	5
40	019	06028	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	17		11	6
41	019	06030	52316089Z	TEACHER'S HIGHLAND CREAM	1000	91		10	81
42	019	06030	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	31		11	20
43	002	07009	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	22		22
44	002	07012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	6		4	2
45	002	07017	52316089Z	TEACHER'S HIGHLAND CREAM	1000	26	44	70
46	002	07017	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	59		24	35
47	002	07017	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	1	36	13	24
48	002	07017	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	124	24	36	112
49	002	07017	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	15		15
50	002	07017	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	76		11	65
51	002	07017	52832071Z	J&B RARE BLENDED SCOTCH WHISKY	750	26		14	12
52	002	07017	52832091Z	GLENKINCHIE SINGLE MALT SCOTCH	750	2		0	2
53	002	07017	54832011Z	GORDON'S LONDON DRY GIN	750	6		4	2
54	002	07017	56832021Z	KETEL ONE VODKA	750	14		0	14
55	002	07017	59832011Z	BAILEYS THE ORIGINAL IRISH CRE	750	21		0	21
56	002	07024	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	6	12	6	12
57	017	07036	52316089Z	TEACHER'S HIGHLAND CREAM	1000	58		29	29
58	017	07036	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	16		8	8
59	017	07036	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	46		18	28
60	017	07041	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	24	36	6	54
61	002	07047	52316089Z	TEACHER'S HIGHLAND CREAM	1000	4	36	37	3
62	002	07047	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	8	24	26	6
63	017	07051	52316089Z	TEACHER'S HIGHLAND CREAM	1000	48		16	32
64	017	07051	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	29		4	25
65	017	07053	52316089Z	TEACHER'S HIGHLAND CREAM	1000	56		6	50
66	017	07053	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	10		0	10
67	017	07053	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	50		2	48
68	010	08003	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	0	60	37	23
69	010	08003	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	0	120	33	87
70	010	08003	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	47		26	21
71	010	08003	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	10		4	6
72	010	08003	52832071Z	J&B RARE BLENDED SCOTCH WHISKY	750	26		2	24
73	010	08003	52832101Z	TALISKER SINGLE MALT SCOTCH WH	750	11		0	11
74	010	08003	52832121Z	CRAGGANMORE SPEYSIDE SINGLE MA	750	3		0	3
75	010	08003	54832011Z	GORDON'S LONDON DRY GIN	750	28		2	26
76	010	08003	56832021Z	KETEL ONE VODKA	750	12		0	12
77	010	08003	59832011Z	BAILEYS THE ORIGINAL IRISH CRE	750	6		0	6
78	010	08004	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	4	12	3	13
79	010	08004	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	67		38	29
80	010	08005	52316089Z	TEACHER'S HIGHLAND CREAM	1000	39	240	154	125
81	010	08005	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	24		24
82	010	08005	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	11	24	11	24
83	010	08005	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	42	60	57	45
84	010	08011	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	5		0	5
85	010	08011	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	18		1	17
86	010	08012	52316089Z	TEACHER'S HIGHLAND CREAM	1000	12	60	53	19
87	010	08012	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	4	12	3	13
88	010	08012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	2	60	37	25
89	016	08019	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	6		0	6
90	016	08019	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	11	36	12	35
91	010	08028	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	7		0	7
92	010	08030	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	1		0	1
93	010	08031	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	19		0	19
94	012	11001	52316089Z	TEACHER'S HIGHLAND CREAM	1000	44		5	39
95	012	11001	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	6		1	5
96	012	11001	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	3		0	3
97	012	11001	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	50		5	45
98	012	11001	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	11		0	11
99	012	11001	52832071Z	J&B RARE BLENDED SCOTCH WHISKY	750	18		0	18
100	012	11001	52832121Z	CRAGGANMORE SPEYSIDE SINGLE MA	750	2		0	2