resumen general de valorizacion n°6 (3).xlsx

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

Post on 07-Jul-2016

213 views

Category:

Documents

1 download

Embed Size (px)

TRANSCRIPT

  • 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