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