FECHA 25-Feb-15 3-Mar-15 10-Mar-15 17-Mar-15 24-Mar-15 31-Mar-15 7-Apr-15 14-Apr-15 21-Apr-15 28-Apr-15 5-May-15 12-May-15 19-May-15

AVANCE SEMANAL PROGRAMADO 0.00% 0.02% 0.02% 0.02% 0.01% 0.01% 0.03% 0.03% 0.05% 0.05% 0.04% 0.08% 0.10%
AVANCE SEMANAL PROGRAMADO AC. 0.00% 0.02% 0.04% 0.06% 0.07% 0.08% 0.11% 0.14% 0.19% 0.24% 0.28% 0.36% 0.46%
AVANCE SEMANAL REAL 0.00% 0.02% 0.02% 0.02% 0.01% 0.01% 0.03% 0.13% 0.05% 0.06% 0.06% 0,06%
AVANCE SEMANAL REAL AC. 0.00% 0.02% 0.04% 0.06% 0.07% 0.08% 0.11% 0.24% 0.29% 0.35% 0.41% 0,47%
DESVIACIÓN 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.10% 0.10% 0.11% 0.13% 0,11 %
DÍAS ADELANTO 1,07 día
CURVA PLANIFICADA V/S REAL GALERÍA IMPERIO
1

0.9
ADELANTO= 1 DÍA

0.8

0.7

0.6
PLANIFICADO
% AVANCE

0.5
REAL

0.4

0.3

0.2

0.1
0.47%
0.36%
0
 FECHA 25-Feb-15 28-Apr-15 5-May-15
AVANCE SEMANAL PROGRAMADO 0.00% 0.05% 0.04%
AVANCE SEMANAL PROGRAMADO AC. 0.00% 0.24% 0.28%
AVANCE SEMANAL REAL 0.00% 0.00% 0.00%
AVANCE SEMANAL REAL AC. 0.00% 0.00% 0.00%
DESVIACIÓN 0.240%
Dec/99
DÍAS ADELANTO 1 día

0%

Retenciones 5%
Garantia correcta ejecucion 10% Para evitar retenciones o pago anticipado d
Fiel Cumplimiento del contrato

Anticipo 10%

CD 651,281.49 79.69%
GG 132,116.06 20.29% 16.17%
Utilidades 37,839.45 5.81% 4.63%
Dscto Cierre - 4,000.00 -0.49%
Total Neto 817,237.00 100.00%
 12-May-15 19-May-15 26-May-15 2-Jun-15 9-Jun-15 16-Jun-15
0.08% 0.10% 0.12% 0.17% 0.19% 0.21%
0.36% 0.46% 0.58% 0.75% 0.94% 1.15%
0.00%
0.00%
0.340%

DATOS DEL PROYECTO

Materiales 48.20%
Subcontratos de obra 16.06%
Mano de Obra Directa 35.74%
Mano de Obra Indirecta 50.03%
Gastos Generales ( sin MOI) 49.97%
23-Jun-15 30-Jun-15 7-Jul-15 14-Jul-15 21-Jul-15 28-Jul-15 4-Aug-15 11-Aug-15
0.20% 0.19% 0.23% 0.24% 0.21% 0.27% 0.30% 0.36%
1.35% 1.54% 1.77% 2.01% 2.22% 2.49% 2.79% 3.15%

0.960% 0.950%
18-Aug-15 25-Aug-15 1-Sep-15 8-Sep-15 15-Sep-15 22-Sep-15 29-Sep-15 6-Oct-15
0.38% 0.38% 0.35% 0.34% 0.33% 0.25% 0.31% 0.33%
3.53% 3.91% 4.26% 4.60% 4.93% 5.18% 5.49% 5.82%

1.420% 1.580%
13-Oct-15 20-Oct-15 27-Oct-15 3-Nov-15 10-Nov-15 17-Nov-15 24-Nov-15 1-Dec-15
0.24% 0.31% 0.31% 0.33% 0.35% 0.33% 0.32% 0.35%
6.06% 6.37% 6.68% 7.01% 7.36% 7.69% 8.01% 8.36%

1.190% 1.330%
8-Dec-15 15-Dec-15 22-Dec-15 29-Dec-15 5-Jan-16 12-Jan-16 19-Jan-16 26-Jan-16
0.31% 0.34% 0.35% 0.32% 0.33% 0.56% 0.62% 0.74%
8.67% 9.01% 9.36% 9.68% 10.01% 10.57% 11.19% 11.93%

1.670% 2.250%
2-Feb-16 9-Feb-16 16-Feb-16 23-Feb-16 1-Mar-16 8-Mar-16 15-Mar-16 22-Mar-16
0.73% 0.74% 0.74% 0.67% 0.70% 0.78% 0.78% 0.90%
12.66% 13.40% 14.14% 14.81% 15.51% 16.29% 17.07% 17.97%

2.880%
29-Mar-16 5-Apr-16 12-Apr-16 19-Apr-16 26-Apr-16 3-May-16 10-May-16 17-May-16
0.75% 0.92% 0.90% 0.94% 1.51% 1.48% 1.41% 1.37%
18.72% 19.64% 20.54% 21.48% 22.99% 24.47% 25.88% 27.25%

3.910% 4.270%
24-May-16 31-May-16 7-Jun-16 14-Jun-16 21-Jun-16 28-Jun-16 5-Jul-16 12-Jul-16
1.35% 1.27% 0.71% 0.70% 0.81% 0.86% 1.11% 1.15%
28.60% 29.87% 30.58% 31.28% 32.09% 32.95% 34.06% 35.21%

6.880% 3.080%
19-Jul-16 26-Jul-16 2-Aug-16 9-Aug-16 16-Aug-16 23-Aug-16 30-Aug-16 6-Sep-16
1.15% 1.14% 1.17% 1.17% 1.08% 1.30% 1.38% 1.33%
36.36% 37.50% 38.67% 39.84% 40.92% 42.22% 43.60% 44.93%

4.550% 6.100%
13-Sep-16 20-Sep-16 27-Sep-16 4-Oct-16 11-Oct-16 18-Oct-16 25-Oct-16 1-Nov-16
1.29% 1.47% 1.85% 1.92% 1.90% 2.16% 2.24% 1.84%
46.22% 47.69% 49.54% 51.46% 53.36% 55.52% 57.76% 59.60%

5.940% 8.220%
8-Nov-16 15-Nov-16 22-Nov-16 29-Nov-16 6-Dec-16 13-Dec-16 20-Dec-16 27-Dec-16
2.30% 2.34% 2.37% 2.40% 2.35% 2.08% 2.48% 2.44%
61.90% 64.24% 66.61% 69.01% 71.36% 73.44% 75.92% 78.36%

11.250% 9.350%
3-Jan-17 10-Jan-17 17-Jan-17 24-Jan-17 31-Jan-17 7-Feb-17 14-Feb-17 21-Feb-17
2.40% 2.30% 2.19% 1.97% 1.87% 1.48% 1.26% 1.17%
80.76% 83.06% 85.25% 87.22% 89.09% 90.57% 91.83% 93.00%

10.730%
28-Feb-17 7-Mar-17 14-Mar-17 21-Mar-17 28-Mar-17 4-Apr-17 11-Apr-17 18-Apr-17
1.16% 1.04% 0.74% 0.67% 0.67% 0.66% 0.60% 0.45%
94.16% 95.20% 95.94% 96.61% 97.28% 97.94% 98.54% 98.99%

5.070% 3.120%
25-Apr-17 2-May-17 9-May-17 16-May-17 23-May-17 30-May-17
0.32% 0.32% 0.22% 0.12% 0.02% 0.01%
99.31% 99.63% 99.85% 99.97% 99.99% 100.00%

2.030% 0.690%
Resumen EP Rersumen Cuadrado egresos (sin r
EP % Avance Monto Neto CD Materiales SubContratoMO
1 0.24% 1,961.37 1,563.08 753.40 251.03 558.64
2 0.34% 2,778.61 2,214.36 1,067.32 355.63 791.41
3 0.96% 7,845.48 6,252.30 3,013.61 1,004.12 2,234.57
4 0.95% 7,763.75 6,187.17 2,982.22 993.66 2,211.30
5 1.42% 11,604.77 9,248.20 4,457.63 1,485.26 3,305.31
6 1.58% 12,912.34 10,290.25 4,959.90 1,652.61 3,677.73
7 1.19% 9,725.12 7,750.25 3,735.62 1,244.69 2,769.94
8 1.33% 10,869.25 8,662.04 4,175.11 1,391.12 3,095.81
9 1.67% 13,647.86 10,876.40 5,242.43 1,746.75 3,887.23
10 2.25% 18,387.83 14,653.83 7,063.15 2,353.41 5,237.28
11 2.88% 23,536.43 18,756.91 9,040.83 3,012.36 6,703.72
12 3.91% 31,953.97 25,465.11 12,274.18 4,089.70 9,101.23
13 4.27% 34,896.02 27,809.72 13,404.28 4,466.24 9,939.19
14 6.88% 56,225.91 44,808.17 21,597.54 7,196.19 16,014.44
15 3.08% 25,170.90 20,059.47 9,668.66 3,221.55 7,169.25
16 4.55% 37,184.28 29,633.31 14,283.25 4,759.11 10,590.94
17 6.10% 49,851.46 39,728.17 19,148.98 6,380.34 14,198.85
18 5.94% 48,543.88 38,686.12 18,646.71 6,212.99 13,826.42
19 8.22% 67,176.88 53,535.34 25,804.03 8,597.78 19,133.53
20 11.25% 91,939.16 73,269.17 35,315.74 11,767.03 26,186.40
21 9.35% 76,411.66 60,894.82 29,351.30 9,779.71 21,763.81
22 10.73% 87,689.53 69,882.50 33,683.37 11,223.13 24,976.01
23 5.07% 41,433.92 33,019.97 15,915.63 5,303.01 11,801.34
24 3.12% 25,497.79 20,319.98 9,794.23 3,263.39 7,262.36
25 2.03% 16,589.91 13,221.01 6,372.53 2,123.29 4,725.19
26 0.69% 5,638.94 4,493.84 2,166.03 721.71 1,606.10
TOTAL 100% 817,237.00 651,281.49 313,917.68 104,595.81 232,768.00

FLUJO

CD GG
Subtotal
EP
SubContrat Egresos
Materales o MO GGMO GGsMO
- -
1 753.40 251.03 558.64 158.63 158.44 1,880.15
2 1,067.32 355.63 791.41 224.73 224.46 2,663.55
3 3,013.61 1,004.12 2,234.57 634.54 633.78 7,520.62
4 2,982.22 993.66 2,211.30 627.93 627.17 7,442.28
5 4,457.63 1,485.26 3,305.31 938.59 937.46 11,124.25
6 4,959.90 1,652.61 3,677.73 1,044.34 1,043.09 12,377.68
7 3,735.62 1,244.69 2,769.94 786.56 785.62 9,322.43
8 4,175.11 1,391.12 3,095.81 879.10 878.04 10,419.19
9 5,242.43 1,746.75 3,887.23 1,103.83 1,102.51 13,082.74
10 7,063.15 2,353.41 5,237.28 1,487.20 1,485.41 17,626.44
11 9,040.83 3,012.36 6,703.72 1,903.61 1,901.33 22,561.85
12 12,274.18 4,089.70 9,101.23 2,584.42 2,581.32 30,630.84
13 13,404.28 4,466.24 9,939.19 2,822.37 2,818.99 33,451.08
14 21,597.54 7,196.19 16,014.44 4,547.52 4,542.07 53,897.75
15 9,668.66 3,221.55 7,169.25 2,035.81 2,033.37 24,128.64
16 14,283.25 4,759.11 10,590.94 3,007.44 3,003.84 35,644.59
17 19,148.98 6,380.34 14,198.85 4,031.96 4,027.12 47,787.25
18 18,646.71 6,212.99 13,826.42 3,926.20 3,921.49 46,533.81
19 25,804.03 8,597.78 19,133.53 5,433.23 5,426.71 64,395.28
20 35,315.74 11,767.03 26,186.40 7,435.99 7,427.07 88,132.22
21 29,351.30 9,779.71 21,763.81 6,180.13 6,172.72 73,247.67
22 33,683.37 11,223.13 24,976.01 7,092.28 7,083.77 84,058.56
23 15,915.63 5,303.01 11,801.34 3,351.15 3,347.13 39,718.26
24 9,794.23 3,263.39 7,262.36 2,062.25 2,059.77 24,442.00
25 6,372.53 2,123.29 4,725.19 1,341.78 1,340.17 15,902.97
26 2,166.03 721.71 1,606.10 456.07 455.53 5,405.44
27
umen Cuadrado egresos (sin retenciones)
GG Sin MO MO Retenciones
1,563.08 317 158.44 158.63 317.08 1,880.15 A cubrir
2,214.36 449 224.46 224.73 449.19 2,663.55 EP
6,252.30 1,268 633.78 634.54 1,268.31 7,520.62 1
6,187.17 1,255 627.17 627.93 1,255.10 7,442.28 2
9,248.20 1,876 937.46 938.59 1,876.05 11,124.25 3
10,290.25 2,087 1,043.09 1,044.34 2,087.43 12,377.68 4
7,750.25 1,572 785.62 786.56 1,572.18 9,322.43 5
8,662.04 1,757 878.04 879.10 1,757.14 10,419.19 6
10,876.40 2,206 1,102.51 1,103.83 2,206.34 13,082.74 7
14,653.83 2,973 1,485.41 1,487.20 2,972.61 17,626.44 8
18,756.91 3,805 1,901.33 1,903.61 3,804.94 22,561.85 9
25,465.11 5,166 2,581.32 2,584.42 5,165.74 30,630.84 10
27,809.72 5,641 2,818.99 2,822.37 5,641.36 33,451.08 11
44,808.17 9,090 4,542.07 4,547.52 9,089.58 53,897.75 12
20,059.47 4,069 2,033.37 2,035.81 4,069.17 24,128.64 13
29,633.31 6,011 3,003.84 3,007.44 6,011.28 35,644.59 14
39,728.17 8,059 4,027.12 4,031.96 8,059.08 47,787.25 15
38,686.12 7,848 3,921.49 3,926.20 7,847.69 46,533.81 16
53,535.34 10,860 5,426.71 5,433.23 10,859.94 64,395.28 17
73,269.17 14,863 7,427.07 7,435.99 14,863.06 88,132.22 18
60,894.82 12,353 6,172.72 6,180.13 12,352.85 73,247.67 19
69,882.50 14,176 7,083.77 7,092.28 14,176.05 84,058.56
33,019.97 6,698 3,347.13 3,351.15 6,698.28 39,718.26
20,319.98 4,122 2,059.77 2,062.25 4,122.02 24,442.00
13,221.01 2,682 1,340.17 1,341.78 2,681.96 15,902.97
4,493.84 912 455.53 456.07 911.60 5,405.44
651,281.49 132,116 66,018.40 66,097.66 132,116.06

Retencione
Dev
Dev s (10%) Subtotal
Anticipo EP Retencione TOTAL
Anticipo (hasta el Ingresos
s
5%)
81,723.70 - 81,723.70 81,723.70
- 1,961.37 - 196.14 - 196.14 - 1,569.10 81,412.64
- 2,778.61 - 277.86 - 277.86 - 2,222.88 80,971.97
- 7,845.48 - 784.55 - 784.55 - 6,276.38 79,727.74
- 7,763.75 - 776.38 - 776.38 - 6,211.00 78,496.46
- 11,604.77 - 1,160.48 - 1,160.48 - 9,283.81 76,656.03
- 12,912.34 - 1,291.23 - 1,291.23 - 10,329.88 74,608.22
- 9,725.12 - 972.51 - 972.51 - 7,780.10 73,065.89
- 10,869.25 - 1,086.93 - 1,086.93 - 8,695.40 71,342.10
- 13,647.86 - 1,364.79 - 1,364.79 - 10,918.29 69,177.65
- 18,387.83 - 1,838.78 - 1,838.78 - 14,710.27 66,261.47
- 23,536.43 - 2,353.64 - 2,353.64 - 18,829.14 62,528.76
- 31,953.97 - 3,195.40 - 3,195.40 - 25,563.17 57,461.09
- 34,896.02 - 3,489.60 - 3,489.60 - 27,916.82 51,926.83
- 56,225.91 - 5,622.59 - 5,622.59 - 44,980.72 43,009.81
- 25,170.90 - 2,517.09 - 2,517.09 - 20,136.72 39,017.88
- 37,184.28 - 3,718.43 - 3,718.43 - 29,747.43 33,120.72
- 49,851.46 - 4,985.15 - 4,985.15 - 39,881.17 25,214.63
- 48,543.88 - 4,854.39 - 4,854.39 - 38,835.10 17,515.92
- 67,176.88 - 6,717.69 - 375.93 - 60,083.26 13,203.91
- 91,939.16 - 9,193.92 - - 82,745.25 7,816.93
- 76,411.66 - 7,641.17 - - 68,770.49 3,339.75
- 87,689.53 - 8,768.95 - 78,920.58 - 1,798.23
- 41,433.92 - 4,143.39 - 37,290.52 - 4,225.96
- 25,497.79 - 2,549.78 - 22,948.01 - 5,719.95
- 16,589.91 - 1,658.99 - 14,930.92 - 6,692.00
- 5,638.94 - 563.89 5,075.04 - 7,022.40
40,861.85 40,861.85 33,839.45
 5%
40,861.85
Monto Saldo
196.14 40,665.71
277.86 40,387.85
784.55 39,603.31
776.38 38,826.93
1,160.48 37,666.45
1,291.23 36,375.22
972.51 35,402.71
1,086.93 34,315.78
1,364.79 32,951.00
1,838.78 31,112.21
2,353.64 28,758.57
3,195.40 25,563.17
3,489.60 22,073.57
5,622.59 16,450.98
2,517.09 13,933.89
3,718.43 10,215.46
4,985.15 5,230.32
4,854.39 375.93
375.93 -
Según lo entregado visto en la tabla, se indica que con el pago de las retenciones desde el primer mes, se estaria
esta mandera, nos encontraríamos con un saldo negativo desde el mes 22 hasta el termino de obra, saldo negati
con la devolucion de las retenciones. este saldo negativo se saldaria solicitando un préstamos a 5 meses por 702
negativos. Desde ese punto de vista se podria concluir que este proyecto es viable siemopre y cuando al mes 22
financiamiento para terminar la obra. Dejando un delta de aproximadamente 33 mil UF a favor de la constructora,
en presupuesto original, pero viable de todos modos.
s desde el primer mes, se estaria pagando el 5% al mes 21º, de
el termino de obra, saldo negativo que se ajustaria al mes 27
un préstamos a 5 meses por 7022,4 UF, para ni tener saldos
e siemopre y cuando al mes 22 se busque una manera de
mil UF a favor de la constructora, un poco menos que lo estiùlado