4.2.3. HOJA DE CALCULO MAGDALENA (Corregido)
4.2.3. HOJA DE CALCULO MAGDALENA (Corregido)
4.2.3. HOJA DE CALCULO MAGDALENA (Corregido)
OBRA: CREACION DE PISTAS Y VEREDAS EN EL PP. JJ. MAGDALENA NUEVA, DISTRITO DE CHIMBOTE, PROVINCIA DE SANTA – ANCASH
MONTO DE CONTRATO ORIGINAL S/. 4,505,075.18 Inc IGV S/IGV : S/. 3,817,860.32
MONTO DE REDUCCION DE OBRA S/. 135,471.81 Inc IGV S/IGV : S/. 114,806.62
MONTO EJECUTADO S/. 4,369,603.37 Inc IGV S/IGV : S/. 3,703,053.70
II.- ADELANTOS
2.1 OTORGADO
2.1.1 Adelanto Directo en Efectivo S/IGV 381,786.03
2.1.2 Adelanto de Materiales S/IGV 763,572.06
2.2 AMORTIZADO
2.2.1 Del Adelanto Directo en Efectivo 381,786.03
2.2.2 Del Adelanto de Materiales 763,572.06
SUB TOTAL 1,145,358.09 1,145,358.09
2.2 PAGADO
2.2.1 VALORIZACIONES NETAS PAGADAS 2,557,695.62
SUB TOTAL 2,697,822.61 2,557,695.62
RESUMEN DE SALDOS
EN CARGO DEL A FAVOR DEL
CONTRATISTA CONTRATISTA
DEL CONTRATO PRINCIPAL INC. I.G.V. 3,183,430.68 (1) 3,018,080.83 (2)
SON: CIENTO SESENTA Y CINCO MIL TRESCIENTOS CUARENTA Y NUEVE CON 84/100 SOLES
RESUMEN DE VALORIZACIONES
OBRA “CREACION DE PISTAS Y VEREDAS EN EL PP. JJ. MAGDALENA NUEVA, DISTRITO DE CHIMBOTE, PROVINCIA DE SANTA – ANCASH”
ENTIDAD GOBIERNO REGIONAL DE ANCASH MONTO TOTAL CONTRATADO S/. 4,505,075.18
UBICACIÓN Region : Ancash-Provincia : del Santa-Distrito : Chimbote-Localidad : Magdalena FECHA DE INICIO DE OBRA 22.MAR.2018
CONTRATISTA CONSORCIO MAGDALENA
RESIDENCIA ING. NILTON TOMAS MENDEZ COTRINA
SUPERVISOR ING. JOSE ANTONIO QUIÑONEZ RODRIGUEZ FECHA DE TERMINO DE OBRA 19.JUL.2018
TOTAL 3,703,053.71 0.00 0.00 3,703,053.71 0.00 381,786.03 763,572.06 1,145,358.09 2,557,695.62 460,385.21 3,018,080.82 96.99%
RESUMEN DE VALORIZACIONES RECALCULADAS
OBRA “CREACION DE PISTAS Y VEREDAS EN EL PP. JJ. MAGDALENA NUEVA, DISTRITO DE CHIMBOTE, PROVINCIA DE SANTA – ANCASH”
ENTIDAD GOBIERNO REGIONAL DE ANCASH MONTO TOTAL CONTRATADO S/. 4,505,075.18
UBICACIÓN Region : Ancash-Provincia : del Santa-Distrito : Chimbote-Localidad : Magdalena FECHA DE INICIO DE OBRA 22.MAR.2018
CONTRATISTA CONSORCIO MAGDALENA
RESIDENCIA ING. NILTON TOMAS MENDEZ COTRINA
SUPERVISOR ING. JOSE ANTONIO QUIÑONEZ RODRIGUEZ FECHA DE TERMINO DE OBRA 19.JUL.2018
TOTAL 3,703,053.71 143,156.25 -3,029.27 0.00 3,843,180.69 0.00 381,786.03 763,572.06 1,145,358.09 2,697,822.60 485,608.08 3,183,430.66 96.99%
HOJA DE CALCULO DE REAJUSTES RECALCULADOS
CREACION DE PISTAS Y VEREDAS EN EL PP. JJ. MAGDALENA NUEVA, DISTRITO DE CHIMBOTE, PROVINCIA DE SANTA – ANCASH
SISTEMA DE CONTRATACION : PRECIOS UNITARIOS FECHA DE INICIO DE OBRA : 3/22/2018
FACTOR REAJUSTE
AVANCE REAJUSTE
VAL * PERIODO REAJUSTE BRUTO SITUACION
N° DE * PROGRAM ** EJECUT. ACUMULADO MES/PAGO PROGRAM. EJECUT. ACUMULADO AUTORIZADO DE LA
VALORIZ. "T" "V" * PROGRAM. ** EJECUT. "K-1" T x (K-1) V x (K-1) PROGRAM. EJECUT. MENSUAL ( R) ACUMULADO OBRA
VALORIZACION N° 01 146,402.92 176,897.18 146,402.92 176,897.18 4,538.49 5,483.81 4,538.49 5,483.81 5,483.81 5,483.81 ADELANTADA
01 Marz- 2018 146,402.92 176,897.18 146,402.92 176,897.18 0.031 4,538.49 5,483.81 4,538.49 5,483.81
VALORIZACION N° 02 1,174,392.05 1,254,626.46 1,320,794.97 1,431,523.64 38,754.94 41,402.67 43,293.43 46,886.49 41,402.67 46,886.49 ADELANTADA
02 Abr - 2018 1,174,392.05 1,254,626.46 1,320,794.97 1,431,523.64 0.033 38,754.94 41,402.67 43,293.43 46,886.49
VALORIZACION N° 03 1,722,228.32 693,925.23 3,043,023.29 2,125,448.87 70,611.36 28,450.93 113,904.79 75,337.42 28,450.93 75,337.42 ATRASADA
03 May - 2018 1,722,228.32 693,925.23 3,043,023.29 2,125,448.87 0.041 70,611.36 28,450.93 113,904.79 75,337.42
VALORIZACION N° 04 656,340.75 1,368,469.34 3,699,364.04 3,493,918.21 26,909.97 56,107.24 140,814.76 131,444.66 56,107.24 131,444.66 ATRASADA
04 Jun - 2018 656,340.75 1,368,469.34 3,699,364.04 3,493,918.21 0.041 26,909.97 56,107.24 140,814.76 131,444.66
VALORIZACION N° 05 118,496.29 209,135.50 3,817,860.33 3,703,053.71 6,635.79 11,711.59 147,450.55 143,156.25 11,711.59 143,156.25 CULMINADA
05 Jul - 2018 118,496.29 209,135.50 3,817,860.33 3,703,053.71 0.056 6,635.79 11,711.59 147,450.55 143,156.25
3,817,860.33 3,703,053.71 147,450.55 143,156.25 143,156.25
DECRETO SUPREMO N° 011-79-VC : Articulo 7°, Inciso B) Normas para Obras atrasadas
a) El reajuste total acumulado sobre el avance realmente ejecutado no podra superar el reajuste que hubiera correspondido al avance acumulado programado.
b) El reajuste que se abone al Contratistaen cada valorizacion de avance de obra, sumado con los yapagados, no debera superar al reajuste acumulado sobre el avance programdado a la misma fecha.
c) Cuando en determinado momento, el avance real de obra supere el atraso o se efectue reprogramacion de obra, ademas del reajuste que corresponda a la valorizacion del mes, se reintegrará, la parte del reajuste dejada de
abonar a consecuencia del atraso, a condicion que se cumpla con lo establecido en el inciso a) de este rubro B).
RECALCULO REAJUSTE QUE NO CORRESPONDE - ADELANTO DIRECTO
CREACION DE PISTAS Y VEREDAS EN EL PP. JJ. MAGDALENA NUEVA, DISTRITO DE CHIMBOTE, PROVINCIA DE
SANTA – ANCASH
SISTEMA DE CONTRATACION : SUMA ALZADA FECHA DE INICIO DE OBRA : 22/03/2018
ENTIDAD : GOBIERNO REGIONAL DE ANCASH PLAZO DE EJECUCION : 120 DIAS CALENDARIOS
CONTRATISTA : CONSORCIO MAGDALENA RESIDENTE DE OBRA : ING. NILTON TOMAS MENDEZ COTRINA
PRESUPUESTO CONTRATADO S/IGV: S/ 3,817,860.32 SUPERVISOR DE OBRA : ING. JOSE ANTONIO QUIÑONEZ RODRIGUEZ
FECHA DE ENTREGA DE TERRENO : 21/03/18
MONTO ADELANTO DIRECTO S/IGV : S/ 381,786.03
FACTOR FACTOR
VAL * PERIODO ** ADELANTO REAJUSTE REAJUSTE DEDUCCION DEDUCCION
N° DE AMORTIZADO MES/PAGO MES/PAGO K- Ka D= ACUMULADA
AA*(Ka-K)/(Ka)
VALORIZ. "AA" "Ka" "K"
PROYECTO: CREACION DE PISTAS Y VEREDAS EN EL PP. JJ. MAGDALENA NUEVA, DISTRITO DE CHIMBOTE, PROVINCIA DE SANTA – ANCASH
ADELANTO AMORTIZACION DE
MONTO VALORIZACION MONTO CONTRATO
VALORIZACION MENSUAL OTORGADO ADELANTO DIRECTO
MENSUAL S/IGV S/IGV.
S/IGV A = [1].[2] / [3]
Imo :
ADELANTO
Ima : I.U.
OTORGADO % A= adelanto Monto Adelanto por Saldo Adelanto x DEDUCCION:
MONTO VALORIZADO INDICE COEFICIENT Imr I.U. MAYO 2018 OCTUBRE
TIPO DE MATERIAL f: (mayo - 18) Utilizado = COEFIC Utilizable Utilizar Utilizar D= A*(Imr - Ima)/
(1) UNIFICADO E (3) PART. (4) 2017
Monto S/ x Val =(3) x (1) MU= (2) x (6)/(5) (9) (9)-A Imo
(5)
(2)
(6)
Imo :
ADELANTO Ima : AMORTIZACION
MATERIAL I.U. CALCULO DE LA
OTORGADO INDICE Imr I.U. MAYO 2018 DEUDA A LA FECHA DE SALDO POR AMORTIZAR
TIPO DE MATERIAL UTILIZADO X P.U. OCTUB 2017 AMORTIZACION
f: (may - 18) UNIFICADO (4) (8) VALORIZACION (9) - (8)
(1) (7)
Monto S/ (5) (9)
(6)
VALORIZACIONES VALORIZACIONES
DESCRIPCION SALDO
RECALCULADAS PAGADAS
A. VALORIZACION DE OBRA 3,703,053.71 3,703,053.71 0.00
OBRA: CREACION DE PISTAS Y VEREDAS EN EL PP. JJ. MAGDALENA NUEVA, DISTRITO DE CHIMBOTE, PROVINCIA DE SANTA – ANCASH
MONTO DE CONTRATO ORIGINAL S/. 4,505,075.18 Inc IGV S/IGV : S/. 3,817,860.32
MONTO DE REDUCCION DE OBRA S/. 135,471.81 Inc IGV S/IGV : S/. 114,806.62
MONTO EJECUTADO S/. 4,369,603.37 Inc IGV S/IGV : S/. 3,703,053.70
II.- ADELANTOS
2.1 OTORGADO
2.1.1 Adelanto Directo en Efectivo S/IGV 381,786.03
2.1.2 Adelanto de Materiales S/IGV 763,572.06
2.2 AMORTIZADO
2.2.1 Del Adelanto Directo en Efectivo 381,786.03
2.2.2 Del Adelanto de Materiales 763,572.06
SUB TOTAL 1,145,358.09 1,145,358.09
2.2 PAGADO
2.2.1 VALORIZACIONES NETAS PAGADAS 2,557,695.62
SUB TOTAL 2,697,822.61 2,557,695.62
RESUMEN DE SALDOS
EN CARGO DEL A FAVOR DEL
CONTRATISTA CONTRATISTA
DEL CONTRATO PRINCIPAL INC. I.G.V. 3,183,430.68 (1) 3,018,080.83 (2)
SON: CIENTO SESENTA Y CINCO MIL TRESCIENTOS CUARENTA Y NUEVE CON 84/100 SOLES
RESUMEN DE LIQUIDACION FINAL DE CONTRATO
OBRA: CREACION DE PISTAS Y VEREDAS EN EL PP. JJ. MAGDALENA NUEVA, DISTRITO DE CHIMBOTE, PROVINCIA DE SANTA – ANCASH
K = 0.228*(Mr / Mo) + 0.183*(AAr / AAo) + 0.119*(Ar / Ao) + 0.127*(Cr / Co) + 0.181*(Mr / Mo) + 0.162*(Ir / Io)
VALORIZACION 01 (22/03/18 - VALORIZACION 02 (01/04/18 - VALORIZACION 03 (01/05/18 - VALORIZACION 04 (01/06/18 - VALORIZACION 05 (01/07/18 -
I.U. OCTUBRE 2017 I.U. MARZO 2018
MONOMIO SIMBOLO DESCRIPCION I. U. COEF. INCID. % INCID. 31/03/18) I.U. ABRIL 2018 30/04/18) I.U. MAYO 2018 31/05/18) I.U. JUNIO 2018 30/06/18) I.U. JULIO 2018 19/07/18) I.U. AGOSTO 2018
Io - INDICE BASE Im K Im K Im K Im K Im K Im K
1 M MANO DE OBRA INC. LEYES SOCIALES 47 0.228 100.000% 580.90 582.52 0.229 582.52 0.229 602.11 0.236 602.11 0.236 602.11 0.236 582.52 0.229
2 AA ACERO DE CONSTRUCCION CORRUGADO 3 8.743% 469.92 501.98 513.58 508.81 512.37 525.48 506.47
0.183 0.186 0.186 0.186 0.186 0.187 0.186
AA AGREGADO GRUESO 5 91.257% 216.12 216.64 216.68 216.69 216.64 216.30 216.76
3 A ASFALTO 13 0.119 100.000% 1270.34 1461.65 0.137 1461.65 0.137 1461.65 0.137 1461.65 0.137 1596.69 0.150 1461.65 0.137
4 C CEMENTO PORTLAND TIPO I 21 0.127 100.000% 401.92 423.68 0.134 423.68 0.134 423.68 0.134 423.68 0.134 423.68 0.134 423.68 0.134
5 M MAQUINARIA Y EQUIPO NACIONAL 48 0.181 100.000% 363.30 365.01 0.182 368.95 0.184 368.82 0.184 369.08 0.184 369.15 0.184 365.55 0.182
6 I INDICE GENERAL DE PRECIOS AL CONSUMIDOR 39 0.162 100.000% 442.48 445.52 0.163 445.61 0.163 447.10 0.164 448.81 0.164 449.40 0.165 446.14 0.163
1.000 1.031 1.033 1.041 1.041 1.056 1.031
ACTUALIZACION DE PRECIOS
I.U. Io lr
MATERIAL
COD Oct-17 Apr-18 May-18 Jun-18 Jul-18 Aug-18
5 AGREGADO GRUESO 216.12 216.64 216.68 216.69 216.64 216.30
13 ASFALTO 1270.34 1461.65 1461.65 1461.65 1461.65 1596.69
21 CEMENTO PORTLAND TIPO I 401.92 423.68 423.68 423.68 423.68 423.68
22 CEMENTO PORTLAND TIPO II 367.30 367.30 367.30 367.30 367.30 367.30
30 DÓLAR (GENERAL PONDERADO) 467.61 469.88 478.04 479.58 481.37 483.02
39 INDICE GENERAL DE PRECIOS AL CONSUMIDOR 442.48 445.52 445.61 447.10 448.81 449.40
47 MANO DE OBRA INC. LEYES SOCIALES 580.90 582.52 582.52 602.11 602.11 602.11
48 MAQUINARIA Y EQUIPO NACIONAL 363.30 365.01 368.95 368.82 369.08 369.15
49 MAQUINARIA Y EQUIPO IMPORTADO 293.18 294.12 298.68 298.83 299.69 302.20
VALORIZACI VALORIZACI VALORIZACI VALORIZACI
VALORIZACION
ON 01 (01/03/18 ON 02 (01/04/18 ON 03 (01/05/18 ON 04 (01/06/18
05 (01/07/18 -
MONOMIO SIMBOLO DESCRIPCION I. U. I.U. OCTUBRE 2017 - 31/03/18) - 30/04/18) - 31/05/18) - 30/06/18)
19/07/18) I.U.
I.U. ABRIL I.U. MAYO I.U. JUNIO I.U. JULIO
AGOSTO 2018
2018 2018 2018 2018
Io - INDICE BASE Im Im Im Im Im
1 A AGREGADO GRUESO 5 216.12 216.64 216.68 216.69 216.64 216.30
2 A ASFALTO 13 1270.34 1461.65 1461.65 1461.65 1461.65 1596.69
3 CC CEMENTO PORTLAND TIPO I 21 401.92 423.68 423.68 423.68 423.68 423.68
4 A CEMENTO PORTLAND TIPO II 22 367.30 367.30 367.30 367.30 367.30 367.30
D DÓLAR (GENERAL PONDERADO) 30 467.61 469.88 478.04 479.58 481.37 483.02
5 I INDICE GENERAL DE PRECIOS AL CONSUMIDOR 39 442.48 445.52 445.61 447.10 448.81 449.40
M MANO DE OBRA INC. LEYES SOCIALES 47 580.90 582.52 582.52 602.11 602.11 602.11
6 MM MAQUINARIA Y EQUIPO NACIONAL 48 363.30 365.01 368.95 368.82 369.08 369.15
7 MAQUINARIA Y EQUIPO IMPORTADO 49 293.18 294.12 298.68 298.83 299.69 302.20
1 811.68 811.68 811.68
3 469.92 469.92 469.92
5 449.54 216.12 418.45
7 653.31 653.31 653.31
9 236.02 236.02 236.02
11 234.14 234.14 234.14
13 1270.34 1270.34 1270.34
17 624.31 666.77 703.47
19 751.34 751.34 751.34
21 465.71 401.92 426.29
23 418.1 418.1 418.1
27 701.88 701.88 701.88
31 373.41 373.41 373.41
33 830.19 830.19 830.19
37 298.08 298.08 298.08
39 442.48 442.48 442.48
41 410.71 410.71 410.71
43 719.16 655.68 887.32
45 322.7 322.7 322.7
47 580.9 580.9 580.9
49 293.18 293.18 293.18
51 305.83 305.83 305.83
53 680.84 680.84 680.84
55 500.65 500.65 500.65
57 385.56 385.56 385.56
59 238.53 238.53 238.53
61 236.63 236.63 236.63
65 235.92 235.92 235.92
69 389.45 327.82 428.87
71 645.41 645.41 645.41
73 544.62 544.62 544.62
77 321.23 321.23 321.23
2 488.45 488.45 488.45
4 545.9 935.73 1036.19
6 899.02 899.02 899.02
8 857.27 857.27 857.27
10 412.23 412.23 412.23
12 318.43 318.43 318.43
14 285.57 285.57 285.57
16 368.08 368.08 368.08
18 335.86 335.86 335.86
20 1533.84 1533.84 1533.84
22 367.3 367.3 367.3
24 240.78 240.78 240.78
26 370.67 370.67 370.67
28 599.03 599.03 599.03
30 467.61 467.61 467.61
32 468 468 468
34 464.73 464.73 464.73
38 428.42 960.95 864.26
40 378.13 412.96 443.25
42 284.22 284.22 284.22
44 376.71 376.71 376.71
46 474.55 474.55 474.55
48 363.3 363.3 363.3
50 693.13 693.13 693.13
52 300.4 300.4 300.4
54 405.6 405.6 405.6
56 488.1 488.1 488.1
60 295.99 295.99 295.99
62 462.33 462.33 462.33
64 319.97 319.97 319.97
66 707.19 707.19 707.19
68 259.97 259.97 259.97
70 218.25 218.25 218.25
72 426.35 426.35 426.35
78 480.28 480.28 480.28
80 107.23 107.23 107.23
811.68 811.68 811.68
469.92 469.92 469.92
603.46 (*) 632.37
653.31 653.31 653.31
236.02 236.02 236.02
234.14 234.14 234.14
1270.34 1270.34 1270.34
860.67 697.48 859.67
751.34 751.34 751.34
431.73 426.29 410.96
418.1 418.1 418.1
701.88 701.88 701.88
373.41 373.41 373.41
830.19 830.19 830.19
298.08 298.08 298.08
442.48 442.48 442.48
410.71 410.71 410.71
642.01 1088.94 884.54
322.7 322.7 322.7
580.9 580.9 580.9
293.18 293.18 293.18
305.83 305.83 305.83
680.84 680.84 680.84
500.65 500.65 500.65
385.56 385.56 385.56
238.53 238.53 238.53
236.63 236.63 236.63
235.92 235.92 235.92
488.52 269.39 451.51
645.41 645.41 645.41
544.62 544.62 544.62
321.23 321.23 321.23
488.45 488.45 488.45
591.86 391.8 760.7
899.02 899.02 899.02
857.27 857.27 857.27
412.23 412.23 412.23
318.43 318.43 318.43
285.57 285.57 285.57
368.08 368.08 368.08
335.86 335.86 335.86
1533.84 1533.84 1533.84
367.3 367.3 367.3
240.78 240.78 240.78
370.67 370.67 370.67
565.65 599.03 599.03
467.61 467.61 467.61
468 468 468
464.73 464.73 464.73
568.39 (*) 656.62
340.12 272.89 331.41
284.22 284.22 284.22
376.71 376.71 376.71
474.55 474.55 474.55
363.3 363.3 363.3
693.13 693.13 693.13
300.4 300.4 300.4
405.6 405.6 405.6
488.1 488.1 488.1
295.99 295.99 295.99
462.33 462.33 462.33
319.97 319.97 319.97
707.19 707.19 707.19
259.97 259.97 259.97
218.25 218.25 218.25
426.35 426.35 426.35
480.28 480.28 480.28
107.23 107.23 107.23
RESOLUCIÓN JEFATURAL Nº 305-2017-INEI
CÓDIGO 47: ÍNDICE MANO DE OBRA
GRÁFICA 2
MARZO 2018
ÍNDICE
MODIFICAD
O
47
943.93 5
216.76 13
679.31 21
961.33 22
436.72 48
666.28 49
30
39
1 902.13 902.13 902.13 902.13 902.13 902.13
3 501.98 501.98 501.98 501.98 501.98 501.98
5 450.08 216.64 420.58 607.14 (*) 628.08
7 671.19 671.19 671.19 671.19 671.19 671.19
9 238.74 238.74 238.74 238.74 238.74 238.74
11 235.08 235.08 235.08 235.08 235.08 235.08
13 1461.65 1461.65 1461.65 1461.65 1461.65 1461.65
17 627.28 672.21 702.73 861.15 764.74 868.72
19 774.8 774.8 774.8 774.8 774.8 774.8
21 476.04 423.68 449.56 431.73 449.56 410.96
23 439.25 439.25 439.25 439.25 439.25 439.25
27 458.59 458.59 458.59 458.59 458.59 458.59
31 376.78 376.78 376.78 376.78 376.78 376.78
33 841.52 841.52 841.52 841.52 841.52 841.52
37 304.2 304.2 304.2 304.2 304.2 304.2
39 445.52 445.52 445.52 445.52 445.52 445.52
41 419.01 419.01 419.01 419.01 419.01 419.01
43 721.99 670.45 898.75 649.51 1103.19 904.3
45 322.55 322.55 322.55 322.55 322.55 322.55
47 582.52 582.52 582.52 582.52 582.52 582.52
49 294.12 294.12 294.12 294.12 294.12 294.12
51 340.88 340.88 340.88 340.88 340.88 340.88
53 745.75 745.75 745.75 745.75 745.75 745.75
55 500.55 500.55 500.55 500.55 500.55 500.55
57 381.93 381.93 381.93 381.93 381.93 381.93
59 244.25 244.25 244.25 244.25 244.25 244.25
61 243.1 243.1 243.1 243.1 243.1 243.1
65 247.66 247.66 247.66 247.66 247.66 247.66
69 389.45 327.82 428.87 488.52 269.39 451.51
71 641.45 641.45 641.45 641.45 641.45 641.45
73 545.39 545.39 545.39 545.39 545.39 545.39
77 325.14 325.14 325.14 325.14 325.14 325.14
2 526.55 526.55 526.55 526.55 526.55 526.55
4 547.13 937.59 1039.22 587.84 365.28 763.89
6 932.93 932.93 932.93 932.93 932.93 932.93
8 892.57 892.57 892.57 892.57 892.57 892.57
10 418.64 418.64 418.64 418.64 418.64 418.64
12 317.37 317.37 317.37 317.37 317.37 317.37
14 283.57 283.57 283.57 283.57 283.57 283.57
16 354.83 354.83 354.83 354.83 354.83 354.83
18 340.5 340.5 340.5 340.5 340.5 340.5
20 1778.04 1778.04 1778.04 1778.04 1778.04 1778.04
22 367.3 367.3 367.3 367.3 367.3 367.3
24 243.19 243.19 243.19 243.19 243.19 243.19
26 370.53 370.53 370.53 370.53 370.53 370.53
28 569.3 569.3 569.3 563.03 569.3 569.3
30 469.88 469.88 469.88 469.88 469.88 469.88
32 468.41 468.41 468.41 468.41 468.41 468.41
34 471.19 471.19 471.19 471.19 471.19 471.19
38 425.65 958.44 867.04 568.58 (*) 659.07
40 383.17 437.47 450.27 343.15 272.89 331.41
42 283.36 283.36 283.36 283.36 283.36 283.36
44 381.73 381.73 381.73 381.73 381.73 381.73
46 486.77 486.77 486.77 486.77 486.77 486.77
48 365.01 365.01 365.01 365.01 365.01 365.01
50 637.87 637.87 637.87 637.87 637.87 637.87
52 304.25 304.25 304.25 304.25 304.25 304.25
54 406.26 406.26 406.26 406.26 406.26 406.26
56 523.71 523.71 523.71 523.71 523.71 523.71
60 295.99 295.99 295.99 295.99 295.99 295.99
62 463.83 463.83 463.83 463.83 463.83 463.83
64 348.21 348.21 348.21 348.21 348.21 348.21
66 729.1 729.1 729.1 729.1 729.1 729.1
68 276.08 276.08 276.08 276.08 276.08 276.08
70 218.25 218.25 218.25 218.25 218.25 218.25
72 429.31 429.31 429.31 429.31 429.31 429.31
78 485.34 485.34 485.34 485.34 485.34 485.34
80 106.96 106.96 106.96 106.96 106.96 106.96
106.96
1 908.57 908.57 908.57 908.57 908.57 908.57
3 513.58 513.58 513.58 513.58 513.58 513.58
5 450.97 216.68 422.12 608.03 (*) 617.54
7 679.18 679.18 679.18 679.18 679.18 679.18
9 249.31 249.31 249.31 249.31 249.31 249.31
11 237.63 237.63 237.63 237.63 237.63 237.63
13 1461.65 1461.65 1461.65 1461.65 1461.65 1461.65
17 624.36 668.02 700.78 859.84 784.13 865.43
19 782.52 782.52 782.52 782.52 782.52 782.52
21 476.04 423.68 449.56 431.73 449.56 410.96
23 439.25 439.25 439.25 439.25 439.25 439.25
27 464.69 464.69 464.69 464.69 464.69 464.69
31 378.03 378.03 378.03 378.03 378.03 378.03
33 857.98 857.98 857.98 857.98 857.98 857.98
37 304.54 304.54 304.54 304.54 304.54 304.54
39 445.61 445.61 445.61 445.61 445.61 445.61
41 419.01 419.01 419.01 419.01 419.01 419.01
43 718.6 674.85 900.76 646.54 1103.67 899.03
45 323.64 323.64 323.64 323.64 323.64 323.64
47 582.52 582.52 582.52 582.52 582.52 582.52
49 298.68 298.68 298.68 298.68 298.68 298.68
51 347.86 347.86 347.86 347.86 347.86 347.86
53 779.52 779.52 779.52 779.52 779.52 779.52
55 500.55 500.55 500.55 500.55 500.55 500.55
57 389.94 389.94 389.94 389.94 389.94 389.94
59 244.25 244.25 244.25 244.25 244.25 244.25
61 253.46 253.46 253.46 253.46 253.46 253.46
65 250.41 250.41 250.41 250.41 250.41 250.41
69 389.45 327.82 428.87 488.52 269.39 451.51
71 649.98 649.98 649.98 649.98 649.98 649.98
73 551.43 551.43 551.43 551.43 551.43 551.43
77 331.39 331.39 331.39 331.39 331.39 331.39
2 534.75 534.75 534.75 534.75 534.75 534.75
4 545.1 935.32 1036.79 589.61 365.28 746.69
6 945.8 945.8 945.8 945.8 945.8 945.8
8 905.34 905.34 905.34 905.34 905.34 905.34
10 416.29 416.29 416.29 416.29 416.29 416.29
12 319.78 319.78 319.78 319.78 319.78 319.78
14 283.57 283.57 283.57 283.57 283.57 283.57
16 354.83 354.83 354.83 354.83 354.83 354.83
18 350.69 350.69 350.69 350.69 350.69 350.69
20 1778.04 1778.04 1778.04 1778.04 1778.04 1778.04
22 367.3 367.3 367.3 367.3 367.3 367.3
24 242.45 242.45 242.45 242.45 242.45 242.45
26 371.13 371.13 371.13 371.13 371.13 371.13
28 576.87 576.87 576.87 568.64 576.87 576.87
30 478.04 478.04 478.04 478.04 478.04 478.04
32 468.41 468.41 468.41 468.41 468.41 468.41
34 494.47 494.47 494.47 494.47 494.47 494.47
38 422.07 954.76 865.26 567.84 (*) 653.87
40 383.17 436.92 450.27 347.98 272.89 331.41
42 285.22 285.22 285.22 285.22 285.22 285.22
44 382.02 382.02 382.02 382.02 382.02 382.02
46 489.6 489.6 489.6 489.6 489.6 489.6
48 368.95 368.95 368.95 368.95 368.95 368.95
50 646.23 646.23 646.23 646.23 646.23 646.23
52 309.75 309.75 309.75 309.75 309.75 309.75
54 406.26 406.26 406.26 406.26 406.26 406.26
56 539.72 539.72 539.72 539.72 539.72 539.72
60 295.99 295.99 295.99 295.99 295.99 295.99
62 467.17 467.17 467.17 467.17 467.17 467.17
64 348.21 348.21 348.21 348.21 348.21 348.21
66 735.57 735.57 735.57 735.57 735.57 735.57
68 278.22 278.22 278.22 278.22 278.22 278.22
70 218.25 218.25 218.25 218.25 218.25 218.25
72 431.66 431.66 431.66 431.66 431.66 431.66
78 489.2 489.2 489.2 489.2 489.2 489.2
80 107.02 107.02 107.02 107.02 107.02 107.02
Cód. 1 2 3 4 5
1 908.11 908.11 908.11 908.11 908.11
3 508.81 508.81 508.81 508.81 508.81
5 453.1 216.69 423.8 609.06 (*)
7 683.55 683.55 683.55 683.55 683.55
9 250.85 250.85 250.85 250.85 250.85
11 238.13 238.13 238.13 238.13 238.13
13 1461.65 1461.65 1461.65 1461.65 1461.65
17 622.17 668.52 700.21 859 787.91
19 782.96 782.96 782.96 782.96 782.96
21 476.04 423.68 449.56 431.73 449.56
23 439.25 439.25 439.25 439.25 439.25
27 464.25 464.25 464.25 464.25 464.25
31 377.94 377.94 377.94 377.94 377.94
33 857.7 857.7 857.7 857.7 857.7
37 303.74 303.74 303.74 303.74 303.74
39 447.1 447.1 447.1 447.1 447.1
41 419.01 419.01 419.01 419.01 419.01
43 720.1 678.76 903.7 652.81 1103.67
45 323.64 323.64 323.64 323.64 323.64
47 582.52 602.11 582.52 582.52 582.52
49 298.83 298.83 298.83 298.83 298.83
51 349.06 349.06 349.06 349.06 349.06
53 790.12 790.12 790.12 790.12 790.12
55 500.55 500.55 500.55 500.55 500.55
57 389.58 389.58 389.58 389.58 389.58
59 243.79 243.79 243.79 243.79 243.79
61 260.82 260.82 260.82 260.82 260.82
65 250.53 250.53 250.53 250.53 250.53
69 389.45 327.82 428.87 488.52 269.39
71 649.38 649.38 649.38 649.38 649.38
73 550.99 550.99 550.99 550.99 550.99
77 331.78 331.78 331.78 331.78 331.78
2 532.76 532.76 532.76 532.76 532.76
4 546.69 938.46 1036.79 588.7 365.28
6 939.31 939.31 939.31 939.31 939.31
8 904.81 904.81 904.81 904.81 904.81
10 414.54 414.54 414.54 414.54 414.54
12 319.59 319.59 319.59 319.59 319.59
14 283.57 283.57 283.57 283.57 283.57
16 354.83 354.83 354.83 354.83 354.83
18 350.51 350.51 350.51 350.51 350.51
20 1778.04 1778.04 1778.04 1778.04 1778.04
22 367.3 367.3 367.3 367.3 367.3
24 244.8 244.8 244.8 244.8 244.8
26 371.51 371.51 371.51 371.51 371.51
28 576.34 576.34 576.34 568.25 576.34
30 479.58 479.58 479.58 479.58 479.58
32 470.47 470.47 470.47 470.47 470.47
34 507.4 507.4 507.4 507.4 507.4
38 423.83 951.31 862.48 569.3 (*)
40 383.17 439.33 448.01 348.83 272.89
42 285.07 285.07 285.07 285.07 285.07
44 382.87 382.87 382.87 382.87 382.87
46 483.55 483.55 483.55 483.55 483.55
48 368.82 368.82 368.82 368.82 368.82
50 645.61 645.61 645.61 645.61 645.61
52 309.58 309.58 309.58 309.58 309.58
54 406.6 406.6 406.6 406.6 406.6
56 539.22 539.22 539.22 539.22 539.22
60 295.99 295.99 295.99 295.99 295.99
62 469.04 469.04 469.04 469.04 469.04
64 348.21 348.21 348.21 348.21 348.21
66 735.11 735.11 735.11 735.11 735.11
68 288.14 288.14 288.14 288.14 288.14
70 218.25 218.25 218.25 218.25 218.25
72 434.23 434.23 434.23 434.23 434.23
78 488.93 488.93 488.93 488.93 488.93
80 107.59 107.59 107.59 107.59 107.59
6
908.11
508.81
618.89
683.55
250.85
238.13
1461.65
864.03
782.96
410.96
439.25
464.25
377.94
857.7
303.74
447.1
419.01
896.42
323.64
582.52
298.83
349.06
790.12
500.55
389.58
243.79
260.82
250.53
451.51
649.38
550.99
331.78
532.76
744.62
939.31
904.81
414.54
319.59
283.57
354.83
350.51
1778.04
367.3
244.8
371.51
576.34
479.58
470.47
507.4
651.43
331.41
285.07
382.87
483.55
368.82
645.61
309.58
406.6
539.22
295.99
469.04
348.21
735.11
288.14
218.25
434.23
488.93
107.59
Cód. 1 2 3 4 5 6
1 957.83 957.83 957.83 957.83 957.83 957.83
3 512.37 512.37 512.37 512.37 512.37 512.37
5 453.63 216.64 425.85 605.75 (*) 619.23
7 685.35 685.35 685.35 685.35 685.35 685.35
9 251.38 251.38 251.38 251.38 251.38 251.38
11 236.99 236.99 236.99 236.99 236.99 236.99
13 1461.65 1461.65 1461.65 1461.65 1461.65 1461.65
17 622.77 671.19 697.96 858.99 795.04 865.97
19 783.88 783.88 783.88 783.88 783.88 783.88
21 476.04 423.68 449.56 438.28 449.56 410.96
23 439.25 439.25 439.25 439.25 439.25 439.25
27 465.25 465.25 465.25 465.25 465.25 465.25
31 378.15 378.15 378.15 378.15 378.15 378.15
33 859.31 859.31 859.31 859.31 859.31 859.31
37 305.61 305.61 305.61 305.61 305.61 305.61
39 448.81 448.81 448.81 448.81 448.81 448.81
41 419.01 419.01 419.01 419.01 419.01 419.01
43 725.34 678.97 914.43 650.56 1119.03 894.58
45 323.28 323.28 323.28 323.28 323.28 323.28
47 582.52 602.11 582.52 582.52 582.52 582.52
49 299.69 299.69 299.69 299.69 299.69 299.69
51 348.95 348.95 348.95 348.95 348.95 348.95
53 805.35 805.35 805.35 805.35 805.35 805.35
55 500.55 500.55 500.55 500.55 500.55 500.55
57 390.41 390.41 390.41 390.41 390.41 390.41
59 243.79 243.79 243.79 243.79 243.79 243.79
61 266.57 266.57 266.57 266.57 266.57 266.57
65 254.51 254.51 254.51 254.51 254.51 254.51
69 389.45 327.82 428.87 488.52 269.39 451.51
71 650.77 650.77 650.77 650.77 650.77 650.77
73 551.96 551.96 551.96 551.96 551.96 551.96
77 331.03 331.03 331.03 331.03 331.03 331.03
2 532.40 532.40 532.40 532.40 532.40 532.40
4 547.19 936.14 1036.46 589.75 365.28 751.32
6 944.94 944.94 944.94 944.94 944.94 944.94
8 904.70 904.70 904.70 904.70 904.70 904.70
10 414.88 414.88 414.88 414.88 414.88 414.88
12 319.93 319.93 319.93 319.93 319.93 319.93
14 283.57 283.57 283.57 283.57 283.57 283.57
16 354.83 354.83 354.83 354.83 354.83 354.83
18 350.24 350.24 350.24 350.24 350.24 350.24
20 1778.04 1778.04 1778.04 1778.04 1778.04 1778.04
22 367.30 367.30 367.30 367.30 367.30 367.30
24 243.50 243.50 243.50 243.50 243.50 243.50
26 377.26 377.26 377.26 377.26 377.26 377.26
28 577.58 577.58 577.58 569.16 577.58 577.58
30 481.37 481.37 481.37 481.37 481.37 481.37
32 470.47 470.47 470.47 470.47 470.47 470.47
34 503.52 503.52 503.52 503.52 503.52 503.52
38 425.64 955.92 865.32 570.93 (*) 649.00
40 383.17 442.60 446.07 350.36 272.89 331.41
42 285.36 285.36 285.36 285.36 285.36 285.36
44 383.09 383.09 383.09 383.09 383.09 383.09
46 483.51 483.51 483.51 483.51 483.51 483.51
48 369.08 369.08 369.08 369.08 369.08 369.08
50 647.15 647.15 647.15 647.15 647.15 647.15
52 309.94 309.94 309.94 309.94 309.94 309.94
54 406.60 406.60 406.60 406.60 406.60 406.60
56 540.38 540.38 540.38 540.38 540.38 540.38
60 295.99 295.99 295.99 295.99 295.99 295.99
62 468.68 468.68 468.68 468.68 468.68 468.68
64 348.21 348.21 348.21 348.21 348.21 348.21
66 736.16 736.16 736.16 736.16 736.16 736.16
68 288.64 288.64 288.64 288.64 288.64 288.64
70 218.25 218.25 218.25 218.25 218.25 218.25
72 434.41 434.41 434.41 434.41 434.41 434.41
78 489.56 489.56 489.56 489.56 489.56 489.56
80 107.54 107.54 107.54 107.54 107.54 107.54
CODIGO 47: INDICE MANO DE OBRA