KARDEX

ARTICULO LAMPARA ANTIGUA REF: LMA EXISTENCIAS MINIMA

METODO EXISTENCIAS MAXIMA
VALOR ENTRADAS SALID
FECHA DETALLE UNITARIO CANT. V/TOTAL CANT.
6/4/2017 COMPRA FACTURA 20 $ 22,000 30 $660,000
6/6/2017 VENTA FACTURA 1 $22,000 $0 25
7/1/2017 COMPRA FACTURA 30 $ 23,000 15 $345,000
7/3/2017 VENTA FACTURA 5 $22,750 $0 12
7/5/2017 VENTA FACTURA 6 $22,750 $0 8
8/1/2017 COMPRA FACTURA 50 $22,000 15 $330,000
8/3/2017 VENTA FACTURA 9 $22,000 $0 10
9/1/2017 COMPRA FACTURA 34 $ 50,000 45 $2,250,000
9/7/2017 VENTA FACTURA 14 $47,200 $0 50
9/7/2017 COMPRA FACTURA 123 $ 35,000 80 $2,800,000
9/9/2017 VENTA FACTURA 15 $35,000 $0 80
 LOCALIZACION
CUANTIA UNITARIO
SALIDAS SALDO
CANT. V/TOTAL CANT. V/TOTAL V/ UNITARIO V/ VENTA
$0 30 $660,000 $22,000 $32,350 68%
25 $550,000 5 $110,000 $22,000 $32,350 68%
$0 20 $455,000 $22,750 $33,450 68%
12 $273,000 8 $182,000 $22,750 $33,450 68%
8 $182,000 0 $0 #DIV/0! #DIV/0! #DIV/0!
$0 15 $330,000 $22,000 $32,350 68%
10 $220,000 5 $110,000 $22,000 $32,350 68%
$0 50 $2,360,000 $47,200 $69,400 68%
50 $2,360,000 0 $0 #DIV/0! #DIV/0! #DIV/0!
$0 80 $2,800,000 $35,000 $51,450 68%
80 $2,800,000 0 $0 #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
 KARDEX
ARTICULO LAMPARA CLASICA REF: LMC EXISTENCIAS MINIMA
METODO EXISTENCIAS MAXIMA
VALOR ENTRADAS SALIDAS
FECHA DETALLE UNITARIO CANT. V/TOTAL CANT.
6/4/2017 COMPRA FACTURA 20 $ 20,000 30 $600,000
6/5/2017 COMPRA FACTURA 206 $22,000 30 $660,000
6/6/2017 VENTA FACTURA 1 $21,000 $0 25
6/7/2017 VENTA FACTURA 2 $21,000 $0 15
7/2/2017 COMRA FACTURA 432 $ 20,700 20 $414,000
7/3/2017 VENTA FACTURA 5 $20,850 $0 20
7/5/2017 VENTA FACTURA 7 $20,850 $0 15
8/2/2017 COMPRA FACTURA 500 $21,000 15 $315,000
8/3/2017 VENTA FACTURA 9 $20,950 $0 10
8/4/2017 VENTA FACTURA 10 $21,000 $0 5
9/1/2017 COMPRA FACTURA 34 $ 40,000 45 $1,800,000
9/7/2017 VENTA FACTURA 13 $38,100 $0 50
9/5/2017 COMPRA FACTURA 62 $ 35,000 50 $1,750,000
9/9/2017 VENTA FACTURA 14 $35,000 $0 50
9/7/2017 COMPRA FACTURA 123 $ 45,000 80 $3,600,000
9/12/2017 VENTA FACTURA 15 $45,000 $0 80
 LOCALIZACION
CUANTIA UNITARIO
SALIDAS SALDO
CANT. V/TOTAL CANT. V/TOTAL V/ UNITARI V/ VENTA
$0 30 $600,000 $20,000 $29,400 68%
$0 60 $1,260,000 $21,000 $30,900 68%
25 $525,000 35 $735,000 $21,000 $30,900 68%
15 $315,000 20 $420,000 $21,000 $30,900 68%
$0 40 $834,000 $20,850 $30,650 68%
20 $417,000 20 $417,000 $20,850 $30,650 68%
15 $312,750 5 $104,250 $20,850 $30,650 68%
$0 20 $419,250 $20,950 $30,800 68%
10 $209,500 10 $209,750 $21,000 $30,900 68%
5 $105,000 5 $104,750 $20,950 $30,800 68%
$0 50 $1,904,750 $38,100 $56,050 68%
50 $1,905,000 0 $0 #DIV/0! #DIV/0! #DIV/0!
$0 50 $1,750,000 $35,000 $51,450 68%
50 $1,750,000 0 $0 #DIV/0! #DIV/0! #DIV/0!
$0 80 $3,600,000 $45,000 $66,200 68%
80 $3,600,000 0 $0 #DIV/0! #DIV/0! #DIV/0!
 KARDEX
ARTICULO LAMPARA MODERNA REF: LMM EXISTENCIAS MINIMA
METODO EXISTENCIAS MAXIMA
VALOR ENTRADAS SALIDAS
FECHA DETALLE UNITARIO CANT. V/TOTAL CANT.
6/5/2017 COMPRA FACTURA 206 $ 25,000 20 $500,000
6/7/2017 COMPRA C COBRO No 35 $27,000 40 $1,080,000
6/7/2017 VENTA FACTURA 2 $26,350 $0 15
6/11/2017 VENTA FACTURA 4 $26,350 $0 22
7/1/2017 COMPRA FACTURA 30 $ 28,000 15 $420,000
7/2/2017 COMRA FACTURA 432 $24,750 12 $297,000
7/4/2017 COMPRA C COBRO No 76 $ 27,000 25 $675,000
7/5/2017 VENTA FACTURA 6 $26,650 $0 45
7/11/2017 VENTA FACTURA 8 $26,600 $0 25
8/1/2017 COMPRA FACTURA 50 $24,000 15 $360,000
8/2/2017 COMPRA FACTURA 500 $ 29,000 15 $435,000
8/4/2017 VENTA FACTURA 10 $26,500 $0 28
8/14/2017 COMPRA C COBRO 98 $30,000 25 $750,000
8/16/2017 VENTA FACTURA 12 $29,250 $0 30
9/5/2017 COMPRA FACTURA 62 $ 38,000 50 $1,900,000
9/7/2017 VENTA FACTURA 13 $37,650 $0 52
 CUANTIA UNITARIO
SALIDAS SALDO
CANT. V/TOTAL CANT. V/TOTAL V/ UNITARI V/ VENTA
$0 20 $500,000 $25,000 $36,750 68%
$0 60 $1,580,000 $26,350 $38,750 68%
15 $395,250 45 $1,184,750 $26,350 $38,750 68%
22 $579,700 23 $605,050 $26,300 $38,700 68%
$0 38 $1,025,050 $27,000 $39,700 68%
$0 50 $1,322,050 $26,450 $38,900 68%
$0 75 $1,997,050 $26,650 $39,200 68%
45 $1,199,250 30 $797,800 $26,600 $39,100 68%
25 $665,000 5 $132,800 $26,550 $39,050 68%
$0 20 $492,800 $24,650 $36,250 68%
$0 35 $927,800 $26,500 $38,950 68%
28 $742,000 7 $185,800 $26,550 $39,050 68%
$0 32 $935,800 $29,250 $43,000 68%
30 $877,500 2 $58,300 $29,150 $42,850 68%
$0 52 $1,958,300 $37,650 $55,350 68%
52 $1,957,800 0 $0 #DIV/0! #DIV/0! ###
#DIV/0! #DIV/0! ###
26800
 KARDEX
ARTICULO LAMPARA INFANTIL REF: LMI EXISTENCIAS MINIMA
METODO EXISTENCIAS MAXIMA
VALOR ENTRADAS SALIDAS
FECHA DETALLE UNITARIO CANT. V/TOTAL CANT.
6/6/2017 COMPRA FACTURA 50 $ 15,000 40 $600,000
6/10/2017 VENTA FACTURA 3 $15,000 $0 30
7/3/2017 COMPRA FACTURA 234 $ 17,000 30 $510,000
8/10/2017 COMPRA FACTURA 80 $16,000 35 $560,000
8/17/2017 VENTA FACTURA 11 $16,250 $0 60
9/7/2017 COMPRA FACTURA 123 $38,000 80 $3,040,000
9/7/2017 VENTA FACTURA 13 $34,600 $0 95
$0
$0
 LOCALIZACION
CUANTIA UNITARIO
SALIDAS SALDO
CANT. V/TOTAL CANT. V/TOTAL V/ UNITARI V/ VENTA
$0 40 $600,000 $15,000 $22,050 68%
30 $450,000 10 $150,000 $15,000 $22,050 68%
$0 40 $660,000 $16,500 $24,250 68%
$0 75 $1,220,000 $16,250 $23,900 68%
60 $975,000 15 $245,000 $16,350 $24,050 68%
$0 95 $3,285,000 $34,600 $50,900 68%
95 $3,287,000 0 $0 #DIV/0! #DIV/0! ###
$0 0 $0 #DIV/0! #DIV/0! ###
$0 0 $0 #DIV/0! #DIV/0! ###
 KARDEX
ARTICULO CAPERUZA N0 REF: CP0 EXISTENCIAS MINIMA
METODO EXISTENCIAS MAXIMA
VALOR ENTRADAS SALIDAS
FECHA DETALLE UNITARIO CANT. V/TOTAL CANT.
6/4/2017 COMPRA FACTURA 20 $ 7,000 30 $210,000
6/6/2017 VENTA FACTURA 1 $7,000 $0 10
7/1/2017 COMPRA FACTURA 30 $7,100 20 $142,000
7/3/2017 VENTA FACTURA 5 $7,050 $0 20
8/1/2017 COMPRA FACTURA 50 $ 7,900 15 $118,500
8/3/2017 VENTA FACTURA 9 $7,400 $0 20
8/14/2017 COMPRA C COBRO 98 $ 8,300 25 $207,500
8/16/2017 VENTA FACTURA 12 $8,000 $0 35
9/1/2017 COMPRA FACTURA 34 $ 18,000 45 $810,000
9/9/2017 VENTA FACTURA 14 $17,000 $0 50
 LOCALIZACION
CUANTIA UNITARIO
SALIDAS SALDO
CANT. V/TOTAL CANT. V/TOTAL V/ UNITARI V/ VENTA
$0 30 $210,000 $7,000 $10,300 68%
10 $70,000 20 $140,000 $7,000 $10,300 68%
$0 40 $282,000 $7,050 $10,350 68%
20 $141,000 20 $141,000 $7,050 $10,350 68%
$0 35 $259,500 $7,400 $10,900 68%
20 $148,000 15 $111,500 $7,450 $10,950 68%
$0 40 $319,000 $8,000 $11,750 68%
35 $280,000 5 $39,000 $7,800 $11,450 68%
$0 50 $849,000 $17,000 $25,000 68%
50 $850,000 0 $0 #DIV/0! #DIV/0! ###
#DIV/0! #DIV/0! ###
 KARDEX
ARTICULO CAPERUZA N1 REF: CP1 EXISTENCIAS MINIMA
METODO EXISTENCIAS MAXIMA
VALOR ENTRADAS SALIDA
FECHA DETALLE UNITARIO CANT. V/TOTAL CANT.
6/4/2017 COMPRA FACTURA 20 $ 7,500 30 $225,000
6/6/2017 COMPRA FACTURA 50 $ 7,700 50 $385,000
6/6/2017 VENTA FACTURA 1 $ 7,650 $0 10
6/10/2017 VENTA FACTURA 3 $ 7,600 $0 30
7/1/2017 COMPRA FACTURA 30 $ 7,800 10 $78,000
7/3/2017 COMPRA FACTURA 234 $ 7,700 35 $269,500
7/3/2017 VENTA FACTURA 5 $7,700 $0 40
7/5/2017 VENTA FACTURA 7 $7,650 $0 30
8/1/2017 COMPRA FACTURA 50 $ 7,700 15 $115,500
8/3/2017 VENTA FACTURA 9 $7,700 $0 15
8/10/2017 COMPRA FACTURA 80 $ 8,200 35 $287,000
8/17/2017 VENTA FACTURA 11 $8,100 $0 45
9/1/2017 COMPRA FACRURA 32 $ 20,000 45 $900,000
9/7/2017 VENTA FACTURA 13 $18,800 $0 50
X
LOCALIZACION
CUANTIA UNITARIO
SALIDAS SALDO
CANT. V/TOTAL CANT. V/TOTAL V/ UNITARI V/ VENTA
$0 30 $225,000 $7,500 $11,050 68%
$0 80 $610,000 $7,650 $11,250 68%
10 $76,500 70 $533,500 $7,600 $11,200 68%
30 $228,000 40 $305,500 $7,650 $11,250 68%
$0 50 $383,500 $7,650 $11,250 68%
$0 85 $653,000 $7,700 $11,300 68%
40 $308,000 45 $345,000 $7,650 $11,250 68%
30 $229,500 15 $115,500 $7,700 $11,300 68%
$0 30 $231,000 $7,700 $11,300 68%
15 $115,500 15 $115,500 $7,700 $11,300
$0 50 $402,500 $8,100 $11,900
45 $364,500 5 $38,000 $7,600 $11,200
$0 50 $938,000 $18,800 $27,600
50 $938,000 0 $0 #DIV/0! #DIV/0!
 KARDEX
ARTICULO CAPERUZA N2 REF: CP2 EXISTENCIAS MINIMA
METODO EXISTENCIAS MAXIMA
VALOR ENTRADAS SALIDAS
FECHA DETALLE UNITARIO CANT. V/TOTAL CANT.
6/5/2017 COMPRA FACTURA 206 $ 8,000 20 $160,000
6/7/2017 COMPRA C COBRO No 35 $8,200 50 $410,000
6/7/2017 VENTA FACTURA 2 $8,150 $0 20
6/11/2017 VENTA FACTURA 4 $8,150 $0 30
7/2/2017 COMRA FACTURA 432 $ 5,400 20 $108,000
7/5/2017 VENTA FACTURA 6 $6,750 $0 30
8/2/2017 COMPRA FACTURA 500 $ 7,500 15 $112,500
8/4/2017 VENTA FACTURA 10 $7,200 $0 15
9/5/2017 COMPRA FACTURA 62 $ 16,000 50 $800,000
9/12/2017 VENTA FACTURA 15 $14,550 $0 60
 LOCALIZACION
CUANTIA UNITARIO
SALIDAS SALDO
CANT. V/TOTAL CANT. V/TOTAL V/ UNITARI V/ VENTA
$0 20 $160,000 $8,000 $11,750 68%
$0 70 $570,000 $8,150 $12,000 68%
20 $163,000 50 $407,000 $8,150 $12,000 68%
30 $244,500 20 $162,500 $8,150 $12,000 68%
$0 40 $270,500 $6,750 $9,950 68%
30 $202,500 10 $68,000 $6,800 $10,000 68%
$0 25 $180,500 $7,200 $10,600 68%
15 $108,000 10 $72,500 $7,250 $10,650 68%
$0 60 $872,500 $14,550 $21,400 68%
60 $873,000 0 $0 #DIV/0! #DIV/0! ###
 KARDEX
ARTICULO CAPERUZA N3 REF: CP3 EXISTENCIAS MINIMA
METODO EXISTENCIAS MAXIMA
VALOR ENTRADAS SALIDAS
FECHA DETALLE UNITARIO CANT. V/TOTAL CANT.
6/5/2017 COMPRA FACTURA 206 $ 8,500 20 $170,000
6/7/2017 VENTA FACTURA 2 $8,500 $0 10
7/2/2017 COMRA FACTURA 432 $ 5,850 30 $175,500
7/4/2017 COMPRA C COBRO No 76 $ 7,200 35 $252,000
7/5/2017 VENTA FACTURA 6 $6,850 $0 40
7/11/2017 VENTA FACTURA 8 $6,800 $0 30
8/2/2017 COMPRA FACTURA 500 $ 7,900 15 $118,500
8/4/2017 VENTA FACTURA 10 $7,650 $0 10
9/5/2017 COMPRA FACTURA 62 $ 19,000 50 $950,000
9/12/2017 VENTA FACTURA 15 $17,100 60
 LOCALIZACION
CUANTIA UNITARIO
SALIDAS SALDO
CANT. V/TOTAL CANT. V/TOTAL V/ UNITARI V/ VENTA
$0 20 $170,000 $8,500 $12,500 68%
10 $85,000 10 $85,000 $8,500 $12,500 68%
$0 40 $260,500 $6,500 $9,550 68%
$0 75 $512,500 $6,850 $10,050 68%
40 $274,000 35 $238,500 $6,800 $10,000 68%
30 $204,000 5 $34,500 $6,900 $10,150 68%
$0 20 $153,000 $7,650 $11,250 68%
10 $76,500 10 $76,500 $7,650 $11,250 68%
$0 60 $1,026,500 $17,100 $25,150 68%
60 $1,026,000 0 $0 #DIV/0! #DIV/0! ###
 KARDEX
ARTICULO CAPERUZA INFANTIL REF: CPI EXISTENCIAS MINIMA
METODO EXISTENCIAS MAXIMA
VALOR ENTRADAS SALID
FECHA DETALLE UNITARIO CANT. V/TOTAL CANT.
6/6/2017 COMPRA FACTURA 50 $ 5,000 50 $250,000
6/10/2017 VENTA FACTURA 3 $5,000 $0 30
7/3/2017 COMPRA FACTURA 234 $ 5,500 30 $165,000
7/5/2017 VENTA FACTURA 7 $5,300 $0 40
8/10/2017 COMPRA FACTURA 80 $5,000 30 $150,000
8/17/2017 VENTA FACTURA 11 $5,100 $0 35
9/7/2017 COMPRA FACTURA 123 $ 7,000 80 $560,000
9/9/2017 VENTA FACTURA 14 $6,900 $0 85
 LOCALIZACION
CUANTIA UNITARIO
SALIDAS SALDO
CANT. V/TOTAL CANT. V/TOTAL V/ UNITARI V/ VENTA
$0 50 $250,000 $5,000 $7,350 68%
30 $150,000 20 $100,000 $5,000 $7,350 68%
$0 50 $265,000 $5,300 $7,800 68%
40 $212,000 10 $53,000 $5,300 $7,800 68%
$0 40 $203,000 $5,100 $7,500 68%
35 $178,500 5 $24,500 $4,900 $7,200 68%
$0 85 $584,500 $6,900 $10,150 68%
85 $586,500 0 $0 #DIV/0! #DIV/0! ###
 14350501 14350502 14350503 14350504
lamparas antigua lampara clasica lampara moderna lampara infantil
VENTA FACTURA 1 $ 550,000 $ 525,000 $ - $ -
VENTA FACTURA 2 $ - $ 315,000 $ 395,250 $ -
VENTA FACTURA 3 $ - $ - $ - $ 450,000
VENTA FACTURA 4 $ - $ - $ 579,700 $ -
VENTA FACTURA 5 $ 273,000 $ 417,000 $ - $ -
VENTA FACTURA 6 $ 182,000 $ - $ 1,199,250 $ -
VENTA FACTURA 7 $ - $ 312,750 $ - $ -
VENTA FACTURA 8 $ - $ - $ 665,000 $ -
VENTA FACTURA 9 $ 220,000 $ 209,500 $ - $ -
VENTA FACTURA 10 $ - $ 105,000 $ 742,000 $ -
VENTA FACTURA 11 $ - $ - $ - $ 975,000
VENTA FACTURA 12 $ - $ - $ 877,500 $ -
VENTA FACTURA 13 $ - $ 1,905,000 $ 1,957,800 $ 3,287,000
VENTA FACTURA 14 $ 2,360,000 $ 1,750,000 $ - $ -
VENTA FACTURA 15 $ 2,800,000 $ 3,600,000 $ - $ -

VENTA FACTURA 1 550000 525000 0 0

VENTA FACTURA 2 0 315000 395250 0
VENTA FACTURA 3 0 0 0 450000
VENTA FACTURA 4 0 0 579700 0
VENTA FACTURA 5 273000 417000 0 0
VENTA FACTURA 6 182000 0 1199250 0
VENTA FACTURA 7 0 312750 0 0
VENTA FACTURA 8 0 0 665000 0
VENTA FACTURA 9 220000 209500 0 0
VENTA FACTURA 10 0 105000 742000 0
VENTA FACTURA 11 0 0 0 975000
VENTA FACTURA 12 0 0 877500 0
VENTA FACTURA 13
VENTA FACTURA 14
VENTA FACTURA 15
 14350601 14350602 14350603 14350604 14350605
caperuza 0 caperuza 1 caperuza 2 caperuza 3 caperuza infantil TOTAL
$ 70,000 $ 76,500 $ - $ - $ - $ 1,221,500
$ - $ - $ 163,000 $ 85,000 $ - $ 958,250
$ - $ 228,000 $ - $ - $ 150,000 $ 828,000
$ - $ - $ 244,500 $ - $ - $ 824,200
$ 141,000 $ 308,000 $ - $ - $ - $ 1,139,000
$ - $ - $ 202,500 $ 274,000 $ - $ 1,857,750
$ - $ 229,500 $ - $ - $ 212,000 $ 754,250
$ - $ - $ - $ 204,000 $ - $ 869,000
$ 148,000 $ 115,500 $ - $ - $ - $ 693,000
$ - $ - $ 108,000 $ 76,500 $ - $ 1,031,500
$ - $ 364,500 $ - $ - $ 178,500 $ 1,518,000
$ 280,000 $ - $ - $ - $ - $ 1,157,500
$ - $ 938,000 $ - $ - $ - $ 8,087,800
$ 850,000 $ - $ - $ - $ 586,500 $ 5,546,500
$ - $ - $ 873,000 $ 1,026,000 $ - $ 8,299,000

70000 76500 0 0 0
0 0 163000 85000 0
0 228000 0 0 150000
0 0 244500 0 0
141000 308000 0 0 0
0 0 202500 274000 0
0 229500 0 0 212000
0 0 0 204000 0
148000 115500 0 0 0
0 0 108000 76500 0
0 364500 0 0 178500
280000 0 0 0 0