Loading...
HomeMy WebLinkAbout2.a. 2017 Draft BudgetEXECUTIVE SUMMARY City Council Work Session: July 11, 2016 AGENDA ITEM: 2017 Draft Budget AGENDA SECTION: Discussion PREPARED BY: Dwight Johnson, City Administrator AGENDA NO. 2.. ATTACHMENTS: Draft 2017 Budget APPROVED BY: ddj RECOMMENDED ACTION: Discussion only BACKGROUND Attached is the first draft of the 2017 budget. The focus at this time is on the operating budgets; recommendations on the City’s Capital Budgets will be forthcoming later this year. Department Directors proposed budgets for next year. Jeff May and I met with each department at least once and adjustments were made both up and down in the proposed budgets. The result of this first draft is a proposed increase in the property tax levy of 3.45%. The current projected increase for the median value home is $25 per year. The total projected City tax for the median value home is $994 which compares with $1,058 on the median home in 2008. DISCUSSION Revenues Licenses and Permits are projected to increase by $84,100 over the 2016 budgeted amount, an increase of 13.75%. This is mainly due to building permit activity being stronger than budgeted for both 2015 and for the first six months of 2016. The budget also is showing an additional $100,000 of SKB funds being allocated to the General Fund compared with 2016 to help restore the historical balance of distribution of SKB funds between capital projects and operating budgets. The City’s tax base (tax capacity value) is increasing by 5.79% for 2017 while the overall taxable market value is increasing by 6.19%. This is the second highest increase in the County, but somewhat less than last year’s tax capacity increase of 7.00%. Expenditures A new police sergeant position is proposed. The net cost for 2017 is $75,400 because either a grant will help pay for the position for the first three years or we will not start the position before July 1, 2017 if the grant is not approved. Crime has increased, response times have increased, committed time percentages are up, and clearance rates for crimes are down. The police sergeant position will help eliminate unsupervised shifts, reduce our committed time below the desired 60% level to allow for more community policing, and will help the overburdened investigative division by not borrowing the Investigative Sergeant for patrol purposes so often. We will have a short presentation on this proposal. 2 A new parks maintenance position is proposed at a net cost of $21,000 for 2017. This position will reduce the reliance on outside contracting, reduce part-time salaries activities, and is projected to help reduce overtime costs. We have added park facilities at Flint Hills Fields, UMore park field, Ailesbury Park and the Splash Pad in recent years without adding to our permanent parks maintenance staff and new parks at Greystone and Bella Vista are moving forward. The position will also provide some MS4-related pond maintenance. An assistant city engineer position is also proposed at no net cost to the budget since this position would replace a currently contracted position. A new intern is proposed in the Finance Department at a cost of $12,000 to help meet increased demands for IT service throughout all City departments. The amount of tax levy money designated for the Equipment CIP and Street CIP fund is proposed to increase by $20,000 and $31,400 respectively to meet both short term and long term needs in our updated 10 year projections. The Insurance Fund is showing an increase in levy of $15,000. We self-insure up to $200,000 per year and our reserve funds for this purpose have started trending downward. Spending has also been reduced downward for the past three budget cycles by $50,000 per year as we gradually have incorporated the benefits of the broadened sales tax exemption adopted by the Legislature several years ago. The 2017 budget no longer includes a $50,000 reduction for this purpose. The charge for the Dakota Communications Center (911 center) is up $29,700 partly because calls have increased significantly in Rosemount. The allocation of the DCC budget among the area cities is based on a three year average of calls. RECOMMENDATION The Council should direct staff on additional questions to be answered or researched and provide general guidance on the direction of the budget. We should also establish a time for the next budget work session, since neither Jeff May nor Councilmember Nelson will be available on August 8th, the next regular work session date. FUNDING REQUIREMENTS-USES July 11,2016 2016 2017 Adopted Proposed Departments Budget Budget Difference Percentage Council Budget 281,628 $287,400 $5,772 2.05% Sales Tax Exemption Savings 50,000) 0 $50,000 n/ a Administration Budget 610,100 674,200 64,100 10.51% Elections Budget 48,200 20,000 (28,200) -58.51% Finance Budget 507,800 529,400 21,600 4.25% General Government Budget 326,800 323,300 3,500) -1.07% Community Development Budget 1,005,600 1,057,600 52,000 5.17% Police Budget 3,689,800 3,947,300 257,500 6.98% Fire Budget 366,400 379,000 12,600 3.44% Public Works Operating Budgets: Government Buildings Budget 542,100 573,900 31,800 5.87% Fleet Maintenance Budget 683,500 653,500 (30,000) -4.39% Street Maintenance Budget 1,345,200 1,424,500 79,300 5.90% Parks Maintenance Budget 921,200 941,600 20,400 2.21% Park&Rec Budget- General Operating 1,249,400 1,290,100 40,700 3.26% Park& Rec Budget-Steeple Ctr.Operations 93,400 111,400 18,000 19.27°/a Park&Rec Budget-Special Programs 84,400 91,800 7,400 8.77% Transfers-Arena Assistance 130,000 130,000 0 0.00% Total Operating Budgets-General Fund $11,835,528 572,435,000 $599,472 5.07% Building CIP Requirements 24,000 24,000 0 0.00% Street CIP Requirements 780,000 811,400 31,400 4.03% Equipment CIP Requirements 560,000 580,000 20,000 3.57% Insurance Budget Requirements 245,000 260,000 15,000 6.12% Port Authority Operating Levy 58,000 58,000 0 0.00% Bonded Indebtedness 347,874 346,058 1,816) -0.52% Water Enterprise Fund 1,579,700 1,656,800 77,100 4.88% Sewer Enterprise Fund 2,060,600 2,135,800 75,200 3.65% Storm Water Enterprise Fund 743,000 1,247,000 504,000 67.83% Arena Enterprise Fund 594,700 611,100 16,400 2.76% Total Funding Requirements 18,828,402 $20,165, 158 $1,336,756 7.10% 1 FUNDING REQUIREMENTS-SOURCES July 11,2016 2016 2017 Adopted Proposed Types Budget Budget Difference Percentage Internal Revenue Generated: Licenses and Permits 611,800 695,900 84,100 13.75% Intergovernmental 679,400 760,600 81,200 11.95% Charges for Services 958,800 1,123,800 165,000 17.21% Fines& Forfeits 120,000 120,000 0 0.00% Recreational Fees 226,800 242,100 15,300 6.75% Miscellaneous Revenues 210,800 148,500 (62,300) -29.55% Transfers In 3,500 3,500 0 0.00% Enterprise Revenues 4,978,000 5,650,700 672,700 13.51% Total Internal Revenues 7,789,100 8,745,100 956,000 12.27% Levy Sources: Special Levies 347,874 346,058 1,816) -0.52% General Levy 10,691,428 11,074,000 382,572 3.58% Totai Levy 11,039,302 $11,420,058 $380,756 3.45% Total Revenue Sources 18,828,402 $20,165,158 $1,336,756 7.10% 2 2016 GENERAL PROPERTY TAX LEVY PAYABLE 2017 GENERALLEVY GENERAL FUND 9,340,600 BUILDING CIP FUND 24,000 STREET CIP FUND 811,400 EQUIPMENT CIP FUND 580,000 INSURANCE FUND 260,000 PORT AUTHORITY OPERATING LEVY 58,000 TOTAL GENERAL LEVY 11,074,000 BONDEDINDEBTEDNESS G. O. PUBLIC FACILITY REFUNDING BONDS 2010B (Old 2001C) (Port Authority) (Authorized-$166,061) 166,061 G.O. IMPROVEMENT BONDS 2013A(Authorized-$8,467) p G.O. IMPROVEMENT BONDS 2014A(Authorized-$1,233) p G.O. CAPITAL IMPROVEMENT PLAN (CIP) REFUNDING BONDS 2015B (Authorized-$179,997) 179,997 TOTAL BONDED INDEBTEDNESS 346,058 GRAND TOTAL 2015 PROPERTY TAX LEVY 11,420,058 Last Updated 7/6/16 3 SPREAD LEW COMPUTATIONAL WORKSHEET INCLUDING FIRE STATION LEVY) Proposed) 2014 2015 2016 2017 Total Funding Requirements 17,575,222 18,237,547 18,828,402 20,165,158 Less: Internal Revenues 6,953,800 7,409,800 7,789,100 8,745,100 Equals: Revenues Needed 10,621,422 10,827,747 11,039,302 11,420,058 County Auditor Adjustments(All Subtractions): Fiscal Disparities Distribution Levy(Metro Area) 1,208,535 1,172,199 1,121,469 1,100,000 (2) Spread Levy Used to Compute Local Tax Rate 9,412,887 (1) 9,655,548 (1) 9,917,833 (1) 10,320,058 Increase/(Decrease)from Previous Year in Spread Levy 2.58% 2.72% 4.06% 1) Actual Spread Levy Based on Numbers from Dakota County 2) 2017 Number Provided by Dakota County as of x/xx/16 Last Updated-7/6/16 4 d oN v o 3 vN v oN m O y e ° 1 O ° x x y a m O, Z° y^ o ° 1 ° x x y v C a v#— 3pi()() m m 3olnnn n m a °# N(( m °# m 4 C7( nn a o n i o ° cF nrn c aa C 01 m v =° c " m i° c Zva 0 0 0' m o O i o p t ia o m w d v ° c = m fD° Q oii ° c ^ O 2' ^. c d ° c ^ m D° Z m c° 3^ fD 7 . w a D ? m' 1D m O A m D ? m O ? m O F Z m i xl!: m y " A: c m d 7 m m a'i N 3 TI m o w W d . ZI A ui A 0.. ZI N n N N A N f N, A N m A ry N , am n y AaN a 3 3 3 3 ii ii i ' i o 0 0 li ii j o 0 0 i I j j ii ' o0o i ' j0000 jo i o0o u 0000 j II ' I W i ' O N O II W i N W N p N W II N i N I O N O II W i N W Ntp j N I II A i OG N i OU O fJ O N O II O i O N OI > i N II pI i N + A Of t0 N 0 11 O i O N OI O i N I il A ' N A ' ! O N T O A O 11 W W I W N L 1 1 II V ' Q + j W V O N O A O II O I ( J j w . tl i A i 11 O O O W-+ O A O A O II O W W W II OI O 01 O O Of V A O A O II tp W V I II II II i I jj II I O O O i i i O O O II 000 II -' 000 O N W W II O 00 II ' 00 O N I N N I A W - O N O II O i O IJ N A W ' I p A II N i N O O O II O i O N N A ' O 01 O II ( n A Ol W ; p II O N O II N p pp j N ' d II A i t0 > i OG t0 A II O W tl A i O N II pf ( n p A( J 0 O Ol O 11 O N O i m i t0 W IIN A m ' ! W W Ol O O O II t0 ! J a a ; O OI II OI ' t0 W I O O OU 0 O t0 O 11 10 I V A > i N W U O ln O O A V A fl O O II t0 tJ V O O W O O II t0 O l0 O O A 00 N W O O II tp W V O{ O I O m II I II ' C 11 11 II II I O O O i j j d II I i O O O I N i I I O O O I I j O O O O ry 11 I O O O I I j O O O O d p II A ' W i O ONI O O ( n A W Gf fil I a 11 N N O N O II O i ( pli A N fil j Z II tWO ' > A ' V W m UAi O 10 O II 0 1 I m V+ A • N• I l I > ' ( NO A ' O tA0 m O 1 0 O I O i I Ol V A Np f I I O O N O N L V A O 0 I I O l W V O W W 3 I V O l0 O W A Ul N N II Of W V O Ol V ~ N 2 3 m am O II ii O O o i j I il I li c^ N ii ii u o 0 o i v o 2 a Q^ y n o 0 0 ' o 0 0 0 7 N ; o 0 o ii - o 0 0 0 ' N m v v N II II ? O N O O ' O N N p A d V N N O O O I O ' O N Ntp A T iN ()( Z N T 11 ( II O N i N tp IJ W 0 p II O i O N 0I ' N II ( p i pl W i + tP m O O A O II O i O N O1 N T T ? y ^ O p 11 N 11 ( n 01 O O) N T II W W J W 4 A II N ' N T il pl W J W N A j C ?. G - 1 m II W II O N O 0 Oo W J t0 O L O 11 t0 W W N O i II V O N O( T W W t J> O> O I t 0 W' W N W 3 .• jl c x v u u u u u m a o u u ii 1 I ii A o v m. ii ii I o00 I o00 i mm II O O O II ' O O O O I N I A A II O O O Ij -' O O O O N I N N n O% d II N II A i "` O N O 0 I N N N A y p A II N N O O O 1 O O N N A A N N 3 p J n ' II W II + I N O J O O II p W I II I O N O II ( n A W W N O A C D T N 11 O fli O O II { p p IJ I - N 1p O O 11 O O W N N i IJ N •- p C r' II O II pp ' O OU W O b O II O pt V A > i O O 11 A I i A N OI O O 11 p i O1 J A A I O V N Z 6 A p T - II W II O Ql O U O V W Ol 0 p II fp W J O t0 O O O II t0 O W O O A OI ID 11 tp W V O t0 Q' O OD a j T I I I I I I G 11 11 I V G K O 4... N N p 11 II O O O N I W 11 i II N i N N m I I I I O O O O 3 fn p 9 N C II 11 1 I I I O O O I O O O O o j K T N II N II O 00 II O ' ON N A i V i II i 000 II ' I 0000 i v Q p G Q j N II II A i O N O 11 O Upf A 00 A m D N N O N O O O N N A N D D y m Q n N W N II II J.. A ' O OU A O O II O I i Oj ll N i 11 W ' 01 N Ui A fD O t 0 O II O pN W N N ! m 3 D p Z 71 O O 10 O J A . II p d A 1 A A I p Ol V+ A i '"' N O N 1 I 3 C N d < II O II O 00 O W O V W L Q II OI i W V O OI O 3 II Ol O W O I A Ol N W 0 p II 01 J O O1 Ol i 6 y O ON 3 PT( II a L H m n K p d O O r9c Tf ^ J m ii ' u i ii i 1 r. im mz L` m d T 000 I I 11 I V' 1 O ^ O O X O O O II O O O O i j II i O O O II j O O O O v N Z T d II O N W A II O O O II O O N N A ' I d C 1 OI j N n N C ONO II A ' NAAt p ' N II O I W A N Ol O II O I ON` 8i w i "' i a 3 iD p j p 9 fNll W O II N i Of A N f0 11 J ' W W A t0 01 O A O II 00 ' W W( T OI P C o II N N O 01 A II N O N O W I t0 N p O1 O A O II t0 W W N O I y N p O C W I II i m A y — v o0o I t ii o00 I a y p j — Q O O O jl O O O O i j II O O O II ' O O O O I N N N N n O O O II O N W A 2 II O O O II O ' O N N A N W 0 3 ? O N O II pl ( P V W Ou W I II W N i O N O II p(P A OD W N O OI 3 N S N O N O il N ' 0 0 N N 11 W W i + J V O O 11 t 0 m N m I V O O i r d O O N O N O I W A OI N II W O V O 01 tp A A Gn O O 11 10 W J O tAp O O W T W N m 6 ii i I C o ON o00 1 ii ' o00 j m m N ry O j O O O II O O O O i 0 W II O O O 11 j O O O O jp V p n 69 O NO j N I V V A n II W i N i ONO II O f l A ONGN N ' m i n I O m A II O Of N T t0 O Ol O fil n O II p N V O ' + O N O II O i I O V N a i N 3 N O l 0 O II V OU Of I W i d II D O I O N ( p A A A O W O II W O OI O a o y o Z aa m I Am I 3 N V A d II li 6 O O O O O O II i i _ n A V V N y O O O O I I ' O O O O N C I I i O O O I I O O O O I n 1 I 7 W I V V W D O UNi O II W I f l W Ntp I ' II W I N I O N O II W f l W tN0 tAJ N O V I I OG N 00 J 4 N O I O i O N 01 I V i tp + OI t O U O p I O N+ W N I v W O O W fT O O O II W I W J W( n II N ' 01 On I > fl O O> O I W I W V W t0 I I A v J m A p e e O d O II ( O W- W N y 11 N O N O V Of L( p GO O A O I lp W W N 00 j 0 U II II i jj i I X % d O O O e O O O O O II O O O O , N p j O O O i N I I O O O II O O O O W N 0 0 N II O O N N A ' II O O O II O ' O N N A ' o N O O O I i N A tll W I m i d W ' N ' J O m O II i N w Oo W N OI O I D N O I O ppf j( n+ II V I OU tp i J W IJ II O ( n W O V A N R o O O O II tp W V O ta0 N II tw0 O O O N V f T OND O O O II ( p V O m i O O D ii m, m a. ii N ii ii I m o00 i w j I u I o0o ii i w 0 o p p y o 0 0 o 0 0 0 i o 0 o i ; o 0 0 0 ' ' m T T N j`< N O m O II O N A W N xp TI II W I N I O N O II O UOpi A m N N m D O i O W N 16 in II V i 0 O i V W N 0 0 II O j N W i H i J J U O O f0 O II Of T+ I O ' O ' A O O lD O ; I 01 T V t0 N o o O m O II W V O OI i I O O O O O V( T W O O O I m W J O W OD 2 00 o C) C7 m N O rn rnm 3 N wN y d j 2 N N N A 3 1D v i m I I a A M O i b O O IJ M f p tD V U > O A 5 Page One 2017 BUDGET WORKSHEETS GENERALFUND REVENUES July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Adual Actual Actual Budget Amount Budget 101 31010.00 Current Ad Valorem Taxes 7,160,549 $7,437,178 $7,615,397 $7,902,959 8,240,600 From County 101 31040.00 Fiscal Disparities 1,235,453 1,208,535 1,172,199 1,121,469 1,100,000 From County Total Taxes(Tax) 8,396,002 8,645,713 8,787,596 9,024,428 9,340,600 Total Property Tax Levy for Fund 101 101 32110.00 Alcoholic Beverage Licenses(L) 37,900 36,695 42,080 38,000 40,000 101 32160.00 Licenses to do Business(L) 7,440 7,990 8,410 8,000 8,500 Garbage Haulers,Ped Licenses,etc. 101 32162.00 Lic to do Business-Rental Housing(L) 5,775 12,500 4,025 12,000 5,000 101 32180.00 Tobacco Licenses(L)0 0 5,500 7,000 7,000 New Requirment Beginning in 2016 101 32210.00 Building Permit Revenue(L) 345,004 515,616 453,003 425,000 480,000 101 32212.00 Mineral Extraction Permit(L) 1,490 1,860 2,600 1,200 1,500 101 32220.00 Electrical Permit Revenue(L) 19,565 20,222 23,535 15,000 20,000 101 32221.00 Admin Fee-Electrical Permits(L) 7,260 8,048 6,742 7,000 7,000 101 32230.00 Plumbing Permit Revenue(L) 35,205 47,318 62,316 37,000 50,000 101 32240.00 Animal Licenses(L) 1,604 1,741 1,791 2,000 1,800 101 32250.00 Sewer Permit Revenue(L)9,994 9,675 11,315 9,000 9,000 101 32255.00 County Recording Fee-City's(L) 130 120 160 100 100 101 32260.00 HVAC Permit Revenue(L) 50,375 68,600 71,267 50,000 65,000 101 32290.00 Other Non-Bus Lic&Permits(L) 390 380 2,020 500 1,000 Alarm Permits 8 Fireworks Permits Total Licenses 8 Permits(L) 522,131 730,765 694,765 611,800 695, 900 101 31010.00 Current Ad Valorem Taxes(I) 86,000 0 0 0 0 Included in Debt Levy Figure 101 31010.01 MSABC Armory Payments 0 Will Use Reserves Thru Final Pymt 101 31020.00 Delinquent Ad Valorem Taxes(I) 113,915 113,740 58,970 0 0 From County 101 31030.00 Mobile Home Taxes(I) 10,241 12,257 6,316 12,000 7,000 From County 101 31710.00 Gravel Taxes(I)19,467 39,275 83,275 100,000 100,000 From County 101 31810.00 Franchise Taxes-Regular Fees(I) 216,687 227,039 227,388 225,000 227,000 From Cable Company 101 31811.00 Franchise Taxes-PEG Fees(I) 22,911 22,111 21,627 23,000 22,000 From Cable Company 101 31920.00 Forfeited Tax Sale Apportionment(I) 0 0 0 0 0 From County 101 33100.00 Federal Grants 8 Aids(I) 0 0 96, 190 0 50,000 Cops Grant 101 33416.00 Police Training Reimbursement(I)160, 129 160,347 177,808 172,500 From State 101 33416.01 Post Board Training Reimb 7,000 7,000 101 33416.02 State Aid(Tied to PERA) 152,500 165, 500 101 33418.00 MSA for Streets-Maintenance(I) 32,790 32,790 41,235 32,800 41,300 From State 101 33423.00 Ag Preserves Credit(I) 3,424 3,736 7,347 3,000 4,000 From State 101 33425.00 Other State Grants&Aids(I) 38,515 58,620 46,220 35,000 46,000 From State-PERA Aid&Safe&Sober 101 33620.00 Other County Grants&Aids(I) 20,635 22,536 23, 000 23,000 24,000 Dakota County Recycling Funds 101 33630.00 Police Services Levy-ISD t 196(I) 63,493 64,128 64,769 66,100 66,800 101 33630.00 iaison Funding 66, 800 From ISD# 196 101 33720 Other Organization Grants 0 0 2,500 0 0 2015- Walmart Police Grant Total Intergovernmental(I) 788,207 756,579 856,645 679,400 760,600 PAGE TOTALS 9,706,340 10,133,057 10,339,007 10,315,628 10,797,100 6 Page Two 2017 BUDGET WORKSHEETS GENERALFUND REVENUES July 11,2016 2p 7 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 34103.00 Zoning&Subdivision Fees(C) 27,183 60,915 44,545 40,000 42,000 101 34104.00 Plan Checking Fees(C)124,959 212,622 185,952 175,000 192,000 101 34105.00 Saies of Maps&Publications(C) 233 160 120 300 300 Maps&Spec Books 101 34108.00 Admin Fees-Other Funds(C)110,000 101 34108.01 Applicable Funds Except Const. 25,000 25, 000 25,000 25,000 25,000 101 34108.02 Construction Funds 42,456 66,830 116,079 85,000 85,000 85%of 5%Fee for Const.Projeds 101 34109.00 Other Charges for Service(C) 5,094 4,322 7,331 5,000 5,000 101 34110.00 Service Chg on Returned Chks(C) 60 90 60 100 100 101 34112.00 Utility Permit Application Fee(C) 0 0 0 0 0 101 34113.00 Application Fees(C) 0 0 0 0 0 101 34150.00 User Fees-SKB(C) 86,115 82,943 149,072 120,000 180,000 SKB Fees-C&D Cell Fees 101 34151.00 User Fees/Host Agreements-SKB(C) 156,033 25,000 0 0 0 101 34151.00 Landscaping Agreement 0 Landscaping Agreement 101 34152.00 User Fees-SKB(C) 17,959 28,690 25,675 20,000 25,000 SKB Fees-MSW Ash Charges 101 34153.00 User Fees-SKB(C) 167,414 390,484 325,253 360,000 420,000 SKB Fees-Base Service Charges 101 34160.00 National Guard Maint Fees(C) 54,673 50,560 50,560 46,000 54, 500 101 34160.00 Shared Space Maint.Agreement 16,000 Snow Removal/Mowing 101 34160.00 Building Maintenance Contract 38,500 101 34201.00 Special Police Services(C) 11,809 13,362 14,852 20,000 16,000 Contractual 0(T for O cers 101 34202.00 Fire Services-Burning Permits(C) 750 750 750 200 700 No Longer Charge for Permits 101 34203.00 Accident Reports(C)12 0 5 0 0 101 34204.00 Day Care Inspection Fees(C) 200 50 50 200 100 101 34206.00 Other Police Services(C) 4,293 526 4,654 0 2,000 101 34207.00 Other Fire Protection Services(C) 15,751 15,902 16,278 16,900 101 34207.01 U of M Fire Contract 5,200 5,200 101 34207.02 Coates Fire Contract 10,700 10,700 101 34207.03 Other Billed Fire Cails 2,100 1,000 101 34303.00 Mow Weeds(C) 3,339 4,112 2,188 3,000 3,000 101 34304.00 Sweep/Plow Streets(C) 501 987 871 500 700 101 34306.00 Other Highway 8 Street Rev(C) 42,022 40,563 72,058 30,000 40,000 Street Light Bills-Developers 101 34310.00 Right-of-Way Permits(C) 5,350 11,446 18,534 8,000 12,000 101 34407.00 City Share of Metro SAC Chgs(C) 2,601 2,309 5,407 2,500 3,500 Total Charges for Services(C)793,806 1,037,621 1,065,295 958,800 1,123,800 101 35101.00 Court Fines(F)106,617 116,384 114,580 120,000 120,000 From County Total Fines&Forfeits(F) 106,617 116,384 114, 580 120,000 120,000 101 34718.00 Tournament Fees(R) 25,005 12,606 20,538 12,000 18,000 New Fee for 2012 101 34719.00 Player Maintenance Fees(R) 0 0 0 0 0 New Fee for 2011 101 34720.00 Park Reservations(R) 1,604 2,168 4,678 3,400 4,000 101 34721.00 Softball Revenues(R) 41,100 37,559 25, 369 36,000 25, 000 101 34724.00 Tennis Revenues(R) 2,175 2,480 1,995 2,400 2,200 101 34726.00 Rosettes Revenues(R) 2,288 2,222 1,966 2,100 2,000 101 34727.00 Field Trip Revenues(R)7,000 101 34727.01 Youth/Teen Trips 0 0 0 0 0 101 34727.02 AdulUSenior Trips 8,050 7,621 10,072 7,000 7,000 101 34728.00 Adult Soccer League Revenues(R)12,322 9,942 53 0 0 No Longer Offered 101 34730.00 Run forthe Goid Revenues(R) 4,677 5,540 4,344 5,500 4,800 101 34731.00 Youth Soccer Lessons(R)3,298 2,441 1,364 2,400 2,400 101 34732.00 Adult Basketball Revenues(R) 1,214 2,054 1,867 2,000 2,000 101 34733.00 Other Programs Revenues(R) 13,804 13,014 11,180 13,000 13,000 101 34735.00 Camps Revenues(R) 23,594 23,873 26,851 23,000 30,000 101 34736.00 T-Ball Lessons(R) 5,224 4,130 3,961 4,500 4,000 101 38080.00 Banquet Room Fees(R) 39,623 43,171 51,089 50,000 50,000 101 38081.00 Auditorium Fees(R) 4,444 5,973 7,310 6,000 6,500 101 38082.00 Gymnasium Fees(R) 24, 173 26,242 29,292 27,000 28,000 101 38086.00 Classroom Fees(R) 8,465 8,968 9,448 8,500 9,000 101 38096.00 Liquor Provider Fees(R) 900 660 600 800 600 101 38097.00 AN Rental Fees(R) 710 456 450 1,000 500 101 38154.00 Teen Night Revenues(R) 693 631 527 700 600 101 38201.00 Rental Revenues 11,910 4,800 0 18,000 28, 000 Steeple Center Operations 101 38205.00 A/V Rental Revenues 0 0 0 500 2,000 Steeple Center Operations 101 38209.00 Miscellaneous Revenues 0 175 0 0 0 Steeple Center Operations 101 38211.00 Security Services 1,729 651 0 1,000 2,500 Steeple Center Operations 101 38301.00 Rental Revenues 0 0 0 0 0 Senior/Activity Center Operations 101 38305.00 A/V Rental Revenues 0 0 0 0 0 Senior/Activity Center Operations Total Recreation Fees(R) 237,001 217,377 212,956 226,800 242,100 PAGE TOTALS 1,137,424 1,371,381 1,392,831 1,305,600 1,485,900 7 Page Three 2017 BUDGET WORKSHEETS GENERAL FUND REVENUES July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 36101.00 Principai-Special Assessments(M)4,470 4,457 0 2,000 0 From County-101 Funded Projects 101 36102.00 Penaities&Interest-S/A(M) 0 195 0 0 0 From County 101 36210.00 Interest Earnings-Investments(M)90,851 176, 177 122,664 90,000 120,000 101 36214.00 Net Change in FV-Investments(M) (357,024) 231,871 16,629 0 0 Annual Market Value Changes 101 36215.00 Interest Earnings(M) 147 122 837 300 500 From Checking Account 101 36220.00 Rents&Royalties(M) 15,090 17,371 18,399 1,000 3,000 101 36220.01 Garden Plot Rentals 2,000 Antenna to Water Utility Fund in 2016 101 36220.02 Athletic Complex Land Rental 1,00 101 36230.00 ContributionlDonations(M) 12,923 28,756 39,800 0 0 101 36260.00 Other Revenue(M) 6,084 2,086 11,524 10,500 10,500 Includes$7,500 for Heaith Reinsurance 101 36262.00 Special Settlements(M) 13,156 0 0 0 0 101 36263.00 Wellness Program Revenues 0 3,926 15,643 0 10,000 101 36265.00 Use of Reserve Funds(M) 0 41,000 0 102,500 0 101 36265.01 Elections Balancing 0 0 0 0 0 Elections Balancing 101 36265.02 Health Insurance Adjustment 0 0 0 0 0 Health Insurance Adj/Assignment 101 38090.00 City Concessions(M) 4,809 4,229 4,099 4,500 4,500 Total Misc Revenues(M) 209,494) 510,191 229,594 210,800 148,500 101 39202.00 Contribution from Enterprises(T) 3,500 3,500 3,500 3,500 3,500 Arena-Building &Grounds Maint. 10 39203.00 Transfer From T) 0 0 12,623 0 0 Funds Returned from Projects Total Transfers In(T) 3,500 3,500 16,123 3,500 3,500 PAGE TOTALS 205,994) Y$ 513,691 $245,717 $214,300 $152,000 FUNDTOTALS 10,637,770 $12,018,129 $11,977,556 $11,835,528 12,435, 000 INTERNAL REVENUES 2,241,768 $3,372,416 $3,189,959 $2,811,100 3,094,400 Grand Total Less: Ad Valorem Fiscal Disparities 8 Page Four 2017 BUDGET WORKSHEETS GENERAL FUND REVENUES July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Adual 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.02 Fund 202 2,500 101 34108.03 Fund 203 2,500 101 34108.04 Fund 206 2,500 101 34108.05 Fund 207 2,500 101 34108.06 Fund 605 1,000 101 34108.07 Fund 606 1,000 101 34108.08 Fund 607 1,000 101 34108.09 Fund 650 6,000 Admin Fees Breakdown Totals 25,000 $25,000 $25,000 $25,000 $25,000 $25,000 9 Page One 2017 BUDGET WORKSHEETS COUNCIL July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41110 103.00 Salaries& Benefits 37,181 $37,346 $40,976 $39,800 41,300 Salary,Taxes,PERA& Benefits 101 41110 01 225.00 Landscaping Materials 24,923 45,181 26,368 0 25,000 Funding From SKB Revenues 101 41110 01 307.00 City Promotional Fees 23,100 101 41110 01 307.01 Newsletter 14,637 14,424 14,357 15,000 15,000 3 Newsletters 101 41110 01 307.02 Chamber of Commerce Directory 1,069 1,000 1,000 1,100 1,100 101 41110 01 307.03 Community Survey 0 0 0 0 0 101 41110 01 307.04 Community Events 0 0 7,000 7,000 7,000 Leprechaun Days Fireworks 101 41110 01 315.00 Special Programs 4,226 982 2,725 3,000 3,000 Promotions,Marketing,etc. 101 41110 01 319.00 Other Professional Services 33,000 101 41110 01 319.01 Education Reimbursement 7,307 10,230 5,521 12,000 12,000 101 41110 01 319.02 intergovernmentallnitiatives 0 4,177 7,644 20,000 15,000 101 41110 01 319.03 Open Government Intiatives 0 0 0 22,828 6,000 101 41110 01 321.00 Telephone Costs 400 101 41110 01 321.02 Mayor's Cell Phone 389 389 389 400 400 101 41110 01 329.00 Other Communication Costs 0 0 0 500 500 Newspaper Ads/Open Houses 101 41110 01 331.00 Travel Expense 8,000 101 41110 01 331.01 NLC Conference 4,455 4,092 4,302 6,000 6,000 101 41110 01 331.02 MiscellaneousTravel 2,043 1,112 2,776 2,000 2,000 101 41110 01 433.00 Dues&Subscriptions 28,600 101 41110 01 433.01 LMC Dues 16,126 16,700 17,485 17,600 18,500 101 41110 01 433.02 AMM Dues 7,507 7,597 7,656 7,800 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 41110 01 437.00 Conferences&Seminars 14,000 101 41110 01 437.01 Registration&Hotel-LMC Conf 394 1,003 1,552 2,000 2,000 101 41110 01 437.02 Registration&Hotel-NLC Conf 7,541 7,040 10,538 9,000 9,000 101 41110 01 437.03 Miscellaneous Conferences 0 875 674 3,000 3,000 101 41110 01 439.00 Other Miscellaneous Charges 426 381 0 400 400 101 41110 01 598.00 Council Designated 3,991 573,534 337,226 100,000 100,000 '14&'15-Assignment for Projects 101 41110 01 598.01 Assignment for Health Ins. Increases 0 0 0 0 0 101 41110 01 598.02 Sales Tax Exemption Savings 0 0 0 (50,000) 0 0 Year 2 of 2 Phase Out 101 41110 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,726 2,787 3,340 3,500 3,500 101 41110 01 599.02 Vending Machine Costs 3,874 3,206 3,928 4,000 4,000 Offset by Revenue from Machines 101 41110 01 599.03 Commemorations 447 971 1,311 1,200 1,200 101 41110 01 599.04 CammissionNolunteer Recognition 1,296 1,322 394 1,300 1,300 PAGE TOTALS 142,417 $736,211 $499,025 $231,628 287,400 DEPARTMENT TOTALS 142,417 $ 736,211 $499,025 $231,628 287,400 10 Page One 2017 BUDGET WORKSHEETS ADMINISTRATION July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41320 101.00 Salaries&Benefits 386,547 $404,313 $412,421 $431,100 550,500 Salary,Taxes,PERA&Benefits 101 41320 101.00 Human Resources Coordinator 0 0 0 48,300 0 New Position-Start 7/1/16 101 41320 102.00 Full-Time OveRime 0 0 0 0 0 101 41320 103.00 Part-Time Salaries&Benefits 0 5,359 4,322 0 0 101 41320 01 209.00 Other Office Supplies 0 31 0 300 300 Miscellaneous Purchases 101 41320 01 313.00 Temporary Service Fees 0 0 0 0 0 101 41320 01 319.00 Other Professional Services 0 0 0 0 0 101 41320 01 321.00 Telephone Costs 1,572 1,322 1,322 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 01 331.02 ICMA Conference 328 391 0 700 700 101 41320 01 331.03 Miscelianeous Travel 353 226 252 500 500 101 41320 01 433.00 Dues&Subscriptions 2,700 101 41320 01 433.01 MCMA Dues 269 275 281 300 300 101 41320 01 433.02 MAMA Dues 0 0 0 0 0 101 41320 01 433.03 MCFOA Dues 35 35 85 100 100 101 41320 01 433.04 Munici-Pals 25 25 25 100 100 101 41320 01 433.05 IIMC Dues 0 185 0 200 200 City Clerk Association 101 41320 01 433.06 ICMA Dues 1,795 1,831 1,877 1,900 1,900 101 41320 01 433.07 APMP Dues 60 50 40 100 100 101 41320 01 435.00 Books&Pamphlets 0 0 0 100 100 101 41320 01 437.00 Conferences&Seminars 8,800 101 41320 01 437.01 Registration&Hotel-LMC 0 482 687 500 700 101 41320 01 437.02 Registration&Hotel-MCMA 1,429 629 1,444 1,500 1,500 101 41320 01 437.04 Staff(t)Each 0 0 0 0 0 101 41320 01 437.05 Miscellaneous Seminars 0 40 17 300 300 ULI/Greening Initiatives 101 41320 01 437.06 Registration&Hotel-ICMA 3,399 2,995 1,556 3,400 3,400 101 41320 01 437.07 City Clerk Training 1,240 1,507 2,224 2,700 2,700 All MCFOA Events- MMCI 101 41320 01 437.08 Registration 8 Hotel-NLC 0 0 0 0 0 101 41320 01 437.09 Miscellaneous Meetings 89 0 111 200 200 101 41320 01 439.00 Other Miscellaneous Charges 0 202 20 200 200 101 41320 01 580.00 Other Equipment Purchases 0 6 0 200 200 PAGE TOTALS 397,141 419,902 426,683 494,300 565,600 11 Page Two 2017 BUDGET WORKSHEETS ADMINISTRATION July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 41320 31 305.00 Medical&Dental Fees 9,200 Employee Drug Testing 101 41320 31 305.01 Pre-Employment Physicals 630 1,177 1,725 900 900 101 41320 31 305.02 Employee Drug Testing 1,166 1,716 1,588 1,200 800 101 41320 31 305.03 PCORI Fees 0 284 343 0 0 101 41320 31 305.04 Reinsurance Costs 0 0 7,371 7,500 7,500 Costs Reimbursed by Grants 101 41320 31 306.00 Personnel Testing&Recruitment 0 1,825 6,198 8,000 5,000 101 41320 31 315.00 Special Programs 11,500 101 41320 31 315.01 Employee Training 49 0 132 1,000 1,000 101 41320 31 315.02 Health&Wellness 206 594 500 500 500 Weliness&Health Management 101 41320 31 315.04 SW/WC Co-op Wellness Grant 0 3,912 15,557 0 10,000 Costs Reimbursed by Grants 101 41320 31 319.00 Other Professional Services 4,000 101 41320 31 319.01 Labor Consultant 0 0 0 500 500 101 41320 31 319.02 Labor Legal Issues 0 0 1,148 700 700 101 41320 31 319.04 COBRA Consultant 699 518 715 800 800 101 41320 31 319.05 FIexNEBAAdministrativeFees 1,770 1,945 1,920 2,000 2,000 101 41320 31 319.06 S1NWC Co-Operative Dues 0 0 0 0 0 101 41320 31 331.00 Travel Expense 330 599 635 400 600 101 41320 31 341.00 EmploymentAdvertising 797 1,956 927 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 0 8,500 0 0 Neo Gov-Initial Purchase 101 41320 31 433.00 Dues&Subscriptions 900 101 41320 31 433.02 IPMA Dues 209 249 174 300 300 101 41320 31 433.03 MPELRA Dues 275 200 275 400 600 101 41320 31 435.00 Books&Pamphlets 0 0 0 100 100 Books&Training Materials 101 41320 31 437.00 Conferences&Seminars 1,100 101 41320 31 437.01 MPELRA State Conference 297 485 601 500 S00 101 41320 31 437.02 Personnel Seminars 235 171 75 300 300 101 41320 31 437.03 Safety,Supervisor,Policy 0 0 0 0 0 101 41320 41 315.00 Special Programs 300 101 41320 41 315.01 General Marketing 214 0 0 300 300 101 41320 41 315.02 Historical Monuments 0 0 0 0 0 101 41320 41 319.00 Other Professional Services 6,500 101 41320 41 319.01 Website 3,572 4,751 5,983 13,000 6,500 101 41320 41 319.02 Website Improvements 0 0 0 0 0 101 41320 41 328.00 Cable Supply Costs 384 1,016 864 1,000 1,000 Cable Supplies,Software 101 41320 41 329.00 Other Communication Costs 0 0 0 60,100 101 41320 41 329.01 Cable JPA Payment-General City 44,265 45,934 54,388 71,000 60,000 101 41320 41 329.02 Video Streaming Council Mtgs 0 0 60 100 100 101 41320 41 329.03 Bulk E-Mail System 0 0 0 0 0 101 41320 41 331.00 Travel Expenses 32 52 55 100 100 101 41320 41 433.00 Dues&Subscriptions 75 75 75 100 100 MAGC 101 41320 41 437.00 Conferences&Seminars 0 0 0 100 100 Technical Courses 101 41320 41 580.00 Other Equipment Purchases 189 371 0 500 500 PAGE TOTALS 55,393 $67,829 $ 109,808 $115,800 108,600 DEPARTMENTTOTALS 452,534 $487,731 $536,491 $610,100 674,200 12 Page One 2017 BUDGET WORKSHEETS ELECTIONS July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 41410 01 103.00 Part-Time Salaries 0 $18,117 0 $36,000 0 Election Judges& Front Desk 101 41410 01 203.00 Printed Forms&Paper 0 568 0 200 0 Ballots&Programming 101 41410 01 208.00 Miscellaneous Supplies 0 147 0 500 0 101 41410 01 219.00 Other Operating Supplies 0 306 0 300 0 Food for Election Judges 101 41410 01 242.00 Minor Equipment 0 0 0 0 0 Signs&Miscellaneous 101 41410 01 304.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 0 0 0 101 41410 01 351.00 Legai Notices Publishing 0 0 0 0 0 Election Publications 101 41410 01 391.00 P.C.Maintenance 0 6,200 6,355 6,200 0 Elections S/W Maintenance Costs Utiliizing Lase che) 101 41410 01 409.00 Other Contracted Repair&Maint 5,000 101 41410 01 409.01 Maintenance for Voting Machines 1,225 1,225 0 5,000 5,000 101 41410 01 409.02 MaintenanceforAccuvotes 1,000 1,000 0 0 0 101 41410 01 412.00 Building Rental 0 0 0 0 0 Possible Rent for Locations 101 41410 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 101 41410 01 580.00 Other Equipment Purchases 8,626 0 11,200 0 15,000 PAGE TOTALS 10,851 $27,562 $17,555 $48,200 20,000 DEPARTMENT TOTALS 10,851 $27,562 $17,555 $48,200 20,000 13 Page One 2017 BUDGET WORKSHEETS FINANCE July 11,2016 2p 7 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41520 101.00 Salaries&Benefits 319,121 $395,125 $406,312 $ 420,100 432,500 Salary,Taxes,PERA&Benefits 101 41520 102.00 Full-Time Overtime 2,707 2,826 1,629 3,000 3,000 101 41520 103.00 Part-Time Salaries&Benefits 50,067 0 0 0 12,000 Intern 12-15 Hours Per Week 101 41520 01 321.00 Telephone Costs 1,429 1,322 1,322 1,500 1,500 Cell PhoneAllowances(2) 101 41520 01 331.00 Travel Expense 1,300 101 41520 01 331.01 Finance Director 869 449 409 1,200 1,200 National Conference Included 101 41520 01 331.02 Staff 69 0 129 100 100 101 41520 01 391.00 P.C.Maintenance 67,400 101 41520 01 391.02 Remote Desktop Services 962 900 900 1,000 1,000 101 41520 01 391.03 Incode Software Maintenance 8,857 9,168 9,595 9,000 10,000 101 41520 01 391.04 General Network Support 20,000 20,000 20,000 25,000 25,000 Block Hours of Support Time 101 41520 01 391.06 Fixed Asset Maint Contract 1,384 1,365 1,365 1,400 1,400 Increased Cost and Need^^ 101 41520 01 391.07 Miscelianeous Repairs&Maint. 1,590 2,794 711 2,500 2,000 101 41520 01 391.08 Anti-Virus Software Renewal 4,696 1,188 1,188 2,000 2,000 101 41520 01 391.09 File Server Software Maintenance 12,931 8,707 5,764 14,800 7,000 101 41520 01 391.10 Managed Backup Services 0 11,010 11,060 14,500 19,000 Outgrowing Current Capacity 101 41520 01 392.00 P.C.Accessories&Supplies 2,462 2,075 1,766 3,000 3,000 City System Supplies 101 41520 01 393.00 P.C.Hardware Purchases 1,243 675 2,192 2,000 2,000 101 41520 01 394.00 P.C.Software Purchases 2,000 101 41520 01 394.01 Annual Microsoft Office Payment 0 0 0 0 0 2015 End of Life for O ce 2010 101 41520 01 394.02 Miscelianeous S/W Purchases 3,515 352 1,754 2,000 2,000 101 41520 01 409.00 Other Contracted R&M 210 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 360 380 380 101 41520 01 433.04 GFOA-Finance Director&Asst. 340 340 340 350 350 101 41520 01 435.00 Books&Pamphlets 100 101 41520 01 435.01 Accounting Related Books 178 0 0 50 50 101 41520 01 435.02 Finance Related Books 0 0 0 50 50 101 41520 01 437.00 Conferences&Seminars 2,800 101 41520 01 437.02 MnGFOA Annual Conf(FID) 571 571 573 700 700 101 41520 01 437.03 GFOA National Conf(F/D) 1,708 432 543 1,500 1,500 101 41520 01 437.04 Staff Development 0 15 0 200 200 101 41520 01 437.05 Miscellaneous Seminars 278 360 387 400 400 Misc.Meetings,Lunches,etc. 101 41520 01 439.00 Other Miscellaneous Charges 39 284 85 200 200 Contingencies 101 41520 01 570.00 Office Equipment 8 Furnishings 1,000 316 971 500 500 PAGE TOTALS 436,646 $460,919 $469,640 $507,800 529,400 DEPARTMENT TOTALS 436,646 $460,919 $469,640 $507,800 529,400 14 Page One 2017 BUDGET WORKSHEETS GENERAL GOVERNMENT July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 41810 01 202.00 Duplicating&Copying 15,000 101 41810 01 202.02 Copying Costs 14,668 16,182 16,522 15,000 15,000 101 41810 01 203.00 Printed Forms&Paper 7,600 101 41810 01 203.01 Copy Paper 3,757 3,773 5,026 4,000 4,000 101 41810 01 203.02 General Receipt Books 0 0 776 800 800 101 41810 01 203.03 Purchase Orders 1,376 1,336 0 1,400 1,400 101 41810 01 203.04 Payroll&A!P Checks 327 324 435 400 400 101 41810 01 203.06 Miscellaneous Forms 856 2,257 123 1,000 1,000 Business Cards,etc. 101 41810 01 204.00 Envelopes&Letterheads 1,800 101 41810 01 204.01 Letterhead 245 1,523 1,195 700 700 101 41810 01 204.02 Plain Envelopes 1,192 322 902 600 600 101 41810 01 204.03 A/P&Payroll Envelopes 0 946 0 500 500 101 41810 01 204.04 10 x 13 Envelopes 0 0 0 0 0 101 41810 01 209.00 Other Office Supplies 13,021 14,456 14,386 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.00 Minor Equipment 500 101 41810 01 242.02 Credit Card Equipment 0 0 748 500 500 500-$700 for One Terminal 101 41810 01 301.00 Auditing&Accounting Services 68,100 101 41810 01 301.01 Audit&General Consuiting Fees 57,547 59,181 65,173 62,000 60,000 101 41810 01 301.02 Dakota County Assessment Fees 5,955 6,344 6,482 7,000 6,500 101 41810 01 301.03 Dak Cty Truth In Taxation Costs 1,503 1,523 1,525 1,600 1,600 101 41810 01 303.00 Engineering Fees 0 0 0 0 0 101 41810 01 304.00 Legal Fees 56,703 63,485 87,108 64,000 66,000 General City Legal Fees 101 41810 01 319.00 Other Professional Services 25,200 101 41810 01 319.01 City Code Update 1,140 160 2,974 2,700 2,700 101 41810 01 319.02 City Code Web Fees 500 500 500 500 500 101 41810 01 319.03 State Building Report(Springsteds) 4,935 4,548 4,310 5,000 5,000 Fees Paid to Springsted 101 41810 01 319.04 Continuing Disclosure Fees 2,000 2,400 2,600 4,000 3,000 Fees Paid to Springsted(Bonds} 101 41810 01 319.05 Annual User Fee Study Update 3,695 3,928 3,996 4,000 4,000 Fees Paid to Springsted 101 41810 01 319.06 Arbitrage/Rebate Calculations 5,750 0 5,850 10,000 10,000 Fees Paid to Springsted(Bonds) 101 41810 01 319.10 UMore Professional Services 36,961 20,020 2,603 0 0 In-House Engineer or Bill Out 101 41810 01 320.00 Credit Card Activity Fees 22,000 101 41810 01 320.01 Utilities'Fees 453 0 0 0 0 O/L Added- Moved to Utilities 101 41810 01 320.02 Parks&Recreation Fees 5,082 5,031 4,746 5,200 5,500 101 41810 01 320.03 Building Fees 10,950 11,492 19,326 12,000 15,000 101 41810 01 320.04 General Fees 1,091 819 1,372 1,000 1,500 101 41810 01 320.05 Parks 8 Recreation On-Line Fees 0 0 99 0 0 101 41810 01 321.00 Telephone Costs 38,800 101 41810 01 321.01 General Phone Costs(&Internet) 36,021 25,574 27,504 28,000 28,000 Added Fiber to Buildings in 2013 101 41810 01 321.02 Domain Housing 60 60 60 100 100 101 41810 01 321.03 Software Maintenance Costs 7,299 7,970 7,970 8,700 8,700 Added Additional Licenses 101 41810 01 321.04 Phone System Hardware 0 533 289 2,000 2,000 Phone Upgrades, Headsets,etc. 101 41810 01 322.00 Postage Costs 13,555 15,601 13,340 15,000 15,000 101 41810 01 339.00 Other Transportation Expenses 44 906 166 800 1,000 Vehicle Licensing 101 41810 01 351.00 Legal Notices Publishing 3,500 101 41810 01 351.01 Costs for Public Notices 2,716 4,468 2,997 3,000 3,000 All Departments 101 41810 01 351.03 Budget&Audit Publications 227 452 996 500 500 State Mandated Publications 101 41810 01 391.00 P.C.Maintenance 16,198 18,245 14,344 18,000 18,000 Lasefishe Maintenance 101 41810 01 392.00 P.C.Software Purchases 4,900 12,669 1,593 7,000 7,000 Lase she Software 101 41810 01 393.00 P.C. Hardware Purchases 3,825 2,140 1,100 4,000 4,000 Scanner Purchase 101 41810 01 433.00 Dues&Subscriptions 1,322 1,050 964 1,000 1,000 Newspapers 101 41810 01 439.00 Other Miscellaneous 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 36,132 32,209 30,930 20,000 14,000 O ce Machines-All Buildings PAGE TOTALS 352,247 $342,664 $351,268 $326,800 323,300 DEPARTMENT TOTALS 352,247 $342,664 $351,268 $326,800 323,300 15 Page One 2017 BUDGET WORKSHEETS POLICE July 11,2016 Zp 7 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Adual Budget Amount Budget Comments All Salary Costs Inclusive of ^ 101 42110 101.00 Salaries&Benefits 2,514,144 $2,630,087 $2,840,182 $2,879,000 2,962,800 Salary,Taues,PERA&Benefits 101 42110 101.00 Salaries&Benefits 0 0 0 0 125,400 New Sergeant(Cops Grant-PaR'I) 101 42110 102.00 Full-Time Overtime 94,077 89,832 94,032 93,500 93,500 101 42110 102.01 Regular Overtime Hours 77,500 COIA&Expiorer Post Time 101 42110 102.02 Contracted O/T 16,000 101 42110 103.00 Part-Time Salaries&Benefits 44,700 101 42110 2°103.00 Part-Time Secretary 12,686 10,227 123 0 0 Position Eliminated in 2015 101 42110 9fi 103.00 Part-Time CSO's 32,980 36,277 37,593 43,700 44,700 CSO's-Up To 50 Hours/Wk 101 42110 01 202.00 Duplicating& Copying 0 0 0 0 0 101 42110 01 203.00 Printed Forms&Paper 1,745 1,784 1,693 1,600 1,700 101 42110 01 204.00 Envelopes& Letterheads 8 213 0 300 300 Business Cards 101 42110 01 207.00 Training&Instructional Supplies 12,600 101 42110 01 207.01 Practice Ammunition 3,003 5,067 5,277 5,500 5,500 Increase Due to Increase in Costs 101 42110 01 207.02 Service Ammunition 815 1,0'14 1,000 1,300 1,300 Increase Due to Increase in Costs 101 42110 01 207.03 Other Supplies 787 25 134 200 300 101 42110 01 207.04 M.A.A.G.Ammunition 4, 951 5,190 5,220 5,500 5,500 Increase Due to Increase in Costs 101 42110 01 208.00 Miscellaneous Supplies 0 Donated&Forfeited Funds 101 42110 01 208.01 DARE Donations 285 302 212 0 0 101 42110 01 208.02 Equipment Donations/Forfeitures 6,465 3,837 2,901 0 0 101 42110 01 208.03 Other Grants Expenditures 0 0 2,807 0 0 101 42110 01 209.00 Other Office Supplies 1,518 1,080 908 1,100 1,100 Videos&CD's(Increase in Costs) 101 42110 01 211.00 Cleaning Supplies 1,500 101 42110 01 211.01 Blanket Cleaning 0 0 0 0 0 101 42110 01 211.02 Squad Cleaning 235 557 502 1,500 1,500 101 42110 01 217.00 Clothing Allowance 4,700 101 42110 01 217.01 CSO's 420 319 2,375 800 1,000 101 42110 01 217.02 Reserves 1,796 997 2,168 1,000 1,500 101 42110 01 217.03 Other Supplies 4,256 2,682 1,826 1,600 2,200 Increase to Cover Chief Uniforms 101 42110 01 219.00 Other Operating Supplies 4,200 101 42110 01 219.01 Evidence Bags,Drug Kits,Misc. 420 1,635 2,033 2,000 2,000 101 42110 01 219.02 Accurint Database Services 600 717 713 1,700 2,200 Free Service no Longer Available 101 42110 01 221.00 Equipment PaRs 3,025 2,598 2,841 4,000 4,000 Squad Emerg Equip(Medic Bags) 101 42110 01 241.00 Small Tools 4,100 Crime Scene Kd Supplies 101 42110 01 241.01 Evidence Processing Equipment 572 213 765 800 800 101 42110 01 241.02 Camera and Video Supplies 1,141 1,644 1,850 2,000 2,000 Squad Camera Maintenance 101 42110 01 241.03 Digital Recorder Warranty 728 1,198 1,285 1,300 1,300 3%Cost Increase Estimate 101 42110 01 242.00 Minor Equipment 2,200 101 42110 01 242.01 Less Lethal Tactical Equipment 754 966 1,615 1,000 .9,200 Training Supplies,Taser Batteries 101 42110 01 242.02 MAAG Equipment 0 362 413 500 1,000 101 42110 01 304.00 Legal Fees 59,570 59,532 68,420 65,400 67,000 Prosecution-2.5%Increase 101 42110 01 305.00 Medical&Dental Fees 2,000 101 42110 01 305.01 Physicals 1,044 667 1,418 800 1,200 101 42110 01 305.02 Seized Narcotic Testing 773 170 794 800 800 Biood Draws 101 42110 01 306.00 Personnel Testing&Recruitment 1,551 795 4,319 1,000 1,500 Psychological 101 42110 01 313.00 Temporary Service Fees 787 70 626 800 800 Interpreter Services 101 42110 01 315.00 Special Programs 0 0 0 0 0 101 42110 01 316.00 Animal Care Services 1,700 101 42110 01 316.01 Impound&Care Fees 3,000 1,600 1,252 2,800 1,700 101 42110 01 316.02 "Future Use" 0 0 0 0 0 101 42110 01 319.00 Other Professional Services 434,700 101 42110 01 319.01 Dispatch Services-Operations 338,376 354,649 368,448 388,200 417,900 403,800-Ops 8$19,400-Capital 101 42110 01 319.02 Policy Development&Training 0 999 842 800 800 Includes RFD^^^) 101 42110 01 319.03 Mediation Services 0 792 219 1,000 1,000 101 42110 01 319.04 Eledronic Crimes Unit Fees 0 0 15,000 15,000 15,000 Coordinated by Dakota County 101 42110 01 319.05 Emergency Mgmt Plan Update 0 5,148 0 0 0 101 42110 01 321.00 Telephone Costs 14,000 101 42110 01 321.01 Cell Phones 4,865 3,696 4,599 10,300 14,000 Switching to Smart Phones 101 42110 01 323.00 Radio Units 14,000 101 42110 01 323.01 Radios 8,437 10,638 9,052 12,900 11,500 800 MHz Subscriber Fees 101 42110 01 323.02 Radars 0 767 370 500 500 Radar&LIDAR Repairs 101 42110 01 323.03 Radio Warranty 1,703 1,703 1,703 2,000 2,000 101 42110 01 331.00 Travel Expense 6,000 101 42110 01 331.01 MN Chiefs Spring Conference 395 435 0 500 500 101 42110 01 331.02 IACP or FBINAA Conference 0 1,813 1,956 2,000 2,200 101 42110 01 331.03 Outstate Investigations& Conf. 43 552 1,032 750 750 101 42110 01 331.04 MAAG Conference 660 623 619 750 850 Increase in Conference Costs 101 42110 Ot 331.05 CAN-AM Narcotic Conference 394 420 261 500 500 101 42110 01 331.06 Juvenile Officers Conference 244 513 521 600 600 Increase in Conference Costs 101 42110 01 331.07 Meeting Reimbursements 134 101 139 500 600 PAGETOTALS 3,109,386 3,244,506 3,492,057 3,557,800 3,804,500 16 Page Two 2017 BUDGET WORKSHEETS POLICE July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actuai Actuai Actual Budget Amount Budget Comments 101 42110 01 333.00 Freight& Express Expenses 46 97 9 200 200 Repairs 101 42110 01 394.00 P.C.Software Purchases 60,500 101 42110 01 394.01 Automated Pawn System 204 204 204 300 300 101 42110 01 394.02 Pictometry 0 0 0 0 0 In Public Works Budget 101 42110 01 394.03 CJIIN/Pro Phoenix System 7,385 36,120 41,759 32,200 0 No longer member of CJIIN/ProPhoen 101 42110 01 394.04 LOGIS TriTech RMS 0 0 0 24,500 60,200 TriTech RMS and Report Writing 101 42110 01 396.00 Computer Maintenance 35,700 101 42110 01 396.01 LOGIS Apps Support 36,264 2,952 3,060 0 0 LOGIS APS-Moved to LOGIS RMS 101 42110 01 396.02 CJDN Connection Charges 2,981 3,724 4,365 2,800 2,800 State of MN CJDN Connection 101 42110 01 396.03 MCD Connection Charges 1,384 630 236 2,100 2,100 LOGIS MDC Connection Charges 101 42110 01 396.04 MCD Maintenance&Cellular 20,084 21,523 24,058 27,500 28,000 Increase Due to CAD Change 101 42110 01 396.05 LOGIS Fees/Development 8,288 3,302 1,985 1,600 1,600 Development Fund(Waived til 2018) 101 42110 01 396.06 Evidence.com Data Storage 0 0 0 600 600 Squad Video 101 42110 01 396.07 Schedule Anywhere 0 0 0 0 600 Scheduling Software 101 42110 01 433.00 Dues&Subscriptions 10,500 101 42110 01 433.01 Multi-Agency Assistance Group-MAAG 5,000 8,300 8,300 8,300 8,300 MAAG Equipment CIP Increase 101 42110 01 433.02 IACP Chiefs 120 120 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 320 330 400 400 400 Chief and a Sergeant 101 42110 01 433.05 Wakota CAER 0 0 0 0 0 101 42110 01 433.06 Metro Emergency Managers 0 0 0 0 0 101 42110 01 433.07 MN Sex Crimes Investigators 0 0 0 20 20 101 42110 01 433.08 Tri-County Investigators 0 75 75 50 50 101 42110 01 433.09 MN Crime Prevention Association 60 45 45 65 65 101 42110 01 433.10 P.O.S.T.Licenses 639 420 1,260 540 540 101 42110 01 433.11 FBI NaYI Academy Association 75 85 0 0 0 Chiefs Membership Cancelled 101 42110 01 433.12 Miscelianeous 171 13 350 290 390 101 42110 01 433.13 ATOM 0 0 0 250 250 Ass'n Training O cers of MN 101 42110 01 435.00 Books&Pamphlets 887 1,123 ,058 1,500 2,500 Crime Prevention Materials 101 42110 01 436.00 Towing Charges 0 158 255 200 200 Disabled Squads Disabled Squads 101 42110 01 437.00 Conferences&Seminars 28,400 101 42110 01 437.01 Firearms-Range 2,299 2,130 4,325 4,000 4,500 Range Rental 101 42110 01 437.02 Chiefs Spring Conference 20 523 0 750 750 Conference Cost Increases 101 42110 01 437.03 Investigations 1,103 1,064 1,175 1,500 2,000 101 42110 01 437.04 IACP Conference 352 210 295 300 400 101 42110 01 437.05 Supervision 198 1,362 1,883 6,000 6,500 Personnel Developm t Northwestern 101 42110 01 437.06 Use of Force 736 275 750 2,000 2,000 Increase due to Instructor Retiring 101 42110 01 437.07 Emergency Driving 225 1,575 2,625 3,000 3,000 Driving School Cost Increase 101 42110 01 437.08 First Aid 500 0 640 600 700 Cost Increase due to State Reg.Inc. 101 42110 01 437.09 Narcotic Enforcement 0 12 197 200 200 101 42110 01 437.10 Tactical 213 819 1,269 1,000 1,000 101 42110 01 437.11 SuppoR Services 240 190 306 500 500 101 42110 01 437.12 Patroi Operations 1,848 1,413 1,480 3,500 4,500 Increase due to C.I.T.for Patrol 101 42110 01 437.13 Emergency Management 224 32 0 200 0 101 42110 01 437.14 SRO/CRO 0 0 0 1,000 1,300 Added for Specialized Training 101 42110 01437.15 Explorer Conference 0 0 0 750 750 Two Advisors to State Conference 101 42110 01 437.16 360 Communities Annual Banquet 0 0 0 300 300 101 42110 01 439.00 Other Miscellaneous Charges 265 94 783 500 800 Refreshments for Meetings& Compliance Checks 101 42110 01 580.00 Other Equipment Purchases 0 1,730 1,864 2,000 2,000 101 42110 01 599.00 Employee Recognition Costs 0 0 0 0 2,000 Recognition BanqueUPlaques/Awards PAGE TOTALS 92,422 $90,940 $105,450 $132,000 142,800 DEPARTMENTTOTALS 3,201,808 $3,335,445 $3,597,506 $3,689,800 3,947,300 17 Page One 2017 BUDGET WORKSHEETS FIRE July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 42210 103.00 Salaries&Benefits 155,420 $163,743 $203,534 $213,000 213,000 Salary,Taxes,PERA&Benefits 10142210 103.01 Salaries 32,000 101 42210 103.02 Training Pay 51,000 101 42210 103.03 Call Pay/Stipends 130,000 101 42210 103.04 Class Pay/Stipends 0 101 42210 01 202.00 Duplicating&Copying 200 101 42210 01 202.01 Copy Toner 0 0 97 50 100 101 42210 01 202.02 Computer Printers 0 14 0 50 100 101 42210 01 204.00 Envelopes& Letterhead 500 101 42210 01 204.01 Envelopes 0 0 0 200 200 Need New Stationary in 2017 101 42210 01 204.02 Letterhead 0 0 0 200 200 Need New Stationary in 2017 101 42210 01 204.03 Forms 0 10 0 100 100 Need to Update Supply 101 42210 01 211.00 Cleaning Supplies 800 101 42210 01 211.01 Soaps 885 47 278 550 550 101 42210 O1 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.04 SCBA Cleaner 0 91 100 150 150 101 42210 01 218.00 Fire Department Clothing 5,000 101 42210 01 218.01 Uniforms 2,923 1,268 319 1,500 1,700 Uniforms for New Hires 101 42210 01 218.02 Station Wear(2015) 449 179 572 3,000 3,300 Yearly Ailowance for Fire Fighters 101 42210 01 219.00 Other Operating Supplies 8,400 Medical Supplies 101 42210 01 219.01 Gloves 692 510 2,638 1,000 2,500 101 42210 01219.02 Bandages 0 0 0 100 100 101 42210 01 219.03 Equipment 1,564 380 4,766 1,500 1,500 101 42210 01 219.04 Tyvek Suits 0 0 0 100 100 101 42210 01 219.05 Consummable Medical 2,174 2,406 2,566 3,000 3,000 Increase in Medical Calls 101 42210 01 219.06 Oxygen 126 917 (467) 1,200 1,200 Added 02 Cascade @ FS#2 101 42210 01 229.00 Other Maintenance Supplies 6,900 101 42210 01 229.01 Vehicle Repairs 0 0 58 400 400 101 42210 01 229.02 Pickup Trucks 0 0 0 0 0 101 42210 01 229.03 Rescue&Other 0 0 0 0 0 101 42210 01 229.04 Vehicle Modifications 0 1,147 55 3,500 6,500. Replace Aging Light Bars 101 42210 01 230.00 Equipment Repair Materials 1,500 101 42210 01 230.01 Light Bars 0 0 0 100 100 101 42210 01 230.02 Smoke Machines 113 0 0 300 300 101 42210 01 230.03 Lanterns&Miscellaneous 1,808 0 64 300 300 101 42210 01 230.04 Small Tool Repairs 241 181 640 600 600 101 42210 01 230.05 Opticom 0 0 0 100 100 101 42210 01 230.06 Station 0 10 101 100 100 101 42210 01 241.00 Small Tools gpp 101 42210 01 241.01 Axes, Bars&Other 15 42 1,413 150 150 101 42210 01 241.02 Grass Fire 0 0 0 250 250 101 42210 01 241.03 Hand Tools(2014-Donation) 338 5,994 461 500 500 Replace Aging Tools 101 42210 01 305.00 Medical&Dental Fees 3,120 3,039 2,560 3,800 4,500 Switching Testing Company-2017 101 42210 01 306.00 Personnel Testing&Recruitment 5,300 101 42210 01 306.01 New Physicals(4) 1,942 1,823 2,448 2,000 4,000 New Hires 101 42210 01 306.02 Hepatitis Shots(4) 0 0 220 500 500 101 42210 01 306.03 Background Checks(4)183 438 403 500 600 101 42210 01 306.04 Drug Testing(4) 0 0 0 200 200 101 42210 01 308.00 Instructors'Fees 9,100 101 42210 01 308.01 Fire Fighter 1 (4) 1,015 1,951 600 1,600 1,600 101 42210 01 308.02 Fire Fighter 1 Certificates(4) 75 0 0 300 300 101 42210 01 308.03 Fire Fighter Re-Certificates(14) 320 280 200 400 400 101 42210 01 308.04 First Responder(4) 0 495 0 1,000 1,000 101 42210 01 308.05 First Responder Refresher(1/2) 1,350 1,447 1,200 1,400 1,400 101 42210 01 308.06 Outside Schools 879 17,035 2,335 3,300 3,300 101 42210 01 308.07 Haz-Mat Training(4) 1,675 0 0 1,000 1,000 101 42210 01 308.08 Other Re-Certificates(2) 0 55 0 100 100 PAGE TOTALS 177,305 203,503 227,160 248,200 256,100 18 Page Two 2017 BUDGET WORKSHEETS FIRE July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 42210 01 310.00 Testing Services 5,800 101 42210 01 310.01 Aerial 750 750 2,373 1,000 2,500 101 42210 01 310.02 Ladders 436 564 434 800 800 Increase in Fees 101 42210 01 310.03 Pumpers(3)(Next 2014) 675 2,344 829 2,500 2,500 Increase in Fees 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 3,105 1,988 1,800 4,500 4,500 Added SCBA Compressor-FS#2 101 42210 01 313.02 SCBA Flow Test 780 783 500 2,500 2,500 Added SCBA Compressor-FS#2 101 42210 01 313.04 Security Contract 610 656 656 800 800 101 42210 01 313.05 SOT Joint Powers 5,770 6,867 6,867 7,500 7,500 Increase in Fees 101 42210 01 314.00 Annual Fire Relief Contribution 171,000 171,000 109, 100 30,000 30,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 0 114 200 200 101 42210 01 319.03 Fire Prevention Week Promos 408 307 694 700 700 101 42210 01 319.04 Food at Open House 141 283 223 300 300 101 42210 01 319.05 Summer Park Education 0 0 0 0 0 101 42210 01 319.06 National Night Out 539 762 0 600 600 101 42210 01 321.00 Telephone Costs 5,000 101 42210 01 321.01 Cell Phones 2,481 1,818 3,002 2,500 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 0 18 0 100 100 UPS Costs 101 42210 01 329.00 Other Communication Costs 21,300 101 42210 01 329.01 Base Repairs 0 0 0 300 300 101 42210 01 329.02 Pager Repairs 835 235 1,356 1,000 1,000 101 42210 01 329.03 Hand Held Repairs 72 0 1,884 2,000 2,500 Warranty Plan to be Added 101 42210 01 329.04 Mobile Repairs 560 930 0 1,000 2,000 Aging Equipment 101 42210 01 329.05 800 MHZ User Fee 9,555 11,758 10,079 14,000 14,000 101 42210 01 329.06 Mobile Computers 937 1,320 1,416 1,500 1,500 Monthly Air Time Fees(1 Add'n) 101 42210 01 331.00 Travel Expense 8,600 101 42210 01 331.01 Minnesota Chiefs Conference 1,083 0 0 2,000 2,000 101 42210 01 331.02 Fire Department Association 0 0 0 1,600 1,600 101 42210 01 331.03 Outside Schools 0 0 0 5,000 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 101 42210 01 433.01 Capital City 50 0 0 50 50 101 42210 01 433.02 VFBA Insurance 287 307 672 350 775 101 42210 01 433.03 State Fire 318 385 763 725 800 101 42210 01 433.04 State Chiefs 0 345 0 250 250 101 42210 01 433.05 DCFC 0 150 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 O1 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 0 367 323 400 400 101 42210 01 437.02 State Chiefs Conference 440 1,148 1,718 1,000 1,500 Sending Additional Personnel 101 42210 01 439.00 Other Miscellaneous Charges 3,100 101 42210 01 439.01 Food&Coffee 565 546 818 700 700 101 42210 01 439.02 Extinguisher 356 0 505 600 600 101 42210 01 439.03 Plaques 30 91 139 200 200 101 42210 01 439.04 Paint 0 0 0 100 100 101 42210 01 439.05 Station Needs 737 987 1,617 1,500 1,500 101 42210 01 580.00 Other Equipment Purchases 27,600 101 42210 01 580.01 Bunker Gear(8) 13,549 20,744 33,626 18,600 18,600 101 42210 01 580.02 Pagers 0 385 2,245 5,000 5,000 Replacements(5 Per Year) 101 42210 01 580.03 Hose&Fittings 6,904 1,349 407 2,000 2,000 Aging Equipment 101 42210 01 580.04 Replace Damaged Items 2,502 1,001 6,917 2,000 2,000 101 42210 01 581.00 Other Equipment Purchases 0 0 0 0 0 101 42210 01 586.00 Other Equipment Purchase 1,866 0 0 0 0 Donation Items PAGE TOTALS 227,391 $230,239 $191,199 $118,200 122,900 DEPARTMENT TOTALS 404,696 $433,742 $418,359 $366,400 379,000 19 Page One 2017 BUDGET WORKSHEETS GOVERNMENT BUILDINGS July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41940 101.00 Salaries&Benefits 113,700 Salary,Taxes, PERA& Benefits 101 41940 77 101.01 Administrative 0 0 3,353 7,000 7,300 P.W.Director/City Engineer 101 41940 79 101.01 Maintenance 72,144 67,802 68,709 71,400 106,400 Facility Specialist(80%) 101 41940 102.00 Full-Time Overtime 1,791 1,047 563 0 0 101 41940 01 208.00 Miscellaneous Supplies 19,744 16,604 15,995 18,000 18,000 Cleaning,Paper Prod.,Coffee 101 41940 01 219.00 Other Operating Supplies 1,980 2,012 2,580 2,500 2,800 Flags 101 41940 01 223.00 Building Repair Supplies 7,881 10,602 8,760 13,000 10,500 Light Bulbs,Locks, etc. 101 41940 01 225.00 Landscaping Materials 1,614 1,367 442 1,500 1,500 Trees&Shrubs 101 41940 01 241.00 Small Tools 276 187 422 300 600 Carpentry,Bits,Blades,etc. 101 41940 01 242.00 Minor Equipment 829 1,384 995 2,000 1,000 Equipment Replacement 101 41940 01 302.00 Architects'Fees 0 0 0 0 0 Estimates 101 41940 01 318.00 Contract Engineer 2,500 3,000 1,562 0 0 101 41940 01 319.00 Other Professional Services 86,300 101 41940 01 319.01 Elevator Maintenance 3,110 2,388 1,887 2,500 2,500 101 41940 01 319.02 Heating/Cooling Maint Contract 5,336 6,457 7,322 9,000 9,000 Includes all City Facilities 101 41940 01 319.03 Annual Boiler Inspections/Maint. 75 75 50 800 500 101 41940 01 319.04 Pest Control 2,821 2,972 3,144 3,100 4,500 Price Incr.,Boxelder Treatment 101 41940 01 319.05 Fire Extinguishers 1,859 1,255 810 1,800 1,800 101 41940 01 319.06 Fire Suppression System Check 3,400 2,505 2,569 3,500 3,500 101 41940 01 319.07 Janitorial Service-Fire Stations 10,016 9,762 9,837 10,200 10,200 101 41940 01 319.08 Janitorial Service-P.W. Building 10,529 10,620 10,774 10,700 11,000 101 41940 01 319.09 Janitorial Service-City Hall 26,266 26,035 26,232 26,700 26,700 101 41940 01 319.10 Floor Mats-Monthly Charges 4, 361 4,125 4,491 4,500 5,000 Vendor Price Increase 101 41940 01 319.11 Other Janitorial Services 11,468 9,779 9,635 12,000 10,500 Wax Flrs,Carpet Cing,Windows 101 41940 01 319.12 Annual Monument Maintenance 1,025 1,025 1,075 1,100 1,100 900-$1200(Hot Wax) 101 41940 01 321.00 Telephone Costs 447 735 726 800 800 Air Card for iPad-Monthly Chgs 101 41940 01 381.00 Electric Utilities 75,732 69,202 63,971 77,000 70,000 101 41940 01 383.00 Gas Utilities 63,594 73,444 49,446 70,000 65,000 101 41940 01 384.00 Refuse Disposal 39,000 101 41940 01 384.01 General Buildings&Parks 18,982 19,289 19,936 20,000 22,000 Add 2 Parks in 2016 101 41940 01 384.02 Recycling/Cleanup 14,484 15,161 13,373 17,000 17,000 Increased Recycling Costs 101 41940 01 393.00 P.C. Hardware Purchases 850 0 0 0 0 101 41940 01 394.00 P.C.Software Purchases 0 0 0 0 0 Will Share Cartegraph Cost in'18 101 41940 01 401.00 Contracted Building Repairs 60,000 101 41940 01 401.01 Electrical Repairs 7,293 12,970 2,973 8,000 8,000 101 41940 01 401.02 Siren Operations&Maintenance 3,688 4,748 6,648 10,000 7,000 101 41940 01 401.03 Miscellaneous Repafrs 35,205 51,040 49,062 13,000 25,000 101 41940 01 401.04 HVAC Repairs 0 0 0 25,000 20,000 101 41940 01 402.00 Security Card System Maintenance 0 0 0 2,500 5,000 Updates, Prev. Maint.,Tech Supt. 101 41940 01 416.00 Machinery Rental 0 0 0 0 1,500 Lift Rental 101 41940 01 437.00 Conferences&Seminars 0 0 0 200 200 101 41940 01 439.00 Other Miscellaneous Charges 5,950 0 5,573 5,000 6,000 Energy Efficiency Improvements 101 41940 01 530.00 Improvements Other Than Buildings 60,000 85,000 87,833 92,000 92,000 From Long-Term Plan 101 41940 01 601.00 Bond Principal 65,368 0 0 0 0 Will Be Paid from Assigned Funds 101 41940 01 611.00 Bond Interest 19,629 0 0 0 0 Wiil Be Paid from Assigned Funds 101 41940 01 621.00 Bond Paying Agent Fees 0 0 0 0 0 PAGETOTALS 560,247 $512,590 $480,747 $542,100 573,900 DEPARTMENTTOTALS 560,247 $512,590 $480,747 $542,100 573,900 20 Page One 2017 BUDGET WORKSHEETS FLEET MAINTENANCE July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 43100 101.00 Salaries&Benefits 220,400 Salary,Taxes,PERA&Benefits 101 43100 77 101.00 Administrative 10,586 10,933 17,871 25,500 26,600 101 43100 78 101.00 Technicai/Clerical 9,415 9,972 10,144 10,700 11,200 101 43100 79 101.00 Maintenance 158,351 163,952 177,494 172,400 182,600 10143100 102.00 Full-TimeOveRime 1,117 304 1,183 3,000 3,000 101 43100 01 211.00 Cleaning Supplies 4,378 2,685 2,609 4,000 4,000 Shop&Vehicles 101 43100 01 212.00 Motor Fuels 201,394 188,784 162,298 200,000 158,000 Part Moved to Utilities 101 43100 01 213.00 Lubricants&Additives 13,231 10,020 9,811 15,000 15,000 101 43100 01 215.00 Shop Materials 19,270 15,279 13,479 20,000 20,000 101 43100 01 221.00 Equipment Parts 103,190 99,142 103,841 120,000 120,000 101 43100 01 222.00 Tires 24,375 38,757 15,783 30,000 30,000 101 43100 01 241.00 Small Tools 4,249 2,919 4,125 5,000 5,000 Replace Old Tools 101 43100 01 242.00 Minor Equipment 2,544 1,902 5,715 4,000 4,000 101 43100 01 318.00 Contract Engineer 5,000 6,000 3,125 0 0 101 43100 01 321.00 Telephone Costs 0 0 0 0 0 101 43100 01 323.00 Radio Units(Warranty 8 Batteries) 1,830 905 905 1,000 1,000 101 43100 01 384.00 Refuse Disposai 0 0 0 300 300 Shop Hazardous Waste 101 43100 01 394.00 P.C.Software Purchases 6,500 101 43100 01 394.01 Licensing&Maintenance 1,646 1,668 1,735 2,000 2,000 CarteGraph OMS 101 43100 01 394.02 Online Subscriptions 1,997 1,500 2,188 3,000 3,000 ALLDATAlCummings/CAT/Detroit 101 43100 O1 394.03 New Software Purchases 1,860 0 1,200 1,500 1,500 101 43100 01 404.00 Contracted Mach&Equip Services 53,837 65,000 101 43100 01 404.01 Contracted Services 0 60,912 37,772 55,000 55,000 Aging Equipment,FD Units,Towing 101 43100 01 404.02 Contracted Preventative Maint. 0 9,626 11,836 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 DueslSubscriptions/Certifcations 0 0 0 100 300 DOT Cert.ASE Cert.,EVT Cert. 101 43100 01 435.00 Books&Pamphlets 195 48 60 200 200 DOT Decals and Inspection Pads 101 43100 01 437.00 Conferences&Seminars 90 90 157 300 300 PAGE TOTALS 618,556 $ 625,398 $583,331 $683,500 653,500 DEPARTMENT TOTALS 618,556 $ 625,398 $583,331 $683,500 653,500 21 Page One 2017 BUDGET WORKSHEETS STREET MAINTENANCE July 11,2016 Zp 7 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 43121 101.00 Salaries&Benefits 595,700 Salary,Taxes,PERA&Benefits 101 43121 77 101.00 Administrative 21,172 21,866 35,742 51,000 89,000 Added-$36KforAsst.CityEngineer 101 43121 7E 101.00 Technical/Clerical 51,712 55,442 53,541 55,300 54,900 101 43121 75 101.00 Maintenance 408, 540 416,767 429,553 426,300 451,800 101 43121 102.00 Full-Time Overtime 10,343 14,733 9,409 14,000 14,000 Maintenance 101 43121 95 103.00 Part-Time Salaries&Benefits 21,958 15,293 18,916 20,000 21,000 Includes Funds for P/T Horticulturist 101 43121 01 201.00 Office Accessories 500 0 0 100 100 101 43121 01 203.00 Printed Forms&Paper p 101 43121 01 203.01 R/W Permit&Inspection Forms 0 0 0 0 0 101 43121 01 203.03 City Specification Books 0 0 804 0 0 101 43121 01 205.00 Drafting Supplies 700 101 43121 01 205.01 Plotter Ink and Paper 1,275 1,001 374 500 500 Split with 101-45202-01405.00 101 43121 01 205.02 Off-Site Reproductions 160 0 0 200 200 101 43121 01 209.00 Other O ce Supplies 1,480 720 73 700 700 101 43121 01 216.00 Chemical&Chemical Products 128,197 84,057 65,574 103,000 103,000 101 43121 01 224.00 Street Maintenance Materials 14,300 101 43121 01 224.01 Paint 403 314 441 500 500 101 43121 01 224.02 Maii Boxes 1,757 1,357 1,428 1,500 1,500 101 43121 01 224.03 Light Bulbs/Lenses 51 315 68 800 800 Replace with LED Bulbs 101 43121 01 224.04 Holiday Decorations 3,818 3,952 7,951 10,500 9,000 Contraded Tree Lighting 101 43121 01 224.04 Miscellaneous 0 0 0 0 2,500 Fencing,Miscellaneous Supplies 101 43121 01 225.00 Landscaping Materials 16,000 101 43121 01 225.01 Turt Restoration Material 445 2,731 162 3,500 2,000 101 43121 01 225.02 Seed 186 0 108 0 0 101 43121 01 225.03 Black Dirt 599 0 0 0 0 101 43121 01225.04 Trees 155 159 272 500 500 101 43121 01 225.05 Planters&Brackets 2,868 3,150 3,033 3,500 3,500 101 43121 01 225.06 Entrance Monuments 200 1,182 1,665 1,500 1,000 101 43121 01 225.07 Downtown Planters 1,973 1,275 2,034 2,000 2,500 101 43121 01 225.08 Park Signs,Central Park 2,331 2,508 3,464 2,500 3,000 Includes Business Park Sign 101 43121 01 225.09 City Facilities 0 118 1,117 1,500 3,000 CH,RCC,FS1,FS2,LIB,STP,ACT 101 43121 01 225.10 Banners/Flag Components 0 180 0 500 500 101 43121 01 226.00 Sign Repair Materials 4,069 10,827 7,950 6,000 101 43121 01 226.01 Signs and Posts 5,500 5,500 101 43121 01 226.02 Solar Batteries 500 500 101 43121 01 231.00 Bituminous Patching Materials 26,784 27,083 29,722 37,500 37,500 101 43121 01 232.00 Crushed Rock 32,206 30,331 35,628 30,000 30, 000 1/2 Mile of Bacardi Paved in 2015 101 43121 01233.00 Dust Control Materials 26, 188 24,550 31,529 30,000 32,000 Bonaire/Akron=FHR Fields 101 43121 01 234.00 De-Icing Sand/Rock 6,435 4,235 1,161 4,500 4,500 Gravel Road Ice Control 101 43121 01 235.00 Shouldering Gravel 0 0 0 Q 0 101 43121 01 241.00 Smali Tools 632 680 1,357 1,000 1,000 Shovels,Brooms,etc. 101 43121 01 242.00 Minor Equipment 6,490 3,366 2,536 3,000 3,000 Safety Equipment/Power Tools 101 43121 01 303.00 Engineering Fees 26,913 64,776 50,851 10,000 20,000 101 43121 01 303.01 General Non-Project Related 15,000 101 43121 01 303.02 Pavement Management 5,000 101 43121 01 304.00 Legal Fees 0 0 0 0 0 101 43121 01 310.00 Testing Services 0 1,125 0 0 0 101 43121 01 318.00 Contrect Engineer 10,000 12,000 6,250 0 0 101 43121 01 319.00 Other Professional Services 0 0 0 2,000 101 43121 01 319.01 "Future Use" 0 0 0 0 0 101 43121 01 319.02 GIS Consulting Services 344 3,071 2,276 5,000 2,000 Reduce Due to In-Hause Eng. 101 43121 01 321.00 Telephone Costs 2,623 2,629 3,113 3,700 3,700 Includes Wireless Technology 101 43121 01 323.00 Radio Units 1,045 1,367 1,120 1,500 5,100 (24x$300)(12x$1500)( Split 5 Ways) 101 43121 01 331.00 Travel Expense 6 6 242 200 200 101 43121 01 381.00 Electric Utilities 175,100 101 43121 01 381.01 Street Lights 174,559 164,890 163,598 170,000 172,000 101 43121 01 381.02 Signal Lights&Sirens 2,680 2,943 2,592 3,000 3,100 101 43121 01 384.00 Refuse Disposal 1,400 101 43121 01 384.01 Hazardous Waste Disposal 0 1,508 0 500 500 101 43721 01 384.02 Roadside Garbage 572 160 407 900 900 101 43121 01 391.00 P.C.Maintenance 800 101 43121 01 391.03 Pavement Management Syst Sup 8,977 17,550 15,824 10,000 0 Moved to 101-43121-01-303.02 101 43121 01 391.04 R-O-W Permit On-Line Service 536 585 643 800 B00 101 43121 01 392.00 P.C.Accessories&Supplies 0 0 0 0 0 101 43121 01 393.00 P.C.Hardware Purchases 2,093 1,600 0 1,500 1,500 101 43121 01 394.00 P.C.Sokware Purchases 7,200 101 43121 01 394.01 Licensing&Maintenance 4,212 4,371 4,591 6,200 6,200 CarteGraph,OMS,ESRI 101 43121 01 394.02 Online Subscriptions 286 379 379 800 800 Pictometry 101 43121 01 394. 03 New Software Purchases 235 0 0 200 200 PAGETOTALS 998,009 1,007,149 997,497 1,026,200 1,096,500 22 Page Two 2017 BUDGET WORKSHEETS STREET MAINTENANCE July 11,2016 2017 20i6 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Adual Actual Actual Budget Amount Budget Comments 101 43121 01 402.00 Parking Lot Maintenance 25,000 65,000 55,000 60,000 70,000 From Long-Term Plan 101 43121 01 403.00 Contracted Repair&Maintenance 21,500 ""CH,RCC Lots Not Included^^ 101 43121 01 403.01 Street Lights 27,080 786 2,384 5,000 5,000 Street LighUPole Repair/Replace 101 43121 01 403.02 Signal Lights 510 463 488 1,500 1,500 101 43121 01 403.03 Light Replacements 0 18,250 0 15,000 15,000 Conversion to LED 101 43121 01 404.00 Railroad Administration/Mgmt. 1,683 9,574 0 15,000 15,000 QZ Update Due Jan'17,Misc Issues 101 43121 01 405.00 Street Striping 35,469 50,688 10,798 45,000 45,000 101 43121 01 408.00 Street Crack Sealing 55,249 53,349 38,776 60, 000 60,000 Increased Curb Seals 101 43121 01 409.00 Tree Trimming 7,630 8,375 9,071 8,500 10,000 101 43121 01 410.00 Concrete SidewalklCurb Repairs 20,000 101 43121 01 410.01 General Repairs 30,402 14,422 23,493 20,000 20,000 101 43121 01 410.02 Pedestrian improvements 0 0 146,924 0 0 Moved$125,000 to Street CIP 101 43121 01411.00 Contracted Snow Removal 58,000 101 43121 01411.01 Community Center 24,081 19,710 8,961 23,000 23,000 101 43121 01411.02 Steeple Center 15,708 13,712 3,999 15,000 15,000 101 43121 01 411.04 Dakota County Library 20,698 18,305 9,181 20,000 20,000 101 43121 01 415.00 Equipment Rental 21,184 16,328 11,108 22,000 20,500 101 43121 01433.00 Dues&Subscriptions 1,300 101 43121 01433.01 American Public Works Ass'n 820 912 855 1,000 1,000 Annual Membership 101 43121 01433.03 City Engineers'Association 0 0 0 100 100 101 43121 01433.07 MN Street Superintendent Ass'n 100 100 100 200 200 101 43121 01 433.09 MN Transportation Alliance 0 788 804 0 0 101 43121 01 437.00 Conferences&Seminars 6,200 101 43121 01 437.01 APWA 1,765 1,780 0 3,000 2,000 State/NaYI Conference in 2016 101 43121 01 437.03 Clerical 0 0 0 0 0 101 43121 01 437.05 Maintenance Expo 0 0 134 300 300 101 43121 01437.06 Cartegraph,ESRI,GIS 237 161 0 1,300 1,300 User Group,Conference,Training 101 43121 01 437.07 Snow Conference 0 0 177 300 300 101 43121 01 437.08 MN Dot 0 0 0 300 300 Simulator 101 43121 01 437.09 Miscellaneous Training 1,924 576 615 2,000 2,000 DCTC Defensive Driving Training 101 43121 01 439.00 Other Miscellaneous Charges 915 1,199 448 500 500 Host CONDAC,RL Notary 101 43121 01 570.00 Office Equipment&Furnishings 0 644 0 0 0 PAGETOTALS 270,456 $295,122 $323,315 $ 319,000 328,000 DEPARTMENTTOTALS 1,268,465 $1,302,271 $1,320,812 $1,345,200 1,424,500 23 Page One 2017 BUDGET WORKSHEETS PARKS 8 GROUNDS MAINTENANCE July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 45202 101.00 Salaries&Benefits 447,400 Salary,Taxes,PERA&Benefits 101 45202 77 101.00 Administrative 21,172 21,866 25,685 30,200 37,200 Add$6K for Asst.City Engineer 101 45202 78 101.00 Technical/Clerical 18,829 19,944 20,288 21,400 22,300 101 45202 79 101.00 Maintenance 337,975 340,619 324,310 363,300 387,900 Added$62.4K-75%of New Person 101 45202 102.00 Full-Time Overtime 15,864 12,615 4,617 14,000 8,000 Reduce 0/T with New Position 101 45202 99 103.00 Part-Time Salaries&Benefits 53,181 51,085 52,927 63,000 55,800 Reduce Horticulturist&Eliminate 1 101 45202 01 205.00 Plotter Ink and Paper 57 197 91 500 500 Split with 101-43121-01-205.01 101 45202 01 216.00 Chemical& Chemical Products 22,150 28,338 31,794 35,000 47,500 Jpn Btti'16-18,Add in-house chem 101 45202 01 219.00 Other Operating Supplies 35,000 101 45202 01 219.01 Seed,Sod,etc. 4,722 4,948 3,962 6,000 6,000 FHR Fields Online in 2014 101 45202 01 219.02 Red Rock,Sand,Gravel,etc.9,448 8,830 10,449 10,000 14,000 Topdressing Program 101 45202 01 219.03 Repair Supplies 0 0 0 0 0 101 45202 01 219.05 Wood Chips 12,691 12,000 12,000 15,000 15,000 Playgrounds 101 45202 01 220.00 Splash Pad Maintenance 0 0 8,899 7,500 2,500 Supplies 101 45202 01 221.00 Equipment Parts 18,500 101 45202 01 221.01 Playground Equipment Repair 7,847 5,459 5,812 8,000 8,000 Repairs on Aging Equipment 101 45202 01 221.02 Irrigation Repair(In-House) 3,487 6,357 6,962 8,000 8,000 101 45202 01 221.03 Miscellaneous 2,340 2,397 2,204 2,500 2,500 Ballfield Fence Repair 101 45202 01 221.04 Park Sign Replacements 0 0 0 0 0 101 45202 01 223.00 Shelter Repair Supplies 2,400 101 45202 01 223.01 Paint,Stain,etc. 383 606 862 1,500 800 101 45202 01 223.02 Shingles, Boards,etc. 569 784 324 1,500 600 101 45202 01 223.03 Miscellaneous 992 1,016 629 1,500 1,000 101 45202 01 223.04 Shelter/Shed Repairs 2,200 829 147 0 0 Paid from Building Maint.Budget 101 45202 01 225.00 Landscaping Materials 3,000 101 45202 01 225.01 Trees,Shrubs,etc. 1,459 1,200 1,779 2,500 2,000 101 45202 01 225.02 Timbers, Fence,etc.2,775 70 132 2,500 1,000 Fieid Fence Maintenance 101 45202 01 226.00 Sign Repair Materials 0 0 0 500 500 101 45202 01 229.00 Other Maintenance Supplies 21,173 9,728 14,101 20,000 18,000 Paint,Chalk,Field Dry,Etc. 101 45202 01 241.00 Small Tools 1,734 1,560 1,738 2,500 2,000 Hand Tools,Blades,Bits,etc. 101 45202 01 242.00 Minor Equipment 1,972 2,576 4,340 5,000 5,000 Weed Whips,Chain Saws,etc. 101 45202 01 303.00 Engineering Fees(GIS) 0 0 0 5,000 2,000 Reduce Due to In-House Engineer 101 45202 01 318.00 Contract Engineer 2,500 3,000 1,562 0 0 101 45202 01 319.00 Other Professional Services 11,000 101 45202 01 319.01 Maintenance of Open Spaces 347 18,697 4,738 9,000 7,000 Prairies,Controlled Burns,etc. 101 45202 01 319.02 Landscaping&Flower Beds 3,924 8,142 9,456 6,000 4,000 Reduced Both Due to New Person 101 45202 01 321.00 Telephone Costs 3,915 3,927 3,836 5,000 5,000 All Wireless,Including iPad 101 45202 01 323.00 Radio Units 1,045 1,367 1,120 1,500 5,100 (24x$300)(12x$1500)(Split 5 Ways) 101 45202 01 381.00 Electric Utilities 24,000 Anticipated Rate Increase 101 45202 01 381.01 Skating Rinks 8,342 6,370 6,235 8,500 8,500 Service Connect/Disconnect 101 45202 01 381.02 Softbali Fields 7,328 6,379 7,843 8,500 8,500 101 45202 01 381.03 Irrigation 6,339 6,651 5,507 8,000 7,000 Umore 2013,Flint Hilis 2014 101 45202 01 383.00 Gas Utilities 2,070 2,287 1,684 2,500 2,500 101 45202 01 393.00 P.C. Hardware Purchases 2,833 1,600 0 1,000 1,000 101 45202 01 394.00 P.C. Software Purchases 7,200 101 45202 01 394.01 Licensing&Maintenance 4,212 4,371 4, 591 6,200 6,200 Cartegraph,OMS,ESRI 101 45202 01 394.02 Online Subscriptions 286 379 379 800 800 Pictometry 101 45202 01 394.03 New Software Purchases 235 0 0 200 200 PAGE TOTALS 586,398 596,193 581,005 684,100 703,900 24 Page Two 2017 BUDGET WORKSHEETS PARKS&GROUNDS MAINTENANCE July 11,2016 zp 7 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 45202 01 403.00 Contracted Repair&Maintenance 10,000 101 45202 01 403.01 Irrigation Repairs 2,070 9,806 2,425 8,000 5,000 RPZ-Inspect 101 45202 01 403.02 Electrical Repairs 2,811 2,479 1,462 3,000 3,000 101 45202 01 403.03 Miscellaneous Repairs 575 1,425 3,654 1,000 2,000 Hard Court Fencing 101 45202 01 409.00 Other Contracted Repair&Maint 22,500 101 45202 01 409.01 Spring Clean Up 0 0 0 1,200 1,200 Dethatching, Flower Beds,etc. 101 45202 01 409.02 Library/Steeple Center/RCC 9,374 8,521 9,081 9,500 10,000 Mowing!Chemicals-VonBank 101 45202 01 409.03 Fire Station#1 4,080 3,834 4,087 4,200 0 Eliminate with New Person Added 101 45202 01 409.04 Fire Station#2 2,867 2,556 2,724 3,000 0 Eliminate with New Person Added 101 45202 01 409.05 City Hall/Central Park 6,948 6,391 6,811 7,000 0 Eliminate with New Person Added 101 45202 01 409.06 UMore Baseball Fields 15,000 2,980 3,844 5,000 5,300 Chemicals-VonBank 101 45202 01 409.07 FHR Soccer Fields 0 2,451 5,901 5,000 6,000 Chemicals-VonBank 101 45202 01 416.00 Machinery Rental 26,000 101 45202 01 416.01 Mower Leases 16,203 15,161 18,000 21,000 21,000 3 Mowers 101 45202 01 416.02 Miscellaneous Rentals 7,372 4,092 4,478 5,000 5,000 Gator(Utility Vehicle for Ballfields) 101 45202 01 433.00 Dues&Subscriptions 200 101 45202 01 433.01 MN Park Supervisors Ass'n 0 50 0 50 50 101 45202 01 433.02 Miscellaneous Dues 90 0 75 150 150 101 45202 01 435.00 Books&Pamphlets 0 0 263 0 0 101 45202 01 437.00 Conferences&Seminars 3,800 101 45202 01 437.01 Seminars&Workshops 719 2,001 1,334 1,200 1,500 Green Expo,MPSA, Playgrounds 101 45202 01 437.02 School&Tuition 1,031 465 624 1,300 1,300 Turf School,Power Limited Tech. 101 45202 01 437.03 CarteGraph,ESRI,GIS 120 126 0 1,300 1,000 User Group,Conference,Training 101 45202 01 439.00 Other Miscellaneous Charges 224 39 48 200 200 Contingencies 101 45202 01 530.00 Improvements Other Than Bldgs 75,000 135,286 149,439 160,000 175,000 From Long-Term Plan PAGE TOTALS 144,486 $197,663 $214,249 $237,100 237,700 DEPARTMENT TOTALS 730,884 $793,855 $795,254 $921,200 941,600 25 Page One 2017 BUDGET WORKSHEETS PARKS 8 RECREATION July 11,2016 2p 7 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Sa ary Costs Inclusive of 101 45100 101.00 Salaries&Benefits 741, 601 $762,122 $748,284 $804,100 832,800 Salary,Taxes,PERA&Benefits 101 45100 102.00 Full-Time Overtime 5,660 3,018 1,372 5,000 5,000 Upgrades for Coord,Lead Pay"^ 101 45100 103.00 Part-Time Salaries 8 Benefits 191,400 101 45100 10 103.00 PIf Receptionist 36,758 37,221 44,930 46,000 38, 300 101 45100 12 103.00 Building Attendants 55,230 46, 178 53,567 54,000 54,000 101 45100 15 103.00 P(f Recreation Coordinator 0 0 13,296 35,100 52,600 101 45100 83 103.00 Playground Recreation Leaders 26,362 23, 195 25,026 26,000 29,500 101 45100 94 103.00 Warming House Attendants 16,287 10,347 10,162 15,000 15,000 101 45100 99 103. 00 Park&Rec Committee 1,920 1,420 1,464 2,000 2,000 101 45100 01 203.00 Printed Forms&Paper 0 0 0 0 0 101 45100 01 205.00 Drafting Supplies 25 0 500 500 500 Laminating 101 45100 01 207.00 Training&instructional Supplies 0 0 0 0 0 101 45100 01 208.00 Miscellaneous Supplies 0 0 0 0 0 101 45100 01 209.00 Other Office Supplies 190 259 873 500 500 Envelopes,Forms,Ruiers,etc. 101 45100 01 211. 00 Cleaning Supplies 5,233 3,573 4,553 4,500 4,500 101 45100 01 216.00 Chemicals&Chemical Products 282 689 527 0 0 Moved to"211.00" 101 45100 01 219.00 Other Operating Supplies 10,052 7,593 9,438 8,000 8,000 Rec Programs,1stAid Sup,etc. 101 45100 01 221.00 Equipment Parts 7,074 6,772 9,599 8,000 6,000 101 45100 01 223.00 Building Repair Supplies 2,536 649 2,039 1,500 1,500 101 45100 01 229.00 Other Maintenance Supplies 5,367 9,736 4,635 9,000 6,000 Tournament Supplies 101 45100 01 312.00 Custodial Services 5,990 4,461 5,450 6,000 6,000 Custodial Services-Banquet Rm 101 45100 01 315.00 Special Programs 20,000 101 45100 01 315.01 Sunday Night Specials 5,039 4,873 5,326 5,500 5,500 Performances(Add Movies) 101 45100 01 315.02 Leprechaun Days 200 910 400 250 250 101 45100 01 315.03 Umore Maint.Agreement 4,000 2,000 2,038 2,000 2,000 101 45100 01 315.04 Ground Pounders(Running) 169 200 225 200 200 Ribbons&Mailings 101 45100 01 315.05 Nature Programs(Arbor Day) 4,741 0 221 0 0 Move to 101-41110-01-225.00 101 45100 01 315.06 Puppet Programs 54 0 189 150 150 Tapes,Fuses,Puppets,etc. 101 45100 01 315.07 Special Events 3,055 849 1,512 3,000 2,000 Publicity&Supplies(Winter Fest) 101 45100 01 315.08 Adopt-A-Park Program 67 54 50 500 500 Flyers,Signs 101 45100 01 315.09 Miscellaneous Programs 4,004 2,223 1,680 4,500 9,000 Community Gardens/Senior Prog 101 45100 01 315.10 ADA Programs 0 0 0 400 400 ADA Program Supplies 101 45100 01 319.00 Other Professional Services 431 6,964 6,802 6,000 6,000 ADA Services/Eng.LA Serv Test 101 45100 01 321.00 Telephone Costs 3,750 3,904 4,354 4,000 4,000 Pagers&Cellular Phones 101 45100 01 331.00 Travel Expense 874 253 493 1,000 1,000 101 45100 01 341.00 Employment Advertising 0 0 0 0 0 101 45100 01 349.00 Other Advertising 33,400 101 45100 01 349.01 Brochures 29,427 28,574 29,572 29,000 29,000 City Newsletter(3 Per Year) 101 45100 01 349.02 Yellow Pages 643 385 391 1,500 500 Rec Ads 101 45100 01 349.03 Special Marketing 5,043 4,522 4,806 3,900 3,900 Garage Sale Ad 101 45100 01 381.00 Electric Utilities 37,269 33,207 30,874 30,000 30,000 101 45100 01 383.00 Gas Utilities 28,636 34,036 21,845 30,000 30,000 101 45100 01 384.00 Refuse Disposal 3,066 3,062 3,062 4,000 3,200 101 45100 01 392.00 P.C.Accessories&Supplies 0 0 0 0 0 101 45100 O1 393.00 P.C.Hardware Purchases 0 0 0 0 D 101 45100 01 394.00 P.C.Software Purchases 0 0 0 0 0 See"433.03"Below 101 45100 01 401.00 Contracted Building Repairs 14,693 13,070 9,771 12,000 12,000 101 45100 01 404.00 Contracted Mach&Equip Repairs 13,012 13,542 13,647 9,000 9,000 101 45100 01 409.00 Other Contracted Repair&Maint 24,599 26,330 24,143 24,000 24,000 Air Handler Maintenance Contract 101 45100 01 412.00 Building Rental 16,800 16,800 16,800 16,800 16,800 Monthly Rent Payments to Guard 101 45100 01 415.00 Other Equipment Rental 22,872 22,480 24,749 24,000 24,000 Portable Toilets&Other(New Pks) 101 45100 01 433.00 Dues&Subscriptions 6,400 101 45100 01 433.01 MRPA Dues 1,520 1,520 1,809 1,700 1,700 Minn Recreation& Parks Ass'n 101 45100 01 433.02 Miscellaneous 2,469 2,445 2,515 2,000 2,000 Paper,Magazines,etc. 101 45100 01 433.03 On-Line RegistraYn Subscription 1,620 2,053 2,025 2,700 2,700 I01 45100 01 435.00 Books 8 Pamphlets 0 0 0 100 100 101 45100 01 437.00 Conferences&Seminars 6,000 101 45100 01 437.01 MRPA State Conference 1,065 1,604 1,353 2,000 2,000 101 45100 01 437.03 Workshops,Schools,&Tuition 2,334 1,191 2,008 4,000 4,000 Additional Training 101 45100 01 439.00 Other Miscellaneous Charges 8,869 13,378 7,721 0 0 Donation Account 101 45100 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 PAGE TOTALS 1,160,888 $1,157,660 $1,156,093 $1,249,400 1,290,100 GeneralOperating DEPARTMENTTOTALS 1,160,888 $1,157,660 $1,156,093 $1,249,400 1,290,100 26 Page Two 2017 BUDGET WORKSHEETS PARKS 8 RECREATION STEEPLE CENTER"' July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Adual Budget Amount Budget Comments 101 38201.00 Rental Revenues 11,910 $4,800 0 $ 18,000 28,000 101 38205.00 AN Rental Revenues 0 0 0 500 2,000 101 38209.00 Miscellaneous Revenues 0 175 0 0 0 101 38211.00 Security Services 1,729 651 0 1,000 2,000 TOTAL REVENUES 13,639 $5,626 Y $ 0 $19,500 32,000 2015 Closed for Construction 101 45100 30 103.00 Salaries&Benefits 52,000 Salary, Taxes,PERA&Benefits 101 45100 30 103. 00 Building Attendants 13,485 5,177 1,639 34,000 52,000 Staff^^ 101 45100 30 211.00 Cleaning Supplies 1,849 1,059 822 4,000 4,000 101 45100 30 219.00 Other Operating Supplies 2,531 2,704 4,855 2,500 2,500 Events Supplies 101 45100 30 221.00 Equipment Parts 656 0 6,099 1,500 1,500 101 45100 30 223.00 Building Repair Supplies 3,422 4,444 3,134 5,500 5,500 101 45100 30 241.00 Small Tools 187 0 0 500 500 101 45100 30 242.00 Minor Equipment 1,012 191 353 2,000 2,000 101 45100 30 312.00 Custodial Services 1,357 299 450 2,000 2,000 101 45100 30 321.00 Telephone Costs 1,760 219 547 3,000 3,000 101 45100 30 349.00 Other Advertising 0 0 0 600 600 101 45100 30 365.00 Workers'Comp Insurance 0 0 0 0 0 Pay from Insurance Fund 101 45100 30 369.00 Other Insurance 0 0 0 0 0 Pay from Insurance Fund 701 45100 30 381.00 Electric Utilities 5,319 5,485 10,472 6,500 6,500 101 45100 30 383.00 Gas Utilities 7,971 10,065 6,934 10,000 10,000 101 45100 30 384.00 Refuse Disposal 1,150 1,068 0 1,800 1,800 101 45100 30 401.00 Contracted Building Repairs 5,645 14,069 17,266 9,000 9,000 101 45100 30 404.00 Contracted Mach&Equip Repairs 6,265 4,803 2,334 7,000 7,000 101 45100 30 409.00 Other Contracted Repairs&Main 0 1,532 0 2,500 2,500 Holiday Lights 101 45100 30 415.00 Other Equipment Rental 0 0 0 1,000 1,000 101 45100 30 439.00 Other Miscellaneous Charges 0 0 0 0 0 101 45100 30 521.00 Building&Structure Purchases 0 0 0 0 0 PAGE/EXPENDITURE TOTALS $52,608 $51,115 $54,906 $93,400 111,400 2015 Combined Steeple Center/ Activity Center Expenditures 27 Page Three 2017 BUDGET WORKSHEETS PARKS S RECREATION July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 91,800 101 45100 80 Art Classes 0 0 0 0 0 101 45100 81 Softball 34,384 25,390 20,188 23,500 23,500 101 45100 84 Tennis 1,943 2,379 2,292 2,000 2,200 101 45100 86 Rosettes 1,927 2,363 2,098 2,000 2,000 101 45100 87 Senior Programs 7,035 5,754 7,711 6,000 6,000 101 45100 90 Run forthe Gold 4,892 4,878 4,890 4,500 4,800 101 45100 91 Camps 27,510 24,778 30,904 24,000 30,000 101 45100 92 Adult Basketball 0 0 (139) 600 600 1014510093 OtherPrograms 11,740 12,751 11,964 14,000 14,000 101 45100 95 T-Ball 4,308 5,720 4,261 5,000 5,000 101 45100 96 Teen Night 882 350 986 0 900 101 45100 97 Adult Soccer League 11,209 8,835 0 0 0 No Longer Offered 101 45100 98 Youth Soccer Lessons 3,179 2,894 2,117 2,800 2,800 109,009 96,092 87,272 84,400 91,800 101 45100 80 219.00 Operating Supplies 0 0 0 0 0 101 45100 81 103.00 Part-Time Salaries 5,345 4,083 3,748 3,500 3,500 101 45100 81 219.00 Operating Supplies 6,386 2,679 3,327 2,500 2,500 101 45100 81 311.00 Officiating Fees 20,575 17,323 12,261 16,000 16,000 101 45100 81 319.00 Other Professional Services 2,079 1,305 851 1,500 1,500 101 45100 84 103.00 Part-Time Salaries 1,673 1,935 2,216 1,500 1,700 101 45100 84 219.00 Operating Supplies 270 444 75 500 500 101 45100 86 103.00 Part-Time Salaries 817 870 1,104 1,000 1,000 101 45100 86 219.00 Operating Supplies 1,110 1,493 994 1,000 1,000 101 45100 87 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 87 219.00 Operating Supplies 6,000 101 45100 87 219.01 Youth/Teen Trips Supplies 0 0 0 500 0 101 45100 87 219.02 AdulUSenior Supplies 7,035 5,754 7,711 5,500 6,000 101 45100 90 219.00 Operating Supplies 4,892 4,878 4,890 4,500 4,800 101 45100 91 103.00 PaR-Time Salaries 14,013 10,724 15,934 9,000 16,000 101 45100 91 219.00 Operating Supplies 13,498 14,054 14,970 15,000 14,000 101 45100 92 219.00 Operating Supplies 0 0 (139) 600 600 101 45100 93 103.00 PaR-Time Salaries 2,232 3,842 5,582 3,000 3,000 101 45100 93 219.00 Operating Supplies 9,507 8,909 6,382 11,000 11,000 101 45100 93 319.00 Other Professional Services 0 0 0 0 0 101 45100 95 103.00 Part-Time Salaries 2,878 4,095 3,043 3,500 3,500 101 45100 95 219.00 Operating Supplies 1,430 1,626 1,218 1,500 1,500 101 45100 96 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 96 219.00 Operating Supplies 882 350 986 0 900 101 45100 97 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 97 219.00 Operating Supplies 1,609 5,595 0 0 0 No Longer Offered 101 45100 97 311.00 Officiating Fees 9,600 3,240 0 0 0 No Longer Offered 1014510098 103.00 Part-TimeSalaries 2,38 2,147 1,444 1,800 1,800 1014510098 219.00 OperatingSupplies 1,040 747 672 1,000 1,000 SPECIAL PROGRAM TOTALS 109,009 96,092 87,272 84,400 91,800 GRAND TOTAL- PARK&REC $1,322,504 $1,304,867 $1,298,271 $1,427,200 1,493,300 28 Page One 2017 BUDGET WORKSHEETS OTHER FINANCING USES July 11,2016 2016 2015 Object 2016 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101-49300-01 710.00 Transfers 115,000 $115,000 $130,000 $130,000 130,000 101-49300-01 710.01 Arena Operations Assistance 0 0 0 0 130,000 101-49300-01 710.02 Debt Service Levies 0 0 0 0 0 101-49300-01 720.00 Transfers 0 360,000 500,000 0 0 Excess F/B Transfers FUND TOTALS 115,000 $475,000 $ 630,000 $130,000 130,000 29 Page One 2017 BUDGET WORKSHEETS INSURANCE-REVENUES July 11,2016 2017 2016 Object 2017 2013 2014 2015 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 $245,000 260,000 206 33100.00 Federal Grants&Aids 0 0 0 0 0 206 36210.00 Interest Earnings-Investments 6,562 4,103 4,682 4,000 4,000 206 36214.00 Net Change in FV-Investments 0 0 0 0 0 Annual Market Value Changes 206 36215.00 Interest Earnings 46 33 91 100 100 206 36260.00 Other Revenue 52,280 244,491 86,393 30,000 30,000 Insurance Refunds/Dividends 206 36265.00 Use of Reserve Funds 0 0 0 39,500 60,900 (2014-$217,000 Hail Damage) FUND TOTALS 303,887 493,627 336,166 318,600 355,000 INSURANCE-EXPENDITURES 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 206 49006 01 221.00 Equipment Parts 515 $4,187 $7,049 $5,000 5,000 Liability& Auto Deductible Pymts 206 49006 01 304.00 Legal Fees 500 1,755 0 1,000 1,000 Unreimbursable Legal Fees 206 49006 01 305.00 Medical&Dentai Fees 11,489 6,949 6,379 7,500 7,000 Work Comp Deductible Pymts 206 49006 O1 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,000 6,250 6,000 6,500 206 49006 01 319.02 CHESS Consultant 12,300 12,540 12,720 12,600 13,000 206 49006 01 365.00 Worker's Compensation Insurance 112,964 112,534 131,630 114,000 135,000 Annual Premium 206 49006 01 369.00 Other Insurance 89,163 98,607 108,529 100,000 110,000 Annual Premium-General Liability Changed to High Deductible) 206 49006 01 403.00 Contracted R&M-Other Impr. 0 20,332 5,533 0 0 Liability&Auto Deductible Pymts 206 49006 01 409.00 Other Contracted Repair&Maint 65,465 274,248 73,694 70,000 75,000 Liability& Auto Deductible Pymts 206 49006 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 206 49006 01 550.00 Motor Vehicle Purchases 37,176 21,730 0 0 0 2013 8 2014-Replace Vehicle FUND TOTALS 338,072 561,381 354,284 318,600 355, 000 (Changed to High Deductible) NOTE: Levy of$260,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 levies,interest earnings,insurance refunds/dividends and reserve funds. 30 Page One 2017 BUDGET WORKSHEETS PORT AUTHORITY-REVENUES July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 201 31010.00 CurrentAd Valorem Taxes 58,000 $58,000 $58,000 $58,000 58,000 Operating Levy 201 31050.00 Tax Increments 0 0 0 0 0 Admin Fees Portion Only 201 32280.00 Fiber License Fees 0 0 0 2,400 2,400 201 33130.00 Federal Grants-CDBG 0 0 0 0 0 201 33425.00 Other State Grants&Aids 0 734,060 287,090 0 0 LCA Grant-Land/Bldg Acquisition 201 33620.00 Other County Grants&Aids 0 6,600 0 0 0 Dakota Cty-South Gateway 201 34109.00 Other Charges for Services 0 0 0 0 0 Genz-Ryan Tenant Utility Pymts 201 36210.00 Interest Earnings- Investments 50 49 74 100 100 Interest Earned on CD's 201 36215.00 Interest Earnings 35 33 58 100 100 Checking Interest&Misc 20136230.00 Contributions/Donations 0 0 0 0 0 201 36260.00 Other Revenue 0 763 0 0 0 201 36265.00 Use of Reserve Funds 0 0 0 14,000 0 201 39101.00 Sales of General Fixed Assets 0 0 0 0 0 FUND TOTALS 58,086 $799,505 $ 345,222 $74,600 60,600 EXPENDITURES 2017 2016 Object 2017 2013 2014 2015 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 8 Benefits 6,079 $5,511 $11,171 0 0 Part-Time Intern 201 46300 99 103.00 Part-Time Salaries&Benefits 2,509 2,305 3,008 4,000 4,000 Port Authority Members 201 46300 01 303.00 Engineering Fees 0 0 0 2,000 2,000 201 46300 01 304.00 Legal Fees 1,645 8,422 4,912 3,000 5,000 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 19,000 201 46300 01 319.01 Project Management Consultant 0 0 0 2,000 2,000 201 46300 01 319.02 Marketing-REDE-City Share 10,020 10,000 14,373 10,000 10,000 Twin Cities Marketing Initiative 201 46300 01 319.03 County TIF Charges 0 0 0 0 0 Moved to TIF Fund 201 46300 01 319.04 P/A Property Tax Payments 0 0 0 0 0 201 46300 01 319.05 Other Consultants 0 0 0 5,400 7,000 Downtown Update 201 46300 01 319.06 South Gateway Study 0 11,553 0 0 0 Dakota Cty-South Gateway 201 46300 01 319.07 Bu on Project 0 16,667 16,667 17,000 0 201 46300 01 322.00 Postage Costs 446 0 0 0 0 201 46300 01 331.00 Travel Expense 0 0 0 0 0 201 46300 01 349.00 Other Advertising 7,094 9,216 14,217 10,000 12,000 Additional Marketing 201 46300 01 359.00 Other Printing&Binding Costs 0 902 100 3,000 1,500 201 46300 01 365.00 Workers Comp Insurance 540 530 604 500 700 Commissioners 201 46300 01 369.00 Other Insurance 394 409 440 2,000 500 Property Insurance 201 46300 01 381.00 Electric Utilities 309 190 130 500 400 Business Park&Other PropeRies 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 0 Utility Fees 201 46300 01 403.00 Contracted Repairs&Maintenance 0 0 0 2,000 2,000 Contracts for Fiber 201 46300 01 433.00 Dues 8 Subscriptions 2,000 Prof Organizations/Journais 201 46300 01 433.01 Professional Organizations/Journ 1,806 2,088 2,392 1,700 2,000 201 46300 01 433.02 Foreign Trade Zone Comm(ssion 0 0 0 0 0 201 46300 01 437.00 Conferences 8 Seminars 4,249 1,277 7,349 5,000 5,000 DevelopmenUTIF/Miscellaneous 201 46300 01 439.00 Other Miscellaneous Charges 434 172 0 500 500 Contingencies 201 46300 01 521.00 Building&Structure Purchases 0 0 0 0 0 201 46300 01 525.00 Building 8 Structure Purchases 0 652,781 287,090 0 0 LCA Grant-Land/ Bldg Acquisition 201 46300 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 201 46300 01 710.00 Transfers 0 0 86,437 0 0 FUND TOTALS 41,525 $ 728,022 $454,890 $74,600 60,600 31 Page One 2017 BUDGET WORKSHEETS WATER UTILITY REVENUES- July 1'I,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 33425.00 Other State Grants&Aids 0 $9,901 0 0 4,500 MCES Water Efficiency Grant 601 34108.00 Administrative Fees-Other Funds 2,497 3,931 6,828 0 0 5%of 5%Fees-Const Projects 601 34109.00 Other Gen'I Govt Chgs for Services 12,250 15,820 5,850 0 0 601 36101.00 Principal-Special Assessments 55,362 56,217 54,299 57,000 57,000 601 361 D2.00 Penalties&Interest-S/A 224 (847)57 0 0 601 36210.00 Interest Earnings-Investments 57,119 105,027 97,236 60,000 60,000 601 36214.00 Net Change in FV-Investments (125,524) 96,607 (5,138) 0 0 Annual Market Value Changes 601 36215.00 Interest Earnings 70 65 280 200 200 601 36220.00 Rents&Royalties 88,052 107,624 158,580 140,000 148,500 Antenna Leases 601 36260.00 Other Revenues 128 0 0 0 0 ^^Added Verizon Antenna^^ 601 36265.00 Use of Reserve Funds 0 0 0 0 0 601 37110.00 Residential Water Revenues 1,155,429 1,100,286 1,090,820 1,350,000 1,200,000 Est$6K Lost Rev from Rebate Prog. 601 37120.00 Apartment Water Revenues 83,470 84,079 94,071 100,000 100,000 60137125.00 InstitutionalWaterRevenues 70,541 61,957 69,187 78, 000 75,000 601 37130.00 Commercial Water Revenues 79,091 79,817 81,477 95,000 85,000 601 37140.00 Industrial Water Revenues 123,072 113,947 164,347 140,000 150,000 601 37160.00 Penalties-Water Revenues 9,896 9,280 10,506 9,500 9,500 601 37165.00 Meter Maint Water Revenues 0 0 0 0 0 601 37170.00 Other Water Revenues 0 2,800 592 0 0 601 37180.00 Water Meter Sales Revenue 46,529 37,385 49, 058 45,000 45,000 601 39103.00 Gain or Loss from F/A Disposal 144) 0 (494) 0 0 60139203.00 TransferFrom 24,443 0 89,101 0 0 FUND TOTALS 1,682,505 $1,883,897 $1,966,658 $2,074,700 1,934,700 32 Page One 2017 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES- July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Accual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 601 49400 101.00 Salaries&Benefits 512,300 Salary,Taxes,PERA&Benefits 601 49400 77 101.00 Administrative 117,500 117,387 139,529 144,900 176,100 Added-$24K forAsst City Engineer 6014940078 101.00 Technicai/Clerical 142,778 151,671 151,280 158,800 160,500 601 49400 79 101.00 Maintenance 157,164 163,437 165,527 172, 300 175,700 601 49400 oc 101.00 Salary&Benefit Contingency 0 0 0 0 0 601 49400 102.00 Full-Time OveRime 15,629 13,810 9,705 8,000 8,000 601 49400 103.00 Part-Time Salaries&Benefits 5,697 6,508 5,132 8,000 7,000 601 49400 99 103.01 Utility Commission Wages(50%) 1,000 50%-601; 50%-602 601 49400 99 103.02 Maintenance Labor 6,000 100%-601 601 49400 01 203.00 Printed Forms&Paper 1,742 2,075 1,005 2,200 2,200 Inserts&Water Bill Statements 601 49400 01 209.00 Other Office Supplies 1,459 186 168 200 200 601 49400 01 212.00 Motor Fuels 0 0 0 0 5,600 601 49400 01 216.00 Chemicals&Chemical Products 58,454 51,562 48,581 70,000 75,000 ChlorinelFlouride/Poly(Add Well 16) 601 49400 01 219.00 Other Operating Supplies 331 250 50 300 300 Maintenance Supplies 601 49400 01 220.00 Water Meter Purchases 107,500 Meters,MIU's 8 CU Horns 601 49400 01 220.01 For Replacements 43,441 13,930 16,142 60,000 62,500 New Meter Standards 601 49400 01 220.02 For New Homes 61,704 68,837 74,982 45,000 45,000 From Water Rate Model 601 49400 01 224.00 Street Maintenance Materials 0 0 640 2,500 2,500 Patching for Breaks 601 49400 01 225.00 Landscaping Materials 845 0 60 500 500 Topsoil,Seed&Sod 601 49400 01 228.00 Meter Repair Materials 29 490 0 0 0 601 49400 01 229.00 Other Maintenance Supplies 26,000 601 49400 01 229.01 Supplies for Hydrants 3,332 6,622 6,619 6,000 8,000 601 49400 01 229.02 Curb Shutoffs 565 653 252 1,000 1,000 601 49400 01 229.03 GV Repair/Replacement 0 11,973 303 12,000 12,000 Repairs Done By City Staff 601 49400 01 229.04 Misceilaneous Supplies 3,355 2,581 2,074 5,000 5,000 601 49400 01 241.00 Small Tools 614 702 626 2,000 2,000 Wrenches,Shovels,etc. 601 49400 01 242.00 Minor Equipment 2,860 2,966 5,113 3,000 12,000 Hydrant Tooi(2 x$4500 each) 601 49400 01 303.00 Engineering Fees 78,000 601 49400 01 303.01 WHPP 0 0 0 5,000 5,000 Groundwater Plan Implementation 601 49400 01 303.02 GIS 516 4,607 3,413 5,000 3,000 Reduce Due to In-House Engineer 601 49400 01 303.03 Rate Study 0 0 0 15,000 15,000 Part of Comp Plan Update 601 49400 01 303.04 Miscelianeous Fees 20,093 29,118 68,392 20,000 55,000 Water Facility Study in'17($50K) 601 49400 01 304.00 Legal Fees 0 0 0 1,000 1,000 601 49400 01 310.00 Testing Services 47,000 601 49400 01 310.01 Bacteria 8 Water Quality 1,585 1,560 1,966 2,000 2,000 Radon,Tri-Chl.,Pesticides,Etc. 601 49400 01 310.03 MDH Service Connection Fee 43,149 43,552 44,475 45,000 45,000 6.36/Connection- Annual Fee 601 49400 01 312.00 Gopher State One-Call 2,303 2,770 1,655 2,500 2,500 $7,500 Split 3 Ways 601 49400 01 318.00 Contract Engineer 10,000 12,000 6,250 0 0 601 49400 01 319.00 Other Professional Services 30,000 601 49400 01 319.01 Thaw Pipes,Check Leaks,etc. 0 32,250 0 1,500 1,500 601 49400 01 319.02 Supervisory Controls 15,648 6,562 3,575 5,000 12,500 SCADA,Summit Loggers-$ 7500 601 49400 01 319.03 Hazardous Chemical Permits 725 725 725 1,000 1,000 MN Department of Public Safety 601 49400 01 3'19.06 Contracted Hydrant Painting 10,004 10,120 10,028 10,000 11,000 110 Hydrants/Yr($92 each) 601 49400 0 319.07 Antenna Expenses 12,563 19,904 15,458 0 0 601 49400 01 319.08 Buxton Project 0 5,556 5,556 5,600 0 601 49400 01 319.09 HVAC Maintenance Contract 0 0 0 0 4,000 Annual Insp/Maint,Ail Wells 601 49400 01 320.00 Credit Card Activity Fees 3,324 5,372 6,797 6,000 7,000 1/3 Cost of C/C Pymt Processing 601 49400 01 321.00 Telephone Costs 2,745 3,003 3,122 3,500 3,500 Cell Phones,Modesm,GPS 601 49400 01 322.00 Postage Costs 4,556 4,173 4,296 5,000 5,000 Billings with Inserts 601 49400 01 323.00 Radio Units 1,045 1,367 1,120 1,500 5,100 (24x$300)(12x$1500)(Split 5 Ways) 601 49400 01 365.00 Workers Comp Insurence 6,990 7,095 8,338 7,000 7,000 Water's Share of Premiums 601 49400 01 369.00 Other Insurance 6,181 6,048 6,132 12,000 6,500 Water's Share of Premiums 601 49400 01 391.00 P.C.Maintenance 2,900 601 49400 01 391.01 U/B Software Maintenance 2,081 2,074 2,074 2,200 2,200 Added to Utility Budgets in 2012 601 49400 01 391.02 Auto Read Software Support 585 578 595 700 700 Added to Utility Budgets in 2012 60 49400 01 392.00 P.C.Accessories&Supplies 0 0 40 200 200 601 49400 01 393.00 P.C.Hardware Purchases 4,093 1,707 9,199 2,000 2,000 601 49400 01 394.00 P.C.Software Purchases 16,000 601 49400 01 394.01 Licensing&Maintenance 4,279 4,371 4,591 6,200 15,000 ESRI,Cartegraph,OMS$10,700 601 49400 01 394.02 Online Subscriptions 286 379 379 800 800 Pictometry 601 49400 Ot 394.03 New Software Purchases 2,271 0 0 200 200 PAGE TOTALS 772,524 820,530 837,962 867,600 974,800 33 Page Two 2017 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES- July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Adual Actual Budget Amount Budget Comments 601 49400 01 403.00 Contracted R 8 M-Other Impr 30,845 23,576 23,397 30,000 30,000 Main Breaks,Gate Valves,Etc. 601 49400 01 416.00 Machinery Rental 0 0 0 0 0 601 49400 01 433.00 Dues&Subscriptions 25 0 187 400 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 R Seminars 5,700 601 49400 01 437.01 MDH Training(Water School) 816 1,459 2,161 2,000 2,500 Operator Licensure 601 49400 01 437.02 AWWA Conference 0 0 0 0 1,200 Duluth,Send 2 Staff 601 49400 01 437.03 CarteGraph,ESRI,GIS 370 126 0 1,300 1,000 User Group,Conference,Training 601 49400 01 437.04 Miscelianeous Training 0 9 849 1,000 1,000 601 49400 01 439.00 Other Miscellaneous Charges 14,627 13,460 13,459 45,000 45, 000 DNR Annual Water Use 601 49400 01 450.00 Sales Tax on Purchases 0 0 2,699 0 0 601 49400 01 521.00 Building&Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W.Building(19 of 20) 601 49400 01 530.00 Improvements Other Than Bldgs 220,600 601 49400 01 530.01 Well Inspections 490 560 0 600 600 601 49400 01 530.02 Miscellaneous Improvements 0 0 405 5,000 5,000 601 49400 01 530.03 CRP of Watermain 0 0 0 150,000 150,000 Annual Pavement Management 601 49400 01 530.04 inspection&Maintenance 0 0 259,255 190,000 65,000 From Long-Term Plan 601 49400 01 540.00 Heavy Machinery Purchases 0 0 0 0 0 Equipment Purchases-Match CIP 601 49400 01 550.00 Motor Vehicle Purchases 0 0 0 0 10,000 Equipment Purchases-Match CIP 601 49400 01 570.00 Office Equipment Purchases 107 0 0 500 500 601 49400 01 580.00 Other Equipment Purchases 0 0 0 0 11,000 Trash Pump(Split with 602,603) 601 49400 01 611. 00 Interest on Lease Payments 2,538 2,167 1,773 0 0 P.W.Building Expansion(See 521) 601 49400 01 710.00 Transfers 139,194 4,796 0 0 0 Transfers for Other Improvements 601-49400-01 TOTALS 961,537 866,683 1,142,148 1,303,600 1,308,200 601 49406 01 221.00 Equipment Parts 0 2,762 0 500 13,000 SCADA Upgrades 601 49406 01 223.00 Building Repair Supplies 0 7,250 0 200 200 601 49406 01 319.00 Other Professional Services 0 2,352 5,862 1,000 1,000 601 49406 01 381.00 Electric Utilities 1,045 1,083 1,147 1,300 1,300 Pumping 8 Lighting TOTAL-PRV 1,045 13,448 7,009 3,000 15,500 601 49407 01 221.00 Equipment Parts 1,401 0 409 1,500 1,500 601 49407 01 223.00 Building Repair Supplies 0 8 0 200 200 601 49407 01 319.00 Other Professional Services 0 0 0 0 0 601 49407 01 321.00 Telephone Costs 211 211 211 300 300 601 49407 01 381.00 Electric Utilities 23,667 23,142 20,7 8 33,000 33,000 Pumping,Lighting,Tower Mixer 601 49407 01 409.00 Other Contracted Repairs&Maint 6,000 11,781 1,429 2,000 2,000 $800 for Lights in 2015 601 49407 01 439.00 Other Miscellaneous Charges 37 0 0 100 100 Contingencies 601 49407 01 530.00 Improvements Other Than Bldgs 0 0 0 0 60,000 Controls Upgrade!Modernization TOTAL-WELL#7 31,316 35, 142 22,826 37,100 97, 100 601 49408 01 221.00 Equipment Parts 1,342 242 25 1,500 1,500 601 49408 01 223.00 Building Repair Supplies 0 106 19 200 200 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 601 49408 01 381.00 Electric Utilities 23,841 21,542 20,456 25,000 25,000 Pumping 8 Lighting 601 49408 01 383.00 Gas Utilities 470 592 497 600 600 Heat Only 601 49408 01 409.00 Other Contracted Repairs&Maint 5,952 27, 330 735 2,000 2,000 $800 for Lights in 2015 601 49408 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL-WELI#8 31,605 49,812 21,732 29,400 29,400 601 49409 01 221.00 Equipment Parts 2,831 2,569 0 1,500 1,500 601 49409 01 223.00 Building Repair Supplies 0 0 109 200 200 601 49409 01 319.00 Other Professional Services 0 0 0 0 0 601 49409 01 381.00 Electric Utilities 16,618 31,854 25,109 32,000 32,000 Pumping 8 ighting 601 49409 01 383.00 Gas Utilities 795 901 627 1,500 1,500 Heat Only 601 49409 01 409.00 Other Contracted Repairs&Maint 837 335 1,838 2,000 2,000 $800 for Lights in 2015 601 49409 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49409 01 530.00 Improvements Other Than Bldgs 21,907 0 0 0 0 TOTAL-WELL#9 42,988 35,659 27,683 37,300 37,300 34 Page Three 2017 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES- July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actuai Budget Amount Budget Comments 601 49410 01 219.00 Other Operating Supplies 0 0 0 500 500 601 49410 01 221.00 Equipment Parts 4,434 0 5,710 1,000 1,000 601 49410 01 223.00 Building Repafr Suppiies 213 15 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 Eledric Utilities 16,623 13,223 16,173 17,000 17,000 Pumping&Lighting 601 49410 01 409.00 Other Contracted Repairs 8 Maint 9,957 1,748 690 2,000 2,000 $800 for Lights in 2015 601 49410 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49410 01 530.00 Improvements Other Than Bidgs 10,014 0 0 0 0 TOTAL-WELL#10 42,005 15,751 23,337 20,800 20,800 Rural Water System 601 49411 01 221.00 Equipment Parts 0 0 4 0 0 601 49411 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 Y ( )TOTAL-WELL#11 0 0 4 0 0 Rural Water S stem #2 601 49412 01 221.00 Equipment Parts 0 0 3,431 1,500 1,500 601 49412 01 223.00 Building Repair Supplies 0 0 0 200 200 601 49412 01 319.00 Other Professional Services 0 0 0 0 0 601 49412 01 381.00 Electric Utilities 23,242 21,696 21,159 28,000 28,000 Pumping&Lighting 601 49412 01 409.00 Other Contracted Repairs&Maint 1,495 8,317 15,891 2,000 2,000 $800 for Lights in 2015 601 49412 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL-WELL#12 24,737 30,013 40,480 31,800 31,800 601 49414 01 221. 00 Equipment Parts 0 161 0 1,500 1,500 601 49414 01 223.00 Building Repair Supplies 0 408 0 200 200 601 49414 01 319.00 Other Professional Services 0 384 0 1,000 1,000 601 49414 01 381.00 Electric Utilities 27,051 23,382 26,674 28,000 28,000 Pumping&Lighting 601 49414 01 409.00 Other Contracted Repairs 8 Maint 883 0 6,850 2,000 2,000 $800 for Lights in 2015 601 49414 01 439.00 Other Miscelianeous Charges 0 0 0 100 100 Contingencies TOTAL-WELL#14 27,934 24,335 33,525 32,800 32,800 601 49425 01 221.00 Equipment Parts 575 830 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 500 601 49425 01 381.00 Electric Utilities 26,071 24,817 24,641 28,000 28,000 Pumping&Lighting 601 49425 01 409.00 Other Contracted Repairs 8 Maint 1,526 430 3,944 2,000 2,000 $800 for Lights in 2015 601 49425 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL-WELL#15 28,172 26,077 28,585 32,300 32,300 601 49426 01 221.00 Equipment Parts 0 0 0 1,500 1,500 601 49426 01 223.00 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,000 28,000 Pumping&Lighting 601 49426 01 383.00 Gas Utilities 0 0 0 1,000 1,000 May Be Electric Only(TBD) 601 49426 01 409.00 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 35 Page Four 2017 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES- July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detaii Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49415 01 221.00 Equipment Parts 0 0 0 500 500 Touch-up Paint 601 49415 01 319.00 Other Professional Services 0 3,675 0 0 0 601 49415 01 409.00 Other Contracted Repairs 8 Maint 0 1,050 617 500 500 601 49415 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies TOTAL-WATER TOWER#1 ^ W 0 4,725 617 1,200 ~ 1,200 Chippendale Water Tower) 601 49416 01 221.00 Equipment Parts 12 101 0 500 500 Touch-up Paint 601 49416 01 319.00 Other Professional Services 0 0 3,500 0 0 Tower Inspection 601 49416 01 381. 00 Electric Utilities 1,338 1,261 2,195 4,500 4,500 New Water Mixers in 2014 601 49416 01 409.00 Other Contracted Repairs&Maint 0 8,210 3,027 500 500 601 49416 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies TOTAL-WATER TOWER#2 1,350 9,572 8,722 5,700 5,700 Connemara Water Tower) 601 49417 01 221.00 Equipment Parts 0 206 8 500 500 601 49417 01 319.00 Other Professional Services 0 0 3,500 0 0 601 49417 01 381.00 Electric Utilities 5,374 4,760 2,994 6,000 6,000 601 49417 01 409.00 Other Contracted Repairs&Maint 0 14,700 6,105 500 500 601 49417 01 439.00 Other Miscellaneous Charges 96 0 156 200 200 Contingencies TOTAL-WATER TOWER#4 5,470 19,666 12,763 7,200 7,200 Bacardi Water Tower) 601 49418 01 221.00 Equipment Parts 0 0 24 500 500 601 49418 01 319.00 Other Professional Services 0 0 20,314 0 0 601 49418 01 381. 00 Eledric Utilities 3,359 2,768 2,154 4,000 4,000 New Water Mixers in 2014 601 49418 01 409.00 Other Contracted Repairs&Maint 519 15,500 1,020 500 500 601 49418 01 439.00 Other Miscellaneous Charges 0 0 20 200 200 Contingencies TOTAL-WATER TOWER#3 3,878 18,268 23,532 5,200 5,200 East Side Water Tower) GRANDTOTAL-ALLDEPT. $1,202,036 $1,149,152 $1,392,963 $1,579,700 1,656,800 36 Page One 2017 BUDGET WORKSHEETS SEWER UTILITY REVENUES- July'11,2016 Zp 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 602 33425.00 Other State Grants&Aids 0 0 0 0 0 602 34108.00 Administrative Fees-Other Funds 2,497 3,931 6,828 0 0 5%of 5%Fees-Const Projects 602 36101.00 Principal-Special Assessments 98,077 81,278 78,480 90,000 85,000 602 36102.00 Penalties 8 Interest-S/A 327 (1,366) (251) 0 0 602 36210.00 Interest Earnings-Investments 17,042 17,411 13,886 17,000 15,000 602 36214.00 Net Change in FV-Investments 8,621) 8,534 (4,100) 0 0 Annual Market Value Changes 602 36215.00 Interest Earnings 76 54 225 200 200 602 36260.00 Other Revenues 0 0 1,972 0 0 602 36265.00 Use of Reserve Funds 0 0 0 103,400 282,600 602 37210.00 Residential Sewer Revenues 1,278,008 1,247,826 1,251,838 1,500,000 1,400,000 602 37220.00 Apartment Sewer Revenues 114,024 111,519 117,405 134,000 125,000 602 37225.00 Institutional Sewer Revenues 24,238 24,128 21,813 29,000 25,000 602 37230.00 Commercial Sewer Revenues 72,645 74,855 78,823 90,000 80,000 602 37240.00 Industrial Sewer Revenues 86,042 71,258 110,928 85,000 110,000 602 37260.00 Penalties-Sewer Revenues 12,567 12,104 13,051 12,000 13,000 602 39103.00 Gain or Loss from F/A Disposal 0 0 0 0 0 602 39203.00 Transfer From 10,806 0 0 0 0 FUND TOTA S 1,707,729 $1,651,532 $1,690,900 $2,060,600 2,135,800 37 Page One 2017 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES- July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 602 49450 101.00 Salaries&Benefits 506,300 Salary,Taxes,PERA 8 Benefits 602 49450 77 101.00 Administrative 117,498 117,386 139,515 144,900 170,100 Add$18K for Asst City Engineer 602 49450 78 101.00 Technical/Clerical 142,778 151,671 151,279 158,800 160,500 602 49450 79 101.00 Maintenance 157,163 163,438 165,527 172, 300 175,700 602 49450 ux 101.00 Salary&Benefit Contingency 0 0 0 0 0 602 49450 102.00 Full-Time Overtime 15,629 13,810 9,705 7,500 7,500 602 49450 103.00 Part-Time Salaries&Benefits 5,531 5,707 3,548 9,000 7,000 602 49450 99 103.01 Utility Commission Wages(50%) 1,000 50%-602; 50%- 601 602 49450 99 103.02 Maintenance Labor 6,000 100%-602 602 49450 01 203.00 Printed Forms&Paper 1,613 1,416 1,005 1,500 1,500 Inserts&Water Bill Statements 602 49450 01 209.00 Other Office Supplies 899 172 439 200 200 602 49450 01 212.00 Motor Fuels 0 0 0 0 5,200 602 49450 01 216.00 Chemicals&Chemical Products 0 0 731 500 500 Root Killer,Degreaser 602 49450 01 219.00 Other Operating Supplies 304 100 9 200 200 602 49450 01 224.00 Street Maintenance Materials 0 0 1,439 2,500 2,500 Patching 602 49450 01 225.00 Landscaping Materials 0 0 0 400 400 Topsoil,Seed&Sod 602 49450 01 227.00 Utility System Maintenance Supplie: 211 797 1,378 5,000 5,000 MH Castings Replacement Prog. 602 49450 01 241.00 Small Tools 165 237 241 500 500 Wrenches,Shovels,etc. 602 49450 01 242.00 Minor Equipment 2,990 3,746 2,765 3,000 3,000 602 49450 01 303.00 Engineering Fees 23,000 602 49450 01 303.01 GIS 516 4,607 3,413 5,000 3,000 Reduce Due to In-House Engineer 602 49450 01 303.02 Rate Study 0 0 0 15,000 15,000 Part of Comp Plan Update 602 49450 Ot 303.04 Miscellaneous 7,402 2,846 9,471 15,000 5,000 Reduce Due to In-House Engineer 602 49450 01 304.00 Legal Fees 0 0 0 500 0 602 49450 01 312.00 Gopher State One-Calt 2,303 2,770 1,655 2,500 2,500 $7,500 Split 3 Ways 602 49450 01 318.00 Contract Engineer 10,000 12,000 6,250 0 0 602 49450 01 319.00 Other Professional Services 10,000 602 49450 01 319.01 Televising 0 0 0 3,000 3,000 602 49450 01 319.02 Root Control 0 0 0 2,000 2,000 602 49450 01 319.03 Supervisory Controls(Maint Cont) 6,802 0 0 5,000 5,000 SCADA System 602 49450 01 319.04 Buxton Project 0 5,556 5,556 5,600 0 602 49450 01 320.00 Credit Card Activity Fees 3,324 5,372 6,797 6,000 7,000 1/3 Cost of C/C Pymt Processing 602 49450 01 321.00 Telephone Costs 2,745 3,001 3,122 3,500 3,500 Cell Phones, Modems, GPS 602 49450 01 322.00 Postage Costs 4,556 4,173 4,296 5,000 5,000 Billings with Inserts 602 49450 01 323.00 Radio Units 1,045 1,367 1,120 1,500 5,100 (24x$300)(12x$1500)(Split 5 Ways) 602 49450 01 365.00 Workers Comp Insurance 7,011 7,117 8,361 7,000 7,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 10,777 12,067 13,292 12,000 12,000 Sewers Share of Premiums 602 49450 01 391.00 P.C.Maintenance 0 0 0 2,900 602 49450 01 391.01 U/B Software Maintenance 2,081 2,074 2,074 2,200 2,200 Added to Utility Budgets in 2012 602 49450 01 391.02 Auto Read Software Support 585 578 595 700 700 Added to Utility Budgets in 2012 602 49450 01 392.00 P.C.Accessories&Supplies 0 0 0 200 200 602 49450 01 393.00 P.C.Hardware Purchases 4,093 1,600 9,199 2,000 2,000 602 49450 01 394.00 P.C.Software Purchases 16,000 602 49450 01 394.01 Licensing&Maintenance 4,279 4,371 4,591 6,200 15,000 ESR,Cartegraph,OMS$10,700 602 49450 01 394.02 Online Subscriptions 286 379 379 800 800 Pictometry 602 49450 01 394.03 New Software Purchases 2,271 0 0 200 200 602 49450 01 395.00 P.C.Repairs 0 0 0 500 500 602 49450 01 403.00 Contracted R&M-Other Impr 2,581 63 24,454 5,000 30,000 MH Castings Replacement Prog. 602 49450 01 415.00 Other Equipment Rental 0 0 0 200 200 602 49450 01 416.00 Machinery Rental 0 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 49450 01 437.00 Conferences&Seminars 3,800 602 49450 01 437.01 MPCA Training(Sewer School)1,646 669 600 1,500 1,500 Operator Licensure$300 each(M) 602 49450 01 437.03 CaReGraph,ESRI,GIS 120 126 0 1,300 1,300 User Group, Conference,Training 602 49450 01 437.04 Miscellaneous Training 0 0 814 1,000 1,000 602 49450 01 439.00 Other Miscellaneous Charges 148 145 258 100 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 Bidgs 160,000 602 49450 01 530.01 Miscellaneous Improvements 31 0 0 10,000 10,000 SCADA Reconfiguration, PCL's 602 49450 01 530.03 CRP of Sewermain 0 0 0 150,000 150,000 Annual Pavement Management 602 49450 01 540.00 Heavy Machinery Purchases 0 189, 190 63 0 0 Equipment Purchases-Match CIP 602 49450 01 550.00 Motor Vehicle Purchases 0 0 0 0 11,000 Equipment Purchases-Match CIP 602 49450 01 560.00 Fumiture&Fixture Purchases 0 0 56 500 500 602 49450 01 570.00 Office Equipment Purchases 0 0 0 500 500 602 49450 01 580.00 Other Equipment Purchases 0 0 0 0 11,000 Trash Pump(Split with 601,603) PAGE TOTALS 519,385 718,548 583,995 790,300 866,300 38 Page Two 2017 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES- July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 602 49450 01 602.00 Sewer Service Charges 1,007,195 1,090,261 1,077,415 1,185,400 1,215,000 MWCC Charges 602 49450 01 611.00 Interest on Lease Payments 2,538 2,165 1,773 0 0 P.W.Building Expansion(See 521) 602 49450 01 710.00 Transfers 116,948 2,405 0 0 Transfers for Other Improvements 602-49450-01 TOTALS 1,646,066 1,813,379 1,663,183 1,975,700 2,081,300 602 49451 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49451 01 221.00 Equipment Parts 0 0 0 800 800 602 49451 01 229.00 Other Maintenance Supplies 0 0 567 200 200 602 49451 01 303.00 Engineering Fees 0 0 0 0 0 6024945101 381.00 EledricUtilities 915 916 761 1,500 1,500 602 49451 01 403.00 Contracted R&M-Other Impr 0 775 704 45,000 2,000 602 49451 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies City Hall) TOTAL-LIFT STATION#1 915 1,691 2,032 47,700 4,700 602 49452 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49452 01 221.00 Equipment Parts 1,060 0 0 800 800 602 49452 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49452 01 381.00 Electric Utilities 630 623 604 700 700 602 49452 01 403.00 Contracted R&M-Other Impr 0 0 0 200 2,000 602 49452 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Bloamfield Sth) TOTAL-LIFT STATION#7 1,691 623 604 2,100 3,900 602 49453 01 219.00 Other Operating Suppiies 0 0 0 100 100 602 49453 01 221.00 Equipment Parts 0 0 0 800 800 602 49453 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49453 01 381.00 Electric Utilities 3,753 3,548 3,728 4,000 4,000 602 49453 01 403.00 Contracted R&M-Other Impr 0 7,395 0 200 2,000 602 49453 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Shannon Pond) TOTAI-LIFT STATION#3 3,753 10,942 3,728 5,400 7,200 602 49454 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49454 01 221. 00 Equipment Parts 167 6 0 800 800 602 49454 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49454 01 381.00 Eledric Utilities 4,602 4,821 5,539 6,000 6,000 602 49454 01 403.00 Contracted R&M-Other Impr 1,582 0 0 2,000 2,000 602 49454 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Hawkins) TOTAL-LIFT STATION#4 6,351 ^ 4,827 5,539 9,200 9,200 602 49455 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49455 01 221.00 Equipment Parts 0 1,800 0 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 0 0 0 0 602 49455 01 381.00 Electric Utilities 5,569 5,802 4,979 6,000 6,000 602 49455 01 403.00 Contracted R&M-Other Impr 0 415 2,350 200 2,000 602 49455 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies LeForet Add'n) TOTAL-LIFT STATION#5 5,569 8,016 7,329 7,400 9,200 602 49456 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49456 01 221.00 Equipment Parts 2,385 0 0 800 800 602 49456 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49456 01 381.00 Electric Utilities 6, 001 8,270 3,945 6,000 6,000 602 49456 01 403.00 Contracted R 8 M-Other Impr 0 0 0 200 2,000 602 49456 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Drumcliffe) TOTAL-LIFT STATION#6 8,385 8,270 3,945 7,400 9,200 39 Page Three 2017 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES- July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Aetua Budget Amount Budget Comments 602 49457 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49457 01 221. 00 Equipment Parts 0 0 0 500 500 602 49457 01 229.00 Other Maintenance Supplies 0 0 0 200 200 6024945701 381.00 EleclricUtiiities 1,278 857 216 1,200 1,200 602 49457 01 403.00 Contracted R&M-Other Impr 0 0 1,533 200 2,000 602 49457 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Glendalough Sth) TOTAL-LIFT STATION#9 1,278 857 1,749 2,300 4,100 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49458 01 221.00 Equipment Parts 1,269 0 0 500 500 602 49458 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49456 01 381.00 Electric Utiiities 633 629 449 800 800 602 49458 01 403.00 Contracted R&M-Other Impr 0 0 539 200 2,000 602 49458 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Meadows of)TOTAL-LIFT STATION#8 1,902 629 987 1,900 3,700 Bloomfield) 602 49460 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49460 01 221.00 Equipment Parts 725 0 0 500 500 602 49460 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49460 01 381.00 Electric Utilities 252 261 233 400 400 602 49460 01 403.00 Contracted R&M-Other Impr 0 0 0 200 2,000 602 49460 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Glen Rose) TOTAL-LIFT STATION#10 W 977 261 233 1,500 ^^3,300 GRANDTOTAL-ALLDEPTS. $1,676,886 $1,849,496 $1,689,329 $2,060,600 2,135,800 40 Page One 2017 BUDGET WORKSHEETS STORM WATER UTILITY REVENUES- July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actuai Actual Actual Budget Amount Budget Comments 603 33400.00 State Grants 8 Aids 0 0 0 0 0 603 33425.00 Other State Grants 8 Aids 0 0 0 0 0 603 33620.00 Other County Grants&Aids 0 19,680 0 0 0 603 34108.00 Administrative Fees-Other Funds 2,497 3,931 6,828 0 0 5%of 5%Fees-Const Projects 603 36101.00 Principal-Special Assessments 19,925 25,726 21,967 22,000 22,000 603 36102.00 Penalties&nterest-S/A 76 (362)57) 0 0 603 36210.00 Interest Earnings-Investments 21,458 37,889 34,724 25,000 25,000 603 36214.00 Net Change in FV-Investments 48,916) 40,005 (8,127) 0 0 Annual Market Value Changes 603 36215.00 Interest Earnings 60 47 213 200 200 603 36260.00 Other Revenues 188,004 35,615 0 0 0 603 36262.00 Special Settlements 0 24,797 0 0 0 603 36265.00 Use of Reserve Funds 0 0 0 0 0 603 37300.00 Storm Water Utility Revenues 980,819 1,040,839 1,102,373 1,000,000 1,215,000 5%Rate Increase PerYear 603 37360.00 Penalties-Storm Water Utility 5,956 6,577 9,300 6,000 6,000 603 39203.00 Transfer From 0 14,260 24,000 0 0 FUND TOTALS 1,169,878 $1,249,004 $1,191,221 $1,053,200 1,268,200 41 Page One 2017 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES- July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 603 49500 101.00 Salaries&Benefits 275,000 Salary,Taxes,PERA&Benefits 603 49500 77 101.00 Administrative 10,586 10,932 26,693 39,400 77,100 Added-$36K for Asst City Engineer 603 49500 7S 101.00 Technical/Cierical 60,607 85,598 85,202 86,800 87,300 603 49500 79 101.00 Maintenance 78,581 81,718 82,763 87,900 110,600 Added-$20.SK-25%of New Position 603 49500 xx 101.00 Salary 8 Benefit Contingency 0 0 0 0 0 603 49500 102.00 Full-Time Overtime 7,836 6,918 4,928 6,000 6,000 603 49500 99 103.00 Part-Time Salaries&Benefits 5,157 4,323 6,506 8,000 8,000 603 49500 01 203.00 Printed Forms&Paper 1,613 1,416 1,005 1,500 1,500 603 49500 01 204.00 Envelopes 8 Letterhead 0 0 0 0 0 603 49500 01 208.00 Miscellaneous Supplies 1,090 0 397 500 500 Stakes,Ribbons,Level,etc. 603 49500 01 212.00 Motor Fuels 0 0 0 0 6,200 603 49500 01 215.00 Shop Materials 0 0 0 0 0 603 49500 01 219.00 Other Operating Supplies 0 0 0 0 0 603 49500 01 221.00 Equipment Parts 0 0 0 0 0 603 49500 01 224.00 Street Maintenance Materials 515 1,505 39 2,000 2,000 Patching Material for Washouts 603 49500 01 225.00 Landscaping Materials 2,000 603 49500 01 225.01 Rip-Rap,Matting,Rock,etc. 898 1,868 1,162 2,000 1,000 603 49500 0 225.02 Black Dirt,Seed,Sod,etc.150 150 0 2,000 1,000 603 49500 01 226.00 Sign Repair Materials 0 0 0 500 500 603 49500 01 230.00 Equipment Repair Material 1,754 1,018 482 1,000 1,000 603 49500 01 241.00 Small Toois 349 627 260 1,000 1,000 603 49500 01 242.00 Minor Equipment 2,659 1,567 943 2,000 2,000 Misc.Noules for Vac Truck 603 49500 01 303.00 Engineering Fees 100,000 603 49500 01 303.01 Problem Area Investigations 79 0 0 10,000 5,000 Reduce Due to In-House Engineer 603 49500 01 303.02 NPDES Phase II 14,115 68,996 75,829 40,000 32,000 Reduce Due to In-House Engineer 603 49500 01 303.03 CSMP Update 4,850 2,535 25,026 50,000 50,000 Part of Comp Plan Update 603 49500 01 303.04 Miscellaneous 14,108 5,265 11,053 20,000 10,000 Reduce Due to In-House Engineer 603 49500 01 303.05 GIS 344 3,071 2,276 5,000 3,000 Reduce Due to In-House Engineer 603 49500 01 303.06 MS4 Services 0 0 0 10,000 0 603 49500 01 304.00 Legal Fees 0 0 0 2,000 2,000 603 49500 01 310.00 Testing Services 0 0 0 1,000 1,000 Water Quality Tests(M) 603 49500 01 312.00 Gopher State One-Call 0 169 2,012 2,500 2,500 $7,500 Split 3 Ways 603 49500 01 315.00 Special Programs 4,815 4,815 3,850 5,000 5,000 WHEP 603 49500 01 318.00 Contract Engineer 10,000 12,000 6,250 0 0 603 49500 01 319.00 Other Professional Services 6,802 5,000 603 49500 01 319.01 SCADA 0 0 0 5,000 5,000 603 49500 01 319.02 Bu on Project 0 5,556 5,556 5,600 0 603 49500 01 320.00 Credit Card Activity Fees 3,324 5,372 6,797 6,000 7,000 1/3 Cost of C/C Pymt Processing6034950001321.00 Telephone Costs 2,745 3,002 3,122 3,500 3,500 Cell Phones,Modems,GPS 603 49500 01 322.00 Postage Costs 4,556 4,173 4,296 5,000 5,000 Billings&Info Mailings 603 49500 01 323.00 Radio Units 1,045 1,367 1,120 1,500 5,100 (24x$300)(12x$1500)(Split 5 Ways) 603 49500 01 352.00 General Notices&Public Info 0 0 0 1,000 1,000 Public Info Brochure 603 49500 01 365.00 Workers Comp Insurance 2,925 2,992 3,541 3,500 3,500 Storm Water's Share of Premiums 603 49500 01 369.00 Other Insurance 1,278 1,316 1,203 4,000 4,000 Storm Water's Share of Premiums 603 49500 01 391.00 P.C.Maintenance 2,900 603 49500 01 391.01 U/B Software Maintenance 2,081 2,074 2,074 2,200 2,200 Added to Utility Budgets in 2012 603 49500 01 391.02 Auto Read Software Support 585 578 595 700 700 Added to Utility Budgets in 2012 603 49500 01 393.00 P.C.Hardware Purchases 4,093 1,600 9,199 2,000 2,000 603 49500 01 394.00 P.C.Software Purchases 16,000 603 49500 01 394.01 Licensing&Maintenance 4,279 4,371 4,591 6,200 15,000 ESRI,Cartegraph,OMS$10,700 603 49500 01 394.02 Online Subscriptions 286 379 379 800 800 Pictometry 603 49500 01 394.03 New Software Purchases 2,271 0 0 200 200 603 49500 01 403.00 Contracted R&M-Other Impr 68,000 603 49500 01 403.01 Ditching 4,330 8,344 0 8,000 8,000 603 49500 01 403.02 Miscellaneous Repairs 32,838 117,136 20,634 60,000 60,000 Catch Basins, Manholes,Etc. 603 49500 01 403.03 Pond Inspection 8 Maintenance 0 D 0 10,000 0 603 49500 01 405.00 MS4 Permit Compliance 170,000 603 49500 01 405.01 Engineering Fees 0 0 0 0 45,000 Inspection,GIS,Guidance,Etc. 603 49500 01 405.02 Equipment Rental 0 0 0 0 20,000 Bulldozer,Large Equipment 603 49500 01 405.03 Dirt,Seed,Rip Rap,Etc. 0 0 0 0 5,000 For Restoration 603 49500 01 405.04 Contracted Maintenance 0 0 0 0 100,000 Burush Clearing,Dredging($40K)603 49500 01 416.00 Machinery Rental 64 0 0 4,000 2,500 Pumps 603 49500 01 433.00 Oues 8 Subscriptions 140 140 140 200 200 SUSA(AJ,Dick)50%Split w/Storm 603 49500 01 435.00 Books&Pamphlets 0 0 73 500 500 Utility Information6034950001437.00 Conferences&Seminars 3,500 603 49500 01 437.01 Storm Water Management 112 0 0 1,200 1,200 Stormwater Collab,Flygt Training6034950001437.04 Cartegraph,ESRI,GIS 120 126 0 1,300 1,300 User Group,Conference, Training6034950001437.05 Miscellaneous Training 0 0 165 1,000 1,000 603 49500 01 439.00 Other Miscellaneous Charges 908 145 265 0 300 PAGE TOTALS 314,887 453,160 400,426 519,500 716,200 42 Page Two 2017 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES- July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Adual Actual Actual Budget Amount Budget Comments 603 49500 01 530.00 Improvements Other Than Bldgs 356,300 603 49500 01 530.01 CRP of Storm Sewer 6,523 0 7,800 150,000 150,000 Keegan Lake Drainage in 2017 603 49500 01 530.02 Stormwater System Improvements 0 0 0 0 206,300 Keegan Lake Drainage in 2017 603 49500 01 540.00 Heavy Machinery Purchases 0 0 0 0 99,000 Sweeper(Split w/Equipment CIP) 603 49500 01 550.00 Motor Vehicle Purchases 0 0 0 0 10,000 Equipment Purchases-Match CIP 603 49500 01 560.00 Furniture&Fixture Purchases 0 189,190 0 500 500 603 49500 01 580.00 Other Equipment Purchases 0 0 63 2,000 11,000 Trash Pump(Split with 601,602) 603 49500 01 586.00 Computer Equipment Purchases 0 0 0 500 500 603 49500 01 710.00 Transfers 32,000 603 49500 01 710.06 1/2 of 2011 P&I Payments(2010A) 89,000 87,000 51,000 51,000 32,000 Refunding Issue 12/ 10 603 49500 01 710.10 Projects 81,225 123,395 384,695 0 0 603-49500-01 TOTALS 491,635 852,746 843,983 723,500 1,225,500 603 49511 01 221.00 Equipment Parts 410 0 0 500 500 603 49511 01 381.00 Electric Utilities 312 360 277 500 500 6034951101 403.00 ContractedRepairBMaintenance 0 278 1,455 1,000 1,000 Copper Pond)TOTAL-LIFT STATION#1 722 638 1,732 2,000 2,000 603 49512 01 221.00 Equipment Parts 0 0 0 500 500 603 49512 01 381.00 Electric Utilities 0 0 0 500 500 603 49512 01 403.00 Contracted Repair&Maintenance 0 0 1,897 1,000 1,000 Schwarz Pond) TOTAL-LIFT STATION#2 0 0 1,897 2,000 2,000 603 49513 01 221.00 Equipme t Parts 0 0 0 500 500 6034951301 381.00 ElectricUtilities 5,176 5,552 4,157 6,000 6,000 603 49513 01 403.00 Contracted Repair&Maintenance 0 0 1,455 1,000 1,000 Birger Pond) TOTAL-LIFT STATION#3 5,176 5,552 5,612 7,500 7,500 603 49514 01 221.00 Equipment Parts 0 0 0 500 500 603 49514 01 381.00 Electric Utilities 1,500 2,067 986 2,500 2,500 603 49514 01 403.00 Contracted Repair&Maintenance 0 103 1,765 1,000 1,000 Alarm Upgrades Marcotte Pond) TOTAL-LIFT STATION#4 1,500 2,170 2,751 4,000 4,000 603 49515 01 221.00 Equipment Parts 0 0 0 500 500 603 49575 01 38.00 Electric Utilities 0 0 0 500 500 603 49515 01 403.00 Contracted Repair&Maintenance 0 0 1,455 1,000 1,000 Alarm Upgrades,SCADA,PLC Hawkins Pond) TOTAL-LIFT STATION#5 0 0 1,455 2,000 2,000 603 49516 01 221.00 Equipment Parts 0 0 0 500 500 603 49516 01 381.00 Electric Utilities 449 473 352 500 500 603 49516 01 403.00 Contraded Repair&Maintenance 0 145 1,455 1,000 1,000 Glendalough 7th) TOTAL-LIFT STATION#6 449 618 1,807 2,000 2,000 603 49517 01 221.00 Equipment Parts 0 0 0 0 500 603 49517 01 381.00 Electric Utilities 0 0 0 0 500 603 49517 01 403.00 Contracted Repair&Maintenance 0 0 0 0 1,000 Horseshoe Lake) TOTAL-LIFT STATION#7 0 0 0 0 2,000 GRANDTOTAL-ALLDEPTS.499,484 $861,724 $859,238 $743,000 1,247,000 43 Page One 2017 BUDGET WORKSHEETS ARENA-REVENUES July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 650 36210.00 Interest Earnings-Investments 320 $399 $628 0 0 650 36215.00 Interest Earnings 35 54 70 100 100 650 36230.00 Contributions/Donations 0 0 0 0 0 650 36260.00 Other Revenue-Learn to Skate 31,950 38,362 40,189 37,000 40,000 Learn to Skate Program(LTS) 650 36265.00 Use of Reserve Funds 0 0 0 49,700 49,000 650 38060.00 Prime Time Ice Fees 243,303 254,671 259,730 270,000 257,000 650 38067.00 Non-Prime Time Ice Fees 72,984 61,953 71,309 72,000 95,000 650 38063.00 Open Skating Ice Fees 7,945 6,425 6,316 6,000 6,500 650 38065.00 Other Events-Arena 0 0 0 0 0 Dry Floor Events 650 38066.00 Advertising Revenue-Arena 8,750 12,250 6,500 13,000 13,000 650 38067.00 Skate Sharpening Revenue-Arena 3,024 7,085 5,330 7,000 7,000 65038090.00 Concessions 2,600 4,550 4,100 3,900 2,000 650 38091.00 Vending Machine Revenues 4,892 4,518 13,890 5,000 10,000 650 38095.00 Pro Shop Revenues 611 950 1,510 1,000 1,500 Tape,Laces,Mouthguards,etc. 650 39103.00 Gain or Loss from F/A Disposal 0 1,867 0 0 0 650 39201.00 Transfer From General Fund 115,000 115,000 130,000 130,000 130,000 Subsidy for Operations FUNDTOTALS 491,413 508,084 539,572 594,700 611,100 44 Page One 2077 BUDGET WORKSHEETS ARENA-EXPENDITURES July 11,2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of65045130101.00 Salaries&Benefits 181,800 Salary,Taxes,PERA& Benefits6504513077101.00 Administrative 42,768 39,514 49,113 44,500 45,800 650 45130 78 101.00 Technical/Clerical 37,657 39,299 39,663 41,500 42,900 650 45130 79 101.00 Maintenance 75,364 77,378 74,020 81,400 93,100 Upgrades for Coord,Lead Pay 650 45130 oc 101.00 Salary&Benefit Contingency 0 0 0 0 0 650 45130 79 102.00 Full-Time Overtime 1,916 1,471 525 2,000 2,000 650 45130 103.00 Part-Time Salaries&Benefits 42,000 650 45130 89 103.00 Learn-To-Skate Program 17,512 19,779 21,035 19,000 19,000 650 45130 99 103.00 Building Attendants 23,718 25,692 28,929 23,000 23,000 And Other P/T Positions 650 45130 01 207.00 Training&Instructional Suppiies 0 0 0 100 100 650 45130 01 208.00 Miscellaneous Supplies 700 650 45130 01 208.01 Skate Magnets 0 0 0 100 100 650 45130 01 208.02 Other Supplies 0 290 0 600 600 650 45130 01 209.00 Other Office Supplies 107 135 605 500 500 Learn to Skate Program Supplies 650 45130 01 211.00 Cleaning Supplies 3,828 3,488 3,965 4,000 4,000 650 45130 01 212.00 Motor Fuels 0 0 0 0 0 Zamboni Maintenance 650 45130 01 216.00 Chemicals&Chemical Products 7,515 7,848 8,083 5,000 7,500 Cooling Tower 650 45130 01 219.00 Other Operating Supplies 1,289 489 148 500 500 Events Supplies 650 45130 01 221.00 Equipment PaRs 6,133 4,704 8,794 6,000 8,000 650 45130 01 223.00 Building Repair Supplies 1,629 3,903 2,499 3,000 3,500 650 45130 01 265.00 Other Items for Resale 681 1,075 1,006 600 600 Pro Shop Supplies 650 45130 01 305.00 Medical&Dental 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 PerAdmin Fee Policy 650 45130 01 321.00 Telephone Costs 1,285 1,183 1,000 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 120 855 1,077 200 200 650 45130 01 365.00 Workers Comp Insurance 3,302 3,257 3,697 3,500 3,500 650 45130 01 369.00 Other Insurance 4,033 3,803 3,715 8,000 8,000 650 45130 01 381.00 Electric Utilities 134,898 123,636 118,354 130,000 125,000 650 45130 01 383.00 Gas Utilities 28,636 32,808 21,845 25,000 25,000 650 45130 01 384.00 Refuse Disposal 2,836 2,833 2,833 3,000 3,000 650 45130 01 401.00 Contracted Building Repairs 10,653 9,490 11,375 8,500 10,000 650 45130 01 404.00 Contracted Mach&Equip Repairs 28,128 25,257 28,175 25,000 25,000 650 45130 01 415.00 Other Equipment Rental 0 0 225 300 300 650 45130 01 433.00 Dues&Subscriptions 1,090 770 770 1,000 1,000 MIAMA&MRPA Dues 650 45130 01 437.00 Conferences&Seminars 0 406 2,415 2,500 4,000 MIAMA&MRPA Seminars 650 45130 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 Contingencies 650 45130 01 521.00 Building&Structure Purchases 0 913 0 0 30,000 Restroom Rehab-Upper Level 650 45130 01 580.00 Other Equipment Purchases 80,176 14,005 0 145,000 108,000 Ice Resurfacer(Moved to 2017) 650 45130 01 581.00 Other Equipment Purchases 0 0 0 0 6,000 Ice Edger 650 45130 01 710.00 Transfers 3,500 650 45130 01 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 0 0 0 0 FUNDTOTALS 524,772 453,780 443,367 594,700 611,100 45