Loading...
Administration Committee Packet 2019 06-19-19 AGENDA ADMINISTRATION COMMITTEE MEETING Wednesday, June 19, 2019 6:00 p.m. City Hall Conference Room 800 Game Farm Road, Yorkville, IL Citizen Comments: Minutes for Correction/Approval: May 15, 2019 New Business: 1. ADM 2019-25 Monthly Budget Report for May 2019 2. ADM 2019-26 Monthly Treasurer’s Report for May 2019 3. ADM 2019-27 Cash Statement for April 2019 4. ADM 2019-28 Monthly Website Report for May 2019 5. ADM 2019-29 Vehicle Replacement Chart 6. ADM 2019-30 Selection of Committee Liaisons 7. ADM 2019-31 Meeting Dates 8. ADM 2019-32 Nepotism Policy 9. ADM 2019-33 Policy Review 10. ADM 2019-34 Solicitor Registration and Regulations 11. ADM 2019-35 Facilities Master Plan RFQ Old Business: Additional Business: United City of Yorkville 800 Game Farm Road Yorkville, Illinois 60560 Telephone: 630-553-4350 www.yorkville.il.us Administration Committee Agenda June 19, 2019 Page 2 2019/2020 City Council Goals - Administration Committee Goal Priority Staff “Staffing” 1 Bart Olson, Rob Fredrickson, Rich Hart, Eric Dhuse, Tim Evans & Erin Willrett “Municipal Building Needs and Planning” 2 Bart Olson, Rob Fredrickson, Rich Hart, Eric Dhuse, Tim Evans & Erin Willrett “Road to Better Roads Funding” 3 Bart Olson, Rob Fredrickson & Eric Dhuse “Metra Extension” 7 Bart Olson, Rob Fredrickson, Eric Dhuse, Krysti Barksdale-Noble & Erin Willrett “Automation and Technology” 11 (tie) Bart Olson, Erin Willrett & Lisa Pickering “Grant Opportunities and Planning” 11 (tie) Bart Olson, Erin Willrett & Tim Evans “Revenue Growth” 13 Rob Fredrickson, Krysti Barksdale-Noble & Lynn Dubajic “Special Events Amplification” 14 (tie) Erin Willrett & Tim Evans “Public Relations and Outreach” 16 Bart Olson & Erin Willrett UNITED CITY OF YORKVILLE WORKSHEET ADMINISTRATION COMMITTEE Wednesday, June 19, 2019 6:00 PM CITY HALL CONFERENCE ROOM --------------------------------------------------------------------------------------------------------------------------------------- CITIZEN COMMENTS: --------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------- MINUTES FOR CORRECTION/APPROVAL: --------------------------------------------------------------------------------------------------------------------------------------- 1. May 15, 2019 □ Approved __________ □ As presented □ With corrections --------------------------------------------------------------------------------------------------------------------------------------- NEW BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2019-25 Monthly Budget Report for May 2019 □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2019-26 Monthly Treasurer’s Report for May 2019 □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 3. ADM 2019-27 Cash Statement for April 2019 □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 4. ADM 2019-28 Monthly Website Report for May 2019 □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 5. ADM 2019-29 Vehicle Replacement Chart □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 6. ADM 2019-30 Selection of Committee Liaisons □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 7. ADM 2019-31 Meeting Dates □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 8. ADM 2019-32 Nepotism Policy □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 9. ADM 2019-33 Policy Review □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 10. ADM 2019-34 Solicitor Registration and Regulations □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 11. ADM 2019-35 Facilities Master Plan RFQ □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- ADDITIONAL BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number Minutes Tracking Number Minutes of the Administration Committee – May 15, 2019 Administration Committee – June 19, 2019 Majority Committee Approval Minute Taker Name Department Page 1 of 3 DRAFT UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE MEETING Wednesday, May 15, 2019 6:00pm City Hall Conference Room Committee Members In Attendance: Chairman Chris Funkhouser Alderman Dan Transier Alderman Jason Peterson Absent: Alderman Joe Plocher Other City Officials In Attendance: Mayor John Purcell Assistant City Administrator Erin Willrett City Administrator Bart Olson Finance Director Rob Fredrickson Others in Attendance: None The meeting was called to order at 6:01pm by Chairman Chris Funkhouser. Citizen Comments: None Minutes for Correction/Approval: March 20, 2019 The minutes were approved as presented. New Business: 1. ADM 2019-18 Monthly Budget Report for March and April 2019 Mr. Olson presented the 12-month budget report and said this report provides a good month-to-month comparison. March figures reflect the holiday sales and the holiday receipts were down by 10% this year over last year. He explained the income tax is per capita-based and the city receives about $105 per resident. The use tax is based on out- of-state on-line purchases and is outperforming expectations. Chairman Funkhouser asked to have an asterisk placed by on-line items and Alderman Peterson asked that another column be added to show overages/deficits or transfer of funds to another category. Mr. Olson said a cover letter summary could be provided. Administrator Olson said the expenditure numbers are not yet final, but are following trends from previous years. Mayor Purcell asked about municipal vs. non-home rule sales taxes for which Mr. Olson gave an explanation. Page 2 of 3 There was discussion about taxes collected from the businesses in Kendall Marketplace. It was also noted that inspections were up by 1800%. This report will be forwarded to the full Council. 2. ADM 2019-19 Monthly Treasurer's Report for March and April 2019 Mr. Fredrickson reported the below revenue figures. Mayor Purcell asked about the enterprise fund which includes infrastructure fees, water fees and investment earnings. This moves to the full Council for approval by vote. March April $11,544,948 $11,544,948 Beginning Fund Balance $29,387,187 $31,843,184 YTD Revenues $28,272,261 $29,978.667 YTD Expenses $12,659,874 $13,409,465 Projected Ending Fund Balance 3. ADM 2019-20 Cash Statement for February and March 2019 Alderman Peterson asked what occurs when CD's reach their maturity dates. Mr. Fredrickson said the city uses an agency called PMA to search throughout the country for the best rates. Mr. Fredrickson also briefly discussed other options. Agreements will be examined next month after agencies are vetted by staff. 4. ADM 2019-21 Bills for Payment The bill list will no longer come to the Administration committee since these bills will have been approved by the time this committee meets. 5. ADM 2019-22 Monthly Website Report for March and April 2019 Ms. Willrett said the website is on the upswing, gaining visitors, followers and likes. She said there are 3 months of history for comparison in the report. Alderman Transier asked who updates the pages. Staff and Parks and Rec Administrators make the changes and Ms. Willrett said staff will begin a website re-design in June. Mr. Olson noted that messages come in all hours of the day and people expect 24/7 monitoring. The committee discussed the fact that information is available on various sites like Facebook and 'neighborhood' sites as well as the city website. Chairman Funkhouser asked about obtaining analytics for duration of the visit and clicks thru on the city site as compared to other sites. Ms. Willrett said visitors do not stay or click on the site, so a direct link is provided for most information. She will provide the requested analytics. This item is informational. 6. ADM 2019-23 Required Reporting to Municipality by Yorkville Police Pension Board Mr. Fredrickson said this is the annual report which shows actuarial valuation from the city compared to the actuarial valuation done by the Illinois Department of Insurance. He said the report shows the city's contribution will be just over $1.1 million this year, up $150,000 over the previous year. Mr. Fredrickson gave a history of the process and explanation of the increase. He expects better returns in the future based on equity investments and if there is a shortfall, the money will come from the general fund. The Pension Board has financial advisers who assist with investments. Page 3 of 3 The Mayor asked about the IMRF fund status. It is currently in the 90% range for the Police Department. Mayor Purcell asked if the city could pay more than is owed in a given year for IMRF or the police pension. Only the annual required contribution is paid for the police pension fund. This report moves to the City Council for information as well as to the Police Pension Board. 7. ADM 2019-24 Travel Authorizations for FY 2020 There are three travel authorizations for the upcoming FY and Mr. Olson said the authorizations are mandated by State law to be voted on in open session. There was a brief discussion about the upcoming conferences and not budgeting for the third night of the IML conference if no one attends. This item will move forward to City Council for a vote. Old Business: None Additional Business: Chairman Funkhouser noted that Lisa Pickering has assumed the duties of City Clerk and Rob Fredrickson is the City Treasurer. City code sets the stipend amount and meeting fee for the Clerk and the Mayor will be reviewing the salary. There was no further business and the meeting adjourned at 7:14pm. Respectfully transcribed by Marlys Young, Minute Taker Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #1 Tracking Number ADM 2019-25 Monthly Budget Reports for May 2019 Administration Committee – June 19, 2019 Informational None Monthly budget reports and income statements. Rob Fredrickson Finance Name Department % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget GENERAL FUND REVENUES Taxes 01-000-40-00-4000 PROPERTY TAXES 175,386 175,386 2,119,323 8.28% 01-000-40-00-4010 PROPERTY TAXES-POLICE PENSION 91,517 91,517 1,105,927 8.28% 01-000-40-00-4030 MUNICIPAL SALES TAX 211,897 211,897 3,151,800 6.72% 01-000-40-00-4035 NON-HOME RULE SALES TAX 157,270 157,270 2,432,700 6.46% 01-000-40-00-4040 ELECTRIC UTILITY TAX - - 710,000 0.00% 01-000-40-00-4041 NATURAL GAS UTILITY TAX 24,573 24,573 250,000 9.83% 01-000-40-00-4043 EXCISE TAX 32,276 32,276 313,625 10.29% 01-000-40-00-4044 TELEPHONE UTILITY TAX 695 695 8,340 8.33% 01-000-40-00-4045 CABLE FRANCHISE FEES 63,971 63,971 290,000 22.06% 01-000-40-00-4050 HOTEL TAX 1,549 1,549 80,000 1.94% 01-000-40-00-4055 VIDEO GAMING TAX 14,990 14,990 140,000 10.71% 01-000-40-00-4060 AMUSEMENT TAX 4,592 4,592 205,000 2.24% 01-000-40-00-4065 ADMISSIONS TAX - - 140,000 0.00% 01-000-40-00-4070 BDD TAX - KENDALL MARKETPLACE 27,274 27,274 382,500 7.13% 01-000-40-00-4071 BDD TAX - DOWNTOWN 15,863 15,863 35,000 45.32% 01-000-40-00-4072 BDD TAX - COUNTRYSIDE 562 562 10,000 5.62% 01-000-40-00-4075 AUTO RENTAL TAX - - 14,500 0.00% Intergovernmental 01-000-41-00-4100 STATE INCOME TAX 381,988 381,988 1,916,366 19.93% 01-000-41-00-4105 LOCAL USE TAX 45,940 45,940 602,966 7.62% 01-000-41-00-4110 ROAD & BRIDGE TAX 10,903 10,903 130,000 8.39% 01-000-41-00-4120 PERSONAL PROPERTY TAX 4,406 4,406 17,000 25.92% 01-000-41-00-4160 FEDERAL GRANTS - - 15,000 0.00% 01-000-41-00-4168 STATE GRANT - TRF SIGNAL MAINT - - 21,000 0.00% 01-000-41-00-4170 STATE GRANTS - - - 0.00% 01-000-41-00-4182 MISC INTERGOVERNMENTAL - - 900 0.00% Licenses & Permits 01-000-42-00-4200 LIQUOR LICENSES 450 450 56,000 0.80% 01-000-42-00-4205 OTHER LICENSES & PERMITS 1,777 1,777 7,500 23.70% 01-000-42-00-4210 BUILDING PERMITS 46,319 46,319 350,000 13.23% Fines & Forfeits 01-000-43-00-4310 CIRCUIT COURT FINES 2,839 2,839 45,000 6.31% 01-000-43-00-4320 ADMINISTRATIVE ADJUDICATION 1,471 1,471 30,000 4.90% 01-000-43-00-4323 OFFENDER REGISTRATION FEES 35 35 400 8.75% 01-000-43-00-4325 POLICE TOWS 2,500 2,500 50,000 5.00% Charges for Service 01-000-44-00-4400 GARBAGE SURCHARGE 873 873 1,224,875 0.07% 01-000-44-00-4405 UB COLLECTION FEES 16,638 16,638 165,000 10.08% UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 1 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 01-000-44-00-4407 LATE PENALTIES - GARBAGE 2 2 21,000 0.01% 01-000-44-00-4415 ADMINISTRATIVE CHARGEBACK 17,070 17,070 204,836 8.33% 01-000-44-00-4474 POLICE SPECIAL DETAIL - - 500 0.00% Investment Earnings 01-000-45-00-4500 INVESTMENT EARNINGS 11,033 11,033 80,000 13.79% Reimbursements 01-000-46-00-4604 REIMB - ENGINEERING EXPENSES - - 25,000 0.00% 01-000-46-00-4680 REIMB - LIABILITY INSURANCE - - 10,000 0.00% 01-000-46-00-4685 REIMB - CABLE CONSORTIUM - - 35,000 0.00% 01-000-46-00-4690 REIMB - MISCELLANEOUS 296 296 5,000 5.93% Miscellaneous 01-000-48-00-4820 RENTAL INCOME 500 500 7,000 7.14% 01-000-48-00-4850 MISCELLANEOUS INCOME 4,837 4,837 13,000 37.21% Other Financing Uses 01-000-49-00-4916 TRANSFER FROM CW MUNICIPAL BLDG - - 47,180 0.00% TOTAL REVENUES: GENERAL FUND 1,372,293 1,372,293 16,469,238 8.33% ADMINISTRATION EXPENDITURES Salaries & Wages 01-110-50-00-5001 SALARIES - MAYOR 725 725 11,000 6.59% 01-110-50-00-5002 SALARIES - LIQUOR COMM 83 83 1,000 8.33% 01-110-50-00-5003 SALARIES - CITY CLERK 500 500 - 0.00% 01-110-50-00-5005 SALARIES - ALDERMAN 4,000 4,000 50,000 8.00% 01-110-50-00-5010 SALARIES - ADMINISTRATION 61,298 61,298 538,095 11.39% Benefits 01-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION 5,560 5,560 49,367 11.26% 01-110-52-00-5214 FICA CONTRIBUTION 4,959 4,959 41,686 11.90% 01-110-52-00-5216 GROUP HEALTH INSURANCE 20,352 20,352 120,064 16.95% 01-110-52-00-5222 GROUP LIFE INSURANCE 43 43 428 9.93% 01-110-52-00-5223 GROUP DENTAL INSURANCE 1,309 1,309 7,853 16.67% 01-110-52-00-5224 VISION INSURANCE 188 188 1,130 16.66% Contractual Services 01-110-54-00-5412 TRAINING & CONFERENCES 934 934 17,000 5.49% 01-110-54-00-5415 TRAVEL & LODGING 1,671 1,671 10,000 16.71% 01-110-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - 1,655 0.00% 01-110-54-00-5426 PUBLISHING & ADVERTISING - - 5,000 0.00% 01-110-54-00-5430 PRINTING & DUPLICATION - - 3,250 0.00% 01-110-54-00-5440 TELECOMMUNICATIONS 471 471 19,000 2.48% 01-110-54-00-5448 FILING FEES - - 500 0.00% 01-110-54-00-5451 CODIFICATION - - 5,000 0.00% 01-110-54-00-5452 POSTAGE & SHIPPING 57 57 3,000 1.90% 2 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 01-110-54-00-5460 DUES & SUBSCRIPTIONS 8,828 8,828 20,000 44.14% 01-110-54-00-5462 PROFESSIONAL SERVICES 100 100 12,000 0.83% 01-110-54-00-5480 UTILITIES - - 20,787 0.00% 01-110-54-00-5485 RENTAL & LEASE PURCHASE 113 113 3,000 3.78% 01-110-54-00-5488 OFFICE CLEANING - - 11,757 0.00% Supplies 01-110-56-00-5610 OFFICE SUPPLIES 140 140 10,000 1.40% TOTAL EXPENDITURES: ADMINISTRATION 111,331 111,331 962,572 11.57% FINANCE EXPENDITURES Salaries & Wages 01-120-50-00-5010 SALARIES & WAGES 31,356 31,356 301,372 10.40% Benefits 01-120-52-00-5212 RETIREMENT PLAN CONTRIBUTION 2,854 2,854 27,649 10.32% 01-120-52-00-5214 FICA CONTRIBUTION 2,353 2,353 21,574 10.91% 01-120-52-00-5216 GROUP HEALTH INSURANCE 8,601 8,601 64,351 13.37% 01-120-52-00-5222 GROUP LIFE INSURANCE 20 20 246 8.33% 01-120-52-00-5223 DENTAL INSURANCE 865 865 5,192 16.67% 01-120-52-00-5224 VISION INSURANCE 118 118 707 16.68% Contractual Services 01-120-54-00-5412 TRAINING & CONFERENCES 507 507 3,500 14.49% 01-120-54-00-5414 AUDITING SERVICES - - 34,100 0.00% 01-120-54-00-5415 TRAVEL & LODGING 83 83 1,000 8.27% 01-120-54-00-5430 PRINTING & DUPLICATING 76 76 3,500 2.16% 01-120-54-00-5440 TELECOMMUNICATIONS - - 1,250 0.00% 01-120-54-00-5452 POSTAGE & SHIPPING 93 93 1,200 7.75% 01-120-54-00-5460 DUES & SUBSCRIPTIONS 90 90 1,500 6.00% 01-120-54-00-5462 PROFESSIONAL SERVICES 1,696 1,696 60,000 2.83% 01-120-54-00-5485 RENTAL & LEASE PURCHASE 150 150 2,200 6.81% Supplies 01-120-56-00-5610 OFFICE SUPPLIES - - 2,500 0.00% TOTAL EXPENDITURES: FINANCE 48,863 48,863 531,841 9.19% POLICE EXPENDITURES Salaries & Wages 01-210-50-00-5008 SALARIES - POLICE OFFICERS 197,516 197,516 1,924,224 10.26% 01-210-50-00-5011 SALARIES - POLICE CHIEF & DEPUTIES 49,255 49,255 396,159 12.43% 01-210-50-00-5012 SALARIES - SERGEANTS 59,662 59,662 644,811 9.25% 01-210-50-00-5013 SALARIES - POLICE CLERKS 18,878 18,878 175,554 10.75% 3 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 01-210-50-00-5014 SALARIES - CROSSING GUARD 4,892 4,892 27,500 17.79% 01-210-50-00-5015 PART-TIME SALARIES 6,741 6,741 70,000 9.63% 01-210-50-00-5020 OVERTIME 10,944 10,944 111,000 9.86% Benefits 01-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,710 1,710 16,106 10.62% 01-210-52-00-5213 EMPLOYER CONTRI - POL PEN 91,517 91,517 1,111,484 8.23% 01-210-52-00-5214 FICA CONTRIBUTION 25,763 25,763 245,951 10.47% 01-210-52-00-5216 GROUP HEALTH INSURANCE 105,320 105,320 741,025 14.21% 01-210-52-00-5222 GROUP LIFE INSURANCE 202 202 2,748 7.34% 01-210-52-00-5223 DENTAL INSURANCE 7,452 7,452 50,770 14.68% 01-210-52-00-5224 VISION INSURANCE 1,042 1,042 7,080 14.72% Contractual Services 01-210-54-00-5410 TUITION REIMBURSEMENT - - 17,272 0.00% 01-210-54-00-5411 POLICE COMMISSION 405 405 4,000 10.13% 01-210-54-00-5412 TRAINING & CONFERENCES 249 249 21,000 1.19% 01-210-54-00-5415 TRAVEL & LODGING - - 10,000 0.00% 01-210-54-00-5422 VEHICLE & EQUIPMENT CHARGEBACK 2,003 2,003 24,032 8.33% 01-210-54-00-5434 COMPUTER REPLACEMENT CHARGEBACK - - 4,301 0.00% 01-210-54-00-5430 PRINTING & DUPLICATING - - 4,500 0.00% 01-210-54-00-5440 TELECOMMUNICATIONS - - 40,000 0.00% 01-210-54-00-5452 POSTAGE & SHIPPING 46 46 1,600 2.89% 01-210-54-00-5460 DUES & SUBSCRIPTIONS 8,278 8,278 9,000 91.98% 01-210-54-00-5462 PROFESSIONAL SERVICES 14,562 14,562 30,000 48.54% 01-210-54-00-5467 ADJUDICATION SERVICES - - 20,000 0.00% 01-210-54-00-5469 NEW WORLD LIVE SCAN - - 2,000 0.00% 01-210-54-00-5472 KENDALL CO. JUVE PROBATION - - 4,000 0.00% 01-210-54-00-5485 RENTAL & LEASE PURCHASE 299 299 7,150 4.18% 01-210-54-00-5488 OFFICE CLEANING - - 11,758 0.00% 01-210-54-00-5495 OUTSIDE REPAIR & MAINTENANCE 1,931 1,931 60,000 3.22% Supplies 01-210-56-00-5600 WEARING APPAREL 2,128 2,128 15,000 14.18% 01-210-56-00-5610 OFFICE SUPPLIES - - 4,500 0.00% 01-210-56-00-5620 OPERATING SUPPLIES 40 40 16,000 0.25% 01-210-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE 3,441 3,441 12,500 27.53% 01-210-56-00-5650 COMMUNITY SERVICES - - 1,500 0.00% 01-210-56-00-5690 BALLISTIC VESTS - - 6,000 0.00% 01-210-56-00-5695 GASOLINE - - 63,000 0.00% 01-210-56-00-5696 AMMUNITION - - 10,000 0.00% TOTAL EXPENDITURES: POLICE 614,277 614,277 5,923,525 10.37% 4 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 COMMUNITY DEVELOPMENT EXPENDITURES Salaries & Wages 01-220-50-00-5010 SALARIES & WAGES 57,405 57,405 520,619 11.03% Benefits 01-220-52-00-5212 RETIREMENT PLAN CONTRIBUTION 5,228 5,228 47,763 10.95% 01-220-52-00-5214 FICA CONTRIBUTION 4,288 4,288 38,317 11.19% 01-220-52-00-5216 GROUP HEALTH INSURANCE 14,880 14,880 90,471 16.45% 01-220-52-00-5222 GROUP LIFE INSURANCE 36 36 429 8.34% 01-220-52-00-5223 DENTAL INSURANCE 1,175 1,175 6,603 17.80% 01-220-52-00-5224 VISION INSURANCE 180 180 1,009 17.85% Contractual Services 01-220-54-00-5412 TRAINING & CONFERENCES 350 350 7,300 4.79% 01-220-54-00-5415 TRAVEL & LODGING - - 6,500 0.00% 01-220-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - 1,323 0.00% 01-220-54-00-5426 PUBLISHING & ADVERTISING - - 2,500 0.00% 01-220-54-00-5430 PRINTING & DUPLICATING - - 1,500 0.00% 01-220-54-00-5440 TELECOMMUNICATIONS - - 4,000 0.00% 01-220-54-00-5452 POSTAGE & SHIPPING 53 53 1,000 5.27% 01-220-54-00-5459 INSPECTIONS - - 125,000 0.00% 01-220-54-00-5460 DUES & SUBSCRIPTIONS 1,089 1,089 2,750 39.60% 01-220-54-00-5462 PROFESSIONAL SERVICES - - 62,500 0.00% 01-220-54-00-5485 RENTAL & LEASE PURCHASE 189 189 3,150 6.00% Supplies 01-220-56-00-5610 OFFICE SUPPLIES - - 1,500 0.00% 01-220-56-00-5620 OPERATING SUPPLIES - - 3,750 0.00% 01-220-56-00-5695 GASOLINE - - 2,405 0.00% TOTAL EXPENDITURES: COMMUNITY DEVELP 84,873 84,873 930,389 9.12% PUBLIC WORKS - STREET OPERATIONS EXPENDITURES Salaries & Wages 01-410-50-00-5010 SALARIES & WAGES 39,406 39,406 402,421 9.79% 01-410-50-00-5015 PART-TIME SALARIES 240 240 12,500 1.92% 01-410-50-00-5020 OVERTIME - - 20,000 0.00% Benefits 01-410-52-00-5212 RETIREMENT PLAN CONTRIBUTION 3,570 3,570 38,754 9.21% 01-410-52-00-5214 FICA CONTRIBUTION 2,917 2,917 31,902 9.14% 01-410-52-00-5216 GROUP HEALTH INSURANCE 14,862 14,862 114,394 12.99% 01-410-52-00-5222 GROUP LIFE INSURANCE 25 25 437 5.64% 01-410-52-00-5223 DENTAL INSURANCE 1,003 1,003 7,363 13.62% 01-410-52-00-5224 VISION INSURNCE 140 140 1,065 13.10% 5 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 Contractual Services 01-410-54-00-5412 TRAINING & CONFERENCES 2,147 2,147 3,000 71.56% 01-410-54-00-5415 TRAVEL & LODGING - - 2,000 0.00% 01-410-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - 2,500 0.00% 01-410-54-00-5435 TRAFFIC SIGNAL MAINTENANCE - - 30,000 0.00% 01-410-54-00-5440 TELECOMMUNICATIONS - - 3,750 0.00% 01-410-54-00-5455 MOSQUITO CONTROL - - 6,281 0.00% 01-410-54-00-5458 TREE & STUMP MAINTENANCE - - 15,000 0.00% 01-410-54-00-5462 PROFESSIONAL SERVICES - - 6,825 0.00% 01-410-54-00-5483 JULIE SERVICES - - 3,000 0.00% 01-410-54-00-5485 RENTAL & LEASE PURCHASE 675 675 6,000 11.25% 01-410-54-00-5488 OFFICE CLEANING - - 1,051 0.00% 01-410-54-00-5490 VEHICLE MAINTENANCE SERVICES 45 45 65,000 0.07% Supplies 01-410-56-00-5600 WEARING APPAREL - - 5,100 0.00% 01-410-56-00-5618 SALT & CALCIUM CHLORIDE - - 157,500 0.00% 01-410-56-00-5620 OPERATING SUPPLIES 151 151 23,000 0.66% 01-410-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - - 30,000 0.00% 01-410-56-00-5630 SMALL TOOLS & EQUIPMENT - - 18,500 0.00% 01-410-56-00-5640 REPAIR & MAINTENANCE 129 129 25,000 0.52% 01-410-56-00-5642 STREET LIGHTING SUPLIES - - 17,000 0.00% 01-410-56-00-5665 JULIE SUPPLIES - - 1,200 0.00% 01-410-56-00-5695 GASOLINE 91 91 24,043 0.38% TOTAL EXP: PUBLIC WORKS - STREET OPS 65,400 65,400 1,074,586 6.09% PW - HEALTH & SANITATION EXPENDITURES Contractual Services 01-540-54-00-5441 GARBAGE SRVCS - SR SUBSIDY - - 34,081 0.00% 01-540-54-00-5442 GARBAGE SERVICES - - 1,200,294 0.00% 01-540-54-00-5443 LEAF PICKUP - - 7,000 0.00% TOTAL EXPENDITURES: HEALTH & SANITATION - - 1,241,375 0.00% ADMINISTRATIVE SERVICES EXPENDITURES Salaries & Wages 01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES - - 500 0.00% Benefits 01-640-52-00-5230 UNEMPLOYMENT INSURANCE 2,766 2,766 15,000 18.44% 01-640-52-00-5231 LIABILITY INSURANCE 69,817 69,817 316,374 22.07% 01-640-52-00-5240 RETIREES - GROUP HEALTH INS 9,032 9,032 47,796 18.90% 01-640-52-00-5241 RETIREES - DENTAL INSURANCE 1,210 1,210 449 269.59% 6 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 01-640-52-00-5242 RETIREES - VISION INSURANCE 213 213 80 265.73% Contractual Services 01-640-54-00-5418 PURCHASING SERVICES - - 50,465 0.00% 01-640-54-00-5423 IDOR ADMINISTRATION FEE 3,386 3,386 44,689 7.58% 01-640-54-00-5427 GC HOUSING RENTAL ASSISTANCE 1,268 1,268 7,800 16.26% 01-640-54-00-5428 UTILITY TAX REBATE - - 14,375 0.00% 01-640-54-00-5432 FACILITY MANAGEMENT SERVICES - - 57,425 0.00% 01-640-54-00-5439 AMUSEMENT TAX REBATE - - 60,000 0.00% 01-640-54-00-5449 KENCOM 11,653 11,653 126,109 9.24% 01-640-54-00-5450 INFORMATION TECH SRVCS 16,651 16,651 225,000 7.40% 01-640-54-00-5456 CORPORATE COUNSEL - - 115,000 0.00% 01-640-54-00-5461 LITIGATION COUNSEL - - 120,000 0.00% 01-640-54-00-5462 PROFESSIONAL SERVICES 523 523 27,000 1.94% 01-640-54-00-5463 SPECIAL COUNSEL - - 25,000 0.00% 01-640-54-00-5465 ENGINEERING SERVICES - - 390,000 0.00% 01-640-54-00-5473 KENDALL AREA TRANSIT - - 25,000 0.00% 01-640-54-00-5475 CABLE CONSORTIUM FEE - - 96,000 0.00% 01-640-54-00-5481 HOTEL TAX REBATES - - 72,000 0.00% 01-640-54-00-5486 ECONOMIC DEVELOPMENT 1,320 1,320 146,000 0.90% 01-640-54-00-5491 CITY PROPERTY TAX REBATE - - 1,500 0.00% 01-640-54-00-5492 SALES TAX REBATES - - 912,900 0.00% 01-640-54-00-5493 BUSINESS DISTRICT REBATES 29,461 29,461 421,088 7.00% 01-640-54-00-5494 ADMISSIONS TAX REBATE - - 140,000 0.00% 01-640-54-00-5499 BAD DEBT - - 2,000 0.00% Supplies 01-640-56-00-5625 REIMBURSEABLE REPAIRS - - 15,000 0.00% Other Financing Uses 01-640-99-00-9942 TRANSFER TO DEBT SERVICE 26,615 26,615 319,379 8.33% 01-640-99-00-9952 TRANSFER TO SEWER 47,919 47,919 575,030 8.33% 01-640-99-00-9979 TRANSFER TO PARKS & RECREATION 117,582 117,582 1,410,988 8.33% 01-640-99-00-9982 TRANSFER TO LIBRARY OPS 5,588 5,588 25,003 22.35% TOTAL EXPENDITURES: ADMIN SERVICES 345,005 345,005 5,804,950 5.94% TOTAL FUND REVENUES 1,372,293 1,372,293 16,469,238 8.33% TOTAL FUND EXPENDITURES 1,269,749 1,269,749 16,469,238 7.71% FUND SURPLUS (DEFICIT) 102,543 102,543 - 7 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 FOX HILL SSA REVENUES 11-000-40-00-4000 PROPERTY TAXES 1,142 1,142 13,381 8.53% TOTAL REVENUES: FOX HILL SSA 1,142 1,142 13,381 8.53% FOX HILL SSA EXPENDITURES 11-111-54-00-5462 PROFESSIONAL SERVICES - - 2,977 0.00% 11-111-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 28,000 0.00% TOTAL FUND REVENUES 1,142 1,142 13,381 8.53% TOTAL FUND EXPENDITURES - - 30,977 0.00% FUND SURPLUS (DEFICIT) 1,142 1,142 (17,596) SUNFLOWER SSA REVENUES 12-000-40-00-4000 PROPERTY TAXES 1,284 1,284 18,140 7.08% TOTAL REVENUES: SUNFLOWER SSA 1,284 1,284 18,140 7.08% SUNFLOWER SSA EXPENDITURES 12-112-54-00-5416 POND MAINTENANCE - - 5,000 0.00% 12-112-54-00-5462 PROFESSIONAL SERVICES - - 2,977 0.00% 12-112-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 6,000 0.00% TOTAL FUND REVENUES 1,284 1,284 18,140 7.08% TOTAL FUND EXPENDITURES - - 13,977 0.00% FUND SURPLUS (DEFICIT) 1,284 1,284 4,163 MOTOR FUEL TAX REVENUES 15-000-41-00-4112 MOTOR FUEL TAX 42,104 42,104 484,084 8.70% 15-000-41-00-4113 MFT HIGH GROWTH - - 41,000 0.00% 15-000-45-00-4500 INVESTMENT EARNINGS 1,360 1,360 9,820 13.85% TOTAL REVENUES: MOTOR FUEL TAX 43,464 43,464 534,904 8.13% MOTOR FUEL TAX EXPENDITURES Capital Outlay 15-155-60-00-6004 BASELINE ROAD BRIDGE REPAIRS - - 25,000 0.00% 15-155-60-00-6025 ROADS TO BETTER ROADS PROGRAM - - 620,000 0.00% 15-155-60-00-6079 ROUTE 47 EXPANSION 6,149 6,149 73,788 8.33% TOTAL FUND REVENUES 43,464 43,464 534,904 8.13% TOTAL FUND EXPENDITURES 6,149 6,149 718,788 0.86% FUND SURPLUS (DEFICIT) 37,315 37,315 (183,884) 8 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 CITY-WIDE CAPITAL REVENUES Licenses & Permits 23-000-42-00-4214 DEVELOPMENT FEES - - 5,000 0.00% 23-000-42-00-4218 DEVELOPMENT FEES - MUNICIPAL BLDG 3,259 3,259 47,180 6.91% 23-000-42-00-4222 ROAD CONTRIBUTION FEE 20,000 20,000 100,000 20.00% Charges for Service 23-000-44-00-4440 ROAD INFRASTRUCTURE FEES 610 610 746,500 0.08% Investment Earnings 23-000-45-00-4500 INVESTMENT EARNINGS 1,308 1,308 7,500 17.44% Reimbursements 23-000-46-00-4614 REIMB - BLACKBERRY WOODS - - 7,549 0.00% 23-000-46-00-4612 MILL ROAD IMPROVEMENTS - - 2,926,300 0.00% 23-000-46-00-4690 REIMB - MISCELLANEOUS - - 80,000 0.00% Other Financing Sources 23-000-48-00-4845 DONATIONS - - 2,000 0.00% TOTAL REVENUES: CITY-WIDE CAPITAL 25,177 25,177 3,922,029 0.64% CW MUNICIPAL BUILDING EXPENDITURES 23-216-54-00-5446 PROPERTY & BLDG MAINT SERVICES 576 576 225,000 0.26% 23-216-54-00-5482 STREET LIGHTING - - 102,820 0.00% 23-216-56-00-5619 SIGNS - - 15,000 0.00% 23-216-56-00-5626 HANGING BASKETS - - 2,000 0.00% 23-216-56-00-5656 PROPERTY & BLDG MAINT SUPPLIES 180 180 25,000 0.72% 23-216-60-00-6020 BUILDINGS & STRUCTURES - - 41,250 0.00% 23-216-99-00-9901 TRANSFER TO GENERAL - - 47,180 0.00% CITY-WIDE CAPITAL EXPENDITURES Contractual Services 23-230-54-00-546 PROFESSIONAL SERVICES - - 5,000 0.00% 23-230-54-00-5498 PAYING AGENT FEES - - 475 0.00% 23-230-54-00-5499 BAD DEBT - - 1,500 0.00% 23-230-60-00-6032 ASPHALT PATCHING - - 35,000 0.00% 23-230-56-00-5637 SIDEWALK CONSTRUCTION SUPPLIES - - 5,000 0.00% Capital Outlay 23-230-60-00-6012 MILL ROAD IMPROVEMENTS - - 3,105,000 0.00% 23-230-60-00-6014 BLACKBERRY WOODS SUBDIVISION - - 7,549 0.00% 23-230-60-00-6016 US34 (CENTER/ELDAMAIN RD) PROJECT - - 110,226 0.00% 23-230-60-00-6021 PAVILLION RD STREAMBANK STABILIZATION - - 137,500 0.00% 23-230-60-00-6025 ROAD TO BETTER ROADS PROGRAM - - 80,000 0.00% 23-230-60-00-6034 WHISPERING MEADOWS SUBDIVISION - - 22,500 0.00% 9 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 23-230-60-00-6058 RT71 ( RT47/ORCHARD RD) PROJECT - - 30,333 0.00% 23-230-60-00-6059 US RT34(IL47/ORCHARD RD)PROJECT - - 90,981 0.00% 23-230-60-00-6094 ITEP KENNEDY RD BIKE TRAIL - - 32,000 0.00% 2014A Bond 23-230-78-00-8000 PRINCIPAL PAYMENT - - 195,000 0.00% 23-230-78-00-8050 INTEREST PAYMENT 63,594 63,594 127,188 50.00% 23-230-99-00-9951 TRANSFER TO WATER 8,742 8,742 104,906 8.33% TOTAL FUND REVENUES 25,177 25,177 3,922,029 0.64% TOTAL FUND EXPENDITURES 73,091 73,091 4,548,408 1.61% FUND SURPLUS (DEFICIT)(47,914) (47,914) (626,379) VEHICLE & EQUIPMENT REVENUE Licenses & Permits 25-000-42-00-4215 DEVELOPMENT FEES - POLICE CAPITAL 6,300 6,300 30,000 21.00% 25-000-42-00-4217 WEATHER WARNING SIREN FEES 109 109 - 0.00% 25-000-42-00-4218 ENGINEERING CAPITAL FEE 1,900 1,900 10,000 19.00% 25-000-42-00-4219 DEVELOPMENT FEES - PW CAPITAL 14,900 14,900 64,500 23.10% 25-000-42-00-4220 DEVELOPMENT FEES - PARK CAPITAL 1,000 1,000 5,000 20.00% Fines & Forfeits 25-000-43-00-4315 DUI FINES 854 854 8,000 10.68% 25-000-43-00-4316 ELECTRONIC CITATION FEES 76 76 650 11.74% Charges for Service 25-000-44-00-4418 MOWING INCOME - - 2,000 0.00% 25-000-44-00-4420 POLICE CHARGEBACK 2,003 2,003 24,032 8.33% 25-000-44-00-4425 COMPUTER REPLACEMENT CHARGEBACKS - - 14,080 0.00% Investment Earnings 25-000-45-00-4522 INVESTMENT EARNINGS - PARKS 86 86 850 10.08% Miscellaneous - - 25-000-48-00-4854 MISC INCOME - PW CAPITAL - 2,000 0.00% TOTAL REVENUES: VEHICLE & EQUIPMENT 27,227 27,227 161,112 16.90% VEHICLE & EQUIPMENT EXPENDITURES POLICE CAPITAL EXPENDITURES Contractual Services 25-205-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 8,750 0.00% Capital Outlay 25-205-60-00-6060 EQUIPMENT - - 5,000 0.00% 25-205-60-00-6070 VEHICLES - - 55,000 0.00% TOTAL EXPENDITURES: POLICE CAPITAL - - 68,750 0.00% 10 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 GENERAL GOVERNMENT CAPITAL EXPENDITURES Contractual Services 25-212-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - - 14,080 0.00% TOTAL EXPENDITURES: GENERAL GOVERNMENT - - 14,080 0.00% PUBLIC WORKS CAPITAL EXPENDITURES Contractual Services 25-215-54-00-5448 FILING FEES - - 750 0.00% Supplies 25-215-56-00-5620 OPERATING SUPPLIES - - 2,000 0.00% Capital Outlay 25-215-60-00-6060 EQUIPMENT - - 7,000 0.00% 185 Wolf Street Building 25-215-92-00-8000 PRINCIPAL PAYMENT 3,604 3,604 44,429 8.11% 25-215-92-00-8050 INTEREST PAYMENT 2,689 2,689 31,095 8.65% TOTAL EXPENDITURES: PW CAPITAL 6,294 6,294 85,274 7.38% PARK & RECREATION CAPITAL EXPENDITURES Contractual Services 25-225-54-00-5495 OUTSDE REPAIR & MAINTENANCE - - 5,000 0.00% Capital Outlay 25-225-60-00-6060 EQUIPMENT - - 50,000 0.00% 25-225-60-00-6070 VEHICLES - - 70,000 0.00% 185 Wolf Street Building 25-225-92-00-8000 PRINCIPAL PAYMENT 113 113 1,392 8.11% 25-225-92-00-8050 INTEREST PAYMENT 84 84 974 8.65% TOTAL EXPENDITURES: PARK & REC CAPITAL 197 197 127,366 0.15% TOTAL FUND REVENUES 27,227 27,227 161,112 16.90% TOTAL FUND EXPENDITURES 6,491 6,491 295,470 2.20% FUND SURPLUS (DEFICIT) 20,736 20,736 (134,358) DEBT SERVICE REVENUES 42-000-42-00-4208 RECAPTURE FEES-WATER & SEWER 550 550 4,646 11.84% 42-000-49-00-4901 TRANSFER FROM GENERAL 26,615 26,615 319,379 8.33% TOTAL REVENUES: DEBT SERVICE 27,165 27,165 324,025 8.38% DEBT SERVICE EXPENDITURES 42-420-54-00-5498 PAYING AGENT FEES - - 475 0.00% 2014B Refunding Bond 42-420-79-00-8000 PRINCIPAL PAYMENT - - 290,000 0.00% 11 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 42-420-79-00-8050 INTEREST PAYMENT - - 33,550 0.00% TOTAL FUND REVENUES 27,165 27,165 324,025 8.38% TOTAL FUND EXPENDITURES - - 324,025 0.00% FUND SURPLUS (DEFICIT)27,165 27,165 - WATER FUND REVENUES Charges for Service 51-000-44-00-4424 WATER SALES 5,750 5,750 3,228,300 0.18% 51-000-44-00-4425 BULK WATER SALES - - 5,000 0.00% 51-000-44-00-4426 LATE PENALTIES - WATER 32 32 110,000 0.03% 51-000-44-00-4430 WATER METER SALES 17,755 17,755 60,000 29.59% 51-000-44-00-4440 WATER INFRASTRUCTURE FEE 610 610 768,000 0.08% 51-000-44-00-4450 WATER CONNECTION FEE 35,220 35,220 230,000 15.31% Investment Earnings 51-000-45-00-4500 INVESTMENT EARNINGS 1,619 1,619 23,851 6.79% Miscellaneous 51-000-46-00-4690 REIMB - MISCELLANEOUS - - - 0.00% 51-000-48-00-4820 RENTAL INCOME 10,982 10,982 95,749 11.47% 51-000-48-00-4850 MISCELLANEOUS INCOME 515 515 250 205.82% Other Financing Sources 51-000-49-00-4923 TRANSFER FROM CITY-WIDE CAPITAL 8,742 8,742 104,906 8.33% 51-000-49-00-4952 TRANSFER FROM SEWER 6,156 6,156 73,875 8.33% TOTAL REVENUES: WATER FUND 87,382 87,382 4,699,931 1.86% WATER OPERATIONS EXPENSES Salaries & Wages 51-510-50-00-5010 SALARIES & WAGES 39,899 39,899 477,935 8.35% 51-510-50-00-5015 PART-TIME SALARIES 1,440 1,440 30,000 4.80% 51-510-50-00-5020 OVERTIME 631 631 12,000 5.26% Benefits 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 3,686 3,686 44,948 8.20% 51-510-52-00-5214 FICA CONTRIBUTION 3,086 3,086 37,702 8.19% 51-510-52-00-5216 GROUP HEALTH INSURANCE 14,894 14,894 137,566 10.83% 51-510-52-00-5222 GROUP LIFE INSURANCE 36 36 560 6.51% 51-510-52-00-5223 DENTAL INSURANCE 1,126 1,126 9,354 12.04% 51-510-52-00-5224 VISION INSURANCE 165 165 1,344 12.28% 51-510-52-00-5230 UNEMPLOYMENT INSURANCE 272 272 2,000 13.62% 51-510-52-00-5231 LIABILITY INSURANCE 6,464 6,464 29,590 21.85% Contractual Services 51-510-54-00-5401 ADMINISTRATIVE CHARGEBACK 9,886 9,886 118,631 8.33% 12 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 51-510-54-00-5412 TRAINING & CONFERENCES 2,400 2,400 6,500 36.92% 51-510-54-00-5415 TRAVEL & LODGING - - 2,000 0.00% 51-510-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - 827 0.00% 51-510-54-00-5426 PUBLISHING & ADVERTISING - - 500 0.00% 51-510-54-00-5429 WATER SAMPLES - - 8,000 0.00% 51-510-54-00-5430 PRINTING & DUPLICATING 101 101 3,250 3.11% 51-510-54-00-5440 TELECOMMUNICATIONS - - 35,000 0.00% 51-510-54-00-5445 TREATMENT FACILITY SERVICES 16,217 16,217 145,000 11.18% 51-510-54-00-5448 FILING FEES 530 530 3,000 17.67% 51-510-54-00-5452 POSTAGE & SHIPPING 2,536 2,536 19,000 13.35% 51-510-54-00-5460 DUES & SUBSCRIPTIONS 567 567 1,800 31.48% 51-510-54-00-5462 PROFESSIONAL SERVICES 4,222 4,222 65,000 6.50% 51-510-54-00-5465 ENGINEERING SERVICES - - 37,500 0.00% 51-510-54-00-5480 UTILITIES - - 303,709 0.00% 51-510-54-00-5483 JULIE SERVICES - - 3,000 0.00% 51-510-54-00-5485 RENTAL & LEASE PURCHASE 45 45 1,700 2.63% 51-510-54-00-5488 OFFICE CLEANING - - 1,051 0.00% 51-510-54-00-5490 VEHICLE MAINTENANCE SERVICES - - 12,000 0.00% 51-510-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 25,000 0.00% 51-510-54-00-5498 PAYING AGENT FEES - - 1,750 0.00% 51-510-54-00-5499 BAD DEBT - - 10,000 0.00% Supplies 51-510-56-00-5600 WEARING APPAREL - - 5,100 0.00% 51-510-56-00-5620 OPERATING SUPPLIES 126 126 10,500 1.20% 51-510-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - - 2,500 0.00% 51-510-56-00-5630 SMALL TOOLS & EQUIPMENT 24 24 4,000 0.60% 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 7,019 7,019 218,438 3.21% 51-510-56-00-5640 REPAIR & MAINTENANCE - - 27,500 0.00% 51-510-56-00-5664 METERS & PARTS 1,876 1,876 100,000 1.88% 51-510-56-00-5665 JULIE SUPPLIES - - 1,200 0.00% 51-510-56-00-5695 GASOLINE 91 91 24,043 0.38% Capital Outlay 51-510-60-00-6022 WELL REHABILITATIONS - - 165,000 0.00% 51-510-60-00-6025 ROAD TO BETTER ROADS PROGRAM - - 569,000 0.00% 51-510-60-00-6059 US34 (IL RT47/ORCHARD) PROJECT - - 21,608 0.00% 51-510-60-00-6060 EQUIPMENT - - 400,000 0.00% 51-510-60-00-6066 RTE 71 WATERMAIN REPLACEMENT - - 42,166 0.00% 51-510-60-00-6079 ROUTE 47 EXPANSION 3,781 3,781 45,372 8.33% 13 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 51-510-60-00-6081 CATION EXCHANGE MEDIA REPLACEMENT - - 185,000 0.00% 2015A Bond 51-510-77-00-8000 PRINCIPAL PAYMENT - - 290,483 0.00% 51-510-77-00-8050 INTEREST PAYMENT 75,893 75,893 151,787 50.00% 2016 Refunding Bond 51-510-85-00-8000 PRINCIPAL PAYMENT - - 1,470,000 0.00% 51-510-85-00-8050 INTEREST PAYMENT - - 176,450 0.00% IEPA Loan L17-156300 51-510-89-00-8000 PRINCIPAL PAYMENT - - 104,423 0.00% 51-510-89-00-8050 INTEREST PAYMENT - - 20,607 0.00% 2014C Refunding Bond 51-510-94-00-8000 PRINCIPAL PAYMENT - - 125,000 0.00% 51-510-94-00-8050 INTEREST PAYMENT - - 22,750 0.00% TOTAL FUND REVENUES 87,382 87,382 4,699,931 1.86% TOTAL FUND EXPENSES 197,015 197,015 5,770,144 3.41% FUND SURPLUS (DEFICIT) (109,633) (109,633) (1,070,213) SEWER FUND REVENUES Charges for Service 52-000-44-00-4435 SEWER MAINTENANCE FEES 666 666 979,200 0.07% 52-000-44-00-4440 SEWER INFRASTRUCTURE FEE (220) (220) 370,000 -0.06% 52-000-44-00-4455 SW CONNECTION FEES - OPS 7,400 7,400 23,300 31.76% 52-000-44-00-4456 SW CONNECTION FEES - CAPITAL 21,600 21,600 180,000 12.00% 52-000-44-00-4462 LATE PENALTIES - SEWER 4 4 15,000 0.03% 52-000-44-00-4465 RIVER CROSSING FEES 300 300 - 0.00% Investment Earnings 52-000-45-00-4500 INVESTMENT EARNINGS 598 598 7,149 8.37% Other Financing Sources 52-000-46-00-4850 MISCELANEOUS INCOME 309 309 - 0.00% 52-000-49-00-4901 TRANSFER FROM GENERAL 47,919 47,919 575,030 8.33% TOTAL REVENUES: SEWER FUND 78,577 78,577 2,149,679 3.66% SEWER OPERATIONS EXPENSES Salaries & Wages 52-520-50-00-5010 SALARIES & WAGES 16,419 16,419 265,446 6.19% 52-520-50-00-5015 PART-TIME SALARIES 1,360 1,360 5,000 27.20% 52-520-50-00-5020 OVERTIME 47 47 500 9.39% Benefits 52-520-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,505 1,505 24,399 6.17% 52-520-52-00-5214 FICA CONTRIBUTION 1,304 1,304 19,031 6.85% 52-520-52-00-5216 GROUP HEALTH INSURANCE 9,127 9,127 98,202 9.29% 14 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 52-520-52-00-5222 GROUP LIFE INSURANCE 16 16 314 5.07% 52-520-52-00-5223 DENTAL INSURANCE 639 639 6,433 9.94% 52-520-52-00-5224 VISION INSURANCE 88 88 879 9.95% 52-520-52-00-5230 UNEMPLOYMENT INSURANCE 143 143 750 19.10% 52-520-52-00-5231 LIABILITY INSURANCE 3,133 3,133 14,052 22.29% Contractual Services 52-520-54-00-5401 ADMINISTRATIVE CHARGEBACK 3,558 3,558 42,696 8.33% 52-520-54-00-5412 TRAINING & CONFERENCES 707 707 2,500 28.27% 52-520-54-00-5415 TRAVEL & LODGING 2 2 2,000 0.11% 52-520-54-00-5430 PRINTING & DUPLICATING 47 47 1,500 3.15% 52-520-54-00-5440 TELECOMMUNICATIONS - - 9,000 0.00% 52-520-54-00-5444 LIFT STATION SERVICES 93 93 75,000 0.12% 52-520-54-00-5462 PROFESSIONAL SERVICES 1,060 1,060 43,000 2.47% 52-520-54-00-5480 UTILITIES - - 22,472 0.00% 52-520-54-00-5483 JULIE SERVICES - - 3,000 0.00% 52-520-54-00-5485 RENTAL & LEASE PURCHASE 45 45 1,000 4.47% 52-520-54-00-5488 OFFICE CLEANING - - 759 0.00% 52-520-54-00-5490 VEHICLE MAINTENANCE SERVICES 1,240 1,240 10,000 12.40% 52-520-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 16,000 0.00% 52-520-54-00-5498 PAYING AGENT FEES - - 750 0.00% 52-520-54-00-5499 BAD DEBT - - 3,000 0.00% Supplies 52-520-56-00-5600 WEARING APPAREL - - 3,980 0.00% 52-520-56-00-5610 OFFICE SUPPLIES - - 1,000 0.00% 52-520-56-00-5613 LIFT STATION MAINTENANCE - - 8,000 0.00% 52-520-56-00-5620 OPERATING SUPPLIES 248 248 9,000 2.75% 52-520-56-00-5628 VEHICLE MAINTENANCE SUPPLIES (105) (105) 10,000 -1.05% 52-520-56-00-5630 SMALL TOOLS & EQUIPMENT 59 59 2,000 2.95% 52-520-56-00-5640 REPAIR & MAINTENANCE - - 5,000 0.00% 52-520-56-00-5665 JULIE SUPPLIES - - 1,200 0.00% 52-520-56-00-5695 GASOLINE 91 91 22,470 0.40% Capital Outlay 52-520-60-00-6001 SCADA SYSTEM - - 67,000 0.00% 52-520-60-00-6025 ROAD TO BETTER ROADS PROGRAM - - 137,000 0.00% 52-520-60-00-6059 US34 (IL RT47/ORCHARD) PROJECT - - 11,373 0.00% 52-520-60-00-6066 RTE 71 SEWER MAIN REPLACEMENT - - 63,000 0.00% 52-520-60-00-6070 VEHICLES - - 50,000 0.00% 52-520-60-00-6079 ROUTE 47 EXPANSION 1,873 1,873 22,488 8.33% 15 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 Developer Commitments - Lennar 52-520-75-00-7500 LENNAR-RAINTREE SW RECAPTURE - - 30,721 0.00% 2003 IRBB Debt Certificates 52-520-90-00-8000 PRINCIPAL PAYMENT - - 135,000 0.00% 52-520-90-00-8050 INTEREST PAYMENT - - 29,668 0.00% 2011 Refunding Bond 52-520-92-00-8000 PRINCIPAL PAYMENT - - 845,000 0.00% 52-520-92-00-8050 INTEREST PAYMENT - - 289,114 0.00% IEPA Loan L17-115300 52-520-96-00-8000 PRINCIPAL PAYMENT - - 52,832 0.00% 52-520-96-00-8050 INTEREST PAYMENT - - 693 0.00% Other Financing Uses 52-520-99-00-9951 TRANSFER TO WATER 6,156 6,156 73,875 8.33% TOTAL FUND REVENUES 78,577 78,577 2,149,679 3.66% TOTAL FUND EXPENSES 48,856 48,856 2,538,097 1.92% FUND SURPLUS (DEFICIT) 29,721 29,721 (388,418) LAND CASH REVENUES 72-000-41-00-4186 OSLAD GRANT-BRISTOL BAY 400,000 400,000 - 0.00% 72-000-47-00-4703 AUTUMN CREEK 3,003 3,003 6,606 45.46% 72-000-47-00-4704 BLACKBERRY WOODS 568 568 15,909 3.57% 72-000-47-00-4706 CALEDONIA 1,007 1,007 16,341 6.16% 72-000-47-00-4708 COUNTRY HILLS 1,538 1,538 8,000 19.23% 72-000-47-00-4724 KENDALL MARKETPLACE - - 2,024 0.00% 72-000-47-00-4736 BRIARWOOD - - 9,555 0.00% TOTAL REVENUES: LAND CASH 406,116 406,116 58,435 694.99% LAND CASH EXPENDITURES 72-720-54-00-5485 RENTAL & LEASE PURCHASE - - 4,850 0.00% 72-720-60-00-6043 BRISTOL BAY REGIONAL PARK - - 25,000 0.00% 72-720-60-00-6045 RIVERFRONT PARK - - 50,000 0.00% 72-720-60-00-6067 BLACKBERRY CREEK NATURE PRESERVE - - 25,000 0.00% TOTAL FUND REVENUES 406,116 406,116 58,435 694.99% TOTAL FUND EXPENDITURES - - 104,850 0.00% FUND SURPLUS (DEFICIT) 406,116 406,116 (46,415) 16 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 PARK & RECREATION REVENUES Charges for Service 79-000-44-00-4402 SPECIAL EVENTS 22,500 22,500 90,000 25.00% 79-000-44-00-4403 CHILD DEVELOPMENT 14,922 14,922 145,000 10.29% 79-000-44-00-4404 ATHLETICS AND FITNESS 37,842 37,842 365,000 10.37% 79-000-44-00-4441 CONCESSION REVENUE 5,681 5,681 32,000 17.75% Investment Earnings 79-000-45-00-4500 INVESTMENT EARNINGS 126 126 1,500 8.39% Reimbursements 79-000-46-00-4690 REIMB - MISCELLANEOUS - - - 0.00% Miscellaneous 79-000-48-00-4820 RENTAL INCOME 48,650 48,650 54,500 89.27% 79-000-48-00-4825 PARK RENTALS 2,838 2,838 15,000 18.92% 79-000-48-00-4843 HOMETOWN DAYS 6,775 6,775 108,000 6.27% 79-000-48-00-4846 SPONSORSHIPS & DONATIONS 5,419 5,419 20,000 27.09% 79-000-48-00-4850 MISCELLANEOUS INCOME 1,182 1,182 3,000 39.40% Other Financing Sources 79-000-49-00-4901 TRANSFER FROM GENERAL 117,582 117,582 1,410,988 8.33% TOTAL REVENUES: PARK & RECREATION 263,516 263,516 2,244,988 11.74% PARKS DEPARTMENT EXPENDITURES Salaries & Wages 79-790-50-00-5010 SALARIES & WAGES 64,605 64,605 552,859 11.69% 79-790-50-00-5015 PART-TIME SALARIES 6,796 6,796 51,000 13.32% 79-790-50-00-5020 OVERTIME 73 73 5,000 1.46% Benefits 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 6,057 6,057 52,725 11.49% 79-790-52-00-5214 FICA CONTRIBUTION 5,328 5,328 44,715 11.91% 79-790-52-00-5216 GROUP HEALTH INSURANCE 29,685 29,685 153,747 19.31% 79-790-52-00-5222 GROUP LIFE INSURANCE 54 54 645 8.34% 79-790-52-00-5223 DENTAL INSURANCE 1,918 1,918 10,866 17.65% 79-790-52-00-5224 VISION INSURANCE 270 270 1,537 17.56% Contractual Services 79-790-54-00-5412 TRAINING & CONFERENCES 2,400 2,400 7,000 34.29% 79-790-54-00-5415 TRAVEL & LODGING - - 3,000 0.00% 79-790-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - 662 0.00% 79-790-54-00-5440 TELECOMMUNICATIONS - - 6,500 0.00% 79-790-54-00-5462 PROFESSIONAL SERVICES - - 9,400 0.00% 79-790-54-00-5466 LEGAL SERVICES - - 3,000 0.00% 79-790-54-00-5485 RENTAL & LEASE PURCHASE 95 95 2,500 3.78% 79-790-54-00-5488 OFFICE CLEANING - - 2,876 0.00% 17 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 79-790-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 50,000 0.00% Supplies 79-790-56-00-5600 WEARING APPAREL 305 305 6,220 4.91% 79-790-56-00-5620 OPERATING SUPPLIES 115 115 25,000 0.46% 79-790-56-00-5630 SMALL TOOLS & EQUIPMENT - - 6,000 0.00% 79-790-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - - 2,000 0.00% 79-790-56-00-5640 REPAIR & MAINTENANCE - - 126,000 0.00% 79-790-56-00-5695 GASOLINE - - 25,410 0.00% TOTAL EXPENDITURES: PARKS DEPT 117,698 117,698 1,148,662 10.25% RECREATION DEPARTMENT EXPENDITURES Salaries & Wages 79-795-50-00-5010 SALARIES & WAGES 40,742 40,742 359,002 11.35% 79-795-50-00-5015 PART-TIME SALARIES 1,559 1,559 41,000 3.80% 79-795-50-00-5045 CONCESSION WAGES 2,436 2,436 15,000 16.24% 79-795-50-00-5046 PRE-SCHOOL WAGES 4,141 4,141 40,000 10.35% 79-795-50-00-5052 INSTRUCTORS WAGES 4,051 4,051 40,000 10.13% Benefits 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION 3,833 3,833 37,514 10.22% 79-795-52-00-5214 FICA CONTRIBUTION 3,977 3,977 36,761 10.82% 79-795-52-00-5216 GROUP HEALTH INSURANCE 14,969 14,969 101,795 14.70% 79-795-52-00-5222 GROUP LIFE INSURANCE 37 37 440 8.34% 79-795-52-00-5223 DENTAL INSURANCE 1,090 1,090 6,539 16.67% 79-795-52-00-5224 VISION INSURANCE 158 158 948 16.66% Contractual Services 79-795-54-00-5410 TUITION RIMBURSEMENT - - 9,648 0.00% 79-795-54-00-5412 TRAINING & CONFERENCES - - 5,000 0.00% 79-795-54-00-5415 TRAVEL & LODGING - - 3,000 0.00% 79-795-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - 2,812 0.00% 79-795-54-00-5426 PUBLISHING & ADVERTISING - - 55,000 0.00% 79-795-54-00-5440 TELECOMMUNICATIONS - - 8,000 0.00% 79-795-54-00-5447 SCHOLARSHIPS - - 2,500 0.00% 79-795-54-00-5452 POSTAGE & SHIPPING 792 792 3,500 22.64% 79-795-54-00-5460 DUES & SUBSCRIPTIONS - - 3,000 0.00% 79-795-54-00-5462 PROFESSIONAL SERVICES 6,131 6,131 100,000 6.13% 79-795-54-00-5480 UTILITIES - - 14,292 0.00% 79-795-54-00-5485 RENTAL & LEASE PURCHASE 135 135 3,000 4.49% 79-795-54-00-5488 OFFICE CLEANING - - 3,992 0.00% 79-795-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 3,000 0.00% 18 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 Supplies 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 10,800 10,800 100,000 10.80% 79-795-56-00-5606 PROGRAM SUPPLIES 8,633 8,633 160,000 5.40% 79-795-56-00-5607 CONCESSION SUPPLIES 114 114 18,000 0.63% 79-795-56-00-5610 OFFICE SUPPLIES - - 3,000 0.00% 79-795-56-00-5620 OPERATING SUPPLIES - - 15,000 0.00% 79-795-56-00-5640 REPAIR & MAINTENANCE 36 36 2,000 1.78% 79-795-56-00-5695 GASOLINE - - 1,000 0.00% TOTAL EXPENDITURES: RECREATION DEPT 103,632 103,632 1,194,743 8.67% TOTAL FUND REVENUES 263,516 263,516 2,244,988 11.74% TOTAL FUND EXPENDITURES 221,330 221,330 2,343,405 9.44% FUND SURPLUS (DEFICIT)42,186 42,186 (98,417) LIBRARY OPERATIONS REVENUES Taxes 82-000-40-00-4000 PROPERTY TAXES 58,036 58,036 699,220 8.30% 82-000-40-00-4083 PROPERTY TAXES-DEBT SERVICE 65,634 65,634 793,028 8.28% Intergovernmental 82-000-41-00-4120 PERSONAL PROPERTY TAX 1,460 1,460 5,250 27.81% 82-000-41-00-4170 STATE GRANTS - - 20,000 0.00% Fines & Forfeits 82-000-43-00-4330 LIBRARY FINES 434 434 8,500 5.10% Charges for Service 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 1,193 1,193 8,000 14.91% 82-000-44-00-4422 COPY FEES 294 294 3,750 7.84% Investment Earnings 82-000-45-00-4500 INVESTMENT EARNINGS 735 735 10,000 7.35% Miscellaneous 82-000-48-00-4820 RENTAL INCOME 200 200 2,000 10.00% 82-000-48-00-4850 MISCELLANEOUS INCOME 1,981 1,981 2,000 99.07% Other Financing Sources 82-000-49-00-4901 TRANSFER FROM GENERAL 5,588 5,588 25,003 22.35% TOTAL REVENUES: LIBRARY 135,555 135,555 1,576,751 8.60% LIBRARY OPERATIONS EXPENDITURES Salaries & Wages 82-820-50-00-5010 SALARIES & WAGES 30,988 30,988 278,394 11.13% 82-820-50-00-5015 PART-TIME SALARIES 19,549 19,549 196,000 9.97% Benefits 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 2,821 2,821 25,541 11.05% 82-820-52-00-5214 FICA CONTRIBUTION 3,804 3,804 35,544 10.70% 19 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 82-820-52-00-5216 GROUP HEALTH INSURANCE 11,099 11,099 81,184 13.67% 82-820-52-00-5222 GROUP LIFE INSURANCE 31 31 387 7.97% 82-820-52-00-5223 DENTAL INSURANCE 1,165 1,165 6,987 16.67% 82-820-52-00-5224 VISION INSURANCE 169 169 1,012 16.67% 82-820-52-00-5230 UNEMPLOYMENT INSURANCE 172 172 750 22.94% 82-820-52-00-5231 LIABILITY INSURANCE 5,416 5,416 24,253 22.33% Contractual Services 82-820-54-00-5412 TRAINING & CONFERENCES - - 2,000 0.00% 82-820-54-00-5415 TRAVEL & LODGING - - 1,500 0.00% 82-820-54-00-5426 PUBLISHING & ADVERTISING - - 2,000 0.00% 82-820-54-00-5440 TELECOMMUNICATIONS - - 6,000 0.00% 82-820-54-00-5452 POSTAGE & SHIPPING - - 750 0.00% 82-820-54-00-5460 DUES & SUBSCRIPTIONS 1,533 1,533 11,000 13.94% 82-820-54-00-5462 PROFESSIONAL SERVICES 4,059 4,059 40,000 10.15% 82-820-54-00-5466 LEGAL SERVICES - - 3,000 0.00% 82-820-54-00-5468 AUTOMATION 2,249 2,249 20,000 11.24% 82-820-54-00-5480 UTILITIES - - 11,130 0.00% 82-820-54-00-5495 OUTSIDE REPAIR & MAINTENANCE 248 248 50,000 0.50% 82-820-54-00-5498 PAYING AGENT FEES - - 1,700 0.00% Supplies 82-820-56-00-5610 OFFICE SUPPLIES - - 8,000 0.00% 82-820-56-00-5620 OPERATING SUPPLIES - - 3,000 0.00% 82-820-56-00-5621 CUSTODIAL SUPPLIES - - 8,000 0.00% 82-820-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - - 2,000 0.00% 82-820-56-00-5671 LIBRARY PROGRAMMING - - 1,000 0.00% 82-820-56-00-5675 EMPLOYEE RECOGNITION - - 200 0.00% 82-820-56-00-5685 DVD'S - - 500 0.00% 82-820-56-00-5686 BOOKS - - 1,500 0.00% 2006 Bond 82-820-84-00-8000 PRINCIPAL PAYMENT - - 50,000 0.00% 82-820-84-00-8050 INTEREST PAYMENT - - 22,613 0.00% 2013 Refunding Bond 82-820-99-00-8000 PRINCIPAL PAYMENT - - 585,000 0.00% 82-820-99-00-8050 INTEREST PAYMENT - - 139,400 0.00% TOTAL FUND REVENUES 135,555 135,555 1,576,751 8.60% TOTAL FUND EXPENDITURES 83,303 83,303 1,620,345 5.14% FUND SURPLUS (DEFICIT) 52,251 52,251 (43,594) 20 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 LIBRARY CAPITAL REVENUES 84-000-42-00-4214 DEVELOPMENT FEES 9,800 9,800 50,000 19.60% 84-000-45-00-4500 INVESTMENT EARNINGS 62 62 100 62.10% TOTAL REVENUES: LIBRARY CAPITAL 9,862 9,862 50,100 19.68% LIBRARY CAPITAL EXPENDITURES 84-840-54-00-5460 E-BOOK SUBSCRIPTIONS - - 3,500 0.00% 84-840-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - - 15,000 0.00% 84-840-56-00-5683 AUDIO BOOKS - - 3,500 0.00% 84-840-56-00-5684 COMPACT DISCS & OTHER MUSIC - - 500 0.00% 84-840-56-00-5685 DVD'S - - 3,000 0.00% 84-840-56-00-5686 BOOKS - - 50,000 0.00% TOTAL FUND REVENUES 9,862 9,862 50,100 19.68% TOTAL FUND EXPENDITURES - - 75,500 0.00% FUND SURPLUS (DEFICIT) 9,862 9,862 (25,400) COUNTRYSIDE TIF REVENUES 87-000-40-00-4000 PROPERTY TAXES 96 96 232,318 0.04% 87-000-48-00-4850 MISCELLANEOUS INCOME 0 0 - 0.00% TOTAL REVENUES: COUNTRYSIDE TIF 96 96 232,318 0.04% COUNTRYSIDE TIF EXPENDITURES Contractual Services 87-870-54-00-5401 ADMINISTRATIVE CHARGEBACK 939 939 11,263 8.33% 87-870-54-00-5425 TIF INCENTIVE PAYOUT - - 700,000 0.00% 87-870-54-00-5462 PROFESSIONAL SERVICES - - 2,000 0.00% 87-870-54-00-5498 PAYING AGENT FEES - - 700 0.00% 2015A Bond 87-870-77-00-8000 PRINCIPAL PAYMENT - - 104,517 0.00% 87-870-77-00-8050 INTEREST PAYMENT 27,307 27,307 54,613 50.00% 2014 Refunding Bond 87-870-93-00-8050 INTEREST PAYMENT 25,358 25,358 50,715 50.00% TOTAL FUND REVENUES 96 96 232,318 0.04% TOTAL FUND EXPENDITURES 53,603 53,603 923,808 5.80% FUND SURPLUS (DEFICIT) (53,507) (53,507) (691,490) 21 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended May 31, 2019 DOWNTOWN TIF REVENUES 88-000-40-00-4000 PROPERTY TAXES 8,667 8,667 80,000 10.83% TOTAL REVENUES: DOWNTOWN TIF 8,667 8,667 80,000 10.83% DOWNTOWN TIF EXPENDITURES Contractual Services 88-880-54-00-5401 ADMINISTRATIVE CHARGEBACK 2,687 2,687 32,246 8.33% 88-880-54-00-5425 TIF INCENTIVE PAYOUT -- 20,000 0.00% 88-880-54-00-5462 PROFESSIONAL SERVICES -- 1,000 0.00% 88-880-54-00-5466 LEGAL SERVICES -- 15,000 0.00% 88-880-54-00-5470 FACADE REHAB PROGRAM -- 25,000 0.00% Capital Outlay 88-880-60-00-6000 PROJECT COSTS -- 27,500 0.00% 88-880-60-00-6015 DOWNTOWN HILL -- 50,000 0.00% 88-880-60-00-6048 DOWNTOWN STREETSCAPE IMPROV -- 30,000 0.00% 88-880-60-00-6079 ROUTE 47 EXPANSION 624 624 7,488 8.33% FNBO Loan - 102 E Van Emmon Building 88-880-81-00-8000 PRINCIPAL PAYMENT -- 200,000 0.00% 88-880-81-00-8050 INTEREST PAYMENT -- 18,250 0.00% TOTAL FUND REVENUES 8,667 8,667 80,000 10.83% TOTAL FUND EXPENDITURES 3,311 3,311 426,484 0.78% FUND SURPLUS (DEFICIT)5,356 5,356 (346,484) DOWNTOWN TIF II REVENUES 89-000-40-00-4000 PROPERTY TAXES 2,001 2,001 - 0.00% TOTAL REVENUES: DOWNTOWN TIF II 2,001 2,001 - 0.00% DOWNTOWN TIF II EXPENDITURES 89-890-54-00-5466 LEGAL SERVICES -- 10,000 0.00% 89-890-54-00-5470 FACADE REHAB PROGRAM -- 25,000 0.00% TOTAL FUND REVENUES 2,001 2,001 - 0.00% TOTAL FUND EXPENDITURES -- 35,000 0.00% FUND SURPLUS (DEFICIT)2,001 2,001 (35,000) 22 May YTD % of FY 2020 Actual Actual Budget Budget YTD Actual % Change GENERAL FUND (01) Revenues Local Taxes Property Taxes 266,903$ 266,903$ 8.3% 3,225,250$ 256,150$ 4.20% Municipal Sales Tax 211,897 211,897 6.7% 3,151,800 210,909 0.47% Non-Home Rule Sales Tax 157,270 157,270 6.5% 2,432,700 155,868 0.90% Electric Utility Tax - - 0.0%710,000 - 0.00% Natural Gas Tax 24,573 24,573 9.8%250,000 26,788 -8.27% Excise Tax 32,276 32,276 10.3%313,625 25,749 25.35% Telephone Utility Tax 695 695 8.3%8,340 695 0.00% Cable Franchise Fees 63,971 63,971 22.1%290,000 58,232 9.86% Hotel Tax 1,549 1,549 1.9% 80,000 6,737 -77.01% Video Gaming Tax 14,990 14,990 10.7%140,000 12,883 16.36% Amusement Tax 4,592 4,592 2.2%205,000 4,162 10.33% Admissions Tax - - 0.0%140,000 - 0.00% Business District Tax 43,699 43,699 10.2%427,500 28,365 54.06% Auto Rental Tax - - 0.0% 14,500 1,099 -100.00% Total Taxes 822,416$ 822,416$ 7.2% 11,388,715$ 787,637$ 4.42% Intergovernmental State Income Tax 381,988$ 381,988$ 19.9% 1,916,366$ 260,888$ 46.42% Local Use Tax 45,940 45,940 7.6%602,966 37,262 23.29% Road & Bridge Tax 10,903 10,903 8.4%130,000 11,492 -5.13% Personal Property Replacement Tax 4,406 4,406 25.9% 17,000 3,196 37.85% Other Intergovernmental - - 0.0% 36,900 1,217 -100.00% Total Intergovernmental 443,236$ 443,236$ 16.4% 2,703,232$ 314,055$ 41.13% Licenses & Permits Liquor Licenses 450$ 450$ 0.8% 56,000$ 700$ -35.71% Building Permits 46,319 46,319 13.2%350,000 42,238 9.66% Other Licenses & Permits 1,777 1,777 23.7%7,500 310 473.31% Total Licenses & Permits 48,546$ 48,546$ 11.7%413,500$ 43,248$ 12.25% Fines & Forfeits Circuit Court Fines 2,839$ 2,839$ 6.3% 45,000$ 3,988$ -28.81% Administrative Adjudication 1,471 1,471 4.9% 30,000 1,599 -8.01% Police Tows 2,500 2,500 5.0% 50,000 3,500 -28.57% Other Fines & Forfeits 35 35 8.8%400 45 -22.22% Total Fines & Forfeits 6,845$ 6,845$ 5.5%125,400$ 9,132$ -25.04% Charges for Services ^Garbage Surcharge 873$ 873$ 0.1% 1,224,875$ 144$ 506.33% ^Late PMT Penalties - Garbage 2 2 0.0% 21,000 13 -82.08% ^UB Collection Fees 16,638 16,638 10.1%165,000 16,131 3.15% Administrative Chargebacks 17,070 17,070 8.3%204,836 16,199 5.37% Other Services - - 0.0%500 - 0.00% Total Charges for Services 34,584$ 34,584$ 2.1% 1,616,211$ 32,487$ 6.45% Investment Earnings 11,033$ 11,033$ 13.8% 80,000$ 5,752$ 91.80% UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended May 31, 2019 * Fiscal Year 2019 For the Month Ended May 31, 2018 23 May YTD % of FY 2020 Actual Actual Budget Budget YTD Actual % Change UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended May 31, 2019 * Fiscal Year 2019 For the Month Ended May 31, 2018 GENERAL FUND (01) (continued) Reimbursements/Miscellaneous/Transfers In Reimb - Engineering & Legal Expenses -$ -$ 0.0% 25,000$ 366$ -100.00% Other Reimbursements 296 296 0.6% 50,000 645 -54.06% Rental Income 500 500 7.1%7,000 545 -8.26% Miscellaneous Income & Transfers In 4,837 4,837 8.0% 60,180 - 0.00% Total Miscellaneous 5,633$ 5,633$ 4.0%142,180$ 1,556$ 262.02% Total Revenues and Transfers 1,372,293$ 1,372,293$ 8.3% 16,469,238$ 1,193,867$ 14.95% Expenditures Administration 111,331$ 111,331$ 11.6%962,572$ 90,926$ 22.44% 50 Salaries 66,606 66,606 11.1%600,095 52,972 25.74% 52 Benefits 32,411 32,411 14.7%220,528 28,999 11.77% 54 Contractual Services 12,174 12,174 9.2%131,949 8,955 35.95% 56 Supplies 140 140 1.4% 10,000 - 0.00% Finance 48,863$ 48,863$ 9.2%531,841$ 38,749$ 26.10% 50 Salaries 31,356 31,356 10.4%301,372 22,730 37.95% 52 Benefits 14,813 14,813 12.4%119,719 13,383 10.68% 54 Contractual Services 2,694 2,694 2.5%108,250 2,636 2.21% 56 Supplies - - 0.0%2,500 - 0.00% Police 614,277$ 614,277$ 10.4%5,923,525$ 450,791$ 36.27% Salaries 336,944 336,944 10.4% 3,238,248 219,223 53.70% Overtime 10,944 10,944 9.9%111,000 4,538 141.16% 52 Benefits 233,007 233,007 10.7% 2,175,164 217,873 6.95% 54 Contractual Services 27,773 27,773 10.3%270,613 8,557 224.57% 56 Supplies 5,608 5,608 4.4%128,500 600 834.71% Community Development 84,873$ 84,873$ 9.1%930,389$ 58,532$ 45.00% 50 Salaries 57,405 57,405 11.0%520,619 36,451 57.49% 52 Benefits 25,788 25,788 14.0%184,592 19,260 33.89% 54 Contractual Services 1,681 1,681 0.8%217,523 2,821 -40.42% 56 Supplies - - 0.0%7,655 - 0.00% PW - Street Ops & Sanitation 65,400$ 65,400$ 2.8%2,315,961$ 55,649$ 17.52% Salaries 39,646 39,646 9.6%414,921 27,772 42.76% Overtime - - 0.0% 20,000 - 0.00% 52 Benefits 22,516 22,516 11.6%193,915 25,825 -12.81% 54 Contractual Services 2,867 2,867 0.2% 1,385,782 1,305 119.66% 56 Supplies 371 371 0.1%301,343 747 -50.38% Administrative Services 345,005$ 345,005$ 5.9%5,804,950$ 361,785$ -4.64% 50 Salaries - - 0.0%500 - 0.00% 52 Benefits 83,038 83,038 21.9%379,699 82,545 0.60% 54 Contractual Services 64,262 64,262 2.1% 3,079,351 48,802 31.68% 56 Supplies - - 0.0% 15,000 - 0.00% 99 Transfers Out 197,705 197,705 8.5% 2,330,400 230,438 -14.20% Total Expenditures and Transfers 1,269,749$ 1,269,749$ 7.7% 16,469,238$ 1,056,432$ 20.19% Surplus(Deficit)102,543$ 102,543$ -$ 137,435$ ^modified accruals basis 50 50 24 May YTD % of FY 2020 Actual Actual Budget Budget YTD Actual % Change WATER FUND (51) Revenues ^ Water Sales 5,750$ 5,750$ 0.2% 3,228,300$ 2,072$ 177.53% ^ Water Infrastructure Fees 610 610 0.1%768,000 266 129.35% ^ Late Penalties 32 32 0.0%110,000 86 -63.06% Water Connection Fees 35,220 35,220 15.3%230,000 29,260 20.37% Bulk Water Sales - - 0.0% 5,000 - 0.00% Water Meter Sales 17,755 17,755 29.6% 60,000 13,985 26.96% Total Charges for Services 59,367$ 59,367$ 1.3% 4,401,300$ 45,669$ 29.99% BUILD Program -$ 0.0% -$ 5,845$ -100.00% Investment Earnings 1,619$ 1,619$ 6.8% 23,851$ 879$ 84.17% Reimbursements/Miscellaneous/Transfers In Reimbursements -$ -$ 0.0%-$ 93$ -100.00% Rental Income 10,982 10,982 11.5% 95,749 5,173 112.30% Miscellaneous Income & Transfers In 15,413 15,413 8.6%179,031 11,878 29.76% Total Miscellaneous 26,395$ 26,395$ 9.6%274,780$ 17,144$ 53.96% Total Revenues and Transfers 87,382$ 87,382$ 1.9% 4,699,931$ 69,537$ 25.66% Expenses Water Operations Salaries 41,339$ 41,339$ 8.1%507,935$ 32,023$ 29.09% Overtime 631 631 5.3% 12,000 507 24.44% 52 Benefits 29,730 29,730 11.3%263,064 35,284 -15.74% 54 Contractual Services 36,504 36,504 4.5%804,218 21,872 66.90% 56 Supplies 9,136 9,136 2.3%393,281 9,301 -1.78% 60 Capital Outlay 3,781$ 3,781$ 1,428,146$ 16,462$ -77.03% Well Rehabilitations - - 0.0% 165,000 Road to Better Roads Program - - 0.0% 569,000 US 34 Project (IL Rte 47 to Orchard)- - 0.0% 21,608 Route 71 Watermain Replacement - - 0.0% 42,166 Route 47 Expansion 3,781 3,781 8.3% 45,372 Cation Exhange Media Replacement - - 0.0% 185,000 Vehicles & Equipment - - 0.0% 400,000 Debt Service 75,893$ 75,892$ 2,361,500$ 78,247$ -3.01% 2015A Bond 75,893 75,892 17.2% 442,270 2016 Refunding Bond - - 0.0% 1,646,450 IEPA Loan L17-156300 - - 0.0% 125,030 2014C Refunding Bond - - 0.0% 147,750 Total Expenses 197,015$ 197,014$ 3.4% 5,770,144$ #193,696$ 1.71% Surplus(Deficit)(109,633)$ (109,632)$ (1,070,213)$ (124,159)$ ^modified accruals basis *May represents 8% of fiscal year 2020 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENSES AND TRANSFERS For the Month Ended May 31, 2019 * Fiscal Year 2019 For the Month Ended May 31, 2018 Charges for Services 89 50 6025 6059 6022 6066 6081 6079 6070 77 85 94 25 May YTD % of FY 2020 Actual Actual Budget Budget YTD Actual % Change SEWER FUND (52) Revenues ^Sewer Maintenance Fees 666$ 666$ 0.1%979,200$ 246$ 170.91% ^Sewer Infrastructure Fees (220) (220) -0.1%370,000 134 -263.87% River Crossing Fees 300 300 0.0% - - 0.00% ^Late Penalties 4 4 0.0% 23,300 18 -75.56% Sewer Connection Fees 29,000 29,000 14.9%195,000 10,508 175.98% Total Charges for Services 29,751$ 29,751$ 1.9% 1,567,500$ 10,906$ 172.80% BUILD Program -$ -$ 0.0% -$ 2,000$ -100.00% Investment Earnings 598$ 598$ 8.4% 7,149$ 3,500$ -82.91% Reimbursements/Miscellaneous/Transfers In Other Reimbursements -$ -$ 0.0%- -$ 0.00% Miscellaneous Income & Transfers In 48,228 48,228 8.4%575,030 71,392 -32.45% Total Miscellaneous 48,228$ 48,228$ 8.4%575,030$ 71,392$ -32.45% Total Revenues and Transfers 78,577$ 78,577$ 3.7% 2,149,679$ 87,798$ -10.50% Expenses Sewer Operations Salaries 17,779$ 17,779$ 6.6%270,446$ 17,900$ -0.67% Overtime 47 47 9.4%500 - 0.00% 52 Benefits 15,955 15,955 9.7%164,060 15,077 5.83% 54 Contractual Services 6,752 6,752 2.9%232,677 6,432 4.97% 56 Supplies 293 293 0.5% 62,650 96 205.16% 75 Developer Commitment - Lennar(Raintree)- - 0.0% 30,721 - 0.00% 60 Capital Outlay 1,873$ 1,873$ 350,861$ 4,918$ -61.91% SCADA - - 0.0% 67,000 Road to Better Roads Program - - 0.0% 137,000 US 34 Project (IL Rte 47 to Orchard)- - 0.0% 11,373 Route 71 Sewer Main Replacement - - 0.0%63,000 Vehicles - - 0.0%50,000 Route 47 Expansion 1,873 1,873 8.3% 22,488 Debt Service -$ -$ 1,352,307$ -$ 0.00% 2003 IRBB Debt Certificates - - 0.0% 164,668 2011 Refunding Bond - - 0.0% 1,134,114 IEPA Loan L17-115300 - - 0.0% 53,525 99 Transfers Out 6,156$ 6,156$ 8.3% 73,875$ 6,473$ -4.89% Total Expenses and Transfers 48,856$ 48,856$ 1.9% 2,538,097$ 50,896$ -4.01% Surplus(Deficit)29,721$ 29,721$ (388,418)$ 36,902$ ^modified accruals basis *May represents 8% of fiscal year 2020 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENSES AND TRANSFERS For the Month Ended May 31, 2019 * Fiscal Year 2019 For the Month Ended May 31, 2018 6070 Charges for Services 50 6001 6059 6066 6025 6079 90 92 96 26 May YTD % of FY 2020 Actual Actual Budget Budget YTD Actual % Change PARKS & RECREATION FUND (79) Revenues Charges for Services Special Events 22,500$ 22,500$ 25.0% 90,000$ 24,299$ -7.40% Child Development 14,922 14,922 10.3%145,000 16,375 -8.87% Athletics & Fitness 37,842 37,842 10.4%365,000 36,681 3.17% Concession Revenue 5,681 5,681 17.8% 32,000 4,837 17.44% Total Charges for Services 80,945$ 80,945$ 12.8%632,000$ 82,192$ -1.52% Investment Earnings 126$ 126$ 8.4%1,500$145$ -13.16% Reimbursements/Miscellaneous/Transfers In Reimbursements -$-$0.0%-$-$0.00% Rental Income 48,650 48,650 89.3% 54,500 47,558 2.30% Park Rentals 2,838 2,838 18.9% 15,000 1,671 69.83% Hometown Days 6,775 6,775 6.3%108,000 450 1405.56% Sponsorships & Donations 5,419 5,419 27.1% 20,000 7,648 -29.15% Miscellaneous Income & Transfers In 118,764 118,764 8.4% 1,413,988 106,226 11.80% Total Miscellaneous 182,446$ 182,446$ 11.3% 1,611,488$ 163,553$ 11.55% Total Revenues and Transfers 263,516$ 263,516$ 11.7% 2,244,988$ 245,890$ 7.17% Expenditures Parks Department 117,698$ 117,698$ 10.2%1,148,662$ 72,751$ 61.78% Salaries 71,401 71,401 11.8%603,859 40,530 76.17% Overtime 73 73 1.5%5,000 765 -90.48% 52 Benefits 43,310 43,310 16.4%264,235 31,279 38.46% 54 Contractual Services 2,495 2,495 2.9% 84,938 142 1656.73% 56 Supplies 420 420 0.2%190,630 35 1099.51% Recreation Department 103,632$ 103,632$ 8.7%1,194,743$ 65,974$ 57.08% 50 Salaries 52,928 52,928 10.7%495,002 34,223 54.66% 52 Benefits 24,062 24,062 13.1%183,997 20,758 15.92% 54 Contractual Services 7,058 7,058 3.3%216,744 2,176 224.38% 56 Hometown Days 10,800 10,800 10.8%100,000 5,149 109.75% 56 Supplies 8,783 8,783 4.4%199,000 3,668 139.44% Total Expenditures 221,330$ 221,330$ 9.4% 2,343,405$ 138,725$ 59.55% Surplus(Deficit)42,186$ 42,186$ (98,417)$ 107,165$ *May represents 8% of fiscal year 2020 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended May 31, 2019 * Fiscal Year 2019 For the Month Ended May 31, 2018 50 27 May YTD % of FY 2020 Actual Actual Budget Budget YTD Actual % Change LIBRARY OPERATIONS FUND (82) Revenues Property Taxes 123,669$ 123,669$ 8.3% 1,492,248$ 118,377$ 4.47% Intergovernmental Personal Property Replacement Tax 1,460$ 1,460$ 27.8%5,250$ 1,059$ 37.85% State Grants - - 0.0% 20,000 4,060.00 0.00% Total Intergovernmental 1,460$ 1,460$ 5.8% 25,250$ 5,119$ -71.48% Library Fines 434$ 434$ 5.1%8,500$ 569$ -23.71% Charges for Services Library Subscription Cards 1,193$ 1,193$ 14.9%8,000$ 1,114$ 7.06% Copy Fees 294 294 7.8%3,750 296 -0.63% Program Fees - - 0.0%- 1 -100.00% Total Charges for Services 1,487$ 1,487$ 12.7% 11,750$ 1,411$ 5.37% Investment Earnings 735$ 735$ 7.4% 10,000$ 291$ 152.60% Reimbursements/Miscellaneous/Transfers In Miscellaneous Reimbursements -$ -$ 0.0%-$ -$ 0.00% Rental Income 200 200 10.0%2,000 100 100.00% DVD Rental Income - - 0.0%0 271 632.20% Miscellaneous Income 1,981 1,981 99.1%2,000 2 279309.00% Transfer In 5,588 5,588 22.4% 25,003 5,438 2.77% Total Miscellaneous & Transfers 7,770$ 7,770$ 26.8% 29,003$ 5,810$ 33.72% Total Revenues and Transfers 135,555$ 135,555$ 8.6% 1,576,751$ 131,577$ 3.02% Expenditures Library Operations 83,303$ 83,303$ 5.1%1,620,345$ 58,360$ 42.74% 50 Salaries 50,537 50,537 10.7% 474,394 31,627 59.79% 52 Benefits 24,676 24,676 14.0% 175,658 21,221 16.28% 54 Contractual Services 8,090 8,090 5.4% 149,080 5,512 46.76% 56 Supplies - - 0.0% 24,200 - 0.00% 99 Transfers Out/Debt Service - - 0.0% 797,013 - 0.00% Total Expenditures and Transfers 83,303$ 83,303$ 5.1% 1,620,345$ 58,360$ 42.74% Surplus(Deficit)52,251$52,251$(43,594)$ 73,217$ *May represents 8% of fiscal year 2020 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended May 31, 2019 * Fiscal Year 2019 For the Month Ended May 31, 2018 28 DATE: 06/10/2019 UNITED CITY OF YORKVILLE PAGE: 1TIME: 09:56:06 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 01PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________01-110-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 AP-190525MB 05/14/2019 05 ICSC - PUBLIC INSTITUTION DUE FIRST NATIONAL BANK 900073 052519-B.OLSON-B 100.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 100.00 0.00 YTD BUDGET 1,000.00 TOTAL ACCOUNT ACTIVITY 100.00 0.00 ANNUAL REVISED BUDGET 12,000.00 ENDING BALANCE 100.00_____________________________________________________________________________________________________________________________________________________01-120-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 GJ-190530FE 06/03/2019 02 Analysis Charge Partial Refund 25.05 GJ-190531FE 05/21/2019 01 UB CC Fees - Apr 2019 523.95 05/21/2019 07 UB Paymentus Fees - Apr 2019 1,197.25 _________________________________ TOTAL PERIOD 01 ACTIVITY 1,721.20 25.05 YTD BUDGET 5,000.00 TOTAL ACCOUNT ACTIVITY 1,721.20 25.05 ANNUAL REVISED BUDGET 60,000.00 ENDING BALANCE 1,696.15_____________________________________________________________________________________________________________________________________________________01-210-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 AP-190514B 05/07/2019 24 LAW ENFORCEMENT MANUAL UPDATE LEXIPOL LLC 529815 28427 11,967.00 AP-190525MB 05/14/2019 10 ELINEUP-SOFTWARE MAINTENANCE FIRST NATIONAL BANK 900073 052519-N.DECKER-B 600.00 GJ-90520PRE 05/21/2019 26 ID Ntwrk-Live Scan Renewal 1,995.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 14,562.00 0.00 YTD BUDGET 2,500.00 TOTAL ACCOUNT ACTIVITY 14,562.00 0.00 ANNUAL REVISED BUDGET 30,000.00 ENDING BALANCE 14,562.00_____________________________________________________________________________________________________________________________________________________01-220-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 YTD BUDGET 5,208.34 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 62,500.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________01-410-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 YTD BUDGET 568.75 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 6,825.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________01-640-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 AP-190528B 05/21/2019 61 2018 DRAINAGE DISTRICT FEES KENDALL COUNTY COLLE 529899 2018DDF 522.92 _________________________________ TOTAL PERIOD 01 ACTIVITY 522.92 0.00 YTD BUDGET 2,250.00 TOTAL ACCOUNT ACTIVITY 522.92 0.00 ANNUAL REVISED BUDGET 27,000.00 ENDING BALANCE 522.92_____________________________________________________________________________________________________________________________________________________11-111-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 YTD BUDGET 248.09 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 2,977.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________12-112-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 YTD BUDGET 248.09 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 2,977.00 ENDING BALANCE 0.00 DATE: 06/10/2019 UNITED CITY OF YORKVILLE PAGE: 2TIME: 09:56:06 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 01PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________23-230-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 YTD BUDGET 416.67 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 5,000.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________25-205-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 YTD BUDGET 0.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 0.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________25-225-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 YTD BUDGET 0.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 0.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________51-510-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 AP-190528B 05/21/2019 77 ANNUAL SOFTWARE SUPPORT SENSUS USA, INC 529935 ZA19006900 1,949.94 GJ-190530FE 06/03/2019 04 Analysis Charge Partial Refund 33.57 GJ-190531FE 05/21/2019 03 UB CC Fees - Apr 2019 701.97 05/21/2019 09 UB Paymentus Fees - Apr 2019 1,604.02 _________________________________ TOTAL PERIOD 01 ACTIVITY 4,255.93 33.57 YTD BUDGET 5,416.67 TOTAL ACCOUNT ACTIVITY 4,255.93 33.57 ANNUAL REVISED BUDGET 65,000.00 ENDING BALANCE 4,222.36_____________________________________________________________________________________________________________________________________________________52-520-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 GJ-190530FE 06/03/2019 06 Analysis Charge Partial Refund 15.66 GJ-190531FE 05/21/2019 05 UB CC Fees - Apr 2019 327.45 05/21/2019 11 UB Paymentus Fees - Apr 2019 748.23 _________________________________ TOTAL PERIOD 01 ACTIVITY 1,075.68 15.66 YTD BUDGET 3,583.34 TOTAL ACCOUNT ACTIVITY 1,075.68 15.66 ANNUAL REVISED BUDGET 43,000.00 ENDING BALANCE 1,060.02_____________________________________________________________________________________________________________________________________________________79-790-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 YTD BUDGET 783.34 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 9,400.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 AP-190514B 05/07/2019 81 SUMMER & FALL 2019 USSSA HERB WIEGEL 529824 44 789.25 AP-190528B 05/21/2019 114 UMPIRE JUAN DANIEL AVILA 529869 050419 70.00 05/21/2019 115 UMPIRE MATT BENJAMIN 529871 050919 80.00 05/21/2019 116 UMPIRE DWAYNE F BEYER 529872 050919 80.00 05/21/2019 117 UMPIRE REBEKAH BOHYER 529874 5/3-5/13 40.00 05/21/2019 118 UMPIRE DONALD CZEPIEL 529879 5/3-5/13 55.00 05/21/2019 119 UMPIRE SARA R. EBNER 529884 5/3-5/13 140.00 05/21/2019 120 UMPIRE JOHN ELENBAAS 529885 050419 105.00 DATE: 06/10/2019 UNITED CITY OF YORKVILLE PAGE: 3TIME: 09:56:06 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 01PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 AP-190528B 05/21/2019 121 UMPIRE JAMIE ELENBAAS 529886 050919 35.00 05/21/2019 122 UMPIRE CONNER FOX 529888 5/3-5/13 65.00 05/21/2019 123 UMPIRE RICARDO GANTE 529891 051119 70.00 05/21/2019 124 UMPIRE JOSHUA HAVERNICK 529892 5/3-5/13 40.00 05/21/2019 125 UMPIRE ANDREW HETTINGER 529893 5/3-5/13 55.00 05/21/2019 126 UMPIRE MICHAEL HILKER 529894 5/3-5/13 20.00 05/21/2019 127 UMPIRE JAREK DANIEL HOTWANG 529895 5/3-5/13 55.00 05/21/2019 128 UMPIRE TY KUKIELKA 529902 5/3-5/13 110.00 05/21/2019 129 UMPIRE JOESEPH KWIATKOWSKI 529903 5/3-5/13 55.00 05/21/2019 130 UMPIRE MATTHEW J. LAWLESS 529904 050619 35.00 05/21/2019 131 UMPIRE OWEN LINDSTRAND 529907 5/3-5/13 100.00 05/21/2019 132 UMPIRE JACOB LIPSCOMB 529908 5/3-5/13 110.00 05/21/2019 133 UMPIRE JORDAN LONG 529909 5/3-5/13 35.00 05/21/2019 134 UMPIRE RAMIRO RENE MARTINEZ 529911 5/3-5/13 20.00 05/21/2019 135 UMPIRE DAVID TYLER MCCURDY 529912 5/3-5/13 140.00 05/21/2019 136 UMPIRE KYLE DEAN MCCURDY 529913 5/3-5/13 115.00 05/21/2019 137 UMPIRE ALEXIS MEYER 529915 5/3-5/13 20.00 05/21/2019 138 UMPIRE BRAD NEMSICK 529918 5/3-5/13 55.00 05/21/2019 139 2019 BASEBALL SCHEDULING FEE MARK PAWLOWSKI 529924 050919 195.00 05/21/2019 140 UMPIRE ROBERT L. RIETZ JR. 529931 050919 80.00 05/21/2019 141 UMPIRE KURTIS TYLER RYAN 529933 5/3-5/13 20.00 05/21/2019 142 UMPIRE TY JAMES SILAS 529937 05/3-05/13 260.00 05/21/2019 143 UMPIRE BEN STEMMET 529938 05/3-05/13 85.00 05/21/2019 144 UMPIRE ZANE STRIKE 529939 05/3-05/13 65.00 05/21/2019 145 UMPIRE PAUL TAEUBER 529940 051119 105.00 05/21/2019 146 UMPIRE NATHANIEL TAGGART 529941 5/3-5/13 55.00 05/21/2019 147 UMPIRE CHRISTOPHER D. TUTTL 529942 05/3-05/13 125.00 05/21/2019 148 UMPIRE JAEDON VAUGHN 529944 05/3-05/13 70.00 05/21/2019 149 UMPIRE IVAN WESTCOTT 529948 05/3-05/13 165.00 05/21/2019 150 UMPIRE HERB WIEGEL 529949 050919 80.00 05/21/2019 151 UMPIRE ALEXANDER VINCENZO W 529950 05/3-05/13 20.00 AP-190528PR 05/28/2019 01 UMPIRE REBEKAH BOHYER 529955 5/14-5/28 25.00 05/28/2019 02 UMPIRE JOSLYN T. BULLINGTON 529982 5/14-5/28 75.00 05/28/2019 03 UMPIRE CONNER FOX 529957 5/14-5/28 60.00 05/28/2019 04 UMPIRE SAM GOLINSKI 529958 5/14-5/28 55.00 05/28/2019 05 UMPIRE JOSHUA HAVERNICK 529959 5/14-5/28 45.00 05/28/2019 06 UMPIRE GEORGE A. JACOBO 529960 5/14-5/28 70.00 05/28/2019 07 UMPIRE ZACHARY STEVEN KAUS 5/14-5/28 20.00 05/28/2019 08 UMPIRE TY KUKIELKA 529962 5/14-5/28 95.00 05/28/2019 09 UMPIRE OWEN LINDSTRAND 529983 5/14-5/28 85.00 05/28/2019 10 UMPIRE JACOB LIPSCOMB 529964 5/14-5/28 55.00 05/28/2019 11 UMPIRE JORDAN LONG 529965 5/14-5/28 70.00 05/28/2019 12 UMPIRE RAMIRO RENE MARTINEZ 529966 5/14-5/28 25.00 05/28/2019 13 UMPIRE DAVID TYLER MCCURDY 529984 5/14-5/28 160.00 05/28/2019 14 UMPIRE KYLE DEAN MCCURDY 529985 5/14-5/28 150.00 05/28/2019 15 UMPIRE ALEXIS MEYER 529986 5/14-5/28 85.00 05/28/2019 16 UMPIRE ROBERT J. PAVLIK 529970 5/14-5/28 55.00 05/28/2019 17 UMPIRE MATTHEW L. RAMEY 529971 5/14-5/28 35.00 DATE: 06/10/2019 UNITED CITY OF YORKVILLE PAGE: 4TIME: 09:56:07 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 01PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 AP-190528PR 05/28/2019 18 UMPIRE KURTIS TYLER RYAN 529987 5/14-5/28 40.00 05/28/2019 19 UMPIRE JONATHAN SCHWEITZER 5/14-5/28 20.00 05/28/2019 20 UMPIRE TY JAMES SILAS 529988 5/14-5/28 90.00 05/28/2019 21 UMPIRE BEN STEMMET 529975 5/14-5/28 60.00 05/28/2019 22 UMPIRE ZANE STRIKE 529976 5/14-5/28 80.00 05/28/2019 23 UMPIRE CHRISTOPHER D. TUTTL 529977 5/14-5/28 40.00 05/28/2019 24 UMPRIE JAEDON VAUGHN 529989 5/14-5/28 40.00 05/28/2019 25 UMPIRE IVAN WESTCOTT 529990 5/14-5/28 50.00 05/28/2019 26 UMPIRE ALEXANDER VINCENZO W 529980 5/14-5/28 40.00 05/28/2019 27 UMPIRE ROYAL WOOLFOLK 5/14-5/28 55.00 AP-190528VD 05/29/2019 01 UMPIRE :VOID 529961 ZACHARY STEVEN KAUS 5/14-5/28 20.00 05/29/2019 02 UMPIRE :VOID 529973 JONATHAN SCHWEITZER 5/14-5/28 20.00 05/29/2019 03 UMPIRE :VOID 529981 ROYAL WOOLFOLK 5/14-5/28 55.00 AP-190529PR 05/29/2019 01 UMPIRE JOSLYN T. BULLINGTON 529982 5/14-5/28 40.00 05/29/2019 02 UMPIRE OWEN LINDSTRAND 529983 5/14-5/28 60.00 05/29/2019 03 UMPIRE DAVID TYLER MCCURDY 529984 5/14-5/28 90.00 05/29/2019 04 UMPIRE KYLE DEAN MCCURDY 529985 5/14-5/28 110.00 05/29/2019 05 UMPIRE ALEXIS MEYER 529986 5/14-5/28 60.00 05/29/2019 06 UMPIRE KURTIS TYLER RYAN 529987 5/14-5/28 20.00 05/29/2019 07 UMPIRE TY JAMES SILAS 529988 5/14-5/28 55.00 05/29/2019 08 UMPRIE JAEDON VAUGHN 529989 5/14-5/28 20.00 05/29/2019 09 UMPIRE IVAN WESTCOTT 529990 5/14-5/28 50.00 GJ-190531FE 05/21/2019 13 PR CC Fees - Apr 2019 997.07 AP-90528VD2 05/29/2019 01 UMPIRE :VOID 529956 JOSLYN T. BULLINGTON 529982 5/14-5/28 75.00 05/29/2019 02 UMPIRE :VOID 529963 OWEN LINDSTRAND 529983 5/14-5/28 85.00 05/29/2019 03 UMPIRE :VOID 529967 DAVID TYLER MCCURDY 529984 5/14-5/28 160.00 05/29/2019 04 UMPIRE :VOID 529968 KYLE DEAN MCCURDY 529985 5/14-5/28 150.00 05/29/2019 05 UMPIRE :VOID 529969 ALEXIS MEYER 529986 5/14-5/28 85.00 05/29/2019 06 UMPIRE :VOID 529972 KURTIS TYLER RYAN 529987 5/14-5/28 40.00 05/29/2019 07 UMPIRE :VOID 529974 TY JAMES SILAS 529988 5/14-5/28 90.00 05/29/2019 08 UMPRIE :VOID 529978 JAEDON VAUGHN 529989 5/14-5/28 40.00 05/29/2019 09 UMPIRE :VOID 529979 IVAN WESTCOTT 529990 5/14-5/28 50.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 7,001.32 870.00 YTD BUDGET 8,333.34 TOTAL ACCOUNT ACTIVITY 7,001.32 870.00 ANNUAL REVISED BUDGET 100,000.00 ENDING BALANCE 6,131.32_____________________________________________________________________________________________________________________________________________________82-820-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 AP-190513B 05/06/2019 07 MAY 2019 COPIER LEASE DLL FINANCIAL SERVIC 104704 63218016 194.48 05/06/2019 08 MAINTENANCE CONTRACT CHARGE SOUND INCORPORATED 104709 R161038 929.52 05/06/2019 09 06/278/19-06/26/20 ANNUAL TODAY'S BUSINESS SOL 104711 9268 2,644.00 AP-190528B 05/21/2019 162 JUN 2019 COPIER LEASE DLL FINANCIAL SERVIC 529882 63564126 194.48 GJ-90520PRE 05/21/2019 54 Sound Inc May 2019 Srvc Agrmnt 97.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 4,059.48 0.00 YTD BUDGET 3,333.34 TOTAL ACCOUNT ACTIVITY 4,059.48 0.00 ANNUAL REVISED BUDGET 40,000.00 ENDING BALANCE 4,059.48_____________________________________________________________________________________________________________________________________________________87-870-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 YTD BUDGET 166.67 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 2,000.00 ENDING BALANCE 0.00 DATE: 06/10/2019 UNITED CITY OF YORKVILLE PAGE: 5TIME: 09:56:07 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 01PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________88-880-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 YTD BUDGET 83.34 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 1,000.00 ENDING BALANCE 0.00 GRAND TOTAL 32,354.25 0.00 TOTAL DIFFERENCE 32,354.25 0.00 Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #2 Tracking Number ADM 2019-26 Monthly Treasurer’s Report for May 2019 Administration Committee – June 19, 2019 Majority Approval Rob Fredrickson Finance Name Department May Revenues YTD Revenues Revenue Budget % of Budget May Expenses YTD Expenses Expense Budget % of Budget General Fund01 - General 1,372,293$ 1,372,293$ 16,469,238$ 8% 1,269,749$ 1,269,749$ 16,469,238$ 8%Special Revenue Funds15 - Motor Fuel Tax 43,464 43,464 534,904 8% 6,149 6,149 718,788 1%79 - Parks and Recreation 263,516 263,516 2,244,988 12% 221,330 221,330 2,343,405 9%72 - Land Cash 406,116 406,116 58,435 695% - - 104,850 0%87 - Countryside TIF 96 96 232,318 0% 53,603 53,603 923,808 6%88 - Downtown TIF 8,667 8,667 80,000 11% 3,311 3,311 426,484 1%89 - Downtown TIF II 2,001 2,001 - 0% - - 35,000 0%11 - Fox Hill SSA 1,142 1,142 13,381 9% - - 30,977 0%12 - Sunflower SSA 1,284 1,284 18,140 7% - - 13,977 0%Debt Service Fund42 - Debt Service 27,165 27,165 324,025 8% - - 324,025 0%Capital Project Funds25 - Vehicle & Equipment 27,227 27,227 161,112 17% 6,491 6,491 295,470 2%23 - City-Wide Capital 25,177 25,177 3,922,029 1% 73,091 73,091 4,548,408 2%Enterprise Funds *51 - Water87,382 87,382 4,699,931 2% 197,015 197,015 5,770,144 3%*52 - Sewer78,577 78,577 2,149,679 4% 48,856 48,856 2,538,097 2%Library Funds82 - Library Operations 135,555 135,555 1,576,751 9% 83,303 83,303 1,620,345 5%84 - Library Capital 9,862 9,862 50,100 20% - - 75,500 0%Total Funds 2,489,523$ 2,489,523$ 32,535,031$ 8% 1,962,898$ 1,962,898$ 36,238,516$ 5%* Fund Balance EquivalencyRob Fredrickson, Finance Director/TreasurerUNITED CITY OF YORKVILLE TREASURER'S REPORT - for the month ending May 31, 2019Cash BasisAs Treasurer of the United City of Yorkville, I hereby attest, to the best of my knowledge, that the information contained in this Treasurer's Report is accurate as of the date detailed herein. Further information is available in the Finance Department. Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #3 Tracking Number ADM 2019-27 Cash Statement for April 2019 Administration Committee – June 19, 2019 Informational None Rob Fredrickson Finance Name Department GrandRestricted atFirst National West Suburban Associated Illinois Funds Old SecondTotalsIMETGeneral Fund01 - General 1,345,248 239,083 1,886,605 2,289,777 - 5,760,713 82,415 Special Revenue Funds15 - Motor Fuel Tax - - - 627,307 - 627,307 - 72 - Land Cash (506,373) - - - - (506,373) - 87 - Countryside TIF (422,459) - - - - (422,459) - 88 - Downtown TIF (929,896) - - - - (929,896) - 89 - Downtown TIF II (2,575) - - - - (2,575) - 11 - Fox Hill SSA 11,666 - - - - 11,666 - 12 - Sunflower SSA (18,720) - - - - (18,720) - Debt Service Fund42 - Debt Service 2,944 - - - - 2,944 - Capital Project Funds23 - City-Wide Capital 303,719 - 684,280 - - 987,999 103,868 25 - Police Capital 80,124 - - - - 80,124 - 25 - Public Works Capital73,425 - - - - 73,425 - Enterprise Funds51 - Water1,489,749 501,649 847,144 - - 2,838,543 13,808 52 - Sewer428,386 163,239 313,009 - - 904,634 64,896 Agency Funds90 - Developer Escrow 192,405 - - - - 192,405 - 95 - Escrow Deposit30,643 411,207 - - - 441,850 - Total City Funds2,078,287 1,315,178 3,731,038 2,917,084 - 10,041,587 264,987 Distribution %20.70% 13.10% 37.16% 29.05%Library Funds82 - Library Operations54 - - 211,154 431,427 642,634 8,007 84 - Library Capital5,300 - - - 91,413 96,713 - Library Totals 5,354 - - 211,154 522,840 739,347 8,007 Distribution % 0.72% 28.56% 70.72%Park and Recreation Funds79 - Parks and Recreation 637,919 - - - - 637,919 - 25 - Park & Rec Capital405,998 - - - - 405,998 2,371 Park & Rec Totals 1,043,917 - - - - 1,043,917 2,371 Distribution % 100.00%UNITED CITY OF YORKVILLECASH AND INVESTMENT SUMMARY - as of April 30, 2019Cash Summary 1 FinancialAccrued Type of Investment Institution FDIC # Interest Rate Original Cost Maturity Date Interest to Date Value at Maturity FundCertificate of Deposit (CD) Bank OZK 110 2.50% 246,900$ 6/17/2019 2,228$ 249,938$ General (01)Certificate of Deposit (CD)Pacific Western Bank24045 2.49% 246,900$ 8/28/2019 1,010$ 249,930$ General (01)Certificate of Deposit (CD) Servisfirst Bank 57993 2.41% 247,000$ 9/30/2019 457$ 249,930$ General (01)740,800$ 3,695$ 749,799$ UNITED CITY OF YORKVILLECASH AND INVESTMENT SUMMARY - as of April 30, 2019Investments Summary Investment Totals2 Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #4 Tracking Number ADM 2019-28 Monthly Website Report for May 2019 Administration Committee – June 19, 2019 Informational None. See attached memo. Erin Willrett Administration Name Department Summary Yorkville’s website and social media analytics report for May 2019. Background Every month at the Administration Committee meeting, the website data from the previous month will be highlighted. This month’s highlight is May 1, 2019 – May 31, 2019. Website Visits:  May  2018   June  2018  July  2018  Aug  2018  Sept  2018  Oct  2018  Nov  2018  Dec  2018  Jan  2019  Feb  2019  March 2019  April  2019  May  2019  Unique  Visitors 13,285 17,085 17,085 17,304 13,355 11,767 11,767 8,087 10,376 9,678 11,781 13,911 13,163  Returning  Visits 5,444 7,472 7,472 8,400 7,297 6,028 4,833 3,597 4,826 4,546 5,134 7,223 6,377  Total Visits 16,573 21,962 21,962 22,488 17,460 15,172 9,862 9,965 13,237 12,233 14,775 18,271 17,219  Visit Times (Averages):  2 minutes 56 second average visit duration  3 actions (page views, downloads, outlinks and internal site searches) per visit 0 5,000 10,000 15,000 20,000 25,000 Total  Visits Total Visits Memorandum To: Administration Committee From: Erin Willrett, Assistant Administrator CC: Bart Olson, City Administrator Date: June 17, 2019 Subject: Website Report for May 2019 Website Statistics: March 2019 April 2019 May 2019i Top 5 Pages Visited 1.Homepage 2. Parks and Recreation Main Page 3. St. Patrick’s Day Celebration 4. My GovHub 5. Job Opportunities 1.Homepage 2. City Elections 3. Parks and Recreation Main Page 4. White Goods/Bulk Items 5. Online Utility Payments 1.Homepage 2. Parks and Recreation Main Page 3. Facilities Feature Overview 4. Online Utility Payments 5. My Gov Hub March 2019 April 2019 May 2019ii Top 5 Downloads 1. St. Patrick’s Day Parade 2.St. Patrick’s Day Event Schedule 3. 2019 Election Information 4.Comprehensive Plan 5. Application for Employment 1. 2019 Tournament Registration Form 2. Privacy Policy 3. 2019 Election Information 4.Comprehensive Plan 5. Ward 1 Map 1. Privacy Policy 2. Residential Permit Application 3. Fence Permit Application 4.Board and Commission Application 5. 50/50 Parkway Tree Program March 2019 April 2019 May 2019 Top 5 Searches 1. Jobs (Employment was 2nd, Employment Opportunities was 4th, Careers was 6th) 2. True 3. Garbage 4. Farmer’s Market 5. Old Jail 1. True 2. Garbage 3. Mayor 4. Employment (Jobs was 5th) 5. Baseball 1. Jobs (Employment was 4th, Employment Opportunities was 6th) 2. Solicitor 3. True 4. Baseball 5. Garbage March 2019 April 2019 May 2019 Top 5 Website Referrers 1. Facebook 2.patch.com 3.r.search.aol.com 4.search.xfinity.com 5.www.landmarks.org 1. Facebook 2.wspynews.com 3.r.search.aol.com 4.gis.co.kendall.il.us 5.start.att.net 1. Facebook 2.wspynews.com 3.www.stcharlescanoeclub .com 4.r.search.aol.com 5.www.bandsintown.com City Facebook Data: May 2019 Total Page Followers: 4,902 (an increase of 87 followers from April) Total Page Likes: 4,794 Total Average Reach: 2,372 Highest Viewed Post: “IDOT US 34 Project Update…” (Date, May 31, 2019 at 11:23 am) Highest Viewed Post Reach: 6,038; 1,051 Post Clicks; 127 Reactions, Comments & Shares Parks and Recreation Facebook Data: May 2019 Total Page Followers: 2,704 (an increase of 39 followers from April) Total Page Likes: 2,683 Total Average Reach: 946 Highest Viewed Post: “National Take Your Parents to the Playground Day…” (Posted May 17, 2019, 2:35 pm) Highest Viewed Post Reach: 2,871; 212 Post Clicks; 68 Reactions, Comments & Shares City Twitter Data: May 2019 Total Followers: 1,566 (an increase in 12 followers from April) Total Tweet Impressions: 17,900 Total Profile Visits: 535 Yorkville Twitter Mentions: 15 Top Tweet (earned 702 Impressions): “Due to the storm, the City will be conducting a brush pick-up…” Recommendation: This is an informational item. ihttps://www.yorkville.il.us/; https://www.yorkville.il.us/259/Parks-Recreation; https://www.yorkville.il.us/facilities/featureoverview; https://www.yorkville.il.us/131/Online-Utility-Payments; https://www.yorkville.il.us/573/MyGovHub-Transition-Page ii https://www.yorkville.il.us/124/Privacy-Policy; https://www.yorkville.il.us/DocumentCenter/View/5804/Residential-Permit-Application-PDF?bidId=; https://www.yorkville.il.us/DocumentCenter/View/1345/Fence-Permit-App-PDF?bidId=; https://www.yorkville.il.us/DocumentCenter/View/179/Boards--Commissions-Application-PDF?bidId=; https://www.yorkville.il.us/DocumentCenter/View/2236/2016-50-50-Parkway-Tree-Program-Tree-Choices?bidId= Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #5 Tracking Number ADM 2019-29 Vehicle Replacement Chart Administration Committee – June 19, 2019 Informational None Rob Fredrickson Finance Name Department 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Police Department 55,000$ 616,068$ 298,241$ 222,580$ 202,161$ 196,109$ 196,109$ 203,798$ 209,908$ 214,738$ 215,423$ Community Development - 39,120 14,620 14,620 14,620 14,620 12,717 12,717 13,315 13,315 13,315 Streets - 2,110,208 943,366 632,267 594,082 548,740 497,002 476,608 477,877 482,671 484,981 Total General Fund 55,000$ 2,765,395$ 1,256,226$ 869,466$ 810,863$ 759,469$ 705,829$ 693,123$ 701,100$ 710,723$ 713,719$ Total Water Fund -$ 121,807$ 44,323$ 34,888$ 33,207$ 33,207$ 31,087$ 31,087$ 32,697$ 33,966$ 34,651$ Total Sewer Fund 48,892$ 43,046$ 43,046$ 18,758$ 18,758$ 18,758$ 18,758$ 19,782$ 19,782$ 19,782$ 21,547$ Parks 66,000$ 183,532$ 119,535$ 102,411$ 87,684$ 78,758$ 76,855$ 75,494$ 77,104$ 78,972$ 80,216$ Recreation 27,500 7,783 7,783 7,783 7,783 7,783 7,783 7,783 7,133 7,133 7,133 Total Parks & Rec Fund 93,500$ 191,315$ 127,318$ 110,194$ 95,467$ 86,541$ 84,638$ 83,277$ 84,237$ 86,105$ 87,349$ FISCAL YEAR Vehicle Chargeback Summary 1 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Estimated Useful Life Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback M 8 2016 Chevrolet Impala Sedan 2G1WA5E30G1161317 867920 89 14,374 Police Capital Chief -- 30,000$ 3,000$ 27,000$ -$ M 8.1 2025 Chevrolet Malibu Sedan Police Capital Chief 2025 4 32,473$ 3,247$ 29,226$ 7,306$ M 8.2 2033 Chevrolet Malibu Sedan Police Capital Chief 2033 8 38,047$ 3,805$ 34,243$ 4,280$ M 8.3 2041 Chevrolet Malibu Sedan Police Capital Chief 2041 8 44,578$ 4,458$ 40,121$ 5,015$ M 8.4 2049 Chevrolet Malibu Sedan Police Capital Chief 2049 8 52,231$ 5,223$ 47,008$ 5,876$ M 8.5 2057 Chevrolet Malibu Sedan Police Capital Chief 2057 8 61,197$ 6,120$ 55,077$ 6,885$ M 23 2018 Chevrolet Malibu Sedan 1G1ZBST1JF132097 M218935 109 4,830 Police Capital Deputy Chief -- 30,000$ 3,000$ 27,000$ -$ M 23.1 2027 Chevrolet Malibu Sedan Police Capital Deputy Chief 2027 6 37,466$ 3,840$ 33,626$ 5,604$ M 23.2 2035 Chevrolet Malibu Sedan Police Capital Deputy Chief 2035 8 47,960$ 4,916$ 43,044$ 5,380$ M 23.3 2043 Chevrolet Malibu Sedan Police Capital Deputy Chief 2043 8 61,392$ 6,293$ 55,100$ 6,887$ M 23.4 2051 Chevrolet Malibu Sedan Police Capital Deputy Chief 2051 8 78,587$ 8,055$ 70,532$ 8,817$ M 23.5 2059 Chevrolet Malibu Sedan Police Capital Deputy Chief 2059 8 100,598$ 10,311$ 90,287$ 11,286$ M 3 2016 Chevrolet Impala Sedan 2G1WA5E33G1160517 M208233 88 26,423 Police Capital Deputy Chief -- 30,000$ 3,000$ 27,000$ -$ M 3.1 2025 Chevrolet Malibu Sedan Police Capital Deputy Chief 2025 4 32,473$ 3,247$ 29,226$ 7,306$ M 3.2 2033 Chevrolet Malibu Sedan Police Capital Deputy Chief 2033 8 38,047$ 3,805$ 34,243$ 4,280$ M 3.3 2041 Chevrolet Malibu Sedan Police Capital Deputy Chief 2041 8 44,578$ 4,458$ 40,121$ 5,015$ M 3.4 2049 Chevrolet Malibu Sedan Police Capital Deputy Chief 2049 8 52,231$ 5,223$ 47,008$ 5,876$ M 3.5 2057 Chevrolet Malibu Sedan Police Capital Deputy Chief 2057 8 61,197$ 6,120$ 55,077$ 6,885$ M 4 2003 Chevrolet Yukon SUV 2G1WA5E33G1160517 M208233 88 26,423 Police Capital Detective -- 30,000$ 3,000$ 27,000$ -$ M 4.1 2021 Chevrolet Malibu Sedan Police Capital Detective 2021 1 30,000$ 3,000$ 27,000$ 27,000$ M 4.2 2028 Chevrolet Malibu Sedan Police Capital Detective 2028 7 34,461$ 3,446$ 31,015$ 4,431$ M 4.3 2035 Chevrolet Malibu Sedan Police Capital Detective 2035 7 39,584$ 3,958$ 35,626$ 5,089$ M 4.4 2042 Chevrolet Malibu Sedan Police Capital Detective 2042 7 45,470$ 4,547$ 40,923$ 5,846$ M 4.5 2049 Chevrolet Malibu Sedan Police Capital Detective 2049 7 52,231$ 5,223$ 47,008$ 6,715$ M 17 2016 Chevrolet Impala Sedan 2G1WD5E33G1158872 MP13889 92 17,057 Police Capital Detective -- 30,000$ 3,000$ 27,000$ -$ M 17.1 2023 Chevrolet Malibu Sedan Police Capital Detective 2023 2 31,212$ 3,121$ 28,091$ 14,045$ M 17.2 2030 Chevrolet Malibu Sedan Police Capital Detective 2030 7 35,853$ 3,585$ 32,267$ 4,610$ M 17.3 2037 Chevrolet Malibu Sedan Police Capital Detective 2037 7 41,184$ 4,118$ 37,065$ 5,295$ M 17.4 2044 Chevrolet Malibu Sedan Police Capital Detective 2044 7 47,307$ 4,731$ 42,576$ 6,082$ M 17.5 2051 Chevrolet Malibu Sedan Police Capital Detective 2051 7 54,341$ 5,434$ 48,907$ 6,987$ M 15 2014 Chevy Caprice Sedan 6G3NS5U23EL973259 MP11082 83 103,885 Police Capital Detective -- 30,000$ 3,000$ 27,000$ -$ M 15.1 2022 Chevrolet Malibu Sedan Police Capital Detective 2022 1 30,000$ 3,000$ 27,000$ 27,000$ M 15.2 2029 Chevrolet Malibu Sedan Police Capital Detective 2029 7 34,461$ 3,446$ 31,015$ 4,431$ M 15.3 2036 Chevrolet Malibu Sedan Police Capital Detective 2036 7 39,584$ 3,958$ 35,626$ 5,089$ M 15.4 2043 Chevrolet Malibu Sedan Police Capital Detective 2043 7 45,470$ 4,547$ 40,923$ 5,846$ M 15.5 2050 Chevrolet Malibu Sedan Police Capital Detective 2050 7 52,231$ 5,223$ 47,008$ 6,715$ Vehicle # Vehicle Replacement Chargeback Schedule - Police Capital (Police Department) Police Chief Deputy Police Chiefs Police Detectives 2 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Estimated Useful Life Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual ChargebackVehicle # Vehicle Replacement Chargeback Schedule - Police Capital (Police Department) M 1 2016 Chevrolet Impala Sedan 2G1WD5E33G1156250 MP15247 101 25,033 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 1.1 2023 Chevrolet Yukon SUV Police Capital Patrol 2023 2 67,626$ 8,323$ 59,303$ 29,651$ M 1.2 2028 Chevrolet Yukon SUV Police Capital Patrol 2028 5 74,665$ 9,189$ 65,475$ 13,095$ M 1.3 2033 Chevrolet Yukon SUV Police Capital Patrol 2033 5 82,436$ 10,146$ 72,290$ 14,458$ M 1.4 2038 Chevrolet Yukon SUV Police Capital Patrol 2038 5 91,016$ 11,202$ 79,814$ 15,963$ M 1.5 2043 Chevrolet Yukon SUV Police Capital Patrol 2043 5 100,489$ 12,368$ 88,121$ 17,624$ M 5 2016 Chevrolet Impala Sedan 2G1WD5E36G1156162 MP13887 94 40,152 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 5.1 2022 Chevrolet Yukon SUV Police Capital Patrol 2022 1 66,300$ 8,160$ 58,140$ 58,140$ M 5.2 2027 Chevrolet Yukon SUV Police Capital Patrol 2027 5 73,201$ 9,009$ 64,191$ 12,838$ M 5.3 2032 Chevrolet Yukon SUV Police Capital Patrol 2032 5 80,819$ 9,947$ 70,872$ 14,174$ M 5.4 2037 Chevrolet Yukon SUV Police Capital Patrol 2037 5 89,231$ 10,982$ 78,249$ 15,650$ M 5.5 2042 Chevrolet Yukon SUV Police Capital Patrol 2042 5 98,518$ 12,125$ 86,393$ 17,279$ M 9 2016 Chevrolet Impala Sedan 2G1WD5E34G1157357 MP13890 93 39,579 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 9.1 2022 Chevrolet Yukon SUV Police Capital Patrol 2022 1 65,000$ 8,000$ 57,000$ 57,000$ M 9.2 2027 Chevrolet Yukon SUV Police Capital Patrol 2027 5 71,765$ 8,833$ 62,933$ 12,587$ M 9.3 2032 Chevrolet Yukon SUV Police Capital Patrol 2032 5 79,235$ 9,752$ 69,483$ 13,897$ M 9.4 2037 Chevrolet Yukon SUV Police Capital Patrol 2037 5 87,481$ 10,767$ 76,714$ 15,343$ M 9.5 2042 Chevrolet Yukon SUV Police Capital Patrol 2042 5 96,587$ 11,888$ 84,699$ 16,940$ M 10 2016 Chevrolet Impala Sedan 2G1WD5E30G1155301 MP15245 100 21,774 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 10.1 2023 Chevrolet Yukon SUV Police Capital Patrol 2023 2 67,626$ 8,323$ 59,303$ 29,651$ M 10.2 2028 Chevrolet Yukon SUV Police Capital Patrol 2028 5 74,665$ 9,189$ 65,475$ 13,095$ M 10.3 2033 Chevrolet Yukon SUV Police Capital Patrol 2033 5 82,436$ 10,146$ 72,290$ 14,458$ M 10.4 2038 Chevrolet Yukon SUV Police Capital Patrol 2038 5 91,016$ 11,202$ 79,814$ 15,963$ M 10.5 2043 Chevrolet Yukon SUV Police Capital Patrol 2043 5 100,489$ 12,368$ 88,121$ 17,624$ M 11 2016 Chevrolet Impala Sedan 2G1WD5E30G1155315 MP16617 105 2,110 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 11.1 2024 Chevrolet Yukon SUV Police Capital Patrol 2024 3 68,979$ 8,490$ 60,489$ 20,163$ M 11.2 2029 Chevrolet Yukon SUV Police Capital Patrol 2029 5 76,158$ 9,373$ 66,785$ 13,357$ M 11.3 2034 Chevrolet Yukon SUV Police Capital Patrol 2034 5 84,084$ 10,349$ 73,736$ 14,747$ M 11.4 2039 Chevrolet Yukon SUV Police Capital Patrol 2039 5 92,836$ 11,426$ 81,410$ 16,282$ M 11.5 2044 Chevrolet Yukon SUV Police Capital Patrol 2044 5 102,498$ 12,615$ 89,883$ 17,977$ M 19 2016 Chevrolet Impala Sedan 2G1WD5E33G1158158 MP13888 95 44,197 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 19.1 2022 Chevrolet Yukon SUV Police Capital Patrol 2022 1 66,300$ 8,160$ 58,140$ 58,140$ M 19.2 2027 Chevrolet Yukon SUV Police Capital Patrol 2027 5 73,201$ 9,009$ 64,191$ 12,838$ M 19.3 2032 Chevrolet Yukon SUV Police Capital Patrol 2032 5 80,819$ 9,947$ 70,872$ 14,174$ M 19.4 2037 Chevrolet Yukon SUV Police Capital Patrol 2037 5 89,231$ 10,982$ 78,249$ 15,650$ M 19.5 2042 Chevrolet Yukon SUV Police Capital Patrol 2042 5 98,518$ 12,125$ 86,393$ 17,279$ M 20 2016 Chevrolet Impala Sedan 2G1WD5E33G1154823 MP16618 104 3,493 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 20.1 2024 Chevrolet Yukon SUV Police Capital Patrol 2024 3 68,979$ 8,490$ 60,489$ 20,163$ M 20.2 2029 Chevrolet Yukon SUV Police Capital Patrol 2029 5 76,158$ 9,373$ 66,785$ 13,357$ M 20.3 2034 Chevrolet Yukon SUV Police Capital Patrol 2034 5 84,084$ 10,349$ 73,736$ 14,747$ M 20.4 2039 Chevrolet Yukon SUV Police Capital Patrol 2039 5 92,836$ 11,426$ 81,410$ 16,282$ M 20.5 2044 Chevrolet Yukon SUV Police Capital Patrol 2044 5 102,498$ 12,615$ 89,883$ 17,977$ Patrol 3 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Estimated Useful Life Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual ChargebackVehicle # Vehicle Replacement Chargeback Schedule - Police Capital (Police Department) M 21 2016 Chevrolet Impala Sedan 2G1WD5E33G1150206 MP16619 103 2,362 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 21.1 2024 Chevrolet Yukon SUV Police Capital Patrol 2024 3 68,979$ 8,490$ 60,489$ 20,163$ M 21.2 2029 Chevrolet Yukon SUV Police Capital Patrol 2029 5 76,158$ 9,373$ 66,785$ 13,357$ M 21.3 2034 Chevrolet Yukon SUV Police Capital Patrol 2034 5 84,084$ 10,349$ 73,736$ 14,747$ M 21.4 2039 Chevrolet Yukon SUV Police Capital Patrol 2039 5 92,836$ 11,426$ 81,410$ 16,282$ M 21.5 2044 Chevrolet Yukon SUV Police Capital Patrol 2044 5 102,498$ 12,615$ 89,883$ 17,977$ M 13 2016 Chevrolet Impala Sedan 2G1WD5E31G1149006 MP15246 99 21,054 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 13.1 2023 Chevrolet Yukon SUV Police Capital Patrol 2023 2 67,626$ 8,323$ 59,303$ 29,651$ M 13.2 2028 Chevrolet Yukon SUV Police Capital Patrol 2028 5 74,665$ 9,189$ 65,475$ 13,095$ M 13.3 2033 Chevrolet Yukon SUV Police Capital Patrol 2033 5 82,436$ 10,146$ 72,290$ 14,458$ M 13.4 2038 Chevrolet Yukon SUV Police Capital Patrol 2038 5 91,016$ 11,202$ 79,814$ 15,963$ M 13.5 2043 Chevrolet Yukon SUV Police Capital Patrol 2043 5 100,489$ 12,368$ 88,121$ 17,624$ M 16 2015 Chevy Tahoe SUV 1GNSK2EC3FR725184 MP12713 80 62,939 Police Capital Sergeants -- 65,000$ 8,000$ 57,000$ -$ M 16.1 2022 Chevrolet Yukon SUV Police Capital Sergeants 2022 1 65,000$ 8,000$ 57,000$ 57,000$ M 16.2 2027 Chevrolet Yukon SUV Police Capital Sergeants 2027 5 71,765$ 8,833$ 62,933$ 12,587$ M 16.3 2032 Chevrolet Yukon SUV Police Capital Sergeants 2032 5 79,235$ 9,752$ 69,483$ 13,897$ M 16.4 2037 Chevrolet Yukon SUV Police Capital Sergeants 2037 5 87,481$ 10,767$ 76,714$ 15,343$ M 16.5 2042 Chevrolet Yukon SUV Police Capital Sergeants 2042 5 96,587$ 11,888$ 84,699$ 16,940$ M 18 2015 Chevy Tahoe SUV 1GNSK2ECOFR725210 MP12714 81 49,435 Police Capital Sergeants -- 65,000$ 8,000$ 57,000$ -$ M 18.1 2023 Chevrolet Yukon SUV Police Capital Sergeants 2023 2 67,626$ 8,323$ 59,303$ 29,651$ M 18.2 2028 Chevrolet Yukon SUV Police Capital Sergeants 2028 5 74,665$ 9,189$ 65,475$ 13,095$ M 18.3 2033 Chevrolet Yukon SUV Police Capital Sergeants 2033 5 82,436$ 10,146$ 72,290$ 14,458$ M 18.4 2038 Chevrolet Yukon SUV Police Capital Sergeants 2038 5 91,016$ 11,202$ 79,814$ 15,963$ M 18.5 2043 Chevrolet Yukon SUV Police Capital Sergeants 2043 5 100,489$ 12,368$ 88,121$ 17,624$ M 100 New SUV SUV ----Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 100.1 2021 Chevrolet Yukon SUV Police Capital Patrol 2021 1 65,000$ 8,000$ 57,000$ 57,000$ M 100.2 2026 Chevrolet Yukon SUV Police Capital Patrol 2026 5 71,765$ 8,833$ 62,933$ 12,587$ M 100.3 2031 Chevrolet Yukon SUV Police Capital Patrol 2031 5 79,235$ 9,752$ 69,483$ 13,897$ M 100.4 2036 Chevrolet Yukon SUV Police Capital Patrol 2036 5 87,481$ 10,767$ 76,714$ 15,343$ M 100.5 2041 Chevrolet Yukon SUV Police Capital Patrol 2041 5 96,587$ 11,888$ 84,699$ 16,940$ M 101 New SUV SUV ----Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 101.1 2021 Chevrolet Yukon SUV Police Capital Patrol 2021 1 65,000$ 8,000$ 57,000$ 57,000$ M 101.2 2026 Chevrolet Yukon SUV Police Capital Patrol 2026 5 71,765$ 8,833$ 62,933$ 12,587$ M 101.3 2031 Chevrolet Yukon SUV Police Capital Patrol 2031 5 79,235$ 9,752$ 69,483$ 13,897$ M 101.4 2036 Chevrolet Yukon SUV Police Capital Patrol 2036 5 87,481$ 10,767$ 76,714$ 15,343$ M 101.5 2041 Chevrolet Yukon SUV Police Capital Patrol 2041 5 96,587$ 11,888$ 84,699$ 16,940$ 4 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback CD 1 2007 Ford Explorer Pick-up 1FMEU73E47UB50282 M166523 2 58,279 Comm Dvlp Building -- 25,000$ 500$ 24,500$ -$ CD 1.1 2021 Ford 150 4x4 Pick-up Comm Dvlp Building 2021 1 25,000$ 500$ 24,500$ 24,500$ CD 1.2 2028 Ford 150 4x4 Pick-up Comm Dvlp Building 2028 7 28,717$ 574$ 28,143$ 4,020$ CD 1.3 2035 Ford 150 4x4 Pick-up Comm Dvlp Building 2035 7 32,987$ 660$ 32,327$ 4,618$ CD 1.4 2042 Ford 150 4x4 Pick-up Comm Dvlp Building 2042 7 37,892$ 758$ 37,134$ 5,305$ CD 1.5 2049 Ford 150 4x4 Pick-up Comm Dvlp Building 2049 7 43,526$ 871$ 42,655$ 6,094$ CD 2 2018 Ford F150 4x4 Pick-up 1FTNF1EG5JKF37470 M217881 106 1,882 Comm Dvlp Building -- 25,000$ 1,000$ 24,000$ -$ CD 2 2026 Ford F150 4x4 Pick-up Comm Dvlp Building 2026 5 27,602$ 1,104$ 26,498$ 5,300$ CD 2 2033 Ford F150 4x4 Pick-up Comm Dvlp Building 2033 7 31,706$ 1,268$ 30,438$ 4,348$ CD 2 2040 Ford F150 4x4 Pick-up Comm Dvlp Building 2040 7 36,420$ 1,457$ 34,963$ 4,995$ CD 2 2047 Ford F150 4x4 Pick-up Comm Dvlp Building 2047 7 41,835$ 1,673$ 40,162$ 5,737$ CD 2 2054 Ford F150 4x4 Pick-up Comm Dvlp Building 2054 7 48,056$ 1,922$ 46,134$ 6,591$ CD 3 2018 Ford F150 4x4 Pick-up 1FTMF1CB0JKF30476 M217880 107 3,627 Comm Dvlp Building -- 25,000$ 1,000$ 24,000$ -$ CD 3 2026 Ford F150 4x4 Pick-up Comm Dvlp Building 2026 5 27,602$ 1,104$ 26,498$ 5,300$ CD 3 2033 Ford F150 4x4 Pick-up Comm Dvlp Building 2033 7 31,706$ 1,268$ 30,438$ 4,348$ CD 3 2040 Ford F150 4x4 Pick-up Comm Dvlp Building 2040 7 36,420$ 1,457$ 34,963$ 4,995$ CD 3 2047 Ford F150 4x4 Pick-up Comm Dvlp Building 2047 7 41,835$ 1,673$ 40,162$ 5,737$ CD 3 2054 Ford F150 4x4 Pick-up Comm Dvlp Building 2054 7 48,056$ 1,922$ 46,134$ 6,591$ Vehicle Replacement Chargeback Schedule - Community Development (Building Department) Vehicle # 5 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback Y 30 2005 Ford F250 Pick-up 1FTSX21575EC28484 M151639 4 93,796 PW Capital Streets -- 55,000$ 3,000$ 52,000$ -$ Y 30.1 2021 Ford F 350 - w/plow Pick-up PW Capital Streets 2021 1 55,000$ 3,000$ 52,000$ 52,000$ Y 30.2 2028 Ford F 350 - w/plow Pick-up PW Capital Streets 2028 7 63,178$ 3,446$ 59,732$ 8,533$ Y 30.3 2035 Ford F 350 - w/plow Pick-up PW Capital Streets 2035 7 72,571$ 3,958$ 68,613$ 9,802$ Y 30.4 2042 Ford F 350 - w/plow Pick-up PW Capital Streets 2042 7 83,362$ 4,547$ 78,815$ 11,259$ Y 30.5 2049 Ford F 350 - w/plow Pick-up PW Capital Streets 2049 7 95,756$ 5,223$ 90,533$ 12,933$ Y 23 2006 International 7400 5 Yard 5 Yard 1HTWDAAN46J218804 M156008 54 30,971 PW Capital Streets -- 202,000$ 25,000$ 177,000$ -$ Y 23.1 2025 International 7400 5 Yard 5 Yard PW Capital Streets 2025 4 218,651$ 27,061$ 191,590$ 47,898$ Y 23.2 2035 International 7400 5 Yard 5 Yard PW Capital Streets 2035 10 266,535$ 32,987$ 233,548$ 23,355$ Y 23.3 2045 International 7400 5 Yard 5 Yard PW Capital Streets 2045 10 324,904$ 40,211$ 284,693$ 28,469$ Y 23.4 2055 International 7400 5 Yard 5 Yard PW Capital Streets 2055 10 396,057$ 49,017$ 347,040$ 34,704$ Y 23.5 2065 International 7400 5 Yard 5 Yard PW Capital Streets 2065 10 482,791$ 59,751$ 423,039$ 42,304$ Y 10 2004 International 7400 5 Yard 5 Yard 1HTWDAAR74J083169 M143323 64 29,210 PW Capital Streets -- 202,000$ 25,000$ 177,000$ -$ Y 10.1 2021 International 7400 5 Yard 5 Yard PW Capital Streets 2021 1 202,000$ 25,000$ 177,000$ 177,000$ Y 10.2 2031 International 7400 5 Yard 5 Yard PW Capital Streets 2031 10 246,237$ 30,475$ 215,762$ 21,576$ Y 10.3 2041 International 7400 5 Yard 5 Yard PW Capital Streets 2041 10 300,161$ 37,149$ 263,013$ 26,301$ Y 10.4 2051 International 7400 5 Yard 5 Yard PW Capital Streets 2051 10 365,895$ 45,284$ 320,611$ 32,061$ Y 10.5 2061 International 7400 5 Yard 5 Yard PW Capital Streets 2061 10 446,024$ 55,201$ 390,823$ 39,082$ Y TBD Peterbilt - with plow & spreader Dump TBD TBD TBD - PW Capital Streets -- 202,000$ -$ 202,000$ -$ Y TBD 2021 Peterbilt - with plow & spreader Dump PW Capital Streets 2021 1 202,000$ -$ 202,000$ 202,000$ Y TBD 2031 Peterbilt - with plow & spreader Dump PW Capital Streets 2031 10 246,237$ 30,475$ 215,762$ 21,576$ Y TBD 2041 Peterbilt - with plow & spreader Dump PW Capital Streets 2041 10 300,161$ 37,149$ 263,013$ 26,301$ Y TBD 2051 Peterbilt - with plow & spreader Dump PW Capital Streets 2051 10 365,895$ 45,284$ 320,611$ 32,061$ Y TBD 2061 Peterbilt - with plow & spreader Dump PW Capital Streets 2061 10 446,024$ 55,201$ 390,823$ 39,082$ Y 31 2007 Ford Explorer Pick-up 1FMEU73E27UB50281 M163944 3 75,698 PW Capital Streets -- 35,000$ 2,000$ 33,000$ -$ Y 31.1 2022 Ford F 250 with plow Pick-up PW Capital Streets 2022 1 35,000$ 2,000$ 33,000$ 33,000$ Y 31.2 2029 Ford F 250 with plow Pick-up PW Capital Streets 2029 7 40,204$ 2,297$ 37,907$ 5,415$ Y 31.3 2036 Ford F 250 with plow Pick-up PW Capital Streets 2036 7 46,182$ 2,639$ 43,543$ 6,220$ Y 31.4 2043 Ford F 250 with plow Pick-up PW Capital Streets 2043 7 53,048$ 3,031$ 50,017$ 7,145$ Y 31.5 2050 Ford F 250 with plow Pick-up PW Capital Streets 2050 7 60,936$ 3,482$ 57,454$ 8,208$ Y 26 2006 F550 Aerial Lift Truck Aerial 1FSAF57P56EC54524 M161896 41 67,587 PW Capital Streets -- 150,000$ 15,000$ 135,000$ -$ Y 26.1 2022 Aerial Lift Truck Aerial PW Capital Streets 2022 1 150,000$ 15,000$ 135,000$ 135,000$ Y 26.2 2029 Aerial Lift Truck Aerial PW Capital Streets 2029 7 172,303$ 17,230$ 155,073$ 22,153$ Y 26.3 2036 Aerial Lift Truck Aerial PW Capital Streets 2036 7 197,922$ 19,792$ 178,130$ 25,447$ Y 26.4 2043 Aerial Lift Truck Aerial PW Capital Streets 2043 7 227,350$ 22,735$ 204,615$ 29,231$ Y 26.5 2050 Aerial Lift Truck Aerial PW Capital Streets 2050 7 261,154$ 26,115$ 235,038$ 33,577$ Y 21 2005 Freightliner HC80 Dump 1FVAB6BV75DN04463 M151796 50 23,570 PW Capital Streets -- 250,000$ 30,000$ 220,000$ -$ Y 21.1 2022 Freightliner HC80 Dump PW Capital Streets 2022 1 250,000$ 30,000$ 220,000$ 220,000$ Y 21.2 2032 Freightliner HC80 Dump PW Capital Streets 2032 10 304,749$ 36,570$ 268,179$ 26,818$ Y 21.3 2042 Freightliner HC80 Dump PW Capital Streets 2042 10 371,487$ 44,578$ 326,908$ 32,691$ Y 21.4 2052 Freightliner HC80 Dump PW Capital Streets 2052 10 452,840$ 54,341$ 398,500$ 39,850$ Y 21.5 2062 Freightliner HC80 Dump PW Capital Streets 2062 10 552,010$ 66,241$ 485,769$ 48,577$ Y 19 2004 Ford F350 Pick-up 1FDWF37SX4ED64867 M150335 63 88,540 PW Capital Streets -- 35,000$ 6,500$ 28,500$ -$ Y 19.1 2022 Ford F350 Pick-up PW Capital Streets 2022 1 35,000$ 6,500$ 28,500$ 28,500$ Y 19.2 2029 Ford F350 Pick-up PW Capital Streets 2029 7 40,204$ 7,466$ 32,738$ 4,677$ Y 19.3 2036 Ford F350 Pick-up PW Capital Streets 2036 7 46,182$ 8,577$ 37,605$ 5,372$ Y 19.4 2043 Ford F350 Pick-up PW Capital Streets 2043 7 53,048$ 9,852$ 43,196$ 6,171$ Y 19.5 2050 Ford F350 Pick-up PW Capital Streets 2050 7 60,936$ 11,317$ 49,619$ 7,088$ Vehicle Replacement Chargeback Schedule - Public Works Capital (Street Department) Vehicle # 6 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback Vehicle Replacement Chargeback Schedule - Public Works Capital (Street Department) Vehicle # Y TBD Peterbilt - New Dump Truck Dump TBD TBD TBD - PW Capital Streets -- 205,000$ -$ 205,000$ -$ Y TBD 2022 Peterbilt - New Dump Truck Dump PW Capital Streets 2022 1 205,000$ -$ 205,000$ 205,000$ Y TBD 2032 Peterbilt - New Dump Truck Dump PW Capital Streets 2032 10 249,894$ 30,475$ 219,419$ 21,942$ Y TBD 2042 Peterbilt - New Dump Truck Dump PW Capital Streets 2042 10 304,619$ 37,149$ 267,471$ 26,747$ Y TBD 2052 Peterbilt - New Dump Truck Dump PW Capital Streets 2052 10 371,329$ 45,284$ 326,045$ 32,605$ Y TBD 2062 Peterbilt - New Dump Truck Dump PW Capital Streets 2062 10 452,648$ 55,201$ 397,447$ 39,745$ Y TBD Peterbilt - New Dump Truck Dump TBD TBD TBD - PW Capital Streets -- 205,000$ -$ 205,000$ -$ Y TBD 2022 Peterbilt - New Dump Truck Dump PW Capital Streets 2022 1 205,000$ -$ 205,000$ 205,000$ Y TBD 2032 Peterbilt - New Dump Truck Dump PW Capital Streets 2032 10 249,894$ 30,475$ 219,419$ 21,942$ Y TBD 2042 Peterbilt - New Dump Truck Dump PW Capital Streets 2042 10 304,619$ 37,149$ 267,471$ 26,747$ Y TBD 2052 Peterbilt - New Dump Truck Dump PW Capital Streets 2052 10 371,329$ 45,284$ 326,045$ 32,605$ Y TBD 2062 Peterbilt - New Dump Truck Dump PW Capital Streets 2062 10 452,648$ 55,201$ 397,447$ 39,745$ Y 25 2007 Ford 250 Pick-up 1FTNF21587EA47543 M160751 46 47,175 PW Capital Streets -- 35,000$ 3,500$ 31,500$ -$ Y 25.1 2023 Ford 250 Pick-up PW Capital Streets 2023 2 36,414$ 3,641$ 32,773$ 16,386$ Y 25.2 2030 Ford 250 Pick-up PW Capital Streets 2030 7 41,828$ 4,183$ 37,645$ 5,378$ Y 25.3 2037 Ford 250 Pick-up PW Capital Streets 2037 7 48,047$ 4,805$ 43,243$ 6,178$ Y 25.4 2044 Ford 250 Pick-up PW Capital Streets 2044 7 55,191$ 5,519$ 49,672$ 7,096$ Y 25.5 2051 Ford 250 Pick-up PW Capital Streets 2051 7 63,398$ 6,340$ 57,058$ 8,151$ Y 4 2008 Ford F350 Pick-up 1FDWF37Y08ED57176 M168872 49 69,798 PW Capital Streets -- 65,000$ 5,500$ 59,500$ -$ Y 4.1 2023 One Ton Dump Truck Dump PW Capital Streets 2023 2 67,626$ 5,722$ 61,904$ 30,952$ Y 4.2 2030 One Ton Dump Truck Dump PW Capital Streets 2030 7 77,681$ 6,573$ 71,108$ 10,158$ Y 4.3 2037 One Ton Dump Truck Dump PW Capital Streets 2037 7 89,231$ 7,550$ 81,681$ 11,669$ Y 4.4 2044 One Ton Dump Truck Dump PW Capital Streets 2044 7 102,498$ 8,673$ 93,826$ 13,404$ Y 4.5 2051 One Ton Dump Truck Dump PW Capital Streets 2051 7 117,739$ 9,962$ 107,776$ 15,397$ Y 13 2008 International 7400 5 Yard 5 Yard 1HTWDAAN48J648495 M170535 53 6,331 PW Capital Streets -- 425,000$ 35,000$ 390,000$ -$ Y 13.1 2023 International 7400 5 Yard 5 Yard PW Capital Streets 2023 2 442,170$ 36,414$ 405,756$ 202,878$ Y 13.2 2033 International 7400 5 Yard 5 Yard PW Capital Streets 2033 10 539,003$ 44,388$ 494,614$ 49,461$ Y 13.3 2043 International 7400 5 Yard 5 Yard PW Capital Streets 2043 10 657,041$ 54,109$ 602,932$ 60,293$ Y 13.4 2053 International 7400 5 Yard 5 Yard PW Capital Streets 2053 10 800,930$ 65,959$ 734,971$ 73,497$ Y 13.5 2063 International 7400 5 Yard 5 Yard PW Capital Streets 2063 10 976,329$ 80,404$ 895,925$ 89,593$ Y 27 2007 International 7400 5 Yard 5 Yard 1HTWDAAR37J429772 M161895 55 25,519 PW Capital Streets -- 185,000$ 25,000$ 160,000$ -$ Y 27.1 2023 International 7400 5 Yard 5 Yard PW Capital Streets 2023 2 192,474$ 26,010$ 166,464$ 83,232$ Y 27.2 2033 International 7400 5 Yard 5 Yard PW Capital Streets 2033 10 234,625$ 31,706$ 202,919$ 20,292$ Y 27.3 2043 International 7400 5 Yard 5 Yard PW Capital Streets 2043 10 286,006$ 38,649$ 247,357$ 24,736$ Y 27.4 2053 International 7400 5 Yard 5 Yard PW Capital Streets 2053 10 348,640$ 47,114$ 301,526$ 30,153$ Y 27.5 2063 International 7400 5 Yard 5 Yard PW Capital Streets 2063 10 424,990$ 57,431$ 367,559$ 36,756$ Y 28 2007 International 7400 5 Yard 5 Yard 1HTWDAAR17J429771 M161894 56 27,503 PW Capital Streets -- 185,000$ 25,000$ 160,000$ -$ Y 28.1 2023 International 7400 5 Yard 5 Yard PW Capital Streets 2023 2 192,474$ 26,010$ 166,464$ 83,232$ Y 28.2 2033 International 7400 5 Yard 5 Yard PW Capital Streets 2033 10 234,625$ 31,706$ 202,919$ 20,292$ Y 28.3 2043 International 7400 5 Yard 5 Yard PW Capital Streets 2043 10 286,006$ 38,649$ 247,357$ 24,736$ Y 28.4 2053 International 7400 5 Yard 5 Yard PW Capital Streets 2053 10 348,640$ 47,114$ 301,526$ 30,153$ Y 28.5 2063 International 7400 5 Yard 5 Yard PW Capital Streets 2063 10 424,990$ 57,431$ 367,559$ 36,756$ Y 9 2008 International 7400 six wheeler 6W 1HTWHAAR78J648496 M170083 57 55,242 PW Capital Streets -- 200,000$ 35,000$ 165,000$ -$ Y 9.1 2024 International 7400 six wheeler 6W PW Capital Streets 2024 3 212,242$ 37,142$ 175,099$ 58,366$ Y 9.2 2034 International 7400 six wheeler 6W PW Capital Streets 2034 10 258,721$ 45,276$ 213,445$ 21,345$ Y 9.3 2044 International 7400 six wheeler 6W PW Capital Streets 2044 10 315,380$ 55,191$ 260,188$ 26,019$ Y 9.4 2054 International 7400 six wheeler 6W PW Capital Streets 2054 10 384,446$ 67,278$ 317,168$ 31,717$ Y 9.5 2064 International 7400 six wheeler 6W PW Capital Streets 2064 10 468,638$ 82,012$ 386,626$ 38,663$ 7 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback Vehicle Replacement Chargeback Schedule - Public Works Capital (Street Department) Vehicle # Y 22 2006 International 7400 six wheeler 6W 1HTWHAAR36J218803 M156007 66 63,226 PW Capital Streets -- 200,000$ 50,000$ 150,000$ -$ Y 22.1 2025 International 7400 six wheeler 6W PW Capital Streets 2025 4 216,486$ 54,122$ 162,365$ 40,591$ Y 22.2 2035 International 7400 six wheeler 6W PW Capital Streets 2035 10 263,896$ 65,974$ 197,922$ 19,792$ Y 22.3 2045 International 7400 six wheeler 6W PW Capital Streets 2045 10 321,687$ 80,422$ 241,266$ 24,127$ Y 22.4 2055 International 7400 six wheeler 6W PW Capital Streets 2055 10 392,135$ 98,034$ 294,101$ 29,410$ Y 22.5 2065 International 7400 six wheeler 6W PW Capital Streets 2065 10 478,011$ 119,503$ 358,508$ 35,851$ Y 2 2015 Peterbilt Vac Con Vac Con 2NP3LJOX8FM266717 M200121 84 9,069 PW Capital Streets -- 450,000$ 50,000$ 400,000$ -$ Y 2.1 2026 Peterbilt Vac Con Vac Con PW Capital Streets 2026 5 496,836$ 55,204$ 441,632$ 88,326$ Y 2.2 2036 Peterbilt Vac Con Vac Con PW Capital Streets 2036 10 605,641$ 67,293$ 538,347$ 53,835$ Y 2.3 2046 Peterbilt Vac Con Vac Con PW Capital Streets 2046 10 738,273$ 82,030$ 656,242$ 65,624$ Y 2.4 2056 Peterbilt Vac Con Vac Con PW Capital Streets 2056 10 899,950$ 99,994$ 799,956$ 79,996$ Y 2.5 2066 Peterbilt Vac Con Vac Con PW Capital Streets 2066 10 1,097,034$ 121,893$ 975,142$ 97,514$ Y 0 2006 International Truck Dump 1HTWDAAN46J218804 M156008 54 - PW Capital Streets -- 225,000$ 25,000$ 200,000$ -$ Y 0.1 2026 International Truck Dump PW Capital Streets 2026 5 248,418$ 27,602$ 220,816$ 44,163$ Y 0.2 2036 International Truck Dump PW Capital Streets 2036 10 302,820$ 33,647$ 269,174$ 26,917$ Y 0.3 2046 International Truck Dump PW Capital Streets 2046 10 369,136$ 41,015$ 328,121$ 32,812$ Y 0.4 2056 International Truck Dump PW Capital Streets 2056 10 449,975$ 49,997$ 399,978$ 39,998$ Y 0.5 2066 International Truck Dump PW Capital Streets 2066 10 548,517$ 60,946$ 487,571$ 48,757$ Y 11 2016 Peterbilt - includes hook lift system Dump 2NP3LJ0X9GM361854 M208199 90 13,476 PW Capital Streets -- 450,000$ 50,000$ 400,000$ -$ Y 11.1 2027 Peterbilt - includes hook lift system Dump PW Capital Streets 2027 6 506,773$ 56,308$ 450,465$ 75,077$ Y 11.2 2037 Peterbilt - includes hook lift system Dump PW Capital Streets 2037 10 617,754$ 68,639$ 549,114$ 54,911$ Y 11.3 2047 Peterbilt - includes hook lift system Dump PW Capital Streets 2047 10 753,038$ 83,671$ 669,367$ 66,937$ Y 11.4 2057 Peterbilt - includes hook lift system Dump PW Capital Streets 2057 10 917,949$ 101,994$ 815,955$ 81,595$ Y 11.5 2067 Peterbilt - includes hook lift system Dump PW Capital Streets 2067 10 1,118,975$ 124,331$ 994,645$ 99,464$ Y 3 2016 Ford F350 Pick-up 1FDRF3H68GED40778 M210871 96 6,760 PW Capital Streets -- 45,000$ 5,500$ 39,500$ -$ Y 3.1 2027 Ford F350 Pick-up PW Capital Streets 2027 6 50,677$ 6,194$ 44,483$ 7,414$ Y 3.2 2034 Ford F350 Pick-up PW Capital Streets 2034 7 58,212$ 7,115$ 51,097$ 7,300$ Y 3.3 2041 Ford F350 Pick-up PW Capital Streets 2041 7 66,868$ 8,173$ 58,695$ 8,385$ Y 3.4 2048 Ford F350 Pick-up PW Capital Streets 2048 7 76,810$ 9,388$ 67,422$ 9,632$ Y 3.5 2055 Ford F350 Pick-up PW Capital Streets 2055 7 88,230$ 10,784$ 77,447$ 11,064$ Y 6 2016 Ford F350 Pick-up 1FDRF3H6XGED40779 M210857 97 10,725 PW Capital Streets -- 45,000$ 5,500$ 39,500$ -$ Y 6.1 2027 Ford F350 Pick-up PW Capital Streets 2027 6 50,677$ 6,194$ 44,483$ 7,414$ Y 6.2 2034 Ford F350 Pick-up PW Capital Streets 2034 7 58,212$ 7,115$ 51,097$ 7,300$ Y 6.3 2041 Ford F350 Pick-up PW Capital Streets 2041 7 66,868$ 8,173$ 58,695$ 8,385$ Y 6.4 2048 Ford F350 Pick-up PW Capital Streets 2048 7 76,810$ 9,388$ 67,422$ 9,632$ Y 6.5 2055 Ford F350 Pick-up PW Capital Streets 2055 7 88,230$ 10,784$ 77,447$ 11,064$ Y TBD 2004 Mac Lander Trailer Trailer 4UVPF202X41005505 M095484 58 - PW Capital Streets -- 5,000$ 500$ 4,500$ -$ Y TBD 2022 Mac Lander Trailer Trailer PW Capital Streets 2022 1 5,000$ 500$ 4,500$ 4,500$ Y TBD 2037 Mac Lander Trailer Trailer PW Capital Streets 2037 15 6,729$ 673$ 6,056$ 404$ Y TBD 2052 Mac Lander Trailer Trailer PW Capital Streets 2052 15 9,057$ 906$ 8,151$ 543$ Y TBD 2067 Mac Lander Trailer Trailer PW Capital Streets 2067 15 12,189$ 1,219$ 10,970$ 731$ Y TBD 2082 Mac Lander Trailer Trailer PW Capital Streets 2082 15 16,405$ 1,641$ 14,765$ 984$ Y TBD 1998 Towmaster Trailer - Single axel 12'Trailer 4KNTT1412WL160456 - 59 - PW Capital Streets -- 5,000$ 500$ 4,500$ -$ Y TBD 2022 Towmaster Trailer - Single axel 12'Trailer PW Capital Streets 2022 1 5,000$ 500$ 4,500$ 4,500$ Y TBD 2037 Towmaster Trailer - Single axel 12'Trailer PW Capital Streets 2037 15 6,729$ 673$ 6,056$ 404$ Y TBD 2052 Towmaster Trailer - Single axel 12'Trailer PW Capital Streets 2052 15 9,057$ 906$ 8,151$ 543$ Y TBD 2067 Towmaster Trailer - Single axel 12'Trailer PW Capital Streets 2067 15 12,189$ 1,219$ 10,970$ 731$ Y TBD 2082 Towmaster Trailer - Single axel 12'Trailer PW Capital Streets 2082 15 16,405$ 1,641$ 14,765$ 984$ Trailers 8 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback Vehicle Replacement Chargeback Schedule - Public Works Capital (Street Department) Vehicle # Y TBD 2003 Haulmark Trailer Trailer 16HCB12153H112082 - 20 - PW Capital Streets -- 5,000$ 500$ 4,500$ -$ Y TBD 2024 Haulmark Trailer Trailer PW Capital Streets 2024 3 5,306$ 531$ 4,775$ 1,592$ Y TBD 2039 Haulmark Trailer Trailer PW Capital Streets 2039 15 7,141$ 714$ 6,427$ 428$ Y TBD 2054 Haulmark Trailer Trailer PW Capital Streets 2054 15 9,611$ 961$ 8,650$ 577$ Y TBD 2069 Haulmark Trailer Trailer PW Capital Streets 2069 15 12,935$ 1,294$ 11,642$ 776$ Y TBD 2084 Haulmark Trailer Trailer PW Capital Streets 2084 15 17,409$ 1,741$ 15,668$ 1,045$ Y TBD 1998 Cronkite Trailer - 2 axel 16x7 Trailer 473271926W1101575 M091254 40 - PW Capital Streets -- 5,000$ 500$ 4,500$ -$ Y TBD 2022 Cronkite Trailer - 2 axel 16x7 Trailer PW Capital Streets 2022 1 5,000$ 500$ 4,500$ 4,500$ Y TBD 2037 Cronkite Trailer - 2 axel 16x7 Trailer PW Capital Streets 2037 15 6,729$ 673$ 6,056$ 404$ Y TBD 2052 Cronkite Trailer - 2 axel 16x7 Trailer PW Capital Streets 2052 15 9,057$ 906$ 8,151$ 543$ Y TBD 2067 Cronkite Trailer - 2 axel 16x7 Trailer PW Capital Streets 2067 15 12,189$ 1,219$ 10,970$ 731$ Y TBD 2082 Cronkite Trailer - 2 axel 16x7 Trailer PW Capital Streets 2082 15 16,405$ 1,641$ 14,765$ 984$ 9 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback Y 8 2003 Ford F350 Pick-up 1FTSF31SX3EA32518 M139290 47 79,509 Water Water Ops -- 38,000$ 4,000$ 34,000$ -$ Y 8.1 2021 Ford F 250 with plow Pick-up Water Water Ops 2021 1 38,000$ 4,000$ 34,000$ 34,000$ Y 8.2 2028 Ford F 250 with plow Pick-up Water Water Ops 2028 7 43,650$ 4,595$ 39,055$ 5,579$ Y 8.3 2035 Ford F 250 with plow Pick-up Water Water Ops 2035 7 50,140$ 5,278$ 44,862$ 6,409$ Y 8.4 2042 Ford F 250 with plow Pick-up Water Water Ops 2042 7 57,595$ 6,063$ 51,533$ 7,362$ Y 8.5 2049 Ford F 250 with plow Pick-up Water Water Ops 2049 7 66,159$ 6,964$ 59,195$ 8,456$ Y 24 2007 Ford F250 Pick-up 1FTNF215X7EA47544 M160752 45 73,929 Water Water Ops -- 55,000$ 4,000$ 51,000$ -$ Y 24.1 2022 One Ton Utility Truck Pick-up Water Water Ops 2022 1 56,100$ 4,080$ 52,020$ 52,020$ Y 24.2 2029 One Ton Utility Truck Pick-up Water Water Ops 2029 7 64,441$ 4,687$ 59,755$ 8,536$ Y 24.3 2036 One Ton Utility Truck Pick-up Water Water Ops 2036 7 74,023$ 5,383$ 68,639$ 9,806$ Y 24.4 2043 One Ton Utility Truck Pick-up Water Water Ops 2043 7 85,029$ 6,184$ 78,845$ 11,264$ Y 24.5 2050 One Ton Utility Truck Pick-up Water Water Ops 2050 7 97,671$ 7,103$ 90,568$ 12,938$ Y 5 2008 Ford F150 4x4 P/U Pick-up 1FTRF14W98KD16085 M168863 43 87,455 Water Water Ops -- 30,000$ 3,000$ 27,000$ -$ Y 5.1 2023 Ford F150 2W/D Pick-up Water Water Ops 2023 2 31,212$ 3,121$ 28,091$ 14,045$ Y 5.2 2030 Ford F150 2W/D Pick-up Water Water Ops 2030 7 35,853$ 3,585$ 32,267$ 4,610$ Y 5.3 2037 Ford F150 2W/D Pick-up Water Water Ops 2037 7 41,184$ 4,118$ 37,065$ 5,295$ Y 5.4 2044 Ford F150 2W/D Pick-up Water Water Ops 2044 7 47,307$ 4,731$ 42,576$ 6,082$ Y 5.5 2051 Ford F150 2W/D Pick-up Water Water Ops 2051 7 54,341$ 5,434$ 48,907$ 6,987$ Y 15 2017 Ford F150 Pick-up 1FTEW1CF8HFA76567 M211311 98 1,752 Water Water Ops -- 35,000$ 3,000$ 32,000$ -$ Y 15.1 2028 Ford F150 Pick-up Water Water Ops 2028 7 40,204$ 3,446$ 36,758$ 5,251$ Y 15.2 2035 Ford F150 Pick-up Water Water Ops 2035 7 46,182$ 3,958$ 42,223$ 6,032$ Y 15.3 2042 Ford F150 Pick-up Water Water Ops 2042 7 53,048$ 4,547$ 48,501$ 6,929$ Y 15.4 2049 Ford F150 Pick-up Water Water Ops 2049 7 60,936$ 5,223$ 55,713$ 7,959$ Y 15.5 2056 Ford F150 Pick-up Water Water Ops 2056 7 69,996$ 6,000$ 63,996$ 9,142$ Y 12 2018 Ford F150 Super Crew Pick-up 4ZEPE2224F1086728 - 86 - Water Water Ops -- 35,000$ 3,000$ 32,000$ -$ Y 12 2026 Ford F150 Super Crew Pick-up Water Water Ops 2026 5 38,643$ 3,312$ 35,331$ 7,066$ Y 12 2033 Ford F150 Super Crew Pick-up Water Water Ops 2033 7 44,388$ 3,805$ 40,584$ 5,798$ Y 12 2040 Ford F150 Super Crew Pick-up Water Water Ops 2040 7 50,988$ 4,370$ 46,618$ 6,660$ Y 12 2047 Ford F150 Super Crew Pick-up Water Water Ops 2047 7 58,570$ 5,020$ 53,549$ 7,650$ Y 12 2054 Ford F150 Super Crew Pick-up Water Water Ops 2054 7 67,278$ 5,767$ 61,511$ 8,787$ Y TBD 2003 Haulmark Trailer - Enclosed (TH85 / 20WT3)Trailer 16HGB20243H105515 M992897 51 - Water Water Ops -- 7,500$ 1,000$ 6,500$ -$ Y TBD 2024 Haulmark Trailer - Enclosed (TH85 / 20WT3)Trailer Water Water Ops 2024 3 7,959$ 1,061$ 6,898$ 2,299$ Y TBD 2039 Haulmark Trailer - Enclosed (TH85 / 20WT3)Trailer Water Water Ops 2039 15 10,712$ 1,428$ 9,284$ 619$ Y TBD 2054 Haulmark Trailer - Enclosed (TH85 / 20WT3)Trailer Water Water Ops 2054 15 14,417$ 1,922$ 12,495$ 833$ Y TBD 2069 Haulmark Trailer - Enclosed (TH85 / 20WT3)Trailer Water Water Ops 2069 15 19,403$ 2,587$ 16,816$ 1,121$ Y TBD 2084 Haulmark Trailer - Enclosed (TH85 / 20WT3)Trailer Water Water Ops 2084 15 26,114$ 3,482$ 22,632$ 1,509$ Y TBD 2015 Load Rite Trailer PE0222072-15146 Trailer 4ZEPE2224F1086728 - 86 - Water Water Ops -- 7,500$ 500$ 7,000$ -$ Y TBD 2026 Load Rite Trailer PE0222072-15146 Trailer Water Water Ops 2026 5 8,281$ 552$ 7,729$ 1,546$ Y TBD 2041 Load Rite Trailer PE0222072-15146 Trailer Water Water Ops 2041 15 11,145$ 743$ 10,402$ 693$ Y TBD 2056 Load Rite Trailer PE0222072-15146 Trailer Water Water Ops 2056 15 14,999$ 1,000$ 13,999$ 933$ Y TBD 2071 Load Rite Trailer PE0222072-15146 Trailer Water Water Ops 2071 15 20,187$ 1,346$ 18,841$ 1,256$ Y TBD 2086 Load Rite Trailer PE0222072-15146 Trailer Water Water Ops 2086 15 27,169$ 1,811$ 25,358$ 1,691$ Vehicle Replacement Chargeback Schedule - Water Department Vehicle # Trailers 10 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback Y 14 2008 Ford F350 Dump Utility 1FDWF37Y28ED57177 M169033 48 63,175 Sewer Sewer Ops -- 50,000$ 8,000$ 42,000$ -$ Y 14.1 2020 Utility Truck with plow Utility Sewer Sewer Ops 2020 0 50,000$ 8,000$ 42,000$ 42,000$ Y 14.2 2027 Utility Truck with plow Utility Sewer Sewer Ops 2027 7 57,434$ 9,189$ 48,245$ 6,892$ Y 14.3 2034 Utility Truck with plow Utility Sewer Sewer Ops 2034 7 65,974$ 10,556$ 55,418$ 7,917$ Y 14.4 2041 Utility Truck with plow Utility Sewer Sewer Ops 2041 7 75,783$ 12,125$ 63,658$ 9,094$ Y 14.5 2048 Utility Truck with plow Utility Sewer Sewer Ops 2048 7 87,051$ 13,928$ 73,123$ 10,446$ Y 20 2005 Ford F350 Utility 1FDWF37Y25EC37004 M149884 68 59,927 Sewer Sewer Ops -- 75,000$ 5,500$ 69,500$ -$ Y 20.1 2023 Utility Truck with crane & plow Utility Sewer Sewer Ops 2023 2 78,030$ 5,722$ 72,308$ 36,154$ Y 20.2 2030 Utility Truck with crane & plow Utility Sewer Sewer Ops 2030 7 89,632$ 6,573$ 83,059$ 11,866$ Y 20.3 2037 Utility Truck with crane & plow Utility Sewer Sewer Ops 2037 7 102,959$ 7,550$ 95,409$ 13,630$ Y 20.4 2044 Utility Truck with crane & plow Utility Sewer Sewer Ops 2044 7 118,267$ 8,673$ 109,594$ 15,656$ Y 20.5 2051 Utility Truck with crane & plow Utility Sewer Sewer Ops 2051 7 135,852$ 9,962$ 125,890$ 17,984$ Vehicle Replacement Chargeback Schedule - Sewer Department Vehicle # 11 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback P 1 2003 Ford F350 Utility 1FTSF31S13ED42301 M143039 33 78,216 Park & Rec Parks -- 34,000$ 1,000$ 33,000$ -$ P 1.1 2020 Ford F350 Utility Park & Rec Parks 2020 1 34,000$ 1,000$ 33,000$ 33,000$ P 1.2 2027 Ford F350 Utility Park & Rec Parks 2027 7 39,055$ 1,149$ 37,907$ 5,415$ P 1.3 2034 Ford F350 Utility Park & Rec Parks 2034 7 44,862$ 1,319$ 43,543$ 6,220$ P 1.4 2041 Ford F350 Utility Park & Rec Parks 2041 7 51,533$ 1,516$ 50,017$ 7,145$ P 1.5 2048 Ford F350 Utility Park & Rec Parks 2048 7 59,195$ 1,741$ 57,454$ 8,208$ P 2 2003 Ford F350 Dump Utility 1FDWF37S83ED42302 M201911 32 71,911 Park & Rec Parks -- 34,000$ 1,000$ 33,000$ -$ P 2.1 2020 Ford F350 Utility Utility Park & Rec Parks 2020 1 34,000$ 1,000$ 33,000$ 33,000$ P 2.2 2027 Ford F350 Utility Utility Park & Rec Parks 2027 7 39,055$ 1,149$ 37,907$ 5,415$ P 2.3 2034 Ford F350 Utility Utility Park & Rec Parks 2034 7 44,862$ 1,319$ 43,543$ 6,220$ P 2.4 2041 Ford F350 Utility Utility Park & Rec Parks 2041 7 51,533$ 1,516$ 50,017$ 7,145$ P 2.5 2048 Ford F350 Utility Utility Park & Rec Parks 2048 7 59,195$ 1,741$ 57,454$ 8,208$ P 3 2008 Ford F350 Pick-up 1FTWF31548EA08413 M160637 31 59,425 Park & Rec Parks -- 30,000$ 2,000$ 28,000$ -$ P 3.1 2022 Ford F350 Pick-up Park & Rec Parks 2022 1 30,600$ 2,040$ 28,560$ 28,560$ P 3.2 2029 Ford F350 Pick-up Park & Rec Parks 2029 7 35,150$ 2,343$ 32,806$ 4,687$ P 3.3 2036 Ford F350 Pick-up Park & Rec Parks 2036 7 40,376$ 2,692$ 37,684$ 5,383$ P 3.4 2043 Ford F350 Pick-up Park & Rec Parks 2043 7 46,379$ 3,092$ 43,287$ 6,184$ P 3.5 2050 Ford F350 Pick-up Park & Rec Parks 2050 7 53,275$ 3,552$ 49,724$ 7,103$ P 4 2007 Ford F350 Utility Dump 1FDWF37Y37EA13940 M160425 28 42,184 Park & Rec Parks -- 50,000$ 2,000$ 48,000$ -$ P 4.1 2021 Ford F450 Dump Dump Park & Rec Parks 2021 1 50,000$ 2,000$ 48,000$ 48,000$ P 4.2 2028 Ford F450 Dump Dump Park & Rec Parks 2028 7 57,434$ 2,297$ 55,137$ 7,877$ P 4.3 2035 Ford F450 Dump Dump Park & Rec Parks 2035 7 65,974$ 2,639$ 63,335$ 9,048$ P 4.4 2042 Ford F450 Dump Dump Park & Rec Parks 2042 7 75,783$ 3,031$ 72,752$ 10,393$ P 4.5 2049 Ford F450 Dump Dump Park & Rec Parks 2049 7 87,051$ 3,482$ 83,569$ 11,938$ P 5 2003 Ford F150 Pick-up 2FTRF17273CA61524 M143521 25 40,113 Park & Rec Parks -- 25,000$ 500$ 24,500$ -$ P 5.1 2023 Ford F150 Pick-up Park & Rec Parks 2023 2 26,010$ 520$ 25,490$ 12,745$ P 5.2 2030 Ford F150 Pick-up Park & Rec Parks 2030 7 29,877$ 598$ 29,280$ 4,183$ P 5.3 2037 Ford F150 Pick-up Park & Rec Parks 2037 7 34,320$ 686$ 33,633$ 4,805$ P 5.4 2044 Ford F150 Pick-up Park & Rec Parks 2044 7 39,422$ 788$ 38,634$ 5,519$ P 5.5 2051 Ford F150 Pick-up Park & Rec Parks 2051 7 45,284$ 906$ 44,378$ 6,340$ P 6 2004 Ford F150 Pick-up 2FTRF17224CA79916 M144398 24 34,322 Park & Rec Parks -- 25,000$ 500$ 24,500$ -$ P 6.1 2023 Ford F150 Pick-up Park & Rec Parks 2023 2 26,010$ 520$ 25,490$ 12,745$ P 6.2 2030 Ford F150 Pick-up Park & Rec Parks 2030 7 29,877$ 598$ 29,280$ 4,183$ P 6.3 2037 Ford F150 Pick-up Park & Rec Parks 2037 7 34,320$ 686$ 33,633$ 4,805$ P 6.4 2044 Ford F150 Pick-up Park & Rec Parks 2044 7 39,422$ 788$ 38,634$ 5,519$ P 6.5 2051 Ford F150 Pick-up Park & Rec Parks 2051 7 45,284$ 906$ 44,378$ 6,340$ P 7 2005 Ford F350 Flatbed Pick-up 1FDWF36Y95EC37003 M149885 26 36,479 Park & Rec Parks -- 32,000$ 500$ 31,500$ -$ P 7.1 2024 Ford F350 Pick-up Park & Rec Parks 2024 3 33,959$ 531$ 33,428$ 11,143$ P 7.2 2031 Ford F350 Pick-up Park & Rec Parks 2031 7 39,008$ 609$ 38,398$ 5,485$ P 7.3 2038 Ford F350 Pick-up Park & Rec Parks 2038 7 44,808$ 700$ 44,108$ 6,301$ P 7.4 2045 Ford F350 Pick-up Park & Rec Parks 2045 7 51,470$ 804$ 50,666$ 7,238$ P 7.5 2052 Ford F350 Pick-up Park & Rec Parks 2052 7 59,123$ 924$ 58,199$ 8,314$ Vehicle Replacement Chargeback Schedule - Parks Department Vehicle # 12 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback Vehicle Replacement Chargeback Schedule - Parks Department Vehicle # P 8 2007 Ford F350 Dump 1FDWF37Y57EA13941 M160502 27 48,450 Park & Rec Parks -- 52,000$ 1,500$ 50,500$ -$ P 8.1 2024 Ford F450 Dump Park & Rec Parks 2024 3 55,183$ 1,592$ 53,591$ 17,864$ P 8.2 2031 Ford F450 Dump Park & Rec Parks 2031 7 63,388$ 1,828$ 61,559$ 8,794$ P 8.3 2038 Ford F450 Dump Park & Rec Parks 2038 7 72,813$ 2,100$ 70,712$ 10,102$ P 8.4 2045 Ford F450 Dump Park & Rec Parks 2045 7 83,639$ 2,413$ 81,226$ 11,604$ P 8.5 2052 Ford F450 Dump Park & Rec Parks 2052 7 96,075$ 2,771$ 93,303$ 13,329$ P 9 2008 Ford F350 Pick-up 1FTWF31528EA08412 M160639 29 37,038 Park & Rec Parks -- 33,000$ 1,000$ 32,000$ -$ P 9.1 2025 Ford F450 Pick-up Park & Rec Parks 2025 4 35,720$ 1,082$ 34,638$ 8,659$ P 9.2 2032 Ford F450 Pick-up Park & Rec Parks 2032 7 41,031$ 1,243$ 39,788$ 5,684$ P 9.3 2039 Ford F450 Pick-up Park & Rec Parks 2039 7 47,132$ 1,428$ 45,704$ 6,529$ P 9.4 2046 Ford F450 Pick-up Park & Rec Parks 2046 7 54,140$ 1,641$ 52,499$ 7,500$ P 9.5 2053 Ford F450 Pick-up Park & Rec Parks 2053 7 62,190$ 1,885$ 60,305$ 8,615$ P 10 2008 Ford F350 Pick-up 1FTWF31568EA08414 M160638 30 41,611 Park & Rec Parks -- 33,000$ 1,000$ 32,000$ -$ P 10.1 2025 Ford F350 Pick-up Park & Rec Parks 2025 4 35,720$ 1,082$ 34,638$ 8,659$ P 10.2 2032 Ford F350 Pick-up Park & Rec Parks 2032 7 41,031$ 1,243$ 39,788$ 5,684$ P 10.3 2039 Ford F350 Pick-up Park & Rec Parks 2039 7 47,132$ 1,428$ 45,704$ 6,529$ P 10.4 2046 Ford F350 Pick-up Park & Rec Parks 2046 7 54,140$ 1,641$ 52,499$ 7,500$ P 10.5 2053 Ford F350 Pick-up Park & Rec Parks 2053 7 62,190$ 1,885$ 60,305$ 8,615$ P 11 2008 Ford F350 Pick-up 1FTWF31528ED44867 M168864 34 30,924 Park & Rec Parks -- 33,000$ 1,000$ 32,000$ -$ P 11.1 2025 Ford F350 Pick-up Park & Rec Parks 2025 4 35,720$ 1,082$ 34,638$ 8,659$ P 11.2 2032 Ford F350 Pick-up Park & Rec Parks 2032 7 41,031$ 1,243$ 39,788$ 5,684$ P 11.3 2039 Ford F350 Pick-up Park & Rec Parks 2039 7 47,132$ 1,428$ 45,704$ 6,529$ P 11.4 2046 Ford F350 Pick-up Park & Rec Parks 2046 7 54,140$ 1,641$ 52,499$ 7,500$ P 11.5 2053 Ford F350 Pick-up Park & Rec Parks 2053 7 62,190$ 1,885$ 60,305$ 8,615$ P 12 2015 Ford F350 Dump 1FDRF3G68FED09773 M204398 78 9,049 Park & Rec Parks -- 55,000$ 7,000$ 48,000$ -$ P 12.1 2026 Ford F450 Dump Park & Rec Parks 2026 5 60,724$ 7,729$ 52,996$ 10,599$ P 12.2 2033 Ford F450 Dump Park & Rec Parks 2033 7 69,753$ 8,878$ 60,876$ 8,697$ P 12.3 2040 Ford F450 Dump Park & Rec Parks 2040 7 80,125$ 10,198$ 69,927$ 9,990$ P 12.4 2047 Ford F450 Dump Park & Rec Parks 2047 7 92,038$ 11,714$ 80,324$ 11,475$ P 12.5 2054 Ford F450 Dump Park & Rec Parks 2054 7 105,723$ 13,456$ 92,267$ 13,181$ P 13 2016 Ford Transit Van Van 1FTYE1ZM4GKA79591 M207782 87 4,689 Park & Rec Parks -- 30,000$ 3,000$ 27,000$ -$ P 13.1 2027 Ford Transit Van Van Park & Rec Parks 2027 6 33,785$ 3,378$ 30,406$ 5,068$ P 13.2 2037 Ford Transit Van Van Park & Rec Parks 2037 10 41,184$ 4,118$ 37,065$ 3,707$ P 13.3 2047 Ford Transit Van Van Park & Rec Parks 2047 10 50,203$ 5,020$ 45,182$ 4,518$ P 13.4 2057 Ford Transit Van Van Park & Rec Parks 2057 10 61,197$ 6,120$ 55,077$ 5,508$ P 13.5 2067 Ford Transit Van Van Park & Rec Parks 2067 10 74,598$ 7,460$ 67,139$ 6,714$ 13 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback R 1 2006 Dodge Grand Caravan Van 1D4GP24E66B731334 M160824 22 40,920 Park & Rec Recreation -- 28,000$ 500$ 27,500$ -$ R 1.1 2020 Dodge Grand Caravan Van Park & Rec Recreation 2020 1 28,000$ 500$ 27,500$ 27,500$ R 1.2 2030 Dodge Grand Caravan Van Park & Rec Recreation 2030 10 34,132$ 609$ 33,522$ 3,352$ R 1.3 2040 Dodge Grand Caravan Van Park & Rec Recreation 2040 10 41,607$ 743$ 40,864$ 4,086$ R 1.4 2050 Dodge Grand Caravan Van Park & Rec Recreation 2050 10 50,718$ 906$ 49,812$ 4,981$ R 1.5 2060 Dodge Grand Caravan Van Park & Rec Recreation 2060 10 61,825$ 1,104$ 60,721$ 6,072$ R 2 2017 Ford Transit Van Van 1FTYE1YM9HKB18372 M212638 102 3,758 Park & Rec Recreation -- 30,000$ 3,000$ 27,000$ -$ R 2.1 2028 Ford Transit Van Van Park & Rec Recreation 2028 7 34,461$ 3,446$ 31,015$ 4,431$ R 2.2 2038 Ford Transit Van Van Park & Rec Recreation 2038 10 42,007$ 4,201$ 37,807$ 3,781$ R 2.3 2048 Ford Transit Van Van Park & Rec Recreation 2048 10 51,207$ 5,121$ 46,086$ 4,609$ R 2.4 2058 Ford Transit Van Van Park & Rec Recreation 2058 10 62,421$ 6,242$ 56,178$ 5,618$ R 2.5 2068 Ford Transit Van Van Park & Rec Recreation 2068 10 76,090$ 7,609$ 68,481$ 6,848$ Vehicle Replacement Chargeback Schedule - Recreation Department Vehicle # 14 Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #6 Tracking Number ADM 2019-30 Selection of Committee Liaisons Administration Committee – June 19, 2019 Selection of liaison to the Library Board. Bart Olson Administration Name Department Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #7 Tracking Number ADM 2019-31 2019 Meeting Dates Administration Committee – June 19, 2019 Review of the remainder of 2019 meeting dates for the Administration Committee. Bart Olson Administration Name Department Page 1 of 2 2019 MEETING SCHEDULE This meeting schedule is subject to revision. Upon revision, all entities that have lodged a request for the meeting schedule will be sent the updated/revised schedule. City Council Meeting 2nd & 4th Tuesday – 7:00 pm at City Hall January 8 & 22 July 9 & 23 February 12 & 26 August 13 & 27 March 12 & 26 September 10 & 24 April 9 & 23 October 8 & 22 May 14 & 28 November 12 & 26 June 11 & 25 December 10 Administration Committee 3rd Wednesday – 6:00 pm at City Hall January 16 July 17 February 20 August 21 March 20 September 18 April 17 October 16 May 15 November 20 June 19 December 18 Economic Development Committee 1st Tuesday – 6:00 pm at City Hall January 2* (Wednesday, due to Jan. 1st holiday) July 2 February 5 August 6 March 5 September 3 April 2 October 1 May 7 November 5 June 4 December 3 Public Safety Committee Quarterly - 1st Thursday – 6:00 pm at City Hall January 3 July 3* (Wednesday, due to July 4th holiday) April 4 October 3 United City of Yorkville 800 Game Farm Road Yorkville, Illinois 60560 Telephone: 630-553-4350 www.yorkville.il.us Page 2 of 2 Public Works Committee 3rd Tuesday – 6:00 pm at City Hall January 15 July 16 February 19 August 20 March 19 September 17 April 16 October 15 May 21 November 19 June 18 December 17 Fire and Police Commission Quarterly, 4th Wednesday - 6:00 pm at City Hall January 23 July 24 April 24 October 23 Library Board Meeting 2nd Monday - 7:00 pm at Library January 14 July 8 February 11 August 12 March 11 September 9 April 8 October 14 May 13 November 18* (due to Nov. 11th Veterans Day holiday) June 10 December 9 Park Board 2nd Thursday bi-monthly – 6:30 pm at Parks Maintenance Bldg – 185 Wolf Street January 10 July 11 March 14 September 12 May 9 November 14 Planning and Zoning Commission 2nd Wednesday - 7:00 pm at City Hall January 9 July 10 February 13 August 14 March 13 September 11 April 10 October 9 May 8 November 13 June 12 December 11 Police Pension Fund Board Quarterly, 2nd Tuesday - 5:00 p.m. at Police Dept. February 12 August 13 May 21* (3rd Tuesday) November 12 Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #8 Tracking Number ADM 2019-32 Nepotism Policy Administration Committee – June 19, 2019 Majority Approval See attached memo. Erin Willrett Administration Name Department Summary Revising Section 2.19 Nepotism Policy to the Employee Manual. Background Section 2.19 is currently known as the Nepotism Policy. The red-lined version is attached for your reference. Staff is currently reviewing the Employee Manual in its entirety but are first cleaning up sections that are out of compliance. The Nepotism Policy amendment reflects the need to address these items on a case-by-case basis. The need to apply these rules consistently was also added to the language of this section. The city does not promote favoritism and the revised language is meant to reiterate that point. Recommendation Staff recommends amending Section 2.19 Nepotism Policy as outlined in the attached red-lined version of the City of Yorkville Employee Manual. Memorandum To: Administration Committee From: Erin Willrett, Assistant City Administrator CC: Bart Olson, City Administrator Date: June 19, 2019 Subject: Revising Section 2.19 Nepotism, United City of Yorkville Employee Manual Section 2.19 Nepotism Section 2.19.1 Prohibition on Employing the Spouse/Relatives of Department Heads/Elected Officials/Paid Appointed Officers (Anti-Nepotism) a. It shall be the policy of the City that it shall not employ the spouse or a relative of the following Department Heads, Elected Officials, or Paid Appointed Officers: Mayor, Aldermen, Clerk, Treasurer, City Administrator, Chief of Police, Director of Parks and Recreation, Director of Finance, City Engineer, Director of Public Works, Community Development Director, Building and Zoning Officer, and City Attorney. For this purpose, a relative is deemed to mean a spouse/ parents, grandparents, children or grandchildren, siblings, aunts, uncles, in-laws, and step relatives within the same categories. b. This policy restricting employment of certain spouses and relatives shall not apply to any prohibited relationships existing on the date of passage of this provision. These issues will be addressed on a case-by-case basis and will be applied consistently without regard to marital or familial status. Section 2.19.2 Spouse/Relatives of Department Heads/Elected Officials a. The employment of a spouse or a relative of any Department Head or elected official may be subject to a confidentiality disclosure agreement or conflict of interest agreement as deemed necessary by the City Attorney. For this purpose, a relative is deemed to mean a spouse, parents, grandparents, children or grandchildren, siblings, aunts, uncles, nieces, nephews, in-laws, and step relatives within these categories. b. This policy is intended to comply with the requirements of all applicable federal, state, and local laws. c. These issues will be addressed on a case-by-case basis.The City Administrator is responsible for the coordination, administration and implementation of the provisions of this policy as approved by the City Council. Section 2.19.3 Relatives of All Employees a. The purpose of this policy is to establish consistent guidelines concerning the employment of relatives of employees of the City. Relative is deemed to mean a spouse, parents, grandparents, children or grandchildren, siblings, aunts and uncles, in-laws and step-relatives, within these categories. It is the policy of the City to provide all employees with equal employment opportunities for career advancement without fear of favoritism or penalty, actual or implied, based on family relations. b. The employment of a relative of any full-time City employee, in a full or part-time position, is prohibited if such employment shall cause the new employee to come under direct supervision of or provide direct supervision to the related full-time employee. c. Full-time City employees will not be considered for promotion or transfer if such change shall cause the employee to come under, or to provide direct supervision to a related City employee. d. If employees in a supervisory relationship become related after employment, every effort will be made to transfer one of the employees to a position where no supervisory relationship exists. If neither employee volunteers to transfer, the City Administrator will arrange an involuntary transfer at his or her discretion. Transfer decisions may be based on, but are not limited to, such factors as the grade of each affected employee's position, the availability of openings for which the affected employees are qualified, and the availability of replacement candidates for the affected employees' positions. e. This policy is intended to comply with the requirements of all applicable federal, state and local laws. f. The Mayor or his designee is responsible for the coordination, administration and implementation of the provisions of this policy as approved by the City Council. Prior to the application of this policy regarding employment or transfer decisions with respect to spouses, supervisors must contact the Mayor to ensure compliance with applicable federal, state and local laws.   Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #9 Tracking Number ADM 2019-33 Policy Review Administration Committee – June 19, 2019 Materials will be presented at the meeting. Bart Olson Administration Name Department Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #10 Tracking Number ADM 2019-34 Solicitor Registration and Regulations Administration Committee – June 19, 2019 Majority Approval Chairman Funkhouser has requested a review of current solicitor regulations. Staff has prepared proposed changes to the solicitor requirements for the committee to review and consider. Lisa Pickering Administration Name Department Summary Consideration of an amendment to the section of city code regulating solicitors. Background Solicitor regulations were lasted updated in 2008. Included in the city code regulating solicitors is a provision for the certificate of registration to be carried and displayed by solicitors while engaged in soliciting. Section 3-7-2 of the city code includes the following regarding the Certificate of Registration: “It shall be unlawful for any person to engage in soliciting, hawking or business as an itinerant merchant without having first obtained said certificate of registration. Said certificate shall be carried by the registered solicitor, hawker, or itinerant merchant while engaged in soliciting and shall be displayed at all times.” To aid solicitors in making sure that they had an item that could be displayed at all times, the city has issued picture ID card to registered solicitors. The ID card that staff has been using for over ten years is small and it is felt that it is not easy to read. There has also been a concern that not all solicitors are wearing their ID card when they go door-to-door. Staff is proposing a new ID card that is larger and easier to read; along with providing a holder and lanyard for the ID card as well. Staff has provided a sample of the current solicitor ID card, as well as a proposed new version that is larger and easier to read. We are proposing changing the color used on the ID to a blue and a darker red color to reflect the colors that were chosen for the downtown wayfinding signage. Staff has also researched the cost of an ID holder and lanyard on Amazon and has found that the cost is approximately $.50 per solicitor to provide a holder and lanyard. This cost would be minimal and would ensure that solicitors have a holder that they can wear at all times while soliciting in Yorkville. We have also provided samples of solicitor IDs from Lombard, Elk Grove Village, Montgomery, and Oswego for comparison. In reviewing our solicitor code, staff has found two sections to be considered for an update. The first proposed update is to city code section 3-7-3, paragraph E which deals with situations in which denial of a certificate of registration would occur. Recommended changes include denying solicitor registration to persons who have been previously convicted of any crimes involving burglary, theft, dishonesty, fraud, deception or similar offenses. Also recommended is the addition of a new section which would allow for revocation of a registration that has been issued to any solicitor that solicits outside of the allowed hours for soliciting or Memorandum To: Administration Committee From: Lisa Pickering, City Clerk CC: Bart Olson, City Administrator Date: June 11, 2019 Subject: Solicitor Registration and Regulations solicits at residences that have “No Soliciting” signs posted. The city attorney has provided an ordinance amending these sections of code for consideration. Additionally, to help emphasize to solicitors the importance of following the regulations on soliciting, staff is proposing an additional checklist that solicitors must read and sign when they pick up their permit and badge. The checklist would include an acknowledgement by the solicitors of the allowed hours for soliciting, an acknowledgement that they cannot knock on any doors where the residents have a “no soliciting” sign posted and finally an acknowledgment that they will wear their city issued ID card and ensure that it is clearly visible at all times while soliciting within city limits. Recommendation Staff recommends approval of the amendment to the solicitor code and seeks feedback on the proposed redesigned ID cards. United City of Yorkville Office of the City Clerk Certificate of Registration Solicitor No. 2019- Registration Fee $100.00 By the Authority of the United City of Yorkville This Certificate of Registration is Hereby Granted to: _______________ To Operate as a Solicitor for _____________________________________ For a Term of One Year – January 1, 2019 through December 31, 2019, Subject to the Ordinances of the United City of Yorkville. Permitted Hours for Soliciting Monday – Friday 9:00 A.M. – 8:00 P.M. Saturday 9:00 A.M. – 5:00 P.M. No Soliciting on Sundays or Legal Holidays IN WITNESS WHEREOF, I have hereunto set my hand and seal on this _____ day of _______________, 2019. ________________________ City Clerk Example of current certificate of registration issued to each solicitor. Current Solicitor ID Badge Size 3” x 2” 2 inches 3 inches Proposed Solicitor ID Badge Size 3 ¼ “ x 4 ¾ “ 3 ¼ inches 4 ¾ inches Village of Lombard Registered Solicitors Elk Grove Village Passport Holders, Extra Large ID Badge Holder Inside Dimensions 4 x 6 inches. Outside Dimensions 4.2 x 7 inches Price per 100 is $29.99 on Amazon https://www.amazon.com/MIFFLIN-Passport-Holders-Waterproof- Vertical/dp/B07QR2TW2H/ref=sr_1_6?keywords=id+sleeve+vertical+6+inch&qid=156027191 3&s=gateway&sr=8-6 Lanyards for ID Holders Price per 100 is $14.99 on Amazon https://www.amazon.com/Black-Lanyards-Safety-Lanyard- Swivel/dp/B07GRVCBCK/ref=sxin_2_ac_d_pm?crid=2NA0740INEKSS&keywords=lanyards+ for+id+badges&pd_rd_i=B07GRVCBCK&pd_rd_r=8c1ddfb5-5373-4715-b0b1- 44d103903c9f&pd_rd_w=46xai&pd_rd_wg=uCO1B&pf_rd_p=be5d8dec-444e-4770-91df- 1e16a8c46da8&pf_rd_r=ZFWYT6WKBEHKM71ZV0MJ&qid=1560279113&s=gateway&spref ix=lanyar%2Caps%2C175 Ordinance No. 2019-____ Page 1 Ordinance No. 2019-_____ AN ORDINANCE OF THE UNITED CITY OF YORKVILLE, KENDALL COUNTY, ILLINOIS, AMENDING THE REGULATIONS FOR SOLICITORS, HAWKERS AND ITINERANT MERCHANTS WHEREAS, the United City of Yorkville, Kendall County, Illinois (the “City”) is a duly organized and validly existing non home-rule municipality created in accordance with the Constitution of the State of Illinois of 1970 and the laws of the State; and, WHEREAS, Title 3, Chapter 7 of the Code of Ordinances of the United City of Yorkville, Kendall County, Illinois, establishes regulations for solicitors, hawkers and itinerant merchants; and, WHEREAS, the Mayor and the City Council (the “Corporate Authorities”) have reviewed the requirements for registration and have determined that there is need to further the application requirement for solicitors, hawkers and itinerant merchants and to provide for the immediate revocation of the registration of any person violating the time limit on solicitation or defying the notice in any residence in the City restricting solicitation, all as hereinafter provided. NOW, THEREFORE, BE IT ORDAINED by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois, as follows: Section 1. That Subsection 3-7-3E of the Yorkville City Code, be and is hereby amended by deleting said Subsection in its entirety and replacing it with the following: “E. No certificate of registration shall be issued to any person who has been convicted of a felony under the laws of the State of Illinois or any other State or Federal law of the United States, within five (5) years of the date of the application; nor to any person who has an active, unpaid violation or conviction of any provision of this Chapter; nor to any person whose certificate of registration hereunder has previously been revoked as herein provided; nor to any person convicted of a crime involving burglary, theft, dishonesty, fraud, deception or similar offense.” Ordinance No. 2019-____ Page 2 Section 2. The following new Section 3-7-11 is hereby added to Title 3, Chapter: “3-7-11: Revocation of Registration. Any registration issued pursuant to this Chapter shall be immediately revoked upon a violation of Sections 3-7-8 or 3-7-9 of this Chapter 3.” Section 3. This Ordinance shall be in full force and effect from and after its passage and approval as provided by law. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois, this ____ day of _________________, A.D. 2019. ______________________________ City Clerk KEN KOCH ________ DAN TRANSIER ________ JACKIE MILSCHEWSKI ________ ARDEN JOE PLOCHER ________ CHRIS FUNKHOUSER ________ JOEL FRIEDERS ________ SEAVER TARULIS ________ JASON PETERSON ________ APPROVED by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this _____ day of _________________, A.D. 2019. ______________________________ Mayor Attest: _____________________________ City Clerk Chapter 7 SOLICITORS, HAWKERS AND ITINERANT MERCHANTS 3-7-1: DEFINITIONS: For the purpose of this chapter, the following words as used herein shall be construed to have the meanings herein ascribed: HAWKER/PEDDLER: Any person traveling from place to place, house to house, or street to street, carrying, conveying or transporting goods, wares, and merchandise, offering and exposing the same for sale. ITINERANT MERCHANT: Any person, who engages in a transient or temporary business of selling and delivering goods, wares, or merchandise within the city, and who, in furtherance of such purpose, leases, uses, or occupies any temporary structure, tent lot, street, alley, sidewalk, or any other such place, public or private, within the city for the exhibition and sale of such goods, wares, or merchandise, or for securing orders for future delivery of such goods, wares, or merchandise. Examples include: Christmas tree sales. Also called transient merchant or transient vendor. RESIDENCE: Includes every separate living unit occupied for residential purposes by one or more persons, contained within any type of building or structure. SOLICITING: Includes any one or more of the following activities: A. Seeking to obtain orders for the purchase of goods, wares, merchandise, foodstuffs, and services of any kind, character or description, for any kind of consideration; or B. Seeking to obtain prospective customers for application or purchase of insurance of any type, kind or character; or C. Seeking to obtain subscriptions to books, magazines, periodicals, newspapers, and every other type or kind of publication; or D. Seeking to obtain gifts or contributions of money, clothing, or any other valuable thing for the support or benefit of any charitable or nonprofit association, organization, corporation or project. E. Hawking or doing business as an itinerant merchant. SOLICITOR: Any person traveling from place to place, house to house, or street to street, taking or attempting to take orders for sale of goods, wares and merchandise, personal property of any nature for future delivery, or for services to be furnished or performed in the future, whether or not such person carries or exposes for sale a sample of the subject of such sale. (Ord. 2008-51, 6- 10-2008) Yorkville code - red-lined version of proposed changes 3-7-2: CERTIFICATE OF REGISTRATION REQUIRED: Every person desiring to engage in soliciting, hawking or business as an itinerant merchant within the city is hereby required to make written application for a certificate of registration as hereinafter provided. It shall be unlawful for any person to engage in soliciting, hawking or business as an itinerant merchant without having first obtained said certificate of registration. Said certificate shall be carried by the registered solicitor, hawker, or itinerant merchant while engaged in soliciting and shall be displayed at all times. (Ord. 2008-51, 6-10-2008) 3-7-3: APPLICATION FOR CERTIFICATE: A. Before a certificate may be issued under this chapter, a written sworn application signed by the applicant, if an individual; or by all partners, if a partnership; or by the president of a corporation, if a corporation; or by a parent, if the applicant is under the age of fourteen (14), containing the following information must be submitted to the office of the city clerk: 1. The applicant's name, current address of residence, length of residence at such address, telephone number, business address if other than residence address, date of birth, and social security number; 2. Copy of current state photo identification or driver's license; 3. Name, address, and telephone number of the person, firm, corporation, or association whom the applicant is employed by or represents, and the length of time of such employment or representation; 4. A brief description of the nature of the business in which the applicant is engaged, and the kind of products or services to be sold or rendered; 5. Period of time for which the certificate is requested, and the approximate hours of the day that such function shall be performed; 6. The date, or approximate date, of the latest previous application for certificate under this chapter, if any; 7. A statement whether a certificate of registration, under the provisions of this chapter or any other similar ordinance of the city or any county or municipality, has ever been revoked, together with the details thereof; 8. A statement whether the applicant and/or the person(s) managing or supervising the applicant's business have/has ever been convicted of a felony or misdemeanor under the laws of the state of Illinois, or any other state or federal law of the United States, or a violation of any of the provisions of this chapter or the ordinance of any other Illinois municipality regulating the activities of solicitors, hawkers, or itinerant merchants, together with the details thereof; 9. The applicant's "Illinois business tax number" as issued by the "Illinois department of revenue". No certificate shall be issued if the applicant does not have an Illinois business tax number, unless the applicant represents or works for a religious, educational or charitable organization where such organization is entirely a nonprofit organization and who can furnish the city with a "tax exempt number" and written proof of its "tax exempt status"; 10. Each itinerant merchant must submit a signed statement from the owner of the property from which he or she is proposing to operate his or her business evidencing permission to do business on the particular owner's property. If the applicant is proposing to operate his or her business from a city park, written permission from the park board must be submitted; 11. Each applicant shall submit a photo that must be the same size as required for passports _ two inches by two inches (2" x 2"). B. All statements made by the applicant upon the application or in connection therewith shall be under oath. C. Each applicant shall be required to submit to fingerprinting by the police department in connection with the application for certificate. The applicant shall pay the fee as set by the Illinois state police for fingerprint submissions. D. The office of the city clerk shall keep an accurate record of every application received and acted upon, together with all other information and data pertaining thereto, and all certificates of registration issued or applications denied. E. No certificate of registration shall be issued to any person who has been convicted of the commission of a felony under the laws of the state of Illinois or any other state or federal law of the United States, within five (5) years of the date of the application; nor to any person who has an active, unpaid violation or been convicted of a violationconviction of any of the provisions of this chapter;, nor to any person whose certificate of registration issued hereunder has previously been revoked, as herein provided; nor to any person convicted of a crime involving burglary, theft, dishonesty, fraud, deception or similar offense. F. Each hawker and itinerant merchant applicant shall pay a two hundred dollar ($200.00) application fee per application. Each solicitor applicant shall pay a one hundred dollar ($100.00) application fee per application. No application fee shall be charged of a solicitor, hawker, or itinerant merchant sponsored by or working for a religious, educational or charitable organization where such organization is entirely a nonprofit organization and who can furnish the city with a "tax exempt number" and written proof of its "tax exempt status". (Ord. 2008-51, 6-10-2008) 3-7-4: ISSUANCE OF CERTIFICATE: The office of the city clerk, after consideration of the application and all information obtained relative thereto, shall, within ten (10) business days of application, approve or deny the application. If the applicant does not provide the necessary information or qualify for such certificate, pursuant to section 3-7-3 of this chapter, and the issuance of a certificate of registration to the applicant would not be in accord with the intent and purpose of this chapter, then the office of the city clerk shall deny the application. If denied, endorsement shall be made by the office of the city clerk upon the application. If the applicant provides the necessary information and is found to be fully qualified, the certificate of registration shall be issued within five (5) business days of the application approval so long as the application fees have been fully paid. Any certificate of registration issued pursuant to this chapter shall expire one year after issuance. (Ord. 2008-51, 6-10-2008) 3-7-5: INVITING HAWKERS AND SOLICITORS ONTO PREMISES: The owner or resident of any premises in the city shall determine whether hawkers and solicitors shall be, or shall not be, invited onto his or her premises. Only hawkers and solicitors having a valid certificate of registration provided in section 3-7-2 of this chapter shall engage in solicitation within the city unless said hawker or solicitor has previously been invited by an owner or resident of the premises. In the interest of safety, no child under the age of fourteen (14) shall be allowed to solicit in the city of Yorkville unless said child is supervised during solicitation by an adult who has registered pursuant to this chapter. (Ord. 2008-51, 6-10-2008) 3-7-6: NOTICE REGULATING SOLICITING: A. Any owner or resident may restrict solicitation or limit the hours during which hawkers and solicitors are invited to his or her residence by posting that intention as provided in this section. B. Notice of restricting solicitation or limiting a hawker's or solicitor's hours by the owner or resident shall be given in the following manner: A weatherproof card, approximately three inches by four inches (3" x 4") in size, or larger, shall be exhibited upon or near the main entrance door to the residence, indicating as follows: NO SOLICITORS INVITED or SOLICITATION LIMITED TO THE HOURS OF: Note: Any reference to "solicitors" on said card shall include both hawkers and solicitors, as defined in this chapter. C. Such card, or similar sign, so exhibited shall constitute sufficient notice to any hawker or solicitor of the owner's or resident's desire to restrict solicitation or to limit the hawker's or solicitor's hours. (Ord. 2008-51, 6-10-2008) 3-7-7: DUTY OF HAWKERS AND SOLICITORS: It shall be the duty of each hawker and solicitor entering any privately owned premises in the city to first examine the notice provided for in section 3-7-6 of this chapter, if any is given or attached, and abide by the statement contained in the notice. If the hawker or solicitor is calling during a time when the resident has restricted solicitation or limited the hawker's or solicitor's hours, then the hawker or solicitor, whether registered or not, shall immediately and peacefully depart from the premises. Any hawker or solicitor who has gained entrance to or who is on any premises, whether invited or not, shall immediately and peacefully depart from the premises when requested to do so by the owner or resident. (Ord. 2008-51, 6-10-2008) 3-7-8: UNINVITED SOLICITING PROHIBITED: It is hereby declared to be unlawful and shall constitute a nuisance for any person, whether registered under this chapter or not, to go upon any premises and ring the doorbell upon or near any door, or create any sound in any manner calculated to attract the attention of the occupant of such residence, for the purpose of securing an audience with the occupant thereof and engage in "soliciting" as herein defined, in defiance of the notice exhibited at the residence in accordance with the provisions of section 3-7-6 of this chapter. (Ord. 2008-51, 6-10-2008) 3-7-9: TIME LIMIT ON SOLICITING: It is hereby declared to be unlawful and shall constitute a nuisance for any person, whether registered under this chapter or not, to go upon any premises and ring the doorbell upon or near any door of a residence located thereon, or rap or knock upon any door, or create any sound in any other manner calculated to attract the attention of the occupant of such residence, for the purpose of securing an audience with the occupant thereof and engage in "soliciting" as herein defined, before nine o'clock (9:00) A.M. or after eight o'clock (8:00) P.M., Monday through Friday, or prior to nine o'clock (9:00) A.M. or after five o'clock (5:00) P.M. on Saturday. There shall be no "soliciting", as defined in this chapter, on Sundays or on state or national holidays, except as follows: Itinerant merchants and hawkers not going door to door to residences may conduct business from nine o'clock (9:00) A.M. to eight thirty o'clock (8:30) P.M. Sunday through Saturday, including holidays. Individual owners and residents may further restrict the hours of soliciting on their property by posting a notice pursuant to section 3-7-6 of this chapter. (Ord. 2008-51, 6-10-2008) 3-7-10: ITINERANT MERCHANTS; PERMIT: In addition to the application fee set out in subsection 3-7-3F of this chapter, itinerant merchants shall be required to obtain a permit from the building and zoning department of Yorkville. Because of the nonpermanent nature of the structures being operated by itinerant merchants, itinerant merchants shall also be charged a fee of forty dollars ($40.00) to cover the costs and expenses of periodic safety inspections by the building department of the premises from which sales are being made. (Ord. 2008-51, 6-10-2008) 3-7-11: REVOCATION OF REGISTRATION: Any registration issued pursuant to this Chapter shall be immediately revoked upon a violation of Sections 3-7-8 or 3-7-9 of this Chapter 3. United City of Yorkville 800 Game Farm Road Yorkville, Illinois 60560 630-553-4350 Solicitor, Hawker, or Itinerant Merchant Registration Acknowledgement Form. I, ____________________________________ [insert name], having been approved to operate as a solicitor, hawker, or itinerant merchant in the United City of Yorkville, hereby acknowledge the following: 1)Permitted hours for Soliciting Monday – Friday from 9:00 a.m. – 8:00 p.m. Saturday from 9:00 a.m. – 5:00 p.m. 2)No soliciting on Sundays or Legal Holidays 3)No soliciting at any houses with “No Soliciting” signs posted I agree to follow these restrictions listed above as well as all regulations found in the Yorkville City Code, Title 3, Chapter 7: Solicitors, Hawkers, and Itinerant Merchants. _____________________________ Signature _____________________________ Print Name _____________________________ Date Proposed form for solicitors to sign VILLAGE OF MONTGOMERY ORDINANCE NO. 1859 _______________________________________________________________ AN ORDINANCE AMENDING CHAPTER 13 OF THE VILLAGE CODE VILLAGE OF MONTGOMERY, ILLINOIS (PEDDLERS, CANVASSERS AND SOLICITORS) _________________________________________________________________ PASSED BY THE PRESIDENT AND BOARD OF TRUSTEES OF THE VILLAGE OF MONTGOMERY, KANE AND KENDALL COUNTIES, ILLINOIS THIS ___ DAY OF _______, 2019. PUBLISHED IN PAMPHLET FORM BY AUTHORITY OF THE PRESIDENT AND BOARD OF TRUSTEES OF THE VILLAGE OF MONTGOMERY, KANE AND KENDALL COUNTIES, ILLINOIS, THIS __ DAY OF _______, 2019. Village of Montgomery - proposed solicitor revisions from their June 10th online meeting packet Page 2 of 10 ORDINANCE NO. 1859 AN ORDINANCE AMENDING CHAPTER 13 OF THE VILLAGE CODE VILLAGE OF MONTGOMERY, ILLINOIS (PEDDLERS, CANVASSERS AND SOLICITORS) BE IT ORDAINED by the President and Board of Trustees of the Village of Montgomery, Kane and Kendall Counties, Illinois, as follows: WHEREAS, the Village of Montgomery (“Village”) is not a home rule municipality within Article VII, Section 6A of the Illinois Constitution and accordingly, acts pursuant to the powers granted to it under 65 ILCS 5/1-1 et seq.; and, WHEREAS, the Village of Montgomery Village Code of Ordinances contains certain provisions providing for the regulation of peddlers, canvassers and solicitors within its corporate boundaries; and, WHEREAS, the Village finds that it is in the best interest of its residents to amend these provisions to clarify the requirements for registering for and maintaining solicitor registrations within the Village. NOW, THEREFORE, BE IT ORDAINED by the President and Board of Trustees of the Village of Montgomery, Kane and Kendall Counties, Illinois, as follows: SECTION ONE: TEXT AMENDMENT Chapter 13 – Peddlers, Canvassers, and Solicitors – shall be amended to read as follows: Chapter 13 - PEDDLERS, CANVASSERS AND SOLICITORS Sec. 13-1. - Registration of commercial canvassers or solicitors. It shall be unlawful for any person to engage in business as a canvasser or solicitor calling at residences in the village without the previous consent of the occupant when that canvasser or solicitor is engaging in any commercial enterprise such as soliciting orders, sales, subscriptions, or business of any kind, without having first registered in the office of the village clerk. Pursuant to section 13-8 hereof, religious, charitable, political, and other noncommercial canvassers and solicitors shall not be subject to this requirement when undertaking noncommercial canvassing or solicitation. Sec. 13-2. - Contents of registration. Before a certificate of registration may be issued under this chapter, a written sworn application signed by the applicant, if an individual; or by all partners, if a partnership; or by the Page 3 of 10 president of a corporation, if a corporation; or by a parent, if the applicant is under fourteen (14) years old, containing the following information must be submitted to the village clerk: 1.The applicant’s name, current address of residence, length of residence at such address, telephone number, business address if other than residence address, and date of birth; 2. Copy of current state photo identification or driver’s license; 3.Name, address, telephone number of the person, firm, corporation, or association whom the applicant is employed by or represents, and the length of time of such employment or representation; 4. A brief description of the nature of the business in which the applicant is engaged, and the kind of products or services to be sold or rendered; 5.Period of time for which the certificate is requested, and approximate hours of the day that such functions are to be performed; 6.The date, or approximate date, of the latest previous application for certificate under this chapter, if any; 7.A statement whether a certificate of registration, under the provisions of this chapter or any other similar ordinance of the Village or any county or municipality, has ever been revoked, together with the details thereof; 8.A statement whether the applicant and/or the person(s) managing or supervising the applicant’s business have/has ever been convicted of a felony or misdemeanor under the laws of the State of Illinois, or any other state or federal law of the United States, or a violation of any of the provisions of this chapter or the ordinance of any Illinois municipality regarding the activities of solicitors, hawkers, or iterant merchants, together with the details thereof; 9.The applicant’s Illinois business tax number as issued by the Illinois Department of Revenue. No certificate shall be issued if the applicant does not have an Illinois business tax number, unless the applicant represents or works for a religious, educational, or charitable organization where such organization is entirely a nonprofit organization and who can furnish the city with a tax-exempt number and proof of its tax-exempt status; 10. A photo that must be the same size as is required for passports (2” by 2”). The registrant shall give his complete identification, his signature, the name of his or her employer, the nature of the products or services in which he or she is interested, the names of the manufacturers of such products or of the organization which he or she is representing, and the proposed method of operation in the village. All statements made by the applicant upon the application or in connection therewith shall be under oath. The form of registration shall be supplied by the office of the village clerk, and shall be in substantially the following form: Page 4 of 10 Registration of ____________ Canvasser or Solicitor Fee $30.00> APPLICANT INFORMATION Name of applicant: _______________________ Date of Birth: _________________ Address of applicant (home): __________________ Length at residence: _____________ Applicant telephone number: __________________ BUSINESS INFORMATION Address of applicant (business): ________________ Business telephone number: ___________________ Business/Employer's name: ____________________ Length of time employed: ________ Business/Employer's address: ___________________ Illinois business tax number or tax-exempt number: ____________________________________ SOLICITATION INFORMATION Products/services to be sold/rendered: ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ Name of actual company offering products/services being sold, if different than above (for example, employer is ABC Marketing, but service being sold is electricity contracts from XYZ Energy): ______________________________________________________________________ Method of solicitation: ___________________________________________________________ Period of time for which permit is requested: _________________________________________ Approximate hours functions expected to be performed: ________________________________ Has the applicant or business previously applied for a permit with the Village? If so, when? ______________________________________________________________________________ Has the applicant and/or the person(s) managing or supervising the applicant’s business ever been Page 5 of 10 convicted of a felony or misdemeanor under the laws of the State of Illinois, or any other state or federal law of the United States, or a violation of any of the provisions of this chapter or the ordinance of any Illinois municipality regarding the activities of solicitors, hawkers, or iterant merchants? ______________________________________________________________________________ Has the applicant and/or business ever had a solicitor/canvasser permit revoked, either under the provisions of this chapter or pursuant to any other similar ordinance of any other county or municipality? If so, when? ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ I hereby authorize the Village of Montgomery to investigate and verify the information contained herein and waive any rights of privacy I may have to the information contained therein and indemnify and hold harmless the Village of Montgomery its officers, employees, agents and assigns for any and all claims or damages (including reasonable attorney’s fees) resulting from said investigation. I hereby certify and swear that all the above information is true and accurate. ________________________________________ (Signature) Subscribed and sworn to before me this ____________ day of ____________ 20 ____________ . ________________________________________ Notary Public Date of Application: Date of Registration: Date Registration Expires: ________________________________________ Registration No. Sec. 13-3. - Approval of registration, registration fee, duration. Upon submittal, the application shall be reviewed in its totality, considering all information obtained relative thereto. After consideration of the application, the police department shall, within ten (10) business days of application, approve or deny the application review the application within ten business days. Each applicant shall pay to the village clerk, a nonrefundable registration fee of $30.00. No certificate of registration shall be issued to any person who has been convicted of the commission of a felony under the laws of the State of Illinois or any other state or federal law in the United States, within five (5) years of the date of the application; nor to any person who has Page 6 of 10 been convicted of a violation of any of the provisions of this chapter, nor to any person whose certificate of registration issued hereunder has been previously revoked, as herein provided. If such a conviction is determined to be a part of the applicant's record, the village clerk shall deny said permit certificate of registration. If approved, the registration fee shall be for the period commencing on the date of issuance of said registration and expiring thirty (30) days after the date of said registration. If denied, the registration fee shall not be refunded. The office of the village clerk shall keep an accurate record of every application received and acted upon, together with all other information and data pertaining thereto, and all certificates of registration issued or applications denied. If the applicant does not provide the necessary information or qualify for such certificate of registration, pursuant to the provisions of this chapter, and the issuance of a certificate of registration to the applicant would not be in accord with the intent and purpose of this chapter, then the office of the village clerk shall deny the application. If denied, endorsement shall be made by the office of the village clerk upon the application. If the applicant provides the necessary information and is found to be fully qualified, the certificate of registration shall be issued within five (5) business days of the application approval so long as the application fees have been fully paid. Sec. 13-4. - Possession of certificate of registration; form. (a)Each person shall at all times, while engaged in the business of soliciting or canvassing in the village, carry and display (so as to be easily seen by any person) upon his or her person the registration certificate certificate of registration, and the same shall further be presented for additional review, by such registrant whenever he or she is required to do so by any police officer or by any person solicited. The solicitor identification certificate shall be in substantially the following form: (Front) VILLAGE OF MONTGOMERY, ILLINOIS SOLICITOR IDENTIFICATION Name ____________ Employer Company ____________ Company for whom products/services are being solicited ____________ Expires ____________ This is not an endorsement of Pproduct. No. ____________ Village Clerk (Back) This registration is valid for 30 days from issuance. Page 7 of 10 (b) Card must be displayed (so as to be easily seen by any person) and presented to any property owner or police officer. (c) Card may be revoked upon violation of any village ordinance, federal law, state law, or other applicable regulation, as more specifically set forth in Section 13-5. No one shall act as a canvasser or solicitor, or shall sell at residences without the previous consent of the occupant for the purpose of soliciting or canvassing except between the hours of 9:00 a.m. and 8:00 p.m. Monday through Saturday. No one shall act as a canvasser or solicitor, or shall sell at residences without the previous consent of the occupant for the purpose of soliciting or canvassing except between the hours of 10:00 a.m. and 5:00 p.m. on Sunday. Sec. 13-5. – Revocation of registration. Any registration may be revoked by the village clerk for the following reasons: because of any violation by the registrant of this chapter or of any other ordinances of the village, or of the state or federal law, or whenever the registrant shall cease to possess the qualifications or character required by this chapter for the original registrant. (a) violation of any provision of the Village Code of Ordinances, including the provisions of this chapter; (b) violation of any provision of State law; (c) violation of any provision of Federal law; (d) changes in the information provided on the registration application set forth in Section 13-2; (e) ceases to possess the character qualifications required by Section 13-3; (f) violation of any other applicable rule or regulation, or otherwise engages in behavior which the Village’s Police Department determines to be threatening or posing a danger to the Village and its residents. Sec. 13-6. - Hours. No one shall act as a canvasser or solicitor, or shall sell at residences without the previous consent of the occupant for the purpose of soliciting or canvassing except between the hours of 9:00 a.m. and 8:00 p.m., Monday through Saturday. No one shall act as a canvasser or solicitor, or shall sell at residences without the previous consent of the occupant for the purpose of soliciting or canvassing except between the hours of 10:00 a.m. and 5:00 p.m. on Sunday. Sec. 13-7. - Posting of no solicitors signs. (a) The owner or resident of any premises in the village shall determine whether solicitors shall be, or shall not be, invited onto his or her premises. Only solicitors having a valid certificate of registration shall engage in solicitation within the village unless said solicitor has previously been invited by an owner or resident of the premises. In the interest of safety, no child under the age of fourteen (14) shall be allowed to solicit in the village unless said child is supervised by an adult Page 8 of 10 who has registered pursuant to this chapter. (a) (b) Residents and other persons within the village shall be entitled to post a "No Solicitors”, “No Solicitation", or other similar sign on the property which they own or occupy, where it is reasonably visible to individuals who may approach the house, apartment, building or other edifice near or on which the sign is posted, in order to notify any such individual that no solicitation, canvassing or peddling of any type is desired by the occupant without the occupant's prior approval. (b) (c) It shall be unlawful for any person, whether engaging in commercial or noncommercial canvassing, solicitation, or other similar enterprise, to, when entering upon a premises which has a reasonably visible “No Solicitors” or other similar sign, continue with the attempted canvassing or solicitation. Upon sight of such sign, the canvasser or solicitor must leave the premises. If such sign is reasonably visible, the canvasser or solicitor shall be presumed to have seen the sign and shall be in violation of this chapter if he or she attempts his or her canvassing or solicitation. Any owner or resident may also restrict solicitation or limit the hours during which solicitors are invited to his or her residence by posting that intention as provided in this section. Such sign, so exhibited shall constitute sufficient notice to any solicitor of the owner’s or resident’s desire to restrict solicitation or to limit the solicitor’s hours. (d) Notwithstanding whether a sign has been posted, any solicitor is required to depart immediately upon request. Sec. 13-8. - Exceptions. Sections 13-1 through 13-5 of this chapter shall not apply to charitable, religious or political canvassers or solicitors, or any other noncommercial canvassers or solicitors. Sections 13-6 and 13-7 shall apply to all individuals undertaking any commercial or noncommercial canvassing or solicitation, with the exception that no part of this chapter shall apply to officers or employees of the village, county, state or federal governments, or any subdivision thereof, when on official business. Sec. 13-9. - Violations. (a) It is hereby unlawful and shall constitute a nuisance for any person, whether registered under this chapter or not, to go upon any premises and ring the doorbell upon or near any door, or create any sound in any manner calculated to attract the attention of the occupant’s of such residence, for the purpose of securing an audience with the occupant thereof, and engaging in soliciting as herein defined, in defiance of the notice exhibited at the residence in accordance with the provisions of this chapter. (b) It is hereby declared unlawful and shall constitute a nuisance for any person, whether registered under this chapter or not, to go upon any premises and ring the doorbell upon or near the door of a residence located thereon, or rap or knock upon any door, or create any sound in any other manner calculated to attract the attention of the occupant of such residence, for the Page 9 of 10 purpose of securing an audience with the occupant thereof and engage in soliciting as herein defined, outside of the hours set forth in Section 13-6. Individual owners and residents may further restrict the hours of soliciting on their property by posting a notice pursuant to section 13- 7 of this chapter. (c) It is hereby declared unlawful and shall constitute a nuisance for any person, whether registered under this chapter or not, to fail to depart from the premises upon the request of the owner/occupant. (d) Any person who shall violate any provision of this chapter is guilty of a petty offense for which the offender may be fined an amount in accordance with section 1-8 or 1-10 of this Code. For purposes of section 1-10, a violation hereof, shall be treated as a Type 2 offense. SECTION TWO: GENERAL PROVISIONS REPEALER: All ordinances or portions thereof in conflict with this Ordinance are hereby repealed. SEVERABILITY: Should any provision of this Ordinance be declared invalid by a court of competent jurisdiction; the remaining provisions will remain in full force and effect the same as if the invalid provision had not been a part of this Ordinance. EFFECTIVE DATE: This Ordinance shall be in full force and effect from and after its approval, passage and publication in pamphlet form as provided by law. PASSED AND APPROVED by the President and Board of Trustees of the Village of Montgomery, Kane and Kendall Counties, Illinois this ____ day of ___________, 2019. __________________________________________ Matthew Brolley President of the Board of Trustees of the Village of Montgomery ATTEST: __________________________________________ Penny Fitzpatrick Village Clerk of the Village of Montgomery Page 10 of 10 Aye Nay Absent Abstain Trustee Tom Betsinger ___ ___ ___ ___ Trustee Dan Gier ___ ___ ___ ___ Trustee Steve Jungermann ___ ___ ___ ___ Trustee Denny Lee ___ ___ ___ ___ Trustee Doug Marecek ___ ___ ___ ___ Trustee Theresa Sperling ___ ___ ___ ___ Village President Matthew Brolley ___ ___ ___ ___ 3-9-1: DEFINITIONS: For the purpose of this chapter, the following words as used herein shall be construed to have the meanings herein ascribed: COMMERCIAL GAIN: Any business, corporation, association or natural person established for pecuniary gain. LICENSED ITINERANT MERCHANT: Any person who has obtained a valid license as hereinafter provided, who is not otherwise exempted under this chapter and who upon private premises transports tangible personal property for retail sale or for a temporary period, establishes a display or sample room, or who occupies any kind of structure, building, room or vacant lot for the purposes of selling, offering or displaying for sale, or taking orders or subscriptions for future delivery of, tangible personal property, at retail and who does not maintain in this village an established office, distribution house, sales house, warehouse, service center or residence from which such business is conducted. LICENSED PEDDLER: Any person who has obtained a valid license as hereinafter provided, who is not otherwise exempted under this chapter and who travels from place to place within the village, by foot or by other conveyance, selling for profit or offering for sale, barter or exchange any commodity, article or service, and rendering immediate delivery thereof. LICENSED SOLICITOR: Any person who has obtained a valid license as hereinafter provided, who is not otherwise exempted under this chapter and who engages in any one or more of the following activities including: (A) Seeking to obtain orders for the purchase of any article, commodity, or service whatsoever, for any kind of consideration whatsoever; (B) Seeking to obtain prospective customers for application or purchase of insurance of any type, kind or character. (Ord. 10-55, 7-20-2010) 3-9-2: LICENSE REQUIRED: Every person or entity desiring to engage in peddling, soliciting or itinerant merchandising for commercial gain within the village is hereby required to make written application for a license as hereinafter provided, unless otherwise exempted hereunder. It shall be unlawful for any person to engage in peddling, soliciting or itinerant merchandising for commercial gain without having first obtained said license except as provided in subsection 3-9-4(H) of this chapter. (Ord. 10-55, 7-20-2010) Sterling Codifiers, Inc.https://sterlingcodifiers.com/codebook/printnow.php 1 of 6 6/11/2019, 4:45 PM Village of Oswego - current solicitor regulations 3-9-3: APPLICATION FOR LICENSE: (A) Application for a license shall be made upon a form provided by the village's police department and filed with such department. The applicant shall truthfully state in full the information requested on the application including: 1. Name, address of present place of residence of applicant, length of residence at such address, business address if other than residence address, and social security number; 2. Address of place of residence of applicant during the past three (3) years if other than present address; 3. State issued photo ID card for proof of identity and verification of age of the applicant; 4. Physical description of applicant; 5. Name and address of the person, firm, corporation or association whom the applicant is employed by or represents; and the length of time of such employment or representation; 6. Name and address of employer of the applicant during the past three (3) years if other than the present employer; 7. Description sufficient for identification of the subject matter of the peddler, solicitor or itinerant merchant which the applicant will engage in; 8. Period of time for which license is applied for; 9. The date, or approximate date, of the latest previous application for license under this chapter, if any; 10. Whether a license issued to the applicant under this chapter has ever been denied or revoked; 11. Whether the applicant has ever been convicted of a violation of any of the provisions of this chapter or an ordinance of any other Illinois municipality regulating peddling, soliciting, or itinerant merchandising; 12. Whether the applicant has ever been convicted of a felony under the laws of the State of Illinois or any other State or Federal law of the United States; 13. The applicant shall provide a full set of fingerprints for the purposes of conducting a background investigation. (B) All statements made by the applicant upon the application or in connection therewith shall be under oath. (C) The Chief of Police or designee shall require applicants to submit to fingerprinting by the Police Department in connection with the application for license. (Ord. 10-55, 7-20-2010) Sterling Codifiers, Inc.https://sterlingcodifiers.com/codebook/printnow.php 2 of 6 6/11/2019, 4:45 PM (D) The Chief of Police or designee shall cause to be kept in his/her office an accurate record of every application received and acted upon together with all other information and data pertaining thereto and all licenses issued under the provisions of this chapter and of the denial of applications. (Ord. 17-36, 8-1-2017) (E) No license shall be issued to any person who has been convicted of a felony under the laws of the State of Illinois or any other State or Federal law of the United States, within five (5) years of the date of the application; nor to any person who has an active, unpaid violation or conviction of any provision of this chapter, nor to any person whose license hereunder has previously been revoked as herein provided, nor to any person convicted of a crime involving dishonesty, fraud, deception or similar offense. (Ord. 10-55, 7-20-2010) 3-9-4: LICENSE FEES: (A) Monthly Or Annual License: Any applicant seeking a license hereunder may apply for a license monthly (1 month) or annually (1 year), which fees shall be as follows: Annual $100.00 Monthly 50.00 (B) Number Of Applicants Covered: The annual and monthly fee shall be applied to each license listing up to five (5) applicants. An additional five dollars ($5.00) per person shall apply to the sixth and each consecutive applicant per license. (C) Fingerprint Fee: A fingerprint fee of forty dollars ($40.00) per person for a fingerprint of nonresident or nonbusiness owner(s) shall apply to each person listed in a license application. An additional fee, per person, will apply for all Livescan fingerprint submittals; said fee amount will be determined by the Illinois State Police. (Ord. 15-61, 10-20-2015) (D) Nonrefundable: All fees are nonrefundable and shall be paid at the time application is made. (E) Prior Payment: No license shall be issued without prior payment of fees. (F) Insurance Companies: No license fee shall be required of insurance companies or their agents. (G) Bond Required; Itinerant Merchant: 1. Itinerant merchants shall be required to file with the Chief of Police or designee a surety bond or a cash deposit in an amount not less than fifty percent (50%) of the wholesale value of the merchandise that the applicant intends to offer for sale. Such bond or deposit to be held for the benefit of any person who suffers loss or damage as a result of the purchase of Sterling Codifiers, Inc.https://sterlingcodifiers.com/codebook/printnow.php 3 of 6 6/11/2019, 4:45 PM merchandise from said person licensed under this chapter or as the result of the negligent or intentionally tortuous act of the person licensed under this chapter. Action on the bond or deposit may be brought by any person. Surety bonds may not expire sooner than two (2) years from December 31 following the issuance of the license under this chapter. The Village shall transfer the bond or deposit to the Attorney General of the State of Illinois within fourteen (14) days after the applicant ceases to do business in the Village, pursuant to the law. 2. No license shall be issued until the surety bond or cash deposit has been filed with the Chief of Police or designee. (H) Exemptions: 1. Prior Invitation: Any person who, for the purposes of selling or taking orders for sale of merchandise or services, has been previously invited by the occupant of a residence to call thereon. 2. Newspaper, Book And Periodical Vendors: Any person who sells or distributes any newspaper, book or other periodical. 3. Farmer, Fruit And Vine Grower And Gardener: Any farmer, fruit and vine grower or gardener, who sells the products of their own farm, orchard, vineyard or garden, provided he does not obstruct streets, sidewalks or other public places within the Village. 4. Nonprofit Organizations: Any person engaged in peddling or soliciting which is not prohibited by law on behalf of a charitable, religious or nonprofit organization organized as a not for profit corporation under State or Federal law. 5. First Amendment Activities: Any person exercising their first amendment rights, including the free exercise of religion, the freedom of speech or press, the right of assembly and not engaged in peddling, soliciting or itinerant merchandising for commercial gain. (Ord. 10-55, 7-20-2010) 3-9-5: ISSUANCE OF LICENSE: Upon receipt of any application for a license hereunder, the Chief of Police or designee shall, within three (3) business days of the applicant submitting to fingerprinting at the Village of Oswego Police Department, issue the license to any applicant hereunder, provided that the applicant has complied with all application requirements, paid all fees pursuant to this chapter, and no grounds exist to deny the license pursuant to subsection 3-9-3(E) of this chapter. If any application for a license is denied, the Chief of Police or designee shall so notify the applicant in writing by stating the specific reason(s) for such denial. An annual license shall be valid for a period of one (1) year from the date in which said license is issued. A monthly license shall be valid for a period of thirty (30) days from the date of its issuance. Any license issued hereunder shall be nontransferable and shall not be prorated. (Ord. 10-55, 7-20-2010) Sterling Codifiers, Inc.https://sterlingcodifiers.com/codebook/printnow.php 4 of 6 6/11/2019, 4:45 PM 3-9-6: PENALTIES: Any person found liable/guilty by a preponderance of the evidence of a violation of this chapter in an administrative/judicial hearing shall be subject to a Class IV fine, plus applicable hearing costs, as provided in subsection 1-4-3(G) of this Code. (Ord. 10-55, 7-20-2010) 3-9-7: NOTICE REGULATING PEDDLING AND SOLICITING: Every person desiring to secure the protection intended to be provided by the regulations pertaining to peddling and soliciting contained in this chapter shall comply with the following directions: (A) Any owner or resident may restrict peddling and/or soliciting or limit the hours during which peddlers and/or solicitors are invited to his or her residence by posting that intention as provided in this section. (Ord. 10-55, 7-20-2010) (B) Notice of the determination by the occupant of the refusal of invitation to peddlers and/or solicitors or a restriction to peddlers and/or solicitors or a restriction on hours during which peddlers and/or solicitors are invited at any residence, shall be given in the following manner: 1. A weatherproof card, approximately three inches by four inches (3" x 4") in size, shall be exhibited upon or near the main entrance door to the residence, indicating the determination of the occupant, in substantially the following: NO PEDDLERS AND/OR SOLICITORS INVITED or PEDDLING AND/OR SOLICITING LIMITED TO THE HOURS OF . 2. The letters shall be at least one-third inch (1/3") in height. 3. Such card, or similar sign, so exhibited shall constitute notice to any peddler and/or solicitor of the determination by the occupant of the residence of the information contained thereon. (Ord. 17-36, 8-1-2017) 3-9-8: DUTY OF PEDDLERS AND SOLICITORS: (A) It shall be the duty of every peddler and solicitor upon going onto any premises in the Village to first examine the notice provided for in section 3-9-7 of this chapter, if any is given or attached, and be governed by the statement contained on the notice. It is hereby declared to be unlawful and shall constitute a nuisance for any person to go upon any premises and ring the doorbell upon or near any door, in defiance of the notice exhibited at the residence in accordance with the provisions of section 3-9-7 of this chapter. If the peddler or solicitor is calling during a time when the resident has restricted peddling and/or solicitation or a notice pursuant to section Sterling Codifiers, Inc.https://sterlingcodifiers.com/codebook/printnow.php 5 of 6 6/11/2019, 4:45 PM 3-9-7 of this chapter is posted, then the peddler or solicitor whether registered or not, shall immediately and peacefully depart from the premises. Any peddler or solicitor who has gained entrance to or who is on any premises, whether invited or not, shall immediately and peacefully depart from the premises when requested to do so by the occupant. Peddling and soliciting on streets or ways or in public areas is expressly prohibited. (Ord. 10-55, 7-20-2010; amd. Ord. 15-61, 10-20-2015) (B) Any person licensed pursuant to this chapter shall, at all times while engaged in the activities defined herein, keep said license in his possession and shall display the same upon the demand of any police officer or upon the request of any person whose premises he seeks to enter. (Ord. 10-55, 7-20-2010) 3-9-9: TIME LIMIT ON PEDDLING AND SOLICITING: It is hereby declared to be unlawful and shall constitute a nuisance for any person whether registered under this chapter or not, to go upon any premises and ring the doorbell upon or near any door of a residence located thereon, or rap or knock upon any door, or create any sound in any other manner calculated to attract the attention of the occupant of such residence, for the purposes of securing an audience with the occupant thereof and engage in "peddling", or "soliciting" as herein defined, before nine o'clock (9:00) A.M. or after seven o'clock (7:00) P.M., Monday through Friday, or prior to nine o'clock (9:00) A.M. or after five o'clock (5:00) P.M. on Saturday, or at any time on a Sunday or on a State or national holiday. (Ord. 10-55, 7-20-2010) 3-9-10: LIMITATIONS ON PEDDLING AND SOLICITING IN STREETS: No person shall stand on a highway within the Village for the purpose of soliciting contributions or selling anything to occupants of any vehicle. (Ord. 15-61, 10-20-2015) Sterling Codifiers, Inc.https://sterlingcodifiers.com/codebook/printnow.php 6 of 6 6/11/2019, 4:45 PM Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #11 Tracking Number ADM 2019-35 Facilities Master Plan RFQ Administration Committee – June 19, 2019 Materials will be presented at the meeting. Bart Olson Administration Name Department