Exercício_PEPS_UEPS

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

Plan1
	PEPS
	DATA	ENTRADA	SAÍDA	SALDO	VENDAS	* 710,000
	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	(-) CMV	* 560,000
	1-Nov	0.0	0.0	* 200	* 1,000	* 200,000	(=) RCM	* 150,000
	1-Nov	* 300	* 1,200	* 360,000	0.0	* 300	* 1,200	* 360,000	EST.FINAL	* 260,000
	2-Nov	0.0	* 100	* 1,000	* 100,000	* 100	* 1,000	* 100,000
	0.0	0.0	* 300	* 1,200	* 360,000
	15-Nov	0.0	* 100	* 1,000	* 100,000	* 100	* 1,200	* 120,000
	0.0	* 200	* 1,200	* 240,000	0.0
	18-Nov	* 200	* 1,300	* 260,000	0.0	* 100	* 1,200	* 120,000
	0.0	0.0	* 200	* 1,300	* 260,000
	20-Nov	0.0	* 100	* 1,200	* 120,000	* 200	* 1,300	* 260,000
	SOMA	* 500	* 620,000	* 500	* 560,000	* 200	* 260,000
	UEPS
	DATA	ENTRADA	SAÍDA	SALDO	VENDAS	* 710,000
	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	(-) CMV	* 590,000
	1-Nov	0.0	0.0	* 200	* 1,000	* 200,000	(=) RCM	* 120,000
	1-Nov	* 300	* 1,200	* 360,000	0.0	* 300	* 1,200	* 360,000	EST.FINAL	* 230,000
	2-Nov	0.0	* 100	* 1,200	* 120,000	* 200	* 1,000	* 200,000
	0.0	0.0	* 200	* 1,200	* 240,000
	15-Nov	0.0	* 200	* 1,200	* 240,000	* 100	* 1,000	* 100,000
	0.0	* 100	* 1,000	* 100,000	0.0
	18-Nov	* 200	* 1,300	* 260,000	0.0	* 100	* 1,000	* 100,000
	0.0	0.0	* 200	* 1,300	* 260,000
	20-Nov	0.0	* 100	* 1,300	* 130,000	* 100	* 1,000	* 100,000
	* 100	* 1,300	* 130,000
	SOMA	* 500	* 620,000	* 500	* 590,000
	MÉDIA PONDERADA
	DATA	ENTRADA	SAÍDA	SALDO
	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	VENDAS	* 710,000
	1-Nov	0.0	0.0	* 500	* 1,120	* 560,000	(-) CMV	* 572,000
	1-Nov	* 300	* 1,200	* 360,000	0.0	0.0	(=) RCM	* 138,000
	2-Nov	0.0	* 100	* 1,120	* 112,000	* 400	* 1,120	* 448,000	EST.FINAL	* 248,000
	0.0	0.0	0.0
	15-Nov	0.0	* 300	* 1,120	* 336,000	* 100	* 1,120	* 112,000
	0.0	0.0	0.0
	18-Nov	* 200	* 1,300	* 260,000	0.0	* 300	* 1,240	* 372,000
	0.0	0.0	0.0
	20-Nov	0.0	* 100	* 1,240	* 124,000	* 200	* 1,240	* 248,000
	0.0
	SOMA	* 500	* 620,000	* 500	* 572,000	* 200	* 248,000
Plan2
Plan3