Calculos de estoque-PEPS-UEPS-MPM

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

PEPS
	PEPS
	Entrada	SAIDA	SALDO
	Data	QTD	Valor UNI.	Valor TL.	QTD	Valor UNI.	Valor TL.	QTD	Valor UNI.	Valor TL.
	1	150	R$ 50.00	R$ 7,500.00	150	R$ 50.00	R$ 7,500.00	3	150 - 100 = 50
	2	200	R$ 70.00	R$ 14,000.00	CMV	200	R$ 70.00	R$ 14,000.00
	3	100	R$ 50.00	R$ 5,000.00	50	R$ 50.00	R$ 2,500.00
	4	50	R$ 50.00	R$ 2,500.00	200	R$ 70.00	R$ 14,000.00
	30	R$ 70.00	R$ 2,100.00	170	R$ 70.00	R$ 11,900.00
	170	R$ 70.00	R$ 11,900.00
	5	250	R$ 90.00	R$ 22,500.00	250	R$ 90.00	R$ 22,500.00	4	50 - 50 = 0 200-30=170 
	6	90	R$ 70.00	R$ 6,300.00	80	R$ 70.00	R$ 5,600.00
	250	R$ 90.00	R$ 22,500.00
	7	50	R$ 70.00	R$ 3,500.00	30	R$ 70.00	R$ 2,100.00	6	170 - 90 = 80
	R$ 19,400.00	250	R$ 90.00	R$ 22,500.00
	280	R$ 24,600.00	7	80 - 50 = 30
	CMV	R$ 19,400.00
	ESTOQUE FINAL	280
	SALDO FINAL	R$ 24,600.00
UEPS
	UEPS
	Entrada	SAIDA	SALDO
	Data	QTD	Valor UNI.	Valor TL.	QTD	Valor UNI.	Valor TL.	QTD	Valor UNI.	Valor TL.	3	200 - 100 = 100
	1	150	R$ 50.00	R$ 7,500.00	150	R$ 50.00	R$ 7,500.00
	2	200	R$ 70.00	R$ 14,000.00	CMV	200	R$ 70.00	R$ 14,000.00	4	100 - 80 = 20
	3	100	R$ 70.00	R$ 7,000.00	150	R$ 50.00	R$ 7,500.00
	4	80	R$ 70.00	R$ 5,600.00	100	R$ 70.00	R$ 7,000.00	5	250 - 90 = 160
	150	R$ 50.00	R$ 7,500.00
	20	R$ 70.00	R$ 1,400.00	6	160 - 50 = 110
	5	250	R$ 90.00	R$ 22,500.00	250	R$ 90.00	R$ 22,500.00
	6	90	R$ 90.00	R$ 8,100.00	150	R$ 50.00	R$ 7,500.00
	20	R$ 70.00	R$ 1,400.00
	7	50	R$ 90.00	R$ 4,500.00	160	R$ 90.00	R$ 14,400.00
	R$ 25,200.00	150	R$ 50.00	R$ 7,500.00
	20	R$ 70.00	R$ 1,400.00
	110	R$ 90.00	R$ 9,900.00
	280	R$ 18,800.00
	CMV	R$ 25,200.00
	ESTOQUE FINAL	280
	SALDO FINAL	R$ 18,800.00
MPM
	MPM
	Entrada	SAIDA	SALDO
	Data	QTD	Valor UNI.	Valor TL.	QTD	Valor UNI.	Valor TL.	QTD	Valor UNI.	Valor TL.	150	+	200	=	350	Valor UNI.
	1	150	R$ 50.00	R$ 7,500.00	150	R$ 50.00	R$ 7,500.00	R$ 21,500.50	/	350	=	R$ 61.43
	2	200	R$ 70.00	R$ 14,000.00	CMV	200	R$ 70.00	R$ 14,000.00	350	-	100	=	250
	3	100	R$ 61.43	R$ 6,143.00	350	R$ 61.43	R$ 21,500.50	R$ 32,944.80	/	420	=	R$ 78.44
	4	80	R$ 61.43	R$ 4,914.40	250	R$ 61.43	R$ 15,357.50	250	-	80	=	170
	170	R$ 61.43	R$ 10,443.10
	5	250	R$ 90.00	R$ 22,500.00	250	R$ 90.00	R$ 22,500.00	170	+	250	=	420
	420	R$ 78.44	R$ 32,944.80
	6	90	R$ 78.44	R$ 7,059.60	330	R$ 78.44	R$ 25,885.20	420	-	90	=	330
	280	R$ 78.44	R$ 21,963.20
	7	50	R$ 78.44	R$ 3,922.00	330	-	50	=	280
	R$ 22,038.10
	280	R$ 21,961.90
	CMV	R$ 22,038.10
	ESTOQUE FINAL	280
	SALDO FINAL	R$ 21,961.90