control de inventario

10
SUCURSAL CLIENTEPROVEEDOR LINEA ARTICULO pereira ARROZ ROA alimentos arroz DOMEC licores brandy LG electrodomesticos microonda nevera (empty) alimentos aceite carne electrodomesticos nevera licores cerveza cuba BAVARIA licores cerveza CARNECOL alimentos carne GOURMET alimentos aceite RON DE CALDAS licores ron SAMSUNG electrodomesticos TV (empty) alimentos manzanas electrodomesticos TV licores

Upload: ale9388

Post on 06-Dec-2015

11 views

Category:

Documents


4 download

DESCRIPTION

Inventario

TRANSCRIPT

Page 1: 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 ###

Page 2: Control de Inventario

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 ###

Page 3: Control de Inventario

Suma de TOTAL

Page 4: Control de Inventario

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

C1
ELECTRODOMESTICOS, ALIMENTOS, LICORES, ETC.
D1
CUBA, DOSQUEBRADAS, CENTRO
Page 5: Control de Inventario

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

Page 6: Control de Inventario

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

L1
FACTURA, ORDEN DE ENTRADA, REMISION, ETC.
Page 7: Control de Inventario

$ 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

Page 8: Control de Inventario

OBSERVACIONES