Scribd Logo
Upload

Welcome to Scribd!

  • 33 views

    Excel Phusca

    Uploaded by

    Yeims Lozano
    This document contains population and production data for Usicayos, Peru from 2013 to 2033. It shows that the population is projected to increase from 813 people in 2013 to 6,052 people in 2033, with an annual growth rate of 10.56%. Livestock production of alpacas, llamas, and sheep is also projected to increase each year to match the growing population's consumption needs. The document also outlines current and projected traffic patterns both without and with a proposed new bridge and flood defense wall infrastructure project.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Excel Phusca

    Uploaded by

    Yeims Lozano
    33 views26 pages
    This document contains population and production data for Usicayos, Peru from 2013 to 2033. It shows that the population is projected to increase from 813 people in 2013 to 6,052 people in 2033, with an annual growth rate of 10.56%. Livestock production of alpacas, llamas, and sheep is also projected to increase each year to match the growing population's consumption needs. The document also outlines current and projected traffic patterns both without and with a proposed new bridge and flood defense wall infrastructure project.

    Original Description:

    fgdfgdfg

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains population and production data for Usicayos, Peru from 2013 to 2033. It shows that the population is projected to increase from 813 people in 2013 to 6,052 people in 2033, with an annual growth rate of 10.56%. Livestock production of alpacas, llamas, and sheep is also projected to increase each year to match the growing population's consumption needs. The document also outlines current and projected traffic patterns both without and with a proposed new bridge and flood defense wall infrastructure project.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    33 views26 pages

    Excel Phusca

    Uploaded by

    Yeims Lozano
    This document contains population and production data for Usicayos, Peru from 2013 to 2033. It shows that the population is projected to increase from 813 people in 2013 to 6,052 people in 2033, with an annual growth rate of 10.56%. Livestock production of alpacas, llamas, and sheep is also projected to increase each year to match the growing population's consumption needs. The document also outlines current and projected traffic patterns both without and with a proposed new bridge and flood defense wall infrastructure project.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 26

    POBLACION HABITANTES

    AO

    POBLACION HABITANTES

    % TASA DE CRECIMIENTO(INEI 2007)

    2007

    445

    0.1056

    46.992

    2008

    492

    0.1056

    51.9543552

    2009

    544

    0.1056

    57.4407351091

    2010

    601

    0.1056

    63.5064767366

    2011

    665

    0.1056

    70.21276068

    2012

    735

    0.1056

    77.6272282078

    2013

    813

    0.1056

    85.8246635066

    2014

    899

    0.1056

    94.8877479729

    2015

    993

    0.1056

    104.9078941588

    2016

    1098

    0.1056

    115.986167782

    2017

    1214

    0.1056

    128.2343070998

    2018

    1343

    0.1056

    141.7758499295

    2019

    1484

    0.1056

    156.7473796821

    2020

    1641

    0.1056

    173.2999029765

    2021

    1814

    0.1056

    191.6003727308

    2022

    2006

    0.1056

    211.8333720912

    2023

    2218

    0.1056

    234.202976184

    2024

    2452

    0.1056

    258.9348104691

    2025

    2711

    0.1056

    286.2783264546

    2026

    2997

    0.1056

    316.5093177282

    2027

    3314

    0.1056

    349.9327016803

    2028

    3664

    0.1056

    386.8855949777

    2029

    4051

    0.1056

    427.7407138074

    2030

    4478

    0.1056

    472.9101331854

    2031

    4951

    0.1056

    522.8494432498

    2032

    5474

    0.1056

    578.062344457

    2033

    6052

    0.1056

    639.1057280316

    DEMANDA DE PEATONES
    PERIODO

    AO

    POBLACION BENEFICIARIA

    2013

    813

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20

    2014

    899

    2015

    993

    2016

    1098

    2017

    1214

    2018

    1343

    2019

    1484

    2020

    1641

    2021

    1814

    2022

    2006

    2023

    2218

    2024

    2452

    2025

    2711

    2026

    2997

    2027

    3314

    2028

    3664

    2029

    4051

    2030

    4478

    2031

    4951

    2032

    5474

    2033

    6052

    N DE FAMILIAS

    N familias/ 1 jefe de
    familia

    98
    108
    120
    132
    146
    162
    179
    198

    22
    24
    26
    29
    32
    36
    39
    44

    219
    242
    267
    296
    327
    361
    400
    442
    488
    540
    597
    660
    730
    807
    892
    986
    1090
    1206
    1333

    48
    53
    59
    65
    72
    80
    88
    97
    108
    119
    131
    145
    161
    178
    196
    217
    240
    265
    294

    tem

    Principales
    especies

    Kg/ao

    Consumo per cpita


    Kg/ao

    Alpacas

    0.38

    Llama

    0.56

    Ovino

    0.49

    ALPACAS
    AO

    POBLACION

    Alpacas (Tn/ao)

    2014

    899

    0.00038

    2015

    993

    0.00038

    2016

    1098

    0.00038

    2017

    1214

    0.00038

    2018

    1343

    0.00038

    2019

    1484

    0.00038

    2020

    1641

    0.00038

    2021

    1814

    0.00038

    2022

    2006

    0.00038

    2023

    2218

    0.00038

    2024

    2452

    0.00038

    2025

    2711

    0.00038

    2026

    2997

    0.00038

    2027

    3314

    0.00038

    2028

    3664

    0.00038

    2029

    4051

    0.00038

    2030

    4478

    0.00038

    2031

    4951

    0.00038

    2032

    5474

    0.00038

    2033

    6052

    0.00038

    IMD- USICAYOS
    Tipo de Vehculo

    LUNES

    MARTES

    MIERCOLES

    JUEVES

    VIERNES

    BICICLETA

    MOTO

    AUTOMOVIL

    CAMIONETA

    C.R.

    MICRO

    BUS-GRANDE

    CAMION 2E

    CAMION 3E

    TOTAL

    onsumo per cpita

    Poblacin
    afectada ao
    2013

    Gr/da

    Consumo total
    Kg/ao

    Gr/da

    389

    813

    308

    308.94

    561

    813

    455

    455.28

    489

    813

    398

    398.37

    308.94

    LLAMAS
    Produccion
    Alpacas
    (Tn/ao)

    AO

    POBLACION

    Llamas (Tn/ao)

    Produccion
    Llamas
    (Tn/ao)

    0.34

    2014

    899

    0.00056

    0.50

    0.38

    2015

    993

    0.00056

    0.56

    0.42

    2016

    1098

    0.00056

    0.62

    0.46

    2017

    1214

    0.00056

    0.68

    0.51

    2018

    1343

    0.00056

    0.75

    0.56

    2019

    1484

    0.00056

    0.83

    0.62

    2020

    1641

    0.00056

    0.92

    0.69

    2021

    1814

    0.00056

    1.02

    0.76

    2022

    2006

    0.00056

    1.12

    0.84

    2023

    2218

    0.00056

    1.24

    0.93

    2024

    2452

    0.00056

    1.37

    1.03

    2025

    2711

    0.00056

    1.52

    1.14

    2026

    2997

    0.00056

    1.68

    1.26

    2027

    3314

    0.00056

    1.86

    1.39

    2028

    3664

    0.00056

    2.05

    1.54

    2029

    4051

    0.00056

    2.27

    1.70

    2030

    4478

    0.00056

    2.51

    1.88

    2031

    4951

    0.00056

    2.77

    2.08

    2032

    5474

    0.00056

    3.07

    2.30

    2033

    6052

    0.00056

    3.39

    SABADO

    DOMINGO

    OVINOS
    AO

    POBLACION

    Ovinos (Tn/ao)

    Produccion Ovinos
    (Tn/ao)

    2014

    899

    0.00049

    0.44

    2015

    993

    0.00049

    0.49

    2016

    1098

    0.00049

    0.54

    2017

    1214

    0.00049

    0.60

    2018

    1343

    0.00049

    0.66

    2019

    1484

    0.00049

    0.73

    2020

    1641

    0.00049

    0.80

    2021

    1814

    0.00049

    0.89

    2022

    2006

    0.00049

    0.98

    2023

    2218

    0.00049

    1.09

    2024

    2452

    0.00049

    1.20

    2025

    2711

    0.00049

    1.33

    2026

    2997

    0.00049

    1.47

    2027

    3314

    0.00049

    1.62

    2028

    3664

    0.00049

    1.80

    2029

    4051

    0.00049

    1.98

    2030

    4478

    0.00049

    2.19

    2031

    4951

    0.00049

    2.43

    2032

    5474

    0.00049

    2.68

    2033

    6052

    0.00049

    2.97

    TOTAL-USICAYOS
    AO

    POBLACION

    Produccion Alpacas
    (Tn/ao)

    Produccion Llamas
    (Tn/ao)

    Produccion Ovinos
    (Tn/ao)

    2014

    899

    0.34

    0.50

    0.44

    2015

    993

    0.38

    0.56

    0.49

    2016

    1098

    0.42

    0.62

    0.54

    2017

    1214

    0.46

    0.68

    0.60

    2018

    1343

    0.51

    0.75

    0.66

    2019

    1484

    0.56

    0.83

    0.73

    2020

    1641

    0.62

    0.92

    0.80

    2021

    1814

    0.69

    1.02

    0.89

    2022

    2006

    0.76

    1.12

    0.98

    2023

    2218

    0.84

    1.24

    1.09

    2024

    2452

    0.93

    1.37

    1.20

    2025

    2711

    1.03

    1.52

    1.33

    2026

    2997

    1.14

    1.68

    1.47

    2027

    3314

    1.26

    1.86

    1.62

    2028

    3664

    1.39

    2.05

    1.80

    2029

    4051

    1.54

    2.27

    1.98

    2030

    4478

    1.70

    2.51

    2.19

    2031

    4951

    1.88

    2.77

    2.43

    2032

    5474

    2.08

    3.07

    2.68

    2033

    6052

    2.30

    3.39

    2.97

    TOTAL PRODUCCION
    PECUARIA(Tn/ao)

    1.28
    1.42
    1.57
    1.74
    1.92
    2.12
    2.35
    2.59
    2.87
    3.17
    3.51
    3.88
    4.29
    4.74
    5.24
    5.79
    6.40
    7.08
    7.83
    8.65

    TIPO DE VEHICULO S/PROYECTO


    AOS

    TRAFICO NORMAL

    BICICLETA

    MOTO

    AUTOMOVIL

    CAMIONETA

    MICRO

    BUS GRANDE

    0
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20

    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
    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
    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

    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
    0
    0
    0
    0
    0
    0
    0

    TIPO DE VEHICULO C/ PROYECTO


    AOS

    TRAFICO NORMAL

    BICICLETA

    MOTO

    AUTOMOVIL

    CAMIONETA

    MICRO

    BUS GRANDE

    0
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11

    0
    5
    6
    8
    11
    13
    16
    19
    21
    21
    23
    25

    0
    2
    2
    2
    2
    2
    2
    2
    2
    2
    2
    2

    0
    3
    4
    5
    7
    9
    11
    13
    15
    15
    16
    18

    0
    0
    0
    1
    1
    1
    1
    1
    1
    1
    1
    1

    0
    0
    0
    0
    1
    1
    1
    2
    2
    2
    2
    2

    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    1
    1

    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    12
    13
    14
    15
    16
    17
    18
    19
    20

    26
    28
    29
    31
    34
    36
    37
    39
    41

    2
    2
    2
    2
    2
    2
    2
    2
    2

    19
    21
    22
    24
    25
    27
    28
    30
    31

    1
    1
    1
    1
    2
    2
    2
    2
    3

    2
    2
    2
    2
    3
    3
    3
    3
    3

    1
    1
    1
    1
    1
    1
    1
    1
    1

    0
    0
    0
    0
    0
    0
    0
    0
    0

    OYECTO
    CAMION 2E

    CAMION 3E

    TOTAL

    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
    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

    CAMION 2E

    CAMION 3E

    TOTAL

    0
    0
    0
    0
    0
    0
    1
    1
    1
    1
    1
    1

    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    0
    5
    6
    8
    11
    13
    16
    19
    21
    21
    23
    25

    OYECTO

    1
    1
    1
    1
    1
    1
    1
    1
    1

    0
    0
    0
    0
    0
    0
    0
    0
    0

    26
    28
    29
    31
    34
    36
    37
    39
    41

    ITEM

    DESCRIPCION
    COSTO DIRECTO

    PUENTE CARROZABLE SOBRE VIGA DE 25.00M


    MANO DE OBRA CALIFICADA
    MANO DE OBRA NO CALIFICADA
    INSUMOS

    MURO DE ENCAUSAMIENTO Y DEFENSA RIBEREA


    MANO DE OBRA CALIFICADA
    MANO DE OBRA NO CALIFICADA
    INSUMOS

    PLAN AMBIENTAL
    MANO DE OBRA CALIFICADA
    MANO DE OBRA NO CALIFICADA
    INSUMOS
    EXPEDIENTE TECNICO
    SUPERVISION
    GASTOS GENERALES
    GASTOS DE LIQUIDACION
    TOTAL PRESUPUESTO

    ALTERNATIVA 01

    FACTOR DE

    ALTERNATIVA 01

    TOTAL A PRECIOS DE MERCADO (S/.)

    CORRECCION

    TOTAL A PRECIOS SOCIALES (S/.)

    582,424.50

    582,424.50

    473,031.95

    473,031.95
    0.79

    0.00

    0.79

    0.00

    0.79

    0.00

    104,094.55

    104,094.55
    0.79

    0.00

    0.79

    0.00

    0.79

    0.00

    5,298.00

    5,298.00
    0.79

    0.00

    0.79

    0.00

    0.79

    0.00

    10,000.00

    0.847

    8,470.00

    15,608.75

    0.847

    13,220.61

    44,331.00

    0.847

    37,548.36

    6,000.00

    0.847

    5,082.00

    658,364.25

    10.498

    658,364.25

    10.198/13
    0.78446154

    COSTOS DE OPERACIN Y MANTENIMIENTO CON PROYECTO


    PARA LA ALTERNATIVA SELECCIONADA
    AOS
    AO1
    AO2
    AO3
    AO4
    AO5
    AO6
    AO7
    AO8
    AO9
    AO10
    AO11
    AO12
    AO13
    AO14
    AO15
    AO16
    AO17
    AO18
    AO19
    AO20

    MANTENIMIENTO

    MANTENIMIENTO

    TOTAL A

    TOTAL A

    RUTINARIO

    PERIODICO

    PRECIOS MERCADO

    PRECIOS SOCIALES

    1377
    1377
    5723.5
    1377
    1377
    5723.5
    1377
    1377
    5723.5
    1377
    1377
    5723.5
    1377
    1377
    5723.5
    1377
    1377
    5723.5
    1377
    1377

    1041.012
    1041.012
    4326.966
    1041.012
    1041.012
    4326.966
    1041.012
    1041.012
    4326.966
    1041.012
    1041.012
    4326.966
    1041.012
    1041.012
    4326.966
    1041.012
    1041.012
    4326.966
    1041.012
    1041.012

    1377
    1377
    0
    1377
    1377
    0
    1377
    1377
    0
    1377
    1377
    0
    1377
    1377
    0
    1377
    1377
    0
    1377
    1377

    5723.5

    5723.5

    5723.5

    5723.5

    5723.5

    5723.5

    FLUJOS

    1041.012
    1041.012
    4326.966
    1041.012
    1041.012
    4326.966
    1041.012
    1041.012
    4326.966
    1041.012
    1041.012
    4326.966
    1041.012
    1041.012
    4326.966
    1041.012
    1041.012
    4326.966
    1041.012
    1041.012

    (1+i)n

    BENEFICIO
    1.09 955.056880734
    1.1881 876.19897315
    1.295029 3341.21166399
    1.41158161 737.479145821
    1.5386239549 676.586372313
    1.6771001108 2580.02845032
    1.8280391208 569.469213293
    1.9925626417 522.448819535
    2.1718932794 1992.25534742
    2.3673636746 439.734718908
    2.5804264053 403.426347622
    2.8126647818 1538.38666734
    3.0658046121 339.55588555
    3.3417270272 311.519161055
    3.6424824597 1187.91677047
    3.9703058811 262.199445379
    4.3276334104 240.549949889
    4.7171204173 917.289705843
    5.1416612548 202.466080203
    5.6044107678 185.748697434
    18279.5282963

    VP.CO&M

    Descripcin
    Situacin sin Proyecto
    Alternativa 1
    Alternativa 2

    Costo de
    Inversin

    VP.CO&M

    VP.Costo
    Total

    544957.71

    18279.5283 563237.238

    548416.442 18279.5283

    566695.97

    Costos Incrementales
    Alternativa 1
    Alternativa 2

    544957.71

    18279.5283 563237.238

    548416.442 18279.5283

    566695.97

    899

    POBLACION

    993
    1098
    1214
    1343
    1484
    1641
    1814
    2006
    2218
    2452
    2711
    2997
    3314
    3664

    544957.71

    9.93451799

    548416.442

    9.99757028

    4051
    4478
    4951
    5474
    6052

    54855

    CE

    ALTERNATIVA 1

    CE

    ALTERNATIVA 2

    ANALISIS DE SENSIBILIDAD
    VARIACION
    ALTERNATIVA
    DE
    INVERSION
    1
    0.00
    544,957.71
    0.10
    599,453.48
    0.20
    719,344.18
    0.30
    935,147.43
    0.00
    544,957.71
    0.10
    490,461.94
    0.20
    392,369.55
    0.30
    274,658.69

    VP.CO&M
    18,279.53
    20,107.48
    24,128.98
    31,367.67
    18,279.53
    16,451.58
    13,161.26
    13,819.32

    CE

    ALTERNATIVA

    VAE

    9.93
    10.93
    13.11
    17.05
    9.93
    8.94
    7.15
    5.01

    2
    548,416.44
    603,258.09
    723,909.70
    941,082.61
    548,416.44
    493,574.80
    394,859.84
    276,401.89

    18,279.53
    20,107.48
    24,128.98
    31,367.67
    18,279.53
    16,451.58
    13,161.26
    13,819.32

    CE
    10.00
    11.00
    13.20
    17.16
    10.00
    9.00
    7.20
    5.04

    0.1
    0.2
    0.3

    544,957.71
    54495.771
    490461.939 98092.3878
    392369.551 117710.865

    490,461.94
    392,369.55
    274,658.69

    0.1
    0.2
    0.3

    18,279.53 1827.95283
    16451.5755 3290.31509
    19741.8906 5922.56717

    16,451.58
    13,161.26
    13,819.32

    0.1
    0.2
    0.3

    9.93
    0.9934518
    8.94106619 1.78821324
    7.15285295 2.14585589

    8.94
    7.15
    5.01

    You might also like