{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["RK-28-2004-19, př. 2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"RK-28-2004-19, př. 2","index":0,"n_rows":136,"n_cols":14,"rows_kept":136,"cut":false,"hidden":false,"merged":[[2,0,5,0],[2,1,2,13],[3,7,3,8],[3,12,3,13],[35,1,35,3],[35,4,35,6],[35,9,35,11],[36,1,36,3],[36,4,36,6],[37,1,37,3],[37,4,37,6],[40,0,40,8],[41,0,42,3],[41,4,42,6],[41,7,42,10],[41,11,42,13],[43,0,43,3],[43,4,43,6],[43,7,43,10],[43,11,43,13],[44,0,44,3],[44,4,44,6],[44,7,44,10],[44,11,44,13],[45,0,45,3],[45,4,45,6],[45,7,45,10],[45,11,45,13],[46,0,46,3],[46,4,46,6],[46,7,46,10],[46,11,46,13],[47,0,47,3],[47,4,47,6],[47,7,47,10],[47,11,47,13],[48,0,48,3],[48,4,48,6],[48,7,48,10],[48,11,48,13],[49,0,49,3],[49,4,49,6],[49,7,49,10],[49,11,49,13],[50,0,50,3],[50,4,50,6],[50,7,50,10],[50,11,50,13],[51,0,51,3],[51,4,51,6],[51,7,51,10],[51,11,51,13],[52,0,52,3],[52,4,52,6],[52,7,52,10],[52,11,52,13],[53,0,53,3],[53,4,53,6],[53,7,53,10],[53,11,53,13],[55,0,55,3],[55,4,55,6],[55,7,55,10],[55,11,55,13],[56,0,56,3],[56,4,56,6],[56,7,56,10],[56,11,56,13],[59,0,59,11],[60,2,60,3],[60,4,60,5],[60,6,60,7],[60,8,60,9],[60,10,60,11],[61,10,61,11],[62,2,62,3],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[61,2,61,3],[61,4,61,5],[61,6,61,7],[61,8,61,9],[63,10,63,11],[64,2,64,3],[64,4,64,5],[64,6,64,7],[64,8,64,9],[64,10,64,11],[63,2,63,3],[63,4,63,5],[63,6,63,7],[63,8,63,9],[65,10,65,11],[66,2,66,3],[66,4,66,5],[66,6,66,7],[66,8,66,9],[66,10,66,11],[65,2,65,3],[65,4,65,5],[65,6,65,7],[65,8,65,9],[67,10,67,11],[69,2,69,3],[69,4,69,5],[69,6,69,7],[69,8,69,9],[69,10,69,11],[67,2,67,3],[67,4,67,5],[67,6,67,7],[67,8,67,9],[70,10,70,11],[71,2,71,3],[71,4,71,5],[71,6,71,7],[71,8,71,9],[71,10,71,11],[70,2,70,3],[70,4,70,5],[70,6,70,7],[70,8,70,9],[77,0,78,3],[77,4,78,6],[77,7,78,10],[77,11,78,13],[79,0,79,3],[79,4,79,6],[79,7,79,10],[79,11,79,13],[80,0,80,3],[80,4,80,6],[80,7,80,10],[80,11,80,13],[81,0,81,3],[81,4,81,6],[81,7,81,10],[81,11,81,13],[82,0,82,3],[82,4,82,6],[82,7,82,10],[82,11,82,13],[83,0,83,3],[83,4,83,6],[83,7,83,10],[83,11,83,13],[84,0,84,3],[84,4,84,6],[84,7,84,10],[84,11,84,13],[85,0,85,3],[85,4,85,6],[85,7,85,10],[85,11,85,13],[86,0,86,3],[86,4,86,6],[86,7,86,10],[86,11,86,13],[87,0,87,3],[87,4,87,6],[87,7,87,10],[87,11,87,13],[88,0,88,3],[88,4,88,6],[88,7,88,10],[88,11,88,13],[89,0,89,3],[89,4,89,6],[89,7,89,10],[89,11,89,13],[90,0,90,3],[90,4,90,6],[94,0,96,0],[94,1,96,1],[94,2,94,7],[94,8,96,8],[95,2,96,2],[95,3,95,7],[100,0,101,0],[100,1,101,1],[100,2,100,5],[100,6,101,6],[100,7,101,7],[100,8,100,11],[109,0,110,0],[109,1,110,1],[109,2,109,7],[115,0,116,0],[115,1,115,4],[115,5,115,8],[115,9,115,12],[124,0,125,0],[124,1,124,4],[124,5,124,8],[124,9,124,12],[54,0,54,3],[54,4,54,6],[54,7,54,10],[54,11,54,13]],"flags":["formulas_cached_only"]}
[{"$nulls":13},"RK-28-2004-19, př. 2"]
[{"$nulls":13},"počet stran: 2"]
["Finanční plán","SÚS Jihlava - změna č. 1"]
[null,"Skutečnost za rok 2002",null,null,"Skutečnost za rok 2003",null,null,"Rozdíl 2003 - 2002",null,"Návrh na rok 2004",null,null,"Rozdíl 2004 - 2003"]
[null,"Hlavní ","Doplňková","Celkem","Hlavní ","Doplňková","Celkem","Celkem","v ","Hlavní ","Doplňková","Celkem","Celkem","v "]
[null,"činnost","činnost",null,"činnost","činnost",null,"+/-","%","činnost","činnost",null,"+/-","%"]
["Tržby za vlastní výrobky /úč. 601/"]
["Tržby z prodeje služeb /úč. 602/",null,5347,5347,null,4892,4892,-455,0.9149055545165513,null,4500,4500,-392,0.919869174161897]
["Tržby za prodané zboží /úč. 604/",null,null,0,null,null,0,0,0,null,null,0,0,0]
["Aktivace /sesk.úč. 62/",2964,null,2964,2545,null,2545,-419,0.8586369770580297,2500,null,2500,-45,0.9823182711198428]
["Ostatní výnosy /sesk.úč. 64/",2439,null,2439,2794,null,2794,355,1.1455514555145552,2000,null,2000,-794,0.7158196134574087]
["      z toho: zúčtování fondů /úč.648/",1103,null,1103,547,null,547,-556,0.4959202175883953,null,null,0,-547,0]
["Tržby z prodeje majetku /sesk.úč.65/",330,null,330,1368,null,1368,1038,4.1454545454545455,300,null,300,-1068,0.21929824561403508]
["      z toho: tržby z prodeje dlouhod. majetku /úč. 651/",141,null,141,180,null,180,39,1.2765957446808511,100,null,100,-80,0.5555555555555556]
["Provozní dotace /úč. 691/",111679,null,111679,114982,null,114982,3303,1.0295758378925313,116848,null,116848,1866,1.0162286270894574]
["Výnosy celkem",117412,5347,122759,121689,4892,126581,3822,1.0311341734618236,121648,4500,126148,-433,0.9965792654505811]
["Spotřeba materiálu /úč. 501/",25209,2422,27631,26392,2384,28776,1145,1.0414389634830443,35058,2458,37516,8740,1.3037253266611064]
["      z toho: nákup drobného dlouhod. hm. majetku",231,4,235,525,16,541,306,2.302127659574468,300,10,310,-231,0.5730129390018485]
["Spotřeba energie /úč. 502/",1676,61,1737,1692,74,1766,29,1.0166954519286127,1700,70,1770,4,1.0022650056625142]
["Spotřeba ostat. nesklad. dodávek /úč. 503/",null,null,0,null,null,0,0,0,null,null,0,0,0]
["Prodané zboží /úč. 504/",null,null,0,null,null,0,0,0,null,null,0,0,0]
["Služby /sesk.úč. 51/",32373,936,33309,44190,211,44401,11092,1.333003092257348,34930,331,35261,-9140,0.7941487804328732]
["       z toho: opravy a udržování /úč. 511/",29253,256,29509,39365,55,39420,9911,1.3358636348232742,32080,50,32130,-7290,0.815068493150685]
["           ostatní služby /úč. 518/",1847,659,2506,3612,123,3735,1229,1.4904229848363926,1800,80,1880,-1855,0.5033467202141901]
["Osobní náklady /sesk.úč. 52/",33208,500,33708,35742,822,36564,2856,1.0847276610893557,36240,811,37051,487,1.013319111694563]
["     z toho: mzdové náklady /úč. 521/",24122,368,24490,25980,605,26585,2095,1.0855451204573294,26240,611,26851,266,1.010005642279481]
["           v tom: platy zaměstnanců",23766,357,24123,25349,593,25942,1819,1.0754052149400986,25602,599,26201,259,1.0099838100377765]
["                    ostatní osobní náklady",356,11,367,631,12,643,276,1.7520435967302452,638,12,650,7,1.010886469673406]
["           sociální pojištění /úč. 524-528/",9086,132,9218,9762,217,9979,761,1.0825558689520502,10000,200,10200,221,1.0221465076660987]
["Daně a poplatky /sesk.úč. 53/",20,null,20,18,null,18,-2,0.9,20,null,20,2,1.1111111111111112]
["Ostatní náklady /sesk.úč. 54/",1442,23,1465,1677,49,1726,261,1.1781569965870307,1700,30,1730,4,1.0023174971031286]
["Odpisy, prodaný majetek /sesk.úč. 55/",21049,84,21133,11159,185,11344,-9789,0.5367908011167368,12000,150,12150,806,1.0710507757404795]
["      z toho: odpisy dlouhodobého majetku /úč. 551/",20878,84,20962,10973,150,11123,-9839,0.5306268485831505,11750,150,11900,777,1.0698552548772813]
["Daň z příjmů /sesk.úč. 59/",220,308,528,485,293,778,250,1.4734848484848484,null,150,150,-628,0.1928020565552699]
["Náklady celkem",115197,4334,119531,121355,4018,125373,5842,1.048874350586877,121648,4000,125648,275,1.0021934547310825]
["Hospodářský výsledek",3228,null,null,1208,null,-50784,null,null,500,null,0]
["Nerozdělený zisk, ztráta minulých let k 31.12.",-2172]
["Kumulovaná ztráta (zisk)",1056,null,null,1208]
[]
[]
["Plán čerpání investičního fondu "]
["Stavby - technické zhodnocení a opravy ",null,null,null,"v tis.Kč",null,null,"Strojní investice ",null,null,null,"v tis.Kč"]
[]
["Oprava střechy dílny Telč",null,null,null,550,null,null,"Válec tendemový 4 ks",null,null,null,2500]
["Oprava střechy AB Jihlava",null,null,null,250,null,null,"Podvalník 4 ks",null,null,null,720]
["Výměna oken v zasedácí místnosti AB Jihlava",null,null,null,90,null,null,"Náhrada osobního auta",null,null,null,400]
[{"$nulls":7},"Nakladač repasovaný",null,null,null,1200]
[{"$nulls":7},"Traktor s předním náhonem",null,null,null,950]
[{"$nulls":7},"Auto Pickup - 6 míst + valník",null,null,null,500]
[{"$nulls":7},"Vysokozdvižná plošina",null,null,null,200]
[{"$nulls":7},"Rozbrušovač ledu",null,null,null,400]
[{"$nulls":7},"Klimatizace - sekačky 7 x",null,null,null,500]
[{"$nulls":7},"Nákladni auto Tatra - nosič nástaveb",null,null,null,1400]
[{"$nulls":7},"Nákladni auto Tatra - nosič nástaveb",null,null,null,1900]
[{"$nulls":7},"Systém pro sledování provozu vozidla",null,null,null,60]
[{"$nulls":7},"Sypačová nástavby 2 ks",null,null,null,790]
["Celkem nemovitý majetek",null,null,null,890,null,null,"Celkem movitý majetek",null,null,null,11520]
[]
[]
["Doplňkové ukazatele"]
[null,null,2002,null,2003,null,2004,null,"Index 2003/2002",null,"Index 2004/2003"]
["N - dodavatelsky (Kč)",null,25778957,null,38969575,null,31630000,null,1.5116816013929502,null,0.81165883897887]
["N - dodavatelsky / celkem (%)",null,21.57,null,31.08,null,25.17,null,1.4408901251738524,null,0.80984555984556]
["N - dodavatelsky / (celkem - os. náklady) (%)",null,30.04,null,43.88,null,35.7,null,1.4607190412782958,null,0.8135824977210574]
["N - Osobní / celkem (%)",null,28.2,null,29.16,null,29.49,null,1.0340425531914894,null,1.0113168724279835]
["N - na O a Ú dodavat.bez ZÚS (Kč)",null,24929290,null,38662710,null,29930000,null,1.5508949512802008,null,0.774130939088336]
["N - O a Ú bez ZÚS / celkem (%)",null,20.85,null,30.84,null,23.82,null,1.4791366906474819,null,0.7723735408560312]
["N - odpisy / celkem (%)",null,17.57,null,8.87,null,9.47,null,0.5048377916903812,null,1.0676437429537768]
[]
["PP - opravy a údržba (511) / PP (%)",null,26.42,null,34.28,null,27.46,null,1.2975018925056774,null,0.8010501750291715]
["PP - O a Ú dodavatelsky vč. ZÚS(NS 100-91x, ZR 9) / PP (%)",null,23.08,null,33.89,null,27.07,null,1.4683708838821492,null,0.7987606963706108]
["PP - O a Ú dodavatelsky bez ZÚS (NS 200-91x, ZR 9 / PP (%)",null,22.32,null,33.63,null,25.62,null,1.506720430107527,null,0.7618198037466547]
[]
["N - náklady","PP - provozní příspěvek"]
[]
[]
["Plán oprav - hrazeno z provozu"]
["Plán oprav  dlouhodobého majetku - nemovitý majetek",null,null,null,"v tis.Kč",null,null,"Movitý majetek",null,null,null,"v tis.Kč"]
[]
["Jmenovité akce dle přílohy D2 rozpočtu kraje Vysočina",null,null,null,24800,null,null,"Opravy techniky SÚS",null,null,null,600]
["Dodavatelské výpomoci při ZÚS",null,null,null,1700]
["Drobné dodavatelské práce v NS 200 - 800",null,null,null,4880]
["Drobné opravy budov jednotlivých středisek SÚS",null,null,null,150]
{"$rows_empty":7}
["Celkem plán oprav (SÚ 511)",null,null,null,32130]
[]
[]
[]
["Pořizovací cena majetku","Oprávky k 1.1.2004","Účetní odpisy na rok 2004",{"$nulls":5},"Zůstatková cena k 31.12.2004"]
[null,null,"celkem","z toho odpisová skupina:"]
[null,null,null,1,2,3,4,5]
[200286,111795,11900,426,9935,230,182,1127,76591]
[]
[]
["Fondy v tis. Kč","Zůstatek účtu k 1.1.2003","Účetní stav 2003",null,null,null,"Zůstatek účtu k 31.12.2003","Deficit (-) BÚ","Plán 2004"]
[null,null,"Stav k 1.1.2003","Tvorba","Čerpání","Stav k 31.12.2003",null,null,"Stav k 1.1.2004","Tvorba","Čerpání","Stav k 31.12.2004"]
["Běžný účet celkem",8518125.33,"-","-","-","-",10548051.39,"-","-","-","-","-"]
["z toho: provozní prostředky",8518125.33,"-","-","-","-",10548051.39,null,"-","-","-","-"]
["Fond odměn",633253.78,322624,645664,546765,421523,968248.34,546725.34,421523,null,null,421523]
["Rezervní fond",652989.06,null,410866.75,null,410866.75,560810.12,149943.37,410866.75,null,null,410866.75]
["Investiční fond",761821.6,1772039.96,11123093,11593437.45,1301695.5100000016,1259929.68,-41765.830000001704,1301695.51,11900000,12410000,791695.5099999998]
["Běžný účet FKSP",469053.62,821736.01,569450,686810.49,704375.52,546240.28,-158135.24,704375.52,633000,900000,437375.52]
[]
["stav k 31.12.2003","Celkem","z toho po lhůtě splatnosti"]
[null,null,"do 30 dnů","31-90","91-180","181-360","nad 360","celkem"]
["Pohledávky",1219232.2,43742.4,1260,2963.4,null,76461,124426.8]
["Závazky",8526019.64,{"$nulls":5},0]
[]
[]
["Zaměstnanci","Průměrný přepočtený počet pracovníků (celorok)",null,null,null,"Průměrný evidenční počet zaměstnanců k poslednímu dni sledovaného období",null,null,null,"Průměrná mzda"]
[null,2002,2003,2004,"Rozdíl 04 - 03",2002,2003,2004,"Rozdíl 04 - 03",2002,2003,2004,"Rozdíl 04 - 03"]
[]
["THP",30,30,29,-1,30,30,29,-1,16707,19181,19373,192]
["Dělníci",113,108,109,1,110,102,109,7,12149,13125,13256,131]
["POP",13,11,11,0,13,13,11,-2,7237,8809,8898,89]
["Celkem",156,149,149,0,153,145,149,4,12617,14026,14654,628]
[]
[]
["Zaměstnanci","Tarifní mzdy",null,null,null,"Nadtarif  - nárokový",null,null,null,"Nadtarif  - nenárokový"]
[null,2002,2003,2004,"Index 04/03",2002,2003,2004,"Index 04/03",2002,2003,2004,"Index 04/03"]
[]
["THP",3164770,3573800,3966000,110.97431305613073,1776814,1928185,1983000,102.84282887793444,1099004,1402345,1000000,71.3091286381026]
["Dělníci",8663267,8980583,9968000,110.99502114729076,4976007,5414860,5921000,109.34724074121954,3312021,3479550,2160000,62.07699271457516]
["POP",749498,764970,849000,110.9847444997843,331986,338562,339000,100.12937069133572,49934,59208,15000,25.334414268342115]
["Celkem",12577535,13319353,14783000,110.9888746097502,7084807,7681607,8243000,107.30827546892205,4460959,4941103,3175000,64.2569078199746]
[]
[]
["Poznámka:"]
["Nadtarif nárokový - příplatek za vedení, 13. a 14. plat, příplatky (přesčas, pohotovost, noční, víkendy, svátky, prostředí apod.)"]
["Nadtarif nenárokový - osobní ohodnocení, odměny"]