control de inventario

DataSUCURSAL CLIENTEPROVEEDOR LINEA ARTICULO Suma de CANSuma de TOTALpereira 526 ###

ARROZ ROA 0 ###alimentos 0 ###

arroz 0 ###DOMEC 0 ###

licores 0 ###brandy 0 ###

LG 0 ###electrodomesticos 0 ###

microondas 0 ###nevera 0 ###

(empty) 526 ###alimentos 420 ###

aceite 360 ###carne 60 ###

electrodomesticos 76 ###nevera 76 ###

licores 30 ###cerveza 30 ###

cuba 410 ###BAVARIA 0 ###

licores 0 ###cerveza 0 ###

CARNECOL 0 ###alimentos 0 ###

carne 0 ###GOURMET 0 ###

alimentos 0 ###aceite 0 ###

RON DE CALDAS 0 ###licores 0 ###

ron 0 ###SAMSUNG 0 ###

electrodomesticos 0 ###TV 0 ###

(empty) 410 ###alimentos 260 ###

manzanas 260 ###electrodomesticos 50 ###

TV 50 ###licores 100 ###

vino 100 ###dosquebradas 446 ###

AGUARDIENTE DE CALDAS 0 ###

licores 0 ###aguardient 0 ###

FRUVER 0 ###alimentos 0 ###

manzanas 0 ###HACEB 0 ###

electrodomesticos 0 ###lavadora 0 ###

(empty) 446 ###alimentos 156 ###

papa 156 ###electrodomesticos 250 ###

lavadora 250 ###licores 40 ###

ron 40 ###virginia 376 ###

FRUVER 0 ###alimentos 0 ###

papa 0 ###GRAJALES 0 ###

licores 0 ###vino 0 ###

MABEL 0 ###electrodomesticos 0 ###

telefono 0 ###(empty) 376 ###

alimentos 113 ###arroz 113 ###

licores 263 ###aguardient 66 ###brandy 197 ###

(empty)(empty)

(empty)(empty)

Total Result 1,758 ###

Suma de TOTAL

FECHA ARTICULO LINEA SUCURSAL

9/30/2013 nevera electrodomesticos pereira 1,000 0 $ 950,000 10/1/2013 TV electrodomesticos cuba 3,000 0 $ 850,000 10/2/2013 lavadora electrodomesticos dosquebradas 2,000 0 $ 500,000 10/3/2013 telefono electrodomesticos virginia 1,000 0 $ 98,000 10/4/2013 microondas electrodomesticos pereira 4,000 0 $ 50,000 10/5/2013 ron licores cuba 2,000 0 $ 70,000 10/6/2013 aguardiente licores dosquebradas 1,000 0 $ 50,000 10/7/2013 cerveza licores cuba 3,000 0 $ 1,500 10/8/2013 vino licores virginia 2,000 0 $ 18,000 10/9/2013 brandy licores pereira 4,000 0 $ 70,000

10/10/2013 carne alimentos cuba 2,000 0 $ 9,500 10/11/2013 manzanas alimentos dosquebradas 5,000 0 $ 600 10/12/2013 papa alimentos virginia 1,000 0 $ 1,000 10/13/2013 arroz alimentos pereira 3,000 0 $ 1,200 10/14/2013 aceite alimentos cuba 2,000 0 $ 2,500 10/15/2013 nevera electrodomesticos pereira 0 20 $ 1,100,000 10/16/2013 TV electrodomesticos cuba 0 50 $ 1,000,000 10/17/2013 lavadora electrodomesticos dosquebradas 0 100 $ 600,000 10/18/2013 manzanas alimentos cuba 0 70 $ 1,000 10/19/2013 manzanas alimentos cuba 0 70 $ 1,000 10/20/2013 ron licores dosquebradas 0 10 $ 80,000 10/21/2013 aguardiente licores virginia 0 20 $ 65,000 10/22/2013 cerveza licores pereira 0 30 $ 3,000 10/23/2013 vino licores cuba 0 40 $ 25,000 10/24/2013 brandy licores virginia 0 50 $ 84,000 10/25/2013 carne alimentos pereira 0 60 $ 11,000 10/26/2013 manzanas alimentos cuba 0 70 $ 1,000 10/27/2013 papa alimentos dosquebradas 0 80 $ 2,500 10/28/2013 arroz alimentos virginia 0 90 $ 2,000 10/29/2013 aceite alimentos pereira 0 100 $ 3,000 10/30/2013 nevera electrodomesticos pereira 2,000 0 $ 950,000 10/31/2013 brandy licores virginia 0 80 $ 84,000

11/1/2013 cerveza licores cuba 5,000 0 $ 1,500 11/2/2013 manzanas alimentos cuba 0 50 $ 1,000 11/3/2013 ron licores dosquebradas 0 30 $ 80,000 11/4/2013 aguardiente licores virginia 0 46 $ 65,000 11/5/2013 papa alimentos dosquebradas 0 76 $ 2,500 11/6/2013 arroz alimentos virginia 0 23 $ 2,000 11/7/2013 lavadora electrodomesticos dosquebradas 0 150 $ 600,000 11/8/2013 microondas electrodomesticos pereira 3,000 0 $ 50,000 11/9/2013 aceite alimentos pereira 0 260 $ 3,000

11/10/2013 vino licores cuba 0 60 $ 25,000 11/11/2013 papa alimentos virginia 2,300 0 $ 1,000

CANTIDADENTRADA

CANTIDASALIDA

VALOR UNITARIO

11/12/2013 aceite alimentos cuba 4,500 0 $ 2,500 11/13/2013 nevera electrodomesticos pereira 0 56 $ 1,100,000 11/14/2013 brandy licores virginia 0 67 $ 84,000 11/15/2013 ron licores cuba 1,700 0 $ 70,000 11/16/2013 aguardiente licores dosquebradas 1,000 0 $ 50,000 11/17/2013 cerveza licores cuba 3,000 0 $ 1,500

IMPUESTO TOTAL DOCUMENTO

$ 950,000,000 $ 152,000,000 $ 1,102,000,000 LG 0001 $ 2,550,000,000 $ 408,000,000 $ 2,958,000,000 SAMSUNG 0022 $ 1,000,000,000 $ 160,000,000 $ 1,160,000,000 HACEB 0002 $ 98,000,000 $ 15,680,000 $ 113,680,000 MABEL 0003 $ 200,000,000 $ 32,000,000 $ 232,000,000 LG 0004 $ 140,000,000 $ 22,400,000 $ 162,400,000 RON DE CALDAS 0005 $ 50,000,000 $ 8,000,000 $ 58,000,000 AGUARDIENTE DE CALDAS 0006 $ 4,500,000 $ 720,000 $ 5,220,000 BAVARIA 0007 $ 36,000,000 $ 5,760,000 $ 41,760,000 GRAJALES 0008 $ 280,000,000 $ 44,800,000 $ 324,800,000 DOMEC 0009 $ 19,000,000 $ 3,040,000 $ 22,040,000 CARNECOL 0010 $ 3,000,000 $ 480,000 $ 3,480,000 FRUVER 0011 $ 1,000,000 $ 160,000 $ 1,160,000 FRUVER 0012 $ 3,600,000 $ 576,000 $ 4,176,000 ARROZ ROA 0013 $ 5,000,000 $ 800,000 $ 5,800,000 GOURMET 0014 $ 22,000,000 $ 3,520,000 $ 25,520,000 $ 50,000,000 $ 8,000,000 $ 58,000,000 $ 60,000,000 $ 9,600,000 $ 69,600,000 $ 70,000 $ 11,200 $ 81,200 $ 70,000 $ 11,200 $ 81,200 $ 800,000 $ 128,000 $ 928,000 $ 1,300,000 $ 208,000 $ 1,508,000 $ 90,000 $ 14,400 $ 104,400 $ 1,000,000 $ 160,000 $ 1,160,000 $ 4,200,000 $ 672,000 $ 4,872,000 $ 660,000 $ 105,600 $ 765,600 $ 70,000 $ 11,200 $ 81,200 $ 200,000 $ 32,000 $ 232,000 $ 180,000 $ 28,800 $ 208,800 $ 300,000 $ 48,000 $ 348,000 $ 1,900,000,000 $ 304,000,000 $ 2,204,000,000 LG $ 6,720,000 $ 1,075,200 $ 7,795,200 $ 7,500,000 $ 1,200,000 $ 8,700,000 BAVARIA $ 50,000 $ 8,000 $ 58,000 $ 2,400,000 $ 384,000 $ 2,784,000 $ 2,990,000 $ 478,400 $ 3,468,400 $ 190,000 $ 30,400 $ 220,400 $ 46,000 $ 7,360 $ 53,360 $ 90,000,000 $ 14,400,000 $ 104,400,000 $ 150,000,000 $ 24,000,000 $ 174,000,000 LG $ 780,000 $ 124,800 $ 904,800 $ 1,500,000 $ 240,000 $ 1,740,000 $ 2,300,000 $ 368,000 $ 2,668,000 FRUVER

SUBTOTAL

CLIENTEPROVEEDOR

$ 11,250,000 $ 1,800,000 $ 13,050,000 GOURMET $ 61,600,000 $ 9,856,000 $ 71,456,000 $ 5,628,000 $ 900,480 $ 6,528,480 $ 119,000,000 $ 19,040,000 $ 138,040,000 RON DE CALDAS $ 50,000,000 $ 8,000,000 $ 58,000,000 AGUARDIENTE DE CALDAS $ 4,500,000 $ 720,000 $ 5,220,000 BAVARIA

OBSERVACIONES