Loading...
11-24-14 CC WS Agenda CITY OF SHOREWOOD 5755 COUNTRY CLUB ROAD CITY COUNCIL WORK SESSION COUNCIL CHAMBERS MONDAY, NOVEMBER 24, 2014 6:00 P.M. AGENDA 1. CONVENE CITY COUNCIL WORK SESSION A. Roll Call Mayor Zerby _____ Hotvet _____ Siakel _____ Sundberg _____ Woodruff _____ B. Review Agenda ATTACHMENTS 2. FINAL GENERAL FUND BUDGET REVIEW Finance Director’s memo 3. ADJOURN City of Shorewood Work Session Item Title / Subject: 2015 General Fund Budget Meeting Date: November 24, 2014 Prepared by: Bruce DeJong, Finance Director Reviewed by: Bill Joynes, Interim City Administrator Attachments: Fund Balance Available Calculation Major Changes General Fund Budget Worksheets PowerPoint for Truth -in- Taxation Updated Worksheets for Park, Street, & Trail Capital Funds Policy Consideration: How should General Fund budgets be prioritized and funded? UN MEETING TYPE Work Session Meeting Background: The General Fund budget presented here is essentially unchanged from the preliminary budget approved in August. The only addition that has occurred is an $11,500 intergovernmental grant from the Excelsior Fire Department as a return of fund balance. Staff intends to present this budget with any modifications made at the work session as the basis for the Truth -in- Taxation budget hearing on Monday, December 1, 2014. The PowerPoint presentation for the Truth -in- Taxation meeting is included for your review and comment. Financial or Budget Considerations: This budget provides funding for the basic services that the City provides. Funding it with the resources identified in the budget is a reasonable, one -time method of operating. Long -term, the City Council needs to continue to prioritize projects in the CIP and enterprise budgets and fully fund them either with user fee revenues, outside funding sources such as partnership arrangements with other cities, bond issuance, internal loans or transfers, or increased tax levies. A review of the strategies taken in 2014 and options for long -range funding will be explored at the City Council retreat in 2015. This budget incorporates a 2.5% increase in the tax levy over the current year. This budget includes a Forestry position at three - quarters time. There is also a contingency amount for existing employee increases of 2.5% that is in the Council miscellaneous services budget. The remainder is to cover increased transfers to capital funds for equipment replacement and street reconstruction. As requested by council members, an updated estimate of available fund balance has been calculated. The October monthly budget report has a column for estimated full year expenditures. Using the change in fund balance calculated in that document, gives us a new estimate of the amount available for transfer to fund capital projects. The amount currently estimated is just over $533,000. Updated capital sheets have been included based on changes made at the last work session. Recommendation / Action Requested: Staff recommends that the City Council review the budgeted expenditures for the 2015 General Fund budget and direct staff to make any changes that are desired. Mission Statement: The City of Shorewood is committed to providing residents quality public services, a healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial management through effective, efficient, and visionary leadership. Next Steps and Timelines: Adoption of the 2015 Budget is anticipated for Monday, December 1, 2014. Connection to Vision / Mission: This budget contributes to providing excellent public services by maintaining high quality, reliable public services and infrastructure. City Method 12/31/13 General Fund Reserve 3,943,342 Estimated use of reserves for 2014 (23,850) 12/31/14 Estimated General Fund Reserve 3,919,492 Proposed 2015 Expenditures & Transfers 5,643,263 Fund Balance % 69.5% 12/31/14 Estimated General Fund Reserve 3,919,492 60% Reserve (3,385,958) Available Reserve 533,534 Office of State Auditor Method 2014 Expenditures 5,547,054 Less transfers (1,015,950) Net General Fund Expenditures 4,5311104 Special Revenue Expenditures 120,800 Net General & Special Revenue Expenditures 4,651,904 Fund Balance % 84.3% 12/31/14 Estimated General Fund Reserve 3,919,492 50% Reserve of Expenditures (2,325,952) Using the OSA calculation allows an additional $ 1,593,540 of fund balance that could be used for other purposes. Page 1 Major Budget Changes from 2014 > $4,000 in a line item City Council Increased Salary & Benefit $5,400 Christmas Lake Inspections (Rev reduced $45,000 also) ($45,000) Net Increase ($39,600) Administration Election Judges ($11,520) Part -time Employee - to cover Twila when at SSC $11,520 Net Savings $0 Professional Services Hennepin County assessing services $4,000 Net Increase $4,000 Police Proposed Operating Budget $27,153 Debt Service reduction ($4,582) Net Increase $22,571 Fire Operating Increase $15,948 Debt Service reduction ($6,115) Refund of Fund Balance ($11,500) Net Savings ($1,667) Public Works Employee Salary - Tree Inspector $40,000 Employee Benefits -Tree Inspector $15,000 Equipment & Street Reconstruction Transfers $30,000 Net Increase $85,000 Page 2 GENERAL FUND BUDGET SUMMARY Approved Requested Actual Actual YTD Budget Budget Percent Dollar 2012 2013 2014 2014 2015 Change Change REVENUES TAXES 4,783,939 4,764,472 2,497,543 4,858,585 4,980,050 2.5% 121,465 LICENSES & PERMITS 175,086 204,600 147,175 132,770 147,770 11.3% 15,000 INTERGOVERNMENTAL 76,102 96,549 64,735 96,251 87,251 -9.4% (9,000) CHARGES FOR SERVICES 64,825 33,194 24,860 41,700 42,200 1.2% 500 FINES & FORFEITURES 66,230 59,294 30,945 57,000 57,000 0.0% - MISCELLANEOUS REVENUE 141,013 205,010 134,001 232,900 210,400 -9.7% (22,500) TRANSFERS 330 317,182 - 25,000 25,000 0.0% - TOTAL REVENUES 5,307,525 5,680,301 2,899,259 5,444,206 5,549,671 1.9% 105,465 EXPENDITURES CITY CO UNCIL Personnel 16,794 16,794 9,796 16,800 22,600 34.5% 5,800 Materials and Supplies 887 2,035 142 1,200 2,000 66.7% 800 Support Services and Charges 80,309 90,885 26,338 156,121 110,350 -29.3% (45,771) Transfers 13,600 91,700 283,414 70,000 70,000 0.0% Total City Council 111,590 201,414 319,690 244,121 204,950 -16.0% (39,171) Administration Personnel 373,915 240,032 137,847 250,323 251,153 0.3% 830 Materials and Supplies 18,276 15,649 10,554 19,300 20,900 8.3% 1,600 Support Services and Charges 82,008 134,401 66,847 147,290 145,500 -1.2% (1,790) Capital - - - - - - Total City Administration 474,199 390,082 215,248 416,913 417,553 0.2% 640 FINANCE Personnel 120,556 137,469 79,347 134,758 134,758 0.0% - Materials and Supplies 8,042 8,547 7,910 9,050 10,050 11.0% 1,000 Support Services and Charges 11,686 14,619 9,418 16,000 16,000 0.0% - Capital - - - - - - Total Finance 140,284 160,635 96,675 159,808 160,808 0.6% 1,000 PROFESSIONAL SERVICES Support Services and Charges 190,592 199,042 159,825 211,060 215,060 1.9% 4,000 Total Professional Services 190,592 199,042 159,825 211,060 215,060 1.9% 4,000 PLANNING Personnel 181,382 181,143 105,115 173,157 173,157 0.0% - Materials and Supplies 137 292 42 250 300 20.0% 50 Support Services and Charges 7,691 7,684 3,960 11,900 11,000 -7.6% (900) Capital - - - - - - Total Planning 189,210 189,119 109,117 185,307 184,457 -0.5% (850) MUNICIPAL BUILDINGS Materials and Supplies 40,799 60,118 9,307 21,400 23,400 9.3% 2,000 Support Services and Charges 149,878 141,227 34,282 165,800 170,800 3.0% 5,000 Capital 2,441 - - - - - Transfers 102,200 100,450 - 103,950 101,513 -2.3% (2,437) Total Municipal Buildings 295,318 301,795 43,589 291,150 295,713 1.6% 4,563 Total General Government 1,401,193 1,442,087 944,144 1,508,359 1,478,541 -2.0% (29,818) less transfers (115,800) (192,150) (283,414) (173,950) (171,513) Net General Government 1,285,393 1,249,937 660,730 1,334,409 1,307,028 POLICE Materials and Supplies 1,328 - - - - - Support Services and Charges 991,383 1,018,680 696,475 1,045,056 1,072,645 2.6% 27,589 Capital 225,132 227,764 172,323 229,763 225,181 -2.0% (4,582) Total Police 1,217,843 1,246,444 868,798 1,274,819 1,297,826 1.8% 23,007 Page 3 GENERAL FUND BUDGET SUMMARY (Planned Use of Fund Balance) Page 4 Approved Requested Actual Actual YTD Budget Budget Percent Dollar 2012 2013 2014 2014 2015 Change Change FIRE Support Services and Charges 331,987 345,728 261,591 344,940 361,315 4.7% 16,375 Capital 277,906 287,655 208,817 282,271 276,156 -2.2% (6,115) Total Fire 609,893 633,383 470,408 627,211 637,471 1.6% 10,260 PROTECTIVE INSPECTIONS Personnel 114,396 123,411 68,669 121,323 121,323 0.0% - Materials and Supplies 242 - 157 200 200 0.0% - Support Services and Charges 5,813 6,813 1,354 5,300 7,700 45.3% 2,400 Total Protective Inspections 120,451 130,224 70,180 126,823 129,223 1.9% 2,400 Total Public Safety 1,948,187 2,010,051 1,409,386 2,028,853 2,064,520 1.8% 35,667 CITY ENGINEER Personnel 84,615 460 - - - - Materials and Supplies 144 - 37 - - Support Services and Charges 21,688 68,690 25,889 87,900 87,900 0.0% Capital - - - - - Total City Engineer 106,447 69,150 25,926 87,900 87,900 0.0% - PUBLIC WORKS SERVICES Personnel 417,330 434,212 179,805 439,587 494,547 12.5% 54,960 Materials and Supplies 120,684 141,763 57,103 167,200 167,700 0.3% 500 Support Services and Charges 121,758 105,845 52,324 141,600 142,600 0.7% 1,000 Capital - - - 2,500 - - 100.0% (2,500) Transfers 750,000 772,500 - 800,000 830,000 3.8% 30,000 Total Public Works Services 1,409,772 1,454,320 289,232 1,550,887 1,634,847 5.4% 83,960 SNOW AND ICE CONTROL Personnel 27,502 56,862 45,392 58,339 58,339 0.0% - Materials and Supplies 29,509 44,835 25,591 45,000 45,000 0.0% Total Snow and Ice Control 57,011 101,697 70,983 103,339 103,339 0.0% - Total Streets & Highways 1,573,230 1,625,167 386,141 1,742,126 1,826,086 4.8% 83,960 less transfers (750,000) (772,500) - (800,000) (830,000) 3.8% (30,000) Net Streets & Highways 823,230 852,667 386,141 942,126 996,086 PARKS MAINTENANCE Personnel 101,395 82,222 69,104 109,473 109,473 0.0% - Materials and Supplies 17,095 18,908 4,815 20,300 23,300 14.8% 3,000 Support Services and Charges 32,807 38,816 15,532 34,600 38,000 9.8% 3,400 Total Parks Maintenance 151,297 139,946 89,451 164,373 170,773 3.9% 6,400 RECREATION Personnel 37,627 51,296 29,473 36,743 36,743 0.0% - Materials and Supplies 1,171 4,818 3,308 5,800 5,800 0.0% Support Services and Charges 15,446 13,051 5,670 18,800 18,800 0.0% Transfers 42,000 42,000 - 42,000 42,000 0.0% Total Recreation 96,244 111,165 38,451 103,343 103,343 0.0% - Total Recreation 247,541 251,111 127,902 267,716 274,116 2.4% 6,400 less transfers (42,000) (42,000) - (42,000) (42,000) Net Recreation 205,541 209,111 127,902 225,716 232,116 GENERAL FUND TOTAL EXPENDITURES 5,170,151 5,328,416 2,867,573 5,547,054 5,643,263 1.7% 96,209 REVENUE OVER/(UNDER)EXPENDITURES 137,374 351,885 31,686 (102,848) (93,592) -9.0% 9,256 (Planned Use of Fund Balance) Page 4 TOTAL REVENUES 5,307,525 5,680,301 5,263,970 2,899,259 5,444,206 5,549,671 1.9% 105,465 Page 5 Approved Requested Actual Actual Budget YTD Budget Budget Percent Dollar 2012 2013 2013 2014 2014 2015 Change Change REVENUES TAXES 3010 GENERAL PROPERTY TAX 4,608,958 4,617,654 4,763,319 2,405,788 4,858,585 4,980,050 2.5% 121,465 3011 DELINQUENT AD VALOREM TAXES 61,571 43,292 40,600 3100 FISCAL DISPARITIES 113,410 103,526 51,155 TOTALTAXES 4,783,939 4,764,472 4,763,319 2,497,543 4,858,585 4,980,050 2.5% 121,465 LICENSES & PERMITS 3211 LIQUOR LICENSES 9,165 8,820 8,300 9,630 8,820 8,820 0.0% - 3212 TOBACCO LICENSES 1,000 1,250 1,000 - 500 500 0.0% 3216 TREE TRIMMING LICENSES 510 570 450 120 500 500 0.0% 3217 RENTAL HOUSING LICENSES 780 1,140 1,000 720 1,000 1,000 0.0% 3218 OTHER BUSINESS LICENSES AND PE 4,411 7,817 3,100 2,169 3,500 3,500 0.0% - 3221 BUILDING PERMITS 124,523 146,256 92,000 102,547 100,000 110,000 10.0% 10,000 3222 PLAN CHECK FEES 31,990 36,357 15,000 30,366 15,000 20,000 33.3% 5,000 3223 DOG LICENSES 2,482 2,140 3,300 1,368 3,300 3,300 0.0% 3224 FARM ANIMAL 150 150 - 255 100 100 0.0% 3225 HORSE PERMITS 50 25 50 50 50 0.0% 3230 DOMESTIC PARTNERSHIP REGISTRATION 25 75 - TOTAL LICENSES & PERMITS 175,086 204,600 124,200 147,175 132,770 147,770 11.3% 15,000 INTERGOVERNMENTAL 3314 BULLET -PROOF VEST GRANT 1,328 247 - - - 3341 LOCAL PERFORMANCE AID 1,023 1,041 1,000 1,000 1,000 0.0% - 3343 MKT VALUE CREDIT AID 245 26 3344 PERA AID 4,751 4,751 4,751 4,751 4,751 0.0% - 3345 MUNICIPAL STATE AID FOR STREET 68,755 70,479 64,650 36,843 68,000 70,000 2.9% 2,000 3362 GRANTS 20,005 27,892 22,500 11,500 -48.9% (11,000) TOTAL INTERGOVERNMENTAL 76,102 96,549 70,401 64,735 96,251 87,251 -9.4% (9,000) CHARGES FOR SERVICES 3400 CHARGES FOR SERVICES 4,037 - - - 3413 ZONING AND SUBDIVISION FEES 7,243 5,070 4,500 5,074 4,000 4,500 12.5% 500 3414 PASS -THRU CHARGES 10,034 (9,034) - (4,064) - - - 3415 SALE OF COPIES 264 220 1,000 236 500 500 0.0% 3417 SPECIAL ASSESSMENT SEARCHES 350 200 150 25 200 200 0.0% 3471 RECREATION RENTALS 1,498 1,524 - 2,925 30,000 1,500 -95.0% (28,500) 3472 TREE SALES 6,828 - - 3473 PARK PROGRAMS 31,357 32,844 29,500 17,439 1,500 32,000 2033.3% 30,500 3474 ARCTIC FEVER /PRINCESS TEA 3,214 2,370 - 3,225 5,500 3,500 -36.4% (2,000) TOTAL CHARGES FOR SERVICES 64,825 33,194 35,150 24,860 41,700 42,200 1.2% 500 FINES & FORFEITURES 3510 FINES & FORFEITS 66,230 59,294 57,000 30,945 57,000 57,000 0.0% - TOTAL FINES & FORFEITURES 66,230 59,294 57,000 30,945 57,000 57,000 0.0% MISCELLANEOUS REVENUE 3620 INTEREST EARNINGS 25,603 12,902 35,000 199 35,000 35,000 0.0% 3623 CONTRIBUTIONS AND DONATIONS FR 300 700 - 3624 REFUNDS & REIMBURSEMENTS 67,832 46,838 10,000 14,783 32,500 10,000 -69.2% (22,500) 3626 DRY HYDRANT CHARGES (6) 2,436 3,500 - - 3627 CELLULAR ANTENNA REVENUE 29,320 132,996 150,000 118,600 150,000 150,000 0.0% 3670 MISCELLANEOUS REVENUE 17,964 9,138 15,400 419 15,400 15,400 0.0% TOTAL MISCELLANEOUS REVENUE 141,013 205,010 213,900 134,001 232,900 210,400 -9.7% (22,500) TRANSFERS 3910 TRANSFERS FROM OTHER FUNDS 330 317,182 - 25,000 25,000 0.0% TOTAL TRANSFERS 330 317,182 - 25,000 25,000 0.0% TOTAL REVENUES 5,307,525 5,680,301 5,263,970 2,899,259 5,444,206 5,549,671 1.9% 105,465 Page 5 CITY COUNCIL General Coding: 101 -11- Page 6 Approved Dept Actual Actual Budget YTD Budget Request Percent Dollar PERSONAL SERVICES 2012 2013 2013 2014 2014 2015 Change Change 4103 PART -TIME 15,600 15,600 15,600 9,100 15,600 21,000 34.6% 5,400 4122 FICA CONTRIB - CITY SHARE 1,194 1,194 1,200 696 1,200 1,600 33.3% 400 TOTAL PERSONAL SERVICES 16,794 16,794 16,800 9,796 16,800 22,600 34.5% 5,800 MATERIALS & SUPPLIES 4245 GENERALSUPPLIES 887 2,035 2,000 142 1,200 2,000 66.7% 800 TOTAL MATERIALS & SUPPLIES 887 2,035 2,000 142 1,200 2,000 66.7% 800 SUPPORT SERVICES /CHARGES 4302 CONSULTING FEES - - 4331 TRAVEL, CONFERENCE & SCHOOLS 2,395 3,214 4,500 1,324 4,500 4,500 0.0% 4351 PRINTING AND PUBLISHING - 4400 CONTRACTUAL SERVICES 32,873 41,176 330 45,000 - - 100.0% (45,000) 4433 DUES AND SUBSCRIPTIONS 40,041 41,495 47,000 24,684 47,865 49,000 2.4% 1,135 4440 MISC SERVICES 5,000 5,000 20,950 - 58,756 56,850 -3.2% (1,906) TOTAL SUPPORT SERVICES /CHARGES 80,309 90,885 72,450 26,338 156,121 110,350 -29.3% (45,771) TRANSFERS 4820 OPERATING TRANSFERS 13,600 91,700 47,700 283,414 70,000 70,000 0.0% TOTAL TRANSFERS 13,600 91,700 47,700 283,414 70,000 70,000 0.0% TOTAL COUNCIL 111,590 201,414 138,950 319,690 244,121 204,950 -16.0% (39,171) Page 6 ADMINSTRATION General Coding: 101 -13- PERSONAL SERVICES 4101 FULL -TIME REGULAR 4102 FULL -TIME OVERTIME 4103 PART -TIME 4121 PERA /ICMA CONTRIB - CITY SHARE 4122 FICA CONTRIB - CITY SHARE 4131 EMPLOYEE INSURANCE - CITY SHARE 4141 UNEMPLOYMENT COMPENSATION 151 WORKERS COMPENSATION TOTAL PERSONAL SERVICES MATERIALS & SUPPLIES 4200 OFFICE SUPPLIES 4208 POSTAGE 4221 MAINTENANCE OF EQUIPMENT 4245 GENERAL SUPPLIES TOTAL MATERIALS & SUPPLIES SUPPORT SERVICES /CHARGES 4321 COMMUNICATIONS- TELEPHONE 4331 TRAVEL, CONFERENCE & SCHOOLS 4351 PRINTING AND PUBLISHING 4400 CONTRACTUAL SERVICES 4433 DUES AND SUBSCRIPTIONS 4440 MISC SERVICES TOTAL SUPPORT SERVICES /CHARGES CAPITAL OUTLAY 4240 MACHINERY & EQUIPMENT TOTAL CAPITAL OUTLAY 373,915 240,032 359,671 137,847 250,323 251,153 0.3% 830 4,790 3,844 5,000 1,877 Approved Dept -9.1% (500) Actual Actual Budget YTD Budget Request Percent Dollar 2012 2013 2013 2014 2014 2015 Change Change 238,085 141,783 286,860 119,990 187,866 187,866 0.0% 41,600 29,170 - 1,926 12,520 12,520 0.0% 20,064 12,070 20,797 7,564 13,620 14,450 6.1% 830 21,181 12,640 21,945 8,013 15,330 15,330 0.0% - 45,585 29,993 30,069 - 20,987 20,987 0.0% 7,400 14,376 - - - - 354 373,915 240,032 359,671 137,847 250,323 251,153 0.3% 830 4,790 3,844 5,000 1,877 5,500 5,000 -9.1% (500) 10,878 10,857 11,150 6,871 11,000 11,000 0.0% - 1,589 - 1,400 1,736 1,900 4,000 110.5% 2,100 1,019 948 900 70 900 900 0.0% - 18,276 15,649 18,450 10,554 19,300 20,900 8.3% 1,600 962 565 1,100 - 3,909 4,478 8,710 3,387 6,500 6,500 0.0% 2,477 794 2,000 1,336 2,000 1,500 -25.0% (500) 74,134 128,239 28,365 61,335 138,320 137,000 -1.0% (1,320) 526 325 2,000 330 470 500 6.4% 30 - - - 459 - 82,008 134,401 42,175 66,847 147,290 145,500 -1.2% (1,790) TOTAL ADMINISTRATION 474,199 390,082 420,296 215,248 416,913 417,553 0.2% 640 Page 7 FINANCE General Coding: 101 -15 SUPPORT SERVICES /CHARGES 4301 AUDITING & ACCOUNTING SERVICES 2,700 2,066 - 5,880 Approved Dept 0.0% 4331 TRAVEL, CONFERENCE & SCHOOLS 2,877 Actual Actual Budget YTD Budget Request Percent Dollar PERSONAL SERVICES 2012 2013 2013 2014 2014 2015 Change Change 4101 FULL -TIME REGULAR 97,460 108,488 106,078 69,858 107,669 107,669 0.0% 500 4121 PERA CONTRIB - CITY SHARE 7,424 7,782 7,691 4,593 7,806 7,806 0.0% 4122 FICA CONTRIB - CITY SHARE 7,834 7,750 8,115 4,671 8,237 8,237 0.0% 6,000 4131 EMPLOYEE INSURANCE - CITY SHARE 7,838 13,449 11,045 225 11,046 11,046 0.0% 16,000 TOTAL PERSONAL SERVICES 120,556 137,469 132,929 79,347 134,758 134,758 0.0% MATERIALS & SUPPLIES 4200 OFFICE SUPPLIES 110 37 - 1,021 250 250 0.0% 4221 MAINTENANCE OF EQUIPMENT 7,839 8,078 8,100 6,889 8,500 9,500 11.8% 1,000 4245 GENERALSUPPLIES 93 432 300 - 300 300 0.0% - TOTAL MATERIALS & SUPPLIES 8,042 8,547 8,400 7,910 9,050 10,050 11.0% 1,000 SUPPORT SERVICES /CHARGES 4301 AUDITING & ACCOUNTING SERVICES 2,700 2,066 - 5,880 3,600 3,600 0.0% 4331 TRAVEL, CONFERENCE & SCHOOLS 2,877 4,440 4,000 1,012 4,000 4,000 0.0% 4351 PRINTING AND PUBLISHING - 2,246 700 900 900 0.0% 4400 CONTRACTUAL SERVICES - - 1,000 1,000 1,000 0.0% 4330 DUES AND SUBSCRIPTIONS 280 220 500 247 500 500 0.0% 4440 MISC SERVICES 2 - - 4450 BANK SERVICE CHARGES 5,827 5,647 5,400 2,279 6,000 6,000 0.0% TOTAL SUPPORT SERVICES /CHARGES 11,686 14,619 11,600 9,418 16,000 16,000 0.0% TOTAL FINANCE 140,284 160,635 152,929 96,675 159,808 160,808 0.6% 1,000 Page 8 PROFESSIONAL SERVICES General Coding: 101 -16- Page 9 Approved Dept Actual Actual Budget YTD Budget Request Percent Dollar SUPPORT SERVICES /CHARGES 2012 2013 2013 2014 2014 2015 Change Change 4301 AUDITING & ACCOUNTING SERVICES 27,625 23,225 25,000 22,030 26,660 26,660 0.0% 4304 CIVIL LEGAL CONTRACT 36,559 40,000 44,000 11,766 44,400 44,400 0.0% 4304 PROSECUTION CONTRACT 28,250 33,360 33,900 19,611 34,000 34,000 0.0% 4400 CONTRACTUAL ASSESSOR SERVICES 98,158 102,457 100,000 106,419 106,000 110,000 3.8% 4,000 4440 MISCSERVICES - - - - TOTAL SUPPORT SERVICES /CHARGES 190,592 199,042 202,900 159,825 211,060 215,060 1.9% 4,000 TOTAL PROFESSIONAL SERVICES 190,592 199,042 202,900 159,825 211,060 215,060 1.9% 4,000 Page 9 PLANNING General Coding: 101 -18- TOTAL PLANNING 189,210 189,119 178,916 109,117 185,307 184,457 -0.5% (850) Page 10 Actual Actual Budget YTD Budget Request Percent Dollar PERSONAL SERVICES 2012 2013 2013 2014 2014 2015 Change Change 4101 FULL -TIME REGULAR 121,955 103,497 133,887 93,184 135,193 135,193 0.0% 4103 PART -TIME 18,015 37,719 - 4121 PERA CONTRIB - CITY SHARE 10,493 10,065 9,707 5,866 9,802 9,802 0.0% 4122 FICA CONTRIB - CITY SHARE 9,638 9,440 10,242 5,741 10,342 10,342 0.0% 4131 EMPLOYEE INSURANCE - CITY SHAR 18,558 20,422 16,830 324 17,820 17,820 0.0% 4141 UNEMPLOYMENT COMPENSATION 2,723 - - TOTAL PERSONAL SERVICES 181,382 181,143 170,666 105,115 173,157 173,157 0.0% MATERIALS & SUPPLIES 4200 OFFICE SUPPLIES 137 292 - - 4221 MAINTENANCE OF EQUIPMENT - - 400 4245 GENERALSUPPLIES - - 250 42 250 300 20.0% 50 TOTAL MATERIALS & SUPPLIES 137 292 650 42 250 300 20.0% 50 SUPPORT SERVICES /CHARGES 4321 COMMUNICATIONS - CELLULARPHON 1,018 869 800 753 1,000 1,000 0.0% - 4331 TRAVEL, CONFERENCE & SCHOOLS 1,598 1,770 2,000 1,618 4,200 4,200 0.0% - 4351 PRINTING AND PUBLISHING 1,179 1,070 1,000 594 1,000 1,100 10.0% 100 4400 CONTRACTUAL SERVICES 2,893 2,850 2,500 4,500 3,500 -22.2% (1,000) 4433 DUES AND SUBSCRIPTIONS 1,003 1,125 1,100 995 1,200 1,200 0.0% - TOTAL SUPPORT SERVICES /CHARGES 7,691 7,684 7,400 3,960 11,900 11,000 -7.6% (900) CAPITAL OUTLAY 4240 FURNITURE AND FIXTURES - - 200 - TOTAL CAPITAL OUTLAY 200 - - TOTAL PLANNING 189,210 189,119 178,916 109,117 185,307 184,457 -0.5% (850) Page 10 MUNICIPAL BUILDINGS General Coding: 101 -19- CAPITAL OUTLAY 4240 BUILDINGS & STRUCTURES 4240 MACHINERY & EQUIPMENT 2,441 TOTAL CAPITAL OUTLAY 2,441 TRANSFERS 4820 OPERATING TRANSFERS 102,200 100,450 100,450 103,950 101,513 -2.3% (2,437) TOTAL TRANSFERS 102,200 100,450 100,450 - 103,950 101,513 -2.3% (2,437) TOTAL MUNICIPAL BUILDINGS 295,318 301,795 287,380 43,589 291,150 295,713 1.6% 4,563 Page 11 Approved Dept Actual Actual Budget YTD Budget Request Percent Dollar MATERIALS & SUPPLIES 2012 2013 2013 2014 2014 2015 Change Change 4221 MAINTENANCE OF EQUIPMENT 31,111 30,248 11,400 1,493 11,400 11,400 0.0% 4223 MAINTENANCE OF BUILDINGS 7,638 27,900 7,800 6,800 8,000 10,000 25.0% 2,000 4245 GENERALSUPPLIES 2,050 1,970 2,930 1,014 2,000 2,000 0.0% - TOTAL MATERIALS & SUPPLIES 40,799 60,118 22,130 9,307 21,400 23,400 9.3% 2,000 SUPPORT SERVICES /CHARGES 4302 CONSULTING FEES 1,582 - 4321 COMMUNICATIONS - Warner Connect 17,142 38,592 34,000 24,706 34,000 36,000 5.9% 2,000 4331 TRAVEL, CONFERENCE & SCHOOLS 16 - - 4360INSURANCE 104,402 82,680 110,000 - 1.10,000 113,000 2.7% 3,000 4361 INSURANCE DEDUCTIBLE 8,668 - - - 4380 UTILITY SERVICES 7,111 8,601 11,000 4,454 11,000 11,000 0.0% 4400 CONTRACTUAL SERVICES 9,501 10,018 9,800 4,534 9,800 9,800 0.0% 4410 RENTALS 1,472 1,320 - 588 1,000 1,000 0.0% - TOTAL SUPPORT SERVICES /CHARGES 149,878 141,227 164,800 34,282 165,800 170,800 3.0% 5,000 CAPITAL OUTLAY 4240 BUILDINGS & STRUCTURES 4240 MACHINERY & EQUIPMENT 2,441 TOTAL CAPITAL OUTLAY 2,441 TRANSFERS 4820 OPERATING TRANSFERS 102,200 100,450 100,450 103,950 101,513 -2.3% (2,437) TOTAL TRANSFERS 102,200 100,450 100,450 - 103,950 101,513 -2.3% (2,437) TOTAL MUNICIPAL BUILDINGS 295,318 301,795 287,380 43,589 291,150 295,713 1.6% 4,563 Page 11 POLICE General Coding: 101-21 - Approved Dept Actual Actual Budget YTD Budget Request Percent Dollar MATERIALS & SUPPLIES 2012 2013 2013 2014 2014 2015 Change Change 4245 GENERALSUPPLIES 1,328 - TOTAL MATERIALS & SUPPLIES 1,328 - - - - SUPPORT SERVICES/CHARGES 4380 UTILITY SERVICES - 50 - - 4400 CONTRACTUAL SERVICES 990,264 1,015,403 1,013,027 695,870 1,042,556 1,070,145 2.7% 27,153 4440 MISC SERVICES 1,119 3,277 2,000 605 2,500 2,500 0.0% - TOTAL SUPPORT SERVICES/CHARGES 991,383 1,018,680 1,015,077 696,475 1,045,056 1,072,645 2.6 %. 27,589 CAPITAL OUTLAY 4620 BUILDINGS & STRUCTURES 225,132 227,764 235,437 172,323 229,763 225,181 -2.0% (4,582) TOTAL CAPITAL OUTLAY 225,132 227,764 235,437 172,323 229,763 225,181 -2.0% (4,582) TOTAL POLICE PROTECTION 1,217,843 1,246,444 1,250,514 868,798 1,274,819 1,297,826 1.8% 23,007 Page 12 FIRE General Coding: 101 -22- TOTAL FIRE PROTECTION 609,893 633,383 637,225 470,408 627,211 637,471 1.61% 10,260 Page 13 Approved Dept Actual Actual Budget YTD Budget Request Percent Dollar SUPPORT SERVICES /CHARGES 2012 2013 2013 2014 2014 2015 Change Change 4400 Excelsior Fire 307,705 320,728 324,999 249,299 321,367 337,315 5.0% 15,948 4400 Mound Fire Contract 24,282 25,000 24,583 12,292 23,573 24,000 1.8% 427 TOTAL SUPPORT SERVICES /CHARGES 331,987 345,728 349,582 261,591 344,940 361,315 4.7% 16,375 CAPITAL OUTLAY 4620 BUILDINGS & STRUCTURES 277,906 287,655 287,643 208,817 282,271 276,156 -2.2% (6,115) TOTAL CAPITAL OUTLAY 277,906 287,655 287,643 208,817 282,271 276,156 -2.2% (6,115) TOTAL FIRE PROTECTION 609,893 633,383 637,225 470,408 627,211 637,471 1.61% 10,260 Page 13 PROTECTIVE INSPECTIONS General Coding: 101 -24- TOTAL PROTECTIVE INSPECTIONS 120,451 130,224 126,088 70,180 126,823 129,223 1.9% 2,400 Net Levy Support (36,062) (52,389) 19,088 (62,732) 11,823 (777) Page 14 Approved Dept Actual Actual Budget YTD Budget Request Percent Dollar REVENUE 2012 2013 2013 2014 2014 2015 Change Change 3221 Building Permits 124,523 146,256 92,000 102,546 100,000 110,000 10.0% 10,000 3222 Plan Check Fees 31,990 36,357 15,000 30,366 15,000 20,000 33.3% 5,000 TOTAL REVENUE 156,513 182,613 107,000 132,912 115,000 130,000 13.0% 15,000 Dept Dept Actual Actual Budget May Request Request Percent Dollar PERSONAL SERVICES 2012 2013 2013 2013 2014 2015 Increase Change 4101 FULL -TIME REGULAR 87,420 88,725 92,613 60,711 93,902 93,902 0.0% 4102 PART -TIME 211 6,468 1,500 - 4121 PERA CONTRIB - CITY SHARE 6,597 6,588 6,714 3,999 6,808 6,808 0.0% 4122 FICA CONTRIB - CITY SHARE 6,079 6,188 7,085 3,644 7,183 7,183 0.0% 4131 EMPLOYEE INSURANCE - CITY SHARE 14,089 15,442 12,676 315 13,430 13,430 0.0% TOTAL PERSONAL SERVICES 114,396 123,411 120,588 68,669 121,323 121,323 0.0% MATERIALS & SUPPLIES 4200 OFFICE SUPPLIES 242 - - 4245 GENERALSUPPLIES 200 157 200 200 0.0% TOTAL MATERIALS & SUPPLIES 242 200 157 200 200 0.0% - SUPPORT SERVICES /CHARGES 4321 COMMUNICATIONS - CELLULAR PHONE - - - 400 400 4331 TRAVEL, CONFERENCE & SCHOOLS 3,151 3,232 2,500 764 2,500 3,500 40.0% 1,000 4351 PRINTING AND PUBLISHING 87 161 150 135 150 150 0.0% - 4400 CONTRACTUAL SERVICES 2,450 3,185 2,500 455 2,500 3,500 40.0% 1,000 4433 DUES AND SUBSCRIPTIONS 125 235 150 150 150 0.0% - TOTAL SUPPORT SERVICES /CHARGES 5,813 6,813 5,300 1,354 5,300 7,700 45.3% 2,400 TOTAL PROTECTIVE INSPECTIONS 120,451 130,224 126,088 70,180 126,823 129,223 1.9% 2,400 Net Levy Support (36,062) (52,389) 19,088 (62,732) 11,823 (777) Page 14 CITY ENGINEER General Coding: 101 -31 CAPITAL OUTLAY 4240 MACHINERY & EQUIPMENT TOTAL CAPITAL OUTLAY TOTAL CITY ENGINEER 106,447 69,150 103,969 25,926 87,900 87,900 0.0% Page 15 Approved Dept Actual Actual Budget YTD Budget Request Percent Dollar PERSONAL SERVICES 2012 2013 2013 2014 2014 2015 Change Change 4101 FULL -TIME REGULAR 66,401 406 73,640 - 4121 PERA CONTRIB - CITY SHARE 4,181 29 5,339 4122 FICA CONTRIB - CITY SHARE 5,272 25 5,633 4131 EMPLOYEE INSURANCE - CITY SHARE 8,761 - 7,937 TOTAL PERSONAL SERVICES 84,615 460 92,549 MATERIALS & SUPPLIES 4200 OFFICE SUPPLIES 104 - 150 4245 GENERALSUPPLIES 40 50 37 TOTAL MATERIALS & SUPPLIES 144 - 200 37 - - SUPPORT SERVICES /CHARGES 4303 ENGINEERING FEES 14,106 21,817 5,000 2,842 37,500 37,500 4321 COMMUNICATIONS - CELLULAR PHONE - 60 - 4331 TRAVEL, CONFERENCE & SCHOOLS 1,374 130 2,500 4351 PRINTING AND PUBLISHING 367 - 300 - 300 300 4400 CONTRACTUAL SERVICES 4,000 45,110 - 23,047 48,000 48,000 4410 RENTAL 159 57 - - 4433 DUES AND SUBSCRIPTIONS 1,546 1,576 3,060 2,100 2,100 - 4437 TAXES /LICENSES 136 - 300 - TOTAL SUPPORT SERVICES /CHARGES 21,688 68,690 11,220 25,889 87,900 87,900 0.0% CAPITAL OUTLAY 4240 MACHINERY & EQUIPMENT TOTAL CAPITAL OUTLAY TOTAL CITY ENGINEER 106,447 69,150 103,969 25,926 87,900 87,900 0.0% Page 15 PUBLIC WORKS General Coding: 101 -32- TOTAL CAPITAL OUTLAY 1,200 2,500 - - 100.0% (2,500) TRANSFERS 4820 OPERATING TRANSFERS -EQUIPMENT 750,000 772,500 772,500 800,000 830,000 3.8% 30,000 TOTAL TRANSFERS 750,000 772,500 772,500 - 800,000 830,000 3.8% 30,000 TOTAL PUBLIC WORKS 1,409,772 1,454,320 1,512,325 289,232 1,550,887 1,634,847 5.4% 83,960 Page 16 Approved Dept Actual Actual Budget YTD Budget Request Percent Dollar PERSONAL SERVICES 2012 2013 2013 2014 2014 2015 Change Change 4101 FULL -TIME REGULAR 320,659 330,213 334,078 149,362 334,078 334,078 0.0% 4102 OVERTIME 1,553 2,607 2,500 4,144 2,500 2,500 0.0% 4103 PART -TIME 2,695 - 40,000 40,000 4121 PERA CONTRIB -CITY SHARE 24,290 23,811 24,402 9,664 24,402 27,302 11.9% 2,900 4122 FICA CONTRIB - CITY SHARE 24,437 23,911 25,748 9,848 25,748 28,808 11.9% 3,060 4131 EMPLOYEE INSURANCE - CITY SHARE 46,391 50,975 42,047 6,787 52,859 61,859 17.0% 9,000 TOTAL PERSONAL SERVICES 417,330 434,212 428,775 179,805 439,587 494,547 12.5% 54,960 MATERIALS & SUPPLIES 4200 OFFICE SUPPLIES 161 26 200 862 200 200 0.0% 4212 MOTOR FUELS & LUBRICATION 41,981 46,760 51,000 28,009 51,000 51,000 0.0% 4221 MAINTENANCE OF EQUIPMENT 17,093 17,045 16,500 5,415 18,000 18,000 0.0% 4223 MAINTENANCE OF BUILDINGS 1,104 856 2,500 244 7,000 7,000 0.0% - 4240 SMALL TOOLS AND MINOR EQUIPMENT 1,040 1,463 1,500 687 1,000 1,500 50.0% 500 4245 GENERALSUPPLIES 59,305 75,613 99,600 21,886 90,000 90,000 0.0% - TOTAL MATERIALS & SUPPLIES 120,684 141,763 171,300 57,103 167,200 167,700 0.3% 500 SUPPORT SERVICES /CHARGES 4303 ENGINEERING 4305 DRUG TESTING 150 904 1,800 52 1,800 1,800 0.0% 4321 COMMUNICATIONS - TELEPHONE 2,436 2,044 3,200 1,703 2,700 2,700 0.0% 4331 TRAVEL, CONFERENCE & SCHOOLS 3,154 3,208 7,500 - 6,500 6,500 0.0% - 4380 UTILITY SERVICES 8,907 15,047 14,550 8,618 15,000 16,000 6.7% 1,000 4399 UTILITIES - STREET LIGHTS 40,411 41,846 41,500 18,643 44,000 44,000 0.0% - 4400 CONTRACTUAL SERVICES 62,379 40,244 63,000 20,642 64,000 64,000 0.0% 4410 RENTALS 679 231 1,000 18 1,000 1,000 0.0% 4433 DUES AND SUBSCRIPTIONS 1,659 1,673 1,500 1,786 1,700 1,700 0.0% 4437 TAXES /LICENSES 875 529 900 789 900 900 0.0% 4440 MISC SERVICES 1,108 119 3,600 73 4,000 4,000 0.0% - TOTAL SUPPORT SERVICES /CHARGES 121,758 105,845 138,550 52,324 141,600 142,600 0.7% 1,000 CAPITAL OUTLAY 4240 MACHINERY & EQUIPMENT 900 2,500 - 100.0% (2,500) 4240 FURNITURE AND FIXTURES 300 TOTAL CAPITAL OUTLAY 1,200 2,500 - - 100.0% (2,500) TRANSFERS 4820 OPERATING TRANSFERS -EQUIPMENT 750,000 772,500 772,500 800,000 830,000 3.8% 30,000 TOTAL TRANSFERS 750,000 772,500 772,500 - 800,000 830,000 3.8% 30,000 TOTAL PUBLIC WORKS 1,409,772 1,454,320 1,512,325 289,232 1,550,887 1,634,847 5.4% 83,960 Page 16 ICE AND SNOW REMOVAL General Coding: 101 -33- Page 17 Approved Dept Actual Actual Budget YTD Budget Request Percent Dollar PERSONAL SERVICES 2012 2013 2013 2014 2014 2015 Change Change 4101 FULL -TIME REGULAR 14,416 38,307 37,455 29,490 37,455 37,455 0.0% 410 OVERTIME 4,577 6,119 7,500 8,839 7,500 7,500 0.0% 4121 PERA CONTRIB - CITY SHARE 1,425 3,145 3,259 2,832 3,259 3,259 0.0% 4122 FICA CONTRIB - CITY SHARE 1,414 3,149 3,439 2,481 3,439 3,439 0.0% 4131 EMPLOYEE INSURANCE - CITY SHARE 5,670 6,142 5,009 1,750 6,686 6,686 0.0% TOTAL PERSONAL SERVICES 27,502 56,862 56,662 45,392 58,339 58,339 0.0% MATERIALS & SUPPLIES 4245 GENERALSUPPLIES 29,509 44,835 45,000 25,591 45,000 45,000 0.0% TOTAL MATERIALS & SUPPLIES 29,509 44,835 45,000 25,591 45,000 45,000 0.0% TOTAL ICE & SNOW CONTROL 57,011 101,697 101,662 70,983 103,339 103,339 0.0% Page 17 PARKS MAINTENANCE General Coding: 101-52 - PERSONAL SERVICES 4101 FULL -TIME REGULAR 4102 OVERTIME 4103 PART -TIME 4121 PERA CONTRIB - CITY SHARE 4122 FICA CONTRIB - CITY SHARE 4131 EMPLOYEE INSURANCE - CITY SHARE TOTAL PERSONAL SERVICES MATERIALS & SUPPLIES 4208 POSTAGE 4221 MAINTENANCE OF EQUIPMENT 4223 MAINTENANCE OF BUILDINGS 4240 SMALLTOOLS AND MINOR EQUIPMENT 4245 GENERALSUPPLIES 4247 TREES PURCHASED TOTAL MATERIALS & SUPPLIES SUPPORT SERVICES /CHARGES 4303 ENGINEERING FEES 4321 COMMUNICATIONS - TELEPHONE 4331 TRAVEL, CONFERENCE & SCHOOLS 4351 PRINTING AND PUBLISHING 4380 UTILITY SERVICES 4400 CONTRACTUAL SERVICES 4410 RENTALS 4440 MISC SERVICES TOTAL SUPPORT SERVICES /CHARGES 255 - 505 613 8,358 7,364 - 5,469 6,208 932 6,299 - 4,000 5,000 800 9,500 - 982 35 45 3,753 Approved Dept 0.0% 75.0% 0.0% 0.0% Actual Actual Budget YTD Budget Request Percent Dollar 2012 2013 2013 2014 2014 2015 Change Change 77,866 62,036 69,784 55,137 69,784 69,784 0.0% 1,800 - 2,500 187 2,500 2,500 0.0% 3,598 2,464 12,000 4,438 12,000 12,000 0.0% 5,938 4,447 5,241 3,220 5,241 5,241 0.0% 5,917 4,309 6,448 3,859 6,448 6,448 0.0% 8,076 8,966 7,386 2,263 13,500 13,500 0.0% 101,395 82,222 103,358 69,104 109,473 109,473 0.0% 255 - 505 613 8,358 7,364 - 5,469 6,208 932 6,299 - 4,000 5,000 800 9,500 - 982 35 45 3,753 6,000 4,000 800 9,500 6,000 7,000 800 9,500 0.0% 75.0% 0.0% 0.0% 3,000 - - 17,095 18,908 19,300 4,815 20,300 23,300 14.8% 3,000 - 2,000 - 2,000 - 100.0% (2,000) 1,019 1,828 1,800 945 1,800 2,000 11.1% 200 - 1,000 6 1,000 1,000 0.0% - 38 - 160 - - - 7,048 9,901 9,000 6,371 9,000 11,000 22.2% 2,000 15,061 14,895 7,200 2,588 9,800 13,000 32.7% 3,200 9,641 9,267 9,750 5,622 11,000 11,000 0.0% - 2,925 - - - 32,807 38,816 30,910 15,532 34,600 38,000 9.8% 3,400 TOTAL PARKS MAINTENANCE 151,297 139,946 153,568 89,451 164,373 170,773 3.9% 6,400 Page 18 RECREATION General Coding: 101 -53- TOTAL PARKS AND RECREATION 96,244 111,165 100,005 38,451 103,343 103,343 0.0% Net Levy Support 60,176 74,427 70,505 14,862 66,343 Page 19 Approved Dept Actual Actual Budget YTD Budget Request Percent Dollar REVENUE 2012 2013 2013 2014 2014 2015 Change Change 3471 Recreation Rentals 1,498 1,524 29,500 2,925 1,500 1,500 0.0% 3473 Park Programs 31,356 32,844 17,439 30,000 32,000 6.7% 2,000 3474 Arctic Fever /Princess Tea 3,214 2,370 3,225 5,500 3,500 -36.4% (2,000) TOTAL REVENUE 36,068 36,738 29,500 23,589 37,000 37,000 0.0% Dept Actual Actual Budget YTD Request Percent Dollar PERSONAL SERVICES 2012 2013 2013 2014 2014 Increase Change 4101 FULL -TIME REGULAR 28,780 30,872 21,882 13,345 22,211 22,211 0.0% 4102 OVERTIME 418 - 550 - 4103 PART -TIME 3,099 13,615 10,000 12,503 10,000 10,000 0.0% 4121 PERA CONTRIB - CITY SHARE 2,302 2,469 1,586 1,011 1,610 1,610 0.0% 4122 FICA CONTRIB - CITY SHARE 2,370 3,424 2,439 2,005 2,464 2,464 0.0% 4131 EMPLOYEE INSURANCE -CITY SHARE 1,076 498 453 59 458 458 0.0% TOTAL PERSONAL SERVICES 37,627 51,296 36,360 29,473 36,743 36,743 0.0% MATERIALS & SUPPLIES 4245 GENERALSUPPLIES 1,171 500 1,500 500 4246 PROGRAM EXPENSE 4,318 2,808 5,800 5,800 0.0% TOTAL MATERIALS & SUPPLIES 1,171 4,818 1,500 3,308 5,800 5,800 0.0% SUPPORT SERVICES /CHARGES 4321 COMMUNICATIONS - TELEPHONE 728 - 2,100 4331 TRAVEL, CONFERENCE & SCHOOLS 179 48 1,500 - 200 200 0.0% 4351 PRINTING AND PUBLISHING 904 - 1,500 850 850 0.0% 4400 CONTRACTUAL SERVICES 10,164 4,923 14,795 264 10,500 10,500 0.0% 4433 DUES AND SUBSCRIPTIONS 150 199 250 49 250 250 0.0% 4440 ARCTIC FEVER /PRINCESS TEA 3,258 7680 5357 7,000 7,000 0.0% 4450 BANK SERVICE CHARGES 63 201 0 TOTAL SUPPORT SERVICES /CHARGES 15,446 13,051 20,145 5,670 18,800 18,800 0.0% TRANSFERS 4820 OPERATING TRANSFERS 42,000 42,000 42,000 42,000 42,000 0.0% TOTAL TRANSFERS 42,000 42,000 42,000 - 42,000 42,000 0.0% TOTAL PARKS AND RECREATION 96,244 111,165 100,005 38,451 103,343 103,343 0.0% Net Levy Support 60,176 74,427 70,505 14,862 66,343 Page 19 pe V I , • 4 C� n� W -C Cr .-J W V LM 4-J -iJ buo 0 4-J is m LO W W E xr--i _0 0 W u m 0 u .-J U} CL {� 4-J W W CL V 4-J .� M� 1�� 1 • 1 n 1 1 0 E cv—) co— 0 •i 2 • � r-L ! C 06 • i` s ! 1 1 . 1 � r`� C 1 • 1 11 1 1; 1 • 1 11, • Ln d-j N 4-J U °° (1} 0 M s Ln N p 0 U Ln Ln ' i, E E Ln m I _ 10 � o U C6 w 4-J 0 V) Ln N w Q 4- "® w U Co >. w ui 4-j 06 1 U -- .fir I • • l; • 674 U- '' s • 0 0 i 0 0 0 0 r 674 U- '' s • 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 �o Lr) d= tYi N e—i qcn- -cn- cn to cn cn rd r 1 ! 1 1 1 .11 11 Lill I - m» / � � y � , m>A. � ? � \ � \ }may I � \ � ^ \�\ I - m» / � � y � , m>A. � ? � \ � \ }may I 1 1 a SZOZ tT O Z GTOZ ZZOZ T T O Z IM U N LL 0 O CxA u L N i- J X O O O O O SZOZ tT O Z GTOZ ZZOZ T T O Z IM O O O O O O qj)- O O O O O O O O O O O O O O O O O lD Ln d' M N rl qj,)- Jl )- -cn- -tn- qcn- -V?- SZOZ tT O Z GTOZ ZZOZ T T O Z IM L i! • ! • i i L i! • �I • 1 / i • / Lin (1) 1 / i • / i 1 o i 1' • i • LO i 1 i • 1 1 • 1 1 / 1 _! 1 • 1 • 1 Cl. • 1 1 / • • A 1 i 1 ry C- • • aim1111 A A A A A A 11w i aim Lin (1) 1 / i • / i 1 o i 1' i • LO i 1 i • 1 1 • 1 1 / 1 _! 1 • 1 • 1 Cl. • 1 1 / • • 1 i 1 ry C- 0� \�\ 4\\ \1\ \�\ \1. I NOR � Qƒ w < \� API a � \ £ �■ y � < ) i. « » ■ # .. .. 2 t << •. ) f �. «< «< .? 4 / $ « ■ \ t d � # .. n . � »» r : . �, • �', �' � �� s • ®'; a a a' • :: ,• ,� • ! ., • i t � �� LM • i 1 - • 1 E qt E 0 Ln w 0 • 1 • • • ' - / 1 i m i 1 s x qcl- ft.. x Co c •_O •. Ln • •` 1 • 0 0 CL Ul s • E > 0 0"- > 0 < C— 4— < m 1 1 1 0 C►- • 1 i .® • • ai +� N C: �' 11/21/2014 of • ••d Park Improvement Fund - This fund covers capital expenditures for the improvement of park facilities I EXPENDITURES OTHER SERVICES Contractrual Services - - - - - - - Miscellaneous Charges - - - - - - - TOTAL OTHER SERVICES CAPITAL OUTLAY Machinery and Equipment - - - - - - - Other Improvements 53,027 3,000 36,500 692,000 860,000 202,500 19,000 TOTAL CAPITAL OUTLAY 53,027 3,000 36,500 692,000 860,000 202,500 19,000 TOTAL EXPENDITURES Revenue - Over /(under) 53,027 44,939 3,000 353,214 36,500 8,300 0.0% 0.0% 0.0% 0.0% Ending Fund Balance Actual Budget Projected Projected Projected Projected Projected REVENUES 2013 2014 2015 2016 2017 2018 2019 Beginning Fund Balance 168,427 213,366 566,580 574,880 427,780 (388,120) (550,520) Park Dedication Fees 55,000 30,000 - 500,000 - - - Interest Earnings* 966 800 2,800 2,900 2,100 (1,900) (2,800) Concession Sales - - - - - - - Grants - - - - - - - Transfers in 42,000 325,414 42,000 42,000 42,000 42,000 42,000 TOTAL REVENUES 97,966 356,214 44,800 544,900 44,100 40,100 39,200 EXPENDITURES OTHER SERVICES Contractrual Services - - - - - - - Miscellaneous Charges - - - - - - - TOTAL OTHER SERVICES CAPITAL OUTLAY Machinery and Equipment - - - - - - - Other Improvements 53,027 3,000 36,500 692,000 860,000 202,500 19,000 TOTAL CAPITAL OUTLAY 53,027 3,000 36,500 692,000 860,000 202,500 19,000 TOTAL EXPENDITURES Revenue - Over /(under) 53,027 44,939 3,000 353,214 36,500 8,300 692,000 (147,100) 860,000 (815,900) 202,500 (162,400) 19,000 20,200 Ending Fund Balance 213,366 566,580 574,880 427,780 (388,120) (550,520) (530,320) Note: * Interest projected at 0.5% of fund balance 2014 2015 2016 2017 2018 Expenditures 3,000 36,500 692,000 860,000 202,500 Fund Balance 566,580 574,880 427,780 (388,120) (550,520) 2019 19,000 (530,320) 11/21/2014 1 City of Shorewood Financial Management Plan November 10, 2014 Street Maintenance Fund - This fund covers expenditures related to street reconstruction and sealcoating 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% REVENUES Beginning Balance MSA Maintenance Money Interest Earnings Transfers in Total Revenue EXPENDITURES CAPITAL OUTLAY Other Improvements TOTAL CAPITAL OUTLAY TOTAL EXPENDITURES Revenue over /(under) Ending Fund Balance Actual Budget Projected Projected Projected Projected Projected 2013 2014 2015 2016 2017 2018 2019 1,760,337 2,143,328 1,509,428 1,325,028 977,428 402,828 355,028 9,013 10,700 7,500 6,600 4,900 2,000 1,800 714,000 725,000 740,000 740,000 740,000 740,000 740,000 723,013 735,700 747,500 746,600 744,900 742,000 741,800 340,022 1,369,600 931,900 1,094,200 1,319,500 789,800 1,973,100 340,022 1,369,600 931,900 1,094,200 1,319,500 789,800 1,973,100 340,022 1,369,600 931,900 1,094,200 1,319,500 789,800 1,973,100 382,991 (633,900) (184,400) (347,600) (574,600) (47,800) (1,231,300) 2,143,328 1,509,428 1,325,028 977,428 402,828 355,028 (876,272) 2014 2015 2016 2017 2018 2019 Expenditures 1,369,600 931,900 1,094,200 1,319,500 789,800 1,973,100 Fund Balance 1,509,428 1,325,028 977,428 402,828 355,028 (876,272) 11/21/2014 of • - ••d • November 10, 2014 Trail Construction Fund - This fund covers expenditures related to local trails Actual Budget Projected Projected Projected Projected Projected REVENUES 2013 2014 2015 2016 2017 2018 2019 Beginning Balance (34,576) - 971,959 (668,041) (668,041) (668,041) (1,520,041) Interest Earnings MSA Grants Transfers in from MSA - 405 Transfers in from Sewer - 611 Transfers in from Comm Infr Fund - 450 Total Revenue EXPENDITURES CAPITAL OUTLAY Other Improvements TOTAL CAPITAL OUTLAY 460,943 22,645 1,476, 000 488,371 - - - - - 1,476,000 971,959 - - 1,493,861 - 1,640,000 - - 852,000 852,000 1,493,861 - 1,640,000 - 852,000 852,000 TOTAL EXPENDITURES 1,493,861 - 1,640,000 - - 852,000 852,000 Revenue over /(under) (17,861) 971,959 (1,640,000) - - (852,000) (852,000) Ending Fund Balance (52,437) 971,959 (668,041) (668,041) (668,041) (1,520,041) (2,372,041) 2014 2015 2016 2017 2018 2019 Expenditures - 1,640,000 - - 852,000 852,000 Fund BalancE 971,959 (668,041) (668,041) (668,041) (1,520,041) (2,372,041) III