Post on 06-Jul-2018
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
1/38
PRESUPUESTO ALTR. "1" A PRECIOS PRIVADOS
Items Descripcion Parcial S/
1.0 OBRAS PROVISIONALES 64,360.99
2.0 TRABAJOS PRELIMINARES 158,446.01
3.0 EXPLANACIONES 2,701,413.61
4.0 PAVIMENTO 1,207,752.66
5.0 OBRAS DE ARTE Y DRENAJE 1,600,007.70
6.0 REPOSICION DE TBERIA PVC SAP DE 4! "RIE#O$ 36,108.48
7.0 SE%ALI&ACION 51,214.23
8.0 MITI#ACION DEL IMPACTO AMBIENTAL 62,575.84
9.0 TRANSPORTE DE MATERIALES A OBRA 310,780.50
10.0 PREBAS DE CONTROL DE CALIDAD 36,200.00
COSTO DIRECTO 6,228,860.02EXPEDIENTE TECNICO "2,7'$ 168,179.22
#ASTOS #ENERALES "10'$ 622,886.00SPERVICION "3,0'$ 186,865.80LI(IDACION "1,0'$ 62,288.60
COSTO TOTAL 7,269,079.64
PRESUPUESTO ALTR. "2" A PRECIOS PRIVADOS
Items Descripcion Parcial S/
1.0 OBRAS PROVISIONALES 64,360.99
2.0 TRABAJOS PRELIMINARES 158,446.01
3.0 EXPLANACIONES 3,137,575.60
4.0 PAVIMENTO 1,393,564.20
5.0 OBRAS DE ARTE Y DRENAJE 1,600,007.70
6.0 REPOSICION DE TBERIA PVC SAP DE 4! "RIE#O$ 36,108.48
7.0 SE%ALI&ACION 51,214.23
8.0 MITI#ACION DEL IMPACTO AMBIENTAL 62,575.84
9.0 TRANSPORTE DE MATERIALES A OBRA 310,780.50
10.0 PREBAS DE CONTROL DE CALIDAD 36,200.00
COSTO DIRECTO 6,850,833.55
EXPEDIENTE TECNICO "2,7'$ 184,972.51#ASTOS #ENERALES "10'$ 685,083.36SPERVICION "3,0'$ 205,525.01LI(IDACION "1,0'$ 68,508.34
COSTO TOTAL 7,994,922.77
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
2/38
MANTENIMIENTO RUTINARIO SIN PROYECTO A PRECIOS PRIVADOS
OBRA:
LONGITUD VIA EXISTENTE
ITEM DESCRIPCION UND. CANT. P.U P.PARC.
1.00.01 Roce de malea! " l#m$#ea %a &&.'( 100.00 &)&'*.&+
1.00.0* L#m$#ea de $la,a-oma/deme!2 m( 1'1*.00 *.3* 4)(14.*4
1.00.0( Bac5eo m* *300.00 &4.00 1&0)000.00
1.00.04 Ta6!$o,e de ma,e#al a Oa m( 1100.00 (.** ()34*.00
Ga!,o! Ge6eale! /1072 1')43*.8+
Ga!,o! de S$e9#c#o6 /1.372 *)&1'.+(
TOTAL PRESUPUESTO SMANTENIMIENTO;MAm *0.'8 &'3.00 14)0*&.30
0*.04 Ta6!$o,e de ma,e#al a Oa m( 3&00.00 3.** *+)*(*.00
Ga!,o! Ge6eale! /1072 **)+30.83
Ga!,o! de S$e9#c#o6 /1.372 ()44*.&(
TOTAL PRESUPUESTO S
MANTENIMIENTO;MA
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
3/38
*0.'8 ;M
P.TOTAL
174528.93
1+4)3++.'&+)(&4.'&
*0.'8 ;M
P.TOTAL
229508.50
*33)+01.+8
1*)(14.8*
A
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
4/38
ALT. 01 MANTENIMIENTO RUTINARIO CON PROYECTO A PRECIOS PRIVAD
OBRA:
LONGITUD VIA EXISTENTE
ITEM DESCRIPCION UND. CANT. P.U
01.00 Obras de Limpieza y Mantenimiento
01.01 Roce de malea! " l#m$#ea %a &&.'( 100.00
01.0* L#m$#ea de $la,a-oma/deme!2 m( 1'1*.00 *.3*
01.0( Bac5eo m* 800.00 &4.00
01.04 Ta6!$o,e de ma,e#al a Oa m( 1300.00 (.**
02.00 Obras de Arte y Obras Comp. De drenaje
0*.01 L#m$#ea de Alca6,a#lla! 6d (+.00 141.13
0*.0* L#m$#ea de C6e,a! m (''+.00 *.(40*.0( L#m$#ea de ade6e! m* 84.00 (.30
Ga!,o! Ge6eale! /1072
Ga!,o! de S$e9#c#o6 /1.372
TOTAL PRESUPUESTO
MANTENIMIENTO;MAm *+.0& 3'.*+
0*.0* Bac5eo m* 1(00.00 &4.00
0*.0( Ta6!$o,e de ma,e#al a Oa m( (&00.00 3.**
03.00 Obras de Arte y Obras Comp. De drenaje
0(.01 L#m$#ea de Alca6,a#lla! 6d (+.00 141.13
0(.0* L#m$#ea de C6e,a! m (''+.00 *.(4
0(.0( L#m$#ea de ade6e! m* 84.00 (.30
Ga!,o! Ge6eale! /1072
Ga!,o! de S$e9#c#o6 /1.372
TOTAL PRESUPUESTO
ME?ORAMIENTO Y CONSTRUCCION DE LA TROC%A CARRO@ABLE COTABAMBAS%UACLLDISTRITO COTABAMBASCOTABAMBASAPURIMAC.
ME?ORAMIENTO Y CONSTRUCCION DE LA TROC%A CARRO@ABLE COTABAMBAS%UACLL
DISTRITO COTABAMBASCOTABAMBASAPURIMAC.
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
5/38
MANTENIMIENTO;MA
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
6/38
S
*+.0& ;M
P.PARC. P.TOTAL 1142
126
&)&'*.&+ 81658.64 1379 2400
4)(14.*4
31)*00.00
4)8(0.00
3)304.83
8)84*.8&*+4.00
8)1&3.8&
1)**4.88
S +1)04+.(8
S ()1((.13
S
*+.0& ;M
P.PARC. P.TOTAL
10,000.00 128298.56
1)&&4.83
8()*00.00
18)'+*.00
3)304.83
8)84*.8&
*+4.00
1*)8*+.8&
1*8)*+8.3&
S *&+)4*&.+'
TAMBUROA
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
7/38
S +)*'1.40
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
8/38
3779
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
9/38
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
10/38
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
11/38
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
12/38
ALT. 0* MANTENIMIENTO RUTINARIO CON PROYECTO A PRECIOS PRIVAD
OBRA:
LONGITUD VIA EXISTENTE
ITEM DESCRIPCION UND. CANT. P.U
01.00 Obras de Limpieza y Mantenimiento
01.01 Roce de malea! " l#m$#ea %a &&.'( 100.00
01.0* L#m$#ea de $la,a-oma/deme!2 m( 1+00.00 *.3*
01.0( Bac5eo m* +00.00 &4.00
01.04 Ta6!$o,e de ma,e#al a Oa m( 1300.00 (.**
02.00 Obras de Arte y Obras Comp. De drenaje
0*.01 L#m$#ea de Alca6,a#lla! 6d (+.00 141.13
0*.0* L#m$#ea de C6e,a! m (''+.00 *.(4
0*.0( L#m$#ea de ade6e! m* 84.00 (.30
Ga!,o! Ge6eale! /1072
Ga!,o! de S$e9#c#o6 /1.372
TOTAL PRESUPUESTO
MANTENIMIENTO;MAm *+.0& 3'.*+
0*.0* Bac5eo m* 1(30.00 &4.000*.0( Ta6!$o,e de ma,e#al a Oa m( (&00.00 3.**
03.00 Obras de Arte y Obras Comp. De drenaje
0(.01 L#m$#ea de Alca6,a#lla! 6d (+.00 141.13
0(.0* L#m$#ea de C6e,a! m (''+.00 *.(4
0(.0( L#m$#ea de ade6e! m* 84.00 (.30
Ga!,o! Ge6eale! /1072
Ga!,o! de S$e9#c#o6 /1.372
ME?ORAMIENTO Y CONSTRUCCION DE LA TROC%A CARRO@ABLE COTABAMBAS%UACLLDISTRITO COTABAMBASCOTABAMBASAPURIMAC.
ME?ORAMIENTO Y CONSTRUCCION DE LA TROC%A CARRO@ABLE COTABAMBAS%UACLLDISTRITO COTABAMBASCOTABAMBASAPURIMAC.
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
13/38
TOTAL PRESUPUESTO
MANTENIMIENTO;MA
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
14/38
S
*+.0& ;M
P.PARC. P.TOTAL 1142
111
126
&)&'*.&+ 88532.40 1379 2400
4)'88.00
3')&00.00
4)8(0.00
3)304.83
8)84*.8&
*+4.00
8)83(.*4
1)(*'.++
S +8)'1(.&(
S ()(+&.8+
S
*+.0& ;M
P.PARC. P.TOTAL
10,000.00 131498.56
1)&&4.83
8&)400.0018)'+*.00
3)304.83
8)84*.8&
*+4.00
1()14+.8&
1(1)4+8.3&
TAMBUROA
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
15/38
S *'&)14&.+'
S +)30*.&3
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
16/38
3779
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
17/38
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
18/38
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
19/38
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
20/38
AÑOS
COSTOS INCREMENTALES
INVERSION
2014 0 7,269,079.64 0.002015 1 194,599.76 91,049.382016 2 194,599.76 91,049.382017 3 255,901.98 269,426.972018 4 194,599.76 91,049.382019 5 194,599.76 91,049.382020 6 255,901.98 269,426.972021 7 194,599.76 91,049.382022 8 194,599.76 91,049.382023 9 255,901.98 269,426.97
2024 10 194,599.76 91,049.38
VALOR ACTUAL DE COSTOS TOTALES (11%) 6,853,212.90
AÑOS
COSTOS INCREMENTALES
INVERSION
2014 0 7,994,922.77 0.002015 1 194,599.76 98,713.632016 2 194,599.76 98,713.632017 3 255,901.98 276,146.972018 4 194,599.76 98,713.632019 5 194,599.76 98,713.632020 6 255,901.98 276,146.972021 7 194,599.76 98,713.632022 8 194,599.76 98,713.632023 9 255,901.98 276,146.97
2024 10 194,599.76 98,713.632,129,904.23
VALOR ACTUAL DE COSTOS TOTALES (11%) 7,622,628.15
COSTOS DEOER. !
MANT. SIN !
COSTOS DEMANT. RUT.
CON !
COSTOS DEMANT. ER.
CON !
COSTOS DEOER. !
MANT. SIN !
COSTOS DEMANT. RUT.
CON !
COSTOS DEMANT. ER.
CON !
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
21/38
7,269,079.64"103,550.37 5,815,263.71 5399396.97"103,550.37 6,178,717.70 5762850.95
13,524.99 6,542,171.68 6126304.94"103,550.37 6,905,625.66 6489758.92"103,550.37 7,269,079.64 6853212.9
13,524.99 7,632,533.63 7216666.88"103,550.37 7,995,987.61 7580120.87"103,550.37 8,359,441.59 7943574.85
13,524.99 8,722,895.57 8307028.83
"103,550.37
7,994,922.77"95,886.13 6,395,938.22 6023643.6"95,886.13 6,795,684.35 6423389.7320,244.99 7,195,430.49 6823135.87
"95,886.13 7,595,176.63 7222882.01"95,886.13 7,994,922.77 7622628.1520,244.99 8,394,668.91 8022374.29
"95,886.13 9,595,185.13 9222890.51"95,886.13 10,031,329.91 9659035.2920,244.99 10,467,474.69 10095180.1
"95,886.13
COSTOSINCREMENTALES
COSTOSINCREMENTALES
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
22/38
AÑOS
COSTOS INCREMENTALES
INVERSION
2014 0 5,742,572.92 0.002015 1 194,599.76 68,287.042016 2 194,599.76 68,287.042017 3 255,901.98 202,070.232018 4 194,599.76 68,287.042019 5 194,599.76 68,287.042020 6 255,901.98 202,070.232021 7 194,599.76 68,287.042022 8 194,599.76 68,287.042023 9 255,901.98 202,070.23
2024 10 194,599.76 68,287.04
VALOR ACTUAL DE COSTOS TOTALES (11%) 5,118,771.36
AÑOS
COSTOS INCREMENTALES
INVERSION
2014 0 6,315,988.99 0.002015 1 194,599.76 74,035.222016 2 194,599.76 74,035.222017 3 255,901.98 207,110.232018 4 194,599.76 74,035.222019 5 194,599.76 74,035.222020 6 255,901.98 207,110.232021 7 194,599.76 74,035.22
2022 8 194,599.76 74,035.222023 9 255,901.98 207,110.23
2024 10 194,599.76 74,035.22
VALOR ACTUAL DE COSTOS TOTALES (11%) 5,724,866.52
COSTOS DEOER. !
MANT. SIN !
COSTOS DEMANT. RUT.
CON !
COSTOS DEMANT. ER.
CON !
COSTOS DEOER. !
MANT. SIN !
COSTOS DEMANT. RUT.
CON !
COSTOS DEMANT. ER.
CON !
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
23/38
5,742,572.92 4594058.33459 3970256.78 3782524.72"126,312.72 4881186.9805 4257385.42 4003225.08"126,312.72 5168315.62641 4544514.07 4223925.44
"53,831.75 5455444.27233 4831642.72 4444625.8"126,312.72 5742572.91824 5118771.36 4665326.16"126,312.72 6029701.56415 5405900.01 4886026.52
"53,831.75 6316830.21006 5693028.65 5106726.88"126,312.72 6603958.85597 5980157.30 5327427.24"126,312.72 6891087.50189 6267285.95 5548127.6
"53,831.75
"126,312.72
6,315,988.99 5,052,791.19 4461668.73"120,564.54 5,368,590.64 4777468.17"120,564.54 5,684,390.09 5093267.62
"48,791.75 6,000,189.54 5409067.07"120,564.54 6,315,988.99 5724866.52"120,564.54 6,631,788.44 6040665.97
"48,791.75 6,947,587.89 6356465.42"120,564.54 7,263,387.34 6672264.87
"120,564.54 7,579,186.79 6988064.32"48,791.75
"120,564.54
COSTOSINCREMENTALES
COSTOSINCREMENTALES
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
24/38
Cantidad prod. Anual Cantidad prod anual com. Autoconsumo Perdidas
P)*) "+-$ 74,400.00 74,400.00 26,040.00 3,720.00
M)/ "+-$ 29,760.00 29,760.00 7,440.00 1,190.40
29,760.00 29,760.00 4,464.00 892.80
)) "+-$ 59,520.00 59,520.00 11,904.00 1,190.40
T"+-$ 29,760.00 29,760.00 4,464.00 1,785.60
:; S-: =-:)-
Descripcion Autoconsumo Perdidas Excedente de productor
Papa (kls) 35% 5% 60%
Maíz (kls) 25% % !5%
Ce"ada (kls) #5% 3% !5%
$a"a (kls) 20% 2% !%
&ri'o(kls) #5% 6% !!%
:; S-: =-:)-
Cantidad prod. Anual Cantidad prod anual com. Autoconsumo Perdidas
P)*) "+-$ 89,280.00 89,280.00 11,160.00 1,488.00
M)/ "+-$ 35,712.00 35,712.00 3,273.60 595.20
35,712.00 35,712.00 1,785.60 595.20
)) "+-$ 71,424.00 71,424.00 3,571.20 595.20
T"+-$ 35,712.00 35,712.00 1,488.00 297.60
:; S-: =-:)-
Descripcion Autoconsumo Perdidas Excedente de productor
Papa (kls) #3% 2% 5%
Maíz (kls) % 2% !0%
Ce"ada (kls) 5% 2% !0%
$a"a (kls) 5% #% 0%
&ri'o(kls) % #% 0%
:; S-: =-:)-
escripci*n
"+-$
escripci*n
C)>)"+-$
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
25/38
#$#&' *+-'' *+#-/+$
Años
2014 0 187,964.16 213,647.042015 1 187,964.16 213,647.04 9517502016 2 187,964.16 213,647.04 9517502017 3 187,964.16 213,647.04 9517502018 4 187,964.16 213,647.04 9517502019 5 187,964.16 213,647.04 9517502020 6 187,964.16 213,647.04 9517502021 7 187,964.16 213,647.04 9517502022 8 187,964.16 213,647.04 9517502023 9 187,964.16 213,647.04 951750
2024 10 187,964.16 213,647.04 951750
EVALUACION SOCIAL
Años Flujo
2014 0 5,742,572.92 0.00 "5,742,572.922015 1 "126,312.72 977,432.88 1,103,745.602016 2 "126,312.72 977,432.88 1,103,745.60
2017 3 "53,831.75 977,432.88 1,031,264.632018 4 "126,312.72 977,432.88 1,103,745.602019 5 "126,312.72 977,432.88 1,103,745.602020 6 "53,831.75 977,432.88 1,031,264.632021 7 "126,312.72 977,432.88 1,103,745.602022 8 "126,312.72 977,432.88 1,103,745.602023 9 "53,831.75 977,432.88 1,031,264.632024 10 "126,312.72 977,432.88 1,103,745.60
VALOR ACTUAL NETO A RECIOS SOCIALES (11%) 637,557.64 TASA INTERNA DE RETORNO 13.6%RELACION ENEICIOCOSTO 1.12
Años Flujo
2014 0 6,315,988.99 0.00 "6,315,988.992015 1 "120,564.54 977,432.88 1,097,997.422016 2 "120,564.54 977,432.88 1,097,997.422017 3 "48,791.75 977,432.88 1,026,224.632018 4 "120,564.54 977,432.88 1,097,997.42
Ingresos sinProyecto
Ingresos conProyecto
Ingresos conProyectoGanadero
costosincrementales
Ingresosincrementales
costosincrementales
Ingresosincrementales
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
26/38
2019 5 "120,564.54 977,432.88 1,097,997.422020 6 "48,791.75 977,432.88 1,026,224.632021 7 "120,564.54 977,432.88 1,097,997.422022 8 "120,564.54 977,432.88 1,097,997.422023 9 "48,791.75 977,432.88 1,026,224.632024 10 "120,564.54 977,432.88 1,097,997.42
VALOR ACTUAL NETO A RECIOS SOCIALES (11%) 31,462.48 TASA INTERNA DE RETORNO 11.1%RELACION ENEICIOCOSTO 1.01
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
27/38
Precio de +enta Costo de producci*n ,n'resos
44,640.00 1.80 0.60 53,568.00
22,320.00 1.70 0.60 24,552.00
22,320.00 1.25 0.42 18,525.60
46,425.60 1.80 0.45 62,674.56
22,915.20 1.80 0.55 28,644.00
1!#$%.1$
Precio de +enta Costo de producci*n ,n'resos
75,888.00 1.30 0.40 68,299.20
24,998.40 1.60 0.50 27,498.24
24,998.40 1.00 0.40 14,999.04
57,139.20 1.60 0.40 68,567.04
28,569.60 1.60 0.40 34,283.52
21&$%!.'%
-cedente de productor
-cedente de productor
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
28/38
0977,432.88977,432.88977,432.88977,432.88977,432.88977,432.88977,432.88977,432.88977,432.88
977,432.88
4594058.33459088 "4594058.33459 1,786,072.23 19.70%4881186.98050281 "4881186.9805 1,498,943.58 17.95%
5168315.62641474 "5168315.62641 1,211,814.94 16.37%5455444.27232667 "5455444.27233 924,686.29 14.92%5742572.9182386 "5742572.91824 637,557.64 13.60%
6029701.56415053 "6029701.56415 350,429.00 12.37%6316830.21006246 "6316830.21006 63,300.35 11.24%6603958.85597439 "6603958.85597 "223,828.29 10.18%6891087.50188632 "6891087.50189 "510,956.94 9.20%
5,052,791.19 "5052791.19064 16.85%5,368,590.64 "5368590.64006 15.21%5,684,390.09 "5684390.08947 13.73%6,000,189.54 "6000189.53889 12.37%
Ingresosincremental
es
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
29/38
6,315,988.99 "6315988.9883 11.12%6,631,788.44 "6631788.43772 9.96%6,947,587.89 "6947587.88713 8.89%7,263,387.34 "7263387.33655 7.90%7,579,186.79 "7579186.78596 6.96%
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
30/38
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
31/38
1679342.68302471458642.3226726
1237941.96232051017241.6019683796541.24161624575840.88126413355140.52091203134440.16055992"86260.19979218
1,294,660.28978,860.83663,061.38347,261.93
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
32/38
31,462.48"284,336.97"600,136.42"915,935.87
"1,231,735.31
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
33/38
AÑOS
COSTOS INCREMENTALES
INVERSION
2014 0 5,742,572.92 0.00
2015 1 194,599.76 68,287.042016 2 194,599.76 68,287.042017 3 255,901.98 202,070.232018 4 194,599.76 68,287.042019 5 194,599.76 68,287.042020 6 255,901.98 202,070.232021 7 194,599.76 68,287.042022 8 194,599.76 68,287.042023 9 255,901.98 202,070.23
2024 10 194,599.76 68,287.04
VALOR ACTUAL DE COSTOS TOTALES (11%) 5,118,771.36OLACION ENEICIARIA ROMEDIO 620.00
RATIO COSTOEECTIVIDAD S AITANTE 8,256.08&+ E$'-$#*'+ -'*$
AOS
COS!OS INC"E#EN!ALES
INVE"SION
2014 0 6,315,988.99 0.00
2015 1 194,599.76 74,035.22
2016 2 194,599.76 74,035.22
2017 3 255,901.98 207,110.23
2018 4 194,599.76 74,035.22
2019 5 194,599.76 74,035.22
2020 6 255,901.98 207,110.23
2021 7 194,599.76 74,035.22
2022 8 194,599.76 74,035.22
2023 9 255,901.98 207,110.23
2024 10 194,599.76 74,035.22
VALOR ACTUAL DE COSTOS TOTALES (11%) 5,724,866.52OLACION ENEICIARIA ROMEDIO 620.00
RATIO COSTOEECTIVIDAD S AITANTE 9,233.66&+ $ '-$# '+ -' $
COSTOS DEOER. ! MANT.
SIN !
COSTOS DEMANT. RUT.
CON !
COSTOS DEMANT. ER.
CON !
COS!OS $EOPE"% & #AN!%
SIN P&
COS!OS $E#AN!% "U!%
CON P&
COS!OS $E#AN!% PE"%
CON P&
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
34/38
5,742,572.92
"126,312.72"126,312.72
"53,831.75"126,312.72"126,312.72
"53,831.75"126,312.72"126,312.72
"53,831.75
"126,312.72
6,315,988.99
"120,564.54
"120,564.54
"48,791.75
"120,564.54
"120,564.54
"48,791.75
"120,564.54
"120,564.54
"48,791.75
"120,564.54
COSTOSINCREMENTALES
COS!OSINC"E#EN!ALES
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
35/38
RECIOS DE MERCADO RECIOS SOCIALES
CO INVERSION VACT CO INVERSION"20% 5,815,263.71 5,399,396.97 "20% 4,594,058.33"15% 6,178,717.70 5,762,850.95 "15% 4,881,186.98"10% 6,542,171.68 6,126,304.94 "10% 5,168,315.63
"5% 6,905,625.66 6,489,758.92 "5% 5,455,444.270% 7,269,079.64 6,853,212.90 0% 5,742,572.925% 7,632,533.63 7,216,666.88 5% 6,029,701.56
10% 7,995,987.61 7,580,120.87 10% 6,316,830.2115% 8,359,441.59 7,943,574.85 15% 6,603,958.8620% 8,722,895.57 8,307,028.83 20% 6,891,087.50
CO INVERSION VACT CO INVERSION
"20% 6,395,938.22 6,023,643.60 "20% 5,052,791.19
"15% 6,795,684.35 6,423,389.73 "15% 5,368,590.64"10% 7,195,430.49 6,823,135.87 "10% 5,684,390.09"5% 7,595,176.63 7,222,882.01 "5% 6,000,189.540% 7,994,922.77 7,622,628.15 0% 6,315,988.995% 8,394,668.91 8,022,374.29 5% 6,631,788.44
10% 9,595,185.13 9,222,890.51 10% 6,947,587.8915% 10,031,329.91 9,659,035.29 15% 7,263,387.3420% 10,467,474.69 10,095,180.07 20% 7,579,186.79
"20% "15% "10% "5% 0% 5% 10% 15
"1,500,000
"1,000,000
"500,000
0
500,000
1,000,000
1,500,000
2,000,000
ANALISIS $E SENSI'ILI$A$
VANPS Py ( VANPS Py )
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
36/38
VACT TIRS 1 VANS 1
3,970,256.78 19.70% 1,786,072.23 3531205.765633684,257,385.42 17.95% 1,498,943.58 3751906.125985794,544,514.07 16.37% 1,211,814.94 3972606.48633789
4,831,642.72 14.92% 924,686.29 4193306.846695,118,771.36 13.60% 637,557.64 4414007.20704215,405,900.01 12.37% 350,429.00 4634707.567394215,693,028.65 11.24% 63,300.35 4855407.927746315,980,157.30 10.18% "223,828.29 5076108.288098426,267,285.95 9.20% "510,956.94 5296808.64845052
VACT TIRS 2 VANS 2
4,461,668.73 16.85% 1,294,660.28 3,916,166.50
4,777,468.17 15.21% 978,860.83 4,160,926.915,093,267.62 13.73% 663,061.38 4,405,687.325,409,067.07 12.37% 347,261.93 4,650,447.725,724,866.52 11.12% 31,462.48 4,895,208.136,040,665.97 9.96% "284,336.97 5,139,968.536,356,465.42 8.89% "600,136.42 5,384,728.946,672,264.87 7.90% "915,935.87 5,629,489.356,988,064.32 6.96% "1,231,735.31 5,874,249.75
20%
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
37/38
I,em! De!c#$c#o6 Ao 0
M 1 M * M ( M 4 M 3 M & M ' M 8
1.0 OBRAS PROVISIONALES
2.0 TRABAJOS PRELIMINARES
3.0 EXPLANACIONES
4.0 PAVIMENTO5.0 OBRAS DE ARTE Y DRENAJE
6.0 REPOSICION DE TBERIA PVC SAP DE 4! "RIE#O$
7.0 SE%ALI&ACION
8.0 MITI#ACION DEL IMPACTO AMBIENTAL
9.0 TRANSPORTE DE MATERIALES A OBRA
10.0 PREBAS DE CONTROL DE CALIDAD
11.0 EXPEDIENTE TECNICO "2,7'$
12.0 #ASTOS #ENERALES "10'$
13.0 SPERVICION "3,0'$14.0 LI(IDACION "1,0'$
15.0 OPERACI?N Y MANTENIMIENTO
8/17/2019 HOJA DE CALCULO PARA PIP CARRETERA
38/38
Ao1 Ao* Ao( Ao4 Ao3 Ao& Ao' Ao8 Ao+ Ao 10