SHOP STOCK - APRIL 2022.xlsx

	A	B	C	D	E	F	G	H
1	FMFL - SHOP STOCK DETAILS - APRIL 2022
2	SHOPNO	PRDCODE	DESCP	UOM	OPBAL	RCPT	SALE	CLBAL

3	01011	52316089Z	TEACHER'S HIGHLAND CREAM	1000	0	120	120
4	01011	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	55	96	56	95
5	01011	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	162	60	146	76
6	02003	52316089Z	TEACHER'S HIGHLAND CREAM	1000	43	108	151
7	02003	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	101		101
8	02025	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	17		11	6
9	03001	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	21		12	9
10	03001	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	15	36	11	40
11	03001	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	12		0	12
12	03012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	21		17	4
13	03013	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	53		32	21
14	04003	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	27		25	2
15	04012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	8	12	20
16	05002	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	4		0	4
17	05013	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	19		0	19
18	05017	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	10		10
19	05026	52316089Z	TEACHER'S HIGHLAND CREAM	1000	49	120	149	20
20	05026	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	115		36	79
21	05026	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	69	60	72	57
22	06001	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	23		6	17
23	06002	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	42		40	2
24	06010	52316089Z	TEACHER'S HIGHLAND CREAM	1000	0	72	62	10
25	06012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	2		2
26	06018	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	10		4	6
27	06020	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	11		7	4
28	06021	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	0	12	9	3
29	06022	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	9		2	7
30	06028	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	0	36	23	13
31	06030	52316089Z	TEACHER'S HIGHLAND CREAM	1000	15	12	26	1
32	06030	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	43	24	44	23
33	07009	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	54		13	41
34	07012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	18		16	2
35	07017	52316089Z	TEACHER'S HIGHLAND CREAM	1000	108		108
36	07017	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	62	84	37	109
37	07017	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	1		0	1
38	07017	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	113		79	34
39	07017	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	1	168	20	149
40	07017	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	0	168	17	151
41	07017	52832071Z	J&B RARE BLENDED SCOTCH WHISKY	750	0	72	2	70
42	07017	54832011Z	GORDON'S LONDON DRY GIN	750	32		5	27
43	07017	56832021Z	KETEL ONE VODKA	750	0	24	1	23
44	07017	59832011Z	BAILEYS THE ORIGINAL IRISH CRE	750	3		0	3
45	07024	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	26		14	12
46	07036	52316089Z	TEACHER'S HIGHLAND CREAM	1000	65		42	23
47	07036	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	62		20	42
48	07041	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	11		6	5
49	07047	52316089Z	TEACHER'S HIGHLAND CREAM	1000	1		1
50	07047	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	37		15	22
51	07051	52316089Z	TEACHER'S HIGHLAND CREAM	1000	2		2
52	07051	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	15		15
53	07053	52316089Z	TEACHER'S HIGHLAND CREAM	1000	2		2
54	07053	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	20		20
55	08003	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	31	60	40	51
56	08003	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	96		21	75
57	08003	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	0	36	18	18
58	08003	52832071Z	J&B RARE BLENDED SCOTCH WHISKY	750	12	60	3	69
59	08003	52832101Z	TALISKER SINGLE MALT SCOTCH WH	750	9		3	6
60	08003	52832121Z	CRAGGANMORE SPEYSIDE SINGLE MA	750	0	6	0	6
61	08003	54832011Z	GORDON'S LONDON DRY GIN	750	14		2	12
62	08003	56832021Z	KETEL ONE VODKA	750	43		2	41
63	08003	59832011Z	BAILEYS THE ORIGINAL IRISH CRE	750	6	3	0	9
64	08004	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	13		13
65	08005	52316089Z	TEACHER'S HIGHLAND CREAM	1000	84	60	142	2
66	08005	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	40	60	59	41
67	08005	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	1		0	1
68	08011	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	12		4	8
69	08012	52316089Z	TEACHER'S HIGHLAND CREAM	1000	0	36	19	17
70	08012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	37		26	11
71	08019	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	7	21	25	3
72	08028	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	18		16	2
73	08031	52316089Z	TEACHER'S HIGHLAND CREAM	1000	20		3	17
74	08031	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	13		2	11
75	11001	52316089Z	TEACHER'S HIGHLAND CREAM	1000	0	12	9	3
76	11001	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	31	12	4	39
77	11001	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	3		0	3
78	11001	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	11		4	7
79	11001	52832031Z	JOHNNIE WALKER DOUBLE BLACK B	750	3		0	3
80	11001	52832071Z	J&B RARE BLENDED SCOTCH WHISKY	750	38		3	35
81	11001	52832121Z	CRAGGANMORE SPEYSIDE SINGLE MA	750	1		0	1
82	11001	54832011Z	GORDON'S LONDON DRY GIN	750	8		0	8
83	11001	56832021Z	KETEL ONE VODKA	750	45		0	45
84	11006	52316089Z	TEACHER'S HIGHLAND CREAM	1000	0	6	6
85	11006	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	24	60	25	59
86	11006	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	1	132	44	89
87	11006	52832031Z	JOHNNIE WALKER DOUBLE BLACK B	750	10		6	4
88	11006	52832061Z	JOHNNIE WALKER BLUE LABEL BLEN	750	1		0	1
89	11006	52832071Z	J&B RARE BLENDED SCOTCH WHISKY	750	26		12	14
90	11006	52832091Z	GLENKINCHIE SINGLE MALT SCOTCH	750	2		0	2
91	11006	52832101Z	TALISKER SINGLE MALT SCOTCH WH	750	1	2	0	3
92	11006	52832111Z	CAOL ILA AGED 12 YEARS ISLAY S	750	3		0	3
93	11006	52832121Z	CRAGGANMORE SPEYSIDE SINGLE MA	750	1		0	1
94	11006	54832011Z	GORDON'S LONDON DRY GIN	750	23		6	17
95	11006	56832021Z	KETEL ONE VODKA	750	7	6	1	12
96	11008	52316089Z	TEACHER'S HIGHLAND CREAM	1000	0	192	179	13
97	11008	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	67	84	56	95
98	11008	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	109	48	84	73
99	11008	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	35	36	23	48
100	11008	52832031Z	JOHNNIE WALKER DOUBLE BLACK B	750	13		13