Controle de Estoques pdf 1

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

Terno Masculino
	Ficha de Controle de Estoque - Custo Médio	Item:	TERNO MASCULINO REF-0001
	Data	Histórico	Entradas	Saídas	Saldos
	Qtde	Custo Unitário	Valor	Qtde	Custo Unitário	Valor CMV	Qtde	Custo Unitário	Valor
	1/2/17	compra	116.00	R$ 454.69	R$ 52,744.04	0.00	0.0	R$ 454.69	0.0	116.00	R$ 454.69	R$ 52,744.04
	1/17/17	venda	0.00	0.0	0.0	20.00	R$ 454.69	R$ 454.69	R$ 9,093.80	96.00	R$ 454.69	R$ 43,650.24
	1/23/17	venda	0.00	0.0	0.0	25.00	R$ 454.69	R$ 454.69	R$ 11,367.25	71.00	R$ 454.69	R$ 32,282.99
	1/27/17	venda	0.00	0.0	0.0	25.00	R$ 454.69	R$ 454.69	R$ 11,367.25	46.00	R$ 454.69	R$ 20,915.74
	2/3/17	compra	100.00	R$ 454.69	R$ 45,469.00	0.00	0.0	R$ 454.69	0.0	146.00	R$ 454.69	R$ 66,384.74
	2/6/17	venda	0.00	0.0	0.0	21.00	R$ 454.69	R$ 454.69	R$ 9,548.49	125.00	R$ 454.69	R$ 56,836.25
	2/12/17	venda	0.00	0.0	0.0	35.00	R$ 454.69	R$ 454.69	R$ 15,914.15	90.00	R$ 454.69	R$ 40,922.10
	2/24/17	venda	0.00	0.0	0.0	35.00	R$ 454.69	R$ 454.69	R$ 15,914.15	55.00	R$ 454.69	R$ 25,007.95
	3/5/17	compra	104.00	R$ 454.69	R$ 47,287.76	0.00	0.0	R$ 454.69	0.0	159.00	R$ 454.69	R$ 72,295.71
	3/9/17	venda	0.00	0.0	0.0	21.00	R$ 454.69	R$ 454.69	R$ 9,548.49	138.00	R$ 454.69	R$ 62,747.22
	3/14/17	venda	0.00	0.0	0.0	44.00	R$ 454.69	R$ 454.69	R$ 20,006.36	94.00	R$ 454.69	R$ 42,740.86
	3/26/17	venda	0.00	0.0	0.0	44.00	R$ 454.69	R$ 454.69	R$ 20,006.36	50.00	R$ 454.69	R$ 22,734.50
	320.00	270.00	R$ 122,766.30
Camisa Social
	Ficha de Controle de Estoque - Custo Médio	Item:	CAMISA SOCIAL REF-0002
	Data	Histórico	Entradas	Saídas	Saldos
	Qtde	Custo Unitário	Valor	Qtde	Custo Unitário	Valor CMV	Qtde	Custo Unitário	Valor
	1/2/17	compra	128.00	R$ 101.85	R$ 13,036.80	0.00	0.0	R$ 101.85	0.0	128.00	R$ 101.85	R$ 13,036.80
	1/17/17	venda	0.00	0.0	0.0	20.00	R$ 101.85	R$ 101.85	R$ 2,037.00	108.00	R$ 101.85	R$ 10,999.80
	1/23/17	venda	0.00	0.0	0.0	30.00	R$ 101.85	R$ 101.85	R$ 3,055.50	78.00	R$ 101.85	R$ 7,944.30
	1/27/17	venda	0.00	0.0	0.0	30.00	R$ 101.85	R$ 101.85	R$ 3,055.50	48.00	R$ 101.85	R$ 4,888.80
	2/3/17	compra	106.00	R$ 101.85	R$ 10,796.10	0.00	0.0	R$ 101.85	0.0	154.00	R$ 101.85	R$ 15,684.90
	2/6/17	venda	0.00	0.0	0.0	20.00	R$ 101.85	R$ 101.85	R$ 2,037.00	134.00	R$ 101.85	R$ 13,647.90
	2/12/17	venda	0.00	0.0	0.0	38.00	R$ 101.85	R$ 101.85	R$ 3,870.30	96.00	R$ 101.85	R$ 9,777.60
	2/24/17	venda	0.00	0.0	0.0	38.00	R$ 101.85	R$ 101.85	R$ 3,870.30	58.00	R$ 101.85	R$ 5,907.30
	3/5/17	compra	112.00	R$ 101.85	R$ 11,407.20	0.00	0.0	R$ 101.85	0.0	170.00	R$ 101.85	R$ 17,314.50
	3/9/17	venda	0.00	0.0	0.0	21.00	R$ 101.85	R$ 101.85	R$ 2,138.85	149.00	R$ 101.85	R$ 15,175.65
	3/14/17	venda	0.00	0.0	0.0	47.00	R$ 101.85	R$ 101.85	R$ 4,786.95	102.00	R$ 101.85	R$ 10,388.70
	3/26/17	venda	0.00	0.0	0.0	47.00	R$ 101.85	R$ 101.85	R$ 4,786.95	55.00	R$ 101.85	R$ 5,601.75
	346.00	291.00	R$ 29,638.35
Gravata
	Ficha de Controle de Estoque - Custo Médio	Item:	GRAVATA REF-0003
	Data	Histórico	Entradas	Saídas	Saldos
	Qtde	Custo Unitário	Valor	Qtde	Custo Unitário	Valor CMV	Qtde	Custo Unitário	Valor
	1/2/17	compra	144.00	R$ 21.83	R$ 3,143.52	0.00	0.0	R$ 21.83	0.0	144.00	R$ 21.83	R$ 3,143.52
	1/17/17	venda	0.00	0.0	0.0	10.00	R$ 21.83	R$ 21.83	R$ 218.30	134.00	R$ 21.83	R$ 2,925.22
	1/23/17	venda	0.00	0.0	0.0	40.00	R$ 21.83	R$ 21.83	R$ 873.20	94.00	R$ 21.83	R$ 2,052.02
	1/27/17	venda	0.00	0.0	0.0	40.00	R$ 21.83	R$ 21.83	R$ 873.20	54.00	R$ 21.83	R$ 1,178.82
	2/3/17	compra	119.00	R$ 21.83	R$ 2,597.77	0.00	0.0	R$ 21.83	0.0	173.00	R$ 21.83	R$ 3,776.59
	2/6/17	venda	0.00	0.0	0.0	10.00	R$ 21.83	R$ 21.83	R$ 218.30	163.00	R$ 21.83	R$ 3,558.29
	2/12/17	venda	0.00	0.0	0.0	49.00	R$ 21.83	R$ 21.83	R$ 1,069.67	114.00	R$ 21.83	R$ 2,488.62
	2/24/17	venda	0.00	0.0	0.0	49.00	R$ 21.83	R$ 21.83	R$ 1,069.67	65.00	R$ 21.83	R$ 1,418.95
	3/5/17	compra	125.00	R$ 21.83	R$ 2,728.75	0.00	0.0	R$ 21.83	0.0	190.00	R$ 21.83	R$ 4,147.70
	3/9/17	venda	0.00	0.0	0.0	10.00	R$ 21.83	R$ 21.83	R$ 218.30	180.00	R$ 21.83	R$ 3,929.40
	3/14/17	venda	0.00	0.0	0.0	60.00	R$ 21.83	R$ 21.83	R$ 1,309.80	120.00	R$ 21.83	R$ 2,619.60
	3/26/17	venda	0.00	0.0	0.0	60.00	R$ 21.83	R$ 21.83	R$ 1,309.80	60.00	R$ 21.83	R$ 1,309.80
	388.00	328.00	R$ 7,160.24
Blusa Masculina
	Ficha de Controle de Estoque - Custo Médio	Item:	BLUSA MASCULINA REF-0004
	Data	Histórico	Entradas	Saídas	Saldos
	Qtde	Custo Unitário	Valor	Qtde	Custo Unitário	Valor CMV	Qtde	Custo Unitário	Valor
	1/2/17	compra	48.00	R$ 163.69	R$ 7,857.12	0.00	0.0	R$ 163.69	0.0	48.00	R$ 163.69	R$ 7,857.12
	1/17/17	venda	0.00	0.0	0.0	10.00	R$ 163.69	R$ 163.69	R$ 1,636.90	38.00	R$ 163.69	R$ 6,220.22
	1/23/17	venda	0.00	0.0	0.0	10.00	R$ 163.69	R$ 163.69	R$ 1,636.90	28.00	R$ 163.69	R$ 4,583.32
	1/27/17	venda	0.00	0.0	0.0	10.00	R$ 163.69	R$ 163.69	R$ 1,636.90	18.00	R$ 163.69	R$ 2,946.42
	2/3/17	compra	40.00	R$ 163.69	R$ 6,547.60	0.00	0.0	R$ 163.69	0.0	58.00	R$ 163.69	R$ 9,494.02
	2/6/17	venda	0.00	0.0	0.0	10.00	R$ 163.69	R$ 163.69	R$ 1,636.90	48.00	R$ 163.69	R$ 7,857.12
	2/12/17	venda	0.00	0.0	0.0	13.00	R$ 163.69	R$ 163.69	R$ 2,127.97	35.00	R$ 163.69	R$ 5,729.15
	2/24/17	venda	0.00	0.0	0.0	13.00	R$ 163.69	R$ 163.69	R$ 2,127.97	22.00	R$ 163.69	R$ 3,601.18
	3/5/17	compra	51.00	R$ 163.69	R$ 8,348.19	0.00	0.0	R$ 163.69	0.0	73.00	R$ 163.69	R$ 11,949.37
	3/9/17	venda	0.00	0.0	0.0	11.00	R$ 163.69	R$ 163.69	R$ 1,800.59	62.00	R$ 163.69	R$ 10,148.78
	3/14/17	venda	0.00	0.0	0.0	16.00	R$ 163.69	R$ 163.69	R$ 2,619.04	46.00	R$ 163.69	R$ 7,529.74
	3/26/17	venda	0.00	0.0	0.0	16.00	R$ 163.69	R$ 163.69	R$ 2,619.04	30.00	R$ 163.69	R$ 4,910.70
	139.00	109.00	R$ 17,842.21
Sapato Social
	Ficha de Controle de Estoque - Custo Médio	Item:	SAPATO SOCIAL REF-0005
	Data	Histórico	Entradas	Saídas	Saldos
	Qtde	Custo Unitário	Valor	Qtde	Custo Unitário	Valor CMV	Qtde	Custo Unitário	Valor
	1/2/17	compra	96.00	R$ 105.49	R$ 10,127.04	0.00	0.0	R$ 105.49	0.0	96.00	R$ 105.49	R$ 10,127.04
	1/17/17	venda	0.00	0.0	0.0	10.00	R$ 105.49	R$ 105.49	R$ 1,054.90	86.00	R$ 105.49	R$ 9,072.14
	1/23/17	venda	0.00	0.0	0.0	25.00	R$ 105.49	R$ 105.49	R$ 2,637.25	61.00	R$ 105.49	R$ 6,434.89
	1/27/17	venda	0.00	0.0	0.0	25.00	R$ 105.49	R$ 105.49	R$ 2,637.25	36.00	R$ 105.49	R$ 3,797.64
	2/3/17	compra	79.00	R$ 105.49	R$ 8,333.71	0.00	0.0	R$ 105.49	0.0	115.00	R$ 105.49	R$ 12,131.35
	2/6/17	venda	0.00	0.0	0.0	10.00	R$ 105.49	R$ 105.49	R$ 1,054.90	105.00	R$ 105.49	R$ 11,076.45
	2/12/17	venda	0.00	0.0	0.0	31.00	R$ 105.49	R$ 105.49	R$ 3,270.19	74.00	R$ 105.49	R$ 7,806.26
	2/24/17	venda	0.00	0.0	0.0	31.00	R$ 105.49	R$ 105.49	R$ 3,270.19	43.00	R$ 105.49	R$ 4,536.07
	3/5/17	compra	88.00	R$ 105.49	R$ 9,283.12	0.00	0.0	R$ 105.49	0.0	131.00	R$ 105.49	R$ 13,819.19
	3/9/17	venda	0.00	0.0	0.0	10.00	R$ 105.49	R$ 105.49	R$ 1,054.90	121.00	R$ 105.49	R$ 12,764.29
	3/14/17	venda	0.00	0.0	0.0	38.00	R$ 105.49	R$ 105.49	R$ 4,008.62	83.00	R$ 105.49	R$ 8,755.67
	3/26/17	venda	0.00	0.0	0.0	38.00	R$ 105.49	R$ 105.49	R$ 4,008.62	45.00	R$ 105.49	R$ 4,747.05
	263.00	218.00	R$ 22,996.82
Totalizador CMV
	Ficha de Controle de Estoque - Custo Médio	Item:	TOTALIZADOR CMV
	Data	Histórico	Entradas	Saídas	Saldos
	Qtde	Custo Unitário	Valor	Qtde	Custo Unitário	Valor CMV	Qtde	Custo Unitário	Valor
	0.0	0.00	0.0	0.0	0.0	0.00	0.0	0.0
	0.00	0.00	R$ 200,403.92	ERROR:#REF!