Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
08-13-07 Agenda Item 4E
~ ~HILLS Request for Council Action Prepared By: Depl.: Council Mtg. Date: Final Action Needed By: Sue Iverson, Finance Director -Finane-e'- Agenda Item: 4.E. liiiii.;~t~,~QQ? .. nt. Budgeted Amount: Actual Amount: ,-" Funding Source: ......_. ""__ ______ N/A .. U 'NiA N/A ~ii'011ieirf~ctlb1r~!qq~1.t~r1lt&g1:~m;lliilit__m._.m.'._.......,..,..,.""-"-"..,-,.........."-," "--,"--"--- !A motion to accept the 2007 second quarter financial reports. ~ff3R~lh1j!@n~~t!iI~]jfttGJ1.li4_gi0~~i}74ill1QQ1....,..,._. "___________________ ........... ........ ..... ..____._ ______ I Staff recommends acceptance of the financial reports as presented. x ;u. _,. _H. Memo from Sue Iverson - 2007 2nd Quarter Financial Reports ;~- -...... No.: ,u No.: II!:! Recommendation: Recommendation: X jOther: ----2~-d- Quarter Financial and Investment Portfolio Reports ~iJJjiQlalRrmpilcation$TbTf1~lIu~&filillillilfili-[P~~L--------____.._..,,___....._._......,..,..,..,..,..,.....,.,..,..,..,..,..,....,............_._._..___._"___________________________________n'_.._....,_.,.................."."..".,_". i Actual figures appear to be consistent with budget except where noted and approved by Council. [~gJfOrtXr~frfi~F:l~~mQm.ID).D.f$~ilidllilniliiliT&j ___..._......... . ........__.__ i The actual numbers are coming consistent with budget except as noted and approved by Council. ~ ~~HILLS MEMORANDUM DATE: August 9, 2007 4.E. TO: Honorable Mayor and City Council Michelle Wolfe, City Administrator V FROM: Sue Iverson, Finance Director ~ SUBJECT: 2007 2nd Quarter Financial Reports Background/Discussion: The second quarter [mancial reports are now completed. I have prepared summary sheets for each of the fund types and provided the department detail behind. The reports show the Adopted Budget for the year, June 30, 2007 year-to-date actual results, the percentage of budget used year-to-date, and the amount that remains in the budget. I have not adjusted any budget amounts for any additional authorized charges approved by Council. I will bring forward budget amendments for these items during the 2008 budget process. Items which may be included in these amendments are legal costs for City Hall arbitration and mediation, City Hall repairs, Council Chamber A V equipment, etc. For your information, I have included comments in the detailed portion of the reports to identify instances of major expenditures which may cause the numbers to look over or under budget. This helps to identify situations and helps in understanding the actual numbers versus the budgeted numbers. Some of those areas include: increased costs for advertising in the Administration budget due to position vacancies, increased audit costs in the Finance budget, City Hall arbitration/mediation and repair costs in the City Buildings budget, and unemployment costs which impact several public works related budgets (Streets, Parks, Water, Sewer, Storm Water Management, etc). Overall, the numbers look to be on track with the budget as the General Fund is running about 50% of budget for the first half of the year. Special Revenue Funds vary based on the funding sources, developer expenditures and reimbursements, with the exception of the Cable Fund which is running over budget due to the Laser fiche and Council Chamber A V equipment. Enterprise Funds look behind due to fact that we have a lag in revenue recognition as we do not book the revenue until we receive the payments from customers. At year-end we do an accrual for these billings so that the entire year is reflected, but this is the only time we book an accrual. You would be looking at first quarter revenues and part of the second quarter in these numbers. This would also be reflected in the charges, as major charges are from Roseville for water and the Metropolitan Council for wastewater and they bill us on a lag also. The second quarter investment portfolio has also been included. I have not yet made any changes to the reports or in any investments, as we have just completed and approved the investment policy. Rates in Memo City Council 2007 2nd Quarter Financial Reports 2 the money markets are competitive right now and I will work actively on these after I get the budgets done. Please feel free to call me anytime to discuss any questions you may have. I am happy to explain anything to you. If there is something that is not in these reports that you would like to see, please call or email and I will try to get the information for you. Staff Recommendation: Staff recommends Council make a motion to accept the 2007 second quarter financial reports as presented. in o l")llJPlVV........r-- (lJOOMr--r-COOlN "":dlcidr-:r-.:cir-i.n '<t NIJ)........OlCOM v r-r-- NMCO NN r'~<:i ~ :::::::::~ ~ ~ <<! ~ ~ ~ ~ ~ ~ ~ ~ .:-:.:.::9 ~ ~ g ~ f:? 8 ~ '8; 12 ~..; IIi~i ~ ~* ;;;;~~i . 'i[ .!2~ ~-;S c=o ~€~ eto!! ~... 0_0 l:'~~ os . . > ~ '" M ~ " M m 0 0 ~ ill ~ ::::::jj; ~ m ~ 00 00 ~ ~ :i oj ili d <D N <D <D ~ '" N ::::.:;:l ~ ;; 10 N N ~ ~ ~ lV~ ~ 00 M oo. ~ M. oj 00 .; oj oj a; ,,; ~ J:!:::~ 0 ;; M M (d:.'tI ~ :~::~. w -.:c:..... 8 ;:i '" '" '" '" '" '" '" '" '" '" '" ~ ~ ~ 0 00 00 ~ ~ ~ ~ m m m 0 ~ ~ ~ ~ ~ m ~ ~ .; d .; .; ~ ~ ~ ~ ..; ?-:-:.~ '" ;g 10 ~ ~ ~ ~ ~ ~ ~ M ~ m ~ M m ~ ''';';' " ro '" <D oj d ;j, ~ d <D ~ ... 0 00 <; 0 m ~ M ~ ., 0 ~ m ~ - m ~ !2 ~ ~ '" 0 ~ .; ~ 0 m. ~ '" .; .. ~ M 0 10 10 m ~ ~ .~ - ~. M 0 M - ,,; !+:- ... ..; .10:.:.:. '" :g;~ M ~ :i::" .Q-:.:;; ........ '" l::~ ~ 1:F:. l' e . .1;;:::. 0 ~:::::: . . " .. :C:::. u ~ 2 2 2 2 . if 0 ~ , , ~ ~ ~ ~ u ~ ~ ~ 0 Q:::: ~ ~ " " ~ u , " " u ~ t t ~ 0 ~ it ~ ~ 0 , . . . . , , 8 u u u u ~ . ~ ~ " 0 u ~ m ~ ~ ~ ~ " 0 .5 , => . " .> ~ . . . ~ e " ... => => .. ~ u u u u " ~ m m m m 0 0 0 0 . . . . . 0 0 .0 0 .0 , , , , , " .. ....... .c .c .c ~ ~ ~ ~ ~ " i1 , , ~ 0 " " .c .c .c .c c . " z z z ~ ~ ~ ~ ~ ~ m ...... " " " ~ ~ 00 :::::j;;; ;; :-:-:.:.if.i . ~ <D ~ .; :::::::1 . ~ ~ '" '" .:.:.:.:9: ~ 00 ".i1j:::: 0 0 0 0 "a;::" " " " " u u !2 !2 " " ";;;';::: " " " " " " " " " " ~.:.::: " " " " :k~ . . . . . . . . . . . . . . . . . . . . ~.:" 0 0 0 u 0 0 0 0 0 0 0 0 0 0 ~ ~ ~ ~ 0 0 .:.i:~ ~ ~ ~ ~ M M m M ~ ~ 00 00 M M I:~ m m 00 00 e 0 0 ~ N N ~ ~ ~ ~ -:E':':';' ;:; ;:; 0 0 J~:i. :tf-Q. .ttr:::. .:.3::: . 0 'm:':';':' " :ft:~ m u E 0 , . . . 0 .E ',0:::: ~ , , ~ ~ , 00 m u u 00 ~ ~ ~ ~ ~ " 0 aF" e 0 => ~ . "0 , , ~ . E >;- ~ ~ .. c c .c c ~ 0 ~ " " " ~ ~ ~ ~ ~ m , ....... v v v ~ ~ ~ 00 00 00 00 ON ~ N 0; m M 00 00 dd o o ,,; *** O~~ O~~ cit"'i<"i 000 000 cicid 00 00 00 00 ~M ~ . , .. " ,g ,~ 8 :rn. 0:( ;Q; ~ ~ :; ~ L-~~~ ~~~~: <\I ro O>:~ c: c: 0:<::1 ~~*~ ooMf'1 (,)U e;t: **,UQ ot,{) ,,". 1'-1'-<1>;0>> ...tM~- ;;;;n~~ -,-,::2:4 :C:CZJ:; u..u..u..a;r O)~"""'iB !:i=>oi:2'~ v ww N::2:u...X. E::n~g M;;)Mg?, Wi 2$2~ o 00.'0' ZZZ:Z: iK 10 :m >=>=)::~ ~IJ')M~ r--r--rom 0000: roi?Jt'\itz: ..-.....0,", -roOi:N 3ooiffi: NNl.O.ltl ~~1BEl ~~~5 ooo~ 0: 0 0;0 U<..lUP. ....;e; CllIll<llJII ~~~M :J::J:J'O rolllro);ll o::a:::o::.~ c c cia "iij "iij "iii:ffi oooa g d w :('!l ill :;;; [:;j[O u:lt'i ~o ~M 0000000 U)COCOlDO "cidddtciLri .....00l00r-0> <OO.....OOMO:> NlliNuir.ti<<ir-: NcnOlcnmro(fl v v _ 0000000 0001010..-0 .ou:iONN'<l'c::i S5~~lRlRtog :!M'!('<)crir-:.,f '$..';f<;f.***'if'.. fiO?l~~~3g MM"';M<;').,f-i goooooo 000000 gOg"ggggg o 00000 ll)-<iSo0.6l.lfcici C'lO>OOlOlOlO '<l" lO ......... ilk ~ if!. " :lii ::E: ~ 00 oj o u w ~~ Cl ~~ l\l ~ ~~ ffi;g; -g~ al, S ~*.rl~'$.. ~~~~~~ 8~~<l: ~~ ~~~~~~~ :r::2:Zttlf!!ZI u...(!lu.:EI-u...u... >=>=~~j::~~ NU.XIOWClt-. ~~:2:~~~~ McoilltOlDlOCO "'....MNVM"l ....."'.....10(1).......- MMMll)COMC":I 2020022 ~U~(.H)::@~ )::>=:';;)::)::>:>= MM('.jll)ll)'<l"lO r--(QroOOlDl)lOl ~Q~~~~~ c::!QC::!C::!C::!:!::!2 O....r--NNM'<T 00.........00 '<tltlltlMMIllM QS2S2eQ.\2e N.... co '<l"0l co 0 ~~~fH1~~ .....00.........00 50 <II <lI QI Q) QI Q) III E E E E E E E III ro ro III (lI to III mmmmmmm =:5=:5-5:5:5 "e "e "e "e 'e "e "e V)Ulcnrn(f)VJW ccccccc III ro III (II 1Il <Il <Il E E E E E E E o 0 0 0 0 0 0 wwwwwww (J)(J)(J)(J)(J)(J)(J) @ ~ IrA MMM ~~~ ..t..t..t MMM "':.r--r--. --- 114 ~~~~~~g ili1:5:5:5:5:5il=i I~ ggg~-~ 000000 000001ll ..t-.tmmmc-.i NNt;;t;;t;;~ '<f.:f"iriri~ #.#.*-#.#.#. 001ll1ll1ll1O MMllllllllllO -.t'<i(')<:'5(')-.t 000000 000000 Og"ggggg 00000 cO 10 cO 10 cOci mmmmmlll M ,,1'0 Ejl!! i!ra lIlillJ "" fit 3S ~ I" - ~ ;~-g ::!: ..><:. 2i1!i= o~"S2 ~~o,j"'~iil~~ 'lD"S l: '" l: iil l5ijjiil~iiliil e!;m~~2@@e! 1-;13 l: Ql '" E:E"1- ~lS"~~~j~~ 8i~~~[f~B 01<t\:J:.::c:;:ll.mlJ. ~gQ~~~ffia;~ ~~~~(lj~~~ m:W'<l"IO~llllllm 00000000 umlooouuu >=~>=g:>=>=>=>= .....1!fuC'\lC'\lMMMC'\I r--N.ir--r--r--r--r--1O ~~:a~~a~a M"".>::!>::!e-..""'~ ~ alalNN(;:J'<l" o 00...............0 ~ 1ll1llg'<l"'<l"<D ~ ~~ro~~~ [;) ii5~~~(;:Jl?; o 00......,..,,-0 o 000 000 lii liiliiliiliilii u. lJ.u.u.u.u. '" "''''.!!!..!!l:.!!!..!!l: ~ ~~~~~~ ~ 0 ~ g ~ ~ ~ ~ :i ~ ~ 0 0 0 M 0 0 0 = ~ ,; 0 0 ,; M ~ N " ~ ~ 0 0 ri ~ o ~ ~ ~ ~ 0 0 0 ~ 0 0 0 M ,; 0 0 ., M W " '" w '" '" ~ 0 ;! ~ 0 ~ d ..; ., 0 000 M 0 qqq ~ d 000 ~ ~ ~ .. ~ ~ w '" 0 '" 0 ~ '" i'l '" 0 ~ " .2 . e " , " om ~ ~> ~ " ~ . 0 . " 0 " .- ~ .. ,"," ~ ~ :!tjlJ ;; 0 ;E~ , 0 " ;\ E20 ~ . S.E1l1 .Ss S .C 0 1;5 o C 0 . - . . E w g ~ ~ ~ ~ " ,-- > w o . . ~ Z o.!:.!: z ~ ~ ~ .. ~ . . . "0 ~ NNN ~ v ~ U 00 ~ M ;; m gj c W ~ ~ e ~ ~ N 1] " 1\ 0 u " 'g m , . "0 ~ >;- 0 ~ .. , 0 00 '" M ~ .; '" ~ N '" ~ ~ . c . E 2 .. ~ . .. ~ ~ . . u: .. "0 >;- ~ , 00 #.#. NM ~M woo ..t<:'5 ~ " " ~ . o E 0 ,,, iii..e ~ . o E . , iUiii ~~ -go N . ~~ ~-g .::c "~ ~~ . 0 > 0 O~ General Fund Summary Adopted 6/30/2007 % 2007 TYD Budget BudClet Actual (Mean 50%1 Variance Revenue Administration $ 2,821,140 $1,437,742 51.0% $ 1,383,398 Planning & Zoning 101,794 31,557 31.0% 70,237 Government Buildings 60,000 60,000 100.0% Public Safety 34,450 11,772 34.2% 22,678 Protective Inspections 257,500 89,586 34.8% 167,914 Street Maintenance 70,000 32,278 46.1% 37,722 Park Maintenance 1,300 1,439 110.7% (139) Recreation Programs 88,750 59,932 67.5% 28,818 Other Financing Sources 39,000 39,000 100.0% Total 3,473,934 1,763,306 50.8% 1,710,628 Expenditures Mayor & Council 67,360 33,657 50.0% 33,703 Elections 3,300 4 0.1% 3,296 Administration 430,018 199,009 46.3% 231,009 Finance 81,864 32,533 39.7% 49,331 Planning & Zoning 171,904 64,400 37.5% 107,504 Government Buildings 256,911 194,788 75.8% 62,123 Public Safety 1,076,972 689,729 64.0% 387,243 Protective Inspections 227,905 104,882 46.0% 123,023 Street Maintenance 459,361 114,842 25.0% 344,519 Parks Maintenance 291,083 107,861 37.1% 183,222 Recreation 219,442 91,690 41.8% 127,752 Transfers 187,816 187,816 100.0% Total 3,473,936 1.821,211 52.4% 1,652,725 Total Revenue Over Expenditures $ (2) $ (57,905) $ 57,903 Administration Adopted 2007 Budoet 6/30/2007 YTD Actual % Budget (Mean 50%) Variance Comments General Fund Revenues Pro e tv Taxes 101 - 41500 - 31010 General Tax Levv 2,479.318 1,235,649 49.8% 1.243,669 101 - 41500 - 31020 DeJiauentProoertvTaxes 7.000 6,454 92.2% 546 101 - 41500 - 31030 Mobile Homes 7.500 1,454 19.4% 6.046 101 - 41500 - 31040 Fiscal Disnarities 195,843 102,801 52.5% 93.042 101 - 41500 - 31910 Del Penaltv/lnterest - 413 nfa 1413 101 - 41500 - 31920 Forfeited Tax Sales - nfa - Subtotal 2.689,661 1,346.772 50.1% 1,342.889 Licenses & Permits 101 - 41500- 32110 Linuor, On Sale & Sunday 34,000 31.970 94.0% 2.030 101 - 41500 - 32111 Linuor, Off Sale 1,100 640 58.2% 460 101 - 41500- 32160 Contractors 4.600 3.120 67.8% 1,480 101 - 41500- 32180 Business Licenses 12.000 13.222 110.2% 11,222 101 - 41500 - 32240 Pet Reaistration 3.000 1.538 51.3% 1,463 Subtotal 54.700 50,490 92.3% 4,211 Inter overnmental 101 - 41500 - 33410 MVHC - n/a - 101 - 41500 - 33480 State PERA Aid 5,179 0.0% 5,179 Subtotal 5,179 - 0.0% 5.179 Char es for Services 101 - 41500 - 34100 General Govt Fees 4,000 3.289 82.2% 711 101 - 41500 - 34103 Plat & Other Fees - nfa - 101 - 41500 - 34120 Water Tower Antenna Rentals 51.000 24.225 47.5% 26.775 Subtotal 55.000 27.514 50.0% 27,486 Miscellaneous 101 - 41500 - 36230 Contributions/Franchise Fees 3.600 2.152 59.8% 1,448 101 - 41500 - 36270 Miscellaneous 4.000 56 1.4% 3,944 Subtotal 7,600 2,208 29.1% 5.392 Interest Income 101 - 41500 - 36210 Interest Income 9,000 10,758 119.5% 11.758 Subtotal 9.000 10.758 119.5% 11.758 I Total Administration 2.821.140 1,437.742 51.0% 1.3S3.398 Plannina & Zonina Licenses & Permits 101 - 41910 - 32190 Sinn Permits 1,100 800 72.7% 300 101 - 41910 - 32215 Plan Check Fee 60,000 17,916 29.9% 42,084 Subtotal 61.100 18,716 30.6% 42,384 Inter overnmental 101 - 41910 - 33500 Grants 24.194 0.0% 24,194 Subtotal 24,194 - 0.0% 24,194 General Fund Revenues Adopted 2007 6/30/2007 YTD % Budget Budoet Actual Mean 50% Variance Comments Char es tor Services 101 - 41910 - 34103 Plat & Other Fees 16.500 12,841 77.8% 3,659 101 - 41910 - 36274 Develooer Reimbursements - n/a 0 Subtotal 16.500 12,841 77.8% 3,659 I Total Plannina & Zonina 101,794 31,557 31.0% 70,237 Government Buildinas Other Internal Revenue 101 - 41940- 38400 I Buildina Rent 60.000 60.000 100.0% - From Water/Sewer I Subtotal 60.000 60.000 100.0% - 1 Total Government Buildinas 60.000 60.000 100.0% - Public Safety Inter overnmental Revenue 101 - 42100 - 334211 Police Aid - n/a - I Subtotal - 0 n/a - Char es tor Services 101 - 42100 - 34202 False Alarms 2,400 650 27.1% 1,750 101 o 42100 - 34206 Doa Imoound Fees 400 136 33.9% 264 Subtotal 2.800 786 28.1% 2.014 Fines & Forfeits 101 - 42100 - 35110 Hwv Patrol Fines 1.500 520 34.7% 980 101 - 42100 - 35130 DWI Forfeitures - - nfa 0 101 - 42100 - 35140 Violations Bureau 30.000 10,466 34.9% 19.534 101 - 42100 - 35150 Tobacco Fines 150 0.0% 150 Subtotal 31,650 10,987 34.7% 20.663 I Total Public Satetv 34,450 11,772 34.2% 22,678 Protective Insnections Licenses & Permits 101 o 42400 _ 32210 Plan Review & Bide Permits 175.000 50.940 29.1% 124.060 101 - 42400 - 32220 Mechanical Permits 30,000 11.754 39.2% 18.246 101 - 42400 - 32230 Plumbina Permits 12,000 5.253 43.8% 6.747 101 - 42400 - 32260 Electrial Permits 22,000 11,625 52.8% 10,375 101 - 42400 - 32275 Fire Sunnression Permits 6,000 4,372 72.9% 1,629 101 - 42400 - 32278 Fire Permit Plan Check Fee 2.500 2,173 86.9% 327 Subtotal 247.500 86,116 34.8% 161,384 Miscellaneous Recei ts 101 - 42400 - 36202 State Blda Code Surcharaes 9.000 2,985 33.2% 6.015 101 - 42400 - 36203 Citv Bldn Code Surcharnes 1.000 485 48.5% 515 101 - 42400 - 36271 Fire Ins ection Reim LJFD - n/a 0 Subtotal 10.000 3,470 34.7% 6,530 Total Protective Ins ections 257,500 89.586 34.8% 167.914 General Fund Revenues Adopted 2007 Budoet 6/30/2007 YTD Actual % Budget (Mean 50%) Variance Comments Street Maintenance Inter overnmental Revenue 101 - 43100 - 334191 MSA Maintenance 70,000 32.083 45.8% 37,917 I Subtotal 70,000 32,083 45.8% 37.917 I Miscellaneous Recei ts 101 - 43100 - 36270 Misc Reimbursements - 195 nla 195 101 - 43100 - 36275 Private Street Lioht Reim - nla - 101 - 43100 - 36990 Sale of Enuinment - n/a - Subtotal - 195 nfa 195 I Total Street Maintenance 70,000 32.278 46.1% 37.722 Parks Maintenance Char es for Services 101 - 45200 - 34780 Park Facilitv Rental Fees 1,300 1,439 110.7% 1139 Subtotal 1.300 1,439 110.7% 1139 I Total Parks Maintenance 1.300 1,439 110.7% (139 Recreation Proaram Char es for Services 101 - 45120- 34730 Summer Plavoround Fees 12,000 12.581 104.8% (581 101 - 45120 - 34740 Summer TriD Fees 750 620 82.7% 130 101 - 45120 - 34781 Adult Proarams 500 0.0% 500 101 - 45120- 34782 Youth Proqrams 40.500 27.178 67.1% 13.322 101 - 45120- 34785 Adult Softball 16.000 10,704 66.9% 5.296 101 - 45120- 34790 After School Proarams 17.000 7,365 43.3% 9.636 101 - 45120- 34791 Soecial Events Proarams 2.000 1,485 74.3% 515 Subtotal 88,750 59.932 67.5% 28,818 I Other Financin Sources 101 - 45120 - 39230ITransfer from 225 39.000 39.000 100.0% - I Subtotal 39.000 39,000 100.0% - I Total Protective InsDections 127.750 98.932 77.4% 28,818 Total General Fund 3,473.934 1.763.307 50.8% 1.710.627 Adopted 2007 Budaet 6/30/2007 YTD Actual % Budget (Mean 50%1 Variance Comments General Fund EXDenditures Mavor & Council Personnel Services 101 - 41100 - 41010 Re ular Office Salaries 16,400 8,200 50.0% 8,200 101 - 41100 - 41220 FICA Exoense 1.255 627 50.0% 628 Subtotal 17,655 8,827 50.0% 8,828 Sunnlies 101 - 41100 - 42010 Suoolies/Accessories n/a - 101 ~ 41100 - 42030 Printina 500 356 71.1% 144 Subtotal 500 356 71.1% 144 Communications 101- 41100- 43220 Postaae 7,800 2,831 36.3% 4,969 101 - 41100 - 43240 Miscellaneous - n/a - 101 - 41100 - 43510 Le al Notice/AdvertisinQ 2,600 289 11.1% 2,311 101 - 41100 - 43550 Newsletter Printino/Publishino 13,130 5,802 44.2% 7.328 Subtotal 23,530 8,922 37.9% 14.608 Emnlovee Develo ment 101 - 41100 - 44330 Dues/Licenses 6,475 1,465 22.6% 5,010 101 - 41100 - 44370 Trainino/Subsistence 3.600 1,544 42.9% 2,056 101 41100 44372 Emnlovee Reco nition Pro ram 30 n/a (30 101 ~ 41100 - 44915 Miscellaneous 1,100 0.0% 1,100 Subtotal 11,175 3,039 27.2% 8,136 Contractural Service 101 - 41100 - 43010 Professional Services 10,000 7,551 75.5% 2,449 Council Retreat $5.268 Subtotal 10,000 7,551 75.5% 2,449 Other Services & Charaes 101 - 41100 - 43610 Pro erty & Liability Insurance 500 345 69.0% 155 101 - 41100 - 44900 Community Proiects . n/a . 101- 41100- 44935 Miscellaneous 4,000 4,618 115.5% (618 Subtotal 4,500 4,963 110.3% (463 Total Mavor & Council 67,360 33,657 50.0% 33,703 General Fund Exoenditures Adopted 2007 Budaet 6/30/2007 YTD Actual % Budget (Mean 50%\ Variance Comments Elections Personnel Services 101 - 41210 - 41020 Overtime Salaries - n/a - 101 - 41210 - 41210 PERA Emo[over Exoense - n/a 101 - 41210 - 41220 FICA Exnense - n/a - Subtotal - - n/a - SUDolies 101 - 41210 - 42010 Sunnlies/Accessones n/a - 101 - 41210 - 42030 Printin n/a - Subtotal - - n/a - Communications 101 - 41210 - 43220 Posta e - 4 n/a 4 Subtotal - 4 n/a 4 Emnlovee Develonment 101 - 41210 - 44370 Traininn/Subsistence 200 0.0% 200 Subtotal 200 - 0.0% 200 Contractural Service 101 - 41210 - 43090 A I. Software SUOt ort 600 0.0% 600 Subtotal 600 - 0.0% 600 Other Services & Charnes 101 - 41210 - 43065 Election Jud e Pavments - n/a - 101 - 41210 - 43310 Mileaoe Reimbursement - n/a - 101 - 41210 - 44935 Miscellaneous - n/a - Subtotal - - n/a - Ca italOutla 101 - 41210 - 45700 Office Eauio. & Furnishinos 2,500 0.0% 2,500 Subtotal 2,500 - 0.0% 2,500 Total Elections 3.300 4 0.1% 3.296 General Fund Exoenditures Adopted 2007 Budaet 6/30/2007 YTO Actual % Budget (Mean 50%) Variance Comments Administration Personnel Services 101 - 41500 M 41010 Reaular Office Salaries 147,576 73,949 50.1% 73,627 101 - 41500 M 41020 Overtime Salaries - n/a - 101 - 41500 - 41040 Temoorarv Emolovees - n/a - 101 - 41500 - 41120 Car Allowance 1,800 975 54.2% 825 101 - 41500 - 41130 Emnlover Savin s Match 2.154 1,025 47.6% 1.129 101 - 41500 M 41210 PERA Emolover Exoense 9.223 4,738 51.4% 4.485 101 - 41500 M 41220 FICA Exoene 11.290 5,618 49.8% 5,672 101 - 41500 M 41300 Insurance EXflense 15,199 13,231 87.1% 1,968 101 - 41500 M 41310 Life Insurance/L TD/STD 1,991 588 29.6% 1.403 101 - 41500 M 41410 Paid Unemolovement Benefits - n/a - 101 - 41500 - 41510 Workers' Como Ins Premiums 11,500 11,815 102.7% 1315 Subtotal 200,733 111,940 55.8% 88,793 Sunnlies 101 - 41500 M 42010 Suoolies/Accessories 22.000 10,110 46.0% 11.890 101 - 41500 M 42030 Printina 1.000 513 51.3% 487 Subtotal 23,000 10,623 46.2% 12,378 Communications 101 - 41500 - 43210 Teleohone/Cell Phone Chas - 311 n/a 311 101 - 41500 - 43220 Postane 8,000 4,553 56.9% 3.447 101 - 41500 M 43240 Miscellaneous 200 0.0% 200 101 - 41500 M 43510 Leaal Notice/Advertisina 1,200 1,673 139.4% 473 Job Notice Ads Subtotal 9,400 6.537 69.5% 2,863 Emnlovee Develo ment 101 - 41500 - 44330 Dues/Licenses 13,185 5.423 41.1% 7,762 101 - 41500 - 44370 Trainina/Subsistence 5,600 3,274 58.5% 2,326 101 - 41500 M 43310 Mileane 233 n/a 233 Subtotal 18,785 8,930 47.5% 9,855 General Fund Excenditures Adopted 2007 6/30/2007 YTD % Budget Budnet Actual Mean 50% Variance Comments Contractural Service 101 . 41500 - 43010 Professional Services 147,500 5,361 3.6% 142,139 101 - 41500 - 43030 Prof Serv E~ineer 12,737 n/a 112,737 101 - 41500 - 43040 Prof Serv L~l Fees 4,146 n/a 4,146 101 - 41500 - 43045 Prof Serv Le al Prosecution 10,731 n/a (10,731 101 . 41500 - 43090 Annl. Software Sunnort - . n/a - 101 - 41500 - 43091 PC Network Sunnort - - n/a . 101 - 41500. 44090 Admin Fee$lEAP, FSA FeeS' 3,300 1,500 45.5% 1.800 Subtotal 150,800 34,474 22.9% 116.326 Maintenance/Materials 101 - 41500 - 44040 Maint. Of Vehicles/Eni:ij"n 1.800 1,339 74.4% 461 101 - 41500 - 44150 Rentals . n/a . Subtotal 1,800 1,339 74.4% 461 Other Services & Char-;:;es 101 - 41500 - 43310 Milea e Reimbursement 500 0.0% 500 101 - 41500 - 43610 Pronertv & Liabilitv Insurance 23,200 22,844 98.5% 356 101 - 41500 - 44091 Admin. Fees 1,000 1,616 161.6% 616 101 - 41500 - 44900 Commun~Pro;ects - n/a - 101 - 41500 - 44935 Miscellaneous 800 706 88.3% 94 Subtotal 25,500 25,166 98.7% 334 Canital Outl~ 101 - 41500 - 45400 ~ment . n/a - 101 - 41500 - 45700 Office E uin & Furnishinas . n/a - Subtotal . . n/a - Total Administration 430,018 199,009 46.3% 231,009 General Fund EXDenditures Finance Adopted 2007 Budaet 6/30/2007 YTD Actual % Budget (Mean 50%) Variance Comments Personnel Services 101 - 46500 - 41010 Reaular Office Salaries 43,277 14,432 33.3% 28,845 101 - 46500 - 41110 Unused PTO 677 0.0% 677 101 - 46500 - 41130 Em lover Savinas Match 418 274 65.6% 144 101 - 46500 - 41210 PERA Emolover Exoense 2,705 899 33.2% 1,806 101 - 46500 - 41220 FICA Exoene 3,311 1.085 32.8% 2,226 101 - 46500 - 41300 Insurance Ex ense 5,197 1.859 35.8% 3,338 101 - 46500 - 41310 Life Insurance/L TD/STD 450 119 26.3% 331 Subtotal 56.035 18,668 33.3% 37,367 Communications 101 - 46500 - 43220 Posta e 1,000 7 0.7% 993 101 - 46500 - 43510 Leaal Notice/Advertisina 1,000 0.0% 1,000 Subtotal 2,000 7 0.4% 1,993 Emnlovee Oevelonment 101 - 46500 - 44330 Dues/Licenses 350 580 165.7% 230 101 - 46500 - 44370 Trainino/Subsistence 1,320 1.107 83.9% 213 Subtotal 1,670 1,687 101.0% 17 Contractural Service 101 - 46500 - 43010 Professional Services 8,934 6.003 67.2% 2,932 Audit costs 101 - 46500 - 43090 Ann). Software Su ort 4,500 2,332 51.8% 2,168 S rinQbrook software 101 - 46500 - 43091 PC Network Suooort 7,000 3,277 46.8% 3,723 Subtotal 20,434 11,611 56.8% 8,823 Other Services & Charaes 101 - 46500 - 43310 MiJea e Reimbursement 225 5 2.4% 220 101 - 46500 - 44091 Admin. Fees (Bankina, TIF Fee 1,500 464 30.9% 1,036 101 - 46500 - 43240 Mise 91 nfa (91 Subtotal 1,725 560 32.5% 1,165 Total Finance 81,864 32,533 39.7% 49,331 General Fund Exoenditures Adopted 2007 Budaet 6/30/2007 YTO Actual % Budget (Mean 50%\ Variance Comments Planninn & Zoninn Personnel Services 101 - 41910 - 41010 Reaular Office Salaries 88.257 42,276 47.9% 45,981 101 ~ 41910 - 41110 Unused PTO - n/a - 101 - 41910 - 41130 Emnlo er Savin s Match 1,462 677 46.3% 785 101 - 41910 - 41210 PERA Emolover Exoense 5,516 2.744 49.8% 2.772 101 - 41910 - 41220 FICA Ex[}ene 6,752 3,168 46.9% 3.584 101 - 41910 - 41300 Insurance Exnense 10,276 5,108 49.7% 5,168 101 - 41910 - 41310 Life Insurance/L TD/STD 941 378 40.2% 563 Subtotal 113,204 54,352 48.0% 58,852 Sunnlies 101 - 41910 - 42010 Su lies/Accessories - 33 n/a 1:33 101 - 41910 - 42030 Printina 1,300 0.0% 1,300 Subtotal 1,300 33 2.5% 1,267 Communications 101 ~ 41910 - 43210 Tele[}hone - 156 n/a 156 101 - 41910 - 43220 Postaae 1.000 91 9.1% 909 101 - 41910 - 43510 Lenal Notice/Advertisina 600 266 44.3% 334 Subtotal 1,600 512 32.0% 1,088 Emnlovee OeveloDment 101 - 41910 - 44330 Dues/Licenses 2,000 1,787 89.3% 213 101 - 41910 - 44370 Trainin /Subsistence 2,000 0.0% 2.000 101 - 41910 - 43310 Mileaae - 97 n/a 197 101 - 41910 - 44375 Public Official Trainina 500 230 46.0% 270 Subtotal 4,500 2,114 47.0% 2,386 Contractural Service 101 - 41910 - 43010 Professional Services 48.000 1,568 3.3% 46,432 101 - 41910 - 43030 Prof Serv Ennineerinn 942 n/a 942 101 - 41910 - 43040 Prof Serv Le al Fees 4,424 n/a 43,013 101 - 41910 - 43090 Acol. Software Suocort - n/a - Subtotal 48,000 6,934 14.4% 88,503 Other Services & Charnes 101 - 41910 - 43310 Mileaae Reimbursement 800 0.0% 800 101 - 41910 - 44900 Community Proiects 2.000 454 22.7% 1,547 101 - 41910 - 44090 Mise - n/a - Subtotal 2,800 454 16.2% 2,347 Canital Outlav 101 - 41910 - 45700 Office Enuin & Furnishinns 500 0.0% 500 Subtotal 500 - 0.0% 500 Total Planina & Zonina 171,904 64,400 37.5% 154,942 General Fund EXDenditures Adopted 2007 Budaet 6/30/2007 YTD Actual % Budget (Mean 50%) Variance Comments Government BuildinD Personnel Services 101 - 41940 - 41010 Re;:;tJlar Office Salaries 21,483 10.197 47.5% 11,286 101 ~ 41940 - 41020 Overtime Salaries 2,000 789 39.5% 1,211 101 - 41940 - 41040 Temnoraru Em lovees - nla - 101 - 41940 - 41110 Unused PTO - nla - 101 ~ 41940 - 41130 E~r Savin;;$ Match 209 123 58.8% 86 101 ~ 41940 - 41210 PERA E~lo-;er Ex ense 1,468 717 48.8% 751 101 ~ 41940 ~ 41220 FICA Ex ene 1,796 867 48.2% 929 101 ~ 41940 ~ 41300 Insurance Ex ense 2,599 1,248 48.0% 1,352 101 ~ 41940 ~ 41310 Ufe Insurance/L TD/STD 256 80 31.3%1 176 101 ~ 41940 ~ 41410 Paid Une~ment Benefits 361 nla 361 Tom Moore Subtotal 29,811 14,380 48.2% 15,431 Sunnlies 101 - 41940 - 42010 S~es/Accessories 900 397 44.2% 503 Subtotal 900 397 44.2% 503 Communications 101 - 41940 - 43210 Tel~hone/Cell Phone Ch s 22,500 14,785 65.7% 7,715 Subtotal 22,500 14,785 65.7% 7,715 Contractural Service 101 ~ 41940 - 43010 Professional Services 6.168 nla 6,168 101 - 41940 - 43040 Prof Serv Lenal Fees 52.092 nla 43,013 Citv Hall Arbitration/Mediation 101 - 41940 - 43090 Ann!. Software Sunnort nla - Subtotal - 58.260 nla 36,845 Maintenance/Materials 101 - 41940 ~ 42230 Bldll:"/Ground Maintenance 140,000 49,905 35.6% 90.095 101 ~ 41940 ~ 42270 Maint. Materials 1,000 34,102 3410.2% 33,102 Citv Hall reoair costs 101 ~ 41940 ~ 42400 Small Tools/E ui ment 1.000 131 13.1% 869 101 ~ 41940 - 44150 Rentals 1,000 0.0% 1,000 Subtotal 143.000 84,138 58.8% 58,862 Utilities 101 - 41940 - 43810 Electricitv/Gas 34,000 11,403 33.5% 22,597 101 - 41940 - 44010 SanitationlWaste Removal 22,000 9,817 44.6% 12,183 101 - 41940 - 44930 Miscellaneous 2,700 0.0% 2,700 Subtotal 58,700 21,220 36.1% 37,480 Other Services & Charnes 101 - 41940 - 43310 Milea;;e Reimbursement 10 nla '10 101 - 41940 - 44090 Admin Fees 457 nla 1457 101 - 41940 - 44935 Miscellaneous 2.000 18 0.9% 1,982 Subtotal 2.000 485 24.2% 1,515 Ca ital Outla 101 ~ 41940 ~ 45400 Enuinment - nla - 101 - 41940 - 45700 Office -E~ & Fumishinns - 1,123 nla 1,123 Subtotal - 1,123 nla 1,123 Total Government BuildinD 256,911 194,788 75.8% 157,228 General Fund Exoenditures Adopted 2007 Budaet 6/30/2007 YTO Actual % Budget (Mean 50%) Variance Comments Public Safetv S~ies 101 - 42100 - 42170 Misc. ProClrams SUDDlies/Fees - n/a - Subtotal - - n/a - Contractural Service 101 - 42100 - 43010 Professional Services 1,068,972 5,113 -0.5% 1,074,085 101 - 42100 - 43120 Contract Policin 401,553 n/a (401.553 101 - 42100 - 43121 911 Ois atch Services 15,339 n/a 15.339 101 ~ 42100 - 43130 Fire Contract 275,589 n/a 275.589 Subtotal 1,068,972 687,368 64.3% 381,604 Utilities 101 - 42100 - 43810 Electricitv/Gas - n/a - Subtotal - - n/a - Other Services & Charnes 101 - 42100 - 43150 Animal Ord Enforcement 8.000 2.261 28.3% 5,739 101 - 42100 - 44935 Miscellaneous - 100 n/a 100 Subtotal 8,000 2,361 29.5% 5,639 Total Public Safety 1.076,972 689,729 64.0% 387,243 General Fund EXDenditures - . - Protective Insnections Personnel Services 101 - 42400 - 41010 Reaular Office Salaries 139,351 66,694 47.9% 72.657 101 - 42400 - 41110 Unused PTO - nla - 101 - 42400 - 41130 Emnlover Savinns Match 1,949 488 25.0% 1.461 101 - 42400 - 41210 PERA Em 10 er Expense 8.709 4,330 49.7% 4,379 101 - 42400 - 41220 FICA EXDene 10.660 4,784 44.9% 5,876 101 - 42400 - 41300 Insurance Exnense 18.025 9,355 51.9% 8,670 101 - 42400 - 41310 Life InsurancelL TD/STD 1.511 592 39.2% 919 Subtotal 180,205 86,243 47.9% 93,962 Sunnlies 101 - 42400 - 42010 SunnlieslAccessories - - 101 - 42400 - 42030 Printin 300 0.0% 300 Subtotal 300 - 0.0% 300 Communications 101 ~ 42400 - 43210 T ele hone/Cell Phone Charaes 1,000 311 31.1% 689 1 01 ~ 42400 - 43220 Postaae 300 55 18.5% 245 101 - 42400 - 43510 Leaal Notice/Advertisina 200 0.0% 200 Subtotal 1,500 367 24.5% 1,133 Em 10 ee Develooment 101 - 42400 - 44330 DueslLicenses 550 260 47.3% 290 101 - 42400 - 44370 Traininn/Subsistence 3,700 954 25.8% 2,746 Subtotal 4,250 1,214 28.6% 3,036 Contractural Service 101 - 42400 - 43102 Electricallnsnections 15,000 13,171 87.8% 1,829 Subtotal 15,000 13,171 87.8% 1,829 MaintenancelMaterials 101 - 42400 - 44040 Maint. OfVehicleslEnuin 500 0.0% 500 Subtotal 500 - 0.0% 500 Utilities 101 - 42400 - 42120 Motor Fuel 1.000 528 52.8% 472 Subtotal 1.000 528 52.8% 472 Other Services & Charaes 101 - 42400 - 43310 Mileane Reimbursement 150 0.0% 150 101 - 42400 - 44060 Bid . Code Surcharaes 10,000 1,859 18.6% 8,141 101 - 42400 - 44935 Miscellaneous - nla - Subtotal 10,150 1,859 18.3% 8,291 CanitalOutlav 101 - 42400 - 45500 Heaw Machinerv & Auto - nla - 101 . 42400 - 45700 Office EauiD. & Furnishinas 15.000 1,500 10.0% 13,500 Subtotal 15.000 1,500 10.0% 13,500 Total Protective Insoections 227,905 104,882 46.0% 123,023 Adopted 2007 Budaet 6/30/2007 YTO Actual % Budget (Mean 500/. \ Variance Comments General Fund Exoenditures Street Maintenance Adopted 2007 Budaet 6/30/2007 YTD Actual % Budget (Mean 50%\ Variance Comments Personnel Services 101 . 43100 - 41010 Reaular Office Salaries 101,887 46,860 46.0% 55,027 101 . 43100 - 41020 Overtime Salaries 7,000 11.385 162.6% 4,385 101 - 43100 - 41040 Temnorarv Emnlovees 8,000 2.207 27.6% 5.793 101 - 43100.41110 Unused PTO - n/a - 101 - 43100 - 41130 Em lover Savinas Match 70 169 241.6% (99 101 - 43100 - 41210 PERA Emolover Exoense 6,805 3,706 54.5% 3,099 101 - 43100 - 41220 FICA Exnene 8,330 4,620 55.5% 3,710 101 - 43100 - 41300 Insurance Ex ense 15,168 8,372 55.2% 6,796 101 - 43100 . 41310 Life Insurance/L TD/STD 1,251 400 32.0% 851 101 - 43100. 41410 Paid Unemolovment Benefits 1,082 n/a 1,082 Tom Moore 101 - 43100- 42111 Uniform Exnense 750 429 57.2% 321 Subtotal 149,261 79,229 53.1% 70,032 SUDDlies 101 - 43100 - 42010 Sunnlies/Accessories - n/a - 101 - 43100 - 42030 Printin 100 0.0% 100 Subtotal 100 - 0.0% 100 Communications 101 - 43100. 43210 Telenhone/Cell Phone Charaes - 309 n/a 309 Subtotal - 309 n/a 309 Emnlovee Develooment 101 . 43100 - 44330 Dues/Licenses 500 150 30.0% 350 101 . 43100 - 44370 Trainina/Subsistence 2,000 868 43.4% 1,132 Subtotal 2,500 1,018 40.7% 1,483 Contractural Service 101 - 43100 . 43010 Professional Services 16,600 659 4.0% 15,941 101 - 43100. 43030 Prof Serv Enaineerina 29 n/a (29 101 - 43100. 43040 Prof Serv Lenal Fees 27 n/a m 101 - 43100 - 43090 A l. Software Support n/a - Subtotal 16,600 714 4.3% 15.886 Maintenance/Materials 101 - 43100 - 42150 Shon Materials 2,000 500 25.0% 1,500 101 - 43100 - 42230 Blda & Ground Maint 72 n/a 172 101 . 43100 - 42240 Sand, Salt, Roadmix 22,500 19.027 84.6% 3,473 101 - 43100 - 42270 Maint. Materials 14,000 2.289 16.3% 11,711 101 - 43100 - 42400 Small Tools/E ui ment 3,000 491 16.4% 2,509 101 - 43100 - 44033 Seal Coatin IResurfacina 200,000 0.0% 200,000 101 - 43100. 44036 Maint. Of Utilities 4,000 0.0% 4,000 101 - 43100. 44040 Maint. Of Vehicles/E ui ment 12,000 1,472 12.3% 10,528 101 - 43100 - 44150 Rentals 1,750 0.0% 1,750 Subtotal 259,250 23,851 9.2% 235,399 Utilities 101 - 43100 - 42120 Motor Fuel 3,000 2,084 69.5% 916 101 - 43100 - 43810 Electricitv/Gas 26,000 7,074 27.2% 18.926 101 . 43100 - 44010 SanitationlWaste Removal 300 317 105.6% (17 Subtotal 29,300 9,475 32.3% 19,825 Other Services & Char es 101 . 43100 - 43310 Mileaae Reimbursement 200 187 93.6% 13 101 . 43100 - 44935 Miscellaneous 2,000 60 3.0% 1,940 Subtotal 2,200 247 11.2% 1,953 Ca ital Outla 101 . 43100 - 45400 Eauioment - n/a - 101 . 43100 - 45500 Heavv Machinerv & Auto - n/a - 101 - 43100 . 45700 Office E ui . & Furnishinas 150 0.0% 150 Subtotal 150 - 0.0% 150 Total Street Maintenance 459,361 114,842 25.0% 344,519 General Fund EXDenditures Adopted 2007 Budaet 6/30/2007 YTO Actual % Budget {Mean 50%) Variance Comments Parks Maintenance Personnel Services 101 - 45200 - 41010 Reaurar Office Salaries 108,108 48,433 44.8% 59,675 101 - 45200 - 41020 Overtime Salaries - 1,350 n/. 1,350 101 - 45200 - 41040 Tern ora Em loyees 23,000 11,390 49.5% 11,610 101 - 45200 - 41110 Unused PTO - n/. - 101 - 45200 - 41130 Emolover Savinas Match 70 121 172.9% 151 101 - 45200 - 41210 PERA Em[llover EX[lense 6,757 3,190 47.2% 3,567 101 - 45200 - 41220 FICA Ex ene 8,270 4,736 57.3% 3,534 101 - 45200 - 41300 Insurance Ex ense 16,778 7,367 43.9% 9,411 101 - 45200 - 41310 Life lnsurance/L TD/STD 1,350 383 28.4% 967 101 - 43100 - 41410 Paid Unernolovment Benefits 721 n/. (721 Tom Moore 101 - 45200 - 42111 Uniform Exnense 750 429 57.2% 321 Subtotal 165,083 78,119 47.3% 86,964 SUDDlies 101 - 45200 - 42010 Sunnlies/Accessories - n/. - 101 - 45200 - 42030 Printina 500 0.0% 500 Subtotal 500 - 0.0% 500 Communications 101 - 45200 - 43210 Tele hone/Cell Phone Charaes 2,750 816 29.7% 1,934 Subtotal 2,750 816 29.7% 1,934 Emnlovee Develonment 101 - 45200 - 44330 Dues/Licenses 850 450 52.9% 400 101 - 45200 - 44370 Trainina/Subsistence 2,500 461 18.4% 2,039 Subtotal 3,350 911 27.2% 2,440 Contractural Service 101 - 45200 - 43010 Professional Services 6.500 31 0.5% 6,469 101 - 45200 - 43030 Prof Serv Enaineerina 585 n/. 585 101 - 45200 - 43040 Prof Serv Le al Fees 176 n/. 176 101 - 45200 - 44050 TreelWeed Services 32,750 318 1.0% 32,432 Subtotal 39,250 1,110 2.8% 38,140 Maintenance/Materials 101 - 45200 - 42150 Shop Materials 800 495 61.9% 305 101 - 45200 - 42230 Bdla.lGround Maintenance 17,000 6,916 40.7% 10,084 101 - 45200 - 42270 Maint. Materials 12,000 5,503 45.9% 6,497 101 - 45200 - 42400 Small TaolsJE ui ment 1,800 643 35.7% 1,157 101 - 45200 - 44033 Seal Coatina/Resurfacina 13,750 0.0% 13,750 101 - 45200 - 44040 Maint. OfVehicles/Eauioment 4,000 439 11.0% 3,561 101 - 45200 - 44150 Rentals 250 127 50.8% 123 Subtotal 49,600 14,124 28.5% 35,476 Utilities 101 - 45200 - 42120 Motor Fuel 11.500 2,984 26.0% 8,516 101 - 45200 - 43810 Electrici /Gas 12.000 6,454 53.8% 5,546 101 - 45200 - 44010 SanitatianlWaste Removal 5,000 2,372 47.4% 2,628 Subtotal 28,500 11,811 41.4% 16,689 Other Services & Charaes 101 - 45200 - 43310 Milea e Reimbursement 200 48 24.2% 152 101 - 45200 - 44900 Community Pro'ect 500 0.0% 500 101 - 45200 - 44935 Miscellaneous 1,200 0.0% 1,200 Subtotal 1.900 48 2.5% 1,852 Ca'nital Outlav 101 - 45200 - 45400 Eauioment - 922 n/. 1922 101 - 45200 - 45500 Heavv Machinerv & Auto - n/. - 101 - 45200 - 45700 Office Enuin. & Furnishin s 150 0.0% 150 Subtotal 150 922 614.7% (772 Total Parks Maintenance 291,083 107,861 37.1% 183,222 General Fund Exoenditures Adopted 2007 Budaet 6/30/2007 YTD Actual % Budget (Mean 50%) Variance Comments Recreation Personnel Services 101 - 45120 - 41010 Renular Office Salaries 83,181 38,211 45.9% 44,970 101 - 45120 - 41040 Temnorarv Em 10 ees 50,000 16,919 33.8% 33,081 101 - 45120 - 41130 Emolover Savinas Match 1,740 895 51.4% 845 101 - 45120 - 41210 PERA Emolover Exoense 5,199 2.964 57.0% 2,235 101 - 45120 - 41220 FICA Exnene 6,363 4.467 70.2% 1,896 101 - 45120 - 41300 Insurance Ex ense 9,623 4.703 48.9% 4,920 101 - 45120 - 41310 Life Insurance/L TD/STD 911 317 34.8% 594 101 - 45120 - 41410 Paid Unemolovment Benefits 721 n/a 721 Tom Moore Subtotal 157,017 69,198 44.1% 87,819 Su lies 101 - 45120 - 42010 Suoolies/Accessories - 69 n/a (69 101 M 45120 - 42030 Printinn 125 0.0% 125 101 M 45120 - 42170 Misc. Pronrams Su lies/Fees 7,500 3,553 47.4% 3,947 101 M 45120 - 42172 Athletic Sorts Supolies 7,500 3,751 50.0% 3,749 Subtotal 15.125 7,373 48.7% 7,752 Communications 101 - 45120 - 43210 Teleohone/Cell Phone Charaes 650 234 35.9% 416 101 - 45120 - 43220 Postaae 2,900 744 25.7% 2,156 101 - 45120 - 43550 Newsletter Printina/Publishinn 11,000 4.541 41.3% 6,459 Subtotal 14,550 5,518 37.9% 9,032 Emolovee DeveloDment 101 - 45120 - 44330 Dues/Licenses 300 25 8.3% 275 101 - 45120 - 44370 Trainin /Subsistence 700 450 64.3% 250 Subtotal 1,000 475 47.5% 525 Contractural Service 101 M 45120 - 43010 Professional Services 21.000 - 0.0% 21,000 101 M 45120 - 43080 Prof Serv Instructor Fees 8,577 n/a 8,577 101 - 45120 - 43082 Adaotive Rec Proaram Fees n/a - 101 - 45120 - 43090 Ann!. Software Sunoort 7,500 0.0% 7,500 Subtotal 28,500 8,577 30.1% 19,923 Utilities 101 - 45120 - 44010 SanitationlWaste Removal 2,500 549 22.0% 1,951 Subtotal 2,500 549 22.0% 1,951 Other Services & Charaes 101 M 45120 - 43310 Mileane Reimbursement 750 0.0% 750 Subtotal 750 - 0.0% 750 Ca italOutlav 101 - 45120 - 45700 Office Enuin. & Furnishinas - n/a - Subtotal - - n/a - ODeratina Transfers 101 M 45120 - 47212 Transfers Out to proa. Fund - n/a - Subtotal - - n/a - Total Recreation 219,442 91,690 41.8% 127,752 General Fund Excenditures Adopted 2007 Budaet 6/30/2007 YTO Actual % Budget (Mean 50%) Variance Comments Oneratinn Transfers Transfers 101 - 49300 - 47213 Transfer to Recreation - n/a - 101 - 49300 - 47240 Transfer to Blda Fund 408 - n/a - 101 - 49300 - 47242 Transfer to Can Eauin 411 - n/a - 101 - 49300 - 47243 Transfer to Pub Safe 412 140,862 140,862 100.0% - 101 - 49300 ~ 47212 Transfer to Storm Wtr 604 - n/a - 101 - 49300- 47260 Transfer to PIR 501 46,954 46,954 100.0% - Subtotal 187,816 187,816 100.0% - Total 0 eratina Transfers 187,816 187,816 100.0% - Total General Fund 3,473,936 1,821,212 I 52.4%1 1,795,267 Special Revenue Fund Summarv Adopted 6/30/2007 % 2007 TYD Budget Budaet Actual (Mean 50%) Variance Revenue Community Services $ 66,000 $ 28,604 43.3% $ 37,396 Parks 22,750 14,891 65.5% 7,859 Cable 72,500 21,425 29.6% 51,075 TCMP 329,908 n/a (329,908) Risk Management 30,500 4,061 13.3% 26,439 EDA General Activities 20,200 70,107 347.1% (49,907) EDA TIF Distr #2 Round Lake 415,000 219,000 52.8% 196,000 EDA TI F Distr #3 Cottage Villas 50,500 25,407 50.3% 25,093 Total 677,450 713,403 105.3% (35,953) Expenditures Community Services 65,000 65,000 100.0% Parks 123,500 781 0.6% 122,719 Cable 64,554 83,248 129.0% (18,694) TCMP 441,500 143,140 32.4% 298,360 Risk Management 27,000 0.0% 27,000 EDA General Activities 38,449 66,355 172.6% (27,906) EDA TIF Distr#2 Round Lake 284,625 0.0% 284,625 EDA TIF Distr#3 Cottage Villas 43,200 0.0% 43,200 Total 1,087,828 358.524 33.0% 729,304 Total Revenue Over Expenditures $ (410,378) $ 354,879 $ (765,257) SDecial Revenue Funds Revenues Adopted 2007 Budaet 6/30/2007 YTO Actual % Budget {Mean 50%) Variance Comments Community Services Miscellaneous 225 - 0- 36230 Contributions/Franchise Fees 65,000 28.434 43.7% 36.566 Subtotal 65.000 28.434 43.7% 36.666 Interest Income 225 - 0- 36210 Interest Income 1.000 170 17.0% 830 Subtotal 1.000 170 17.0% 830 I Total Community Services 66.000 28.604 43.3% 37.396 Parks Inter overnmental 227 - 0- 33500 Grants 16.750 0.0% 16,750 Subtotal 16.750 - 0.0% 16,750 I Miscellaneious Recei ts 227 - 0- 36230 Contributions/Franchise Fees - - n/a - 227 - 0- 36235 Park Dedication Fees - 12,552 n/a 12.552 Subtotal - 12,552 n/a 12.552 Interest Income 227 - 0- 36210 Interest Income 6,000 2.339 39.0% 3.661 Subtotal 6,000 2.339 39.0% 3,661 I Other Financina Sources 227 - 0- 391 011Transfer from 101 - n/a - I Subtotal - - n/a - I Total Parks 22.750 14.891 65.5% 7.859 Cable Miscellaneous ReceiDts 228 - 0- 36230 I Contributions/Franchise Fees 64,000 18.054 28.2% 45.946 I Subtotal 64,000 18.054 28.2% 45,946 Interest Income 228 - 0- 36210 Interest Income 8.500 3.371 39.7% 5.129 Subtotal 8.500 3.371 39.7% 5.129 I Total Cable 72.500 21.425 29.6% 51.075 TCAAP Miscellaneous Recei ts 229 - 0- 36274 Develooer Reimbursements - 329,520 n/a (329.520 229 - 0- 36270 Misc Reimbursement - n/a - Subtotal - 329.520 n/a (329.520 Interest Income 229 - 0- 36210 Interest Income - 388 n/a (388 Subtotal - 388 n/a (388 I Total TCAAP - 329.908 n/a (329,908 Soecial Revenue Funds Revenues Adopted 2007 Budaet 6/30/2007 YTD Actual % Budget IMean 50%1 Variance Comments Risk Mananement Miscellaneous Recei ts 230 - 0 - 36260 Groun Uabiljtv Ins Dividend 22.000 0.0% 22.000 230 - 0 - 36265 Liabilitv Ins Loss Proceeds - n/a - Subtotal 22.000 - 0.0% 22,000 Interest Income 230 - 0 - 36210 Interest Income 8.500 4.061 47.8% 4,439 Subtotal 8,500 4.061 47.8% 4,439 I Total Risk Manallement 30,500 4.061 13.3% 26,439 EDA General Activities Fund Pro ertu Taxes 701 - 0- 31059 Tax Increment Excess 20.000 7,001 35.0% 12.999 Subtotal 20.000 7,001 35.0% 12.999 Intere overnmental 701 - 0 - 33500 Grants - 50.000 n/a 150.000 Pass thru to Develoner - Subtotal - 50.000 n/a 150,000 I Miscellaneous ReceiDts 701 - 0- 36990 I Sale of Enuinment - n/a - I Subtotal - - - Interest Income 701 - 0- 36210 Interest Income 200 13.105 6552.7% 112.905 Subtotal 200 13,105 6552.7% 112.905 I Total EDA General 20.200 70,107 347.1% 149.907 EDA Bus Revolvina Loan Fund Interest Income I 702 - 0- 36210 Interest Income 5,000 1.811 36.2% 3.189 I Subtotal 5,000 1.811 36.2% 3,189 I Total EDA Revolvina 5.000 1.811 36.2% 3,189 EDA TIF #2 Round Lake Pro e -tv Taxes 704 - 0- 31051 Tax Increment 385.000 212,471 55.2% 172.529 Subtotal 385,000 212,471 55.2% 172.529 Miscellaneous Receh ts 704 - 0- 36990 Sale of Enuinment - n1a - 704 - 0- 36270 Misc Reimbursements - n/a - Subtotal - - n/a - Interest Income 704 - 0- 36210 Interest Income 30,000 6.530 21.8% 23,470 Subtotal 30.000 6.530 21.8% 23,470 Total EOA TIF #2 415.000 219,000 52.8% 196.000 SDecial Revenue Funds Revenues Adopted 2007 Budaet 6/30/2007 YTD Actual % Budget IMean 50%\ Variance Comments EDA TIF #3 cottane Villas Pro e~Taxes 705 - 0- 31051 Tax Increment 48.000 23.997 50.0% 24.003 705 - 0- 33410 State MVHC - - Subtotal 48,000 23.997 50.0% 24.003 Interest Income 705 - 0- 36210 Interest Income 2,500 1.410 56.4% 1.090 Subtotal 2,500 1.410 56.4% 1,090 T Total EDA TIF #3 50,500 25.407 50.3% 25,093 Soecial Revenue Funds EXDenditures Adopted 2007 Budaet 613012007 % YTD Budget Actual [Mean 50% Variance Comments Community Services Ooeratina Transfers 225 - 49020 - 47213 Transfer to Recreation (Park) 39.000 39.000 100.0% - 225 - 49020 - 47243 Transfer to Pub. Safetv 26.000 26.000 100.0% - Subtotal 65.000 65.000 100.0% - Total Community Services 65,000 65.000 100.0% - Parks Contractural Service 227 - 48205 - 43010 Professional Services - 781 nla (781 Subtotal - 781 nla (781 Capital Outlay 227 - 48205 - 45200 Building & Structures 123.500 0.0% 123,500 227 - 48205 - 45800 Construction Contract - nla 227 - 48205 - 45805 Other Proiect Costs - nla Subtotal 123.500 - 0.0% 123,500 Total Parks 123,500 781 0.6%1 122.719 Soecial Revenue Funds Exoenditures Adopted 2007 Budaet 6/30/2007 % YTD Budget Actual (Mean 50% Variance Comments Cable Personnel Services 228 - 49010 - 41010 Re ular Office Salaries 21.929 10,502 47.9% 11.427 228- 49010- 41110 Unused PTO - n/a - 228 - 49010 - 41130 Emolover Savinas Match 467 218 46.6% 249 228 - 49010 - 41210 PERA Em lover Exoense 1.371 682 49.7% 689 228 - 49010 - 41220 FICA Exoene 1.678 816 48.6% 862 228 - 49010 - 41300 Insurance Expense 2,528 1.255 49.6% 1,273 228 - 49010 - 41310 Life Insurance/L TD/STD 281 91 32.3% 190 Subtotal 28,254 13.563 48.0% 14,691 Sunnlies 228 - 49010 - 42010 Sunnlies/Accessories - n/a - Subtotal - - n/a - Emnlovee Develooment 228 - 49010 - 44330 Dues/Licenses 18.600 17,161 92.3% 1,439 Subtotal 18.600 17,161 92.3% 1.439 Contractural Service 228 - 49010 - 43010 Professional Services 3,000 4.075 135.8% 11.075 Laser Fiche TraininQ and Services Subtotal 3,000 4.075 135.8% 1.075 Maintenance/Materials 228 - 49010 - 42270 Maint. Materials 1,200 530 44.1% 670 228 - 49010 - 44040 Maint. Of VehicleslEauio 3.500 1.122 32.1% 2,378 Subtotal 4.700 1.652 35.2% 3,048 CaDital Outlav 228 - 49010 - 45400 Eauioment 10.000 45,378 453.8% 135,378 New AV Eauioment Council Chamber 228 - 49010 - 45700 Office E uio & Furnishin s - 1,418 n/a 11.418 Subtotal 10.000 46.796 468.0% 136.796 Total Cable 64,554 83.248 129.0% 118.694 Soecial Revenue Funds Exoenditures Adopted 2007 Budaet 6/30/2007 % YTD Budget Actual fMean 50% Variance Comments TCAAP Personnel Services 229 - 46400 - 41010 Reaular Office Salaries - 6 n/a 16 229 - 46400 - 41130 Emplover Savinas Match - 0 n/a 10 229 - 46400 - 41210 PERA Employer Expense - (0 n/a 0 229 - 46400 - 41220 FICA Exoene - (10 n/a 10 229 - 46400 - 41300 Insurance Exoense - 115 n/a 15 229 - 46400 - 41310 Life InsurancelL TD/STD - 4 n/a 14 Subtotal - (15 n/a 15 SUDDlies 229 - 46400 - 42010 Supolies/Accessories - g n/a (9 Subtotal - g n/a 19 Communications 229 - 46400 - 43220 Postaae 500 204 40.9% 296 229 - 46400 - 43510 LeQal Notice/AdvertisinQ 500 0.0% 500 229 - 46400 - 43550 Newsletter Printino/Publishina - n/a - Subtotal 1,000 204 20.4% 796 Employee Development 229 - 46400 - 44370 Training/Subsistence 5.000 1.343 26.9% 3.657 Subtotal 5.000 1.343 26.9% 3.657 Contractural Service 229 - 46400 - 43010 Professional Services 435,000 64.538 14.8% 370.462 229 - 46400 - 43030 Prof Serv Enaineer 675 n/a 1675 229 - 46400 - 43040 Prof Serv Leaal Fees 37,674 n/a (37.674 229 - 46400 - 43048 TCAAP Leaal 2,295 n/a (2.295 229 - 46400 - 43050 Fiscal Consultant 30,811 n/a (30.811 229 - 46400 - 43121 TeMP Plan nina-Urban Desian n/a - 229 - 46400 - 43121 TCAAP Plan nino DSU 5,522 n/a 15,522 Subtotal 435.000 141,515 32.5% 293.485 Other Services & Charaes 229 - 46400 - 43310 Mileaae Reimbursement 500 83 16.6% 417 Subtotal 500 83 16.6% 417 Total TCAAP 441.500 143.140 32.4% 298.360 SDecial Revenue Funds EXDenditures Adopted 2007 Budaet 6/30/2007 % YTD Budget Actual [Mean 50% Variance Comments Risk Manaaement Other Services & Charaes 230 - 49240 - 43340 Awards & Indemnities 27,000 0.0% 27,000 Subtotal 27,000 - 0.0% 27,000 Total Risk Manaaement 27,000 - 0.0% 27.000 Soecial Revenue Funds Exoenditures Adopted 2007 Budaet 6/30/2007 % YTD Budget Actual [Mean 50% Variance Comments EDA General Personnel Services 701 - 47300 - 41010 Reaular Office Salaries 26,294 12.418 47.2% 13,876 701 - 47300 - 41130 Erfi[)lover Savinas Match 70 62 88.3% 8 701 - 47300 - 41210 PERA Emnlo\fer Exnense 1,643 801 48.8% 842 701 0 47300 - 41220 FICA Exnene 2,011 866 43.1% 1,145 701 0 47300 - 41300 Insurance Exnense 2,551 1.194 46.8% 1,357 701 0 47300 - 41310 Life Insurance/L TD/STD 180 89 49.4% 91 Subtotal 32,749 15.431 47.1% 17,318 Sunniies 701 - 47300 - 42010 SliODlies/Accessories 200 0.0% 200 Subtotal 200 - 0.0% 200 Communications 701 - 47300 - 43220 posta;;e 500 73 14.5% 427 701 - 47300 - 44910 Miscellaneous 5,000 0.0% 5.000 Subtotal 5,500 73 1.3% 5.427 Em~e Develomnent 701 - 47300 - 44370 Trainil,njSubsistence 264 n/a 1264 701 0 47300 - n/a - Subtotal - 264 n/a (264 Contractural Services 701 - 47300 - 43010 Professional SelVices - n/a 0 Subtotal - - n/a - Other Services & Charnes 701 - 47300 - 44601 State Grant - 50.000 n/a (50,000 Pass thru Grant to Develoner 701 - 47300 - 44910 Miscellaneous - 587 n/a (587 Subtotal - 50,587 n/a 150,587 Canital Outlay 701 - 47300 - 46120 Interfund Loan Interest - n/a - Subtotal - - n/a - Total EDA General 38.449 66,355 172.6% (27,906 Soecial Revenue Funds Exoenditures Adopted 2007 Budoet 6/30/2007 % YTD Budget Actual [Mean 50% Variance Comments TIF District #2 - Round Lake Contractural Service 704 - 47307 - 43010 Professional Services 2.150 0.0% 2.150 Subtotal 2.150 - 0.0% 2.150 Other Services & Charaes 704 - 47307 - 44091 Admin Fees lBankin , TIF Fees 1,300 - 0.0% 1,300 704 - 47307 - 44935 Miscellaneous - nla - Subtotal 1.300 - 0.0% 1,300 Oneratinn Transfers 704 - 47307 - 47285 Transfer to GO Bonds 1998 (32 281,175 0.0% 281,175 Subtotal 281,175 - 0.0% 281.175 Total TIF District #2 - Round Lake 284,625 - 0.0% 284.625 TIF District #3 - Cotta e Villas Contractural Service 705 - 47305 - 43010 Professional Services - nla - 705 - 47305 - 43059 Develooer TIF Payments 43.200 - 0.0% 43.200 Subtotal 43.200 - 0.0% 43.200 Other Services & Charaes 705 - 47305 - 44091 Admin Fees (Bankino, TIF Fees - - nla - Subtotal - - nla - Total TIF District #3 - cottaae Villas 43.200 - 0.0% 43.200 Debt Service Fund Summarv Adopted 6/30/2007 % 2007 TYD Budget BudQet Actual (Mean 50%) Variance Revenue GO TIF Bonds 1998A $ 281,175 $ 281,171 100.0% $ 4 Total 281,175 281.171 100.0% 4 Expenditures GO TIF Bonds 1998A 281,175 249,700 88.8% 31,475 Total 281,175 249,700 88.8% 31,475 Total Revenue Over Expenditures $ - $ 31,471 $ (31,471) Debt Service Funds Revenues Adopted 2007 Budaet 6/30/2007 YTO Actual % Budget {Mean 50%} Variance Comments GO TI Bonds of 1998 Other FinancinnSources 325 - 0 - 39240 Transfer from EDA #704 281.175 281.175 100.0% - 325 - 0- 39310 Bond Proceeds - n/a - Subtotal 281.175 281,175 100.0% - Interest Income 325 - 0 - 36210 Interest Income - 14 n/a 4 Subtotal - 14 n/a 4 T Total Risk Mananement 281,175 281,171 100.0% 4 Debt Service Funds ExDenditures Adopted 2007 Budoet 6/30/2007 % YTD Budget Actual (Mean 50% Variance Comments Debt Service G 0 TI Bonds 1998A . . Other Services & Charnes 325 - 47010 - 43000 Issue Cost - nla - Subtotal - - nla - Canital Outlav 325 - 47010 - 46010 Debt Princinal 215.000 215.000 100.0% - 325 - 47010 - 46110 Interest on Bonds 66.175 34,700 52.4% 31,475 Subtotal 281.175 249,700 88.8% 31,475 Total Debt Service GO TI Bonds 1998A 281.175 249.700 88.8% 31,475 Caoital Fund Summary Adopted 6/30/2007 % 2007 TYD Budget BudClet Actual (Mean 50%\ Variance Revenue Public Safety Capital $ 184,862 $ 174,346 94.3% $ 10,516 Permanent Impr Revolving Fund 401,000 92,101 23.0% 308,899 Total 585,862 266,447 45.5% 319,415 Exoenditures Public Safety Capital 49,309 15,795 32.0% 33,514 Permanent Impr Revolving Fund 918,791 196,034 21.3% 722,757 Total 968,100 211,829 21.9% 756,271 Total Revenue Over Expenditures $ (382,238) $ 54,618 $ (436,856) CaDital Funds Revenues Adopted 2007 Budaet 6/30/2007 YTO Actual % Budget (Mean 50%) Variance Comments Public Safetu Canital Enuinment Other Financinn Sources 412 - 0 - 39101 ~ratjn;:;-Trans from 101 140.862 140.862 100.0% - 412 - 0 - 39230 Oneratinn Trans from 225 26.000 26.000 100.0% - Subtotal 166.862 166.862 100.0% - Interest Income 412 - 0- 36210 Interest Income 18.000 7.484 41.6% 10.516 Subtotal 18.000 7.484 41.6% 10.516 I Total Public Saf~Canital 184.862 174.346 94.3% 10.516 Permanent Im"r Revolvinn Fund Inter overnmental Revenues 501 - 0 - 33418 MSA Construction 176,000 0.0% 176,000 501 - 0- - n/a - Subtotal 176,000 - 0.0% 176.000 Snecial Assessments 501 - 0 - 36100 ~ecial Assessments 296,000 263,436 89.0% 32,564 501 - 0 - 36101 Delinn Snecial Assessments - 1,469 n/a 11,469 501 - 0 - 36102 Pen & Int ~cial Assessments - 146 n/a 1146 Subtotal 296.000 265,052 89.5% 30,948 Interest Income 501 - 0 - 36210 Interest Income 225.000 92,101 40.9% 132,899 Subtotal 225.000 92,101 40.9% 132,899 T Total Permanent Imnr Revolvinn Fun 401.000 92,101 23.0% 308,899 Adopted 2007 Budaet 6/30/2007 % YTD Budget Actual [Mean 50% Variance Comments CaDital Funds Exoenditures Public Safetv Canital Eauinment Other Services & Char as 412 - 48120 - 0 - n/a - Subtotal - - n/a - Caoital Outlav 412 - 48120 - 45400 Eauipment 49.309 13.033 26.4% 36.276 412 - 48120 - 45805 Other Proiect Costs - 2.762 n/a {2.762 Subtotal 49,309 15.795 32.0% 33,514 Total Public Safetv Capital E uiDment 49,309 15,795 32.0% 33,514 Permanent Imnr Revolvina Fund Supplies 501 - 48501 - 42010 SUDolies/Accessories - n/a - Subtotal - - n/a - Communications 501 - 48501 - 43220 Postaae n/a - 501 - 48501 - 43510 Leaal Notice/AdvertisinQ 99 n/a 99 501 - 48501 - 43550 Newsletter Printina/Publishing n/a - Subtotal - 99 n/a 199 Construction Contracts 501 - 48515 - 45800 Contractor Pavrnents 637,791 113.299 17.8% 524,492 Subtotal 637,791 113,299 17.8% 524,492 Contractural Service 501 - 48515 - 43010 Professional Services 633 n/a {633 501 - 48501 - 43030 Prof Serv Enaineer 1,684 n/a (1,684 501 - 48502 - 43030 Prof Serv En ineer 24,590 n/a 124,590 501 - 48503 - 43030 Prof Serv Enqineer 444 n/a {444 501 - 48515 - 43030 Contractual Services 54.644 n/a {54.644 501 - 48501 - 43030 Prof Serv Enaineer n/a - 501 - 48501 - 43040 Prof Serv Leaal Fees n/a - 501 - 48501 - 43048 TCMP Leaal n/a - 501 - 48501 - 43050 Fiscal Consultant n/a - 501 - 48501 - 43121 TeMP Plannina-Urban Desion n/a - 501 - 48501 - 43121 TCMP Plannino DSU n/a - Subtotal - 81,996 n/a 181,996 Maintenance/Materials 501 - 48515 - 42230 Blda & Ground Maintenenace 135 n/a (135 Subtotal - 135 n/a 1135 Other Services & Charaes 501 - 48501 - 44090 Other Charaes 505 n/a (505 Subtotal - 505 n/a {505 Capital Outlav 501 - 48515 - 45200 Buildinas & Structures 150.000 0.0% 150,000 501 - 48515 - 45400 Enuipment 26,000 0.0% 26,000 501 - 48515 - 45500 Heaw Machinerv & Auto 105,000 0.0% 105.000 Subtotal 281.000 - 0.0% 281.000 Total Permanent ImDr Revolvina Fund 918.791 196,034 21.3% 723.397 Enterprise Funds Summary Adopted 6/30/2007 % 2007 TYD Budget BudQet Actual {Mean 50%1 Variance Revenue Water Utility $ 1,343,900 $ 348,175 25.9% $ 995,725 Sewer Utility 1,167,250 517,001 44.3% 650,249 Recycling 83,750 52,485 62.7% 31,265 Surface Water Management 401,500 157,952 39.3% 243,548 Total 2,996,400 1,075,613 35.9% 1,920,787 Expenditures Water Utility 1,394,603 413,033 29.6% 981,570 Sewer Utility 1.312,082 530,968 40.5% 781,114 Recycling 85,655 37,585 43.9% 48,070 Surface Water Management 242,927 88.308 36.4% 154,619 Total 3,035,267 1,069,894 35.2% 1,965,373 Total Revenue Over Expenditures $ (38,867) $ 5,719 $ (44,586) EnterDrise Funds Revenues Water Utilitv Pro ertv Taxes I 601 - 0- I - n/a - I Subtotal - - n/a - Licenses & Permits 601 - 0 - 32270 Permit Fees 1,800 285 15.8% 1.515 Subtotal 1.800 285 15.8% 1.515 I Miscellaneous Recei ts 601 - 0- 36100 Soedal Assessments - 6.891 n/a 16.891 601 - 0- 36101 Sneei Assess Del Utility - 761 n/a 761 601 - 0- 36101 Pen & Int Delina Assessments 350 204 58.2% 146 601 - 0- 36270 Mise Reimbursements - - n/a - 601 - 0- 36990 Sale of Eaui ment - n/a - Subtotal 350 7,856 2244.6% 17,506 Utili Billln Receints 601 - 0- 37100 Utility Sillinas 1,150.000 265.648 23.1% 884.352 Lao from billin to reconnition 601 - 0- 37110 Standbv Charaes 130.000 50.117 38.6% 79.883 601 - 0- 37120 Late Charaes 5.000 4.824 96.5% 176 601 - 0- 37130 MDH Water Test Fees 12.000 4.362 36.3% 7.638 601 - 0- 37140 Sales Tax 13.500 5.336 39.5% 8.164 601 - 0- 37160 connection Reoair Fees - 80 n/a 180 601 - 0- 37170 Hvdrant Rental - n/a - 601 - 0- 37180 Meter Deoosits 3,000 1,110 37.0% 1,890 601 - 0- 37190 Water Meter Uoarade Serv Ch 250 0.0% 250 Subtotal 1.313.750 331.477 25.2% 982.273 Interest Income 601 - 0- 36210 Interest Income 28.000 8.556 30.6% 19.444 Subtotal 28.000 8.556 30.6% 19.444 Other Financin Sources 601 - 0- 36200 Transfer In - n/a - I Subtotal - - nia - I Total Water Utilitv 1,343.900 348.175 25.9% 995.725 Adopted 2007 Budaet 6/30/2007 YTO Actual % Budget (Mean 50%) Variance Comments EnterDrise Funds Revenues Adopted 2007 Budaet 6/30/2007 YTO Actual % Budget (Mean 50%) Variance Comments Sewer Utility Pro ertv Taxes I - 0- I - n/a - I Subtotal - - nla - Licenses & Permits 602 - 0- 32270 Permit Fees 850 455 53.5% 395 Subtotal 850 455 53.5% 395 I Miscellaneous Rece! ts 602 - 0- 36100 Special Assessments - 8,159 n/a (8.159 602 - 0- 36196 Soeci Assess Del Utility 11.000 808 7.3% 10.192 602 - 0- 31900 Penalties and Interest 400 210 52.4% 190 602 - 0- 36990 Sale of Eauioment - n/a - Subtotal 11,400 9.177 80,5% 2.223 I Utili Billin Receipts 602 - 0- 37100 Utility Billinas 1,100,000 370.567 33.7% 729.433 Lao from billina to recoanition 602 - 0- 37120 Late Charges 20,000 249 1.2% 19.751 602 - 0- 37160 Connection Reoair Fees - 300 nta 300 602 - 0- 37271 SAC Charaes 25,000 132.325 529.3% (107.325 Subtotal 1,145,000 503.441 44.0% 641,559 Interest Income 602 - 0- 36210 Interest Income 10,000 3.928 39.3% 6,072 Subtotal 10,000 3,928 39.3% 6.072 I Other Financln Sources 602 - 0- 36200 Transfer In - n/a - 602 0 39998 Prior Period Ad' n/a Subtotal - - n/a - I Total Sewer Utility 1.167,250 517,001 44.3% 650,249 EnterDrise Funds Revenues Rec\lclln" Pro ertv Taxes I - 0- I - n/a - I Subtotal - - n/a - Inter overnmental 603 - 0- 33620 County Aid-Recvclina 18.000 18.396 102.2% f396 Subtotal 18.000 18.396 102.2% 1396 I Miscellaneous Recei ts 603 - 0- 36100 Soecial Assessments 65.000 33.055 50.9% 31,945 603 - 0- 36196 Soeci Assess Del Utilitv 333 n/a 1333 603 - 0- 31900 Penalties and Interest - 61 n/a '61 603 - 0- 36199 Recvclino Service Fee n/a - 603 - 0- 36270 Misc Reimbursement - 72 n/a '72 Subtotal 65,000 33.520 51.6% 31,480 Interest Income 603 - 0 - 36210 Interest Income 750 569 75.8% 181 Subtotal 750 569 75.8% 181 I Total Recvclino 83,750 52,485 62.7% 31,265 Adopted 2007 Budaet 6/30/2007 YTD Actual % Budget (Mean 50%) Variance Comments Enterorise Funds Revenues Adopted 2007 Budaet 6/30/2007 YTO Actual % Budget {Mean 50%) Variance Comments Surface Water Mana ement Pro e;::h;'"" Taxes 604 - 0- 31010 General Pron Taxes - 6.099 nla (6,099 604 0 31020 Delin;;-Ad Valorem Taxes 2 n/a 12 604 - 0- 31040 Fiscal Disnarities 0 781 nla 781 0 Subtotal 0 6.882 nla (6.882 Inter overnmental 6040 00 33418 MSA Construction - n/a - Subtotal - 0 n/a - I I Utili Billin Rece~ts 604 - 0- 36100 8necial Assessment - 1,711 n/a (1.711 6040 0- 36196 &\ecial Assessment Del - 80 n/a 180 604 0 31900 Penaltv/lnt 8n Assessments 10 n/a 604 - 0- 37100 Utilitv Billinns 400,000 148.080 37.0% 251.920 Lan from billinn to recoqnition 604 - 0- 37120 Late Char;;es 1,500 324 21.6% 1.176 Subtotal 401,500 150.205 37.4% 251.305 Interest Income 6040 0- 36210 Interest Income - 865 n/a 865 Subtotal - 865 n/a 865 Interest Income 604 - o - 39200 Transfer In 0 n/a 0 6040 o 0 39998 Prior Period AdT - n/a - Subtotal 0 - n/a 0 T Total Recvclinn 401.500 157,952 39.3% 243,558 Enterorise Funds EXDendltures Adopted 2007 Budaet 613012007 % YTD Budget Actual (Mean 50% Variance Comments Water Personnel Services 601 - 49440 - 41010 R ular Office Salarias 163,883 68,606 41.9% 95,277 601 - 49440 - 41020 Overtime Salaries 10,000 8,873 88.7% 1127 601 - 49440 - 41040 Tern or Em 10 ees 8,500 2,524 29.7% 5,976 601 - 49440 - 41110 UnusedPTO 1231 2,091 169.9% 860 Utllit Billin ClerkPa Out 601 - 49440 - 41130 Em fo erSavin sMatch 710 640 90.1% 70 601 - 49440 - 41210 PERA Em 10 er Ex ense 10,868 5,140 47.3% 5,728 601 - 49440 - 41220 FICA Ex ena 13302 6576 49.4% 6,726 601 - 49440 - 41300 Insurance Ex ense 23,190 11,235 48.4% 11955 601 - 49440 - 41310 Life Insurance/L TD/STD 1,886 624 33.1% 1,262 601 - 49440 - 41410 PaidUnem 10 entBanafrts 1803 of, 1,803 Tom Moore 601 - 49440 - 41510 Worker's Com InsPrem 11,500 11815 102.7% 315 601 - 49440 - 42111 Uniform Ex anse 750 429 57.2% 321 Subtotal 245,820 120,356 49.0% 125,464 So lies 601 - 49440 - 42010 So lies/Accessories 1,400 0.0% 1,400 601 - 49440 - 42030 Printin 1,200 0.0% 1,200 Subtotal 2,600 - 0.0% 2,600 Communications 601 - 49440 - 43210 Tele hone/CellPhoneCha " - 2631 of, 2,631 601 - 49440 - 43220 Posta e 2,300 "" 24.7% 1,733 601 - 49440 - 43510 Le al Notice/Advertisin 112 of, 112 Subtotal 2,300 3310 143.9% 1,010 Em ]0 ee Deve]o ment 601 - 49440 - 44330 Dues/Licenses 1,000 492 49.2% 508 601 . 49440 - 44370 Trainin Subsistence 2,500 983 39.3% 1,517 Subtotal 3500 1,475 42.1% 2,025 Contractural Service 601 . 49440 - 4301 0 Professional Services 19,333 6,265 32.4% 13,068 601 - 49440 - 43090 A I. SoftwareSu ort 5,300 3,184 60.1% 2116 601 - 49440 - 43091 PC Network Su ort 7,000 956 13.7% 6,044 Subtotal 31633 10,405 32.9% 21,228 Maintenance/Materials 601 - 49440 . 42150 Sho Materials 600 495 82.6% 105 601 - 49440 - 42230 BI & Ground Maintanance 58 of, 58 601 - 49440 - 42270 Mainl.Materials 46,500 3,891 8.4% 42609 601 - 49440 - 42400 Small ToolslE ui ment 900 451 50.1% 449 601 - 49440 - 44036 Maint Of Utilities 5,000 0.0% 5,000 601 - 49440 - 44040 Maint. Of Vahicles/E ui ment 1.000 324 32.4% 676 601 - 49440 - 44150 Rentals 250 0.0% 250 Subtotal 54,250 5,218 9.6% 49,032 Utilities 601 - 49440 - 42120 Motor Fuel 15,000 3,991 26.6% 11009 601 - 49440 - 43810 Electrici /Gas 18,750 6,470 34.5% 12,280 601 - 49440 - 43820 Water Purchases 840,000 170975 20.4% 669,025 601 - 49440 . 43825 Water Testin Go her Fees 21500 13,096 60.9% 8,404 Subtotal 895,250 194,533 21.7% 700,717 Other Services & Cha " 601 - 49440 - 43310 Mites e Reimbursement 100 24 24.1% 76 601 - 49440 - 43610 Pro ert &Liabiiit Ins 23,000 22,844 99.3% 156 601 - 49440 - 44200 De reciation 90,000 0.0% 90,000 601 - 49440 - 44390 Salas Tax 15000 7,023 46.8% 7977 601 - 49440 - 44935 Miscellaneous 1,000 248 24.8% 752 Subtotal 129,100 30139 23.3% 98,961 Ca italOutla 601 . 49440 - 45700 OfficeE ui .&Fumishin s 150 0.0% 150 601 - 49440 - 45800 ConstructionConlract 17,596 of, 17596 PartofCa italOutla CIP Subtotal 150 17,596 11731.0% 17,446 o eratin Transfers 601 - 49440 - 47200 Transfer to Genera] Fund 101 30,000 30000 100.0% Subtotal 30,000 30,000 100.0% Total Water 1,394,603 413,033 29.6% 981,570 Capital Outlay (CIP) 135,000 - r--o:D%I 135,000 Enterorise Funds Exoenditures Adopted 2007 Budaet 6/3012007 % YlD Budget Actual tMean 50% Variance Comments Sanitaru Sewer - - - Personnel Services 602 - 49490 - 41010 R ular Office Salaries 186794 80,952 43.3% 105,842 602 - 49490 - 41020 Overtime Salaries 20,000 9,174 45.9% 10826 602 - 49490 - 41040 Tern ora Em 1 '" 8,000 2524 31.6% 5,476 602 - 49490 - 41110 UnusedPTO 1231 2091 169.9% 860 Util. 8illin ClerkP 0" 602 - 49490 - 41130 Em 10 erSavi sMatch 710 640 90.1% 70 602 - 49490 - 41210 PERAEm 10 erE ense 12,925 5,807 44.9% 7,118 602 - 49490 - 41220 FICA Ex ene 15,820 7.386 45.7% 8434 602 - 49490 - 41300 Insurance E ense 26934 12632 45.9% 14,302 602 - 49490 - 41310 Life InsuranceJL lDlSTD 2,186 699 32.0% 1,487 602 - 49490 - 41410 PaidUnem 10 entBenefits 1,803 01, 1,803 Tom Moore 602 ~ 49490 - 41510 Worker's Com InsPrem 11500 11,815 102.7% 315 602- 49490- 42111 Uniform Ex ense 750 429 57.2% 321 Subtotal 286850 135952 47.4% 150,896 5, lies 602 - 49490 - 42010 S, lieslAccessories 1,350 855 63.3% 495 602 - 49490 - 42030 Printin 1,000 0.0% 1,000 Subtotal 2350 855 36.4% 1,495 Communications 602 - 49490 - 43210 Tele honeJCell Phone Cha ~ 2631 01, 2,631 602 - 49490 - 43220 Posta e 2300 567 24.7% 1,733 Subtotal 2,300 3,198 139.0% 898 Em 10 ee Develo ment 602 - 49490 - 44330 DuesfUcenses 1,000 1,038 103.8% 38 602 - 49490 - 44370 Trainin ISubsistence 2,500 983 39.3% 1517 Subtotal 3,500 2,021 57.7% 1,479 Contractural Service 602 - 49490 - 43010 Professional Services 28333 6,051 21.4% 22,282 602 - 48504 - 43030 ProfServEn rnearin 377 01, 377 602 - 49490 - 43030 ProfServEn ineerin 1,104 01, 1,104 602 - 49490 - 43040 ProfServLe alFees 186 01, 186 602 - 49490 - 43090 I. SoftwareSu ort 5,3OD 2,332 44.0% 2,968 602 - 49490 ~ 43091 PC Network Su ort 7000 956 13.7% 6,044 Subtotal 40,633 11,004 27.1% 29629 Maintenance/Materials 602 - 49490 - 42150 Sho Materials 500 496 99.1% 5 602 - 49490 - 42270 Maint.Materials 10,000 3,594 35.9% 6406 602 - 49490 - 42400 Small Tools/E ui ment 3,000 444 14.8% 2,556 602 - 49490. 44036 Maint. Of Utilities 30,000 0.0% 30,000 602 ~ 49490 - 44040 Maint. Of VehicleslE ui ment 5000 620 12.4% 4,360 602 - 49490 - 44150 Rentals 1,000 0.0% 1,000 Subtotal 49500 5,153 10.4% 44,347 Utilities 602 - 49490 - 42120 Motor Fuel 4,000 1,352 33.8% 2648 602 - 49490 - 43810 Electrici {Gas 28,800 8328 28.9% 20,472 602 - 49490 ~ 43815 Electrici -LiftStations 951 01, 951 602 - 49490 - 44010 SanitationlWaste Removal 01, Subtotal 32,800 10631 32.4% 22,169 Other Services & Cha ~ 602 - 49490 - 43310 Milea a Reimbursement 150 31 20.9% 119 602 - 49490 - 4361 0 Pro ert &LiabiHt Ins 23,000 22,844 99.3% 156 602 - 49490 - 43862 Wastewater Char es 691,624 295,807 42.8% 395817 602 - 49490 - 43865 SAC Reimbursements 25,000 4,434 -17.7% 29,434 602 - 49490 - 44200 De redaUon 123,225 0.0% 123,225 602 - 49490 - 44935 Miscellaneous 1,000 98 9.8% 902 Subtotal 863999 314,347 36.4% 549652 Ca ltalOutla 602 - 49490 - 45700 OfficeE ui . & Fumishin s 150 0.0% 150 602 - 49490 - 45800 ConstructionConlract . 17806 01, 17,806 Ca ilalOutla CIP Subtotal 150 17,806 11870.9% 17656 o eratin Transfers 602 - 49490 - 47200 Transfer to General Fund 101 30,000 30,000 100.0% Subtotal 30000 30,000 100.0% TotalSanita Sewer 1,312,082 530968 40.5% 781,114 Cap~al Outlay (CIP) 120,100 - CQ]ill 120,100 Enterorise Funds Exoendltures Adopted 2007 Budaet 6/30/2007 % YTD Budget Actual {Mean 50",1, Variance Comments R"""clinll Personnel Services 603 - 49520 - 41010 R ular Office Salaries 7,421 3,347 45.1% 4,074 603 - 49520 - 41020 Overtime Salaries 01. 603 - 49520 - 41110 Unused PTO - 01. 603 - 49520 . 41130 Em 10 er Savin s Match 104 42 40.1% 62 603 - 49520 - 41210 PERA Em 10 er Ex ense 464 215 46.3% 249 603 . 49520 - 41220 FICA Ex ene 568 250 44.0% 318 603 - 49520 - 41300 Insurance Ex ense 963 478 49.5% 487 603 - 49520. 41310 Life InsurancelL TDfSTD 85 30 35.0% 55 Subtotal 9605 4,359 45.4% 5,246 S" lies 603 . 49520 - 42010 S" Jies/Accessories 01. Subtotal 01. Em 10 ee Develo men! 603 - 49520 - 44330 DuesfLicenses 01. 603 . 49520 - 44370 Trainin Subsistence - 19 01. ,. Subtotal - ,. 01. ,. Contractual Services 603 - 49520 - 43010 Professional Services 17 01. 17 603 - 49520. oIa - Subtotal 17 01. 17 Utilities 603 - 49520 - 43540 Res.Rec lin Costs 70,000 32746 46.8% 37254 603 . 49520 - 44010 SanilationfWaste Removal 6,000 436 7.3% 5,564 Subtotal 76,000 33182 43.7% 42,818 Other Services & Char .. 603 - 49520 - 43310 Milea eReimbursement 50 0.0% 50 603 - 49520 - 44915 Miscellaneous 8 01. 8 Subtotal 50 8 15.1% 42 Total Re clin 85,655 37,585 43.9% 48,070 EntemrisB Funds Exoenditures Adopted 2007 Budaet 613012007 % Y1D Budget Actual IMean 50% Variance Comments Surface Water Mana ement Personnel Services 604 - 43150 - 41010 R ular Qffice Salaries 73155 33,568 45,9% 39,587 604 - 43150 - 41020 OvertimeSa!aries 1,000 16 1.6% 964 604 - 43150. 41040 Tern ora Em 10 aas 1,000 1,908 190.8% 908 604 - 43150 - 41110 UnusedPTO S54 1,001 180.6% 447 Util~ Billin ClerkPa Out 604 - 43150 - 41130 Em 10 er Savin s Match 104 160 153,8% 66 604 . 43150 - 41210 PERA Em 10 er Ex ense 4635 2,142 46.2% 2493 604 - 43150 - 41220 FICA Ex ene 5,673 2795 49.3% 2,878 604 - 43150. 41300 Insurance Ex anse 11,077 4,846 43.7% 6,231 604 - 43150 - 41310 Life lnsurance/L TO/STO 896 272 30.3% 624 604. 43150 - 41410 Paid Unem 10 entBenefrts 721 nla 721 Tom Moore 604 - 43150. 42111 Uniform Ex ense 270 nla 270 Subtotal 98094 47,699 48.6% 50,395 Su lies 604 - 43150- 42030 Printin 1,750 0.0% 1,750 604 - 43150- 43510 Le alNoticesfAdvertisin 10 nla 10 Subtotal 1750 10 0.6% 1,740 Communications 604 - 43150 - 43210 Tele hone/Cell Phone Char as 245 nla 245 604 - 43150 - 43220 Posta e nla - Subtotal 245 nla 245 Em 10 ee Develo ment 604 - 43150 - 44330 Dues/Licenses 665 0.0% 665 604 - 43150. 44370 Trainin Subsistence 1,000 427 42.7% 573 Subtotal 1665 427 25,7% 1,238 Contractural Service 604. 43150 - 43010 Professional Services 15,000 230 1.5% 14,770 604 - 43150 - 43030 ProfServEn ineerin 286 nla 296 604 - 48502 - 43030 ProfServEn ineerin 57 nla 57 Subtotal 15,000 573 3.8% 14.427 Maintenance/Materials 604 - 43150 - 42150 Sho Materials 300 82 27.2% 218 604 - 43150 - 42270 Maint.Materials 5,000 0,0% 5,000 604 - 43150 - 42400 Small ToolsfE ui ment 1000 281 28.1% 719 604 - 43150 - 44036 Maint. Of Utilities 34,000 0.0% 34,000 604 - 43150. 44040 Maint. Of VehiclesfE ui ment 236 nla 236 604 - 43150 - 44150 Rentals 1000 0.0% 1,000 Subtotal 41300 596 1.4% 40702 Other Services & Cha '" 604 - 43150 - 44200 De reciation 35,118 0.0% 35,118 604 - 43150 - 44935 Miscellaneous 8 nla 8 Subtotal 35,118 8 0.0% 35,110 Ca italOutla 604 - 43150 - 45200 Buildin s & Structures 50000 0,0% 50,000 604 - 43150 - 45800 Construction Contract 38748 nla 38,748 PartofCa ltalOuUa CIP Subtotal 50,000 38,748 77.5% 11,252 TotalSanita Sewer 242,927 88,308 36.4% 154,619 Capital Outlay (CIP) 70,000 -~ 70,000