Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/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: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/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 2517 67549.99 211210451 TUBORG PREMIUM BEER CAN 500 535.80 0 0.00 211210462 TUBORG PREMIUM BEER 330 395.13 134 2206.14 211210848 TUBORG PREM ST BEER 650 322.05 103179 2769066.41 211210859 TUBORG PREM ST BEER CAN 500 573.56 62415 1491614.48 21121086A TUBORG PREM ST BEER 330 395.13 70 1152.46 211210961 TUBORG STRONG PR BR 330 395.13 0 0.00 -------------------------------------------- Sub-Total: 168315 4331589.48 -------------------------------------------- Total.... : 4331589.00 Less Discount...: 300198.00 Balance ........ : 4031391.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/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 2041 46315.39 211230346 CALSBG ELE ST SUP PRM BEE 650 444.76 44663 1655359.66 211230357 CALSBG ELE ST SUP PRM BEC 500 778.05 26779 868141.71 211230368 CALSBG ELE ST SUP PRM BEE 330 552.69 0 0.00 211230448 TUBG BSTR STG PRM BEER 650 430.92 1657 59502.87 211230743 CARLSBERG A M P BEER 650 444.76 31031 1150112.30 211230754 CARLSBERG A M P BEER CAN 500 729.60 795 24168.00 211230765 CARLSBERG A M P BEER 330 543.05 733 16585.65 211231247 TUBRG BSTR ST PRER BEER 650 463.18 1338 51644.57 -------------------------------------------- Sub-Total: 109037 3871830.15 -------------------------------------------- Total.... : 3871830.00 Less Discount...: 299002.00 Balance ........ : 3572828.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/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 8596 312127.92 213090441 BUDWI PRE KING OF BE 650 460.99 33432 1284318.14 213090463 BUDWI PRE KING OF BE 330 510.86 681 14495.65 213090645 TENN ORG ST BEER 650 359.96 3021 90619.93 213090667 TENN ORG ST BEER 330 460.37 117 2244.30 213090747 ARMSTRONG ST BEER 650 423.00 0 0.00 213090849 TENNENT'S SUPER STRONG BE 650 359.96 3779 113357.40 213090940 BUDWEISER MAGNUM STRONG B 650 509.20 9303 394757.30 213090962 BUDWEISER MAGNUM STRONG B 330 555.00 0 0.00 213091149 BUDWEISER MAGNUM BEER 650 509.20 31833 1350780.30 213091160 BUDWEISER MAGNUM BEER 330 553.85 1 23.08 -------------------------------------------- Sub-Total: 90763 3562724.02 -------------------------------------------- Total.... : 3562724.00 Less Discount...: 273561.00 Balance ........ : 3289163.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 313 IMPALA DISTILLERIES & BREWERIES 213130240 BELO STRONG BEER 650 423.00 0 0.00 213130251 BELO STRONG BEER CAN 500 610.00 0 0.00 213130262 BELO STRONG BEER 330 548.15 0 0.00 213130546 BELO PREMIUM BEER 650 378.00 420 13230.00 213130557 BELO PREMIUM BEER CAN 500 525.00 0 0.00 213130568 BELO PREMIUM BEER 330 462.65 0 0.00 21313074A KING'S BLK LBL PRM PLSNR 650 463.60 0 0.00 213130750 KING'S BLK LBL PRM PLSNR 500 522.50 0 0.00 213130761 KING'S BLK LBL PRM PLSNR 330 538.65 0 0.00 213130841 GOA PREMIUM BEER 650 463.60 0 0.00 213130852 GOA PREMIUM BEER CAN 500 872.10 0 0.00 213130863 GOA PREMIUM BEER 330 548.15 31 708.03 213130943 GOA STRONG BEER 650 508.25 30822 1305440.13 213130954 GOA STRONG BEER CAN 500 963.30 0 0.00 213130965 GOA STRONG BEER 330 638.40 879 23381.40 -------------------------------------------- Sub-Total: 32152 1342759.56 -------------------------------------------- Total.... : 1342760.00 Less Discount...: 103898.00 Balance ........ : 1238862.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/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 391 11607.81 213470340 COX 10000 STNG PRM BEER 650 356.25 2973 88260.94 -------------------------------------------- Sub-Total: 3364 99868.75 -------------------------------------------- Total.... : 99869.00 Less Discount...: 6491.00 Balance ........ : 93378.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/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 213774447 LADY BIRD BIO BEER PREM 650 222.20 0 0.00 -------------------------------------------- Sub-Total: 652 11092.15 -------------------------------------------- Total.... : 11092.00 Less Discount...: 471.00 Balance ........ : 10621.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/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 823 13704.32 -------------------------------------------- Sub-Total: 823 13704.32 -------------------------------------------- Total.... : 13704.00 Less Discount...: 582.00 Balance ........ : 13122.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/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: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/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 1746 28055.31 214920340 HAYWARDS 5000 STG BEER 650 289.75 350 8451.04 214920362 HAYWARDS 5000 STG BEER 330 370.50 0 0.00 214920442 HAYWARDS 2000 PR STG BEER 650 203.12 3472 58769.39 214924443 KNOCK OUT HIGH PUNCH STGB 650 243.00 1357 27479.25 214924465 KNOCK OUT HIGH PUNCH STGB 330 267.53 48 535.06 214924940 HAYWARDS 5000 GD PR ST B 650 322.05 72477 1945101.49 214924962 HAYWARDS 5000 GD PR ST B 330 421.80 0 0.00 214925242 FOSTERS SPL BREW 650 305.90 47218 1203665.52 214925264 FOSTERS SPL BREW 330 406.60 222 3761.05 214925446 FOSTER'S STG PRM BEER 650 383.80 70125 2242831.25 214925468 FOSTER'S STG PRM BEER 330 456.95 12 228.48 214925548 KO REFRESHING STG BEER 650 311.13 42066 1090666.22 21492556A KO REFRESHING STG BEER 330 408.03 0 0.00 21492564A FOSTER'S GD STR BEER 650 373.35 1275 39668.44 214925661 FOSTER'S GD STR BEER 330 456.95 0 0.00 214925741 HAYWARDS 2000 GD PRM STR 650 304.95 50344 1279366.90 214925763 HAYWARDS 2000 GD PRM STR 330 421.80 0 0.00 214925843 ROYAL CHAL STR BEER 650 289.75 24 579.50 214925865 ROYAL CHAL STR BEER 330 370.50 0 0.00 -------------------------------------------- Sub-Total: 290736 7929158.90 -------------------------------------------- Total.... : 7929159.00 Less Discount...: 512938.00 Balance ........ : 7416221.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/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 6020 219704.92 -------------------------------------------- Sub-Total: 6020 219704.92 -------------------------------------------- Total.... : 219705.00 Less Discount...: 17027.00 Balance ........ : 202678.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/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 1042 16926.42 215830345 KING FISHER PREM LGR BEER 650 194.93 3676 59713.56 215830367 KING FISHER PREM LGR BEER 330 235.77 0 0.00 215830447 KINGFISHER SIN 1857 STR M 650 306.83 75329 1926099.76 215830742 KINGFISHER ULT LGR BEER 650 446.72 55290 2058262.40 215830764 KINGFISHER ULT LGR BEER 330 495.38 2745 56659.09 215830855 KINGFISHER ULT LG BER CAN 500 760.00 3 95.00 215830946 HEINEKEN LAGER BEER 650 598.79 30222 1508052.62 215830968 HEINEKEN LAGER BEER 330 727.23 3449 104509.01 215831053 HEINEKEN LGR BEER CAN 500 1167.20 0 0.00 215831144 KINGFISH ULT MAX PRM ST 650 724.93 120 7249.30 215831155 KINGFISH ULT MAX PRM ST C 500 1133.20 0 0.00 215831166 KINGFISH ULT MAX PRM ST 330 812.22 48 1624.44 215831246 ORG RECP HEIN LGR BEER 650 769.07 0 0.00 215831268 ORG RECP HEIN LGR BEER 330 812.22 0 0.00 21583136A UB KINGFISHER BL PRM BEER 330 314.02 0 0.00 21583144A KINGFISHER ULT PRM MLT BE 650 592.48 0 0.00 215831461 KINGFISHER ULT PRM MLT BE 330 635.63 0 0.00 215832442 LONDON PILSNER PREM BEER 650 179.25 4232 63215.50 215832544 LONDON NO.1 STRONG BEER 650 205.23 1169 19992.82 215836443 UB ICE PREMIUM BEER 650 215.53 548 9842.54 215837548 KINGFISHER STG PREM BEER 650 215.53 685 12303.17 215837843 KINGFISHER EXTRA ST BEER 650 256.50 6703 143276.63 215838041 KINGFISHER GOLD PREM BEER 650 229.90 1375 26342.71 215838063 KINGFISHER GOLD PREM BEER 330 284.20 5243 62085.86 215839441 K.F SPL ST BEER 650 304.71 87995 2234413.04 215839543 KINGFISHER BLUE SEL BEER 650 265.12 48740 1076829.07 215839565 KINGFISHER BLUE SEL BEER 330 314.02 118 1543.93 215839656 KINGFISHER GLD PRM BEER C 500 448.31 0 0.00 215839747 KINGFISHER BLUE PRM BEER 650 265.12 2168 47898.35 215839769 KINGFISHER BLUE PRM BEER 330 314.02 19 248.60 21583985A KINGFISHER BL PRM BEER CA 500 601.30 36847 923170.88 215839951 KINGFISHER EXT STG BEER C 500 499.89 85990 1791064.21 -------------------------------------------- Sub-Total: 453756 12151418.91 -------------------------------------------- Total.... : 12151419.00 Less Discount...: 851822.00 Balance ........ : 11299597.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/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 215990659 BUDWES PRM KING OF BEERC 500 798.00 16880 561260.00 21599066A BUDWES PRM KING OF BEERC 330 557.65 707 16427.44 215990754 BUDWES MAGN STG BEER CAN 500 845.50 16107 567436.19 -------------------------------------------- Sub-Total: 33730 1145887.43 -------------------------------------------- Total.... : 1145887.00 Less Discount...: 88806.00 Balance ........ : 1057081.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 718 SAB MILLER INDIA LIMITED (SICA ) 217186746 FOSTER'S LAGER 650 240.75 0 0.00 217186768 FOSTER'S LAGER 330 283.03 138 1627.42 -------------------------------------------- Sub-Total: 138 1627.42 -------------------------------------------- Total.... : 1627.00 Less Discount...: 89.00 Balance ........ : 1538.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/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 48220 1169335.00 217420151 SNJ 10000 SUP STG BEER CA 500 611.87 0 0.00 217420162 SNJ 10000 SUP STG BEER 330 337.91 0 0.00 217420344 HIGH VOL SUP STG BEER 650 321.85 0 0.00 217420355 HIGH VOL SUP STG BEER C 500 660.31 216 5942.79 217420366 HIGH VOL SUP STG BEER 330 435.76 0 0.00 217420548 BRITI EMP ULT PRM BEER 650 364.00 114780 3481660.00 217420558 BRITI EMP ULT PRM BEER CA 500 709.73 14483 428292.48 21742056A BRITI EMP ULT PRM BEER 330 534.61 0 0.00 217421143 SNJ ULT PRM CLASSIC BEER 650 346.56 41 1184.08 217421154 SNJ ULT PRM CLAS BEER CAN 500 710.71 0 0.00 217421165 SNJ ULT PRM CLASSIC BEER 330 485.18 0 0.00 217421245 ROYAL PALACE U PRM BEER 650 474.05 0 0.00 217421358 ROYAL PALACE U PRM BEER C 500 961.40 0 0.00 217421460 ROYAL PALACE U PRM BEER 330 706.80 0 0.00 217421540 MARKER SUPER STG BEER 650 465.50 0 0.00 217421551 MARKER SUPER STG BEER 500 875.90 0 0.00 217421562 MARKER SUPER STG BEER 330 641.25 0 0.00 -------------------------------------------- Sub-Total: 177740 5086414.35 -------------------------------------------- Total.... : 5086414.00 Less Discount...: 323767.00 Balance ........ : 4762647.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 764 SABMILLER INDIA LTS-UNIT PALS 217640169 FOSTER'S CAN 330 481.00 0 0.00 217640453 KNOCK OUT HIGH P ST BEERC 500 569.05 0 0.00 217640464 KNOCK OUT HIGH P ST BEERC 330 428.00 386 6883.67 217640759 FOSTERS SPL BREW CAN 500 619.57 39347 1015759.20 21764076A FOSTERS SPL BREW CAN 330 507.30 486 10272.83 217640850 HAYWARDS 5000 GD P ST CAN 500 619.57 35971 928606.35 217640861 HAYWARDS 5000 GD P ST CAN 330 507.30 428 9046.85 217641252 FOSTERS ST PRE B CAN 500 619.57 25229 651297.15 217641445 MILLER HIGH LIFE 650 443.39 16326 603232.10 217641456 MILLER HIGH LIFE CAN 500 717.64 32239 963999.83 217641467 MILLER HIGH LIFE 330 540.88 5572 125574.31 217641740 MILLER ACE 650 588.96 9168 449965.44 217641762 MILLER ACE 330 685.98 2723 77830.15 217642266 PERONI NASTRO AZURO BIR S 330 1027.06 0 0.00 217642357 MILLER ACE CAN 500 911.83 632 24011.52 217642856 FOSTER'S GOLD STRG BEER C 500 715.35 13474 401609.41 217642958 HAYWARDS 5000 ST BEER CA 500 582.35 2589 62821.01 217643054 ROYAL CHALGE ST BEER CAN 500 582.35 0 0.00 217643156 KO REFRESHING ST BEER CAN 500 665.76 164 4549.36 217643258 HAYWADS 2000 GD PRM STC B 500 612.75 18317 467655.91 -------------------------------------------- Sub-Total: 203051 5803115.09 -------------------------------------------- Total.... : 5803115.00 Less Discount...: 449741.00 Balance ........ : 5353374.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount ============================================================================= 766 SOM DISTILLERIES & BREWERIES 217660144 LEGEND PRM LGR BEER 650 422.75 0 0.00 217660246 POWR 10000 SUP STG BER 650 422.75 170 5988.96 217660359 POWR 10000 SUP STG BER C 500 701.10 0 0.00 21766044A BLACK FORT SUP STG BEER 650 422.75 31816 1120851.17 217660552 BLACK FORT SUP STG BEER C 500 613.70 38502 984528.23 217660643 HUNTER REFR STG PRM BEER 650 466.45 38036 1478491.02 217660756 HUNTER REF STG PRM BEERC 500 789.45 39758 1307789.71 -------------------------------------------- Sub-Total: 148282 4897649.09 -------------------------------------------- Total.... : 4897649.00 Less Discount...: 379568.00 Balance ........ : 4518081.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/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 495 8465.74 218050347 GOLDEN GLOW XTRA SMT BEER 650 169.25 401 5655.77 218057148 KALYANI BLK LBL STG BEER 650 243.00 1290 26122.50 218057942 CANNON 10000 SUP ST BEER 650 299.13 0 0.00 218058140 LONDON PLSNR PR STG BEER 650 328.99 41219 1130053.23 218058242 KF PRMR LGR BEER 650 278.83 45646 1060622.85 218058344 KINGFISHER SIN 1857 PRM M 650 306.83 53509 1368180.54 218058446 ZINGARO PREM STG BEER 650 380.00 62849 1990218.33 218058548 BULLET EXT STG BEER 650 314.64 57882 1517666.04 -------------------------------------------- Sub-Total: 263291 7106985.00 -------------------------------------------- Total.... : 7106985.00 Less Discount...: 450069.00 Balance ........ : 6656916.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/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 283.43 1657 39136.96 218061247 KINGFISHER STR PRMR MALT 650 283.43 48250 1139624.79 -------------------------------------------- Sub-Total: 51405 1208968.27 -------------------------------------------- Total.... : 1208968.00 Less Discount...: 65701.00 Balance ........ : 1143267.00 Run Date: 27/11/2017 BEER Supplier/Product-wise - Closing Balance Lying At KSBC Shops as on 31/10/2017 ============================================================================= Supplier Code & Name Stock In Product Code Description UOM L/Cost Bottles Amount =============================================================================