Planilha de Controle de Orçamento e Despesas

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

Início
	CONTROLE DE ORÇAMENTO E DESPESAS - INÍCIO
Orçamento
	CONTROLE DE ORÇAMENTO E DESPESAS - ORÇAMENTO
	JANEIRO	FEVEREIRO	MARÇO	ABRIL	MAIO	JUNHO	JULHO	AGOSTO	SETEMBRO	OUTUBRO	NOVEMBRO	DEZEMBRO	TOTAL
	ORÇAMENTO	R$0.00
	ORÇADO MENOS PLANEJADO	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	DIFERENÇA (%)	n/a	n/a	n/a	n/a	n/a	n/a	n/a	n/a	n/a	n/a	n/a	n/a	n/a
	Planejado	Realizado	Dif.	Planejado	Realizado	Dif.	Planejado	Realizado	Dif.	Planejado	Realizado	Dif.	Planejado	Realizado	Dif.	Planejado	Realizado	Dif.	Planejado	Realizado	Dif.	Planejado	Realizado	Dif.	Planejado	Realizado	Dif.	Planejado	Realizado	Dif.	Planejado	Realizado	Dif.	Planejado	Realizado	Dif.	Planejado	Realizado	Dif.
	PRODUÇÃO/INDUSTRIAL	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Matéria-prima	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Mão-de-obra operação	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Manutenção	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Material indireto	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Estoques de Matéria-prima	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Equipamentos	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Outras despesas 	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	COMERCIAL/VENDAS	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Transporte de produtos	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	0
	Comissão de vendas	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Transporte de resíduos	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Outras despesas 	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	MARKETING e PUBLICIDADE	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Propaganda	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Endomarketing	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Plano de marketing	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Pesquisa de mercado	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Marketing virtual	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Outras despesas 	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	DEPARTAMENTO PESSOAL	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Pró-labore	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Auxilio doença	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Benefícios	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Treinamentos	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Programas de saúde 	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Responsabilidade Social	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Outras despesas	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	ADMINISTRATIVO	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Material de escritório	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Mão-de-obra indireta	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Comissão diretoria	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Outras despesas	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	OUTROS	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Empréstimos bancários	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Energia	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
Água	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Telefone	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Internet	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Tarifas alfandegárias	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	Reserva	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
	JANEIRO - Planejado	JANEIRO - Realizado	JANEIRO - Dif.	FEVEREIRO - Planejado	FEVEREIRO - Realizado	FEVEREIRO - Dif.	MARÇO - Planejado	MARÇO - Realizado	MARÇO - Dif.	ABRIL - Planejado	ABRIL - Realizado	ABRIL - Dif.	MAIO - Planejado	MAIO - Realizado	MAIO - Dif.	JUNHO - Planejado	JUNHO - Realizado	JUNHO - Dif.	JULHO - Planejado	JULHO - Realizado	JULHO - Dif.	AGOSTO - Planejado	AGOSTO - Realizado	AGOSTO - Dif.	SETEMBRO - Planejado	SETEMBRO - Realizado	SETEMBRO - Dif.	OUTUBRO - Planejado	OUTUBRO - Realizado	OUTUBRO - Dif.	NOVEMBRO - Planejado	NOVEMBRO - Realizado	NOVEMBRO - Dif.	DEZEMBRO - Planejado	DEZEMBRO - Realizado	DEZEMBRO - Dif.	TOTAL - Planejado	TOTAL - Realizado	TOTAL - Dif.
	TOTAL	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00	R$0.00
Gráficos
	CONTROLE DE ORÇAMENTO E DESPESAS - GRÁFICOS
	Orçado	Planejado	Realizado	Orçado (%)	Planejado (%)	Realizado (%)
	JANEIRO	0.0	0.0	0.0	JANEIRO	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	FEVEREIRO	0.0	0.0	0.0	FEVEREIRO	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	MARÇO	0.0	0.0	0.0	MARÇO	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	ABRIL	0.0	0.0	0.0	ABRIL	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	MAIO	0.0	0.0	0.0	MAIO	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	JUNHO	0.0	0.0	0.0	JUNHO	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	JULHO	0.0	0.0	0.0	JULHO	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	AGOSTO	0.0	0.0	0.0	AGOSTO	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	SETEMBRO	0.0	0.0	0.0	SETEMBRO	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	OUTUBRO	0.0	0.0	0.0	OUTUBRO	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	NOVEMBRO	0.0	0.0	0.0	NOVEMBRO	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	DEZEMBRO	0.0	0.0	0.0	DEZEMBRO	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	TOTAL	0.0	0.0	0.0	TOTAL	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	Selecione o setor:	DEPARTAMENTO PESSOAL
	Selecione o mês:	JANEIRO
	DEPARTAMENTO PESSOAL	PLANEJADO	REALIZADO
	Pró-labore	0.0	0.0
	Auxilio doença	0.0	0.0
	Benefícios	0.0	0.0
	Treinamentos	0.0	0.0
	Programas de saúde 	0.0	0.0
	Responsabilidade Social	0.0	0.0
	Outras despesas	0.0	0.0
	0	ERROR:#N/A	ERROR:#N/A
	0	ERROR:#N/A	ERROR:#N/A
	JANEIRO	PRODUÇÃO/INDUSTRIAL
	FEVEREIRO	COMERCIAL/VENDAS
	MARÇO	MARKETING e PUBLICIDADE
	ABRIL	DEPARTAMENTO PESSOAL
	MAIO	ADMINISTRATIVO
	JUNHO	OUTROS
	JULHO
	AGOSTO
	SETEMBRO
	OUTUBRO
	NOVEMBRO
	DEZEMBRO
	TOTAL