Loading...
Administration Committee Packet 2020 07-15-20 AGENDA ADMINISTRATION COMMITTEE MEETING Wednesday, July 15, 2020 6:00 p.m. City Hall Conference Room 800 Game Farm Road, Yorkville, IL Citizen Comments: Minutes for Correction/Approval: June 17, 2020 New Business: 1. ADM 2020-45 Budget Report for June 2020 2. ADM 2020-46 Treasurer’s Report for June 2020 3. ADM 2020-47 Cash Statement for May 2020 4. ADM 2020-48 Website Report for June 2020 5. ADM 2020-49 4th Quarter Budget Review – Fiscal Year 2020 6. ADM 2020-50 Fiscal Year 2020 Budget Amendment – Downtown TIF II 7. ADM 2020-51 Ordinance Amending City Code Regarding Contracts and Purchases (Phase 2) Old Business: 1. ADM 2020-37 School District – IGA 2. ADM 2020-39 Governing Ordinance – Discussion of Review and Changes Additional Business: 2019/2020 City Council Goals - Administration Committee Goal Priority Staff “Staffing” 1 Bart Olson, Rob Fredrickson, James Jensen, Eric Dhuse, Tim Evans & Erin Willrett “Municipal Building Needs and Planning” 2 Bart Olson, Rob Fredrickson, James Jensen, 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 800 Game Farm Road Yorkville, Illinois 60560 Telephone: 630-553-4350 www.yorkville.il.us UNITED CITY OF YORKVILLE WORKSHEET ADMINISTRATION COMMITTEE Wednesday, July 15, 2020 6:00 PM CITY HALL CONFERENCE ROOM --------------------------------------------------------------------------------------------------------------------------------------- CITIZEN COMMENTS: --------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------- MINUTES FOR CORRECTION/APPROVAL: --------------------------------------------------------------------------------------------------------------------------------------- 1. June 17, 2020 □ Approved __________ □ As presented □ With corrections --------------------------------------------------------------------------------------------------------------------------------------- NEW BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2020-45 Budget Report for June 2020 □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2020-46 Treasurer’s Report for June 2020 □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 3. ADM 2020-47 Cash Statement for May 2020 □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 4. ADM 2020-48 Website Report for June 2020 □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 5. ADM 2020-49 4th Quarter Budget Review – Fiscal Year 2020 □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 6. ADM 2020-50 Fiscal Year 2020 Budget Amendment – Downtown TIF II □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 7. ADM 2020-51 Ordinance Amending City Code Regarding Contracts and Purchases (Phase 2) □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- OLD BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2020-37 School District – IGA □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2020-39 Governing Ordinance – Discussion of Review and Changes □ 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 – June 17, 2020 Administration Committee – July 15, 2020 Majority Committee Approval Minute Taker Name Department Page 1 of 2 DRAFT UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE MEETING Wednesday, June 17, 2020 6:00pm City Hall Conference Room 800 Game Farm Road, Yorkville, IL Note: This meeting was held in accordance with Governor Pritzker's Executive Order #2020-07, extended by Orders # 2020-33 and 2020-39. These Orders allow remote attendance to encourage social distancing related to the Covid-19 pandemic. Committee Members In Attendance: Chairman Chris Funkhouser-remote Alderman Jason Peterson-remote Alderman Joe Plocher-remote Absent: Alderman Dan Transier Other City Officials In Attendance: City Administrator Bart Olson-remote Assistant City Administrator Erin Willrett-remote Finance Director Rob Fredrickson-in-person attendance Others in Attendance: Tyler Bachman, WSPY-remote The meeting was called to order at 6:00pm by Chairman Chris Funkhouser. Citizen Comments: None Minutes for Correction/Approval: May 20, 2020 The minutes were approved as presented. New Business: 1. ADM 2020-40 Budget Report for May 2020 Administrator Olson presented the budget report which was updated with the various tax information. He said the taxes were better than expected in spite of the pandemic After next month's report, the city will have a better idea of the overall FY 2021 budget and if budget cuts will be needed. He said the food businesses are doing better than expected since people are staying in town and buying locally in general. He added that loss of jobs could impact the numbers farther into the year. For information. Page 2 of 2 2. ADM 2020-41 Treasurer's Report for May 2020 Mr. Fredrickson reported the below revenue figures. $1,529,011 YTD Revenues $1,763,918 YTD Expenses He added that final numbers for the FY will be presented in August or September with with final audit numbers in October. This moves forward to City Council. 3. ADM 2020-42 Cash Statement for April 2020 This is informationl with cash balances and investments reflected in the report. No further discussion. 4. ADM 2020-43 Website Report for May 2020 The trend is upward even without the planned festivals, said Ms. Willrett. The highest number of posts, 30,000, was registered on the city pages regarding the list of outdoor dining options due to the pandemic. Parks & Rec and the police department have also had several postings. This is informational. 5. ADM 2020-44 Required Reporting to Municipality by Yorkville Police Pension Board Mr. Fredrickson said this is standard reporting required each year, usually in May. The Fund's assets went up 12% to about $10.5 million and since they have exceed $10 million they can increase their investments. He said the Fund had a good year and he expects it to grow in the fall. This proceeds to City Council, though no action is required by them. Old Business: 1. ADM 2020-38 Cable Consortium – Exit and Moving Forward - Discussion of Review and Changes In early June, the City notifed the Consortium that their membership would continue only through June. However, now a memo has been prepared to ask the City Council to continue in the Consortium a few more months to consider options. Plano, Sandwich and Yorkville School District have expressed interest in joining together with Yorkville for services similar to the Consortium. Mr. Olson said the remaining money, $30,000- $40,000, could be used as a starter fund for equipment and the remaining Consortium equipment could be liquidated or shared. In moving this forward to the Council, a resolution or motion would be made by the Council to rescind the previously recommended withdrawal action and continue in the Consortium a few more months. 2. ADM 2020-39 Governing Ordinance – Discussion of Review and Changes This is tabled until next month. Additional Business: None There was no further business and the meeting adjourned at 6:18pm. Respectfully transcribed byMarlys Young, Minute Taker, remote 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 2020-45 Budget Report for June 2020 Administration Committee – July 15, 2020 Informational None Monthly budget reports and income statements. Rob Fredrickson Finance Name Department % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget GENERAL FUND REVENUES Taxes 01-000-40-00-4000 PROPERTY TAXES - 1,002,375 1,002,375 2,107,099 47.57% 01-000-40-00-4010 PROPERTY TAXES-POLICE PENSION - 585,372 585,372 1,230,604 47.57% 01-000-40-00-4030 MUNICIPAL SALES TAX 231,048 253,657 484,704 3,284,400 14.76% 01-000-40-00-4035 NON-HOME RULE SALES TAX 152,373 178,045 330,417 2,493,900 13.25% 01-000-40-00-4040 ELECTRIC UTILITY TAX - 150,649 150,649 715,000 21.07% 01-000-40-00-4041 NATURAL GAS UTILITY TAX 22,870 15,924 38,794 265,000 14.64% 01-000-40-00-4043 EXCISE TAX 20,790 21,150 41,939 246,075 17.04% 01-000-40-00-4044 TELEPHONE UTILITY TAX 695 695 1,390 8,340 16.67% 01-000-40-00-4045 CABLE FRANCHISE FEES 63,267 - 63,267 300,000 21.09% 01-000-40-00-4050 HOTEL TAX 1,239 1,808 3,047 80,000 3.81% 01-000-40-00-4055 VIDEO GAMING TAX 7,193 - 7,193 140,000 5.14% 01-000-40-00-4060 AMUSEMENT TAX - 21 21 205,000 0.01% 01-000-40-00-4065 ADMISSIONS TAX - - - 145,000 0.00% 01-000-40-00-4070 BDD TAX - KENDALL MARKETPLACE 22,569 23,876 46,445 365,160 12.72% 01-000-40-00-4071 BDD TAX - DOWNTOWN 1,847 5,349 7,196 30,000 23.99% 01-000-40-00-4072 BDD TAX - COUNTRYSIDE 1,898 1,613 3,511 10,000 35.11% 01-000-40-00-4075 AUTO RENTAL TAX 1,247 9 1,256 15,250 8.24% Intergovernmental 01-000-41-00-4100 STATE INCOME TAX 191,781 118,791 310,572 1,897,310 16.37% 01-000-41-00-4105 LOCAL USE TAX 47,285 60,149 107,434 675,281 15.91% 01-000-41-00-4106 CANNABIS EXCISE TAX 896 694 1,591 15,218 10.45% 01-000-41-00-4110 ROAD & BRIDGE TAX - 26,084 26,084 130,000 20.06% 01-000-41-00-4120 PERSONAL PROPERTY TAX 2,414 - 2,414 16,500 14.63% 01-000-41-00-4160 FEDERAL GRANTS 1,723 788 2,511 14,925 16.82% 01-000-41-00-4168 STATE GRANT - TRF SIGNAL MAINT 18,553 - 18,553 20,000 92.76% 01-000-41-00-4170 STATE GRANTS - - - - 0.00% 01-000-41-00-4182 MISC INTERGOVERNMENTAL - - - 1,000 0.00% Licenses & Permits 01-000-42-00-4200 LIQUOR LICENSES 3,081 1,965 5,046 65,000 7.76% 01-000-42-00-4205 OTHER LICENSES & PERMITS 310 2,647 2,957 9,500 31.12% 01-000-42-00-4210 BUILDING PERMITS 39,882 41,019 80,900 400,000 20.23% Fines & Forfeits 01-000-43-00-4310 CIRCUIT COURT FINES 863 2,087 2,950 40,000 7.38% 01-000-43-00-4320 ADMINISTRATIVE ADJUDICATION 2,284 1,237 3,521 27,500 12.80% 01-000-43-00-4323 OFFENDER REGISTRATION FEES - - - 500 0.00% 01-000-43-00-4325 POLICE TOWS 3,000 6,000 9,000 45,000 20.00% Charges for Service 01-000-44-00-4400 GARBAGE SURCHARGE 482 221,192 221,674 1,297,650 17.08% 01-000-44-00-4405 UB COLLECTION FEES 13,942 25,982 39,924 165,000 24.20% 01-000-44-00-4407 LATE PENALTIES - GARBAGE - 2 2 25,000 0.01% 01-000-44-00-4415 ADMINISTRATIVE CHARGEBACK 17,825 17,825 35,649 213,896 16.67% 01-000-44-00-4474 POLICE SPECIAL DETAIL - - - 500 0.00% UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 1 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 Investment Earnings 01-000-45-00-4500 INVESTMENT EARNINGS 2,021 1,561 3,582 89,878 3.99% Reimbursements 01-000-46-00-4604 REIMB - ENGINEERING EXPENSES - - - 25,000 0.00% 01-000-46-00-4680 REIMB - LIABILITY INSURANCE 4,886 5,585 10,471 15,000 69.81% 01-000-46-00-4685 REIMB - CABLE CONSORTIUM - - - 36,000 0.00% 01-000-46-00-4690 REIMB - MISCELLANEOUS 4,763 178 4,941 12,000 41.17% Miscellaneous 01-000-48-00-4820 RENTAL INCOME - - - 7,000 0.00% 01-000-48-00-4850 MISCELLANEOUS INCOME - 16,501 16,501 13,000 126.93% Other Financing Uses 01-000-49-00-4916 TRANSFER FROM CW MUNICIPAL BLDG - - - 35,000 0.00% TOTAL REVENUES: GENERAL FUND 883,025 2,790,828 3,673,853 16,933,486 21.70% ADMINISTRATION EXPENDITURES Salaries & Wages 01-110-50-00-5001 SALARIES - MAYOR 825 960 1,785 10,500 17.00% 01-110-50-00-5002 SALARIES - LIQUOR COMM 83 83 167 1,000 16.67% 01-110-50-00-5005 SALARIES - ALDERMAN 3,900 5,080 8,980 50,000 17.96% 01-110-50-00-5010 SALARIES - ADMINISTRATION 59,330 43,903 103,233 550,247 18.76% Benefits 01-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION 6,636 4,912 11,548 62,251 18.55% 01-110-52-00-5214 FICA CONTRIBUTION 4,789 3,724 8,512 43,010 19.79% 01-110-52-00-5216 GROUP HEALTH INSURANCE 13,730 9,770 23,500 97,664 24.06% 01-110-52-00-5222 GROUP LIFE INSURANCE 36 36 71 428 16.67% 01-110-52-00-5223 GROUP DENTAL INSURANCE 591 591 1,182 7,089 16.67% 01-110-52-00-5224 VISION INSURANCE 188 94 282 1,130 25.00% Contractual Services 01-110-54-00-5412 TRAINING & CONFERENCES 1,890 - 1,890 16,000 11.81% 01-110-54-00-5415 TRAVEL & LODGING - - - 10,000 0.00% 01-110-54-00-5426 PUBLISHING & ADVERTISING - - - 4,000 0.00% 01-110-54-00-5430 PRINTING & DUPLICATION - 86 86 3,250 2.65% 01-110-54-00-5440 TELECOMMUNICATIONS - 634 634 22,300 2.84% 01-110-54-00-5448 FILING FEES - - - 500 0.00% 01-110-54-00-5451 CODIFICATION - - - 10,000 0.00% 01-110-54-00-5452 POSTAGE & SHIPPING 37 48 85 3,000 2.83% 01-110-54-00-5460 DUES & SUBSCRIPTIONS 1,252 6,747 7,999 22,000 36.36% 01-110-54-00-5462 PROFESSIONAL SERVICES - 748 748 12,000 6.23% 01-110-54-00-5480 UTILITIES - 276 276 31,800 0.87% 01-110-54-00-5485 RENTAL & LEASE PURCHASE 338 226 564 3,000 18.80% 01-110-54-00-5488 OFFICE CLEANING - 1,091 1,091 12,181 8.95% Supplies 01-110-56-00-5610 OFFICE SUPPLIES - 165 165 19,000 0.87% TOTAL EXPENDITURES: ADMINISTRATION 93,625 79,173 172,797 992,350 17.41% 2 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 FINANCE EXPENDITURES Salaries & Wages 01-120-50-00-5010 SALARIES & WAGES 32,610 24,603 57,213 324,856 17.61% Benefits 01-120-52-00-5212 RETIREMENT PLAN CONTRIBUTION 3,659 2,765 6,424 36,752 17.48% 01-120-52-00-5214 FICA CONTRIBUTION 2,441 1,834 4,275 23,420 18.26% 01-120-52-00-5216 GROUP HEALTH INSURANCE 8,703 3,595 12,297 57,566 21.36% 01-120-52-00-5222 GROUP LIFE INSURANCE 20 20 41 246 16.66% 01-120-52-00-5223 DENTAL INSURANCE 384 384 767 4,604 16.67% 01-120-52-00-5224 VISION INSURANCE 118 59 177 707 25.01% Contractual Services 01-120-54-00-5412 TRAINING & CONFERENCES 285 (255) 30 3,500 0.86% 01-120-54-00-5414 AUDITING SERVICES - - - 31,400 0.00% 01-120-54-00-5415 TRAVEL & LODGING - - - 600 0.00% 01-120-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - 1,957 0.00% 01-120-54-00-5430 PRINTING & DUPLICATING - 29 29 3,500 0.82% 01-120-54-00-5440 TELECOMMUNICATIONS - 176 176 1,000 17.64% 01-120-54-00-5452 POSTAGE & SHIPPING 78 79 156 1,200 13.03% 01-120-54-00-5460 DUES & SUBSCRIPTIONS 10 - 10 1,500 0.67% 01-120-54-00-5462 PROFESSIONAL SERVICES 2,132 1,718 3,851 65,000 5.92% 01-120-54-00-5485 RENTAL & LEASE PURCHASE 312 113 426 2,200 19.34% Supplies 01-120-56-00-5610 OFFICE SUPPLIES - 133 133 2,500 5.34% TOTAL EXPENDITURES: FINANCE 50,753 35,253 86,006 562,508 15.29% POLICE EXPENDITURES Salaries & Wages 01-210-50-00-5008 SALARIES - POLICE OFFICERS 209,346 167,921 377,267 1,981,203 19.04% 01-210-50-00-5011 SALARIES - POLICE CHIEF & DEPUTIES 43,819 31,212 75,031 394,401 19.02% 01-210-50-00-5012 SALARIES - SERGEANTS 57,145 42,771 99,915 664,437 15.04% 01-210-50-00-5013 SALARIES - POLICE CLERKS 19,438 12,988 32,426 183,567 17.66% 01-210-50-00-5014 SALARIES - CROSSING GUARD - - - 30,000 0.00% 01-210-50-00-5015 PART-TIME SALARIES 6,738 3,789 10,526 70,000 15.04% 01-210-50-00-5020 OVERTIME 4,467 12,682 17,149 111,000 15.45% Benefits 01-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION 2,171 1,451 3,622 20,767 17.44% 01-210-52-00-5213 EMPLOYER CONTRI - POL PEN - 585,372 585,372 1,230,604 47.57% 01-210-52-00-5214 FICA CONTRIBUTION 25,219 19,974 45,193 253,963 17.80% 01-210-52-00-5216 GROUP HEALTH INSURANCE 102,203 48,874 151,077 648,780 23.29% 01-210-52-00-5222 GROUP LIFE INSURANCE 218 218 436 2,714 16.06% 01-210-52-00-5223 DENTAL INSURANCE 3,309 3,274 6,582 41,677 15.79% 01-210-52-00-5224 VISION INSURANCE 1,042 518 1,560 6,602 23.63% Contractual Services 01-210-54-00-5410 TUITION REIMBURSEMENT - 4,824 4,824 15,000 32.16% 01-210-54-00-5411 POLICE COMMISSION - - - 17,250 0.00% 3 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 01-210-54-00-5412 TRAINING & CONFERENCES - - - 25,500 0.00% 01-210-54-00-5415 TRAVEL & LODGING - - - 10,000 0.00% 01-210-54-00-5422 VEHICLE & EQUIPMENT CHARGEBACK 3,654 3,654 7,307 43,844 16.67% 01-210-54-00-5430 PRINTING & DUPLICATING - - - 5,000 0.00% 01-210-54-00-5440 TELECOMMUNICATIONS - 56 56 42,000 0.13% 01-210-54-00-5452 POSTAGE & SHIPPING 18 273 291 1,200 24.24% 01-210-54-00-5460 DUES & SUBSCRIPTIONS 5,113 30 5,143 10,700 48.06% 01-210-54-00-5462 PROFESSIONAL SERVICES - 4,681 4,681 36,750 12.74% 01-210-54-00-5467 ADJUDICATION SERVICES - 5,750 5,750 20,000 28.75% 01-210-54-00-5469 NEW WORLD LIVE SCAN - 100 100 2,000 5.00% 01-210-54-00-5472 KENDALL CO. JUVE PROBATION - - - 4,000 0.00% 01-210-54-00-5485 RENTAL & LEASE PURCHASE 444 411 855 5,600 15.27% 01-210-54-00-5488 OFFICE CLEANING - 1,091 1,091 12,181 8.95% 01-210-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - 3,050 3,050 60,000 5.08% Supplies 01-210-56-00-5600 WEARING APPAREL - 109 109 15,000 0.73% 01-210-56-00-5610 OFFICE SUPPLIES - 152 152 4,500 3.38% 01-210-56-00-5620 OPERATING SUPPLIES - 1,324 1,324 16,500 8.02% 01-210-56-00-5650 COMMUNITY SERVICES - - - 1,500 0.00% 01-210-56-00-5690 BALLISTIC VESTS - 125 125 3,850 3.25% 01-210-56-00-5695 GASOLINE - - - 63,130 0.00% 01-210-56-00-5696 AMMUNITION - 4,359 4,359 9,000 48.44% TOTAL EXPENDITURES: POLICE 484,342 961,032 1,445,374 6,064,220 23.83% COMMUNITY DEVELOPMENT EXPENDITURES Salaries & Wages 01-220-50-00-5010 SALARIES & WAGES 55,320 49,488 104,809 535,995 19.55% Benefits 01-220-52-00-5212 RETIREMENT PLAN CONTRIBUTION 6,213 5,561 11,774 60,639 19.42% 01-220-52-00-5214 FICA CONTRIBUTION 4,104 3,681 7,785 39,552 19.68% 01-220-52-00-5216 GROUP HEALTH INSURANCE 14,564 6,161 20,725 93,545 22.16% 01-220-52-00-5222 GROUP LIFE INSURANCE 35 35 70 446 15.68% 01-220-52-00-5223 DENTAL INSURANCE 542 542 1,084 6,505 16.67% 01-220-52-00-5224 VISION INSURANCE 180 90 270 1,081 24.99% Contractual Services 01-220-54-00-5412 TRAINING & CONFERENCES - (1,495) (1,495) 7,300 -20.48% 01-220-54-00-5415 TRAVEL & LODGING - - - 6,500 0.00% 01-220-54-00-5426 PUBLISHING & ADVERTISING - - - 2,500 0.00% 01-220-54-00-5430 PRINTING & DUPLICATING - 44 44 1,500 2.92% 01-220-54-00-5440 TELECOMMUNICATIONS - 107 107 4,000 2.68% 01-220-54-00-5452 POSTAGE & SHIPPING 16 5 21 500 4.24% 01-220-54-00-5459 INSPECTIONS - - - 70,000 0.00% 01-220-54-00-5460 DUES & SUBSCRIPTIONS 2,031 - 2,031 2,750 73.87% 01-220-54-00-5462 PROFESSIONAL SERVICES - 53 53 92,500 0.06% 4 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 01-220-54-00-5485 RENTAL & LEASE PURCHASE 189 189 378 3,150 12.01% 01-220-54-00-5490 VEHICLE MAINTENANCE SERVICES - 575 575 4,000 14.38% 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 - 320 320 4,441 7.20% TOTAL EXPENDITURES: COMMUNITY DEVELP 83,195 65,356 148,551 942,154 15.77% PUBLIC WORKS - STREET OPERATIONS EXPENDITURES Salaries & Wages 01-410-50-00-5010 SALARIES & WAGES 47,751 36,028 83,779 516,943 16.21% 01-410-50-00-5015 PART-TIME SALARIES - - - 12,500 0.00% 01-410-50-00-5020 OVERTIME - 304 304 20,000 1.52% Benefits 01-410-52-00-5212 RETIREMENT PLAN CONTRIBUTION 5,334 4,058 9,392 60,746 15.46% 01-410-52-00-5214 FICA CONTRIBUTION 3,524 2,657 6,182 40,268 15.35% 01-410-52-00-5216 GROUP HEALTH INSURANCE 18,936 8,788 27,724 134,105 20.67% 01-410-52-00-5222 GROUP LIFE INSURANCE 36 36 73 499 14.60% 01-410-52-00-5223 DENTAL INSURANCE 610 610 1,220 8,474 14.40% 01-410-52-00-5224 VISION INSURNCE 192 96 287 1,326 21.66% Contractual Services 01-410-54-00-5412 TRAINING & CONFERENCES - 210 210 4,500 4.67% 01-410-54-00-5415 TRAVEL & LODGING - - - 2,500 0.00% 01-410-54-00-5422 VEHICLE EQUIPMENT CHARGEBACK 11,879 11,879 23,759 142,551 16.67% 01-410-54-00-5435 TRAFFIC SIGNAL MAINTENANCE - - - 20,000 0.00% 01-410-54-00-5440 TELECOMMUNICATIONS - 274 274 7,600 3.60% 01-410-54-00-5455 MOSQUITO CONTROL - - - 6,300 0.00% 01-410-54-00-5458 TREE & STUMP MAINTENANCE - - - 13,000 0.00% 01-410-54-00-5462 PROFESSIONAL SERVICES 367 669 1,036 9,225 11.23% 01-410-54-00-5483 JULIE SERVICES - - - 3,000 0.00% 01-410-54-00-5485 RENTAL & LEASE PURCHASE 69 92 161 6,000 2.69% 01-410-54-00-5488 OFFICE CLEANING - 108 108 788 13.64% 01-410-54-00-5490 VEHICLE MAINTENANCE SERVICES - 3,432 3,432 65,000 5.28% Supplies 01-410-56-00-5600 WEARING APPAREL - 703 703 5,000 14.06% 01-410-56-00-5620 OPERATING SUPPLIES - 1,258 1,258 19,450 6.47% 01-410-56-00-5628 VEHICLE MAINTENANCE SUPPLIES 136 835 972 42,000 2.31% 01-410-56-00-5630 SMALL TOOLS & EQUIPMENT - 323 323 7,500 4.31% 01-410-56-00-5640 REPAIR & MAINTENANCE - 366 366 24,000 1.52% 01-410-56-00-5665 JULIE SUPPLIES - - - 2,234 0.00% 01-410-56-00-5695 GASOLINE - 410 410 25,726 1.59% TOTAL EXP: PUBLIC WORKS - STREET OPS 88,835 73,137 161,972 1,201,235 13.48% 5 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 PW - HEALTH & SANITATION EXPENDITURES - Contractual Services 01-540-54-00-5441 GARBAGE SRVCS - SR SUBSIDY - - - 35,875 0.00% 01-540-54-00-5442 GARBAGE SERVICES - - - 1,268,428 0.00% 01-540-54-00-5443 LEAF PICKUP - 600 600 7,000 8.57% TOTAL EXPENDITURES: HEALTH & SANITATION - 600 600 1,311,303 0.05% 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 5,351 - 5,351 15,000 35.68% 01-640-52-00-5231 LIABILITY INSURANCE 71,918 25,885 97,803 343,684 28.46% 01-640-52-00-5240 RETIREES - GROUP HEALTH INS 13,805 1,677 15,482 39,066 39.63% 01-640-52-00-5241 RETIREES - DENTAL INSURANCE 35 (1) 34 423 8.05% 01-640-52-00-5242 RETIREES - VISION INSURANCE 212 13 225 80 281.24% Contractual Services 01-640-54-00-5418 PURCHASING SERVICES - - - 59,664 0.00% 01-640-54-00-5423 IDOR ADMINISTRATION FEE 2,929 3,387 6,316 47,047 13.43% 01-640-54-00-5427 GC HOUSING RENTAL ASSISTANCE 1,538 769 2,307 9,843 23.44% 01-640-54-00-5428 UTILITY TAX REBATE - - - 14,375 0.00% 01-640-54-00-5432 FACILITY MANAGEMENT SERVICES - - - 64,443 0.00% 01-640-54-00-5439 AMUSEMENT TAX REBATE - - - 46,000 0.00% 01-640-54-00-5449 KENCOM - 14,447 14,447 154,350 9.36% 01-640-54-00-5450 INFORMATION TECH SRVCS 7,450 14,594 22,044 392,681 5.61% 01-640-54-00-5456 CORPORATE COUNSEL - 7,910 7,910 110,000 7.19% 01-640-54-00-5461 LITIGATION COUNSEL - 12,160 12,160 110,000 11.05% 01-640-54-00-5462 PROFESSIONAL SERVICES - 523 523 8,250 6.34% 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 - - - 105,000 0.00% 01-640-54-00-5481 HOTEL TAX REBATES - - - 72,000 0.00% 01-640-54-00-5486 ECONOMIC DEVELOPMENT - 9,425 9,425 160,000 5.89% 01-640-54-00-5491 CITY PROPERTY TAX REBATE - - - 1,300 0.00% 01-640-54-00-5492 SALES TAX REBATES - - - 906,762 0.00% 01-640-54-00-5493 BUSINESS DISTRICT REBATES 25,787 30,222 56,009 397,057 14.11% 01-640-54-00-5494 ADMISSIONS TAX REBATE - - - 145,000 0.00% 01-640-54-00-5499 BAD DEBT - - 1,500 0.00% Supplies 01-640-56-00-5625 REIMBURSEABLE REPAIRS - - - 15,000 0.00% Other Financing Uses 01-640-70-00-7799 CONTINGENCY - - - 80,000 0.00% 01-640-99-00-9915 TRANSFER TO CITY-WIDE CAPITAL 21,667 21,667 43,333 260,000 16.67% 01-640-99-00-9942 TRANSFER TO DEBT SERVICE 26,269 26,269 52,538 315,225 16.67% 6 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 01-640-99-00-9952 TRANSFER TO SEWER 14,562 14,562 29,124 174,744 16.67% 01-640-99-00-9979 TRANSFER TO PARKS & RECREATION 109,107 109,107 218,214 1,309,284 16.67% 01-640-99-00-9982 TRANSFER TO LIBRARY OPS 5,911 1,911 7,822 26,584 29.42% TOTAL EXPENDITURES: ADMIN SERVICES 306,541 294,525 601,067 5,824,862 10.32% TOTAL FUND REVENUES 883,025 2,790,828 3,673,853 16,933,486 21.70% TOTAL FUND EXPENDITURES 1,107,292 1,509,076 2,616,368 16,898,632 15.48% FUND SURPLUS (DEFICIT)(224,267) 1,281,752 1,057,485 34,854 FOX HILL SSA REVENUES 11-000-40-00-4000 PROPERTY TAXES - 8,166 8,166 16,034 50.93% TOTAL REVENUES: FOX HILL SSA - 8,166 8,166 16,034 50.93% FOX HILL SSA EXPENDITURES 11-111-54-00-5462 PROFESSIONAL SERVICES - - - 3,126 0.00% 11-111-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - - 34,200 0.00% TOTAL FUND REVENUES - 8,166 8,166 16,034 50.93% TOTAL FUND EXPENDITURES - - - 37,326 0.00% FUND SURPLUS (DEFICIT)- 8,166 8,166 (21,292) SUNFLOWER SSA REVENUES 12-000-40-00-4000 PROPERTY TAXES - 9,580 9,580 20,363 47.05% TOTAL REVENUES: SUNFLOWER SSA - 9,580 9,580 20,363 47.05% SUNFLOWER SSA EXPENDITURES 12-112-54-00-5416 POND MAINTENANCE - - - 5,000 0.00% 12-112-54-00-5462 PROFESSIONAL SERVICES - - - 3,126 0.00% 12-112-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - 400 400 12,200 3.28% TOTAL FUND REVENUES - 9,580 9,580 20,363 47.05% TOTAL FUND EXPENDITURES - 400 400 20,326 1.97% FUND SURPLUS (DEFICIT)- 9,180 9,180 37 MOTOR FUEL TAX REVENUES 15-000-41-00-4112 MOTOR FUEL TAX 33,790 26,525 60,315 472,697 12.76% 15-000-41-00-4113 MFT HIGH GROWTH - - - 11,000 0.00% 15-000-41-00-4114 TRANSPORTATION RENEWAL TAX 22,626 18,145 40,771 320,901 12.71% 15-000-41-00-4115 REBUILD ILLINOIS 208,937 - 208,937 5,000 4178.75% 15-000-45-00-4500 INVESTMENT EARNINGS 418 272 690 4,263 16.19% TOTAL REVENUES: MOTOR FUEL TAX 265,772 44,942 310,714 813,861 38.18% 7 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 MOTOR FUEL TAX EXPENDITURES Capital Outlay 15-155-56-00-5618 SALT - - - 175,000 0.00% 15-155-60-00-6004 BASELINE ROAD BRIDGE REPAIRS - - - 25,000 0.00% 15-155-60-00-6025 ROADS TO BETTER ROADS PROGRAM - 61,694 61,694 781,674 7.89% 15-155-60-00-6028 PAVEMENT STRIPING PROGRAM - - - 62,000 0.00% 15-155-60-00-6079 ROUTE 47 EXPANSION 6,149 6,149 12,298 73,788 16.67% TOTAL FUND REVENUES 265,772 44,942 310,714 813,861 38.18% TOTAL FUND EXPENDITURES 6,149 67,843 73,992 1,117,462 6.62% FUND SURPLUS (DEFICIT)259,623 (22,901) 236,722 (303,601) CITY-WIDE CAPITAL REVENUES Licenses & Permits 23-000-42-00-4214 DEVELOPMENT FEES - - - 6,000 0.00% 23-000-42-00-4218 DEVELOPMENT FEES - MUNICIPAL BLDG 3,968 1,759 5,727 35,000 16.36% 23-000-42-00-4222 ROAD CONTRIBUTION FEE 8,000 6,000 14,000 100,000 14.00% Charges for Service 23-000-44-00-4440 ROAD INFRASTRUCTURE FEES 458 129,357 129,814 780,000 16.64% Investment Earnings 23-000-45-00-4500 INVESTMENT EARNINGS 6 11 17 1,098 1.53% Reimbursements 23-000-46-00-4614 REIMB - BLACKBERRY WOODS - - - 10,973 0.00% 23-000-46-00-4612 MILL ROAD IMPROVEMENTS 33,274 - 33,274 - 0.00% 23-000-46-00-4621 REIMB - FOUNTAIN VILLAGE - 1,283 1,283 38,599 0.00% 23-000-46-00-4636 REIMB. - RAINTREE VILLAGE - - - 70,000 0.00% 23-000-46-00-4690 REIMB - PUSH FOR THE PATH - - - 26,523 0.00% 23-000-46-00-4690 REIMB - MISCELLANEOUS - 393 393 5,477 7.17% Other Financing Sources 23-000-48-00-4845 DONATIONS - - - 2,000 0.00% 23-000-49-00-4901 TRANSFER FROM GENERAL 21,667 21,667 43,333 260,000 16.67% TOTAL REVENUES: CITY-WIDE CAPITAL 67,372 160,468 227,840 1,335,670 17.06% CW MUNICIPAL BUILDING EXPENDITURES 23-216-54-00-5446 PROPERTY & BLDG MAINT SERVICES 2,643 463 3,107 135,000 2.30% 23-216-56-00-5626 HANGING BASKETS - 3,623 3,623 2,000 181.13% 23-216-56-00-5656 PROPERTY & BLDG MAINT SUPPLIES - 6,117 6,117 25,000 24.47% 23-216-99-00-9901 TRANSFER TO GENERAL - - - 35,000 0.00% CITY-WIDE CAPITAL EXPENDITURES Contractual Services 23-230-54-00-5462 PROFESSIONAL SERVICES - - - 5,000 0.00% 23-230-54-00-5465 ENGINEERING SERVICES - - - 10,000 0.00% 23-230-54-00-5482 STREET LIGHTING - - - 108,989 0.00% 23-230-54-00-5498 PAYING AGENT FEES - - - 475 0.00% 23-230-54-00-5499 BAD DEBT - - - 1,500 0.00% 8 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 23-230-56-00-5619 SIGNS - 664 664 15,000 4.43% 23-230-60-00-6032 ASPHALT PATCHING - - - 35,000 0.00% 23-230-56-00-5637 SIDEWALK CONSTRUCTION SUPPLIES - - - 5,000 0.00% 23-230-56-00-5642 STREET LIGHTING & OTHER SUPPLIES - 289 289 45,000 0.64% Capital Outlay 23-230-60-00-6014 BLACKBERRY WOODS SUBDIVISION - - - 10,973 0.00% 23-230-60-00-6016 US34 (CENTER/ELDAMAIN RD) PROJECT - - - 110,000 0.00% 23-230-60-00-6023 FOUNTAIN VILLAGE SUBDIVISION - - - 38,599 0.00% 23-230-60-00-6025 ROAD TO BETTER ROADS PROGRAM - (3,500) (3,500) 312,500 -1.12% 23-230-60-00-6036 RAINTREE VILLAGE IMPROVEMENTS - - - 70,000 0.00% 23-230-60-00-6041 SIDEWALK REPLACEMENT PROGRAM - - - 125,000 0.00% 23-230-60-00-6058 RT71 ( RT47/ORCHARD RD) PROJECT - - - 53,878 0.00% 23-230-60-00-6059 US RT34(IL47/ORCHARD RD)PROJECT - - - 27,000 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 - - - 200,000 0.00% 23-230-78-00-8050 INTEREST PAYMENT 60,669 - 60,669 121,338 50.00% 23-230-99-00-9951 TRANSFER TO WATER 8,658 8,658 17,316 103,895 16.67% TOTAL FUND REVENUES 67,372 160,468 227,840 1,335,670 17.06% TOTAL FUND EXPENDITURES 71,970 16,314 88,284 1,628,147 5.42% FUND SURPLUS (DEFICIT)(4,598) 144,154 139,556 (292,477) VEHICLE & EQUIPMENT REVENUE Licenses & Permits 25-000-42-00-4215 DEVELOPMENT FEES - POLICE CAPITAL 2,400 900 3,300 30,000 11.00% 25-000-42-00-4217 WEATHER WARNING SIREN FEES 109 - 109 - 0.00% 25-000-42-00-4218 ENGINEERING CAPITAL FEE 800 300 1,100 10,000 11.00% 25-000-42-00-4219 DEVELOPMENT FEES - PW CAPITAL 5,600 2,100 7,700 64,500 11.94% 25-000-42-00-4220 DEVELOPMENT FEES - PARK CAPITAL 400 150 550 5,000 11.00% Fines & Forfeits 25-000-43-00-4315 DUI FINES - - - 8,000 0.00% 25-000-43-00-4316 ELECTRONIC CITATION FEES 514 20 534 800 66.71% Charges for Service 25-000-44-00-4418 MOWING INCOME - - - 2,000 0.00% 25-000-44-00-4420 POLICE CHARGEBACK 3,654 3,654 7,307 43,844 16.67% 25-000-44-00-4421 PUBLIC WORKS CHARGEBACK 11,879 11,879 23,759 142,551 16.67% 25-000-44-00-4422 PARKS & RECREATION CHARGEBACK - - - 75,000 0.00% 25-000-44-00-4425 COMPUTER REPLACEMENT CHARGEBACKS - - - 5,664 0.00% Investment Earnings 25-000-45-00-4522 INVESTMENT EARNINGS - PARKS 77 72 149 1,000 14.93% Miscellaneous 25-000-46-00-4692 MISC REIMB - PARK CAPITAL - - - 59,464 0.00% 25-000-48-00-4852 MISC INCOME - PD CAPITAL - 87 87 - 0.00% 25-000-48-00-4853 MISC INCOME - GEN GOV - 492 492 - 0.00% 9 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 25-000-48-00-4854 MISC INCOME - PW CAPITAL - - - 1,000 0.00% 25-000-48-00-4855 MISC INCOME - PARKS CAPITAL - 27 27 - 0.00% 25-000-49-00-4920 SALE OF CAPITAL ASSETS - PD - 4,005 4,005 - 0.00% TOTAL REVENUES: VEHICLE & EQUIPMENT 25,433 23,685 49,118 448,823 10.94% 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-6070 VEHICLES - - - 130,000 0.00% TOTAL EXPENDITURES: POLICE CAPITAL - - - 138,750 0.00% GENERAL GOVERNMENT CAPITAL EXPENDITURES Contractual Services 25-212-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - - - 5,664 0.00% TOTAL EXPENDITURES: GENERAL GOVERNMENT - - - 5,664 0.00% PUBLIC WORKS CAPITAL EXPENDITURES Contractual Services 25-215-54-00-5448 FILING FEES 67 - 67 750 8.93% Supplies 25-215-56-00-5620 OPERATING SUPPLIES - - - 1,000 0.00% Capital Outlay 25-215-60-00-6060 EQUIPMENT 6,941 - 6,941 130,000 5.34% 25-215-60-00-6070 VEHICLES - - - 100,000 0.00% 185 Wolf Street Building 25-215-92-00-8000 PRINCIPAL PAYMENT 4,250 4,213 8,464 51,612 16.40% 25-215-92-00-8050 INTEREST PAYMENT 1,533 1,570 3,102 17,784 17.44% TOTAL EXPENDITURES: PW CAPITAL 12,791 5,783 18,574 301,146 6.17% PARK & RECREATION CAPITAL EXPENDITURES Contractual Services 25-225-54-00-5495 OUTSDE REPAIR & MAINTENANCE - - - 1,600 0.00% Capital Outlay 25-225-60-00-6010 PARK IMPROVEMENTS - - - 59,464 0.00% 25-225-60-00-6013 BEECHER CENTER PARK - - - 50,000 0.00% 25-225-60-00-6020 BUILDINGS & STRUCTURES - - - 12,596 0.00% 25-225-60-00-6060 EQUIPMENT - - - 10,400 0.00% 25-225-60-00-6070 VEHICLES - - - 70,000 0.00% 185 Wolf Street Building 25-225-92-00-8000 PRINCIPAL PAYMENT 133 132 265 1,617 16.40% 25-225-92-00-8050 INTEREST PAYMENT 48 49 97 557 17.45% TOTAL EXPENDITURES: PARK & REC CAPITAL 181 181 362 206,234 0.18% TOTAL FUND REVENUES 25,433 23,685 49,118 448,823 10.94% TOTAL FUND EXPENDITURES 12,972 5,964 18,936 651,794 2.91% FUND SURPLUS (DEFICIT)12,460 17,721 30,181 (202,971) 10 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 DEBT SERVICE REVENUES 42-000-42-00-4208 RECAPTURE FEES-WATER & SEWER 400 450 850 8,000 10.63% 42-000-49-00-4901 TRANSFER FROM GENERAL 26,269 26,269 52,538 315,225 16.67% TOTAL REVENUES: DEBT SERVICE 26,669 26,719 53,388 323,225 16.52% DEBT SERVICE EXPENDITURES 42-420-54-00-5498 PAYING AGENT FEES - - - 475 0.00% 2014B Refunding Bond 42-420-79-00-8000 PRINCIPAL PAYMENT - - - 295,000 0.00% 42-420-79-00-8050 INTEREST PAYMENT - 13,875 13,875 27,750 50.00% TOTAL FUND REVENUES 26,669 26,719 53,388 323,225 16.52% TOTAL FUND EXPENDITURES - 13,875 13,875 323,225 4.29% FUND SURPLUS (DEFICIT)26,669 12,844 39,513 - WATER FUND REVENUES Charges for Service 51-000-44-00-4424 WATER SALES (524) 494,075 493,551 3,129,000 15.77% 51-000-44-00-4425 BULK WATER SALES (1,950) - (1,950) 5,000 -39.00% 51-000-44-00-4426 LATE PENALTIES - WATER - 19 19 131,250 0.01% 51-000-44-00-4430 WATER METER SALES 9,850 12,150 22,000 60,000 36.67% 51-000-44-00-4440 WATER INFRASTRUCTURE FEE 454 134,919 135,373 795,000 17.03% 51-000-44-00-4450 WATER CONNECTION FEES 35,014 12,700 47,714 230,000 20.75% Investment Earnings 51-000-45-00-4500 INVESTMENT EARNINGS 149 140 289 22,557 1.28% Miscellaneous 51-000-46-00-4690 REIMB - MISCELLANEOUS 9,459 - 9,459 - 0.00% 51-000-48-00-4820 RENTAL INCOME 8,295 8,295 16,590 100,010 16.59% 51-000-48-00-4850 MISCELLANEOUS INCOME - 390 390 250 156.16% Other Financing Sources 51-000-49-00-4923 TRANSFER FROM CITY-WIDE CAPITAL 8,658 8,658 17,316 103,895 16.67% 51-000-49-00-4952 TRANSFER FROM SEWER 6,260 6,260 12,521 75,125 16.67% TOTAL REVENUES: WATER FUND 75,666 677,606 753,272 4,652,087 16.19% WATER OPERATIONS EXPENSES Salaries & Wages 51-510-50-00-5010 SALARIES & WAGES 48,833 33,324 82,157 457,530 17.96% 51-510-50-00-5015 PART-TIME SALARIES - - - 30,000 0.00% 51-510-50-00-5020 OVERTIME 439 438 877 22,000 3.98% Benefits 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 5,520 3,788 9,308 54,251 17.16% 51-510-52-00-5214 FICA CONTRIBUTION 3,646 2,472 6,118 37,576 16.28% 51-510-52-00-5216 GROUP HEALTH INSURANCE 15,972 7,841 23,812 107,430 22.17% 51-510-52-00-5222 GROUP LIFE INSURANCE 43 43 87 543 15.97% 11 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 51-510-52-00-5223 DENTAL INSURANCE 606 606 1,213 7,278 16.67% 51-510-52-00-5224 VISION INSURANCE 198 99 297 1,129 26.31% 51-510-52-00-5230 UNEMPLOYMENT INSURANCE 527 - 527 2,000 26.34% 51-510-52-00-5231 LIABILITY INSURANCE 6,659 2,281 8,939 30,961 28.87% Contractual Services 51-510-54-00-5401 ADMINISTRATIVE CHARGEBACK 10,352 10,352 20,704 124,225 16.67% 51-510-54-00-5412 TRAINING & CONFERENCES - - - 9,200 0.00% 51-510-54-00-5415 TRAVEL & LODGING - - - 4,000 0.00% 51-510-54-00-5426 PUBLISHING & ADVERTISING - - - 500 0.00% 51-510-54-00-5429 WATER SAMPLES - 631 631 8,000 7.89% 51-510-54-00-5430 PRINTING & DUPLICATING - 3 3 3,250 0.08% 51-510-54-00-5440 TELECOMMUNICATIONS 392 336 728 40,000 1.82% 51-510-54-00-5445 TREATMENT FACILITY SERVICES 12,952 14,854 27,806 255,000 10.90% 51-510-54-00-5448 FILING FEES 67 - 67 3,000 2.23% 51-510-54-00-5452 POSTAGE & SHIPPING 2,590 447 3,036 19,000 15.98% 51-510-54-00-5460 DUES & SUBSCRIPTIONS 250 150 400 2,500 16.00% 51-510-54-00-5462 PROFESSIONAL SERVICES 4,536 4,682 9,219 155,000 5.95% 51-510-54-00-5465 ENGINEERING SERVICES - - - 85,000 0.00% 51-510-54-00-5480 UTILITIES - 9,003 9,003 309,520 2.91% 51-510-54-00-5483 JULIE SERVICES - - - 3,000 0.00% 51-510-54-00-5485 RENTAL & LEASE PURCHASE 145 95 240 1,700 14.11% 51-510-54-00-5488 OFFICE CLEANING - 108 108 788 13.64% 51-510-54-00-5490 VEHICLE MAINTENANCE SERVICES - - - 12,000 0.00% 51-510-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - - 32,000 0.00% 51-510-54-00-5498 PAYING AGENT FEES - - - 1,300 0.00% 51-510-54-00-5499 BAD DEBT - - - 10,000 0.00% Supplies 51-510-56-00-5600 WEARING APPAREL - 852 852 5,000 17.03% 51-510-56-00-5620 OPERATING SUPPLIES - 61 61 16,000 0.38% 51-510-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - - - 2,500 0.00% 51-510-56-00-5630 SMALL TOOLS & EQUIPMENT 4 - 4 4,000 0.10% 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 2,524 13,509 16,033 178,500 8.98% 51-510-56-00-5640 REPAIR & MAINTENANCE - 416 416 27,500 1.51% 51-510-56-00-5664 METERS & PARTS - 7,282 7,282 100,000 7.28% 51-510-56-00-5665 JULIE SUPPLIES - - - 2,233 0.00% 51-510-56-00-5695 GASOLINE - 799 799 23,540 3.40% Capital Outlay 51-510-60-00-6015 WATER TOWER PAINTING - - - 18,000 0.00% 51-510-60-00-6025 ROAD TO BETTER ROADS PROGRAM - - - 634,000 0.00% 51-510-60-00-6059 US34 (IL RT47/ORCHARD) PROJECT - - - 7,700 0.00% 51-510-60-00-6060 EQUIPMENT - - - 500,300 0.00% 51-510-60-00-6066 RTE 71 WATERMAIN REPLACEMENT - - - 12,871 0.00% 51-510-60-00-6070 VEHICLES - - - 90,000 0.00% 12 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 51-510-60-00-6079 ROUTE 47 EXPANSION 3,781 3,781 7,562 45,372 16.67% 51-510-60-00-6081 CATION EXCHANGE MEDIA REPLACEMENT - - - 25,000 0.00% 2015A Bond 51-510-77-00-8000 PRINCIPAL PAYMENT - - - 297,837 0.00% 51-510-77-00-8050 INTEREST PAYMENT 70,084 - 70,084 140,167 50.00% 2016 Refunding Bond 51-510-85-00-8000 PRINCIPAL PAYMENT - - - 1,475,000 0.00% 51-510-85-00-8050 INTEREST PAYMENT - 58,825 58,825 117,650 50.00% IEPA Loan L17-156300 51-510-89-00-8000 PRINCIPAL PAYMENT - - - 107,050 0.00% 51-510-89-00-8050 INTEREST PAYMENT - - - 17,981 0.00% 2014C Refunding Bond 51-510-94-00-8000 PRINCIPAL PAYMENT - - - 130,000 0.00% 51-510-94-00-8050 INTEREST PAYMENT - 10,125 10,125 20,250 50.00% TOTAL FUND REVENUES 75,666 677,606 753,272 4,652,087 16.19% TOTAL FUND EXPENSES 190,120 187,201 377,321 5,828,132 6.47% FUND SURPLUS (DEFICIT)(114,454) 490,405 375,951 (1,176,045) SEWER FUND REVENUES Charges for Service 52-000-44-00-4435 SEWER MAINTENANCE FEES 538 168,955 169,493 1,024,850 16.54% 52-000-44-00-4440 SEWER INFRASTRUCTURE FEE 236 64,842 65,078 390,000 16.69% 52-000-44-00-4455 SW CONNECTION FEES - OPS 2,200 1,200 3,400 23,300 14.59% 52-000-44-00-4456 SW CONNECTION FEES - CAPITAL 10,800 1,800 12,600 180,000 7.00% 52-000-44-00-4462 LATE PENALTIES - SEWER - 3 3 17,500 0.02% Investment Earnings 52-000-45-00-4500 INVESTMENT EARNINGS 71 63 134 7,473 1.79% Other Financing Sources 52-000-48-00-4850 MISCELLANEOUS INCOME ~- 215 215 - 0.00% 52-000-49-00-4901 TRANSFER FROM GENERAL 14,562 14,562 29,124 174,744 16.67% TOTAL REVENUES: SEWER FUND 28,407 251,641 280,048 1,817,867 15.41% SEWER OPERATIONS EXPENSES Salaries & Wages 52-520-50-00-5010 SALARIES & WAGES 26,709 18,575 45,284 250,561 18.07% 52-520-50-00-5015 PART-TIME SALARIES - - - 5,000 0.00% 52-520-50-00-5020 OVERTIME - 88 88 500 17.66% Benefits 52-520-52-00-5212 RETIREMENT PLAN CONTRIBUTION 2,983 2,085 5,068 28,403 17.84% 52-520-52-00-5214 FICA CONTRIBUTION 1,963 1,347 3,309 18,509 17.88% 52-520-52-00-5216 GROUP HEALTH INSURANCE 12,449 5,816 18,266 79,026 23.11% 52-520-52-00-5222 GROUP LIFE INSURANCE 26 26 52 314 16.67% 52-520-52-00-5223 DENTAL INSURANCE 418 418 837 5,021 16.67% 52-520-52-00-5224 VISION INSURANCE 133 66 199 736 27.01% 52-520-52-00-5230 UNEMPLOYMENT INSURANCE 277 - 277 750 36.95% 13 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 52-520-52-00-5231 LIABILITY INSURANCE 3,227 1,105 4,333 15,025 28.84% Contractual Services 52-520-54-00-5401 ADMINISTRATIVE CHARGEBACK 3,726 3,726 7,452 44,709 16.67% 52-520-54-00-5412 TRAINING & CONFERENCES - 164 164 3,500 4.69% 52-520-54-00-5415 TRAVEL & LODGING - - - 3,000 0.00% 52-520-54-00-5430 PRINTING & DUPLICATING - - - 1,500 0.00% 52-520-54-00-5440 TELECOMMUNICATIONS - 2 2 13,500 0.02% 52-520-54-00-5444 LIFT STATION SERVICES 92 212 304 64,000 0.47% 52-520-54-00-5462 PROFESSIONAL SERVICES 1,620 - 1,620 45,500 3.56% 52-520-54-00-5480 UTILITIES - 1,749 1,749 23,820 7.34% 52-520-54-00-5483 JULIE SERVICES - 421 421 3,000 14.02% 52-520-54-00-5485 RENTAL & LEASE PURCHASE 69 - 69 1,100 6.31% 52-520-54-00-5488 OFFICE CLEANING - 57 57 788 7.24% 52-520-54-00-5490 VEHICLE MAINTENANCE SERVICES - 108 108 10,000 1.08% 52-520-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - 5,424 5,424 16,000 33.90% 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 - 235 235 3,980 5.92% 52-520-56-00-5610 OFFICE SUPPLIES - 99 99 1,000 9.87% 52-520-56-00-5613 LIFT STATION MAINTENANCE 71 144 215 8,000 2.69% 52-520-56-00-5620 OPERATING SUPPLIES 75 19 94 12,000 0.78% 52-520-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - 577 577 10,000 5.77% 52-520-56-00-5630 SMALL TOOLS & EQUIPMENT - 92 92 2,000 4.62% 52-520-56-00-5640 REPAIR & MAINTENANCE - - - 5,000 0.00% 52-520-56-00-5665 JULIE SUPPLIES - - - 2,233 0.00% 52-520-56-00-5695 GASOLINE - 416 416 24,043 1.73% Capital Outlay 52-520-60-00-6001 SCADA SYSTEM - - - 67,000 0.00% 52-520-60-00-6059 US34 (IL RT47/ORCHARD) PROJECT - - - 650 0.00% 52-520-60-00-6060 EQUIPMENT 4,223 - 4,223 80,000 5.28% 52-520-60-00-6066 RTE 71 SEWER MAIN REPLACEMENT - - - 34,223 0.00% 52-520-60-00-6079 ROUTE 47 EXPANSION 1,873 1,873 3,747 22,488 16.66% 2003 IRBB Debt Certificates 52-520-90-00-8000 PRINCIPAL PAYMENT - - - 140,000 0.00% 52-520-90-00-8050 INTEREST PAYMENT - - - 22,850 0.00% 2011 Refunding Bond 52-520-92-00-8000 PRINCIPAL PAYMENT - - - 885,000 0.00% 52-520-92-00-8050 INTEREST PAYMENT - 126,474 126,474 252,948 50.00% Other Financing Uses 52-520-99-00-9951 TRANSFER TO WATER 6,260 6,260 12,521 75,125 16.67% TOTAL FUND REVENUES 28,407 251,641 280,048 1,817,867 15.41% TOTAL FUND EXPENSES 66,196 177,580 243,776 2,286,552 10.66% FUND SURPLUS (DEFICIT)(37,789) 74,061 36,272 (468,685) 14 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 LAND CASH REVENUES 72-000-47-00-4701 WHITE OAK - - - 1,406 0.00% 72-000-47-00-4702 WHISPERING MEADOWS - - - 4,699 0.00% 72-000-47-00-4704 BLACKBERRY WOODS 568 - 568 1,932 29.41% 72-000-47-00-4706 CALEDONIA 1,007 - 1,007 4,698 21.43% 72-000-47-00-4707 RIVERS EDGE - - - 671 0.00% 72-000-47-00-4708 COUNTRY HILLS - - - 4,358 0.00% 72-000-47-00-4711 FOX HIGHLANDS - - - 3,298 0.00% 72-000-47-00-4724 KENDALL MARKETPLACE 324 162 486 2,752 17.65% 72-000-47-00-4725 HEARTLAND MEADOWS - - - 3,522 0.00% 72-000-47-00-4727 CIMARRON RIDGE - - - 1,377 0.00% 72-000-47-00-4736 BRIARWOOD - - - 5,145 0.00% TOTAL REVENUES: LAND CASH 1,899 162 2,061 33,858 6.09% LAND CASH EXPENDITURES 72-720-54-00-5485 RENTAL & LEASE PURCHASE 5,290 - 5,290 5,287 100.05% 72-720-60-00-6013 BEECHER CENTER PARK - - - 95,000 0.00% 72-720-60-00-6029 CALEDONIA PARK - - - 85,000 0.00% 72-720-60-00-6047 AUTUMN CREEK - - - 50,000 0.00% 72-720-60-00-6067 BLACKBERRY CREEK NATURE PRESERVE - - - 5,000 0.00% TOTAL FUND REVENUES 1,899 162 2,061 33,858 6.09% TOTAL FUND EXPENDITURES 5,290 - 5,290 240,287 2.20% FUND SURPLUS (DEFICIT)(3,391) 162 (3,229) (206,429) PARK & RECREATION REVENUES Charges for Service 79-000-44-00-4402 SPECIAL EVENTS 1,085 1,525 2,610 90,000 2.90% 79-000-44-00-4403 CHILD DEVELOPMENT 4,464 1,837 6,301 145,000 4.35% 79-000-44-00-4404 ATHLETICS AND FITNESS 2,661 2,606 5,267 370,000 1.42% 79-000-44-00-4441 CONCESSION REVENUE 182 1,761 1,943 45,000 4.32% Investment Earnings 79-000-45-00-4500 INVESTMENT EARNINGS 112 87 200 1,300 15.35% Reimbursements 79-000-46-00-4690 REIMB - MISCELLANEOUS - - - - 0.00% Miscellaneous 79-000-48-00-4820 RENTAL INCOME 49,816 2,000 51,816 64,216 80.69% 79-000-48-00-4825 PARK RENTALS 1,120 - 1,120 17,500 6.40% 79-000-48-00-4843 HOMETOWN DAYS 1,675 - 1,675 120,000 1.40% 79-000-48-00-4846 SPONSORSHIPS & DONATIONS 1,872 - 1,872 20,000 9.36% 79-000-48-00-4850 MISCELLANEOUS INCOME - 2,421 2,421 5,000 48.42% 15 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 Other Financing Sources 79-000-49-00-4901 TRANSFER FROM GENERAL 109,107 109,107 218,214 1,309,284 16.67% TOTAL REVENUES: PARK & RECREATION 172,094 121,345 293,438 2,187,300 13.42% PARKS DEPARTMENT EXPENDITURES Salaries & Wages 79-790-50-00-5010 SALARIES & WAGES 65,029 44,902 109,931 601,936 18.26% 79-790-50-00-5015 PART-TIME SALARIES - - - 59,000 0.00% 79-790-50-00-5020 OVERTIME - 519 519 5,000 10.38% Benefits 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 7,275 5,085 12,360 70,570 17.51% 79-790-52-00-5214 FICA CONTRIBUTION 4,813 3,313 8,126 48,830 16.64% 79-790-52-00-5216 GROUP HEALTH INSURANCE 24,229 13,171 37,400 155,338 24.08% 79-790-52-00-5222 GROUP LIFE INSURANCE 54 54 108 645 16.67% 79-790-52-00-5223 DENTAL INSURANCE 846 809 1,655 9,708 17.05% 79-790-52-00-5224 VISION INSURANCE 263 128 391 1,537 25.44% Contractual Services 79-790-54-00-5412 TRAINING & CONFERENCES 23 - 23 7,000 0.32% 79-790-54-00-5415 TRAVEL & LODGING - - - 3,000 0.00% 79-790-54-00-5422 VEHICLE & EQUIPMENT CHARGEBACK - - - 75,000 0.00% 79-790-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - 875 0.00% 79-790-54-00-5440 TELECOMMUNICATIONS - 673 673 8,100 8.31% 79-790-54-00-5462 PROFESSIONAL SERVICES 510 545 1,055 11,400 9.25% 79-790-54-00-5466 LEGAL SERVICES - 270 270 2,000 13.50% 79-790-54-00-5485 RENTAL & LEASE PURCHASE 95 95 189 2,500 7.56% 79-790-54-00-5488 OFFICE CLEANING - 233 233 3,078 7.55% 79-790-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - 113 113 33,759 0.34% Supplies 79-790-56-00-5600 WEARING APPAREL - - - 6,220 0.00% 79-790-56-00-5620 OPERATING SUPPLIES - 173 173 25,000 0.69% 79-790-56-00-5630 SMALL TOOLS & EQUIPMENT - - - 6,000 0.00% 79-790-56-00-5640 REPAIR & MAINTENANCE - (746) (746) 71,000 -1.05% 79-790-56-00-5646 ATHLETIC FIELDS & EQUIPMENT - - - 55,000 0.00% 79-790-56-00-5695 GASOLINE - - - 27,189 0.00% TOTAL EXPENDITURES: PARKS DEPT 103,136 69,336 172,472 1,289,685 13.37% RECREATION DEPARTMENT EXPENDITURES Salaries & Wages 79-795-50-00-5010 SALARIES & WAGES 40,602 28,301 68,903 387,576 17.78% 79-795-50-00-5015 PART-TIME SALARIES 240 70 310 23,500 1.32% 79-795-50-00-5045 CONCESSION WAGES - - - 15,000 0.00% 79-795-50-00-5046 PRE-SCHOOL WAGES 561 - 561 40,000 1.40% 79-795-50-00-5052 INSTRUCTORS WAGES 840 457 1,297 40,000 3.24% Benefits 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION 4,544 3,170 7,713 49,493 15.58% 16 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 79-795-52-00-5214 FICA CONTRIBUTION 3,153 2,127 5,279 37,543 14.06% 79-795-52-00-5216 GROUP HEALTH INSURANCE 13,693 6,262 19,954 103,025 19.37% 79-795-52-00-5222 GROUP LIFE INSURANCE 38 38 76 475 16.05% 79-795-52-00-5223 DENTAL INSURANCE 526 526 1,051 6,744 15.59% 79-795-52-00-5224 VISION INSURANCE 170 85 255 1,092 23.35% Contractual Services 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 - - - 875 0.00% 79-795-54-00-5426 PUBLISHING & ADVERTISING - - - 55,000 0.00% 79-795-54-00-5440 TELECOMMUNICATIONS - 390 390 8,750 4.45% 79-795-54-00-5447 SCHOLARSHIPS - - - 2,500 0.00% 79-795-54-00-5452 POSTAGE & SHIPPING 213 49 261 3,500 7.46% 79-795-54-00-5460 DUES & SUBSCRIPTIONS 664 - 664 3,000 22.12% 79-795-54-00-5462 PROFESSIONAL SERVICES 195 696 891 140,000 0.64% 79-795-54-00-5480 UTILITIES - 54 54 15,150 0.36% 79-795-54-00-5485 RENTAL & LEASE PURCHASE 135 95 229 3,000 7.64% 79-795-54-00-5488 OFFICE CLEANING - 630 630 3,078 20.47% 79-795-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - - 3,000 0.00% Supplies 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 11,725 - 11,725 120,000 9.77% 79-795-56-00-5606 PROGRAM SUPPLIES 893 1,915 2,808 158,241 1.77% 79-795-56-00-5607 CONCESSION SUPPLIES - - - 18,000 0.00% 79-795-56-00-5610 OFFICE SUPPLIES - - - 3,000 0.00% 79-795-56-00-5620 OPERATING SUPPLIES - 90 90 15,000 0.60% 79-795-56-00-5640 REPAIR & MAINTENANCE - - - 2,000 0.00% 79-795-56-00-5695 GASOLINE - - - 535 0.00% TOTAL EXPENDITURES: RECREATION DEPT 78,190 44,952 123,142 1,267,077 9.72% TOTAL FUND REVENUES 172,094 121,345 293,438 2,187,300 13.42% TOTAL FUND EXPENDITURES 181,326 114,288 295,614 2,556,762 11.56% FUND SURPLUS (DEFICIT)(9,232) 7,057 (2,175) (369,462) LIBRARY OPERATIONS REVENUES Taxes 82-000-40-00-4000 PROPERTY TAXES - 351,569 351,569 739,047 47.57% 82-000-40-00-4083 PROPERTY TAXES-DEBT SERVICE - 393,438 393,438 822,953 47.81% Intergovernmental 82-000-41-00-4120 PERSONAL PROPERTY TAX 800 - 800 5,250 15.24% 82-000-41-00-4170 STATE GRANTS - - - 20,000 0.00% Fines & Forfeits 82-000-43-00-4330 LIBRARY FINES - 1,072 1,072 8,500 12.61% Charges for Service 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS - 476 476 8,500 5.60% 17 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 82-000-44-00-4422 COPY FEES - 3 3 3,800 0.08% Investment Earnings 82-000-45-00-4500 INVESTMENT EARNINGS 203 142 345 8,959 3.85% Miscellaneous 82-000-48-00-4820 RENTAL INCOME - - - 1,750 0.00% 82-000-48-00-4850 MISCELLANEOUS INCOME - 324 324 2,000 16.19% Other Financing Sources 82-000-49-00-4901 TRANSFER FROM GENERAL 5,911 1,911 7,822 26,584 29.42% TOTAL REVENUES: LIBRARY 6,914 748,934 755,848 1,647,343 45.88% LIBRARY OPERATIONS EXPENDITURES Salaries & Wages 82-820-50-00-5010 SALARIES & WAGES 31,602 21,068 52,670 289,742 18.18% 82-820-50-00-5015 PART-TIME SALARIES 19,929 9,261 29,190 190,000 15.36% Benefits 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 3,547 2,370 5,917 32,779 18.05% 82-820-52-00-5214 FICA CONTRIBUTION 3,886 2,264 6,149 35,952 17.10% 82-820-52-00-5216 GROUP HEALTH INSURANCE 10,625 9,593 20,219 76,764 26.34% 82-820-52-00-5222 GROUP LIFE INSURANCE 29 29 58 387 14.96% 82-820-52-00-5223 DENTAL INSURANCE 527 527 1,054 6,322 16.67% 82-820-52-00-5224 VISION INSURANCE 169 84 253 1,012 25.00% 82-820-52-00-5230 UNEMPLOYMENT INSURANCE 333 - 333 750 44.39% 82-820-52-00-5231 LIABILITY INSURANCE 5,578 1,911 7,489 25,834 28.99% Contractual Services 82-820-54-00-5412 TRAINING & CONFERENCES - - - 3,000 0.00% 82-820-54-00-5415 TRAVEL & LODGING - - - 1,500 0.00% 82-820-54-00-5426 PUBLISHING & ADVERTISING - 228 228 2,500 9.12% 82-820-54-00-5440 TELECOMMUNICATIONS - - - 7,200 0.00% 82-820-54-00-5452 POSTAGE & SHIPPING - - - 750 0.00% 82-820-54-00-5460 DUES & SUBSCRIPTIONS 593 185 778 11,000 7.07% 82-820-54-00-5462 PROFESSIONAL SERVICES 3,865 986 4,851 40,000 12.13% 82-820-54-00-5466 LEGAL SERVICES - - - 3,000 0.00% 82-820-54-00-5468 AUTOMATION 2,366 - 2,366 20,000 11.83% 82-820-54-00-5480 UTILITIES - - - 11,798 0.00% 82-820-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - - 50,000 0.00% 82-820-54-00-5498 PAYING AGENT FEES - 1,556 1,556 1,700 91.53% Supplies 82-820-56-00-5610 OFFICE SUPPLIES - 311 311 8,000 3.89% 82-820-56-00-5620 OPERATING SUPPLIES - 78 78 4,000 1.95% 82-820-56-00-5621 CUSTODIAL SUPPLIES - 895 895 7,000 12.78% 82-820-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - - - 2,000 0.00% 82-820-56-00-5671 LIBRARY PROGRAMMING - - - 2,000 0.00% 82-820-56-00-5675 EMPLOYEE RECOGNITION - - - 300 0.00% 82-820-56-00-5685 DVD'S - - - 500 0.00% 82-820-56-00-5686 BOOKS - - - 1,500 0.00% 18 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 2006 Bond 82-820-84-00-8000 PRINCIPAL PAYMENT - - - 75,000 0.00% 82-820-84-00-8050 INTEREST PAYMENT - 10,119 10,119 20,238 50.00% 2013 Refunding Bond 82-820-99-00-8000 PRINCIPAL PAYMENT - - - 610,000 0.00% 82-820-99-00-8050 INTEREST PAYMENT - 60,925 60,925 121,850 50.00% TOTAL FUND REVENUES 6,914 748,934 755,848 1,647,343 45.88% TOTAL FUND EXPENDITURES 83,048 122,390 205,437 1,664,378 12.34% FUND SURPLUS (DEFICIT)(76,134) 626,544 550,410 (17,035) LIBRARY CAPITAL REVENUES 84-000-42-00-4214 DEVELOPMENT FEES 3,500 1,500 5,000 50,000 10.00% 84-000-45-00-4500 INVESTMENT EARNINGS 16 15 31 500 6.23% 84-000-48-00-4850 MISCELLANEOUS INCOME - 26 26 - 0.00% TOTAL REVENUES: LIBRARY CAPITAL 3,516 1,541 5,057 50,500 10.01% LIBRARY CAPITAL EXPENDITURES 84-840-54-00-5460 E-BOOK SUBSCRIPTIONS - - - 3,500 0.00% 84-840-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - 1,326 1,326 15,000 8.84% 84-840-56-00-5683 AUDIO BOOKS - 155 155 3,500 4.43% 84-840-56-00-5684 COMPACT DISCS & OTHER MUSIC - 16 16 500 3.20% 84-840-56-00-5685 DVD'S - 420 420 3,000 13.99% 84-840-56-00-5686 BOOKS - 1,046 1,046 50,000 2.09% TOTAL FUND REVENUES 3,516 1,541 5,057 50,500 10.01% TOTAL FUND EXPENDITURES - 2,963 2,963 75,500 3.92% FUND SURPLUS (DEFICIT)3,516 (1,422) 2,094 (25,000) COUNTRYSIDE TIF REVENUES 87-000-40-00-4000 PROPERTY TAXES - 16,490 16,490 153,965 10.71% 87-000-48-00-4850 MISCELLANEOUS INCOME - 0 0 - 0.00% TOTAL REVENUES: COUNTRYSIDE TIF - 16,491 16,491 153,965 10.71% COUNTRYSIDE TIF EXPENDITURES Contractual Services 87-870-54-00-5401 ADMINISTRATIVE CHARGEBACK 956 956 1,913 11,475 16.67% 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 - - - 107,163 0.00% 87-870-77-00-8050 INTEREST PAYMENT 25,216 - 25,216 50,433 50.00% 19 % of Fiscal Year 8%17%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 June-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended June 30, 2020 2014 Refunding Bond 87-870-93-00-8050 INTEREST PAYMENT 25,358 - 25,358 50,715 50.00% TOTAL FUND REVENUES - 16,491 16,491 153,965 10.71% TOTAL FUND EXPENDITURES 51,530 956 52,486 222,486 23.59% FUND SURPLUS (DEFICIT)(51,530) 15,534 (35,996) (68,521) DOWNTOWN TIF REVENUES 88-000-40-00-4000 PROPERTY TAXES - 25,320 25,320 76,000 33.32% 88-000-48-00-4850 MISCELLANEOUS INCOME - 0 0 - 0.00% TOTAL REVENUES: DOWNTOWN TIF - 25,320 25,320 76,000 33.32% DOWNTOWN TIF EXPENDITURES Contractual Services 88-880-54-00-5401 ADMINISTRATIVE CHARGEBACK 2,791 2,791 5,581 33,487 16.67% 88-880-54-00-5425 TIF INCENTIVE PAYOUT - - - 26,877 0.00% 88-880-54-00-5462 PROFESSIONAL SERVICES - - - 1,000 0.00% 88-880-54-00-5466 LEGAL SERVICES - 50 50 15,000 0.33% Capital Outlay 88-880-60-00-6000 PROJECT COSTS - - - 10,000 0.00% 88-880-60-00-6079 ROUTE 47 EXPANSION 624 624 1,248 7,488 16.67% FNBO Loan - 102 E Van Emmon Building 88-880-81-00-8000 PRINCIPAL PAYMENT - 200,000 200,000 200,000 100.00% 88-880-81-00-8050 INTEREST PAYMENT - 12,233 12,233 12,200 100.27% TOTAL FUND REVENUES - 25,320 25,320 76,000 33.32% TOTAL FUND EXPENDITURES 3,415 215,698 219,113 306,052 71.59% FUND SURPLUS (DEFICIT)(3,415) (190,378) (193,793) (230,052) DOWNTOWN TIF II REVENUES 89-000-40-00-4000 PROPERTY TAXES - 18,481 18,481 25,000 73.93% 89-000-48-00-4850 MISCELLANEOUS INCOME - 0 0 - 0.00% TOTAL REVENUES: DOWNTOWN TIF II - 18,481 18,481 25,000 73.93% DOWNTOWN TIF II EXPENDITURES 89-890-54-00-5425 TIF INCENTIVE PAYOUT - - - 17,500 0.00% 89-890-54-00-5462 PROFESSIONAL SERVICES - - - 5,000 0.00% TOTAL FUND REVENUES - 18,481 18,481 25,000 73.93% TOTAL FUND EXPENDITURES - - - 22,500 0.00% FUND SURPLUS (DEFICIT)- 18,481 18,481 2,500 20 June YTD % of FY 2021 Actual Actual Budget Budget YTD Actual % Change GENERAL FUND (01) REVENUES Property Taxes 1,587,747$ 1,587,747$ 47.6% 3,337,703$ 1,639,828$ -3.18% Municipal Sales Tax 253,657 484,704 14.8% 3,284,400 466,009 4.01% Non-Home Rule Sales Tax 178,045 330,417 13.2% 2,493,900 347,617 -4.95% Electric Utility Tax 150,649 150,649 21.1% 715,000 158,190 -4.77% Natural Gas Tax 15,924 38,794 14.6% 265,000 42,547 -8.82% Excise (Telecommunication) Tax 21,150 41,939 17.0% 246,075 56,287 -25.49% Cable Franchise Fees - 63,267 21.1% 300,000 63,971 -1.10% Hotel Tax 1,808 3,047 3.8% 80,000 13,084 -76.71% Video Gaming Tax - 7,193 5.1% 140,000 27,165 -73.52% Amusement Tax 21 21 0.0% 205,000 8,562 -99.75% State Income Tax 118,791 310,572 16.4% 1,897,310 501,281 -38.04% Local Use Tax 60,149 107,434 15.9% 675,281 98,165 9.44% Road & Bridge Tax 26,084 26,084 20.1% 130,000 67,681 -61.46% Building Permits 41,019 80,900 20.2% 400,000 81,892 -1.21% Garbage Surcharge 221,192 221,674 17.1% 1,297,650 209,992 5.56% Investment Earnings 1,561 3,582 4.0% 89,878 21,306 -83.19% MOTOR FUEL TAX FUND (15) REVENUES Motor Fuel Tax 26,525$ 60,315$ 12.8% 472,697$ 42,104$ 43.25% Transportation Renewal Funds 18,145 40,771 12.7% 320,901 - 0.00% WATER FUND (51) REVENUES Water Sales 494,075$ 493,551$ 15.8% 3,129,000$ 506,657$ -2.59% Water Infrastructure Fees 134,919 135,373 17.0% 795,000 130,998 3.34% Late Penalties 19 19 0.0% 131,250 17,705 -99.89% Water Connection Fees 12,700 47,714 20.7% 230,000 63,265 -24.58% Water Meter Sales 12,150 22,000 36.7% 60,000 33,282 -33.90% SEWER FUND (52) REVENUES Sewer Maintenance Fees 168,955$ 169,493$ 16.5% 1,024,850$ 164,594$ 2.98% Sewer Infrastructure Fees 64,842 65,078 16.7% 390,000 62,071 4.85% Sewer Connection Fees 3,000 16,000 7.9% 203,300 51,900 -69.17% PARKS & RECREATION (79) REVENUES Special Events 1,525$ 2,610$ 2.9% 90,000$ 25,762$ -89.87% Child Development 1,837 6,301 4.3% 145,000 16,766 -62.42% Athletics & Fitness 2,606 5,267 1.4% 370,000 79,506 -93.38% Rental Income 2,000 51,816 80.7% 64,216 49,600 4.47% Hometown Days - 1,675 1.4% 120,000 7,515 -77.71% *June represents 17% of fiscal year 2021 UNITED CITY OF YORKVILLE MONTHLY ANALYSIS OF MAJOR REVENUES For the Month Ended June 30, 2020 * Fiscal Year 2020 For the Month Ended June 30, 2019 21 June YTD % of FY 2021 Actual Actual Budget Budget YTD Actual % Change GENERAL FUND (01) Revenues Local Taxes Property Taxes 1,587,747$ 1,587,747$ 47.6% 3,337,703$ 1,639,828$ -3.18% Municipal Sales Tax 253,657 484,704 14.8% 3,284,400 466,009 4.01% Non-Home Rule Sales Tax 178,045 330,417 13.2% 2,493,900 347,617 -4.95% Electric Utility Tax 150,649 150,649 21.1% 715,000 158,190 -4.77% Natural Gas Tax 15,924 38,794 14.6% 265,000 42,547 -8.82% Excise (Telecommunication) Tax 21,150 41,939 17.0% 246,075 56,287 -25.49% Telephone Utility Tax 695 1,390 16.7%8,340 1,390 0.00% Cable Franchise Fees - 63,267 21.1% 300,000 63,971 -1.10% Hotel Tax 1,808 3,047 3.8% 80,000 13,084 -76.71% Video Gaming Tax - 7,193 5.1% 140,000 27,165 -73.52% Amusement Tax 21 21 0.0% 205,000 8,562 -99.75% Admissions Tax - - 0.0% 145,000 - 0.00% Business District Tax 30,838 57,152 14.1% 405,160 62,445 -8.48% Auto Rental Tax 9 1,256 8.2% 15,250 2,462 0.00% Total Taxes 2,240,542$ 2,767,576$ 23.8% 11,640,828$ 2,889,557$ -4.22% Intergovernmental State Income Tax 118,791$ 310,572$ 16.4% 1,897,310$ 501,281$ -38.04% Local Use Tax 60,149 107,434 15.9% 675,281 98,165 9.44% Cannabis Exise Tax 694 1,591 0.0% 15,218.00 - 0.00% Road & Bridge Tax 26,084 26,084 20.1% 130,000 67,681 -61.46% Personal Property Replacement Tax - 2,414 14.6% 16,500 4,406 -45.22% Other Intergovernmental 788 21,064 58.6% 35,925 266 7818.68% Total Intergovernmental 206,506$ 469,158$ 16.9% 2,770,234$ 671,799$ -30.16% Licenses & Permits Liquor Licenses 1,965$ 5,046$ 7.8% 65,000$ 2,061$ 144.85% Building Permits 41,019 80,900 20.2% 400,000 81,892 -1.21% Other Licenses & Permits 2,647 2,957 31.1%9,500 3,251 -9.05% Total Licenses & Permits 45,630$ 88,904$ 18.7% 474,500$ 87,204$ 1.95% Fines & Forfeits Circuit Court Fines 2,087$ 2,950$ 7.4% 40,000$ 7,303$ -59.60% Administrative Adjudication 1,237 3,521 12.8% 27,500 3,754 -6.21% Police Tows 6,000 9,000 20.0% 45,000 4,500 100.00% Other Fines & Forfeits - - 0.0%500 60 -100.00% Total Fines & Forfeits 9,325$ 15,471$ 13.7% 113,000$ 15,617$ -0.93% Charges for Services ^Garbage Surcharge 221,192$ 221,674$ 17.1% 1,297,650$ 209,992$ 5.56% ^Late PMT Penalties - Garbage 2 2 0.0% 25,000 3,835 -99.95% ^UB Collection Fees 25,982 39,924 24.2% 165,000 28,822 38.52% Administrative Chargebacks 17,825 35,649 16.7% 213,896 34,139 4.42% Other Services - - 0.0%500 - 0.00% Total Charges for Services 265,000$ 297,249$ 17.5% 1,702,046$ 276,788$ 7.39% Investment Earnings 1,561$ 3,582$ 4.0% 89,878$ 21,306$ -83.19% UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended June 30, 2020 * Fiscal Year 2020 For the Month Ended June 30, 2019 22 June YTD % of FY 2021 Actual Actual Budget Budget YTD Actual % Change UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended June 30, 2020 * Fiscal Year 2020 For the Month Ended June 30, 2019 GENERAL FUND (01) (continued) Reimbursements/Miscellaneous/Transfers In Reimb - Engineering & Legal Expenses -$ -$ 0.0% 25,000$ -$ 0.00% Other Reimbursements 5,763 15,411 24.5% 63,000 12,605 22.26% Rental Income - - 0.0%7,000 1,180 -100.00% Miscellaneous Income & Transfers In 16,501 16,501 34.4% 48,000 23,047 -28.40% Total Miscellaneous 22,264$ 31,913$ 22.3% 143,000$ 36,832$ -13.36% Total Revenues and Transfers 2,790,828$ 3,673,853$ 21.7% 16,933,486$ 3,999,103$ -8.13% Expenditures Administration 79,173$ 172,797$ 17.4%992,350$ 181,257$ -4.67% 50 Salaries 50,027 114,165 18.7% 611,747 111,262 2.61% 52 Benefits 19,127 45,096 21.3% 211,572 51,201 -11.92% 54 Contractual Services 9,855 13,372 8.9% 150,031 17,536 -23.75% 56 Supplies 165 165 0.9% 19,000 1,258 -86.92% Finance 35,253$ 86,006$ 15.3%562,508$ 86,309$ -0.35% 50 Salaries 24,603 57,213 17.6% 324,856 57,832 -1.07% 52 Benefits 8,657 23,982 19.5% 123,295 23,499 2.06% 54 Contractual Services 1,860 4,677 4.2% 111,857 4,931 -5.14% 56 Supplies 133 133 5.3%2,500 47 183.96% Police 961,032$ 1,445,374$ 23.8%6,064,220$ 1,439,493$ 0.41% Salaries 258,680 595,165 17.9% 3,323,608 584,738 1.78% Overtime 12,682 17,149 15.4% 111,000 21,907 -21.72% 52 Benefits 659,681 793,843 36.0% 2,205,107 775,141 2.41% 54 Contractual Services 23,921 33,149 10.7% 311,025 47,360 -30.01% 56 Supplies 6,069 6,069 5.3% 113,480 10,347 -41.34% Community Development 65,356$ 148,551$ 15.8%942,154$ 143,295$ 3.67% 50 Salaries 49,488 104,809 19.6% 535,995 99,140 5.72% 52 Benefits 16,070 41,709 20.7% 201,768 40,550 2.86% 54 Contractual Services (522) 1,715 0.9% 194,700 2,526 -32.12% 56 Supplies 320 320 3.3%9,691 1,079 -70.39% PW - Street Ops & Sanitation 73,737$ 162,573$ 6.5%2,512,538$ 122,028$ 33.23% Salaries 36,028 83,779 15.8% 529,443 69,464 20.61% Overtime 304 304 1.5% 20,000 819 -62.93% 52 Benefits 16,246 44,878 18.3% 245,418 36,333 23.52% 54 Contractual Services 17,264 29,580 1.9% 1,591,767 10,838 172.93% 56 Supplies 3,896 4,032 3.2% 125,910 4,574 -11.85% Administrative Services 294,526$ 601,066$ 10.3%5,824,862$ 659,902$ -8.92% 50 Salaries - - 0.0%500 - 0.00% 52 Benefits 27,573 118,896 29.9% 398,253 113,108 5.12% 54 Contractual Services 93,437 131,140 4.0% 3,245,272 155,143 -15.47% 56 Supplies - - 0.0% 15,000 - 0.00% 99 Transfers Out 173,515 351,031 16.2% 2,165,837 391,651 -10.37% Total Expenditures and Transfers 1,509,077$ 2,616,369$ 15.5% 16,898,632$ 2,632,284$ -0.60% Surplus(Deficit)1,281,752$ 1,057,484$ 34,854$ 1,366,819$ ^modified accruals basis *June represents 17% of fiscal year 2021 50 50 23 June YTD % of FY 2021 Actual Actual Budget Budget YTD Actual % Change WATER FUND (51) Revenues ^ Water Sales 494,075$ 493,551$ 15.8% 3,129,000$ 506,657$ -2.59% ^ Water Infrastructure Fees 134,919 135,373 17.0% 795,000 130,998 3.34% ^ Late Penalties 19 19 0.0% 131,250 17,705 -99.89% Water Connection Fees 12,700 47,714 20.7% 230,000 63,265 -24.58% Bulk Water Sales - (1,950) -39.0% 5,000 - 0.00% Water Meter Sales 12,150 22,000 36.7% 60,000 33,282 -33.90% Total Charges for Services 653,863$ 696,707$ 16.0% 4,350,250$ 751,907$ -7.34% Investment Earnings 140$ 289$ 1.3% 22,557$ 3,193$ -90.96% Reimbursements/Miscellaneous/Transfers In Reimbursements -$ 9,459$ 0.0%-$ -$ 0.00% Rental Income 8,295 16,590 16.6% 100,010 19,065 -12.98% Miscellaneous Income & Transfers In 15,309 30,227 16.9% 179,270 30,621 -1.29% Total Miscellaneous 23,604$ 56,276$ 20.2% 279,280$ 49,686$ 13.26% Total Revenues and Transfers 677,606$ 753,272$ 16.2% 4,652,087$ 804,786$ -6.40% Expenses Water Operations Salaries 33,324$ 82,157$ 16.9% 487,530$ 70,584$ 16.40% Overtime 438 877 4.0% 22,000 1,007 -12.94% 52 Benefits 17,130 50,301 20.9% 241,168 44,368 13.37% 54 Contractual Services 40,661 71,944 6.7% 1,078,983 73,300 -1.85% 56 Supplies 22,918 25,446 7.1% 359,273 24,518 3.78% 60 Capital Outlay 3,781$ 7,562$ 1,333,243$ 7,562$ 0.00% Water Tower Painting - - 0.0% 18,000 Road to Better Roads Program - - 0.0% 634,000 US 34 Project (IL Rte 47 to Orchard)- - 0.0%7,700 Route 71 Watermain Replacement - - 0.0% 12,871 Route 47 Expansion 3,781 7,562 16.7% 45,372 Cation Exchange Media Replacement - - 0.0% 25,000 Equipment - - 0.0% 500,300 Vehicles & Equipment - - 0.0% 90,000 Debt Service 68,950$ 139,034$ 2,305,935$ 175,493$ -20.78% 2015A Bond - 70,084 16.0% 438,004 2016 Refunding Bond 58,825 58,825 3.7% 1,592,650 IEPA Loan L17-156300 - - 0.0% 125,031 2014C Refunding Bond 10,125 10,125 6.7% 150,250 Total Expenses 187,201$ 377,321$ 6.5% 5,828,132$ 396,832$ -4.92% Surplus(Deficit)490,405$ 375,951$ (1,176,045)$ 407,954$ ^modified accruals basis *June represents 17% of fiscal year 2021 94 Charges for Services 89 50 6025 6059 6015 6066 6081 6079 6070 77 85 6060 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENSES AND TRANSFERS For the Month Ended June 30, 2020 * Fiscal Year 2020 For the Month Ended June 30, 2019 24 June YTD % of FY 2021 Actual Actual Budget Budget YTD Actual % Change SEWER FUND (52) Revenues ^Sewer Maintenance Fees 168,955$ 169,493$ 16.5% 1,024,850$ 164,594$ 2.98% ^Sewer Infrastructure Fees 64,842 65,078 16.7% 390,000 62,071 4.85% River Crossing Fees - - 0.0%- 300 -100.00% ^Late Penalties 3 3 0.0% 17,500 2,703 -99.87% Sewer Connection Fees 3,000 16,000 7.9% 203,300 51,900 -69.17% Total Charges for Services 236,801$ 250,575$ 15.3% 1,635,650$ 281,568$ -11.01% Investment Earnings 63$134$1.8%7,473$1,180$-88.64% Reimbursements/Miscellaneous/Transfers In Miscellaneous Income 215$215$0.0%-$ 420$-48.81% Transfers In 14,562 29,124 16.7% 174,744 95,838 -69.61% Total Miscellaneous & Transfers 14,777$ 29,339$ 16.8% 174,744$ 96,258$ -69.52% Total Revenues and Transfers 251,641$ 280,048$ 15.4% 1,817,867$ 379,006$ -26.11% Expenses Sewer Operations Salaries 18,575$ 45,284$ 17.7% 255,561$ 32,972$ 37.34% Overtime 88 88 17.7%500 47 87.91% 52 Benefits 10,864 32,340 21.9% 147,784 24,153 33.90% 54 Contractual Services 11,862 17,369 7.4% 234,167 14,528 19.55% 56 Supplies 1,583 1,729 2.5% 68,256 2,329 -25.77% 60 Capital Outlay 1,873$ 7,970$204,361$ 3,747$ 112.70% SCADA -- 0.0% 67,000 US 34 Project (IL Rte 47 to Orchard)-- 0.0%650 Route 71 Sewer Main Replacement -- 0.0% 34,223 Equipment -4,223 5.3% 80,000 Route 47 Expansion 1,873 3,747 16.7% 22,488 Debt Service 126,474$ 126,474$ 1,300,798$ 144,557$ -12.51% 2003 IRBB Debt Certificates --0.0% 162,850 2011 Refunding Bond 126,474 126,474 11.1% 1,137,948 99 Transfers Out 6,260$12,521$ 16.7% 75,125$ 12,313$ 1.69% Total Expenses and Transfers 177,580$ 243,776$ 10.7% 2,286,552$ 234,646$ 3.89% Surplus(Deficit)74,061$ 36,272$ (468,685)$ 144,360$ ^modified accruals basis *June represents 17% of fiscal year 2021 6079 90 92 6060 Charges for Services 50 6001 6059 6066 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENSES AND TRANSFERS For the Month Ended June 30, 2020 * Fiscal Year 2020 For the Month Ended June 30, 2019 25 June YTD % of FY 2021 Actual Actual Budget Budget YTD Actual % Change PARKS & RECREATION FUND (79) Revenues Charges for Services Special Events 1,525$ 2,610$ 2.9% 90,000$ 25,762$ -89.87% Child Development 1,837 6,301 4.3% 145,000 16,766 -62.42% Athletics & Fitness 2,606 5,267 1.4% 370,000 79,506 -93.38% Concession Revenue 1,761 1,943 4.3% 45,000 23,867 -91.86% Total Charges for Services 7,729$ 16,121$ 2.5% 650,000$ 145,901$ -88.95% Investment Earnings 87$ 200$ 15.4%1,300$ 228$ -12.45% Reimbursements/Miscellaneous/Transfers In Reimbursements -$ -$ 0.0%-$ -$ 0.00% Rental Income 2,000 51,816 80.7% 64,216 49,600 4.47% Park Rentals - 1,120 6.4% 17,500 5,553 -79.83% Hometown Days - 1,675 1.4% 120,000 7,515 -77.71% Sponsorships & Donations - 1,872 9.4% 20,000 11,858 -84.21% Miscellaneous Income & Transfers In 111,528 220,635 16.8% 1,314,284 238,222 -7.38% Total Miscellaneous 113,528$ 277,118$ 18.0% 1,536,000$ 312,748$ -11.39% Total Revenues and Transfers 121,344$ 293,438$ 13.4% 2,187,300$ 458,877$ -36.05% Expenditures Parks Department 69,336$ 172,472$ 13.4%1,289,685$ 207,468$ -16.87% Salaries 44,902 109,931 16.6% 660,936 125,177 -12.18% Overtime 519 519 10.4%5,000 391 32.77% 52 Benefits 22,559 60,039 20.9% 286,628 66,043 -9.09% 54 Contractual Services 1,928 2,555 1.7% 146,712 3,578 -28.58% 56 Supplies (573) (573) -0.3% 190,409 12,279 -104.66% Recreation Department 44,952$ 123,142$ 9.7%1,267,077$ 188,517$ -34.68% 50 Salaries 28,828 71,071 14.0% 506,076 91,813 -22.59% 52 Benefits 12,207 34,329 17.3% 198,372 37,998 -9.65% 54 Contractual Services 1,913 3,119 1.3% 245,853 19,459 -83.97% 56 Hometown Days - 11,725 9.8% 120,000 10,800 8.56% 56 Supplies 2,005 2,898 1.5% 196,776 28,447 -89.81% Total Expenditures 114,288$ 295,614$ 11.6% 2,556,762$ 395,985$ -25.35% Surplus(Deficit)7,056$ (2,176)$ (369,462)$ 62,892$ *June represents 17% of fiscal year 2021 YORKVILLE PARKS & RECREATION STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended June 30, 2020 * Fiscal Year 2020 For the Month Ended June 30, 2019 50 26 June YTD % of FY 2021 Actual Actual Budget Budget YTD Actual % Change LIBRARY OPERATIONS FUND (82) Revenues Property Taxes 745,006$ 745,006$ 47.7% 1,562,000$ 759,865$ -1.96% Intergovernmental Personal Property Replacement Tax -$ 800$ 15.2%5,250$ 1,460$ -45.21% State Grants - - 0.0% 20,000 - 0.00% Total Intergovernmental -$ 800$ 3.2% 25,250$ 1,460$ -45.21% Library Fines 1,072$ 1,072$ 12.6%8,500$ 1,145$ -6.45% Charges for Services Library Subscription Cards 476$ 476$ 5.6%8,500$ 2,075$ -77.06% Copy Fees 3 3 0.1%3,800 616 -99.48% Program Fees - - 0.0%- 15 -100.00% Total Charges for Services 479$ 479$ 3.9% 12,300$ 2,706$ -82.30% Investment Earnings 142$ 345$ 3.8%8,959$ 1,415$ -75.63% Reimbursements/Miscellaneous/Transfers In Miscellaneous Reimbursements -$ -$ 0.0%-$ -$ 0.00% Rental Income - - 0.0%1,750 200 -100.00% Miscellaneous Income 324 325 16.2%2,000 2,352 -86.19% Transfers In 1,911 7,822 29.4% 26,584 7,418 5.45% Total Miscellaneous & Transfers 2,235$ 8,147$ 26.9% 30,334$ 9,969$ -18.28% Total Revenues and Transfers 748,934$ 755,849$ 45.9% 1,647,343$ 776,561$ -2.67% Expenditures Library Operations 122,390$ 205,437$ 12.3%1,664,378$ 221,507$ -7.25% 50 Salaries 30,329 81,860 17.1% 479,742 84,664 -3.31% 52 Benefits 16,778 41,471 23.1% 179,800 37,014 12.04% 54 Contractual Services 2,955 9,779 6.4% 152,448 16,984 -42.42% 56 Supplies 1,284 1,284 5.1% 25,300 1,840 -30.23% 99 Debt Service 71,044 71,044 8.6% 827,088 81,006 -12.30% Total Expenditures and Transfers 122,390$ 205,437$ 12.3% 1,664,378$ 221,507$ -7.25% Surplus(Deficit)626,544$ 550,411$ (17,035)$ 555,054$ *June represents 17% of fiscal year 2021 YORKVILLE PUBLIC LIBRARY STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended June 30, 2020 * Fiscal Year 2020 For the Month Ended June 30, 2019 27 DATE: 07/06/2020 UNITED CITY OF YORKVILLE PAGE: 1TIME: 15:02:53 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2021 ACTIVITY THROUGH FISCAL PERIOD 02PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________01-110-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.0002 AP-200609B 06/03/2020 13 05/12/20 CC MEETING CHRISTINE M. VITOSH 532890 CMV 1980 243.14 06/03/2020 14 05/07/20 PUBLIC SAFETY MEETING MARLYS J. YOUNG 532893 050720 58.25 06/03/2020 15 05/19/20 PW MEETING MINUTES MARLYS J. YOUNG 532893 051920 40.50 AP-200623B 06/17/2020 18 05/26 CITY COUNCIL MEETING CHRISTINE M. VITOSH 532983 CMV 1982 201.12 06/17/2020 19 05/20/20 ADMIN MEETING MINUTES MARLYS J. YOUNG 532988 052020 50.00 AP-200625MB 06/16/2020 03 ZOOM-05/22-06/23 MONTHLY COSTS FIRST NATIONAL BANK 900090 062520-B.OLSON-B 154.97 AP-200714 06/29/2020 28 MAY 2020 COBRA FLEX BENEFIT SERVICE 533010 139234 50.00 06/29/2020 29 06/09/20 CC HEARING CHRISTINE M. VITOSH 533045 CMV 1983 228.20 GJ-200714RV 06/29/2020 28 Reverse AP-200714 50.00 06/29/2020 29 Reverse AP-200714 228.20 _________________________________ TOTAL PERIOD 02 ACTIVITY 1,026.18 278.20 YTD BUDGET 2,000.00 TOTAL ACCOUNT ACTIVITY 1,026.18 278.20 ANNUAL REVISED BUDGET 12,000.00 ENDING BALANCE 747.98_____________________________________________________________________________________________________________________________________________________01-120-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 GJ-200531FE 06/02/2020 01 UB CC Fees - Apr 2020 611.98 06/02/2020 07 UB Paymentus Fees - Apr 2020 1,218.83 06/02/2020 13 FNBO Analysis Chrg - Apr 2020 301.68 _________________________________ TOTAL PERIOD 01 ACTIVITY 2,132.49 0.0002 GJ-200630FE 06/29/2020 01 UB CC Fees - May 2020 311.34 06/29/2020 07 UB Paymentus Fees - May 2020 1,115.62 06/29/2020 13 FNBO Analysis Chrg - May 2020 291.06 _________________________________ TOTAL PERIOD 02 ACTIVITY 1,718.02 0.00 YTD BUDGET 10,833.34 TOTAL ACCOUNT ACTIVITY 3,850.51 0.00 ANNUAL REVISED BUDGET 65,000.00 ENDING BALANCE 3,850.51_____________________________________________________________________________________________________________________________________________________01-210-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.0002 AP-200609B 06/03/2020 26 SOFTWARE MAINTENANCE RENEWAL JEFFREY C DAVIES 532864 788 600.00 AP-200623B 06/17/2020 39 CAPERS SOFTWARE MAINTENANCE CAPERS LLC 532931 INV-0751 5,000.00 AP-200625MB 06/16/2020 15 ACCURINT-MAY 2020 SEARCHES FIRST NATIONAL BANK 900090 062520-N.DECKER-B 150.00 _________________________________ TOTAL PERIOD 02 ACTIVITY 5,750.00 0.00 YTD BUDGET 6,125.00 TOTAL ACCOUNT ACTIVITY 5,750.00 0.00 ANNUAL REVISED BUDGET 36,750.00 ENDING BALANCE 5,750.00_____________________________________________________________________________________________________________________________________________________01-220-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.0002 AP-200604R 06/04/2020 08 TEXT AMENDMENT PUBLIC HEARING CHRISTINE M. VITOSH 530149 1958 79.78 GJ-200604VD 06/04/2020 04 VITOSH INV 1958 VD 530893 79.78 AP-200625MB 06/16/2020 34 ADOBE-MONTHLY CLOUD FEE FIRST NATIONAL BANK 900090 062520-J.ENGBERG-B 52.99 _________________________________ TOTAL PERIOD 02 ACTIVITY 132.77 79.78 YTD BUDGET 15,416.68 TOTAL ACCOUNT ACTIVITY 132.77 79.78 ANNUAL REVISED BUDGET 92,500.00 ENDING BALANCE 52.99_____________________________________________________________________________________________________________________________________________________01-410-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 DATE: 07/06/2020 UNITED CITY OF YORKVILLE PAGE: 2TIME: 15:03:02 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2021 ACTIVITY THROUGH FISCAL PERIOD 02PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________01-410-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 AP-200525MB 05/19/2020 02 MINER#100594-MAY 2020 MANAGED FIRST NATIONAL BANK 900088 052520-K.GREGORY-B 366.85 _________________________________ TOTAL PERIOD 01 ACTIVITY 366.85 0.0002 AP-200623B 06/17/2020 58 04/29-05/28 COPIER CHARGES IMPACT NETWORKING, L 532947 1796944 2.50 AP-200625MB 06/16/2020 37 APWA-MEMBERSHIP RENEWAL FIRST NATIONAL BANK 900090 062520-E.DHUSE-B 300.00 06/16/2020 38 MINER#100630-JUN 2020 MANAGED FIRST NATIONAL BANK 900090 062520-K.GREGORY-B 366.85 AP-200714 06/29/2020 85 ALICE ST STORM SEWER INLETS INNOVATIVE UNDERGROU 533019 1521 1,000.00 GJ-200714RV 06/29/2020 85 Reverse AP-200714 1,000.00 _________________________________ TOTAL PERIOD 02 ACTIVITY 1,669.35 1,000.00 YTD BUDGET 1,537.50 TOTAL ACCOUNT ACTIVITY 2,036.20 1,000.00 ANNUAL REVISED BUDGET 9,225.00 ENDING BALANCE 1,036.20_____________________________________________________________________________________________________________________________________________________01-640-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.0002 AP-200609B 06/03/2020 58 2019 DRAINAGE DISTRICT FEES KENDALL COUNTY COLLE 532876 2019DDF 522.92 _________________________________ TOTAL PERIOD 02 ACTIVITY 522.92 0.00 YTD BUDGET 1,375.00 TOTAL ACCOUNT ACTIVITY 522.92 0.00 ANNUAL REVISED BUDGET 8,250.00 ENDING BALANCE 522.92_____________________________________________________________________________________________________________________________________________________11-111-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 521.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 3,126.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________12-112-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 521.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 3,126.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________23-230-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 833.34 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/2020 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/2020 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/2020 BEGINNING BALANCE 0.00 GJ-00521PRE 05/28/2020 32 Itron-May Host Srvcs 624.39 AP-200525MB 05/19/2020 07 MINER#100594-MAY 2020 MANAGED FIRST NATIONAL BANK 900088 052520-K.GREGORY-B 430.65 DATE: 07/06/2020 UNITED CITY OF YORKVILLE PAGE: 3TIME: 15:03:34 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2021 ACTIVITY THROUGH FISCAL PERIOD 02PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________51-510-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 AP-200526B 05/19/2020 36 JUNE 2020 HOSTING SERVICES ITRON 532821 555744 624.39 GJ-200531FE 06/02/2020 03 UB CC Fees - Apr 2020 819.90 06/02/2020 09 UB Paymentus Fees - Apr 2020 1,632.94 06/02/2020 15 FNBO Analysis Chrg - Apr 2020 404.18 _________________________________ TOTAL PERIOD 01 ACTIVITY 4,536.45 0.0002 AP-200609B 06/03/2020 74 SOFTWARE RENEWAL SENSUS USA, INC 532887 ZA20209152 1,949.94 AP-200625MB 06/16/2020 64 MINER#100630-JUN 2020 MANAGED FIRST NATIONAL BANK 900090 062520-K.GREGORY-B 430.65 GJ-200630FE 06/29/2020 03 UB CC Fees - May 2020 417.12 06/29/2020 09 UB Paymentus Fees - May 2020 1,494.66 06/29/2020 15 FNBO Analysis Chrg - May 2020 389.95 _________________________________ TOTAL PERIOD 02 ACTIVITY 4,682.32 0.00 YTD BUDGET 25,833.34 TOTAL ACCOUNT ACTIVITY 9,218.77 0.00 ANNUAL REVISED BUDGET 155,000.00 ENDING BALANCE 9,218.77_____________________________________________________________________________________________________________________________________________________52-520-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 AP-200525MB 05/19/2020 09 MINER#100594-MAY 2020 MANAGED FIRST NATIONAL BANK 900088 052520-K.GREGORY-B 287.10 GJ-200531FE 06/02/2020 05 UB CC Fees - Apr 2020 382.46 06/02/2020 11 UB Paymentus Fees - Apr 2020 761.73 06/02/2020 17 FNBO Analysis Chrg - Apr 2020 188.54 _________________________________ TOTAL PERIOD 01 ACTIVITY 1,619.83 0.0002 AP-200623B 06/17/2020 152 ALARM MONITORING FOR WIRE WIZARD OF ILLIN 532985 34002 138.00 AP-200625MB 06/16/2020 73 APWA-MEMBERSHIP RENEWAL FIRST NATIONAL BANK 900090 062520-E.DHUSE-B 250.00 06/16/2020 74 MINER#100630-JUN 2020 MANAGED FIRST NATIONAL BANK 900090 062520-K.GREGORY-B 287.10 GJ-200630FE 06/29/2020 05 UB CC Fees - May 2020 194.57 06/29/2020 11 UB Paymentus Fees - May 2020 697.22 06/29/2020 17 FNBO Analysis Chrg - May 2020 181.90 AP-200714 06/29/2020 167 INSTALLED 8" MUNI PLUG ON INNOVATIVE UNDERGROU 533019 1522 500.00 06/29/2020 168 INSTALLED 6" CIPP SPOT REPAIR INNOVATIVE UNDERGROU 533019 1523 2,500.00 GJ-200714RV 06/29/2020 167 Reverse AP-200714 500.00 06/29/2020 168 Reverse AP-200714 2,500.00 _________________________________ TOTAL PERIOD 02 ACTIVITY 4,748.79 3,000.00 YTD BUDGET 7,583.34 TOTAL ACCOUNT ACTIVITY 6,368.62 3,000.00 ANNUAL REVISED BUDGET 45,500.00 ENDING BALANCE 3,368.62_____________________________________________________________________________________________________________________________________________________79-790-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 AP-200525MB 05/19/2020 11 MINER#100594-MAY 2020 MANAGED FIRST NATIONAL BANK 900088 052520-K.GREGORY-B 510.40 _________________________________ TOTAL PERIOD 01 ACTIVITY 510.40 0.0002 AP-200623B 06/17/2020 175 04/29-05/28 COPIER CHARGES IMPACT NETWORKING, L 532947 1796944 34.26 AP-200625MB 06/16/2020 83 MINER#100630-JUN 2020 MANAGED FIRST NATIONAL BANK 900090 062520-K.GREGORY-B 510.40 _________________________________ TOTAL PERIOD 02 ACTIVITY 544.66 0.00 YTD BUDGET 1,900.00 TOTAL ACCOUNT ACTIVITY 1,055.06 0.00 ANNUAL REVISED BUDGET 11,400.00 ENDING BALANCE 1,055.06_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 DATE: 07/06/2020 UNITED CITY OF YORKVILLE PAGE: 4TIME: 15:03:58 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2021 ACTIVITY THROUGH FISCAL PERIOD 02PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 GJ-200531FE 06/02/2020 19 PR CC Fees - Apr 2020 195.19 _________________________________ TOTAL PERIOD 01 ACTIVITY 195.19 0.0002 AP-200604R 06/04/2020 11 UMPIRE JOSHUA S LINDHOLM 530145 JUNE 24-JULY 7 55.00 AP-200605VD 06/04/2020 07 UMPIRE :VOID 530601 JOSHUA S LINDHOLM 530145 JUNE 24-JULY 7 55.00 AP-200609B 06/03/2020 122 MAY 2020 YOGA ZOOM SESSIONS ELIZABETH J HERIAUD 532870 515-0519-209 100.00 06/03/2020 123 KINDERJAM CLASS INSTRUCTION CYNTHIA ROCHELLE HUE 532878 KJ1109 56.00 06/03/2020 124 CHILD & BABYSITTING SAFETY SECOND CHANCE CARDIA 532886 20-005-290 157.50 AP-200623B 06/17/2020 190 04/29-05/28 COPIER CHARGES IMPACT NETWORKING, L 532947 1796944 34.28 06/17/2020 191 MAY VIRTUAL MAGIC CLASS GARY KANTOR 532952 060720 10.40 GJ-200630FE 06/29/2020 19 PR CC Fees - May 2020 337.80 _________________________________ TOTAL PERIOD 02 ACTIVITY 750.98 55.00 YTD BUDGET 23,333.34 TOTAL ACCOUNT ACTIVITY 946.17 55.00 ANNUAL REVISED BUDGET 140,000.00 ENDING BALANCE 891.17_____________________________________________________________________________________________________________________________________________________82-820-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 GJ-00521PRE 05/28/2020 55 Sound Inc-May Srvc Aggrmnt 97.00 AP-200511B 05/04/2020 01 MAY 2020 COPIER LEASE DLL FINANCIAL SERVIC 104889 67565916 194.48 05/04/2020 02 MAY-JULY 2020 MAINTENANCE SOUND INCORPORATED 104891 R168569 929.52 05/04/2020 03 ANNUAL SERVICE AGREEMENT TODAY'S BUSINESS SOL 104892 10498 2,644.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 3,865.00 0.0002 AP-200608B 06/03/2020 01 SERVICE AGREEMENT FOR SOUND INCORPORATED 104896 R169019 291.00 06/03/2020 02 ELEVATOR MAINTENCE MAY - THYSSENKRUPP ELEVATO 104897 3005222849 560.01 AP-200609B 06/03/2020 129 05/11/20 LIBRARY BOARD MEETING MARLYS J. YOUNG 532893 051120 74.50 AP-200623B 06/17/2020 204 06/02 LIBRARY MEETING MINUTES MARLYS J. YOUNG 532988 060120 60.00 AP-200714 06/29/2020 215 06/08/20 LIBRARY MEETING MARLYS J. YOUNG 533047 060820 79.50 GJ-200714RV 06/29/2020 215 Reverse AP-200714 79.50 _________________________________ TOTAL PERIOD 02 ACTIVITY 1,065.01 79.50 YTD BUDGET 6,666.68 TOTAL ACCOUNT ACTIVITY 4,930.01 79.50 ANNUAL REVISED BUDGET 40,000.00 ENDING BALANCE 4,850.51_____________________________________________________________________________________________________________________________________________________87-870-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 333.34 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 2,000.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________88-880-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 166.68 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 1,000.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________89-890-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 833.34 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 5,000.00 ENDING BALANCE 0.00 GRAND TOTAL 31,344.73 0.00 TOTAL DIFFERENCE 31,344.73 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 2020-46 Treasurer’s Report for June 2020 Administration Committee – July 15, 2020 Majority Approval Rob Fredrickson Finance Name Department June Revenues YTD Revenues Revenue Budget % of Budget June Expenses YTD Expenses Expense Budget % of Budget General Fund01 - General 2,790,828$ 3,673,853$ 16,933,486$ 22% 1,509,076$ 2,616,368$ 16,898,632$ 15%Special Revenue Funds15 - Motor Fuel Tax 44,942 310,714 813,861 38% 67,843 73,992 1,117,462 7%79 - Parks and Recreation 121,345 293,438 2,187,300 13% 114,288 295,614 2,556,762 12%72 - Land Cash 162 2,061 33,858 6% - 5,290 240,287 2%87 - Countryside TIF 16,491 16,491 153,965 11% 956 52,486 222,486 24%88 - Downtown TIF 25,320 25,320 76,000 33% 215,698 219,113 306,052 72%89 - Downtown TIF II 18,481 18,481 25,000 0% - - 22,500 0%11 - Fox Hill SSA 8,166 8,166 16,034 51% - - 37,326 0%12 - Sunflower SSA 9,580 9,580 20,363 47% 400 400 20,326 2%Debt Service Fund42 - Debt Service 26,719 53,388 323,225 17% 13,875 13,875 323,225 4%Capital Project Funds25 - Vehicle & Equipment 23,685 49,118 448,823 11% 5,964 18,936 651,794 3%23 - City-Wide Capital 160,468 227,840 1,335,670 17% 16,314 88,284 1,628,147 5%Enterprise Funds *51 - Water 677,606 753,272 4,652,087 16% 187,201 377,321 5,828,132 6%*52 - Sewer 251,641 280,048 1,817,867 15% 177,580 243,776 2,286,552 11%Library Funds82 - Library Operations 748,934 755,848 1,647,343 46% 122,390 205,437 1,664,378 12%84 - Library Capital 1,541 5,057 50,500 10% 2,963 2,963 75,500 4%Total Funds 4,925,910$ 6,482,674$ 30,535,382$ 21% 2,434,548$ 4,213,854$ 33,879,561$ 12%* Fund Balance EquivalencyRob Fredrickson, Finance Director/TreasurerUNITED CITY OF YORKVILLE TREASURER'S REPORT - for the month ending June 30, 2020Cash 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 2020-47 Cash Statement for May 2020 Administration Committee – July 15, 2020 Informational None Rob Fredrickson Finance Name Department First National West Suburban Associated Illinois Trust Illinois Funds Old Second Grand Totals Restricted at IMET General Fund01 - General 1,820,608$ 107,746$ 3,390,651$ 101,007$ 1,085,954$ -$ 6,505,966$ 42,464$ Special Revenue Funds15 - Motor Fuel Tax 202,789 - - - 696,325 - 899,114 - 72 - Land Cash239,752 - - - - - 239,752 - 87 - Countryside TIF(1,193,314) - - - - - (1,193,314) - 88 - Downtown TIF(1,240,964) - - - - - (1,240,964) - 89 - Downtown TIF II(73,799) - - - - - (73,799) - 11 - Fox Hill SSA14,066 - - - - - 14,066 - 12 - Sunflower SSA(15,626) - - - - - (15,626) - Debt Service Fund42 - Debt Service30,577 - - - - - 30,577 - Capital Project Funds23 - City-Wide Capital275,592 66,139 694,994 - - - 1,036,726 53,517 25 - Police Capital70,442 - - - - - 70,442 - 25 - General Gov Capital(4,442) - - - - - (4,442) - 25 - Public Works Capital87,272 - - - - - 87,272 - Enterprise Funds51 - Water790,318 352,181 1,449,751 - - - 2,592,250 7,114 52 - Sewer415,119 119,713 529,255 - - - 1,064,088 33,437 Agency Funds90 - Developer Escrow 160,468 - - - - - 160,468 - 95 - Escrow Deposit59,890 293,674 - - - - 353,564 - Total City Funds1,638,749$ 939,453$ 6,064,652$ 101,007$ 1,782,280$ -$ 10,526,140$ 136,532$ Distribution %15.57%8.92% 57.62%0.96% 16.93%Library Funds82 - Library Operations54$ -$ -$ -$ 236,679$ 319,906$ 556,638$ 4,126$ 84 - Library Capital3,500 - - - - 123,389 126,889 - Library Totals 3,554$ -$ -$ -$ 236,679$ 443,294$ 683,526$ 4,126$ Distribution %0.52%34.63% 64.85%Park and Recreation Funds79 - Parks and Recreation 532,531$ -$ -$ -$ -$ -$ 532,531$ -$ 25 - Park & Rec Capital443,498 - - - - - 443,498 1,221 Park & Rec Totals 976,029$ -$ -$ -$ -$ -$ 976,029$ 1,221$ Distribution % 100.00%UNITED CITY OF YORKVILLECASH AND INVESTMENT SUMMARY - as of May 31, 2020Cash Summary 1 FinancialAccrued Type of Investment Institution FDIC # Interest Rate Original Cost Maturity Date Interest to Date Value at Maturity FundCertificate of Deposit (CD) Sonabank 57968 2.49% 243,800$ 6/17/2020 5,786$ 249,868$ General (01)Certificate of Deposit (CD)Western Alliance Bank57512 1.62% 246,000 2/25/2021 1,037 249,917 General (01)489,800$ 6,823$ 499,785$ UNITED CITY OF YORKVILLECASH AND INVESTMENT SUMMARY - as of May 31, 2020Investments 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 2020-48 Website Report for June 2020 Administration Committee – July 15, 2020 Informational None. See attached memo. Erin Willrett Administration Name Department 0 5,000 10,000 15,000 20,000 25,000 30,000 Total  Visits Total Visits Summary Yorkville’s website and social media analytics report for June 2020. Background Every month at the Administration Committee meeting, the website data from the previous month will be highlighted. This month’s highlight is June 1, 2020 – June 30, 2020. Website Visits:   June  2019  July  2019  Aug  2019  Sept  2019  Oct  2019  Nov  2019  Dec  2019  Jan  2020  Feb  2020  March  2020  April  2020  May  2020  June  2020  Unique  Visitors 17,246 21,699 20,358 13,262 14,179 11,539 8,911 10,678 10,151 14,408 12,529 12,747 18,527  Returning  Visits 8,412 10,546 9,629 6,405 7,084 5,659 3,593 4,785 4,458 5,233 4,841 4,832 7,592  Total Visits 22,768 20,020 27,106 17,156 18,975 15,297 11,244 14,041 13,192 18,067 15,953 16,173 23,895  Visit Times (Averages):  1 minute 59 second average visit duration  2.4 actions (page views, downloads, outlinks and internal site searches) per visit Memorandum To: Administration Committee From: Erin Willrett, Assistant Administrator CC: Bart Olson, City Administrator Date: July 15, 2020 Subject: Website Report for June 2020 Website Statistics: April 2020 May 2020 June 2020i Top 5 Pages Visited 1. Homepage 2. Online Utility Payments 3. My Gov Hub Transition Page 4. COVID-19 Update 5. Pick-Up Service Schedules 1. Homepage 2. COVID-19 Update 3. Online Utility Payments 4. Facilities Overview 5. My Gov Hub Transition Page 1. Homepage 2. Feature Overview 3. White Goods 4. Fourth of July Celebration 5. Online Utility Payments April 2020 May 2020 June 2020ii Top 5 Downloads 1. Residential Permit Application 2. Annual Drinking Water Quality Report 3. Concrete and Paver Patio Information 4. Fence Permit 5. Shed and Accessory Structures 1. Residential Permit Application 2. Pool Permit Information 3. Concrete and Paver Patio Information 4. Annual Drinking Quality Report 5. Park and Playground Information 1. Residential Permit Application 2. Pool Permit Information 3. Parks Map and Matrix 4. Annual Drinking Quality Report 5. Concrete and Paver Patio Information April 2020 May 2020 June 2020 Top 5 Searches 1. True 2. Meters 3. Chickens 4. Garbage 5. Request for Meter Reading 1. True 2. Pool 3. Meter 4. Request for Meter Reading 5. Permit 1. Meter 2. Fireworks 3. True 4. 4th of July 5. Request for Meter Reading April 2020 May 2020 June 2020 Top 5 Website Referrers 1. Facebook 2. newsbreakapp.com 3. weareyorkville.org 4. patch.com 5. r.search.aol.com 1. Facebook 2. r.search.aol.com 3. Patch.com 4. dnserrorassist.att.net 5. q985online.com 1. Facebook 2. mykidlist.com 3. Patch.com 4. r.search.aol.com 5. wspynews.com City Facebook Data: June 2020 Total Page Followers: 6,326 (an increase of 427 followers from May) Total Page Likes: 5,953 Total Average Reach: 2,777 Highest Viewed Post: “Late Friday afternoon, the State of Illinois released some guidance on swimming pools…” (Posted June 10, 2020, 2:00 pm) Highest Viewed Post Reach: 17,574; 3,173 Post Clicks; 377 Reactions, Comments & Shares Parks and Recreation Facebook Data: June 2020 Total Page Followers: 3,598 (an increase of 313 followers from May) Total Page Likes: 3,851 Total Average Reach: 2,327 Highest Viewed Post: “Paint your own masterpiece with Petite Palette of Sandwich!…” (Posted June 3, 2020, 8:54 am) Highest Viewed Post Reach: 5,109; 69 Post Clicks; 26 Reactions, Comments & Shares Police Facebook Data: June 2020 Total Page Followers: 4,176 (an increase 1,677 of followers from May) Total Page Likes: 2,381 Total Average Reach: 5,781 Highest Viewed Post: “The Yorkville Police Department is aware of a snapchat-distributed protest invitation for downtown Yorkville…” (Posted June 2, 2020, 2:48 pm) Highest Viewed Post Reach: 42,013; 8,659 Post Clicks; 1,535 Reactions, Comments & Shares City Twitter Data: June 2020 Total Followers: 1,659 (6 new followers from May) Total Tweet Impressions: 7,541 Total Profile Visits: 556 Yorkville Twitter Mentions: 12 Top Tweet (earned 1,262 Impressions): “Join the City of Yorkville as we host the Annual 4th of July Celebration on Saturday, July 4th…” Recommendation: This is an informational item. ihttps://www.yorkville.il.us/; https://www.yorkville.il.us/facilities/featureoverview; https://www.yorkville.il.us/159/White-Goods; https://www.yorkville.il.us/567/Fourth-of-July-Celebration; https://www.yorkville.il.us/131/Online-Utility-Payments; ii https://www.yorkville.il.us/DocumentCenter/View/5804/Residential-Permit-Application-PDF; https://www.yorkville.il.us/DocumentCenter/View/6652/Pool-2018?bidId=; https://www.yorkville.il.us/DocumentCenter/View/124/Parks-Map-and-Matrix-PDF?bidId=; https://www.yorkville.il.us/DocumentCenter/View/6094/2019-Annual-Drinking-Water-Quality-Report- PDF?bidId=; https://www.yorkville.il.us/DocumentCenter/View/6655/Concrete-Patio-and-Brick-Pavers-2018?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 2020-49 4th Quarter Budget Review – Fiscal Year 2020 Administration Committee – July 15, 2020 Informational Rob Fredrickson Finance Name Department UNITED CITY OF YORKVILLE QUARTERLY BUDGET REVIEW 4th Quarter Ended April 30, 2020 2020 QUARTERLY BUDGET REVIEW FISCAL YEAR 2020 United City of Yorkville – 4th quarter ended April 30, 2020 1 General Fund Revenues (cash basis after 12 periods) Revenue Source FY 2020 Actual YTD FY 2020 Budget % of Budget FY 2019 Actual YTD % Change 1 Property Taxes $ 3,231,926 $ 3,225,250 100% $ 3,149,635 3% 2 Municipal Sales Tax 3,198,731 3,151,800 101% 3,067,752 4% 3 Non-Home Rule Sales Tax 2,421,227 2,432,700 100% 2,355,866 3% 4 Utility Taxes 980,684 960,000 102% 1,004,920 -2% 5 Excise Tax 285,898 321,965 89% 336,355 -15% 6 Cable Franchise Fees 303,536 290,000 105% 295,361 3% 7 Hotel Tax 77,715 80,000 97% 79,168 -2% 8 Video Gaming Tax 139,088 140,000 99% 143,627 -3% 9 Amusement Tax 201,362 205,000 98% 207,885 -3% 10 Admissions Tax 146,143 140,000 104% 148,133 -1% 11 Business District Tax 398,635 427,500 93% 414,649 -4% 12 Auto Rental Tax 18,087 14,500 125% 15,900 14% 13 Income Tax 2,061,687 1,916,366 108% 1,846,826 12% 14 Local Use Tax 656,367 602,966 109% 562,425 17% 15 Road & Bridge 131,199 130,000 101% 128,668 2% 16 Other Intergovernmental 51,364 53,900 95% 54,083 -5% 17 Licenses & Permits 498,322 413,500 121% 553,923 -10% 18 Fines & Forfeits 75,766 125,400 60% 101,733 -26% 19 Charges for Service 1,659,332 1,616,211 103% 1,586,233 5% 20 Investment Earnings 147,835 80,000 185% 90,321 64% 21 Reimbursements/Miscellaneous 107,767 95,000 113% 57,885 86% 22 Transfers In - 47,180 0% - 0% 23 Total Revenues $16,792,671 $ 16,469,238 102% $ 16,201,348 4% (1) Property Taxes consist of the Corporate and Police Pension tax levies which account for approximately 20% of total General Fund revenues. In Fiscal Year (FY) 2020 the City collected 99.7% of what was extended by the County, which is in- line with historical collection patterns. Per the pension funding policy, the City fully funded its actuarial determined contribution (ADC) amount of $1,111,484 from property taxes ($1,108,182) and from other General Fund revenues ($3,302). (2 & 3) Municipal & Non-Home Rule (NHR) Sales Taxes account for the majority (~ 35%) of aggregate General Fund revenues. Municipal sales tax consists of the 1% local share from the total 8.25% general merchandise tax rate and all of the sales tax associated with qualifying food, drug and medical appliances. In addition to the 1% local share for municipal sales tax, the City also passed (via referendum) a 1% non-home rule sales tax rate applicable only to general merchandise. After accounting for audit accruals, staff is currently projecting sales tax to finish around $3.22 million for the Fiscal Year Ended (FYE) 2020, which includes $4,830 in deferrals. This new high-water mark for sales tax represents about a 5% growth over FY 2019 and exceeds the current year budget amount by ~$70,000. After modest growth of 3% in March (represents December 2019 Holiday sales), year-over-year monthly sales tax proceeds grew 12% in April (January 2020 consumer sales) and 10% in May (February consumer sales), ostensibly due to increased demand for food and other household goods resulting from the COVID-19 pandemic. June sales tax proceeds, which represented March consumer sales, were initially expected to decline by a third, based on information received from the Governor’s Office of Management & Budget (GOMB) in May. Fortunately, QUARTERLY BUDGET REVIEW FISCAL YEAR 2020 United City of Yorkville – 4th quarter ended April 30, 2020 2 General Fund Revenues – continued this sharp decline in sales tax proceeds did not come to fruition, as June 2020 proceeds were virtually identical to the prior year amount of ~$255,000. Monthly allotments for non-home rule (NHR) sales tax tended to follow a similar pattern to municipal sales over the course of FY 2020, although they did diverge a bit towards the end of the fiscal year. Monthly NHR sales tax amounts decreased by 1.5% in May (February consumer sales) and 5.3% in June (March consumer sales), presumably since most food related purchases are exempt from NHR sales tax. NHR sales are currently projected to finish FY 2020 at $2.41 million (gross amount taking audit accruals into consideration). This would be a year-over-year increase of 2.3% but would fall short of the FY 2020 budgeted amount of $2.43 million. Throughout FY 2020 the State continued to implement its 1.5% administrative fee (which is accounted for in the Administrative Services cost center in the General Fund) on all NHR sales tax proceeds. This administrative fee equates to about $36,000 in the current fiscal year (net NHR sales tax proceeds equal ~$2.37 million). As illustrated by the graph below, municipal sales tax tends to reflect the movement of the aggregate economy over the last ten audited fiscal years. After reaching its lowest point ($2.45M) during the height of the recession in FY 2010, sales tax increased by approximately 5% in FY 2011 ($2.57M), before declining again in FY 2012 ($2.55M) and FY 2013 ($2.49M). After increasing by 4% in FY 2014, sales tax eclipsed its pre-recessionary high of $2.68M (FY 2007) in FY 2015, as revenues exceeded $2.7M for the first time in the City’s history. Since FY 2014, sales tax amounts have continued to escalate, increasing an average of 3.8% per annum. (4) Utility Taxes consist of the City’s share of electric (ComEd) and natural gas (Nicor) taxes, which are heavily influenced by weather patterns over the summer and winter months. Due to the relatively mild winter temperatures experienced last winter, natural gas tax receipts are expected to finish at approximately $270,000; a decrease of 2% in comparison to the year prior. Electric utility tax receipts are projected to decline by 4%, totaling just over $700,000 at FYE 2020. Nonetheless, when taken in aggregate, utility taxes should exceed budgeted amounts by a little over $10,000. (5) Excise (formerly Telecommunications) Taxes are comprised of the State’s excise tax and the telephone utility tax received from AT&T. In recent years, this revenue stream has declined precipitously in municipalities across the State, as - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 FYE 2010 FYE 2011 FYE 2012 FYE 2013 FYE 2014 FYE 2015 FYE 2016 FYE 2017 FYE 2018 FYE 2019 FYE 2020 Municipal Sales Tax QUARTERLY BUDGET REVIEW FISCAL YEAR 2020 United City of Yorkville – 4th quarter ended April 30, 2020 3 General Fund Revenues – continued landlines become less prevalent. After only nominally decreasing last year by 1.5%, excise taxes have dropped sharply in the current fiscal year by nearly 20%. Excise tax should finish FY 2020 around $263,000, which is ~$50,000 less than initially budgeted ($313,625). (6) Cable Franchise Fees are projected to total around $300,000, which is slight increase of 0.6% from the previous year. These fees are remitted from AT&T, Metronet and Comcast at a rate of 5% of gross revenues earned during the previous calendar quarter. (7) Hotel Tax is generated from the five hotel/motels within City limits: Super 8; Hampton Inn; All Seasons; Sunset Motel; and the new Holiday Inn Express, which opened in December. Not surprisingly, hotel tax proceeds have been hard hit by the pandemic and corresponding shelter in place order from the Governor, declining by over 60% between March ($3,348) and April ($1,239). Currently, hotel taxes are expected to total around $74,000 at the end of FY 2020, which is a ~5% decrease in comparison to FY 2019. This tax is rebated to the Aurora Area Convention & Visitors Bureau (AACVB) at a rate of 90% and is an expenditure of the Administrative Services cost center in the General Fund. (8) Video Gaming Tax has increased substantially since the City first began receiving this revenue stream in FY 2013, as there are currently fourteen locations across the City that offer video gaming terminals. The tax is applied to net terminal income (gross revenue less prizes paid) at a rate of 30%, of which the City receives one sixth (17%). Since its inception, video gaming tax receipts have increased more than five times over, going from $26,047 in FY 2014 to $145,734 at the end of FY 2019. This revenue stream has undoubtedly been impacted by the pandemic and is expected to decline by about 10% in the current fiscal year, to finish around ~$130,000. (9) Amusement Tax was created by ordinance in 2010 and is collected as a result of an admission to any facility providing an amusement at a rate of 3% of gross revenue. Prior to the COVID-19 pandemic, this revenue stream has remained resilient due to the sustained success of local businesses, including Raging Waves, and has been further enhanced in recent years by the opening of NCG Cinemas. Current projections for amusement tax are around $197,000, which is 6% less than the year prior. (11) Business District Taxes are generated from the additional general merchandise sales tax rates applied to the City’s three business district areas: Kendall Marketplace (0.5%); Countryside (1%); and Downtown (1%). The business district sales tax rate was implemented as a mechanism to finance public improvements in these areas, as amounts generated from this tax are rebated in full to either pay debt service (Kendall Marketplace) or reimburse developers for public improvements. Business district taxes within Kendall Marketplace appear to have trended in an opposite direction compared to municipal & non-home rule sales taxes over the course of the fiscal year; as they are currently estimated to decline by approximately 5% over the prior year, for a total of ~$345,000. Meanwhile, tax proceeds in the Countryside Business District have been particularly robust, as they are expected to exceed prior year amounts by 39%, to finish around $14,500. While analyzing sales tax streams within the City’s business districts provides certain insights, it should be noted that these revenue streams have no budgetary impact. As mentioned above, these taxes are rebated in full, less a 2% administrative fee deducted by the State of Illinois. (13) Income Tax is the City’s largest intergovernmental (i.e. disbursed on a per capita basis) revenue source, accounting for approximately 12% of all General Fund revenues. Prior to January 2011, 10% of total income tax collections were dedicated to the Local Government Distributive Fund (LGDF), which is distributed to municipalities and counties on a per capita basis. In January 2011, the LGDF percentage was decreased to 6% (with the enactment of the temporary income tax increase); and then increased to 8% in January 2015 after the temporary income tax increase expired. After the income tax was permanently increased in July 2017, the local government share was reduced to 5.45% and 6.16% of individual and corporate income tax collections, respectively. Currently local governments receive 5.757% of individual and 6.50% of corporate income tax QUARTERLY BUDGET REVIEW FISCAL YEAR 2020 United City of Yorkville – 4th quarter ended April 30, 2020 4 General Fund Revenues – continued proceeds. Income tax was initially budgeted at $1.916 million for FY 2020, based on the Illinois Municipal League (IML) December 2018 per capita estimate of $100.75. Income tax had been tracking strong over the first ten months of FY 2020 and was up by about 6% on average in comparison to the prior year. Subsequent IML projections reflected this as well, projecting $106.30 per capita ($2.02 million) in October 2019, before increasing further in December to $107.25 per capita ($2.04 million). Unfortunately, the onset of the pandemic and ensuing shelter in place order in the last quarter of the fiscal year negated this initial exuberance. In May of 2020 (March income tax allotment), income tax proceeds declined by 22% in comparison to historical norms for that month. Nonetheless, in spite of the fact that the state income tax filing deadline had been pushed to July 15th, the fiscal year did end on a positive note, as April income tax proceeds (received in June) were essentially flat in comparison to April of the prior year ($118,79 in FY 2020 v. $119,293 in FY 2019). Actual income tax receipts are expected to fall short of budgeted amounts by ~$45,000, to finish around $1.87 million ($98 per capita). (14) Local Use Tax is a form of sales tax that is imposed on the privilege of using, in Illinois, any tangible personal property purchased out-of-state. If the seller does not collect at least 6.25% on general merchandise or 1% on qualifying food, drug and medical appliance sales, the purchaser is responsible for the difference. Local use tax has been particularly robust in recent years, increasing an average of 14% per annum from FY 2014 through FY 2019, due to the 2018 South Dakota v. Wayfair Supreme Court decision and the continued growth of online purchases. Due to the increased proclivity towards on-line sales, Fiscal Year 2020 is shaping up to be another strong year for this revenue stream, as management expects local use tax to increase by approximately 15%, ending FY 2020 at ~$665,000 ($35 per capita). (16) Other Intergovernmental Revenue consists of federal monies for overtime reimbursement in conjunction with the City’s participation in Chicago’s High Intensity Drug Trafficking Area (HIDTA) program; personal property replacement tax proceeds; vest grant proceeds from the United States Department of Justice; State grant proceeds for traffic signal maintenance; a police academy training reimbursement from the State; and the annual allotment of pull tabs & jar games from the IDOR. This category also includes proceeds from the cannabis excise tax, which went into effect on January 1st, and is remitted to municipalities on a per capita basis. In its initial year of distribution, cannabis excise tax proceeds are estimated at ~$4,000; and must be used to fund crime prevention programs, training and drug interdiction efforts. (17) License & Permit revenue is comprised of liquor licenses, building and other permits. Throughout FY 2020, building permit revenues have dramatically exceeded initial expectations (budgeted amount was $350,000) and are projected to reach an excess of $425,000. Per the City’s past practice, most of this amount will be recognized in the General Fund to cover Building Department personnel and operating costs, with the remaining proceeds recognized in the City-Wide Capital Fund to finance current and future capital improvements. At the culmination of Fiscal Year 2020 – 2,247 permits had been issued and are comprised as follows: 113 commercial; 141 single-family detached homes; 34 single-family attached homes; and 1,959 miscellaneous residential and commercial permits. The total number of permits issued in FY 2020 more than doubled in comparison to the previous fiscal year’s amount of 980. New housing starts remained stable in FY 2020, with a total of 175; but were down in comparison to last year’s total of 222. (18) Fines & Forfeits consist of circuit court, adjudication, offender registration and police tow fines. Due to the nature in which fines and forfeits are generated, this revenue stream was immediately impacted by the COVID-19 pandemic. Kendall County Circuit Court fines are expected to be under budget by at least $10,000 and decline ~8% in comparison to FY 2019. Administrative adjudication fines are tracking around $23,000, which is about 12% less than the prior year. Tow revenues are tracking at about half last year’s amount (~$15,000) due to City code amendments and the pandemic. Tow revenues are anticipated to return to more of a historical range (~$30,000 - $50,000+) in the upcoming fiscal year, as the economy begins to reopen. QUARTERLY BUDGET REVIEW FISCAL YEAR 2020 United City of Yorkville – 4th quarter ended April 30, 2020 5 General Fund Revenues – continued (19) Charges for Services primarily consist of the refuse charges included on residents’ utility bills and the administrative fees paid to the City from the YBSD and Fox Metro for administering their billing and collection processes. Total garbage surcharge revenues (including late fees) are projected at $1.27 million for FY 2020, which would yield a nominal surplus of about $12,000 when netted against the costs of providing this service (paid out of the PW - Health & Sanitation cost center in the General Fund). Overall refuse surcharge revenue is estimated to increase approximately 5% over last year, due to new residential development and increases to the contractual refuse rate from $16.91 to $17.34 (2.5%) per month for 65- & 95- gallon totes. Expenditures for the refuse subsidy, which reduces senior citizens’ monthly refuse charges by $3.47 ($8.67 for those seniors qualifying for circuit breaker), is estimated to finish around $34,000, and has a little over 500 participants at fiscal year end. The City also offers 33-gallon totes at the reduced rate of $16.76 per month ($13.41 for seniors and $8.38 for seniors qualifying for circuit breaker), in which about 115 residents participate. (20) Investment Earnings is comprised of interest income earned from FDIC insured certificates of deposit (i.e. CD’s), IMET recovery proceeds and having cash on account with First National Bank, Illinois Funds, Associated Bank and Illinois Trust. Interest earnings, generated from CD’s and the other account listed above, are estimated to increase by almost 20% over prior year amounts, due to favorable interest rates for the majority of the fiscal year and more cash being available for investment within the General Fund, as a direct result of increased fund balance. Regarding the ongoing IMET recovery, in November of 2019 the Overall Receiver (i.e. the law firm appointed by the Court who has custody of the assets recovered on behalf of investors stemming from the 2014 First Farmer’s Financial Repo Fraud) disbursed the bulk of its assets ($72.9 million) to the various claimants, including the Illinois Metropolitan Investment Fund (IMET), who’s share was ~$21 million. In turn, the following month IMET disbursed the City’s share of recovered proceeds totaling $133,486; of which $39,952 was directly attributable to the General Fund. The total amount recovered to date is $177,925 (56%), with $53,252 being allocated to the General Fund. Before winding down, the Overall Receiver will make one final distribution of receivership funds to participants over the Summer. As of April 30, 2020, the Overall Receiver had roughly $2.3 million in cash, which will ultimately result in recovery proceeds for the City of approximately of $4,100. (21 & 22) Reimbursements/Miscellaneous Income & Transfers In is comprised of various reimbursements for engineering, legal, liability insurance, etc., as well as rental and other miscellaneous income. Aggregate miscellaneous reimbursements are expected to finish the year around $75,000 and are primarily comprised of quarterly rebates from the cable consortium ($11,647), IPRF safety grant funds ($7,237) and insurance reimbursements ($19,494). The bulk of miscellaneous income (currently projected at ~$18,000 for FY 2020) will consist of credit card rebate proceeds, of which $16,550 will be accrued to the current fiscal year. The Transfer In amount (estimated at ~$31,000 for FY 2020) is composed of building development fees, which are transferred out of the City-Wide Capital Fund in order to reimburse the General Fund for the transfer it made in FY 2014 to close out the (16) Municipal Building Fund in the amount of $571,615. At the end of FY 2020, $143,452 has been reimbursed to the General Fund, leaving a balance of $392,863. (23) Total General Fund Revenues & Transfers are projected (after considering audit accruals) to exceed budgetary amounts in excess of $150,000 (~1%); due predominantly to better than expected building permits, intergovernmental revenues, charges for services revenue and investment earnings. QUARTERLY BUDGET REVIEW FISCAL YEAR 2020 United City of Yorkville – 4th quarter ended April 30, 2020 6 General Fund Expenditures (cash basis after 12 periods) FY 2020 Actual YTD FY 2020 Budget % of Budget FY 2019 Actual YTD % Change Total YTD Expenditures $ 15,166,425 $ 16,783,649 90% $ 15,187,386 0% Expenditures by Category 50 Salaries 5,012,703 5,206,755 96% 4,707,608 6% 52 Benefits 3,072,109 3,273,617 94% 2,887,067 6% 54 Contractual Services 4,190,503 5,527,879 80% 4,310,752 -3% 56 Supplies 311,324 464,998 67% 238,731 30% 99 Transfers Out 2,579,785 2,580,400 100% 3,043,228 -15% Expenditures by Department 110 Administration 921,212 964,684 95% 922,490 0% 120 Finance 494,319 533,741 93% 474,577 4% 210 Police 5,583,173 5,935,224 94% 5,258,136 6% 220 Community Development 799,810 933,186 86% 814,863 -2% 410 PW - Streets & Sanitation 1,971,435 2,320,194 85% 1,857,186 6% 640 Administrative Services 5,396,474 6,096,620 89% 5,860,134 -8% (50) Salaries – After twelve periods of activity, overall salary line items finished at 96% of budget, as most functional departments within the General Fund came in under their respective appropriations. Once audit accruals have been applied, aggregate Police Department salaries will finish ~$60,000 over budget, due to a retirement payout. Administration Services will be over as well, by about $5,100, due to overtime generated from special details in the Police Department (this is offset in full on the revenue side). Total General Fund salary expenditures should finish FY 2020 at ~$5.21 million, which is only nominally over budget by about $3,000. At the end of April 2020, salaries accounted for approximately 33% of total General Fund expenditures. (52) Benefits – Aggregate expenditures for benefits (which include individual departmental line items for group life, health, dental and vision – as well as unemployment and liability expenditures in the Administrative Services cost center) are expected to finish under budget (~94%) across all departments in FY 2020. The overage on budgeted salaries for Police, will be more than offset by the budgeted savings in benefit related expenditures. The Police Department should finish approximately $135,000 under budget in the benefit expenditure category, due to the aforementioned retirement, several current employees choosing to opt-out of the City’s health insurance program and lower than expected utilization rates regarding the City’s Health Reimbursement Account (HRA). To date, benefits account for 20% of total General Fund expenditures. (54) Contractual Services – At first glance it appears that the General Fund is considerably below budgeted amounts for this cost category, tracking at only 80% at the end of April; however, there are two material expenditures that still need to be accounted for as part of the audit accrual process. The first of these costs is for refuse service for the months of March and April, which totaled approximately $220,000. The other significant expenditure will be the sales tax rebate amount covering the last four months of the fiscal year (January thru April). These amounts, which were paid out in June, increased total sales tax rebates for FY 2020 to ~$872,000, which is $31,000 under budget. Once these, and other audit related expenditures are recorded, total General Fund contractual services are projected to finish around $4.84 million (~92% of budget), resulting in significant budgetary savings of approximately $430,000. Much of these projected budgetary savings are derived from QUARTERLY BUDGET REVIEW FISCAL YEAR 2020 United City of Yorkville – 4th quarter ended April 30, 2020 7 General Fund Expenditures – continued outsourced inspection fees, which is expected to be under budget by ~$86,000, in Community Development; and several line items within the Administrative Services cost center including: information technology (under budget by ~$32,000), legal services (under budget by ~$57,000) and engineering services (under budget by ~$92,000). Contractual services accounted for 28% of total appropriations in the General Fund at the end of April 2020. (56) Supplies & (99) Transfers Out – It appears that most operational departments will finish well below budgeted amounts in the supply expenditure category once all audit related accruals have been accounted for in the current fiscal year. The most recent projections for the General Fund supply expenditure category are at approximately $343,000, which is ~$110,000 under budgeted amounts. The Public Works – Street Department will account for the vast majority of the budgetary savings (~$95,000), due to the MFT Fund budget being amended during the course of FY 2020 to help offset an unexpected increase in bulk rock salt prices. The General Fund makes several monthly (99) Transfers Out (i.e. other financing uses) to various City Funds for the following reasons: (42) Debt Service Fund – to pay the 2014B annual debt service amounts, which mature in FY 2023; (52) Sewer Fund – transfer a portion of non-home rule sales tax proceeds to pay debt service amounts on the 2011 refunding bonds; (79) Parks & Recreation Fund – annual transfer to subsidize that Fund’s operations; and (23) City-Wide Capital – to fund the demolition and subsequent reconstruction of a materials storage shed. The transfer to the (82) Library Operations Fund is for reimbursement of liability and unemployment insurance, which is reimbursed to the Library as those expenditures are incurred. At the end of April 2020, supplies and transfers out accounted for 2% and 17%, respectively, of total General Fund expenditures. General Fund – Fund Balance Management is currently estimating the General Fund (once all revenue and expenditure accruals have been accounted for) to finish the year with a surplus of approximately $630,000, which is ~$950,000 better than the original budget deficit amount of $314,000. This estimated surplus would result in an ending fund balance in excess of $7.5 million, which equates to a fund balance percentage of ~47% (fund balance divided by total expenditures & transfers out); which is equivalent to a five to six- month reserve. Total revenues and transfers in are estimated to finish around $16.61 million, which is ~$150,000 better than originally budgeted; whereas total expenditures are currently projected to finish under budget by ~$800,000, totaling $15.98 million. All departments within the General Fund are expected to finish below budgeted amounts. Cash and investments in the General Fund as of April 30, 2020 totaled $6.74 million and $495,769, respectively. QUARTERLY BUDGET REVIEW FISCAL YEAR 2020 United City of Yorkville – 4th quarter ended April 30, 2020 8 General Fund – Fund Balance - continued As illustrated above, fund balance in the General Fund declined percipitously in FY 2008 and FY 2009, as building activity in the City began to slow significantly due to the recession. Fund balance reached its lowest point in FY 2010 due to a one-time bad debt write off of approximately $1 million, before rebounding in Fiscal Years 2011 thru 2013; due to staff and other budgetary reductions, as well as the implementation of non-home rule sales tax. Fund balance declined by $363,000 in FY 2014, due to interfund transfers closing out the (16) Municipal Building & (80) Recreation Center Funds. Fund balance continued to increase over the next two fiscal years, returning to its pre-recessionary high of over $5.5 million at the conclusion of FY 2016. Since FY 2016, fund balance has continued to rise by an average of 6.5% per annum, reaching $6.88 million at the end of FY 2019. As mentioned on the previous page, current projections for the General Fund show a budget surplus of ~$630,000, which would yield a resulting fund balance of $7.51 million. Nevertheless, it should be noted that when netted against the three TIF Funds (which are currently estimated to finish FY 2020 with a combined negative fund balance of $2.44 million), net fund balance for the General Fund is reduced to ~$5.07 million, which equates to a 32% fund balance percentage (roughly 4 months of reserve). (500,000) 500,000 1,500,000 2,500,000 3,500,000 4,500,000 5,500,000 6,500,000 7,500,000 8,500,000 FYE 2006 FYE 2007 FYE 2008 FYE 2009 FYE 2010 FYE 2011 FYE 2012 FYE 2013 FYE 2014 FYE 2015 FYE 2016 FYE 2017 FYE 2018 FYE 2019 FYE 2020 Fund Balance History -General Fund QUARTERLY BUDGET REVIEW FISCAL YEAR 2020 United City of Yorkville – 4th quarter ended April 30, 2020 9 Water Fund Revenues (cash basis after 12 periods) Revenue Source FY 2020 Actual YTD FY 2020 Budget % of Budget FYE 2019 Actual YTD % Change 24 Charges for Service $ 4,415,135 $ 4,401,300 100% $ 4,515,184 -2% 25 BUILD Program - - 0% 27,465 -100% 26 Investment Earnings 27,874 23,851 117% 19,100 46% 27 Reimb/Misc/Transfers 283,292 274,780 103% 219,029 29% 28 Total Revenues $ 4,726,301 $ 4,699,931 101% $ 4,780,778 -1% (24) Charges for Service primarily consist of water sales, infrastructure and connection fees, which currently account for 94% of total Water Fund revenues. The overall volume of water billed in FY 2020 is down about 5% in comparison to the previous fiscal year, most notably in the summer months of June through September. As a result, water sales are projected to finish the year a little over $3.04 million (after accounting for audit accruals), which is $190,000 below the budgeted amount of $3.23 million. On a positive note, water infrastructure, meter and connection fees are currently estimated to exceed budgetary amounts by a total of approximately $194,000; as building activity in Yorkville remained stable throughout the current fiscal year. (26) Investment Earnings consist of interest income earned from having cash on account with Associated and First National Banks, and IMET recovery proceeds which totaled $6,693 in the current fiscal year. Bank generated interest earnings are targeted to finish around $21,000, which is in-line with budgeted amounts. (27) Reimb/Misc/Transfers are made up of reimbursements, rental income, and interfund transfers. Rental income was enhanced in the current fiscal year as a result of the City entering into a second cell tower lease agreement with Verizon in late FY 2019. The new cell tower, located at 610 Tower Lane, generated an additional $34,800, which will result in annual rental income exceeding $100,000 for the first time in FY 2020 (after accounting for audit accruals). The “transfers in” from the Sewer and City-Wide Capital Funds will total around $180,000 and pay for a portion of the annual debt service on the 2014B (which refunded the 2005C bonds) and 2015A (used to finance water improvements in Countryside subdivision) bonds, respectively. Water Fund Expenses (cash basis after 12 periods) FY 2020 Actual YTD FY 2020 Budget % of Budget FY 2019 Actual YTD % Change Total YTD Expenditures $ 4,824,877 $ 5,779,725 83% $ 3,753,546 29% Expenses by Category 50 Salaries 397,074 519,935 76% 393,134 1% 52 Benefits 193,548 263,064 74% 202,029 -4% 54 Contractual Services 785,750 813,799 97% 738,644 6% 56 Supplies 364,057 393,281 93% 317,866 15% 60 Capital Outlay 722,950 1,428,146 51% 569,029 27% 77-94 Debt Service 2,361,500 2,361,500 100% 1,532,844 54% As shown above, the (50) Salary and (52) Benefit cost categories are expected to finish below budgeted amounts in the current fiscal year, due to water department vacancies (that were later filled) and the decision not to hire a water & sewer QUARTERLY BUDGET REVIEW FISCAL YEAR 2020 United City of Yorkville – 4th quarter ended April 30, 2020 10 Water Fund Expenses - continued superintendent, as originally conceived in the FY 2020 budget. After audit accruals have been applied, salary and benefit amounts are estimated to be approximately $180,000 below budgeted amounts. (54) Contractual Services are projected to exceed budgeted amounts by approximately $40,000; as a temporary consultant (paid out of professional services) was needed to fulfil the operational duties of a certified water operator for a portion of the fiscal year, and due to unanticipated costs relating to the maintenance of the City’s various water treatment plants. Total (60) Capital Outlay expenses are expected to finish significantly below budget (~60%), as the Well #7 rehabilitation and standby generator projects (the Well #7 standby generator has since been moved to Beaver Street) were deferred to the subsequent fiscal year. In addition, IDOT’s Route 71 and US Route 34 west watermain replacement projects are expected to come in under budget as well, due to timing issues with the State. Capital projects that were substantially completed as of April 30th includes replacement of the East Orange Street watermain and design engineering work related to the Elizabeth Street watermain. Presently, the Water Fund pays (77-94) Debt Service on four issuances: the 2015A Bond (matures FY 2035); the 2016 Refunding Bond (matures FY 2023); the 2014C Refunding Bond (matures FY 2025); and an IEPA Loan (matures FY 2027). Water Fund – Fund Balance Equivalent Once all audit accruals have been booked, the Water Fund is projected to finish the year with a deficit of ~$290,000, which is approximatley $790,000 better than originally budgeted. Currently the Fiscal Year 2020 ending fund balance equivalent is predicted to be around $3.24 million, which is roughly 64% of total expenses & transfers out. Equivalency percentages in the Water Fund are expected to return to more normal levels (30%-40%) in the upcoming fiscal year, as the capital projects mentioned above progress towards completion. Cash balances in the Water Fund as of April 30, 2020 totaled $2.505 million. Sewer Fund Revenues (cash basis after 12 periods) Revenue Source FY 2020 Actual YTD FY 2020 Budget % of Budget FY 2019 Actual YTD % Change 29 Charges for Service $ 1,601,721 $ 1,567,500 102% $ 1,530,862 5% 30 BUILD Program - - 0% 18,000 -100% 31 Investment Earnings 38,751 7,149 542% 9,679 300% 32 Reimb/Misc/Transfers 579,410 575,030 101% 858,048 -32% 33 Total Revenues $ 2,219,882 $ 2,149,679 103% $ 2,416,589 -8% (29) Charges for Services account for 73% of total Fund revenues, consisting primarily of sewer maintenance and infrastructure fees. At the end of FY 2020, both maintenance and infrastructure fees are expected to exceed budgeted amounts, for a combined surplus of ~$37,000. Aggregate sewer connection fees are projected to finish slightly below budgeted amounts by ~$4,600 but will exceed prior year amounts by over $25,000. QUARTERLY BUDGET REVIEW FISCAL YEAR 2020 United City of Yorkville – 4th quarter ended April 30, 2020 11 Sewer Fund Revenues - continued (31) Investment Earnings consist of interest income earned from having cash on account with Associated and First National Banks, and IMET recovery proceeds which totaled $31,459 in the current fiscal year. Bank generated interest earnings are targeted to finish around $15,000, which is in-line with budget targets. (32) Reimbursements/Miscellaneous/Transfers In primarily consists of an interfund transfer from the General Fund comprised on non-home rule sales tax proceeds, for the purposes of paying a portion of the debt service on the 2011 Refunding Bonds. Sewer Fund Expenses (cash basis after 12 periods) FY 2020 Actual YTD FY 2020 Budget % of Budget FY 2019 Actual YTD % Change Total YTD Expenditures $ 2,046,986 $ 2,546,355 80% $ 2,702,138 -24% Expenses by Category 50 Salaries 197,946 270,946 73% 196,299 1% 52 Benefits 118,820 164,060 72% 96,424 23% 54 Contractual Services 126,001 240,935 52% 137,240 -8% 56 Supplies 45,754 62,650 73% 55,618 -18% 60 Capital Outlay 132,283 350,861 38% 222,679 -41% 75 Developer Commitments - 30,721 0% 35,938 0% 84-96 Debt Service 1,352,307 1,352,307 100% 1,880,265 0% 99 Transfer Out 73,875 73,875 100% 77,675 -5% Similar to the Water Fund, the (50) Salaries and (52) Benefits cost categories in the Sewer Fund are expected to finish below budgeted amounts in the current fiscal year by approximately $110,000, due to partial year vacancies and the decision not to hire a water & sewer superintendent. (54) Contractual Services should finish ~ $100,000 under budget, as the Countryside and Blackberry lift station projects were deferred to the subsequent fiscal year. After accounting for audit accruals, (60) Capital Outlay for the Sewer Fund is expected to finish considerably below budget (~47%), as most construction costs related to IDOT’s Route 71 Sanitary Sewer Replacement Project were deferred into the ensuing fiscal year. The Sewer Fund’s 2019 Road to Better Roads Program focused on sanitary improvements on Church Street, which were substantially complete at the end of the fiscal year. The (75) Developer Commitment cost center represents the annual payment to Lennar Chicago, pursuant to the reimbursement agreement entered into in December 2002. This agreement expired in the current fiscal year, and a final payment of $30,948 was paid out in May (will be accrued back to FY 2020). Currently, the Sewer Fund pays (84-96) Debt Service on two issuances: the 2003 IRBB Debt Certificates (matures FY 2023); and the 2011 Refunding Bond (matures FY 2026). The IEPA Loan matured in the current fiscal year – final debt service amounts totaled $53,525. The (99) Transfer Out represents one half of the annual debt service payment on the 2014C (refunded 2005C) bonds in the Water Fund, as a portion of that bond’s initial proceeds were used for sewer infrastructure improvements. QUARTERLY BUDGET REVIEW FISCAL YEAR 2020 United City of Yorkville – 4th quarter ended April 30, 2020 12 Sewer Fund – Fund Balance Equivalent The Sewer Fund is expected to finish the year with a surplus of ~ $62,000, due to projected expenses coming in better than initially budgeted. Once all audit accruals have been booked, the Sewer Fund will expected to exceed its original budget deficit of $396,676 by approximately $460,000. Fund Balance Equivalancey for the Sewer Fund is currently estimated to be ~$1.17 million at the end of FY 2020, which equates to around 54% of total expenses (including tranfers out). Cash amounts in the Sewer Fund as of April 30, 2020 totaled $1.04 million. Parks & Recreation Fund Revenues (cash basis after 12 periods) Revenue Source FY 2020 Actual YTD FY 2020 Budget % of Budget FY 2019 Actual YTD % Change 34 Charges for Service 608,408 632,000 96% 582,920 4% 35 Investment Earnings 1,333 1,500 89% 1,534 -13% 36 Reimb/Misc/Transfers 1,646,548 1,611,488 102% 1,503,839 9% 37 Total Revenues $ 2,256,289 $ 2,244,988 101% $ 2,088,293 8% To date, the Parks & Recreation Fund has been most negatively impacted by the pandemic, due to the very social nature of most recreational revenue generating activities. Aggregate (34) Charges for Service are a bit skewed when looking at them from the cash basis as of April 30th, as they do not account for the various refunds issued for recreational activities in the new fiscal year due to COVID-19. To date, refunds and household credits issued in FY 2021, but attributable to FY 2020, total ~$80,000. Once these figures are adjusted as part of the audit accrual process, charges for service revenues (includes special events, athletics & fitness & child development) are currently projected to finish FY 2020 at approximately $100,000 under budget. Proceeds from Hometown Days, which is included in the (37) Reimb/Misc/Transfers revenue center, increased by 5% in comparison with the previous fiscal year (the festival essentially broke-even in the current fiscal year, generating ~$124,000 in both revenues and expenditures). Total revenues for the Parks & Recreation Fund are expected to come in around $2.1 million, which is ~$130,000 below budget. QUARTERLY BUDGET REVIEW FISCAL YEAR 2020 United City of Yorkville – 4th quarter ended April 30, 2020 13 Parks & Recreation Fund Expenditures (cash basis after 12 periods) FY 2020 Actual YTD FY 2020 Budget % of Budget FY 2019 Actual YTD % Change Total YTD Expenditures $ 2,168,696 $ 2,349,081 92% $ 2,035,620 7% Expenditures by Category 50 Salaries 1,217,194 1,287,858 95% 962,216 26% 52 Benefits 462,405 484,055 96% 392,316 18% 54 Contractual Services 187,310 187,538 100% 307,650 -39% 56 Supplies 153,307 190,630 80% 262,452 -42% 56 Hometown Days 148,481 199,000 75% 110,986 34% Expenditures by Department 790 Parks 1,070,083 1,151,262 93% 1,057,416 1% 795 Recreation 1,098,613 1,197,819 92% 978,204 12% As shown on the table above, all Parks & Recreation Fund cost categories are anticipated to remain under budgeted amounts, even after the application of audit accruals. Total expenditures for the Parks Department is currently estimated around $1.09 million, which is ~$60,000 under budget. Aggregate Recreation Department expenditures are projected at $1.13 million, which is ~$70,000 under budget. Assuming these projections hold, aggregate Fund expenditures would total $2.22 million, which is ~$130,000 under the budgeted amount of $2.35 million. Parks & Recreation Fund – Fund Balance Despite the decline in Recreation revenues brought on by the pandemic, the Fund is still anticipated to finish right around its budgeted deficit amount of $104,000. Ending fund balance for the year is projected to be ~$350,000, which is equal to about 16% of total expenditures. This will be the last fiscal year in which the Parks & Recreation Fund will maintain a sizeable fund balance. Starting in FY 2021, the General Fund operational transfer will be adjusted accordingly to ensure that the Parks & Recreation Fund budget maintains a break-even position (i.e. zero fund balance). Cash on hand in the Parks & Recreation Fund as of April 30, 2020 totaled $634,613. 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 2020-50 FY 2020 Budget Amendment – Downtown TIF II Administration Committee – July 15, 2020 N/A Majority Approval Please see attached memo. Rob Fredrickson Finance Name Department For Fiscal Year Ended 2020, all City Funds, less one, are expected to come in under budget for expenditures, including all major operating funds (General, Water, Sewer, Library, Parks & Recreation, etc.). The lone exception is the (89) Downtown TIF II Fund, which is anticipated to go over budget by ~$47,000, due to TIF Incentive Payouts (89-890-54-00-5425) totaling $80,000. These payouts were made pursuant to a redevelopment agreement (Exhibit 1 – approved by City Council on August 27, 2019) with KCJ Restoration, LLC regarding the Old Jail building located at 111 W. Madison Street. Additional adjustments have also been made to better reflect the actual activity of the Fund over the course of FY 2020 including: reducing the professional services (89-890- 54-00-5462) line item by $8,000; zeroing out the Facade Rehab Program line item (89-890-54- 00-5470); and increasing the property tax (89-000-40-00-4000) line item in the revenue budget by $24,171. As has been the City’s past practice, Funds that exceed their budgetary amounts due to explanatory circumstance have been amended, per the recommendation of the City’s auditors, to better reflect the changing plans of management/City Council and to avoid auditor comment. Although this may seem a bit “after the fact” to amend the 2020 budget after the fiscal year has ended, not doing so will result in the same audit comment that we received in the 2012 CAFR (included in the attached packet as Exhibit 2). Since this redevelopment agreement was not conceived until several months after the FY 2020 Budget was approved, it is the recommendation of staff that the Downtown TIF II Budget be amended as prescribed above. A budget worksheet has been attached for the (89) Downtown TIF II Fund, showing the Fiscal Year 2020 original and proposed budgetary changes (highlighted in yellow), in addition to a budget ordinance, for your review and consideration. Memorandum To: Administration Committee From: Rob Fredrickson, Finance Director Date: July 9, 2020 Subject: Fiscal Year 2020 Proposed Budget Amendment Ordinance No. 2020-____ Page 1 Ordinance No. 2020-____ AN ORDINANCE AUTHORIZING THE NINTH AMENDMENT TO THE ANNUAL BUDGET OF THE UNITED CITY OF YORKVILLE, FOR THE FISCAL YEAR COMMENCING ON MAY 1, 2019 AND ENDING ON APRIL 30, 2020 WHEREAS, the United City of Yorkville (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, pursuant to 65 ILCS 5/8-2-9.4, the City adopted Ordinance No. 2019-24 on April 9, 2019 adopting an annual budget for the fiscal year commencing on May 1, 2019 and ending on April 30, 2020; and, WHEREAS, pursuant to 65 ILCS 5/8-2-9.6, by a vote of two-thirds of the members of the corporate authorities then holding office, the annual budget of the United City of Yorkville may be revised by deleting, adding to, changing or creating sub-classes within object classes and object classes themselves. No revision of the budget shall be made increasing the budget in the event funds are not available to effectuate the purpose of the revision; and, WHEREAS, funds are available to effectuate the purpose of this revision. 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 the amounts shown in Schedule A, attached hereto and made a part hereof by reference, increasing and/or decreasing certain object classes and decreasing certain fund balances in the Downtown TIF II fund with respect to the United City of Yorkville’s 2019- 2020 Budget are hereby approved. Section 2: This ordinance shall be in full force and effect from and after its passage and approval according to law. Ordinance No. 2020-____ Page 2 Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this ______ day of ___________________, 2020. ______________________________ 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 ___________________, 2020. ______________________________ MAYOR FY 2020 FY 2020 FY 2017 FY 2018 FY 2019 Adopted Amended Actual Actual Actual Budget Budget Revenue Taxes - - - - 24,171 Investment Earnings - - - - - Total Revenue - - - - 24,171 Expenditures Contractual Services - - 2,736 35,000 82,000 Total Expenditures - - 2,736 35,000 82,000 Surplus (Deficit)- - (2,736)(35,000)(57,829) Ending Fund Balance 0 0 (2,736)(10,000)(60,565) The Downtown TIF II was created in 2018, in order to help promote downtown redevelopment and support the existing Downtown TIF. DOWNTOWN TIF II FUND (89) ($80) ($60) ($40) ($20) $0 Thousands1 890 FY 2020 FY 2020 FY 2017 FY 2018 FY 2019 Adopted Amended Account Actual Actual Actual Budget Budget 89-000-40-00-4000 PROPERTY TAXES - - - - 24,171 89-000-45-00-4500 INVESTMENT EARNINGS - - - - - $0 $0Total:Taxes DOWNTOWN TIF II FUND REVENUE Description Taxes $0 $0 $0 $0 $0 $24,171 $0 $24,171 United City of Yorkville Downtown TIF II Fund Total: DOWNTOWN TIF II REVENUE $0 $0 $0 Investment Earnings Total:Investment Earnings $0 $0 2 890 FY 2020 FY 2020 FY 2017 FY 2018 FY 2019 Adopted Amended Account Actual Actual Actual Budget Budget 89-890-54-00-5425 TIF INCENTIVE PAYOUT - - - - 80,000 89-890-54-00-5462 PROFESSIONAL SERVICES - - 2,736 10,000 2,000 89-890-54-00-5470 FACADE REHAB PROGRAM - - - 25,000 - $2,736$0 $82,000 $82,000 United City of Yorkville Downtown TIF II Fund DOWNTOWN TIF II FUND EXPENDITURES Description Total:Contractual Services Contractual Services $0 $2,736 Total: DOWNTOWN TIF II EXPENDITURES $0 $35,000 $35,000$0 3 UNITED CITY OF YORKVILLE, ILLINOIS Notes to the Financial Statements April 30, 2012 27 NOTE 2 – STEWARDSHIP, COMPLIANCE, AND ACCOUNTABILITY –Continued BUDGETARY INFORMATION –Continued The City follows these procedures in establishing the budgetary data reflected in the financial statements: Prior the May 1, the Mayor submits to the City Council the proposed budget for the fiscal year commencing the following May1. The operating budget includes proposed expenditures and the means of financing them. Public hearings are conducted at the City offices to obtain taxpayer comments. Prior to May 1, the budget is legally adopted by a vote of the City Council through passage of an ordinance. The budget officer is authorized to transfer budgeted amounts between departments within any fund; however, any revisions that alter the total expenditures of any fund must be approved by the City Council. EXCESS OF ACTUAL EXPENDITURES OVER BUDGET IN INDIVIDUAL FUNDS The following funds had an excess of actual expenditures over budget as of the date of this report: Fund Fox Hill Special Service Area $ 860 Land Cash 35,836 Countryside TIF 42 Municipal Building 750 Excess DEFICIT FUND EQUITY The following funds had deficit fund equity as of the date of this report: Fund Land Cash $ 294,778 Municipal Building 579,374 Recreation Center 220,001 Deficit 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 2020-51 Code Amendment Title 1 Chapter 7 Section 3 (Phase 2) Administration Committee – July 15, 2020 N/A Majority Approval See Attached Memo Carri Parker, Purchasing Manager Administration Name Department Summary Approval of an Ordinance to Amend the City Code, Title 1, Chapter 7, Subsection 3: Contracts and Purchases, to address changes to the code regarding the procurement process. Background This item was last discussed by the City Council on May 26, 2020, when the City Council authorized the approval for the addition of the surplus and cooperative purchasing sections, as well as the removal of the business registration section. During this meeting, Purchasing Manager Parker explained that she was reviewing the remaining code for accuracy against current state code and city internal procedures. Over the last several months, staff, working closely with the Village Attorney, has researched, drafted, and reviewed proposed changes to the code. The intent with the revised code is to maintain an open, fair, and transparent procurement process. Administrative processes will be outlined in a Procurement Policies and Procedures Manual that will be more comprehensive and will be updated regularly to meet changing processes and needs. The Procurement Policies and Procedures Manual is scheduled to be presented to the Administration Committee later this summer. The following summarizes changes recommended to the City Code:  Procurement deals with the sourcing activities, negotiation, and strategic selection of goods and services that are usually of importance to an organization. Purchasing is the process of how goods and services are ordered. Therefore, the code and section title has been changed to reflect procurement, not purchasing.  Removed repetitive language that can be found in the Illinois Municipal Code.  Updated titles to be uniform with the entire code.  Removed procedural language that can be found in the Procurement Policies and Procedures Manual. Memorandum To: Administrative Committee From: Carri Parker, Purchasing Manager CC: Bart Olson, City Administrator Date: July 15, 2020 Subject: City Code Amendment to Title 1, Chapter 7, Subsection 3: Contracts and Purchases 2 | Page Code Changes The previous code incorporated internal processes based on expenditures over $25,000. The proposed changes incorporate processes that potential vendors will need to be aware of before doing business with the city. The changes include purchasing threshold processes, defining and clarifying the bidding process, implementing an electronic process based on the recent COVID-19 pandemic event, adding language for bid cancellations, establishing bonding requirements, adding changes orders, ineligible vendor requirements, bid protests, and adding language to abide by state statue if it defers from city code. The additional changes in the code align with Oswego’s code for consistency in the Purchasing Manager position. The red-lined version is attached for your review. A summary of those changes are listed as follows: 3 | Page 1. PROPOSED CHANGE Current Language Removal: 1-7-3: Contracts and Purchases: A. Definitions: The expression "lowest responsible bidder", as used in this section and in the City's bidding documents, shall be deemed to mean the lowest bidder whose offer best represents in quality, fitness and capacity the requirements of the proposed work or usage. Proposed Language Addition:  Added this subsection to provide information of the purpose of the procurement function. 1-7-3 (A): Procurement Objectives: 1. It is the purpose of this subsection to establish competitive bidding and economical procurement practices, which shall apply to all purchases as herein described. 2. The City Administrator or his or her designee shall be the general purchasing agent of the city. Subject to the terms of this chapter, the City Administrator, or his or her designee shall oversee the purchasing process of all materials, supplies, services, and equipment necessary for the operation of the city. 3. Procurement procedures shall be consistent with any applicable federal, state, and local laws and any contractual obligations with other governmental agencies. 4. The purchasing requirements, as herein established, are to be construed as maximum requirements and do not restrict those authorized to make purchases for the city to go beyond these requirements. 5. The purchasing requirements will not necessarily govern every purchasing situation that may arise. In the event a specific purchase is not covered by these requirements, the purchase shall be made based on these objectives following consultation with the City Administrator or his or her designee. All purchasing agreements shall provide that payment will be made in compliance with the Local Government Prompt Payment Act (50 ILCS 505/1). 4 | Page 2. PROPOSED CHANGE Current Language Removal: 1-7-3 (B): Bids For All Contracts For Services Of Materials Over Twenty-Five Thousand Dollars to Purchasing Requirements: 1. Advertising For Bids: Except as otherwise provided herein, all contracts of whatever nature for labor, services or work, and for the purchase or lease of materials or supplies involving amounts in excess of twenty five thousand dollars ($25,000.00) made by or on behalf of the City shall be let to the lowest responsible bidder following notice as required in the following subsections: a. Notice shall be published in a newspaper of general circulation throughout the City at least once which publication shall be at least fifteen (15) days prior to the time designated for opening bids. The notice shall include a general description of the article or service desired, shall state the time, date and place of bid opening, and shall designate where bidding documents may be obtained. b. All purchases or contracts to be let shall be noticed by posting on the public bulletin board in the City Hall. Proposed Language Addition:  Changed the section title from Bids For All Contracts For Services Of Materials Over Twenty-Five Thousand Dollars to Purchasing Requirements, and these requirements are not just for Invitation to Bids, this also includes the addition of the processes for Request for Proposals, Request for Qualifications and Informal Purchasing (smaller purchases). 1-7-3 (B): Purchasing Requirements: 1. Competitive Bidding - (Invitation to Bid [ITB]) – The Invitation for Bid (ITB) method is used to initiate a competitive sealed bid procurement. The ITB applies to contracts for construction or repair work and purchase of apparatus, supplies, materials, or equipment of more than twenty-five thousand dollars ($25,000.00). ITBs should include detailed specifications, the scope of work, contract, and any other legal requirements. These bids are received sealed by a specific date and are opened and read out loud publicly in-person or electronically. The standard for awarding contracts is based on the lowest responsive and responsible bidder, or bidders, based on the bid amount listed. For an ITB, the pricing is the main criteria. a. An Invitation To Bid (ITB or bid) shall be issued for contracts under this subsection and shall include specifications and all contractual terms and conditions applicable. Any business submitting a bid or proposal is referenced as a bidder in this code. 5 | Page (1) Bids shall be obtained by publishing a public notice in a newspaper of general circulation, city website, electronic bidding portal, or applicable trade publications. (2) Bids shall be published for at least ten (10) days, excluding Sundays and legal holidays, in advance of the due date announced in the invitation for the public opening. (3) The City Administrator shall designate a means of distribution or determination of information to interested parties using reasonably available methods. Such methods may include publication in newspapers of general circulation, electronic or paper mailing lists, and web sites designated and maintained for such notification. Said notice shall state the place, date, and time of the bid opening. (4) All bids and proposals must be sealed and submitted set forth in the request prior to the date and time stated for the opening of responses. (5) All contracts are to be awarded pursuant to this subsection shall be approved by the city council. (6) No contract shall be assignable or sublet by the successful bidder without the written consent of the City Administrator or his or her designee. In no event shall a contract or any part thereof be assigned or sublet to a bidder who had been declared not to be a responsible bidder in consideration of bids submitted in response to an invitation for bids for the particular contract. 2. Competitive Proposals (Request for Qualification [RFQ]/Request for Proposal [RFP]) – The Request for Qualifications (RFQ) method can be used as a pre-qualification stage of the procurement process. Only those proponents who successfully respond to the RFQ and meet the qualification criteria listed within the RFQ will move on in the selection process that will include submitting a cost proposal. The Request for Proposal(RFP) is a process where the strategy, objectives, cost, and other details that will assist with the ability to choose the most qualified vendor are included. The RFP can be used without an RFQ as a bidding technique to obtain cost information, but the pricing is not the main criteria. This two-stage approach can both streamline the solicitation process and assist in gathering information about candidates for future use. a. Requests for Proposals shall be considered when determining the following through a Qualifications Based Selection (QBS) process: (1) Whether the contract needs to be other than a fixed-price type; (2) Whether oral or written discussions may need to be conducted with proposers concerning technical and price aspects of their proposals; (3) Whether the award may need to be based upon a comparative evaluation as stated in the Request for Proposals of differing price, quality, and contractual factors in order to determine the most advantageous offering to the city. Quality factors include technical and performance capability and the content of the technical proposal; and (4) Whether the primary consideration in determining award may not be price. 6 | Page b. Request for Proposals shall be prepared in accordance with the bid requirements listed in the above subsections 1-7-3(B)(1)(a)1 – 6, and shall also include: (1) A statement that discussions may be conducted with proposers who submit proposals determined to be reasonably susceptible of being selected for the contract award, but that proposals may be accepted without such discussions; (2) A statement of when and how price should be submitted; and (3) A listing of the criteria by which a proper shall be selected and recommended to the city council may also be included. 3. Informal Purchasing - (Agreements/Contracts/Quotes) – Another procurement method would be informal purchasing. Informal purchasing is when the threshold of the purchase does not meet the competitive bidding requirements. The city's informal bidding threshold is five thousand dollars ($5,000.00) to twenty-five thousand dollars ($25,000.00). This method would include soliciting quotes for goods and services and developing or reviewing service contracts or agreements. Any purchases under five thousand dollars ($5,000.00) can be purchased with a purchasing card with the Department Head's permission. It is assumed that staff is using their best judgment when making these purchases about quality and price. Purchases of goods or services in excess of $25,000.00 require a formal competitive bidding process. 7 | Page 3. PROPOSED CHANGE Proposed Language Addition  Added this section to allow the competitive bidding process to be held electronically. 1-7-3 (C): Electronic Bid Process: Electronic Transactions: The City may conduct procurement transactions, including competitive sealed bids, competitive sealed proposals, and informal quotations, by electronic means or in electronic form. The City Administrator shall adopt operational procedures regarding: 1. Appropriate security to prevent unauthorized access to the bidding, approval and award processes; a. Identification; b. Confidentiality; and c. Utilization of digital signatures, where applicable. 2. Electronic Posting: The City may electronically post solicitations, determinations, and other information related to procurement on a centralized internet web site designated by the city for this purpose. 3. Electronic Bid Openings: The city may hold public bid openings electronically with the opportunity for public access and input. 4. Electronic Records: In accordance with the Illinois Electronic Commerce Security Act, 5 Illinois Compiled Statutes 175/1-101 et seq., whenever this Article requires a record to be "written" or "in writing," an electronic record satisfies that requirement. 8 | Page 4. PROPOSED CHANGE Current Language Removal: 1-7-3 (B)(2): Bidding Procedures: 1. Bidder's Security: All bids must be sealed and, in the case of contracts for construction of Municipal buildings or facilities or for labor, shall be accompanied by security, either cash, cashier's check, certified check or surety bond, in a sum equal to ten percent (10%) of the total aggregate of the bid. The successful bidder shall forfeit his bid security upon such bidder's failure or refusal to execute the contract within the time designated in the bid documents. The City Council, in such event, may award the contract to the new lowest responsible bidder. 2. Other Bond Requirements: A faithful performance bond, labor and material bond and other bonds may be required by the City Council in amounts reasonably necessary to protect the City's interests in obtaining the services or work involved. If bonds are required, the form and amount thereof shall be designated in the notice inviting bids. 3. Bid Opening Procedures: All bids shall be submitted to the City Clerk, who shall safeguard them in a sealed condition until the time noticed for public bid opening. At the time and place stated in the public notices, the City Clerk or designee shall publicly open all bids. The tabulation of all bids or copies of bids received shall be available for public inspection in the Clerk's Office for a period of not less than thirteen (13) days after the bid opening. 4. Award Of Contracts i. Lowest Responsible Bidder: The City Council may make an award of contract to the lowest responsible bidder. If considered to be in the best interest of the City, selected portions of the lowest responsible bid may be accepted and award made accordingly. In the alternative, the City Council may either reject all bids and readvertise or authorize the City itself to perform the work and directly acquire the items desired in accordance with the immediately following provision. ii. Direct Method: After bids are rejected or if no bids are received, the City Council, by resolution and act of majority vote of the Council, including the Mayor, may authorize the work done by City personnel and equipment or may authorize the purchase of the material and equipment for services involved on the open market without complying with the requirements of this section, provided that the City Council reserves competent information or data that the City itself is capable of completing the project involved in a more satisfactory or economical manner or that the materials, equipment or services may be purchased more economically on the open market. 5. Tie Bids: If two (2) or more bids are received which are in all respects equal, the contract shall be awarded to the bidder maintaining a place of business in the City. However, if all or none of said bidders maintain a place of business in the City, then the contract shall be awarded by drawing lots. 9 | Page 5. PROPOSED CHANGE Proposed Language Addition  Moved this language into its subsection for increased public transparency.  This section provides information on the City’s bonding requirements related to competitive bidding. 1-7-3 (D): Bonding Requirements: All competitive bidding proposals must be sealed and, in the case of contracts for the construction of municipal buildings or facilities or labor, shall be accompanied by a bid security, performance bond, or labor and materials bond. 4. Bid security in an amount of ten percent (10%) or such other percentage as stated in the conditions of the full amount of the bid in the form of a bid bond. In a reasonable time after the bid opening, bid deposits of all, except the three lowest responsible bidders, will be released. The remaining deposits will be released after the successful bidder has entered into the contract and furnished the required insurance and any additional bonds. The bid deposit shall become the property of the city if the successful bidder within fourteen (14) days from awarding the contract refuses or is unable to comply with the contract requirements, not as a penalty, but as liquidated damages. 5. A performance bond, labor, and material bond or other bonds shall be required of the successful bidder at the time of execution of the contract, to guarantee the completion of any work to be performed by the contractor under the contract, payment of material used in such work, and for all labor performed in such work, including subcontractors. A performance bond satisfactory to the city must be executed by a Surety Company authorized to do business in the State of Illinois or otherwise secured in a manner satisfactory to the city in an amount equal to 110% of the contract price specified. The surety on the bond shall be a company that is licensed by the Department of Insurance, authorizing it to execute surety bonds. The company shall have a financial strength rating of at least "A," as rated by A.M. Best Company, Inc., Moody's Investors Service, Standard & Poor's Corporation, or a similar rating agency. In the event that the bidder fails to furnish the bonds within 14 days after notification of the award, then the bid guarantee shall be retained by the city as liquidated damages and not as a penalty. It is agreed that the sum is a fair estimate of the amount of damages that the city will sustain due to the bidder's failure to furnish the bonds. 10 | Page 6. PROPOSED CHANGE Current Language Removal: 1-7-3 (B)(3): Exemptions From Bidding Requirements: a. Notwithstanding any provisions of this section to the contrary, the competitive bidding procedures and requirements may be dispensed within any of the following instances: i. When a commodity being purchased is standardized in a manner to be compatible with equipment or articles in existing City use and in order to obtain more function or economic use from such existing equipment or articles, together with such commodity. ii. When in public session, the City Council has received competent information, data and sworn testimony supporting the facts that the product or service desired is provided only by one person or firm. iii. The City Council may authorize the purchase of materials, supplies, equipment and services or may order work performed by the City upon a finding of support by competent information or data that such purchase or work is urgent and immediately necessary for the preservation of life, health and property. The term "urgent and immediately" as used herein shall be deemed to mean threatening to happen at once, such as an impending danger or calamity. iv. When an agreement involves acquisition of services, equipment or any agreement entered into with another governmental entity. v. The City may award a renewal or extension of an existing contract or agreement with any supplier or vendor of services, equipment, materials or work performed by or on behalf of the City in the event that the City is satisfied with the past performance of the entity providing said service, equipment or work. In the event the City Council wishes to make a renewal or extension of an existing agreement with the City, no competitive bidding shall be required by the City Council by a vote of the majority of the Aldermen then holding office. Nothing contained herein shall be interpreted to restrict the power of the City to amend the terms of any existing agreement upon renewal or extension thereof so long as the City Council passes a resolution approving the terms of any amendment or modification of an existing agreement. The City may award any contract or approve any purchase of materials without advertising for bids if authorized by two-thirds (2/3) of the Aldermen then holding office. 11 | Page Proposed Language Addition  Added additional information about sole source purchases  Reworded the type of specialty contracts that can be exempt  Added purchases for IT, copies, and used items.  Removed requirement to waive competitive bidding for any purchases.  Retained City Council must approve such a purchase by a 2/3rds vote. 1-7-3 (E): Bid Exemptions: Unless prohibited by state or federal law, the following contracts and any other contracts which by their nature are not adapted to award by competitive bidding, shall be exempt from the purchasing requirements in subsection 1-7-3(B): a. Purchase contracts, for either labor, materials or both, which by their nature are not adaptable to award by competitive bidding, such as, but not limited to, contracts for the services of individuals possessing a high degree of professional skill where the ability or fitness of the individual plays an important part, contracts for supplies, materials, parts or equipment which are available only from a single source, and contracts for the printing of distributable information. b. All purchases of whatever nature, for labor, services or work, the purchase, lease or sale of personal property, materials, equipment or supplies, wherein the city council, by a two-thirds majority affirmative vote of the members of the city council then holding office, waive the requirement of open and competitive bidding, except in such instances where open and competitive bidding are required by the provisions of subsection 8-9-1 of the Illinois Municipal Code. c. Any purchases may be exempt from the purchasing requirements in subsubsection 1- 7-3(B) if a two-thirds (2/3) vote of the city council, then holding office is acquired. 7. PROPOSED CHANGE Proposed Language Addition  Added this section for increased transparency.  This subsection explains when the City can cancel a bid and they type of notification required. 1-7-3 (F): Bidding Cancellation: An invitation for bids, a request for proposals, or other solicitation may be canceled, or any or all bids or proposals may be rejected in whole or in part as may be specified in the solicitation by the City Administrator when in the best interests of the city. Notice of cancellation shall be sent to all persons solicited. The reasons therefor shall be made part of the contract file. Each solicitation issued by the city shall state that the solicitation may be canceled and that any bid or proposal may be rejected in whole or in part when in the best interests of the city. The reason(s) for rejection shall be provided upon request by unsuccessful bidders or offerors. 12 | Page 8. PROPOSED CHANGE Proposed Language Addition  Added this section for increased transparency.  This subsection provides information on when a change order is eligible and authorized. 1-7-3 (I): Change Orders: 1. After a contract is awarded pursuant to the purchasing requirements in subsection 1- 7-3(B), additional purchases or modifications may be made under the contract, or the terms of the contract may be extended without rebidding the materials, supplies, services or equipment involved. 2. All change orders are required to be approved by the city council should the original contract amount be exceeded by $10,000. 9. PROPOSED CHANGE Proposed Language Addition  Added this section for increased transparency.  This subsection provides information on the amount authorized to staff by the City Council for purchases of goods and services. 1-7-3 (J): Spending Limits: Department heads of the city, or their assignees, in the performance of their respective duties on behalf of the city, shall be empowered to authorize the ordering or purchase of budgeted materials, fixtures, equipment, services and supplies as may be deemed essential in the normal, day to day operations. The department head is responsible for determining if an item is budgeted, if adequate funds are available and if proper purchasing procedures have been followed. 10. PROPOSED CHANGE Proposed Language Addition  Added this section for increased transparency.  This subsection provides City Council authorization for staff to sign contracts within a designated cost threshold. 1-7-3 (K): Signing of Contracts: 1. All contracts must be executed by the City Administrator or his or her designee if the contract amount is less than $25,000.00. 2. If the contract is $25,000.00 or more, then the mayor or his or her designee must sign the  contract with the approval of the city council.  13 | Page 11. PROPOSED CHANGE Proposed Language Addition  Added this section for increased transparency.  This subsection provides the City’s procedure to contractors on the debarment process for vendors. 1-7-3 (L): Ineligible Contractors or Vendors: 1. The city council may debar a vendor, subcontractor, or supplier for: a. Conviction of, or civil judgment for: (1) Commission or attempted commission of fraud or a criminal offense in connection with obtaining, attempting to obtain, or performing a private or public contract or subcontract; (2) Violation or attempted violation of federal or state statutes, or any other legally applicable law, regulation, or rule relating to the submission of bids, proposals, or claims; (3) Commission or attempted commission of embezzlement, theft, forgery, bribery, falsification or destruction of records, making false statements, tax evasion, or receiving stolen property; or (4) Commission or attempted commission of any other offense or engaging in or attempting to engage in conduct indicating a lack of truthfulness, integrity, or honesty, which affects the responsibility of the vendor. b. Violation of the terms of a city ordinance or city contract or subcontract so severe as to justify debarment including, but not limited to: (1) Willful failure to perform in accordance with the terms of one or more contracts or subcontracts, including the hiring of subcontractors or suppliers debarred under this subsection; (2) A history of failure to perform one or more contracts or subcontracts; (3) A history of unsatisfactory performance of one or more contracts or subcontracts; or (4) A history of failure to meet equal employment opportunity obligations, or prevailing wage obligations, or any other contracting or subcontracting obligation imposed by this code or any other law. c. Making, attempting, or causing any false, deceptive, or fraudulent material statement in any bid, proposal, or application for city or any government work or in the performance of any such contract for the city or a government agency, or application for any permit or license. d. Refusal to cooperate with reasonable requests of city inspectors, representatives, or other appropriate city personnel with respect to work under contract provisions, plans, or specifications, or otherwise, pursuant to the duties of that city personnel. e. Founding, establishing or operating an entity in a manner designed to evade the application or defeat the purpose of these rules or any provision of this code, rule or regulation, the statutes, rules or regulations of the State of Illinois, or any federal statute, rule or regulation, or any other legally applicable law, regulation, or rule; 14 | Page f. Improper conduct, including, but not limited to, the commission or attempted commission of: (1) Intentional or negligent billing irregularities; (2) Submitting false or frivolous or exaggerated claims, documents, or records; (3) Falsification of claims, documents, or records; (4) Willful or grossly negligent destruction of documents or records the vendor had an obligation to maintain; (5) Bribery or coercion of a government official, or other unlawful tampering with a government official; (6) Use of false or deceptive statements to obtain some benefit, or causing competition to be restrained or limited; (7) Misrepresentation to any governmental agency or government official; (8) Violation of ethical standards established by the city, or other dishonesty incident to obtaining, prequalifying for, or performing any contract or modification thereof; (9) Failing to pay, after a reasonable period of time, any judgment or other adjudicated debt owed to the city after a request for payment; or (10) Failing to defend, indemnify, or hold harmless the city pursuant to a contractual obligation after having received a request to do so. g. Any other cause of so serious or compelling a nature that it affects the responsibility of the vendor. h. Debarment, disqualification, or suspension by any other government agency for any reason. i. Disqualification or rejection of a bid from a vendor or contractor on three (3) or more occasions within a three (3) year period. 2. Effect of Debarment: a. Notwithstanding the debarment of a contractor, the city may continue contracts or subcontracts in existence at the time the contractor was debarred unless the mayor directs otherwise. b. Debarred contractors are further prohibited from performing work as a contractor, subcontractor or materialman on any tier on city contracts. The city shall not accept or enter into any contract where a debarred contractor is proposed to perform the work. c. The debarment may be canceled prospectively, or the duration and scope may be reduced or waived by the mayor, upon the written application of the debarred individual or entity, supported by documentation, for any of the following reasons: (1) Newly discovered material evidence or documentable error in the findings of the city council's decision. (2) Reversal of the conviction or judgment on which the ineligibility is based on the conviction or judgment was based on an admission of conduct that was a cause for debarment. (3) Bona-fide change in ownership and control of the entity, or other mitigating factors sufficient, in the judgment of the city council, to remove the conditions giving rise to the conduct that led to the ineligibility. 15 | Page 3. Penalties: a. Any vendor obtaining services or hiring a subcontractor on any tier or supplier that has been debarred under this subsubsection may be subject to one or more of the following: (1) Immediate termination of all city contracts without recourse; (2) Placement on the list of debarred vendors for at least five (5) years; (3) Is guilty of a Class IV violation for each day, or part thereof, that the debarred vendor performed work; (4) Reduction of their contract price by an amount equal to the value of the work performed by a debarred vendor; and (5) Any city employee willfully violating this subsection or hiring a debarred vendor shall be subject to disciplinary action, up to and including termination. 16 | Page 12. PROPOSED CHANGE Proposed Language Addition  Added this section for increased transparency.  This subsection provides contractors information on how to protest a bid, should they not agree with the award authorized by the City Council. 1-7-3 (M): Bid Protests: 1. Right to Protest: Any actual or prospective bidder, offeror, or contractor who is aggrieved in connection with the solicitation or award of a contract may protest to the City Administrator. The protest shall be submitted in writing within ten (10) calendar days after such aggrieved person knows or should have known of the facts giving rise thereto. 2. Contract Claims: All claims by a contractor against the city relating to a contract shall be submitted in writing to the City Administrator. The contractor may request a conference with the City Administrator on a submitted claim. Claims include, without limitation, disputes arising under a contract and those based upon breach of contract, mistake, misrepresentation, or other cause for contract modification or rescission. 3. Authority To Resolve Protests And Contract Claims: a. Protests: The City Administrator shall have the authority consistent with this code to settle and resolve a protest of an aggrieved bidder, offeror, or contractor, actual or prospective, concerning the solicitation or award of a contract. b. Contract Claims: The City Administrator, after consulting with the City Attorney, shall have the authority to resolve contract claims, subject to the approval of the City Administrator or City Council, as applicable, regarding any settlement that will result in a change order or contract modification pursuant to Subsection 1-7- 3(I) of this code. 4. Decision: If a protest brought pursuant to this Section is not resolved by mutual agreement, the City Administrator shall promptly issue a decision in writing. A copy of the decision shall be mailed or otherwise furnished immediately to the protestant or claimant and any other party intervening. The decision shall state the reasons for the action taken. 5. Finality of Decision: A decision under this Section shall be final and conclusive unless, within ten (10) calendar days from the date of receipt of the decision, the protestant or claimant files a written appeal with the City Administrator. 6. Authority of The City Administrator: The City Administrator shall have the jurisdiction to review and determine any appeal by an aggrieved party from a determination by the City Administrator regarding a protest or contract claim. Such a decision shall be final and conclusive. 17 | Page 13. PROPOSED CHANGE Proposed Language Addition  Added this section for increased transparency.  Should the State change its procurement code, the City can abide by state law before updating its municipal code. 1-7-3 (N): Inconsistent State Law: If any provision of this subsection shall conflict with any provision of any statute or public law now or hereafter enacted by the Illinois General Assembly, such statute or public law shall control. Recommendation Staff recommends the City Council approve the attached ordinance authorizing the proposed changes to the City Code, Title 1, Chapter 7, Subsection 3: Contracts and Purchases. Attachments  Ordinance  Exhibit A – Amended City Code Title 1 Chapter 7 Section 3: Contracts and Purchases – Red-lined Version Ordinance No. 2020-____ Page 1 Ordinance No. 2020-______ AN ORDINANCE OF THE UNITED CITY OF YORKVILLE, KENDALL COUNTY, ILLINOIS, AMENDING THE YORKVILLE CITY CODE, TITLE 1, CHAPTER 7, SECTION 3: CONTRACTS AND PURCHASES 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 1, Chapter 7, Section 1-7-3 of the Yorkville City Code, establishes procedures for all purchases and contracts to be accepted by the City; and, WHEREAS, the Mayor and the City Council (the “Corporate Authorities”) have reviewed the procedures for contracts and purchases and have determined that it is in the best interest of the City and its residents to amend Title 1, Chapter 7, Section 1-7-3 of the Yorkville City Code to provide for procurement of all goods and services required by the City. 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 Section 1-7-3 of the Yorkville City Code, be and is hereby deleted in its entirety and the following added instead: “1-7-3: PROCUREMENT: A. PROCUREMENT OBJECTIVES: 1. It is the purpose of this subsection to establish competitive bidding and economical procurement practices, which shall apply to all purchases as herein described. 2. The City Administrator or his or her designee shall be the general purchasing agent of the city. Subject to the terms of this chapter, the City Administrator, or his or her designee shall oversee the purchasing process of all materials, supplies, services, and equipment necessary for the operation of the city. 3. Procurement procedures shall be consistent with any applicable federal, state, and local laws and any contractual obligations with other governmental agencies. Ordinance No. 2020-____ Page 2 4. The purchasing requirements, as herein established, are to be construed as maximum requirements and do not restrict those authorized to make purchases for the city to go beyond these requirements. 5. The purchasing requirements will not necessarily govern every purchasing situation that may arise. In the event a specific purchase is not covered by these requirements, the purchase shall be made based on these objectives following consultation with the City Administrator or his or her designee. All purchasing agreements shall provide that payment will be made in compliance with the Local Government Prompt Payment Act (50 ILCS 505/1). B. PURCHASING REQUIREMENTS: 1. Competitive Bidding - (Invitation to Bid [ITB]) – The Invitation for Bid (ITB) method is used to initiate a competitive sealed bid procurement. The ITB applies to contracts for construction or repair work and purchase of apparatus, supplies, materials, or equipment of more than twenty-five thousand dollars ($25,000.00). ITBs should include detailed specifications, the scope of work, contract, and any other legal requirements. These bids are received sealed by a specific date and are opened and read out loud publicly in-person or electronically. The standard for awarding contracts is based on the lowest responsive and responsible bidder, or bidders, based on the bid amount listed. For an ITB, the pricing is the main criteria. a. An Invitation To Bid (ITB or bid) shall be issued for contracts under this subsection and shall include specifications and all contractual terms and conditions applicable. Any business submitting a bid or proposal is referenced as a bidder in this code. (1) Bids shall be obtained by publishing a public notice in a newspaper of general circulation, city website, electronic bidding portal, or applicable trade publications. (2) Bids shall be published for at least ten (10) days, excluding Sundays and legal holidays, in advance of the due date announced in the invitation for the public opening. (3) The City Administrator shall designate a means of distribution or determination of information to interested parties using reasonably available methods. Such methods may include publication in newspapers of general circulation, electronic or paper mailing lists, and web sites designated and maintained for such notification. Said notice shall state the place, date, and time of the bid opening. (4) All bids and proposals must be sealed and submitted set forth in the request prior to the date and time stated for the opening of responses. (5) All contracts are to be awarded pursuant to this subsection shall be approved by the city council. (6) No contract shall be assignable or sublet by the successful bidder without the written consent of the City Administrator or his or her designee. In no event shall Ordinance No. 2020-____ Page 3 a contract or any part thereof be assigned or sublet to a bidder who had been declared not to be a responsible bidder in consideration of bids submitted in response to an invitation for bids for the particular contract. 2. Competitive Proposals (Request for Qualification [RFQ]/Request for Proposal [RFP]) – The Request for Qualifications (RFQ) method can be used as a pre-qualification stage of the procurement process. Only those proponents who successfully respond to the RFQ and meet the qualification criteria listed within the RFQ will move on in the selection process that will include submitting a cost proposal. The Request for Proposal(RFP) is a process where the strategy, objectives, cost, and other details that will assist with the ability to choose the most qualified vendor are included. The RFP can be used without an RFQ as a bidding technique to obtain cost information, but the pricing is not the main criteria. This two-stage approach can both streamline the solicitation process and assist in gathering information about candidates for future use. a. Requests for Proposals shall be considered when determining the following through a Qualifications Based Selection (QBS) process: (1) Whether the contract needs to be other than a fixed-price type; (2) Whether oral or written discussions may need to be conducted with proposers concerning technical and price aspects of their proposals; (3) Whether the award may need to be based upon a comparative evaluation as stated in the Request for Proposals of differing price, quality, and contractual factors in order to determine the most advantageous offering to the city. Quality factors include technical and performance capability and the content of the technical proposal; and (4) Whether the primary consideration in determining award may not be price. b. Request for Proposals shall be prepared in accordance with the bid requirements listed in the above subsections 1-7-3(B)(1)(a)1 – 6, and shall also include: (1) A statement that discussions may be conducted with proposers who submit proposals determined to be reasonably susceptible of being selected for the contract award, but that proposals may be accepted without such discussions; (2) A statement of when and how price should be submitted; and (3) A listing of the criteria by which a proper shall be selected and recommended to the city council may also be included. 3. Informal Purchasing - (Agreements/Contracts/Quotes) – Another procurement method would be informal purchasing. Informal purchasing is when the threshold of the purchase does not meet the competitive bidding requirements. The city's informal bidding threshold is five thousand dollars ($5,000.00) to twenty-five thousand dollars ($25,000.00). This method would include soliciting quotes for goods and services and developing or reviewing service contracts or agreements. Any purchases under five thousand dollars ($5,000.00) can be purchased with a purchasing card with the Department Head's permission. It is assumed that staff is using their best Ordinance No. 2020-____ Page 4 judgment when making these purchases about quality and price. Purchases of goods or services in excess of $25,000.00 require a formal competitive bidding process. C. ELECTRONIC BID PROCESS: Electronic Transactions: The City may conduct procurement transactions, including competitive sealed bids, competitive sealed proposals, and informal quotations, by electronic means or in electronic form. The City Administrator shall adopt operational procedures regarding: 1. Appropriate security to prevent unauthorized access to the bidding, approval and award processes; a. Identification; b. Confidentiality; and c. Utilization of digital signatures, where applicable. 2. Electronic Posting: The City may electronically post solicitations, determinations, and other information related to procurement on a centralized internet web site designated by the city for this purpose. 3. Electronic Bid Openings: The city may hold public bid openings electronically with the opportunity for public access and input. 4. Electronic Records: In accordance with the Illinois Electronic Commerce Security Act, 5 Illinois Compiled Statutes 175/1-101 et seq., whenever this Article requires a record to be "written" or "in writing," an electronic record satisfies that requirement. D. BONDING REQUIREMENTS: All competitive bidding proposals must be sealed and, in the case of contracts for the construction of municipal buildings or facilities or labor, shall be accompanied by a bid security, performance bond, or labor and materials bond. 1. Bid security in an amount of ten percent (10%) or such other percentage as stated in the conditions of the full amount of the bid in the form of a bid bond. In a reasonable time after the bid opening, bid deposits of all, except the three lowest responsible bidders, will be released. The remaining deposits will be released after the successful bidder has entered into the contract and furnished the required insurance and any additional bonds. The bid deposit shall become the property of the city if the successful bidder within fourteen (14) days from awarding the contract refuses or is unable to comply with the contract requirements, not as a penalty, but as liquidated damages. 2. A performance bond, labor, and material bond or other bonds shall be required of the successful bidder at the time of execution of the contract, to guarantee the completion of any work to be performed by the contractor under the contract, payment of material used in such work, and for all labor performed in such work, including subcontractors. A performance bond satisfactory to the city must be executed by a Surety Company authorized to do business in the State of Illinois or otherwise secured in a manner satisfactory to the city in an amount equal to 110% of the contract price specified. The Ordinance No. 2020-____ Page 5 surety on the bond shall be a company that is licensed by the Department of Insurance, authorizing it to execute surety bonds. The company shall have a financial strength rating of at least "A," as rated by A.M. Best Company, Inc., Moody's Investors Service, Standard & Poor's Corporation, or a similar rating agency. In the event that the bidder fails to furnish the bonds within 14 days after notification of the award, then the bid guarantee shall be retained by the city as liquidated damages and not as a penalty. It is agreed that the sum is a fair estimate of the amount of damages that the city will sustain due to the bidder's failure to furnish the bonds. E. BID EXEMPTIONS: Unless prohibited by state or federal law, the following contracts and any other contracts which by their nature are not adapted to award by competitive bidding, shall be exempt from the purchasing requirements in subsection 1-7-3(B): a. Purchase contracts, for either labor, materials or both, which by their nature are not adaptable to award by competitive bidding, such as, but not limited to, contracts for the services of individuals possessing a high degree of professional skill where the ability or fitness of the individual plays an important part, contracts for supplies, materials, parts or equipment which are available only from a single source, and contracts for the printing of distributable information. b. All purchases of whatever nature, for labor, services or work, the purchase, lease or sale of personal property, materials, equipment or supplies, wherein the city council, by a two-thirds majority affirmative vote of the members of the city council then holding office, waive the requirement of open and competitive bidding, except in such instances where open and competitive bidding are required by the provisions of subsection 8-9-1 of the Illinois Municipal Code. c. Any purchases may be exempt from the purchasing requirements in subsubsection 1-7- 3(B) if a two-thirds (2/3) vote of the city council, then holding office is acquired. F. BIDDING CANCELLATION: An invitation for bids, a request for proposals, or other solicitation may be canceled, or any or all bids or proposals may be rejected in whole or in part as may be specified in the solicitation by the City Administrator when in the best interests of the city. Notice of cancellation shall be sent to all persons solicited. The reasons therefor shall be made part of the contract file. Each solicitation issued by the city shall state that the solicitation may be canceled and that any bid or proposal may be rejected in whole or in part when in the best interests of the city. The reason(s) for rejection shall be provided upon request by unsuccessful bidders or offerors. G. COOPERATIVE PROCUREMENT: Ordinance No. 2020-____ Page 6 1. Authority: When deemed in the best interest of the city by the City Administrator, supplies, services, or construction may be procured pursuant to a cooperative purchasing agreement in accordance with the Governmental Joint Purchasing Act, 30 Illinois Compiled Statutes 525/1 et seq., as amended. 2. Cooperative Purchasing: The city may participate in, sponsor, conduct, or administer a cooperative purchasing agreement for the procurement of any supplies, services, or construction with one or more governmental units in accordance with a formal agreement entered into by the participants. Such cooperative purchasing may include but is not limited to, joint or multi-party contracts between public procurement units and open-ended public procurement unit contracts that are made available to other governmental units. 3. Competition: All cooperative purchasing conducted under this subsection shall be through contracts awarded through full and open competition, including the use of source selection methods substantially equivalent to those specified in Subsection 1-7-3(B) of this Code. H. SURPLUS PROPERTY: 1. Real Property: The city has either (1) adopted an ordinance to sell surplus real estate pursuant to Section11- 76-4.2 of the Illinois Municipal Code, 65 ILCS 5/1-1-1 et. seq. (the "Illinois Municipal Code") and has received no bid; or, (2) adopted a resolution to sell surplus real estate under Section 11-76-4.1 of the Illinois Municipal Code and has received no acceptable offer within six (6) months after the adoption of the resolution, then that parcel of surplus real estate may be sold in the following manner. If the city has an unemployment rate higher than the national average for at least one (1) month during the six (6) months preceding an ordinance adopted to sell surplus real estate and the city has not received an acceptable offer within six (6) months of the date of the resolution authorizing the sale, then the City Council may, by resolution, authorize the sale of surplus public real estate in any of the following manners: a. by the staff of the municipality; b. by listing with local licensed real estate agencies; or c. by public auction. The terms of the sale, the compensation of the agent, if any, the time and the place of the auction, if applicable, a legal description of the property and its size, use and zoning shall be included in the resolution. The resolution shall be published once each week for three (3) successive weeks in a daily or weekly newspaper published in the municipality or, if none, in Ordinance No. 2020-____ Page 7 a newspaper published in the county in which the municipality is located. No sale may be conducted until at least thirty (30) days after the first publication. The corporate authorities may accept any offer or bid determined by them to be in the best interest of the municipality by a vote of three-fourths (3/4) of the corporate authorities then holding office. 2. Personal Property: Pursuant to Section 11-76-4 of the Illinois Municipal Code, whenever the city owns any personal property which is no longer necessary or useful to or in the best interests of the city to retain with a residual value of less than $5,000, the City Administrator is authorized to sell or dispose of such property by any method the City Administrator deems to be in the best interests of the city, including not limited to: a. Competitive sealed bidding; b. Donation; c. Recycling Company; d. Public auction; e. Trade-in, when the City Administrator or his or her designee determines the trade-in value is expected to exceed the value estimated to be obtained through the sale of such supplies; or f. Disposal, when the City Administrator or his or her designee determines that surplus supplies have no resale value, or that the cost of transportation, storage, and sale of said supplies will exceed the anticipated sale value. Any personal property which has a residual value in excess of $5,000 shall be sold or disposed of pursuant to any one of the methods set forth above as recommended by the City Administrator and approved by the City Council. The surplus property shall not be made available to any elected or appointed official or employee of the city, unless through a public auction or competitive sealed bidding process. I. CHANGE ORDERS: 1. After a contract is awarded pursuant to the purchasing requirements in subsection 1-7- 3(B), additional purchases or modifications may be made under the contract, or the terms of the contract may be extended without rebidding the materials, supplies, services or equipment involved. 2. All change orders are required to be approved by the city council should the original contract amount be exceeded by $25,000 or increase the total contract amount to exceed $25,000. J. SPENDING LIMITS: Department heads of the city, or their assignees, in the performance of their respective duties on behalf of the city, shall be empowered to authorize the ordering or purchase of budgeted Ordinance No. 2020-____ Page 8 materials, fixtures, equipment, services and supplies as may be deemed essential in the normal, day to day operations. The department head is responsible for determining if an item is budgeted, if adequate funds are available and if proper purchasing procedures have been followed. K. SIGNING OF CONTRACTS: 1. All contracts must be executed by the City Administrator or his or her designee if the contract amount is less than $25,000.00. 2. If the contract is $25,000.00 or more, then the mayor or his or her designee must sign the contract with the approval of the city council. L. INELIGIBLE CONTRACTORS OR VENDORS: 1. The city council may debar a vendor, subcontractor, or supplier for: a. Conviction of, or civil judgment for: (1) Commission or attempted commission of fraud or a criminal offense in connection with obtaining, attempting to obtain, or performing a private or public contract or subcontract; (2) Violation or attempted violation of federal or state statutes, or any other legally applicable law, regulation, or rule relating to the submission of bids, proposals, or claims; (3) Commission or attempted commission of embezzlement, theft, forgery, bribery, falsification or destruction of records, making false statements, tax evasion, or receiving stolen property; or (4) Commission or attempted commission of any other offense or engaging in or attempting to engage in conduct indicating a lack of truthfulness, integrity, or honesty, which affects the responsibility of the vendor. b. Violation of the terms of a city ordinance or city contract or subcontract so severe as to justify debarment including, but not limited to: (1) Willful failure to perform in accordance with the terms of one or more contracts or subcontracts, including the hiring of subcontractors or suppliers debarred under this subsection; (2) A history of failure to perform one or more contracts or subcontracts; (3) A history of unsatisfactory performance of one or more contracts or subcontracts; or (4) A history of failure to meet equal employment opportunity obligations, or prevailing wage obligations, or any other contracting or subcontracting obligation imposed by this code or any other law. c. Making, attempting, or causing any false, deceptive, or fraudulent material statement in any bid, proposal, or application for city or any government work or in the performance of any such contract for the city or a government agency, or application for any permit or license. Ordinance No. 2020-____ Page 9 d. Refusal to cooperate with reasonable requests of city inspectors, representatives, or other appropriate city personnel with respect to work under contract provisions, plans, or specifications, or otherwise, pursuant to the duties of that city personnel. e. Founding, establishing or operating an entity in a manner designed to evade the application or defeat the purpose of these rules or any provision of this code, rule or regulation, the statutes, rules or regulations of the State of Illinois, or any federal statute, rule or regulation, or any other legally applicable law, regulation, or rule; f. Improper conduct, including, but not limited to, the commission or attempted commission of: (1) Intentional or negligent billing irregularities; (2) Submitting false or frivolous or exaggerated claims, documents, or records; (3) Falsification of claims, documents, or records; (4) Willful or grossly negligent destruction of documents or records the vendor had an obligation to maintain; (5) Bribery or coercion of a government official, or other unlawful tampering with a government official; (6) Use of false or deceptive statements to obtain some benefit, or causing competition to be restrained or limited; (7) Misrepresentation to any governmental agency or government official; (8) Violation of ethical standards established by the city, or other dishonesty incident to obtaining, prequalifying for, or performing any contract or modification thereof; (9) Failing to pay, after a reasonable period of time, any judgment or other adjudicated debt owed to the city after a request for payment; or (10) Failing to defend, indemnify, or hold harmless the city pursuant to a contractual obligation after having received a request to do so. g. Any other cause of so serious or compelling a nature that it affects the responsibility of the vendor. h. Debarment, disqualification, or suspension by any other government agency for any reason. i. Disqualification or rejection of a bid from a vendor or contractor on three (3) or more occasions within a three (3) year period. 2. Effect of Debarment: a. Notwithstanding the debarment of a contractor, the city may continue contracts or subcontracts in existence at the time the contractor was debarred unless the mayor directs otherwise. b. Debarred contractors are further prohibited from performing work as a contractor, subcontractor or materialman on any tier on city contracts. The city shall not accept or enter into any contract where a debarred contractor is proposed to perform the work. c. The debarment may be canceled prospectively, or the duration and scope may be reduced or waived by the mayor, upon the written application of the debarred individual or entity, supported by documentation, for any of the following reasons: (1) Newly discovered material evidence or documentable error in the findings of the city council's decision. Ordinance No. 2020-____ Page 10 (2) Reversal of the conviction or judgment on which the ineligibility is based on the conviction or judgment was based on an admission of conduct that was a cause for debarment. (3) Bona-fide change in ownership and control of the entity, or other mitigating factors sufficient, in the judgment of the city council, to remove the conditions giving rise to the conduct that led to the ineligibility. 3. Penalties: a. Any vendor obtaining services or hiring a subcontractor on any tier or supplier that has been debarred under this subsubsection may be subject to one or more of the following: (1) Immediate termination of all city contracts without recourse; (2) Placement on the list of debarred vendors for at least five (5) years; (3) Is guilty of a Class IV violation for each day, or part thereof, that the debarred vendor performed work; (4) Reduction of their contract price by an amount equal to the value of the work performed by a debarred vendor; and (5) Any city employee willfully violating this subsection or hiring a debarred vendor shall be subject to disciplinary action, up to and including termination. M. BID PROTESTS: 1. Right to Protest: Any actual or prospective bidder, offeror, or contractor who is aggrieved in connection with the solicitation or award of a contract may protest to the City Administrator. The protest shall be submitted in writing within ten (10) calendar days after such aggrieved person knows or should have known of the facts giving rise thereto. 2. Contract Claims: All claims by a contractor against the city relating to a contract shall be submitted in writing to the City Administrator. The contractor may request a conference with the City Administrator on a submitted claim. Claims include, without limitation, disputes arising under a contract and those based upon breach of contract, mistake, misrepresentation, or other cause for contract modification or rescission. 3. Authority To Resolve Protests And Contract Claims: a. Protests: The City Administrator shall have the authority consistent with this code to settle and resolve a protest of an aggrieved bidder, offeror, or contractor, actual or prospective, concerning the solicitation or award of a contract. b. Contract Claims: The City Administrator, after consulting with the City Attorney, shall have the authority to resolve contract claims, subject to the approval of the City Administrator or City Council, as applicable, regarding any settlement that will result in a change order or contract modification pursuant to Subsection 1-7-3(I) of this code. 4. Decision: If a protest brought pursuant to this Section is not resolved by mutual agreement, the City Administrator shall promptly issue a decision in writing. A copy of the decision shall be mailed or otherwise furnished immediately to the protestant or Ordinance No. 2020-____ Page 11 claimant and any other party intervening. The decision shall state the reasons for the action taken. 5. Finality of Decision: A decision under this Section shall be final and conclusive unless, within ten (10) calendar days from the date of receipt of the decision, the protestant or claimant files a written appeal with the City Administrator. 6. Authority of The City Administrator: The City Administrator shall have the jurisdiction to review and determine any appeal by an aggrieved party from a determination by the City Administrator regarding a protest or contract claim. Such a decision shall be final and conclusive. N. INCONSISTENT STATE LAW: If any provision of this subsection shall conflict with any provision of any statute or public law now or hereafter enacted by the Illinois General Assembly, such statute or public law shall control.” Section 2. 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. 2020. ______________________________ CITY CLERK KEN KOCH _________ DAN TRANSIER _________ JACKIE MILSCHEWSKI _________ ARDEN JOE PLOCHER _________ CHRIS FUNKHOUSER _________ JOEL FRIEDERS _________ SEAVER TARULIS _________ JASON PETERSON _________ Ordinance No. 2020-____ Page 12 APPROVED by me, as Mayor of the United City of Yorkville, Kendall County, Illinois this ____ day of __________________, A.D. 2020. ______________________________ MAYOR Attest: ______________________________ CITY CLERK EXHIBIT A: CHAPTER 7 MUNICIPAL FINANCES 1-7-1: BUDGET AND BUDGET OFFICER: 1-7-2: TAX LEVY: 1-7-3: CONTRACTS AND PURCHASESPROCUREMENT: 1-7-4: PUBLIC BENEFIT TAX AND FUND: 1-7-5: WATER TOWER CONSTRUCTION ACCOUNT: 1-7-6: WAGE RATES FOR PUBLIC WORKS EMPLOYEES: 1-7-7: DISCLOSURE OF PUBLIC RECORDS; FEES: 1-7-8: DEVELOPMENT FEES FOR EXTENDING MUNICIPAL SERVICES: 1-7-9: ANNEXATION AND ZONING FEES: 1-7-10: DIRECTOR OF FINANCE: 1-7-11: VOLUNTARY PAYMENT: 1-7-3: CONTRACTS AND PURCHASESPROCUREMENT: A. PROCUREMENT Definitions: The expression "lowest responsible bidder", as used in this section and in the City's bidding documents, shall be deemed to mean the lowest bidder whose offer best represents in quality, fitness and capacity the requirements of the proposed work or usage.OBJECTIVES: 1. It is the purpose of this subsection to establish competitive bidding and economical procurement practices, which shall apply to all purchases as herein described. 2. The City Administrator or his or her designee shall be the general purchasing agent of the city. Subject to the terms of this chapter, the City Administrator, or his or her designee shall oversee the purchasing process of all materials, supplies, services, and equipment necessary for the operation of the city. 3. Procurement procedures shall be consistent with any applicable federal, state, and local laws and any contractual obligations with other governmental agencies. 4. The purchasing requirements, as herein established, are to be construed as maximum requirements and do not restrict those authorized to make purchases for the city to go beyond these requirements. 5. The purchasing requirements will not necessarily govern every purchasing situation that may arise. In the event a specific purchase is not covered by these requirements, the purchase shall be made based on these objectives following consultation with the City Administrator or his or her designee. All purchasing agreements shall provide that payment will be made in compliance with the Local Government Prompt Payment Act (50 ILCS 505/1). A. Bids For All Contracts For Services Of Materials Over Twenty Five Thousand Dollars: 1. Advertising For Bids: Except as otherwise provided herein, all contracts of whatever nature for labor, services or work, and for the purchase or lease of materials or supplies involving amounts in excess of twenty five thousand dollars ($25,000.00) made by or on behalf of the City shall be let to the lowest responsible bidder following notice as required in the following subsections: a. Notice shall be published in a newspaper of general circulation throughout the City at least once which publication shall be at least fifteen (15) days prior to the time designated for opening bids. The notice shall include a general description of the article or service desired, shall state the time, date and place of bid opening, and shall designate where bidding documents may be obtained. b. All purchases or contracts to be let shall be noticed by posting on the public bulletin board in the City Hall. 2. Bidding Procedures: 1. Bidder's Security: All bids must be sealed and, in the case of contracts for construction of Municipal buildings or facilities or for labor, shall be accompanied by security, either cash, cashier's check, certified check or surety bond, in a sum equal to ten percent (10%) of the total aggregate of the bid. The successful bidder shall forfeit his bid security upon such bidder's failure or refusal to execute the contract within the time designated in the bid documents. The City Council, in such event, may award the contract to the new lowest responsible bidder. 2. Other Bond Requirements: A faithful performance bond, labor and material bond and other bonds may be required by the City Council in amounts reasonably necessary to protect the City's interests in obtaining the services or work involved. If bonds are required, the form and amount thereof shall be designated in the notice inviting bids. 3. Bid Opening Procedures: All bids shall be submitted to the City Clerk, who shall safeguard them in a sealed condition until the time noticed for public bid opening. At the time and place stated in the public notices, the City Clerk or designee shall publicly open all bids. The tabulation of all bids or copies of bids received shall be available for public inspection in the Clerk's Office for a period of not less than thirteen (13) days after the bid opening. 4. Award Of Contracts: i. Lowest Responsible Bidder: The City Council may make an award of contract to the lowest responsible bidder. If considered to be in the best interest of the City, selected portions of the lowest responsible bid may be accepted and award made accordingly. In the alternative, the City Council may either reject all bids and readvertise or authorize the City itself to perform the work and directly acquire the items desired in accordance with the immediately following provision. ii. Direct Method: After bids are rejected or if no bids are received, the City Council, by resolution and act of majority vote of the Council, including the Mayor, may authorize the work done by City personnel and equipment or may authorize the purchase of the material and equipment for services involved on the open market without complying with the requirements of this section, provided that the City Council reserves competent information or data that the City itself is capable of completing the project involved in a more satisfactory or economical manner or that the materials, equipment or services may be purchased more economically on the open market. B. Tie Bids: If two (2) or more bids are received which are in all respects equal, the contract shall be awarded to the bidder maintaining a place of business in the City. However, if all or none of said bidders maintain a place of business in the City, then the contract shall be awarded by drawing lots.PURCHASING REQUIREMENTS: 1. Competitive Bidding - (Invitation to Bid [ITB]) – The Invitation for Bid (ITB) method is used to initiate a competitive sealed bid procurement. The ITB applies to contracts for construction or repair work and purchase of apparatus, supplies, materials, or equipment of more than twenty-five thousand dollars ($25,000.00). ITBs should include detailed specifications, the scope of work, contract, and any other legal requirements. These bids are received sealed by a specific date and are opened and read out loud publicly in-person or electronically. The standard for awarding contracts is based on the lowest responsive and responsible bidder, or bidders, based on the bid amount listed. For an ITB, the pricing is the main criteria. a. An Invitation To Bid (ITB or bid) shall be issued for contracts under this subsection and shall include specifications and all contractual terms and conditions applicable. Any business submitting a bid or proposal is referenced as a bidder in this code. (1) Bids shall be obtained by publishing a public notice in a newspaper of general circulation, city website, electronic bidding portal, or applicable trade publications. (2) Bids shall be published for at least ten (10) days, excluding Sundays and legal holidays, in advance of the due date announced in the invitation for the public opening. (3) The City Administrator shall designate a means of distribution or determination of information to interested parties using reasonably available methods. Such methods may include publication in newspapers of general circulation, electronic or paper mailing lists, and web sites designated and maintained for such notification. Said notice shall state the place, date, and time of the bid opening. (4) All bids and proposals must be sealed and submitted set forth in the request prior to the date and time stated for the opening of responses. (5) All contracts are to be awarded pursuant to this subsection shall be approved by the city council. (6) No contract shall be assignable or sublet by the successful bidder without the written consent of the City Administrator or his or her designee. In no event shall a contract or any part thereof be assigned or sublet to a bidder who had been declared not to be a responsible bidder in consideration of bids submitted in response to an invitation for bids for the particular contract. 2. Competitive Proposals (Request for Qualification [RFQ]/Request for Proposal [RFP]) – The Request for Qualifications (RFQ) method can be used as a pre-qualification stage of the procurement process. Only those proponents who successfully respond to the RFQ and meet the qualification criteria listed within the RFQ will move on in the selection process that will include submitting a cost proposal. The Request for Proposal(RFP) is a process where the strategy, objectives, cost, and other details that will assist with the ability to choose the most qualified vendor are included. The RFP can be used without an RFQ as a bidding technique to obtain cost information, but the pricing is not the main criteria. This two-stage approach can both streamline the solicitation process and assist in gathering information about candidates for future use. a. Requests for Proposals shall be considered when determining the following through a Qualifications Based Selection (QBS) process: (1) Whether the contract needs to be other than a fixed-price type; (2) Whether oral or written discussions may need to be conducted with proposers concerning technical and price aspects of their proposals; (3) Whether the award may need to be based upon a comparative evaluation as stated in the Request for Proposals of differing price, quality, and contractual factors in order to determine the most advantageous offering to the city. Quality factors include technical and performance capability and the content of the technical proposal; and (4) Whether the primary consideration in determining award may not be price. b. Request for Proposals shall be prepared in accordance with the bid requirements listed in the above subsections 1-7-3(B)(1)(a)1 – 6, and shall also include: (1) A statement that discussions may be conducted with proposers who submit proposals determined to be reasonably susceptible of being selected for the contract award, but that proposals may be accepted without such discussions; (2) A statement of when and how price should be submitted; and (3) A listing of the criteria by which a proper shall be selected and recommended to the city council may also be included. 3. Informal Purchasing - (Agreements/Contracts/Quotes) – Another procurement method would be informal purchasing. Informal purchasing is when the threshold of the purchase does not meet the competitive bidding requirements. The city's informal bidding threshold is five thousand dollars ($5,000.00) to twenty-five thousand dollars ($25,000.00). This method would include soliciting quotes for goods and services and developing or reviewing service contracts or agreements. Any purchases under five thousand dollars ($5,000.00) can be purchased with a purchasing card with the Department Head's permission. It is assumed that staff is using their best judgment when making these purchases about quality and price. Purchases of goods or services in excess of $25,000.00 require a formal competitive bidding process. C. ELECTRONIC BID PROCESS: Electronic Transactions: The City may conduct procurement transactions, including competitive sealed bids, competitive sealed proposals, and informal quotations, by electronic means or in electronic form. The City Administrator shall adopt operational procedures regarding: 1. Appropriate security to prevent unauthorized access to the bidding, approval and award processes; a. Identification; b. Confidentiality; and c. Utilization of digital signatures, where applicable. 2. Electronic Posting: The City may electronically post solicitations, determinations, and other information related to procurement on a centralized internet web site designated by the city for this purpose. 3. Electronic Bid Openings: The city may hold public bid openings electronically with the opportunity for public access and input. 4. Electronic Records: In accordance with the Illinois Electronic Commerce Security Act, 5 Illinois Compiled Statutes 175/1-101 et seq., whenever this Article requires a record to be "written" or "in writing," an electronic record satisfies that requirement. D. BONDING REQUIREMENTS: All competitive bidding proposals must be sealed and, in the case of contracts for the construction of municipal buildings or facilities or labor, shall be accompanied by a bid security, performance bond, or labor and materials bond. 1. Bid security in an amount of ten percent (10%) or such other percentage as stated in the conditions of the full amount of the bid in the form of a bid bond. In a reasonable time after the bid opening, bid deposits of all, except the three lowest responsible bidders, will be released. The remaining deposits will be released after the successful bidder has entered into the contract and furnished the required insurance and any additional bonds. The bid deposit shall become the property of the city if the successful bidder within fourteen (14) days from awarding the contract refuses or is unable to comply with the contract requirements, not as a penalty, but as liquidated damages. 2. A performance bond, labor, and material bond or other bonds shall be required of the successful bidder at the time of execution of the contract, to guarantee the completion of any work to be performed by the contractor under the contract, payment of material used in such work, and for all labor performed in such work, including subcontractors. A performance bond satisfactory to the city must be executed by a Surety Company authorized to do business in the State of Illinois or otherwise secured in a manner satisfactory to the city in an amount equal to 110% of the contract price specified. The surety on the bond shall be a company that is licensed by the Department of Insurance, authorizing it to execute surety bonds. The company shall have a financial strength rating of at least "A," as rated by A.M. Best Company, Inc., Moody's Investors Service, Standard & Poor's Corporation, or a similar rating agency. In the event that the bidder fails to furnish the bonds within 14 days after notification of the award, then the bid guarantee shall be retained by the city as liquidated damages and not as a penalty. It is agreed that the sum is a fair estimate of the amount of damages that the city will sustain due to the bidder's failure to furnish the bonds. 3. Exemptions From Bidding Requirements: a. Notwithstanding any provisions of this section to the contrary, the competitive bidding procedures and requirements may be dispensed within any of the following instances: i. When a commodity being purchased is standardized in a manner to be compatible with equipment or articles in existing City use and in order to obtain more function or economic use from such existing equipment or articles, together with such commodity. ii. When in public session, the City Council has received competent information, data and sworn testimony supporting the facts that the product or service desired is provided only by one person or firm. iii. The City Council may authorize the purchase of materials, supplies, equipment and services or may order work performed by the City upon a finding of support by competent information or data that such purchase or work is urgent and immediately necessary for the preservation of life, health and property. The term "urgent and immediately" as used herein shall be deemed to mean threatening to happen at once, such as an impending danger or calamity. iv. When an agreement involves acquisition of services, equipment or any agreement entered into with another governmental entity. v. The City may award a renewal or extension of an existing contract or agreement with any supplier or vendor of services, equipment, materials or work performed by or on behalf of the City in the event that the City is satisfied with the past performance of the entity providing said service, equipment or work. In the event the City Council wishes to make a renewal or extension of an existing agreement with the City, no Formatted: Font: (Default) Times New Roman, 12 pt competitive bidding shall be required by the City Council by a vote of the majority of the Aldermen then holding office. Nothing contained herein shall be interpreted to restrict the power of the City to amend the terms of any existing agreement upon renewal or extension thereof so long as the City Council passes a resolution approving the terms of any amendment or modification of an existing agreement. E. The City may award any contract or approve any purchase of materials without advertising for bids if authorized by two-thirds (2/3) of the Aldermen then holding office.BID EXEMPTIONS: Unless prohibited by state or federal law, the following contracts and any other contracts which by their nature are not adapted to award by competitive bidding, shall be exempt from the purchasing requirements in subsection 1-7-3(B): 1. Purchase contracts, for either labor, materials or both, which by their nature are not adaptable to award by competitive bidding, such as, but not limited to, contracts for the services of individuals possessing a high degree of professional skill where the ability or fitness of the individual plays an important part, contracts for supplies, materials, parts or equipment which are available only from a single source, and contracts for the printing of distributable information. 2. All purchases of whatever nature, for labor, services or work, the purchase, lease or sale of personal property, materials, equipment or supplies, wherein the city council, by a two-thirds majority affirmative vote of the members of the city council then holding office, waive the requirement of open and competitive bidding, except in such instances where open and competitive bidding are required by the provisions of subsection 8-9-1 of the Illinois Municipal Code. 3. Any purchases may be exempt from the purchasing requirements in subsubsection 1-7- 3(B) if a two-thirds (2/3) vote of the city council, then holding office is acquired. F. BIDDING CANCELLATION: An invitation for bids, a request for proposals, or other solicitation may be canceled, or any or all bids or proposals may be rejected in whole or in part as may be specified in the solicitation by the City Administrator when in the best interests of the city. Notice of cancellation shall be sent to all persons solicited. The reasons therefor shall be made part of the contract file. Each solicitation issued by the city shall state that the solicitation may be canceled and that any bid or proposal may be rejected in whole or in part when in the best interests of the city. The reason(s) for rejection shall be provided upon request by unsuccessful bidders or offerors. A.G. COOPERATIVE PROCUREMENT: 1. Authority: When deemed in the best interest of the city by the city administratorCity Administrator, supplies, services, or construction may be procured pursuant to a cooperative purchasing agreement in accordance to with the Governmental Joint Purchasing Act, 30 Illinois Compiled Statutes 525/1 et seq., as amended. 2. Cooperative Purchasing: The city may participate in, sponsor, conduct, or administer a cooperative purchasing agreement for the procurement of any supplies, services, or construction with one or more governmental units in accordance with a formal agreement entered into by the participants. Such cooperative purchasing may include but is not limited to, joint or multi-party contracts between public procurement units and open-ended public procurement unit contracts that are made available to other governmental units. 3. Competition: All cooperative purchasing conducted under this subsection shall be through contracts awarded through full and open competition, including the use of source selection methods substantially equivalent to those specified in Subsection 1-7-3(B) of this Code. B.H. SURPLUS PROPERTY: 1. Real Property: In tThe City city has either (1) adopted an ordinance to sell surplus real estate pursuant to Section11-76-4.2 of the Illinois Municipal Code, 65 ILCS 5/1-1-1 et. seq. (the “"Illinois Municipal Code”) ") and has received no bid; or, (2) adopted a resolution to sell surplus real estate under Section 11-76-4.1 of the Illinois Municipal Code and has received no acceptable offer within six (6) months after the adoption of the resolution, then that parcel of surplus real estate may be sold in the following manner. If the City city has an unemployment rate higher than the national average for at least one (1) month during the six (6) months preceding an ordinance adopted to sell surplus real estate and the City city has not received an acceptable offer within six (6) months of the date of the resolution authorizing the sale, then the City Council may, by resolution, authorize the sale of surplus public real estate in any of the following manners: a. by the staff of the municipality; b. by listing with local licensed real estate agencies; or c. by public auction. The terms of the sale, the compensation of the agent, if any, the time and the place of the auction, if applicable, a legal description of the property and its size, use and zoning shall be included in the resolution. The resolution shall be published once each week for three (3) successive weeks in a daily or weekly newspaper published in the municipality or, if none, in a newspaper published in the county in which the municipality is located. No sale may be conducted until at least thirty (30) days after the first publication. The corporate authorities may accept any offer or bid determined by them to be in the best interest of the municipality by a vote of three-fourths (3/4) of the corporate authorities then holding office. 2. Personal Property: Pursuant to Section 11-76-4 of the Illinois Municipal Code, whenever the City city owns any personal property which is no longer necessary or useful to or in the best interests of the City city to retain with a residual value of less than $5,000, the City Administrator is authorized to sell or dispose of such property by any method the City Administrator deems to be in the best interests of the Citycity, including not limited to: a. Competitive sealed bidding; b. Donation; c. Recycling Company; d. Public auction; e. Trade-in, when the City Administrator or his or her designee determines the trade-in value is expected to exceed the value estimated to be obtained through the sale of such supplies; or f. Disposal, when the City Administrator or his or her designee determines that surplus supplies have no resale value, or that the cost of transportation, storage, and sale of said supplies will exceed the anticipated sale value. Any personal property which has a residual value in excess of $5,000 shall be sold or disposed of pursuant to any one of the methods set forth above as recommended by the City Administrator and approved by the City Council. Surplus The surplus property shall not be made available to any elected or appointed official or employee of the Citycity, unless through a public auction or competitive sealed bidding process. I. CHANGE ORDERS: 1. After a contract is awarded pursuant to the purchasing requirements in subsection 1-7- 3(B), additional purchases or modifications may be made under the contract, or the terms of the contract may be extended without rebidding the materials, supplies, services or equipment involved. 2. All change orders are required to be approved by the city council should the original contract amount be exceeded by $10,000. J. SPENDING LIMITS: Department heads of the city, or their assignees, in the performance of their respective duties on behalf of the city, shall be empowered to authorize the ordering or purchase of budgeted materials, fixtures, equipment, services and supplies as may be deemed essential in the normal, day to day operations. The department head is responsible for determining if an item is budgeted, if adequate funds are available and if proper purchasing procedures have been followed. K. SIGNING OF CONTRACTS: 1. All contracts must be executed by the City Administrator or his or her designee if the contract amount is less than $25,000.00. 2. If the contract is $25,000.00 or more, then the mayor or his or her designee must sign the contract with the approval of the city council. L. INELIGIBLE CONTRACTORS OR VENDORS: 1. The city council may debar a vendor, subcontractor, or supplier for: a. Conviction of, or civil judgment for: (1) Commission or attempted commission of fraud or a criminal offense in connection with obtaining, attempting to obtain, or performing a private or public contract or subcontract; (2) Violation or attempted violation of federal or state statutes, or any other legally applicable law, regulation, or rule relating to the submission of bids, proposals, or claims; (3) Commission or attempted commission of embezzlement, theft, forgery, bribery, falsification or destruction of records, making false statements, tax evasion, or receiving stolen property; or (4) Commission or attempted commission of any other offense or engaging in or attempting to engage in conduct indicating a lack of truthfulness, integrity, or honesty, which affects the responsibility of the vendor. b. Violation of the terms of a city ordinance or city contract or subcontract so severe as to justify debarment including, but not limited to: (1) Willful failure to perform in accordance with the terms of one or more contracts or subcontracts, including the hiring of subcontractors or suppliers debarred under this subsection; (2) A history of failure to perform one or more contracts or subcontracts; (3) A history of unsatisfactory performance of one or more contracts or subcontracts; or (4) A history of failure to meet equal employment opportunity obligations, or prevailing wage obligations, or any other contracting or subcontracting obligation imposed by this code or any other law. c. Making, attempting, or causing any false, deceptive, or fraudulent material statement in any bid, proposal, or application for city or any government work or in the performance of any such contract for the city or a government agency, or application for any permit or license. d. Refusal to cooperate with reasonable requests of city inspectors, representatives, or other appropriate city personnel with respect to work under contract provisions, plans, or specifications, or otherwise, pursuant to the duties of that city personnel. e. Founding, establishing or operating an entity in a manner designed to evade the application or defeat the purpose of these rules or any provision of this code, rule or regulation, the statutes, rules or regulations of the State of Illinois, or any federal statute, rule or regulation, or any other legally applicable law, regulation, or rule; f. Improper conduct, including, but not limited to, the commission or attempted commission of: (1) Intentional or negligent billing irregularities; (2) Submitting false or frivolous or exaggerated claims, documents, or records; (3) Falsification of claims, documents, or records; (4) Willful or grossly negligent destruction of documents or records the vendor had an obligation to maintain; (5) Bribery or coercion of a government official, or other unlawful tampering with a government official; (6) Use of false or deceptive statements to obtain some benefit, or causing competition to be restrained or limited; (7) Misrepresentation to any governmental agency or government official; (8) Violation of ethical standards established by the city, or other dishonesty incident to obtaining, prequalifying for, or performing any contract or modification thereof; (9) Failing to pay, after a reasonable period of time, any judgment or other adjudicated debt owed to the city after a request for payment; or (10) Failing to defend, indemnify, or hold harmless the city pursuant to a contractual obligation after having received a request to do so. g. Any other cause of so serious or compelling a nature that it affects the responsibility of the vendor. h. Debarment, disqualification, or suspension by any other government agency for any reason. i. Disqualification or rejection of a bid from a vendor or contractor on three (3) or more occasions within a three (3) year period. 2. Effect of Debarment: a. Notwithstanding the debarment of a contractor, the city may continue contracts or subcontracts in existence at the time the contractor was debarred unless the mayor directs otherwise. b. Debarred contractors are further prohibited from performing work as a contractor, subcontractor or materialman on any tier on city contracts. The city shall not accept or enter into any contract where a debarred contractor is proposed to perform the work. c. The debarment may be canceled prospectively, or the duration and scope may be reduced or waived by the mayor, upon the written application of the debarred individual or entity, supported by documentation, for any of the following reasons: (1) Newly discovered material evidence or documentable error in the findings of the city council's decision. (2) Reversal of the conviction or judgment on which the ineligibility is based on the conviction or judgment was based on an admission of conduct that was a cause for debarment. (3) Bona-fide change in ownership and control of the entity, or other mitigating factors sufficient, in the judgment of the city council, to remove the conditions giving rise to the conduct that led to the ineligibility. 3. Penalties: a. Any vendor obtaining services or hiring a subcontractor on any tier or supplier that has been debarred under this subsubsection may be subject to one or more of the following: (1) Immediate termination of all city contracts without recourse; (2) Placement on the list of debarred vendors for at least five (5) years; (3) Is guilty of a Class IV violation for each day, or part thereof, that the debarred vendor performed work; (4) Reduction of their contract price by an amount equal to the value of the work performed by a debarred vendor; and (5) Any city employee willfully violating this subsection or hiring a debarred vendor shall be subject to disciplinary action, up to and including termination. M. BID PROTESTS: 1. Right to Protest: Any actual or prospective bidder, offeror, or contractor who is aggrieved in connection with the solicitation or award of a contract may protest to the City Administrator. The protest shall be submitted in writing within ten (10) calendar days after such aggrieved person knows or should have known of the facts giving rise thereto. 2. Contract Claims: All claims by a contractor against the city relating to a contract shall be submitted in writing to the City Administrator. The contractor may request a conference with the City Administrator on a submitted claim. Claims include, without limitation, disputes arising under a contract and those based upon breach of contract, mistake, misrepresentation, or other cause for contract modification or rescission. 3. Authority To Resolve Protests And Contract Claims: a. Protests: The City Administrator shall have the authority consistent with this code to settle and resolve a protest of an aggrieved bidder, offeror, or contractor, actual or prospective, concerning the solicitation or award of a contract. b. Contract Claims: The City Administrator, after consulting with the City Attorney, shall have the authority to resolve contract claims, subject to the approval of the City Administrator or City Council, as applicable, regarding any settlement that will result in a change order or contract modification pursuant to Subsection 1-7-3(I) of this code. 4. Decision: If a protest brought pursuant to this Section is not resolved by mutual agreement, the City Administrator shall promptly issue a decision in writing. A copy of the decision shall be mailed or otherwise furnished immediately to the protestant or claimant and any other party intervening. The decision shall state the reasons for the action taken. 5. Finality of Decision: A decision under this Section shall be final and conclusive unless, within ten (10) calendar days from the date of receipt of the decision, the protestant or claimant files a written appeal with the City Administrator. 6. Authority of The City Administrator: The City Administrator shall have the jurisdiction to review and determine any appeal by an aggrieved party from a determination by the City Administrator regarding a protest or contract claim. Such a decision shall be final and conclusive. N. INCONSISTENT STATE LAW: If any provision of this subsection shall conflict with any provision of any statute or public law now or hereafter enacted by the Illinois General Assembly, such statute or public law shall control. 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 Old Business #1 Tracking Number ADM 2020-37 School District – IGA Administration Committee – July 15, 2020 A discussion will take place 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 Old Business #2 Tracking Number ADM 2020-39 Governing Ordinance – Discussion of Review and Changes Administration Committee – July 15, 2020 Bart Olson Administration Name Department Ordinance No. 2020-_____ AN ORDINANCE REGARDING CITY COUNCIL PROCEDURES WHEREAS, the United City of Yorkville (the “City”) is a duly organized and validly existing non-home-rule municipality created in accordance with Article VII, Section 7 of the Constitution of the State of Illinois of 1970; and, WHEREAS, the City Council of the United City of Yorkville first passed a Procedural Ordinance on November 8, 2011 as Ordinance 2011-65, and revised said ordinance on April 24, 2012 as Ordinance 2012-09 and again on October 9, 2012 as Ordinance 2012-33 and again on May 16, 2013 as Ordinance 2013-31; and, WHEREAS, the City Council of the United City of Yorkville, in accordance with the Illinois Compiled State Statutes, has the right to determine procedures for organizing and conducting all meetings of the City Council acknowledging that the City is bound by certain state and federal laws as well as legal precedents which cannot be supplanted by City ordinance; and, WHEREAS, in keeping with this right, the City Council has adopted Roberts Rules of Order to outline the procedure to be followed during meetings and to regulate the actions of Council members and the public in attendance at such meetings; and, WHEREAS, the City Council has discussed implementing additional procedures to supplement Roberts Rules of Order, newly revised regarding City Council meetings and the four standing committees of the City Council – Administration, Economic Development, Public Safety and Public Works. NOW THEREFORE, BE IT ORDAINED by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois, as follows: Section 1. Procedures for City Council Meetings: a. City Council Meetings shall be regularly scheduled to convene on the 2nd and 4th Tuesday of each month at 7:00 p.m. in the City Hall Council Chambers. b. The Mayor, or any 3 Aldermen, may call a special meeting by submitting the request in the form of a Notice, and an Agenda for the meeting to the City Clerk. c. The Council may hold additional meetings or special meetings at other locations and times, or may change the location and time of a regularly scheduled meeting as it deems appropriate. Notice of additional meetings or changes to the location or time of a regularly scheduled meeting will be provided to the public and press as required by the Open Meetings Act 5 ILCS 120 (OMA). d. The Mayor, “Presiding Officer” shall preside over City Council meeting as the Chairman, unless the Mayor is unavailable, at which time the Mayor Pro Tem shall preside. Should both the Mayor and Pro Tem be unavailable, the e. The City Council shall appoint the Mayor Pro Tem at the first City Council meeting each May. The appointment shall occur by calling for open nominations at the meeting, and then a roll call votes on the nominations. f. The City Attorney shall serve as the Parliamentarian for the purposes of interpreting these Meeting Procedure, and the Illinois Compiled Statutes, and Robert’s Rules of Order, as may be directed by the presiding officer, or as required as a result of a point of order raised by one or more Councilmen. g. Citizens in attendance at any meeting of the City Council shall be entitled to address the City Council on any agenda item prior to the Council’s consideration of the Consentactionable items Agenda in order to permit the work of the City Council to proceed. Citizens shall have 5 minutes to address the Council. The aggregate of citizens comments shall not exceed one hour however may be extended by consensus of the City Council. h. Citizens shall be entitled to address the City Council on any matter immediately prior to entering executive session or adjournment. a.i. The Chairman or by consent of two alderman present shall at their discretion allow an individual to be recognized to address the council outside of the regular agenda citizen’s comments. j. No application presented during a public hearing shall be voted on during the same City Council meeting in which that public hearing is held. This provision may be waived by a supermajority (6 out of 9) of the City Councilcorporate authorities. k. No ordinance or resolution shall be voted on at a City Council meeting unless the item to be voted on has been presented in its final form to the Corporate Authorities at the time of packet publication with the exception to scribers errors or City Council amendments made at time of consideration. l. City Council meeting agenda items may be added by the Mayor with consent of respective committee chairman of which the item is relevant, consent of four three (43) aldermen, or direction from a committee. b. The Mayor shall preside over City Council meeting as the Chairman, unless the Mayor is unavailable, at which time the Mayor Pro Tem shall preside. c.m. The City Council shall appoint the Mayor Pro Tem at the first City Council meeting each May. The appointment shall occur by calling for open nominations at the meeting, and then a roll call votes on the nominations.City Council Meetings shall be generally conducted according to the agenda template attached hereto. Section 2. Procedures for Committee Meetings: a. Committee meetings shall be regularly held monthly, at the dates, times and locations as approved by the Committees. b. The Mayor shall be a non-voting member of all standing committees. a.c. The Mayor shall select committee rosters at the first City Council meeting in May following a municipal consolidated election (i.e. every two years). d. Committee rosters may be switched by mutual, unanimous consent of the aldermen trading seats and the Mayor. e. Each committee shall be represented by at least one alderman from each ward. b.f. Committees shall consist of at least 4 aldermen. g. The Mayor shall select committee chairmen. h. and Committees shall select vice-chairmen at the first committee meeting following first City Council meeting in May following a municipal consolidated election (i.e. every two years). i. Any alderman may add any agenda item to any committee agenda. c.j. Chairmen shall select liaisons to other organizations and boards by any means they deem necessary, provided that the other organizations by-laws may govern the selection of the liaison. d.k.The four committees shall be: i. Administration ii. Economic Development iii. Public Safety iv. Public Works l. Committee purview and oversight shall be defined as follows: i. Administration: Shall review all Bills for Payment, Cash Statements, Budget Reports & review, Budget Amendments, Treasurer’s Report, Sales Tax Analysis, RFPs & RFQs, all City contracts, convention and visitor’s bureau matters, insurance, Website Reports and other administration related proposals and tasks. ii. Economic Development: Shall review all monthly Building Permit Reports, Building Inspection Reports, Property Maintenance Reports, Economic Development Reports and economic development related plans, proposals and tasks. iii. Public Safety: Adjudication Reports, Police Reports, relevant Licensing Requirements, Liquor Code considerations, Police Department Staffing, motor vehicle issues, traffic safety, and other public safety related proposals and tasks. iv. Public Works: Bond and Letter of Credit Reduction Summaries, Capital Improvement projects and updates, water reports, snow operations reports, vehicles updates, MFT projects, roads, walks and trails; storm and sanitary sewers, water infrastructure, and other pertinent public works related proposals and tasks. m. Each committee shall be presided over by its chairman, or in the absence of the chairman, the vice-chairman. n. Committee meetings may be cancelled by the Chairman of the committee if there is a not a quorum of the members present, or there are no agenda items which require action by a committee. o. When moving items from the committee agenda to a City Council agenda, the committee shall make a recommendation whether that item should be on consent agenda or the committee’s report. If on the committee’s report, the committee shall make a recommendation whether the item is up for first reading, or is on the City Council agenda for action or placed on consent agenda. No item shall move out of committee without a positive recommendation. This shall in no way preclude alderman from using Section 1.d. to add an item to the City Council agenda report. p. If a committee meeting is cancelled, all standing monthly reports shall be placed on the City Council agenda report for review and vote for approval if required. Section 3. This Ordinance shall be in full force and effect upon its passage, approval, and publication as provided by law. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this _______ Day of ____________________, A.D. 20132020. ______________________________ CITY CLERK DANIEL TRANSIER ________ KEN KOCH ________ JACKIE MILSCHEWSKI ________ JOE PLOCHER ________ CHRIS FUNKHOUSER ________ JOEL FRIEDERS ________ JASON PETERSON ________ SEAVER TARULIS ________ Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this ________ Day of ____________________, A.D. 20132020. ______________________________ MAYOR