Cafés Monte Bianco II

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

DRE
	DEMONSTRAÇÃO DO RESULTADO DO EXERCCÍCIO
	2000	AV	AH	2001	AV	AH
	RECEITAS	* 56,112,408.00	100%	100%	* 182,980,000.00	100%	326%
	SEM MARCA	* 9,934,848.00	18%	100%	* 14,080,000.00	8%	142%
	MARCA PREMIUM	* 46,177,560.00	82%	100%	* 168,900,000.00	92%	366%
	CUSTO DOS PRODUTOS VENDIDOS	* (33,233,867.00)	-59%	100%	* (109,312,600.00)	-60%	329%
	MARGEM BRUTA	* 22,878,541.00	41%	100%	* 73,667,400.00	40%	322%
	DEPESAS DE MARKETING	* (4,155,980.00)	-7%	100%	* (15,612,000.00)	-9%	376%
	DESPESAS DE P&D	* (3,328,130.00)	-6%	100%	* (3,328,130.00)	-2%	100%
	DESPESAS DE VENDAS	* (3,574,710.00)	-6%	100%	* (3,574,710.00)	-2%	100%
	DESPESAS ADMINISTRATIVAS	* (4,752,000.00)	-8%	100%	* (4,752,000.00)	-3%	100%
	DESPESAS FINANCEIRAS	* (3,825,000.00)	-7%	100%	* (3,825,000.00)	-2%	100%
	LUCRO ANTES DO IR	* 3,242,721.00	6%	100%	* 42,575,560.00	23%	1313%
	IR (40%)	* (1,297,088.40)	-2%	100%	* (17,030,224.00)	-9%	1313%
	LUCRO LIQUIDO	* 1,945,632.60	3%	100%	* 25,545,336.00	14%	1313%
BALANÇO
	BALANÇO PATRIMONIAL
	ATIVO	PASSIVO
	2000	AV	AH	2001	AV	AH	2000	AV	AH	2001	AV	AH
	Caixa	* 1,121,450.00	3%	100%	* 39,039,504.00	45%	3481%	Contas a Pagar	* 487,331.00	1%	100%	0.0	0%
	Estoque de Matéria-prima	* 2,907,963.00	7%	100%	0.0	0%	-100%	Empréstimos - CP	* 25,000,000.00	56%	100%	* 25,000,000.00	29%	100%
	Estoque de Prod. Acabados (174.000kg)	* 1,148,400.00	3%	100%	0.0	0%	-100%	IR a Pagar	0.0	0.0	* 17,030,224.00	20%
	Contas a Receber	* 9,368,467.00	21%	100%	* 17,595,005.00	20%	188%	Empréstimos - LP	* 10,000,000.00	22%	100%	* 10,000,000.00	12%	100%
	0%
	Imobilizado	* 42,374,000.00	95%	100%	* 42,374,000.00	49%	100%	Patrimônio Liquido	* 9,165,869.00	21%	100%	* 34,711,205.00	40%	379%
	Depreciação Acumulada	* (12,267,080.00)	-27%	100%	* (12,267,080.00)	-14%	100%	Capital Social	* 9,165,869.00	21%	100%	* 9,165,869.00	11%	100%
	Reserva de lucro	0.0	* 25,545,336.00	29%
	Total do Ativo	* 44,653,200.00	100%	* 86,741,429.00	100%	194%	Total do Passivo	* 44,653,200.00	100%	* 86,741,429.00	100%	194%
	0.0
	2000	2001
	ROE	21.23%	73.59%
MARGEM CONTRIBUIÇÃO
	PRODUTO	D	C	B	BB	A	AA	AAA	TOTAL
	PREÇO POR KG	* 8,800.00	* 19,500.00	* 26,600.00	* 30,000.00	* 35,500.00	* 39,000.00	* 42,600.00
	CUSTO UNITÁRIO (VARIÁVEL)	* 6,600.00	* 12,485.00	* 14,275.00	* 16,288.00	* 17,791.00	* 19,166.00	* 20,441.00
	MARGEM CONTRIBUIÇÃO	* 2,200.00	* 7,015.00	* 12,325.00	* 13,712.00	* 17,709.00	* 19,834.00	* 22,159.00
	CUSTO FIXO	* 3,319,500.00	* 4,100,500.00	* 4,100,500.00	* 4,100,500.00	* 4,100,500.00	* 4,100,500.00	* 4,100,500.00
	PONTO DE EQUILIBRIO	1509	585	333	299	232	207	185	3348
	% PONTO DE EQUILIBRIO	45%	17%	10%	9%	7%	6%	6%	100%
	% CAPACIDADE PRODUTIVA	* 2,703,671	* 1,047,401	* 596,147	* 535,846	* 414,903	* 370,451	* 331,582	* 6,000,000	* 0.45
	RECEITA	* 23,792,301.88	* 20,424,317.33	* 15,857,521.98	* 16,075,373.18	* 14,729,056.52	* 14,447,573.47	* 14,125,377.24	* 119,451,521.60
	* 1,982,691.82	* 5,106,079.33	* 3,964,380.50	* 4,018,843.30	* 3,682,264.13	* 3,611,893.37	* 3,531,344.31	* 25,897,496.75	* 93,554,024.85
	CUSTO	* 21,050,779.82	* 16,655,768.93	* 12,584,076.37	* 14,220,810.96	* 11,634,709.94	* 10,897,545.35	* 10,176,903.24	* 97,220,594.63
	MARGEM BRUTA	* 2,741,522.06	* 3,768,548.40	* 3,273,445.61	* 1,854,562.22	* 3,094,346.58	* 3,550,028.12	* 3,948,473.99	* 22,230,926.97	* 22,878,541.00
	DEPESAS DE MARKETING	0.0	0	0	0	0	0	* 56,501.51	* (4,212,481.51)	* (4,155,980.00)	* (1,872,733.54)
	DESPESAS DE P&D	* (3,328,130.00)	* (3,328,130.00)	* (1,499,694.58)
	DESPESAS DE VENDAS	* (3,574,710.00)	* (3,574,710.00)	* (1,610,806.43)
	DESPESAS ADMINISTRATIVAS	* (4,752,000.00)	* (4,752,000.00)	* (2,141,307.17)
	DESPESAS FINANCEIRAS	* (3,825,000.00)	* (3,825,000.00)	* (1,723,590.05)
	LUCRO ANTES DO IR	* 2,538,605.46	* 3,242,721.00
	IR (40%)	* 1,015,442.19	* (1,297,088.40)
	LUCRO LIQUIDO	* 1,523,163.28	* 1,945,632.60
	SL 2000	RECEB	CUSTO	DESPESAS
	CAIXA	* 1,121,450.00	* 103,351,030.85	* (97,220,594.63)	* (19,692,321.51)	* (12,440,435.29)
MARGEM CONTRIBUIÇÃO (2)
	PRODUTO	D	C	B	BB	A	AA	AAA	TOTAL
	PREÇO POR KG	* 8,800.00	* 19,500.00	* 26,600.00	* 30,000.00	* 35,500.00	* 39,000.00	* 42,600.00
	CUSTO UNITÁRIO (VARIÁVEL)	* 6,600.00	* 12,485.00	* 14,275.00	* 16,288.00	* 17,791.00	* 19,166.00	* 20,441.00
	MARGEM CONTRIBUIÇÃO	* 2,200.00	* 7,015.00	* 12,325.00	* 13,712.00	* 17,709.00	* 19,834.00	* 22,159.00
	CUSTO FIXO	* 3,319,500.00	* 4,100,500.00	* 4,100,500.00	* 4,100,500.00	* 4,100,500.00	* 4,100,500.00	* 4,100,500.00
	PONTO DE EQUILIBRIO	1509	585	333	299	232	207	185	3348
	% PONTO DE EQUILIBRIO	45%	17%	10%	9%	7%	6%	6%	100%
	% CAPACIDADE PRODUTIVA	* 1,200,000	* 800,000	* 800,000	* 800,000	* 800,000	* 800,000	* 800,000	* 6,000,000	* 0.20
	800	0.0
	RECEITA	* 10,560,000.00	* 15,600,000.00	* 21,280,000.00	* 24,000,000.00	* 28,400,000.00	* 31,200,000.00	* 34,080,000.00	* 165,120,000.00
	* 880,000.00	* 3,900,000.00	* 5,320,000.00	* 6,000,000.00	* 7,100,000.00	* 7,800,000.00	* 8,520,000.00	* 39,520,000.00	* 125,600,000.00
	CUSTO	* 9,343,200.00	* 12,721,600.00	* 16,887,200.00	* 21,231,200.00	* 22,433,600.00	* 23,533,600.00	* 24,553,600.00	* 130,704,000.00
	MARGEM BRUTA	* 1,216,800.00	* 2,878,400.00	* 4,392,800.00	* 2,768,800.00	* 5,966,400.00	* 7,666,400.00	* 9,526,400.00	* 34,416,000.00	* 22,878,541.00
	DEPESAS DE MARKETING	* 93,600.00	* 306,720.00	* (4,556,300.00)	* (4,155,980.00)	* (831,196.00)
	DESPESAS DE P&D	* (3,328,130.00)	* (3,328,130.00)	* (665,626.00)
	DESPESAS DE VENDAS	* (3,574,710.00)	* (3,574,710.00)	* (714,942.00)
	DESPESAS ADMINISTRATIVAS	* (4,752,000.00)	* (4,752,000.00)	* (950,400.00)
	DESPESAS FINANCEIRAS	* (3,825,000.00)	* (3,825,000.00)	* (765,000.00)
	LUCRO ANTES DO IR	* 14,379,860.00	* 3,242,721.00
	IR (40%)	* 5,751,944.00	* (1,297,088.40)
	LUCRO LIQUIDO	* 8,627,916.00	* 1,945,632.60
	SL 2000	RECEB	CUSTO	DESPESAS
	CAIXA	* 1,121,450.00	* 135,397,006.00	* (130,704,000.00)	* (15,479,840.00)	* (9,665,384.00)
MEMÓRIA DE CÁLCULO
	PRODUTO	D	C	B	BB	A	AA	AAA	TOTAL
	PREÇO POR KG	* 8,800.00	* 19,500.00	* 26,600.00	* 30,000.00	* 35,500.00	* 39,000.00	* 42,600.00	CAIXA	RECEITA
	CUSTO UNITÁRIO (VARIÁVEL)	* 6,600.00	* 12,485.00	* 14,275.00	* 16,288.00	* 17,791.00	* 19,166.00	* 20,441.00	* 1,121,450.00	* (105,256,237.00)	* 182,980,000.00	* (182,980,000.00)	C	RECEITA	* (182,980,000.00)
	* 165,385,000.00	* (15,612,000.00)	D	CAIXA	* 165,385,000.00
	MARGEM CONTRIBUIÇÃO	* 2,200.00	* 7,015.00	* 12,325.00	* 13,712.00	* 17,709.00	* 19,834.00	* 22,159.00	* 9,368,462.00	* (3,328,130.00)	D	CTAS A REC	* 17,595,000.00
	* (3,574,710.00)
	CUSTO FIXO	* 3,319,500.00	* 4,100,500.00	* 4,100,500.00	* 4,100,500.00	* 4,100,500.00	* 4,100,500.00	* 4,100,500.00	* (4,752,000.00)	C	CAIXA	* (105,256,237.00)
	* (3,825,000.00)	0.0	D	ESTOQUE	* 105,256,237.00
	CAPACIDADE PRODUTIVA	* 1,600,000	* 1,800,000	* 1,600,000	* 1,000,000	* 6,000,000	* 0.27	* (487,331.00)
	0.0	* 39,039,504.00
	RECEITA	* 14,080,000.00	0.0	0.0	0.0	* 63,900,000.00	* 62,400,000.00	* 42,600,000.00	* 182,980,000.00
	Contas a receber 2001	* 3,520,000.00	0.0	0.0	0.0	* 5,325,000.00	* 5,200,000.00	* 3,550,000.00	* 17,595,000.00	Receb 2001	* 165,385,000.00
	CUSTO	* 13,880,000.00	0.0	0.0	0.0	* 36,124,200.00	* 34,766,400.00	* 24,542,000.00	* 109,312,600.00	CTAS A RECEBER	CPV	C	ESTOQUE	* (109,312,600.00)
	* 9,368,467.00	* (9,368,462.00)	* 109,312,600.00	-109,312,600.00	D	CPV	* 109,312,600.00
	MARGEM BRUTA	* 200,000.00	0.0	0.0	0.0	* 27,775,800.00	* 27,633,600.00	* 18,058,000.00	* 73,667,400.00	* 17,595,000.00
	C	CTAS A REC	* (9,368,462.00)
	DEPESAS DE MARKETING	* 5,112,000.00	* 6,240,000.00	* 4,260,000.00	* (15,612,000.00)	D	CAIXA	* 9,368,462.00
	DESPESAS DE P&D	* (3,328,130.00)
	DESPESAS DE VENDAS	* (3,574,710.00)	* 17,595,005.00	0.0	C	CAIXA	* (31,091,840.00)
	DESPESAS ADMINISTRATIVAS	* (4,752,000.00)	D	DESPESAS	* 31,091,840.00
	DESPESAS FINANCEIRAS	* (3,825,000.00)
	C	CAIXA	* (487,331.00)
	LUCRO ANTES DO IR	* 42,575,560.00	ESTOQUE	DESPESAS	D	CTAS A PAGAR	* 487,331.00
	* 2,907,963.00	* 15,612,000.00
* 15,612,000.00
	IR (40%)	* 17,030,224.00	* 1,148,400.00	* 3,328,130.00	* 3,328,130.00	29383.666666666668
	* 105,256,237.00	* (109,312,600.00)	* 3,574,710.00	* 3,574,710.00	KG Premium	$
	LUCRO LIQUIDO	* 25,545,336.00	* 4,752,000.00	* 4,752,000.00	156676	* 4,603,715,358.67
	* 3,825,000.00	* 3,825,000.00	144716	* 4,252,286,705.33
	CAIXA	movimento 2001	0.0	0.0	0.0	143520	* 4,217,143,840.00
	SLD 2000	RECEB	CUSTO	DESPESAS	SLD 2001
	* 1,121,450.00	* 174,266,131.00	* (105,256,237.00)	* (31,091,840.00)	* 39,039,504.00	CTAS A PAGAR	ARE
	* 487,331.00	* (487,331.00)	* 15,612,000.00	* (182,980,000.00)
	* 3,328,130.00	kg Marca prórpia	$
	* 3,574,710.00	10	150912	* 2,248,437,888.00
	* 4,752,000.00	11	139392	* 2,076,801,408.00
	* 3,825,000.00	12	138240	* 2,059,637,760.00
	0.0	* 109,312,600.00
	* 140,404,440.00	* (182,980,000.00)
	* (42,575,560.00)
Plan7