Contabilidad Inventarios PEPS UEPS PROMEDIO PONDERADO INVENTARIO FINAL COSTOS DE VENTAS
Kardex Con Macro (Peps Ueps Promedio) Excel 2010
Click here to load reader
-
Upload
richardprado3 -
Category
Documents
-
view
1.160 -
download
94
Transcript of Kardex Con Macro (Peps Ueps Promedio) Excel 2010
COD. 006521PRODUCTO CRISTAL NE 650 RET 12XMETODO PEPS
Nº FECHA DOC. PU
CANTIDAD
1 1/1/2011 SALDO INICIAL S/. 15.00 100 100
2 1/2/2011 C001 ENTRADA S/. 18.00 300 400
3 1/2/2011 C002 ENTRADA S/. 20.00 170 570
4 1/3/2011 V001 SALIDA 50 520
5 1/4/2011 V002 SALIDA 370 150
6 1/4/2011 C003 ENTRADA S/. 23.00 700 850
7 1/8/2011 V003 SALIDA 450 400
8 1/15/2011 V004 SALIDA 250 150
9 1/25/2011 C004 ENTRADA S/. 28.00 320 470
10 1/28/2011 V005 SALIDA 470 0
DESCRIPCIÓN ENTRADA
UNIDADESSALIDA
UNIDADESSALDO
UNIDADES
VALORIZACION
ENTRADA SALIDA SALDO
S/. 1,500.00 S/. 1,500.00 S/. 5,400.00 S/. 6,900.00 S/. 3,400.00 S/. 10,300.00
S/. 20.00 S/. 1,000.00 S/. 9,300.00 S/. 18.65 S/. 6,900.00 S/. 2,400.00
S/. 16,100.00 S/. 18,500.00 S/. 23.00 S/. 10,350.00 S/. 8,150.00 S/. 23.00 S/. 5,750.00 S/. 2,400.00
S/. 8,960.00 S/. 11,360.00 S/. 24.17 S/. 11,360.00 S/. 0.00
COSTO UNITARIO
COD. 006521PRODUCTO CRISTAL NE 650 RET 12XMETODO UEPS
Nº FECHA DOC. PU
CANTIDAD
1 1/1/2011 SALDO INICIAL S/. 15.00 100 100
2 1/2/2011 C001 ENTRADA S/. 18.00 300 400
3 1/2/2011 C002 ENTRADA S/. 20.00 170 570
4 1/3/2011 V001 SALIDA 50 520
5 1/4/2011 V002 SALIDA 370 150
6 1/4/2011 C003 ENTRADA S/. 23.00 700 850
7 1/8/2011 V003 SALIDA 450 400
8 1/15/2011 V004 SALIDA 250 150
9 1/25/2011 C004 ENTRADA S/. 28.00 320 470
10 1/28/2011 V005 SALIDA 470 0
DESCRIPCIÓN ENTRADA
UNIDADESSALIDA
UNIDADESSALDO
UNIDADES
VALORIZACION
ENTRADA SALIDA SALDO
S/. 1,500.00 S/. 1,500.00 S/. 5,400.00 S/. 6,900.00 S/. 3,400.00 S/. 10,300.00
S/. 20.00 S/. 1,000.00 S/. 9,300.00 S/. 18.65 S/. 6,900.00 S/. 2,400.00
S/. 16,100.00 S/. 18,500.00 S/. 23.00 S/. 10,350.00 S/. 8,150.00 S/. 23.00 S/. 5,750.00 S/. 2,400.00
S/. 8,960.00 S/. 11,360.00 S/. 24.17 S/. 11,360.00 S/. 0.00
COSTO UNITARIO
COD. 006521PRODUCTO CRISTAL NE 650 RET 12XMETODO PROMEDIO
Nº FECHA DOC. PU
CANTIDAD
1 1/1/2011 SALDO INICIAL S/. 15.00 100 100
2 1/2/2011 C001 ENTRADA S/. 18.00 300 400
3 1/2/2011 C002 ENTRADA S/. 20.00 170 570
4 1/3/2011 V001 SALIDA 50 520
5 1/4/2011 V002 SALIDA 370 150
6 1/4/2011 C003 ENTRADA S/. 23.00 700 850
7 1/8/2011 V003 SALIDA 450 400
8 1/15/2011 V004 SALIDA 250 150
9 1/25/2011 C004 ENTRADA S/. 28.00 320 470
10 1/28/2011 V005 SALIDA 470 0
DESCRIPCIÓN ENTRADA
UNIDADESSALIDA
UNIDADESSALDO
UNIDADES
VALORIZACION
ENTRADA SALIDA SALDO
S/. 1,500.00 S/. 1,500.00 S/. 5,400.00 S/. 6,900.00 S/. 3,400.00 S/. 10,300.00
S/. 18.07 S/. 903.51 S/. 9,396.49 S/. 18.07 S/. 6,685.96 S/. 2,710.53
S/. 16,100.00 S/. 18,810.53 S/. 22.13 S/. 9,958.51 S/. 8,852.01 S/. 22.13 S/. 5,532.51 S/. 3,319.50
S/. 8,960.00 S/. 12,279.50 S/. 26.13 S/. 12,279.50 S/. 0.00
COSTO UNITARIO