PlanejamentoGeral

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

Orange
	NOSSO T01	NOSSO T02	T01	T02	T03	T04	T05	T06	T07	T08
	IGP	100.20	2.00	100.20	101.70
	IVE	95.00	115.00	95.00	100.00
	IAE	101.00	106.00	101.00	111.00
	Inflação Anual (Prev)	2.00	2.00	5.00
	IVE (Prev)	115.00	115.00	95.00
	IAE (Prev)	106.00	106.00	110.00
	Preço Unitário	$6.25	$6.10	$6.30	$6.60	$6.85	$6.85	$7.30	$7.40	$7.50
	Dividendos	$170,000	$170,000	$150,000	$50,000	$50,000	$100,000	$100,000	$150,000	$200,000
	LDIR	-$16,350	-$16,350	$174,782	$395,562	$349,056	$415,785	$1,060,993	$957,137	$3,323,516
	Volume de Vendas	634,183	634,183	706,017	687,363	677,629	770,000	1,115,227	1,100,000	1,377,030
	Market Share	15.94	15.94	13.56	15.45	13.19	15.64	17.31	18.25	23.68
	Prev. Mercado Potencial	$416,768	$673,500	700,000	680,000
	Prev. Vendas	$480,000	$673,500	706,096	$687,363	$677,629	$1,100,000
	Preço Unitário	$6.25	$6.10	$6.30	$6.60	$6.85	$6.85	$7.30	$7.40	$7.50
	Valor de Vendas	$2,604,800	$4,108,350	$4,448,405	$4,500,000	$4,641,762	$8,140,000
	Verba Marketing	$400,000	$550,000	$600,000	$450,000	$550,000	$700,000	$1,200,000	$1,400,000	$1,400,000
	Verba P&D	$450,000	$400,000	$400,000	$300,000	$400,000	$500,000	$800,000	$700,000	$700,000
	Verba Manutenção	$100,000	$110,000	$225,000	$250,000	$350,000	$350,000	$300,000	$300,000	$300,000
	Prev. Custo Unit MOD	$1.43	$1.67	$1.67	$1.51	$1.45	$1.20	$1.23	$1.23	$1.03
	Volume Produção	550,000	622,500	666,700	687,363	677,629	770,000	1,115,227	1,100,000	1,377,030
	Previsão Folha Pagto	$786,500	$1,039,575	$1,115,520	$1,043,864	$987,735	$924,000	$1,371,729	$1,355,343	$1,418,341
	Investimento Equip.	$210,000	$800,000	$500,000	$100,000	$0	$50,000	$500,000	$500,000	$500,000
	Compra Matéria Prima	$742,500	$800,000	$1,000,000	$900,000	$1,000,000	$1,500,000	$2,000,000	$2,000,000	$2,000,000
	Dividendos	$50,000	$170,000	$150,000	$50,000	$50,000	$100,000	$100,000	$150,000	$200,000
	Outras Despesas 1	-$1,000	-$10,000	-$40,000	-$1,000	-$1,000	-$50,000
	Outras Despesas 2	-$5,000	-$10,000	-$15,000	$25,000
	Outras Despesas 3	-$1,000	-$40,000	-$40,000	-$30,000
	Outras Despesas 4	-$1,000	-$50,000
	Outras Despesas 5
	Outras Despesas 6
	Total Outras Despesas	-$1,000	-$10,000	-$47,000	-$51,000	-$106,000	$0	$0	-$55,000	$0
	Prev. Caixa	-$500,000	$100,000	$200,000	$1,000,000
	Prev. Lucro Líq. após IR	$120,000	$120,000	$200,000	$900,000	$300,000
	Caixa	$441,940	$248,799	$793,868	$1,279,438	$1,329,594	$1,512,626	$1,496,305	$3,879,224
	P. Acabados	$117,951	$0	$0	$0	$0	$0	$0
	M.P.	$1,061,258	$1,119,446	$1,049,194	$1,088,703	$1,524,705	$2,018,780	$2,565,449
	Fáb. e Eq. (rep)	$9,092,217	$9,409,808	$9,276,559	$9,044,641	$8,954,807	$9,240,930	$9,576,539
	P.L.E.	$10,713,367	$10,778,053	$11,119,621	$11,412,783	$11,809,107	$12,772,337	$13,638,294
	Marketing	$550,000	$575,000	$533,333	$537,500	$570,000	$675,000	$778,571
	P&D	$400,000	$400,000	$366,667	$375,000	$400,000	$466,667	$500,000
	Volume de Vendas	634,183	670,100	675,854	676,298	695,038	765,070	812,917
	Lucro Líquido	-$16,350.00	$79,216.00	$184,665.00	$225,763.00	$263,767.00	$396,638.00	$476,709.00
	Taxa de Retorno	1.7137	1.8576	2.4375	2.5970	2.9399	3.9079	4.4638
	Colocação	3	3	1	1	1	1	1
Balanco
	Receita de Vendas	$2,604,800
	Despesas	$2,690,000
	Marketing	$400,000
	P&D	$450,000
	Adm
	Manutenção	$100,000
	MOD	$786,500
	Matéria prima	$742,500
	Diminuição de Estoque
	Depreciação
	Custo Estoc. PA
	Custo Estoc. MP
	Custo Pedido MP
	Custo Mudança Turno
	Desp. Invest. Equip.	$210,000
	Desp. Financeiras
	Desp. Gerais	$1,000
	LAIR	-$85,200
	IR	$0
	LL	-$85,200
	Dividendos	$50,000
	Acrésc. PL	-$135,200
Ficha
	T01	T02	T03	T04
	Mercado Potencial	416,768	538,693	750,000	800,000	900,000
	Previsão Vendas	480,000	538,693	750,000	800,000	900,000
	Preço Unitário	$6.25	$6.25	$6.30	$6.40	$6.55
	Receita de Vendas	$3,000,000	$3,366,831	$4,725,000	$5,120,000	$5,895,000
	Marketing	$400,000	$400,000	$600,000	$500,000	$500,000
	P&D	$450,000	$450,000	$600,000	$450,000	$450,000
	Manutenção	$100,000	$100,000	$150,000	$250,000	$250,000
	Custo Unitário MOD	$1.43	$1.4325	$1.4330	$1.43	$1.43
	Volume de Produção	550,000	550,000
700,000	800,000	900,000
	MOD (Prev. Folha Pgto)	$786,500	$787,875	$1,003,100	$1,144,000	$1,287,000
	Desp. Invest. Equip.	$210,000	$210,000	$500,000	$500,000	$500,000
	Custo Unitário MP	$2.50	$1.4985	$1.45	$2.50	$2.50
	Matéria prima	$1,375,000	$824,175	$1,015,000	$2,000,000	$2,250,000
	Dividendos	$50,000	$50,000	$70,000	$50,000	$150,000
	Outras Despesas 1	$1,000	$1,000	$16,000	$25,000	$25,000
	Outras Despesas 2	$3,000
	Outras Despesas 3	$86,000
	Outras Despesas 4	$10,500
	Outras Despesas 5	$368,345
	Outras Despesas 6	$29,532
	Outras Despesas	$1,000	$1,000	$513,377	$25,000	$25,000
	Total de Despesas	$3,372,500	$2,823,050	$4,451,477	$4,919,000	$5,412,000
	Caixa	-$372,500	$543,781	$273,523	$201,000	$483,000
	Previsão de LL Após IR	$0	$0	$180,525	$132,660	$318,780