valorizaciones

45
Item Descripción METR Unidad 01.01.00 MOVIMIENTO DE TIERRAS Y DEMOLICIONES 01.01.01 Demolición de Vereda existente M2 01.01.02 Demolición de pavimentos de concreto de 4" M2 01.01.03 Excavación a nivel de subrasante M3 01.01.04 Relleno con material propio con equipo M3 01.01.05 Eliminación de material Excedente M3 02.01.00 VEREDAS 02.01.01 Compactación manual de subrasante M2 02.01.02 Base e=0.1m (manual) M2 02.01.03 losa de concreto f'c=210 kg/cm2 e=0.1 M2 02.01.04 Sellado de juntas para veredas M 03.01.00 PAVIMENTO 03.01.01 Conformación de la subrasante M2 03.01.02 Base e=0.20 M2 03.01.03 Imprimacióa asfáltica M2 03.01.04 Carpeta asfáltica en caliente, E=2" M2 04.01.00 REPARACIÓN DE PAVIMENTO 04.01.01 Carpeta asfáltica en caliente, E=1" M2 04.01.02 Riego de liga M2 05.01.00 SARDINELES Y OTROS 05.01.01 Sardinel de vereda f'c=175 Kg/cm2 M 05.01.02 Alcantarillas de PVC-SAP D=10" f'c=210 Kg/cm2 M Costo Directo Gastos Generales (10%) Presupuesto total

Upload: javier-pachas-norabuena

Post on 18-Jan-2016

4 views

Category:

Documents


0 download

DESCRIPTION

Hoja de cálculo para la obtención de los reajustes, deducciones y amortizaciones de valorizaciones en obras públicas

TRANSCRIPT

Page 1: Valorizaciones

Item DescripciónMETRADO

Unidad CANTIDAD01.01.00 MOVIMIENTO DE TIERRAS Y DEMOLICIONES01.01.01 Demolición de Vereda existente M2 12501.01.02 Demolición de pavimentos de concreto de 4" M2 11001.01.03 Excavación a nivel de subrasante M3 27801.01.04 Relleno con material propio con equipo M3 22001.01.05 Eliminación de material Excedente M3 109.48

02.01.00 VEREDAS02.01.01 Compactación manual de subrasante M2 168002.01.02 Base e=0.1m (manual) M2 168002.01.03 losa de concreto f'c=210 kg/cm2 e=0.1 M2 168002.01.04 Sellado de juntas para veredas M 334.8

03.01.00 PAVIMENTO03.01.01 Conformación de la subrasante M2 1320003.01.02 Base e=0.20 M2 1320003.01.03 Imprimacióa asfáltica M2 1320003.01.04 Carpeta asfáltica en caliente, E=2" M2 13200

04.01.00 REPARACIÓN DE PAVIMENTO04.01.01 Carpeta asfáltica en caliente, E=1" M2 341004.01.02 Riego de liga M2 3410

05.01.00 SARDINELES Y OTROS05.01.01 Sardinel de vereda f'c=175 Kg/cm2 M 280005.01.02 Alcantarillas de PVC-SAP D=10" f'c=210 Kg/cm2 M 26.4

Costo DirectoGastos Generales (10%)

Presupuesto total

Page 2: Valorizaciones

PRESUPUESTO ACUMULADO ANTERIOR AVANCE ACTUALPU P TOTAL % CANTIDAD P TOTAL % CANTIDAD

S/. 12,590.12 0.00 S/. 0.00 35.91%8.47 S/. 1,058.75 0.00 S/. 0.00 100.00% 125.00 6.29 S/. 691.90 0.00 S/. 0.00 100.00% 110.00

27.71 S/. 7,703.38 0.00 S/. 0.00 35.97% 100.00 6.88 S/. 1,513.60 0.00 S/. 0.00 0.00%

14.82 S/. 1,622.49 0.00 S/. 0.00 0.00%

S/. 88,496.76 0.00 S/. 0.00 3.08%7.79 S/. 13,087.20 0.00 S/. 0.00 20.83% 350.00 8.94 S/. 15,019.20 0.00 S/. 0.00 0.00%

35.01 S/. 58,816.80 0.00 S/. 0.00 0.00%4.7 S/. 1,573.56 0.00 S/. 0.00 0.00%

S/. 467,016.00 0.00 S/. 0.00 2.17%2.89 S/. 38,148.00 0.00 S/. 0.00 26.52% 3,500.00 9.94 S/. 131,208.00 0.00 S/. 0.00 0.00%4.15 S/. 54,780.00 0.00 S/. 0.00 0.00%18.4 S/. 242,880.00 0.00 S/. 0.00 0.00%

0.00S/. 41,329.20 0.00 S/. 0.00 0.00%

9 S/. 30,690.00 0.00 S/. 0.00 0.00%3.12 S/. 10,639.20 0.00 S/. 0.00 0.00%

S/. 68,699.90 0.00 S/. 0.00 0.00%22.42 S/. 62,776.00 0.00 S/. 0.00 0.00%

224.39 S/. 5,923.90 0.00 S/. 0.00 0.00%Costo Directo S/. 678,131.98 S/. 0.00 2.56%

Gastos Generales (10%) S/. 67,813.20 S/. 0.00Presupuesto total S/. 745,945.18 S/. 0.00

Page 3: Valorizaciones

AVANCE ACTUAL ACUMULADO TOTAL SALDOP TOTAL % CANTIDAD P TOTAL % CANTIDADS/. 4,521.65 35.91% S/. 4,521.65 64.09%S/. 1,058.75 100.00% 125.00 S/. 1,058.75 0.00% 0.00

S/. 691.90 100.00% 110.00 S/. 691.90 0.00% 0.00S/. 2,771.00 35.97% 100.00 S/. 2,771.00 64.03% 178.00

S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 220.00S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 109.48

S/. 2,726.50 3.08% S/. 2,726.50 96.92%S/. 2,726.50 20.83% 350.00 S/. 2,726.50 79.17% 1330.00

S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 1680.00S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 1680.00S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 334.80

S/. 10,115.00 2.17% S/. 10,115.00 97.83%S/. 10,115.00 26.52% 3500.00 S/. 10,115.00 73.48% 9700.00

S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 13200.00S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 13200.00S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 13200.00

S/. 0.00 0.00% S/. 0.00 100.00%S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 3410.00S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 3410.00

S/. 0.00 0.00% S/. 0.00 100.00%S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 2800.00S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 26.40

S/. 17,363.15 2.56% S/. 17,363.15 97.44%S/. 1,736.32 S/. 1,736.32

S/. 19,099.47 S/. 19,099.47

Page 4: Valorizaciones

SALDOP TOTAL

S/. 8,068.47S/. 0.00S/. 0.00

S/. 4,932.38S/. 1,513.60S/. 1,622.49

S/. 85,770.26S/. 10,360.70S/. 15,019.20S/. 58,816.80

S/. 1,573.56

S/. 456,901.00S/. 28,033.00

S/. 131,208.00S/. 54,780.00

S/. 242,880.00

S/. 41,329.20S/. 30,690.00S/. 10,639.20

S/. 68,699.90S/. 62,776.00

S/. 5,923.90S/. 660,768.83

S/. 66,076.88S/. 726,845.71

Page 5: Valorizaciones

Item DescripciónMETRADO

Unidad CANTIDAD01.01.00 MOVIMIENTO DE TIERRAS Y DEMOLICIONES01.01.01 Demolición de Vereda existente M2 12501.01.02 Demolición de pavimentos de concreto de 4" M2 11001.01.03 Excavación a nivel de subrasante M3 27801.01.04 Relleno con material propio con equipo M3 22001.01.05 Eliminación de material Excedente M3 109.48

02.01.00 VEREDAS02.01.01 Compactación manual de subrasante M2 168002.01.02 Base e=0.1m (manual) M2 168002.01.03 losa de concreto f'c=210 kg/cm2 e=0.1 M2 168002.01.04 Sellado de juntas para veredas M 334.8

03.01.00 PAVIMENTO03.01.01 Conformación de la subrasante M2 1320003.01.02 Base e=0.20 M2 1320003.01.03 Imprimacióa asfáltica M2 1320003.01.04 Carpeta asfáltica en caliente, E=2" M2 13200

04.01.00 REPARACIÓN DE PAVIMENTO04.01.01 Carpeta asfáltica en caliente, E=1" M2 341004.01.02 Riego de liga M2 3410

05.01.00 SARDINELES Y OTROS05.01.01 Sardinel de vereda f'c=175 Kg/cm2 M 280005.01.02 Alcantarillas de PVC-SAP D=10" f'c=210 Kg/cm2 M 26.4

Costo DirectoGastos Generales (10%)

Presupuesto total

Page 6: Valorizaciones

PRESUPUESTO ACUMULADO ANTERIOR AVANCE ACTUALPU P TOTAL % CANTIDAD P TOTAL % CANTIDAD

S/. 12,590.12 35.91% S/. 4,521.65 38.48%8.47 S/. 1,058.75 100.00% 125.00 S/. 1,058.75 0.00%6.29 S/. 691.90 100.00% 110.00 S/. 691.90 0.00%

27.71 S/. 7,703.38 35.97% 100.00 S/. 2,771.00 53.96% 150.00 6.88 S/. 1,513.60 0.00% 0.00 S/. 0.00 45.45% 100.00

14.82 S/. 1,622.49 0.00% 0.00 S/. 0.00 0.00%

S/. 88,496.76 3.08% S/. 2,726.50 34.09%7.79 S/. 13,087.20 20.83% 350.00 S/. 2,726.50 71.43% 1,200.00 8.94 S/. 15,019.20 0.00% 0.00 S/. 0.00 80.36% 1,350.00

35.01 S/. 58,816.80 0.00% 0.00 S/. 0.00 14.88% 250.00 4.7 S/. 1,573.56 0.00% 0.00 S/. 0.00 0.00%

S/. 467,016.00 2.17% S/. 10,115.00 9.03%2.89 S/. 38,148.00 26.52% 3500.00 S/. 10,115.00 45.45% 6,000.00 9.94 S/. 131,208.00 0.00% 0.00 S/. 0.00 18.94% 2,500.00 4.15 S/. 54,780.00 0.00% 0.00 S/. 0.00 0.00%18.4 S/. 242,880.00 0.00% 0.00 S/. 0.00 0.00%

S/. 41,329.20 0.00% S/. 0.00 0.00%9 S/. 30,690.00 0.00% 0.00 S/. 0.00 0.00%

3.12 S/. 10,639.20 0.00% 0.00 S/. 0.00 0.00%

S/. 68,699.90 0.00% S/. 0.00 0.00%22.42 S/. 62,776.00 0.00% 0.00 S/. 0.00 0.00%

224.39 S/. 5,923.90 0.00% 0.00 S/. 0.00 0.00%Costo Directo S/. 678,131.98 2.56% S/. 17,363.15 11.38%

Gastos Generales (10%) S/. 67,813.20 S/. 1,736.32Presupuesto total S/. 745,945.18 S/. 19,099.47

Page 7: Valorizaciones

AVANCE ACTUAL ACUMULADO TOTAL SALDOP TOTAL % CANTIDAD P TOTAL % CANTIDADS/. 4,844.50 74.39% S/. 9,366.15 25.61%

S/. 0.00 100.00% 125.00 S/. 1,058.75 0.00% 0.00S/. 0.00 100.00% 110.00 S/. 691.90 0.00% 0.00

S/. 4,156.50 89.93% 250.00 S/. 6,927.50 10.07% 28.00S/. 688.00 45.45% 100.00 S/. 688.00 54.55% 120.00

S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 109.48

S/. 30,169.50 37.17% S/. 32,896.00 62.83%S/. 9,348.00 92.26% 1550.00 S/. 12,074.50 7.74% 130.00

S/. 12,069.00 80.36% 1350.00 S/. 12,069.00 19.64% 330.00S/. 8,752.50 14.88% 250.00 S/. 8,752.50 85.12% 1430.00

S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 334.80

S/. 42,190.00 11.20% S/. 52,305.00 88.80%S/. 17,340.00 71.97% 9500.00 S/. 27,455.00 28.03% 3700.00S/. 24,850.00 18.94% 2500.00 S/. 24,850.00 81.06% 10700.00

S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 13200.00S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 13200.00

S/. 0.00 0.00% S/. 0.00 100.00%S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 3410.00S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 3410.00

S/. 0.00 0.00% S/. 0.00 100.00%S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 2800.00S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 26.40

S/. 77,204.00 13.95% S/. 94,567.15 86.05%S/. 7,720.40 S/. 9,456.72

S/. 84,924.40 S/. 104,023.86

Page 8: Valorizaciones

SALDOP TOTAL

S/. 3,223.97S/. 0.00S/. 0.00

S/. 775.88S/. 825.60

S/. 1,622.49

S/. 55,600.76S/. 1,012.70S/. 2,950.20

S/. 50,064.30S/. 1,573.56

S/. 414,711.00S/. 10,693.00

S/. 106,358.00S/. 54,780.00

S/. 242,880.00

S/. 41,329.20S/. 30,690.00S/. 10,639.20

S/. 68,699.90S/. 62,776.00

S/. 5,923.90S/. 583,564.83

S/. 58,356.48S/. 641,921.31

Page 9: Valorizaciones

Item DescripciónMETRADO

Unidad CANTIDAD01.01.00 MOVIMIENTO DE TIERRAS Y DEMOLICIONES01.01.01 Demolición de Vereda existente M2 12501.01.02 Demolición de pavimentos de concreto de 4" M2 11001.01.03 Excavación a nivel de subrasante M3 27801.01.04 Relleno con material propio con equipo M3 22001.01.05 Eliminación de material Excedente M3 109.48

02.01.00 VEREDAS02.01.01 Compactación manual de subrasante M2 168002.01.02 Base e=0.1m (manual) M2 168002.01.03 losa de concreto f'c=210 kg/cm2 e=0.1 M2 168002.01.04 Sellado de juntas para veredas M 334.8

03.01.00 PAVIMENTO03.01.01 Conformación de la subrasante M2 1320003.01.02 Base e=0.20 M2 1320003.01.03 Imprimacióa asfáltica M2 1320003.01.04 Carpeta asfáltica en caliente, E=2" M2 13200

04.01.00 REPARACIÓN DE PAVIMENTO04.01.01 Carpeta asfáltica en caliente, E=1" M2 341004.01.02 Riego de liga M2 3410

05.01.00 SARDINELES Y OTROS05.01.01 Sardinel de vereda f'c=175 Kg/cm2 M 280005.01.02 Alcantarillas de PVC-SAP D=10" f'c=210 Kg/cm2 M 26.4

Costo DirectoGastos Generales (10%)

Presupuesto total

Page 10: Valorizaciones

PRESUPUESTO ACUMULADO ANTERIOR AVANCE ACTUALPU P TOTAL % CANTIDAD P TOTAL % CANTIDAD

S/. 12,590.12 74.39% S/. 9,366.15 12.72%8.47 S/. 1,058.75 100.00% 125.00 S/. 1,058.75 0.00%6.29 S/. 691.90 100.00% 110.00 S/. 691.90 0.00%

27.71 S/. 7,703.38 89.93% 250.00 S/. 6,927.50 10.07% 28.00 6.88 S/. 1,513.60 45.45% 100.00 S/. 688.00 54.55% 120.00

14.82 S/. 1,622.49 0.00% 0.00 S/. 0.00 0.00%

S/. 88,496.76 37.17% S/. 32,896.00 54.99%7.79 S/. 13,087.20 92.26% 1550.00 S/. 12,074.50 7.74% 130.00 8.94 S/. 15,019.20 80.36% 1350.00 S/. 12,069.00 19.64% 330.00

35.01 S/. 58,816.80 14.88% 250.00 S/. 8,752.50 74.40% 1,250.00 4.7 S/. 1,573.56 0.00% 0.00 S/. 0.00 59.74% 200.00

S/. 467,016.00 11.20% S/. 52,305.00 15.06%2.89 S/. 38,148.00 71.97% 9500.00 S/. 27,455.00 28.03% 3,700.00 9.94 S/. 131,208.00 18.94% 2500.00 S/. 24,850.00 45.45% 6,000.00 4.15 S/. 54,780.00 0.00% 0.00 S/. 0.00 0.00%18.4 S/. 242,880.00 0.00% 0.00 S/. 0.00 0.00%

S/. 41,329.20 0.00% S/. 0.00 0.00%9 S/. 30,690.00 0.00% 0.00 S/. 0.00 0.00%

3.12 S/. 10,639.20 0.00% 0.00 S/. 0.00 0.00%

S/. 68,699.90 0.00% S/. 0.00 26.11%22.42 S/. 62,776.00 0.00% 0.00 S/. 0.00 28.57% 800.00

224.39 S/. 5,923.90 0.00% 0.00 S/. 0.00 0.00%Costo Directo S/. 678,131.98 13.95% S/. 94,567.15 20.43%

Gastos Generales (10%) S/. 67,813.20 S/. 9,456.72Presupuesto total S/. 745,945.18 S/. 104,023.86

Page 11: Valorizaciones

AVANCE ACTUAL ACUMULADO TOTAL SALDOP TOTAL % CANTIDAD P TOTAL % CANTIDADS/. 1,601.48 87.11% S/. 10,967.63 12.89%

S/. 0.00 100.00% 125.00 S/. 1,058.75 0.00% 0.00S/. 0.00 100.00% 110.00 S/. 691.90 0.00% 0.00

S/. 775.88 100.00% 278.00 S/. 7,703.38 0.00% 0.00S/. 825.60 100.00% 220.00 S/. 1,513.60 0.00% 0.00

S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 109.48

S/. 48,665.40 92.16% S/. 81,561.40 7.84%S/. 1,012.70 100.00% 1680.00 S/. 13,087.20 0.00% 0.00S/. 2,950.20 100.00% 1680.00 S/. 15,019.20 0.00% 0.00

S/. 43,762.50 89.29% 1500.00 S/. 52,515.00 10.71% 180.00S/. 940.00 59.74% 200.00 S/. 940.00 40.26% 134.80

S/. 70,333.00 26.26% S/. 122,638.00 73.74%S/. 10,693.00 100.00% 13200.00 S/. 38,148.00 0.00% 0.00S/. 59,640.00 64.39% 8500.00 S/. 84,490.00 35.61% 4700.00

S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 13200.00S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 13200.00

S/. 0.00 0.00% S/. 0.00 100.00%S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 3410.00S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 3410.00

S/. 17,936.00 26.11% S/. 17,936.00 73.89%S/. 17,936.00 28.57% 800.00 S/. 17,936.00 71.43% 2000.00

S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 26.40S/. 138,535.88 34.37% S/. 233,103.03 65.63%

S/. 13,853.59 S/. 23,310.30S/. 152,389.47 S/. 256,413.33

Page 12: Valorizaciones

SALDOP TOTAL

S/. 1,622.49S/. 0.00S/. 0.00S/. 0.00S/. 0.00

S/. 1,622.49

S/. 6,935.36S/. 0.00S/. 0.00

S/. 6,301.80S/. 633.56

S/. 344,378.00S/. 0.00

S/. 46,718.00S/. 54,780.00

S/. 242,880.00

S/. 41,329.20S/. 30,690.00S/. 10,639.20

S/. 50,763.90S/. 44,840.00

S/. 5,923.90S/. 445,028.95

S/. 44,502.89S/. 489,531.84

Page 13: Valorizaciones

Item DescripciónMETRADO

Unidad CANTIDAD01.01.00 MOVIMIENTO DE TIERRAS Y DEMOLICIONES01.01.01 Demolición de Vereda existente M2 12501.01.02 Demolición de pavimentos de concreto de 4" M2 11001.01.03 Excavación a nivel de subrasante M3 27801.01.04 Relleno con material propio con equipo M3 22001.01.05 Eliminación de material Excedente M3 109.48

02.01.00 VEREDAS02.01.01 Compactación manual de subrasante M2 168002.01.02 Base e=0.1m (manual) M2 168002.01.03 losa de concreto f'c=210 kg/cm2 e=0.1 M2 168002.01.04 Sellado de juntas para veredas M 334.8

03.01.00 PAVIMENTO03.01.01 Conformación de la subrasante M2 1320003.01.02 Base e=0.20 M2 1320003.01.03 Imprimacióa asfáltica M2 1320003.01.04 Carpeta asfáltica en caliente, E=2" M2 13200

04.01.00 REPARACIÓN DE PAVIMENTO04.01.01 Carpeta asfáltica en caliente, E=1" M2 341004.01.02 Riego de liga M2 3410

05.01.00 SARDINELES Y OTROS05.01.01 Sardinel de vereda f'c=175 Kg/cm2 M 280005.01.02 Alcantarillas de PVC-SAP D=10" f'c=210 Kg/cm2 M 26.4

Costo DirectoGastos Generales (10%)

Presupuesto total

Page 14: Valorizaciones

PRESUPUESTO ACUMULADO ANTERIOR AVANCE ACTUALPU P TOTAL % CANTIDAD P TOTAL % CANTIDAD

S/. 12,590.12 87.11% S/. 10,967.63 12.89%8.47 S/. 1,058.75 100.00% 125.00 S/. 1,058.75 0.00%6.29 S/. 691.90 100.00% 110.00 S/. 691.90 0.00%

27.71 S/. 7,703.38 100.00% 278.00 S/. 7,703.38 0.00%6.88 S/. 1,513.60 100.00% 220.00 S/. 1,513.60 0.00%

14.82 S/. 1,622.49 0.00% 0.00 S/. 0.00 100.00% 109.48

S/. 88,496.76 92.16% S/. 81,561.40 7.84%7.79 S/. 13,087.20 100.00% 1680.00 S/. 13,087.20 0.00%8.94 S/. 15,019.20 100.00% 1680.00 S/. 15,019.20 0.00%

35.01 S/. 58,816.80 89.29% 1500.00 S/. 52,515.00 10.71% 180.00 4.7 S/. 1,573.56 59.74% 200.00 S/. 940.00 40.26% 134.80

S/. 467,016.00 26.26% S/. 122,638.00 53.46%2.89 S/. 38,148.00 100.00% 13200.00 S/. 38,148.00 0.00%9.94 S/. 131,208.00 64.39% 8500.00 S/. 84,490.00 35.61% 4,700.00 4.15 S/. 54,780.00 0.00% 0.00 S/. 0.00 68.18% 9,000.00 18.4 S/. 242,880.00 0.00% 0.00 S/. 0.00 68.18% 9,000.00

S/. 41,329.20 0.00% S/. 0.00 0.00%9 S/. 30,690.00 0.00% 0.00 S/. 0.00 0.00%

3.12 S/. 10,639.20 0.00% 0.00 S/. 0.00 0.00%

S/. 68,699.90 26.11% S/. 17,936.00 65.27%22.42 S/. 62,776.00 28.57% 800.00 S/. 17,936.00 71.43% 2,000.00

224.39 S/. 5,923.90 0.00% 0.00 S/. 0.00 0.00%Costo Directo S/. 678,131.98 34.37% S/. 233,103.03 44.69%

Gastos Generales (10%) S/. 67,813.20 S/. 23,310.30Presupuesto total S/. 745,945.18 S/. 256,413.33

Page 15: Valorizaciones

AVANCE ACTUAL ACUMULADO TOTAL SALDOP TOTAL % CANTIDAD P TOTAL % CANTIDADS/. 1,622.49 100.00% S/. 12,590.12 0.00%

S/. 0.00 100.00% 125.00 S/. 1,058.75 0.00% 0.00S/. 0.00 100.00% 110.00 S/. 691.90 0.00% 0.00S/. 0.00 100.00% 278.00 S/. 7,703.38 0.00% 0.00S/. 0.00 100.00% 220.00 S/. 1,513.60 0.00% 0.00

S/. 1,622.49 100.00% 109.48 S/. 1,622.49 0.00% 0.00

S/. 6,935.36 100.00% S/. 88,496.76 0.00%S/. 0.00 100.00% 1680.00 S/. 13,087.20 0.00% 0.00S/. 0.00 100.00% 1680.00 S/. 15,019.20 0.00% 0.00

S/. 6,301.80 100.00% 1680.00 S/. 58,816.80 0.00% 0.00S/. 633.56 100.00% 334.80 S/. 1,573.56 0.00% 0.00

S/. 249,668.00 79.72% S/. 372,306.00 20.28%S/. 0.00 100.00% 13200.00 S/. 38,148.00 0.00% 0.00

S/. 46,718.00 100.00% 13200.00 S/. 131,208.00 0.00% 0.00S/. 37,350.00 68.18% 9000.00 S/. 37,350.00 31.82% 4200.00

S/. 165,600.00 68.18% 9000.00 S/. 165,600.00 31.82% 4200.00

S/. 0.00 0.00% S/. 0.00 100.00%S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 3410.00S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 3410.00

S/. 44,840.00 91.38% S/. 62,776.00 8.62%S/. 44,840.00 100.00% 2800.00 S/. 62,776.00 0.00% 0.00

S/. 0.00 0.00% 0.00 S/. 0.00 100.00% 26.40S/. 303,065.85 79.07% S/. 536,168.88 20.93%

S/. 30,306.59 S/. 53,616.89S/. 333,372.44 S/. 589,785.77

Page 16: Valorizaciones

SALDOP TOTAL

S/. 0.00S/. 0.00S/. 0.00S/. 0.00S/. 0.00S/. 0.00

S/. 0.00S/. 0.00S/. 0.00S/. 0.00S/. 0.00

S/. 94,710.00S/. 0.00S/. 0.00

S/. 17,430.00S/. 77,280.00

S/. 41,329.20S/. 30,690.00S/. 10,639.20

S/. 5,923.90S/. 0.00

S/. 5,923.90S/. 141,963.10

S/. 14,196.31S/. 156,159.41

Page 17: Valorizaciones

Item DescripciónMETRADO

Unidad CANTIDAD01.01.00 MOVIMIENTO DE TIERRAS Y DEMOLICIONES01.01.01 Demolición de Vereda existente M2 12501.01.02 Demolición de pavimentos de concreto de 4" M2 11001.01.03 Excavación a nivel de subrasante M3 27801.01.04 Relleno con material propio con equipo M3 22001.01.05 Eliminación de material Excedente M3 109.48

02.01.00 VEREDAS02.01.01 Compactación manual de subrasante M2 168002.01.02 Base e=0.1m (manual) M2 168002.01.03 losa de concreto f'c=210 kg/cm2 e=0.1 M2 168002.01.04 Sellado de juntas para veredas M 334.8

03.01.00 PAVIMENTO03.01.01 Conformación de la subrasante M2 1320003.01.02 Base e=0.20 M2 1320003.01.03 Imprimacióa asfáltica M2 1320003.01.04 Carpeta asfáltica en caliente, E=2" M2 13200

04.01.00 REPARACIÓN DE PAVIMENTO04.01.01 Carpeta asfáltica en caliente, E=1" M2 341004.01.02 Riego de liga M2 3410

05.01.00 SARDINELES Y OTROS05.01.01 Sardinel de vereda f'c=175 Kg/cm2 M 280005.01.02 Alcantarillas de PVC-SAP D=10" f'c=210 Kg/cm2 M 26.4

Costo DirectoGastos Generales (10%)

Presupuesto total

Page 18: Valorizaciones

PRESUPUESTO ACUMULADO ANTERIOR AVANCE ACTUALPU P TOTAL % CANTIDAD P TOTAL % CANTIDAD

S/. 12,590.12 100.00% S/. 12,590.12 0.00%8.47 S/. 1,058.75 100.00% 125.00 S/. 1,058.75 0.00%6.29 S/. 691.90 100.00% 110.00 S/. 691.90 0.00%

27.71 S/. 7,703.38 100.00% 278.00 S/. 7,703.38 0.00%6.88 S/. 1,513.60 100.00% 220.00 S/. 1,513.60 0.00%

14.82 S/. 1,622.49 100.00% 109.48 S/. 1,622.49 0.00%

S/. 88,496.76 100.00% S/. 88,496.76 0.00%7.79 S/. 13,087.20 100.00% 1680.00 S/. 13,087.20 0.00%8.94 S/. 15,019.20 100.00% 1680.00 S/. 15,019.20 0.00%

35.01 S/. 58,816.80 100.00% 1680.00 S/. 58,816.80 0.00%4.7 S/. 1,573.56 100.00% 334.80 S/. 1,573.56 0.00%

S/. 467,016.00 79.72% S/. 372,306.00 20.28%2.89 S/. 38,148.00 100.00% 13200.00 S/. 38,148.00 0.00%9.94 S/. 131,208.00 100.00% 13200.00 S/. 131,208.00 0.00%4.15 S/. 54,780.00 68.18% 9000.00 S/. 37,350.00 31.82% 4,200.00 18.4 S/. 242,880.00 68.18% 9000.00 S/. 165,600.00 31.82% 4,200.00

S/. 41,329.20 0.00% S/. 0.00 100.00%9 S/. 30,690.00 0.00% 0.00 S/. 0.00 100.00% 3,410.00

3.12 S/. 10,639.20 0.00% 0.00 S/. 0.00 100.00% 3,410.00

S/. 68,699.90 91.38% S/. 62,776.00 8.62%22.42 S/. 62,776.00 100.00% 2800.00 S/. 62,776.00 0.00%

224.39 S/. 5,923.90 0.00% 0.00 S/. 0.00 100.00% 26.40 Costo Directo S/. 678,131.98 79.07% S/. 536,168.88 20.93%

Gastos Generales (10%) S/. 67,813.20 S/. 53,616.89Presupuesto total S/. 745,945.18 S/. 589,785.77

Page 19: Valorizaciones

AVANCE ACTUAL ACUMULADO TOTAL SALDOP TOTAL % CANTIDAD P TOTAL % CANTIDAD

S/. 0.00 100.00% S/. 12,590.12 0.00%S/. 0.00 100.00% 125.00 S/. 1,058.75 0.00% 0.00S/. 0.00 100.00% 110.00 S/. 691.90 0.00% 0.00S/. 0.00 100.00% 278.00 S/. 7,703.38 0.00% 0.00S/. 0.00 100.00% 220.00 S/. 1,513.60 0.00% 0.00S/. 0.00 100.00% 109.48 S/. 1,622.49 0.00% 0.00

S/. 0.00 100.00% S/. 88,496.76 0.00%S/. 0.00 100.00% 1680.00 S/. 13,087.20 0.00% 0.00S/. 0.00 100.00% 1680.00 S/. 15,019.20 0.00% 0.00S/. 0.00 100.00% 1680.00 S/. 58,816.80 0.00% 0.00S/. 0.00 100.00% 334.80 S/. 1,573.56 0.00% 0.00

S/. 94,710.00 100.00% S/. 467,016.00 0.00%S/. 0.00 100.00% 13200.00 S/. 38,148.00 0.00% 0.00S/. 0.00 100.00% 13200.00 S/. 131,208.00 0.00% 0.00

S/. 17,430.00 100.00% 13200.00 S/. 54,780.00 0.00% 0.00S/. 77,280.00 100.00% 13200.00 S/. 242,880.00 0.00% 0.00

S/. 41,329.20 100.00% S/. 41,329.20 0.00%S/. 30,690.00 100.00% 3410.00 S/. 30,690.00 0.00% 0.00S/. 10,639.20 100.00% 3410.00 S/. 10,639.20 0.00% 0.00

S/. 5,923.90 100.00% S/. 68,699.90 0.00%S/. 0.00 100.00% 2800.00 S/. 62,776.00 0.00% 0.00

S/. 5,923.90 100.00% 26.40 S/. 5,923.90 0.00% 0.00S/. 141,963.10 100.00% S/. 678,131.98 0.00%

S/. 14,196.31 S/. 67,813.20S/. 156,159.41 S/. 745,945.18

Page 20: Valorizaciones

SALDOP TOTAL

S/. 0.00S/. 0.00S/. 0.00S/. 0.00S/. 0.00S/. 0.00

S/. 0.00S/. 0.00S/. 0.00S/. 0.00S/. 0.00

S/. 0.00S/. 0.00S/. 0.00S/. 0.00S/. 0.00

S/. 0.00S/. 0.00S/. 0.00

S/. 0.00S/. 0.00S/. 0.00S/. 0.00S/. 0.00S/. 0.00

Page 21: Valorizaciones

IUSIMBOLO DESCRIPCION %

J mano de obra 47 0.135 100%A Asfalto 13 0.384 100%AT Agregado grueso 5 0.107 87.85%

Agregado fino 4 9.35%Tuberia PVC para agua 72 2.80%

C Cemento portlan tipo I 21 0.057 80.70%Acero de construccion liso 2 5.26%Madera nacional para encofrado 43 14.04%

E Maquinaria y equipo importado 49 0.164 87.90%Maquinaria y equipo nacional 48 8.28%Herramientas manuales 37 3.82%

GU Indice general de precios al consumidor 39 0.153 100%1

COEFICIENTE DE INCIDENCIA

Page 22: Valorizaciones

Io Ir KJul-12 Oct-12 Oct-12

448.25 470.79 0.1421697.48 1697.48 0.384

214.9 216.21 0.095724.59 724.59 0.01348.79 354.66 0.003339.42 339.42 0.046476.32 432.2 0.003559.82 566.4 0.008231.78 227.56 0.142327.55 324.3 0.013292.14 291.11 0.006

377.5 380.86 0.154K = 1.006

Page 23: Valorizaciones

IUSIMBOLO DESCRIPCION %

J mano de obra 47 0.135 100%A Asfalto 13 0.384 100%AT Agregado grueso 5 0.107 87.85%

Agregado fino 4 9.35%Tuberia PVC para agua 72 2.80%

C Cemento portlan tipo I 21 0.057 80.70%Acero de construccion liso 2 5.26%Madera nacional para encofrado 43 14.04%

E Maquinaria y equipo importado 49 0.164 87.90%Maquinaria y equipo nacional 48 8.28%Herramientas manuales 37 3.82%

GU Indice general de precios al consumidor 39 0.153 100%1

COEFICIENTE DE INCIDENCIA

Page 24: Valorizaciones

Io Ir KJul-12 Nov-12 Nov-12

448.25 470.79 0.1421697.48 1697.48 0.384

214.9 216.21 0.095724.59 724.59 0.01348.79 355.5 0.003339.42 339.42 0.046476.32 432.84 0.003559.82 566.27 0.008231.78 228.18 0.142327.55 324.97 0.013292.14 291.46 0.006

377.5 380.33 0.154K = 1.006

Page 25: Valorizaciones

IUSIMBOLO DESCRIPCION %

J mano de obra 47 0.135 100%A Asfalto 13 0.384 100%AT Agregado grueso 5 0.107 87.85%

Agregado fino 4 9.35%Tuberia PVC para agua 72 2.80%

C Cemento portlan tipo I 21 0.057 80.70%Acero de construccion liso 2 5.26%Madera nacional para encofrado 43 14.04%

E Maquinaria y equipo importado 49 0.164 87.90%Maquinaria y equipo nacional 48 8.28%Herramientas manuales 37 3.82%

GU Indice general de precios al consumidor 39 0.153 100%1

COEFICIENTE DE INCIDENCIA

Page 26: Valorizaciones

Io Ir KJul-12 Dec-12 Dec-12

448.25 470.79 0.1421697.48 1697.48 0.384

214.9 217.47 0.095724.59 724.59 0.01348.79 352.28 0.003339.42 339.42 0.046476.32 427.68 0.003559.82 567.05 0.008231.78 225.8 0.14327.55 323.01 0.013292.14 290.48 0.006

377.5 381.32 0.155K = 1.005

Page 27: Valorizaciones

IUSIMBOLO DESCRIPCION %

J mano de obra 47 0.135 100%A Asfalto 13 0.384 100%AT Agregado grueso 5 0.107 87.85%

Agregado fino 4 9.35%Tuberia PVC para agua 72 2.80%

C Cemento portlan tipo I 21 0.057 80.70%Acero de construccion liso 2 5.26%Madera nacional para encofrado 43 14.04%

E Maquinaria y equipo importado 49 0.164 87.90%Maquinaria y equipo nacional 48 8.28%Herramientas manuales 37 3.82%

GU Indice general de precios al consumidor 39 0.153 100%1

COEFICIENTE DE INCIDENCIA

Page 28: Valorizaciones

Io Ir KJul-12 Jan-13 Jan-13

448.25 471.44 0.1421697.48 1697.48 0.384

214.9 216.65 0.095724.59 721 0.01348.79 350.98 0.003339.42 339.42 0.046476.32 427.49 0.003559.82 569.4 0.008231.78 224.22 0.139327.55 321.94 0.013292.14 287.49 0.006

377.5 381.76 0.155K = 1.004

Page 29: Valorizaciones

IUSIMBOLO DESCRIPCION %

J mano de obra 47 0.135 100%A Asfalto 13 0.384 100%AT Agregado grueso 5 0.107 87.85%

Agregado fino 4 9.35%Tuberia PVC para agua 72 2.80%

C Cemento portlan tipo I 21 0.057 80.70%Acero de construccion liso 2 5.26%Madera nacional para encofrado 43 14.04%

E Maquinaria y equipo importado 49 0.164 87.90%Maquinaria y equipo nacional 48 8.28%Herramientas manuales 37 3.82%

GU Indice general de precios al consumidor 39 0.153 100%1

COEFICIENTE DE INCIDENCIA

Page 30: Valorizaciones

Io Ir KJul-12 Feb-13 Feb-13

448.25 471.44 0.1421697.48 1697.48 0.384

214.9 216.88 0.095724.59 733.24 0.01348.79 353.5 0.003339.42 339.42 0.046476.32 437.05 0.003559.82 570.99 0.008231.78 227.2 0.141327.55 323.59 0.013292.14 280.95 0.006

377.5 381.42 0.155K = 1.006

Page 31: Valorizaciones

Descripción Monto Contratado %

VALORIZACIÓN CONTRACTUAL S/. 745,945.18 100.00%Pavimento y Veredas S/. 745,945.18TOTAL CONTRACTUAL (V) S/. 745,945.18REAJUSTE ( R ) KPavimento y Veredas 1.006TOTAL REAJUSTE NETO (TOTAL DE R)DEDUCCIÓN POR ADELANTO DIRECTO (D)Pavimento y VeredasTOTAL REAJUSTE NETOVALORIZACIÓN BRUTA (VB=V+R-D)AMORTIZACIONES (A)AMORTIZACIONES POR ADELANTO DIRECTOTOTAL DE AMORTIZACIONESVALORIZACIÓN NETA (VN=VB-A)MONTO TOTAL

Page 32: Valorizaciones

Valoriz. Actual Val. Acum. Total % de Avance

0.00 S/. 19,099.47 19099.465 S/. 726,845.710.00 S/. 19,099.47 19099.465 2.56% S/. 726,845.71

0.00 S/. 114.60 S/. 114.600.00 S/. 114.60 114.59679

0.00 0.00 0.000.000.00 S/. 19,214.06 19214.06179

0.00 0.00 0.000.00 0.00 0.000.00 19214.061790.00 S/. 19,214.06

Val. Acum. Anterior

Saldo por Valorizar

Page 33: Valorizaciones

Descripción Monto Contratado %

VALORIZACIÓN CONTRACTUAL S/. 745,945.18 100.00%Pavimento y Veredas S/. 745,945.18TOTAL CONTRACTUAL (V) S/. 745,945.18REAJUSTE ( R ) KPavimento y Veredas 1.006TOTAL REAJUSTE NETO (TOTAL DE R)DEDUCCIÓN POR ADELANTO DIRECTO (D)Pavimento y VeredasTOTAL REAJUSTE NETOVALORIZACIÓN BRUTA (VB=V+R-D)AMORTIZACIONES (A)AMORTIZACIONES POR ADELANTO DIRECTOTOTAL DE AMORTIZACIONESVALORIZACIÓN NETA (VN=VB-A)MONTO TOTAL

Page 34: Valorizaciones

Valoriz. Actual Val. Acum. Total % de Avance

S/. 19,099.47 S/. 84,924.40 S/. 104,023.86 S/. 641,921.31S/. 19,099.47 S/. 84,924.40 S/. 104,023.86 13.95% S/. 641,921.31

S/. 114.60 S/. 509.55 S/. 624.14S/. 114.60 S/. 509.55 S/. 624.14

S/. 0.00 0.00 S/. 0.00

S/. 19,214.06 S/. 85,433.95 S/. 104,648.01

S/. 0.00 0.00 S/. 0.00S/. 0.00 0.00 S/. 0.00

S/. 19,214.06 85433.94640S/. 19,214.06 S/. 85,433.95

Val. Acum. Anterior

Saldo por Valorizar

Page 35: Valorizaciones

Descripción Monto Contratado %

VALORIZACIÓN CONTRACTUAL S/. 745,945.18 100.00%Pavimento y Veredas S/. 745,945.18TOTAL CONTRACTUAL (V) S/. 745,945.18REAJUSTE ( R ) KPavimento y Veredas 1.005TOTAL REAJUSTE NETO (TOTAL DE R)DEDUCCIÓN POR ADELANTO DIRECTO (D)Pavimento y VeredasTOTAL REAJUSTE NETOVALORIZACIÓN BRUTA (VB=V+R-D)AMORTIZACIONES (A)AMORTIZACIONES POR ADELANTO DIRECTOTOTAL DE AMORTIZACIONESVALORIZACIÓN NETA (VN=VB-A)MONTO TOTAL

Page 36: Valorizaciones

Valoriz. Actual Val. Acum. Total % de Avance

S/. 104,023.86 S/. 152,389.47 S/. 256,413.33 S/. 489,531.85S/. 104,023.86 S/. 152,389.47 S/. 256,413.33 34.37% S/. 489,531.85

S/. 624.14 S/. 761.95 S/. 1,386.09S/. 624.14 S/. 761.95 S/. 1,386.09

S/. 0.00 0.00 S/. 0.00

S/. 104,648.01 S/. 153,151.42 S/. 257,799.42

S/. 0.00 0.00 S/. 0.00S/. 0.00 0.00 S/. 0.00

153151.41534S/. 153,151.42

Val. Acum. Anterior

Saldo por Valorizar

Page 37: Valorizaciones

Descripción Monto Contratado %

VALORIZACIÓN CONTRACTUAL S/. 745,945.18 100.00%Pavimento y Veredas S/. 745,945.18TOTAL CONTRACTUAL (V) S/. 745,945.18REAJUSTE ( R ) KPavimento y Veredas 1.004TOTAL REAJUSTE NETO (TOTAL DE R)DEDUCCIÓN POR ADELANTO DIRECTO (D)Pavimento y VeredasTOTAL REAJUSTE NETOVALORIZACIÓN BRUTA (VB=V+R-D)AMORTIZACIONES (A)AMORTIZACIONES POR ADELANTO DIRECTOTOTAL DE AMORTIZACIONESVALORIZACIÓN NETA (VN=VB-A)MONTO TOTAL

Page 38: Valorizaciones

Valoriz. Actual Val. Acum. Total % de Avance

S/. 256,413.33 S/. 333,372.44 S/. 589,785.77 S/. 156,159.41S/. 256,413.33 S/. 333,372.44 S/. 589,785.77 79.07% S/. 156,159.41

S/. 1,386.09 S/. 1,333.49 S/. 2,719.58S/. 1,386.09 S/. 1,333.49 S/. 2,719.58

S/. 0.00 0.00 S/. 0.00

S/. 257,799.42 S/. 334,705.93 S/. 592,505.35

S/. 0.00 0.00 S/. 0.00S/. 0.00 0.00 S/. 0.00

334705.92872S/. 334,705.93

Val. Acum. Anterior

Saldo por Valorizar

Page 39: Valorizaciones

Descripción Monto Contratado %

VALORIZACIÓN CONTRACTUAL S/. 745,945.18 100.00%Pavimento y Veredas S/. 745,945.18TOTAL CONTRACTUAL (V) S/. 745,945.18REAJUSTE ( R ) KPavimento y Veredas 1.006TOTAL REAJUSTE NETO (TOTAL DE R)DEDUCCIÓN POR ADELANTO DIRECTO (D)Pavimento y VeredasTOTAL REAJUSTE NETOVALORIZACIÓN BRUTA (VB=V+R-D)AMORTIZACIONES (A)AMORTIZACIONES POR ADELANTO DIRECTOTOTAL DE AMORTIZACIONESVALORIZACIÓN NETA (VN=VB-A)MONTO TOTAL

Page 40: Valorizaciones

Valoriz. Actual Val. Acum. Total % de Avance

S/. 589,785.77 S/. 156,159.41 S/. 745,945.18 S/. 0.00S/. 589,785.77 S/. 156,159.41 S/. 745,945.18 100.00% S/. 0.00

S/. 2,719.58 S/. 936.96 S/. 3,656.54S/. 2,719.58 S/. 936.96 S/. 3,656.54

S/. 0.00 0.00 S/. 0.00

S/. 592,505.35 S/. 157,096.36 S/. 749,601.71

S/. 0.00 0.00 S/. 0.00S/. 0.00 0.00 S/. 0.00

157096.36203S/. 157,096.36

Val. Acum. Anterior

Saldo por Valorizar