26
CODIGO 1 12 2 Otros 13 3 14 4 15 5 16 6 18 7 19 8 22 9 23 10 35 11 37 12 13 14 12 15 13 16 14 17 15 18 16 19 18 20 19 21 22 22 23 23 35 24 37 25

Tablas Tabuladas Info Dossier Alcaldia12

Embed Size (px)

DESCRIPTION

zdfasd

Citation preview

Hoja1

CODIGODESCRIPCIONPRESUPUESTO VIGENTEEJECUCINMONTOEN PORCENTAJE% DE PARTICIPACIN2011112VENTA DE BIENES Y SERVICIOS DE LAS ADMINISTRACIONES PBLICAS78,934,235.0068,485,635.5286.76%5.12%2Otros13INGRESOS POR IMPUESTOS 352,804,001.00325,639,047.3792.30%24.34%314REGALIAS200,000.0055,130.3827.57%0.00%415TASAS DERECHOS Y OTROS INGRESOS80,652,805.00109,764,431.84136.09%8.21%516INTERESES Y OTRAS RENTAS DE LA PROPIEDAD50,000.0045,366.3190.73%0.00%618DONACIONES CORRIENTES6,061,322.006,225,167.16102.70%0.47%719TRANSFERENCIAS CORRIENTES722,248,837.00721,823,473.3299.94%53.96%822DONACIONES DE CAPITAL33,408,703.0013,415,500.3240.16%1.00%923TRANSFERENCIAS DE CAPITAL59,179,250.0017,625,207.1329.78%1.32%1035DISMINUCION Y COBRO DE OTROS ACTIVOS FINANCIEROS421,044,148.000.000.00%0.00%1137OBTENCION DE PRESTAMOS DEL EXTERIOR123,148,020.0074,693,576.1060.65%5.58%12TOTAL1,877,731,321.001,337,772,535.4571.24%100.00%1320121412VENTA DE BIENES Y SERVICIOS DE LAS ADMINISTRACIONES PBLICAS73,469,338.0079,707,189.54108.49%5.18%1513INGRESOS POR IMPUESTOS 437,654,781.00380,623,827.5186.97%24.75%1614REGALIAS200,000.0059,095.5829.55%0.00%1715TASAS DERECHOS Y OTROS INGRESOS105,183,405.00119,789,906.45113.89%7.79%1816INTERESES Y OTRAS RENTAS DE LA PROPIEDAD50,000.0068,143.21136.29%0.00%1918DONACIONES CORRIENTES11,761,501.004,702,189.9839.98%0.31%2019TRANSFERENCIAS CORRIENTES880,602,271.00880,564,741.82100.00%57.25%2122DONACIONES DE CAPITAL12,577,912.006,658,819.9752.94%0.43%2223TRANSFERENCIAS DE CAPITAL29,880,969.0011,917,155.1739.88%0.77%2335DISMINUCION Y COBRO DE OTROS ACTIVOS FINANCIEROS589,179,220.000.000.00%0.00%2437OBTENCION DE PRESTAMOS DEL EXTERIOR93,938,965.0054,065,518.1657.55%3.51%25TOTAL2,234,498,362.001,538,156,587.3968.84%100.00%-0.06923354610.240504018500.30415061200.94041844340.2192505213-0.6235139089-0.49507692310.3993288419-0.23718655810.1899989828

Hoja2

DADESCRIPCINDEVENGADOEN % PARTICIPACIONPERCIBIDO% DE PARTICIPACION1CONSEJO MUNICIPAL243.240.00%243.240.00%2ADMINISTRACION GENERAL DEL EJECUTIVO878,039.420.06%878,039.420.06%3COORDINACION GENERAL DEL EJECUTIVO449,375.380.03%449,375.380.03%5DIRECCION ESPECIAL DE GESTION INTEGRAL DE RIESGOS695,566.280.05%695,566.280.05%6DIRECCION ESPECIAL DE SEGURIDAD CIUDADANA42,240.000.00%42,240.000.00%7OFICIALIA MAYOR DE INFRAESTRUCTURA PBLICA3,463,451.260.23%3,463,451.260.23%8OFICIALIA MAYOR DE PLANIFICACIN PARA EL DESARROLLO499,933.110.03%499,933.110.03%9OFICIALIA MAYOR DE DESARROLLO HUMANO13,961,031.680.91%13,961,031.680.93%10OFICIALIA MAYOR DE CULTURA943,339.440.06%943,339.440.06%11OFICIALIA MAYOR DE PROMOCIN ECONMICA4,238.460.00%4,238.460.00%12SUBALCALDIA I COTAHUMA70,219.910.00%70,219.910.00%13SUBALCALDIA II MAXIMILIANO PAREDES32,209.720.00%32,209.720.00%14SUBALCALDIA III PERIFERICA74,241.880.00%74,241.880.00%15SUBALCALDIA IV SAN ANTONIO29,517.080.00%29,517.080.00%16SUBALCALDIA V SUR87,159.560.01%87,159.560.01%17SUBALCALDIA VI MALLASA32,142.360.00%32,142.360.00%18SUBALCALDIA VII CENTRO17,147.080.00%17,147.080.00%19SUBALCALDIA VIII HAMPATURI220.000.00%220.000.00%20SUBALCALDIA IX ZONGO5,257.060.00%5,257.060.00%25ZOOLOGICO MUNICIPAL14,781.950.00%14,781.950.00%28PARQUE URBANO CENTRAL190.940.00%190.940.00%30BARRIOS Y COMUNIDADES DE VERDAD7,043,033.330.46%7,043,033.330.47%31PROGRAMA DE DRENAJE PLUVIAL34,960,514.212.27%15,684,611.601.05%32PROGRAMA DE MOVILIDAD Y TRANSPORTE PUBLICO833,417.930.05%833,417.930.06%33TESORO MUNICIPAL1,428,967,971.8692.90%1,412,570,511.5094.16%34SERVICIOS Y GASTOS INSTITUCIONALES15,656.000.00%15,656.000.00%36CENTROS INFANTILES MUNICIPALES50,250.000.00%50,250.000.00%39MATADERO MUNICIPAL1,039,561.000.07%1,023,420.000.07%40SISTEMA DE REGULACIN Y SUPERVISIN MUNICIPAL38,195.000.00%38,195.000.00%41HOSPITAL DE CLNICAS16,129,213.551.05%15,283,453.351.02%42HOSPITAL DE LA MUJER1,288,980.940.08%1,286,174.920.09%43HOSPITAL DEL NIO4,884,818.630.32%4,387,451.490.29%44INSTITUTO DE GASTROENTEROLOGIA BOLIVIANO JAPONS6,045,468.640.39%5,837,512.850.39%45INSTITUTO NACIONAL DEL TORAX4,718,190.040.31%4,283,445.400.29%46INSTITUTO NACIONAL DE OFTALMOLOGIA1,466,874.000.10%1,466,419.140.10%47HEMOCENTRO BANCO DE SANGRE DE REF. DPTAL. DE LA PAZ3,022,085.200.20%2,765,035.200.18%48HOSPITAL LA PAZ1,454,219.390.09%1,438,576.600.10%49HOSPITAL LA MERCED 592,484.830.04%583,815.730.04%50HOSPITAL LOS PINOS1,777,921.460.12%1,751,655.690.12%51RED DE SALUD 1 COTAHUMA311,612.250.02%311,049.550.02%52RED DE SALUD 2 MAXIMILIANO PAREDES1,379.100.00%0.000.00%53RED DE SALUD 3 PERIFERICA - CENTRO6,543.400.00%0.000.00%54RED DE SLAUD 4 SA ANTONIO1,876,519.720.12%1,873,994.220.12%55RED DE SALUD 5 SUR313,181.850.02%311,049.550.02%56DIRECCION ESPECIAL DE MOVILIDAD, TRANSPORTE Y VIALIDAD17,949.250.00%17,949.250.00%TOTAL1,538,156,587.39100.00%1,500,157,224.11100.00%

Hoja3

CDIGODESCRIPCINPRESUPUESTO VIGENTEEJECUCIONMONTOEN PORCENTAJE% DE PARTICIPACION2011120RECURSOS ESPECIFICOS548,506,447.00511,106,710.6893.18%38.21%241TRANSFERENCIAS TGN1,029,343,751.00721,207,916.5870.06%53.91%342TRASFERENCIAS DE RECURSOS ESPECIFICOS1,286,617.001,280,766.0499.55%0.10%443TRANSFERENCIAS DE CREDITO EXTERO34,758,280.00491,287.231.41%0.04%544TRANSFERENCIA DE DONACION EXTERNA38,213,933.0016,468,710.600.00%1.23%646TRANSFERENCIA TGN OTROS INGRESOS1,567,305.000.000.00%0.00%770CREDITO EXTERNO 187,441,740.0074,693,576.1039.85%5.58%880DONACION EXTERNA36,613,248.0012,523,568.2234.21%0.94%9TOTAL1,877,731,321.001,337,772,535.4571.24%100.00%1020121120RECURSOS ESPECIFICOS791,198,096.00583,807,584.9373.79%37.96%1241TRANSFERENCIAS TGN1,245,957,654.00880,831,266.0770.70%57.27%1342TRASFERENCIAS DE RECURSOS ESPECIFICOS6,203.000.000.00%0.00%1443TRANSFERENCIAS DE CREDITO EXTERO12,657,975.00498,202.733.94%0.03%1544TRANSFERENCIA DE DONACION EXTERNA48,760,858.0011,152,428.1922.87%0.73%1670CREDITO EXTERNO 113,986,710.0054,065,518.1647.43%3.51%1780DONACION EXTERNA21,930,866.007,801,587.3135.57%0.51%18TOTAL2,234,498,362.001,538,156,587.3968.84%100.00%

Hoja5FUENTEDESCRIPCIONPRESUPUESTO VIGENTEEJECUCIONMONTOEN PORCENTAJE% DE PARTICIPACION201220 RECURSOS ESPECFICOS791,198,096.00583,087,574.9373.79%37.96%210REC.ESPECIF. DE MUICIPALIDADES E INDIGENA ORIGINARIO CAM726,573,781.00538,326,294.4874.09%35.00%220REGALIAS200,000.0059,095.5829.55%0.00%230OTROS RECURSOS ESPECIFICOS64,424,315.0045,422,194.8770.50%2.95%41 TRANSFERENCIAS TGN1,245,957,654.00880,831,266.0770.70%57.27%113TESORO GENERAL DE LA NACION - PARTICIPACION POPULAR762,056,280.00565,912,776.2774.26%36.79%114RECURSOS DE CONTRAVALOR266,622.00266,524.2599.96%0.02%119TGN - IMPUESTO DIRECTO A LOS HIDROCARBUROS483,603,485.00314,651,965.5565.06%20.46%120TGN - IMPUESTO A LA PARTICIPACION EN JUEGOS31,267.000.000.00%0.00%42 TRANSFERENCIA DE RECURSOS ESPECIFICOS6,203.000.000.00%0.00%230OTROS RECURSOS ESPECIFICOS6,203.000.000.00%0.00%43 TRANSFERENCIAS DE CREDITO EXTERNO12,657,975.0049,202.733.94%0.03%411BANCO INTERAMERICANO DE DESARROLLO11,361,074.00498,202.734.39%0.03%415AGENCIA INTERNACIONAL DE FOMENTO (BM)1,296,901.000.000.00%0.00%44 TRANSFERENCIAS DE DONACION EXTERNA48,760,858.0011,152,428.1922.87%0.73%115DONACIONES - HIPC II46,817,121.0011,044,575.9623.59%0.72%371UNION EUROPEA1,403,559.000.000.00%0.00%411BANCO INTERAMERICANO DE DESARROLLO1,732.000.000.00%0.00%720BASKET FUNDING538,446.00107,852.2320.03%0.01%70 CREDITO EXTERNO113,986,710.0054,065,518.1647.43%3.51%314CORPORACION ANDINA DE FOMENTO3,200,000.001,823,683.7356.99%0.12%411BANCO INTERAMERICANO DE DESARROLLO89,260,057.0041,954,976.2447.00%2.73%415AGENCIA INTERNACIONAL DE FOMENTO (BM)21,526,653.0010,286,858.1947.79%0.67%80 DONACION EXTERNA21,930,866.007,801,587.3135.57%0.51%314CORPORACION ANDINA DE FOMENTO1,780,095.00429,658.3424.14%0.03%341CENTRO NNUU PARA LOS ASENTAMIENTOS HUMANOS200,000.000.000.00%0.00%345FONDO NNUU PARA LA ACTIVIDAD EN MATERIA DE POBLACION122,246.000.000.00%0.00%357PROGRAMA DE LAS NNUU PARA EL DESARROLLLO1,167,900.00679,435.6058.18%0.04%411BANCO INTERAMERICANO DE DESARROLLO438.00438.00100.00%0.00%528AGENCIA ESPAOLA DE COOPERACION INTERNACIONAL7,819,158.002,968,123.4037.96%0.19%556HOLANDA28,000.0028,000.00100.00%0.00%559ITALIA431,001.00321,899.8374.69%0.02%561JAPON3,959,630.003,201,555.1480.85%0.21%568REPUBLICA BOLIVARIANA DE VENEZUELA1,506,398.000.000.00%0.00%569OTROS ORGANISMOS NO GUBERNAMENTALES142,680.00142,680.00100.00%0.01%729OTROS ORGANISMOS FINANCIADORES EXTERNOS4,773,320.0029,797.000.62%0.00%TOTAL2,234,498,362.001,538,156,587.3968.84%100.00%

Hoja6FUENTEORGANISMOESTEXTGADGAM*N. CENTRALTOTALDONEXDON49,03749,037JICA28,27528,275OPS51,35451,354OTROS ONG621,270621,270OTROS ORG EXT1,019,6961,019,696OTROS ORG MULT142,856142,856UNICEF502502REESPOTROS REESP158,650,608158,650,608TRANSF CREEXBID15,50715,507TRANSF CREINTSIN ORG FIN62,96162,961TRANSF DONEXDON20,74520,745HIPC570,48232,939,81533,510,297TRANSF REESPREESP - MUN27,128,12627,128,126TRANSF TGEIDH18,125,3936,613,74224,739,135PP - TGE10,987,74110,987,741IDH - SSPAM9,745,7229,745,722IDH - SUSA2,445,4442,445,444PP - SUMI88,401,99988,401,999IDH - SUSAT10,859,44810,859,448TGE346,411,604346,411,604TOTAL158,650,6081,949,24328,984,841145,893,255379,414,380714,892,328

Hoja7FUENTE DE FINANCIAMIENTOMONTO EN BOLIVIANOSESTRUCTURA %IDH - SUSA2,445,4442.43%IDH - SSPAM9,745,7229.69%PP - SUMI88,401,99987.88%SUB TOTAL100,593,165100.00%HIPC570,4821.26%IDH6,613,74214.60%REESP - MUN27,128,12659.89%PP - TGE10,987,74124.26%SUB TOTAL45,300,090100.00%TOTAL145,893,255

Hoja4AoXYX2XYMill. Ton. CO2200912481248201022614522201132799837N=36788141607Ao200320042005200620072009201120122013Precio223.54.27.1139119AoPrecio200312200422200534Prmedio 3 ultimos aosMADwq12006442.501.701.001.001.70ERROR:#DIV/0!ERROR:#DIV/0!22007573.233.870.971.975.575.570.172008694.933.572.173.137.433.720.58320097136.606.406.408.579.973.321.9320108129.532.47-0.535.878.872.22-0.24420119911.172.17-0.17-0.704.630.93-0.1852012101111.330.33-2.33-2.502.500.42-5.606201311910.671.679.67Resumen

Estadsticas de la regresin0.8483728831Coeficiente de correlacin mltiple0.7197365487Coeficiente de determinacin R^20.6796989128R^2 ajustado2.2775787757Error tpico92.50Observaciones3.234.93ANLISIS DE VARIANZAGrados de libertadSuma de cuadradosPromedio de los cuadradosFValor crtico de F8.20193.250666666793.250666666717.97649967560.00384092419.92Regresin736.31155555565.187365079411.25Residuos8129.56222222229.67TotalCoeficientesError tpicoEstadstico tProbabilidadInferior 95%Superior 95%Inferior 95,0%Superior 95,0%0.52222222221.65462261980.31561409590.7614970381-3.39033855194.4347829963-3.39033855194.4347829963Intercepcin1.24666666670.29403415564.23987024280.00384092410.55138637161.94194696180.55138637161.9419469618Variable X 1Anlisis de los residualesPronstico para YResiduosObservacin1.76888888890.231111111113.0155555556-1.015555555624.2622222222-0.762222222235.5088888889-1.308888888946.75555555560.344444444458.00222222224.997777777869.2488888889-0.2488888889710.49555555560.5044444444811.7422222222-2.74222222229