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 - 2016/07/05
CITY OF MOUNDS VIEW CITY COUNCIL WORK SESSION AGENDA MOUNDS VIEW CITY HALL TUESDAY, July 5, 2016 7:00 p.m. ROLL CALL: Flaherty, Gunn, Hull, Meehlhause, Mueller 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 2017 Draft General Fund Budget 2. Public Works Facility Update 3. Review Take-Aways from the 2016 LMC Annual Conference 4. Review Council Member Compensation Adjustment Next Work Session: Monday, August 1, 2016, at 7pm Next City Council Meeting: Monday, July 11, 2016, at 7pm City of Mounds View 2017 Budget Summary Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 General Fund:Actual Actual Actual Budget Actual Request Dollar Percent Revenues: Property taxes - Base levy 3,328,796 3,363,602 3,651,411 3,706,549 1,620,000 3,706,549 - 0.00% Special tax levies, Bonds 144,627 156,348 154,119 154,119 - 154,119 - 0.00% Special tax levies, Operations 220,145 217,145 226,145 233,145 - 233,145 - 0.00% Franchise tax 259,070 336,711 309,039 265,000 109,431 275,000 10,000 3.77% Other taxes 190,180 109,002 47,877 29,000 - 29,000 - 0.00% Hotel/motel tax 60,364 66,367 69,109 64,000 24,012 65,000 1,000 1.56% Licenses and permits 210,773 246,969 204,845 177,422 87,833 180,722 3,300 1.86% Intergovernmental 642,900 941,697 1,038,060 958,483 113,718 976,636 18,153 1.89% Charges for services 24,141 14,933 18,942 16,815 32,267 16,815 - 0.00% Fines & forfeitures 40,754 40,239 36,338 40,000 14,569 39,000 (1,000) -2.50% Interest (315,747) 521,224 112,669 125,000 5,566 115,000 (10,000) -8.00% Miscellaneous 385,794 355,678 321,188 268,844 233,969 287,808 18,964 7.05% Transfers: DARE Fund - - 4,643 - - - - 0.00% Water Fund 67,372 69,393 - 73,619 - 75,828 2,209 3.00% Sewer Fund 53,361 54,962 56,611 58,309 - 60,058 1,749 3.00% Storm Water Fund 6,959 7,168 7,383 7,604 - 7,832 228 3.00% Street Light Fund 2,390 2,462 2,536 2,612 - 2,690 78 2.99% Vehicle & Equipment Fund 23,736 38,316 21,000 22,000 - 21,600 (400) -1.82% Bond sales - - 246,729 - - - - 0.00% Total revenues 5,345,615 6,542,216 6,528,644 6,202,521 2,241,365 6,246,802 44,281 0.71% Expenditures: Legislative Services: City Council 42,644 46,030 47,115 51,565 27,505 51,554 (11) -0.02% Advisory Commissions 8,117 14,315 8,720 15,100 1,053 15,500 400 2.65% Subtotal 50,761 60,345 55,835 66,665 28,558 67,054 389 0.58% Administrative Services: City Administrator 233,463 231,848 271,314 281,882 130,199 294,264 12,382 4.39% Elections 19,955 20,053 22,222 61,700 33,454 35,000 (26,700) -43.27% Finance 215,857 232,173 246,268 257,362 126,764 263,457 6,095 2.37% Central Services 200,970 207,551 216,482 242,986 105,492 242,080 (906) -0.37% Subtotal 670,245 691,625 756,286 843,930 395,909 834,801 (9,129) -1.08% Community Development 323,696 341,593 353,381 382,720 165,697 400,816 18,096 4.73% Police 2,493,219 2,481,263 2,710,053 2,752,111 1,308,129 2,766,922 14,811 0.54% Fire 441,466 511,231 567,934 594,522 450,205 583,513 (11,009) -1.85% Public Works Administration 129,700 141,537 113,779 138,341 62,830 143,944 5,603 4.05% Parks, Recreation & Forestry: Recreation 101,502 99,589 112,429 114,413 52,038 115,487 1,074 0.94% Parks 313,627 313,684 333,043 344,600 148,542 359,424 14,824 4.30% Forestry 3,744 17,379 34,478 67,889 6,187 47,486 (20,403) -30.05% Subtotal 418,873 430,652 479,950 526,902 206,767 522,397 (4,505) -0.85% Fleet Services: Building & Grounds Mtnce 137,025 126,707 391,909 129,044 55,580 132,657 3,613 2.80% Vehicle & Equipment Mtnce 89,806 116,011 84,331 114,805 48,391 108,167 (6,638) -5.78% Subtotal 226,831 242,718 476,240 243,849 103,971 240,824 (3,025) -1.24% Streets: Pavement Management 188,102 205,624 203,268 228,346 88,033 235,303 6,957 3.05% Snow & Ice Control 142,794 196,155 134,936 140,079 67,541 147,564 7,485 5.34% Sign Maintenance 38,861 37,342 40,315 66,957 16,360 63,877 (3,080) -4.60% Subtotal 369,757 439,121 378,519 435,382 171,934 446,744 11,362 2.61% Other Convention & Visitor's Bureau 57,346 63,049 65,654 60,800 17,974 61,750 950 1.56% Social Service Coordination 19,548 19,763 20,178 20,783 20,259 21,406 623 3.00% Miscellaneous/contingency 4,877 4,926 4,975 6,500 2,845 6,500 - 0.00% Transfers to other funds 235,000 1,090,000 496,000 445,000 - 475,000 30,000 6.74% Debt service - - 20,268 24,323 12,248 24,496 173 0.71% Subtotal 316,771 1,177,738 607,075 557,406 53,326 589,152 31,746 5.70% Total expenditures 5,441,319 6,517,823 6,499,052 6,541,828 2,947,326 6,596,167 54,339 0.83% Net change in fund balance (95,704) 24,393 29,592 (339,307) (705,961) (349,365) (10,058) Beginning Fund Balance 9,656,133 9,560,429 9,584,822 9,614,414 9,614,414 9,275,107 Ending Fund Balance 9,560,429 9,584,822 9,614,414 9,275,107 8,908,453 8,925,742 (10,058) 1 City of Mounds View GENERAL FUND 2017 Budget Summary Community Park Public 2017 2016 Percent Legislative Admin Finance Central Development Police Fire & Rec Works Misc.Total Total Variance Change Current Personnel services 33,254$ 284,089$ 242,828$ -$ 371,830$ 2,354,723$ -$ 222,866$ 517,324$ 6,500$ 4,033,414$ 3,941,346$ 92,068$ 2.34% Materials & supplies 2,900 1,310 725 36,765 3,215 82,463 - 55,578 138,245 - 321,201 344,449 (23,248) -6.75% Contractual services 30,900 43,865 19,904 205,315 25,771 329,736 405,095 237,953 175,943 83,156 1,557,638 1,543,871 13,767 0.89% Contingency - - - - - - - - - - - - - 0.00% Current total 67,054 329,264 263,457 242,080 400,816 2,766,922 405,095 516,397 831,512 89,656 5,912,253 5,829,666 82,587 1.42% Other Principal - - - - - - 74,056 - - 18,331 92,387 148,286 (55,899) -37.70% Interest - - - - - - 12,453 - - 6,165 18,618 22,817 (4,199) -18.40% Capital outlays - - - - - - 91,909 6,000 - - 97,909 96,059 1,850 1.93% Transfers to other funds - - - - - - - - - 475,000 475,000 445,000 30,000 6.74% Other total - - - - - - 178,418 6,000 - 499,496 683,914 712,162 (28,248) -3.97% Department Total 67,054$ 329,264$ 263,457$ 242,080$ 400,816$ 2,766,922$ 583,513$ 522,397$ 831,512$ 589,152$ 6,596,167$ 6,541,828$ 54,339$ 0.83% 2016 Budget 66,665 343,582 257,362 242,986 382,720 2,752,111 594,522 526,902 817,572 557,406 6,541,828 Increase (Decrease)389 (14,318)6,095 (906)18,096 14,811 (11,009)(4,505)13,940 31,746 54,339 Percent change 0.58%-4.17%2.37%-0.37%4.73%0.54%-1.85%-0.85%1.71%5.70%0.83% 2 City of Mounds View 2017 Budget Summary Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 General Fund:Actual Actual Actual Budget Actual Request Dollar Percent Capital Outlays Legislative Services: City Council - - - - - - - 0.00% Advisory Commissions - - - - - - - 0.00% Subtotal - - - - - - - 0.00% Administrative Services: City Administrator - - - - - - - 0.00% Elections - - - 36,000 28,112 - (36,000) -100.00% Central Services - - - - - - - 0.00% Finance - - - - - - - 0.00% Subtotal - - - 36,000 28,112 - (36,000) -100.00% Community Development - - - - - - - 0.00% Police 59,860 - - 5,000 707 - (5,000) -100.00% Fire 5,736 22,900 38,925 55,059 - 91,909 36,850 66.93% Public Works Administration - - - - - - - 0.00% Parks, Recreation & Forestry: Recreation - - - - - - - 0.00% Parks 8,016 6,145 14,124 - - 6,000 6,000 0.00% Forestry - - - - - - - 0.00% Subtotal 8,016 6,145 14,124 - - 6,000 6,000 0.00% Fleet Services: Building & Grounds Mtnce - - 246,729 - - - - 0.00% Vehicle & Equipment Mtnce - 6,050 - - - - - 0.00% Subtotal - 6,050 246,729 - - - - 0.00% Streets: Pavement Management - - - - - - - 0.00% Snow & Ice Control - 2,618 - - - - - 0.00% Sign Maintenance - - - - - - - 0.00% Subtotal - 2,618 - - - - - 0.00% Other Convention & Visitor's Bureau - - - - - - - 0.00% Social Service Coordination - - - - - - - 0.00% Miscellaneous/contingency - - - - - - - 0.00% Transfers to other funds - - - - - - - 0.00% Debt service - Fire Bonds - - - - - - - 0.00% Subtotal - - - - - - - 0.00% Total expenditures 73,612 37,713 299,778 96,059 28,819 97,909 1,850 1.93% 3 City of Mounds View 2017 Budget Summary Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 General Fund:Actual Actual Actual Budget Actual Request Dollar Percent Operating Expenditures: Legislative Services: City Council 42,644 46,030 47,115 51,565 27,505 51,554 (11) -0.02% Advisory Commissions 8,117 14,315 8,720 15,100 1,053 15,500 400 2.65% Subtotal 50,761 60,345 55,835 66,665 28,558 67,054 389 0.58% Administrative Services: City Administrator 233,463 231,848 271,314 281,882 130,199 294,264 12,382 4.39% Elections 19,955 20,053 22,222 25,700 5,342 35,000 9,300 36.19% Central Services 200,970 207,551 216,482 242,986 105,492 242,080 (906) -0.37% Finance 215,857 232,173 246,268 257,362 126,764 263,457 6,095 2.37% Subtotal 670,245 691,625 756,286 807,930 367,797 834,801 26,871 3.33% Community Development 323,696 341,593 353,381 382,720 165,697 400,816 18,096 4.73% Police 2,433,359 2,481,263 2,710,053 2,747,111 1,307,422 2,766,922 19,811 0.72% Fire 435,730 488,331 529,009 539,463 450,205 491,604 (47,859) -8.87% Public Works Administration 129,700 141,537 113,779 138,341 62,830 143,944 5,603 4.05% Parks, Recreation & Forestry: Recreation 101,502 99,589 112,429 114,413 52,038 115,487 1,074 0.94% Parks 305,611 307,539 318,919 344,600 148,542 353,424 8,824 2.56% Forestry 3,744 17,379 34,478 67,889 6,187 47,486 (20,403) -30.05% Subtotal 410,857 424,507 465,826 526,902 206,767 516,397 (10,505) -1.99% Fleet Services: Building & Grounds Mtnce 137,025 126,707 145,180 129,044 55,580 132,657 3,613 2.80% Vehicle & Equipment Mtnce 89,806 109,961 84,331 114,805 48,391 108,167 (6,638) -5.78% Subtotal 226,831 236,668 229,511 243,849 103,971 240,824 (3,025) -1.24% Streets: Pavement Management 188,102 205,624 203,268 228,346 88,033 235,303 6,957 3.05% Snow & Ice Control 142,794 193,537 134,936 140,079 67,541 147,564 7,485 5.34% Sign Maintenance 38,861 37,342 40,315 66,957 16,360 63,877 (3,080) -4.60% Subtotal 369,757 436,503 378,519 435,382 171,934 446,744 11,362 2.61% Other Convention & Visitor's Bureau 57,346 63,049 65,654 60,800 17,974 61,750 950 1.56% Social Service Coordination 19,548 19,763 20,178 20,783 20,259 21,406 623 3.00% Miscellaneous/contingency 4,877 4,926 4,975 6,500 2,845 6,500 - 0.00% Transfers to other funds 235,000 1,090,000 496,000 445,000 - 475,000 30,000 6.74% Debt service - Lease payable - - 20,268 24,323 12,248 24,496 173 0.71% Subtotal 316,771 1,177,738 607,075 557,406 53,326 589,152 31,746 5.70% Total expenditures 5,367,707 6,480,110 6,199,274 6,445,769 2,918,507 6,498,258 52,489 0.81% 4 General Fund Revenue Detail - 2017 Budget Y-T-D Acct 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 #Description Actual Actual Actual Budget Actual Request Dollar Percent Taxes 3101 Current ad valorem property tax 3,328,796 3,363,602 3,651,411 3,706,549 1,620,000 3,706,549 - 0.00% 3101 Fire bonds 05 & notes 11 144,627 156,348 154,119 154,119 - 154,119 - 0.00% 3101 PERA rate increase property tax 39,145 39,145 39,145 39,145 - 39,145 - 0.00% 3101 Police Officer property tax 181,000 178,000 187,000 194,000 - 194,000 - 0.00% 3102 Delinquent ad valorem prop tax - 12,324 17,266 - - - - 0.00% 3111 Manufact home tax - current 19,949 19,935 21,331 20,000 - 20,000 - 0.00% 3112 Manufact home tax - delinquent 9,209 8,500 9,280 9,000 - 9,000 - 0.00% 3125 Excess TIF 155,766 62,069 - - - - - 0.00% 3180 Franchise tax on utilities 259,070 336,711 309,039 265,000 109,431 275,000 10,000 3.24% 3190 Penalties & interest 5,256 5,817 - - - - - 0.00% 3192 Forfeited tax sales - 357 - - - - - 0.00% 3195 Hotel/Motel tax 60,364 66,367 69,109 64,000 24,012 65,000 1,000 1.45% Total taxes 4,203,182 4,249,175 4,457,700 4,451,813 1,753,443 4,462,813 11,000 0.25% Licenses and Permits 3211 Liquor on-sale 16,770 16,775 16,800 16,800 17,290 16,800 - 0.00% 3212 Liquor off-sale 630 600 1,477 600 1,510 600 - 0.00% 3215 Malt on-sale license - 135 - - - - - 0.00% 3216 Malt off-sale 100 (15) - 100 135 100 - 0.00% 3221 Tobacco license 2,990 3,220 3,300 2,900 2,640 3,000 100 3.03% 3223 Amusement devices 1,168 1,072 720 1,100 32 1,100 - 0.00% 3231 Bowling alley 672 672 672 672 672 672 - 0.00% 3232 Garbage hauling 2,906 3,150 2,558 2,800 2,939 2,800 - 0.00% 3233 Gasoline station 908 850 850 900 850 850 (50) -5.88% 3234 Used car sales 204 204 204 150 - 200 50 24.51% 3235 Kennel 185 285 426 150 395 150 - 0.00% 3236 Restraurant licenses 3,172 3,025 3,806 3,100 2,577 3,100 - 0.00% 3237 Cabaret & Dance 60 - - - - - - 0.00% 3238 Transient & solicitor 4,559 2,235 2,666 2,200 2,130 2,200 - 0.00% 3239 Apartment 24,981 26,331 28,967 26,000 1,256 26,000 - 0.00% 3240 Rental conversion 3,835 3,295 1,335 1,000 1,750 1,000 - 0.00% 3241 Dog license 1,197 3,454 1,428 1,200 314 1,200 - 0.00% 3242 Massage therapy - - 899 - - - - 0.00% 3243 Chickens and bees - - 440 200 200 200 - 0.00% 3250 General contractor 720 1,340 760 1,100 900 1,100 - 0.00% 3251 HVAC contractor 3,795 6,390 5,050 3,800 2,340 4,000 200 3.96% 3252 Cement contractor 40 160 - 100 - 100 - 0.00% 3253 Asphalt contractor 160 40 180 100 120 100 - 0.00% 3254 Excavating contractor 180 60 - 50 - 50 - 0.00% 3255 Sign & billboard contractor 560 680 60 300 60 300 - 0.00% 3256 Sewer & water contractor - - 100 - - - - 0.00% 3257 Other contractor 1,320 2,230 3,430 1,300 1,620 1,500 200 5.83% 3258 License check 1,844 2,012 2,058 1,400 869 1,600 200 9.72% 3260 Fire permits 924 1,320 950 800 1,180 900 100 10.53% Subtotal licenses 73,880 79,520 79,136 68,822 41,779 69,622 800 1.01% 5 General Fund Revenue Detail - 2017 Budget Y-T-D Acct 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 #Description Actual Actual Actual Budget Actual Request Dollar Percent 3262 Grading permit 225 - - - - - 0.00% 3268 Plan check fee 35,505 37,926 23,141 18,000 5,453 18,000 - 0.00% 3270 Building permits 54,272 79,071 53,481 50,000 16,161 50,000 - 0.00% 3271 Fixed fee - building permits 16,009 18,592 18,421 18,000 9,211 18,000 - 0.00% 3272 Wetland buffer permit - (7) - - - - - 0.00% 3273 HVAC permits 16,145 15,070 15,341 11,000 7,694 13,000 2,000 13.04% 3274 Plumbing permits 8,495 9,985 6,904 6,000 2,965 6,500 500 7.24% 3275 Non-building permits 4,839 5,921 7,679 5,000 2,864 5,000 - 0.00% 3278 Interim use permits - - - - 400 - - 0.00% 3279 Conditional use permits 1,400 600 400 600 600 600 - 0.00% 3280 Building surcharge 106 144 1,052 - 429 - - 0.00% 3281 Fixed fee building surcharge 33 75 (921) - 98 - - 0.00% 3282 Mechanical/commercial surcharg (136) 28 (38) - 74 - - 0.00% 3283 HVAC surcharge 15 21 60 - 59 - - 0.00% 3284 Plumbing surcharge (16) 13 27 - 28 - - 0.00% 3286 Water & sewer surcharge - - 158 8 - 0.00% 3287 Commercial plmb surcharge 1 10 4 - 10 - - 0.00% Subtotal permits 136,893 167,449 125,709 108,600 46,054 111,100 2,500 1.99% Total licenses & permits 210,773 246,969 204,845 177,422 87,833 180,722 3,300 1.61% Intergovernmental: 3318 Federal grant 2,761 1,088 350 - - - - 0.00% 3341 Local Government Aid 232,078 597,024 655,531 600,112 - 604,365 4,253 0.65% 3345 Performance Aid 1,742 - - 0.00% 3346 PERA Aid 8,671 8,671 8,671 8,671 - 8,671 - 0.00% 3351 Street Aid - MSA maintenance 104,397 109,063 122,280 106,000 60,821 120,000 14,000 11.45% 3355 Police Aid 136,324 126,933 141,567 135,000 - 135,000 - 0.00% 3356 Police training 5,810 5,471 5,664 5,700 - 5,600 (100) -1.77% 3357 State police grant 1,862 1,088 389 - - - - 0.00% 3359 Other state grants 81,764 27,409 36,522 37,000 10,764 37,000 - 0.00% 3370 Other local government revenue 586 2,000 1,230 - - - - 0.00% 3371 IDS # 621 - SRO 68,647 62,950 64,114 66,000 42,133 66,000 - 0.00% Total intergovernmental 642,900 941,697 1,038,060 958,483 113,718 976,636 18,153 1.75% Charges for services 3410 Advertising revenue 1,060 1,620 205 700 325 700 - 0.00% 3415 Housing inspections - - 190 50 1,455 50 - 0.00% 3418 HRA inspections 1,118 190 - 1,000 - 1,000 - 0.00% 3419 Investigations 30 228 2,806 - 200 - - 0.00% 3421 Police reports 1,666 1,723 1,165 1,200 771 1,200 - 0.00% 3422 Documents / copies 68 26 351 90 170 90 - 0.00% 3423 Customer service 147 281 595 300 213 300 - 0.00% 3425 Book sales - various 19 10 - - - - - 0.00% 3426 Reimbursed staff time 375 15 - 500 - 500 - 0.00% 3430 Right-of-way 15,778 5,615 8,310 9,000 19,985 9,000 - 0.00% 3431 Street opening fee - - 200 - - - 0.00% 3432 Tree removal charges (2,320) - 2,670 1,000 7,748 1,000 - 0.00% 3433 Overload permits 3,450 75 - - 200 - - 0.00% 3458 Zoning letter 250 300 150 75 250 75 - 0.00% 3461 Subdivision 700 2,100 - 1,000 350 1,000 - 0.00% 3462 Variance 1,800 1,800 1,800 1,000 600 1,000 - 0.00% 3463 Rezoning - - 500 200 - 200 - 0.00% 3464 Development - non refund - 450 - 350 - 350 - 0.00% 3465 Code appeal - - - - - - - 0.00% 3466 Comprehensive Plan Amendmen - 500 - - - - - 0.00% 3467 PUD amendment - - - 350 - 350 - 0.00% Total charges for services 24,141 14,933 18,942 16,815 32,267 16,815 - 0.00% 6 THIS PAGE LEFT BLANK INTENTIONALLY 7 General Fund Revenue Detail - 2017 Budget Y-T-D Acct 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 #Description Actual Actual Actual Budget Actual Request Dollar Percent Fines and Forfeitures 3510 Ramsey County municipal court 34,279 35,010 32,019 34,000 12,298 34,000 - 0.00% 3515 Mn Highway Patrol 920 233 50 500 - 200 (300) -600.00% 3520 Administrative offenses 2,780 2,621 2,144 3,000 446 2,500 (500) -23.32% 3525 False alarm charges 2,775 2,375 2,125 2,500 1,825 2,300 (200) -9.41% Total fines & forfeitures 40,754 40,239 36,338 40,000 14,569 39,000 (1,000) -2.75% Other Revenue 3550 Special assessments 2,873 11,601 4,195 3,000 - 3,000 - 0.00% 3610 Investment income (charge)(315,747) 521,224 112,669 125,000 5,566 115,000 (10,000) -8.88% 3630 Billboard Lease 100,980 103,110 105,303 112,562 78,797 113,876 1,314 1.25% 3631 Water tower rental 95,063 98,855 101,639 106,932 116,156 106,932 - 0.00% 3634 Equipment and space rental 4,631 5,268 5,454 4,500 864 1,150 (3,350) -61.42% 3639 Security 280 - 3,782 - 224 - - 0.00% 3650 Donations 1,387 11,485 5,100 - 10,740 - - 0.00% 3651 Donations - K9 2,612 1,618 1,247 750 630 750 - 0.00% 3655 City fines - - - - - - - 0.00% 3665 Park site permit 15,864 12,497 14,940 13,000 7,019 14,000 1,000 6.69% 3679 Vending machine commissions - 466 - 100 - 100 - 0.00% 3680 Other revenue 84,695 46,993 10,584 11,000 14,122 11,000 - 0.00% 3685 Insurance reimbursements 60,685 59,152 40,145 10,000 4,682 30,000 20,000 49.82% 3690 Cash over / short 9 (22) - - - - - 0.00% 3911 Sale of assets 13,327 550 28,338 5,000 - 5,000 - 0.00% 3912 Resale of materials 3,388 4,105 461 2,000 735 2,000 - 0.00% Total other revenue 70,047 876,902 433,857 393,844 239,535 402,808 8,964 2.07% Transfers & Debt proceeds 3972 Transfers: Vehicle & Equip replacemen 23,736 38,316 21,000 22,000 - 21,600 (400) -1.90% DARE fund - - 4,643 - - - - 0.00% Water 67,372 69,393 - 73,619 - 75,828 2,209 0.00% Sewer 53,361 54,962 56,611 58,309 - 60,058 1,749 3.09% Storm Water 6,959 7,168 7,383 7,604 - 7,832 228 3.09% Street light 2,390 2,462 2,536 2,612 - 2,690 78 3.08% 3993 Debt proceeds - - 246,729 - - - - 0.00% Total Transfers & Debt 153,818 172,301 338,902 164,144 - 168,008 3,864 1.14% Total 5,345,615 6,542,216 6,528,644 6,202,521 2,241,365 6,246,802 44,281 0.68% 8 Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent City Council (100 - 4100): Personnel services 0100 Salaries, regular 29,292 29,292 29,292 29,388 14,646 29,388 - 0.00% 0300 Social Security 1,129 1,129 1,129 2,248 564 2,248 - 0.00% 0321 PERA 885 885 885 1,470 443 1,470 - 0.00% 0500 Workers compensation 63 111 148 159 99 148 (11) -6.92% Total personnel services 31,369 31,417 31,454 33,265 15,752 33,254 (11) -0.03% Materials & supplies 1600 Supplies, operating 940 1,690 1,635 2,600 1,369 2,600 - 0.00% Total materials & supplies 940 1,690 1,635 2,600 1,369 2,600 - 0.00% Contractual services 3030 Other professional services 5,115 6,895 6,154 6,200 3,241 6,200 - 0.00% 3610 Memberships 2,831 2,801 5,161 5,600 5,343 5,600 - 0.00% 3630 Training & conferences 1,703 2,633 2,208 3,200 1,455 3,200 - 0.00% 4800 Bonding & insurance 686 594 503 700 345 700 - 0.00% Total contractual services 10,335 12,923 14,026 15,700 10,384 15,700 - 0.00% 0.00% Total City Council 42,644 46,030 47,115 51,565 27,505 51,554 (11) -0.02% 15,661 18,300 18,300 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 3,250 4,369 2,227 5,000 1,053 4,500 (500) -10.00% 3630 Training & conferences - - - 300 - 200 (100) -33.33% 3900 Festivities Commission 4,867 9,946 6,452 9,500 - 10,500 1,000 10.53% Total contractual services 8,117 14,315 8,679 14,800 1,053 15,200 400 2.70% 0.00% Total Advisory Commissions 8,117 14,315 8,720 15,100 1,053 15,500 400 2.65% 2017 Budget Summary 9 Fund: 100 Department: 4100 City Council Account Description 2014 2015 2016 2017 Description 1600 Supplies, operating 900 900 1,000 1,000 Employee appreciation dinner 500 500 600 600 Strategic planning session supplies 900 900 1,000 1,000 Plaques and gift certificates for employee appreciation 2,300 2,300 2,600 2,600 3030 Other professional services 3,000 3,000 - - Strategic planning session(s) facilitator 7,425 6,075 6,200 6,200 Contractual minutes for Council mtgs ( $225 x 24 reg, + 3 special) 10,425 9,075 6,200 6,200 3610 Memberships 25 30 30 30 Mn Mayor's Association 2,801 5,770 5,570 5,570 North Metro Mayors 2,826 5,800 5,600 5,600 3630 Conferences 2,000 2,000 3,200 3,200 Council training, LMC conference, RCCLG dinners & NLC conference 2,000 2,000 3,200 3,200 4800 Bonds & insurance 900 750 700 700 General property & liability 900 750 700 700 18,451 19,925 18,300 18,300 21.78%7.99%-8.16%0.00% Fund: 100 Department: 4110 Advisory Commissions Account Description 2014 2015 2016 2017 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 2,000 1,750 Charter commission legal fees 2,500 2,500 2,500 2,250 Planning Commission meeting minutes 5,000 5,000 5,000 4,500 3630 Training 175 150 150 75 Misc training & conferences. 175 150 150 125 Planning Commissioner training & conferences 350 300 300 200 3900 Festival in the Park 4,500 9,500 4,500 5,500 City Festival in the Park (personnel, supplies) - - 5,000 5,000 Fireworks 4,500 9,500 9,500 10,500 10,150 15,100 15,100 15,500 0.00%48.77%48.77%2.65% 10 Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Office of the City Administrator (100 - 4130): Personnel services 0100 Salaries, regular 179,161 177,671 212,471 214,356 101,349 220,847 6,491 3.03% 0110 Salaries, over-time - - - 874 - 896 22 2.52% 0150 Salaries, part-time - - - 1,872 - 988 (884) -47.22% 0300 Social Security 13,216 12,871 15,417 16,608 7,582 17,039 431 2.60% 0321 PERA 12,817 12,692 15,622 16,143 7,440 16,631 488 3.02% 0400 Group insurance 24,255 24,479 20,649 24,808 10,629 26,007 1,199 4.83% 0500 Workers compensation 962 1,465 2,325 1,771 1,104 1,681 (90) -5.08% Total personnel services 230,411 229,178 266,484 276,432 128,104 284,089 7,657 2.77% Materials & supplies 1230 Supplies, equipment 454 340 179 825 - 1,200 375 45.45% 1600 Supplies, operating - - 13 75 - 75 - 0.00% 2100 Books & periodicals - - - 35 35 - 0.00% Total materials & supplies 454 340 192 935 - 1,310 375 40.11% Contractual services 3100 Communications 649 631 741 1,300 519 1,300 - 0.00% 3610 Memberships 165 142 188 190 201 1,340 1,150 605.26% 3630 Training & conferences 1,574 1,335 3,709 2,650 1,375 5,850 3,200 120.75% 3800 Mileage 210 222 - 375 375 - 0.00% Total contractual services 2,598 2,330 4,638 4,515 2,095 8,865 4,350 96.35% Total City Administrator 233,463 231,848 271,314 281,882 130,199 294,264 12,382 4.39% 4,830 5,450 10,175 Elections (100 - 4140): Contractual services 3030 Other professional services 19,955 20,053 22,222 25,700 5,342 35,000 9,300 36.19% Total contractual services 19,955 20,053 22,222 25,700 5,342 35,000 9,300 36.19% 7030 Capital outlays - - - 36,000 28,112 - (36,000) -100.00% Total Elections 19,955 20,053 22,222 61,700 33,454 35,000 (26,700) -43.27% 2017 Budget Summary 11 Fund: 100 Department: 4130 Office of the City Administrator Account Description 2014 2015 2016 2017 Description 1230 Supplies, equipment < $5000 725 725 825 1,200 Equipment and phones under the $5,000 capitalization threshold 725 725 825 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 760 1,300 1,300 Cell phone service (2) employees 760 760 1,300 1,300 3610 Memberships 50 - - 50 MAMA - (Administrator) Metro Area Manager's Association - - - 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 240 190 190 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 850 1,000 1,000 LMC annual conference (2 attendees)(Asst. Adm. every other year) 850 850 850 850 Mn City County Managers Assoc seminar 100 100 100 100 Mn Clerks and Finance Officers Association (MCFOA) institute training 3,000 3,000 - 3,200 National ICMA or NLC conference (City Administrator)(every other year) 5,500 5,500 2,650 5,850 3800 Mileage 375 375 375 375 Miscellaneous mileage @ IRS rate. 375 375 375 375 7,710 7,660 5,450 10,175 72.87%-0.65%-29.31%86.70% Fund: 100 Department: 4140 Elections Account Description 2014 2015 2016 2017 Description 3030 Other professional services 20,000 23,200 23,200 22,000 Ramsey County elections contract - - - 10,500 Special election - - 2,500 2,500 Equip. maint. service costs (voting equip.) 20,000 23,200 25,700 35,000 7030 Equipment 36,000 36,000 29,000 - Voting equipment 36,000 36,000 29,000 - 56,000 59,200 54,700 35,000 180.00%5.71%-7.60%-36.01% 12 2017 Budget Summary Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Finance (100 - 4150): Personnel services 0100 Salaries, regular 154,279 166,330 177,754 182,752 85,469 187,327 4,575 2.50% 0300 Social Security 11,004 11,908 12,751 13,980 6,046 14,330 350 2.50% 0321 PERA 10,960 11,808 13,050 13,707 6,320 14,050 343 2.50% 0400 Group insurance 20,866 21,414 21,860 24,335 11,154 25,506 1,171 4.81% 0500 Workers compensation 1,042 1,273 1,850 1,702 1,061 1,615 (87) -5.11% 0990 Severence - - - - - - - 0.00% Subtotal 198,151 212,733 227,265 236,476 110,050 242,828 6,352 2.69% Materials & supplies 1230 Supplies, equipment 48 17 - 200 - 200 - 0.00% 1600 Supplies, operating - 35 - 75 - 75 - 0.00% 2100 Books & periodicals 182 181 185 450 30 450 - 0.00% Subtotal 230 233 185 725 30 725 - 0.00% Contractual services 3030 Other professional 9,731 9,811 9,738 10,255 9,519 9,615 (640) -6.24% 3100 Communications - 480 480 480 160 480 - 0.00% 3430 Printing 202 1,179 551 700 - 700 - 0.00% 3610 Memberships 790 804 970 995 995 995 - 0.00% 3630 Training 2,304 2,635 2,477 2,575 1,178 2,700 125 4.85% 5130 Repairs & maint., equipment 4,449 4,298 4,602 5,156 4,832 5,414 258 5.00% Subtotal 17,476 19,207 18,818 20,161 16,684 19,904 (257) -1.27% Total Financial Services 215,857 232,173 246,268 257,362 126,764 263,457 6,095 2.37% 13 Fund: 100 Department: 4150 Finance Account Description 2014 2015 2016 2017 Description 1230 Supplies, equitpment < $5000 200 200 200 200 Furniture or equipment under the $5,000 capitalization threshold 200 200 200 200 1600 Supplies, operating 75 75 75 75 Misc supplies - planners, plaques, folders, files, etc. 75 75 75 75 2100 Books & periodicals 550 550 450 450 Misc computer & finance books & periodicals 550 550 450 450 3030 Other professional services 9,300 9,480 9,660 9,020 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 9,895 10,075 10,255 9,615 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 200 350 350 350 Government Finance Officer's Association (GFOA) 120 120 120 120 Mn GFOA (2) 230 240 250 250 AICPA Am. Institute of Certified Public Accts 265 275 275 275 MNCPA Mn Society of Certified Public Accountants 815 985 995 995 3630 Training & conferences 75 75 75 50 Mn GFOA monthly meetings 1,250 1,450 1,600 1,700 Seminars & training 1,200 - - - (2) GFOA National conference (In Minneapolis no travel expenses) 500 600 650 650 Accounting and software training 250 250 250 300 Mileage 3,275 2,375 2,575 2,700 5130 Equipment repairs 4,675 4,910 5,156 5,414 40% acct. software support charges (30% each in Water, Sanitary Sewer) 4,675 4,910 5,156 5,414 20,665 20,350 20,886 20,629 12.02%-1.52%1.07%-1.23% 14 Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Central Services (100 - 4160): Materials & supplies 1110 Stationery 302 1,027 - 1,000 - 1,000 - 0.00% 1120 Copy materials 523 - 830 1,500 995 1,500 - 0.00% 1230 Supplies, equipment 15,068 4,296 21,316 20,000 12,765 18,000 (2,000) -10.00% 1600 Supplies, operating 12,054 14,462 12,662 15,900 5,470 15,900 - 0.00% 2100 Books & periodicals 149 159 169 365 85 365 - 0.00% Total materials & supplies 28,096 19,944 34,977 38,765 19,315 36,765 (2,000) -5.16% Contractual services 3010 General legal 47,253 57,407 45,489 44,000 13,502 44,000 - 0.00% 3030 Other professional services 11,387 5,154 9,643 9,300 13,980 9,300 - 0.00% 3100 Telephone 6,790 7,078 6,160 7,400 1,645 4,000 (3,400) -45.95% 3300 Postage 6,167 8,366 8,273 7,800 2,248 7,800 - 0.00% 3410 Legal notices 2,854 2,395 4,168 3,000 1,023 3,000 - 0.00% 3420 Advertising 1,678 2,534 2,634 2,500 - 2,500 - 0.00% 3430 Printing 5,992 8,330 7,945 7,400 4,343 7,400 - 0.00% 3610 Memberships 10,755 13,424 19,253 19,922 8,224 20,337 415 2.08% 3630 Training & conferences 1,625 172 1,167 2,000 80 2,000 - 0.00% 4010 Rental, equipment 1,772 1,431 1,407 1,750 703 1,750 - 0.00% 4800 Insurance & bonds 17,103 14,614 15,212 22,000 10,840 22,000 - 0.00% 5100 Repairs & maint, computers 59,498 64,347 56,507 76,549 29,589 80,628 4,079 5.33% 5130 Repairs, equipment - 2,355 3,647 600 600 - 0.00% Total contractual services 172,874 187,607 181,505 204,221 86,177 205,315 1,094 0.54% Total central services 200,970 207,551 216,482 242,986 105,492 242,080 (906) -0.37% 2017 Budget Summary 15 Fund: 100 Department: 4160 Central Services Account Description 2014 2015 2016 2017 Description 1110 Stationery 1,300 1,000 1,000 1,000 Envelopes, labels, letterhead, etc. 1,300 1,000 1,000 1,000 1120 Copy materials 2,000 1,500 1,500 1,500 Copy paper 2,000 1,500 1,500 1,500 1230 Supplies, equipment < $5000 20,800 20,000 20,000 18,000 Comp & security equip under $5,000, pc's, software, switches, cameras.... 20,800 20,000 20,000 18,000 Replace pc's @ $800 4 yr replacement cycle 1600 Supplies, operating 15,400 15,400 15,400 15,400 Toner, rug service, paper, pens, staples, desk supplies, etc. 500 500 500 500 Misc operating supplies 15,900 15,900 15,900 15,900 2100 Books & periodicals 125 175 175 175 Employment handbooks/publications 360 190 190 190 Star Tribune - $190 485 365 365 365 3010 General legal 26,400 26,400 24,000 24,000 Retainer for legal services 18,000 18,000 20,000 20,000 Legal fees outside scope of retainer. 44,400 44,400 44,000 44,000 3030 Other professional services 6,000 6,000 5,700 5,700 General labor assistance 1,400 1,400 1,500 1,500 Section 125 (flex spending plan) & COBRA administration 900 900 1,000 1,000 Human resources items 1,000 1,000 1,100 1,100 Web hosting/GovOffice (Avenet) 9,300 9,300 9,300 9,300 3100 Telephone 6,800 6,800 7,400 4,000 Basic telephone plus long distance 6,800 6,800 7,400 4,000 3300 Postage 300 300 300 300 Courier charges (delivery services) 9,200 7,500 7,500 7,500 General postage includes PW mailings for street projects. 9,500 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 3,000 2,500 2,500 Job opening advertisements for vacant positions 3,000 3,000 2,500 2,500 3430 Printing 6,000 6,400 6,800 6,800 4 newsletter-50% cost here, 50% in YMCA. 750 200 200 200 Miscellaneous printing 750 400 400 400 City guides, directories & miscellaneous 7,500 7,000 7,400 7,400 3610 Memberships 605 605 600 600 Ramsey County League of Local Governments (RCLLG) - - 2,850 2,850 I-35W Corridor Coalition 2,381 4,833 4,835 4,901 Metro Cities (1.36% increase for 2017) 10,447 10,813 11,637 11,986 League of Mn Cities (3% increase for 2017) 13,433 16,251 19,922 20,337 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 19,000 19,000 Insurance policy premiums 3,000 3,000 3,000 3,000 Allowance for insurance policy deductibles 22,000 22,000 22,000 22,000 5100 Repairs, computer 58,500 59,000 64,000 68,000 Computer, phone, network & technology assistance - City of Roseville 2,198 2,198 2,609 2,688 Laserfiche annual maintenance and storage 5,750 5,750 5,750 5,750 Computer, printer, and networks repairs. 4,190 4,190 4,190 4,190 Copier maintenance + overages 1,360 2,040 - - Hosted servers (2 servers) add (1) in 2015 (included in technology assist.) 71,998 73,178 76,549 80,628 5130 Repairs, equipment 900 600 600 600 Postage meter, copy machine, fax, misc. 900 600 600 600 236,066 235,844 242,986 242,080 0.96%-0.09%2.93%-0.37% 16 Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Community Development (100 - 4180): Personnel services 0100 Salaries, regular 224,644 245,039 259,655 260,927 116,925 274,307 13,380 5.13% 0110 Overtime, regular - 24 - 666 - 682 16 2.40% 0150 Salaries, part time 6,311 1,380 1,226 2,808 794 1,976 (832) -29.63% 0300 Social Security 14,743 17,745 18,069 20,228 8,600 21,188 960 4.75% 0321 PERA 18,150 17,572 18,504 19,619 8,662 20,624 1,005 5.12% 0400 Group insurance 34,528 35,750 35,975 46,002 17,282 51,120 5,118 11.13% 0500 Workers comp 1,343 2,177 2,859 1,997 1,245 1,933 (64) -3.20% 0600 Unemployment - - - - - - - 0.00% Total personnel services 299,719 319,687 336,288 352,247 153,508 371,830 19,583 5.56% Materials & supplies 1230 Supplies, equipment - 510 - 825 30 500 (325) -39.39% 1600 Supplies, operating 17 - 110 300 48 300 - 0.00% 1700 Motor fuels & lubricants 1,533 2,191 1,745 2,200 335 1,840 (360) -16.36% 2100 Books & periodicals 164 - 498 375 112 375 - 0.00% 2400 Uniforms 79 296 - 200 82 200 - 0.00% Total materials & supplies 1,793 2,997 2,353 3,900 607 3,215 (685) -17.56% Contractual services 3030 Other professional 16,189 12,869 9,431 18,652 10,563 16,355 (2,297) -12.32% 3040 Consultants, development review 1,116 2,085 822 3,000 (701) 3,000 - 0.00% 3100 Telephone 1,333 1,240 1,365 1,781 725 1,961 180 10.11% 3430 Printing 847 762 543 1,000 510 900 (100) -10.00% 3610 Memberships 710 870 1,180 840 120 1,630 790 94.05% 3630 Training and conferences 1,989 1,024 1,393 1,200 357 1,825 625 52.08% 3800 Mileage - 59 6 100 8 100 - 0.00% Total contractual services 22,184 18,909 14,740 26,573 11,582 25,771 (802) -3.02% Total Community Development 323,696 341,593 353,381 382,720 165,697 400,816 18,096 4.73% 2017 Budget Summary 17 Fund: 100 Department: 4180 Community Development Account Description 2014 2015 2016 2017 Description 1230 Supplies, equipment < $5000 475 475 825 500 Miscellaneous equipment & computer peripherals 475 475 825 500 1600 Supplies, operating 175 100 100 100 Presentation supplies 200 200 200 200 Office supplies 375 300 300 300 1700 Motor fuels & lubs 3,200 1,788 2,200 1,840 Unleaded fuel: 800 gallons @ $2.30 (Gas for Comm Devlopment) 3,200 1,788 2,200 1,840 2100 Books & periodicals 100 100 100 100 Reference materials 100 100 100 100 Intl. Code Council Manuals and Code Updates 200 175 175 175 Manuals, pamphlets, etc. 400 375 375 375 2400 Uniforms 175 200 200 200 Clothing for inspections staff 175 200 200 200 3030 Other professional 1,300 1,300 1,300 1,300 Ramsey County JPA (geographic information system) 3,900 4,620 4,620 4,620 Permit Works system annual software support (includes busi. lic. mod) - - 1,595 - Permit works mobile inspector (one-time set-up and training) - - 2,040 2,040 Permit works mobile inspector annual support fee 500 500 500 500 Filing fees (Ramsey County increased fees from $29 to $48) 3,486 1,971 2,110 2,195 Comcate code enforcement license - 1,987 1,987 1,200 Comcate mobile access 500 500 500 500 GIS assistance 4,000 4,000 4,000 4,000 Abatements of nuisance properties 13,686 14,878 18,652 16,355 3040 Consulting - Development 1,000 750 750 750 Environmental reviews Review (reimbursable)1,000 750 750 750 City attorney services 1,000 750 750 750 Development case reviews 1,000 750 750 750 Engineering services 4,000 3,000 3,000 3,000 3100 Telephone 750 1,300 1,300 1,000 Verizon Cell Accounts (2) for inspectors 480 481 481 961 network card for code enforcement (2 cards @ $40.01) 1,230 1,781 1,781 1,961 3430 Printing 1,400 1,300 1,000 900 Forms, flyers, etc. 1,400 1,300 1,000 900 3610 Memberships 300 300 300 245 American Planning Association (APA) - National (1) - - - 50 American Planning Association (APA-MN) - State (1) - - - 750 Sensible Land Use Coalition (membership $250, monthly lunches (10 @ $50) - - - 135 American Institute of Certified Planners (AICP) 120 120 120 - Assoc. of MN Building Officials 60 - - - Fire Marshal's Assoc. of MN 120 120 125 140 International Code Council (ICC) 60 60 95 100 10K Lakes Chapter of ICC 60 60 100 105 MN Assoc. Housing Code Officials (MAHCO) 85 85 100 105 MN Building Permit Technicians Association (MBPTA) 805 745 840 1,630 3630 Training & conferences 600 600 600 800 APA state conference (one attendee) - - - 225 ICC code seminars 300 300 300 300 Other software training 300 300 300 500 Other staff training & seminars 1,200 1,200 1,200 1,825 3800 Mileage 100 100 100 100 Misc. use of personal automobiles 100 100 100 100 27,046 26,142 30,473 28,986 2.17%-3.34%16.57%-4.88% 18 Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Police (100 - 4200): Personnel services: 0100 Salaries, regular 1,495,148 1,542,874 1,570,903 1,620,155 785,502 1,641,324 21,169 1.31% 0110 Overtime 108,555 74,978 80,112 58,473 41,124 60,499 2,026 3.46% 0150 Salaries, part-time 10,556 - - - - - - 0.00% 0300 Social Security 24,410 26,023 27,501 30,752 14,067 32,698 1,946 6.33% 0321 PERA 212,359 226,087 254,166 260,597 120,053 264,443 3,846 1.48% 0400 Group insurance 190,444 205,941 220,722 256,794 115,391 272,160 15,366 5.98% 0500 Workers compensation 44,499 57,033 78,193 88,930 55,442 83,599 (5,331) -5.99% Total personnel services 2,085,971 2,132,936 2,231,597 2,315,701 1,131,579 2,354,723 39,022 1.69% Materials & Supplies 1210 Supplies, buildings & grounds - - - 800 - 500 (300) -37.50% 1230 Supplies, equipment 11,705 19,509 35,038 24,600 9,121 19,100 (5,500) -22.36% 1600 Supplies, operating 6,242 4,543 7,664 7,100 2,499 9,100 2,000 28.17% 1700 Motor, fuels & lubricants 45,043 43,608 39,643 39,807 9,419 33,293 (6,514) -16.36% 2100 Books & periodicals 823 811 1,031 900 702 900 - 0.00% 2400 Uniforms & clothing 21,502 16,974 15,168 19,570 13,541 19,570 - 0.00% Total materials & supplies 85,315 85,445 98,544 92,777 35,282 82,463 (10,314) -11.12% Contractual services 3010 General Legal 154 - - - - - - 0.00% 3020 Legal, prosecuting attorney 53,194 53,181 72,774 76,398 30,890 78,690 2,292 3.00% 3030 Other professional services 27,485 11,556 3,183 3,590 (204) 3,690 100 2.79% 3050 Dispatching 94,450 100,915 108,058 106,426 44,344 107,131 705 0.66% 3055 Information systems fees 2,540 2,540 2,565 2,626 1,035 2,626 - 0.00% 3070 COPS events - 644 802 700 111 1,000 300 42.86% 3080 Veternarian services 3,385 2,951 5,449 5,500 927 1,500 (4,000) -72.73% 3100 Telephone 3,185 2,889 2,879 6,420 2,403 6,420 - 0.00% 3210 Electricity 342 290 280 320 122 320 - 0.00% 3430 Printing 1,420 339 149 500 - 500 - 0.00% 3610 Memberships 1,825 1,925 1,495 1,910 1,615 1,936 26 1.36% 3630 Training 8,098 9,166 11,387 12,830 5,205 12,470 (360) -2.81% 4800 Insurance & bonds 38,361 40,670 42,602 64,100 27,028 54,100 (10,000) -15.60% 5100 Technology maintenance 20,935 29,252 121,538 47,423 25,652 51,513 4,090 8.62% 5130 Maintenance, equipment 6,699 6,564 6,751 9,890 1,433 7,840 (2,050) -20.73% Total contractual services 262,073 262,882 379,912 338,633 140,561 329,736 (8,897) -2.63% Capital outlays 7030 Equipment 59,860 - - 5,000 707 - (5,000) -100.00% Total capital outlays 59,860 - - 5,000 707 - (5,000) -100.00% Total police 2,493,219 2,481,263 2,710,053 2,752,111 1,308,129 2,766,922 14,811 0.54% 2017 Budget Summary 19 Fund: 100 Department: 4200 Police Account Description 2014 2015 2016 2017 Description 1210 Supplies, bldgs & grounds 800 800 800 500 Carpet cleaning & misc maintenance items 800 800 800 500 1230 Supplies, equipment < $5000 4,500 4,500 4,500 3,000 Miscellaneous office equip (6 squad room 2 clerical chairs )(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 4,000 Bicycles and racks for park patrol (3) - 4,000 - 800 (5) Alco-sensor portable breath test (PBT's) ($800 each) 10,300 10,300 10,300 10,300 (2) squad computers $8,000, light bar $2,300 14,800 19,600 24,600 19,100 1600 Supplies, operating 3,750 3,750 3,400 3,000 Photo print supplies, fire extinguishers, gloves, inkjet cartridges, toner, etc. 700 700 700 600 K9 Food - 500 500 500 Portable radio batteries (10) @ $50 2,500 2,500 2,500 5,000 Batteries, breathalyzer parts, DVD's & CD's, disinfectant, simulation ammo ammunition, crime scene tape, emergency blankets, etc. 6,950 7,450 7,100 9,100 1700 Motor, fuels, & lubs -52,000 42,300 38,775 32,430 Unleaded gas 14,100 gallons @ $2.30/gal. 1,500 1,125 1,032 863 K9 take home car gas 375 gallons @ $2.30 53,500 43,425 39,807 33,293 2100 Books & periodicals 900 900 900 900 Traf. law, crim. law, HR, employ. law, school year books, & misc. books 900 900 900 900 2400 Uniforms & clothing 720 710 710 710 Chief 720 710 710 710 Deputy Chief 4,000 4,000 4,000 4,000 Initial officer set-ups replacing up to two retiring officers 12,240 12,070 12,070 12,070 17 officers @ $710 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,760 19,570 19,570 19,570 3020 Legal, prosecuting attorney 56,214 74,214 76,398 78,690 Retainer ($6,239 per month)(misc charges $1,530) 56,214 74,214 76,398 78,690 3030 Other professional services 600 700 700 900 Tobacco compliance project 150 150 150 150 Hazardous material disposal fee 1,500 1,500 1,500 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,490 3,590 3,590 3,690 3050 Dispatching 100,916 109,819 106,426 107,131 Ramsey County dispatching 100,916 109,819 106,426 107,131 3055 Informational systems fees 2,101 2,101 2,101 2,101 State service fee - CJDN ($510 per quarter in 07, 08, 09,10,11) 515 515 525 525 IACP.net ($500 annual in 06, 07, 08, 09,10,11) 2,616 2,616 2,626 2,626 3070 COPS events 500 500 700 1,000 National night out, town hall meeting, child ID, stickers 500 500 700 1,000 3080 Veterinarian services 5,000 4,200 4,500 1,000 Hillcrest Veterinary Hospital 1,000 1,000 1,000 500 K9 vet services 6,000 5,200 5,500 1,500 3100 Telephone 2,600 2,600 6,420 6,420 Verizon cell phones (10 phones)(new 6 smart, 4 basic)($420 accessories) 2,600 2,600 6,420 6,420 3210 Electricity 320 320 320 320 Civil defense siren's electricity 320 320 320 320 20 THIS PAGE LEFT BLANK INTENTIONALLY 21 Fund: 100 Department: 4200 Police Account Description 2014 2015 2016 2017 Description 3430 Printing 800 800 500 500 Dept manual, Emergency management manual, business cards, 800 800 500 500 3610 Memberships 100 100 - - Assoc. Metro Emergency Managers 50 50 50 50 FBI/LEEDA Law Enfor. Execu. Devel. Assoc. 2@ $50 60 75 75 75 Tri-County Investigator Association 45 45 45 45 Mn Crime Prevention Association 35 - - - Mn DARE Officers Association 100 100 130 130 MN Emergency Managers Assoc. 420 420 420 420 Mn Police chiefs 129 129 129 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 140 200 200 200 Notary commission (3 year due in 2012)($120+$20) 630 630 630 630 POST license reimbursement 7 @ $90 30 30 30 35 Prof. Law Enforcement Admin. Assoc. 25 25 35 35 National Association of Town Watch 1,930 1,970 1,910 1,936 3630 Training 900 600 600 710 MN Chief's conference 2@$355 200 200 200 400 BCA/CJDN training (new records tech) 320 320 320 450 Intox certification (6@$75) 1,000 1,000 1,000 1,000 Range Rental 300 - - - Emergency Management Conference (reimbursed by HLS) 400 400 400 400 MN Sex Crimes Investigators Assoc Conference 3,000 3,000 3,000 2,000 Tuition reimbursement 1,200 1,200 1,200 1,400 Supervisor training 2,000 1,500 1,400 1,400 K9 training 600 600 600 600 Emergency Management training 2,000 1,700 1,700 1,700 Employee development courses 1,615 1,615 1,615 1,615 Patrol on-line program 695 695 795 795 Post training for officers at Century College (1 officers) 14,230 12,830 12,830 12,470 4800 Insurance & bonds 25,000 25,000 25,000 25,000 Liability and automotive insurance - 14,100 14,100 14,100 Insurance per MN Statute 299A.465 25,000 25,000 25,000 15,000 Allowance for insurance policy deductibles 50,000 64,100 64,100 54,100 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,800 1,000 Copier maintenance + overages 2,000 2,000 2,000 2,000 Automatic License plate reader maintenance 2,720 - - - E-ticketing annual maintenance fees - 3,840 3,840 3,840 Air cards for squad CAD (8) at $40 per month - - 2,500 3,500 Milestone video maintenance and licenses - - 2,428 2,800 NetMotion 2 factor authentication (state required) - 12,500 12,500 15,000 IT support for squad computers (Roseville) 31,221 129,894 20,355 21,373 Operating costs of police records management system and ticket writer 39,741 152,034 47,423 51,513 5130 Repairs, equipment 3,000 3,000 3,000 3,000 Misc. equipment repair - defibs, cameras, recorders, fax, printers. 450 450 450 400 Fire extinguisher recharging 1,500 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) 4,350 4,350 4,000 2,000 Radio repair (one-time reprogramming fee $50) 1,400 1,440 1,440 1,440 800 MHZ radio licenses fees 38@ 3.12 per month 11,700 11,740 9,890 7,840 7030 Equipment > $5000 - - - - Digital cameras (7) - 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 - 387,767 553,478 436,410 412,199 5.94%42.73%-21.15%-5.55% 22 Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Fire (100 - 4210): Personnel services Total personnel services 5,532 - - - - - - 0.00% Contractual services 3030 Fire inspection services - 5,249 17,412 15,500 6,225 - (15,500) -100.00% 3032 Contractual fire services 288,701 334,179 356,039 372,283 310,236 399,095 26,812 7.20% 3050 Dispatching 3,985 - 4,759 4,900 5,296 6,000 1,100 22.45% Total contractual services 292,686 339,428 378,210 392,683 321,757 405,095 12,412 3.16% Capital outlays: 7040 Vehicles & equipment 5,736 22,900 38,925 55,059 55,059 91,909 36,850 66.93% Total capital outlays 5,736 22,900 38,925 55,059 55,059 91,909 36,850 66.93% Debt Service: 8010 Principal 89,934 40,636 113,336 123,963 61,981 74,056 (49,907) -40.26% 8020 Interest 47,578 108,267 37,463 22,817 11,408 12,453 (10,364) -45.42% Total debt service 137,512 148,903 150,799 146,780 73,389 86,509 (60,271) -41.06% Total Fire 441,466 511,231 567,934 594,522 450,205 583,513 (11,009) -1.85% 2011 Capital Equipment Note was retired in 2016 2013 Fire Improvement Refunding Bonds will be retired in 2025 2017 Capital Outlays includes $20,565 for a capital lease for a ladder truck (7 year term) this could also be financed with another equipment note (no decision has been made on financing) 2017 Budget Summary 23 Fund: 100 Department: 4210 Fire Account Description 2014 2015 2016 2017 Description 3030 Fire inspection services 15,000 15,500 15,500 - Contractual fee for Fire Marshalling services (SBM) 15,000 15,500 15,500 - 3032 Contractual fire services 334,179 356,039 372,283 399,095 Share of joint fire dept. costs (14-16.357%,15-16.424%,16-16.099%,17-15.819%) 334,179 356,039 372,283 399,095 3050 Dispatching 4,355 4,355 4,900 6,000 Anoka County dispatching fee 4,355 4,355 4,900 6,000 7040 Capital, vehicles & equipment 22,900 38,925 55,059 91,909 Share of joint fire department's capital costs 22,900 38,925 55,059 91,909 8010 Principal - Fire bond 60,521 63,232 73,251 74,056 15.819% of interest payment on 2013 refunding Fire bonds Principal - Equip Certs 50,707 52,557 50,712 - 15.819% of interest payment on 2011 Equipment Certificates 8020 Interest - Fire bond 35,792 33,629 22,081 12,453 15.819% of principal payment on 2013 refunding Fire bonds Interest - Equip Certs 1,883 1,381 736 - 15.819% of principal payment on 2011 Equipment Certificates 148,903 150,799 146,780 86,509 525,337 565,618 594,522 583,513 19.60%7.67%5.11%-1.85% 24 Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Recreation (100 - 4350): Contractual services: 3036 Contractual recreation 100,335 98,467 111,289 112,713 51,200 113,787 1,074 0.95% 4800 Bonding & insurance 1,167 1,122 1,140 1,700 838 1,700 - 0.00% Total contractual services 101,502 99,589 112,429 114,413 52,038 115,487 1,074 0.94% Total Recreation 101,502 99,589 112,429 114,413 52,038 115,487 1,074 0.94% 2017 Budget Summary 25 Fund: 100 Department: 4350 Recreation Account Description 2014 2015 2016 2017 Description 3036 Contractual recreation 97,000 102,200 103,713 105,787 YMCA Mgt contract (39.5% of $267,814) 8,500 8,700 9,000 8,000 Ice Skating supervision 105,500 110,900 112,713 113,787 4800 Bonding & insurance 1,700 1,700 1,700 1,700 Insurance & bonding cost. 1,700 1,700 1,700 1,700 107,200 112,600 114,413 115,487 0.00%5.04%1.61%0.94% 26 Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent 2017 Budget Summary Parks (100 - 4360): Personnel services 0100 Salaries, regular 129,794 99,541 116,799 120,346 56,112 123,859 3,513 2.92% 0110 Overtime, regular 7,256 6,498 8,569 4,923 5,602 5,068 145 2.95% 0150 Salaries, part-time 27,376 35,701 29,448 33,180 7,823 33,180 - 0.00% 0300 Social Security 11,334 10,335 11,318 12,122 5,030 12,401 279 2.30% 0321 PERA 8,727 7,697 9,376 9,396 4,593 9,670 274 2.92% 0400 Group insurance 12,769 17,532 20,899 23,455 10,615 24,354 899 3.83% 0500 Workers compensation 5,007 7,274 9,129 10,714 6,679 10,148 (566) -5.28% 0600 Unemployment 1,474 2,701 3,275 - 1,430 - - 0.00% Total personnel services 203,737 187,279 208,813 214,136 97,884 218,680 4,544 2.12% Materials & supplies: 1210 Supplies, bldgs & grnds 8,125 7,777 6,456 10,600 3,262 12,600 2,000 18.87% 1220 Supplies, vehicles & mowers 9,192 8,565 4,321 10,000 - 8,000 (2,000) -20.00% 1230 Supplies, equipment 3,094 9,803 6,693 6,250 6,345 8,500 2,250 36.00% 1600 Supplies, operating 8,229 8,131 14,461 10,000 4,425 10,900 900 9.00% 1700 Motor fuels & lubs 13,007 14,337 11,692 7,650 1,222 7,580 (70) -0.92% 2400 Uniforms & clothing 812 963 1,046 1,370 325 1,370 - 0.00% 2410 Mats & towels 338 479 609 728 329 728 - 0.00% Total materials & supplies 42,797 50,055 45,278 46,598 15,908 49,678 3,080 6.61% Contractual services: 3030 Other professional services 5,681 8,168 9,744 10,300 4,089 10,300 - 0.00% 3100 Telephone 1,492 1,272 1,575 2,056 1,007 2,056 - 0.00% 3200 Water & sewer 5,798 6,401 5,442 7,000 70 6,500 (500) -7.14% 3210 Electricity 9,909 9,689 10,214 7,200 4,063 10,000 2,800 38.89% 3220 Natural gas 6,031 9,121 4,546 4,800 2,179 4,800 - 0.00% 3530 Refuse collection - - - - 87 - 0.00% 3610 Memberships - 65 - 90 40 90 - 0.00% 3630 Training & conferences 334 740 913 1,670 331 1,670 - 0.00% 3900 Grants & subsidies 10,608 10,608 11,500 11,500 11,500 11,500 - 0.00% 4010 Rental, equipment - 1,260 1,096 2,900 704 3,900 1,000 34.48% 4030 Portable restrooms 4,221 5,642 4,884 4,850 2,167 5,000 150 3.09% 4800 Bonding & insurance 10,984 12,010 10,729 16,000 8,031 16,000 - 0.00% 5110 Repairs, bldg & grounds 4,019 5,229 4,185 15,500 482 13,250 (2,250) -14.52% Total contractual services 59,077 70,205 64,828 83,866 34,750 85,066 1,200 1.43% Capital outlays 7030 Equipment 8,016 6,145 14,124 - - 6,000 6,000 0.00% Total capital outlays 8,016 6,145 14,124 - - 6,000 6,000 0.00% Total Parks 313,627 313,684 333,043 344,600 148,542 359,424 14,824 4.30% 110,106 130,464 140,744 27 Fund: 100 Department: 4360 Parks Account Description 2014 2015 2016 2017 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 3,000 2,000 2,000 County 10 trailway landscaping mulch, shrubs, and plants 400 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.) 150 300 300 300 Graffiti remover 500 500 250 250 Goose repellent 2,500 2,500 2,000 2,000 Replace irrigation heads - - - 2,000 City Hall Park sign (estimate) 2,500 2,500 2,000 2,000 Seed, fertilizer 12,600 12,850 10,600 12,600 1220 Supplies, vehicles 7,000 7,000 7,000 6,000 Oil filters, mower blades, tires, vehicle registration fees, 3,500 - - - Lift gate #428 2,500 3,000 3,000 2,000 Miscellaneous repairs 13,000 10,000 10,000 8,000 1230 Supplies, equipment < $5000 250 250 250 250 Drinking fountain parts 250 250 250 250 Field Lights 250 250 250 250 Park signage 500 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 2,500 4,500 Replace park equipment, fixtures and misc parts 3,750 4,250 6,250 8,500 1600 Supplies, operating 2,000 2,000 2,000 2,500 Fiber fill for play lots & courts 200 200 200 200 Tri mix 1,700 1,700 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 400 800 Nets 2,900 2,900 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 9,500 10,000 10,900 1700 Motor fuels & lubes 7,200 4,500 4,500 5,060 2,200 gallons of unleaded gas @ $2.30 4,050 3,150 3,150 2,520 900 gallons of diesel fuel @ $2.80 11,250 7,650 7,650 7,580 2400 Uniforms & clothing 175 350 350 350 Clothing allowance 2.0 FTE 600 820 820 820 Uniforms 18.2% of $4,500 200 200 200 200 Safety glasses, masks, ear protection, etc. 975 1,370 1,370 1,370 2410 Mats & towels 850 910 728 728 Share of floor mats and shop towels 18.2% of $4,000 850 910 728 728 3030 Other professional services 240 240 240 240 Fire extinguisher inspection/maint. (2@ $120) 600 600 600 600 HVAC maintenance 840 840 840 960 Fire sprinkler testing (4@ $210) 120 120 120 120 Backflow prevention testing (2@ $60) 4,500 8,500 8,500 8,380 Broadleaf control 6,300 10,300 10,300 10,300 28 THIS PAGE LEFT BLANK INTENTIONALLY 29 Fund: 100 Department: 4360 Parks (continued) Account Description 2014 2015 2016 2017 Description 3100 Telephone 1,400 985 1,206 1,206 Cellular phones (13.1% of $9,200) - 850 850 850 GPS units for mowers (split with 4472) 1,400 1,835 2,056 2,056 3200 Water & wastewater 7,000 7,000 7,000 6,500 Parkland irrigation & park bathrooms 7,000 7,000 7,000 6,500 3210 Electricity 7,200 7,200 7,200 10,000 Est. 5 park buildings, park sec. lighting, court & field lighting & misc. 7,200 7,200 7,200 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 30 60 - - Pesticide license renewal (every 2 years) 100 - - - Tree inspector license (moved to 4380) 220 150 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) 210 375 375 375 Equipment training (18.2% of $2,050) 200 - 200 200 Pesticide application class (every 2 years) 30 - - - Pesticide license renewal (every 2 years)(in 3610) 150 - - - Tree inspector training (moved to 4380) 1,685 1,470 1,670 1,670 3900 Grants & subsidies 10,608 11,500 11,500 11,500 Lakeside Park share of operating costs 10,608 11,500 11,500 11,500 4010 Rental, equipment 350 500 2,900 3,900 Tools and equipment (sod cutter, chipper, concrete mixer, etc...) 350 500 2,900 3,900 4030 Portable restrooms 4,850 4,850 4,850 5,000 For May thru Oct, plus special events such as tournaments, & extra cleanings and insurance 4,850 4,850 4,850 5,000 4800 Bonding & insurance 12,000 12,000 12,000 12,000 Insurance policy premiums 4,000 4,000 4,000 4,000 Allowance for insurance policy deductibles 16,000 16,000 16,000 16,000 5110 Repairs, bldgs & grounds 750 750 750 750 Windows, doors, & lock repairs - - - 4,000 Sandblast trash cans and paint 3,500 1,000 1,000 1,000 Building exterior repairs 5,000 1,500 7,750 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 Repairs to playground equipment 2,500 2,500 2,500 2,500 Repairs to furnaces, plumbing, phones, electrical, etc 12,750 6,750 15,500 13,250 7030 Capital, equipment > $5000 8,000 - - - Utility cart - - - 6,000 Trencher (irrigation repairs and oak wilt treatments) 6,350 - - - Plow for unit #428 14,350 - - 6,000 139,438 118,885 130,464 140,744 27.87%-14.74%9.74%7.88% 30 Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent 2017 Budget Summary Forestry (100 - 4380): Personnel services 0100 Salaries, regular - - 2,820 2,857 1,388 2,928 71 2.49% 0110 Overtime, regular - - 118 - 122 - - 0.00% 0300 Social Security - - 203 219 103 224 5 2.28% 0321 PERA - - 221 214 113 220 6 2.80% 0400 Group insurance - - 530 606 290 630 24 3.96% 0500 Workers compensation - - 168 193 120 184 (9) -4.66% Total personnel services - - 4,060 4,089 2,136 4,186 97 2.37% 0.00% Materials & supplies 1200 Supplies, landscaping 395 3,018 1,944 8,900 1,923 5,900 (3,000) -33.71% Total materials & supplies 395 3,018 1,944 8,900 1,923 5,900 (3,000) -33.71% Contractual services 3030 Professional services 3,349 2,909 1,577 21,500 - 11,500 (10,000) -46.51% 3520 Tree removal - 11,437 26,727 32,500 1,700 25,000 (7,500) -23.08% 3630 Training & conferences - 15 170 900 428 900 - Total contractual services 3,349 14,361 28,474 54,900 2,128 37,400 (17,500) -31.88% Total Forestry 3,744 17,379 34,478 67,889 6,187 47,486 (20,403) -30.05% 30,418 63,800 43,300 31 Fund: 100 Department: 4380 Forestry Account Description 2014 2015 2016 2017 Description 1200 Supplies, landscaping 400 400 400 400 Landscaping materials 800 1,000 1,000 2,000 Small trees to replace damaged trees 1,800 2,000 2,000 3,000 Large trees - storm damage replacement 7,500 5,000 5,000 - Ash tree replacement trees (MN DNR grant) 2,500 2,500 500 500 EAB treatment supplies 13,000 10,900 8,900 5,900 3030 Professional services 10,000 10,000 5,000 5,000 Tree trimming - 500 500 500 Asset mgt. software 25,000 25,000 15,000 5,000 Forestry consulting 7,500 1,000 1,000 1,000 Tree injections (Ash every 2 years) 42,500 36,500 21,500 11,500 3520 Tree removal 28,000 28,000 25,000 25,000 Remove or treat diseased trees 13,500 7,500 7,500 - Ash tree removal (MN DNR grant) 41,500 35,500 32,500 25,000 3630 Training & memberships - 300 800 800 Tree Inspector training - 100 100 100 Tree Inspector license - 400 900 900 97,000 83,300 63,800 43,300 23.57%-14.12%-23.41%-32.13% 32 Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Public Works Administration (100-4410): Personnel services: 0100 Salaries, regular 98,079 107,821 86,232 100,621 46,365 106,006 5,385 5.35% 0110 Salaries, overtime - 141 - - - - - 0.00% 0300 Social Security 7,037 7,782 5,856 7,697 3,281 8,109 412 5.35% 0321 PERA 7,042 7,753 5,843 7,547 3,448 7,950 403 5.34% 0400 Group insurance 12,155 13,202 11,422 15,716 7,290 16,416 700 4.45% 0500 Workers compensation 1,134 1,839 1,885 1,462 911 1,405 (57) -3.90% Total personnel services 125,447 138,538 111,238 133,043 61,295 139,886 6,843 5.14% Materials & supplies: 1230 Supplies, equipment - 130 - - - - - 0.00% 1600 Operating supplies 104 297 300 300 - 300 - 0.00% 2400 Uniforms & clothing 888 - 56 400 52 400 - 0.00% Total materials and supplies 992 427 356 700 52 700 - 0.00% Contractual services: 3030 Other professional services 842 524 336 900 760 900 - 0.00% 3100 Telephone 895 636 616 773 338 773 - 0.00% 3610 Memberships 433 632 430 730 385 490 (240) -32.88% 3630 Training & conferences 753 490 600 1,895 - 895 (1,000) -52.77% 3800 Mileage reimbursement 338 290 203 300 - 300 - 0.00% Total contractual services 3,261 2,572 2,185 4,598 1,483 3,358 (1,240) -26.97% Total public works administration 129,700 141,537 113,779 138,341 62,830 143,944 5,603 4.05% 2,541 5,298 4,058 2017 Budget Summary 33 Fund: 100 Department: 4410 Public Works Adminstration Account Description 2014 2015 2016 2017 Description 1600 Operating Supplies 200 230 230 230 Office supplies - 70 70 70 National Public Works Week posters 200 300 300 300 2400 Uniforms & clothing 400 400 400 400 33% of Supervisor's uniform cost. 400 400 400 400 3030 Other professional services 100 100 100 100 Physicals & drug testing - new employee - 500 500 500 Asset mgt software 300 300 300 300 Drug & alcohol testing - federal mandate 400 900 900 900 3100 Telephone 680 630 773 773 Cellphone (8.4% of $9,200) 680 630 773 773 3610 Memberships/license fee 180 190 375 400 American Public Works Association memb. (APWA) (1/2 of $800) 60 60 60 60 City Engineer's Association of MN (CEAM) 40 - - - NASASP (National Assoc. of State Agencies for Surplus Property) 30 30 30 30 MN Safety Council 250 - 265 - MN Board of AELSLAGID (PE Renewal even years) 230 250 - - American Society of Civil Engineers 790 530 730 490 3630 Training & conferences 500 500 1,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 895 1,895 895 3800 Mileage reimbursement 400 300 300 300 vehicle mileage reimbursement 400 300 300 300 3,765 3,955 5,298 4,058 5.61%5.05%33.96%-23.41% 34 Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent 2017 Budget Summary Building & Grounds Maintenance (100 - 4460): Personnel services: 0100 Salaries, regular 12,039 12,389 13,885 13,795 6,475 14,141 346 2.51% 0110 Salaries, overtime 312 626 382 1,023 369 1,048 25 2.44% 0300 Social Security 888 946 1,052 1,133 503 1,161 28 2.47% 0321 PERA 886 934 1,053 1,112 507 1,140 28 2.52% 0400 Group insurance 2,864 2,943 2,413 2,815 1,264 2,952 137 4.87% 0500 Workers compensation 400 641 1,153 996 621 945 (51) -5.12% Total personnel services 17,389 18,479 19,938 20,874 9,739 21,387 513 2.46% Materials & supplies: 1210 Supplies, building & grounds 1,988 2,283 3,762 2,000 1,200 2,000 - 0.00% 1220 Supplies, vehicles - - 68 - - - - 0.00% 1230 Supplies, equipment 264 825 209 1,300 - 1,300 - 0.00% 1600 Supplies, operating 3,389 2,534 3,570 4,300 1,315 4,300 - 0.00% 1700 Motor fuels & lubricants 1,543 - - - - - - 0.00% 2400 Uniforms & clothing 113 103 91 117 41 117 - 0.00% 2410 Mats & towels 85 925 750 630 509 630 - 0.00% Total materials & supplies 7,382 6,670 8,450 8,347 3,065 8,347 - 0.00% Contractual services: 3030 Other professional services 27,273 18,737 31,200 31,660 14,828 36,160 4,500 14.21% 3100 Telephone 124 112 97 129 63 129 - 0.00% 3200 Water & sewer 1,000 807 786 1,400 158 1,000 (400) -28.57% 3210 Electricity 29,788 28,341 27,793 14,000 10,402 14,000 - 0.00% 3220 Natural gas 21,912 26,488 17,502 20,000 9,004 19,000 (1,000) -5.00% 3530 Refuse collection 7,912 7,806 7,611 9,334 3,754 9,334 - 0.00% 3610 Memberships - 10 - - - - - 0.00% 3630 Training & conferences 9 19 10 - 19 - - 0.00% 4010 Rental, equipment - - - 200 - 200 - 0.00% 4800 Insurance 4,805 4,621 4,694 7,000 3,449 7,000 - 0.00% 5110 Repairs, bldgs & grounds 14,470 10,208 24,920 11,100 1,099 11,100 - 0.00% 5130 Repairs, equipment 4,961 4,409 2,179 5,000 - 5,000 - 0.00% Total contractual services 112,254 101,558 116,792 99,823 42,776 102,923 3,100 3.11% 125,242 108,170 111,270 Capital outlays 7030 Equipment - - 246,729 - - - - 0.00% Total capital outlays - - 246,729 - - - - 0.00% Total buildings & grounds 137,025 126,707 391,909 129,044 55,580 132,657 3,613 2.80% 35 Fund: 100 Department: 4460 Building & Ground Maintenance Account Description 2014 2015 2016 2017 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,300 Repair parts, filters, hoses, etc., office furniture 1,300 1,300 1,300 1,300 1600 Supplies, operating 500 500 1,500 1,500 Cleaning supplies 300 300 150 150 Lumber & fasteners 550 550 300 300 Repair items & hardware 300 300 100 100 First aid supplies 500 500 200 200 Light bulbs & ballasts 500 500 750 750 Paper supplies 500 500 400 400 Mechanical items, fans, motors, etc 100 100 - - Goose repellent 200 200 - - Weed control - city hall 200 200 200 200 Office supplies 700 700 700 700 Paint & supplies - parking lot & building 4,350 4,350 4,300 4,300 2400 Uniforms & clothing 150 81 81 81 Uniforms (1.8% of $4,500) 45 36 36 36 Clothing & boot allowance (.20 @$175) 195 117 117 117 2410 Mats & towels 210 90 90 90 Share of floor mats and shop towels (1.8% of $5,000) - 540 540 540 Floor mats at CH ($45/month) 210 630 630 630 3030 Other professional services 180 180 180 180 Backflow prevention testing (3@$60) 60 60 60 60 Boiler & pressure vessel registration program 3,250 5,500 5,520 5,520 HVAC maintenance (City Hall & PW facilities) 100 100 100 100 MN DOL operating permit - elevator (previously in acct. 5110) 15,300 18,000 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 200 MDH Monitoring well maint. permit - PW bldg. - - - 4,500 Service contract for generator 600 600 600 600 Fire extingiusher inspection/service (30@$20) 25,190 30,140 31,660 36,160 3100 Telephone 120 120 129 129 Cellphone (1.6% of $7,500)($9,200) 120 120 129 129 3200 Water & Sewer 1,500 1,400 1,400 1,000 Service at City Hall and Public Works buildings 1,500 1,400 1,400 1,000 3210 Electricity 26,000 28,000 14,000 14,000 Electricity at City Hall and Public Works buildings 26,000 28,000 14,000 14,000 3220 Natural gas 19,000 20,000 20,000 19,000 Natural gas at City Hall and Public Works buildings 19,000 20,000 20,000 19,000 3530 Refuse collection 3,161 3,161 1,630 1,030 Hazardous waste disposal, Lamps $100, batteries $30 264 264 264 264 Hazardous waste annual fee (State of MN PCA) 230 230 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,200 7,800 Facility dumpsters, city hall, public works 11,005 11,005 9,334 9,334 4010 Rental, equipment 205 200 200 200 Misc. rentals 205 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 2,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 11,100 5130 Repairs, equipment 5,000 5,000 5,000 5,000 HVAC, plumbing & electrical repairs 5,000 5,000 5,000 5,000 114,175 122,362 108,170 111,270 -0.93%7.17%-11.60%2.87% 36 Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent 2017 Budget Summary Vehicle & Equipment Maintenance (100 - 4465): Personnel services: 0100 Salaries, regular 31,133 33,251 34,939 37,947 10,661 36,826 (1,121) -2.95% 0110 Salaries, overtime 1,038 1,110 - 577 - 556 (21) -3.64% 0300 Social Security 2,330 2,492 2,540 2,946 787 2,860 (86) -2.92% 0321 PERA 2,332 2,490 2,579 2,889 795 2,804 (85) -2.94% 0400 Group insurance 5,289 5,565 4,635 7,087 1,219 7,344 257 3.63% 0500 Workers compensation 976 1,628 2,487 1,983 1,236 1,785 (198) -9.98% Total personnel services 43,098 46,536 47,180 53,429 14,698 52,175 (1,254) -2.35% Materials & supplies: 1220 Supplies, vehicles 14,200 16,616 9,522 19,950 8,553 19,950 - 0.00% 1230 Supplies, equipment 970 4,752 5,027 9,800 526 4,100 (5,700) -58.16% 1600 Supplies, operating 4,791 3,771 6,404 4,200 2,070 4,200 - 0.00% 1700 Motor fuels & lubricants - unleade 2,630 4,051 2,074 3,260 2,494 3,260 - 0.00% 1701 Motor fuels & lubricants - diesel - 7,663 85 - 9,084 - - 0.00% 2400 Uniforms & clothing 729 414 878 354 97 375 21 5.93% 2410 Mats & towels 203 180 185 220 98 220 - 0.00% Total materials & supplies 23,523 37,447 24,175 37,784 22,922 32,105 (5,679) -15.03% Contractual services: 3030 Other professional services 19 18 17 - 25 - 0.00% 3100 Telephone 262 263 228 387 141 387 - 0.00% 3530 Refuse collection - - - 100 - 100 - 0.00% 3610 Memberships 258 606 - 80 - 80 - 0.00% 3630 Training 58 283 54 625 203 920 295 47.20% 4010 Rental, equipment - - - 100 - 100 - 0.00% 5120 Repairs, vehicles 18,414 19,894 6,872 16,800 5,931 16,800 - 0.00% 5130 Repairs, equipment 4,174 4,914 5,805 5,500 4,471 5,500 - 0.00% Total contractual services 23,185 25,978 12,976 23,592 10,771 23,887 295 1.25% Capital outlays 7030 Equipment - 6,050 - - - - - 0.00% Total capital outlays - 6,050 - - - - - 0.00% Total vehicle & equipment maintenance 89,806 116,011 84,331 114,805 48,391 108,167 (6,638) -5.78% 37,151 61,376 55,992 37 Fund: 100 Department: 4465 Vehicle & Equipment Maintenance Account Description 2014 2015 2016 2017 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 8,000 9,000 9,000 9,000 Tires & batteries 18,950 19,950 19,950 19,950 1230 Supplies, equipment < $5000 200 200 200 200 Small equipment tune up items 400 400 400 400 Filters belts & hoses 1,000 1,000 1,000 1,000 Hydraulic system repairs - 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,400 - - - Refridgerant ID machine 1,000 2,000 2,000 - Tires 5,000 9,800 9,800 4,100 1600 Supplies, operating 1,200 1,200 1,200 1,200 Specialty tools & hand tools 350 350 350 350 Welding supplies 100 100 100 100 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 500 Solvents & degreasers 500 500 500 500 Fastners & electrical supplies 4,200 4,200 4,200 4,200 1700 Motor fuels & lubricants 60 60 60 60 Gear lube 200 200 200 200 ATF - 7 cases 375 500 500 500 Aftermarket additives 2,500 2,500 2,500 2,500 Engine oil: 150 gallons (synthetic) 3,135 3,260 3,260 3,260 2400 Uniforms & clothing 360 249 249 270 Uniforms 6% of $4,500) 105 105 105 105 Clothing and boot allowance (.6@$175) 465 354 354 375 2410 Mats & towels 510 275 220 220 Share of floor mats and shop towels (5.5% of $4,000) 510 275 220 220 3100 Communications 280 308 387 387 Cellular telephone (4.1% of $9,200) 280 308 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 320 200 200 495 Misc training ($295 squad training) 175 175 175 175 ASE certification 75 75 190 190 Vehicle inspection recertification (DOT required) 630 510 625 920 4010 Rental, equipment 100 100 100 100 Specialty tool & equipment rental 100 100 100 100 5120 Repairs, vehicles 6,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 2,000 1,960 Tire repairs 700 700 950 950 Ignition scanner software update 1,700 1,700 1,700 1,740 Mitchell On Demand Software 2,000 2,000 2,000 2,000 Transmission repairs 14,550 16,550 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 6,000 - - - Hoist adaptor 6,000 - - - 59,500 60,987 61,376 55,992 17.48%2.50%0.64%-8.77% 38 Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent 2017 Budget Summary Street Pavement Management (100 - 4470): Personnel services: 0100 Salaries, regular 96,757 102,349 114,727 113,381 53,961 117,480 4,099 3.62% 0110 Salaries, overtime 3,494 3,470 3,154 3,296 1,451 3,379 83 2.52% 0150 Salaries, part-time 6,139 5,910 5,452 7,488 1,268 7,488 - 0.00% 0300 Social Security 7,861 8,253 8,938 9,498 4,156 9,817 319 3.36% 0321 PERA 7,147 7,527 8,541 8,751 3,892 9,064 313 3.58% 0400 Group insurance 11,816 11,703 13,953 17,338 7,405 18,972 1,634 9.42% 0500 Workers compensation 4,692 7,123 10,532 10,056 6,269 9,530 (526) -5.23% 0990 Severence pay - - - - - - 0.00% Total personnel services 137,906 146,335 165,297 169,808 78,402 175,730 5,922 3.49% Materials & supplies: 1230 Supplies, equipment 8,648 5,712 469 500 23 2,950 2,450 490.00% 1240 Supplies, streets 11,391 25,299 5,411 22,500 512 10,000 (12,500) -55.56% 1260 Supplies, traffic control 888 429 - 1,000 - 750 (250) -25.00% 1600 Supplies, operating 2,911 2,815 2,250 750 284 1,000 250 33.33% 1700 Motor fuels & lubricants 8,140 9,515 6,391 9,375 1,169 7,650 (1,725) -18.40% 2400 Uniforms & clothing 885 917 820 701 528 701 - 0.00% 2410 Mats & towels 338 351 397 436 210 436 - 0.00% Total materials & supplies 33,201 45,038 15,738 35,262 2,726 23,487 (11,775) -33.39% Contractual services: 3030 Other professional services 8,136 5,279 11,975 8,950 2,159 20,950 12,000 134.08% 3100 Telephone 806 756 641 966 383 966 - 0.00% 3610 Memberships 177 247 190 245 195 255 10 4.08% 3630 Training & conferences 767 583 760 1,115 256 1,115 - 0.00% 4010 Rental, equipment 2,840 1,125 4,500 5,300 850 6,100 800 15.09% 4800 Insurance 4,256 6,261 4,157 6,200 3,055 6,200 - 0.00% 5130 Repairs, equipment 13 - 10 500 7 500 - 0.00% Total contractual supplies 16,995 14,251 22,233 23,276 6,905 36,086 12,810 55.04% Total street pavement management 188,102 205,624 203,268 228,346 88,033 235,303 6,957 3.05% 37,971 58,538 59,573 39 Fund: 100 Department: 4470 Pavement Management Account Description 2014 2015 2016 2017 Description 1230 Supplies, equipment < $5000 500 500 500 500 Safety vests and other safety equipment - - - 1,000 Radio/hearing protection - - - - Traffic counters - - - 500 Push mower - - - 450 Chainsaw - - - 500 Backpack blower 4,000 - - - Rear cameras for plow trucks 4,500 500 500 2,950 1240 Supplies, street repair 20,000 20,000 20,000 7,500 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 22,500 10,000 1260 Supplies, traffic control 400 400 400 250 Traffic cones/baracades 100 600 600 500 portable signs (traffic control) 500 1,000 1,000 750 1600 Supplies, operating 650 650 650 850 Asphalt hand tools, rakes, etc. 1,750 - - - Traffic marking paint (crosswalks)(move to 4475) 100 100 100 150 Batteries, shop supplies, etc. 2,500 750 750 1,000 1700 Motor fuels & lubricants 6,750 5,250 5,250 4,200 Diesel fuel: 1500 gallons @ $2.80. 5,200 4,500 4,125 3,450 Unleaded fuel: 1500 gallons @ $2.30 11,950 9,750 9,375 7,650 2400 Uniforms & clothing 600 491 491 491 Uniforms (10.9% of $4,500) 175 210 210 210 Clothing and boot allowance (1.2@$175) 775 701 701 701 2410 Mats & towels 850 545 436 436 Share of floor mats and shop towels (10.9% of $4,000) 850 545 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 Asset management software annual maintenance - 500 650 650 ROW weed control - 1,500 1,500 1,500 Material dump charges 2,000 2,000 2,000 2,000 Sidewalk joint corrections - - - 12,000 CSAH 10 median and ROW maintenance (mowing and weed wipping) 4,500 - - - Striping of streets (Ramsey County)(move to 4475) 10,800 8,800 8,950 20,950 3100 Communications 840 893 966 966 Cellular telephones (10.5% of $9,200) 840 893 966 966 3610 Memberships 180 190 190 200 American Public Works Association memb. (APWA) (1/4 of $800) 20 - 15 15 Pesticide license renewal (TF) 40 40 40 40 MN Safety Council 240 230 245 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 200 - - - Pesticide applicator's class (every 2 years) 60 60 60 60 Vehicle inspection license renewal 75 75 75 75 Vehicle inspection recertification 300 300 - - Work zone traffic control (every 3 years) 1,615 1,415 1,115 1,115 4010 Rentals, equipment 2,800 2,800 2,800 3,600 Annual trade-in of skidsteer loaders 1,200 700 2,500 2,500 Specialized equip rental (chipper, crack sealing,) 4,000 3,500 5,300 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) 500 5,500 500 500 67,770 62,284 58,538 59,573 -9.45%-8.10%-6.01%1.77% 40 Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent 2017 Budget Summary Street Snow & Ice Control (100 - 4472): Personnel services: 0100 Salaries, regular 57,539 62,998 60,902 58,753 28,699 60,224 1,471 2.50% 0110 Salaries, overtime 11,296 19,281 7,711 7,932 3,351 8,130 198 2.50% 0300 Social Security 5,054 5,944 5,016 5,102 2,292 5,229 127 2.49% 0321 PERA 4,922 5,855 4,852 5,002 2,513 5,127 125 2.50% 0400 Group insurance 9,623 11,550 7,972 11,160 4,345 11,520 360 3.23% 0500 Workers compensation 4,044 6,116 8,074 7,865 4,903 7,464 (401) -5.10% Total personnel services 92,478 111,744 94,527 95,814 46,103 97,694 1,880 1.96% Materials & supplies: 1230 Supplies, equipment 6,346 19,758 8,185 2,050 486 9,500 7,450 363.41% 1600 Supplies, operating 32,382 41,589 24,726 31,175 18,328 31,175 - 0.00% 1700 Motor fuels & lubricants 5,428 13,786 3,586 3,680 814 2,980 (700) -19.02% 2400 Uniforms & clothing 542 457 397 528 179 528 - 0.00% 2410 Mats & towels 366 331 341 328 181 328 - 0.00% Total materials & supplies 45,064 75,921 37,235 37,761 19,988 44,511 6,750 17.88% Contractual services: 3030 Other professional services 1,248 1,592 1,321 1,200 46 1,325 125 10.42% 3100 Telephone and data cards 507 753 1,713 2,259 567 1,179 (1,080) -47.81% 3610 Memberships - 70 - 70 - 70 - 0.00% 3630 Training & conferences 107 84 118 475 85 285 (190) -40.00% 5130 Repairs, equipment 3,390 3,373 22 2,500 752 2,500 - 0.00% Total contractual supplies 5,252 5,872 3,174 6,504 1,450 5,359 (1,145) -17.60% Capital outlays 7030 Equipment - 2,618 - - - - 0.00% Total capital outlays - 2,618 - - - - - 0.00% Total streets snow & ice control 142,794 196,155 134,936 140,079 67,541 147,564 7,485 5.34% 40,409 44,265 49,870 41 Fund: 100 Department: 4472 Snow & Ice Control Account Description 2014 2015 2016 2017 Description 1230 Supplies, equipment < $5000 250 250 250 500 Filters 4,500 - - 3,000 Skidsteer broom 4,850 - - 4,000 Snow blower for skid steer 2,900 - - - V plow skid steer 1,800 1,800 1,800 2,000 Cutting edges, plow shoes 14,300 2,050 2,050 9,500 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,000 28,125 28,125 Salt: 375 tons @ $75 per ton. 31,050 31,050 31,175 31,175 1700 Motor fuels & lubricants 180 180 180 180 Engine oil: 30 gallons @ $6.00 per gallon. 4,500 3,500 3,500 2,800 Diesel fuel: 1,000 gallons @ $2.80 per gallon. 4,680 3,680 3,680 2,980 2400 Uniforms & clothing 660 370 370 370 Uniforms (8.2% of $4,500) 195 158 158 158 Clothes & boots allowance (.9@$175) 855 528 528 528 2410 Mats & towels 940 410 328 328 Cost share of mats & towels (8.2% of $4,000) 940 410 328 328 3030 Other professional services 1,200 1,200 1,200 1,325 Weather service reports 1,200 1,200 1,200 1,325 3100 Telephone 520 473 579 579 Cellphone (6.3% of $7,500)($9,200) 360 360 1,680 600 GPS data cards 880 833 2,259 1,179 3610 Memberships 150 - - - American Public Works Association memb. (APWA) (1/4 of $750) 40 70 70 70 Minnesota Safety Council 190 70 70 70 3630 Training 55 75 75 85 Hearing tests/RTN training (1.1@$XX) - 400 400 200 Defensive Driving class (2 staff) 55 475 475 285 5130 Repairs, equipment 1,000 2,500 2,500 2,500 Plow, blower, salt spreader repairs, paint plow assemblies 1,000 2,500 2,500 2,500 7030 Capital, equipment > $5000 - 5,600 - - Plow control update (#445) 8,350 8,350 - - GPS equipment for plow trucks 8,350 13,950 - - 63,500 56,746 44,265 49,870 61.70%-10.64%-21.99%12.66% 42 Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent 2017 Budget Summary Street Sign Maintenance (100 - 4475): Personnel services: 0100 Salaries, regular 20,863 23,579 18,442 18,096 8,631 18,721 625 3.45% 0110 Salaries, overtime 1,646 450 657 824 279 845 21 2.55% 0150 Salaries, part-time - - - 2,496 - 2,496 - 0.00% 0300 Social Security 1,685 1,787 1,399 1,638 651 1,689 51 3.11% 0321 PERA 1,597 1,696 1,399 1,419 655 1,467 48 3.38% 0400 Group insurance 2,761 2,698 2,526 3,181 1,267 3,456 275 8.65% 0500 Workers compensation 1,453 2,188 1,966 1,878 1,171 1,778 (100) -5.32% Total personnel services 30,005 32,398 26,389 29,532 12,654 30,452 920 3.12% Materials & supplies: 1600 Supplies, operating 2,465 1,590 10,570 28,500 2,252 28,500 - 0.00% 2400 Uniforms & clothing 199 165 143 435 64 435 - 0.00% 2410 Mats & towels 135 119 122 160 65 160 - 0.00% Total materials & supplies 2,799 1,874 10,835 29,095 2,381 29,095 - 0.00% Contractual services: 3030 Other professional services - - 11 5,500 16 500 (5,000) -90.91% 3100 Telephone 175 180 157 230 98 230 - 0.00% 3250 Electricity - traffic signals 5,531 2,569 2,906 2,000 1,181 3,000 1,000 50.00% 3630 Training & conferences 53 30 17 100 30 100 - 0.00% 5130 Repairs, equipment 298 291 - 500 - 500 - 0.00% Total contractual supplies 6,057 3,070 3,091 8,330 1,325 4,330 (4,000) -48.02% Total street sign maintenance 38,861 37,342 40,315 66,957 16,360 63,877 (3,080) -4.60% 43 Fund: 100 Department: 4475 Street Sign Maintenance 1600 Supplies, operating 5,000 17,500 17,500 17,500 Signs, posts, sign hardware, and supplies - 7,500 7,500 7,500 Street name sign panels, posts, hardware - 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 (3) Traffic counters 6,000 27,750 28,500 28,500 2400 Uniforms & clothing 240 81 81 81 Uniforms (1.8% of $4,500) 70 354 354 354 Clothes and boot allowance (.2@$175) 310 435 435 435 2410 Mats & towels 340 340 160 160 Cost share of mats & towels (4% of $4,000) 340 340 160 160 3030 Other professional services - 5,000 5,000 - Contract pavement marking (Ramsey Co)(moved from 4470) - 500 500 500 Asset management software annual maintenance - 5,500 5,500 500 3100 Telephone 200 200 230 230 Cellphone (2.5% of $8,000)($9,200) 200 200 230 230 3250 Electricity - traffic signals 2,000 2,000 2,000 3,000 Electricity for traffic signals 2,000 2,000 2,000 3,000 3630 Training & conferences 80 80 80 80 Equipment operator training 20 20 20 20 Hearing test/RTN trainging (.4@$50) 100 100 100 100 5130 Repairs, equipment 500 500 500 500 Traffic signal repairs & maintenance 500 500 500 500 9,450 36,825 37,425 33,425 -0.11%289.68%1.63%-10.69% Grand Total all PW Departments 318,160 343,159 315,072 314,188 8.57%7.86%-8.18%-0.28% 44 Y-T-D 2013 2014 2015 2016 06/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Convention & Visitor's Bureau (100-4653) Contractual services 3045 N Metro Convention Bureau 57,346 63,049 65,654 60,800 17,974 61,750 950 1.56% Total contractual services 57,346 63,049 65,654 60,800 17,974 61,750 950 1.56% Total Convention & Visitor's Bureau 57,346 63,049 65,654 60,800 17,974 61,750 950 1.56% Miscellaneous (100 - 4700): Personnel services 0300 Social security 245 248 210 - 106 - - 0.00% 0321 PERA 304 306 388 - 236 - - 0.00% 0400 Group insurance 495 489 488 - 318 - - 0.00% 0750 Fitness program 3,833 3,883 3,889 6,500 2,185 6,500 - 0.00% Total personnel services 4,877 4,926 4,975 6,500 2,845 6,500 - 0.00% Contractual services 3065 Family & youth social services 19,548 19,763 20,178 20,783 20,259 21,406 623 3.00% Total contractual services 19,548 19,763 20,178 20,783 20,259 21,406 623 3.00% Miscellaneous 9900 Transfers - EDA - - 16,000 50,000 - 50,000 - 0.00% 9900 Transfers - Vehicle & Equip. Fund 90,000 100,000 110,000 150,000 - 175,000 25,000 16.67% 9900 Transfers - Special Projects - 825,000 200,000 75,000 - 75,000 - 0.00% 9900 Community Center 145,000 165,000 170,000 170,000 - 175,000 5,000 2.94% Total miscellaneous 235,000 1,090,000 496,000 445,000 - 475,000 30,000 6.74% 0.00% Total miscellaneous 259,425 1,114,689 521,153 472,283 23,104 502,906 30,623 6.48% Debt Service (100 - 4750): Debt Service ESP 8011 Lease payable - - 20,268 24,323 8,830 18,331 (5,992) -24.64% 8021 Interest - - - - 3,418 6,165 6,165 0.00% Total debt service - - 20,268 24,323 12,248 24,496 173 0.71% 2017 Budget Summary 45 Fund: 100 Department: 4653 Convention & Visitor's Bureau Account Description 2014 2015 2016 2017 Description 3045 N Metro Convention Bureau 50,350 53,200 60,800 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) 50,350 53,200 60,800 61,750 Fund: 100 Department: 4700 Miscellaneous Account Description 2014 2015 2016 2017 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 19,763 20,178 20,783 21,406 Northeast Youth and Family Services (NYFS) 19,763 20,178 20,783 21,406 9100 Contingency - - - - Unexpected expenditures, deductibles, grant matches - - - - 9900 Transfers - miscellaneous - 10,000 50,000 50,000 Transfer to Economic Development Authority (EDA) - 50,122 75,000 75,000 Transfer to Special Projects fund - 60,122 125,000 125,000 9900 Transfers - miscellaneous 100,000 110,000 150,000 175,000 Transfer to Vehicle & Equipment Fund 100,000 110,000 150,000 175,000 9990 Community Center 170,000 170,000 170,000 175,000 Subsidy for Community Center operating costs 170,000 170,000 170,000 175,000 296,263 366,800 472,283 502,906 Fund: 100 Department: 4750 Debt Service Account Description 2014 2015 2016 2017 Description 8011 Lease payable - - 24,323 18,331 Lease payable Energy Savings Program 8021 Interest - - - 6,165 Interest - - 24,323 24,496 46 THIS PAGE LEFT BLANK INTENTIONALLY 47 Item No. 1. Meeting Date: July 5, 2016 Type of Business: Work Session City Administrator Review: ______ City of Mounds View Staff Report To: Honorable Mayor and City Council From: Mark Beer, Finance Director Item Title/Subject: 2017 Draft General Fund Budget There is no state levy limit for 2017. The charter will limit any levy increase to between 2 and 3 percent. City departments have been refining their budgets and more adjustments will occur as more accurate information becomes available. The state has concluded the current legislative session with Local Government Aid (LGA) proposed to increase from $666,795 to $671,517 this could increase to $735,514 if the Governor and the Legislature can agree on a special session. The tax bill that contained the LGA increase was pocket vetoed by the Governor. 90% of LGA was included in the 2017 budget and there is no levy increase included at this time. Ramsey County will hold their annual tax meeting at the end of August, they will release preliminary valuation information at that time and staff will be able to calculate the preliminary tax rate and the effect on properties. The Department of Labor Statistics will release inflation data around August 12th. The City will be negotiating union agreements for 2017 through 2019. Another unknown are health insurance premiums. The City contribution for 2016 is $1,010 per employee. General fund Assigned fund balance (levy reduction) will be approximately $5,636,995 at December 31, 2016. The Council has been using a measured draw down of the levy reduction fund balance by $250,000 per year. The preliminary imbalance is $349,365, after considering the planned draw down of $250,000 from the levy reduction fund balance there is an imbalance of $99,365. There are several options that can be used to close this imbalance. (increase revenues, reduce expenditures, use fund balance, or a combination of all three) The City needs to certify a preliminary levy and General Fund budget to the County by September 30th. This can be done anytime over the next few months. Once set the levy can go down but not up. The City will hold a truth in taxation meeting on Monday, December 5th, 2016 at 6pm with a continuation meeting on Monday, December 12th, 2016 at 7pm if needed. Final levy and budget approval may occur at the December 12th meeting. Conclusion Staff is looking for any additional direction from the Council on how they would like to proceed. Respectfully Submitted, Mark Beer Item No. 2. Meeting Date: July 5, 2016 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., Director of Public Works /City Engineer Item Title/Subject: Public Works Facility Update Introduction Since the April 25, 2016 award of the design services contract for the Public Works Facility to Oertel Architects both staff and the designer have met and discussed the facility. Additionally, select Public Works staff visited the Public Works Facilities at White Bear Lake, Vadnais Heights and Little Canada. Oertel has prepared a schematic design and with input from staff has proceeded to develop the design. Discussion During the work session staff and the designer will be presenting the current schematic design along with a brief recap of the facility tours at White Bear Lake, Vadnais Heights and Little Canada. In addition, the current schedule will be reviewed and discussed with the Council. Representatives from Oertel Architects will be attending the work session to address questions and concerns of Council. Respectfully Submitted, Brian Erickson, P.E.