RESUMEN GENERAL DE VALORIZACION N°6 (3).xlsx

MONTOS VALORIZADOS PROGRAMADOS

MONTOS (Inc/ IGV) PORCENTAJESMES PARCIAL ACUMUL. PARCIAL ACUMUL.

S/. S/. % %1-Mar-14 0.00 0.00 0.00% 0.00%

17-Mar-14 0.00 0.00 0.00% 0.00%31-Mar-14 69,002.85 69,002.85 0.88% 0.88%30-Apr-14 323,201.18 392,204.03 4.11% 4.98%31-May-14 684,272.47 1,076,476.51 8.70% 13.68%30-Jun-14 1,069,934.05 2,146,410.56 13.60% 27.28%31-Jul-14 1,391,238.43 3,537,648.99 17.68% 44.96%31-Aug-14 1,725,234.27 5,262,883.26 21.93% 66.89%30-Sep-14 2,261,798.97 7,524,682.22 28.75% 95.63%12-Oct-14 343,802.67 7,868,484.89 4.37% 100.00%

TOTAL 7,868,484.89 100.00%

00.0088147541 0.0597721933

0.1325094798

GRFICO DEL AVANCE FSICO PROGRAMADO VS. AVANCE FSICO EJECUTADO

EJECUTADO

1997066.69

MONTOS VALORIZADOS EJECUTADOS

MONTOS (Inc/ IGV) PORCENTAJESMES PARCIAL ACUMUL. PARCIAL

S/. S/. %1-Mar-14 0.00 0.00 0.00%17-Mar-14 0.00 0.00 0.00%31-Mar-14 69,358.76 69,358.76 0.88%30-Apr-14 400,957.84 470,316.60 5.10%31-May-14 572,332.24 1,042,648.84 7.27%30-Jun-14 854,895.91 1,897,544.75 10.86%31-Jul-1431-Aug-1430-Sep-1412-Oct-14

TOTAL 1,897,544.75 24.12%

00.0088147541 0.0597721933

0.1325094798

GRFICO DEL AVANCE FSICO PROGRAMADO VS. AVANCE FSICO EJECUTADO

EJECUTADO

58778.61 10580.15 69358.7598339794.78 61163.06 400957.8404

485027.32146 87304.92 572332.2393228883,600.71 159048.13 1,042,648.84

MONTOS VALORIZADOS EJECUTADOS

ACUMUL.%0.00%0.00%

0.88%5.98%

13.25%24.12%

00.0088147541 0.0597721933

0.1325094798

GRFICO DEL AVANCE FSICO PROGRAMADO VS. AVANCE FSICO EJECUTADO

EJECUTADO

RESUMEN GENERAL DE LA VALORIZACIN N 06DEL 01/05/2016 AL 31/05/2016

OBRA: MEJORAMIENTO Y AMPLIACIN DEL SERVICIO EDUCATIVO A NIVEL INICIAL EN 09 LOCALIDADES DEL DISTRITO DE CHIRINOS - SAN IGNACIO - CAJAMARCA

PROPIETARIO: MUNICIPALIDAD DISTRITAL DE CHIRINOSRESIDENTE: ING. SEGUNDO JUAN CORONEL PEREZSUPERVISOR DE OBRA: CONSORCIO SUPERVISOR CAJAMARCAUBICACIN CAJAMARCA-SAN IGNACIO-CHIRINOSFECHA PPTO.REFERENCIAL: Diciembre 2013MONTO CONTRACTUAL (C/IGV): S/. 8,890,382.93MONTO CONTRACTUAL DE OBRA (C/IGV): S/. 8,890,382.93 FECHA DE INICIO DE OBRA 12/5/2015MONTO CONTRACTUAL DE OBRA (S/IGV): S/. 7,534,222.82 FECHA DE TERMINO DE OBRA 6/1/2016PLAZO DE EJECUCION: 180 dias calendarioELABORADO JEFE DE SUPERVISION ARQ. BRENDA BARTOLO SEGURA

CONCEPTO VAL. ACTUAL

VAL 01 VAL 02 VAL 03 VAL 04 VAL 05 N06 ACUMULADO (S/.)

TOTAL CONTRACTUAL S/IGV 7,534,222.82 8,890,382.93 2,593,778.59 1,130,133.42 1,300,012.00 895,990.86 929,087.84 6,849,002.70 456,674.11 7,305,676.81 96.97% 228,546.01

Avances en porcentajes 34.43% 15.00% 17.25% 11.89% 12.33% 90.91% 6.06% 96.97% 3.03%I.E.I. N 128 SAN PEDRO DE PERICO 1,426,305.22 1,683,040.16 699,479.34 180,218.66 111,139.72 162,517.24 192,314.76 1,345,669.72 42,973.02 1,388,642.74 97.36% 37,662.48

49.04% 12.64% 7.79% 11.39% 13.48% 94.35% 3.01%I.E.I. N 122 PUERTO TAMBORAPA 683,097.97 806,055.60 302,790.89 63,253.73 66,317.12 101,007.52 88,386.10 621,755.35 40,298.27 662,053.62 96.92% 21,044.35

44.33% 9.26% 9.71% 14.79% 12.94% 91.02% 5.90%I.E.I. N 206 LAMBAYEQUE 550,123.36 649,145.56 189,590.57 83,618.45 59,957.23 81,160.87 71,517.88 485,845.00 41,008.94 526,853.94 95.77% 23,269.42

34.46% 15.20% 10.90% 14.75% 13.00% 88.32% 7.45%I.E.I. N 204 CORDILLERA ANDINA 657,128.24 775,411.32 249,507.56 102,114.31 73,355.64 86,340.16 86,871.45 598,189.12 36,858.84 635,047.96 96.64% 22,080.28

37.97% 15.54% 11.16% 13.14% 13.22% 91.03% 5.61%I.E.I. N 195 LA PALMA 745,765.63 880,003.44 95,896.03 189,985.43 168,102.62 92,786.54 139,382.46 686,153.08 41,222.54 727,375.62 97.53% 18,390.01

12.86% 25.48% 22.54% 12.44% 18.69% 92.01% 5.53%I.E.I. N 194 EL CORAZON 902,619.22 1,065,090.68 391,317.99 46,997.37 172,007.50 108,225.09 106,536.06 825,084.01 39,670.54 864,754.55 95.81% 37,864.67

43.35% 5.21% 19.06% 11.99% 11.80% 91.41% 4.40%I.E.I. N 16494 HUACACURO 959,563.15 1,132,284.52 304,849.84 95,301.85 336,613.71 79,720.17 80,399.89 896,885.46 44,536.38 941,421.84 98.11% 18,141.31

31.77% 9.93% 35.08% 8.31% 8.38% 93.47% 4.64%I.E.I. N 205 EL LIMON 882,704.21 1,041,590.97 167,322.60 234,128.73 224,101.49 39,448.08 59,332.11 724,333.01 134,244.35 858,577.36 97.27% 24,126.85

18.96% 26.52% 25.39% 4.47% 6.72% 82.06% 15.21%I.E.I. N 160 TABLON DE CUNIA 678,693.81 800,858.70 193,023.77 134,514.89 78,772.57 106,207.59 104,347.13 616,865.95 35,861.23 652,727.18 96.17% 25,966.63

28.44% 19.82% 11.61% 15.65% 15.37% 90.89% 5.28%CAPACITACION DOCENTE Y ADMINISTRATIVA 35,910.00 42,373.80 0.00 7,182.00 28,728.00 35,910.00 35,910.00 100.00% 0.00

0.20 0.80 0.00 100.00% 0.00%DISEO DE ESTRUCTURA CURRICULAR 12,312.00 14,528.16 0.00 2,462.40 9,849.60 12,312.00 12,312.00 100.00% 0.00

0.20 0.80 0.00 100.00% 0.00%

REAJUSTES ( R ) (/)VAL-01 NO SE SOLICITO (sera en liquidacion)

DEDUCCIONES (D)

POR ADELANTO EN EFECTIVO 0.00 0.00 0.00 0.00 0.00

POR ADELANTO PARA MATERIALES

VALORIZACION BRUTA (VB= V + R - D) 1,778,076.58 6,849,002.70 456,674.11 7,305,676.81 96.97% 228,546.01

AMORTIZACIONES (A) Pagado S/IGV

DEL ADELANTO DIRECTO (20%) DIC. 2015 1,506,844.56 376,711.14 301,368.91 301,368.92 204,534.03 322,861.54 1,506,844.56 0.00 1,506,844.56 100.00% 0.00

15% 27% 23.18% 22.83% 34.75% 100.00%I.E.I. N 128 SAN PEDRO DE PERICO 41,856.79 33,485.43 33,485.44 22,726.00 35,873.50 167,427.17 0.00I.E.I. N 122 PUERTO TAMBORAPA 41,856.79 33,485.43 33,485.44 22,726.00 35,873.50 167,427.17 0.00I.E.I. N 206 LAMBAYEQUE 41,856.79 33,485.43 33,485.44 22,726.00 35,873.50 167,427.17 0.00I.E.I. N 204 CORDILLERA ANDINA 41,856.79 33,485.43 33,485.44 22,726.00 35,873.50 167,427.17 0.00I.E.I. N 195 LA PALMA 41,856.79 33,485.43 33,485.44 22,726.00 35,873.50 167,427.17 0.00I.E.I. N 194 EL CORAZON 41,856.79 33,485.43 33,485.44 22,726.00 35,873.50 167,427.17 0.00I.E.I. N 16494 HUACACURO 41,856.79 33,485.43 33,485.44 22,726.00 35,873.50 167,427.17 0.00I.E.I. N 205 EL LIMON 41,856.79 33,485.43 33,485.44 22,726.00 35,873.50 167,427.17 0.00I.E.I. N 160 TABLON DE CUNIA S/IGV 41,856.79 33,485.43 33,485.44 22,726.00 35,873.50 131,553.67 0.00

DEL ADELANTO DE MATERIALES (10%) DIC.2015 753,422.28 753,422.28 0.00 0.00 0.00 753,422.28 0.00 753,422.28 100.00% 0.00 (/)

TOTAL AMORTIZACIONES (A) 2,260,266.84 1,130,133.42 301,368.91 301,368.92 204,534.03 2,260,266.84 0.00 2,260,266.84 0.00

VALORIZACION NETA (VN=VB-A) 1,463,645.17 828,764.51 998,643.08 691,456.83 4,588,735.86 456,674.11 5,045,409.97 228,546.01

RETENCIONES ( C )

FONDO DE GARANTIA (5%Xvb)

GASTOS DE LICITACIONMULTA POR ATRASO DE OBRA

TOTAL 0.00 0.00 0.00 0.00 0.00

MONTO A PAGAR AL CONTRATISTA 1,463,645.17 828,764.51 998,643.08 691,456.83 4,588,735.86 456,674.11 5,045,409.97 228,546.01

EN EFECTIVO (VN-C) 1,463,645.17 828,764.51 998,643.08 691,456.83 4,588,735.86 456,674.11 5,045,409.97 228,546.01

MONTO POR IGV (VNX0.18) 263,456.13 149,177.61 179,755.75 124,462.23 825,972.46 82,201.34 908,173.79 41,138.28

MONTO TOTAL CON IGV 1,727,101.30 977,942.12 1,178,398.83 815,919.06 5,414,708.32 538,875.45 5,953,583.77 269,684.29

TOTAL COMPROMISO DE PAGO >>>>>>>>>>>>>>>>>>>>>>>>>> S/. 538,875.45

(/) CARTA FIANZA DEL ADELANTO DE MATERIALES LIBERADA

MONTO CONTRATADO

S/IGV(S/.)

MONTO CONTRATADOCON IGV (S/.)

% DE AVANCE ACUMULADO

SALDO POR VALORIZAR (S/.)

VAL. ACUM.ANTERIOR

Elaborado por Consorcio Supervisor Cajamarca

RESUMEN GENERAL DE LA VALORIZACIN N 06DEL 01/05/2016 AL 31/05/2016

OBRA: MEJORAMIENTO Y AMPLIACIN DEL SERVICIO EDUCATIVO A NIVEL INICIAL EN 09 LOCALIDADES DEL DISTRITO DE CHIRINOS - SAN IGNACIO - CAJAMARCA

PROPIETARIO: MUNICIPALIDAD DISTRITAL DE CHIRINOSRESIDENTE: ING. SEGUNDO JUAN CORONEL PEREZSUPERVISOR DE OBRA: ARQ. BRENDA BARTOLO SEGURAUBICACIN CAJAMARCA-SAN IGNACIO-CHIRINOSFECHA PPTO.REFERENCIAL:MONTO CONTRACTUAL (C/IGV): S/. 1,683,040.16MONTO CONTRACTUAL (S/IGV): S/. 1,426,305.22PLAZO DE EJECUCION: 180 DIAS CALENDARIOS

CONCEPTO val 01

TOTAL CONTRACTUAL S/IGV 1,426,305.22

VALORIZACION CONTRACTUAL 699,479.34

ESTRUCTURASARQUITECTURAI. SANITARIASI. ELECTRICAS

REAJUSTES 0.00

VALORIZACION BRUTA 699,479.36

AMORTIZACIONES

167,427.17 41,856.79

83,713.59 83,713.59

TOTAL AMORTIZACIONES 125,570.38

VALORIZACION NETA 573,908.98

I.G.V. 103,303.62

TOTALES 677,212.60

MONTO CONTRATADO

DEL ADELANTO DIRECTO (19.56%)

DEL ADELANTO DE MATERIALES (39.08%)

Elaborado por Consorcio Supervisor Cajamarca

RESUMEN GENERAL DE LA VALORIZACIN N 06DEL 01/05/2016 AL 31/05/2016

MEJORAMIENTO Y AMPLIACIN DEL SERVICIO EDUCATIVO A NIVEL INICIAL EN 09 LOCALIDADES DEL DISTRITO DE CHIRINOS - SAN IGNACIO - CAJAMARCA

MUNICIPALIDAD DISTRITAL DE CHIRINOS

val 02 val 03 val 04 val 05

180,218.66 111,139.72 162,517.24 192,314.76 1,345,669.720.13

0.00 0.00 0.00 0.00 0.00

180,218.66 111,139.72 162,517.24 192,314.76 1,345,669.72

33,485.43 33,485.44 22,726.00 35,873.50 167,427.17

0.00 0.00 0.00 0.00 83,713.59

33,485.43 33,485.44 22,726.00 35,873.50 251,140.76

146,733.23 77,654.29 139,791.24 156,441.26 1,094,528.96

26,411.98 13,977.77 25,162.42 28,159.43 197,015.21

173,145.21 91,632.06 164,953.66 184,600.68 1,291,544.17

VAL. ACUM ANTERIOR

Elaborado por Consorcio Supervisor Cajamarca

RESUMEN GENERAL DE LA VALORIZACIN N 06DEL 01/05/2016 AL 31/05/2016

MEJORAMIENTO Y AMPLIACIN DEL SERVICIO EDUCATIVO A NIVEL INICIAL EN 09 LOCALIDADES DEL DISTRITO DE CHI