Orçamento de vendas prática

Prévia do material em texto

1-Orçamento_de_Vendas
	Orçamento de Vendas	Base	Jan/20	Feb/20	Mar/20	Apr/20	May/20	Jun/20	Jul/20	Aug/20	Sep/20	Oct/20	Nov/20	Dec/20	Total
	ROLAMENTOS
	Preço de Venda Original		47.00 	47.00 	47.00 	47.00 	47.00 	47.00 	47.00 	47.00 	47.00 	47.00 	47.00 	47.00 
	Preço de Venda		47.00 	47.00 	47.00 	47.00 	47.00 	47.00 	47.00 	47.00 	47.00 	47.00 	47.00 	47.00 	47.00 
	Variação de Preço
	Volume Original		5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000
	Volume		5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	60,000 
	Variação de Volume
	Receita Bruta		235,000 	235,000 	235,000 	235,000 	235,000 	235,000 	235,000 	235,000 	235,000 	235,000 	235,000 	235,000 	2,820,000 
	Impostos		-66,761 	-66,761 	-66,761 	-66,761 	-66,761 	-66,761 	-66,761 	-66,761 	-66,761 	-66,761 	-66,761 	-66,761 	-801,136 
	IPI	10.00%	-21,364 	-21,364 	-21,364 	-21,364 	-21,364 	-21,364 	-21,364 	-21,364 	-21,364 	-21,364 	-21,364 	-21,364 	-256,364 
	ICMS	12.00%	-25,636 	-25,636 	-25,636 	-25,636 	-25,636 	-25,636 	-25,636 	-25,636 	-25,636 	-25,636 	-25,636 	-25,636 	-307,636 
	PIS	1.65%	-3,525 	-3,525 	-3,525 	-3,525 	-3,525 	-3,525 	-3,525 	-3,525 	-3,525 	-3,525 	-3,525 	-3,525 	-42,300 
	COFINS	7.60%	-16,236 	-16,236 	-16,236 	-16,236 	-16,236 	-16,236 	-16,236 	-16,236 	-16,236 	-16,236 	-16,236 	-16,236 	-194,836 
	Outro (1)		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Outro (2)		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Receita Líquida		168,239 	168,239 	168,239 	168,239 	168,239 	168,239 	168,239 	168,239 	168,239 	168,239 	168,239 	168,239 	2,018,864 
	ESCAPAMENTOS
	Preço de Venda Original		50.00 	50.00 	50.00 	50.00 	50.00 	50.00 	50.00 	50.00 	50.00 	50.00 	50.00 	50.00 
	Preço de Venda		50.00 	50.00 	50.00 	50.00 	50.00 	50.00 	50.00 	50.00 	50.00 	50.00 	50.00 	50.00 	50.00 
	Variação de Preço
	Volume Original		2,000	2,000	2,000	2,000	2,000	2,000	2,000	2,000	2,000	2,000	2,000	2,000
	Volume		2,000 	2,000 	2,000 	2,000 	2,000 	2,000 	2,000 	2,000 	2,000 	2,000 	2,000 	2,000 	24,000 
	Variação de Volume
	Receita Bruta		100,000 	100,000 	100,000 	100,000 	100,000 	100,000 	100,000 	100,000 	100,000 	100,000 	100,000 	100,000 	1,200,000 
	Impostos		-28,409 	-28,409 	-28,409 	-28,409 	-28,409 	-28,409 	-28,409 	-28,409 	-28,409 	-28,409 	-28,409 	-28,409 	-340,909 
	IPI	10.00%	-9,091 	-9,091 	-9,091 	-9,091 	-9,091 	-9,091 	-9,091 	-9,091 	-9,091 	-9,091 	-9,091 	-9,091 	-109,091 
	ICMS	12.00%	-10,909 	-10,909 	-10,909 	-10,909 	-10,909 	-10,909 	-10,909 	-10,909 	-10,909 	-10,909 	-10,909 	-10,909 	-130,909 
	PIS	1.65%	-1,500 	-1,500 	-1,500 	-1,500 	-1,500 	-1,500 	-1,500 	-1,500 	-1,500 	-1,500 	-1,500 	-1,500 	-18,000 
	COFINS	7.60%	-6,909 	-6,909 	-6,909 	-6,909 	-6,909 	-6,909 	-6,909 	-6,909 	-6,909 	-6,909 	-6,909 	-6,909 	-82,909 
	Outro (1)		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Outro (2)		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Receita Líquida		71,591 	71,591 	71,591 	71,591 	71,591 	71,591 	71,591 	71,591 	71,591 	71,591 	71,591 	71,591 	859,091 
	EMBREAGENS
	Preço de Venda Original		230.00 	230.00 	230.00 	230.00 	230.00 	230.00 	230.00 	230.00 	230.00 	230.00 	230.00 	230.00 
	Preço de Venda		230.00 	230.00 	230.00 	230.00 	230.00 	230.00 	230.00 	230.00 	230.00 	230.00 	230.00 	230.00 	230.00 
	Variação de Preço
	Volume Original		800	800	800	800	800	800	800	800	800	800	800	800
	Volume		800 	800 	800 	800 	800 	800 	800 	800 	800 	800 	800 	800 	9,600 
	Variação de Volume
	Receita Bruta		184,000 	184,000 	184,000 	184,000 	184,000 	184,000 	184,000 	184,000 	184,000 	184,000 	184,000 	184,000 	2,208,000 
	Impostos		-52,273 	-52,273 	-52,273 	-52,273 	-52,273 	-52,273 	-52,273 	-52,273 	-52,273 	-52,273 	-52,273 	-52,273 	-627,273 
	IPI	10.00%	-16,727 	-16,727 	-16,727 	-16,727 	-16,727 	-16,727 	-16,727 	-16,727 	-16,727 	-16,727 	-16,727 	-16,727 	-200,727 
	ICMS	12.00%	-20,073 	-20,073 	-20,073 	-20,073 	-20,073 	-20,073 	-20,073 	-20,073 	-20,073 	-20,073 	-20,073 	-20,073 	-240,873 
	PIS	1.65%	-2,760 	-2,760 	-2,760 	-2,760 	-2,760 	-2,760 	-2,760 	-2,760 	-2,760 	-2,760 	-2,760 	-2,760 	-33,120 
	COFINS	7.60%	-12,713 	-12,713 	-12,713 	-12,713 	-12,713 	-12,713 	-12,713 	-12,713 	-12,713 	-12,713 	-12,713 	-12,713 	-152,553 
	Outro (1)		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Outro (2)		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Receita Líquida		131,727 	131,727 	131,727 	131,727 	131,727 	131,727 	131,727 	131,727 	131,727 	131,727 	131,727 	131,727 	1,580,727 
	AMORTECEDORES
	Preço de Venda Original		100.00 	100.00 	100.00 	100.00 	100.00 	100.00 	100.00 	100.00 	100.00 	100.00 	100.00 	100.00 
	Preço de Venda		100.00 	100.00 	100.00 	100.00 	100.00 	100.00 	100.00 	100.00 	100.00 	100.00 	100.00 	100.00 	100.00 
	Variação de Preço
	Volume Original		700	700	700	700	700	700	700	700	700	700	700	700
	Volume		700 	700 	700 	700 	700 	700 	700 	700 	700 	700 	700 	700 	8,400 
	Variação de Volume
	Receita Bruta		70,000 	70,000 	70,000 	70,000 	70,000 	70,000 	70,000 	70,000 	70,000 	70,000 	70,000 	70,000 	840,000 
	Impostos		-19,886 	-19,886 	-19,886 	-19,886 	-19,886 	-19,886 	-19,886 	-19,886 	-19,886 	-19,886 	-19,886 	-19,886 	-238,636 
	IPI	10.00%	-6,364 	-6,364 	-6,364 	-6,364 	-6,364 	-6,364 	-6,364 	-6,364 	-6,364 	-6,364 	-6,364 	-6,364 	-76,364 
	ICMS	12.00%	-7,636 	-7,636 	-7,636 	-7,636 	-7,636 	-7,636 	-7,636 	-7,636 	-7,636 	-7,636 	-7,636 	-7,636 	-91,636 
	PIS	1.65%	-1,050 	-1,050 	-1,050 	-1,050 	-1,050 	-1,050 	-1,050 	-1,050 	-1,050 	-1,050 	-1,050 	-1,050 	-12,600 
	COFINS	7.60%	-4,836 	-4,836 	-4,836 	-4,836 	-4,836 	-4,836 	-4,836 	-4,836 	-4,836 	-4,836 	-4,836 	-4,836 	-58,036 
	Outro (1)		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Outro (2)		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Receita Líquida		50,114 	50,114 	50,114 	50,114 	50,114 	50,114 	50,114 	50,114 	50,114 	50,114 	50,114 	50,114 	601,364 
	MOLAS
	Preço de Venda Original		40.00 	40.00 	40.00 	40.00 	40.00 	40.00 	40.00 	40.00 	40.00 	40.00 	40.00 	40.00 
	Preço de Venda		40.00 	40.00 	40.00 	40.00 	40.00 	40.00 	40.00 	40.00 	40.00 	40.00 	40.00 	40.00 	40.00 
	Variação de Preço
	Volume Original		1,800	1,800	1,800	1,800	1,800	1,800	1,800	1,800	1,800	1,800	1,800	1,800
	Volume		1,800 	1,800 	1,800 	1,800 	1,800 	1,800 	1,800 	1,800 	1,800 	1,800 	1,800 	1,800 	21,600 
	Variação de Volume
	Receita Bruta		72,000 	72,000 	72,000 	72,000 	72,000 	72,000 	72,000 	72,000 	72,000 	72,000 	72,000 	72,000 	864,000 
	Impostos		-20,455 	-20,455 	-20,455 	-20,455 	-20,455 	-20,455 	-20,455 	-20,455 	-20,455 	-20,455 	-20,455 	-20,455 	-245,455 
	IPI	10.00%	-6,545 	-6,545 	-6,545 	-6,545 	-6,545 	-6,545 	-6,545 	-6,545 	-6,545 	-6,545 	-6,545 	-6,545 	-78,545 
	ICMS	12.00%	-7,855 	-7,855 	-7,855 	-7,855 	-7,855 	-7,855 	-7,855 	-7,855 	-7,855 	-7,855 	-7,855 	-7,855 	-94,255 
	PIS	1.65%	-1,080 	-1,080 	-1,080 	-1,080 	-1,080 	-1,080 	-1,080 	-1,080 	-1,080 	-1,080 	-1,080 	-1,080 	-12,960 
	COFINS	7.60%	-4,975 	-4,975 	-4,975 	-4,975 	-4,975 	-4,975 	-4,975 	-4,975 	-4,975 	-4,975 	-4,975 	-4,975 	-59,695 
	Outro (1)		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Outro (2)		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Receita Líquida		51,545 	51,545 	51,545 	51,545 	51,545 	51,545 	51,545 	51,545 	51,545 	51,545 	51,545 	51,545 	618,545 
	Preço de Venda Original
	Preço de Venda		0.00 	0.00 	0.00 	0.00 	0.00 	0.00 	0.00 	0.00 	0.00 	0.00 	0.00 	0.00 	0.00 
	Variação de Preço
	Volume Original
	Volume		0.00 	0.00 	0.00 	0.00 	0.00 	0.00 	0.00 	0.00 	0.00 	0.00 	0.00 	0.00 	0 
	Variação de Volume
	Receita Bruta		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Impostos		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	IPI	10.00%	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	ICMS	12.00%	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	PIS	1.65%	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	COFINS	7.60%	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Outro (1)		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Outro (2)		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Receita Líquida		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Receita Bruta		661,000 	661,000 	661,000 	661,000661,000 	661,000 	661,000 	661,000 	661,000 	661,000 	661,000 	661,000 	7,932,000 
	Impostos		-187,784 	-187,784 	-187,784 	-187,784 	-187,784 	-187,784 	-187,784 	-187,784 	-187,784 	-187,784 	-187,784 	-187,784 	-2,253,409 
	IPI		-60,091 	-60,091 	-60,091 	-60,091 	-60,091 	-60,091 	-60,091 	-60,091 	-60,091 	-60,091 	-60,091 	-60,091 	-721,091 
	ICMS		-72,109 	-72,109 	-72,109 	-72,109 	-72,109 	-72,109 	-72,109 	-72,109 	-72,109 	-72,109 	-72,109 	-72,109 	-865,309 
	PIS		-9,915 	-9,915 	-9,915 	-9,915 	-9,915 	-9,915 	-9,915 	-9,915 	-9,915 	-9,915 	-9,915 	-9,915 	-118,980 
	COFINS		-45,669 	-45,669 	-45,669 	-45,669 	-45,669 	-45,669 	-45,669 	-45,669 	-45,669 	-45,669 	-45,669 	-45,669 	-548,029 
	Outro (1)		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Outro (2)		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 
	Receita Líquida		473,216 	473,216 	473,216 	473,216 	473,216 	473,216 	473,216 	473,216 	473,216 	473,216 	473,216 	473,216 	5,678,591 
9-Painel_de_Controle
	Indicadores	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	2019
	Indicadores DRE
	Faturamento Bruto (R$)
	Faturamento Líquido (R$)
	Custo das Vendas e Serviços (R$)
	Custo das Vendas e Serviços (%)
	Matéria-Prima (R$)
	Matéria-Prima (%)
	Despesas Operacionais (R$)
	Despesas Operacionais (%)
	EBITDA (R$)
	EBITDA (%)
	Resultado Financeiro (R$)
	Resultado Financeiro (%)
	Indicadores de Liquidez
	Liquidez Corrente
	Liquidez Seca
	iquidez Geral
	Indicadores de Estrutura de Capital
	Participação dos Capitais de Terceiros
	Endividamento Total
	Endividamento CP (%)
	Endividamento LP (%)
	Dívida Líquida / EBITDA
	Indicadores de Rentabilidade
	ROI (%)
	Rentabilidade do Ativo (%)
	Rentabilidade do Capital Próprio (%)
	Prazos Médios
	Clientes
	Estoques
	Fornecedores