KARDEX.xls
12
PEPS FECHA DETALLE ENTRADAS SALIDA SALDO CANTIDAD CANTIDAD CANTIDAD 1/1/2011 SALDO INICIAL 240 S/.500.00 1/15/2011 COMPRA 24 S/.500.00 ### 240 S/.500.00 24 S/.500.00 1/17/2011 VENTA 30 S/.500.00 ### 210 S/.500.00 24 S/.500.00 1/21/2011 COMPRA 120 S/.500.00 ### 210 S/.500.00 24 S/.500.00 120 S/.500.00 1/27/2011 VENTA 100 S/.500.00 ### 110 S/.500.00 24 S/.500.00 120 S/.500.00 ### ### CV=(II+COMPRAS NETAS)-IF CV= (120000+72000)-127000 ### COSTO UNITARIO COSTO TOTAL COSTO UNITARIO COSTO TOTAL COSTO UNITARIO
Transcript of KARDEX.xls
PEPS
FECHA DETALLEENTRADAS SALIDA SALDO
CANTIDAD CANTIDAD CANTIDAD COSTO TOTAL
1/1/2011 SALDO INICIAL 240 S/.500.00 S/.120,000.00
1/15/2011 COMPRA 24 S/.500.00 S/.12,000.00240 S/.500.00 S/.120,000.00
24 S/.500.00 S/.12,000.00
1/17/2011 VENTA 30 S/.500.00 S/.15,000.00210 S/.500.00 S/.105,000.00
24 S/.500.00 S/.12,000.00
1/21/2011 COMPRA 120 S/.500.00 S/.60,000.00210 S/.500.00 S/.105,000.00
24 S/.500.00 S/.12,000.00120 S/.500.00 S/.60,000.00
1/27/2011 VENTA 100 S/.500.00 S/.50,000.00110 S/.500.00 S/.55,000.00
24 S/.500.00 S/.12,000.00120 S/.500.00 S/.60,000.00
S/.72,000.00 S/.65,000.00 S/.127,000.00CV=(II+COMPRAS NETAS)-IFCV= (120000+72000)-127000 S/.65,000.00
COSTO UNITARIO
COSTO TOTAL
COSTO UNITARIO
COSTO TOTAL
COSTO UNITARIO
PEPS
FECHA DETALLEENTRADAS SALIDA SALDO
CANTIDAD CANTIDAD CANTIDAD COSTO TOTAL
2/1/2011 SALDO INICIAL110 S/.500.00 S/.55,000.00
24 S/.500.00 S/.12,000.00120 S/.500.00 S/.60,000.00
2/14/2011 VENTA 8 S/.500.00 S/.4,000.00102 S/.500.00 S/.51,000.00
24 S/.500.00 S/.12,000.00120 S/.500.00 S/.60,000.00
S/.0.00 S/.4,000.00 S/.123,000.00CV=(II+COMPRAS NETAS)-IFCV= (127000+0)-123000 S/.4,000.00
COSTO UNITARIO
COSTO TOTAL
COSTO UNITARIO
COSTO TOTAL
COSTO UNITARIO
PEPS
FECHA DETALLEENTRADAS SALIDA SALDO
CANTIDAD CANTIDAD CANTIDAD COSTO TOTAL
4/1/2011 SALDO INICIAL102 S/.500.00 S/.51,000.00
24 S/.500.00 S/.12,000.00120 S/.500.00 S/.60,000.00
4/8/2011 COMPRA 40 S/.500.00 S/.20,000.00 S/.0.00
102 S/.500.00 S/.51,000.0024 S/.500.00 S/.12,000.00
120 S/.500.00 S/.60,000.0040 S/.500.00 S/.20,000.00
S/.20,000.00 S/.0.00 S/.143,000.00CV=(II+COMPRAS NETAS)-IFCV= (123000+20000)- 143000 S/.0.00
COSTO UNITARIO
COSTO TOTAL
COSTO UNITARIO
COSTO TOTAL
COSTO UNITARIO
PEPS
FECHA DETALLEENTRADAS SALIDA SALDO
CANTIDAD CANTIDAD CANTIDAD COSTO TOTAL
5/1/2011 SALDO INICIAL
102 S/.500.00 S/.51,000.0024 S/.500.00 S/.12,000.00
120 S/.500.00 S/.60,000.0040 S/.500.00 S/.20,000.00
5/10/2011 VENTA S/.0.00 40 S/.500.00 S/.20,000.00
62 S/.500.00 S/.31,000.0024 S/.500.00 S/.12,000.00
120 S/.500.00 S/.60,000.0040 S/.500.00 S/.20,000.00
S/.0.00 S/.20,000.00 S/.123,000.00CV=(II+COMPRAS NETAS)-IFCV= (143000+0)-123000 S/.20,000.00
COSTO UNITARIO
COSTO TOTAL
COSTO UNITARIO
COSTO TOTAL
COSTO UNITARIO
PEPS
FECHA DETALLEENTRADAS SALIDA SALDO
CANTIDAD CANTIDAD CANTIDAD COSTO TOTAL
10/1/2011 SALDO INICIAL
62 S/.500.00 S/.31,000.0024 S/.500.00 S/.12,000.00
120 S/.500.00 S/.60,000.0040 S/.500.00 S/.20,000.00
10/1/2011 VENTA S/.0.00 40 S/.500.00 S/.20,000.00
22 S/.500.00 S/.11,000.0024 S/.500.00 S/.12,000.00
120 S/.500.00 S/.60,000.0040 S/.500.00 S/.20,000.00
S/.0.00 S/.20,000.00 S/.103,000.00CV=(II+COMPRAS NETAS)-IFCV= (143000+0)-123000 S/.20,000.00
COSTO UNITARIO
COSTO TOTAL
COSTO UNITARIO
COSTO TOTAL
COSTO UNITARIO
PEPS
FECHA DETALLEENTRADAS SALIDA SALDO
CANTIDAD CANTIDAD CANTIDAD COSTO TOTAL
11/1/2011 SALDO INICIAL
22 S/.500.00 S/.11,000.0024 S/.500.00 S/.12,000.00
120 S/.500.00 S/.60,000.0040 S/.500.00 S/.20,000.00
10/1/2011 VENTA 52 S/.500.00 S/.26,000.00 S/.0.00
22 S/.500.00 S/.11,000.0024 S/.500.00 S/.12,000.00
120 S/.500.00 S/.60,000.0040 S/.500.00 S/.20,000.0052 S/.500.00 S/.26,000.00
S/.26,000.00 S/.0.00 S/.129,000.00CV=(II+COMPRAS NETAS)-IFCV= (143000+0)-123000 S/.0.00
COSTO UNITARIO
COSTO TOTAL
COSTO UNITARIO
COSTO TOTAL
COSTO UNITARIO
