verif.reajustes valorizacion n° 21 mayo.2013 (2)

Upload: yhon-eddy-vilca-peralta

Post on 30-Oct-2015

34 views

Category:

Documents


0 download

TRANSCRIPT

Planilla (2)9.0017ERROR:#REF!Devolucin de fondo de garantaERROR:#REF!ERROR:#REF!

OBRA: REHABILITACION Y MEJORAMIENTO DE LA CARRETERA PATAHUASI - YAURI - SICUANICONTRATISTA: CONSORCIO VIAL EL DESCANSO - LANGUICONTRATISTACONTRATOERROR:#REF!PRESUPUESTO : S/.70'599,929.37 (Inc. IGV) CONTRATISTALUGAR: DEPARTAMENTO: CUSCO; PROVINCIA: CANASPRECIOS : DICIEMBRE 2009LUGAR1234567891011121314151617181920ItemDESCRIPCION DE PARTIDAUnd.METRADO ACTUALIZADOP. UNIT.PARCIALACUMULADO ANTERIORPRESENTE VALORIZACIONACUMULADO ACTUALSALDO POR VALORIZARVac 01Vac 02Vac 03Vac 04Vac 05Vac 06Vac 07Vac 08Vac 09Vac 10Vac 11Vac 12Vac 13Vac 14Vac 15Vac 16Vac 17Vac 18Vac 19Vac 20ACTUALIZADOS/.S/.METRADOS/.METRADOS/.METRADOS/.METRADOS/.Oct-10Nov-10Dec-10Jan-11Feb-11Mar-11Apr-11May-11Jun-11Jul-11Aug-11Sep-11Oct-11Nov-11Dec-11Jan-12Feb-12Mar-12Apr-12May-12100PRELIMINARES2,870,111.232,244,383.820.002,244,383.82625,727.41101.AMovilizacin y Desmovilizacin de Equipoglb1.001,982,568.301,982,568.300.7941,574,668.300.0000.000.79431,574,668.300.2057407,900.00-0.045600.018590.004440.05600.02410.05140.10590.100.040.020.010.11000.07970.1251102.ATopografa y Georeferenciacionkm19.814,253.4484,260.6519.81084,260.650.0000.0019.810084,260.650.00000.00-3.960001.580001.581.581.581.581.581.271.271.091.091.64103.AMantenimiento de Transito y Seguridad Vialglb1.00763,365.22763,365.220.7399564,791.010.0000.000.7399564,791.010.2601198,574.21-0.002400.009300.01390.02350.03320.03890.0400.090.060.070.03860.040.090.090.10104.AAcceso a Canteras Botaderos y Fuentes de Aguakm1.747,030.3812,232.861.7412,232.860.0000.001.740012,232.860.000.00-0.390.360.540.45105.AReubicacin de Postesund4.001,003.304,013.204.004,013.200.0000.004.004,013.200.000.00-4.00106.ATubera de PVC D=1" para Agua Potablem220.0075.7316,660.600.000.000.0000.000.000.00220.0016,660.60-107.ATubera de PVC D=1/2" para Agua Potablem60.0073.634,417.8060.004,417.800.0000.0060.004,417.800.000.00-60.00108ATubera de PVC 8"m20.00129.632,592.600.000.000.0000.000.000.0020.002,592.60-0.00-200MOVIMIENTO DE TIERRAS0.004,557,692.214,557,692.210.004,557,692.210.00-205.BCorte en Roca Fijam318,504.7128.57528,679.5618,504.71528,679.560.000.0018,504.71528,679.560.000.00-0.0797.786,833.038,771.120.02,102.78205.CCorte en Roca Sueltam337,189.3811.38423,215.1437,189.38423,215.140.000.0037,189.38423,215.140.00000000000.00-6,824.3483.285,596.3811,050.908,441.412,105.323,087.750.00-0.000.0205.DCorte de Material Sueltom3315,416.904.211,327,905.15315,416.901,327,905.150.000.00315,416.901,327,905.150.000.00-16,477.0849,561.9040,655.9855,738.8041,251.3224,190.1927,268.9234,573.781,016.1724,682.75210.AConformacin de Terraplenes con Material Propiom315,892.8414.20225,678.3315,892.84225,678.330.000.0015,892.84225,678.330.000.00-579.013,151.355,150.203,858.8811,271.380.0-8,684.35566.37210.BConformacin de Terraplenes con Material de Prstamom345,777.0626.111,195,239.0445,777.061,195,239.040.000.0045,777.061,195,239.040.000.00-2,152.308,315.7612,158.780.021,218.761,931.460.000.0212.APerfilado Compactacin de Sub-Rasante en Zona de Cortem2137,098.052.26309,841.59137,098.05309,841.590.000.00137,098.05309,841.590.000.00-37,626.0139,283.2312,530.9552,785.11-19,921.0111,512.393,281.250.12220.AMejoramiento de Suelos a Nivel de Subrasantem318,117.0030.20547,133.4018,117.00547,133.400.000.0018,117.00547,133.400.000.00-1,894.9516,222.050.00.00.00.00-300SUB BASES Y BASES0.002,633,114.232,618,624.10-9.572,618,614.5314,499.70-303.CSub-Base Granularm30.0050.020.000.000.000.000.000.000.000.000.00-305.DBase Granularm338,529.6268.342,633,114.2338,317.592,618,624.10-0.14-9.5738,317.452,618,614.53212.1714,499.70-7,061.828,287.5114,076.845,354.163,537.26-0.140.00-400PAVIMENTO ASFALTICO0.005,944,739.225,805,838.76134,904.175,940,742.923,996.30-401.AImprimacin Asflticam2192,938.291.24239,243.48182,082.66225,782.5010,855.6313,460.98192,938.29239,243.480.000.00-27,108.84103,299.9238,101.7213,572.1810,855.63402.ARiego de Ligam2117.410.93109.190.000.00117.41109.19117.41109.190.000.00-0.0117.41410.APavimento de Concreto Asfaltico Caliente (MAC)m313.84288.753,996.300.000.000.000.000.000.0013.843,996.30-0.0420.DCemento Asfaltico de Penetracin 120-150gin510,296.129.204,694,724.30505,357.544,649,289.374,938.5845,434.94510,296.124,694,724.300.000.00-16,128.31179,831.47309,397.764,938.58422.AAsfalto Diluido Tipo MC-30gln57,882.579.92574,195.0954,625.83541,888.233,256.7432,306.8657,882.57574,195.090.000.00-8,132.7630,989.8711,430.514,072.693,256.74422.EAsfalto RC-250gin22.3110.34230.690.000.0022.31230.6922.31230.690.000.00-0.022.31423.AFiller Mineral (Cal Hidratada)kg317,394.540.96304,698.76273,615.70262,671.0743,778.8442,027.69317,394.54304,698.760.000.00-20,040.58223,453.4730,121.6543,778.84450.AAditivo Mejorador de Adherenciakg9,676.8913.18127,541.419,575.69126,207.59101.201,333.829,676.89127,541.410.000.00-305.843,410.095,859.76101.200.00-600OBRAS DE ARTE Y DRENAJE0.009,901,325.159,689,943.65191,001.969,880,945.6120,379.54-601.CExcavacin para Estructuras en Secom313,216.9212.68167,590.5513,216.92167,590.550.000.0013,216.92167,590.550.000.00-86.70243.57332.30589.491,193.906,861.213,909.750.00.00.00.00.00.0601.DExcavacin Bajo Aguam32,371.9229.3369,568.412,371.9269,568.410.000.002,371.9269,568.410.000.00-0.00.00.00.00.01,393.790.00.0978.13601.ELimpieza de Caucem35,303.9913.4171,126.515,303.9971,126.510.000.005,303.9971,126.510.000.00-0.00.00.00.00.00.03,272.321,035.04996.63601.FDemolicin de Estructurasm360.10152.599,170.6660.109,170.660.000.0060.109,170.660.000.00-0.00.00.060.100.00.00.00.00.0605.ARelleno para Estructurasm311,408.5735.20401,581.6611,408.57401,581.660.000.0011,408.57401,581.660.000.00-56.74131.73333.00648.301,125.232,372.151,285.791,884.601,830.49-192.161,629.59303.110.0605.BMaterial Filtrantem3491.21154.3875,833.00491.2175,833.000.000.00491.2175,833.000.000.00-21.330.018.4143.11221.70256.57-112.1342.210.01605.CRelleno para Estructuras con Material de Sub Basem3145.2066.019,584.65145.209,584.650.000.00145.209,584.650.000.00-0.00.00.00.00.0138.216.990.00.0610.CConcreto fc=280 kg/cm2m3536.48530.30284,495.34536.48284,495.340.000.00536.48284,495.340.000.00-0.00.00.00.0225.39179.42131.670.00.0610.DConcreto fc =210 kg/cm2m3876.44502.29440,227.05876.44440,227.050.000.00876.44440,227.050.000.00-0.00.0367.64243.76255.8836.91-27.750.00.0610.FConcreto Ciclpeo fc =210 kg/cm2 + 30% pgm3302.54406.38122,946.21302.54122,946.210.000.00302.54122,946.210.000.00-0.00.00.0302.540.00.00.00.00.0610.GConcreto Ciclpeo fc =175 kg/cm2 + 30% pmm31,398.88380.19531,840.191,368.31520,217.7822.308,478.241,390.61528,696.028.273,144.17-0.0464.5464.49264.764.80352.70200.480.016.5422.30610.IConcreto fc =100 kg/cm2m3124.43397.5049,460.93124.4349,460.930.000.00124.4349,460.930.000.00-0.00.027.5920.6676.180.00.00.00.0612.AEncofrado y Desencofradom27,559.7478.34592,230.037,416.82581,033.6892.187,221.387,509.00588,255.0650.743,974.97-1,435.67560.681,028.252,171.23263.341,672.1327.39144.90113.2392.18612.BEncofrado Bajo Aguam279.16149.5311,836.7979.1611,836.790.000.0079.1611,836.790.000.00-0.00.00.00.079.160.00.00.00.0612.CEncofrado de Losas y Tablerosm2171.13161.0927,567.33171.1327,567.330.000.00171.1327,567.330.000.00-0.00.00.00.00.00.0171.130.00.0612.DEncofrado de Elevacinm2641.47107.1668,739.93641.4768,739.930.000.00641.4768,739.930.000.00-0.00.00.00.0294.99346.480.00.00.0612.EEncofrado Cara Vistam234.22122.814,202.5634.224,202.560.000.0034.224,202.560.000.00-0.00.00.00.00.042.27-8.050.00.0615.AAcero de Refuerzokg133,636.015.89787,116.10133,480.46786,199.910.000.00133,480.46786,199.91155.55916.19-0.00.017,387.1021,268.7751,702.1825,106.3017,373.07643.040.0622.BAlcantarilla TMC D=36"m1,366.01486.82665,000.991,366.01665,000.99-15.39-7,492.161,350.62657,508.8315.397,492.16-25.1151.6591.47134.86243.19196.43350.79223.5717.0020.9510.990.00.0-15.39622.CAlcantarilla TMC D=48"m28.60819.8823,448.5728.6023,448.570.000.0028.6023,448.570.000.00-0.028.600.00.00.00.00.00.00.0622.DAlcantarilla TMC D=60"m43.031,228.4652,860.6343.0352,860.630.000.0043.0352,860.630.000.00-0.00.043.030.00.00.00.00.00.0625ASub Dren Tipo Im4,963.70272.141,350,821.324,963.701,350,821.320.000.004,963.701,350,821.320.000.00-367.76446.501,511.461,001.98817.50743.3675.140.00.0625.BSub Dren Tipo IIm475.40147.8870,302.15475.4070,302.150.000.00475.4070,302.150.000.00-40.0077.00174.000.085.730.098.670.00.0625.CSub Dren Transversal Tipo Im802.35152.71122,526.87802.35122,526.870.000.00802.35122,526.870.000.00-26.85137.63145.28142.80278.1542.0129.640.00.0625.DSub Dren Transversal Tipo IIm52.60115.736,087.4052.606,087.400.000.0052.606,087.400.000.00-0.012.8330.180.00.00.009.590.00.0625.ETubera de PVC Pesada Sin Perforacin D=3m529.1526.4513,996.02529.1513,996.020.000.00529.1513,996.020.000.00-17.1518.80122.1471.05-13.4760.04253.440.00.0625.FTubera de PVC Pesada con Perforacin D=6m686.4437.0425,425.74686.4425,425.740.000.00686.4425,425.740.000.00-30.0010.00101.8374.6039.85118.97253.7557.440.0635.ACunetas Triangulares Revestidas en Concretom22,434.53123.132,762,363.6821,076.812,595,187.621,357.19167,110.8022,434.002,762,298.420.5365.26-0.00.00.00.00.0274.968,465.559,478.322,857.981,357.19635.BZanja de Coronacinm3,124.00119.61373,661.643,073.98367,678.7510.001,196.103,083.98368,874.8540.024,786.79-0.00.00.00.0241.841,304.72718.47397.04411.9110.00635.CZanja de Drenajem561.0023.3113,076.910.000.00561.0013,076.91561.0013,076.910.000.00-0.00.00.00.00.00.00.00.00.0561.00635.GEmboquillado de Piedra E=0.15 mm21,256.13106.03133,187.461,256.13133,187.460.000.001,256.13133,187.460.000.00-0.00.00.00.0940.88315.250.00.00.0635.HEmboquillado de Piedra E=0.30 mm2333.20201.4067,106.48333.2067,106.480.000.00333.2067,106.480.000.00-0.00.00.00.00.094.94238.260.00.0635.IEmboquillado de Piedra E=0.80 mm21,281.17289.18370,488.741,281.17370,488.740.000.001,281.17370,488.740.000.00-0.00.00.00.0348.2721.20777.6579.9954.06650.AGeotextilm23,418.116.5822,491.163,418.1122,491.160.000.003,418.1122,491.160.000.00-71.100.0149.00640.3198.87511.85400.06140.721,406.20650.NGeocompuesto de Drenajem20.0046.050.000.000.000.000.000.000.000.000.00-0.00.00.00.00.00.00.00.00.0660.AJunta de Badnm270.2583.4322,546.96270.2522,546.960.000.00270.2522,546.960.000.00-0.00.00.00.00.00.0243.230.027.02660.BFalso Puentem9.88940.109,288.199.889,288.190.000.009.889,288.190.000.00-0.00.00.00.00.00.00.09.880.0660.CPintura Bituminosam2394.5718.837,429.75394.577,429.750.000.00394.577,429.750.000.00-0.00.00.00.00.0232.64161.930.00.0660.DJunta de Pontnm0.0050.730.000.000.000.000.000.000.000.000.00-0.00.00.00.00.00.00.00.00.0660.EJunta de Murosm2219.4040.348,850.60184.437,439.9134.971,410.69219.408,850.600.000.00-0.00.050.5995.92-86.4882.17-13.570.055.8034.97660.FPase Provisionalglb1.009,917.849,917.841.009,917.840.000.001.009,917.840.000.00-0.00.00.01.000.00.00.00.00.0670.AEnrocadom31,283.7235.3145,328.151,283.7245,328.150.000.001,283.7245,328.150.000.00-0.00.00.00.00.00.00.00.01,283.720.00-700TRANSPORTE0.005,501,594.735,467,132.870.005,467,132.8734,461.84-700.ATransporte de Materiales Granulares Entre 120 m y 1000 mm3k94,231.496.08572,927.4694,347.32573,631.710.000.0094,347.32573,631.71-115.83-704.25Error19,828.432,005.5745,615.5515,022.3910,581.252,424.10-1,129.97700.BTransporte de Material Granular Mayor a 1 km.m3k1,508,879.531.181,780,477.851,504,922.741,775,808.830.000.001,504,922.741,775,808.833,956.794,669.01-77,040.6014,588.28797,828.11725,324.38-42,600.840.0-67,257.79701.ATransporte de Mezcla Asfltica Hasta 1 km.m3k13,159.118.76115,273.8011,868.08103,964.380.000.0011,868.08103,964.381,291.0311,309.42-0.00.00.0408.894,856.206,602.99701.BTransporte de Mezcla Asfltica Mayor a 1 km.m3k114,215.002.30262,694.50106,088.82244,004.290.000.00106,088.82244,004.298,126.1818,690.21-0.00.00.0155.8823,406.9182,526.03702.ATransporte de Material Excedente Entre 120 m y 1000 mm3k288,084.207.082,039,636.14288,013.942,039,138.700.000.00288,013.942,039,138.7070.26497.44-19,799.4829,633.7940,325.4565,894.5539,494.6831,394.8754,758.306,783.080.00-70.26702.BTransporte de Material Excedente Mayor a 1 Kmm3k619,139.811.18730,584.98619,139.80730,584.960.000.00619,139.80730,584.960.010.01-31,681.2454,840.51126,557.00245,062.61160,998.450.00.00.00-0.010.00-800SEALIZACIN0.001,685,241.760.000.000.001,685,241.76-801.ASeal Preventiva (0.60 m x 0.60 m)und129.00422.1854,461.220.000.000.000.000.000.00129.0054,461.22-802.ASeal Reglamentaria (1.20 m x 0.80 m)und39.00539.3221,033.480.000.000.000.000.000.0039.0021,033.48-803.CSeal Informativam246.82521.8624,433.490.000.000.000.000.000.0046.8224,433.49-804.APoste de Soporte de Sealesund168.00217.2436,496.320.000.000.000.000.000.00168.0036,496.32-804.BEstructura de Soporte de Sealesund40.001,918.2076,728.000.000.000.000.000.000.0040.0076,728.00-810.AMarcas en el Pavimentom25,587.0114.0778,609.230.000.000.000.000.000.005,587.0178,609.23-820.AGuardava Metlicam5,950.00202.641,205,708.000.000.000.000.000.000.005,950.001,205,708.00-820.BSeccin Finalund49.00134.796,604.710.000.000.000.000.000.0049.006,604.71-820.CSeccin de Amortiguacinund49.00191.619,388.890.000.000.000.000.000.0049.009,388.89-825.ACaptafrosund3,118.0054.05168,527.900.000.000.000.000.000.003,118.00168,527.90-830.APoste de Kilometrajeund19.00171.083,250.520.000.000.000.000.000.0019.003,250.52-0.00-900PROTECCIN AMBIENTAL0.001,613,022.931,112,995.500.001,112,995.50500,027.43-902.ASealizacin Ambiental Temporalund21.00406.958,545.9510.004,069.500.0010.004,069.5011.004,476.45-10.00902.BSealizacin Ambiental Permanenteund2.001,938.153,876.300.000.000.000.000.000.002.003,876.30-905.AReacond. Area de Campamento y Patio de Mquinasha1.005,300.015,300.010.000.000.000.000.000.001.005,300.01-905.BReacond. Area de la Canteraha7.144,718.5933,690.730.000.000.000.000.000.007.1433,690.73-905.CReacond. Area de la Planta Chancadoraha0.502,072.351,036.180.000.000.000.000.000.000.501,036.18-905.DReacond. Area de la Planta de Preparacin de Asfaltoha0.502,072.351,036.180.000.000.000.000.000.000.501,036.18-905.EAcond. ME y Read. Morfolgica del Depsito de MEm3387,320.783.541,371,115.56309,535.141,095,754.410.000.00309,535.141,095,754.4177,785.64275,361.15-15,339.3036,793.2050,421.2118,820.6772,484.98160,997.31-162,000.00116,678.47906.ARevegetacinha15.3310,229.08156,811.800.000.000.000.000.000.0015.33156,811.80-907.APasivos Ambientalesglb1.008,311.418,311.410.000.000.000.000.000.001.008,311.41-908.AMonitoreo de la Calidad del Aguapto12.00776.639,319.566.004,659.780.000.006.004,659.786.004,659.78-2.004.00908.BMonitoreo de la Calidad del Airepto6.001,863.9011,183.404.007,455.600.000.004.007,455.602.003,727.80-2.002.00908.CMonitoreo de la Calidad de Ruidopto45.0062.132,795.8517.001,056.210.000.0017.001,056.2128.001,739.64-7.0010.00( A )COSTO DIRECTO34,706,841.4631,496,610.91325,896.5631,822,507.462,884,333.980.0113,145.20429,564.53664,044.101,072,872.701,540,185.191,803,871.111,836,272.814,085,897.032,968,828.901,402,678.861,788,120.751,905,521.323,713,219.230.0( B )GASTOS GENERALES20.05%de ( A )6,980,546.286,315,070.4865,342.266,380,412.74600,133.540.022,685.6186,127.69133,140.84215,110.98308,807.13361,676.16368,172.70819,222.35595,250.20281,237.110.00.00.00.0 GASTOS GENERALES FIJOS 0.20%0.00262882608091,238.2562,993.22651.7963,645.0127,593.240.0226.29859.131,328.092,145.753,080.373,607.743,672.558,171.795,937.662,805.360.00.00.00.0 GASTOS GENERALES VARIABLES19.85%0.1985000000056,889,308.036,252,077.2664,690.476,316,767.73572,540.300.022,459.3285,268.56131,812.75212,965.23305,726.76358,068.42364,500.15811,050.56589,312.54278,431.750.00.00.00.0( C )UTILIDAD10.00%de ( A )3,470,684.153,149,661.0932,589.663,182,250.75288,433.400.011,314.5242,956.4566,404.41107,287.27154,018.52180,387.11183,627.28408,589.70296,882.89140,267.89178,812.07190,552.13371,321.920.0( D )SUB TOTAL( A ) + ( B ) + ( C )45,158,071.8940,961,342.48423,828.4841,385,170.953,772,900.920.0147,145.33558,648.67863,589.351,395,270.952,003,010.842,345,934.382,388,072.795,313,709.083,860,961.991,824,183.861,966,932.822,096,073.454,084,541.150.0( E )I.G.V. ( 19% del S.T. )19.00%8,580,033.667,782,655.0780,527.417,863,182.48716,851.178.35%TOTAL53,738,105.5548,743,997.55504,355.8949,248,353.434,489,752.098.35%PORCENTAJE DE AVANCE VALORIZADO100.00%90.71%0.94%91.65%8.35%8.35%0.200%0.200%0.200%0.200%0.200%0.200%0.200%0.200%0.200%0.200%0.009390019.850%19.850%19.850%19.850%19.850%19.850%19.850%19.850%19.850%19.850%193,660.39147,145.33705,794.001,569,383.352,964,654.304,967,665.147,313,599.529,701,672.3115,015,381.3918,876,343.3820,700,527.24

283,798.08368,937.50147,145.33558,648.67863,589.341,395,270.952,003,010.832,345,934.392,388,072.825,313,709.083,860,961.991,824,183.88-0.000.000.01-0.000.01-0.01-0.03-0.000.00-0.02115,874.7540000

Polinomica Oferta

SISTEMA DE VALORIZACIONESSustento del Calculo del Coeficiente "K"OBRA PRINCIPAL

REHABILITACION Y MEJORAMIENTO DE LA CARRETERA PATAHUASI - YAURI - SICUANI; TRAMO: EL DESCANSO - LANGUI

Supervisor: CONSORCIO SICUANI IIContratista: CONSORCIO VIAL EL DESCANSO - LANGUIContratoPresupuesto: S/.70'599,929.37 (Inc. IGV) Fecha Presup.: DICIEMBRE 2009Zona GeograficaFORMULA POLINOMICAK = 0.055 Mr / Mo + 0.051 ADFr / ADFo + 0.114 APr / APo + 0.28 Cr / Co +0.287 Mr / Mo +0.213 Ir / Io

SIMBOLOI.U.DESCRIPCIONCOEF.INCIDENCIAK baseESPECIFICADec-07Dec-09Jan-08Feb-08Apr-09May-09Jun-09Jul-09Aug-09Sep-09

M47MANO DE OBRA (INC. LEYES SOCIALES)0.055100.000%374.22374.22374.78374.78397.23397.23413.41413.41413.41413.410.055 Mr / Mo0.0550.0550.0550.0550.0580.0580.0610.0610.0610.061

ADF4AGREGADO FINO0.05147.059%372.66372.66379.05381.84414.64415.09405.71397.69400.87403.6530DLAR PONDERADO29.412%365.13365.13361.10357.35382.42371.94372.65378.60370.23365.9032FLETE TERRESTRE23.529%415.28415.28415.28415.28425.75425.75419.22419.22419.22418.410.051 ADFr / ADFo0.0510.0510.0510.0510.0550.0540.0540.0530.0530.053

AP13ASFALTO0.11464.912%1,339.171,339.171,339.171,339.17966.59966.591,070.281,131.791,131.791,147.5053PETROLEO DIESSEL35.088%703.35703.35703.35703.35615.93615.27615.27615.27615.27615.270.114 APr / APo0.1140.1140.1140.1140.0860.0860.0930.0970.0970.098

C20CEMENTO ASFALTICO0.280100.000%1,481.231,481.231,481.231,481.231,127.941,127.941,253.511,327.991,327.991,327.990.28 Cr / Co0.2800.2800.2800.2800.2130.2130.2370.2510.2510.251

M49MAQUINARA Y EQUIPO IMPORTADO0.287100.000%247.96247.96246.15242.97265.29257.18256.93258.62253.68250.160.287 Mr / Mo0.2870.2870.2850.2810.3070.2980.2970.2990.2940.290

I39INDICE DE PRECIOS AL CONSUMIDOR0.213100.000%324.99324.99325.71328.67348.03347.88346.69347.34346.62346.320.213 Ir / Io0.2130.2130.2130.2150.2280.2280.2270.2280.2270.227

COEFICIENTE DE REAJUSTE ( K ) :1.0001.0000.9980.9960.9470.9370.9690.9890.9830.980

&"Arial,Cursiva"&7&F/&A

Reajuste

SISTEMA DE VALORIZACIONESDeterminacin del ReajusteOBRA PRINCIPAL

REHABILITACION Y REMODELACION DE LA INFRAESTRUCTURA I.E. GUE SAN CARLOS

Contratista: CONSORCIO PUNO CONSTRUYEExoneracin0054-2010-ED/UE/108Supervision: OFICINA DE INFRAESTRUCTURA EDUCATIVA - OINFEPresupuesto34392796.8Fecha Presup.Apr-10Zona GeograficaPunoF O R M U L A: R = V x ( K - 1 )

DONDE :R : Reajuste del componente en S/. de la Valorizacion MensualV : Monto del componente en S/. de la valorizacion mensual.K : Coeficiente de reajuste obtenido por la aplicacion de la formula polinomica.

ESTRUCTURASVALORIZACIONAVANCE PROGRAMADOAVANCE REAL (sin IGV)FACTOR DE REAJUSTEREINTEGRO PROGRAMADOREINTEGRO REALREINTEGRO A DEDUCCIONREINTEGROMENSUAL(A)ACUMULADO(APA)MENSUAL(B)ACUMULADO(ARA)MENSUALC = A x (K-1)ACUMULADO(SRP)MENSUALD = B x (K-1)ACUMULADO(SRR)RECONOCERADELANTOA.M.A.M.A.M.A.M.TOTALNETONMES(K-1) MesDIRECTO1234AUTORIZADO

1Sep-11402,919.72402,919.72402,919.72402,919.720.0090Sep-113,626.283,626.283,626.283,626.283,626.282,384.630.000.000.000.002,384.631,241.652Oct-11437,078.77839,998.49437,078.77839,998.490.0090Oct-113,933.717,559.993,933.717,559.993,933.712,586.790.000.000.000.002,586.791,346.923Nov-111,266,453.442,106,451.931,266,453.442,106,451.930.0110Nov-1113,930.9921,490.9813,930.9921,490.9813,930.998,012.260.000.000.000.008,012.265,918.734Dec-11758,496.082,864,948.01758,496.082,864,948.020.0130Dec-119,860.4531,351.439,860.4531,351.439,860.455,108.240.000.000.000.005,108.244,752.215Jan-12677,016.233,541,964.24677,016.233,541,964.240.0130Jan-128,801.2140,152.648,801.2140,152.648,801.214,559.500.000.000.000.004,559.504,241.716Feb-12745,870.814,287,835.05745,870.814,287,835.050.0110Feb-128,204.5848,357.228,204.5848,357.228,204.584,718.770.000.000.000.004,718.773,485.817Mar-121,598,221.695,886,056.741,598,221.695,886,056.740.0090Mar-1214,384.0062,741.2214,384.0062,741.2214,384.009,458.860.000.000.000.009,458.864,925.148Apr-121,068,963.146,955,019.881,068,963.146,955,019.880.0060Apr-126,413.7869,155.006,413.7869,155.006,413.785,672.050.000.000.000.005,672.05741.739May-121,044,080.407,999,100.281,044,080.407,999,100.280.0090May-129,396.7278,551.729,396.7278,551.729,396.726,179.250.000.000.000.006,179.253,217.4710Jun-121,276,364.209,275,464.481,276,364.209,275,464.480.0010Jun-121,276.3679,828.081,276.3679,828.081,276.365,470.130.000.000.000.005,470.13(4,193.77 )11Jul-12781,838.2910,057,302.77781,838.2910,057,302.77-0.0070Jul-12(5,472.87 )74,355.21(5,472.87 )74,355.21(5,472.87 )2,074.260.000.000.000.002,074.26(7,547.13 )12Aug-12929,648.7610,986,951.53929,645.8610,986,948.63-0.0060Aug-12(5,577.89 )68,777.32(5,577.88 )68,777.33(5,577.89 )2,655.180.000.000.000.002,655.18(8,233.07 )13Sep-12749,879.2711,736,830.80852,325.1811,839,273.81-0.0060Sep-12(4,499.28 )64,278.04(5,113.95 )63,663.38(5,113.95 )2,434.340.000.000.000.002,434.34(7,548.29 )14Oct-12812,930.1812,549,760.98368,027.5112,207,301.31-0.0030Oct-12(2,438.79 )61,839.25(1,104.08 )62,559.30(2,438.79 )1,276.370.000.000.000.001,276.37(3,715.16 )15Nov-12840,048.8213,389,809.80353,014.0012,560,315.31-0.0050Nov-12(4,200.24 )57,639.01(1,765.07 )60,794.23(4,200.24 )1,080.270.000.000.000.001,080.27(5,280.51 )16Dec-122,445,379.1215,835,188.92195,939.1212,756,254.43-0.0060Dec-12(14,672.27 )42,966.74(1,175.63 )59,618.60(14,672.27 )559.630.000.000.000.00559.63(15,231.90 )17Jan-130.015,835,188.92296,253.5913,052,508.02-0.0020Jan-130.0042,966.74(592.51 )59,026.090.001,087.890.000.000.000.001,087.89(1,087.89 )18Feb-130.015,835,188.92933,348.5313,985,856.550.0020Feb-130.0042,966.741,866.7060,892.790.004,189.040.000.000.000.004,189.04(4,189.04 )19Mar-130.015,835,188.92239,715.2314,225,571.770.0050Mar-130.0042,966.741,198.5862,091.370.001,222.600.000.000.000.001,222.60(1,222.60 )20Apr-130.015,835,188.9288,970.1714,314,541.950.0070Apr-130.0042,966.74622.7962,714.160.00490.070.000.000.000.00490.07(490.07 )21May-130.015,835,188.92131,500.3414,446,042.290.0070Apr-130.0042,966.74920.5063,634.660.00724.330.000.000.000.00724.33(724.33 )

TOTAL REINTEGRO S/.42,352.0771,944.4671,944.46(29,592.39 )REINTEGRO CONSIDERADO ANTERIORMENTE S/.(87,376.04 )REINTEGRO TOTAL A CONSIDERAR S/.42,352.07

ARQUITECTURAVALORIZACIONAVANCE PROGRAMADOAVANCE REAL (sin IGV)FACTOR DE REAJUSTEREINTEGRO PROGRAMADOREINTEGRO REALREINTEGRO A DEDUCCIONREINTEGROMENSUAL(A)ACUMULADO(APA)MENSUAL(B)ACUMULADO(ARA)MENSUALC = A x (K-1)ACUMULADO(SRP)MENSUALD = B x (K-1)ACUMULADO(SRR)RECONOCERADELANTOA.M.A.M.A.M.A.M.TOTALNETONMES(K-1) MesDIRECTO1234AUTORIZADO

1Sep-110.00.00.00.00.003Sep-110.000.000.000.000.000.000.000.000.000.000.000.002Oct-110.00.00.00.00.002Oct-110.000.000.000.000.000.000.000.000.000.000.000.003Nov-110.00.00.00.00.004Nov-110.000.000.000.000.000.000.000.000.000.000.000.004Dec-1165,124.0065,124.0065,124.0065,124.000.004Dec-11260.50260.50260.50260.50260.50237.78335.680.000.000.00573.46(312.96 )5Jan-1217,497.7382,621.7317,497.7382,621.730.004Jan-1269.99330.4969.99330.4969.9963.8998.970.000.000.00162.86(92.87 )6Feb-120.082,621.730.082,621.730.006Feb-120.00330.490.00330.490.000.000.000.000.000.000.000.007Mar-1221,062.83103,684.5621,062.83103,684.560.003Mar-1263.19393.6863.19393.6863.1972.63138.110.000.000.00210.74(147.55 )8Apr-1297,605.80201,290.3697,605.80201,290.360.003Apr-12292.82686.50292.82686.50292.82336.57812.780.000.000.001,149.35(856.53 )9May-12163,812.52365,102.88163,812.52365,102.880.006May-12982.881,669.38982.881,669.38982.88664.551,498.07187.390.000.002,350.01(1,367.13 )10Jun-12241,398.20606,501.08241,398.20606,501.080.001Jun-12241.401,910.78241.401,910.78241.40734.482,084.91253.450.000.003,072.84(2,831.44 )11Jul-12174,822.97781,324.05174,822.97781,324.05-0.008Jul-12(1,398.58 )512.20(1,398.58 )512.20(1,398.58 )212.771,264.60173.860.000.001,651.23(3,049.81 )12Aug-12253,109.931,034,433.98253,109.931,034,433.980.001Aug-12253.11765.31253.11765.31253.11769.831,827.87329.300.009.282,936.28(2,683.17 )13Sep-12410,731.311,445,165.29355,737.661,390,171.64-0.001Sep-12(410.73 )354.58(355.74 )409.57(410.73 )937.712,170.77572.620.0036.553,717.65(4,128.38 )14Oct-121,106,264.352,551,429.64257,689.941,647,861.580.002Oct-122,212.532,567.11515.38924.95515.38836.021,904.42413.550.0021.663,175.65(2,660.27 )15Nov-12742,561.353,293,991.00172,757.521,820,619.100.002Nov-121,485.124,052.23345.521,270.47345.52560.471,181.64251.400.0011.922,005.43(1,659.91 )16Dec-122,866,206.716,160,197.70185,522.652,006,141.75-0.001Dec-12(2,866.21 )1,186.02(185.52 )1,084.95(185.52 )489.031,101.46289.980.0018.291,898.76(2,084.28 )17Jan-132,602,026.068,762,223.76103,990.392,110,132.150.001Jan-132,602.033,788.05103.991,188.94103.99316.29662.89170.060.0012.421,161.66(1,057.67 )18Feb-13505,100.149,267,323.902,328,159.484,438,291.630.005Feb-132,525.506,313.5511,640.8012,829.742,525.508,969.4016,603.453,811.630.00274.7129,659.19(27,133.69 )19Mar-130.09,267,323.901,142,388.315,580,679.940.008Mar-130.006,313.559,139.1121,968.850.005,096.059,329.292,693.370.00278.9317,397.64(17,397.64 )20Apr-130.09,267,323.90312,890.235,893,570.170.009Apr-130.006,313.552,816.0124,784.860.001,459.212,736.91816.330.0087.805,100.25(5,100.25 )21May-130.09,267,323.90446,459.036,340,029.200.009Apr-130.006,313.554,018.1328,802.990.002,082.123,905.261,164.820.00125.297,277.49(7,277.49 )

TOTAL REINTEGRO S/.3,659.4523,838.8083,500.49(79,841.04 )REINTEGRO CONSIDERADO ANTERIORMENTE S/.(184,363.12 )REINTEGRO TOTAL A CONSIDERAR S/.3,659.45

INSTALACIONES SANITARIASVALORIZACIONAVANCE PROGRAMADOAVANCE REAL (sin IGV)FACTOR DE REAJUSTEREINTEGRO PROGRAMADOREINTEGRO REALREINTEGRO A DEDUCCIONREINTEGROMENSUAL(A)ACUMULADO(APA)MENSUAL(B)ACUMULADO(ARA)MENSUALC = A x (K-1)ACUMULADO(SRP)MENSUALD = B x (K-1)ACUMULADO(SRR)RECONOCERADELANTOA.M.A.M.A.M.A.M.TOTALNETONMES(K-1) MesDIRECTO1234AUTORIZADO

1Sep-110.00.00.00.00.018Sep-110.000.000.000.000.000.000.000.000.000.000.000.002Oct-110.00.00.00.00.016Oct-110.000.000.000.000.000.000.000.000.000.000.000.003Nov-110.00.00.00.00.015Nov-110.000.000.000.000.000.000.000.000.000.000.000.004Dec-110.00.00.00.00.014Dec-110.000.000.000.000.000.000.000.000.000.000.000.005Jan-123,287.113,287.113,287.113,287.110.014Jan-1246.0246.0246.0246.0246.0219.360.000.000.000.0019.3626.666Feb-124,922.428,209.534,922.428,209.530.011Feb-1254.15100.1754.15100.1754.1525.990.000.000.000.0025.9928.167Mar-123,612.3111,821.843,612.3111,821.840.010Mar-1236.12136.2936.12136.2936.1218.340.000.000.000.0018.3417.788Apr-126,724.5618,546.406,724.5618,546.400.011Apr-1273.97210.2673.97210.2673.9735.500.000.000.000.0035.5038.479May-1211,948.3830,494.7811,948.3830,494.780.015May-12179.23389.49179.23389.49179.2372.780.000.980.000.0073.76105.4710Jun-1213,475.2343,970.0113,475.2343,970.010.014Jun-12188.65578.14188.65578.14188.6579.350.000.890.340.0080.58108.0711Jul-1214,753.2858,723.2914,753.2858,723.290.008Jul-12118.03696.17118.03696.17118.0368.900.000.400.330.0069.6348.4012Aug-1220,271.3278,994.6120,271.3278,994.610.012Aug-12243.26939.43243.26939.43243.26111.090.000.000.690.00111.78131.4813Sep-1238,357.68117,352.2926,538.77105,533.380.017Sep-12652.081,591.51451.161,390.59451.16172.370.000.001.340.00173.71277.4514Oct-12217,034.55334,386.8432,188.19137,721.570.019Oct-124,123.665,715.17611.582,002.17611.58222.130.000.001.320.00223.45388.1315Nov-12432,028.79766,415.6357,324.89195,046.460.018Nov-127,776.5213,491.691,031.853,034.021,031.85383.970.000.002.220.00386.19645.6616Dec-12629,303.071,395,718.7044,062.39239,108.850.015Dec-129,439.5522,931.24660.943,694.96660.94268.300.000.001.750.00270.05390.8917Jan-130.01,395,718.7060,379.68299,488.530.017Jan-130.0022,931.241,026.454,721.411,026.45392.170.000.002.370.00394.54631.9118Feb-130.01,395,718.70-46,814.14252,674.390.019Feb-130.0022,931.24(889.47 )3,831.94(889.47 )0.0089.823.280.002.3395.43(984.90 )19Mar-130.01,395,718.70180,565.74433,240.130.025Mar-130.0022,931.244,514.148,346.084,514.141,466.00177.176.3215.520.001,665.012,849.1320Apr-130.01,395,718.70475,755.72908,995.850.027Apr-130.0022,931.2412,845.4021,191.4812,845.404,055.75871.1729.6946.470.005,003.087,842.3221May-130.01,395,718.7039,594.62948,590.470.027Apr-130.0022,931.241,069.0522,260.531,069.05337.5472.502.473.870.00416.38652.67

TOTAL REINTEGRO S/.22,260.537,729.549,062.7813,197.75REINTEGRO CONSIDERADO ANTERIORMENTE S/.18,964.02REINTEGRO TOTAL A CONSIDERAR S/.22,260.53

INSTALACIONES ELECTRICASVALORIZACIONAVANCE PROGRAMADOAVANCE REAL (sin IGV)FACTOR DE REAJUSTEREINTEGRO PROGRAMADOREINTEGRO REALREINTEGRO A DEDUCCIONREINTEGROMENSUAL(A)ACUMULADO(APA)MENSUAL(B)ACUMULADO(ARA)MENSUALC = A x (K-1)ACUMULADO(SRP)MENSUALD = B x (K-1)ACUMULADO(SRR)RECONOCERADELANTOA.M.A.M.A.M.A.M.TOTALNETONMES(K-1) MesDIRECTO1234AUTORIZADO

1Sep-110.00.00.00.0-0.013Sep-110.000.000.000.000.000.000.000.000.000.000.000.002Oct-110.00.00.00.0-0.028Oct-110.000.000.000.000.000.000.000.000.000.000.000.003Nov-110.00.00.00.0-0.046Nov-110.000.000.000.000.000.000.000.000.000.000.000.004Dec-110.00.00.00.0-0.041Dec-110.000.000.000.000.000.000.000.000.000.000.000.005Jan-1226,035.3826,035.3826,035.3826,035.38-0.043Jan-12(1,119.52 )(1,119.52 )(1,119.52 )(1,119.52 )(1,119.52 )0.00103.610.000.000.00103.61(1,223.13 )6Feb-1220,591.2146,626.5920,591.2146,626.59-0.032Feb-12(658.92 )(1,778.44 )(658.92 )(1,778.44 )(658.92 )12.8062.220.000.000.0075.02(733.94 )7Mar-1231,535.4178,162.0031,535.4178,162.00-0.027Mar-12(851.46 )(2,629.90 )(851.46 )(2,629.90 )(851.46 )52.2972.430.000.000.00124.72(976.18 )8Apr-1218,382.5096,544.5018,382.5096,544.50-0.036Apr-12(661.77 )(3,291.67 )(661.77 )(3,291.67 )(661.77 )0.0034.270.000.000.0034.27(696.04 )9May-1243,724.71140,269.2143,724.71140,269.21-0.036May-12(1,574.09 )(4,865.76 )(1,574.09 )(4,865.76 )(1,574.09 )0.00260.470.000.000.00260.47(1,834.56 )10Jun-1271,284.29211,553.5071,284.29211,553.50-0.043Jun-12(3,065.22 )(7,930.98 )(3,065.22 )(7,930.98 )(3,065.22 )0.00399.200.009.310.00408.51(3,473.73 )11Jul-1234,460.03246,013.5334,460.03246,013.53-0.052Jul-12(1,791.92 )(9,722.90 )(1,791.92 )(9,722.90 )(1,791.92 )0.00134.270.003.050.00137.32(1,929.24 )12Aug-1262,094.37308,107.9062,094.37308,107.90-0.042Aug-12(2,607.96 )(12,330.86 )(2,607.96 )(12,330.86 )(2,607.96 )0.00210.900.006.700.00217.60(2,825.56 )13Sep-1275,820.17383,928.0764,409.76372,517.66-0.043Sep-12(3,260.27 )(15,591.13 )(2,769.62 )(15,100.48 )(2,769.62 )0.00187.520.008.460.00195.98(2,965.60 )14Oct-12476,393.34860,321.4133,346.21405,863.87-0.046Oct-12(21,914.09 )(37,505.22 )(1,533.93 )(16,634.41 )(1,533.93 )0.000.000.000.000.000.00(1,533.93 )15Nov-12690,902.971,551,224.3831,249.92437,113.79-0.042Nov-12(29,017.92 )(66,523.14 )(1,312.50 )(17,946.91 )(1,312.50 )0.0024.020.001.380.0025.40(1,337.90 )16Dec-121,096,982.882,648,207.265,204.52442,318.31-0.049Dec-12(53,752.16 )(120,275.30 )(255.02 )(18,201.93 )(255.02 )0.000.680.000.210.000.89(255.91 )17Jan-130.02,648,207.26438.96442,757.27-0.050Jan-130.00(120,275.30 )(21.95 )(18,223.88 )0.000.000.000.000.010.000.01(0.01 )18Feb-130.02,648,207.26110,353.38553,110.65-0.042Feb-130.00(120,275.30 )(4,634.84 )(22,858.72 )0.000.008.080.004.830.0012.91(12.91 )19Mar-130.02,648,207.26124,984.56678,095.21-0.041Mar-130.00(120,275.30 )(5,124.37 )(27,983.09 )0.000.00161.290.0017.460.00178.75(178.75 )20Apr-130.02,648,207.26109,224.26787,319.48-0.045Apr-130.00(120,275.30 )(4,915.09 )(32,898.18 )0.000.00176.790.0018.110.00194.90(194.90 )21May-130.02,648,207.26366,001.101,153,320.58-0.045Apr-130.00(120,275.30 )(16,470.05 )(49,368.23 )0.000.00592.390.0060.690.00653.08(653.08 )

TOTAL REINTEGRO S/.(18,201.93 )65.092,623.44(20,825.37 )REINTEGRO CONSIDERADO ANTERIORMENTE S/.(93,101.96 )REINTEGRO TOTAL A CONSIDERAR S/.(18,201.93 )

CONSOLIDADOVALORIZACIONAVANCE PROGRAMADOAVANCE REAL (sin IGV)FACTOR DE REAJUSTEREINTEGRO PROGRAMADOREINTEGRO REALREINTEGRO A DEDUCCIONREINTEGROMENSUAL(A)ACUMULADO(APA)MENSUAL(B)ACUMULADO(ARA)MENSUALC = A x (K-1)ACUMULADO(SRP)MENSUALD = B x (K-1)ACUMULADO(SRR)RECONOCERADELANTOA.M.A.M.A.M.A.M.TOTALNETONMES(K-1) MesDIRECTO1234AUTORIZADO

1Sep-11402,919.72402,919.72402,919.72402,919.723,626.283,626.283,626.283,626.283,626.282,384.630.000.000.000.002,384.631,241.652Oct-11437,078.77839,998.49437,078.77839,998.493,933.717,559.993,933.717,559.993,933.712,586.790.000.000.000.002,586.791,346.923Nov-111,266,453.442,106,451.931,266,453.442,106,451.9313,930.9921,490.9813,930.9921,490.9813,930.998,012.260.000.000.000.008,012.265,918.734Dec-11823,620.082,930,072.01823,620.082,930,072.0210,120.9531,611.9310,120.9531,611.9310,120.955,346.01335.680.000.000.005,681.694,439.265Jan-12723,836.453,653,908.46723,836.453,653,908.467,797.7039,409.637,797.7039,409.637,797.704,599.57202.580.000.000.004,802.152,995.556Feb-12771,384.444,425,292.90771,384.444,425,292.907,599.8147,009.447,599.8147,009.447,599.814,757.5662.220.000.000.004,819.782,780.037Mar-121,654,432.246,079,725.141,654,432.246,079,725.1413,631.8560,641.2913,631.8560,641.2913,631.859,602.12210.540.000.000.009,812.663,819.198Apr-121,191,676.007,271,401.141,191,676.007,271,401.146,118.8066,760.096,118.8066,760.096,118.806,040.31847.050.000.000.006,887.36(768.56 )9May-121,263,566.018,534,967.151,263,566.018,534,967.158,984.7475,744.838,984.7475,744.838,984.746,907.531,758.54188.370.000.008,854.44130.3010Jun-121,602,521.9210,137,489.071,602,521.9210,137,489.07-1,358.8174,386.02-1,358.8174,386.02(1,358.81 )6,165.762,484.11254.349.650.008,913.86(10,272.67 )11Jul-121,005,874.5711,143,363.641,005,874.5711,143,363.64-8,545.3465,840.68-8,545.3465,840.68(8,545.34 )2,234.521,398.87174.263.380.003,811.03(12,356.37 )12Aug-121,265,124.3812,408,488.021,265,121.4812,408,485.12-7,689.4858,151.20-7,689.4758,151.21(7,689.47 )3,446.052,038.77329.307.399.285,830.79(13,520.26 )13Sep-121,274,788.4313,683,276.461,299,011.3613,707,496.49-7,518.2050,633.00-7,788.1550,363.06(7,788.15 )3,437.672,358.29572.629.8036.556,414.93(14,203.08 )14Oct-122,612,622.4216,295,898.87691,251.8514,398,748.34-18,016.6932,616.31-1,511.0548,852.01(1,511.05 )2,258.531,904.42413.551.3221.664,599.48(6,110.53 )15Nov-122,705,541.9319,001,440.81614,346.3215,013,094.66-23,956.528,659.79-1,700.2047,151.81(1,700.20 )1,979.391,205.66251.403.6011.923,451.97(5,152.17 )16Dec-127,037,871.7726,039,312.58430,728.6815,443,823.35-61,851.09(53,191.30 )-955.2346,196.58(955.23 )1,301.871,102.14289.981.9618.292,714.24(3,669.47 )17Jan-132,602,026.0628,641,338.63461,062.6215,904,885.972,602.03(50,589.27 )515.9846,712.56515.980.00662.89170.062.3812.42847.75(331.77 )18Feb-13505,100.1429,146,438.773,325,047.2519,229,933.222,525.50(48,063.77 )7,983.1954,695.757,983.190.0016,701.353,814.914.83277.0420,798.13(12,814.94 )19Mar-130.029,146,438.771,687,653.8420,917,587.060.00(48,063.77 )9,727.4664,423.219,727.4693,160.169,667.752,699.6932.98278.93105,839.51(96,112.05 )

TOTAL REINTEGRO S/.64,423.21164,220.72217,063.44(152,640.23 )REINTEGRO CONSIDERADO ANTERIORMENTE S/.(345,877.10 )REINTEGRO TOTAL A CONSIDERAR S/.64,423.21193,236.87

Reg. Reajuste

SISTEMA DE VALORIZACIONESDeterminacin de la Regularizacin del ReajusteOBRA PRINCIPAL

REHABILITACION Y REMODELACION DE LA INFRAESTRUCTURA I.E. GUE SAN CARLOS

Contratista: CONSORCIO PUNO CONSTRUYEExoneracin0054-2010-ED/UE/108Inspector: OFICINA DE INFRAESTRUCTURA EDUCATIVA - OINFEPresupuesto34392796.8Fecha Presup.Apr-10Zona GeograficaPuno

VALORIZACINMONTO S/.K CalculadoAnteriorREAJUSTE CONSIDERADOK MES DE "PAGO"DefinitivoREAJUSTE REALREG.DEL REAJUSTE S/.

Sep-11402,919.72Oct-111.0093,626.28Sep-111.0093,626.280.0Oct-11437,078.77Nov-111.0114,807.87Oct-111.0093,933.71-874.16Nov-111,266,453.44Dec-111.01316,463.89Nov-111.01113,930.99-2,532.90Dec-11758,496.08Jan-121.0139,860.45Dec-111.0139,860.450.0Jan-12677,016.23Feb-121.0117,447.18Jan-121.0138,801.211,354.03Feb-12745,870.81Mar-121.0096,712.84Feb-121.0118,204.581,491.74Mar-121,598,221.69Apr-121.0069,589.33Mar-121.00914,384.004,794.67Apr-121,068,963.14May-121.0099,620.67Apr-121.0066,413.78-3,206.89May-121,044,080.40Jun-121.0011,044.08May-121.0099,396.728,352.64Jun-121,276,364.20Jun-121.0011,276.36Jun-121.0011,276.360.0Jul-12781,838.29Jun-121.001781.84Jul-120.993(5,472.87 )-6,254.71

71,230.7974,355.213,124.42

Amortizacin Adelanto Directo

SISTEMA DE VALORIZACIONESAMORTIZACION DEL ADELANTO DIRECTO

REHABILITACION Y REMODELACION DE LA INFRAESTRUCTURA I.E. GUE SAN CARLOSContratista: CONSORCIO PUNO CONSTRUYEExoneracin0054-2010-ED/UE/108Supervision: OFICINA DE INFRAESTRUCTURA EDUCATIVA - OINFEPresupuesto34392796.8Inc. I.G.V.Fecha Presup.: ABRIL 2011Fecha Adelanto: DICIEMBRE 2010Datos GeneralesMonto de Contrato :29146437.97Monto Adelanto5827195.29

Formula : A1 A2 Am = V x ( ------- ) + V x ( ------- ) C1 C2 Donde :Am :Amortizacion del adelanto en efectivo parcial concedido al contratista (S/.).V :Monto de la valorizacion mensual (S/.).Ai :Montos parciales del adelanto directo concedido al Contratista (S/.).Ci :Saldo del contrato por valorizar a la fecha de pago de cada adelanto parcial (S/.).

AMORTIZACION DEL ADELANTO DIRECTOESTRUCTURASVALORIZACIONMONTOAMORTIZACIONSALDO% PRESUPUESTOVALORIZADO(A1*V) / C1TOTALPORAMORTIZADONMES - A0VAMORTIZARx VALORIZACIONVal. N 1Sep-2011Estructuras402,919.7280,583.9480,583.9420.00%Val. N 2Oct-2011Estructuras437,078.7787,415.7587,415.7520.00%Val. N 3Nov-2011Estructuras1,266,453.44253,290.69253,290.6920.00%Val. N 4Dec-2011Estructuras758,496.08151,699.22151,699.2220.00%Val. N 5Jan-2012Estructuras677,016.23135,403.25135,403.2520.00%Val. N 6Feb-2012Estructuras745,870.81149,174.16149,174.1620.00%Val. N 7Mar-2012Estructuras1,598,221.69319,644.34319,644.3420.00%Val. N 8Apr-2012Estructuras1,068,963.14213,792.63213,792.6320.00%Val. N 9May-2012Estructuras1,044,080.40208,816.08208,816.0820.00%Val. N 10Jun-2012Estructuras1,276,364.20255,272.84255,272.8420.00%Val. N 11Jul-2012Estructuras781,838.29156,367.66156,367.6620.00%Val. N 12Aug-2012Estructuras929,645.86185,862.44185,862.4419.99%Val. N 13Sep-2012Estructuras852,325.18170,403.85170,403.8519.99%Val. N 14Oct-2012Estructuras368,027.5173,579.0873,579.0819.99%Val. N 15Nov-2012Estructuras353,014.0070,577.4670,577.4619.99%Val. N 16Dec-2012Estructuras195,939.1239,173.7639,173.7619.99%Val. N 17Jan-2013Estructuras296,253.5959,229.4559,229.4519.99%Val. N 18Feb-2013Estructuras933,348.53186,602.70186,602.7019.99%Val. N 19Mar-2013Estructuras239,715.2347,925.8447,925.8419.99%Val. N 20Apr-2013Estructuras88,970.1717,787.6517,787.6519.99%Val. N 21May-2013Estructuras131,500.3426,290.6326,290.6319.99%

TOTALES S/. :14,446,042.292,888,893.42ARQUITECTURAVALORIZACIONMONTOAMORTIZACIONSALDO% PRESUPUESTOVALORIZADO(A1*V) / C1TOTALPORAMORTIZADONMES - A0VAMORTIZARx VALORIZACIONVal. N 1Sep-2011Arquitectura0.00.00.0Val. N 2Oct-2011Arquitectura0.00.00.0Val. N 3Nov-2011Arquitectura0.00.00.0Val. N 4Dec-2011Arquitectura65,124.0013,024.8013,024.8020.00%Val. N 5Jan-2012Arquitectura17,497.733,499.553,499.5520.00%Val. N 6Feb-2012Arquitectura0.00.00.0Val. N 7Mar-2012Arquitectura21,062.834,212.574,212.5720.00%Val. N 8Apr-2012Arquitectura97,605.8019,521.1619,521.1620.00%Val. N 9May-2012Arquitectura163,812.5232,762.5032,762.5020.00%Val. N 10Jun-2012Arquitectura241,398.2048,279.6448,279.6420.00%Val. N 11Jul-2012Arquitectura174,822.9734,964.5934,964.5920.00%Val. N 12Aug-2012Arquitectura253,109.9350,603.8250,603.8219.99%Val. N 13Sep-2012Arquitectura355,737.6671,122.0071,122.0019.99%Val. N 14Oct-2012Arquitectura257,689.9451,519.4951,519.4919.99%Val. N 15Nov-2012Arquitectura172,757.5234,539.1034,539.1019.99%Val. N 16Dec-2012Arquitectura185,522.6537,091.2137,091.2119.99%Val. N 17Jan-2013Arquitectura103,990.3920,790.6120,790.6119.99%Val. N 18Feb-2013Arquitectura2,328,159.48465,464.77465,464.7719.99%Val. N 19Mar-2013Arquitectura1,142,388.31228,395.65228,395.6519.99%Val. N 20Apr-2013Arquitectura312,890.2362,555.5962,555.5919.99%Val. N 21May-2013Arquitectura446,459.0389,259.7689,259.7619.99%

TOTALES S/. :6,340,029.201,267,606.81INSTALACIONES SANITARIASVALORIZACIONMONTOAMORTIZACIONSALDO% PRESUPUESTOVALORIZADO(A1*V) / C1TOTALPORAMORTIZADONMES - A0VAMORTIZARx VALORIZACIONVal. N 1Sep-2011Inst. Sanitarias0.00.00.0Val. N 2Oct-2011Inst. Sanitarias0.00.00.0Val. N 3Nov-2011Inst. Sanitarias0.00.00.0Val. N 4Dec-2011Inst. Sanitarias0.00.00.0Val. N 5Jan-2012Inst. Sanitarias3,287.11657.42657.4220.00%Val. N 6Feb-2012Inst. Sanitarias4,922.42984.48984.4820.00%Val. N 7Mar-2012Inst. Sanitarias3,612.31722.46722.4620.00%Val. N 8Apr-2012Inst. Sanitarias6,724.561,344.911,344.9120.00%Val. N 9May-2012Inst. Sanitarias11,948.382,389.682,389.6820.00%Val. N 10Jun-2012Inst. Sanitarias13,475.232,695.052,695.0520.00%Val. N 11Jul-2012Inst. Sanitarias14,753.282,950.662,950.6620.00%Val. N 12Aug-2012Inst. Sanitarias20,271.324,052.814,052.8119.99%Val. N 13Sep-2012Inst. Sanitarias26,538.775,305.855,305.8519.99%Val. N 14Oct-2012Inst. Sanitarias32,188.196,435.336,435.3319.99%Val. N 15Nov-2012Inst. Sanitarias57,324.8911,460.8611,460.8619.99%Val. N 16Dec-2012Inst. Sanitarias44,062.398,809.328,809.3219.99%Val. N 17Jan-2013Inst. Sanitarias60,379.6812,071.6012,071.6019.99%Val. N 18Feb-2013Inst. Sanitarias-46,814.14-9,359.47-9,359.4719.99%Val. N 19Mar-2013Inst. Sanitarias180,565.7436,100.1936,100.1919.99%Val. N 20Apr-2013Inst. Sanitarias475,755.7295,116.9995,116.9919.99%Val. N 21May-2013Inst. Sanitarias39,594.627,916.087,916.0819.99%

TOTALES S/. :948,590.47189,654.22INSTALACIONES ELECTRICASVALORIZACIONMONTOAMORTIZACIONSALDO% PRESUPUESTOVALORIZADO(A1*V) / C1TOTALPORAMORTIZADONMES - A0VAMORTIZARx VALORIZACIONVal. N 1Sep-2011Inst. Elctricas0.00.00.0Val. N 2Oct-2011Inst. Elctricas0.00.00.0Val. N 3Nov-2011Inst. Elctricas0.00.00.0Val. N 4Dec-2011Inst. Elctricas0.00.00.0Val. N 5Jan-2012Inst. Elctricas26,035.385,207.075,207.0720.00%Val. N 6Feb-2012Inst. Elctricas20,591.214,118.254,118.2520.00%Val. N 7Mar-2012Inst. Elctricas31,535.416,307.086,307.0820.00%Val. N 8Apr-2012Inst. Elctricas18,382.503,676.503,676.5020.00%Val. N 9May-2012Inst. Elctricas43,724.718,744.948,744.9420.00%Val. N 10Jun-2012Inst. Elctricas71,284.2914,256.8514,256.8520.00%Val. N 11Jul-2012Inst. Elctricas34,460.036,892.006,892.0020.00%Val. N 12Aug-2012Inst. Elctricas62,094.3712,414.4212,414.4219.99%Val. N 13Sep-2012Inst. Elctricas64,409.7612,877.3312,877.3319.99%Val. N 14Oct-2012Inst. Elctricas33,346.216,666.856,666.8519.99%Val. N 15Nov-2012Inst. Elctricas31,249.926,247.746,247.7419.99%Val. N 16Dec-2012Inst. Elctricas5,204.521,040.531,040.5319.99%Val. N 17Jan-2013Inst. Elctricas438.9687.7687.7619.99%Val. N 18Feb-2013Inst. Elctricas110,353.3822,062.7522,062.7519.99%Val. N 19Mar-2013Inst. Elctricas124,984.5624,987.9424,987.9419.99%Val. N 20Apr-2013Inst. Elctricas109,224.2621,837.0121,837.0119.99%Val. N 21May-2013Inst. Elctricas366,001.1073,173.9573,173.9519.99%

TOTALES S/. :1,153,320.58230,598.97CONSOLIDADOVALORIZACIONMONTOAMORTIZACIONSALDO% PRESUPUESTOVALORIZADO(A1*V) / C1TOTALPORAMORTIZADONMES - A0VAMORTIZARx VALORIZACIONVal. N 1Sep-2011Contractual402,919.7280,583.9480,583.945,746,611.3520.00%Val. N 2Oct-2011Contractual437,078.7787,415.7587,415.755,659,195.6020.00%Val. N 3Nov-2011Contractual1,266,453.44253,290.69253,290.695,405,904.9120.00%Val. N 4Dec-2011Contractual823,620.08164,724.02164,724.025,241,180.8920.00%Val. N 5Jan-2012Contractual723,836.45144,767.29144,767.295,096,413.6020.00%Val. N 6Feb-2012Contractual771,384.44154,276.89154,276.894,942,136.7120.00%Val. N 7Mar-2012Contractual1,654,432.24330,886.45330,886.454,611,250.2620.00%Val. N 8Apr-2012Contractual1,191,676.00238,335.20238,335.204,372,915.0620.00%Val. N 9May-2012Contractual1,263,566.01252,713.20252,713.204,120,201.8620.00%Val. N 10Jun-2012Contractual1,602,521.92320,504.38320,504.383,799,697.4820.00%Val. N 11Jul-2012Contractual1,005,874.57201,174.91201,174.913,598,522.5720.00%Val. N 12Aug-2012Contractual1,265,121.48252,933.49252,933.493,345,589.0819.99%Val. N 13Sep-2012Contractual1,299,011.36259,709.03259,709.033,085,880.0519.99%Val. N 14Oct-2012Contractual691,251.85138,200.75138,200.752,947,679.3019.99%Val. N 15Nov-2012Contractual614,346.32122,825.16122,825.162,824,854.1419.99%Val. N 16Dec-2012Contractual430,728.6886,114.8286,114.822,738,739.3219.99%Val. N 17Jan-2013Contractual461,062.6292,179.4292,179.422,646,559.9019.99%Val. N 18Feb-2013Contractual3,325,047.25664,770.75664,770.751,981,789.1519.99%Val. N 19Mar-2013Contractual1,687,653.84337,409.62337,409.621,644,379.5319.99%Val. N 20Apr-2013Contractual986,840.39197,297.24197,297.241,447,082.2919.99%Val. N 21May-2013Contractual983,555.10196,640.42196,640.421,250,441.8719.99%

TOTALES S/. :22,887,982.544,576,753.4276,507,024.92

&P de &N

Ded. Reajuste Adelanto Directo

SISTEMA DE VALORIZACIONESDEDUCCION DEL REAJUSTE QUE NO CORRESPONDE POR EL ADELANTO DIRECTO

REHABILITACION Y REMODELACION DE LA INFRAESTRUCTURA I.E. GUE SAN CARLOSContratista: CONSORCIO PUNO CONSTRUYEExoneracin0054-2010-ED/UE/108Supervision: OFICINA DE INFRAESTRUCTURA EDUCATIVA - OINFEPresupuesto34392796.8Inc. I.G.V.Fecha Presup.: DICIEMBRE 2009Fecha Adelanto: OCTUBRE 2010Datos GeneralesMonto de Contrato :29146437.97Monto Adelanto5827195.29

FORMULA GENERAL

De = ( A x V / C ) x ( Kr / Ka - 1 )donde :De =Deduccion del reajuste que no corresponde A =Monto del Adelanto sujeto a deduccion (sin IGV)datos :S/.C =Saldo del contrato por valorizar a la fecha de pago del adelanto (sin IGV)A =5,827,195.29Kr =Factor de Reajuste del mes respectivoC =29,146,437.97Ka =Factor de Reajuste al mes que se otorg el adelanto

ESTRUCTURASKa Dic. 20100.980

VALORIZACIONCOEFICIENTEDEDUCCION PARADEDUCCION TOTALMONTO (SIN IGV)DE REAJUSTEANPERIODOS/.KrS/.

0.001Sep-11402,919.721.009Sep-112,384.632,384.6302Oct-11437,078.771.009Oct-112,586.792,586.7903Nov-111,266,453.441.011Nov-118,012.268,012.2604Dec-11758,496.081.013Dec-115,108.245,108.2405Jan-12677,016.231.013Jan-124,559.504,559.5006Feb-12745,870.811.011Feb-124,718.774,718.7707Mar-121,598,221.691.009Mar-129,458.869,458.8608Apr-121,068,963.141.006Apr-125,672.055,672.0509May-121,044,080.401.009May-126,179.256,179.2510Jun-121,276,364.201.001Jun-125,470.135,470.1311Jul-12781,838.290.993Jul-122,074.262,074.2612Aug-12929,645.860.994Aug-122,655.182,655.1813Sep-12852,325.180.994Sep-122,434.342,434.3414Oct-12368,027.510.997Oct-121,276.371,276.3715Nov-12353,014.000.995Nov-121,080.271,080.2716Dec-12195,939.120.994Dec-12559.63559.6317Jan-13296,253.590.998Jan-131,087.891,087.8918Feb-13933,348.531.002Feb-134,189.044,189.0419Mar-13239,715.231.005Mar-131,222.601,222.6020Apr-1388,970.171.007Apr-13490.07490.0721May-13131,500.341.007Apr-13724.33724.33

TOTALES14,446,042.2971,944.46MONTO DEDUCIDO ANTERIORMENTE0.0MONTO A DEDUCIR EN LA PRESENTE VALORIZACIONS/.71,944.46

ARQUITECTURAKa Dic. 20100.986

VALORIZACIONCOEFICIENTEDEDUCCION PARADEDUCCION TOTALMONTO (SIN IGV)DE REAJUSTEANPERIODOS/.KrS/.

0.001Sep-110.01.003Sep-110.00.002Oct-110.01.002Oct-110.00.003Nov-110.01.004Nov-110.00.004Dec-1165,124.001.004Dec-11237.78237.7805Jan-1217,497.731.004Jan-1263.8963.8906Feb-120.01.006Feb-120.00.007Mar-1221,062.831.003Mar-1272.6372.6308Apr-1297,605.801.003Apr-12336.57336.5709May-12163,812.521.006May-12664.55664.5510Jun-12241,398.201.001Jun-12734.48734.4811Jul-12174,822.970.992Jul-12212.77212.7712Aug-12253,109.931.001Aug-12769.83769.8313Sep-12355,737.660.999Sep-12937.71937.7114Oct-12257,689.941.002Oct-12836.02836.0215Nov-12172,757.521.002Nov-12560.47560.4716Dec-12185,522.650.999Dec-12489.03489.0317Jan-13103,990.391.001Jan-13316.29316.2918Feb-132,328,159.481.005Feb-138,969.408,969.4019Mar-131,142,388.311.008Mar-135,096.055,096.0520Apr-13312,890.231.009Mar-131,459.211,459.2121May-13446,459.031.009Apr-132,082.122,082.12

TOTALES6,340,029.2023,838.80MONTO DEDUCIDO ANTERIORMENTE0.0MONTO A DEDUCIR EN LA PRESENTE VALORIZACIONS/.23,838.80

INSTALACIONES SANITARIASKa Dic. 20100.985

VALORIZACIONCOEFICIENTEDEDUCCION PARADEDUCCION TOTALMONTO (SIN IGV)DE REAJUSTEANPERIODOS/.KrS/.

0.001Sep-110.01.018Sep-110.00.002Oct-110.01.016Oct-110.00.003Nov-110.01.015Nov-110.00.004Dec-110.01.014Dec-110.00.005Jan-123,287.111.014Jan-1219.3619.3606Feb-124,922.421.011Feb-1225.9925.9907Mar-123,612.311.010Mar-1218.3418.3408Apr-126,724.561.011Apr-1235.5035.5009May-1211,948.381.015May-1272.7872.7810Jun-1213,475.231.014Jun-1279.3579.3511Jul-1214,753.281.008Jul-1268.9068.9012Aug-1220,271.321.012Aug-12111.09111.0913Sep-1226,538.771.017Sep-12172.37172.3714Oct-1232,188.191.019Oct-12222.13222.1315Nov-1257,324.891.018Nov-12383.97383.97 16Dec-1244,062.391.015Dec-12268.30268.3017Jan-1360,379.681.017Jan-13392.17392.1718Feb-13-46,814.141.019Feb-13-323.07-323.0719Mar-13180,565.741.025Mar-131,466.001,466.0020Apr-13475,755.721.027Mar-134,055.754,055.7521May-1339,594.621.027Apr-13337.54337.54

TOTALES948,590.477,406.47MONTO DEDUCIDO ANTERIORMENTE0.0MONTO A DEDUCIR EN LA PRESENTE VALORIZACIONS/.7,406.47

INSTALACIONES ELECTRICASKa Dic. 20100.965

VALORIZACIONCOEFICIENTEDEDUCCION PARADEDUCCION TOTALMONTO (SIN IGV)DE REAJUSTEANPERIODOS/.KrS/.

0.001Sep-110.00.987Sep-110.00.002Oct-110.00.972Oct-110.00.003Nov-110.00.954Nov-110.00.004Dec-110.00.959Dec-110.00.005Jan-1226,035.380.957Jan-12-43.17-43.1706Feb-1220,591.210.968Feb-1212.8012.8007Mar-1231,535.410.973Mar-1252.2952.2908Apr-1218,382.500.964Apr-12-3.81-3.8109May-1243,724.710.964May-12-9.06-9.0610Jun-1271,284.290.957Jun-12-118.19-118.1911Jul-1234,460.030.948Jul-12-121.41-121.4112Aug-1262,094.370.958Aug-12-90.05-90.0513Sep-1264,409.760.957Sep-12-106.76-106.7614Oct-1233,346.210.954Oct-12-76.00-76.0015Nov-1231,249.920.958Nov-12-45.32-45.3216Dec-125,204.520.951Dec-12-15.10-15.1017Jan-13438.960.950Jan-13-1.36-1.3618Feb-13110,353.380.958Feb-13-160.04-160.0419Mar-13124,984.560.959Mar-13-155.37-155.3720Apr-13109,224.260.955Mar-13-226.29-226.2921May-13366,001.100.955Mar-13-758.28-758.28

TOTALES1,153,320.58-1,865.11MONTO DEDUCIDO ANTERIORMENTE0.0MONTO A DEDUCIR EN LA PRESENTE VALORIZACIONS/.-1,865.11

CONSOLIDADOKa Dic. 20100.965

VALORIZACIONCOEFICIENTEDEDUCCION PARADEDUCCION TOTALMONTO (SIN IGV)DE REAJUSTEANPERIODOS/.KrS/.

0.001Sep-11402,919.72Sep-112,384.632,384.6302Oct-11437,078.77Oct-112,586.792,586.7903Nov-111,266,453.44Nov-118,012.268,012.2604Dec-11823,620.08Dec-115,346.015,346.0105Jan-12723,836.45Jan-124,599.574,599.5706Feb-12771,384.44Feb-124,757.564,757.5607Mar-121,654,432.24Mar-129,602.129,602.1208Apr-121,191,676.00Apr-126,040.316,040.3109May-121,263,566.01May-126,907.536,907.5310Jun-121,602,521.92Jun-126,165.766,165.7611Jul-121,005,874.57Jul-122,234.522,234.5212Aug-121,265,121.48Aug-123,446.053,446.0513Sep-121,299,011.36Sep-123,437.673,437.6714Oct-12691,251.85Oct-122,258.532,258.5315Nov-12614,346.32Nov-121,979.391,979.3916Dec-12430,728.68Dec-121,301.871,301.8717Jan-13461,062.62Jan-131,794.981,794.9818Feb-133,325,047.25Feb-1312,675.3312,675.3319Mar-131,687,653.84Mar-137,629.287,629.2820Apr-13

TOTALES20,917,587.0693,160.16MONTO DEDUCIDO ANTERIORMENTE0.0MONTO A DEDUCIR EN LA PRESENTE VALORIZACIONS/.93,160.16

&"Arial,Normal"&8

Amortizacin Adelanto Materiale

SISTEMA DE VALORIZACIONESDETALLE DE LA AMORTIZACION DEL ADELANTO ESPECIFICO PARA MATERIALESERROR:#REF!

REHABILITACION Y MEJORAMIENTO DE LA CARRETERA PATAHUASI - YAURI - SICUANI; TRAMO: EL DESCANSO - LANGUIContratista: CONSORCIO VIAL EL DESCANSO - LANGUIContrato0054-2010-ED/UE/108Supervisor: CONSORCIO SICUANI IIPresupuesto70599929.37Inc. I.G.V.Fecha Presup.: DICIEMBRE 2009Fecha Adelanto: ABRIL 2011

VALORIZACIONADELANTO OTORGADOMATERIAL UTILIZADOAdelantoImaBaseImoMONTO A AMORTIZARMu x Ima / Imo(S/.)MONTO AMORTIZADO

(S/.)MONTO AMORTIZADO ACUMULADO(S/.)SALDO POR AMORTIZAR(S/.)NPERIODONMONTO (S/.)FECHACANTP.U. (S/.)MONTO UTILIZADO (S/.)(Set-06)Jun-2011Jul-2011Aug-2011Sep-2011Oct-2011Nov-2011Dec-11Jan-12Feb-12Mar-12totalADELANTO PARA MATERIALES N 01CEMENTO PORTLAND TIPO I BLS 42.5KGIUP = 2101896,675.92Apr-110.0896,675.929Jun-1101ERROR:#REF!14.05ERROR:#REF!410.96410.96ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!610.CConcreto fc=280 kg/cm2ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!10Jul-1101ERROR:#REF!14.05ERROR:#REF!410.96410.96ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!610.DConcreto fc =210 kg/cm2ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!11Aug-1101ERROR:#REF!14.05ERROR:#REF!410.96410.96ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!610.FConcreto Ciclpeo fc =210 kg/cm2 + 30% pgERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!12Sep-1101ERROR:#REF!14.05ERROR:#REF!410.96410.96ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!610.GConcreto Ciclpeo fc =175 kg/cm2 + 30% pmERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!13Oct-1101ERROR:#REF!14.05ERROR:#REF!410.96410.96ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!610.IConcreto fc =100 kg/cm2ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!14Nov-1101ERROR:#REF!14.05ERROR:#REF!410.96410.96ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!635.ACunetas Triangulares Revestidas en ConcretoERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!15Dec-1101ERROR:#REF!14.05ERROR:#REF!410.96410.96ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!635.BZanja de CoronacinERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!16Jan-1201ERROR:#REF!14.05ERROR:#REF!410.96410.96ERROR:#REF!126,488.56ERROR:#REF!ERROR:#REF!635.CZanja de Drenaje0.0635.GEmboquillado de Piedra E=0.15 mERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!TOTALERROR:#REF!635.HEmboquillado de Piedra E=0.30 mERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!CEMENTO ASFALTO PENETRACION 120-150IUP = 20635.IEmboquillado de Piedra E=0.80 mERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!012,903,324.08Apr-110.02,903,324.08ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!14Nov-1101ERROR:#REF!7.11ERROR:#REF!1,974.961,508.89ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!0.0015Dec-1101ERROR:#REF!7.11ERROR:#REF!1,974.961,508.89ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!0.0016Jan-1201ERROR:#REF!7.11ERROR:#REF!1,974.961,508.89ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!

TOTALERROR:#REF!

TOTAL ADELANTO MATERIALES RECIBIDO3,800,000.00TOTAL AMORTIZACION ACUMULADAERROR:#REF!ERROR:#REF!

AMORTIZACION EFECTUADA EN LAS VALORIZACIONES MENSUALES:

VALORIZACIONAMORTIZACION DE MATERIALES N 01TOTAL AMORTIZACION DE MATERIALESNMES01Oct-100.00.002Nov-100.00.003Dec-100.00.0ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!04Jan-110.00.005Feb-110.00.006Mar-110.00.007Apr-110.00.008May-110.00.009Jun-11ERROR:#REF!ERROR:#REF!10Jul-11ERROR:#REF!ERROR:#REF!11Aug-11ERROR:#REF!ERROR:#REF!12Sep-11ERROR:#REF!ERROR:#REF!13Oct-11ERROR:#REF!ERROR:#REF!14Nov-11ERROR:#REF!ERROR:#REF!15Dec-11ERROR:#REF!ERROR:#REF!16Jan-12ERROR:#REF!ERROR:#REF!

TOTAL AMORTIZADO ACUMULADOERROR:#REF!TOTAL AMORTIZADO ANTERIOR3,800,000.00TOTAL AMORTIZADO EN EL MESERROR:#REF!

&"Arial Narrow,Normal"&8C:\ &F / &A&"Arial Narrow,Normal"&8Pgina &P de &N

Ded. Reajuste Adelanto Mat

SISTEMA DE VALORIZACIONESDEDUCCIN DEL REAJUSTE QUE NO CORRESPONDE DEL ADELANTO PARA MATERIALESERROR:#REF!

REHABILITACION Y MEJORAMIENTO DE LA CARRETERA PATAHUASI - YAURI - SICUANI; TRAMO: EL DESCANSO - LANGUIContratista: CONSORCIO VIAL EL DESCANSO - LANGUIContrato: DICIEMBRE 2009Supervisor: CONSORCIO SICUANI IIPresupuesto70599929.37Inc. I.G.V.Fecha Presup.: DICIEMBRE 2009Fecha Adelanto: ABRIL 2011

FORMULA:DEDUCCION : Monto del adelanto utilizado en la presenta valorizacin x (Ir-Ia)/IoADELANTO PARA MATERIALES N 01

MATERIAL :CEMENTO PORTLAND TIPO I BLS 42.5KGINDICE : 21ADELANTO MONTO MONTO DEFLATADONF. PAGO OTORGADOADELANTOACUMULADOFORMULA POLINOMICA UNICA1Apr-11S/.896,675.92896,675.92896,675.92

MONTODEL MONOMIOADEL.ADEL.I N D I C E SMONTOADELANTOSALDOVALORIZACIONBRUTOUTILIZ.AMORTIZADOMAXIMOUTILIZADOPORDEDUCC.VALORIZ.INC.%(1)x(2)x(2)'=DEFLATADOIoIaIrUTILIZABLEAMORTIZAR"D"No.MES(1)(2)(2)'(3)(4)(5)(6)ADEL.x(4)/(5)(8)(8)x(6-5)/(4)Feb-09Mar-09Apr-09May-09Jun-0909Jun-115,313,709.080.065100.00%345,391.09ERROR:#REF!410.96410.96410.96896,675.92ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!10Jul-113,860,961.990.065100.00%250,962.53ERROR:#REF!410.96410.96410.96896,675.92ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!11Aug-111,824,183.880.065100.00%118,571.95ERROR:#REF!410.96410.96410.96896,675.92ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!12Sep-112,325,451.050.065100.00%151,154.32ERROR:#REF!410.96410.96410.96896,675.92ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!13Oct-112,468,235.900.065100.00%160,435.33ERROR:#REF!410.96410.96410.96896,675.92ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!14Nov-114,829,041.590.065100.00%313,887.70ERROR:#REF!410.96410.96410.96896,675.92ERROR:#REF!ERROR:#REF!ERROR:#REF!15Dec-11ERROR:#REF!0.065100.00%ERROR:#REF!ERROR:#REF!410.96410.96410.96896,675.92ERROR:#REF!ERROR:#REF!ERROR:#REF!16Jan-12ERROR:#REF!0.065100.00%ERROR:#REF!126,488.56410.96410.96410.96896,675.92126,488.56ERROR:#REF!

ERROR:#REF!ERROR:#REF!DEDUC. TOTALERROR:#REF!

MATERIAL :CEMENTO ASFALTO PENETRACION 120-150INDICE : 20ADELANTO MONTO MONTO DEFLATADONF. PAGO OTORGADOADELANTOACUMULADOFORMULA POLINOMICA UNICA1Apr-11S/.2,651,437.522,903,324.082,903,324.08

MONTODEL MONOMIOADEL.ADEL.I N D I C E SMONTOADELANTOSALDOVALORIZACIONBRUTOUTILIZ.AMORTIZADOMAXIMOUTILIZADOPORDEDUCC.VALORIZ.INC.%(1)x(2)x(2)'=DEFLATADOIoIaIrUTILIZABLEAMORTIZAR"D"No.MES(1)(2)(2)'(3)(4)(5)(6)ADEL.x(4)/(5)(8)(8)x(6-5)/(4)14Nov-114,829,041.590.091100.00%439,442.78ERROR:#REF!1508.891974.962064.352,903,324.08ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!15Dec-11ERROR:#REF!0.091100.00%ERROR:#REF!ERROR:#REF!1508.891974.962064.352,903,324.08ERROR:#REF!ERROR:#REF!ERROR:#REF!16Jan-12ERROR:#REF!0.091100.00%ERROR:#REF!ERROR:#REF!1508.891974.962064.352,903,324.08ERROR:#REF!ERROR:#REF!ERROR:#REF!

ERROR:#REF!ERROR:#REF!DEDUC. TOTALERROR:#REF!

VALORIZACIONAMORTIZACION DEL ADELANTO DE MATERIALESDEDUCC DEL REAJUSTE POR ADELANT MATER N 01TOTAL DEDUCC DEL REAJUSTE POR ADELANT MATERNMES01Dec-080.0002Jan-090.0003Feb-0904Mar-0905Apr-0906May-0907Jun-11ERROR:#REF!ERROR:#REF!ERROR:#REF!08Jul-11ERROR:#REF!ERROR:#REF!ERROR:#REF!09Aug-11ERROR:#REF!ERROR:#REF!ERROR:#REF!10Sep-11ERROR:#REF!ERROR:#REF!ERROR:#REF!11Oct-11ERROR:#REF!ERROR:#REF!ERROR:#REF!12Nov-11ERROR:#REF!ERROR:#REF!ERROR:#REF!13Dec-11ERROR:#REF!ERROR:#REF!ERROR:#REF!14Jan-12ERROR:#REF!ERROR:#REF!ERROR:#REF!15Feb-120.00TOTAL DEDUCION ACUMULADOERROR:#REF!TOTAL DEDUCCION ANTERIOR171,999.38TOTAL DEDUCCION MESERROR:#REF!

&8&F : &A&8&P/&N

Cartas Fianza

SISTEMA DE VALORIZACIONCONTROL DE CARTAS FIANZA DEL CONTRATISTA

REHABILITACION Y MEJORAMIENTO DE LA CARRETERA PATAHUASI - YAURI - SICUANI; TRAMO: EL DESCANSO - LANGUI

Supervisor: CONSORCIO SICUANI IIContratista: CONSORCIO VIAL EL DESCANSO - LANGUIContratoERROR:#REF!Presupuesto: S/.70'599,929.37 (Inc. IGV) Fecha Presup.: DICIEMBRE 2009

FIANZA N DE FIANZABANCO GARANTEGARANTIA ORIGINALGARANTIA RENOVADAVIGENCIA DE LA C/FSITUACIONOBSERVACIONESS/US$S/US$INICIOTERMINO

GARANTIA DE SERIEDAD DE OFERTA1,200,000.0010011-0586-9800147055-52Bco. Continental600,000.000.008/12/1011/10/10VencidaDevuelta250066-02Bco. Interbank600,000.000.008/3/1010/31/10VencidaDevuelta

GARANTIA DE FIEL CUMPLIMIENTO (Contrato Principal)7,059,992.947,059,992.941E0678-00-2010Secrex3,529,996.470.0010/7/109/2/11VencidaE0678-01-2010Secrex3,529,996.470.009/2/1112/31/11Vigente

250995-1Interbank3,529,996.470.0010/7/109/2/11Vencida50995-2Interbank0.003,529,996.470.009/2/1112/31/11Vigente

GARANTIA DE FIEL CUMPLIMIENTO (Presupuesto Adicional N 01)136,364.5815705741La Positiva68,182.290.003/1/1110/31/11Vigente25850133La Positiva68,182.290.003/1/1110/31/11Vigente

GARANTIA DE FIEL CUMPLIMIENTO (Presupuesto Adicional N 02 y Presupuesto Adicional N 03)214,527.2215708836La Positiva107,263.610.007/18/1110/31/11Vigente25853588La Positiva107,263.610.007/19/1110/31/11Vigente

GARANTIA DEL ADELANTO EN EFECTIVO14,119,985.8811,711,735.32151167-1Interbank7,059,992.940.0010/15/101/13/11Vencida51167-2Interbank7,059,992.940.001/14/114/13/11Vencida89.0051167-3Interbank6,465,888.530.004/13/117/17/11Vencida95.0051167-4Interbank5,855,867.390.007/17/1110/10/11Vigente

2E0698-00-2010Secrex3,529,996.470.0010/15/101/13/11VencidaE0698-00-2010Secrex3,529,996.470.001/13/114/13/11VencidaE0698-00-2010Secrex2,935,892.060.004/13/117/12/11VencidaE0698-00-2010Secrex2,325,871.460.007/12/1110/10/11Vigente

30011-0586-9800154655-59Continental3,529,996.470.0010/15/101/13/11Vencida0011-0586-9800154655-59Continental3,529,996.470.001/14/114/13/11Vencida0011-0586-9800154655-59Continental3,529,996.470.004/13/117/12/11Vencida0011-0586-9800154655-59Continental3,529,996.470.007/12/1110/10/11Vigente

GARANTIA DEL ADELANTO PARA MATERIALES4,484,000.004,484,000.0015705638La Positiva2,242,000.000.004/25/117/24/11Vencida5705638-01La Positiva2,242,000.000.007/24/1110/22/11Vigente

25847639La Positiva2,242,000.000.004/25/117/24/11Vencida5847639-01La Positiva2,242,000.007/24/1110/22/11Vigente

NOTAS:

Principal (2)

CUADRO COMPARATIVO DE AVANCE GENERAL DE LA OBRA

REHABILITACION Y MEJORAMIENTO DE LA CARRETERA PATAHUASI - YAURI - SICUANI; TRAMO: EL DESCANSO - LANGUI

Supervisor: CONSORCIO SICUANI IIContratista: CONSORCIO VIAL EL DESCANSO - LANGUIContrato: 158-2010-MTC/20Presupuesto: S/.70'599,929.37 (Inc. IGV) Fecha Presup.: DICIEMBRE 2009

PERIODOVALORIZACIONES DE OBRA PROGRAMADAS (S/.)VALORIZACIONES DE OBRA EJECUTADAS (S/.)SITUACION DE PRINCIPALSUMAACUM%PRESUPUESTOPRESUPUESTOPRESUPUESTOPRESUPUESTOPRESUPUESTOSUMAACUM%LA OBRAParc.ACUM.PRINCIPALADIC. 01ADIC. 02ADIC. 03ADIC. 05PARC.ACUM.ADELANTOATRASOInicio0.00.00.00.00%0.00%0.00.00.00%0.00%0.00%0.00%Oct-100.00.00.00.00%0.00%0.00.00.00.00%0.00%0.00%0.00%Nov-1094,520.1094,520.1094,520.100.15%0.15%147,145.33147,145.33147,145.330.24%0.24%55.68%0.00%Dec-10460,145.56460,145.56554,665.660.74%0.89%558,648.67558,648.67705,794.000.90%1.13%27.25%0.00%Jan-11266,213.87266,213.87820,879.530.43%1.32%863,589.34863,589.341,569,383.341.39%2.52%91.18%0.00%Feb-11266,213.87266,213.871,087,093.400.43%1.74%1,395,270.951,395,270.952,964,654.292.24%4.76%172.71%0.00%Mar-11856,242.30856,242.301,943,335.701.37%3.12%2,003,010.832,003,010.834,967,665.123.22%7.97%155.63%0.00%Apr-114,279,375.534,279,375.536,222,711.236.87%9.99%2,345,934.392,345,934.397,313,599.513.77%11.74%17.53%0.00%May-115,819,599.025,819,599.0212,042,310.259.34%19.33%2,388,072.822,388,072.829,701,672.333.83%15.57%0.00%19.44%Jun-116,654,631.086,654,631.0818,696,941.3310.68%30.01%5,313,709.085,313,709.0815,015,381.418.53%24.10%0.00%19.69%80%Falt. Para 80%Falt. Para 80% CDJul-114,678,413.294,678,413.2923,375,354.627.51%37.52%3,860,961.99343,610.92700,685.0688,457.3188,457.315,082,172.5920,097,554.008.16%32.26%0.00%14.02%18,700,283.70 -1,397,270.30 -1,074,823.31 Aug-116,746,884.906,746,884.9030,122,239.5210.83%48.35%1,824,183.88862,640.52199,507.77379,322.26379,322.263,644,976.6923,742,530.695.85%38.11%0.00%21.18%Sep-119,200,926.369,200,926.3639,323,165.8814.77%63.12%ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!78.82%Oct-1113,536,354.0213,536,354.0252,859,519.9021.73%84.84%Nov-119,441,811.299,441,811.2962,301,331.1915.16%100.00%62,301,331.190.00.00.00.062,301,331.19100.00%ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!

&8&F

REINTEGROO I N F E REINTEGRO POR REAJUSTE - VALORIZACION N21(CONTROL DE VALORIZACIONES Y REAJUSTES)CONTRATO PRINCIPAL

O B R A:REHABILITACION Y REMODELACION DE LA INFRAESTRUCTURA I.E. GUE SAN CARLOS

CONTRATISTA:: CONSORCIO PUNO CONSTRUYESUPERVISOR:: OFICINA DE INFRAESTRUCTURA EDUCATIVA - OINFE

VALORIZACIONREINTEGROREINTEGRODEDUCCIONREINTEGRONo.MESK-1BRUTOA.DNETOPROGRAMADOEJECUTADOPROGRAMADOEJECUTADOAUTORIZADOEFECTIVOMAT.01MAT.02MAT.03MAT.04TOTALAUTORIZADOFORMULA 01: ESTRUCTURAERROR:#REF!Mar-120.000.000.000.000.000.002Apr-120.000.000.000.000.000.003May-120.000.000.000.000.000.004Jun-120.000.000.000.000.000.005Jul-120.000.000.000.000.000.006Aug-120.000.000.000.000.000.007Sep-120.000.000.000.000.000.008Oct-120.000.000.000.000.000.009Nov-120.000.000.000.000.000.0010Dec-120.000.000.000.000.000.0011Jan-130.000.000.000.000.000.0012Feb-130.000.000.000.000.000.0013Mar-130.000.000.000.000.000.0014Apr-130.000.000.000.000.000.0021May-130.00131,500.340.0070.00920.50920.50724.330.000.000.000.000.00196.17SUB-TOTAL0.00920.50920.50724.330.00196.17EN VALORIZ. ANTERIORREINTEGRO ACTUAL920.50724.330.00196.17FORMULA 02: ARQUITECTURAERROR:#REF!Mar-120.000.000.000.000.000.002Apr-120.000.000.000.000.000.003May-120.000.000.000.000.000.004Jun-120.000.000.000.000.000.005Jul-120.000.000.000.000.000.006Aug-120.000.000.000.000.000.007Sep-120.000.000.000.000.000.008Oct-120.000.000.000.000.000.009Nov-120.000.000.000.000.000.0010Dec-120.000.000.000.000.000.0011Jan-130.000.000.000.000.000.0012Feb-130.000.000.000.000.000.0013Mar-130.000.000.000.000.000.0014Apr-130.000.000.000.000.000.0021May-13446,459.030.0090.004,018.134,018.132,082.123,905.261,164.820.00125.295,195.37-3,259.36SUB-TOTAL0.00446,459.030.004,018.134,018.132,082.125,195.37-3,259.36EN VALORIZ. ANTERIORREINTEGRO ACTUAL4,018.132,082.125,195.37-3,259.36FORMULA 03: INSTALACIONES SANITARIAS1Mar-120.000.000.000.000.000.002Apr-120.000.000.000.000.000.003May-120.000.000.000.000.000.004Jun-120.000.000.000.000.000.005Jul-120.000.000.000.000.000.006Aug-120.000.000.000.000.000.007Sep-120.000.000.000.000.000.008Oct-120.000.000.000.000.000.009Nov-120.000.000.000.000.000.0010Dec-120.000.000.000.000.000.0011Jan-130.000.000.000.000.000.0012Feb-130.000.000.000.000.000.0013Mar-130.000.000.000.000.000.0014Apr-130.000.000.000.000.000.0021May-1339,594.620.0270.001,069.051,069.05337.5472.502.473.870.0078.84652.67SUB-TOTAL0.0039,594.620.001,069.051,069.05337.5478.84652.67EN VALORIZ. ANTERIORREINTEGRO ACTUAL1,069.05337.5478.84652.67FORMULA 04: INSTALACIONES ELECTRICAS1Mar-120.000.000.000.000.000.002Apr-120.000.000.000.000.000.003May-120.000.000.000.000.000.004Jun-120.000.000.000.000.000.005Jul-120.000.000.000.000.000.006Aug-120.000.000.000.000.000.007Sep-120.000.000.000.000.000.008Oct-120.000.000.000.000.000.009Nov-120.000.000.000.000.000.0010Dec-120.000.000.000.000.000.0011Jan-130.000.000.000.000.000.0012Feb-130.000.000.000.000.000.0013Mar-130.000.000.000.000.000.0014Apr-130.000.000.000.000.000.0021May-13363,725.28-0.0450.00-16,367.64-16,367.640.00592.390.0060.690.00653.08-17,020.72SUB-TOTAL0.00363,725.280.00-16,367.64-16,367.640.00653.08-17,020.72EN VALORIZ. ANTERIORREINTEGRO ACTUALTOTAL SIN IGV0.00849,778.930.00-10,359.96-10,359.963,144.005,927.29-19,431.25EN VALORIZ. ANTERIORREINTEGRO ACTUAL-10,359.963,144.005,927.29-19,431.25