Loading...
Administration Committee Packet 2019 09-18-19 AGENDA ADMINISTRATION COMMITTEE MEETING Wednesday, September 18, 2019 6:00 p.m. City Hall Conference Room 800 Game Farm Road, Yorkville, IL Citizen Comments: Minutes for Correction/Approval: August 21, 2019 New Business: 1. ADM 2019-49 Monthly Budget Report for August 2019 2. ADM 2019-50 Monthly Treasurer’s Report for August 2019 3. ADM 2019-51 Cash Statement for July 2019 4. ADM 2019-52 Monthly Website Report for August 2019 5. ADM 2019-53 Quarterly Vehicle Replacement Chart Old Business: 1. ADM 2019-32 Nepotism Policy 2. ADM 2019-35 Facilities Master Plan RFQ 3. ADM 2019-45 Website Redesign Update 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, September 18, 2019 6:00 PM CITY HALL CONFERENCE ROOM --------------------------------------------------------------------------------------------------------------------------------------- CITIZEN COMMENTS: --------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------- MINUTES FOR CORRECTION/APPROVAL: --------------------------------------------------------------------------------------------------------------------------------------- 1. August 21, 2019 □ Approved __________ □ As presented □ With corrections --------------------------------------------------------------------------------------------------------------------------------------- NEW BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2019-49 Monthly Budget Report for August 2019 □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2019-50 Monthly Treasurer’s Report for August 2019 □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 3. ADM 2019-51 Cash Statement for July 2019 □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 4. ADM 2019-52 Monthly Website Report for August 2019 □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 5. ADM 2019-53 Quarterly Vehicle Replacement Chart □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- OLD BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2019-32 Nepotism Policy □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2019-35 Facilities Master Plan RFQ □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 3. ADM 2019-45 Website Redesign Update □ 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 – August 21, 2019 Administration Committee – September 18, 2019 Majority Committee Approval Minute Taker Name Department Page 1 of 4 DRAFT UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE MEETING Wednesday, August 21, 2019 6:00pm City Hall Conference Room Committee Members In Attendance: Chairman Chris Funkhouser Alderman Joe Plocher Alderman Daniel Transier Alderman Jason Peterson Other City Officials In Attendance: Assistant City Administrator Erin Willrett City Finance Director Rob Fredrickson Others in Attendance: None The meeting was called to order at 6:01pm by Chairman Chris Funkhouser. Citizen Comments: None Minutes for Correction/Approval: June 19, 2019 The minutes were approved as presented. New Business: 1. ADM 2019-36 Monthly Budget Report for June and July 2019 Mr. Fredrickson said all tax categories were up for both months and he gave specific figures for all. Two $400,000 OSLAD grants are also expected from the state. This report is for information. 2. ADM 2019-37 Monthly Treasurer's Report for June and July 2019 Finance Director Fredrickson reported the following revenues and this report moves to City Council: 3. ADM 2019-38 Cash Statement for May and June 2019 This report is for information. June 2019 July 2019 Beg. Fund Balance $13,124,363 YTD Revenues $7,402,937 $8,936,650 YTD Expenses $4,304,859 $6,500,584 Proj. End Fund Bal. $15,560,429 Page 2 of 4 4. ADM 2019-39 Monthly Website Report for June and July 2019 Ms. Willrett said the social media followers are growing with a large uptick in August due to a Make-A-Wish post. The re-design process is in motion and will be discussed later in the meeting. Alderman Peterson asked if baseball statistics are available and Ms. Willrett said they were in the top 5 most viewed. 5. ADM 2019-40 4th Quarter Budget Review for Fiscal Year 2019 Mr. Fredrickson presented some of the highlights of the report including sales tax receipts. Overall, the city exceeded the budgeted sales tax amount by $60,000. He also reported on non-home rules taxes, gaming taxes which showed notable increases and holiday receipts. Taxes from on-line sales were 22% higher than FY2018. Mr. Fredrickson said on-line sales tax will rise, local use tax may plateau and that the state is restructuring so that the city will receive non-home rule tax as well. He also reported on revenue from building permits. Regarding expenditures, most departments stayed under budget. Community Development was over due to inspections as a result of robust building. He cited various dollar figures and percentages regarding the various funds. This report is informational. 6. ADM 2019-41 Fiscal Year End 2019 Budget Report (Unaudited) The auditors were at the city last week and no changes are expected to the numbers provided in this report. The final report will be given in October. This is informational. 7. ADM 2019-42 Budget Amendment Ordinance for Fox Hill SSA All city operating funds are under budget with the exception of the Fox Hill SSA which was over budget by $618. The budget will be amended to avoid an audit comment and this moves to the City Council. 8. ADM 2019-43 Illinois Trust – Investment Options Mr. Fredrickson said Illinois Trust is an investment option managed by PFM Asset Management LLC. Illinois Trust is a local government investment pool and has a AAA rating. By joining, it would allow the city another access to brokered CD's which are FDIC-insured up to $250,000. He suggested keeping a nominal amount in cash and said investment earnings are becoming more relevant. The committee was agreeable to this suggestion and thanked Mr. Fredrickson for judicious investments. This moves to City Council. 9. ADM 2019-44 PMA I-Prime PMA is also being used by the city for CD's and for collateralized accounts. A change will occur in how money is moved in and out of the account and the city will need to upgrade to PMA's system. BMO Harris is now used for moving money and the change would use I-Prime (investment pool used by PMA) to move the money. Mr. Fredrickson said he would still like to keep the accounts fully collateralized and they are insured by United States Government securities. He said I-Prime is AAA rated. This moves to the City Council. Page 3 of 4 10. ADM 2019-45 Website Redesign Update Ms. Willrett said Civic Plus has been the city's website provider since 2014 and the city is eligible for a redesign every 48 months. The website will be more user friendly and ADA compliant with a December target completion date expected. There was brief discussion about the colors from the downtown rebranding being used. This will be brought back to the next Administration meeting. 11. ADM 2019-46 2019 City Survey Following Council approval, the city will be kicking off a resident survey by the end of October. Each resident/household will receive the survey in their utility bill and have a unique number. Renters will also receive surveys and social media will be used. The questions will be similar to the last survey with a few updates and a comment area. The last survey was in 2017/2018. The committee discussed ways to encourage residents to fill out the survey and they suggested raffles and gift certificates from businesses. Staff will look at this idea. This will go to the next City Council meeting for approval. 12. ADM 2019-47 Travel/Meal Policy This was last discussed in 2017 after a new state policy was put in place that mandated upfront approval for travel, etc. To update the process further, staff considered per diem rates which would reduce the amount of time spent and allow for revising per diem rates depending on travel location. This moves to City Council with committee approval. 13. ADM 2019-48 Clerk/Treasurer Stipend These are no longer elected positions and staff proposed a $2,000 stipend for both positions effective May 1, 2020. This goes to City Council. Old Business: 1. ADM 2019-32 Nepotism Policy This policy was revised regarding policy exceptions and approved June 25th by City Council. The wording “case by case basis” was added. Staff has since looked at other communities for any differences between part-time and full-time employees with none found that were less restrictive. Chairman Funkhouser asked if the policy could reference the number of hours worked by an employee. He cited a recent case where an Alderman's relative wished to teach a class, but someone other than the relative was chosen to teach the class due to the policy. He asked that the language be examined to allow for more flexibility for the part-time classes. This will come back in September. 2. ADM 2019-34 Solicitor Registration and Regulations This item was discussed at the last Administration meeting and additional language and badge samples were requested. Alderman Funkhouser noted that after the recent windstorm, there were many unregistered solicitiors. He said the city needs to be strict with the company as well as the solicitors. Ms. Willrett said the solicitation times were updated to read 8am to 7pm as well as revisions in the background check language. There was brief discussion of age restrictions and high school students soliciting for school activities. The committee decided on badge example #3b, bright yellow, include city logo, name and company name in large print and the permit must be visible at all times. The revisions will move forward to City Council. Page 4 of 4 3. ADM 2019-35 Facilities Master Plan RFQ This item was also discussed at the June meeting. Chairman Funkhouser noted that the master plan is high on the city goal list, however, due to elections this year the study was put on hold. There is money budgeted for this and interviews had been conducted with some firms, but no one was selected. He said the Mayor feels the money could be spent elsewhere and that the department heads could do this study. Mr. Funkhouser feels it is not the best use of department heads' time and that most city buildings have needs. The facilities master plan and another item have now been deferred due to an unexpected expense for Public Works. The committee said they will move this forward to the City Council and work with the Mayor in further discussions. Alderman Plocher suggested delaying this discussion to allow the Mayor time to first complete meetings with all department heads. This will come back to committee on September 18th and then move to the September 24th Council meeting. Additional Business: None There was no further business and the meeting adjourned at 6:56pm. Respectfully transcribed by Marlys Young, Minute Taker Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #1 Tracking Number ADM 2019-49 Monthly Budget Report for August 2019 Administration Committee – September 18, 2019 Informational None Monthly budget report and income statement. Rob Fredrickson Finance Name Department % of Fiscal Year 8% 17% 25% 33%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 June-19 July-19 August-19 Totals BUDGET % of Budget GENERAL FUND REVENUES Taxes 01-000-40-00-4000 PROPERTY TAXES 175,386 902,168 37,170 76,386 1,191,110 2,119,323 56.20% 01-000-40-00-4010 PROPERTY TAXES-POLICE PENSION 91,517 470,757 19,396 39,858 621,528 1,105,927 56.20% 01-000-40-00-4030 MUNICIPAL SALES TAX 211,897 254,112 259,358 286,263 1,011,630 3,151,800 32.10% 01-000-40-00-4035 NON-HOME RULE SALES TAX 157,270 190,346 197,361 219,798 764,776 2,432,700 31.44% 01-000-40-00-4040 ELECTRIC UTILITY TAX - 158,190 - - 158,190 710,000 22.28% 01-000-40-00-4041 NATURAL GAS UTILITY TAX 24,573 17,974 12,690 11,782 67,020 250,000 26.81% 01-000-40-00-4043 EXCISE TAX 32,276 24,012 23,137 19,316 98,740 313,625 31.48% 01-000-40-00-4044 TELEPHONE UTILITY TAX 695 695 695 695 2,780 8,340 33.33% 01-000-40-00-4045 CABLE FRANCHISE FEES 63,971 - 11,482 64,747 140,199 290,000 48.34% 01-000-40-00-4050 HOTEL TAX 1,549 11,536 8,915 8,921 30,920 80,000 38.65% 01-000-40-00-4055 VIDEO GAMING TAX 14,990 12,175 12,553 11,174 50,891 140,000 36.35% 01-000-40-00-4060 AMUSEMENT TAX 4,592 3,970 46,423 70,253 125,238 205,000 61.09% 01-000-40-00-4065 ADMISSIONS TAX - - - - - 140,000 0.00% 01-000-40-00-4070 BDD TAX - KENDALL MARKETPLACE 13,637 27,998 28,219 30,088 99,943 382,500 26.13% 01-000-40-00-4071 BDD TAX - DOWNTOWN 15,863 3,411 - 25 19,299 35,000 55.14% 01-000-40-00-4072 BDD TAX - COUNTRYSIDE 562 974 1,046 902 3,484 10,000 34.84% 01-000-40-00-4075 AUTO RENTAL TAX - 2,462 1,422 1,307 5,191 14,500 35.80% Intergovernmental 01-000-41-00-4100 STATE INCOME TAX 381,988 119,293 178,400 127,883 807,564 1,916,366 42.14% 01-000-41-00-4105 LOCAL USE TAX 45,940 52,226 49,432 49,646 197,243 602,966 32.71% 01-000-41-00-4110 ROAD & BRIDGE TAX 10,903 56,778 2,155 4,298 74,133 130,000 57.03% 01-000-41-00-4120 PERSONAL PROPERTY TAX 4,406 - 2,602 312 7,320 17,000 43.06% 01-000-41-00-4160 FEDERAL GRANTS - 266 - 1,223 1,489 15,000 9.93% 01-000-41-00-4168 STATE GRANT - TRF SIGNAL MAINT - - - - - 21,000 0.00% 01-000-41-00-4182 MISC INTERGOVERNMENTAL - - - 1,861 1,861 900 206.72% Licenses & Permits 01-000-42-00-4200 LIQUOR LICENSES 450 1,611 4,725 1,277 8,062 56,000 14.40% 01-000-42-00-4205 OTHER LICENSES & PERMITS 1,777 1,474 10 105 3,366 7,500 44.88% 01-000-42-00-4210 BUILDING PERMITS 46,319 35,573 54,939 40,056 176,886 350,000 50.54% Fines & Forfeits 01-000-43-00-4310 CIRCUIT COURT FINES 2,839 4,464 3,729 2,869 13,901 45,000 30.89% 01-000-43-00-4320 ADMINISTRATIVE ADJUDICATION 1,471 2,283 2,514 2,117 8,385 30,000 27.95% 01-000-43-00-4323 OFFENDER REGISTRATION FEES 35 25 - 35 95 400 23.75% 01-000-43-00-4325 POLICE TOWS 2,500 2,000 4,500 2,500 11,500 50,000 23.00% Charges for Service 01-000-44-00-4400 GARBAGE SURCHARGE 873 209,119 632 209,561 420,185 1,224,875 34.30% 01-000-44-00-4405 UB COLLECTION FEES 16,638 12,183 323 15,343 44,487 165,000 26.96% 01-000-44-00-4407 LATE PENALTIES - GARBAGE 2 3,833 35 3,673 7,543 21,000 35.92% 01-000-44-00-4415 ADMINISTRATIVE CHARGEBACK 17,070 17,070 17,070 17,070 68,279 204,836 33.33% 01-000-44-00-4474 POLICE SPECIAL DETAIL - - - 900 900 500 180.00% Investment Earnings 01-000-45-00-4500 INVESTMENT EARNINGS 11,033 10,274 11,953 12,134 45,393 80,000 56.74% Reimbursements 01-000-46-00-4604 REIMB - ENGINEERING EXPENSES - - - - - 25,000 0.00% 01-000-46-00-4680 REIMB - LIABILITY INSURANCE - - - 3,852 3,852 10,000 38.52% 01-000-46-00-4685 REIMB - CABLE CONSORTIUM - 12,052 - - 12,052 35,000 34.43% 01-000-46-00-4690 REIMB - MISCELLANEOUS 5,133 257 708 504 6,601 5,000 132.02% Miscellaneous 01-000-48-00-4820 RENTAL INCOME 500 680 455 780 2,415 7,000 34.50% 01-000-48-00-4850 MISCELLANEOUS INCOME - 18,210 0 (50) 18,160 13,000 139.69% Other Financing Uses 01-000-49-00-4916 TRANSFER FROM CW MUNICIPAL BLDG - - - - - 47,180 0.00% TOTAL REVENUES: GENERAL FUND 1,358,656 2,640,449 994,046 1,339,463 6,332,613 16,469,238 38.45% UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended August 31, 2019 1 % of Fiscal Year 8% 17% 25% 33%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 June-19 July-19 August-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended August 31, 2019 ADMINISTRATION EXPENDITURES Salaries & Wages 01-110-50-00-5001 SALARIES - MAYOR 725 563 825 825 2,938 11,000 26.71% 01-110-50-00-5002 SALARIES - LIQUOR COMM 83 48 83 83 298 1,000 29.84% 01-110-50-00-5003 SALARIES - CITY CLERK 500 100 - - 600 - 0.00% 01-110-50-00-5005 SALARIES - ALDERMAN 4,000 3,674 3,800 3,700 15,174 50,000 30.35% 01-110-50-00-5010 SALARIES - ADMINISTRATION 61,298 40,270 39,479 39,479 180,526 538,095 33.55% Benefits 01-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION 5,560 3,655 3,584 3,584 16,383 49,367 33.19% 01-110-52-00-5214 FICA CONTRIBUTION 4,959 3,297 3,261 3,253 14,771 41,686 35.43% 01-110-52-00-5216 GROUP HEALTH INSURANCE 20,352 11,060 8,186 8,941 48,539 120,064 40.43% 01-110-52-00-5222 GROUP LIFE INSURANCE 43 29 36 36 143 428 33.34% 01-110-52-00-5223 GROUP DENTAL INSURANCE 1,309 654 654 654 3,272 7,853 41.67% 01-110-52-00-5224 VISION INSURANCE 188 94 94 94 471 1,130 41.66% Contractual Services 01-110-54-00-5412 TRAINING & CONFERENCES 934 1,782 75 2,099 4,890 17,000 28.77% 01-110-54-00-5415 TRAVEL & LODGING 1,671 97 58 4,370 6,196 10,000 61.96% 01-110-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - - - 1,655 0.00% 01-110-54-00-5426 PUBLISHING & ADVERTISING - - - - - 5,000 0.00% 01-110-54-00-5430 PRINTING & DUPLICATION - 167 124 109 400 3,250 12.31% 01-110-54-00-5440 TELECOMMUNICATIONS 471 1,036 1,485 1,582 4,574 19,000 24.07% 01-110-54-00-5448 FILING FEES - - - - - 500 0.00% 01-110-54-00-5451 CODIFICATION - - - - - 5,000 0.00% 01-110-54-00-5452 POSTAGE & SHIPPING 57 87 98 78 320 3,000 10.68% 01-110-54-00-5460 DUES & SUBSCRIPTIONS 8,778 358 - 1,739 10,874 20,000 54.37% 01-110-54-00-5462 PROFESSIONAL SERVICES 100 201 685 714 1,700 12,000 14.17% 01-110-54-00-5480 UTILITIES - 517 1,925 2,420 4,862 20,787 23.39% 01-110-54-00-5485 RENTAL & LEASE PURCHASE 113 112 226 113 565 3,000 18.83% 01-110-54-00-5488 OFFICE CLEANING - 1,005 1,005 1,005 3,015 11,757 25.64% Supplies 01-110-56-00-5610 OFFICE SUPPLIES 140 1,118 447 359 2,064 10,000 20.64% TOTAL EXPENDITURES: ADMINISTRATION 111,281 69,926 66,132 75,236 322,574 962,572 33.51% FINANCE EXPENDITURES Salaries & Wages 01-120-50-00-5010 SALARIES & WAGES 31,356 26,476 21,731 21,907 101,470 301,372 33.67% Benefits 01-120-52-00-5212 RETIREMENT PLAN CONTRIBUTION 2,854 2,412 1,982 1,998 9,248 27,649 33.45% 01-120-52-00-5214 FICA CONTRIBUTION 2,353 1,984 1,621 1,635 7,594 21,574 35.20% 01-120-52-00-5216 GROUP HEALTH INSURANCE 8,601 3,777 4,195 4,064 20,638 64,351 32.07% 01-120-52-00-5222 GROUP LIFE INSURANCE 20 20 20 20 82 246 33.32% 01-120-52-00-5223 DENTAL INSURANCE 865 433 433 433 2,163 5,192 41.67% 01-120-52-00-5224 VISION INSURANCE 118 59 59 59 295 707 41.69% Contractual Services 01-120-54-00-5412 TRAINING & CONFERENCES 507 15 - - 522 3,500 14.91% 01-120-54-00-5414 AUDITING SERVICES - - - - - 34,100 0.00% 01-120-54-00-5415 TRAVEL & LODGING 83 32 - 26 141 1,000 14.13% 01-120-54-00-5430 PRINTING & DUPLICATING 76 56 502 36 670 3,500 19.13% 01-120-54-00-5440 TELECOMMUNICATIONS - 68 68 68 203 1,250 16.20% 01-120-54-00-5452 POSTAGE & SHIPPING 93 68 5 166 332 1,200 27.66% 01-120-54-00-5460 DUES & SUBSCRIPTIONS 90 272 - 289 651 1,500 43.40% 01-120-54-00-5462 PROFESSIONAL SERVICES 1,696 1,689 1,884 2,509 7,778 60,000 12.96% 01-120-54-00-5485 RENTAL & LEASE PURCHASE 150 37 113 150 450 2,200 20.46% Supplies 01-120-56-00-5610 OFFICE SUPPLIES - 47 - - 47 2,500 1.88% TOTAL EXPENDITURES: FINANCE 48,863 37,446 32,614 33,360 152,283 531,841 28.63% 2 % of Fiscal Year 8% 17% 25% 33%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 June-19 July-19 August-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended August 31, 2019 POLICE EXPENDITURES Salaries & Wages 01-210-50-00-5008 SALARIES - POLICE OFFICERS 197,516 154,254 163,080 128,295 643,145 1,924,224 33.42% 01-210-50-00-5011 SALARIES - POLICE CHIEF & DEPUTIES 49,255 31,564 28,803 30,553 140,175 396,159 35.38% 01-210-50-00-5012 SALARIES - SERGEANTS 59,662 43,434 39,050 40,888 183,034 644,811 28.39% 01-210-50-00-5013 SALARIES - POLICE CLERKS 18,878 12,846 12,846 12,913 57,483 175,554 32.74% 01-210-50-00-5014 SALARIES - CROSSING GUARD 4,892 508 - 626 6,026 27,500 21.91% 01-210-50-00-5015 PART-TIME SALARIES 6,741 5,188 4,333 4,946 21,207 70,000 30.30% 01-210-50-00-5020 OVERTIME 10,944 10,963 19,011 10,081 50,998 111,000 45.94% Benefits 01-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,710 1,164 1,164 1,170 5,208 16,106 32.34% 01-210-52-00-5213 EMPLOYER CONTRI - POL PEN 91,517 470,757 19,396 39,858 621,528 1,111,484 55.92% 01-210-52-00-5214 FICA CONTRIBUTION 25,763 18,985 19,651 16,761 81,160 245,951 33.00% 01-210-52-00-5216 GROUP HEALTH INSURANCE 105,320 47,144 55,304 45,265 253,033 741,025 34.15% 01-210-52-00-5222 GROUP LIFE INSURANCE 202 246 209 207 864 2,748 31.43% 01-210-52-00-5223 DENTAL INSURANCE 7,452 3,365 4,033 3,264 18,115 50,770 35.68% 01-210-52-00-5224 VISION INSURANCE 1,042 472 581 465 2,561 7,080 36.17% Contractual Services 01-210-54-00-5410 TUITION REIMBURSEMENT - 1,206 - - 1,206 17,272 6.98% 01-210-54-00-5411 POLICE COMMISSION 405 1,185 406 - 1,996 4,000 49.90% 01-210-54-00-5412 TRAINING & CONFERENCES 249 1,420 1,239 1,645 4,553 21,000 21.68% 01-210-54-00-5415 TRAVEL & LODGING - 57 - - 57 10,000 0.57% 01-210-54-00-5422 VEHICLE & EQUIPMENT CHARGEBACK 2,003 2,003 2,003 2,003 8,011 24,032 33.33% 01-210-54-00-5434 COMPUTER REPLACEMENT CHARGEBACK - - - - - 4,301 0.00% 01-210-54-00-5430 PRINTING & DUPLICATING - 465 1,928 532 2,926 4,500 65.02% 01-210-54-00-5440 TELECOMMUNICATIONS - 2,062 3,711 3,829 9,602 40,000 24.01% 01-210-54-00-5452 POSTAGE & SHIPPING 46 76 57 114 292 1,600 18.27% 01-210-54-00-5460 DUES & SUBSCRIPTIONS 8,278 615 - 340 9,233 9,000 102.59% 01-210-54-00-5462 PROFESSIONAL SERVICES 14,562 - 652 376 15,590 30,000 51.97% 01-210-54-00-5467 ADJUDICATION SERVICES - 5,610 322 1,951 7,883 20,000 39.42% 01-210-54-00-5469 NEW WORLD LIVE SCAN - - - - - 2,000 0.00% 01-210-54-00-5472 KENDALL CO. JUVE PROBATION - - - - - 4,000 0.00% 01-210-54-00-5485 RENTAL & LEASE PURCHASE 299 207 506 394 1,407 7,150 19.68% 01-210-54-00-5488 OFFICE CLEANING - 1,005 1,005 1,005 3,015 11,758 25.64% 01-210-54-00-5495 OUTSIDE REPAIR & MAINTENANCE 1,931 3,675 4,063 4,484 14,154 60,000 23.59% Supplies 01-210-56-00-5600 WEARING APPAREL 2,128 4,041 6,086 1,717 13,971 15,000 93.14% 01-210-56-00-5610 OFFICE SUPPLIES - 127 203 35 365 4,500 8.11% 01-210-56-00-5620 OPERATING SUPPLIES 40 537 906 477 1,960 16,000 12.25% 01-210-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE 3,441 - 105 - 3,546 12,500 28.37% 01-210-56-00-5650 COMMUNITY SERVICES - - 1,310 - 1,310 1,500 87.33% 01-210-56-00-5690 BALLISTIC VESTS - - - 2,103 2,103 6,000 35.06% 01-210-56-00-5695 GASOLINE - 34 3,975 5,820 9,829 63,000 15.60% 01-210-56-00-5696 AMMUNITION - - - - - 10,000 0.00% TOTAL EXPENDITURES: POLICE 614,277 825,216 395,936 362,118 2,197,546 5,923,525 37.10% COMMUNITY DEVELOPMENT EXPENDITURES Salaries & Wages 01-220-50-00-5010 SALARIES & WAGES 57,405 41,735 38,102 38,102 175,343 520,619 33.68% Benefits 01-220-52-00-5212 RETIREMENT PLAN CONTRIBUTION 5,228 3,808 3,479 3,479 15,995 47,763 33.49% 01-220-52-00-5214 FICA CONTRIBUTION 4,288 3,095 2,817 2,817 13,018 38,317 33.97% 01-220-52-00-5216 GROUP HEALTH INSURANCE 14,880 7,126 7,475 7,903 37,384 90,471 41.32% 01-220-52-00-5222 GROUP LIFE INSURANCE 36 56 21 37 150 429 35.02% 01-220-52-00-5223 DENTAL INSURANCE 1,175 588 588 588 2,938 6,603 44.50% 01-220-52-00-5224 VISION INSURANCE 180 90 90 90 450 1,009 44.63% 3 % of Fiscal Year 8% 17% 25% 33%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 June-19 July-19 August-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended August 31, 2019 Contractual Services 01-220-54-00-5412 TRAINING & CONFERENCES 350 410 - - 760 7,300 10.41% 01-220-54-00-5415 TRAVEL & LODGING - - - 35 35 6,500 0.54% 01-220-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - - - 1,323 0.00% 01-220-54-00-5426 PUBLISHING & ADVERTISING - - 691 161 853 2,500 34.11% 01-220-54-00-5430 PRINTING & DUPLICATING - 121 128 117 366 1,500 24.41% 01-220-54-00-5440 TELECOMMUNICATIONS - 79 263 358 700 4,000 17.50% 01-220-54-00-5452 POSTAGE & SHIPPING 53 28 33 55 168 1,000 16.83% 01-220-54-00-5459 INSPECTIONS - - 3,610 10,500 14,110 125,000 11.29% 01-220-54-00-5460 DUES & SUBSCRIPTIONS 1,089 188 53 526 1,856 2,750 67.50% 01-220-54-00-5462 PROFESSIONAL SERVICES - 21 12,740 167 12,928 62,500 20.68% 01-220-54-00-5485 RENTAL & LEASE PURCHASE 189 - 189 189 567 3,150 18.01% Supplies 01-220-56-00-5610 OFFICE SUPPLIES - 46 24 112 182 1,500 12.14% 01-220-56-00-5620 OPERATING SUPPLIES - 653 1,024 - 1,676 3,750 44.71% 01-220-56-00-5695 GASOLINE - 380 308 523 1,211 2,405 50.36% TOTAL EXPENDITURES: COMMUNITY DEVELP 84,873 58,422 71,636 65,760 280,692 930,389 30.17% PUBLIC WORKS - STREET OPERATIONS EXPENDITURES Salaries & Wages 01-410-50-00-5010 SALARIES & WAGES 39,406 27,822 25,953 26,066 119,248 402,421 29.63% 01-410-50-00-5015 PART-TIME SALARIES 240 1,995 2,880 2,000 7,115 12,500 56.92% 01-410-50-00-5020 OVERTIME - 819 - - 819 20,000 4.09% Benefits 01-410-52-00-5212 RETIREMENT PLAN CONTRIBUTION 3,570 2,595 2,351 2,362 10,878 38,754 28.07% 01-410-52-00-5214 FICA CONTRIBUTION 2,917 2,236 2,099 2,040 9,292 31,902 29.13% 01-410-52-00-5216 GROUP HEALTH INSURANCE 14,862 8,341 7,637 8,895 39,734 114,394 34.73% 01-410-52-00-5222 GROUP LIFE INSURANCE 25 30 30 30 113 437 25.96% 01-410-52-00-5223 DENTAL INSURANCE 1,003 539 539 539 2,619 7,363 35.57% 01-410-52-00-5224 VISION INSURNCE 140 76 76 76 368 1,065 34.54% Contractual Services 01-410-54-00-5412 TRAINING & CONFERENCES 2,147 276 - - 2,423 3,000 80.77% 01-410-54-00-5415 TRAVEL & LODGING - 127 - - 127 2,000 6.37% 01-410-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - - - 2,500 0.00% 01-410-54-00-5435 TRAFFIC SIGNAL MAINTENANCE - - 8,407 7,242 15,649 30,000 52.16% 01-410-54-00-5440 TELECOMMUNICATIONS - 54 258 274 586 3,750 15.62% 01-410-54-00-5455 MOSQUITO CONTROL - 274 - - 274 6,281 4.36% 01-410-54-00-5458 TREE & STUMP MAINTENANCE - - - - - 15,000 0.00% 01-410-54-00-5462 PROFESSIONAL SERVICES - 1 100 411 513 6,825 7.52% 01-410-54-00-5483 JULIE SERVICES - - - 1,448 1,448 3,000 48.25% 01-410-54-00-5485 RENTAL & LEASE PURCHASE 675 77 171 200 1,124 6,000 18.73% 01-410-54-00-5488 OFFICE CLEANING - 65 65 65 195 1,051 18.55% 01-410-54-00-5490 VEHICLE MAINTENANCE SERVICES 45 7,095 3,282 576 10,998 65,000 16.92% Supplies 01-410-56-00-5600 WEARING APPAREL - - - 231 231 5,100 4.53% 01-410-56-00-5618 SALT & CALCIUM CHLORIDE - - - - - 157,500 0.00% 01-410-56-00-5620 OPERATING SUPPLIES 151 58 89 390 688 23,000 2.99% 01-410-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - 2,241 1,354 1,413 5,008 30,000 16.69% 01-410-56-00-5630 SMALL TOOLS & EQUIPMENT - - 625 278 903 18,500 4.88% 01-410-56-00-5640 REPAIR & MAINTENANCE 129 - 713 3,195 4,037 25,000 16.15% 01-410-56-00-5642 STREET LIGHTING SUPLIES - 582 941 3,163 4,686 17,000 27.57% 01-410-56-00-5665 JULIE SUPPLIES - - - - - 1,200 0.00% 01-410-56-00-5695 GASOLINE 91 1,322 1,691 1,622 4,726 24,043 19.66% TOTAL EXP: PUBLIC WORKS - STREET OPS 65,400 56,627 59,260 62,514 243,801 1,074,586 22.69% 4 % of Fiscal Year 8% 17% 25% 33%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 June-19 July-19 August-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended August 31, 2019 PW - HEALTH & SANITATION EXPENDITURES Contractual Services 01-540-54-00-5441 GARBAGE SRVCS - SR SUBSIDY - - 2,884 2,875 5,759 34,081 16.90% 01-540-54-00-5442 GARBAGE SERVICES - - 101,576 102,342 203,918 1,200,294 16.99% 01-540-54-00-5443 LEAF PICKUP - - 600 - 600 7,000 8.57% TOTAL EXPENDITURES: HEALTH & SANITATION - - 105,060 105,217 210,277 1,241,375 16.94% ADMINISTRATIVE SERVICES EXPENDITURES Salaries & Wages 01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES - - - 900 900 500 180.00% Benefits 01-640-52-00-5230 UNEMPLOYMENT INSURANCE 2,766 - 2,766 - 5,532 15,000 36.88% 01-640-52-00-5231 LIABILITY INSURANCE 69,817 24,635 26,085 23,585 144,121 316,374 45.55% 01-640-52-00-5240 RETIREES - GROUP HEALTH INS 9,032 5,230 8 1,690 15,961 47,796 33.39% 01-640-52-00-5241 RETIREES - DENTAL INSURANCE 1,210 187 187 (112) 1,472 449 327.90% 01-640-52-00-5242 RETIREES - VISION INSURANCE 213 18 32 (19) 244 80 305.10% Contractual Services 01-640-54-00-5418 PURCHASING SERVICES - - - - - 50,465 0.00% 01-640-54-00-5423 IDOR ADMINISTRATION FEE 3,113 3,652 3,672 4,023 14,460 44,689 32.36% 01-640-54-00-5427 GC HOUSING RENTAL ASSISTANCE 1,268 634 634 634 3,170 7,800 40.64% 01-640-54-00-5428 UTILITY TAX REBATE - - - 4,430 4,430 14,375 30.82% 01-640-54-00-5432 FACILITY MANAGEMENT SERVICES - - - - - 57,425 0.00% 01-640-54-00-5439 AMUSEMENT TAX REBATE - 3,970 4,604 - 8,574 60,000 14.29% 01-640-54-00-5449 KENCOM 11,653 1,146 1,146 1,146 15,090 126,109 11.97% 01-640-54-00-5450 INFORMATION TECH SRVCS 16,651 14,320 19,336 31,810 82,118 225,000 36.50% 01-640-54-00-5456 CORPORATE COUNSEL - 8,744 4,730 6,499 19,972 115,000 17.37% 01-640-54-00-5461 LITIGATION COUNSEL - - 6,699 8,069 14,768 120,000 12.31% 01-640-54-00-5462 PROFESSIONAL SERVICES 523 3,500 - - 4,023 27,000 14.90% 01-640-54-00-5463 SPECIAL COUNSEL - - 13,858 - 13,858 25,000 55.43% 01-640-54-00-5465 ENGINEERING SERVICES - - 22,124 28,518 50,642 390,000 12.99% 01-640-54-00-5473 KENDALL AREA TRANSIT - - - - - 25,000 0.00% 01-640-54-00-5475 CABLE CONSORTIUM FEE - - - - - 96,000 0.00% 01-640-54-00-5481 HOTEL TAX REBATES - 29 7,128 8,023 15,180 72,000 21.08% 01-640-54-00-5486 ECONOMIC DEVELOPMENT 1,370 9,425 15,950 9,425 36,170 146,000 24.77% 01-640-54-00-5491 CITY PROPERTY TAX REBATE - - - - - 1,500 0.00% 01-640-54-00-5492 SALES TAX REBATES - - - - - 912,900 0.00% 01-640-54-00-5493 BUSINESS DISTRICT REBATES 29,461 31,735 28,680 30,395 120,270 421,088 28.56% 01-640-54-00-5494 ADMISSIONS TAX REBATE - - - - - 140,000 0.00% 01-640-54-00-5499 BAD DEBT - - - - - 2,000 0.00% Supplies 01-640-56-00-5625 REIMBURSEABLE REPAIRS - - - - - 15,000 0.00% Other Financing Uses 01-640-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL - - - - - 250,000 0.00% 01-640-99-00-9942 TRANSFER TO DEBT SERVICE 26,615 26,615 26,615 26,615 106,460 319,379 33.33% 01-640-99-00-9952 TRANSFER TO SEWER 47,919 47,919 47,919 47,919 191,677 575,030 33.33% 01-640-99-00-9979 TRANSFER TO PARKS & RECREATION 117,582 117,582 117,582 117,582 470,329 1,410,988 33.33% 01-640-99-00-9982 TRANSFER TO LIBRARY OPS 5,588 1,830 2,002 1,830 11,249 25,003 44.99% TOTAL EXPENDITURES: ADMIN SERVICES 344,782 301,171 351,756 352,961 1,350,671 6,054,950 22.31% TOTAL FUND REVENUES 1,358,656 2,640,449 994,046 1,339,463 6,332,613 16,469,238 38.45% TOTAL FUND EXPENDITURES 1,269,477 1,348,807 1,082,394 1,057,166 4,757,844 16,719,238 28.46% FUND SURPLUS (DEFICIT) 89,179 1,291,642 (88,349) 282,297 1,574,769 (250,000) FOX HILL SSA REVENUES 11-000-40-00-4000 PROPERTY TAXES 1,142 5,793 200 370 7,505 13,381 56.08% TOTAL REVENUES: FOX HILL SSA 1,142 5,793 200 370 7,505 13,381 56.08% 5 % of Fiscal Year 8% 17% 25% 33%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 June-19 July-19 August-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended August 31, 2019 FOX HILL SSA EXPENDITURES 11-111-54-00-5462 PROFESSIONAL SERVICES - - 496 298 794 2,977 26.67% 11-111-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 1,861 905 2,766 28,000 9.88% TOTAL FUND REVENUES 1,142 5,793 200 370 7,505 13,381 56.08% TOTAL FUND EXPENDITURES - - 2,357 1,202 3,559 30,977 11.49% FUND SURPLUS (DEFICIT) 1,142 5,793 (2,158) (832) 3,945 (17,596) SUNFLOWER SSA REVENUES 12-000-40-00-4000 PROPERTY TAXES 1,284 7,632 294 322 9,532 18,140 52.55% TOTAL REVENUES: SUNFLOWER SSA 1,284 7,632 294 322 9,532 18,140 52.55% SUNFLOWER SSA EXPENDITURES 12-112-54-00-5416 POND MAINTENANCE - - - - - 5,000 0.00% 12-112-54-00-5462 PROFESSIONAL SERVICES - - 496 204 700 2,977 23.52% 12-112-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 3,779 855 4,634 6,000 77.23% TOTAL FUND REVENUES 1,284 7,632 294 322 9,532 18,140 52.55% TOTAL FUND EXPENDITURES - - 4,275 1,059 5,334 13,977 38.16% FUND SURPLUS (DEFICIT) 1,284 7,632 (3,981) (737) 4,197 4,163 MOTOR FUEL TAX REVENUES 15-000-41-00-4112 MOTOR FUEL TAX 42,104 38,586 35,176 43,968 159,835 484,084 33.02% 15-000-41-00-4113 MFT HIGH GROWTH - - - - - 41,000 0.00% 15-000-45-00-4500 INVESTMENT EARNINGS 1,360 1,366 1,067 522 4,315 9,820 43.94% 15-000-46-00-4690 REIMB. - MISCELLANOUS - - - 26,717 26,717 - 0.00% TOTAL REVENUES: MOTOR FUEL TAX 43,464 39,952 36,243 71,208 190,867 534,904 35.68% MOTOR FUEL TAX EXPENDITURES Capital Outlay 15-155-60-00-6004 BASELINE ROAD BRIDGE REPAIRS - - - - - 25,000 0.00% 15-155-60-00-6025 ROADS TO BETTER ROADS PROGRAM - - 467,703 - 467,703 620,000 75.44% 15-155-60-00-6079 ROUTE 47 EXPANSION 6,149 6,149 6,149 6,149 24,596 73,788 33.33% TOTAL FUND REVENUES 43,464 39,952 36,243 71,208 190,867 534,904 35.68% TOTAL FUND EXPENDITURES 6,149 6,149 473,852 6,149 492,299 718,788 68.49% FUND SURPLUS (DEFICIT) 37,315 33,803 (437,609) 65,059 (301,432) (183,884) CITY-WIDE CAPITAL REVENUES Licenses & Permits 23-000-42-00-4214 DEVELOPMENT FEES - 835 1,085 - 1,920 5,000 38.40% 23-000-42-00-4218 DEVELOPMENT FEES - MUNICIPAL BLDG 3,259 4,268 6,177 2,059 15,763 47,180 33.41% 23-000-42-00-4222 ROAD CONTRIBUTION FEE 20,000 6,000 14,000 6,000 46,000 100,000 46.00% Charges for Service 23-000-44-00-4440 ROAD INFRASTRUCTURE FEES 610 126,579 718 128,276 256,183 746,500 34.32% Investment Earnings 23-000-45-00-4500 INVESTMENT EARNINGS 1,308 1,272 1,313 1,198 5,090 7,500 67.87% Reimbursements 23-000-46-00-4614 REIMB - BLACKBERRY WOODS - - 2,350 - 2,350 7,549 31.13% 23-000-46-00-4612 MILL ROAD IMPROVEMENTS - - 2,359 10,712 13,071 2,926,300 0.45% 23-000-46-00-4621 REIMB - FOUNTAIN VILLAGE - - 93 - 93 - 0.00% 23-000-46-00-4690 REIMB - MISCELLANEOUS - 83,700 - - 83,700 80,000 104.62% Other Financing Sources 23-000-48-00-4845 DONATIONS - - - - - 2,000 0.00% 23-000-49-00-4901 TRANSFER FROM GENERAL - - - - - 250,000 0.00% TOTAL REVENUES: CITY-WIDE CAPITAL 25,177 222,653 28,094 148,246 424,170 4,172,029 10.17% 6 % of Fiscal Year 8% 17% 25% 33%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 June-19 July-19 August-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended August 31, 2019 CW MUNICIPAL BUILDING EXPENDITURES 23-216-54-00-5446 PROPERTY & BLDG MAINT SERVICES 576 8,966 4,053 26,013 39,607 225,000 17.60% 23-216-54-00-5482 STREET LIGHTING - 6,888 3,748 7,262 17,898 102,820 17.41% 23-216-56-00-5619 SIGNS - - - 763 763 15,000 5.09% 23-216-56-00-5626 HANGING BASKETS - - 427 - 427 2,000 21.35% 23-216-56-00-5656 PROPERTY & BLDG MAINT SUPPLIES 180 5 3 1,778 1,967 25,000 7.87% 23-216-60-00-6003 MATERIALS STORAGE BUILDING - - - - - 250,000 0.00% 23-216-60-00-6020 BUILDINGS & STRUCTURES - - - - - 41,250 0.00% 23-216-99-00-9901 TRANSFER TO GENERAL - - - - - 47,180 0.00% CITY-WIDE CAPITAL EXPENDITURES Contractual Services 23-230-54-00-5462 PROFESSIONAL SERVICES - - - - - 5,000 0.00% 23-230-54-00-5498 PAYING AGENT FEES - - - 475 475 475 100.00% 23-230-54-00-5499 BAD DEBT - - - - - 1,500 0.00% 23-230-60-00-6032 ASPHALT PATCHING - 1,680 553 3,444 5,677 35,000 16.22% 23-230-56-00-5637 SIDEWALK CONSTRUCTION SUPPLIES - - - 932 932 5,000 18.64% Capital Outlay 23-230-60-00-6012 MILL ROAD IMPROVEMENTS - - 2,359 27,712 30,071 3,105,000 0.97% 23-230-60-00-6014 BLACKBERRY WOODS SUBDIVISION - - 2,350 - 2,350 7,549 31.13% 23-230-60-00-6016 US34 (CENTER/ELDAMAIN RD) PROJECT - - 62,924 33,644 96,568 110,226 87.61% 23-230-60-00-6021 PAVILION RD STREAMBANK STABILIZATION - - - - 137,500 0.00% 23-230-60-00-6023 FOUNTAIN VILLAGE SUBDIVISION - - 93 - 93 - 0.00% 23-230-60-00-6025 ROAD TO BETTER ROADS PROGRAM - - 14,148 32,933 47,081 80,000 58.85% 23-230-60-00-6034 WHISPERING MEADOWS SUBDIVISION - - 594 201 795 22,500 3.53% 23-230-60-00-6058 RT71 ( RT47/ORCHARD RD) PROJECT - - - - - 30,333 0.00% 23-230-60-00-6059 US RT34(IL47/ORCHARD RD)PROJECT - - 16,722 2,120 18,842 90,981 20.71% 23-230-60-00-6094 ITEP KENNEDY RD BIKE TRAIL - - - - - 32,000 0.00% 2014A Bond 23-230-78-00-8000 PRINCIPAL PAYMENT - - - - - 195,000 0.00% 23-230-78-00-8050 INTEREST PAYMENT 63,594 - - - 63,594 127,188 50.00% 23-230-99-00-9951 TRANSFER TO WATER 8,742 8,742 8,742 8,742 34,969 104,906 33.33% TOTAL FUND REVENUES 25,177 222,653 28,094 148,246 424,170 4,172,029 10.17% TOTAL FUND EXPENDITURES 73,091 26,281 116,717 146,019 362,108 4,798,408 7.55% FUND SURPLUS (DEFICIT) (47,914) 196,372 (88,623) 2,227 62,061 (626,379) VEHICLE & EQUIPMENT REVENUE Licenses & Permits 25-000-42-00-4215 DEVELOPMENT FEES - POLICE CAPITAL 6,300 3,000 4,800 1,650 15,750 30,000 52.50% 25-000-42-00-4217 WEATHER WARNING SIREN FEES 109 217 326 54 705 - 0.00% 25-000-42-00-4218 ENGINEERING CAPITAL FEE 1,900 1,000 1,600 400 4,900 10,000 49.00% 25-000-42-00-4219 DEVELOPMENT FEES - PW CAPITAL 14,900 7,000 11,200 3,950 37,050 64,500 57.44% 25-000-42-00-4220 DEVELOPMENT FEES - PARK CAPITAL 1,000 500 800 250 2,550 5,000 51.00% Fines & Forfeits 25-000-43-00-4315 DUI FINES 854 1,029 1,361 489 3,733 8,000 46.67% 25-000-43-00-4316 ELECTRONIC CITATION FEES 76 76 100 62 314 650 48.36% Charges for Service 25-000-44-00-4418 MOWING INCOME - - 338 - 338 2,000 16.89% 25-000-44-00-4420 POLICE CHARGEBACK 2,003 2,003 2,003 2,003 8,011 24,032 33.33% 25-000-44-00-4425 COMPUTER REPLACEMENT CHARGEBACKS - - - - - 14,080 0.00% Investment Earnings 25-000-45-00-4522 INVESTMENT EARNINGS - PARKS 86 93 93 87 358 850 42.17% Miscellaneous 25-000-48-00-4852 MISC INCOME - PD CAPITAL - 412 - - 412 - 0.00% 7 % of Fiscal Year 8% 17% 25% 33%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 June-19 July-19 August-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended August 31, 2019 25-000-48-00-4854 MISC INCOME - PW CAPITAL - 99 - - 99 2,000 4.93% TOTAL REVENUES: VEHICLE & EQUIPMENT 27,227 15,428 22,620 8,945 74,220 161,112 46.07% VEHICLE & EQUIPMENT EXPENDITURES POLICE CAPITAL EXPENDITURES Contractual Services 25-205-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - - 448 448 8,750 5.12% Capital Outlay 25-205-60-00-6060 EQUIPMENT - - - - - 5,000 0.00% 25-205-60-00-6070 VEHICLES - - - - - 55,000 0.00% TOTAL EXPENDITURES: POLICE CAPITAL - - - 448 448 68,750 0.65% GENERAL GOVERNMENT CAPITAL EXPENDITURES Contractual Services 25-212-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - 13,999 - - 13,999 14,080 99.42% TOTAL EXPENDITURES: GENERAL GOVERNMENT - 13,999 - - 13,999 14,080 99.42% PUBLIC WORKS CAPITAL EXPENDITURES Contractual Services 25-215-54-00-5448 FILING FEES - - - - - 750 0.00% Supplies 25-215-56-00-5620 OPERATING SUPPLIES - - - - - 2,000 0.00% Capital Outlay 25-215-60-00-6060 EQUIPMENT - - - - - 7,000 0.00% 25-215-60-00-6070 VEHICLES - - - 201,000 0.00% 185 Wolf Street Building 25-215-92-00-8000 PRINCIPAL PAYMENT 3,604 3,622 3,640 3,657 14,523 44,429 32.69% 25-215-92-00-8050 INTEREST PAYMENT 2,689 2,672 2,654 2,636 10,651 31,095 34.25% TOTAL EXPENDITURES: PW CAPITAL 6,294 6,294 6,294 6,294 25,174 286,274 8.79% PARK & RECREATION CAPITAL EXPENDITURES Contractual Services 25-225-54-00-5495 OUTSDE REPAIR & MAINTENANCE - - - - - 5,000 0.00% Capital Outlay 25-225-60-00-6020 BUILDINGS & STRUCTURES - - - - - 20,000 0.00% 25-225-60-00-6060 EQUIPMENT - - - - - 50,000 0.00% 25-225-60-00-6070 VEHICLES - - - - - 70,000 0.00% 185 Wolf Street Building 25-225-92-00-8000 PRINCIPAL PAYMENT 113 113 114 115 455 1,392 32.69% 25-225-92-00-8050 INTEREST PAYMENT 84 84 83 83 334 974 34.26% TOTAL EXPENDITURES: PARK & REC CAPITAL 197 197 197 197 789 147,366 0.54% TOTAL FUND REVENUES 27,227 15,428 22,620 8,945 74,220 161,112 46.07% TOTAL FUND EXPENDITURES 6,491 20,490 6,491 6,939 40,410 516,470 7.82% FUND SURPLUS (DEFICIT) 20,736 (5,061) 16,129 2,006 33,810 (355,358) DEBT SERVICE REVENUES 42-000-42-00-4208 RECAPTURE FEES-WATER & SEWER 550 1,373 2,621 1,248 5,792 4,646 124.67% 42-000-49-00-4901 TRANSFER FROM GENERAL 26,615 26,615 26,615 26,615 106,460 319,379 33.33% TOTAL REVENUES: DEBT SERVICE 27,165 27,988 29,236 27,863 112,252 324,025 34.64% DEBT SERVICE EXPENDITURES 42-420-54-00-5498 PAYING AGENT FEES - - - 475 475 475 100.00% 2014B Refunding Bond 42-420-79-00-8000 PRINCIPAL PAYMENT - - - - - 290,000 0.00% 42-420-79-00-8050 INTEREST PAYMENT - 16,775 - - 16,775 33,550 50.00% TOTAL FUND REVENUES 27,165 27,988 29,236 27,863 112,252 324,025 34.64% TOTAL FUND EXPENDITURES - 16,775 - 475 17,250 324,025 5.32% FUND SURPLUS (DEFICIT) 27,165 11,213 29,236 27,388 95,002 - 8 % of Fiscal Year 8% 17% 25% 33%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 June-19 July-19 August-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended August 31, 2019 WATER FUND REVENUES Charges for Service 51-000-44-00-4424 WATER SALES 5,750 500,906 5,125 562,150 1,073,931 3,228,300 33.27% 51-000-44-00-4425 BULK WATER SALES - - - - - 5,000 0.00% 51-000-44-00-4426 LATE PENALTIES - WATER 32 17,673 194 17,541 35,441 110,000 32.22% 51-000-44-00-4430 WATER METER SALES 17,755 15,527 14,238 7,038 54,559 60,000 90.93% 51-000-44-00-4440 WATER INFRASTRUCTURE FEE 610 130,388 481 132,068 263,548 768,000 34.32% 51-000-44-00-4450 WATER CONNECTION FEE 35,220 28,045 39,670 21,139 124,074 230,000 53.95% Investment Earnings 51-000-45-00-4500 INVESTMENT EARNINGS 1,619 1,574 1,625 2,305 7,123 23,851 29.87% Miscellaneous 51-000-48-00-4820 RENTAL INCOME 10,982 8,082 8,082 8,082 35,230 95,749 36.79% 51-000-48-00-4850 MISCELLANEOUS INCOME 515 309 - - 824 250 329.50% Other Financing Sources 51-000-49-00-4923 TRANSFER FROM CITY-WIDE CAPITAL 8,742 8,742 8,742 8,742 34,969 104,906 33.33% 51-000-49-00-4952 TRANSFER FROM SEWER 6,156 6,156 6,156 6,156 24,625 73,875 33.33% TOTAL REVENUES: WATER FUND 87,382 717,403 84,315 765,223 1,654,323 4,699,931 35.20% WATER OPERATIONS EXPENSES Salaries & Wages 51-510-50-00-5010 SALARIES & WAGES 39,899 27,910 28,083 29,302 125,194 477,935 26.19% 51-510-50-00-5015 PART-TIME SALARIES 1,440 1,335 1,250 280 4,305 30,000 14.35% 51-510-50-00-5020 OVERTIME 631 376 916 1,043 2,966 12,000 24.72% Benefits 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 3,686 2,576 2,641 2,763 11,666 44,948 25.95% 51-510-52-00-5214 FICA CONTRIBUTION 3,086 2,155 2,201 2,235 9,678 37,702 25.67% 51-510-52-00-5216 GROUP HEALTH INSURANCE 14,894 7,041 7,520 7,810 37,265 137,566 27.09% 51-510-52-00-5222 GROUP LIFE INSURANCE 36 36 36 36 146 560 26.02% 51-510-52-00-5223 DENTAL INSURANCE 1,126 563 563 563 2,816 9,354 30.10% 51-510-52-00-5224 VISION INSURANCE 165 83 83 83 413 1,344 30.70% 51-510-52-00-5230 UNEMPLOYMENT INSURANCE 272 - 272 - 545 2,000 27.23% 51-510-52-00-5231 LIABILITY INSURANCE 6,464 2,184 2,184 2,184 13,015 29,590 43.98% Contractual Services 51-510-54-00-5401 ADMINISTRATIVE CHARGEBACK 9,886 9,886 9,886 9,886 39,544 118,631 33.33% 51-510-54-00-5412 TRAINING & CONFERENCES 2,400 312 - - 2,712 6,500 41.73% 51-510-54-00-5415 TRAVEL & LODGING - 127 - - 127 2,000 6.37% 51-510-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - - - 827 0.00% 51-510-54-00-5426 PUBLISHING & ADVERTISING - - - - - 500 0.00% 51-510-54-00-5429 WATER SAMPLES - 50 3,465 2,172 5,687 8,000 71.08% 51-510-54-00-5430 PRINTING & DUPLICATING 101 14 618 1 735 3,250 22.61% 51-510-54-00-5440 TELECOMMUNICATIONS - 2,892 3,117 3,519 9,528 35,000 27.22% 51-510-54-00-5445 TREATMENT FACILITY SERVICES 16,217 - 27,630 18,651 62,498 145,000 43.10% 51-510-54-00-5448 FILING FEES 530 - - 53 583 3,000 19.43% 51-510-54-00-5452 POSTAGE & SHIPPING 2,536 516 2,542 627 6,221 19,000 32.74% 51-510-54-00-5460 DUES & SUBSCRIPTIONS 567 729 - - 1,296 1,800 71.98% 51-510-54-00-5462 PROFESSIONAL SERVICES 4,222 6,287 12,010 9,947 32,467 65,000 49.95% 51-510-54-00-5465 ENGINEERING SERVICES - - 9,602 208 9,810 37,500 26.16% 51-510-54-00-5480 UTILITIES - 15,520 22,676 24,456 62,651 303,709 20.63% 51-510-54-00-5483 JULIE SERVICES - - - - - 3,000 0.00% 51-510-54-00-5485 RENTAL & LEASE PURCHASE 45 99 241 45 430 1,700 25.27% 51-510-54-00-5488 OFFICE CLEANING - 363 65 65 493 1,051 46.91% 51-510-54-00-5490 VEHICLE MAINTENANCE SERVICES - - 1,540 102 1,642 12,000 13.68% 51-510-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - - - - 25,000 0.00% 51-510-54-00-5498 PAYING AGENT FEES - - 349 475 824 1,750 47.10% 51-510-54-00-5499 BAD DEBT - - - - - 10,000 0.00% Supplies 51-510-56-00-5600 WEARING APPAREL - 81 - 231 312 5,100 6.12%9 % of Fiscal Year 8% 17% 25% 33%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 June-19 July-19 August-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended August 31, 2019 51-510-56-00-5620 OPERATING SUPPLIES 126 140 98 299 663 10,500 6.32% 51-510-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - 307 106 - 412 2,500 16.49% 51-510-56-00-5630 SMALL TOOLS & EQUIPMENT 24 56 4 178 262 4,000 6.55% 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 7,019 6,136 10,888 19,339 43,382 218,438 19.86% 51-510-56-00-5640 REPAIR & MAINTENANCE - 608 993 1,561 3,162 27,500 11.50% 51-510-56-00-5664 METERS & PARTS 1,876 6,711 20,199 19,097 47,884 100,000 47.88% 51-510-56-00-5665 JULIE SUPPLIES - 21 48 340 408 1,200 34.03% 51-510-56-00-5695 GASOLINE 91 1,322 1,691 1,622 4,726 24,043 19.66% Capital Outlay 51-510-60-00-6022 WELL REHABILITATIONS - - 84 7,541 7,625 165,000 4.62% 51-510-60-00-6025 ROAD TO BETTER ROADS PROGRAM - - - 221,417 221,417 569,000 38.91% 51-510-60-00-6034 WHISPERING MEADOWS SUBDIVISION - - 26 9 35 - 0.00% 51-510-60-00-6059 US34 (IL RT47/ORCHARD) PROJECT - - 3,972 504 4,475 21,608 20.71% 51-510-60-00-6060 EQUIPMENT - - - - - 400,000 0.00% 51-510-60-00-6066 RTE 71 WATERMAIN REPLACEMENT - - - - - 42,166 0.00% 51-510-60-00-6079 ROUTE 47 EXPANSION 3,781 3,781 3,781 3,781 15,124 45,372 33.33% 51-510-60-00-6081 CATION EXCHANGE MEDIA REPLACEMENT - - - - - 185,000 0.00% 2015A Bond 51-510-77-00-8000 PRINCIPAL PAYMENT - - - - - 290,483 0.00% 51-510-77-00-8050 INTEREST PAYMENT 75,893 - - - 75,893 151,787 50.00% 2016 Refunding Bond 51-510-85-00-8000 PRINCIPAL PAYMENT - - - - - 1,470,000 0.00% 51-510-85-00-8050 INTEREST PAYMENT - 88,225 - - 88,225 176,450 50.00% IEPA Loan L17-156300 51-510-89-00-8000 PRINCIPAL PAYMENT - - - 51,887 51,887 104,423 49.69% 51-510-89-00-8050 INTEREST PAYMENT - - - 10,628 10,628 20,607 51.57% 2014C Refunding Bond 51-510-94-00-8000 PRINCIPAL PAYMENT - - - - - 125,000 0.00% 51-510-94-00-8050 INTEREST PAYMENT - 11,375 - - 11,375 22,750 50.00% TOTAL FUND REVENUES 87,382 717,403 84,315 765,223 1,654,323 4,699,931 35.20% TOTAL FUND EXPENSES 197,015 199,818 181,381 454,939 1,033,152 5,770,144 17.91% FUND SURPLUS (DEFICIT) (109,633) 517,586 (97,066) 310,284 621,171 (1,070,213) SEWER FUND REVENUES Charges for Service 52-000-44-00-4435 SEWER MAINTENANCE FEES 666 163,928 542 165,360 330,497 979,200 33.75% 52-000-44-00-4440 SEWER INFRASTRUCTURE FEE (220) 62,291 842 64,219 127,133 370,000 34.36% 52-000-44-00-4455 SW CONNECTION FEES - OPS 7,400 8,500 5,700 11,900 33,500 23,300 143.78% 52-000-44-00-4456 SW CONNECTION FEES - CAPITAL 21,600 14,400 16,200 5,400 57,600 180,000 32.00% 52-000-44-00-4462 LATE PENALTIES - SEWER 4 2,699 21 2,510 5,235 15,000 34.90% 52-000-44-00-4465 RIVER CROSSING FEES 300 - - 150 450 - 0.00% Investment Earnings 52-000-45-00-4500 INVESTMENT EARNINGS 598 582 600 830 2,611 7,149 36.52% Other Financing Sources 52-000-46-00-4850 MISCELANEOUS INCOME 309 111 - - 420 - 0.00% 52-000-49-00-4901 TRANSFER FROM GENERAL 47,919 47,919 47,919 47,919 191,677 575,030 33.33% TOTAL REVENUES: SEWER FUND 78,577 300,429 71,825 298,290 749,121 2,149,679 34.85% SEWER OPERATIONS EXPENSES Salaries & Wages 52-520-50-00-5010 SALARIES & WAGES 16,419 13,672 11,211 11,867 53,170 265,446 20.03% 52-520-50-00-5015 PART-TIME SALARIES 1,360 1,520 1,440 1,120 5,440 5,000 108.80% 52-520-50-00-5020 OVERTIME 47 - - - 47 500 9.39% Benefits 52-520-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,505 1,239 1,016 1,075 4,835 24,399 19.82% 52-520-52-00-5214 FICA CONTRIBUTION 1,304 1,090 897 929 4,220 19,031 22.17% 52-520-52-00-5216 GROUP HEALTH INSURANCE 9,127 4,430 4,349 5,434 23,340 98,202 23.77% 10 % of Fiscal Year 8% 17% 25% 33%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 June-19 July-19 August-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended August 31, 2019 52-520-52-00-5222 GROUP LIFE INSURANCE 16 16 16 16 64 314 20.29% 52-520-52-00-5223 DENTAL INSURANCE 639 320 320 320 1,599 6,433 24.85% 52-520-52-00-5224 VISION INSURANCE 88 44 44 44 219 879 24.89% 52-520-52-00-5230 UNEMPLOYMENT INSURANCE 143 - 143 - 287 750 38.20% 52-520-52-00-5231 LIABILITY INSURANCE 3,133 1,058 1,058 1,058 6,308 14,052 44.89% Contractual Services 52-520-54-00-5401 ADMINISTRATIVE CHARGEBACK 3,558 3,558 3,558 3,558 14,232 42,696 33.33% 52-520-54-00-5412 TRAINING & CONFERENCES 707 276 150 - 1,133 2,500 45.32% 52-520-54-00-5415 TRAVEL & LODGING 2 130 - - 132 2,000 6.59% 52-520-54-00-5430 PRINTING & DUPLICATING 47 1 - 1 50 1,500 3.31% 52-520-54-00-5440 TELECOMMUNICATIONS - 636 289 707 1,632 9,000 18.13% 52-520-54-00-5444 LIFT STATION SERVICES 93 - 684 1,185 1,962 75,000 2.62% 52-520-54-00-5462 PROFESSIONAL SERVICES 1,060 1,160 - 1,520 3,741 43,000 8.70% 52-520-54-00-5480 UTILITIES - 1,937 1,177 1,628 4,742 22,472 21.10% 52-520-54-00-5483 JULIE SERVICES - - 1,488 - 1,488 3,000 49.61% 52-520-54-00-5485 RENTAL & LEASE PURCHASE 45 12 106 135 298 1,000 29.78% 52-520-54-00-5488 OFFICE CLEANING - 65 65 65 195 759 25.69% 52-520-54-00-5490 VEHICLE MAINTENANCE SERVICES 1,240 - - - 1,240 10,000 12.40% 52-520-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - - - - 16,000 0.00% 52-520-54-00-5498 PAYING AGENT FEES - - - - - 750 0.00% 52-520-54-00-5499 BAD DEBT - - - - - 3,000 0.00% Supplies 52-520-56-00-5600 WEARING APPAREL - 384 67 291 742 3,980 18.64% 52-520-56-00-5610 OFFICE SUPPLIES - - - 17 17 1,000 1.70% 52-520-56-00-5613 LIFT STATION MAINTENANCE - 104 1,223 1,171 2,498 8,000 31.23% 52-520-56-00-5620 OPERATING SUPPLIES 248 37 156 241 681 9,000 7.57% 52-520-56-00-5628 VEHICLE MAINTENANCE SUPPLIES (105) 165 - 39 100 10,000 1.00% 52-520-56-00-5630 SMALL TOOLS & EQUIPMENT 59 19 87 152 317 2,000 15.85% 52-520-56-00-5640 REPAIR & MAINTENANCE - - - 861 861 5,000 17.22% 52-520-56-00-5665 JULIE SUPPLIES - - - - - 1,200 0.00% 52-520-56-00-5695 GASOLINE 91 1,327 1,695 1,627 4,740 22,470 21.10% Capital Outlay 52-520-60-00-6001 SCADA SYSTEM - - - - - 67,000 0.00% 52-520-60-00-6025 ROAD TO BETTER ROADS PROGRAM - - 7,268 - 7,268 137,000 5.31% 52-520-60-00-6034 WHISPERING MEADOWS SUBDIVISION - - 40 13 53 - 0.00% 52-520-60-00-6059 US34 (IL RT47/ORCHARD) PROJECT - - 209 27 236 11,373 2.07% 52-520-60-00-6066 RTE 71 SEWER MAIN REPLACEMENT - - - - - 63,000 0.00% 52-520-60-00-6070 VEHICLES - - - - - 50,000 0.00% 52-520-60-00-6079 ROUTE 47 EXPANSION 1,873 1,873 1,873 1,873 7,494 22,488 33.32% Developer Commitments - Lennar 52-520-75-00-7500 LENNAR-RAINTREE SW RECAPTURE - - - - - 30,721 0.00% 2003 IRBB Debt Certificates 52-520-90-00-8000 PRINCIPAL PAYMENT - - - - - 135,000 0.00% 52-520-90-00-8050 INTEREST PAYMENT - - 14,834 - 14,834 29,668 50.00% 2011 Refunding Bond 52-520-92-00-8000 PRINCIPAL PAYMENT - - - - - 845,000 0.00% 52-520-92-00-8050 INTEREST PAYMENT - 144,557 - - 144,557 289,114 50.00% IEPA Loan L17-115300 52-520-96-00-8000 PRINCIPAL PAYMENT - - - 52,832 52,832 52,832 100.00% 52-520-96-00-8050 INTEREST PAYMENT - - - 693 693 693 100.04% 11 % of Fiscal Year 8% 17% 25% 33%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 June-19 July-19 August-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended August 31, 2019 Other Financing Uses 52-520-99-00-9951 TRANSFER TO WATER 6,156 6,156 6,156 6,156 24,625 73,875 33.33% TOTAL FUND REVENUES 78,577 300,429 71,825 298,290 749,121 2,149,679 34.85% TOTAL FUND EXPENSES 48,856 185,788 61,621 96,654 392,919 2,538,097 15.48% FUND SURPLUS (DEFICIT) 29,721 114,641 10,204 201,636 356,203 (388,418) LAND CASH REVENUES 72-000-41-00-4186 OSLAD GRANT-BRISTOL BAY 400,000 - - - 400,000 - 0.00% 72-000-47-00-4701 WHITE OAK - - - 1,406 1,406 - 0.00% 72-000-47-00-4703 AUTUMN CREEK 3,003 - - - 3,003 6,606 45.46% 72-000-47-00-4704 BLACKBERRY WOODS 568 - - - 568 15,909 3.57% 72-000-47-00-4706 CALEDONIA 1,007 1,007 - - 2,013 16,341 12.32% 72-000-47-00-4708 COUNTRY HILLS 1,538 - - 769 2,307 8,000 28.84% 72-000-47-00-4724 KENDALL MARKETPLACE - - - - - 2,024 0.00% 72-000-47-00-4736 BRIARWOOD - 2,205 4,410 2,205 8,820 9,555 92.31% 72-000-48-00-4850 MISCELLANEOUS INCOME - 20 - - 20 - 0.00% TOTAL REVENUES: LAND CASH 406,116 3,231 4,410 4,380 418,137 58,435 715.56% LAND CASH EXPENDITURES 72-720-54-00-5485 RENTAL & LEASE PURCHASE - - - 5,035 5,035 4,850 0.00% 72-720-60-00-6043 BRISTOL BAY REGIONAL PARK - - - - - 25,000 0.00% 72-720-60-00-6045 RIVERFRONT PARK - - - - - 50,000 0.00% 72-720-60-00-6067 BLACKBERRY CREEK NATURE PRESERVE - - - - - 25,000 0.00% TOTAL FUND REVENUES 406,116 3,231 4,410 4,380 418,137 58,435 715.56% TOTAL FUND EXPENDITURES - - - 5,035 5,035 104,850 4.80% FUND SURPLUS (DEFICIT) 406,116 3,231 4,410 (655) 413,102 (46,415) PARK & RECREATION REVENUES Charges for Service 79-000-44-00-4402 SPECIAL EVENTS 22,500 3,262 32,843 5,162 63,767 90,000 70.85% 79-000-44-00-4403 CHILD DEVELOPMENT 14,922 1,844 4,648 15,124 36,538 145,000 25.20% 79-000-44-00-4404 ATHLETICS AND FITNESS 37,842 41,664 50,673 16,216 146,395 365,000 40.11% 79-000-44-00-4441 CONCESSION REVENUE 5,681 18,187 6,174 2,195 32,236 32,000 100.74% Investment Earnings 79-000-45-00-4500 INVESTMENT EARNINGS 126 103 110 109 447 1,500 29.78% Reimbursements 79-000-46-00-4690 REIMB - MISCELLANEOUS - - 830 - 830 - 0.00% Miscellaneous 79-000-48-00-4820 RENTAL INCOME 48,650 950 750 750 51,100 54,500 93.76% 79-000-48-00-4825 PARK RENTALS 2,838 2,715 7,435 1,559 14,547 15,000 96.98% 79-000-48-00-4843 HOMETOWN DAYS 6,775 740 1,885 6,685 16,085 108,000 14.89% 79-000-48-00-4846 SPONSORSHIPS & DONATIONS 5,419 6,440 1,155 1,450 14,463 20,000 72.32% 79-000-48-00-4850 MISCELLANEOUS INCOME 1,182 1,876 360 1,172 4,590 3,000 152.99% Other Financing Sources 79-000-49-00-4901 TRANSFER FROM GENERAL 117,582 117,582 117,582 117,582 470,329 1,410,988 33.33% TOTAL REVENUES: PARK & RECREATION 263,516 195,362 224,445 168,004 851,327 2,244,988 37.92% PARKS DEPARTMENT EXPENDITURES Salaries & Wages 79-790-50-00-5010 SALARIES & WAGES 64,605 46,935 47,008 38,309 196,858 552,859 35.61% 79-790-50-00-5015 PART-TIME SALARIES 6,796 6,841 7,142 6,784 27,562 51,000 54.04% 79-790-50-00-5020 OVERTIME 73 318 2,391 - 2,782 5,000 55.64% Benefits 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 6,057 4,431 4,594 3,602 18,683 52,725 35.44% 79-790-52-00-5214 FICA CONTRIBUTION 5,328 3,998 4,176 3,302 16,804 44,715 37.58% 79-790-52-00-5216 GROUP HEALTH INSURANCE 29,685 13,216 17,392 11,076 71,368 153,747 46.42% 12 % of Fiscal Year 8% 17% 25% 33%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 June-19 July-19 August-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended August 31, 2019 79-790-52-00-5222 GROUP LIFE INSURANCE 54 54 54 48 210 645 32.51% 79-790-52-00-5223 DENTAL INSURANCE 1,918 905 905 793 4,522 10,866 41.62% 79-790-52-00-5224 VISION INSURANCE 270 128 128 108 634 1,537 41.26% Contractual Services 79-790-54-00-5412 TRAINING & CONFERENCES 2,400 - - - 2,400 7,000 34.29% 79-790-54-00-5415 TRAVEL & LODGING - - - - - 3,000 0.00% 79-790-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - - - 662 0.00% 79-790-54-00-5440 TELECOMMUNICATIONS - 627 712 685 2,023 6,500 31.13% 79-790-54-00-5462 PROFESSIONAL SERVICES - 203 117 231 551 9,400 5.86% 79-790-54-00-5466 LEGAL SERVICES - - 43 194 237 3,000 7.88% 79-790-54-00-5485 RENTAL & LEASE PURCHASE 95 - 95 651 840 2,500 33.60% 79-790-54-00-5488 OFFICE CLEANING - 254 254 254 762 2,876 26.50% 79-790-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 7,164 8,752 15,916 50,000 31.83% Supplies 79-790-56-00-5600 WEARING APPAREL 305 584 25 - 914 6,220 14.70% 79-790-56-00-5620 OPERATING SUPPLIES 115 2,806 2,554 411 5,885 25,000 23.54% 79-790-56-00-5630 SMALL TOOLS & EQUIPMENT - 50 412 307 769 6,000 12.81% 79-790-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - - - - - 2,000 0.00% 79-790-56-00-5640 REPAIR & MAINTENANCE - 6,897 5,734 3,860 16,491 126,000 13.09% 79-790-56-00-5695 GASOLINE - 1,523 1,984 2,627 6,134 25,410 24.14% TOTAL EXPENDITURES: PARKS DEPT 117,698 89,770 102,884 81,994 392,345 1,148,662 34.16% RECREATION DEPARTMENT EXPENDITURES Salaries & Wages 79-795-50-00-5010 SALARIES & WAGES 40,742 31,071 28,135 27,764 127,712 359,002 35.57% 79-795-50-00-5015 PART-TIME SALARIES 1,559 1,150 1,569 1,295 5,573 41,000 13.59% 79-795-50-00-5045 CONCESSION WAGES 2,436 3,201 1,972 371 7,980 15,000 53.20% 79-795-50-00-5046 PRE-SCHOOL WAGES 4,141 20 20 317 4,498 40,000 11.24% 79-795-50-00-5052 INSTRUCTORS WAGES 4,051 3,443 2,391 1,071 10,956 40,000 27.39% Benefits 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION 3,833 2,904 2,620 2,522 11,878 37,514 31.66% 79-795-52-00-5214 FICA CONTRIBUTION 3,977 2,903 2,535 2,285 11,700 36,761 31.83% 79-795-52-00-5216 GROUP HEALTH INSURANCE 14,969 7,469 6,976 7,269 36,682 101,795 36.04% 79-795-52-00-5222 GROUP LIFE INSURANCE 37 37 37 37 147 440 33.35% 79-795-52-00-5223 DENTAL INSURANCE 1,090 545 545 545 2,724 6,539 41.66% 79-795-52-00-5224 VISION INSURANCE 158 79 79 79 395 948 41.66% Contractual Services 79-795-54-00-5410 TUITION RIMBURSEMENT - - - - - 9,648 0.00% 79-795-54-00-5412 TRAINING & CONFERENCES - 710 2,355 - 3,065 5,000 61.30% 79-795-54-00-5415 TRAVEL & LODGING - - - - - 3,000 0.00% 79-795-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - - - 2,812 0.00% 79-795-54-00-5426 PUBLISHING & ADVERTISING - - 255 3,352 3,607 55,000 6.56% 79-795-54-00-5440 TELECOMMUNICATIONS - 676 823 829 2,328 8,000 29.10% 79-795-54-00-5447 SCHOLARSHIPS - - - - - 2,500 0.00% 79-795-54-00-5452 POSTAGE & SHIPPING 792 176 248 237 1,453 3,500 41.50% 79-795-54-00-5460 DUES & SUBSCRIPTIONS - - - - - 3,000 0.00% 79-795-54-00-5462 PROFESSIONAL SERVICES 6,131 9,848 18,530 18,743 53,253 100,000 53.25% 79-795-54-00-5480 UTILITIES - 406 954 1,110 2,470 14,292 17.28% 79-795-54-00-5485 RENTAL & LEASE PURCHASE 135 60 95 95 384 3,000 12.81% 79-795-54-00-5488 OFFICE CLEANING - 525 525 525 1,575 3,992 39.45% 79-795-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 67 1,045 1,112 3,000 37.06% Supplies 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 10,800 - - 51,544 62,344 100,000 62.34% 79-795-56-00-5606 PROGRAM SUPPLIES 8,633 12,424 22,832 8,549 52,438 160,000 32.77% 79-795-56-00-5607 CONCESSION SUPPLIES 114 2,693 5,640 2,117 10,564 18,000 58.69% 79-795-56-00-5610 OFFICE SUPPLIES - - - - - 3,000 0.00% 13 % of Fiscal Year 8% 17% 25% 33%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 June-19 July-19 August-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended August 31, 2019 79-795-56-00-5620 OPERATING SUPPLIES - - 1,950 2,170 4,120 15,000 27.47% 79-795-56-00-5640 REPAIR & MAINTENANCE 36 60 6 77 178 2,000 8.92% 79-795-56-00-5695 GASOLINE - 4,488 39 - 4,527 1,000 452.72% TOTAL EXPENDITURES: RECREATION DEPT 103,632 84,886 101,199 133,948 423,664 1,194,743 35.46% TOTAL FUND REVENUES 263,516 195,362 224,445 168,004 851,327 2,244,988 37.92% TOTAL FUND EXPENDITURES 221,330 174,655 204,083 215,942 816,010 2,343,405 34.82% FUND SURPLUS (DEFICIT)42,186 20,706 20,362 (47,938) 35,317 (98,417) LIBRARY OPERATIONS REVENUES Taxes 82-000-40-00-4000 PROPERTY TAXES 58,036 298,555 12,300 25,236 394,126 699,220 56.37% 82-000-40-00-4083 PROPERTY TAXES-DEBT SERVICE 65,634 337,641 13,910 28,540 445,725 793,028 56.21% Intergovernmental 82-000-41-00-4120 PERSONAL PROPERTY TAX 1,460 - 862 103 2,426 5,250 46.21% 82-000-41-00-4170 STATE GRANTS - - - - - 20,000 0.00% Fines & Forfeits 82-000-43-00-4330 LIBRARY FINES 434 712 492 1,669 3,307 8,500 38.90% Charges for Service 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 1,193 882 880 990 3,945 8,000 49.31% 82-000-44-00-4422 COPY FEES 294 322 441 399 1,457 3,750 38.84% 82-000-44-00-4439 PROGRAM FEES - 15 20 23 58 - 0.00% Investment Earnings 82-000-45-00-4500 INVESTMENT EARNINGS 735 680 817 1,079 3,311 10,000 33.11% Miscellaneous 82-000-48-00-4820 RENTAL INCOME 200 - - 175 375 2,000 18.75% 82-000-48-00-4850 MISCELLANEOUS INCOME 1,981 370 52 - 2,404 2,000 120.18% Other Financing Sources 82-000-49-00-4901 TRANSFER FROM GENERAL 5,588 1,830 2,002 1,830 11,249 25,003 44.99% TOTAL REVENUES: LIBRARY 135,555 641,006 31,777 60,044 868,382 1,576,751 55.07% LIBRARY OPERATIONS EXPENDITURES Salaries & Wages 82-820-50-00-5010 SALARIES & WAGES 30,988 21,451 20,903 20,903 94,244 278,394 33.85% 82-820-50-00-5015 PART-TIME SALARIES 19,549 12,675 12,560 12,752 57,536 196,000 29.36% Benefits 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 2,821 1,957 1,907 1,907 8,593 25,541 33.64% 82-820-52-00-5214 FICA CONTRIBUTION 3,804 2,552 2,501 2,516 11,373 35,544 32.00% 82-820-52-00-5216 GROUP HEALTH INSURANCE 11,099 5,301 5,112 5,461 26,974 81,184 33.23% 82-820-52-00-5222 GROUP LIFE INSURANCE 31 31 31 31 123 387 31.87% 82-820-52-00-5223 DENTAL INSURANCE 1,165 582 582 582 2,911 6,987 41.67% 82-820-52-00-5224 VISION INSURANCE 169 84 84 84 422 1,012 41.67% 82-820-52-00-5230 UNEMPLOYMENT INSURANCE 172 - 172 - 344 750 45.89% 82-820-52-00-5231 LIABILITY INSURANCE 5,416 1,830 1,830 1,830 10,905 24,253 44.96% Contractual Services 82-820-54-00-5412 TRAINING & CONFERENCES - - - - - 2,000 0.00% 82-820-54-00-5415 TRAVEL & LODGING - - - - - 1,500 0.00% 82-820-54-00-5426 PUBLISHING & ADVERTISING - - - 485 485 2,000 24.25% 82-820-54-00-5440 TELECOMMUNICATIONS - 832 - 842 1,674 6,000 27.89% 82-820-54-00-5452 POSTAGE & SHIPPING - 45 9 8 63 750 8.37% 82-820-54-00-5460 DUES & SUBSCRIPTIONS 1,533 13 13 - 1,559 11,000 14.17% 82-820-54-00-5462 PROFESSIONAL SERVICES 4,059 1,983 1,181 3,384 10,607 40,000 26.52% 82-820-54-00-5466 LEGAL SERVICES - - - 630 630 3,000 21.00% 82-820-54-00-5468 AUTOMATION 2,249 - - 3,804 6,053 20,000 30.26% 82-820-54-00-5480 UTILITIES - - 559 774 1,333 11,130 11.97% 82-820-54-00-5495 OUTSIDE REPAIR & MAINTENANCE 248 4,921 7,359 1,343 13,872 50,000 27.74% 14 % of Fiscal Year 8% 17% 25% 33%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 June-19 July-19 August-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended August 31, 2019 82-820-54-00-5498 PAYING AGENT FEES - 1,100 - 589 1,689 1,700 99.32% Supplies 82-820-56-00-5610 OFFICE SUPPLIES - 112 437 500 1,049 8,000 13.11% 82-820-56-00-5620 OPERATING SUPPLIES - 309 23 408 740 3,000 24.68% 82-820-56-00-5621 CUSTODIAL SUPPLIES - 1,397 - 120 1,516 8,000 18.96% 82-820-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - - - - - 2,000 0.00% 82-820-56-00-5671 LIBRARY PROGRAMMING - 22 61 - 83 1,000 8.31% 82-820-56-00-5675 EMPLOYEE RECOGNITION - - - - - 200 0.00% 82-820-56-00-5685 DVD'S - - - - - 500 0.00% 82-820-56-00-5686 BOOKS - - - 273 273 1,500 18.21% 2006 Bond 82-820-84-00-8000 PRINCIPAL PAYMENT - - - - - 50,000 0.00% 82-820-84-00-8050 INTEREST PAYMENT - 11,306 - - 11,306 22,613 50.00% 2013 Refunding Bond 82-820-99-00-8000 PRINCIPAL PAYMENT - - - - - 585,000 0.00% 82-820-99-00-8050 INTEREST PAYMENT - 69,700 - - 69,700 139,400 50.00% TOTAL FUND REVENUES 135,555 641,006 31,777 60,044 868,382 1,576,751 55.07% TOTAL FUND EXPENDITURES 83,303 138,204 55,325 59,226 336,058 1,620,345 20.74% FUND SURPLUS (DEFICIT) 52,251 502,802 (23,548) 818 532,324 (43,594) LIBRARY CAPITAL REVENUES 84-000-42-00-4214 DEVELOPMENT FEES 9,800 4,400 7,300 2,800 24,300 50,000 48.60% 84-000-45-00-4500 INVESTMENT EARNINGS 62 50 56 62 230 100 230.29% 84-000-48-00-4850 MISCELLANEOUS INCOME - 29 - - 29 - 0.00% TOTAL REVENUES: LIBRARY CAPITAL 9,862 4,479 7,356 2,862 24,559 50,100 49.02% LIBRARY CAPITAL EXPENDITURES 84-840-54-00-5460 E-BOOK SUBSCRIPTIONS - - - - - 3,500 0.00% 84-840-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - - - - - 15,000 0.00% 84-840-56-00-5683 AUDIO BOOKS - 157 233 95 485 3,500 13.85% 84-840-56-00-5684 COMPACT DISCS & OTHER MUSIC - - 343 100 443 500 88.53% 84-840-56-00-5685 DVD'S - 127 119 246 492 3,000 16.39% 84-840-56-00-5686 BOOKS - 1,958 3,713 2,427 8,097 50,000 16.19% TOTAL FUND REVENUES 9,862 4,479 7,356 2,862 24,559 50,100 49.02% TOTAL FUND EXPENDITURES - 2,241 4,408 2,867 9,516 75,500 12.60% FUND SURPLUS (DEFICIT) 9,862 2,238 2,948 (5) 15,043 (25,400) COUNTRYSIDE TIF REVENUES 87-000-40-00-4000 PROPERTY TAXES 96 64,536 619 31,741 96,993 232,318 41.75% 87-000-48-00-4850 MISCELLANEOUS INCOME 0 0 - - 0 - 0.00% TOTAL REVENUES: COUNTRYSIDE TIF 96 64,536 619 31,741 96,993 232,318 41.75% COUNTRYSIDE TIF EXPENDITURES Contractual Services 87-870-54-00-5401 ADMINISTRATIVE CHARGEBACK 939 939 939 939 3,754 11,263 33.33% 87-870-54-00-5425 TIF INCENTIVE PAYOUT - - - - - 700,000 0.00% 87-870-54-00-5462 PROFESSIONAL SERVICES - - - 129 129 2,000 6.45% 87-870-54-00-5498 PAYING AGENT FEES - - 126 - 126 700 17.95% 2015A Bond 87-870-77-00-8000 PRINCIPAL PAYMENT - - - - - 104,517 0.00% 87-870-77-00-8050 INTEREST PAYMENT 27,307 - - - 27,307 54,613 50.00% 15 % of Fiscal Year 8% 17% 25% 33%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTION May-19 June-19 July-19 August-19 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2020 BUDGET REPORT For the Month Ended August 31, 2019 2014 Refunding Bond 87-870-93-00-8050 INTEREST PAYMENT 25,358 - - - 25,358 50,715 50.00% TOTAL FUND REVENUES 96 64,536 619 31,741 96,993 232,318 41.75% TOTAL FUND EXPENDITURES 53,603 939 1,064 1,068 56,673 923,808 6.13% FUND SURPLUS (DEFICIT) (53,507) 63,598 (445) 30,674 40,320 (691,490) DOWNTOWN TIF REVENUES 88-000-40-00-4000 PROPERTY TAXES 8,667 30,817 406 2,477 42,367 80,000 52.96% 88-000-48-00-4850 MISCELLANEOUS INCOME - 17 - - 17 - 0.00% TOTAL REVENUES: DOWNTOWN TIF 8,667 30,835 406 2,477 42,384 80,000 52.98% DOWNTOWN TIF EXPENDITURES Contractual Services 88-880-54-00-5401 ADMINISTRATIVE CHARGEBACK 2,687 2,687 2,687 2,687 10,749 32,246 33.33% 88-880-54-00-5425 TIF INCENTIVE PAYOUT - - - - - 20,000 0.00% 88-880-54-00-5462 PROFESSIONAL SERVICES - - - - - 1,000 0.00% 88-880-54-00-5466 LEGAL SERVICES - 527 43 - 570 15,000 3.80% 88-880-54-00-5470 FACADE REHAB PROGRAM - - - - - 25,000 0.00% Capital Outlay 88-880-60-00-6000 PROJECT COSTS - - - 104 104 27,500 0.38% 88-880-60-00-6015 DOWNTOWN HILL - - - - - 50,000 0.00% 88-880-60-00-6048 DOWNTOWN STREETSCAPE IMPROV - - - - - 30,000 0.00% 88-880-60-00-6079 ROUTE 47 EXPANSION 624 624 624 624 2,496 7,488 33.33% 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 - 18,250 - - 18,250 18,250 100.00% TOTAL FUND REVENUES 8,667 30,835 406 2,477 42,384 80,000 52.98% TOTAL FUND EXPENDITURES 3,311 222,088 3,354 3,415 232,168 426,484 54.44% FUND SURPLUS (DEFICIT) 5,356 (191,253) (2,948) (939) (189,784) (346,484) DOWNTOWN TIF II REVENUES 89-000-40-00-4000 PROPERTY TAXES 2,001 9,875 271 373 12,520 - 0.00% TOTAL REVENUES: DOWNTOWN TIF II 2,001 9,875 271 373 12,520 - 0.00% DOWNTOWN TIF II EXPENDITURES 89-890-54-00-5466 LEGAL SERVICES - - 753 1,387 2,139 10,000 21.39% 89-890-54-00-5470 FACADE REHAB PROGRAM - - - - - 25,000 0.00% TOTAL FUND REVENUES 2,001 9,875 271 373 12,520 - 0.00% TOTAL FUND EXPENDITURES - - 753 1,387 2,139 35,000 6.11% FUND SURPLUS (DEFICIT)2,001 9,875 (481) (1,013) 10,381 (35,000) 16 August YTD % of FY 2020 Actual Actual Budget Budget YTD Actual % Change GENERAL FUND (01) Revenues Local Taxes Property Taxes 116,244$ 1,812,638$ 56.2% 3,225,250$ 2,330,690$ -22.23% Municipal Sales Tax 286,263 1,011,630 32.1% 3,151,800 984,142 2.79% Non-Home Rule Sales Tax 219,798 764,776 31.4% 2,432,700 749,823 1.99% Electric Utility Tax -158,190 22.3%710,000 152,566 3.69% Natural Gas Tax 11,782 67,020 26.8%250,000 63,670 5.26% Excise Tax 19,316 98,740 31.5%313,625 108,184 -8.73% Telephone Utility Tax 695 2,780 33.3%8,340 2,780 0.00% Cable Franchise Fees 64,747 140,199 48.3%290,000 129,591 8.19% Hotel Tax 8,921 30,920 38.7% 80,000 30,736 0.60% Video Gaming Tax 11,174 50,891 36.4%140,000 48,111 5.78% Amusement Tax 70,253 125,238 61.1%205,000 121,432 3.13% Admissions Tax -- 0.0%140,000 -0.00% Business District Tax 31,015 122,725 28.7%427,500 132,441 -7.34% Auto Rental Tax 1,307 5,191 35.8% 14,500 4,992 3.98% Total Taxes 841,515$ 4,390,938$ 38.6% 11,388,715$ 4,859,158$ -9.64% Intergovernmental State Income Tax 127,883$ 807,564$ 42.1% 1,916,366$ 663,984$ 21.62% Local Use Tax 49,646 197,243 32.7%602,966 164,363 20.00% Road & Bridge Tax 4,298 74,133 57.0%130,000 95,601 -22.46% Personal Property Replacement Tax 312 7,320 43.1% 17,000 5,938 23.28% Other Intergovernmental 3,083 3,350 9.1% 36,900 6,874 -51.27% Total Intergovernmental 185,222$ 1,089,611$ 40.3% 2,703,232$ 936,760$ 16.32% Licenses & Permits Liquor Licenses 1,277$8,062$14.4% 56,000$ 3,819$111.11% Building Permits 40,056 176,886 50.5%350,000 217,543 -18.69% Other Licenses & Permits 105 3,366 44.9%7,500 1,852 81.76% Total Licenses & Permits 41,437$ 188,315$ 45.5%413,500$ 223,214$ -15.63% Fines & Forfeits Circuit Court Fines 2,869$13,901$ 30.9% 45,000$ 17,253$ -19.43% Administrative Adjudication 2,117 8,385 28.0% 30,000 9,945 -15.69% Police Tows 2,500 11,500 23.0% 50,000 14,709 -21.82% Other Fines & Forfeits 35 95 23.8%400 150 -36.67% Total Fines & Forfeits 7,522$33,881$ 27.0%125,400$ 42,057$ -19.44% Charges for Services ^Garbage Surcharge 209,561$ 420,185$ 34.3% 1,224,875$ 396,991$ 5.84% ^Late PMT Penalties - Garbage 3,673 7,543 35.9% 21,000 6,510 15.87% ^UB Collection Fees 15,343 44,487 27.0%165,000 55,178 -19.38% Administrative Chargebacks 17,070 68,279 33.3%204,836 64,796 5.37% Other Services 900 900 180.0%500 -0.00% Total Charges for Services 246,546$ 541,394$ 33.5% 1,616,211$ 523,475$ 3.42% Investment Earnings 12,134$ 45,393$ 56.7% 80,000$ 17,990$ 152.32% UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended August 31, 2019 * Fiscal Year 2019 For the Month Ended August 31, 2018 17 August YTD % of FY 2020 Actual Actual Budget Budget YTD Actual % Change UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended August 31, 2019 * Fiscal Year 2019 For the Month Ended August 31, 2018 GENERAL FUND (01) (continued) Reimbursements/Miscellaneous/Transfers In Reimb - Engineering & Legal Expenses -$ -$ 0.0% 25,000$ 632$ -100.00% Other Reimbursements 4,356 22,505 45.0% 50,000 14,490 55.32% Rental Income 780 2,415 34.5%7,000 2,405 0.42% Miscellaneous Income & Transfers In (50) 18,160 30.2% 60,180 7 0.00% Total Miscellaneous 5,086$ 43,081$ 30.3%142,180$ 17,534$ 145.70% Total Revenues and Transfers 1,339,463$ 6,332,613$ 38.5% 16,469,238$ 6,620,188$ -4.34% Expenditures Administration 75,236$ 322,574$ 33.5%962,572$ 324,711$ -0.66% 50 Salaries 44,087 199,536 33.3%600,095 205,378 -2.84% 52 Benefits 16,562 83,578 37.9%220,528 87,113 -4.06% 54 Contractual Services 14,228 37,396 28.3%131,949 30,697 21.82% 56 Supplies 359 2,064 20.6% 10,000 1,523 35.50% Finance 33,360$ 152,283$ 28.6%531,841$ 147,295$ 3.39% 50 Salaries 21,907 101,470 33.7%301,372 96,894 4.72% 52 Benefits 8,210 40,019 33.4%119,719 40,619 -1.48% 54 Contractual Services 3,244 10,746 9.9%108,250 9,588 12.08% 56 Supplies - 47 1.9%2,500 194 -75.78% Police 362,118$ 2,197,546$ 37.1%5,923,525$ 2,223,094$ -1.15% Salaries 218,221 1,051,070 32.5% 3,238,248 1,027,221 2.32% Overtime 10,081 50,998 45.9%111,000 33,532 52.09% 52 Benefits 106,990 982,469 45.2% 2,175,164 1,075,829 -8.68% 54 Contractual Services 16,673 79,925 29.5%270,613 57,790 38.30% 56 Supplies 10,153 33,084 25.7%128,500 28,722 15.19% Community Development 65,760$ 280,692$ 30.2%930,389$ 251,504$ 11.61% 50 Salaries 38,102 175,343 33.7%520,619 161,634 8.48% 52 Benefits 14,915 69,936 37.9%184,592 59,415 17.71% 54 Contractual Services 12,110 32,344 14.9%217,523 27,660 16.93% 56 Supplies 635 3,070 40.1%7,655 2,795 9.83% PW - Street Ops & Sanitation 167,731$ 454,078$ 19.6%2,315,961$ 369,586$ 22.86% Salaries 28,066 126,363 30.5%414,921 142,785 -11.50% Overtime - 819 4.1% 20,000 253 0.00% 52 Benefits 13,941 63,004 32.5%193,915 74,794 -15.76% 54 Contractual Services 115,433 243,614 17.6% 1,385,782 123,224 97.70% 56 Supplies 10,292 20,278 6.7%301,343 28,530 -28.92% Administrative Services 352,961$ 1,350,671$ 22.3%6,054,950$ 1,501,155$ -10.02% 50 Salaries 900 900 180.0%500 - 0.00% 52 Benefits 25,144 167,330 44.1%379,699 158,043 5.88% 54 Contractual Services 132,972 402,726 13.1% 3,079,351 432,380 -6.86% 56 Supplies - - 0.0% 15,000 - 0.00% 99 Transfers Out 193,946 779,715 30.2% 2,580,400 910,732 -14.39% Total Expenditures and Transfers 1,057,166$ 4,757,844$ 28.5% 16,719,238$ 4,817,345$ -1.24% Surplus(Deficit)282,297$ 1,574,769$ (250,000)$ 1,802,843$ ^modified accruals basis *August represents 34% of fiscal year 2020 50 50 18 August YTD % of FY 2020 Actual Actual Budget Budget YTD Actual % Change WATER FUND (51) Revenues ^ Water Sales 562,150$ 1,073,931$ 33.3% 3,228,300$ 1,124,891$ -4.53% ^ Water Infrastructure Fees 132,068 263,548 34.3%768,000 255,407 3.19% ^ Late Penalties 17,541 35,441 32.2%110,000 32,226 9.98% Water Connection Fees 21,139 124,074 53.9%230,000 205,216 -39.54% Bulk Water Sales - - 0.0%5,000 2,800 -100.00% Water Meter Sales 7,038 54,559 90.9% 60,000 79,805 -31.64% Total Charges for Services 739,937$ 1,551,552$ 35.3% 4,401,300$ 1,700,345$ -8.75% BUILD Program -$ -$ 0.0%-$ 24,805$ -100.00% Investment Earnings 2,305$ 7,123$ 29.9% 23,851$ 3,918$ 81.81% Reimbursements/Miscellaneous/Transfers In Reimbursements -$ -$ 0.0%-$ 8,923$ -100.00% Rental Income 8,082 35,230 36.8% 95,749 20,696 70.23% Miscellaneous Income & Transfers In 14,898 60,417 33.7%179,031 47,638 26.83% Total Miscellaneous 22,981$ 95,647$ 34.8%274,780$ 77,257$ 23.80% Total Revenues and Transfers 765,223$ 1,654,323$ 35.2% 4,699,931$ 1,806,325$ -8.41% Expenses Water Operations Salaries 29,582$ 129,499$ 25.5%507,935$ 147,784$ -12.37% Overtime 1,043 2,966 24.7% 12,000 2,469 20.14% 52 Benefits 15,674 75,542 28.7%263,064 90,453 -16.48% 54 Contractual Services 70,206 237,249 29.5%804,218 179,663 32.05% 56 Supplies 42,668 101,212 25.7%393,281 90,055 12.39% 60 Capital Outlay 233,251$ 248,676$ 1,428,146$ 70,853$ 250.97% Well Rehabilitations 7,541 7,625 4.6% 165,000 Road to Better Roads Program 221,417 221,417 38.9% 569,000 Whispering Meadows Subdivision 9 35 0.0%- US 34 Project (IL Rte 47 to Orchard)504 4,475 20.7% 21,608 Route 71 Watermain Replacement - - 0.0% 42,166 Route 47 Expansion 3,781 15,124 33.3% 45,372 Cation Exhange Media Replacement - - 0.0% 185,000 Vehicles & Equipment - - 0.0% 400,000 Debt Service 62,515$ 238,008$ 2,361,500$ 257,587$ -7.60% 2015A Bond - 75,893 17.2% 442,270 2016 Refunding Bond - 88,225 5.4% 1,646,450 IEPA Loan L17-156300 62,515 62,515 50.0% 125,030 2014C Refunding Bond - 11,375 7.7% 147,750 Total Expenses 454,939$ 1,033,152$ 17.9% 5,770,144$ #838,864$ 23.16% Surplus(Deficit)310,284$ 621,171$ (1,070,213)$ 967,461$ ^modified accruals basis *August represents 34% of fiscal year 2020 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENSES AND TRANSFERS For the Month Ended August 31, 2019 * Fiscal Year 2019 For the Month Ended August 31, 2018 Charges for Services 89 50 6025 6059 6022 6066 6081 6079 6070 77 85 6034 94 19 August YTD % of FY 2020 Actual Actual Budget Budget YTD Actual % Change SEWER FUND (52) Revenues ^Sewer Maintenance Fees 165,360$ 330,497$ 33.8%979,200$ 319,613$ 3.41% ^Sewer Infrastructure Fees 64,219 127,133 34.4%370,000 123,796 2.70% River Crossing Fees 150 450 0.0% - 4,628 0.00% ^Late Penalties 2,510 5,235 22.5% 23,300 65,878 -92.05% Sewer Connection Fees 17,300 91,100 46.7%195,000 - 0.00% Total Charges for Services 249,540$ 554,414$ 35.4% 1,567,500$ 513,915$ 7.88% BUILD Program -$ -$ 0.0% -$ 16,000$ -100.00% Investment Earnings 830$ 2,611$ 36.5% 7,149$ 2,985$ -12.54% Reimbursements/Miscellaneous/Transfers In Miscellaneous Income & Transfers In 47,919 192,096 33.4%575,030 285,671 -32.76% Total Miscellaneous 47,919$ 192,096$ 33.4%575,030$ 285,671$ -32.76% Total Revenues and Transfers 298,290$ 749,121$ 34.8% 2,149,679$ 818,571$ -8.48% Expenses Sewer Operations Salaries 12,987$ 58,610$ 21.7%270,446$ 78,937$ -25.75% Overtime - 47 9.4%500 - 0.00% 52 Benefits 8,875 40,871 24.9%164,060 42,838 -4.59% 54 Contractual Services 8,799 30,844 13.3%232,677 46,347 -33.45% 56 Supplies 4,398 9,956 15.9% 62,650 15,097 -34.05% 75 Developer Commitment - Lennar(Raintree)- - 0.0% 30,721 - 0.00% 60 Capital Outlay 1,913$ 15,051$ 350,861$ 47,800$ -68.51% SCADA - - 0.0% 67,000 Road to Better Roads Program - 7,268 5.3% 137,000 Whispering Meadows Subdidvision 13 53 0.0%- US 34 Project (IL Rte 47 to Orchard)27 236 2.1% 11,373 Route 71 Sewer Main Replacement - - 0.0%63,000 Vehicles - - 0.0%50,000 Route 47 Expansion 1,873 7,494 33.3% 22,488 Debt Service 53,525$ 212,916$ 1,352,307$ 242,633$ -12.25% 2003 IRBB Debt Certificates - 14,834 9.0% 164,668 2011 Refunding Bond - 144,557 12.7% 1,134,114 IEPA Loan L17-115300 53,525 53,525 100.0% 53,525 99 Transfers Out 6,156$ 24,625$ 33.3% 73,875$ 25,892$ -4.89% Total Expenses and Transfers 96,654$ 392,919$ 15.5% 2,538,097$ 499,544$ -21.34% Surplus(Deficit)201,636$ 356,203$ (388,418)$ 319,027$ ^modified accruals basis *August represents 34% of fiscal year 2020 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENSES AND TRANSFERS For the Month Ended August 31, 2019 * Fiscal Year 2019 For the Month Ended August 31, 2018 6070 Charges for Services 50 6001 6059 6066 6025 6034 6079 90 92 96 20 August YTD % of FY 2020 Actual Actual Budget Budget YTD Actual % Change PARKS & RECREATION FUND (79) Revenues Charges for Services Special Events 5,162$ 63,767$ 70.9% 90,000$ 63,234$ 0.84% Child Development 15,124 36,538 25.2%145,000 45,940 -20.47% Athletics & Fitness 16,216 146,395 40.1%365,000 81,334 79.99% Concession Revenue 2,195 32,236 100.7% 32,000 21,870 47.40% Total Charges for Services 38,697$ 278,936$ 44.1%632,000$ 212,378$ 31.34% Investment Earnings 109$ 447$ 29.8%1,500$ 524$ -14.76% Reimbursements/Miscellaneous/Transfers In Reimbursements -$ 830$ 0.0%-$ 9,696$ -91.44% Rental Income 750 51,100 93.8% 54,500 49,608 3.01% Park Rentals 1,559 14,547 97.0% 15,000 11,033 31.85% Hometown Days 6,685 16,085 14.9%108,000 19,250 -16.44% Sponsorships & Donations 1,450 14,463 72.3% 20,000 9,415 53.62% Miscellaneous Income & Transfers In 118,754 474,919 33.6% 1,413,988 426,431 11.37% Total Miscellaneous 129,199$ 571,944$ 35.5% 1,611,488$ 525,433$ 8.85% Total Revenues and Transfers 168,004$ 851,327$ 37.9% 2,244,988$ 738,335$ 15.30% Expenditures Parks Department 81,994$ 392,345$ 34.2%1,148,662$ 334,120$ 17.43% Salaries 45,093 224,420 37.2%603,859 190,100 18.05% Overtime - 2,782 55.6%5,000 2,701 3.00% 52 Benefits 18,929 112,222 42.5%264,235 94,209 19.12% 54 Contractual Services 10,766 22,729 26.8% 84,938 16,339 39.11% 56 Supplies 7,205 30,193 15.8%190,630 30,771 -1.88% Recreation Department 133,948$ 423,664$ 35.5%1,194,743$ 356,221$ 18.93% 50 Salaries 30,818 156,718 31.7%495,002 142,724 9.80% 52 Benefits 12,737 63,527 34.5%183,997 62,893 1.01% 54 Contractual Services 25,935 69,247 31.9%216,744 42,530 62.82% 56 Hometown Days 51,544 62,344 62.3%100,000 56,607 10.14% 56 Supplies 12,913 71,828 36.1%199,000 51,467 39.56% Total Expenditures 215,942$ 816,010$ 34.8% 2,343,405$ 690,341$ 18.20% Surplus(Deficit)(47,938)$ 35,317$ (98,417)$ 47,994$ *August represents 34% of fiscal year 2020 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended August 31, 2019 * Fiscal Year 2019 For the Month Ended August 31, 2018 50 21 August YTD % of FY 2020 Actual Actual Budget Budget YTD Actual % Change LIBRARY OPERATIONS FUND (82) Revenues Property Taxes 53,776$ 839,850$ 56.3% 1,492,248$ 1,078,224$ -22.11% Intergovernmental Personal Property Replacement Tax 103$ 2,426$ 46.2%5,250$ 1,968$ 23.27% State Grants - - 0.0% 20,000 25,211 -100.00% Total Intergovernmental 103$ 2,426$ 9.6% 25,250$ 27,179$ -91.07% Library Fines 1,669$ 3,307$ 38.9%8,500$ 3,187$ 3.76% Charges for Services Library Subscription Cards 990$ 3,945$ 49.3%8,000$ 3,644$ 8.27% Copy Fees 399 1,457 38.8%3,750 1,592 -8.53% Program Fees 23 58 0.0%- 1 5725.00% Total Charges for Services 1,413$ 5,460$ 46.5% 11,750$ 5,237$ 4.25% Investment Earnings 1,079$ 3,311$ 33.1% 10,000$ 1,453$ 127.78% Reimbursements/Miscellaneous/Transfers In Miscellaneous Reimbursements -$ -$ 0.0%-$ -$ 0.00% Rental Income 175 375 18.8%2,000 500 -25.00% DVD Rental Income - - 0.0%- 1,102 -100.00% Miscellaneous Income - 2,404 120.2%2,000 123 1854.17% Transfer In 1,830 11,249 45.0% 25,003 10,730 4.84% Total Miscellaneous & Transfers 2,005$ 14,028$ 48.4% 29,003$ 12,454$ 12.63% Total Revenues and Transfers 60,044$ 868,382$ 55.1% 1,576,751$ 1,127,735$ -23.00% Expenditures Library Operations 59,226$ 336,058$ 20.7%1,620,345$ 331,082$ 1.50% 50 Salaries 33,654 151,780 32.0% 474,394 147,279 3.06% 52 Benefits 12,412 61,646 35.1% 175,658 60,485 1.92% 54 Contractual Services 11,858 37,963 25.5% 149,080 25,620 48.18% 56 Supplies 1,301 3,662 15.1% 24,200 9,148 -59.97% 99 Debt Service - 81,006 10.2% 797,013 88,550 -8.52% Total Expenditures and Transfers 59,226$ 336,058$ 20.7% 1,620,345$ 331,082$ 1.50% Surplus(Deficit)818$ 532,324$ (43,594)$ 796,653$ *August represents 34% of fiscal year 2020 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended August 31, 2019 * Fiscal Year 2019 For the Month Ended August 31, 2018 22 DATE: 09/10/2019 UNITED CITY OF YORKVILLE PAGE: 1TIME: 11:02:54 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 04PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________01-110-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 AP-190525MB 05/14/2019 05 ICSC - PUBLIC INSTITUTION DUE FIRST NATIONAL BANK 900073 052519-B.OLSON-B 100.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 100.00 0.0002 AP-190611B 06/05/2019 15 05/07 EDC MEETING MINUTES MARLYS J. YOUNG 530075 050719 79.50 AP-190625B 06/19/2019 21 05/15/19 ADMIN MEETING MINUTES MARLYS J. YOUNG 530419 051519 65.50 06/19/2019 22 05/21/19 PW MEETING MINUTES MARLYS J. YOUNG 530419 052119 55.75 _________________________________ TOTAL PERIOD 02 ACTIVITY 200.75 0.0003 AP-190709 07/01/2019 09 06/04/19 EDC MEETING MINUTES MARLYS J. YOUNG 530533 060419 60.00 AP-190723 07/17/2019 25 LIQUOR LICENSE BACKGROUND ILLINOIS STATE POLIC 530590 053119 113.00 07/17/2019 26 BACKGROUND CHECKS ILLINOIS STATE POLIC 530591 053119 395.50 07/17/2019 27 06/18/19 PW MEETING MINUTES MARLYS J. YOUNG 530662 061819 59.25 07/17/2019 28 07/19/19 ADMIN MEETING MINUTES MARLYS J. YOUNG 530662 061919 57.50 _________________________________ TOTAL PERIOD 03 ACTIVITY 685.25 0.0004 AP-190813 08/06/2019 33 SOLICITOR BACKGROUND CHECKS ILLINOIS STATE POLIC 530728 063019 395.50 08/06/2019 34 06/13/19 UDO ADVISORY MEETING MARLYS J. YOUNG 530815 061319 62.00 08/06/2019 35 07/02/19 EDC MEETING MINUTES MARLYS J. YOUNG 530815 070219 45.75 08/06/2019 36 07/03/19 PUBLIC SAFETY MEETING MARLYS J. YOUNG 530815 070319 50.00 08/06/2019 37 07/16/19 PW MEETING MINUTES MARLYS J. YOUNG 530815 071619 48.00 AP-190827 08/20/2019 20 LIQUOR LICENSE BACKGROUND ILLINOIS STATE POLIC 530853 073119 113.00 _________________________________ TOTAL PERIOD 04 ACTIVITY 714.25 0.00 YTD BUDGET 4,000.00 TOTAL ACCOUNT ACTIVITY 1,700.25 0.00 ANNUAL REVISED BUDGET 12,000.00 ENDING BALANCE 1,700.25_____________________________________________________________________________________________________________________________________________________01-120-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 GJ-190530FE 06/03/2019 02 Analysis Charge Partial Refund 25.05 GJ-190531FE 05/21/2019 01 UB CC Fees - Apr 2019 523.95 05/21/2019 07 UB Paymentus Fees - Apr 2019 1,197.25 _________________________________ TOTAL PERIOD 01 ACTIVITY 1,721.20 25.0502 AP-190625B 06/19/2019 37 MYGOVHUB FEES - MAY 2019 HARRIS COMPUTER SYST 530348 XT00006855 174.64 GJ-190630FE 06/24/2019 01 UB CC Fees - May 2019 676.28 06/24/2019 07 UB Paymentus Fees - May 2019 837.85 _________________________________ TOTAL PERIOD 02 ACTIVITY 1,688.77 0.0003 GJ-190731FE 08/02/2019 01 UB CC Fees - June 2019 591.10 08/02/2019 07 UB Paymentus Fees - June 2019 1,292.70 _________________________________ TOTAL PERIOD 03 ACTIVITY 1,883.80 0.0004 AP-190813 08/06/2019 56 MYGOVHUB FEES - JUNE 2019 HARRIS COMPUTER SYST 530723 XT00006916 78.76 08/06/2019 57 MYGOVHUB FEES - JULY 2019 HARRIS COMPUTER SYST 530723 XT00006930 174.23 GJ-190831FE 08/29/2019 01 UB CC Fees - July 2019 1,123.03 08/29/2019 07 UB Paymentus Fees - July 2019 759.94 08/29/2019 13 FNBO Analysis Charge-July 2019 373.15 _________________________________ TOTAL PERIOD 04 ACTIVITY 2,509.11 0.00 YTD BUDGET 20,000.00 TOTAL ACCOUNT ACTIVITY 7,802.88 25.05 ANNUAL REVISED BUDGET 60,000.00 ENDING BALANCE 7,777.83 DATE: 09/10/2019 UNITED CITY OF YORKVILLE PAGE: 2TIME: 11:02:54 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 04PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________01-210-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 AP-190514B 05/07/2019 24 LAW ENFORCEMENT MANUAL UPDATE LEXIPOL LLC 529815 28427 11,967.00 AP-190525MB 05/14/2019 10 ELINEUP-SOFTWARE MAINTENANCE FIRST NATIONAL BANK 900073 052519-N.DECKER-B 600.00 GJ-90520PRE 05/21/2019 26 ID Ntwrk-Live Scan Renewal 1,995.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 14,562.00 0.0003 AP-190723 07/17/2019 60 BACKGROUND CHECKS ILLINOIS STATE POLIC 530591 053119 28.25 AP-190725M 07/22/2019 19 SHRED-IT-MAY ON SITE SHREDDING FIRST NATIONAL BANK 900077 072519-N.DECKER 176.73 07/22/2019 20 ACCURINT-MAY 2019 SEARCHES FIRST NATIONAL BANK 900077 072519-N.DECKER 147.25 07/22/2019 21 IL CHIEFS ASSOCIATION-JOB FIRST NATIONAL BANK 900077 072519-R.WRIGHT 50.00 07/22/2019 22 THE BLUE LINE-JOB POSTING FIRST NATIONAL BANK 900077 072519-R.WRIGHT 250.00 _________________________________ TOTAL PERIOD 03 ACTIVITY 652.23 0.0004 AP-190825M 08/15/2019 30 SHRED-IT-JUNE 6 ON-SITE FIRST NATIONAL BANK 900078 082519-N.DECKER 177.50 08/15/2019 31 ACCURRINT-JUNE 2019 SEARCHES FIRST NATIONAL BANK 900078 082519-N.DECKER 198.50 _________________________________ TOTAL PERIOD 04 ACTIVITY 376.00 0.00 YTD BUDGET 10,000.00 TOTAL ACCOUNT ACTIVITY 15,590.23 0.00 ANNUAL REVISED BUDGET 30,000.00 ENDING BALANCE 15,590.23_____________________________________________________________________________________________________________________________________________________01-220-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.0002 AP-190625B 06/19/2019 70 REMAINING BALANCE DUE FOR FARR ASSOCIATES 530342 2017021-11 16.21 06/19/2019 71 05/08/19 P&Z MEETING MINUTES MARLYS J. YOUNG 530419 050819 4.67 GJ-90816RC2 08/19/2019 01 RC Adobe Inv#062519-J.Engberg 52.99 _________________________________ TOTAL PERIOD 02 ACTIVITY 73.87 0.0003 AP-190709 07/01/2019 41 MAY 2019 CONSULTING SERVICES HOUSEAL LAVIGNE ASSO 530463 4204 240.00 AP-190723 07/17/2019 77 UDO SMART CODE LICENSE FEE & ENCODE PLUS, LLC 530571 1530 7,750.00 AP-190725M 07/22/2019 51 IWORDQ-SOFTWARE MANAGEMENT FIRST NATIONAL BANK 900077 072519-K.BARKSDALE 4,750.00 GJ-90816RC3 08/19/2019 01 RC Adobe Inv#072519-J.Engberg 52.99 _________________________________ TOTAL PERIOD 03 ACTIVITY 12,792.99 0.0004 AP-190825M 08/15/2019 66 ADOBE-MONTHLY CREATIVE CLOUD FIRST NATIONAL BANK 900078 082519-J.ENGBERG 52.99 AP-190827 08/20/2019 73 TEXT AMENDMENT FOR ACCESSORY CHRISTINE M. VITOSH 530893 1958 79.78 08/20/2019 74 TEXT AMENDMENT FOR ACCESSORY MARLYS J. YOUNG 530896 071019 17.06 08/20/2019 75 PLANNING & ZONING COMMISSION MARLYS J. YOUNG 530896 071019 17.06 _________________________________ TOTAL PERIOD 04 ACTIVITY 166.89 0.00 YTD BUDGET 20,833.36 TOTAL ACCOUNT ACTIVITY 13,033.75 0.00 ANNUAL REVISED BUDGET 62,500.00 ENDING BALANCE 13,033.75_____________________________________________________________________________________________________________________________________________________01-410-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.0002 AP-190625B 06/19/2019 78 MAY 2019 COPIER CHARGES IMPACT NETWORKING, L 530354 1447604 1.37 _________________________________ TOTAL PERIOD 02 ACTIVITY 1.37 0.0003 AP-190723 07/17/2019 85 BACKGROUND CHECKS ILLINOIS STATE POLIC 530591 053119 56.50 07/17/2019 86 5/29-6/28 COPIER CHARGES IMPACT NETWORKING, L 530594 1475388 0.99 AP-190725M 07/22/2019 58 PHYSICIANS CARE-DRUG TESTING FIRST NATIONAL BANK 900077 072519-R.WRIGHT 43.00 _________________________________ TOTAL PERIOD 03 ACTIVITY 100.49 0.00 DATE: 09/10/2019 UNITED CITY OF YORKVILLE PAGE: 3TIME: 11:02:54 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 04PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________01-410-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________04 AP-190813 08/06/2019 94 06/29-07/28 COPIER CHARGES IMPACT NETWORKING, L 530731 1500632 1.12 AP-190825M 08/15/2019 71 PHYSICIANS CARE-DRUG TESTS FIRST NATIONAL BANK 900078 082519-R.WRIGHT 136.00 AP-190827 08/20/2019 85 3 BLADES SHARPENED BOB'S SHARPENING & R 530828 081219 24.00 08/20/2019 86 STORM SEWER TELEVISING & INNOVATIVE UNDERGROU 530857 1321 250.00 _________________________________ TOTAL PERIOD 04 ACTIVITY 411.12 0.00 YTD BUDGET 2,275.00 TOTAL ACCOUNT ACTIVITY 512.98 0.00 ANNUAL REVISED BUDGET 6,825.00 ENDING BALANCE 512.98_____________________________________________________________________________________________________________________________________________________01-640-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 AP-190528B 05/21/2019 61 2018 DRAINAGE DISTRICT FEES KENDALL COUNTY COLLE 529899 2018DDF 522.92 _________________________________ TOTAL PERIOD 01 ACTIVITY 522.92 0.0002 AP-190611B 06/05/2019 73 05/01/19 SHARED SERVICES FOR VILLAGE OF OSWEGO 530051 485-B 3,500.00 _________________________________ TOTAL PERIOD 02 ACTIVITY 3,500.00 0.00 YTD BUDGET 9,000.00 TOTAL ACCOUNT ACTIVITY 4,022.92 0.00 ANNUAL REVISED BUDGET 27,000.00 ENDING BALANCE 4,022.92_____________________________________________________________________________________________________________________________________________________11-111-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.0003 AP-190709 07/01/2019 82 GROUNDS MANAGEMENT SERVICES BAUM PROPERTY MANAGE 530434 19-05 248.07 07/01/2019 83 GROUNDS MANAGEMENT SERVICES BAUM PROPERTY MANAGE 530434 19-06 248.06 _________________________________ TOTAL PERIOD 03 ACTIVITY 496.13 0.0004 AP-190813 08/06/2019 169 FOX HILL SUBDIVISION RESIDENT AURORA FASTPRINT, IN 530680 22994 297.69 _________________________________ TOTAL PERIOD 04 ACTIVITY 297.69 0.00 YTD BUDGET 992.36 TOTAL ACCOUNT ACTIVITY 793.82 0.00 ANNUAL REVISED BUDGET 2,977.00 ENDING BALANCE 793.82_____________________________________________________________________________________________________________________________________________________12-112-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.0003 AP-190709 07/01/2019 85 GROUNDS MANAGEMENT SERVICES BAUM PROPERTY MANAGE 530434 19-05 248.06 07/01/2019 86 GROUNDS MANAGEMENT SERVICES BAUM PROPERTY MANAGE 530434 19-06 248.07 _________________________________ TOTAL PERIOD 03 ACTIVITY 496.13 0.0004 AP-190813 08/06/2019 172 SUNFLOWER SUBDIVISION AURORA FASTPRINT, IN 530680 22995 204.19 _________________________________ TOTAL PERIOD 04 ACTIVITY 204.19 0.00 YTD BUDGET 992.36 TOTAL ACCOUNT ACTIVITY 700.32 0.00 ANNUAL REVISED BUDGET 2,977.00 ENDING BALANCE 700.32_____________________________________________________________________________________________________________________________________________________23-230-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 YTD BUDGET 1,666.68 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 5,000.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________25-205-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 YTD BUDGET 0.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 0.00 ENDING BALANCE 0.00 DATE: 09/10/2019 UNITED CITY OF YORKVILLE PAGE: 4TIME: 11:02:55 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 04PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________25-225-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 YTD BUDGET 0.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 0.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________51-510-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 AP-190528B 05/21/2019 77 ANNUAL SOFTWARE SUPPORT SENSUS USA, INC 529935 ZA19006900 1,949.94 GJ-190530FE 06/03/2019 04 Analysis Charge Partial Refund 33.57 GJ-190531FE 05/21/2019 03 UB CC Fees - Apr 2019 701.97 05/21/2019 09 UB Paymentus Fees - Apr 2019 1,604.02 _________________________________ TOTAL PERIOD 01 ACTIVITY 4,255.93 33.5702 AP-190611B 06/05/2019 94 MAY 2019 WATER SYSTEM INTERIM BAXTER & WOODMAN 530016 0206281-B 3,394.80 06/05/2019 95 JUNE 2019 HOSTING SERVICES ITRON 530039 519904 600.37 AP-190625B 06/19/2019 125 MYGOVHUB FEES - MAY 2019 HARRIS COMPUTER SYST 530348 XT00006855 263.55 GJ-190630FE 06/24/2019 03 UB CC Fees - May 2019 906.05 06/24/2019 09 UB Paymentus Fees - May 2019 1,122.52 _________________________________ TOTAL PERIOD 02 ACTIVITY 6,287.29 0.0003 AP-190709 07/01/2019 106 JULY 2019 HOSTING SERVICES ITRON 530467 523190 600.37 AP-190723 07/17/2019 200 JUNE 2019 WATER SYSTEM BAXTER & WOODMAN 530543 0206905 8,486.00 AP-190725M 07/22/2019 85 APWA-JOB POSTING FIRST NATIONAL BANK 900077 072519-E.DHUSE 400.00 GJ-190731FE 08/02/2019 03 UB CC Fees - June 2019 791.94 08/02/2019 09 UB Paymentus Fees - June 2019 1,731.91 _________________________________ TOTAL PERIOD 03 ACTIVITY 12,010.22 0.0004 AP-190813 08/06/2019 224 06/17-07/11 WATER SYSTEM BAXTER & WOODMAN 530682 0207517 5,942.25 08/06/2019 225 MYGOVHUB FEES - JUNE 2019 HARRIS COMPUTER SYST 530723 XT00006916 118.86 08/06/2019 226 MYGOVHUB FEES - JULY 2019 HARRIS COMPUTER SYST 530723 XT00006930 262.94 08/06/2019 227 AUG 2019 HOSTING SERVICES ITRON 530734 526199 600.37 GJ-190831FE 08/29/2019 03 UB CC Fees - July 2019 1,504.58 08/29/2019 09 UB Paymentus Fees - July 2019 1,018.13 08/29/2019 15 FNBO Analysis Charge-July 2019 499.94 _________________________________ TOTAL PERIOD 04 ACTIVITY 9,947.07 0.00 YTD BUDGET 21,666.68 TOTAL ACCOUNT ACTIVITY 32,500.51 33.57 ANNUAL REVISED BUDGET 65,000.00 ENDING BALANCE 32,466.94_____________________________________________________________________________________________________________________________________________________52-520-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 GJ-190530FE 06/03/2019 06 Analysis Charge Partial Refund 15.66 GJ-190531FE 05/21/2019 05 UB CC Fees - Apr 2019 327.45 05/21/2019 11 UB Paymentus Fees - Apr 2019 748.23 _________________________________ TOTAL PERIOD 01 ACTIVITY 1,075.68 15.6602 AP-190625B 06/19/2019 150 MYGOVHUB FEES - MAY 2019 HARRIS COMPUTER SYST 530348 XT00006855 76.06 06/19/2019 151 JUL - SEPT 2019 ALARM WIRE WIZARD OF ILLIN 530416 31967 138.00 GJ-190630FE 06/24/2019 05 UB CC Fees - May 2019 422.65 06/24/2019 11 UB Paymentus Fees - May 2019 523.63 DATE: 09/10/2019 UNITED CITY OF YORKVILLE PAGE: 5TIME: 11:02:56 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 04PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________52-520-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________02 GJ-90816RC2 08/19/2019 10 RC Wire Whiz Inv#31967 138.00 _________________________________ TOTAL PERIOD 02 ACTIVITY 1,160.34 138.0003 GJ-190731FE 08/02/2019 05 UB CC Fees - June 2019 369.42 08/02/2019 11 UB Paymentus Fees - June 2019 807.89 _________________________________ TOTAL PERIOD 03 ACTIVITY 1,177.31 0.0004 AP-190813 08/06/2019 275 MYGOVHUB FEES - JUNE 2019 HARRIS COMPUTER SYST 530723 XT00006916 34.30 08/06/2019 276 MYGOVHUB FEES - JULY 2019 HARRIS COMPUTER SYST 530723 XT00006930 75.88 GJ-190831FE 08/29/2019 05 UB CC Fees - July 2019 701.85 08/29/2019 11 UB Paymentus Fees - July 2019 474.93 08/29/2019 17 FNBO Analysis Charge-July 2019 233.21 _________________________________ TOTAL PERIOD 04 ACTIVITY 1,520.17 0.00 YTD BUDGET 14,333.36 TOTAL ACCOUNT ACTIVITY 4,933.50 153.66 ANNUAL REVISED BUDGET 43,000.00 ENDING BALANCE 4,779.84_____________________________________________________________________________________________________________________________________________________79-790-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.0002 AP-190625B 06/19/2019 169 MAY 2019 COPIER CHARGES IMPACT NETWORKING, L 530354 1447604 129.36 06/19/2019 170 05/09/19 PARK BOARK MEETING MARLYS J. YOUNG 530419 050919 73.25 _________________________________ TOTAL PERIOD 02 ACTIVITY 202.61 0.0003 AP-190723 07/17/2019 262 BACKGROUND CHECKS ILLINOIS STATE POLIC 530591 053119 28.25 07/17/2019 263 5/29-6/28 COPIER CHARGES IMPACT NETWORKING, L 530594 1475388 45.63 AP-190725M 07/22/2019 101 PHYSICIANS CARE-DRUG TESTING FIRST NATIONAL BANK 900077 072519-R.WRIGHT 43.00 _________________________________ TOTAL PERIOD 03 ACTIVITY 116.88 0.0004 AP-190813 08/06/2019 312 06/29-07/28 COPIER CHARGES IMPACT NETWORKING, L 530731 1500632 88.13 AP-190825M 08/15/2019 121 PHYSICIANS CARE-DRUG TESTS FIRST NATIONAL BANK 900078 082519-R.WRIGHT 58.00 AP-190827 08/20/2019 198 7/11/19 PARK BOARD MEETING MARLYS J. YOUNG 530896 071119-PR 85.00 _________________________________ TOTAL PERIOD 04 ACTIVITY 231.13 0.00 YTD BUDGET 3,133.36 TOTAL ACCOUNT ACTIVITY 550.62 0.00 ANNUAL REVISED BUDGET 9,400.00 ENDING BALANCE 550.62_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 AP-190514B 05/07/2019 81 SUMMER & FALL 2019 USSSA HERB WIEGEL 529824 44 789.25 AP-190528B 05/21/2019 114 UMPIRE JUAN DANIEL AVILA 529869 050419 70.00 05/21/2019 115 UMPIRE MATT BENJAMIN 529871 050919 80.00 05/21/2019 116 UMPIRE DWAYNE F BEYER 529872 050919 80.00 05/21/2019 117 UMPIRE REBEKAH BOHYER 529874 5/3-5/13 40.00 05/21/2019 118 UMPIRE DONALD CZEPIEL 529879 5/3-5/13 55.00 05/21/2019 119 UMPIRE SARA R. EBNER 529884 5/3-5/13 140.00 05/21/2019 120 UMPIRE JOHN ELENBAAS 529885 050419 105.00 05/21/2019 121 UMPIRE JAMIE ELENBAAS 529886 050919 35.00 05/21/2019 122 UMPIRE CONNER FOX 529888 5/3-5/13 65.00 05/21/2019 123 UMPIRE RICARDO GANTE 529891 051119 70.00 05/21/2019 124 UMPIRE JOSHUA HAVERNICK 529892 5/3-5/13 40.00 DATE: 09/10/2019 UNITED CITY OF YORKVILLE PAGE: 6TIME: 11:02:57 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 04PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 AP-190528B 05/21/2019 125 UMPIRE ANDREW HETTINGER 529893 5/3-5/13 55.00 05/21/2019 126 UMPIRE MICHAEL HILKER 529894 5/3-5/13 20.00 05/21/2019 127 UMPIRE JAREK DANIEL HOTWANG 529895 5/3-5/13 55.00 05/21/2019 128 UMPIRE TY KUKIELKA 529902 5/3-5/13 110.00 05/21/2019 129 UMPIRE JOESEPH KWIATKOWSKI 529903 5/3-5/13 55.00 05/21/2019 130 UMPIRE MATTHEW J. LAWLESS 529904 050619 35.00 05/21/2019 131 UMPIRE OWEN LINDSTRAND 529907 5/3-5/13 100.00 05/21/2019 132 UMPIRE JACOB LIPSCOMB 529908 5/3-5/13 110.00 05/21/2019 133 UMPIRE JORDAN LONG 529909 5/3-5/13 35.00 05/21/2019 134 UMPIRE RAMIRO RENE MARTINEZ 529911 5/3-5/13 20.00 05/21/2019 135 UMPIRE DAVID TYLER MCCURDY 529912 5/3-5/13 140.00 05/21/2019 136 UMPIRE KYLE DEAN MCCURDY 529913 5/3-5/13 115.00 05/21/2019 137 UMPIRE ALEXIS MEYER 529915 5/3-5/13 20.00 05/21/2019 138 UMPIRE BRAD NEMSICK 529918 5/3-5/13 55.00 05/21/2019 139 2019 BASEBALL SCHEDULING FEE MARK PAWLOWSKI 529924 050919 195.00 05/21/2019 140 UMPIRE ROBERT L. RIETZ JR. 529931 050919 80.00 05/21/2019 141 UMPIRE KURTIS TYLER RYAN 529933 5/3-5/13 20.00 05/21/2019 142 UMPIRE TY JAMES SILAS 529937 05/3-05/13 260.00 05/21/2019 143 UMPIRE BEN STEMMET 529938 05/3-05/13 85.00 05/21/2019 144 UMPIRE ZANE STRIKE 529939 05/3-05/13 65.00 05/21/2019 145 UMPIRE PAUL TAEUBER 529940 051119 105.00 05/21/2019 146 UMPIRE NATHANIEL TAGGART 529941 5/3-5/13 55.00 05/21/2019 147 UMPIRE CHRISTOPHER D. TUTTL 529942 05/3-05/13 125.00 05/21/2019 148 UMPIRE JAEDON VAUGHN 529944 05/3-05/13 70.00 05/21/2019 149 UMPIRE IVAN WESTCOTT 529948 05/3-05/13 165.00 05/21/2019 150 UMPIRE HERB WIEGEL 529949 050919 80.00 05/21/2019 151 UMPIRE ALEXANDER VINCENZO W 529950 05/3-05/13 20.00 AP-190528PR 05/28/2019 01 UMPIRE REBEKAH BOHYER 529955 5/14-5/28 25.00 05/28/2019 02 UMPIRE JOSLYN T. BULLINGTON 529982 5/14-5/28 75.00 05/28/2019 03 UMPIRE CONNER FOX 529957 5/14-5/28 60.00 05/28/2019 04 UMPIRE SAM GOLINSKI 529958 5/14-5/28 55.00 05/28/2019 05 UMPIRE JOSHUA HAVERNICK 529959 5/14-5/28 45.00 05/28/2019 06 UMPIRE GEORGE A. JACOBO 529960 5/14-5/28 70.00 05/28/2019 07 UMPIRE ZACHARY STEVEN KAUS 5/14-5/28 20.00 05/28/2019 08 UMPIRE TY KUKIELKA 529962 5/14-5/28 95.00 05/28/2019 09 UMPIRE OWEN LINDSTRAND 529983 5/14-5/28 85.00 05/28/2019 10 UMPIRE JACOB LIPSCOMB 529964 5/14-5/28 55.00 05/28/2019 11 UMPIRE JORDAN LONG 529965 5/14-5/28 70.00 05/28/2019 12 UMPIRE RAMIRO RENE MARTINEZ 529966 5/14-5/28 25.00 05/28/2019 13 UMPIRE DAVID TYLER MCCURDY 529984 5/14-5/28 160.00 05/28/2019 14 UMPIRE KYLE DEAN MCCURDY 529985 5/14-5/28 150.00 05/28/2019 15 UMPIRE ALEXIS MEYER 529986 5/14-5/28 85.00 05/28/2019 16 UMPIRE ROBERT J. PAVLIK 529970 5/14-5/28 55.00 05/28/2019 17 UMPIRE MATTHEW L. RAMEY 529971 5/14-5/28 35.00 05/28/2019 18 UMPIRE KURTIS TYLER RYAN 529987 5/14-5/28 40.00 05/28/2019 19 UMPIRE JONATHAN SCHWEITZER 5/14-5/28 20.00 05/28/2019 20 UMPIRE TY JAMES SILAS 529988 5/14-5/28 90.00 05/28/2019 21 UMPIRE BEN STEMMET 529975 5/14-5/28 60.00 DATE: 09/10/2019 UNITED CITY OF YORKVILLE PAGE: 7TIME: 11:02:57 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 04PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 AP-190528PR 05/28/2019 22 UMPIRE ZANE STRIKE 529976 5/14-5/28 80.00 05/28/2019 23 UMPIRE CHRISTOPHER D. TUTTL 529977 5/14-5/28 40.00 05/28/2019 24 UMPRIE JAEDON VAUGHN 529989 5/14-5/28 40.00 05/28/2019 25 UMPIRE IVAN WESTCOTT 529990 5/14-5/28 50.00 05/28/2019 26 UMPIRE ALEXANDER VINCENZO W 529980 5/14-5/28 40.00 05/28/2019 27 UMPIRE ROYAL WOOLFOLK 5/14-5/28 55.00 AP-190528VD 05/29/2019 01 UMPIRE :VOID 529961 ZACHARY STEVEN KAUS 5/14-5/28 20.00 05/29/2019 02 UMPIRE :VOID 529973 JONATHAN SCHWEITZER 5/14-5/28 20.00 05/29/2019 03 UMPIRE :VOID 529981 ROYAL WOOLFOLK 5/14-5/28 55.00 AP-190529PR 05/29/2019 01 UMPIRE JOSLYN T. BULLINGTON 529982 5/14-5/28 40.00 05/29/2019 02 UMPIRE OWEN LINDSTRAND 529983 5/14-5/28 60.00 05/29/2019 03 UMPIRE DAVID TYLER MCCURDY 529984 5/14-5/28 90.00 05/29/2019 04 UMPIRE KYLE DEAN MCCURDY 529985 5/14-5/28 110.00 05/29/2019 05 UMPIRE ALEXIS MEYER 529986 5/14-5/28 60.00 05/29/2019 06 UMPIRE KURTIS TYLER RYAN 529987 5/14-5/28 20.00 05/29/2019 07 UMPIRE TY JAMES SILAS 529988 5/14-5/28 55.00 05/29/2019 08 UMPRIE JAEDON VAUGHN 529989 5/14-5/28 20.00 05/29/2019 09 UMPIRE IVAN WESTCOTT 529990 5/14-5/28 50.00 GJ-190531FE 05/21/2019 13 PR CC Fees - Apr 2019 997.07 AP-90528VD2 05/29/2019 01 UMPIRE :VOID 529956 JOSLYN T. BULLINGTON 529982 5/14-5/28 75.00 05/29/2019 02 UMPIRE :VOID 529963 OWEN LINDSTRAND 529983 5/14-5/28 85.00 05/29/2019 03 UMPIRE :VOID 529967 DAVID TYLER MCCURDY 529984 5/14-5/28 160.00 05/29/2019 04 UMPIRE :VOID 529968 KYLE DEAN MCCURDY 529985 5/14-5/28 150.00 05/29/2019 05 UMPIRE :VOID 529969 ALEXIS MEYER 529986 5/14-5/28 85.00 05/29/2019 06 UMPIRE :VOID 529972 KURTIS TYLER RYAN 529987 5/14-5/28 40.00 05/29/2019 07 UMPIRE :VOID 529974 TY JAMES SILAS 529988 5/14-5/28 90.00 05/29/2019 08 UMPRIE :VOID 529978 JAEDON VAUGHN 529989 5/14-5/28 40.00 05/29/2019 09 UMPIRE :VOID 529979 IVAN WESTCOTT 529990 5/14-5/28 50.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 7,001.32 870.0002 AP-190611B 06/05/2019 155 UMPIRE JUAN DANIEL AVILA 530015 051819 70.00 06/05/2019 156 UMPIRE MATT BENJAMIN 530017 051619 80.00 06/05/2019 157 UMPIRE DWAYNE F BEYER 530018 051619 80.00 06/05/2019 158 UMPIRE DWAYNE F BEYER 530018 052319 120.00 06/05/2019 159 UMPIRE JAMIE ELENBAAS 530024 051319 35.00 06/05/2019 160 UMPIRE JAMIE ELENBAAS 530024 051819 70.00 06/05/2019 161 UMPIRE MATTHEW J. LAWLESS 530043 051819 70.00 06/05/2019 162 BASEBALL UMPIRE ASSIGNING FEE CYNTHIA O'LEARY YORKVILLE IN HOUSE 2 1,300.00 06/05/2019 163 BASEBALL TOURNAMENT UMPIRE CYNTHIA O'LEARY 530050 YORKVILLE REC 2019 250.00 06/05/2019 164 UMPIRE ROBERT L. RIETZ JR. 530063 051619 80.00 06/05/2019 165 UMPIRE ROBERT L. RIETZ JR. 530063 052319 40.00 06/05/2019 166 UMPIRE HERB WIEGEL 530072 051619 80.00 06/05/2019 167 UMPIRE HERB WIEGEL 530072 052319 160.00 AP-190619M 06/18/2019 01 UMPIRE RAIUMUNDO FONSECA 530078 WOOD BAT 2019 300.00 06/18/2019 02 UMPIRE SAM GOLINSKI 530079 WOOD BAT 2019 150.00 06/18/2019 03 UMPIRE ANDREW HETTINGER 530080 WOOD BAT 2019 100.00 06/18/2019 04 UMPIRE KENNETH ISHAM 530081 WOOD BAT 2019 100.00 06/18/2019 05 UMPIRE MIKE KALISH 530082 WOOD BAT 2019 150.00 DATE: 09/10/2019 UNITED CITY OF YORKVILLE PAGE: 8TIME: 11:02:57 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 04PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________02 AP-190619M 06/18/2019 06 UMPIRE JACOB LIPSCOMB 530083 WOOD BAT 2019 350.00 06/18/2019 07 UMPIRE JACK MODAFF 530084 WOOD BAT 2019 250.00 06/18/2019 08 SCHEDULING OF OFFICIALS CYNTHIA O'LEARY 530085 WOOD BAT 2019 255.00 06/18/2019 09 UMPIRE ROBERT J. PAVLIK 530086 WOOD BAT 2019 50.00 06/18/2019 10 UMPIRE ROBERT L. RIETZ JR. 530087 WOOD BAT 2019 50.00 06/18/2019 11 UMPIRE COLE RUNDLE 530088 WOOD BAT 2019 100.00 06/18/2019 12 UMPIRE MARK RUNYON 530089 WOOD BAT 2019 350.00 06/18/2019 13 UMPIRE VANCE SCHMIDT 530090 WOOD BAT 2019 100.00 06/18/2019 14 UMPIRE NATHANIEL TAGGART 530091 WOOD BAT 2019 50.00 06/18/2019 15 UMPIRE JAMES A. TIETZ 530092 WOOD BAT 2019 300.00 AP-190625B 06/19/2019 194 UMPIRE MATT BENJAMIN 530318 053019 80.00 06/19/2019 195 UMPIRE MATT BENJAMIN 530318 060619 80.00 06/19/2019 196 UMPIRE DWAYNE F BEYER 530319 053019 80.00 06/19/2019 197 UMPIRE DWAYNE F BEYER 530319 060619 80.00 06/19/2019 198 UMPIRE REBEKAH BOHYER 530320 INV 5/29-6/9 85.00 06/19/2019 199 UMPIRE ANTHONY BOULE 530322 INV 5/29-6/9 40.00 06/19/2019 200 UMPIRE JOSLYN T. BULLINGTON 530325 INV 5/29-6/9 20.00 06/19/2019 201 UMPIRE HUMBERTO B. ARROYO 530326 INV 5/29-6/9 60.00 06/19/2019 202 UMPIRE JACOB CARLSON 530330 INV 5/29-6/9 20.00 06/19/2019 203 STRONG FITNESS CLASS KAYLA DJIDIC 530336 0001 175.00 06/19/2019 204 UMPIRE SARA R. EBNER 530339 INV 5/29-6/9 20.00 06/19/2019 205 UMPIRE GARY R FORD JR 530346 INV 5/29-6/9 55.00 06/19/2019 206 UMPIRE SAM GOLINSKI 530347 INV 5/29-6/9 55.00 06/19/2019 207 UMPIRE JOSHUA HAVERNICK 530349 INV 5/29-6/9 80.00 06/19/2019 208 UMPIRE ANDREW HETTINGER 530351 INV 5/29-6/9 165.00 06/19/2019 209 UMPIRE MICHAEL HILKER 530352 INV 5/29-6/9 20.00 06/19/2019 210 UMPIRE JAREK DANIEL HOTWANG 530353 INV 5/29-6/9 55.00 06/19/2019 211 MAY 2019 COPIER CHARGES IMPACT NETWORKING, L 530354 1447604 129.36 06/19/2019 212 UMPIRE GEORGE A. JACOBO 530360 INV 5/29-6/9 35.00 06/19/2019 213 UMPIRE ZACHARY STEVEN KAUS 530361 INV 5/29-6/9 190.00 06/19/2019 214 UMPIRE TY KUKIELKA 530364 INV 5/29-6/9 35.00 06/19/2019 215 UMPIRE OWEN LINDSTRAND 530365 INV 5/29-6/9 125.00 06/19/2019 216 UMPIRE JORDAN LONG 530366 INV 5/29-6/9 20.00 06/19/2019 217 UMPIRE DAVID TYLER MCCURDY 530369 INV 5/29-6/9 105.00 06/19/2019 218 UMPIRE KYLE DEAN MCCURDY 530370 INV 5/29-6/9 90.00 06/19/2019 219 UMPIRE ALEXIS MEYER 530372 INV 5/29-6/9 95.00 06/19/2019 220 UMPIRE JOSHUA CALEB MEYERS 530373 INV 5/29-6/9 70.00 06/19/2019 221 UMPIRE MICHAEL T. MILLER 530375 060219 70.00 06/19/2019 222 UMPIRE HANNAH MONTELAURO 530376 INV 5/29-6/9 70.00 06/19/2019 223 UMPIRE MATTHEW L. RAMEY 530389 INV 5/29-6/9 35.00 06/19/2019 224 UMPIRE ROBERT L. RIETZ JR. 530391 053019 80.00 06/19/2019 225 UMPIRE ROBERT L. RIETZ JR. 530391 060619 80.00 06/19/2019 226 UMPIRE MARK RUNYON 530392 INV 5/29-6/9 60.00 06/19/2019 227 UMPIRE KURTIS TYLER RYAN 530393 INV 5/29-6/9 45.00 06/19/2019 228 UMPIRE JONATHAN SCHWEITZER 530394 INV 5/29-6/9 65.00 06/19/2019 229 UMPIRE KEVIN SERIO JR 530395 INV 5/29-6/9 55.00 06/19/2019 230 UMPIRE TY JAMES SILAS 530396 INV 5/29-6/9 70.00 06/19/2019 231 UMPIRE BEN STEMMET 530400 INV 5/29-6/9 60.00 DATE: 09/10/2019 UNITED CITY OF YORKVILLE PAGE: 9TIME: 11:02:57 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 04PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________02 AP-190625B 06/19/2019 232 UMPIRE ZANE STRIKE 530403 INV 5/29-6/9 80.00 06/19/2019 233 UMPIRE CHRISTOPHER D. TUTTL 530405 INV 5/29-6/9 65.00 06/19/2019 234 UMPRIE JAEDON VAUGHN 530408 INV 5/29-6/9 40.00 06/19/2019 235 UMPIRE WILLIAM WEEKS 530410 INV 5/29-6/9 55.00 06/19/2019 236 UMPIRE IVAN WESTCOTT 530412 INV 5/29-6/9 140.00 06/19/2019 237 UMPIRE HERB WIEGEL 530414 053019 80.00 06/19/2019 238 UMPIRE HERB WIEGEL 530414 060619 80.00 06/19/2019 239 UMPIRE ALEXANDER VINCENZO W 530415 INV 5/29-6/9 20.00 06/19/2019 240 UMPIRE DAVID WOLLNIK 530417 INV 5/29-6/9 60.00 GJ-190630FE 06/24/2019 13 PR CC Fees - May 2019 1,383.81 _________________________________ TOTAL PERIOD 02 ACTIVITY 9,848.17 0.0003 AP-072919VD 07/29/2019 01 SUMMER 2019 TOT RO:VOID 530630 ROCK 'N' KIDS, INC. YRKSU19 329.00 AP-190709 07/01/2019 191 UMPIRE ALJO AMORELLI 530429 061319 40.00 07/01/2019 192 UMPIRE ALJO AMORELLI 530429 062019 60.00 07/01/2019 193 UMPIRE MATT BENJAMIN 530435 062019 80.00 07/01/2019 194 UMPIRE DWAYNE F BEYER 530436 061319 100.00 07/01/2019 195 UMPIRE DWAYNE F BEYER 530436 062019 80.00 07/01/2019 196 UMPIRE REBEKAH BOHYER 530438 JUN 10-23 110.00 07/01/2019 197 UMPIRE ANTHONY BOULE 530439 JUN 10-23 80.00 07/01/2019 198 CHICAGO WHITE SOX SUMMER CAMP ROCLAB ATHLETIC INST 530441 8953 950.00 07/01/2019 199 UMPIRE GARY M. DIETER 530445 061219 75.00 07/01/2019 200 UMPUIRE GARY M. DIETER 530445 061919 50.00 07/01/2019 201 UMPIRE SARA R. EBNER 530448 JUN 10-23 35.00 07/01/2019 202 UMPIRE GARY R FORD JR 530452 061219 50.00 07/01/2019 203 UMPIRE COLIN GLASS 530454 JUN 10-23 40.00 07/01/2019 204 UMPIRE JOSHUA HAVERNICK 530457 JUN 10-23 80.00 07/01/2019 205 UMPIRE ANDREW HETTINGER 530460 JUN 10-23 110.00 07/01/2019 206 UMPIRE MICHAEL HILKER 530461 JUN 10-23 35.00 07/01/2019 207 UMPIRE GEORGE A. JACOBO 530468 JUN 10-23 70.00 07/01/2019 208 UMPIRE ZACHARY STEVEN KAUS 530472 JUN 10-23 85.00 07/01/2019 209 UMPIRE TY KUKIELKA 530474 JUN 10-23 105.00 07/01/2019 210 UMPIRE OWEN LINDSTRAND 530476 JUN 10-23 20.00 07/01/2019 211 UMPIRE DAVID TYLER MCCURDY 530478 JUN 10-23 110.00 07/01/2019 212 UMPIRE KYLE DEAN MCCURDY 530479 JUN 10-23 130.00 07/01/2019 213 UMPIRE JOSHUA CALEB MEYERS 530482 JUN 10-23 35.00 07/01/2019 214 UMPIRE MICHAEL T. MILLER 530484 060919 35.00 07/01/2019 215 UMPIRE JACK MODAFF 530485 JUN 10-23 55.00 07/01/2019 216 UMPIRE HANNAH MONTELAURO 530486 JUN 10-23 105.00 07/01/2019 217 UMPIRE ROBERT MOSER 530487 061219 50.00 07/01/2019 218 UMPIRE MARTY MUNNS 530489 061319 75.00 07/01/2019 219 UMPIRE MARTY MUNNS 530489 061919 75.00 07/01/2019 220 UMPIRE BRAD NEMSICK 530490 JUN 10-23 55.00 07/01/2019 221 UMPIRE STEVE PEARSON 530495 JUN 10-23 120.00 07/01/2019 222 UMPIRE MATTHEW L. RAMEY 530501 JUN 10-23 35.00 07/01/2019 223 UMPIRE GRANT RIEHLE-MOELLER 530502 061219 50.00 07/01/2019 224 UMPIRE GRANT RIEHLE-MOELLER 530502 061919 75.00 07/01/2019 225 UMPIRE BENJAMIN RIETZ 530503 061319 40.00 DATE: 09/10/2019 UNITED CITY OF YORKVILLE PAGE: 10TIME: 11:02:57 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 04PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________03 AP-190709 07/01/2019 226 UMPIRE BENJAMIN RIETZ 530503 062019 60.00 07/01/2019 227 UMPIRE ROBERT L. RIETZ JR. 530504 061319 60.00 07/01/2019 228 UMPIRE ROBERT L. RIETZ JR. 530504 062019 40.00 07/01/2019 229 UMPIRE ROBERT L. RIETZ JR. 530504 JUN 10-23 60.00 07/01/2019 230 UMPIRE MARK RUNYON 530505 JUN 10-23 55.00 07/01/2019 231 UMPIRE KURTIS TYLER RYAN 530506 JUN 10-23 85.00 07/01/2019 232 UMPIRE JONATHAN SCHWEITZER 530507 JUN 10-23 40.00 07/01/2019 233 ASHI CHILD AND BABYSITTING SECOND CHANCE CARDIA 530508 19-006-292 315.00 07/01/2019 234 UMPIRE KEVIN SERIO JR 530509 JUN 10-23 25.00 07/01/2019 235 UMPIRE TY JAMES SILAS 530511 JUN 10-23 105.00 07/01/2019 236 UMPIRE BEN STEMMET 530512 JUN 10-23 70.00 07/01/2019 237 UMPIRE ZANE STRIKE 530513 JUN 10-23 195.00 07/01/2019 238 UMPIRE JAMES A. TIETZ 530515 JUN 10-23 115.00 07/01/2019 239 UMPIRE CHRISTOPHER D. TUTTL 530517 JUN 10-23 45.00 07/01/2019 240 UMPIRE JOE VASCIK 530520 061919 50.00 07/01/2019 241 UMPRIE JAEDON VAUGHN 530521 JUN 10-23 185.00 07/01/2019 242 UMPIRE BOB VELA 530522 JUN 10-23 60.00 07/01/2019 243 UMPIRE WILLIAM WEEKS 530523 061919 50.00 07/01/2019 244 UMPIRE WILLIAM WEEKS 530523 JUN 10-23 55.00 07/01/2019 245 UMPIRE IVAN WESTCOTT 530524 JUN 10-23 35.00 07/01/2019 246 UMPIRE HERB WIEGEL 530526 061319 80.00 07/01/2019 247 UMPIRE DAVID WOLNIK 530528 JUN 10-23 110.00 AP-190723 07/17/2019 293 UMPIRE ALJO AMORELLI 530538 062719 80.00 07/17/2019 294 YOUTH PERSONAL TRAINING FRANK E. BADUS 530544 PLF62419 192.00 07/17/2019 295 UMPIRE MATT BENJAMIN 530546 062719 80.00 07/17/2019 296 UMPIRE DWAYNE F BEYER 530548 062719 80.00 07/17/2019 297 UMPIRE REBEKAH BOHYER 530549 JUNE 24-JULY 7 80.00 07/17/2019 298 UMPIRE ANTHONY BOULE 530550 JUNE 24-JULY 7 80.00 07/17/2019 299 UMPIRE HUMBERTO B. ARROYO 530552 JUNE 24-JULY 7 170.00 07/17/2019 300 REFEREE GARY M. DIETER 530562 062619 75.00 07/17/2019 301 ZUMBA CLASS INSTRUCTION KAYLA DJIDIC 530563 0002 220.50 07/17/2019 302 UMPIRE RAIUMUNDO FONSECA 530576 JUNE 24-JULY 7 60.00 07/17/2019 303 UMPIRE ANDREW GOLINSKI 530578 JUNE 24-JULY 7 20.00 07/17/2019 304 UMPIRE SAM GOLINSKI 530579 JUNE 24-JULY 7 55.00 07/17/2019 305 UMPIRE ALLEN R. GOSS 530581 JUNE 24-JULY 7 110.00 07/17/2019 306 UMPIRE ANDREW HETTINGER 530586 JUNE 24-JULY 7 60.00 07/17/2019 307 UMPIRE JAREK DANIEL HOTWANG 530587 JUNE 24-JULY 7 55.00 07/17/2019 308 UMPIRE WILLIAM HRUBES 530588 JUNE 24-JULY 7 55.00 07/17/2019 309 BACKGROUND CHECKS ILLINOIS STATE POLIC 530591 053119 310.75 07/17/2019 310 5/29-6/28 COPIER CHARGES IMPACT NETWORKING, L 530594 1475388 45.63 07/17/2019 311 UMPIRE MATTHEW J. LAWLESS 530599 062619 50.00 07/17/2019 312 UMPIRE JOSHUA S LINDHOLM 530601 JUNE 24-JULY 7 55.00 07/17/2019 313 UMPIRE JACOB LIPSCOMB 530602 JUNE 24-JULY 7 55.00 07/17/2019 314 UMPIRE KYLE DEAN MCCURDY 530603 JUNE 24-JULY 7 40.00 07/17/2019 315 UMPIRE MICHAEL T. MILLER 530606 062319 35.00 07/17/2019 316 UMPIRE JACK MODAFF 530607 JUNE 24-JULY 7 330.00 07/17/2019 317 UMPIRE HANNAH MONTELAURO 530608 JUNE 24-JULY 7 40.00 07/17/2019 318 UMPIRE ROBERT MOSER 530609 062619 75.00 DATE: 09/10/2019 UNITED CITY OF YORKVILLE PAGE: 11TIME: 11:02:57 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 04PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________03 AP-190723 07/17/2019 319 UMPIRE JON MUEHLBAUER 530610 JUNE 24-JULY 7 55.00 07/17/2019 320 UMPIRE MARTY MUNNS 530611 062619 75.00 07/17/2019 321 UMPIRE BRAD NEMSICK 530613 JUNE 24-JULY 7 110.00 07/17/2019 322 ASSIGNING FEE FOR OFFICIALS CYNTHIA O'LEARY 530616 SUMMER YOUTH BK 2019 300.00 07/17/2019 323 ASSIGNING FEE FOR OFFICIALS CYNTHIA O'LEARY YORKVILLE IN HOUSE 2 1,600.00 07/17/2019 324 UMPIRE GRANT RIEHLE-MOELLER 530627 062619 75.00 07/17/2019 325 UMPIRE BENJAMIN RIETZ 530628 062719 80.00 07/17/2019 326 UMPIRE ROBERT L. RIETZ JR. 530629 062719 80.00 07/17/2019 327 UMPIRE ROBERT L. RIETZ JR. 530629 JUNE 24-JULY 7 110.00 07/17/2019 328 SUMMER 2019 TOT ROCK CLASSES ROCK 'N' KIDS, INC. YRKSU19 329.00 07/17/2019 329 UMPIRE KURTIS TYLER RYAN 530632 JUNE 24-JULY 7 60.00 07/17/2019 330 UMPIRE KEVIN SERIO JR 530636 JUNE 24-JULY 7 25.00 07/17/2019 331 UMPIRE TY JAMES SILAS 530638 JUNE 24-JULY 7 25.00 07/17/2019 332 UMPIRE TIM SIPES 530639 JUNE 24-JULY 7 55.00 07/17/2019 333 UMPIRE BEN STEMMET 530642 JUNE 24-JULY 7 35.00 07/17/2019 334 UMPIRE ZANE STRIKE 530644 JUNE 24-JULY 7 40.00 07/17/2019 335 UMPIRE JAMES A. TIETZ 530646 JUNE 24-JULY 7 110.00 07/17/2019 336 UMPIRE CHRISTOPHER D. TUTTL 530649 JUNE 24-JULY 7 35.00 07/17/2019 337 UMPRIE JAEDON VAUGHN 530652 JUNE 24-JULY 7 20.00 07/17/2019 338 UMPIRE BOB VELA 530653 JUNE 24-JULY 7 110.00 07/17/2019 339 UMPIRE WILLIAM WEEKS 530654 JUNE 24-JULY 7 115.00 07/17/2019 340 UMPIRE IVAN WESTCOTT 530656 JUNE 24-JULY 7 70.00 07/17/2019 341 UMPIRE DAVID WOLNIK 530657 JUNE 24-JULY 7 55.00 07/17/2019 342 UMPIRE ROYAL WOOLFOLK 530658 JUNE 24-JULY 7 55.00 07/17/2019 343 UMPIRE JOEL WYETH 530661 JUNE 24-JULY 7 60.00 AP-190725M 07/22/2019 126 PHYSICIANS CARE-DRUG TESTING FIRST NATIONAL BANK 900077 072519-R.WRIGHT 86.00 07/22/2019 127 LISA LOMBARDI COACHING-JUNE FIRST NATIONAL BANK 900077 072519-S.REDMON 87.50 07/22/2019 128 VERMONT SYSTEMS-REC TRAC FIRST NATIONAL BANK 900077 072519-S.REDMON 5,250.00 07/22/2019 129 ARCHERY PLACE-MAY ARCHERY FIRST NATIONAL BANK 900077 072519-T.NELSON 120.00 07/22/2019 130 ARCHERY PLACE-JUNE ARCHERY FIRST NATIONAL BANK 900077 072519-T.NELSON 80.00 GJ-190731FE 08/02/2019 13 PR CC Fees - June 2019 1,847.95 CR-P190709 07/09/2019 90 172725 1,847.95 07/09/2019 91 172731 1,847.95 _________________________________ TOTAL PERIOD 03 ACTIVITY 20,707.28 2,176.9504 AP-190813 08/06/2019 337 SUMMER I 2019 SPORTS CLASS ALL STAR SPORTS INST 530666 194052 9,930.00 08/06/2019 338 UMPIRE ALJO AMORELLI 530671 071119 120.00 08/06/2019 339 UMPIRE ALJO AMORELLI 530671 071819 120.00 08/06/2019 340 UMPIRE ALJO AMORELLI 530671 072519 80.00 08/06/2019 341 UMPIRE MATT BENJAMIN 530685 071819 100.00 08/06/2019 342 UMPIRE MATT BENJAMIN 530685 072519 80.00 08/06/2019 343 UMPIRE DWAYNE F BEYER 530686 071119 120.00 08/06/2019 344 UMPIRE DWAYNE F BEYER 530686 071819 80.00 08/06/2019 345 UMPIRE DWAYNE F BEYER 530686 072519 80.00 08/06/2019 346 UMPIRE REBEKAH BOHYER 530688 JULY 8-JULY 28 25.00 08/06/2019 347 RUGBY CAMP INSTRUCTION WAUBONSEE VALLEY RUG 530693 1001 472.50 08/06/2019 348 UMPIRE GARY M. DIETER 530699 071019 75.00 08/06/2019 349 UMPIRE GARY M. DIETER 530699 071719 75.00 DATE: 09/10/2019 UNITED CITY OF YORKVILLE PAGE: 12TIME: 11:02:57 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 04PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________04 AP-190813 08/06/2019 350 ZUMBA CLASS INSTRUCTION KAYLA DJIDIC 530700 0003 168.00 08/06/2019 351 UMPIRE SARA R. EBNER 530704 JULY 8-JULY 28 100.00 08/06/2019 352 UMPIRE GARY R FORD JR 530716 071019 50.00 08/06/2019 353 UMPIRE ANDREW HETTINGER 530725 JULY 8-JULY 28 120.00 08/06/2019 354 BACKGROUND CHECKS ILLINOIS STATE POLIC 530728 063019 56.50 08/06/2019 355 06/29-07/28 COPIER CHARGES IMPACT NETWORKING, L 530731 1500632 88.12 08/06/2019 356 SPACE ADVENTURE CAMP JMC VENTURES, LLC 530735 071719 105.00 08/06/2019 357 JULY MAGIC CLASS GARY KANTOR 530737 JULY 2019 75.00 08/06/2019 358 UMPIRE MATTHEW J. LAWLESS 530740 071719 50.00 08/06/2019 359 UMPIRE STEPHEN LINDSTROM 530744 071719 50.00 08/06/2019 360 UMPIRE MICHAEL T. MILLER 530757 072119 140.00 08/06/2019 361 UMPIRE JACK MODAFF 530758 JULY 8-JULY 28 60.00 08/06/2019 362 UMPIRE ROBERT MOSER 530760 071019 75.00 08/06/2019 363 UMPIRE MARTY MUNNS 530762 071019 50.00 08/06/2019 364 UMPIRE MARTY MUNNS 530762 071719 75.00 08/06/2019 365 UMPIRE GRANT RIEHLE-MOELLER 530786 071019 50.00 08/06/2019 366 UMPIRE GRANT RIEHLE-MOELLER 530786 071719 50.00 08/06/2019 367 UMPIRE BENJAMIN RIETZ 530787 071119 120.00 08/06/2019 368 UMPIRE BENJAMIN RIETZ 530787 071819 80.00 08/06/2019 369 UMPIRE BENJAMIN RIETZ 530787 072519 80.00 08/06/2019 370 UMPIRE ROBERT L. RIETZ JR. 530788 071119 40.00 08/06/2019 371 UMPIRE ROBERT L. RIETZ JR. 530788 071819 40.00 08/06/2019 372 UMPIRE TY JAMES SILAS 530792 JULY 8-JULY 28 50.00 08/06/2019 373 UMPIRE WILLIAM WEEKS 530802 JULY 8-JULY 28 180.00 08/06/2019 374 UMPIRE DAVID WOLNIK 530808 JULY 8-JULY 28 60.00 AP-190825M 08/15/2019 155 PHYSICIANS CARE-DRUG TESTS FIRST NATIONAL BANK 900078 082519-R.WRIGHT 215.00 08/15/2019 156 PETITE PALETTE-YOUTUBE VIDEO FIRST NATIONAL BANK 900078 082519-S.REDMON 650.00 08/15/2019 157 ROC'N'KIDS-SUMMER TOT ROCK FIRST NATIONAL BANK 900078 082519-S.REDMON 329.00 08/15/2019 158 LISA LOMBARDI-THRILLS & FIRST NATIONAL BANK 900078 082519-S.REDMON 170.10 08/15/2019 159 ARCHERY PLACE-JULY 2019 FIRST NATIONAL BANK 900078 082519-T.NELSON 575.00 AP-190827 08/20/2019 223 JUNE 26-30 SOCCER CAMP 5 STAR SOCCER CAMPS 530817 062519 1,200.00 08/20/2019 224 UMPIRE ANDREW HETTINGER 530852 JUL29-AUG11 60.00 08/20/2019 225 UMPIRE OWEN LINDSTRAND 530862 JUL29-AUG11 75.00 GJ-190831FE 08/29/2019 19 PR CC Fees - July 2019 2,098.55 _________________________________ TOTAL PERIOD 04 ACTIVITY 18,742.77 0.00 YTD BUDGET 33,333.36 TOTAL ACCOUNT ACTIVITY 56,299.54 3,046.95 ANNUAL REVISED BUDGET 100,000.00 ENDING BALANCE 53,252.59_____________________________________________________________________________________________________________________________________________________82-820-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 AP-190513B 05/06/2019 07 MAY 2019 COPIER LEASE DLL FINANCIAL SERVIC 104704 63218016 194.48 05/06/2019 08 MAINTENANCE CONTRACT CHARGE SOUND INCORPORATED 104709 R161038 929.52 05/06/2019 09 06/278/19-06/26/20 ANNUAL TODAY'S BUSINESS SOL 104711 9268 2,644.00 AP-190528B 05/21/2019 162 JUN 2019 COPIER LEASE DLL FINANCIAL SERVIC 529882 63564126 194.48 GJ-90520PRE 05/21/2019 54 Sound Inc May 2019 Srvc Agrmnt 97.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 4,059.48 0.0002 AP-190610B 06/04/2019 03 07/01/20-06/30/21 CATEGORY 1 E-RATE FUND SERVICES 104722 299 350.00 DATE: 09/10/2019 UNITED CITY OF YORKVILLE PAGE: 13TIME: 11:02:57 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 04PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________82-820-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________02 AP-190610B 06/04/2019 04 MAY 2019 ON SITE IT SUPPORT LLOYD WARBER 104724 10453 720.00 06/04/2019 05 JUNE - AUG SILVER SERVICE SOUND INCORPORATED 104726 R161625 291.00 06/04/2019 06 05/01-07/31 ELEVATOR THYSSENKRUPP ELEVATO 104727 3004582070 542.22 06/04/2019 07 05/13/19 MEETING MINUTES MARLYS J. YOUNG 104729 051319 79.50 _________________________________ TOTAL PERIOD 02 ACTIVITY 1,982.72 0.0003 AP-190708 07/01/2019 04 JULY 2019 COPIER LEASE DLL FINANCIAL SERVIC 104732 63957683 194.48 07/01/2019 05 JUNE 2019 ON SITE IT SUPPORT LLOYD WARBER 104733 10454 720.00 07/01/2019 06 ANNUAL FEE RENEWAL FOR WEBLINX INCORPORATED 104740 27527 200.00 AP-190723 07/17/2019 360 06/10/19 MEETING MINUTES MARLYS J. YOUNG 530662 061019 66.25 _________________________________ TOTAL PERIOD 03 ACTIVITY 1,180.73 0.0004 AP-190812 08/05/2019 03 AUG 2019 COPIER LEASE DLL FINANCIAL SERVIC 104744 64205724 194.48 08/05/2019 04 2019 ANNUAL INSPECTIONS GREAT LAKES PLUMBING 104746 18861 450.00 08/05/2019 05 04/15-07/14 COPIER OVERAGES IMPACT NETWORKING, L 104747 1496722 139.51 08/05/2019 06 AUG-OCT 2019 MAINTENANCE SOUND INCORPORATED 104756 R162440 929.52 08/05/2019 07 2ND QTR COST FOR FAX TBS CONSTRUCTION 104757 072919-7 43.52 08/05/2019 08 047/08/19 MEETING MINUTES MARLYS J. YOUNG 104761 070819 61.25 AP-190813 08/06/2019 402 JULY 2019 ON-SITE IT SUPPORT LLOYD WARBER 530745 10460 1,110.00 AP-190825M 08/15/2019 199 LIBERTY MUTUAL-SURETY BOND FIRST NATIONAL BANK 900078 082519-A.SIMMONS 456.00 _________________________________ TOTAL PERIOD 04 ACTIVITY 3,384.28 0.00 YTD BUDGET 13,333.36 TOTAL ACCOUNT ACTIVITY 10,607.21 0.00 ANNUAL REVISED BUDGET 40,000.00 ENDING BALANCE 10,607.21_____________________________________________________________________________________________________________________________________________________87-870-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.0004 AP-190827 08/20/2019 239 COUNTRYSIDE TIF MATTERS KATHLEEN FIELD ORR & 1341 15985 129.00 _________________________________ TOTAL PERIOD 04 ACTIVITY 129.00 0.00 YTD BUDGET 666.68 TOTAL ACCOUNT ACTIVITY 129.00 0.00 ANNUAL REVISED BUDGET 2,000.00 ENDING BALANCE 129.00_____________________________________________________________________________________________________________________________________________________88-880-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 0.00 YTD BUDGET 333.36 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 1,000.00 ENDING BALANCE 0.00 GRAND TOTAL 145,918.30 0.00 TOTAL DIFFERENCE 145,918.30 0.00 Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #2 Tracking Number ADM 2019-50 Monthly Treasurer’s Report for August 2019 Administration Committee – September 18, 2019 Majority Approval Rob Fredrickson Finance Name Department Beginning Fund Balance August Revenues YTD Revenues Revenue Budget % of Budget August Expenses YTD Expenses Expense Budget % of Budget Projected Ending Fund Balance General Fund01 - General 6,879,823$ 1,339,463$ 6,332,613$ 16,469,238$ 38% 1,057,166$ 4,757,844$ 16,719,238$ 28% 8,454,592$ Special Revenue Funds15 - Motor Fuel Tax 635,382 71,208 190,867 534,904 36% 6,149 492,299 718,788 68% 333,950 79 - Parks and Recreation 452,914 168,004 851,327 2,244,988 38% 215,942 816,010 2,343,405 35% 488,231 72 - Land Cash 211,832 4,380 418,137 58,435 716% 5,035 5,035 104,850 5% 624,934 87 - Countryside TIF (422,459) 31,741 96,993 232,318 42% 1,068 56,673 923,808 6% (382,139) 88 - Downtown TIF (1,024,518) 2,477 42,384 80,000 53% 3,415 232,168 426,484 54% (1,214,302) 89 - Downtown TIF II (2,736) 373 12,520 - 0% 1,387 2,139 35,000 6% 7,645 11 - Fox Hill SSA 10,485 370 7,505 13,381 56% 1,202 3,559 30,977 11% 14,430 12 - Sunflower SSA (22,626) 322 9,532 18,140 53% 1,059 5,334 13,977 38% (18,429) Debt Service Fund42 - Debt Service - 27,863 112,252 324,025 35% 475 17,250 324,025 5% 95,002 Capital Project Funds25 - Vehicle & Equipment 496,042 8,945 74,220 161,112 46% 6,939 40,410 516,470 8% 529,852 23 - City-Wide Capital 629,429 148,246 424,170 4,172,029 10% 146,019 362,108 4,798,408 8% 691,490 Enterprise Funds *51 - Water 3,533,027 765,223 1,654,323 4,699,931 35% 454,939 1,033,152 5,770,144 18% 4,154,198 *52 - Sewer 1,110,251 298,290 749,121 2,149,679 35% 96,654 392,919 2,538,097 15% 1,466,454 Library Funds82 - Library Operations 554,271 60,044 868,382 1,576,751 55% 59,226 336,058 1,620,345 21% 1,086,595 84 - Library Capital 83,260 2,862 24,559 50,100 49% 2,867 9,516 75,500 13% 98,303 Total Funds 13,124,377$ 2,929,811$ 11,868,903$ 32,785,031$ 36% 2,059,541$ 8,562,475$ 36,959,516$ 23% 16,430,805$ * Fund Balance EquivalencyRob Fredrickson, Finance Director/TreasurerUNITED CITY OF YORKVILLE TREASURER'S REPORT - for the month ending August 31, 2019Cash BasisAs Treasurer of the United City of Yorkville, I hereby attest, to the best of my knowledge, that the information contained in this Treasurer's Report is accurate as of the date detailed herein. Further information is available in the Finance Department. Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #3 Tracking Number ADM 2019-51 Cash Statement for July 2019 Administration Committee – September 18, 2019 Informational None Rob Fredrickson Finance Name Department GrandRestricted atFirst National West Suburban Associated Illinois Funds Old SecondTotalsIMETGeneral Fund01 - General 741,737 177,838 1,903,485 3,579,252 - 6,402,312 82,415 Special Revenue Funds15 - Motor Fuel Tax - - - 252,550 - 252,550 - 72 - Land Cash (92,615) - - - - (92,615) - 87 - Countryside TIF (412,813) - - - - (412,813) - 88 - Downtown TIF (1,147,987) - - - - (1,147,987) - 89 - Downtown TIF II 8,658 - - - - 8,658 - 11 - Fox Hill SSA 15,262 - - - - 15,262 - 12 - Sunflower SSA (17,692) - - - - (17,692) - Debt Service Fund42 - Debt Service 67,614 - - - - 67,614 - Capital Project Funds23 - City-Wide Capital 229,817 109,164 688,172 - - 1,027,153 103,868 25 - Police Capital 23,325 - - - - 23,325 - 25 - General Gov Capital(13,999) - - - - (13,999) - 25 - Public Works Capital110,964 - - - - 110,964 - Enterprise Funds51 - Water1,818,851 581,283 851,962 - - 3,252,096 13,808 52 - Sewer627,134 197,588 314,789 - - 1,139,511 64,896 Agency Funds90 - Developer Escrow 208,959 - - - - 208,959 - 95 - Escrow Deposit(169,386) 484,716 - - - 315,330 - Total City Funds1,997,829 1,550,589 3,758,407 3,831,803 - 11,138,628 264,987 Distribution %17.94% 13.92% 33.74% 34.40%Library Funds82 - Library Operations54 - - 212,444 589,387 801,885 8,007 84 - Library Capital7,300 - - - 89,174 96,474 - Library Totals 7,354 - - 212,444 678,561 898,359 8,007 Distribution % 0.82% 23.65% 75.53%Park and Recreation Funds79 - Parks and Recreation 501,089 - - - - 501,089 - 25 - Park & Rec Capital406,114 - - - - 406,114 2,371 Park & Rec Totals907,203 - - - - 907,203 2,371 Distribution % 100.00%UNITED CITY OF YORKVILLECASH AND INVESTMENT SUMMARY - as of July 31, 2019Cash Summary 1 FinancialAccrued Type of Investment Institution FDIC # Interest Rate Original Cost Maturity Date Interest to Date Value at Maturity FundCertificate of Deposit (CD)Pacific Western Bank24045 2.49% 246,900$ 8/28/2019 2,559$ 249,930$ General (01)Certificate of Deposit (CD) Servisfirst Bank 57993 2.41% 247,000$ 9/30/2019 1,960$ 249,957$ General (01)Certificate of Deposit (CD) Sonabank 57968 2.49% 243,800$ 6/17/2020 715$ 249,868$ General (01)737,700$ 5,234$ 749,756$ UNITED CITY OF YORKVILLECASH AND INVESTMENT SUMMARY - as of July 31, 2019Investments Summary Investment Totals2 Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #4 Tracking Number ADM 2019-52 Monthly Website Report for August 2019 Administration Committee – September 18, 2019 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 August 2019. Background Every month at the Administration Committee meeting, the website data from the previous month will be highlighted. This month’s highlight is August 1, 2019 – August 31, 2019. Website Visits:   Aug  2018  Sept  2018  Oct  2018  Nov  2018  Dec  2018  Jan  2019  Feb  2019  March 2019  April  2019  May  2019  June  2019  July  2019  Aug  2019  Unique  Visitors 17,304  13,355  11,767  11,767  8,087  10,376  9,678  11,781  13,911  13,163  17,246  21,699  20,358  Returning  Visits 8,400  7,297  6,028  4,833  3,597  4,826  4,546  5,134  7,223  6,377  8,412  10,546  9,629  Total Visits 22,488  17,460  15,172  9,862  9,965  13,237  12,233  14,775  18,271  17,219  22,768  20,020  27,106  Visit Times (Averages):  2 minutes 42 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: September 18, 2019 Subject: Website Report for August 2019 Website Statistics: June 2019 July 2019 August 2019i Top 5 Pages Visited 1.Homepage 2. Facilities Feature Overview 3. Parks & Recreation Main Page 4. Online Utility Payments 5. My Gov Hub 1.Homepage 2. Fourth of July Celebration 3. River Fest 4. Facilities Feature Overview 5. Job Opportunities 1. Hometown Days Festival 2. Homepage 3. Facilities Feature Overview 4. Online Utility Payments 5. My Gove Hub July 2019 July 2019 August 2019ii Top 5 Downloads 1. Senior Services and Programs 2. Privacy Policy 3. Residential Permit Application 4.Yak Shack Flyer 5. Parade Route 1. Parade Route 2. Yak Shack Flyer 3. Residential Permit Application 4.Downtown Festival Parking 5. Marge Cline Whitewater Course 1. Hometown Days Schedule 2. Privacy Policy 3. Residential Permit Application 4.Senior Services & Programs 5. Marge Cline Whitewater Course June 2019 July 2019 August 2019 Top 5 Searches 1. Garbage 2. Jobs (Employment Opportunities was 3rd and Employment was 4th) 3. Solicitor 4. True 5. Water 1. Jobs (Employment was 2nd and Employment Opportunities was 3rd) 2. Fireworks 3. True 4. Baseball 5. Garbage 1. Employment (Jobs was 2nd and Employment Opportunities was 3rd) 2. Yorkville Hometown Days Festival 3. Hometown Days 4. Zoning Map 5. Brush/Refuse Pick-up June 2019 July 2019 August 2019 Top 5 Website Referrers 1. Facebook 2. patch.com 3. mykidlist.com 4.r.search.aol.com 5.search.xfinity.com 1. Facebook 2. patch.com 3. search.xfinity.com 4. mykidlist.com 5.ohiofestivals.net 1. Facebook 2. enjoyaurora.com 3. 7thheavenband.com 4. bandsintown.com 5.patch.com City Facebook Data: August 2019 Total Page Followers: 5,158 (an increase of 102 followers from July) Total Page Likes: 5,035 Total Average Reach: 3,436 Highest Viewed Post: “What a special day today was…reveal party with the Make A Wish Foundation…” (Posted August 18, 2019 at 4:31 pm) Highest Viewed Post Reach: 13,666; 1,19 Post Clicks; 4,862 Reactions, Comments & Shares Parks and Recreation Facebook Data: August 2019 Total Page Followers: 2,909 (an increase of 87 followers from July) Total Page Likes: 2,875 Total Average Reach: 1,420 Highest Viewed Post: “New Zumba Fitness Class on Tuesdays…” (Posted August 15, 2019, 10:00 am) Highest Viewed Post Reach: 3,434; 104 Post Clicks; 269 Reactions, Comments & Shares City Twitter Data: August 2019 Total Followers: 1,610 (an increase in 8 followers from July) Total Tweet Impressions: 9,952 Total Profile Visits: 144 Yorkville Twitter Mentions: 7 Top Tweet (earned 1,073 Impressions): “Jim Jensen was sworn in as the Chief of Police…” Recommendation: This is an informational item. ihttps://www.yorkville.il.us/459/Hometown-Days-Festival; https://www.yorkville.il.us/; https://www.yorkville.il.us/facilities/featureoverview; https://www.yorkville.il.us/131/Online-Utility-Payments; https://www.yorkville.il.us/573/MyGovHub-Transition-Page ii https://www.yorkville.il.us/DocumentCenter/View/6183/2019-HTD-Schedule?bidId=; https://www.yorkville.il.us/124/Privacy-Policy; https://www.yorkville.il.us/DocumentCenter/View/5804/Residential-Permit-Application-PDF?bidId=; https://www.yorkville.il.us/244/Senior-Services-Programs; https://www.yorkville.il.us/facilities/facility/details/margeclinewhitewatercourse-37 Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #5 Tracking Number ADM 2019-53 Quarterly Vehicle Replacement Chart Administration Committee – September 18, 2019 Informational None Rob Fredrickson Finance Name Department 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Police Department 55,000$ 616,068$ 298,241$ 222,580$ 202,161$ 196,109$ 196,109$ 203,798$ 209,908$ 214,738$ 215,423$ Community Development - 39,120 14,620 14,620 14,620 14,620 12,717 12,717 13,315 13,315 13,315 Streets - 2,110,208 943,366 632,267 594,082 548,740 497,002 476,608 477,877 482,671 484,981 Total General Fund 55,000$ 2,765,395$ 1,256,226$ 869,466$ 810,863$ 759,469$ 705,829$ 693,123$ 701,100$ 710,723$ 713,719$ Total Water Fund -$ 121,807$ 44,323$ 34,888$ 33,207$ 33,207$ 31,087$ 31,087$ 32,697$ 33,966$ 34,651$ Total Sewer Fund 48,892$ 43,046$ 43,046$ 18,758$ 18,758$ 18,758$ 18,758$ 19,782$ 19,782$ 19,782$ 21,547$ Parks 66,000$ 183,532$ 119,535$ 102,411$ 87,684$ 78,758$ 76,855$ 75,494$ 77,104$ 78,972$ 80,216$ Recreation 27,500 7,783 7,783 7,783 7,783 7,783 7,783 7,783 7,133 7,133 7,133 Total Parks & Rec Fund 93,500$ 191,315$ 127,318$ 110,194$ 95,467$ 86,541$ 84,638$ 83,277$ 84,237$ 86,105$ 87,349$ FISCAL YEAR Vehicle Chargeback Summary 1 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Estimated Useful Life Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback M 8 2016 Chevrolet Impala Sedan 2G1WA5E30G1161317 867920 89 14,374 Police Capital Chief -- 30,000$ 3,000$ 27,000$ -$ M 8.1 2025 Chevrolet Malibu Sedan Police Capital Chief 2025 4 32,473$ 3,247$ 29,226$ 7,306$ M 8.2 2033 Chevrolet Malibu Sedan Police Capital Chief 2033 8 38,047$ 3,805$ 34,243$ 4,280$ M 8.3 2041 Chevrolet Malibu Sedan Police Capital Chief 2041 8 44,578$ 4,458$ 40,121$ 5,015$ M 8.4 2049 Chevrolet Malibu Sedan Police Capital Chief 2049 8 52,231$ 5,223$ 47,008$ 5,876$ M 8.5 2057 Chevrolet Malibu Sedan Police Capital Chief 2057 8 61,197$ 6,120$ 55,077$ 6,885$ M 23 2018 Chevrolet Malibu Sedan 1G1ZBST1JF132097 M218935 109 4,830 Police Capital Deputy Chief -- 30,000$ 3,000$ 27,000$ -$ M 23.1 2027 Chevrolet Malibu Sedan Police Capital Deputy Chief 2027 6 37,466$ 3,840$ 33,626$ 5,604$ M 23.2 2035 Chevrolet Malibu Sedan Police Capital Deputy Chief 2035 8 47,960$ 4,916$ 43,044$ 5,380$ M 23.3 2043 Chevrolet Malibu Sedan Police Capital Deputy Chief 2043 8 61,392$ 6,293$ 55,100$ 6,887$ M 23.4 2051 Chevrolet Malibu Sedan Police Capital Deputy Chief 2051 8 78,587$ 8,055$ 70,532$ 8,817$ M 23.5 2059 Chevrolet Malibu Sedan Police Capital Deputy Chief 2059 8 100,598$ 10,311$ 90,287$ 11,286$ M 3 2016 Chevrolet Impala Sedan 2G1WA5E33G1160517 M208233 88 26,423 Police Capital Deputy Chief -- 30,000$ 3,000$ 27,000$ -$ M 3.1 2025 Chevrolet Malibu Sedan Police Capital Deputy Chief 2025 4 32,473$ 3,247$ 29,226$ 7,306$ M 3.2 2033 Chevrolet Malibu Sedan Police Capital Deputy Chief 2033 8 38,047$ 3,805$ 34,243$ 4,280$ M 3.3 2041 Chevrolet Malibu Sedan Police Capital Deputy Chief 2041 8 44,578$ 4,458$ 40,121$ 5,015$ M 3.4 2049 Chevrolet Malibu Sedan Police Capital Deputy Chief 2049 8 52,231$ 5,223$ 47,008$ 5,876$ M 3.5 2057 Chevrolet Malibu Sedan Police Capital Deputy Chief 2057 8 61,197$ 6,120$ 55,077$ 6,885$ M 4 2003 Chevrolet Yukon SUV 2G1WA5E33G1160517 M208233 88 26,423 Police Capital Detective -- 30,000$ 3,000$ 27,000$ -$ M 4.1 2021 Chevrolet Malibu Sedan Police Capital Detective 2021 1 30,000$ 3,000$ 27,000$ 27,000$ M 4.2 2028 Chevrolet Malibu Sedan Police Capital Detective 2028 7 34,461$ 3,446$ 31,015$ 4,431$ M 4.3 2035 Chevrolet Malibu Sedan Police Capital Detective 2035 7 39,584$ 3,958$ 35,626$ 5,089$ M 4.4 2042 Chevrolet Malibu Sedan Police Capital Detective 2042 7 45,470$ 4,547$ 40,923$ 5,846$ M 4.5 2049 Chevrolet Malibu Sedan Police Capital Detective 2049 7 52,231$ 5,223$ 47,008$ 6,715$ M 17 2016 Chevrolet Impala Sedan 2G1WD5E33G1158872 MP13889 92 17,057 Police Capital Detective -- 30,000$ 3,000$ 27,000$ -$ M 17.1 2023 Chevrolet Malibu Sedan Police Capital Detective 2023 2 31,212$ 3,121$ 28,091$ 14,045$ M 17.2 2030 Chevrolet Malibu Sedan Police Capital Detective 2030 7 35,853$ 3,585$ 32,267$ 4,610$ M 17.3 2037 Chevrolet Malibu Sedan Police Capital Detective 2037 7 41,184$ 4,118$ 37,065$ 5,295$ M 17.4 2044 Chevrolet Malibu Sedan Police Capital Detective 2044 7 47,307$ 4,731$ 42,576$ 6,082$ M 17.5 2051 Chevrolet Malibu Sedan Police Capital Detective 2051 7 54,341$ 5,434$ 48,907$ 6,987$ M 15 2014 Chevy Caprice Sedan 6G3NS5U23EL973259 MP11082 83 103,885 Police Capital Detective -- 30,000$ 3,000$ 27,000$ -$ M 15.1 2022 Chevrolet Malibu Sedan Police Capital Detective 2022 1 30,000$ 3,000$ 27,000$ 27,000$ M 15.2 2029 Chevrolet Malibu Sedan Police Capital Detective 2029 7 34,461$ 3,446$ 31,015$ 4,431$ M 15.3 2036 Chevrolet Malibu Sedan Police Capital Detective 2036 7 39,584$ 3,958$ 35,626$ 5,089$ M 15.4 2043 Chevrolet Malibu Sedan Police Capital Detective 2043 7 45,470$ 4,547$ 40,923$ 5,846$ M 15.5 2050 Chevrolet Malibu Sedan Police Capital Detective 2050 7 52,231$ 5,223$ 47,008$ 6,715$ Vehicle # Vehicle Replacement Chargeback Schedule - Police Capital (Police Department) Police Chief Deputy Police Chiefs Police Detectives 2 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Estimated Useful Life Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual ChargebackVehicle # Vehicle Replacement Chargeback Schedule - Police Capital (Police Department) M 1 2016 Chevrolet Impala Sedan 2G1WD5E33G1156250 MP15247 101 25,033 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 1.1 2023 Chevrolet Yukon SUV Police Capital Patrol 2023 2 67,626$ 8,323$ 59,303$ 29,651$ M 1.2 2028 Chevrolet Yukon SUV Police Capital Patrol 2028 5 74,665$ 9,189$ 65,475$ 13,095$ M 1.3 2033 Chevrolet Yukon SUV Police Capital Patrol 2033 5 82,436$ 10,146$ 72,290$ 14,458$ M 1.4 2038 Chevrolet Yukon SUV Police Capital Patrol 2038 5 91,016$ 11,202$ 79,814$ 15,963$ M 1.5 2043 Chevrolet Yukon SUV Police Capital Patrol 2043 5 100,489$ 12,368$ 88,121$ 17,624$ M 5 2016 Chevrolet Impala Sedan 2G1WD5E36G1156162 MP13887 94 40,152 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 5.1 2022 Chevrolet Yukon SUV Police Capital Patrol 2022 1 66,300$ 8,160$ 58,140$ 58,140$ M 5.2 2027 Chevrolet Yukon SUV Police Capital Patrol 2027 5 73,201$ 9,009$ 64,191$ 12,838$ M 5.3 2032 Chevrolet Yukon SUV Police Capital Patrol 2032 5 80,819$ 9,947$ 70,872$ 14,174$ M 5.4 2037 Chevrolet Yukon SUV Police Capital Patrol 2037 5 89,231$ 10,982$ 78,249$ 15,650$ M 5.5 2042 Chevrolet Yukon SUV Police Capital Patrol 2042 5 98,518$ 12,125$ 86,393$ 17,279$ M 9 2016 Chevrolet Impala Sedan 2G1WD5E34G1157357 MP13890 93 39,579 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 9.1 2022 Chevrolet Yukon SUV Police Capital Patrol 2022 1 65,000$ 8,000$ 57,000$ 57,000$ M 9.2 2027 Chevrolet Yukon SUV Police Capital Patrol 2027 5 71,765$ 8,833$ 62,933$ 12,587$ M 9.3 2032 Chevrolet Yukon SUV Police Capital Patrol 2032 5 79,235$ 9,752$ 69,483$ 13,897$ M 9.4 2037 Chevrolet Yukon SUV Police Capital Patrol 2037 5 87,481$ 10,767$ 76,714$ 15,343$ M 9.5 2042 Chevrolet Yukon SUV Police Capital Patrol 2042 5 96,587$ 11,888$ 84,699$ 16,940$ M 10 2016 Chevrolet Impala Sedan 2G1WD5E30G1155301 MP15245 100 21,774 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 10.1 2023 Chevrolet Yukon SUV Police Capital Patrol 2023 2 67,626$ 8,323$ 59,303$ 29,651$ M 10.2 2028 Chevrolet Yukon SUV Police Capital Patrol 2028 5 74,665$ 9,189$ 65,475$ 13,095$ M 10.3 2033 Chevrolet Yukon SUV Police Capital Patrol 2033 5 82,436$ 10,146$ 72,290$ 14,458$ M 10.4 2038 Chevrolet Yukon SUV Police Capital Patrol 2038 5 91,016$ 11,202$ 79,814$ 15,963$ M 10.5 2043 Chevrolet Yukon SUV Police Capital Patrol 2043 5 100,489$ 12,368$ 88,121$ 17,624$ M 11 2016 Chevrolet Impala Sedan 2G1WD5E30G1155315 MP16617 105 2,110 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 11.1 2024 Chevrolet Yukon SUV Police Capital Patrol 2024 3 68,979$ 8,490$ 60,489$ 20,163$ M 11.2 2029 Chevrolet Yukon SUV Police Capital Patrol 2029 5 76,158$ 9,373$ 66,785$ 13,357$ M 11.3 2034 Chevrolet Yukon SUV Police Capital Patrol 2034 5 84,084$ 10,349$ 73,736$ 14,747$ M 11.4 2039 Chevrolet Yukon SUV Police Capital Patrol 2039 5 92,836$ 11,426$ 81,410$ 16,282$ M 11.5 2044 Chevrolet Yukon SUV Police Capital Patrol 2044 5 102,498$ 12,615$ 89,883$ 17,977$ M 19 2016 Chevrolet Impala Sedan 2G1WD5E33G1158158 MP13888 95 44,197 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 19.1 2022 Chevrolet Yukon SUV Police Capital Patrol 2022 1 66,300$ 8,160$ 58,140$ 58,140$ M 19.2 2027 Chevrolet Yukon SUV Police Capital Patrol 2027 5 73,201$ 9,009$ 64,191$ 12,838$ M 19.3 2032 Chevrolet Yukon SUV Police Capital Patrol 2032 5 80,819$ 9,947$ 70,872$ 14,174$ M 19.4 2037 Chevrolet Yukon SUV Police Capital Patrol 2037 5 89,231$ 10,982$ 78,249$ 15,650$ M 19.5 2042 Chevrolet Yukon SUV Police Capital Patrol 2042 5 98,518$ 12,125$ 86,393$ 17,279$ M 20 2016 Chevrolet Impala Sedan 2G1WD5E33G1154823 MP16618 104 3,493 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 20.1 2024 Chevrolet Yukon SUV Police Capital Patrol 2024 3 68,979$ 8,490$ 60,489$ 20,163$ M 20.2 2029 Chevrolet Yukon SUV Police Capital Patrol 2029 5 76,158$ 9,373$ 66,785$ 13,357$ M 20.3 2034 Chevrolet Yukon SUV Police Capital Patrol 2034 5 84,084$ 10,349$ 73,736$ 14,747$ M 20.4 2039 Chevrolet Yukon SUV Police Capital Patrol 2039 5 92,836$ 11,426$ 81,410$ 16,282$ M 20.5 2044 Chevrolet Yukon SUV Police Capital Patrol 2044 5 102,498$ 12,615$ 89,883$ 17,977$ Patrol 3 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Estimated Useful Life Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual ChargebackVehicle # Vehicle Replacement Chargeback Schedule - Police Capital (Police Department) M 21 2016 Chevrolet Impala Sedan 2G1WD5E33G1150206 MP16619 103 2,362 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 21.1 2024 Chevrolet Yukon SUV Police Capital Patrol 2024 3 68,979$ 8,490$ 60,489$ 20,163$ M 21.2 2029 Chevrolet Yukon SUV Police Capital Patrol 2029 5 76,158$ 9,373$ 66,785$ 13,357$ M 21.3 2034 Chevrolet Yukon SUV Police Capital Patrol 2034 5 84,084$ 10,349$ 73,736$ 14,747$ M 21.4 2039 Chevrolet Yukon SUV Police Capital Patrol 2039 5 92,836$ 11,426$ 81,410$ 16,282$ M 21.5 2044 Chevrolet Yukon SUV Police Capital Patrol 2044 5 102,498$ 12,615$ 89,883$ 17,977$ M 13 2016 Chevrolet Impala Sedan 2G1WD5E31G1149006 MP15246 99 21,054 Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 13.1 2023 Chevrolet Yukon SUV Police Capital Patrol 2023 2 67,626$ 8,323$ 59,303$ 29,651$ M 13.2 2028 Chevrolet Yukon SUV Police Capital Patrol 2028 5 74,665$ 9,189$ 65,475$ 13,095$ M 13.3 2033 Chevrolet Yukon SUV Police Capital Patrol 2033 5 82,436$ 10,146$ 72,290$ 14,458$ M 13.4 2038 Chevrolet Yukon SUV Police Capital Patrol 2038 5 91,016$ 11,202$ 79,814$ 15,963$ M 13.5 2043 Chevrolet Yukon SUV Police Capital Patrol 2043 5 100,489$ 12,368$ 88,121$ 17,624$ M 16 2015 Chevy Tahoe SUV 1GNSK2EC3FR725184 MP12713 80 62,939 Police Capital Sergeants -- 65,000$ 8,000$ 57,000$ -$ M 16.1 2022 Chevrolet Yukon SUV Police Capital Sergeants 2022 1 65,000$ 8,000$ 57,000$ 57,000$ M 16.2 2027 Chevrolet Yukon SUV Police Capital Sergeants 2027 5 71,765$ 8,833$ 62,933$ 12,587$ M 16.3 2032 Chevrolet Yukon SUV Police Capital Sergeants 2032 5 79,235$ 9,752$ 69,483$ 13,897$ M 16.4 2037 Chevrolet Yukon SUV Police Capital Sergeants 2037 5 87,481$ 10,767$ 76,714$ 15,343$ M 16.5 2042 Chevrolet Yukon SUV Police Capital Sergeants 2042 5 96,587$ 11,888$ 84,699$ 16,940$ M 18 2015 Chevy Tahoe SUV 1GNSK2ECOFR725210 MP12714 81 49,435 Police Capital Sergeants -- 65,000$ 8,000$ 57,000$ -$ M 18.1 2023 Chevrolet Yukon SUV Police Capital Sergeants 2023 2 67,626$ 8,323$ 59,303$ 29,651$ M 18.2 2028 Chevrolet Yukon SUV Police Capital Sergeants 2028 5 74,665$ 9,189$ 65,475$ 13,095$ M 18.3 2033 Chevrolet Yukon SUV Police Capital Sergeants 2033 5 82,436$ 10,146$ 72,290$ 14,458$ M 18.4 2038 Chevrolet Yukon SUV Police Capital Sergeants 2038 5 91,016$ 11,202$ 79,814$ 15,963$ M 18.5 2043 Chevrolet Yukon SUV Police Capital Sergeants 2043 5 100,489$ 12,368$ 88,121$ 17,624$ M 100 New SUV SUV ----Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 100.1 2021 Chevrolet Yukon SUV Police Capital Patrol 2021 1 65,000$ 8,000$ 57,000$ 57,000$ M 100.2 2026 Chevrolet Yukon SUV Police Capital Patrol 2026 5 71,765$ 8,833$ 62,933$ 12,587$ M 100.3 2031 Chevrolet Yukon SUV Police Capital Patrol 2031 5 79,235$ 9,752$ 69,483$ 13,897$ M 100.4 2036 Chevrolet Yukon SUV Police Capital Patrol 2036 5 87,481$ 10,767$ 76,714$ 15,343$ M 100.5 2041 Chevrolet Yukon SUV Police Capital Patrol 2041 5 96,587$ 11,888$ 84,699$ 16,940$ M 101 New SUV SUV ----Police Capital Patrol -- 65,000$ 8,000$ 57,000$ -$ M 101.1 2021 Chevrolet Yukon SUV Police Capital Patrol 2021 1 65,000$ 8,000$ 57,000$ 57,000$ M 101.2 2026 Chevrolet Yukon SUV Police Capital Patrol 2026 5 71,765$ 8,833$ 62,933$ 12,587$ M 101.3 2031 Chevrolet Yukon SUV Police Capital Patrol 2031 5 79,235$ 9,752$ 69,483$ 13,897$ M 101.4 2036 Chevrolet Yukon SUV Police Capital Patrol 2036 5 87,481$ 10,767$ 76,714$ 15,343$ M 101.5 2041 Chevrolet Yukon SUV Police Capital Patrol 2041 5 96,587$ 11,888$ 84,699$ 16,940$ 4 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback CD 1 2007 Ford Explorer Pick-up 1FMEU73E47UB50282 M166523 2 58,279 Comm Dvlp Building -- 25,000$ 500$ 24,500$ -$ CD 1.1 2021 Ford 150 4x4 Pick-up Comm Dvlp Building 2021 1 25,000$ 500$ 24,500$ 24,500$ CD 1.2 2028 Ford 150 4x4 Pick-up Comm Dvlp Building 2028 7 28,717$ 574$ 28,143$ 4,020$ CD 1.3 2035 Ford 150 4x4 Pick-up Comm Dvlp Building 2035 7 32,987$ 660$ 32,327$ 4,618$ CD 1.4 2042 Ford 150 4x4 Pick-up Comm Dvlp Building 2042 7 37,892$ 758$ 37,134$ 5,305$ CD 1.5 2049 Ford 150 4x4 Pick-up Comm Dvlp Building 2049 7 43,526$ 871$ 42,655$ 6,094$ CD 2 2018 Ford F150 4x4 Pick-up 1FTNF1EG5JKF37470 M217881 106 1,882 Comm Dvlp Building -- 25,000$ 1,000$ 24,000$ -$ CD 2 2026 Ford F150 4x4 Pick-up Comm Dvlp Building 2026 5 27,602$ 1,104$ 26,498$ 5,300$ CD 2 2033 Ford F150 4x4 Pick-up Comm Dvlp Building 2033 7 31,706$ 1,268$ 30,438$ 4,348$ CD 2 2040 Ford F150 4x4 Pick-up Comm Dvlp Building 2040 7 36,420$ 1,457$ 34,963$ 4,995$ CD 2 2047 Ford F150 4x4 Pick-up Comm Dvlp Building 2047 7 41,835$ 1,673$ 40,162$ 5,737$ CD 2 2054 Ford F150 4x4 Pick-up Comm Dvlp Building 2054 7 48,056$ 1,922$ 46,134$ 6,591$ CD 3 2018 Ford F150 4x4 Pick-up 1FTMF1CB0JKF30476 M217880 107 3,627 Comm Dvlp Building -- 25,000$ 1,000$ 24,000$ -$ CD 3 2026 Ford F150 4x4 Pick-up Comm Dvlp Building 2026 5 27,602$ 1,104$ 26,498$ 5,300$ CD 3 2033 Ford F150 4x4 Pick-up Comm Dvlp Building 2033 7 31,706$ 1,268$ 30,438$ 4,348$ CD 3 2040 Ford F150 4x4 Pick-up Comm Dvlp Building 2040 7 36,420$ 1,457$ 34,963$ 4,995$ CD 3 2047 Ford F150 4x4 Pick-up Comm Dvlp Building 2047 7 41,835$ 1,673$ 40,162$ 5,737$ CD 3 2054 Ford F150 4x4 Pick-up Comm Dvlp Building 2054 7 48,056$ 1,922$ 46,134$ 6,591$ Vehicle Replacement Chargeback Schedule - Community Development (Building Department) Vehicle # 5 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback Y 30 2005 Ford F250 Pick-up 1FTSX21575EC28484 M151639 4 93,796 PW Capital Streets -- 55,000$ 3,000$ 52,000$ -$ Y 30.1 2021 Ford F 350 - w/plow Pick-up PW Capital Streets 2021 1 55,000$ 3,000$ 52,000$ 52,000$ Y 30.2 2028 Ford F 350 - w/plow Pick-up PW Capital Streets 2028 7 63,178$ 3,446$ 59,732$ 8,533$ Y 30.3 2035 Ford F 350 - w/plow Pick-up PW Capital Streets 2035 7 72,571$ 3,958$ 68,613$ 9,802$ Y 30.4 2042 Ford F 350 - w/plow Pick-up PW Capital Streets 2042 7 83,362$ 4,547$ 78,815$ 11,259$ Y 30.5 2049 Ford F 350 - w/plow Pick-up PW Capital Streets 2049 7 95,756$ 5,223$ 90,533$ 12,933$ Y 23 2006 International 7400 5 Yard 5 Yard 1HTWDAAN46J218804 M156008 54 30,971 PW Capital Streets -- 202,000$ 25,000$ 177,000$ -$ Y 23.1 2025 International 7400 5 Yard 5 Yard PW Capital Streets 2025 4 218,651$ 27,061$ 191,590$ 47,898$ Y 23.2 2035 International 7400 5 Yard 5 Yard PW Capital Streets 2035 10 266,535$ 32,987$ 233,548$ 23,355$ Y 23.3 2045 International 7400 5 Yard 5 Yard PW Capital Streets 2045 10 324,904$ 40,211$ 284,693$ 28,469$ Y 23.4 2055 International 7400 5 Yard 5 Yard PW Capital Streets 2055 10 396,057$ 49,017$ 347,040$ 34,704$ Y 23.5 2065 International 7400 5 Yard 5 Yard PW Capital Streets 2065 10 482,791$ 59,751$ 423,039$ 42,304$ Y 10 2004 International 7400 5 Yard 5 Yard 1HTWDAAR74J083169 M143323 64 29,210 PW Capital Streets -- 202,000$ 25,000$ 177,000$ -$ Y 10.1 2021 International 7400 5 Yard 5 Yard PW Capital Streets 2021 1 202,000$ 25,000$ 177,000$ 177,000$ Y 10.2 2031 International 7400 5 Yard 5 Yard PW Capital Streets 2031 10 246,237$ 30,475$ 215,762$ 21,576$ Y 10.3 2041 International 7400 5 Yard 5 Yard PW Capital Streets 2041 10 300,161$ 37,149$ 263,013$ 26,301$ Y 10.4 2051 International 7400 5 Yard 5 Yard PW Capital Streets 2051 10 365,895$ 45,284$ 320,611$ 32,061$ Y 10.5 2061 International 7400 5 Yard 5 Yard PW Capital Streets 2061 10 446,024$ 55,201$ 390,823$ 39,082$ Y TBD Peterbilt - with plow & spreader Dump TBD TBD TBD - PW Capital Streets -- 202,000$ -$ 202,000$ -$ Y TBD 2021 Peterbilt - with plow & spreader Dump PW Capital Streets 2021 1 202,000$ -$ 202,000$ 202,000$ Y TBD 2031 Peterbilt - with plow & spreader Dump PW Capital Streets 2031 10 246,237$ 30,475$ 215,762$ 21,576$ Y TBD 2041 Peterbilt - with plow & spreader Dump PW Capital Streets 2041 10 300,161$ 37,149$ 263,013$ 26,301$ Y TBD 2051 Peterbilt - with plow & spreader Dump PW Capital Streets 2051 10 365,895$ 45,284$ 320,611$ 32,061$ Y TBD 2061 Peterbilt - with plow & spreader Dump PW Capital Streets 2061 10 446,024$ 55,201$ 390,823$ 39,082$ Y 31 2007 Ford Explorer Pick-up 1FMEU73E27UB50281 M163944 3 75,698 PW Capital Streets -- 35,000$ 2,000$ 33,000$ -$ Y 31.1 2022 Ford F 250 with plow Pick-up PW Capital Streets 2022 1 35,000$ 2,000$ 33,000$ 33,000$ Y 31.2 2029 Ford F 250 with plow Pick-up PW Capital Streets 2029 7 40,204$ 2,297$ 37,907$ 5,415$ Y 31.3 2036 Ford F 250 with plow Pick-up PW Capital Streets 2036 7 46,182$ 2,639$ 43,543$ 6,220$ Y 31.4 2043 Ford F 250 with plow Pick-up PW Capital Streets 2043 7 53,048$ 3,031$ 50,017$ 7,145$ Y 31.5 2050 Ford F 250 with plow Pick-up PW Capital Streets 2050 7 60,936$ 3,482$ 57,454$ 8,208$ Y 26 2006 F550 Aerial Lift Truck Aerial 1FSAF57P56EC54524 M161896 41 67,587 PW Capital Streets -- 150,000$ 15,000$ 135,000$ -$ Y 26.1 2022 Aerial Lift Truck Aerial PW Capital Streets 2022 1 150,000$ 15,000$ 135,000$ 135,000$ Y 26.2 2029 Aerial Lift Truck Aerial PW Capital Streets 2029 7 172,303$ 17,230$ 155,073$ 22,153$ Y 26.3 2036 Aerial Lift Truck Aerial PW Capital Streets 2036 7 197,922$ 19,792$ 178,130$ 25,447$ Y 26.4 2043 Aerial Lift Truck Aerial PW Capital Streets 2043 7 227,350$ 22,735$ 204,615$ 29,231$ Y 26.5 2050 Aerial Lift Truck Aerial PW Capital Streets 2050 7 261,154$ 26,115$ 235,038$ 33,577$ Y 21 2005 Freightliner HC80 Dump 1FVAB6BV75DN04463 M151796 50 23,570 PW Capital Streets -- 250,000$ 30,000$ 220,000$ -$ Y 21.1 2022 Freightliner HC80 Dump PW Capital Streets 2022 1 250,000$ 30,000$ 220,000$ 220,000$ Y 21.2 2032 Freightliner HC80 Dump PW Capital Streets 2032 10 304,749$ 36,570$ 268,179$ 26,818$ Y 21.3 2042 Freightliner HC80 Dump PW Capital Streets 2042 10 371,487$ 44,578$ 326,908$ 32,691$ Y 21.4 2052 Freightliner HC80 Dump PW Capital Streets 2052 10 452,840$ 54,341$ 398,500$ 39,850$ Y 21.5 2062 Freightliner HC80 Dump PW Capital Streets 2062 10 552,010$ 66,241$ 485,769$ 48,577$ Y 19 2004 Ford F350 Pick-up 1FDWF37SX4ED64867 M150335 63 88,540 PW Capital Streets -- 35,000$ 6,500$ 28,500$ -$ Y 19.1 2022 Ford F350 Pick-up PW Capital Streets 2022 1 35,000$ 6,500$ 28,500$ 28,500$ Y 19.2 2029 Ford F350 Pick-up PW Capital Streets 2029 7 40,204$ 7,466$ 32,738$ 4,677$ Y 19.3 2036 Ford F350 Pick-up PW Capital Streets 2036 7 46,182$ 8,577$ 37,605$ 5,372$ Y 19.4 2043 Ford F350 Pick-up PW Capital Streets 2043 7 53,048$ 9,852$ 43,196$ 6,171$ Y 19.5 2050 Ford F350 Pick-up PW Capital Streets 2050 7 60,936$ 11,317$ 49,619$ 7,088$ Vehicle Replacement Chargeback Schedule - Public Works Capital (Street Department) Vehicle # 6 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback Vehicle Replacement Chargeback Schedule - Public Works Capital (Street Department) Vehicle # Y TBD Peterbilt - New Dump Truck Dump TBD TBD TBD - PW Capital Streets -- 205,000$ -$ 205,000$ -$ Y TBD 2022 Peterbilt - New Dump Truck Dump PW Capital Streets 2022 1 205,000$ -$ 205,000$ 205,000$ Y TBD 2032 Peterbilt - New Dump Truck Dump PW Capital Streets 2032 10 249,894$ 30,475$ 219,419$ 21,942$ Y TBD 2042 Peterbilt - New Dump Truck Dump PW Capital Streets 2042 10 304,619$ 37,149$ 267,471$ 26,747$ Y TBD 2052 Peterbilt - New Dump Truck Dump PW Capital Streets 2052 10 371,329$ 45,284$ 326,045$ 32,605$ Y TBD 2062 Peterbilt - New Dump Truck Dump PW Capital Streets 2062 10 452,648$ 55,201$ 397,447$ 39,745$ Y TBD Peterbilt - New Dump Truck Dump TBD TBD TBD - PW Capital Streets -- 205,000$ -$ 205,000$ -$ Y TBD 2022 Peterbilt - New Dump Truck Dump PW Capital Streets 2022 1 205,000$ -$ 205,000$ 205,000$ Y TBD 2032 Peterbilt - New Dump Truck Dump PW Capital Streets 2032 10 249,894$ 30,475$ 219,419$ 21,942$ Y TBD 2042 Peterbilt - New Dump Truck Dump PW Capital Streets 2042 10 304,619$ 37,149$ 267,471$ 26,747$ Y TBD 2052 Peterbilt - New Dump Truck Dump PW Capital Streets 2052 10 371,329$ 45,284$ 326,045$ 32,605$ Y TBD 2062 Peterbilt - New Dump Truck Dump PW Capital Streets 2062 10 452,648$ 55,201$ 397,447$ 39,745$ Y 25 2007 Ford 250 Pick-up 1FTNF21587EA47543 M160751 46 47,175 PW Capital Streets -- 35,000$ 3,500$ 31,500$ -$ Y 25.1 2023 Ford 250 Pick-up PW Capital Streets 2023 2 36,414$ 3,641$ 32,773$ 16,386$ Y 25.2 2030 Ford 250 Pick-up PW Capital Streets 2030 7 41,828$ 4,183$ 37,645$ 5,378$ Y 25.3 2037 Ford 250 Pick-up PW Capital Streets 2037 7 48,047$ 4,805$ 43,243$ 6,178$ Y 25.4 2044 Ford 250 Pick-up PW Capital Streets 2044 7 55,191$ 5,519$ 49,672$ 7,096$ Y 25.5 2051 Ford 250 Pick-up PW Capital Streets 2051 7 63,398$ 6,340$ 57,058$ 8,151$ Y 4 2008 Ford F350 Pick-up 1FDWF37Y08ED57176 M168872 49 69,798 PW Capital Streets -- 65,000$ 5,500$ 59,500$ -$ Y 4.1 2023 One Ton Dump Truck Dump PW Capital Streets 2023 2 67,626$ 5,722$ 61,904$ 30,952$ Y 4.2 2030 One Ton Dump Truck Dump PW Capital Streets 2030 7 77,681$ 6,573$ 71,108$ 10,158$ Y 4.3 2037 One Ton Dump Truck Dump PW Capital Streets 2037 7 89,231$ 7,550$ 81,681$ 11,669$ Y 4.4 2044 One Ton Dump Truck Dump PW Capital Streets 2044 7 102,498$ 8,673$ 93,826$ 13,404$ Y 4.5 2051 One Ton Dump Truck Dump PW Capital Streets 2051 7 117,739$ 9,962$ 107,776$ 15,397$ Y 13 2008 International 7400 5 Yard 5 Yard 1HTWDAAN48J648495 M170535 53 6,331 PW Capital Streets -- 425,000$ 35,000$ 390,000$ -$ Y 13.1 2023 International 7400 5 Yard 5 Yard PW Capital Streets 2023 2 442,170$ 36,414$ 405,756$ 202,878$ Y 13.2 2033 International 7400 5 Yard 5 Yard PW Capital Streets 2033 10 539,003$ 44,388$ 494,614$ 49,461$ Y 13.3 2043 International 7400 5 Yard 5 Yard PW Capital Streets 2043 10 657,041$ 54,109$ 602,932$ 60,293$ Y 13.4 2053 International 7400 5 Yard 5 Yard PW Capital Streets 2053 10 800,930$ 65,959$ 734,971$ 73,497$ Y 13.5 2063 International 7400 5 Yard 5 Yard PW Capital Streets 2063 10 976,329$ 80,404$ 895,925$ 89,593$ Y 27 2007 International 7400 5 Yard 5 Yard 1HTWDAAR37J429772 M161895 55 25,519 PW Capital Streets -- 185,000$ 25,000$ 160,000$ -$ Y 27.1 2023 International 7400 5 Yard 5 Yard PW Capital Streets 2023 2 192,474$ 26,010$ 166,464$ 83,232$ Y 27.2 2033 International 7400 5 Yard 5 Yard PW Capital Streets 2033 10 234,625$ 31,706$ 202,919$ 20,292$ Y 27.3 2043 International 7400 5 Yard 5 Yard PW Capital Streets 2043 10 286,006$ 38,649$ 247,357$ 24,736$ Y 27.4 2053 International 7400 5 Yard 5 Yard PW Capital Streets 2053 10 348,640$ 47,114$ 301,526$ 30,153$ Y 27.5 2063 International 7400 5 Yard 5 Yard PW Capital Streets 2063 10 424,990$ 57,431$ 367,559$ 36,756$ Y 28 2007 International 7400 5 Yard 5 Yard 1HTWDAAR17J429771 M161894 56 27,503 PW Capital Streets -- 185,000$ 25,000$ 160,000$ -$ Y 28.1 2023 International 7400 5 Yard 5 Yard PW Capital Streets 2023 2 192,474$ 26,010$ 166,464$ 83,232$ Y 28.2 2033 International 7400 5 Yard 5 Yard PW Capital Streets 2033 10 234,625$ 31,706$ 202,919$ 20,292$ Y 28.3 2043 International 7400 5 Yard 5 Yard PW Capital Streets 2043 10 286,006$ 38,649$ 247,357$ 24,736$ Y 28.4 2053 International 7400 5 Yard 5 Yard PW Capital Streets 2053 10 348,640$ 47,114$ 301,526$ 30,153$ Y 28.5 2063 International 7400 5 Yard 5 Yard PW Capital Streets 2063 10 424,990$ 57,431$ 367,559$ 36,756$ Y 9 2008 International 7400 six wheeler 6W 1HTWHAAR78J648496 M170083 57 55,242 PW Capital Streets -- 200,000$ 35,000$ 165,000$ -$ Y 9.1 2024 International 7400 six wheeler 6W PW Capital Streets 2024 3 212,242$ 37,142$ 175,099$ 58,366$ Y 9.2 2034 International 7400 six wheeler 6W PW Capital Streets 2034 10 258,721$ 45,276$ 213,445$ 21,345$ Y 9.3 2044 International 7400 six wheeler 6W PW Capital Streets 2044 10 315,380$ 55,191$ 260,188$ 26,019$ Y 9.4 2054 International 7400 six wheeler 6W PW Capital Streets 2054 10 384,446$ 67,278$ 317,168$ 31,717$ Y 9.5 2064 International 7400 six wheeler 6W PW Capital Streets 2064 10 468,638$ 82,012$ 386,626$ 38,663$ 7 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback Vehicle Replacement Chargeback Schedule - Public Works Capital (Street Department) Vehicle # Y 22 2006 International 7400 six wheeler 6W 1HTWHAAR36J218803 M156007 66 63,226 PW Capital Streets -- 200,000$ 50,000$ 150,000$ -$ Y 22.1 2025 International 7400 six wheeler 6W PW Capital Streets 2025 4 216,486$ 54,122$ 162,365$ 40,591$ Y 22.2 2035 International 7400 six wheeler 6W PW Capital Streets 2035 10 263,896$ 65,974$ 197,922$ 19,792$ Y 22.3 2045 International 7400 six wheeler 6W PW Capital Streets 2045 10 321,687$ 80,422$ 241,266$ 24,127$ Y 22.4 2055 International 7400 six wheeler 6W PW Capital Streets 2055 10 392,135$ 98,034$ 294,101$ 29,410$ Y 22.5 2065 International 7400 six wheeler 6W PW Capital Streets 2065 10 478,011$ 119,503$ 358,508$ 35,851$ Y 2 2015 Peterbilt Vac Con Vac Con 2NP3LJOX8FM266717 M200121 84 9,069 PW Capital Streets -- 450,000$ 50,000$ 400,000$ -$ Y 2.1 2026 Peterbilt Vac Con Vac Con PW Capital Streets 2026 5 496,836$ 55,204$ 441,632$ 88,326$ Y 2.2 2036 Peterbilt Vac Con Vac Con PW Capital Streets 2036 10 605,641$ 67,293$ 538,347$ 53,835$ Y 2.3 2046 Peterbilt Vac Con Vac Con PW Capital Streets 2046 10 738,273$ 82,030$ 656,242$ 65,624$ Y 2.4 2056 Peterbilt Vac Con Vac Con PW Capital Streets 2056 10 899,950$ 99,994$ 799,956$ 79,996$ Y 2.5 2066 Peterbilt Vac Con Vac Con PW Capital Streets 2066 10 1,097,034$ 121,893$ 975,142$ 97,514$ Y 0 2006 International Truck Dump 1HTWDAAN46J218804 M156008 54 - PW Capital Streets -- 225,000$ 25,000$ 200,000$ -$ Y 0.1 2026 International Truck Dump PW Capital Streets 2026 5 248,418$ 27,602$ 220,816$ 44,163$ Y 0.2 2036 International Truck Dump PW Capital Streets 2036 10 302,820$ 33,647$ 269,174$ 26,917$ Y 0.3 2046 International Truck Dump PW Capital Streets 2046 10 369,136$ 41,015$ 328,121$ 32,812$ Y 0.4 2056 International Truck Dump PW Capital Streets 2056 10 449,975$ 49,997$ 399,978$ 39,998$ Y 0.5 2066 International Truck Dump PW Capital Streets 2066 10 548,517$ 60,946$ 487,571$ 48,757$ Y 11 2016 Peterbilt - includes hook lift system Dump 2NP3LJ0X9GM361854 M208199 90 13,476 PW Capital Streets -- 450,000$ 50,000$ 400,000$ -$ Y 11.1 2027 Peterbilt - includes hook lift system Dump PW Capital Streets 2027 6 506,773$ 56,308$ 450,465$ 75,077$ Y 11.2 2037 Peterbilt - includes hook lift system Dump PW Capital Streets 2037 10 617,754$ 68,639$ 549,114$ 54,911$ Y 11.3 2047 Peterbilt - includes hook lift system Dump PW Capital Streets 2047 10 753,038$ 83,671$ 669,367$ 66,937$ Y 11.4 2057 Peterbilt - includes hook lift system Dump PW Capital Streets 2057 10 917,949$ 101,994$ 815,955$ 81,595$ Y 11.5 2067 Peterbilt - includes hook lift system Dump PW Capital Streets 2067 10 1,118,975$ 124,331$ 994,645$ 99,464$ Y 3 2016 Ford F350 Pick-up 1FDRF3H68GED40778 M210871 96 6,760 PW Capital Streets -- 45,000$ 5,500$ 39,500$ -$ Y 3.1 2027 Ford F350 Pick-up PW Capital Streets 2027 6 50,677$ 6,194$ 44,483$ 7,414$ Y 3.2 2034 Ford F350 Pick-up PW Capital Streets 2034 7 58,212$ 7,115$ 51,097$ 7,300$ Y 3.3 2041 Ford F350 Pick-up PW Capital Streets 2041 7 66,868$ 8,173$ 58,695$ 8,385$ Y 3.4 2048 Ford F350 Pick-up PW Capital Streets 2048 7 76,810$ 9,388$ 67,422$ 9,632$ Y 3.5 2055 Ford F350 Pick-up PW Capital Streets 2055 7 88,230$ 10,784$ 77,447$ 11,064$ Y 6 2016 Ford F350 Pick-up 1FDRF3H6XGED40779 M210857 97 10,725 PW Capital Streets -- 45,000$ 5,500$ 39,500$ -$ Y 6.1 2027 Ford F350 Pick-up PW Capital Streets 2027 6 50,677$ 6,194$ 44,483$ 7,414$ Y 6.2 2034 Ford F350 Pick-up PW Capital Streets 2034 7 58,212$ 7,115$ 51,097$ 7,300$ Y 6.3 2041 Ford F350 Pick-up PW Capital Streets 2041 7 66,868$ 8,173$ 58,695$ 8,385$ Y 6.4 2048 Ford F350 Pick-up PW Capital Streets 2048 7 76,810$ 9,388$ 67,422$ 9,632$ Y 6.5 2055 Ford F350 Pick-up PW Capital Streets 2055 7 88,230$ 10,784$ 77,447$ 11,064$ Y TBD 2004 Mac Lander Trailer Trailer 4UVPF202X41005505 M095484 58 - PW Capital Streets -- 5,000$ 500$ 4,500$ -$ Y TBD 2022 Mac Lander Trailer Trailer PW Capital Streets 2022 1 5,000$ 500$ 4,500$ 4,500$ Y TBD 2037 Mac Lander Trailer Trailer PW Capital Streets 2037 15 6,729$ 673$ 6,056$ 404$ Y TBD 2052 Mac Lander Trailer Trailer PW Capital Streets 2052 15 9,057$ 906$ 8,151$ 543$ Y TBD 2067 Mac Lander Trailer Trailer PW Capital Streets 2067 15 12,189$ 1,219$ 10,970$ 731$ Y TBD 2082 Mac Lander Trailer Trailer PW Capital Streets 2082 15 16,405$ 1,641$ 14,765$ 984$ Y TBD 1998 Towmaster Trailer - Single axel 12'Trailer 4KNTT1412WL160456 - 59 - PW Capital Streets -- 5,000$ 500$ 4,500$ -$ Y TBD 2022 Towmaster Trailer - Single axel 12'Trailer PW Capital Streets 2022 1 5,000$ 500$ 4,500$ 4,500$ Y TBD 2037 Towmaster Trailer - Single axel 12'Trailer PW Capital Streets 2037 15 6,729$ 673$ 6,056$ 404$ Y TBD 2052 Towmaster Trailer - Single axel 12'Trailer PW Capital Streets 2052 15 9,057$ 906$ 8,151$ 543$ Y TBD 2067 Towmaster Trailer - Single axel 12'Trailer PW Capital Streets 2067 15 12,189$ 1,219$ 10,970$ 731$ Y TBD 2082 Towmaster Trailer - Single axel 12'Trailer PW Capital Streets 2082 15 16,405$ 1,641$ 14,765$ 984$ Trailers 8 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback Vehicle Replacement Chargeback Schedule - Public Works Capital (Street Department) Vehicle # Y TBD 2003 Haulmark Trailer Trailer 16HCB12153H112082 - 20 - PW Capital Streets -- 5,000$ 500$ 4,500$ -$ Y TBD 2024 Haulmark Trailer Trailer PW Capital Streets 2024 3 5,306$ 531$ 4,775$ 1,592$ Y TBD 2039 Haulmark Trailer Trailer PW Capital Streets 2039 15 7,141$ 714$ 6,427$ 428$ Y TBD 2054 Haulmark Trailer Trailer PW Capital Streets 2054 15 9,611$ 961$ 8,650$ 577$ Y TBD 2069 Haulmark Trailer Trailer PW Capital Streets 2069 15 12,935$ 1,294$ 11,642$ 776$ Y TBD 2084 Haulmark Trailer Trailer PW Capital Streets 2084 15 17,409$ 1,741$ 15,668$ 1,045$ Y TBD 1998 Cronkite Trailer - 2 axel 16x7 Trailer 473271926W1101575 M091254 40 - PW Capital Streets -- 5,000$ 500$ 4,500$ -$ Y TBD 2022 Cronkite Trailer - 2 axel 16x7 Trailer PW Capital Streets 2022 1 5,000$ 500$ 4,500$ 4,500$ Y TBD 2037 Cronkite Trailer - 2 axel 16x7 Trailer PW Capital Streets 2037 15 6,729$ 673$ 6,056$ 404$ Y TBD 2052 Cronkite Trailer - 2 axel 16x7 Trailer PW Capital Streets 2052 15 9,057$ 906$ 8,151$ 543$ Y TBD 2067 Cronkite Trailer - 2 axel 16x7 Trailer PW Capital Streets 2067 15 12,189$ 1,219$ 10,970$ 731$ Y TBD 2082 Cronkite Trailer - 2 axel 16x7 Trailer PW Capital Streets 2082 15 16,405$ 1,641$ 14,765$ 984$ 9 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback Y 8 2003 Ford F350 Pick-up 1FTSF31SX3EA32518 M139290 47 79,509 Water Water Ops -- 38,000$ 4,000$ 34,000$ -$ Y 8.1 2021 Ford F 250 with plow Pick-up Water Water Ops 2021 1 38,000$ 4,000$ 34,000$ 34,000$ Y 8.2 2028 Ford F 250 with plow Pick-up Water Water Ops 2028 7 43,650$ 4,595$ 39,055$ 5,579$ Y 8.3 2035 Ford F 250 with plow Pick-up Water Water Ops 2035 7 50,140$ 5,278$ 44,862$ 6,409$ Y 8.4 2042 Ford F 250 with plow Pick-up Water Water Ops 2042 7 57,595$ 6,063$ 51,533$ 7,362$ Y 8.5 2049 Ford F 250 with plow Pick-up Water Water Ops 2049 7 66,159$ 6,964$ 59,195$ 8,456$ Y 24 2007 Ford F250 Pick-up 1FTNF215X7EA47544 M160752 45 73,929 Water Water Ops -- 55,000$ 4,000$ 51,000$ -$ Y 24.1 2022 One Ton Utility Truck Pick-up Water Water Ops 2022 1 56,100$ 4,080$ 52,020$ 52,020$ Y 24.2 2029 One Ton Utility Truck Pick-up Water Water Ops 2029 7 64,441$ 4,687$ 59,755$ 8,536$ Y 24.3 2036 One Ton Utility Truck Pick-up Water Water Ops 2036 7 74,023$ 5,383$ 68,639$ 9,806$ Y 24.4 2043 One Ton Utility Truck Pick-up Water Water Ops 2043 7 85,029$ 6,184$ 78,845$ 11,264$ Y 24.5 2050 One Ton Utility Truck Pick-up Water Water Ops 2050 7 97,671$ 7,103$ 90,568$ 12,938$ Y 5 2008 Ford F150 4x4 P/U Pick-up 1FTRF14W98KD16085 M168863 43 87,455 Water Water Ops -- 30,000$ 3,000$ 27,000$ -$ Y 5.1 2023 Ford F150 2W/D Pick-up Water Water Ops 2023 2 31,212$ 3,121$ 28,091$ 14,045$ Y 5.2 2030 Ford F150 2W/D Pick-up Water Water Ops 2030 7 35,853$ 3,585$ 32,267$ 4,610$ Y 5.3 2037 Ford F150 2W/D Pick-up Water Water Ops 2037 7 41,184$ 4,118$ 37,065$ 5,295$ Y 5.4 2044 Ford F150 2W/D Pick-up Water Water Ops 2044 7 47,307$ 4,731$ 42,576$ 6,082$ Y 5.5 2051 Ford F150 2W/D Pick-up Water Water Ops 2051 7 54,341$ 5,434$ 48,907$ 6,987$ Y 15 2017 Ford F150 Pick-up 1FTEW1CF8HFA76567 M211311 98 1,752 Water Water Ops -- 35,000$ 3,000$ 32,000$ -$ Y 15.1 2028 Ford F150 Pick-up Water Water Ops 2028 7 40,204$ 3,446$ 36,758$ 5,251$ Y 15.2 2035 Ford F150 Pick-up Water Water Ops 2035 7 46,182$ 3,958$ 42,223$ 6,032$ Y 15.3 2042 Ford F150 Pick-up Water Water Ops 2042 7 53,048$ 4,547$ 48,501$ 6,929$ Y 15.4 2049 Ford F150 Pick-up Water Water Ops 2049 7 60,936$ 5,223$ 55,713$ 7,959$ Y 15.5 2056 Ford F150 Pick-up Water Water Ops 2056 7 69,996$ 6,000$ 63,996$ 9,142$ Y 12 2018 Ford F150 Super Crew Pick-up 4ZEPE2224F1086728 - 86 - Water Water Ops -- 35,000$ 3,000$ 32,000$ -$ Y 12 2026 Ford F150 Super Crew Pick-up Water Water Ops 2026 5 38,643$ 3,312$ 35,331$ 7,066$ Y 12 2033 Ford F150 Super Crew Pick-up Water Water Ops 2033 7 44,388$ 3,805$ 40,584$ 5,798$ Y 12 2040 Ford F150 Super Crew Pick-up Water Water Ops 2040 7 50,988$ 4,370$ 46,618$ 6,660$ Y 12 2047 Ford F150 Super Crew Pick-up Water Water Ops 2047 7 58,570$ 5,020$ 53,549$ 7,650$ Y 12 2054 Ford F150 Super Crew Pick-up Water Water Ops 2054 7 67,278$ 5,767$ 61,511$ 8,787$ Y TBD 2003 Haulmark Trailer - Enclosed (TH85 / 20WT3)Trailer 16HGB20243H105515 M992897 51 - Water Water Ops -- 7,500$ 1,000$ 6,500$ -$ Y TBD 2024 Haulmark Trailer - Enclosed (TH85 / 20WT3)Trailer Water Water Ops 2024 3 7,959$ 1,061$ 6,898$ 2,299$ Y TBD 2039 Haulmark Trailer - Enclosed (TH85 / 20WT3)Trailer Water Water Ops 2039 15 10,712$ 1,428$ 9,284$ 619$ Y TBD 2054 Haulmark Trailer - Enclosed (TH85 / 20WT3)Trailer Water Water Ops 2054 15 14,417$ 1,922$ 12,495$ 833$ Y TBD 2069 Haulmark Trailer - Enclosed (TH85 / 20WT3)Trailer Water Water Ops 2069 15 19,403$ 2,587$ 16,816$ 1,121$ Y TBD 2084 Haulmark Trailer - Enclosed (TH85 / 20WT3)Trailer Water Water Ops 2084 15 26,114$ 3,482$ 22,632$ 1,509$ Y TBD 2015 Load Rite Trailer PE0222072-15146 Trailer 4ZEPE2224F1086728 - 86 - Water Water Ops -- 7,500$ 500$ 7,000$ -$ Y TBD 2026 Load Rite Trailer PE0222072-15146 Trailer Water Water Ops 2026 5 8,281$ 552$ 7,729$ 1,546$ Y TBD 2041 Load Rite Trailer PE0222072-15146 Trailer Water Water Ops 2041 15 11,145$ 743$ 10,402$ 693$ Y TBD 2056 Load Rite Trailer PE0222072-15146 Trailer Water Water Ops 2056 15 14,999$ 1,000$ 13,999$ 933$ Y TBD 2071 Load Rite Trailer PE0222072-15146 Trailer Water Water Ops 2071 15 20,187$ 1,346$ 18,841$ 1,256$ Y TBD 2086 Load Rite Trailer PE0222072-15146 Trailer Water Water Ops 2086 15 27,169$ 1,811$ 25,358$ 1,691$ Vehicle Replacement Chargeback Schedule - Water Department Vehicle # Trailers 10 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback Y 14 2008 Ford F350 Dump Utility 1FDWF37Y28ED57177 M169033 48 63,175 Sewer Sewer Ops -- 50,000$ 8,000$ 42,000$ -$ Y 14.1 2020 Utility Truck with plow Utility Sewer Sewer Ops 2020 0 50,000$ 8,000$ 42,000$ 42,000$ Y 14.2 2027 Utility Truck with plow Utility Sewer Sewer Ops 2027 7 57,434$ 9,189$ 48,245$ 6,892$ Y 14.3 2034 Utility Truck with plow Utility Sewer Sewer Ops 2034 7 65,974$ 10,556$ 55,418$ 7,917$ Y 14.4 2041 Utility Truck with plow Utility Sewer Sewer Ops 2041 7 75,783$ 12,125$ 63,658$ 9,094$ Y 14.5 2048 Utility Truck with plow Utility Sewer Sewer Ops 2048 7 87,051$ 13,928$ 73,123$ 10,446$ Y 20 2005 Ford F350 Utility 1FDWF37Y25EC37004 M149884 68 59,927 Sewer Sewer Ops -- 75,000$ 5,500$ 69,500$ -$ Y 20.1 2023 Utility Truck with crane & plow Utility Sewer Sewer Ops 2023 2 78,030$ 5,722$ 72,308$ 36,154$ Y 20.2 2030 Utility Truck with crane & plow Utility Sewer Sewer Ops 2030 7 89,632$ 6,573$ 83,059$ 11,866$ Y 20.3 2037 Utility Truck with crane & plow Utility Sewer Sewer Ops 2037 7 102,959$ 7,550$ 95,409$ 13,630$ Y 20.4 2044 Utility Truck with crane & plow Utility Sewer Sewer Ops 2044 7 118,267$ 8,673$ 109,594$ 15,656$ Y 20.5 2051 Utility Truck with crane & plow Utility Sewer Sewer Ops 2051 7 135,852$ 9,962$ 125,890$ 17,984$ Vehicle Replacement Chargeback Schedule - Sewer Department Vehicle # 11 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback P 1 2003 Ford F350 Utility 1FTSF31S13ED42301 M143039 33 78,216 Park & Rec Parks -- 34,000$ 1,000$ 33,000$ -$ P 1.1 2020 Ford F350 Utility Park & Rec Parks 2020 1 34,000$ 1,000$ 33,000$ 33,000$ P 1.2 2027 Ford F350 Utility Park & Rec Parks 2027 7 39,055$ 1,149$ 37,907$ 5,415$ P 1.3 2034 Ford F350 Utility Park & Rec Parks 2034 7 44,862$ 1,319$ 43,543$ 6,220$ P 1.4 2041 Ford F350 Utility Park & Rec Parks 2041 7 51,533$ 1,516$ 50,017$ 7,145$ P 1.5 2048 Ford F350 Utility Park & Rec Parks 2048 7 59,195$ 1,741$ 57,454$ 8,208$ P 2 2003 Ford F350 Dump Utility 1FDWF37S83ED42302 M201911 32 71,911 Park & Rec Parks -- 34,000$ 1,000$ 33,000$ -$ P 2.1 2020 Ford F350 Utility Utility Park & Rec Parks 2020 1 34,000$ 1,000$ 33,000$ 33,000$ P 2.2 2027 Ford F350 Utility Utility Park & Rec Parks 2027 7 39,055$ 1,149$ 37,907$ 5,415$ P 2.3 2034 Ford F350 Utility Utility Park & Rec Parks 2034 7 44,862$ 1,319$ 43,543$ 6,220$ P 2.4 2041 Ford F350 Utility Utility Park & Rec Parks 2041 7 51,533$ 1,516$ 50,017$ 7,145$ P 2.5 2048 Ford F350 Utility Utility Park & Rec Parks 2048 7 59,195$ 1,741$ 57,454$ 8,208$ P 3 2008 Ford F350 Pick-up 1FTWF31548EA08413 M160637 31 59,425 Park & Rec Parks -- 30,000$ 2,000$ 28,000$ -$ P 3.1 2022 Ford F350 Pick-up Park & Rec Parks 2022 1 30,600$ 2,040$ 28,560$ 28,560$ P 3.2 2029 Ford F350 Pick-up Park & Rec Parks 2029 7 35,150$ 2,343$ 32,806$ 4,687$ P 3.3 2036 Ford F350 Pick-up Park & Rec Parks 2036 7 40,376$ 2,692$ 37,684$ 5,383$ P 3.4 2043 Ford F350 Pick-up Park & Rec Parks 2043 7 46,379$ 3,092$ 43,287$ 6,184$ P 3.5 2050 Ford F350 Pick-up Park & Rec Parks 2050 7 53,275$ 3,552$ 49,724$ 7,103$ P 4 2007 Ford F350 Utility Dump 1FDWF37Y37EA13940 M160425 28 42,184 Park & Rec Parks -- 50,000$ 2,000$ 48,000$ -$ P 4.1 2021 Ford F450 Dump Dump Park & Rec Parks 2021 1 50,000$ 2,000$ 48,000$ 48,000$ P 4.2 2028 Ford F450 Dump Dump Park & Rec Parks 2028 7 57,434$ 2,297$ 55,137$ 7,877$ P 4.3 2035 Ford F450 Dump Dump Park & Rec Parks 2035 7 65,974$ 2,639$ 63,335$ 9,048$ P 4.4 2042 Ford F450 Dump Dump Park & Rec Parks 2042 7 75,783$ 3,031$ 72,752$ 10,393$ P 4.5 2049 Ford F450 Dump Dump Park & Rec Parks 2049 7 87,051$ 3,482$ 83,569$ 11,938$ P 5 2003 Ford F150 Pick-up 2FTRF17273CA61524 M143521 25 40,113 Park & Rec Parks -- 25,000$ 500$ 24,500$ -$ P 5.1 2023 Ford F150 Pick-up Park & Rec Parks 2023 2 26,010$ 520$ 25,490$ 12,745$ P 5.2 2030 Ford F150 Pick-up Park & Rec Parks 2030 7 29,877$ 598$ 29,280$ 4,183$ P 5.3 2037 Ford F150 Pick-up Park & Rec Parks 2037 7 34,320$ 686$ 33,633$ 4,805$ P 5.4 2044 Ford F150 Pick-up Park & Rec Parks 2044 7 39,422$ 788$ 38,634$ 5,519$ P 5.5 2051 Ford F150 Pick-up Park & Rec Parks 2051 7 45,284$ 906$ 44,378$ 6,340$ P 6 2004 Ford F150 Pick-up 2FTRF17224CA79916 M144398 24 34,322 Park & Rec Parks -- 25,000$ 500$ 24,500$ -$ P 6.1 2023 Ford F150 Pick-up Park & Rec Parks 2023 2 26,010$ 520$ 25,490$ 12,745$ P 6.2 2030 Ford F150 Pick-up Park & Rec Parks 2030 7 29,877$ 598$ 29,280$ 4,183$ P 6.3 2037 Ford F150 Pick-up Park & Rec Parks 2037 7 34,320$ 686$ 33,633$ 4,805$ P 6.4 2044 Ford F150 Pick-up Park & Rec Parks 2044 7 39,422$ 788$ 38,634$ 5,519$ P 6.5 2051 Ford F150 Pick-up Park & Rec Parks 2051 7 45,284$ 906$ 44,378$ 6,340$ P 7 2005 Ford F350 Flatbed Pick-up 1FDWF36Y95EC37003 M149885 26 36,479 Park & Rec Parks -- 32,000$ 500$ 31,500$ -$ P 7.1 2024 Ford F350 Pick-up Park & Rec Parks 2024 3 33,959$ 531$ 33,428$ 11,143$ P 7.2 2031 Ford F350 Pick-up Park & Rec Parks 2031 7 39,008$ 609$ 38,398$ 5,485$ P 7.3 2038 Ford F350 Pick-up Park & Rec Parks 2038 7 44,808$ 700$ 44,108$ 6,301$ P 7.4 2045 Ford F350 Pick-up Park & Rec Parks 2045 7 51,470$ 804$ 50,666$ 7,238$ P 7.5 2052 Ford F350 Pick-up Park & Rec Parks 2052 7 59,123$ 924$ 58,199$ 8,314$ Vehicle Replacement Chargeback Schedule - Parks Department Vehicle # 12 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback Vehicle Replacement Chargeback Schedule - Parks Department Vehicle # P 8 2007 Ford F350 Dump 1FDWF37Y57EA13941 M160502 27 48,450 Park & Rec Parks -- 52,000$ 1,500$ 50,500$ -$ P 8.1 2024 Ford F450 Dump Park & Rec Parks 2024 3 55,183$ 1,592$ 53,591$ 17,864$ P 8.2 2031 Ford F450 Dump Park & Rec Parks 2031 7 63,388$ 1,828$ 61,559$ 8,794$ P 8.3 2038 Ford F450 Dump Park & Rec Parks 2038 7 72,813$ 2,100$ 70,712$ 10,102$ P 8.4 2045 Ford F450 Dump Park & Rec Parks 2045 7 83,639$ 2,413$ 81,226$ 11,604$ P 8.5 2052 Ford F450 Dump Park & Rec Parks 2052 7 96,075$ 2,771$ 93,303$ 13,329$ P 9 2008 Ford F350 Pick-up 1FTWF31528EA08412 M160639 29 37,038 Park & Rec Parks -- 33,000$ 1,000$ 32,000$ -$ P 9.1 2025 Ford F450 Pick-up Park & Rec Parks 2025 4 35,720$ 1,082$ 34,638$ 8,659$ P 9.2 2032 Ford F450 Pick-up Park & Rec Parks 2032 7 41,031$ 1,243$ 39,788$ 5,684$ P 9.3 2039 Ford F450 Pick-up Park & Rec Parks 2039 7 47,132$ 1,428$ 45,704$ 6,529$ P 9.4 2046 Ford F450 Pick-up Park & Rec Parks 2046 7 54,140$ 1,641$ 52,499$ 7,500$ P 9.5 2053 Ford F450 Pick-up Park & Rec Parks 2053 7 62,190$ 1,885$ 60,305$ 8,615$ P 10 2008 Ford F350 Pick-up 1FTWF31568EA08414 M160638 30 41,611 Park & Rec Parks -- 33,000$ 1,000$ 32,000$ -$ P 10.1 2025 Ford F350 Pick-up Park & Rec Parks 2025 4 35,720$ 1,082$ 34,638$ 8,659$ P 10.2 2032 Ford F350 Pick-up Park & Rec Parks 2032 7 41,031$ 1,243$ 39,788$ 5,684$ P 10.3 2039 Ford F350 Pick-up Park & Rec Parks 2039 7 47,132$ 1,428$ 45,704$ 6,529$ P 10.4 2046 Ford F350 Pick-up Park & Rec Parks 2046 7 54,140$ 1,641$ 52,499$ 7,500$ P 10.5 2053 Ford F350 Pick-up Park & Rec Parks 2053 7 62,190$ 1,885$ 60,305$ 8,615$ P 11 2008 Ford F350 Pick-up 1FTWF31528ED44867 M168864 34 30,924 Park & Rec Parks -- 33,000$ 1,000$ 32,000$ -$ P 11.1 2025 Ford F350 Pick-up Park & Rec Parks 2025 4 35,720$ 1,082$ 34,638$ 8,659$ P 11.2 2032 Ford F350 Pick-up Park & Rec Parks 2032 7 41,031$ 1,243$ 39,788$ 5,684$ P 11.3 2039 Ford F350 Pick-up Park & Rec Parks 2039 7 47,132$ 1,428$ 45,704$ 6,529$ P 11.4 2046 Ford F350 Pick-up Park & Rec Parks 2046 7 54,140$ 1,641$ 52,499$ 7,500$ P 11.5 2053 Ford F350 Pick-up Park & Rec Parks 2053 7 62,190$ 1,885$ 60,305$ 8,615$ P 12 2015 Ford F350 Dump 1FDRF3G68FED09773 M204398 78 9,049 Park & Rec Parks -- 55,000$ 7,000$ 48,000$ -$ P 12.1 2026 Ford F450 Dump Park & Rec Parks 2026 5 60,724$ 7,729$ 52,996$ 10,599$ P 12.2 2033 Ford F450 Dump Park & Rec Parks 2033 7 69,753$ 8,878$ 60,876$ 8,697$ P 12.3 2040 Ford F450 Dump Park & Rec Parks 2040 7 80,125$ 10,198$ 69,927$ 9,990$ P 12.4 2047 Ford F450 Dump Park & Rec Parks 2047 7 92,038$ 11,714$ 80,324$ 11,475$ P 12.5 2054 Ford F450 Dump Park & Rec Parks 2054 7 105,723$ 13,456$ 92,267$ 13,181$ P 13 2016 Ford Transit Van Van 1FTYE1ZM4GKA79591 M207782 87 4,689 Park & Rec Parks -- 30,000$ 3,000$ 27,000$ -$ P 13.1 2027 Ford Transit Van Van Park & Rec Parks 2027 6 33,785$ 3,378$ 30,406$ 5,068$ P 13.2 2037 Ford Transit Van Van Park & Rec Parks 2037 10 41,184$ 4,118$ 37,065$ 3,707$ P 13.3 2047 Ford Transit Van Van Park & Rec Parks 2047 10 50,203$ 5,020$ 45,182$ 4,518$ P 13.4 2057 Ford Transit Van Van Park & Rec Parks 2057 10 61,197$ 6,120$ 55,077$ 5,508$ P 13.5 2067 Ford Transit Van Van Park & Rec Parks 2067 10 74,598$ 7,460$ 67,139$ 6,714$ 13 Year Model Type VIN #License Plate # in Title Book Mileage Department User Group Fiscal Year Replacement Years to Replacement Estimated Replacement Cost Estimated Trade- In Value Estimated Replacement Cost - Net Annual Chargeback R 1 2006 Dodge Grand Caravan Van 1D4GP24E66B731334 M160824 22 40,920 Park & Rec Recreation -- 28,000$ 500$ 27,500$ -$ R 1.1 2020 Dodge Grand Caravan Van Park & Rec Recreation 2020 1 28,000$ 500$ 27,500$ 27,500$ R 1.2 2030 Dodge Grand Caravan Van Park & Rec Recreation 2030 10 34,132$ 609$ 33,522$ 3,352$ R 1.3 2040 Dodge Grand Caravan Van Park & Rec Recreation 2040 10 41,607$ 743$ 40,864$ 4,086$ R 1.4 2050 Dodge Grand Caravan Van Park & Rec Recreation 2050 10 50,718$ 906$ 49,812$ 4,981$ R 1.5 2060 Dodge Grand Caravan Van Park & Rec Recreation 2060 10 61,825$ 1,104$ 60,721$ 6,072$ R 2 2017 Ford Transit Van Van 1FTYE1YM9HKB18372 M212638 102 3,758 Park & Rec Recreation -- 30,000$ 3,000$ 27,000$ -$ R 2.1 2028 Ford Transit Van Van Park & Rec Recreation 2028 7 34,461$ 3,446$ 31,015$ 4,431$ R 2.2 2038 Ford Transit Van Van Park & Rec Recreation 2038 10 42,007$ 4,201$ 37,807$ 3,781$ R 2.3 2048 Ford Transit Van Van Park & Rec Recreation 2048 10 51,207$ 5,121$ 46,086$ 4,609$ R 2.4 2058 Ford Transit Van Van Park & Rec Recreation 2058 10 62,421$ 6,242$ 56,178$ 5,618$ R 2.5 2068 Ford Transit Van Van Park & Rec Recreation 2068 10 76,090$ 7,609$ 68,481$ 6,848$ Vehicle Replacement Chargeback Schedule - Recreation Department Vehicle # 14 Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number Old Business #1 Tracking Number ADM 2019-32 Nepotism Policy Administration Committee – September 18, 2019 N / A Majority Approval See attached memo. Bart Olson Administration Name Department Summary Revising Section 2.19 Nepotism Policy to the Employee Manual. Background In June 2019 the City Council approved an amendment to Section 2.19 Nepotism Policy to reflect the need to address items on a case-by-case basis. The need to apply rules consistently was also added to the language of this section and to not promote favoritism. At the June 25th City Council meeting Alderman Funkhouser also raised an issue for discussion, where a relative of an elected official had been prohibited from being considered for a part-time recreational instructor position. This issue was discussed at the August 21st Administration Committee where staff was directed to provide for relatives to work with elected or current employees if that work was 200 hours or less. That change is reflected in the attached red-lined version of the policy. Recommendation Staff recommends amending Section 2.19 Nepotism Policy as outlined in the attached red-lined version of the City of Yorkville Employee Manual. Memorandum To: Administration Committee From: Erin Willrett, Assistant City Administrator CC: Bart Olson, City Administrator Date: September 19, 2019 Subject: Revising Section 2.19 Nepotism, United City of Yorkville Employee Manual Resolution No. 2019-___ Page 1 Resolution No. 2019-_____ A RESOLUTION OF THE UNITED CITY OF YORKVILLE, KENDALL COUNTY, ILLINOIS, APPROVING AN AMENDMENT TO THE UNITED CITY OF YORKVILLE EMPLOYEE MANUAL 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 this State; and, WHEREAS, the City desires to amend the portion of its Employee Manual which addresses the Lodging, Travel and Meal Policy in order to maintain a consistent policy; and, WHEREAS, it has been determined to be in the best interests of the City to amend Section 2.19 of the Employee Manual, in the form attached hereto in Exhibit “A”. NOW, THEREFORE, BE IT RESOLVED, by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois that Section 2.19 of the United City of Yorkville Employee Manual is hereby amended by deleted in its entirety and replacing said Section set forth on Exhibit “A” attached hereto and incorporated herein are hereby adopted. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this _____ day of ___________________, 2019. ______________________________ City Clerk KEN KOCH ________ DAN TRANSIER ________ JACKIE MILSCHEWSKI ________ ARDEN JOE PLOCHER ________ CHRIS FUNKHOUSER ________ JOEL FRIEDERS ________ SEAVER TARULIS ________ JASON PETERSON ________ Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this _____ day of ___________________, 2019. ______________________________ MAYOR Resolution No. 2019-___ Page 2 Attest: ____________________________ City Clerk Section 2.19 Nepotism Section 2.19.1 Prohibition on Employing the Spouse/Relatives of Department Heads/Elected Officials/Paid Appointed Officers (Anti-Nepotism) a. It shall be the policy of the City that it shall not employ a person that will work more than 200 hours in a calendar year, the spouse or a relative of the following Department Heads, Elected Officials, or Paid Appointed Officers: Mayor, Aldermen, Clerk, Treasurer, City Administrator, Chief of Police, Director of Parks and Recreation, Director of Finance, City Engineer, Director of Public Works, Community Development Director, Building and Zoning Officer, and City Attorney. For this purpose, a relative is deemed to mean a spouse/ parents, grandparents, children or grandchildren, siblings, aunts, uncles, nieces, nephews, in-laws, and step relatives within the same categories. b. This policy restricting employment of certain spouses and relatives shall not apply to any prohibited relationships existing on the date of passage of this provision. These issues will be addressed on a case-by-case basis and will be applied consistently without regard to marital or familial status. Section 2.19.2 Spouse/Relatives of Department Heads/Elected Officials a. The employment of a spouse or a relative of any Department Head or elected official may be subject to a confidentiality disclosure agreement or conflict of interest agreement as deemed necessary by the City Attorney. For this purpose, a relative is deemed to mean a spouse, parents, grandparents, children or grandchildren, siblings, aunts, uncles, nieces, nephews, in-laws, and step relatives within these categories. b. This policy is intended to comply with the requirements of all applicable federal, state, and local laws. c. These issues will be addressed on a case-by-case basis. Section 2.19.3 Relatives of All Employees a. The purpose of this policy is to establish consistent guidelines concerning the employment of relatives of employees of the City. Relative is deemed to mean a spouse, parents, grandparents, children or grandchildren, siblings, aunts and uncles, in-laws and step-relatives, within these categories. It is the policy of the City to provide all employees with equal employment opportunities for career advancement without fear of favoritism or penalty, actual or implied, based on family relations. b. The employment of a relative of any full-time City employee, in a full or part-time position, is prohibited if such employment shall cause the new employee to come under direct supervision of or provide direct supervision to the related full-time employee. c. Full-time City employees will not be considered for promotion or transfer if such change shall cause the employee to come under, or to provide direct supervision to a related City employee. d. If employees in a supervisory relationship become related after employment, every effort will be made to transfer one of the employees to a position where no supervisory relationship exists. If neither employee volunteers to transfer, the City Administrator will arrange an involuntary transfer at his or her discretion. Transfer decisions may be based on, but are not limited to, such factors as the grade of each affected employee's position, the availability of openings for which the affected employees are qualified, and the availability of replacement candidates for the affected employees' positions. e. This policy is intended to comply with the requirements of all applicable federal, state and local laws. f. The Mayor or his designee is responsible for the coordination, administration and implementation of the provisions of this policy as approved by the City Council. Prior to the application of this policy regarding employment or transfer decisions with respect to spouses, supervisors must contact the Mayor to ensure compliance with applicable federal, state and local laws.   Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number Old Business #2 Tracking Number ADM 2019-35 Facilities Master Plan RFQ Administration Committee – September 18, 2019 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 #3 Tracking Number ADM 2019-45 2019 Website Redesign Administration Committee – September 18, 2019 N/A N/A N/A Discussion on the website redesign including Mood Board and Layout Proposal. Erin Willrett Administration Name Department Summary Continued discussions on the website redesign process including Mood Board and Layout Proposal. Background Civic Plus has bene the city’s website provider since 2014. The redesign process is built in to the agreement to occur every 48 months at no additional cost. Staff from all departments have been collaborating on all elements of the redesign. All content will remain the same, but the look of the website will be reimagined. The focus is on accessibility, service and transparency. Staff is trying to make it as easy as possible for the public to navigate the website and provide documents within an easy- to-find manner. Parallel to the overall look of the website, staff will continue to update department and other pages of the website to maintain fresh appeal to assure that there is no outdated content within the site. This process will take approximately 6 – 8 months. Our goal is to have the redesign live on December 17, 2019. To meet the goals of the timeline Civic Plus has provided a Mood Board and Layout Proposal. The objective of the Mood Board is to establish the color scheme and photographic direction of the design of the website. The hues of the colors and pictures shown on the Mood Board reflect Web Content Accessibility Guidelines to ensure that we have a fully accessible website. The Layout Proposal is a blueprint for the structure of the website. It provides placement of the content as well as a general guideline for the functionality of the website. When these items are relatively established, website engineers can move on to focus on the aesthetics and visual design of the website. Attached is the proposed Mood Board and Layout Proposal for the City’s website. Please keep in mind that the new design will be available for review between September 24th and October 25th and can be brought back to the committee for additional review and comment at the October 16th Administration Committee for further discussion. Recommendation No further action at this time is recommended. Discussion only. Memorandum To: Administration Committee From: Erin Willrett, Assistant City Administrator CC: Bart Olson, City Administrator Date: September 18, 2019 Subject: 2019 Website Redesign – Mood Board and Layout Proposal