| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | SHOP STOCK DETAILS - APRIL 2022 | |||||||
2 | SHOPNO | PRDCODE | DESCP | UOM | OPBAL | RCPT | SALE | CLBAL |
3 | 01001 | 11013825A | PAPILLON RESERVE BRANDY | 500 | 63 | 0 | 63 | |
4 | 01001 | 110204026 | BEJOIS PREMIUM BRANDY | 375 | 168 | 96 | 190 | 74 |
5 | 01001 | 110204059 | BEJOIS PREMIUM BRANDY | 500 | 10 | 3 | 7 | |
6 | 01001 | 110341118 | KYRON PREMIUM BRANDY FRENCH BL | 750 | 15 | 8 | 7 | |
7 | 01001 | 110341129 | KYRON PREMIUM BRANDY FRENCH BL | 375 | 21 | 4 | 17 | |
8 | 01001 | 11041051X | DAILY DAWN BRANDY | 750 | 41 | 0 | 41 | |
9 | 01001 | 11041055X | DAILY DAWN BRANDY | 500 | 49 | 0 | 49 | |
10 | 01001 | 112018612 | CHEVALIER DE PARIS PREMIUM XO | 750 | 29 | 0 | 29 | |
11 | 01001 | 112018623 | CHEVALIER DE PARIS PREMIUM XO | 375 | 53 | 0 | 53 | |
12 | 01001 | 11290041X | LINCOLN PREMIUM BRANDY | 750 | 72 | 0 | 72 | |
13 | 01001 | 11290051X | MADISON GRAPE BRANDY | 750 | 108 | 0 | 108 | |
14 | 01001 | 11302061X | CASABLANCA XO PREMIUM BRANDY | 750 | 9 | 0 | 9 | |
15 | 01001 | 113559356 | MONT CASTLE FRENCH GRAPE BRAND | 500 | 288 | 0 | 288 | |
16 | 01001 | 113784818 | ESPECIAL CT FIN OL QU BDY | 750 | 10 | 0 | 10 | |
17 | 01001 | 11380933A | MALABAR HOUSE PREMIUM VSOP BRA | 180 | 354 | 528 | 541 | 341 |
18 | 01001 | 113809351 | MALABAR HOUSE PREMIUM VSOP BRA | 500 | 45 | 45 | 0 | |
19 | 01001 | 113970856 | MORNING WALKER'S XO BRANDY | 500 | 270 | 18 | 252 | |
20 | 01001 | 11397151A | CHAIRMAN'S CHOICE XO BRANDY | 750 | 25 | 1 | 24 | |
21 | 01001 | 11402031A | BRITISH EMPIRE PURE GRAPE BRAN | 750 | 27 | 4 | 23 | |
22 | 01001 | 114020411 | KING LOUIS XIV MATURED GRAPE B | 750 | 29 | 5 | 24 | |
23 | 01001 | 114020422 | KING LOUIS XIV MATURED GRAPE B | 375 | 10 | 6 | 4 | |
24 | 01001 | 114020659 | ROYAL PALACE PREMIUM XO BRANDY | 500 | 37 | 72 | 9 | 100 |
25 | 01001 | 11489572X | NO.1 HONEY BEE BRANDY | 375 | 276 | 276 | 0 | |
26 | 01001 | 11489579X | NO.1 HONEY BEE BRANDY | 1000 | 0 | 90 | 67 | 23 |
27 | 01001 | 11489585X | JOIE DE FRANC VSOP PREMIUM BLE | 500 | 17 | 72 | 89 | 0 |
28 | 01001 | 11489611X | LOUIS VERNANT XOá PREMIUM BLEN | 750 | 4 | 4 | 0 | |
29 | 01001 | 11489612X | LOUIS VERNANT XOá PREMIUM BLEN | 375 | 21 | 2 | 19 | |
30 | 01001 | 115052752 | NORMANDY'S DADDY WILSON INDIAN | 500 | 126 | 0 | 126 | |
31 | 01001 | 115119616 | NICOL'S BLACK & GOLD FRENCH BR | 750 | 24 | 0 | 24 | |
32 | 01001 | 115983451 | CAPT MORIS PREM GRP BDY | 500 | 18 | 0 | 18 | |
33 | 01001 | 116630253 | 8 PM EXCELLENCY BRANDY | 500 | 0 | 108 | 69 | 39 |
34 | 01001 | 116630297 | 8 PM EXCELLENCY BRANDY | 1000 | 54 | 54 | 0 | |
35 | 01001 | 11668171A | EMPEROR'S PREMIUM BRANDY | 750 | 138 | 0 | 138 | |
36 | 01001 | 116780755 | BONJOUR RARE CLASSIC BRANDY | 500 | 90 | 0 | 90 | |
37 | 01001 | 11678131X | RADICO MORPHEUS XO BLENDED RAR | 750 | 18 | 17 | 1 | |
38 | 01001 | 11678132X | RADICO MORPHEUS XO BLENDED RAR | 375 | 10 | 10 | 0 | |
39 | 01001 | 11702012X | NO.1 MCDOWELL'S BRANDY | 375 | 239 | 192 | 431 | 0 |
40 | 01001 | 11702015X | NO.1 MCDOWELL'S BRANDY | 500 | 492 | 1422 | 1306 | 608 |
41 | 01001 | 11702019X | NO.1 MCDOWELL'S BRANDY | 1000 | 95 | 450 | 353 | 192 |
42 | 01001 | 11744309X | ROYAL TROPHY PREMIUM FRENCH BR | 1000 | 25 | 7 | 18 | |
43 | 01001 | 117510814 | TI'S MANSION HOUSE SILK PREMIU | 750 | 48 | 0 | 48 | |
44 | 01001 | 11751429X | MANSION HOUSE FRENCH BRANDY RE | 1000 | 0 | 180 | 99 | 81 |
45 | 01001 | 117518259 | COURRIER NAPOLEON GOLD BRANDY | 500 | 180 | 360 | 180 | 360 |
46 | 01001 | 118550111 | THE WAREHOUSE MATURED SUPERIOR | 750 | 36 | 0 | 36 | |
47 | 01001 | 118550155 | THE WAREHOUSE MATURED SUPERIOR | 500 | 121 | 0 | 121 | |
48 | 01001 | 12064031X | DEWAR'S WHITE LABEL BLENDED SC | 750 | 12 | 0 | 12 | |
49 | 01001 | 12290041X | ROCKDOVE PREMIUM WHISKY | 750 | 41 | 1 | 40 | |
50 | 01001 | 12489051X | BAGPIPER GOLD PREMIUM WHISKY | 750 | 7 | 12 | 14 | 5 |
51 | 01001 | 12489061X | ANTIQUITY BLUE ULTRA PREMIUM W | 750 | 1 | 1 | 0 | |
52 | 01001 | 12648045X | RADICO 8 PM SMOOTH INDIAN WHIS | 500 | 75 | 234 | 208 | 101 |
53 | 01001 | 12702721X | MCDOWELL'S GREEN LABEL 'THE RI | 750 | 100 | 100 | 0 | |
54 | 01001 | 12702741X | SIGNATURE RARE AGED WHISKY | 750 | 14 | 12 | 26 | 0 |
55 | 01001 | 130200323 | OLD PORT DELUXE RUM | 375 | 505 | 5112 | 4482 | 1135 |
56 | 01001 | 130200392 | OLD PORT DELUXE RUM | 1000 | 1605 | 450 | 1606 | 449 |
57 | 01001 | 130208234 | XO OLD PORT RUM | 180 | 0 | 1824 | 570 | 1254 |
58 | 01001 | 130341416 | JOLLY ROGER PREMIUM XXX RUM | 750 | 13 | 84 | 38 | 59 |
59 | 01001 | 130341427 | JOLLY ROGER PREMIUM XXX RUM | 375 | 32 | 32 | 0 | |
60 | 01001 | 13034145A | JOLLY ROGER PREMIUM XXX RUM | 500 | 0 | 144 | 65 | 79 |
61 | 01001 | 13041081X | DAILY DAWN RUM | 750 | 72 | 0 | 72 | |
62 | 01001 | 13041085X | DAILY DAWN RUM | 500 | 33 | 0 | 33 | |
63 | 01001 | 13064061X | BACARDI CARTA BLANCA CLASSIC S | 750 | 107 | 19 | 88 | |
64 | 01001 | 13064062X | BACARDI CARTA BLANCA CLASSIC S | 375 | 51 | 27 | 24 | |
65 | 01001 | 130642219 | BACARDI CLASSIC BLACK ORIGINAL | 750 | 96 | 120 | 58 | 158 |
66 | 01001 | 130720119 | BACARDI LIMON ORIGINAL CITRUS | 750 | 84 | 84 | 0 | |
67 | 01001 | 13072012A | BACARDI LIMON ORIGINAL CITRUS | 375 | 0 | 312 | 72 | 240 |
68 | 01001 | 13074111X | OLD MONK SELECT XXX PREMIUM RU | 750 | 33 | 144 | 147 | 30 |
69 | 01001 | 13074131X | OLD MONK WHITE RUM | 750 | 3 | 12 | 8 | 7 |
70 | 01001 | 131007759 | HERCULES SPECIAL RESERVE 3'X' | 500 | 78 | 252 | 107 | 223 |
71 | 01001 | 131007792 | HERCULES SPECIAL RESERVE 3'X' | 1000 | 8 | 72 | 80 | 0 |
72 | 01001 | 13290041X | MURANO RUM | 750 | 25 | 1 | 24 | |
73 | 01001 | 13349191X | SPECIAL RESERVE ARISTOCRAT WHI | 750 | 36 | 0 | 36 | |
74 | 01001 | 133800451 | MALABAR HOUSE PREMIUM XXX RUM | 500 | 91 | 3636 | 3727 | 0 |
75 | 01001 | 13380833A | SNJ NO.1 PREMIUM XXX RUM | 180 | 12639 | 12639 | 0 | |
76 | 01001 | 133879939 | RARE HONOUR PREMIUM RUM | 180 | 960 | 960 | 0 | |
77 | 01001 | 133879950 | RARE HONOUR PREMIUM RUM | 500 | 193 | 2538 | 2731 | 0 |
78 | 01001 | 133970327 | OLD PERAL NO.1 MATURED XXX RUM | 375 | 0 | 768 | 768 | 0 |
79 | 01001 | 13397035A | OLD PERAL NO.1 MATURED XXX RUM | 500 | 940 | 1080 | 2020 | 0 |
80 | 01001 | 133970393 | OLD PERAL NO.1 MATURED XXX RUM | 1000 | 0 | 720 | 720 | 0 |
81 | 01001 | 133971851 | MAGIC BLEND RESERVED XXX RUM | 500 | 0 | 162 | 48 | 114 |
82 | 01001 | 13489475X | BAGPIPER DELUXE XXX RUM | 500 | 0 | 1980 | 1980 | 0 |
83 | 01001 | 135052835 | NORMANDY'S DADDY WILSON PURE B | 180 | 0 | 528 | 528 | 0 |
84 | 01001 | 135052890 | NORMANDY'S DADDY WILSON PURE B | 1000 | 0 | 270 | 270 | 0 |
85 | 01001 | 13511101X | NICOL'S HAWAIAN ORIGINAL WHITE | 750 | 44 | 2 | 42 | |
86 | 01001 | 135502024 | EVERYDAY GOLD XXX RUM | 375 | 17 | 48 | 65 | 0 |
87 | 01001 | 135502159 | PREMIUM OLD FOX XXX RUM | 500 | 55 | 0 | 55 | |
88 | 01001 | 135503027 | OASIS CLASSIC RUM | 375 | 72 | 24 | 48 | |
89 | 01001 | 13550305A | OASIS CLASSIC RUM | 500 | 234 | 378 | 612 | 0 |
90 | 01001 | 136483129 | CONTESSA WHITE RUM | 375 | 0 | 96 | 96 | 0 |
91 | 01001 | 136483151 | CONTESSA WHITE RUM | 500 | 136 | 136 | 0 | |
92 | 01001 | 13702952X | MCDOWELL'S NO.1 CELEBRATION LU | 375 | 4561 | 1176 | 5737 | 0 |
93 | 01001 | 13702955X | MCDOWELL'S NO.1 CELEBRATION LU | 500 | 4573 | 3654 | 7538 | 689 |
94 | 01001 | 13702975X | MC OCR PREMIUM RUM | 500 | 356 | 684 | 1040 | 0 |
95 | 01001 | 13760885X | DIAMOND DELUXE XXX RUM | 500 | 270 | 270 | 0 | |
96 | 01001 | 138559618 | OLD CRUIZE MATURED SUPERIOR CA | 750 | 60 | 0 | 60 | |
97 | 01001 | 138559651 | OLD CRUIZE MATURED SUPERIOR CA | 500 | 63 | 0 | 63 | |
98 | 01001 | 151183222 | RIVIERA SHIRAZ | 375 | 20 | 0 | 20 | |
99 | 01001 | 152300616 | FRATELLI CLASSIC SHIRAZ | 750 | 12 | 6 | 6 | |
100 | 01001 | 15230111A | SIDUS PREMIUM PORT WINE | 750 | 12 | 0 | 12 | |