MEMÓRIA DE CÁLCULO RATEIO

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

Plan1
	MAPA DE GASTOS
	Custos Indiretos	Usinagem	Cromeação	Montagem	CQ	Almox	Manut	Adm Geral	Total
	Aluguel							$150,000.00	$150,000.00
	Energia	$30,000.00	$10,000.00	$10,000.00				$40,000.00	$90,000.00
	Mat Indiretos	$6,000.00	$4,000.00	$8,000.00	$5,000.00	$10,000.00	$9,000.00	$18,000.00	$60,000.00
	MO Indireta	$40,000.00	$30,000.00	$50,000.00	$30,000.00	$60,000.00	$60,000.00	$80,000.00	$350,000.00
	Depreciação	$21,000.00	$13,000.00	$2,000.00	$10,000.00		$16,000.00	$8,000.00	$70,000.00
	Total	$97,000.00	$57,000.00	$70,000.00	$45,000.00	$70,000.00	$85,000.00	$296,000.00	$720,000.00
	Rateio da Adm Geral
	Aluguel	$30,000.00	$20,000.00	$40,000.00	$15,000.00	$20,000.00	$25,000.00	$(150,000.00)
	Energia	$4,000.00	$2,000.00	$7,000.00	$8,000.00	$6,000.00	$13,000.00	$(40,000.00)
	MO Indireta	$19,000.00	$16,000.00	$21,000.00	$19,000.00	$9,000.00	$22,000.00	$(106,000.00)
	SOMA	$150,000.00	$95,000.00	$138,000.00	$87,000.00	$105,000.00	$145,000.00	0.0
	Rateio dos demais departamentos
	Rateio Manutenção	$50,000.00	$40,000.00	0.0	$40,000.00	$15,000.00	$(145,000.00)
	SOMA	$200,000.00	$135,000.00	$138,000.00	$127,000.00	$120,000.00	0.0
	Rateio Almox	$40,000.00	$40,000.00	$40,000.00	0.0	$(120,000.00)
	SOMA	$240,000.00	$175,000.00	$178,000.00	$127,000.00	0.0	0.0
	Rateio CQ	$68,072.00	$43,942.00	$14,986.00	$(127,000.00)
	SOMA	$308,072.00	$218,942.00	$192,986.00	0.0	0.0	0.0
	RATEIO AOS PRODUTOS (COM BASE NAS HORAS TRABALHADAS EM CADA DEPARTAMENTO)
	G	150	120	80
	H	120	120	70
	I	80	60	43
	G	* 132,030.86	* 87,576.80	* 79,994.20
	H	* 105,624.69	* 87,576.80	* 69,994.92
	I	* 70,416.46	* 43,788.40	* 42,996.88
	Total	* 308,072.00	* 218,942.00	* 192,986.00	$720,000.00
Plan2
	
Plan3