The URL can be used to link to this page

08-12-19 CC WS Agenda PacketCITY OF SHOREWOOD CITY COUNCIL WORK SESSION MONDAY, AUGUST 12, 2019 AGENDA 1. CONVENE CITY COUNCIL WORK SESSION A. Roll Call B. Review and Adopt Agenda 2. BUDGET 3. ADJOURN 5755 COUNTRY CLUB ROAD COUNCIL CHAMBERS 6:00 P.M. Mayor Zerby Johnson Labadie Siakel Sundberg Finance Director Memo #2 MEETING TYPE City of Shorewood Council Meeting Item Work Session Title / Subject: 2020 Proposed Budget Meeting Date: August 12, 2019 Prepared by: Joe Rigdon, Finance Director Reviewed by: Greg Lerud, City Administrator Attachments: Notable Budget Changes 2019 to 2020 General Fund 2020 Budget Draft Shorewood Community and Event Center 2020 Budget Draft Enterprise Funds 2020 Budget Drafts Park and Equipment Capital Funds Background: 2020 budget worksheets were distributed to department heads in mid -June and staff has subsequently been working on putting together the 2020 preliminary budget and property tax levy. It is anticipated that the Council will adopt the preliminary budget and levy at the September 23 meeting. Following the meeting the City will certify the budget and levy which will go out in November to property owners on their truth -in- taxation notices. General Fund: Expenditures: Overall proposed 2020 General Fund expenditures and transfers out are preliminarily budgeted at $6,630,269 or a 4.9 increase from the 2019 General Fund budget. Included is an increase to operating expenditures of $274,211, or 5.3 %. Total transfers out are budgeted to increase by $36,110 or 3.0 %. This includes a $25,000 increase for street improvements and a $50,000 shift from capital equipment to park improvements. Personnel - related Assumptions: • A full -time position for a Street Inspector /Construction Observer was authorized in 2019 and added to the 2020 budget. The proposed allocations of personnel costs for the new position are: • General Fund (Public Works): 30% • Water 20% • Sewer 30% • Storm Water 20% • Employee 2020 pay step increases are included as applicable. • An employee cost of living adjustment of 3.0% is included for 2020. • Health insurance premiums are scheduled to increase an approximate 10.0% for 2020. • The employer contribution toward insurance premiums is shown with an increase from $1,130 per month in 2019 to $1,180 per month in 2020. 1 General Fund Expenditures and Transfers Out 2020 Proposed Budget Streets 33% Powoniioc- Parks and Recreation 7% General PUblIC batety 36% rent General Fund 2020 revenues and transfers in are preliminarily budgeted at $6,541,196, or a 4.3% increase over the 2019 budget. The property tax levy is proposed to increase by $326,289, with all other General Fund revenues budgeted to decrease $58,625. General Fund Revenues and Transfers In Intergovemmenta 2% Licenses & Permits 3% 2020 Proposed Budget Special Assessments Taxes 90% 2 To balance the 2020 General Fund budget, a "use of reserves" of $89,073 is proposed. This compares to a budgeted use of General Fund reserves of $46,416 in the 2019 budget. Actual results currently project to a General Fund reserves increase for 2019. Shorewood Community and Event Center: The SCEC is funded by facility rentals and annual transfers from the General Fund. For 2020, a transfer of $70,000 is scheduled to assist with operations, and a $32,300 transfer is projected to assist with building improvements. Because it has been less than a year to date with the personnel changes and physical improvements to the facility, staff thought it was not enough time on which to base budget recommendations. Prior to the 2021 budget, staff will evaluate the expenditures and revenues with the anticipation that the annual transfer can be reduced in future years. Enterprise Funds: The City maintains and budgets four enterprise funds: Water, Sewer, Storm Water, and Recycling. These funds are supported by user charges /utility fees. In 2019, the financial impact of completing various city street and utility construction projects was analyzed, and the City Council approved utility rate increases with a goal to sustain positive utility fund cash balances. Property Tax Levy: The City's 2020 preliminary property tax levy of $5,856,611 is 5.9% higher than the 2019 total levy of $5,530,322. Based on the latest property values data supplied by Hennepin County, the City is proposing to increase the payable 2020 City tax rate by 1.5% from 28.539% in 2019 to 28.967% in 2020. $3,000,000,000 $2,500,000,000 $2,000,000,000 $1,500,000,000 $1,000,000,000 $500,000,000 $0 TAXABLE MARKET VALUE $1,828,831,994 $1,685,541,755 $1,755,830,947 $1,524,492,565 $1,588,639,140 2016 2017 2018 2019 2020 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 :-M 60.000% 50.000% 40.000% 30.000% 20.000% 10.000% 0.000% PROPERTY TAX LEVY $5,856,611 $5,079,408 $5,180,996 $5,369,245 $5,530,322 2016 2017 2018 2019 2020 -*-General Fund Levy CITY LOCAL TAX CAPACITY RATE 30.227% 29.450% 28.635% 28.539% 28.967% 2016 2017 2018 2019 2020 General Fund Local Tax Capacity Rate 4 Property owners with no change in market values from payable 2019 to payable 2020 should experience a 1.5% increase in the City portion of their overall property tax bill. In the event of a market value decrease or increase from payable 2019 to payable 2020, City property taxes would change proportionately. The following table calculates the property tax impact on residential homesteads that had no market value change from 2019 to 2020: 2020 CITY PROPERTY TAXES (WITH NO MARKET VALUE CHANGE) Market City Local City Property Percentage Value Tax Tax Capacity Property Taxes Tax 2020 Capacity Rate Taxes Increase Increase NO CHANGE 2020 Pay 2020 2020 (Decrease) (Decrease) $200,000 $1,808 28.967% $524 $8 1.5% $400,000 $3,988 28.967% $1,155 $17 1.5% $600,000 $6,250 28.967% $1,810 $27 1.5% $800,000 $8,750 28.967% $2,535 $37 1.5% $1,000,000 $11,250 28.967% $3,259 $48 1.5% The City's overall market value increased by 4.1% from 2019 to 2020. The largest component, single family residential properties, increased by 3.2 %. After excluding new construction improvement amounts and existing houses improvement amounts, existing houses on average experienced market growth of 1.2% for 2020. The following table calculates the property tax impact on residential homesteads that had an average market value growth increase of 1.2% for 2020. 2020 CITY PROPERTY TAXES (WITH MARKET VALUE INCREAS Market $1,834 28.967% $531 $15 Value City Local City Property Percentage 2020 Tax Tax Capacity Property Taxes Tax INCREASE OF Capacity Rate Taxes Increase Increase 1.2% 2020 Pav 2020 2020 (Decrease) (Decrease) $202,400 $1,834 28.967% $531 $15 3.0% $404,800 $4,040 28.967% $1,170 $32 2.8% $607,200 $6,340 28.967% $1,836 $53 3.0% $809,600 $8,870 28.967% $2,569 $72 2.9% $1,012,000 $11,400 28.967% $3,302 $92 2.9% 5 Council Direction: In addition to answering Council questions and providing any additional information you need, Staff would like direction on the following items: Level of change to the overall 2020 property tax levy. The preliminary budget includes a 5.9% increase in the levy from 2019 to 2020. As described, the tax impact (percentage change in taxes) to homeowners may be less than the 5.9% percentage increase in the total levy, along the lines of a 1.5% to 3.0% increase. This is due to the spreading of taxes on an increased property tax base. In recent years, the overall property value of the City has increased at a faster rate than the property tax levy, resulting in a slow decline to the local tax rate. The 2020 preliminary budget reverses that trend, and includes a modest 1.5% increase to the local tax rate. As you can see from the previous tables, a 5.9% levy increase results in a $27 annual property tax increase on a $600,000 valued home that experienced no valuation increase (less than $2.50 per month). If that same property increased the average value of all increases, the annual property tax increase would be $53 or less than $4.50 per month. Funding the Parks capital improvement plan (CIP). In recent years, the parks CIP has included significant expenditures for projects and proposes various improvements going forward. Sources to pay for park improvements have included park dedication fees, grants, and transfers from the General Fund. However, the parks CIP projects a deficit as soon as 2021. Future sources could include: • Increase in the annual transfer from the General Fund. This would potentially result in an increase to the property tax levy. • Shift of capital transfers. It appears that around $50,000 per year of the amount transferred annually to the Equipment Replacement Fund could be shifted to the Parks Fund without depleting the Equipment fund. This would significantly assist the Parks Fund, but may not entirely fund the CIP. • Parks grants • Parks referendum Evaluation of the Enterprise funds rates as proposed by David Drown Associates. At the annual Council retreat, Shannon Sweeney of David Drown Associates presented a rate analysis for the city's utility enterprise funds. The analysis showed fairly significant increases going out ten years. Staff proposes using those recommended rates going forward and would like to hear if the Council supports that approach or if the Council would like to see changes. Next Steps and Timelines: Staff will revisit any areas and incorporate any recommendations or directions made by the Council. If additional meeting or work session time is necessary, it will be scheduled. If additional time is not needed, the 2020 preliminary budget will be on the September 23 City Council agenda for approval. Staff will submit the required information to Hennepin County. City of Shorewood Notable Budget Changes 2019 to 2020 Budget Change ($) Department Account 2019 to 2020 Comment GENERAL FUND Revenues Taxes 326,289 5.9% increase to the property tax levy Revenues Building Permits (5,000) reduce reliance on variable revenues Revenues Miscellaneous Grants (15,000) adjust Christmas Lake AIS grant (pass- through); offset to Park Maint Revenues Excelsior Annexation Detachment (17,100) overstated in 2019 budget Revenues Interest Earnings (10,000) reduce reliance on variable revenues Revenues Miscellaneous Revenue (14,000) reduce reliance on variable revenues Council Travel, Conference & School (4,500) reclassification of Council expenditures (Nets to $0 change) Council Events 11,500 reclassification of Council expenditures (Nets to $0 change) Council Contractual Services 2,000 reclassification of Council expenditures (Nets to $0 change) Council Dues and Subscriptions (9,000) reclassification of Council expenditures (Nets to $0 change) Administration Full -Time 17,979 step increases; COLA Administration Dues and Subscriptions 8,350 includes See Click Fix and web site costs Elections All Finance Full -Time Finance Bank Service Charges Planning Full -Time Municipal Buildings Insurance Police Contractual Services Fire Protective Inspections Protective Inspections Contractual Services Full -Time Contractual Services 7 26,000 5,110 3,700 7,562 5,000 25,552 41,356 8,631 7,000 2020 is an on year for elections step increases; COLA includes credit card transaction fees and bank charges step increases; COLA increase for property/liability insurance operating budget increase of $26,913; capital decrease of $1,361 Mound fire of 26,828 not included in 2019 budget step increases; COLA contracted inspection services City of Shorewood Notable Budget Changes 2019 to 2020 Shorewood Community & Event Center Revenues Rental Income 11,000 reflect increased revenue trend Water Fund Water Full -Time 26,621 step increases; COLA; 20% of new Street Inspector position Water Insurance (8,000) code not utilized Sewer Fund Sewer Full -Time Budget step increases; COLA; 30% of new Street Inspector position Sewer MCES SAC Charges Change (S) adjust to 2020 Met Council estimate (BEING REVIEWED) Department Account 2019 to 2020 Comment Sewer Contractual Services 12,000 includes sewer televising Public Works Full -Time 49,132 step increases; COLA; 30% of new Street Inspector position Public Works Employee Insurance 8,068 includes 30% of new Street Inspector position Public Works Maintenance of Buildings 6,000 increase projected Ice & Snow Removal General Supplies 8,000 ice and snow removal materials Park Maintenance Full -Time 7,104 step increases; COLA Park Maintenance Engineering Fees (9,000) not utilized in prior years Park Maintenance Contractual Services (15,000) adjust Christmas Lake AIS grant (pass- through) Transfers Out Park Improvements 53,000 shift of $50,000 to Park Improvements from Equipment Replacement Transfers Out Equipment Replacement (45,000) shift of $50,000 to Park Improvements from Equipment Replacement Transfers Out Street Improvements 25,000 increase of $25,000 for 2020 Shorewood Community & Event Center Revenues Rental Income 11,000 reflect increased revenue trend Water Fund Water Full -Time 26,621 step increases; COLA; 20% of new Street Inspector position Water Insurance (8,000) code not utilized Sewer Fund Sewer Full -Time 32,510 step increases; COLA; 30% of new Street Inspector position Sewer MCES SAC Charges (45,483) adjust to 2020 Met Council estimate (BEING REVIEWED) Sewer Insurance (7,000) code not utilized Sewer Contractual Services 12,000 includes sewer televising 8 City of Shorewood Notable Budget Changes 2019 to 2020 Budget Change (S) Department Account 2019 to 2020 Comment Storm Water Fund Storm Water Full -Time 17,819 step increases; COLA; 20% of new Street Inspector position Storm Water Maintenance of Equipment (30,000) code not utilized General Fund 2020 Budget Summary YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number 2016 2017 2018 2018 2019 2019 2020 2020 2020 Taxes 5,129,619 5,221,374 5,369,245 5,342,946 5,530,322 2,862,223 5,856,611 326,289 5.9% Licenses & Permits 340,111 315,574 245,155 565,687 232,225 300,149 227,225 (5,000) -2.2% Intergovernmental 172,806 144,922 91,250 125,140 152,100 48,952 123,500 (28,600) -18.8% Charges for Services 51,318 62,056 53,885 57,761 53,885 31,930 52,860 (1,025) -1.9% Fines & Forfeitures 48,868 76,056 60,000 67,734 60,000 29,727 60,000 0 0.0% Special Assessments 0 0 0 3,846 0 6,516 0 0 N/A Miscellaneous 299,374 232,859 215,000 225,690 220,000 187,714 196,000 (24,000) -10.9% TOTAL REVENUES 6,042,096 6,052,841 6,034,535 6,388,804 6,248,532 3,467,211 6,516,196 267,664 4.3% OTHER FINANCING SOURCES Sales of Capital Assets 0 0 0 0 0 0 0 0 N/A Transfers In 25,000 25,000 25,000 25,000 25,000 25,000 25,000 0 0.0% TOTAL OTHER FINANCING SOURCES 25,000 25,000 25,000 25,000 25,000 25,000 25,000 0 0.0% TOTAL REVENUES AND OTHER FINANCING SOURCES 6,067,096 6,077,841 6,059,535 6,413,804 6,273,532 3,492,211 6,541,196 267,664 4.3% EXPENDITURES GENERAL GOVERNMENT Council 162,138 108,146 84,100 77,233 84,100 31,984 84,100 0 0.0% Administration 420,783 450,889 447,024 443,412 492,899 241,184 527,170 34,271 7.0% Elections 12,409 0 21,975 16,161 0 0 26,000 26,000 N/A Finance 181,343 200,483 172,483 186,792 198,329 110,345 210,686 12,357 6.2% Professional Services 252,052 265,077 240,000 236,627 251,500 126,591 252,000 500 0.2% Planning 195,958 295,551 190,361 233,651 221,657 112,345 231,497 9,840 4.4% Municipal Buildings 188,644 172,874 207,600 167,255 182,500 135,376 197,500 15,000 8.2% TOTAL GENERAL GOVERNMENT 1,413,326 1,493,020 1,363,543 1,361,131 1,430,985 757,825 1,528,953 97,968 6.8% PUBLIC SAFETY Police 1,327,352 1,398,020 1,449,930 1,453,368 1,481,949 904,946 1,507,501 25,552 1.7% Fire 639,088 629,587 625,953 651,925 651,969 509,098 693,325 41,356 6.3% Protective Inspections 142,259 165,476 144,263 216,732 138,033 142,159 153,586 15,553 11.3% TO TAL PUBLIC SA FE TY 2,108,700 2,193,083 2,220,146 2,322,025 2,271,951 1,556,203 2,354,412 82,461 3.6% 10 General Fund 2020 Budget Summary Account Number STREETS Engineer Public Works Ice and Snow Removal TOTAL STREETS PARKS AND RECREATION Park Maintenance Recreation TOTAL PARKS AND RECREATION TOTAL EXPENDITURES OTHER FINANCING USES Transfers Out TOTAL EXPENDITURES AND OTHER FINANCING USES EXCESS (DEFICIENCY) OF REVENUES AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/19/19 Budget Change Change 2016 2017 2018 2018 2019 2019 2020 2020 2020 100,561 83,314 89,500 83,057 89,500 49,704 90,250 750 0.8% 620,286 604,553 1,019,797 791,093 911,296 389,009 996,631 85,335 9.4% 50,928 62,486 113,931 140,111 101,379 92,442 113,062 11,683 11.5% 771,775 750,353 1,223,228 1,014,261 1,102,176 531,155 1,199,943 97,768 8.9% 232,111 227,701 196,932 221,580 265,316 81,778 258,889 (6,427) -2.4% 51,456 51,309 65,889 52,953 63,216 32,577 65,657 2,442 3.9% 283,567 279,010 262,820 274,533 328,531 114,355 324,546 (3,986) -1.2% 4,577,368 4,715,466 5,069,737 4,971,950 5,133,643 2,959,538 5,407,854 274,211 5.3% 1,387,313 1,804,913 1,163,895 1,182,745 1,186,305 1,646,305 1,222,415 36,110 3.0% 5,964,681 6,520,379 6,233,632 6,154,695 6,319,948 4,605,843 6,630,269 310,321 4.9% 102,416 (442,538) (174,097) 259,109 (46,416) (1,113,632) (89,073) (42,657) 91.9% 1E General Fund 2020 Budget Revenues by Line Item YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 REVENUES TAXES 101 -00- 3010 -0000 CURRENT AD VALOREM TAXES 4,972,519 5,062,967 5,369,245 5,215,215 5,530,322 2,759,779 �l 326,289 5.9% 101 -00- 3011 -0000 DELINQUENT AD VALOREM TAXES 30,155 27,640 0 (6,411) 0 23,744 0 0 N/A 101 -00- 3100 -0000 FISCAL DISPARITIES 119,405 121,979 0 127,622 0 71,823 0 0 N/A 101 -00- 3180 -0000 OTHER TAXES 0 0 0 0 0 0 0 0 N/A 101 -00- 3191 -0000 PENALTIES & INT. ON AD VALOREM 7,541 3,578 0 3,818 0 3,947 0 0 N/A 101 -00- 3192 -0000 TAX FORFEIT SALE 0 5,210 0 2,702 0 2,930 0 0 N/A Total Taxes 5,129,619 5,221,374 5,369,245 5,342,946 5,530,322 2,862,223 5,856,611 326,289 5.9% LICENSES & PERMITS 101 -00- 3211 -0000 LIQUOR LICENSES 1,430 3,630 1,430 5,069 3,500 0 3,500 0 0.0% 101 -00- 3212 -0000 TOBACCO LICENSES 1,350 1,250 500 1,250 500 0 500 0 0.0% 101 -00- 3215 -0000 REFUSE COLLECTION LICENSES 1,375 1,300 1,375 1,400 1,375 0 1,375 0 0.0% 101 -00- 3216 -0000 TREE TRIMMING LICENSES 790 720 500 840 500 450 500 0 0.0% 101 -00- 3217 -0000 RENTAL HOUSING LICENSES 0 0 0 (75) 0 0 0 0 N/A 101 -24- 3217 -0000 RENTAL HOUSING LICENSES 1,380 1,900 2,400 6,815 2,400 560 2,400 0 0.0% 101 -00- 3218 -0000 OTHER BUSINESS LICENSES &PEN 734 676 750 684 750 434 750 0 0.0% 101 -00- 3219 -0000 LAWN FERTILIZER LICENSE 240 180 200 280 200 210 200 0 0.0% 101 -00- 3221 -0000 BUILDING PERMITS 17,400 8,951 0 12,338 0 10,474 0 0 N/A 101 -24- 3221 -0000 BUILDING PERMITS 226,476 236,513 190,000 381,203 180,000 204,804 175,000 (5,000) -2.8% 101 -00- 3222 -0000 PLAN CHECK FEES 0 0 0 0 0 0 0 0 N/A 101 -24- 3222 -0000 PLAN CHECK FEES 86,516 56,924 45,000 152,424 40,000 80,702 40,000 0 0.0% 101 -00- 3223 -0000 DOG LICENSES 2,246 2,405 2,000 1,824 2,000 1,390 2,000 0 0.0% 101 -00- 3224 -0000 FARM ANIMAL PERMIT 50 50 0 100 0 50 0 0 N/A 101 -00- 3225 -0000 HORSE PERMITS 25 25 0 0 0 25 0 0 N/A 101 -00- 3226 -0000 OTHER NON-BUSINESS LICENSES AN 0 0 0 35 0 0 0 0 N/A 101 -00- 3235 -0000 SOLICITOR PERMIT 100 1,050 1,000 1,500 1,000 1,050 00 0 0.0% Total Licenses & Permits 340,111 315,574 245,155 565,687 232,225 300,149 227,225 (5,000) -2.2% INTERGOVERNMENTAL 101 -00- 3314 -0000 BULLETPROOF VEST GRANT 2,011 1,328 0 1,429 0 0 0 0 N/A 101 -00- 3316 -0000 FEMA STORM DISASTER AID 1,858 715 0 0 0 0 0 0 N/A 101 -00- 3341 -0000 LOCAL PERFORMANCE AID 1,044 0 0 0 0 0 0 0 N/A 101 -00- 3343 -0000 MKT VALUE CREDIT AID 49 43 0 42 0 0 0 0 N/A 101 -00- 3344 -0000 PERA AID 4,751 4,751 4,750 4,751 4,750 0 4,750 0 0.0% 101 -00- 3345 -0000 MUNICIPAL STATE AID FOR STREET 88,022 86,868 75,000 97,073 93,500 48,952 97,000 3,500 3.7% 101 -00- 3362 -0000 MISCGRANTS 75,070 32,367 11,500 20,096 35,000 0 20,000 (15,000) -42.9% 101 -00- 3365 -0000 EXCELSIOR ANNEX- DETACH 0 18,850 0 1,749 18,850 0 , 1,750 (17,100) -90.7% Total Intergovemmental 172,806 144,922 91,250 125,140 152,100 48,952 123,500 (28,600) -18.8% CIiARGES FOR SERVICES 101 -00- 3400 -0000 CHARGES FOR SERVICES 0 0 0 0 0 0 0 0 N/A 101 -00- 3410 -0000 RENTAL INCOME 0 0 0 0 0 0 0 0 N/A 101 -00- 3413 -0000 ZONING AND SUBDIVISION FEES 14,645 11,239 11,000 13,925 11,000 10,427 10,000 (1,000) -9.1% 12 General Fund 2020 Budget Revenues by Line Item YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 101 -18- 3413 -0000 ZONING & SUBDIVISION FEES 0 0 0 0 0 0 0 0 N/A 101 -00- 3414 -0000 PASS -THRU CHARGES (1,280) 3,764 0 0 0 (259) 0 0 N/A 101 -00- 3415 -0000 SALE OF COPIES 207 208 250 1,129 250 387 250 0 0.0% 101 -00- 3417 -0000 SPECIAL ASSESSMENT SEARCHES 25 25 25 175 25 0 0 (25) - 100.0% 101 -00- 3420 -0000 ELECTION FILING FEES 6 0 10 8 10 0 10 0 0.0% 101 -00- 3470 -0000 PARK DEDICATION FEES 0 0 0 0 0 0 0 0 N/A 101 -00- 3471 -0000 PARK FEES & RENTALS 32,650 40,839 35,000 35,790 35,000 17,817 35,000 0 0.0% 101 -53- 3471 -0000 PARK FEES & RENTALS 0 0 0 0 0 0 0 0 N/A 101 -00- 3472 -0000 TREE SALES 1,925 2,557 3,000 4,117 3,000 2,674 3,000 0 0.0% 101 -00- 3473 -0000 PARK PROGRAM FEES 0 0 0 130 0 (65) 0 0 N/A 101 -53- 3473 -0000 PARK PROGRAM FEES 0 0 0 0 0 0 0 0 N/A 101 -00- 3474 -0000 ARCTIC FEVER DONATIONS 3,269 2,650 3,000 2,356 3,000 1,301 2,500 (500) -16.7% 101 -53- 3476 -0000 COMM GARDEN PLOT RENTAL 1,185 1,230 1,200 1,260 1,200 1,205 1,200 0 0.0% 101 -53- 3478 -0000 SAFETY CAMP (489) (112) 0 421 0 43 500 500 N/A 101 -53- 3479 -0000 MUSIC IN THE PARK (1,045) (800) 0 (1,800) 0 (1,800) 0 0 N/A 101 -53- 3481 -0000 GARDEN FAIR (30) (24) 0 0 0 0 0 0 N/A 101 -00- 3482 -0000 Special Event Permit Fees 250 480 400 250 400 200 400 0 0.0% Total Charges for Services 51,318 62,056 53,885 57,761 53,885 31,930 52,860 (1,025) -1.9% FINES & FORFEITURES 101 -00- 3510 -0000 FINES & FORFEITS 48,868 75,616 60,000 67,734 60,000 29,727 60,000 0 0.0% 101 -00- 3511 -0000 IMPOUND FEES 0 440 0 0 0 0 0 0 N/A Total Fines & Forfeitures 48,868 76,056 60,000 67,734 60,000 29,727 60,000 0 0.0% SPECIAL ASSESSMENTS 101 -00- 3610 -0000 SPECIAL ASSESSMENT - CURRENT 0 0 0 3,846 0 6,516 0 0 N/A 101 -00- 3611 -0000 SPECIAL ASSESSMENT - DELINQUENT 0 0 0 0 0 0 0 0 N/A 101 -00- 3614 -0000 SPECIAL ASSESSMENT - INTEREST 0 0 0 0 0 0 0 0 N/A Total Special Assessments 0 0 0 3,846 0 6,516 0 0 N/A MISCELLANEOUS 101 -00- 3620 -0000 INTEREST EARNINGS 59,413 20,024 35,000 32,875 35,000 63 25,000 (10,000) -28.6% 101 -00- 3623 -0000 CONTRIBUTIONS AND DONATIONS 300 0 0 0 0 0 0 0 N/A 101 -53- 3623 -0000 PARK DONATIONS 250 2,000 0 0 0 0 0 0 N/A 101 -00- 3624 -0000 REFUNDS & REIMBURSEMENTS 61,591 37,173 15,000 20,036 15,000 23,930 15,000 0 0.0% 101 -00- 3626 -0000 DRY HYDRANT CHARGES 263 0 0 0 0 0 0 0 N/A 101 -00- 3627 -0000 CELLULAR ANTENNA REVENUE 159,121 167,799 150,000 171,496 155,000 163,155 155,000 0 0.0% 101 -00- 3630 -0000 LEASE REVENUE 394 0 0 394 0 0 0 0 N/A 101 -00- 3670 -0000 MISCELLANEOUS REVENUE 18,042 5,863 15,000 889 15,000 566 1,000 14,000 -93.3% Total Miscellaneous 299,374 232,859 215,000 225,690 220,000 187,714 196,000 (24,000) -10.9% TOTAL REVENUES 6,042,096 6,052,841 6,034,535 6,388,804 6,248,532 3,467,211 6,516,196 267,664 4.3% 101 -00- 3910 -0000 SALES OF CAPITAL ASSETS 0 0 0 0 0 0 0 0 N/A 13 General Fund 2020 Budget Revenues by Line Item Account Number 101 -00- 3920 -0000 TRANSFERS IN TOTAL OTHER FINANCING SOURCES TOTAL REVENUES AND OTHER FINANCING SOURCES YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/19/19 Budget Change Change 2016 2017 2018 2018 2019 2019 2020 2020 2020 25,000 25,000 25,000 25,000 25,000 25,000 ' 25,000 0 0.0% 25,000 25,000 25,000 25,000 25,000 25,000 25,000 0 0.0% 14 General Fund 2020 Budget Expenditures by Line Item ANNUMM 101 -11- 4245 -0000 GENERAL SUPPLIES 1,330 2,687 2,000 3,366 2,000 YTD Preliminary Budget 0.0% Percentage CONSULTING FEES 0 Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 101 -11- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 10,959 11,674 7,500 EXPENDITURES 7,500 99 3,000 (4,500) -60.0% 101 -11- 4346 -0000 EVENTS 0 0 0 0 DEPT 11 COUNCIL 11,500 11,500 N/A 101 -11- 4351 -0000 PRINTING AND PUBLISHING 0 0 0 0 0 PERSONAL SERVICES 0 0 N/A 101 -11- 4400 -0000 CONTRACTUAL SERVICES 87,789 33,387 0 1,529 0 101 -11- 4103 -0000 PART -TINE 20,600 20,600 21,000 20,600 21,000 10,300 21,000 0 0 0.0% 101 -11- 4121 -0000 PERA CONTRIB - CITY SHARE 0 0 0 0 0 0 0 52,000 0 N/A 101 -11- 4122 -0000 FICA CONTRIB - CITY SHARE 1,576 1,576 1,600 1,576 1,600 788 1,600 0 0 0.0% 101 -11- 4151 -0000 WORKERS CONDENSATION 0 0 0 0 0 0 0 59,500 0 N/A Total Personal Services 22,175 22,176 22,600 22,176 22,600 11,088 22,600 0 0 0.0% ANNUMM 101 -11- 4245 -0000 GENERAL SUPPLIES 1,330 2,687 2,000 3,366 2,000 631 2,000 0 0.0% 101 -11- 4302 -0000 CONSULTING FEES 0 0 0 0 0 0 0 0 N/A Total Supplies 1,330 2,687 2,000 3,366 2,000 631 2,000 0 0.0% OTHER SERVICES AND CHARGES 101 -11- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 10,959 11,674 7,500 10,943 7,500 99 3,000 (4,500) -60.0% 101 -11- 4346 -0000 EVENTS 0 0 0 0 0 0 11,500 11,500 N/A 101 -11- 4351 -0000 PRINTING AND PUBLISHING 0 0 0 0 0 0 0 0 N/A 101 -11- 4400 -0000 CONTRACTUAL SERVICES 87,789 33,387 0 1,529 0 524 2,000 2,000 N/A 101 -11- 4410 -0000 RENTALS 0 0 0 0 0 0 0 0 N/A 101 -11- 4433 -0000 DUES AND SUBSCRIPTIONS 39,886 38,222 52,000 39,219 52,000 19,642 43,000 (9,000) -17.3% 101 -11- 4440 -0000 NISC SERVICES /CONTINGENCY 0 0 0 0 0 0 0 0 N/A Total Other Services and Charges 138,633 83,283 59,500 51,691 59,500 20,265 59,500 0 0.0% Total Council 161138 108.146 84.100 77.233 84.100 3L984 84.100 0 0.0% 15 General Fund 2020 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 DEPT 13 ADMINISTRATION 101 -13- 4101 -0000 FULL -TIME REGULAR 185,933 281,941 281,719 272,295 303,361 146,532 321,340 17,979 5.9% 101 -13- 4102 -0000 OVERTIME 0 0 0 0 0 2,430 0 0 N/A 101 -13- 4103 -0000 PART -TIME 8,693 8,600 13,718 12,616 23,769 10,729 26,312 2,543 10.7% 101 -13- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 101 -13- 4121 -0000 PERA CONTRIB - CITY SHARE 14,147 21,063 22,158 21,471 24,535 11,968 26,074 1,539 6.3% 101 -13- 4122 -0000 FICA CONTRIB - CITY SHARE 18,547 22,202 22,601 21,782 25,025 11,860 26,595 1,570 6.3% 101 -13- 4131 -0000 EMPLOYEE INSURANCE - CITY 32,684 45,799 39,915 45,885 42,673 25,676 46,599 3,926 9.2% 101 -13- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 101 -13- 4151 -0000 WORKERS COMPENSATION 2,427 3,767 2,363 3,669 2,586 1,380 2,750 164 6.3% Total Personal Services 262,431 383,372 382,474 377,718 421,949 210,575 449,670 27,721 6.6% SUPPLIES 101 -13- 4200 -0000 OFFICE SUPPLIES 5,065 4,848 5,000 5,140 5,000 2,596 5,000 0 0.0% 101 -13- 4208 -0000 POSTAGE 9,469 13,086 11,000 8,676 11,000 4,339 11,000 0 0.0% 101 -13- 4221 -0000 MAINTENANCE OF EQUIPMENT 965 2,851 4,000 2,373 4,000 604 4,000 0 0.0% 101 -13- 4245 -0000 GENERAL SUPPLIES 1,799 314 1,000 740 1,000 119 1,000 0 0.0% 37,158 32,000 24,626 32,000 11,024 32,000 0 0.0% 101 -13- 4433 Total Supplies 17,298 21,099 21,000 16,929 21,000 7,658 21,000 0 0.0% 101 -13- 4321 -0000 COMMUNICATIONS - VOICE/DATA 0 360 0 0 0 0 0 0 N/A 101 -13- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 4,056 4,045 7,800 6,502 11,800 2,874 10,000 (1,800) -15.3% 101 -13- 4351 -0000 PRINTING AND PUBLISHING 4,128 3,202 3,000 2,778 4,500 1,808 4,500 0 0.0% 101 -13- 4400 -0000 CONTRACTUAL SERVICES 132,380 37,158 32,000 24,626 32,000 11,024 32,000 0 0.0% 101 -13- 4433 -0000 DUES AND SUBSCRIPTIONS 490 1,653 750 14,859 1,650 7,245 10,000 8,350 506.1% Total Other Services and Charges 141,053 46,418 43,550 48,765 49,950 22,951 56,500 6,550 13.1 Total Administration 420,783 450,889 447,024 443,412 492,899 241,184 527,170 34,271 7.0% 16 General Fund 2020 Budget Expenditures by Line Item SUPPLIES 0 YTD Preliminary Budget Percentage MAINTENANCE OF EQUIPMENT Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 101 -14- 4440 -0000 MISC SERVICES /CONTINGENCY N/A Total Other Services and Charges 0 DEPT 14 ELECTIONS 1,946 0 0 2,500 PERSONAL SERVICES N/A 101 -14- 4107 -0000 ELECTION JUDGE 12,409 0 14,700 9,977 0 0 16,500 16,500 N/A Total Personal Services 12,409 0 14,700 9,977 0 0 16,500 16,500 N/A SUPPLIES 0 101 -14- 4200 -0000 OFFICE SUPPLIES 101 -14- 4221 -0000 MAINTENANCE OF EQUIPMENT 101 -14- 4245 -0000 GENERAL SUPPLIES N/A Total Supplies OTHER SERVICES AND CHARGES 101 -14- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 101 -14- 4351 -0000 PRINTING AND PUBLISHING 101 -14- 4440 -0000 MISC SERVICES /CONTINGENCY N/A Total Other Services and Charges 0 Total Elections 0 0 790 721 0 0 1,000 1,000 N/A 0 0 1,900 2,715 0 0 3,000 3,000 N/A 0 0 1,410 1,946 0 0 2,500 2,500 N/A 0 0 4,100 5,382 0 0 6,500 6,500 N/A 0 0 0 743 0 0 1,000 1,000 N/A 0 0 2,500 59 0 0 1,000 1,000 N/A 0 0 675 0 0 0 11000 11000 N/A 0 0 3,175 802 0 0 3,000 3,000 N/A 11409 0 21975 16.161 0 0 26.000 26.000 N/A 17 General Fund 2020 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 DEPT 15 FINANCE 101 -15- 4101 -0000 FULL -TIME REGULAR 114,756 78,036 49,344 82,459 132,598 67,119 137,708 5,110 3.9% 101 -15- 4102 -0000 OVERTIME 0 0 0 0 0 0 0 0 N/A 101 -15- 4103 -0000 PART -TIME 0 0 0 0 0 0 0 0 N/A 101 -15- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 101 -15- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 101 -15- 4121 -0000 PERA CONTRIB - CITY SHARE 8,738 5,552 3,701 6,185 9,945 5,034 10,328 383 3.9% 101 -15- 4122 -0000 FICACONTRIB - CITYSHARE 8,364 5,776 3,775 6,305 10,144 5,138 10,535 391 3.9% 101 -15- 4131 -0000 EMPLOYEE INSURANCE - CITY 13,760 9,117 5,768 8,698 13,127 8,475 15,265 2,138 16.3% 101 -15- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 14,194 0 3,509 0 0 0 0 N/A 101 -15- 4151 -0000 WORKERS COMPENSATION 780 729 395 682 915 357 950 35 3.8% 93,900 Total Personal Services 146,398 113,404 62,983 107,838 166,729 86,123 174,786 8,057 4.8% AwwwNeW 101 -15- 4200 -0000 OFFICE SUPPLIES 1,283 198 600 583 600 1215 600 0 0.0% 101 -15- 4221 -0000 MAINTENANCE OF EQUIPMENT 13,697 14,383 15,000 14,943 15,000 15,688 16,000 1,000 6.7% 101 -15- 4245 -0000 GENERAL SUPPLIES 0 0 0 62 0 22 0 0 N/A Total Supplies 14,980 14,581 15,600 15,588 15,600 15,831 16,600 1,000 6.4% 101 -15- 4301 -0000 AUDITING & ACCOUNTING 11,175 0 0 0 0 0 0 0 N/A 101 -15- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 1,758 1,241 2,000 1,821 4,000 663 3,500 (500) -12.5% 101 -15- 4351 -0000 PRINTING AND PUBLISHING 109 (109) 1,000 2,326 2,000 1,716 2,100 100 5.0% 101 -15- 4360 -0000 INSURANCE 0 0 0 0 0 0 0 0 N/A 101 -15- 4400 -0000 CONTRACTUAL SERVICES 0 63,861 84,000 49,096 1,000 0 1,000 0 0.0% 101 -15- 4433 -0000 DUES AND SUBSCRIPTIONS 220 90 400 711 1,200 550 1,200 0 0.0% 101 -15- 4440 -0000 MISC SERVICES /CONTINGENCY 0 0 0 0 0 0 0 0 N/A 101 -15- 4450 -0000 BANK SERVICE CHARGES 6,703 7,415 6,500 9,412 7,800 5,462 11,500 3,700 47.4% Total Other Services and Charges 19,965 72,498 93,900 63,366 16,000 8,391 19,300 3,300 20.6% Total Finance 181,343 200,483 172,483 186,792 198,329 110,345 210,686 12,357 6.2% 18 General Fund 2020 Budget Expenditures by Line Item 19 YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 DEPT 16 PROFESSIONAL SERVICES SUPPLIES 101 -16- 4200 -0000 OFFICE SUPPLIES 0 0 0 0 0 0 0 0 N/A OTHER SERVICES AND CHARGES 101 -16- 4301 -0000 AUDITING & ACCOUNTING 31,769 29,547 30,000 30,280 31,500 30,500 32,000 500 1.6% 101 -16- 4304 -0000 LEGAL FEES 102,206 112,902 90,000 78,711 90,000 30,591 90,000 0 0.0% 101 -16- 4400 -0000 CONTRACTUAL SERVICES 118,077 122,628 120,000 127,636 130,000 65,500 130,000 0 0.0% Total Other Services and Charges 252,052 265,077 240,000 236,627 251,500 126,591 252,000 500 0.2% Total Professional Services 252,052 265,077 240,000 236,627 251,500 126,591 252,000 500 0.2% 19 General Fund 2020 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 DEPT 18 PLANNING 101 -18- 4101 -0000 FULL -TIME REGULAR 137,309 181,311 143,665 138,730 152,063 73,590 159,625 7,562 5.0% 101 -18- 4102 -0000 OVERTIME 0 0 0 0 0 0 0 0 N/A 101 -18- 4103 -0000 PART -TIME 0 0 0 0 7,129 2,075 7,956 827 11.6% 101 -18- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 101 -18- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 101 -18- 4121 -0000 PERA CONTRIB - CITY SHARE 10,493 9,115 10,775 10,612 11,939 5,676 12,569 630 5.3% 101 -18- 4122 -0000 FICA CONTRIB - CITY SHARE 10,557 13,888 10,990 10,832 12,178 5,806 12,820 642 5.3% 101 -18- 4131 -0000 EMPLOYEE INSURANCE - CITY 24,177 20,614 11,136 24,960 23,508 14,604 25,842 2,334 9.9% 101 -18- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 101 -18- 4151 -0000 WORKERS COMPENSATION 1,081 1,448 945 1,281 840 485 885 45 5.4% CONTRACTUAL SERVICES Total Personal Services 183,617 226,376 177,511 186,415 207,657 102,236 219,697 12,040 5.8 AwwwNeW 101 -18- 4200 -0000 OFFICE SUPPLIES 0 0 0 352 0 0 0 0 N/A 101 -18- 4208 -0000 POSTAGE 7 30 0 0 0 44 0 0 N/A 101 -18- 4221 -0000 MAINTENANCE OF EQUIPMENT 400 400 0 400 400 0 400 0 0.0% 101 -18- 4245 -0000 GENERAL SUPPLIES 0 19 450 458 200 0 200 0 0.0% Total Supplies 407 449 450 1,210 600 44 600 0 0.0% OTHER SERVICES AND CHARGES 101 -18- 4304 -0000 LEGAL FEES 1,779 7,563 0 7,433 2,000 7,424 2,000 0 0.0% 101 -18- 4321 -0000 COMMUNICATIONS - VOICE/DATA 625 489 1,000 0 0 0 0 0 N/A 101 -18- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 3,207 972 4,200 894 4,200 138 2,000 (2,200) -52.4% 101 -18- 4351 -0000 PRINTING AND PUBLISHING 2,189 2,673 2,000 1,518 2,000 334 2,000 0 0.0% 101 -18- 4400 -0000 CONTRACTUAL SERVICES 3,466 56,195 4,000 36,006 4,000 2,169 4,000 0 0.0% 101 -18- 4433 -0000 DUES AND SUBSCRIPTIONS 668 724 1,200 175 1,200 0 1,200 0 0.0% 101 -18- 4440 -0000 MISC SERVICES /CONTINGENCY 0 110 0 0 0 0 0 0 N/A Total Other Services and Charges 11,934 68,726 12,400 46,026 13,400 10,065 11,200 (2,200) -16.4% Total Planning 195,958 295,551 190,361 233,651 221,657 112,345 231,497 9,840 4.4% 20 General Fund 2020 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 DEPT 19 MUNICIPAL BUILDINGS SUPPLIES Total Supplies 33,850 17,068 22,000 101 -19- 4221 -0000 MAINTENANCE OF EQUIPMENT 28,171 8,358 10,000 9,286 10,000 3,592 12,000 2,000 20.0% 101 -19- 4223 -0000 MAINTENANCE OF BUILDINGS 3,518 6,646 10,000 5,957 10,000 318 10,000 0 0.0% 101 -19- 4245 -0000 GENERAL SUPPLIES 2,161 2,064 2,000 3,086 2,000 1,309 3,000 1,000 50.0% 21 Total Supplies 33,850 17,068 22,000 18,329 22,000 5,219 25,000 3,000 13.6% OTHER SERVICES AND CHARGES 101 -19- 4321 -0000 COMMUNICATIONS - VOICE/DATA 42,402 44,961 44,000 43,485 44,000 25,073 48,000 4,000 9.1 101 -19- 4360 -0000 INSURANCE 83,340 86,955 116,000 79,027 90,000 91,396 95,000 5,000 5.6% 101 -19- 4361 -0000 INSURANCE DEDUCTIBLE 0 0 0 0 0 0 0 0 N/A 101 -19- 4380 -0000 UTILITY SERVICES 14,888 7,330 11,000 8,974 11,000 3,808 11,000 0 0.0% 101 -19- 4400 -0000 CONTRACTUAL SERVICES 13,039 14,881 13,100 16,534 14,000 9,106 17,000 3,000 21.4% 101 -19- 4410 -0000 RENTALS 591 985 1,000 591 1,000 502 1,000 0 0.0% 101 -19- 4433 -0000 DUES AND SUBSCRIPTIONS 534 672 500 217 500 235 500 0 0.0% 101 -19- 4437 -0000 TAXES/LICENSES 0 0 0 0 0 17 0 0 N/A 101 -19- 4440 -0000 MISC SERVICES /CONTINGENCY 0 22 0 98 0 20 0 0 N/A Total Other Services and Charges 154,794 155,806 185,600 148,926 160,500 130,157 172,500 12,000 7.5% Total Municipal Buildings 188,644 172,874 207,600 167,255 182,500 135,376 197,500 15,000 8.2% TOTAL GENERAL GOVERNMENT 1,413,326 1,493,020 1,363,543 1,361,131 1,430,985 757,825 1,528,953 97,968 6.8% 21 General Fund 2020 Budget Expenditures by Line Item 101 -21- 4360 -0000 INSURANCE YTD Preliminary Budget Percentage 0 0 Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 1,234,633 1,236,287 1,265,693 742,359 1,292,606 DEPT 21 POLICE 101 -21- 4440 -0000 MISC SERVICES /CONTINGENCY 3,616 SUPPLIES 2,500 2,855 3,000 2,645 101 -21- 4221 -0000 MAINTENANCE OF EQUIPMENT 0 0 0 1,429 0 0■ 0 0 N/A 101 -21- 4245 -0000 GENERAL SUPPLIES 3,601 1,328 0 0 0 0 0 0 N/A 745,004 Total Supplies 3,601 1,328 0 1,429 0 0 0 0 N/A 101 -21- 4360 -0000 INSURANCE 0 500 0 0 0 0 0 0 N/A 101 -21- 4400 -0000 CONTRACTUAL SERVICES 1,105,804 1,179,658 1,234,633 1,236,287 1,265,693 742,359 1,292,606 26,913 2.1% 101 -21- 4440 -0000 MISC SERVICES /CONTINGENCY 3,616 2,727 2,500 2,855 3,000 2,645 3,000 0 0.0% Total Other Services and Charges 1,109,419 1,182,885 1,237,133 1,239,142 1,268,693 745,004 1,295,606 26,913 2.1 CAPITAL OUTLAY 101 -21- 4620 -0000 BUILDINGS & STRUCTURES 214,332 213,807 212,797 212,797 213,256 159,942 211,895 (1,361) -0.6% Total Police 1,327,352 1,398,020 1,449,930 1,453,368 1,481,949 904,946 1,507,501 25,552 1.7% 22 General Fund 2020 Budget Expenditures by Line Item CAPITAL OUTLAY 101 -22- 4620 -0000 BUILDINGS & STRUCTURES 270,620 256,648 271,955 271,955 272,330 204,248 116L 273,380 1,050 0.4% Total Fire 639,088 629,587 625,953 651,925 651,969 509,098 693,325 41,356 6.3% 23 YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 DEPT 22 FIRE OTHER SERVICES AND CHARGES 101 -22- 4400 -0000 CONTRACTUAL SERVICES - EXCELSIOR 344,714 347,976 353,998 353,998 379,639 284,729 394,916 15,277 4.0% 101 -22- 4400 -0000 CONTRACTUAL SERVICES -MOUND 23,754 24,963 0 25,972 0 20,121 25,029 25,029 N/A Total Other Services and Charges 368,468 372,939 353,998 379,970 379,639 304,850 419,945 40,306 10.6% CAPITAL OUTLAY 101 -22- 4620 -0000 BUILDINGS & STRUCTURES 270,620 256,648 271,955 271,955 272,330 204,248 116L 273,380 1,050 0.4% Total Fire 639,088 629,587 625,953 651,925 651,969 509,098 693,325 41,356 6.3% 23 General Fund 2020 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 DEPT 24 PROTECTIVE INSPECTIONS 101 -24- 4101 -0000 FULL -TIME REGULAR 106,568 111,145 98,015 146,608 88,985 101,750 97,616 8,631 9.7% 101 -24- 4102 -0000 OVERTIME 0 0 0 0 0 0 0 0 N/A 101 -24- 4103 -0000 PART -TINE 0 0 0 0 0 0 0 0 N/A 101 -24- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 101 -24- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 101 -24- 4121 -0000 PERA CONTRIB - CITY SHARE 8,109 8,293 7,351 10,758 6,674 4,994 1 7,321 647 9.7% 101 -24- 4122 -0000 FICA CONTRIB - CITY SHARE 6,936 7,159 7,498 9,928 6,807 7,467 7,468 661 9.7% 101 -24- 4131 -0000 EMPLOYEE INSURANCE - CITY 12,000 12,360 14,365 16,416 15,654 11,792 14,523 (1,131) -7.2% 101 -24- 4141 -0000 UNEMPLOYMENT CONDENSATION 0 0 0 0 0 0 0 0 N/A 101 -24- 4151 -0000 WORKERS CONDENSATION 898 1,166 584 1,556 463 425 508 45 9.7% 22,225 Total Personal Services 134,511 140,123 127,813 185,266 118,583 126,428 127,436 8,853 7.5% ANNUMM 101 -24- 4200 -0000 OFFICE SUPPLIES 245 0 0 16 0 280 0 0 N/A 101 -24- 4245 -0000 GENERAL SUPPLIES 0 0 0 0 0 0 0 0 N/A Total Supplies 245 0 0 16 0 280 0 0 N/A OTHER SERVICES AND CHARGES 101 -24- 4303 -0000 ENGINEERING FEES 0 0 0 52 0 143 0 0 N/A 101 -24- 4304 -0000 LEGAL FEES 389 0 0 0 0 273 0 0 N/A 101 -24- 4321 -0000 CONARTNICATIONS - VOICE/DATA 0 0 0 0 0 0 0 0 N/A 101 -24- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 3,544 2,663 3,800 3,698 3,800 1,791 3,500 (300) -7.9% 101 -24- 4351 -0000 PRINTING AND PUBLISHING 146 330 500 120 500 144 500 0 0.0% 101 -24- 4400 -0000 CONTRACTUAL SERVICES 3,290 22,225 12,000 27,580 15,000 12,965 22,000 7,000 46.7% 101 -24- 4433 -0000 DUES AND SUBSCRIPTIONS 135 135 150 0 150 135 150 0 0.0% Total Other Services and Charges 7,503 25,353 16,450 31,450 19,450 15,451 26,150 6,700 34.4% Total Protective Inspections 142,259 165,476 144,263 216,732 138,033 142,159 153,586 15,553 11.3% DEPENDING ON THE CITY ENTERING INTO A CONTRACT WITH EXCELSIOR TO PROVIDE BUILDING INSPECTION SERVICES, FULL TINE LINE COULD GO UP, LINE 4400 WOULD DECREASE, AND A NEW REVENUE LINE WOULD BE NEEDED TOTAL PUBLIC SAFETY 2,108,700 2,193,083 2,220,146 2,322,025 2,271,951 1,556,203 2,354,412 82,461 3.6% 24 General Fund 2020 Budget Expenditures by Line Item 25 YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 DEPT 31 CITY ENGINEER OTHER SERVICES AND CHARGES 101 -31- 4303 -0000 ENGINEERING FEES 52,161 34,548 40,000 34,387 40,000 29,704 40,000 0 0.0% 101 -31- 4321 -0000 CONINIONICATIONS - VOICE/DATA 0 0 0 0 0 0 0 0 N/A 101 -31- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 0 0 0 15 0 0 0 0 N/A 101 -31- 4351 -0000 PRINTING AND PUBLISHING 0 0 0 145 0 0 0 0 N/A 101 -31- 4400 -0000 CONTRACTUAL SERVICES 48,400 48,358 49,500 48,510 49,500 20,000 49,500 0 0.0% 101 -31- 4410 -0000 RENTALS 0 0 0 0 0 0 0 0 N/A 101 -31- 4433 -0000 DUES AND SUBSCRIPTIONS 0 408 0 0 0 0 750 750 N/A Total Other Services and Charges 100,561 83,314 89,500 83,057 89,500 49,704 90,250 750 0.8 Total City Engineer 100,561 83,314 89,500 83,057 89,500 49,704 90,250 750 0.8 25 General Fund 2020 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 DEPT 32 PUBLIC WORKS 101 -32- 4101 -0000 FULL -TIME REGULAR 233,844 246,711 438,584 324,056 374,007 169,954 423,139 49,132 13.1% 101 -32- 4102 -0000 OVERTIME 2,580 5,314 2,500 4,678 2,500 3,545 3,000 500 20.0% 101 -32- 4103 -0000 PART -TIME 0 0 0 3,787 0 0 0 0 N/A 101 -32- 4104 -0000 TEMPORARY REGULAR 0 0 0 0 0 0 0 0 N/A 101 -32- 4105 -0000 STREET PAGER PAY 8,936 7,340 9,000 6,526 9,000 4,663 9,000 0 0.0% 101 -32- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 101 -32- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 101 -32- 4121 -0000 PERA CONTRIB - CITY SHARE 18,672 19,416 33,082 23,258 28,913 11,529 32,635 3,723 12.9% 101 -32- 4122 -0000 FICACONTRIB - CITYSHARE 18,332 19,122 33,743 24,171 29,492 13,106 33,270 3,778 12.8% 101 -32- 4131 -0000 EMPLOYEE INSURANCE - CITY 45,260 47,188 80,240 60,691 63,828 36,424 71,896 8,068 12.6% 101 -32- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 100 0 0 N/A 101 -32- 4151 -0000 WORKERS COMPENSATION 15,263 21,059 25,848 27,102 32,207 11,262 36,591 4,384 13.6% 0 0 0 Total Personal Services 342,887 366,150 622,997 474,269 539,946 250,583 609,531 69,585 12.9% SUPPLIES 101 -32- 4200 -0000 OFFICE SUPPLIES 235 26 400 199 400 0 400 0 0.0% 101 -32- 4208 -0000 POSTAGE 0 94 0 40 0 0 0 0 N/A 101 -32- 4212 -0000 MOTOR FUELS & LUBRICANTS 23,109 22,109 40,000 40,424 40,000 21,474 40,000 0 0.0% 101 -32- 4221 -0000 MAINTENANCE OF EQUIPMENT 35,206 12,035 20,000 46,580 25,000 8,918 25,000 0 0.0% 101 -32- 4223 -0000 MAINTENANCE OF BUILDINGS 1,108 2,280 3,500 3,249 4,000 1,085 10,000 r.0,000 6,000 150.0% 101 -32- 4240 -0000 NII SMALL TOOLS/NOREQUIPMENT 116 1,821 1,600 1,296 1,900 538 1,900 0 0.0% 101 -32- 4245 -0000 GENERAL SUPPLIES 15,314 11,584 16,000 14,382 16,000 7,227 16,000 0 0.0% 101 -32- 4250 -0000 ROAD MAINT MATERIALS 68,047 44,614 75,000 80,645 75,000 39,008 5,000 6.7% Total Supplies 143,135 94,563 156,500 186,815 162,300 78,250 173,300 11,000 6.8% OTHER SERVICES AND CHARGES 101 -32- 4303 -0000 ENGINEERING FEES 0 2,695 0 0 0 143 0 0 N/A 101 -32- 4305 -0000 DRUG TESTING 152 780 2,350 901 2,000 568 2,000 0 0.0% 101 -32- 4321 -0000 COMMUNICATIONS - VOICE/DATA 2,899 4,987 3,350 5,307 3,350 1,638 5,000 1,650 49.3% 101 -32- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 2,256 8,382 6,500 4,010 6,500 688 7,500 1,000 15.4% 101 -32- 4351 -0000 PRINTING AND PUBLISHING 0 0 0 0 0 0 0 0 N/A 101 -32- 4380 -0000 UTILITY SERVICES 8,991 7,984 14,000 10,234 13,000 5,386 13,000 0 0.0% 101 -32- 4399 -0000 UTILITIES - STREET LIGHTS 38,340 43,714 42,000 42,144 40,000 16,826 42,000 2,000 5.0% 101 -32- 4400 -0000 CONTRACTUAL SERVICES 78,652 72,010 165,000 63,520 140,000 30,645 140,000 0 0.0% 101 -32- 4410 -0000 RENTALS 400 327 1,500 1,280 1,600 2,218 1,600 0 0.0% 101 -32- 4433 -0000 DUES AND SUBSCRIPTIONS 1,578 2,083 1,700 623 1,700 1,500 1,700 0 0.0% 101 -32- 4437 -0000 TAXES/LICENSES 975 878 900 1,175 900 564 1,000 100 11.1% 101 -32- 4440 -0000 MISC SERVICES /CONTINGENCY 22 0 3,000 815 0 0 0 0 N/A Total Other Services and Charges 134,265 143,840 240,300 130,009 209,050 60,176 213,800 4,750 2.3 Total Public Works 620,286 604,553 1,019,797 791,093 911,296 389,009 996,631 85,335 9.4% 26 General Fund 2020 Budget Expenditures by Line Item Account Number Description Actual 2016 Actual 2017 Budget 2018 Actual 2018 Budget 2019 YTD 07/19/19 2019 Preliminary Budget 2020 Budget Change 2020 Percentage Change 2020 DEPT 33 ICE AND SNOW REMOVAL PERSONAL SERVICES 101 -33- 4101 -0000 FULL -TIME REGULAR 18,208 17,958 46,439 55,655 34,499 41,163 37,172 2,673 7.7% 101 -33- 4102 -0000 OVERTIME 4,914 1,707 7,500 12,595 7,500 4,106 7,500 0 0.0% 101 -33- 4103 -0000 PART -TIME 0 0 0 5,184 0 568 0 0 N/A 101 -33- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 101 -33- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 101 -33- 4121 -0000 PERA CONTRIB - CITY SHARE 1,950 1,475 4,046 4,555 3,150 3,072 3,351 201 6.4% 101 -33- 4122 -0000 FICACONTRIB - CITYSHARE 1,615 1,188 4,127 4,558 3,213 3,052 3,418 205 6.4% 101 -33- 4131 -0000 EMPLOYEE INSURANCE - CITY 0 0 9,204 3,502 6,542 3,825 6,953 411 6.3% 101 -33- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 101 -33- 4151 -0000 WORKERS COMPENSATION 1,234 1,204 2,616 4,728 2,476 2,889 2,669 193 7.8% Total Personal Services 27,920 23,532 73,931 90,777 57,379 58,675 61,062 3,683 6.4% SUPPLIES 101 -33- 4245 -0000 GENERAL SUPPLIES 23,008 38,954 40,000 49,334 44,000 33,767 2,000 8,000 18.2% OTHER SERVICES AND CHARGES 101 -33- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 0 0 0 0 0 0 0 N/A Total Ice and Snow Removal 50,928 62,486 113,931 140,111 101,379 92,442 113,062 11,683 11.5% TOTAL STREETS 771,775 750,353 1,223,228 1,014,261 1,102,176 531,155 1,199,943 97,768 8.9% 27 General Fund 2020 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 DEPT 52 PARK MAINTENANCE 101 -52- 4101 -0000 FULL -TIME REGULAR 104,960 112,960 79,599 84,392 103,405 41,931 110,509 7,104 6.9% 101 -52- 4102 -0000 OVERTIME 0 0 2,500 45 2,500 0 2,500 0 0.0% 101 -52- 4103 -0000 PART -TIME 6,199 0 12,000 10,813 12,000 858 12,000 0 0.0% 101 -52- 4104 -0000 TEMPORARY REGULAR 0 0 0 0 0 0 0 0 N/A 101 -52- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 101 -52- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 101 -52- 4121 -0000 PERA CONTRIB - CITY SHARE 8,324 8,472 6,158 8,047 7,943 2,942 8,476 533 6.7% 101 -52- 4122 -0000 FICACONTRIB - CITYSHARE 8,449 9,154 7,198 8,718 9,019 3,334 9,563 544 6.0% 101 -52- 4131 -0000 EMPLOYEE INSURANCE - CITY 21,601 27,308 16,200 24,593 18,025 11,084 20,039 2,014 11.2% 101 -52- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 101 -52- 4151 -0000 WORKERS COMPENSATION 6,023 8,555 4,777 8,759 5,724 2,617 6,102 378 6.6% COMMUNICATIONS - VOICE/DATA 1,959 1,800 2,000 2,119 1,000 1,382 1,500 500 50.0% Total Personal Services 155.556 166.449 128.432 145367 158.616 61766 169.189 10.573 6.7% SUPPLIES 101 -52- 4208 -0000 POSTAGE 19 0 0 0 0 0 0 0 N/A 101 -52- 4221 -0000 MAINTENANCE OF EQUIPMENT 18,971 844 6,000 0 6,000 0 6,000 0 0.0% 101 -52- 4223 -0000 MAINTENANCE OF BUILDINGS 3,457 1,981 7,000 76 7,000 255 7,000 0 0.0% 101 -52- 4240 -0000 SMALL TOOLS/NIINOREQUIPMENT 130 711 1,000 605 1,000 0 1,100 100 10.0% 101 -52- 4245 -0000 GENERAL SUPPLIES 8,783 17,879 9,500 4,442 9,500 2,220 9,500 0 0.0% 101 -52- 4247 -0000 TREES PURCHASED 2,275 2,693 0 5,156 600 0 600 0 0.0% Total Supplies 33,635 24,108 23,500 10,279 24,100 2,475 24,200 100 0.4% OTHER SERVICES AND CHARGES 101 -52- 4302 -0000 CONSULTING FEES 12,446 0 0 0 0 0 0 0 N/A 101 -52- 4303 -0000 ENGINEERING FEES 0 0 5,000 0 9,000 0 5,000 (4,000) -44.4% 101 -52- 4304 -0000 LEGAL FEES 0 0 0 2,869 0 0 0 0 N/A 101 -52- 4321 -0000 COMMUNICATIONS - VOICE/DATA 1,959 1,800 2,000 2,119 1,000 1,382 1,500 500 50.0% 101 -52- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 0 795 2,000 85 2,200 0 2,200 0 0.0% 101 -52- 4351 -0000 PRINTING AND PUBLISHING 137 0 0 490 0 323 400 400 N/A 101 -52- 4380 -0000 UTILITY SERVICES 8,288 9,456 10,000 9,160 8,000 4,734 9,000 1,000 12.5% 101 -52- 4400 -0000 CONTRACTUAL SERVICES 11,831 16,074 12,000 37,655 47,000 5,191 32,000 (15,000) -31.9% 101 -52- 4401 -0000 LAKE MINNETONKA TREATMENT 0 0 5,000 0 5,000 0 5,000 0 0.0% 101 -52- 4402 -0000 CHRISTMAS LAKE AIS INSPECTIONS 0 0 0 5,000 5,000 0 5,000 0 0.0% 101 -52- 4410 -0000 RENTALS 8,259 8,480 9,000 7,961 5,000 4,907 5,000 0 0.0% 101 -52- 4433 -0000 DUES AND SUBSCRIPTIONS 0 225 0 595 400 0 400 0 0.0% 101 -52- 4440 -0000 MISC SERVICES /CONTINGENCY 0 314 0 0 0 0 0 0 N/A Total Other Services and Charges 42,920 37,144 45,000 65,934 82,600 16,537 65,500 (17,100) -20.7% Total Park Maintenance 232,111 227,701 196,932 221,580 265,316 81,778 258,889 (6,427) -2.4% 28 General Fund 2020 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/19/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 DEPT 53 RECREATION 101 -53- 4101 -0000 FULL -TIME REGULAR 25,137 27,002 25,251 29,262 27,373 15,195 29,195 1,822 6.7% 101 -53- 4102 -0000 OVERTIME 623 308 0 135 300 0 300 0 0.0% 101 -53- 4103 -0000 PART -TIME 6,595 3,899 13,000 644 6,500 5,450 7,500 1,000 15.4% 101 -53- 4121 -0000 PERA CONTRIB - CITY SHARE 1,935 2,033 1,894 2,195 2,076 1,139 2,213 137 6.6% 101 -53- 4122 -0000 FICA CONTRIB - CITY SHARE 2,447 2,348 2,927 2,262 2,614 1,570 2,830 216 8.2% 101 -53- 4131 -0000 EMPLOYEE INSURANCE - CITY 511 535 1,015 545 2,025 305 1,043 (982) -48.5% 101 -53- 4151 -0000 WORKERS COMPENSATION 958 1,273 202 1,713 728 664 777 49 6.7% 0 Total Personal Services 38.206 37398 44.289 36.756 4L616 24323 41857 1242 5.4% SUPPLIES 101 -53- 4245 -0000 101 -53- 4246 -0000 101 -53- 4248 -0000 OTHER SERVIC 101 -53- 4321 -0000 101 -53- 4331 -0000 101 -53- 4351 -0000 101 -53- 4400 -0000 101 -53- 4433 -0000 101 -53- 4437 -0000 101 -53- 4438 -0000 101 -53- 4441 -0000 101 -53- 4442 -0000 101 -53- 4450 -0000 GENERAL SUPPLIES PROGRAM SUPPLIES OTHER PROGRAMS FEE Total Supplies -S AND CHARGES COMMUNICATIONS - VOICE/DATA TRAVEL, CONFERENCE &SCHOOL PRINTING AND PUBLISHING CONTRACTUAL SERVICES DUES AND SUBSCRIPTIONS TAXES/LICENSES OKTOBERFEST ARCTIC FEVER PROGRAMS SNOW PRINCESS TEA PARTY BANK SERVICE CHARGES Total Other Services and Charges Total Recreation TOTAL PARKS AND RECREATION TOTAL EXPENDITURES 704 500 700 753 700 600 700 0 0.0% 403 869 7,000 794 3,000 0 3,000 0 0.0% 2,575 2,580 0 4,728 4,000 2,305 4,000 0 0.0% 1,859 1,463 6,500 539 5,000 0 5,000 0 0.0% 3,681 3,949 7,700 6,275 7,700 2,905 7,700 0 0.0% 0 0 0 0 0 0 0 0 N/A 0 0 100 21 100 0 200 100 100.0% 382 450 0 1,650 1,500 1,064 1,500 0 0.0% 1,859 1,463 6,500 539 5,000 0 5,000 0 0.0% 190 209 200 225 200 0 300 100 50.0% (26) (7) 0 0 0 0 0 0 N/A 1,527 1,386 0 1,802 0 0 0 0 N/A 5,342 6,461 7,000 5,685 7,100 4,285 7,100 0 0.0% 294 0 0 0 0 0 0 0 N/A 0 0 100 0 0 0 0 0 N/A 9,568 9,962 13,900 9,922 13,900 5,349 14,100 200 1.4% 51,456 51,309 65,889 52,953 63,216 32,577 65,657 2,442 3.9% 283,567 279,010 262,820 274,533 328,531 114,355 324,546 (3,986) -1.2% 4,577,368 4,715,466 5,069,737 4,971,950 5,133,643 2,959,538 5,407,854 274,211 5.3% 29 General Fund 2020 Budget Expenditures by Line Item Account Number Description Actual 2016 Actual 2017 Budget 2018 Actual 2018 Budget 2019 YTD 07/19/19 2019 Preliminary Budget 2020 Budget Change 2020 Percentage Change 2020 OTHER FINANCING USES TRANSFERS OUT 101 -00- 4820 -0000 SOUTHSHORE CENTER - BUILDING 311,000 0 38,000 56,850 32,300 49,800 32,300 0 0.0% 101 -11- 4820 -0000 SOUTHSHORE CENTER- OPERATIONS 70,000 95,000 70,000 70,000 70,000 70,000 70,000 0 0.0% 101 -19- 4820 -0000 CITY HALL DEBT SERVICE 104,313 102,913 93,895 93,895 92,005 92,005 95,115 3,110 3.4% 101 -32- 4820 -0000 EQUIPMENT REPLACEMENT 105,000 120,000 135,000 135,000 140,000 172,500 95,000 (45,000) -32.1% 101 -32- 4820 -0000 STREET IMPROVEMENTS 755,000 1,245,000 785,000 785,000 810,000 810,000 835,000 25,000 3.1% 101 -53- 4820 -0000 PARK IMPROVEMENTS 42,000 242,000 42,000 42,000 42,000 222,000 95,000 53,000 126.2% 101 -00- 4820 -0000 STORM WATER -MANOR PARK POND 0 0 0 0 0 230,000 0 0 N/A Total Transfers Out 1,387,313 1,804,913 1,163,895 1,182,745 1,186,305 1,646,305 1,222,415 36,110 3.0% TOTAL EXPENDITURES AND OTHER FINANCING USES 5,964,681 6,520,379 6,233,632 6,154,695 6,319,948 4,605,843 6,630,269 310,321 4.9% 30 Shorewood Community & Event Center 2020 Budget YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 08/07/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 FUND 201 Shorewood Community & Event Center REVENUE 201 -00- 3410 -0000 RENTAL INCOME 201 -00- 3471 -0000 PARK FEES & RENTALS 201 -00- 3473 -0000 EVENT PROGRAM FEES 201 -00- 3477 -0000 METRO DINING CARDS 201 -00- 3480 -0000 PROGRAM (CLASS) FEES 201 -00- 3620 -0000 INTEREST EARNINGS 201 -00- 3623 -0000 CONTRIBUTIONS AND DONATION 201 -00- 3670 -0000 MISCELLANEOUS REVENUE 201 -00- 3920 -0000 TRANSFERS IN REVENUE Totals EXPENDITURES PERSONAL SERVICES 201 -00- 4101 -0000 FULL -TIME REGULAR 201 -00- 4102 -0000 OVERTIME 201 -00- 4103 -0000 PART -TIME 201 -00- 4121 -0000 PERA CONTRIB - CITY SHARE 201 -00- 4122 -0000 FICA CONTRIB - CITY SHARE 201 -00- 4131 -0000 EMPLOYEE INSURANCE - CITY 201 -00- 4151 -0000 WORKERS COMPENSATION Total Personal Services SUPPLIES 42,546 46,565 44,000 55,989 44,000 27,843 55,000 11,000 25.0% 0 0 0 0 0 0 0 0 N/A 889 665 0 607 500 25 500 0 0.0% 506 2,500 0 2,304 1,500 2,500 1,700 200 13.3% 2,339 2,481 5,000 1,658 1,500 (87) 1,500 0 0.0% 809 2,097 250 1,319 250 0 0 (250) - 100.0% 426 225 0 415 0 0 0 0 N/A 474 0 1,000 260 500 15 500 0 0.0% 381,000 95,000 108,000 108,000 102,300 119,800 6- 102,300 0 0.0% 15,000 13,440 15,900 900 6.0% 0 0.0% 428,989 149,533 158,250 170,552 150,550 150,096 161,500 10,950 7.3% 17,777 20,239 18,938 25,895 20,530 21,430 21,896 1,366 6.7% 4,500 2,341 4,000 2,857 4,000 1,546 41000 0 0.0% 9,318 9,332 10,000 9,156 10,000 5,439 11,000 1,000 10.0% 1,371 1,525 1,420 1,848 1,840 1,607 1,942 102 5.5% 2,055 2,214 2,214 2,535 2,642 2,018 2,823 181 6.8% 0 0 761 204 1,518 264 782 (736) -48.5% 35,790 36,948 37,485 44,480 41,076 33,429 43,025 1,949 4.7% 201 -00- 4200 -0000 OFFICE SUPPLIES 0 0 0 0 0 323 400 400 N/A 201 -00- 4223 -0000 MAINTENANCE OF BUILDINGS 1,595 45,523 3,000 2,378 3,000 5,430 3,000 0 0.0% 201 -00- 4245 -0000 GENERAL SUPPLIES 2,928 3,338 2,500 3,427 2,500 3,836 3,000 500 20.0% 201 -00- 4246 -0000 EVENT SUPPLIES EXPENSE 38 175 500 0 500 617 500 0 0.0% 201 -00- 4247 -0000 COMMUNITY EVENT EXPENSE 0 2,000 0 2,000 0 0 0 0 N/A 201 -00- 4248 -0000 PROGRAM (CLASS) EXPENSES 8,457 8,806 5,000 10,709 9,000 3,234 9,000 0 0.0% 201 -00- 4380 -0000 UTILITY SERVICES 11,083 11,432 11,000 11,451 11,000 5,958 11,500 500 Total Supplies 13,019 59,842 11,000 18,514 15,000 13,440 15,900 900 6.0% OTHER SERVICES AND CHARGES 201 -00- 4302 -0000 CONSULTING FEES 0 810 0 0 0 0 0 0 N/A 201 -00- 4304 -0000 LEGAL FEES 24,277 1,092 0 0 0 0 0 0 N/A 201 -00- 4321 -0000 COMMUNICATIONS - VOICE/DATA 1,293 1,399 3,000 1,426 2,000 3,362 5,000 3,000 150.0% 201 -00- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 14 12 0 182 200 24 200 0 0.0% 201 -00- 4351 -0000 PRINTING AND PUBLISHING 2,695 3,682 3,000 3,568 3,000 768 3,500 500 16.7% 201 -00- 4360 -0000 INSURANCE 0 0 1,000 0 500 0 0 (500) - 100.0% 201 -00- 4380 -0000 UTILITY SERVICES 11,083 11,432 11,000 11,451 11,000 5,958 11,500 500 4.5% 201 -00 -4400 -0000 CONTRACTUAL SERVICES 12,902 13,633 15,000 17,858 15,000 9,697 15,000 0 0.0% 31 Shorewood Community & Event Center 2020 Budget Account Number Description Actual 2016 Actual 2017 Budget 2018 Actual 2018 Budget 2019 YTD 08/07/19 2019 Preliminary Budget 2020 Budget Change 2020 Percentage Change 2020 201 -00 -4433 -0000 DUES AND SUBSCRIPTIONS 0 283 0 361 500 521 500 0 0.0% 201 -00 -4437 -0000 TAXES/LICENSES 767 867 1,200 791 1,200 823 1,200 0 0.0% 201 -00 -4440 -0000 MISC SERVICES 0 0 1,000 0 1,000 0 1,000 0 0.0% 201 -00 -4441 -0000 ARCTIC FEVER PROGRAMS 0 0 0 0 0 0 0 0 N/A Total Other Services and Charges 53,030 33,210 35,200 35,637 34,400 21,153 37,900 3,500 10.2% CAPITAL OUTLAY 201 -00- 4620 -0000 BUILDINGS & STRUCTURES 311,000 0 158,250 145,822 31,000 13,087 (4,750) -15.3% 201 -00- 4680 -0000 OTHER IMPROVEMENTS 0 0 0 0 0 6,024 0 N/A Total Capital Outlay 311,000 0 158,250 145,822 31,000 19,111 26,250 (4,750) -15.3% EXPENDITURES TOTAL 412,838 130,000 241,935 244,453 121,476 87,133 123,075 1,599 1.3% CHANGE IN FUND BALANCE 16,151 19,533 (83,685) (73,901) 29,074 62,963 38,426 9,352 32.2% 32 Water Fund 2020 Budget REVENUE Totals: 727,129 717,732 474,750 2,035,377 544,894 273,285 582,858 37,964 7.0% EXPENSE PERSONAL SERVICES YTD Preliminary Budget Percentage FULL -TIME REGULAR 149,803 Actual Actual Budget Actual Budget 07/30/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 PART -TIME 0 0 0 0 0 0 0 0 N/A 601 -00- 4104 -0000 FUND 601 Water Utility 0 0 0 0 0 0 0 N/A 601 -00- 4105 -0000 REVENUE 5,532 5,548 5,500 5,769 5,500 3,739 6,000 500 9.1% 601 -00- 4106 -0000 601 -00- 3353 -0000 PERA PENSION OTHER REVENUE 749 51 0 744 0 0 0 0 N/A 601 -00- 3362 -0000 MISC GRANTS 0 8,087 0 0 0 0 0 0 N/A 601 -00- 3610 -0000 SPECIAL ASSESSMENTS - CURREN' 8,490 7,253 5,000 6,462 0 18,762 0 0 N/A 601 -00- 3611 -0000 SPECIAL ASSESSMENTS- DELINQUE 1,012 0 0 0 0 0 0 0 N/A 601 -00- 3614 -0000 SPECIAL ASSESSMENTS- INTEREST 0 0 0 0 0 0 0 0 N/A 601 -00- 3620 -0000 INTEREST EARNINGS 25,818 6,963 25,000 16,566 5,000 0 0 (5,000) - 100.0% 601 -00- 3620 -0000 INTEREST EARNINGS 0 0 0 15,494 12,516 41,447 9,480 (3,036) -24.3% 601 -00- 3620 -0000 INTEREST EARNINGS 0 0 0 0 69,778 0 69,778 0 0.0% 601 -00- 3621 -0000 GAIN / (LOSS) ON INVESTMENTS 0 0 0 0 0 0 0 0 N/A 601 -00- 3624 -0000 REFUNDS & REIMBURSEMENTS 2,127 0 0 0 0 1,546 0 0 N/A 601 -00- 3670 -0000 MISCELLANEOUS REVENUE 0 0 0 0 0 0 0 0 N/A 601 -00- 3710 -0000 UTILITY REVENUE 404,156 405,198 417,150 435,218 430,000 167,528 467,500 37,500 8.7% 601 -00- 3711 -0000 WATER CONNECTION FEES 278,972 285,513 25,000 96,055 25,000 1,477 25,000 0 0.0% 601 -00- 3712 -0000 UTILITY PERMIT FEES 750 810 500 4,630 500 3,240 1,000 500 100.0% 601 -00- 3713 -0000 WATER METER SALES 4,755 3,677 2,000 18,140 2,000 39,345 10,000 8,000 400.0% 601 -00- 3715 -0000 STATE SURCHARGE 0 0 0 0 0 0 0 0 N/A 601 -00- 3717 -0000 Water Meter Permit 300 180 100 (60) 100 (60) 100 0 0.0% 601 -00- 3720 -0000 WATER PENALTIES 0 0 0 0 0 0 0 0 N/A 601 -00- 3725 -0000 LOCAL SAC CHARGES 0 0 0 0 0 0 0 0 N/A 601 -00- 3900 -0000 CAPITAL CONTRIBUTIONS 0 0 0 1,442,128 0 0 0 0 N/A 601 -00- 3910 -0000 SALES OF CAPITAL ASSETS 0 0 0 0 0 0 0 0 N/A 601 -00- 3920 -0000 TRANSFERS IN 0 0 0 0 0 0 0 0 N/A REVENUE Totals: 727,129 717,732 474,750 2,035,377 544,894 273,285 582,858 37,964 7.0% EXPENSE PERSONAL SERVICES 601 -00- 4101 -0000 FULL -TIME REGULAR 149,803 132,331 77,620 118,115 126,721 74,256 153,342 26,621 21.0% 601 -00- 4102 -0000 OVERTIME 4,205 6,195 5,000 5,013 5,000 1,930 5,000 0 0.0% 601 -00- 4103 -0000 PART -TIME 0 0 0 0 0 0 0 0 N/A 601 -00- 4104 -0000 TEMPORARY REGULAR 0 0 0 0 0 0 0 0 N/A 601 -00- 4105 -0000 WATER PAGER PAY 5,532 5,548 5,500 5,769 5,500 3,739 6,000 500 9.1% 601 -00- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 601 -00- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 601 -00- 4121 -0000 PERA CONTRIB - CITY SHARE 11,518 10,752 5,821 9,440 9,504 5,972 j 12,326 2,822 29.7% 601 -00- 4122 -0000 FICA CONTRIB - CITY SHARE 11,427 9,902 5,938 9,057 9,694 5,771 12,573 2,879 29.7% 601 -00- 4131 -0000 EMPLOYEE INSURANCE - CITY 21,166 14,898 13,640 12,939 23,206 13,909 26,253 3,047 13.1% 601 -00- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 601 -00- 4151 -0000 WORKERS COMPENSATION 4,679 6,464 3,521 5,653 6,104 2,527 8,042 1,938 31.7% 601 -00- 4161 -0000 PENSIONEXPENSE 23,128 (7,587) 24,000 (37,926) 0 0 0 0 N/A Total Personal Services 231,457 178,503 141,040 128,060 185,729 108,104 223,536 37,807 20.4% SUPPLIES 33 Water Fund 2020 Budget YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/30/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 601 -00- 4200 -0000 OFFICE SUPPLIES 152 902 200 157 200 149 200 0 0.0% 601 -00- 4208 -0000 POSTAGE 1,417 1,443 1,400 1,358 1,400 689 1,400 0 0.0% 601 -00- 4212 -0000 MOTOR FUELS & LUBRICANTS 0 0 0 0 0 0 0 0 N/A 601 -00- 4215 -0000 SHOP MATERIALS 0 0 0 0 0 0 0 0 N/A 601 -00- 4221 -0000 MAINTENANCE OF EQUIPMENT 19,635 2,771 26,000 2,184 20,000 51 20,000 0 0.0% 601 -00- 4223 -0000 MAINTENANCE OF BUILDINGS 107 4,397 60,000 2,575 20,000 163 20,000 0 0.0% 601 -00- 4240 -0000 SMALL TOOLS/MINOR EQUIPMENT 243 229 800 619 800 36 800 0 0.0% 601 -00- 4245 -0000 GENERAL SUPPLIES 8,376 11,804 11,000 8,747 11,000 3,001 11,000 0 0.0% 601 -00- 4260 -0000 WATER PURCHASES - TONKA BAY 2,585 3,516 3,500 3,653 3,500 2,327 3,500 0 0.0% 601 -00- 4261 -0000 WATER PURCHASES EXCELSIOR 17,169 16,088 18,000 18,324 18,000 7,406 18,000 0 0.0% 601 -00- 4262 -0000 WATER PURCHASES - MINNETONK 1,059 755 1,500 786 1,200 389 1,200 0 0.0% 601 -00- 4263 -0000 WATER PURCHASES- CHANHASSEI\ 8,282 11,064 10,000 9,559 11,000 3,504 11,000 0 0.0% 601 -00- 4265 -0000 WATER METER PURCHASES 11,385 18,396 13,000 25,952 15,000 52,075 , 20,000 5,000 33.3% Total Other Services and Charges 455,753 485,392 521,700 526,252 532,850 218,219 659,600 126,750 23.8% NON - OPERATING EXPENSES 34 Total Supplies 70,411 71,365 145,400 73,914 102,100 69,790 107,100 5,000 4.9% OTHER SERVICES AND CHARGES 601 -00- 4301 -0000 AUDITING & ACCOUNTING 0 0 2,500 0 0 0 0 0 N/A 601 -00- 4302 -0000 CONSULTING FEES 0 0 0 0 0 0 0 0 N/A 601 -00- 4303 -0000 ENGINEERING FEES 15,454 15,614 20,000 3,202 20,000 0 20,000 0 0.0% 601 -00- 4304 -0000 LEGAL FEES 0 1,943 0 37 0 0 0 0 N/A 601 -00- 4312 -0000 ENGINEERING 0 0 0 0 0 0 0 0 N/A 601 -00- 4321 -0000 COMMUNICATIONS - VOICE/DATA 1,268 1,369 4,000 2,681 4,000 1,562 41000 0 0.0% 601 -00- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 700 1,300 1,400 594 1,600 0 1,600 0 0.0% 601 -00- 4351 -0000 PRINTING AND PUBLISHING 901 0 1,100 0 500 0 500 0 0.0% 601 -00- 4360 -0000 INSURANCE 0 2,500 8,000 0 8,000 0 0 (8,000) - 100.0% 601 -00- 4380 -0000 UTILITY SERVICES 0 (306) 0 0 0 0 0 0 N/A 601 -00- 4394 -0000 UTILITIES - AMESBURY WELL 10,192 13,489 12,000 4,872 12,000 2,203 12,000 0 0.0% 601 -00- 4395 -0000 UTILITIES - BADGER WELL 6,711 5,766 12,500 9,829 12,500 8,944 12,500 0 0.0% 601 -00- 4396 -0000 UTILITIES - BOULDER BRIDGE 19,068 20,509 20,000 18,771 20,000 4,262 20,000 0 0.0% 601 -00- 4397 -0000 UTILITIES - WOODHAVEN WELL 0 0 0 0 0 0 0 0 N/A 601 -00- 4398 -0000 UTILITIES - SE AREA WELL 34,987 18,735 34,000 32,402 30,000 16,361 30,000 0 0.0% 601 -00 -4400 -0000 CONTRACTUAL SERVICES 42,666 65,357 72,000 104,490 70,000 23,587 70,000 0 0.0% 601 -00- 4410 -0000 RENTALS 0 0 0 0 0 0 0 0 N/A 601 -00 -4420 -0000 DEPRECIATION 317,882 322,748 320,000 334,084 330,000 0 350,000 20,000 6.1% 601 -00 -4433 -0000 DUES AND SUBSCRIPTIONS 33 1,233 10,000 1,457 10,000 1,440 4,000 (6,000) -60.0% 601 -00 -4437 -0000 TAXES/LICENSES 2,350 2,244 3,000 1,900 3,000 3,548 4,000 1,000 33.3% 601 -00 -4440 -0000 MISC SERVICES /CONTINGENCY 235 0 200 0 0 0 0 0 N/A 601 -00 -4450 -0000 BANK SERVICE CHARGES 2,004 1,546 1,000 1,077 0 891 1,000 1,000 N/A 601 -00- 4499 -0000 FEMA ELIGLI13LE EXPENSES 0 0 0 0 0 0 0 0 N/A 601 -00- 4620 -0000 BUILDINGS & STRUCTURES 0 6,020 0 0 0 0 0 0 N/A 601 -00- 4640 -0000 MACHINERY & EQUIPMENT 1,000 0 0 0 11,250 39,831 25,000 13,750 122.2% 601 -00- 4680 -0000 OTHER IMPROVEMENTS 300 5,325 0 10,856 0 115,590 105,000 105,000 N/A Total Other Services and Charges 455,753 485,392 521,700 526,252 532,850 218,219 659,600 126,750 23.8% NON - OPERATING EXPENSES 34 Water Fund 2020 Budget YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/30/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 601 -00- 4711 -0000 BOND INTEREST 16,978 15,388 14,375 13,362 12,080 12,080 9,216 (2,864) -23.7% 601 -00- 4720 -0000 FISCAL AGENT FEES 1,205 495 500 2,245 500 495 500 0 0.0% 601 -00- 4810 -0000 RESIDUAL EQUITY TRANSFERS 0 0 0 0 0 0 0 0 N/A 601 -00- 4820 -0000 OPERATING TRANSFERS 12,500 14,866 12,500 12,500 12,500 12,500 12,500 0 0.0% 601 -00- 4820 -0000 TRANSFERS FOR CIP STREETS 0 0 0 864,547 0 0 750,000 750,000 N/A Total Non - Operating Expenses 30,683 30,749 27,375 892,654 25,080 25,075 772,216 747,136 2979.0% Total Expenses 788,304 766,009 835,515 1,620,880 845,759 421,188 1,762,452 916,693 108.4% Change in Net Position (61,175) (48,277) (360,765) 414,497 (300,865) (147,903) (1,179,594) (878,729) 292.1% Depreciation (Non -Cash) 350,000 Bond Principal (275,000) Capital Acquisitions 130,000 shown above Principal Payment Received on 2017 Ladder Truck Lease 154,876 Principal Payments Received on TIF Loan 0 first principal payment 2022 estimated Change in Cash L242_LLa bonding? Change in Cash, Excluding Transfers for CIP Streets (199 71 Rl 35 Sewer Fund 2020 Budget REVENUE Totals: 1,042,616 1,008,482 943,600 1,075,087 981,600 495,469 1,025,400 43,800 4.5% EXPENSE I, DI11f fINIR MM DI 141 W DR 611 -00- 4101 -0000 FULL -TIME REGULAR 135,343 94,085 64,641 85,030 105,648 YTD Preliminary Budget Percentage 611 -00- 4102 -0000 OVERTIME Actual Actual Budget Actual Budget 07/30/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 611 -00- 4104 -0000 TEMPORARY REGULAR 0 0 0 0 0 0 0 0 N/A FUND 611 Sanitary Sewer Utility 5,532 5,397 5,500 5,613 5,500 3,739 6,000 500 9.1% REVENUE OTHER 0 0 0 0 0 0 0 0 N/A 611 -00- 3353 -0000 PERA PENSION OTHER REVENUE 670 37 0 574 0 0 0 0 N/A 611 -00- 3362 -0000 MISC GRANTS 20,206 0 0 0 0 0 0 0 N/A 611 -00- 3400 -0000 CHARGES FOR SERVICES 0 0 0 0 0 0 0 0 N/A 611 -00- 3610 -0000 SPECIAL ASSESSMENTS - CURREN' 19,941 1,775 1,000 198 0 15,943 0 0 N/A 611 -00- 3611 -0000 SPECIAL ASSESSMENTS- DELINQUE 1,081 0 0 0 0 0 0 0 N/A 611 -00- 3614 -0000 SPECIAL ASSESSMENTS- INTEREST 0 0 0 0 0 0 0 0 N/A 611 -00- 3620 -0000 INTEREST EARNINGS 33,936 31,551 25,000 38,777 25,000 0 15,000 (10,000) -40.0% 611 -00- 3621 -0000 GAIN / (LOSS) ON INVESTMENTS 0 0 0 0 0 0 0 0 N/A 611 -00- 3670 -0000 MISCELLANEOUS REVENUE 0 0 0 0 0 0 0 0 N/A 611 -00- 3710 -0000 UTILITY REVENUE 855,527 906,990 910,000 923,705 949,000 469,416 1,002,800 53,800 5.7% 611 -00- 3712 -0000 UTILITY PERMIT FEES 1,400 3,150 2,000 9,245 2,000 5,460 2,000 0 0.0% 611 -00- 3720 -0000 SEWER PENALTIES 0 0 0 0 0 0 0 0 N/A 611 -00- 3725 -0000 LOCAL SAC CHARGES PAYABLE 108,805 63,779 5,000 21,568 5,000 3,600 5,000 0 0.0% 611 -00- 3727 -0000 OUTSIDE SEWER REPAIR 1,050 1,200 600 600 600 1,050 600 0 0.0% 611 -00- 3900 -0000 CAPITAL CONTRIBUTIONS 0 0 0 80,420 0 0 0 0 N/A 611 -00- 3910 -0000 SALES OF CAPITAL ASSETS 0 0 0 0 0 0 0 0 N/A 611 -00- 3920 -0000 TRANSFERS IN 0 0 0 0 0 0 0 0 N/A REVENUE Totals: 1,042,616 1,008,482 943,600 1,075,087 981,600 495,469 1,025,400 43,800 4.5% EXPENSE I, DI11f fINIR MM DI 141 W DR 611 -00- 4101 -0000 FULL -TIME REGULAR 135,343 94,085 64,641 85,030 105,648 60,464 138,158 32,510 30.8% 611 -00- 4102 -0000 OVERTIME 2,580 3,098 2,500 4,781 2,500 1,832 2,500 0 0.0% 611 -00- 4103 -0000 PART -TIME 0 0 0 0 0 0 0 0 N/A 611 -00- 4104 -0000 TEMPORARY REGULAR 0 0 0 0 0 0 0 0 N/A 611 -00- 4105 -0000 SEWER PAGER PAY 5,532 5,397 5,500 5,613 5,500 3,739 6,000 500 9.1% 611 -00- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 611 -00- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 611 -00- 4121 -0000 PERA CONTRIB - CITY SHARE 10,307 7,650 4,848 7,283 7,924 4,931 11,000 3,076 38.8% 611 -00- 4122 -0000 FICA CONTRIB - CITY SHARE 10,411 7,251 4,945 7,006 8,082 4,724 11,219 3,137 38.8% 611 -00- 4131 -0000 EMPLOYEE INSURANCE - CITY 21,166 14,898 11,048 12,422 18,460 11,230 23,194 4,734 25.6% 611 -00- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 611 -00- 4151 -0000 WORKERS COMPENSATION 3,290 4,184 3,047 4,217 4,883 2,066 7,465 2,582 52.9% 611 -00- 4161 -0000 PENSIONEXPENSE 31,737 (33,269) 32,000 (20,597) 0 0 0 0 N/A Total Personal Services 220,366 103,294 128,529 105,755 152,997 88,986 199,536 46,539 30.4% SUPPLIES 611 -00- 4200 -0000 OFFICE SUPPLIES 152 163 200 157 200 149 200 0 0.0% 611 -00- 4208 -0000 POSTAGE 1,386 1,358 1,500 1,358 1,500 689 1,500 0 0.0% 611 -00- 4212 -0000 MOTOR FUELS & LUBRICANTS 0 0 0 0 0 0 0 0 N/A 611 -00- 4215 -0000 SHOP MATERIALS 0 0 0 0 0 0 0 0 N/A 36 Sewer Fund 2020 Budget Account Number Description Actual 2016 Actual 2017 Budget 2018 Actual 2018 Budget 2019 YTD 07/30/19 2019 Preliminary Budget 2020 Budget Change 2020 Percentage Change 2020 611 -00- 4221 -0000 MAINTENANCE OF EQUIPMENT 0 311 5,000 1,268 5,000 0 5,000 0 0.0% 611 -00- 4223 -0000 MAINTENANCE OF BUILDINGS 0 0 0 1,469 0 0 0 0 N/A 611 -00- 4240 -0000 SMALL TOOLS/MINOR EQUIPMENT 50 239 550 484 600 907 900 300 50.0% 611 -00- 4245 -0000 GENERAL SUPPLIES 524 569 2,100 475 2,000 336 1,700 300 -15.0% Total Supplies 2,112 2,640 9,350 5,211 9,300 2,081 9,300 0 0.0% OTHER SERVICES AND CHARGES 611 -00- 4301 -0000 AUDITING & ACCOUNTING 0 0 2,500 0 0 0 0 0 N/A 611 -00- 4302 -0000 CONSULTING FEES 0 0 0 0 0 0 0 0 N/A 611 -00- 4303 -0000 ENGINEERING FEES 1,289 4,617 5,000 4,572 0 6,344 0 0 N/A 611 -00- 4304 -0000 LEGAL FEES 1,721 389 1,500 111 0 0 0 0 N/A 611 -00- 4312 -0000 ENGINEERING 0 0 5,000 0 5,000 0 5,000 0 0.0% 611 -00- 4321 -0000 COMMUNICATIONS - VOICE/DATA 2,905 3,343 3,000 2,549 3,600 629 3,600 0 0.0% 611 -00- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 1,310 0 1,600 100 1,600 445 1,600 0 0.0% 611 -00- 4351 -0000 PRINTING AND PUBLISHING 330 0 0 95 0 0 0 0 N/A 611 -00- 4360 -0000 INSURANCE 0 2,500 7,000 0 7,000 0 0 (7,000) - 100.0% 611 -00- 4380 -0000 UTILITY SERVICES 9 822 7,500 2,254 0 (986) 0 0 N/A 611 -00- 4385 -0000 MCES SAC Payables Charges 588,636 690,699 723,500 770,921 869,163 579,442 823,680 (45,483) -5.2% 611 -00- 4386 -0000 Excelsior Sewer Charges 49,366 49,309 40,000 45,500 50,000 0 50,000 0 0.0% 611 -00 -4400 -0000 CONTRACTUAL SERVICES 29,881 43,291 32,000 27,011 20,000 31,613 32,000 12,000 60.0% 611 -00- 4410 -0000 RENTALS 0 0 0 0 0 0 0 0 N/A 611 -00 -4420 -0000 DEPRECIATION 88,236 90,928 100,000 91,392 100,000 0 100,000 0 0.0% 611 -00 -4433 -0000 DUES AND SUBSCRIPTIONS 33 1,233 10,000 2,007 10,000 1,440 4,000 (6,000) -60.0% 611 -00 -4437 -0000 TAXES/LICENSES 195 0 0 475 500 498 500 0 0.0% 611 -00 -4440 -0000 MISC SERVICES /CONTINGENCY 0 0 150 0 0 0 0 0 N/A 611 -00 -4450 -0000 BANK SERVICE CHARGES 93 1,546 1,500 1,077 0 891 1,000 1,000 N/A 611 -00- 4499 -0000 FEMA ELIGLI13LE EXPENSES 0 0 0 0 0 0 0 0 N/A 611 -00- 4620 -0000 BUILDINGS & STRUCTURES 0 0 0 0 0 0 0 0 N/A 611 -00- 4640 -0000 MACHINERY & EQUIPMENT 0 0 0 0 11,500 101,262 0 (11,500) - 100.0% 611 -00- 4680 -0000 OTHER IMPROVEMENTS 2,665 0 0 4,741 0 0 390,000 390,000 N/A 611 -00- 4680 -0001 MCES Forcemain(DO NOT USE) 0 0 0 0 0 0 0 0 N/A 611 -00- 4680 -0011 MCES FORCEMAIN IMPROVEMENT 0 0 0 0 0 0 0 0 N/A Total Other Services and Charges 766,667 888,677 940,250 952,805 1,078,363 721,578 1,411,380 333,017 30.9% NON - OPERATING EXPENSES 611 -00- 4711 -0000 BOND INTEREST 0 0 0 0 0 0 0 0 N/A 611 -00- 4720 -0000 FISCAL AGENT FEES 0 0 0 0 0 0 0 0 N/A 611 -00- 4810 -0000 RESIDUAL EQUITY TRANSFERS 0 0 0 0 0 0 0 0 N/A 611 -00- 4820 -0000 OPERATING TRANSFERS 12,500 12,500 12,500 12,500 12,500 12,500 12,500 0 0.0% 611 -00- 4820 -0000 TRANSFERS FOR CIP STREETS 0 0 0 77,106 0 0 650,000 650,000 N/A Total Non - Operating Expenses 12,500 12,500 12,500 89,606 12,500 12,500 662,500 650,000 5200.0% Total Expenses 1,001,645 1,007,111 1,090,629 1,153,377 1,253,160 825,145 2,282,716 1,029,556 82.2% Change in Net Position 40,971 1,371 (147,029) (78,290) (271,560) (329,676) (1,257,316) (985,756) 363.0% 37 Sewer Fund 2020 Budget YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/30/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 Non -Cash: Depreciation 100,000 Bond Principal 0 Capital Acquisitions 390,000 shown above Change in Cash (1 157 31 C bonding? Change in Cash, Excluding Transfers for CIP Streets (507 31 fil 38 Recycling Fund 2020 Budget Account Number Description Actual 2016 Actual 2017 Budget 2018 Actual 2018 Budget 2019 YTD 07/30/19 2019 Preliminary Budget 2020 Budget Change 2020 Percentage Change 2020 FUND 621 Recycling Utility REVENUE 621 -00- 4101 -0000 621 -00- 3353 -0000 PERA PENSION OTHER REVENUE 49 4 0 56 0 0 0 0 N/A 621 -00- 3362 -0000 MISC GRANTS 26,912 23,790 20,100 22,219 17,750 15,895 14,595 (3,155) -17.8% 621 -00- 3400 -0000 CHARGES FOR SERVICES 0 0 0 0 0 0 0 0 N/A 621 -00- 3610 -0000 SPECIAL ASSESSMENTS - CURREN' 3,867 460 300 198 300 2,995 300 0 0.0% 621 -00- 3611 -0000 SPECIAL ASSESSMENTS- DELINQUE 194 0 0 0 0 0 0 0 N/A 621 -00- 3614 -0000 SPECIAL ASSESSMENTS- INTEREST 0 0 0 0 0 0 0 0 N/A 621 -00- 3620 -0000 INTEREST EARNINGS 2,407 2,691 1,000 4,084 1,000 0 1,000 0 0.0% 621 -00- 3621 -0000 GAIN / (LOSS) ON INVESTMENTS 0 0 0 0 0 0 0 0 N/A 621 -00- 3623 -0000 CONTRIBUTIONS AND DONATION' 0 0 0 0 0 0 0 0 N/A 621 -00- 3670 -0000 MISCELLANEOUS REVENUE 0 174 0 125 0 60 0 0 N/A 621 -00- 3710 -0000 UTILITY REVENUE 154,550 160,881 155,000 160,043 155,000 80,984 160,000 5,000 3.2% 621 -00- 3720 -0000 RECYCLING PENALTIES 0 0 0 0 0 0 0 0 N/A 621 -00- 3732 -0000 CITY CLEANUP CHARGES (4,431) (4,390) 8,000 (3,444) 8,000 6,453 6,500 (1,500) -18.8% 621 -00- 3920 -0000 TRANSFERS IN 0 0 0 0 0 0 0 0 N/A 39 REVENUE Totals: 183,549 183,610 184,400 183,281 182,050 106,387 182,395 345 0.2% EXPENSE PERSONAL SERVICES 621 -00- 4101 -0000 FULL -TIME REGULAR 9,344 10,546 6,111 9,476 6,843 6,088 10,948 4,105 60.0% 621 -00- 4102 -0000 OVERTIME 661 712 0 0 0 0 0 0 N/A 621 -00- 4103 -0000 PART -TIME 0 68 0 0 0 0 0 0 N/A 621 -00- 4104 -0000 TEMPORARY REGULAR 0 0 0 0 0 0 0 0 N/A 621 -00- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 621 -00- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 621 -00- 4121 -0000 PERA CONTRIB - CITY SHARE 757 844 458 712 513 456 821 308 60.0% 621 -00- 4122 -0000 FICA CONTRIB - CITY SHARE 670 799 467 672 524 385 838 314 59.9% 621 -00- 4131 -0000 EMPLOYEE INSURANCE - CITY 1,687 1,725 1,296 1,769 1,356 1,052 2,655 1,299 95.8% 621 -00- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 621 -00- 4151 -0000 WORKERS COMPENSATION 69 147 49 95 36 33 57 21 58.3% 621 -00- 4161 -0000 PENSIONEXPENSE 684 1,347 0 3,305 0 0 0 0 N/A Total Personal Services 13,872 16,188 8,381 9,419 9,272 8,014 15,319 6,047 65.2% SUPPLIES 621 -00- 4200 -0000 OFFICE SUPPLIES 152 163 100 220 100 149 300 200 200.0% 621 -00- 4208 -0000 POSTAGE 1,386 1,358 1,400 1,358 1,400 689 1,500 100 7.1% 621 -00- 4221 -0000 MAINTENANCE OF EQUIPMENT 0 0 0 0 0 0 0 0 N/A 621 -00- 4223 -0000 MAINTENANCE OF BUILDINGS 0 0 0 0 0 0 0 0 N/A 621 -00- 4240 -0000 SMALL TOOLS/MINOR EQUIPMENT 0 0 0 0 0 0 0 0 N/A 621 -00- 4245 -0000 GENERAL SUPPLIES 0 0 200 37 200 0 200 0 0.0% Total Supplies 1,538 1,521 1,700 1,615 1,700 838 2,000 300 17.6% 39 Recycling Fund 2020 Budget YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/30/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2020 2020 2020 OTHER SERVICES AND CHARGES 621 -00- 4301 -0000 AUDITING & ACCOUNTING 621 -00- 4302 -0000 CONSULTING FEES 621 -00- 4303 -0000 ENGINEERING FEES 621 -00- 4304 -0000 LEGAL FEES 621 -00- 4312 -0000 ENGINEERING 621 -00- 4321 -0000 COMMUNICATIONS - VOICE/DATA 621 -00- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 621 -00- 4347 -0000 CITY CLEANUP EXP 621 -00- 4351 -0000 PRINTING AND PUBLISHING 621 -00- 4360 -0000 INSURANCE 621 -00- 4380 -0000 UTILITY SERVICES 621 -00 -4400 -0000 CONTRACTUAL SERVICES 621 -00 -4400 -0026 ORGANIC GARBAGE 621 -00- 4410 -0000 RENTALS 621 -00 -4420 -0000 DEPRECIATION 621 -00 -4433 -0000 DUES AND SUBSCRIPTIONS 621 -00 -4437 -0000 TAXES/LICENSES 621 -00 -4440 -0000 MISC SERVICES /CONTINGENCY 621 -00 -4450 -0000 BANK SERVICE CHARGES Total Other Services and Charges NON - OPERATING EXPENSES 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 2,516 0 1,853 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 65 58 0 185 200 20 400 200 100.0% 0 0 0 0 0 5,832 11,500 11,500 N/A 137 420 150 0 0 161 300 300 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 116,967 118,632 117,000 122,795 117,000 58,366 125,000 8,000 6.8% 0 714 0 210 0 210 400 400 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 75 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 160 8,500 0 8,500 0 8,500 0 0.0% 0 0 0 0 0 0 L 0 0 N/A 117,244 119,984 125,650 125,706 125,700 66,442 146,100 20,400 16.2% 621 -00- 4810 -0000 RESIDUAL EQUITY TRANSFERS 0 0 0 0 0 0 0 0 N/A 621 -00- 4820 -0000 OPERATING TRANSFERS 0 0 0 0 0 0 0 0 N/A Total Non - Operating Expenses 0 0 0 0 0 0 0 0 N/A Total Expenses 132,654 137,693 135,731 136,740 136,672 75,294 163,419 26,747 19.6% Change in Net Position 50,895 45,917 48,669 46,541 45,378 31,093 18,976 (26,402) -58.2% 40 Stormwater Management Fund 2020 Budget YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/30/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2000 2000 2000 FUND 631 Storm Water Utility REVENUE 631 -00- 3353 -0000 PERA PENSION OTHER REVENUE 138 9 0 161 0 0 0 0 N/A 631 -00- 3362 -0000 MISC GRANTS 0 0 0 0 0 0 0 0 N/A 631 -00- 3400 -0000 CHARGES FOR SERVICES 0 0 0 0 0 0 0 0 N/A 631 -00- 3610 -0000 SPECIAL ASSESSMENTS - CURREN' 5,421 640 500 205 0 6,040 0 0 N/A 631 -00- 3611 -0000 SPECIAL ASSESSMENTS- DELINQUE 790 0 0 0 0 0 0 0 N/A 631 -00- 3614 -0000 SPECIAL ASSESSMENTS- INTEREST 0 0 0 0 0 0 0 0 N/A 631 -00- 3620 -0000 INTEREST EARNINGS 10,421 10,525 5,000 13,715 5,000 0 5,000 0 0.0% 631 -00- 3621 -0000 GAIN / (LOSS) ON INVESTMENTS 0 0 0 0 0 0 0 0 N/A 631 -00- 3670 -0000 MISCELLANEOUS REVENUE 0 0 0 0 0 0 0 0 N/A 631 -00- 3710 -0000 UTILITY REVENUE 268,959 340,540 387,000 381,792 399,000 198,351 400,464 1,464 0.4% 631 -00- 3712 -0000 UTILITY PERMIT FEES 0 0 0 0 0 0 0 0 N/A 631 -00- 3720 -0000 STORM WATER PENALTIES 0 0 0 0 0 0 0 0 N/A 631 -00- 3900 -0000 CAPITAL CONTRIBUTIONS 0 395,706 0 422,629 0 0 0 0 N/A 631 -00- 3910 -0000 SALES OF CAPITAL ASSETS 0 0 0 0 0 0 in 0 0 N/A 631 -00- 3920 -0000 TRANSFERS IN 0 0 0 0 0 230,000 0 0 N/A REVENUE Totals: 285,728 747,420 392,500 818,502 404,000 434,391 405,464 1,464 0.4% EXPENSE I, no 11f fI IR MM D1.41 W DR 631 -00- 4101 -0000 FULL -TIME REGULAR 27,584 25,402 12,550 26,807 35,268 31,143 53,087 17,819 50.5% 631 -00- 4102 -0000 OVERTIME 332 749 500 318 500 1,410 800 300 60.0% 631 -00- 4103 -0000 PART -TIME 0 0 0 0 0 0 0 0 N/A 631 -00- 4104 -0000 TEMPORARY REGULAR 0 0 0 0 0 0 0 0 N/A 631 -00- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 631 -00- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 631 -00- 4121 -0000 PERA CONTRIB - CITY SHARE 2,120 1,919 941 2,033 2,645 2,340 4,042 1,397 52.8% 631 -00- 4122 -0000 FICA CONTRIB - CITY SHARE 1,992 1,880 960 1,946 2,698 2,286 4,122 1,424 52.8% 631 -00- 4131 -0000 EMPLOYEE INSURANCE - CITY 2,566 1,920 1,472 1,891 3,573 2,867 7,845 4,272 119.6% 631 -00- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 631 -00- 4151 -0000 WORKERS COMPENSATION 1,080 845 490 985 1,633 1,003 3,210 1,577 96.6% 631 -00- 4161 -0000 PENSIONEXPENSE 8,261 2,202 0 2,844 0 0 0 0 N/A Total Personal Services 27,413 30,513 16,913 31,136 46,317 41,049 73,106 26,789 57.8% SUPPLIES 631 -00- 4200 -0000 OFFICE SUPPLIES 152 163 200 157 200 149 149 (51) -25.5% 631 -00- 4208 -0000 POSTAGE 1,386 1,358 1,400 1,358 1,400 689 689 (711) -50.8% 631 -00- 4212 -0000 MOTOR FUELS & LUBRICANTS 0 0 0 0 0 0 0 0 N/A 631 -00- 4215 -0000 SHOP MATERIALS 0 0 0 0 0 0 0 0 N/A 631 -00- 4221 -0000 MAINTENANCE OF EQUIPMENT 0 0 30,000 0 30,000 0 0 (30,000) - 100.0% 631 -00- 4223 -0000 MAINTENANCE OF BUILDINGS 0 0 0 0 0 0 0 0 N/A 631 -00- 4240 -0000 SMALL TOOLS/MINOR EQUIPMENT 0 0 500 0 500 0 0 (500) - 100.0% 41 Stormwater Management Fund 2020 Budget 42 YTD Preliminary Budget Percentage Actual Actual Budget Actual Budget 07/30/19 Budget Change Change Account Number Description 2016 2017 2018 2018 2019 2019 2000 2000 2000 631 -00- 4245 -0000 GENERAL SUPPLIES 370 64 3,000 800 3,000 6,156 ML 6,156 3,156 105.2% Total Supplies 1,909 1,585 35,100 2,315 35,100 6,994 6,994 (28,106) -80.1% OTHER SERVICES AND CHARGES 631 -00- 4301 -0000 AUDITING & ACCOUNTING 0 0 0 0 0 0 0 0 N/A 631 -00- 4302 -0000 CONSULTING FEES 0 0 0 0 0 0 0 0 N/A 631 -00- 4302 -0005 MS4 (DO NOT USE) 0 0 0 0 0 0 0 0 N/A 631 -00- 4302 -0009 MS4 SERVICES 3,869 5,490 0 9,930 5,000 1,651 5,000 0 0.0% 631 -00- 4303 -0000 ENGINEERING FEES 27,552 8,507 35,000 34,224 35,000 19,261 35,000 0 0.0% 631 -00- 4304 -0000 LEGAL FEES 0 0 10,000 0 15,000 2,999 15,000 0 0.0% 631 -00- 4312 -0000 ENGINEERING 0 0 0 0 0 0 0 0 N/A 631 -00- 4321 -0000 COMMUNICATIONS - VOICE/DATA 605 651 500 576 0 0 0 0 N/A 631 -00- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 0 0 800 0 0 0 0 0 N/A 631 -00- 4351 -0000 PRINTING AND PUBLISHING 0 41 100 0 0 0 0 0 N/A 631 -00- 4360 -0000 INSURANCE 0 0 0 0 0 0 0 0 N/A 631 -00- 4380 -0000 UTILITY SERVICES 0 0 0 0 0 0 0 0 N/A 631 -00 -4400 -0000 CONTRACTUAL SERVICES 5,883 12,035 83,500 10,662 10,000 3,577 10,000 0 0.0% 631 -00- 4410 -0000 RENTALS 0 0 0 0 2,000 0 2,000 0 0.0% 631 -00 -4420 -0000 DEPRECIATION 44,110 57,284 46,000 59,395 60,000 0 62,000 2,000 3.3% 631 -00 -4433 -0000 DUES AND SUBSCRIPTIONS 33 1,233 10,000 737 10,000 720 4,000 (6,000) -60.0% 631 -00 -4437 -0000 TAXES/LICENSES 0 400 0 0 0 6,652 0 0 N/A 631 -00 -4440 -0000 MISC SERVICES /CONTINGENCY 0 0 0 0 0 0 0 0 N/A 631 -00 -4450 -0000 BANK SERVICE CHARGES 0 0 1,000 0 0 0 0 0 N/A 631 -00- 4499 -0000 FEMA ELIGLI13LE EXPENSES 0 0 0 0 0 0 0 0 N/A 631 -00- 4620 -0000 BUILDINGS & STRUCTURES 0 0 0 0 0 0 0 0 N/A 631 -00- 4640 -0000 MACHINERY & EQUIPMENT 0 0 0 0 0 0 28,000 28,000 N/A 631 -00- 4680 -0000 OTHER IMPROVEMENTS 0 0 0 0 0 0 84,500 84,500 N/A Total Other Services and Charges 82,051 85,641 186,900 115,524 137,000 34,860 245,500 108,500 79.2% NON - OPERATING EXPENSES 631 -00- 4810 -0000 RESIDUAL EQUITY TRANSFERS 0 0 0 0 0 0 0 0 N/A 631 -00- 4820 -0000 OPERATING TRANSFERS 0 20,478 0 0 0 0 0 0 N/A 631 -00- 4820 -0000 TRANSFERS FOR CIP STREETS 0 0 0 168,325 0 0 800,000 800,000 N/A Total Non - Operating Expenses 0 20,478 0 168,325 0 0 800,000 800,000 N/A Total Expenses 111,373 138,217 238,913 317,300 218,417 82,903 1,125,600 907,183 415.3% Change in Net Position 174,355 609,203 153,587 501,202 185,583 351,488 (720,136) (905,719) - 488.0% Non -Cash: Depreciation 62,000 Bond Principal 0 Capital Acquisitions 112,500 shown above Change in Cash fi5R 14fi bondinq? Change in Cash, Excluding Transfers for CIP Streets 41 EL 42 PARK CAPITAL IMPROVEMENT FUND Fund: 402- Park Capital Outlay EXPENDITURES 622,793 302,564 YTD & Est. 2019 costs as of 07 -17 -19 Addl Engineering- WSB 0 0 0 estimated Other Improvements 716,456 466,624 522,669 Actual Actual 2019 Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget 368,500 2017 2018 7/11/2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 REVENUES 122,411 129,247 136,186 143,229 Beginning Fund Balance 612,818 690,197 396,364 294,048 178,059 (59,270) (323,660) (346,414) (266,611) (172,610) (50,199) 79,048 215,234 Ending Fund Balance Park Dedication Fees - Mattamy 291,127 87,888 - - - - - - - - - - - ParkDedicationFees - Oppidan - - - - - - - - - - - - - ParkDedicationFees - Other 6,500 13,000 13,000 - - - - - - - - - - Interest Earnings 12,878 9,053 10,353 4,411 2,671 (889) (4,855) (5,196) (3,999) (2,589) (753) 1,186 3,229 Contributions /donations - Minnetonka Youth lacrosse - 2,000 - - - - - - - - - - - Contributions /donations - Tonka football - - - - - - - - - - - - - Grants - Hennepin County Lacrosse 200,000 - - - - - - - - - - - - Grants - Badger Park - - 175,000 - - - - - - - - - - Miscellaneous revenue - - - - - - - - - - - - - Transfersin - Budget 42,000 42,000 42,000 95,000 100,000 105,000 110,000 115,000 120,000 125,000 130,000 135,000 140,000 Transfers in - Excess Reserves 200,000 - 180,000 - - - - - - - - - - Transfers in - Badger Park Phase 2 (Water, Storm, Street) 41,330 - - - - - - - - - - - - Transfersin - correct Excelsior annexation detachment - 18,850 - - - - - - - - - - - TOTAL REVENUES 793,835 172,791 420,353 99,411 102,671 104,111 105,145 109,804 116,001 122,411 129,247 136,186 143,229 EXPENDITURES 622,793 302,564 1,876 2019 costs as of 07 -17 -19 Addl Engineering- WSB 0 0 0 estimated Other Improvements 716,456 466,624 522,669 215,400 340,000 368,500 127,900 30,000 22,000 - - - - TOTAL EXPENDITURES 716,456 466,624 522,669 215,400 340,000 368,500 127,900 30,000 22,000 Prehall Electric Revenues Over /(Under) Expenditures 77,379 (293,833) (102,316) (115,989) (237,329) (264,389) (22,755) 79,804 94,001 122,411 129,247 136,186 143,229 Beginning Fund Balance 612,818 690,197 396,364 294,048 178,059 (59,270) (323,660) (346,414) (266,611) (172,610) (50,199) 79,048 215,234 Ending Fund Balance 690,197 396,364 294,048 178,059 (59,270) (323,660) (346,414) (266,611) (172,610) (50,199) 79,048 215,234 358,462 Expenditures Badger Park Phase 2 622,793 302,564 1,876 2019 costs as of 07 -17 -19 Addl Engineering- WSB 0 0 0 estimated 622,793 302,564 1,876 Badger Park Playground 0 164,060 58,321 2019 costs as of 07- 11 -19, including Blackstone and Loucks Addl Contract 0 0 136,799 Blackstone Contractors LLC Change order - electrician 0 0 13,700 Prehall Electric Addl Engineering- Loucks 0 0 5,000 estimated 0 164,060 213,820 Badger Park shelter 0 0 0 2019 costs as of 07 -11 -19 Addl Contract 0 0 64,033 Structural Wood 0 0 64,033 Badger Park restroom 0 0 1,650 2019 costs as of 07 -11 -19 Addl Contract 0 0 145,210 Tom Koehnen 0 0 146,860 Freeman Park Parking Lot, Rink, Lights 93,663 0 0 Freeman Park Playground 0 0 77,980 Cathcart and Silverwood Parks - resurfacing courts 0 0 18,100 93,663 0 96,080 716,456 466,624 522,669 43 EQUIPMENT REPLACEMENT FUND Fund: 403 - Equipment Replacement REVENUES Interest Earnings Grants Miscellaneous revenue Sale of Capital Assets Transfers in - Budget Transfers in - Excess Reserves TOTAL REVENUES EXPENDITURES Public Works Administration TOTAL EXPENDITURES Revenues Over /(Under) Expenditures Beginning Fund Balance Ending Fund Balance 44 YTD & Est. Actual Actual 2019 Budget Budget Budget Budget Budget Budget Budget Budget Budget 2017 2018 7/17/2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 8,514 6,985 7,134 4,997 2,917 3,519 3,397 4,402 5,857 4,051 5,351 3,271 - 14,500 - - - - - - - - - - 120,000 135,000 140,000 95,000 100,000 105,000 110,000 115,000 120,000 125,000 130,000 135,000 - - 32,500 - - - - - - - - - 128,514 156,485 179,634 99,997 102,917 108,519 113,397 119,402 125,857 129,051 135,351 138,271 216,878 94,372 282,100 228,700 52,800 96,600 36,400 12,400 236,300 32,400 264,000 202,700 7,630 38,986 40,000 10,000 10,000 20,000 10,000 10,000 10,000 10,000 10,000 10,000 224,508 133,358 322,100 238,700 62,800 116,600 46,400 22,400 246,300 42,400 274,000 212,700 (95,994) 23,127 (142,466) (138,703) 40,117 (8,081) 66,997 97,002 (120,443) 86,651 (138,649) (74,429) 548,495 452,501 475,628 333,162 194,460 234,577 226,495 293,493 390,495 270,053 356,703 218,054 452,501 475,628 333,162 194,460 234,577 226,495 293,493 390,495 270,053 356,703 218,054 143,625 44