The URL can be used to link to this page

ITEM 4.1 2015 BudgetIZJ City of Otsego 2015 Budget Table of Contents PAGE r� Property Tax Levy 1 General Fund Summary 2 General Fund Revenues General Fund Revenues 3 Expenditures 15 City Council 4 Administration 5 Elections 9 Assessor 9 Finance 10 Legal Services 10 Information Technology 11 City Hall/Public Works Building 12 Planning 13 Building Inspection 14 Police 15 Fire Station 15 Emergency Management 15 Animal Control 15 Streets 16 Engineering 18 Street Lights 18 Fleet Management 20 Park Maintenance 22 Recreation 26 Prairie Center 28 Economic Development 29 Debt Service Funds Outstanding Bonded Debt at 1/1/2015 30 Payment of Outstanding Principal 2015 31 Principal and Interest Payments by Bond Issue 32 Principal and Interest Pyaments by Source Fund 33 Enterprise Funds Water Utility Fund 34 Sewer Utility Fund 39 City of Otsego Calculation of Property Tax Levy Options for taxes payable 2015 General Fund Levy Fire Reserve Levy Storm Sewer Levy Pavement Management Levy Park Trail Management Levy Capital Equipment Revolving Fund Levy Parks Capital Equipment Subtotal: Other Limited Levies Subtotal: Limited Levy 2007B GO Improvement Bonds 2010A GO Equipment Certificate 2010B GO Building Bonds 2010D & 2011A GO Improvement Bonds 2003A Improvement Bonds 2004A Improvement Bonds 2006B Improvement Bonds Subtotal: Bonded Debt Levies Tax Abatement TOTAL: Certified Levy Dollar Increase Percentage Increase Pay 2012 Pay 2013 2,831,000 3,213,145 480,000 140,000 - 57,765 300,000 300,000 25,000 25,000 150,000 175,000 50,000 25,000 1,005,000 722,765 3,836,000 3,935,910 150,000 150,000 100,000 100,000 75,000 75,000 100,000 100,000 425,000 425,000 - 17,000 4,261,000 4,377,910 116,910 2.74% Adopted Proposed Pay 2014 Pay 2015 3,273,715 3,319,000 145,000 145,000 25,000 25,000 320,000 320,000 25,000 25,000 160,000 160,000 53,000 53,000 728,000 728,000 4,001,715 4,047,000 200,285 410,000 - 200,000 100,000 - 75,000 - 100,000 - 475,285 610,000 23,000 23,000 4,500,000 4,680,000 122,090 180,000 2.79% 4.00% Dollar Percentage Chanae Chance 45,285 1.38% - 0.00% - 0.00% - 0.00% - 0.00% - 0.00% - 0.00% - 0.00% 45,285 1.13% - 0.00% - 0.00% 209,715 104.71% 200,000 0.00% (100,000) (100.00%) (75,000) (100.00%) (100,000) (100.00%) 134,715 28.34% 0.00% 180,000 4.00% 1 CAUsers\Dan\Documents\2015 Budget\Property Tax Levy Pay 20151 12/3/2014 City of Otsego General Fund Budget for the year ending 31 December 2015 Revenues: Taxes Licenses and Permits Intergovernmental Revenue Charges for Service Interest Revenue Cable Franchise Fees Other Revenues TOTAL Revenues: Expenditures: General Government.- City overnment:City Council Administration Elections Assessor Finance Legal Information Technology City Hall Planning Building Inspection Subtotal: General Government: Public Safety: Police Police Commission Fire Emergency Management Animal Control Subtotal: Public Safety: Public Works: Streets Engineering Street Lights Fleet Maintenance Subtotal: PublicWorks Culture & Recreation Park Maintenance Recreation Prairie Center Subtotal: Culture & Recreation: Economic Development Transfers OuU(In) TOTAL Expenditures: NET GENERAL FUND: 2011 2012 2013 2014 2015 Arfiial Artnal Ar m Riidnat Prnnnsed 3,343,665 3,139,130 3,366,010 3,273,715 3,334,000 304,084 563,077 830,076 557,300 592,000 199,053 208,822 217,630 316,611 323,122 96,204 62,163 38,321 65,650 50,700 118,186 92,134 (4,766) 100,000 95,000 100,176 106,547 83,681 105,000 105,000 282,796 66,553 72,924 143,736 149,047 4,444,164 4,238,426 4,603,876 4,562,012 4,648,869 49,950 51,273 44,216 74,547 82,317 295,869 376,582 339,696 391,860 415,273 390 24,334 1,486 26,200 745 67,935 67,904 67,463 70,300 74,700 176,950 239,680 242,381 321,187 342,703 95,239 71,305 78,996 75,000 82,000 - 35,108 22,760 47,628 66,300 721 716 71,270 81,255 82,063 91,753 86,356 70,016 73,400 67,250 454,415 204,926 181,882 231,692 229,723 1,233,222 1,158,184 1,120,166 1,393, 069 1,443, 074 861,410 875,045 882,601 912,500 941,700 1,191 1,372 1,399 1,350 1,350 - 347,922 365,873 375,850 454,560 - 728 2,950 8,550 7,450 15,274 10,915 11,058 11,000 11,300 877,875 1,235,982 1,263,881 1,309,250 1,416,360 1,285,891 760,656 678,991 630,610 681,123 147,421 128,714 160,825 85,000 85,000 97,046 108,775 109,667 110,000 114,100 - - 148,131 191,630 187,260 1,530,358 998,145 1,097,614 1,017,240 1,067,483 346,350 193,455 166,490 294,880 343,851 41,736 86,162 115,471 156,089 130,177 58,888 39,134 20,220 32,647 35,622 446,974 318,751 302,181 483,616 509,650 12,353 2,649 3,286 13,790 14,100 556,941 115,000 - 65,911 - 4,657,723 3,828,711 3,787,128 4,282,876 4,450,667 213,559 409,715 816,748 279,136 198,202 2 C:\Users\Dan\Documents\2015 Budget\GF Summary 2015 11/25/2014 r City of Otsego General Fund- Revenues for the year ending December 31, 2015 101 31010 Current Ad Valorem Taxes 101 31800 Other Taxes 101 31900 Penalties and Interest - 14144 Taxes 101 32100 Business Licenses/Permits 101 32130 Fire Inspections 101 32140 Rental Inspection Fees 101 32150 Public Utilities ROW Permits 101 32180 Other Licenses/Permits 101 32190 Fencing Permits 101 32210 Liquor Licenses 101 32250 Sign Permits 101 32260 Building Permits 101 32261 Plumbing Permits 101 32262 Mechanical Permits 101 32263 Electrical Permits 101 32270 Septic Permits 101 32290 Weight Permits 101 32999 Assessor's Fee 700 - Licenses and Permits 101 33403 Local Government Aid 101 33405 Police Aid 101 33406 MSA Maintenance 101 33422 Other Intergovernmental Aid 60,392 43,000 Intergovernmental Revenues 101 34050 Administrative Fees 101 34103 Zoning and Subdivision Fees 101 34105 Sales of Maps and Publications 101 34107 Assessment Search Fees 101 34201 Mining Fees 101 34207 Citations 101 34303 Public Works Charges 101 34320 Street Light Operation 101 34330 Grading Reviews 101 34710 Recreation Fees 101 34740 Sports Field Use 101 34750 Prairie Center Rentals 101 34760 Otsego Festival Vendors Charges for Services 101 35101 Fines and Forfeits 101 36100 Special Assessments 101 36102 Special Assessments Penalties & I 101 36200 Miscellaneous Revenues 101 36210 Interest Earnings Interest and Assessments 101 38000 Rentals 101 38010 HPC Book Sales 101 38020 Donations and Contributions 101 38050 Cable TV Franchise Fees 101 38990 Other Miscellaneous 101 38991 Refunds and Reimbursements Other Revenue Sources 101 39000 Other Financing Sources 101 39101 Sales of General Fixed Assets 101 39200 Interfund Operating Transfers 101 2011 2012 2013 2014 2015 3,327,753 3,125,888 3,340,728 3,273,715 3,319,000 $ additional = $ 45,285 or 1.38% 1,768 1,650 - - - 14144 11,592 25,282 - 15,000 weighted 3 year average 3,343,665 3,139,130 3,366,010 3,273,715 3,334,000 23,200 33,170 12,400 30,000 600 liquor licenses moved to 32210 2,125 181 1,000 - 1,000 alternate years for reinspections 17,390 19,420 29,680 18,600 29,000 - 2,450 3,400 2,500 2,500 - 120 33,150 - - 1,650 1,700 1,910 1,600 1,750 3 year average - - - 10,100 33,850 250 625 700 - 300 new signs only 211,270 409,317 615,433 400,000 400,000 20,383 41,850 56,823 41,000 52,000 22,634 43,144 60,392 43,000 58,000 7 - - - - done by State of MN 4,150 4,050 5,300 3,500 3,000 - - 305 - - 1,025 7,050 9,583 7,000 10,000 on new construction; offset by expenditure in 42410-336 304,084 46,692 147,633 4,728 199,053 287 1,200 534 420 86,892 3,770 3,101 96,204 1,000 69,047 1,135 1,866 118,186 190,234 79,070 241 3,000 100,176 22 182,509 127,415 563,077 45,432 154,667 8,723 208,822 200 6,600 272 2,941 9,689 2,168 21,115 1,650 8,688 8,840 62,163 2,000 47,440 5,001 92,134 144,575 258 800 106,547 7,349 70) 114,884 3,775 830,076 61,543 156,087 217,630 280 6,700 57 3,920 664 8,000 (9,990) 22,770 5,830 38,231 45,796 3,760 4,218 (4,766) 49,008 51 1,000 83,681 3,893 13,717 102,342 579 557,30U 112,711 47,000 155,000 1,900 316,611 5,000 2,500 1,650 4,000 50,000 2,500 65,650 100,000 100,000 105,000 592,000 123,947 allotment by Legislature 46,375 weighted 3 year average 152,800 3 year average 323,122 250 5,000 2,500 2,000 code enforcement fines 1,800 4,000 22,000 3,500 soccer fields and ballfields 6,000 3,650 50,700 95,000 95,000 1,000 105,000 105,000 106,000 143,736 148,047 Utility Billing Staff $ 47,013; Administrative Transfer $ 64,099; Streets Staff from Utilities $ 36,935 Other Financing Sources I 127,415 3,775 579 143,736 148,047 TOTAL REVENUES 1.90% 3 Y.\Budget 2015 Input\2015 Finance\GF Revenues 2015 Compiled 12/3/2014 Personal Services 101 41100 320 Telephone 101 41100 321 Mileage/Travel 101 41100 355 Dues & Memberships 101 41100 360 Education/Training/Conferences 101 41100 801 101 41100 31,848 107 190 945 33,732 13 180 855 Purchased Services 1,242 1,048 Contingency 16,860 16,493 city 2013 2014 2015 29,690 30,000 2,271 2,295 296 102 32,257 32,397 1,636 500 91 200 30 200 1,868 1,250 3,625 2,150 8,334 40,000 30,000 2,295 102 32,397 2,520 5 Ipad contracts $ 210/mo 200 200 WC Mayors Assn $150; LMC Mayors & others $50 2,000 LMC Conference 1 x 250; Elected officials 1 x 350; meeting supplies 500; volunteer recognition dinner 900 4,920 45,000 Y:\Budget 2015 Input\2015 Administration\GF Expense - Council 2015 12/3/2014 City of Otsego General Fund - Expenditures for the year ending December 31, r 2015 City Council 2011 2012 =und Account Description Actual Actual EXPENDITURES 101 41100 104 Wages - PT Employees 29,585 31,335 101 41100 122 FICA and Medicare 2,263 2,397 101 41100 150 Workers Compensation - - Personal Services 101 41100 320 Telephone 101 41100 321 Mileage/Travel 101 41100 355 Dues & Memberships 101 41100 360 Education/Training/Conferences 101 41100 801 101 41100 31,848 107 190 945 33,732 13 180 855 Purchased Services 1,242 1,048 Contingency 16,860 16,493 city 2013 2014 2015 29,690 30,000 2,271 2,295 296 102 32,257 32,397 1,636 500 91 200 30 200 1,868 1,250 3,625 2,150 8,334 40,000 30,000 2,295 102 32,397 2,520 5 Ipad contracts $ 210/mo 200 200 WC Mayors Assn $150; LMC Mayors & others $50 2,000 LMC Conference 1 x 250; Elected officials 1 x 350; meeting supplies 500; volunteer recognition dinner 900 4,920 45,000 Y:\Budget 2015 Input\2015 Administration\GF Expense - Council 2015 12/3/2014 City of Otsego General Fund - Expenditures for the year ending December 31, 2015 i Administration 2011 2012 2013 2014 2015 EXPENDITURES 101 41400 101 Wages - FT Employees 101 41400 102 Overtime - FT Employees 101 41400 104 Wages - PT Employees 101 41400 121 PERA 101 41400 122 FICA and Medicare 101 41400 130 Insurance Benefit 101 41400 140 Unemployment Compensation 101 41400 150 Workers Compensation Personal Services 101 41400 201 Office Supplies 101 41400 210 Operating Supplies 101 41400 206 Postage Supplies 101 41400 315 GIS Services 101 41400 320 Telephone 101 41400 321 Mileage/Travel 101 41400 340 Recording Fees 101 41400 347 Newsletter 101 41400 350 Print and Publishing 101 41400 355 Dues and Memberships 101 41400 360 Education/Training/Conferences 101 41400 361 Liability and Property Insurance 101 41400 390 Contracted Services 101 41400 410 Rentals 88,123 194,697 210,208 223,351 226,970 1,256 1,557 2,744 - - - 14,400 432 - - 6,000 29,120 Request for additional; Administrative Assistant, 32 hr/wk, Class 6, Step 4 12,822 15,282 15,874 16,193 19,207 13,936 15,728 15,674 17,086 19,591 5,983 19,657 13,195 14,500 22,069 11,560 3,468 - - - - - 1,170 1,250 1,335 134,413 251,576 256,121 278,380 318,292 12,912 8,549 8,105 7,050 8,500 Divider/Office cubicle $1,850 estimate; - - - - 1,250 Computer if Deputy Clerk/Admin Assistant were to be approved, 3,198 3,300 4,600 4,000 4,000 16,110 11,849 12,705 11,050 30,997 9,561 3,516 - 2,639 6,169 3,724 950 244 857 898 1,100 177 1,256 1,954 1,000 13,599 16,049 18,676 14,400 4,177 4,380 4,822 4,690 11,257 11,173 11,465 12,100 31132 2,827 2,250 4,850 40,047 40,901 5,524 21,290 23,808 7,922 6,862 11,000 10,771 11,742 11,179 12,200 Purchased Services 140,848 112,837 70,870 83,580 101 41400 501 Equipment 4,498 320 - 18,850 Capital 4,498 320 - 18,850 13,750 - to IT 41650 1,450 C/A Cell; share of main phone lines; Add programming fee to update how lines forward/ring; Nova $125 hr labor cost 1,100 Administrator and Clerk mileage 1,000 easements; notice of completion; agreements; others reimbursed by developers 15,972 4/times year; TPC 2,400; Kim Welter 2,000; Helegeson Mailing. Increased volumn for new homes/businesses; postage increase (see separate sheet) 4,690 Legal notices; ordinances 12,159 MCFOA 35; LMC 11,624;ICMA/MAMA 500 2,081 State of Cities 50; I94 Chamber 60; MMUA Safety 871; MCFOA Conf 500; LMC Conference 300; IT Training 100; LMC/GTS training 200 21,929 10,450 Internet $1,500, Laserfiche $2,750, web hosting $700, webdesign $750,web link/laserfiche $3000 annually; laserfiche maint/labor $175 hr- 10 hr block total $1750 12,400 copiers, B/W $1,092; color copier, $3,000; wide format $3,350; postage meter $1,704; plus copy cost 83,231 101 41400 Administration 295 869 376,582 339,696 391,860 415 273 5 Y:\Budget 2015 Input\2015 Administration\GF Expense -Administration 2015 12/3/2014 TO: Lori Johnson, City Administrator FROM: Tami Loff, City Clerk DATE: June 26, 2014 RE: 2015 Budget Administration Staff Recommendation Background: Currently there is no one who is trained to perform the City Clerks job in her absence. Finance Assistant I, Kathy Grover, is assigned Deputy Clerk for signature purpose only. Special Licensing, Sandy Lindenfelser, will perform back minute taking and assembling the City Council packets only. In past years during ,the busy times, we had an Administrative Assistant and Deputy Clerk to perform back up City Clerk jobs. During the recession those positions wer_e.not needed. So when. I.becoi e Gi-ty Clerk. -those positions were eliminated and a majority of those job duties moved with me. As we have grown other duties have been implemented on the City Clerks job description for instance city website, laserfiche, WebQA, etc. This last year things have picked up in development which brings along public hearings and recordings which are on a as they occur basis. This year alone we have had an estimated 11 final plats/replatting; site and building plans; utility drainage easements; that involved public hearings and/or recordings. I have pulled together some recommended job duties and I feel we could possibly do some reassigning --of other-��duties aswelf-, I would--also•-like-to-stress the importance of having another person trained and responsible for Elections as back up Chief Election Official. Deputy Clerk/Administrative Assistant: ® Prepare the Planning Commission packets -and attend the PC Meetings as the recording clerk. Prepare the City Council packets and attend the CC Meetings as the recording clerk in the City Clerks absence. Back up City Clerk on notes for Administrative Subcommittee and Public Works Subcommittee meetings. L, Assist the City Clerk in managing the laserfiche system. ® Laserfiche city files when time permits. Manage/order office Supplies and responsible for coordinating the maintenance of machines (copiers, postage machine, fax machine, phone system etc.) © Back up front desk reception/phones as needed. Assist the City Clerk with Public Hearings Notices. Assist the City Clerk with Recording Documents. © Assist the City Clerk with Elections as Dep.uty_.Ch.ief of Elections. Manage the gambling licenses. ® Assist all departments with clerical work as needed. I highly recommend City Council consider this position at Part-time 32 hours a week for 2015. Wages: Grade 6, Step 4 $ 17.50/hour 32 Hours per week $ 29,120 Benefits: FICA and Medicare @ 7.65% 2,228 PERA Retirement @ 7.50% 21184 Prorated Insurances (dental, medical, STD, LTD, Life) 7,962 Workers Compensation @ $ .44/$100 127 TOTAL COST 7 $ 41,621 HeIReson Maili Printing costs: 5,800 2 color, 2 sides, Newsletter, folded= $1,421.00 Mailing costs: 5,700 Newsletter mailed= $560.00 Postage: 5,700 = $912.00 TPC per issue 400 Kim Welter Design per issue 660 Extra page design from Kim Welter 11,572 1,600 2,640 220 16,032 Fund Account Description EXPENDITURES 101 41410 104 Wages - PT Employees Personal Services 101 41410 210 Operating Supplies Supplies 101 41410 321 Mileage/Travel 101 41410 350 Print and Publishing Purchased Services 101 41410 501 Equipment Capital 101 41410 Elections Fund Account Description EXPENDITURES 101 41410 350 Contracted Services Purchased Services 101 41410 Assessor 2011 2012 2013 2014 2015 Actual Actual Actual Budget Reque! 9,080 10,400 - 9,080 - 10,400 390 13,243 1,442 13,600 390 13,243 1,442 13,600 - 1,561 43 1,700 - 450 - 500 - non election year 700 Two additional M100 Scanner; $60 Annual Firmware Maintenance & Support Fee per unit= $120 additional (5 M100 and 2 AutoMarks= total $420) Working with Elections Systems & Software to do yearly maintenance in house rather than Wright County. 700 45 - 2,011 43 2,200 45 /4S 2011 2012 2013 2014 2015 4ctual Actual Actual Budget Request Comments 67,935 67,904 67,463 70,300 74,700 based on consistent charges with contingency for increase in charge (3.5%) 6/,935 6/,904 b/,4b3 67,935 67,904 67,463 9 Y:\Budget 2015 Input\2015 Clerk-Elections\GF Expense- Elections Assessor 2015 12/3/2014 City of Otsego General Fund - Expenditures for the year ending December 31, 2015 r Fina -n -c -e-------1 2011 2012 2013 2014 2015 EXPENDITURES 101 41600 101 Wages - FT Employees 101 41600 102 Overtime - FT Employees 101 41600 104 Wages - PT Employees 101 41600 121 PERA 101 41600 122 FICA and Medicare 101 41600 130 Insurance Benefit 101 41600 140 Unemployment Compensation 101 41600 150 Workers Compensation Personal Services 101 41600 201 Office Supplies 101 41600 206 Postage Supplies 101 41600 304 Accounting and Auditing 101 41600 320 Telephone 101 41600 321 Mileage/Travel 101 41600 350 Print and Publishing 101 41600 355 Dues and Memberships 101 41600 360 Education/Training/Conferences 101 41600 390 Contracted Services Purchased Services 101 41600 501 Equipment Capital 101 41600 Finance 83,189 141,681 148,130 147,596 153,940 2 Full Time - - - 70,466 74,380 2 Part Time; 1 @ 32 hrs, 1 @ 36 30,435 Audit $ 30,000; Certificate 95,239 hrs 13,041 13,606 11,711 15,880 16,553 13,004 14,827 10,944 16,680 17,466 17,907 20,250 19,201 19,200 24,619 - - 944 1,000 11100 127,141 190,364 190,930 270,822 288,058 979 2,273 5,205 3,280 5,200 979 2,273 5,205 3,280 5,200 2014 Budget Comments 30,350 29,025 29,430 30,000 30,435 Audit $ 30,000; Certificate 95,239 71,305 78,996 75,000 application $ 435 - - - 100 - costs are in City Hail Building Purchased Services 95,239 71,305 78,996 75,000 expenses - - - 300 440 In-state conferences 1,147 922 672 935 1,000 financial statements, OS, budgets, Y:\Budget20l5 Input\2015 Finance\GF Expense- Finance Legal 2015' CIP, GAAFR update 35 35 99 750 640 GFOA (2) $ 340 ; MnGFOA (3) $ 195; MCFOA (3) $ 105 2,386 2,690 4,068 4,000 4,430 Civic Systems $ 1,800 (2 days via web), MnGFOA (2 @ $ 435 per), MCFOA (2 @ $ 415 per), MMUA $ 930 13,048 12,127 11,977 11,000 12,500 Civic Systems, Softronics, ADP Payroll, Wright County Treasurer and Auditor 46,966 44,799 46,246 47,085 49,445 1,864 2,244 - - - binding machine removed 1,864 2,244 - - - Legal Services Fund Account Description 2011 Actual 2012 Actual 2013 Actual 2014 Budget 2014 Budget Comments EXPENDITURES 95,239 71,305 78,996 75,000 82,000 3 year average + $ 5.00/hr 101 41700 301 Legal Services increase Purchased Services 95,239 71,305 78,996 75,000 82,000 101 41700 Legal Services 95,239 71,305 78,996 75,000 82,000 10 Y:\Budget20l5 Input\2015 Finance\GF Expense- Finance Legal 2015' 12/3/2014 Fund City of Otsego General Fund - Expenditures for the year ending December 31, 2015 r Information Technology 2011 Account Description Actual 2012 Actual 2013 Actual 2014 Budget 2015 Request Comments EXPENDITURES 101 41650 201 Office Supplies - - - - - 101 41650 206 Operating Supplies - - 2,764 5,628 6,000 Software support Supplies - - 2,764 5,628 6,000 101 41650 309 IT Support/Licenses - 10,744 480 - - 101 41650 315 GIS Services - - - - 16,000 101 41650 321 Mileage/Travel - - - - - 101 41650 355 Dues and Memberships - - - - - 101 41650 360 Education/Training/Conferences - - - - 2,400 training on Civic Systems modules - non -Finance 101 41650 390 Contracted Services - 24,364 19,516 42,000 41,900 Softronics Purchased Services - 35,108 19,996 42,000 60,300 101 41650 501 Equipment - - - - - Capital - - - - - 101 41650 Information Technology - 35,108 22 760 47,628 66,300 Y:\Budget 2015 Input\2015 Finance\GF Expense - IT 2015 12/3/2014 Fund City of Otsego General Fund - Expenditures for the year ending December 31, 2015 r, City Hall/ Public Works Bldg. 2011 2012 Account Description Actual Actual 2013 Actual 2014 Budget 2015 Requested Comments EXPENDITURES 101 41945 101 Wages - FT Employees - 9,067 - - 101 41945 121 PERA - 500 - - 101 41945 122 FICA and Medicare - - 682 - - 101 41945 130 Insurance Benefit - - - - - 101 41945 140 Unemployment Compensation - - - - - 101 41945 150 Workers Compensation - - - - Personal Services - - 10,249 - 101 41945 201 Office Supplies - 98 - 100 101 41945 210 Operating Supplies - 2,145 4,690 4,300 2014 adjusted for sales tax; 2015 adjusted downward for expereince 101 41945 202 Fuel 1,192 2,000 2,000 101 41945 220 Repair/Maintenance Supplies 1,345 4,690 3,500 2014 adjusted for sales flax; 2015 adjusted downward for experience 101 41950 210 Operating Suppl. - Old Town Hall 333 333 - - 1,000 in the case that an opportunity to put the building to use comes to Dass Supplies 333 333 4,780 11,380 10,900 101 41945 320 Telephone - - 2,080 5,200 3,200 101 41945 322 Utilities - - 24,784 29,900 28,000 101 41950 322 Utilities - Old Town Hall 388 383 401 950 500 101 41945 325 Garbage - - 4,754 - 5,000 garbage and recycling not budgeted In first year of building. 101 41945 361 Insurance - - 6,275 6,463 101 41950 361 Insurance - Old Town Hall - - - 550 500 101 41945 389 Cleaning Services - - 10,293 11,000 11,000 101 41945 390 Contracted Services - - 13,051 15,500 15,500 carpet mats, elevator service, HVAC services, alarm services, fire extinauisher service 101 41950 390 Contracted Svcs.- Old Town Hall - - 878 500 1,000 101 41945 410 Rentals - - - - - Purchased Services 388 383 56,241 69,875 71,163 101 41945 501 Equipment - - - - Capital - - - - 101 41945 City Hall/Public Works 721 716 71,270 8i 255 82 063 12 Y:\Budget 2015 Input\2015 Finance\GF Expense - City Hall 12/3/2014 City of Otsego General Fund - Expenditures for the year ending December 31, 2014 r Planning 2011 Fund Account Description Actual EXPENDITURES 101 46530 104 Wages - PT Employees Personal Services 101 46570 303 Planning Fees 101 46570 321 Mileage/Travel 101 46530 360 Education/Training/Conferences 101 46570 390 Contracted Services Purchased Services 101 46570 501 Equipment Capital 101 46570 Planning 2012 2013 2014 2015 %ctual Actual Budget Requested Comments 540 1,230 1,010 1,700 1,500 Commission compensation 540 1,230 1,010 1,700 1,500 91,213 85,126 68,996 65,000 65,000 see e-mail from TPC - - 10 - - - - - - 750 91,213 85,126 69,006 65,000 65,750 - - - 6,700 - 6,700 - 13 Y:\Budget 2015 Input\2015 Administration\GF Expense -Planning 12/3/2014 PERSONAL SERVICES 101 42410 201 Office Supplies and Expenses 101 42410 201 Fuel SUPPLIES 101 42410 302 Engineering Fees 101 42410 303 Planning Fees 101 42410 315 GIS Services 101 42410 320 Telephone 101 42410 321 Mileage/Travel 101 42410 336 Assessor Fee -New Construction 101 42410 348 Miscellaneous 101 42410 350 Print and Publishing 101 42410 355 Dues and Membership 101 42410 360 Educadon/Training/Conferences 101 42410 361 Liability/PC Insurance 101 42410 390 Contracted Services 101 42410 410 Rentals 101 42420 303 Planning Fees CONTRACTUAL SERVICES 101 42410 720 Operating Transfers TRANSFERS 101 42410 501 Equipment EQUIPMENT 223,752 1,305 3,967 5,272 4,353 8,952 5,997 3,559 1,636 2,286 257 87,438 27,684 2012 2013 2014 2015 46,187 25,000 3,334 3,393 6,197 467 4,326 88,904 2,019 3,520 5,364 5,134 216 1,500 175 2,334 785 77,974 3,772 46,108 49,275 6,250 - 3,421 3,769 3,366 3,572 7,467 6,716 - 355 255 350 66,867 64,037 2,351 2,100 1,301 4,600 3,652 6,700 4,974 4,000 5,259 6,500 - 10,000 1,646 2,600 345 - - 7,000 226 - 125 175 526 785 - 295 94,392 108,400 3,871 5,200 545 111,363 144,955 - - 21,104 - - 21,104 16,000 - - 16,000 50,066 3,630 3,830 9,264 356 67,146 2,200 4,000 6,500 - moved to IT 41650 1,800 10,000 275 ICC $ 125; MBPTA $ 150 232 MMUA 124,800 48 hours of inspection services per week 4,270 printer/plotter 151,877 _now included in GF 4,000 vehicle replacement charge 4,000 YABudget 2015 lnput\2015 Administratlon\GFExpense-Building Safety 2015 14 12/3/2014 City of Otsego Building Safety for the year ending December 31, 2015 Building Inspection 2011 and Account Description Actual EXPENDITURES 101 42410 101 Full -Time Employees Regular 62,431 101 42410 119 Payroll Allocation 138,800 101 42410 121 PERA 4,550 101 42410 122 FICA and Medicare 4,248 101 42410 123 Health 12,184 101 42410 130 Other Emplolyee Insurance 509 101 42410 140 Unemployment Compensation 1,030 101 42410 150 Workers Compensation - PERSONAL SERVICES 101 42410 201 Office Supplies and Expenses 101 42410 201 Fuel SUPPLIES 101 42410 302 Engineering Fees 101 42410 303 Planning Fees 101 42410 315 GIS Services 101 42410 320 Telephone 101 42410 321 Mileage/Travel 101 42410 336 Assessor Fee -New Construction 101 42410 348 Miscellaneous 101 42410 350 Print and Publishing 101 42410 355 Dues and Membership 101 42410 360 Educadon/Training/Conferences 101 42410 361 Liability/PC Insurance 101 42410 390 Contracted Services 101 42410 410 Rentals 101 42420 303 Planning Fees CONTRACTUAL SERVICES 101 42410 720 Operating Transfers TRANSFERS 101 42410 501 Equipment EQUIPMENT 223,752 1,305 3,967 5,272 4,353 8,952 5,997 3,559 1,636 2,286 257 87,438 27,684 2012 2013 2014 2015 46,187 25,000 3,334 3,393 6,197 467 4,326 88,904 2,019 3,520 5,364 5,134 216 1,500 175 2,334 785 77,974 3,772 46,108 49,275 6,250 - 3,421 3,769 3,366 3,572 7,467 6,716 - 355 255 350 66,867 64,037 2,351 2,100 1,301 4,600 3,652 6,700 4,974 4,000 5,259 6,500 - 10,000 1,646 2,600 345 - - 7,000 226 - 125 175 526 785 - 295 94,392 108,400 3,871 5,200 545 111,363 144,955 - - 21,104 - - 21,104 16,000 - - 16,000 50,066 3,630 3,830 9,264 356 67,146 2,200 4,000 6,500 - moved to IT 41650 1,800 10,000 275 ICC $ 125; MBPTA $ 150 232 MMUA 124,800 48 hours of inspection services per week 4,270 printer/plotter 151,877 _now included in GF 4,000 vehicle replacement charge 4,000 YABudget 2015 lnput\2015 Administratlon\GFExpense-Building Safety 2015 14 12/3/2014 City of Otsego f General Fund - Expenditures for the year ending December 31, 2015 Public Safety 2011 Fund Account Description Actual 101 42100 390 Contracted Services Police Services Police Commission 101 42150 104 Wages - PT Employees 101 42150 210 Operating Supplies 101 42150 350 Print and Publishing Police Commission Fire Protection 101 42200 390 Contracted Services Fire Protection Emergency Management 101 42500 210 Operating Supplies 101 42500 322 Utilities 101 42500 360 Education/Training/Conferences 101 42500 390 Contracted Services Emergency Management Animal Control 101 42710 390 Contracted Services Animal Control 101 Public Safety 2012 2013 2014 2015 861,410 875,045 882,601 912,500 941,700 40 hours per day - 3.2% increase - 347,922 365,873 375,850 454,560 per contract approved July 22, 2013 861,410 875,045 882,601 912,500 941,700 690 590 640 750 750 501 782 759 600 600 1,191 1,372 1,399 1,350 1,350 - 347,922 365,873 375,850 454,560 Albertville (increase based on Fr Chief)= 225,701; Rogers .00044 X market value (est 5% MV increase) = 28,827; Elk River 3% increase per contract to 58.83 per parcel (est 3,400) = 200,022. - 347,922 365,873 375,850 454,560 - 895 1,000 2,500 operating supplies for EOC - - 373 550 450 - - 382 5,000 2,500 EOC exercises, Emercency Management Traininq courses - 728 1,300 2,000 2,000 radio and siren contracts & repair - 728 2,950 8,550 7,450 15,274 10,915 11,058 11,000 11,300 Y.\Budget 2015 Input\2015 Finance\GF Expense - Public Safety 2015 15 12/3/2014 City of Otsego General Fund - Expenditures for the year ending December 31, 2015 r, Streets 2011 2012 2013 2014 2015 Fund Account Description Actual Actual Actual Budqet Reque: 101 43100 101 Wages - FT Employees 101 43100 102 Overtime - FT Employees 101 43100 104 Wages - PT Employees 101 43100 121 PERA 101 43100 122 FICA and Medicare 101 43100 130 Insurance Benefit 101 43100 140 Unemployment Compensation 101 43100 150 Workers Compensation Personal Services 101 43100 201 Office Supplies 101 43100 202 Fuel 101 43100 210 Operating Supplies 101 43100 220 Repair/Maintenance Supplies 101 43100 225 Uniforms/Clothing Allowance 101 43100 227 Safety Supplies 101 43100 234 Blacktop Supplies 101 43100 240 Small Tools and Equipment 101 43100 270 Sand and Gravel 101 43100 272 Salt and Sand 101 43100 292 Culverts 101 43100 293 Sign/Signal Materials 101 43100 295 Sign/Signal Reimbursement Supplies 101 43100 301 Legal Services 101 43100 320 Telephone 101 43100 322 Utilities 101 43100 325 Garbage Service 101 43100 350 Print and Publishing 101 43100 355 Dues and Memberships 101 43100 360 Education/Training/Conferences 101 43100 361 Liability and Property Insurance 101 43100 389 Cleaning Services 101 43100 390 Contracted Services 101 43100 410 Rentals 101 43100 436 Dustcoating 101 43100 720 Operating Transfers Purchased Services 101 43100 501 Equipment Capital 101 41400 Streets 279,184 337,413 6,736 5,280 15,746 11,729 22,475 26,250 23,522 26,792 34,105 39,817 308 44 382,076 1,700 56,544 16,604 17,850 6,300 1,946 7,544 10,156 20,304 63,449 2,914 11,006 215,263 116 8,212 21,622 1,662 70 3,061 43,695 5,431 61,903 1,340 11,668 529,772 688,552 447,325 1,124 55,431 25,161 25,090 6,786 3,020 9,997 11,840 22,110 24,272 7,331 7,971 386,973 21,746 28,165 48,648 19,255 504,787 2,266 2,845 2,724 5,226 1,893 16,154 6,654 13,143 75,032 17,204 Comments 193,943 142,097 see attached details 310,971 297,128 275 8,000 8,000 10,355 12,900 52,268 calculations corrected (3,000) 23,125 26,805 calculations corrected 894 25,809 27,341 calculations corrected (10,569) 32,400 37,910 calculations corrected 3,061 20,200 20,200 - 433,405 469,652 500 485 500 3,953 3,755 3,265 34,343 4,690 4,690 24,154 2,950 3,940 - 1,875 1,875 5,368 13,135 15,000 3,471 9,380 9,380 5,750 23,450 20,000 13,500 60,970 75,000 21,575 12,800 additional 2,300 for sign replacement program 193,943 142,097 142,265 146,450 - 275 - - 10,355 5,872 4,500 5,040 22,485 1,285 500 1,200 1,021 77 - 500 311 158 - - 100 100 500 500 4,047 3,953 4,675 7,577 additional for MMUA safety training 34,343 1,016 23,450 24,154 7,993 - - - 22,417 5,368 5,000 5,000 3,471 922 2,815 5,750 12,844 13,081 13,500 15,300 119,387 32,107 54,940 65,021 Y:\Budget20151nput\2015 PublicWorks\GFFxpense- Streets 2015 16 12/3/2014 17 2015 Street Department Budget Detail 43100201 Office Supplies Reclassify random and pre-employment drug and alcohol testing and pre-employment background checks to 101-43100-390. Office supplies are office only related expenses including paper, pens, pencils, markers, batteries, log books, white boards, folders, etc. Estimated at $500 43100210 Operating Supplies Operating supplies needed for street maintenance and repair includes herbicides, flags, snow plowing markers, lathe, marking paints, roadside cleanup materials, etc.. Based on past expenditures and 2015 projections reduce budget to $3500. 43100220 Repair Supplies Repair supplies include materials for repair ofstreet and ROW maintenance and repair including curbs,sidewalks, ditches, mailboxes, etc. Materials include concrete, lumber, herbicide, topsoil seed, fertilizer, plow markers, flags, erosion protection materials, etc. 43100225 Uniforms/Clothing The Street Department uniform budget is bases on the uniform policy approved in 2014. Included are uniforms for six full time employees and four seasonal employees. Full time employees are allotted $400 each for uniforms and $150 each for boot allowance. The estimated allowance for uniforms and boots for four seasonal employees is $160 each. The 2015 budget is estimated at$3940. 43100227 SafetySupplies Employee personal protective equipment Includes hard hats eyewear, hearing protection, specialty gloves, reflective vests and jackets, etc.. Other Includes traffic cones and barricades, harnesses, mist. signs and placards, first aid kits, fire extinguishers, other mist. 43100234 Blacktop Supplies Blacktop patching and repairs will be performed by City staff In preparation ofthe streets proposed to be seal coated and fog sealed in 2015 and to patch potholes in streets designated preventative maintenance only. It is estimated with the bituminous street infrastructure aging and a slight increase in asphalt repair supply costs, the 2015 blacktop supply budget be increased to $15,000. 43100240 Small tools and Equipment Used forthe purchase and replacement ofsmall tools and equipment under CIP values. Alist of needs (tools& equipment) to be considered is maintained and joint department purchases are encouraged when possible. The recommended purchases for 2015 Include $5000 to upgrade a another existing vehicle assigned to winter snow and ice control to apply deicing chemicals and a 3 -point landscape rake to repair ROW and ditches estimated at $1500. The 43100270 Sand and Gravel The budget decrease is based on the anticipated reduction of lineal miles and use ofgravel roads to maintain and previous annual actual expenses.. Consideration given to the(bituminous) improvement of70th street in 2015 and continuing the annual dust control program. The 2015 budget request in the amount of$20,000 will purchase approximately 2800 ton of classy gravel including delivery. 2500 ton will be dedicated to gravel road repairs, 300 ton for repairing the gravel shoulders of bituminous rural roads. 43100272 Salt/Sand The proposed budget is based an past product use, service levels, and current salt inventory available. The 2014-15 State of MN contract for salt has been awarded and is based on Otsego purchasing 900 ton oftreated and untreated salt at an average price of$80.58 per ton ($72,500). The unexpended monies from the 2014 general fund for salt/sand($39,400) will purchase approximately 500 ton ofthe 900 ton contracted for 2014-15 winterseason. Theremaining 400 ton($33,100) ofthe 2014-15 salt contract will be purchased with $33,100 ofthe $75,DD0 2014 budget for salt sand, leaving $40,000 forthe purchase of deicing chemicals and salt/sand to he used in the fall of2015. Additional street mileage for new subdivisions has been included. 43100293 Sign/Signals Materials The 2015 estimate for Sign/signal material Includes the estimated purchase ofreplacement hulbsforthe City maintained signal lights($1000),materialsto complete the blanket replacementofstreetsigns ($1500), and the purchase of materialsto repairand maintain signs throughout the City$8,000. Industry standards recommend a maintenance budget of4% ofthe value of all signs In the City. The estimated value of the street signs in Otsego is $200,000 x4%= $8,000. 2015 budget estimated at $10,500. 43100320 Telephone Includes 2 -1 -Pads, one for Sign Management and one for the Street Supervisor. 2-1 Phones, one each for the Street Supervisor and Lead Worker.5-standard cell phones with direct connect Estimated monthly expense for 2015 is $420 or $5,040 annually. 43100322 Utilities The budget for utilities Includes electric and gas service to the old public works facility which is used forstorage. Atthistime the facilities require no heat. Estimated budget for 2015 is $100 per month. 43100325 Garbage service $500 for disposal of trash and appliance from ditch clean up. 43100355 Dues and Memberships American Public Works Assoc/ MN Public Works Assoc. -$350, MN Street superintendents Assoc -$150 43100360 Education/rraining/Oonferences The 2015 budget request provides for training six employees. Approximately $3,000 is forsafety training(MMUA) and the remainderwill include two employees to attend plow truck simulator training. Other training will include the The Fall Expo in St. Cloud, gravel road maintenance, sign maintenance, winter maintenance, and UNNC loss control workshop. 43100390 Contracted services The 2015 budget of$5,000 is estimated to fund contracted services including repair ofsignal luminaires ($1400), contract curb repair ($2000), drug and alcoholtesting, new employee background tests, contract computer repair, maintenance upgrades for sign management software contract computer repair ($1,000). `Move drug testing here from office supplies (431002010) 43100410 Rentals Minimal tree trimming was necessary in 2014. Anticipate more for 2015 requiring tree chipper rental of$1,500. Asphalt mill for bituminous repairs estimated for three days at$250per day=$750. Add request to rent a power screen at a cost of$3,500 per week. The screen is proposed to screen debris from street sweepings, screen topsail stockpiled west ofthe ballfields in Prairie Park, and screen compost to assist Albertville In Maintaining the compost site. Albertville stated that screened compost would be available to Otsego residents. Also other mist. equipment rental as needed. If an asphalt roller is not purchased in 2014, add $1500. 43100436 Dustcoating Recommend dust control be applied on the same roads as 2014. Residents may request additional dust control at their expense. The City funds dust control an approximately 5.5 miles ofgravel roads. The 2014 price for calcium chloride increased to $.96 per gallon. The 2015 budget is estimated at $1.00 per gallon x15,300 gallons. 17 City of Otsego General Fund - Expenditures r for the year ending December 31, 2015 Engineering 2011 2012 2013 2014 2015 Fund Account Description Actual Actual Actual Budget Budget EXPENDITURES 101 43150 210 Operating Supplies - - - - - Supplies 101 43150 302 Engineering Fees 101 43150 348 Utility Locates Purchased Services 101 43150 501 Equipment Capital 101 43150 Engineering vc.,J iNuwi EXPEND]TURES 101 43160 350 Utilities Purchased Services 101 43160 Street Lights Comments 108,422 78,720 100,369 85,000 85,000 from HAA; 3 year average is $ 95,000 38,999 49,994 60,456 - - in Utilities beginning in 2014 147,421 128,714 160,825 85,000 85,000 2011 2012 2013 2014 2015 Actual Actual Actual Budget Budget Comments 97,046 108,775 109,667 110,000 114,100 1% energy cost increase, 3% system growth 97,046 108,775 109,667 110,000 114,100 18 Y:\Budget 2015 Input\2015 Finance\GF Expense - Engineering 12/3/2014 Dan Jordet From: Ron Wagner <RonW@HAA-inc.com> Sent: Monday, June 30, 2014 11:15 AM To: Lori Johnson Cc: Dan Jordet Subject: RE: engineering budget items Lori The $85k was for the overall engineering general items An estimated breakdown would look like Council & Other Meetings w/ Council $5,000 estimate 40 to 50hrs/year Prepare Agenda Items $7,000 estimate 70hrs/year General Streets $3,000 estimate 20 to 30hrs/year Finance Questions, CIP, Budget $7,000 estimate 70hrs/year Sanitary Sewer $3,000 estimate 20 to 30hrs/year Water $3,000 estimate 20 to 30hrs/year City Maps $3,000 estimate 30 to 40hrs/year Staff/Developer Mtg $3,000 estimate 20 to 30hrs/year GIS Support— depends on GIS decision $10,000 estimate 140 to 150hrs/year Public Works Sub Mtg And Memos $5,000 estimate 40 to 50hrs/year Grading and Storm Water Issues $10,000 estimate 100 hrs/year Review Permits (ROW and fence, and Land alteration) $10,000 estimate 100 hrs/year Street Renewal $5,000 estimate 40 to 50 hrs/year Engineering Manual $1,000 estimate 10 hrs/year Street Signage $1,000 estimate 10 hrs/year Park Questions $1,000 estimate 10 hrs/year Wetland issues $1,000 estimate 10 to 15 hrs/year NPDES Compliance $7,000 estimate 90 to 100 hrs/year Total $85,000 estimate 840 to 895 hrs/year based on $60 to $107.5/hr billing rates with majority being Brent and Ron time. Hope this helps. !!' Ande'r'son — Ronald J. Wagner, Otsego City Engineer 3 601 Thurston Avenue 19 city of Otsego General Fund - Expenditures for the year ending December 31, 2015 Flpnt Mannnament 1 2011 2012 2013 2014 2015 uesaipuuu EXPENDITURES 101 43240 101 Wages - FT Employees 101 43240 102 Overtime - FT Employees 101 43240 104 Wages - PT Employees 101 43240 121 PERA 101 43240 122 FICA and Medicare 101 43240 130 Insurance Benefit 101 43240 140 Unemployment Compensation 101 43240 150 Workers Compensation Personal Services 101 43240 201 Office Supplies 101 43240 202 Fuel 101 43240 210 Operating Supplies 101 43240 220 Repair/Maintenance Supplies 101 43240 225 Uniforms/Clothing Allowance 101 43240 227 Safety Supplies 101 43240 240 Small Tools and Equipment Supplies 101 43240 322 Utilities 101 43240 355 Dues and Memberships 101 43240 360 Education/Training/Conferences 101 43240 361 Liability and Property Insurance 101 43240 389 Cleaning Services 101 43240 390 Contracted Services 101 43240 720 Operating Transfers Purchased Services 101 43240 501 Equipment Capital 101 43240 Fleet Management 6,486 5,%UU 8,St5u Y:\Budget 2015 Input\2015 Public Works\GF Expense - Street Dept. 20 12/3/2014 see attached details - 20,093 62,503 53,581 - 4,739 4,530 3,885 - 1,494 4,780 4,099 - 8,550 6,887 9,118 - 370 400 2,163 - 35,246 79,100 72,846 - 62,505 63,400 64,034 combined streets/parks maintenance needs - 29,044 18,480 15,800 additional 2,000 for tires - 10,969 18,760 22,000 combined streets/parks maintenance needs - - 1,500 1,500 - 3,881 4,690 2,500 - 106,399 106,830 105,834 - 632 700 1,080 additional for MMUA safety training - 5,854 5,000 7,500 6,486 5,%UU 8,St5u Y:\Budget 2015 Input\2015 Public Works\GF Expense - Street Dept. 20 12/3/2014 2015 STREET DEPARTMENT FLEET EXPENDITURES DETAIL 43240202 Fuel Estimate 14,000 gallons The 2015 estimated budget of $52,500 for Fuel (diesel and gas) to operate Street Department assigned equipment is based on actual fuel used the paAl2 combined of gas and diesel fuel months. An additional 3.07S gallons has been added for Park maintenance fuel. @$3.75 average per ga1lon=$52,500 43240210 Operating Supplies Hard repair parts for vehicle and The 2015 budget estimate of$13,800 for Street Department repair supplies is based on the current condition ofvehitles and equipment assignedto the street equipment components e.g.: department, reviewing the past 12 months of expense history, and considering current schedules for replacement. The remaining amount is for Fleet engine, transmission, hydraulics, Department supplies not recorded on work orders and used for quick fixes such as nuts,bolts, connectors, tape, aerosol lubricants,oxygen/acetylene grinding electrical, chassis, drive train, wheels, etc. and suspension parts. 43240220 Repair Supplies Cutting edges -$8,000, Oils and The 2015 budget for operating supplies estimates Street Department expendit—af$2,000 fortires,$7000 forcutting edges ferthe snowplows and grader, lubricants-$3,5DOTlres-$4,500, $2,400 farstreet sweeper brooms and brushes, and $3,500 for oils and greases. The remaining $750 will fund mise supplies such as cleaningsupplies,floor sweeperlamomsandrubbers- dry and other Fleet Department supplies. Park mi t n n has alsosubmitted a separate rq esti rth it own repair andmaintenance uppli sial udimt S $2,400, mise wear items -$3,600 1000 for cutting edges, $2,500 for tires. and general maintenance items of$2850. 43240225 Uniforms/Clothing 1 -employee rental uniforms and 2014 budget for uniforms/clothing is to provide rental and cleaning of uniforms, and purchase ofsafetyshoes for one employee. The current contract service is safetyshoes with G&K which also provides rags for the fleet department and rugs and other supplies for the facilities. 43240240 Small tools/Equipment Specialty Fleet Department The small tools/equipment budget for 2015 of $2,500 is to be used to purchase additional specialty hand tools as needed for staff assigned to perform fleet specifictools. repair. The reduction is based an other departments providing fortheir own hand tools. 43240360 Educ/Train/Ccnf MMUASafety4550, Fall Expo Verify prorated cost ofsafety training for Fleet Department employee. $50, DOT Inspec Cert. $100 43240390 Contracted services Tire service, fuel system The Contracted services budget for Fleet Management was originally intended as a reserve, budget to contract unexpected major repairs such as an engine or inspections and repairs, Fre ext. transmission failure. Recent history has utilized the contractual budget for contract repairs and service for the fuel system, shop equipment repair 2 -way radio service, 2 -way radio service, service and repair, and inspections required. The 2015 contracted services budget considers an additional $2,500 for unexpected contract repair of Vehicle crane inspection, and Equipment major components. Replacement of Equipment as recommended in the CIP may reduce the estimated expenditures to repair major Software(Tatems) maint- components. Rage/Tmvels, etc 21 City of Otsego General Fund - Expenditures for the year ending December 31, 2015 -r Park Maintenance 2011 Actual Fund Account Description 43,648 32,120 D(PENDII-URES 101 45200 101 Wages - FT Employees 101 45200 102 Overtime - FT Employees 101 45200 104 Wages - PT Employees 101 45200 121 PERA 101 45200 122 FICA and Medicare 101 45200 130 Insurance Benefit 101 45200 140 Unemployment Compensation 101 45200 150 Workers Compensation 24,336 Personal Services 101 45200 201 Office Supplies 101 45200 202 Fuel 101 45200 210 Operating Supplies 101 45200 220 Repair/ Maintenance Supplies 101 45200 225 Uniforms/Clothing Allowance 101 45200 227 Safety Supplies 101 45200 240 Small Tools and Equipment Supplies 2012 2013 2014 2015 35,693 49,660 43,648 32,120 - - 4,917 2,682 6,225 5,188 3,799 3,222 9,630 7,520 3,395 - - 991 87,548 63,661 57,481 - - 781 4,568 6,119 - 6,386 14,808 24,336 19,225 13,399 9,627 304 - - 1,154 2,213 5,775 5,896 40,101 82,300 84,148 1.4 FTE of full time staff 43,600 52,126 additional 1,980 hours of seasonal requested. see attached explanation 6,000 6,101 9,650 10,425 for additional staffing request 2,900 3,674 1,050 2,771 145,500 159,245 - 230 Misc. office supplies for the Park Lead; Drug Testing & Background Checks for Employees 26,500 37,970 $7,000 Fertilizer; $2,600 Mulch; $4,000 Ballfield Paint; $5,000 Field Maintenance Supplies(Chalk, Diamond Dry, Aglime, Bases); $4,000 Playground Woodchips; $10,000 Court Surface Repair & Maintenance; $2,000 Skatepark Re - Surface; $1,000 Dust control soccer field parking lot; $2000 misc. Increase in 2014 due to the addition of court repair and maintenance being added into the Operating Budget also the skatepark re- surface. $3,000 for hockey boards removed 11,755 15,500 $1,500 Dirt & Black Seed; $4,000 Irrigation Supplies (Valves, Heads, Controllers, Irrigation Boxes); $6,000 Playgrounds; $4,000 Misc. Repairs (Shelters, Fencing, Splash Pad, Planters) Increase over last year by $3,745 due to the addition of the soccer fields and aging infrastructure. 1,100 1,430 $400 x 2 Full Time Staff Clothing Allowance; $150 Full Time Boot allowance x 2; $60 Seasonal Boot Allowance x 6; $55 Seasonal Seasonal Clothing Allowance (2 Shirts, 1 Hat, 1 Sweat Shirt) x 6 560 1,200 Safety Glasses, Gloves, Cutting Gear, Helmets, Face shields, Goggles, Hearing protection. 4,690 5,000 Small hand tools, weed whips, backpack blower, shovels, power tools, ballfield tools. snow eauipment 44,605 61,330 Y:\Budget 2015 Input\2015 Parks & Recreation\Completed 22 1 12/3/2014 Fund Account Description 2011 2012 2013 Actual Actual Actual 2014 2015 Budget Requested Comments 101 45200 320 Telephone 5,403 1,500 2,850 Average monthly Verizon bill through June 2014 was $188, That does not include seasonal phones, which would add an additional $60 per month June - August; $25 per month for long distance service; $110 Misc. cost 101 45200 322 Utilities 20,586 26,399 28,239 28,700 29,086 security lights for parks and parking, water, irriqation, sewer 101 45200 325 Garbage Service 98 437 - 1,200 Parks generates a majority of the garbage in the summer months. Adding an additional 3 yard dumpster with a twice a week service and 6-35 gallon cans is what is needed to keep up with garbage. The dumpster service is $155 per month April -September and the can service is $14 per month year around. $100 misc. costs. 101 45200 350 Print and Publishing - - - - 101 45200 355 Dues and Memberships - 264 - 600 Minnesota Recreation & Parks Association; Minnesota Nursery & Landscaoe Association 101 45200 360 Education/Training/Conferences - 98 2,083 2,750 3,509 $ 1,859 MMUA Training Annually; $1,650 Greens Expo; Playground Maintenance Classes; The safety committee is recommending the additional day to assist staff develop policies and operating procedures that currently are not in place. 101 45200 361 Liability and Property Insurance 27,291 26,600 - 35,350 36,411 101 45200 390 Contracted Services 26,806 23,905 30,015 34,600 34,500 $11,000 For Herbicide Control; $4,000 Fertilizer Application; $14,500 Port -0 - Potties; Irrigation Repair & Maintenance $3,600; Misc. $2,000. The Port -o -Potty number went up due to the need for additional toilets at the new soccer fields. However, the herbicide quote went down therefore decreasing the overall number. 101 45200 410 Rentals 11,727 12,593 470 1,875 2,000 Ditch Diggers, Stump Grinders 101 45200 720 Operating Transfers 140,000 - - - - Purchased Services 226,410 89,693 66,911 104,775 110,156 101 45200 501 Equipment - - - - 13,120 $6,200 For a broom attachment on the skidster which will be used to broom off trials, ice rinks, and remove lips around infields; $6,920 Boss V -Plow which would replace the Blizzard plow currently on #38. The Boss plow are interchangeable and would be able to be installed onto a new truck should #38 be traded in. Capital - - - - 13,120 101 45200 Park Maintenance 346 350 193,455 166,490 294,880 343851 Y:\Budget 2015 Input\2015 Parks & Recreation\Completed 23 12/3/2014 2015 PROPOSED PARKS STAFFING STRUCTURE MOWING: In 2014, the City began mowing the W WTF properties which was contracted in the past. Staff estimated that it would take a City crew about 9 hours to mow all of the W WTF each week and the properties would be mowed about 15 times per year. The estimated staff cost including benefits is $1,185, and estimating $1,500 in fuel cost and vehicle depreciation, the 2014 City cost for mowing the WW -TF is estimated to be $2,685. The contracted cost to mow the W WTF in 2013 was $11,616.24 which is a difference of $8,931.24. In 2013, the City began mowing the boulevards which were contracted prior to 2013. Staff estimates that that it takes City Crews 12 hours a week and about 15 times each year to maintain the boulevards. The estimated costs are $2,333.50 for staffing with benefits, and $2,005 for fuel and vehicle depreciation for a total cost of $4,338.50. The contracted amount in 2012 to mow the boulevards was $13,862 which is a difference of $9,523.50. Mowing Crew: Wide Area mower 1 staff 31 hours per week x 22 weeks Trim Mowing 2 staff 32 hours per week each x 14 weeks BALLFIELD MAINTENANCE: Staff have continued to work with the area youth sport associations to improvethe field maintenance throughout the City. Staff currently lines all of the City's soccer fields and baseball fields, they also maintain 5 baseball game fields (4 at Prairie Park and 1 Zimmer Park) and a practice field at Frankfort Park. Ballfield Crew: Daily maintenance 2 staff 8 hours per week each x 14 weeks Lining ballfields 1 staff 6 hours every week x 14 weeks TREE & MULCH MAINTENANCE The City currently has a large inventory of trees planted in non -irrigated areas throughout the City. In order to maintain these trees, Staff must go out and water each tree from a watering truck throughout the summer. Depending on weather conditions and condition of the trees this process may have to be repeated for many years. Each ofthe eight parks has many other amenities that add to a quality experience for park users. The amenities that require bi-weekly attention include planters, playgrounds, and sport courts. Planter, tree, sport court Maintenance 1 staff 7 hours everyother week x 18 weeks Weekly Playground Maintenance 1 staff 2 hours every other week x 18 weeks PARK GARBAGE There continues to be an increase in use throughout the park system. Staff have noticed that garbage accumulation has increased over the past 2 years requiring more stafftime to maintain garbage throughout the season. Weekly Garbage 2 staff 5 hours every week x 18 weeks GENERAL MAINTENANCE Currently the City has 1 FTE park employee, and to assist him with his duties the City added a 6 month seasonal employee in 2013. This position assists the park lead With many duties throughout their seasonal employment. Over the past two years, this position has been extremely valuable especially during the early spring and early fall seasons when the other weekly maintenance (mowing, weed whipping) is still needed to be performed and the majority ofthe other seasonal employees wither haven't started or are gone for the season. Staff is recommending adding an additional 5 month seasonal park position. If approved, this position would start May 1 and work until October 31. The current position starts April land runs until September 30. The proposed position would start a month later than the current position and would add assistanceto the Park Lead in the late fall with maintenance. If approved, staff would seek out an individual with irrigation experience to assist with irrigation repairs, start-ups, and winterization. The 2013-2014 irrigation winterization and start-up contract cost was $1500. This position would also assist and lead maintenance project throughout the City to include trim mowing, ball field maintenance, irrigation repair and maintenance, and Splash Pad repair and maintenance. The assistance with these tasks would allow more time for the Park Lead to do safety inspections ofthe playgrounds, skatepark, athletic fields, and trails. it would also allow more time for follow through with contractors and better supervision of the seasonal employees. (2) General Maintenance 2 $taff at 27 weeks x 40 hrs/wk WINTER MAINTENANCE With the addition ofthe hockey rink, staffwould like to propose seasonal position be added from December Vto February lnfor 10 hours per week to help with maintenance. if approved this person would assist with the daily sweeping, shoveling, and flooding of the hockey rink. This would all for a quicker turnaround after snow events and allow staffto spend more time on snow removal on the trails. Staff December 1 -October 1 9 weeks x 10 hrs/wk STAFFING BREAKDOWN 2 Staff (27 weeks) 1 Staff (22 weeks) 1 Staff (llweeks) 2 Staff (14weeks) 1Staff December 1 -February 1(9weeks) 40hrs/wk ($11) $23,760 31hrs/wk ($13) $8,866 40hrs/wk ($13) $5,720 40hrs/wk ($11.50) $12,880 10hrs/wk ($10) $1000 Total $52,226 24 GENERAL MAINTENANCE Staff is recommending adding an additional 6 month seasonal park position. If approved, this position would start May 1 and work until October3l. The current position starts April 1 and runs until September 30. The proposed position would start a month laterthan the current position and would add assistance to the Park Lead in the late fall with maintenance. If approved, staff would seek out an individual with irrigation experience to assist with irrigation repairs, start-ups, and winterization. The 2013-2014 irrigation winterization and start-up contract cost was $1500. This position would also assist and lead maintenance project throughout the City to include trim mowing, ball field maintenance, irrigation repair and maintenance, and Splash Pad repair and maintenance. The assistance with these tasks would allow more time forthe Park Lead to do safety inspections of the playgrounds, skatepark, athletic fields, and trails. It would also allow more time for follow through with contractors and better supervision ofthe seasonal employees. 1 staff for 27 weeks x 40 hrs/wk at ($11) WINTER MAINTENANCE With the addition of the hockey rink, staff would like to propose a seasonal position be added from December 111to February 111for 10 hours per week to help with maintenance. If approved this person would assist with the daily sweeping, shoveling, and flooding of the hockey rink. This would all for a quicker turnaround after snow events and allow staff to spend more time on snow removal on the trails. 1 Staff December 1 -February 1 (9 weeks) x10 hrs/wk ($10) 25 City of Otsego General Fund - Expenditures for the year ending December 31, 2015 Recreation 2011 2012 2013 2014 2015 Account Description Actual Actual Actual Budget Request 101 45250 101 Wages - FF Employees 101 45250 102 Overtime - FT Employees 101 45250 104 Wages - PT Employees 101 45300 104 Wages - PT Employees - HPC 101 45250 121 PERA 101 45250 122 FICA and Medicare 101 45250 130 Insurance Benefit 101 45250 140 Unemployment Compensation 101 45250 150 Workers Compensation Personal Services 101 45250 201 Office Supplies 101 45300 201 Office Supplies - HPC 101 45250 210 Program Supplies 101 45250 240 Equipment Supplies 101 45250 320 Telephone 101 45250 350 Print and Publishing 101 45250 225 Uniforms - 45,058 54,208 38,700 40,235 .6 FTE of full time staff 720 1,915 1,141 15,600 20,779 Recreation Admin Assistant in 2013 seasonal rec staffing in 2013 for programs was $3,628.50. Staff expects this number to increase slightly for exsisting programs due to wage increases. Staff also estimates an additional $1,000 in seasonal recreation staff, which a majority is paid for by recreaiton program revenues. 450 590 670 450 450 - 3,163 2,876 4,150 4,088 - 3,437 4,009 3,950 4,314 - 2,966 5,089 2,450 3,050 - - 663 700 1,834 1,170 57,129 68,656 66,000 74,750 36 31 963 1,875 210 Staff has moved Rec, office supplies (101-45250-201)to the Prairie Center office supplies because the Recreation Department is now housed in Prairie Center and the supplies are used for both. Background checks for recreation staff will still be taken out of recreation office supplies 544 465 470 500 - 282 3,000 10,820 $7820 in program supply costs in 2013 which included (participant shirts, sporting equipment, arts & crafts supplies, and program refreshments) staff estimates that number to remain consistent for exsistmg programs; Estimated $3000 in new program supply cost. Programs to include (outdoor rec class, adult flag football, senior programming) a majority of these costs will come from program revenue. 11,530 36 575 1,710 5,345 - - 244 1,500 2,300 Cell service for two employees & Ipad Service for one employee. ($175 per month; $200 equipment & upgrades) - - 2,705 5,910 6,000 $1300 for P&R Brochures printing throughout the year; $2000 for designs services both flyer and website; $2,700 for mailing the brochure. 300 $100 Admin. Assistant Uniforms; $200 Recreation Assistant Uniforms (2 T -Shirts & 1 Hat per staff) Y:\Budget 2015 Input\2015 Parks & Recreation\Completed 26 12/3/2014 Fund Account Description 2011 2012 Actual Actual 2013 Actual 2014 2015 Budget Requested Comments 101 45250 360 Education/Training/Conferences - - - 1,500 2 Staff for the MRPA Annual Conference(Minnesota Recreation & Parks Association); 2 Staff MRPA(Minnesota Recreation & Parks Association) annual membership; Program networking opportunites 101 45250 360 Education/Training/Conferences - - - - 232 MMUA Safety Training 101 45300 360 Education/Training/Conf. - HPC 255 - - 300 300 101 45250 361 Liability and Property Insurance - - 1,279 - - 101 45250 390 Contracted Services - 2,715 - 7,600 $3,000 Annual Contract for On -Line Registration Services; Contracted Rec Programs (Archery, Golf, Adult Fitness) are paid from the program revenue. The 2013 amount was $3558.09, staff estimates this number to stay consistent for exsisting programs. Staff also estimates an additional $1,000 In new Rec Program contract fees which the majority will be paid by program renvenue. 101 45300 390 Contracted Services - HPC 1,695 - - - 101 45250 410 Rentals - - 275 330 - The printer rental has been moved to the Prairie Center Budget 101 45250 440 Recreation Programming 36,569 15,039 19,352 55,000 - This line item has been detailed Into staffing 101-45250-104 and program supplies 101-45250-210. 101 45250 445 Community Events - 11,407 16,522 19,690 23,650 $2000 Easter Egg Hunt; $2000 For Santa Day; $3000 for Pumpkin Patch; $5000 for Tuesday Entertainment; Movies $3000; Prairie Festival $ 8,650 (the City's portion of the Prairie Festival cost Will be evaluated and possibly reduced by monies remaining from 2014.) Purchased Services 40,530 28,458 45,105 84,744 43,897 101 45250 501 Equipment - - - - - Capital - - - - - 101 45250 Recreation 41,736 86,162 115,471 156,089 130,177 27 Y:\Budget 2015 Input\2015 Parks & Recreation\Completed 1 12/3/2014 City of Otsego General Fund - Expenditures for the year ending December 31, 2015 Prairie Center 2011 Fund Account Description Actual EXPENDITURES 101 41940 101 Wages - FT Employees - 101 41940 102 Overtime - FT Employees 101 41940 104 Wages - PT Employees - 101 41940 121 PERA 101 41940 122 FICA and Medicare 101 41940 130 Insurance Benefit 101 41940 140 Unemployment Compensation 101 41940 150 Workers Compensation Personal Services 101 41940 201 Office Supplies 101 41940 202 Fuel 101 41940 210 Operating Supplies 101 41940 220 Repair/Maintenance Supplies Supplies 101 41940 320 Telephone 101 41940 322 Utilities 101 41940 325 Garbage Service 101 41940 355 Dues and Memberships 101 41940 360 Education/Training/Conferences 101 41940 361 Liability and Property Insurance 101 41940 389 Cleaning Services 101 41940 390 Contracted Services Purchased Services 101 41940 501 Equipment Capital 101 41940 Prairie Center 2012 2013 2014 2015 2,460 - - - - - 4,000 As of June 23, 2014 there has been 89 buildiing supervision hours with a total of $1,060 spent for building supervision. Staff estimates $3,000 for building supervision due to an estimated increase in rentals for 2015 which will be funded by rental fees. $1,000 for additional cleaning in the summer monthes because the "Compass" school group which cleans PC twice per week during the school year is off in the summer. - 17 - - - - 173 - 306 - - - - 50 Y:\Budget 2015 Input\2015 Parks & Recreation\Completed 1 28 12/3/2014 - 2,650 - 4,356 - 208 - 500 Paper, Printer Ink & Misc supplies - - 393 1,000 1,000 Diesel for generator 1,718 1,492 1,958 4,690 3,000 Cleaning supplies, Paper/ Restroom Supplies, Light Bulbs, Misc. 118 29 135 1,407 5,000 General Repair/ Maintenance of Buildinq 1,836 1,521 2,694 7,097 9,500 - - - 3,400 - 10,520 10,712 8,002 10,450 11,140 1,756 1,868 1,310 - 1,680 $140 per month for once a week dumpster service - 7,285 - 1,200 1,236 9,282 6,993 - 4,000 3,000 Weekly Cleaning Service 35,494 10,755 5,564 6,500 4,710 Mat services $900 annually, Pest Control $400 annually; Security Services $420 annually; Copier Rental $400 annually; Chamber Sound System Repair & Service $2,390; Fire Extinguisher Service & Repair $200. 57,052 37,613 14,876 25,550 21,766 Y:\Budget 2015 Input\2015 Parks & Recreation\Completed 1 28 12/3/2014 City of Otsego General Fund - Expenditures for the year ending December 31, 2015 r Fronnmir. Develonm-ent 1 2011 2012 2013 2014 2015 101 46580 104 Wages - PT Employees Personal Services 101 46580 201 Office Supplies Supplies 101 46580 350 Dues & Memberships 101 46580 360 Education/Training/Conferences 101 46580 380 Marketing 101 46580 390 Contracted Services 101 41900 439 Development Incentives Purchased Services 101 46580 501 Equipment Capital 101 46580 Economic Development 10 - 140 200 10 - - 140 200 2,582 3,286 3,150 3,300 I94 West Chamber of Commerce 300; WCEDP 2,500; Initiative Foundation 250; EDAM 250 - - - 500 600 EDAM State Conference; WCEDP Sessions; ED Traininq - 67 - 5,000 5,000 - - - 5,000 5,000 12,343 - - - - see Fund 255 12,343 2,649 3,286 13,650 13,900 29 Y:\Budget 2015 Input\2015 Finance\GF Expense - Economic Development 12/3/2014 City of Otsego Outstanding Bonded Debt as of 1/1/2015 TOTALS $ 39,690,000 $ 38,475,000 C:\Users\Dan\Documents\2015 Budget\Debt Service Funds 30 12/3/2014 Value Original Outstanding Date of Issue Designation Date of Issue Face Value at 1/1/2015 Final Maturity GO Improvement 2007B 11/01/2007 $ 680,000 $ 205,000 12/01/2016 GO Improvement Refunding 2010B 11/01/2010 $ 3,705,000 $ 3,130,000 12/01/2021 GO Improvement Refunding 2010D 11/01/2010 $ 1,220,000 $ 1,220,000 02/01/2028 GO Improvement Refunding 2011A 12/01/2011 $ 4,640,000 $ 4,640,000 02/01/2028 GO Improvement Refunding 2012A 03/01/2012 $ 1,400,000 $ 1,400,000 12/01/2021 $ 11,645,000 $ 10,595,000 GO Equipment Certificate 2010A 01/15/2010 $ 385,000 $ 220,000 07/15/2019 $ 385,000 $ 220,000 GO Water/Sewer Revenue Refunding 2009A 12/01/2009 $ 6,360,000 $ 6,360,000 12/01/2027 GO Water/Sewer Revenue Refunding 2010C 11/01/2010 $ 21,300,000 $ 21,300,000 12/01/2026 $ 27,660,000 $ 27,660,000 TOTALS $ 39,690,000 $ 38,475,000 C:\Users\Dan\Documents\2015 Budget\Debt Service Funds 30 12/3/2014 City of Otsego Payment of Outstanding Principal for the period ending 12/31/2015 Value Value Outstanding Principal Payments Outstanding Issue Designation at 12/31/2014 2015 at 12/31/2015 GO Improvement 2007B $ 205,000 $ 105,000 $ 100,000 GO Improvement Refunding 2010B $ 3,130,000 $ 420,000 $ 2,710,000 GO Improvement Refunding 2010D $ 1,220,000 $ - $ 1,220,000 GO Improvement Refunding 2011A $ 4,640,000 $ 360,000 $ 4,280,000 GO Improvement Refunding 2012A $ 1,400,000 $ 200,000 $ 1,200,000 $ 10,595,000 $ 1,085,000 $ 9,510,000 GO Equipment Certificate 2010A $ 220,000 $ 45,000 $ 175,000 $ 220,000 $ 45,000 $ 175,000 GO Water/Sewer Revenue Refunding 2009A $ 6,360,000 $ - $ 6,360,000 GO Water/Sewer Revenue Refunding 2010C $ 21,300,000 $ - $ 21,300,000 $ 27,660,000 $ - $ 27,660,000 38,475,000 $ 1,130,000 $ 37,345,000 C:\Users\Dan\Documents\2015 Budget\Debt Service Funds 31 12/3/2014 C:\Users\Dan\Documents\2015 Budget\Debt Service Funds 32 12/3/2014 City of Otsego Payment of Principal & Interest e by bond issue for the period ending 12/31/2015 Principal Interest Issue Designation Payment Payment Total Payments Debt Service Fund # GO Improvement 2007B $ 105,000 $ 8,200.00 $ 113,200.00 395 GO Improvement Refunding 2010B $ 420,000 $ 76,323.00 $ 496,323.00 385 GO Improvement Refunding 2010D $ - $ 36,033.00 $ 36,033.00 380 GO Improvement Refunding 2011A $ 360,000 $ 104,243.00 $ 464,243.00 380 GO Improvement Refunding 2012A $ 200,000 $ 28,000.00 $ 228,000.00 375 $ 1,085,000 $ 252,799.00 $ 1,337,799.00 GO Equipment Certificate 2010A $ 45,000 $ 6,700.00 $ 51,700.00 399 $ 45,000 $ 6,700.00 $ 51,700.00 GO Water/Sewer Revenue Refunding 2009A $ - $ 260,610.00 $ 260,610.00 360 GO Water/Sewer Revenue Refunding 2010C $ - $ 745,500.00 $ 745,500.00 360 $ - $ 1,006,110.00 $ 1,006,110.00 1 1 '�n nnn -t 1.7F,F_6n9.no t 2.395.609.00 C:\Users\Dan\Documents\2015 Budget\Debt Service Funds 32 12/3/2014 City of Otsego Payment of Principal & Interest - by Fiend for the period ending 12/31/2015 Principal Interest Issue Desiqnation Payment Payment GO Water/Sewer Revenue Refunding 2009A $ - $ 260,610.00 GO Water/Sewer Revenue Refunding 2010C $ - $ 745,500.00 GO Improvement GO Improvement GO Improvement GO Improvement GO Improvement GO Equipment Certificate Total Debt Service yments Fund # $ 260,610.00 $ 745,500.00 $ 1,006,110.00 $ - $ 1,006,110.00 Refunding 2012A $ 200,000 $ 28,000.00 Refunding 2010D $ - $ 36,032.50 Refunding 2011A $ 360,000 $ 104,243.00 $ 360,000 $ 140,275.50 Refunding 20108 $ 420,000 $ 76,323.00 2007B $ 105,000 $ 8,200.00 2010A $ 45,000 $ 6,700.00 Total Debt Service yments Fund # $ 260,610.00 $ 745,500.00 $ 1,006,110.00 $ 228,000.00 $ 36,032.50 $ 464,243.00 $ 500,275.50 $ 496,323.00 $ 113,200.00 $ 51,700.00 360 375 380 385 395 399 C:\Users\Dan\Documents\2015 Budget\Debt Service Funds 33 12/3/2014 City of Otsego Water Utility Fund •Y for the year ending December 31, 2015 601 37150 Water Sales 601 37155 Water Sales - Irrigation - 139,419 Subtototal: Water Sales 601 37165 Water Tower Leases 601 36100 Special Assessments 601 37170 DNR Fees Collected 601 31900 Penalties and Interest 601 "34302 Water Meters 601 36210 Interest Earned 601 34109 Other Administrative Charges 601 38990 Other Miscellaneous Revenue 25,000 35,000 TOTAL REVENUES 2011 2012 2013 2014 2015 lctual Actual Actual Budget Budget Comments 728,544 837,928 862,413 1,026,830 1 1,052,500 - - 139,419 - 75,000 728,544 837,928 1,001,831 1,026,830 1,127,500 - 55,168 64,050 60,000 60,000 55,050 79,090 72,294 - - 14,299 - 16,422 17,045 18,600 10,331 12,226 34,142 25,000 35,000 24,598 57,219 70,313 60,000 68,000 27,618 17,226 (8,393) - - 582 1,684 15,313 - - 7,322 6,082 2,644 - - 868,344 1,066,623 1,268,617 1,188,875 1,309,100 rate Increase approved 2/11/13 $ 6.36 X 2,924 connections 170X$400, Y:\Budget 2015 Input\2015 Utilities\Water 2015 • 34 12/3/2014 D(PENDJURES 601 49400 101 Full -Time Employees Regular 29,619 27,826 74,726 30,049 47,720 25% water 75% wastewater 601 49400 102 FT Overtime - - - 660 1,100 601 49400 104 Part -lime Employees - - - 180 300 601 49400 119 Payroll Allocation 24,955 24,960 3,750 - 601 49400 121 PERA 2,147 2,008 4,979 2,226 3,662 601 49400 122 FICA and Medicare 2,128 1,921 5,474 2,363 3,758 601 49400 123 Health 2,577 2,620 51919 5,894 8,679 601 49400 130 Other Emplolyee Insurance - - - - 601 49400 140 Unemployment Compensation - - - - 601 49400 150 Workers Compensation - - 322 1,347 2,142 PERSONAL SERVICES 61,426 59,335 95,170 42,719 67,361 601 49400 201 Office Supplies and Expenses 91 7,036 11,651 10,500 10,000 601 49400 202 Fuel 515 202 162 750 61833 8/1/13-W25/14;2873g used In vehlcles, 771g generators = 3644g/year @ 3.75/9 (1/2) 601 49400 206 Postage 5,345 4,595 4,720 6,000 61600 (2200 bills @0.49x12)/2+additional WWTF 601 49400 210 Operating Supplies 14,048 41,061 99,139 98,100 Postaoe items 107,110 See Attachment 210 601 49400 220 Repair/Maintenance Supplies 2,412 7,850 5,152 16,000 14,820 See Attachment 220 601 49400 225 Uniform/Clothing Allowance - - 1,254 1,475 1,100 [550/yrx4star0/2 601 49400 227 Safety Supplies - - 808 200 1,000 Arc flash suit/traffic vest/ear plugs/glasses, Ist aid Idtsuppffes, insolated tools, bench box (1/2), Wood 601 49400 240 Small Tools and Equipment - - 8,064 4,000 500 Hydrant king nut stop removal/Drill 601 49400 298 Fleet Expenses - - - 9,000 2,600 8 oil changes@ $40e, 4 tire rotate @ $Ise, Jet Vac oil $420, Crane truck cable, Air Filter, tight, Battery, Brakes, wheel well paint, trany flush@$200.(1/2). Wel moved to 402 SUPPLIES 22,411 60,744 130,950 146,025 150,563 Y:\Budget 2015 Input\2015 Utilities\Water 2015 • 34 12/3/2014 601 49400 301 Legal Fees 601 49400 302 Engineering Feses 601 49400 303 Planning Fees 601 49400 306 Permits & Fees 601 49400 310 Miscellaneous 601 49400 315 GIS Services 601 49400 320 Telephone 601 49400 321 Mileage & Travel 601 49400 322 Utilities 601 49400 350 Print & Publishing 601 49400 355 Dues & Memberships 601 49400 360 Education/Training/Conferences 601 49400 361 Liabiiity & Property Insurance 601 49400 375 Water Test Fee 601 49400 390 Contracted Services 601 49400 402 Repairs & Maintenance Services 601 49400 410 Rentals 601 49400 420 Depreciation CONTRACTUAL SERVICES 601 49400 602 Bond Interest 601 49400 720 Operating Transfers TRANSFERS 601 49400 501 Equipment EQUIPMENT 2011 4ctual 2012 Actual 2013 Actual 2014 Budget 887 232 462 1,000 17,128 7,144 1,921 33,000 470 750 175 1,000 - 7,713 150 9,500 2014 ludget Comments 29,000 DNRAppropration9000frier1I4x125=500/MDH connectionfees (6.36 per connection@2724In 2014) estimating 2924 2015; 2 well maintenance permits 50e 10,297 - - - - 1,371,076 2,064 190 2,501 3,000 3,000 61,9761 - - 2,181 4,140 2,301 2 hard lines @ 213.53/ mo =2562.36 4 cell = ((50+400142=2040 - - 91 - 52,689 50,368 54,189 57,000 57,000 2,766 2,559 265 3,500 300 - 392 623 300 340 MRWA=$22512 MMUA $404/2; AW WA $25 - - 650 1,700 2,859 MMUA allocation for safety training = 3718/2 250 x 4 = 1000 8,426 6,690 - 6,145 14,772 437 16,240 17,100 - zero - moved to line 306 184,372 207,144 117,551 49,200 58,600 See Attachment390 19,065 - 4,755 - - 473,231 473,379 469,094 487,580 502,200 786,167 756,998 670,848 674,165 671,600 641,232 424,914 424,914 424,914 424,914 32,459 9 800 - 40,379 56,638 673,691 434,714 424,914 465,293 481,552 18,871 - 22,250 18,871 - - 22,250 - TOTAL EXPENDITURES 1,562,566 1,311,791 1,321,883 1,350,452 1,371,076 NET OPERATIONS (694,222) (245,168) (53,266) (161,5771L 61,9761 35 Y:\Budget 2015 Input\2015 Utilities\Water 2015 12/3/2014 210 Operating Supplies 2015 2016 I 2017 Water Chemical Budget 58,000 60,000 62,000 Chem Budget History - Based on Use 2010 35,400 Preventative Maintenance 2011 46,000 Oils / Grease / Filters / Gloves / Paint 500 500 500 2012 55,500 Ball valves/torches/zip ties/tie downs 100 100 100 2013 54,000 Laboratory - Reagents/pipet/wipes 200 200 200 Chem pump parts - diaphram/repair kit/4way valve/connector 500 500 750 Chlorine tubing 100 100 100 Chemical injection parts 200 200 200 generator wheel covers 100 Bungees 10 10 10 Salt - Snow markers - shovel 100 100 100 Hose repairs 100 100 100 C- Fold Towels / Cleaning Supplies 100 100 100 Lighting 50 50 4' $2.50/Ballast 50t/70W HPS $37 WH3/WH4 replaced ext bulbs 2014 Hydrants 1 nozzle, 4 main valve rubber, seats, 4 Flange Gaskets, l cane 1,200 1,200 1,200 rubber seats 45e Traffic Flange Replacement 4- 225e 900 900 900 Meters for Resale 45,000 45,000 45,000 170 X $260. Total 107,110 1 109,060 1 111,310 36 220 Repaks / Maim. Supplies attachment 2015 I 2016 2017 Distribution Repairs - valve extentions, main parts 7,000 5,000 5,000 2 Transducers - Well level monitoring - 7 year life 2,000 2,000 2,000 Lawn Maintenance -Trees/Mulch/Weed Spray 100 100 100 Community Ed - Displays Prairie Fest 500 Well House #2 Chem Room Air Exchange 3,000 Hanging Heater repair/replacement 800 1 Chem Pump - life expectancy 7 yr 800 800 800 PLC Well 1 4,000 Chlorine Regulator - life expectancy 7 yr 1,200 WH1 WH2 WH3 WH4 Hi E Dry Dehumidifier replacement 800 4 top bell water valves @ $80 each 320 320 320 Variable Frequency Drives / Soft Starters Totall 14,820 I 12,220 I 9,920 37 38 390 Contr acted Servuces 2015 2016 I 2017 Stericyle Communications - ans service 800 800 800 Softronics 5,000 5,000 5,000 Civic Systems 1,200 1,200 1,200 2 Well Pump Pulls 6,000 6,000 6,000 AE25S 3 visits 1100 each 3,300 3,300 3,300 Electrician Services 2,000 2,000 2,000 Generator Service -Annual Maintenance 1,430 1,430 1,430 Public Water System Testing- UC Labs-15x9x12 Total Coliform 1,620 1,800 1,800 (20x0.25)=5 20-5=15 Bear Alarms -alarm monitoring Well Sites 1,750 1,750 1,750 Spraying Lawn Area Well sites 200 200 200 Fire Ext Testing/ Replacement 100 100 100 MeterTesting- Municipal Wells/ Residents 1,000 1,000 1,000 RPZ Testing - 4 bulk water meters 200 200 600 $50/insp; 2017@150/rebuild Well 3 motor replacement & Check valve 2014 + 7yr = 2021 @$13000 Locates 25,000 25,000 25,000 Water Tower 2 & 3 inspection and cleaning 8,000 8,000 8,000 PSI control valve seat replacement 1,000 1,000 1,000 Total 58,600 T 58,780 � 59,180 38 City of Otsego Sewer Utility Fund t for the year ending December 31, 2015 1 2011 602 37200 Sewer Sales 1,022,681 602 34000 Charges for Service 13,200 602 31900 Penalties and Interest 16,064 602 36210 Interest Earned 19,505 602 38991 Refunds and Reimbursements 14,854 1,086,304 TOTAL REVENUES 602 49450 101 Full -Time Employees Reqular 602 49450 102 FT Overtime 602 49450 104 Part -Time Employees 602 49450 119 Payroll Allocation 602 49450 121 PERA 602 49450 122 FICA and Medicare 602 49450 123 Health 602 49450 130 Other Emplolyee Insurance 602 49450 140 Unemployment Compensation 602 49450 150 Workers Compensation PERSONAL SERVICES 602 49450 201 Office Supplies and Expenses 602 49450 202 Fuel 602 49450 206 Postage 602 49450 210 Operating Supplies 602 49450 220 Repair/Maintenance Supplies 602 49450 225 Uniform/Clothing Allowance 602 49450 227 Safety Supplies 602 49450 240 Small Tools and Equipment 602 49450 298 W/S Fleet Expenses SUPPLIES 602 49450 301 LegalFees 602 49450 302 Engineering Fees 602 49450 303 Planninq Fees 602 49450 306 Permits & Fees 602 49450 310 Miscellaneous 602 49450 315 GIS Services 602 49450 320 Telephone 602 49450 321 Mileage&Travel 602 49450 322 Utilities 602 49450 325 Garbage Service 602 49450 350 Print & Publishing 602 49450 355 Dues & Memberships 602 49450 360 Education/Training/Conferences 602 49450 361 Liability & Property Insurance 602 49450 390 Contracted Services 602 49450 402 Repairs & Maintenance Services 602 49450 410 Rentals 602 49450 419 Biosolids Removal 602 49450 420 Depreciation CONTRACTUAL SERVICES 602 49450 610 Bond Interest 602 49450 720 Operatinq Transfers TRANSFERS 602 49450 501 Equipment EQUIPMENT 2012 2013 2014 2015 1,019,258 9,553 14,519 12,279 11,347 1,136,423 7,873 42,227 (5,049) - 1,181,900 - 35,000 6,000 11,000 1,240,995 7,000 40,000 - - 1,066,956 1,181,474 1,233,900 1,287,995 22,135 22,840 49,507 24,960 1,591 1,647 1,544 1,539 902 1,456 136 161 75,815 97 4,571 5,345 1,464 24,476 52,603 6,878 5,203 4,595 29,334 35,953 46,010 2,182 652 18,745 10,405 1,020 760 - 4,142 8,632 - 7,991 190 128,145 124,947 2,452 2,250 20,739 17,913 395,580 482,537 31,289 - 61,942 2,500 826,095 826,242 1,504,812 1,472,538 1,139,971 755,400 18,000 19,600 1,157,971 775,000 22,107 - 22,107 - 72,045 3,750 4,785 5,269 5,256 662 1,264 93,031 11,651 3,208 4,702 12,930 26,369 1,253 3,435 7,031 170,276 3,740 1,020 12,616 13,390 33,397 7,632 242,071 10,500 5,500 6,000 53,000 66,000 1,425 300 1,000 9,000 70,579 152,725 - 1,000 6,849 11,000 225 1,000 4,140 7,500 57 4,000 2,834 4,140 150,225 165,000 3,478 - 116 3,500 25 200 1,126 1,300 4,064 20,205 258,155 101,300 73,488 - 32,346 35,000 846,492 843,252 1,383,620 1,198,397 755,400 755,400 - 45,006 755,400 800,406 320 58,750 320 58,750 rate Increase approved 2/11113 25%water 75% wastewater 205,108 81000 Bank charges & PSN Fees, $300Ink WWTF, hanging file folders, record boxes, pens, markers 61833 8/1/13-8/25/14; 2873g used in vehicles, 771g generators = 3644g/year @ 3.75/9 (1/7) 6,600 (2200 bills @ 0.49x12)/2 + additional W WTF Poslaoeitems 43,337 See Attachment 210 80,700 See Attachment 220 1,250 [550/yrx4smfr7(2-r seasonal 11000 Arc flash suitjoaffic vesVear plugs/glasses (1/2), life jacket 1st akl kit supplies, Insulated tools, trench box 500 Impact (1/2), backpack sprayer (1/2), shovel.small air comoressor 21600 8 oil changes@ $40e, 4 Ore rotate @ $Ise, Jet Vac oil $420, Crane truck cable, Alr Filter, Light Battery, Brakes, wheel well paint trany flush@$200.(1/2) 150,820 .0,000 Increase for incorporate West digester 1,000 7,700 EWWIf annual 5900 WWWTF annual 1450 SWPPP annual400 zero 4,000 2,301 2 hard lines @ 213.53/ mo =2562.36, 4 cell = 1(50+40(3)1x12=2040. total 4603 (1/2) Z- 0,000 6,851 3 yards per week (377.61+193.21)x12=6851.04 200 340 MWRA225/2 AWWA25 MMUA404/2 21859 MMUA alto ation for safety training = 3718/2 250 x 4 = 1000 74 q See Attachment 390 60,000 1,200000g x o.o5/ga I 860,117 12% growth in asset 1,200,082 812,038 �$ 6,000 for v -plow requested TOTAL EXPENDITURES I 2,796,658 2,346,151 2,302,950 2,452,349 2,368,048 NET OPERATIONS 39 Y:\Budget20151nput\2015 Utilities\Sewer 2015 ' " ' ' 12/3/2014 220 Re airs and Maintenance WestVUWTF 2015 1 2016 2017 Pretreatment Building sampler replacement- Influent 5,000 sigma SD 900 refrigerated sampler RAS pump 6,000 Hi E Dry 5,000 Piping options 1,500 Control Building Generator PLC 4,000 ASCO Transfer Control Center Display Blower Building Blower rehab GBT Building Heater replacement Ferric room 500 Ferric Pump 400 400 UV Building UV-fans/ac/compressor/bulbs/cards/psi gauge 700 East = 48 bulbs 24 cards West 40 bulbs 20 cards Digester/Storage/Aeration/Other Storage nozzle repair 4,000 Concrete Repairs/Sealing Sealed 2014 5 tree/w tub replacement N fence line 2,000 Splitter box bar rack 300 Control Panel PLC/UPS/Program Card 2,000 Vfd life expectancy 12years heat tape clarifiers EWWTF 200 3 Mechanical Air Units, Fine Screen, Gravity Belt, 2 Positive Displacement Pumps, 4 Blowers Pretreatment Building Inf channel concrete repair 3,000 MAU #1 motor replacement 400 Odor Control Activated Carbon Replacement 1,500 Entrance Door- Pretreatment 800 Grit Cyclone Pipe reduction 100 Water line repair 100 Control Building RAS meter replacement 5,000 Chemical Building Heater replacement Ferric room 500 GBT Building EWWTF GBT Floor 2,000 Blower Building UV Building UV fans/ac/compressor/bulbs/cards 3,300 East= 48 bulbs 24 cards West 40 bulbs 20 cards control valve100 / bulbs 150e / card 650 / fan 339 Digester/Storage/Aeration/Other Storm water Pollution Prevention Items 2,000 Mixer repair 5,000 Vfd life expectancy 12years 3 Mechanical Air Units, Fine Screen, Gravity Belt, 2 Positive Displacement Pumps, 4 Blowers Control Panel PLC/UPS_/Program Card Collection System 2,000 Lift Stations Grinders Otsego Preserve 40b GMH isolation valve repair 1,000 LS#3 Chord and rail repair 1,000 Soft Starts (2) 4,000 Collection System Chimney Seals - CIP 15,000 15,000 15,000 $350 each Chimney replacements - CIP 12,000 12,000 12,000 30/ring, 300/skirt & ext, 350 casting &cover,30 adhesive, 30 fasteners = $740 each 1 air reliefvalve 1,000 1,000 1,000 Total 1 80,7001 331000 34,400 40 21®Operating Supplies Attachment 2015 2016 1 2017 Chemical Related Ferric History Ferric Consumption 5g/day West 2009 E 6900 W 11500 =18400 Ferric Consumption 2g/day East 2010 E 8600 W 7900 =16500 Total 6g/day x $2.7/g = $6000 Ferric 6,899.00 7,100.00 7,300.00 2011 E 4600 W 8200 =12800 Contingency high phosp (660g or 2 totes) = 1,782.00 1,782.00 1,782.00 2012 E 25 W 5900 = 5925 Polymer 6 barrels EWWTF$919 per 5,514.00 5,514.00 5,514.00 2013 E400 W 4500=4900 Polymer 6 barrels WWWTF $919 per 5,514.00 5,514.00 5,514.00 Preventative Maintenance Lubricants - oil /grease / oil analysis 3,000.00 3,000.00 3,000.00 Belts - Blowers /Transfer pumps / Exhaust systems 600.00 600.00 600.00 Air Filters - blowers / compressors/ furnace / dehumidifiers 300.00 300.00 300.00 Oil Filters-Aerators 300.00 300.00 300.00 Seal kits /gaskets /shim kits / mechanical seal 1,000.00 1,000.00 1,000.00 fuses/relays/starters/alternators/phase monitor 4,000.00 4,000.00 4,000.00 UV bulbs + disposal; $180/bulb EWWTF48total WWWTF32total 8,640.00 5,760.00 Batteries-UPS/Equipment/Sensors/Flashlights/Gas Detector/Timers 300.00 300.00 300.00 Sampler Tubing East & West Influent/Effluent 100.00 100.00 100.00 Shop towels/glue/tape/screws bolts nuts/helicoil 150.00 150.00 150.00 West Auger liners 490.00 490.00 490.00 $17.50 each x 24+35 x 2 Delivery Disposable Gloves/Winter Gloves/Rubber Gloves/Leather Gloves 650.00 650.00 650.00 60x10 = 600 + other gloves Ferric Pump tubing-1&2 size - supply/distribution replacement 150.00 150.00 150.00 $75/5pk#1, $75/5pk#2 Process sensors - DO / pH - Probe life expect 2year 1,000.00 1,000.00 1,000.00 portable DO probe $345(2014/2017) Salt Bridges /Solution - Inf/Eff pH Meters EWWTF 500.00 500.00 500.00 Cable ties / fittings / torches / propane/ plumbing supplies 100.00 100.00 100.00 shear pins/ 1445 repairs / blades/auger/blower 200.00 200.00 200.00 Bulb replacement: Driveway lights/Building Exterior/Interior/WT/LED status lights 200.00 200.00 200.00 4' $2.50/Ballast 50+/70W HPS $37 Outlet/motor rewind/ext chord 400.00 200.00 400.00 Bearings/Desicant/Fine Screen Blades 700.00 700.00 700.00 Gravity Belt Thickener Blade-Plows-filter belt 1,000.00 - 1,000.00 EW WTF GBT Belt-908.60 P#063952 Janitorial C Fold Towels/Soap/GoJo/Hand Sanitizer/Glass & Surface Cleaner 500.00 500.00 500.00 600 Garbage bags / mop / 4'-8' brushes / Bleach / Floor Cleaner 350.00 350.00 350.00 Pesticides / Herbicides / Sprayers - 8 Wasp Spray 5e / 4 Round up 80e 400.OD 400.00 400.00 Paint & Paint Supplies/ Floor Treatment 1,000.00 Pretreatment Building U/L/Main Restroom Items - urinal cakes, 40 Toilet paper, hand soap 100.00 100.00 100.00 Sidewalk/Driveway Salt; $20/58. 200.00 200.00 200.00 Snow Markers; 20/yr @ $3 each 60.00 60.00 60.00 Plates/forks/spoons/W microwave 70.00 30.00 30.00 Granite Chips Driveway 600.00 - 600.00 Site Application Markers 10/year Beach 80.00 80.00 80.00 Air Cans / Lock De icer / Ice Scrapers 25.00 25.00 25.00 Double Jacket Hydrant hose Q/C 50; 50'@ 200each/garden hose 400.00 200.00 200.00 Oil Dry/algae brushes - 3/entry rugs/ 100.00 - - Collection System Lift Station Ultrasonic/Pressure Transmitter (1) life expectence 7year 820.00 820.00 820.00 Lift Station Cleaning 1,600.00 1,600.00 1,600.00 Lift Station Floats 2@100each 200.00 200.00 200.00 Lift Station Pump/Panel; alternator, phase monitor, relay, fuses 200.00 200.00 200.00 Sewer Plugs - lift station cleaning 500.00 Community Ed - Display Prairie Festival 200.00 Air relief valve parts 1,000.00 Joint seal 1,000.00 1,000.00 1,000.00 Lab Filter pads-5 bx/yr=125; Kim Wipes 4bx/yr=70; Phosver 3 packets 4 units/yr--160 355.00 355.00 355.00 Process testing reagents/glassware/pipets / pipet bulb/pans 100.00 100.00 100.00 Ice for Samples- EW WTF $3x26wk 78.00 78.00 78.00 pH buffer and storage solution/DI water 100.00 100.00 100.00 pH meter replacement probe $100/yr /DO meter replacement probe $300/2yr 100.00 400.00 100.00 Desicant Process Testing 50.00 50.00 50.00 Total 1 43,337.00 49,338.00 1 49,858.00 41 390 Contract Services Attachment 2015 1 2016 1 2017 1 1 Generator System Services- Generator Maintenance E&W WWTF 3,000 1 3,000 3,000 NRI- HVAC- Heating cooling maintenance/repairs 3,000 3,000 3,000 Fall maint=490W 340E AE2S - instrumentation services -1100/day 6 visits 6,600 6,600 6,600 Softronics 3,000 3,000 3,000 Contracted - Lawn Spraying 2,000 2,000 2,000 RPZ inspections 3 @ WWTF 150 150 450 $50/inspection; rebuild 2017 @ $150 each Bear Alarms 700 700 700 Civic Systems 4,700 4,700 4,700 Nelsons - LS pump repairs major / MF annual inspection 2,000 2,000 2,000 5 trips 200 each + parts Nielson Co - meter calibrations - permit required 2x/yr 1,240 1,240 1,240 617.60 Feb 14, 586.20 Aug 14; done 2x/yr Fire Extinguisher Annual Inspections 200 200 200 Locates 25,000 25,000 25,000 Camera Inspections 1,500 1,500 1,500 Spectrophotometer calibration 417 Hach $397 + $20 for shipping Answering Service - Stericycle 715 715 715 59.58/mo Chain hosit inspection - Midwest Crane 40 40 40 Permit renewal East WWTF- added analytes 500 - - LaboratoryEWWTF - Pace Analytical CBOD 4,992 4,992 4,992 Cost/Sam 16.00 I #SAMPLES 312 Cost 4,992.00 TSS 2,808 2,808 2,808 9.00 312 2,808.00 T Phosp routine+ average reduction 3,200 3,200 3,200 10.00 320 3,200.00 HG 2,800 2,800 2,800 140.00 20 2,800.00 Fecal 1,872 1,872 1,872 12.00 156 1,872.00 NH4 2,028 2,028 2,028 13.00 156 21028.00 Laboratory West WWTF- LIC Labs Cost/Sam # SMPLS Cost CBOD (27x0.25)=6.75 27-6.75=20.25 2,106 2,106 1 2,106 20.25 104 2,106.00 TSS (16.50x0.25)=4.125 16.50-4,125=12,375 1,287 1,287 1,287 12.38 104 1,287.00 T Phosp (20x0.25)=5 20-5=15 routine+average reduction 1,800 1,800 1,800 15.00 120 1,800.00 Fecal 384 384 384 12.00 32 384.00 Salty Discharge pH N/C 0 Chloride (16.50x0.25)=4.125 16.50-4,125=12,375 149 149 149 12.38 12 148.56 Calcium (24.5x0.25)=6.125 24.5-6,125=18,375 221 221 221 18.38 12 220.56 Sodium (24.5x0.25)=6.125 24.5-6,125=18,375 221 221 221 18.38 12 220.56 Magnesium (24.5x0.25)=6.125 24.5-6,125=18,375 221 221 221 18.38 12 220.56 Potassium (24.5x0.25)=6.125 24.5-6,125=18,375 221 221 221 18.38 12 220.56 Sample Prep Fee (23x0.25)=5.75 23-5.75=17.25 207 207 207 17.25 12 207.00 TDS (16.50x0.25)=4.125 16.50-4,125=12,375 149 149 149 12.38 12 148.56 Sulfate (38.5x0.25)=9.6 38.5-9.625=28,875 347 347 347 28.88 12 346.56 Alkalinity N/C - - - - 12 - Bicarbonate (20x0.25)=5 20-5=15 180 180 1 180 15.00 12 180.00 Specific Conductance (15.5x0.25)=3.875 15.5-3.875=11,625 140 140 140 11.63 12 139.56 N 120 120 120 60.00 2 120.00 HG 140 140 140 140.00 1 140.00 Biosolids 503 1,020 1,020 1,020 510.00 2 1,020.00 Pathogen Reduction MPN 910 910 910 65.00 14 910.00 Acute Toxicity 850 850 850 850.00 1 850.00 Soil Samples - 186 62 62.00 0 - Priority Pollutants 1,000 1,000 1,000 991.00 1 991.00 83,714 83,400 i 83,993 42 CITY OF Ot MINNESOTA 9 Information and Public wmment Meetin, 2015 Operating Budgets Property Tax Levy Payable in 2015 I I Why? Strategic Goals Budget Process General Fund Property Taxes • Other Budgeted Funds • Capital Improvement Plan (CIP) 9 Take Public Comment Consider 2 Resolutions; — Adopting Tax Levy for Pay 2015 — Adopting 2015 Operating Budgets Why does the / have \Meet'lng?, § CAdministrator prepares a n d submits J n operating budget for the ensuing year to the City Council, Minnesota Statutes 275.065, the "Taxation a q d Notification" law, establishes process for communication of this information to the public, City Council must h a meeting { discuss the budget a\fid property tlevy and, b 4 final determination, allow public : 9 C. L -4 4- 4 R To focus the use of the City's limited resources to produce the greatest value for the Otsego community, the City Council has adopted the following four Strategic Planning Goals; o Expand the City's commercial -industrial tax base. o Assess the efficiency and effectiveness of City services. o Assure the availability of high quality broadband service within the community. o Develop and implement a Marketing Plan to enhance development and increase the property tax base. The et Process • ® City Administrator and Department Heads have met with Council on several occasions to discuss proposed revenues and expenditures. o May 28 — Initial Overview of Process and Goals o July 21— Debt Service Requirements and Property Tax Implications o August 4 — General Fund Revenues, Administration, Elections and Finance o August 1— Public Safety, Building Safety, Planning, HPC and IT o August25 — Streets, Fleet, Engineering, Public Buildings o September 8 — Parks, Recreation, Prairie Center, ED and Staff Compensation o September 15 — Property Tax Levy Implications and General Fund review o September 22 — Adopt Preliminary Property Tax Levy and Preliminary Budget o October 27 — water Utility, Sewer Utility, Staff Compensation o November 17 — CIP; Equipment Maintenance and Replacement o November 24 — CIP; Buildings, Parks, CIP Financing • December 8— Public Meeting for Public Review and Comment o Receive Public Input o Adopt Property Tax Levy o Adopt Operating Budgets Police • Fire Protection Animal Contro Streets — Maintenance — Cleaning — Plowing Parks Recreation Planning Zoning Enforcement Facilities — City Hall — Prairie Center Citi Council Administration — Clerk/Elections — Finance — IT —Legal Information Technology Property Taxes Assessments Business Licenses. — Liquor — Rental Housing Permits — Building Permits — Fence and Sign Permits Transfers from Other Funds — for services provided , Fees: — Recreation Programs — Park Facility Use — Platting — Zoning Changes Cable Communications Franchise Fees • State Aid • Investment Earnings General Fund Revenues 2015 Investment Earnings Franchise Fees 2,04% Intergovernmental Revenue 2,26°% 6,95% Fees for Service Transfers � 1.09% 3,21°% I Licenses & Permits 12,73% 4 i i i Property I i I General Fund Expenditures 2015 Parks & Recreation 10.65% Facilities 2.64°% Planning & Zoning 1.83% I rCity Council 1.85% Streets Administration 20.57°A I i Police Fire Protection ' 10.21°,6 Informtaion Technology 1.49°% I Building Inspection & Safety 5.16% City of Otsego General Fund Budget for the year ending 31 December 2015 Revenues: Taxes Licenses and Permits Intergovernmental Revenue Charges for Service Interest Revenue Cable franchise Fees Other Revenues TOTAL Revenues: Expenditures: General Government: City Council Administration Elections Assessor Finance Legal Information Technology City Hall Planning Building Inspection Subtotal., General Government Public Safety.- Police afety:Police Police Commission Fire Emergency Management Animal Control Subtotal: Public Safely: Public Works: Streets Engineering Street Lights Real Maintenance Subtotal: Publicftk8 Culture & Recreation Park Maintenance Recreation Prairie Center Subtotal: Culture & Recreation: Economic Development Transfers Outl(In) TOTAL Expenditures: NET GENERAL FUND: 2011 2012 2013 2014 2015 Actual Actual Actual Budget Proposed 3,343,665 3,139,130 3,366,010 3,273,715 3,334,000 304,084 553,077 830,076 557,300 592,000 199,053 208,622 217,630 316,611 323,122 96,204 62,163 38,321 65,650 50,700 116,186 92,134 (4,766) 100,000 95,000 100,176 106,547 83,681 105,000 105,000 282,796 66,553 72,924 143,736 149,047 4,444,164 4,238,426 4,603,876 4,562,012 4,648,869 49,950 51,273 44,216 74,547 82,317 295,869 376,582 339,696 391,850 415,273 390 24,334 1,486 26,200 745 67,935 67,904 67,463 70,300 74,700 176,950 239,680 242,381 321,187 342,703 95,239 71,305 78,996 75,000 82,000 35,108 22,760 47,628 66,300 721 716 71,270 81,255 82,063 91,753 86,356 70;016 73,400 67,250 454,415 204,926 181,882 231,692 229,723 1,233,222 1,156,184 1,120,166 1,393,069 1,443, 074 861,410 875,045 8B2,601 912,500 941,700 1,191 1,372 1,399 1,350 1,350 - 347,922 365,873 375,850 454,560 728 2,950 8,550 7,450 15,274 10,915 11,058 11,300 877,875 1,235,982 1,263,881 -11,000 1,309,250 1,416, 360 1,285,891 760,656 678,991 630,810 681,123 147,421 128,714 160,825 85,000 85,000 97,046 108,775 109,667 110,000 114,100 148,131 191,63D 187,260 1,530,358 998,145 1,097,614: 1,017,240 1,067,483 345,350 193,455 166,490 294,880 343,851 41,736 86,162 115,471 156,089 130,177 56,888 39,134 20,220 32,647 35,622 446,974 318,751 302,181 483,616 509,650 12,353 2,649 3,286 13,790 14,100 556,941 115,000 65,911 4,657,723 3,828,711 3,787,128 4,282,876 4,450,667 213,559 409,715 816,748 279,136 L 198,202 Property Taxes Property Tax is the method chosen by the Minnesota Legislature for paying for the public services we want and expect from cities, counties, schools and other government agencies. on the value of immovable or real It is based property owned. How is it determined?, Based on the proportionate market value of your taxable property relative to the total market value of taxable property in the city. Proportion is determined by formula; taxable market value X class rate = tax capacity • There are 26 classifications of property using 6 different class rates. Property Taxes - variables estimated market value EMV taxable market value TMV tax capacity rate TCR property tax levy BEVY tax capacity TC total tax capacity TTC • tax extension rate or tax rate ER • property taxes payable $ Property Taxes - calculations (EMV or TMV * TCR = TC • TC1 + TC2 + TC3 + TC4 ...= TTC LEVY/ TTC = ER • ER*TC=$ Proportionate Share of Taxes Estimated Market Value Tax Capacity Business 9,250 45,12/ .._., Apartment E,250 30 49°0 Taxes Payable Certified Levy = $ 8,437 Total Tax Capacity = 20,500 Tax Extension Rate = 41.16% Residential Apartment Commercial 5,000 X 41.16% _ $2,058 6,250 X 41.16% _ $21572 9,250 X 41.16% _ $31807 City of Otsego Calculation of Property Tax Levy Options for taxes payable 2015 General Fund Levy Fire Reserve Levy Storm Sewer Levy Pavement Management Levy Park Trail Management Levy Capital Equipment Revolving Fund Levy Parks Capital Equipment Subtotal: Other Limited Levies Subtotal Limited Levy 2007E GO Improvement Bonds 2010A GO Equipment Certificate 20106 GO Building Bonds 2010D & 2011A GO Improvement Bonds 2003A Improvement Bonds 2004A Improvement Bonds 20066 Improvement Bonds Subtotal: Bonded Debt Levies Tax Abatement TOTAL: Certified Levy Dollar Increase Percentage Increase Proposed % of Pay 2012 Pay 2013 Pay 2014 _Pay 2015 Total Levy 21831,000 31213,145 3,273,715 31319,000 70.92% 480,000 140,000 145,000 145,000 3.10% - 571765 251000 25,000 0.53% 3001000 300,000 320,000 320,000 6.84% 25,000 25,000 25,000 25,000 0.53% 150,000 175,000 160,000 160,000 3.42% 50 000 25,000 53 000 53 000 1.13% 11005,000 722,765 728,000 728,000 15°56% 31836,000 31935,910 41001,715 4,047,000 86.47% 1501000 150,000 200,285 410,000 8.76% - - - 2001000 4.27% 100,000 100,000 1001000 - - 75,000 75,000 75,000 - 100f000 100,000 100 o00 - - 425,000 425,000 475,285 610,000 13.03% - 171000 23,000 23,000 0.49% 412611000 41377,910 41500,000 4,680,000 100,00% 116,910 122,090 180,000 2.74% 2,79% 4.00% 0 for tie ,7�,,,ty ot Otsego i n 20�,i.5 Tax Rate 41,162% New Value 3611731900 Source: Wright County Auditor's Office City of Otsego Effect of proposed Tax Levy on Various Properties Taxes Payable 2014 and 2015 Pay 2014 Pay 2015 Taxable Tax City Tax Taxable Tax City Tax Dollar % Market Value Capacity Tax Rate Payable Market Value Capacity Tax Rate Payable Change Char Residential: Value Up 10.00% $ 200,000 2,000 44.573% $ 891,46 $ 220,000 2,200 41.162% $ 905.56 $ 14.10 1.58% Residential: Value up 8.287% $ 200,000 2,000 44.573% $ 891.46 $ 216,574 2,166 41.162% $ 891.46 $ 0,00 0.00% Residential: Value Up 5,00% $ 200,000 2,000 44.573°% $ 891,46 $ 210,000 2,100 41,162% $ 864.40 $ (27.06) (3.04%) Residential: Value Stable $ 200,000 2,000 44.573°A $ 891.46 $ 200,000 2,000 41,162% $ 823.24 $ (68,22) (7.65%) Residential: Value Down 5.00% $ 200,000 2,000 44.573% $ 891.46 $ 190,000 1,900 41.162% $ 782,08 1 $ (109,38) (12,27%) Commercial: Value Up 7,932% $ 875,000 16,750 44.5730/c $ 7,465.98 Commercial Value Up 5.00% $ 875,000 16,750 44.573% $ 7,465.98 Commercial: Value Stable $ 875,000 16,750 44,573% $ 7,465.98 Commercial: Value Down 5,00% $ 8751000 16,750 44,573% $ 7,465.98 $ 944,402 18,138 41.162% $ 7,465.98 $ 918,750 17,625 41.162% $ 7,254.80 $ 875,000 16,750 41.162% $ 6,894,64 $ 831,250 15,875 41.162% $ 6,534.47 $ 0.00 0.001/0 $ (211.18) (2.83%) $ (571.34) (7,65%) $ (931.51) (12.48%) Why would my property i • City asks for more or less dollars. Market Value of my property goes up or down Market Value of my property changes in relation to other properties Legislative law changes — tax classification rates — homestead credits or value exclusions Real value growth in property tax base Other Funds— Debt Service Funds Bonded Debt 12/31/2014: $ 38,475,000 2015 Principal Payments 1,130,000 Bonded Debt 13/31/2015 $ 37,345,000 2015 Principal Payments $ 1,130,000 2015 Interest Payments 1,265,609 2015 Debt Service Expenditures $ 2,395,609 * G.O. Improvement 2004A and G.O. Improvement 20058 were paid off according to the adopted refunding schedules from trustee escrows Other Funds—Water Fund Water Sales $1,127,500 Other Revenues 181,600 Revenues $1,309,100 Personal Services $ 671361 Supplies 150,563 Contractual Services 1691400 Depreciation 5021200 Transfers (incl. debt payments) 481,552 Expenditures $ 113711076 Net Operations $ (61,976) Net Cash Flows $ 4191576 Non -Operating Revenues $ 292,958 rate increase 2050% Other Funds—Sewer Fund Sewer Charges $1,240,995 Other Revenues 47,000 Revenues $1,287,995 Personal Services $ 205,108 Supplies 1501820 Contractual Services 3391965 Depreciation 8601117 Transfers(incl.debt payments) 812,038 Expenditures $ 213681048 Net Operations $(1,080,053) Net Cash Flows $(268,015) Non -Operating Revenues $ 481,833 rate increase 5.00% PUBLIC COMMENT CONSIDER RESOLUTIONS ADOPTING THE PROPERTY TAX LEVY PAYABLE IN 2015 AND THE 2015 OPERATING BUDGETS FOR GENERAL FUND, DEBT SERVICE FUNDS AND UTILITY FUNDS