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 - 2015/12/07 (2)
CITY OF MOUNDS VIEW CITY COUNCIL WORK SESSION AGENDA MOUNDS VIEW CITY HALL Monday, December 7, 2015 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. Presentation by Iris McGinnis from Community Support Center 2. Review 2016 Draft Municipal Budget Next Work Session: Monday, January 4, 2016, at 7pm Next City Council Meeting: Monday, December 14, 2015, at 7pm Item No: 01 Meeting Date: December 7, 2015 Type of Business: Work Session City of Mounds View Staff Report To: Honorable Mayor and City Council From: James Ericson, City Administrator Item Title/Subject: Presentation of Iris McGinnis regarding the Community Support Center Introduction: Iris McGinnis is a volunteer representing the Community Support Center and she has been asked to give a presentation regarding organization. Discussion: The Community Support Center received funding through Bethlehem Baptist Church to assist with their programming and outreach efforts for residents in the Mounds View school district area. Ms. McGinnis has prepared a presentation for the City Council and members of the Community and will have brochures available (see attached) which highlight’s the Community Support Center’s services. Recommendation: Consider the presentation and direct any questions you may have to Ms. McGinnis. Respectfully submitted, ________________________ James Ericson City Administrator How We Began 12 years ago---CEAP fund Emergency Assistance How We Began 4 years ago--- Community Support Center Long-term relationships How We Began 1 year ago---Merger Community Support Center and CEAP fund Who Are Our Neighbors? Residents of… New Brighton Mounds View Shoreview Arden Hills North Oaks Who Are Our Neighbors? Almost always… people in crisis Who Are Our Neighbors? Referrals from… Churches Food shelf County 211 “Just heard about us” How Do We Help? Ask for a volunteer Take time to listen How Do We Help? Try to solve crisis problem… Refer Advocate Direct aid How Do We Help? Begin relationship Set goals What Goals? Money matters Social connections What Goals? A better job More training What Goals? Desire for self-sufficiency How Does This Help? A place to be heard again…and again Success!!! A story of a graduate… who wants to stay Success!!! Amazing teamwork among partners Challenges There is still so much to be done 47% of respondents could not handle a $400 emergency without selling something or borrowing. The loan would not be paid off within 30 days. Federal Reserve Board Report, 2015 47% of respondents could not handle a $400 emergency without selling something or borrowing. The loan would not be paid off within 30 days. Federal Reserve Board Report, 2015 92% increase in suburban poverty in Metro area since 2000 Met Council Report 2015 In school year 2014-15: 117 homeless families 182 homeless students Mounds View School District Already this school year… 112 homeless students Mounds View School District Ramsey County homeless shelters have waiting lists. $4,800 per month for emergency shelter per family U.S. Dept. of Housing & Urban Development It costs Hundreds to keep families in their homes Thousands to get them back into permanent homes Participants Live in Our Neighborhoods… New Brighton Mounds View 1st Avenue Hwy 10 3rd Avenue Cty Road I 6th Avenue Woodlawn Drive 9th Avenue Raymond Avenue 7th Street Cornell Drive 10th Street Silver Lake Road 21st Street AND Cty Road E Todd Drive, Arden Hills Innsbruck Drive Lexington Ave., Shoreview Community Support Center Give today Text CSC to 41444 Online at www.CEAP.org/donate Item No: 2 Meeting Date: December 7, 2015 Type of Business: Work Session Administrator Review: _____ City of Mounds View Staff Report To: Honorable Mayor and City Council From: Mark Beer, Finance Director Item Title/Subject: All Funds Budgets for 2016 Attached are budgets for all City Funds (General, Special Revenue, Debt Service, Capital Projects, and Enterprise). The City Council has had an opportunity to review all the funds at different times during the budget process. The City Council adopted a 1% preliminary tax levy for 2016 in September. Most residential property owners’ will see a decrease in the City portion of their tax bills. There have been some minor changes from the preliminary budgets as more accurate information has become available. The preliminary General Fund budget reflected expenditures of $6,493,326. The increase ($48,502) was due to the lease payable for the Energy Savings Program ($24,323) with reductions for insurance costs in several departments and carryover of the election equipment purchase of $36,000. The City Council will continue to use $250,000 from levy reduction “assigned” fund balance. This will leave a deficit of $89,307 that will be taken from unassigned fund balance. Looking forward to 2016, state budget projections show a 1.871 Billion surplus for the current budget period. That means that there will probably not be any cuts to the late December LGA payment. The 2016 LGA payment is certified by the Department of Revenue at $666,792. The 2016 General Fund budget was constructed using 90% of certified LGA as a precaution from changes at the state level. The next revenue forecast will come out in February prior to the start of the legislative session. The next legislative session will be a bonding session with indications that infrastructure and tax cuts will be the primary focus and how to finance it. Staff welcomes any comments or questions. Respectfully Submitted, Mark Beer City of Mounds View 2016 Budget Summary Y-T-D 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 General Fund:Actual Actual Actual Budget Actual Request Dollar Percent Revenues: Property taxes - Base levy 3,355,230 3,328,796 3,363,602 3,665,826 3,330,714 3,706,549 40,723 1.11% Special tax levies, Bonds 93,734 144,627 156,348 158,339 - 154,119 (4,220) -2.67% Special tax levies, Operations 229,145 220,145 217,145 226,145 - 233,145 7,000 3.10% Franchise tax 219,581 259,070 336,711 255,000 241,794 265,000 10,000 3.92% Other taxes 204,492 190,180 109,002 30,000 39,840 29,000 (1,000) -3.33% Hotel/motel tax 54,088 60,364 66,367 56,000 60,886 64,000 8,000 14.29% Licenses and permits 162,954 210,773 246,969 176,842 193,091 177,422 580 0.33% Intergovernmental 587,641 642,900 941,697 948,027 694,817 958,483 10,456 1.10% Charges for services 27,856 24,141 14,933 19,215 16,825 16,815 (2,400) -12.49% Fines & forfeitures 52,054 40,754 40,239 41,000 30,299 40,000 (1,000) -2.44% Interest 116,056 (315,747) 521,224 125,000 (3,535) 125,000 - 0.00% Miscellaneous 308,678 385,794 355,678 256,345 282,386 268,844 12,499 4.88% Transfers: Water Fund 65,410 67,372 69,393 71,475 - 73,619 2,144 3.00% Sewer Fund 51,807 53,361 54,962 56,611 - 58,309 1,698 3.00% Storm Water Fund 6,756 6,959 7,168 7,383 - 7,604 221 2.99% Street Light Fund 2,320 2,390 2,462 2,536 - 2,612 76 3.00% Vehicle & Equipment Fund 11,340 23,736 38,316 21,000 - 22,000 1,000 4.76% Street Improvement - - - - - - - 0.00% Total revenues 5,549,142 5,345,615 6,542,216 6,116,744 4,891,760 6,202,521 85,777 1.40% Expenditures: Legislative Services: City Council 43,857 42,644 46,030 53,153 42,723 51,565 (1,588) -2.99% Advisory Commissions 7,600 8,117 14,315 15,100 8,454 15,100 - 0.00% Subtotal 51,457 50,761 60,345 68,253 51,177 66,665 (1,588) -2.33% Administrative Services: City Administrator 228,701 233,463 231,848 276,630 242,790 281,882 5,252 1.90% Elections 38,205 19,955 20,053 59,200 16,880 61,700 2,500 4.22% Finance 238,066 215,857 232,173 245,969 221,428 257,362 11,393 4.63% Central Services 176,248 200,970 207,551 235,844 188,042 242,986 7,142 3.03% Subtotal 681,220 670,245 691,625 817,643 669,140 843,930 26,287 3.21% Community Development 310,907 323,696 341,593 373,133 313,485 382,720 9,587 2.57% Police 2,407,178 2,493,219 2,481,263 2,761,401 2,417,700 2,752,111 (9,290) -0.34% Fire 448,980 441,466 511,231 565,618 488,523 594,522 28,904 5.11% Public Works Administration 124,505 129,700 141,537 142,129 99,986 138,341 (3,788) -2.67% Parks, Recreation & Forestry: Recreation 95,432 101,502 99,589 112,600 112,429 114,413 1,813 1.61% Parks 319,774 313,627 313,684 319,170 302,594 344,600 25,430 7.97% Forestry 53,757 3,744 17,379 87,257 19,048 67,889 (19,368) -22.20% Subtotal 468,963 418,873 430,652 519,027 434,071 526,902 7,875 1.52% Fleet Services: Building & Grounds Mtnce 131,736 137,025 126,707 142,792 118,029 129,044 (13,748) -9.63% Vehicle & Equipment Mtnce 93,798 89,806 116,011 113,379 83,148 114,805 1,426 1.26% Subtotal 225,534 226,831 242,718 256,171 201,177 243,849 (12,322) -4.81% Streets: Pavement Management 197,578 188,102 205,624 228,476 180,606 228,346 (130) -0.06% Snow & Ice Control 115,928 142,794 196,155 149,469 115,532 140,079 (9,390) -6.28% Sign Maintenance 35,356 38,861 37,342 65,424 29,921 66,957 1,533 2.34% Subtotal 348,862 369,757 439,121 443,369 326,059 435,382 (7,987) -1.80% Other Convention & Visitor's Bureau 51,384 57,346 63,049 53,200 52,052 60,800 7,600 14.29% Social Service Coordination 19,221 19,548 19,763 20,178 20,178 20,783 605 3.00% Miscellaneous/contingency 3,176 4,877 4,926 6,500 4,635 6,500 - 0.00% Transfers to other funds 245,000 235,000 1,090,000 340,122 - 445,000 104,878 30.84% Debt service - - - - 18,242 24,323 24,323 0.00% Subtotal 318,781 316,771 1,177,738 420,000 95,107 557,406 137,406 32.72% Total expenditures 5,386,387 5,441,319 6,517,823 6,366,744 5,096,425 6,541,828 175,084 2.75% Net change in fund balance 162,755 (95,704) 24,393 (250,000) (204,665) (339,307) (89,307) Beginning Fund Balance 9,493,378 9,656,133 9,560,429 9,584,822 9,584,822 9,334,822 Ending Fund Balance 9,656,133 9,560,429 9,584,822 9,334,822 9,380,157 8,995,515 (89,307) 1 City of Mounds View GENERAL FUND 2016 Budget Summary Community Park Public 2016 2015 Percent Legislative Admin Finance Central Development Police Fire & Rec Works Misc.Total Total Variance Change Current Personnel services 33,265$ 276,432$ 236,476$ -$ 352,247$ 2,315,701$ -$ 218,225$ 502,500$ 6,500$ 3,941,346$ 3,791,983$ 149,363$ 3.94% Materials & supplies 2,900 935 725 38,765 3,900 92,777 - 55,498 148,949 - 344,449 344,263 186 0.05% Contractual services 30,500 30,215 20,161 204,221 26,573 338,633 392,683 253,179 166,123 81,583 1,543,871 1,631,302 (87,431) -5.36% Contingency - - - - - - - - - - - - - #DIV/0! Current total 66,665 307,582 257,362 242,986 382,720 2,747,111 392,683 526,902 817,572 88,083 5,829,666 5,767,548 62,118 1.08% Other Principal - - - - - - 123,963 - - 24,323 148,286 115,789 32,497 28.07% Interest - - - - - - 22,817 - - - 22,817 35,010 (12,193) -34.83% Capital outlays - 36,000 - - - 5,000 55,059 - - - 96,059 108,275 (12,216) -11.28% Transfers to other funds - - - - - - - - - 445,000 445,000 340,122 104,878 30.84% Other total - 36,000 - - - 5,000 201,839 - - 469,323 712,162 599,196 112,966 18.85% Department Total 66,665$ 343,582$ 257,362$ 242,986$ 382,720$ 2,752,111$ 594,522$ 526,902$ 817,572$ 557,406$ 6,541,828$ 6,366,744$ 175,084$ 2.75% 2015 Budget 68,253 335,830 245,969 235,844 373,133 2,761,401 565,618 519,027 841,669 420,000 6,366,744 Increase (Decrease)(1,588)7,752 11,393 7,142 9,587 (9,290)28,904 7,875 (24,097)137,406 175,084 Percent change -2.33%2.31%4.63%3.03%2.57%-0.34%5.11%1.52%-2.86%32.72%2.75% 2 City of Mounds View 2016 Budget Summary Y-T-D 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 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 - 36,000 - 0.00% Central Services - - - - - - - 0.00% Finance - - - - - - - 0.00% Subtotal - - - 36,000 - 36,000 - 0.00% Community Development - - - - - - - 0.00% Police 10,616 59,860 - 19,400 11,707 5,000 (14,400) -74.23% Fire - 5,736 22,900 38,925 - 55,059 16,134 41.45% Public Works Administration - - - - - - - 0.00% Parks, Recreation & Forestry: Recreation - - - - - - - 0.00% Parks - 8,016 6,145 - 15,536 - - 0.00% Forestry - - - - - - - 0.00% Subtotal - 8,016 6,145 - 15,536 - - 0.00% Fleet Services: Building & Grounds Mtnce - - - - - - - 0.00% Vehicle & Equipment Mtnce - - 6,050 - - - - 0.00% Subtotal - - 6,050 - - - - 0.00% Streets: Pavement Management - - - - - - - 0.00% Snow & Ice Control - - 2,618 13,950 3,588 - (13,950) -100.00% Sign Maintenance - - - - - - - 0.00% Subtotal - - 2,618 13,950 3,588 - (13,950) -100.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 10,616 73,612 37,713 108,275 30,831 96,059 (12,216) -11.28% 3 City of Mounds View 2016 Budget Summary Y-T-D 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 General Fund:Actual Actual Actual Budget Actual Request Dollar Percent Operating Expenditures: Legislative Services: City Council 43,857 42,644 46,030 53,153 42,723 51,565 (1,588) -2.99% Advisory Commissions 7,600 8,117 14,315 15,100 8,454 15,100 - 0.00% Subtotal 51,457 50,761 60,345 68,253 51,177 66,665 (1,588) -2.33% Administrative Services: City Administrator 228,701 233,463 231,848 276,630 242,790 281,882 5,252 1.90% Elections 38,205 19,955 20,053 23,200 16,880 25,700 2,500 10.78% Central Services 176,248 200,970 207,551 235,844 188,042 242,986 7,142 3.03% Finance 238,066 215,857 232,173 245,969 221,428 257,362 11,393 4.63% Subtotal 681,220 670,245 691,625 781,643 669,140 807,930 26,287 3.36% Community Development 310,907 323,696 341,593 373,133 313,485 382,720 9,587 2.57% Police 2,396,562 2,433,359 2,481,263 2,742,001 2,405,993 2,747,111 5,110 0.19% Fire 448,980 435,730 488,331 526,693 488,523 539,463 12,770 2.42% Public Works Administration 124,505 129,700 141,537 142,129 99,986 138,341 (3,788) -2.67% Parks, Recreation & Forestry: Recreation 95,432 101,502 99,589 112,600 112,429 114,413 1,813 1.61% Parks 319,774 305,611 307,539 319,170 287,058 344,600 25,430 7.97% Forestry 53,757 3,744 17,379 87,257 19,048 67,889 (19,368) -22.20% Subtotal 468,963 410,857 424,507 519,027 418,535 526,902 7,875 1.52% Fleet Services: Building & Grounds Mtnce 131,736 137,025 126,707 142,792 118,029 129,044 (13,748) -9.63% Vehicle & Equipment Mtnce 93,798 89,806 109,961 113,379 83,148 114,805 1,426 1.26% Subtotal 225,534 226,831 236,668 256,171 201,177 243,849 (12,322) -4.81% Streets: Pavement Management 197,578 188,102 205,624 228,476 180,606 228,346 (130) -0.06% Snow & Ice Control 115,928 142,794 193,537 135,519 111,944 140,079 4,560 3.36% Sign Maintenance 35,356 38,861 37,342 65,424 29,921 66,957 1,533 2.34% Subtotal 348,862 369,757 436,503 429,419 322,471 435,382 5,963 1.39% Other Convention & Visitor's Bureau 51,384 57,346 63,049 53,200 52,052 60,800 7,600 14.29% Social Service Coordination 19,221 19,548 19,763 20,178 20,178 20,783 605 3.00% Miscellaneous/contingency 3,176 4,877 4,926 6,500 4,635 6,500 - 0.00% Transfers to other funds 245,000 235,000 1,090,000 340,122 - 445,000 104,878 30.84% Debt service - Lease payable - - - - 18,242 24,323 24,323 0.00% Subtotal 318,781 316,771 1,177,738 420,000 95,107 557,406 137,406 32.72% Total expenditures 5,375,771 5,367,707 6,480,110 6,258,469 5,065,594 6,445,769 187,300 2.99% 4 General Fund Revenue Detail - 2015 Budget Y-T-D Acct 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 #Description Actual Actual Actual Budget Actual Request Dollar Percent Taxes 3101 Current ad valorem property tax 3,355,230 3,328,796 3,363,602 3,665,826 3,330,714 3,706,549 40,723 1.11% 3101 Fire bonds 05 & notes 11 93,734 144,627 156,348 158,339 - 154,119 (4,220) -2.67% 3101 PERA rate increase property tax 39,145 39,145 39,145 39,145 - 39,145 - 0.00% 3101 Police Officer property tax 190,000 181,000 178,000 187,000 - 194,000 7,000 3.74% 3102 Delinquent ad valorem prop tax 37,854 - 12,324 - 14,220 - - 0.00% 3111 Manufact home tax - current 19,740 19,949 19,935 20,000 - 20,000 - 0.00% 3112 Manufact home tax - delinquent 6,977 9,209 8,500 10,000 5,073 9,000 (1,000) -10.00% 3125 Excess TIF 131,545 155,766 62,069 - 18,525 - - 0.00% 3180 Franchise tax on utilities 219,581 259,070 336,711 255,000 241,794 265,000 10,000 3.92% 3190 Penalties & interest 8,087 5,256 5,817 - 2,022 - - 0.00% 3192 Forfeited tax sales 289 - 357 - - - - 0.00% 3195 Hotel/Motel tax 54,088 60,364 66,367 56,000 60,886 64,000 8,000 14.29% Total taxes 4,156,270 4,203,182 4,249,175 4,391,310 3,673,234 4,451,813 60,503 1.38% Licenses and Permits 3211 Liquor on-sale 16,660 16,770 16,775 16,800 16,800 16,800 - 0.00% 3212 Liquor off-sale 610 630 600 600 1,477 600 - 0.00% 3215 Malt on-sale license 100 - 135 - - - - 0.00% 3216 Malt off-sale 755 100 (15) 100 - 100 - 0.00% 3221 Tobacco license 3,220 2,990 3,220 2,900 3,300 2,900 - 0.00% 3223 Amusement devices 1,280 1,168 1,072 1,100 720 1,100 - 0.00% 3231 Bowling alley 672 672 672 672 672 672 - 0.00% 3232 Garbage hauling 2,820 2,906 3,150 2,800 2,558 2,800 - 0.00% 3233 Gasoline station 1,245 908 850 900 850 900 - 0.00% 3234 Used car sales - 204 204 150 204 150 - 0.00% 3235 Kennel 189 185 285 120 426 150 30 25.00% 3236 Restraurant licenses 3,817 3,172 3,025 3,200 3,806 3,100 (100) -3.13% 3237 Cabaret & Dance - 60 - - - - - 0.00% 3238 Transient & solicitor 2,883 4,559 2,235 2,200 2,666 2,200 - 0.00% 3239 Apartment 23,796 24,981 26,331 24,000 28,787 26,000 2,000 8.33% 3240 Rental conversion 1,935 3,835 3,295 1,000 1,235 1,000 - 0.00% 3241 Dog license 3,449 1,197 3,454 1,200 1,408 1,200 - 0.00% 3242 Massage therapy - - - - 442 - - 0.00% 3243 Chickens and bees - - - - 330 200 200 0.00% 3250 General contractor 1,180 720 1,340 1,100 580 1,100 - 0.00% 3251 HVAC contractor 4,444 3,795 6,390 3,800 3,450 3,800 - 0.00% 3252 Cement contractor 120 40 160 100 - 100 - 0.00% 3253 Asphalt contractor 240 160 40 200 60 100 (100) -50.00% 3254 Excavating contractor - 180 60 50 - 50 - 0.00% 3255 Sign & billboard contractor 200 560 680 300 60 300 - 0.00% 3256 Sewer & water contractor - - - 50 100 - (50) -100.00% 3257 Other contractor 1,770 1,320 2,230 1,100 3,070 1,300 200 18.18% 3258 License check 1,699 1,844 2,012 1,200 1,953 1,400 200 16.67% 3260 Fire permits 1,525 924 1,320 600 950 800 200 33.33% Subtotal licenses 74,609 73,880 79,520 66,242 75,904 68,822 2,580 3.89% 5 General Fund Revenue Detail - 2015 Budget Y-T-D Acct 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 #Description Actual Actual Actual Budget Actual Request Dollar Percent 3262 Grading permit 44 225 - - - - - 0.00% 3268 Plan check fee 11,504 35,505 37,926 18,000 21,331 18,000 - 0.00% 3270 Building permits 38,597 54,272 79,071 50,000 48,237 50,000 - 0.00% 3271 Fixed fee - building permits 17,259 16,009 18,592 20,000 17,921 18,000 (2,000) -10.00% 3272 Wetland buffer permit 30 - (7) - - - - 0.00% 3273 HVAC permits 8,980 16,145 15,070 11,000 13,957 11,000 - 0.00% 3274 Plumbing permits 5,492 8,495 9,985 6,000 6,289 6,000 - 0.00% 3275 Non-building permits 5,921 4,839 5,921 5,000 7,619 5,000 - 0.00% 3279 Conditional use permits 400 1,400 600 600 400 600 - 0.00% 3280 Building surcharge (54) 106 144 - 872 - - 0.00% 3281 Fixed fee building surcharge 29 33 75 - 84 - - 0.00% 3282 Mechanical/commercial surcharg (31) (136) 28 - 19 - - 0.00% 3283 HVAC surcharge 92 15 21 - 67 - - 0.00% 3284 Plumbing surcharge 109 (16) 13 - 31 - - 0.00% 3286 Water & sewer surcharge - - - 354 - 0.00% 3287 Commercial plmb surcharge (27) 1 10 - 6 - - 0.00% Subtotal permits 88,345 136,893 167,449 110,600 117,187 108,600 (2,000) -1.81% Total licenses & permits 162,954 210,773 246,969 176,842 193,091 177,422 580 0.33% Intergovernmental: 3318 Federal grant 3,276 2,761 1,088 - 350 - - 0.00% 3341 Local Government Aid 232,078 232,078 597,024 590,356 327,766 600,112 9,756 1.65% 3346 PERA Aid 8,671 8,671 8,671 8,671 4,335 8,671 - 0.00% 3351 Street Aid - MSA maintenance 106,605 104,397 109,063 106,000 122,280 106,000 - 0.00% 3355 Police Aid 120,281 136,324 126,933 130,000 141,567 135,000 5,000 3.85% 3356 Police training 6,310 5,810 5,471 6,000 5,664 5,700 (300) -5.00% 3357 State police grant - 1,862 1,088 - 389 - - 0.00% 3359 Other state grants 35,067 81,764 27,409 37,000 28,352 37,000 - 0.00% 3370 Other local government revenue 6,863 586 2,000 - - - - 0.00% 3371 IDS # 621 - SRO 68,490 68,647 62,950 70,000 64,114 66,000 (4,000) -5.71% Total intergovernmental 587,641 642,900 941,697 948,027 694,817 958,483 10,456 1.10% Charges for services 3410 Advertising revenue 770 1,060 1,620 600 205 700 100 16.67% 3415 Housing inspections 10 - - 50 63 50 - 0.00% 3418 HRA inspections 2,808 1,118 190 2,000 - 1,000 (1,000) -50.00% 3419 Investigations - 30 228 - 2,806 - - 0.00% 3421 Police reports 1,191 1,666 1,723 1,200 1,128 1,200 - 0.00% 3422 Documents / copies 44 68 26 90 353 90 - 0.00% 3423 Customer service 256 147 281 300 566 300 - 0.00% 3425 Book sales - various 120 19 10 - - - - 0.00% 3426 Reimbursed staff time 458 375 15 1,000 - 500 (500) -50.00% 3430 Right-of-way 15,754 15,778 5,615 9,000 9,054 9,000 - 0.00% 3431 Street opening fee 125 - - - 200 - - 0.00% 3432 Tree removal charges 1,120 (2,320) - 2,000 - 1,000 (1,000) -50.00% 3433 Overload permits 3,050 3,450 75 - - - - 0.00% 3458 Zoning letter 150 250 300 75 150 75 - 0.00% 3461 Subdivision - 700 2,100 1,000 - 1,000 - 0.00% 3462 Variance 1,400 1,800 1,800 1,000 1,800 1,000 - 0.00% 3463 Rezoning - - - 200 500 200 - 0.00% 3464 Development - non refund - - 450 350 - 350 - 0.00% 3465 Code appeal 200 - - - - - - 0.00% 3466 Comprehensive Plan Amendmen - - 500 - - - - 0.00% 3467 PUD amendment 400 - - 350 - 350 - 0.00% Total charges for services 27,856 24,141 14,933 19,215 16,825 16,815 (2,400) -12.49% 6 THIS PAGE LEFT BLANK INTENTIONALLY 7 General Fund Revenue Detail - 2015 Budget Y-T-D Acct 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 #Description Actual Actual Actual Budget Actual Request Dollar Percent Fines and Forfeitures 3510 Ramsey County municipal court 43,263 34,279 35,010 33,000 26,845 34,000 1,000 3.03% 3515 Mn Highway Patrol 637 920 233 500 50 500 - 0.00% 3520 Administrative offenses 5,079 2,780 2,621 5,000 2,029 3,000 (2,000) -40.00% 3525 False alarm charges 3,075 2,775 2,375 2,500 1,375 2,500 - 0.00% Total fines & forfeitures 52,054 40,754 40,239 41,000 30,299 40,000 (1,000) -2.44% Other Revenue 3550 Special assessments 4,160 2,873 11,601 3,000 2,112 3,000 - 0.00% 3610 Investment income (charge)116,056 (315,747) 521,224 125,000 (3,535) 125,000 - 0.00% 3630 Billboard Lease 86,374 100,980 103,110 104,675 105,303 112,562 7,887 7.53% 3631 Water tower rental 91,417 95,063 98,855 102,820 101,639 106,932 4,112 4.00% 3634 Equipment and space rental 4,799 4,631 5,268 4,000 5,454 4,500 500 12.50% 3639 Security 2,340 280 - - 2,510 - - 0.00% 3650 Donations 50 1,387 11,485 - 4,500 - - 0.00% 3651 Donations - K9 1,247 2,612 1,618 750 1,047 750 - 0.00% 3655 City fines 150 - - - - - - 0.00% 3665 Park site permit 15,703 15,864 12,497 13,000 14,087 13,000 - 0.00% 3679 Vending machine commissions 448 - 466 100 - 100 - 0.00% 3680 Other revenue 13,585 84,695 46,993 11,000 11,423 11,000 - 0.00% 3685 Insurance reimbursements 76,905 60,685 59,152 10,000 5,512 10,000 - 0.00% 3690 Cash over / short (17) 9 (22) - - - - 0.00% 3911 Sale of assets 7,500 13,327 550 5,000 28,338 5,000 - 0.00% 3912 Resale of materials 4,017 3,388 4,105 2,000 461 2,000 - 0.00% Total other revenue 424,734 70,047 876,902 381,345 278,851 393,844 12,499 3.28% Transfers & Debt proceeds 3972 Transfers: Vehicle & Equip replacemen 11,340 23,736 38,316 21,000 22,000 1,000 4.76% DARE fund - - - - 4,643 - - 0.00% Water 65,410 67,372 69,393 71,475 73,619 2,144 3.00% Sewer 51,807 53,361 54,962 56,611 58,309 1,698 3.00% Storm Water 6,756 6,959 7,168 7,383 7,604 221 2.99% Street light 2,320 2,390 2,462 2,536 2,612 76 3.00% 3993 Debt proceeds - - - - - - - 0.00% Total Transfers & Debt 137,633 153,818 172,301 159,005 4,643 164,144 5,139 3.23% Total 5,549,142 5,345,615 6,542,216 6,116,744 4,891,760 6,202,521 85,777 1.40% 8 Y-T-D 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 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 26,851 29,388 - 0.00% 0300 Social Security 1,482 1,129 1,129 2,248 1,035 2,248 - 0.00% 0321 PERA 885 885 885 1,470 811 1,470 - 0.00% 0500 Workers compensation 57 63 111 122 148 159 37 58.73% Total personnel services 31,716 31,369 31,417 33,228 28,845 33,265 37 0.12% Materials & supplies 1600 Supplies, operating 1,639 940 1,690 2,300 1,635 2,600 300 31.91% Total materials & supplies 1,639 940 1,690 2,300 1,635 2,600 300 31.91% Contractual services 3030 Other professional services 5,068 5,115 6,895 9,075 4,371 6,200 (2,875) -56.21% 3610 Memberships 2,831 2,831 2,801 5,800 5,161 5,600 (200) -7.06% 3630 Training & conferences 1,884 1,703 2,633 2,000 2,208 3,200 1,200 70.46% 4800 Bonding & insurance 719 686 594 750 503 700 (50) -7.29% Total contractual services 10,502 10,335 12,923 17,625 12,243 15,700 (1,925) -18.63% Capital outlays - - - - - - - 0.00% Total City Council 43,857 42,644 46,030 53,153 42,723 51,565 (1,588) -3.72% 19,925 18,300 Advisory Commissions (100-4110): Materials & supplies 1600 Supplies, operating - - - 200 41 200 - 0.00% 2100 Books & periodicals - - - 100 - 100 - 0.00% Total materials & supplies - - - 300 41 300 - 0.00% Contractual services 3030 Other professional services 2,030 3,250 4,369 5,000 1,961 5,000 - 0.00% 3630 Training & conferences 126 - - 300 - 300 - 0.00% 3900 Festivities Commission 5,444 4,867 9,946 9,500 6,452 9,500 - 0.00% Total contractual services 7,600 8,117 14,315 14,800 8,413 14,800 - 0.00% Capital outlays - - - - - - 0.00% Total Advisory Commissions 7,600 8,117 14,315 15,100 8,454 15,100 - 0.00% 2016 Budget Summary 9 Fund: 100 Department: 4100 City Council Account Description 2013 2014 2015 2016 Description 1600 Supplies, operating 800 900 900 1,000 Employee appreciation dinner - 500 500 600 Strategic planning session supplies 800 900 900 1,000 Plaques and gift certificates for employee appreciation 1,600 2,300 2,300 2,600 3030 Other professional services 500 3,000 3,000 - Strategic planning session(s) facilitator 7,425 7,425 6,075 6,200 Contractual minutes for Council mtgs ( $225 x 24 reg, + 3 special) 7,925 10,425 9,075 6,200 3610 Memberships 25 25 30 30 Mn Mayor's Association 2,801 2,801 5,770 5,570 North Metro Mayors 2,826 2,826 5,800 5,600 3630 Conferences 1,800 2,000 2,000 3,200 Council training, LMC conference, RCCLG dinners & NLC conference 1,800 2,000 2,000 3,200 4800 Bonds & insurance 1,000 900 750 700 General property & liability 1,000 900 750 700 15,151 18,451 19,925 18,300 -0.84%21.78%7.99%-8.16% Fund: 100 Department: 4110 Advisory Commissions Account Description 2013 2014 2015 2016 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 2,000 Charter commission legal fees 2,500 2,500 2,500 2,500 Planning Commission meeting minutes 5,000 5,000 5,000 5,000 3630 Training 175 175 150 150 Misc training & conferences. 175 175 150 150 Planning Commissioner training & conferences 350 350 300 300 3900 Festival in the Park 4,500 4,500 9,500 4,500 City Festival in the Park (personnel, supplies) - - - 5,000 Fireworks 4,500 4,500 9,500 9,500 10,150 10,150 15,100 15,100 -4.69%0.00%48.77%0.00% 10 Y-T-D 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Office of the City Administrator (100 - 4130): Personnel services 0100 Salaries, regular 177,306 179,161 177,671 208,507 188,970 214,356 5,849 2.81% 0110 Salaries, over-time - - - 814 - 874 60 7.37% 0150 Salaries, part-time - - - 1,872 - 1,872 - 0.00% 0300 Social Security 12,929 13,216 12,871 16,156 14,117 16,608 452 2.80% 0321 PERA 12,675 12,817 12,692 15,699 13,844 16,143 444 2.83% 0400 Group insurance 22,579 24,255 24,479 24,008 18,928 24,808 800 3.33% 0500 Workers compensation 883 962 1,465 1,914 2,325 1,771 (143) -7.47% Total personnel services 226,372 230,411 229,178 268,970 238,184 276,432 7,462 2.77% Materials & supplies 1230 Supplies, equipment - 454 340 725 179 825 100 13.79% 1600 Supplies, operating - - - 75 13 75 - 0.00% 2100 Books & periodicals 32 - - 35 - 35 - 0.00% Total materials & supplies 32 454 340 835 192 935 100 11.98% Contractual services 3100 Communications 661 649 631 760 536 1,300 540 71.05% 3610 Memberships 185 165 142 190 188 190 - 0.00% 3630 Training & conferences 1,451 1,574 1,335 5,500 3,690 2,650 (2,850) -51.82% 3800 Mileage - 210 222 375 - 375 - 0.00% Total contractual services 2,297 2,598 2,330 6,825 4,414 4,515 (2,310) -33.85% Total City Administrator 228,701 233,463 231,848 276,630 242,790 281,882 5,252 1.90% 7,660 5,450 Elections (100 - 4140): Contractual services 3030 Other professional services 38,205 19,955 20,053 23,200 16,880 25,700 2,500 10.78% Total contractual services 38,205 19,955 20,053 23,200 16,880 25,700 2,500 10.78% 7030 Capital outlays - - - 36,000 - 36,000 - 0.00% Total Elections 38,205 19,955 20,053 59,200 16,880 61,700 2,500 4.22% 2016 Budget Summary 11 Fund: 100 Department: 4130 Office of the City Administrator Account Description 2013 2014 2015 2016 Description 1230 Supplies, equipment < $5000 450 725 725 825 Furniture or equipment under the $1,000 capitalization threshold 450 725 725 825 1600 Supplies, Operating 100 75 75 75 Miscellaneous supplies 100 75 75 75 2100 Books & Periodicals 35 35 35 35 Miscellaneous reference books 35 35 35 35 3100 Communications 760 760 760 1,300 Verizon service (2 data plans) 760 760 760 1,300 3610 Memberships 50 50 - - MAMA - (Administrator) Metro Area Manager's Association 150 150 150 150 Mn City County Managers Association 40 40 40 40 Municipal Clerks & Finance Officers Association 240 240 190 190 3630 Training & conferences 100 100 100 100 MAMA meetings 500 500 500 500 LMC / miscellaneous training 100 100 100 100 Chamber lunches 850 850 850 1,000 LMC annual conference (2 attendees)(St.Paul)(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 - National ICMA or NLC conference (City Administrator)(every other year) 2,500 5,500 5,500 2,650 3800 Mileage 375 375 375 375 Miscellaneous mileage @ IRS rate. 375 375 375 375 4,460 7,710 7,660 5,450 -1.11%72.87%-0.65%-28.85% Fund: 100 Department: 4140 Elections Account Description 2013 2014 2015 2016 Description 3030 Other professional services 20,000 20,000 23,200 23,200 Ramsey County elections contract - - - 2,500 Equip. maint. service costs (voting equip.) 20,000 20,000 23,200 25,700 7030 Equipment - 36,000 36,000 36,000 Voting equipment - 36,000 36,000 36,000 20,000 56,000 59,200 61,700 -45.21%180.00%5.71%4.22% 12 Y-T-D 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Finance (100 - 4150): Personnel services 0100 Salaries, regular 149,272 154,279 166,331 173,931 158,114 182,752 8,821 5.07% 0150 Salaries, part-time 22,748 - - - - - - 0.00% 0300 Social Security 11,603 11,004 11,908 13,306 11,280 13,980 674 5.07% 0321 PERA 11,810 10,960 11,808 13,045 11,559 13,707 662 5.07% 0400 Group insurance 23,470 20,866 21,413 23,814 19,937 24,335 521 2.19% 0500 Workers compensation 1,079 1,042 1,273 1,523 1,850 1,702 179 11.75% 0990 Severence - - - - - - - 0.00% Subtotal 219,982 198,151 212,733 225,619 202,740 236,476 10,857 4.81% Materials & supplies 1230 Supplies, equipment - 48 17 200 - 200 - 0.00% 1600 Supplies, operating - - 35 75 - 75 - 0.00% 2100 Books & periodicals 539 182 181 550 - 450 (100) -18.18% Subtotal 539 230 233 825 - 725 (100) -12.12% Contractual services 3030 Other professional 9,519 9,731 9,811 10,075 9,737 10,255 180 1.79% 3100 Communications - - 480 480 400 480 - 0.00% 3430 Printing 1,630 202 1,179 700 551 700 - 0.00% 3610 Memberships 495 790 804 985 970 995 10 1.02% 3630 Training 1,670 2,304 2,635 2,375 2,428 2,575 200 8.42% 5130 Repairs & maint., equipment 4,231 4,449 4,298 4,910 4,602 5,156 246 5.01% Subtotal 17,545 17,476 19,207 19,525 18,688 20,161 636 3.26% Total Financial Services 238,066 215,857 232,173 245,969 221,428 257,362 11,393 4.63% 2016 Budget Summary 13 Fund: 100 Department: 4150 Finance Account Description 2013 2014 2015 2016 Description 1230 Supplies, equitpment < $5000 300 200 200 200 Furniture or equipment under the $5,000 capitalization threshold 300 200 200 200 1600 Supplies, operating 75 75 75 75 Misc supplies - planners, plaques, folders, files, etc. 75 75 75 75 2100 Books & periodicals 350 550 550 450 Misc computer & finance books & periodicals 350 550 550 450 3030 Other professional services 9,120 9,300 9,480 9,660 30% 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,715 9,895 10,075 10,255 3100 Communications - 480 480 480 cell phone ($40 month) - 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 210 200 350 350 Government Finance Officer's Association (GFOA) 120 120 120 120 Mn GFOA (2) 220 230 240 250 AICPA Am. Institute of Certified Public Accts 230 265 275 275 MNCPA Mn Society of Certified Public Accountants 780 815 985 995 3630 Training & conferences 75 75 75 75 Mn GFOA monthly meetings 1,200 1,250 1,450 1,600 Seminars & training - 1,200 - - (2) GFOA National conference (In Minneapolis no travel expenses) 500 500 600 650 Accounting and software training 300 250 250 250 Mileage 2,075 3,275 2,375 2,575 5130 Equipment repairs 4,452 4,675 4,910 5,156 40% accounting software support charges 4,452 4,675 4,910 5,156 18,447 20,665 20,350 20,886 3.58%12.02%-1.52%2.63% 14 Y-T-D 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Central Services (100 - 4160): Materials & supplies 1110 Stationery 455 302 1,027 1,000 - 1,000 - 0.00% 1120 Copy materials 828 523 - 1,500 830 1,500 - 0.00% 1230 Supplies, equipment 7,700 15,068 4,296 20,000 12,848 20,000 - 0.00% 1600 Supplies, operating 16,483 12,054 14,462 15,900 11,329 15,900 - 0.00% 2100 Books & periodicals 283 149 159 365 169 365 - 0.00% Total materials & supplies 25,749 28,096 19,944 38,765 25,176 38,765 - 0.00% Contractual services 3010 General legal 30,846 47,253 57,407 44,400 38,535 44,000 (400) -0.90% 3030 Other professional services 7,383 11,387 5,154 9,300 8,332 9,300 - 0.00% 3100 Telephone 6,430 6,790 7,078 6,800 5,585 7,400 600 8.82% 3300 Postage 5,599 6,167 8,366 7,800 8,280 7,800 - 0.00% 3410 Legal notices 3,070 2,854 2,395 3,000 2,954 3,000 - 0.00% 3420 Advertising - 1,678 2,534 3,000 890 2,500 (500) -16.67% 3430 Printing 5,527 5,992 8,330 7,000 6,321 7,400 400 5.71% 3610 Memberships 10,339 10,755 13,424 16,251 19,253 19,922 3,671 22.59% 3630 Training & conferences 113 1,625 172 2,000 1,167 2,000 - 0.00% 4010 Rental, equipment 134 1,772 1,431 1,750 703 1,750 - 0.00% 4800 Insurance & bonds 14,348 17,103 14,614 22,000 15,212 22,000 - 0.00% 5100 Repairs & maint, computers 66,619 59,498 64,347 73,178 51,987 76,549 3,371 4.61% 5130 Repairs, equipment 91 - 2,355 600 3,647 600 - 0.00% Total contractual services 150,499 172,874 187,607 197,079 162,866 204,221 7,142 3.62% Total central services 176,248 200,970 207,551 235,844 188,042 242,986 7,142 3.03% 2016 Budget Summary 15 Fund: 100 Department: 4160 Central Services Account Description 2013 2014 2015 2016 Description 1110 Stationery 1,300 1,300 1,000 1,000 Envelopes, labels, letterhead, etc. 1,300 1,300 1,000 1,000 1120 Copy materials 2,000 2,000 1,500 1,500 Copy paper 2,000 2,000 1,500 1,500 1230 Supplies, equipment < $5000 16,800 20,800 20,000 20,000 Comp & security equip under $5,000, pc's, software, switches, cameras.... 16,800 20,800 20,000 20,000 Replace pc's @ $800 5 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 125 175 175 Employment handbooks/publications 340 360 190 190 Star Tribune - $190 465 485 365 365 3010 General legal 26,400 26,400 26,400 24,000 Retainer for legal services 21,000 18,000 18,000 20,000 Legal fees outside scope of retainer. 47,400 44,400 44,400 44,000 3030 Other professional services 6,500 6,000 6,000 5,700 General labor assistance 1,400 1,400 1,400 1,500 Section 125 (flex spending plan) & COBRA administration 900 900 900 1,000 Human resources items 1,000 1,000 1,000 1,100 Web hosting/GovOffice (Avenet) 9,800 9,300 9,300 9,300 3100 Telephone 6,400 6,800 6,800 7,400 Basic telephone plus long distance 6,400 6,800 6,800 7,400 3300 Postage 300 300 300 300 Courier charges (delivery services) 10,200 9,200 7,500 7,500 General postage includes PW mailings for street projects. 10,500 9,500 7,800 7,800 3410 Legal notices 900 900 900 900 Truth in taxation notices and Ramsey County fees. 1,600 2,100 2,100 2,100 Legal notices and legal publications. 2,500 3,000 3,000 3,000 3420 Advertising 3,500 3,000 3,000 2,500 Job opening advertisements for vacant positions 3,500 3,000 3,000 2,500 3430 Printing 6,400 6,000 6,400 6,800 4 newsletter-50% cost here, 50% in YMCA. 750 750 200 200 Miscellaneous printing 750 750 400 400 City guides, directories & miscellaneous 7,900 7,500 7,000 7,400 3610 Memberships 605 605 605 600 Ramsey County League of Local Governments (RCLLG) - - - 2,850 I-35W Corridor Coalition - 2,381 4,833 4,835 Metro Cities 10,447 10,447 10,813 11,637 League of Mn Cities (5% increase for 2016) 11,052 13,433 16,251 19,922 3630 Training & conferences 800 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 1,800 2,000 2,000 2,000 4010 Rental, equipment 150 150 150 150 Misc 1,500 1,600 1,600 1,600 Postage machine and scale rental 1,650 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 58,500 59,000 64,000 Computer, phone, network & technology assistance - City of Roseville 4,190 4,190 4,190 4,190 Copier maintenance + overages 2,198 2,198 2,198 2,609 Laserfiche annual maintenance and storage 1,311 1,360 2,040 - Hosted servers (2 servers) add (1) in 2015 (included in technology assist.) 5,750 5,750 5,750 5,750 Computer, printer, and networks repairs. 71,949 71,998 73,178 76,549 5130 Repairs, equipment 900 900 600 600 Postage meter, copy machine, fax, misc. 900 900 600 600 233,816 236,066 235,844 242,986 7.13%0.96%-0.09%3.03% 16 Y-T-D 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Community Development (100 - 4180): Personnel services 0100 Salaries, regular 204,654 224,644 245,039 256,937 227,681 260,927 3,990 1.55% 0110 Overtime, regular - - 24 653 - 666 13 1.99% 0150 Salaries, part time 15,521 6,311 1,380 2,964 1,068 2,808 (156) -5.26% 0300 Social Security 11,470 14,743 17,745 19,932 16,125 20,228 296 1.49% 0321 PERA 19,660 18,150 17,572 19,331 16,834 19,619 288 1.49% 0400 Group insurance 39,825 34,528 35,750 44,820 33,752 46,002 1,182 2.64% 0500 Workers comp 1,181 1,343 2,177 2,354 2,859 1,997 (357) -15.17% 0600 Unemployment - - - - - - - 0.00% Total personnel services 292,311 299,719 319,687 346,991 298,319 352,247 5,256 1.51% Materials & supplies 1230 Supplies, equipment 75 - 510 475 - 825 350 73.68% 1600 Supplies, operating 32 17 - 300 110 300 - 0.00% 1700 Motor fuels & lubricants 3,149 1,533 2,191 1,788 1,507 2,200 412 23.04% 2100 Books & periodicals 126 164 - 375 367 375 - 0.00% 2400 Uniforms - 79 296 200 - 200 - 0.00% Total materials & supplies 3,382 1,793 2,997 3,138 1,984 3,900 762 24.28% Contractual services 3030 Other professional 10,226 16,189 12,869 14,878 8,564 18,652 3,774 25.37% 3040 Consultants, development review 2,118 1,116 2,085 3,000 822 3,000 - 0.00% 3100 Telephone 686 1,333 1,240 1,781 1,184 1,781 - 0.00% 3430 Printing 846 847 762 1,300 543 1,000 (300) -23.08% 3610 Memberships 570 710 870 745 1,080 840 95 12.75% 3630 Training and conferences 729 1,989 1,024 1,200 983 1,200 - 0.00% 3800 Mileage 39 - 59 100 6 100 - 0.00% Total contractual services 15,214 22,184 18,909 23,004 13,182 26,573 3,569 15.51% Total Community Development 310,907 323,696 341,593 373,133 313,485 382,720 9,587 2.57% 2016 Budget Summary 17 Fund: 100 Department: 4180 Community Development Account Description 2013 2014 2015 2016 Description 1230 Supplies, equipment < $5000 475 475 475 825 Miscellaneous equipment & computer peripherals 475 475 475 825 1600 Supplies, operating 175 175 100 100 Presentation supplies 200 200 200 200 Office supplies 375 375 300 300 1700 Motor fuels & lubs 3,200 3,200 1,788 2,200 Unleaded fuel: 800 gallons @ $2.75 (Gas for Comm Devlopment) 3,200 3,200 1,788 2,200 2100 Books & periodicals 100 100 100 100 Reference materials 80 - - - Planning Commission Journal 100 100 100 100 Intl. Code Council Manuals and Code Updates 175 200 175 175 Manuals, pamphlets, etc. 455 400 375 375 2400 Uniforms 175 175 200 200 Clothing for inspections staff 175 175 200 200 3030 Other professional 1,300 1,300 1,300 1,300 Ramsey County JPA (geographic information system) 3,900 3,900 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 Permit works mobile inspector annual support fee 500 500 500 500 Filing fees (Ramsey County increased fees from $29 to $48) 3,486 3,486 1,971 2,110 Comcate code enforcement license - - 1,987 1,987 Comcate mobile access 500 500 500 500 GIS assistance 4,000 4,000 4,000 4,000 Abatements of nuisance properties 13,686 13,686 14,878 18,652 3040 Consulting - Development 1,000 1,000 750 750 Environmental reviews Review (reimbursable)1,000 1,000 750 750 City attorney services 1,000 1,000 750 750 Development case reviews 1,000 1,000 750 750 Engineering services 4,000 4,000 3,000 3,000 3100 Telephone 500 750 1,300 1,300 Verizon Cell Accounts (2) for inspectors 400 480 481 481 network card for code enforcement 900 1,230 1,781 1,781 3430 Printing 1,400 1,400 1,300 1,000 Forms, flyers, etc. 1,400 1,400 1,300 1,000 3610 Memberships 300 300 300 300 American Planning Association (APA) - National & state (1) 120 120 120 120 Assoc. of MN Building Officials 60 60 - - Fire Marshal's Assoc. of MN 120 120 120 125 International Code Council (ICC) 60 60 60 95 10K Lakes Chapter of ICC 60 60 60 100 MN Assoc. Housing Code Officials 85 85 85 100 MN Building Permit Technicians Association (MBPTA) 805 805 745 840 3630 Training & conferences 300 600 600 600 APA state conference (one attendee) 300 300 300 300 Other software training 300 300 300 300 Other staff training & seminars 900 1,200 1,200 1,200 3800 Mileage 100 100 100 100 Misc. use of personal automobiles 100 100 100 100 26,471 27,046 26,142 30,473 -1.49%2.17%-3.34%16.57% 18 Y-T-D 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Police (100 - 4200): Personnel services: 0100 Salaries, regular 1,497,810 1,495,148 1,542,874 1,556,229 1,393,045 1,620,155 63,926 4.11% 0110 Overtime 77,953 108,555 74,978 57,255 72,224 58,473 1,218 2.13% 0150 Salaries, part-time 15,034 10,556 - - - - - 0.00% 0300 Social Security 24,186 24,410 26,023 29,431 24,973 30,752 1,321 4.49% 0321 PERA 217,206 212,359 226,087 250,614 225,914 260,597 9,983 3.98% 0400 Group insurance 200,823 190,444 205,941 250,020 202,801 256,794 6,774 2.71% 0500 Workers compensation 39,556 44,499 57,033 64,374 78,193 88,930 24,556 38.15% Total personnel services 2,072,568 2,085,971 2,132,936 2,207,923 1,997,150 2,315,701 107,778 4.88% Materials & Supplies 1210 Supplies, buildings & grounds 400 - - 800 - 800 - 0.00% 1230 Supplies, equipment 16,368 11,705 19,509 19,600 13,968 24,600 5,000 25.51% 1600 Supplies, operating 6,257 6,242 4,543 7,450 7,627 7,100 (350) -4.70% 1700 Motor, fuels & lubricants 59,042 45,043 43,608 43,425 33,381 39,807 (3,618) -8.33% 2100 Books & periodicals 703 823 811 900 1,031 900 - 0.00% 2400 Uniforms & clothing 17,370 21,502 16,974 19,570 14,767 19,570 - 0.00% Total materials & supplies 100,140 85,315 85,445 91,745 70,774 92,777 1,032 1.12% Contractual services 3010 General Legal - 154 - - - - - 0.00% 3020 Legal, prosecuting attorney 52,220 53,194 53,181 74,214 60,660 76,398 2,184 2.94% 3030 Other professional services 1,054 27,485 11,556 3,590 1,848 3,590 - 0.00% 3050 Dispatching 96,617 94,450 100,915 109,819 90,048 106,426 (3,393) -3.09% 3055 Information systems fees 4,966 2,540 2,540 2,616 2,055 2,626 10 0.38% 3070 COPS events - - 644 500 802 700 200 40.00% 3080 Veternarian services 3,983 3,385 2,951 5,200 4,374 5,500 300 5.77% 3100 Telephone 1,936 3,185 2,889 2,600 2,402 6,420 3,820 146.92% 3210 Electricity 265 342 290 320 232 320 - 0.00% 3430 Printing 379 1,420 339 800 149 500 (300) -37.50% 3610 Memberships 1,485 1,825 1,925 1,970 1,420 1,910 (60) -3.05% 3630 Training 7,325 8,098 9,166 12,830 8,775 12,830 - 0.00% 4800 Insurance & bonds 22,677 38,361 40,670 64,100 42,602 64,100 - 0.00% 5100 Technology maintenance 21,862 20,935 29,252 152,034 117,307 47,423 (104,611) -68.81% 5130 Maintenance, equipment 9,085 6,699 6,564 11,740 5,395 9,890 (1,850) -15.76% Total contractual services 223,854 262,073 262,882 442,333 338,069 338,633 (103,700) -23.44% Capital outlays 7030 Equipment 10,616 59,860 - 19,400 11,707 5,000 (14,400) -74.23% Total capital outlays 10,616 59,860 - 19,400 11,707 5,000 (14,400) -74.23% Total police 2,407,178 2,493,219 2,481,263 2,761,401 2,417,700 2,752,111 (9,290) -0.34% 2016 Budget Summary 19 Fund: 100 Department: 4200 Police Account Description 2013 2014 2015 2016 Description 1210 Supplies, bldgs & grounds 800 800 800 800 Carpet cleaning & misc maintenance items 800 800 800 800 1230 Supplies, equipment < $5000 2,000 4,500 4,500 4,500 Miscellaneous office equip (6 squad room 2 clerical chairs )(eticket paper) - - 800 - Laptop - - - 800 SLR camera for Investigations - - - 2,000 Shredder - - - 3,000 Rifle mounts (10@$300 each) - - - 4,000 Bicycles and racks for park patrol (3) - - 4,000 - (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 12,300 14,800 19,600 24,600 1600 Supplies, operating 3,750 3,750 3,750 3,400 Photo print supplies, fire extinguishers, gloves, inkjet cartridges, toner, etc. 500 700 700 700 K9 Food - - 500 500 Portable radio batteries (10) @ $50 1,750 2,500 2,500 2,500 Batteries, breathalyzer parts, DVD's & CD's, disinfectant, simulation ammo ammunition, crime scene tape, emergency blankets, etc. 6,000 6,950 7,450 7,100 1700 Motor, fuels, & lubs -52,000 52,000 42,300 38,775 Unleaded gas 14,100 gallons @ $2.75/gal. 1,500 1,500 1,125 1,032 K9 take home car gas 375 gallons @ $2.75 53,500 53,500 43,425 39,807 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 720 710 710 Chief 720 720 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,240 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,760 19,570 19,570 3020 Legal, prosecuting attorney 55,142 56,214 74,214 76,398 Retainer ($6,239 per month)(misc charges $1,530) 55,142 56,214 74,214 76,398 3030 Other professional services 600 600 700 700 Tobacco compliance project 150 150 150 150 Hazardous material disposal fee 1,500 1,500 1,500 1,500 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,490 3,590 3,590 3050 Dispatching 94,450 100,916 109,819 106,426 Ramsey County dispatching 94,450 100,916 109,819 106,426 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 515 525 IACP.net ($500 annual in 06, 07, 08, 09,10,11) 2,616 2,616 2,616 2,626 3070 COPS events 500 500 500 700 National night out, town hall meeting, child ID, stickers 500 500 500 700 3080 Veterinarian services 5,000 5,000 4,200 4,500 Brighton Vet Clinic 1,000 1,000 1,000 1,000 K9 vet services 6,000 6,000 5,200 5,500 3100 Telephone 2,150 2,600 2,600 6,420 Verizon cell phones (10 phones)(new 6 smart, 4 basic)($420 accessories) 2,150 2,600 2,600 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 2013 2014 2015 2016 Description 3430 Printing 800 800 800 500 Dept manual, Emergency management manual, business cards, 800 800 800 500 3610 Memberships 100 100 100 - Assoc. Metro Emergency Managers 50 50 50 50 FBI/LEEDA Law Enfor. Execu. Devel. Assoc. 2@ $50 60 60 75 75 Tri-County Investigator Association 45 45 45 45 Mn Crime Prevention Association 35 35 - - Mn DARE Officers Association 100 100 100 130 MN Emergency Managers Assoc. 400 420 420 420 Mn Police chiefs 129 129 129 129 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 140 200 200 Notary commission (3 year due in 2012)($120+$20) 630 630 630 630 POST license reimbursement 7 @ $90 30 30 30 30 Prof. Law Enforcement Admin. Assoc. 25 25 25 35 National Association of Town Watch 1,910 1,930 1,970 1,910 3630 Training 900 900 600 600 MN Chief's conference 200 200 200 200 BCA/CJDN training 320 320 320 320 Intox certification 1,000 1,000 1,000 1,000 Range Rental 300 300 - - Emergency Management Conference (reimbursed by HLS) 400 400 400 400 MN Sex Crimes Investigators Assoc Conference 3,000 3,000 3,000 3,000 Tuition reimbursement 1,200 1,200 1,200 1,200 Supervisor training 2,000 2,000 1,500 1,400 K9 training 600 600 600 600 Emergency Management training 2,000 2,000 1,700 1,700 Employee development courses - 1,615 1,615 1,615 Patrol on-line program 595 695 695 795 Post training for officers at Century College (1 officers) 12,515 14,230 12,830 12,830 4800 Insurance & bonds 18,500 25,000 25,000 25,000 Liability and automotive insurance - - 14,100 14,100 Insurance per MN Statute 299A.465 10,000 25,000 25,000 25,000 Allowance for insurance policy deductibles 28,500 50,000 64,100 64,100 5100 Technology - maintenance 2,000 2,000 2,000 2,000 Computer network & technology assistance - City of Roseville agreements & support 1,200 1,800 1,800 1,800 Copier maintenance + overages - 2,000 2,000 2,000 Automatic License plate reader maintenance - 2,720 - - E-ticketing annual maintenance fees - - - - Software interface fee w/LETG + CAD records mgt and comp aided disp. - - 3,840 3,840 Air cards for squad CAD (8) at $40 per month - - - 2,500 Milestone video maintenance and licenses - - - 2,428 NetMotion 2 factor authentication (state required) - - 12,500 12,500 IT support for squad computers (Roseville) 31,221 31,221 129,894 20,355 Operating costs of police records management system and ticket writer 34,421 39,741 152,034 47,423 5130 Repairs, equipment 3,000 3,000 3,000 3,000 Misc. equipment repair - defibs, cameras, recorders, fax, printers. 450 450 450 450 Fire extinguisher recharging 1,500 1,500 1,500 - Squad mobile digital computer repairs 500 1,000 1,000 1,000 Civil Defense siren repair & maint. (all 3 were replaced in 06,07,08) 2,500 4,350 4,350 4,000 Radio repair (one-time reprogramming fee $50) 1,999 1,400 1,440 1,440 800 MHZ radio licenses fees 38@ 3.12 per month 9,949 11,700 11,740 9,890 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) 20,000 - - - E-ticketing system for 7 squads 20,000 - 19,400 5,000 366,023 387,767 553,478 436,410 8.26%5.94%42.73%-21.15% 22 Y-T-D 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Fire (100 - 4210): Personnel services Total personnel services 13,596 5,532 - - - - - 0.00% Contractual services 3030 Fire inspection services - - 5,249 15,500 13,400 15,500 - 0.00% 3032 Contractual fire services 282,761 288,701 334,179 356,039 356,039 372,283 16,244 4.56% 3050 Dispatching 3,784 3,985 - 4,355 4,759 4,900 545 12.51% Total contractual services 286,545 292,686 339,428 375,894 374,198 392,683 16,789 4.47% Capital outlays: 7040 Vehicles & equipment 11,340 5,736 22,900 38,925 38,925 55,059 16,134 41.45% Total capital outlays 11,340 5,736 22,900 38,925 38,925 55,059 16,134 41.45% Debt Service: 8010 Principal 75,928 89,934 40,636 115,789 57,895 123,963 8,174 7.06% 8020 Interest 61,571 47,578 108,267 35,010 17,505 22,817 (12,193) -34.83% Total debt service 137,499 137,512 148,903 150,799 75,400 146,780 (4,019) -2.67% Total Fire 448,980 441,466 511,231 565,618 488,523 594,522 28,904 5.11% 2016 Budget Summary 23 Fund: 100 Department: 4210 Fire Account Description 2013 2014 2015 2016 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 291,418 334,179 356,039 372,283 Share of joint fire dept. costs (13 - 15.095%, 14 - 16.357%, 15 - 16.424) 291,418 334,179 356,039 372,283 3050 Dispatching 4,355 4,355 4,355 4,900 Anoka County dispatching fee 4,355 4,355 4,355 4,900 7040 Capital, vehicles & equipment 5,736 22,900 38,925 55,059 Share of joint fire department's capital costs 5,736 22,900 38,925 55,059 8010 Principal - 2005 Fire bond 53,676 60,521 63,232 73,251 16.099% of interest payment on 2013 refunding Fire bonds Principal - 2011 Equip Certs 46,872 50,707 52,557 50,712 16.099% of interest payment on 2011 Equipment Certificates 8020 Interest - 2005 Fire bond 35,125 35,792 33,629 22,081 16.099% of principal payment on 2013 refunding Fire bonds Interest - 2011 Equip Certs 2,068 1,883 1,381 736 16.099% of principal payment on 2011 Equipment Certificates 137,741 148,903 150,799 146,780 439,250 525,337 565,618 594,522 0.78%19.60%7.67%5.11% 24 Y-T-D 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Recreation (100 - 4350): Contractual services: 3036 Contractual recreation 94,350 100,335 98,467 110,900 111,289 112,713 1,813 1.63% 4800 Bonding & insurance 1,082 1,167 1,122 1,700 1,140 1,700 - 0.00% Total contractual services 95,432 101,502 99,589 112,600 112,429 114,413 1,813 1.61% Total Recreation 95,432 101,502 99,589 112,600 112,429 114,413 1,813 1.61% 2016 Budget Summary 25 Fund: 100 Department: 4350 Recreation Account Description 2013 2014 2015 2016 Description 3036 Contractual recreation 95,000 97,000 102,200 103,713 YMCA Mgt contract (39.5% of $262,563) 10,500 8,500 8,700 9,000 Ice Skating supervision 105,500 105,500 110,900 112,713 4800 Bonding & insurance 1,700 1,700 1,700 1,700 Insurance & bonding cost. 1,700 1,700 1,700 1,700 107,200 107,200 112,600 114,413 0.00%0.00%5.04%1.61% 26 Y-T-D 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent 2016 Budget Summary Parks (100 - 4360): Personnel services 0100 Salaries, regular 118,173 129,794 99,541 111,983 103,804 120,346 8,363 7.47% 0110 Overtime, regular 4,490 7,256 6,498 4,567 7,940 4,923 356 7.80% 0150 Salaries, part-time 34,227 27,376 35,701 33,180 29,260 33,180 - 0.00% 0300 Social Security 11,334 11,334 10,335 11,455 10,281 12,122 667 5.82% 0321 PERA 8,785 8,727 7,697 8,742 8,335 9,396 654 7.48% 0400 Group insurance 20,630 12,769 17,532 22,842 19,143 23,455 613 2.68% 0500 Workers compensation 4,588 5,007 7,274 7,516 9,129 10,714 3,198 42.55% 0600 Unemployment - 1,474 2,701 - 1,739 - - 0.00% Total personnel services 202,227 203,737 187,279 200,285 189,631 214,136 13,851 6.92% Materials & supplies: 1210 Supplies, bldgs & grnds 7,479 8,125 7,777 12,850 6,192 10,600 (2,250) -17.51% 1220 Supplies, vehicles & mowers 14,129 9,192 8,565 10,000 2,894 10,000 - 0.00% 1230 Supplies, equipment 2,502 3,094 9,803 4,250 6,682 6,250 2,000 47.06% 1600 Supplies, operating 11,495 8,229 8,131 9,500 11,068 10,000 500 5.26% 1700 Motor fuels & lubs 11,065 13,007 14,337 7,650 9,383 7,650 - 0.00% 2400 Uniforms & clothing 1,182 812 963 1,370 910 1,370 - 0.00% 2410 Mats & towels 887 338 479 910 549 728 (182) -20.00% Total materials & supplies 48,739 42,797 50,055 46,530 37,678 46,598 68 0.15% Contractual services: 3030 Other professional services 7,705 5,681 8,168 10,300 9,744 10,300 - 0.00% 3100 Telephone 1,419 1,492 1,272 1,835 1,386 2,056 221 12.04% 3200 Water & sewer 6,510 5,798 6,401 7,000 5,396 7,000 - 0.00% 3210 Electricity 7,432 9,909 9,689 7,200 8,794 7,200 - 0.00% 3220 Natural gas 3,589 6,031 9,121 4,800 3,876 4,800 - 0.00% 3610 Memberships 30 - 65 150 - 90 (60) -40.00% 3630 Training & conferences 800 334 740 1,470 404 1,670 200 13.61% 3900 Grants & subsidies 23,108 10,608 10,608 11,500 11,500 11,500 - 0.00% 4010 Rental, equipment 222 - 1,260 500 1,096 2,900 2,400 480.00% 4030 Portable restrooms 4,851 4,221 5,642 4,850 4,884 4,850 - 0.00% 4800 Bonding & insurance 10,186 10,984 12,010 16,000 10,729 16,000 - 0.00% 5110 Repairs, bldg & grounds 2,956 4,019 5,229 6,750 1,940 15,500 8,750 129.63% Total contractual services 68,808 59,077 70,205 72,355 59,749 83,866 11,511 15.91% Capital outlays 7030 Equipment - 8,016 6,145 - 15,536 - - 0.00% Total capital outlays - 8,016 6,145 - 15,536 - - 0.00% Total Parks 319,774 313,627 313,684 319,170 302,594 344,600 25,430 7.97% 118,885 130,464 27 Fund: 100 Department: 4360 Parks Account Description 2013 2014 2015 2016 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 County 10 trailway landscaping mulch, shrubs, and plants 400 400 500 500 Janitorial supplies 150 150 150 150 Snow shovels 210 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 150 300 300 Graffiti remover 500 500 500 250 Goose repellent 2,000 2,500 2,500 2,000 Replace irrigation heads 2,500 2,500 2,500 2,000 Seed, fertilizer 9,110 12,600 12,850 10,600 1220 Supplies, vehicles 6,500 7,000 7,000 7,000 Oil filters, mower blades, tires, vehicle registration fees, - 3,500 - - Lift gate #428 1,500 2,500 3,000 3,000 Miscellaneous repairs 8,000 13,000 10,000 10,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 500 1,000 1,000 Bases, jox boxes, etc. - - - 2,000 Drag for ball fields 2,500 2,500 2,500 2,500 Replace park equipment, fixtures and misc parts 3,750 3,750 4,250 6,250 1600 Supplies, operating 1,500 2,000 2,000 2,000 Fiber fill for play lots & courts 200 200 200 200 Tri mix 1,200 1,700 1,700 2,000 Wood chips for trees 500 500 500 500 Ag-lime for fields 500 500 500 500 Surface drying compound 400 400 400 400 Nets 2,700 2,900 2,900 3,100 Field paint & chalk (partially reimb by school district) 800 800 800 800 Landscaping materials - 500 500 500 Hand tools 7,800 9,500 9,500 10,000 1700 Motor fuels & lubes 7,200 7,200 4,500 4,500 1,500 gallons of unleaded gas @ $2.75 4,050 4,050 3,150 3,150 900 gallons of diesel fuel @ $3.50 11,250 11,250 7,650 7,650 2400 Uniforms & clothing 175 175 350 350 Clothing allowance 2.0 FTE 600 600 820 820 Uniforms 18.2% of $4,500 200 200 200 200 Safety glasses, masks, ear protection, etc. 975 975 1,370 1,370 2410 Mats & towels 850 850 910 728 Share of floor mats and shop towels 18.2% of $4,000 850 850 910 728 3030 Other professional services 240 240 240 240 Fire extinguisher inspection/maint. (2@ $120) 600 600 600 600 HVAC maintenance 840 840 840 840 Fire sprinkler testing (4@ $210) 120 120 120 120 Backflow prevention testing (2@ $60) 4,500 4,500 8,500 8,500 Broadleaf control 6,300 6,300 10,300 10,300 28 THIS PAGE LEFT BLANK INTENTIONALLY 29 Fund: 100 Department: 4360 Parks (continued) Account Description 2013 2014 2015 2016 Description 3100 Telephone 1,490 1,400 985 1,206 Cellular phones (13.1% of $7,500)($9,200) - - 850 850 GPS units for mowers (split with 4472) 300 - - - Security at Silver View (phones removed from park buildings) 1,790 1,400 1,835 2,056 3200 Water & wastewater 6,000 7,000 7,000 7,000 Parkland irrigation & park bathrooms 6,000 7,000 7,000 7,000 3210 Electricity 6,000 7,200 7,200 7,200 Est. 5 park buildings, park sec. lighting, court & field lighting & misc. 6,000 7,200 7,200 7,200 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 30 60 - Pesticide license renewal (every 2 years) - - - - State low voltage electrical licenses 100 100 - - Tree inspector license (moved to 4380) 220 220 150 90 3630 Training & conferences 75 75 75 75 Computer classes 100 100 100 100 Hearing tests/RTN training (2@$50) - - - - Low voltage/power limited training 60 60 60 60 Maintenance EXPO 110 110 110 110 Loss control workshops 100 750 750 750 Playground inspection training (Certified Playground Safety Inspector CPSI) 210 210 375 375 Equipment training (18.2% of $2,050) - 200 - 200 Pesticide application class (every 2 years) - 30 - - Pesticide license renewal (every 2 years)(in 3610) 85 150 - - Tree inspector training (moved to 4380) 740 1,685 1,470 1,670 3900 Grants & subsidies 10,608 10,608 11,500 11,500 Lakeside Park share of operating costs 10,608 10,608 11,500 11,500 4010 Rental, equipment 350 350 500 2,900 Tools and equipment (sod cutter, chipper, concrete mixer, etc...) 350 350 500 2,900 4030 Portable restrooms 3,000 4,850 4,850 4,850 For May thru Oct, plus special events such as tournaments, & extra cleanings and insurance 3,000 4,850 4,850 4,850 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 500 750 750 750 Windows, doors, & lock repairs - 3,500 1,000 1,000 Building exterior repairs - 5,000 1,500 7,750 Irrigation system repairs (Silver View Park irrigation vault $6,250) 500 1,000 1,000 1,000 Field light repairs - - - 2,500 Repairs to playground equipment 2,500 2,500 2,500 2,500 Repairs to furnaces, plumbing, phones, electrical, etc 3,500 12,750 6,750 15,500 7030 Capital, equipment > $5000 8,000 8,000 - - Utility cart - 6,350 - - Plow for unit #428 8,000 14,350 - - 109,043 139,438 118,885 130,464 7.16%27.87%-14.74%9.74% 30 Y-T-D 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent 2016 Budget Summary Forestry (100 - 4380): Personnel services 0100 Salaries, regular - - - 2,801 2,494 2,857 56 2.00% 0110 Overtime, regular - - - - 106 - - 0.00% 0300 Social Security - - - 214 178 219 5 2.34% 0321 PERA - - - 210 195 214 4 1.90% 0400 Group insurance - - - 594 481 606 12 2.02% 0500 Workers compensation - - - 138 168 193 55 39.86% Total personnel services - - - 3,957 3,622 4,089 132 3.34% 0.00% Materials & supplies 1200 Supplies, landscaping 705 395 3,018 10,900 1,944 8,900 (2,000) -18.35% Total materials & supplies 705 395 3,018 10,900 1,944 8,900 (2,000) -18.35% Contractual services 3030 Professional services 35,102 3,349 2,909 36,500 1,577 21,500 (15,000) -41.10% 3520 Tree removal 17,950 - 11,437 35,500 11,735 32,500 (3,000) -8.45% 3630 Training & conferences - - 15 400 170 900 500 Total contractual services 53,052 3,349 14,361 72,400 13,482 54,900 (17,500) -24.17% Total Forestry 53,757 3,744 17,379 87,257 19,048 67,889 (19,368) -22.20% 83,300 63,800 31 Fund: 100 Department: 4380 Forestry Account Description 2013 2014 2015 2016 Description 1200 Supplies, landscaping 400 400 400 400 Landscaping materials 800 800 1,000 1,000 Small trees to replace damaged trees 1,800 1,800 2,000 2,000 Large trees - storm damage replacement 7,500 7,500 5,000 5,000 Ash tree replacement trees (MN DNR grant) 2,500 2,500 2,500 500 EAB treatment supplies 13,000 13,000 10,900 8,900 3030 Professional services 9,000 10,000 10,000 5,000 Tree trimming - - 500 500 Asset mgt. software 15,000 25,000 25,000 15,000 Forestry consulting - 7,500 1,000 1,000 Tree injections (Ash every 2 years) 24,000 42,500 36,500 21,500 3520 Tree removal 28,000 28,000 28,000 25,000 Remove or treat diseased trees 13,500 13,500 7,500 7,500 Ash tree removal (MN DNR grant) 41,500 41,500 35,500 32,500 3630 Training & memberships - - 300 800 Tree Inspector training - - 100 100 Tree Inspector license - - 400 900 78,500 97,000 83,300 63,800 42.73%23.57%-14.12%-23.41% 32 Y-T-D 2012 2012 2014 2015 11/30/2015 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Public Works Administration (100-4410): Personnel services: 0100 Salaries, regular 95,452 98,079 107,821 105,282 75,358 100,621 (4,661) -4.43% 0110 Salaries, overtime - - 141 - - - - 0.00% 0300 Social Security 6,802 7,037 7,782 8,054 5,045 7,697 (357) -4.43% 0321 PERA 6,870 7,042 7,753 7,896 5,014 7,547 (349) -4.42% 0400 Group insurance 11,653 12,155 13,202 15,390 10,231 15,716 326 2.12% 0500 Workers compensation 1,006 1,134 1,839 1,552 1,885 1,462 (90) -5.80% Total personnel services 121,783 125,447 138,538 138,174 97,533 133,043 (5,131) -3.71% Materials & supplies: 1230 Supplies, equipment - - 130 - - - - 0.00% 1600 Operating supplies 223 104 297 300 300 300 - 0.00% 2400 Uniforms & clothing 283 888 - 400 56 400 - 0.00% Total materials and supplies 506 992 427 700 356 700 - 0.00% Contractual services: 3030 Other professional services 320 842 524 900 337 900 - 0.00% 3100 Telephone 677 895 636 630 527 773 143 22.70% 3610 Memberships 604 433 632 530 430 730 200 37.74% 3630 Training & conferences 300 753 490 895 600 1,895 1,000 111.73% 3800 Mileage reimbursement 315 338 290 300 203 300 - 0.00% Total contractual services 2,216 3,261 2,572 3,255 2,097 4,598 1,343 41.26% Capital outlays: 7030 Equipment - - - - - - - 0.00% Total capital outlays - - - - - - - 0.00% Total public works administration 124,505 129,700 141,537 142,129 99,986 138,341 (3,788) -2.67% 3,955 5,298 2016 Budget Summary 33 Fund: 100 Department: 4410 Public Works Adminstration Account Description 2013 2014 2015 2016 Description 1600 Operating Supplies 200 200 230 230 Office supplies - - 70 70 National Public Works Week posters (2017?) 200 200 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 Asset mgt software 240 300 300 300 Drug & alcohol testing - federal mandate 340 400 900 900 3100 Telephone 720 680 630 773 Cellphone 8.4% of $7,500 ($9,200) 720 680 630 773 3610 Memberships/license fee 150 180 190 375 American Public Works Association memb. (APWA) (1/2 of $750) 60 60 60 60 City Engineer's Association of MN (CEAM) 40 40 - - NASASP (National Assoc. of State Agencies for Surplus Property) 30 30 30 30 MN Safety Council 200 250 - 265 MN Board of AELSLAGID (PE Renewal even years) 230 230 250 - American Society of Civil Engineers 710 790 530 730 3630 Training & conferences 500 500 500 1,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 895 1,895 3800 Mileage reimbursement 300 400 300 300 vehicle mileage reimbursement 300 400 300 300 3,565 3,765 3,955 5,298 -2.73%5.61%5.05%33.96% 34 Y-T-D 2012 2012 2014 2015 11/30/2015 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent 2016 Budget Summary Building & Grounds Maintenance (100 - 4460): Personnel services: 0100 Salaries, regular 11,983 12,039 12,389 13,523 12,240 13,795 272 2.01% 0110 Salaries, overtime 38 312 626 1,002 382 1,023 21 2.10% 0300 Social Security 854 888 946 1,112 935 1,133 21 1.89% 0321 PERA 863 886 934 1,090 937 1,112 22 2.02% 0400 Group insurance 2,739 2,864 2,943 2,754 2,216 2,815 61 2.21% 0500 Workers compensation 366 400 641 949 1,153 996 47 4.95% Total personnel services 16,843 17,389 18,479 20,430 17,863 20,874 444 2.17% Materials & supplies: 1210 Supplies, building & grounds 1,976 1,988 2,283 2,000 1,774 2,000 - 0.00% 1220 Supplies, vehicles 105 - - - - - - 0.00% 1230 Supplies, equipment 546 264 825 1,300 60 1,300 - 0.00% 1600 Supplies, operating 2,573 3,389 2,534 4,350 3,051 4,300 (50) -1.15% 1700 Motor fuels & lubricants - 1,543 - - - - - 0.00% 2400 Uniforms & clothing 205 113 103 117 74 117 - 0.00% 2410 Mats & towels 222 85 925 630 655 630 - 0.00% Total materials & supplies 5,627 7,382 6,670 8,397 5,614 8,347 (50) -0.60% Contractual services: 3030 Other professional services 28,643 27,273 18,737 30,140 24,949 31,660 1,520 5.04% 3100 Telephone 121 124 112 120 81 129 9 7.50% 3200 Water & sewer 1,375 1,000 807 1,400 649 1,400 - 0.00% 3210 Electricity 26,159 29,788 28,341 28,000 23,887 14,000 (14,000) -50.00% 3220 Natural gas 15,445 21,912 26,488 20,000 14,808 20,000 - 0.00% 3530 Refuse collection 9,673 7,912 7,806 11,005 6,354 9,334 (1,671) -15.18% 3610 Memberships - - 10 - - - - 0.00% 3630 Training & conferences - 9 19 - 10 - - 0.00% 4010 Rental, equipment 118 - - 200 - 200 - 0.00% 4800 Insurance 4,457 4,805 4,621 7,000 4,694 7,000 - 0.00% 5110 Repairs, bldgs & grounds 19,628 14,470 10,208 11,100 16,941 11,100 - 0.00% 5130 Repairs, equipment 3,647 4,961 4,409 5,000 2,179 5,000 - 0.00% Total contractual services 109,266 112,254 101,558 113,965 94,552 99,823 (14,142) -12.41% 122,362 108,170 Capital outlays 7030 Equipment - - - - 0.00% Total capital outlays - - - - - - - 0.00% Total buildings & grounds 131,736 137,025 126,707 142,792 118,029 129,044 (13,748) -9.63% 35 Fund: 100 Department: 4460 Building & Ground Maintenance Account Description 2013 2014 2015 2016 Description 1210 Supplies, bldgs & grounds 1,500 2,000 2,000 2,000 Bldg repairs, cleaning/heating supplies, batteries 1,500 2,000 2,000 2,000 1230 Supplies, equipment < $5000 690 1,300 1,300 1,300 Repair parts, filters, hoses, etc., office furniture - - - - Pressure washer repair parts, garage door motor 690 1,300 1,300 1,300 1600 Supplies, operating 500 500 500 1,500 Cleaning supplies 300 300 300 150 Lumber & fasteners 550 550 550 300 Repair items & hardware 300 300 300 100 First aid supplies 500 500 500 200 Light bulbs & ballasts 500 500 500 750 Paper supplies 500 500 500 400 Mechanical items, fans, motors, etc 250 100 100 - Goose repellent 200 200 200 - Weed control - city hall 200 200 200 200 Office supplies 700 700 700 700 Paint & supplies - parking lot & building 4,500 4,350 4,350 4,300 2400 Uniforms & clothing 150 150 81 81 Uniforms (1.8% of $4,500) 45 45 36 36 Clothing & boot allowance (.20 @$175) 195 195 117 117 2410 Mats & towels 210 210 90 90 Share of floor mats and shop towels (1.8% of $5,000) - - 540 540 Floor mats at CH ($45/month) 210 210 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 3,250 5,500 5,520 HVAC maintenance (City Hall & PW facilities) 100 100 100 100 MN DOL operating permit - elevator (previously in acct. 5110) 15,300 15,300 18,000 19,500 City Hall cleaning contract (renews in 2016) 3,500 3,500 3,500 3,500 Carpet cleaning, floor striping & waxing (2 times) 210 680 680 680 Fire sprinkler testing 1,320 1,320 1,320 1,320 Pest control (12@$110) - 200 200 200 MDH Monitoring well maint. permit - PW bldg. 600 600 600 600 Fire extingiusher inspection/service (30@$20) 24,520 25,190 30,140 31,660 3100 Telephone 130 120 120 129 Cellphone (1.6% of $7,500)($9,200) 130 120 120 129 3200 Water & Sewer 1,800 1,500 1,400 1,400 Service at City Hall and Public Works buildings 1,800 1,500 1,400 1,400 3210 Electricity 25,000 26,000 28,000 14,000 Electricity at City Hall and Public Works buildings 25,000 26,000 28,000 14,000 3220 Natural gas 20,000 19,000 20,000 20,000 Natural gas at City Hall and Public Works buildings 20,000 19,000 20,000 20,000 3530 Refuse collection 130 130 130 130 Lamps $100, batteries $30 264 264 264 264 Hazardous waste annual fee (State of MN PCA) 230 230 230 90 Hazardous waste generator license fee (Ramsey County) 150 150 150 150 Used oil filters ($100 in vehicle maint.) 9,200 7,200 7,200 7,200 Facility dumpsters, city hall, public works 1,031 3,031 3,031 1,500 Hazardous waste disposal 11,005 11,005 11,005 9,334 4010 Rental, equipment 205 205 200 200 Misc. rentals 205 205 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 1,300 2,500 2,500 2,500 Door & gate opener repairs 2,100 2,500 2,500 2,500 Building repairs 575 750 750 750 Elevator maintenance & repairs 350 350 350 350 Fire sprinklers & alarm repairs 4,000 5,000 5,000 5,000 General building & ground maintenance 8,325 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 7030 Capital, equipment > $5000 - - - - Walk behind broom (1/2 bldg. 1/2 MVCC) 5,100 - - - 800 amp panelboard (city hall) 5,100 - - - 115,180 114,175 122,362 108,170 2.72%-0.87%7.17%-11.60% 36 Y-T-D 2012 2012 2014 2015 11/30/2015 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent 2016 Budget Summary Vehicle & Equipment Maintenance (100 - 4465): Personnel services: 0100 Salaries, regular 30,681 31,133 33,251 37,200 33,358 37,947 747 2.01% 0110 Salaries, overtime 1,056 1,038 1,110 565 - 577 12 2.12% 0300 Social Security 2,349 2,330 2,492 2,889 2,426 2,946 57 1.97% 0321 PERA 2,308 2,332 2,490 2,832 2,490 2,889 57 2.01% 0400 Group insurance 4,792 5,289 5,565 6,858 5,212 7,087 229 3.34% 0500 Workers compensation 892 976 1,628 2,048 2,488 1,983 (65) -3.17% Total personnel services 42,078 43,098 46,536 52,392 45,974 53,429 1,037 1.98% Materials & supplies: 1220 Supplies, vehicles 21,130 14,200 16,616 19,950 8,054 19,950 - 0.00% 1230 Supplies, equipment 1,657 970 4,752 9,800 4,627 9,800 - 0.00% 1600 Supplies, operating 3,695 4,791 3,771 4,200 5,175 4,200 - 0.00% 1700 Motor fuels & lubricants - unleade 2,721 2,630 4,051 3,260 2,074 3,260 - 0.00% 1701 Motor fuels & lubricants - diesel - - 7,663 - 4,071 - - 0.00% 2400 Uniforms & clothing 439 729 414 354 837 354 - 0.00% 2410 Mats & towels 523 203 180 275 167 220 (55) -20.00% Total materials & supplies 30,165 23,523 37,447 37,839 25,005 37,784 (55) -0.15% Contractual services: 3030 Other professional services - 19 18 - 17 - 0.00% 3100 Telephone 282 262 263 308 191 387 79 25.65% 3530 Refuse collection 86 - - 100 - 100 - 0.00% 3610 Memberships - 258 606 80 - 80 - 0.00% 3630 Training 196 58 283 510 54 625 115 22.55% 4010 Rental, equipment - - - 100 - 100 - 0.00% 5120 Repairs, vehicles 18,245 18,414 19,894 16,550 6,102 16,800 250 1.51% 5130 Repairs, equipment 2,746 4,174 4,914 5,500 5,805 5,500 - 0.00% Total contractual services 21,555 23,185 25,978 23,148 12,169 23,592 444 1.92% Capital outlays 7030 Equipment - - 6,050 - - - - 0.00% Total capital outlays - - 6,050 - - - - 0.00% Total vehicle & equipment maintenance 93,798 89,806 116,011 113,379 83,148 114,805 1,426 1.26% 60,987 61,376 37 Fund: 100 Department: 4465 Vehicle & Equipment Maintenance Account Description 2013 2014 2015 2016 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 300 500 500 500 Headlamps, spots, & bulbs 800 800 800 800 Tune up items 400 500 500 500 Wiper blades & fluid 1,550 1,950 1,950 1,950 Minor repairs, rebuilds 1,100 1,500 1,500 1,500 Automotive parts 1,500 2,000 2,000 2,000 Filters: oil, air, fuel, transmission 1,500 2,000 2,000 2,000 Brake pads & shoes 7,500 8,000 9,000 9,000 Tires & batteries 16,350 18,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 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 1,000 2,000 2,000 Tires 2,600 5,000 9,800 9,800 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 License tabs 500 500 500 500 Solvents & degreasers 500 500 500 500 Fastners & electrical supplies 3,850 4,200 4,200 4,200 1700 Motor fuels & lubricants 60 60 60 60 Gear lube 200 200 200 200 ATF - 7 cases 200 375 500 500 Aftermarket additives 2,000 2,500 2,500 2,500 Engine oil: 150 gallons (synthetic) 2,460 3,135 3,260 3,260 2400 Uniforms & clothing 360 360 249 249 Uniforms 6% of $6,000) 105 105 105 105 Clothing and boot allowance (.6@$175) 465 465 354 354 2410 Mats & towels 510 510 275 220 Share of floor mats and shop towels (5.5% of $4,000) 510 510 275 220 3100 Communications 300 280 308 387 Cellular telephone (4.1% of $7,500)($9,200) 300 280 308 387 3530 Refuse collection 100 100 100 100 Oil filter recycling 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) 120 120 - - Equipment operation training (Skidsteer & boom) 30 30 30 30 Maintenance Expo 200 200 200 200 Misc training 175 175 175 175 ASE certification 75 75 75 190 Vehicle inspection recertification (DOT required) 630 630 510 625 4010 Rental, equipment 100 100 100 100 Specialty tool & equipment rental and mileage reimbursement 100 100 100 100 5120 Repairs, vehicles 4,500 6,000 8,000 8,000 Accident repairs 400 750 750 750 Alignments 1,000 1,000 1,000 1,000 Glass replacement 400 400 400 400 Radiator repairs, replacement 1,000 2,000 2,000 2,000 Tire repairs 700 700 700 950 Ignition scanner software update 1,700 1,700 1,700 1,700 Mitchell On Demand Software 2,000 2,000 2,000 2,000 Transmission repairs 11,700 14,550 16,550 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 6,000 - - Hoist adaptor 6,000 6,000 - - 50,645 59,500 60,987 61,376 20.10%17.48%2.50%0.64% 38 Y-T-D 2012 2012 2014 2015 11/30/2015 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent 2016 Budget Summary Street Pavement Management (100 - 4470): Personnel services: 0100 Salaries, regular 94,686 96,757 102,349 111,981 101,261 113,381 1,400 1.25% 0110 Salaries, overtime 3,073 3,494 3,470 3,231 2,844 3,296 65 2.01% 0150 Salaries, part-time 10,029 6,139 5,910 7,488 5,452 7,488 - 0.00% 0300 Social Security 7,969 7,861 8,253 9,387 7,944 9,498 111 1.18% 0321 PERA 6,984 7,147 7,527 8,640 7,378 8,751 111 1.28% 0400 Group insurance 11,025 11,816 11,703 16,794 12,716 17,338 544 3.24% 0500 Workers compensation 4,277 4,692 7,123 8,671 10,532 10,056 1,385 15.97% 0990 Severence pay - - - - - - 0.00% Total personnel services 138,043 137,906 146,335 166,192 148,127 169,808 3,616 2.18% Materials & supplies: 1230 Supplies, equipment 1,300 8,648 5,712 500 469 500 - 0.00% 1240 Supplies, streets 23,366 11,391 25,299 22,500 5,411 22,500 - 0.00% 1260 Supplies, traffic control 1,870 888 429 1,000 - 1,000 - 0.00% 1600 Supplies, operating 2,486 2,911 2,815 750 1,342 750 - 0.00% 1700 Motor fuels & lubricants 10,239 8,140 9,515 9,750 5,773 9,375 (375) -3.85% 2400 Uniforms & clothing 861 885 917 701 693 701 - 0.00% 2410 Mats & towels 872 338 351 545 358 436 (109) -20.00% Total materials & supplies 40,994 33,201 45,038 35,746 14,046 35,262 (484) -1.35% Contractual services: 3030 Other professional services 9,161 8,136 5,279 8,800 11,288 8,950 150 1.70% 3100 Telephone 863 806 756 893 537 966 73 8.17% 3610 Memberships 169 177 247 230 190 245 15 6.52% 3630 Training & conferences 1,001 767 583 1,415 251 1,115 (300) -21.20% 4010 Rental, equipment 2,778 2,840 1,125 3,500 2,000 5,300 1,800 51.43% 4800 Insurance 4,437 4,256 6,261 6,200 4,157 6,200 - 0.00% 5130 Repairs, equipment 132 13 - 5,500 10 500 (5,000) -90.91% Total contractual supplies 18,541 16,995 14,251 26,538 18,433 23,276 (3,262) -12.29% Capital outlays 7030 Equipment - - - - - - - 0.00% Total capital outlays - - - - - - - 0.00% Total street pavement management 197,578 188,102 205,624 228,476 180,606 228,346 (130) -0.06% 62,284 58,538 39 Fund: 100 Department: 4470 Pavement Management Account Description 2013 2014 2015 2016 Description 1230 Supplies, equipment < $5000 500 500 500 500 Safety vest, hearing protection, safety protection 4,500 - - - Radial arm saw 5,000 4,000 - - Rear cameras for plow trucks 10,000 4,500 500 500 1240 Supplies, street repair 20,000 20,000 20,000 20,000 Asphalt & concrete for street patching & curb repair 500 1,000 1,000 1,000 Disposal 1,200 1,500 1,500 1,500 Bituminous tack coat/crack fill material 21,700 22,500 22,500 22,500 1260 Supplies, traffic control 400 400 400 400 Traffic cones/baracades 100 100 600 600 portable signs (traffic control) 500 500 1,000 1,000 1600 Supplies, operating 380 650 650 650 Asphalt hand tools, rakes, etc. 1,300 1,750 - - Traffic marking paint (crosswalks)(move to 4475) - 100 100 100 Batteries, shop supplies, etc. 1,680 2,500 750 750 1700 Motor fuels & lubricants 6,750 6,750 5,250 5,250 Diesel fuel: 1500 gallons @ $3.50. 5,200 5,200 4,500 4,125 Unleaded fuel: 1500 gallons @ $2.75 11,950 11,950 9,750 9,375 2400 Uniforms & clothing 600 600 491 491 Uniforms (10.9% of $4,500) 175 175 210 210 Clothing and boot allowance (1.2@$175) 775 775 701 701 2410 Mats & towels 850 850 545 436 Share of floor mats and shop towels (10.9% of $4,000) 850 850 545 436 3030 Other professional services 1,800 1,800 1,800 1,800 Pavement Mgmt software annual maintenance. 1,000 2,500 2,500 2,500 Engineering services. - - - - Annual certification of weight scales - - 500 500 Asset management software annual maintenance - - 500 650 ROW weed control - - 1,500 1,500 Material dump charges 2,000 2,000 2,000 2,000 Sidewalk joint corrections 3,500 4,500 - - Striping of streets (Ramsey County)(move to 4475) 8,300 10,800 8,800 8,950 3100 Communications 890 840 893 966 Cellular telephones (10.5% of $8,000)($9,200) 890 840 893 966 3610 Memberships 150 180 190 190 American Public Works Association memb. (APWA) (1/4 of $720) 20 20 - 15 Pesticide license renewal (TF) 40 40 40 40 MN Safety Council 210 240 230 245 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 125 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,090 1,615 1,415 1,115 4010 Rentals, equipment 3,800 2,800 2,800 2,800 Annual trade-in of skidsteer loaders 1,200 1,200 700 2,500 Specialized equip rental (chipper, crack sealing) 5,000 4,000 3,500 5,300 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 500 5,500 500 7030 Equipment > $5000 - - - - Crack router 5,200 - - - Tack coat applicator system 5,200 - - - 74,845 67,770 62,284 58,538 26.22%-9.45%-8.10%-6.01% 40 Y-T-D 2012 2012 2014 2015 11/30/2015 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent 2016 Budget Summary Street Snow & Ice Control (100 - 4472): Personnel services: 0100 Salaries, regular 57,623 57,539 62,998 57,597 53,673 58,753 1,156 2.01% 0110 Salaries, overtime 6,838 11,296 19,281 7,775 4,796 7,932 157 2.02% 0300 Social Security 4,725 5,054 5,944 5,001 4,271 5,102 101 2.02% 0321 PERA 4,562 4,922 5,855 4,903 4,289 5,002 99 2.02% 0400 Group insurance 9,312 9,623 11,550 10,800 7,248 11,160 360 3.33% 0500 Workers compensation 3,700 4,044 6,116 6,647 8,074 7,865 1,218 18.32% Total personnel services 86,760 92,478 111,744 92,723 82,351 95,814 3,091 3.33% Materials & supplies: 1230 Supplies, equipment 874 6,346 19,758 2,050 1,081 2,050 - 0.00% 1600 Supplies, operating 19,743 32,382 41,589 31,050 23,580 31,175 125 0.40% 1700 Motor fuels & lubricants 4,659 5,428 13,786 3,680 1,786 3,680 - 0.00% 2400 Uniforms & clothing 779 542 457 528 322 528 - 0.00% 2410 Mats & towels 950 366 331 410 308 328 (82) -20.00% Total materials & supplies 27,005 45,064 75,921 37,718 27,077 37,761 43 0.11% Contractual services: 3030 Other professional services - 1,248 1,592 1,200 1,321 1,200 - 0.00% 3100 Telephone and data cards 528 507 753 833 1,077 2,259 1,426 171.19% 3610 Memberships - - 70 70 - 70 - 0.00% 3630 Training & conferences 55 107 84 475 118 475 - 0.00% 5130 Repairs, equipment 1,580 3,390 3,373 2,500 - 2,500 - 0.00% Total contractual supplies 2,163 5,252 5,872 5,078 2,516 6,504 1,426 28.08% Capital outlays 7030 Equipment - - 2,618 13,950 3,588 - (13,950) -100.00% Total capital outlays - - 2,618 13,950 3,588 - (13,950) -100.00% Total streets snow & ice control 115,928 142,794 196,155 149,469 115,532 140,079 (9,390) -6.28% 56,746 44,265 41 Fund: 100 Department: 4472 Snow & Ice Control Account Description 2013 2014 2015 2016 Description 1230 Supplies, equipment < $5000 250 250 250 250 Filters 450 - - - Broom for Bobcat 750 - - - Skidsteer snow bucket - 4,500 - - Skidsteer broom motor mechanism - 4,850 - - Snow blower for skid steer - 2,900 - - V plow skid steer 1,800 1,800 1,800 1,800 Cutting edges, plow shoes 3,250 14,300 2,050 2,050 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. 24,000 28,000 28,000 28,125 Salt: 375 tons @ $75 per ton. 27,050 31,050 31,050 31,175 1700 Motor fuels & lubricants 180 180 180 180 Engine oil: 30 gallons @ $6.00 per gallon. 4,500 4,500 3,500 3,500 Diesel fuel: 1,000 gallons @ $3.50 per gallon. 4,680 4,680 3,680 3,680 2400 Uniforms & clothing 660 660 370 370 Uniforms (8.2% of $4,500) 195 195 158 158 Clothes & boots allowance (.9@$175) 855 855 528 528 2410 Mats & towels 940 940 410 328 Cost share of mats & towels (8.2% of $4,000) 940 940 410 328 3030 Other professional services 700 1,200 1,200 1,200 Weather service reports 700 1,200 1,200 1,200 3100 Telephone 550 520 473 579 Cellphone (6.3% of $7,500)($9,200) - 360 360 1,680 GPS data cards 550 880 833 2,259 3610 Memberships 150 150 - - American Public Works Association memb. (APWA) (1/4 of $750) 40 40 70 70 Minnesota Safety Council 190 190 70 70 3630 Training 55 55 75 75 Hearing tests/RTN training (1.1@$50) - - 400 400 Defensive Driving class (2 staff) 55 55 475 475 5130 Repairs, equipment 1,000 1,000 2,500 2,500 Plow, blower, salt spreader repairs, paint plow assemblies 1,000 1,000 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 - 39,270 63,500 56,746 44,265 1.95%61.70%-10.64%-21.99% 42 Y-T-D 2012 2012 2014 2015 11/30/2015 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent 2016 Budget Summary Street Sign Maintenance (100 - 4475): Personnel services: 0100 Salaries, regular 21,083 20,863 23,579 17,615 16,276 18,096 481 2.73% 0110 Salaries, overtime 1,150 1,646 450 808 600 824 16 1.98% 0150 Salaries, part-time - - - 2,496 - 2,496 - 0.00% 0300 Social Security 1,668 1,685 1,787 1,601 1,240 1,638 37 2.31% 0321 PERA 1,580 1,597 1,696 1,382 1,240 1,419 37 2.68% 0400 Group insurance 2,540 2,761 2,698 3,078 2,316 3,181 103 3.35% 0500 Workers compensation 1,328 1,453 2,188 1,619 1,967 1,878 259 16.00% Total personnel services 29,349 30,005 32,398 28,599 23,639 29,532 933 3.26% Materials & supplies: 1600 Supplies, operating 2,988 2,465 1,590 27,750 3,474 28,500 750 2.70% 2400 Uniforms & clothing 276 199 165 435 116 435 - 0.00% 2410 Mats & towels 358 135 119 340 110 160 (180) -52.94% Total materials & supplies 3,622 2,799 1,874 28,525 3,700 29,095 570 2.00% Contractual services: 3030 Other professional services - - - 5,500 11 5,500 - 0.00% 3100 Telephone 193 175 180 200 130 230 30 15.00% 3250 Electricity - traffic signals 1,865 5,531 2,569 2,000 2,425 2,000 - 0.00% 3630 Training & conferences 20 53 30 100 16 100 - 0.00% 5130 Repairs, equipment 307 298 291 500 - 500 - 0.00% Total contractual supplies 2,385 6,057 3,070 8,300 2,582 8,330 30 0.36% Capital outlays 7030 Equipment - - - - - - - 0.00% Total capital outlays - - - - - - - 0.00% Total street sign maintenance 35,356 38,861 37,342 65,424 29,921 66,957 1,533 2.34% 43 Fund: 100 Department: 4475 Street Sign Maintenance 1600 Supplies, operating 5,000 5,000 17,500 17,500 Signs, posts, sign hardware, and supplies - - 7,500 7,500 Street name sign panels, posts, hardware - - 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 (3) Traffic counters 6,000 6,000 27,750 28,500 2400 Uniforms & clothing 240 240 81 81 Uniforms (1.8% of $4,500) 70 70 354 354 Clothes and boot allowance (.2@$175) 310 310 435 435 2410 Mats & towels 340 340 340 160 Cost share of mats & towels (4% of $4,000) 340 340 340 160 3030 Other professional services - - 5,000 5,000 Contract pavement marking (Ramsey Co)(moved from 4470) - - 500 500 Asset management software annual maintenance - - 5,500 5,500 3100 Telephone 210 200 200 230 Cellphone (2.5% of $8,000)($9,200) 210 200 200 230 3250 Electricity - traffic signals 2,000 2,000 2,000 2,000 Electricity for traffic signals 2,000 2,000 2,000 2,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,460 9,450 36,825 37,425 15.44%-0.11%289.68%1.63% Grand Total all PW Departments 292,965 318,160 343,159 315,072 10.98%8.60%7.86%-8.18% 44 Y-T-D 2012 2013 2014 2015 11/30/2015 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Convention & Visitor's Bureau (100-4653) Contractual services 3045 N Metro Convention Bureau 51,384 57,346 63,049 53,200 52,052 60,800 7,600 14.29% Total contractual services 51,384 57,346 63,049 53,200 52,052 60,800 7,600 14.29% Total Convention & Visitor's Bureau 51,384 57,346 63,049 53,200 52,052 60,800 7,600 14.29% Miscellaneous (100 - 4700): Personnel services 0300 Social security 148 245 248 - 196 - - 0.00% 0321 PERA 203 304 306 - 362 - - 0.00% 0400 Group insurance 278 495 489 - 462 - - 0.00% 0750 Fitness program 2,547 3,833 3,883 6,500 3,615 6,500 - 0.00% Total personnel services 3,176 4,877 4,926 6,500 4,635 6,500 - 0.00% Contractual services 3065 Family & youth social services 19,221 19,548 19,763 20,178 20,178 20,783 605 3.00% Total contractual services 19,221 19,548 19,763 20,178 20,178 20,783 605 3.00% Miscellaneous 9900 Transfers - EDA - - - 10,000 - 50,000 40,000 400.00% 9900 Transfers - Vehicle & Equip. Fund 75,000 90,000 100,000 110,000 - 150,000 40,000 36.36% 9900 Transfers - Special Projects - - 825,000 50,122 - 75,000 24,878 49.63% 9900 Community Center 170,000 145,000 165,000 170,000 - 170,000 - 0.00% Total miscellaneous 245,000 235,000 1,090,000 340,122 - 445,000 104,878 30.84% 0.00% Total miscellaneous 267,397 259,425 1,114,689 366,800 24,813 472,283 105,483 28.76% Debt Service (100 - 4750): Debt Service ESP 8011 Lease payable - - - - 18,242 24,323 24,323 0.00% Total debt service - - - - 18,242 24,323 24,323 0.00% 2016 Budget Summary 45 Fund: 100 Department: 4653 Convention & Visitor's Bureau Account Description 2013 2014 2015 2016 Description 3045 N Metro Convention Bureau 50,350 50,350 53,200 60,800 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 50,350 53,200 60,800 Fund: 100 Department: 4700 Miscellaneous Account Description 2013 2014 2015 2016 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,548 19,763 20,178 20,783 Northeast Youth and Family Services (NYFS) 19,548 19,763 20,178 20,783 9100 Contingency - - - - Unexpected expenditures, deductibles, grant matches - - - - 9900 Transfers - miscellaneous - - 10,000 50,000 Transfer to Economic Development Authority (EDA) - - 50,122 75,000 Transfer to Special Projects fund - - 60,122 125,000 9900 Transfers - miscellaneous 90,000 100,000 110,000 150,000 Transfer to Vehicle & Equipment Fund 90,000 100,000 110,000 150,000 9990 Community Center 170,000 170,000 170,000 170,000 Subsidy for Community Center operating costs 170,000 170,000 170,000 170,000 286,048 296,263 366,800 472,283 Fund: 100 Department: 4750 Debt Service Account Description 2013 2014 2015 2016 Description 8011 Lease payable - - - 24,323 Lease payable Energy Savings Program - - - 24,323 46 2016 Budget Summary Y-T-D 2012 2013 2014 2015 11/30/15 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Cable TV (Fund 210): Revenues 3180 Franchise fee 119,881 122,921 126,980 118,000 94,147 122,000 4,000 3.39% 3680 Other revenue 5,100 3,750 2,400 2,400 1,800 2,400 - 0.00% Total revenue 124,981 126,671 129,380 120,400 95,947 124,400 4,000 3.32% Operating expenses Operations (4350) Personnel services 0100 Salaries, regular 61,611 62,331 63,790 65,207 57,725 66,502 1,295 1.99% 0150 Salaries, part-time 1,684 - - - - - 0.00% 0300 Social security 4,711 4,631 4,697 4,989 4,285 5,087 98 1.96% 0321 PERA 4,582 4,496 4,599 4,890 4,294 4,988 98 2.00% 0400 Group insurance 8,937 10,073 10,570 11,340 9,847 11,718 378 3.33% 0500 Workers compensation 258 253 379 418 508 508 90 21.53% 0600 Unemployment - - - - 0.00% Total personnel services 81,783 81,784 84,035 86,844 76,659 88,803 1,959 2.26% Materials & supplies 1230 Supplies, equipment - - 1,097 3,000 428 3,000 - 0.00% 1600 Supplies, operating - - 863 1,500 - 1,500 - 0.00% Total materials & supplies - - 1,960 4,500 428 4,500 - 0.00% Contractual services 3030 Other professional services 3,672 3,672 3,941 7,200 2,925 7,200 - 0.00% 3630 Training & conferences - - 675 300 200 350 50 16.67% 3800 Mileage & parking 16 24 65 50 8 50 - 0.00% 3900 Grants & subsidies 27,414 27,658 28,390 29,241 28,560 29,826 585 2.00% 5130 Repairs, equipment - - - 10,000 - 10,000 - 0.00% Total contractual services 31,102 31,354 33,071 46,791 31,693 47,426 635 1.36% Capital 7030 Equipment - - - - - - - 0.00% Total capital outlays - - - - - - - 0.00% Total expenditures 112,885 113,138 119,066 138,135 108,780 140,729 2,594 1.88% Net change in fund balance 12,096 13,533 10,314 (17,735) (12,833) (16,329) 1,406 -7.93% Fund balance, beginning year 302,301 314,397 327,930 338,244 338,244 320,509 (17,735) -5.24% Fund balance, end of year 314,397$ 327,930$ 338,244$ 320,509$ 325,411$ 304,180$ (16,329)$ -5.09% 51,291 51,926 47 Fund: 210 Cable TV Revenues Account Description 2013 2014 2015 2016 Description 3180 Franchise fee revenue 110,000 116,000 118,000 122,000 Estimated collections 110,000 116,000 118,000 122,000 3680 Other revenue 5,100 2,400 2,400 2,400 Lease revenue from Library fiber connection 5,100 2,400 2,400 2,400 Fund: 210 Department: 4350 Operations 1230 Supplies, equipment < $5000 2,000 2,000 3,000 3,000 Equipment costing less than $5,000 per item 2,000 2,000 3,000 3,000 1600 Supplies, operating 750 1,000 1,250 1,250 Recording media - tapes, DVD's 250 250 250 250 Batteries, cables, bulbs, tapes, misc 1,000 1,250 1,500 1,500 3030 Other professional services 4,260 4,800 7,200 7,200 Web streaming meetings $600 per month. 4,260 4,800 7,200 7,200 3630 Training & conferences 300 300 300 350 Attendance at local training - 400 - - NATOA National Conference (local no travel) 300 700 300 350 3800 Mileage & parking 75 50 50 50 Mileage 75 50 50 50 3900 Grants & subsidies 28,236 29,083 29,241 29,826 Share of costs of North Suburban Cable Commission (2% increase) 28,236 29,083 29,241 29,826 5130 Repairs, equipment 10,000 10,000 10,000 10,000 Repair and maintenance of equipment 10,000 10,000 10,000 10,000 7030 Capital, equipment > $5000 ????Supplemental duct work/air conditioning ($5,000 - $15,000) ????Video Camera ($6,000 - $9,000) ????Editing Computer - ($8,600) ????Automation and control ($36,000) ????Control room/Council chambers replacement ($150,000 - $225,000) - - - - 45,871 47,883 51,291 51,926 2.51%4.39%7.12%1.24% 48 2016 Budget Summary Y-T-D 2012 2013 2014 2015 11/30/15 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Forfeiture (Fund 225): Revenues 3510 Ramsey Co Municipal Court - - 1,680 - 1,080 - - #DIV/0! 3514 Forfeitures 26,676 27,457 26,813 5,500 12,668 5,500 - 0.00% Total revenue 26,676 27,457 28,493 5,500 13,748 5,500 - 0.00% Operating expenses (4200): Materials & supplies 1230 Supplies, equipment - 1,079 8,305 7,400 2,292 19,000 11,600 156.76% 1600 Supplies, operating 28 795 9,220 500 151 500 - 0.00% Total materials & supplies 28 1,874 17,525 7,900 2,443 19,500 11,600 146.84% Contractual services 3030 Other professional services 8,976 7,976 2,450 1,500 2,992 1,500 - 0.00% Total contractual services 8,976 7,976 2,450 1,500 2,992 1,500 - 0.00% Capital 7030 Equipment - - 12,914 25,000 - 25,000 - 0.00% 7040 Vehicles - - - - - - - 0.00% Total capital outlays - - 12,914 25,000 - 25,000 - 0.00% Total expenses 9,004 9,850 32,889 34,400 5,435 46,000 11,600 33.72% Net change in fund balance 17,672 17,607 (4,396) (28,900) 8,313 (40,500) (11,600) 40.14% Fund balance, beginning year 23,165 40,837 58,444 54,048 54,048 25,148 (28,900) -53.47% Fund balance, end of year 40,837 58,444 54,048 25,148 62,361 (15,352) (40,500) -161.05% 49 Fund: 225 Forfeiture Revenues Account Description 2013 2014 2015 2016 Description 3514 Forfeitures 5,500 5,500 5,500 5,500 Sale of forfeited vehicles at auction. 5,500 5,500 5,500 5,500 Fund: 225 Department: 4200 Operations 1230 Supplies - equipment < $5000 1,100 1,100 1,100 1,100 Taser 4,000 4,000 1,000 6,000 (6) Body cameras and storage system - - - 2,000 K-9 additional vehicle set-up costs - 950 - - Gun clearing safety device - - 900 900 Long rifle - 2,500 - 4,600 (2) Ballistic shields - 1,000 1,500 1,500 Replacement Glock pistols (5) with trade-in 2,000 2,700 2,900 2,900 Radar 7,100 12,250 7,400 19,000 1600 Supplies - operating 500 500 500 500 Supplies to prepare vehicles for auction. (tows, title fees, batteries) 500 500 500 500 3030 Other professional services 1,500 1,500 1,500 1,500 Share of auction costs. 1,500 1,500 1,500 1,500 7030 Equipment > $5000 - - 10,000 10,000 (2) In-squad cameras - - 15,000 15,000 Stationary radar sign for County Rd I (Pinewood school) - - 25,000 25,000 9,100 14,250 34,400 46,000 355.00%56.59%141.40%33.72% 50 Y-T-D 2012 2013 2014 2015 11/30/15 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent EDA (Fund 230): Revenues 3610 Investment income 5 4 4 - - - - 0.00% 3615 Interest received on notes 172 439 546 - - - - 0.00% 3680 Other revenue 5,858 5,988 5,547 - - - - 0.00% 3972 Transfers 134,758 119,870 85,428 91,820 - 125,331 33,511 36.50% Total revenue 140,793 126,301 91,525 91,820 - 125,331 33,511 36.50% Operating expenses Economic Development (4650): Personnel services 0100 Salaries, regular 83,852 74,095 29,785 6,803 6,395 77,652 70,849 1041.44% 0150 Salaries, part-time - - 12,614 49,838 44,186 - (49,838) -100.00% 0300 Social security 6,219 5,601 3,133 4,334 3,802 5,941 1,607 37.08% 0321 PERA 6,048 5,319 3,020 4,249 3,772 5,824 1,575 37.07% 0400 Group insurance 10,991 10,991 4,272 9,612 8,904 12,838 3,226 33.56% 0500 Workers compensation 399 435 513 515 626 836 321 62.33% Total personnel services 107,509 96,441 53,337 75,351 67,685 103,091 27,740 36.81% Materials & supplies 1600 Supplies, operating - 11 - 100 - 100 - 0.00% 2100 Book & periodicals 229 249 278 230 - 230 - 0.00% Total materials & supplies 229 260 278 330 - 330 - 0.00% Contractual services 3030 Other professional services 23,265 19,059 28,844 13,080 17,459 17,610 4,530 34.63% 3420 Advertisements 1,246 1,635 898 - - - - 0.00% 3430 Printing 857 9 - 600 - 600 - 0.00% 3610 Memberships 3,551 4,751 3,501 710 510 710 - 0.00% 3630 Training & conferences 1,030 518 1,055 1,000 1,294 1,991 991 99.10% 3800 Mileage - 27 25 100 316 350 250 250.00% 4800 Insurance 2,929 3,158 3,037 649 435 649 - 0.00% 5210 Housing replacement 493 1,030 144 - - - - 0.00% Total contractual services 33,371 30,187 37,504 16,139 20,014 21,910 5,771 35.76% Total expenditures 141,109 126,888 91,119 91,820 87,699 125,331 33,511 36.50% Net change in fund balance (316) (587) 406 - (87,699) - - 0.00% Fund balance, beginning year 49,651 49,335 48,748 49,154 49,154 49,154 - 0.00% Fund balance, end of year 49,335 48,748 49,154 49,154 (38,545) 49,154 - 0.00% 2016 Budget Summary 51 Fund: 230 EDA Revenues Account Description 2013 2014 2015 2016 Description 3610 Interest income - - - - Estimated interest earnings at 1.25%. - - - - 3635 Rental income - - - - Rental on EDA owned houses - - - - 3972 Transfers 388,840 268,636 81,820 75,331 Transfers from TIF 5 - - 10,000 50,000 Transfers from General Fund 388,840 268,636 91,820 125,331 Fund: 230 Department: 4650 Economic Development 1600 Supplies, operating 100 100 100 100 Misc office supplies 100 100 100 100 2100 Books & periodicals 30 30 - - LMC directory 230 230 230 230 Misc. reports & periodicals (Finance & Commerce) 260 260 230 230 3030 Other professional services 6,500 6,500 - - Legal fees for development reviews 11,000 11,000 - - Financial consultant fees (Ehlers) 24,000 24,000 - 4,500 Special project consultant fees 4,500 4,500 - - Appraisal and environmental fees 4,560 4,650 1,580 1,610 5% audit fee (reduced from 15%)(2016-$32,200) 12,750 12,750 11,500 11,500 Housing Resource Center fees 3,000 10,000 - - Marketing Consultant fees 66,310 73,400 13,080 17,610 3420 Advertising 1,000 1,500 - - Targeted advertisements. 1,000 1,500 - - 3430 Printing 500 500 500 500 Property ad printing 200 200 - - Stationary/business cards/signs/site info 300 300 100 100 Misc printing 1,000 1,000 600 600 3610 Memberships 400 400 400 400 Economic Development Assoc of MN (EDAM) 250 250 250 250 Twin Cities North Chamber of Commerce dues 60 60 60 60 MN Assoc. of Govt. Communicators (MAGC) 225 225 - - Urban Land Institute 2,801 2,801 - - North Metro Mayors Assoc (all in General Fund for 2015) 3,736 3,736 710 710 3630 Training & conferences 300 300 - - Chamber of Commerce meetings 650 650 - - DEED/ EDC training 300 300 - - EDAM monthly meetings - - - 535 IEDC Conference Minneapolis - - - 275 Ehlers Finance Seminar 600 600 600 600 EDAM summer conference 150 455 400 581 Other miscellaneous training 2,000 2,305 1,000 1,991 3800 Mileage 100 100 100 350 Misc. mileage 4800 Insurance 4,600 4,600 649 649 Allocation of the City's property & liability insurance (moved to Central Serv) 4,600 4,600 649 649 5210 Housing programs 150,000 50,000 - - Housing Improvement programs 150,000 50,000 - - 9300 Business loans/subsidies 50,000 50,000 - - Business improvement partnership loans/subsidies 50,000 50,000 - - 279,106 187,001 16,469 22,240 -0.83%-33.00%-91.19%35.04% 52 THIS PAGE LEFT BLANK INTENTIONALLY 53 2016 Budget Summary Y-T-D 2012 2013 2014 2015 11/30/15 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (Fund 252): Building overhead (4350) Building overhead revenues 171,831 144,298 169,525 171,000 7,401 171,000 - 0.00% Building overhead expenditures - - - - 56,416 52,988 52,988 #DIV/0! Net Building Overhead Operations 171,831 144,298 169,525 171,000 (49,015) 118,012 (52,988) -30.99% Banquet Center (4730): Banquet revenues 82,471 106,268 91,376 86,000 76,096 88,000 2,000 2.33% Banquet Center expenditures 207,066 127,496 131,664 120,899 102,743 112,727 (8,172) -6.76% Net Banquet Center (124,595) (21,228) (40,288) (34,899) (26,647) (24,727) 10,172 -29.15% YMCA (4732): YMCA revenues 52,620 61,138 70,463 45,425 42,676 52,600 7,175 15.80% YMCA expenditures 253,667 215,785 228,783 239,230 212,711 223,673 (15,557) -6.50% Net YMCA (201,047) (154,647) (158,320) (193,805) (170,035) (171,073) 22,732 -11.73% Office/Chamber space (4734): Office/Chamber revenues - 3,495 2,000 - 7,450 8,198 8,198 #DIV/0! Office/Chamber expenditures - 5,733 6,003 - 4,757 4,634 4,002 #DIV/0! Net Office/Chamber space - (2,238) (4,003) - 2,693 3,564 4,196 #DIV/0! Creative Kids Child Care Center (4736): Creative Kids revenues 79,900 81,730 83,135 85,032 77,783 85,882 850 1.00% Creative Kids expenditures 47,933 40,128 41,356 39,222 32,636 33,183 (6,039) -15.40% Net Creative Kids 31,967 41,602 41,779 45,810 45,147 52,699 6,889 15.04% Total revenue 386,822 396,929 416,499 387,457 211,406 405,680 18,223 4.70% Total expenditures 508,666 389,142 407,806 399,351 409,263 427,205 27,222 6.82% Net change in fund balance (121,844) 7,787 8,693 (11,894) (197,857) (21,525) (8,999) 75.66% Fund balance, beginning year 240,168 118,324 126,111 134,804 134,804 122,910 (11,894) -8.82% Fund balance, end of year 118,324 126,111 134,804 122,910 (63,053) 101,385 (21,525) -17.51% (continued) 54 2016 Budget Summary YTD 2012 2013 2014 2015 11/30/15 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (continued): Building overhead (4350) Building revenues: 3610 Investment income 1,519 (1,295) 1,511 1,000 (9) 1,000 - 0.00% 3634 Equipment rental - 153 3,047 - - - - 0.00% 3650 Donations - - - - 470 - - 0.00% 3680 Miscellaneous 312 440 (33) - 6,940 - - 0.00% 3972 Transfers 170,000 145,000 165,000 170,000 - 170,000 - 0.00% 171,831 144,298 169,525 171,000 7,401 171,000 - 0.00% Operating expenses Personnel services 0100 Salaries, regular 35,864 36,391 37,181 39,716 35,425 40,514 798 2.01% 0110 Salaries,overtime 284 1,328 2,983 1,611 1,550 1,643 32 1.99% 0300 Social Security 2,566 2,713 2,925 3,161 2,704 3,225 64 2.02% 0321 PERA 2,594 2,710 2,860 3,100 2,767 3,162 62 2.00% 0400 Group insurance 8,212 8,652 9,089 9,504 8,805 9,696 192 2.02% 0500 Workers compensation 1,361 1,489 2,243 2,699 3,728 3,249 550 20.38% 999 Allocation of salaries (50,881) (53,283) (57,281) (59,791) (49,929) (61,489) (1,698) 2.84% Total personnel services - - - - 5,050 - - 0.00% Materials & supplies 1210 Supplies, buildings & grounds 2,176 2,961 2,916 1,150 1,022 1,150 - 0.00% 1230 Supplies, equipment 877 1,972 588 800 149 800 - 0.00% 1600 Supplies, operating 5,132 7,923 7,534 7,000 6,827 7,500 500 7.14% 2400 Uniforms 626 432 575 470 416 470 - 0.00% 2410 Mats & towels 654 253 3,053 1,250 1,877 1,250 - 0.00% 2999 Allocation of supplies (9,465) (13,541) (14,666) (10,670) (9,385) (11,170) (500) 4.69% Total materials & supplies - - - - 906 - - 0.00% Contractual services 3030 Other professional services 4,250 1,352 343 11,750 11,455 13,750 2,000 17.02% 3100 Telephone 2,740 2,839 3,026 3,200 2,581 3,200 - 0.00% 3200 Water & sewer 8,198 7,871 8,720 9,000 8,335 9,000 - 0.00% 3210 Electricity 56,410 65,926 60,276 58,000 51,535 25,000 (33,000) -56.90% 3220 Natural gas 8,496 12,282 13,977 11,000 11,151 9,000 (2,000) -18.18% 3530 Refuse collection 4,215 2,723 2,837 3,980 2,757 3,980 - 0.00% 3610 Memberships - - 30 - - - - 0.00% 3630 Training & conferences - 73 58 - 31 - - 0.00% 3999 Allocation of utilities (84,309) (93,066) (89,267) (96,930) (80,220) (63,930) 33,000 -34.05% 5110 Repairs, building & grounds 70,533 14,592 18,475 8,570 14,300 8,570 - 0.00% 5130 Repairs, equipment 28,574 17,944 21,892 12,500 8,967 12,500 - 0.00% 5999 Allocation of repairs (99,107) (32,536) (40,367) (21,070) (20,172) (21,070) - 0.00% Total contractual services - - - - 10,720 - - 0.00% Debt service 8011 Lease payable - - - - 39,740 52,988 52,988 #DIV/0! Total debt service - - - - 39,740 52,988 52,988 #DIV/0! Total Building overhead expendi - - - - 56,416 52,988 52,988 #DIV/0! Total Building Overhead Net 171,831 144,298 169,525 171,000 (49,015) 118,012 (52,988) -30.99% (continued) 55 Fund: 252 Department: 4350 Community Center Building Overhead Expenditures Account Description 2013 2014 2015 2016 Description 1210 Supplies, bldgs & grounds 1,100 1,150 1,150 1,150 Lights, signs, fertilizer 1,100 1,150 1,150 1,150 1230 Supplies, equipment < $5000 800 800 800 800 Small tools & equipment 800 800 800 800 1600 Supplies, operating 7,000 7,000 7,000 7,500 Batteries, soap, paper towels, cleaning supplies for bathrooms Paper cups, plates, etc. for lounge & customer service events 7,000 7,000 7,000 7,500 2400 Uniforms 582 650 470 470 Uniforms/Clothing (7.3% of $4,500 + .8 FTE x $175) 582 650 470 470 2410 Mats & towels 1,250 1,000 1,000 1,000 Floor mats and cleaning towelsto provide better protection of carpets 500 250 250 250 Special events 1,750 1,250 1,250 1,250 3030 Other professional services 200 200 800 800 Backflow inspection, alarm inspection, - - 200 200 Sprinkler inspections - - 9,000 11,000 Custodial services: 12 months $xxx - - 1,750 1,750 Commercial carpet cleaning service (twice annually) 200 200 11,750 13,750 3100 Telephone & internet 3,600 3,600 3,200 3,200 Office & customer phones, internet, maintenance agreements, & repairs 3,600 3,600 3,200 3,200 3200 Water & Wastewater 9,000 9,000 9,000 9,000 Water & sewer charges for community center 9,000 9,000 9,000 9,000 3210 Electricity 62,000 58,000 58,000 25,000 Estimated electrice charges 62,000 58,000 58,000 25,000 3220 Natural gas 14,000 10,000 11,000 9,000 Estimated natural gas charges 14,000 10,000 11,000 9,000 3530 Refuse collection 3,720 3,120 3,280 3,280 Dumpsters $273 x 12 months 680 1,200 600 600 Extra garbage pick-up charges 100 100 100 100 Ramsey County recyclying fee 4,500 4,420 3,980 3,980 5110 Repairs, building & grounds 5,760 5,760 - - Custodial services: 12 mths X $480 (moved to 3030) 3,000 3,000 - - Commercial carpet cleaning service (twice annually)(moved to 3030) 4,500 4,500 4,500 4,500 Exterior building maintenance 770 770 770 770 Exterminator: 12 months X 64.02 1,500 1,500 1,500 1,500 Fire alarm system service 1,300 1,300 1,300 1,300 Parking lot & grounds maintenance 500 500 500 500 Security system service 17,330 17,330 8,570 8,570 5130 Repairs, equipment 5,000 5,000 11,000 11,000 HVAC system maintenance contract 200 200 - - Sprinkler inspections (moved to 3030) 1,500 1,500 1,500 1,500 Plumbing, electrical, & misc. interior maintenance 6,700 6,700 12,500 12,500 8011 Lease payable (ESP)- - - 52,988 Lease payable for energy savings program - - - 52,988 128,562 120,100 128,670 149,158 1.14%-6.58%7.14%15.92% 56 2016 Budget Summary Y-T-D 2012 2013 2014 2015 11/30/15 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (continued): Banquet Center (4730): Banquet Revenues 3644 Equipment rental - - - - 4,063 - - 0.00% 3645 Rental - banquet facility 82,471 106,268 91,376 86,000 72,033 88,000 2,000 2.33% 0.00% 82,471 106,268 91,376 86,000 76,096 88,000 2,000 2.33% Banquet Expenditures Personnel services 0999 Allocation of salaries 10,452 10,754 11,456 11,958 9,986 12,298 340 2.84% Total personnel services 10,452 10,754 11,456 11,958 9,986 12,298 340 2.84% Materials & supplies 1210 Supplies, buildings & grounds 82 - 78 - - - - 0.00% 1230 Supplies, equipment 587 4,355 59 2,500 1,555 2,500 - 0.00% 1600 Supplies, operating - - - - 79 - - 0.00% 2999 Allocation of supplies 2,650 3,791 4,105 2,988 2,628 3,128 140 4.67% Total materials & supplies 3,319 8,146 4,242 5,488 4,262 5,628 140 2.54% Contractual services 3030 Other professional services 61,763 62,504 64,958 62,691 58,606 63,279 588 0.94% 3100 Telephone 180 - - - - - - 0.00% 3420 Advertising - - - 500 - 500 - 0.00% 3430 Printing - - - 250 - 250 - 0.00% 3999 Allocation of utilities 22,458 25,725 24,736 26,884 21,217 17,644 (9,240) -34.37% 4800 Bonding & insurance 1,337 1,442 1,387 2,100 1,408 2,100 - 0.00% 5110 Repairs, building & grounds 18,840 7,182 11,601 2,700 1,616 2,700 - 0.00% 5130 Repairs, equipment 449 2,633 1,997 1,600 - 1,600 - 0.00% 5999 Allocation of repairs 27,750 9,110 11,287 6,728 5,648 6,728 - 0.00% Total contractual services 132,777 108,596 115,966 103,453 88,495 94,801 (8,652) -8.36% Capital 7030 Equipment 60,518 - - - - - - 0.00% Total capital outlays 60,518 - - - - - - 0.00% 207,066 127,496 131,664 120,899 102,743 112,727 (8,172) -6.76% Total Banquet Center net (124,595) (21,228) (40,288) (34,899) (26,647) (24,727) 10,172 -29.15% (continued) 57 Fund: 252 Community Center - 4730 Banquet Center Expenditures Account Description 2013 2014 2015 2016 Description 1230 Supplies, equipment 4,000 4,000 2,500 2,500 Tables, mirrors, microphones, projectors, etc. for Banquet Room 4,000 4,000 2,500 2,500 2999 Allocation of supplies 3,145 3,038 2,988 3,128 28% Allocation from overall building support 3,145 3,038 2,988 3,128 3030 Other professional services 760 775 790 790 2.5% of audit 2,600 2,600 2,000 2,000 Miscellaneous professional services (linen service) 51,923 52,962 54,551 55,139 Banquet facility management (21% of 262,562.23) - - 1,250 1,250 Carpet cleaning 2 x year - 2,500 3,600 3,600 Extra staff for large events 1,500 500 500 500 Legal costs 56,783 59,337 62,691 63,279 3420 Advertising & marketing 500 500 500 500 Website and traditional advertising, marketing 500 500 500 500 3430 Printing 250 250 250 250 Brochures, flyers, etc. 250 250 250 250 3999 Allocation of utilities 25,836 23,574 26,884 17,644 28% Allocation from overall building utilities 25,836 23,574 26,884 17,644 4800 Bonding & insurance 2,100 2,100 2,100 2,100 Insurance & bonding cost 2,100 2,100 2,100 2,100 5110 Repairs, building & grounds 1,200 1,200 1,200 1,200 Interior building repairs specific to the banquette center 500 1,500 1,500 1,500 Dance floor maintenance 1,700 2,700 2,700 2,700 5130 Repairs, equipment 1,600 1,600 1,600 1,600 Repairs to kitchen, audio system, and other banquette equipment 1,600 1,600 1,600 1,600 5999 Allocation of repairs 6,728 6,728 6,728 6,728 28% Allocation from overall building repairs 6,728 6,728 6,728 6,728 102,642 103,827 108,941 100,429 -27.31%1.15%4.93%-7.81% 58 2016 Budget Summary YTD 2012 2013 2014 2015 11/30/15 2016 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (continued): YMCA (4732): YMCA Revenues 3405 Recreation profit 20,811 19,124 30,157 15,000 - 18,000 3,000 20.00% 3660 Gym & meeting room rental 13,947 23,139 19,683 15,000 24,267 18,000 3,000 20.00% 3661 Open gym participant fees 17,576 18,363 19,856 15,000 16,840 16,000 1,000 6.67% 3679 Commissions - vending 286 512 767 425 1,569 600 175 41.18% 52,620 61,138 70,463 45,425 42,676 52,600 7,175 15.80% YMCA Expenditures Personnel services - 0999 Allocation of salaries 36,635 36,764 39,524 43,050 34,451 42,427 (623) -1.45% Total personnel services 36,635 36,764 39,524 43,050 34,451 42,427 (623) -1.45% Materials & supplies 1230 Supplies, equipment - - - 500 - 500 - 0.00% 1600 Supplies, operating 4,221 - - - - - - 0.00% 2999 Allocation of supplies 5,016 6,771 7,331 5,655 4,693 5,585 (70) -1.24% Total materials & supplies 9,237 6,771 7,331 6,155 4,693 6,085 (70) -1.14% Contractual services 3030 Other professional services 96,598 97,204 100,808 104,570 106,225 109,018 4,448 4.25% 3300 Postage - - - 600 - 600 - 0.00% 3430 Printing 5,642 5,797 6,042 6,600 4,694 6,600 - 0.00% 3999 Allocation of utilities 48,105 47,468 45,475 52,237 43,190 32,925 (19,312) -36.97% 4010 Rental, equipment - - - 250 184 250 - 0.00% 4800 Bonding & insurance 2,562 2,763 2,657 4,025 2,699 4,025 - 0.00% 5110 Repairs, building & grounds 106 1,181 4,512 7,000 5,355 7,000 - 0.00% 5130 Repairs, equipment 2,255 1,569 2,278 1,350 1,134 1,350 - 0.00% 5999 Allocation of repairs 52,527 16,268 20,156 13,393 10,086 13,393 - 0.00% Total contractual services 207,795 172,250 181,928 190,025 173,567 175,161 (14,864) -7.82% 253,667 215,785 228,783 239,230 212,711 223,673 (15,557) -6.50% Total YMCA net (201,047) (154,647) (158,320) (193,805) (170,035) (171,073) 22,732 -11.73% (continued) Change from 2015 59 Fund: 252 Community Center - 4732 YMCA Expenditures Account Description 2013 2014 2015 2016 Description 1230 Supplies, equipment - - 500 500 Miscellaneous - - 500 500 2999 Allocation of supplies 5,953 5,642 5,655 5,585 50% Allocation from overall building support 5,953 5,642 5,655 5,585 3030 Other professional services 100,188 97,000 102,200 103,713 YMCA mgt. contract (other half of fee in parks)(39.5% of $262,563) - - - 2,935 Copier ($2,100) Computer ($835) per agreement 2,280 2,325 2,370 2,370 7.5% of audit 102,468 99,325 104,570 109,018 3300 Postage 1,200 1,200 600 600 50% of the cost of mailing the Mounds View Matters newsletter 1,200 1,200 600 600 3430 Printing 6,000 6,000 6,600 6,600 50% of the cost of printing the Mounds View Matters newsletter 6,000 6,000 6,600 6,600 3999 Allocation of utilities 50,421 45,322 52,237 32,925 50% Allocation from overall building utilities 50,421 45,322 52,237 32,925 4010 Rental, equipment - - 250 250 Scissor lift rental - - 250 250 4800 Bonding & insurance 4,025 4,025 4,025 4,025 Insurance & bonding cost. 4,025 4,025 4,025 4,025 5110 Repairs, building & grounds 3,000 3,000 3,000 3,000 General building repairs 4,000 4,000 2,000 2,000 Interior improvements 2,000 2,000 2,000 2,000 Gym floor resurfacing & maintenance 9,000 9,000 7,000 7,000 5130 Repairs, equipment 2,650 500 - - Copier maintenance contract 1,000 500 500 500 Registration system support 350 350 850 850 Repairs to other equipment 4,000 1,350 1,350 1,350 5999 Allocation of repairs 12,736 12,496 13,393 13,393 50% Allocation from overall building repairs 12,736 12,496 13,393 13,393 195,803 184,360 196,180 181,246 0.38%-5.84%6.41%-7.61% 60 2016 Budget Summary 2012 2013 2014 2015 11/30/15 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Office space/Chamber (4734); Office space/Chamber Revenues 3633 Lease - Office/Chamber space - 3,495 2,000 - 7,450 8,198 8,198 #DIV/0! - 3,495 2,000 - 7,450 8,198 8,198 #DIV/0! Office/Chamber space Expenditures Personnel services 0999 Allocation of salaries - 1,598 1,719 - 1,498 1,845 1,845 #DIV/0! Total personnel services - 1,598 1,719 - 1,498 1,845 1,845 #DIV/0! Materials & supplies 2999 Allocation of supplies - 406 440 - 281 335 335 #DIV/0! Total materials & supplies - 406 440 - 281 335 335 #DIV/0! Contractual services 3999 Allocation of utilities - 2,753 2,635 - 2,373 1,822 1,822 #DIV/0! 5999 Allocation of repairs - 976 1,209 - 605 632 632 #DIV/0! Total contractual services - 3,729 3,844 - 2,978 2,454 1,822 #DIV/0! 0 - 5,733 6,003 - 4,757 4,634 4,002 #DIV/0! Total Office/Chamber space Net - (2,238) (4,003) - 2,693 3,564 4,196 #DIV/0! (continued) 61 2016 Budget Summary YTD 2012 2013 2014 2015 11/30/15 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Creative Kids Child Care (4736): Child Care Revenues 3632 Lease - Child Care 79,900 81,730 83,135 85,032 77,783 85,882 850 1.00% 79,900 81,730 83,135 85,032 77,783 85,882 850 1.00% Child Care Ed Expenditures (19%) Personnel services 0999 Allocation of salaries 4,071 4,263 4,582 4,783 3,994 4,919 136 2.85% Total personnel services 4,071 4,263 4,582 4,783 3,994 4,919 136 2.85% Materials & supplies 2999 Allocation of supplies 1,798 2,572 2,785 2,027 1,783 2,122 95 4.70% Total materials & supplies 1,798 2,572 2,785 2,027 1,783 2,122 95 4.70% Contractual services 3999 Allocation of utilities 13,747 17,120 16,475 17,809 13,441 11,539 (6,270) -35.21% 4750 Taxes, licenses, & fees 8,596 9,030 8,930 9,200 8,646 9,200 - 0.00% 4800 Bonding & insurance 891 961 925 1,400 939 1,400 - 0.00% 5999 Allocation of repairs 18,830 6,182 7,659 4,003 3,833 4,003 0 0.01% Total contractual services 42,064 33,293 33,989 32,412 26,859 26,142 (6,270) -19.34% Total Child Care expenditures 47,933 40,128 41,356 39,222 32,636 33,183 (6,039) -15.40% Total Child Care net 31,967 41,602 41,779 45,810 45,147 52,699 6,889 15.04% 62 2016 Budget Summary Y-T-D 2012 2013 2014 2015 11/30/15 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Lakeside Park (Fund 255): Revenues 3370 Spring Lake Pk contribution 10,608 10,608 10,608 11,500 11,500 11,500 - 0.00% 3370 Mounds View contribution 23,108 10,608 10,608 11,500 11,500 11,500 - 0.00% 3610 Investment income 219 (466) 729 300 (4) 300 - 0.00% 3665 Park site permit 571 448 678 250 921 250 - 0.00% 3680 Other revenue 9,558 - - - - 0.00% Total revenue 44,064 21,198 22,623 23,550 23,917 23,550 - 0.00% Operating expenses (4350): Personnel services 0150 Salaries, part-time 3,320 3,360 3,528 3,360 2,079 3,360 - 0.00% 0300 Social security 254 257 270 257 159 257 - 0.00% 0500 Workers compensation 83 106 146 166 202 166 - 0.00% Total personnel services 3,657 3,723 3,944 3,783 2,440 3,783 - 0.00% Materials & supplies 1210 Supplies, bldgs & grounds 1,844 458 237 1,200 - 1,200 - 0.00% 1600 Supplies, operating 4,483 4,337 957 1,800 - 1,800 - 0.00% Total materials & supplies 6,327 4,795 1,194 3,000 - 3,000 - 0.00% Contractual services 3030 Other professional services - - - - - - - 0.00% 3200 Water & sewer 2,428 1,646 1,869 1,600 2,088 1,600 - 0.00% 3210 Electricity 1,021 984 1,625 1,600 1,097 1,600 - 0.00% 3530 Refuse collection 48 48 - 75 - 75 - 0.00% 4010 Equipment Contribution SLP 4,986 4,986 4,372 4,600 - 4,600 - 0.00% 4030 Satellites 520 609 875 500 1,487 500 - 0.00% 4800 Insurance 4,411 4,638 4,738 4,800 - 4,800 - 0.00% 5130 Repairs, equipment 992 2,558 - 3,592 - 3,592 - 0.00% Total contractual services 14,406 15,469 13,479 16,767 4,672 16,767 - 0.00% Capital 7030 Equipment 13,385 - - - - - - 0.00% 7050 Construction 33,878 13,361 - - - - - 0.00% Total capital outlays 47,263 13,361 - - - - - 0.00% Total expenses 71,653 37,348 18,617 23,550 7,112 23,550 - 0.00% Net change in fund balance (27,589) (16,150) 4,006 - 16,805 - - 0.00% Fund balance, beginning year 40,078 12,489 (3,661) 345 345 345 - 0.00% Fund balance, end of year 12,489 (3,661) 345 345 17,150 345 - 0.00% 63 Fund: 255 Lakeside Park Revenues Account Description 2013 2014 2015 2016 Description 3370 Contributions 10,608 10,608 11,500 11,500 Spring Lake Park contribution for half of cost for joint park 10,608 10,608 11,500 11,500 3370 Contributions 10,608 10,608 11,500 11,500 Mounds View contribution for half of cost for joint park 10,608 10,608 11,500 11,500 3610 Interest revenue 300 300 300 300 Estimated interest earnings at 1.25%. 300 300 300 300 3680 Park sit rental 250 250 250 250 Rental of the park by groups or individuals 250 250 250 250 Fund: 255 Department: 4350 Expenditures 1210 Supplies, bldgs & grounds 600 600 1,200 1,200 Paper, sand, etc. 600 600 1,200 1,200 1600 Supplies, operating 1,500 1,500 1,800 1,800 Fertilizer & pesticides 1,500 1,500 1,800 1,800 3200 Water & sewer 1,400 1,400 1,600 1,600 Estimated water & sewer charges 1,400 1,400 1,600 1,600 3210 Electricity 1,400 1,400 1,600 1,600 Estimated electric charges 1,400 1,400 1,600 1,600 3530 Refuse collection 250 250 75 75 Six months service 250 250 75 75 4010 Equipment, capital charge 4,372 4,372 4,600 4,600 Capital charge for usage of SLP city equipment 4,372 4,372 4,600 4,600 4030 Satellites 500 500 500 500 Five months service 500 500 500 500 4800 Insurance & bonds 4,500 4,500 4,800 4,800 Property & liability insurnace 4,500 4,500 4,800 4,800 5130 Repairs, equipment 3,514 3,514 3,592 3,592 Repair of equipment at the park 3,514 3,514 3,592 3,592 18,036 18,036 19,767 19,767 -0.17%0.00%9.60%0.00% 64 2016 Budget Summary Y-T-D 2012 2013 2014 2015 11/30/15 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Recycling (Fund 290): Revenues 3360 Other County grants 25,199 24,565 25,211 31,877 11,894 30,220 (1,657) -5.20% 3610 Investment income 85 (209) 321 - (2) - - 0.00% Total revenue 25,284 24,356 25,532 31,877 11,892 30,220 (1,657) -5.20% Operating expenses Operations (4420) Personnel services 0100 Salaries, regular 8,470 8,650 8,939 9,481 8,915 10,180 699 7.37% 0110 Salaries, overtime - - 286 281 - 0.00% 0300 Social security 554 565 612 725 686 779 54 7.45% 0321 PERA 615 625 666 711 651 764 53 7.45% 0400 Group insurance 2,311 2,416 2,480 1,588 483 1,641 53 3.34% 0500 Workers compensation 54 58 71 83 101 105 22 26.51% Total personnel services 12,004 12,314 13,054 12,588 11,117 13,469 881 7.00% Materials & supplies 1600 Supplies, operating 3,864 3,252 - 3,000 - 1,000 (2,000) -66.67% Contractual services 3300 Postage 4,552 4,671 6,722 5,500 4,002 5,000 (500) -9.09% 3430 Printing 1,595 860 1,936 2,000 2,913 1,000 (1,000) -50.00% 3530 Refuse collection 3,345 3,892 4,321 8,789 4,439 9,751 962 10.95% Total contractual services 9,492 9,423 12,979 16,289 11,354 15,751 (538) -3.30% Total expenses 25,360 24,989 26,033 31,877 22,471 30,220 (1,657) -5.20% Net change in fund balance (76) (633) (501) - (10,579) - - 0.00% Fund balance, beginning year 15,719 15,643 15,010 14,509 14,509 14,509 - 0.00% Fund balance, end of year 15,643 15,010 14,509 14,509 3,930 14,509 - 0.00% 16,751 65 Fund: 290 Recycling Grant Revenues Account Description 2013 2014 2015 2016 Description 3360 Other grants & aid 25,133 25,133 31,877 30,220 Estimated Ramsey County recycling grant 25,133 25,133 31,877 30,220 Fund: 290 Department: 4420 Expenditures 1600 Supplies, operatin - - 3,000 1,000 - - 3,000 1,000 3030 Other professional services - - - - - - - - 3300 Postage 1,700 3,000 5,500 5,000 City wide mailing for Cleanup Day and Newsletter 1,700 3,000 5,500 5,000 3420 Advertisements - - - - Promotional items - - - - 3430 Printing 600 800 1,000 500 Articles in City newsletter 800 800 1,000 500 Clean-up Day printing of direct mailing items 1,400 1,600 2,000 1,000 3530 Refuse collection 9,868 7,777 8,789 9,751 Contractual services for City Cleanup Day 9,868 7,777 8,789 9,751 12,968 12,377 19,289 16,751 -2.04%-4.56%55.85%-13.16% 66 Y-T-D 2012 2013 2014 2015 11/30/15 2016 Actual Actual Actual Budget Actual Request Dollar Percent TIF # 5 (Fund 450): Revenues 3101 Tax collections 1,326,776 1,390,103 1,415,212 1,457,260 1,220,973 1,555,982 98,722 6.77% 3610 Investment income 2,435 (8,333) 13,433 4,000 (80) 4,000 - 0.00% Total revenue 1,329,211 1,381,770 1,428,645 1,461,260 1,220,893 1,559,982 98,722 6.76% Operating expenses (4650): Contractual services 3030 Other professional 1,122 1,315 1,178 4,000 2,925 5,000 1,000 25.00% 8010 Developer PAG, principal - 132,268 196,416 - 231,283 - - 0.00% 8020 Developer PAG, interest 1,204,143 1,158,250 1,136,109 1,364,425 1,125,867 1,431,290 66,865 4.90% 9900 Transfers out to EDA 63,376 69,505 70,760 72,863 - 75,331 2,468 3.39% Total contractual services 1,268,641 1,361,338 1,404,463 1,441,288 1,360,075 1,511,621 70,333 4.88% Net change in fund balance 60,570 20,432 24,182 19,972 (139,182) 48,361 28,389 142.14% Fund balance, beginning year 622,175 682,745 703,177 727,359 727,359 747,331 19,972 2.75% Fund balance, end of year 682,745 703,177 727,359 747,331 588,177 795,692 48,361 6.47% 2016 Budget Summary Change from 2015 67 Fund: 450 TIF District #5 Revenues Account Description 2013 2014 2015 2016 Description 3101 Tax increment collections 1,326,776 1,299,181 1,457,260 1,555,982 Estimated collections of incremental taxes on properties 1,326,776 1,299,181 1,457,260 1,555,982 in the district. 3610 Investment income 5,000 4,000 4,000 4,000 Estimated interest earnings at 1.00%. 5,000 4,000 4,000 4,000 Fund: 430 Department: 4650 Economic Development 3030 Other professional services 3,000 3,000 2,420 3,420 TIF administration and reporting fees - - 1,580 1,580 5% audit fee (moved from EDA) 3,000 3,000 4,000 5,000 8010 Pay-as-you-go principal 1,260,437 1,234,223 1,364,425 1,431,290 Principal on a revenue note issued to promote a development. (Medtronic) 1,260,437 1,234,223 1,364,425 1,431,290 9900 Transfer out to EDA Fund 66,339 64,958 72,863 75,331 Transfer to cover the EDA operating budget. 66,339 64,958 72,863 75,331 68 2016 Budget Summary Y-T-D 2012 2013 2014 2015 11/30/15 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Park Dedication (Fund 451): Revenues 3610 Investment income 4,555 (11,465) 17,648 2,000 (113) 2,000 - 0.00% 3650 Park donations 10,000 8,155 8,900 - 15,085 - - 0.00% 3652 Park dedication fees - - 213,529 6,000 - 6,000 - 0.00% Total revenue 14,555 (3,310) 240,077 8,000 14,972 8,000 - 0.00% Operating expenses Operations (4350): Materials & supplies 1230 Supplies, equipment < $5,000 - - 15,367 - - - - 0.00% 1600 Supplies, operating 739 87 - - - - - 0.00% Total materials & supplies 739 87 15,367 - - - - 0.00% Contractual services 3030 Other professional services 819 3,654 2,235 - - - - 0.00% Total contractual services 819 3,654 2,235 - - - - 0.00% Capital 7050 Construction 285,175 119,640 7,960 347,500 63,045 145,000 (202,500) -58.27% Total capital outlays 285,175 119,640 7,960 347,500 63,045 145,000 (202,500) -58.27% Total expenses 286,733 123,381 25,562 347,500 63,045 145,000 (202,500) -58.27% Net change in fund balance (272,178) (126,691) 214,515 (339,500) (48,073) (137,000) 202,500 -59.65% Fund balance, beginning year 679,290 407,112 280,421 494,936 494,936 155,436 (339,500) -68.59% Fund balance, end of year 407,112$ 280,421$ 494,936$ 155,436$ 446,863$ 18,436$ (137,000)$ -88.14% 69 Fund: 451 Park Dedication Fund Revenues Account Description 2013 2014 2015 2016 Description 3610 Investment income 10,000 3,000 2,000 2,000 Estimated interest earnings at 1%. 10,000 3,000 2,000 2,000 3652 Park dedication fees 6,000 6,000 6,000 6,000 Developer payments 6,000 6,000 6,000 6,000 Fund: 451 Department: 4470 Expenditures 7050 Construction > $25000 - - - 20,000 Random Park Building interior remodeling - - - 25,000 Roofing shelters - - 100,000 100,000 Splash pad - - 220,000 - Groveland Park Improvements - 25,000 25,000 - Disk golf course improvements at Silverview Park - 20,000 - - Shelter and grounds improvements Silverview Park - 10,000 - - Irrigation improvements Silverview Park - 5,600 2,500 - Bike racks, Benches, Trash containers, Picknick tables, etc (BBC donations) - 3,000 - - Furniture replacement Random Park (BBC donations) - 15,000 - - Engineering for tennis court redesign Groveland Park 100,000 - - - Replace playground equipment - Silverview Park 8,500 - - - Hillview Park building roof 25,000 - - - Park Improvement Program (PIP) 50,000 - - - Greenfield Park Parking area (with area F street reconstruction) 183,500 78,600 347,500 145,000 70 2016 Budget Summary Y-T-D 2012 2013 2014 2015 11/30/15 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Vehicle & Equipment (Fund 460): Revenues 3972 Transfers in - General fund 75,000 90,000 100,000 110,000 - 150,000 40,000 36.36% 3972 Transfers in - Water Fund 58,000 58,000 60,000 58,000 - 64,000 6,000 10.34% 3972 Transfers in - Sewer Fund 36,000 36,000 36,000 53,000 - 42,000 (11,000) -20.75% 3972 Transfers in - Storm Water Fund 16,000 16,000 16,000 71,000 - 32,000 (39,000) -54.93% Total revenue 185,000 200,000 212,000 292,000 - 288,000 (4,000) -1.37% Expenditures Central Services (4160): Materials & supplies 0.00% 1600 Supplies, operating 941 - - - - - - 0.00% Total Central Services 941 - - - - - - 0.00% 0.00% Police (4200): Materials & supplies 0.00% 1230 Supplies, equipment < $5,000 - - 2,897 - - - - 0.00% 3030 Other professional services - - 941 - - - - 0.00% 5120 Repairs, vehicles - - 4,542 - - - - 0.00% Capital 7030 Equipment 945 - - - 93,649 10,000 10,000 #DIV/0! 7040 Vehicles 29,311 89,804 45,952 65,000 49,480 74,000 74,000 113.85% Total Police 30,256 89,804 54,332 65,000 143,129 84,000 84,000 129.23% Park and rec (4360): Capital 7030 Equipment - 15,344 183,224 115,000 - 18,000 18,000 15.65% 7040 Vehicles - - 26,696 - - - - 0.00% Total Park and rec - 15,344 209,920 115,000 - 18,000 18,000 15.65% PW Streets (4470): Materials & supplies 0.00% 1230 Supplies, equipment < $5,000 - - 4,215 - - - - 0.00% Capital 7030 Equipment 71,194 - - - 93,649 - - 0.00% 7040 Vehicles 27,737 - 96,622 - - - - 0.00% Total PW Streets 98,931 - 100,837 - 93,649 - - 0.00% Other (4160): 9100 Contingency - - - - - - - 0.00% 9900 Transfer out - General Fund 11,340 23,736 38,316 21,000 - 22,000 1,000 4.76% 9900 Transfer out - Water Fund 289,000 - 72,000 - - - 0.00% 9900 Transfer out - Sewer Fund - - - - - 83,000 83,000 #DIV/0! 9900 Transfer out - Storm Water Fund - - - 210,000 - (210,000) -100.00% Total other 300,340 23,736 110,316 231,000 - 105,000 (126,000) -54.55% Total expenditures 430,468 128,884 475,405 411,000 236,778 207,000 (24,000) 90.34% Net change in fund balance (245,468) 71,116 (263,405) (119,000) (236,778) 81,000 200,000 -168.07% Fund balance, beginning year 1,926,570 1,681,102 1,752,218 1,488,813 1,488,813 1,369,813 (119,000) -7.99% Fund balance, end of year 1,681,102 1,752,218 1,488,813 1,369,813 1,252,035 1,450,813 81,000 5.91% 71 Fund: 460 Vehicle & Equipment Fund Revenues Account Description 2013 2014 2015 2016 Description 3961 Transfers in 90,000 100,000 110,000 150,000 From General Fund ($256,000 5yr Fin Plan) 58,000 60,000 58,000 64,000 From Water Fund 36,000 36,000 53,000 42,000 From Sanitary Sewer Fund 16,000 16,000 71,000 32,000 From Storm Water Fund 200,000 212,000 292,000 288,000 Fund: 460 Department: 4160 Central Services Operations 7030 Equipment > $5000 - - - - 11 computers, software and network hardware reduce from $23,000. - - - - Fund: 460 Department: 4200 Police Operations 7030 Equipment > $5000 - - - - Squad mobile computers (2), light bar, (Police) - - - 10,000 Radar trailer - - - 10,000 7040 Vehicles 87,000 62,000 65,000 74,000 (2) SUV's $26,000 set-up's $11,000 87,000 62,000 65,000 74,000 Fund: 460 Department: 4360 Parks Operations 7030 Equipment > $5000 90,000 130,000 - - Parks mower (AEBI Terratrac TT705) - 17,500 - - Batwing mower for AEBI - - - 8,000 Utility cart 10,000 Engine for parks mower - - 115,000 - Parks mower ($13,500 Walker MTGHS mower move to 2017) 90,000 147,500 115,000 18,000 7040 Vehicles 36,000 63,000 - - Parks - 3/4 ton pick-up 36,000 63,000 - - Fund: 460 Department: 4460 Building & Grounds Operations 7030 Equipment > $5000 - - - - Replace City Hall entrance lights (Bldg & grnds) - - - - Fund: 460 Department: 4470 Pavement Management Operations 7030 Equipment > $5000 - - - - Brine solution equipment (Snow & Ice removal) - - - - Air compressor (1/2 parks 1/2 pavement mgt.) - - - - 7040 Vehicles - - - - Boom truck (Streets - pvmt mgt)(Carryover) - 25,000 - - Street maint 1/2 ton pick-up 40,000 70,000 - - Street maint 1 ton pick-up 40,000 95,000 - - 9900 Transfers out 18,000 81,600 21,000 22,000 Various equipment purchases general fund - - - 83,000 Sewer - Pickup 4x2 3/4 ton ($60,000) - - 210,000 - Storm Water - street sweeper (net of $40,000-$50,000 trade-in) - 72,000 - - Water - 3/4 ton pick-up 23,736 153,600 231,000 105,000 72 2016 Budget Summary Y-T-D 2012 2013 2014 2015 11/30/15 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Special Projects (Fund 480): Revenues 3552 Spec assessmt delinquent 68 - - - - - 0.00% 3553 Spec assessmt penalty & interes 186 256 - - - - 0.00% 3610 Investment income 8,881 (22,992) 33,985 2,000 (162) 6,000 4,000 200.00% 3680 Other revenue - - 4,000 - - - - 0.00% 3972 Transfers in - - 912,000 50,122 - 75,000 24,878 49.63% Total revenue 9,135 (22,736) 949,985 52,122 (162) 81,000 28,878 55.40% Operating expenses Operations (4160): Materials & supplies 1230 Supplies, equipment < $5,000 - - 11,881 - - - - 0.00% 1600 Supplies, operating - - 828 - - - - 0.00% Total materials & supplies - - 12,709 - - - - - Contractual services 3030 Other professional services - - 190 - - - 0.00% 5130 Repairs; Equipment - - 3,189 - - - - 0.00% Total contractual services - - 3,379 - - - - 0.00% Operations (4180): Contractual services 3030 Other professional services 13,305 22,057 5,969 4,500 2,438 - (4,500) -100.00% 5130 Repairs; Equipment 3,145 3,261 12,359 - - - - 0.00% Total contractual services 16,450 25,318 18,328 4,500 2,438 - (4,500) -100.00% Capital 7030 Capital equipment - 29,975 101,297 - 62,850 62,850 #DIV/0! 7050 Construction 245,228 189,977 198,075 413,000 38,274 815,000 402,000 97.34% Total capital outlays 245,228 219,952 299,372 413,000 38,274 877,850 464,850 112.55% Total expenses 261,678 245,270 333,788 417,500 40,712 877,850 460,350 110.26% Net change in fund balance (252,543) (268,006) 616,197 (365,378) (40,874) (796,850) (431,472) 118.09% Fund balance, beginning year 1,095,071 842,528 574,522 1,190,719 1,190,719 825,341 (365,378) -30.69% Fund balance, end of year 842,528 574,522 1,190,719 825,341 1,149,845 28,491 (796,850) -96.55% 73 Fund: 480 Special Projects Revenues Account Description 2013 2014 2015 2016 Description 3610 Investment income 10,000 6,000 2,000 6,000 Estimated interest earnings at 1%. 10,000 6,000 2,000 6,000 3972 Transfers in - - 50,122 75,000 Transfer from General Fund - - 50,122 75,000 Fund: 480 Department: 4180 Expenditures 3030 Other professional services 5,000 2,000 - - Scanning of microfilm to laser fiche - - 4,500 - Interior painting Police Department 5,000 2,000 4,500 - 7030 Capital, equipment > $5000 28,000 28,000 - - Purchase copiers (3) Main copier, police, comm dev/finance - 6,000 - - Card Key Access - City Hall 10,000 12,500 - - Council Chambers chairs/tables (50 chairs @ $150)(Defer) - 3,500 - - Dias chairs - - - 10,000 Park building video and door lock improvements 10,000 10,000 - 30,000 Video and Security improvements for CH and CC (BBC grant of $2,000) - - - 8,250 Road sensors 3 locations - - - 11,450 Automatic Transfer switch (City Hall generator) - - - 3,150 Upgrade CH electrical panel - 30,000 - - Unleaded fuel tank, pump, and monitoring equipment 40,000 - - - City Hall sign 88,000 90,000 - 62,850 7050 Construction > $25000 13,000 25,000 - - City Hall irrigation and landscape project ($10,000 defer to 2016) 100,000 - - - Pathway construction program - 79,500 200,000 200,000 PW Building Project (design phase)(construction in 2017) 20,000 200,000 150,000 375,000 Pathway rehabilitation program (Silver View Park) - - - 200,000 Splash Pad - 12,000 - - Police parking lot lighting - 30,000 - - Masonry renovation of CH & CC - 75,000 - - CC retro commissioning Improvements (phase 1) - - 25,000 - CC HVAC Improvements - 25,000 - - Cty Rd H sidewalk - - 30,000 - Remodel prep kitchen - - - 40,000 Remodel /Expand exercise area ($40,000 to 2016) - - 8,000 - Remodel Comm Ctr Admin offices 133,000 446,500 413,000 815,000 9900 Transfer to General Fund 45,000 90,000 - - 45,000 90,000 - - 74 2016 Budget Summary Y-T-D 2012 2013 2014 2015 11/30/15 2016 Change from 2015 Actual Actual Actual Budget Actual Request Dollar Percent Street Improvement (Fund 485): Revenues 3101 Property taxes 278,744 276,447 302,356 300,000 150,297 300,000 - 0.00% 3180 Franchise fee 219,581 259,070 336,711 255,000 241,794 265,000 10,000 3.92% 3319 Other federal grants 16,306 - - - - - - 0.00% 3352 MSA street construction 315,426 395,280 327,190 315,000 323,342 275,000 (40,000) -12.70% 3360 Other county grant - - - - 39,300 39,300 #DIV/0! 3550 Spec assessmt prepayment 40,229 49,226 42,215 20,000 29,512 20,000 - 0.00% 3610 Investment income 83,914 (220,669) 363,537 75,000 (2,399) 75,000 - 0.00% 3680 Other revenue 7,898 18,480 42,670 - 3,235 - - 0.00% 3972 Transfer from other funds 300,000 300,000 215,000 240,000 240,000 - 0.00% Total revenue 1,262,098 1,077,834 1,629,679 1,205,000 745,781 1,214,300 9,300 0.77% Operating expenses Operations (4470): Contractual services 3030 Other professional services - - 2,564 - - - - 0.00% Capital 7050 Construction 551,292 1,706,436 1,663,718 2,701,463 2,193,724 5,650,000 2,948,537 109.15% Total capital outlays 551,292 1,706,436 1,663,718 2,701,463 2,193,724 5,650,000 2,948,537 109.15% Total expenses 551,292 1,706,436 1,666,282 2,701,463 2,193,724 5,650,000 2,948,537 109.15% Net change in fund balance 710,806 (628,602) (36,603) (1,496,463) (1,447,943) (4,435,700) (2,939,237) 196.41% Fund balance, beginning year 7,143,574 7,854,380 7,225,778 7,189,175 7,189,175 5,692,712 (1,496,463) -20.82% Fund balance, end of year 7,854,380$ 7,225,778$ 7,189,175$ 5,692,712$ 5,741,232$ 1,257,012$ (4,435,700)$ -77.92% 75 Fund: 485 Street Improvement Revenues Account Description 2013 2014 2015 2016 Description 3101 Property taxes 300,000 300,000 300,000 300,000 General tax levy for streets 300,000 300,000 300,000 300,000 3180 Franchise fee 253,000 253,000 255,000 265,000 Half of the 4% franchase fee on gas & electric utilities 253,000 253,000 255,000 265,000 3352 MSA Street Construction 383,000 315,000 315,000 275,000 State aid funds 383,000 315,000 315,000 275,000 3360 Other County grants - - - 39,300 County trail grants - - - 39,300 3550 Special assessments - 20,000 20,000 20,000 Special assessments on private improvements - 20,000 20,000 20,000 3610 Investment income 80,000 75,000 75,000 75,000 Estimated interest earnings at 1%. 80,000 75,000 75,000 75,000 3972 Transfer in 300,000 300,000 240,000 240,000 Transfers from utility funds (water 25,000, sewer 140,000, storm 75,000) 300,000 300,000 240,000 240,000 1,214,300 Fund: 485 Department: 4470 Expenditures 3030 Other professional services - - - - - - - - 7050 Construction > $25000 - 94,805 - - 2013 Area F Street & Utility project 495,460 1,408,424 96,770 - 2014 Area G Street & Utility project - 247,771 1,856,049 373,885 2015 Area H Street & Utility project - - 348,644 3,964,115 2016 Area I Street & Utility project - - - 125,000 Mill and overlay - - - 285,000 Cty Rd H/10 intersection (MSA eligible)(City share)(Ramsey Co is lead) - - - 627,000 Trail segments 6 and 11 (County grant/match of $39,300) - - - 125,000 Cty Rd I and Quincy Intersection street lights - 50,000 50,000 75,000 Other pavement improvements (Silver View parking lot and trails) 90,000 375,000 350,000 75,000 Seal coat projects 585,460 2,176,000 2,701,463 5,650,000 76 2012 2013 2014 2015 Y-T-D 2016 Change from 2015 Actual Actual Actual Budget 11/30/15 Request Dollar Percent Water (Fund 700): Revenues 3424 Meter charge (4) - - - - - - 0.00% 3426 Reimbursed staff time - 100 - - - - - 0.00% 3551 Spec assessments-current 64,167 69,242 62,591 50,000 30,088 55,000 5,000 10.00% 3552 Spec assessments-delinquent 2,721 2,922 3,133 - 1,232 - - 0.00% 3553 Spec assess.-penalty & interest 2,904 1,713 647 170 - 0.00% 3610 Investment income 3,838 (8,287) 8,909 1,000 3 1,000 - 0.00% 3680 Other revenues 2,916 3,220 10,399 2,000 6,025 2,000 - 0.00% 3710 Water sales 806,698 777,150 768,838 906,974 784,568 906,974 - 0.00% 3712 Utility credits - 50 - - - - - 0.00% 3714 Water service fee 52,562 54,980 65,848 85,000 85,466 85,000 - 0.00% 3715 Utility connections 1,625 2,750 3,750 1,000 3,452 1,000 - 0.00% 3716 Penalties 6,837 7,011 7,022 4,000 10,498 5,000 1,000 25.00% 3913 Meter sales 1,806 1,269 855 - 3,208 - - 0.00% WAC/SWM charges 1,500 2,500 53,680 - 5,500 - - 0.00% 3972 Transfers - Vehicle & Equip 289,000 - 72,000 - - - - 0.00% Total revenue 1,236,570 914,620 1,057,672 1,049,974 930,210 1,055,974 6,000 0.57% Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 37,472 38,295 40,222 40,591 37,483 42,116 1,525 3.76% 0300 Social security 2,653 2,798 2,911 3,107 2,731 3,221 114 3.67% 0321 PERA 2,631 2,686 2,810 3,044 2,691 3,159 115 3.78% 0400 Group insurance 3,609 3,700 3,722 4,914 3,012 5,128 214 4.35% 0500 Workers compensation 216 234 311 360 437 476 116 32.22% Total personnel services 46,581 47,713 49,976 52,016 46,354 54,100 2,084 4.01% Materials & supplies 1600 Supplies, operating - - - 50 - 50 - 0.00% Total materials & supplies - - - 50 - 50 - 0.00% Contractual services 3030 Other professional services 7,120 6,901 6,891 8,142 8,040 8,289 147 1.81% 3300 Postage 3,727 3,232 3,330 4,426 2,686 4,377 (49) -1.11% 3430 Printing 802 881 - 900 271 900 - 0.00% 3630 Training - - - 1,500 - 1,500 - 0.00% 5130 Repairs, equipment 3,513 3,693 4,017 4,545 4,264 4,729 184 4.05% Total contractual services 15,162 14,707 14,238 19,513 15,261 19,795 282 1.45% Debt Service: 8010 Principal 215,000 230,000 - - - - - 0.00% 8020 Interest 8,650 680 - - - - - 0.00% 8030 Paying agent fees 431 - - - - - - 0.00% 8040 Continuing disclosure 725 - - - - - - 0.00% Total capital outlays 224,806 230,680 - - - - - 0.00% Miscellaneous: 9900 Transfers out to General Fund 65,410 67,372 69,393 71,475 - 73,619 2,144 3.00% 9900 Transfers out to Vehicle Fund 58,000 58,000 60,000 58,000 - 64,000 6,000 10.34% Total capital outlays 123,410 125,372 129,393 129,475 - 137,619 8,144 6.29% Total Billing 409,959 418,472 193,607 201,054 61,615 211,564 10,510 5.23% 149,038 157,464 2016 Budget Summary 77 Fund: 700 Department: 4820 Billing Services Account Description 2013 2014 2015 2016 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 6,840 6,977 7,742 7,889 24.5% of audit fee (up from 22.5%) 800 800 - - Inserting & mailing bills (move to 3300) 400 400 400 400 County special assessment maintenance fee 394 - - - Annual maintenance (meter reading software)(50% sewer, 50% Water) 8,434 8,177 8,142 8,289 3300 Postage 2,880 3,136 3,136 3,136 3200 bills X $0.49 postage X 4 billings X 1/2 cost - - 800 800 Inserting & mailing bills (moved from 3030) 450 460 490 441 Late notices: 450 bills X $0.49 postage X 4 billings X 1/2 cost 3,330 3,596 4,426 4,377 3430 Printing 450 450 450 450 Utility bills (1/2 cost) 450 450 450 450 Envelopes 900 900 900 900 3630 Training 250 1,500 1,500 1,500 Seminars on new regulations, software updates, etc. INCODE training 250 1,500 1,500 1,500 Defer INCODE Training to future year $1,250 5130 Repairs, equipment 3,339 3,506 3,682 3,866 INCODE software maintenance support (30%) - - 475 475 Neptune software maintenance (1/2 in sewer) 334 369 388 388 Handheld interface support for meter readers (1/2 in sewer)(Incode) 3,673 3,875 4,545 4,729 8010 Principal 230,000 - - - Principal due on bonds 230,000 - - - 8020 Interest 4,025 - - - Interest due on 2002 A Bonds 4,025 - - - 8030 Paying agent fees 475 - - - Paying agent fees on bond issues 475 - - - 8040 Continuing Disclosure 2,200 1,200 - - Annual debt disclosure requirements and Ramsey county sp. Assmt. Fees 2,200 1,200 - - 9900 Transfers out 67,372 69,393 71,475 73,619 Transfer to General Fund for administrative overhead costs 58,000 60,000 58,000 64,000 Transfer to Vehicle & Equipment Fund to fund future purchases 125,372 129,393 129,475 137,619 378,709 148,691 149,038 157,464 78 2012 2013 2014 2015 Y-T-D 2016 Change from 2015 Actual Actual Actual Budget 11/30/15 Request Dollar Percent Water (Fund 700): 2016 Budget Summary Infrastructure & Equip Maintenance (4823): Personnel services 0100 Salaries, regular 178,690 155,246 195,190 176,088 157,889 181,542 5,454 3.10% 0110 Salaries, overtime 5,947 11,268 12,053 9,231 9,961 9,669 438 4.74% 0150 Salaries, part-time 8,408 - 8,921 10,320 8,230 10,320 - 0.00% 0300 Social security 13,330 12,077 14,989 14,967 12,367 15,417 450 3.01% 0321 PERA 12,457 12,254 14,625 14,204 12,062 14,646 442 3.11% 0400 Group insurance 28,828 24,469 31,480 31,374 26,515 32,682 1,308 4.17% 0500 Workers compensation 5,459 6,020 8,784 7,660 9,304 10,137 2,477 32.34% Total personnel services 253,119 221,334 286,042 263,844 236,328 274,413 10,569 4.01% Materials & supplies 1210 Supplies, bldg & grnds 1,494 1,131 833 2,750 1,334 2,750 - 0.00% 1220 Supplies, vehicles 1,434 1,712 506 1,500 642 1,500 - 0.00% 1230 Supplies, equipment 3,898 10,607 21,853 1,625 6,774 1,625 - 0.00% 1240 Supplies, streets 4,825 11,191 2,226 3,000 5,012 3,000 - 0.00% 1250 Supplies, utilities 2,170 16,192 17,265 10,250 15,594 11,500 1,250 12.20% 1260 Supplies, traffic control - 257 200 200 - 200 - 0.00% 1600 Supplies, operating 4,562 8,812 8,615 5,800 7,802 5,800 - 0.00% 1700 Motor fuels 6,034 9,271 5,652 3,850 3,104 3,575 (275) -7.14% 2400 Uniforms 1,460 1,618 1,025 995 876 1,100 105 10.55% 2410 Mats & towels 1,657 642 634 775 629 620 (155) -20.00% Total materials & supplies 27,534 61,433 58,809 30,745 41,767 31,670 925 3.01% Contractual services 3030 Other professional services 9,548 7,310 20,946 8,630 6,008 22,630 14,000 162.22% 3100 Communications - telephone 2,277 2,535 2,435 2,715 2,540 3,056 341 12.56% 3200 Water & wastewater charges 12,740 7,286 6,398 7,200 8,346 7,200 - 0.00% 3220 Natural gas 5,999 7,668 8,336 7,000 6,311 7,000 - 0.00% 3610 Memberships 214 208 527 290 - 290 - 0.00% 3630 Training 4,489 1,676 2,737 3,850 1,932 3,850 - 0.00% 4010 Equipment rental 2,672 2,672 7,117 4,500 405 4,500 - 0.00% 4800 Insurance 18,165 7,023 6,754 10,230 6,860 10,230 - 0.00% 5110 Repairs, bldgs & grnds - 248 1,758 7,000 3,844 7,000 - 0.00% 5120 Repairs, vehicles - - - 1,000 20 1,000 - 0.00% 5130 Repairs, equipment 7,118 19,057 8,025 6,600 7,675 12,600 6,000 90.91% 5140 Repairs, streets 7,198 34,222 3,110 10,000 6,450 10,000 - 0.00% 5150 Repairs, utilities 1,530 2,148 14,516 17,500 18,515 17,500 - 0.00% 5155 Water service repair 59,509 170,240 121,561 80,000 71,104 80,000 - 0.00% 5160 Repairs, system maintenance 9,954 5,800 9,280 3,500 742 3,500 - 0.00% Total contractual services 141,413 268,093 213,500 170,015 140,752 190,356 20,341 11.96% Capital outlays 7030 Equipment - - - 56,750 1,039 133,708 76,958 135.61% 7050 Construction - - - 260,000 170,775 105,000 (155,000) -59.62% 7950 Depreciation 220,231 251,946 254,991 245,000 - 255,000 10,000 4.08% Total capital outlays 220,231 251,946 254,991 561,750 171,814 493,708 (68,042) -12.11% Miscellaneous: 9100 Contingency - - - 15,000 - 15,000 - 0.00% 9900 Transfer to Street Fund 100,000 100,000 - 25,000 - 25,000 - 0.00% Total miscellaneous 100,000 100,000 - 40,000 - 40,000 - 0.00% Total infrastructure & equip maint 742,297 902,806 813,342 1,066,354 590,661 1,030,147 (36,207) -3.40% 802,510 755,734 79 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance Account Description 2013 2014 2015 2016 Description 1210 Supplies, Bldgs & grounds 100 100 100 100 Mops, buckets, brooms 600 600 500 500 Light tubes & ballasts 200 200 200 200 Paper products 200 200 200 200 Paint, thinner, & brushes 1,000 1,000 750 750 Black dirt & sod/seed, landscaping materials 500 500 500 500 Misc. cleaners for well houses & % of shop 400 400 - - Fertilizer/seed/weed control 500 500 500 500 Irrigation parts 300 300 - - Goose repellent 3,800 3,800 2,750 2,750 1220 Supplies, vehicles 200 300 300 300 Air, oil, fuel, & transmission filters 100 100 100 100 Fluids 100 100 400 400 Batteries and tires 50 50 50 50 Paint sealant 150 150 150 150 Tune ups 200 300 500 500 Misc repairs 800 1,000 1,500 1,500 1230 Supplies, equipment < $5000 100 100 100 100 Tune ups 100 100 100 100 Grounds maintenance equipment 100 100 100 100 Blades, suction hoses, filter screens 175 175 175 175 Hydraulic fluid: 35 gallons @ $4.80 / gallon 200 200 200 200 Solvents & cleaning fluids 200 200 200 200 Air compressor & dehumidifier parts 2,100 1,500 500 500 Chemical equipment parts (fluoride pumps) 1,100 4,800 - - Fluoride tank replacement (3 tanks every 3 years)(2017 next) 250 250 250 250 Air, oil, fuel, & trans filters (emergency generator) 4,325 7,425 1,625 1,625 1240 Supplies, streets 3,000 3,000 3,000 3,000 Asphalt/concrete/sod/seed for patching minor street, curb, driveway repairs. 3,000 3,000 3,000 3,000 1250 Supplies, utilities - - - - Meter batteries (200 @ $25) 500 500 2,000 2,500 Paint & sandblasting materials for hydrants 500 500 500 500 Copper, steel & PVC pipe 1,500 1,500 1,500 1,500 Valve box risers, main repair clamps 1,000 1,000 250 1,000 Hydrant markers (new marker flags) 1,500 1,500 3,000 3,000 Hydrant parts 2,000 2,000 3,000 3,000 Meter supplies, etc. (move from account 1600) 2,000 - - - Motorized gate valve wrench 1,500 - - - Motorized hydrant wrench 1,500 - - - Hydrant cut-off tool 2,000 - - - Plasma cutter 14,000 7,000 10,250 11,500 1260 Supplies, traffic control 200 200 200 200 Traffic cones / safety vests 200 200 200 200 1600 Supplies, operating 500 500 500 500 Propane, acetylene & oxygen supplies 400 400 400 400 Gloves, masks, & rags 650 650 650 650 Film, first aid supplies, & batteries 1,500 2,000 2,500 2,500 Location flags & paint (moved from account 1250) 250 250 250 250 Cleaning supplies 1,000 1,000 1,500 1,500 Additional & replacement hand tools 4,300 4,800 5,800 5,800 1700 Motor fuels & lubs 450 675 700 650 Diesel fuel - 200 gallons @ $3.25 - - 450 450 Oil 200 - - - Propane: 50 gallons @ $4 5,200 5,200 2,700 2,475 Unleaded fuel: 900 gallons @ $2.75 5,850 5,875 3,850 3,575 2400 Uniforms 1,475 1,475 995 1,100 Uniforms 15.5% of $4,500 and clothing 1.7 FTE x $175 per contract 1,475 1,475 995 1,100 2410 Mats & towels 1,620 1,620 775 620 Share of floor mats & shop towels (15.5% of $4,000) 1,620 1,620 775 620 3030 Other professional services 180 180 180 180 Backflow prevention testing (3 @ $60 per test) 3,000 - - 3,000 Water system leak survey (every 2 years, next in 2018) 250 250 - - Water tower evaluation - - - 11,000 Production assessment - - 500 500 Broadleaf control - - 1,000 1,000 Asset management software 200 250 250 250 Fire sprinkler inspections/testing 200 200 200 200 Fire extinguisher inspection/service (10 @ $20) 2,750 2,750 1,500 1,500 Gopher State One-call locates 1,000 2,500 5,000 5,000 Arcview/GIS base map and engineering consulting 7,580 6,130 8,630 22,630 3100 Communications - telephone 400 400 400 400 Service & repair 1,570 1,570 1,505 1,846 Cellular phone service (20.06% of $9,200) - - 720 720 Data cards for SCADA (2)(75%) balance in Sewer 90 90 90 90 800 MHz license fee (33%)(5 radios @ $4.48 per month) 2,060 2,060 2,715 3,056 3200 Water and wastewater charges 7,200 7,200 7,200 7,200 7,200 7,200 7,200 7,200 80 THIS PAGE LEFT BLANK INTENTIONALLY 81 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance Account Description 2013 2014 2015 2016 Description 3220 Natural gas 8,500 7,000 7,000 7,000 Heating fuel 8,500 7,000 7,000 7,000 3610 Memberships 150 180 - - American Public Works Association (APWA)(25% of $710) 100 100 100 100 MN Rural Water Association (50%) 80 80 80 80 MN Safety Council (19% of $405) 50 50 50 50 Suburban Utility Superintendant Association (SUSA)(50% of $100) 60 60 60 60 Pressurized vessel license 440 470 290 290 3630 Training 250 250 250 250 Computer training/webinars - 1,200 1,200 1,200 Trench safety training (on-site)(not annual) 110 110 110 110 Hearing test/R2K (2.15 FTE * $50) 60 60 60 60 Maintenance Expo 820 820 820 820 Water operator class/exam/certificate ($205 per person) 200 200 200 200 Misc. training seminars 390 390 390 390 Equipment operator training 200 200 200 200 MRWA workshops 150 150 - - MN Public Works Assoc workshop 560 560 560 560 Tuition reimbursement - 60 60 60 Work zone safety seminar (every 3 years) 2,740 4,000 3,850 3,850 4010 Rental, equipment 3,500 3,500 4,000 4,000 Skid steer - upgrade 300 300 300 300 Barricades & signs 200 200 200 200 Tools & equipment 4,000 4,000 4,500 4,500 4800 Insurance 10,230 10,230 10,230 10,230 Share of property/liability insurance 10,230 10,230 10,230 10,230 5110 Repairs, buildings & grounds - 5,000 2,000 2,000 Door & lock repairs - 2,000 1,000 1,000 Roof & wall repairs - 3,000 3,000 3,000 Electrical & mechanical repairs - 1,000 1,000 1,000 Site repairs (pavement, fence, irrigation, etc...) - 11,000 7,000 7,000 5120 Repairs, vehicles - 1,500 1,000 1,000 Utility truck repairs - 1,500 1,000 1,000 5130 Repairs, equipment - - - - Chemical pump repairs 2,500 1,500 1,500 1,500 Well and water treatment plant repairs 1,500 1,500 1,500 1,500 Miscellaneous repairs (Backhoe, Skid steer) - 3,000 - - Backhoe tires - - - 3,500 Generator service - Onan - - - 2,500 VFD service - 1,500 1,500 1,500 Meter and valve repairs - 2,000 2,000 2,000 SCADA repairs 5,500 - - - 10" gate valve repair (well #3) 100 100 100 100 Radio repairs 9,600 9,600 6,600 12,600 5140 Repairs, streets 14,000 10,000 10,000 10,000 Contractor repairs to streets after water main breaks 14,000 10,000 10,000 10,000 5150 Repairs, utilities - - - - RTU panel repairs - - - - Electrical modifications & repairs - 5,000 5,000 5,000 Fire hydrant repairs - 5,000 5,000 5,000 Gate valve repairs 5,000 7,500 7,500 7,500 Water main repairs 5,000 17,500 17,500 17,500 5155 Water service repairs 50,000 50,000 65,000 65,000 Contractor repairs to residential water services. - 15,000 15,000 15,000 Pavement & curb repairs 50,000 65,000 80,000 80,000 5160 System maintenance 10,000 - - - Building repairs (moved to 5110) 3,500 3,500 3,500 3,500 Water system maintenance & repair items 7,500 7,000 - - Well #4 perimeter fencing 21,000 10,500 3,500 3,500 7030 Capital, equipment > $5000 17,000 15,000 15,000 15,000 Gate valves 10,500 - - - Plate compactor for backhoe - - - 31,958 SCADA system upgrades (automatic controls) - - - 35,000 Booster station (pressure valve) - - - 10,000 Water treatment plant (leaking valve) 8,500 14,000 14,000 14,000 Trench box - 2,750 2,750 2,750 Electric rain gauges SCADA System (33%)(total cost $8,250) - 7,500 - - Chemical feed equipment - 25,000 25,000 25,000 Security cameras & card key access - 5,000 - - Air Compressor (well #5) - 72,000 - - 3/4 ton pick-up 36,000 141,250 56,750 133,708 7050 Construction > $25000 - - - 80,000 Wells #4,5,6 building repairs (int. and exterior repairs) 250,000 350,000 200,000 - Reservoir & booster station building and roof repairs (carryover from 10,11) - - - 25,000 Water system upgrades wells #1,2 - - 60,000 - Well pump rehabilitation project (well no. 6) ($60,000 - 2015) 250,000 350,000 260,000 105,000 82 2012 2013 2014 2015 Y-T-D 2016 Change from 2015 Actual Actual Actual Budget 11/30/15 Request Dollar Percent Water (Fund 700): 2016 Budget Summary Water Production (4825): Personnel services 0100 Salaries, regular 842 361 269 25,391 21,674 25,900 509 2.00% 0110 Salaries, overtime - - - - 1,428 - - 0.00% 0300 Social security 61 26 19 1,942 1,619 1,981 39 2.01% 0321 PERA 60 26 19 1,904 1,732 1,943 39 2.05% 0400 Group insurance 104 36 41 4,752 4,102 4,944 192 4.04% 0500 Workers compensation - - - 1,390 1,688 1,799 409 29.42% Total personnel services 1,067 449 348 35,379 32,243 36,567 1,188 3.36% Materials & supplies 1600 Supplies, operating 32,574 32,919 27,583 35,175 20,586 35,175 - 0.00% 1700 Motor fuels - - - - - - - 0.00% 2400 Uniforms - - - 235 - 235 - 0.00% 2410 Mats & towels - - - 180 - 144 (36) -20.00% Total materials & supplies 32,574 32,919 27,583 35,590 20,586 35,554 (36) -0.10% Contractual services 3030 Other professional services 27,291 24,962 2,155 24,930 6,994 24,930 - 0.00% 3210 Electricity 93,188 107,531 103,552 108,000 85,992 108,000 - 0.00% Total contractual services 120,479 132,493 105,707 132,930 92,986 132,930 - 0.00% Total water production 154,120 165,861 133,638 203,899 145,815 205,051 1,152 0.56% 168,520 168,484 Total expenditures 1,306,376 1,487,139 1,140,587 1,471,307 798,091 1,446,762 (24,545) -1.67% Revenues over (under) expenditures (69,806) (572,519) (82,915) (421,333) 132,119 (390,788) 30,545 -7.25% Add back: capital outlays - - - 316,750 171,814 238,708 (78,042) -24.64% principal payment on debt 215,000 230,000 - - - - - 0.00% Change in net assets 145,194 (342,519) (82,915) (104,583) 303,933 (152,080) (47,497) 45.42% Net Assets, beginning year 4,273,002 4,418,196 4,075,677 3,992,762 3,992,762 3,888,179 (104,583) -2.62% Net Assets, end of year 4,418,196$ 4,075,677$ 3,992,762$ 3,888,179$ 4,296,695$ 3,736,099$ (152,080)$ -3.91% 1,120,068 1,081,682 83 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance 7950 Depreciation 240,000 240,000 245,000 255,000 Estimated depreciation 240,000 240,000 245,000 255,000 9100 Contingency 15,000 15,000 15,000 15,000 Contingency 15,000 15,000 15,000 15,000 9900 Transfers out 100,000 85,000 25,000 25,000 Water system upgrades in conjunction with major roadway program 100,000 85,000 25,000 25,000 822,720 1,033,635 802,510 755,734 Fund: 700 Department: 4825 Water Production Account Description 2013 2014 2015 2016 Description 1600 Supplies, operating 550 550 550 550 Computer supplies 800 800 800 800 Testing reagents 3,950 4,125 4,125 4,125 Sulfur dioxide: 25 150# cylinders @ $1.10 per pound 8,000 8,800 8,800 8,800 Chlorine: 8 - 1 ton cylinders @ .55 per pound 8,438 9,350 9,350 9,350 75 - 150 # cylinders @ $.83 6,600 7,400 7,400 7,400 Hydrofluosilic acid: 20,000 pounds @ $0.37 3,190 3,300 3,300 3,300 R-999 Buffer solution 2 - 55 gal drums @ $30 per gal. 850 850 850 850 Sand separator 400 - - - Water conservation program implementation 32,778 35,175 35,175 35,175 1700 Motor fuels & lubs 200 200 - - Turbine & electric motor oil 250 250 - - Oil for generators 1,800 - - - Diesel fuel for primary generator: 400 gallons @ $3.50 2,250 450 - - 2400 Uniforms - - 235 235 Uniforms 3.6% of $4,500 and clothing .4 FTE x $175 per contract - - 235 235 2410 Mats & towels - - 180 144 Share of floor mats & shop towels (3.6% of $4,000) - - 180 144 3030 Other professional services 960 960 960 960 Bacteria tests (8*$10*12 months) 800 800 800 800 Computer maintenance 1,000 1,000 1,000 1,000 Consumer confidence report 7,500 10,000 10,000 10,000 DNR water permit fee (annual surcharge) 300 300 300 300 Emergency Response Commission fees 1,120 1,120 1,120 1,120 Full scan tests - 4 @ $280 600 600 600 600 Minimum contamination level (MCL) tests 1,000 1,000 1,000 1,000 Radon tests 800 800 800 800 Random sample tests 825 1,050 1,050 1,050 MCES discharge permits (3*$350) 300 300 300 300 MNDPS - EPCRA program ($100/WTP) 15,000 10,000 7,000 7,000 Well head protection plan (req. by Dept. of Health) 30,205 27,930 24,930 24,930 3210 Electricity 80,000 95,000 108,000 108,000 Electricity for wells, tower & reservoir 80,000 95,000 108,000 108,000 3630 Training - - - - General training - - - - 145,233 158,555 168,520 168,484 1,346,662 1,340,881 1,120,068 1,081,682 -12.96%-0.43%-16.47%-3.43% 84 2016 Budget Summary 2012 2013 2014 2015 Y-T-D 2016 Change from 2015 Actual Actual Actual Budget 11/30/15 Request Dollar Percent Sanitary Sewer (Fund 730): Revenues 3551 Spec. Assessments 502 78 - - 13,105 - - 0.00% 3610 Investment income 31,367 (79,782) 128,382 30,000 (818) 30,000 - 0.00% 3680 Other revenues 750 - 30,000 - - - - 0.00% 3716 Penalties 8,018 7,678 9,117 6,000 13,124 6,000 - 0.00% 3720 Utility sales 1,182,806 1,227,815 1,301,911 1,410,821 1,379,609 1,410,821 - 0.00% 3721 SAC charges (464) (1,753) 13,170 - (2,013) - - 0.00% 3725 Utility connections 350 850 1,200 - 1,800 - - 0.00% 3726 Penalties & interest 545 811 603 - 612 - - 0.00% 3972 Transfers from Vehicle Fund - - - - - 83,000 83,000 #DIV/0! Total revenue 1,223,874 1,155,697 1,484,383 1,446,821 1,405,419 1,529,821 83,000 5.74% Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 37,472 38,295 40,222 40,591 37,505 42,116 1,525 3.76% 0300 Social security 2,653 2,798 2,911 3,107 2,736 3,221 114 3.67% 0321 PERA 2,630 2,686 2,809 3,044 2,694 3,159 115 3.78% 0400 Group insurance 3,609 3,701 3,721 4,914 3,015 5,128 214 4.35% 0500 Workers compensation 216 233 311 360 437 476 116 32.22% Total personnel services 46,580 47,713 49,974 52,016 46,387 54,100 2,084 4.01% Materials & supplies 1600 Supplies, operating - - - 50 - 50 - 0.00% Total materials & supplies - - - 50 - 50 - 0.00% Contractual services 3030 Other professional services 7,120 6,901 6,780 7,742 7,620 7,889 147 1.90% 3300 Postage 3,727 3,231 3,330 4,426 2,686 4,426 - 0.00% 3430 Printing 802 801 - 900 271 900 - 0.00% 3630 Training - - - 1,500 - 1,500 - 0.00% 5130 Repairs, equipment 3,513 3,693 4,017 4,544 4,264 4,729 185 4.07% Total contractual services 15,162 14,626 14,127 19,112 14,841 19,444 332 1.74% Miscellaneous: 9900 Transfers out to General Fund 51,807 53,361 54,962 56,611 - 58,309 1,698 3.00% 9900 Transfers out to Vehicle Fund 36,000 36,000 36,000 53,000 - 42,000 (11,000) -20.75% Total miscellaneous 87,807 89,361 90,962 109,611 - 100,309 (9,302) -8.49% Total Billing 149,549 151,700 155,063 180,789 61,228 173,903 (6,886) -3.81% 128,773 119,803 Infrastructure & Equip Maintenance (4823): Personnel services 100 Salaries, regular 165,270 167,543 192,664 202,260 168,285 203,566 1,306 0.65% 110 Salaries, overtime 5,852 7,884 7,942 8,078 4,833 8,241 163 2.02% 150 Salaries, part-time 8,885 11,503 - 11,520 8,230 11,520 - 0.00% 300 Social security 12,857 13,641 13,753 16,974 12,707 17,085 111 0.65% 321 PERA 12,210 12,788 13,885 16,082 12,448 16,191 109 0.68% 400 Group insurance 26,151 27,159 30,670 35,640 27,753 37,116 1,476 4.14% 500 Workers compensation 4,954 5,413 8,245 8,383 10,183 10,817 2,434 29.03% Total personnel services 236,179 245,931 267,159 298,937 244,439 304,536 5,599 1.87% 85 Fund: 730 Department: 4820 Billing Services Account Description 2013 2014 2015 2016 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 825 825 - - Inserting & mailing bills (move to 3300) 375 375 - - Annual maintenance (moved to 5130) 6,840 6,977 7,742 7,889 24.5% of audit fee (up from 22.5%) 8,040 8,177 7,742 7,889 3300 Postage 2,880 3,136 3,136 3,136 3200 bills X $0.49 postage X 4 billings X 1/2 cost - - 800 800 Inserting & mailing bills (moved from 3030) 450 460 490 490 Late notices: 500 bills X $0.49 postage X 4 billings X 1/2 cost 3,330 3,596 4,426 4,426 3430 Printing 450 450 450 450 Envelopes 450 450 450 450 Utility bills (1/2 cost) 900 900 900 900 3630 Training 250 1,500 1,500 1,500 Seminars on new regulations, software updates, etc. INCODE training (new) 250 1,500 1,500 1,500 Defer INCODE training to a future year $1,250 5130 Repairs, equipment 3,339 3,506 3,681 3,866 Incode software support (30%) - - 475 475 Neptune software maintenance (1/2 in water) 334 369 388 388 Handheld interface support for meter readers (50% water 50% sewer) 3,673 3,875 4,544 4,729 9900 Transfers out 53,361 54,962 56,611 58,309 Transfer to General Fund for admin costs 36,000 36,000 53,000 42,000 Transfer to Vehicle & Equipment Fund for vehicle use 89,361 90,962 109,611 100,309 105,604 109,060 128,773 119,803 86 2016 Budget Summary 2012 2013 2014 2015 Y-T-D 2016 Change from 2015 Actual Actual Actual Budget 11/30/15 Request Dollar Percent Sanitary Sewer (Fund 730): Materials & supplies 1210 Supplies, bldg & grnds - 151 - 200 - 200 - 0.00% 1220 Supplies, vehicles 2,635 590 1,872 2,775 244 1,575 (1,200) -43.24% 1230 Supplies, equipment 6,580 4,636 7,895 4,650 2,222 4,650 - 0.00% 1240 Supplies, streets - - - 3,000 - 3,000 - 0.00% 1250 Supplies, utilities 1,541 571 112 5,850 903 3,350 (2,500) -42.74% 1260 Supplies, traffic control - 447 325 300 - 300 - 0.00% 1600 Supplies, operating 9,045 12,952 11,944 12,250 2,764 14,250 2,000 16.33% 1700 Motor fuels 8,158 4,347 4,789 5,200 3,579 4,875 (325) -6.25% 2400 Uniforms 1,360 1,304 1,168 1,169 854 1,169 - 0.00% 2410 Mats & towels 1,657 642 634 910 629 728 (182) -20.00% Total materials & supplies 30,976 25,640 28,739 36,304 11,195 34,097 (2,207) -6.08% Contractual services 3030 Other professional services 1,824 1,263 6,697 5,700 1,225 5,700 - 0.00% 3100 Communications - telephone 1,554 1,659 1,492 1,785 1,314 2,115 330 18.49% 3200 Water & sewer 3,102 3,328 3,301 3,000 2,508 3,000 - 0.00% 3210 Electricity 1,845 2,306 2,668 2,300 2,082 2,300 - 0.00% 3230 Wastewater disposal - MCES 760,913 816,267 827,962 832,084 837,241 898,071 65,987 7.93% 3610 Memberships - - 153 230 - 230 - 0.00% 3630 Training 3,054 2,470 2,258 4,450 1,693 4,450 - 0.00% 4010 Equipment rental - - - 500 - 500 - 0.00% 4800 Insurance 4,647 7,951 9,024 7,300 7,452 7,300 - 0.00% 5130 Repairs, equipment 10,563 706 10,899 8,750 3,259 8,750 - 0.00% 5140 Repairs, streets - - - 10,000 - 10,000 - 0.00% 5150 Repairs, utilities 265 4,065 3,941 17,500 719 17,500 - 0.00% 5155 Utility service repairs 6,850 53,846 10,827 - - - - 0.00% 5160 Repairs, maintenance 1,150 10,893 9,665 33,500 2,418 33,500 - 0.00% Total contractual services 795,767 904,754 888,887 927,099 859,911 993,416 66,317 7.15% Capital outlays 7030 Equipment - - - 14,750 11,857 44,750 30,000 203.39% 7050 Construction - - - 600,000 64 250,000 (350,000) -58.33% 7950 Depreciation 165,698 166,533 165,752 167,000 - 167,000 - 0.00% Total capital outlays 165,698 166,533 165,752 781,750 11,921 461,750 (320,000) -40.93% Miscellaneous: 9100 Contingency - - - 15,000 - 15,000 - 0.00% 9900 Transfer to Street fund 160,000 160,000 140,000 140,000 - 140,000 - 0.00% Total miscellaneous 160,000 160,000 140,000 155,000 - 155,000 - 0.00% 1,900,153 1,644,263 Total infrastructure & equip maint 1,388,620 1,502,858 1,490,537 2,199,090 1,127,466 1,948,799 (250,291) -11.38% Total expenditures 1,538,169 1,654,558 1,645,600 2,379,879 1,188,694 2,122,702 (257,177) -10.81% Revenues over (under) expenditures (314,295) (498,861) (161,217) (933,058) 216,725 (592,881) 340,177 -36.46% Add back: capital outlays - - - 614,750 11,921 294,750 (320,000) -52.05% Change in net assets (314,295) (498,861) (161,217) (318,308) 228,646 (298,131) 20,177 -6.34% Net Assets, beginning of year 5,228,379 4,914,084 4,415,223 4,254,006 4,254,006 3,935,698 (318,308) -7.48% Net Asset, end of year 4,914,084$ 4,415,223$ 4,254,006$ 3,935,698$ 4,482,652$ 3,637,567$ (277,954)$ -7.06% 2,028,926 1,764,066 87 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance Account Description 2013 2014 2015 2016 Description 1210 Supplies, bldgs & grounds 100 100 100 100 Paint, bulbs, fuses, etc 100 100 100 100 Seed, dirt, sod, etc 200 200 200 200 1220 Supplies, vehicles 75 75 75 75 Air, oil, fuel & transmission filters 775 775 775 775 Fluids 125 125 125 125 Repair & replacement parts 600 600 600 600 Tires & batteries - 1,200 1,200 - Back-up camera for televising van 1,575 2,775 2,775 1,575 1230 Supplies, equipment < $5000 650 650 650 650 Tune up parts 500 500 500 500 Hydraulic fluids & hoses 200 200 200 200 Cutting edges (skid loader) 300 300 300 300 Misc. replacement & repair parts 300 300 300 300 Light equip misc replacement & repair parts 1,000 1,500 2,000 2,000 Camera track and parts (CCTV) 300 300 300 300 Minor repairs - 500 100 100 Gas detection device parts and supplies 1,500 4,000 300 300 Vactor cleaning nozzle parts and supplies 4,750 8,250 4,650 4,650 1240 Supplies, streets 200 200 200 200 Tack coat 300 300 300 300 Dewatering rock/agg. base 2,500 2,500 2,500 2,500 Asphalt mix 3,000 3,000 3,000 3,000 1250 Supplies, utilities 100 1,500 1,500 1,500 Replacement pumps & motors 100 100 100 100 Filters, packings, relays, etc 300 300 300 300 Speed crete (mortar) 700 700 700 700 Repair parts 2,500 2,500 2,500 - Portable flow meter 750 750 750 750 Manhole covers, adjust rings & bolts 4,450 5,850 5,850 3,350 1260 Supplies, traffic control 300 300 300 300 Traffic cones, work zone sign face, safety vests 300 300 300 300 1600 Supplies, operating 500 500 500 500 Additional & replacement hand tools 250 250 250 250 Glove & paper products 150 150 150 150 Disinfectant supplies 500 500 500 500 Camera supplies 200 200 200 200 First aid supplies, protective equip 400 400 400 400 CD's, DVD's, software 500 500 250 250 Engineering supplies 700 700 700 700 Shop supplies, fastners, soap, degreasers, steet, batteries 500 500 500 500 Pipe, fittings, and accessories (connectors) 1,500 2,000 500 500 Locating supplies (paint, flags, markers, etc.) 500 2,000 8,000 10,000 Chemical blocks for lift stations 600 500 300 300 Filter replacement for sewer gas monitors 6,300 8,200 12,250 14,250 1700 Motor fuels & lubs 300 300 300 300 Fluids 600 600 600 600 Motor oil - 100 gallons $6 gal. 4,000 4,000 1,500 1,375 Unleaded fuel 500 gallons @ $2.75 3,600 3,600 2,800 2,600 Diesel fuel 800 gallons @ $3.25 8,500 8,500 5,200 4,875 2400 Uniforms 1,475 1,475 1,169 1,169 Uniforms 18.2% of $4,500 and clothing 2.0 FTE x $175 per contract 1,475 1,475 1,169 1,169 2410 Mats & towels 1,620 1,620 910 728 Share of floor mats & shop towels (18.2% of $4,000) 1,620 1,620 910 728 3030 Other professional services 2,750 2,750 1,500 1,500 Gopher State One Call locates - 600 600 600 Consulting engineering services - annual lift station inspections 100 100 100 100 Fire extinguisher inspection/servcie (5 @ $20) - - 1,000 1,000 Asset management software 2,500 2,500 2,500 2,500 Arcview/GIS base map and engineering consulting 5,350 5,950 5,700 5,700 3100 Communications - telephone 1,570 1,570 1,455 1,785 Cellular phone service (19.4% of $9,200) - - 240 240 Data cards for SCADA (2)(25%) balance in Water 90 90 90 90 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month) 1,660 1,660 1,785 2,115 3200 Water & Sewer service 2,600 2,600 3,000 3,000 Estimated annual charge 2,600 2,600 3,000 3,000 3210 Electricity 2,100 2,100 2,300 2,300 Electricity for lift stations 2,100 2,100 2,300 2,300 43,880 52,480 49,089 47,212 88 THIS PAGE LEFT BLANK INTENTIONALLY 89 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance (continued) Account Description 2013 2014 2015 2016 Description 3230 Met Council Environ. Servies 816,267 822,568 832,084 892,571 Annual charge (7.27% increase for 2016)($74,380.92/mo) - - - 5,500 Strength Charge (new charge from MCES) 816,267 822,568 832,084 898,071 3610 Memberships 100 100 100 100 MN Rural Water Assoc. (50%) 50 50 50 50 Suburban Utility Superintendant Association (SUSA)(50% of $100) 80 80 80 80 MN Safety Council (20%) 230 230 230 230 3630 Training 1,400 1,400 1,400 1,400 Collection operators training/renewal ($350 per person) 560 560 560 560 Tuition reimbursement (PW Mgt. Class - North Hennepin CC) 250 250 250 250 Computer training/webinars 110 110 110 110 Hearing test/R2K (2.15 FTE * $50) 1,200 1,200 1,200 1,200 Confined space seminar (on-site)(not annual) 320 320 - - Metro school - 120 120 120 Pesticide applicators license 300 300 300 300 Miscellaneous wastewater training 60 60 60 60 Maintenance Expo 390 390 390 390 Equipment operator training - 60 60 60 Work zone safety seminar (every 3 years) 4,590 4,770 4,450 4,450 4010 Rental, equipment 1,000 500 500 500 Barricades & signs 1,000 500 500 500 4800 Insurance 7,300 7,300 7,300 7,300 Share of property/liability insurance 7,300 7,300 7,300 7,300 5130 Repairs, equipment 2,500 2,500 2,500 2,500 Repairs to motors & pumps 2,500 2,500 2,500 2,500 Repairs to Vactor (jet truck) 2,500 2,500 2,500 2,500 Repairs to camera van and camera equipment 1,000 1,000 1,000 1,000 Repairs to utility truck 250 250 250 250 Misc repairs 8,750 8,750 8,750 8,750 5140 Repairs, streets - - 10,000 10,000 Contractor restoration of pavement, bwd., etc... - - 10,000 10,000 5150 Repairs, utilities 2,500 2,500 2,500 2,500 Lift station repairs - - 15,000 15,000 Sanitary collection system repairs 2,500 2,500 17,500 17,500 5160 System maintenance 15,000 15,000 - - Sanitary collection system repairs 25,000 25,000 25,000 25,000 Root control 15,000 15,000 - - Contractor restoration of pavement, bwd., etc... 4,500 4,500 4,500 4,500 Lift station maintenance/cleaning/pump service - 4,000 4,000 4,000 Sewer debris disposal costs 59,500 63,500 33,500 33,500 7030 Capital, equipment > $5000 30,000 30,000 - - Generator - trailer mounted (carryover) - - - 30,000 Generator - Bronson (natural gas) - 2,750 2,750 2,750 Electronic rain gauges for SCADA (33%)(total cost $8,250) - 12,000 12,000 12,000 Grinder station for Bronson lift station - 3,000 - - Camera Cable (Sewer & Storm Water) 30,000 47,750 14,750 44,750 7050 Construction > $25000 125,000 250,000 250,000 250,000 Sewer pipe relining program (carryover from 12,13) - - 350,000 - Groveland lift station rehabilitation (with area H project) 125,000 250,000 600,000 250,000 7950 Depreciation 160,000 167,000 167,000 167,000 Estimated depreciation 160,000 167,000 167,000 167,000 9100 Contingency 15,000 15,000 15,000 15,000 Contingency - may include lift station impeller replacement at Bronson 15,000 15,000 15,000 15,000 9900 Transfer out 160,000 140,000 140,000 140,000 Sewer system upgrades in conjunction with major roadway program 160,000 140,000 140,000 140,000 1,390,137 1,529,868 1,851,064 1,597,051 90 2012 2013 2014 2015 Y-T-D 2016 Change from 2015 Actual Actual Actual Budget 11/30/15 Request Dollar Percent Street Lighting (Fund 740): Revenues 3610 Investment income 1,262 (3,218) 5,251 1,300 (36) 1,300 - 0.00% 3716 Penalties 650 679 603 500 867 500 - 0.00% 3740 Street lighting charges 75,581 81,946 87,449 91,567 91,310 97,290 5,723 6.25% Total revenue 77,493 79,407 93,303 93,367 92,141 99,090 5,723 6.13% Operating expenses Operations (4416) Personnel services 0100 Salaries, regular 2,734 2,617 2,768 6,470 5,919 6,600 130 2.01% 0110 Salaries, overtime - - - - 87 - - 0.00% 0300 Social security 188 189 189 495 429 505 10 2.02% 0321 PERA 195 198 202 415 446 424 9 2.17% 0400 Group insurance 550 575 588 594 1,034 618 24 4.04% 0500 Workers compensation 17 19 22 285 346 313 28 9.82% Total personnel services 3,684 3,598 3,769 8,259 8,261 8,460 201 2.43% Materials & supplies 1600 Supplies, operating - - - 1,000 - 1,000 - 0.00% Contractual services 3030 Other professional services - - - - 796 - - 0.00% 3210 Electricity 78,023 87,326 62,996 90,000 62,172 78,000 (12,000) -13.33% 4800 Insurance 573 618 594 900 603 900 - 0.00% 5150 Repairs, utilities 133 5,032 1,409 3,000 291 3,000 - 0.00% Total contractual services 78,729 92,976 64,999 93,900 63,862 81,900 (12,000) -12.78% Other 8011 Lease payable (Energy Savings - - - - 7,167 9,556 9,556 #DIV/0! 9900 Transfer to General Fund 2,320 2,390 2,462 2,536 - 2,612 76 3.00% Total other 2,320 2,390 2,462 2,536 7,167 12,168 9,632 379.81% Total expenditures 84,733 98,964 71,230 105,695 79,290 103,528 (2,167) -2.05% Revenues over (under) expenditures (7,240) (19,557) 22,073 (12,328) 12,851 (4,438) 7,890 -64.00% Add back: Capital outlays/Prin on debt - - - - 7,167 9,556 9,556 #DIV/0! Change in net assets (7,240) (19,557) 22,073 (12,328) 20,018 5,118 17,446 -141.52% Net assets, beginning year 142,146 134,906 115,349 137,422 137,422 125,094 (12,328) -8.97% Net assets, end of year 134,906$ 115,349$ 137,422$ 125,094$ 157,440$ 130,212$ 5,118$ 4.09% 97,436 95,068 2016 Budget Summary 91 Fund: 740 Street Lighting Fund Revenues Account Description 2013 2014 2015 2016 Description 3610 Interest revenue 1,500 1,300 1,300 1,300 Estimated interest earnings at 1%. 1,500 1,300 1,300 1,300 3716 Penalties 500 500 500 500 Estimated late fees on street lighting charges. 500 500 500 500 3740 Street lighting charges 79,900 88,364 91,567 97,290 Estimated utility charges for street lighting. 79,900 88,364 91,567 97,290 Fund: 740 Department: 4416 Operations 1600 Supplies, operating - 1,000 1,000 1,000 Bulbs, ballasts, covers, etc... - 1,000 1,000 1,000 3210 Electricity 83,000 83,000 90,000 78,000 Estimate 83,000 83,000 90,000 78,000 4800 Insurance 900 900 900 900 Share of property/liability insurance 900 900 900 900 5150 Repairs, utilities 3,000 3,000 3,000 3,000 Repairs to street and trail lighting. 3,000 3,000 3,000 3,000 5170 Utility conversion costs - - - - Conversion of street lights to Xcel ownership. - - - - 8011 Lease payable (capital)- - - 9,556 Energy savings program (LED trail lighting) 9900 Transfer out 2,390 2,462 2,536 2,612 Transfer to General Fund for administrative overhead costs 2,390 2,462 2,536 12,168 89,290 90,362 97,436 95,068 12.71%1.20%7.83%-2.43% 92 2016 Budget Summary 2012 2013 2014 2015 Y-T-D 2016 Change from 2015 Actual Actual Actual Budget 11/30/15 Request Dollar Percent Storm Water (Fund 745): Revenues 3610 Investment income (charge 18,879 (51,529) 85,811 15,000 (586) 15,000 - 0.00% 3716 Penalties & interest 2,093 2,215 1,706 - 2,449 - - 0.00% 3718 Impact charges 636 - 0.00% 3730 Surface water charges 264,302 266,372 276,652 265,000 267,687 270,000 5,000 1.89% 3972 Transfer from other funds - - - 210,000 - - (210,000) -100.00% Total revenue 285,274 217,058 364,169 490,000 270,186 285,000 (205,000) -41.84% Operating expenses System Maintenance (4415): Personnel services 0100 Salaries, regular 49,428 53,978 61,400 71,361 60,043 71,821 460 0.64% 0110 Salaries, overtime 1,898 3,198 6,511 1,212 1,672 1,236 24 1.98% 0150 Salaries, part-time 3,311 6,139 5,910 2,640 5,452 2,640 - 0.00% 0300 Social security 4,100 4,682 5,553 5,754 4,990 5,792 38 0.66% 0321 PERA 3,638 3,589 4,780 5,443 4,484 5,479 36 0.66% 0400 Group insurance 7,651 2,864 3,750 12,420 4,664 12,972 552 4.44% 0500 Workers compensation 3,433 3,748 5,608 5,476 6,652 7,062 1,586 28.96% Total personnel services 73,459 78,198 93,512 104,306 87,957 107,002 2,696 2.58% Materials & supplies 1230 Supplies, equipment 5,511 7,106 1,201 3,250 1,196 3,250 - 0.00% 1240 Supplies, streets - - - 300 - 300 - 0.00% 1600 Supplies, operating 2,178 2,741 3,297 5,675 2,504 6,725 1,050 18.50% 1700 Motor fuels 1,767 3,078 3,901 2,700 2,971 2,475 (225) -8.33% 2100 Books/Periodicals - - 39 100 - 100 - 0.00% 2400 Uniforms 918 768 393 470 492 470 - 0.00% 2410 Mats & towels 829 321 285 365 264 292 (73) -20.00% Total materials & suppli 11,203 14,014 9,116 12,860 7,427 13,612 752 5.85% Contractual services 3030 Other professional services 6,988 6,482 17,537 12,206 4,475 12,227 21 0.17% 3100 Telephone 1,122 697 645 725 783 872 147 20.28% 3610 Memberships 914 937 345 1,035 950 1,035 - 0.00% 3630 Training 1,329 368 1,534 2,445 697 2,445 - 0.00% 4800 Insurance 4,031 3,559 4,027 4,000 4,492 4,000 - 0.00% 5120 Repairs, vehicles - 1,624 192 1,500 46 1,500 - 0.00% 5150 Repairs, utilities 265 - 50,366 50,000 8,007 50,000 - 0.00% Total contractual service 14,649 13,667 74,646 71,911 19,450 72,079 168 0.23% Capital outlays 7030 Equipment - - - 2,750 - 15,725 12,975 471.82% 7050 Construction - - - 100,000 - 75,000 (25,000) -25.00% 7950 Depreciation 31,397 30,708 32,503 32,000 - 32,000 - 0.00% Total capital outlays 31,397 30,708 32,503 134,750 - 122,725 (12,025) -8.92% Miscellaneous: 9900 Transfer out 46,756 46,959 82,168 82,383 - 82,604 221 0.27% Total miscellaneous 46,756 46,959 82,168 82,383 - 82,604 221 0.27% Total System Maintenance 177,464 183,546 291,945 406,210 114,834 398,022 (8,188) -2.02% 301,904 291,020 0.00% 93 Fund: 745 Storm Water Revenues Account Description 2013 2014 2015 2016 Description 3610 Interest revenue 22,000 22,000 15,000 15,000 Estimated interest earnings at 1%. 22,000 22,000 15,000 15,000 3730 Utility sales 250,718 265,000 265,000 270,000 Estimated surface water charges. 250,718 265,000 265,000 270,000 3972 Transfers - Vehicle & equip Fd 40,000 - 210,000 - Transfer for capital equipment purchases 40,000 - 210,000 - Fund: 745 Department: 4415 System Maintenance 1230 Supplies, equipment < $5000 250 1,500 1,500 1,500 Miscellaneous equipment & parts (AEBI parts, pole camera parts) - 1,250 1,250 1,250 Filters, brakes, bulbs, wipers, tires, batteries, etc... 2,500 - - - Leveling bar for skidsteer 3,500 - - - Winch for pick-up truck 3,700 - - - Tommy gate fro pick-up truck 600 - - - Truck springs 1,000 500 500 500 Hoses & nozzles 11,550 3,250 3,250 3,250 1240 Supplies, streets 300 300 300 300 Bituminous mix 300 300 300 300 1600 Supplies, operating 250 250 250 250 Concrete 2,450 2,450 2,450 3,500 Rain Garden mix, riprap, topsoil, seed and sod 175 175 175 175 Concrete adjustment rings 150 150 150 150 Hand tools 175 150 150 150 CD's, DVD's, software upgrade for camera van 2,500 2,500 2,500 2,500 Catch basin castings, pipe, approns, etc... 5,700 5,675 5,675 6,725 1700 Motor fuels 1,350 1,350 - - 300 gallons diesel fuel @ $3.75 / gallon for Vactor 2,000 2,000 2,700 2,475 900 gallons unleaded @ $2.75 for utility truck 3,350 3,350 2,700 2,475 2100 Books/Periodicals 100 100 100 100 Storm water books/periodicals 100 100 100 100 2400 Uniforms 740 740 470 470 Uniforms/clothing (7.3% of $4,500, .8 FTE x $175 per contract) 740 740 470 470 2410 Mats & towels 810 810 365 292 Share of floor mats & shop towels (7.3% of $4,000) 810 810 365 292 3030 Other professional services 5,000 7,500 7,500 7,500 Consulting engineers (SWPPP, Studies, etc...) 1,250 2,500 2,500 2,500 Arcview/GIS base map consulting - 12,500 - - Silverview pond sediment removal - - 1,000 1,000 Asset management software 100 100 100 100 Fire extinguisher inspection/servcie (5 @ $20) 760 775 1,106 1,127 Audit fees 3.5% (up from 2.5%) 7,110 23,375 12,206 12,227 3100 Communications 690 690 635 782 Cell Phone (8.5% of $9,200) 90 90 90 90 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month) 780 780 725 872 3610 Memberships 150 180 190 190 American Public Works Association (APWA)(25% of $710) 725 750 800 800 Minnesota Cities Storm Water Coalition 45 45 45 45 MN Safety Council (11% of $405) 920 975 1,035 1,035 3630 Training 200 200 200 200 Seminars & training sessions (Stormwater) 55 55 55 55 Hearing test/R2K (1.1 FTE * $50) 350 350 350 350 Safety training 750 750 500 500 NPDES compliance training 1,250 1,250 750 750 Tuition reimbursement 270 270 270 270 Erosion & Stormwater Maint. Certification 220 220 220 220 Equipment operator training 100 100 100 100 Computer/webinar training 3,195 3,195 2,445 2,445 4010 Equipment rental - - - 6,000 Rent mini excavater for clean-outs - - - 6,000 4800 Insurance 1,900 2,500 2,500 2,500 Share of property/liability insurance - 1,500 1,500 1,500 Deductible 1,900 4,000 4,000 4,000 5120 Repairs, vehicles 1,500 1,500 1,500 1,500 Utility truck & equipment repairs 1,500 1,500 1,500 1,500 5150 Repairs & maint., utilities 25,000 25,000 50,000 44,000 Repair & maintain storm sewers, ponds, basins, and drainage issues 10,000 - - - Storm Sewer slip linning improvements 35,000 25,000 50,000 44,000 7030 Equipment > $5000 4,000 - - - Small generator for trailer 5,000 - - - Concrete mixer - - - 12,975 Trailer for backhoe - 3,000 - - Camera Cable (Sewer & Storm Water) - 12,000 - - Flail mower for AEBI - 2,750 2,750 2,750 Electronic rain gauges for SCADA (33%)(total cost $8,250) 9,000 17,750 2,750 15,725 94 2016 Budget Summary 2012 2013 2014 2015 Y-T-D 2016 Change from 2015 Actual Actual Actual Budget 11/30/15 Request Dollar Percent Storm Water (Fund 745): Street Sweeping (4417): Personnel services 0100 Salaries, regular 8,174 7,588 8,695 11,202 10,444 11,427 225 2.01% 0110 Salaries, overtime 256 304 306 1,212 305 1,236 24 1.98% 0300 Social security 596 547 637 950 797 969 19 2.00% 0321 PERA 570 525 642 931 781 950 19 2.04% 0400 Group insurance 1,482 914 1,220 2,160 857 2,256 96 4.44% 0500 Workers compensation 567 616 929 1,336 1,623 1,726 390 29.19% Total personnel services 11,645 10,494 12,429 17,791 14,807 18,564 773 4.34% Materials & supplies 1230 Supplies, equipment 7,352 3,869 2,129 2,500 621 2,500 - 0.00% 1600 Supplies, operating 2,526 2,608 2,002 3,500 287 3,500 - 0.00% 1700 Motor fuels 5,249 2,755 4,124 4,500 1,424 4,250 (250) -5.56% 2400 Uniforms 104 79 60 116 42 116 - 0.00% 2410 Mats & towels 130 51 44 90 40 72 (18) -20.00% Total materials & suppli 15,361 9,362 8,359 10,706 2,414 10,438 (268) -2.50% Contractual services 3030 Other professional services 205 4 4 4 - 0.00% 3530 Disposal - - - 5,000 - 50,000 45,000 900.00% 3630 Training 15 40 11 280 6 280 - 0.00% 5130 Repairs, equipment 117 1,395 - 4,000 1,821 4,000 - 0.00% Total contractual service 337 1,439 15 9,280 1,831 54,280 45,000 484.91% Capital outlays 7030 Equipment - - - 210,000 210,000 - (210,000) -100.00% Total capital outlays - - - 210,000 210,000 - (210,000) -100.00% 0.00% Miscellaneous:0.00% 9900 Transfer out 16,000 16,000 16,000 71,000 - 32,000 (39,000) -54.93% Total miscellaneous 16,000 16,000 16,000 71,000 - 32,000 (39,000) -54.93% Total street sweeping 43,343 37,295 36,803 318,777 229,052 115,282 (203,495) -63.84% 300,986 96,718 Total expenditures 220,807 220,841 328,748 724,987 343,886 513,304 (211,683) -29.20% Revenues over expenditures 64,467 (3,783) 35,421 (234,987) (73,700) (228,304) 6,683 -2.84% Add back: Capital outlays - - - 312,750 210,000 90,725 (222,025) -70.99% Change in net asssets 64,467 (3,783) 35,421 77,763 136,300 (137,579) (215,342) -276.92% Net assets, beginning year 2,995,236 3,059,703 3,055,920 3,055,920 3,055,920 3,133,683 77,763 2.54% Net assets, end of year 3,059,703$ 3,055,920$ 3,091,341$ 3,133,683$ 3,192,220$ 2,996,104$ (137,579)$ -4.39% 602,890 387,738 95 Fund: 745 Department: 4415 System Maintenance 7050 Construction > $25000 - - - - Sewer sliplining program - - - 50,000 2255 Lambert (pipe ditch)(possible matching grant from Rice Creek WSD) 50,000 75,000 75,000 - Mustang Drive improvements 48,000 50,000 25,000 25,000 Storm water projects 98,000 125,000 100,000 75,000 7950 Depreciation 32,000 32,000 32,000 32,000 Estimated depreciation 32,000 32,000 32,000 32,000 9900 Transfer out 40,000 75,000 75,000 75,000 Storm water system upgrades in conjunction with major roadway program 6,959 7,168 7,383 7,604 General Fund 46,959 82,168 82,383 82,604 258,914 329,968 301,904 291,020 Fund: 745 Department: 4417 Street Cleaning 1230 Supplies, equipment < $5000 2,500 2,500 2,500 2,500 Misc. sweeper repairs - belts, pumps, hoses, filters, etc. 2,500 2,500 2,500 2,500 1600 Supplies, operating 2,300 2,300 2,300 2,300 Gutter brooms 700 700 700 700 Belts, pumps, hoses, filters, etc... for sweeper 100 100 100 100 Gloves, hearing protection, etc... 400 400 400 400 2 dirt shoes 3,500 3,500 3,500 3,500 1700 Motor fuels 4,000 4,500 3,500 3,250 Diesel fuel - 1000 gallons @ $3.25/gallon 150 150 1,000 1,000 Hydraulic oil - 4 changes 4,150 4,650 4,500 4,250 2400 Uniforms 115 115 116 116 Uniforms/clothing (1.8% of $4,500, .2 FTE x $175 per contract) 115 115 116 116 2410 Mats & towels 110 110 90 72 Share of floor mats & shop towels (1.8% of $4,000) 110 110 90 72 3530 Disposal 5,000 5,000 5,000 50,000 Sweeping pile disposal (estimated 5 year project) 5,000 5,000 5,000 50,000 3630 Training 250 250 250 250 NPDES compliance training 30 30 30 30 Maintenance Expo 280 280 280 280 5130 Repairs, equipment 4,000 4,000 4,000 4,000 Sweeper repairs 4,000 4,000 4,000 4,000 7030 Equipment > $5000 - - 210,000 - Street sweeper (250,000 - trade-in of 40,000) - - - - 3/4 ton 4X2 Truck - - 210,000 - 9900 Transfer out to Vehicle & Equip 16,000 16,000 71,000 32,000 Transfer to Vehicle & Equip Fund for future replacements 16,000 16,000 71,000 32,000 35,655 36,155 300,986 96,718 294,569 366,123 602,890 387,738 5.07%24.29%64.67%-35.69% 96 THIS PAGE LEFT BLANK INTENTIONALLY 97