hoja de calculo para pip carretera

Upload: hugo

Post on 06-Jul-2018

243 views

Category:

Documents


6 download

TRANSCRIPT

  • 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