TRABALHO DE CONTABILIDADE GERENCIAL

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

Plan1
	FATURAMENTO 2011
	jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
	189,000.00	194,100.00	199,400.00	177,400.00	121,900.00	201,410.00	264,200.00	263,700.00	274,100.00	261,100.00	267,800.00	245,200.00
	
	CUSTO DA MERCADORIA
	jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
	103,005	105,784.50	108,673	96,683	66435.5	109,768.45	143,989.00	263,700.00	149.384,,50	142,299.50	142,951.00	133,634.00
	
	DESPESAS DEDUTIVEIS
	jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
	54,415.00	54,124.00	53,124.36	50,020.15	50,000.34	58,111.36	61,214.00	61,214.36	67,180.28	68,541.23	69,020.15	71,049.87
	
	CALCULO DO PIS - LUCRO REAL ( 1,65% )
	jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
	3,118.50	3,202.65	3,290.10	2,927.10	2,011.35	3,323.26	4,359.30	4,351.05	4,522.65	4,308.15	4,418.70	4,045.80
	
	CALCULO DO COFINS - LUCRO REAL ( 7,6% )
	jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
	14,364.00	14,751.60	15,154.40	13,482.40	9,264.40	15,307.16	20,079.20	20,041.20	20,831.60	19,843.60	20,352.80	18,635.20
	
	CALCULO DO IRPJ E CSLL ( 15% E 9% ) - LUCRO REAL
	jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
	189.00,00	194,100.00	199,400	177,400.00	121,900.00	201,410.00	264,200.00	263,700.00	274,100.00	261,100.00	267,800.00	245,200.00	RECEITA
	17,482.50	17,954.25	18,444.50	16,409.50	11,275.75	18,630.42	24,438.50	24,392.25	25,354.25	24,151.75	24,771.50	22,681.00	(-) IMPOSTOS
	103,005.00	105,784.50	108,673.00	96,683.00	66,435.50	109,768.45	143,989.00	143,716.50	149,384.50	142,299.50	145,951.00	133,634.00	(-) CUSTOS
	55,415.30	54,124.23	53,124.36	50,020.15	50,000.34	58,111.36	61,214.00	61,214.36	67,180.28	68,541.25	69,020.15	71,049.87	(-) DESPESAS
	13,092.20	16,237.02	19,158.14	14,287.35	-5,811.59	14,899.77	34,558.50	34,376.89	32,180.97	26,107.50	28,057.35	17,835.13	LUCRO
	1,963.83	2,435.55	2,873.72	2,143.10	871.73	2,234.96	5,189.77	5,156.53	4,827.14	3,916.12	4,208.60	2,675.26	IRPJ
													IRPJ ADIC
	1,178.29	1,461.33	1,724.23	1,285.86	523.04	1,340.97	3,113.86	3,093.92	2,896.28	2,349.67	2,525.16	1,605.16	CS
	
	CALCULO DO PIS - LUCRO PRESUMIDO ( 0,65% )
	jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
	1,228.50	1,261.65	1,296.10	1,153.10	792.35	1,309.16	1,717.30	1,714.05	1,781.65	1,697.15	1,740.70	1,593.80
	
	CALCULO DO COFINS - LUCRO PRESUMIDO ( 3% )
	jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
	5,670.00	5,823.00	5,982.00	5,322.00	3,657.00	6,042.30	7,926.00	7,911.00	8,223.00	7,833.00	8,034.00	7,356.00
	
	CALCULO DO IRPJ - LUCRO PRESUMIDO ( PRESUNÇÃO 8% E ALIQUOTA DE 15%)
	jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
	2,268.00	$2,329.20	2,392.80	2,128.80	1,462.80	2,416.92	3,170.40	3,164.40	3,289.20	3,133.20	3,213.60	2,942.40
	
	CALCULO DO CS - LUCRO PRESUMIDO ( PRESUNÇÃO DE 12% E ALIQUOTA DE 9%)
	jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
	
	
	CALCULO DO SIMPLES
	jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
Plan2
		FATURAMENTO 2011
		jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
		189,000.00	194,100.00	199,400.00	177,400.00	121,900.00	201,410.00	264,200.00	263,700.00	274,100.00	261,100.00	267,800.00	245,200.00
	
		CUSTO DA MERCADORIA
		jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
		103,005	105,784.50	108,673	96,683	66435.5	109,768.45	143,989.00	263,700.00	149.384,,50	142,299.50	142,951.00	133,634.00
	
		DESPESAS DEDUTIVEIS
		jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
		54,415.00	54,124.00	53,124.36	50,020.15	50,000.34	58,111.36	61,214.00	61,214.36	67,180.28	68,541.23	69,020.15	71,049.87
	
		CALCULO DO PIS - LUCRO REAL ( 1,65% )
		jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
		3,118.50	3,202.65	3,290.10	2,927.10	2,011.35	3,323.26	4,359.30	4,351.05	4,522.65	4,308.15	4,418.70	4,045.80
	
		CALCULO DO COFINS - LUCRO REAL ( 7,6% )
		jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
		14,364.00	14,751.60	15,154.40	13,482.40	9,264.40	15,307.16	20,079.20	20,041.20	20,831.60	19,843.60	20,352.80	18,635.20
	
		CALCULO DO IRPJ E CSLL ( 15% E 9% ) - LUCRO REAL
		jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
	RECEITA	189.00,00	194,100.00	199,400	177,400.00	121,900.00	201,410.00	264,200.00	263,700.00	274,100.00	261,100.00	267,800.00	245,200.00
	(-) IMPOSTOS	17,482.50	17,954.25	18,444.50	16,409.50	11,275.75	18,630.42	24,438.50	24,392.25	25,354.25	24,151.75	24,771.50	22,681.00
	(-) CUSTOS	103,005.00	105,784.50	108,673.00	96,683.00	66,435.50	109,768.45	143,989.00	143,716.50	149,384.50	142,299.50	145,951.00	133,634.00
	(-) DESPESAS	55,415.30	54,124.23	53,124.36	50,020.15	50,000.34	58,111.36	61,214.00	61,214.36	67,180.28	68,541.25	69,020.15	71,049.87
	LUCRO	13,092.20	16,237.02	19,158.14	14,287.35	-5,811.59	14,899.77	34,558.50	34,376.89	32,180.97	26,107.50	28,057.35	17,835.13
	IRPJ	1,963.83	2,435.55	2,873.72	2,143.10	871.73	2,234.96	5,189.77	5,156.53	4,827.14	3,916.12	4,208.60	2,675.26
	IRPJ ADIC
	CS	1,178.29	1,461.33	1,724.23	1,285.86	523.04	1,340.97	3,113.86	3,093.92	2,896.28	2,349.67	2,525.16	1,605.16
	
		CALCULO DO PIS - LUCRO PRESUMIDO ( 0,65% )
		jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
		1,228.50	1,261.65	1,296.10	1,153.10	792.35	1,309.16	1,717.30	1,714.05	1,781.65	1,697.15	1,740.70	1,593.80
	
		CALCULO DO COFINS - LUCRO PRESUMIDO ( 3% )
		jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
		5,670.00	5,823.00	5,982.00	5,322.00	3,657.00	6,042.30	7,926.00	7,911.00	8,223.00	7,833.00	8,034.00	7,356.00
	
		CALCULO DO IRPJ - LUCRO PRESUMIDO ( PRESUNÇÃO 8% E ALIQUOTA DE 15%)
		jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
		2,268.00	$2,329.20	2,392.80	2,128.80	1,462.80	2,416.92	3,170.40	3,164.40	3,289.20	3,133.20	3,213.60	2,942.40
	
		CALCULO DO CS - LUCRO PRESUMIDO ( PRESUNÇÃO DE 12% E ALIQUOTA DE 9%)
		jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
		2,041.20	2,096.28	2,153.52	1,915.92	1,316.52	2,175.22	2,853.36	2,847.96	2,960.28	2,819.88	2,892.24	2,648.16
	
		CALCULO DO SIMPLES
		jan	fev	mar	abr	mai	jun	jul	ago	set	out	nov	dez
		21,753.90	22,340.91	22,950.94	20,418.74	14,030.69	23,182.29	30,409.42	30,351.87	31,548.91	30,052.61	30,823.78	28,222.52
Plan3