Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
2017 Draft Budget 7-27-2016
,isCity of Otsego General Fund Budget - 2017 Requested Budget Revenue & Expenditure Summary Descri Revenues Taxes Cable Franchise Fees Licenses & Permits Intergovernmental Charges for Services Special Assessments Fines & Forfeitures Investment Interest Miscellaneous Interfund Transfers Subtotal Expenditures General Government Public Safety Public Works Culture & Recreation Economic Development Interfund Transfers Subtotal Net Change in Fund Balance 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 3,291,805 2,000,000 1,000,000 2014 Actual Requested Actual Actual Year -to -Date Budget Budget 2014 2015 2016 2016 2017 $ 3,321,316 $ 3,315,453 $ 1,900,936 $ 3,544,352 $ 3,763,588 120,964 128,722 65,503 107,000 132,000 1,238,823 1,179,136 1,094,163 641,565 792,650 337,778 195,363 93,447 343,590 185,905 192,168 174,659 154,203 57,000 105,550 7,136 3,540 1,426 - - 4,000 11,998 5,569 - 6,000 36,017 14,410 329,022 50,000 33,000 29,854 39,251 38,231 - - 425,868 122,276 - 136,755 155,042 5,713,925 5,184,807 3,682,501 4,880,262 5,173,735 1,105,873 1,150,132 718,481 1,255,768 1,339,049 1,496,111 1,666,511 1,098,496 1,757,000 1,862,634 1,014,934 1,034,525 519,829 1,098,952 1,143,828 434,268 477,444 264,375 535,652 589,181 93,179 96,211 46,405 105,300 109,860 86,411 1,289,914 460,212 127,590 129,105 4,230,777 5,714,737 3,107,799 4,880,262 5,173,657 $ 1,483,148 $ (529,930) $ 574,702 $ - $ 78 Revenues Expenditures -*--Fund Balance City of Otsego General Fund Budget -2017 Requested Budget Revenues V 6.71% Tax Levy Increase Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Source Account Description 2014 2015 2016 2016 2017 Comments 101 31010 CURRENT AD VALOREM TAXES 101 31011 UNCOLLECTED PROPERTY TAXES 101 31020 DELINQUENT AD VALOREM TAXES 101 31800 OTHER TAXES 101 31900 PENALTIES AND INTEREST TOTAL -TAXES 101 38050 CABLE TV FRANCHISE FEES TOTAL - CABLE FRANCHISE FEES 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 PERMIT 101 32260 BUILDING PERMITS 101 32261 PLUMBING PERMITS 101 32262 MECHANICAL PERMITS 101 32270 SEPTIC SYSTEM PERMITS 101 32280 WETLAND REVIEW FEES 101 32999 ASSESSORS FEE TOTAL - LICENSES & PERMITS 101 33402 HOMESTEAD CREDIT 101 33403 LOCAL GOVERNMENT AID 101 33405 POLICE AID 101 33406 MSA MAINTENANCE 101 33422 OTHER STATE AID GRANTS 101 33423 PERA AID 101 33424 OTHER GRANTS TOTAL - INTERGOVERNMENTAL $ 3,304,656 $ 3,266,747 $ 1,870,841 $ 3,529,352 $ 3,766,250 - - - - (37,663) Recent collection rates have been 99% - 41,262 28,744 30,000 1,726 - - - 14,934 7,444 1,351 15,000 5,000 3,321,316 3,315,453 1,900,936 3,544,352 3,763,588 120,964 128,722 65,503 107,000 132,000 Annualized - Based on Amounts Received for Q1-Q2 2016+ 1% Inflation 120,964 128,722 65,503 107,000 132,000 62,575 5,095 870 600 1,000 150 - 150 - - 37,340 29,850 37,400 30,000 56,000 5,600 37,600 25,910 2,500 10,000 6,920 1,700 1,380 750 100 1,750 2,950 4,300 1,750 2,000 - 43,425 34,350 38,450 33,750 400 400 400 300 300 992,257 900,639 887,092 444,215 600,000 53,100 66,532 43,165 52,000 36,000 63,325 71,840 45,496 58,000 42,000 5,550 6,955 2,900 3,000 4,000 - 2,000 4,000 - - 9,855 10,150 6,750 10,000 7,500 1,238,823 1,179,136 1,094,163 641,565 792,650 Includes: Garbage Haulers ($50 Each), Peddlers ($100 Each) Based on 2015 Licenses (374 @ $150) - 2016 YTD = 285 on 7-25-2016 Based on 50 Permits at $200 Each Includes: Fowl Keeping, Etc. Estimate Based on Prior Year Actuals Based on 2016 Approvals (Tami Provided) Estimate Based on Prior Year Actuals Estimated 150 Permits at $4,000 (Roughly a $320,000 Home) Based on 3 Year Average as Compared to Building Permits (6%) Based on 3 Year Average as Compared to Building Permits (7%) Estimate Based on Prior Year Actuals 150 Permits at $50 (Consider Changing Fee - County Only Charges $25) 6,825 11,368 - - Agricultural MV Credits - Unknown if these are ongoing. 112,711 123,947 - 127,590 129,105 Budget Directly into Capital Fund? 52,669 55,676 53,000 55,000 Estimate Based on Prior Year Actuals 163,006 - 93,447 163,000 - This funding now goes to Pavement Management Fund (#201). 695 - - - - 1,872 1,872 - - 1,800 Estimate Based on Prior Year Actuals - C,Dvu - - - 337,778 195,363 93,447 343,590 185,905 101 34050 ADMINISTRATIVE FEES 101 34100 CONDITIONAL USE/VARIANCE FEES 101 34103 ZONING AND SUBDIVISION FEES 101 34105 SALE OF MAPS AND PUBLICATIONS 101 34107 ASSESSMENT SEARCH FEES 101 34201 MINING FEES 101 34207 REIMBURSABLE EXPENSE MOWING 101 34301 STREET, SIDEWALK AND CURB FEES 101 34302 STREET & TRAFFIC CONTROL SIGNS 101 34303 PWCHARGES- OTHERDEPARTMENTS 101 34320 STREET LIGHT OF 101 34330 GRADING REVIEWS 101 34700 RECREATION FEES 101 34709 FIELD MAINTENANCE 101 34710 SHELTER RENTAL FEES 101 34733 TOURNAMENTS 101 34740 SPORT FIELD USE 101 34750 PRAIRIE CENTER 101 34760 OTSEGO FESTIVAL VENDORS TOTAL -CHARGES FOR SERVICES 101 36100 SPECIAL ASSESSMENTS 101 36102 SPECIAL ASSESSMENT PENALTIES TOTAL -SPECIAL ASSESSMENTS 101 35101 FINES & FORFEITS TOTAL - FINES & FORFEITURES 101 36210 INTEREST EARNINGS 101 36213 NET CHANGE IN INVESTMENT FMV TOTAL -INVESTMENT INTEREST 101 36200 MISCELLANEOUS REVENUES 101 36261 OTHER 101 38010 HPC BOOK SALES 101 38020 DONATIONS/CONTRIBUTIONS 101 38991 REFUNDS & REIMBURSEMENTS 101 39101 SALES OF GENERAL FIXED ASSETS TOTAL - MISCELLANEOUS 101 39200 INTERFUND OPERATING TRANSFERS TOTAL-INTERFUND TRANSFERS Grand Total 36,007 17,336 34,835 2,000 5,000 - - 200 - - 40,519 14,189 11,000 5,500 5,000 347 120 36 - - 2,125 1,050 1,030 2,000 1,500 8,928 16,708 17,440 - 5,000 360 - 450 - 9,000 - - - - 11,250 17,250 - 2,000 504 - - - - 48,000 32,000 18,000 2,000 8,000 2,772 30,150 19,277 4,000 22,500 23,845 29,977 19,830 30,000 28,000 - - 675 - - 4,247 2,435 2,452 2,500 4,500 2,046 1,583 3,398 - 2,000 - 3,315 1,200 4,000 4,000 2,685 5,233 2,081 5,000 5,000 10,783 9,314 5,050 - 13,050 192,168 174,659 154,203 57,000 305,550 6,115 3,540 1,426 - - 1,021 - - 7,136 3,540 1,426 Conservative - Only Receive if Developments Occur Conservative - Only Receive if Developments Occur Estimate Based on Prior Year Actuals Conservative - Engineer is confident mining will occur in 2017. Conservative - Only Receive if Developments Occur Conservative - Only Receive if Developments Occur 150 Permits at $150 (Offsets Grading Review Costs in Building Department) See Detail by Program (Provided by Ross (7-19-2016) Provided by Ross (6-27-2016) Provided by Ross (6-27-2016) Provided by Ross (6-27-2016) Provided by Ross (6-27-2016) Budgeted Expenditures (101-45250-490), less City Contribution ($5,000). 4,000 11,998 5,569 6,000 Wright County Court Fines (12 Months @ $500) 4,000 11,998 5,569 - 6,000 36,017 19,346 161,605 50,000 33,000 2016 YTD into PY Allocation Formula ($16,496); Then Annualized & Rounded (4,936) 167,417 - - Accounting Only - No Cash Transactions 36,017 14,410 329,022 50,000 33,000 3,044 28,784 15,077 - - 5,390 - - 47 218 - 4,500 6,259 5,250 16,034 3,990 17,904 - - 840 29,854 39,251 38,231 - 425,868 122,276 - 136,755 155,042 Water & Sanitary Sewer Administrative Services Charge 425,868 122,276 136,755 155,042 $ 5,713,925 $ 5,184,807 $ 3,682,501 $ 4,880,262 $ 5,173,735 Change ($) 293,473 Change (%) 6,01% 2017 Estimate EVENT Revenue Expenses Staff Balance Tiny Tot Program -Jan 250.00 19.66 364.00 (133.66) Zumba 201.00 80.00 121.00 Full Body 86.00 80.00 6.00 Tiny Tot Program - Feb 227.00 364.00 (137.00) Cheer America 1,090.19 720.00 187.50 182.69 Zumba 209.71 80.00 129,71 Full Body 90.81 80.00 10.81 Beginner Archery Class 258.70 140.00 118.70 Tot Tumbling 288.30 290.00 (1.70 Preschool Tumbling 144.53 290.00 (145.47) Safe on my Own 244.49 86.48 158.01 Tiny Tot Program -March 312.00 364.00 52.00) Tiny Tot Program April 286.00 364.00 (78.00) Zumba 253.74 120.00 133.74 Yoga Fusion 317.11 120.00 197.11 Yoga 169.31 120.00 49.31 Tot Tumbling 337.25 336.00 1.25 Preschool Tumbling 135.05 336.00 (200.95) Wine Canvas 1,237.03 960.00 15.00 262.03 Managing Your ISO Devices 58.39 70.00 (11.61) Square foot gardening 155.00 300.00 70.00 (215.00) Zumba 114.57 80.00 34.57 MultiSport Camp 168.69 138.00 30.69 Soccer Camp 10am 361.93 172.50 189.43 T-Ball 2,393.60 661.25 187.50 1,544.85 Tiny T-Ball 3,482.27 878.25 187.50 2,416.52 Little Library Story Time Wednesdays 91.00 (91.00) Little Library Story Time Thursday 10.99 91.00 (101.99) Archery Beginner 588.81 480.00 24.00 84.81 Youth Tennis Lessons 5-8 188.48 188.48 Youth Tennis Lessons 9-12 233.38 233.38 Safety Camp 462.27 304.00 352.00 (193.73) Safety Camp Before and After 67.67 67.67 Tot Tumbling 4 classes 1,263.72 714.25 549.47 Preschool Tumbling 169.08 168.00 1.08 Zumba $105.60 105.60 Soccer Camp $360.86 $30.00 $172.50 158.36 MultiSport Camp $197.07 $138.00 59.07 Paintball in the Park $120.94 120.94 Youth Golf Program $1,062.48 $700.00 $16.00 346.48 Youth Tennis 5-8 $143.93 $350.00 (206.07) Youth Tennis 9-12 $307.64 $350.00 (42.36) Bea Princess $129.65 $90.00 39.65 Date Night Couple Canoe Trip $541.96 $463.64 $45.00 33.32 Tiny Tot Program -Sept $112.00 $210.00 Wednesdays & Thursdays Tiny Tots - Sept $102.00 $175.00 (73.00) Tot Time Tumbling $677.98 $336.00 341.98 Flag FootballK-1 $1,839.53 $680.00 $87.00 1,072.53 Flag Football 2-3 $817.50 $1,153.00 (335.50) Zumba $229.42 $120.00 109.42 Yoga Fusion $338.17 $120.00 218.17 Tiny Tot Program -Oct $170.00 $336.00 166.00 Monster Mash Dash $842.02 $406.40 435.62 Tiny Tot Program - Nov $210.00 $252.00 (42.00) Zumba $243.21 $160.00 83.21 Adult Child Archery $130.48 $60.00 70.48 Tiny Tot Program - Dec $168.00 $252.00 (84,00 Snowmobile $188.41 $195.00 $100.00 (106.59) Be a Princess $115.07 $80.00 35.07 New programs $3,000.00 $3,500.00 $3,952.00 (4,452.00) $2&;�00'00 $S'3,9dQ.19 $11,T2613 •$3,pi3,5£t= City of Otsego General Fund Budget - 2017 Expenditures by Function Summary Requested Amounts Requested Actual Actual Year -to -Date Budget Budget Function & Department 2014 2015 2016 2016 2017 General Government 41100 City Council $ 52,852 $ 58,713 $ 47,255 $ 116,276 $ 124,293 41400 Administration 382,738 379,882 228,669 469,467 461,064 41410 Elections 25,671 1,003 3,046 29,825 1,924 41550 Assessing 72,517 70,537 76,623 76,941 81,623 41600 Finance 318,213 341,965 176,704 288,531 318,400 41650 Information Technology 42,606 71,523 48,285 72,000 94,500 41700 Legal 101,013 123,239 60,234 86,000 114,000 41940 Prairie Center 26,968 21,980 18,711 33,877 32,149 41945 City Hall & Public Works Building 82,267 80,594 58,371 82,351 109,656 41950 Old Town Hall 1,027 695 583 500 1,440 Subtotal 1,105,873 1,150,132 718,481 1,255,768 1,339,049 Public Safety 42100 Police Services 42150 Public Safety Commission 42200 Fire Protection 42410 Building Inspection 42500 Emergency Management 42710 Animal Control Subtotal Public Works 43100 Streets 43150 Engineering 43160 Street Lights 43240 Fleet Management Subtotal Culture & Recreation 45200 Park Maintenance 45250 Recreation 45300 Heritage Preservation Commission Subtotal Economic Development 46530 Planning Commission 46570 Planning 46580 Economic Development Subtotal Interfund Transfers 49300 Interfund Transfers Subtotal Grand Total 912,365 952,546 576,914 978,200 1,020,700 605 137 - 2,850 2,850 377,926 455,367 368,179 497,462 527,490 190,295 244,122 141,108 250,588 287,274 309 2,878 7,736 14,400 9,920 14,610 11,460 4,560 13,500 14,400 1,496,111 1,666,511 1,098,496 1,757,000 1,862,634 620,265 630,107 337,085 689,681 727,326 93,093 122,074 29,792 85,000 86,400 111,465 108,987 56,975 115,968 117,000 190,111 173,358 95,978 208,303 213,102 1,014,934 1,034,525 519,829 1,098,952 1,143,828 293,209 326,850 179,376 381,806 391,088 139,020 148,993 84,582 151,396 195,643 2,040 1,601 416 2,450 2,450 434,268 477,444 264,375 535,652 589,181 745 1,724 280 3,000 4,000 88,340 86,335 37,758 88,000 91,200 4,095 8,152 8,367 14,300 14,660 93,179 96,211 46,405 105,300 109,860 86,411 1,289,914 460,212 127,590 129,105 86,411 1,289,914 460,212 127,590 129,105 $ 4,230,777 $ 5,714,737 $ 3,107,799 $ 4,880,262 $ 5,173,657 Change ($) $ 293,395 Change (%) 6.01% 2017 Budget City Building Fleet Council Administration Finance Inspections Streets Management Parks Recreation Totals 101 FULL-TIME EMPLOYEES REGULAR $ $ 313,185 $ 201,240 $ 54,309 $ 324,906 $ 61,048 $ 136,190 $ 45,352 $ 1,136,230 102 FULL-TIME - OVERTIME - - - 81000 - 1,000 - 9,000 104 PART-TIME EMPLOYEES REGULAR 34,000 17,472 - 19,129 24,480 - 29,146 43,698 167,925 121 PERA - 23,489 15,093 5,508 24,968 4,579 10,289 6,079 90,005 122 FICA AND MEDICARE 2,601 25,295 15,395 5,618 27,340 4,670 12,725 6,812 100,456 130 OTHER EMPLOYER PAID INS - 24,308 24,872 11,277 38,616 11,307 10,515 11,859 132,754 150 WORKERS COMPENSATION 133 21059 11267 462 30,039 2,056 8,054 2,837 46,907 Total 36,734 405,808 257,867 96,303 478,349 83,660 207,919 116,637 1,683,277 2016 Budget City Building Fleet Council Administration Finance Inspections Streets Management Parks Recreation Totals 101 FULL-TIME EMPLOYEES REGULAR $ $ 298,339 $ 182,394 $ 52,107 $ 307,505 $ 55,756 $ 131,089 $ 42,861 $ 1,070,051 102 FULL-TIME - OVERTIME - - - 81000 - - - 8,000 104 PART-TIME EMPLOYEES REGULAR 34,000 - - 16,877 21,542 - 28,015 31,073 131,507 121 PERA - 22,375 13,680 5,174 23,663 4,182 9,832 5,155 84,061 122 FICA AND MEDICARE 2,601 22,823 13,953 5,277 25,784 4,265 12,172 5,931 92,806 130 OTHER EMPLOYER PAID INS - 23,185 17,285 8,364 42,500 10,313 11,754 10,726 124,127 150 WORKERS COMPENSATION 317 694 694 694 21,447 1,861 2,912 650 29,269 Total 36,918 367,416 228,006 88,493 450,441 76,377 195,774 96,396 1,539,821 Change ($) (184) 38,392 29,861 7,810 27,908 7,283 12,145 20,241 143,456 Change (%) -0.50% 10.45% 13.10% 8.83% 6.20% 9.54% 6.20% 21.00% 9.32% Change ($) 143,456 293,395 Total Budget Increase Scanning Clerk (18,918) 48.90% Percentage of Increase W/C Premiums (22,873) Net Change 101,665 6.60% City of Otsego General Fund Budget - 2017 Department Requests 41100 - City Council Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 41100 104 PART-TIME EMPLOYEES REGULAR $ 33,846 $ 28,930 $ 14,475 $ 34,000 $ 34,000 101 41100 122 FICA AND MEDICARE 2,529 2,213 1,107 2,601 2,601 101 41100 150 WORKERS COMPENSATION 253 190 421 317 133 TOTAL - PERSONAL SERVICES 36,628 31,333 16,004 36,918 36,734 101 41100 210 OPERATING SUPPLIES 25 - - - - TOTAL -SUPPLIES 25 - - - - 101 41100 320 TELEPHONE 1,900 2,451 1,045 2,520 2,400 Ipad Data Plan (5 @ $40 Monthly) 101 41100 321 MILEAGE/TRAVEL 65 60 50 200 200 101 41100 355 DUES & MEMBERSHIPS 430 210 16,108 200 24,200 See Detailed Attachment 101 41100 360 EDUCATION/TRAINING/CONFERENCES 356 1,657 - 3,300 3,500 See Detailed Attachment 101 41100 361 LIABILITY AND PROPERTY INSURAN - 4,401 12,036 - 17,259 Estimate - 5% Increase from 2015-2016 Actual Premiums 101 41100 801 CONTINGENCY 13,449 17,129 2,013 73,138 40,000 TOTAL - SERVICES & OTHER CHARGES 16,200 25,908 31,251 79,358 87,559 101 41100 500 CAPITAL OUTLAY (GENERAL) - 1,473 - - - TOTAL - SERVICES & OTHER CHARGES - 1,473 DEPARTMENT TOTAL $ 52,852 $ 58,713 $ 47,255 $ 116,276 $ 124,293 Change ($) 8,017 Change (%) 6.89% City of Otsego General Fund Budget - 2017 Detail of Line Item Requests City Council Requested Budget Budget Account No. & Description 2016 2017 Item Detail / Description Comment 101-41100-355 $ 150 DUES & MEMBERSHIPS - 50 200 101-41100-360 $ 250 EDUCATION/TRAINING/CONFERENCE 350 900 800 1,000 3,300 $ 200 Wright County Mayor's Association Dues 13,000 League of Minnesota Cities Annual Membership Dues 8,000 1-94 Chamber of Commerce Corridor Coalition 3,000 WCAT Membership + Share of Operating Costs - League of Minnesota Cities Mayor's Association Dues 24,200 $ 800 (2) League of Minnesota Cities (LMC) Annual Conference 700 (2) Newly Elected Officials Conference 1,000 Commissioner Appreciation Dinner 1,000 Employee Recognition Events (30 Staff @ $25) + Years of Service Recognition ($250) - Office Supplies & Meeting Refreshments 3,500 City of Otsego General Fund Budget - 2017 Department Requests 41400 - Administration Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 41400 101 FULL-TIME EMPLOYEES REGULAR $ 215,671 $ 233,892 $ 154,302 $ 298,339 $ 313,185 101 41400 104 PART-TIME - EMPLOYEES REGULAR 3,616 9,631 6,080 - 17,472 101 41400 121 PERA 16,077 19,146 11,642 22,375 23,489 101 41400 122 FICA AND MEDICARE 16,090 17,812 11,722 22,823 25,295 101 41400 123 HEALTH 7,234 - - - - 101 41400 130 OTHER EMPLOYER PAID INS 1,347 15,059 13,208 23,185 24,308 101 41400 150 WORKERS COMPENSATION 1,297 799 407 694 2,059 TOTAL - PERSONAL SERVICES 261,333 296,338 197,361 367,416 405,808 101 41400 201 OFFICE SUPPLIES AND EXPENSES 9,772 10,529 5,012 8,500 10,000 101 41400 206 POSTAGE 3,121 3,000 - 4,600 - 101 41400 210 OPERATING SUPPLIES - 1,717 1,019 1,213 1,000 TOTAL - SUPPLIES 12,893 15,245 6,031 14,313 11,000 101 41400 309 SOFTWARE & SUPPORT - - 7,209 - 8,000 101 41400 315 GIS SERVICES 1,246 - - - - 101 41400 320 TELEPHONE 10,016 2,495 56 1,450 - 101 41400 321 MILEAGE/TRAVEL 980 722 482 1,100 1,100 101 41400 340 RECORDING FEES 1,474 1,112 1,143 1,500 1,700 101 41400 347 NEWSLETTER 17,153 17,276 7,680 16,280 20,800 101 41400 350 PRINT&PUBLISHING 5,986 6,295 4,000 6,500 6,500 101 41400 355 DUES & MEMBERSHIPS 12,439 4,573 438 12,785 670 101 41400 360 EDUCATION/TRAINING/CONFERENCES 1,726 2,534 916 2,500 1,900 101 41400 361 LIABILITY AND PROPERTY INSURAN 28,966 16,578 2,293 23,025 2,586 101 41400 390 CONTRACTED SERVICES 5,157 5,614 1,060 11,398 1,000 101 41400 410 RENTALS 5,943 11,099 - 11,200 - TOTAL -SERVICES & OTHER CHARGES 91,087 68,299 25,276 87,738 44,256 101 41400 501 EQUIPMENT 17,425 - - - - TOTAL - CAPITAL OUTLAY 17,425 - - - - DEPARTMENT TOTAL $ 382,738 $ 379,882 $ 228,669 $ 469,467 $ 461,064 Change ($) (8,403) Change (%) -1.79% 2016 Actual and 2017 Budget - Now in City Hall Department (41945) See Detailed Attachment Easements, Notice of Completion, Agreements, Findings and Decision See Detailed Attachment Ordinances, Legal Notices See Detailed Attachment See Detailed Attachment Estimate - 5% Increase from 2015-2016 Actual Premiums See Detailed Attachment 2016 Actual and 2017 Budget - Now in City Hall Department (41945) City of Otsego General Fund Budget - 2017 Detail of Line Item Requests Administration r Budget Account No. & Description 2016 101-41400-309 $ SOFTWARE & SUPPORT 101-41400-347 $ 5,684 NEWSLETTER 2,120 3,876 3,000 1,600 16,280 101-41400-355 $ 12,250 DUES & MEMBERSHIPS 500 35 12,785 101-41400-360 $ 871 EDUCATION / TRAINING / CONFERENCE 500 300 60 50 200 410 100 9 2,500 $ 2,750 101-41400-390 CONTRACTED SERVICES 3,000 1,975 525 1,500 700 750 198 11,398 Requested Budget 2017 Item Detail / Description Comment 2,750 Laserfiche Software 3,000 Laserfiche Weblink Software 370 OPG3 - Laserfiche Support ($185 Per Hour- 2 Hours) 1,740 WebO,A 140 Contingency/Rounding 8,000 10,000 Helgeson - Printing Costs 2,400 Helgeson - Mailing Costs 4,000 Postage 2,000 Kim Welter - Design Costs 2,400 The Planning Company - Drafting 20,800 - League of Minnesota Cities 200 Minnesota Cities & County Management Association 200 International Institute of Municipal Clerks 200 Society for Human Resource Management 70 Minnesota Clerk & Finance Officer Association (2 Memberships) 670 $ 497 Minnesota Municiapl Utilities Association - Citywide Safety Training 625 Minnesota Clerk & Finance Officer Association Conference (2 Attenc 400 LMC Conference (1 Attendee) 60 194 Chamber Lunch Meetings 50 State of Minnesota Cities 200 Government Trainine Service (New Laws) 68 lContingency / Rounding 00 Laserfiche Software Laserfiche Weblink Soft% Laserfiche - Add 3 Users OPG3 - Laserfiche Suppc Internet Service - Web Hosting 00 Web Design - Installation Costs - New City of Otsego General Fund Budget - 2017 Department Requests 41410 - Elections Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 41410 104 PART-TIME EMPLOYEES REGULAR $ 11,756 $ - $ - $ 13,850 $ - TOTAL - PERSONAL SERVICES 11,756 - - 13,850 - 101 41410 210 OPERATING SUPPLIES 11,946 1,003 2,582 13,600 1,924 Annual Maintenance & Support - Hardware / Software / Firmware TOTAL - SUPPLIES 11,946 1,003 2,582 13,600 1,924 101 41410 321 MILEAGE/TRAVEL 1,605 - 48 1,875 - 101 41410 350 PRINT&PUBLISHING 365 416 500 TOTAL - SERVICES & OTHER CHARGES 1,970 - 464 2,375 - DEPARTMENT TOTAL $ 25,671 $ 1,003 $ 3,046 $ 29,825 $ 1,924 Change ($) (27,901) Change (%) -93.55% City of Otsego General Fund Budget - 2017 Department Requests 41550 - Assessing Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 41550 390 CONTRACTED SERVICES $ 72,517 $ 70,537 $ 76,623 $ 76,941 $ 81,623 2016 Actual Paid +2016 New Construction (200 @ $25 Each) TOTAL -SERVICES & OTHER CHARGES 72,517 70,537 76,623 76,941 81,623 DEPARTMENT TOTAL $ 72,517 $ 70,537 $ 76,623 $ 76,941 $ 81,623 County Charges = $25 / Building Permit Charges = $50 (Consider Break -Even) Change ($) 4,682 Change (%) 6.09% City of Otsego General Fund Budget - 2017 Department Requests 41600 - Finance Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 41600 101 FULL-TIME EMPLOYEES REGULAR $ 155,011 $ 131,380 $ 94,778 $ 182,394 $ 201,240 101 41600 102 FINANCE OVERTIME 341 201 - - - 101 41600 104 WAGES - PT EMPLOYEES 68,940 47,760 - - - 101 41600 121 PERA 15,634 12,854 7,130 13,680 15,093 101 41600 122 FICA AND MEDICARE 16,548 13,579 6,598 13,953 15,395 101 41600 123 HEALTH 12,824 - - - - 101 41600 130 OTHER EMPLOYER PAID INS 1,222 14,068 16,559 17,285 24,872 101 41600 140 UNEMPLOYMENT COMP 702 3,117 - - - 101 41600 150 WORKERS COMPENSATION 1,156 777 451 694 1,267 TOTAL - PERSONAL SERVICES 272,379 223,737 125,516 228,006 257,867 101 41600 201 OFFICE SUPPLIES AND EXPENSES 961 2,248 81 5,200 3,000 TOTAL - SUPPLIES 961 2,248 81 5,200 3,000 101 41600 304 ACCOUNTING&AUDITING 29,350 29,635 29,800 32,935 26,950 101 41600 309 IT -SOFTWARE LICENSE - - 6,541 - 7,200 101 41600 320 TELEPHONE - 70 102 - - 101 41600 321 MILEAGE/TRAVEL 159 438 179 450 600 101 41600 350 PRINT&PUBLISHING 3,176 1,118 2,041 1,200 3,500 101 41600 355 DUES & MEMBERSHIPS 285 620 518 1,240 400 101 41600 360 EDUCATION/TRAINING/CONFERENCES 2,633 5,486 486 4,500 2,800 101 41600 361 LIABILITY AND PROPERTY INSURAN - 506 1,383 - 1,983 101 41600 390 CONTRACTED SERVICES 9,269 77,052 9,129 15,000 12,000 101 41600 437 BANK SERVICE CHARGES - 1,056 930 - 2,100 TOTAL -SERVICES & OTHER CHARGES 44,873 115,981 51,107 55,325 57,533 DEPARTMENT TOTAL $ 318,213 $ 341,965 $ 176,704 $ 288,531 $ 318,400 Change ($) 29,869 Change (%) 10.35% Based on Quote from BerganKDV (5-17-2016) Caselle Financial Software ($6,000) + Plan -IT CIP Software ($1,200) See Detailed Attachment See Detailed Attachment See Detailed Attachment Estimate - 5% Increase from 2015-2016 Actual Premiums See Detailed Attachment City of Otsego General Fund Budget - 2017 Detail of Line Item Requests Finance Budget Account No. & Description 2016 101-41600-350 $ 1,200 PRINT & PUBLISHING - 1,200 101-41600-355 $ 340 DUES & MEMBERSHIPS 585 315 1,240 101-41600-360 $ 870 EDUCATION/TRAINING/CONFERENCE 830 930 1,870 Requested Budget 2017 Item Detail / Description Comment $ - Lump Sum (Financial Statements, Official Statements, Budgets, CIP, GAAFR Update) 1,300 Wright County -Truth In Taxation Notices 1,000 Newspaper Publishing (Budget, Summary Financial Reports) 750 Printing - Comprehensive Annual Financial Reports 450 Application Fee - Comprehensive Annual Financial Report Award Program 3,500 $ 950 (2) State Government Finance Officer's Association Conference - (2) Minnesota Clerk's & Finance Officer's Association Conference 250 (2) CPA License Renewals 550 (2) Various Government Finance Seminars (CLA, AEM, MN GFOA, Etc.) 300 (2) Unlimited Continuing Education Software Packages 306 Minnesota Municiapl Utilities Association - Citywide Safety Training - Civic Systems - Caselle Clarity Financial Software Training 444 lContingency - New Events or Sources of Training 4,5001 2,800 101-41600-390 $ 15,000 CONTRACTED SERVICES - 15,000 $ - Lump Sum (Civic Systems, ADP Payroll, Wageworks, County Auditor -Treasurer) 7,800 Paychex Payroll ($300 Per Payroll) 1,200 Wageworks Benefits Administration ($100 Monthly) 300 Wright County - Audit Verification Report +Annual Auditor Certificate 2,500 Wright County- Special Assessment Administration Fees 200 Background Checks, Job Postings 12,000 City of Otsego General Fund Budget - 2017 Department Requests 41650 - Information Technology Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 41650 210 OPERATING SUPPLIES $ 3,094 $ 3,707 $ 1,528 $ 5,000 $ 5,000 TOTAL - SUPPLIES 3,095 3,707 1,528 5,000 5,000 101 41650 309 SOFTWARE & SUPPORT 750 2,703 6,036 5,000 6,500 See Detailed Attachment 101 41650 315 GIS SERVICES - 16,900 13,861 19,000 15,000 See Detailed Attachment 101 41650 322 UTILITIES - 1,026 - 2,000 Charter Communications (TV & Internet Service - $160 Monthly) 101 41650 360 EDUCATION/TRAINING/CONFERENCES - - - 2,000 - 101 41650 390 CONTRACTED SERVICES 37,082 43,483 22,325 40,000 60,000 Increased Hours to Meet Demands (100 Hours Max Per Month) TOTAL - SERVICES & OTHER CHARGES 37,832 63,086 43,247 66,000 83,500 101 41650 501 EQUIPMENT 1,680 4,729 3,510 1,000 6,000 See Detailed Attachment TOTAL - CAPITAL OUTLAY 1,680 4,729 3,510 1,000 6,000 DEPARTMENT TOTAL $ 42,606 $ 71,523 $ 48,285 $ 72,000 $ 94,500 Change ($) 22,500 Change (%) 31.25% City of Otsego General Fund Budget -2017 Detail of Line Item Requests Information Technology Requested Budget Budget Account No. & Description 2016 2017 Item Detail / Description Comment 101-41650-309 $ 51000 SOFTWARE & SUPPORT - $ - Lump Sum (Email, Anti -Virus, Other Systems) 420 US Internet - Email Spam Filter 300 TR Computer Sales - Annual Firewall Protection Upgrade for Router 3,600 Microsoft - Email Server (40 Accounts @ $90 Each) 1,000 Avenet - City Website Hosting 1,180 Contingency - Microsoft Windows, Microsoft Office, Currently Unknown Products 5,0001 6,500 101-41650-315 $ 19,000 GIS SERVICES 19,000 101-41650-501 $ 1,000 EQUIPMENT - 1,000 nson Annerson - hU upclares Iver Kon 5-Lb-LU1bf it County - Aerial Photography (2011 and 2015...Ne7t 7n $ - GB Network Switches 1,500 Computer Replacement - Streets Supervisor (Kevin) 1,500 Computer Replacement - Office Assistant / Receptionist (Melanie) 1,500 Computer Replacement - City Administrator (Lori) 1,500 Computer Replacement - Accountant (Jeff) 6,000 City of Otsego General Fund Budget - 2017 Department Requests Pr 41700 - Legal Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 41700 301 LEGAL SERVICES $ 101,013 $ 123,239 $ 60,234 $ 86,000 $ 114,000 Based on 2016 YTD Monthly Average Less 5% TOTAL -SERVICES & OTHER CHARGES 101,013 123,239 60,234 86,000 114,000 DEPARTMENTTOTAL $ 101,013 $ 123,239 $ 60,234 $ 86,000 $ 114,000 Change ($) 28,000 Change (%) 32.56% City of Otsego General Fund Budget - 2017 Department Requests 41940 - Prairie Center Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 41940 104 PART-TIME - EMPLOYEES REGULAR $ - $ - $ - $ 3,000 $ - 101 41940 122 FICA AND MEDICARE 230 101 41940 150 WORKERS COMP - - - 50 - TOTAL -PERSONAL SERVICES 3,280 - 101 41940 201 OFFICE SUPPLIES AND EXPENSES 277 167 500 500 Paper, Printer Cartridges, Etc. 101 41940 210 OPERATING SUPPLIES 6,153 3,824 2,469 4,000 4,800 Coffee & Water / Cleaning & Restroom Products / Building Supplies 101 41940 220 REPAIR/MAINT SUPPLY 204 276 5,856 11,000 5,000 General building repairs and maintenance. TOTAL - SUPPLIES 6,634 4,268 8,325 15,500 10,300 101 41940 320 TELEPHONE - - 846 - 1,800 Centurylink(Elections Line + Alarm Monitoring) -$150Monthly 101 41940 322 UTILITIES 7,424 8,205 5,160 8,500 11,000 Natuaral Gas (Centerpoint) & Electric (Wright Hennepin) 101 41940 325 GARBAGE SERVICE 307 1,452 1,113 1,800 2,400 Randy's Environmental Services (12 Months at $200) 101 41940 361 LIABILITY AND PROPERTY INSURAN 1,572 907 104 1,297 149 Estimate - 5% Increase from 2015-2016 Actual Premiums 101 41940 389 CLEANING SERVICES 3,475 269 398 - 600 T-Shirts for Cleaning Crew and Appreciation Event 101 41940 390 CONTRACTED SERVICES 7,556 6,879 2,765 3,500 2,900 See Detailed Attachment TOTAL - SERVICES & OTHER CHARGES 20,334 17,712 10,386 15,097 18,849 101 41940 501 EQUIPMENT - - - - 3,000 60 New Chairs for Council Chambers TOTAL - CAPITAL OUTLAY - - 3,000 DEPARTMENT TOTAL $ 26,968 $ 21,980 $ 18,711 $ 33,877 $ 32,149 Change ($) (1,728) Change (%) -5.10% In 2015 revenues were $5,233. Seven volunteer groups were able to access the building for approximately 80 hours total and gave back over 1,000 hours of Prairie Center Revenues (101-34750) 2,685 5,233 2,081 5,000 5,000 volunteer time. City of Otsego General Fund Budget -2017 Detail of Line Item Requests Prairie Center a Requested Budget Budget Account No. & Description 2016 2017 Item Detail / Description Comment 101-41940-390 $ 400 CONTRACTED SERVICES 450 2,400 250 3,500 $ 400 Pest Control 800 Burglary & Fire Alarm Monitoring ($36.45 + $27.95 Monthly... Rounded) - Council Chamber A/V Repairs & Service 250 Fire Extinguisher Service 500 Carpet Cleaning 150 Window Cleaning 800 lContingency - Unidentified services at Prairie Center 2,900 City 0f Otsego General Fund Budget - 2017 Department Requests 41945 - City Hall & Public Works Building Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 101 41945 201 OFFICE SUPPLIES AND EXPENSES $ 34 $ $ $ - $ 101 41945 202 FUEL - 1,000 101 41945 206 POSTAGE - 1,851 - 4,000 101 41945 210 OPERATING SUPPLIES 2,277 5,828 2,108 2,750 4,800 101 41945 220 REPAIR/MAINTSUPPLY 5,409 3,831 2,375 4,000 4,000 TOTAL -SUPPLIES 7,720 9,659 6,334 7,750 12,800 101 41945 320 TELEPHONE 101 41945 322 UTILITIES 101 41945 325 GARBAGE SERVICE 101 41945 361 LIABILITY AND PROPERTY INS 101 41945 389 CLEANING SERVICES 101 41945 390 CONTRACTED SERVICES 101 41945 410 RENTALS TOTAL - SERVICES & OTHER CHARGES 101 41945 501 EQUIPMENT TOTAL - CAPITAL OUTLAY DEPARTMENT TOTAL Comments Coffee & Water / Cleaning & Restroom Products / Building Supplies General building repairs and maintenance. 1,954 2,178 4,055 3,500 7,400 Centuryl-ink (Fax) & Consolidated Communications (Phones) - $615 Monthly 29,577 28,129 14,657 31,000 31,000 Natuaral Gas (Centerpoint) & Electric (Wright Hennepin) 3,393 2,541 1,865 5,000 4,000 Randy's Environmental Services (12 Months at $340) 8,216 7,718 8,676 6,786 12,441 Estimate - 5% Increase from 2015-2016 Actual Premiums 11,316 9,075 6,750 11,315 11,415 See Detailed Attachment 20,091 18,478 4,192 17,000 16,300 See Detailed Attachment - - 9,027 - 14,300 See Detailed Attachment 74,547 68,120 49,222 74,601 96,856 2,815 2,815 2,815 2,815 $ 82,267 $ 80,594 $ 58,371 $ 82,351 $ 109,656 Change ($) 27,305 Change (%) 33.16% City of Otsego General Fund Budget - 2017 Detail of Line Item Requests City Hall & PW Building Budget Account No. & Description 2016 101-41945-389 $ 9,900 CLEANING SERVICES 813 352 250 11,325 101-41945-390 $ 17,000 CONTRACTED SERVICES - 101-41945-410 $ RENTALS Requested Budget 2017 Item Detail / Description Comment $ - Lump Sum (Adjusted Budget to Reflect PY Actuals) 800 Burglary & Fire Alarm Monitoring ($36.45 + $27.95 Monthly... Rounded) 800 Elevator Service Contract 500 Pest Control 400 Septic Tank Pumping 1,000 Fire Sprinkler Inspection Services 1,000 1 Nova Communications - Phone System Support 11,800 lContingency - HVAC / Electrical / Other Unidentified Services 17,000 16,300 $ 3,780 Lease - Wide Format Printer #6700 (Building Department) 3,000 Lease - Color Copier/Printer #4503 (Administration) 1,092 Lease - B&W Copier/Printer #3353 (Reception) 1,660 Lease - Postage Machine 4,768 Maintenance Agreement+ Cost of Print/Copy Overages 14,300 City of Otsego General Fund Budget - 2017 Department Requests 41950 - Old Town Hall Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 41950 322 UTILITIES $ 486 $ 695 $ 583 $ 500 $ 1,440 Natuaral Gas (Centerpoint) & Electric (Elk River Utilities) - $120 Monthly 101 41950 390 CONTRACTED SERVICES 541 - - - - TOTAL - SERVICES & OTHER CHARGES 1,027 695 583 500 1,440 DEPARTMENT TOTAL $ 1,027 $ 695 $ 583 $ 500 $ 1,440 Change ($) 940 Change (%) 188.00% City of Otsego General Fund Budget - 2017 Department Requests 42100 - Police Services Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 42100 310 MISCELLANEOUS $ - $ - $ - $ - $ 6,000 Remit court fines back to Wright County ($500 Monthly - Same as Revenue) 101 42100 390 CONTRACTED SERVICES 912,365 952,546 576,914 978,200 1,014,700 Contract through 2017 - $69.50 at 40 Hours Daily (3.7% Increase) TOTAL - SERVICES & OTHER CHARGES 912,365 952,546 576,914 978,200 1,020,700 DEPARTMENT TOTAL $ 912,365 $ 952,546 $ 576,914 $ 978,200 $ 1,020,700 Change ($) 42,500 Change (%) 4.34% City of Otsego General Fund Budget - 2017 Department Requests P 42150 - Public Safety Commission Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 421SO 104 PART-TIME EMPLOYEES REGULAR $ 510 $ - $ - $ 750 $ 750 TOTAL - PERSONAL SERVICES 510 - - 750 750 101 42150 210 OPERATING SUPPLIES 95 137 - 600 600 TOTAL - SUPPLIES 101 42150 360 EDUCATION/TRAINING/CONFERENCES TOTAL - SERVICES & OTHER CHARGES DEPARTMENT TOTAL 95 137 - 600 600 - - - 1,500 1,500 - - - 1,500 1,500 $ 605 $ 137 $ - $ 2,850 $ 2,850 Change ($) - Change (%) 0.00% Event Registration for 2 Commissioners City of Otsego General Fund Budget - 2017 Department Requests 42200 - Fire Protection Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 101 42200 208 MEETING SUPPLIES $ - $ 86 $ - $ - $ 500 TOTAL -SUPPLIES 86 500 101 42200 390 CONTRACTED SERVICES 377,926 455,281 367,961 497,462 526,765 101 42200 441 LICENSES, TAXES & FEES - - 218 - 225 TOTAL -SERVICES & OTHER CHARGES 377,926 455,281 368,179 497,462 526,990 DEPARTMENT TOTAL $ 377,926 $ 455,367 $ 368,179 $ 497,462 $ 527,490 Change ($) 30,028 Change (%) 6.041 Comments Fire Department Recognition Events See below Property Taxes - Fire Station Property Albertville $ 160,531 $ 225,710 $ 126,653 $ 253,304 $ 272,616 Department Budget Increased 1.6%- Otsego Share Increased 2.4% Elk River 190,460 202,918 212,686 215,095 224,668 $60.59 Per Parcel (2016 = 3,510 / 2017 Estimated at 3,600) + 3% Inflation Rogers 26,679 26,421 28,622 29,063 29,481 3% Increase on Contract ($28,622) Wright County -Property Taxes 256 232 218 - 225 Total 377,926 455,281 368,179 497,462 526,990 Difference (0) (0) 0 - - City of Otsego General Fund Budget - 2017 Department Requests 42410 - Building Inspection Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 101 42410 101 FULL-TIME EMPLOYEES REGULAR $ 49,006 $ 51,226 $ 29,525 $ 52,107 $ 54,309 101 42410 102 OVERTIME 124 193 - - - 101 42410 104 PART-TIME - EMPLOYEES REGULAR - 528 6,918 16,877 19,129 101 42410 106 TEMP EMPLOYEE WAGES - 2,603 - - - 101 42410 121 PERA 3,543 4,162 2,704 5,174 5,508 101 42410 122 FICA AND MEDICARE 3,512 3,812 2,455 5,277 5,618 101 42410 123 HEALTH 11,120 - - - - 101 42410 130 OTHER EMPLOYER PAID INS 523 7,915 9,374 8,364 11,277 101 42410 150 WORKERS COMPENSATION 464 446 1,114 694 462 TOTAL - PERSONAL SERVICES 68,292 70,886 52,089 88,493 96,303 101 42410 201 OFFICE SUPPLIES AND EXPENSES 1,269 2,729 1,299 2,200 3,000 101 42410 202 FUEL - 2,062 - 4,500 3,000 TOTAL -SUPPLIES 1,269 4,791 1,299 6,700 61000 101 42410 302 ENGINEERING FEES 5,479 4,673 5,048 4,000 12,500 101 42410 303 PLANNING FEES 1,240 2,163 - 5,000 4,000 101 42410 309 IT -SOFTWARE LICENSE - - 2,090 - 2,200 101 42410 311 GRADING REVIEWS - 22,489 3,101 - 18,750 101 42410 320 TELEPHONE 1,562 1,579 (0) 2,000 - 101 42410 321 MILEAGE/TRAVEL 269 - 41 - 400 101 42410 336 ASSESSOR FEE -NEW CONSTRUCTION - 5,000 - 10,000 - 101 42410 338 REIMBURSABLE COSTS 1,050 1,250 3,300 - - 101 42410 350 PRINT&PUBLISHING 261 572 247 - 500 101 42410 355 DUES & MEMBERSHIPS 125 300 135 275 350 101 42410 360 EDUCATION/TRAINING/CONFERENCES 461 1,247 77 250 900 101 42410 361 LIABILITY & PROPERTY INSURANCE 290 350 956 800 1,371 101 42410 390 CONTRACTED SERVICES 101,329 125,625 72,725 124,800 144,000 101 42410 410 RENTALS 7,565 3,197 - 4,270 - TOTAL - SERVICES & OTHER CHARGES 119,631 168,445 87,719 151,395 184,971 101 42410 501 EQUIPMENT 1,104 - - 4,000 - TOTAL -CAPITAL OUTLAY 1,104 - - 4,000 - DEPARTMENT TOTAL $ 190,295 $ 244,122 $ 141,108 $ 250,588 $ 287,274 Change ($) 36,686 Change (%) 14.64% Comments Ink Cartridges / Plan Review Stamps / General Office Supplies Allocated at Year -End Based on Percentage of Gallons Used Engineering Review of Building Permits (Per Ron 5-26-2016) Planning Review of Building Permits Annual License & Support - PermitWorks Software 150 Permits at $125 Each (Previously Netted with Revenue) 2016 Actual and 2017 Budget - Now in City Hall Department (41945) MBPTA Meetings 2016 Actual and 2017 Budget - Now in Assessor's Department (41550) Code Books / Septic System Owners Guide See Detailed Attachment See Detailed Attachment Estimate - 5% Increase from 2015-2016 Actual Premiums Metro West Inspections ($12,000 Monthly = 2,880 Hours =1.38 FTE) 2016 Actual and 2017 Budget - Now in City Hall Department (41945) City of Otsego General Fund Budget -2017 Detail of Line Item Requests Building Inspections Y Requested Budget Budget Account No. & Description 2016 2017 Item Detail / Description Comment 101-42410-355 $ 275 DUES & MEMBERSHIPS - 275 101-42410-360 $ 250 EDUCATION /TRAINING / CONFERENCE - 250 - Lump Sum Budget Amount 150 International Code Council Membership 100 International Code Council Licensure (Ba 100 Minnesota Building Permit Technician A 350 - Lump Sum Budget Amount 111 Minnesota Municiapl Utilities Association - Citywide Safety Training 150 Minnesota Building Permit Technician Association Fall Conference 200 Minnesota Building Officials Conference (Spring & Fall) 350 International Code Council Conference 89 Contingency - New Events or Sources of Training 900 City of Otsego General Fund Budget - 2017 Department Requests 42500 - Emergency Management Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 42500 210 OPERATING SUPPLIES $ - $ - $ - $ 1,500 $ - TOTAL - SUPPLIES - - - 1,500 - 101 42500 322 UTILITIES 309 400 263 400 420 Electricity for Emergency Sirens 101 42500 360 EDUCATION/TRAINING/CONFERENCES - - - 2,500 1,500 NIMS / Other Emergency Related Training 101 42500 390 CONTRACTED SERVICES - - - 2,500 - TOTAL - SERVICES & OTHER CHARGES 309 400 263 5,400 1,920 101 42500 500 CAPITAL OUTLAY (GENERAL) - 2,478 7,473 7,500 8,000 Three SOOmhz Radios - Will get City to desired quantity of 10 radios. TOTAL - CAPITAL OUTLAY - 2,478 7,473 7,500 81000 DEPARTMENT TOTAL $ 309 $ 2,878 $ 7,736 $ 14,400 $ 9,920 Change ($) (4,480) Change (%) -31.11% City of Otsego General Fund Budget - 2017 Department Requests 42710 - Animal Control Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 42710 390 CONTRACTED SERVICES $ 14,610 $ 11,460 $ 4,560 $ 13,500 $ 14,400 Stray animal pickups & boarding ($1,200 Monthly) TOTAL -SERVICES & OTHER CHARGES 14,610 11,460 4,560 13,500 14,400 DEPARTMENT TOTAL $ 14,610 $ 11,460 $ 4,560 $ 13,500 $ 14,400 Change ($) 900 Change (%) 6.67% City of Otsego General Fund Budget - 2017 Department Requests 43100 - Streets Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 43100 101 FULL-TIME EMPLOYEES REGULAR $ 262,684 $ 262,982 $ 151,800 $ 307,505 $ 324,906 101 43100 102 FULL-TIME - OVERTIME 9,596 1,171 723 8,000 8,000 101 43100 104 PART-TIME - EMPLOYEES REGULAR 55,115 57,101 9,583 21,542 24,480 101 43100 121 PERA 22,742 20,443 11,370 23,663 24,968 101 43100 122 FICA AND MEDICARE 23,587 23,329 11,710 25,784 27,340 101 43100 123 HEALTH 25,171 - - - - 101 43100 130 OTHER EMPLOYER PAID INS 2,533 26,237 24,575 42,500 38,616 101 43100 140 UNEMPLOYMENT COMP 150 928 84 - - 101 43100 150 WORKERS COMPENSATION 21,900 18,773 12,348 21,447 30,039 TOTAL - PERSONAL SERVICES 423,480 410,964 222,193 450,441 478,349 101 43100 201 OFFICE SUPPLIES AND EXPENSES 1,148 1,227 634 300 1,339 101 43100 210 OPERATING SUPPLIES 3,828 6,097 2,329 3,800 3,950 101 43100 220 REPAIR/MAINTSUPPLY 2,966 5,522 8,351 10,845 19,165 101 43100 225 UNIFORMS/CLOTHING ALLOWANCE 3,573 2,906 1,821 4,420 4,150 101 43100 227 SAFETY SUPPLIES 2,041 2,547 2,308 2,275 2,450 101 43100 234 BLACKTOP SUPPLIES 12,431 16,667 4,950 15,900 17,950 101 43100 240 SMALL TOOLS/EQUIPMENT 8,816 9,643 10,000 10,000 6,350 101 43100 270 SAND AND GRAVEL 11,958 19,609 20,091 24,683 24,239 101 43100 272 SALT AND SAND 56,896 72,644 16,281 79,044 81,716 101 43100 293 SIGN/SIGNAL MATERIAL PURCHASED 21,345 17,689 10,524 8,456 10,112 101 43100 295 SIGN/SIGNAL REIMBURSEMENT 903 (1,050) - - - TOTAL - SUPPLIES 125,903 153,503 77,288 159,723 171,421 101 43100 301 LEGAL SERVICES 87 - - - - 101 43100 302 ENGINEERING FEES 6,561 - - - - 101 43100 320 TELEPHONE 6,301 6,370 2,239 6,992 6,000 101 43100 322 UTILITIES 560 990 736 1,200 1,200 101 43100 325 GARBAGE SERVICE 129 19 790 1,150 1,450 101 43100 350 PRINT&PUBLISHING 1,172 545 - - 500 101 43100 355 DUES & MEMBERSHIPS 144 237 193 250 254 101 43100 360 EDUCATION/TRAINING/CONFERENCES 2,668 6,317 5,501 8,805 9,445 101 43100 361 LIABILITY AND PROPERTY INSURAN 30,702 20,417 9,385 30,159 13,458 101 43100 390 CONTRACTED SERVICES 4,461 9,518 3,884 9,357 16,370 101 43100 410 RENTALS 2,283 5,614 1,670 6,750 12,650 101 43100 436 DUSTCOATING 14,886 15,613 13,206 14,854 16,229 TOTAL - SERVICES & OTHER CHARGES 69,954 65,640 37,604 79,517 77,556 101 43100 501 EQUIPMENT 928 - - - - TOTAL - CAPITAL OUTLAY 928 - - DEPARTMENT TOTAL $ 620,265 $ 630,107 $ 337,085 $ 689,681 $ 727,326 Change ($) 37,645 Change (%) 5.46% See Detailed Attachment See Detailed Attachment See Detailed Attachment See Detailed Attachment See Detailed Attachment See Detailed Attachment See Detailed Attachment See Detailed Attachment See Detailed Attachment See Detailed Attachment Cell Phones ($55 x 6) + PAD ($35 x 2) + Replacement Phones ($1,200) See Detailed Attachment See Detailed Attachment See Detailed Attachment See Detailed Attachment See Detailed Attachment Estimate - 5% Increase from 2015-2016 Actual Premiums See Detailed Attachment See Detailed Attachment See Detailed Attachment City of Otsego General Fund Budget - 2017 Detail of Line Item Requests Streets r Budget Account No. & Description 2016 OFFICE 1 SUPPLIES 0-201 OFFICE SUPPLIES 300 300 101-43100-210 $ 1,200 OPERATING SUPPLIES 300 1,000 600 300 400 3,800 101-43100-220 $ 800 REPAIR/MAINT SUPPLIES 600 500 300 620 200 200 200 400 7,025 10,845 $ 2,400 101-43100-225 UNIFORMS/CLOTHING ALLOWANCE 900 480 640 4,420 101-43100-227 $ 500 SAFETY SUPPLIES 450 200 250 100 200 200 375 2,275 $ 500 101-43100-234 BLACKTOP SUPPLIES 1,200 14,200 15,900 Requested Budget 2017 Item Detail / Description Comment $ 1,168 1 Background checks and drug testing (Seasonals) Misc. office supplies. This also includes pre -employment drug and backgound checks for $ 1,200 Herbicide Operating supplies are needed for Street Department functions including spraying, snow 300 Lath/Fiberglass Markers removal operations marking, vehicle cleaning and other department functions. Amounts are 700 Acetylene/Torch Supplies based on prior history and department usage and service levels. 1,050 Pressure Washer Detergent 300 Road Clean-up Supplies 400 Misc. 3,950 500 Grass Seed 375 Erosion Control Blanket and Stakes 500 Lumber for Misc. repairs: Sidewalks, Mailboxes 500 Hardware for Mailbox repairs 310 Screened Topsoil 200 Straw for turf establishment/erosioncontrol 200 Irrigation Supplies for facilities and plow damaf 200 Sidewalk mix/patch 000 Manhole/catch basin/lid repairs 300 Propane for patching 500 Rock for repairs: Stormwater or gravel 200 Misc. 380 Public Works shop lights replacements 44 @ $3 165 pairs would be applicable to Street Department functions for storm water, streets, facilities 1 ROW maintenance. Amounts are based on prior usage and trends. In 2016, staff replaced lights in the Public Works facility and was directed to place the replacement of the paining fixtures in the 2017 budget for replacement. The City received a rebate from ight Hennepin for the 2016 replacements in the amount of $1,496, and it is possible the L7 replacements would also qualify for a rebate. $ 2,400 1 Uniform allowance for six full-time employees Clothing allowances for six full time employees, one winter seasonal employee and four 900 Boot allowance for six full-time employees summer seasonal employees. A decrease was shown here with staff only recommending 170 1winter seasonal uniform allowance assistance of one winter seasonal employee versus three in the past. 680 Summer seasonal uniform allowance $ 500 Cones/Barricades Used for the purchase of required safety gear. 450 Safety Vests 200 Hearing protection 200 Eye protection 100 Specialty signage/ ostings 200 Hard hats/face shields 200 Harness replacements 600 Reflectivejackets 2,450 500 lCold mix Anticipate the additional need to patch rural sections of streets and more full -depth patching. 150 ITack oil 2015 tonnage put down was 110 ton and I anticipate that nearly doubling. There is a lot of mix, fine and 1/2" mix, rubber in 2016, not 2017 City of Otsego General Fund Budget - 2017 Detail of Line Item Requests Streets r 101-43100-240 $ 7,000 SMALL TOOLS & EQUIPMENT 500 1,500 1,000 10,000 101-43100-270 $ 3,605 16,496 SAND AND GRAVEL 4,582 24,683 101-43100-272 $ 29,524 SALT AND SAND 45,100 700 3,720 79,044 101-43100-293 $ SIGN/SIGNAL MATERIALS - 500 978 633 1,000 2,500 2,000 845 8,456 $ 1200, 101-43100-322 UTILITIES - 1,200 $ 150 101-43100-325 GARBAGE SERVICE 200 150 500 150 1,150 200 Landscaping 3-point rake for 2017, shouldering disc 500 Blacktopping Tools 600 Chainsaw 750 Chop saw blades 600 Backpack blower for 2017, two way radios for 2016 200 Trash pump & hoses 1,000 UUU MISC. Kepalrs ana �.nouiaering l,000 Ion 989 62nd Street, 2016 2.25" Rating, needs appx. 123.58 ton 989 67th Street, 2016 2.41" Rating, needs appx. 123.58 ton 186 Cty. 39 Svc. Rd., 2016 2.25" Rating, needs appx. 148.29ton 034 O'brian/Oday/96th Street, 2016 2" Rating, needs appx. - 254.22 ton. 084 Jaber Ave., 2016 2.94" Rating, needs appx. 635.55 ton 034 Odean Ave. 2016 3.1" Rating, needs appx. 254.22 ton 923 62nd/Quale. 2016 3.54" Ratine. needs aoox. 490.38 ton SU,lbb 4UU Ion regular roaa salt esumatea 47,130 500 Ton treated road salt estimated 700 100 Ton sand @ $7/ton 3.720 Ice melt additives: 8 totes @ 5465A 950 Sign Cad Annual Maintenance- Sign DE 125 Sign Trak Annual Maintenance- Sign In 250 Traffic signal bulbs 675 (50) 8' U-Channel galvanized @ $13.5C 012 (50) 12' Round Posts @ $20.25 000 Hardware: brackets, fineals, bolts, etc. 300 lFilm (4) @ $575 000 ISign blanks (200) @ $10 800 1 Concrete 200 bags @ $4 service for the old shop/school house s that are used routinely in department operations that need to be replaced or added to ntory. I length gravel additions have not been done to these streets and staff is recommending ling a full 4" of new gravel to these sections to strenghten them. Each section is below the iimum standard that we would like to maintain. Staff has estimated approximately 29.82 ton of gravel that will need to be added in 2017 at an estimated price of $8/ton ich gives us a $24,239 total. removal operations has consistently used this amount of salt. With new streets being I we must continue to budget for this amount of salt. Staff is continuing to use new )CIS to make salt application more efficient and environmentally mindful. Hopefully new vast majority of the sign replacement has been completed. We are into more of a ntenance trend with signs. We have continued to see costs for materials and new =lopments being added which needs to have maintenance costs reflected. rily electrical service for the old shop. Recommend no change with the building rily being used for cold and seasonal storage and electrical draw is for battery $ 150 Fluorescent Lights Used for the disposal of commonplace items that are typically retreived on road side clean-up 400 Appliance Recycling or to recycle items such as tires, bulbs, appliances. 150 E-scrap 600 Roadside Debris/Waste Management 150 Tires 1,450 City of Otsego General Fund Budget - 2017 Detail of Line Item Requests Streets r 101-43100-350 $ PRINT & PUBLISHING 101-43100-355 $ 50 DUES & MEMBERSHIPS 20 180 250 $ 240 101-43100-360 EDUCATION / TRAINING / CONFERENCE 175 7,400 950 40 8,805 $ 350 101-43100-390 CONTRACTED SERVICES - 565 375 20 400 2,000 3,000 500 2 147 9,357 101-43100-410 $ 750 RENTALS 6,000 6,750 $ 14,854 101-43100-436 DUSTCOATI NG - 14,854 open 20 IN Dept. of Labor (Boilers 184 APWA cards. I Based on past history. Primarily used for advertising openings. Also used for business cards. ps and dues for related associations that staff participates in. 240 ATSSA for 2 employees Primary expense is for the safety training provided by MMUA. This also includes sending two 175 St. Cloud Fall Maintenance Expo employees to be educated for the sign updates. Additional specialty training for employees 7,500 MMUA (Allocation of $7,236 + Extra Events) on an individual basis. Need to send all employees to additional salt application training and 1,410 LTAP Courses: Pavement Mngt., Stormwater, Salting seminars. 120 MN Loss Control Workshop 9,445 600 1Fire Extinguisher Maintenance- Dehmers 7Cn \A/rin0.r rni in IT- 4nn nnue ro 4in mn i- 600 Fuel Island Inspection 20 MN DOLT Annual boiler inspections 500 Pressure Washer Service- Hotsy 000 Off -site light service, Kirsch Electric 000 Concrete Repairs, cross gutters, cross 800 Two-way radio service 500 Garage Door service/maintenance - Lump Sum - No Detail ntracted services for specialty services that are necessary for department functions. The ijority of these services are required and need to be performed by trained professionals. 1,250 Asphalt Mill 5 days @ $250/day Rentals to perform street related functions. The mill is in preparation for fog/seal coat 400 Crane for lights replacement in 2017, mastic rental for 2016 application. Crane for lights replacement in public works building. The tracked skid would be 1,200 Track skid loader rental for storm water work used in storm water pond maintenance to remove debris/brush. If approved, the roller renti 4,800 Blacktop roller if not approved in CIP would not be utilized as the purchase would fill this need. 5,000 Chipper Rental 12,650 $ 16,229 Dust contol to same streets both public and private Staff saw increases of 9% in pricing for 2016 when prices were quoted and we anticipate the same increass for 2017. City of Otsego General Fund Budget - 2017 Department Requests 43150 - Engineering Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 43150 210 OPERATING SUPPLIES $ 217 $ - $- TOTAL - SUPPLIES 217 - - - - 101 43150 302 ENGINEERING FEES 70,224 121,109 29,792 85,000 86,400 Based on 2016 YTD Monthly Average + 20% Contingency 101 43150 315 GIS SERVICES - 965 - - - 101 43150 348 UTILITY LOCATES 22,652 - - - - TOTAL - SERVICES & OTHER CHARGES 92,876 122,074 29,792 85,000 86,400 DEPARTMENT TOTAL $ 93,093 $ 122,074 $ 29,792 $ 85,000 $ 86,400 Change ($) 1,400 Change (%) 1.65% City of Otsego General Fund Budget - 2017 Department Requests 43160 - Street Lights Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 43160 322 UTILITIES $ 111,465 $ 108,987 $ 56,975 $ 115,968 $ 117,000 Based on PY Actuals + Inflation = Estimated at $9,750 per month TOTAL - SERVICES & OTHER CHARGES 111,465 108,987 56,975 115,968 117,000 DEPARTMENT TOTAL $ 111,465 $ 108,987 $ 56,975 $ 115,968 $ 117,000 Change ($) 1,032 Change (%) 0.89% City of Otsego General Fund Budget - 2017 Department Requests 43240 - Fleet Management Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 101 43240 101 FULL-TIME EMPLOYEES REGULAR $ 51,897 $ 57,034 $ 29,336 $ 55,756 $ 61,048 101 43240 102 OVERTIME 1,399 - - - - 101 43240 121 PERA 3,864 4,435 2,211 4,182 4,579 101 43240 122 FICA AND MEDICARE 3,755 4,041 2,071 4,265 4,670 101 43240 123 HEALTH 8,564 - - - - 101 43240 130 OTHER EMPLOYER PAID INS 424 9,668 7,162 10,313 11,307 101 43240 150 WORKERS COMPENSATION 1,356 1,695 1,083 1,861 2,056 TOTAL - PERSONAL SERVICES 71,259 76,873 41,863 76,377 83,660 101 43240 202 FUEL 66,285 38,031 18,070 60,000 60,630 101 43240 210 OPERATING SUPPLIES 22,058 22,405 14,124 28,076 28,852 101 43240 220 REPAIR/MAINTSUPPLY 17,789 21,486 12,026 22,000 23,000 101 43240 225 UNIFORMS/CLOTHING ALLOWANCE 872 3,856 2,072 1,250 1,500 101 43240 227 SAFTEY SUPPLIES 194 - - - - 101 43240 240 SMALL TOOLS/EQUIPMENT 2,872 2,561 6,595 8,500 4,500 101 43240 298 W/S FLEET EXPENSES - (2,327) - - - TOTAL - SUPPLIES 110,069 86,012 52,887 119,826 118,482 101 43240 320 TELEPHONE - 155 309 - 860 101 43240 360 EDUCATION/TRAINING/CONFERENCES 513 750 345 1,100 1,100 101 43240 361 LIABILITY AND PROPERTY INS 2,580 5,732 - 2,000 - 101 43240 390 CONTRACTED SERVICES 5,691 3,836 575 9,000 9,000 TOTAL - SERVICES & OTHER CHARGES 8,783 10,473 1,228 12,100 10,960 DEPARTMENT TOTAL $ 190,111 $ 173,358 $ 95,978 $ 208,303 $ 213,102 Change ($) 4,799 Change (%) 2.30% Comments See Detailed Attachment See Detailed Attachment See Detailed Attachment See Detailed Attachment See Detailed Attachment Cell Phones ($55 x 1) + Replacement Phones ($200) City of Otsego General Fund Budget - 2017 Detail of Line Item Requests Fleet Management Requested Budget Budget Account No. & Description 2016 2017 Item Detail / Description Comment 101-43240-202 $ 60,000 FUEL 60,000 $ 320 101-43240-210 OPERATING SUPPLIES 7,500 2,475 1,000 9,881 6,900 28,076 $ 22,000 101-43240-220 REPAIR/MAINT SUPPLIES - 22,000 $ 750 101-43240-225 UNIFORMS/CLOTHING ALLOWANCE 500 1,250 101-43240-240 $ 1,000 SMALL TOOLS & EQUIPMENT 6,000 1,500 8,500 $ 800 101-43240-360 Education/Training 100 200 1,100 101-43240-390 $ Contracted Services 1,000 3,000 5,000 9,000 i 384 License Tabs: 24 vehicles @ $16/ea. This includes necessary supplies to keep fleet running and are essential to keep both inventorie 7,500 Oil: Hydraulic, 10-30, 15-40, Grease and funded. Without these supplies, the equipment is not able to function. 2,925 Brooms: Main/Gutter brooms for sweeper 1,250 Filters 11,693 Cutting Edges 5,100 Tires: #'s 10, 38, 50, 52, 39 28,852 i fleet operable and are Staff has reviewed historical data, and based on the past history, we have seen the amount of are unanticipated. repairs steadily increasing. 2014 total repairs of $17,789, 2015 repairs of $22,405 and $22,000 budgeted for 2016, staff recommends increasing this line item by $1000. 1 $ 750 JUniform/Boot Allowance Anticipate G&K uniform cancellation in end of 2016 and will not have contracted uniform 750 Rags for shop cprvirp staff will mirrhacp/tpnH unifnrmc and still have rap cprvirp i 1,000 Socket Upgrades Includes specialty tools for fleet department duties. Includes replacement of heavily used 2,500 Plasma Cutter for 2017, tire machine in 2016 sockets and purchase of new tools for department. Plasma cutter would be extremely useful it 1,000 Specialty tools: Lug Crimper, Cable Cutter, Angle Grinder the fab bay in addition to cutting torch/contractingtorch/contracting cutting. 4,500 i 800 MMUA (Allocation of $495 + Extra Events) Fleet portion of the MMUA safety program, specialty training for other employees to operate 100 DOT inspection certification Tatems fleet software. 200 Tatems training 1,100 1,500 1 Radio Service for 2017, tire changes in 2016 IThese are specific services that staff can not perform in house but we routinely use and rely on. 1,000 IDiagnostics Major repairs have not been needed in a couple of years but one transmission, engine or 1,500 JHydraulic repairs hydraulic failure could eat up this entire budget and then some. City of Otsego General Fund Budget - 2017 Department Requests 45200 - Park Maintenance Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 45200 101 FULL-TIME EMPLOYEES REGULAR $ 83,982 $ 85,087 $ 55,790 $ 131,089 $ 136,190 101 45200 102 OVERTIME 4,029 984 492 - 1,000 101 45200 104 PART-TIME - EMPLOYEES REGULAR 31,327 37,375 11,194 28,015 29,146 101 45200 121 PERA 6,473 7,190 4,329 9,832 10,289 101 45200 122 FICA AND MEDICARE 8,385 9,228 5,097 12,172 12,725 101 45200 123 HEALTH 383 - - - - 101 45200 130 OTHER EMPLOYER PAID INS 630 2,941 2,834 11,754 10,515 101 45200 150 WORKERS COMPENSATION 2,544 2,858 1,042 2,912 8,054 TOTAL - PERSONAL SERVICES 137,751 145,662 80,778 195,774 207,919 101 45200 201 OFFICE SUPPLIES AND EXPENSES 412 1,929 654 2,000 2,000 101 45200 210 OPERATING SUPPLIES 28,006 35,067 30,010 43,800 43,800 101 45200 220 REPAIR/MAINTSUPPLY 10,287 12,758 4,220 17,500 23,500 101 45200 225 UNIFORMS/CLOTHING ALLOWANCE 1,099 1,501 1,287 2,800 1,850 101 45200 227 SAFETY SUPPLIES 771 608 918 1,500 1,000 101 45200 240 SMALL TOOLS/EQUIPMENT 2,958 4,200 4,524 9,000 5,000 TOTAL - SUPPLIES 43,532 56,062 41,613 76,600 77,150 101 45200 302 ENGINEERING FEES 448 - - - - 101 45200 320 TELEPHONE 4,826 4,767 1,300 4,900 3,000 101 45200 322 UTILITIES 21,246 27,882 13,650 29,100 30,000 101 45200 325 GARBAGE SERVICE 1,509 3,113 15 1,600 - 101 45200 355 DUES & MEMBERSHIPS - 165 139 800 800 101 45200 360 EDUCATION/TRAINING/CONFERENCES 2,305 2,444 1,907 5,300 5,040 101 45200 361 LIABILITY AND PROPERTY INSURAN 46,283 36,237 29,066 38,232 41,679 101 45200 390 CONTRACTED SERVICES 35,215 39,277 10,909 27,500 23,500 101 45200 410 RENTALS 95 - - 2,000 2,000 TOTAL - SERVICES & OTHER CHARGES 111,926 113,886 56,985 109,432 106,019 101 45200 501 Equipment TOTAL - CAPITAL OUTLAY DEPARTMENT TOTAL Shelter Rental Revenues(101-34710) Tournament Revenues(101-34733) Sport Field Use Revenues (101-34740) 11,240 11,240 $ 293,209 $ 326,850 $ 179,376 $ 381,806 $ 391,088 Change ($) 9,282 Change (%) 2.43% 4,247 2,435 2,452 2,500 4,500 2,046 1,583 3,398 - 2,000 - 3,315 1,200 4,000 4,000 Drug Testing / Background Checks / Job Openings See Detailed Attachment See Detailed Attachment See Detailed Attachment Hand Tools/Weed Whips/Backpack Blowers/Power Tools/Etc. Cell Phones ($55 x 3) + IPAD ($35 x 1) + Replacement Phones ($600) Garbage coded to City Hall (41945) & Prairie Center (41940) MN Parks & Rec Assoc / MN Nursery & Landscape Assoc. See Detailed Attachment Estimate - 5% Increase from 2015-2016 Actual Premiums See Detailed Attachment Ditch Diggers / Stump Grinders City of Otsego General Fund Budget -2017 Detail of Line Item Requests V Budget Account No. & Description 2016 101-45200-210 $ 10,000 OPERATING SUPPLIES 2,600 4,200 5,000 5,000 10,000 1,000 3,000 3,000 43,800 $ 1,500 101-45200-220 REPAIR/MAINT SUPPLIES 4,000 6,000 2,000 4,000 17,500 $ 1,500 101-45200-225 UNIFORMS/CLOTHING ALLOWANCE 750 550 2,800 101-45200-360 $ 2,100 EDUCATION/TRAINING/CONFERENCE 1,700 1,500 5,300 101-45200-390 $ 11,000 CONTRACTED SERVICES 14,500 2,000 27,500 Requested Budget 2017 Item Detail / Description Comment $ 10,000 Fertilizer 2,600 Mulch 4,200 Ballfield Paint 5,000 Field Maintenance Supplies (Chalk, Aglime, Bases) 5,000 Playground Woodchips 10,000 Court Repair and Maintenance 1,000 1 Dust Control Soccer Field 3,000 IParking Lot Maintenance 3,000 IMisc. 43,800 $ 1,500 Dirt & Black Seed 4,000 Irrigation Repair & Maintenance 6,000 Playground Repair & Maintenance 8,000 Splash Pad Repairs To include upgrades to surface andspray 4,000 Misc. Repairs (Shelters. Planters, Fencing) 23,500 1,100 Clothing 2 Fulltime Em to ees@ $400/ 5 Seasonal @ $60 750 Boots (3 Fulltime @ $150/ 5 Seasonal @ $60) - Misc. 1,850 $ 1,940 MMUATraining 1,700 Greens Expo/ Grounds Maintenance Classes 1,400 Certification Classes 5,040 $ 6,000 Herbicide Control 14,500 Port-o-potties 3,000 Misc. 23,500 City of Otsego General Fund Budget - 2017 Department Requests 45250 - Recreation Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 45250 101 FULL-TIME EMPLOYEES REGULAR $ 39,037 $ 42,396 $ 21,799 $ 42,861 $ 45,352 101 45250 104 PART-TIME EMPLOYEES REGULAR 25,969 34,389 23,922 31,073 43,698 101 45250 121 PERA 4,051 4,776 3,065 5,155 6,079 101 45250 122 FICA AND MEDICARE 5,366 5,693 3,378 5,931 6,812 101 45250 123 HEALTH 3,284 - - - - 101 45250 130 OTHER EMPLOYER PAID INS 293 4,996 8,485 10,726 11,859 101 45250 150 WORKERS COMPENSATION 459 438 1,275 650 2,837 TOTAL - PERSONAL SERVICES 78,459 92,688 61,925 96,396 116,637 101 45250 201 OFFICE SUPPLIES AND EXPENSES 500 493 626 - 500 101 45250 210 OPERATING SUPPLIES 3,174 11,822 5,850 12,000 15,000 See Detailed Attachment 101 45250 225 UNIFORMS - 652 238 400 550 See Detailed Attachment TOTAL - SUPPLIES 3,674 12,967 6,715 12,400 16,050 101 45250 320 TELEPHONE 420 401 309 2,300 860 Cell Phones ($55 x 1) + Replacement Phones ($200) 101 45250 350 PRINT & PUBLISHING 2,284 3,965 3,149 6,300 6,300 See Detailed Attachment 101 45250 360 EDUCATION/TRAINING/CONFERENCES - 601 1,134 2,000 2,300 (2) MRPA Annual Conference / (2) MRPA Meetings+ Memberships 101 45250 361 LIABILITY AND PROPERTY INSURAN - 241 660 - 946 Estimate - 5% Increase from 2015-2016 Actual Premiums 101 45250 390 CONTRACTED SERVICES 4,105 10,227 3,327 8,000 10,500 See Detailed Attachment 101 45250 410 RENTALS 120 - - - - 101 45250 440 RECREATION PROGRAMMING 18,282 - - - - 101 45250 445 COMMUNITY EVENTS 29,068 27,903 6,889 24,000 24,000 See Detailed Attachment 101 45250 490 PRAIRIE FESTIVAL - - 475 - 18,050 Costs are paid for with donations and vendor registration fees. 101 45252 440 SUMMER ENTERTAINMENT (PR.05) 2,607 - - - - TOTAL - SERVICES & OTHER CHARGES 56,886 43,338 15,942 42,600 62,956 DEPARTMENT TOTAL $ 139,020 $ 148,993 $ 84,582 $ 151,396 $ 195,643 Change ($) 44,247 Change (%) 29.23% Recreation Fee Revenues (101-34700) 23,845 29,977 19,830 30,000 28,000 City of Otsego General Fund Budget -2017 Detail of Line Item Requests V Budget Account No. & Description 2016 101-45250-210 $ 12,000 OPERATING SUPPLIES - 12,0 00 $ 150 101-45250-225 UNIFORMS/CLOTHING ALLOWANCE 250 400 $ 1,400 101-45250-350 PRINT & PUBLISHING 2,100 2,800 6,300 101-45250-390 $ 4,700 CONTRACTED SERVICES 3,300 8,000 $ 51000 101-45250-445 COMMUNITY EVENTS 2,000 2,000 3,000 5,000 3,000 4,000 24,000 Requested Budget 2017 Item Detail / Description Comment $ 15,000 This pays for programs supplies both free and revenue based. The revenue created by the program fees offsets the program supplies for the non -fee programs. 15,000 $ 300 jAdmin Staff Uniforms 250 lRecreation & Building Assistant Uniforms 550 $ 1,400 Printing of P&R Brochures 2,100 Website & Flyer Design 2,800 Brochure Mailings 6,300 Instructors IThese costs are typically covered by the registration fees. $ 5,000 City's Contribution for Prairie Festival 2,000 Easter Egg Hunt 2,000 Santa Day 3,000 Pumpkin Patch 5,000 Tuesday Entertainment 3,000 Movies 4,000 ISenior Programming 24,000 City of Otsego General Fund Budget - 2017 Department Requests 45300 - Heritage Preservation Commission Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 45300 104 PART-TIME EMPLOYEES REGULAR $ 590 $ 420 $ $ 450 $ 450 TOTAL -PERSONAL SERVICES 590 420 - 450 450 101 45300 201 OFFICE SUPPLIES AND EXPENSES 145 170 416 500 500 TOTAL -SUPPLIES 145 170 416 500 500 101 45300 350 PRINT & PUBLISHING - 95 - - - 101 45300 360 EDUCATION/TRAINING/CONFERENCES 980 916 - 1,500 1,500 Event Registration for 2 Commissioners 101 45300 390 CONTRACTED SERVICES 325 - - - TOTAL - SERVICES & OTHER CHARGES 1,305 1,011 - 1,500 1,500 DEPARTMENT TOTAL $ 2,040 $ 1,601 $ 416 $ 2,450 $ 2,450 Change ($) - Change (%) 0.00% City of Otsego General Fund Budget - 2017 Department Requests P 46530 - Planning Commission Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 46530 104 PART-TIME EMPLOYEES REGULAR $ 710 $ 1,500 $ 10 $ 1,500 $ 2,500 Increase due to more scheduled meetings thus far in 2016. TOTAL - PERSONAL SERVICES 710 1,500 10 1,500 2,500 101 46530 210 OPERATING SUPPLIES 35 24 - - - TOTAL - SUPPLIES 101 46530 360 EDUCATION/TRAINING/CONFERENCES TOTAL - SERVICES & OTHER CHARGES DEPARTMENT TOTAL 35 24 - - - - 200 270 1,500 1,500 - 200 270 1,500 1,500 $ 745 $ 1,724 $ 280 $ 3,000 $ 4,000 Change ($) 1,000 Change(Y) 33.33% Event Registration for 2 Commissioners City of Otsego General Fund Budget - 2017 Department Requests Pr 46570 - Planning Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 46570 303 PLANNING FEES $ 88,340 $ 86,335 $ 37,758 $ 88,000 $ 91,200 Based on 2016 YTD Monthly Average + 20%Contingency TOTAL - SERVICES & OTHER CHARGES 88,340 86,335 37,758 88,000 91,200 DEPARTMENTTOTAL $ 88,340 $ 86,335 $ 37,758 $ 88,000 $ 91,200 Change ($) 3,200 Change (%) 3.64% City of Otsego General Fund Budget - 2017 Department Requests 46580 - Economic Development Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 46580 350 PRINT&PUBLISHING $ 296 $ 0 $ - $ - $ - 101 46580 355 DUES & MEMBERSHIPS 2,799 2,777 3,077 3,300 3,160 See Detailed Attachment 101 46580 360 EDUCATION/TRAINING/CONFERENCES - - 50 500 500 Chamber Groups/ Networking Events 101 46580 380 MARKETING - 4,175 5,240 5,500 6,000 Print & Online Advertising Mechanisms 101 46580 390 CONTRACTED SERVICES 1,000 1,200 - 5,000 5,000 Strategic Planning; Development Consultants; Contracted Studies TOTAL - SERVICES & OTHER CHARGES 4,095 8,152 8,367 14,300 14,660 DEPARTMENT TOTAL $ 4,095 $ 8,152 $ 8,367 $ 14,300 $ 14,660 Change ($) 360 Change (%) 2.52% City of Otsego General Fund Budget -2017 Detail of Line Item Requests Economic Development Y Requested Budget Budget Account No. & Description 2016 2017 Item Detail / Description Comment 101-46580-355 $ 21500 $ 2,600 Wright County Economic Development Partnership DUES & MEMBERSHIPS 300 300 1-94 West Chamber of Commerce 2S0 260 Initiative Foundation 250 - EDAM 3,300 3,160 City of Otsego General Fund Budget - 2017 Department Requests 49300 - Interfund Transfers Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Object Account Description 2014 2015 2016 2016 2017 Comments 101 49300 720 OPERATING TRANSFERS $ 86,411 $ 1,289,914 $ 460,212 $ 127,590 $ 129,105 100%Transfer of LGA into Capital Fund of Council's Discretion TOTAL - INTERFUND TRANSFERS 86,411 1,289,914 460,212 127,590 129,105 DEPARTMENT TOTAL $ 86,411 $ 1,289,914 $ 460,212 $ 127,590 $ 129,105 Change ($) 1,515 Change (%) 1.19%