{"text_format":"5","workbook":"xls","n_sheets":2,"sheets":["RK-37-2004-83, př. 1","str. 2"],"props":{"creator":"buricova","last_modified_by":"jakoubkova","company":"v"},"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"RK-37-2004-83, př. 1","index":0,"n_rows":23,"n_cols":11,"rows_kept":23,"headers":{"header":["","","RK-37-2004-83, př. 1 počet stran: 2"]},"flags":["formulas_cached_only"]}
["Vývoj  peněžních fondů k 30.9.2004"]
[]
["Organizace: ","Dětské centrum Jihlava, příspěvková organizace"]
[]
[{"$nulls":10},"/v tis. Kč/"]
[null,"Účetní zůstatky fondů:",{"$nulls":3},"Zůstatek","z toho:",{"$nulls":3},"Zůstatek "]
["Období","fond",null,"fond","fond","na běžném","fond","fond","fond","provozní","FKSP"]
[null,"odměn","FKSP","rezervní","investiční","účtu x)","odměn","rezervní","investiční","prostředky","na b. ú."]
[null,"úč. 911","úč. 912","úč. 914","úč. 916","úč.241+245+378",{"$nulls":3},"bez fondů","úč. 243"]
[null,1,2,3,4,"5=6 až 9",6,7,8,9,10]
["k 31.12.2002",87,174,191,202,{"v":1279,"d":"1,279"},87,191,202,799,109]
["k 31.12.2003",87,234,191,335,{"v":1511,"d":"1,511"},87,191,335,898,225]
["k 30.9.2004",111,247,291,412,{"v":1947,"d":"1,947"},111,291,412,{"v":1133,"d":"1,133"},216]
[]
["Vývoj za 1/2003 až 9/2004",24,73,100,210,668,24,100,210,334,107]
[]
["Vývoj za 1-9/2004",24,13,100,77,436,24,100,77,235,-9]
[]
["x) - včetně termínovaných vkladů"]
[]
[]
["Zpracoval:   ","Němcová"]
[null,"2004-10-13"]

{"sheet":"str. 2","index":1,"n_rows":55,"n_cols":10,"rows_kept":55,"merged":[[3,0,6,0],[3,1,3,9],[4,7,4,9],[31,1,31,3],[31,4,31,6],[35,1,35,2],[35,3,35,4],[36,1,36,2],[36,3,36,4],[37,1,37,2],[37,3,39,4],[38,1,38,2],[39,1,39,2],[40,1,40,2],[40,3,40,4],[41,1,41,2],[41,3,41,4],[42,1,42,2],[42,3,42,4],[43,1,43,2],[43,3,43,4],[47,0,48,0],[47,1,48,1],[47,2,47,5],[47,6,48,6],[47,7,48,7]],"flags":["formulas_cached_only"]}
[]
[]
["I. Finanční plán"]
["Finanční plán","Dětské centrum Jihlava"]
[null,"Schválený plán na rok 2004",null,null,"Stav k 30.9.2004",null,null,"Rozdíl 2004 - 2003"]
[null,"Hlavní ","Doplňková","Celkem","Hlavní ","Doplňková ","Celkem","HČ","DČ","Celkem"]
[null,"činnost","činnost",null,"činnost","činnost",null,"%","%","%"]
["Tržby za vlastní výrobky /úč. 601/",0]
["Tržby z prodeje služeb /úč. 602/",0,null,0,null,null,0]
["Tržby za prodané zboží /úč. 604/",0,null,0,null,null,0]
["Aktivace /sesk.úč. 62/",0,null,0,null,null,0]
["Ostatní výnosy /sesk.úč. 64/",330,null,330,341,null,341,{"v":1.0333333333333334,"d":"103.33%"},null,{"v":1.0333333333333334,"d":"103.33%"}]
["      z toho: zúčtování fondů /úč.648/",0,null,0,null,null,0]
["Tržby z prodeje majetku /sesk.úč.65/",0,null,0,null,null,0]
["      z toho: tržby z prodeje dlouhod. majetku /úč. 651/",0,null,0,null,null,0]
["Provozní dotace /úč. 691/",{"v":11800,"d":"11,800"},null,{"v":11800,"d":"11,800"},{"v":8847,"d":"8,847"},null,{"v":8847,"d":"8,847"},{"v":0.7497457627118644,"d":"74.97%"},null,{"v":0.7497457627118644,"d":"74.97%"}]
["Výnosy celkem",{"v":12130,"d":"12,130"},0,{"v":12130,"d":"12,130"},{"v":9188,"d":"9,188"},0,{"v":9188,"d":"9,188"},{"v":0.7574608408903545,"d":"75.75%"},null,{"v":0.7574608408903545,"d":"75.75%"}]
["Spotřeba materiálu /úč. 501/",{"v":1261,"d":"1,261"},null,{"v":1261,"d":"1,261"},984,null,984,{"v":0.7803330689928628,"d":"78.03%"},null,{"v":0.7803330689928628,"d":"78.03%"}]
["      z toho: nákup drobného dlouhod. hm. majetku",30,null,30,4,null,4,{"v":0.13333333333333333,"d":"13.33%"},null,{"v":0.13333333333333333,"d":"13.33%"}]
["Spotřeba energie /úč. 502/",500,null,500,250,null,250,{"v":0.5,"d":"50.00%"},null,{"v":0.5,"d":"50.00%"}]
["Prodané zboží /úč. 504/",0,null,0,0,null,0]
["Služby /sesk.úč. 51/",651,null,651,489,null,489,{"v":0.7511520737327189,"d":"75.12%"},null,{"v":0.7511520737327189,"d":"75.12%"}]
["       z toho: opravy a udržování /úč. 511/",136,null,136,114,null,114,{"v":0.8382352941176471,"d":"83.82%"},null,{"v":0.8382352941176471,"d":"83.82%"}]
["           ostatní služby /úč. 518/",505,null,505,375,null,375,{"v":0.7425742574257426,"d":"74.26%"},null,{"v":0.7425742574257426,"d":"74.26%"}]
["Osobní náklady /sesk.úč. 52/",{"v":9488,"d":"9,488"},null,{"v":9488,"d":"9,488"},{"v":6985,"d":"6,985"},null,{"v":6985,"d":"6,985"},{"v":0.7361930860033726,"d":"73.62%"},null,{"v":0.7361930860033726,"d":"73.62%"}]
["     z toho: mzdové náklady /úč. 521/",{"v":6906,"d":"6,906"},null,{"v":6906,"d":"6,906"},{"v":5107,"d":"5,107"},null,{"v":5107,"d":"5,107"},{"v":0.7395018824210832,"d":"73.95%"},null,{"v":0.7395018824210832,"d":"73.95%"}]
["           v tom platy zaměstnanců",{"v":6876,"d":"6,876"},null,{"v":6876,"d":"6,876"},{"v":5082,"d":"5,082"},null,{"v":5082,"d":"5,082"},{"v":0.7390924956369983,"d":"73.91%"},null,{"v":0.7390924956369983,"d":"73.91%"}]
["Ostatní náklady /sesk.úč. 54/",85,null,85,76,null,76,{"v":0.8941176470588236,"d":"89.41%"},null,{"v":0.8941176470588236,"d":"89.41%"}]
["Odpisy/551/",145,null,145,108,null,108,{"v":0.7448275862068966,"d":"74.48%"},null,{"v":0.7448275862068966,"d":"74.48%"}]
["Daň z příjmů /sesk.úč. 59/",0,null,0,null,null,0]
["Náklady celkem",{"v":12130,"d":"12,130"},0,{"v":12130,"d":"12,130"},{"v":8904,"d":"8,904"},0,{"v":8904,"d":"8,904"},{"v":0.734047815333883,"d":"73.40%"},null,{"v":0.734047815333883,"d":"73.40%"}]
["Hospodářský výsledek",0,null,0,284]
[]
[]
["II. Mzdové prostředky"]
["Ukazatel","platy zaměstnaců",null,"Osobní náklady celkem (včetně odvodů)"]
["Limit mzdových prostředků 2004",{"v":6876,"d":"6,876.0"},null,{"v":9488,"d":"9,488.0"}]
["Čerpání mzdových prostředků k 30.9.2004",{"v":5082,"d":"5,082.0"}]
["Čerpání v % k 30.9.2004",{"v":0.7390924956369983,"d":"0.74"}]
["Předpokládané čerpání do konce roku 2004",{"v":2144,"d":"2,144.0"}]
["Předběžný výpočet pro čerpání za rok 2004",{"v":7226,"d":"7,226.0"},null,{"v":9969.619999999999,"d":"9,969.6"}]
["Překročení limitu",{"v":350,"d":"350.0"},null,{"v":481.619999999999,"d":"481.6"}]
["   - toho 25% další plat",{"v":150,"d":"150.0"},null,205.5]
["   - z toho zapojení z fondů",{"v":200,"d":"200.0"},null,{"v":276.119999999999,"d":"276.1"}]
[]
[]
["III. Peněžní fondy"]
["Fondy v tis. Kč","Zůstatek účtu k 31.12.2003","Plán 2004",{"$nulls":3},"Účetní zůstatek k 30.9.2004","Zůstatek bankovního účtu k 30.9.2004"]
[null,null,"Stav k 1.1.2004","Tvorba","Čerpání","Stav k 31.12.2004"]
["Běžný účet celkem",{"v":1061.57,"d":"1,062"},"-","-","-","-","-",{"v":1947,"d":"1,947"}]
["z toho: fond odměn",0,87,25,0,112,111,111]
["          rezervní fond",0,191,99,0,290,291,291]
["          provozní prostř.",{"v":1061.57,"d":"1,062"},"-","-","-","-","-",{"v":1133,"d":"1,133"}]
["          investiční fond",0,335,145,131,349,412,412]
["Běžný účet FKSP",{"v":224.87,"d":"225"},234,148,150,232,247,216]