Loading...
HomeMy WebLinkAboutAgenda Packets - 1998/07/20 CITY OF MOUNDS VIEW WORK SESSION AGENDA July 20 1998 6:00 p.m. Items Discussed Per Consensus 1. Discussion of Mermaid Economic Development Project. 2. Discussion of 1999 Budget. Item No. Staff Report No. Meeting Date: 7/20/98 Type of Business: WK WK: Work Session;PH:Public Hearing; CA: Consent Agenda;EDAB:EDA Business City of Mounds View Staff Report To: Mayor and City Council Members From: Rick jopke, Community Development Director Item Title/Subject: Discussion of the Mermaid Hotel/Banquet Facility Project Date of Report: July 17, 1998 BACKGROUND: At the July 6, 1998 work session staff discussed the current status of the Mermaid hotel/banquet facility and the proposed$1,700,000 TIF assistance request. Staff estimated that there could potentially be a need for an additional $1,000,000 of assistance needed by the developer over and above the original $1,700,000 to cover land acquisition costs. The City Council directed staff to continue to work with the developers to see if the estimated$1,000,000 gap could be reduced such that the City's assistance could be paid back by the increment generated by the project. The City Council scheduled an additional work session on July 20, 1998 to discuss this matter further. FINANCIAL ANALYSIS City staff, the City's financial consultant, and the developer have completed additional financial analysis and have come up with an alternative which reduces the gap substantially. The attached sheets and the following summarize this scenerio: • The City would issue $2,000,000 of taxable bonds. The developer would receive $1,700,000 of the proceeds upfront. Staff will explore ways to issue a portion of the bonds as tax exempt to reduce the interest rate. • The City would acquire the RentAll site and pays for acquisition and demolition costs from the TIF pool. The City will apply for state funds from the DTED Redevelopment grant program to help offset some of these costs. • The developer would be responsible for the acquisition costs of the rest of the land needed for the project within the $1,700,000. • 100% of the increment generated will be allocated to debt service. • The project as proposed(not including the second phase of the hotel )would generate approximately $218,500 of annual tax increment. • Because of the delay in the start of the project and a recent State Auditor's interpretation on the length of tax increment districts, the developer may have to make a payment-in- lieu-taxes (pilot) in the year 2000. SUBJECT: Hotel Project/John Seibert DATE: July 15, 1998 • Pilot-Year 2000 -$218,500 (under consideration). • Tax shortfall agreement(proposed). • TIF -2001 through 2013 inclusive. • 100% of project tax increment allocated to debt service. • Hotel operational in the Summer of 1999. • City acquires Rent-All and finances relocation and demolition from TIF Pool • Of the$1,700,000 request for tax increment assistance, exclusive of Rent-All costs, no dollar limit will be set for acquisition. However, acquisition expenses must be determined mutually by the parties to be both"reasonable and prudent"investments of bond proceeds. • Annual tax increment estimate of$218,500 is expected to increase over time. • Preliminary Bond Details. Sale Date 12-1-98 Amount $2,000,000 Taxable G.O. $1,700,000 Project Proceeds $ 300,000 Issuance Costs Estimated Rate 6.5% -6.75% First Interest Payment 8-1-99; semi-annually thereafter First Maturity 8-1-01 • Pursue tax-exempt bond financing to the degree possible given the details of the project. • 0 000 000 00000 N,n v1 so N N M02 NvlN.0-.-000 O•.N N 00 0 M N 0 M et 00 N N N N 00 h Vl-l0 N te en00O1 00 01 0 00 'O a .T?M M N'N�O V M ref Q�1 s/1 Vl t.C1 0 0 0 0 0 0 0 0 0 0 0 0 00 k 0...O-flh N-N M 0 00 0 0 0 0000.01 00 R M h M 0 00 N 8 0 .00.0 4,n01 CO en O1 e M N 0 O CO O 00 N c.).8 - OppO1 ,,,www�i�i�i 8.-..,"".."..,"""00Ret'0 0•V 00-N N N N N N N O OOO O O O p O- N'NN N.N NN N N tel tel N N N f.. y s/1 N N N N NN-N N N N N N N N 04 0 0'0 O O 0 0 O 0 O'ONpp.pp AM M ,�.W8MN -. 0.0 Oa- .3 CO-N-0 v1 .� - 0 -a h 00 O O ON N Cr N -O MN N NNM N N N NNNN-seN-NF <., y N N N-N-N-N N N N N N N.N N- j g O-HI O O 0---.0 O O N-O O O O 0.0.0. ....".4.to M M M M-co en'en en.-en-re:M M en- d d 0 0 0.0 0 0 0'0 0.0 8 0:0 W M 000 N O 01 h 0•R 8 M 0 N 0 0•- N O vel M N N an-N N .- -• M M-N N tel N N N N M�.N N N N N N N N-N N N N N N O 8 oo. 3 0 0 h U Y Y 'C 00 tL y .8 O H 9 - 8-8 ... O 0. L .. O .5 0 t0000O.0000.00.000OO00000 11! 0 0000 0 0 0 0 0-0.0.0.000'00.0 0 00 0 0 0 0 00 0- u o t' N (�z aY0 ( 0000000000000 p vl an vl O ananv1 hhO v1 0 0 00 Oi O O 0 N M N N Crs0 y Q 00- O m 0 I ..5 vl 0 ON CO N O 0O an Q 01 N N O vl ni n... �-.-.^� Y M-lN N N N N N N N N N-N-N N N a H F a 0 0 0 0 0 0 0 0 0 0 0 0O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O W IF a d Ho I 8 io 0 0008a0000a °.00000000aa ° 00000p rnarnalarnrnrnrnarnrnaO 0000 F.01 N N N N N N N N N N N N N N N N co Y n O V 0 O TO: Honorable Mayor& members of the City Council FROM: Bruce A. Kessel, Finance Director DATE: July 17, 1998 Subject: Preliminary 1999 budget Attached is a very preliminary budget for 1999. The budgeted property tax levy was increased by 3%, salaries by 3%, and the franchise fe was kept at 2.5%. An additional $2,000 was added for tree replacement as a result of the Sorms. Most of the other programs and related budgets were kept the same as 1998 with slight adjustments for inflation. Departments are still reviewing their budgets and additional adjustments are anticipated. Several items have not been included the attached budget including: • Salary adjustments needed for compliance with Hay pay plan; • Replacement of police chief- severance pay, recruitment($15,000 to $30,000); • Park improvements paid for out of parkland dedication fees; • Improvements to City hall - HVAC, sprinkling system, etc. • Electronic message board on Highway 10 ($25,000 to $40,000); • Addition of two police officers ($120,000 plus one additional vehicle @ $27,000); • Receptionist position($32,000); • Building maintenance position for City Hall & Community Center; • Central digital filing system ($25,000 to $60,000); • New phone system. a est �0�;gg 1LI UlUl_I e g ge 8g g e e g g 0 omovI ege e g g Sg g g g so g g g s�g 3 1 VO O ! OO 00 0 0 0 00 0 O Ole-4 O O O O O O O O O O O O O O O O O O OIO Oy. " m p 'l 00 0 0 0 O O S 00 0 0 0 0 0 0 00 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 0 0 0 0 0 0 0 0 0 0 0 0 0 r T O O T b y r e hV O N D 1 s �IO U rn p p so p 88 88 p p p 8 p 8 !;II OO OO ON S V 0O000SS N VI ON TOO v01 SS00 V100000 .On Sv01 en V hSS S SOON OSS SS S Sto NO O G �. ^ o. 8 O N N ^ N N N-.• Q M N CO-b b 0 M Cr 0, Of n pN p^ Os 8 p 8 p p p p pQ p 8 8 p N p O O O vhf l 00 O V 0 0 N 0 0 v01 O�POO VOf O O O VOi O Q O ONO v01 O 00 ONO vi b N O N O 00 Oho S O ^ N N N^• ? �M �vl N a0 b b e M^ ^ 0-Os' A ^ V N y e N Q 044 ✓ o p 04 WWII N--0 so .M.^ Oso ut MOOOOO vi O mS o00,,D OHO N Nnh n V CO V 0S 0O�o n ren voi 00 V vii ON00 SON+-0 On e a N-N CO M l�n N N P V v1 M ^N N 0 eo N -.00-.e-en N T 0 ON^ h V N^- ^ V Of /�ecu/ p =S N a O N e. N N N.^ V N N o0 R O.e n M N 00 yy T e N ON" ^ Ci en en pen Ch� -�• sO en VVI velN Ono en en as 01 V O en-000 of.00 v010N ,0 O v0f v0f O V n V^vs CO O00R Of veses f a ONO Q rOn S N h•.R Cs vs NN �1 V of en b O sen CO T V 8 O^N^ O 00.Tr ut h h O V O.O.O N Of M^^N n^ Of h N N O^ N N N S M N - h b b V N O a0 011. CI 41* C _ _ Opppp p ., ,n�0 r^ MOO V M nh N OOnOOOO OnNmV.O O^m eDO �hO MQvO ve S 0 0O 4,.. 0�vh o00�.W Oti OM^NN bh a O:m N N r� V N O h�O M V 00 vi N O 00 M M O, 00 h N -n N V•N en vi vs h^00 N M vs v.i N en Os N h 3 Cren n O ^ N ^ N N N^ P N 00 4.1 V 00 co"O' ^ 00^ q 00 00 Is 4ppp...N p p8 p pp el T- e Q V n eenn T ^O en S N O 0 N V N N V m e0 0 ro h I00 in 0 00 O N ren 00 vhf V O0f en Of N 00 Ops Off N M N^ b R vs.<4 v O^^ 0 .h. ^ M^ Q M .-^ 00 r h R o ... =Vf' ✓ 00 N r ^ 0 on MOSCI, 4100,0 al Tr Tn en a.O ses 0 S.00 O p 00 ea 0 O en 0 rn 00 O O Q 0 01 00 0 0 O N 0 as 0 0 O.CO VVi p CO Tr,K,O A 0 O C N e p N O en O qen 1 m .e-. ao � A1 m lV^• Q -. IM N M � a` .... O N V N V ^I O n O O N f0Ol r 0 en O S 0 0 S 000 0 O T M 0 O ,000 r O n 0 0 T 0 0 00 O en 0 h^ev 00^N N^ 00 h �O N en N V v)• ao V M N 00 h V V e v1 h e V 00 O^V V 0 h S o S Or 00 0 h T II o M N.� C� N N N.� V �v N W Q M M .� b M T O,h 0 V 00 0000000 0Oh0Tvt 0 e N O. 0 0 0 0 0 0 0 0 V P 0 0 M 00 0 R CO ten 0 en ? r .N..CO W h h ten O,een O^N h 0so 00 ren N N p N en 0.en h. r COo N P P 00 ca 00 n m OO Tr n 0 N N vel Ve. v v O N 0 T 0 V N N N • V fen N W en N M ^ e T eCIpONW m Of N n rN V O.,n 00,0000 0 0 0 0 0 0000 O N R S'Oh.. O 0 O O O pp 000 000 0 Nen N ^^0.1•40 ^en S S N e Of P O Q\e m N S O h V Cf e 0 V•^ h N Of N O`00 N N CO N O.?en V M O.M N V V 00 e N O O b 00 N h -O. N^ b b b M N ✓4 a Q Os ers N M V N CA V -. ,000. 000 SMSO n O -.00,0,00 SN-. h N0000hemO O 0 0•••• M me CO O S b i n pe hvsV 0 O. no n n V O 00 N Of^ h O es e v en^ O V N N Of 00 m 0 Of N V^en e h N P N N O 00 on ^OpM .6 ^ hMa h 21 V e^ ^Nr en Tr 0 0 en r CI V M N •h0 n<I vhf 0 een 0 0 e O O N een 0 O p N N '0 h l n CO h`=0 CI V 00 00 ten N O O?tpf O 0 x000 M CO O � J 00 ^ r� V O.TI N v V •o 7N ^^ .O N O M vhf 0 W O h N e N Of en I h I 0000000 O V 0 0 0^0 0 O.N I_ 0 0 0 0 0 0 0 0 h N O O h^O ON 0-00 000, O N O M 0, O\00 0I O M O h e e e en T n e N hi0 a V N a N e e e O` N m O N^ rpn V V en Q e e h 0 M h 0 co N en, Of N N 0100 0 V V en---M e N 01 en N e v1 00 N I^i Q M ^III Q N b Vl rf m.M.ry rr, I h O. V TIOfI h 0 0 0 0 0 0 ^V vt O V v1 O V ebI^i O v1 0 0 e e 0 0 V 0 0 0^Q 0 S O.O 1.1 II-- N N e U e G O er1 Os,0 en V V^ V Tr M 0 00 Ch N OA N pp N a OS, h e h OI h e M^of V N V N O h-1001 N en V N^en 07 en 00 O O. V l N C en.-.00 N eV V .-:I n) N^ e NP ?M .._ T 7 IMI I mTQ 1 µ n O n000 0 Oha^I m.00 r��nOO veerNS QO ASO vpi nl0 ONNten niton ten so npiOOO ten V•O vei vpi� h JJJ Cr Q Q ^MRI 0 N M n ^ t M N 0.00 b e1 N V 4 I g N 0 T C o y u a 21 ` C y m 9 o.a e.ztguE•o_QQ o g € € y9 $ » € = C8. E la= c e o o '� v a v v v v u . u o a,.. ° ° S v E e 9 E a a oo c e0`� N d3 oc uo2F . EvEZca ` u_ v ev r•=.° v - A I .Aa iO o '. 8 P .=- @o.t .uc c ` m c m` w EEo0Vu0c14 ' o oe umy n$ y ^Gug ct' ec1tv, € o' a.o'Em2 13 Nv ^._ y $F > ; ° °s '�= i E u v m % 0 0= m m u gd $ o cg g 3 3•°a e u m 0 .a&v co m y N c h•u o= e.- e u u_ u u m.- ., a 8 8 e 1 yp..,$ c m.0 u .. se- .. a,.: o e u°_ m.-al .... n 5 6g. :4 .=.-g 0 o iii u`C F u v'_v?.a•x a E. .3 a 0-a 2 H 1 A c pro c Q E a 5 g 3 r 9$ I)a E 0 G v o•r,E ::rn rn F0+ o 0 '- a o c o o•- o E o > u x.- u a 9.X o> o o °..' 0 9.x u o. a A ^UwwFG�$�fnUtn�aw �..t..1tn�Lm3FQmc7C��YdUiF`.� t72U6�wtntnOQmw Saz'u.UmwSa3 H 3 `I; O N -N ^N en V N a^^V Of 0-N V N •0^ ^eV V e h 00 M 0^tV V 0 V O e O O ^Ch N V .O V V R V V V V V n 00 00 00 M M M en een enenten ref ten en enenen en en ten en ten en een M M ten M 0 M M ten ren M M M M M M N M M �V Z M M M M 6 S 0 0 O ^N N_ 00 O N h O O _,,..,,„,,..„0_,_,-....,_,..,___ ^N M V r e h 00^O M O O O p O O V e G ZI.� p N N V 1�F. O O O O N N O N VI h co h N M en e N N V N 0 P N N N N N M O M 0 fon ton ton ton r0n ton eon n eon M M M M M M M M M M M M M M M M M M M en MMM ten en en en ten n M en N N en en MMM en n n n n M en M M M M M 0 eel 6 F.Z 1999 Budget Summary 07/17/98 08:13 AM BDGT99GF.WK4 1995 1996 1997 1998 1999 Change from 1998 ActualActual Actual Budget Budget Dollar Percent City Council(100-4100): Personnel services 0100 Salaries,regular 30,895 26,013 25,698 26,249 30,944 4,695 17.89% 0200 Salaries,part-time 717 0 0 3,164 0 (3,164) -100.00% 0300 Pensions 2,770 2,142 2,568 3,577 3,938 361 10.09% 0400 Group insurance 476 153 0 240 480 240 100.00% 0500 Workers compensation 357 370 236 165 171 6 3.64% Total personnel services 35,215 28,678 28,502 33,395 35,533 2,138 6.40% Materials&supplies 1600 Supplies,operating 1,969 1,613 2,513 3,500 3,000 (500) -14.29% 2100 Books&periodicals 80 35 144 100 150 50 50.00% Total materials&supplies 2,049 1,648 2,657 3,600 3,150 (450) -12.50% Contractual services 3030 Other professional services 22,313 11,529 15,475 4,500 7,500 3,000 66.67% 3410 Legal notices 467 (212) 2,145 0 0 0 ERR 3610 Memberships 11,428 11,634 20,452 14,935 20,500 5,565 37.26% 3630 Training&conferences 2,550 4,056 2,349 4,000 4,000 0 0.00% Total contractual services 36,758 27,007 40,421 23,435 32,000 8,565 36.55% Capital outlays 0 0 0 0 0 0 ERR Total City Council 74,022 57,333 71,580 60,430 70,683 10,253 16.97% Advisory Commissions(100-4110): Personnel services 0200 Salaries,part-time 136 47 459 253 250 (3) -1.19% 0300 Pensions 0 5 0 19 0 (19) -100.00% 0500 Workers compensation 25 6 8 3 0 (3) -100.00% Total personnel services 161 58 467 275 250 (25) -9.09% Materials&supplies 1600 Supplies,operating 5 275 0 200 200 0 0.00% 2100 Books&periodicals 0 60 0 200 200 0 0.00% Total materials&supplies 5 335 0 400 400 0 0.00% Contractual services 3030 Other professional services 65 80 1,329 400 400 0 0.00% 3630 Training&conferences 190 90 340 300 300 0 0.00% 3920 Festivities Commission 0 4,000 4,000 4,000 4,000 0 0.00% Total contractual services 255 4,170 5,669 4,700 4,700 0 0.00% Capital outlays 0 0 0 0 0 0 ERR Total Advisory Commissions 421 4,563 6,136 5,375 5,350 (25) -0.47% 1999 Budget Summary 07/17/98 08:13 AM BDGT99GF.WK4 1995 1996 1997 1998 1999 Change from 1998 Actual Actual Actual Budge Budget Dollar Percent Office of the City Administrator(100-4130): Personnel services 0100 Salaries,regular 77,613 65,193 69,955 77,760 91,913 14,153 18.20% 0200 Salaries,part-time 2,591 1,944 0 4,160 0 (4,160) -100.00% 0300 Pensions 8,665 7,339 7,827 10,294 11,792 1,498 14.55% 0400 Group insurance 6,179 1,793 2,806 3,360 3,840 480 14.29% 0500 Workers compensation 199 168 358 951 1,041 90 9.46% Total personnel services 95,247 76,437 80,946 96,525 108,586 12,061 12.50% Materials&supplies 1600 Supplies,operating - 412 907 280 1,000 500 (500) -50.00% 2100 Books&periodicals 303 715 252 600 400 (200) -33.33% Total materials&supplies 715 1,622 532 1,600 900 (700) -43.75% Contractual services 3030 Other professional services 681 2,437 6,478 3,000 3,000 0 0.00% 3100 Communications 423 503 373 600 450 (150) -25.00% 3430 Printing 278 270 55 500 150 (350) -70.00% 3610 Memberships 866 636 522 1,050 700 (350) -33.33% 3630 Training&conferences 5,164 2,730 3,363 6,626 4,500 (2,126) -32.09% 3800 Mileage 1,880 2,749 3,669 3,900 3,800 (100) -2.56% 4010 Rental,equipment 0 0 0 0 0 0 ERR Total contractual services 9,292 9,325 14,460 15,676 12,600 (3,076) -19.62% Capital outlays 7030 Equipment 3,119 3,622 0 0 0 0 ERR Total City Administrator 108,373 91,006 95,938 113,801 122,086 8,285 7.28% Elections (100-4140): Personnel services 0100 Salaries,regular 0 3,450 0 3,000 3,922 922 30.73% 0200 Salaries,part-time 280 0 3,873 6,000 0 (6,000) -100.00% 0300 Pensions 33 668 426 800 503 (297) -37.13% 0400 Insurance 257 101 0 400 240 (160) -40.00% 0500 Workers compensation 7 15 4 40 49 9 22.50% Total personnel services 577 4,234 4,303 10,240 4,714 (5,526) -53.96% Materials&supplies 1140 Misc.office supplies 0 199 87 500 0 (500) -100.00% 1600 Supplies,operating 52 587 3,732 1,000 0 (1,000) -100.00% Total materials&supplies 52 786 3,819 1,500 0 (1,500) -100.00% Contractual services 3030 Other professional services 0 139 6 500 300 (200) -40.00% 3410 Legal notices 4 273 2,875 300 0 (300) -100.00% 3430 Printing 0 0 0 400 0 (400) -100.00% 5130 Repairs,equipment 2,600 52 0 500 500 0 0.00% Total contractual services 2,604 464 2.881 1,700 800 (900) -52.94% Capital outlays 0 2,554 0 4,000 2,000 (2,000) -50.00% Total Elections 3,233 8,038 11.003 17,440 7,514 (9,926) -56.92% 1999 Budget Summary 07/17/98 08:13 AM BDGT99GF.WK4 1995 1996 1997 1998 1999 Change from 1998 Actual Actual Actual Budget Budget Dollar Percent Finance (100-4150): Personnel services 0100 001 Salaries,regular 140,244 83,854 109,890 117,435 109,038 (8,397) -7.15% 0100 002 Salaries,regular Training 0 0 0 0 0 0 ERR 0150 Overtime 885 2,898 181 0 0 0 ERR 0200 Salaries,part-time 0 0 0 0 0 0 ERR 0300 Pensions 13,222 10,181 13,093 15,067 13,990 (1,077) -7.15% 0400 Group insurance 8,632 6,557 8,003 8,100 6,990 (1,110) -13.70% 0500 Workers compensation 245 245 284 518 479 (39) -7.53% Subtotal - 163,228 103,735 131,451 141,120 130,497 (10,623) -7.53% Materials&supplies 1140 Misc office supplies 0 0 23 0 200 200 ERR 1600 Supplies,operating 0 0 202 250 250 0 0.00% 2100 Books&periodicals 229 311 227 425 425 0 0.00% Subtotal 229 311 452 675 875 200 29.63% Contractual services 3030 Other professional 13,214 18,561 5,904 7,475 7,475 0 0.00% 3430 Printing 3,597 5,444 1,615 3,000 3,000 0 0.00% 3610 Memberships 165 250 125 410 410 0 0.00% 3630 Training 2,628 1,846 3,091 3,700 3,700 0 0.00% 5130 Repairs,equipment 0 746 270 1,900 1,900 0 0.00% Subtotal 19,604 26,847 11,005 16,485 16,485 0 0.00% Capital outlays 7030 Equipment 2,852 26,652 (5,646) 14,600 10,000 (4,600) -31.51% Subtotal 2,852 26,652 (5,646) 14,600 10,000 (4,600) -31.51% Total Financial Services 185,913 157,545 137,262 172,880 157,857 (15,023) -8.69% 7 1999 Budget Summary 07/17/98 08:13 AM BDGT99GF.WK4 1995 1996 1997 1998 1999 Change from 1998 Actual Actual Actual Budget Budget Dollar Percent Central Services (100-4160): Personnel services 0100 001 Salaries,regular Admin 57,300 0 24,441 12,136 70,207 58,071 478.50% 0100 002 Salaries,regular Training 0 0 0 0 0 0 ERR 0100 003 Salaries,regular Human res 0 3,592 8,272 14,498 0 (14,498) -100.00% 0100 004 Salaries,regular Central 0 28,862 0 23,077 0 (23,077) -100.00% 0100 005 Salaries,regular MIS&Records 0 2,765 1,822 0 0 0 ERR 0100 006 Salaries,regular Public Info 0 9,463 1,357 0 0 0 ERR 0150 Salaries,overtime 0 0 518 0 0 0 ERR 0200 001 Salaries,part-time Admin 8,310 9,709 15,854 17,251 18,134 883 5.12% 0200 003 Salaries,part-time Human res 819 0 0 0 0 0 ERR 0300 Pensions 8,336 6,760 5,865 8,170 10,898 2,728 33.39% 0400 Group insurance 5,152 2,826 3,816 4,400 3,030 (1,370) -31.14% 0500 Workers compensation 294 285 1,482 468 768 300 64.10% Total personnel services 80,211 64,262 63,427 80,000 103,037 23,037 28.80% Materials&supplies 1110 Stationery 2,006 257 641 1,500 1,000 (500) -33.33% 1120 Copy materials 4,181 5,782 1,889 4,800 4,800 0 0.00% 1140 Misc.office supplies 11,110 9,671 16,806 13,500 13,500 0 0.00% 1210 Supplies,building&grounds 2,838 5,464 5,887 4,200 6,000 1,800 42.86% 1600 Supplies,operating 720 142 166 0 200 200 ERR 2100 Books&periodicals 304 857 1,620 1,095 1,200 105 9.59% Total materials&supplies 21,159 22,173 27,009 25,095 26,700 1,605 6.40% Contractual services 3010 000 General legal 26,587 53,677 37,324 40,000 40,000 0 0.00% 3030 003 Other professional Human res 7,592 6,480 7,592 7,200 5,000 (2,200) -30.56% 3030 004 Other.professional Central 5,208 1,173 4,970 3,000 3,000 0 0.00% 3030 005 Other professional MIS&Records 8,196 1,669 3,915 3,500 3,500 0 0.00% 3030 006 Other professional Public Info 0 500 25 2,000 1,000 (1,000) -50.00% 3100 Telephone 19,285 20,778 19,685 19,000 20,000 1,000 5.26% 3200 Water&sewer 0 0 2,238 0 2,500 2,500 ERR 3210 Electricity 12,978 13,346 13,934 14,950 15,000 50 0.33% 3220 Natural gas 6,719 16,684 6,185 7,600 7,600 0' 0.00% 3300 Postage 15,540 15,077 19,917 15,800 18,000 2,200 13.92% 3410 Legal notices 3,210 5,843 2,900 3,000 3,000 0 0.00% 3420 Advertising 2,133 7,301 7,073 3,000 5,000 2,000 66.67% 3430 Printing 15,858 14,934 9,945 10,440 11,000 560 5.36% 3530 Refuse collection 2,810 2,784 2,936 3,000 3,200 200 6.67% 3610 Memberships 300 1,298 600 420 600 180 42.86% 3630 Training&conferences 736 2,909 2,729 4,050 4,100 50 1.23% 3800 Mileage 5 40 62 200 200 0 0.00% 4010 000 Rental,equipment 12,701 17,141 16,358 16,020 15,000 (1,020) -6.37% 4010 005 Rental,equipment MIS&Records 1,491 2,722 1,738 3,240 2,000 (1,240) -38.27% 4800 Insurance&bonds 18,976 18,990 16,416 16,187 16,187 0 0.00% 5110 Rep,bldg&grounds 3,906 4,147 10,013 4,500 4,500 0 0.00% 5130 Repairs,equipment 8,150 6,119 18,009 13,000 10,000 (3,000) -23.08% Total contractual services 172,381 213,612 204,564 190,107 190,387 280 0.15% Capital outlays 7010 Building 0 0 0 25,000 25,000 0 0.00% 7030 Equipment 18,952 27,848 6,565 22,500 22,500 0 0.00% Total capital outlays 18,952 27,848 6,565 47,500 47,500 0 0.00% Total central services 292,703 327,895 301,565 342,702 367,624 24,922 7.27% /0 City of Mounds View, 1999 Budget 07/17/98 08:18 AM Fund: 100 Department: 4190 General Fund,Central Services (continued) Proposed Account Description Budget Detail Description 3410 Legal notices 3,000 1,200 Truth in taxation notices. 1,800 Legal notices. 3,000 3420 Advertising 3,000 3,000 Job opening advertisements for vacant positions 3,000 3430 Printing 10,440 4,240 4 newsletters @ 1/2 cost;other 1/2 in recreation 3,500 Additional newsletters 1,500 General printing 750 New resident guides 450 City directory 10,440 3530 Refuse collection 3,000 3,000 Refuse collection and recycling @$250 per month. 3,000 3610 Memberships 420 100 Sam's Club 140 IMPA 150 MPLERA(personnel) 30 TUG (Metro personnel officers association) 420 3630 Training&conferences 4,050 300 Records retention&misc. 1,750 Misc training&educatio assistance 500 Misc training&seminars 1,500 Network training 4,050 3800 Mileage 200 200 Miscellaneous use of personal vehicles 200 4010 Rental,equipment 16,020 11,520 Copy rental fee of$860 per month plus$100/mth overage 100 Misc 4,400 Postage machine @$1,100 per quarter. 16,020 4010 'Rental,MIS equipment 3,240 3,240'Microfilm reader lease @$270 per month. 3,240 4800 Insurance&bonds 16,187 16,187'Insurance&bonds 16.1871 5110 Repairs,bldgs&grounds 4,500 4,500 All city elevators,fire sprinklers&alarms,recharge fire extinguishers,general maintenance&repairs,etc. 4,5001 5130 'Repairs,equipment 13,000 8,000(Postage meter,copy machine,fax,misc. 5,000 Upgrades and repairs to MIS system. 13,0001 7010 Capital,Building 25,000 25,000 HVAC sinking fund 25.000 7030 'Capital,equipment 22,500 3,000 IIntergovernmental information exchange 11,000 Upgrade 5 personal computers 3,000 Upgrade general software 1,000 Update file server software 2,000 Replace and upgrade file server tape backup system 2,000'Replace fax machine 500'Replace water heater 22,500, 12 City of Mounds View, 1999 Budget 07/17/98 08:18 AM Fund: 100 Department: 4180 General Fund,Community Development Proposed Account Description Budget Detail Description 1600 Supplies,operating 1,195 465'Office supplies 155 Cell phone-inspectors 245 Presentation supplies. 330 Photo supplies for enforcement,development cases. 1.195 I 2100 'Books&periodicals 650 62 Zoning news 150 Reference materials 88 Planning Commission Journal 350 Bldg code updates,manuals,pamphlets,etc. 650 3430 Printing 6,250 1,250 Forms,flyers,bldg inspection tickets,tags,plates,etc. 5,000 Comp plan,zoning ordinances 6,250 3030-011 Other professional-Planning 9,360 2,000 GIS services,comp plan base maps 1,510 Ramsey County JPA(annual share of cost) 2,000 Contractual services for taking minutes of Planning Comm mtgs. 3,850 North Metro 35 W Corridor Coalition(share of costs) 9,360 3040-010 Consultants,spec projects 7,000 5,000 Comprehensive plan 2,000 Zoning&ordinance update 7,000 3040-012 Consultants,Development 6,600 620 Environmental reviews Review 620 Building plan reviews 3,300 Development case reviews 2,060 Engineering services 6,600 3610 Memberships 740 310 APA-National&state(2) 310 ICBO Lake Country&Northstar chapter 120 NAHRO dues 7401 3800 Mileage 200 200!Misc.use of personal automobiles 200 3630 Training&conferences 5,400 1,700 APA conferences-national&state 1,200 GIS/CAD training 500 1ICBO conferences&training 1,000!Data base training 1,000!Staff training&conferences 5,400 7030 'Capital,equipment 10,600 400!Light table 8,500 IBldg/Hsg computer software 700 Digital camera 1,000 CAD/GIS software updates 10,600 fy City of Mounds View, 1999 Budget 07/17/98 08:19 AM Fund: 100 Department: 4200 General Fund,Police Proposed Account Description Budget Detail Description 1140 Supplies,office 150 150 Misc.office supplies 150 1210 Supplies,bldgs&grounds 300 300 Misc maintenance items 300 1600 Supplies,operating 3,500 3,500 Misc.supplies-film,extingishers,gloves,toner,etc. 3,500 1700-001 Motor,fuels,&lubs- 1,000 1,000 Unleaded fuel-800 gallons @$1.25 Admin 1,000 1700-021 Motor,fuels,& lubs- 500 500 Unleaded fuel-400 gallons @$1.25 Investigator 500 1700-022 Motor,fuels,&lubs- 16,250 16,250 Unleaded gas 13,000 gallons @$1.25;three patrol vehicles Patrol 16,250 1700-024 Motor,fuels,& tubs- 400 400 Animal control 400 2100 Books&periodicals 800 400 Traffic law books 350 Criminal books 50 Inv update 800 2400 Uniforms&clothing 11,450 550 Chief 550 Lieutenant 550 DARE officer 550 COPS officer 7,150 13 officers @$550 275 Secretary 275 Clerk-typist 500 Reserve 200 Misc items 700 2 bullet proof vest 150 Animal control officer 11,450 I 3020 Legal,prosecuting attorney 42,500 42,5001$3,500 per month retainer plus$500 misc. 42,500 3030 Other professional services 14,900 1,200 Lab fees,blood tests,physical tests,video,misc. 300 CD Rom phone numbers&addressess 12,100 Laison Officer-payment to City of New Brighton 600 Tabacco compliance project 700 Paper shredder service 14,900 3050 Dispatching 68,600 68,600!Ramsey County dispatching 68,600 I 3070 COPS events 2,000 2,000 COPS activities-Halloween party&bike safety 2,0001 3080 I Veternarian services ( 2,000 2,000!Brighton Vet Clinic 2,0001 l6 1999 Budget Summary 07/17/98 08:14 AM BDGT99GF.WK4 1995 1996 1997 1998 1999 Change from 1998 Actual Actual Actual Budget Budget Dollar Percent FIRE(100-4210): Contractual services 303 035 Fire inspection services 0 5,183 4,487 8,000 10,000 2,000 25.00% 305 Dispatching 0 0 0 0 0 0 ERR 396 035 Contractual fire services 157,918 167,846 152,142 151,883 144,565 (7,318) -4.82% Total contractual services 157,918 173,029 156,629 159,883 154,565 (5,318) -3.33% Capital outlays: 704 Vehicles&equipment 0 0 29,925 14,963 20,585 5,622 37.57% 702 Buildings 0 0 0 0 0 0 ERR Total capital outlays _ 0 0 29,925 14,963 20,585 5,622 37.57% Miscellaneous 299 Miscellaneous 0 0 595 0 0 0 ERR Total miscellaneous 0 0 595 0 0 0 ERR Total Fire 157,918 173,029 187,149 174,846 175,150 304 0.17% /1 1999 Budget Summary 07/17/98 08:14 AM BDGT99GF.WK4 1995 1996 1997 1998 1999 Change from 1998 Actual Actual Actual Budget Budget Dollar Percent Parks,Recreation& Forestry Recreation(100-4350): Personnel services: 0100 1 Salaries,regular Admin 15,735 22,284 27,345 26,620 62,139 35,519 133.43% 0100 30 Salaries,regular Programming 22,566 13,088 5,057 11,925 (11,925) -100.00% 0100 2 Salaries,regular Training 0 0 0 0 0 0 ERR 0200 Salaries,part-time 12,067 26,441 34,648 24,197 (24,197) -100.00% 0300 Pensions 6,916 6,212 6,719 6,796 6,468 (328) -4.83% 0400 Group insurance 3,129 2,664 1,724 2,970 2,534 (436) -14.68% 0500 Workers compensation 933 572 1,058 785 778 (7) -0.89% 0600 Unemployment 0 0 8 0 0 0 ERR 0990 Severence 0 0 10,301 0 0 0 ERR Total personnel services 61,346 71,261 86,860 73,293 71,919 (1,374) -1.87% Materials&supplies: 1140 Supplies,office 2,773 3,468 0 3,215 3,215 0 0.00% 1600 Supplies,operating 644 615 2,138 860 420 (440) -51.16% 2990 Miscellaneous 0 0 0 0 0 0 ERR Total materials&supplies 3,417 4,083 2,138 4,075 3,635 (440) -10.80% Contractual services: 3060 School coordinator 8,447 9,492 9,669 9,700 9,700 0 0.00% 3100 Telephone 392 0 0 0 2,600 2,600 ERR 3210 Electricity 0 50 0 0 0 0 ERR 3300 Postage 2,209 2,729 2,341 1,200 1,200 0 0.00% 3420 Advertising 0 275 0 300 300 0 0.00% 3430 Printing 10,581 12,019 10,221 4,080 4,080 0 0.00% 3610 Memberships 715 580 823 550 400 (150) -27.27% 3630 Training&conferences 2,481 3,288 1,739 2,710 2,000 (710) -26.20% 3800 Mileage 124 101 55 200 200 0 0.00% 4010 Rental,equipment 0 0 0 0 0 0 ERR 4800 Bonding&insurance 6,006 6,361 3,093 2,450 2,450 0 0.00% 5110 Repairs,equipment 0 1,168 704 640 490 (150) -23.44% Total contractual supplies 30,955 36,063 28,645 21,830 23,420 1,590 7.28% Capital outlays 7030 Equipment 5,271 3,833 2,229 0 2,500 2,500 ERR Total capital outlays 5,271 3,833 2,229 0 2,500 3,080 ERR Total Recreation 100,989 115,240 119,872 99,198 101,474 2,276 2.29% P.O 1999 Budget Summary 07/17/98 08:14 AM BDGT99GF.WK4 1995 1996 1997 1998 1999 Change from 1998 Actual Actual Actual Budget Budget Dollar Percent Parks (100-4360): Personnel services 0100 1 Salaries,regular Admin 15,751 14,382 84,098 26,028 (26,028) -100.00% 0100 2 Salaries,regular Training 0 0 0 0 0 0 ERR 0100 31 Salaries,regular Maintenance 85,321 82,805 20,603 66,986 114,742 47,756 71.29% 0150 Overtime,regular 3,316 3,411 1,556 4,627 (4,627) -100.00% 0200 Salaries,part-time 14,910 15,329 17,805 15,584 (15,584) -100.00% 0300 Pensions 12,562 12,801 14,645 14,132 13,890 (242) -1.71% 0400 Group insurance 10,596 9,534 9,782 9,266 8,910 (356) -3.84% 0500 Workers compensation 3,743 1,846 3,353 2,821 2,844 23 0.82% 0700 Beeper time 3,418 3,311 4,221 3,221 (3,221) -100.00% Total personnel services 149,617 143,419 156,063 142,665 140,386 (2,279) -1.60% Materials&supplies: 1210 Supplies,Bldgs&grnds 0 10,814 10,925 16,400 16,400 0 0.00% 1220 Supplies,vehicles 227 6,155 5,139 4,000 4,000 0 0.00% 1230 Supplies,equipment 0 3,219 1,461 3,150 3,150 0 0.00% 1600 Supplies,operating 23,689 5,471 12,283 10,310 10,310 0 0.00% 1700 Motor fuels&lubs 2,279 986 2,346 2,500 2,500 0 0.00% 2400 Uniforms&clothing 1,704 2,036 1,550 1,750 1,750 0 0.00% Total materials&supplies 27,899 28,681 33,704 38,110 38,110 0 0.00% Contractual services: 3030 Other professional services 0 6,163 4,168 3,900 3,900 0 0.00% 3100 Telephone 2,023 2,193 4,116 2,100 0 (2,100) -100.00% 3200 Water&sewer 0 0 4,255 0 4,000 4,000 ERR 3210 Electricity 6,178 5,976 6,398 6,200 6,200 0 0.00% 3220 Natural gas 1,383 1,395 2,141 1,500 1,500 0 0.00% 3420 Advertising 0 0 495 500 0 (500) -100.00% 3530 Refuse collection 5,252 5,507 5,241 6,470 6,470 0 0.00% 3560 Satellites 7,297 4,163 4,032 7,300 7,300 0 0.00% 3630 Training&conferences 993 933 776 920 920 0 0.00% 3900 Grants&subsidies 7,500 7,500 7,500 6,200 7,500 1,300 20.97% 4010 Rental,equipment 8,979 0 0 0 0 0 ERR 4800 Bonding&insurance 9,772 6,731 5,571 4,890 4,890 0 0.00% 5110 Repairs,bldg&grounds 103 2,945 8,695 2,700 2,700 0 0.00% 5130 Repairs,equipment 0 754 3,715 0 0 0 ERR Total contractual services 49,480 44,260 57,103 42,680 45,380 2,700 6.33% Capital outlays 7050 Construction 2,258 19,909 6,931 0 0 0 ERR 7030 Equipment 112,429 25,370 20,673 29,750 0 (29,750) -100.00% Total capital outlays 114,687 45,279 27,604 29,750 0 (29,750) -100.00% Total Parks 341,683 261,639 274,474 253,205 223,876 (29,329) -11.58% oZo2 City of Mounds View, 1999 Budget 07/17/98 08:19 AM Fund: 100 Department: 4360 General Fund,Parks (continued) I Proposed Account Description , Budget Detail Description 3420 Advertising 0 0 3530 Refuse collection 6,470 5,500 Monthly charges 970 Additional trips to landfill,Ramsey Cty park fee. 6,470 3560 Portable restrooms 7,300 7,300 For May thru Oct,plus special events such as tournaments,&extra cleanings and insurance 7,300 3630 Training&conferences -l 920 50 MPSA membership 20 Chemical license 110 MPRA&loss control workshops 20 Equipment EXPO 420 Sewer,Water&traffic certificates 300 MTI school 920 3900 Grants&subsidies 7,500 7,500 Lakeside Park share of operating costs 7,500 4800 'Bonding&insurance 4,890 4,890 Bonding&insurance 4,890 5110 Repairs,bldgs&grounds 2,700 700 Windows&doors 500 Siding 500 Replace locks 500 Light bulbs 500 Repairs to furnaces,plumbing,phones,electrical,etc 2,700 7030 Captial,equipment 0 0 vZ y City of Mounds View, 1999 Budget 07/17/98 08:19 AM Fund: 100 Department: 4367 General Fund,Athletic Fields Proposed Account Description Budget Detail Description 1600 Supplies,operating 4,750 1,500 Field paint&chalk 500 Surface drying compound 200 Tri mix 600 Nets 200 Bases- 1 set 250 Home plates 5 X$50 1,500 Aggregate 4,750 4800 Bonding&insurance 2,450 2,450 Bonding&insurance 2,450 7040 Capital,vehicles 0 0 Fund: 100 Department: 4380 General Fund,Forestry Proposed Account Description Budget Detail Description 1200 Supplies,landscaping 4,850 250 Seedlings for Arbor Day 100 Chemicals 4,000 Large trees-5 yr tree planting program&replace storm damage 500 Small trees to replace damaged trees 4,850 1210 Supplies,bldgs&grounds 850 350 City Hall flowers 500 Weed control-city hall 850 1600 Supplies,operating 80 80 Film,developing,manuals,pamphlets 80 3030-032 Joint powers forester 22,682 22,682 Amount per joint powers agreement(3%increase) 22,682 3030 'Professional services 8,000 8,000 Boulevard tree trimming for 1/4 of city 8,000 3520 Tree removal 13,500 13,500 Remove diseased trees 13,500 3900 Grants&subsidies 2,500 2,500 Match for tree grant 2,500 26 City of Mounds View, 1999 Budget 07/17/98 08:19 AM Fund: 100 Department: 4460 General Fund,Building&Ground Maintenance Proposed Account I Description Budget Detail !Description 1230 Supplies,equipment 650 400 Air compressor parts,filters,hoses,etc. 100 Pressure washer repair parts 150 Garage door motor 650 1600 Supplies,operating 5,800 500 First aid supplies 500 Light bulbs&ballasts 500 Paper supplies 300 Cleaning supplies 300 Lumber&fasteners 1,300(Paint&supplies-parking lot&building 450 Repair items&hardware 500 Mechanical items,fans,motors,etc 750 Office supplies 700 Steel supplies 5,800 2400 Uniforms&clothing 880 240 10%of uniform cost for one employee 40 Shop coats 600 Rug&towel service 880 3030 Other professional services 1,075 500 Annual fire&backflow inspection 575 Fire extingiusher service 1,075 3210 Electricity 4,500 4,500'Electricity at Public Works building 1-4W 3220 Natural gas 3,300 3,300'Natural gas at Public Works building 3,300 3530 Refuse collection 6,885 2,835'Facility dumpsters 425 Hazardous waste generator permit 500 Used oil filters 25 Batteries 100 Lamps 3,000'Hazardous waste disposal 1 6,885 3610 'Memberships II 80 80 1/4 of APWA membership 80! 4010 'Rental,equipment I 825 475'Copy machine 350Fax 8251 4800 'Insurance ' 16,186 16,1861 Insurance 16,1861 5110 IRepairs,bldgs&grounds 1,650 500(Door&gate opener repairs 900 Building repairs 2501Power washer repairs 1,6501 5130 ;Repairs,equipment j 1,800 200;Telephone repairs 550 Fuel station repairs 400'HVAC system service 6501 Overhead door repairs 1,8001 7030 ICapital,equipment 6,000 2,500 Dumpster???? 3,500'Portable vehicle lift 6,000 I f City of Mounds View, 1999 Budget 07/17/98 08:19 AM Fund: 100 Department: 4462 General Fund,Squad&Staff Car Maintenance Proposed Account ; Description Budget Detail Description 1220 Supplies,vehicles 11,225 900 Filters:oil,air,fuel,transmission 6,400 Tires&batteries 350 Tune up items 1,250 Brake pads&shoes 350 Wiper blades&fluid 500 Visibar repair items 250 Headlamps,spots,&bulbs 175 Misc parts,fastners 500 Minor repairs,rebuilds 200 Anti freeze 250 Air conditioning gas 100 Brake fluid 11,225 1600 Supplies,operating 3,600 400 Specialty tools&hand tools 500 Welding supplies 1,100 Solvents&degreasers 1,100 Fastners&electrical supplies 500 Steel supplies 3,600 1700 Motor fuels&lubs 2,970 715 Engine oil: 150 gallons @$4.75 20 Gear lube 1 175 ATF-7 cases 500 Aftermarket additives 1,560 Unleaded fuel: 1200 gallons @$1.30 2,970 2100 Books&periodicals 525 225 Repair manuals 300 Ignition scanner software updates 525 2400 Uniforms&clothing 1,046 840 60%of FTE uniform 206 Cloth towel&rag service 1 1,046 3030 Other professional services 350 300 Oil filter recycling 50 Battery recycling 350 3610 'Memberships 60 60 1/4 APWA membership ( 60 3630 Training 950 500 Electronics updates,propane updates,other classes 150 GM training 300 Ford training 9501 5120 1Repairs,vehicles 4,500 300 Alignments 400 Radiator repairs,replacement 3,000 Transmission repairs 800 Glass replacement 4,500 30 City of Mounds View, 1999 Budget 07/17/98 08:19 AM Fund: 100 Department: 4465 General Fund,Vehicle&Equipment Maintenance Proposed Account Description Budget Detail Description 1220 Supplies, vehicles 1,450 200 Filters:oil,air,fuel,transmission 500 Tires&batteries 100 Tune up items 100 Brake pads&shoes 200 Propane rebuild kits 350 Misc supplies 1,450 1230 Supplies,equipment 2,275 150 Small equipment tune up items 500 Filters,belts&hoses 1,000 Tire-dump trucks,loader,backhoe 625 Hydraulic system repairs 2,275 1600 Supplies,operating 1,900 200 Chains,devises,hitch pins 600 Steel for repairs&fabrication 1,100 Equipment&vehicle cleaning supplies 1,900 2400 Uniforms&clothing 505 376 30%of FTE uniform 129 Rags,towels,&rug service 505 3030 Other professional services 200 200 Oil filter&battery recycling 200 3630 'Training 375 200'Vehicle inspection recertification 175 Freon certification 375 4010 Rental,equipment 400 300 Specialty tool&equipment rental 100 pager 400 5120 Repairs,vehicles ' 750 550 Transmission repairs 200 Glass repairs 7501 7030 Capital,equipment 6,900 900 Chain saws 6,000 Pickup truck 6,900 3� City of Mounds View, 1999 Budget 07/17/98 08:19 AM Fund: 100 Department: 4470 General Fund,Pavement Management Proposed Account Description Budget Detail Description 1230 Supplies,equipment 300 300 Milling machine teeth 300 1260 Supplies,traffic control ( 360 360 Traffic cones:20 @$18 360 1600 Supplies,operating 2,300 300 Asphalt hand tools,lutes,rakes,etc. 2,000 Asphalt-winter mix,25 tons @$80 2,300 1700 Motor fuels&tubs 1,665 855 Diesel fuel:900 gallons @$0.95. 550 Propane: 1100 gallons @$0.50. 260 Unleaded fuel: 200 gallons @$1.30. 1,665 2400 Uniforms&clothing 1,030 810 80%of FTE uniform cost. 220 33%of Foreman's uniform cost. 1,030 3030 Other professional services 9,950 2,250 Rough cutting of boulevard. 3,200 Striping of crosswalks&school crossings. 3,000 Engineering services. 1,500 Pavement Mgmt software annual maintenance. 9,950 3630 Training&conferences 500 250 Pavement,sealcoating,patching&sealcoating seminars. 250 MPWA conferences. 500 4010 Rentals,equipment 309 0 Rental of crack sealer. 309 Pagers. 309, 7030 Capital,equipment 26,800 26,800 Crack sealer 26,800 7050 Capital,construction 125,000 125,000 Pavement management maintenance&rehab program. 125.000 3y City of Mounds View, 1999 Budget 07/17/98 08:19 AM Fund: 100 Department: 4472 General Fund,Snow& Ice Control Proposed Account I Description Budget Detail !Description 1230 Supplies,equipment 1,900 1,300 Cutting edges,plow shoes 400 Brooms for sweepers 200 Filters 1,900 1600 Supplies,operating 21,035 17,500 Salt: 500 tons @$35 per ton. 2,875 Liquid Mg Chloride: 2300 gallons @$1.25 per gallon. 660 Welding supplies,steel stock,sod for boulevards,etc. 21,035 1700 Motor fuels&lubs 2,870 2,185 Fuel: 2,300 gallons @$0.95 per gallon. 550 Propane: 1100 gallons @$0.50. 135 Engine oil: 30 gallons @$4.50. 2,870 2400 Uniforms&clothing 800 800`80%of FTE uniform cost. 800 3030 Other professional services 775 775 Weather service reports: 5 months @$155 per month. 775 3610 Memberships 145 60 MSSA dues 85 1/3 of APWA membership 145 3630 Training I 1,100 700 '1/3 of APWA conference(shared with water&sewer) 200 MSSA meetings 200 MSSA operator training sessions 1,100 4010 Rental,equipment 655 500 Blade 155 Pagers 655 5130 Repairs,equipment 0 0 7030 Capital,equipment I 1,500 1,500 Two way radios 1,500 36 City of Mounds View, 1999 Budget 07/17/98 08:19 AM Fund: 100 Department: 4475 General Fund,Street Sign Maintenance Proposed Account I Description I Budget Detail Description 1220 Supplies,vehicles 300 100 Tune ups 100 Air,oil,fuel&transmission filters 100 Fluids 300 1600 Supplies,operating 4,550 150 Sign tools and supplies 600 Street name sign blanks 750 Regulatory&warning signs 200 Parking signs 750 Channel posts 200 Tubular posts 200 Sign hardware 800 Shop supplies-fastners,degreasers,etc 300 Neighborhood watch sign hardware 600 Graffitti remover 4,550 1700 Motor fuels&lubs 250 250 Propane: 500 gallons @$0.50. • 250 2400 Uniforms&clothing 410 410 40%of FTE uniform cost. 410 3250 Electricity-traffic signals 6,200 6,200 Electricity for traffic signals 6,200 3630 Training&conferences 425 250 MUTEC,workzone safety 175 Annual hearing test 425 5130 Repairs,equipment 421 421 Traffic signal repairs&maintenance 421 7030 Capital,equipment I 0 0 0 3� City of Mounds View, 1999 Budget 07/17/98 08:19 AM Fund: 100 Department: 4700 General Fund,Miscellaneous Proposed Account Description Budget Detail (Description 0860 Fitness program 3,700 3,700 Fitness program(maximum$40/month paid with sick leave time) 3,700 3900-040 Family&youth social 14,749 14,749 Northwest Youth and Family Services(3%increase over 1997) services 14,749 9100 Contingency 46,000 46,000 Unexpected expenditures 46,000 9900-000 Transfers-miscellaneous . 25,000 25,000 Transfer to Vehicle&Equipment Fund 25,000 9900-052 Bel Rae,net operations 50,000 50,000 Preliminary general fund subsidy for Community Center operating costs. 50,000 1999 Budget Summary 07/17/98 08:25 AM BGT99OTR.WK4 1994 1995 1996 1997 1998 1999 Change from 1998 Actual Actual Actual Actual Budget Budget Dollar Percent Cable TV(210-4350): Revenues 3180 Franchise fee 42,702 41,864 44,505 54,048 44,500 44,500 0 0.00% 3610 Investment income 1,952 2,470 3,207 5,112 3,000 3,000 0 0.00% Donations 0 5,600 5,938 0 0 0 0 ERR Other revenue 6,598 30 0 6,617 0 0 0 ERR Total revenue 51,252 49,964 53,650 65,777 47,500 47,500 0 0.00% Operating expenses Operations(4350) Personnel services 0100 Salaries,regular 0 2,746 2,438 1,289 2,883 1,775 (1,108) -38.43% 0150 Salaries,part-time - 13,021 13,207 10,689 13,015 16,501 16,706 205 1.24% 0321 Pensions 1,500 1,813 1,499 1,646 2,182 2,044 (138) -6.32% 0400 Group insurance 1,860 1,855 1,470 1,722 2,450 1,319 (1,131) -46.16% 0500 Workers compensation 122 128 96 106 195 101 (94) -48.21% Total personnel services 16,503 19,749 16,192 17,778 24,211 21,945 (2,266) -9.36% Materials&supplies 1600 Supplies,operating 1,304 1,025 916 1,923 1,800 1,800 0 0.00% Contractual services 3630 Training&conferences 15 0 0 0 0 0 0 ERR 3900 Grants&subsidies 15,531 15,749 15,406 15,189 15,000 15,500 500 3.33% 5130 Repairs,equipment 195 0 116 0 0 0 0 ERR Total contractual services 15,741 15,749 15,522 15,189 15,000 15,500 500 3.33% Capital 7030 Equipment 10,105 9,656 2,556 11,995 300 15,000 14,700 4900.00% Total capital outlays 10,105 9,656 2,556 11,995 300 15,000 14,700 4900.00% Total expenses 43,653 46,179 35,186 46,885 41,311 54,245 12,934 31.31% Net income 7,599 3,785 18,464 18,892 6,189 (6,745) (12,934) -208.98% Equity,beginning year 31,852 39,451 43,236 112,054 112,054 118,243 6,189 5.52% Prior period adjustment 50,354 Equity,end of year 39,451 43,236 112,054 130,946 118,243 111,498 (6,745) -5.70% 72- 1999 Budget Summary 07/17/98 11:32 AM BGT99OTR.WK4 1994 1995 1996 1997 1998 1999 Change from 1998 Actual Actual Actual Actual Rafted Budget Dollar Percent EDA(495-4530): Revenues 3901 Investment income 0 0 (2,403) 0 (1,500) (1,500) 0 0.00% 3932 Marketing revenue 0 0 850 0 750 750 0 0.00% 3961 Transfers 88,700 93,695 98,078 113,532 2,946,320 2,946,320 0 0.00% 3690 Grants 0 0 0 4,000 0 0 0 ERR 3991 Other revenue 0 0 0 282 0 0 0 ERR 3991 Loan repayments 0 0 2,193 0 0 0 0 ERR Total revenue 88,700 93,695 98,718 117,814 2,945,570 2,945,570 0 0.00% Operating expenses _ Economic Development: Personnel services 0100 Salaries,regular 59,873 67,787 65,916 84,773 81,412 67,720 (13,692) -16.82% 0150 Salaries,overtime 0 0 191 67 0 0 0 ERR 0200 Salaries,part-time 0 327 0 0 0 0 0 ERR 0300 Pensions 6,093 7,430 7,988 9,759 9,875 8,689 (1,186) -12.01% 0400 Group insurance 6,209 7,174 5,071 5,112 4,962 4,800 (162) -3.26% 0500 Workers compensation 251 167 171 420 926 792 (134) -14.47% Total personnel services 72,426 82,885 79,337 100,131 97,175 82,001 (15,174) -15.62% Materials&supplies 1600 Supplies,operating 0 0 0 145 1,500 500 (1,000) -66.67% 2100 Book&periodicals 81 216 220 211 420 430 10 2.38% Total materials&supplies 81 216 220 356 1,920 930 (990) -51.56% Contractual services 3030 Other professional services 12,780 799 2,028 5,002 140,000 140,000 0 0.00% 3420 Advertisements 0 2,730 4,028 409 2,000 2,000 0 0.00% 3430 Printing 1,829 1,620 1,283 6,781 2,700 2,700 0 0.00% 3610 Memberships 125 1,315 7,264 3,236 3,525 3,525 0 0.00% 3630 Training&conferences 1,389 3,389 2,305 2,292 3,100 2,400 (700) -22.58% 3800 Mileage 70 161 110 175 150 150 0 0.00% Total contractual services 16,193 10,014 17,018 17,895 151,475 150,775 (700) -0.46% Capital outlays 7030 Equipment 0 580 1,575 0 0 0 0 ERR 7050 Construction 0 0 0 0 2,650,000 665,000 (1,985,000) -74.91% 7060 Business loans 0 0 0 0 45,000 25,000 (20,000) -44.44% Total capital outlays 0 580 1,575 0 2,695,000 690,000 (2,005,000) -74.40% Miscellaneous: 9900 Transfer out 0 0 0 0 0 0 0 ERR Total miscellaneous 0 0 0 0 0 0 0 ERR Total expenditures 88,700 93,695 98,150 118,382 2,945,570 923,706 (2,021,864) -68.64% Net income 0 0 568 (568) 0 2,021,864 2,021,864 ERR Equity,beginning year 0 0 0 568 0 0 0 ERR Equity,end of year 0 0 568 0 0 0 0 ERR ely 1999 Budget Summary 07/17/98 08:26 AM BGT99OTR.WK4 1994 1995 1996 1997 1998 1999 Change from 1998 Actual Astral Actual Actual Budget Budget Dollar Percent Lakeside Park(255): Revenues 3690 Spring Lake Pk contribution 7,500 7,500 7,500 7,500 6,200 7,500 1,300 20.97% 3610 Investment income 73 0 0 0 0 0 0 ERR 3961 Mounds View contribution 7,500 7,500 7,500 7,500 6,200 7,500 1,300 20.97% 3991 Other revenue 0 779 0 94 350 350 0 0.00% Total revenue 15,073 15,779 15,000 15,094 12,750 15,350 2,600 20.39% Operating expenses(4350): Personnel services 0200 Salaries,part-time 6,378 7,815 6,036 7,714 10,836 9,536 (1,300) -12.00% 0300 Pensions 488 598 462 590 829 829 0 0.00% 0500 Workers compensation - 161 125 101 23 135 135 0 0.00% Total personnel services 7,027 8,538 6,599 8,327 11,800 10,500 (1,300) -1L02% Materials&supplies 1210 Supplies,bldgs&grounds 171 971 548 20 95 95 0 0.00% 1600 Supplies,operating 2,087 2,106 3,480 5,008 1,125 1,125 0 0.00% 2400 Uniforms&clothing 0 0 0 0 150 150 0 0.00% Supplies,operating 2,258 3,077 4,028 5,028 1,370 1,370 0 0.00% Contractual services 3100 Telephone 1,078 919 425 343 250 250 0 0.00% 3200 Water&sewer 0 0 0 1,296 0 1,300 1,300 ERR 3210 Electricity 436 614 479 989 500 500 0 0.00% 3530 Refuse collection 636 722 893 614 780 780 0 0.00% 3560 Satellites 344 311 208 243 300 300 0 0.00% 3630 Training-safety 0 0 0 0 0 350 350 ERR 4800 Insurance&bonds 0 0 0 0 0 0 0 ERR 5130 Repairs,equipment 0 0 0 0 0 0 0 ERR Total contractual services 2,494 2,566 2,005 3,485 1,830 3,480 1,650 90.16% Capital 7030 Equipment 1,119 3,519 0 0 0 0 0 ERR 7050 Construction 558 0 0 0 0 0 0 ERR Total capital outlays 1,677 3,519 0 0 0 0 0 ERR Total expenses 13,456 17,700 12,632 16,840 15,000 15,350 350 2.33% Net income 1,617 (1,921) 2,368 (1,746) (2,250) 0 2,250 -100.00% Equity,beginning year 213 1,830 (91) 2,277 531 (1,719) (2,250) -423.73% Equity,end of year 1,830 (91) 2,277 531 (1,719) (1,719) 0 0.00% Open June 12 to August 15, 1999. Reducing to 6 hours per day for 65 days. Hours with lifeguard on duty noon to 6 p.m. 1999 Budget Summary 07/17/98 08:26 AM BGT99OTR.WK4 1994 1995 1996 1997 1998 1999 Change from 1998 Actual Actual Actual Actual Budget Budget Dollar Percent Recycling(290-4420): Revenues 3360 Grants 22,806 21,647 23,132 25,420 26,846 26,846 0 0.00% 3610 Investment income 39 0 0 (762) 0 0 0 ERR Transfers 0 0 0 159 0 0 0 ERR 3680 Other revenue 500 0 0 0 0 0 0 ERR Total revenue 23,345 21,647 23,132 24,817 26,846 26,846 0 0.00% Operating expenses Operations(4420) Personnel services 0100 Salaries,regular 16,007 10,604 9,877 9,205 8,054 8,054 0 0.00% 0321 Pensions 472 381 1,076 1,047 977 977 0 0.00% 0400 Group insurance 394 0 872 779 600 600 0 0.00% 0500 Workers compensation 213 85 69 33 35 35 0 0.00% Total personnel services 17,086 11,070 11,894 11,064 9,666 9,666 0 0.00% Materials&supplies 1600 Supplies,operating 0 0 1,830 0 0 0 0 ERR Contractual services 3030 Other professional services 0 0 0 0 0 0 0 ERR 3300 Postage 906 1,958 1,312 1,181 1,530 1,530 0 0.00% 3420 Advertisements 0 382 1,922 3,632 3,900 3,900 0 0.00% 3430 Printing 1,741 1,330 1,411 1,489 2,350 2,350 0 0.00% 3530 Refuse collection 750 5,503 5,392 6,401 8,200 8,200 0 0.00% 3960 Awards 1,000 1,200 1,200 1,050 1,200 1,200 0 0.00% Total contractual services 4,397 10,373 11,237 13,753 17,180 17,180 0 0.00% Capital 7030 Equipment 1,825 0 0 0 0 0 ERR Total capital outlays 1,825 0 0 0 0 0 0 ERR Total expenses 23,308 21,443 24,961 24,817 26,846 26,846 0 0.00% Net income 37 204 (1,829) 0 0 0 0 ERR Equity,beginning year 1,588 1,625 1,829 0 0 0 0 ERR Equity,end of year 1,625 1,829 0 0 0 0 0 ERR 1999 Budget Summary 07/17/98 08:26 AM BGT99OTR.WK4 1994 1995 1996 1997 1998 1999 Changefrom 1998 Actual Actual Actual Actual Budget Budget Dollar Percent Street Lighting(240-4416): Revenues Special assessments 0 1,943 0 0 0 0 0 ERR 3745 Street light connections 0 0 0 0 0 0 0 ERR 3746 Penalties 2,719 2,448 2,832 3,039 2,700 2,700 0 0.00% 3740 Street lighting charges 58,025 58,062 58,451 59,754 58,500 58,500 0 0.00% 3610 Investment income 2,309 2,395 2,042 3,282 3,300 3,300 0 0.00% 3690 Cash over&short 0 0 0 0 0 0 0 ERR 3680 Other revenue 176 0 3 0 0 0 0 ERR Total revenue 63,229 64,848 63,328 66,075 64,500 64,500 0 0.00% Operating expenses Operations(4416) Personnel services 0100 Salaries,regular 2,191 2,074 1,040 702 1,594 1,594 0 0.00% 0321 Pensions 264 252 126 76 202 202 0 0.00% 0400 Group insurance 131 60 0 113 198 198 0 0.00% 0500 Workers compensation 5 10 7 6 7 7 0 0.00% Total personnel services 2,591 2,396 1,173 897 2,001 2,001 0 0.00% Materials&supplies 1600 Supplies,operating 0 0 0 0 0 0 0 ERR Contractual services 3030 Other professional services 0 20 0 30 150 150 0 0.00% 3210 Electricity 43,622 46,031 47,010 47,603 51,277 51,277 0 0.00% 5150 Repairs,utilities 1,763 1,495 912 711 2,500 2,500 0 0.00% Total contractual services 45,385 47,546 47,922 48,344 53,927 53,927 0 0.00% Other Contingency 0 0 0 0 0 0 0 ERR Depreciation 0 0 0 0 0 0 0 ERR Transfer Hwy 10 Bridge 0 25,000 0 ERR Total other 0 25,000 0 0 0 0 0 ERR Capital Equipment 7,014 0 0 0 0 0 ERR 7060 Installations 8,895 2,045 0 0 7,875 7,875 0 0.00% Total capital outlays 15,909 2,045 0 0 7,875 7,875 0 0.00% Total expenses 63,885 76,987 49,095 49,241 63,803 63,803 0 0.00% Net income (656) (12,139) 14,233 16,834 697 697 0 0.00% Equity,beginning year 56,933 56,277 44,138 58,371 100,205 100,902 697 0.70% Residual equity transfer 0 0 0 25,000 0 0 0 ERR Equity,end of year 56,277 44,138 58,371 100,205 100,902 101,599 697 0.69% 1999 Budget Summary 07/17/98 08:26 AM BGT99OTR.WK4 1994 1995 1996 1997 1998 1999 Change from 1998 Actual Actual Actual Actual .11utlgct eget Dollar Percent Surface Water(245): Revenues 3550 Spec assessments-prepaid 0 1,943 0 0 0 0 0 ERR 3551 Spec assessments-current 3552 Spec assessments-delinquent 3553 Spec assessments-penalty&int 3730 Utility sales 97,808 97,574 99,538 99,866 98,000 100,000 2,000 2.04% 3735 Utility connections 25,191 10,514 4,953 13,664 6,500 8,000 1,500 23.08% 3736 Penalties 588 968 1,230 1,746 750 1,000 250 33.33% 3610 Investment income 7,633 12,210 17,292 10,409 20,680 19,594 (1,086) -5.25% Transfers 0 0 0 0 0 0 0 ERR 3680 Other revenues 50 0 0 236 0 0 0 ERR 3690 Cash over&short 50 0 0 0 0 0 0 ERR Total revenue 131,320 123,209 123,013 125,921 125,930 128,594 2,664 2.12% Operating expenses System Maintenance(4415): Personnel services 0100 Salaries,regular 5,139 5,361 5,492 4,988 4,583 4,635 52 1.13% 0110 Salaries,overtime 30 31 0 233 915 946 31 3.39% 0150 Salaries,part-time 0 675 0 0 0 0 0 ERR 0321 Pensions 627 443 653 647 705 729 24 3.40% 0400 Group insurance 484 183 264 753 515 515 0 0.00% 0500 Workers compensation 475 0 147 139 212 220 8 3.77% 0700 Beeper time 0 180 85 149 100 100 0 0.00% Total personnel services 6,755 6,873 6,641 6,909 7,030 7,145 115 1.64% Materials&supplies Supplies,vehicles 0 0 0 0 0 0 0 ERR 1230 Supplies,equipment 584 150 0 0 500 500 0 0.00% 1240 Supplies,streets 100 0 39 0 200 400 200 100.00% 1600 Supplies,operating 1,400 740 1,029 1,723 1,675 1,675 0 0.00% 1700 Motor fuels 0 228 0 717 1,425 1,425 0 0.00% 2400 Uniforms 85 221 341 622 585 610 25 4.27% Total materials&supplies 2,169 1,339 1,409 3,062 4,385 4,610 225 5.13% Contractual services 3030 Other professional services 2,364 9,101 11,528 3,570 19,500 19,800 300 1.54% 3630 Training 450 0 200 388 300 300 0 0.00% 4010 Equipment rental 140 150 90 102 100 100 0 0.00% 5110 Repairs,bidgs&gmds 0 52 2,144 0 0 0 0 ERR 5150 Repairs,utilities 1,138 0 0 0 25,000 25,000 0 0.00% Total contractual services 4,092 9,303 13,962 4,060 44,900 45,200 300 0.67% Capital outlays 7030 Equipment 121 23,604 25,847 3,225 0 6,000 6,000 ERR Total capital outlays 121 23,604 25,847 3,225 0 6,000 6,000 ERR Miscellaneous: Transfer out 0 0 0 170,275 0 0 0 ERR Total miscellaneous 0 0 0 170,275 0 0 0 ERR Total System Maintenance 13,137 41,119 47,859 187,531 56,315 62,955 6,640 11.79% S- aZ City of Mounds View, 1999 Budget 07/17/98 08:19 AM Fund: 245 Special Revenue-Surface Water Fund Proposed Account Description Budget Detail Description 3470 Utility sales 98,000 98,000 Estimated surface water charges. 98,000 3472 Utility connections 6,500 6,500 Estimated fees. 6,500 3473 Penalties 750 750 Estimated late payment fees. 750 3901 Interest revenue 20,680 20,680 Estimated income @ 5.50%. 20,680 Expenditures Department 4415 System Maintenance 1230 Supplies,equipment 500 500 Sand nozzles for Vactor 500 1240 Supplies,streets 400 400 Bituminous mix 400 1600 Supplies, operating 1,675 500 Catch basin castings 300 Concrete adjustment rings 275 Cement mix 600 File holders 1,675 1700 Motor fuels 1,425 1,425 1500 gallons diesel fuel @$0.95/gallon for Vactor 1,425 2400 Uniforms 610 610 Uniform allotment 610 3030 Other professional services 19,800 6,000 Plan updates&reviews 4,000 Inspections 7,000 Continuing update surface water management plan 2,800 GIS data input 19.800 3630 Training 300 200(Seminars&training sessions 50 Trench safety seminar 50 Competent person training 300 4010 Rental, equipment 100 100 Pager rental 100 5150 Repairs,utilities I 25,000 25,000 Ditch&retention pond cleaning 25,000 7030 ICapital,equipment 6,00.0 6,000 Pick up truck 6.000 Y 1999 Budget Summary 07/17/98 08:26 AM BGT990TR.WK4 1994 1995 1996 1997 1998 1999 Changan/m.1998 Actual Actual Actual Actual Budget Bhlu get Dollar Percent Water(700): Revenues 3424 Meter charge 0 0 29,016 29,154 38,121 29,000 (9,121) -23.93% 3550 Spec assessments-prepaid 153 940 0 0 0 0 0 ERR 3551 Spec assessments-current 18,743 998 118 0 0 0 0 ERR 3552 Spec assessments-delinquent 155 0 63 0 0 0 0 ERR 3553 Spec assessments-penalty&interest 0 0 0 0 0 0 0 ERR 3610 Investment income 121,629 425,034 140,287 168,216 160,000 160,000 0 0.00% 3631 Water tower space rental 0 0 7,792 42,940 22,000 43,000 21,000 95.45% 3680 Other revenues 13,926 15,254 14,132 6,649 2,500 6,500 4,000 160.00% 3681 Sales tax 0 368 0 0 0 0 0 ERR 3690 Cash over&short 0 39 (35) 1 0 0 0 ERR 3710 Water sales 509,911 543,466 617,268 635,843 626,250 630,000 3,750 0.60% 3715 Utility connections 10,181 5,400 5,715 (1,098) 5,000 5,000 0 0.00% 3716 Penalties 8,153 4,921 5,794 5,598 7,678 5,500 (2,178) -28.37% 3911 Gain on sale of assets 0 0 0 362 0 0 0 ERR 3913 Meter sales 5,975 5,470 6,120 6,741 5,950 6,000 50 0.84% 3972 Transfers 0 0 0 0 0 0 0 ERR Total revenue 688,826 1,001,890 826,270 894,406 867,499 885,000 17,501 2.02% Operating expenses Billing Services(4820): Personnel services 0100 Salaries,regular 56,768 72,686 21,394 18,720 8,580 8,861 281 3.28% 0110 Salaries,overtime 57 159 943 1,582 0 0 0 ERR 0150 Salaries,part-time 0 0 1,626 3,371 5,720 0 (5,720) -100.00% 0321 Pensions 6,423 8,259 2,401 2,506 1,835 1,137 (698) -38.04% 0400 Group insurance 5,847 8,584 1,255 1,613 990 990 0 0.00% 0500 Workers compensation 984 727 171 55 63 39 (24) -38.10% Severance 0 0 0 3,296 0 0 0 ERR Total personnel services 70,079 90,415 27,790 31,143 17,188 11,027 (6,161) -35.84% Materials&supplies 1600 Supplies,operating 0 216 604 604 500 500 0 0.00% Total materials&supplies 0 216 604 604 500 500 0 0.00% Contractual services 3030 Other professional services 4,531 6,124 6,821 3,308 4,000 3,600 (400) -10.00% Program instructors 4,211 0 0 0 0 0 0 ERR 3300 Postage 2,898 3,479 1,785 1,903 2,352 2,505 153 6.51% 3430 Printing 1,036 2,598 415 1,239 4,654 4,655 1 0.02% 3610 Memberships 0 0 0 0 0 0 0 ERR 3630 Training 1,522 1,472 104 320 500 500 0 0.00% 5130 Repairs,equipment 2,337 2.272 2,436 1,498 2,010 1,650 (360) -17.91% Total contractual services 16,535 15,945 11,561 8,268 13,516 12,910 (606) -4.48% Capital outlays 7030 Equipment 0 135 350 0 5,000 5,000 0 0.00% Total capital outlays 0 135 350 0 5,000 5,000 0 0.00% Debt Service: 8010 Principal 0 0 0 0 95,000 100,000 5,000 5.26% 8020 Interest 145,755 354,297 297,762 292,321 288,921 283,086 (5,835) -2.02% 8030 Paying agent fees 436 507 663 463 750 750 0 0.00% Total capital outlays 146,191 354,804 298,425 292,784 384,671 383,836 (835) -0.22% Miscellaneous: Refunds 0 1,180 0 570 0 0 0 ERR 9900 Transfers out 118,580 90,197 92,605 94,500 94,500 94,500 0 0.00% Total capital outlays 118,580 91,377 92,605 95,070 94,500 94,500 0 0.00% Total Billing 351,385 552.892 431,335 427,869 515,375 507,773 (7,602) -1.48% S-6 1999 Budget Summary 07/17/98 08:26 AM BGT990TR.WK4 1994 1995 1996 1997 1998 1999 Change from 1998 Actual Actual Actual Actual Budget Budge! Dollar Percent Water Production(4825): Personnel services 0100 Salaries,regular 18,656 19,692 19,989 28,090 18,333 18,939 606 3.31% 0110 Salaries,overtime 1,515 839 84 446 1,017 1,051 34 3.34% 0150 Salaries,part-time 0 0 0 0 0 0 0 ERR 0321 Pensions 2,447 2,576 3,300 3,667 2,347 2,565 218 9.29% 0400 Group insurance 2,226 1,936 1,837 1,929 1,248 1,248 0 0.00% 0500 Workers compensation 961 414 384 444 747 772 25 3.35% 0700 Beeper time 0 796 1,234 1,819 0 0 0 ERR Total personnel services 25,805 26,253 26,828 36,395 23,692 24,575 883 3.73% Materials&supplies 1600 Supplies,operating 13,941 16,432 16,163 17,719 17,145 17,750 605 3.53% 1700 Motor fuels 1,426 931 374 1,366 2,176 2,180 4 0.18% 2400 Uniforms 703 520 615 576 850 920 70 8.24% Total materials&supplies 16,070 17,883 17,152 19,661 20,171 20,850 679 3.37% Contractual services 3030 Other professional services 5,105 10,175 4,603 4,884 8,270 8,770 500 6.05% 3210 Electricity 68,748 57,279 55,698 52,961 52,000 52,000 0 0.00% 3420 Advertisements 0 71 2,245 146 0 0 0 ERR 3630 Training 0 695 0 175 800 800 0 0.00% 5150 Repairs,utilities 0 29,573 83 0 0 0 0 ERR Total contractual services 73,853 97,793 62,629 58,166 61,070 61,570 500 0.82% Capital outlays 7030 Equipment 2,501 2,369 0 0 2,800 0 (2,800) -100.00% 7050 Construction 0 0 0 0 0 0 0 ERR Total capital outlays 2,501 2,369 0 0 2,800 0 (2,800) -100.00% Miscellaneous: 9900 Transfer out 0 0 0 0 0 0 0 ERR Total miscellaneous 0 0 0 0 0 0 0 ERR Total water production 118,229 144,298 106,609 114,222 107,733 106,995 (738) -0.69% Revenues over expenditures (141,524) (57,338) (158,280) (123,250) (433,866) (375,526) 58,340 -13.45% Equity,beginning year 4,435,067 4,293,543 4,236,205 4,077,925 3,954,675 3,520,809 (433,866) -10.97% Equity,end of year 4,293,543 4,236,205 4,077,925 3,954,675 3,520,809 3,145,283 (375,526) -10.67% 5-Y City of Mounds View, 1999 Budget 07/17/98 08:20 AM Fund: 700 Department: 4823 Water Infrastructure&Equipment Maintenance Proposed Account Description Budget Detail Description 1210 Supplies,Bldgs&grounds 1,600 600 Misc.cleaners for well houses&%of shop 150 Mops,buckets,brooms 200 Paper products 300 Black dirt&sod 200 Paint,thinner,&brushes 150 Light tubes&ballasts 1,600 1220 Supplies,vehicles 750 150 Tune ups 50 Air,oil,fuel,&transmission filters 100 Fluids 100 Batteries 250 Misc repairs 100 Paint sealant 750 1230 Supplies,equipment 1,028 150 Tune ups 200 Air,oil,fuel,&trans filters 150 Fluids 228 Hydraulic fluid:35 gallons @$6.00/gallon 100 Solvents&cleaning fluids 200 Blades,suction hoses,filter screens 1,028 I 1240 Supplies,streets 5,600 300 Asphalt mix&tack 150 Aggregate base 150 Dewatering rock 5,000 Repair of residential services 5.600 1250 Supplies,utilities 6,275 700(Chemical equipment parts 150 Air compresser&dehumidifier parts 500 Paint&sandblasting materials for hydrants 500 Copper,steel&PVC pipe 825 Valve box risers,main repair clamps 1,750 Hydrant repair parts 1,300 Hydrant markers 550 Location flags&paint 6,275 I 1260 Supplies,traffic control 200 200 10 traffic cones 200. 1600 !Supplies,operating 3,200 150 Propane,acetylene&oxygen supplies 250 Film,first aid supplies,&batteries 400 Cleaning supplies 150 Gloves,masks,&rags 1,500 HTC,meter&meter supplies,&muratic acid 750 Additional&replacement hand tools 3.200 1700 Motor fuels&lubs 1,358 95 Diesel fuel- 100 gallons @$0.95 950 Propane: 1,750 gallons @$0.50 313,Unleaded fuel:250 gallons @$1.25 1.3581 2400 IUniforms 1,150 1,0001.7 FTE 150!Safety shoes I 1.1501 City of Mounds View, 1999 Budget 07/17/98 08:20 AM Fund: 700 Department: 4825 Water Production Proposed Account Description Budget Detail Description 1600 Supplies,operating 17,750 550 Computer supplies 3,400 Chlorine: 8 1 ton cylinders @$410 99999999 4,000 60 150#cylinders @$63 99999999 5,300 Hydrofluosilic acid:2,300 gallons @$2.25 99999 3,500 Sulfur dioxide: 40 cylinders @$84 999999 200 Equipment repair parts 800 Testing reagents 17,750 1700 Motor fuels&lubs 2,176 413 Motor oil for well#2-55 gallons 150 Turbine&electric motor oil 148 Oil for standby generator 8 gallons X 4 X$4.50 665 Fuel for standby generator: 700 gallons @$0.95 250 Propane for well#2: 500 gallons @$0.50 550 Propane for vehicles: 1,100 gallons @$0.50 2.176 2400 Uniforms 920 770 .6 FTE 150 Rags&towels 920 3030 Other professional services 8,770 600 Bacteria tests 600 Arsenal contaminant tests 1,120 Full scan tests-4 @$280 800 Random sample tests 1,000 Radon tests 800 Computer maintenance 2,500 Consulting engineer services 750 One-call locating 600 New MCL's tests 8,770 3210 Electricity 52,000. 52,000 Electricity for wells,tower&reservoir 52,000 3630 Training 800 100 N Surburban Utilities Superint'd Assoc. 100 Hach-water testing seminar 600 AWWA conference 8001 7030 Capital,equipment 0 01 oZ • 1999 Budget Summary 07/17/98 08:26 AM BGT99OTR.WK4 V 1994 1995 1996 1997 1998 1999 Changefrom 1998 Actual Actual Actual Actual Budget Budget Dollar Percent Infrastructure&Equip Maintenance(4823): Personnel services 0100 Salaries,regular 21,079 30,498 82,659 68,757 107,883 121,074 13,191 12.23% 0110 Salaries,overtime 1,815 1,167 304 3,351 4,373 4,518 145 3.32% 0150 Salaries,part-time 3,752 3,861 4,312 8,873 4,025 4,148 123 3.06% 0321 Pensions 2,743 4,389 10,369 10,034 13,924 16,431 2,507 18.00% 0400 Group insurance 2,593 2,665 8,834 8,214 8,806 9,511 705 8.01% 0500 Workers compensation 1,912 1,096 999 4,806 2,921 3,538 617 21.12% 0700 Beeper time 0 1,206 2,899 1,638 0 0 0 ERR Total personnel services 33,894 44,882 110,376 105,673 141,932 159,220 17,288 12.18% Materials&supplies 1210 Supplies,bldg&grnds 319 83 112 2,301 250 250 0 0.00% 1230 Supplies,equipment 4,358 1,506 2,957 3,740 2,400 2,700 300 12.50% 1240 Supplies,streets 373 162 0 0 500 500 0 0.00% 1250 Supplies,utilities 1,265 2,955 1,389 4,282 3,600 3,600 0 0.00% 1260 Supplies,traffic control 321 377 200 0 300 300 0 0.00% 1600 Supplies,operating 3,130 524 1,704 1,570 3,800 4,800 1,000 26.32% 2400 Uniforms 730 472 756 1,164 1,085 1,780 695 64.06% Total materials&supplies 10,496 6,079 7,118 13,057 11,935 13,930 1,995 16.72% Contractual services 3030 Other professional services 447 514 2,539 641 3,000 3,300 300 10.00% 3039 Collection expense 3,251 3,809 3,624 3,307 0 3,500 3,500 ERR 3100 Communications-telephone 1,186 871 1,278 1,057 1,531 1,700 169 11.04% 3200 Water&sewer 0 0 0 3,344 0 0 0 ERR 3210 Electricity 1,045 1,059 1,268 1,223 1,242 1,350 108 8.70% 3230 Wastewater disposal-Met Council 594,241 742,100 714,990 731,389 721,584 730,000 8,416 1.17% 3231:_:;Wastewater disposal-other cities 0 0 0 0 0 0 0 ERR 3610 Memberships 0 0 70 115 0 0 0 ERR 3630 Training 320 893 1,461 615 2,050 2,250 200 9.76% 4010 Equipment rental 1,142 856 309 158 1,050 1,150 100 9.52% 4800 Insurance 0 17,375 19,113 12,312 16,187 16,187 0 0.00% 5130 Repairs,equipment 2,694 1,225 0 30 545 545 0 0.00% 5150 Repairs,utilities 5,151 9,273 0 351 1,500 500 (1,000) -66.67% 5160 Repairs,maintenance 0 0 22,603 11,333 25,000 28,000 3,000 12.00% Total contractual services 609,477 777,975 767,255 765,875 773,689 788,482 14,793 1.91% Capital outlays 7030 Equipment 0 0 0 0 0 6,000 6,000 ERR 7040 Vehicles 0 0 0 0 0 0 0 ERR 7950 Depreciation 142,128 138,717 118,519 144,197 140,414 148,000 7,586 5.40% Total capital outlays 142,128 138,717 118,519 144,197 140,414 154,000 13,586 9.68% Miscellaneous: 9100 Contingency 5,974 0 0 0 15,000 15,000 0 0.00% Total miscellaneous 5,974 0 0 0 15,000 15,000 0 0.00% Total infrastructure&equip maint 801,969 967,653 1,003,268 1,028,802 1,082,970 1,130,632 47,662 4.40% 4r City of Mounds View, 1999 Budget 07/17/98 08:20 AM 4. Fund: 730 Department: 4820 Wastewater Administration Proposed Account Description Budget Detail (Description 1600 Supplies,operating 500 500 Computer supplies 5001 3030 Other professional services 3,600 3,600 25%of audit fee 3,6001 3300 Postage 2,505 1,975 Carrier route: 2900 bills X$0.34 postage X 4 billings X 1/2 cost 190 1st class: 275 bills X$0.34 postage X 4 billings X 1/2 cost 340 Reminder notices:500 bills X$0.34 postage X 4 billings X 1/2 co>t 2,505 3430 Printing 4,655 4,635 Utility bills 20 Reminder notices 4,655 3630 Training 500 500 Seminars on new regulations,updates,etc. 500 5130 Repairs,equipment 1,650 900 Accounting software support(30%) 750 PC repairs 1,650 7030 Capital,equipment 5,000 5,000 50%of misc equipment costs 5,000 9900 Transfers out 68,690 38,690'Transfer to General Fund for admin costs 30,000 ITransfer to Vehicle&Equipment Fund for vehicle use 68.690 I • • 4'6 City of Mounds View, 1999 Budget 07/17/98 08:20 AM Fund: 730 Department: 4823 Wastewater Infrastructure&Equipment Maintenance (continued) Proposed Account Description Budget Detail (Description 3630 Training 2,250 500 NSP locator seminar 150 Work zone safety seminar 700 Engineering seminars 900 AWWA conferences 2,250 4010 Rental,equipment 1,150 300 Barricades&signs 350 Copy machine 300 Fax machine 200 Pagers 1,150 4800 Insurance 16,187 16,187 Share of property insurance 16.187 5130 Repairs,equipment 545 95 Fire extinguisher recharge/repair 250 Misc repairs 200 Repairs to motors&pumps 545 5150 Repairs,utilities 500 500 Repairs to RTUs 500 5160 System maintenance 28,000 28,000 Sewer main&manhole rehabilitation 28,000 7030 Capital,equipment 6,000 6,000 Pickup truck 6,000 7950 Depreciation 148,000 148,000 Estimated depreciation 148,000 9100 Contingency 15,000 15,000 Contingency 15,000 6I' ,L a 0 ,1 O N 00 as n o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o[ I O O O O O O a T 00 0 0 0 0 0 O O 0 O O 0 00 0 O V1 0 M 0 0 Nil I N 0 N 00 h 00 h O in 01 0 1� O 0. coN O ni N d• M^ N 8 N N MN M m 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a 00 b 0 0 0 0 0 0 0 0 0 0 O 7 0 0 N 0 V1 0 7 7 7 0 7 O M hON ^'Vh1 t0�1N h 00- $NN 00 h M N N. N M N M M 7 0 0 0 0 0 0 0 o 0 0 0 0 0 0 0 0 0 0 0 0 OI a 00 N 0 0 0 0 0 O O o O O 00 O O O N O O N N O N 0 00 � N N.�b o h b g b 0,0 7 V1 01 .N. h O N V1 h M 7 N N N N N M 0 0 0 0 0 0 0 0 0 0 h 0 0 0 h h 0 0 0 0 h a h h 0 0 0 0 0 M 0 M M M b V1 O N 0 0 10 V1 •. M m M 0 . ~ en V01 0 N v1 N 0 g Vii vel M N 7 N 7 7 ten 000000000000,000 0 0 0 0 0 0 e�7 0 0 0 0 0 0 0 0 0 0 0 0 0 O. 0 0 in 0 h 0 0 Vf h h 0 0 h O T N M 7 •-� h ao �+O h 7 7 00 Vi h O 5 7 V1 0 Mh s •o h M V1 N - M N M M 7 0000000001000. 000n 010 0in 0 0 0 0 in in ..h 7 0 0 0 N �• o C 0 M M M C 7 I`O 00'0 7 00 00 ,QM 5 N V1 .--,h N M N 7 e:,� R R M vii 0 0 0 0 0 0 0 0 0 0 0 N O 0 0 N N 0 0 0 0 N e 7 01 0 O in 0 S 00 7 0 0 0 0 0 O ON. et VNl M h N n ^ 0 N R 0 M• el 7 a 00 • O 0 0 0 0 0 0 0 05 0 0 0 0 0 V1 01 0 0 0 0 in M M 0, 0000 h 00 h h 0 0 h a 10 O V1 o h M O O 0, V1 O c,...1, G O i - 01 7 en .--N 0 M ON O .N.�O. • = 7 V1 N V1^ M O N M M h Iy M N M M M N ,O • 0 00000000000 00001 0/00000/ a N10 o 0 0 0 0 V1 0 7 0 0 01 OS 0 0 0 01 7 V I 0 0 N 0.0 ON 0 0 V 1 O O 0 n O h 0 h h M T 10 O 00 V1 00 00 8 7‘0 ,o' N 00 0• I` O 00 N - 7 01 N N h N 7 h M O 7 N 7 N 7 7 V1 V 0 0 0 0 0 0 0 0 in 0 0 0 0 0 v11 01 0 0 0 0 01 a^-.M 0 0 0 0 0 00 0 0 0 001 00 0 h V O 0 V1‘.0N V1 N M 01 U1 V1V1 O V1 p N^7 ^ 7 N N inN as a OS- T M 0 - N .fir N N M 00000000010 -.0000 000007 e 0 0 0 0 0 010 H 0 0 10 V1 01 N O. N 0 054 V1 ie 0 V1 0^C 7 I-00 0.0 O M N a,N N� N -7 7 N'O_' t+Nll H en (nil hi N M r+Nl I N M 7 V1 I2 IO 1.20. O T H y N LTt0. 00 .. C H N G 21 'R T O E v ' c e En o V1 u w d uZ > v 03 0 `. T U V v = 7 .,'. 4 W Cl 6,13 T.W p T 2 t. W N._h.1 H i0w `o U o 0 W o c w' on•- c o•— ,, w . •a ° I I ^ `v m R •0 p V E d = H I .o o • ¢ U o y = I I E • E u '� °' zc " S • LT/° I a o st a_9 cL. CT 0 C� 3 c 88888 0 8800008 0 oOO OO� 0005 00000 0 wn �n, r.; 0 O N 01 `0 N VI C0 .-. C N 8 N N 0 0 0 0 0 0 0O' 0 0 0 08 0 040000 2255 § 0 0 0 0 0 0 0 0 2a no0o00 ,ntngr.'0 0 N 0�1�0 N ..41N 0 N S N N 0 0 0 0 0 0 0 0 0 0 8§...0§ 0 0 C .-•.~N M VI N Y G 0 N a 0 N N 00 0 0 0 0 0 0 0 0 0 I00 Q o 0 0 0 8 0 0§o 0 0 o s O O O O vl O 0 Vl O OSS- S- C.-• ^ N O ni^ vi n 8� ... 0 N b N N 0 0 0 0 0 O O 0800008 0 040000§ 0 0 0 0 0 0 0 0 wl 0 0 E E 0 0 Q.0 0 .41 O V 1 y 0- 0 p -N to N Vi .1 . 8 N Q N • N O O 0 0 0 0 O 0:2.0.00§ 0 O O O o O O o Q 0 0 0 0 0 0 O O 8 O O O O d 000000 O 0, r O 00 0� _ o .-+- N m •0 N N O O -N 00 0 N V1 C N N 00008 0 0 0$0000 0 0 0 0 0 0 O 0 O O O i 0 0 0 O Vl 0 Vl so. p' 4.4 0'-+^N 0 M VI N 0 -N M O, Q.4 0 N ..41 0 [F,i•.'� N N Os 0 0 0 0 0 o 010 80000§ O O 01....g ' os 0000 0 o .^, 00 0 ?co0 0,f- ✓ F$ ---cmN V1 er N M U 7 ' ."' N O 7 O F• L N w N 7 y 0 0 0 0 0 0 O 8§§000§ 0 0 0 0 g 0 0 0 0,4 O•• E�000O 0 0 O 0,,,,17:,9: ae E OO ..; L -� N M .W.. 0 VI N L S .-N M W M N 00 0 OT. N .-. � L N U e .e 8 0 0 0 0 8 E O O O O 0§....§ w o0 00 o 0 I0 c 00 0 0 0 0 0 0 0 Vl 0 15, w w9 Q N 2 0 yyVm"10 — h N Oi 00 0 U Ia N t C 04 UI UI 00 0 00 0 00 0800008 i o 0 00800008 i° 0 0 0 00 0 0 0 0 0 0 00 i� L 0 0 O O O 0 vl o •nom E .1. v so vl�.e C. 0, 0, -. M N•� N V1 �l Y E N 00 U as -. N I.7 o IO; o I 0 w N L-n n r `7 T.-N ry n r L CO 0 O e. O L C L ',II C C C "5 '5 0 0 T U U 0 „, '5 U V U U U 0 ,.•-.p.. U T T n. 0. T E a 3'o n. T o.•a Ea Ea-2 3 C,T_O. O T T N G.11 Q'O•V C V O' 4,S O' O'u O V G U C O V U U V F U '0 0 u U U U.Q U l' U 0•p U U U U •rj 0 ami d 50 v ^0° E v 'E ami e Lo °' y u v `6 " S' E E .T.• O U i° m U.Q •v E 0 U n 43? ip O .274. 15.5•U us O V U O uao > so0oua . vF• Fff U•o Ou • r ix a 0 0 0 0 0 0 0 o o 0 o a o 737- 0: '0 0 v o 'o 0 0 0 0 0 0 0 0 o e 0 0 0. 000.8 . g > 00. 00,40 4 4 (A gci u 0@ .- E a s .. m m . m a a= - m m m m a a o - 0 0 E E aa) U 0 U cUL £ U aa U 00) 0. °' 0. ... ars gcc cc cc cc a g E °G E a"' a 000 = e °' E Cmc � a v SL. — u o - > .. Uy T m o � - 0 E „, U 8 c m hcx ; N2 3 y v TY ..- •11r2 o • CS c o e S 0 a m. `m 8 v 0 u Ec_ v? m 0E m ' E : -- 2-.12 0v 1oH0 m- . 71 ._w ` .po.. 1.):,? 4 W on U O 5' . oto-.md b o U C w m 0 0 f, CTP 3 M 2 a. r N v,0 d C L Q O0 2255 0000000 0 0255g0000q 0 0 ip O pO N N 00.0... O 0100..Q , N 0 0� EMS 8 0 0 N N 0.\-..... 0 0 0 0 052 0 so 0 p 0 0 g9 0 0 '�+ ,r+ Cl N O 0,1 o000g C\ O s 0000n O • ry ,0 O 0? _ O �o,,- 8 N N 8 ;. — h a N 0 V1 N N 0000000 Q O O O 25 05 00S 25 0.0. 0 0..00 205 ON 4o Ir N en 8 0000000 0 O 00000 I, O O pO _ 25 C C o0 0 cad H1 Sn N N 0 0 0 0 0 0 0 7 00 N N 0 0 0 0 ry Cl N O 05 0 M1 tel e 8 � _ N Cl N 0os o g 0 0 0 0 0 0 0 0 0 0 0 0§0 0 0 0 0 ea o 0 0 0 0 E 0 00 O 0 ory u_n o C S p b N ^ M � v C N C N 0 W. W 1 Q Q Q 7 u O 0§0o0os >, y nr o 0 0 H o V'aS§025;7- E 0090 4 L 8 a oo oa• vi so' a§ vv it ag. N a: bri 000.-.0S wloo°e 0000000 $ . w ,33 a N N W a L w U L O* L w L H 0 L c C U 0po00004 -0000 - N h,_,,7,..0.00.07 V 00 a1 h 0 Y 00 a .... 00 .-. N N C C w �— — — -rvn-.r {7 Ti N —en s 7 -h N h — .. -ry 0-s0 R 11. y 9y . O C L C . a U Ci 00 0 0 0 0 4) 0 0 0) p0 E c9 EEEEEEE v U E r) ;9 •= T, a aaaaaa9•e m 0. R E :ate ao 0 cN cc0ccc0 %.o Hce'a _ . ' ' ' .4y � NR «o = LE'U L•v _ v v v v v v v 4 v v - _ R 0 c c13 v E a' a e O L 03 O " °) pHt o -E , wv • p), v Ff O 'E R R R R R R-2 "• p 3yp 2 j P. 0 00 0 o o•o vc e a 0 u h u v e $:8 [- a 7 p 083 0 0 77O RvU O]yUNUaUpC S /1 E a vvvvvvv v R0d R v a r R.. N RRR R c4 Oe R 24 6 o R ( so w C' . v v 0 �S °. xa axaaaaa a g �a 0 0 a , e e 0 0 oa E 3 Ove ti ' ye p « e o 0 e v 00 i 0ev• to a-0�vac 9 `�0. RaEo °^ aE22g8Emgfa2aTs0o • .: 4 � • 0U0Nsg -0 T v '0 a j 0y R yyU'U 3E °,- °Vy R R— -[.Q U v 1" c..p a+ u 2 H V a d d u aa • Y- ug(, a `'3 '.-0:1 '-' ° .9."?! Y g CA E U e u e em,v .6 u R E d 3 N `� v�? � a"i m g v v C7 R G. �c .e. = `L' 2 0 ,, g u v Q .- • v c- o v 0 z m u at o u Is.° .e 2. a'= y J 0 u. V E v y = vw e W LL. W Q a. a. n 4.TPS t 2 a o cat 0 0 0 e 0 e 0 0 L_ L 7 L 9 .O 'O °° Ory Cry Ory Ory C 0 0 0 1 ' G G G O ' O O G O 0 0 0 0.9-0000?, O o o$ G; o o 0 o o I$ io 0 0 n 0 0 0 leo 0000 0 ,"b o 0 0 0 o•.- Li: 00 I co N N N N N vt N O o g0 0 0 0 52 0 0 0 0 Q p '8 0 0 0 0 .00000 g 0 0 0 CO. ES O O O O O? O O v f O O . O O O O O M 0 I` I` 8ren l Vl 00 S O N t� CO,'t 'e 8 N • 0R o o o o 8 00O Q oo o Oq OOO0 400008 0000000 0 5 Os V1f T ' � 0 O 0 0 0„g 8 llM § 0 O Vi 8 N Vl v' C' 1. N '-•N 7 N 1 1 _ • 0 0 8 0 0 0 0 4 O 0 0 8 0 0 0 018 0 0 O O 08000” C°°°°°0 .n ez OOO.0 22055 0 OOO VO'f..e O N l� 8 M Vl 00 an a - co O N^� M 8 in ON N N — N .0 N N 0080000 000$0000,$ OOO O$ 00 o G$ CGO .... O0CO0 "0 O O O opt0p▪ l:s N0M v1 00 O O v1 O7 to 0 l".. 8 N '.n 0 N O O1 o 0004 OOO 0000§ 000 00000¢ 0000000 41 OOOoi OOO$ et O 88 i ori v 00 8 CCv. C ut 7 hy MO N N O OQo Ooo g O O O 0 0 0 0245 O O O 0000 0000000 C C O OO,j A e e O C O O O 8 G :p l�N :p NN M V1 00 :p C O O Os 8 10 O (a 0 O 0 p 0 0 vl „M„ O O O N I:, N LO N O N yr Os cl.sce 0 O'$0000p E p p Ob 0000.5 s O 0 0 0 OQoo oo8 W 0000000 O0 � 22055 ' OOa0$ ko y krt. OOO -i; P 8 .> al 'a O O a{5 M kf 00 al 5.-� C 0 vi ,0 at p y 4p M M ratp p 7 v1 CM. O.p N N •..N ^N O 7 7 p O4 Go0o O O O'O 0 00.0 7 O O O O 040 0 0 0 7 O 0„.....g o w o0a a k. 00 Op W 000 ooa 8 W 0025 000 000p 000 0,0,4 g oow o dg oo y�,,uo � � oov C n do vi u, ES M M y y 7 h< y N N I. N I.iN y N 8 y N V r.j U U U g U e ' 000 G Go"I•.+ 0 000 O o'-a- O G 0 ,flN O N n 0 co 0 O O 5 $ O 020.00§ 00.0 0 00000 :1` O O O O O C 0 0 0 O- 0, • enm Cr, a an OS 8 03 05 ., .. .o ., o 8 ., 0 0w 0..H %OOO80000O p0000001 OOOOOOOOOo$ ( 0000000 O 0 • 0 0 O. - sr1 O V J- e` of O co O O o O O 0, ovi MOWN E 0— en n -et n E 00 oOf " 0 i 01 N N y 0� 0 L -- Q --- -n n y r 0 H. Nnt .n :. .34 .5 E I. v 'C I' O y O 0 O - a O .0 • 4 '' a 00 0.o 0- U in W m Ce 00 oa a m • E .4 2 ` uE e0 . .o Hm. .e v d oNB P L 0 Q.1� 3 N U y 0 0L.0.0 E .. C g . 11-0 aTi 1•y X X .0 0 0 ." am iO 'I.; d > 6 F � > > F F . O N N N 0 1 E L e c v e F ° . o Fo E 0; ° v ° R. 40@ so a o a Cy 0. e E E &IU � E F/3w E w na'a Li, wx N o N N 05 N N r .. 0 ..4. 4.4 N C N C 0o E O O . C O p p O 0 e O y L O vt d O y N 01 O .. 0. v ° E a_o E a ... 0g e N� m E c Av ti y E x A 0 yII ? O 0 bt a 0 c.C = 0) .. u 23 0.o` $ Q a c E E A o c G E a. E .c A G 3 .� N y 9 t0 a p O 1.1 U'O C e• n d O I) o Ifj y o E C 0 a a O u O y 2 'G N 'O w =� a N 'p s e a 'p"'2 0 = 0 0 2 ° Z •o U L s. 7 a °' H 9 e a 6t.O 8 e a U x x.7 U B •e a' a B 0 8 0 Ca 8 0 6 ran w 4. %. w .' c.rP7