Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 022 ARTHOS BREWERIES LIMITED, AP 210220143 GOLDEN EAGLE PREMIUM BEER 650 231.80 241 4655.32 -------------------------------------------- Sub-Total: 241 4655.32 -------------------------------------------- Total.... : 4655.00 Less Discount...: 198.00 Balance ........ : 4457.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 121 CARLSBERG INDIA PVT LTD MAHARASHTRA 211210440 TUBORG PREMIUM BEER 650 322.05 1650 44281.88 211210462 TUBORG PREMIUM BEER 330 395.13 102 1679.30 211210848 TUBORG PREM ST BEER 650 333.00 97965 2718528.75 211210859 TUBORG PREM ST BEER CAN 500 612.00 88671 2261110.50 21121086A TUBORG PREM ST BEER 330 395.13 70 1152.46 -------------------------------------------- Sub-Total: 188458 5026752.89 -------------------------------------------- Total.... : 5026753.00 Less Discount...: 355003.00 Balance ........ : 4671750.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 123 CARLSBERG INDIA PVT LTD,HYDERABAD 211230142 OKOCIMPALN PRM STG BEER 650 272.31 1536 34855.68 211230346 CALSBG ELE ST SUP PRM BEE 650 463.84 52252 2019713.97 211230357 CALSBG ELE ST SUP PRM BEC 500 750.79 25041 783355.52 211230368 CALSBG ELE ST SUP PRM BEE 330 552.69 2 46.06 211230448 TUBG BSTR STG PRM BEER 650 430.92 1145 41116.95 211230743 CARLSBERG A M P BEER 650 465.00 31051 1203226.25 211230754 CARLSBERG A M P BEER CAN 500 729.60 643 19547.20 211230765 CARLSBERG A M P BEER 330 543.05 733 16585.65 211231247 TUBRG BSTR ST PRER BEER 650 463.18 572 22078.25 -------------------------------------------- Sub-Total: 112975 4140525.53 -------------------------------------------- Total.... : 4140526.00 Less Discount...: 320089.00 Balance ........ : 3820437.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 309 CROWN BEERS INDIA LTD. 213090146 BUDWEISER, KING OF BEERS 650 435.73 10140 368191.85 213090441 BUDWI PRE KING OF BE 650 493.26 40985 1684688.43 213090463 BUDWI PRE KING OF BE 330 546.62 681 15510.34 213090645 TENN ORG ST BEER 650 359.96 2106 63172.98 213090667 TENN ORG ST BEER 330 460.37 117 2244.30 213090849 TENNENT'S SUPER STRONG BE 650 359.96 3153 94579.49 213090940 BUDWEISER MAGNUM STRONG B 650 509.20 8674 368066.73 213091149 BUDWEISER MAGNUM BEER 650 544.84 50040 2271982.80 213091160 BUDWEISER MAGNUM BEER 330 592.62 1 24.69 -------------------------------------------- Sub-Total: 115897 4868461.61 -------------------------------------------- Total.... : 4868462.00 Less Discount...: 375334.00 Balance ........ : 4493128.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 313 IMPALA DISTILLERIES & BREWERIES 213130546 BELO PREMIUM BEER 650 378.00 0 0.00 21313074A KING'S BLK LBL PRM PLSNR 650 463.60 0 0.00 213130863 GOA PREMIUM BEER 330 553.00 30 691.25 213130943 GOA STRONG BEER 650 511.00 42302 1801360.17 213130965 GOA STRONG BEER 330 642.00 879 23513.25 21313144X GOA KING'S PILSNER STRONG 650 399.00 132 4389.00 -------------------------------------------- Sub-Total: 43343 1829953.67 -------------------------------------------- Total.... : 1829954.00 Less Discount...: 141767.00 Balance ........ : 1688187.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 347 JAGPIN BREWERIES 213470147 COX 10000 SUPER STRG BEER 650 356.25 151 4482.81 213470340 COX 10000 STNG PRM BEER 650 356.25 2972 88231.25 -------------------------------------------- Sub-Total: 3123 92714.06 -------------------------------------------- Total.... : 92714.00 Less Discount...: 6026.00 Balance ........ : 86688.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 377 KHODAY BREWERIES LIMITED, BANGALORE 213771744 HERCULES STRONG BEER 650 204.15 652 11092.15 -------------------------------------------- Sub-Total: 652 11092.15 -------------------------------------------- Total.... : 11092.00 Less Discount...: 471.00 Balance ........ : 10621.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 454 MOHAN BREWERIES & DISTILLERIES LTD 214541342 GOLDEN EAGLE DLX PREM BER 650 199.82 574 9558.06 -------------------------------------------- Sub-Total: 574 9558.06 -------------------------------------------- Total.... : 9558.00 Less Discount...: 406.00 Balance ........ : 9152.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 490 MALABAR BREWERIES LIMITED 214900944 ROSY PELICAN FI PR L BEER 650 150.00 52 650.00 -------------------------------------------- Sub-Total: 52 650.00 -------------------------------------------- Total.... : 650.00 Less Discount...: 28.00 Balance ........ : 622.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 492 SAB MILLER INDIA LTD(UNIT MALABAR BREW) 214920147 ROYAL CHANG CLS PRM L BER 650 192.82 1720 27637.53 214920340 HAYWARDS 5000 STG BEER 650 310.03 206 5322.18 214920442 HAYWARDS 2000 PR STG BEER 650 203.12 3030 51287.80 214924443 KNOCK OUT HIGH PUNCH STGB 650 243.00 889 18002.25 214924465 KNOCK OUT HIGH PUNCH STGB 330 267.53 96 1070.12 214924940 HAYWARDS 5000 GD PR ST B 650 344.59 73667 2115409.29 214925242 FOSTERS SPL BREW 650 327.31 52888 1442564.27 214925264 FOSTERS SPL BREW 330 406.60 222 3761.05 214925446 FOSTER'S STG PRM BEER 650 383.80 78537 2511875.05 214925468 FOSTER'S STG PRM BEER 330 456.95 15 285.59 214925548 KO REFRESHING STG BEER 650 332.91 46996 1303786.53 21492564A FOSTER'S GD STR BEER 650 399.48 959 31925.11 214925661 FOSTER'S GD STR BEER 330 456.95 0 0.00 214925741 HAYWARDS 2000 GD PRM STR 650 304.95 51825 1317002.81 214925843 ROYAL CHAL STR BEER 650 289.75 24 579.50 21492636X FOSTER'S LAGER 330 371.93 138 2138.60 -------------------------------------------- Sub-Total: 311212 8832647.68 -------------------------------------------- Total.... : 8832648.00 Less Discount...: 572083.00 Balance ........ : 8260565.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 495 MOUNT EVEREST BREWERIES LIMITED 21495104X MOUNT 6000 SUPER ST BEER 650 359.10 252 7541.10 -------------------------------------------- Sub-Total: 252 7541.10 -------------------------------------------- Total.... : 7541.00 Less Discount...: 490.00 Balance ........ : 7051.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 515 NEW INDIA BREWERIES ,JAMMU 215150147 FALCON SUP STG BEER 650 437.95 5795 211493.35 -------------------------------------------- Sub-Total: 5795 211493.35 -------------------------------------------- Total.... : 211493.00 Less Discount...: 16391.00 Balance ........ : 195102.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 583 UNITED BREWERIES (PREMIER UNIT),PKD 215830143 SAND PIPER PREMIUM BEER 650 194.93 898 14587.26 215830345 KING FISHER PREM LGR BEER 650 194.93 6527 106025.68 215830447 KINGFISHER SIN 1857 STR M 650 328.31 73359 2007041.11 215830742 KINGFISHER ULT LGR BEER 650 466.30 59905 2327808.46 215830764 KINGFISHER ULT LGR BEER 330 530.06 1650 36441.63 215830855 KINGFISHER ULT LG BER CAN 500 790.10 3 98.76 215830946 HEINEKEN LAGER BEER 650 598.79 38884 1940279.20 215830968 HEINEKEN LAGER BEER 330 730.35 2289 69657.13 215831144 KINGFISH ULT MAX PRM ST 650 731.20 156 9505.60 215831166 KINGFISH ULT MAX PRM ST 330 818.65 47 1603.19 215832442 LONDON PILSNER PREM BEER 650 179.25 3262 48726.13 215832544 LONDON NO.1 STRONG BEER 650 205.23 1199 20505.90 215836443 UB ICE PREMIUM BEER 650 215.53 548 9842.54 215837548 KINGFISHER STG PREM BEER 650 215.53 983 17655.50 215837843 KINGFISHER EXTRA ST BEER 650 256.50 7011 149860.13 215838041 KINGFISHER GOLD PREM BEER 650 229.90 647 12395.44 215839543 KINGFISHER BLUE SEL BEER 650 283.68 49901 1179659.64 215839565 KINGFISHER BLUE SEL BEER 330 336.00 118 1652.00 215839747 KINGFISHER BLUE PRM BEER 650 283.68 1704 40282.56 21583975X KINGFISHER BL PRM BEER CA 500 643.39 64594 1731630.57 215839769 KINGFISHER BLUE PRM BEER 330 336.00 19 266.00 215839951 KINGFISHER EXT STG BEER C 500 534.88 100578 2241548.36 -------------------------------------------- Sub-Total: 414282 11967072.79 -------------------------------------------- Total.... : 11967073.00 Less Discount...: 862790.00 Balance ........ : 11104283.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 599 PRIVILEGE INDUSTRIES LTD 215990261 TENNENT'S ORG STG BEER CA 330 509.20 36 763.80 21599066A BUDWES PRM KING OF BEERC 330 557.65 827 19215.69 215990754 BUDWES MAGN STG BEER CAN 500 845.50 13932 490812.75 21599105X BUDWR PRM KING OF BEERS 500 834.58 13465 468234.15 21599115X BUDWEISER MAGNUM BEER 500 960.40 144 5762.40 -------------------------------------------- Sub-Total: 28404 984788.79 -------------------------------------------- Total.... : 984789.00 Less Discount...: 76321.00 Balance ........ : 908468.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 742 SNJ BREWERIES PVT LTD 217420140 SNJ 10000 SUP STG BEER 650 291.00 44059 1068430.75 217420344 HIGH VOL SUP STG BEER 650 333.00 0 0.00 217420355 HIGH VOL SUP STG BEER C 500 698.00 216 6282.00 217420548 BRITI EMP ULT PRM BEER 650 376.00 121360 3802613.33 217420558 BRITI EMP ULT PRM BEER CA 500 759.41 45023 1424621.52 21742056A BRITI EMP ULT PRM BEER 330 551.00 48 1102.00 217421143 SNJ ULT PRM CLASSIC BEER 650 370.00 82 2528.33 -------------------------------------------- Sub-Total: 210788 6305577.93 -------------------------------------------- Total.... : 6305578.00 Less Discount...: 416544.00 Balance ........ : 5889034.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 764 SABMILLER INDIA LTS-UNIT PALS 217640464 KNOCK OUT HIGH P ST BEERC 330 428.00 338 6027.67 217640759 FOSTERS SPL BREW CAN 500 619.57 33783 872122.22 21764076A FOSTERS SPL BREW CAN 330 507.30 265 5601.44 217640850 HAYWARDS 5000 GD P ST CAN 500 619.57 30991 800045.58 217640861 HAYWARDS 5000 GD P ST CAN 330 507.30 428 9046.85 217641252 FOSTERS ST PRE B CAN 500 619.57 21125 545350.68 217641445 MILLER HIGH LIFE 650 443.39 14357 530479.19 217641456 MILLER HIGH LIFE CAN 500 717.64 25733 769459.59 217641467 MILLER HIGH LIFE 330 540.88 4424 99702.21 217641740 MILLER ACE 650 588.96 8145 399756.60 217641762 MILLER ACE 330 685.98 2257 64510.70 217642357 MILLER ACE CAN 500 911.83 632 24011.52 217642856 FOSTER'S GOLD STRG BEER C 500 715.35 11502 342831.49 217642958 HAYWARDS 5000 ST BEER CA 500 612.00 2088 53244.00 217643156 KO REFRESHING ST BEER CAN 500 665.76 608 16865.92 217643258 HAYWADS 2000 GD PRM STC B 500 612.75 15706 400993.81 -------------------------------------------- Sub-Total: 172382 4940049.47 -------------------------------------------- Total.... : 4940049.00 Less Discount...: 382854.00 Balance ........ : 4557195.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 766 SOM DISTILLERIES & BREWERIES 217660246 POWR 10000 SUP STG BER 650 335.00 90 2512.50 21766044A BLACK FORT SUP STG BEER 650 422.75 37324 1314893.42 217660552 BLACK FORT SUP STG BEER C 500 613.70 46673 1193467.50 217660643 HUNTER REFR STG PRM BEER 650 466.45 41288 1604898.97 21766066X HUNTER REFRG STG PRM BEER 330 552.62 600 13815.50 217660756 HUNTER REF STG PRM BEERC 500 789.45 51248 1685738.90 -------------------------------------------- Sub-Total: 177223 5815326.79 -------------------------------------------- Total.... : 5815327.00 Less Discount...: 450656.00 Balance ........ : 5364671.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 805 UNITED BREWERIES LIMITED,CHERTHALA 218050149 KALYANI BLK LBL PR LG BER 650 205.23 899 15375.15 218050347 GOLDEN GLOW XTRA SMT BEER 650 169.25 401 5655.77 21805036X KINGFISHER GOLD PREM BEER 330 304.09 3149 39899.14 218057148 KALYANI BLK LBL STG BEER 650 243.00 809 16382.25 218058140 LONDON PLSNR PR STG BEER 650 349.45 44762 1303506.74 218058242 KF PRMR LGR BEER 650 298.35 45910 1141437.38 218058344 KINGFISHER SIN 1857 PRM M 650 328.31 52101 1425439.94 218058446 ZINGARO PREM STG BEER 650 393.60 67452 2212425.60 218058548 BULLET EXT STG BEER 650 336.66 70735 1984470.43 21805974X K.F SPL ST BEER 650 326.04 108130 2937892.10 -------------------------------------------- Sub-Total: 394348 11082484.50 -------------------------------------------- Total.... : 11082485.00 Less Discount...: 707633.00 Balance ........ : 10374852.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 806 UNITED BREWERIES LTD (BANGALORE),NEELAMA 21806054A KINGFISHER GLD PR LG BEE 650 229.90 818 15671.52 218061043 KINGFISHER EXT STG PRMR B 650 256.50 680 14535.00 218061145 KINGFISHER PRMR MALT BEER 650 303.27 2599 65683.23 218061247 KINGFISHER STR PRMR MALT 650 303.27 46713 1180554.29 -------------------------------------------- Sub-Total: 50810 1276444.04 -------------------------------------------- Total.... : 1276444.00 Less Discount...: 82464.00 Balance ........ : 1193980.00 Run Date: 16/01/2018 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 30/11/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount =============================================================================