10.2 Cronograma Valorizado Ampliacion de Plazo
10.2 Cronograma Valorizado Ampliacion de Plazo
10.2 Cronograma Valorizado Ampliacion de Plazo
2 CRONOGRAMA VALORIZADO
ampliacion d eplazo.xls
Ejecutar el 21/07/2014 14:26
Se quitarn los efectos aplicados a este objeto. Cualquier texto que desborde 500
los lmites de este grfico aparecer recortado.
Hoja1'!A1:AN1503
Es posible que uno o ms objetos de este libro, como formas, WordArt o 500
cuadros de texto, permitan que el texto desborde los lmites del objeto. Las
versiones anteriores de Excel no reconocen esta opcin y ocultarn el texto
que se desborde.
Hoja1'!A1:AN1503
Versin
Excel 97-2003
Excel 97-2003
3
PROYECTO: MEJORAMIENTO DE LOS SERVICIOS EDUCATIVOS DE LA INSTITUCION EDUCATIVA INICIAL MORO, DISTRITO PAUCARCOLLA - PUNO - PUNO
PRESUPUESTO: 950,141.65
RESIDENTE : ING. ANTONIO HUMORA VILCA CIP 132989
SUPERVISOR: ING. EDWIN APAZA GARAMBEL CIP 80341
03.02 ALCANTARILLAS: CONCRETO SIMPLE f'c=210 Kg/cm2 M2 100.00% 50% 20% 20% 10%
S/. 69.66 24.87 1,732.44 866.22 346.49 346.49 173.24
SUB TOTAL (COSTO DIRECTO) 100.00% 12.81% 64.36% 8.85% 7.50% 4.60% 1.89%
S/. 40,811.04 5,225.98 26,265.07 3,612.55 3,058.89 1,875.48 773.07
301.68%
GASTOS GENERALES
4
27.88%
GASTOS DE GESTION DE PROYECTO
1,456.90 7,322.19 1,007.11 852.76 522.85 215.52
S/. 11,377.33
96.57%
GASTOS DE SUPERVISION
5,046.59 25,363.50 3,488.55 2,953.89 1,811.11 746.53
S/. 39,410.17
20.32%
GASTOS DE LIQUIDACION
1,062.03 5,337.62 734.15 621.63 381.14 157.10
S/. 8,293.67
19.86%
GASTOS DE MONITOREO Y SEGUIMIENTO
1,037.92 5,216.47 717.48 607.52 372.49 153.54
S/. 8,105.42
PRESUPUESTO
ITEM DESCRIPCION UND.
METRADO
01 OBRAS PROVISIONALES, TRABAJOS PRELIMINARES Y SEGURIDAD
02.01.01 CORTES
02.03.02.02 ZARANDEO DE MATERIAL DE PRESTAMO (CANTERA MAT. LIGANTE MEZCLA 40%) m3 1,668.43
02.05 ENROCADO
05.00 SEALIZACION
06.00 VARIOS
06.01 PRUEBAS DE CONTROL DE CALIDAD / KM und 6.00
COSTO DIRECTO
PRESUPUESTO TOTAL
NA ITAPALLUNI DEL DISTRITO DE PUNO,
100%
1500
500.00 1,500.00
100%
884.8
884.80 884.80
100%
5000
5,000.00 5,000.00
100%
5000
5,000.00 5,000.00
20%
106.008
12.65 530.04
25% 25%
1,875.00
2,500.00 7,500.00 1875
25%
1798.2575
1.00 7,193.03
19% 5% 5% 5% 11% 5%
5,324.63 1410 1410 1410 3,135.37 1,410.00
0.94 28,200.00
25% 25%
1,777.50 1,777.50
237.00 7,110.00
15% 5% 5% 5% 10% 5%
1687.5 562.5 562.5 562.5 1125 562.5
11,250.00 11,250.00
3% 3% 3% 10% 10%
1035.0015 1035.0015 1035.0015 3,450.01 3,450.01
6.14 34,500.05
8.68 30,255.01
3% 3% 3% 15% 20%
139.86 139.86 139.86 699.30 932.40
15.54 4,662.00
7.74 22,961.64
5.22 1,252.80
3.22 77,280.00
4.30 60,888.00
8.12 13,547.65
5.74 9,576.79
25.94 43,279.07
3.05 10,507.49
5.17 17,811.06
1.72 412.80
5.56 133,440.00
22.63 135,539.90
14.44 15,884.00
31.24 140,331.64
37.33 59,728.00
31.10 15,674.40
50% 50%
5,329.30 5,329.30
31.10 10,658.59
50% 50%
3,859.03 3,859.03
22.52 7,718.05
50% 50%
5,367.00 5,367.00
31.32 10,733.99
20% 30%
492.68 739.01
16.09 2,463.38
20% 30%
3,420.41 5,130.62
488.63 17,102.05
20% 30%
2,237.64 3,356.46
745.88 11,188.20
3.52 1,760.00
2.69 1,345.00
1.49 3,725.00
1.61 4,025.00
5,000.00 5,000.00
1,636.25 1,636.25
436.25 872.50
436.25 872.50
574.36 1,148.72
574.36 1,148.72
200.00 1,200.00
1,200.00 7,200.00
25.00 1,000.00
0.22 6,600.00
S/.
1,488,999.35
25%
1,012.55
25% 25%
1875 1875
25% 25%
1,798.26
1,798.26
5% 5% 10% 5% 5% 5% 10% 5%
1,410.00 1,410.00 2,820.00 1,410.00 1,410.00 1,410.00 2,820.00 1,410.00
25% 25%
1,777.50 1,777.50
5% 5% 10% 5% 5% 5% 10% 5%
562.5 562.5 1125 562.5 562.5 562.5 1125 562.5
20%
1463.52
40% 30%
9,184.66 6,888.49
30% 70%
40,661.97 94,877.93
30% 70%
4,765.20 11,118.80
30%
42,099.49 98,232.15
30%
17,918.40 41,809.60
100%
15,674.40
30% 20%
739.01 492.68
30% 20%
10,019.07 6,679.38
30% 20%
5,000.13 3,333.42
30% 20%
5,130.62 3,420.41
30% 20%
3,356.46 2,237.64
40% 30%
654.50 490.88
40% 30%
349.00 261.75
40% 30%
349.00 261.75
40% 30%
459.49 344.62
40% 30%
459.49 344.62
100%
1,200.00
224,966.56 S/. 335,988.34 S/. 540
1,488
MARZO 2016 MONTOS EN SOLES
SEM3 SEM4 COSTO % AVANCE MES 1 MES 2 MES 3
0 0 0
1500 0 0
884.8 0 0
5000 0 0
5000 0 0
2025.1 2025.1 0
0 212.016 318.024
25%
1,798.26
1798.2575 1798.2575 1798.2575
5%
562.5
3375 2812.5 2812.5
2927.04 4390.56 0
0 0 30255.01
30%
6,888.49
0 0 0
0 375.84 0
25%
19,320.00
0 19320 0
0 21845.81102366 39,042.19
10%
1,354.77
0 0 4064.295
10%
957.68
0 0 2873.037
10%
4,327.91
0 0 12983.721
20% 10%
2,101.50 1,050.75
0 0 3152.247
20% 10%
3,562.21 1,781.11
0 0 5343.318
20% 10%
82.56 41.28
0 0 123.84
20% 10%
26,688.00 13,344.00
0 0 40032
0 40661.97 0
0 4765.2 0
0 42099.492 0
0 17918.4 0
0 0 15674.4
10658.59 0 0
7718.05 0 0
10733.99 0 0
1231.69 0 1231.69
8551.025 0 8551.025
5594.1 0 5594.1
100%
1,760.00
0 0 0
100%
1,345.00
0 0 0
100%
3725 0 0 0
100%
4,025.00 0 0 0
100%
5,000.00
0 0 0
30%
490.88
0 0 0
30%
261.75
0 0 0
30%
261.75
0 0 0
30%
344.62
0 0 0
30%
344.62
0 0 0
0 0 0
0 0 0
100%
7,200.00
0 0 0
100%
1,000.00
0 0 0
100%
6,600.00
0 0 0
6622.940729
MONTOS EN SOLES
MES 4 TOTAL
0 0 OK
0 1500 OK
0 884.8 OK
0 5000 OK
0 5000 OK
0 4050.2 OK
0 530.04 OK
1875 7500 OK
1798.2575 7193.03 OK
4230 28200 OK
1777.5 7110 OK
2250 11250 OK
0 7317.6 OK
0 34500.05 OK
0 30255.01 OK
0 4662 OK
22961.64 22961.64 OK
876.96 1252.8 OK
57960 77280 OK
0 60888 OK
0 27650.47 OK
0 19546.02 OK
0 28569.88 OK
0 98028 OK
3448.4194092857 58380.39 OK
9483.355 13547.65 OK
6703.753 9576.79 OK
30295.349 43279.07 OK
7355.243 10507.49 OK
12467.742 17811.06 OK
288.96 412.8 OK
93408 133440 OK
94877.93 135539.9 OK
11118.8 15884 OK
98232.148 140331.64 OK
41809.6 59728 OK
0 15674.4 OK
0 10658.59 OK
0 7718.05 OK
0 10733.99 OK
0 2463.38 OK
0 33396.89 OK
0 16667.1 OK
0 17102.05 OK
0 11188.2 OK
1760 1760 OK
1345 1345 OK
3725 3725 OK
4025 4025 OK
5000 5000 OK
1636.25 1636.25 OK
872.5 872.5 OK
872.5 872.5 OK
1148.72 1148.72 OK
1148.72 1148.72 OK
1200 1200 OK
0 0
7200 7200 OK
1000 1000 OK
6600 6600 OK
493,988.21 1,292,704.67
46,614.80 1,292,704.67
13,030.16
5,870.12
9,496.06
568999.35 1488999.35
WTF
38.21% 100%
568,999.35
-46,764.14