Embed Size (px)
DESCRIPTION
PLANILHA DE CUSTOS DE LOTEAMENTOS
Citation preview
CUSTO LOTEAMENTO
Página 1
CLIENTE: MODELO
ESTOQUE INICIAL............................. 250,000.00 JANEIRO
COMPLEMENTO MÊS........................ 100,000.00
ESTOQUE TOTAL............................ 350,000.00
BAIXA CUSTO ANTERIOR............... -
SUB-TOTAL.................................... 350,000.00
CUSTO DO MÊS............................ 4,375.00 TOTAL CUSTO ACUMULADO 4,375.00
ESTOQUE FINAL............................ 345,625.00
DATA LOTE QUADRA M2 TERRENO COMPLEMENTO M2 TOTAL %PARTIC CUSTO PDT SD%PART VLR.CONTR SD.ANTER
1 10 250.00 250.00 5.00% 17,500.00 5.00% 200,000.00 200,000.00
2 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
3 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
4 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
5 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
6 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
7 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
8 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
9 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
10 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
11 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
12 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
13 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
14 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
15 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
16 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
17 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
18 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
19 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
20 10 250.00 250.00 5.00% 17,500.00 5.00% 1.00 1.00
CUSTO M2........ 50.00 5,000.00 - 5,000.00 100.00% 350,000.00 100.00% 200,019.00 200,019.00
CLIENTE: MODELO
ESTOQUE INICIAL............................. 250,000.00 FEVEREIRO
COMPLEMENTO ANTERIOR.............. 100,000.00
COMPLEMENTO DO MES................................ 120,000.00 220,000.00
ESTOQUE TOTAL............................ 470,000.00
BAIXA CUSTO ANTERIOR............... 5,875.00 1,500.00 DIF. BAIXA CUSTO MÊS ANTERIOR
SUB-TOTAL.................................... 464,125.00
CUSTO DO MÊS............................ 7,050.00 TOTAL CUSTO ACUMULADO 12,925.00
ESTOQUE FINAL............................ 457,075.00
DATA LOTE QUADRA M2 TERRENO COMPLEMENTO M2 TOTAL %PARTIC CUSTO PDT SD%PART VLR.CONTR SD.ANTER
12/30/1899 1 10 250.00 0 - 250.00 5.00% 17,625.00 3.80% 200,000.00 150,000.00
CUSTO LOTEAMENTO
Página 2
12/30/1899 2 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 3 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 4 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 5 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 6 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 7 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 8 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 9 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 10 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 11 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 12 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 13 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 14 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 15 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 16 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 17 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 18 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 19 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
12/30/1899 20 10 250.00 0 - 250.00 5.00% 23,500.00 5.06% 1.00 1.00
5,000.00 5,000.00 100.00% 464,125.00 100.00% 200,019.00 150,019.00
CLIENTE: MODELO
ESTOQUE INICIAL............................. 250,000.00 MARÇO
COMPLEMENTO ANTERIOR.............. 220,000.00
COMPLEMENTO DO MES................................ 135,000.00 355,000.00
ESTOQUE TOTAL............................ 605,000.00
BAIXA CUSTO ANTERIOR............... 16,637.50 3,712.50 DIF. BAIXA CUSTO MÊS ANTERIOR
SUB-TOTAL.................................... 588,362.50
CUSTO DO MÊS............................ 3,025.00 TOTAL CUSTO ACUMULADO 19,662.50
ESTOQUE FINAL............................ 585,337.50
DATA LOTE QUADRA M2 TERRENO COMPLEMENTO M2 TOTAL %PARTIC CUSTO PDT SD%PART VLR.CONTR SD.ANTER
12/30/1899 1 10 250.00 0 - 250.00 5.00% 13,612.50 2.93% 200,000.00 90,000.00
12/30/1899 2 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 3 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 4 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 5 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 6 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 7 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 8 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 9 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 10 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 11 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
CUSTO LOTEAMENTO
Página 3
12/30/1899 12 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 13 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 14 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 15 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 16 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 17 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 18 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 19 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
12/30/1899 20 10 250.00 0 - 250.00 5.00% 30,250.00 6.52% 1.00 1.00
5,000.00 5,000.00 100.00% 588,362.50 126.77% 200,019.00 90,019.00
CLIENTE: MODELO
ESTOQUE INICIAL............................. 250,000.00 ABRIL
COMPLEMENTO ANTERIOR.............. 355,000.00
COMPLEMENTO DO MES................................ 150,000.00 505,000.00
ESTOQUE TOTAL............................ 755,000.00
BAIXA CUSTO ANTERIOR............... 24,537.50 4,875.00 DIF. BAIXA CUSTO MÊS ANTERIOR
SUB-TOTAL.................................... 730,462.50
CUSTO DO MÊS............................ - TOTAL CUSTO ACUMULADO 24,537.50
ESTOQUE FINAL............................ 730,462.50
DATA LOTE QUADRA M2 TERRENO COMPLEMENTO M2 TOTAL %PARTIC CUSTO PDT SD%PART VLR.CONTR SD.ANTER
12/30/1899 1 10 250.00 0 - 250.00 5.00% 13,212.50 1.81% 200,000.00 70,000.00
12/30/1899 2 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 3 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 4 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 5 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 6 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 7 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 8 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 9 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 10 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 11 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
26.04.2010 12 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 13 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 14 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 15 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 16 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 17 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 18 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 19 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
12/30/1899 20 10 250.00 0 - 250.00 5.00% 37,750.00 5.17% 1.00 1.00
5,000.00 5,000.00 100.00% 730,462.50 100.00% 200,019.00 70,019.00
CUSTO LOTEAMENTO
Página 4
CLIENTE: MODELO
ESTOQUE INICIAL............................. 250,000.00 MAIO
COMPLEMENTO ANTERIOR.............. 505,000.00
COMPLEMENTO DO MES................................ 200,000.00 705,000.00
ESTOQUE TOTAL............................ 955,000.00
BAIXA CUSTO ANTERIOR............... 31,037.50 6,500.00 DIF. BAIXA CUSTO MÊS ANTERIOR
SUB-TOTAL.................................... 923,962.50
CUSTO DO MÊS............................ - TOTAL CUSTO ACUMULADO 31,037.50
ESTOQUE FINAL............................ 923,962.50
DATA LOTE QUADRA M2 TERRENO COMPLEMENTO M2 TOTAL %PARTIC CUSTO PDT SD%PART VLR.CONTR SD.ANTER
12/30/1899 1 10 250.00 0 - 250.00 5.00% 16,712.50 1.81% 200,000.00 70,000.00
12/30/1899 2 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 3 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 4 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 5 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 6 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 7 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 8 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 9 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 10 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 11 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12.05.08 12 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 13 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 14 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 15 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 16 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 17 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 18 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 19 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
12/30/1899 20 10 250.00 0 - 250.00 5.00% 47,750.00 5.17% 1.00 1.00
5,000.00 5,000.00 100.00% 923,962.50 100.00% 200,019.00 70,019.00
CLIENTE: MODELO
ESTOQUE INICIAL............................. 250,000.00 JUNHO
COMPLEMENTO ANTERIOR.............. 705,000.00
COMPLEMENTO DO MES................................ 180,000.00 885,000.00
ESTOQUE TOTAL............................ 1,135,000.00
BAIXA CUSTO ANTERIOR............... 36,887.50 5,850.00 DIF. BAIXA CUSTO MÊS ANTERIOR
SUB-TOTAL.................................... 1,098,112.50
CUSTO DO MÊS............................ - TOTAL CUSTO ACUMULADO 36,887.50
ESTOQUE FINAL............................ 1,098,112.50
DATA LOTE QUADRA M2 TERRENO COMPLEMENTO M2 TOTAL %PARTIC CUSTO PDT SD%PART VLR.CONTR SD.ANTER
CUSTO LOTEAMENTO
Página 5
12/30/1899 1 10 250.00 0 - 250.00 5.00% 19,862.50 1.81% 200,000.00 70,000.00
12/30/1899 2 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 3 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 4 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 5 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 6 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 7 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 8 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 9 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 10 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 11 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12.05.08 12 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 13 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 14 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 15 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 16 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 17 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 18 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 19 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
12/30/1899 20 10 250.00 0 - 250.00 5.00% 56,750.00 5.17% 1.00 1.00
5,000.00 5,000.00 100.00% 1,098,112.50 100.00% 200,019.00 70,019.00
CLIENTE: MODELO
ESTOQUE INICIAL............................. 250,000.00 JULHO
COMPLEMENTO ANTERIOR.............. 885,000.00
COMPLEMENTO DO MES................................ 100,000.00 985,000.00
ESTOQUE TOTAL............................ 1,235,000.00
BAIXA CUSTO ANTERIOR............... 40,137.50 3,250.00 DIF. BAIXA CUSTO MÊS ANTERIOR
SUB-TOTAL.................................... 1,194,862.50
CUSTO DO MÊS............................ - TOTAL CUSTO ACUMULADO 40,137.50
ESTOQUE FINAL............................ 1,194,862.50
DATA LOTE QUADRA M2 TERRENO COMPLEMENTO M2 TOTAL %PARTIC CUSTO PDT SD%PART VLR.CONTR SD.ANTER
12/30/1899 1 10 250.00 0 - 250.00 5.00% 21,612.50 1.81% 200,000.00 70,000.00
12/30/1899 2 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 3 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 4 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 5 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 6 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 7 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 8 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 9 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 10 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
CUSTO LOTEAMENTO
Página 6
12/30/1899 11 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12.05.08 12 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 13 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 14 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 15 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 16 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 17 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 18 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 19 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 20 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
5,000.00 5,000.00 100.00% 1,194,862.50 100.00% 200,019.00 70,019.00
CLIENTE: MODELO
ESTOQUE INICIAL............................. 250,000.00 AGOSTO
COMPLEMENTO ANTERIOR.............. 985,000.00
COMPLEMENTO DO MES................................ - 985,000.00
ESTOQUE TOTAL............................ 1,235,000.00
BAIXA CUSTO ANTERIOR............... 40,137.50 0.00 DIF. BAIXA CUSTO MÊS ANTERIOR
SUB-TOTAL.................................... 1,194,862.50
CUSTO DO MÊS............................ - TOTAL CUSTO ACUMULADO 40,137.50
ESTOQUE FINAL............................ 1,194,862.50
DATA LOTE QUADRA M2 TERRENO COMPLEMENTO M2 TOTAL %PARTIC CUSTO PDT SD%PART VLR.CONTR SD.ANTER
12/30/1899 1 10 250.00 0 - 250.00 5.00% 21,612.50 1.81% 200,000.00 70,000.00
12/30/1899 2 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 3 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 4 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 5 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 6 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 7 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 8 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 9 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 10 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 11 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12.05.08 12 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 13 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 14 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 15 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 16 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 17 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 18 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 19 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 20 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
CUSTO LOTEAMENTO
Página 7
5,000.00 5,000.00 100.00% 1,194,862.50 100.00% 200,019.00 70,019.00
CLIENTE: MODELO
ESTOQUE INICIAL............................. 250,000.00 SETEMBRO
COMPLEMENTO ANTERIOR.............. 985,000.00
COMPLEMENTO DO MES................................ - 985,000.00
ESTOQUE TOTAL............................ 1,235,000.00
BAIXA CUSTO ANTERIOR............... 40,137.50 0.00 DIF. BAIXA CUSTO MÊS ANTERIOR
SUB-TOTAL.................................... 1,194,862.50
CUSTO DO MÊS............................ - TOTAL CUSTO ACUMULADO 40,137.50
ESTOQUE FINAL............................ 1,194,862.50
DATA LOTE QUADRA M2 TERRENO COMPLEMENTO M2 TOTAL %PARTIC CUSTO PDT SD%PART VLR.CONTR SD.ANTER
12/30/1899 1 10 250.00 0 - 250.00 5.00% 21,612.50 1.81% 200,000.00 70,000.00
12/30/1899 2 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 3 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 4 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 5 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 6 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 7 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 8 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 9 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 10 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 11 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12.05.08 12 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 13 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 14 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 15 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 16 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 17 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 18 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 19 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 20 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
5,000.00 5,000.00 100.00% 1,194,862.50 100.00% 200,019.00 70,019.00
CLIENTE: MODELO
ESTOQUE INICIAL............................. 250,000.00 OUTUBRO
COMPLEMENTO ANTERIOR.............. 985,000.00
COMPLEMENTO DO MES................................ - 985,000.00
ESTOQUE TOTAL............................ 1,235,000.00
BAIXA CUSTO ANTERIOR............... 40,137.50 0.00 DIF. BAIXA CUSTO MÊS ANTERIOR
SUB-TOTAL.................................... 1,194,862.50
CUSTO DO MÊS............................ - TOTAL CUSTO ACUMULADO 40,137.50
ESTOQUE FINAL............................ 1,194,862.50
CUSTO LOTEAMENTO
Página 8
DATA LOTE QUADRA M2 TERRENO COMPLEMENTO M2 TOTAL %PARTIC CUSTO PDT SD%PART VLR.CONTR SD.ANTER
12/30/1899 1 10 250.00 0 - 250.00 5.00% 21,612.50 1.81% 200,000.00 70,000.00
12/30/1899 2 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 3 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 4 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 5 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 6 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 7 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 8 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 9 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 10 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 11 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12.05.08 12 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 13 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 14 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 15 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 16 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 17 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 18 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 19 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 20 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
5,000.00 5,000.00 100.00% 1,194,862.50 100.00% 200,019.00 70,019.00
CLIENTE: MODELO
ESTOQUE INICIAL............................. 250,000.00 NOVEMBRO
COMPLEMENTO ANTERIOR.............. 985,000.00
COMPLEMENTO DO MES................................ - 985,000.00
ESTOQUE TOTAL............................ 1,235,000.00
BAIXA CUSTO ANTERIOR............... 40,137.50 0.00 DIF. BAIXA CUSTO MÊS ANTERIOR
SUB-TOTAL.................................... 1,194,862.50
CUSTO DO MÊS............................ - TOTAL CUSTO ACUMULADO 40,137.50
ESTOQUE FINAL............................ 1,194,862.50
DATA LOTE QUADRA M2 TERRENO COMPLEMENTO M2 TOTAL %PARTIC CUSTO PDT SD%PART VLR.CONTR SD.ANTER
12/30/1899 1 10 250.00 0 - 250.00 5.00% 21,612.50 1.81% 200,000.00 70,000.00
12/30/1899 2 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 3 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 4 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 5 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 6 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 7 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 8 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 9 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
CUSTO LOTEAMENTO
Página 9
12/30/1899 10 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 11 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12.05.08 12 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 13 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 14 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 15 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 16 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
17 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 18 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 19 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 20 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
5,000.00 5,000.00 100.00% 1,194,862.50 100.00% 200,019.00 70,019.00
CLIENTE: MODELO
ESTOQUE INICIAL............................. 250,000.00 DEZEMBRO
COMPLEMENTO ANTERIOR.............. 985,000.00
COMPLEMENTO DO MES................................ - 985,000.00
ESTOQUE TOTAL............................ 1,235,000.00
BAIXA CUSTO ANTERIOR............... 40,137.50 0.00 DIF. BAIXA CUSTO MÊS ANTERIOR
SUB-TOTAL.................................... 1,194,862.50
CUSTO DO MÊS............................ - TOTAL CUSTO ACUMULADO 40,137.50
ESTOQUE FINAL............................ 1,194,862.50
DATA LOTE QUADRA M2 TERRENO COMPLEMENTO M2 TOTAL %PARTIC CUSTO PDT SD%PART VLR.CONTR SD.ANTER
12/30/1899 1 10 250.00 0 - 250.00 5.00% 21,612.50 1.81% 200,000.00 70,000.00
12/30/1899 2 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 3 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 4 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 5 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 6 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 7 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 8 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 9 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 10 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 11 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12.05.08 12 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 13 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 14 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 15 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 16 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
17 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 18 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
12/30/1899 19 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
CUSTO LOTEAMENTO
Página 10
12/30/1899 20 10 250.00 0 - 250.00 5.00% 61,750.00 5.17% 1.00 1.00
5,000.00 5,000.00 100.00% 1,194,862.50 100.00% 200,019.00 70,019.00
CLIENTE MODELO
CONTROLE DE RECEBIMENTO
SD.ANTERIOR LOTE QUADRA JAN FEV MAR ABR MAI JUN
200,000.00 1 10 50,000.00 60,000.00 20,000.00
1.00 2 10
1.00 3 10
1.00 4 10
1.00 5 10
1.00 6 10
1.00 7 10
1.00 8 10
1.00 9 10
1.00 10 10
1.00 11 10
1.00 12 10
1.00 13 10
1.00 14 10
1.00 15 10
1.00 16 10
1.00 17 10
1.00 18 10
1.00 19 10
1.00 20 10
200,019.00 TOTAL 50,000.00 60,000.00 20,000.00 - - -
obs: os lançamento de receita conforme as parcelas recebidas e o valor principal conforme o contrato(sem os acréscimo)
CLIENTE MODELO
CONTROLE DE CUSTO
LOTE QUADRA JAN FEV MAR ABR MAI JUN
1 10 4,375.00 7,050.00 3,025.00 - - -
2 10 - - - - - -
3 10 - - - - - -
4 10 - - - - - -
5 10 - - - - - -
6 10 - - - - - -
7 10 - - - - - -
8 10 - - - - - -
9 10 - - - - - -
10 10 - - - - - -
CUSTO LOTEAMENTO
Página 11
11 10 - - - - - -
12 10 - - - - - -
13 10 - - - - - -
14 10 - - - - - -
15 10 - - - - - -
16 10 - - - - - -
17 10 - - - - - -
18 10 - - - - - -
19 10 - - - - - -
20 10 - - - - - -
TOTAL 4,375.00 7,050.00 3,025.00 - - -
CUSTO UNID.RECEBIDAS - 5,875.00 16,637.50 24,537.50 31,037.50 36,887.50
CUSTO ACUMULADO 4,375.00 12,925.00 19,662.50 24,537.50 31,037.50 36,887.50
CUSTO DO MÊS 4,375.00 8,550.00 6,737.50 4,875.00 6,500.00 5,850.00
0.30 48.79% 20.93% 0.00% 0.00% 0.00%
- custo a baixar - - - - - -
12.00 total baixa custo 4,375.00 7,050.00 3,025.00 - - -
-
CLIENTE: MODELO
DEMONSTRATIVO DE RESULTADO
LOTE QUADRA JAN FEV MAR ABR MAI JUN
1 10 45,625.00 52,950.00 16,975.00 - - -
2 10 - - - - - -
3 10 - - - - - -
4 10 - - - - - -
5 10 - - - - - -
6 10 - - - - - -
7 10 - - - - - -
8 10 - - - - - -
9 10 - - - - - -
10 10 - - - - - -
11 10 - - - - - -
12 10 - - - - - -
13 10 - - - - - -
14 10 - - - - - -
15 10 - - - - - -
16 10 - - - - - -
CUSTO LOTEAMENTO
Página 12
17 10 - - - - - -
18 10 - - - - - -
19 10 - - - - - -
20 10 - - - - - -
TOTAL 45,625.00 52,950.00 16,975.00 - - -
DEMONSTRATIVO CALCULO DE TRIBUTOS
HISTORICO TAXA JAN FEV MAR ABR MAI JUN
RECEBIMENTOS....................... 50,000.00 60,000.00 20,000.00 - - -
VENDAS CANCELADAS............
SUB-TOTAL............................... 50,000.00 60,000.00 20,000.00 - - -
PIS S/FATURAMENTO 0.65% 325.00 390.00 130.00 - - -
COFINS...................... 3.00% 1,500.00 1,800.00 600.00 - - -
I.R.P.J.- ESTIMATIVA.... - - - - - -
CONTRIB.SOCIAL....... - - - - - -
TOTAL..................................... 1,825.00 2,190.00 730.00 - - -
CUSTO LOTEAMENTO
Página 13
RECEBIM SD.PENDEN %SD.ANT %RECEB. %SD.PEND %CUSTO CUSTO MÊS CUSTO PDTE CUSTO ACUMULADOR C.EX.FUTURO ESTOQUE
50,000.00 150,000.00 100.00% 25.00% 75.00% 25.00% 4,375.00 13,125.00 4,375.00 13,125.00 -
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 17,500.00 - - 17,500.00
50,000.00 150,019.00 2000.00% 25.00% 1975.00% 25.00% 4,375.00 345,625.00 4,375.00 13,125.00 332,500.00
RECEBIM SD.PENDEN %SD.ANT %RECEB. %SD.PEND %CUSTO CUSTO MÊS CUSTO PDTE CUSTO ACUMULADOR C.EX.FUTURO ESTOQUE
60,000.00 90,000.00 75.00% 30.00% 45.00% 40.00% 7,050.00 10,575.00 12,925.00 10,575.00 -
CUSTO LOTEAMENTO
Página 14
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 23,500.00 - - 23,500.00
60,000.00 90,019.00 1975.00% 30.00% 1945.00% 40.00% 7,050.00 457,075.00 12,925.00 10,575.00 446,500.00
RECEBIM SD.PENDEN %SD.ANT %RECEB. %SD.PEND %CUSTO CUSTO MÊS CUSTO PDTE CUSTO ACUMULADOR C.EX.FUTURO ESTOQUE
20,000.00 70,000.00 45.00% 10.00% 35.00% 22.22% 3,025.00 10,587.50 19,662.50 10,587.50 -
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
CUSTO LOTEAMENTO
Página 15
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 30,250.00 - - 30,250.00
20,000.00 70,019.00 1945.00% 10.00% 1935.00% 22.22% 3,025.00 585,337.50 19,662.50 10,587.50 574,750.00
RECEBIM SD.PENDEN %SD.ANT %RECEB. %SD.PEND %CUSTO CUSTO MÊS CUSTO PDTE CUSTO ACUMULADOR C.EX.FUTURO ESTOQUE
- 70,000.00 35.00% 0.00% 35.00% 0.00% - 13,212.50 24,537.50 13,212.50 -
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 37,750.00 - - 37,750.00
- 70,019.00 1935.00% 0.00% 1935.00% 0.00% - 730,462.50 24,537.50 13,212.50 717,250.00
CUSTO LOTEAMENTO
Página 16
RECEBIM SD.PENDEN %SD.ANT %RECEB. %SD.PEND %CUSTO CUSTO MÊS CUSTO PDTE CUSTO ACUMULADOR C.EX.FUTURO ESTOQUE
- 70,000.00 35.00% 0.00% 35.00% 0.00% - 16,712.50 31,037.50 16,712.50 -
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 47,750.00 - - 47,750.00
- 70,019.00 1935.00% 0.00% 1935.00% 0.00% - 923,962.50 31,037.50 16,712.50 907,250.00
RECEBIM SD.PENDEN %SD.ANT %RECEB. %SD.PEND %CUSTO CUSTO MÊS CUSTO PDTE CUSTO ACUMULADOR C.EX.FUTURO ESTOQUE
CUSTO LOTEAMENTO
Página 17
- 70,000.00 35.00% 0.00% 35.00% 0.00% - 19,862.50 36,887.50 19,862.50 -
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 56,750.00 - - 56,750.00
- 70,019.00 1935.00% 0.00% 1935.00% 0.00 - 1,098,112.50 36,887.50 19,862.50 1,078,250.00
RECEBIM SD.PENDEN %SD.ANT %RECEB. %SD.PEND %CUSTO CUSTO MÊS CUSTO PDTE CUSTO ACUMULADOR C.EX.FUTURO ESTOQUE
- 70,000.00 35.00% 0.00% 35.00% 0.00% - 21,612.50 40,137.50 21,612.50 -
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
CUSTO LOTEAMENTO
Página 18
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 70,019.00 1935.00% 0.00% 1935.00% 0.00% - 1,194,862.50 40,137.50 21,612.50 1,173,250.00
RECEBIM SD.PENDEN %SD.ANT %RECEB. %SD.PEND %CUSTO CUSTO MÊS CUSTO PDTE CUSTO ACUMULADOR C.EX.FUTURO ESTOQUE
- 70,000.00 35.00% 0.00% 35.00% 0.00% - 21,612.50 40,137.50 21,612.50 -
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
CUSTO LOTEAMENTO
Página 19
- 70,019.00 1935.00% 0.00% 1935.00% 0.00% - 1,194,862.50 40,137.50 21,612.50 1,173,250.00
RECEBIM SD.PENDEN %SD.ANT %RECEB. %SD.PEND %CUSTO CUSTO MÊS CUSTO PDTE CUSTO ACUMULADOR C.EX.FUTURO ESTOQUE
- 70,000.00 35.00% 0.00% 35.00% 0.00% - 21,612.50 40,137.50 21,612.50 -
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 70,019.00 1935.00% 0.00% 1935.00% 0.00% - 1,194,862.50 40,137.50 21,612.50 1,173,250.00
CUSTO LOTEAMENTO
Página 20
RECEBIM SD.PENDEN %SD.ANT %RECEB. %SD.PEND %CUSTO CUSTO MÊS CUSTO PDTE CUSTO ACUMULADOR C.EX.FUTURO ESTOQUE
- 70,000.00 35.00% 0.00% 35.00% 0.00% - 21,612.50 40,137.50 21,612.50 -
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 70,019.00 1935.00% 0.00% 1935.00% 0.00% - 1,194,862.50 40,137.50 21,612.50 1,173,250.00
RECEBIM SD.PENDEN %SD.ANT %RECEB. %SD.PEND %CUSTO CUSTO MÊS CUSTO PDTE CUSTO ACUMULADOR C.EX.FUTURO ESTOQUE
- 70,000.00 35.00% 0.00% 35.00% 0.00% - 21,612.50 40,137.50 21,612.50 -
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
CUSTO LOTEAMENTO
Página 21
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 70,019.00 1935.00% 0.00% 1935.00% 0.00% - 1,194,862.50 40,137.50 21,612.50 1,173,250.00
RECEBIM SD.PENDEN %SD.ANT %RECEB. %SD.PEND %CUSTO CUSTO MÊS CUSTO PDTE CUSTO ACUMULADOR C.EX.FUTURO ESTOQUE
- 70,000.00 35.00% 0.00% 35.00% 0.00% - 21,612.50 40,137.50 21,612.50 -
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
CUSTO LOTEAMENTO
Página 22
- 1.00 100.00% 0.00% 100.00% 0.00% - 61,750.00 - - 61,750.00
- 70,019.00 1935.00% 0.00% 1935.00% 0.00% - 1,194,862.50 40,137.50 21,612.50 1,173,250.00
planilha ok
JUL AGO SET OUT NOV DEZ TOTAL SD . FINAL
130,000.00 70,000.00
- 1.00
- 1.00
- 1.00
- 1.00
- 1.00
- 1.00
- 1.00
- 1.00
- 1.00
- 1.00
- 1.00
- 1.00
- 1.00
- 1.00
- 1.00
- 1.00
- 1.00
- 1.00
- 1.00
- - - - - - 130,000.00 70,019.00
JUL AGO SET OUT NOV DEZ TOTAL
- - - - - - 14,450.00
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
CUSTO LOTEAMENTO
Página 23
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - 14,450.00
40,137.50 40,137.50 40,137.50 40,137.50 40,137.50 ###
40,137.50 40,137.50 40,137.50 40,137.50 40,137.50 ###
3,250.00 - - - - -
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% total 100.00%
- - - - - - -
- - - - - - 14,450.00 11.12%
JUL AGO SET OUT NOV DEZ TOTAL
- - - - - - 115,550.00
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
CUSTO LOTEAMENTO
Página 24
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - 115,550.00
JULH AGO SETE OUT NOV DEZ TOTAL
- - - - - - 130,000.00
-
- - - - - - 130,000.00
- - - - - - 845.00
- - - - - - 3,900.00
- - - - - - -
- - - - - - -
- - - - - - 4,745.00
PLANILHA CUSTO ORÇADO-REALIZADO
Página 25
LOTEAMENTO
DEMONSTRATIVO DA CONTA CUSTO ORÇADO 2,500,000.00
2,500,000.00
CUSTO ORÇADO 2,500,000.00 SALDO DE PENDENCIA
COMPLEMENTO ORÇADO SALDO CUSTO ANO CUSTO/MÊS CUSTO ACUM. %CUSTO SD.C.PENDTE. %PDTE.
2,500,000.00 Dec-12 250,000.00 250,000.00 10.0000 2,250,000.00 90.00
2,500,000.00 Jan-13 100,000.00 350,000.00 14.0000 2,150,000.00 86.00
2,500,000.00 Feb-13 120,000.00 470,000.00 18.8000 2,030,000.00 81.20
2,500,000.00 Mar-13 135,000.00 605,000.00 24.2000 1,895,000.00 75.80
2,500,000.00 Apr-13 150,000.00 755,000.00 30.2000 1,745,000.00 69.80
2,500,000.00 May-13 200,000.00 955,000.00 38.2000 1,545,000.00 61.80
2,500,000.00 Jun-13 180,000.00 1,135,000.00 45.4000 1,365,000.00 54.60
2,500,000.00 Jul-13 100,000.00 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Aug-13 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Sep-13 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Oct-13 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Nov-13 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Dec-13 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Jan-14 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Feb-14 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Mar-14 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Apr-14 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 May-14 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Jun-14 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Jul-14 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Aug-14 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Sep-14 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Oct-14 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Nov-14 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Dec-14 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Jan-15 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Feb-15 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Mar-15 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Apr-15 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 May-15 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Jun-15 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Jul-15 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Aug-15 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Sep-15 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Oct-15 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Nov-15 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Dec-15 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Jan-16 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Feb-16 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Mar-16 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Apr-16 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 May-16 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Jun-16 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Jul-16 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Aug-16 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Sep-16 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Oct-16 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Nov-16 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Dec-16 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Jan-17 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Feb-17 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Mar-17 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Apr-17 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 May-17 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Jun-17 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Jul-17 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Aug-17 1,235,000.00 49.4000 1,265,000.00 50.60
PLANILHA CUSTO ORÇADO-REALIZADO
Página 26
2,500,000.00 Sep-17 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Oct-17 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Nov-17 1,235,000.00 49.4000 1,265,000.00 50.60
2,500,000.00 Dec-17 1,235,000.00 49.4000 1,265,000.00 50.60
TOTAL M2................... 5,000.00
CUSTO M2.................... 500.00
EXERCICIO 2013 985,000.00
EXERCICIO 2014 -
EXERCICIO 2015 -
EXERCICIO 2016 -
EXERCICIO 2017 -
TOTAL............... 985,000.00
TERRENO
TOTAL GERAL. 985,000.00
CUSTO M2........ 197.00
PLANILHA CUSTO ORÇADO-REALIZADO
Página 27
obs. Efetuar o lançamento dos valores acumulados das despesas pelo centro de custo conforme o mês
PLANILHA CUSTO ORÇADO-REALIZADO
Página 28
