Loading...
HomeMy WebLinkAbout2.a. 2018 Budget EXECUTIVE SUMMARY City Council Work Session: July 10, 2017 AGENDA ITEM: Preliminary Review of Draft 2018 Budget AGENDA SECTION: Discussion PREPARED BY: Logan Martin, City Administrator Jeff May, Finance Director AGENDA NO. 2.a. ATTACHMENTS: Draft 2018 Budget APPROVED BY: LJM RECOMMENDED ACTION: Discuss draft 2018 Budget and provide staff direction on needed modifications. BACKGROUND Over the last few months, staff has been working diligently to develop the attached 2018 Budget. Finance Director May and I met with each Department Head to review their budget proposals and to discuss the costs and benefits of each proposal. The draft attached here is the 3rd draft internally, with nearly $400,000 of requests eliminated through the course of the review process. The preliminary 2018 Budget shows an increase of 6.82% to the operating budget, which results in a 6.9% increase in the property tax levy. The impact of this levy increase on a median valued home is projected to be $63 per year. The City’s tax rate (the percentage used to calculate the City’s portion of the property tax) is projected to be 42%, as compared to 41.8% in 2017. This rate is still lower than it was in 2016 (43%), which is a reflection of the growth of the City in recent years and the effect of added taxable value. Revenues The City’s tax base (tax capacity value) is preliminarily increasing by 6.3% for 2018, or a total increase of $1,748,952 to the City’s taxable value. In 2017, the City’s tax base also increased by 6.3%. Non-tax levy revenues generated by the City are projected to increase by 11.2% ($981,800) in 2018. Licenses and Permits, the fees generated by growth and construction activities, are conservatively projected to grow 4.8% next year. If some of the significant projects that staff is working on come to fruition, these numbers could drastically increase in 2018. Expenditures Below is a description of notable changes to each department’s budget. Some discussion is provided below, however a detailed presentation and discussion surrounding these initiatives will occur during the work session. City Council Initiative Increase over ’17 Budget Community-wide survey (last done in ’16) $22,000 Increase contribution to Leprechaun Days Fireworks $3,000 2 Administration This category includes Elections, Administration, and the General Government budgets. Finance Community Development Police Initiative Increase over ’17 Budget Increase in all-employee training efforts • Reflective of Council’s staff development goal $4,000 Modification to account for General Elections in ’18 $25,300 (comparable to budget for ‘16 Election) Initiative Increase over ’17 Budget Add 1 FTE (Accountant) on 7/1/18 • Responds to growth in operations / community since 2006 (year the last position was added in Finance) $34,300 Increase hours of part-time IT Specialist • 10 add’l hours per week to assist with increasing demands placed on our current IT Coordinator. $20,500 Initiative Increase over ’17 Budget Add 1 FTE (Econ. Dev. Specialist) on 7/1/18 • Creates increased staff capacity to engage in marketing, outreach, business retention and attraction efforts. $42,900 Initiative Increase over ’17 Budget Add 1 FTE (Patrol Officer) on 3/1/18 • Position added after the Detective promotion occurs; would increase ability to provide adequate staff size to meet service minimums, while reducing overtime due to staff shortages. (Position partially funded via $15,000 grant from Commerce Dept.) $83,700 Promote Officer to Detective (stipend pay) $3,000 Increase in Dakota Communications Center annual fee • Annual fee reflects a 3-year rolling average of calls in Rosemount. Recent increases to call volumes in Rosemount have resulted in fee increases. $22,600 3 Fire Public Works This category includes Gov’t Buildings, Fleet Maintenance, Street Maintenance, and Parks Maintenance budgets. Parks and Recreation Port Authority RECOMMENDATION Staff requests the City Council provide direction on any needed modifications to the draft 2018 Budget. Initiative Increase over ’17 Budget Increase Chief stipend $8,000 Increase Assistant Chief stipend $4,000 Increase firefighter rate from $10/hr. to $12/hr. $33,500 Add’l leadership training for officers $4,700 Initiative Increase over ’17 Budget Increased project needs on long-term Building Maintenance program $18,000 Purchase two traffic counters • Perform traffic studies in house, reduced reliance on consultants. $5,000 Increased project needs on long-term Parking Lot Maintenance program $20,000 Additional crack sealing / sealcoat (moved from CIP) $30,000 Add’l hours for PT Horticulturalist $6,000 Topdressing, sod, wood chips, and mulch needs $15,000 Construct Erickson Park dumpster enclosure $4,000 Sprinkler repairs and water spigot at Chili Park Comm. Garden $5,000 Increased project needs on long-term Parks Maintenance program $25,000 Initiative Increase over ’17 Budget Increase Steeple Ctr. / Rec. Coord. to 32 hrs. + benefits • Add 6 hours per week to market and book more events; manage ever-increasing programming schedule at Steeple Center. $22,800 Increase programming for Seniors $3,000 Initiative Increase over ’17 Budget Marketing partnership with Retail Strategies • Supplement staff efforts to develop data, market, and recruit retail users for vacant parcels / buildings. $50,000 FUNDING REQUIREMENTS-USES July 10,2017 2017 2018 Adopted Proposed Departments Budget Budget Difference Percentage Council Budget 272,500 $298,000 $25,500 9.36% Administration Budget 671,200 676,700 5,500 0.82% Elections Budget 20,000 45,300 25,300 126.50% Finance Budget 528,100 610,800 82,700 15.66% General Government Budget 323,600 334,600 11,000 3.40°/o Community Development Budget 1,052,500 1,124,900 72,400 6.88% Police Budget 3,930,300 4,218,500 288,200 7.33% Fire Budget 384,000 438,706 54,700 14.24% Public Works Operating Budgets: Government Buildings Budget 574,300 615,400 41,100 7.16% Fleet Maintenance Budget 653,500 676,500 23,000 3.52% Street Maintenance Budget 1,423,500 1,533,1D0 109,60D 7.70% Parks Maintenance Budget 940,aaa 1,OD0,800 60,800 6.47% Park&Rec Budget-General Operating 1,286,000 1,329,300 43,300 3.37% Park&Rec Budget-Steeple Ctr.Operations 111,400 119,400 8,00 7.18% Park&Rec Budget-Special Programs 91,800 85,400 6,400} -6.97% Transfers-Arena Assistance 130,000 130,000 0 0.00% Total Operating Budgets-General Fund $12,392,700 $13,237,400 $844,700 6.82% Building CIP Requirements 24,000 24,000 0 0.00% Street CIP Requirements 811,400 783,900 (27,5D0) -3.39% Equipment CIP Requirements 580,000 600,000 20,000 3.45% Insurance Budget Requirements 260,000 280,000 20,000 7.69°/o Port Authority Operating Levy 58,000 110,600 52,60Q 90.69% Bonded Indebtedness 346,056 344,682 1,374} -D.4Q% Water Enterprise Fund 1,653,400 2,363,50d 710,100 42.95% 5ewer Enterprise Fund 2,202,000 2,528,900 326,900 14.85% Storm Water Enterprise Fund 1,285,400 1,184,400 (101,000) -7.86% Arena Enterprise Fund 610,100 535,700 (74,400) -12.19% Total Funding Requirements 20,223,U56 $21,993,082 $1,770,026 8.75% FUNDING REQUIREMENTS-SOURCES July 10,2017 2017 2018 Adopted Proposed 1- Types Budget Budget Difference Percentage Internal Revenue Generated: Licenses and Permits 695,9 0 729,200 33,3 a 4.79% Intergovernmental 710,600 747,800 37,200 5.24% Charges for Services 1,123,800 1,169,100 45,300 4.03% Fines&Forfeits 120,000 115,000 5,000) -4.17% Recreational Fees 242,100 236,500 5,6b0) -2.31°/o Miscellaneaus Revenues 148,800 163,800 15,000 10.0$% Transfers In 3,500 3,500 0 0.00% Enterprise Revenues 5,750,900 6,612,500 861,600 14.98% Total Internal Re enues 8,795,60D 9,777,400 981,800 11.16% Levy Sources: Special Levies 346,056 344,682 1,374) -0.40% General Levy 11,081,400 11,871,000 789,600 7.13°/o Total Levy 11,427,456 $72,215,682 $788,226 6.90% Total Revenue Sources 20,223,056 $21,993,082 $1,770,026 8.75% 20'17 GENERAL PROPERTY TAX LEVY PAYABLE 2Q18 GENERALLEVY GENERAL FUND 10,072,50fl BUILDING CIP FUND 24,000 STREET CIP FUND 783,900 EQUIPMENT CIP FUND 600,000 INSURANCE FUND 280,000 PORT AUTHORITY OPERATING LEVY 110,600 T TAL GENERAL LEVY 11,811,000 BONDEDINDEBTEDNESS G.(. PUBLIC FACILITY REFUNDING B NDS 2010B (Old 2001C) (Port Authority) (Authorized-$167,625) 167,625 G.. IMPROVEMENT BONDS 2013A (Authorized-$8,701) 0 G.O. IMPROVEMENT B NDS 2014A(Authorized-$3,448) Q G.O. CAPITAL IMPROVEMENT PLAN (CIP) REFUNDING B NDS 2015B (Authorized-$177,057) 177,57 T TAL BONDED INDEBTEDNESS 344,682 GRAND TOTAL 2017 PROPERTY TAX LEVY 12,215,682 Last Updated 6/30/17 SPREAD LEVY COMPUTATIONAL WORKSHEET INCLUDING FIRE STATION LEVYj Proposed) 2015 2016 2a17 2018 Total Funding Requirements 18,237,547 18,828,402 20,223,056 21,993,d82 Less: Internal Revenues 7,409,800 7,789,100 8,795,600 9,777,400 Equals: Revenues Needed 10,827,747 11,039,302 11,427,456 12,215,682 County Auditor Adjustments(All Subtractions): Fiscal Disparities Distribution Levy(Metro Area) 1,172,199 1,121,469 1,175,131 1,175,131 (2) Spread Le y Used to Compute Local Tax Rate 9,655,548 (1) 9,917,833 (1} 10,252,325 (1) 11,040,551 Increasel(Decrease}from Previous Year in Spread Levy 2.72% 3.37% 7.69°/a 1) Actual Spread Levy Based on Numbers from Dakota County 2) 2018 Number Provided by Dakota County as of 8Ixl18 Last Updated-6130117 o a v o mm rn o n o n a, o, o. , x x v m a °o o ; x x °'C a - N n(m °# (((( m a Cn((m u, (C1((-1 mLO V C C`G N `C a I f0 d f/ 7`G`C y S`G UWO fD N O (D 7 N N y O n T• 0 O 7 p O 7 N 0I ydc --m °7 m c - o, m c° rn °2 m -- o, n a y m K m A O m D n x w 2 mQrn , Z-m A m 'Z rn rn 7 m c Z7 N d i O y 1?rn dWw.ZJ x N ...C7 N N .(]-. N 97 N (D X 1n .n..r N .n-. Npxry,3 (U J v!x y J N y 3 nO.In Q NCC C N C333uuu uiiiiiijiio00 ; i I o 0 0 II O O O II ; O O O N jj I O O O II -` O O O O N EII W O O O II O O N N A II I I O O O I I O N O I I I rs A OD y '' I I N I N I O N O O O N N A N p CJi A W QIIA D A Co c0 A Q II O O W(T A i II pp I p) N U W f0 II O O W Ui N {II N A OD V W W W O O II c0 m I A A II V A W I W W Cn O O II cp 61 I A II Cn O(T O O A J A Vt p II cD W I O(D W II A O O O A N V A Q II cD W V O O O II II II II II 11 II II II Q p 11 II O O O II i jl O O O jj O O O 0 O I N W W 11 ' O O O II O O O O O N ' N N II A W O O O II p O N N A N A 11 I I O O O 11 p O N N A W N 11 O N O II A W W-+ W V O A N N O N O II 0 A W OD N V I O II W tp W p cp A O v O II O t0 W O OD A I I O N 11 p (r p O V O 11 O f0 W O OJ N I c0 c II W cT ! O 01 A O W O II v O W O W A O m 11 A O N O W O II V O W O W O OD II Cn O OD O Q c0 W A O O O O II c0 V T A N W O O II Ol O c0 O l OD 01(D A p 11 f0 I Ql A N O O- II II II II II II I II II I C II O O O j II O O O I p . N i o0o ii o I o000 ii o0o ii o o000 II I 0 O O II fD i O N N A II O O O i i II?W i O N O II pp A W(70 N W I ' Tl I D II N N I O N O II A W N N m I D II W cD W W c0 A O l O II N I (O W O O .p i II O O Cn Q1 cD O I O II N I I II A Cn pD Q O Q? O W O II c0 O W O A I . 11 N A V O-+-N O W O II (p O W O A -N. I .N-. I N II N O W O A t0 W A OD O O O II Q1 v A(O W I I II O t0 O N I p7 f0 cD O O O II I v A tD O I I G C v ii ii ii ii ii d ii ii ii Ij ii ii o o a ii I ii o 0 0 I v 2 Q a ii ii o0o ii o000 ii o0o ii -` ii i o00 i o ii v+ t I o00 i ooa a m 1n v II 11 A J O N O 11 1 A Co A II W N i O N O 11 O O IV IJ A N p N (7 Z N T II W 11 I N O l O O I O O W CT ' II O 61 W ' U 01 O O O II O O W(l- W+ W T T7 O G1 N O II O 11 .... I 6 OD O c O II f0 01-+J A A II W I I m O CO O II c0 m I A A N 7 U J C 11 W 11 O OD O Cn I O I W Q O c D O II c0 W!O(D O 11 po O N O 01 D<D O O O O II (D W V 0 f0 po c m co u n n n n m n' a x o p u n u u u rn ii ii ii I i ii N a 7 p j » < II II O O O jj O O O O O N A.P jj O O O II ' O O O N N N O x n Q Q' II II O N O II Co I A W A A A A N N O N O II 07 A W 00 N A N p c0 O N N j p O J O O D W O W -i V O O 1 1 p p 1 N N c 0 O V O I I O ( f 0 W O O D W D O ry T C r N II (p II W p(,n W W O II v O W O W A O O II J cD A Cn V W II V O W O W A O 61 M Z O. n T = II A II O A O W 01 f0 N O O O II f0 l O1 A N O O O II I O-+O Q1 i (,n O](J D O O O II fp 1 QI A N O+ 6 t °-' `` u u u u u o m c i ii ii I ii ii v C !'n g, -i d c ii ii o 0 o i I c ii o 0 o ii t! o ii ii o 0 0 0 0 0 0 0 0 0 o a o T m ii ii o 0 o ii m ii o 0 0 oo Q fD o µ.x 1 or"NA u n mo Q v O n N II N II _ ? _ O N O II W I A W OD N A m D N N O N O II p D I A W W N N I m D a Z T y p'n N Cf II N II > O N(O j J O W O II N I c0 W O O N II tD 01 W -(T(Op O W O I O W O A A i N p y - p N O II O II W p1 O 6Y V1 A O O O 11 p O W O A A . II GD UD O , 'A N,p O O O 11 V O1 A cD , ' , a aOC Np II W II O A O(O W(O- II W I J 6>c0 O II N O O Cn Cn J r( A o,a mm v n Cm Q n a • 00 O O A N G`C n tU n C o Z ii ii ii ; m Z N . 7 N 0 ry II i i N II II N 7 p v II ' 0 II II O. d .-{ 1-o o `" o o0o ii - o00o N ii o0o ii o000 ' N i '2 j A A p X O O O I p N W A I I I y O O O II r Zl O N O II p7 J W OD I II W I N I O N O O O N N A N i C A OJjdm rn( m n owo ii oocoaou I '''ii r. cn I a o orno i o ' owcn A I °' I 5 p n N O N N O CT O 11 N pD(n N 11 O O N O O O O II c0 ' m-+I A 1 I 7 n N O N O II W A m N 11 N O O (.f W CO(O O O 11 cD W J O c0 I Z m N V 0 m ' II 11 11 C m o « u n I u i I 3 v,o0o ii M i o00 N N O O O I I --` O O O O N O O O O O O O O ' N I N N j p n O O O II p N 1 A II I O O O II f0 O N N A I ' 6 A 11 k a N N p O N 7 O CT O N fl I rl A O N O N O 11 W A W OD N I v I t0 Cn Ca y II A f!61 O O V O II O O W O OO A I C7 OG O1 tn O OD O II A W O N V II p.W N I(O W O W O II I O W O W I I (li( T r d O O N O CO O I I J O D m J 6) I I l O Q 1 O s N O J A rl O O O I I c0 V m A N O D OO i i a f N II I d II II i m C C N o00 I o00 I I ° 7 fAit o o0o ii - j o00o I N w ri o0o ii o ; o000 V O Q O O O II O i O N N A x II I O O O II p O N N.A pfONOIIWi (n W(p(r I II w N I O N O II p) I A W CO N N (T I CDOCOIIOON I II s 1 A I -CT O O O v O II N i (D W O O A I V1 G7 Cn R1 n O O A O II OD i W V W(T d II U+ W N I f0 A O W O II t0 O W O.A I . Q f W O.P O II (D W W N d II N D 61 N OD A N O O O II rl Ql A(O Oo p Q O n N D o O m av d m A m c m a i v ii ii a N N N II II II3 N O O O I C II O O O N N W m N ro D O O O jj O O O O N y II O O O jj O O O O N } }r [n N V1 O.— O O O 11 O O N N? II O O O O C A OD W 01 OODO) .A O O O N O O N O ;i A j 11 W N O N b N O 01 O O O y(. II v pp fp -+1 pp N O O 11 O O j(T OO W O Q1 D W N O O O II cp p1 I A N 11 W N A O N U1 O O II c0 I A f0 y v' 1 3 0 o O c D O II (O W I O(D II c0 O O O D V Ui CO O O O O II <O W I O(O O] a o N p j II II II v v j X 11 II II i i x x W 0 O O O II II O O O II i x x V v=i O O O jj O i O O O O N jj i O O O II I O O N W N 0 0 0 11 O O O II fD O N N A ' II i i O O O II O O N O II W I A W bJ N II W i N O N O fD O N N N O cD 3 j C O N O O l O II O c0 W O Oa J Q1 i W OD N O V O CO W O I I C) [' n a (T O O W O II I O W O W II N A A V O W O II O W O W cD O 67 p a o o O p O II fp V 01 A N II W O O N I N Q1 j N O O p II f0 I O1 A N LO OO i N N y O II I I I I d O O O II CT I N I II O O O II I N d 0 0 0 0 ii ro I I ii iicoaoiio o00o e i I o0o ii o 000o I 3 ,p O O O p O N N A II O O O II tp O N N A T O V N O O v O II N I (O W O O 3 I vmi I II Ql OD 0 61 OJ N O v O II N A W W N N ( Tl ,a cno owo ii owoa ii r.> A owo ii cn owoA j m o o O O O II I V 61 A(O II O O s O O N 61 s CO O O O II 01 I V 01 A cD W f N N G`G'G N N N N N: C7 C m N N N O x 0 0 V N y T 1 n d A X N N ID N N M a d m 3N O N N V M V IG O t0 H NIN O O«i P N A V W N O Page One 2018 BUDGET WORKSHEETS GENERAL FUND REVENUES July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget 101 31010.00 Current Ad Valorem Taxes 7,437,178 $7,615,397 $7,858,155 $8,172,869 8,897,369 From County 101 31440.00 Fiscal Disparities 1,208,535 1,172,199 1,121,469 1,175,131 1,175,131 From County Total Taxes(Tax) 8,645,713 8,787,596 8,979,624 9,348,000 10,072,500 Total Property Tax Levy for Fund 101 101 32110.00 Alcoholic Beverage Licenses(L) 36,695 42,080 45,005 40,OOQ 36,600 101 32160.00 Licenses to do Business(L) 7,990 8,410 7,070 8,500 8,500 Garbage Haulers,Ped Licenses,etc. 101 32162.00 Lic to do Business-Rental Housing(L) 12,500 4,025 12,525 5,000 12,000 101 32180.00 Tobacco Licenses(L)0 5,500 0 7,000 0 Every Other Year 101 32210.00 Building Permit Revenue(L) 515,616 453,003 564,558 480,000 510,000 101 32212.00 Mineral Extraction Permit(L) 1,860 2,600 3,300 1,500 2,000 101 32220.40 Electrical Permit Revenue{L} 20,222 23,535 24,547 20,000 24,000 101 32221.00 Admin Fee-Electrical Permits(L) 8,048 6,742 7,399 7,000 7,000 101 32230.00 Plumbing Permit Revenue(L) 47,318 62,316 47,711 50,000 50,000 101 32240.00 Animal Licenses(L) 1,741 1,791 1,863 1,800 2,000 101 32250.00 Sewer Permit Revenue(L}9,675 11,315 10,375 9,000 10,000 101 32255.OQ County Recording Fee-City's(L) 120 160 120 100 100 101 32260.04 HVAC Permit Revenue(L} 68,600 71,267 64,134 65,000 65,000 101 32290.00 Other Non-Bus Lic&Permits(L) 380 2,020 3,950 1,000 2,000 Alarm Permits&Fireworks Permits Total Licenses&Permits(L) 730,765 694,765 792,555 695,90Q 729,200 101 31024.00 Delinquent Ad Valorem Taxes(I) 113,74D 58,970 53,128 0 0 From County 101 31030.00 Mobile Home Taxes(I) 12,257 6,316 10,201 7,000 8,000 From County 101 31710.00 Gravel Taxes(I)39,275 83,275 94,782 100,000 110,000 From County 101 31810.00 Franchise Taxes-Regular Fees(I) 227,039 227,388 238,378 227,000 235,000 From Cable Company 101 31811.00 Franchise Taxes-PEG Fees(I) 22,111 21,627 21,412 22,Q00 0 Moved to Separate Fund 101 31920.00 Forfeited Tax Sale Apportionment{I) 0 0 0 0 0 From County 1Q1 33100.00 Federal Grants&Aids{I) 0 96,190 0 0 0 101 33416.00 Police Training Reimbursement(I)160,347 177,808 193,588 195,500 From State 101 33416.xx Post Board Training Reimb 7,000 15,000 1Q1 33416.xx State Aid(Tied to PERA) 165,5D0 180,500 101 33418.00 M5A far Streets-Maintenance(I) 32,790 41,235 41,235 41,300 41,300 From 5tate 101 33423.00 Ag Preserves Credit(I) 3,736 7,347 2,617 4,OQ0 4,000 From State 101 33425.00 Other 5tate Grants&Aids(I) 58,620 46,220 263,210 46,000 61,0 0 From State and State Agencies 101 33425.xx PERA Aid 6,500 101 33425.xx Auto Theft Grant 15,000 For New Officer 101 33425.cx All Other Grants&Aids 39,500 101 33624.00 Other County Grants&Aids(I) 22,536 23,000 24,000 24,000 25,000 Dakota County Recycling Funds 101 33630.0 Pofice Ser ices Levy-ISD#196(I) 64,128 64,769 65,417 66,800 68,000 101 33630.00 Liaison Funding 68,000 From ISD#196 101 33720 Other Organization Grants 0 2,500 6,750 0 0 Total Intergovernmental(I) 756,579 856,645 1,014,716 710,6 0 747,8D0 PAGE TOTALS 10,133,057 10,339,007 10,786,895 10,754,50Q 11,549,500 Page Two 2018 BUDGET WORKSHEETS GENERAL FUND REVENUES July 10,2017 2018 2017 Object 2018 2014 2D15 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 34103.OQ Zoning&Subdivision Fees(C) fi0,915 44,545 62,355 42,000 50,000 101 34104.00 Plan Checking Fees(C)212,622 185,952 223,331 192,000 204,000 101 34105.00 Sales of Maps&Publications(C) 160 124 40 300 10 Maps&Spec Books 101 34107.00 Assessment Searches 0 0 626 0 D 101 34108.00 Admin Fees-Other Funds(C)135,000 101 34108.01 Applicable Funds Except Const. 25,000 25,000 25,000 25,000 25,0 0 101 34108.02 Construction Funds 66,83D 116,079 138,859 85,000 110,000 85%of 5°/a Fee for Canst.Projects 101 34109.00 Other Charges for Service(C) 4,322 7,331 3,877 5,Ob0 4,000 101 34114.00 Service Chg on Returned Chks(C) 90 60 0 100 100 1D1 34113.00 Application Fees(C) 0 0 5,000 0 101 34150.00 User Fees-SKB(C) 82,943 149,072 116,841 180,000 186,004 SKB Fees-C&D Cell Fees 101 34151.00 User Fees/Host Agreements-SKB(C) 25,OOd 0 0 0 0 101 34151.00 Landscaping Agreement 0 Landscaping Agreement 101 34 52.00 User Fees-SKB(C) 28,690 25,675 26,395 25,000 25,000 SKB Fees-MSW Ash Charges 101 34153.00 User Fees-SKB(C) 390,484 325,253 381,764 420,000 420,OD0 SKB Fees-Base Service Charges 101 34160.a0 National Guard Maint Fees(C} 50,560 50,560 50,560 54,500 54,500 101 34160.Q0 Shared Space Maint.Agreement 16,000 Snow Removal!Mowing 101 34160.00 Building Maintenance Contract 38,500 101 34201.00 Special Police Services(C) 13,362 14,852 17,fi52 16,000 16,000 Contractual O/T for Officers 101 34202.00 Fire Services-Fireworks Permits(C) 750 750 1,210 700 700 No Longer Charge for Burning Permits 101 342D3.00 Accident Reports(C) 0 5 2 0 0 _ 101 34204.00 Day Care Inspection Fees(C)50 50 100 100 100 101 34206.00 Other Police Services{C} 526 4,654 1,583 2,000 2,000 101 34207.00 Other Fire Protection Services(C) 15,902 16,278 21,463 17,600 101 34207.01 U of M Fire Contract 5,200 5,500 101 34207.02 Coates Fire Contract 10,700 11,100 a 101 34207.03 Other Billed Fire Calls 1,000 1,D00 101 34303.Oa Mow Weeds(C} 4,112 2,188 2,387 3,Q00 3,000 101 34304.00 5weep/Plow Streets(C) 987 871 372 700 500 ___ 101 34306.00 Other Highway&Street Rev(C) 40,563 72,058 16,211 40,000 40,OQ0 Street Light Bills-Developers 101 34310.00 Right-of-Way Permits(C) 11,446 18,534 30,853 12,000 12,000 101 34407.00 City Share of Metro SAC Chgs(C) 2,309 5,407 5,069 3,500 4,50D Total Charges for Services(C) 1,037,621 1,065,295 1,131,552 1,123,800 1,169,100 101 35101.00 Court Fines(F)116,384 114,580 108,561 120,000 115,000 Fram County Total Fines&ForFeits(F) 116,384 114,580 1Q8,561 120,040 115,000 101 34718.00 Tournament Fees(R) 12,606 20,538 20,009 18,000 20,OOQ 101 34720.0 Park Reservations(R) 2,168 4,678 3,875 4,000 4,000 101 34721.D0 Softball Revenues(R) 37,559 25,369 21,310 25,000 15,OOQ 101 34724.00 Tennis Revenues(R) 2,480 1,995 2,526 2,200 2,204 101 34726.00 Rosettes Revenues(R) 2,222 1,966 1,924 2,000 2,000 101 34727.D0 Field Trip Revenues(R)9,000 101 34727.02 Adult/Senior Trips 7,621 10,072 9,850 7,000 9,000 101 34728.00 Adult Exercise Class Revenues(R} 9,942 53 0 0 500 101 34730.D0 Run for the Gold Revenues(R) 5,540 4,344 4,494 4,800 4,800 101 34731.00 Youth Soccer Lessons{R)2,441 1,364 2,713 2,400 2,400 101 34732.00 Adult Basketball Revenues(R) 2,054 1,867 2,707 2,000 2,00 101 34733.00 Other Programs Revenues(R) 13,014 11,180 17,059 13,OOa 13,Q00 101 34735.00 Camps Revenues(R) 23,873 26,851 39,538 30,000 30,000 101 34736.00 T-Ball Lessons{R) 4,130 3,961 5,193 4,OOb 4,0 0 __ 101 38080.00 Banquet Room Fees(R) 43,171 51,089 42,962 50,000 50,000 101 38081.00 Auditorium Fees(R) 5,973 7,310 6,413 6,500 6,500 101 38082.00 Gymnasium Fees{R) 26,242 29,292 28,947 28,000 28,000 101 38086.OD Classroom Fees(R) 8,968 9,448 9,924 9,000 9,000 101 38096.OD Liquor Provider Fees(R) 660 600 540 600 6 0 101 38097.Dd AN Rental Fees(R) 456 450 1,020 500 500 101 38154.00 Adult Enrichment Revenues(R) 631 527 0 600 500 101 38201.00 Rental Revenues(R) 4,8 0 19,614 28,000 28,040 Steeple Center Operations 101 38205.00 AN Rental Revenues(R) 0 0 513 2,000 2,000 Steeple Center Operations 101 38207.00 Liquor Provider Fees(R) 0 0 52 0 0 Steeple Center Operations 101 38209.00 Miscellaneous Revenues(R)175 0 0 0 0 Steeple Center Operations 101 38211.00 5ecurity Services(R) 651 0 1,187 2,500 2,500 Steeple Center Operations 101 38215.00 Other Revenues(R) 0 0 744 0 0 Steeple Center Operations Total Recreation Fees{R) 217,377 212,956 243,114 242,100 236,500 PAGE TOTALS 1,371,381 1,392,831 1,483,226 1,485,900 1,520,600 Page Three 2018 BUDGET WORKSHEETS GENERAL FUND REVENUES July 10,2017 2 18 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 361D1.OD Principal-Special Assessments(M)4,457 0 0 0 From County-101 Funded Projects 101 36102.00 Penalties&Interest-S/A(M)195 0 0 0 0 From County 101 36210.0 Interest Earnings-Investments(M) 176,177 122,664 150,491 120,000 120,000 101 36214.00 Net Change in FV-Investments(M) 231,871 16,629 (97,708) 0 D Annual Market Value Changes 101 36215.00 Interest Earnings(M) 122 837 1,987 800 1,000 From Checking Account 101 36220.OQ Rents&Royalties(M) 17,371 18,399 4,570 3,OD0 3,OOD 101 36220.01 Garden Piot Rentals 2,000 Antenna to Water Utility Fund in 2016 101 36220.02 Athletic Complex Land Rental 1,000 101 36230.0 Contribution/Donations(M) 28,756 39,800 44,196 0 0 101 36260.00 Other Revenue(M) 2,086 11,524 18,313 10,500 10,500 Includes$7,500 for Health Reinsurance 101 36262.00 Special Settlements(M) D 0 D D 0 101 36263.00 Wellness Program Revenues 3,926 15,643 14,295 10,000 0 5witched Health Ins.Providers 101 36265.00 Use of Reserve Funds(M) 41,000 0 74,300 0 0 101 36265.01 Elections Balancing 0 0 0 0 0 25,300 Elections Balancing 101 36265.Q2 Health Insurance Adjustment 0 0 0 0 0 Health Insurance AdjlAssignment 101 38090.00 City Concessions(M) 4,229 4,099 3,554 4,500 4,000 Total Misc Revenues(M) 510,191 229,594 213,998 148,800 163,800 101 39202.0 Contribution from Enterprises(T) 3,500 3,500 3,500 3,500 3,500 Arena-Building &Grounds Maint. 101 39203.00 Transfer From T) 0 12,623 93 0 0 Funds Returned from Projects Total Transfers In{T) 3,500 16,123 3,593 3,500 3,500 PAGE TOTALS 513,691 $245,717 $217,591 $152,300 167,300 FUND TOTALS 12,018,129 $11,977,556 $12,487,712 $12,392,700 13,237,400 INTERNAL REVENUES 3,372,416 $3,189,959 $3,508,088 $3,044,700 3,164,900 Grand Total Less: Ad Valorem Fiscal Disparities Page Four 2018 BUDGET WORKSHEETS GENERALFUND REVENUES July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 34108.00 General Fund Admin Fees 25,000 $25,000 $25,000 $25,000 25,000 101 34108.01 Fund 201 6,000 101 34108.2 Fund 202 2,500 101 34108.03 Fund 203 2,500 101 341Q8.04 Fund 206 2,500 101 34108.05 Fund 207 2,500 141 34108.06 Fund 605 1,000 101 34108.07 Fund 606 1,000 101 34108.08 Fund 6 7 1,Q00 101 34108.09 Fund 650 6,000 Admin Fees Breakdown Totals 25,000 $25,000 $25,000 $25,000 $25,000 $25,000 Page One 2018 BUDGET WORKSHEETS COUNCIL July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 4111Q 103.00 Salaries&Benefits 37,346 $40,976 $40,897 $41,300 41,900 Salary,Taxes,PERA&Benefits 101 41110 01 225.00 Landscaping Materials 45,181 26,368 25,280 25,000 25,000 Funding From SKB Revenues 101 41110 01 307.00 City Promotional Fees 48,100 101 41110 01 307.01 Newsletter 14,424 14,357 14,277 15,000 15,000 3 Newsletters 101 41110 01 307.02 Chamber of Commerce Directory 1,000 1,000 1,Q00 1,100 1,100 101 41110 01 307.03 Community Survey 0 0 0 0 22,000 101 41110 01 307.04 Community Events 0 7,000 7,000 7,000 10,000 Leprechaun Days Fireworks 101 41110 01 315.00 Special Programs 982 2,725 2,057 3,000 3,000 Promotions,Marketing,etc. 101 41110 01 319.00 Other Professional Services 33,000 101 41110 01 319.01 Education Reimbursement 10,230 5,521 0 12,000 12,000 101 41110 01 319.02 Intergovernmental Initiatives 4,177 7,644 11,495 15,000 15,000 101 41110 01 319.03 Open Government Intiatives 0 0 7,500 6,000 6,D00 Open Gov 101 41110 01 321.00 Telephone Costs 400 101 4111 Q 01 321.02 Mayor's Cell Phone 389 389 389 400 400 101 41110 01 329.00 Other Communication Costs 0 0 500 500 500 Newspaper Ads/Open Houses 101 41110 01 331.00 Travel Expense 8,000 101 41110 01 331.01 NLC Conference 4,092 4,302 3,310 6,000 6,000 101 41110 01 331.02 Miscellaneous Tra el 1,112 2,776 1,978 2,000 2,000 101 41110 01 433.00 Dues&Subscriptions 28,600 101 41110 01 433.01 LMC Dues 16,700 17,485 18,254 18,500 18,500 101 41110 01 433.02 AMM Dues 7,597 7,656 7,714 8,000 8,000 101 41110 01 433.03 Dak Cty Regional Chamber 0 0 0 100 100 101 41110 01 433.04 NLC Dues 1,861 1,861 1,861 2,000 2,000 101 41110 01 433.05 Miscellaneous Dues 0 0 0 0 0 101 41110 01 435.00 Books&Pamphlets 0 0 0 100 100 101 4111 D 01 437.00 Conferences&Seminars 14,000 101 41110 01 437.01 Registration&Hotel-LMC Conf 1,003 1,552 2,662 2,000 2,000 101 41110 01 437.02 Registration&Hotel-NLC Conf 7,40 10,538 8,581 9,000 9,000 101 41110 01 437.03 Miscellaneous Conferences 875 674 787 3,000 3,000 1Q1 41110 01 439.00 ther Miscellaneous Charges 381 0 4D0 4Q0 400 101 41110 01 598.00 Council Designated 573,534 337,226 72,019 85,1 0 55,oao '14&'15-Assignment for Projects 101 41110 01 598.01 Assignment for Health Ins. Increases D 0 0 0 0 101 41110 01 598.02 IGH Ice Time Agreement 0 0 0 0 30,000 101 4111D 01 598.03 Salary&Benefit Contingency 0 0 0 0 0 101 41110 01 599.00 Employee Recognition Costs 10,000 101 41110 01 599.01 Employee Recognition Costs 2,787 3,340 3,814 3,500 3,500 101 41110 01 599.02 Vending Machine Costs 3,206 3,928 2,744 4,000 4,000 OfFset by Revenue from Machines 101 41110 01 599.03 Commemorations 971 1,311 760 1,200 1,200 101 41110 01 599.04 CommissionNolunteer Recognition 1,322 394 103 1,300 1,300 PAGE TOTALS 736,211 $499,025 $235,383 $272,500 298,000 DEPARTMENT TOTALS 736,211 $499,025 $235,383 $272,500 298,000 Page One 2018 BUDGET WORKSHEETS ADMINISTRATION July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41320 101.00 5alaries&Benefits 404,313 $412,421 $489,643 $547,500 552,700 5alary,Taxes,PERA&Benefits 101 41320 102.00 Full-Time Overtime 0 0 0 0 0 101 41320 103.00 Part-Time Salaries&Benefits 5,359 4,322 332 0 0 101 41320 01 209.00 Other O ce Supplies 31 0 304 300 300 Miscellaneous Purchases 101 41320 01 313.00 Temporary Service Fees 0 0 225 0 0 1 Q1 41320 01 319.00 Other Professional Services 0 0 0 0 0 161 41320 01 321.00 Telephone Costs 1,322 1,322 1,901 1,600 1,600 Administration Cell Phones 101 41320 01 331.00 Travel Expense 1,200 101 41320 01 331.01 NLC Conference 0 0 0 0 0 101 41320 a1 331.02 ICMA Conference 391 0 255 700 700 101 41320 01 331.03 Miscellaneous Travel 226 252 227 500 5D0 101 41320 01 433.D0 Dues&Subscriptions 2,700 101 41320 01 433.01 MCMA Dues 275 281 289 300 300 101 41320 01 433.02 MAMA Dues 0 0 0 0 0 101 41320 01 433.03 MCFOA Dues 35 85 70 10D 100 101 41320 01 433.04 Munici-Pals 25 25 25 100 100 101 41320 01 433.05 IIMC Dues 185 0 0 200 200 City Clerk Association 101 41320 01 433.06 ICMA Dues 1,831 1,877 842 1,900 1,900 101 41320 01 433.07 APMP Dues 50 40 0 100 100 101 41320 01 435.00 Books&Pamphlets 0 0 0 100 100 101 41320 01 437.00 Conferences&Seminars 8,800 101 4132Q 01 437.01 Registration&Hotel-LMC 482 687 S00 700 700 101 41320 01 437.02 Registration&Hotel-MCMA 629 1,444 743 1,500 1,500 101 41320 01 437.04 Staff(1)Each 0 0 0 0 0 101 41320 01 437.05 Miscellaneous Seminars 40 17 0 300 3 ULI/Greening Initiatives 101 41320 01 437.06 Registration&Hotel-ICMA 2,995 1,556 1,114 3,400 3,4a0 101 41320 01 437.07 City Clerk Training 1,507 2,224 1,722 2,70b 2,700 All MCFOA Events-MMCI 101 41320 01 437.08 Registration&Hotel-NLC 0 0 0 0 0 101 41320 01 437.09 Miscellaneous Meetings 0 111 119 200 200 101 4132Q 01 439.00 Other Miscellaneous Charges 202 20 176 200 200 101 41320 01 580.00 Other Equipment Purchases 6 0 188 200 500 PAGE TOTALS 419,9D2 426,683 498,975 562,600 568,100 Page Two 2018 BUDGET WORKSHEETS ADMINISTRATION July 10,2017 2018 2017 Object 2018 2 14 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 41320 31 305.00 Medical&Dental Fees 9,600 Employee Drug Testing 101 41320 31 305.01 Pre-Employment Physicals 1,177 1,725 1,378 90D 1,300 101 41320 31 305.02 Employee Drug Testing 1,716 1,588 922 800 800 101 41320 31 305.03 PCORI Fees 284 343 365 0 0 101 41320 31 305.04 Reinsurance Costs 0 7,371 5,104 7,500 7,50D Costs Reimbursed by Grants 101 41320 31 346.00 Personnel Testing&Recruitment 1,825 6,198 0 8,000 6,d00 101 41320 31 315.00 Special Programs 6,000 101 41320 31 315.01 Employee Training 0 132 965 1,000 5,000 101 41320 31 315.2 Health&Wellness 594 500 501 500 1,000 Wellness&Health Management 101 41320 31 315.d4 SW/WC Co-op Weliness Grant 3,912 15,557 14,015 10,000 0 Costs Reimbursed by Grants 101 41320 31 319.00 Other Professional Services 5,600 101 41320 31 319.01 Labor Consultant 0 0 1,385 560 500 101 41320 31 319.02 Labor Legal Issues 0 1,148 3,080 700 7Q0 101 41320 31 319.04 COBRA Consultant 518 715 663 800 800 1D1 41320 31 319.05 Flex/VEBAAdministrative Fees 1,945 1,920 1,912 2,OOQ 3,600 101 41320 31 319.D6 SWWC Co-Operative ues 0 0 0 0 0 101 41320 31 331.00 Travel Expense 599 635 525 6Q0 600 101 41320 31 341.00 EmploymentAdvertising 1,956 927 442 1,000 1,000 Vacancies 101 41320 31 391.00 P.C.Maintenance 0 0 0 3,500 3,500 Neo Gov-Annual Maintenance 101 41320 31 394.00 P.C.Software Purchases 0 8,500 3,500 0 0 Neo Gov-Initial Purchase 101 4132 31 433.00 Dues&Subscription5 1,1 DO 101 4132Q 31 433.a2 IPMA Dues 249 174 298 300 300 101 41320 31 433.03 MPELRA Dues 200 275 800 600 800 101 41320 31 435.00 Books&Pamphlets 0 0 0 100 100 Books&Training Materials 101 41320 31 437.00 Conferences&Seminars 1,300 101 41320 31 437.01 MPELRA State Conference 485 601 849 800 1,000 101 41320 31 437.02 Personnel Seminars 171 75 300 300 300 1D1 41320 31 437.03 5afety,Supervisor,Policy 0 0 0 0 0 101 41320 41 315.00 Special Programs 300 101 41320 41 315.01 General Marketing 0 0 0 300 300 101 41320 41 315.02 Histarical Monuments 0 0 0 0 0 101 41320 41 319.00 Other Professional Services 6,OD0 101 41320 41 319.01 Website 4,751 5,983 8,079 6,500 6,000 101 41320 41 319.02 Website Improvements 0 0 0 0 101 41320 41 328.00 Cable Supply Costs 1,016 864 0 1,000 1,000 Cable Supplies,Software 101 41320 41 329.00 Other Communication Costs 0 0 0 65,100 101 41320 41 329.01 Cable JPA Payment-General City 45,934 54,388 72,510 60,000 65,000 101 41320 41 329.02 Video Streaming Council Mtgs 0 60 60 100 100 101 41320 41 329.03 Bulk E-Mail System D D 0 0 0 101 41320 41 331.00 Travel Expenses 52 55 49 100 100 101 41320 41 433.00 Dues&Subscriptions 75 75 75 100 100 MAGC 1D1 41320 41 437.00 Conferences&Seminars 0 0 0 100 200 Technical Courses 101 41320 41 580.00 Other Equipment Purchases 371 0 539 500 1,000 PAGE TOTALS 67,829 $109,808 $118,315 $108,600 108,600 DEPARTMENT TOTALS 487,731 $536,491 $617,290 $671,200 676,700 Page ne 2015 BUDGET WORKSHEETS ELECTIONS July 10,2017 2018 2017 Object 2018 2014 2D15 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 41410 01 103.00 Part-Time Salaries 18,117 0 $44,555 0 38,0 0 Election Judges&Front Desk 101 41410 01 203.00 Printed Forms&Paper 568 0 1,230 0 700 Ballots&Programming 101 41410 01 2D8.00 Miscellaneous Supplies 147 0 527 0 200 101 41410 01 219.00 ther Operating Supplies 306 0 472 0 400 Food for Election Judges 101 41410 01 242.Od Minor Equipment 0 0 836 0 1,aoo Signs&Miscellaneous 101 4141D 1 3D4.00 Legal Fees 0 0 0 0 0 101 41410 01 319.00 Other Professional Services 0 0 0 0 0 101 41410 01 321.00 Telephone Costs 0 0 Q 0 0 101 41410 01 351.00 Legal Notices Publishing 0 0 4,139 0 500 Election Publications 101 41410 01 391.00 P.C.Maintenance 6,200 6,355 0 0 0 Elections S/V1!Maintenance Costs Utiliizing Laserfiche) 101 41416 01 409.Od Other Gontracted Repair&Maint 4,500 101 41410 01 409.01 Maintenance for Voting Machines 1,225 0 0 5,000 4,500 101 41410 01 409.02 Maintenance for Accuvotes 1,000 0 0 0 D 101 41410 01 412.00 Building Rental 0 0 0 0 0 Possible Rent for Locations 101 4141 D 01 439.00 Uther Miscellaneous Charges 0 0 11 0 0 101 41410 01 580.00 Other Equipment Purchases 0 11,200 0 15,000 0 PAGE TOTALS 27,562 $17,555 $51,771 $20,000 45,300 DEPARTMENT TOTALS 27,562 $17,555 $51,771 $20,000 45,300 Page One 2d18 BUDGET WORKSHEETS FINANCE July 10,2017 2D18 2017 Object 2018 2014 2015 2Q16 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41520 101.00 Salaries&Benefits 395,125 $406,312 $412,833 $430,70D 452,300 Salary,Taxes,PERA&Benefits 101 41520 101.00 Salaries&Benefits 0 0 0 0 34,300 New Accountant(80%)(Start 7/1) 101 41520 101.00 Salaries&Benefits 0 0 0 D 32,500 New IT Specialist{80%)(P/T) 101 41520 102.00 Full-Time vertime 2,826 1,629 4,468 3,000 3,000 101 41520 103.00 Part-Time Salaries&Benefits 0 0 1,895 12,000 0 Intern 12-15 Hours Per Week nly if IT Specialist Hired) 101 41520 01 321.00 Telephone Costs 1,322 1,322 1,429 1,500 1,500 Cell Phone Allowances(2) 101 41520 01 331.00 Travel Expense 1,400 101 41520 01 331.01 Finance Director 449 409 321 1,200 1,200 National Conference Included 101 41520 01 331.02 Staff 0 129 346 100 200 101 41520 01 391.00 P.C.Maintenance 71,600 101 41520 01 391.02 Remote Desktop Services 900 900 1,410 1,5D0 1,500 101 41520 01 391.03 Incode Software Maintenance 9,168 9,595 10,211 10,d00 12,000 101 41520 01 391.04 General Network Support 20,000 20,000 25,OD0 25,000 25,000 Block Hours of Support Time 101 41520 01 391.06 Fixed Asset Maint Contract 1,365 1,365 1,5Q0 1,400 1,6 0 Increased Cost and Need^^ 101 41520 1 391.D7 Miscellaneous Repairs&Maint. 2,794 711 2,351 2,000 2,500 101 41520 01 391.08 Anti-Virus Software Renewal 1,188 1,188 1,188 2,000 2,000 101 41520 01 391.09 File Server Software Maintenance 8,707 5,764 5,224 7,000 7,000 101 41520 01 391.10 Managed Backup Services 11,D10 11,D60 12,900 19,000 20,000 Outgrowing Current Capacity 101 41520 01 392.00 P.C.Accessories&Supplies 2,075 1,766 2,999 3,000 4,OQ0 City System Supplies 101 41520 01 393.00 P.C.Hardware Purchases 675 2,192 2,027 2,000 3,000 101 41520 01 394.00 P.C.Software Purchases 2,000 101 41520 01 394.02 Miscellaneous S/VV Purchases 352 1,754 1,034 2,ODD 2,000 101 41520 01 409.00 Other Contracted R&M 225 225 225 300 300 Non-Computer Equipment 101 41520 01 433.00 Dues&Subscriptions 800 101 41520 01 433.02 MnGFOA-Finance Director 60 60 60 70 70 101 41520 01 433.03 MnGFOA-Staff 360 360 36D 380 380 101 4152D 01 433.04 GFOA-Finance Director&Asst. 340 340 340 350 350 101 41520 01 435.00 Books&Pamphlets 100 101 41520 1 435.01 Accounting Related Books 0 0 D 50 50 101 41520 01 435.02 Finance Related Books 0 0 0 50 5 101 41520 Q1 437.00 Conferences&Seminars 2,800 101 41520 01 437.02 MnGFOA Annual Conf(F/D} 571 573 596 700 700 101 41520 01 437.03 GFOA National Conf(F/D)432 543 0 1,500 1,500 101 41520 01 437.04 Staff Development 15 0 135 200 2D0 101 41520 01 437.05 Miscellaneous Seminars 360 387 373 400 400 Misc. Meetings, Lunches,etc. 101 41520 01 439.00 Other Miscellaneous Charges 284 85 46 200 200 Contingencies 101 41520 01 570.00 ffice Equipment&Furnishings 316 971 2,396 500 1,000 PAGE TOTALS 460,919 $469,640 $491,665 $528,100 610,800 DEPARTMENT T TALS 460,919 $469,640 $491,665 $528,100 61Q,8Q0 Page One 2018 BUDGET W RKSHEETS GENERAL GOVERNMENT July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 41810 01 202.00 Duplicating&Copying 13,000 101 4181 a D 1 202.02 Copying Costs 16,182 16,522 11,143 15,000 13,000 101 41810 01 203.00 Printed Forms&Paper 7,600 101 41810 01 203.01 Copy Paper 3,773 5,026 2,397 4,000 4,000 101 41810 01 203.02 General Receipt Books 0 776 0 800 800 101 41810 01 203.03 Purchase Orders 1,336 0 1,338 1,400 1,400 101 41810 01 203.04 Payroll&A/P Checks 324 435 541 4Q0 400 101 41810 01 203.06 Miscellaneous Forms 2,257 123 935 1,000 1,000 Business Cards,etc. 101 41810 01 204.00 Envelopes&Letterheads 1,800 101 41810 01 204.01 Letterhead 1,523 1,195 1,302 700 700 101 41810 01 204.02 Plain Envelopes 322 902 1,082 600 600 101 41810 01 204.03 A/P&Payroll Envelopes 946 0 946 500 500 101 41810 01 204.04 10 x 13 Envelopes b 0 698 0 0 101 4181Q 01 209.00 Other Office Supplies 14,456 14,386 15,198 14,500 14,500 General O ce Supplies 101 41810 01 221.00 Equipment Parts 0 0 0 0 0 City Hall Equipment Repairs 101 41810 01 242.OQ Minor Equipment 500 101 41810 01 242.02 Credit Card Equipment 0 748 0 500 500 500-$700 for One Terminal 101 41810 01 301.00 Auditing&Accounting Services 68,300 101 41810 01 301.01 Audit&General Consulting Fees 59,181 65,173 58,610 6D,OOD 6,00 101 41810 01 301.02 Dakota County Assessment Fees 6,344 6,482 5,597 6,500 6,SOd 101 41810 01 301.03 Dak Cty Truth In Taxation Costs 1,523 1,525 1,629 1,6 0 1,800 101 41810 01 303.00 Engineering Fees 0 0 0 0 0 101 41810 01 304.00 Legal Fees 63,485 87,108 72,206 66,000 70,000 General City Legal Fees 101 41810 01 319.00 Other Professional Services 24,50D 101 41810 01 319.01 City Code Update 160 2,974 234 2,700 2,000 101 41810 01 319.02 City Code Web Fees 500 500 500 500 500 101 41810 01 319.03 State Building Report(Springsteds) 4,548 4,310 4,550 5,000 5,000 Fees Paid to Springsted 101 41810 01 319.04 Continuing Disclosure Fees 2,4DD 2,600 3,200 3,000 3,OD Fees Paid to Springsted(Bonds) 101 41810 01 319.05 Annual User Fee Study Update 3,928 3,996 3,760 4,000 4,Od0 Fees Paid to Springsted 101 41810 01 319.06 Arbitrage/Rebate Calculations 0 5,850 13,900 10,000 10,000 Fees Paid to Springsted(Bonds} 101 41810 01 319.10 UMore Professional Services 20,020 2,603 363 0 0 In-House Engineer or Bill Out 101 41810 01 320.00 Credit Card Activity Fees 26,000 101 41810 01 320.01 Utilities'Fees 0 0 0 0 0 O/L Added-Moved to Utilities 101 41810 01 320.02 Parks&Recreation Fees 5,031 4,746 5,188 5,500 5,500 101 41810 01 320.03 Building Fees 11,492 19,326 18,715 15,000 19,000 101 41810 01 320.04 General Fees 819 1,372 2,108 1,500 1,500 101 41810 01 32D.05 Parks&Recreation On-Line Fees D 99 D 0 D 101 41810 01 321.OD Telephone Costs 42,100 101 41810 01 321.01 General Phone Costs(&Internet) 25,574 27,504 28,o23 28,000 30,0 0 Added Fiber to Buildings in 2013 101 41810 01 321.02 Domain Housing 60 60 270 100 100 101 41810 01 321.03 Software Maintenance Costs 7,970 7,970 9,050 9,000 10,000 Added Additional Licenses 101 41810 01 321.04 Phone System Hardware 533 289 28 2,000 2,000 Phone Upgrades,Headsets,etc. 101 41810 01 322.00 Postage Costs 15,601 13,340 15,505 15,000 15,000 101 41810 01 339.00 Other Transportation Expenses 906 166 908 1,OOD 1,000 Vehicle Licensing 101 41810 01 351.00 Legal Notices Publishing 4,000 101 41810 01 351.01 Costs for Public Notices 4,468 2,997 3,365 3,000 3,000 All Departments 101 41810 01 351.03 Budget&Audit Publications 452 996 906 500 1,D00 State Mandated Publications 101 41810 01 391.00 P.C.Maintenance 18,245 14,344 17,999 18,000 20,QOo Lase she Maintenance 101 41810 01 392.00 P.C.Software Purchases 12,669 1,593 7,000 7,000 7,000 Lase she Software 101 41810 01 393.00 P.C. Hardware Purchases 2,140 1,100 4,000 4,000 4,000 5canner Purchase 101 41810 01 433.00 Dues&Subscriptions 1,050 954 1,170 1,000 1,000 Newspapers 101 41810 01 439.D0 Other Misceliane us Charges 240 240 240 300 300 Direct Deposit Filing Fees/Flex 101 41810 01 450.00 Sales Tax on Purchases 0 0 0 0 0 Sales Tax Audit 101 41810 01 580.00 Other Equipment Purchases 32,209 30,930 19,645 14,000 14,000 O ce Machines-All Buildings PAGE TOTALS 342,664 $351,268 $334,248 $323,600 334,600 DEPARTMENT TOTALS 342,664 $351,268 $334,248 $323,600 334,600 Page One 2018 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 1D1 41910 101.00 Salaries&Benefits 870,717 $906,340 $926,643 $978,800 1,008,900 5alary,Taxes,PERA&Benefits 101 41910 101.00 Salaries&Benefits 0 0 0 0 42,900 Economic Development Coord. 101 4191Q 102.00 Full-Time vertime 20 1,044 2,906 1,000 1,000 ^"New Position Start 7/1/18^^ 1a1 41910 99 103.00 Part-Time Salaries&Benefits 2,072 2,035 15,659 27,500 27,500 101 41910 99 103.01 Planning Commission Members 4,500 101 41910 99 103.02 Part-Time Intern 6,000 101 41910 99 103.03 Part-Time Code Enforcement 17,000 101 41910 01 201.00 Office Accessories 0 0 0 0 0 Calendars,Planners,etc. 101 41910 01 202.00 Duplicating&Copying 2,071 3,615 4,004 14,00 10,000 Includes Comp Plan Printing 101 41910 01 203.00 Printed Forms&Paper 445 1,245 322 1,000 4,000 Forms,Stickers,Tags,etc. 101 41910 01 205.00 Drafting Supplies 0 0 0 0 0 101 41910 01 208.00 Miscellaneous Supplies 27 0 0 0 0 101 41910 01 209.00 Other Office Supplies 444 223 728 600 600 Dictation Devices&Tapes 101 41910 01 219.00 Other Operating Supplies 3,255 2,470 743 2,000 2,00 101 41910 01 241.00 Small Tools 190 207 238 200 300 Inspectors'Tools 101 41910 01 302.D0 Architects'Fees 0 0 0 0 0 101 41910 01 319.00 Other Professional Services 554 1,816 1,205 2,000 2,000 Consultant 101 41910 01 329.00 Other Communication Costs 2,149 2,760 2,484 2,800 2,800 Cell Phones&Pagers 101 41910 01 331.00 Travel Expense 552 947 380 700 700 101 41910 a1 391.00 P.C.Maintenance 2,990 2,990 5,360 4,200 4,200 Permitworks 5upport 101 41910 01 392.00 P.C.Accessories&Supplies 0 40 29 300 300 101 41910 01 393.00 P.C. Hardware Purchases 0 0 0 0 0 101 41910 o1 409.00 Other Contracted Repair&Maint. 3,014 1,955 1,580 2,0 2,000 Mow Weeds-From Street Maint. 101 41910 01 433.00 Dues&Subscriptions 3,400 101 41910 01 433.01 APA/AIGP 1,150 1,040 1,032 1,700 1,760 101 41910 01 433.02 ICC 125 290 215 300 300 101 41910 01 433.03 AMBO 475 200 280 500 500 101 41910 01 433.04 16,OOD Lakes 115 125 125 150 150 101 41910 01 433.06 Trade Magazines 0 0 0 0 0 101 41910 01 433.07 Planner's Journal 430 430 0 0 0 101 41910 01 433.08 Sensible Land Use Coalition 50 76 100 100 100 101 4191 D 01 433.09 AACE/MAHCO 55 55 D 100 100 101 41910 01 433.10 Other Dues&Subscriptions 187 213 115 550 550 101 41910 01 435.00 Books&Pamphlets 582 36 813 800 800 Manuals, References, IBC Books 101 41910 01 437.OQ Conferences&Seminars 8,100 101 41910 01 437.01 State Bldg Official School 557 606 0 500 500 101 41910 01 437.02 Spring&Fall Code Updates 220 440 480 400 500 1Q14191D01437.03 BuildinglnspectorTraining 962 1,038 654 1,000 1,000 101 41910 01 437.04 Computer Training 0 Q 135 200 200 101 41910 01 437.05 Clerical Seminars 180 149 180 300 300 101 41910 01 437.06 Planning Seminars 38 2,830 368 1,800 1,800 101 41910 01 437.07 ISTS Training 175 391 198 500 700 101 41910 01 437.08 State Planning Conference(2) 786 624 521 2,000 2,000 101 41910 01 437.09 Planning Commissioner Training 80 315 90 500 500 101 41910 01 437.10 Gen'I Seminars 304 292 27 30 300 101 41910 01 437.11 Code Enforcement Training 25 296 292 300 300 101 41910 01 439.00 Other Miscellaneous Charges D 630 44 400 400 Contingencies 101 41910 Q1 586.0 Computer Equipment Purchases 0 0 3,000 3,000 Tablets for Employees PAGE TOTALS 894,997 $937,761 $967,947 $1,052,500 1,124,900 DEPARTMENT TOTALS 894,997 $937,761 $967,947 $1,052,500 1,124,900 Page One 2078 BUdGET WORKSHEETS POLICE July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 42110 101.00 Salaries&Benefits 2,630,087 $2,840,182 $2,829,091 $3,071,200 3,212,100 Salary,Taxes,PERA&Benefits 101 4211 D 101.00 Salaries&Benefits 0 0 0 0 3,OQ0 Stipend for Additional Detective 101 42110 101.00 Salaries&Benefits 0 0 0 83,700 Additional Patrol Officer(Start 3/1118) 101 42110 102.0 Full-Time Overtime 89,832 94,032 122,600 93,500 93,500 _ 101 42110 102.01 Regular O ertime Hours 77,500 COLA&Explorer Post Time 101 42110 102.02 Contracted O/T 16,000 101 42110 103.00 Part-Time Salaries&Benefits 45,80D 101 42110 2 103.00 Part-Time Secretary 10,227 123 0 0 0 Position Eliminated in 2015 101 42110 9S 103.00 Part-Time CSO's 36,277 37,593 27,587 44,700 45,800 CS's-Up To 50 Hours/Wk 101 42110 01 202.00 Duplicating&Copying 0 0 0 0 0 101 42110 01 203.Q0 Printed Forms&Paper 1,784 1,693 1,714 1,700 1,700 101 42110 1 204.00 Envelopes&Letterheads 213 D 284 300 300 Business Cards 101 42110 01 207.40 Trai ing&Instructional Supplies 12,800 101 42110 01 207.41 Practice Ammunition 5,067 5,277 5,962 5,500 5,500 Increase Due to Increase in Costs 101 42110 01 207.02 Service Ammunition 1,014 1,ODD 1,308 1,300 1,300 Increase Due to Increase in Costs 101 42110 01 207.03 Other Supplies 25 134 279 300 500 101 42110 01 207.04 M.A.A.G.Ammunition 5,190 5,220 4,859 5,5D0 5,500 Increase Due to Increase in Costs 101 42110 1 208.00 Miscellaneous Supplies 0 Donated&Forfeited Funds 101 42110 01 208.01 DARE Donations 302 212 1,399 0 0 101 42110 41 208.02 Equipment DonationslForfeitures 3,837 2,901 9,595 0 0 101 42110 01 208.03 Other Grants Expenditures 0 2,807 847 D D 101 42110 01 209.OQ Other Office Supplies 1,080 908 1,030 1,100 1,100 Videos&CD's(Increase in Costs) 101 42110 01 211.00 Cleaning Supplies 1,400 101 42110 01 211.01 Blanket Cleaning 0 0 0 0 0 101 42110 01 211.02 Squad Cleaning 557 502 1,183 1,500 1,400 101 4211 D 01 217.00 Clothing Allowance 5,700 101 42110 01 217.01 CSO's 319 2,375 126 1,000 1,000 101 42110 01 217.02 Reserves 997 2,168 1,561 1,500 2,500 101 42110 01 217.03 Other Supplies 2,682 1,826 1,767 2,200 2,200 Increase to Cover Chief Uniforms 101 42110 01 219.00 Other operating Supplies 4,400 101 42110 01 219.o1 Evidence Bags,Drug Kits,Misc. 1,635 2,033 1,166 2,040 2,000 101 42110 01 219.02 Accurint Database Services 717 713 1,963 2,2d0 2,400 Free Service no Longer Available 101 42110 01 221.00 Equipment Parts 2,598 2,841 4,214 4,000 4,500 Squad Emerg Equip(Medic Bags) 101 42110 D1 241.0 Small Tools 4,200 Crime Scene Kit Supplies 101 42110 01 241.01 Evidence Processing Equipment 213 765 676 800 800 101 421'10 01 241.02 Camera and Video Supplies 1,644 1,850 0 2,000 2,000 Squad Camera Maintenance 1o1 42110 01 241.03 Digital Recorder Warranty 1,198 1,285 1,260 1,300 1,400 3%Cost Increase Estimate 101 42110 01 242.00 Minor Equipment 5,100 101 42110 01 242.01 Less Lethal Tactical Equipment 966 1,615 1,905 1,200 1,500 Training Supplies,Taser Batteries 101 42110 01 242.02 MAAG Equipment 3fi2 413 493 1,000 1,000 101 42110 01 242.03 Drug Task Force Equipment 0 0 D 0 3,600 101 4211 D 01 304.00 Legal Fees 59,532 68,420 63,270 67,000 69,000 Prosecution-2.5°/o Increase 101 42110 01 305.Q0 Medical&Dental Fees 2,300 101 42110 01 305.01 Physicals 667 1,418 1,473 1,200 1,5 0 101 42110 01 305.D2 Seized Narcotic Testing 170 794 170 8D0 800 Blood Draws 101 42114 01 306.40 Personnel Testing&Recruitment 795 4,319 2,523 1,500 1,500 Psychological 101 42110 01 313.00 Temporary Service Fees 7Q 626 109 800 800 Interpreter Services 101 4211Q 01 315.00 Special Programs 0 0 0 0 0 101 42110 01 316.b0 Animal Care Services 1,200 101 42110 01 316.01 Impound&Care Fees 1,60Q 1,252 189 1,700 1,200 101 42110 01 316.02 "Future Use" d 0 0 0 0 101 42110 01 319.OQ Other Professional Services 460,500 101 42110 01 319.01 Dispatch Services-Operations 354,649 368,448 388,152 417,900 440,500 1Q1 42110 01 319.02 Policy Development&Training 999 842 1,328 800 1,000 101 42110 01 319.03 Mediation Services 792 219 0 1,000 1,000 101 42110 01 319.04 Electronic Crimes Unit Fees 0 15,DD0 15,000 15,000 18,000 Coordinated by Dakota County 101 42110 01 319.5 Emergency Mgmt Plan Update 5,148 0 0 0 0 101 4211 D 01 321.D0 Telephone Costs 14,000 101 42110 01 321.01 Cell Phones 3,696 4,599 12,448 14,000 14,000 Switching to Smart Phones 101 42110 01 323.00 Radio Units 14,500 101 42110 01 323.01 Radios 10,638 9,052 10,009 11,500 12,000 800 MHz Subscriber Fees 101 42110 01 323.02 Radars 767 37 282 500 5Q0 Radar&LIDAR Repairs 101 42110 01 323.03 Radio Warranty 1,703 1,703 1,749 2,000 2,000 101 42110 01 331.OD Travel Expense 6,30 101 42110 01 331.01 MN Chiefs Spring Conference 435 0 0 500 500 101 42110 01 331.02 IACP or FBINAA Conference 1,813 1,956 1,964 2,200 2,200 101 42110 01 331.03 Outstate Investigations&Conf. 552 1,032 828 750 800 101 4211D 01 331.04 MAAG Conference 623 619 450 850 900 Increase in Conference Costs 101 42110 01 331.05 CAN-AM Narcotic Conference 420 261 412 500 500 1Q1 42110 01 331.06 Juvenile Officers Conference 513 521 0 600 600 Increase in Conference Costs 1a1 42110 01 331.07 Meeting Reimbursements 1 1 139 498 600 800 PAGE TOTALS 3,244,506 3,492,057 3,523,721 3,787,500 4,049,400 Page Two 2018 BUDGET WORKSHEETS POLICE July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 42110 01 333.40 Freight&Express Expenses 97 9 56 200 200 Repairs 101 42110 01 394.00 P.C.Software Purchases 81,6 0 101 42110 01 394.01 Automated Pawn System 204 204 204 300 300 101 42110 01 394.02 Pictometry 0 0 0 D D In Public Works Budget 101 42110 01 394.03 CJN/EFORMS 36,120 41,759 30,932 0 6,500 CJN/Eforms 101 42110 01 394.04 LOGIS TriTech RMS 0 0 30,264 60,200 74,800 TriTech RMS and Report Writing 101 42110 01 396.00 Computer Maintenance 38,800 101 42110 01 396.01 LOGIS Apps Support 2,952 3,060 0 D 0 LOGIS AP5-Moved to LOGIS RMS 101 42110 01 396.02 CJDN Connection Charges 3,724 4,365 2,981 2,800 2,900 State of MN CJDN Connection 101 42110 01 396.03 MCD Connection Charges 630 236 1,384 2,10D 2,10D LOGIS MDC Connection Charges 1D1 42110 01 396.04 MCD Maintenance&Cellular 21,523 24,058 26,476 28,000 29,000 Increase Due to CAD Change 101 42110 01 396.05 LOGIS Fees/Development 3,302 1,985 1,658 1,600 3,500 De elopment Fund 101 42110 01 396.06 Evidence.com Data Storage 0 0 0 600 654 Squad Video 101 42110 01 396.07 Schedule Anywhere 0 0 0 6 Q 65Q Scheduling Software 101 42110 01 433.00 Dues&Subscriptions 12,300 101 42110 01 433.01 Multi-Agency Assistance Group-MAAG 8,300 8,300 8,30 8,300 8,300 MAAG Equipment CIP Increase 1Q1 42110 01 433.02 IACP Chiefs 120 150 150 185 185 101 42110 01 433.03 MN Chiefs of Police 290 290 290 300 300 101 42110 01 433.04 Dakota Cty Chiefs of Police 330 4 0 400 40o 400 Chief and a Sergeant 101 42110 01 433.05 Wakota CAER 0 0 0 0 0 101 42910 01 433.06 Metro Emergency Managers 0 0 0 0 0 101 42110 01 433.7 MN Sex Crimes Investigators 0 0 0 20 20 101 42110 01 433.08 Tri-County Investigators 75 75 75 50 75 101 42110 01 433.09 MN Crime Prevention Association 45 45 60 65 65 101 42110 01 433.10 P.O.S.T.Licenses 42D 1,260 630 540 1,440 101 42110 01 433.11 FBI NaYI Academy Association 85 0 0 0 0 Chiefs Membership Cancelled 101 4211 d 01 433.12 Miscellaneous 13 350 50 390 365 101 4211Q 01 433.13 ATOM 0 0 250 250 250 Ass'n Training Officers of MN 101 42110 01 433.14 Rotary Membership 0 0 0 0 900 101 42110 01 435.00 Books&Pamphlets 1,123 1,058 1,460 2,500 2,500 Crime Pre ention Materials 101 42110 01 436.00 Towing Charges 158 255 47 200 200 Disabled Squads 101 42110 01 437.00 Conferences&Seminars 28,700 101 42110 01 437.01 Firearms-Range 2,130 4,325 3,705 4,500 4,500 Range Rentai 101 42110 01437.02 Chiefs Spring Conference 523 0 4 0 750 750 Conference Cost Increases 101 42110 01 437.03 Investigations 1,064 1,175 1,518 2,000 2,000 101 42110 01 437.04 IACP Conference 210 295 350 400 400 101 42110 01437.05 Supervision 1,362 1,883 5,696 6,500 fi,500 Personnei Developmnt Northwestern 101 42110 01 437.06 Use of Force 275 750 2,033 2,OOD 2,000 Increase due to Instructor Retiring 101 42110 01 437.07 Emergency Driving 1,575 2,625 2,405 3,000 3,004 Driving School Cost Increase 101 42110 01 437.08 First Aid 0 640 578 700 700 Cost Increase due to 5tate Reg.Inc. 101 42110 01 437.09 Narcotic Enforcement 12 197 121 20o 200 101 42110 01 437.10 Tactical 819 1,269 945 1,000 1,000 101 42110 01 437.11 Support Services 190 306 669 500 754 101 42110 01 437.12 Patrol Operations 1,413 1,480 3,611 4,500 4,500 Increase due to C.I.T.for Patrol 101 42110 01 437.13 Emergency Management 32 0 0 0 0 101 42110 01 437.14 SRO/CRO 0 0 398 1,30Q 1,30Q Added for Specialized Training 101 42110 01 437.15 Explorer Conference 0 0 288 750 750 Two Advisors to State Conference 101 42110 01 437.16 360 Communities Annual Banquet 0 0 298 300 350 101 42110 01 439.00 Other Miscellaneous Charges 94 783 452 800 800 Refreshments for Meetings& Compiiance Checks 101 42110 01 58D.Oo Other Equipment Purchases 1,730 1,864 28,006 2,000 2,000 ___ 1d1 42110 01 599.00 Employee Recognition Costs 0 0 0 2,000 2,000 Recognition BanqueUPlaques/Awards PAGE TOTALS 90,940 $105,450 $157,140 $142,800 169,1aD DEPARTMENT TOTALS 3,335,445 $3,597,506 $3,680,861 $3,930,300 4,218,500 Page ne 2018 BUDGET WORKSHEETS FIRE July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All 5alary Costs Inclusive of 101 42210 103.00 Salaries&Benefits 163,743 $203,534 $218,973 $218,000 263,60d Salary,Taxes, PERA&Benefits 101 42210 103.01 Salaries 44,000 Increases for Chief&Assistant 101 42210 103.02 Training Pay 51,000 101 42210 103.d3 Call Pay/Stipends 168,600 From$101hr to$12/hr 101 42210 1 D3.04 Class Pay/Stipends 0 101 42210 01 202.00 Duplicating&Copying 200 101 42210 01 202.01 Copy Toner 0 97 0 100 100 101 42210 01 202.02 Computer Printers 14 0 0 100 100 101 42210 01 204.00 Envelopes&Letterhead 500 101 42210 01 204.01 Envelopes 0 0 0 200 200 101 42210 01 204.02 Letterhead 0 0 0 20D 20Q 101 42210 01 204.03 Forms 10 0 0 100 100 101 42210 01 211.00 Cleaning Supplies 800 101 42210 01 211.01 Soaps 47 278 18 550 550 101 42210 01 211.02 Chamois,Towels,etc. 0 0 0 50 50 101 42210 01 211.03 Sponges,etc. 0 0 0 50 50 101 42210 01 211.Q4 SCBA Cleaner 91 100 100 150 150 101 42210 01 218.00 Fire Department Clothing 5,000 101 42210 01 218.01 Uniforms 1,268 319 3,097 1,700 1,700 Uniforms for New Hires 101 42210 01 218.02 Station Wear(2 15) 179 572 2,473 3,300 3,300 Yearly Allowance for Fire Fighters 101 42210 01 219.00 Other Operating Supplies 9,400 Medical Supplies 101 42210 01 219.01 Gloves 510 2,638 0 2,500 2,500 101 42210 01 219.02 Bandages 0 0 0 100 100 1 D 1 42210 01 219.03 Equipment 380 4,766 2,465 1,500 1,500 101 42210 01 219.04 Tyvek Suits 0 0 0 100 100 101 42210 01 219.05 Consummable Medical 2,406 2,566 4,409 3,000 4,000 Increase in Medical Calls 101 42210 01 219.06 Oxygen 917 (467) (32) 1,200 1,200 Added 02 Cascade @ FS#2 101 42210 01 229.Oa Other Maintenance Supplies 6,900 1 Q1 42210 01 229.01 Vehicle Repairs 0 58 15 400 400 101 42210 01 229.02 Pickup Trucks 0 0 0 0 101 42210 01 229.03 Rescue&Ofher 0 0 0 0 0 101 42210 01 229.04 Vehicle Modifications 1,147 55 0 6,50a 6,500 Replace Aging Light Bars 101 42210 01 230.00 Equipment Repair Materials 1,500 101 42210 01 230.01 Light Bars D 0 0 100 100 101 42210 01 230.02 Smoke Machines 0 0 0 300 300 101 42210 01 230.03 Lanterns&Miscellaneous 0 64 0 300 300 101 42210 01 230.4 Small Tool Repairs 181 640 562 60D 600 101 42210 01 230.05 Opticom 0 0 0 100 100 101 42210 01 230.06 Station 10 101 60 1 DD 100 101 42210 01 241.00 Small Tools 900 101 4221Q 01 241.01 Axes,Bars&ther 42 1,413 0 150 150 101 42210 01 241.02 Grass Fire 0 d 0 250 250 101 42210 01 241.03 Hand Tools(2014-Donation) 5,994 461 471 500 500 Replace Aging Tools 101 42210 01 305.00 Medical&Dental Fees 3,039 2,560 2,700 4,500 6,500 Switching Testing Company-2017 1D1 42210 01 306.00 Personnel Testing&Recruitment 5,300 101 42210 01 306.01 New Physicals(4) 1,823 2,448 3,962 4,000 4,000 New Hires 101 42210 01 306.02 Hepatitis 5hots(4) 0 220 110 5D0 500 101 42210 01 306.03 Background Checks(4}438 403 172 600 600 101 42210 01 306.04 Drug Testing(4) 0 0 a 200 200 101 42210 01 308.b0 Instructors'Fees 13,800 101 42210 01 3D8.01 Fire Fighter 1 (4) 1,951 60a 2,255 1,600 1,600 101 4221Q 01 308.D2 Fire Fighter 1 Certificates(4) 0 6 0 300 300 101 42210 01 308.03 Fire Fighter Re-Certificates(14) 280 200 325 400 40Q 101 42210 01 308.04 First Responder(4) 495 0 0 1,000 1,000 101 42210 01 3D8.05 First Responder Refresher(1/2} 1,447 1,200 1,200 1,400 1,400 101 42210 01 308.06 Outside Schools 17,035 2,335 5,680 3,300 8,000 Adding Leadership Traning 101 42210 1 308.07 Haz-Mat Training(4) D 0 0 1,000 1,000 For Officers^^^ 101 42210 01 308.08 ther Re-Certificates(2)55 0 0 100 1 DO PAGE TOTALS 203,503 227,160 249,014 261,100 314,400 Page Two 2018 BUDGET WORKSHEETS FIRE July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 42210 01 310.00 Testing Services 6,100 101 42210 01 310.01 Aerial 750 2,373 775 2,500 2,500 101 42210 01 310.02 Ladders 564 434 525 800 800 Increase in Fees 101 42210 01 310.03 Pumpers(3)(Next 2014} 2,344 829 2,370 2,500 2,800 Added New Engine to Fleet 101 42210 01 310.04 SCBA Hydro Testing(Next 2016) 0 0 0 0 0 101 42210 01 313.00 Temporary Service Fees 15,300 101 42210 01 313.01 SCBA Maintenance 1,988 1,800 6,499 4,500 4,500 Added SCBA Compressor-FS#2 101 42210 01 313.02 SCBA Flow Test 783 500 2,132 2,500 2,500 Added SCBA Compressor-FS#2 101 42210 01 313.04 Security Contract 656 656 656 800 800 101 42210 01 313.05 SOT Joint Powers 6,867 6,867 6,867 7,500 7,500 Increase in Fees 101 42210 1 314.00 Annual Fire Relief Contribution 171,000 109,100 30,00a 30,000 3D,000 101 42210 01 319.00 Other Professional Services 2,200 Fire Prevention Education 101 42210 01 319.01 School Literature 0 0 0 400 400 101 42210 01 319.02 Door Prizes 0 114 0 200 200 101 42210 01 319.03 Fire Pre ention Week Promos 307 694 870 700 700 101 42210 01 319.04 Food at Open House 283 223 178 300 300 101 42210 01 319.05 Summer Park Education 0 0 0 0 0 101 42210 01 319.06 National Night Out 762 0 0 600 600 101 42210 01 321.00 Telephone Costs 5,000 101 42210 01 321.01 Cell Phones 1,818 3,002 2,899 3,200 3,200 Active 911 Subscriptions 101 42210 01 321.02 Computer Cards 0 0 0 1,800 1,800 101 42210 01 321.04 Numeric Pagers 0 0 0 0 0 101 42210 01 322.00 Postage Costs 18 0 2 100 100 UPS Costs 101 42210 01 329.00 Other Communication Costs 22,400 101 42210 01 329.01 Base Repairs 0 0 0 300 300 101 42210 01 329.02 Pager Repairs 235 1,356 1,120 1,OOQ 1,000 101 42210 01 329.03 Hand Held Repairs 0 1,884 0 2,500 2,500 Warranty Plan to be Added 101 42210 01 329.04 Mobile Repairs 930 D 42 2,000 2,000 Aging Equipment 101 42210 01 329.05 800 MHZ User Fee 11,758 10,079 12,711 14,000 14,000 101 42210 01 329.06 Mobile Computers 1,320 1,416 1,908 1,500 2,600 Monthly Air Time Fees(1 Add'n} 101 42210 01 331.OQ Travel Expense 8,600 101 42210 01 331.01 Minnesota Chiefs Conference 0 6 1,371 2,000 2,OOD 101 42210 01 331.02 FireDepartmentAssociation 0 0 0 1,600 1,600 101 42210 01 331.03 Outside Schools 0 0 1,394 S,dOQ 5,000 FDYC Training Added 101 42210 01 333.00 Freight&Express Expense 0 0 0 0 0 101 42210 01 433.00 Dues&Subscriptions 2,000 1 Q1 42210 D1 433.01 Capital City 0 0 0 50 50 101 42210 61 433.02 VFBA Insurance 307 672 404 775 775 161 42210 01 433.03 State Fire 385 763 763 800 800 1d1 42210 01 433.04 State Chiefs 345 0 0 250 250 101 42210 01 433.05 DCFC 15 75 75 75 75 101 42210 01 433.06 WAKOTA Mutual Aid 50 50 50 50 50 101 42210 01 433.07 Purchasing Consortium 0 0 0 0 0 101 42210 01 433.08 NFPA 0 0 0 0 0 101 42210 01 433.09 "Future Use" 0 0 0 0 0 101 42210 01 437.00 Conferences&Seminars 1,900 101 42210 01 437.01 State Fire Conference 367 323 0 400 400 101 42210 01 437.02 State Chiefs Conference 1,148 1,718 600 1,500 1,500 Sending Additional Personnel 101 42210 01 439.00 Other Miscellaneous Charges 3,100 101 42210 01 439.01 Food&Coffee 546 818 501 700 700 101 42210 01 439.D2 Extinguisher 0 505 69 60d 600 101 42210 01 439.03 Plaques 91 139 250 200 20d 101 42210 01 439.04 Paint 0 0 0 100 10o 101 42210 01 439.05 Station Needs 987 1,617 16,043 1,500 1,500 101 42210 01 580.00 Other Equipment Purchases 1,926 27,600 101 42210 01 580.01 Bunker Gear(8} 20,744 33,626 39,861 18,600 18,60 101 42210 01 580.02 Pagers 385 2,245 2,975 5,000 5,OD0 Replacements(5 Per Year) 101 42210 01 580.03 Hose&Fittings 1,349 407 6,478 2,000 2,000 Aging Equipment 1D1 42210 01 580.04 Replace Damaged Items 1,001 6,917 0 2,000 2,000 101 42210 01 581.00 Other Equipment Purchases 0 0 0 0 0 101 42210 D1 586.00 ther Equipment Purchase 0 0 0 D 0 Donation ItemS PAGE TOTALS 230,239 $191,199 $142,313 $122,90D 124,300 DEPARTMENT TOTALS 433,742 $418,359 $391,327 $384,000 438,700 Page One 2018 BUDGET WORKSHEETS GDVERNMENT BUILDINGS July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41940 101.00 Salaries&Benefits 117,200 5alary,Taxes, PERA&Benefits 101 41940 77 101.01 Administrative 0 3,353 3,678 8,D00 8,200 P.W.Director/City Engineer 101 41940 79 101.01 Maintenance 67,802 68,709 73,008 106,100 109,000 101 41940 102.00 Full-Time Overtime 1,047 563 1,837 0 0 101 41940 01 208.00 Miscellaneous Supplies 16,604 15,995 16,384 18,000 18,000 Cleaning,Paper Prod.,Coffee 101 41940 01 219.00 Other Operating Supplies 2,012 2,580 2,081 2,800 2,800 Flags 101 41940 01 223.00 Building Repair Supplies 10,602 8,760 8,339 10,500 10,500 Light Bulbs,Locks,etc. 101 41940 01 225.00 Landscaping Materials 1,367 442 631 1,500 1,500 Trees&Shrubs 101 41940 01 241.00 Small Tools 187 422 333 600 600 Garpentry,Bits,Blades,etc. 101 41940 01 242.00 Minor Equipment 1,384 995 987 1,000 1,000 Equipment Replacement 101 41940 01 302.0 Architects'Fees 0 0 0 0 0 Estimates 1Q1 41940 01 318.00 Contract Engineer 3,000 1,562 4,044 0 0 101 41940 01 319.00 Other Professional Services 100,400 101 41940 01 319.01 Elevator Maintenance 2,388 1,887 1,938 2,5 0 2,500 101 41940 01 319.02 Heating/Cooling Maint Contract 6,457 7,322 9,156 9,000 10,Od0 Includes all City Facilities 101 41940 01 319.03 Annual Boiler Inspections/Maint. 75 50 70 500 500 101 41940 01 319.04 Pest Control 2,972 3,144 3,395 4,500 4,500 Price Incr.,Boxelder Treatment 1D1 41940 01 319.05 Fire Extinguishers 1,255 810 1,172 1,800 1,800 101 41940 01 319.06 Fire Suppression System Check 2,505 2,569 3,854 3,500 4,000 101 41940 01 319.07 Janitorial Service-Fire Stations 9,762 9,837 9,994 10,200 11,000 101 41940 01 319.08 Janitorial Service-P.W.Building 10,620 10,774 10,946 11,000 12,000 101 41940 01 319.09 Janitorial 5ervice-City Hall 26,035 26,232 26,652 26,700 28,000 101 41940 01 319.10 Floor Mats-Monthly Charges 4,125 4,491 4,772 5,000 5,00 101 41940 Q1 319.11 Other Janitorial Services 9,779 9,635 11,270 10,500 20,000 Clean/Grout Tile CH,PD,F2('18} 101 41940 01 319.12 Bronze Monument Maintenance 1,025 1,075 1,075 1,100 1,100 101 41940 01 321.00 Telephone Costs 735 726 700 80Q 800 Air Gard for iPad-Monthly Chgs 101 41940 01 381.00 Electric Utilities 69,202 63,971 74,433 70,000 65,000 101 41940 01 383.00 Gas Utilities 73,444 49,446 43,596 65,000 60,000 101 41940 01 384.00 Refuse Disposal 41,500 101 41940 01 384.01 General Buildings&Parks 19,289 19,936 20,032 22,000 22,500 Add a Park in 2018 101 41940 01 384.02 Recycling/Cleanup 15,161 13,373 20,557 17,000 19,D00 101 41940 01 389.00 Other Utility 5ervices 0 0 0 0 5,000 5olar Subscription Fees 141 41940 01 393.00 P.C.Hardware Purchases 0 0 0 0 0 101 41940 01 394.00 P.C.Software Purchases 0 0 0 0 8,400 Cartegraph, ESRI 101 41940 01 401.00 Contracted Building Repairs 6Q,DOD 101 41940 01 401.01 Electrical Repairs 12,970 2,973 5,181 8,000 8,000 101 41940 01 401.02 Siren Operations&Maintenance 4,748 6,648 1,537 7,000 7,000 101 41940 01 401.03 Miscellaneous Repairs 51,040 49,062 23,553 25,000 25,000 101 41940 01 401.04 HVAC Repairs 0 0 17,049 20,000 20,000 1Q1 41940 01 402.00 Security Card System Maintenance 0 0 2,865 5,000 5,000 Updates,Prev. Maint.,Tech Supt. 101 41940 01 416.00 Machinery Rental 0 0 0 1,500 1,500 Lift Rental 101 41940 01 437.0 Conferences&Seminars 0 0 61 200 200 101 41940 01 439.00 Other Miscellaneous Charges 0 5,573 5,D00 6,000 6,OD0 Energy Efficiency Improvements 101 41940 01 530.Q Improvements Other Than Buildings 85,000 87,833 92,230 92,000 110,000 From Long-Term Plan PAGE TOTALS 512,590 $480,747 $502,410 $574,300 615,400 DEPARTMENT TOTALS 512,590 $480,747 $502,41 d $574,300 615,400 Page One 2018 BUDGET WORKSHEETS FLEET MAINTENANCE July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All 5alary Costs Inclusive of 101 43100 101.00 Salaries&Benefits 237,900 Salary,Taxes, PERA&Benefits 101 43100 77 101.00 Administrative 10,933 17,871 18,921 27,800 28,600 101 43100 78 101.00 Technical/Clerical 9,972 10,144 10,743 11,100 11,400 101 43100 79 1 1.OQ Maintenance 163,952 177,494 179,979 181,500 197,900 101 43100 102.00 Full-Time vertime 304 1,183 1,601 3,OOD 3,000 101 43100 01 211.00 Cleaning Supplies 2,685 2,609 3,612 4,000 4,DOD Shop&Vehicles 101 4310D 01 212.DD Motor Fuels 188,784 162,298 126,143 158,000 154,000 9.5%of Fuel Covered by Utilities 101 43100 01 213.00 Lubricants&Additives 10,020 9,811 16,105 15,000 15,000 101 43100 01 215.00 Shop Materials 15,279 13,479 14,606 20,000 20,000 101 43100 01 221.00 Equipment Parts 99,142 103,841 100,573 120,000 120,000 101 43100 01 222.00 Tires 38,757 15,783 23,278 30,DOD 30,000 101 43100 01 241.00 Small Tools 2,919 4,125 7,739 5,000 6,000 Replace Old Tools 101 43100 01 242.00 Minor Equipment 1,902 5,715 3,590 4,000 10,000 Replace Old Welders in 2018 101 43100 01 318.00 Contract Engineer 6,000 3,125 8,087 0 0 101 43100 61 321.00 Telephone Costs 0 0 12 0 D 101 43100 01 323.00 Radio Units(Warranty&Batteries)905 905 911 1,000 1,000 101 43100 01 384.00 Refuse Disposal 0 0 0 300 300 Shop Hazardous Waste 101 431 0 01 394.00 P.C.5oftware Purchases 8,700 101 431d0 01 394.01 Licensing&Maintenance 1,668 1,735 1,823 2,000 4,200 CarteGraph OMS 101 43100 01 394.02 Online Subscriptions 1,500 2,188 2,695 3,000 3,000 ALLDATA/Cummings/CAT/Qetroit 101 43100 01 394.03 New Software Purchases 0 1,200 2,705 1,500 1,500 101 43100 01 404.00 Contracted Mach&Equip Services 65,060 101 43100 01 404.01 Contracted Services 60,912 37,772 14,689 55,000 55,000 Aging Equipment,FD Units,Towing 101 43100 01 404.02 Contracted Preventative Maint.9,626 11,836 10,000 10,000 10,000 Power Wash All,Paint One Unit 101 43100 01 416.00 Machinery Rental 0 0 0 500 500 101 43100 01 433.00 Dues/Subscriptions/Certifications 0 0 180 300 200 DOT Cert.ASE Cert., EVT Cert. 101 43100 01 435.00 Books&Pamphlets 48 60 55 200 100 DOT Decals and Inspection Pads 101 4310D 01 437.00 Conferences&Seminars 90 157 0 300 800 Cartegraph in 2018 PAGE T TALS 625,398 $583,331 $548,044 $653,500 676,500 DEPARTMENT TOTALS 625,398 $583,331 $548,044 $653,500 676,500 Page One 2018 BUDGET WORKSHEETS STREET MAINTENANCE July 10,2017 2018 2017 bject 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 43121 101.00 Salaries&Benefits 610,200 Salary,Taxes,PERA&Benefits 101 43121 77 101.00 Administrative 21,866 35,742 38,309 91,400 94,500 101 43121 7E 101.00 Technical/Clerical 55,442 53,541 58,747 54,700 56,900 101 43121 7 101.00 Maintenance 416,767 429,553 439,779 448,300 458,80 101 43121 102.00 Full-Time Overtime 14,733 9,409 14,762 14,000 14,Q00 Maintenance 1 1 43121 95 103.00 Part-Time Salaries&Benefits 15,293 18,916 17,575 21,Q00 21,000 Includes Funds for PIT Horticulturist 101 43121 01 201.00 OfFice Accessories 0 0 100 10 101 43121 01 203.00 Printed Forms&Paper 0 101 43121 01 203.01 R/W Permit&Inspection Forms 0 0 0 D 0 101 43121 01 243.03 City Specification Books 0 804 0 0 0 101 43121 01 205.00 Drafting Supplies 400 101 43121 1 205.01 Plotter Ink and Paper 1,001 374 774 500 400 101 43121 01 205.02 Off-Site Reproductions D 0 0 200 0 101 43121 01 249.00 Other Office Supplies 720 73 111 700 700 101 43121 41 216.00 Chemical&Chemical Products 84,057 65,574 60,745 103,000 90,000 101 43121 Q1 224.00 Street Maintenance Materials 14,300 ______ 101 43121 01 224.01 Paint 314 441 763 500 500 101 43121 61 224.02 Mail Boxes 1,357 1,428 1,178 1,500 1,500 101 43121 01 224.03 Light BuIbs/Lenses 315 68 89 800 800 Replace with LED Bulbs 101 43121 01 224.04 Holiday Decorations 3,952 7,951 5,776 9,000 9,000 Contracted Tree Lighting 101 43121 01 224.05 Miscellaneous 0 0 0 2,500 2,500 Fencing,Miscellaneous Supplies 101 43121 01 225.OQ Landscaping Materials 19,000 101 43121 01 225.01 Turf Restoration Material 2,731 162 4,340 2,000 3,000 101 43121 01 225.02 Seed 0 148 0 0 0 101 43121 01 225.03 Black Dirt 0 0 0 0 0 101 43121 01 225.04 Trees 159 272 0 50b 500 101 43121 01 225.05 Hanging Baskets 3,150 3,033 5,306 3,500 3,500 101 43121 01 225.06 Entrance Monuments 1,182 1,665 799 1,000 1,000 101 43121 01 225.07 Downtown Planters 1,275 2,034 785 2,500 2,500 101 43121 01 225.08 Park Signs,Central Park 2,508 3,464 4,125 3,000 4,000 Includes Business Park,Greystone 101 43121 01 225.09 City Facilities 118 1,117 743 3,000 4,000 CH,RCC,FS1,FS2,LIB,STP,ACT 101 43121 01 225.10 Banners/Flag Components 180 0 36 500 5D0 101 43121 01 226.00 Sign Repair Materials 10,827 7,950 1,888 7,500 101 43121 01 226.01 Signs and Posts 3,579 5,500 7,040 Replace More Faded/Aging Signs 101 43121 01 226.02 Solar Batteries 0 500 50 101 43121 01 231.D0 Bituminous Patching Materials 27,083 29,722 32,232 37,500 35,000 101 43121 01 232.00 Crushed Rock 30,331 35,628 21,051 30,OD0 27,000 101 43121 01 233.00 Dust Control Materials 24,550 31,529 26,728 32,000 34,000 101 43121 1 234.00 De-Icing Sand/Rock 4,235 1,161 2,105 4,500 4,500 Gravel Road Ice Control 101 43121 01 235.00 Shouldering Gravel 0 0 0 0 0 101 43121 01 241.Od Small Tools 680 1,357 755 1,000 1,000 Shovels,Brooms,etc. 1 1 43121 01 242.00 Minor Equipment 3,366 2,536 2,425 3,000 8,000 Traffic Counters in 2018($5,000j 101 43121 01 303.00 Engineering Fees 64,776 50,851 48,244 20,000 1o1 43121 01 303.01 General Non-Project Related 15,000 15,000 101 43121 01 303.02 Pavement Management 5,000 5,000 101 43121 01 304.00 Legal Fees 0 0 0 0 0 101 43121 01 310.00 Testing Services 1,125 0 0 0 0 101 43121 01 318.00 Contract Engineer 12,000 6,250 16,174 0 0 101 43121 01 319.00 Other Professional Services 0 0 0 2,000 101 43121 01 319.01 "Future Use" 0 Q 0 0 0 101 43121 01 319.02 GIS Consulting Services 3,071 2,276 1,280 2,000 2,OD0 101 43121 01 321.00 Telephone Costs 2,629 3,113 3,789 3,700 4,000 Includes Wireless Technology 101 43121 01 323.00 Radio Units 1,367 1,120 1,390 5,100 5,100 (24x$300)(12x$1500){Split 5 Ways) 101 43121 01 331.00 Travel Expense 6 242 207 200 200 101 43121 D1 381.D0 Electric Utilities 177,100 101 43121 01 381.01 Street Lights 164,890 163,598 172,217 172,D00 174,OD0 101 43121 01 381.02 Signal Lights&Sirens 2,943 2,592 2,504 3,100 3,100 101 43121 01 384.00 Refuse Disposal 1,400 101 43121 01 384.01 Hazardous Waste Disposal 1,508 0 0 500 500 101 43121 01 384.02 Roadside Garbage 160 407 1,433 900 900 101 43121 01 391.Q0 P.C.Maintenance 800 101 43121 01 391.03 Pavement Management Syst Sup 17,550 15,824 5,445 0 0 Moved to 1 01-431 21-D1-303.02 101 43121 01 391.04 R-O-W Permit n-Line Service 585 643 641 800 800 101 43121 01 392.00 P.C.Accessories&Supplies D 0 0 0 0 101 43121 01 393.0 P.C.Hardware Purchases 1,600 0 200 1,500 1,500 1 1 43121 01 394.00 P.C.Software Purchases 8,900 101 43121 01 394.01 Licensing&Maintenance 4,371 4,591 4,629 6,200 8,400 CarteGraph,ESRI 101 43121 01 394.02 Online Subscriptions 379 379 0 800 300 Pictometry 101 43121 01 394.03 New Software Purchases 0 0 0 200 206 PAGE TOTALS 1,007,149 997,497 1,003,658 1,095,200 1,103,700 Page Two 2018 BUDGET WORKSHEETS STREET MAINTENANCE July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 43121 01 402.00 Parking Lot Maintenance 65,000 55,000 60,237 70,000 90,400 From Long-Term Plan 101 43121 01 403.00 Contracted Repair&Maintenance 21,500 101 43121 01 403.01 Street Lights 786 2,384 0 5,000 5,000 Street LighUPole Repair/Replace 101 43121 01 403.02 Signal Lights 463 488 0 1,500 1,540 101 43121 01 403.43 Light Replacements 18,250 0 0 15,600 10,Od0 Conversion to LED 101 43121 01 403.04 Miscellaneous Repairs 0 0 0 0 5,000 Curb Painting,etc. 101 43121 01 404.Q0 Railroad Administration/Mgmt. 9,574 0 0 15,000 5,OD0 QZ Update Due Jan'17,Misc Issues 101 43121 01 4D5.00 Street Striping 50,688 10,798 3,482 45,000 40,040 101 43121 01 408.00 Crackseal,Sealcoat,Spray Patch 53,349 38,776 24,755 60,OD0 150,040 Mo e from CIP,More Curb Seal 101 43121 014Q9.00 Tree Trimming 8,375 9,071 8,250 10,OQ0 12,040 More Needed if No SKB Money 101 43121 01410.00 Concrete Sidewalk/Curb Repairs 20,000 _ 101 43121 01 410.01 General Repairs 14,422 23,493 8,549 20,000 20,000 101 43121 01 410.02 Pedestrian Improvements 0 146,924 591,931 0 D Moved$125,000 to Street CIP 101 43121 01411.00 Contracted Snow Removal 58,000 101 43121 01411.01 Community Center 19,710 8,961 12,985 23,OOQ 23,000 101 43121 01411.02 Steeple Center 13,712 3,999 7,431 15,000 15,D00 101 43121 01 411.04 Dakota County Library 18,305 9,181 10,447 26,000 20,000 101 43121 01 415.00 Equipment Rental 16,328 11,108 26,570 20,500 25,0 0 Track-Hoe,Track Skid,Bucket,etc. 101 43121 01 433.00 Dues&Subscriptions 1,300 101 43121 01 433.01 American Public Works Ass'n 912 855 8D0 1,004 1,000 Annual Membership 101 43121 01 433.03 City Engineers'Association 0 0 0 100 100 101 43121 01 433.07 MN Street Superintendent Ass'n 100 100 100 20 200 101 43121 01 433.9 MN Transportation Alliance 788 804 804 0 0 101 43121 01 437.00 Conferences&Seminars 5,800 101 43121 01 437.01 APWA 1,780 D 0 2,000 2,0 0 StatelNaYl Conference in 2016 101 43121 01 437.03 Clerical 0 0 0 0 0 101 43121 01 437.05 Maintenance Expo 0 134 338 300 400 101 43121 01 437.06 Cartegraph,ESRI,G15 161 0 81 1,300 800 User Group,Conference,Training 1Q1 43121 01 437.07 Snow Conference 0 177 166 300 300 101 43121 01 437.08 MN Dot 0 0 0 300 300 Simulator 101 43121 1 437.09 Miscellaneous Training 576 615 1,152 2,d00 2,000 DCTC Defensi e Driving Training 101 43121 01 439.D0 ther Miscellaneous Charges 1,199 448 348 800 800 CONDAC,CDL Licenses 101 43121 01 570.0 Office Equipment&Furnishings 644 0 0 0 0 PAGE TOTALS 295,122 $323,315 $758,426 $328,300 429,440 DEPARTMENTTOTALS 1,302,271 $1,320,812 $1,762,084 $1,423,500 1,533,100 Page One 2U18 BUDGET WORKSHEETS PARKS 8 GR UNdS MAINTENANCE July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 45202 101.00 Salaries&Benefits 445,200 Salary,Taxes, PERA&Benefits 101 45202 77 101.00 Administrative 21,866 25,685 26,806 37,800 38,904 101 45202 78 101.00 Technical/Clerical 19,944 20,288 21,209 22,100 22,800 101 45202 79 1D1.00 Maintenance 340,619 324,310 353,971 385,900 383,500 101 45202 102.00 Full-Time Overtime 12,615 4,617 11,240 8,000 8,000 101 45202 99 103.00 Part-Time Salaries&Benefits 51,085 52,927 6D,263 55,800 61,000 Second Ass't Horticulturist 1 Q1 45202 01 2D5.00 Plotter Ink and Paper 197 91 774 500 400 101 45202 01 216.00 Chemical&Chemical Products 28,338 31,794 34,751 47,500 50,000 Jpn Bttl'16-18,Poa,Greystone 101 45202 01 219.00 Other Operating Supplies 50,000 101 45202 01 219.01 Seed,Sod,etc. 4,948 3,962 5,019 6,000 10,000 Topdressing Program,Ailesbury 101 452a2 01 219.02 Red Rock,Sand,Gravel,etc.8,830 10,449 6,974 14,000 20,000 Topdressing Program 101 452d2 01 219.03 Repair Supplies 0 0 6 0 0 101 452Q2 01 219.05 Wood Chips 12,000 12,000 14,999 15,OOD 20,000 Playgrounds,Greystone in 2018 101 45202 01 220.00 Splash Pad Maintenance 0 8,899 3,267 2,500 2,500 Supplies 101 45202 01 221.00 Equipment Parts 18,500 101 45202 01 221.01 Playground Equipment Repair 5,459 5,812 7,879 8,000 8,000 Repairs on Aging Equipment 101 452d2 01 221.02 Irrigation Repair(In-House) 6,357 6,962 6,859 8,000 8,0 0 101 45202 01 221.03 Miscellaneous 2,397 2,204 2,395 2,500 2,50Q 101 45202 01 221.04 Park Sign Replacements 0 0 0 0 0 101 452d2 01 223.00 Shelter Repair Supplies 2,400 101 452Q2 01 223.01 Paint,Stain,etc. 606 862 566 8DD 800 101 452d2 01 223.02 Shingles,Boards,etc.784 324 565 600 600 101 45202 01 223.03 Miscellaneous 1,016 629 1,542 1,DOD 1,000 101 45202 01 223.04 Shetter/Shed Repairs 829 147 0 0 0 Paid from Building Maint.Budget 101 45202 01 225.00 Landscaping Materials 8,000 101 45202 01 225.01 Trees,Shrubs,etc. 1,200 1,779 1,303 2,000 2,000 101 45202 01 225.02 Timbers,Fence,etc. 70 132 39 1,000 6,000 Dumpster Enclosure-Erickson('18} 101 45202 01 226.00 Sign Repair Materials 0 0 0 500 500 101 45202 01 229.00 Other Maintenance Supplies 9,728 14,101 19,824 18,000 18,000 Paint,Chalk, Field Dry,Etc. 101 45202 01 241.00 Small Tools 1,560 1,738 2,335 2,000 2,000 Hand Tools,Blades,Bits,etc. 101 452D2 01 242.DD Minor Equipment 2,576 4,340 4,687 5,000 5,000 Weed Whips,Chain Saws,etc. 101 45202 01 303.00 Engineering Fees(GIS) 0 0 1,095 2,000 2,000 Reduce Due to In-House Engineer 101 45202 01 318.00 Contract Engineer 3,000 1,562 4,044 0 0 101 45202 01 319.00 Other Professional Services 13,000 101 452D2 01 319.01 Maintenance of pen Spaces 18,697 4,738 5,869 7,000 7,Q00 Prairies,Controlled Burns,etc. 101 45202 01 319.02 Landscaping&Flower Beds 8,142 9,456 13,334 4,000 6,000 101 45202 01 321.00 Telephone Costs 3,927 3,836 4,144 5,000 5,000 All Wireless, Including iPad 101 45202 01 323.00 Radio Units 1,367 1,120 1,390 5,100 5,100 (24x$300)(12x$1500)(Split 5 Ways) 101 45202 01 381.00 Electric Utilities 22,500 Anticipated Rate Increase 101 45202 01 381.01 Skating Rinks 6,370 6,235 5,896 8,500 7,000 Service Connect!Disconnect 101 45202 01 381.02 Softball Fields 6,379 7,843 7,591 8,500 8,500 1Q1 45202 01 381.03 Irrigation 6,651 5,507 7,360 7,000 7,000 101 45202 01 383.00 Gas Utilities 2,287 1,684 1,652 2,500 2,5d0 101 45202 01 393.00 P.C.Hardware Purchases 1,600 0 0 1,000 1,000 101 45202 01 394.00 P.C.Software Purchases 8,900 101 45202 01 394.01 Licensing&Maintenance 4,371 4,591 4,629 6,200 8,400 Cartegraph,ESRI 101 45202 01 394.02 Online Subscriptions 379 379 0 800 300 Pictometry 101 45202 01 394.03 New Software Purchases 0 0 0 200 200 PAGE TOTALS 596,193 581,005 644,271 702,300 731,500 Page Two 2d18 BUDGET WORKSHEETS PARKS 8 GROUNDS MAINTENANCE July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 45202 01 403.00 Contracted Repair&Maintenance 15,000 101 45202 01 403.01 Irrigation Repairs 9,8 6 2,425 5,989 5,000 10,000 RPZ-Inspect,Chili Garden Tap('18) 101 45202 01 403.02 Electrical Repairs 2,479 1,462 3,203 3,000 3,000 101 45202 01 403.03 Miscellaneaus Repairs 1,425 3,654 1,750 2,000 2,000 Hard Court Fencing 101 45202 01 409.00 Other Contracted Repair&Maint 23,800 101 45202 01 409.01 Spring Clean Up 0 0 1,574 1,200 2,000 Dethatching,Flower Beds,etc. 101 45202 01 409.02 Library/Steeple Center I RCC 8,521 9,081 8,709 10,OD0 10,000 Mowing I Chemicals-VonBank 101 45202 01 409.03 Fire Station#1 3,834 4,087 3,919 0 D 101 45202 01 409.04 Fire Station#2 2,556 2,724 2,613 0 0 101 45202 D1 409.05 City Hall 6,391 6,811 6,532 Q 2,500 Mowing 1 Chemicals-VonBank 101 45202 01 409.06 UMore Baseball Fields 2,980 3,844 5,405 5,360 4,300 Chemicals-VonBank 101 45202 01 409.07 FHR Soccer Fields 2,451 5,901 4,526 6,000 5,000 Chemicals-VonBank 101 45202 01 416.00 Machinery Rental 26,500 101 45202 01 416.01 Mower Leases 15,161 18,000 21,000 21,000 22,500 3 Mowers 101 45202 01 416.02 Miscellaneous Rentals 4,092 4,478 7,052 5,000 4,000 Compressors, Lawn Mowers,etc. 101 45202 01 433.00 Dues&Subscriptions 200 101 45202 01 433.01 MN Park Supervisors Ass'n 50 0 50 5Q 50 101 45202 01 433.02 Miscellaneous Dues 0 75 129 150 150 101 45202 01 435.00 Books&Pamphlets 0 263 0 0 0 101 45202 01 437.00 Conferences&Seminars 3,600 101 45202 01 437.01 Seminars&Workshops 2,001 1,334 1,224 1,500 1,500 Green Expo,MPSA,Playgrounds 101 45202 01 437.02 School&Tuition 465 624 1,885 1,300 1,300 Turf School,Power Limited Tech. 101 45202 01 437.03 CarteGraph,ESRI,GIS 126 0 20 1,000 800 User Group,Conference,Training 101 45202 d1 439.00 Other Miscellaneous Charges 39 48 27 2Q0 2d0 Contingencies 101 45202 01 530.00 Improvements Other Than Bldgs 135,286 149,439 165,173 175,000 200,Oa0 From Long-Term Plan PAGE TOTALS 197,663 $214,249 $240,780 $237,700 269,300 DEPARTMENT TOTALS 793,855 $795,254 $885,051 $940,0 0 1,000,800 Page One 2018 BUDGET WORKSHEETS PARKS RECREATION July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 45100 101.00 Salaries&Benefits 762,122 $748,284 $799,643 $828,900 858,200 Salary,Taxes,PERA&Benefits 101 45100 102.00 Full-Time Overtime 3,018 1,372 317 5,000 5,000 101 45100 103.00 Part-Time Salaries&Benefits 216,800 101 45100 10 103.00 P/T Receptionist 37,221 44,930 33,990 38,100 41,100 101 45100 12 103.00 Building Attendants 46,178 53,567 55,483 54,0 0 54,000 101 45100 15 103.00 PIT Recreation Coordinator 0 13,296 35,872 52,600 75,400 Add Hours and Benefits 101 45100 83 103.Q0 Playground Recreation Leaders 23,195 25,26 38,968 29,500 29,500 101 45100 94 103.00 Warming House Attendants 10,347 1a,162 11,051 15,000 13,000 101 45100 99 103.00 Park&Rec Committee 1,420 1,464 2,396 2,000 3,800 101 45100 01 203.00 Printed Forms&Paper 0 0 0 0 0 101 45100 01 205.D0 Drafting Supplies 0 500 437 500 500 Laminating 101 45100 01 207.00 Training&Instructional 5upplies 0 0 0 0 101 45100 1 208.00 Miscellaneous Supplies 0 0 4,290 0 0 101 45100 01 209.00 Other Office Supplies 259 873 470 500 500 Envelopes,Forms,Rulers,etc. 101 45100 01 211.00 Cleaning Supplies 3,573 4,553 4,434 4,500 4,500 101 451 DO 01 216.OD Chemicals&Chemical Products 689 527 682 0 0 Moved to"211.00" 101 45100 01 219.00 Other bperating Supplies 7,593 9,438 7,735 8,000 8,000 Rec Programs,1 st Aid Sup,etc. 101 45100 01 221.00 Equipment Parts 6,772 9,599 8,277 8,000 8,000 101 45100 01 223.00 Building Repair Supplies 649 2,039 1,452 1,500 1,50Q _ 101 45100 01 229.00 Other Maintenance Supplies 9,736 4,635 8,938 6,000 6,D04 Tournament Supplies 101 45100 01 312.00 Custodial Services 4,461 5,450 4,900 6,000 6,OOD Custodial Services-Banquet Rm 101 45100 01 315.00 Special Programs 19,000 ___ 101 45100 01 315.01 Sunday Night Specials 4,873 5,326 5,222 5,500 5,500 Performances(Add Movies) 101 45100 01 315.02 Leprechaun Days 910 400 1,167 250 250 101 45100 01 315.03 Umore Maint.Agreement 2,000 2,038 2,038 2,000 2,000 101 45100 01 315.04 Ground Pounders(Running) 20D 225 600 200 200 Ribbons&Mailings 101 45140 01 315.05 Nature Programs(Arbor Day) 0 221 0 0 Move to 101-41110-01-225.00 101 45100 01 315.06 Puppet Programs 0 189 157 150 150 Tapes,Fuses,Puppets,etc. 101 45100 01 315.07 Special Events 849 1,512 2,239 2,000 2,000 Publicity&Supplies(Winter Fest) 101 45100 01 315.08 Adopt-A-Park Program 54 50 98 500 500 Flyers,Signs 101 45100 01 315.09 Miscellaneous Programs 2,223 1,680 2,112 9,000 5,000 Community Gardens 101 45100 01 315.1 D ADA Programs 0 0 0 460 400 ADA Program Supplies 101 45100 01 315.11 5enior Programs 0 0 0 0 3,000 101 45140 01 319.Q0 Other Professional Services 6,964 6,802 7,525 6,000 6,000 ADA ServiceslEng.LA Serv Test 101 45100 01 321.00 Telephone Costs 3,904 4,354 4,565 4,000 4,500 Pagers&Cellular Phones 101 45100 01 331.0 Travel Expense 253 493 36 1,000 1,000 101 45100 01 341.00 Employment Adveftising 0 0 0 0 0 101 45100 01 349.00 Other Advertising 33,400 101 45100 01 349.01 Brochures 28,574 29,572 32,310 29,000 29,000 City Newsletter(3 Per Year) 101 45100 01 349.02 Yellow Pages 385 391 363 500 500 Rec Ads 101 45100 01 349.a3 Special Marketing 4,522 4,806 4,528 3,900 3,900 Garage Sale Ad 101 45100 01 381.Q0 Electric Utilities 33,207 30,874 29,535 30,000 30,000 _ 1D1 45100 d1 383.00 Gas Utilities 34,036 21,845 17,885 30,000 17,0 0 _ 101 45100 d1 384.00 Refuse Disposal 3,062 3,062 3,062 3,200 3,200 101 45100 01 392.00 P.C.Accessories&Supplies 0 0 0 0 ____ 101 451 0 01 393.00 P.C.Hardware Purchases 0 0 0 0 0 101 45100 01 394.00 P.C.5oftware Purchases 0 0 0 0 0 See"433.03"Below 101 45100 01 401.00 Contracted Building Repairs 13,070 9,771 16,411 12,000 12,400 101 45100 01 404.00 Contracted Mach&Equip Repairs 13,542 13,647 19,004 9,000 10,aoa 101 45100 01 409.00 Other Cantracted Repair&Maint 26,330 24,143 26,010 24,000 24,000 Air Handler Maintenance Contract 101 45100 01 412.0o Building Rental 16,800 16,840 16,800 16,80 16,800 Monthly Rent Payments to Guard 101 4510D 01 415.00 Other Equipment Rental 22,480 24,749 29,158 24,000 24,00 Portable Toilets&Other(New Pks} 101 45100 01 433.00 Dues&Subscriptions 7,300 101 45100 01 433.01 MRPA Dues 1,520 1,869 2,086 1,700 2,100 Minn Recreation&Parks Ass'n 101 45100 01 433.02 Miscellaneous 2,445 2,515 2,419 2,00 2,500 Paper,Magazines,etc. 101 45100 01 433.03 On-Line RegistraYn Subscription 2,053 2,o25 1,97o 2,700 2,700 101 45100 01 435.00 Books&Pamphlets 0 0 0 100 100 101 45100 01 437.00 Conferences&Seminars 6,000 101 4510 01 437.01 MRPA 5tate Conference 1,604 1,353 1,700 2,000 2,000 141 45100 01 437.03 Workshops,Schools,8 Tuition 1,191 2,Q08 1,612 4,000 4,040 Additional Training 101 45100 01 439.00 Other Miscellaneous Charges 13,378 7,721 26,350 0 0 Donation Account 101 45100 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 PAGETOTALS 1,157,660 $1,156,093 $1,276,300 $1,286,000 1,329,300 General Operating DEPARTMENT TOTALS 1,157,660 $1,156,093 $1,276,300 $1,286,000 1,329,300 Page Two 2015 BUDGET WORKSHEETS PARKS&RECREATION STEEPLE CENTER*' July 1 Q,2017 2018 2017 Object 2018 2614 2 15 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 38201.00 Rental Revenues 4,8D0 0 $19,614 $28,000 28,000 101 38205.00 AN Rental Revenues 0 0 513 2,400 2,600 1Q1 38207.00 Liquor Provider Revenues 0 0 52 0 0 101 38209,00 Miscellaneous Revenues 175 0 0 0 0 101 38211.00 Security Services 651 0 1,187 2,000 2,000 101 38215.00 Other Revenues 0 0 744 0 0 TOTAL REVENUES 5,626 0 $22,109 $32,000 32,000 2015 Closed for Construction 101 45100 30 103.00 Salaries&Benefits 52,004 Salary,Taxes,PERA&Benefits 101 45100 30 103.00 Building Attendants 5,177 1,639 65,220 52,000 52,000 Staff^^ 101 45100 30 211.00 Cleaning Supplies 1,059 822 4,811 4,600 4,000 161 45100 3D 219.00 Other Operating Supplies 2,704 4,855 9,703 2,500 4,500 Events Supplies 101 45100 30 221.00 Equipment Parts 0 6,099 8,436 1,500 2,OD0 101 45100 3a 223.00 Building Repair Supplies 4,444 3,134 6,508 5,500 5,500 101 45100 30 241.OD Small Tools Q 0 180 500 500 101 45100 30 242.Od Minor Equipment 191 353 2,351 2,000 2,000 101 45100 30 312.00 Custodial Services 299 450 420 2,000 2,DOD 10 4510a 30 321.00 Telephone Costs 219 547 376 3,000 500 1 1 45100 30 349.00 Qther Advertising 0 0 0 600 600 _ 101 45100 30 381.00 Electric Utilities 5,485 10,472 16,721 6,500 16,000 101 45100 30 383.00 Gas Utilities 10,065 6,934 7,656 10,000 7,500 101 45100 30 384.00 Refuse Disposal 1,068 0 133 1,800 1,800 101 45100 30 401.00 Contracted Building Repairs 14,069 17,266 15,367 9,000 10,000 101 45100 30 404.40 Contracted Mach&Equip Repairs 4,803 2,334 14,121 7,000 7,000 101 45100 30 409.00 Other Contracted Repairs&Main 1,532 0 1,088 2,500 2,5D0 101 45100 30 415.00 Other Equipment Rental 0 0 233 1,000 1,000 101 45100 30 439.00 Other Miscellaneous Charges 0 0 0 0 0 101 4510o 30 521.00 Building&Structure Purchases o 0 0 0 0 PAGE/EXPENDITURE T TALS $51,115 $54,906 $153,322 $111,400 119,400 2015 Combined Steeple Center/ Activity Center Expenditures Page Three 2018 BUDGET WORKSHEETS PARICS&RECREATI N July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 85,40d 101 45100 80 Art Classes 0 0 0 0 0 1 1 45100 81 Softball 25,390 20,188 17,482 23,500 15,000 101 45100 84 Tennis 2,379 2,292 2,044 2,200 2,200 101 45100 86 Rosettes 2,363 2,098 1,730 2,OOD 2,000 101 45100 87 Senior Programs 5,754 7,711 9,336 6,000 8,000 101 45100 90 Run for the Gold 4,878 4,890 4,193 4,800 4,800 101 45100 91 Camps 24,778 30,904 29,151 3D,000 30,000 101 4510o 92 Adult Basketball 0 (139) 0 600 600 101 45100 93 Other Programs 12,751 11,964 15,019 14,000 14,000 101 45100 95 T-Ball 5,720 4,261 5,608 5,000 5,000 101 45100 96 Adult Enrichment 350 986 0 900 SDO 101 45100 97 Adult Exercise Classes 8,835 0 0 0 500 101 45100 98 Youth Soccer Lessons 2,894 2,117 2,536 2,8Q0 2,800 96,092 87,272 87,098 91,800 85,400 101 45100 80 219.00 Operating Supplies 0 0 0 0 0 ___ 101 45100 81 103.00 Part-Time Salaries 4,083 3,748 2,955 3,500 2,000 101 45'100 81 219.00 Operating Supplies 2,679 3,327 2,980 2,500 1,900 101 45100 81 311.00 Officiating Fees 17,323 12,261 10,805 16,000 10,500 ___ 101 45100 81 319.00 Other Professional Services 1,305 851 742 1,500 600 101 45100 84 103.00 Part-Time Salaries 1,935 2,216 2,044 1,700 1,700 101 45100 84 219.00 Operating Supplies 444 75 0 500 500 101 45100 86 103.00 Part-Time Salaries 870 1,104 1,044 1,000 1,000 101 45100 86 219.00 Operating Supplies 1,493 994 686 1,000 1,Q00 _ 101 451 0 87 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 87 219.00 Operating Supplies 8,000 101 45100 87 219.01 Youth/Teen Trips Supplies 0 0 0 0 0 1 1 45100 87 219.02 AdulUSenior Supplies 5,754 7,711 9,336 6,000 8,000 101 45100 90 219.00 Operating Supplies 4,878 4,890 4,193 4,800 4,800 101 45100 91 103.00 Part-Time Salaries 10,724 15,934 7,524 16,000 16,000 101 45100 91 219.00 Operating Supplies 14,054 14,970 21,627 14,000 14,000 101 45100 92 219.00 Operating Supplies D (139) 0 60o fi00 101 45100 93 103.00 Part-Time Salaries 3,842 5,582 3,6fl2 3,000 3,000 101 45100 93 219.00 perating Supplies 8,909 6,382 10,249 11,000 11,d00 101 45100 93 319.00 Other Professional Services 0 0 1,168 0 0 101 451 0 95 103.00 Part-Time Salaries 4,095 3,043 4,216 3,500 3,500 101 45100 95 219.00 Operating Supplies 1,626 1,218 1,391 1,500 1,500 101 451 DO 96 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 96 219.00 Operating Supplies 350 986 0 900 500 101 45100 97 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 97 219.00 Operating Supplies 5,595 0 0 0 500 101 45100 97 311.00 OfFiciating Fees 3,240 0 0 0 0 101 451 QO 98 103.60 Part-Time Salaries 2,147 1,444 1,691 1,800 1,800 101 45100 98 219.00 Operating Supplies 747 672 845 1,000 1,000 SPECIAL PROGRAM TOTALS 96,092 87,272 87,098 91,800 85,400 GRAND TOTAL-PARK&REC $1,304,867 $1,298,271 $1,516,72b $1,489,2 0 1,534,100 Page One 2018 BUDGET WDRKSHEETS OTHER FINANCING USES July 10,2017 2018 2017 Object 2b18 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101-49300-01 710.00 Transfers 115,000 $130,000 $130,000 $130,000 130,000 101-49300-01 710.01 Arena Operations Assistance 0 0 0 0 130,0 0 101-49300-01 710.02 Debt Service Levies 0 0 0 0 0 101-49300-01 720.00 Transfers 360,000 500,000 0 0 0 Excess F/B Transfers FUND TOTALS 475,DOD $630,000 $130,000 $130,QOQ 130,000 Page ne 2018 BUDGET WQRKSHEETS INSURANCE-REVENUES July 1 d,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 206 31010.00 Current Ad Valorem Taxes 245,000 $245,000 $245,000 $260,000 280,000 206 3310D.00 Federal Grants&Aids 0 0 0 0 0 206 36210.00 Interest Earnings-Investments 4,103 4,682 4,702 4,ODD 4,000 206 36214.00 Net Change in FV-Investments 0 0 0 Annual Market Value Changes 206 36215.00 Interest Earnings 33 91 105 100 100 206 36260.00 Other Revenue 244,491 86,393 78,717 30,000 50,000 Insurance Refunds/Dividends 206 36265.00 Use of Reserve Funds 0 0 0 60,900 49,900 (2014-$217,000 Hail Damage) FUND T TALS 493,627 336,166 328,523 355,aao 384,000 INSURANCE-EXPENDITURES 2018 2017 Object 2018 2014 2 15 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 206 49006 01 221.00 Equipment Parts 4,187 $7,049 $11,986 $5,000 10,Q00 Liability&Auto Deductible Pymts 206 49006 01 304.00 Legal Fees 1,755 0 121,142 1,000 10,000 Unreimbursable Legal Fees 206 49006 01 305.00 Medical&Dental Fees 6,949 6,379 5,943 7,000 7,000 Work Comp Deductible Pymts 206 49006 01 317.00 General Fund Administrative Fees 2,500 2,500 2,500 2,500 2,500 Yearly Fee Per Policy F-3 206 49006 01 319.00 Other Professional Services 19,500 206 49006 01 319.01 Risk Management Consultant 6,000 6,250 6,000 6,500 6,500 206 49006 01 319.02 CHESS Consultant 12,540 12,72 13,020 13,000 13,000 206 49006 01 365.00 Worker's Compensation Insurance 112,534 131,630 152,697 135,000 150,000 Annual Premium 206 49006 01 369.00 Other Insurance 98,607 108,529 124,099 110,000 130,000 Annual Premium-General Liability Changed to High Deductible} 2b6 49006 01 403.00 Contracted R&M-Other Impr. 20,332 5,533 0 0 0 Liability&Auto Deductible Pymts 206 49Q06 01 409.00 ther Contracted Repair&Maint 274,248 73,694 38,194 75,000 55,000 Liability&Auto Deductible Pymts 206 49006 01 439.06 Other Miscellaneous Charges 0 0 D 0 0 206 49006 01 550.00 Motor Vehicle Purchases 21,730 0 27,D12 0 0 2014&2016-Replace Vehicle FUND TOTALS 561,381 354,284 502,593 355,000 384,D00 (Changed to High Deductible} NOTE: Levy of$280,000 covers costs for all insurance premiums and some of the general liability payments(changed to high deductible plan for 2011). All other expenditures covered through a combination of tax le ies,interest earnings,insurance refunds/dividends and reserve funds. Page One 2418 BUDGET WORKSHEETS PORT AUTHORITY-REVENUES July 10,2617 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 201 31010.00 Current Ad Valorem Taxes 58,000 $58,000 $58,000 $58,000 110,600 Operating Le y 201 31050.00 Tax Increments D 0 0 0 D Admin Fees Portion nly 201 32280.00 Fiber License Fees 0 0 2,000 2,400 2,400 201 33130.Oo Federal Grants-CDBG 0 0 0 0 0 201 33425.00 Other State Grants&Aids 734,060 287,090 0 0 0 LCA Grant-Land/Bldg Acquisition 201 33620.00 Other County Grants&Aids 6,600 0 0 0 0 Dakota Cty-South Gateway 201 34109.00 Other Charges for Services 0 0 D 0 Genz-Ryan Tenant Utility Pymts 201 36210.00 Interest Earnings-Investments 49 74 55 10 100 Interest Earned on CD's 201 36215.00 Interest Earnings 33 58 76 100 100 Checking Interest&Misc 20136230.00 Contributions/Donations 0 0 0 0 0 201 36260.00 Other Revenue 763 0 0 0 0 201 36265.Q0 Use of Reserve Funds 0 0 0 0 0 201 39101.00 Sales of General Fixed Assets 0 0 0 0 0 FUND TOTALS 799,505 $345,222 $60,131 $60,600 113,200 EXPENDITURES 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of Salary,Taxes,PERA 8 Benefits 201 46300 01 103.00 Part-Time Salaries&Benefits 5,511 $11,171 $5,752 0 Part-Time I tern 201 4630 99 103.00 Part-Time Salaries&Benefits 2,305 3,008 2,467 4,000 4,000 Port Authority Members 201 46300 01 303.00 Engineering Fees 0 d 2,936 2,000 3,000 201 46300 01 304.00 Legal Fees 8,422 4,912 3,261 5,00 4,50o 201 46300 01 317.00 General Fund Administrative Fees 6,000 6,000 6,000 6,000 6,000 Yearly Fee Per Policy F-3 201 46300 01 319.00 Other Professional Services 69,000 201 463D0 1 319.01 Project Management Consultant 0 0 0 2,000 2,000 201 463Q0 01 319.02 Marketing-REDE-City Share 10,000 14,373 10,000 1D,000 10,000 Greater MSP 201 46300 01 319.04 P/A Property Tax Payments 0 0 0 0 0 201 46300 01 319.05 ther Gonsultants 0 0 700 7,000 7,OOQ Downtown Update 201 46300 01 319.6 Grant Reimbursement Expenses 11,553 0 0 0 0 201 46300 01 319.07 Retail Strategies 16,667 16,667 0 0 50,000 201 46300 01 322.00 Postage Gosts 0 0 0 0 0 201 4630 01 331.00 Travel Expense 0 0 0 0 0 201 46300 01 349.00 Other Advertising 9,216 14,217 11,627 12,000 12,00 Additional Marketing Opportunitiss 201 46300 01 359.00 Other Printing&Binding Costs 902 100 637 1,500 1,500 201 46300 01 365.00 Workers Comp Insurance 530 604 616 700 700 Commissioners 2 1 46300 01 369.00 Other Insurance 409 440 696 500 600 Property Insurance 201 46300 01 381.00 Electric Utilities 190 130 321 400 440 Business Park&Other Properties 201 46300 01 383.00 Gas Utilities 0 0 0 0 0 Other Properties 201 46300 01 389.00 Other Utility Services 0 0 0 0 2,000 Utility Fees/Fiber Maintenance 201 46300 01 403.OD Contracted Repairs&Maintenance 0 0 0 2,000 2,000 Contracts for Fiber 201 46300 01 433.00 Dues&Subscriptions 2,000 Prof Organizations/Journals 201 46300 01 433.01 Professional rganizations/Journ 2,088 2,392 1,671 2,000 2,000 201 46300 01 433.02 Foreign Trade Zone Commission 0 0 0 0 0 201 46300 01 437.00 Conferences&5eminars 1,277 7,349 1,428 5,000 5,000 DevelopmentlTlF/Miscellaneous 201 46300 01 439.00 Other Miscellaneous Charges 172 0 443 500 500 Contingencies 201 46300 01 521.00 Building&Structure Purchases 0 0 0 0 0 201 46300 01 525.00 Building&Structure Purchases 652,781 287,090 24,979 0 0 LCA Grant-Land/Bldg Acquisition 201 46300 01 530.00 Impro ements Other Than Bldgs 0 0 0 0 0 201 46300 01 710.00 Transfers D 86,437 0 0 0 FUND TOTALS 728,022 $454,890 $72,931 $60,6D0 113,200 Page One 2018 BUDGET WORKSHEETS DOWNTOWNIBROCKWAY DISTRICT(01U8)-REVENUES July 1 a,2017 2018 2017 Object 2018 2Q14 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 242 31010.00 Current Ad Valorem Taxes 0 0 0 0 0 MVHC Payments 242 3105.00 Tax Increments 646,636 720,963 794,268 800,000 800,00a 242 33400.00 State Grants&Aids 0 0 0 0 0 242 33425.00 Other 5tate Grants&Aids 0 0 0 0 0 242 3362Q.00 Other County Grants&Aids 0 0 0 0 0 242 36210.00 Interest Earnings-Investments 645 978 1,961 800 800 242 36215.00 Interest Earnings 83 139 539 0 0 242 36220.00 Rents&Royalties 0 0 0 d 0 242 36230.OD Other Revenue 0 0 0 0 0 _ 242 36260.00 Contribution/Donation-Private 0 0 0 0 0 242 39101.00 Sale of General Fixed Assets 283,045 15,000 308,161 0 0 242 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS 930,409 $737,080 $1,1 4,929 $800,800 800,800 EXPENDITURES 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 242 49042 D1 303.00 Engineering Fees 0 0 0 0 0 _ 242 49042 01 304.00 Legal Fees 0 0 0 0 D 242 49042 01 319.00 Other Professional Services 12,942 14,919 12,438 15,000 15,000 County TIF Charges 242 49o42 01 522.00 Building&5tructure Purchases 40,278 0 0 0 0 CDA-Dahn Property Purchase 242 49042 01 530.00 Improvements Other Than Buildings 0 0 0 0 0 242 49042 01 533.00 Improvements Other Than Buildings 0 0 0 0 0 242 49042 01 536.00 Impro ements Other Than Buildings 170,062 0 0 0 0 Fiber in Business Park 242 49042 01 538.00 Improvements Other Than Buildings 206,434 o 0 0 0 TH 3 Turn Lane Improvements 242 49042 01 601.00 Principal on Waterford PAYG 64,515 69,168 67,894 71,300 80,000 Waterford Pay-As-You-Go 242 49642 01 611.00 Interest on Waterford PAYG 81,453 78,081 74,709 72,000 68,000 Waterford Pay-As-You-Go 242 49042 01 710.00 Transfers 400,Q00 450,000 500,OD0 550,000 550,000 P&I for 2D08A&20Q8B Issues FUND TOTALS 975,684 $612,168 $655,041 $708,3D0 713,000 Page One 2018 BUDGET WORKSHEETS WATER UTILITY REVENUES- July 10,2017 2018 2017 Object 2 18 2014 2015 2016 Adopted Detail Proposed Accaunt# Description Actual Actual Actual Budget Amount Budget Comments 601 33425.00 Other State Grants&Aids 9,901 0 $24,248 $4,500 4,500 MCES Water Efficiency Grant 601 34108.00 Administrative Fees-ther Funds 3,931 6,828 8,168 0 6,300 5%of 5°/a Fees-Const Projects 601 34109.00 Other Gen'I Govt Chgs for Services 15,820 5,850 9,045 0 0 601 36101.00 Principal-Special Assessments 56,217 54,299 98,164 57,000 57,OOD 601 36102.00 Penalties&Interest-S/A 847)57 690 0 0 601 36210.00 Interest Earnings-Investments 105,027 97,236 113,846 60,000 60,000 601 36214.00 Net Change in FV-Investments 96,607 (5,138) (51,252) D D Annual Market Value Changes 601 36215.00 Interest Earnings 65 280 1,033 200 200 601 36220.00 Rents&Royalties 107,624 158,580 142,237 148,500 148,50D Antenna Leases 601 36260.00 Other Revenues 0 0 126 0 0 601 36265.00 Use of Reserve Funds D 0 0 0 412,50D 601 37110.00 Residential Water Revenues 1,100,286 1,090,820 1,234,904 1,2D0,000 1,200,000 Est$6K Lost Rev from Rebate Prog. 601 37120.00 Apartment Water Revenues 84,079 94,071 109,567 100,000 100,000 601 37125.00 Institutional Water Revenues 61,957 69,187 78,051 75,000 75,000 601 37130.00 Commercial Water Revenues 79,817 81,477 86,107 85,000 85,000 601 37140.00 Industrial Water Revenues 113,947 164,347 158,310 150,00 150,000 601 37160.00 Penalties-Water Revenues 9,280 1Q,506 10,810 9,500 9,506 601 37165.OD Meter Maint Water Revenues 0 0 0 0 0 601 37170.Q0 Other Water Revenues 2,800 592 0 0 0 6Q1 37180.00 Water Meter Sales Revenue 37,385 49,Q58 52,736 45,DD0 55,000 601 39103.00 Gain or Loss from F/A Disposal 0 (494) {249) 0 0 601 39203.OQ Transfer From 0 89,1 1 0 0 0 FUND TOTALS 1,883,897 $1,966,658 $2,076,542 $1,934,700 2,363,500 Page One 2018 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES- July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 601 49400 101.04 Salaries&Benefits 522,800 Salary,Taxes,PERA&Benefits 601 49400 77 101.04 Administrative 117,387 139,529 153,689 178,300 175,506 601 49400 78 101.00 Technical/Clerical 151,671 151,280 158,777 159,800 167,20Q 2 Additional Finance Positions 601 4940D 79 101.00 Maintenance 163,437 165,527 171,037 174,800 180,100 601 49400 xx 101.00 Salary&Benefit Contingency 0 0 0 0 0 601 4940D 102.00 Full-Time Overtime 13,810 9,705 12,552 8,000 8,000 601 49400 103.00 Part-Time Salaries&Benefits 6,508 5,132 8,081 7,000 7,0 0 601 49400 99 103.01 Utility Commission Wages(50%) 1,000 50%-601; 50%-602 601 4940Q 99 103.02 Mainte ance Labor 6,000 100°/o-601 601 49400 01 203.00 Printed Forms&Paper 2,075 1,005 1,067 2,200 2,200 Inserts&Water Bill Statements 601 49404 01 205.00 Plotter Ink&Paper 0 0 0 0 400 601 49400 01 209.0 Other Office 5upplies 186 168 61 200 200 601 49400 01 212.00 Motor Fuels 0 d 0 5,600 5,100 3%Covered by Water Utility 601 49400 01 216.00 Chemicals&Chemical Products 51,562 48,581 48,355 75,000 75,000 Chlorine/Flouride/Poly{Add Well 16) 601 49400 01 219.00 Other Operating Supplies 25 50 957 300 300 Maintenance Supplies 601 49400 01 220.00 Water Meter Purchases 120,000 Meters,MIU's&CU Horns 601 49400 01 220.01 For Replacements 13,930 16,142 87,771 62,500 65,000 From Water Rate Model 601 49400 01 220.02 For New Homes 68,837 74,982 58,843 45,000 55,000 From Water Rate Model 601 49400 01 224.00 Street Maintenance Materials 0 640 2,285 2,50 2,500 Patching for Breaks 601 49400 01 225.00 Landscaping Materials 0 66 1,103 500 1,000 Topsoil,Seed&Sod 601 49400 01 228.00 Meter Repair Materials 490 0 90 0 0 601 49400 01 229.00 Other Maintenance Supplies 15,000 601 49400 01 229.01 Supplies for Hydrants 6,622 8,619 5,846 8,000 8,000 601 49400 01 229.D2 Curb Shutoffs 653 252 135 1,000 1,000 601 49400 01 229.03 GV Repair/Replacement 11,973 303 1,513 12,000 2,000 601 49400 01 229.04 Miscellaneous Supplies 2,581 2,Q74 933 5,000 4,000 6Q1 49400 01 241.d0 Small Tools 702 626 1,432 2,000 2,000 Wrenches,Shovels,etc. 601 49400 01 242.40 Minor Equipment 2,966 5,113 3,543 12,00 8,000 Hydrant Tools(2017),Trailer(2018) 6Q1 49400 01 303.00 Engineering Fees 78,00 601 494Q0 01 3Q3.01 WHPP 0 0 0 5,000 5,000 Groundwater Plan Implementation 601 49400 01 303.02 GIS 4,607 3,413 1,920 3,000 3,000 601 49400 01 303.03 Rate Study 0 0 3,900 15,000 15,000 Part of Comp Plan Update 601 49400 01 303.04 Miscellaneous Fees 29,118 68,392 32,177 55,000 55,000 Water Facility Study in'17($50K) 601 49400 01 304.OQ Legal Fees 0 D 0 1,Q00 1,000 601 49400 01 310.00 Testing Services 48,Q00 601 49400 01 310.01 Bacteria&Water Quality 1,560 1,966 1,516 2,000 2,000 Radon,Tri-Chl.,Pesticides,Etc. 601 49400 01 310.03 MDH Service Connection Fee 43,552 44,475 45,167 45,000 46,000 601 49400 01 312.Oo Gopher State One-Call 2,770 1,655 1,602 2,500 2,500 $7,500 Split 3 Ways 601 49400 01 318.00 Contract Engineer 12,000 6,250 16,174 0 0 601 49400 01 319.00 Other Professional Services 27,500 601 4940D 01 319.01 Thaw Pipes,Check Leaks,etc. 32,250 0 0 1,500 1,500 601 49400 01 319.02 Supervisory Controls 6,562 3,575 4,483 12,SD0 5,000 601 49400 01 319.03 Hazardous Chemical Permits 725 725 725 1,000 1,000 MN Department of Public Safety 601 49400 01 319.06 Contracted Hydrant Painting 10,120 10,028 1,028 11,000 11,000 601 49400 01 319.07 Antenna Expenses 19,904 15,458 7,621 0 0 601 49400 01 319.08 Buxton Project 5,556 5,556 0 0 0 601 4940D 01 319.09 HVAC Maintenance Contract 0 0 0 4,OD0 4,OOd Annual Insp/Maint,All Wells 601 49400 01 319.10 Landscape Maintenance 0 0 0 0 4,000 601 49400 01 319.11 Pest Control 0 0 0 0 1,000 601 49400 01 320.OQ Credit Card Activity Fees 5,372 6,797 6,097 7,000 7,OD0 1/3 Cost of C/C Pymt Processing 601 49400 01 321.Od Telephone Costs 3,d03 3,122 3,451 3,500 3,500 Cell Phones,Modesm,GPS 601 49400 01 322.00 Postage Costs 4,173 4,296 4,315 5,000 5,000 Billings with Inserts 601 49400 01 323.00 Radio Units 1,367 1,120 1,390 5,100 5,100 (24x$300){12x$1500)(Split 5 Ways) 601 49400 01 352.00 General Notices&Public Info 0 0 30 0 0 601 49400 01 365.00 Workers Comp Insurance 7,a95 8,338 10,058 7,000 12,OD0 Water's Share of Premiums 601 49400 01 369.00 Other Insurance 6,048 6,132 6,382 6,SD0 7,000 Water's Share of Premiums 601 49400 01 391.00 P.C.Maintenance 2,9 0 601 49400 01 391.01 U/B 5oftware Maintenance 2,074 2,074 2,117 2,200 2,200 Added to Utility Budgets in 2012 601 49400 01 391.02 Auto Read Software Suppart 578 595 613 700 700 Added to Utility Budgets in 2012 601 49400 01 392.00 P.C.Accessories&Supplies D 40 0 240 240 601 49400 01 393.00 P.C.Hardware Purchases 1,707 9,199 1,306 2,000 2,000 601 49400 01 394.00 P.C.Software Purchases 8,900 601 49400 01 394.01 Licensing&Maintenance 4,371 4,591 4,629 15,000 8,400 ESRI,Cartegraph 601 49400 01 394.02 Online Subscriptions 379 379 0 800 300 Pictometry 601 49400 01 394.3 New Software Purchases 0 0 200 200 PAGE TOTALS 820,530 837,962 883,765 975,40D 980,10 Page Two 2018 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES- July 10,2017 2018 2017 Object 2018 2014 2015 2 16 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49400 01 403.00 Contracted R&M-Other Impr 23,576 23,397 59,309 30,000 50,000 Main Breaks,Gate Valves,Etc. 601 49440 41 416.40 Machinery Rental 0 0 0 0 0 601 49400 01 433.00 Dues&Subscriptions 0 187 250 440 400 Suburban Utility Supt Assn,MRWA 601 49400 01 435.00 Books&Pamphlets 0 0 0 200 200 Reference Materials 601 49400 01 437.00 Conferences&Seminars 6,000 601 49400 01 437.01 MDH Training(Water Schooly 1,459 2,161 436 2,500 3,Q00 Operator Licensure 601 49400 01 437.02 AVW1/A Conference 0 0 0 1,200 1,200 Duluth,Send 2 Staff 601 4940D 01 437.03 CarteGraph,ESRI,GIS 126 0 81 1,000 800 User Group,Conference,Training 601 49400 01 437.04 Miscellaneous Training 9 849 928 1,000 1,000 601 49400 01 439.00 Other Miscellaneous Charges 13,460 13,459 16,057 45,000 45,000 DNR Annual Water Use 601 49400 01 454.00 Sales Tax on Purchases 0 2,699 0 0 0 601 4940Q 01 521.00 Building&Structure Purchases 0 0 0 1Q,000 10,000 Pymt on P.W.Building(20 of 20) 601 49406 01 530.00 Improvements Other Than Bldgs 915,600 601 49400 01 530.01 Well Inspections 560 0 800 600 600 601 49400 01 530.02 Miscellaneous Improvements 0 4 5 63,720 5,000 150,OOD Investigate and Seal Wells 1&2 601 49400 01 530.03 CRP of Watermain 0 0 0 150,000 50,004 PMP Water Imp.When Needed 601 49400 01 530.04 Inspection&Maintenance 0 259,255 49,361 65,00 715,D00 From Long-Term Plan 601 49400 01 540.00 Heavy Machinery Purchases 0 D D 0 0 Equipment Purchases-Match CIP 601 49400 01 550.00 Motor Vehicle Purchases 0 0 0 10,000 52,000 Equipment Purchases-Match CIP 6a1 494d0 01 570.00 Office Equipment Purchases 0 D D SDO 500 601 49400 01 580.Q0 Other Equipment Purchases 0 0 0 7,000 16,600 Trash Pump(Split with 602,603} 601 49400 01 611.00 Interest on Lease Payments 2,167 1,773 1,362 0 0 P.W.Building Expansion(See 521) 601 49400 01 710.00 Transfers 4,796 0 181,450 0 0 Transfers for Other Improvements 601-49400-01 TOTALS 866,683 1,142,148 1,257,519 1,304,80Q 2,076,400 601 49406 01 221.00 Equipment Parts 2,762 0 0 13,000 1,500 SCADA Upgrades 601 49406 01 223.00 Building Repair Supplies 7,250 0 0 200 200 601 49406 01 319.0 Other Professional Services 2,352 5,862 491 1,000 1,000 601 49406 01 381.00 Electric Utilities 1,D83 1,147 1,197 1,3D0 1,300 Pumping&Lighting TOTAL-PRV 13,448 7,009 1,688 15,500 4,000 601 49407 Q1 221.Q0 Equipment Parts 0 409 0 1,500 1,500 601 49407 01 223.00 Building Repair Supplies 8 0 98 240 200 601 494Q7 41 319.00 Other Professional Services 0 0 0 0 601 49407 61 321.00 Telephone Costs 211 211 211 300 3Q0 601 49407 01 381.00 Electric Utilities 23,142 20,778 22,695 33,000 33,040 Pumping,Lighting,Tower Mixer 601 49407 01 409.OQ Other Contracted Repairs&Maint 11,781 1,429 404 2,000 2,OQ0 601 49407 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49407 01 530.00 Improvements Other Than Bldgs 0 0 0 60,004 10,000 Controls(2017,Landscape(2 18} TOTAL-WELL#7 35,142 22,826 23,408 97,100 47,100 601 49408 01 221.00 Equipment Parts 242 25 0 1,500 1,500 fi 1 49408 01 223.00 Building Repair Supplies 106 19 0 200 200 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 601 49408 01 381.00 Electric Utilities 21,542 20,456 22,293 25,OOQ 25,000 Pumping&Lighting 601 494D8 01 383.00 Gas Utilities 592 497 355 600 600 Heat Only 601 49408 01 409.00 Other Contracted Repairs&Maint 27,330 735 5,862 2,000 2,000 601 49408 01 439.00 Other Miscellaneous Charges 0 0 0 100 1 0 Contingencies TOTAL-WELL#8 49,812 21,732 28,510 29,400 29,400 601 49409 01 221.00 Equipment Parts 2,569 0 0 1,500 1,500 6D1 49409 01 223.00 Building Repair Supplies 0 109 84 200 200 601 49409 D1 319.00 Other Professional Services 0 0 0 601 49409 01 381.00 Electric Utilities 31,854 25,109 32,519 32,OQ0 32,000 Pumping&Lighting 601 49409 01 383.40 Gas Utilities 901 627 614 1,500 1,500 Heat Only 601 49409 01 4 9.00 Other Contracted Repairs&Maint 335 1,838 275 2,000 2,000 601 494Q9 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49409 41 530.00 Improvements Other Than Bidgs o 0 0 D 0 TOTAL-WELL#9 35,659 27,683 33,493 37,300 37,300 Page Three 2018 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES- July 10,2017 2018 2a17 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49410 01 219.00 Other Operating Supplies 0 0 0 500 500 601 49410 01 221.00 Equipment Parts 0 5,710 364 1,000 1,D00 601 49410 01 223.00 Building Repair Supplies 15 D 0 200 200 601 49410 01 321.00 Telephone Costs 765 765 765 0 0 Removing Phone Line in 2013 601 49410 01 381.00 Electric Utilities 13,223 16,173 23,806 17,000 17,0 0 Pumping&Lighting 601 4941D 01 409.00 ther Contracted Repairs&Maint 1,748 690 6,474 2,0 0 2,000 601 49410 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49410 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 TOTAL-WELL#10 15,751 23,337 31,448 20,800 20,800 Rural Water System 601 49411 01 221.00 Equipment Parts 0 4 0 0 0 601 49411 01 439.00 dther Miscellaneous Charges 0 0 0 0 0 TOTAL-WELL#11 0 4 0 0 0 Rural Water System(#2) 601 49412 01 221.00 Equipment Parts 0 3,431 608 1,500 1,500 601 49412 1 223.0 Building Repair Supplies 0 0 0 2d0 200 601 49412 01 319.00 Other Professional Services 0 0 0 0 D 601 49412 01 381.00 Electric Utilities 21,69fi 21,159 16,765 28,000 28,000 Pumping&Lighting 601 49412 01 4 9.00 Other Contracted Repairs&Maint 8,317 15,891 275 2,000 2,000 601 49412 01 439.00 Other Miscellaneous Charges 0 0 13 100 100 Contingencies T TAL-WELL#12 3,013 40,480 17,661 31,800 31,860 601 49414 01 221.00 Equipment Parts 161 0 158 1,500 1,500 601 49414 01 223.00 Building Repair Supplies 408 0 0 200 260 601 49414 01 319.00 Other Professional Services 384 a 0 1,000 1,000 601 49414 01 381.00 Electric Utilities 23,382 26,674 26,254 28,000 28,D00 Pumping&Lighting 601 49414 01 409.00 ther Contracted Repairs&Maint 0 6,850 3,116 2,OOD 2,000 601 49414 1 439.00 Other Miscellaneous Charges 4 0 100 100 Contingencies TOTAL-WELL#14 24,335 33,525 29,527 32,800 32,800 601 49425 1 221.00 Equipment Parts 830 0 0 1,500 1,500 601 49425 01 223.00 Building Repair Supplies 0 0 0 200 200 601 49425 01 319.00 Other Professional Services 0 0 0 500 50d 601 49425 61 381.00 Electric Utilities 24,817 24,641 22,884 28,000 28,000 Pumping&Lighting 601 49425 01 409.00 Other Contracted Repairs&Maint 430 3,944 1,697 2,000 2,000 601 49425 01 439.00 Other Misceflaneous Charges 0 0 0 100 100 Contingencies TOTAL-WELL#15 26,077 28,585 24,581 32,300 32,3 0 601 49426 01 221.Oa Equipment Parts 0 0 0 1,500 1,500 601 49426 01 223.OD Building Repair Supplies 0 0 0 200 200 601 49426 01 319.00 Other Professional Services 0 0 0 500 500 601 49426 01 381.00 Electric Utilities 0 0 0 28,600 28,d00 Pumping&Lighting 601 49426 01 383.0 Gas Utilities 0 0 0 1,Q00 1,000 May Be Electric Only(TBD) 601 49426 01 409.Od Other Contracted Repairs&Maint 0 0 0 1,000 1,000 601 49426 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL-WELL#16 0 0 0 32,300 32,300 Page Four 2018 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES- July 10,2017 2a18 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49415 01 221.00 Equipment Parts 0 0 0 500 500 601 49415 01 319.00 Other Professional Services 3,675 0 0 0 0 601 49415 01 409.00 Other Contracted Repairs&Maint 1,d50 617 1,828 500 500 601 49415 01 439.00 Other Miscellaneous Charges 0 0 200 200 Contingencies TOTAL-WATER TOWER#1 4,725 617 1,828 1,200 1,200 Chippendale Water Tower} 601 49416 01 221.00 Equipment Parts 101 0 0 500 500 601 49416 01 319.00 Other Professional Services 0 3,500 0 0 0 601 49416 01 351.00 Electric Utilities 1,261 2,195 2,249 4,500 4,500 601 49416 01 409.0 Other Contracted Repairs&Maint 8,21 D 3,027 500 500 601 49416 01 439.00 Other Miscellaneous Charges 0 o 0 200 200 Contingencies TOTAL-WATER TOWER#2 9,572 8,722 2,249 5,700 5,700 Connemara Water Tower) 6o1 49417 o1 221.00 Equipment Parts 206 8 0 500 500 601 49417 01 319.00 Other Professional Services 0 3,500 0 0 0 601 49417 01 381.00 Electric Utilities 4,760 2,994 2,136 6,D00 6,000 601 49417 01 409.00 Other Contracted Repairs&Maint 14,700 6,105 0 500 500 601 49417 01 439.00 Other Miscellaneous Charges 0 156 0 200 200 Contingencies TOTAL-WATER TOWER#4 19,666 12,763 2,136 7,200 7,200 Bacardi Water Tower) 601 49418 01 221.00 Equipment Parts 0 24 0 500 500 601 49418 01 319.00 Other Professional Services 0 20,314 0 0 0 601 49418 01 381.00 Electric Utilities 2,768 2,154 3,181 4,d00 4,000 601 49418 01 409.00 Other Contracted Repairs&Maint 15,500 1,Q20 3,643 500 500 601 49418 01 439.00 Other Miscellaneous Charges 0 20 0 200 200 Contingencies TOTAL-WATER TOWER#3 18,268 23,532 6,824 5,200 5,200 East Side Water Tower) GRANDTOTAL-ALLDEPTS. $1,149,152 $1,392,963 $1,460,832 $1,653,400 2,363,500 Page One 2018 BUDGET WORKSHEETS SEWER UTILITY REVENUES- July 10,2017 2018 2017 Object 2018 2014 2d15 2Q16 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 602 33425.00 Qther State Grants&Aids 0 0 0 0 0 602 34108.00 Administrative Fees-Other Funds 3,931 6,828 8,168 0 6,300 5%of 5%Fees-Const Projects 6 2 36101.00 Principal-Special Assessments 81,278 78,480 140,976 85,000 85,000 602 36102.00 Penalties&Interest-S/A 1,366) (251) 442 0 0 602 3621Q.00 Interest Earnings-Investments 17,411 13,886 24,736 15,000 15,000 602 36214.00 Net Change in FV-Investments 8,534 (4,100) (11,576) 0 0 Annual Market Value Changes 602 36215.00 Interest Earnings 54 225 534 200 200 602 36260.00 Other Revenues 0 1,972 0 0 0 602 36265.00 Use of Reserve Funds 0 0 0 348,800 669,4D0 60237210.00 Residential5ewerRevenues 1,247,826 1,251,838 1,360,653 1,400,000 1,440,000 ___ 602 37220.00 Apartment 5ewer Re enues 111,519 117,405 139,095 125,000 125,000 602 37225.00 Institutional Sewer Revenues 24,128 21,813 24,272 25,000 25,000 602 37230.Oo Commercial Sewer Revenues 74,855 78,823 78,842 80,000 80,000 602 37240.Od Industrial Sewer Revenues 71,258 110,928 99,216 110,004 110,000 602 37260.40 Penalties-Sewer Revenues 12,104 13,051 13,090 13,000 13,004 602 39103.00 Gain or Loss from F/A Disposal 0 0 (249) 0 0 6D2 392D3.00 Transfer From 0 0 0 0 0 FUND TOTALS 1,651,532 $1,690,900 $1,878,199 $2,202,000 2,528,900 Page One 2018 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES- July 10,2017 2p18 2017 Object 2018 2014 2Q15 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 6d2 49450 101.40 Salaries&Benefits 516,600 Salary,Taxes,PERA&Benefits 602 49450 77 101.00 Administrative 117,386 139,515 153,926 172,300 169,300 602 49450 78 101.00 Technical/Clerical 151,671 151,279 158,777 159,800 167,200 2 Additional Finance Positions 6o2 49450 79 101.00 Maintenance 163,438 165,527 171,036 174,800 180,100 602 49450 xx 101.00 Salary&Benefit Contingency 0 0 0 0 0 602 49450 102.00 Full-Time Overtime 13,810 9,705 12,552 7,500 7,500 602 49450 103.00 Part-Time Salaries&Benefits 5,707 3,548 7,558 7,000 7,004 602 4945D 99 103.01 Utility Commission Wages(50%} 1,0 0 50%-602; 50%-601 602 49450 99 103.02 Maintenance Labor 6,000 100%-602 602 49450 01 203.00 Printed Forms&Paper 1,416 1,005 1,067 1,500 1,500 Inserts&Water Bill Statements 602 49450 01 205.00 Plotter Ink&Paper 0 0 0 0 400 602 4945D 01 209.00 ther Office Supplies 172 439 0 200 200 602 49454 01 212.00 Motor Fuels 0 0 0 5,200 5,100 3°/a Covered by Sewer Utility 602 49450 01 216.00 Chemicals&Chemical Products 0 731 0 500 S00 Root Killer,Degreaser 602 49450 01 219.00 Qther Operating Supplies 100 9 60 200 200 602 49450 01 224.00 Street Maintenance Materials 0 1,439 2,500 2,500 Patching 602 4945Q 01 225.00 Landscaping Materials 0 0 285 400 400 Topsoil,Seed&Sod 602 49454 01 227.00 Utility 5ystem Maintenance Supplie 797 1,378 5,454 5,000 5,000 MH Castings Replacement Prog. 602 49450 01 241.00 Small Tools 237 241 641 500 500 Wrenches,Shovels,etc. 602 49450 01 242.00 Minor Equipment 3,746 2,765 4,500 3,D00 3,000 602 49450 01 303.00 Engineering Fees 23,OD0 602 49450 01 303.01 GIS 4,607 3,413 1,920 3,000 3,000 602 49450 01 303.02 Rate Study 0 Q Q 15,000 15,000 Part of Comp Plan Update 602 49450 01 303.04 Miscellaneous 2,846 9,471 11,737 5,000 5,00 662 49450 01 3 4.00 Legal Fees 0 0 0 0 0 602 49450 01 312.00 Gopher State One-Call 2,770 1,655 1,602 2,500 2,500 $7,500 Split 3 Ways 602 49450 01 318.00 Contract Engineer 12,000 6,250 16,174 0 0 602 49450 01 319.00 Other Professional Services 60,000 602 49450 01 319.01 Televising 0 0 0 3,000 53,000 3-Year Citywide Televising Program 602 49450 01 319.02 Root Control 0 0 0 2,000 2,000 602 49450 01 319.03 Supervisory Controls(Maint Cont) 0 0 0 5,000 5,000 SCADA 5ystem 602 49450 01 319.04 Buxton Project 5,556 5,556 0 0 0 602 49450 01 320.00 Credit Card Activity Fees 5,372 6,797 6,097 7,000 7,400 1/3 Cost of C/C Pymt Processing 602 49450 01 321.00 Telephone Costs 3,001 3,122 3,376 3,500 3,500 Cell Phones,Modems,GPS 602 49450 01 322.00 Postage Costs 4,173 4,296 4,186 5,Q00 5,000 Billings with Inserts 602 49450 1 323.00 Radio Units 1,367 1,120 1,390 5,100 5,100 (24x$300){12x$15D0){Split 5 Ways) 602 49450 01 365.00 Workers Comp Insurance 7,117 8,361 1Q,071 7,o00 12,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 12,067 13,292 14,971 12,000 17,000 Sewer's Share of Premiums 602 49450 01 391.6 P.C.Maintenance 0 0 d 2,900 602 49450 01 391.Q1 U/B Software Maintenance 2,074 2,D74 2,117 2,2d0 2,200 Added to Utility Budgets in 2012 602 49450 01 391.02 Auto Read Software Support 578 595 613 70 700 Added to Utility Budgets in 2012 602 49450 01 392.00 P.C.Accessories&Supplies 0 0 a 2 0 240 602 49450 01 393.60 P.C.Hardware Purchases 1,600 9,199 1,306 2,000 2,000 602 4945 d1 394.00 P.C.Software Purchases 8,900 602 49450 01 394.o1 Licensing&Maintenance 4,371 4,591 4,629 15,Q40 8,400 E5R1,Cartegraph 602 49450 01 394.02 Online Subscriptions 379 379 0 800 300 Pictometry 602 49450 01 394.03 New Software Purchases 0 0 2Q0 200 602 49450 01 395.00 P.C.Repairs 0 0 0 500 500 602 49450 01 403.00 Contracted R&M-Other Impr 63 24,454 10,016 30,000 30,000 MH Castings Replacement Prog. 602 49450 01 415.00 Other Equipment Rental 0 0 0 200 200 6Q2 49450 01 416.00 Machinery Rental o 0 0 2,000 2,000 602 49450 01 433.00 Dues&Subscriptions 0 0 0 200 200 SUSA(AJ,Dick)50%Split w(Storm 602 49450 01 435.00 Books&Pamphlets 0 0 0 300 300 Reference Materials 602 4945Q 01 437.00 Conferences&Seminars 3,800 602 49450 01 437.01 MPCA Training(Sewer School) 669 600 686 1,500 2,000 perator Licensure$3Q0 each(M} 602 49450 d 437.03 CarteGraph,ESRI,GIS 126 0 81 1,300 800 User Group,Conference,Training 602 49450 01 437.4 Miscellaneous Training 0 814 919 1,000 1,00 602 49450 01 439.00 Other Miscellaneous Charges 145 258 86 300 300 Contingencies 602 49450 01 521.00 Building&Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W.Building(19 of 20) 602 49450 01 530.00 Improvements Other Than Bldgs 160,000 602 49450 01 530.01 Miscellaneous Improvements 0 0 Q 10,000 10,000 SCADA Reconfiguration,PCL's 6D2 49450 01 530.03 CRP of Sewermain 0 0 0 150,OQ0 150,000 PMP Sewer Imp.When Needed 602 49450 01 540.00 Heavy Machinery Purchases 189,190 63 0 D 0 Equipment Purchases-Match CIP 602 49450 01 550.00 Motor Vehicle Purchases 0 0 0 11,000 0 Equipment Purchases-Match CIP 602 49450 01 560.00 Furniture&Fixture Purchases 0 56 0 500 500 602 49450 01 570.00 Office Equipment Purchases 0 0 271 500 504 602 49450 01 580.00 Other Equipment Purchases 0 0 0 7,000 41,700 Trash Pump(Split with 601,603) Dump 5tation(Split with 603) PAGE TOTALS 718,548 583,995 608,102 862,904 949,500 Page Two 2015 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES- July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 602 49450 01 602.00 Sewer Service Charges 1,090,261 1,077,415 1,185,397 1,284,600 1,300,000 MWCC Chgs(Matches Rate Model) 602 49450 01 611.00 Interest on Lease Payments 2,165 1,773 1,362 0 0 P.W.Building Expansion(See 521) 602 4945D 01 710.00 Transfers 2,405 0 0 Transfers for Other Improvements 602-49450-01 TOTALS 1,813,379 1,663,183 1,794,861 2,147,500 2,249,500 602 49451 01 219.00 Other Operating Supplies 0 0 D 1 DO 1 DO 602 49451 01 221.00 Equipment Parts 0 0 3,248 800 800 602 49451 01 229.00 Other Maintenance Supplies 0 567 2D0 200 602 49451 01 303.00 Engineering Fees 0 0 0 0 0 6D2 49451 01 381.00 Electric Utilities 916 761 49 1,500 1,500 602 49451 01 403.00 Contracted R&M-Other Impr 775 704 1,931 2,040 2,000 602 49451 01 439.00 Other Miscellaneous Charges 0 0 D 100 100 Contingencies City Hall) TOTAL-LIFT STATIQN#1 1,691 2,032 5,227 4,70 4,700 602 49452 01 219.04 Other Operating Supplies 0 0 0 100 100 602 49452 01 221.00 Equipment Parts 0 0 585 800 800 602 49452 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49452 01 381.00 Electric Utilities 623 604 674 70a 700 602 49452 01 403.00 Contracted R&M-Other Impr 0 0 0 2,000 2,000 6D2 49452 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Bloomfield 5th) TOTAL-LIFT STATION#7 623 604 1,259 3,900 3,900 602 49453 01 219.00 Other Operating Supplies 0 0 0 100 1 0 602 49453 01 221.00 Equipment Parts 0 0 585 800 800 6D2 49453 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49453 01 381.00 Electric Utilities 3,548 3,728 4,165 4,000 4,000 602 49453 01 403.00 Contracted R&M-Other Impr 7,395 0 7,951 2,000 15,000 Safety Improvements in 2018 602 49453 01 439.00 Other Miscellaneous Charges 0 0 0 100 10Q Contingencies Shannon Pond) TOTAL-LIFT STATION#3 1 D,942 3,728 12,701 7,200 20,200 602 49454 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49454 01 221.00 Equipment Parts 6 0 585 800 800 602 49454 01 229.00 Other Maintenance Supplies 0 o 0 200 200 602 49454 01 381.00 Electric Utilities 4,821 5,539 6,110 6,000 6,000 602 49454 01 403.00 Contracted R&M-Other Impr 0 0 0 2,000 210,000 Update to 5ubmersible Pumps 602 49454 01 439.D0 Other Miscellaneous Charges 0 0 0 100 100 Contingencies HawkinsJ TOTAL-LIFT STATION#4 4,827 5,539 6,695 9,200 217,200 602 49455 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49455 01 221.00 Equipment Parts 1,8fl0 0 585 800 800 602 49455 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49455 01 303.00 Engineering Fees 0 0 0 0 0 602 49455 01 310.00 Testing Services 0 D 0 0 0 602 49455 01 381.00 Electric Utilities 5,802 4,979 5,081 6,000 6,Q00 602 49455 01 403.00 Contracted R&M-Other Impr 415 2,350 0 2,000 2,000 602 49455 01 439.00 Other Miscellaneous Charges 0 a 0 100 100 Contingencies LeForet Add'n} TOTAL-LIFT STATION#5 8,016 7,329 5,666 9,200 9,200 602 49456 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49456 01 221.00 Equipment Parts 0 585 800 800 602 49456 01 229.00 Other Maintenance Supplies 0 0 0 200 2D0 602 49456 01 381.00 Electric Utilities 8,270 3,945 3,829 6,d00 6,000 602 49456 01 403.00 Contracted R&M-Other Impr 0 0 0 2,000 2,000 _____ 6 2 49456 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Drumcliffe) TOTAL-LIFT STATION#6 8,270 3,945 4,414 9,200 9,200 Page Three 2018 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES- July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 602 49457 01 219.00 Other Operating Supplies 0 0 0 100 4,000 Bubbler in 2018 602 49457 01 221.OQ Equipment Parts D 0 585 500 500 602 49457 01 229.00 Other Maintenance Supplies 0 0 0 20 2 0 602 49457 01 381.00 Electric Utilities 857 216 688 1,200 1,200 602 49457 01 403.00 Contracted R&M-Other Impr 0 1,533 0 2,OQ0 2,060 6 2 49457 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Glendalough 5th) TOTAL-LIFT STATION#9 857 1,749 1,273 4,104 8,000 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49458 01 221.00 Equipment Parts 0 0 585 500 500 602 49458 01 229.00 Other Maintenance Supplies 0 0 D 200 200 602 49458 01 381.00 Electric Utilities 629 449 519 800 800 602 49458 01 403.00 Contracted R&M-Other Impr 0 539 0 2,OQ0 2,000 602 49458 01 439.00 Other Miscellaneous Charges 0 0 0 1 DO 1 DO Contingencies Meadows of)TOTAL-LIFT STATION#8 629 987 1,105 3,700 3,700 Bloomfield) 602 49460 01 219.00 Other Operating Supplies 0 0 0 100 100 602 4946Q 01 221.00 Equipment Parts 0 0 585 500 500 602 49460 01 229.00 Qther Maintenance Supplies 0 0 0 200 200 602 49460 01 381.00 Electric Utilities 261 233 257 400 400 6 2 49460 01 403.00 Contracted R&M-Other Impr 0 0 0 2,000 2,000 602 49460 1 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Glen Rose) TOTAL-LIFT STATION#10 261 233 843 3,300 3,300 GRAND TOTAL-ALL DEPTS. $1,849,496 $1,689,329 $1,834,044 $2,202,000 2,528,900 Page Qne 2018 BUDGET WORKSHEETS ST RM WATER UTILITY REVENUES- July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 603 33400.00 5tate Grants&Aids 0 0 0 0 0 603 33425.00 Other State Grants&Aids 0 0 0 0 603 33620.00 Other County Grants&Aids 19,680 0 0 0 0 603 34108.00 Administrative Fees-Other Funds 3,931 6,828 8,168 0 6,300 5°/o of 5%Fees-Const Projects 603 361b1.00 Principal-Special Assessments 25,726 21,967 46,930 22,000 22,000 603 36102.00 Penalties&Interest-S/A 362)57) 164 0 0 603 36210.00 Interest Earnings-In estments 37,889 34,724 55,670 25,000 25,000 603 36214.00 Net Change in FV-Investments 40,005 (8,127) (20,949) 0 0 Annual Market Value Changes 603 36215.OD Interest Earnings 47 213 513 200 200 603 36260.00 Other Revenues 35,615 0 0 0 0 603 36262.0 Special Settlements 24,797 0 0 0 0 603 36265.00 Use of Reserve Funds 0 D 0 17,200 0 03 37300.00 Storm Water Utility Revenues 1,040,839 1,102,373 1,158,950 1,215,000 1,260,000 4%Annual Rate Incr.(Rate Model) 603 37360.00 Penalties-Storm Water Utility 6,577 9,34 7,880 6,000 6,000 603 39103.00 Gain or Loss from F/A Disposai 0 0 (249) 0 603 39203.00 Transfer From 14,260 24,OOd 0 0 0 FUND TOTALS 1,249,004 $1,191,221 $1,257,077 $1,285,400 1,319,500 Page One 2018 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES- July 10,2017 2018 2017 Object 2018 2014 2015 2D16 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 603 49500 101.00 Salaries&Benefits 284,200 5alary,Taxes,PERA&Benefits 603 49500 77 101.00 Administrative 1o,932 26,693 47,765 79,5 0 82,300 603 49500 78 101.00 Technical/Clerical 85,598 85,202 78,418 87,000 93,300 2 Additional Finance Positions 603 4950D 79 101.00 Maintenance 81,718 82,763 85,519 109,900 108,600 603 49500 xx 101.00 Salary&Benefit Contingency D 0 0 0 0 603 49500 102.00 Full-Time Qvertime 6,918 4,928 6,300 6,000 6,004 603 49500 99 103.00 Part-Time Salaries&Benefits 4,323 6,506 7,672 8,000 8,000 603 49500 01 203.00 Printed Forms&Paper 1,416 1,045 1,067 1,500 1,500 603 495D0 01 205.00 Plotter Ink&Paper 0 0 0 0 400 603 49500 01 208.Q0 Miscellaneous Supplies 0 397 143 SOD 500 Stakes,Ribbons,Level,etc. 603 495D0 01 212.00 Motor Fuels 0 0 0 6,200 6,000 3%Covered by Storm Utility 603 49500 01 215.00 Shop Materials 0 0 0 0 0 603 49540 d1 219.Q0 Other Operating Supplies 0 0 0 0 0 603 49500 01 221.Q0 Equipment Parts 0 0 0 0 0 603 49560 01 224.00 Street Maintenance Materials 1,505 39 2,00o 2,000 Patching Material for Washouts 603 49500 Q1 225.d0 Landscaping Materials 2,000 603 49500 01 225.01 Rip-Rap,Matting,Rock,etc. 1,868 1,162 9,076 1,000 1,000 603 49560 01 225.02 Black Dirt,Seed,Sod,etc.150 0 5,376 1,000 1,000 603 495Q0 01 226.00 Sign Repair Materials 0 0 0 500 500 603 49500 01 230.00 Equipment Repair Material 1,018 482 3,489 1,000 1,000 603 49500 01 241.00 Small Tools 627 260 373 1,00 1,OOD 603 49500 01 242.00 Minor Equipment 1,567 943 5,687 2,000 2,000 Misc.Noules for Vac Truck 603 49500 01 303.OQ Engineering Fees 100,000 603 49500 01 303.01 Problem Area Investigations 0 0 0 5,000 5,000 603 49500 01 303.02 NPDES Phase II 68,996 75,829 48,942 32,000 32,000 603 49500 01 303.03 CSMP Update 2,535 25,026 5,055 50,000 50,000 Part of Comp Plan Update 603 49500 01 303.04 Miscellaneous 5,265 11,053 54,291 10,000 10,000 6 3 49500 01 303.05 GIS 3,071 2,276 1,280 3,000 3,000 603 49500 01 304.00 Legal Fees a 0 0 2,000 2,400 603 495D0 01 310.00 Testing Services 0 0 0 1,000 1,Q0 Water Quality Tests(M) 603 49500 D1 312.00 Gopher State One-Call 169 2,012 1,602 2,500 2,SD0 $7,500 Split 3 Ways 603 49500 01 315.00 Special Programs 4,815 3,850 6,031 S,OOQ 5,OQ0 WHEP 6o3 49500 01 318.00 Contract Engineer 12,0 0 6,250 16,174 0 0 603 49500 01 319.00 Other Professional Services 5,000 603 49500 01 319.01 SCADA 0 0 0 5,000 5,000 603 49500 01 319.02 Bu on Project 5,556 5,556 0 0 D 603 49500 01 320.00 Credit Card Activity Fees 5,372 6,797 6,097 7,000 7,000 1/3 Cost of C/C Pymt Processing 603 49500 01 321.0 Telephone Costs 3,OD2 3,122 3,376 3,500 3,500 Cell Phones,Modems,GPS 603 49500 01 322.00 Postage Costs 4,173 4,296 4,186 5,000 5,000 Billings&Info Mailings 603 49500 01 323.00 Radio Units 1,367 1,120 1,390 5,100 5,100 (24x$30D}(12x$1500)(Split 5 Ways) 603 49500 01 352.00 General Notices&Public Info 0 0 0 1,Od0 1,000 Public Info Brochure 603 49500 01 365.00 Workers Comp Insurance 2,992 3,541 4,624 3,500 6,000 Storm Water's Share of Premiums 603 49500 01 369.00 Other Insurance 1,316 1,203 1,506 4,000 2,500 Storm Water's Share of Premiums 603 49500 01 391.00 P.C.Maintenance 2,900 603 495 0 01 391.01 U/B 5oftware Maintenance 2,074 2,074 2,117 2,200 2,200 Added to Utility Budgets in 2012 603 49500 01 391.02 Auto Read Software Support 578 595 613 700 700 Added to Utility Budgets in 2012 603 49500 01 393.00 P.C.Hardware Purchases 1,604 9,199 1,306 2,OQ0 2,000 603 49500 01 394.00 P.C.Software Purchases 8,900 603 49500 01 394.01 Licensing&Maintenance 4,371 4,591 4,628 15,000 8,400 ESRI,Cartegraph 603 49500 01 394.02 Online Subscriptions 379 379 0 800 300 Pictometry 603 49500 01 394.03 New Software Purchases 0 0 0 20D 2D0 603 49500 01 4 3.00 Contracted R&M-Other Impr 68,OD0 603 49500 01 403.D1 Ditching 8,344 Q 0 8,000 8,OQ0 603 49500 01 403.02 Miscellaneous Repairs 117,136 20,634 62,221 60,000 60,060 Catch Basins,Manholes,Etc. 6Q3 49500 01 403.03 Pond Inspection&Maintenance 0 0 20,000 0 0 643 49500 01 405.00 MS4 Permit Compliance 170,000 643 49500 01 405.01 Engineering Fees 0 0 0 45,000 45,000 Inspection,GIS,Guidance,Etc. 603 49500 01 405.02 Equipment Rental 0 0 0 20,000 20,OOQ Bulldozer,Large Equipment 603 49500 01 405.03 irt,Seed,Rip Rap,Etc. 0 0 0 5,000 5,00 For Restoration 603 49500 01 405.04 Contracted Maintenance 0 0 D 100,00 100,000 Brush Clearing,redging 603 49500 01 416.00 Machinery Rental 0 0 11,359 2,500 2,500 Pumps 603 49500 01 433.Od Dues&Subscriptions 140 140 280 200 200 SUSA(AJ,Dick)5d%Split w/Storm 603 49500 01 435.00 Books&Pamphlets D 73 D 500 500 Utility Information 603 49500 01 437.00 Conferences&Seminars 3,000 603 49500 01 437.01 Storm Water Management 0 0 0 1,200 1,200 Stormwater Collab,Flygt Training 603 495 0 01 437.04 Cartegraph,ESRI,GIS 126 0 81 1,300 800 User Group,Conference,Training 603 49500 01 437.05 Miscellaneous Training 0 165 864 1,000 1,000 603 49500 01 439.00 Other Miscellaneous Charges 145 265 159 300 300 PAGE TOTALS 453,160 400,426 509,066 717,600 719,000 Page Two 2018 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES- July 1a,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 603 49500 01 530.00 Improvements Other Than Bldgs 350,000 603 495 0 01 530.01 CRP of Storm Sewer 0 7,800 4,982 150,000 350,Oaa 300K for CSAH 38 Improvements 603 49500 01 530.02 Stvrmwater System Improvements 0 0 0 206,300 0 6Q3 49500 01 540.00 Heavy Machinery Purchases 0 0 D 99,000 50,000 Skid Loader($15K from Equip.CIP) 603 49500 01 550.00 Motor Vehicle Purchases 0 0 0 10,00 0 Equipment Purchases-Match CIP 603 49540 01 560.0 Furniture&Fixture Purchases 189,190 0 0 500 500 603 49500 01 580.00 Other Equipment Purchases 0 63 1,690 48,000 41,700 Trash Pump(Split with 601,6D2) 603 49500 01 586.00 Computer Equipment Purchases 0 0 0 500 500 ^^Dump Station(Split with 602) 603 49500 01 710.00 Transfers 0 603 49500 01 710.o6 1/2 of 2018 P&I Payments(2010A} 87,000 51,000 50,000 32,000 0 Refunding Issue 12/10 603 49500 01 710.10 Projects 123,395 384,695 537,101 0 0 No Transfer Needed for 2018^^ 603-49500-01 TOTALS 852,746 843,983 1,102,839 1,263,900 1,161,700 603 49511 01 221.00 Equipment Parts D D 0 500 500 6a3 4951 1 41 381.00 Electric Utilities 360 277 291 500 500 643 49511 41 403.40 Contracted Repair&Maintenance 278 1,455 0 1,400 1,000 Copper Pond)TOTAL-LIFT STATION#1 638 1,732 291 2,000 2,OOQ 603 49512 01 221.00 Equipment Parts 0 0 0 500 500 603 49512 Q1 381.40 Electric Utilities 0 0 0 500 500 603 49512 01 403.00 Contracted Repair&Maintenance 0 1,897 0 1,000 1,000 Schwarz Pond) TOTAL-LIFT STATION#2 0 1,897 0 2,000 2,000 603 49513 01 221.00 Equipment Parts 0 0 0 500 500 603 49513 01 381.OD Electric Utilities 5,552 4,157 7,106 6,000 7,200 603 49513 01 403.00 Contracted Repair&Maintenance 0 1,455 0 1,000 1,000 Birger Pond) T TAL-LIFT STATION#3 5,552 5,612 7,106 7,500 8,700 603 49514 01 221.00 Equipment Parts 0 0 0 500 500 603 49514 01 381.00 Electric Utilities 2,67 986 957 2,500 2,500 603 49514 01 403.00 Contracted Repair&Maintenance 103 1,765 0 1,000 1,000 Marcotte Pond) TOTAL-LIFT STATION#4 2,170 2,751 957 4,000 4,000 603 49515 01 221.00 Equipment Parts 0 0 0 500 500 603 49515 01 381.00 Electric Utilities 0 0 0 500 500 fiO3 49515 01 403.00 Contracted Repair&Maintenance 0 1,455 0 1,000 1,000 Hawkins Pond) TOTAL-LIFT STATION#5 0 1,455 0 2,000 2,000 603 49516 01 221.00 Equipment Parts 0 0 0 500 500 603 49516 01 381.00 Electric Utilities 473 352 388 500 500 603 49516 01 403.00 Contracted Repair&Maintenance 145 1,455 0 1,000 1,000 _ Glendalough 7th) TOTAL-LIFT STATION#6 618 1,807 388 2,000 2,000 603 49517 01 221.00 Equipment Parts 0 0 0 500 500 603 49517 01 381.00 Electric Utilities 0 0 635 500 500 603 49517 1 403.00 Contracted Repair&Maintenance 0 0 0 1,004 1,000 Horseshoe Lake) TOTAL-LIFT STATION#7 0 0 635 2,000 2,000 GRANDTOTAL-ALLDEPTS.861,724 $859,238 $1,112,216 $1,285,400 1,184,4Q0 Page One 2018 BUDGET WORKSHEETS ARENA-REVENUES July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 650 36210.00 Interest Earnings-Investments 399 $628 $374 0 0 650 36215.bQ Interest Earnings 54 70 514 100 100 650 36230.00 Contributions/Donations 0 0 0 0 b 650 36260.00 ther Revenue-Learn to Skate 38,362 4Q,189 34,838 40,000 40,Q00 Learn to Skate Program(LTS) 650 36265.66 Use of Reserve Funds 0 0 D 48,000 0 650 38060.00 Prime Time Ice Fees 254,671 259,730 273,274 257,000 270,000 650 38061.00 Non-Prime Time Ice Fees 61,953 71,309 93,809 95,000 95,00 650 38063.00 Open Skating Ice Fees 6,425 6,316 7,475 6,500 7,500 650 38065.00 Other Events-Arena 0 0 0 0 Dry Floor Events 650 38066.OD Advertising Revenue-Arena 12,250 6,500 12,425 13,000 13,000 650 38067.00 Skate Sharpening Revenue-Arena 7,085 5,330 2,225 7,000 3,500 650 38090.00 Concessions 4,550 4,100 1,500 2,000 1,500 650 38091.00 Vending Machine Revenues 4,518 13,890 3,274 10,000 3,000 650 38095.00 Pro Shop Revenues 950 1,510 1,282 1,500 1,500 Tape,Laces,Mouthguards,etc. 650 39103.00 Gain or Loss from F/A Disposal 1,867 0 0 0 0 650 39201.00 Transfer From General Fund 115,000 130,00 13d,000 130,000 130,000 Subsidy for Operations FUND TOTALS 508,084 539,572 560,991 610,100 565,100 Page One 2018 BUDGET WORKSHEETS ARENA-EXPENDITURES July 10,2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 650 45130 101.00 Salaries&Benefits 186,000 Salary,Taxes,PERA&Benefits 650 45130 77 101.00 Administrative 39,514 49,113 63,509 45,500 46,900 650 45130 78 101.00 Technical/Clericai 39,299 39,663 40,637 42,700 47,900 2 Additional Finance Positions 650 45130 79 101.00 Maintenance 77,378 74,d20 80,799 92,600 91,200 650 45130 oc 101.00 Salary&Benefit Contingency 0 0 D 0 0 650 45130 79 102.00 Full-Time Overtime 1,471 525 1,435 2,000 2,000 650 45130 103.00 Part-Time Salaries&Benefits 44,000 650 45130 89 103.00 Learn-To-Skate Program 19,779 21,035 22,551 19,000 19,00 650 45130 99 103.00 Building Attendants 25,692 28,929 23,647 23,oao 25,000 And Other P!T Positions 650 45130 01 207.00 Training&Instructional Supplies 0 0 0 100 100 650 45130 01 208.00 Miscellaneous Supplies 700 650 45130 01 208.01 Skate Magnets 0 0 0 100 1 d0 650 45130 01 208.02 Other Supplies 290 a 258 600 600 650 45130 01 209.00 Other Office Supplies 135 605 0 50D 500 Learn to Skate Program Supplies 650 45130 01 211.00 Cleaning Supplies 3,488 3,965 3,453 4,000 3,000 650 45130 01 212.00 Motor Fuels 0 0 0 0 0 Zamboni Maintenance 650 45130 01 216.00 Chemicals&Chemical Products 7,848 8,083 9,562 7,500 10,000 Cooling Tower 650 45130 01 219.00 Other Operating Supplies 489 148 835 500 500 Events Supplies 650 45130 01 221.00 Equipment Parts 4,704 8,794 8,147 8,000 8,000 650 45130 01 223.00 Building Repair Supplies 3,903 2,499 4,151 3,5D0 3,500 650 45130 01 265.00 Other Items for Resale 1,075 1,006 485 600 1,000 Pro Shop 5upplies 650 45130 01 305.00 Medical&Denta)Fees 0 0 0 0 0 650 45130 01 311.00 Officiating Fees 0 0 0 0 0 650 45130 01 317.00 General Fund Admin Fees 6,000 6,000 6,000 6,000 6,000 Yearly Fee Per Admin Fee Policy 650 45130 01 321.00 Telephone Costs 1,183 1,000 1,OD0 1,300 1,300 650 45130 01 331.00 Travel Expense 0 0 0 100 100 650 45130 01 341.00 Employment Advertising 0 0 0 0 0 650 45130 01 349.00 OtherAdvertising 855 1,077 2,580 200 200 650 45130 01 365.00 Workers Comp Insurance 3,257 3,697 4,370 3,500 3,500 650 45130 01 369.00 Other Insurance 3,803 3,715 4,073 8,000 4,500 650 45130 01 381.00 Electric Utilities 123,636 118,354 129,562 125,000 125,000 650 45130 01 3$3.00 Gas Utilities 32,808 21,845 17,855 25,000 25,000 650 45130 01 384.00 Refuse Disposal 2,833 2,833 2,833 3,OOD 3,000 650 45130 01 401.00 Contracted Building Repairs 9,490 11,375 8,365 10,000 10,000 650 45130 01 404.00 Contracted Mach&Equip Repairs 25,257 28,175 21,572 25,000 25,000 650 45130 01 415.00 Other Equipment Rental 0 225 0 300 300 650 45130 01 433.00 Dues&Subscriptions 770 770 425 1,000 1,000 MIAMA&MRPA Ques 650 45130 01 437.00 Conferences&Seminars 406 2,415 1,782 4,000 3,000 MIAMA&MRPA Seminars 650 45130 01 439.oD Other Miscellaneous Charges 0 0 0 0 0 Contingencies 650 45130 01 521.00 Building&Structure Purchases 913 0 0 30,000 65,000 Condenser/Cooling Tower t 650 45130 01 580.00 Other Equipment Purchases 14,005 0 25,0 0 108,000 0 650 45130 01 581.00 ther Equipment Purchases 0 0 0 6,000 0 650 45130 01 710.00 Transfers 3,500 650 45130 a1 710.01 Yearly Maintenance 3,500 3,500 3,500 3,500 3,500 650 45130 01 710.02 0 0 0 0 0 650 45130 01 710.03 0 p 0 0 0 FUND TOTALS 453,780 443,367 488,418 610,100 535,760