Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Agenda Packets - 2017/06/05
CITY OF MOUNDS VIEW CITY COUNCIL WORK SESSION AGENDA MOUNDS VIEW CITY HALL Monday, June 5, 2017 6:00 p.m. ROLL CALL: Mueller, Gunn, Hull, Meehlhause, Bergeron PUBLIC COMMENT Citizens may speak to issues not on tonight’s agenda. Before speaking, please give your full name and address for the minutes. Also, please limit your comments to three minutes. Agenda Items Discussed by Consensus 1. Review SBM Fire Department Strategic Plan 2. Discuss County Road H Roundabout Monument 3. Twin Cities Gateway Grant 4. Review 2018 Draft General Fund Budget Next Work Session: Monday, July 17, 2017, at 6 p.m. Next City Council Meeting: Monday, June 12, 2017, at 6 p.m. Item No. 2 Meeting Date: June 5, 2017 Type of Business: Work Session City Administrator Review: ______ City of Mounds View Staff Report To: Honorable Mayor and City Council From: Brian Erickson, P.E., Public Works Director/City Engineer Item Title/Subject: I-35W and County Road H Roundabout Monument Discussion Introduction In September 2015, staff discussed the potential for adding a monument at the roundabout on the west side of the new County Road H bridge over I-35W. Since that time Ramsey County has completed a majority of the work in this area including the roundabout. Discussion With this project concluding this year, staff is bringing this item back for Council to discuss what they would like to see as a monument in the roundabout. Attached construction plans show the location and size so that Council can review and discuss ideas. At a minimum, the inclusion of some landscaping is something that could be included relatively easily until more information is available. As part of the construction the center of the roundabout will have grass. Respectfully Submitted, Brian Erickson, P.E. Item No. 3 Meeting Date: June 5, 2017 Type of Business: Work Session City Administrator Review: ______ City of Mounds View Staff Report To: Honorable Mayor and City Council From: Desaree Crane, Assistant City Administrator Item Title/Subject: Twin Cities Gateway Grant Introduction Since 2009, the City of Mounds View has been a member of the Twin Cities Gateway. One of the Twin Cities Gateway’s programs is the “Member City Marketing Grant.” Beginning in 2011, the program was structured so that each member city receives an annual grant based on the percentage of lodging taxes collected from the prior year. Below is the breakdown of annual grant fund allocations for the City of Mounds View from Twin Cities Gateway: Year 2010: $2,000 Year 2011: $3,673 Year 2012: $6,600 Year 2013: $6,429 Year 2014: $6,504 Year 2015: $6,504 Year 2016: $8,872 Year 2017: $7,964 Discussion As part of accepting the 2017 grant funds, the City Council is required to enter into the attached agreement. Upon accepting the grant, the City must disperse the funds to community festival(s), and/or event(s) the City Council wants to support. Last year, the Mound View City Council chose to provide grant funds towards the Festival in the Park ($7,172) and towards website restructuring to market and promote program and events at the Mounds View Community Center ($1,500). Staff would like to discuss disbursement options of the grant funds before presenting the agreement for approval at the June 12, 2017, City Council Meeting. Respectfully Submitted, ______________________ Desaree Crane City of Mounds View 2018 Budget Summary Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 General Fund:Actual Actual Actual Budget Actual Request Dollar Percent Revenues: Property taxes - Base levy 3,363,602 3,651,411 3,700,381 3,833,967 - 3,828,967 (5,000) -0.13% Special tax levies, Bonds 156,348 154,119 154,119 90,835 - 99,177 8,342 9.18% Special tax levies, Operations 217,145 226,145 233,145 244,145 - 249,145 5,000 2.05% Franchise tax 336,711 309,039 296,173 280,000 116,511 285,000 5,000 1.79% Other taxes 109,002 47,877 27,556 29,000 - 29,000 - 0.00% Hotel/motel tax 66,367 69,109 67,408 65,000 16,465 65,000 - 0.00% Licenses and permits 246,969 204,845 184,499 180,522 115,758 182,972 2,450 1.36% Intergovernmental 941,697 1,038,060 1,090,100 976,636 64,679 1,049,757 73,121 7.49% Charges for services 14,933 18,942 40,988 16,325 12,903 16,825 500 3.06% Fines & forfeitures 40,239 36,338 29,278 39,000 9,033 36,600 (2,400) -6.15% Interest 521,224 112,669 104,985 115,000 32,122 115,000 - 0.00% Miscellaneous 355,678 321,188 342,547 295,826 274,698 282,696 (13,130) -4.44% Transfers: DARE Fund - 4,643 - - - - - 0.00% Water Fund 69,393 - - 75,828 - 78,103 2,275 3.00% Sewer Fund 54,962 56,611 58,309 60,058 - 61,860 1,802 3.00% Storm Water Fund 7,168 7,383 7,604 7,832 - 8,067 235 3.00% Street Light Fund 2,462 2,536 2,612 2,690 - 2,771 81 3.01% Vehicle & Equipment Fund 38,316 21,000 22,000 21,600 - 22,000 400 1.85% Debt proceeds - 246,729 - - - - - 0.00% Total revenues 6,542,216 6,528,644 6,361,704 6,334,264 642,169 6,412,940 78,676 1.24% Expenditures: Legislative Services: City Council 46,030 47,115 47,213 57,527 24,799 57,246 (281) -0.49% Advisory Commissions 14,315 8,720 15,520 15,500 550 17,000 1,500 9.68% Subtotal 60,345 55,835 62,733 73,027 25,349 74,246 1,219 1.67% Administrative Services: City Administrator 231,848 271,314 282,476 298,084 118,935 302,262 4,178 1.40% Elections 20,053 22,222 47,279 35,000 9,515 24,500 (10,500) -30.00% Finance 232,173 246,268 255,786 263,457 109,871 270,906 7,449 2.83% Central Services 207,551 216,482 237,713 255,645 88,350 254,533 (1,112) -0.43% Subtotal 691,625 756,286 823,254 852,186 326,671 852,201 15 0.00% Community Development 341,593 353,381 320,413 398,498 115,968 421,714 23,216 5.83% Police 2,481,263 2,710,053 2,719,071 2,751,241 1,111,995 2,894,933 143,692 5.22% Fire 511,231 567,934 592,181 567,196 301,005 603,304 36,108 6.37% Public Works Administration 141,537 113,779 135,670 143,944 54,371 146,300 2,356 1.64% Parks, Recreation & Forestry: Recreation 99,589 112,429 109,358 115,487 52,354 118,849 3,362 2.91% Parks 313,684 333,043 322,085 359,424 97,364 345,090 (14,334) -3.99% Forestry 17,379 34,478 29,474 47,486 4,944 42,586 (4,900) -10.32% Subtotal 430,652 479,950 460,917 522,397 154,662 506,525 (15,872) -3.04% Fleet Services: Building & Grounds Mtnce 126,707 391,909 116,217 132,657 57,691 135,191 2,534 1.91% Vehicle & Equipment Mtnce 116,011 84,331 86,966 108,167 41,491 113,121 4,954 4.58% Subtotal 242,718 476,240 203,183 240,824 99,182 248,312 7,488 3.11% Streets: Pavement Management 205,624 203,268 185,346 235,303 70,944 231,885 (3,418) -1.45% Snow & Ice Control 196,155 134,936 131,951 147,564 44,372 147,224 (340) -0.23% Sign Maintenance 37,342 40,315 37,082 63,877 11,278 67,962 4,085 6.40% Subtotal 439,121 378,519 354,379 446,744 126,594 447,071 327 0.07% Other Convention & Visitor's Bureau 63,049 65,654 64,038 61,750 14,150 61,750 - 0.00% Social Service Coordination 19,763 20,178 20,259 20,461 20,461 21,075 614 3.00% Miscellaneous/contingency 4,926 4,975 5,061 6,500 1,836 6,500 - 0.00% Transfers to other funds 1,090,000 496,000 745,000 475,000 - 500,000 25,000 5.26% Debt service - 20,268 24,495 24,496 10,206 24,496 - 0.00% Subtotal 1,177,738 607,075 858,853 588,207 46,653 613,821 25,614 4.35% Total expenditures 6,517,823 6,499,052 6,530,654 6,584,264 2,362,450 6,808,427 224,163 3.40% Net change in fund balance 24,393 29,592 (168,950) (250,000) (1,720,281) (395,487) (145,487) Beginning Fund Balance 9,560,579 9,584,972 9,614,564 9,445,614 9,445,614 9,195,614 Ending Fund Balance 9,584,972 9,614,564 9,445,614 9,195,614 7,725,333 8,800,127 (145,487) 1 City of Mounds View GENERAL FUND 2018 Budget Summary Community Park Public 2018 2017 Percent Legislative Admin Finance Central Development Police Fire & Rec Works Misc.Total Total Variance Change Current Personnel services 39,115$ 295,287$ 249,921$ -$ 387,487$ 2,468,280$ -$ 226,662$ 526,989$ 6,500$ 4,200,241$ 4,014,373$ 185,868$ 4.63% Materials & supplies 2,900 1,310 600 39,090 3,375 79,508 - 48,948 135,495 - 311,226 319,636 (8,410) -2.63% Contractual services 32,231 30,165 20,385 215,443 30,852 347,145 447,393 230,915 179,199 82,825 1,616,553 1,578,226 38,327 2.43% Contingency - - - - - - - - - - - - - 0.00% Current total 74,246 326,762 270,906 254,533 421,714 2,894,933 447,393 506,525 841,683 89,325 6,128,020 5,912,235 215,785 3.65% Other Principal - - - - - - 75,135 - - 18,887 94,022 127,980 (33,958) -26.53% Interest - - - - - - 19,319 - - 5,609 24,928 22,394 2,534 11.32% Capital outlays - - - - - - 61,457 - - - 61,457 46,655 14,802 31.73% Transfers to other funds - - - - - - - - - 500,000 500,000 475,000 25,000 5.26% Other total - - - - - - 155,911 - - 524,496 680,407 672,029 8,378 1.25% Department Total 74,246$ 326,762$ 270,906$ 254,533$ 421,714$ 2,894,933$ 603,304$ 506,525$ 841,683$ 613,821$ 6,808,427$ 6,584,264$ 224,163$ 3.40% 2017 Budget 73,027 333,084 263,457 255,645 398,498 2,751,241 567,196 522,397 831,512 588,207 6,584,264 Increase (Decrease)1,219 (6,322)7,449 (1,112)23,216 143,692 36,108 (15,872)10,171 25,614 224,163 Percent change 1.67%-1.90%2.83%-0.43%5.83%5.22%6.37%-3.04%1.22%4.35%3.40%2 General Fund Revenue Detail - 2018 Budget Y-T-D Acct 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 #Description Actual Actual Actual Budget Actual Request Dollar Percent Taxes 3101 Current ad valorem property tax 3,363,602 3,651,411 3,700,381 3,833,967 - 3,828,967 (5,000) -0.13% 3101 Fire bonds 156,348 154,119 154,119 90,835 - 99,177 8,342 9.18% 3101 PERA rate increase property tax 39,145 39,145 39,145 39,145 - 39,145 - 0.00% 3101 Police Officer market rate tax 178,000 187,000 194,000 205,000 - 210,000 5,000 2.44% 3102 Delinquent ad valorem prop tax 12,324 17,266 - - - - - 0.00% 3111 Manufact home tax - current 19,935 21,331 18,966 20,000 - 20,000 - 0.00% 3112 Manufact home tax - delinquent 8,500 9,280 8,590 9,000 - 9,000 - 0.00% 3125 Excess TIF 62,069 - - - - - - 0.00% 3180 Franchise tax on utilities 336,711 309,039 296,173 280,000 116,511 285,000 5,000 1.79% 3190 Penalties & interest 5,817 - - - - - 0.00% 3192 Forfeited tax sales 357 - - - - - 0.00% 3195 Hotel/Motel tax 66,367 69,109 67,408 65,000 16,465 65,000 - 0.00% Total taxes 4,249,175 4,457,700 4,478,782 4,542,947 132,976 4,556,289 13,342 0.29% Licenses and Permits 3211 Liquor on-sale 16,775 16,800 17,290 16,800 - 16,800 - 0.00% 3212 Liquor off-sale 600 1,477 2,095 600 255 600 - 0.00% 3215 Malt on-sale license 135 - 115 - - - - 0.00% 3216 Malt off-sale (15) - 135 100 - 100 - 0.00% 3221 Tobacco license 3,220 3,300 3,300 3,000 330 3,300 300 10.00% 3223 Amusement devices 1,072 720 704 700 - 700 - 0.00% 3231 Bowling alley 672 672 672 672 - 672 - 0.00% 3232 Garbage hauling 3,150 2,558 3,373 3,000 - 3,000 - 0.00% 3233 Gasoline station 850 850 850 850 - 850 - 0.00% 3234 Used car sales 204 204 204 200 - 200 - 0.00% 3235 Kennel 285 426 488 150 45 200 50 33.33% 3236 Restraurant licenses 3,025 3,806 3,641 3,100 - 3,100 - 0.00% 3238 Transient & solicitor 2,235 2,666 2,130 2,200 1,775 2,200 - 0.00% 3239 Apartment 26,331 28,967 25,715 26,000 200 26,000 - 0.00% 3240 Rental conversion 3,295 1,335 2,500 1,000 975 1,000 - 0.00% 3241 Dog license 3,454 1,428 7,119 1,200 723 1,400 200 16.67% 3242 Massage therapy - 899 - - - - - 0.00% 3243 Chickens and bees - 440 350 200 170 200 - 0.00% 3250 General contractor 1,340 760 1,400 1,100 661 1,100 - 0.00% 3251 HVAC contractor 6,390 5,050 4,840 4,000 1,850 4,400 400 10.00% 3252 Cement contractor 160 - 40 100 - 100 - 0.00% 3253 Asphalt contractor 40 180 120 100 - 100 - 0.00% 3254 Excavating contractor 60 - - 50 60 50 - 0.00% 3255 Sign & billboard contractor 680 60 100 300 - 100 (200) -66.67% 3256 Sewer & water contractor - 100 - - 60 - - 0.00% 3257 Other contractor 2,230 3,430 2,800 1,500 1,440 2,000 500 33.33% 3258 License check 2,012 2,058 2,132 1,600 399 1,800 200 12.50% 3260 Fire permits 1,320 950 1,780 900 250 900 - 0.00% Subtotal licenses 79,520 79,136 83,893 69,422 9,193 70,872 1,450 2.09% 3 General Fund Revenue Detail - 2018 Budget Y-T-D Acct 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 #Description Actual Actual Actual Budget Actual Request Dollar Percent 3268 Plan check fee 37,926 23,141 13,751 18,000 31,650 18,000 - 0.00% 3270 Building permits 79,071 53,481 39,681 50,000 53,920 50,000 - 0.00% 3271 Fixed fee - building permits 18,592 18,421 20,146 18,000 7,366 18,500 500 2.78% 3273 HVAC permits 15,070 15,341 14,483 13,000 3,544 13,500 500 3.85% 3274 Plumbing permits 9,985 6,904 5,655 6,500 4,397 6,500 - 0.00% 3275 Non-building permits 5,921 7,679 5,314 5,000 2,380 5,000 - 0.00% 3278 Interim use permits - - 500 - - - - 0.00% 3279 Conditional use permits 600 400 800 600 1,200 600 - 0.00% 3280 Building surcharge 144 1,052 99 - 1,797 - - 0.00% 3281 Fixed fee building surcharge 75 (921) (3) - 137 - - 0.00% 3282 Mechanical/commercial surcharg 28 (38) 8 - - - - 0.00% 3283 HVAC surcharge 21 60 33 - 24 - - 0.00% 3284 Plumbing surcharge 13 27 130 - 25 - - 0.00% 3286 Water & sewer surcharge - 158 3 - 116 - - 0.00% 3287 Commercial plmb surcharge 10 4 6 - 9 - - 0.00% Subtotal permits 167,449 125,709 100,606 111,100 106,565 112,100 1,000 0.90% Total licenses & permits 246,969 204,845 184,499 180,522 115,758 182,972 2,450 1.36% Intergovernmental: 3318 Federal grant 1,088 350 2,902 - - - - 0.00% 3341 Local Government Aid 597,024 655,531 666,792 604,365 - 662,786 58,421 9.67% 3345 Performance Aid - 1,742 1,821 - - 1,800 1,800 0.00% 3346 PERA Aid 8,671 8,671 8,671 8,671 - 8,671 - 0.00% 3351 Street Aid - MSA maintenance 109,063 122,280 121,641 120,000 60,560 120,000 - 0.00% 3355 Police Aid 126,933 141,567 152,973 135,000 - 145,000 10,000 7.41% 3356 Police training 5,471 5,664 5,628 5,600 - 9,500 3,900 69.64% 3357 State police grant 1,088 389 455 - - - - 0.00% 3359 Other state grants 27,409 36,522 31,298 37,000 4,119 32,000 (5,000) -13.51% 3370 Other local government revenue 2,000 1,230 593 - - - - 0.00% 3371 IDS # 621 - SRO 62,950 64,114 75,839 66,000 - 70,000 4,000 6.06% 3375 State pension contribution - - 21,487 - - - - 0.00% Total intergovernmental 941,697 1,038,060 1,090,100 976,636 64,679 1,049,757 73,121 7.49% Charges for services 3410 Advertising revenue 1,620 205 530 700 - 500 (200) -28.57% 3415 Housing inspections - 190 1,771 50 - 100 50 100.00% 3418 HRA inspections 190 - - 500 - 200 (300) -60.00% 3419 Investigations 228 2,806 200 - - 200 200 0.00% 3421 Police reports 1,723 1,165 1,742 1,200 163 1,200 - 0.00% 3422 Documents / copies 26 351 262 100 - 150 50 50.00% 3423 Customer service 281 595 525 300 519 300 - 0.00% 3425 Book sales - various 10 - 43 - 9 - - 0.00% 3426 Reimbursed staff time 15 - - 500 - 200 (300) -60.00% 3430 Right-of-way 5,615 8,310 24,712 9,000 8,561 9,000 - 0.00% 3431 Street opening fee - 200 - - 800 - - 0.00% 3432 Tree removal charges - 2,670 8,353 1,000 2,001 2,000 1,000 100.00% 3433 Overload permits 75 - 200 - 250 - - 0.00% 3458 Zoning letter 300 150 500 75 100 75 - 0.00% 3461 Subdivision 2,100 - 1,050 1,000 - 1,000 - 0.00% 3462 Variance 1,800 1,800 1,100 1,000 - 1,000 - 0.00% 3463 Rezoning - 500 - 200 500 200 - 0.00% 3464 Development - non refund 450 - - 350 - 350 - 0.00% 3466 Comprehensive Plan Amendmen 500 - - - - - - 0.00% 3467 PUD amendment - - - 350 - 350 - 0.00% Total charges for services 14,933 18,942 40,988 16,325 12,903 16,825 500 3.06% 4 THIS PAGE LEFT BLANK INTENTIONALLY 5 General Fund Revenue Detail - 2018 Budget Y-T-D Acct 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 #Description Actual Actual Actual Budget Actual Request Dollar Percent Fines and Forfeitures 3510 Ramsey County municipal court 35,010 32,019 25,527 34,000 8,783 32,000 (2,000) -5.88% 3515 Mn Highway Patrol 233 50 - 200 - 200 - 0.00% 3520 Administrative offenses 2,621 2,144 801 2,500 50 2,100 (400) -16.00% 3525 False alarm charges 2,375 2,125 2,950 2,300 200 2,300 - 0.00% Total fines & forfeitures 40,239 36,338 29,278 39,000 9,033 36,600 (2,400) -6.15% Other Revenue 3550 Special assessments 11,601 4,195 3,706 3,000 - 3,000 - 0.00% 3610 Investment income (charge)521,224 112,669 104,985 115,000 32,122 115,000 - 0.00% 3630 Billboard Lease 103,110 105,303 112,562 113,876 63,475 119,889 6,013 5.28% 3631 Water tower rental 98,855 101,639 110,529 114,950 114,950 90,807 (24,143) -21.00% 3634 Equipment and space rental 5,268 5,454 1,194 1,150 1,230 1,150 - 0.00% 3639 Security - 3,782 1,509 - 540 - - 0.00% 3650 Donations 11,485 5,100 4,080 - 6,575 - - 0.00% 3651 Donations - K9 1,618 1,247 1,330 750 445 750 - 0.00% 3654 COPS events - - - - 6,881 5,000 5,000 0.00% 3656 Tree sales - - 204 - - - - 0.00% 3665 Park site permit 12,497 14,940 14,613 14,000 6,841 14,000 - 0.00% 3679 Vending machine commissions 466 - 76 100 - 100 - 0.00% 3680 Other revenue 46,993 10,584 20,812 11,000 47,103 11,000 - 0.00% 3685 Insurance reimbursements 59,152 40,145 57,995 30,000 6,279 30,000 - 0.00% 3690 Cash over / short (22) - - - - - - 0.00% 3911 Sale of assets 550 28,338 12,513 5,000 7,075 5,000 - 0.00% 3912 Resale of materials 4,105 461 1,424 2,000 13,304 2,000 - 0.00% Total other revenue 876,902 433,857 447,532 410,826 306,820 397,696 (13,130) -3.20% Transfers & Debt proceeds 3972 Transfers: Vehicle & Equip replacement 38,316 21,000 22,000 21,600 - 22,000 400 1.85% DARE fund - 4,643 - - - - - 0.00% Water 69,393 - - 75,828 - 78,103 2,275 3.00% Sewer 54,962 56,611 58,309 60,058 - 61,860 1,802 3.00% Storm Water 7,168 7,383 7,604 7,832 - 8,067 235 3.00% Street light 2,462 2,536 2,612 2,690 - 2,771 81 3.01% 3993 Debt proceeds - 246,729 - - - - - 0.00% Total Transfers & Debt 172,301 338,902 90,525 168,008 - 172,801 4,793 2.85% Total 6,542,216 6,528,644 6,361,704 6,334,264 642,169 6,412,940 78,676 1.24% 6 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent City Council (100 - 4100): Personnel services 0100 Salaries, regular 29,292 29,292 29,292 34,596 12,818 34,596 - 0.00% 0300 Social Security 1,129 1,129 1,129 2,647 534 2,647 - 0.00% 0321 PERA 885 885 885 1,730 358 1,730 - 0.00% 0500 Workers compensation 111 148 132 173 68 142 (31) -17.92% Total personnel services 31,417 31,454 31,438 39,146 13,778 39,115 (31) -0.08% Materials & supplies 1600 Supplies, operating 1,690 1,635 2,239 2,600 585 2,600 - 0.00% Total materials & supplies 1,690 1,635 2,239 2,600 585 2,600 - 0.00% Contractual services 3030 Other professional services 6,895 6,154 5,882 6,200 1,639 6,200 - 0.00% 3610 Memberships 2,801 5,161 5,429 5,681 5,651 5,681 - 0.00% 3630 Training & conferences 2,633 2,208 1,765 3,200 2,923 3,000 (200) -6.25% 4800 Bonding & insurance 594 503 460 700 223 650 (50) -7.14% Total contractual services 12,923 14,026 13,536 15,781 10,436 15,531 (250) -1.58% 0.00% Total City Council 46,030 47,115 47,213 57,527 24,799 57,246 (281) -0.49% 15,661 15,775 18,381 18,131 Advisory Commissions (100-4110): Materials & supplies 1600 Supplies, operating - 41 - 200 - 200 - 0.00% 2100 Books & periodicals - - - 100 - 100 - 0.00% Total materials & supplies - 41 - 300 - 300 - 0.00% Contractual services 3030 Other professional services 4,369 2,227 2,641 4,500 485 4,500 - 0.00% 3630 Training & conferences - - - 200 65 200 - 0.00% 3900 Festivities Commission 9,946 6,452 12,879 10,500 - 12,000 1,500 14.29% Total contractual services 14,315 8,679 15,520 15,200 550 16,700 1,500 9.87% 0.00% Total Advisory Commissions 14,315 8,720 15,520 15,500 550 17,000 1,500 9.68% 2018 Budget Summary 7 Fund: 100 Department: 4100 City Council Account Description 2015 2016 2017 2018 Description 1600 Supplies, operating 900 1,000 1,000 1,000 Employee appreciation dinner 500 600 600 600 Strategic planning session supplies 900 1,000 1,000 1,000 Plaques and gift certificates for employee appreciation 2,300 2,600 2,600 2,600 3030 Other professional services 3,000 - - - Strategic planning session(s) facilitator 6,075 6,200 6,200 6,200 Contractual minutes for Council mtgs ( $225 x 24 reg, + 3 special) 9,075 6,200 6,200 6,200 3610 Memberships 30 30 30 30 Mn Mayor's Association 5,770 5,570 5,651 5,651 North Metro Mayors (Evaluate for value and effectiveness) 5,800 5,600 5,681 5,681 3630 Conferences 2,000 3,200 3,200 3,000 Council training, LMC conference, RCCLG dinners & NLC conference 2,000 3,200 3,200 3,000 4800 Bonds & insurance 750 700 700 650 General property & liability 750 700 700 650 19,925 18,300 18,381 18,131 7.99%-8.16%0.44%-1.36% Fund: 100 Department: 4110 Advisory Commissions Account Description 2015 2016 2017 2018 Description 1600 Supplies, operating 60 60 60 60 Misc supplies for various commissions. 140 140 140 140 Copies for Charter Commission 200 200 200 200 2100 Books & periodicals 100 100 100 100 Misc periodicals - Comp plan review, Ordinance revisions. 100 100 100 100 3030 Other professional services 500 500 500 500 Misc. consultant services. 2,000 2,000 1,750 1,750 Charter commission legal fees 2,500 2,500 2,250 2,250 Planning Commission meeting minutes 5,000 5,000 4,500 4,500 3630 Training 150 150 75 75 Misc training & conferences. 150 150 125 125 Planning Commissioner training & conferences 300 300 200 200 3900 Festival in the Park 9,500 4,500 5,500 7,000 City Festival in the Park (personnel, supplies)(60th Anniversery) - 5,000 5,000 5,000 Fireworks 9,500 9,500 10,500 12,000 15,100 15,100 15,500 17,000 48.77%48.77%2.65%12.58% 8 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Office of the City Administrator (100 - 4130): Personnel services 0100 Salaries, regular 177,671 212,471 216,175 224,486 80,750 230,165 5,679 2.53% 0110 Salaries, over-time - - - 896 - 909 13 1.45% 0150 Salaries, part-time - - - 988 - 988 - 0.00% 0300 Social Security 12,871 15,417 15,115 17,127 6,095 17,562 435 2.54% 0321 PERA 12,692 15,622 15,518 16,716 5,899 17,143 427 2.55% 0400 Group insurance 24,479 20,649 20,981 26,007 9,087 27,090 1,083 4.16% 0500 Workers compensation 1,465 2,325 1,471 1,689 660 1,430 (259) -15.33% Total personnel services 229,178 266,484 269,260 287,909 102,491 295,287 7,378 2.56% Materials & supplies 1230 Supplies, equipment 340 179 - 1,200 - 1,200 - 0.00% 1600 Supplies, operating - 13 - 75 - 75 - 0.00% 2100 Books & periodicals - - - 35 - 35 - 0.00% Total materials & supplies 340 192 - 1,310 - 1,310 - 0.00% Contractual services 3030 Other professional services - - 10,447 - 14,981 - - 0.00% 3100 Communications 631 741 1,078 1,300 873 1,300 - 0.00% 3610 Memberships 142 188 201 1,340 45 1,340 - 0.00% 3630 Training & conferences 1,335 3,709 1,490 5,850 545 2,650 (3,200) -54.70% 3800 Mileage 222 - - 375 - 375 - 0.00% Total contractual services 2,330 4,638 13,216 8,865 16,444 5,665 (3,200) -36.10% Total City Administrator 231,848 271,314 282,476 298,084 118,935 302,262 4,178 1.40% 4,830 13,216 10,175 6,975 Elections (100 - 4140): Contractual services 3030 Other professional services 20,053 22,222 19,167 35,000 9,515 24,500 (10,500) -30.00% Total contractual services 20,053 22,222 19,167 35,000 9,515 24,500 (10,500) -30.00% 7030 Capital outlays - - 28,112 - - - 0.00% Total Elections 20,053 22,222 47,279 35,000 9,515 24,500 (10,500) -30.00% 2018 Budget Summary 9 Fund: 100 Department: 4130 Office of the City Administrator Account Description 2015 2016 2017 2018 Description 1230 Supplies, equipment < $5000 725 825 1,200 1,200 Equipment and phones under the $5,000 capitalization threshold 725 825 1,200 1,200 1600 Supplies, Operating 75 75 75 75 Miscellaneous supplies 75 75 75 75 2100 Books & Periodicals 35 35 35 35 Miscellaneous reference books 35 35 35 35 3100 Communications 760 1,300 1,300 1,300 Cell phone service (2) employees 760 1,300 1,300 1,300 3610 Memberships - - 50 50 MAMA - (Administrator) Metro Area Manager's Association - - 1,100 1,100 ICMA - International City Manager's Association 150 150 150 150 Mn City County Managers Association 40 40 40 40 Municipal Clerks & Finance Officers Association 190 190 1,340 1,340 3630 Training & conferences 100 100 100 100 MAMA meetings 500 500 500 500 LMC / miscellaneous training 100 100 100 100 Chamber lunches 850 1,000 1,000 1,000 LMC annual conference (2 attendees)(Asst. Adm. every other year) 850 850 850 850 Mn City County Managers Assoc conference 100 100 100 100 Mn Clerks and Finance Officers Association (MCFOA) institute training 3,000 - 3,200 - National ICMA or NLC conference (City Administrator)(every other year) 5,500 2,650 5,850 2,650 3800 Mileage 375 375 375 375 Miscellaneous mileage @ IRS rate. 375 375 375 375 7,660 5,450 10,175 6,975 -0.65%-29.31%32.83%27.98% Fund: 100 Department: 4140 Elections Account Description 2015 2016 2017 2018 Description 3030 Other professional services 23,200 23,200 22,000 22,000 Ramsey County elections contract - - 10,500 - Special election - 2,500 2,500 2,500 Equip. maint. service costs (voting equip.) 23,200 25,700 35,000 24,500 7030 Equipment 36,000 29,000 - - Voting equipment 36,000 29,000 - - 59,200 54,700 35,000 24,500 5.71%-7.60%-36.01%-30.00% 10 2018 Budget Summary Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Finance (100 - 4150): Personnel services 0100 Salaries, regular 166,330 177,754 186,467 187,327 72,500 192,483 5,156 2.75% 0300 Social Security 11,908 12,751 13,092 14,330 4,963 14,725 395 2.76% 0321 PERA 11,808 13,050 13,676 14,050 5,382 14,436 386 2.75% 0400 Group insurance 21,414 21,860 22,311 25,506 9,522 26,910 1,404 5.50% 0500 Workers compensation 1,273 1,850 1,415 1,615 632 1,367 (248) -15.36% 0990 Severence - - - - - - - 0.00% Subtotal 212,733 227,265 236,961 242,828 92,999 249,921 7,093 2.92% Materials & supplies 1230 Supplies, equipment 17 - - 200 - 175 (25) -12.50% 1600 Supplies, operating 35 - - 75 - 75 - 0.00% 2100 Books & periodicals 181 185 227 450 - 350 (100) -22.22% Subtotal 233 185 227 725 - 600 (125) -17.24% Contractual services 3030 Other professional 9,811 9,738 9,519 9,615 9,236 9,780 165 1.72% 3100 Communications 480 480 480 480 160 480 - 0.00% 3430 Printing 1,179 551 735 700 404 700 - 0.00% 3610 Memberships 804 970 995 995 750 1,040 45 4.52% 3630 Training 2,635 2,477 2,037 2,700 1,249 2,700 - 0.00% 5130 Repairs & maint., equipment 4,298 4,602 4,832 5,414 5,073 5,685 271 5.01% Subtotal 19,207 18,818 18,598 19,904 16,872 20,385 481 2.42% Total Financial Services 232,173 246,268 255,786 263,457 109,871 270,906 7,449 2.83% 11 Fund: 100 Department: 4150 Finance Account Description 2015 2016 2017 2018 Description 1230 Supplies, equitpment < $5000 200 200 200 175 Furniture or equipment under the $5,000 capitalization threshold 200 200 200 175 1600 Supplies, operating 75 75 75 75 Misc supplies - planners, plaques, folders, files, etc. 75 75 75 75 2100 Books & periodicals 550 450 450 350 Misc computer & finance books & periodicals 550 450 450 350 3030 Other professional services 9,480 9,660 9,020 9,185 27.5% of audit (2016 - $32,200, 2017 - $32,800, 2018 - $33,400) 435 435 435 435 GFOA financial reporting fee 60 60 60 60 Safety deposit box rental 100 100 100 100 Ramsey County overlapping debt, principal taxpayer reports 10,075 10,255 9,615 9,780 3100 Communications 480 480 480 480 cell phone ($40 month) 480 480 480 480 3430 Printing 350 350 350 350 Accts Payable & payroll checks & envelopes 350 350 350 350 Invoices, receipts, & bank deposit slips 700 700 700 700 3610 Memberships 350 350 350 370 Government Finance Officer's Association (GFOA) 120 120 120 120 Mn GFOA (2) 240 250 250 260 AICPA Am. Institute of Certified Public Accts 275 275 275 290 MNCPA Mn Society of Certified Public Accountants 985 995 995 1,040 3630 Training & conferences 75 75 50 50 Mn GFOA monthly meetings 1,450 1,600 1,700 1,700 Seminars & training - - - - GFOA National conference (Defer)($2500) 600 650 650 650 Accounting and software training 250 250 300 300 Mileage 2,375 2,575 2,700 2,700 5130 Equipment repairs 4,910 5,156 5,414 5,685 40% software support charges (30% each in Water, Sanitary Sewer)(5% annual 4,910 5,156 5,414 5,685 20,350 20,886 20,629 20,985 -1.52%2.63%-1.23%1.73% 12 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Central Services (100 - 4160): Materials & supplies 0322 Pesion expense GASB 68 - - 2,031 - - - - 0.00% 1110 Stationery 1,027 - 436 1,000 - 750 (250) -25.00% 1120 Copy materials - 830 1,799 1,500 479 1,500 - 0.00% 1230 Supplies, equipment 4,296 21,316 22,102 21,600 10,099 22,000 400 1.85% 1600 Supplies, operating 14,462 12,662 12,670 14,500 6,091 14,500 - 0.00% 2100 Books & periodicals 159 169 169 365 54 340 (25) -6.85% Total materials & supplies 19,944 34,977 39,207 38,965 16,723 39,090 125 0.32% Contractual services 3010 General legal 57,407 45,489 41,364 44,000 11,250 44,000 - 0.00% 3030 Other professional services 5,154 9,643 22,423 22,446 2,622 14,046 (8,400) -37.42% 3100 Telephone 7,078 6,160 2,613 2,400 749 2,200 (200) -8.33% 3300 Postage 8,366 8,273 4,238 7,800 2,191 7,800 - 0.00% 3410 Legal notices 2,395 4,168 3,499 3,000 848 3,000 - 0.00% 3420 Advertising 2,534 2,634 2,739 2,500 - 2,500 - 0.00% 3430 Printing 8,330 7,945 8,601 7,400 1,605 12,600 5,200 70.27% 3610 Memberships 13,424 19,253 20,049 20,556 8,289 20,556 - 0.00% 3630 Training & conferences 172 1,167 498 2,000 668 2,000 - 0.00% 4010 Rental, equipment 1,431 1,407 1,424 1,750 703 1,750 - 0.00% 4800 Insurance & bonds 14,614 15,212 14,453 20,000 24,281 18,000 (2,000) -10.00% 5100 Repairs & maint, computers 64,347 56,507 76,605 82,228 18,421 86,391 4,163 5.06% 5130 Repairs, equipment 2,355 3,647 - 600 - 600 - 0.00% Total contractual services 187,607 181,505 198,506 216,680 71,627 215,443 (1,237) -0.57% Total central services 207,551 216,482 237,713 255,645 88,350 254,533 (1,112) -0.43% 2018 Budget Summary 13 Fund: 100 Department: 4160 Central Services Account Description 2015 2016 2017 2018 Description 1110 Stationery 1,000 1,000 1,000 750 Envelopes, labels, letterhead, etc. 1,000 1,000 1,000 750 1120 Copy materials 1,500 1,500 1,500 1,500 Copy paper 1,500 1,500 1,500 1,500 1230 Supplies, equipment < $5000 20,000 20,000 21,600 22,000 Comp & security equip under $5,000, pc's, software, switches, cameras.... 20,000 20,000 21,600 22,000 Replace pc's @ $800 4 yr replacement cycle 1600 Supplies, operating 15,400 15,400 14,000 14,000 Toner, rug service, paper, pens, staples, desk supplies, etc. 500 500 500 500 Misc operating supplies 15,900 15,900 14,500 14,500 2100 Books & periodicals 175 175 175 150 Employment handbooks/publications 190 190 190 190 Star Tribune - $190 365 365 365 340 3010 General legal 26,400 24,000 24,000 24,000 Retainer for legal services 18,000 20,000 20,000 20,000 Legal fees outside scope of retainer. 44,400 44,000 44,000 44,000 3030 Other professional services 6,000 5,700 5,700 6,000 General labor assistance - - 10,000 - Personnel market study - - 3,086 3,086 Western Bank monthly fees - - 360 360 US Bank positive pay service 1,400 1,500 1,200 1,200 Section 125 (flex spending plan) & COBRA administration 900 1,000 1,000 1,000 Human resources items 1,000 1,100 1,100 2,400 Web hosting (Revive) (5% annual increase) 9,300 9,300 22,446 14,046 3100 Telephone 6,800 7,400 2,400 2,200 Basic telephone plus long distance 6,800 7,400 2,400 2,200 3300 Postage 300 300 300 300 Courier charges (delivery services) 7,500 7,500 7,500 7,500 General postage includes PW mailings for street projects. 7,800 7,800 7,800 7,800 3410 Legal notices 900 900 900 900 Truth in taxation notices and Ramsey County fees. 2,100 2,100 2,100 2,100 Legal notices and legal publications. 3,000 3,000 3,000 3,000 3420 Advertising 3,000 2,500 2,500 2,500 Job opening advertisements for vacant positions 3,000 2,500 2,500 2,500 3430 Printing 6,400 6,800 6,800 12,000 4 newsletters and postage, YMCA in Comm Ctr Fund. 200 200 200 200 Miscellaneous printing 400 400 400 400 City guides, directories & miscellaneous 7,000 7,400 7,400 12,600 3610 Memberships 605 600 625 625 Ramsey County League of Local Governments (RCLLG) - 2,850 2,850 2,850 I-35W Corridor Coalition 4,833 4,835 4,901 4,901 Metro Cities (1.36% increase for 2017) 10,813 11,637 12,180 12,180 League of Mn Cities (No increase 2018) 16,251 19,922 20,556 20,556 3630 Training & conferences 1,000 1,000 1,000 1,000 League training & seminars 800 800 800 800 OSHA and blood borne pathogen training 200 200 200 200 Information technology training 2,000 2,000 2,000 2,000 4010 Rental, equipment 150 150 150 150 Misc 1,600 1,600 1,600 1,600 Postage machine and scale rental 1,750 1,750 1,750 1,750 4800 Bonding & insurance 19,000 19,000 17,000 15,000 Insurance policy premiums 3,000 3,000 3,000 3,000 Allowance for insurance policy deductibles 22,000 22,000 20,000 18,000 5100 Repairs, computer 59,000 64,000 69,600 72,100 Computer, phone, network & technology assistance - City of Roseville 2,198 2,609 2,688 2,688 Laserfiche annual maintenance and storage - - - 1,603 Denial of Service protection contract (1.687% of $95,000) 5,750 5,750 5,750 6,000 Computer, printer, and networks repairs. 4,190 4,190 4,190 4,000 Copier maintenance + overages 2,040 - - - Hosted servers (2 servers) add (1) in 2015 (included in technology assist.) 73,178 76,549 82,228 86,391 5130 Repairs, equipment 600 600 600 600 Postage meter, copy machine, fax, misc. 600 600 600 600 235,844 242,986 255,645 254,533 -0.09%3.03%5.21%-0.43% 14 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Community Development (100 - 4180): Personnel services 0100 Salaries, regular 245,039 259,655 236,428 263,096 81,304 285,932 22,836 8.68% 0110 Overtime, regular 24 - - 548 70 699 151 27.55% 0150 Salaries, part time 1,380 1,226 1,238 1,976 293 1,976 - 0.00% 0300 Social Security 17,745 18,069 16,801 20,320 6,140 22,078 1,758 8.65% 0321 PERA 17,572 18,504 16,701 19,773 5,949 21,497 1,724 8.72% 0322 Pension expense GASB 68 - - 1,604 - - - - 0.00% 0400 Group insurance 35,750 35,975 28,371 51,120 7,874 53,640 2,520 4.93% 0500 Workers comp 2,177 2,859 1,660 1,834 717 1,665 (169) -9.21% Total personnel services 319,687 336,288 302,803 358,667 102,347 387,487 28,820 8.04% Materials & supplies 1230 Supplies, equipment 510 - 62 500 120 500 - 0.00% 1600 Supplies, operating - 110 48 300 - 300 - 0.00% 1700 Motor fuels & lubricants 2,191 1,745 732 1,840 114 2,000 160 8.70% 2100 Books & periodicals - 498 321 375 168 375 - 0.00% 2400 Uniforms 296 - 82 200 - 200 - 0.00% Total materials & supplies 2,997 2,353 1,245 3,215 402 3,375 160 4.98% Contractual services 3030 Other professional 12,869 9,431 11,749 27,200 11,116 21,906 (5,294) -19.46% 3040 Consultants, development review 2,085 822 1,575 3,000 - 3,000 - 0.00% 3100 Telephone 1,240 1,365 1,550 1,961 532 1,421 (540) -27.54% 3430 Printing 762 543 510 900 - 900 - 0.00% 3610 Memberships 870 1,180 120 1,630 944 1,200 (430) -26.38% 3630 Training and conferences 1,024 1,393 657 1,825 546 2,325 500 27.40% 3800 Mileage 59 6 204 100 81 100 - 0.00% Total contractual services 18,909 14,740 16,365 36,616 13,219 30,852 (5,764) -15.74% Total Community Development 341,593 353,381 320,413 398,498 115,968 421,714 23,216 5.83% 2018 Budget Summary 15 Fund: 100 Department: 4180 Community Development Account Description 2015 2016 2017 2018 Description 1230 Supplies, equipment < $5000 475 825 500 500 Miscellaneous equipment & computer peripherals 475 825 500 500 1600 Supplies, operating 100 100 100 100 Presentation supplies 200 200 200 200 Office supplies 300 300 300 300 1700 Motor fuels & lubs 1,788 2,200 1,840 2,000 Unleaded fuel: 800 gallons @ $2.50 (Gas for Comm Devlopment) 1,788 2,200 1,840 2,000 2100 Books & periodicals 100 100 100 100 Reference materials 100 100 100 100 Intl. Code Council Manuals and Code Updates 175 175 175 175 Manuals, pamphlets, etc. 375 375 375 375 2400 Uniforms 200 200 200 200 Clothing for inspections staff 200 200 200 200 3030 Other professional 1,300 1,300 1,300 1,300 Ramsey County JPA (geographic information system) 4,620 4,620 4,485 5,080 Permit Works system annual software support (includes busi. lic. mod) - 1,595 - 1,020 Permit works mobile inspector - 2,040 1,020 - Roseville Net Motion VPN 2 factor authentication 500 500 500 500 Filing fees (Ramsey County increased fees from $29 to $48) 1,971 2,110 2,195 2,306 Comcate Code Enforcement Mgr license 1,987 1,987 1,200 1,200 Comcate mobile access 500 500 500 500 GIS assistance - - 12,000 6,000 Comp plan GIS assistance with maps 4,000 4,000 4,000 4,000 Abatements of nuisance properties 14,878 18,652 27,200 21,906 3040 Consulting - Development 750 750 750 750 Environmental reviews Review (reimbursable)750 750 750 750 City attorney services 750 750 750 750 Development case reviews 750 750 750 750 Engineering services 3,000 3,000 3,000 3,000 3100 Telephone 1,300 1,300 1,000 1,000 Verizon Cell Accounts (2) for inspectors 481 481 961 421 network card for code enforcement (1 cards @ $35.01) 1,781 1,781 1,961 1,421 3430 Printing 1,300 1,000 900 900 Forms, flyers, etc. 1,300 1,000 900 900 3610 Memberships 300 300 245 265 American Planning Association (APA) - National (1) - - 50 50 American Planning Association (APA-MN) - State (1) - - 135 135 American Institute of Certified Planners (AICP) - - 750 300 Sensible Land Use Coalition (membership $250, monthly lunches (10 @ $50) 120 120 - - Assoc. of MN Building Officials 120 125 140 140 International Code Council (ICC) 60 95 100 100 10K Lakes Chapter of ICC 60 100 105 105 MN Assoc. Housing Code Officials (MAHCO) 85 100 105 105 MN Building Permit Technicians Association (MBPTA) 745 840 1,630 1,200 3630 Training & conferences 600 600 800 850 APA state conference (one attendee) - - 225 225 ICC code seminars 300 300 300 300 Other software training 300 300 500 950 Other staff training & seminars 1,200 1,200 1,825 2,325 3800 Mileage 100 100 100 100 Misc. use of personal automobiles 100 100 100 100 26,142 30,473 39,831 34,227 -3.34%16.57%30.71%-14.07% 16 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Police (100 - 4200): Personnel services: 0100 Salaries, regular 1,542,874 1,570,903 1,631,402 1,639,030 616,890 1,734,431 95,401 5.82% 0110 Overtime 74,978 80,112 96,684 60,499 39,281 62,625 2,126 3.51% 0300 Social Security 26,023 27,501 29,230 32,822 11,898 34,825 2,003 6.10% 0321 PERA 226,087 254,166 256,686 263,847 101,047 291,236 27,389 10.38% 0322 Pension expense GASB 68 - - 14,949 - - - - 0.00% 0400 Group insurance 205,941 220,722 231,125 259,560 102,083 272,520 12,960 4.99% 0500 Workers compensation 57,033 78,193 73,788 83,375 32,604 72,643 (10,732) -12.87% Total personnel services 2,132,936 2,231,597 2,333,864 2,339,133 903,803 2,468,280 129,147 5.52% Materials & Supplies 1210 Supplies, buildings & grounds - - - 500 - - (500) -100.00% 1230 Supplies, equipment 19,509 35,038 23,114 14,100 3,986 13,100 (1,000) -7.09% 1600 Supplies, operating 4,543 7,664 5,706 9,100 5,611 9,100 - 0.00% 1700 Motor, fuels & lubricants 43,608 39,643 24,716 33,293 3,706 36,188 2,895 8.70% 2100 Books & periodicals 811 1,031 723 900 - 300 (600) -66.67% 2400 Uniforms & clothing 16,974 15,168 20,682 20,805 14,796 20,820 15 0.07% Total materials & supplies 85,445 98,544 74,941 78,698 28,099 79,508 810 1.03% Contractual services 3020 Legal, prosecuting attorney 53,181 72,774 74,226 78,690 24,712 78,690 - 0.00% 3030 Other professional services 11,556 3,183 3,115 3,690 32,175 3,690 - 0.00% 3050 Dispatching 100,915 108,058 106,425 107,131 35,710 106,714 (417) -0.39% 3055 Information systems fees 2,540 2,565 4,907 4,955 1,035 4,955 - 0.00% 3070 COPS events 644 802 1,731 1,000 2,502 6,000 5,000 500.00% 3080 Veternarian services 2,951 5,449 1,199 1,500 503 1,500 - 0.00% 3100 Telephone 2,889 2,879 4,720 6,420 3,293 8,882 2,462 38.35% 3210 Electricity 290 280 289 320 107 320 - 0.00% 3430 Printing 339 149 168 500 - 400 (100) -20.00% 3610 Memberships 1,925 1,495 2,171 1,936 1,135 1,756 (180) -9.30% 3630 Training 9,166 11,387 15,045 12,470 6,286 16,370 3,900 31.28% 4010 Rental, equipment - - - - 445 - - 0.00% 4800 Insurance & bonds 40,670 42,602 52,324 54,100 45,715 54,500 400 0.74% 5100 Technology maintenance 29,252 121,538 39,937 52,858 24,855 55,528 2,670 5.05% 5130 Maintenance, equipment 6,564 6,751 4,009 7,840 1,620 7,840 - 0.00% Total contractual services 262,882 379,912 310,266 333,410 180,093 347,145 13,735 4.12% Capital outlays 7030 Equipment - - - - - - - 0.00% Total capital outlays - - - - - - - 0.00% Total police 2,481,263 2,710,053 2,719,071 2,751,241 1,111,995 2,894,933 143,692 5.22% 2018 Budget Summary 17 Fund: 100 Department: 4200 Police Account Description 2015 2016 2017 2018 Description 1210 Supplies, bldgs & grounds 800 800 500 - Carpet cleaning & misc maintenance items 800 800 500 - 1230 Supplies, equipment < $5000 4,500 4,500 3,000 3,000 Miscellaneous office equip (eticket paper) 800 - - - Laptop - 800 1,000 - SLR camera for Investigations add PSO camera $200 - 2,000 - - Shredder - 3,000 - - Rifle mounts (10@$300 each) - 4,000 - - Bicycles and racks for park patrol (3) 4,000 - 800 800 Alco-sensor portable breath test (PBT's) ($800 each) 10,300 10,300 9,300 9,300 (2) squad computers $7,000, light bar $2,300 19,600 24,600 14,100 13,100 1600 Supplies, operating 3,750 3,400 3,000 3,000 Photo print supplies, fire extinguishers, gloves, inkjet cartridges, toner, etc. 700 700 600 600 K9 Food 500 500 500 500 Portable radio batteries (10) @ $50 2,500 2,500 5,000 5,000 Batteries, breathalyzer parts, DVD's & CD's, disinfectant, simulation ammo ammunition, crime scene tape, emergency blankets, etc. 7,450 7,100 9,100 9,100 1700 Motor, fuels, & lubs -42,300 38,775 32,430 35,250 Unleaded gas 14,100 gallons @ $2.50/gal. 1,125 1,032 863 938 K9 take home car gas 375 gallons @ $2.50 43,425 39,807 33,293 36,188 2100 Books & periodicals 900 900 900 300 Traf. law, crim. law, HR, employ. law, school year books, & misc. books 900 900 900 300 2400 Uniforms & clothing 710 710 775 775 Chief 710 710 775 775 Deputy Chief 4,000 4,000 4,000 4,000 Initial officer set-ups replacing up to two retiring officers 12,070 12,070 13,175 13,190 14 officers @ $775, 3 sgts @ $780 - 2018, $800 - 2019 1,080 1,080 1,080 1,080 Administrative assistant, Clerk-typist, Community Service Officer 3@$360 1,000 1,000 1,000 1,000 Traffic vests, Taser holsters, & misc items 19,570 19,570 20,805 20,820 3020 Legal, prosecuting attorney 74,214 76,398 78,690 78,690 Retainer ($6,430 per month)(misc charges $1,530) 74,214 76,398 78,690 78,690 3030 Other professional services 700 700 900 900 Tobacco compliance project 150 150 150 150 Hazardous material disposal fee 1,500 1,500 1,400 1,400 Lab fees, blood tests, physical tests, video, misc. 240 240 240 240 Automated Pawn service 1,000 1,000 1,000 1,000 Civil Service and medical testing for new officers 3,590 3,590 3,690 3,690 3050 Dispatching 109,819 106,426 107,131 106,714 Ramsey County dispatching 109,819 106,426 107,131 106,714 3055 Informational systems fees 2,101 2,101 2,080 2,080 State service fee - CJDN ($510 per quarter) - - 2,350 2,350 BCA connectivity charge thru Ramsey Cty for CAD (new) 515 525 525 525 IACP.net ($525 annual) 2,616 2,626 4,955 4,955 3070 COPS events 500 700 1,000 6,000 National night out, town hall meeting, child ID, stickers, shop, bowl, other outr 500 700 1,000 6,000 3080 Veterinarian services 4,200 4,500 1,000 1,000 Hillcrest Veterinary Hospital 1,000 1,000 500 500 K9 vet services 5,200 5,500 1,500 1,500 3100 Telephone 2,600 6,420 6,420 5,100 Verizon cell phones (12 phones)(8 smart, 4 basic)($420 accessories) - - - 3,782 Air cards for squads CAD (9) at $35.01 per month (moved from 5100) 2,600 6,420 6,420 8,882 3210 Electricity 320 320 320 320 Civil defense siren's electricity 320 320 320 320 18 THIS PAGE LEFT BLANK INTENTIONALLY 19 Fund: 100 Department: 4200 Police Account Description 2015 2016 2017 2018 Description 3430 Printing 800 500 500 400 Dept manual, Emergency management manual, business cards, 800 500 500 400 3610 Memberships 100 - - - Assoc. Metro Emergency Managers 50 50 50 - FBI/LEEDA Law Enfor. Execu. Devel. Assoc. 2@ $50 75 75 75 75 Tri-County Investigator Association 45 45 45 45 Mn Crime Prevention Association 100 130 130 - MN Emergency Managers Assoc. 420 420 420 420 Mn Police chiefs 129 129 150 150 IACP (International Association of Chief of Police) 36 36 36 36 MN Sex Crime Investigators Assoc. 30 30 30 30 Natl. Assoc. School Resource Officers 100 100 100 100 K9 memberships 200 200 200 200 Notary commission (3 year due in 2012)($120+$20) 630 630 630 630 POST license reimbursement 7 @ $90 30 30 35 35 Prof. Law Enforcement Admin. Assoc. 25 35 35 35 National Association of Town Watch 1,970 1,910 1,936 1,756 3630 Training 600 600 710 710 MN Chief's conference 2@$355 200 200 400 400 BCA/CJDN training (new records tech) 320 320 450 450 Intox certification (6@$75) 1,000 1,000 1,000 1,000 Range Rental 400 400 400 400 MN Sex Crimes Investigators Assoc Conference 3,000 3,000 2,000 2,000 Tuition reimbursement 1,200 1,200 1,400 3,000 Supervisor training 1,500 1,400 1,400 1,400 K9 training 600 600 600 600 Emergency Management training 1,700 1,700 1,700 4,000 Employee development courses 1,615 1,615 1,615 1,615 Patrol on-line program 695 795 795 795 Post training for officers at Century College (1 officers) 12,830 12,830 12,470 16,370 4800 Insurance & bonds 25,000 25,000 25,000 25,000 Liability and automotive insurance 14,100 14,100 14,100 14,500 Insurance per MN Statute 299A.465 25,000 25,000 15,000 15,000 Allowance for insurance policy deductibles 64,100 64,100 54,100 54,500 5100 Technology - maintenance 2,000 2,000 2,000 2,000 Computer network & technology assistance - City of Roseville agreements & support 1,800 1,800 1,000 1,000 Copier maintenance + overages 2,000 2,000 2,000 2,000 Automatic License plate reader maintenance - - - 2,500 Watch Guard body camera maintenance 3,840 3,840 3,782 - Air cards for squad CAD (9) at $35.01 per month (move to 3100) - 2,500 3,500 5,185 Milestone video maintenance and licenses - 2,428 3,110 3,777 NetMotion 2 factor authentication (state required) - - 313 313 CAD interface (Zuercher) 12,500 12,500 15,780 17,380 IT support for squad computers (Roseville) 129,894 20,355 21,373 21,373 Operating costs of police records management system and ticket writer 152,034 47,423 52,858 55,528 5130 Repairs, equipment 3,000 3,000 3,000 2,579 Misc. equipment repair - defibs, cameras, recorders, fax, printers. 450 450 400 800 Fire extinguisher recharging and inspection 1,500 - - - Squad mobile digital computer repairs 1,000 1,000 1,000 1,000 Civil Defense siren repair & maint. (all 3 were replaced in 06,07,08)(upgraded 4,350 4,000 2,000 2,000 Radio repair (one-time reprogramming fee $50) 1,440 1,440 1,440 1,461 800 MHZ radio licenses fees 39 @ 3.12 per month 11,740 9,890 7,840 7,840 7030 Equipment > $5000 5,000 5,000 - - Video Recording system - Interview and breath test rooms 14,400 - - - AED replacement (9) @ $1,600 (grants of $2500, $3200, $1600) 19,400 5,000 - - 553,478 436,410 412,108 426,653 42.73%-21.15%-5.57%3.53% 20 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Contractual services 3030 Fire inspection services 5,249 17,412 12,763 15,500 125 15,500 - 0.00% 3032 Contractual fire services 334,179 356,039 372,284 379,163 252,776 423,393 44,230 11.67% 3050 Dispatching - 4,759 5,296 6,000 7,449 8,500 2,500 41.67% Total contractual services 339,428 378,210 390,343 400,663 260,350 447,393 46,730 11.66% Capital outlays: 7040 Vehicles & equipment 22,900 38,925 55,059 40,655 40,655 61,457 20,802 51.17% Total capital outlays 22,900 38,925 55,059 40,655 40,655 61,457 20,802 51.17% Debt Service: 8010 Principal 40,636 113,336 124,284 109,649 - 75,135 (34,514) -31.48% 8020 Interest 108,267 37,463 22,495 16,229 - 19,319 3,090 19.04% Total debt service 148,903 150,799 146,779 125,878 - 94,454 (31,424) -24.96% Total Fire 511,231 567,934 592,181 567,196 301,005 603,304 36,108 6.37% 2013 Fire Improvement Refunding Bonds will be retired in 2025 2017 Equipment Certificates will be retired in 2020 2018 Budget Summary 21 Fund: 100 Department: 4210 Fire Account Description 2015 2016 2017 2018 Description 3030 Fire inspection services 15,500 15,500 15,500 15,500 Contractual fee for Fire Marshalling services (SBM) 15,500 15,500 15,500 15,500 3032 Contractual fire services 356,039 372,283 379,163 423,393 Share of joint fire dept. costs (14-16.357%,15-16.424%,16-16.099%,17-15.819%) 356,039 372,283 379,163 423,393 3050 Dispatching 4,355 4,900 6,000 8,500 Anoka County dispatching fee 4,355 4,900 6,000 8,500 7040 Capital, vehicles & equipment 38,925 55,059 40,655 61,457 Share of joint fire department's capital costs 38,925 55,059 40,655 61,457 8010 Principal - Fire bond 63,232 73,251 74,056 75,135 16.158% of principal payment on 2013 refunding Fire bonds Principal - Equip Certs 52,557 50,712 35,593 - 16.158% of principal payment on 2017 Equipment Certificates 8020 Interest - Fire bond 33,629 22,081 12,453 12,127 16.158% of interest payment on 2013 refunding Fire bonds Interest - Equip Certs 1,381 736 3,776 7,192 16.158% of interest payment on 2017 Equipment Certificates 150,799 146,780 125,878 94,454 565,618 594,522 567,196 603,304 7.67%5.11%-4.60%6.37% 22 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Recreation (100 - 4350): Contractual services: 3036 Contractual recreation 98,467 111,289 108,241 113,787 51,812 117,349 3,562 3.13% 4800 Bonding & insurance 1,122 1,140 1,117 1,700 542 1,500 (200) -11.76% Total contractual services 99,589 112,429 109,358 115,487 52,354 118,849 3,362 2.91% Total Recreation 99,589 112,429 109,358 115,487 52,354 118,849 3,362 2.91% 2018 Budget Summary 23 Fund: 100 Department: 4350 Recreation Account Description 2015 2016 2017 2018 Description 3036 Contractual recreation 102,200 103,713 105,787 110,349 YMCA Mgt contract (39.5% of $279,364)(est. inflation + 1.5%)(use 3.2%) 8,700 9,000 8,000 7,000 Ice Skating supervision 110,900 112,713 113,787 117,349 4800 Bonding & insurance 1,700 1,700 1,700 1,500 Insurance & bonding cost. 1,700 1,700 1,700 1,500 112,600 114,413 115,487 118,849 5.04%1.61%0.94%2.91% 24 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent 2018 Budget Summary Parks (100 - 4360): Personnel services 0100 Salaries, regular 99,541 116,799 121,805 123,859 48,169 127,279 3,420 2.76% 0110 Overtime, regular 6,498 8,569 11,190 5,068 4,551 5,208 140 2.76% 0150 Salaries, part-time 35,701 29,448 24,469 33,180 2,914 33,180 - 0.00% 0300 Social Security 10,335 11,318 11,479 12,401 4,207 12,673 272 2.19% 0321 PERA 7,697 9,376 9,917 9,670 3,858 9,937 267 2.76% 0322 Pension expense GASB 68 - - 1,194 - - - - 0.00% 0400 Group insurance 17,532 20,899 21,399 24,354 5,003 25,554 1,200 4.93% 0500 Workers compensation 7,274 9,129 8,864 10,148 3,968 8,545 (1,603) -15.80% 0600 Unemployment 2,701 3,275 3,806 - - - - 0.00% Total personnel services 187,279 208,813 214,123 218,680 72,670 222,376 3,696 1.69% Materials & supplies: 1210 Supplies, bldgs & grnds 7,777 6,456 11,681 12,600 2,282 10,600 (2,000) -15.87% 1220 Supplies, vehicles & mowers 8,565 4,321 - 8,000 - 6,500 (1,500) -18.75% 1230 Supplies, equipment 9,803 6,693 6,583 8,500 2,031 6,250 (2,250) -26.47% 1600 Supplies, operating 8,131 14,461 9,788 10,900 1,403 10,900 - 0.00% 1700 Motor fuels & lubs 14,337 11,692 6,609 7,580 622 8,200 620 8.18% 2400 Uniforms & clothing 963 1,046 1,241 1,370 322 1,370 - 0.00% 2410 Mats & towels 479 609 704 728 219 728 - 0.00% Total materials & supplies 50,055 45,278 36,606 49,678 6,879 44,548 (5,130) -10.33% Contractual services: 3030 Other professional services 8,168 9,744 10,456 10,300 3,914 10,300 - 0.00% 3100 Telephone 1,272 1,575 2,014 2,056 424 2,056 - 0.00% 3200 Water & sewer 6,401 5,442 3,928 6,500 88 6,500 - 0.00% 3210 Electricity 9,689 10,214 9,711 10,000 3,088 10,000 - 0.00% 3220 Natural gas 9,121 4,546 4,057 4,800 2,291 4,800 - 0.00% 3530 Refuse collection - - 87 - - 0.00% 3610 Memberships 65 - 40 90 60 90 - 0.00% 3630 Training & conferences 740 913 736 1,670 175 1,670 - 0.00% 3900 Grants & subsidies 10,608 11,500 11,500 11,500 - 11,500 - 0.00% 4010 Rental, equipment 1,260 1,096 705 3,900 - 2,000 (1,900) -48.72% 4030 Portable restrooms 5,642 4,884 6,306 5,000 1,243 5,000 - 0.00% 4800 Bonding & insurance 12,010 10,729 10,659 16,000 5,103 15,000 (1,000) -6.25% 5110 Repairs, bldg & grounds 5,229 4,185 9,567 13,250 1,429 9,250 (4,000) -30.19% 5130 Repairs, equipment - - 1,590 - - - - 0.00% Total contractual services 70,205 64,828 71,356 85,066 17,815 78,166 (6,900) -8.11% Capital outlays 7030 Equipment 6,145 14,124 - 6,000 - - (6,000) -100.00% Total capital outlays 6,145 14,124 - 6,000 - - (6,000) -100.00% Total Parks 313,684 333,043 322,085 359,424 97,364 345,090 (14,334) -3.99% 110,106 107,962 140,744 122,714 25 Fund: 100 Department: 4360 Parks Account Description 2015 2016 2017 2018 Description 1210 Supplies, bldgs & grounds 200 200 200 200 Replace bleacher parts 200 200 200 200 Repair hockey boards, gates 300 300 300 300 Sod 3,000 2,000 2,000 2,000 County 10 trailway landscaping mulch, shrubs, and plants 500 500 500 500 Janitorial supplies 150 150 150 150 Snow shovels 200 200 200 200 Ice melt 500 500 500 500 Round up 500 500 500 500 Perennial flowers for park signs 1,500 1,500 1,500 1,500 Damaged building components (windows, locks, etc.) 300 300 300 300 Graffiti remover 500 250 250 250 Goose repellent 2,500 2,000 2,000 2,000 Replace irrigation heads - - 2,000 - City Hall Park sign (estimate) 2,500 2,000 2,000 2,000 Seed, fertilizer 12,850 10,600 12,600 10,600 1220 Supplies, vehicles 7,000 7,000 6,000 3,500 Oil filters, mower blades, tires, vehicle registration fees, 3,000 3,000 2,000 3,000 Miscellaneous repairs 10,000 10,000 8,000 6,500 1230 Supplies, equipment < $5000 250 250 250 250 Drinking fountain parts 250 250 250 250 Field Lights 250 250 250 250 Park signage 1,000 1,000 1,000 1,000 Bases, jox boxes, etc. - 2,000 - - Drag for ball fields - - 1,750 - Gutter broom attachment - - 500 - Chain saw (emergency only)(every 2 years) 2,500 2,500 4,500 4,500 Replace park equipment, fixtures and misc parts 4,250 6,250 8,500 6,250 1600 Supplies, operating 2,000 2,000 2,500 2,500 Fiber fill for play lots & courts 200 200 200 200 Tri mix 1,700 2,000 2,000 2,000 Wood chips for trees 500 500 500 500 Ag-lime for fields 500 500 500 500 Surface drying compound 400 400 800 800 Nets 2,900 3,100 3,100 3,100 Field paint & chalk (partially reimb by school district) 800 800 800 800 Landscaping materials 500 500 500 500 Hand tools 9,500 10,000 10,900 10,900 1700 Motor fuels & lubes 4,500 4,500 5,060 5,500 2,200 gallons of unleaded gas @ $2.50 3,150 3,150 2,520 2,700 900 gallons of diesel fuel @ $3.00 7,650 7,650 7,580 8,200 2400 Uniforms & clothing 350 350 350 350 Clothing allowance 2.0 FTE 820 820 820 820 Uniforms 18.2% of $4,500 200 200 200 200 Safety glasses, masks, ear protection, etc. 1,370 1,370 1,370 1,370 2410 Mats & towels 910 728 728 728 Share of floor mats and shop towels 18.2% of $4,000 910 728 728 728 3030 Other professional services 240 240 240 240 Fire extinguisher inspection/maint. (2@ $120) 600 600 600 600 HVAC maintenance 840 840 960 960 Fire sprinkler testing (4@ $210) 120 120 120 120 Backflow prevention testing (2@ $60) 8,500 8,500 8,380 8,380 Broadleaf control 10,300 10,300 10,300 10,300 26 THIS PAGE LEFT BLANK INTENTIONALLY 27 Fund: 100 Department: 4360 Parks (continued) Account Description 2015 2016 2017 2018 Description 3100 Telephone 985 1,206 1,206 1,206 Cellular phones (13.1% of $9,200) 850 850 850 850 GPS units for mowers (split with dept 4472) 1,835 2,056 2,056 2,056 3200 Water & wastewater 7,000 7,000 6,500 6,500 Parkland irrigation & park bathrooms 7,000 7,000 6,500 6,500 3210 Electricity 7,200 7,200 10,000 10,000 Est. 5 park buildings, park sec. lighting, court & field lighting & misc. 7,200 7,200 10,000 10,000 3220 Natural gas 4,800 4,800 4,800 4,800 Heating cost for Random, Hillview, Groveland, & Lambert Park bldgs. 4,800 4,800 4,800 4,800 3610 Memberships 40 40 40 40 Minnesota Safety Council 50 50 50 50 Playground inspector license 60 - - - Pesticide license renewal (every 2 years) 150 90 90 90 3630 Training & conferences 75 75 75 75 Computer classes 100 100 100 100 Hearing tests/RTN training (2@$50) 60 60 60 60 Maintenance EXPO 110 110 110 110 Loss control workshops 750 750 750 750 Playground inspection training (Certified Playground Safety Inspector CPSI) 375 375 375 375 Equipment training (18.2% of $2,050) - 200 200 200 Pesticide application class (every 2 years) 1,470 1,670 1,670 1,670 3900 Grants & subsidies 11,500 11,500 11,500 11,500 Lakeside Park share of operating costs 11,500 11,500 11,500 11,500 4010 Rental, equipment 500 2,900 3,900 2,000 Tools and equipment (sod cutter, chipper, concrete mixer, etc...) 500 2,900 3,900 2,000 4030 Portable restrooms 4,850 4,850 5,000 5,000 For May thru Oct, plus special events such as tournaments, & extra cleanings and insurance 4,850 4,850 5,000 5,000 4800 Bonding & insurance 12,000 12,000 12,000 11,000 Insurance policy premiums 4,000 4,000 4,000 4,000 Allowance for insurance policy deductibles 16,000 16,000 16,000 15,000 5110 Repairs, bldgs & grounds 750 750 750 750 Windows, doors, & lock repairs - - 4,000 - Sandblast trash cans and paint 1,000 1,000 1,000 1,000 Building exterior repairs 1,500 7,750 1,500 1,500 Irrigation system repairs (Silver View Park irrigation vault $6,250) 1,000 1,000 1,000 1,000 Field light repairs - 2,500 2,500 2,500 Repairs to playground equipment 2,500 2,500 2,500 2,500 Repairs to furnaces, plumbing, phones, electrical, etc 6,750 15,500 13,250 9,250 7030 Capital, equipment > $5000 - - 6,000 - Trencher (irrigation repairs and oak wilt treatments) - - 6,000 - 118,885 130,464 140,744 122,714 -14.74%9.74%7.88%-12.81% 28 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent 2018 Budget Summary Forestry (100 - 4380): Personnel services 0100 Salaries, regular - 2,820 3,006 2,928 1,214 3,009 81 2.77% 0110 Overtime, regular - 118 185 - 41 - - 0.00% 0300 Social Security - 203 219 224 95 230 6 2.68% 0321 PERA - 221 238 220 90 226 6 2.73% 0400 Group insurance - 530 584 630 37 666 36 5.71% 0500 Workers compensation - 168 160 184 72 155 (29) -15.76% Total personnel services - 4,060 4,392 4,186 1,549 4,286 100 2.39% 0.00% Materials & supplies 1200 Supplies, landscaping 3,018 1,944 1,949 5,900 495 4,400 (1,500) -25.42% Total materials & supplies 3,018 1,944 1,949 5,900 495 4,400 (1,500) -25.42% Contractual services 3030 Professional services 2,909 1,577 6,740 11,500 - 8,000 (3,500) -30.43% 3520 Tree removal 11,437 26,727 15,965 25,000 2,800 25,000 - 0.00% 3630 Training & conferences 15 170 428 900 100 900 - Total contractual services 14,361 28,474 23,133 37,400 2,900 33,900 (3,500) -9.36% Total Forestry 17,379 34,478 29,474 47,486 4,944 42,586 (4,900) -10.32% 30,418 25,082 43,300 38,300 29 Fund: 100 Department: 4380 Forestry Account Description 2015 2016 2017 2018 Description 1200 Supplies, landscaping 400 400 400 400 Landscaping materials 1,000 1,000 2,000 1,500 Small trees to replace damaged trees 2,000 2,000 3,000 2,500 Large trees - storm damage replacement 5,000 5,000 - - Ash tree replacement trees (MN DNR grant) 2,500 500 500 - EAB treatment supplies 10,900 8,900 5,900 4,400 3030 Professional services 10,000 5,000 5,000 5,000 Tree trimming 500 500 500 500 Asset mgt. software 25,000 15,000 5,000 2,500 Forestry consulting 1,000 1,000 1,000 - Tree injections (Ash every 2 years) 36,500 21,500 11,500 8,000 3520 Tree removal 28,000 25,000 25,000 25,000 Remove or treat diseased trees 7,500 7,500 - - Ash tree removal (MN DNR grant) 35,500 32,500 25,000 25,000 3630 Training & memberships 300 800 800 800 Tree Inspector training 100 100 100 100 Tree Inspector license 400 900 900 900 83,300 63,800 43,300 38,300 -14.12%-23.41%-32.13%-11.55% 30 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Public Works Administration (100-4410): Personnel services: 0100 Salaries, regular 107,821 86,232 101,413 106,006 40,296 107,579 1,573 1.48% 0110 Salaries, overtime 141 - - - - - - 0.00% 0300 Social Security 7,782 5,856 7,223 8,109 2,869 8,230 121 1.49% 0321 PERA 7,753 5,843 7,562 7,950 3,010 8,069 119 1.50% 0400 Group insurance 13,202 11,422 14,579 16,416 6,310 17,334 918 5.59% 0500 Workers compensation 1,839 1,885 1,215 1,405 549 1,185 (220) -15.66% Total personnel services 138,538 111,238 131,992 139,886 53,034 142,397 2,511 1.80% Materials & supplies: 1230 Supplies, equipment 130 - - - - - - 0.00% 1600 Operating supplies 297 300 45 300 300 230 (70) -23.33% 2400 Uniforms & clothing - 56 180 400 - 200 (200) -50.00% Total materials and supplies 427 356 225 700 300 430 (270) -38.57% Contractual services: 3030 Other professional services 524 336 1,073 900 217 900 - 0.00% 3100 Telephone 636 616 709 773 193 773 - 0.00% 3610 Memberships 632 430 507 490 435 755 265 54.08% 3630 Training & conferences 490 600 1,164 895 192 895 - 0.00% 3800 Mileage reimbursement 290 203 - 300 - 150 (150) -50.00% Total contractual services 2,572 2,185 3,453 3,358 1,037 3,473 115 3.42% Total public works administration 141,537 113,779 135,670 143,944 54,371 146,300 2,356 1.64% 2,541 3,678 4,058 3,903 2018 Budget Summary 31 Fund: 100 Department: 4410 Public Works Adminstration Account Description 2015 2016 2017 2018 Description 1600 Operating Supplies 230 230 230 230 Office supplies 70 70 70 - National Public Works Week posters 300 300 300 230 2400 Uniforms & clothing 400 400 400 200 33% of Supervisor's uniform cost. 400 400 400 200 3030 Other professional services 100 100 100 100 Physicals & drug testing - new employee 500 500 500 500 Asset mgt software 300 300 300 300 Drug & alcohol testing - federal mandate 900 900 900 900 3100 Telephone 630 773 773 773 Cellphone (8.4% of $9,200) 630 773 773 773 3610 Memberships/license fee 190 375 400 400 American Public Works Association memb. (APWA) (1/2 of $800) 60 60 60 60 City Engineer's Association of MN (CEAM) - - - - NASASP (National Assoc. of State Agencies for Surplus Property) 30 30 30 30 MN Safety Council - 265 - 265 MN Board of AELSLAGID (PE Renewal even years) 250 - - - American Society of Civil Engineers 530 730 490 755 3630 Training & conferences 500 1,500 500 500 CEAM / APWA conferences 50 50 50 50 Computer classes/Web training 15 15 15 15 Hearing tests/RTN training (.34 FTE@$50) 30 30 30 30 Maintenance Expo 200 200 200 200 Required continuing education seminars 100 100 100 100 Supervisor training 895 1,895 895 895 3800 Mileage reimbursement 300 300 300 150 vehicle mileage reimbursement 300 300 300 150 3,955 5,298 4,058 3,903 5.05%33.96%-23.41%-3.82% 32 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent 2018 Budget Summary Building & Grounds Maintenance (100 - 4460): Personnel services: 0100 Salaries, regular 12,389 13,885 14,106 14,141 5,202 14,530 389 2.75% 0110 Salaries, overtime 626 382 447 1,048 145 1,077 29 2.77% 0300 Social Security 946 1,052 1,065 1,161 277 1,193 32 2.76% 0321 PERA 934 1,053 1,071 1,140 261 1,171 31 2.72% 0400 Group insurance 2,943 2,413 2,468 2,952 632 3,114 162 5.49% 0500 Workers compensation 641 1,153 828 945 370 800 (145) -15.34% Total personnel services 18,479 19,938 19,985 21,387 6,887 21,885 498 2.33% Materials & supplies: 1210 Supplies, building & grounds 2,283 3,762 2,065 2,000 3,289 2,000 - 0.00% 1220 Supplies, vehicles - 68 - - - - - 0.00% 1230 Supplies, equipment 825 209 90 1,300 - 1,000 (300) -23.08% 1600 Supplies, operating 2,534 3,570 3,077 4,300 204 4,300 - 0.00% 2400 Uniforms & clothing 103 91 132 117 36 117 - 0.00% 2410 Mats & towels 925 750 1,295 630 287 1,000 370 58.73% Total materials & supplies 6,670 8,450 6,659 8,347 3,816 8,417 70 0.84% Contractual services: 3030 Other professional services 18,737 31,200 27,483 36,160 12,295 35,960 (200) -0.55% 3100 Telephone 112 97 117 129 34 129 - 0.00% 3200 Water & sewer 807 786 949 1,000 187 1,000 - 0.00% 3210 Electricity 28,341 27,793 26,149 14,000 7,734 20,000 6,000 42.86% 3220 Natural gas 26,488 17,502 12,446 19,000 9,736 17,000 (2,000) -10.53% 3530 Refuse collection 7,806 7,611 7,954 9,334 4,632 8,500 (834) -8.94% 3610 Memberships 10 - - - - - - 0.00% 3630 Training & conferences 19 10 19 - - - - 0.00% 4010 Rental, equipment - - - 200 - 200 - 0.00% 4800 Insurance 4,621 4,694 4,598 7,000 2,233 7,000 - 0.00% 5110 Repairs, bldgs & grounds 10,208 24,920 3,129 11,100 9,435 10,100 (1,000) -9.01% 5130 Repairs, equipment 4,409 2,179 6,729 5,000 702 5,000 - 0.00% Total contractual services 101,558 116,792 89,573 102,923 46,988 104,889 1,966 1.91% 125,242 96,232 111,270 113,306 Capital outlays 7030 Equipment - 246,729 - - - - - 0.00% Total capital outlays - 246,729 - - - - - 0.00% Total buildings & grounds 126,707 391,909 116,217 132,657 57,691 135,191 2,534 1.91% 33 Fund: 100 Department: 4460 Building & Ground Maintenance Account Description 2015 2016 2017 2018 Description 1210 Supplies, bldgs & grounds 2,000 2,000 2,000 2,000 Bldg repairs, cleaning/heating supplies, batteries 2,000 2,000 2,000 2,000 1230 Supplies, equipment < $5000 1,300 1,300 1,300 1,000 Repair parts, filters, hoses, etc., office furniture 1,300 1,300 1,300 1,000 1600 Supplies, operating 500 1,500 1,500 1,500 Cleaning supplies 300 150 150 150 Lumber & fasteners 550 300 300 300 Repair items & hardware 300 100 100 100 First aid supplies 500 200 200 200 Light bulbs & ballasts 500 750 750 750 Paper supplies 500 400 400 400 Mechanical items, fans, motors, etc 100 - - - Goose repellent 200 - - - Weed control - city hall 200 200 200 200 Office supplies 700 700 700 700 Paint & supplies - parking lot & building 4,350 4,300 4,300 4,300 2400 Uniforms & clothing 81 81 81 81 Uniforms (1.8% of $4,500) 36 36 36 36 Clothing & boot allowance (.20 @$175) 117 117 117 117 2410 Mats & towels 90 90 90 90 Share of floor mats and shop towels (1.8% of $5,000) 540 540 540 910 Floor mats at CH ($45/month) 630 630 630 1,000 3030 Other professional services 180 180 180 180 Backflow prevention testing (3@$60) 60 60 60 60 Boiler & pressure vessel registration program 5,500 5,520 5,520 5,520 HVAC maintenance (City Hall & PW facilities) 100 100 100 100 MN DOL operating permit - elevator (previously in acct. 5110) 18,000 19,500 19,500 19,500 City Hall cleaning contract (renews in 2016) 3,500 3,500 3,500 3,500 Carpet cleaning, floor striping & waxing (2 times) 680 680 680 680 Fire sprinkler testing 1,320 1,320 1,320 1,320 Pest control (12@$110) 200 200 200 - MDH Monitoring well maint. permit - PW bldg. (wells sealed) - - 4,500 4,500 Service contract for generator 600 600 600 600 Fire extingiusher inspection/service (30@$20) 30,140 31,660 36,160 35,960 3100 Telephone 120 129 129 129 Cellphone (1.6% of $7,500)($9,200) 120 129 129 129 3200 Water & Sewer 1,400 1,400 1,000 1,000 Service at City Hall and Public Works buildings 1,400 1,400 1,000 1,000 3210 Electricity 28,000 14,000 14,000 20,000 Electricity at City Hall and Public Works buildings 28,000 14,000 14,000 20,000 3220 Natural gas 20,000 20,000 19,000 18,000 Natural gas at City Hall and Public Works buildings 20,000 20,000 19,000 18,000 3530 Refuse collection 3,161 1,630 1,030 196 Hazardous waste disposal, Lamps $100, batteries $30 264 264 264 264 Hazardous waste annual fee (State of MN PCA) 230 90 90 90 Hazardous waste generator license fee (Ramsey County) 150 150 150 150 Used oil filters ($100 in vehicle maint.) 7,200 7,200 7,800 7,800 Facility dumpsters, city hall, public works 11,005 9,334 9,334 8,500 4010 Rental, equipment 200 200 200 200 Misc. rentals 200 200 200 200 4800 Bonding & insurance 5,500 5,500 5,500 5,500 Insurance policy premiums 1,500 1,500 1,500 1,500 Allowance for insurance policy deductibles 7,000 7,000 7,000 7,000 5110 Repairs, bldgs & grounds 2,500 2,500 2,500 1,500 Door & gate opener repairs 2,500 2,500 2,500 2,500 Building repairs 750 750 750 750 Elevator maintenance & repairs 350 350 350 350 Fire sprinklers & alarm repairs 5,000 5,000 5,000 5,000 General building & ground maintenance 11,100 11,100 11,100 10,100 5130 Repairs, equipment 5,000 5,000 5,000 5,000 HVAC, plumbing & electrical repairs 5,000 5,000 5,000 5,000 122,362 108,170 111,270 114,306 7.17%-11.60%2.87%2.73% 34 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent 2018 Budget Summary Vehicle & Equipment Maintenance (100 - 4465): Personnel services: 0100 Salaries, regular 33,251 34,939 29,313 36,826 13,730 39,644 2,818 7.65% 0110 Salaries, overtime 1,110 - - 556 254 602 46 8.27% 0300 Social Security 2,492 2,540 2,133 2,860 1,000 3,078 218 7.62% 0321 PERA 2,490 2,579 2,188 2,804 1,044 3,019 215 7.67% 0400 Group insurance 5,565 4,635 4,767 7,344 3,083 7,650 306 4.17% 0500 Workers compensation 1,628 2,487 1,648 1,785 698 1,581 (204) -11.43% Total personnel services 46,536 47,180 40,049 52,175 19,809 55,574 3,399 6.51% Materials & supplies: 1220 Supplies, vehicles 16,616 9,522 17,722 19,950 4,883 19,950 - 0.00% 1230 Supplies, equipment 4,752 5,027 4,378 4,100 4,570 5,500 1,400 34.15% 1600 Supplies, operating 3,771 6,404 6,065 4,200 1,015 4,650 450 10.71% 1700 Motor fuels & lubricants - unleade 4,051 2,074 3,359 3,260 764 3,260 - 0.00% 1701 Motor fuels & lubricants - diesel 7,663 85 - - 5,309 - - 0.00% 2400 Uniforms & clothing 414 878 654 375 85 375 - 0.00% 2410 Mats & towels 180 185 190 220 55 220 - 0.00% Total materials & supplies 37,447 24,175 32,368 32,105 16,681 33,955 1,850 5.76% Contractual services: 3030 Other professional services 18 17 25 - - 0.00% 3100 Telephone 263 228 268 387 96 387 - 0.00% 3530 Refuse collection - - - 100 221 100 - 0.00% 3610 Memberships 606 - - 80 30 80 - 0.00% 3630 Training 283 54 203 920 - 625 (295) -32.07% 4010 Rental, equipment - - - 100 - 100 - 0.00% 5120 Repairs, vehicles 19,894 6,872 7,114 16,800 4,654 16,800 - 0.00% 5130 Repairs, equipment 4,914 5,805 6,939 5,500 - 5,500 - 0.00% Total contractual services 25,978 12,976 14,549 23,887 5,001 23,592 (295) -1.23% Capital outlays 7030 Equipment 6,050 - - - - - - 0.00% Total capital outlays 6,050 - - - - - - 0.00% Total vehicle & equipment maintenance 116,011 84,331 86,966 108,167 41,491 113,121 4,954 4.58% 37,151 46,917 55,992 57,547 35 Fund: 100 Department: 4465 Vehicle & Equipment Maintenance Account Description 2015 2016 2017 2018 Description 1220 Supplies, vehicles 200 200 200 200 Brake fluid 700 700 700 700 Misc parts, fastners 500 500 500 500 Anti freeze 300 300 300 300 Air conditioning gas 500 500 500 500 Headlamps, spots, & bulbs 800 800 800 800 Tune up items 500 500 500 500 Wiper blades & fluid 1,950 1,950 1,950 1,950 Minor repairs, rebuilds 1,500 1,500 1,500 1,500 Automotive parts 2,000 2,000 2,000 2,000 Filters: oil, air, fuel, transmission 2,000 2,000 2,000 2,000 Brake pads & shoes 9,000 9,000 9,000 9,000 Tires & batteries 19,950 19,950 19,950 19,950 1230 Supplies, equipment < $5000 200 200 200 1,000 Small equipment tune up items 400 400 400 1,000 Filters belts & hoses 1,000 1,000 1,000 1,000 Hydraulic system repairs 2,500 2,500 2,500 2,500 Vehicle Asset Management software 3,700 3,700 - - Tire mounting machine (defer to 2016)(bought code scanner in 2015) 2,000 2,000 - - Tires 9,800 9,800 4,100 5,500 1600 Supplies, operating 1,200 1,200 1,200 1,000 Battery charger, Load tester 350 350 350 350 Welding supplies 100 100 100 500 Chains, clevises, & hitch pins 700 700 700 700 Equipment & vehicle cleaning supplies 500 500 500 500 Steel for repairs & fabrication 350 350 350 350 License tabs 500 500 500 750 Solvents & degreasers 500 500 500 500 Fastners & electrical supplies 4,200 4,200 4,200 4,650 1700 Motor fuels & lubricants 60 60 60 60 Gear lube 200 200 200 200 ATF - 7 cases 500 500 500 500 Aftermarket additives 2,500 2,500 2,500 2,500 Engine oil: 150 gallons (synthetic) 3,260 3,260 3,260 3,260 2400 Uniforms & clothing 249 249 270 270 Uniforms 6% of $4,500) 105 105 105 105 Clothing and boot allowance (.6@$175) 354 354 375 375 2410 Mats & towels 275 220 220 220 Share of floor mats and shop towels (5.5% of $4,000) 275 220 220 220 3100 Communications 308 387 387 387 Cellular telephone (4.1% of $9,200) 308 387 387 387 3530 Refuse collection 100 100 100 100 Oil filter recycling ($150 in 4460-3530) 100 100 100 100 3610 Memberships 60 60 60 60 Vehicle inspection license renewal (DOT required) 20 20 20 20 Minnesota Safety Council (6% of $465) 80 80 80 80 3630 Training 30 30 30 30 Hearing test/RTN training (.6@$50) 30 30 30 30 Maintenance Expo 200 200 495 200 Misc training 175 175 175 175 ASE certification 75 190 190 190 Vehicle inspection recertification (DOT required) 510 625 920 625 4010 Rental, equipment 100 100 100 100 Specialty tool & equipment rental 100 100 100 100 5120 Repairs, vehicles 8,000 8,000 8,000 8,000 Accident repairs 750 750 750 750 Alignments 1,000 1,000 1,000 1,000 Glass replacement 400 400 400 400 Radiator repairs, replacement 2,000 2,000 1,960 1,960 Tire repairs 700 950 950 950 Ignition scanner software update 1,700 1,700 1,740 1,740 Mitchell On Demand Software 2,000 2,000 2,000 2,000 Transmission repairs 16,550 16,800 16,800 16,800 5130 Repairs, equipment 500 500 500 500 Accident repairs 3,000 3,000 3,000 3,000 Mechanical repairs 2,000 2,000 2,000 2,000 Motor repairs 5,500 5,500 5,500 5,500 7030 Capital, equipment > $5000 - - - - Hoist adaptor - - - - 60,987 61,376 55,992 57,547 2.50%0.64%-8.77%2.78% 36 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent 2018 Budget Summary Street Pavement Management (100 - 4470): Personnel services: 0100 Salaries, regular 102,349 114,727 116,046 117,480 44,206 119,344 1,864 1.59% 0110 Salaries, overtime 3,470 3,154 2,982 3,379 1,183 3,472 93 2.75% 0150 Salaries, part-time 5,910 5,452 3,872 7,488 455 7,488 - 0.00% 0300 Social Security 8,253 8,938 8,935 9,817 3,387 9,967 150 1.53% 0321 PERA 7,527 8,541 8,465 9,064 3,337 9,211 147 1.62% 0322 Pension expense GASB 68 - - 1,709 - - - - 0.00% 0400 Group insurance 11,703 13,953 14,585 18,972 5,347 19,782 810 4.27% 0500 Workers compensation 7,123 10,532 8,359 9,530 3,727 8,048 (1,482) -15.55% Total personnel services 146,335 165,297 164,953 175,730 61,642 177,312 1,582 0.90% Materials & supplies: 1230 Supplies, equipment 5,712 469 30 2,950 956 1,500 (1,450) -49.15% 1240 Supplies, streets 25,299 5,411 2,193 10,000 146 7,500 (2,500) -25.00% 1260 Supplies, traffic control 429 - 1,375 750 - 1,600 850 113.33% 1600 Supplies, operating 2,815 2,250 1,479 1,000 243 1,000 - 0.00% 1700 Motor fuels & lubricants 9,515 6,391 4,356 7,650 741 8,250 600 7.84% 2400 Uniforms & clothing 917 820 1,394 701 182 701 - 0.00% 2410 Mats & towels 351 397 399 436 116 436 - 0.00% Total materials & supplies 45,038 15,738 11,226 23,487 2,384 20,987 (2,500) -10.64% Contractual services: 3030 Other professional services 5,279 11,975 2,486 20,950 1,962 18,450 (2,500) -11.93% 3100 Telephone 756 641 718 966 228 966 - 0.00% 3610 Memberships 247 190 195 255 250 255 - 0.00% 3630 Training & conferences 583 760 838 1,115 - 1,115 - 0.00% 4010 Rental, equipment 1,125 4,500 850 6,100 2,500 6,100 - 0.00% 4800 Insurance 6,261 4,157 4,073 6,200 1,978 6,200 - 0.00% 5130 Repairs, equipment - 10 7 500 - 500 - 0.00% Total contractual supplies 14,251 22,233 9,167 36,086 6,918 33,586 (2,500) -6.93% Total street pavement management 205,624 203,268 185,346 235,303 70,944 231,885 (3,418) -1.45% 37,971 20,393 59,573 54,573 37 Fund: 100 Department: 4470 Pavement Management Account Description 2015 2016 2017 2018 Description 1230 Supplies, equipment < $5000 500 500 500 500 Safety vests and other safety equipment - - 1,000 1,000 Radio/hearing protection - - 500 - Push mower - - 450 - Chainsaw - - 500 - Backpack blower 500 500 2,950 1,500 1240 Supplies, street repair 20,000 20,000 7,500 5,000 Asphalt & concrete for street patching & curb repair 1,000 1,000 1,000 1,000 Disposal 1,500 1,500 1,500 1,500 Bituminous tack coat/crack fill material 22,500 22,500 10,000 7,500 1260 Supplies, traffic control 400 400 250 725 Traffic cones/baracades 600 600 500 875 portable signs (traffic control) 1,000 1,000 750 1,600 1600 Supplies, operating 650 650 850 850 Asphalt hand tools, rakes, etc. 100 100 150 150 Batteries, shop supplies, etc. 750 750 1,000 1,000 1700 Motor fuels & lubricants 5,250 5,250 4,200 4,500 Diesel fuel: 1500 gallons @ $3.00 4,500 4,125 3,450 3,750 Unleaded fuel: 1500 gallons @ $2.50 9,750 9,375 7,650 8,250 2400 Uniforms & clothing 491 491 491 491 Uniforms (10.9% of $4,500) 210 210 210 210 Clothing and boot allowance (1.2@$175) 701 701 701 701 2410 Mats & towels 545 436 436 436 Share of floor mats and shop towels (10.9% of $4,000) 545 436 436 436 3030 Other professional services 1,800 1,800 1,800 1,800 Pavement Mgmt software annual maintenance. 2,500 2,500 2,500 2,500 Engineering services. 500 500 500 500 Asset management software annual maintenance 500 650 650 650 ROW weed control 1,500 1,500 1,500 - Material dump charges 2,000 2,000 2,000 1,000 Sidewalk joint corrections - - 12,000 12,000 CSAH 10 median and ROW maintenance (mowing and weed wipping) - - - - Striping of streets (Ramsey County)(move to 4475) 8,800 8,950 20,950 18,450 3100 Communications 893 966 966 966 Cellular telephones (10.5% of $9,200) 893 966 966 966 3610 Memberships 190 190 200 200 American Public Works Association memb. (APWA) (1/4 of $800) - 15 15 15 Pesticide license renewal (TF) 40 40 40 40 MN Safety Council 230 245 255 255 3630 Training & conferences 50 50 50 50 Computer classes 200 200 200 200 Electronics updates, other classes 60 60 60 60 Hearing test/RTN training (1.16@$50) 60 60 60 60 Maintenance Expo 150 150 150 150 APWA/MN conferences. 250 250 250 250 Pavement, sealcoating, patching & sealcoating seminars. 210 210 210 210 Equipment operator training 60 60 60 60 Vehicle inspection license renewal 75 75 75 75 Vehicle inspection recertification 300 - - - Work zone traffic control (every 3 years) 1,415 1,115 1,115 1,115 4010 Rentals, equipment 2,800 2,800 3,600 3,600 Annual trade-in of skidsteer loaders (no trade-in during 2017) 700 2,500 2,500 2,500 Specialized equip rental (chipper, crack sealing,) 3,500 5,300 6,100 6,100 4800 Bonding & insurance 4,800 4,800 4,800 4,800 Insurance policy premiums 1,400 1,400 1,400 1,400 Allowance for insurnace policy deductibles 6,200 6,200 6,200 6,200 5130 Repairs, equipment 500 500 500 500 Misc. equipment repairs 5,000 - - - Repair crack filling machine (will not repair, rent instead)(see 4010) 5,500 500 500 500 62,284 58,538 59,573 54,573 -8.10%-6.01%1.77%-8.39% 38 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent 2018 Budget Summary Street Snow & Ice Control (100 - 4472): Personnel services: 0100 Salaries, regular 62,998 60,902 62,061 60,224 24,237 61,887 1,663 2.76% 0110 Salaries, overtime 19,281 7,711 9,926 8,130 3,654 8,353 223 2.74% 0300 Social Security 5,944 5,016 5,164 5,229 2,016 5,374 145 2.77% 0321 PERA 5,855 4,852 5,431 5,127 2,051 5,267 140 2.73% 0400 Group insurance 11,550 7,972 8,513 11,520 3,782 12,000 480 4.17% 0500 Workers compensation 6,116 8,074 6,538 7,464 2,919 6,323 (1,141) -15.29% Total personnel services 111,744 94,527 97,633 97,694 38,659 99,204 1,510 1.55% Materials & supplies: 1230 Supplies, equipment 19,758 8,185 1,942 9,500 517 7,400 (2,100) -22.11% 1600 Supplies, operating 41,589 24,726 25,005 31,175 1,960 31,175 - 0.00% 1700 Motor fuels & lubricants 13,786 3,586 3,215 2,980 418 3,180 200 6.71% 2400 Uniforms & clothing 457 397 487 528 156 528 - 0.00% 2410 Mats & towels 331 341 356 328 100 328 - 0.00% Total materials & supplies 75,921 37,235 31,005 44,511 3,151 42,611 (1,900) -4.27% Contractual services: 3030 Other professional services 1,592 1,321 1,400 1,325 - 1,375 50 3.77% 3100 Telephone and data cards 753 1,713 907 1,179 592 1,179 - 0.00% 3610 Memberships 70 - - 70 80 70 - 0.00% 3630 Training & conferences 84 118 185 285 - 285 - 0.00% 5130 Repairs, equipment 3,373 22 821 2,500 1,890 2,500 - 0.00% Total contractual supplies 5,872 3,174 3,313 5,359 2,562 5,409 50 0.93% Capital outlays 7030 Equipment 2,618 - - - - - 0.00% Total capital outlays 2,618 - - - - - - 0.00% Total streets snow & ice control 196,155 134,936 131,951 147,564 44,372 147,224 (340) -0.23% 40,409 34,318 49,870 48,020 39 Fund: 100 Department: 4472 Snow & Ice Control Account Description 2015 2016 2017 2018 Description 1230 Supplies, equipment < $5000 250 250 500 500 Filters - - 3,000 4,500 Skidsteer broom - - 4,000 - Snow blower for skid steer - - - 400 Chloride Tank 1,800 1,800 2,000 2,000 Cutting edges, plow shoes 2,050 2,050 9,500 7,400 1600 Supplies, operating 800 800 800 800 Welding supplies, steel stock, sod for boulevards, etc. 2,250 2,250 2,250 2,250 Liquid Mg Chloride: 1,500 gallons @ $1.50 per gallon. 28,000 28,125 28,125 28,125 Salt: 375 tons @ $75 per ton. 31,050 31,175 31,175 31,175 1700 Motor fuels & lubricants 180 180 180 180 Engine oil: 30 gallons @ $6.00 per gallon. 3,500 3,500 2,800 3,000 Diesel fuel: 1,000 gallons @ $3.00 per gallon. 3,680 3,680 2,980 3,180 2400 Uniforms & clothing 370 370 370 370 Uniforms (8.2% of $4,500) 158 158 158 158 Clothes & boots allowance (.9@$175) 528 528 528 528 2410 Mats & towels 410 328 328 328 Cost share of mats & towels (8.2% of $4,000) 410 328 328 328 3030 Other professional services 1,200 1,200 1,325 1,375 Weather service reports 1,200 1,200 1,325 1,375 3100 Telephone 473 579 579 579 Cellphone (6.3% of $7,500)($9,200) 360 1,680 600 600 GPS data cards 833 2,259 1,179 1,179 3610 Memberships 70 70 70 70 Minnesota Safety Council 70 70 70 70 3630 Training 75 75 85 85 Hearing tests/RTN training (1.1@$XX) 400 400 200 200 Defensive Driving class (2 staff) 475 475 285 285 5130 Repairs, equipment 2,500 2,500 2,500 2,500 Plow, blower, salt spreader repairs, paint plow assemblies 2,500 2,500 2,500 2,500 7030 Capital, equipment > $5000 5,600 - - - Plow control update (#445) 8,350 - - - GPS equipment for plow trucks 13,950 - - - 56,746 44,265 49,870 48,020 -10.64%-21.99%12.66%-3.71% 40 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent 2018 Budget Summary Street Sign Maintenance (100 - 4475): Personnel services: 0100 Salaries, regular 23,579 18,442 18,377 18,721 6,923 18,960 239 1.28% 0110 Salaries, overtime 450 657 547 845 184 868 23 2.72% 0150 Salaries, part-time - - - 2,496 - 2,496 - 0.00% 0300 Social Security 1,787 1,399 1,365 1,689 524 1,708 19 1.12% 0321 PERA 1,696 1,399 1,369 1,467 522 1,488 21 1.43% 0400 Group insurance 2,698 2,526 2,467 3,456 844 3,600 144 4.17% 0500 Workers compensation 2,188 1,966 1,561 1,778 695 1,497 (281) -15.80% Total personnel services 32,398 26,389 25,686 30,452 9,692 30,617 165 0.54% Materials & supplies: 1600 Supplies, operating 1,590 10,570 4,502 28,500 436 28,500 - 0.00% 2400 Uniforms & clothing 165 143 147 435 56 435 - 0.00% 2410 Mats & towels 119 122 125 160 36 160 - 0.00% Total materials & supplies 1,874 10,835 4,774 29,095 528 29,095 - 0.00% Contractual services: 3030 Other professional services - 11 3,762 500 - 4,500 4,000 800.00% 3100 Telephone 180 157 183 230 209 230 - 0.00% 3250 Electricity - traffic signals 2,569 2,906 2,647 3,000 794 3,000 - 0.00% 3630 Training & conferences 30 17 30 100 - 20 (80) -80.00% 5130 Repairs, equipment 291 - - 500 55 500 - 0.00% Total contractual supplies 3,070 3,091 6,622 4,330 1,058 8,250 3,920 90.53% Total street sign maintenance 37,342 40,315 37,082 63,877 11,278 67,962 4,085 6.40% 41 Fund: 100 Department: 4475 Street Sign Maintenance Account Description 2015 2016 2017 2018 Description 1600 Supplies, operating 17,500 17,500 17,500 17,500 Signs, posts, sign hardware, and supplies 7,500 7,500 7,500 7,500 Street name sign panels, posts, hardware 1,750 1,750 1,750 1,750 Pavement marking paint (moved from 4470) 500 500 500 500 Shop supplies - fastners, degreasers, etc 500 500 500 500 Graffitti remover - 750 750 750 (3) Traffic counters 27,750 28,500 28,500 28,500 2400 Uniforms & clothing 81 81 81 81 Uniforms (1.8% of $4,500) 354 354 354 354 Clothes and boot allowance (.2@$175) 435 435 435 435 2410 Mats & towels 340 160 160 160 Cost share of mats & towels (4% of $4,000) 340 160 160 160 3030 Other professional services 5,000 5,000 - 4,000 Contract pavement marking (Ramsey Co)(moved from 4470) 500 500 500 500 Asset management software annual maintenance 5,500 5,500 500 4,500 3100 Telephone 200 230 230 230 Cellphone (2.5% of $8,000)($9,200) 200 230 230 230 3250 Electricity - traffic signals 2,000 2,000 3,000 3,000 Electricity for traffic signals 2,000 2,000 3,000 3,000 3630 Training & conferences 80 80 80 - Equipment operator training 20 20 20 20 Hearing test/RTN trainging (.4@$50) 100 100 100 20 5130 Repairs, equipment 500 500 500 500 Traffic signal repairs & maintenance 500 500 500 500 36,825 37,425 33,425 37,345 289.68%1.63%-10.69%11.73% Grand Total all PW Departments 343,159 315,072 314,188 315,694 7.86%-8.18%-0.28%0.48% 42 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Convention & Visitor's Bureau (100-4653) Contractual services 3045 N Metro Convention Bureau 63,049 65,654 64,038 61,750 14,150 61,750 - 0.00% Total contractual services 63,049 65,654 64,038 61,750 14,150 61,750 - 0.00% Total Convention & Visitor's Bureau 63,049 65,654 64,038 61,750 14,150 61,750 - 0.00% Miscellaneous (100 - 4700): Personnel services 0300 Social security 248 210 171 - 72 - - 0.00% 0321 PERA 306 388 439 - 155 - - 0.00% 0400 Group insurance 489 488 540 - 184 - - 0.00% 0750 Fitness program 3,883 3,889 3,911 6,500 1,425 6,500 - 0.00% Total personnel services 4,926 4,975 5,061 6,500 1,836 6,500 - 0.00% Contractual services 3065 Family & youth social services 19,763 20,178 20,259 20,461 20,461 21,075 614 3.00% Total contractual services 19,763 20,178 20,259 20,461 20,461 21,075 614 3.00% Miscellaneous 9900 Transfers - EDA - 16,000 50,000 50,000 - 50,000 - 0.00% 9900 Transfers - Vehicle & Equip. Fund 100,000 110,000 150,000 175,000 - 200,000 25,000 14.29% 9900 Transfers - Special Projects 825,000 200,000 375,000 75,000 - 75,000 - 0.00% 9900 Community Center 165,000 170,000 170,000 175,000 - 175,000 - 0.00% Total miscellaneous 1,090,000 496,000 745,000 475,000 - 500,000 25,000 5.26% 0.00% Total miscellaneous 1,114,689 521,153 770,320 501,961 22,297 527,575 25,614 5.10% Debt Service (100 - 4750): Debt Service ESP 8011 Lease payable - 20,268 17,791 18,331 7,571 18,887 556 3.03% 8021 Interest - - 6,704 6,165 2,635 5,609 (556) -9.02% Total debt service - 20,268 24,495 24,496 10,206 24,496 - 0.00% 2018 Budget Summary 43 Fund: 100 Department: 4653 Convention & Visitor's Bureau Account Description 2015 2016 2017 2018 Description 3045 N Metro Convention Bureau 53,200 60,800 61,750 61,750 Payment of 95% of hotel/motel tax collections to (3% tax on gross receipts) support the promotion of tourism. (City retains 5% for administration) 53,200 60,800 61,750 61,750 Fund: 100 Department: 4700 Miscellaneous Account Description 2015 2016 2017 2018 Description 0750 Fitness program 6,500 6,500 6,500 6,500 Fitness program (maximum $55/month paid with employee sick leave time). 6,500 6,500 6,500 6,500 3065 Family & youth social services 20,178 20,783 20,461 21,075 Northeast Youth and Family Services (NYFS)(1% - 2017) 20,178 20,783 20,461 21,075 9900 Transfers - miscellaneous 10,000 50,000 50,000 50,000 Transfer to Economic Development Authority (EDA) 50,122 75,000 75,000 75,000 Transfer to Special Projects fund 60,122 125,000 125,000 125,000 9900 Transfers - miscellaneous 110,000 150,000 175,000 200,000 Transfer to Vehicle & Equipment Fund 110,000 150,000 175,000 200,000 9990 Community Center 170,000 170,000 175,000 175,000 Subsidy for Community Center operating costs 170,000 170,000 175,000 175,000 366,800 472,283 501,961 527,575 Fund: 100 Department: 4750 Debt Service Account Description 2015 2016 2017 2018 Description 8011 Lease payable - 24,323 18,331 18,887 Lease payable Energy Savings Program 8021 Interest - - 6,165 5,609 Interest - 24,323 24,496 24,496 44 THIS PAGE LEFT BLANK INTENTIONALLY 45 City of Mounds View 2018 Budget Summary Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 General Fund:Actual Actual Actual Budget Actual Request Dollar Percent Revenues: Property taxes - Base levy 3,363,602 3,651,411 3,700,381 3,833,967 - 3,828,967 (5,000) -0.13% Special tax levies, Bonds 156,348 154,119 154,119 90,835 - 99,177 8,342 9.18% Special tax levies, Operations 217,145 226,145 233,145 244,145 - 249,145 5,000 2.05% Franchise tax 336,711 309,039 296,173 280,000 116,511 285,000 5,000 1.79% Other taxes 109,002 47,877 27,556 29,000 - 29,000 - 0.00% Hotel/motel tax 66,367 69,109 67,408 65,000 16,465 65,000 - 0.00% Licenses and permits 246,969 204,845 184,499 180,522 115,758 182,972 2,450 1.36% Intergovernmental 941,697 1,038,060 1,090,100 976,636 64,679 1,049,757 73,121 7.49% Charges for services 14,933 18,942 40,988 16,325 12,903 16,825 500 3.06% Fines & forfeitures 40,239 36,338 29,278 39,000 9,033 36,600 (2,400) -6.15% Interest 521,224 112,669 104,985 115,000 32,122 115,000 - 0.00% Miscellaneous 355,678 321,188 342,547 295,826 274,698 282,696 (13,130) -4.44% Transfers: DARE Fund - 4,643 - - - - - 0.00% Water Fund 69,393 - - 75,828 - 78,103 2,275 3.00% Sewer Fund 54,962 56,611 58,309 60,058 - 61,860 1,802 3.00% Storm Water Fund 7,168 7,383 7,604 7,832 - 8,067 235 3.00% Street Light Fund 2,462 2,536 2,612 2,690 - 2,771 81 3.01% Vehicle & Equipment Fund 38,316 21,000 22,000 21,600 - 22,000 400 1.85% Debt proceeds - 246,729 - - - - - 0.00% Total revenues 6,542,216 6,528,644 6,361,704 6,334,264 642,169 6,412,940 78,676 1.24% Expenditures: Legislative Services: City Council 46,030 47,115 47,213 57,527 24,799 57,246 (281) -0.49% Advisory Commissions 14,315 8,720 15,520 15,500 550 17,000 1,500 9.68% Subtotal 60,345 55,835 62,733 73,027 25,349 74,246 1,219 1.67% Administrative Services: City Administrator 231,848 271,314 282,476 298,084 118,935 302,262 4,178 1.40% Elections 20,053 22,222 47,279 35,000 9,515 24,500 (10,500) -30.00% Finance 232,173 246,268 255,786 263,457 109,871 270,906 7,449 2.83% Central Services 207,551 216,482 237,713 255,645 88,350 254,533 (1,112) -0.43% Subtotal 691,625 756,286 823,254 852,186 326,671 852,201 15 0.00% Community Development 341,593 353,381 320,413 398,498 115,968 421,714 23,216 5.83% Police 2,481,263 2,710,053 2,719,071 2,751,241 1,111,995 2,894,933 143,692 5.22% Fire 511,231 567,934 592,181 567,196 301,005 603,304 36,108 6.37% Public Works Administration 141,537 113,779 135,670 143,944 54,371 146,300 2,356 1.64% Parks, Recreation & Forestry: Recreation 99,589 112,429 109,358 115,487 52,354 118,849 3,362 2.91% Parks 313,684 333,043 322,085 359,424 97,364 345,090 (14,334) -3.99% Forestry 17,379 34,478 29,474 47,486 4,944 42,586 (4,900) -10.32% Subtotal 430,652 479,950 460,917 522,397 154,662 506,525 (15,872) -3.04% Fleet Services: Building & Grounds Mtnce 126,707 391,909 116,217 132,657 57,691 135,191 2,534 1.91% Vehicle & Equipment Mtnce 116,011 84,331 86,966 108,167 41,491 113,121 4,954 4.58% Subtotal 242,718 476,240 203,183 240,824 99,182 248,312 7,488 3.11% Streets: Pavement Management 205,624 203,268 185,346 235,303 70,944 231,885 (3,418) -1.45% Snow & Ice Control 196,155 134,936 131,951 147,564 44,372 147,224 (340) -0.23% Sign Maintenance 37,342 40,315 37,082 63,877 11,278 67,962 4,085 6.40% Subtotal 439,121 378,519 354,379 446,744 126,594 447,071 327 0.07% Other Convention & Visitor's Bureau 63,049 65,654 64,038 61,750 14,150 61,750 - 0.00% Social Service Coordination 19,763 20,178 20,259 20,461 20,461 21,075 614 3.00% Miscellaneous/contingency 4,926 4,975 5,061 6,500 1,836 6,500 - 0.00% Transfers to other funds 1,090,000 496,000 745,000 475,000 - 500,000 25,000 5.26% Debt service - 20,268 24,495 24,496 10,206 24,496 - 0.00% Subtotal 1,177,738 607,075 858,853 588,207 46,653 613,821 25,614 4.35% Total expenditures 6,517,823 6,499,052 6,530,654 6,584,264 2,362,450 6,808,427 224,163 3.40% Net change in fund balance 24,393 29,592 (168,950) (250,000) (1,720,281) (395,487) (145,487) Beginning Fund Balance 9,560,579 9,584,972 9,614,564 9,445,614 9,445,614 9,195,614 Ending Fund Balance 9,584,972 9,614,564 9,445,614 9,195,614 7,725,333 8,800,127 (145,487) 1 City of Mounds View GENERAL FUND 2018 Budget Summary Community Park Public 2018 2017 Percent Legislative Admin Finance Central Development Police Fire & Rec Works Misc.Total Total Variance Change Current Personnel services 39,115$ 295,287$ 249,921$ -$ 387,487$ 2,468,280$ -$ 226,662$ 526,989$ 6,500$ 4,200,241$ 4,014,373$ 185,868$ 4.63% Materials & supplies 2,900 1,310 600 39,090 3,375 79,508 - 48,948 135,495 - 311,226 319,636 (8,410) -2.63% Contractual services 32,231 30,165 20,385 215,443 30,852 347,145 447,393 230,915 179,199 82,825 1,616,553 1,578,226 38,327 2.43% Contingency - - - - - - - - - - - - - 0.00% Current total 74,246 326,762 270,906 254,533 421,714 2,894,933 447,393 506,525 841,683 89,325 6,128,020 5,912,235 215,785 3.65% Other Principal - - - - - - 75,135 - - 18,887 94,022 127,980 (33,958) -26.53% Interest - - - - - - 19,319 - - 5,609 24,928 22,394 2,534 11.32% Capital outlays - - - - - - 61,457 - - - 61,457 46,655 14,802 31.73% Transfers to other funds - - - - - - - - - 500,000 500,000 475,000 25,000 5.26% Other total - - - - - - 155,911 - - 524,496 680,407 672,029 8,378 1.25% Department Total 74,246$ 326,762$ 270,906$ 254,533$ 421,714$ 2,894,933$ 603,304$ 506,525$ 841,683$ 613,821$ 6,808,427$ 6,584,264$ 224,163$ 3.40% 2017 Budget 73,027 333,084 263,457 255,645 398,498 2,751,241 567,196 522,397 831,512 588,207 6,584,264 Increase (Decrease)1,219 (6,322)7,449 (1,112)23,216 143,692 36,108 (15,872)10,171 25,614 224,163 Percent change 1.67%-1.90%2.83%-0.43%5.83%5.22%6.37%-3.04%1.22%4.35%3.40%2 General Fund Revenue Detail - 2018 Budget Y-T-D Acct 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 #Description Actual Actual Actual Budget Actual Request Dollar Percent Taxes 3101 Current ad valorem property tax 3,363,602 3,651,411 3,700,381 3,833,967 - 3,828,967 (5,000) -0.13% 3101 Fire bonds 156,348 154,119 154,119 90,835 - 99,177 8,342 9.18% 3101 PERA rate increase property tax 39,145 39,145 39,145 39,145 - 39,145 - 0.00% 3101 Police Officer market rate tax 178,000 187,000 194,000 205,000 - 210,000 5,000 2.44% 3102 Delinquent ad valorem prop tax 12,324 17,266 - - - - - 0.00% 3111 Manufact home tax - current 19,935 21,331 18,966 20,000 - 20,000 - 0.00% 3112 Manufact home tax - delinquent 8,500 9,280 8,590 9,000 - 9,000 - 0.00% 3125 Excess TIF 62,069 - - - - - - 0.00% 3180 Franchise tax on utilities 336,711 309,039 296,173 280,000 116,511 285,000 5,000 1.79% 3190 Penalties & interest 5,817 - - - - - 0.00% 3192 Forfeited tax sales 357 - - - - - 0.00% 3195 Hotel/Motel tax 66,367 69,109 67,408 65,000 16,465 65,000 - 0.00% Total taxes 4,249,175 4,457,700 4,478,782 4,542,947 132,976 4,556,289 13,342 0.29% Licenses and Permits 3211 Liquor on-sale 16,775 16,800 17,290 16,800 - 16,800 - 0.00% 3212 Liquor off-sale 600 1,477 2,095 600 255 600 - 0.00% 3215 Malt on-sale license 135 - 115 - - - - 0.00% 3216 Malt off-sale (15) - 135 100 - 100 - 0.00% 3221 Tobacco license 3,220 3,300 3,300 3,000 330 3,300 300 10.00% 3223 Amusement devices 1,072 720 704 700 - 700 - 0.00% 3231 Bowling alley 672 672 672 672 - 672 - 0.00% 3232 Garbage hauling 3,150 2,558 3,373 3,000 - 3,000 - 0.00% 3233 Gasoline station 850 850 850 850 - 850 - 0.00% 3234 Used car sales 204 204 204 200 - 200 - 0.00% 3235 Kennel 285 426 488 150 45 200 50 33.33% 3236 Restraurant licenses 3,025 3,806 3,641 3,100 - 3,100 - 0.00% 3238 Transient & solicitor 2,235 2,666 2,130 2,200 1,775 2,200 - 0.00% 3239 Apartment 26,331 28,967 25,715 26,000 200 26,000 - 0.00% 3240 Rental conversion 3,295 1,335 2,500 1,000 975 1,000 - 0.00% 3241 Dog license 3,454 1,428 7,119 1,200 723 1,400 200 16.67% 3242 Massage therapy - 899 - - - - - 0.00% 3243 Chickens and bees - 440 350 200 170 200 - 0.00% 3250 General contractor 1,340 760 1,400 1,100 661 1,100 - 0.00% 3251 HVAC contractor 6,390 5,050 4,840 4,000 1,850 4,400 400 10.00% 3252 Cement contractor 160 - 40 100 - 100 - 0.00% 3253 Asphalt contractor 40 180 120 100 - 100 - 0.00% 3254 Excavating contractor 60 - - 50 60 50 - 0.00% 3255 Sign & billboard contractor 680 60 100 300 - 100 (200) -66.67% 3256 Sewer & water contractor - 100 - - 60 - - 0.00% 3257 Other contractor 2,230 3,430 2,800 1,500 1,440 2,000 500 33.33% 3258 License check 2,012 2,058 2,132 1,600 399 1,800 200 12.50% 3260 Fire permits 1,320 950 1,780 900 250 900 - 0.00% Subtotal licenses 79,520 79,136 83,893 69,422 9,193 70,872 1,450 2.09% 3 General Fund Revenue Detail - 2018 Budget Y-T-D Acct 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 #Description Actual Actual Actual Budget Actual Request Dollar Percent 3268 Plan check fee 37,926 23,141 13,751 18,000 31,650 18,000 - 0.00% 3270 Building permits 79,071 53,481 39,681 50,000 53,920 50,000 - 0.00% 3271 Fixed fee - building permits 18,592 18,421 20,146 18,000 7,366 18,500 500 2.78% 3273 HVAC permits 15,070 15,341 14,483 13,000 3,544 13,500 500 3.85% 3274 Plumbing permits 9,985 6,904 5,655 6,500 4,397 6,500 - 0.00% 3275 Non-building permits 5,921 7,679 5,314 5,000 2,380 5,000 - 0.00% 3278 Interim use permits - - 500 - - - - 0.00% 3279 Conditional use permits 600 400 800 600 1,200 600 - 0.00% 3280 Building surcharge 144 1,052 99 - 1,797 - - 0.00% 3281 Fixed fee building surcharge 75 (921) (3) - 137 - - 0.00% 3282 Mechanical/commercial surcharg 28 (38) 8 - - - - 0.00% 3283 HVAC surcharge 21 60 33 - 24 - - 0.00% 3284 Plumbing surcharge 13 27 130 - 25 - - 0.00% 3286 Water & sewer surcharge - 158 3 - 116 - - 0.00% 3287 Commercial plmb surcharge 10 4 6 - 9 - - 0.00% Subtotal permits 167,449 125,709 100,606 111,100 106,565 112,100 1,000 0.90% Total licenses & permits 246,969 204,845 184,499 180,522 115,758 182,972 2,450 1.36% Intergovernmental: 3318 Federal grant 1,088 350 2,902 - - - - 0.00% 3341 Local Government Aid 597,024 655,531 666,792 604,365 - 662,786 58,421 9.67% 3345 Performance Aid - 1,742 1,821 - - 1,800 1,800 0.00% 3346 PERA Aid 8,671 8,671 8,671 8,671 - 8,671 - 0.00% 3351 Street Aid - MSA maintenance 109,063 122,280 121,641 120,000 60,560 120,000 - 0.00% 3355 Police Aid 126,933 141,567 152,973 135,000 - 145,000 10,000 7.41% 3356 Police training 5,471 5,664 5,628 5,600 - 9,500 3,900 69.64% 3357 State police grant 1,088 389 455 - - - - 0.00% 3359 Other state grants 27,409 36,522 31,298 37,000 4,119 32,000 (5,000) -13.51% 3370 Other local government revenue 2,000 1,230 593 - - - - 0.00% 3371 IDS # 621 - SRO 62,950 64,114 75,839 66,000 - 70,000 4,000 6.06% 3375 State pension contribution - - 21,487 - - - - 0.00% Total intergovernmental 941,697 1,038,060 1,090,100 976,636 64,679 1,049,757 73,121 7.49% Charges for services 3410 Advertising revenue 1,620 205 530 700 - 500 (200) -28.57% 3415 Housing inspections - 190 1,771 50 - 100 50 100.00% 3418 HRA inspections 190 - - 500 - 200 (300) -60.00% 3419 Investigations 228 2,806 200 - - 200 200 0.00% 3421 Police reports 1,723 1,165 1,742 1,200 163 1,200 - 0.00% 3422 Documents / copies 26 351 262 100 - 150 50 50.00% 3423 Customer service 281 595 525 300 519 300 - 0.00% 3425 Book sales - various 10 - 43 - 9 - - 0.00% 3426 Reimbursed staff time 15 - - 500 - 200 (300) -60.00% 3430 Right-of-way 5,615 8,310 24,712 9,000 8,561 9,000 - 0.00% 3431 Street opening fee - 200 - - 800 - - 0.00% 3432 Tree removal charges - 2,670 8,353 1,000 2,001 2,000 1,000 100.00% 3433 Overload permits 75 - 200 - 250 - - 0.00% 3458 Zoning letter 300 150 500 75 100 75 - 0.00% 3461 Subdivision 2,100 - 1,050 1,000 - 1,000 - 0.00% 3462 Variance 1,800 1,800 1,100 1,000 - 1,000 - 0.00% 3463 Rezoning - 500 - 200 500 200 - 0.00% 3464 Development - non refund 450 - - 350 - 350 - 0.00% 3466 Comprehensive Plan Amendmen 500 - - - - - - 0.00% 3467 PUD amendment - - - 350 - 350 - 0.00% Total charges for services 14,933 18,942 40,988 16,325 12,903 16,825 500 3.06% 4 THIS PAGE LEFT BLANK INTENTIONALLY 5 General Fund Revenue Detail - 2018 Budget Y-T-D Acct 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 #Description Actual Actual Actual Budget Actual Request Dollar Percent Fines and Forfeitures 3510 Ramsey County municipal court 35,010 32,019 25,527 34,000 8,783 32,000 (2,000) -5.88% 3515 Mn Highway Patrol 233 50 - 200 - 200 - 0.00% 3520 Administrative offenses 2,621 2,144 801 2,500 50 2,100 (400) -16.00% 3525 False alarm charges 2,375 2,125 2,950 2,300 200 2,300 - 0.00% Total fines & forfeitures 40,239 36,338 29,278 39,000 9,033 36,600 (2,400) -6.15% Other Revenue 3550 Special assessments 11,601 4,195 3,706 3,000 - 3,000 - 0.00% 3610 Investment income (charge)521,224 112,669 104,985 115,000 32,122 115,000 - 0.00% 3630 Billboard Lease 103,110 105,303 112,562 113,876 63,475 119,889 6,013 5.28% 3631 Water tower rental 98,855 101,639 110,529 114,950 114,950 90,807 (24,143) -21.00% 3634 Equipment and space rental 5,268 5,454 1,194 1,150 1,230 1,150 - 0.00% 3639 Security - 3,782 1,509 - 540 - - 0.00% 3650 Donations 11,485 5,100 4,080 - 6,575 - - 0.00% 3651 Donations - K9 1,618 1,247 1,330 750 445 750 - 0.00% 3654 COPS events - - - - 6,881 5,000 5,000 0.00% 3656 Tree sales - - 204 - - - - 0.00% 3665 Park site permit 12,497 14,940 14,613 14,000 6,841 14,000 - 0.00% 3679 Vending machine commissions 466 - 76 100 - 100 - 0.00% 3680 Other revenue 46,993 10,584 20,812 11,000 47,103 11,000 - 0.00% 3685 Insurance reimbursements 59,152 40,145 57,995 30,000 6,279 30,000 - 0.00% 3690 Cash over / short (22) - - - - - - 0.00% 3911 Sale of assets 550 28,338 12,513 5,000 7,075 5,000 - 0.00% 3912 Resale of materials 4,105 461 1,424 2,000 13,304 2,000 - 0.00% Total other revenue 876,902 433,857 447,532 410,826 306,820 397,696 (13,130) -3.20% Transfers & Debt proceeds 3972 Transfers: Vehicle & Equip replacement 38,316 21,000 22,000 21,600 - 22,000 400 1.85% DARE fund - 4,643 - - - - - 0.00% Water 69,393 - - 75,828 - 78,103 2,275 3.00% Sewer 54,962 56,611 58,309 60,058 - 61,860 1,802 3.00% Storm Water 7,168 7,383 7,604 7,832 - 8,067 235 3.00% Street light 2,462 2,536 2,612 2,690 - 2,771 81 3.01% 3993 Debt proceeds - 246,729 - - - - - 0.00% Total Transfers & Debt 172,301 338,902 90,525 168,008 - 172,801 4,793 2.85% Total 6,542,216 6,528,644 6,361,704 6,334,264 642,169 6,412,940 78,676 1.24% 6 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent City Council (100 - 4100): Personnel services 0100 Salaries, regular 29,292 29,292 29,292 34,596 12,818 34,596 - 0.00% 0300 Social Security 1,129 1,129 1,129 2,647 534 2,647 - 0.00% 0321 PERA 885 885 885 1,730 358 1,730 - 0.00% 0500 Workers compensation 111 148 132 173 68 142 (31) -17.92% Total personnel services 31,417 31,454 31,438 39,146 13,778 39,115 (31) -0.08% Materials & supplies 1600 Supplies, operating 1,690 1,635 2,239 2,600 585 2,600 - 0.00% Total materials & supplies 1,690 1,635 2,239 2,600 585 2,600 - 0.00% Contractual services 3030 Other professional services 6,895 6,154 5,882 6,200 1,639 6,200 - 0.00% 3610 Memberships 2,801 5,161 5,429 5,681 5,651 5,681 - 0.00% 3630 Training & conferences 2,633 2,208 1,765 3,200 2,923 3,000 (200) -6.25% 4800 Bonding & insurance 594 503 460 700 223 650 (50) -7.14% Total contractual services 12,923 14,026 13,536 15,781 10,436 15,531 (250) -1.58% 0.00% Total City Council 46,030 47,115 47,213 57,527 24,799 57,246 (281) -0.49% 15,661 15,775 18,381 18,131 Advisory Commissions (100-4110): Materials & supplies 1600 Supplies, operating - 41 - 200 - 200 - 0.00% 2100 Books & periodicals - - - 100 - 100 - 0.00% Total materials & supplies - 41 - 300 - 300 - 0.00% Contractual services 3030 Other professional services 4,369 2,227 2,641 4,500 485 4,500 - 0.00% 3630 Training & conferences - - - 200 65 200 - 0.00% 3900 Festivities Commission 9,946 6,452 12,879 10,500 - 12,000 1,500 14.29% Total contractual services 14,315 8,679 15,520 15,200 550 16,700 1,500 9.87% 0.00% Total Advisory Commissions 14,315 8,720 15,520 15,500 550 17,000 1,500 9.68% 2018 Budget Summary 7 Fund: 100 Department: 4100 City Council Account Description 2015 2016 2017 2018 Description 1600 Supplies, operating 900 1,000 1,000 1,000 Employee appreciation dinner 500 600 600 600 Strategic planning session supplies 900 1,000 1,000 1,000 Plaques and gift certificates for employee appreciation 2,300 2,600 2,600 2,600 3030 Other professional services 3,000 - - - Strategic planning session(s) facilitator 6,075 6,200 6,200 6,200 Contractual minutes for Council mtgs ( $225 x 24 reg, + 3 special) 9,075 6,200 6,200 6,200 3610 Memberships 30 30 30 30 Mn Mayor's Association 5,770 5,570 5,651 5,651 North Metro Mayors (Evaluate for value and effectiveness) 5,800 5,600 5,681 5,681 3630 Conferences 2,000 3,200 3,200 3,000 Council training, LMC conference, RCCLG dinners & NLC conference 2,000 3,200 3,200 3,000 4800 Bonds & insurance 750 700 700 650 General property & liability 750 700 700 650 19,925 18,300 18,381 18,131 7.99%-8.16%0.44%-1.36% Fund: 100 Department: 4110 Advisory Commissions Account Description 2015 2016 2017 2018 Description 1600 Supplies, operating 60 60 60 60 Misc supplies for various commissions. 140 140 140 140 Copies for Charter Commission 200 200 200 200 2100 Books & periodicals 100 100 100 100 Misc periodicals - Comp plan review, Ordinance revisions. 100 100 100 100 3030 Other professional services 500 500 500 500 Misc. consultant services. 2,000 2,000 1,750 1,750 Charter commission legal fees 2,500 2,500 2,250 2,250 Planning Commission meeting minutes 5,000 5,000 4,500 4,500 3630 Training 150 150 75 75 Misc training & conferences. 150 150 125 125 Planning Commissioner training & conferences 300 300 200 200 3900 Festival in the Park 9,500 4,500 5,500 7,000 City Festival in the Park (personnel, supplies)(60th Anniversery) - 5,000 5,000 5,000 Fireworks 9,500 9,500 10,500 12,000 15,100 15,100 15,500 17,000 48.77%48.77%2.65%12.58% 8 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Office of the City Administrator (100 - 4130): Personnel services 0100 Salaries, regular 177,671 212,471 216,175 224,486 80,750 230,165 5,679 2.53% 0110 Salaries, over-time - - - 896 - 909 13 1.45% 0150 Salaries, part-time - - - 988 - 988 - 0.00% 0300 Social Security 12,871 15,417 15,115 17,127 6,095 17,562 435 2.54% 0321 PERA 12,692 15,622 15,518 16,716 5,899 17,143 427 2.55% 0400 Group insurance 24,479 20,649 20,981 26,007 9,087 27,090 1,083 4.16% 0500 Workers compensation 1,465 2,325 1,471 1,689 660 1,430 (259) -15.33% Total personnel services 229,178 266,484 269,260 287,909 102,491 295,287 7,378 2.56% Materials & supplies 1230 Supplies, equipment 340 179 - 1,200 - 1,200 - 0.00% 1600 Supplies, operating - 13 - 75 - 75 - 0.00% 2100 Books & periodicals - - - 35 - 35 - 0.00% Total materials & supplies 340 192 - 1,310 - 1,310 - 0.00% Contractual services 3030 Other professional services - - 10,447 - 14,981 - - 0.00% 3100 Communications 631 741 1,078 1,300 873 1,300 - 0.00% 3610 Memberships 142 188 201 1,340 45 1,340 - 0.00% 3630 Training & conferences 1,335 3,709 1,490 5,850 545 2,650 (3,200) -54.70% 3800 Mileage 222 - - 375 - 375 - 0.00% Total contractual services 2,330 4,638 13,216 8,865 16,444 5,665 (3,200) -36.10% Total City Administrator 231,848 271,314 282,476 298,084 118,935 302,262 4,178 1.40% 4,830 13,216 10,175 6,975 Elections (100 - 4140): Contractual services 3030 Other professional services 20,053 22,222 19,167 35,000 9,515 24,500 (10,500) -30.00% Total contractual services 20,053 22,222 19,167 35,000 9,515 24,500 (10,500) -30.00% 7030 Capital outlays - - 28,112 - - - 0.00% Total Elections 20,053 22,222 47,279 35,000 9,515 24,500 (10,500) -30.00% 2018 Budget Summary 9 Fund: 100 Department: 4130 Office of the City Administrator Account Description 2015 2016 2017 2018 Description 1230 Supplies, equipment < $5000 725 825 1,200 1,200 Equipment and phones under the $5,000 capitalization threshold 725 825 1,200 1,200 1600 Supplies, Operating 75 75 75 75 Miscellaneous supplies 75 75 75 75 2100 Books & Periodicals 35 35 35 35 Miscellaneous reference books 35 35 35 35 3100 Communications 760 1,300 1,300 1,300 Cell phone service (2) employees 760 1,300 1,300 1,300 3610 Memberships - - 50 50 MAMA - (Administrator) Metro Area Manager's Association - - 1,100 1,100 ICMA - International City Manager's Association 150 150 150 150 Mn City County Managers Association 40 40 40 40 Municipal Clerks & Finance Officers Association 190 190 1,340 1,340 3630 Training & conferences 100 100 100 100 MAMA meetings 500 500 500 500 LMC / miscellaneous training 100 100 100 100 Chamber lunches 850 1,000 1,000 1,000 LMC annual conference (2 attendees)(Asst. Adm. every other year) 850 850 850 850 Mn City County Managers Assoc conference 100 100 100 100 Mn Clerks and Finance Officers Association (MCFOA) institute training 3,000 - 3,200 - National ICMA or NLC conference (City Administrator)(every other year) 5,500 2,650 5,850 2,650 3800 Mileage 375 375 375 375 Miscellaneous mileage @ IRS rate. 375 375 375 375 7,660 5,450 10,175 6,975 -0.65%-29.31%32.83%27.98% Fund: 100 Department: 4140 Elections Account Description 2015 2016 2017 2018 Description 3030 Other professional services 23,200 23,200 22,000 22,000 Ramsey County elections contract - - 10,500 - Special election - 2,500 2,500 2,500 Equip. maint. service costs (voting equip.) 23,200 25,700 35,000 24,500 7030 Equipment 36,000 29,000 - - Voting equipment 36,000 29,000 - - 59,200 54,700 35,000 24,500 5.71%-7.60%-36.01%-30.00% 10 2018 Budget Summary Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Finance (100 - 4150): Personnel services 0100 Salaries, regular 166,330 177,754 186,467 187,327 72,500 192,483 5,156 2.75% 0300 Social Security 11,908 12,751 13,092 14,330 4,963 14,725 395 2.76% 0321 PERA 11,808 13,050 13,676 14,050 5,382 14,436 386 2.75% 0400 Group insurance 21,414 21,860 22,311 25,506 9,522 26,910 1,404 5.50% 0500 Workers compensation 1,273 1,850 1,415 1,615 632 1,367 (248) -15.36% 0990 Severence - - - - - - - 0.00% Subtotal 212,733 227,265 236,961 242,828 92,999 249,921 7,093 2.92% Materials & supplies 1230 Supplies, equipment 17 - - 200 - 175 (25) -12.50% 1600 Supplies, operating 35 - - 75 - 75 - 0.00% 2100 Books & periodicals 181 185 227 450 - 350 (100) -22.22% Subtotal 233 185 227 725 - 600 (125) -17.24% Contractual services 3030 Other professional 9,811 9,738 9,519 9,615 9,236 9,780 165 1.72% 3100 Communications 480 480 480 480 160 480 - 0.00% 3430 Printing 1,179 551 735 700 404 700 - 0.00% 3610 Memberships 804 970 995 995 750 1,040 45 4.52% 3630 Training 2,635 2,477 2,037 2,700 1,249 2,700 - 0.00% 5130 Repairs & maint., equipment 4,298 4,602 4,832 5,414 5,073 5,685 271 5.01% Subtotal 19,207 18,818 18,598 19,904 16,872 20,385 481 2.42% Total Financial Services 232,173 246,268 255,786 263,457 109,871 270,906 7,449 2.83% 11 Fund: 100 Department: 4150 Finance Account Description 2015 2016 2017 2018 Description 1230 Supplies, equitpment < $5000 200 200 200 175 Furniture or equipment under the $5,000 capitalization threshold 200 200 200 175 1600 Supplies, operating 75 75 75 75 Misc supplies - planners, plaques, folders, files, etc. 75 75 75 75 2100 Books & periodicals 550 450 450 350 Misc computer & finance books & periodicals 550 450 450 350 3030 Other professional services 9,480 9,660 9,020 9,185 27.5% of audit (2016 - $32,200, 2017 - $32,800, 2018 - $33,400) 435 435 435 435 GFOA financial reporting fee 60 60 60 60 Safety deposit box rental 100 100 100 100 Ramsey County overlapping debt, principal taxpayer reports 10,075 10,255 9,615 9,780 3100 Communications 480 480 480 480 cell phone ($40 month) 480 480 480 480 3430 Printing 350 350 350 350 Accts Payable & payroll checks & envelopes 350 350 350 350 Invoices, receipts, & bank deposit slips 700 700 700 700 3610 Memberships 350 350 350 370 Government Finance Officer's Association (GFOA) 120 120 120 120 Mn GFOA (2) 240 250 250 260 AICPA Am. Institute of Certified Public Accts 275 275 275 290 MNCPA Mn Society of Certified Public Accountants 985 995 995 1,040 3630 Training & conferences 75 75 50 50 Mn GFOA monthly meetings 1,450 1,600 1,700 1,700 Seminars & training - - - - GFOA National conference (Defer)($2500) 600 650 650 650 Accounting and software training 250 250 300 300 Mileage 2,375 2,575 2,700 2,700 5130 Equipment repairs 4,910 5,156 5,414 5,685 40% software support charges (30% each in Water, Sanitary Sewer)(5% annual 4,910 5,156 5,414 5,685 20,350 20,886 20,629 20,985 -1.52%2.63%-1.23%1.73% 12 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Central Services (100 - 4160): Materials & supplies 0322 Pesion expense GASB 68 - - 2,031 - - - - 0.00% 1110 Stationery 1,027 - 436 1,000 - 750 (250) -25.00% 1120 Copy materials - 830 1,799 1,500 479 1,500 - 0.00% 1230 Supplies, equipment 4,296 21,316 22,102 21,600 10,099 22,000 400 1.85% 1600 Supplies, operating 14,462 12,662 12,670 14,500 6,091 14,500 - 0.00% 2100 Books & periodicals 159 169 169 365 54 340 (25) -6.85% Total materials & supplies 19,944 34,977 39,207 38,965 16,723 39,090 125 0.32% Contractual services 3010 General legal 57,407 45,489 41,364 44,000 11,250 44,000 - 0.00% 3030 Other professional services 5,154 9,643 22,423 22,446 2,622 14,046 (8,400) -37.42% 3100 Telephone 7,078 6,160 2,613 2,400 749 2,200 (200) -8.33% 3300 Postage 8,366 8,273 4,238 7,800 2,191 7,800 - 0.00% 3410 Legal notices 2,395 4,168 3,499 3,000 848 3,000 - 0.00% 3420 Advertising 2,534 2,634 2,739 2,500 - 2,500 - 0.00% 3430 Printing 8,330 7,945 8,601 7,400 1,605 12,600 5,200 70.27% 3610 Memberships 13,424 19,253 20,049 20,556 8,289 20,556 - 0.00% 3630 Training & conferences 172 1,167 498 2,000 668 2,000 - 0.00% 4010 Rental, equipment 1,431 1,407 1,424 1,750 703 1,750 - 0.00% 4800 Insurance & bonds 14,614 15,212 14,453 20,000 24,281 18,000 (2,000) -10.00% 5100 Repairs & maint, computers 64,347 56,507 76,605 82,228 18,421 86,391 4,163 5.06% 5130 Repairs, equipment 2,355 3,647 - 600 - 600 - 0.00% Total contractual services 187,607 181,505 198,506 216,680 71,627 215,443 (1,237) -0.57% Total central services 207,551 216,482 237,713 255,645 88,350 254,533 (1,112) -0.43% 2018 Budget Summary 13 Fund: 100 Department: 4160 Central Services Account Description 2015 2016 2017 2018 Description 1110 Stationery 1,000 1,000 1,000 750 Envelopes, labels, letterhead, etc. 1,000 1,000 1,000 750 1120 Copy materials 1,500 1,500 1,500 1,500 Copy paper 1,500 1,500 1,500 1,500 1230 Supplies, equipment < $5000 20,000 20,000 21,600 22,000 Comp & security equip under $5,000, pc's, software, switches, cameras.... 20,000 20,000 21,600 22,000 Replace pc's @ $800 4 yr replacement cycle 1600 Supplies, operating 15,400 15,400 14,000 14,000 Toner, rug service, paper, pens, staples, desk supplies, etc. 500 500 500 500 Misc operating supplies 15,900 15,900 14,500 14,500 2100 Books & periodicals 175 175 175 150 Employment handbooks/publications 190 190 190 190 Star Tribune - $190 365 365 365 340 3010 General legal 26,400 24,000 24,000 24,000 Retainer for legal services 18,000 20,000 20,000 20,000 Legal fees outside scope of retainer. 44,400 44,000 44,000 44,000 3030 Other professional services 6,000 5,700 5,700 6,000 General labor assistance - - 10,000 - Personnel market study - - 3,086 3,086 Western Bank monthly fees - - 360 360 US Bank positive pay service 1,400 1,500 1,200 1,200 Section 125 (flex spending plan) & COBRA administration 900 1,000 1,000 1,000 Human resources items 1,000 1,100 1,100 2,400 Web hosting (Revive) (5% annual increase) 9,300 9,300 22,446 14,046 3100 Telephone 6,800 7,400 2,400 2,200 Basic telephone plus long distance 6,800 7,400 2,400 2,200 3300 Postage 300 300 300 300 Courier charges (delivery services) 7,500 7,500 7,500 7,500 General postage includes PW mailings for street projects. 7,800 7,800 7,800 7,800 3410 Legal notices 900 900 900 900 Truth in taxation notices and Ramsey County fees. 2,100 2,100 2,100 2,100 Legal notices and legal publications. 3,000 3,000 3,000 3,000 3420 Advertising 3,000 2,500 2,500 2,500 Job opening advertisements for vacant positions 3,000 2,500 2,500 2,500 3430 Printing 6,400 6,800 6,800 12,000 4 newsletters and postage, YMCA in Comm Ctr Fund. 200 200 200 200 Miscellaneous printing 400 400 400 400 City guides, directories & miscellaneous 7,000 7,400 7,400 12,600 3610 Memberships 605 600 625 625 Ramsey County League of Local Governments (RCLLG) - 2,850 2,850 2,850 I-35W Corridor Coalition 4,833 4,835 4,901 4,901 Metro Cities (1.36% increase for 2017) 10,813 11,637 12,180 12,180 League of Mn Cities (No increase 2018) 16,251 19,922 20,556 20,556 3630 Training & conferences 1,000 1,000 1,000 1,000 League training & seminars 800 800 800 800 OSHA and blood borne pathogen training 200 200 200 200 Information technology training 2,000 2,000 2,000 2,000 4010 Rental, equipment 150 150 150 150 Misc 1,600 1,600 1,600 1,600 Postage machine and scale rental 1,750 1,750 1,750 1,750 4800 Bonding & insurance 19,000 19,000 17,000 15,000 Insurance policy premiums 3,000 3,000 3,000 3,000 Allowance for insurance policy deductibles 22,000 22,000 20,000 18,000 5100 Repairs, computer 59,000 64,000 69,600 72,100 Computer, phone, network & technology assistance - City of Roseville 2,198 2,609 2,688 2,688 Laserfiche annual maintenance and storage - - - 1,603 Denial of Service protection contract (1.687% of $95,000) 5,750 5,750 5,750 6,000 Computer, printer, and networks repairs. 4,190 4,190 4,190 4,000 Copier maintenance + overages 2,040 - - - Hosted servers (2 servers) add (1) in 2015 (included in technology assist.) 73,178 76,549 82,228 86,391 5130 Repairs, equipment 600 600 600 600 Postage meter, copy machine, fax, misc. 600 600 600 600 235,844 242,986 255,645 254,533 -0.09%3.03%5.21%-0.43% 14 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Community Development (100 - 4180): Personnel services 0100 Salaries, regular 245,039 259,655 236,428 263,096 81,304 285,932 22,836 8.68% 0110 Overtime, regular 24 - - 548 70 699 151 27.55% 0150 Salaries, part time 1,380 1,226 1,238 1,976 293 1,976 - 0.00% 0300 Social Security 17,745 18,069 16,801 20,320 6,140 22,078 1,758 8.65% 0321 PERA 17,572 18,504 16,701 19,773 5,949 21,497 1,724 8.72% 0322 Pension expense GASB 68 - - 1,604 - - - - 0.00% 0400 Group insurance 35,750 35,975 28,371 51,120 7,874 53,640 2,520 4.93% 0500 Workers comp 2,177 2,859 1,660 1,834 717 1,665 (169) -9.21% Total personnel services 319,687 336,288 302,803 358,667 102,347 387,487 28,820 8.04% Materials & supplies 1230 Supplies, equipment 510 - 62 500 120 500 - 0.00% 1600 Supplies, operating - 110 48 300 - 300 - 0.00% 1700 Motor fuels & lubricants 2,191 1,745 732 1,840 114 2,000 160 8.70% 2100 Books & periodicals - 498 321 375 168 375 - 0.00% 2400 Uniforms 296 - 82 200 - 200 - 0.00% Total materials & supplies 2,997 2,353 1,245 3,215 402 3,375 160 4.98% Contractual services 3030 Other professional 12,869 9,431 11,749 27,200 11,116 21,906 (5,294) -19.46% 3040 Consultants, development review 2,085 822 1,575 3,000 - 3,000 - 0.00% 3100 Telephone 1,240 1,365 1,550 1,961 532 1,421 (540) -27.54% 3430 Printing 762 543 510 900 - 900 - 0.00% 3610 Memberships 870 1,180 120 1,630 944 1,200 (430) -26.38% 3630 Training and conferences 1,024 1,393 657 1,825 546 2,325 500 27.40% 3800 Mileage 59 6 204 100 81 100 - 0.00% Total contractual services 18,909 14,740 16,365 36,616 13,219 30,852 (5,764) -15.74% Total Community Development 341,593 353,381 320,413 398,498 115,968 421,714 23,216 5.83% 2018 Budget Summary 15 Fund: 100 Department: 4180 Community Development Account Description 2015 2016 2017 2018 Description 1230 Supplies, equipment < $5000 475 825 500 500 Miscellaneous equipment & computer peripherals 475 825 500 500 1600 Supplies, operating 100 100 100 100 Presentation supplies 200 200 200 200 Office supplies 300 300 300 300 1700 Motor fuels & lubs 1,788 2,200 1,840 2,000 Unleaded fuel: 800 gallons @ $2.50 (Gas for Comm Devlopment) 1,788 2,200 1,840 2,000 2100 Books & periodicals 100 100 100 100 Reference materials 100 100 100 100 Intl. Code Council Manuals and Code Updates 175 175 175 175 Manuals, pamphlets, etc. 375 375 375 375 2400 Uniforms 200 200 200 200 Clothing for inspections staff 200 200 200 200 3030 Other professional 1,300 1,300 1,300 1,300 Ramsey County JPA (geographic information system) 4,620 4,620 4,485 5,080 Permit Works system annual software support (includes busi. lic. mod) - 1,595 - 1,020 Permit works mobile inspector - 2,040 1,020 - Roseville Net Motion VPN 2 factor authentication 500 500 500 500 Filing fees (Ramsey County increased fees from $29 to $48) 1,971 2,110 2,195 2,306 Comcate Code Enforcement Mgr license 1,987 1,987 1,200 1,200 Comcate mobile access 500 500 500 500 GIS assistance - - 12,000 6,000 Comp plan GIS assistance with maps 4,000 4,000 4,000 4,000 Abatements of nuisance properties 14,878 18,652 27,200 21,906 3040 Consulting - Development 750 750 750 750 Environmental reviews Review (reimbursable)750 750 750 750 City attorney services 750 750 750 750 Development case reviews 750 750 750 750 Engineering services 3,000 3,000 3,000 3,000 3100 Telephone 1,300 1,300 1,000 1,000 Verizon Cell Accounts (2) for inspectors 481 481 961 421 network card for code enforcement (1 cards @ $35.01) 1,781 1,781 1,961 1,421 3430 Printing 1,300 1,000 900 900 Forms, flyers, etc. 1,300 1,000 900 900 3610 Memberships 300 300 245 265 American Planning Association (APA) - National (1) - - 50 50 American Planning Association (APA-MN) - State (1) - - 135 135 American Institute of Certified Planners (AICP) - - 750 300 Sensible Land Use Coalition (membership $250, monthly lunches (10 @ $50) 120 120 - - Assoc. of MN Building Officials 120 125 140 140 International Code Council (ICC) 60 95 100 100 10K Lakes Chapter of ICC 60 100 105 105 MN Assoc. Housing Code Officials (MAHCO) 85 100 105 105 MN Building Permit Technicians Association (MBPTA) 745 840 1,630 1,200 3630 Training & conferences 600 600 800 850 APA state conference (one attendee) - - 225 225 ICC code seminars 300 300 300 300 Other software training 300 300 500 950 Other staff training & seminars 1,200 1,200 1,825 2,325 3800 Mileage 100 100 100 100 Misc. use of personal automobiles 100 100 100 100 26,142 30,473 39,831 34,227 -3.34%16.57%30.71%-14.07% 16 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Police (100 - 4200): Personnel services: 0100 Salaries, regular 1,542,874 1,570,903 1,631,402 1,639,030 616,890 1,734,431 95,401 5.82% 0110 Overtime 74,978 80,112 96,684 60,499 39,281 62,625 2,126 3.51% 0300 Social Security 26,023 27,501 29,230 32,822 11,898 34,825 2,003 6.10% 0321 PERA 226,087 254,166 256,686 263,847 101,047 291,236 27,389 10.38% 0322 Pension expense GASB 68 - - 14,949 - - - - 0.00% 0400 Group insurance 205,941 220,722 231,125 259,560 102,083 272,520 12,960 4.99% 0500 Workers compensation 57,033 78,193 73,788 83,375 32,604 72,643 (10,732) -12.87% Total personnel services 2,132,936 2,231,597 2,333,864 2,339,133 903,803 2,468,280 129,147 5.52% Materials & Supplies 1210 Supplies, buildings & grounds - - - 500 - - (500) -100.00% 1230 Supplies, equipment 19,509 35,038 23,114 14,100 3,986 13,100 (1,000) -7.09% 1600 Supplies, operating 4,543 7,664 5,706 9,100 5,611 9,100 - 0.00% 1700 Motor, fuels & lubricants 43,608 39,643 24,716 33,293 3,706 36,188 2,895 8.70% 2100 Books & periodicals 811 1,031 723 900 - 300 (600) -66.67% 2400 Uniforms & clothing 16,974 15,168 20,682 20,805 14,796 20,820 15 0.07% Total materials & supplies 85,445 98,544 74,941 78,698 28,099 79,508 810 1.03% Contractual services 3020 Legal, prosecuting attorney 53,181 72,774 74,226 78,690 24,712 78,690 - 0.00% 3030 Other professional services 11,556 3,183 3,115 3,690 32,175 3,690 - 0.00% 3050 Dispatching 100,915 108,058 106,425 107,131 35,710 106,714 (417) -0.39% 3055 Information systems fees 2,540 2,565 4,907 4,955 1,035 4,955 - 0.00% 3070 COPS events 644 802 1,731 1,000 2,502 6,000 5,000 500.00% 3080 Veternarian services 2,951 5,449 1,199 1,500 503 1,500 - 0.00% 3100 Telephone 2,889 2,879 4,720 6,420 3,293 8,882 2,462 38.35% 3210 Electricity 290 280 289 320 107 320 - 0.00% 3430 Printing 339 149 168 500 - 400 (100) -20.00% 3610 Memberships 1,925 1,495 2,171 1,936 1,135 1,756 (180) -9.30% 3630 Training 9,166 11,387 15,045 12,470 6,286 16,370 3,900 31.28% 4010 Rental, equipment - - - - 445 - - 0.00% 4800 Insurance & bonds 40,670 42,602 52,324 54,100 45,715 54,500 400 0.74% 5100 Technology maintenance 29,252 121,538 39,937 52,858 24,855 55,528 2,670 5.05% 5130 Maintenance, equipment 6,564 6,751 4,009 7,840 1,620 7,840 - 0.00% Total contractual services 262,882 379,912 310,266 333,410 180,093 347,145 13,735 4.12% Capital outlays 7030 Equipment - - - - - - - 0.00% Total capital outlays - - - - - - - 0.00% Total police 2,481,263 2,710,053 2,719,071 2,751,241 1,111,995 2,894,933 143,692 5.22% 2018 Budget Summary 17 Fund: 100 Department: 4200 Police Account Description 2015 2016 2017 2018 Description 1210 Supplies, bldgs & grounds 800 800 500 - Carpet cleaning & misc maintenance items 800 800 500 - 1230 Supplies, equipment < $5000 4,500 4,500 3,000 3,000 Miscellaneous office equip (eticket paper) 800 - - - Laptop - 800 1,000 - SLR camera for Investigations add PSO camera $200 - 2,000 - - Shredder - 3,000 - - Rifle mounts (10@$300 each) - 4,000 - - Bicycles and racks for park patrol (3) 4,000 - 800 800 Alco-sensor portable breath test (PBT's) ($800 each) 10,300 10,300 9,300 9,300 (2) squad computers $7,000, light bar $2,300 19,600 24,600 14,100 13,100 1600 Supplies, operating 3,750 3,400 3,000 3,000 Photo print supplies, fire extinguishers, gloves, inkjet cartridges, toner, etc. 700 700 600 600 K9 Food 500 500 500 500 Portable radio batteries (10) @ $50 2,500 2,500 5,000 5,000 Batteries, breathalyzer parts, DVD's & CD's, disinfectant, simulation ammo ammunition, crime scene tape, emergency blankets, etc. 7,450 7,100 9,100 9,100 1700 Motor, fuels, & lubs -42,300 38,775 32,430 35,250 Unleaded gas 14,100 gallons @ $2.50/gal. 1,125 1,032 863 938 K9 take home car gas 375 gallons @ $2.50 43,425 39,807 33,293 36,188 2100 Books & periodicals 900 900 900 300 Traf. law, crim. law, HR, employ. law, school year books, & misc. books 900 900 900 300 2400 Uniforms & clothing 710 710 775 775 Chief 710 710 775 775 Deputy Chief 4,000 4,000 4,000 4,000 Initial officer set-ups replacing up to two retiring officers 12,070 12,070 13,175 13,190 14 officers @ $775, 3 sgts @ $780 - 2018, $800 - 2019 1,080 1,080 1,080 1,080 Administrative assistant, Clerk-typist, Community Service Officer 3@$360 1,000 1,000 1,000 1,000 Traffic vests, Taser holsters, & misc items 19,570 19,570 20,805 20,820 3020 Legal, prosecuting attorney 74,214 76,398 78,690 78,690 Retainer ($6,430 per month)(misc charges $1,530) 74,214 76,398 78,690 78,690 3030 Other professional services 700 700 900 900 Tobacco compliance project 150 150 150 150 Hazardous material disposal fee 1,500 1,500 1,400 1,400 Lab fees, blood tests, physical tests, video, misc. 240 240 240 240 Automated Pawn service 1,000 1,000 1,000 1,000 Civil Service and medical testing for new officers 3,590 3,590 3,690 3,690 3050 Dispatching 109,819 106,426 107,131 106,714 Ramsey County dispatching 109,819 106,426 107,131 106,714 3055 Informational systems fees 2,101 2,101 2,080 2,080 State service fee - CJDN ($510 per quarter) - - 2,350 2,350 BCA connectivity charge thru Ramsey Cty for CAD (new) 515 525 525 525 IACP.net ($525 annual) 2,616 2,626 4,955 4,955 3070 COPS events 500 700 1,000 6,000 National night out, town hall meeting, child ID, stickers, shop, bowl, other outr 500 700 1,000 6,000 3080 Veterinarian services 4,200 4,500 1,000 1,000 Hillcrest Veterinary Hospital 1,000 1,000 500 500 K9 vet services 5,200 5,500 1,500 1,500 3100 Telephone 2,600 6,420 6,420 5,100 Verizon cell phones (12 phones)(8 smart, 4 basic)($420 accessories) - - - 3,782 Air cards for squads CAD (9) at $35.01 per month (moved from 5100) 2,600 6,420 6,420 8,882 3210 Electricity 320 320 320 320 Civil defense siren's electricity 320 320 320 320 18 THIS PAGE LEFT BLANK INTENTIONALLY 19 Fund: 100 Department: 4200 Police Account Description 2015 2016 2017 2018 Description 3430 Printing 800 500 500 400 Dept manual, Emergency management manual, business cards, 800 500 500 400 3610 Memberships 100 - - - Assoc. Metro Emergency Managers 50 50 50 - FBI/LEEDA Law Enfor. Execu. Devel. Assoc. 2@ $50 75 75 75 75 Tri-County Investigator Association 45 45 45 45 Mn Crime Prevention Association 100 130 130 - MN Emergency Managers Assoc. 420 420 420 420 Mn Police chiefs 129 129 150 150 IACP (International Association of Chief of Police) 36 36 36 36 MN Sex Crime Investigators Assoc. 30 30 30 30 Natl. Assoc. School Resource Officers 100 100 100 100 K9 memberships 200 200 200 200 Notary commission (3 year due in 2012)($120+$20) 630 630 630 630 POST license reimbursement 7 @ $90 30 30 35 35 Prof. Law Enforcement Admin. Assoc. 25 35 35 35 National Association of Town Watch 1,970 1,910 1,936 1,756 3630 Training 600 600 710 710 MN Chief's conference 2@$355 200 200 400 400 BCA/CJDN training (new records tech) 320 320 450 450 Intox certification (6@$75) 1,000 1,000 1,000 1,000 Range Rental 400 400 400 400 MN Sex Crimes Investigators Assoc Conference 3,000 3,000 2,000 2,000 Tuition reimbursement 1,200 1,200 1,400 3,000 Supervisor training 1,500 1,400 1,400 1,400 K9 training 600 600 600 600 Emergency Management training 1,700 1,700 1,700 4,000 Employee development courses 1,615 1,615 1,615 1,615 Patrol on-line program 695 795 795 795 Post training for officers at Century College (1 officers) 12,830 12,830 12,470 16,370 4800 Insurance & bonds 25,000 25,000 25,000 25,000 Liability and automotive insurance 14,100 14,100 14,100 14,500 Insurance per MN Statute 299A.465 25,000 25,000 15,000 15,000 Allowance for insurance policy deductibles 64,100 64,100 54,100 54,500 5100 Technology - maintenance 2,000 2,000 2,000 2,000 Computer network & technology assistance - City of Roseville agreements & support 1,800 1,800 1,000 1,000 Copier maintenance + overages 2,000 2,000 2,000 2,000 Automatic License plate reader maintenance - - - 2,500 Watch Guard body camera maintenance 3,840 3,840 3,782 - Air cards for squad CAD (9) at $35.01 per month (move to 3100) - 2,500 3,500 5,185 Milestone video maintenance and licenses - 2,428 3,110 3,777 NetMotion 2 factor authentication (state required) - - 313 313 CAD interface (Zuercher) 12,500 12,500 15,780 17,380 IT support for squad computers (Roseville) 129,894 20,355 21,373 21,373 Operating costs of police records management system and ticket writer 152,034 47,423 52,858 55,528 5130 Repairs, equipment 3,000 3,000 3,000 2,579 Misc. equipment repair - defibs, cameras, recorders, fax, printers. 450 450 400 800 Fire extinguisher recharging and inspection 1,500 - - - Squad mobile digital computer repairs 1,000 1,000 1,000 1,000 Civil Defense siren repair & maint. (all 3 were replaced in 06,07,08)(upgraded 4,350 4,000 2,000 2,000 Radio repair (one-time reprogramming fee $50) 1,440 1,440 1,440 1,461 800 MHZ radio licenses fees 39 @ 3.12 per month 11,740 9,890 7,840 7,840 7030 Equipment > $5000 5,000 5,000 - - Video Recording system - Interview and breath test rooms 14,400 - - - AED replacement (9) @ $1,600 (grants of $2500, $3200, $1600) 19,400 5,000 - - 553,478 436,410 412,108 426,653 42.73%-21.15%-5.57%3.53% 20 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Contractual services 3030 Fire inspection services 5,249 17,412 12,763 15,500 125 15,500 - 0.00% 3032 Contractual fire services 334,179 356,039 372,284 379,163 252,776 423,393 44,230 11.67% 3050 Dispatching - 4,759 5,296 6,000 7,449 8,500 2,500 41.67% Total contractual services 339,428 378,210 390,343 400,663 260,350 447,393 46,730 11.66% Capital outlays: 7040 Vehicles & equipment 22,900 38,925 55,059 40,655 40,655 61,457 20,802 51.17% Total capital outlays 22,900 38,925 55,059 40,655 40,655 61,457 20,802 51.17% Debt Service: 8010 Principal 40,636 113,336 124,284 109,649 - 75,135 (34,514) -31.48% 8020 Interest 108,267 37,463 22,495 16,229 - 19,319 3,090 19.04% Total debt service 148,903 150,799 146,779 125,878 - 94,454 (31,424) -24.96% Total Fire 511,231 567,934 592,181 567,196 301,005 603,304 36,108 6.37% 2013 Fire Improvement Refunding Bonds will be retired in 2025 2017 Equipment Certificates will be retired in 2020 2018 Budget Summary 21 Fund: 100 Department: 4210 Fire Account Description 2015 2016 2017 2018 Description 3030 Fire inspection services 15,500 15,500 15,500 15,500 Contractual fee for Fire Marshalling services (SBM) 15,500 15,500 15,500 15,500 3032 Contractual fire services 356,039 372,283 379,163 423,393 Share of joint fire dept. costs (14-16.357%,15-16.424%,16-16.099%,17-15.819%) 356,039 372,283 379,163 423,393 3050 Dispatching 4,355 4,900 6,000 8,500 Anoka County dispatching fee 4,355 4,900 6,000 8,500 7040 Capital, vehicles & equipment 38,925 55,059 40,655 61,457 Share of joint fire department's capital costs 38,925 55,059 40,655 61,457 8010 Principal - Fire bond 63,232 73,251 74,056 75,135 16.158% of principal payment on 2013 refunding Fire bonds Principal - Equip Certs 52,557 50,712 35,593 - 16.158% of principal payment on 2017 Equipment Certificates 8020 Interest - Fire bond 33,629 22,081 12,453 12,127 16.158% of interest payment on 2013 refunding Fire bonds Interest - Equip Certs 1,381 736 3,776 7,192 16.158% of interest payment on 2017 Equipment Certificates 150,799 146,780 125,878 94,454 565,618 594,522 567,196 603,304 7.67%5.11%-4.60%6.37% 22 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Recreation (100 - 4350): Contractual services: 3036 Contractual recreation 98,467 111,289 108,241 113,787 51,812 117,349 3,562 3.13% 4800 Bonding & insurance 1,122 1,140 1,117 1,700 542 1,500 (200) -11.76% Total contractual services 99,589 112,429 109,358 115,487 52,354 118,849 3,362 2.91% Total Recreation 99,589 112,429 109,358 115,487 52,354 118,849 3,362 2.91% 2018 Budget Summary 23 Fund: 100 Department: 4350 Recreation Account Description 2015 2016 2017 2018 Description 3036 Contractual recreation 102,200 103,713 105,787 110,349 YMCA Mgt contract (39.5% of $279,364)(est. inflation + 1.5%)(use 3.2%) 8,700 9,000 8,000 7,000 Ice Skating supervision 110,900 112,713 113,787 117,349 4800 Bonding & insurance 1,700 1,700 1,700 1,500 Insurance & bonding cost. 1,700 1,700 1,700 1,500 112,600 114,413 115,487 118,849 5.04%1.61%0.94%2.91% 24 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent 2018 Budget Summary Parks (100 - 4360): Personnel services 0100 Salaries, regular 99,541 116,799 121,805 123,859 48,169 127,279 3,420 2.76% 0110 Overtime, regular 6,498 8,569 11,190 5,068 4,551 5,208 140 2.76% 0150 Salaries, part-time 35,701 29,448 24,469 33,180 2,914 33,180 - 0.00% 0300 Social Security 10,335 11,318 11,479 12,401 4,207 12,673 272 2.19% 0321 PERA 7,697 9,376 9,917 9,670 3,858 9,937 267 2.76% 0322 Pension expense GASB 68 - - 1,194 - - - - 0.00% 0400 Group insurance 17,532 20,899 21,399 24,354 5,003 25,554 1,200 4.93% 0500 Workers compensation 7,274 9,129 8,864 10,148 3,968 8,545 (1,603) -15.80% 0600 Unemployment 2,701 3,275 3,806 - - - - 0.00% Total personnel services 187,279 208,813 214,123 218,680 72,670 222,376 3,696 1.69% Materials & supplies: 1210 Supplies, bldgs & grnds 7,777 6,456 11,681 12,600 2,282 10,600 (2,000) -15.87% 1220 Supplies, vehicles & mowers 8,565 4,321 - 8,000 - 6,500 (1,500) -18.75% 1230 Supplies, equipment 9,803 6,693 6,583 8,500 2,031 6,250 (2,250) -26.47% 1600 Supplies, operating 8,131 14,461 9,788 10,900 1,403 10,900 - 0.00% 1700 Motor fuels & lubs 14,337 11,692 6,609 7,580 622 8,200 620 8.18% 2400 Uniforms & clothing 963 1,046 1,241 1,370 322 1,370 - 0.00% 2410 Mats & towels 479 609 704 728 219 728 - 0.00% Total materials & supplies 50,055 45,278 36,606 49,678 6,879 44,548 (5,130) -10.33% Contractual services: 3030 Other professional services 8,168 9,744 10,456 10,300 3,914 10,300 - 0.00% 3100 Telephone 1,272 1,575 2,014 2,056 424 2,056 - 0.00% 3200 Water & sewer 6,401 5,442 3,928 6,500 88 6,500 - 0.00% 3210 Electricity 9,689 10,214 9,711 10,000 3,088 10,000 - 0.00% 3220 Natural gas 9,121 4,546 4,057 4,800 2,291 4,800 - 0.00% 3530 Refuse collection - - 87 - - 0.00% 3610 Memberships 65 - 40 90 60 90 - 0.00% 3630 Training & conferences 740 913 736 1,670 175 1,670 - 0.00% 3900 Grants & subsidies 10,608 11,500 11,500 11,500 - 11,500 - 0.00% 4010 Rental, equipment 1,260 1,096 705 3,900 - 2,000 (1,900) -48.72% 4030 Portable restrooms 5,642 4,884 6,306 5,000 1,243 5,000 - 0.00% 4800 Bonding & insurance 12,010 10,729 10,659 16,000 5,103 15,000 (1,000) -6.25% 5110 Repairs, bldg & grounds 5,229 4,185 9,567 13,250 1,429 9,250 (4,000) -30.19% 5130 Repairs, equipment - - 1,590 - - - - 0.00% Total contractual services 70,205 64,828 71,356 85,066 17,815 78,166 (6,900) -8.11% Capital outlays 7030 Equipment 6,145 14,124 - 6,000 - - (6,000) -100.00% Total capital outlays 6,145 14,124 - 6,000 - - (6,000) -100.00% Total Parks 313,684 333,043 322,085 359,424 97,364 345,090 (14,334) -3.99% 110,106 107,962 140,744 122,714 25 Fund: 100 Department: 4360 Parks Account Description 2015 2016 2017 2018 Description 1210 Supplies, bldgs & grounds 200 200 200 200 Replace bleacher parts 200 200 200 200 Repair hockey boards, gates 300 300 300 300 Sod 3,000 2,000 2,000 2,000 County 10 trailway landscaping mulch, shrubs, and plants 500 500 500 500 Janitorial supplies 150 150 150 150 Snow shovels 200 200 200 200 Ice melt 500 500 500 500 Round up 500 500 500 500 Perennial flowers for park signs 1,500 1,500 1,500 1,500 Damaged building components (windows, locks, etc.) 300 300 300 300 Graffiti remover 500 250 250 250 Goose repellent 2,500 2,000 2,000 2,000 Replace irrigation heads - - 2,000 - City Hall Park sign (estimate) 2,500 2,000 2,000 2,000 Seed, fertilizer 12,850 10,600 12,600 10,600 1220 Supplies, vehicles 7,000 7,000 6,000 3,500 Oil filters, mower blades, tires, vehicle registration fees, 3,000 3,000 2,000 3,000 Miscellaneous repairs 10,000 10,000 8,000 6,500 1230 Supplies, equipment < $5000 250 250 250 250 Drinking fountain parts 250 250 250 250 Field Lights 250 250 250 250 Park signage 1,000 1,000 1,000 1,000 Bases, jox boxes, etc. - 2,000 - - Drag for ball fields - - 1,750 - Gutter broom attachment - - 500 - Chain saw (emergency only)(every 2 years) 2,500 2,500 4,500 4,500 Replace park equipment, fixtures and misc parts 4,250 6,250 8,500 6,250 1600 Supplies, operating 2,000 2,000 2,500 2,500 Fiber fill for play lots & courts 200 200 200 200 Tri mix 1,700 2,000 2,000 2,000 Wood chips for trees 500 500 500 500 Ag-lime for fields 500 500 500 500 Surface drying compound 400 400 800 800 Nets 2,900 3,100 3,100 3,100 Field paint & chalk (partially reimb by school district) 800 800 800 800 Landscaping materials 500 500 500 500 Hand tools 9,500 10,000 10,900 10,900 1700 Motor fuels & lubes 4,500 4,500 5,060 5,500 2,200 gallons of unleaded gas @ $2.50 3,150 3,150 2,520 2,700 900 gallons of diesel fuel @ $3.00 7,650 7,650 7,580 8,200 2400 Uniforms & clothing 350 350 350 350 Clothing allowance 2.0 FTE 820 820 820 820 Uniforms 18.2% of $4,500 200 200 200 200 Safety glasses, masks, ear protection, etc. 1,370 1,370 1,370 1,370 2410 Mats & towels 910 728 728 728 Share of floor mats and shop towels 18.2% of $4,000 910 728 728 728 3030 Other professional services 240 240 240 240 Fire extinguisher inspection/maint. (2@ $120) 600 600 600 600 HVAC maintenance 840 840 960 960 Fire sprinkler testing (4@ $210) 120 120 120 120 Backflow prevention testing (2@ $60) 8,500 8,500 8,380 8,380 Broadleaf control 10,300 10,300 10,300 10,300 26 THIS PAGE LEFT BLANK INTENTIONALLY 27 Fund: 100 Department: 4360 Parks (continued) Account Description 2015 2016 2017 2018 Description 3100 Telephone 985 1,206 1,206 1,206 Cellular phones (13.1% of $9,200) 850 850 850 850 GPS units for mowers (split with dept 4472) 1,835 2,056 2,056 2,056 3200 Water & wastewater 7,000 7,000 6,500 6,500 Parkland irrigation & park bathrooms 7,000 7,000 6,500 6,500 3210 Electricity 7,200 7,200 10,000 10,000 Est. 5 park buildings, park sec. lighting, court & field lighting & misc. 7,200 7,200 10,000 10,000 3220 Natural gas 4,800 4,800 4,800 4,800 Heating cost for Random, Hillview, Groveland, & Lambert Park bldgs. 4,800 4,800 4,800 4,800 3610 Memberships 40 40 40 40 Minnesota Safety Council 50 50 50 50 Playground inspector license 60 - - - Pesticide license renewal (every 2 years) 150 90 90 90 3630 Training & conferences 75 75 75 75 Computer classes 100 100 100 100 Hearing tests/RTN training (2@$50) 60 60 60 60 Maintenance EXPO 110 110 110 110 Loss control workshops 750 750 750 750 Playground inspection training (Certified Playground Safety Inspector CPSI) 375 375 375 375 Equipment training (18.2% of $2,050) - 200 200 200 Pesticide application class (every 2 years) 1,470 1,670 1,670 1,670 3900 Grants & subsidies 11,500 11,500 11,500 11,500 Lakeside Park share of operating costs 11,500 11,500 11,500 11,500 4010 Rental, equipment 500 2,900 3,900 2,000 Tools and equipment (sod cutter, chipper, concrete mixer, etc...) 500 2,900 3,900 2,000 4030 Portable restrooms 4,850 4,850 5,000 5,000 For May thru Oct, plus special events such as tournaments, & extra cleanings and insurance 4,850 4,850 5,000 5,000 4800 Bonding & insurance 12,000 12,000 12,000 11,000 Insurance policy premiums 4,000 4,000 4,000 4,000 Allowance for insurance policy deductibles 16,000 16,000 16,000 15,000 5110 Repairs, bldgs & grounds 750 750 750 750 Windows, doors, & lock repairs - - 4,000 - Sandblast trash cans and paint 1,000 1,000 1,000 1,000 Building exterior repairs 1,500 7,750 1,500 1,500 Irrigation system repairs (Silver View Park irrigation vault $6,250) 1,000 1,000 1,000 1,000 Field light repairs - 2,500 2,500 2,500 Repairs to playground equipment 2,500 2,500 2,500 2,500 Repairs to furnaces, plumbing, phones, electrical, etc 6,750 15,500 13,250 9,250 7030 Capital, equipment > $5000 - - 6,000 - Trencher (irrigation repairs and oak wilt treatments) - - 6,000 - 118,885 130,464 140,744 122,714 -14.74%9.74%7.88%-12.81% 28 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent 2018 Budget Summary Forestry (100 - 4380): Personnel services 0100 Salaries, regular - 2,820 3,006 2,928 1,214 3,009 81 2.77% 0110 Overtime, regular - 118 185 - 41 - - 0.00% 0300 Social Security - 203 219 224 95 230 6 2.68% 0321 PERA - 221 238 220 90 226 6 2.73% 0400 Group insurance - 530 584 630 37 666 36 5.71% 0500 Workers compensation - 168 160 184 72 155 (29) -15.76% Total personnel services - 4,060 4,392 4,186 1,549 4,286 100 2.39% 0.00% Materials & supplies 1200 Supplies, landscaping 3,018 1,944 1,949 5,900 495 4,400 (1,500) -25.42% Total materials & supplies 3,018 1,944 1,949 5,900 495 4,400 (1,500) -25.42% Contractual services 3030 Professional services 2,909 1,577 6,740 11,500 - 8,000 (3,500) -30.43% 3520 Tree removal 11,437 26,727 15,965 25,000 2,800 25,000 - 0.00% 3630 Training & conferences 15 170 428 900 100 900 - Total contractual services 14,361 28,474 23,133 37,400 2,900 33,900 (3,500) -9.36% Total Forestry 17,379 34,478 29,474 47,486 4,944 42,586 (4,900) -10.32% 30,418 25,082 43,300 38,300 29 Fund: 100 Department: 4380 Forestry Account Description 2015 2016 2017 2018 Description 1200 Supplies, landscaping 400 400 400 400 Landscaping materials 1,000 1,000 2,000 1,500 Small trees to replace damaged trees 2,000 2,000 3,000 2,500 Large trees - storm damage replacement 5,000 5,000 - - Ash tree replacement trees (MN DNR grant) 2,500 500 500 - EAB treatment supplies 10,900 8,900 5,900 4,400 3030 Professional services 10,000 5,000 5,000 5,000 Tree trimming 500 500 500 500 Asset mgt. software 25,000 15,000 5,000 2,500 Forestry consulting 1,000 1,000 1,000 - Tree injections (Ash every 2 years) 36,500 21,500 11,500 8,000 3520 Tree removal 28,000 25,000 25,000 25,000 Remove or treat diseased trees 7,500 7,500 - - Ash tree removal (MN DNR grant) 35,500 32,500 25,000 25,000 3630 Training & memberships 300 800 800 800 Tree Inspector training 100 100 100 100 Tree Inspector license 400 900 900 900 83,300 63,800 43,300 38,300 -14.12%-23.41%-32.13%-11.55% 30 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Public Works Administration (100-4410): Personnel services: 0100 Salaries, regular 107,821 86,232 101,413 106,006 40,296 107,579 1,573 1.48% 0110 Salaries, overtime 141 - - - - - - 0.00% 0300 Social Security 7,782 5,856 7,223 8,109 2,869 8,230 121 1.49% 0321 PERA 7,753 5,843 7,562 7,950 3,010 8,069 119 1.50% 0400 Group insurance 13,202 11,422 14,579 16,416 6,310 17,334 918 5.59% 0500 Workers compensation 1,839 1,885 1,215 1,405 549 1,185 (220) -15.66% Total personnel services 138,538 111,238 131,992 139,886 53,034 142,397 2,511 1.80% Materials & supplies: 1230 Supplies, equipment 130 - - - - - - 0.00% 1600 Operating supplies 297 300 45 300 300 230 (70) -23.33% 2400 Uniforms & clothing - 56 180 400 - 200 (200) -50.00% Total materials and supplies 427 356 225 700 300 430 (270) -38.57% Contractual services: 3030 Other professional services 524 336 1,073 900 217 900 - 0.00% 3100 Telephone 636 616 709 773 193 773 - 0.00% 3610 Memberships 632 430 507 490 435 755 265 54.08% 3630 Training & conferences 490 600 1,164 895 192 895 - 0.00% 3800 Mileage reimbursement 290 203 - 300 - 150 (150) -50.00% Total contractual services 2,572 2,185 3,453 3,358 1,037 3,473 115 3.42% Total public works administration 141,537 113,779 135,670 143,944 54,371 146,300 2,356 1.64% 2,541 3,678 4,058 3,903 2018 Budget Summary 31 Fund: 100 Department: 4410 Public Works Adminstration Account Description 2015 2016 2017 2018 Description 1600 Operating Supplies 230 230 230 230 Office supplies 70 70 70 - National Public Works Week posters 300 300 300 230 2400 Uniforms & clothing 400 400 400 200 33% of Supervisor's uniform cost. 400 400 400 200 3030 Other professional services 100 100 100 100 Physicals & drug testing - new employee 500 500 500 500 Asset mgt software 300 300 300 300 Drug & alcohol testing - federal mandate 900 900 900 900 3100 Telephone 630 773 773 773 Cellphone (8.4% of $9,200) 630 773 773 773 3610 Memberships/license fee 190 375 400 400 American Public Works Association memb. (APWA) (1/2 of $800) 60 60 60 60 City Engineer's Association of MN (CEAM) - - - - NASASP (National Assoc. of State Agencies for Surplus Property) 30 30 30 30 MN Safety Council - 265 - 265 MN Board of AELSLAGID (PE Renewal even years) 250 - - - American Society of Civil Engineers 530 730 490 755 3630 Training & conferences 500 1,500 500 500 CEAM / APWA conferences 50 50 50 50 Computer classes/Web training 15 15 15 15 Hearing tests/RTN training (.34 FTE@$50) 30 30 30 30 Maintenance Expo 200 200 200 200 Required continuing education seminars 100 100 100 100 Supervisor training 895 1,895 895 895 3800 Mileage reimbursement 300 300 300 150 vehicle mileage reimbursement 300 300 300 150 3,955 5,298 4,058 3,903 5.05%33.96%-23.41%-3.82% 32 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent 2018 Budget Summary Building & Grounds Maintenance (100 - 4460): Personnel services: 0100 Salaries, regular 12,389 13,885 14,106 14,141 5,202 14,530 389 2.75% 0110 Salaries, overtime 626 382 447 1,048 145 1,077 29 2.77% 0300 Social Security 946 1,052 1,065 1,161 277 1,193 32 2.76% 0321 PERA 934 1,053 1,071 1,140 261 1,171 31 2.72% 0400 Group insurance 2,943 2,413 2,468 2,952 632 3,114 162 5.49% 0500 Workers compensation 641 1,153 828 945 370 800 (145) -15.34% Total personnel services 18,479 19,938 19,985 21,387 6,887 21,885 498 2.33% Materials & supplies: 1210 Supplies, building & grounds 2,283 3,762 2,065 2,000 3,289 2,000 - 0.00% 1220 Supplies, vehicles - 68 - - - - - 0.00% 1230 Supplies, equipment 825 209 90 1,300 - 1,000 (300) -23.08% 1600 Supplies, operating 2,534 3,570 3,077 4,300 204 4,300 - 0.00% 2400 Uniforms & clothing 103 91 132 117 36 117 - 0.00% 2410 Mats & towels 925 750 1,295 630 287 1,000 370 58.73% Total materials & supplies 6,670 8,450 6,659 8,347 3,816 8,417 70 0.84% Contractual services: 3030 Other professional services 18,737 31,200 27,483 36,160 12,295 35,960 (200) -0.55% 3100 Telephone 112 97 117 129 34 129 - 0.00% 3200 Water & sewer 807 786 949 1,000 187 1,000 - 0.00% 3210 Electricity 28,341 27,793 26,149 14,000 7,734 20,000 6,000 42.86% 3220 Natural gas 26,488 17,502 12,446 19,000 9,736 17,000 (2,000) -10.53% 3530 Refuse collection 7,806 7,611 7,954 9,334 4,632 8,500 (834) -8.94% 3610 Memberships 10 - - - - - - 0.00% 3630 Training & conferences 19 10 19 - - - - 0.00% 4010 Rental, equipment - - - 200 - 200 - 0.00% 4800 Insurance 4,621 4,694 4,598 7,000 2,233 7,000 - 0.00% 5110 Repairs, bldgs & grounds 10,208 24,920 3,129 11,100 9,435 10,100 (1,000) -9.01% 5130 Repairs, equipment 4,409 2,179 6,729 5,000 702 5,000 - 0.00% Total contractual services 101,558 116,792 89,573 102,923 46,988 104,889 1,966 1.91% 125,242 96,232 111,270 113,306 Capital outlays 7030 Equipment - 246,729 - - - - - 0.00% Total capital outlays - 246,729 - - - - - 0.00% Total buildings & grounds 126,707 391,909 116,217 132,657 57,691 135,191 2,534 1.91% 33 Fund: 100 Department: 4460 Building & Ground Maintenance Account Description 2015 2016 2017 2018 Description 1210 Supplies, bldgs & grounds 2,000 2,000 2,000 2,000 Bldg repairs, cleaning/heating supplies, batteries 2,000 2,000 2,000 2,000 1230 Supplies, equipment < $5000 1,300 1,300 1,300 1,000 Repair parts, filters, hoses, etc., office furniture 1,300 1,300 1,300 1,000 1600 Supplies, operating 500 1,500 1,500 1,500 Cleaning supplies 300 150 150 150 Lumber & fasteners 550 300 300 300 Repair items & hardware 300 100 100 100 First aid supplies 500 200 200 200 Light bulbs & ballasts 500 750 750 750 Paper supplies 500 400 400 400 Mechanical items, fans, motors, etc 100 - - - Goose repellent 200 - - - Weed control - city hall 200 200 200 200 Office supplies 700 700 700 700 Paint & supplies - parking lot & building 4,350 4,300 4,300 4,300 2400 Uniforms & clothing 81 81 81 81 Uniforms (1.8% of $4,500) 36 36 36 36 Clothing & boot allowance (.20 @$175) 117 117 117 117 2410 Mats & towels 90 90 90 90 Share of floor mats and shop towels (1.8% of $5,000) 540 540 540 910 Floor mats at CH ($45/month) 630 630 630 1,000 3030 Other professional services 180 180 180 180 Backflow prevention testing (3@$60) 60 60 60 60 Boiler & pressure vessel registration program 5,500 5,520 5,520 5,520 HVAC maintenance (City Hall & PW facilities) 100 100 100 100 MN DOL operating permit - elevator (previously in acct. 5110) 18,000 19,500 19,500 19,500 City Hall cleaning contract (renews in 2016) 3,500 3,500 3,500 3,500 Carpet cleaning, floor striping & waxing (2 times) 680 680 680 680 Fire sprinkler testing 1,320 1,320 1,320 1,320 Pest control (12@$110) 200 200 200 - MDH Monitoring well maint. permit - PW bldg. (wells sealed) - - 4,500 4,500 Service contract for generator 600 600 600 600 Fire extingiusher inspection/service (30@$20) 30,140 31,660 36,160 35,960 3100 Telephone 120 129 129 129 Cellphone (1.6% of $7,500)($9,200) 120 129 129 129 3200 Water & Sewer 1,400 1,400 1,000 1,000 Service at City Hall and Public Works buildings 1,400 1,400 1,000 1,000 3210 Electricity 28,000 14,000 14,000 20,000 Electricity at City Hall and Public Works buildings 28,000 14,000 14,000 20,000 3220 Natural gas 20,000 20,000 19,000 18,000 Natural gas at City Hall and Public Works buildings 20,000 20,000 19,000 18,000 3530 Refuse collection 3,161 1,630 1,030 196 Hazardous waste disposal, Lamps $100, batteries $30 264 264 264 264 Hazardous waste annual fee (State of MN PCA) 230 90 90 90 Hazardous waste generator license fee (Ramsey County) 150 150 150 150 Used oil filters ($100 in vehicle maint.) 7,200 7,200 7,800 7,800 Facility dumpsters, city hall, public works 11,005 9,334 9,334 8,500 4010 Rental, equipment 200 200 200 200 Misc. rentals 200 200 200 200 4800 Bonding & insurance 5,500 5,500 5,500 5,500 Insurance policy premiums 1,500 1,500 1,500 1,500 Allowance for insurance policy deductibles 7,000 7,000 7,000 7,000 5110 Repairs, bldgs & grounds 2,500 2,500 2,500 1,500 Door & gate opener repairs 2,500 2,500 2,500 2,500 Building repairs 750 750 750 750 Elevator maintenance & repairs 350 350 350 350 Fire sprinklers & alarm repairs 5,000 5,000 5,000 5,000 General building & ground maintenance 11,100 11,100 11,100 10,100 5130 Repairs, equipment 5,000 5,000 5,000 5,000 HVAC, plumbing & electrical repairs 5,000 5,000 5,000 5,000 122,362 108,170 111,270 114,306 7.17%-11.60%2.87%2.73% 34 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent 2018 Budget Summary Vehicle & Equipment Maintenance (100 - 4465): Personnel services: 0100 Salaries, regular 33,251 34,939 29,313 36,826 13,730 39,644 2,818 7.65% 0110 Salaries, overtime 1,110 - - 556 254 602 46 8.27% 0300 Social Security 2,492 2,540 2,133 2,860 1,000 3,078 218 7.62% 0321 PERA 2,490 2,579 2,188 2,804 1,044 3,019 215 7.67% 0400 Group insurance 5,565 4,635 4,767 7,344 3,083 7,650 306 4.17% 0500 Workers compensation 1,628 2,487 1,648 1,785 698 1,581 (204) -11.43% Total personnel services 46,536 47,180 40,049 52,175 19,809 55,574 3,399 6.51% Materials & supplies: 1220 Supplies, vehicles 16,616 9,522 17,722 19,950 4,883 19,950 - 0.00% 1230 Supplies, equipment 4,752 5,027 4,378 4,100 4,570 5,500 1,400 34.15% 1600 Supplies, operating 3,771 6,404 6,065 4,200 1,015 4,650 450 10.71% 1700 Motor fuels & lubricants - unleade 4,051 2,074 3,359 3,260 764 3,260 - 0.00% 1701 Motor fuels & lubricants - diesel 7,663 85 - - 5,309 - - 0.00% 2400 Uniforms & clothing 414 878 654 375 85 375 - 0.00% 2410 Mats & towels 180 185 190 220 55 220 - 0.00% Total materials & supplies 37,447 24,175 32,368 32,105 16,681 33,955 1,850 5.76% Contractual services: 3030 Other professional services 18 17 25 - - 0.00% 3100 Telephone 263 228 268 387 96 387 - 0.00% 3530 Refuse collection - - - 100 221 100 - 0.00% 3610 Memberships 606 - - 80 30 80 - 0.00% 3630 Training 283 54 203 920 - 625 (295) -32.07% 4010 Rental, equipment - - - 100 - 100 - 0.00% 5120 Repairs, vehicles 19,894 6,872 7,114 16,800 4,654 16,800 - 0.00% 5130 Repairs, equipment 4,914 5,805 6,939 5,500 - 5,500 - 0.00% Total contractual services 25,978 12,976 14,549 23,887 5,001 23,592 (295) -1.23% Capital outlays 7030 Equipment 6,050 - - - - - - 0.00% Total capital outlays 6,050 - - - - - - 0.00% Total vehicle & equipment maintenance 116,011 84,331 86,966 108,167 41,491 113,121 4,954 4.58% 37,151 46,917 55,992 57,547 35 Fund: 100 Department: 4465 Vehicle & Equipment Maintenance Account Description 2015 2016 2017 2018 Description 1220 Supplies, vehicles 200 200 200 200 Brake fluid 700 700 700 700 Misc parts, fastners 500 500 500 500 Anti freeze 300 300 300 300 Air conditioning gas 500 500 500 500 Headlamps, spots, & bulbs 800 800 800 800 Tune up items 500 500 500 500 Wiper blades & fluid 1,950 1,950 1,950 1,950 Minor repairs, rebuilds 1,500 1,500 1,500 1,500 Automotive parts 2,000 2,000 2,000 2,000 Filters: oil, air, fuel, transmission 2,000 2,000 2,000 2,000 Brake pads & shoes 9,000 9,000 9,000 9,000 Tires & batteries 19,950 19,950 19,950 19,950 1230 Supplies, equipment < $5000 200 200 200 1,000 Small equipment tune up items 400 400 400 1,000 Filters belts & hoses 1,000 1,000 1,000 1,000 Hydraulic system repairs 2,500 2,500 2,500 2,500 Vehicle Asset Management software 3,700 3,700 - - Tire mounting machine (defer to 2016)(bought code scanner in 2015) 2,000 2,000 - - Tires 9,800 9,800 4,100 5,500 1600 Supplies, operating 1,200 1,200 1,200 1,000 Battery charger, Load tester 350 350 350 350 Welding supplies 100 100 100 500 Chains, clevises, & hitch pins 700 700 700 700 Equipment & vehicle cleaning supplies 500 500 500 500 Steel for repairs & fabrication 350 350 350 350 License tabs 500 500 500 750 Solvents & degreasers 500 500 500 500 Fastners & electrical supplies 4,200 4,200 4,200 4,650 1700 Motor fuels & lubricants 60 60 60 60 Gear lube 200 200 200 200 ATF - 7 cases 500 500 500 500 Aftermarket additives 2,500 2,500 2,500 2,500 Engine oil: 150 gallons (synthetic) 3,260 3,260 3,260 3,260 2400 Uniforms & clothing 249 249 270 270 Uniforms 6% of $4,500) 105 105 105 105 Clothing and boot allowance (.6@$175) 354 354 375 375 2410 Mats & towels 275 220 220 220 Share of floor mats and shop towels (5.5% of $4,000) 275 220 220 220 3100 Communications 308 387 387 387 Cellular telephone (4.1% of $9,200) 308 387 387 387 3530 Refuse collection 100 100 100 100 Oil filter recycling ($150 in 4460-3530) 100 100 100 100 3610 Memberships 60 60 60 60 Vehicle inspection license renewal (DOT required) 20 20 20 20 Minnesota Safety Council (6% of $465) 80 80 80 80 3630 Training 30 30 30 30 Hearing test/RTN training (.6@$50) 30 30 30 30 Maintenance Expo 200 200 495 200 Misc training 175 175 175 175 ASE certification 75 190 190 190 Vehicle inspection recertification (DOT required) 510 625 920 625 4010 Rental, equipment 100 100 100 100 Specialty tool & equipment rental 100 100 100 100 5120 Repairs, vehicles 8,000 8,000 8,000 8,000 Accident repairs 750 750 750 750 Alignments 1,000 1,000 1,000 1,000 Glass replacement 400 400 400 400 Radiator repairs, replacement 2,000 2,000 1,960 1,960 Tire repairs 700 950 950 950 Ignition scanner software update 1,700 1,700 1,740 1,740 Mitchell On Demand Software 2,000 2,000 2,000 2,000 Transmission repairs 16,550 16,800 16,800 16,800 5130 Repairs, equipment 500 500 500 500 Accident repairs 3,000 3,000 3,000 3,000 Mechanical repairs 2,000 2,000 2,000 2,000 Motor repairs 5,500 5,500 5,500 5,500 7030 Capital, equipment > $5000 - - - - Hoist adaptor - - - - 60,987 61,376 55,992 57,547 2.50%0.64%-8.77%2.78% 36 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent 2018 Budget Summary Street Pavement Management (100 - 4470): Personnel services: 0100 Salaries, regular 102,349 114,727 116,046 117,480 44,206 119,344 1,864 1.59% 0110 Salaries, overtime 3,470 3,154 2,982 3,379 1,183 3,472 93 2.75% 0150 Salaries, part-time 5,910 5,452 3,872 7,488 455 7,488 - 0.00% 0300 Social Security 8,253 8,938 8,935 9,817 3,387 9,967 150 1.53% 0321 PERA 7,527 8,541 8,465 9,064 3,337 9,211 147 1.62% 0322 Pension expense GASB 68 - - 1,709 - - - - 0.00% 0400 Group insurance 11,703 13,953 14,585 18,972 5,347 19,782 810 4.27% 0500 Workers compensation 7,123 10,532 8,359 9,530 3,727 8,048 (1,482) -15.55% Total personnel services 146,335 165,297 164,953 175,730 61,642 177,312 1,582 0.90% Materials & supplies: 1230 Supplies, equipment 5,712 469 30 2,950 956 1,500 (1,450) -49.15% 1240 Supplies, streets 25,299 5,411 2,193 10,000 146 7,500 (2,500) -25.00% 1260 Supplies, traffic control 429 - 1,375 750 - 1,600 850 113.33% 1600 Supplies, operating 2,815 2,250 1,479 1,000 243 1,000 - 0.00% 1700 Motor fuels & lubricants 9,515 6,391 4,356 7,650 741 8,250 600 7.84% 2400 Uniforms & clothing 917 820 1,394 701 182 701 - 0.00% 2410 Mats & towels 351 397 399 436 116 436 - 0.00% Total materials & supplies 45,038 15,738 11,226 23,487 2,384 20,987 (2,500) -10.64% Contractual services: 3030 Other professional services 5,279 11,975 2,486 20,950 1,962 18,450 (2,500) -11.93% 3100 Telephone 756 641 718 966 228 966 - 0.00% 3610 Memberships 247 190 195 255 250 255 - 0.00% 3630 Training & conferences 583 760 838 1,115 - 1,115 - 0.00% 4010 Rental, equipment 1,125 4,500 850 6,100 2,500 6,100 - 0.00% 4800 Insurance 6,261 4,157 4,073 6,200 1,978 6,200 - 0.00% 5130 Repairs, equipment - 10 7 500 - 500 - 0.00% Total contractual supplies 14,251 22,233 9,167 36,086 6,918 33,586 (2,500) -6.93% Total street pavement management 205,624 203,268 185,346 235,303 70,944 231,885 (3,418) -1.45% 37,971 20,393 59,573 54,573 37 Fund: 100 Department: 4470 Pavement Management Account Description 2015 2016 2017 2018 Description 1230 Supplies, equipment < $5000 500 500 500 500 Safety vests and other safety equipment - - 1,000 1,000 Radio/hearing protection - - 500 - Push mower - - 450 - Chainsaw - - 500 - Backpack blower 500 500 2,950 1,500 1240 Supplies, street repair 20,000 20,000 7,500 5,000 Asphalt & concrete for street patching & curb repair 1,000 1,000 1,000 1,000 Disposal 1,500 1,500 1,500 1,500 Bituminous tack coat/crack fill material 22,500 22,500 10,000 7,500 1260 Supplies, traffic control 400 400 250 725 Traffic cones/baracades 600 600 500 875 portable signs (traffic control) 1,000 1,000 750 1,600 1600 Supplies, operating 650 650 850 850 Asphalt hand tools, rakes, etc. 100 100 150 150 Batteries, shop supplies, etc. 750 750 1,000 1,000 1700 Motor fuels & lubricants 5,250 5,250 4,200 4,500 Diesel fuel: 1500 gallons @ $3.00 4,500 4,125 3,450 3,750 Unleaded fuel: 1500 gallons @ $2.50 9,750 9,375 7,650 8,250 2400 Uniforms & clothing 491 491 491 491 Uniforms (10.9% of $4,500) 210 210 210 210 Clothing and boot allowance (1.2@$175) 701 701 701 701 2410 Mats & towels 545 436 436 436 Share of floor mats and shop towels (10.9% of $4,000) 545 436 436 436 3030 Other professional services 1,800 1,800 1,800 1,800 Pavement Mgmt software annual maintenance. 2,500 2,500 2,500 2,500 Engineering services. 500 500 500 500 Asset management software annual maintenance 500 650 650 650 ROW weed control 1,500 1,500 1,500 - Material dump charges 2,000 2,000 2,000 1,000 Sidewalk joint corrections - - 12,000 12,000 CSAH 10 median and ROW maintenance (mowing and weed wipping) - - - - Striping of streets (Ramsey County)(move to 4475) 8,800 8,950 20,950 18,450 3100 Communications 893 966 966 966 Cellular telephones (10.5% of $9,200) 893 966 966 966 3610 Memberships 190 190 200 200 American Public Works Association memb. (APWA) (1/4 of $800) - 15 15 15 Pesticide license renewal (TF) 40 40 40 40 MN Safety Council 230 245 255 255 3630 Training & conferences 50 50 50 50 Computer classes 200 200 200 200 Electronics updates, other classes 60 60 60 60 Hearing test/RTN training (1.16@$50) 60 60 60 60 Maintenance Expo 150 150 150 150 APWA/MN conferences. 250 250 250 250 Pavement, sealcoating, patching & sealcoating seminars. 210 210 210 210 Equipment operator training 60 60 60 60 Vehicle inspection license renewal 75 75 75 75 Vehicle inspection recertification 300 - - - Work zone traffic control (every 3 years) 1,415 1,115 1,115 1,115 4010 Rentals, equipment 2,800 2,800 3,600 3,600 Annual trade-in of skidsteer loaders (no trade-in during 2017) 700 2,500 2,500 2,500 Specialized equip rental (chipper, crack sealing,) 3,500 5,300 6,100 6,100 4800 Bonding & insurance 4,800 4,800 4,800 4,800 Insurance policy premiums 1,400 1,400 1,400 1,400 Allowance for insurnace policy deductibles 6,200 6,200 6,200 6,200 5130 Repairs, equipment 500 500 500 500 Misc. equipment repairs 5,000 - - - Repair crack filling machine (will not repair, rent instead)(see 4010) 5,500 500 500 500 62,284 58,538 59,573 54,573 -8.10%-6.01%1.77%-8.39% 38 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent 2018 Budget Summary Street Snow & Ice Control (100 - 4472): Personnel services: 0100 Salaries, regular 62,998 60,902 62,061 60,224 24,237 61,887 1,663 2.76% 0110 Salaries, overtime 19,281 7,711 9,926 8,130 3,654 8,353 223 2.74% 0300 Social Security 5,944 5,016 5,164 5,229 2,016 5,374 145 2.77% 0321 PERA 5,855 4,852 5,431 5,127 2,051 5,267 140 2.73% 0400 Group insurance 11,550 7,972 8,513 11,520 3,782 12,000 480 4.17% 0500 Workers compensation 6,116 8,074 6,538 7,464 2,919 6,323 (1,141) -15.29% Total personnel services 111,744 94,527 97,633 97,694 38,659 99,204 1,510 1.55% Materials & supplies: 1230 Supplies, equipment 19,758 8,185 1,942 9,500 517 7,400 (2,100) -22.11% 1600 Supplies, operating 41,589 24,726 25,005 31,175 1,960 31,175 - 0.00% 1700 Motor fuels & lubricants 13,786 3,586 3,215 2,980 418 3,180 200 6.71% 2400 Uniforms & clothing 457 397 487 528 156 528 - 0.00% 2410 Mats & towels 331 341 356 328 100 328 - 0.00% Total materials & supplies 75,921 37,235 31,005 44,511 3,151 42,611 (1,900) -4.27% Contractual services: 3030 Other professional services 1,592 1,321 1,400 1,325 - 1,375 50 3.77% 3100 Telephone and data cards 753 1,713 907 1,179 592 1,179 - 0.00% 3610 Memberships 70 - - 70 80 70 - 0.00% 3630 Training & conferences 84 118 185 285 - 285 - 0.00% 5130 Repairs, equipment 3,373 22 821 2,500 1,890 2,500 - 0.00% Total contractual supplies 5,872 3,174 3,313 5,359 2,562 5,409 50 0.93% Capital outlays 7030 Equipment 2,618 - - - - - 0.00% Total capital outlays 2,618 - - - - - - 0.00% Total streets snow & ice control 196,155 134,936 131,951 147,564 44,372 147,224 (340) -0.23% 40,409 34,318 49,870 48,020 39 Fund: 100 Department: 4472 Snow & Ice Control Account Description 2015 2016 2017 2018 Description 1230 Supplies, equipment < $5000 250 250 500 500 Filters - - 3,000 4,500 Skidsteer broom - - 4,000 - Snow blower for skid steer - - - 400 Chloride Tank 1,800 1,800 2,000 2,000 Cutting edges, plow shoes 2,050 2,050 9,500 7,400 1600 Supplies, operating 800 800 800 800 Welding supplies, steel stock, sod for boulevards, etc. 2,250 2,250 2,250 2,250 Liquid Mg Chloride: 1,500 gallons @ $1.50 per gallon. 28,000 28,125 28,125 28,125 Salt: 375 tons @ $75 per ton. 31,050 31,175 31,175 31,175 1700 Motor fuels & lubricants 180 180 180 180 Engine oil: 30 gallons @ $6.00 per gallon. 3,500 3,500 2,800 3,000 Diesel fuel: 1,000 gallons @ $3.00 per gallon. 3,680 3,680 2,980 3,180 2400 Uniforms & clothing 370 370 370 370 Uniforms (8.2% of $4,500) 158 158 158 158 Clothes & boots allowance (.9@$175) 528 528 528 528 2410 Mats & towels 410 328 328 328 Cost share of mats & towels (8.2% of $4,000) 410 328 328 328 3030 Other professional services 1,200 1,200 1,325 1,375 Weather service reports 1,200 1,200 1,325 1,375 3100 Telephone 473 579 579 579 Cellphone (6.3% of $7,500)($9,200) 360 1,680 600 600 GPS data cards 833 2,259 1,179 1,179 3610 Memberships 70 70 70 70 Minnesota Safety Council 70 70 70 70 3630 Training 75 75 85 85 Hearing tests/RTN training (1.1@$XX) 400 400 200 200 Defensive Driving class (2 staff) 475 475 285 285 5130 Repairs, equipment 2,500 2,500 2,500 2,500 Plow, blower, salt spreader repairs, paint plow assemblies 2,500 2,500 2,500 2,500 7030 Capital, equipment > $5000 5,600 - - - Plow control update (#445) 8,350 - - - GPS equipment for plow trucks 13,950 - - - 56,746 44,265 49,870 48,020 -10.64%-21.99%12.66%-3.71% 40 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent 2018 Budget Summary Street Sign Maintenance (100 - 4475): Personnel services: 0100 Salaries, regular 23,579 18,442 18,377 18,721 6,923 18,960 239 1.28% 0110 Salaries, overtime 450 657 547 845 184 868 23 2.72% 0150 Salaries, part-time - - - 2,496 - 2,496 - 0.00% 0300 Social Security 1,787 1,399 1,365 1,689 524 1,708 19 1.12% 0321 PERA 1,696 1,399 1,369 1,467 522 1,488 21 1.43% 0400 Group insurance 2,698 2,526 2,467 3,456 844 3,600 144 4.17% 0500 Workers compensation 2,188 1,966 1,561 1,778 695 1,497 (281) -15.80% Total personnel services 32,398 26,389 25,686 30,452 9,692 30,617 165 0.54% Materials & supplies: 1600 Supplies, operating 1,590 10,570 4,502 28,500 436 28,500 - 0.00% 2400 Uniforms & clothing 165 143 147 435 56 435 - 0.00% 2410 Mats & towels 119 122 125 160 36 160 - 0.00% Total materials & supplies 1,874 10,835 4,774 29,095 528 29,095 - 0.00% Contractual services: 3030 Other professional services - 11 3,762 500 - 4,500 4,000 800.00% 3100 Telephone 180 157 183 230 209 230 - 0.00% 3250 Electricity - traffic signals 2,569 2,906 2,647 3,000 794 3,000 - 0.00% 3630 Training & conferences 30 17 30 100 - 20 (80) -80.00% 5130 Repairs, equipment 291 - - 500 55 500 - 0.00% Total contractual supplies 3,070 3,091 6,622 4,330 1,058 8,250 3,920 90.53% Total street sign maintenance 37,342 40,315 37,082 63,877 11,278 67,962 4,085 6.40% 41 Fund: 100 Department: 4475 Street Sign Maintenance Account Description 2015 2016 2017 2018 Description 1600 Supplies, operating 17,500 17,500 17,500 17,500 Signs, posts, sign hardware, and supplies 7,500 7,500 7,500 7,500 Street name sign panels, posts, hardware 1,750 1,750 1,750 1,750 Pavement marking paint (moved from 4470) 500 500 500 500 Shop supplies - fastners, degreasers, etc 500 500 500 500 Graffitti remover - 750 750 750 (3) Traffic counters 27,750 28,500 28,500 28,500 2400 Uniforms & clothing 81 81 81 81 Uniforms (1.8% of $4,500) 354 354 354 354 Clothes and boot allowance (.2@$175) 435 435 435 435 2410 Mats & towels 340 160 160 160 Cost share of mats & towels (4% of $4,000) 340 160 160 160 3030 Other professional services 5,000 5,000 - 4,000 Contract pavement marking (Ramsey Co)(moved from 4470) 500 500 500 500 Asset management software annual maintenance 5,500 5,500 500 4,500 3100 Telephone 200 230 230 230 Cellphone (2.5% of $8,000)($9,200) 200 230 230 230 3250 Electricity - traffic signals 2,000 2,000 3,000 3,000 Electricity for traffic signals 2,000 2,000 3,000 3,000 3630 Training & conferences 80 80 80 - Equipment operator training 20 20 20 20 Hearing test/RTN trainging (.4@$50) 100 100 100 20 5130 Repairs, equipment 500 500 500 500 Traffic signal repairs & maintenance 500 500 500 500 36,825 37,425 33,425 37,345 289.68%1.63%-10.69%11.73% Grand Total all PW Departments 343,159 315,072 314,188 315,694 7.86%-8.18%-0.28%0.48% 42 Y-T-D 2014 2015 2016 2017 05/31/2017 2018 Change from 2017 Actual Actual Actual Budget Actual Request Dollar Percent Convention & Visitor's Bureau (100-4653) Contractual services 3045 N Metro Convention Bureau 63,049 65,654 64,038 61,750 14,150 61,750 - 0.00% Total contractual services 63,049 65,654 64,038 61,750 14,150 61,750 - 0.00% Total Convention & Visitor's Bureau 63,049 65,654 64,038 61,750 14,150 61,750 - 0.00% Miscellaneous (100 - 4700): Personnel services 0300 Social security 248 210 171 - 72 - - 0.00% 0321 PERA 306 388 439 - 155 - - 0.00% 0400 Group insurance 489 488 540 - 184 - - 0.00% 0750 Fitness program 3,883 3,889 3,911 6,500 1,425 6,500 - 0.00% Total personnel services 4,926 4,975 5,061 6,500 1,836 6,500 - 0.00% Contractual services 3065 Family & youth social services 19,763 20,178 20,259 20,461 20,461 21,075 614 3.00% Total contractual services 19,763 20,178 20,259 20,461 20,461 21,075 614 3.00% Miscellaneous 9900 Transfers - EDA - 16,000 50,000 50,000 - 50,000 - 0.00% 9900 Transfers - Vehicle & Equip. Fund 100,000 110,000 150,000 175,000 - 200,000 25,000 14.29% 9900 Transfers - Special Projects 825,000 200,000 375,000 75,000 - 75,000 - 0.00% 9900 Community Center 165,000 170,000 170,000 175,000 - 175,000 - 0.00% Total miscellaneous 1,090,000 496,000 745,000 475,000 - 500,000 25,000 5.26% 0.00% Total miscellaneous 1,114,689 521,153 770,320 501,961 22,297 527,575 25,614 5.10% Debt Service (100 - 4750): Debt Service ESP 8011 Lease payable - 20,268 17,791 18,331 7,571 18,887 556 3.03% 8021 Interest - - 6,704 6,165 2,635 5,609 (556) -9.02% Total debt service - 20,268 24,495 24,496 10,206 24,496 - 0.00% 2018 Budget Summary 43 Fund: 100 Department: 4653 Convention & Visitor's Bureau Account Description 2015 2016 2017 2018 Description 3045 N Metro Convention Bureau 53,200 60,800 61,750 61,750 Payment of 95% of hotel/motel tax collections to (3% tax on gross receipts) support the promotion of tourism. (City retains 5% for administration) 53,200 60,800 61,750 61,750 Fund: 100 Department: 4700 Miscellaneous Account Description 2015 2016 2017 2018 Description 0750 Fitness program 6,500 6,500 6,500 6,500 Fitness program (maximum $55/month paid with employee sick leave time). 6,500 6,500 6,500 6,500 3065 Family & youth social services 20,178 20,783 20,461 21,075 Northeast Youth and Family Services (NYFS)(1% - 2017) 20,178 20,783 20,461 21,075 9900 Transfers - miscellaneous 10,000 50,000 50,000 50,000 Transfer to Economic Development Authority (EDA) 50,122 75,000 75,000 75,000 Transfer to Special Projects fund 60,122 125,000 125,000 125,000 9900 Transfers - miscellaneous 110,000 150,000 175,000 200,000 Transfer to Vehicle & Equipment Fund 110,000 150,000 175,000 200,000 9990 Community Center 170,000 170,000 175,000 175,000 Subsidy for Community Center operating costs 170,000 170,000 175,000 175,000 366,800 472,283 501,961 527,575 Fund: 100 Department: 4750 Debt Service Account Description 2015 2016 2017 2018 Description 8011 Lease payable - 24,323 18,331 18,887 Lease payable Energy Savings Program 8021 Interest - - 6,165 5,609 Interest - 24,323 24,496 24,496 44 THIS PAGE LEFT BLANK INTENTIONALLY 45