calculo final cuna jardin.xlsx

7/25/2019 CALCULO FINAL CUNA JARDIN.xlsx

1/142

1,993

Poblacin

provincia atalaya 28,290

distrito de raymondi 18,341

T.C 3.16T.C 3.16

C!"#$ 200%

43,933

28,348

C!"#$

1993


2/142


3/142

2,007

43,933

28,348

T.C

3.16 &4,619

3.16 36,3&6 3&,243

36,3&6 3&,243

2,012 2,013 2,014

33,118 34,164 3&,243

C!"#$

200%

P'$(!CC)$"

*+ 201&


4/142

0 0 0

33,118 34,164 3&,243


5/142

S/. -5.0


6/142

1

*$ -*#!201& 2,016

36,356 37,505

Promedio :

Poblacin dearea de

inencia


7/142


8/142

2 3 4 5 6 7 8 9

$')/$"T! ! !*+*C)$"2,01% 2,018 2,019 2,020 2,021 2,022 2,023 2,024

38,690 39,912 41,173 42,474 43,815 45,200 46,627 48,100

43312 POBLADORES


9/142


10/142

10

2,02&

49,620


11/142

)5P'!#C)")-+! )5P'!#C)")-+!

5!)$"*5!"T*+ 01

Ade!"d" # S!$ie%&ei%'r"e(&r!&!r" )ed"*+*i",

"dmi%i(&r"&i" # om)eme%&"ri"

5!)$"*5!"T*+ 02

B!e% e(&"do de e!i)"mie%&o&e%o+*io # moii"rio )"r"

"mie%&e( ed!"&io(,"dmi%i(&r"&io( #om)eme%&"rio(


12/142


13/142

M.F. MUTUAMENTE

)5P'!#C)")-+!

EDODAEAL 01Ade!"d" # S!$ie%&e i%'r"e(&r!&!r"

)ed"*+*i", "dmi%i(&r"&i" #om)eme%&"ri"

RELACION DE COMPLE


14/142


15/142

OMPLEMENTARIOS

)5P'!#C)")-+!

EDODAEAL 02B!e% e(&"do de e!i)"mie%&o&e%o+*io # moii"rio )"r"

"mie%&e( ed!"&io(,"dmi%i(&r"&io( # om)eme%&"rio(

ENTARIEDAD


16/142


17/142

P+*"T!*5)!"T$ ! #$+C)$"

5.. 5T*5!"T! C$

)5P'!#C)")-+!

EDODAEAL 01Ade!"d" # S!$ie%&e i%'r"e(&r!&!r"

)ed"*+*i", "dmi%i(&r"&i" #om)eme%&"ri"

*ccin 1.1 o%(i(&e e% " Demoii+% de 7)"eo%e( # o%(&r!i+% de i%o o!e( %!eo(,

o% '!%i+% mi&" de !% (oo %ie, o% e %ie de)i(o &ermi%"do 0.15me&ro( )or e%im" de %ie de&erre%o %"&!r", !"&ro o!e( o% &eo de o(""i*er"d" de 0.20m de "&!r" # !% o!e o%&ier"e( de m"der" # &m)"%o( de o%re&o, &odo(o% oer&!r" " do( "*!"( # ieo( r"(o( de m"der"m"iemr"d" )"r" d"r o%'or& &;rmio " o("!m%o(. < " re'"i+% # meor"mie%&o de"mie%&e( de m=&i)e( !(o( e% 7 "!"( ei(&e%&e(


18/142

*ccin 1.2 o%(i(&e e% " Demoii+% de 7)"eo%e( # o%(&r!i+% de i%o o!e( %!eo(,o% '!%i+% mi&" de !% (oo %ie, o% e %ie de)i(o &ermi%"do 0.15me&ro( )or e%im" de %ie de&erre%o %"&!r", !"&ro o!e( o% &eo de o(""i*er"d" de 0.20m de "&!r" # !% o!e o%&ier"e( de m"der" # &m)"%o( de o%re&o, &odo(o% oer&!r" " do( "*!"( # ieo( r"(o( de m"der"m"iemr"d" )"r" d"r o%'or& &;rmio " o("!m%o(. < " re'"i+% # meor"mie%&o de"mie%&e( de m=&i)e( !(o( e% 7 "!"( ei(&e%&e(


19/142

# ( *+T!'"*T)*#7$%#16

5P+!5!"T*')$#

)5P'!#C)")-+!

EDODAEAL 02B!e% e(&"do de e!i)"mie%&o

&e%o+*io # moii"rio )"r" "mie%&e(ed!"&io(, "dmi%i(&r"&io( #

om)eme%&"rio(

*ccin 2.1 Ad!i(ii+% de moii"rio # e!i)o()"r" o( "mie%&e( ed!"&io(, "dmi%i(&r"&io( #

om)eme%&"rio(.


20/142


21/142

*CT))*!#

ase de inversin

5eses

0 1 2 3 4 &*#! ! )"!'#)$"

) !:pediente T;cnico

)) Costos directos

inastos >enerales

))) Prespesto de obra

) #pervisin

tilidad

*#! ! P$#T?)"!'#)$"

*$peracin y5antenimiento


22/142

ase de Post )nversin $peracin y

6 % 8

*$

1

*$

2

*$

3

*$

4

*$

&

*$

6


23/142

5antenimiento

*$

%

*$

8

*$

9

*$

10


24/142

2004 2005 2006 2007 2008 2009

200& 2006 200% 2008 2009 2010

0 *@os 0 0 0 2 0 01 *@o 20 8 18 14 20 142 *@os 36 35 35 31 31 403 *@os 72 44 71 81 84 574 *@os 78 73 75 90 111 90& *@os 78 87 77 75 98 95

T$T*+ 284 24% 2%6 293 344 296ente !=ipo Tecnico.

#!CC)$"!##!>A" !*


25/142

2010 2011 2012 2013 2014 2015

2011 2012 2013 2014 201& 2016

0 0 0 0 0 016 16 11 13 15 951 45 33 47 23 1965 66 78 54 49 7584 82 112 107 79 69

99 80 83 98 96 95

31& 289 31% 319 262 26%


26/142

200& 2006

0 *$# 0.00 0.00

1 *$ -0.60 1.252 *$# -0.03 0.003 *$# -0.39 0.614 *$# -0.06 0.03& *$# 0.12 -0.11

T$T*+ ?0.96 1.%8

E"or"io% )ro)i"!e%&e: E("e

0 ">o(PROEDO 1 ">o 0.03

2 ">o( -0.023 ">o( 0.054 ">o( 0.00

5 ">o( 0.03

C!"T'$!C*T)$ !+

*'!* !

)"+!"C)*

")!+!C*T)$

#!CC)$"!##!>A" !*

).!. "B 233#*"

'*"C)#C$! *##

)")C)*+C"*?

D*'"


27/142

*$#

200% 2008 2009 2010 2011 2012 2013 2014

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

-0.22 0.43 -0.30 0.14 0.00 -0.31 0.18 0.15-0.11 0.00 0.29 0.28 -0.12 -0.27 0.42 -0.510.14 0.04 -0.32 0.14 0.02 0.18 -0.31 -0.090.20 0.23 -0.19 -0.07 -0.02 0.37 -0.04 -0.26-0.03 0.31 -0.03 0.04 -0.19 0.04 0.18 -0.02

?0.02 1.01 ?0.&& 0.&3 ?0.32 0.01 0.43 ?0.%3


28/142

201& >'*$

0.00 0.00 0 *$#

-0.40 0.03 1 *$-0.17 -0.02 2 *$#0.53 0.05 3 *$#-0.13 0.00 4 *$#-0.01 0.03 & *$#

?0.18 0.02 T$T*+

0.00 E"or"io% )ro)i"!e%&e: E("e

PROEDO 326 0.02&

P'$5!)$T.C.

C!"T'$!C*T)$ !+

*'!* !)"+!"C)*

")!+

!C*T)$

).!. "B 233 #*"'*"C)#C$ !

*##

)")C)*+C"* ?

D*'"


29/142

1 2 3 4 5 6 7 8

*@o 2021

0 0 0 0 0 0 0 0 0

15 15 16 16 17 17 18 18 1926 25 25 24 24 23 23 23 2275 79 83 87 91 96 100 105 11180 80 81 81 81 82 82 83 8394 96 99 102 104 107 110 113 116

290 296 303 303 318 32& 333 342 3&0

*@o

2016

*@o

201%

*@o

2018

*@o

2019

*@o

2020

*@o

2022

*@o

2023

*@o

2024


30/142

9 10

0 0

19 2022 21

116 12283 84

119 122

3&9 369

0.225

*@o

202&

*@o

2026


31/142

>'*$ *@o 2016

0 *$# 0

1 *$ 15

2 *$# 263 *$# 75

4 *$# 80

& *$# 94T$T*+ 290

E"or"io% )ro)i"

!e%&e: E("e

2.50?

1.025

C!"T'$ !C*T)$ !+*'!* ! )"+!"C)*

")!+!C*T)$

).!. "B 233 #*"'*"C)#C$ ! *##

)")C)*+

C"* ?D*'"


32/142

*@o 201% *@o 2018 *@o 2019 *@o 2020 *@o 2021 *@o 2022

0 0 0 0 0 015 16 16 17 17 18

25 25 24 24 23 2379 83 87 91 96 10080 81 81 81 82 8296 99 102 104 107 110

296 303 310 318 32& 333

PERODO A@OS POBLAO0 2016 363561 2017 375062 2018 386913 2019 399134 2020 411755 2021 424766 2022 438187 2023 452038 2024 466319 2025 48105

10 2026 49625


33/142

*@o 2023 *@o 2024 *@o 202& *@o 2026

0 0 0 018 19 19 20

23 22 22 21105 111 116 12283 83 83 84

113 116 119 122342 3&0 3&9 369


34/142

82007 2015

De 5 " 9 "> 72 72De 10 " 14 " 64 64De 15 " 19 " 54 54De 20 " 24 " 27 27De 25 " 29 " 28 28De 30 " 34 " 29 29

De 35 " 39 " 33 33De 40 " 44 " 18 18De 45 " 49 " 18 18De 50 " 54 " 13 13De 55 " 59 " 19 19


35/142


36/142

1 2 3*$ -*#!

2016 2,01% 2,018 2,019

290 296 303 310

Promedio :

*$ -*#!2016 2,01% 2018 2,019

290 296 303 310

Poblacin dearea de

inencia

Poblacinestdiantil atendida

a lo larEo delForiGonte del

proyecto.


37/142

4 5 6 7 8 9 10$')/$"T! ! !*+*C)$"2,020 2,021 2,022 2,023 2,024 2,02& 2,026

318 325 333 342 350 359 369

331 ESDAES

$')/$"T! ! !*+*C)$"2020 2,021 2022 2,023 2024 2,02& 2026

318 325 333 342 350 359 369

3306 ESDAES


38/142

OFERTA O

Aula Area

1 aos A Deteriorado 15 2.002 aos A Deteriorado 10 2.002 aos B Deteriorado 2.00! aos A Deteriorado !" 1.2#! aos B Deteriorado !$ 1.2## aos A Deteriorado 1" 1.2## aos B Deteriorado 1$ 1.2## aos % Deteriorado 1$ 1.2#

# aos D Deteriorado 1$ 1.2#5 aos A Deteriorado !2 1.2#5 aos B Deteriorado !2 1.2#5 aos % Deteriorado !1 1.2#

273 o&"

OFERRe'urso O(erta o)ti*i+ada ,-

A*ietes 0Re'ursos u*aos 1313

Re'ursos (si'os 0Total 0

%3ADRO DE IDE

Ao Alu*os Area

1 aos A 15 $#2 aos A 1! 02 aos B 1! 5! aos A !" #2! aos B !$ #2# aos A 20 #$# aos B 20 #$# aos % 20 #$# aos D 20 #2

Estado delaula

6di'e*27alu*

Re'urso 8u*ao se9: 'a)a'idadesdo'etes


39/142

5 aos A !2 05 aos B !1 05 aos % !1 0

290

%i'lo Ao 201

%ua1 ao 152 aos 26Total 41

=ard

! aos 75# aos 805 aos 94Total 174

%i'lo Ao 201

%ua1 ao 02 aos 0Total 0

=ard! aos 0# aos 05 aos 0

Total Total 0

201 201$ 201"

#1 #1 #1

1$# 1$$ 1"0

0 0 0

%ua =ardN 2!!

%ua =ardN 2!!

De*ada'o )ro;e'to

%ua

De*ada'o )ro;e'to=ard

O(ertao)ti*i+ada

%ua


40/142

0 0 0

#1 #1 #1

1$# 1$$ 1"0

@olu*201 201$ 201"

41 41 41

0 0 0

41 41 41

O(ertao)ti*i+ada

=ard

- alu*osGue

de*adarHlos seri'ios

de los)ro;e'tos.

%ua

- alu*osGue

de*adarHlos seri'ios

de los

)ro;e'tos.=ard.

Alu*os Gue

de*adarHlos seri'iosde los

)ro;e'tos

%u)osdis)oilese el restode 'ole9iosdel Hrea deiue'ia

Seri'iosGueo(re'erH los

)ro;e'tosalteratios


41/142

@olu*201 201$ 201"

174 177 180

0 0 0

174 177 180

Alu*os Guede*adarH

los seri'iosde los)ro;e'tos

%u)osdis)oilese el restode 'ole9iosdel Hrea deiue'ia

Seri'iosGueo(re'erH los

)ro;e'tosalteratios


42/142

TIMIZADA DE AMBIENTES

Alu*os

15 $.50 0 01! .50 0 01! .50 0 0!" !0.5 0 0!$ 2."# 0 020 1.1! 0 020 1.1! 0 020 1.1! 0 0

20 1.1! 0 0!2 25."1 0 0!1 25.00 0 0!1 25.00 0 0

0 0

A OPTIMIZADA TOTA& lu*os/ O(erta o)ti*i+ada ,- se''ioes/

0131300

TIFI%A%ION DE 3SO DE AREAS PEDA4O4I%AS

%odi'io del a*iete Re'o*eda'i

#.! Malo De*oler #.2 Re9ular Re(a''ioar #.!1 Malo De*oler 1.11 Malo De*oler 1.1# Malo De*oler 2.!5 Re9ular Re(a''ioar 2.!5 Re9ular Re(a''ioar 2.!5 Malo De*oler 2.10 Re9ular Re(a''ioar

Desidad)or alu*o

O(erta o)ti*i+ada,alu*os/. N:*ero

*HJi*o de alu*os Gue'ada aula )odrH ateder.

O(ertao)ti*i+ada

,-se''ioes/

Desidad)or alu*o


43/142

1."" Re9ular Re(a''ioar 1.# Re9ular Re(a''ioar 1.# Re9ular Re(a''ioar

De*ada 'o )ro;e'to de la %ua < =ard201$ 201" 201 2020 2021

15 16 16 17 17

25 25 24 24 23

41 41 41 41 41

79 83 87 91 96

80 81 81 81 82

96 99 102 104 107

177 180 183 186 189

O(erta o)ti*i+ada de la %ua < =ard.201$ 201" 201 2020 2021

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

A&3MNOS >3E DEMANDAR?N &OS SER@I%IOS DE &OS PROE%TOS,MtodoC Eolu'i istri'a de la Matr'ula/.

201 2020 2021 2022 202!

#1 #1 #1 #1 #1

1"! 1" 1" 12 15

0 0 0 0 0


44/142

0 0 0 0 0

#1 #1 #1 #1 #1

1"! 1" 1" 12 15

de seri'ios Gue o(re'erH los )ro;e'tos alteratios ,%ua/201 2020 2021 2022 202!

41 41 41 41 41

0 0 0 0 0

41 41 41 41 41


45/142

de seri'ios Gue o(re'erH los )ro;e'tos alteratios ,=ard/201 2020 2021 2022 202!

183 186 189 192 195

0 0 0 0 0

183 186 189 192 195


46/142


47/142

2022 202! 202# 2025 202

18 18 19 19 20

23 23 22 22 21

41 41 41 41 41

100 105 111 116 122

82 83 83 83 84

110 113 116 119 122

192 195 199 202 205

2022 202! 202# 2025 202

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

202# 2025 202

#1 #1 #1

1 202 205

0 0 0


48/142

0 0 0

#1 #1 #1

1 202 205

202# 2025

41 41

0 0

41 41


49/142

202# 2025

199 202

0 0

199 202


50/142

!#C')PC)H"2016 201% 2018 2019

OERA 0 0 0 0DEADA 290 296 303 303

BALAE OO - DD -290 -296 -303 -303

")!+!C*T)$

AL A -ARDC

E"or"i+% )ro)i"


51/142

$')/$"T! ! !*+*C)H"

2020 2021 2022 2023 2024 202& 2026

0 0 0 0 0 0 0318 325 333 342 350 359 369

-318 -325 -333 -342 -350 -359 -369


52/142

META1: TRABAJOS PRELIMINARES

META 02: 6 AULAS+01 SALA PROFESORES+01 COCINA-COMEDOR EN PABELLONES N 02 Y N03

META 03: DIRECCIN, SUB DIRECCIN, SECRETARIA, TPICO Y PSICOLO!A

META 0": REFACCIN Y REMODELACIN DE 01 AULA PARA NI#OS CUNA DE 1 A 2 A#OS, 02 AULAS PARA NI#OS DE CUNA DE 2 A 3

META 0$: CONSTRUCCION DE LOSA MULTIDEPORTI%A &'20 M2(+CUBIERTA METALICA &)00 M2(+TRIBUNAS+ESCENARIO &*0 M2( - IN

META 06: CONSTRUCCIN DE CASETA DE FUERA + TANUE ELE%ADO + TANUE CISTERNA + 01 MDULO DE SER%ICIO IINIC

META 0': CONSTRUCCIN DE OBRAS E/TERIORES &CANALETAS, ACCESOS, JARDINERIAS, REDES ELCTRICAS(




META 0$: CONSTRUCCION DE LOSA MULTIDEPORTI%A &'20 M2(+CUBIERTA METALICA &)00 M2(+TRIBUNAS+ESCENARIO &*0 M2(

META 06: CONSTRUCCIN DE CASETA DE FUERA+TANUE ELE%ADO+TANUE CISTERNA+01 MDULO DE SER%ICIOS IINICO

META 0': CONSTRUCCIN DE OBRAS E/TERIORES &CANALETAS, ACCESOS, REDES ELCTRICAS(




ILUMINACIN DE LOA DEPORTI%A TECADA

ILUMINACIN ESCENARIO

CONSTRUCCION DE SER%ICIOS IIENICOS &1 MDULO(

ALIMENTADOR ENERAL A LOS PABELLONES

CONSTRUCCION DE CASETA TANUE ELE%ADO

ALIMENTADOR Y TABLERO ENERAL

REMPLAO NUE%O SUMINISTRO TRIFSICO

SISTEMA DE PARARRAYOS

RED PRIMARIA EN 10 - 22.) %. Y SUB ESTACIN COMPACTA *0 %A

OBRAS E/TERIORES




META 0$: CONSTRUCCIN DE LOSA MULTIDEPORTI%A &'20 M2(+CUBIERTA METLICA &)00 M2(+TRIBUNAS+ESCENARIO &*0 M2(

META 06: CONSTRUCCIN DE CASETA DE FUERA+TANUE ELE%ADO+TANUE CISTERNA+01 MDULO DE SER%ICIOS IINICO

COSTO DIRECTO

ASTOS ENERALES &12.2)2*6"* C.D.(

UTILIDAD &10.00 C.D.(


53/142

PRESUPUESTO TOTAL DE OBRAS CI%ILES

E/PEDIENTE TCNICO

SUPER%ISION DE OBRA

PRESUPUESTO TOTAL DE IN%ERSIN


54/142

33*,"6*.$$

"63,)*3.11

'*,))'.62

#OS Y 0" AULAS PARA NI#OS DE JARDIN DE 3 A 6 A#OS2,2)'.''

ICIAL1'*,61'.3'

O"$,)1).6$

60,")1.'1

"2*,33*.$'

11*,0"0.6*

#OS Y 0" AULAS PARA NI#OS DE JARDIN DE 3 A 6 A#OS21*,13).21

3)',)6'.*'

S*),36).**

2$,'03.26

'",*"3.*)

1),166.)"

#OS Y 0" AULAS PARA NI#OS DE JARDIN DE 3 A 6 A#OS10,3$*."2

31,$*3.)6

1*,"6).''

6,3*".21

"1,2*1.06

6,3)'.11

*,6)*.11

3,'"*.26

1",62$.3'

)2,0)".00

*,606.00

*6,16".'"

20,6'".1"

#OS Y 0" AULAS PARA NI#OS DE JARDIN DE 3 A 6 A#OS

"2,103.3"

',*23.3*

S22,33$.$6

2,)61,6)3.$1

3"$,1"*.)*

2)6,16).3$


55/142

",2$1,$$3.)'

123,*)$.00

1*2,'"'.00

",$$*,1)$.)'

4400720

2170030001500180

5401040336015003600900

16004000100036001400

70600500

36001000900

350024005200

15750210001760011000396002700

1%9460


56/142

PRESPESO DE RAESRRA

ABEES


57/142

m"&eri"e(e!i)o(


58/142




META 0": REFACCIN Y REMODELACIN DE 01 AULA PARA NI#OS CUNA DE 1 A 2 A#OS, 02 AULAS PARA NI#OS DE CUNA DE 2 A 3 A#OS Y 0" AULAS PARA NI#OS DE JARD

META 0$: CONSTRUCCION DE LOSA MULTIDEPORTI%A &'20 M2(+CUBIERTA METALICA &)00 M2(+TRIBUNAS+ESCENARIO &*0 M2( - INICIAL

META 06: CONSTRUCCIN DE CASETA DE FUERA + TANUE ELE%ADO + TANUE CISTERNA + 01 MDULO DE SER%ICIO IINICO











OBRAS E/TERIORES

COSTO DIRECTO



SUB TOTAL

IMPUESTOS I% &1*(


E/PEDIENTE TCNICO

SUPER%ISION DE OBRA



59/142

1,789,832.

1,610,372.367,942.

1,978,315.

1978315.


60/142

33*,"6*.$$1,0$3,330.31 1,053,330.31236,*').3* 236,879.38

2'2,*)*.'" 272,898.74

$*","0*.62 584,408.62

1$',62$.0) 157,625.09

*6,1)".)' 86,194.9731,$*3.)61*,"6).''

6,3*".21

"1,2*1.06

6,3)'.11

*,6)*.113,'"*.26

1",62$.3'

)2,0)".00

*,606.00

2,)61,6)3.$1 2,961,693.51 2,428,588.683"$,1"*.)* 364,076.982)6,16).3$ 296,169.35

3,603,011.*" 3,621,939.846"*,$"2.13 651,949.17

",2$1,$$3.)' 4,273,889.01123,*)$.00 123,798.791*2,'"'.00 148,084.68

",$$*,1)$.)' 4,545,772.48


61/142


62/142




META 0": REFACCIN Y REMODELACIN DE 01 AULA PARA NI#OS CUNA DE 1 A 2 A#OS, 02 AULAS PA

META 0$: CONSTRUCCION DE LOSA MULTIDEPORTI%A &'20 M2(+CUBIERTA METALICA &)00 M2(+TRIBU

META 06: CONSTRUCCIN DE CASETA DE FUERA + TANUE ELE%ADO + TANUE CISTERNA + 01 M

META 0': CONSTRUCCIN DE OBRAS E/TERIORES &CANALETAS, ACCESOS, JARDINERIAS, REDES EL




META 0$: CONSTRUCCION DE LOSA MULTIDEPORTI%A &'20 M2(+CUBIERTA METALICA &)00 M2(+TRIBU

12 META 06: CONSTRUCCIN DE CASETA DE FUERA+TANUE ELE%ADO+TANUE CISTERNA+01 MDU

META 0': CONSTRUCCIN DE OBRAS E/TERIORES &CANALETAS, ACCESOS, REDES ELCTRICAS(













OBRAS E/TERIORES




META 0$: CONSTRUCCIN DE LOSA MULTIDEPORTI%A &'20 M2(+CUBIERTA METLICA &)00 M2(+TRIBU

META 06: CONSTRUCCIN DE CASETA DE FUERA+TANUE ELE%ADO+TANUE CISTERNA+01 MDU

COSTO DIRECTO




63/142


E/PEDIENTE TCNICO

SUPER%ISION DE OBRA



64/142

33*,"6*.$$

310,00'.6$

'*,))'.62

A NI#OS DE CUNA DE 2 A 3 A#OS Y 0" AULAS PARA NI#OS DE JARDIN DE 3 A 6 A#OS2,2)'.''

AS+ESCENARIO &*0 M2( - INICIAL1'*,61'.3'

DULO DE SER%ICIO IINICO"$,)1).6$

CTRICAS(60,")1.'1

"2*,33*.$'

11*,0"0.6*

A NI#OS DE CUNA DE 2 A 3 A#OS Y 0" AULAS PARA NI#OS DE JARDIN DE 3 A 6 A#OS21*,13).21

AS+ESCENARIO &*0 M2(3)',)6'.*'

O DE SER%ICIOS IINICOS*),36).**

2$,'03.26

'",*"3.*)

1),166.)"

A NI#OS DE CUNA DE 2 A 3 A#OS Y 0" AULAS PARA NI#OS DE JARDIN DE 3 A 6 A#OS10,3$*."2

31,$*3.)6

1*,"6).''

6,3*".21

"1,2*1.06

6,3)'.11

*,6)*.11

3,'"*.26

1",62$.3'

)2,0)".00

*,606.00

*6,16".'"

20,6'".1"

A NI#OS DE CUNA DE 2 A 3 A#OS Y 0" AULAS PARA NI#OS DE JARDIN DE 3 A 6 A#OS

"2,103.3"

AS+ESCENARIO &*0 M2(',*23.3*

O DE SER%ICIOS IINICOS22,33$.$6

2,*0','1*.0$ 2,*0',

3"$,1"*.)*

2*0,''1.*1


65/142

",0$1,6)3.*3

123,*)$.00

1*2,'"'.00

",3$*,33$.*3

4400720

2170030001500180

5401040336015003600900

16004000100036001400

70600500

36001000900

350024005200

15750210001760011000396002700

179460


66/142

PRESPESO DE

LOS ABEES


67/142

m"&eri"e(e!i)o(


68/142




META 0": REFACCIN Y REMODELACIN DE 01 AULA PARA NI#OS CUNA DE 1 A 2 A#OS, 02 AULAS PARA NI#OS DE CUNA DE 2 A 3 A#OS Y 0" AULAS PARA NI#OS DE JARD

META 0$: CONSTRUCCION DE LOSA MULTIDEPORTI%A &'20 M2(+CUBIERTA METALICA &)00 M2(+TRIBUNAS+ESCENARIO &*0 M2( - INICIAL

META 06: CONSTRUCCIN DE CASETA DE FUERA + TANUE ELE%ADO + TANUE CISTERNA + 01 MDULO DE SER%ICIO IINICO











OBRAS E/TERIORES

COSTO DIRECTO



SUB TOTAL

IMPUESTOS I% &1*(


E/PEDIENTE TCNICO

SUPER%ISION DE OBRA



69/142

1,687,659.

1,508,199.363,153.

1,871,353.


70/142

33*,"6*.$$ 33*,"6*.$$*)),3$".*$ 899,354.85236,*').3* 236,879.38

2'2,*)*.'" 272,898.74

$*","0*.62 584,408.62

1$',62$.0) 157,625.09

*6,1)".)' 86,194.9731,$*3.)6 31,$*3.)61*,"6).'' 1*,"6).''

6,3*".21 6,3*".21

"1,2*1.06 "1,2*1.06

6,3)'.11 6,3)'.11

*,6)*.11 *,6)*.113,'"*.26 3,'"*.26

1",62$.3' 1",62$.3'

)2,0)".00 )2,0)".00

*,606.00 *,606.00

2,*0','1*.0$ 2,807,718.05 2,302,328.803"$,1"*.)* 345,148.982)6,16).3$ 280,771.81

3,603,011.*" 3,433,638.846"*,$"2.13 618,054.99

",2$1,$$3.)' 4,051,693.83123,*)$.00 123,895.001*2,'"'.00 182,747.00

",$$*,1)$.)' 4,358,335.83


71/142


72/142

01.02.

03.

04.

05.

06.

07.

08.

09.

10.

11.

12.

13.

14.

15.

16.

17.


73/142

01.

02.

03.

04.

05.

06.

07.

08.

09.

10.11.

12.

13.

14.15.

16.


74/142

17.


75/142

ALTERNATIVA 02 COSTOS A PRECIOS DE

'-'$

EA1: RABAOS PRELARES

EA 03: DRE, SB DRE, SEREARA, PO < PSOLOFCA

LA DE LOGA DEPORHA EIADA

LA ESEARO

OSRO DE SERHOS IFEOS J1 DLOK

ALEADOR FEERAL A LOS PABELLOES

OSRO DE ASEA AE ELEHADO

ALEADOR < ABLERO FEERAL

REPLAGO EHO SSRO RSO

SSEA DE PARARRA


76/142

ALTERNATIVA 01 COSTOS A PRECIOS DE

'-'$

EA1: RABAOS PRELARES

EA 03: DRE, SB DRE, SEREARA, PO < PSOLOFCA

LA DE LOGA DEPORHA EIADA

LA ESEARO

OSRO DE SERHOS IFEOS J1 DLOKALEADOR FEERAL A LOS PABELLOES

OSRO DE ASEA AE ELEHADO

ALEADOR < ABLERO FEERAL

REPLAGO EHO SSRO RSO

SSEA DE PARARRA


77/142

OBRAS ENERORES

C$#T$ )'!CT$FASOS FEERALES J12.2928648? DKLDADES J10?K

#- T$T*+PESO FEERAL A LAS HEAS J18?KENPEDEE EOSPERHS

)"!'#)$" T$T*+ * P'!C)$# ! 5!'C*$


78/142

MERCADO

5!T'*$

338,468.55 1,053,330.31

236,879.38

272,898.74

584,408.62

157,625.09

86,194.97

31,583.96

18,469.77

6,384.21

41,281.06

6,397.11

8,698.11

3,748.26

14,625.37

92,094.00

8,606.00 2,961,693.&1

345,148.98296,169.35

3,603,011.84

648,542.13123,895.00182,747.00

4,&&8,19&.9%

1.00

C$#T$# * P'!C)$#! 5!'C*$

PRESPESOK, do%de (edo )or "d"


79/142

2.003.00

4.005.00

6.007.00)"

!l C, >>, tilida

MERCADO

5!T'*$

338,468.55

899,354.85

236,879.38

272,898.74

584,408.62

157,625.09

86,194.97

31,583.96

18,469.77

6,384.2141,281.06

6,397.11

8,698.11

3,748.2614,625.37

92,094.00

C$#T$# * P'!C)$#! 5!'C*$

PRESPESO1K, do%de (edo )or "d"


80/142

8,606.00 2,80%,%18.0&

345,148.98280,771.81

3,433,638.84618,054.99123,895.00182,747.00

4,3&8,33&.83

1.00

2.003.004.005.00

6.007.00


81/142

C$#T$# * P'!C)$# #$C)*+!#

'-'$

OSO DREO 2,961,693.51

C$#T$# * P'!C)$#! 5!'C*$


82/142

"&eri"e( 1,%89,832.60E!i)o # Ierr"mie%&"( 366,922.84"%o de or" "i$"d" 537,530.82"%o de or" %o "i$"d" 266,069.84FASOS FEERALES 345,148.98LDADES J10? DK 296,169.35

SB OAL 3,603,011.84PESO FEERAL A LAS HEAS J18?K 648,542.13PRESPESO OAL DE OBRA 4,251,553.97ENPEDEE EO 123,895.00SPERHO DE OBRA 182,747.00'#)$" T$T*+ * P'!C)$# ! 5!'C*$ 4,&&8,19&.9%

estan inclido )>

C$#T$# * P'!C)$# #$C)*+!#


83/142

2,80%,%18.0&

4,3&8,33&.83

4,3&8,142.84

192.99

'-'$

OSO DREO 2,807,718.05"&eri"e( 1,68%,6&9.9%E!i)o # Ierr"mie%&"( 363,311.09"%o de or" "i$"d" 499,829.20"%o de or" %o "i$"d" 256,917.79FASOS FEERALES 345,148.98LDADES J10? DK 280,771.81SB OAL 3,433,638.84PESO FEERAL A LAS HEAS J18?K 618,054.99PRESPESO OAL DE OBRA 4,051,693.83ENPEDEE EO 5? 123,895.00SPERHO DE OBRA 7? 182,747.00)"!'#)$" T$T*+ * P'!C)$# ! 5!'C*$ 4,3&8,33&.83

'-'$ *+T!'"*T)* 1OSO DREO 2,807,718.05"&eri"e( 1,68%,6&9.9%E!i)o # Ierr"mie%&"( 363,311.09"%o de or" "i$"d" 499,829.20

"%o de or" %o "i$"d" 256,917.79FASOS FEERALES 345,148.98LDADES J10? DK 280,771.81SB OAL 3,433,638.84PESO FEERAL A LAS HEAS J18?K 618,054.99PRESPESO OAL DE OBRA 4,051,693.83ENPEDEE EO 5? 123,895.00SPERHO DE OBRA 7? 182,747.00)"!'#)$" T$T*+ * P'!C)$# ! 5!'C*$ 4,3&8,33&.83

C$#T$# * P'!C)$#! 5!'C*$


84/142

2,483,011.37

*CT$' !C$''!CC)H"

C$#T$# * P'!C)$##$C)*+!#


85/142

0.84% 1515988.2122 0.847 310783.64548 0.909 488615.51538 0.630 167623.9992 0.847 292341.18606 0.909 269217.93915

3,044,570.50548,022.693,592,593.19

0.909 112,620.560.909 166,117.02

3,8%1,330.%%


86/142

1%9,460.00

192.99

1%9,6&2.99

2,353,375.440.84% 1429447.99459

0.847 307724.49323 0.909 454344.7428 0.630 161858.2077 0.847 292341.18606 0.909 255221.570745

2,900,938.20522,168.88

3,423,107.070.909 112,620.560.909 166,117.02

3,%01,844.6&

2,961,693.511,%89,832.60

366,922.84537,530.82

266,069.84345,148.98296,169.35

3,603,011.84648,542.13

4,251,553.97123,895.00182,747.00

4,&&8,19&.9%

*CT$' !C$''!CC)H"

C$#T$# * P'!C)$##$C)*+!#

*+T!'"*T)*2


87/142

S/P

)T!5 C$"C!PT$ ". C*"T. 5!#!#

$P!'*C)H"

1 'emneracion al personalirectorIPro


88/142

Pa@os 52 4 12

2 5aterial de 5antenimiento 12

Pintra en Peredes >ls 1 12

Pintra en 5adera >ls 2 12

Pintra 5etalica >ls 1 12

idrios 52 1 12

'eparaciones >enerales >ls 2 12

T$T*+


89/142

.C.

234,600.00 0.00 213,4&0.00

234,000.00 212,940.001&00 19&00 234,000.00 0.91 212,940.00

600.00 &10.00

0 0 0.00 0.8& 0.00

&0 &0 600.00 0.8& &10.00

2,%21.60 0.8& 2,313.36

429.60 36&.16

&.4 &.4 64.80 0.8& &&.08

10 10 120.00 0.8& 102.00

1& 1& 180.00 0.8& 1&3.00

2.% &.4 64.80 0.8& &&.08

0 2,292.00 0.8& 1,948.20

20 20 240.00 0.8& 204.00

3& %0 840.00 0.8& %14.00

2& 2& 300.00 0.8& 2&&.00

6 6 %2.00 0.8& 61.20

3& %0 840.00 0.8& %14.00

23%,321.60 21&,%63.36

.C.

234,600.00 213,4&0.00

234,000.00 212,940.00

1&00 19&00 234,000.00 0.91 212,940.00

600.00 &10.000 0 0.00 0.8& 0.00

&0 &0 600.00 0.8& &10.00

3,086.40 2,623.44

%94.40 6%&.24

&.4 &.4 64.80 0.8& &&.08

10 20 240.00 0.8& 204.00

1& 30 360.00 0.8& 306.00

C$#T$5!"#*+

T$T*+5!"#*+

T$T*+ *"*+P'!C)$

P')*$

T$T*+ *"*+P'!C)$ #$C)*+

C$#T$5!"#*+

T$T*+5!"#*+

T$T*+ *"*+P'!C)$

P')*$

T$T*+ *"*+P'!C)$ #$C)*+


90/142

2.% 10.8 129.60 0.8& 110.16

0 2,292.00 0.8& 1,948.20

20 20 240.00 0.8& 204.00

3& %0 840.00 0.8& %14.00

2& 2& 300.00 0.8& 2&&.00

6 6 %2.00 0.8& 61.20

3& %0 840.00 0.8& %14.00

23%,686.40 216,0%3.44


91/142

0.847457627


92/142


93/142

)T!5

A

1.00

2.00

3.004.00

-

C

)T!5

A

1.00

2.00

3.00

4.00-


94/142

C

)T!5

A

01.

02.

03.

05.

07.

08.

-

C

)T!5

A

01.

02.

03.

05.

07.

08.

-

C


95/142


96/142


97/142

!#C')PC)$"

C$#T$ T$T*+ ! +* )"!'#)$"

OSO DREO

"&eri"e(

E!i)o # Ierr"mie%&"(

"%o de or" "i$"d"

"%o de or" %o "i$"d"

FASOS FEERALES

LDADES J10? DK

PESO JFHK

C$#T$ ! $P!'*C)H" ( 5*"T!")5)!"T$ CI P'$(!CT$

C$#T$ ! $P!'*C)H" ( 5*"T!")5)!"T$ #I P'$(!CT$

C$#T$# )"C'!5!"T*+!# KC?L

!#C')PC)$"

C$#T$ T$T*+ ! +* )"!'#)$"

OSO DREO

"&eri"e(


"%o de or" "i$"d"


FASOS FEERALES

LDADES J10? DK

PESO JFHKC$#T$ ! $P!'*C)H" ( 5*"T!")5)!"T$ CI P'$(!CT$


98/142

C$#T$ ! $P!'*C)H" ( 5*"T!")5)!"T$ #I P'$(!CT$

C$#T$# )"C'!5!"T*+!# KC?L

!#C')PC)$"

C$#T$ T$T*+ ! +* )"!'#)$"

OSO DREO

"&eri"e(


"%o de or" "i$"d"


PESO JFHK

C$#T$ ! $P!'*C)H" ( 5*"T!")5)!"T$ CI P'$(!CT$

C$#T$ ! $P!'*C)H" ( 5*"T!")5)!"T$ #I P'$(!CT$

C$#T$# )"C'!5!"T*+!# KC?L

!#C')PC)$"

C$#T$ T$T*+ ! +* )"!'#)$"

OSO DREO

"&eri"e(


"%o de or" "i$"d"


PESO JFHK

C$#T$ ! $P!'*C)H" ( 5*"T!")5)!"T$ CI P'$(!CT$

C$#T$ ! $P!'*C)H" ( 5*"T!")5)!"T$ #I P'$(!CT$

C$#T$# )"C'!5!"T*+!# KC?L


99/142


100/142


101/142

OSOS REEALES A PREOS PRHAD0 1 2 3

4,3&8,33&.83

2,807,718.05

1,687,659.97

363,311.09

499,829.20

256,917.79

345,148.98

280,771.81

618,054.99

237,686.40 237,686.40 237,686.40

237,321.60 237,321.60 237,321.60

4,3&8,33&.83 364.80 364.80 364.80

HA S/. 4,360,676.99

OSOS REEALES A PREOS PRHAD

0 1 2 3

4,&&8,19&.9%

2,961,693.51

1,789,832.60

366,922.84

537,530.82

266,069.84

345,148.98

296,169.35

648,542.13237,686.40 237,686.40 237,686.40


102/142

237,321.60 237,321.60 237,321.60

4,&&8,19&.9% 364.80 364.80 364.80

HA S/. 4,560,537.13

OSOS REEALES A PREOS SOAL0 1 2 3

3,%01,844.6&

2,353,375.44

1,429,447.99

307,724.49

454,344.74

161,858.21

522,168.88

216,073.44 216,073.44 216,073.44

215,763.36 215,763.36 215,763.36

3,%01,844.6& 310.08 310.08 310.08

HA S/. 3,703,834.64

OSOS REEALES A PREOS SOAL0 1 2 3

3,8%1,330.%%

2,483,011.37

1,515,988.21

310,783.65

488,615.52

167,624.00

548,022.69

216,073.44 216,073.44 216,073.44

215,763.36 215,763.36 215,763.36

3,8%1,330.%% 310.08 310.08 310.08

HA S/. 3,873,320.75


103/142


104/142


105/142

S - PRO


106/142

237,321.60 237,321.60 237,321.60 237,321.60

364.80 364.80 364.80 364.80

S - PRO


107/142


108/142


109/142

8 9 10

237,686.40 237,686.40 237,686.40

237,321.60 237,321.60 237,321.60

364.80 364.80 364.80

8 9 10

237,686.40 237,686.40 237,686.40


110/142

237,321.60 237,321.60 237,321.60

364.80 364.80 364.80

8 9 10

216,073.44 216,073.44 216,073.44

215,763.36 215,763.36 215,763.36

310.08 310.08 310.08

8 9 10

216,073.44 216,073.44 216,073.44

215,763.36 215,763.36 215,763.36

310.08 310.08 310.08


111/142


112/142


113/142


114/142

*')*-+!# !+ P'$(!CT$*+T!'"

1

*+$' *CT*+ ! C$#T$ #$C)*+!# K*C#L #I. 3,%03,834.64


115/142

*"*+)#)# C$#T$ !!CT))*'bro *lternativa 1

o(&o &o&" de " %er(io% )reio( )ri"do( S/. 4,358,335.83

o(&o &o&" de " %er(io% )reio( (oi"e( S/. 3,701,844.65"(" (oi" de De(!e%&o 9H"or A&!" de o(&o( o&"e( S/. 3,703,834.64

E Po"io% Be%e$i"ri" 3,306o(&o E'e&iid"d J/EK S/. 1,120.34o(&o )or I"i&"%&e Dire&"me%&e Be%e$i"do S/. 1,318.31


116/142


117/142


118/142

T)*#

2

#I. 3,8%3,320.%&


119/142

*lternativa 2S/. 4,558,195.97

S/. 3,871,330.77

2636S/. 3,873,320.75

3,306 330.60S/. 1,171.60 26,360.00S/. 1,378.76


120/142


121/142


122/142


123/142


124/142


125/142


126/142


127/142


128/142


129/142


130/142


131/142


132/142

449,480.63203,289.14

168,408.66

190,561.76346,898.16

48,270.00

4,000.00

-141,090.84112,872.67

7,054.5420,379.5867,931.9213,586.38


133/142


134/142


135/142


136/142


137/142

Anlisis del Costo de Inversin

RESULTADOS DEL ANLISIS DE SENSPRECIOS SOCIAL

ALTENATIVA N"01

VACT S IE C#E

8.00% 3,230,604 2,670 1,209.96

$%&'( 3,128,181 2,670 1,171.60

1.04576 5.00% 3,140,865 2,670 1,176.35

$%&)*( 4.00% 3,110,952 2,670 1,165.15

3.00% 3,081,039 2,670 1,153.95

2.00% 3,051,126 2,670 1,142.74

0( 2+,,1+-00 2+*)0 1+120%-$

-2.00% 2,931,474 2,670 1,097.93

-3.00% 2,901,561 2,670 1,086.73

0.95624 -4.00% 2,871,648 2,670 1,075.52

.$%-)*( -5.00% 2,841,735 2,670 1,064.32

.$%-'( 2,860,409 2,670 1,071.31

-8.0% 2,751,996 2,670 1,030.71

Sensibilidad de la Alternativa 1 con Respecto a la Alternativa 2

Sensibilidad del costo de inves Anlisis de Sensi/ilidd

Alterntiv 1

Vriin (

Indidor C#E

Alterntiv 1 Alterntiv 2

8.00% 1,209.96 1,171.60

4.58% 1,171.60 1,171.60

5.00% 1,176.35 1,171.60

4.00% 1,165.15 1,171.60

3.00% 1,153.95 1,171.60

1.04576 2.00% 1,142.74 1,171.60

4.576% 0% 1,120.34 1,171.60

-2.00% 1,097.93 1,171.60

-3.00% 1,086.73 1,171.60

-4.00% 1,075.52 1,171.60

-5.00% 1,064.32 1,171.60

-4.38 1,071.31 1,171.60

-8.00% 1,030.71 1,171.60

1,171.60

( vriin de l et iniil 4.58%!"ente# !l"$o de costos del o&ecto

Vr (Inversin

Intersein de l Alterntiv 1 on lAlterntiv 2


138/142

8.00% 4.58% 5.00% 4.00% 3.00% 2.00% 0.00% -2.00%

900.00

950.00

1,000.00

1,050.00

1,100.00

1,150.00

1,200.00

1,250.00

1,171.60

ANALISIS DE SENSIBILIDAD DE LA ALTERNATI%A 1 CON RESPECTO A L

ALTERNATIVA N1 ALTE

*')*C)H" KL

INDICADOR ( C/E)


139/142

I!ILIDADS

'SC'()*+SALTENATIVA N"02

VACT S IE C#E

923,692 730 1,265.33

P++S)

894,407 730 1,225.22

898,034 730 1,230.18

889,481 730 1,218.47

880,929 730 1,206.75

872,376 730 1,195.04

'&&+2)0 )-0 1+1)1%*0 '+

838,165 730 1,148.17

P'S++S)

829,612 730 1,136.46

821,060 730 1,124.74

812,507 730 1,113.02

817,846 730 1,120.34

786,849 730 1,077.88

Sensibilidad de la Alternativa 2 con Respe

Anlisis de Sensi/ilid

Alterntiv 2

Vriin (

Indi

Alterntiv 1

8.00% 1,120.34

4.58% 1,120.34

5.00% 1,120.34

4.00% 1,120.34

3.00% 1,120.34

0.95624 2.00% 1,120.34

-4.38% 0% 1,120.34

-2.00% 1,120.34

-3.00% 1,120.34

-4.00% 1,120.34

-5.00% 1,120.34

-4.38% 1,120.34

-8.00% 1,120.34

( vriin de l et iniil!"ente# !l"$o de costos del o&ecto

Intersein de l Alterntiv 2 on lAlterntiv 1


140/142

-3.00% -4.00% -5.00% -4.38% -8.00%

ALTERNATI%A 2

RNATIVA N2

8 .00 % 4.5 8% 5.0 0% 4 .0 0%

950.00

1,000.00

1,050.00

1,100.00

1,150.00

1,200.00

1,250.00

1,300.00

ANALISIS DE SENSIBILIDAD DE LA A

INDICADOR (C/E)


141/142

cto a la Alternativa 1

d

or C#E

Alterntiv 2

1,265.33

1,225.22

1,230.18

1,218.47

1,206.75

1,195.04

1,171.60

1,148.17

1,136.46

1,124.74

1,113.02

1,120.34

1,077.88

1,120.34

-4.38%


142/142

3.00% 2.00% 0.00% -2.00% -3.00% -4.00% -5.00% -4.38% -8.00%

1,120.34

TERNATI%A 2 CON RESPECTO A LA ALTERNATI%A 1

LTERNATIVA N 1 ALTERNATIVA N 2

*')*C)H" KL

calculo final cuna jardin.xlsx

Documents