PEPS, UEPS PROMEDIO.xls

Las planillas de Excel más útles, en un solo lugar.

METODO DE VALUACION ALUACION - UEPS Control de inventario FECHA

COMPRAS Candad

2-Dec 3-De 3-Decc 5-Dec 9-Dec 9-Dec 12-Dec 18-Dec

22-Dec 26-Dec 26-Dec 27-Dec

Valor unitario

10,0 10,000 00 9,500 9,500

11,000 11,000

930. 930.00 00 1,050. 1,050.00 00

1,250. 1,250.00 00

VENTAS Valor total

9,30 9,300, 0,00 000 0 9,975, 9,975,000 000 -

Candad

9,800 3,500 6,000 200 800 6,000

Valor unitario

930.00 1,050.00 1,050.00 930.00 750.00 750.00

5,700 32,000

1,250.00

7,125,000 24,37,!!!

  E" E"ta

Suue!"#! C$%&'$' Ve%'('$

35.00

9,114,000 3,675,000 6,300,000 186,000 600,000 4,500,000

13,750 13,750,00 ,000 0 19,275,000

32,000 P)ec(# 'e Ve%"$ 6000 I%+ Oe)$c(#%$e!   100,000 E+)e N# Oe)$c   100,000 T$!$ I#!(&$

Valor total

Ve%"$! *)u"$!  % Co"to de Venta" U&('$' *)u"$ e% Ve%"$!  I%+)e!#! N#-Oe)$c(#%$e! - $!"#! N#-Oe)$c(#%$e! / U&('$' $%"e! 'e Iue!"#! - Iue!"#! $lidad

Nece!("$! $u'$ c#% e!"$ $%($ C#%"c"$%#!

SA&'OS Candad

Valor unitario

9,000 10,000 200 9,500 6,000

750 930.00 930.00 1,050.00 1,050.00

Valor total (,7!,!!! Inventario Inicial  ),3!!,!!! *+(,!!! ),)7,!!! (,3!!,!!! %

7,200 1,200 11,000 5,300

750.00 750.00 1,250.00 1,250.00

do de Re"ultado" #todo $EPS

 

192,000,000 24,37,!!! 167,625,000 100,000 100,000 167,625,000 58,668,750 *!+,)(,2!

,4!!,!!! )!!,!!! *3,7!,!!! (,(2,!!! Inventario Final 

METODO DE VALUACION - PEPS Contro FECHA

COMPRAS Candad

2-Dec 3-Dec 5-Dec 9-Dec 12-Dec 18-Dec 22-Dec 26-Dec 27-Dec

10,000

9,500

11,000

Valor unitario

930.00

1,050.00

1,250.00

e inventario VENTAS

Valor total

9,300,000 9,975,000 -

Candad

Valor unitario

9,000 800

750.00 930.00

3,500 5,700 1,300 6,000

930.00 930.00 1,050.00 1,050.00

2,200 3,500 32,000

1,050.00 1,250.00

Valor total

6,750,000 744,000 3,255,000 5,301,000 1,365,000 6,300,000

13,750,000

19,275,000

2,310,000 4,375,000 23,7*,!!!

Suue!"#! C$%&'$' Ve%'('$ 32,000 P)ec(# 'e Ve%"$ 6000 I%+ Oe)$c(#%$e! 100000 E+)e N# Oe)$c 100000 T$!$ I#!(&$ 35.00

Ve%"$! *)u"$!  % Co"to de Venta U&('$' *)u"$ e%  I%+)e!#! N#-O - $!"#! N#-Oe  / U&('$' $%"e! - Iue!"#! $lidad

SA&'OS Candad

Valor unitario

9,000 10,000

750 930.00

9,200 9,500 5,700

930.00 1,050.00 930.00

Valor total (,7!,!!! Inventario Inicial  ),3!!,!!! % +,(,!!! ),)7,!!! ,3!*,!!! %

8,200 2,200 11,000

1,050.00 1,050.00 1,250.00

7,500

1,250.00

+,(*!,!!! 2,3*!,!!! *3,7!,!!! % ),37,!!! Inventario Final 

E"tado de Re"ultado" M#todo PEPS

  Ve%"$! e)$c(#%$e! )$c(#%$e! e Iue!"#!

192,000,000 23,7*,!!! 168,285,000 100,000 100,000 168,285,000 58,899,750 *!),3+,2!

C#!"# )#e'(# Control de inventario FECHA

COMPRAS Candad

2-Dec 3-Dec 5-Dec 9-Dec 12-Dec 18-Dec 22-Dec 26-Dec 27-Dec

Valor unitario

10,000 9,500

11,000

930.00 900.00

1,300.00

VENTAS Valor total

Candad

9,300,000 8,550,000 -

14,300,000 -

T#"$e!

35.00

9,800

844.74

3,500 7,000 6,000

872.81 872.81 1,617.89

5,700 32,000

6,030.34

Valor total

8,278,421 3,054,841 6,109,682 9,707,369 34,372,912 (*,23,22

E"tado de Re"ultado"

Suue!"#! C$%&'$' Ve%'('$   32,000 P)ec(# 'e Ve%"$ 6000 I%+ Oe)$c(#%$e! 100,000 E+)e N# Oe)$c 100,000 T$!$ I#!(&$

Valor unitario

M#todo de Proedio Ponderado

Ve%"$! *)u"$! % Co"to de Venta" U&('$' *)u"$ e% Ve%"$!  I%+)e!#! N#-Oe)$c(#%$e! - $!"#! N#-Oe)$c(#%$e! / U&('$' $%"e! 'e Iue!"#! - Iue!"#! $lidad

192,000,000 (*,23,22 130,476,775 100,000 100,000 130,476,775 45,666,871 +4,+!),)!4

SA&'OS Candad Valor unitario Valor total 9,000 750 (,7!,!!! Inventario Inicial 

19,000 9,200 18,700 15,200 8,200 2,200 13,200 7,500

844.74 844.74 872.81 872.81 1,617.89 6,030.34 2,088.39 3,675.57

16,050,000 7,771,579 16,321,579 13,266,738 13,266,738 13,266,738 27,566,738 27,566,738

Inventario Final 

C#$)$c(% 'e e!"$'# 'e e!u"$' C$%&'$' Ve%'('$  

32,000 P)ec(# 'e Ve%"$ 6000

I%+ Oe)$c(#%$e! 100,000 E+)e N# Oe)$c 100,000 T$!$ I#!(&$ 35.00

E"tado de Re"ultado" Ve%"$! *)u"$! % Co"to de Venta" U&('$' *)u"$ e% Ve%"$!  I%+)e!#! N#-Oe)$c(#%$e! - $!"#! N#-Oe)$c(#%$e! / U&('$' $%"e! 'e Iue!"#! - Iue!"#! $lidad

M#todo Proedio 192,000,000 (*,23,22 130,476,775 100,000 100,000 130,476,775 45,666,871 +4,+!),)!4

! 'e #! '(!&%"#! "#'#!

M#todo PEPS 192,000,000 23,7*,!!! 168,285,000 100,000 100,000 168,285,000 58,899,750 *!),3+,2!

M#todo $PS 192,000,000 24,37,!!! 167,625,000 100,000 100,000 167,625,000 58,668,750 *!+,)(,2!