Gabarito Horta

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

Departamentalização
		Depto. auxiliares			Depto produtivos
	Bases Rateio	Adm	Almox.	Mnt	Prep Solo	plantio	Agu/cons	Colheita	Total
	Funcionários	6	8	12	26	18	14	16	100
	Área	70	150	90	1000000	800000	1400000	1200000	4400310
	Requisições	6	10	18	320	480	120	100	1054
	Potência	70	50	60	400	500	180	1300	2560
	Horas mnt	10	8	2	50	130	200	240	640
	H.Con. Qual.				80	120	200	400	800
	Deprec	120	80	40	360	400	80	140	1220
	
		Depto. auxiliares			Depto. produtivos
	CIF	Adm	Almox.	Manutenção	Prep. solo	Plantio	Água/cons	Colheita	Total
	Aluguel	$1.91	$4.09	$2.45	$27,270.81	$21,816.64	$38,179.13	$32,724.97	$120,000.00
	E.elétrica	$4,068.75	$2,906.25	$3,487.50	$23,250.00	$29,062.50	$10,462.50	$75,562.50	$148,800.00
	Seguro	$2,360.66	$1,573.77	$786.89	$7,081.97	$7,868.85	$1,573.77	$2,754.10	$24,000.00
	MOI	$74.30	$99.07	$148.61	$321.98	$222.91	$173.38	$198.14	$1,238.40
	Outros	$3,240.00	$4,320.00	$6,480.00	$14,040.00	$9,720.00	$7,560.00	$8,640.00	$54,000.00
	CIF	$9,745.62	$8,903.18	$10,905.45	$71,964.76	$68,690.91	$57,948.77	$119,879.71	$348,038.40	Próprios
	Rateio ADM		$829.41	$1,244.12	$2,695.60	$1,866.18	$1,451.48	$1,658.83	$9,745.62
	SUB TOTAL 1		$9,732.60
	Rateio Almox			$168.77	$3,000.42	$4,500.62	$1,125.16	$937.63	$9,732.60
	SUB TOTAL 2			$12,318.34
	Rateio MNT				$993.41	$2,582.88	$3,973.66	$4,768.39	$12,318.34
			DEPTº. PRODUTIVOS		Prep. solo	Plantio	Agua/cons	Colheita	TOTAL
				CIF	$78,654.18	$77,640.59	$64,499.06	$127,244.56	$348,038.40
	Produto	Produção
	Cenoura	2480	Tempo Unit		$0.06	$0.12	$0.04	$0.08
	Pepino	1420	Tempo Unit		$0.08	$0.10	$0.06	$0.10
	Alface	2860	Tempo Unit		$0.04	$0.06	$0.02	$0.08
	
	Cenoura		Tempo Total por deptº.		* 148.80	* 297.60	* 99.20	* 198.40	744 h
	Pepino		Tempo Total por deptº.		* 113.60	* 142.00	* 85.20	* 142.00	482,8 h
	Alface		Tempo Total por deptº.		* 114.40	* 171.60	* 57.20	* 228.80	572 h
			Tempo Total dos Deptº		* 376.80	* 611.20	* 241.60	* 569.20	1798,8 h
			Taxa por hora		208.742528811	127.0297672906	266.9663254699	223.5498210412	TOTAL
			CIF CENOURA		* 31,060.89	* 37,804.06	* 26,483.06	* 44,352.28	* 139,700.29
			CIF PEPINO		* 23,713.15	* 18,038.23	* 22,745.53	* 31,744.07	* 96,240.98
			CIF ALFACE		* 23,880.14	* 21,798.30	* 15,270.47	* 51,148.20	* 112,097.12
				TOTAL	* 78,654.18	* 77,640.59	* 64,499.06	* 127,244.56	* 348,038.40
	
	
			Produto		Mat Prima	MOD	CIF	TOTAL	QP	Custo Unit
			CENOURA		* 28,640.00	* 4,953.60	* 139,700.29	* 173,293.89	2480	* 69.88
			PEPINO		* 32,440.00	* 2,476.80	* 96,240.98	* 131,157.78	1420	* 92.36
			ALFACE		* 60,220.00	* 3,715.20	* 112,097.12	* 176,032.32	2860	* 61.55
				TOTAL	* 121,300.00	* 11,145.60	* 348,038.40	* 480,484.00
Plan2
	
Plan3