{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["RK-28-2004-19upr1, př. 3upr1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"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-19upr1, př. 3upr1","index":0,"n_rows":134,"n_cols":15,"rows_kept":134,"cut":false,"hidden":false,"merged":[[48,12,48,14],[49,12,49,14],[50,12,50,14],[51,12,51,14],[44,12,44,14],[45,12,45,14],[46,12,46,14],[47,12,47,14],[39,12,40,14],[41,12,41,14],[42,12,42,14],[43,12,43,14],[91,0,93,0],[92,3,92,7],[83,12,83,14],[84,7,84,11],[84,12,84,14],[83,4,83,6],[91,8,93,8],[91,2,91,7],[92,2,93,2],[91,1,93,1],[79,12,79,14],[75,12,75,14],[76,12,76,14],[77,12,77,14],[78,12,78,14],[75,0,75,3],[76,0,76,3],[77,0,77,3],[78,0,78,3],[84,4,84,6],[74,4,74,6],[75,4,75,6],[76,4,76,6],[77,4,77,6],[78,4,78,6],[79,4,79,6],[82,12,82,14],[80,4,80,6],[81,4,81,6],[82,4,82,6],[80,12,80,14],[81,12,81,14],[80,7,80,11],[82,7,82,11],[2,0,5,0],[3,13,3,14],[3,7,3,8],[35,1,35,3],[35,4,35,6],[72,12,73,14],[72,0,73,3],[72,7,73,11],[60,2,60,3],[61,2,61,3],[72,4,73,6],[60,4,60,5],[61,4,61,5],[64,4,64,5],[65,4,65,5],[74,0,74,3],[74,12,74,14],[83,0,83,3],[84,0,84,3],[81,7,81,11],[79,0,79,3],[80,0,80,3],[81,0,81,3],[82,0,82,3],[79,7,79,11],[83,7,83,11],[85,0,85,3],[85,4,85,6],[2,1,2,14],[35,9,35,12],[74,7,74,11],[75,7,75,11],[76,7,76,11],[77,7,77,11],[78,7,78,11],[98,7,99,7],[98,8,98,12],[107,0,108,0],[107,1,108,1],[107,2,107,7],[98,0,99,0],[98,1,99,1],[98,2,98,5],[98,6,99,6],[55,11,55,12],[54,2,54,3],[54,4,54,5],[54,6,54,7],[54,11,54,12],[55,8,55,9],[54,8,54,9],[36,1,36,3],[36,4,36,6],[37,1,37,3],[37,4,37,6],[56,2,56,3],[57,2,57,3],[58,2,58,3],[56,11,56,12],[57,11,57,12],[59,2,59,3],[55,6,55,7],[56,6,56,7],[57,6,57,7],[58,6,58,7],[59,6,59,7],[55,2,55,3],[55,4,55,5],[57,4,57,5],[58,4,58,5],[60,6,60,7],[61,6,61,7],[56,4,56,5],[59,4,59,5],[65,11,65,12],[61,8,61,9],[63,8,63,9],[56,8,56,9],[57,8,57,9],[58,8,58,9],[59,8,59,9],[60,8,60,9],[64,2,64,3],[65,2,65,3],[63,6,63,7],[64,6,64,7],[65,6,65,7],[63,4,63,5],[53,0,53,12],[64,8,64,9],[65,8,65,9],[58,11,58,12],[59,11,59,12],[60,11,60,12],[61,11,61,12],[63,11,63,12],[64,11,64,12],[63,2,63,3],[122,9,122,13],[113,0,114,0],[122,0,123,0],[122,1,122,4],[122,5,122,8],[113,1,113,4],[113,5,113,8],[113,9,113,13],[38,0,38,8],[39,0,40,3],[39,4,40,6],[39,7,40,11],[41,0,41,3],[41,4,41,6],[41,7,41,11],[42,0,42,3],[42,4,42,6],[42,7,42,11],[43,0,43,3],[43,4,43,6],[43,7,43,11],[44,0,44,3],[44,4,44,6],[44,7,44,11],[45,0,45,3],[45,4,45,6],[45,7,45,11],[46,0,46,3],[46,4,46,6],[46,7,46,11],[47,0,47,3],[47,4,47,6],[47,7,47,11],[48,0,48,3],[48,4,48,6],[48,7,48,11],[51,0,51,3],[51,4,51,6],[51,7,51,11],[49,0,49,3],[49,4,49,6],[49,7,49,11],[50,0,50,3],[50,4,50,6],[50,7,50,11]],"flags":["formulas_cached_only"]}
[{"$nulls":14},"RK-28-2004-19upr1, př. 3upr1"]
[{"$nulls":14},"Počet listů  2"]
["Finanční plán","SÚS Pelhřimov - 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,null,"Rozdíl 2004 - 2003"]
[null,"Hlavní ","Doplňková","Celkem","Hlavní ","Doplňková","Celkem","Celkem","v ","HLČ","HLČ","Doplňková","Celkem","Celkem","v "]
[null,"činnost","činnost",null,"činnost","činnost",null,"+/-","%","schválená","změna","činnost","po změně","+/-","%"]
["Tržby za vlastní výrobky /úč. 601/"]
["Tržby z prodeje služeb /úč. 602/",null,1734,1734,null,1739,1739,5,1.002883506343714,null,null,1700,1700,-39,0.9775733179988499]
["Tržby za prodané zboží /úč. 604/",null,null,0,null,null,0,0,0,null,null,null,0,0,0]
["Aktivace /sesk.úč. 62/",2706,null,2706,2655,null,2655,-51,0.9811529933481153,2600,null,null,2600,-55,0.9792843691148776]
["Ostatní výnosy /sesk.úč. 64/",1847,null,1847,1644,null,1644,-203,0.8900920411478073,1600,null,null,1600,-44,0.9732360097323601]
["      z toho: zúčtování fondů /úč.648/",null,null,0," ",null,0,0,0,null,null,null,0,0,0]
["Tržby z prodeje majetku /sesk.úč.65/",582,null,582,455,null,455,-127,0.781786941580756,400,null,null,400,-55,0.8791208791208791]
["z toho: tržby z prodeje dlouhod. majetku /úč. 651/",40,null,40,99,null,99,59,2.475,200,null,null,200,101,2.0202020202020203]
["Provozní dotace /úč. 691/",113789,null,113789,122051,null,122051,8262,1.072608072836566,117891,2400,null,120291,-1760,0.9855797986087783]
["Výnosy celkem",118924,1734,120658,126805,1739,128544,7886,1.0653582854017138,122491,2400,1700,126591,-1953,0.9848067587752054]
["Spotřeba materiálu /úč. 501/",36928,803,37731,42864,721,43585,5854,1.1551509368953912,50086,null,928,51014,7429,1.1704485488126648]
["      z toho: nákup drobného dlouhod. hm. majetku",1037,null,1037,743,0,743,-294,0.71648987463838,650,null,0,650,-93,0.8748317631224765]
["Spotřeba energie /úč. 502/",1529,13,1542,1604,13,1617,75,1.04863813229572,1810,null,20,1830,213,1.1317254174397031]
["Spotřeba ostat. nesklad. dodávek /úč. 503/",0,0,0,0,0,0,0,0,0,null,0,0,0,0]
["Prodané zboží /úč. 504/",0,0,0,0,0,0,0,0,0,null,0,0,0,0]
["Služby /sesk.úč. 51/",26643,83,26726,31866,52,31918,5192,1.1942677542468008,20152,2400,60,22612,-9306,0.708440378469829]
["       z toho: opravy a udržování /úč. 511/",23918,51,23969,29335,33,29368,5399,1.2252492803204138,18452,2400,40,20892,-8476,0.7113865431762463]
["           ostatní služby /úč. 518/",1611,22,1633,1414,10,1424,-209,0.8720146968769137,1420,null,10,1430,6,1.0042134831460674]
["Osobní náklady /sesk.úč. 52/",32112,248,32360,36225,244,36469,4109,1.1269777503090235,36513,null,287,36800,331,1.0090762017055581]
["     z toho: mzdové náklady /úč. 521/",23170,178,23348,26148,176,26324,2976,1.1274627377077266,26171,null,206,26377,53,1.0020133718279898]
["           v tom: platy zaměstnanců",22711,178,22889,25419,176,25595,2706,1.1182227270741405,26634,null,206,26840,1245,1.0486423129517484]
["                    ostatní osobní náklady",459,0,459,729,0,729,270,1.588235294117647,735,null,0,735,6,1.008230452674897]
["           sociální pojištění /úč. 524-528/",8941,62,9003,10077,68,10145,1142,1.12684660668666,10342,null,81,10423,278,1.0274026614095613]
["Daně a poplatky /sesk.úč. 53/",70,0,70,36,0,36,-34,0.5142857142857142,40,null,1,41,5,1.1388888888888888]
["Ostatní náklady /sesk.úč. 54/",1329,14,1343,1414,14,1428,85,1.0632911392405062,1450,null,20,1470,42,1.0294117647058822]
["Odpisy, prodaný majetek /sesk.úč. 55/",15585,78,15663,12088,104,12192,-3471,0.7783949434974143,12200,null,100,12300,108,1.0088582677165354]
["      z toho: odpisy dlouhodobého majetku /úč. 551/",15442,78,15520,11938,104,12042,-3478,0.7759020618556701,12000,null,100,12100,58,1.0048164756684936]
["Daň z příjmů /sesk.úč. 59/",386,122,508,235,192,427,-81,0.8405511811023622,240,null,190,430,3,1.0070257611241218]
["Náklady celkem",114582,1361,115943,126332,1340,127672,11729,1.1011617777701113,122491,2400,1606,126497,-1175,0.9907967291183658]
["Hospodářský výsledek",4715,null,null,872,null,-50784,null,null,94,null,null,0]
["Nerozdělený zisk, ztráta minulých let k 31.12."]
["Kumulovaná ztráta (zisk)",null,null,null,872]
["Plán čerpání investičního fondu "]
["Stavby - technické zhodnocení a opravy ",null,null,null,"v tis.Kč",null,null,"Strojní investice ",{"$nulls":4},"v tis.Kč"]
[]
["Montážní jáma-dílna Pelhřimov",null,null,null,500,null,null,"Radlice sněhová",{"$nulls":4},380]
["Oprava střechy garáže Pelhřimov",null,null,null,80,null,null,"Radlice sněhová starší  3 ks",{"$nulls":4},180]
["Oprava střechy Kamenice n/L.",null,null,null,20,null,null,"Osobní auto - obnova",{"$nulls":4},280]
["Oprava střechy Humpolec",null,null,null,20,null,null,"Vibrační válec - 2ks",{"$nulls":4},1100]
[{"$nulls":7},"Technologické vozidlo - obnova",{"$nulls":4},500]
["Odvod do rozpočtu zřizovatele (odpisy z majetku odp.sk. 4 a 5)",null,null,null,1200,null,null,"Nakladač (2300) + drobná mechanizace (526)",{"$nulls":4},2826]
[{"$nulls":7},"Obnova radiové sítě",{"$nulls":4},500]
[{"$nulls":7},"Podvozek universální",{"$nulls":4},4600]
[{"$nulls":7},"Sypací nástavba",{"$nulls":4},600]
[{"$nulls":7},"GO podvozku Š706",{"$nulls":4},500]
["Celkem nemovitý majetek",null,null,null,1820,null,null,"Celkem movitý majetek",{"$nulls":4},11466]
[]
["Doplňkové ukazatele"]
[null,null,2002,null,2003,null,2004,null,"Index 2003/2002",null,null,"Index 2004/2003"]
["N - dodavatelsky (ZR 9) (Kč)",null,19446,null,26207,null,18000,null,1.347680756968014,null,null,0.6868393940550235]
["N - dodavatelsky (ZR 9) / celkem (%)",null,0.17,null,0.21,null,0.14,null,1.2352941176470587,null,null,0.6666666666666667]
["N - dodavatelsky (ZR 9) / (celkem - os. náklady) (%)",null,0.23,null,0.29,null,0.2,null,1.2608695652173911,null,null,0.6896551724137931]
["N - Osobní (sesk.účtů 52) / celkem (%)",null,0.28,null,0.29,null,0.29,null,1.0357142857142856,null,null,1]
["N - na O a Ú dodavat.bez ZÚS (NS 200-91x, ZR 9) (Kč)",null,17715,null,25043,null,16800,null,1.413660739486311,null,null,0.6708461446312343]
["N - O a Ú bez ZÚS (NS 200-91x, ZR 9) / celkem (%)",null,0.15,null,0.2,null,0.13,null,1.3333333333333335,null,null,0.65]
["N - odpisy / celkem (%)",null,0.13,null,0.09,null,0.1,null,0.6923076923076923,null,null,1.1111111111111112]
[]
["PP - opravy a údržba (511) / PP (%)",null,0.21,null,0.24,null,0.17,null,1.1428571428571428,null,null,0.7083333333333334]
["PP - O a Ú dodavatelsky vč. ZÚS(NS 100-91x, ZR 9) / PP (%)",null,0.17,null,0.21,null,0.15,null,1.2352941176470587,null,null,0.7142857142857143]
["PP - O a Ú dodavatelsky bez ZÚS (NS 200-91x, ZR 9 / PP (%)",null,0.16,null,0.21,null,0.14,null,1.3125,null,null,0.6666666666666667]
[]
["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",{"$nulls":4},"v tis.Kč"]
[]
["Jmenovité akce dle přílohy D2 rozpočtu kraje Vysočina",null,null,null,10625,null,null,"Opravy techniky SÚS",{"$nulls":4},2852]
["Dodavatelské výpomoci při ZÚS",null,null,null,1200]
["Drobné dodavatelské práce v NS 200 - 800",null,null,null,5975]
["Drobné opravy budov jednotlivých středisek SÚS",null,null,null,200]
{"$rows_empty":7}
["Celkem plán oprav (SÚ 511)",null,null,null,20852]
[]
[]
[]
[]
[]
["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]
[151488,85736,12042,621,10719,153,72,477,53710]
[]
[]
[]
["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",null,"Čerpání","Stav k 31.12.2004"]
["Běžný účet celkem",8970,1080,16757,14959,2878,10872,null,2878,12100,null,13586,1392]
["z toho: fond odměn",96,96,943,164,875,1039,164,875,0,null,300,575]
["          rezervní fond",0,0,3772,2955,817,817,0,817,0,null,0,817]
["          provozní prostř.",7905,"-","-","-","-",7830,null,"-","-",null,"-","-"]
["          investiční fond",969,984,12042,11840,1186,1186,0,1186,12100,null,13286,0]
["Běžný účet FKSP",789,838,513,419,932,906,-26,932,561,null,450,1043]
[]
["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",294.82,8.78,122.88,3.81,0,159.35,294.82]
["Závazky",0,0,0,0,0,0,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,null,2003,2004,"Rozdíl 04 - 03"]
[]
["THP",26,26,27,1,25,27,27,0,18467,null,20493,19388,-1105]
["Dělníci",115,117,119,2,131,130,130,0,12064,null,13284,13237,-47]
["POP",7,8,7,-1,7,7,7,0,6798,null,6562,7797,1235]
["Celkem",148,151,153,2,163,164,164,0]
[]
[]
["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,null,2003,2004,"Index 04/03"]
[]
["THP",3022,3445,3755,108.99854862119014,1701,1777,1437,80.86662915025323,1039,null,1172,1090,93.00341296928327]
["Dělníci",9280,10398,11490,110.50201961915754,4164,4649,4067,87.48117874811787,3205,null,3604,3346,92.84128745837957]
["POP",425,479,533,111.27348643006263,106,109,92,84.40366972477065,40,null,42,30,71.42857142857143]
["Celkem",12727,14322,15778,110.16617790811338,5971,6535,5596,85.63121652639633,4284,null,4818,4466,92.69406392694064]
[]
[]
["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"]