Tabela peps ueps custo medio

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

VISITE NOSSO BLOG!
PEPS
	PEPS	ITEM 1
	Histórico	Entrada	Saída	Saldo
	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor
	Saldo Inicial	5000	* 1.00	* 5,000.00
	Saldo total	5000	* 5,000.00
	Compra	12000	* 1.20	* 14,400.00	5000	* 1.00	* 5,000.00
	12000	* 1.20	* 14,400.00
	Saldo total	17000	* 19,400.00
	Venda 1A	3500	* 1.00	* 3,500.00	1500	* 1.00	* 1,500.00
	12000	* 1.20	* 14,400.00
	Saldo total	13500	* 15,900.00
	Dev p forneced.	-200	* 1.20	* (240.00)	1500	* 1.00	* 1,500.00
	11800	* 1.20	* 14,160.00
	Saldo total	13300	* 15,660.00
	Totais	11800	* 14,160.00	13300	* 15,660.00
	PEPS	ITEM 2
	Histórico	Entrada	Saída	Saldo
	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor
	Saldo Inicial	8000	* 0.75	* 6,000.00
	Compra
	Saldo total	8000	* 6,000.00
	Compra	0.0	0.0
	Saldo total	0	0.0
	Venda 1A	2000	* 0.75	* 1,500.00	6000	* 0.75	* 4,500.00
	Saldo total	6000	* 4,500.00
	Dev p forneced.	50	* 0.75	* 37.50	6050	* 0.75	* 4,537.50
	0.0
	Saldo total	6050	* 4,537.50
	Totais	50	* 37.50	6050	* 4,537.50
	PEPS	ITEM 3
	Histórico	Entrada	Saída	Saldo
	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor
	Saldo Inicial	4000	* 0.75	* 3,000.00
	Saldo total	4000	* 3,000.00
	Compra	6000	* 2.85	* 17,100.00	4000	* 0.75	* 3,000.00
	6000	* 2.85	* 17,100.00
	Saldo total	10000	* 20,100.00
	Venda 1A	3000	* 2.75	* 8,250.00	3000	* 2.75	* 8,250.00
	0.0
	Dev p forneced.	0.0	0.0
	0.0
	Saldo total	7000	* 11,850.00
	Totais	6000	* 17,100.00	7000	* 11,850.00
UEPS
	UEPS	ITEM 1
	Histórico	Entrada	Saída	Saldo
	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor
	Saldo Inicial	5000	* 1.00	* 5,000.00
	Compra
	Saldo total	5000	* 5,000.00
	Compra	12000	* 1.20	* 14,400.00	5000	* 1.00	* 5,000.00
	12000	* 1.20	* 14,400.00
	Saldo total	17000	* 19,400.00
	Venda 1A	5000	* 1.00	* 5,000.00
	3500	* 1.00	* 3,500.00	8500	* 1.20	* 10,200.00
	Saldo total	13500	* 15,200.00
	Dev p forneced.	-200	* 1.20	* (240.00)	5000	* 1.00	* 5,000.00
	8300	* 1.20	* 9,960.00
	Saldo total	13300	* 14,960.00
	Totais	11800	* 14,160.00	13300	* 14,960.00
	UEPS	ITEM 1
	Histórico	Entrada	Saída	Saldo
	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor
	Saldo Inicial	8000	* 0.75	* 6,000.00
	Compra
	Saldo total	8000	* 6,000.00
	Compra	0.0	0.0
	0.0
	Saldo total	0	0.0
	Venda 1A	2000	* 0.75	* 1,500.00	6000	* 0.75	* 4,500.00
	0.0
	Saldo total	6000	* 4,500.00
	Dev p forneced.	50	* 0.75	* 37.50	5950	* 0.75	* 4,462.50
	0.0
	Saldo total	* 1,462.50	5950	* 4,462.50
	Totais	0	0.0	5950	* 4,462.50
	UEPS	ITEM 3
	Histórico	Entrada	Saída	Saldo
	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor
	Saldo Inicial	4000	* 0.75	* 3,000.00
	Compra
	Saldo total	4000	* 3,000.00
	Compra	6000	* 2.85	* 17,100.00	4000	* 0.75	* 3,000.00
	6000	* 2.85	* 17,100.00
	Saldo total	10000	* 20,100.00
	Venda 1A	4000	* 0.75	* 3,000.00
	3000	* 2.75	* 8,250.00	3000	* 2.85	* 8,550.00
	Saldo total	7000	* 11,550.00
	Dev p forneced.	0.0	0.0
	0.0
	Saldo total	7000	* 11,850.00
	Totais	6000	* 17,100.00	7000	* 11,850.00
CM
	CUSTO MÉDIO	ITEM 1
	Histórico	Entrada	Saída	Saldo
	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor
	Saldo Inicial	5000	* 1.00	* 5,000.00
	Compra	12000	* 1.20	* 14,400.00	17000	* 1.14	* 19,400.00
	Compra	0.0	17000	* 1.14	* 19,400.00
	Venda 	3500	* 1.14	* 3,990.00	13500	* 1.14	* 15,410.00
	Venda	0.0	13500	* 1.14	* 15,410.00
	Compra	-200	* 1.20	* (240.00)	13300	* 1.14	* 15,170.00
	13300	* 1.14	* 15,170.00
	13300	* 1.14	* 15,170.00
	Totais	11800	* 14,160.00	3500	* 3,990.00
	CUSTO MÉDIO	ITEM 2
	Histórico	Entrada	Saída	Saldo
	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor
	Saldo Inicial	8000	* 0.75	* 6,000.00
	Compra	0.0	8000	* 0.75	* 6,000.00
	Compra	0.0	8000	* 0.75	* 6,000.00
	Venda 	2000	* 0.75	* 1,500.00	6000	* 0.75	* 4,500.00
	Devolução	-50	* 0.75	* (37.50)	6050	* 0.75	* 4,537.50
	Compra	0.0	6050	* 0.75	* 4,537.50
	6050	* 0.75	* 4,537.50
	6050	* 0.75	* 4,537.50
	Totais	0	0.0	1950	* 1,462.50	6050	* 4,537.50
	CUSTO MÉDIO	ITEM 3
	Histórico	Entrada	Saída	Saldo
	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor	Qtde	Pç Unit	Valor
	Saldo Inicial	4000	* 2.75	* 11,000.00
	Compra	6000	* 2.85	* 17,100.00	10000	* 2.81	* 28,100.00
	Compra	0.0	10000	* 2.81	* 28,100.00
	Venda 	3000	* 2.81	* 8,430.00	7000	* 2.81	* 19,670.00
	Venda	0.0	7000	* 2.81	* 19,670.00
	Compra	0.0	7000	* 2.81	* 19,670.00
	7000	* 2.81	* 19,670.00
	7000	* 2.81	* 19,670.00
	Totais	6000	* 17,100.00	3000	* 8,430.00	7000	* 19,670.00