Mapa de Rateio

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

Manhã
	Mapa de rateio dos custos indiretos
	Custos Indiretos	Caldeiraria	Tratamento Térmico	Acabamento	Manutenção	Almoxarifado	Adm. Geral da Fábrica	TOTAL	Caldeiraria	Tratamento Térmico	Acabamento	Manutenção	Almoxarifado	Adm. Geral da Fábrica	TOTAL
	Energia Elétrica	R$72,815.53	R$36,407.77	R$97,087.38	R$14,563.11	R$14,563.11	R$14,563.11	R$250,000.00	300	150	400	60	60	60	1,030
	Energia Elétrica	R$25,166.67	R$33,555.56	R$8,388.89	R$5,033.33	R$1,677.78	R$1,677.78	R$75,500.00	1,500	2,000	500	300	100	100	4,500
	Depreciação	R$58,557.69	R$27,326.92	R$11,711.54	R$3,903.85	0.0	0.0	R$101,500.00	150	70	30	10	0	0	260
	Materiais Auxiliares de Produção	R$44,444.44	R$66,666.67	R$22,222.22	R$11,111.11	0.0	R$5,555.56	R$150,000.00	400	600	200	100	0	50	1,350
	Óleo Combustível (para aquecimento do tratamento térmico)	0.0	R$45,000.00	0.0	0.0	0.0	0.0	R$45,000.00	0	100	0	0	0	0	100
	Aluguel do Prédio	R$12,800.00	R$12,800.00	R$2,400.00	R$5,600.00	R$3,200.00	R$3,200.00	R$40,000.00	800	800	150	350	200	200	2,500
	Telefone	0.0	0.0	0.0	0.0	0.0	R$3,500.00	R$3,500.00	0	0	0	0	0	100	100
	Água	R$337.50	R$337.50	0.0	0.0	0.0	R$75.00	R$750.00	45	45	0	0	0	10	100
	Total	R$214,121.84	R$222,094.41	R$141,810.03	R$40,211.40	R$19,440.88	R$28,571.44	R$666,250.00	34	30	20	10	6	0	100
	Rateio da Adm.	R$9,714.29	R$8,571.43	R$5,714.29	R$2,857.14	R$1,714.29	R$28,571.44
	Total	R$223,836.13	R$230,665.84	R$147,524.32	R$43,068.54	R$21,155.17	R$666,250.00
	Rateio do Almoxarifado	R$11,282.76	R$1,057.76	R$5,993.97	R$2,820.69	R$21,155.17	160	15	85	40	300
	Total	R$235,118.88	R$231,723.60	R$153,518.28	R$45,889.23	R$666,250.00
	Rateio da Manutenção	R$10,589.82	R$28,239.53	R$7,059.88	R$45,889.23	30	80	20	130
	Total	R$245,708.71	R$259,963.13	R$160,578.16	R$666,250.00
	Produto A
	Produto B
	Produto C
Noite
	Mapa de rateio dos custos indiretos
	Custos Indiretos	Caldeiraria	Tratamento Térmico	Acabamento	Manutenção	Almoxarifado	Adm. Geral da Fábrica	TOTAL	Caldeiraria	Tratamento Térmico	Acabamento	Manutenção	Almoxarifado	Adm. Geral da Fábrica	TOTAL
	Energia Elétrica	R$10,289.39	R$16,463.02	R$2,572.35	R$1,543.41	R$514.47	R$617.36	R$32,000.00	2,000	3,200	500	300	100	120	6,220
	Materiais Auxiliares de Produção	R$34,015.54	R$37,678.76	R$15,699.48	R$13,082.90	0.0	R$523.32	R$101,000.00	650	720	300	250	0	10	1,930
	Depreciação	R$13,416.67	R$26,833.33	R$20,125.00	R$20,125.00	0.0	0.0	R$80,500.00	240	480	360	360	0	0	1,440
	Aluguel do Prédio	R$18,128.65	R$14,502.92	R$10,877.19	R$10,877.19	R$5,438.60	R$2,175.44	R$62,000.00	1,000	800	600	600	300	120	3,420
	Mão-de-Obra Indireta	R$30,582.52	R$81,553.40	R$27,184.47	R$15,291.26	R$10,194.17	R$10,194.17	R$175,000.00	7,200	19,200	6,400	3,600	2,400	2,400	41,200
	Óleo Combustível	0.0	R$45,000.00	0.0	0.0	0.0	0.0	R$45,000.00	0	100	0	0	0	0	100
	Água	R$1,120.00	R$1,120.00	0.0	0.0	0.0	R$560.00	R$2,800.00	40	40	0	0	0	20	100
	Telefone	0.0	0.0	0.0	0.0	0.0	R$7,000.00	R$7,000.00	0	0	0	0	0	100	100
	Total	R$107,552.78	R$223,151.43	R$76,458.49	R$60,919.77	R$16,147.24	R$21,070.29	R$505,300.00	30	80	20	15	10	0	155
	Rateio da Adm.	R$4,078.12	R$10,874.99	R$2,718.75	R$2,039.06	R$1,359.37	R$21,070.29
	Total	R$111,630.90	R$234,026.42	R$79,177.24	R$62,958.83	R$17,506.61	R$505,300.00
	Rateio do Almoxarifado	R$3,388.38	R$5,082.57	R$7,059.12	R$1,976.55	R$17,506.61	120	180	250	70	620
	Total	R$115,019.28	R$239,108.99	R$86,236.35	R$64,935.38	R$505,300.00
	Rateio da Manutenção	R$27,829.45	R$27,829.45	R$9,276.48	R$64,935.38	60	60	20	140
	Total	R$142,848.73	R$266,938.44	R$95,512.84
	Produto A	R$357,311.97	R$78,735.60	R$49,267.60	R$485,315.17
	Produto B	R$102,089.13	R$66,036.31	R$213,492.95	R$381,618.40
	Produto C	0.0	R$111,753.76	R$82,112.67	R$193,866.43