Nancy

Stock Sheet Data collection and control MONDAY-15/02/2016-BAR AYUKU ITEM O/P RCVD TOTAL T/FERS C/S 1 BALOZI BEER 500ML 25 25 25 2 BLACK SMIRNOFF ICE 300ML 57 57 44 3 BLACK ICE GUARANA 115 115 111 300ML 44 44 44 6 CASTLE LAGER 300ML 4 4 4 7 CASTLE LITE 300ML 40 40 40 8 CASTLE MILK STOUT 500ML 6 6 6 9 GUINESS KUBWA 500ML 97 97 92 10 GUINESS NDOGO 300ML 11 HEINEKEN LAGER 300ML 62 62 58 12 KINGFISHER 300ML 26 26 24 1 1 1 4 RED SMIRNOFF ICE 5 GUARANA - 13 BAVARIA PRE MIUM - 14 PILSNER LAGER 300ML 86 86 79 15 WINDHOECK 500ML 23 23 23 16 REDDS BOTTLE 300ML 17 REDDS CAN 300ML 31 31 31 18 REDD'S VODKA LEMON 300ML 10 30 30 19 Momentum 300ML 37 37 37 20 SUMMIT LAGER 500ML 60 60 56 21 SUMMIT MALT 300ML 27 27 27 22 TUSKER LAGER 500ML 179 179 154 23 TUSKER LITE 500ML 127 127 127 24 TUSKER MALT 500ML 99 99 92 25 WHITE CAP LAGER 500ML 107 107 105 26 WHITE CAP LIGHT 300ML 46 46 46 27 CALSBERG BOTTLE 300ML 17 17 17 28 SNAPP BOTTLE 300ML 133 133 127 29 ALVARO 300ML 29 29 28 30 NOVIDA 300ML 18 18 17 31 BITTER LEMON 300ML 49 49 44 32 COKE 300ML 54 78 71 33 DIET COKE 300ML 34 FANTA ORANGE 300ML 17 41 40 35 FANTA BLACK CURRANT 300ML 16 16 15 36 FANTA PINEAPPLE 300ML 33 33 31 37 SPRITE 300ML 27 51 46 38 GINGER ALE 300ML 22 22 18 39 SODA WATER 300ML 18 18 17 40 TONIC WATER 300ML 20 20 19 41 STONEY 300ML 30 30 29 70 70 54 42 SPARKFRESH 43 QUENCHER 500ML 20 24 24 24 - 44 DASANI 47 47 47 45 EXECUTIVE WATER 500ML 16 16 15 46 DELMONTE MANGO 500ml 5 17 12 47 DELMONTE MIXED BERRY 500ml 12 6 6 5 48 DELMONTE PASSION 500ml 18 18 15 49 DELMONTE PINEAPPLE 500ml 5 5 2 50 DELMONTE TROPICAL 500ml 12 10 51 DELMONTE APPLE 500ml 12 11 52 DELMONTE ORANGE 500ML - 12 12 - 53 DELMONTE PINEAPPLE MANGO - 54 FRUITFULL - 55 SEAGRAMS GIN TOT 25 25 25 56 SEAGRAMS VODKA TOT 25 25 25 57 PASSPORT SCOTCH TOT - 58 SEAGRAM GIN 375ML - 59 SEAGRAM VODKA 375ML - 60 RED BULL (CAN) 250ML 17 17 14 61 SHARK 250ML 13 13 13 62 ORANGEH20 500ML 58 58 - 63 CARLBERG CAB - 64 CARBERG BTL - 65 NILE BEER - 66 ALCOHOL DOCTOR 300ML - 67 FAXE - 68 B52 - 69 VITA 500 CAN 300ML 70 AMARULA 750ML 71 AMARULLA 375ML 8 8 8 72 BACARDI 750ML 41 41 41 73 BAILEYS 750ML 89 89 89 74 BAILEYS 350ML 4 4 4 75 BOND 7 750ML 54 54 54 76 BOND 7 350ml 5 5 5 77 CIROCK BLUE 1 LITRE 78 BUTLERS BLUE 750ML 15 15 79 PEPPERMINT 750ML 2 2 2 80 TRIPPLE SEC 750ML 32 32 32 81 CAMPARI BITTERS 750ML 71 71 71 82 CAPTAIN MORGAN RUM 750ML 62 62 62 83 CAPTAIN MORGAN SPICED 750ML 105 105 103 17 17 17 47 47 47 14 14 14 61 61 61 21 21 21 2 2 2 33 33 33 84 CAOLILA 85 CIROC PINEAPLLE 1000ML 86 CIROC BERRY 87 CHIVAS REGAL 750ML 88 CLYNELISH 89 COINTREAU 750ML 90 DALWHINNIE 300 58 15 91 DISARONO 700ML 53 53 53 92 FAMOUS GROUSE 750ML 44 44 44 93 GILBEYS GIN 750ML 27 77 77 94 GILBEYS GIN 350ml 6 6 6 95 GILBEYS GIN 200ML 96 GORDON GIN 1LTR 28 28 28 97 GRAND MANIER 750ML 17 17 17 98 GRANTS 750 ML 71 71 71 99 GLENKINCHIE 50 - 750 ML 34 34 34 100 GLENFIDICH 15YRS 53 53 50 101 GLENFIDICH 12 104 104 104 102 HENNESSY VS 700ML 87 87 87 22 22 22 1000ML 163 163 163 106 J&B RARE 750ml 155 155 155 107 J&B RARE 375ML 3 3 3 109 J/ WALKER BLACK LABEL 750ML 113 113 113 110 J/ WALKER BLACK LABEL 375ML 5 5 5 111 J/ WALKER RED LABEL 750ML 56 56 31 112 J/WALKER RED LABEL 375ML 5 5 5 113 J/W DOUBLE BLACK 1000ML 76 76 76 114 J/W PLATINUM 750ML 25 25 25 25 25 25 4 4 61 61 93 93 4 4 11 11 8 8 103 HENNESSY VSOP 104 CIROC VODKA 105 CIROC BLUE - 108 BOOST - 115 J/W GOLD RESERVE 116 CAOLILA - 117 JACK DANIELS 375 4 118 JACK DANIELS 700ML 61 119 JAMESON 750ML 43 120 JAMESON 350ML 4 121 KHALUA 700ML 50 - ZANZI 1/4 - ZANZI 750 11 122 JACK DANIELS HONEY 1000ML 123 MAGNUM 750ml 124 MALIBU 750ml 60 60 60 125 MARTEL 700ML 52 52 52 69 69 69 126 MARTEL VSOP 8 - 127 MARTINI BIANCO 750ML 58 58 58 128 MARTINI ROSSO 750ML 58 58 58 129 MYERS RUM 750ml 62 62 62 24 24 22 22 18 18 130 OBAN 24 131 LAGAVULIN - 132 BURBON 22 133 SIR PERTESON GREEN 750ML - 134 SIRPETERSON RED 750ML - 135 SOBIESKI D.VODKA 700ML 18 136 WILLIAM PEEL HONEY 700ML 137 WILLIAM PEEL 8YRS WILLIAM LAWSON 750ML WILLIAM LAWSON 350 21 21 21 14 14 14 16 16 16 - 138 WILLIAM OLB - 139 NAVY RUM 700ML 23 23 23 140 ONDE MEESTER BRANDY 750ML 33 33 33 141 JEGERMESTER 750ML 25 25 25 142 RICHOT BRANDY 750ML 88 88 88 143 RICHOT BRANDY 350ML 8 8 8 144 REMY MARTINI 750ML 18 18 18 145 BAVARIA PRE MIUM 500 - 146 B.SPECIAL/BLOND - 147 D.SPECIAL/BLACK - 148 R.SPECIAL/RED - 149 MALT - 150 REGULAR - 151 SABUCCA BLACK 750ML 25 25 25 152 SABUCCA BLUE 750ML 18 18 18 153 SABUCCA GREEN 750ml 28 28 28 154 SABUCCA RED 750ml 72 72 72 155 SABUCCA CLEAR 700ML 34 34 34 156 SHERIDANS LIQUER 1LTR 157 SMIRNOFF CITRUS 1000ml 7 7 7 158 SMIRNOFF ORANGE - 159 SMIRNOFF VODKA 750ML 53 53 50 160 SMIRNOFF VODKA 350ML 3 3 3 161 SMIRNOFF VODKA 49 49 2 2 95 95 250ML - SMIRNOFF VANNILA 750 - SMIRNOFF EXPRESSO 750 49 162 ZANZI 375 - 163 ZANZI 750 - NEONCHOC VODKA 375 2 BALLATINES 750 95 164 NEON VODKA CHOC 750 165 NEON VODKA COFFEE 375 166 S.GOLD LABLE 6 6 6 10 10 10 167 S.EXPRESSO - 168 S.VANILLA - 169 SOUTHERN COMFORT 700ML 86 86 86 170 TALISKER IRISH WHISKY 1000ML 5 5 5 171 TANG APPLE SPIRIT 750ML 45 45 45 172 TALISKER STORM 14 14 14 173 SINGLETON 28 28 28 20 20 20 2 2 2 25 25 25 174 REGAMORE 175 TANGUERAY GIN 176 T.DONJULIO 1000ML 177 CARDHU 12 12 12 750ML 14 14 14 179 TEQUILLA-CAMINO CLEAR 750ML 74 74 74 26 26 178 TEQUILLA ROSE 180 TEQUILLA-CAMINO GOLD 750ML 181 JOSE-GUERVO SILVER 700ML 182 JOSE-GUERVO GOLD 700ML 26 - 183 TALISKER - 184 CRAGGANMORE 12YRS - 185 TANG TEN 1LTR - 186 PERNOD 1000ML 29 29 29 187 PIMMS 750ML 25 25 25 188 VAT 69 750ML 75 75 50 189 VAT 69 375ML 3 3 2 190 VICEROY 750ML 147 147 147 191 VICEROY 350ML 7 7 7 192 VICEROY 250ML 193 LIME CORDIAL 1500ML 46 44 46 194 ILTR CAPRICE RED - 195 WHITE DRY - 196 WHITE SWEET - 197 CAPRICE RED 1LTR 1 1 1 198 CAPRICE R. SWEET 1LTR 5 5 5 199 BARON DE VALIS RED 750ML - 200 BARON DE VALIS WHITE 750ML - 201 CABERNET 750ML - 202 CAPRICE RED S 1LTR 203 CAPRICE WHITE 750ML 3 3 3 204 CELLAR RED 5LTR 56 56 56 205 CELLAR WHITE 5LITRES 35 35 34 206 DROSTY HOF RED 5LITRE 44 44 44 207 DROSTDY HOF WHITE 5LITRE 64 64 208 CELLAR CASK RED 750ML 209 CELLAR CASK RED 375ml 4 4 210 CELLAR CASK WHITE 750ml - 211 COUTEIRO MOR BLACK 750ml - 212 COUTEIRO MOR WHITE 750ML 213 DROST HOF RED 750ml 3 3 3 214 DROST HOF WHITE 750ml 2 2 2 215 DM GABRIELS WHITE 5 LITRES - 216 DUSHA MONAHA RED 750ML - 217 DUSHA MONAHA WHITE 750ML - 218 DUSHA MONAHA RED 3000ML - 219 DUSHA MONAHA WHITE 3000ML - 220 FOUR COUSINS (RED) 750ML 3 3 3 221 FOUR COUSINS (WHITE) 750ML 7 7 7 222 GATO NEGRO RED 750ML - 223 CHARMDOR RED 750ML - - 64 - 1 3 - 224 CHARDOR WHITE - 225 MOET CHARDOR - 226 Overmeer 750ML 227 4TH STREET 750ML 37 37 37 4 4 4 5 5 5 2 2 75 75 - 228 FOUTH STREET W 229 4TH STREET RED 750ML 230 MONK SWEET WHITE 750ML 231 MUSCATO 750ML 232 ROCAMER WHITE 750ML 233 ROCAMER WHITE 750ML - 234 SAUVIGNON 750ML - 235 SWEET LIPS RED 1LTR - 236 SWEET LIPS ROSE 1LTR - 237 SSW SHIRAZ CARBANET 750ML - 238 SSWSEMI-SWEET 750ML - 239 NIEL SAUVIGNON 750ML - 240 NIEL CHARDONNAY 750ML - 241 PAULER 750ML 242 DUNHILL K R PKT 243 EMBASSY KINGS Pkt 6 6 6 244 EMBASSY LIGHTS pkt 10 10 6 245 SPORTSMAN Pkt 6 6 5 246 SWEET MENTHOL Pkt 1 1 1 247 DUNHILL KINGS Pkt 21 21 21 248 DUNHILL SWITCH Pkt 6 6 5 249 MATCH BOX PR 6 6 6 250 MARAMOJA PR 44 44 44 251 PANADOL PR 47 47 47 252 HEDEX pr 50 50 49 253 ACTAL pr 22 22 22 254 STUDDED CONDOMS pr 22 22 22 255 HONEY pcs 92 92 92 256 TOKENS COINS 11 11 11 9 9 52 52 257 ANTI-POLEEZ 258 4TH STREET RED 259 FERRARI CAN 260 FERRARI BOTTLE - 2 75 - 9 700ML 52 9 9 261 MINUTE MAID - 262 Pick n Peel Apple - 263 Pick n Peel Mango - 264 Pick n Peel Tropical - 265 Pick n Peel Pineapple - 266 Pick n Peel white grape - 267 Pick n Peel Orange - 268 RED GRAPE - 257 - 9 TOTAL STAFF ADVANCES-BILLS WRITE OFF VOUCHER MR NDAIGA COMPLIMENTARY PDQ BUY GOODS TOTAL NET CASH SHORTAGE SALE S/P VALUE 250 - 13 250 3,250 4 - 250 1,000 - 250 - - 300 - - 250 - - 250 - 250 - 300 1,500 250 - 4 300 1,200 2 300 600 5 - 300 - 250 1,750 - 300 - - 250 - - 250 - - 250 - 7 150 - 250 1,000 250 - 250 6,250 250 - 7 250 1,750 2 250 500 250 - 4 25 - - 300 - 6 250 1,500 1 100 100 1 100 100 5 100 500 7 100 700 100 - 1 100 100 1 100 100 2 100 200 5 100 500 4 100 400 1 100 100 1 100 100 1 100 100 16 100 1,600 100 - - - - 100 - 1 120 120 5 350 1,750 1 350 350 3 350 1,050 3 350 1,050 2 350 700 1 350 350 - 350 - - 350 - - 300 - - 150 - - 150 - - 150 - - 850 - - 850 - 250 750 - 250 - - 300 - - 250 - - 250 - - 200 - - 250 - - 300 - - 250 - - 250 - - 150 - - 1500 - - 150 - - 150 - - 1500 - - 100 - - 800 - - 200 - - 150 - - 150 - - 150 - - 150 - - 3 150 - 150 300 - 400 - - 200 - - 200 - - 250 - - 450 - - 150 - - 400 - 2 - 150 - - 150 - - 100 - - 1000 - - 500 - - 200 - - 300 - - 250 - 250 - 300 900 - 250 - - 300 - - 600 - - 200 - - 200 - - 150 - - 1500 - - 250 - - 250 - 3 2500 - 150 3,750 - 1500 - - 300 - - 500 - - 350 - 25 - - 2000 - - 250 - - 200 - - 2000 - - 150 - - 500 - - 100 - - 300 - - 150 - - 150 - - 250 - - 350 - - 100 - - 100 - - 150 - - 450 - - 550 - - 250 - - 150 - - 150 - - 100 - - 150 - - 150 - - 100 - - 1000 - - 150 - - 150 - - 150 - - 200 - - 100 - - 1000 - - 600 - - 300 - - 300 - - 300 - - 300 - - 200 - - 200 - - 100 - - 100 - - 100 - - 100 - - 100 - - 350 - - 150 - - 150 - 100 300 3 - 1000 - - 500 - - 150 - 150 - - 500 - - 1000 - - 100 - - 100 - - 80 - - 1000 - - 150 - - 150 - - 150 - - 150 - - 350 - - 150 - - 350 - - 250 - - 400 - - 200 - - 200 - - 350 - - 200 - - 150 - - 150 - - 150 - - 150 - - - - - - 200 - - 150 - - 150 - 25 100 2,500 1 1250 1,250 - 100 - - 1000 - - 500 - 2 50 100 - 1200 - - 1200 - - 1200 - - 1500 - - 1500 - - 1500 - - 1500 - - 1500 - - 1500 - - 1500 - 200 - 200 200 200 - - 200 - - 1500 - - 1500 - - 1500 - - 1400 - - 1400 - - 1500 - - 1500 - - 200 - - 1500 - - 1500 - - 200 - - 200 - - 1500 - - 1500 - - 1500 - - 1500 - 1 - - 1300 - - 13500 - - 200 - - 1200 - - 1500 - - 1500 - - 1500 - - 1500 - - 1500 - - 1000 - - 1500 - - 1600 - - 1600 - - 1200 - - 1200 - - 1500 - - 1200 - - 500 - - 200 - 250 - 4 250 1,000 1 200 200 - 200 - - 250 - 250 250 - 1 - 10 - - 20 - 20 - 1 20 20 - 20 - - 150 - - 50 - - 50 - - 3500 - - 200 - - 250 - - 200 - - 150 - - 300 - - 300 - - 300 - - 300 - - 300 - - 300 - - 300 - - - 41,790 1020 7350 5800 14,170 14,170 27,620 27,600 (20)