Loading...
B. 2nd Quarter Budget & Investment Update MEMORANDUM TO: Mayor & City Council Members CITY OF FROM: Greg Sticha, Finance Director J CH"NH""SEN DATE: July 26, 2010 7700 Market Boulevard 0 PO Box 147 SUBJ: Second Quarter 2010 Budget & Investment Update Chanhassen, MN 55317 Administration BACKGROUND Phone: 952227.1100 Fax: 952.227.1110 In an effort to keep the City Council informed of the city's financial position, staff will review the current status of the 2010 revenue and expenditure budgets Building Inspections and recap the city's investment portfolio at the work session. Phone: 952.227.1180 Fax: 952.227.1190 2010 BUDGET Engineering Phone: 952.227.1160 Revenues: Half -way through the year, revenues are on- target for all revenue Fax: 952.227.1170 line items. As you are aware, the building permit revenues are being closely monitored this year. As of June 30, building permit revenue has collected 55% Finance of the total budget. Attached is a bar graph showing the historical trend of Phone: 952.227.1140 Fax: 952227.1110 permit revenues at the half -way point in the year. In addition, attached is the budget versus actual revenue report for your review. Park & Recreation Phone: 952.227,1120 Expenditures: As of June 30, expenditures have been 45% spent. It appears Fax: 952.227.1110 there are no line items currently expected to significantly exceed budget in 2010. Therefore, in summary, it appears both revenues and expenditures are tracking Recreation Center with the originally adopted budgets. 2310 Coulter Boulevard Phone: 952.227,1400 Fax: 952.227.1404 INVESTMENTS Planning & Attached is a summary of the city's investments. Staff will briefly go over the Natural Resources information and answer any questions you may have on Monday night. Phone: 952.227.1130 Fax: 952.227,1110 The average yield at cost for the portfolio as of June 30, 2010 is 1.59 %, which is Public Works a very attractive rate of return in the current environment. There are a number 1591 Park Road of other indicators and information about the portfolio included in the summary, Phone: 952.227.1300 and I will be happy to answer any of your questions at the meeting. Fax: 952.227.1310 ATTACHMENTS Senior Center Phone: 952227.1125 1. Permit Revenue Historical Information Bar Chart Fax: 952.227.1110 2. Investment Portfolio Summary Web Site 3. Budget vs. Actual Revenue & Expense General Fund www.ci.chanhassen.mn.us f: \gregs \quartely council updates\2nd2010.docx Chanhassen is a Community for Life - Providing for Today and Planning for Tomorrow N W - In --.1 Co lD 0 0 O O O O O O O O O O O O O O O O in O O O O O O O O O Ni 11 1/1. cn O f ..J N O W f 1 A I I ■ W Co N (n 1 C to ■ lrl ■ CO v 10 ■ I 1 1 1 MD B O 1 v* rn xl NJ O C A N C N 1 O v O y F in P ' f A 00 O N • O to en O co yII O N N C fl_ v CD Z N Q O 0 C ' ;Ks N O O A i-+ J 1 D w E'' c E n, v C O N t CD n o a -� v, v, j .� N W ^ u N ( N 3 E-r m • n ' 1�1 Ctl �o al o o C o CO rr PLE 0 0 'Y S p� 7 N Hrl m y O c c n c c 3 1"1 CO C� • I O N N r-1. l 3 c Oil o ( m N f n o m 7�� 11111 fl 11 0 ? < 7 l 1--'/ z d 01 m 3 N N m = a a r......4 rn 7 1 (D > > `° m a V1 a 2 D o Q O ei. C / z m 1 11 !° ,..D 3 a D n a En N 1 m crt NaP 03c FD ,_ ±:14 3 m v a c o . g lill 7 n -I N fD a n a c m CA a rr cu - v n EL al (T) N lm/, - m P , n o(0 NCO id 1 - 1 o ; N (D m N 01 o ‘111 C n) c a < v ° O ( p o 3 E 0 7 C. a m > >- o u 3 �o m • et ° N N N 0 v) v C M a a m 1 3rr�� �C CA d LaV) s r a N _ O n N o— a (D rmi a - m n N 1 N 2r, O C � rr N (D r 3- n o m s o • ( _ 1 1 _ - m 3 c ` C T (p O1 nq � ' _ Zo tcl m ii 02 a) 7 a Q° N 7 O y n a o n ( n ° �o 3 a 3 X ° c v -o O Q C j o ■ 7 n 0 N pI S 1, 121 C (n 7 cu • 7 rr 0 CU `< i . DJ O D N� � r O re v, N ,? c 3 0 cn Q N 7 in 0 ♦ o a CU m 9 (D co d N rr 3 n () al n o c o ~ m - m 0 3 (A — tO m m a 0 M7 1 N m n o N ° N v M ► S r m r 0 n L ED 0 • n -. __, 2 o _, --I o — v r) O 71 71 0 o iii = m g 3 x d n r C D 0 :° _ ■ y (11 co c < D = v D T c m • (n D N• c) > > D o m o Z _ < C z . 0. 0 � m m < m F o m D c D m o D m 9 0 0 _ v 3 m CD �a m m v 0 CD 6 = r c a m r < m F < v cn> o a 3 ca m E. ; � c o � o o m m 5 m m C O O O --. 73 0 < y X . O C C O C . T • co .N. O o ( B N 7 N a y K 5 O cc co co a a O N M m A va EA cn y w O O cb o EA EA 0) 13 N O A O � O (T N V O V N A Ul A �''� N V N "< J CO CO N V CO V O W o C OO N 0. N W (P ^.l .1 CD N N i/ . r r 0cn a) tl n 0 ti7 u) • • %PORTFOLIO o c n 0 O 0 0 o 0 0 Wi o $ o N A o O O O O O O o O O O T 1 Ip D I c 2 Z () 2 o E D --I i 11 cn i s • _ k n 15 m ° - •-i r... , Z g lit i'''s m ern\ JJ • { 5. 0 1 P e N N al °/PORTFOLIO C -i N W A U' S O O O O O O O O O O O O O Z Z 0 C M ■ m O n q Z o m 8 v_ r W R x w w CO w n 13 o o ' o ' o ( CO ° B O O o m m , / � � O A A CO Jr, 01 . 0) N S m C) O N ( O J 0 Z y 2 D 69 o1 m m ( A A tN0 01 J A o 'Z . ((0 ▪ CO N V 0 N N E ?.+ O U) N O) N N C t» (H EA EA ( 0 (0 . E O "� A A A N W w A C O 0 01 O W d (00 0 0 10 ( 0 (P 0 3 CO N O O) N 01 o 6 0 m 0 0 0 0 0 0 < ( 10 0 N CO O O V - m O ' � N < I m O O O 0 O O O p O� (o OV -` O ( < � ry I D o — — o o — — a .8 ° a � w ° m C 0 0 0 <3 w° rn ° w o n it - N N co co CO CO n ( ( CD N Cr) 0 V N 0 y 0 O K I A � x 0 w w w w w w w g O N IV O) A O) (31 0 < (0 w O) N 0 0 A . O O 0 N N N N Y. < V I Vl N fT W (0 A A m (0 - CO CO CO A O 0 0 Z z z > d D Ec 0 N N W N (0 CO V o N - N O CO 0 - N m O G . d .. 1 U: a N A ((0 - -.I CO 0 CO O V CO N II 11 N _ pp pp _ ((�� _ (_�� {p ((pp _ {{pp �tpp �p + N + m t / V S O O S O fAll m$ O$ N o tl) m tp S 0 0 0 tp tp m m O tip O t J V O V V V V V V v 0 W O A O - pG O O pm� O O O O tp O p� O O tp W k T sl' ll' O o 0 W' O W W m W pVi m S T O+ A 2.3 N top W A A A 0 N * n p � m N N S N N W W W (� � N W J t_D twi pNO twit w N N 2 ONC 2 yy T W po pp pp V s m t 1 ��( xmt, o W fffVfffnnnnnn m x � A+ O)AA 00 0 N . 0 0 p 2 O T.mC cAE - q, -, p (, @ 8 5w M I % w j,2 3000 m p.p C N 5 ! x o o , - tr g mc m t. Xoommm < -o8o = O � tONt_�NAmw mc�a�Z rT3xNyvvoTm< +8w T T T T m T T T m T T N .� T T T T V T T Z T T m T T p n n F Z 3 A mmmm m m mmm m mmmm _D m - m m D vvvm m m mz1 0000pn mT o v * _ mmmm ,O y p p m m m m m Z x -mmm m� T m m m-1 p m q F A A PPPPp PP m 7mc PP°° n T)E)6 = O Z x x Z o m x m x o x x o p w x x x x C m w ( p r 1 x m Z z x w z z J 3 O m m r m ^v x9 m m D di m m m z m m m m m 'n -i 0 2 p x m z 3- m, z m T� m p r, 0 m N m 00�ai c)czm Zrr T DF m,o Oxc�mrpDomTpPm c 0) Z yyyy yy zzrz m�x o > <�c>mrnmmm �+ ZZ � m nm ZT m . RIRCi celx 3Z mgmaza x m m m m T. m N O m O z o O m m Z o Z C c V Z V/ z A LL ? z z m c10s0 z m rDD n i n < z v y l z m m N . A m N y m D D x p X z .,›m0 m O N m 09 D p yy i < ms z Z D xZ D O M D >>>> D D D D D >>>> D D D 0000. . . . 004��4�Gl )4)G) { ,„,--„,"„›››„„›,,,,x.„)„,„›,,,>>>>>>>›,›,.. 2< W N W p N � t + N N N N to A + W A + A + A N Vt A ( w � p w w tJ A w tp 8 A 8 A .c. t.� p A A t t t p O t A � O + + to 0 + ( .1 t40 (( ( (�� O 40 t (0 40 g t 4 p p Q n1 tpV(Qj.J1 S t 10 t 10 f 10 g $�� (p t Nt �� O 0 W S O (0 t�� 8 0 0 0 O g O O O O O O O V O O O ?5,, N O O O S 0 O O S V V 0 O O O S O O. 0 o o+ O + ++ 00++0000++00 0 0 00000000000000000 ri oo ± o L^L"t opot$2."2 es eQeem2)e) NN �000O c C0 m W w W N N N N N N 00000000000000000000000000 z 44 O . t0 O S to p p 000000000000000000000000000000 , m m O 40 p A 000th p + p y S+ O m r W S 0+AA t w 0 N W l o D a 00 V NJmmNNS 0 00 mm T m m A S S O 0 0 00 w Y O N M M W T O O W 0 N A N Oo 0 to N N N N A M M W O W N O O O O U u 0 NN pp O t 0 0 t � o S - A A 0 0 p 0 L N 0 A O N N O O O NN NN O O O N O N 0 0 0 0 0 0 0 0 0 t p O N O r y A + p tp m N m m+ tD A J J 8 W W A m N V V S J W V A N N m mmmm m m N 8 m W+ O 1 N _ _ pp _ _ p _ co eNA SJ A N yy W p �(w 4,- 0 00 o tptp 8 §o Oooloo Otptptpt0t oo-.0 O n W W J+ m O m o N V 00 N W A N O o O A O Oo w o m o A 0 A V V V+ V V V V V V V m W w+ 9 O O A A w 0 0 0 A A A 0 pA O O O A A A A O O O O A O A O O O A p p O O O O O O O N p pO m mp o T O I A -.OmmSmmwo OmA + m W+pmm-4000 N W p W p)NNA NNNNNt W A -.S AAI 0 O + + t p N p o p p o py O � +00 + +00 A 0 >p 000 0000 +OOO p O tp o 000 p O p o p O p o t (pp W W o C p q A V W.w.... po mN V JOO A W O V...... __ AAm_____ A A V NNO f1 N+ (N m o) O o W pm o I N p A fJ 40 P 4 t p Ay 0000p�0 p0p t 0 t � N N 000000000 p 0 p p 0 p 0 p0 p p0p0000000 0; V O m W J J m m m 0+ w A w W Oo Ou m O 0 o N N N N+ O o m m A A A A A E W W N O O o 0 n b b0000000000000 z + I N s$ N t W N N N N + 0 ++ 0 0 0 S S 0 S S S S 0 0 S S S O 0 O O O S O S S S S S S < p p p pC pp n (p o N W OOOS N +N OO S Op p p 8 p B Op t N t�� OOOS�� SSOS oo b 888888OOS0 m 4 i S N N W 8 O O tp V p 0 0 N S S S 02 pm) A 8888882888888888888888 "1-1 y < m qq +++ + + (+� ++++ + + + + +O m_ S t N O m - A A N V N A O p Ern 2 s tp tp0 0.tpm tpt ptp tp tp t ig8 W O m � OAO m W AmmA m wtOmmNNto t0 OO t0Oto +J J JOJJ JJ JJ Jtp W + 5D yy N Z m I W W W W 0 0 0 N A O W O 010 0 O m m m 0 0 0 0 A 0 W 0 0 0 + 0 0 0 0 0 0 0 0 0 0 0 t(t�4 W+ +.pp + N N N o A tJ N t W + t W tpp + 0 t(t0p A W 1 10 0� G W W (0+ 0 p ((0n W A A p A O t 40 A A A A p O t Wo tpp W W ( 0 r Og 5 pe I ' +� O tp - N N m N N -' tp N t mp t S pA) S 2 W tJ N N m N A V V m W A V V W W m V N S' - O N O O w O o w m O+ W o O o +oo + + +o++++0 +000 ++ +000080 +00080000000 0 ONQ'Q)NNNe+++NNQQ L" QNNNNNoNQ 8-4JJJ -4-1Z � Z oh 1 O O N + 0 0 0 O ++ 0 0 0 W W N N N O + + ++ O O O o 0 0 0 0 0 0 0 N W W D o oo Ot OO+ ooto 0om to po, 8t $omomotpom00 ..mom °Om 88LS omomomomomom00000 m 0 0 0 p p p p v ppp,j 8 8 W S 0 0 0 N PJ A O O+ 3 0 5 8 2 2 N N O O O O O O N o S O S O O O O O O O O 8 8 8 m m� -w000 , ° ° sN ° s 0 0000000000000000000000 O 0 13 K > CD p U1 co O D T T1 T T T (7 m N b O O O O X 0 0 0 0 0 0 -< D m n r K Cn -4 0 � � co c 10 0 ° p(D 4)N O O m iD (D iD iD O :c � co C CDD CD m 0 r = O c 0 W . k (P ( co N CO N N V = O O O N N3 C Z Z 'CO O 0 V A 'co 0 0 0 TT // 0 0 o O 0 ° 0 0 o v W r O O O v V O r i V 000 ° v v cn ; me . z Z C--0 0 m0I- m Z � r 0) A W- o T m O n v CO CO v o 0 0 0 0 T 0 73 Up -1 v m m m v m D > o 0 0 0 o c O m Xj m ' -‹ -< Z O v f n CO N O 7:1 171 o 5 n m 0 43 4) 4) 4) 6 D 13 I o 0 0 I - 0 0 X I I 0) ° A CO OZo00000 CD CO 0 .40 00000c)_, n: - cn ° CD A O D 0 0 0 0 0 0 0 0 0 0 0 0 0 0 W 00 W 0 0 -< 0 0 00 CD 0 0 OW) A 0 r- v �00000000 CD o ° � 'o 0 00000000 0b)o o 9° 4,00000000 00)0 Wo U (D CO V CD CD A CO N- 0 0 - , 0 000000000 O 0 0 0 0 0 0 0 0 o O 0 0 1 1 1 1 1 1 1 1 1 O (D CO V 0 U) A CO N- o '9 + (D (D (D (D (D (D (D (D (D (D Z , r (D CD Cfl 0 CD (D CO CO CO 0 �i 1 0 0 O O O N) CO CA A CP Ni 2 n '/ b 6 0 0 0 cn CO W ( 0 n O CO r O O O O O rn D to tzi n CI En C) C) w N O N o O 73 O I O O O 0 d o 0 0 0 0 0 5- 5 r `p o r 0 D W W 11 N M T. co TTx _ r < � � 1 1 m mmm D °m °m ° C M � 11r D > >g cn w r - r m E 3z _ m m 0 0 3 " Z D D —I c vu zzp 0 A .. (1) z C) N I N w 0 m 0 A I N N N 0 A I • 0 0 0 0 0 0 0 0 2 W Al N O N O W N 0 • N • co d O WAN 00 A A t0 m N. - 0 0 C 0 0 0 0 O O O ) co V A N j W O1 CO 0) t0 O - O O . O O O O N O 0 0 �,t W Al d 0 A I N O ; O O O O 0' N Co W A 7 0 N V <0 d U O) N C I co 0 N O N V N rI C 0 � S oaf:, j 0 N I J th o C ✓ • J 0 A 0 O I V I U N ) 0 0 N CA N I) '� 0 / v N 0 01 N N M . CO 0 O 0 0 0 0 0 0 Z1 1 x o N N O 01 0 (n o 0 en O c n o c NI O d o m Z O o 00000 0 � n c< � 13 c m 7 0 0 m s 1 Z ),� C r N °) o. _< m cn = O col 3 D ° ° = to C W v N N Z o = E N y d > C 0 0 „0 000 o r O CO 00 00 V CA V CD O N W /� "d N A O) CO 0 CO CO N V N CO A V/ D ', c m c a o a Z O Q m N 000000 3 Z • CO W co O V W Co N IV j j m o X' AVCO ACA WOVA CO ,C 0 rt v CA m X < , oaooa 0000 rn Q O co O A N O Co A O Co O 61 Ni CO CO W W CP O V Cn co CO 0 o C m z C 1 (p r > 0 0 0 0 0 0 , p22022 CA CA CD m 1 < 4 p 0 :t A A A A Co Co W W Co Co W r 0 , I -A N N VI z V V V O O //� V� Q O m W 000000 0 0 0 0 o O Fs 4 G) A .A . . G.) 0)0)0)0)0)0) 01 0 O O O O (n Cn 0) D) D) V V 0 (p 0 0 —)., O 'Ch m 0 CD 000000'...000000 x 0 —. 0 0 0 0 0 0 0 0 0 0 0 0 0 r: < O 0 0 0 0 0 0 0 0 0 0 0 0 0 `< 0 o n o 1 ii; N Ni 1V N 1V N Ni Ni N N N N Ni o U7 CP CP CP CP CP EP G7 U7 Cn CP Cn (r o m C O W W W j N N N Ni N W W A AA p a) V CT W CD J A Cn CO N O o A C p V 6) (A V (b W (n A O V Cn co o 0 1,..1 0 0 0 0 0 0 0 0 0 0 0 0 C O CP A W n) j O - W A CA V m a N A CA CD -, A CO Ni CO W CO 3 0 0 0 0 0 0 0 0 0 0 0 0 fQ pp m _ I_ N m Cn O n S m 3 3 60 EA EA W W '...4 W CO N W C J1 N N CP O m cc 1 0 N-> 000 (A G m 0C O m 0 � r C CI C") 1 � I W y tIl CD 0 0 0 0 0 0— -+ O o 0 0 0 0 0 0 0-- - 0 0 0 0 Z m A CASHFLOW($OOO) ((T { T1� � { �TTII Cn Cn A WN-+ N-. O CD CO V CD W N-+ N-+ O CO CO 0 Di D D D N N N N N N N N N N N N N N N N N N N N N N N N N N r Z 2 al x 73 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 z 0 N A T 0 0 N A 0 p so o Cn A CO N N N N N N 0 0 0 0 0 0 0 D Z O 0 0 0 0 0 8 0 0 0 8 0 �^ • p 0 � 0 D - A S D D m • m m N A A CP A CD (r - N (D O N _CA O (D co N O O -4 0 0 0 0 0 V O O -4 O O A 0 CA -+ O Cn (D O W O W I m I a N 0) N 3 0 A o 0 N N N N N O O O . N -+ N N V 7 -A -1 -u -u 1 O m CD O N 1.3 - O CD O A O Cn Cn 0 0 OD) al A A (D O 00 (D CO -.< 000 000000 V 0000 A0) 0 > g O 0 n N XI o in ID = 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - m .< t. I C ▪ Clq Ft to O 0 D 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 . N Q x TI C) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 In > a F = D 0) cli g D cn 11 °° z = - » Cl) m r y O = 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 * c) ) D 0 r C m Z n o G Z M O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - W Z 0 cn - a c 3 r M Z 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 — v o � _ _ _ 3 m V NJ -s A A Cn A CD (n N O O N 7 0 CO CO N O O V O O O O O V O 0 V 0 O A 0 D) -+ O (n CD O W O 2. d 'D D 1 n O N N N CO V • co O Cn co O N N 0 - • in 0 0 A 0 y O 0) cm 0 A A 0 CO 0 0 0 (O CD 0 0 0 0 0 0 0 0 0 (n 0 0 0 0 0 al 0 0 0 O V 0 0 0 O A O) O v m 0 a co N --+ N — N W V =. G) O V CO 0 N 0) O �(n 0 001 f N V CD A CO A 01 N (O (D O CO CO N O O V O O 01 O O V O O N O O A O W- O Cn CO A (D O General Ledger Revenue - Budget vs Actual Period 01 - 06 Fiscal Year 2010 - 2010 2010 2010 2010 2010 Account Description Budget Actual $ Uncollected % Uncollected General Property Tax 3010 Current Property Tax 7,380,000.00 3,469,592.36 3,910,407.64 52.99 3002 Allowance for Delinquent Taxes (270,000.00) - (270,000.00) 100.00 3011 Delinquent Property Tax 100,000.00 - 100,000.00 100.00 3041 Homestead & Ag Credit - - - - 3090 Other Property Taxes - - - - 3500 Local Government Aid - - - - Total General Property Tax $ 7,210,000.00 $ 3,469,592.36 $ 3,740,407.64 51.88% Licenses 3203 Dog Kennel 800.00 488.07 311.93 38.99 3205 Dog or Cat I 6,000.00 5,759.00 241.00 4.02 3213 Solicitor 500.00 250.00 250.00 50.00 3226 Liquor On /Off Sale 84,000.00 89,622.00 (5,622.00) (6.69) 3230 Rental Housing Licenses 30,000.00 2,150.00 27,850.00 92.83 3284 Rubbish 5,000.00 1,500.00 3,500.00 70.00 Total Licenses $ 126,300.00 $ 99,769.07 $ 26,530.93 21.01% Permits 3301 Building 350,000.00 191,361.25 158,638.75 45.33 3302 Plan Check 175,000.00 91,145.92 83,854.08 47.92 3305 Heating & NC 60,000.00 38,987.52 21,012.48 35.02 3306 Plumbing 50,000.00 29,292.19 20,707.81 41.42 3307 Trenching 15,000.00 12,049.00 2,951.00 19.67 3308 Gun 1,000.00 220.00 780.00 78.00 3309 Sprinkler 14,000.00 6,630.67 7,369.33 52.64 3311 Sign 7,500.00 2,915.00 4,585.00 61.13 3320 Stable 300.00 210.00 90.00 30.00 3331 Firework's Application Fee - 225.00 (225.00) - 3390 Misc Permits 2,000.00 1,085.00 915.00 45.75 Total Permits $ 674,800.00 $ 374,121.55 $ 300,678.45 44.56% Fines & Penalties 3140 S/A Penalties & Interest - - - - 3401 Traffic & Ordinance Violation 125,000.00 38,769.42 86,230.58 68.98 3402 Vehicle Lockouts 2,500.00 800.00 1,700.00 68.00 3404 Dog /Cat Impound 6,000.00 2,489.09 3,510.91 58.52 3405 Other Fines & Penalties - - - - Total Fines & Penalties $ 133,500.00 $ 42,058.51 $ 91,441.49 68.50% Intergovernmental Revenue 3503 School District Reimbursement 45,000.00 - 45,000.00 100.00 3509 Other Shared Taxes 160,000.00 - 160,000.00 100.00 3510 Grants - State 80,000.00 - 80,000.00 100.00 Total Intergovernmental Revenue $ 285,000.00 $ - $ 285,000.00 100.00% Page 1 of 2 General Ledger Revenue - Budget vs Actual Period 01 - 06 Fiscal Year 2010 - 2010 2010 2010 2010 2010 Account Description Budget Actual $ Uncollected % Uncollected Charges for Current Services 3601 Sale of Documents 1,000.00 2,454.21 (1,454.21) (145.42) 3602 Use & Variance Permits 22,000.00 1,865.00 20,135.00 91.52 3603 Rezoning Fees 2,000.00 - 2,000.00 100.00 3604 Assessment Searches 500.00 90.00 410.00 82.00 3605 Plat Recording Fees 7,000.00 750.00 6,250.00 89.29 3607 Election Filing Fees - - - - 3613 Misc - General Government 5,000.00 1,135.03 3,864.97 77.30 3614 Admin Charge -2% Const 25,000.00 - 25,000.00 100.00 3615 Admin Charge -5% Street Re -Const 108,000.00 - 108,000.00 100.00 3617 Engineering General - 15.00 (15.00) - 3619 Investment Management, Fee 75,000.00 - 75,000.00 100.00 3629 Misc - Public Safety 6,000.00 7,503.51 (1,503.51) (25.06) 3630 Recreation Program Fees 40,000.00 25,665.50 14,334.50 35.84 3631 Recreation Center 221,000.00 103,680.40 117,319.60 (20.09) 3633 Park Equipment Rental 300.00 60.82 239.18 79.73 3634 Park Facility Usage Fee 14,000.00 9,057.20 4,942.80 35.31 3635 Watercraft Rental 4,500.00 2,041.18 2,458.82 54.64 3636 Self- Supporting Programs 98,000.00 44,388.37 53,611.63 54.71 3637 Senior Programs 28,000.00 16,661.18 11,338.82 40.50 3638 Food Concessions 12,000.00 2,800.53 9,199.47 76.66 3639 Misc -Park & Rec 1,000.00 1,164.57 (164.57) (16.46) 3641 Youth Sport Donation 1 - - - - 3642 Recreation Sports 31,000.00 15,832.84 15,167.16 48.93 3649 Misc - Public Works 5,000.00 - 5,000.00 100.00 3651 Merchandise Sales 1,500.00 228.00 1,272.00 84.80 3670 Internment Fee - 50.00 (50.00) - Total Current Services $ 707,800.00 $ 235,443.34 $ 472,356.66 66.74% Other Revenue 3801 Interest Earnings 200,000.00 - 200,000.00 100.00 3802 Equipment Rental ! S, Sale 140,000.00 74,920.56 65,079.44 46.49 3803 Building Rental 4,000.00 2,720.00 1,280.00 32.00 3804 Land Sale - 1,200.00 (1,200.00) - 3807 Donations 20,500.00 34,185.00 (13,685.00) (66.76) 3808 Ins Recoveries & Reimbursements 5,000.00 - 5,000.00 100.00 3816 SAC Retainer 5,000.00 946.00 4,054.00 81.08 3818 Sur -Tax Retainer 1,000.00 255.65 744.35 74.44 3820 Misc Other Revenue 1,000.00 165.00 835.00 83.50 3829 Interest/Penalties -Other 500.00 - 500.00 100.00 3901 Contributed Assets - - - - 3903 Refunds /Reimbursements 43,000.00 81,239.56 (38,239.56) (88.93) 3910 Misc Revenue - - - - 3980 Cash Over /Short - 1.38 (1.38) - Total Other Revenue $ 420,000.00 $ 195,633.15 $ 224,366.85 53.42% Grand Total $ 9,557,400.00 $ 4,416,617.98 $ 5,140,782.02 53.79% Page2of2 General Ledger Expense - Budget vs Actual Period 01 - 06 Fiscal Year 2010 - 2010 2010 2010 2010 2010 Description Budget Actual Dollars Unspent % Unspent City Council 109,300.00 48,980.58 60,319.42 55.19 Administration 461,200.00 206,246.36 254,953.64 55.28 Finance 277,300.00 147,540.75 129,759.25 46.79 Legal 148,000.00 66,435.88 81,564.12 55.11 Property Assessment 110,000.00 6,627.03 103,372.97 93.98 Management Information Systems 247,800.00 110,577.29 137,222.71 55.38 City Hall Maintenance 419,500.00 408,681.96 10,818.04 2.58 Elections 27,900.00 76.61 27,823.39 99.73 Library Building 137,200.00 49,580.79 87,619.21 63.86 General Government $ 1,938,200.00 $ 1,044,747.25 $ 893,452.75 46.10% Police /Carver Co Contract 1,631,200.00 788,567.56 842,632.44 51.66 Fire Prevention & Admin 648,100.00 228,423.55 419,676.45 64.75 Code Enforcement 606,000.00 268,871.56 337,128.44 55.63 Animal Control 74,700.00 30,519.00 44,181.00 59.14 Law Enforcement $ 2,960,000.00 $ 1,316,381.67 $ 1,643,618.33 55.53% Engineering 1 563,200.00 247,486.37 315,713.63 56.06 Street Maintenance 818,500.00 348,160.73 470,339.27 57.46 Street Lighting & Signals 1 348,400.00 139,100.84 209,299.16 60.07 City Garage 527,200.00 226,191.65 301,008.35 57.10 Public Works $ 2,257,300.00 $ 960,939.59 $ 1,296,360.41 57.43% Planning Commission 4,200.00 1,991.66 2,208.34 52.58 Planning Administration 408,900.00 177,617.98 231,282.02 56.56 Senior Facility Commission 32,700.00 10,033.49 22,666.51 69.32 Community Development $ 445,800.00 $ 189,643.13 $ 256,156.87 57.46% Park Commission 2,200.00 897.10 1,302.90 59.22 Park Administration 150,400.00 58,376.06 92,023.94 61.19 Recreation Center 346,300.00 146,159.12 200,140.88 57.79 Lake Ann Park 68,300.00 5,910.16 62,389.84 91.35 Park Maintenance 884,600.00 380,265.98 504,334.02 57.01 Senior Citizens Center 69,100.00 29,001.11 40,098.89 58.03 Recreation Programs 283,500.00 96,805.49 186,694.51 65.85 Self- Supporting Programs 83,300.00 27,034.92 56,265.08 67.55 Recreation Sports 18,400.00 13,229.53 5,170.47 28.10 Park & Recreation $ 1,906,100.00 $ 757,679.47 $ 1,148,420.53 60.25% Transfer for Roads $ 50,000.00 $ - $ 50,000.00 100.00% Grand Total $ 9,557,400.00 $ 4,269,391.11 $ 5,288,008.89 55.33%