Evaluacion Final Mullipampa

download Evaluacion Final Mullipampa

of 49

description

009

Transcript of Evaluacion Final Mullipampa

Hoja1

DATOS DE DISEO

Poblacin ActualNmero de Viviendas=65viv.Densidad Poblacional=5hab/viv.Poblacin Actual=Nviv * DpPa=325hab.

Poblacin FuturaTasa de Crecimiento=24.9%o2.49% segn ineiPeriodo de diseo=20aosPoblacin Futura=(1+Tasa)*Td*Pa =486.85Pf=487hab.

DotacinSegn Normas del Ministerio de Salud tenemos D =60 lt/hab/daPara nuestro caso tenemos D =60 lt/hab/daGasto Promedio Diario=QP = 0.80 CpCp=D * Pf86400Cp=0.28lps.Qp=0.23lps.

Gasto Mximo Diario=Qmd = 1.20 QpQmd=0.27lps.

Gasto Mximo Horario=Qmh = 3.50 QpQmh=0.789lps.

Caudal por infiltracin de Tubera=Qit = 20.000*Ltub.86400Long. Tubera=746.46ml.Qit=0.173lps.

Caudal por infiltracin por buzones=Qib = 380*Nbuzones.86400N buzones=24und.Qib=0.106lps.

Caudal de diseo (Qd)Qd = Qmh + Qit + QibQd=1.067lps.

Qd=92.21m3/da

INFORMACION BASICATABLA DE INGRESO DE DATOS

PROY:MEJORAMIENTO YAMPLIACION DE LOS SISTEMAS DE AGUA EN LA LOCALIDAD CRUZPAMPA -DISTRITO ANGASMARCA - PROVINCIA DE SANTIAGO DE CHUCO - LA LIBERTAD

ITEMPARA SISTEMA DE AGUA POTABLEUNDSIN PROYECTOCON PROYECTOAGUA POTABLEiPoblacion Actualhab325325iiTasa de Crecimiento de Poblacion%2.49%2.49%iiiDensidad por Lote hab/viv5.005.00ivPoblacion servida con conexioneshab0325vPoblacion servida con piletashab00viCobertura de servicioCon Conexin%0.00%100.00%Con Pileta%0.00%0.00%viiDotacion Per Capita Lt/hab/dia060Dotacion por pileta Lts/pileta00viiiPerdidas de agua%0.00%20.00%ixMicromedicion%0.00%0.00%K1 Demanda maxima diaria1.301.30K2 Demanda maxima horaria2.002.00Numero de familias por pileta Sin Proy11

SANEAMIENTOSin ProyectoCon ProyectoPOBLACIN ACTUAL (habitantes)113113TASA CRECIMIENTO ANUAL DE POBLACIONAL (%) (1)0.50%0.50%DENSIDAD POR LOTE (hab/lote) (2)4.004.00DOTACIN POR MEDIO DE CONEXIONES (litros / habitante - dia) (3)120120DOTACIN POR MEDIO DE PILETAS (litros / habitante - dia) (4)00N DE FAMILIAS POR PILETAS (5)00APORTE DE AGUAS RESIDUALES (6)80%80%POBLACIN ACTUAL CON CONEXIONES AGUA (red pblica)00POBLACIN ACTUAL CON PILETAS 00POBLACIN ACTUAL CON CONEXIONES ALCANTARILLADO (red pblica)00.00(1)(Proyeccin INEI)(2)(Informacin INEI y/o Determinado por la UF)(3)(Reglamento)(4)(Reglamento)(5)(Estimado)(6)(Reglamento Nacional de Construcciones)(7)(Estimado)

DATOS BASICOS-DEMANDA AGUA

Informacin para Proyectar la Demanda de Agua Potable

AOSPOBLACION PROYECTADACOBERTURA DE AGUA %PERDIDAS DE AGUA %MICROMEDICIONCOBERTURA DESAGUE %CONEXIONESPILETASPORPILETASCONEXIONESLETRINASAGUApoblacion03250.00%0.00%0.00%0%0.000.00%CONEX NUEV01333100.00%0.00%20.00%0%100.00%100.00%382.21184.0182341100.00%0.00%20.00%0.00%100.00%100.00%TOTAL84.0183350100.00%0.00%20.00%0.00%100.00%100.00%%25.854359100.00%0.00%20.00%0.00%100.00%100.00%5368100.00%0.00%20.00%0.00%100.00%100.00%DESAGUE06377100.00%0.00%20.00%0.00%100.00%100.00%925.78531.767386100.00%0.00%20.00%0.00%100.00%100.00%531.768396100.00%0.00%20.00%0.00%100.00%100.00%%163.629406100.00%0.00%20.00%0.00%100.00%100.00%10416100.00%0.00%20.00%0.00%100.00%100.00%11426100.00%0.00%20.00%0.00%100.00%100.00%12437100.00%0.00%20.00%0.00%100.00%100.00%13447100.00%0.00%20.00%0.00%100.00%100.00%202.0214459100.00%0.00%20.00%0.00%100.00%100.00%15470100.00%0.00%20.00%0.00%100.00%100.00%16482100.00%0.00%20.00%0.00%100.00%100.00%17494100.00%0.00%20.00%0.00%100.00%100.00%13320018506100.00%0.00%20.00%0.00%100.00%100.00%19519100.00%0.00%20.00%0.00%100.00%100.00%20532100.00%0.00%20.00%0.00%100.00%100.00%CONEXIONES111090999200ACUMUL0.968421052618.02200.02240EXISTEN160AO 1

PROYECION DEMANDA AGUA

CALCULO DE LA DEMANDA DE AGUA POTABLE

Proy:"MEJORAMIENTO Y AMPLIACIN DEL SISTEMA DE AGUA POTABLE DEL CASERO CRUZ PAMPA ALTA, DISTRITO DE ANGASMARCA SANTIAGO DE CHUCO - LA LIBERTAD"

AOPOBLACIONCOBERTURA DE AGUA (%)POBLACION SERVIDAVIVIENDAS SERVIDASN NCONSUMO DIARIO AGUA (Lts/Seg)CONSUMO DE AGUAPrdidas de aguaDemanda de Produccin de AguaDemanda Max. DiariaDemanda Max. HorariaVolumen almacenamiento *CONEXPILETASOTROSCONEXPILETASTOTAL%CONEXPILETASTOTALCONEXPILETASCONEXPILETASlitro/diam3/aol/seglitro/diam3/aol/seg* Para poblaciones Mayores de 10000 habitantes(1)(2)(3)(4)(5)(6)(7)(8)(9)(10)(11)(12)(13)(14)(15)(16)(17)(18)(19)(20)(21)lt/seglt/segm3 considerar 216 m3 para incendio

03250.00%0.00%0.00%0000.0000000.0000000.000%000.000.000.000.0001333100.00%0.00%0.00%3330333100.006700670.0019,986019,9867,2950.2320%24,9829,1180.290.380.586.8702341100.00%0.00%0.00%3410341100.006800680.0020,483020,4837,4760.2420%25,6049,3450.300.390.597.0413350100.00%0.00%0.00%3500350100.007000700.0020,993020,9937,6630.2420%26,2429,5780.300.390.617.2164359100.00%0.00%0.00%3590359100.007200720.0021,516021,5167,8530.2520%26,8959,8170.310.400.627.3965368100.00%0.00%0.00%3680368100.007400740.0022,052022,0528,0490.2620%27,56510,0610.320.410.647.5806377100.00%0.00%0.00%3770377100.007500750.0022,601022,6018,2490.2620%28,25110,3120.330.430.657.7697386100.00%0.00%0.00%3860386100.007700770.0023,164023,1648,4550.2720%28,95410,5680.340.440.677.9628396100.00%0.00%0.00%3960396100.007900790.0023,740023,7408,6650.2720%29,67510,8320.340.450.698.1619406100.00%0.00%0.00%4060406100.008100810.0024,331024,3318,8810.2820%30,41411,1010.350.460.708.36410416100.00%0.00%0.00%4160416100.008300830.0024,937024,9379,1020.2920%31,17211,3780.360.470.728.57211426100.00%0.00%0.00%4260426100.008500850.0025,558025,5589,3290.3020%31,94811,6610.370.480.748.78612437100.00%0.00%0.00%4370437100.008700870.0026,195026,1959,5610.3020%32,74311,9510.380.490.769.00413447100.00%0.00%0.00%4470447100.008900890.0026,847026,8479,7990.3120%33,55912,2490.390.500.789.22914459100.00%0.00%0.00%4590459100.009200920.0027,515027,51510,0430.3220%34,39412,5540.400.520.809.45815470100.00%0.00%0.00%4700470100.009400940.0028,201028,20110,2930.3320%35,25112,8660.410.530.829.69416482100.00%0.00%0.00%4820482100.009600960.0028,903028,90310,5490.3320%36,12813,1870.420.540.849.93517494100.00%0.00%0.00%4940494100.009900990.0029,622029,62210,8120.3420%37,02813,5150.430.560.8610.18318506100.00%0.00%0.00%5060506100.00101001010.0030,360030,36011,0810.3520%37,95013,8520.440.570.8810.43619519100.00%0.00%0.00%5190519100.00104001040.0031,116031,11611,3570.3620%38,89514,1970.450.590.9010.69620532100.00%0.00%0.00%5320532100.00106001060.0031,891031,89111,6400.3720%39,86314,5500.460.600.9210.962510,01014,5500.4610.962AOPOBLACIONAO(1)01234567891011121314151617181920POBLACION(2)113114114115115116116117118118119119120121121122122123124124125(1)(2)01131113.5652114.1328253114.7034891254115.27700657065115.85339160356116.43265856157117.01482185438117.59989596369118.187895443410118.778834920611119.372729095212119.969592740713120.569440704414121.172287907915121.778149347516122.387040094217122.998975294718123.613970171119124.23204002220124.8532002221

DEMANDAALCANTDEMANDA DE SANEAMIENTO

Ao (1)Poblacion hab (2)Cobertura % (3)Cobertura Letrinas % (3B)Poblacion Servida Habitantes (4)N Letrinas (5)Consumo promedio de agua (l/dia) (6)Demanda de DesagueCronog Conex

Lts/dia (7)m3/ao (8)

03250.00%0%0012000.0013330.00%100%333676015,9885,835.786723410.00%100%341686016,3875,981.09233500.00%100%350706016,7956,130.02243590.00%100%359726017,2136,282.66253680.00%100%368746017,6416,439.10263770.00%100%377756018,0816,599.43273860.00%100%386776018,5316,763.76283960.00%100%396796018,9926,932.17294060.00%100%406816019,4657,104.782104160.00%100%416836019,9507,281.692114260.00%100%426856020,4477,463.012124370.00%100%437876020,9567,648.842134470.00%100%447896021,4787,839.292144590.00%100%459926022,0128,034.492154700.00%100%470946022,5608,234.552164820.00%100%482966023,1228,439.592174940.00%100%494996023,6988,649.742185060.00%100%5061016024,2888,865.112195190.00%100%5191046024,8939,085.863205320.00%100%5321066025,5139,312.093lts/seg0.3016OFERTA DEL SISTEMA EXISTENTE DE AGUAAO2,007POBLACIN TOTALHAB.325% DE POB. SERVIDA CON CONEXIN%0.00%POBLACIN SERVIDAHAB.0% COBERTURA DEL SERVICIO%0.00%CONSUMO POR CONEXIN (SIN PROYECTO)LT/HAB/DIA0CONSUMO TOTALLT/DIA0NUMERO DE CONEXIONES CONEX.0HORAS DE SERVICIOHORAS6CAPACIDAD DE ALMACENAMIENTO ( *)M3ERROR:#REF!PORCENTAJE DE PERDIDAS%0.00%

OFERTA DEMANDAOFERTA & DEMANDA DE AGUA

Oferta de Fuente de CaptacionCON PROYECTOSIN PROYECTOCAPTACIONESLts/SegLts/SegEstado de Conservacion

Manantial0.510.00REGULAROtros0

TOTAL0.510.00TOTAL DE OFERTA 0.510.00LTS/SEGTOTAL OFERTA ANUAL16,083.360.00M3/AOOferta de almacenamientoRESERVORIOSVOLUMEN M3VOLUMEN M3Estado de conservacion

RESERVORIO 1150PROYECTADO

TOTAL OFERTA150BALANCE OFERTA DEMANDA DE AGUA POTALE SIN PROYECTOEn miles de m3/aoAoOfertaDemandaBalance00.000.000.0010.009.12-9.1220.009.35-9.3530.009.58-9.5840.009.82-9.8250.0010.06-10.0660.0010.31-10.3170.0010.57-10.5780.0010.83-10.8390.0011.10-11.10100.0011.38-11.38110.0011.66-11.66120.0011.95-11.95130.0012.25-12.25140.0012.55-12.55150.0012.87-12.87160.0013.19-13.19170.0013.52-13.52180.0013.85-13.85190.0014.20-14.20200.0014.55-14.55BALANCE OFERTA DEMANDA DE AGUA POTALE CON PROYECTO

En miles de m3/aoAoOfertaDemandaBalance016.080.0016.08116.089.126.96216.089.356.74316.089.586.51416.089.826.27516.0810.066.02616.0810.315.77716.0810.575.51816.0810.835.25916.0811.104.981016.0811.384.711116.0811.664.421216.0811.954.131316.0812.253.831416.0812.553.531516.0812.873.221616.0813.192.901716.0813.522.571816.0813.852.231916.0814.201.892016.0814.551.53OFERTA & DEMANDA DE ALMACENAMIENTO

En miles de m3SIN PROYECTOCON PROYECTOAoOfertaDemandaBalanceOfertaDemandaBalance00.000.000.0015.000.0015.0010.006.87-6.8715.006.878.1320.007.04-7.0415.007.047.9630.007.22-7.2215.007.227.7840.007.40-7.4015.007.407.6050.007.58-7.5815.007.587.4260.007.77-7.7715.007.777.2370.007.96-7.9615.007.967.0480.008.16-8.1615.008.166.8490.008.36-8.3615.008.366.64100.008.57-8.5715.008.576.43110.008.79-8.7915.008.796.21120.009.00-9.0015.009.006.00130.009.23-9.2315.009.235.77140.009.46-9.4615.009.465.54150.009.69-9.6915.009.695.31160.009.94-9.9415.009.945.06170.0010.18-10.1815.0010.184.82180.0010.44-10.4415.0010.444.56190.0010.70-10.7015.0010.704.30200.0010.96-10.9615.0010.964.04

OFERTA & DEMANDA DE ALCANTARILLADO

En miles de m3/aoSIN PROYECTOCON PROYECTOAoOfertaDemandaBalanceOfertaDemandaBalance0000931209,312105,836-5,83693125,8363,476205,981-5,98193125,9813,331306,130-6,13093126,1303,182406,283-6,28393126,2833,029506,439-6,43993126,4392,873606,599-6,59993126,5992,713706,764-6,76493126,7642,548806,932-6,93293126,9322,380907,105-7,10593127,1052,2071007,282-7,28293127,2822,0301107,463-7,46393127,4631,8491207,649-7,64993127,6491,6631307,839-7,83993127,8391,4731408,034-8,03493128,0341,2781508,235-8,23593128,2351,0781608,440-8,44093128,4408731708,650-8,65093128,6506621808,865-8,86593128,8654471909,086-9,08693129,0862262009,312-9,31293129,3120

CALCULO DE FACTORES

DETERMINACION DE PRECIOS SOCIALES

ALTERNATIVA UNICADESCRIPCIONAGUA POTABLECAPACITACION SANITARIASISTEMA DE AGUA POTABLEP. PRIVADOSP. SOCIALESP. PRIVADOSP. SOCIALESCODGDESCRIPCIONINVERSION A PRECIOS PRIVADOS%FACTOR DE CORRECCIONINVERSION A PRECIOS SOCIALESCOSTO DIRECTO524,150.36420,368.591,550.001,243.10GASTOS GENERALES 10%52,415.0442,036.86155.00124.311MANO DE OBRA0.00UTILIDADES 7%36,690.5329,425.80108.5087.021.1CALIFICADA0.00%0.9090.00523,723.18SUB TOTAL613,255.93491,831.251,813.501,454.431.2NO CALIFICADA0.00%0.4900.00IGV 18%110,386.0788,529.63326.43261.802MATERIALES0.00%0.8400.00COSTO OBRA723,641.99580,360.882,139.931,716.223EQUIPOS - HERRAMIENTAS0.00%0.8400.00G. Adm y estudios 3% 15,724.5112,611.0646.5037.290.00%Supervisin 5%26,207.5221,018.4377.5062.16COSTO DIRECTO0.000.00893,564.66COSTO POR COMPONENTE765,574.02613,990.372,263.931,815.67COSTO DEL PROYECTO767,837.95

SISTEMA DE ALCANTARILLADO893,564.66

CODGDESCRIPCIONINVERSION A PRECIOS PRIVADOS%FACTOR DE CORRECCIONINVERSION A PRECIOS SOCIALES0.80

1MANO DE OBRA45,975.7931,774.791.1CALIFICADA22,068.3814.40%0.90920,060.16255,485.00DESCRIPCIONPRECIOS PRIVADOSCOSTOS SOCIALES1.2NO CALIFICADA23,907.4115.60%0.49011,714.632MATERIALES76,626.3250.00%0.84064,366.11255,485.00AGUA POTABLE765,574.02613,990.373EQUIPOS - HERRAMIENTAS30,650.5320.00%0.84025,746.45CAPACITACION2,263.931,815.670.00100.00%850,271.73TOTAL767,837.95615,806.04COSTO DIRECTO153,252.65121,887.35773,645.41

PLANTA DE TRATAMIENTO ALTERNATIVA N 01

CODGDESCRIPCIONINVERSION A PRECIOS PRIVADOS%FACTOR DE CORRECCIONINVERSION A PRECIOS SOCIALES

1MANO DE OBRA30,650.5321,183.191.1CALIFICADA14,712.2614.40%0.90913,373.44111,273.001.2NO CALIFICADA15,938.2715.60%0.4907,809.752MATERIALES51,084.2250.00%0.84042,910.743EQUIPOS - HERRAMIENTAS20,433.6920.00%0.84017,164.300.00100.00%257,055.66COSTO DIRECTO102,168.4381,258.23125,348.97

ALTERNATIVA N 02

SISTEMA DE AGUA POTABLECODGDESCRIPCIONINVERSION A PRECIOS PRIVADOS%FACTOR DE CORRECCIONINVERSION A PRECIOS SOCIALES

1MANO DE OBRA0.0000.001.1CALIFICADA0.0000.00%0.9090.00255,485.001.2NO CALIFICADA0.0000.00%0.4900.002MATERIALES0.0000.00%0.8400.003EQUIPOS - HERRAMIENTAS0.0000.00%0.8400.000.00%COSTO DIRECTO0.000.00

SISTEMA DE ALCANTARILLADO

CODGDESCRIPCIONINVERSION A PRECIOS PRIVADOS%FACTOR DE CORRECCIONINVERSION A PRECIOS SOCIALES

1MANO DE OBRA45,975.7931,774.791.1CALIFICADA22,068.3814.40%0.90920,060.16352,838.931.2NO CALIFICADA23,907.4115.60%0.49011,714.632MATERIALES76,626.3250.00%0.84064,366.11352,838.933EQUIPOS - HERRAMIENTAS30,650.5320.00%0.84025,746.45100.00%COSTO DIRECTO153,252.65121,887.35

PLANTA DE TRATAMIENTO ALTERNATIVA N 02

CODGDESCRIPCIONINVERSION A PRECIOS PRIVADOS%FACTOR DE CORRECCIONINVERSION A PRECIOS SOCIALES

1MANO DE OBRA40,619.1631,029.791.1CALIFICADA19,497.2014.40%0.90917,722.951.2NO CALIFICADA21,121.9615.60%0.63013,306.832MATERIALES67,698.6050.00%0.84056,866.823EQUIPOS - HERRAMIENTAS27,079.44020.00%0.84022,746.73100.00%COSTO DIRECTO135,397.20110,643.34

ALTERNATIVA 1: ALTERNATIVA 2: SISTEMA DE AGUA POTABLESISTEMA DE AGUA POTABLE

ITEMDESCRIPCIONCOSTO DIRECTOITEMDESCRIPCIONCOSTO DIRECTO1.00OBRAS PROVICIONALES0.001.00OBRAS PROVICIONALES0.002.00CONSTRUCCION DE CAPTACION0.002.00CONSTRUCCION DE CAPTACION0.003.00LINEA DE CONDUCCION0.003.00LINEA DE CONDUCCION0.004.00FILTRO GRUESO DINAMICO0.004.00FILTRO GRUESO DINAMICO0.005.00FILTRO LENTO DE ARENA0.005.00FILTRO LENTO DE ARENA0.006.00LINEA DE ADUCC-RED DIST.0.006.00LINEA DE ADUCC-RED DIST.0.007.00CONEXIONES DOMICILIARIAS0.007.00CONEXIONES DOMICILIARIAS0.008.00CONSTRUCCION DE RESERVORIO0.008.00CONSTRUCCION DE RESERVORIO0.000.000.001.00VARIOS0.001.00VARIOS0.002.00CAPACITACION BASICA. A TECNICOS 0.002.00CAPACITACION BASICA. A TECNICOS 0.00Y ADMINISTRATIVOS0.00Y ADMINISTRATIVOS0.003.00IMPACTO AMBIENTAL0.003.00IMPACTO AMBIENTAL0.00COSTO DIRECTO0.00COSTO DIRECTO0.00SISTEMA DE ALCANTARILLADO SISTEMA DE ALCANTARILLADOITEMDESCRIPCIONCOSTO DIRECTOITEMDESCRIPCIONCOSTO DIRECTO1.00TRABAJOS PRELIMINARES15,413.711.00TRABAJOS PRELIMINARES15,413.712.00MOVIMIENTO DE TIERRAS45,008.482.00MOVIMIENTO DE TIERRAS45,008.483.00OBRAS DE CONCRETO SIMPLE10,926.003.00OBRAS DE CONCRETO SIMPLE10,926.004.00OBRAS DE CONCRETO ARMADO16,894.454.00OBRAS DE CONCRETO ARMADO16,894.455.00TUBERIAS49,992.005.00TUBERIAS49,992.006.00CONEXIONES DOMICILIARIAS12,498.006.00CONEXIONES DOMICILIARIAS12,498.007.00OTROS 2,520.007.00OTROS INCLUYE LETRINAS2,520.00COSTO DIRECTO153,252.65COSTO DIRECTO153,252.65

PLANTA DE TRATAMIENTOPLANTA DE TRATAMIENTOLAGUNA DE OXIDACIONITEMDESCRIPCIONCOSTO DIRECTOITEMDESCRIPCIONCOSTO DIRECTO288,649.851.00OBRAS PRELIMINARES10,275.801.00TANQUE SEPTICO ( 02 UNIDADES)72,992.000.53092925342.00MOVIMIENTO TIERRAS30,005.602.00POZO PERCOLADOR ( 6 UNIDADES)27,673.903.00OBRAS CONCRETO SIMPLE Y ARMADO18,546.893.00CAJA DISTRIBUIDORA 11,717.804.00TUBERIAS Y CERCO43,340.004.00CAMARA DE REJAS ( 01 UNIDAD)22,374.90COSTO DIRECTO102,168.435.00CONTROLES DE CALIDAD638.60COSTO DIRECTO135,397.20135,397.20

1472,992.00

COSTOSRESUMEN DE COSTOS A PRECIOS PRIVADOS - ALTERNATIVA IDESCRIPCIONAGUA POTABLECAPACITACION SANITARIA

P. PRIVADOSP. SOCIALESP. PRIVADOSP. SOCIALESCOSTO DIRECTO524,150.36420,368.591,550.001,243.10GASTOS GENERALES 10%52,415.0442,036.86155.00124.31UTILIDADES 7%36,690.5329,425.80108.5087.02SUB TOTAL613,255.93491,831.251,813.501,454.43IGV 18%110,386.0788,529.63326.43261.80COSTO OBRA723,641.99580,360.882,139.931,716.22G Adm y estudios 3% 21,709.2617,410.8364.2051.49Supervision 5%36,182.1029,018.04107.0085.81COSTO POR COMPONENTE781,533.35626,789.752,311.121,853.52COSTO DEL PROYECTO783,844.48

RESUMEN DE LA INVERSIONDESCRIPCIONPRECIOS PRIVADOSCOSTOS SOCIALES

AGUA POTABLE781,533.35626,789.75CAPACITACION SANITARIA2,311.121,853.52

TOTAL783,844.48628,643.27

RESUMEN DE COSTOS A PRECIOS PRIVADOS - ALTERNATIVA 02DESCRIPCIONAGUA POTABLESANEAMIENTOALCANTARILLADOP. TRATAMIENTOP. PRIVADOSP. SOCIALESP. PRIVADOSP. SOCIALESP. PRIVADOSP. SOCIALESCOSTO DIRECTO0.000.00153,252.65121,887.35135,397.20110,643.34GASTOS GENERALES 10%0.000.0015,325.2612,188.7413,539.7211,064.33UTILIDADES 5%0.000.007,662.636,094.376,769.865,532.17SUB TOTAL0.000.00176,240.55140,170.45155,706.78127,239.84IGV 18%0.000.0031,723.3025,230.6828,027.2222,903.17COSTO OBRA0.000.00207,963.84165,401.13183,734.00150,143.02G Adm y estudios 5% 0.000.0010,398.198,270.069,186.707,507.15Supervision 5%0.000.0010,398.198,270.069,186.707,507.15COSTO POR COMPONENTE0.000.00228,760.23181,941.25202,107.40165,157.32COSTO DEL PROYECTO430,867.63

RESUMEN DE LA INVERSIONDESCRIPCIONPRECIOS PRIVADOSCOSTOS SOCIALES

AGUA POTABLE0.000.00SANEAMIENTO430,867.63347,098.57ALCANTARILLADO228,760.23181,941.25PLANTA DE TRATAMIENTO202,107.40165,157.32TOTAL430,867.63347,098.57

(*) Ambito urbano4.530259.5561036020100501018075752828

COSTOS DE OPERACIN Y MANTENIMIENTO SIN PROYECTO - AMBAS ALTERNATIVASAGUA POTABLEUNDCANTIDADP.UNITARIOPRECIOS PRIVADOSFACTOR DE CORRECCIONPRECIOS SOCIALESITEMUNDCANTIDADP.UNITARIOPRECIOS PRIVADOSFACTOR DE CORRECCIONPRECIOS SOCIALES

COSTOS DE OPERACIN1,175.009.90COSTOS DE OPERACIN1320898.8Combustiblegal11515.000.6609.9Mano de obra glob1350350.000Combustiblesmes00.840.0Energia electricaglob11010.000INGRESO EGRESOSMano de obrames12506000.49294Insumos quimicoskg1035350.000energa elctricames12101200.84100.8servicios variosglob1200200.00Materiales de consumomes12506000.84504Materiales de consumoGlob1250250.000COSTOS DE MANTENIMIENTO620391.3Vigilante y cobradorGlob10.000.9000Mano de obraGlob13703700.49181.3COSTOS DE MANTENIMIENTO600.00381.50TOTAL DE INGRESOSMateriales de consumoGlob12702500.84210Mano de obraGlob1350350.000.490171.5TOTAL19401290.1Materiales de consumoGlob1250250.000.840210EGRESOSENServicios variosGlob10.000.8700MATERIALESSUB TOTAL1,775.00391.40SERVICIOSMANO DE OBRACOMBUSTIBLES Y LUBALCANTARILLADOPERSONAL (VIGILANTE Y COBRADOR)150UNDCANTIDADP.UNITARIOPRECIOS PRIVADOSFACTOR DE CORRECCIONPRECIOS SOCIALESSALDOCOSTOS DE OPERACIN0.000.00Combustiblemes0.000.6600Mano de obrames0.000.4900energia electricames0.000.8400Materiales de consumomes0.000.8400Gastos administrativosmes0.000.8400COSTOS DE MANTENIMIENTO0.000.00Mano de obraglob0.000.4900Materiales de consumoglob0.000.8400

SUB TOTAL0.000.00TOTAL1,775.00391.40

COSTOS DE OPERACIN Y MANTENIMIENTO CON PROYECTO ALTERNATIVA 01AGUA POTABLEUNDCANTIDADP.UNITARIOPRECIOS PRIVADOSFACTOR DE CORRECCIONPRECIOS SOCIALES

COSTOS DE OPERACIN0.000.00Combustiblemes120.000.6600Mano de obrames02000.000.4900energia electricames0.000.8400900.00Materiales de consumomes01000.000.8400Gastos administrativosmes01000.000.84001,200.00COSTOS DE MANTENIMIENTO0.000.00Mano de obraglob05000.000.4900Materiales de consumoglob04500.000.8400

SUB TOTAL0.000.00

ALCANTARILLADO REDESUNDCANTIDADP.UNITARIOPRECIOS PRIVADOSFACTOR DE CORRECCIONPRECIOS SOCIALES

COSTOS DE OPERACIN300.00182.00Combustiblesmes0.000.840Mano de obrames1200200.000.4998energia electricames0.000.840Materiales de consumomes1100100.000.8484COSTOS DE MANTENIMIENTO600.00381.50Mano de obraGlob1350350.000.49171.5Materiales de consumoGlob1250250.000.84210

TOTAL900.00563.50

ALCANTARILLADO PLANTA DE TRAT.UNDCANTIDADP.UNITARIOPRECIOS PRIVADOSFACTOR DE CORRECCIONPRECIOS SOCIALES1,775.00

COSTOS DE OPERACIN600.00364.00Combustiblesmes0.000.840Mano de obrames2200400.000.49196energia electricames0.000.840Materiales de consumomes2100200.000.84168COSTOS DE MANTENIMIENTO600.00329.00900.00Mano de obraGlob1500500.000.49245Materiales de consumoGlob1100100.000.84841,200.00

TOTAL1,200.00693.002,100.001,256.50COSTOS DE OPERACIN Y MANTENIMIENTO CON PROYECTO ALTERNATIVA 02AGUA POTABLEUNDCANTIDADP.UNITARIOPRECIOS PRIVADOSFACTOR DE CORRECCIONPRECIOS SOCIALES

COSTOS DE OPERACIN0.000.00Combustiblemes120.000.6600Mano de obrames2000.000.4900energia electricames0.000.8400Materiales de consumomes1000.000.8400Gastos administrativosmes1000.000.8400COSTOS DE MANTENIMIENTO0.000.00Mano de obraglob5000.000.4900Materiales de consumoglob4500.000.8400

SUB TOTAL0.000.00

ALCANTARILLADO REDESUNDCANTIDADP.UNITARIOPRECIOS PRIVADOSFACTOR DE CORRECCIONPRECIOS SOCIALES

COSTOS DE OPERACIN600.00364.00Combustiblesmes0.000.840Mano de obrames2200400.000.49196energia electricames0.000.840Materiales de consumomes2100200.000.84168COSTOS DE MANTENIMIENTO600.00381.50Mano de obraGlob1350350.000.49171.5Materiales de consumoGlob1250250.000.84210

TOTAL1,200.00745.50

ALCANTARILLADO PLANTA DE TRAT.UNDCANTIDADP.UNITARIOPRECIOS PRIVADOSFACTOR DE CORRECCIONPRECIOS SOCIALES

COSTOS DE OPERACIN600.00364.00Combustiblesmes0.000.660Mano de obrames2200400.000.49196energia electricames0.000.840Materiales de consumomes2100200.000.84168COSTOS DE MANTENIMIENTO600.00399.00Mano de obraGlob1300300.000.49147Materiales de consumoGlob1300300.000.84252

TOTAL1,200.00763.00

RESUMEN OPERACIN Y MANTENIMIENTODESCRIPCIONalternativa 01alternativa 02P. PRIVADOSP. SOCIALESP. PRIVADOSP. SOCIALESSIN PROYECTO1,775.00391.401,775.00391.40AGUA1,775.00391.401,775.00391.40ALCANT. REDES0.000.000.000.00ALCANT. PLANTACON PROYECTO900.00563.501,200.00745.50AGUA0.000.000.000.00ALCANT. REDES900.00563.501,200.00745.50ALCANT. PLANTA1,200.00693.001,200.00763.00

INCREMAGUACostos incrementales Agua potable Alternativa 1 (P.Privados)AoCon ProyectoSin ProyectoCostos Incrementales (S/.)InversionOp y ManOp y Man

0783,844.48783,844.48011,940.000.001,940.007,295AoCon ProyectoSin ProyectoCostos Incrementales (S/.)21,988.310.001,988.317,476InversinOp y ManOp y Man32,037.810.002,037.817,66342,088.560.002,088.567,8530486016.82486,016.8252,140.560.002,140.568,04911,280.3001,280.3062,193.860.002,193.868,24921,286.7051,281.7072,248.490.002,248.498,45531,293.1401,293.1482,304.480.002,304.488,66541,299.6001,299.6092,361.860.002,361.868,88151,306.1001,306.10102,420.670.002,420.679,10261,312.6301,312.63112,480.940.002,480.949,32971,319.1901,319.19122,542.720.002,542.729,56181,325.7901,325.79132,606.030.002,606.039,79991,332.4201,332.42142,670.920.002,670.9210,043101,339.0801,339.08152,737.430.002,737.4310,293111,345.7701,345.77162,805.590.002,805.5910,549121,352.5001,352.50172,875.450.002,875.4510,812131,359.2701,359.27182,947.050.002,947.0511,081141,366.0601,366.06193,020.430.003,020.4311,357151,372.8901,372.89203,095.640.003,095.6411,640161,379.7601,379.76171,386.6601,386.66181,393.5901,393.59191,400.5601,400.56Costos incrementales Agua potable Alternativa 1 (P.Sociales)201,407.5601,407.56AoCon ProyectoSin ProyectoCostos Incrementales (S/.)InversionOp y ManOp y Man

0628,643.27628,643.27011,290.100.001,290.107,29521,322.220.001,322.227,47631,355.150.001,355.157,66341,388.890.001,388.897,85351,423.470.001,423.478,04961,458.920.001,458.928,24971,495.240.001,495.248,45581,532.480.001,532.488,66591,570.640.001,570.648,881101,609.740.001,609.749,102111,649.830.001,649.839,329121,690.910.001,690.919,561131,733.010.001,733.019,799141,776.160.001,776.1610,043151,820.390.001,820.3910,293161,865.720.001,865.7210,549171,912.170.001,912.1710,812181,959.790.001,959.7911,081192,008.590.002,008.5911,357202,058.600.002,058.6011,640

INCREMALCANTCostos incrementales Alcantarillado a precios sociales Alterantiva UnicaAoInversionRedesPlanta de TratamientoCostos Incrementales Redes (S/.)Costos Incrementales Planta Trat. (S/.)DEMANDA DE AGUA M3/AOOp y Man C/POp y Man S/POp y Man C/POp y Man S/P

0ERROR:#REF!ERROR:#REF!0.001563.500.00693.000.00563.50693.005,835.782577.530.00710.260.00577.53710.265,981.093591.910.00727.940.00591.91727.946,130.024606.650.00746.070.00606.65746.076,282.665621.760.00764.640.00621.76764.646,439.106637.240.00783.680.00637.24783.686,599.437653.100.00803.200.00653.10803.206,763.768669.370.00823.200.00669.37823.206,932.179686.030.00843.690.00686.03843.697,104.7810703.120.00864.700.00703.12864.707,281.6911720.620.00886.230.00720.62886.237,463.0112738.570.00908.300.00738.57908.307,648.8413756.960.00930.920.00756.96930.927,839.2914775.810.00954.100.00775.81954.108,034.4915795.120.00977.850.00795.12977.858,234.5516814.920.001,002.200.00814.921,002.208,439.5917835.210.001,027.160.00835.211,027.168,649.7418856.010.001,052.730.00856.011,052.738,865.1119877.330.001,078.950.00877.331,078.959,085.8620899.170.001,105.810.00899.171,105.819,312.09

VALTIEMPOCUADRO PARA EL INGRESO DE INFORMACION BASE PARA REALIZAR LA EVALUACION ECONOMICA DE PROYECTOS DE AGUA POTABLE

a) Ingresar slo la informacin a), b) y c) en base a los resultados del Estudio de mercado contenido en el perfil del proyecto:

VALOR DEL TIEMPO SOLES/HORAPropsito LaboralPropsito No Laboral Area UrbanaPropsito No Laboral Area RuralAREA URBANAAREA RURALADULTOSMENORESADULTOSMENORES

4.963.321.490.7410.5TODOS ESTAN CONECTADOS AL SISTEMA

Persona que acarreaTiempo de acarreo minN de viajes/diaTiempo total de Acarreo hrs.Valor del tiempo/h(S/.)Valor del tiempo de acarreo (S/.dia)

Madre1430.701.000.70Hijo1230.600.50.30

Total61.00

Valor del tiempo de acarreo por familia al mesSoles30.00Valor del tiempo de acarreo por familia al aoSoles360.00Cantidad acarreada por viajelts15.00Cantidad acarreada al dialts90.00Cantidad acarreada al mesm32.70Valor del tiempo de acarreo al mes por m3Soles/m311.11

INFUENTEALT1B) EVALUACIONCUADRO PARA EL INGRESO DE INFORMACION BASE PARA REALIZAR LA EVALUACION ECONOMICA DE PROYECTOS DE AGUA POTABLEALTERNATIVA 01

Ingresar slo la informacin a) y b) en base a los resultados del Estudio de mercado contenido en el perfil del proyecto:

a) Datos de la situacin sin proyectoConsumo de los no conectados al sistema (m3/mes/vivi.)2.70QspPrecio econmico del agua para los no conectados al sistema (S/./m3)11.11PspN de familias actualmente conectadas al sistema de agua potable0Consumo con racionamiento de los conectados al sistema (m3/mes/vivi.)6QrPrecio economico para los conectados 0.3809523Pr2.29Tarifa mes actual1.00572Costos de operacin y mantenimiento del sistema actual de agua y alcantarillado (S/./ao) 900Consumo segn tarifa de la EPS (Propuesta)15QcpTarifa de la EPS (Tarifa) S/m30.1555555Pcp2.33Tarifa mes c/p* Qcp = Qa SIN MICROMEDICIONConsumo de saturacion con tarifa margina cero (m3/mes/vivi)14.00QaSustentar encuesta o estudios a poblaciones similaresb) Datos de la situacin con proyecto (donde no corresponda colocar cero)AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioInversin Total a precios privados (S/.) **Consumo de agua (m3/ao) Produccin de agua (m3/ao) Costos de Operacin y mantenimiento a precios privadosTotalAntiguasNuevas

000.00%0781,5331333100.00%670677,2959,1189002341100.00%680687,4769,3459223350100.00%700707,6639,5789454359100.00%720727,8539,8179695368100.00%740748,04910,0619936377100.00%750758,24910,3121,0187386100.00%770778,45510,5681,0438396100.00%790798,66510,8321,0699406100.00%810818,88111,1011,09610416100.00%830839,10211,3781,12311426100.00%850859,32911,6611,15112437100.00%870879,56111,9511,18013447100.00%890899,79912,2491,20914459100.00%9209210,04312,5541,23915470100.00%9409410,29312,8661,27016482100.00%9609610,54913,1871,30217494100.00%9909910,81213,5151,33418506100.00%101010111,08113,8521,36719519100.00%104010411,35714,1971,40120532100.00%106010611,64014,5501,436** Las inversiones a partir del ao 3 corresponden a los costos de instalacin de las nuevas conexiones

CURVASRESALT1I. Curva de la Demanda y Beneficios Econmicos para nuevos Usuarios II. Curva de la Demanda y Beneficios Econmicos para Usuarios Antiguos

1. Estimacin de la curva de demanda de agua1. Estimacin de la curva de demanda de agua

Variable cantidadnuevos usuariosVariable precioVariable cantidadnuevos usuariosVariable preciocantidad (S/.)Precio (S/./m3)cantidad (S/.)Precio (S/./m3)0.00013.766Precio mximo al cual no se demandaria agua potable Pmcurva:0.0013.77Precio mximo al cual no se demandaria agua potable (S/./m3) PmConsumo de los no conectados al sistema (m3/mes/vivi.) Qsp2.70011.111Precio econmico del agua para los no conectados al sistema (S/./m3) PspQ =14.000-1.017PConsumo de los conectados al sistema (m3/mes/vivi.) Qr6.007.87Precio econmico del agua para los conectados segn curva de demanda (S/./m3) PrConsumo segn tarifa de EPS o propuesta (m3/mes/vivi.) Qcp13.8420.156Tarifa de la EPS o propuesta PcpConsumo segn tarifa de EPS o propuesta (m3/mes/vivi.) Qcp13.840.16Tarifa de la EPS o propuesta (S/./m3)PcpConsumo de saturacin con tarifa marginal cero (m3/mes/vivi.) Qa14.0000.000Consumo de saturacin con tarifa marginal cero (m3/mes/vivi.) Qa14.000.00

2. Estimacin de los beneficios de nuevos usuarios2. Estimacin de los beneficios usuarios antiguos 2.1 Usuarios sujetos a micromedicin 2.1 Beneficios por incremento del consumo de agua (S/. / fam/mes)31.45 a. Beneficios por recursos liberados (S/. / fam/mes)30.00 b. Beneficios por incremento del consumo de agua (S/. / fam/mes)62.77 c. Beneficios brutos totales (S/. / fam/mes)92.77

2.1 Usuarios no sujetos a micromedicin a. Beneficios por recursos liberados (S/. / fam/mes)30.00 b. Beneficios por incremento del consumo de agua (S/. / fam/mes)62.78 c. Beneficios brutos totales (S/. / fam/mes)92.78

RESEVALALT1CUADRO N 1EVALUACION ECONOMICA DEL PROYECTO DE AGUAALTERNATIVA 011234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

628,643-628,6431.000-628,6431333100.00%06767074,15974,15909,1181,940.072,2190.90965,6532341100.00%06868076,00576,00509,3451,988.374,0170.82661,1713350100.00%07070077,89877,89809,5782,037.875,8600.75156,9954359100.00%07272079,83879,83809,8172,088.677,7490.68353,1045368100.00%07474081,82581,825010,0612,140.679,6850.62149,4786377100.00%07575083,86383,863010,3122,193.981,6690.56446,1007386100.00%07777085,95185,951010,5682,248.583,7030.51342,9538396100.00%07979088,09188,091010,8322,304.585,7870.46740,0209406100.00%08181090,28590,285011,1012,361.987,9230.42437,28810416100.00%08383092,53392,533011,3782,420.790,1120.38634,74211426100.00%08585094,83794,837011,6612,480.992,3560.35032,37012437100.00%08787097,19897,198011,9512,542.794,6560.31930,16013447100.00%08989099,61999,619012,2492,606.097,0130.29028,10114459100.00%092920102,099102,099012,5542,670.999,4280.26326,18315470100.00%094940104,641104,641012,8662,737.4101,9040.23924,39516482100.00%096960107,247107,247013,1872,805.6104,4410.21822,72917494100.00%099990109,917109,917013,5152,875.4107,0420.19821,17818506100.00%01011010112,654112,654013,8522,947.0109,7070.18019,73219519100.00%01041040115,459115,459014,1973,020.4112,4390.16418,38520532100.00%01061060118,334118,334014,5503,095.6115,2390.14917,130

VAN SOCIAL99,222.71TIR SOCIAL12.046%

+100.00%EVALUACION ECONOMICA DEL PROYECTO DE AGUAALTERNATIVA 011234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

1,257,287-1,257,2871.000-1,257,2871333100.00%06767074,15974,15909,1181,940.072,2190.90965,6532341100.00%06868076,00576,00509,3451,988.374,0170.82661,1713350100.00%07070077,89877,89809,5782,037.875,8600.75156,9954359100.00%07272079,83879,83809,8172,088.677,7490.68353,1045368100.00%07474081,82581,825010,0612,140.679,6850.62149,4786377100.00%07575083,86383,863010,3122,193.981,6690.56446,1007386100.00%07777085,95185,951010,5682,248.583,7030.51342,9538396100.00%07979088,09188,091010,8322,304.585,7870.46740,0209406100.00%08181090,28590,285011,1012,361.987,9230.42437,28810416100.00%08383092,53392,533011,3782,420.790,1120.38634,74211426100.00%08585094,83794,837011,6612,480.992,3560.35032,37012437100.00%08787097,19897,198011,9512,542.794,6560.31930,16013447100.00%08989099,61999,619012,2492,606.097,0130.29028,10114459100.00%092920102,099102,099012,5542,670.999,4280.26326,18315470100.00%094940104,641104,641012,8662,737.4101,9040.23924,39516482100.00%096960107,247107,247013,1872,805.6104,4410.21822,72917494100.00%099990109,917109,917013,5152,875.4107,0420.19821,17818506100.00%01011010112,654112,654013,8522,947.0109,7070.18019,73219519100.00%01041040115,459115,459014,1973,020.4112,4390.16418,38520532100.00%01061060118,334118,334014,5503,095.6115,2390.14917,130

VAN SOCIAL-529,420.56TIR SOCIAL3.63%+207.00%EVALUACION ECONOMICA DEL PROYECTO DE AGUAALTERNATIVA 011234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

1,929,935-1,929,9351.000-1,929,9351333100.00%06767074,15974,15909,1181,940.072,2190.90965,6532341100.00%06868076,00576,00509,3451,988.374,0170.82661,1713350100.00%07070077,89877,89809,5782,037.875,8600.75156,9954359100.00%07272079,83879,83809,8172,088.677,7490.68353,1045368100.00%07474081,82581,825010,0612,140.679,6850.62149,4786377100.00%07575083,86383,863010,3122,193.981,6690.56446,1007386100.00%07777085,95185,951010,5682,248.583,7030.51342,9538396100.00%07979088,09188,091010,8322,304.585,7870.46740,0209406100.00%08181090,28590,285011,1012,361.987,9230.42437,28810416100.00%08383092,53392,533011,3782,420.790,1120.38634,74211426100.00%08585094,83794,837011,6612,480.992,3560.35032,37012437100.00%08787097,19897,198011,9512,542.794,6560.31930,16013447100.00%08989099,61999,619012,2492,606.097,0130.29028,10114459100.00%092920102,099102,099012,5542,670.999,4280.26326,18315470100.00%094940104,641104,641012,8662,737.4101,9040.23924,39516482100.00%096960107,247107,247013,1872,805.6104,4410.21822,72917494100.00%099990109,917109,917013,5152,875.4107,0420.19821,17818506100.00%01011010112,654112,654013,8522,947.0109,7070.18019,73219519100.00%01041040115,459115,459014,1973,020.4112,4390.16418,38520532100.00%01061060118,334118,334014,5503,095.6115,2390.14917,130

VAN SOCIAL-1,202,068.86TIR SOCIAL-0.40%-5.00%EVALUACION ECONOMICA DEL PROYECTO DE AGUAALTERNATIVA 011234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

597,211-597,2111.000-597,2111333100.00%06767074,15974,15909,1181,940.072,2190.90965,6532341100.00%06868076,00576,00509,3451,988.374,0170.82661,1713350100.00%07070077,89877,89809,5782,037.875,8600.75156,9954359100.00%07272079,83879,83809,8172,088.677,7490.68353,1045368100.00%07474081,82581,825010,0612,140.679,6850.62149,4786377100.00%07575083,86383,863010,3122,193.981,6690.56446,1007386100.00%07777085,95185,951010,5682,248.583,7030.51342,9538396100.00%07979088,09188,091010,8322,304.585,7870.46740,0209406100.00%08181090,28590,285011,1012,361.987,9230.42437,28810416100.00%08383092,53392,533011,3782,420.790,1120.38634,74211426100.00%08585094,83794,837011,6612,480.992,3560.35032,37012437100.00%08787097,19897,198011,9512,542.794,6560.31930,16013447100.00%08989099,61999,619012,2492,606.097,0130.29028,10114459100.00%092920102,099102,099012,5542,670.999,4280.26326,18315470100.00%094940104,641104,641012,8662,737.4101,9040.23924,39516482100.00%096960107,247107,247013,1872,805.6104,4410.21822,72917494100.00%099990109,917109,917013,5152,875.4107,0420.19821,17818506100.00%01011010112,654112,654013,8522,947.0109,7070.18019,73219519100.00%01041040115,459115,459014,1973,020.4112,4390.16418,38520532100.00%01061060118,334118,334014,5503,095.6115,2390.14917,130

VAN SOCIAL130,654.88TIR SOCIAL12.81%-10.00%EVALUACION ECONOMICA DEL PROYECTO DE AGUAALTERNATIVA 011234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

565,779-565,7791.000-565,7791333100.00%06767074,15974,15909,1181,940.072,2190.90965,6532341100.00%06868076,00576,00509,3451,988.374,0170.82661,1713350100.00%07070077,89877,89809,5782,037.875,8600.75156,9954359100.00%07272079,83879,83809,8172,088.677,7490.68353,1045368100.00%07474081,82581,825010,0612,140.679,6850.62149,4786377100.00%07575083,86383,863010,3122,193.981,6690.56446,1007386100.00%07777085,95185,951010,5682,248.583,7030.51342,9538396100.00%07979088,09188,091010,8322,304.585,7870.46740,0209406100.00%08181090,28590,285011,1012,361.987,9230.42437,28810416100.00%08383092,53392,533011,3782,420.790,1120.38634,74211426100.00%08585094,83794,837011,6612,480.992,3560.35032,37012437100.00%08787097,19897,198011,9512,542.794,6560.31930,16013447100.00%08989099,61999,619012,2492,606.097,0130.29028,10114459100.00%092920102,099102,099012,5542,670.999,4280.26326,18315470100.00%094940104,641104,641012,8662,737.4101,9040.23924,39516482100.00%096960107,247107,247013,1872,805.6104,4410.21822,72917494100.00%099990109,917109,917013,5152,875.4107,0420.19821,17818506100.00%01011010112,654112,654013,8522,947.0109,7070.18019,73219519100.00%01041040115,459115,459014,1973,020.4112,4390.16418,38520532100.00%01061060118,334118,334014,5503,095.6115,2390.14917,130

VAN SOCIAL162,087.04TIR SOCIAL13.63%EN LA OPERACIN Y MANTENIMIENTO

+10.00%EVALUACION ECONOMICA DEL PROYECTO DE AGUAALTERNATIVA 011234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

628,643-628,6431.000-628,6431333100.00%06767074,15974,15909,1182,134.072,0250.90965,4772341100.00%06868076,00576,00509,3452,187.173,8180.82661,0073350100.00%07070077,89877,89809,5782,241.675,6560.75156,8424359100.00%07272079,83879,83809,8172,297.477,5400.68352,9615368100.00%07474081,82581,825010,0612,354.679,4710.62149,3456377100.00%07575083,86383,863010,3122,413.281,4500.56445,9767386100.00%07777085,95185,951010,5682,473.383,4780.51342,8378396100.00%07979088,09188,091010,8322,534.985,5560.46739,9139406100.00%08181090,28590,285011,1012,598.087,6870.42437,18810416100.00%08383092,53392,533011,3782,662.789,8700.38634,64911426100.00%08585094,83794,837011,6612,729.092,1080.35032,28312437100.00%08787097,19897,198011,9512,797.094,4010.31930,07913447100.00%08989099,61999,619012,2492,866.696,7520.29028,02614459100.00%092920102,099102,099012,5542,938.099,1610.26326,11215470100.00%094940104,641104,641012,8663,011.2101,6300.23924,32916482100.00%096960107,247107,247013,1873,086.1104,1610.21822,66817494100.00%099990109,917109,917013,5153,163.0106,7540.19821,12118506100.00%01011010112,654112,654013,8523,241.8109,4130.18019,67919519100.00%01041040115,459115,459014,1973,322.5112,1370.16418,33520532100.00%01061060118,334118,334014,5503,405.2114,9290.14917,083

VAN SOCIAL97,267.46TIR SOCIAL12.01%+10.00%EVALUACION ECONOMICA DEL PROYECTO DE AGUAALTERNATIVA 011234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

628,643-628,6431.000-628,6431333100.00%06767074,15974,15909,1182,134.072,0250.90965,4772341100.00%06868076,00576,00509,3452,187.173,8180.82661,0073350100.00%07070077,89877,89809,5782,241.675,6560.75156,8424359100.00%07272079,83879,83809,8172,297.477,5400.68352,9615368100.00%07474081,82581,825010,0612,354.679,4710.62149,3456377100.00%07575083,86383,863010,3122,413.281,4500.56445,9767386100.00%07777085,95185,951010,5682,473.383,4780.51342,8378396100.00%07979088,09188,091010,8322,534.985,5560.46739,9139406100.00%08181090,28590,285011,1012,598.087,6870.42437,18810416100.00%08383092,53392,533011,3782,662.789,8700.38634,64911426100.00%08585094,83794,837011,6612,729.092,1080.35032,28312437100.00%08787097,19897,198011,9512,797.094,4010.31930,07913447100.00%08989099,61999,619012,2492,866.696,7520.29028,02614459100.00%092920102,099102,099012,5542,938.099,1610.26326,11215470100.00%094940104,641104,641012,8663,011.2101,6300.23924,32916482100.00%096960107,247107,247013,1873,086.1104,1610.21822,66817494100.00%099990109,917109,917013,5153,163.0106,7540.19821,12118506100.00%01011010112,654112,654013,8523,241.8109,4130.18019,67919519100.00%01041040115,459115,459014,1973,322.5112,1370.16418,33520532100.00%01061060118,334118,334014,5503,405.2114,9290.14917,083

VAN SOCIAL97,267.46TIR SOCIAL12.01%-10.00%EVALUACION ECONOMICA DEL PROYECTO DE AGUAALTERNATIVA 011234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

628,643-628,6431.000-628,6431333100.00%06767074,15974,15909,1181,746.072,4130.90965,8302341100.00%06868076,00576,00509,3451,789.574,2160.82661,3353350100.00%07070077,89877,89809,5781,834.076,0640.75157,1484359100.00%07272079,83879,83809,8171,879.777,9580.68353,2465368100.00%07474081,82581,825010,0611,926.579,8990.62149,6116377100.00%07575083,86383,863010,3121,974.581,8880.56446,2247386100.00%07777085,95185,951010,5682,023.683,9270.51343,0688396100.00%07979088,09188,091010,8322,074.086,0170.46740,1289406100.00%08181090,28590,285011,1012,125.788,1590.42437,38810416100.00%08383092,53392,533011,3782,178.690,3540.38634,83511426100.00%08585094,83794,837011,6612,232.892,6040.35032,45712437100.00%08787097,19897,198011,9512,288.494,9100.31930,24113447100.00%08989099,61999,619012,2492,345.497,2730.29028,17714459100.00%092920102,099102,099012,5542,403.899,6950.26326,25315470100.00%094940104,641104,641012,8662,463.7102,1780.23924,46116482100.00%096960107,247107,247013,1872,525.0104,7220.21822,79117494100.00%099990109,917109,917013,5152,587.9107,3290.19821,23518506100.00%01011010112,654112,654013,8522,652.3110,0020.18019,78519519100.00%01041040115,459115,459014,1972,718.4112,7410.16418,43420532100.00%01061060118,334118,334014,5502,786.1115,5480.14917,176

VAN SOCIAL101,177.97TIR SOCIAL12.09%-20.00%EVALUACION ECONOMICA DEL PROYECTO DE AGUAALTERNATIVA 011234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

628,643-628,6431.000-628,6431333100.00%06767074,15974,15909,1181,552.072,6070.90966,0062341100.00%06868076,00576,00509,3451,590.674,4150.82661,5003350100.00%07070077,89877,89809,5781,630.376,2680.75157,3014359100.00%07272079,83879,83809,8171,670.878,1670.68353,3895368100.00%07474081,82581,825010,0611,712.480,1130.62149,7446377100.00%07575083,86383,863010,3121,755.182,1080.56446,3487386100.00%07777085,95185,951010,5681,798.884,1520.51343,1838396100.00%07979088,09188,091010,8321,843.686,2480.46740,2359406100.00%08181090,28590,285011,1011,889.588,3950.42437,48810416100.00%08383092,53392,533011,3781,936.590,5960.38634,92911426100.00%08585094,83794,837011,6611,984.892,8520.35032,54412437100.00%08787097,19897,198011,9512,034.295,1640.31930,32213447100.00%08989099,61999,619012,2492,084.897,5340.29028,25214459100.00%092920102,099102,099012,5542,136.799,9620.26326,32315470100.00%094940104,641104,641012,8662,189.9102,4510.23924,52616482100.00%096960107,247107,247013,1872,244.5105,0020.21822,85217494100.00%099990109,917109,917013,5152,300.4107,6170.19821,29118506100.00%01011010112,654112,654013,8522,357.6110,2970.18019,83819519100.00%01041040115,459115,459014,1972,416.3113,0430.16418,48320532100.00%01061060118,334118,334014,5502,476.5115,8580.14917,222

VAN SOCIAL103,133.22TIR SOCIAL12.12%

INFUENTEALT(2)B) EVALUACIONCUADRO PARA EL INGRESO DE INFORMACION BASE PARA REALIZAR LA EVALUACION ECONOMICA DE PROYECTOS DE AGUA POTABLEALTERNATIVA 02

Ingresar slo la informacin a) y b) en base a los resultados del Estudio de mercado contenido en el perfil del proyecto:

a) Datos de la situacin sin proyectoConsumo de los no conectados al sistema (m3/mes/vivi.)2.70QspPrecio econmico del agua para los no conectados al sistema (S/./m3)11.11PspN de familias actualmente conectadas al sistema de agua potable0VERIFICAR SEGN ENCUESTAConsumo con racionamiento de los conectados al sistema (m3/mes/vivi.)6QrPrecio economico para los conectados 0.242326Pr1.45Tarifa mes actual1.00572Costos de operacin y mantenimiento del sistema actual de agua y alcantarillado (S/./ao) 1,200Consumo segn tarifa de la EPS (Propuesta)30QcpTarifa de la EPS (Tarifa) S/m30.1665Pcp5.00Tarifa mes c/p* Qcp = Qa SIN MICROMEDICIONConsumo de saturacion con tarifa margina cero (m3/mes/vivi)30QaSustentar encuesta o estudios a poblaciones similaresb) Datos de la situacin con proyecto (donde no corresponda colocar cero)AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioInversin Total a precios privados (S/.) **Consumo de agua (m3/ao) Produccin de agua (m3/ao) Costos de Operacin y mantenimiento a precios privadosTotalAntiguasNuevas

03250.00%001333100.00%670677,2959,1181,2002341100.00%680687,4769,3451,2303350100.00%700707,6639,5781,2614359100.00%720727,8539,8171,2925368100.00%740748,04910,0611,3246377100.00%750758,24910,3121,3577386100.00%770778,45510,5681,3918396100.00%790798,66510,8321,4259406100.00%810818,88111,1011,46110416100.00%830839,10211,3781,49711426100.00%850859,32911,6611,53512437100.00%870879,56111,9511,57313447100.00%890899,79912,2491,61214459100.00%9209210,04312,5541,65215470100.00%9409410,29312,8661,69316482100.00%9609610,54913,1871,73517494100.00%9909910,81213,5151,77918506100.00%101010111,08113,8521,82319519100.00%104010411,35714,1971,86820532100.00%106010611,64014,5501,915** Las inversiones a partir del ao 3 corresponden a los costos de instalacin de las nuevas conexiones

CURVASRESALT1 (2)I. Curva de la Demanda y Beneficios Econmicos para nuevos Usuarios II. Curva de la Demanda y Beneficios Econmicos para Usuarios Antiguos

1. Estimacin de la curva de demanda de agua1. Estimacin de la curva de demanda de agua

Variable cantidadnuevos usuariosVariable precioVariable cantidadnuevos usuariosVariable preciocantidad (S/.)Precio (S/./m3)cantidad (S/.)Precio (S/./m3)0.00013.766Precio mximo al cual no se demandaria agua potable Pmcurva:0.0013.77Precio mximo al cual no se demandaria agua potable (S/./m3) PmConsumo de los no conectados al sistema (m3/mes/vivi.) Qsp2.70011.111Precio econmico del agua para los no conectados al sistema (S/./m3) PspQ =14.000-1.017PConsumo de los conectados al sistema (m3/mes/vivi.) Qr6.007.87Precio econmico del agua para los conectados segn curva de demanda (S/./m3) PrConsumo segn tarifa de EPS o propuesta (m3/mes/vivi.) Qcp13.8420.156Tarifa de la EPS o propuesta PcpConsumo segn tarifa de EPS o propuesta (m3/mes/vivi.) Qcp13.840.16Tarifa de la EPS o propuesta (S/./m3)PcpConsumo de saturacin con tarifa marginal cero (m3/mes/vivi.) Qa14.0000.000Consumo de saturacin con tarifa marginal cero (m3/mes/vivi.) Qa14.000.00

2. Estimacin de los beneficios de nuevos usuarios2. Estimacin de los beneficios usuarios antiguos 2.1 Usuarios sujetos a micromedicin 2.1 Beneficios por incremento del consumo de agua (S/. / fam/mes)31.45 a. Beneficios por recursos liberados (S/. / fam/mes)30.00 b. Beneficios por incremento del consumo de agua (S/. / fam/mes)62.77 c. Beneficios brutos totales (S/. / fam/mes)92.77

2.1 Usuarios no sujetos a micromedicin a. Beneficios por recursos liberados (S/. / fam/mes)30.00 b. Beneficios por incremento del consumo de agua (S/. / fam/mes)62.78 c. Beneficios brutos totales (S/. / fam/mes)92.78

RESEVALALT(2)CUADRO N 1EVALUACION ECONOMICA DEL PROYECTO DE AGUA

Alternativa 021234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

9%

628,643-628,6431.000-628,6431333100.00%06767074,15974,15909,1181,29072,8690.91766,8522341100.00%06868076,00576,00509,3451,32274,6830.84262,8593350100.00%07070077,89877,89809,5781,35576,5430.77259,1054359100.00%07272079,83879,83809,8171,38978,4490.70855,5755368100.00%07474081,82581,825010,0611,42380,4020.65052,2566377100.00%07575083,86383,863010,3121,45982,4040.59649,1357386100.00%07777085,95185,951010,5681,49584,4560.54746,2008396100.00%07979088,09188,091010,8321,53286,5590.50243,4419406100.00%08181090,28590,285011,1011,57188,7140.46040,84610416100.00%08383092,53392,533011,3781,61090,9230.42238,40711426100.00%08585094,83794,837011,6611,65093,1870.38836,11312437100.00%08787097,19897,198011,9511,69195,5070.35633,95613447100.00%08989099,61999,619012,2491,73397,8860.32631,92814459100.00%092920102,099102,099012,5541,776100,3230.29930,02115470100.00%094940104,641104,641012,8661,820102,8210.27528,22816482100.00%096960107,247107,247013,1871,866105,3810.25226,54217494100.00%099990109,917109,917013,5151,912108,0050.23124,95718506100.00%01011010112,654112,654013,8521,960110,6950.21223,46719519100.00%01041040115,459115,459014,1972,009113,4510.19422,06520532100.00%01061060118,334118,334014,5502,059116,2760.17820,747

VAN SOCIAL164,058.26TIR SOCIAL12.177%Proyecto Rentable en Trminos Sociales+10.00%

1234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

691,508-691,5081.000-691,508133310676707415974159091181290728690.91766852234110686807600576005093451322746830.84262859335010707007789877898095781355765430.77259105435910727207983879838098171389784490.708555755368107474081825818250100611423804020.650522566377107575083863838630103121459824040.596491357386107777085951859510105681495844560.547462008396107979088091880910108321532865590.502434419406108181090285902850111011571887140.4604084610416108383092533925330113781610909230.4223840711426108585094837948370116611650931870.3883611312437108787097198971980119511691955070.3563395613447108989099619996190122491733978860.3263192814459109292010209910209901255417761003230.2993002115470109494010464110464101286618201028210.2752822816482109696010724710724701318718661053810.2522654217494109999010991710991701351519121080050.231249571850610101101011265411265401385219601106950.212234671951910104104011545911545901419720091134510.194220652053210106106011833411833401455020591162760.17820747

VAN SOCIAL101,193.93TIR SOCIAL10.819%+53.97%

1234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

967,922-967,9221.000-967,922133310676707415974159091181290728690.91766852234110686807600576005093451322746830.84262859335010707007789877898095781355765430.77259105435910727207983879838098171389784490.708555755368107474081825818250100611423804020.650522566377107575083863838630103121459824040.596491357386107777085951859510105681495844560.547462008396107979088091880910108321532865590.502434419406108181090285902850111011571887140.4604084610416108383092533925330113781610909230.4223840711426108585094837948370116611650931870.3883611312437108787097198971980119511691955070.3563395613447108989099619996190122491733978860.3263192814459109292010209910209901255417761003230.2993002115470109494010464110464101286618201028210.2752822816482109696010724710724701318718661053810.2522654217494109999010991710991701351519121080050.231249571850610101101011265411265401385219601106950.212234671951910104104011545911545901419720091134510.194220652053210106106011833411833401455020591162760.17820747

VAN SOCIAL-175,220.51TIR SOCIAL6.570%-10.00%

1234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

565,779-565,7791.000-565,779133310676707415974159091181290728690.91766852234110686807600576005093451322746830.84262859335010707007789877898095781355765430.77259105435910727207983879838098171389784490.708555755368107474081825818250100611423804020.650522566377107575083863838630103121459824040.596491357386107777085951859510105681495844560.547462008396107979088091880910108321532865590.502434419406108181090285902850111011571887140.4604084610416108383092533925330113781610909230.4223840711426108585094837948370116611650931870.3883611312437108787097198971980119511691955070.3563395613447108989099619996190122491733978860.3263192814459109292010209910209901255417761003230.2993002115470109494010464110464101286618201028210.2752822816482109696010724710724701318718661053810.2522654217494109999010991710991701351519121080050.231249571850610101101011265411265401385219601106950.212234671951910104104011545911545901419720091134510.194220652053210106106011833411833401455020591162760.17820747

VAN SOCIAL226,922.59TIR SOCIAL13.775%-20.00%

1234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

502,915-502,9151.000-502,915133310676707415974159091181290728690.91766852234110686807600576005093451322746830.84262859335010707007789877898095781355765430.77259105435910727207983879838098171389784490.708555755368107474081825818250100611423804020.650522566377107575083863838630103121459824040.596491357386107777085951859510105681495844560.547462008396107979088091880910108321532865590.502434419406108181090285902850111011571887140.4604084610416108383092533925330113781610909230.4223840711426108585094837948370116611650931870.3883611312437108787097198971980119511691955070.3563395613447108989099619996190122491733978860.3263192814459109292010209910209901255417761003230.2993002115470109494010464110464101286618201028210.2752822816482109696010724710724701318718661053810.2522654217494109999010991710991701351519121080050.231249571850610101101011265411265401385219601106950.212234671951910104104011545911545901419720091134510.194220652053210106106011833411833401455020591162760.17820747

VAN SOCIAL289,786.91TIR SOCIAL15.696%EN LA OPERACIN Y MANTENIMIENTO

+10.00%EVALUACION ECONOMICA DEL PROYECTO DE AGUAALTERNATIVA 011234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

628,643-628,6431.000-628,6431333100.00%06767074,15974,15909,1181,419.172,7400.91766,7342341100.00%06868076,00576,00509,3451,454.474,5510.84262,7483350100.00%07070077,89877,89809,5781,490.776,4070.77259,0004359100.00%07272079,83879,83809,8171,527.878,3100.70855,4775368100.00%07474081,82581,825010,0611,565.880,2600.65052,1636377100.00%07575083,86383,863010,3121,604.882,2580.59649,0487386100.00%07777085,95185,951010,5681,644.884,3060.54746,1188396100.00%07979088,09188,091010,8321,685.786,4060.50243,3649406100.00%08181090,28590,285011,1011,727.788,5570.46040,77410416100.00%08383092,53392,533011,3781,770.790,7620.42238,33911426100.00%08585094,83794,837011,6611,814.893,0220.38836,04912437100.00%08787097,19897,198011,9511,860.095,3380.35633,89613447100.00%08989099,61999,619012,2491,906.397,7120.32631,87214459100.00%092920102,099102,099012,5541,953.8100,1450.29929,96815470100.00%094940104,641104,641012,8662,002.4102,6390.27528,17816482100.00%096960107,247107,247013,1872,052.3105,1950.25226,49517494100.00%099990109,917109,917013,5152,103.4107,8140.23124,91318506100.00%01011010112,654112,654013,8522,155.8110,4990.21223,42519519100.00%01041040115,459115,459014,1972,209.4113,2500.19422,02620532100.00%01061060118,334118,334014,5502,264.5116,0700.17820,710

VAN SOCIAL162,654.82TIR SOCIAL12.15%+53.97%EVALUACION ECONOMICA DEL PROYECTO DE AGUAALTERNATIVA 011234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

628,643-628,6431.000-628,6431333100.00%06767074,15974,15909,1181,986.472,1720.91766,2132341100.00%06868076,00576,00509,3452,035.873,9690.84262,2593350100.00%07070077,89877,89809,5782,086.575,8110.77258,5404359100.00%07272079,83879,83809,8172,138.577,6990.70855,0445368100.00%07474081,82581,825010,0612,191.779,6340.65051,7566377100.00%07575083,86383,863010,3122,246.381,6170.59648,6657386100.00%07777085,95185,951010,5682,302.283,6490.54745,7598396100.00%07979088,09188,091010,8322,359.685,7320.50243,0269406100.00%08181090,28590,285011,1012,418.387,8660.46040,45610416100.00%08383092,53392,533011,3782,478.590,0540.42238,04011426100.00%08585094,83794,837011,6612,540.292,2970.38835,76812437100.00%08787097,19897,198011,9512,603.594,5950.35633,63213447100.00%08989099,61999,619012,2492,668.396,9500.32631,62314459100.00%092920102,099102,099012,5542,734.899,3640.29929,73415470100.00%094940104,641104,641012,8662,802.9101,8390.27527,95916482100.00%096960107,247107,247013,1872,872.6104,3740.25226,28917494100.00%099990109,917109,917013,5152,944.2106,9730.23124,71918506100.00%01011010112,654112,654013,8523,017.5109,6370.21223,24219519100.00%01041040115,459115,459014,1973,092.6112,3670.19421,85420532100.00%01061060118,334118,334014,5503,169.6115,1650.17820,549

VAN SOCIAL156,483.92TIR SOCIAL12.04%-10.00%EVALUACION ECONOMICA DEL PROYECTO DE AGUAALTERNATIVA 011234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

628,643-628,6431.000-628,6431333100.00%06767074,15974,15909,1181,161.172,9980.91766,9702341100.00%06868076,00576,00509,3451,190.074,8150.84262,9713350100.00%07070077,89877,89809,5781,219.676,6780.77259,2104359100.00%07272079,83879,83809,8171,250.078,5880.70855,6735368100.00%07474081,82581,825010,0611,281.180,5440.65052,3486377100.00%07575083,86383,863010,3121,313.082,5500.59649,2227386100.00%07777085,95185,951010,5681,345.784,6050.54746,2828396100.00%07979088,09188,091010,8321,379.286,7120.50243,5189406100.00%08181090,28590,285011,1011,413.688,8710.46040,91910416100.00%08383092,53392,533011,3781,448.891,0840.42238,47511426100.00%08585094,83794,837011,6611,484.893,3520.38836,17712437100.00%08787097,19897,198011,9511,521.895,6770.35634,01613447100.00%08989099,61999,619012,2491,559.798,0590.32631,98514459100.00%092920102,099102,099012,5541,598.5100,5010.29930,07415470100.00%094940104,641104,641012,8661,638.4103,0030.27528,27816482100.00%096960107,247107,247013,1871,679.1105,5680.25226,58917494100.00%099990109,917109,917013,5151,721.0108,1960.23125,00118506100.00%01011010112,654112,654013,8521,763.8110,8910.21223,50819519100.00%01041040115,459115,459014,1971,807.7113,6520.19422,10420532100.00%01061060118,334118,334014,5501,852.7116,4820.17820,784

VAN SOCIAL165,461.69TIR SOCIAL12.20%-20.00%EVALUACION ECONOMICA DEL PROYECTO DE AGUAALTERNATIVA 011234a4b4c5a5b5c67891011AosPoblacion TotalPoblacin Conectada (%)N de Familias conectadas al servicioBeneficios Brutos (S/.ao)Inversin Total a precios sociales (S/.)Produccin de agua (m3/ao) Costos de Operacin y mantenimiento incrementalesFlujo neto a precios socialesFactor de descuentoValor actual del flujo neto a precios socialesAntiguasNuevasTotalAntiguasNuevasTotal

10%

628,643-628,6431.000-628,6431333100.00%06767074,15974,15909,1181,032.173,1270.91767,0892341100.00%06868076,00576,00509,3451,057.874,9480.84263,0823350100.00%07070077,89877,89809,5781,084.176,8140.77259,3144359100.00%07272079,83879,83809,8171,111.178,7260.70855,7725368100.00%07474081,82581,825010,0611,138.880,6870.65052,4416377100.00%07575083,86383,863010,3121,167.182,6960.59649,3097386100.00%07777085,95185,951010,5681,196.284,7550.54746,3648396100.00%07979088,09188,091010,8321,226.086,8650.50243,5959406100.00%08181090,28590,285011,1011,256.589,0280.46040,99110416100.00%08383092,53392,533011,3781,287.891,2450.42238,54311426100.00%08585094,83794,837011,6611,319.993,5170.38836,24112437100.00%08787097,19897,198011,9511,352.795,8460.35634,07613447100.00%08989099,61999,619012,2491,386.498,2320.32632,04114459100.00%092920102,099102,099012,5541,420.9100,6780.29930,12815470100.00%094940104,641104,641012,8661,456.3103,1850.27528,32816482100.00%096960107,247107,247013,1871,492.6105,7540.25226,63617494100.00%099990109,917109,917013,5151,529.7108,3880.23125,04518506100.00%01011010112,654112,654013,8521,567.8111,0860.21223,55019519100.00%01041040115,459115,459014,1971,606.9113,8530.19422,14320532100.00%01061060118,334118,334014,5501,646.9116,6870.17820,821

VAN SOCIAL166,865.13TIR SOCIAL12.23%

SensibilidadANALISIS DE SENSIBILIDADPROYECTO:SISTEMA DE AGUA POTABLEVariacion PorcentualEn la inversionEn la operacin y mantenimientoVariacion PorcentualEn la inversionEn la operacin y mantenimientoVariacion PorcentualEn la inversionEn la operacin y mantenimientoALTERNATIVA 01ALTERNATIVA 01ALTERNATIVA 01ALTERNATIVA 01ALTERNATIVA 01ALTERNATIVA 01VANSTIRVANSTIRVANSTIRVANSTIRVANSTIRVANSTIR

20-1,202,068.86-0.4097,267.4612.0120119,067.2514.46%116,720.9514.41%20119,067.2514.46%116,720.950.00%

10-529,420.563.6397,267.4612.0110109,144.9813.25%106,994.2013.21%10109,144.9813.25%106,994.200.00%

099,222.710.1297,267.460.12099,222.7112.05%97,267.4612%099,222.7112.05%97,267.460%

-10130,654.8812.81101,177.9712.09-1089,300.4411%87,540.7111%-1089,300.440.1187,540.710.00

-20162,087.0413.63103,133.2212.12-2079,378.1710%77,813.9710%-2079,378.170.1077,813.970.00

-30

VARIACINVAN SOCIALTIR SOCIAL200.00%19,389.559.78%1000.00%12,086.729.49%2200.00%1,132.469.05%

En la operacin y mantenimientoALTERNATIVA UNICAC/ELC

ERROR:#REF!282.0ERROR:#REF!282.0ERROR:#REF!282.0ERROR:#REF!282.0ERROR:#REF!282.0

SISTEMA DE SANEAMIENTO REDES ALCANTARILLADOVariacion PorcentualEn la inversionALTERNATIVA UNICAIIC/ELCC/ELCC/ELC

13.6ERROR:#REF!282.012ERROR:#REF!282.010ERROR:#REF!282.05ERROR:#REF!282.00ERROR:#REF!282.00.000.00

En la operacin y mantenimientoALTERNATIVA N01C/ELC

12.91109.010.88109.09.51109.08.15109.06.79109.0

PLANTA DE TRATAMIENTOVariacion PorcentualEn la inversionALTERNATIVA N01ALTERNATIVA N 02ALTERNATIVA N 02C/ELCC/ELCC/ELC

116.58.35109.0263.92109.0130.96109.0757.79109.0214.38109.0128.92109.0507.46109.0184.53109.0127.56109.0257.12109.0154.68109.0126.20109.006.79109.0124.84109.00124.84109.00

CUADRO RESUMEN SENSIBILIDAD PARA CADA SISTEMADESCRIPCION% MAXIMO DE SENSIBILIDADSISTEMA DE AGUA POTABLE20SISTEMA DE ALCANTARILLADO 13.6PLANTA DE TRATAMIENTO116.5

ICE AGUACUADRO N 1INDICE COSTO EFECTIVIDAD DEL SUBCOMPONENTE AGUA POTABLEALTERNATIVA 01126891011AosPoblacion TotalInversin Total a precios sociales (S/.)Costos de Operacin y mantenimiento incrementalesTOTAL COSTOSFactor de descuentoValor actual del flujo neto a precios sociales

10%

626,790626,7901.000626,790133301,940.01,9400.9091,764234101,988.31,9880.8261,643335002,037.82,0380.7511,531435902,088.62,0890.6831,427536802,140.62,1410.6211,329637702,193.92,1940.5641,238738602,248.52,2480.5131,154839602,304.52,3040.4671,075940602,361.92,3620.4241,0021041602,420.72,4210.3869331142602,480.92,4810.3508701243702,542.72,5430.3198101344702,606.02,6060.2907551445902,670.92,6710.2637031547002,737.42,7370.2396551648202,805.62,8060.2186111749402,875.42,8750.1985691850602,947.02,9470.1805301951903,020.43,0200.1644942053203,095.63,0960.149460

VAC646,342.29POBLACION BENEFICIADA432ICE = S/.1495.12S/. Pob. BeneficICE = $/.467.22$/. Pob. BeneficCOMPONENTEVALOR CALCULADOLINEA DE CORTEAgua Potable467.2238502228ANEXO SNIP 08TOTAL467.2238502228$ 183.00EL SIGUIENTE PARAMETRO PARA EL SISTEMA DE AGUA POTABLE $ 121.41 < $ 183.00 , ES MENOR QUE EL DEL INDICADO EN EL ANEXO 08

ICE AlcantarilladoIINDICE COSTO EFECTIVIDAD DEL SUBCOMPONENTE SANEAMIENTO-REDESAONuevas ConexionesPob. Benf. IncrementalPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor ActualICE EN LOS BENEFICIARIOS

BENEFICIARIOS% BENEFICIARIOSINDICADOR COSTO EFECTIVIDAD00ERROR:#REF!ERROR:#REF!1.000ERROR:#REF!100.00%346ERROR:#REF!1672662665645640.91751797.50%337ERROR:#REF!2272735785780.84248696.00%332ERROR:#REF!3272805925920.77245794.00%325ERROR:#REF!4272876076070.70843092.00%318ERROR:#REF!5272946226220.65040490.00%311ERROR:#REF!6273016376370.59638089.00%308ERROR:#REF!7283096536530.54735788.27%305ERROR:#REF!8283176696690.5023369283246866860.46031610283327037030.42229711283417217210.38827912283497397390.35626313293587577570.326247100.687514293677767760.29923215293767957950.27521816293858158150.252205172103958358350.231193182104058568560.212181193104158778770.194171203104258998990.178160COMPONENTEVALOR CALCULADOLINEA DE CORTE* VAC =ERROR:#REF!TOTALERROR:#REF!$ 282.00*Promedio poblacin Benef. = 346*ICE =ERROR:#REF!= ERROR:#REF!S./pob. BeneficEL SIGUIENTE PARAMETRO PARA EL SISTEMA DE ALCANTARILLADO $ 322.20 < $ 282.00 346, ES MENOR QUE EL DEL INDICADO EN EL ANEXO 08 ERROR:#REF!$/pob. Benefic

+5.00%AONuevas ConexionesPob. Benf. IncrementalPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

0000ERROR:#REF!0ERROR:#REF!1.000ERROR:#REF!16726626605645640.91751722727305785780.84248632728005925920.77245742728706076070.70843052729406226220.65040462730106376370.59638072830906536530.54735782831706696690.50233692832406866860.460316102833207037030.422297112834107217210.388279122834907397390.356263132935807577570.326247142936707767760.299232152937607957950.275218162938508158150.2522051721039508358350.2311931821040508568560.2121811931041508778770.1941712031042508998990.178160* VAC =ERROR:#REF!*Promedio poblacin Benef. = 346*ICE =ERROR:#REF!= ERROR:#REF!S./pob. Benefic346ERROR:#REF!
USER: USER:$/pob. Benefic+10.82%AONuevas ConexionesPob. Benf. IncrementalPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

0000ERROR:#REF!0ERROR:#REF!1.000ERROR:#REF!16726626605645640.91751722727305785780.84248632728005925920.77245742728706076070.70843052729406226220.65040462730106376370.59638072830906536530.54735782831706696690.50233692832406866860.460316102833207037030.422297112834107217210.388279122834907397390.356263132935807577570.326247142936707767760.299232152937607957950.275218162938508158150.2522051721039508358350.2311931821040508568560.2121811931041508778770.1941712031042508998990.178160* VAC =ERROR:#REF!*Promedio poblacin Benef. = 346*ICE =ERROR:#REF!= ERROR:#REF!S./pob. Benefic346ERROR:#REF!
USER: USER:$/pob. Benefic10.82%AONuevas ConexionesPob. Benf. IncrementalPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

0000ERROR:#REF!0ERROR:#REF!1.000ERROR:#REF!16726626605645640.91751722727305785780.84248632728005925920.77245742728706076070.70843052729406226220.65040462730106376370.59638072830906536530.54735782831706696690.50233692832406866860.460316102833207037030.422297112834107217210.388279122834907397390.356263132935807577570.326247142936707767760.299232152937607957950.275218162938508158150.2522051721039508358350.2311931821040508568560.2121811931041508778770.1941712031042508998990.178160

* VAC =ERROR:#REF!*Promedio poblacin Benef. = 346*ICE =ERROR:#REF!= ERROR:#REF!S./pob. Benefic346ERROR:#REF!
USER: USER:$/pob. Benefic13.60%AONuevas ConexionesPob. Benf. IncrementalPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

0000ERROR:#REF!0ERROR:#REF!1.000ERROR:#REF!16726626605645640.91751722727305785780.84248632728005925920.77245742728706076070.70843052729406226220.65040462730106376370.59638072830906536530.54735782831706696690.50233692832406866860.460316102833207037030.422297112834107217210.388279122834907397390.356263132935807577570.326247142936707767760.299232152937607957950.275218162938508158150.2522051721039508358350.2311931821040508568560.2121811931041508778770.1941712031042508998990.178160

* VAC =ERROR:#REF!*Promedio poblacin Benef. = 346*ICE =ERROR:#REF!= ERROR:#REF!S./pob. Benefic346ERROR:#REF!
USER: USER:

$/pob. BeneficEN LA OPERACIN Y MANTENIMIENTO5.00%AONuevas ConexionesPob. Benf. IncrementalPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

00ERROR:#REF!ERROR:#REF!1.000ERROR:#REF!1672662665925920.9175432272736066060.8425103272806226220.7724804272876376370.7084515272946536530.6504246273016696690.5963997283096866860.5473758283177037030.5023539283247207200.46033210283327387380.42231211283417577570.38829312283497757750.35627613293587957950.32625914293678158150.29924415293768358350.27522916293858568560.252216172103958778770.231203182104058998990.212191193104159219210.194179203104259449440.178168* VAC =ERROR:#REF!*Promedio poblacin Benef. = 346*ICE =ERROR:#REF!= ERROR:#REF!S./pob. Benefic346ERROR:#REF!
USER: USER:$/pob. Benefic

+10.00%AONuevas ConexionesPob. Benf. IncrementalPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

0000ERROR:#REF!0ERROR:#REF!1.000ERROR:#REF!1672662660619.856200.9175692272730635.286350.8425353272800651.106510.7725034272870667.326670.7084735272940683.936840.6504456273010700.967010.5964187283090718.427180.5473938283170736.307360.5023709283240754.647550.46034710283320773.437730.42232711283410792.697930.38830712283490812.428120.35628913293580832.658330.32627214293670853.398530.29925515293760874.648750.27524016293850896.418960.252226172103950918.749190.231212182104050941.619420.212200193104150965.069650.194188203104250989.099890.178176* VAC =ERROR:#REF!*Promedio poblacin Benef. = 346*ICE =ERROR:#REF!= ERROR:#REF!S./pob. Benefic346ERROR:#REF!
USER: USER:$/pob. Benefic12.00%AONuevas ConexionesPob. Benf. IncrementalPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

0000ERROR:#REF!0ERROR:#REF!1.000ERROR:#REF!16726626606316310.91757922727306476470.84254432728006636630.77251242728706796790.70848152729406966960.65045362730107147140.59642672830907317310.54740082831707507500.50237692832407687680.460354102833207877870.422333112834108078070.388313122834908278270.356294132935808488480.326277142936708698690.299260152937608918910.275244162938509139130.2522301721039509359350.2312161821040509599590.2122031931041509839830.19419120310425010071,0070.178180* VAC =ERROR:#REF!*Promedio poblacin Benef. = 346*ICE =ERROR:#REF!= ERROR:#REF!S./pob. Benefic346ERROR:#REF!
USER: USER:$/pob. Benefic13.60%AONuevas ConexionesPob. Benf. IncrementalPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

0000ERROR:#REF!0ERROR:#REF!1.000ERROR:#REF!16726626606406400.91758722727306566560.84255232728006726720.77251942728706896890.70848852729407067060.65045962730107247240.59643272830907427420.54740682831707607600.50238292832407797790.460359102833207997990.422337112834108198190.388317122834908398390.356298132935808608600.326280142936708818810.299264152937609039030.275248162938509269260.2522331721039509499490.2312191821040509729720.2122061931041509979970.19419420310425010211,0210.178182

* VAC =ERROR:#REF!*Promedio poblacin Benef. = 346*ICE =ERROR:#REF!= ERROR:#REF!S./pob. Benefic346ERROR:#REF!
USER: USER:

$/pob. Benefic

ICEPlanta tramI ALTER N 01INDICE COSTO EFECTIVIDAD DEL SUBCOMPONENTE SANEAMIENTO-PLANTA DE TRATAMIENTO Alt 01AOPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

01,853.521,853.521.0001,853.521333693693.000.917635.782341710710.260.842597.813350728727.940.772562.104359746746.070.708528.535368765764.640.650496.976377784783.680.596467.287386803803.200.547439.388396823823.200.502413.139406844843.690.460388.4610416865864.700.422365.2611426886886.230.388343.4412437908908.300.356322.9313447931930.920.326303.6514459954954.100.299285.5115470978977.850.275268.46164821,0021,002.200.252252.42174941,0271,027.160.231237.35185061,0531,052.730.212223.17195191,0791,078.950.194209.84205321,1061,105.810.178197.31* VAC =9,392Planta de Tratamiento6.7894615856*Promedio poblacin Benef. = 432TOTAL6.7894615856$ 6.79*ICE =9,392= 21.73S./poblador beneficiado432EL SIGUIENTE PARAMETRO $ 56.10 < $ 109.00 , 6.79$/pob. BeneficES MENOR QUE EL DEL INDICADO EN EL ANEXO 08+25.00%AOPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

002316.9002316.901.0002316.9013330693693.000.917635.7823410710710.260.842597.8133500728727.940.772562.1043590746746.070.708528.5353680765764.640.650496.9763770784783.680.596467.2873860803803.200.547439.3883960823823.200.502413.1394060844843.690.460388.46104160865864.700.422365.26114260886886.230.388343.44124370908908.300.356322.93134470931930.920.326303.65144590954954.100.299285.51154700978977.850.275268.4616482010021002.200.252252.4217494010271027.160.231237.3518506010531052.730.212223.1719519010791078.950.194209.8420532011061105.810.178197.31* VAC =9,856*Promedio poblacin Benef. = 432*ICE =9,856= 22.80S./poblador beneficiado4327.12$/pob. Benefic+50.00%

AOPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

002780.2802780.281.0002780.2813330693693.000.917635.7823410710710.260.842597.8133500728727.940.772562.1043590746746.070.708528.5353680765764.640.650496.9763770784783.680.596467.2873860803803.200.547439.3883960823823.200.502413.1394060844843.690.460388.46104160865864.700.422365.26114260886886.230.388343.44124370908908.300.356322.93134470931930.920.326303.65144590954954.100.299285.51154700978977.850.275268.4616482010021002.200.252252.4217494010271027.160.231237.3518506010531052.730.212223.1719519010791078.950.194209.8420532011061105.810.178197.31* VAC =10,319*Promedio poblacin Benef. = 432*ICE =10,319= 23.87S./poblador beneficiado4327.46$/pob. Benefic75.00%AOPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

003243.6603243.661.0003243.6613330693693.000.917635.7823410710710.260.842597.8133500728727.940.772562.1043590746746.070.708528.5353680765764.640.650496.9763770784783.680.596467.2873860803803.200.547439.3883960823823.200.502413.1394060844843.690.460388.46104160865864.700.422365.26114260886886.230.388343.44124370908908.300.356322.93134470931930.920.326303.65144590954954.100.299285.51154700978977.850.275268.4616482010021002.200.252252.4217494010271027.160.231237.3518506010531052.730.212223.1719519010791078.950.194209.8420532011061105.810.178197.31

* VAC =10,782*Promedio poblacin Benef. = 432*ICE =10,782= 24.94S./poblador beneficiado4327.79$/pob. Benefic

+116.50%AOPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

004012.8704012.871.0004012.8713330693693.000.917635.7823410710710.260.842597.8133500728727.940.772562.1043590746746.070.708528.5353680765764.640.650496.9763770784783.680.596467.2873860803803.200.547439.3883960823823.200.502413.1394060844843.690.460388.46104160865864.700.422365.26114260886886.230.388343.44124370908908.300.356322.93134470931930.920.326303.65144590954954.100.299285.51154700978977.850.275268.4616482010021002.200.252252.4217494010271027.160.231237.3518506010531052.730.212223.1719519010791078.950.194209.8420532011061105.810.178197.31

* VAC =11,552*Promedio poblacin Benef. = 432*ICE =11,552= 26.72S./poblador beneficiado4328.35$/pob. BeneficEN LA OPERACIN Y MANTENIMIENTO+25.00%AOPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

001853.5201853.521.0001853.5213330866866.250.917794.7223410888887.820.842747.2633500910909.930.772702.6343590933932.580.708660.6753680956955.800.650621.2163770980979.600.596584.117386010041004.000.547549.228396010291029.000.502516.429406010551054.620.460485.5810416010811080.880.422456.5711426011081107.790.388429.3112437011351135.380.356403.6713447011641163.650.326379.5614459011931192.620.299356.8915470012221222.320.275335.5716482012531252.750.252315.5317494012841283.950.231296.6918506013161315.920.212278.9719519013491348.680.194262.3120532013821382.270.178246.64* VAC =11,277*Promedio poblacin Benef. = 432*ICE =11,277= 26.09S./poblador beneficiado4328.15$/pob. Benefic+50.00%AOPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

001853.5201853.521.0001853.521333010401039.500.917953.672341010651065.380.842896.713350010921091.910.772843.164359011191119.100.708792.805368011471146.970.650745.456377011761175.530.596700.937386012051204.800.547659.068396012351234.800.502619.709406012661265.540.460582.6910416012971297.050.422547.8911426013291329.350.388515.1712437013621362.450.356484.4013447013961396.380.326455.4714459014311431.150.299428.2715470014671466.780.275402.6916482015031503.300.252378.6417494015411540.740.231356.0218506015791579.100.212334.7619519016181618.420.194314.7720532016591658.720.178295.97* VAC =13,162*Promedio poblacin Benef. = 432*ICE =13,162= 30.45S./poblador beneficiado4329.51$/pob. Benefic75.00%AOPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

001853.5201853.521.0001853.521333012131212.750.9171112.612341012431242.950.8421046.163350012741273.900.772983.684359013061305.620.708924.935368013381338.130.650869.696377013711371.450.596817.757386014061405.600.547768.918396014411440.590.502722.999406014761476.470.460679.8110416015131513.230.422639.2011426015511550.910.388601.0312437015901589.530.356565.1313447016291629.110.326531.3814459016701669.670.299499.6415470017111711.240.275469.8016482017541753.850.252441.7417494017981797.530.231415.3618506018421842.280.212390.5519519018881888.160.194367.2320532019351935.170.178345.29* VAC =15,046*Promedio poblacin Benef. = 432*ICE =15,046= 34.81S./poblador beneficiado43210.88$/pob. Benefic+112.40%AOPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

001853.5201853.521.0001853.521333014721471.930.9171350.402341015091508.580.8421269.743350015461546.150.7721193.914359015851584.650.7081122.605368016241624.100.6501055.566377016651664.540.596992.517386017061705.990.547933.248396017481748.470.502877.509406017921792.010.460825.0910416018371836.630.422775.8111426018821882.360.388729.4812437019291929.230.356685.9113447019771977.270.326644.9414459020272026.500.299606.4215470020772076.960.275570.2116482021292128.680.252536.1517494021822181.680.231504.1318506022362236.010.212474.0219519022922291.680.194445.7120532023492348.750.178419.09* VAC =17,866*Promedio poblacin Benef. = 432*ICE =17,866= 41.33S./poblador beneficiado43212.91$/pob. Benefic

ICEPlanta tramI ALTER N 02INDICE COSTO EFECTIVIDAD DEL SUBCOMPONENTE SANEAMIENTO-PLANTA DE TRATAMIENTO Alt. 02AOPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

0165,157.32165,157.321.000165,157.321333693693.000.917635.782341710710.260.842597.813350728727.940.772562.104359746746.070.708528.535368765764.640.650496.976377784783.680.596467.287386803803.200.547439.388396823823.200.502413.139406844843.690.460388.4610416865864.700.422365.2611426886886.230.388343.4412437908908.300.356322.9313447931930.920.326303.6514459954954.100.299285.5115470978977.850.275268.46164821,0021,002.200.252252.42174941,0271,027.160.231237.35185061,0531,052.730.212223.17195191,0791,078.950.194209.84205321,1061,105.810.178197.31* VAC =172,696Planta de Tratamiento124.8374838761*Promedio poblacin Benef. = 432TOTAL124.8374838761$ 124.84*ICE =172,696= 399.48S./poblador beneficiado432EL SIGUIENTE PARAMETRO $ 108.74 < $ 109.00 , 124.84$/pob. BeneficES MENOR QUE EL DEL INDICADO EN EL ANEXO 08+25.00%AOPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

00206446.650206446.651.000206446.6513330693693.000.917635.7823410710710.260.842597.8133500728727.940.772562.1043590746746.070.708528.5353680765764.640.650496.9763770784783.680.596467.2873860803803.200.547439.3883960823823.200.502413.1394060844843.690.460388.46104160865864.700.422365.26114260886886.230.388343.44124370908908.300.356322.93134470931930.920.326303.65144590954954.100.299285.51154700978977.850.275268.4616482010021002.200.252252.4217494010271027.160.231237.3518506010531052.730.212223.1719519010791078.950.194209.8420532011061105.810.178197.31* VAC =213,985*Promedio poblacin Benef. = 432*ICE =213,985= 494.99S./poblador beneficiado432154.68$/pob. Benefic+50.00%

AOPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

00247735.980247735.981.000247735.9813330693693.000.917635.7823410710710.260.842597.8133500728727.940.772562.1043590746746.070.708528.5353680765764.640.650496.9763770784783.680.596467.2873860803803.200.547439.3883960823823.200.502413.1394060844843.690.460388.46104160865864.700.422365.26114260886886.230.388343.44124370908908.300.356322.93134470931930.920.326303.65144590954954.100.299285.51154700978977.850.275268.4616482010021002.200.252252.4217494010271027.160.231237.3518506010531052.730.212223.1719519010791078.950.194209.8420532011061105.810.178197.31* VAC =255,275*Promedio poblacin Benef. = 432*ICE =255,275= 590.50S./poblador beneficiado432184.53$/pob. Benefic75.00%AOPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

00289025.310289025.311.000289025.3113330693693.000.917635.7823410710710.260.842597.8133500728727.940.772562.1043590746746.070.708528.5353680765764.640.650496.9763770784783.680.596467.2873860803803.200.547439.3883960823823.200.502413.1394060844843.690.460388.46104160865864.700.422365.26114260886886.230.388343.44124370908908.300.356322.93134470931930.920.326303.65144590954954.100.299285.51154700978977.850.275268.4616482010021002.200.252252.4217494010271027.160.231237.3518506010531052.730.212223.1719519010791078.950.194209.8420532011061105.810.178197.31

* VAC =296,564*Promedio poblacin Benef. = 432*ICE =296,564= 686.01S./poblador beneficiado432214.38$/pob. Benefic

+116.50%AOPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

00357565.590357565.591.000357565.5913330693693.000.917635.7823410710710.260.842597.8133500728727.940.772562.1043590746746.070.708528.5353680765764.640.650496.9763770784783.680.596467.2873860803803.200.547439.3883960823823.200.502413.1394060844843.690.460388.46104160865864.700.422365.26114260886886.230.388343.44124370908908.300.356322.93134470931930.920.326303.65144590954954.100.299285.51154700978977.850.275268.4616482010021002.200.252252.4217494010271027.160.231237.3518506010531052.730.212223.1719519010791078.950.194209.8420532011061105.810.178197.31

* VAC =365,104*Promedio poblacin Benef. = 432*ICE =365,104= 844.56S./poblador beneficiado432263.92$/pob. BeneficEN LA OPERACIN Y MANTENIMIENTO+25.00%AOPoblacion Benef. TotalInversionCostos de Operacin y Mant.Total CostosFactor de descuentoValor Actual

00165157.320165157.321.000165157.3213330866866.250.917794.7223410888887.820.842747.2633500910909.930.772702.6343590933932.580.708660.6753680956955.800.650621.2163770980979.600.596584.117386010041004.000.547549.228396010291029.000.502516.429406010551054.620.460485.5810416010811080.880.422456.5711426011081107.790.388429.3112437011351135.380.356403.6713447011641163.650.326379.5614459011931192.620.299356.8915470012221222.320.275335.5716482012531252.750.252315.531749401284