The URL can be used to link to this page

Administration Committee Packet 2020 06-17-20 AGENDA ADMINISTRATION COMMITTEE MEETING Wednesday, June 17, 2020 6:00 p.m. City Hall Conference Room 800 Game Farm Road, Yorkville, IL Citizen Comments: Minutes for Correction/Approval: May 20, 2020 New Business: 1. ADM 2020-40 Budget Report for May 2020 2. ADM 2020-41 Treasurer’s Report for May 2020 3. ADM 2020-42 Cash Statement for April 2020 4. ADM 2020-43 Website Report for May 2020 5. ADM 2020-44 Required Reporting to Municipality by Yorkville Police Pension Board Old Business: 1. ADM 2020-38 Cable Consortium – Exit and Moving Forward – Strategy – Plan Providing Services 2. ADM 2020-39 Governing Ordinance – Discussion of Review and Changes Additional Business: 2019/2020 City Council Goals - Administration Committee Goal Priority Staff “Staffing” 1 Bart Olson, Rob Fredrickson, James Jensen, Eric Dhuse, Tim Evans & Erin Willrett “Municipal Building Needs and Planning” 2 Bart Olson, Rob Fredrickson, James Jensen, Eric Dhuse, Tim Evans & Erin Willrett “Road to Better Roads Funding” 3 Bart Olson, Rob Fredrickson & Eric Dhuse “Metra Extension” 7 Bart Olson, Rob Fredrickson, Eric Dhuse, Krysti Barksdale-Noble & Erin Willrett “Automation and Technology” 11 (tie) Bart Olson, Erin Willrett & Lisa Pickering “Grant Opportunities and Planning” 11 (tie) Bart Olson, Erin Willrett & Tim Evans “Revenue Growth” 13 Rob Fredrickson, Krysti Barksdale-Noble & Lynn Dubajic “Special Events Amplification” 14 (tie) Erin Willrett & Tim Evans “Public Relations and Outreach” 16 Bart Olson & Erin Willrett United City of Yorkville 800 Game Farm Road Yorkville, Illinois 60560 Telephone: 630-553-4350 www.yorkville.il.us UNITED CITY OF YORKVILLE WORKSHEET ADMINISTRATION COMMITTEE Wednesday, June 17, 2020 6:00 PM CITY HALL CONFERENCE ROOM --------------------------------------------------------------------------------------------------------------------------------------- CITIZEN COMMENTS: --------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------- MINUTES FOR CORRECTION/APPROVAL: --------------------------------------------------------------------------------------------------------------------------------------- 1. May 20, 2020 □ Approved __________ □ As presented □ With corrections --------------------------------------------------------------------------------------------------------------------------------------- NEW BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2020-40 Budget Report for May 2020 □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2020-41 Treasurer’s Report for May 2020 □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 3. ADM 2020-42 Cash Statement for April 2020 □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 4. ADM 2020-43 Website Report for May 2020 □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 5. ADM 2020-44 Required Reporting to Municipality by Yorkville Police Pension Board □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- OLD BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2020-38 Cable Consortium – Exit and Moving Forward – Strategy – Plan Providing Services □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2020-39 Governing Ordinance – Start Discussion of Review and Changes □ Moved forward to CC __________ □ Approved by Committee __________ □ Bring back to Committee __________ □ Informational Item □ Notes ___________________________________________________________________________ _________________________________________________________________________________ _________________________________________________________________________________ --------------------------------------------------------------------------------------------------------------------------------------- ADDITIONAL BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number Minutes Tracking Number Minutes of the Administration Committee – May 20, 2020 Administration Committee – June 17, 2020 Majority Committee Approval Minute Taker Name Department Page 1 of 3 DRAFT UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE MEETING Wednesday, May 20, 2020 6:00pm City Hall Conference Room Note: Due to the Covid-19 pandemic, this meeting was held in accordance with Governor Pritzker's Executive Order 2020-07, extended by Executive Order 2020-33. This Order encourages social distancing by allowing remote attendance. Committee Members In Attendance: Chairman Chris Funkhouser-remote Alderman Joe Plocher-remote Alderman Dan Transier-remote Alderman Jason Peterson-remote Other City Officials In Attendance: City Administrator Bart Olson-remote Assistant City Administrator Erin Willrett-remote City Finance Director Rob Fredrickson/in-person attendance Alderman Ken Koch-remote City Clerk Lisa Pickering-remote Purchasing Manager Carri Parker-remote Others in Attendance: None The meeting was called to order at 6:00pm by Chairman Chris Funkhouser. Citizen Comments: None Minutes for Correction/Approval: February 19, 2020 The minutes were approved as presented. New Business: 1. ADM 2020-29 Budget Report for April 2020 Mr. Olson said that revenue updates have been periodically given to the Council members. The income taxes have come in with the amount expected, local use tax was flat or up and sales tax was up. MFT was down from last year by 20%. 2. ADM 2020-30 Treasurer's Report for April 2020 Finance Director Fredrickson gave the report as follows: $13,124,377 Ending Fund Balance $31,511,274 YTD Revenues $30,548,892 YTD Expenses $14,086,760 Projected Ending Fund Balance There was no further discussion and it moves forward to City Council. Page 2 of 3 3. ADM 2020-31 Cash Statement for March 2020 This is informational with cash balances and investments being shown. No comment. 4. ADM 2020-32 Website Report for February, March and April 2020 Ms. Willrett said there was a spike in March due to the many Covid-19 related closures. A re-design took place in April with many favorable comments and some cleanup is ongoing. 5. ADM 2020-33 Quarterly Vehicle Replacement Chart This report is informational. 6. ADM 2020-34 Consolidation and Closure of Parks and Recreation Bank Accounts It is proposed to consolidate these two Parks and Rec accounts into the main city account. There is no legal requirement for these accounts and the consolidation will save time and eliminate the need for inter-fund transfers. It will be tracked through Fund #79. There was no further discussion and it moves moves forward to City Council. 7. ADM 2020-35 Ordinance Amending the City Code Regarding Contracts and Purchases Purchasing Manager Carri Parker said this was addressed in the January Council meeting and would provide updates to the purchasing ordinance. The suggestion was to raise the amount of a $500 minimum disposal value for many items and a $5,000 minimum is suggested for city vehicle or equipment purchases. Other changes would include a codified disposal policy, language revisions, an internal database of vendors if RFP's are posted so that she can reach out to potential vendors and the addition of co-op purchasing. She will also be looking at the competitive bidding process. Alderman Transier asked if the co-operative bidding will result in better prices. It will depend on the purchase. Chairman Funkhouser questioned a reference to “real property” and Mr. Olson replied it is in reference to the state statutes. 8. ADM 2020-36 Fund Balance Policy Revisions- Contingency Mr. Fredrickson proposed that a contingency line item be added and memorialized in the Fund Balance policy. The amount could be set between 0% and 10% and the funds would be used only for unforeseen expenses. A formal budget amendment would be required to use it and any unused amount would revert to the Fund Balance at the end of the FY. Chairman Funkhouser asked about the benefit of the contingency vs. just including the revenue in the Fund Balance. Mr. Fredrickson said it is just a preference. Mr. Funkhouser asked if cuts are made elsewhere to create the contingency and expressed hesitancy for this proposal. No issues would result in the annual budget for having the contingency. Alderman Transier asked how the percentage of funds would be determined on a yearly basis. The City Council would decide on the percentage. This moves forward to the City Council. 9. ADM 2020-37 School District - IGA This item was placed on the agenda by Mr. Funkhouser since it has not been discussed for several years. A draft had been done and an older agreement has since expired. Mr. Page 3 of 3 Olson said negotiations were progressing at that time and eventually the Council approved what they felt was reasonable and it was forwarded to the school. Since the last IGA, the facility use policy and the city contribution of police officers were changed. The city and Mayor have had discussions with the school and School Board with some progress. Committee members said it would be beneficial to have an agreement and will give staff direction to reach out to the school district for their opinion whether to proceed as they are now or to memorialize the proposed agreement in the package. This will be brought back to committee after staff talks with the school. 10. ADM 2020-38 Cable Consortium – Exit and Moving Forward – Strategy – Plan Providing Services This was brought forward for discussion since the city is no longer part of the consortium. The Mayor has spoken with Plano and Sandwich about going forward. He also reached out to the school system, but it is on hold now due to the pandemic. He asked for options for other ways to broadcast Council meetings. Two of those options are using the current system of remote meetings or livestreaming the meetings by the city with the purchase of some additional equipment. Mr. Olson said he anticipates a plan by June 30th. Chairman Funkhouser noted that he wants to see the money previously earmarked for the consortium to continue to be used on technology for a similar use. This item will come back next month for discussion. 11. ADM 2020-39 Governing Ordinance – Start Discussion of Review and Changes The procedural ordinance approved in 2013 governs the Council and committees at this time. Chairman Funkhouser said he would like a discussion for any updates or revisions needed. He asked that any proposed changes be forwarded to Mr. Olson and this will be kept on the agenda the next few months. Old Business: None Additional Business: None There was no further business and the meeting adjourned at 6:36pm. Respectfully transcribed by Marlys Young, Minute Taker-remote Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #1 Tracking Number ADM 2020-40 Budget Report for May 2020 Administration Committee – June 17, 2020 Informational None Monthly budget reports and income statements. Rob Fredrickson Finance Name Department Summary A review of potential budget updates for the FY 21 budget, due to the COVID-19 pandemic and likely national recession. Background The City Council last discussed the FY 21 budget memo at the June 9th City Council meeting. For ease of use, we have kept the structure and content of that memo and will add commenting paragraphs below each bulletpoint with any updates. Important concepts (new text only where update is noted) 1. What will be the size and length of the economic downturn? What will be the timing and shape of the recovery? a. April 23, 2020 Update – Here’s some article headlines and a chart on the economic situation: i. “US Weekly jobless claims hit 4.4 million, bringing 5-week total to more than 26 million” – CNBC ii. “Stocks fight for gains as small business relief overshadows job losses” – Fox Business b. May 7, 2020 Update – Wednesday’s unemployment filing report from the federal government showed another ~3.2m in unemployment claims and around 33 million claims during the pandemic. The April jobs report is expected to be released the morning of Friday, May 8th, and is expected to show the worst job losses in any one month in American history and an unemployment rate of ~15%. As a comparison, the worst unemployment rate during the Great Recession was around 10%, when 7.5 million jobs were lost over the course of a year and a half, and the worst unemployment rate estimate during the Great Depression was 25%. c. June 10, 2020 Update – Originally the BLS reported that after declining by 20.7 million in April, non-farm payrolls increased by 2.5 million in May, causing unemployment to fall from 14.7% to 13.3%. Initially this report was viewed positively, as most economists had forecasted the national unemployment rate to rise to 19% by the end of May. However, the BLS later disclosed that the jobs report contained a misclassification error, that not only affected May, but April and March as well. Revised projections put April unemployment at 19.7%, falling to around 16% in May. Moreover, the Federal Reserve continues to anticipate a slow economic recovery, predicting unemployment to Memorandum To: Administration Committee From: Bart Olson, City Administrator CC: Date: June 10, 2020 Subject: FY 21 Budget Updates – Pandemic and Recession be at 9.3% at the end of 2020, followed by a further decline to 6.5% by the end of 2021 (unemployment was 3.5% at the end of 2019). 2. Income tax filings have been delayed by the state from April to July. Late penalties are being waived, giving people less incentive to file on time. This will delay the observation of the economic downturn on state income tax payments, causing less accurate LGDF estimates. a. April 23, 2020 Update – LGDF estimates have not been created by the IML or IGFOA, but the Governor’s Office of Management and Budget (GOMB) has released their own estimates for impacts to state income taxes. While these revenue estimates are not exactly correlated to the City’s share of state income taxes, they are a good baseline. As of early April, the GOMB is anticipating a 6.9% decline in individual income taxes for their entire FY 20 budget estimates, which ends June 30, 2020, and another 8.8% decline in individual income taxes for the entire FY 21 budget estimate, which ends June 30, 2021. For those same time periods, they anticipate corporate income taxes to decrease 12% and 17% off their budget estimates. Our early staff estimate is that this could impact the City’s FY 20 budget by $130,000 and the FY 21 budget by $120,000. b. May 7, 2020 Update – IML released its LGDF estimates this week, anticipating a 15% decline over FY 20 actuals. Based on the GOMB estimate of around a 7% decrease from my April 23rd update above, this is a further loss of around $160,000 in the general fund. A spreadsheet of City budget comparisons to the IML estimate is attached to this memo. c. May 21, 2020 Update – May’s allotment of income tax came in at $191,781 – 50% less than the last May’s allotment of $381,988. However, this is a bit skewed, as last May’s allotment was unusually high due to the timing of receipts by the State. Historically May income tax proceeds have been around $260,000; which would put the current years decrease at ~26%, which is slightly better than management’s expectations for May of a 29% reduction. Assuming a similar decrease in proceeds for the June allotment, income taxes would finish FY 20 around $1.836M (6.6% decrease from FY 19 amounts); which is ~$70,000 less than management’s assumption of $1.905M based upon IML projections. d. June 10, 2020 Update – June’s allotment of income tax came in at $118,791, which is essentially even with last June’s allotment of $119,293. Income tax receipts will finish FY 20 at approximately $1.87M, which is a 5% decrease in comparison to last year; but $34,000 better than what was projected last month. The City had been estimating a per capita income tax revenue of $85, based on GOMB estimates and early IML income tax narratives for FY 21, but these most recent figures have caused IML to issue a FY 21 per capita estimate of $97. If $97 per capita comes to fruition in FY 21, that would match the FY 20 actual figures (i.e. revenues are flat). Finally, it appears that the income tax payment extensions have had minimal impact on income tax revenues. 3. Sales tax submittals to the state by bars and restaurants is being deferred in timing and amount. Certain bars and restaurants may now pay only a portion of their obligation of state sales tax for February, March, and April consumer sales through August 2020. a. May 7, 2020 Update – The March state sales tax report was released on May 7, 2020. This March report covers February consumer sales, which were generally pre-pandemic but this is the first period where bars and restaurants could defer their payment of sales taxes to the state. The February consumer sales were much higher than the City expected, even in a normal budget. The February 2020 consumer sales tax amounts were 9% higher than the February 2019 consumer sales tax amounts. We have not been able to verify this theory with business-level sales tax data, but it appears almost no businesses chose to defer their sales tax payments to the state. b. June 10, 2020 Update - The April state sales tax report was released on June 4, 2020. This April report covers March consumer sales, which was the first month impacted by the pandemic, as the Governor’s shelter in place order went into effect on March 20th. Despite the temporary closure of all businesses deemed “non-essential” and the suspension of dining room service for restaurants, sales tax proceeds came in slightly higher than last year ($255,881 for June 2020 vs. $254,112 in June 2019). Sales tax is expected to finish at ~$3.22M for FY 20, which is better than the approved budget and better than our own internal estimates. It appears that the option to defer payments has not impacted our sales tax figures. 4. One report that miles driven in the Chicagoland region after the stay-at-home order was issued is 67% less miles than normal. Since MFT is based on a per gallon flat rate, the relationship between miles driven and gas taxes received by the City should be linear, i.e. 67% less. a. May 21, 2020 Update - MFT proceeds came in better than expected at $33,790, a decrease of approximately 20% from the prior year. MFT finished FY 20 at $466,091 ($24.50 per capita), which is ~3.5% less than FY 19 amounts; but is in-line with IML’s per capita projection of $24.30 ($462,235). MFT Transportation Renewal Fund (TRF) proceeds, which are funded by the recent increase in State motor fuel taxes, came in at $235,852 ($12.40 per capita) for FY 20. TRF proceeds finished higher than IML projected amounts ($11.45 per capita) by over $18,000. b. June 4, 2020 Update – In late May the City received its first of six Rebuild Illinois allotments, which is a new program administered by IDOT and funded by State bond proceeds. This first distribution totaled $208,937, with another distribution expected later on this fiscal year. Subsequent distributions are expected in FY 22 and FY 23, for a grand total of $1,253,625. Due to the uncertainty surrounding the distribution of payments during the FY 21 budget process, a nominal amount of $5,000 in revenue was included in the budget for the Rebuild Illinois program. Assuming the anticipated payment streams come to fruition, it will help to offset any potential MFT revenue declines; thus, allowing the City to maintain relatively stable funding for RTBR and other MFT related capital programs. 5. The City’s utility bills (water, sewer, sanitary district, garbage, and road infrastructure fee) were due on April 6th for usage that occurred in December and January. The City staff was monitoring payment counts and amounts received and can report that neither figure was outside of normal expectations. The “late” bills are due April 20th, and staff will monitor whether those figures are outside expectations. The next full utility bill cycle will cause bills to be due June 5th. a. April 23, 2020 Update – The April 20th late bill payment deadline was within normal expectations. b. June 10, 2020 Update – The June 5th due date for the April utility bills was within normal expectations. Direct deposit amounts for City utility bills have remained steady at around $250,000 per billing cycle. 6. A number of the City’s capital funds are dependent upon impact fees. Fortunately, the City has been extremely conservative in new housing start estimates and does not depend on these revenues for ongoing operational expenditures. The Mayor and staff have been polling local and national home builders and all remain optimistic for the construction season. 7. The State of Illinois is one of the least financially prepared states for a major recession or depression. The State has already begun sweeping different funds and delaying payments to non-health and non-medical organizations. Members of both political parties in Illinois in the past have discussed slashing state revenue sharing with municipalities. While no specific proposal is on the table at this time, one could easily imagine a scenario where municipal-related state funds are swept, and state revenue sharing is significantly reduced. a. April 23, 2020 Update – The state has moved funds around within their own budget but has not yet signaled any impact to revenue streams shared with municipalities. 8. The City’s cash position and cash flow, even in extreme circumstances and with no affirmative action by the City is ok through 2020. The City’s cash position and cash flow, in extreme circumstances and with no affirmative action by the City will enter crisis territory in mid-2021 before being untenable by the end of 2021. The City’s valley of cashflow will occur in December 2020 and December 2021, when most of the City’s bond payments are made. Important Dates (new text only where update is noted) 9. When the curve is flattened 10. When different sectors of the economy are able to restart a. May 7, 2020 Update – The Governor’s stay at home order has been extended through the end of May, and his reopening plan illustrates months before a return to economic normalcy. There has been widespread push back from the business community on this plan, and it remains to be seen whether it will change as a result of data or pressure from the public. b. June 10, 2020 Update – Beginning on June 1st the State entered phase three of the Governor’s reopening plan. “Non-essential businesses” have been allowed to reopen (with certain safety restrictions) and restaurants have been allowed to expand their services beyond delivery, pick-up and drive-thru, to include open outdoor seating. Our region is currently on track to move to Phase 4 of the plan on June 26th, which will allow all outdoor recreation, indoor dining with capacity limits, and other expanded measures. 11. Early May 2020 – when the sales tax monthly report for February consumer sales will be released, and when the sales tax reporting deferral will be seen a. May 7, 2020 Update – As noted above, there is no evidence of impact from sales tax reporting deferrals on the sales tax amounts received. b. June 10, 2020 Update - The impact from sales tax reporting deferrals on the actual amount of sales taxes received remains negligible. Since the sales tax deferral went into effect last month, less than 1% of the average monthly totals have been deferred. 12. Mid May 2020 – when the MFT monthly report for March consumer sales will be released. a. May 21, 2020 Update – As noted in section 4(a) above, MFT proceeds came in better than expected at $33,790, a decrease of approximately 20% from the prior year. 13. Early June 2020 – when the sales tax monthly report for March consumer sales will be released from the state, and the first with potentially lower sales and reporting deferrals. a. June 10, 2020 Update – As noted in section 3(b) above, sales tax will end FY 20 right around $3.22M, which is $70,000 higher than initially budgeted and a 5% increase in comparison with the previous fiscal year. June’s allotment for Non-Home Rule (NHR) sales taxes came in at 94% of last year’s amount. FY 20 totals for NHR Sales will be ~2.41M, which is 2% higher than FY 19 amounts. 14. Early July 2020 – when the sales tax monthly report for April consumer sales will be released from the state 15. July 1, 2020 – when the first, partial online sales tax methodology change goes into effect statewide, resulting in modest (relative) sales tax revenue increases for municipalities 16. July 2020 – when income taxes are due to the state 17. September 2020 – when the first sales tax monthly report will be released that could possibly the first sales tax monthly report with no deferrals 18. August 2020 – no action has been taken by Kendall County to implement this date yet, but the current discussion for property tax payment dates would push the first payment out to August 2020 19. November 2020 – state referendum on progressive income tax 20. December 2020 – large bond payments are due, representing a valley of cashflow 21. January 1, 2021 – when the second, full online sales tax methodology change goes into effect statewide, resulting in potentially significant (relative) sales tax revenue increases for municipalities 22. February 2021 – when abatement ordinances on alternate revenue bonds are due to the County 23. December 2021 – large bond payments are due, representing a valley for cashflow Revenues – Summary (mostly new text) Earlier this week the IML released its revised FY 21 projections for income, local use and other shared State revenues, which were originally projected in December of 2019. The IML reduced their per capita income tax projections down by 7%, from $105 to $97.30, which would put Yorkville’s share at $1.85M. Assuming this estimate holds true, this would be about 1% less than what was received in FY 20 and ~$47,000 less than what was budgeted for FY 21; but significantly better than earlier FY 21 projections referenced in the preceding paragraph. However, the City’s income tax share may be reduced further, depending on the outcome of the State’s graduated income tax referendum this November. The IML’s FY 21 per capita estimate for local use tax remained unchanged from its previous assertion of $35.50. This equates to a local share of $675,281 for the City – which is the same amount budgeted for FY 21. Looking ahead at the big picture, the City’s initial estimate of a $1.375M in lost revenues in the General Fund will be revised in a few weeks; and staff remains cautiously optimistic that revenue declines will not be as sharp as originally believed. The IML also revised its FY 21 MFT and TRF projections this week. Per capita MFT was reduced by almost 20%, from $24.85 to $20; whereas TRF projections were reduced by 11%, from $16.87 to $15. This puts the City’s share at $380,000 (MFT) and $285,000 (TRF), respectively – which combined is $128,000 less than FY 21 budgeted amounts. Fortunately, this projected loss is more than offset by proceeds from the REBUILD Illinois program, mentioned above. The primary concerns of the ongoing situation are explained in greater detail below; but for the most part, can be summarized as follows: - the State cutting or delaying various tax remittances - the County delaying property tax distributions and the impact of a potential recession on the local real estate market - delays and non-payments of various utility billing charges - limited investment opportunities in a low interest rate environment - the impact on the building and development community should a prolonged recession occur - the duration of social distancing, as many revenue streams are dependent upon people freely engaging in various activities in a public setting Revenues - Highest concern (new text only where update is noted) 24. Municipal and NHR Sales Tax – account for approximately one-third of all General Fund revenues and can be highly volatile. Restaurants and bars generate ~14% of all municipal sales tax receipts. Could see potential losses from proposed FY 21 amounts of over $750,000, based on current anecdotal sales information and the stay-at-home order being issued through the end of April. a. April 23, 2020 Update – While the stay at home order has not been extended past April 30th, recent comments by the Governor and Mayor of Chicago, as well as modeling for the COVID-19 case count, seems to indicate that widespread impacts to public gatherings will occur for several weeks, if not months. The staff has updated the FY 21 sales tax estimates, and now expects to see a decrease of more than $1,000,000 in regular and non- home rule sales taxes. b. May 7, 2020 Update – The stay at home order has been extended through May, and the Governor’s reopening plan makes it seem that widespread retail and restaurant impacts will occur through the Summer. As noted above, the February consumer sales tax / March state receipts report was released on May 7, 2020 and the 2020 figures were 9% higher than the 2019 figures for the same month. At least in the run up to the pandemic, no sales tax downturn was observed. c. June 10, 2020 Update – The stay at home order has been lifted as of June 1st, as the State enters phase 3 of the reopening plan. As noted above, the March consumer sales tax / April state receipts report, which is the first month impacted by the Governor’s Shelter in Place order was released on June 4, 2020 and the 2020 figures were nominally higher than the 2019 figures for the same month. Thus far, sales tax has remained resilient, as staff speculates that the decrease in sales tax proceeds from “non-essential businesses” and restaurants has been offset by the increased demand brought on by the pandemic for food and other consumer goods. Revenues - High concern (new text only where update is noted) 25. Income Tax – could possibly decline by $200,000 or more due to sharp increases in unemployment levels and lower corporate profits should a recession occur. The State is also likely to either cut or delay payments, due to their own budgetary issues. a. May 7, 2020 Update – As mentioned earlier in the memo, the IML released their revenue estimates, expecting a 15% decrease in income tax revenues from FY 20 actuals. This is a loss of $300k between FY 20 and FY 21. As of April 28th, the City was assuming a loss of only ~$140k between FY 20 and FY 21, which means the income tax picture has become ~$160k worse than we expected. b. June 10, 2020 Update – As mentioned above, June’s allotment of income tax came in at $118,791, which is essentially even with last June’s allotment of $119,293. Income tax receipts will finish FY 20 at approximately $1.87M, which is a 5% decrease in comparison to last year. IML has revised its FY 21 per capita estimate to $97. If $97 per capita comes to fruition, it would match the FY 20 actual figures (i.e. revenues are flat). 26. Local Use Tax – decline could be marginal, due to the prevalence of on-line sales. However, the State is also likely to either cut or delay payments. a. May 7, 2020 Update – As mentioned earlier in the memo, the IML released their revenue estimates, which expect no change between FY 20 and FY 21. As of April 28th, the City was assuming a loss of ~$87k in use taxes, which means the use tax picture has become $87k better than we expected. b. May 21, 2020 Update – May’s allotment of local use tax came in 3% higher than last year’s allotment of $45,940. Assuming June’s allotment remains flat with last year’s amount, local use tax would finish FY 20 at approximately $658,000. This observance aligns with the IML’s estimate that use taxes are likely to not decrease in FY 21, based on the large transfer of retail sales to online purchases. c. June 10, 2020 Update – June’s allotment of local use tax came in 15% higher than the previous year, ostensibly due to the pandemic and corresponding shelter in place order from the Governor. Local use tax is expected to finish FY 20 at $665,000, which is a 15% increase over FY 19 amounts. 27. Motor Fuel Tax – may decline by over $100,000 from decreased demand, as a result of high unemployment and more people working remotely. The State also likely to either cut or delay payments. a. May 7, 2020 Update – As mentioned earlier in the memo, the IML released their MFT and TRF estimates, expecting a loss of 15% in MFT and lowering their per capita projections for TRF slightly. In the FY 21 budget approval, the City assumed moderate growth in the MFT and had not updated those estimates as a result of the pandemic. As a result, the IML estimates for MFT and TRF are $125,000 worse than we expected. b. June 10, 2020 Update – As mentioned above, the IML has revised its FY 21 MFT and TRF projections this week. Per capita MFT was reduced by almost 20%, from $24.85 to $20; whereas TRF projections were reduced by 11%, from $16.87 to $15. This puts the City’s share at $380,000 (MFT) and $285,000 (TRF), respectively – which combined is $128,000 less than FY 21 budgeted amounts. Fortunately, this projected loss is more than offset by proceeds from the REBUILD Illinois program, mentioned above 28. Water Sales, Infrastructure Fees and Late Penalties – water sales may decline due to shrinking usage or wet weather. May adversely impact cash flow due to customers paying late or not at all. Late penalties may also vary, depending on whether or not fees are waived. 29. Sewer Maintenance Fees and Infrastructure Fees – similar to water infrastructure fees, may adversely impact cash flow due to customers paying late or not at all. 30. Child Development and Athletics & Fitness – may result in substantial refunds and season cancellations depending on how long the shelter in place order lasts and the willingness of residents to reengage in public activities. a. June 10, 2020 Update – Staff expects there to be a significant decrease in revenue and profit margin due to the Restore Illinois Plan restrictions on in-person programming and the willingness of residents to reengage in public activities. For example, about two- thirds of the spring youth sports league participants have requested refunds. We expect that this trend will continue throughout the year or until we reach Phase 5 of the Restore Illinois Plan. Nevertheless, as the State updates in-person programming guidelines we potentially could see an increase in in-person programming opportunities, revenue and profit margins. 31. Library Property Taxes – account for ~95% of all Library revenues. Any substantial delays in payments or remittance may result in serious operational and cash flow issues for the Library. 32. TIF Property Taxes – any substantial delays in payments or remittance would add continued pressure to the General Fund, which directly offsets the negative cash position of the three TIF Funds. In future fiscal years, a potential decline in property values would further inhibit the TIF districts ability to eliminate its negative equity position. Revenues - Medium concern (new text only where update is noted) 33. Corporate Property Taxes – may be delayed by the County. This, coupled with delayed remittance of state taxes, would put a strain on operational cash flow. In future fiscal years, this revenue stream may continue to decline, as more and more funds are diverted away to cover the City’s contribution to the Police Pension Fund. a. April 23, 2020 Update – Property taxes are not being delayed by the County, but late fees are being waived for a couple months. b. June 10, 2020 Update – The first allotment of property tax was received in early June. It was a week later than normal, but the amounts were in-line with expectations, thus far. 34. Building Permits, Connection & Development Fees – the impact on permit revenue from the pandemic and recession that is anticipated to follow, remains to be seen. Staff will continue to provide updates regarding these revenue streams as information becomes available. a. June 10, 2020 Update – Total permits issued thus far in FY 21 total 217, which is significantly higher than last May’s amount of 128. Singe family and commercial permits total 20 thus far in FY 21, in comparison to 31 permits issued last May. 35. Amusement, Video Gaming & Hotel Taxes – the impact on these revenue streams are wholly dependent on the longevity of the COVID-19 pandemic and the shelter in place order from the Governor. Hotel tax receipts will have limited impact on the City budget, as 90% of all proceeds received are remitted to the AACVB. 36. Investment Earnings – are expected decline sharply City-wide in the upcoming fiscal year, due to potentially declining revenues and an extremely low interest rate environment. a. June 10, 2020 Update – Limited opportunities for investment earnings seem likely for the City for at least the next two fiscal years, as the Fed recently announced that it will continue to track interest rates near zero through at least 2022, in an effort to support the national economic recovery. 37. MFT High Growth Earnings – similar situation to the other state taxes mentioned above, these proceeds could be swept or delayed by the State. Revenues - Low or no concern (all old text, no updates) 38. These revenue streams are comprised of pass-through items (such as business district or admission taxes), various reimbursements from developers and other sources, and all other revenues not previously identified – with minimal, individual impact on the overall budget. Expenditures under consideration (all old text, no updates) The Mayor and staff have preliminarily discussed a first cut list of approximately $1.3m in the general fund or related funds and $200,000 in the water fund to offset a potential loss of $1.3m in general fund revenues. We have reprinted the full list of the “easy/medium/difficult” categories from the April 14th City Council memo, with items recommended to be cut noted. All of the cuts marked below will be continuously reviewed by the Mayor and staff, and may be amended or rescinded in the future. Expenditures - Easy to implement (all old text, no updates) 39. Delay the proposed new PW employee - $100,000 annually through FY 25 a. April 23, 2020 Update – Cut until things stabilize. 40. Delay the FY 22 Police Commander - $150,000 annually beginning in FY 22 and annually through FY 25 a. April 23, 2020 Update – Cut until things stabilize. 41. Implement a hiring freeze/review process whenever a vacancy occurs. The City has one anticipated retirement in the police department at the end of FY 20, and the Chief and the Mayor have proposed leaving that position vacant going forward - $85,000 annually through FY 25 for police retirement vacancy; TBD for all other employees a. April 23, 2020 Update – Implement a hiring freeze on a case-by-case basis. Do not rehire position to be vacated through one police officer retirement. Do not hire seasonal part- time help in the Parks and Public Works Departments. 42. Cutback or reduce new budget proposals a. New sidewalk program – gross annual spend proposed at $125,000 i. April 23, 2020 Update – Reduce the annual spend for this project, but watch for a turnaround and opportunity to reinstate the full budget amount. b. Pavement striping – gross annual spend proposed at $62,000 i. April 23, 2020 Update – Reduce the annual spend for this project, but watch for a turnaround and opportunity to reinstate the full budget amount. c. Public Works building RFQ - $30,000 i. April 23, 2020 Update – Cut until things stabilize. d. Police building RFQ - $30,000 i. April 23, 2020 Update – Cut until things stabilize. e. E-ticketing software - $26,500 i. April 23, 2020 Update – Cut this project, but watch for a turnaround and opportunity to reinstate at a later date. f. Office chairs - $10,000 i. April 23, 2020 Update – Cut until things stabilize. g. Buy one less police vehicle per year - $65,000 potential savings per vehicle i. April 23, 2020 Update – Reduce the annual spend for this project but watch for a turnaround and opportunity to reinstate the full budget amount. h. Bulk water dispenser - $20,000 i. April 23, 2020 Update – Not cut for the time being, as cost is housed within the water fund. i. Enterprise Resource Program (ERP) - gross budget spend in FY 21 and FY 22 proposed at $475,000 i. April 23, 2020 Update – Cut this project but continue to do due diligence on reducing scope and cost of a future ERP project and watch for a turnaround and opportunity to reinstate at a later date. j. Cable consortium participation – net annual spend in FY 21 proposed at $65,000 i. April 23, 2020 Update – Cut participation in the consortium from a financial basis but do due diligence on remaining in the consortium at a reduced contribution amount and/or broadcasting public meetings with in house resources. Expenditures - Medium difficulty to implement (all old text, no updates) 43. Compensation and benefits a. The City implemented a one-week furlough during the last recession. A one-week furlough based on current staff counts and compensation would yield more than $100,000 in savings. This assumes that all employees, including union employees (subject to negotiation), would take a one-week furlough. i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient. b. The City froze salaries for a year or two during the last recession, depending on the group of employees. A 0% raise for current non-union employees would yield more than $100,000 in savings annually and compounded compared to the FY 21 budget proposal. i. April 23, 2020 Update – Recommendation to immediately implement. c. The elected official compensation ordinance just approved by City Council doesn’t take effect until FY 24, but the annual value is $30,000 over prior compensation levels. i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient 44. Cutback, reduce, defer a. Police pension contributions, currently at 100% funding target but legally required only at 90% funding target - $195,000 difference in FY 21 i. April 23, 2020 Update – Savings can’t be realized until FY 22, which is when the property tax levy to be passed by the City Council in December 2020 will be on the property tax bills. We recommend exploring this option with the police pension fund over the coming months. b. Greenbriar Road RTBR supplemental project - $200,000 in FY 21 i. April 23, 2020 Update – Cut this project, but watch for a turnaround and opportunity to reinstate at a later date. c. 2021 RTBR program - $1,700,000 in FY 22 i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient d. Staff training, organization wide - $100,000 annual i. April 23, 2020 Update – Reduce the annual spend for this project but watch for a turnaround and opportunity to reinstate the full budget amount. e. Staff membership in professional organizations – TBD i. April 23, 2020 Update – Reduce the annual spend for this project but watch for a turnaround and opportunity to reinstate the full budget amount. f. Ask for all consultants, vendors, and partners to reduce contract value - TBD i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient. However, without being asked, Attorney Orr has reduced her hourly rate by 7.5%. g. Mosquito control - $6,000 annual i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient h. Library liability insurance - $25,000 annual i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient i. Tuition reimbursement for currently enrolled employees - $15,000 annual in five year budget proposal i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient j. Minute taking change - $4,000 annual i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient k. Snow plow blades - $14,000 in FY 21 i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient l. Playground replacements - $200,000 in FY 21 i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient m. Parks equipment and mowers - $70,000 in FY 21 i. April 23, 2020 Update – Cut until things to stabilize. n. Sanitary sewer crawler camera - $65,000 in FY 21 i. April 23, 2020 Update – Cut until things stabilize. o. Hot water unit for vactor truck - $15,000 in FY 21 i. April 23, 2020 Update – Cut until things stabilize. p. Public Works mowers - $31,000 in FY 21 i. April 23, 2020 Update – Cut until things stabilize. q. Elizabeth St watermain replacement - $600,000 in FY 21 i. April 23, 2020 Update – Cut until things stabilize. This project is entirely housed within the water fund, but we are recommending it be deferred indefinitely to protect cash-flow. r. Water fund capital including vehicles, Appletree Ct watermain, Well #7 electrical work, SCADA upgrades, water tower painting, Orange and Olsen watermain engineering work, and pressuring sensing valve program - $100,000 in FY 21 i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient. Costs are entirely housed within the water fund. Expenditures - High difficulty to implement or high impact to organization and services (all old text, no updates) 45. Compensation and benefits a. Reduce health insurance benefits – TBD i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient b. Change health insurance carrier – would have been $100,000 difference in FY 21 if implemented, value in FY 22 is TBD i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient c. Move to self insurance – Value TBD, but risk to City would increase i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient d. Furloughs of 20% (turning a 40 hour work week into a 32 hour work week) for all employees, including union employees (bargained) - $1,500,000 annual and compounded i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient e. Progressive salary cuts of 5% for employees paid less than $60,000 annually, 10% for employees between $60,000 and $100,000 annually, and 15% for employees above $100,000 - $900,000 annually and compounded i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient f. Salary freeze for all union employees (must be negotiated) - $100,000 annually and compounded i. April 23, 2020 Update – Recommendations to negotiate with unions. 46. Waves of staff layoffs – The City’s peak full-time employment count prior to the last recession was 96 actual employees, with 105 budgeted. During the recession and afterwards, the City reduced employment counts through a variety of methods and had a low-count of 71 full-time employees. The City’s current employment count as of April is 77. Layoffs would have varying service impacts and cost savings, and specific layoffs would only be discussed in executive session. a. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient 47. Sell assets a. The Van Emmon Activity Center was worth $1.2m prior to the pandemic. i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient b. The 8 acres at Kendall Marketplace was worth $400,000 prior to the pandemic. i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient 48. Categorical last resorts a. Refinance, restructure, and/or renegotiate all bond payments to delay and reduce imminent bond payment amounts. i. April 23, 2020 Update – No immediate proposal to implement, but due diligence will be conducted by staff for December 2020 bond payments. b. Renegotiate all developer obligations and payments to reduce imminent payment amounts. i. April 23, 2020 Update – No immediate proposal to implement, but due diligence will be conducted by staff on a case-by-case basis. c. Restructure developer fees and deposits to reduce City’s financial burden. This would have the impact of increasing costs to developers and builders. i. April 23, 2020 Update - April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient d. Revenue enhancements. There are many options for raising tax and fee amounts, and creating new taxes but these would only help the organization and would burden the public. i. April 23, 2020 Update - No immediate proposal to implement. Readdress proposal later if first cut list is insufficient New Proposals, as of April 23, 2020 (all old text, no updates) 49. Part-time hires – As noted above in the hiring freeze section, the Director Dhuse and Director Evans have both separately made the recommendation not to hire any seasonal part-time help in their departments. $100,000 FY 21 value. 50. Outsourced inspections – Director Noble and Code Official Ratos have been managing inspection workload to minimize outsourcing. $60,000 FY 21 value. 51. Baseline Road Bridge – There has been no specific proposal to spend these funds, as they had been budgeted simply as a protection against a sudden closure of the bridge. $25,000 FY 21 value. New Proposals, as of May 7, 2020 (all old text, no updates) 52. UDO – At the direction of the Mayor, the City staff negotiated a one-year pause of the UDO with both consultants. The consultants agree that the rates and cost within the agreement will continue forward for the extra year and that the study could be resumed at any time within the year. $80,000 FY 21 value. Recommendation This is an informational item. Staff requests feedback on the content within. % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget GENERAL FUND REVENUES Taxes 01-000-40-00-4000 PROPERTY TAXES - - 2,107,099 0.00% 01-000-40-00-4010 PROPERTY TAXES-POLICE PENSION - - 1,230,604 0.00% 01-000-40-00-4030 MUNICIPAL SALES TAX 231,048 231,048 3,284,400 7.03% 01-000-40-00-4035 NON-HOME RULE SALES TAX 152,373 152,373 2,493,900 6.11% 01-000-40-00-4040 ELECTRIC UTILITY TAX - - 715,000 0.00% 01-000-40-00-4041 NATURAL GAS UTILITY TAX 22,870 22,870 265,000 8.63% 01-000-40-00-4043 EXCISE TAX 20,790 20,790 246,075 8.45% 01-000-40-00-4044 TELEPHONE UTILITY TAX 695 695 8,340 8.33% 01-000-40-00-4045 CABLE FRANCHISE FEES 63,267 63,267 300,000 21.09% 01-000-40-00-4050 HOTEL TAX 1,239 1,239 80,000 1.55% 01-000-40-00-4055 VIDEO GAMING TAX 7,193 7,193 140,000 5.14% 01-000-40-00-4060 AMUSEMENT TAX - - 205,000 0.00% 01-000-40-00-4065 ADMISSIONS TAX - - 145,000 0.00% 01-000-40-00-4070 BDD TAX - KENDALL MARKETPLACE 22,569 22,569 365,160 6.18% 01-000-40-00-4071 BDD TAX - DOWNTOWN 1,847 1,847 30,000 6.16% 01-000-40-00-4072 BDD TAX - COUNTRYSIDE 1,898 1,898 10,000 18.98% 01-000-40-00-4075 AUTO RENTAL TAX 1,247 1,247 15,250 8.18% Intergovernmental 01-000-41-00-4100 STATE INCOME TAX 191,781 191,781 1,897,310 10.11% 01-000-41-00-4105 LOCAL USE TAX 47,285 47,285 675,281 7.00% 01-000-41-00-4106 CANNABIS EXCISE TAX 896 896 15,218 5.89% 01-000-41-00-4110 ROAD & BRIDGE TAX - - 130,000 0.00% 01-000-41-00-4120 PERSONAL PROPERTY TAX 2,414 2,414 16,500 14.63% 01-000-41-00-4160 FEDERAL GRANTS 1,723 1,723 14,925 11.54% 01-000-41-00-4168 STATE GRANT - TRF SIGNAL MAINT 18,553 18,553 20,000 92.76% 01-000-41-00-4170 STATE GRANTS - - - 0.00% 01-000-41-00-4182 MISC INTERGOVERNMENTAL - - 1,000 0.00% Licenses & Permits 01-000-42-00-4200 LIQUOR LICENSES 3,081 3,081 65,000 4.74% 01-000-42-00-4205 OTHER LICENSES & PERMITS 310 310 9,500 3.26% 01-000-42-00-4210 BUILDING PERMITS 39,882 39,882 400,000 9.97% Fines & Forfeits 01-000-43-00-4310 CIRCUIT COURT FINES 863 863 40,000 2.16% 01-000-43-00-4320 ADMINISTRATIVE ADJUDICATION 2,284 2,284 27,500 8.30% 01-000-43-00-4323 OFFENDER REGISTRATION FEES - - 500 0.00% 01-000-43-00-4325 POLICE TOWS 3,000 3,000 45,000 6.67% UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 1 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 Charges for Service 01-000-44-00-4400 GARBAGE SURCHARGE 482 482 1,297,650 0.04% 01-000-44-00-4405 UB COLLECTION FEES 13,942 13,942 165,000 8.45% 01-000-44-00-4407 LATE PENALTIES - GARBAGE - - 25,000 0.00% 01-000-44-00-4415 ADMINISTRATIVE CHARGEBACK 17,825 17,825 213,896 8.33% 01-000-44-00-4474 POLICE SPECIAL DETAIL - - 500 0.00% Investment Earnings 01-000-45-00-4500 INVESTMENT EARNINGS 2,021 2,021 89,878 2.25% Reimbursements 01-000-46-00-4604 REIMB - ENGINEERING EXPENSES - - 25,000 0.00% 01-000-46-00-4680 REIMB - LIABILITY INSURANCE 4,886 4,886 15,000 32.57% 01-000-46-00-4685 REIMB - CABLE CONSORTIUM - - 36,000 0.00% 01-000-46-00-4690 REIMB - MISCELLANEOUS 4,763 4,763 12,000 39.69% Miscellaneous 01-000-48-00-4820 RENTAL INCOME - - 7,000 0.00% 01-000-48-00-4850 MISCELLANEOUS INCOME - - 13,000 0.00% Other Financing Uses 01-000-49-00-4916 TRANSFER FROM CW MUNICIPAL BLDG - - 35,000 0.00% TOTAL REVENUES: GENERAL FUND 883,025 883,025 16,933,486 5.21% ADMINISTRATION EXPENDITURES Salaries & Wages 01-110-50-00-5001 SALARIES - MAYOR 825 825 10,500 7.86% 01-110-50-00-5002 SALARIES - LIQUOR COMM 83 83 1,000 8.33% 01-110-50-00-5005 SALARIES - ALDERMAN 3,900 3,900 50,000 7.80% 01-110-50-00-5010 SALARIES - ADMINISTRATION 59,330 59,330 550,247 10.78% Benefits 01-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION 6,636 6,636 62,251 10.66% 01-110-52-00-5214 FICA CONTRIBUTION 4,789 4,789 43,010 11.13% 01-110-52-00-5216 GROUP HEALTH INSURANCE 13,730 13,730 97,664 14.06% 01-110-52-00-5222 GROUP LIFE INSURANCE 36 36 428 8.33% 01-110-52-00-5223 GROUP DENTAL INSURANCE 591 591 7,089 8.33% 01-110-52-00-5224 VISION INSURANCE 188 188 1,130 16.66% Contractual Services 01-110-54-00-5412 TRAINING & CONFERENCES 1,890 1,890 16,000 11.81% 01-110-54-00-5415 TRAVEL & LODGING - - 10,000 0.00% 01-110-54-00-5426 PUBLISHING & ADVERTISING - - 4,000 0.00% 01-110-54-00-5430 PRINTING & DUPLICATION - - 3,250 0.00% 01-110-54-00-5440 TELECOMMUNICATIONS - - 22,300 0.00% 01-110-54-00-5448 FILING FEES - - 500 0.00% 2 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 01-110-54-00-5451 CODIFICATION - - 10,000 0.00% 01-110-54-00-5452 POSTAGE & SHIPPING 37 37 3,000 1.23% 01-110-54-00-5460 DUES & SUBSCRIPTIONS 1,252 1,252 22,000 5.69% 01-110-54-00-5462 PROFESSIONAL SERVICES - - 12,000 0.00% 01-110-54-00-5480 UTILITIES - - 31,800 0.00% 01-110-54-00-5485 RENTAL & LEASE PURCHASE 338 338 3,000 11.27% 01-110-54-00-5488 OFFICE CLEANING - - 12,181 0.00% Supplies 01-110-56-00-5610 OFFICE SUPPLIES - - 19,000 0.00% TOTAL EXPENDITURES: ADMINISTRATION 93,625 93,625 992,350 9.43% FINANCE EXPENDITURES Salaries & Wages 01-120-50-00-5010 SALARIES & WAGES 32,610 32,610 324,856 10.04% Benefits 01-120-52-00-5212 RETIREMENT PLAN CONTRIBUTION 3,659 3,659 36,752 9.96% 01-120-52-00-5214 FICA CONTRIBUTION 2,441 2,441 23,420 10.42% 01-120-52-00-5216 GROUP HEALTH INSURANCE 8,703 8,703 57,566 15.12% 01-120-52-00-5222 GROUP LIFE INSURANCE 20 20 246 8.33% 01-120-52-00-5223 DENTAL INSURANCE 384 384 4,604 8.33% 01-120-52-00-5224 VISION INSURANCE 118 118 707 16.68% Contractual Services 01-120-54-00-5412 TRAINING & CONFERENCES 285 285 3,500 8.14% 01-120-54-00-5414 AUDITING SERVICES - - 31,400 0.00% 01-120-54-00-5415 TRAVEL & LODGING - - 600 0.00% 01-120-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - 1,957 0.00% 01-120-54-00-5430 PRINTING & DUPLICATING - - 3,500 0.00% 01-120-54-00-5440 TELECOMMUNICATIONS - - 1,000 0.00% 01-120-54-00-5452 POSTAGE & SHIPPING 78 78 1,200 6.47% 01-120-54-00-5460 DUES & SUBSCRIPTIONS 10 10 1,500 0.67% 01-120-54-00-5462 PROFESSIONAL SERVICES 2,132 2,132 65,000 3.28% 01-120-54-00-5485 RENTAL & LEASE PURCHASE 312 312 2,200 14.20% Supplies 01-120-56-00-5610 OFFICE SUPPLIES - - 2,500 0.00% TOTAL EXPENDITURES: FINANCE 50,753 50,753 562,508 9.02% POLICE EXPENDITURES Salaries & Wages 01-210-50-00-5008 SALARIES - POLICE OFFICERS 209,346 209,346 1,981,203 10.57% 3 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 01-210-50-00-5011 SALARIES - POLICE CHIEF & DEPUTIES 43,819 43,819 394,401 11.11% 01-210-50-00-5012 SALARIES - SERGEANTS 57,145 57,145 664,437 8.60% 01-210-50-00-5013 SALARIES - POLICE CLERKS 19,438 19,438 183,567 10.59% 01-210-50-00-5014 SALARIES - CROSSING GUARD - - 30,000 0.00% 01-210-50-00-5015 PART-TIME SALARIES 6,738 6,738 70,000 9.63% 01-210-50-00-5020 OVERTIME 4,467 4,467 111,000 4.02% Benefits 01-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION 2,171 2,171 20,767 10.46% 01-210-52-00-5213 EMPLOYER CONTRI - POL PEN - - 1,230,604 0.00% 01-210-52-00-5214 FICA CONTRIBUTION 25,219 25,219 253,963 9.93% 01-210-52-00-5216 GROUP HEALTH INSURANCE 102,775 102,775 648,780 15.84% 01-210-52-00-5222 GROUP LIFE INSURANCE 218 218 2,714 8.03% 01-210-52-00-5223 DENTAL INSURANCE 3,309 3,309 41,677 7.94% 01-210-52-00-5224 VISION INSURANCE 1,049 1,049 6,602 15.89% Contractual Services 01-210-54-00-5410 TUITION REIMBURSEMENT - - 15,000 0.00% 01-210-54-00-5411 POLICE COMMISSION - - 17,250 0.00% 01-210-54-00-5412 TRAINING & CONFERENCES - - 25,500 0.00% 01-210-54-00-5415 TRAVEL & LODGING - - 10,000 0.00% 01-210-54-00-5422 VEHICLE & EQUIPMENT CHARGEBACK 3,654 3,654 43,844 8.33% 01-210-54-00-5430 PRINTING & DUPLICATING - - 5,000 0.00% 01-210-54-00-5440 TELECOMMUNICATIONS - - 42,000 0.00% 01-210-54-00-5452 POSTAGE & SHIPPING 18 18 1,200 1.47% 01-210-54-00-5460 DUES & SUBSCRIPTIONS 5,113 5,113 10,700 47.79% 01-210-54-00-5462 PROFESSIONAL SERVICES - - 36,750 0.00% 01-210-54-00-5467 ADJUDICATION SERVICES - - 20,000 0.00% 01-210-54-00-5469 NEW WORLD LIVE SCAN - - 2,000 0.00% 01-210-54-00-5472 KENDALL CO. JUVE PROBATION - - 4,000 0.00% 01-210-54-00-5485 RENTAL & LEASE PURCHASE 444 444 5,600 7.92% 01-210-54-00-5488 OFFICE CLEANING - - 12,181 0.00% 01-210-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 60,000 0.00% Supplies 01-210-56-00-5600 WEARING APPAREL - - 15,000 0.00% 01-210-56-00-5610 OFFICE SUPPLIES - - 4,500 0.00% 01-210-56-00-5620 OPERATING SUPPLIES - - 16,500 0.00% 01-210-56-00-5650 COMMUNITY SERVICES - - 1,500 0.00% 01-210-56-00-5690 BALLISTIC VESTS - - 3,850 0.00% 01-210-56-00-5695 GASOLINE - - 63,130 0.00% 4 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 01-210-56-00-5696 AMMUNITION - - 9,000 0.00% TOTAL EXPENDITURES: POLICE 484,921 484,921 6,064,220 8.00% COMMUNITY DEVELOPMENT EXPENDITURES Salaries & Wages 01-220-50-00-5010 SALARIES & WAGES 55,320 55,320 535,995 10.32% Benefits 01-220-52-00-5212 RETIREMENT PLAN CONTRIBUTION 6,213 6,213 60,639 10.25% 01-220-52-00-5214 FICA CONTRIBUTION 4,104 4,104 39,552 10.38% 01-220-52-00-5216 GROUP HEALTH INSURANCE 14,564 14,564 93,545 15.57% 01-220-52-00-5222 GROUP LIFE INSURANCE 35 35 446 7.84% 01-220-52-00-5223 DENTAL INSURANCE 542 542 6,505 8.33% 01-220-52-00-5224 VISION INSURANCE 180 180 1,081 16.66% Contractual Services 01-220-54-00-5412 TRAINING & CONFERENCES - - 7,300 0.00% 01-220-54-00-5415 TRAVEL & LODGING - - 6,500 0.00% 01-220-54-00-5426 PUBLISHING & ADVERTISING - - 2,500 0.00% 01-220-54-00-5430 PRINTING & DUPLICATING - - 1,500 0.00% 01-220-54-00-5440 TELECOMMUNICATIONS - - 4,000 0.00% 01-220-54-00-5452 POSTAGE & SHIPPING 16 16 500 3.24% 01-220-54-00-5459 INSPECTIONS - - 70,000 0.00% 01-220-54-00-5460 DUES & SUBSCRIPTIONS 2,031 2,031 2,750 73.87% 01-220-54-00-5462 PROFESSIONAL SERVICES - - 92,500 0.00% 01-220-54-00-5485 RENTAL & LEASE PURCHASE 189 189 3,150 6.00% 01-220-54-00-5490 VEHICLE MAINTENANCE SERVICES - - 4,000 0.00% Supplies 01-220-56-00-5610 OFFICE SUPPLIES - - 1,500 0.00% 01-220-56-00-5620 OPERATING SUPPLIES - - 3,750 0.00% 01-220-56-00-5695 GASOLINE - - 4,441 0.00% TOTAL EXPENDITURES: COMMUNITY DEVELP 83,195 83,195 942,154 8.83% PUBLIC WORKS - STREET OPERATIONS EXPENDITURES Salaries & Wages 01-410-50-00-5010 SALARIES & WAGES 47,751 47,751 516,943 9.24% 01-410-50-00-5015 PART-TIME SALARIES - - 12,500 0.00% 01-410-50-00-5020 OVERTIME - - 20,000 0.00% Benefits 01-410-52-00-5212 RETIREMENT PLAN CONTRIBUTION 5,334 5,334 60,746 8.78% 01-410-52-00-5214 FICA CONTRIBUTION 3,524 3,524 40,268 8.75% 5 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 01-410-52-00-5216 GROUP HEALTH INSURANCE 18,936 18,936 134,105 14.12% 01-410-52-00-5222 GROUP LIFE INSURANCE 36 36 499 7.30% 01-410-52-00-5223 DENTAL INSURANCE 610 610 8,474 7.20% 01-410-52-00-5224 VISION INSURNCE 192 192 1,326 14.44% Contractual Services 01-410-54-00-5412 TRAINING & CONFERENCES - - 4,500 0.00% 01-410-54-00-5415 TRAVEL & LODGING - - 2,500 0.00% 01-410-54-00-5422 VEHICLE EQUIPMENT CHARGEBACK - - 142,551 0.00% 01-410-54-00-5435 TRAFFIC SIGNAL MAINTENANCE - - 20,000 0.00% 01-410-54-00-5440 TELECOMMUNICATIONS - - 7,600 0.00% 01-410-54-00-5455 MOSQUITO CONTROL - - 6,300 0.00% 01-410-54-00-5458 TREE & STUMP MAINTENANCE - - 13,000 0.00% 01-410-54-00-5462 PROFESSIONAL SERVICES 367 367 9,225 3.98% 01-410-54-00-5483 JULIE SERVICES - - 3,000 0.00% 01-410-54-00-5485 RENTAL & LEASE PURCHASE 69 69 6,000 1.16% 01-410-54-00-5488 OFFICE CLEANING - - 788 0.00% 01-410-54-00-5490 VEHICLE MAINTENANCE SERVICES - - 65,000 0.00% Supplies 01-410-56-00-5600 WEARING APPAREL - - 5,000 0.00% 01-410-56-00-5620 OPERATING SUPPLIES - - 19,450 0.00% 01-410-56-00-5628 VEHICLE MAINTENANCE SUPPLIES 136 136 42,000 0.32% 01-410-56-00-5630 SMALL TOOLS & EQUIPMENT - - 7,500 0.00% 01-410-56-00-5640 REPAIR & MAINTENANCE - - 24,000 0.00% 01-410-56-00-5665 JULIE SUPPLIES - - 2,234 0.00% 01-410-56-00-5695 GASOLINE - - 25,726 0.00% TOTAL EXP: PUBLIC WORKS - STREET OPS 76,956 76,956 1,201,235 6.41% PW - HEALTH & SANITATION EXPENDITURES Contractual Services 01-540-54-00-5441 GARBAGE SRVCS - SR SUBSIDY - - 35,875 0.00% 01-540-54-00-5442 GARBAGE SERVICES - - 1,268,428 0.00% 01-540-54-00-5443 LEAF PICKUP - - 7,000 0.00% TOTAL EXPENDITURES: HEALTH & SANITATION - - 1,311,303 0.00% ADMINISTRATIVE SERVICES EXPENDITURES Salaries & Wages 01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES - - 500 0.00% Benefits 01-640-52-00-5230 UNEMPLOYMENT INSURANCE 5,351 5,351 15,000 35.68% 6 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 01-640-52-00-5231 LIABILITY INSURANCE 71,918 71,918 343,684 20.93% 01-640-52-00-5240 RETIREES - GROUP HEALTH INS 13,233 13,233 39,066 33.87% 01-640-52-00-5241 RETIREES - DENTAL INSURANCE 35 35 423 8.32% 01-640-52-00-5242 RETIREES - VISION INSURANCE 206 206 80 257.03% Contractual Services 01-640-54-00-5418 PURCHASING SERVICES - - 59,664 0.00% 01-640-54-00-5423 IDOR ADMINISTRATION FEE 2,929 2,929 47,047 6.23% 01-640-54-00-5427 GC HOUSING RENTAL ASSISTANCE 1,538 1,538 9,843 15.63% 01-640-54-00-5428 UTILITY TAX REBATE - - 14,375 0.00% 01-640-54-00-5432 FACILITY MANAGEMENT SERVICES - - 64,443 0.00% 01-640-54-00-5439 AMUSEMENT TAX REBATE - - 46,000 0.00% 01-640-54-00-5449 KENCOM - - 154,350 0.00% 01-640-54-00-5450 INFORMATION TECH SRVCS 7,450 7,450 392,681 1.90% 01-640-54-00-5456 CORPORATE COUNSEL - - 110,000 0.00% 01-640-54-00-5461 LITIGATION COUNSEL - - 110,000 0.00% 01-640-54-00-5462 PROFESSIONAL SERVICES - - 8,250 0.00% 01-640-54-00-5463 SPECIAL COUNSEL - - 25,000 0.00% 01-640-54-00-5465 ENGINEERING SERVICES (496) (496) 390,000 -0.13% 01-640-54-00-5473 KENDALL AREA TRANSIT - - 25,000 0.00% 01-640-54-00-5475 CABLE CONSORTIUM FEE - - 105,000 0.00% 01-640-54-00-5481 HOTEL TAX REBATES (3,013) (3,013) 72,000 -4.19% 01-640-54-00-5486 ECONOMIC DEVELOPMENT - - 160,000 0.00% 01-640-54-00-5491 CITY PROPERTY TAX REBATE - - 1,300 0.00% 01-640-54-00-5492 SALES TAX REBATES - - 906,762 0.00% 01-640-54-00-5493 BUSINESS DISTRICT REBATES 25,787 25,787 397,057 6.49% 01-640-54-00-5494 ADMISSIONS TAX REBATE - - 145,000 0.00% 01-640-54-00-5499 BAD DEBT - - 1,500 0.00% Supplies 01-640-56-00-5625 REIMBURSEABLE REPAIRS - - 15,000 0.00% Other Financing Uses 01-640-70-00-7799 CONTINGENCY - - 80,000 0.00% 01-640-99-00-9915 TRANSFER TO CITY-WIDE CAPITAL 21,667 21,667 260,000 8.33% 01-640-99-00-9942 TRANSFER TO DEBT SERVICE 26,269 26,269 315,225 8.33% 01-640-99-00-9952 TRANSFER TO SEWER 14,562 14,562 174,744 8.33% 01-640-99-00-9979 TRANSFER TO PARKS & RECREATION 109,107 109,107 1,309,284 8.33% 7 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 01-640-99-00-9982 TRANSFER TO LIBRARY OPS 5,911 5,911 26,584 22.24% TOTAL EXPENDITURES: ADMIN SERVICES 302,454 302,454 5,824,862 5.19% TOTAL FUND REVENUES 883,025 883,025 16,933,486 5.21% TOTAL FUND EXPENDITURES 1,091,904 1,091,904 16,898,632 6.46% FUND SURPLUS (DEFICIT)(208,879) (208,879) 34,854 FOX HILL SSA REVENUES 11-000-40-00-4000 PROPERTY TAXES - - 16,034 0.00% TOTAL REVENUES: FOX HILL SSA - - 16,034 0.00% FOX HILL SSA EXPENDITURES 11-111-54-00-5462 PROFESSIONAL SERVICES - - 3,126 0.00% 11-111-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 34,200 0.00% TOTAL FUND REVENUES - - 16,034 0.00% TOTAL FUND EXPENDITURES - - 37,326 0.00% FUND SURPLUS (DEFICIT) - - (21,292) SUNFLOWER SSA REVENUES 12-000-40-00-4000 PROPERTY TAXES - - 20,363 0.00% TOTAL REVENUES: SUNFLOWER SSA - - 20,363 0.00% SUNFLOWER SSA EXPENDITURES 12-112-54-00-5416 POND MAINTENANCE - - 5,000 0.00% 12-112-54-00-5462 PROFESSIONAL SERVICES - - 3,126 0.00% 12-112-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 12,200 0.00% TOTAL FUND REVENUES - - 20,363 0.00% TOTAL FUND EXPENDITURES - - 20,326 0.00% FUND SURPLUS (DEFICIT) - - 37 MOTOR FUEL TAX REVENUES 15-000-41-00-4112 MOTOR FUEL TAX 33,790 33,790 472,697 7.15% 15-000-41-00-4113 MFT HIGH GROWTH - - 11,000 0.00% 15-000-41-00-4114 TRANSPORTATION RENEWAL TAX 22,626 22,626 320,901 7.05% 15-000-41-00-4115 REBUILD ILLINOIS 208,937 208,937 5,000 4178.75% 8 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 15-000-45-00-4500 INVESTMENT EARNINGS 418 418 4,263 9.80% TOTAL REVENUES: MOTOR FUEL TAX 265,772 265,772 813,861 32.66% MOTOR FUEL TAX EXPENDITURES Capital Outlay 15-155-56-00-5618 SALT - - 175,000 0.00% 15-155-60-00-6004 BASELINE ROAD BRIDGE REPAIRS - - 25,000 0.00% 15-155-60-00-6025 ROADS TO BETTER ROADS PROGRAM - - 781,674 0.00% 15-155-60-00-6028 PAVEMENT STRIPING PROGRAM - - 62,000 0.00% 15-155-60-00-6079 ROUTE 47 EXPANSION 6,149 6,149 73,788 8.33% TOTAL FUND REVENUES 265,772 265,772 813,861 32.66% TOTAL FUND EXPENDITURES 6,149 6,149 1,117,462 0.55% FUND SURPLUS (DEFICIT) 259,623 259,623 (303,601) CITY-WIDE CAPITAL REVENUES Licenses & Permits 23-000-42-00-4214 DEVELOPMENT FEES - - 6,000 0.00% 23-000-42-00-4218 DEVELOPMENT FEES - MUNICIPAL BLDG 3,968 3,968 35,000 11.34% 23-000-42-00-4222 ROAD CONTRIBUTION FEE 8,000 8,000 100,000 8.00% Charges for Service 23-000-44-00-4440 ROAD INFRASTRUCTURE FEES 458 458 780,000 0.06% Investment Earnings 23-000-45-00-4500 INVESTMENT EARNINGS 6 6 1,098 0.54% Reimbursements 23-000-46-00-4614 REIMB - BLACKBERRY WOODS - - 10,973 0.00% 23-000-46-00-4612 MILL ROAD IMPROVEMENTS 33,274 33,274 - 0.00% 23-000-46-00-4621 REIMB - FOUNTAIN VILLAGE - - 38,599 0.00% 23-000-46-00-4636 REIMB. - RAINTREE VILLAGE - - 70,000 0.00% 23-000-46-00-4690 REIMB - PUSH FOR THE PATH - - 26,523 0.00% 23-000-46-00-4690 REIMB - MISCELLANEOUS - - 5,477 0.00% Other Financing Sources 23-000-48-00-4845 DONATIONS - - 2,000 0.00% 23-000-49-00-4901 TRANSFER FROM GENERAL 21,667 21,667 260,000 8.33% TOTAL REVENUES: CITY-WIDE CAPITAL 67,372 67,372 1,335,670 5.04% CW MUNICIPAL BUILDING EXPENDITURES 23-216-54-00-5446 PROPERTY & BLDG MAINT SERVICES 2,643 2,643 135,000 1.96% 23-216-56-00-5626 HANGING BASKETS - - 2,000 0.00% 23-216-56-00-5656 PROPERTY & BLDG MAINT SUPPLIES - - 25,000 0.00% 9 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 23-216-99-00-9901 TRANSFER TO GENERAL - - 35,000 0.00% CITY-WIDE CAPITAL EXPENDITURES Contractual Services 23-230-54-00-5462 PROFESSIONAL SERVICES - - 5,000 0.00% 23-230-54-00-5465 ENGINEERING SERVICES - - 10,000 0.00% 23-230-54-00-5482 STREET LIGHTING - - 108,989 0.00% 23-230-54-00-5498 PAYING AGENT FEES - - 475 0.00% 23-230-54-00-5499 BAD DEBT - - 1,500 0.00% 23-230-56-00-5619 SIGNS - - 15,000 0.00% 23-230-60-00-6032 ASPHALT PATCHING - - 35,000 0.00% 23-230-56-00-5637 SIDEWALK CONSTRUCTION SUPPLIES - - 5,000 0.00% 23-230-56-00-5642 STREET LIGHTING & OTHER SUPPLIES - - 45,000 0.00% Capital Outlay 23-230-60-00-6014 BLACKBERRY WOODS SUBDIVISION - - 10,973 0.00% 23-230-60-00-6016 US34 (CENTER/ELDAMAIN RD) PROJECT - - 110,000 0.00% 23-230-60-00-6023 FOUNTAIN VILLAGE SUBDIVISION - - 38,599 0.00% 23-230-60-00-6025 ROAD TO BETTER ROADS PROGRAM - - 312,500 0.00% 23-230-60-00-6036 RAINTREE VILLAGE IMPROVEMENTS - - 70,000 0.00% 23-230-60-00-6041 SIDEWALK REPLACEMENT PROGRAM - - 125,000 0.00% 23-230-60-00-6058 RT71 ( RT47/ORCHARD RD) PROJECT - - 53,878 0.00% 23-230-60-00-6059 US RT34(IL47/ORCHARD RD)PROJECT - - 27,000 0.00% 23-230-60-00-6094 ITEP KENNEDY RD BIKE TRAIL - - 32,000 0.00% 2014A Bond 23-230-78-00-8000 PRINCIPAL PAYMENT - - 200,000 0.00% 23-230-78-00-8050 INTEREST PAYMENT 60,669 60,669 121,338 50.00% 23-230-99-00-9951 TRANSFER TO WATER 8,658 8,658 103,895 8.33% TOTAL FUND REVENUES 67,372 67,372 1,335,670 5.04% TOTAL FUND EXPENDITURES 71,970 71,970 1,628,147 4.42% FUND SURPLUS (DEFICIT)(4,598) (4,598) (292,477) VEHICLE & EQUIPMENT REVENUE Licenses & Permits 25-000-42-00-4215 DEVELOPMENT FEES - POLICE CAPITAL 2,400 2,400 30,000 8.00% 25-000-42-00-4217 WEATHER WARNING SIREN FEES 109 109 - 0.00% 25-000-42-00-4218 ENGINEERING CAPITAL FEE 800 800 10,000 8.00% 25-000-42-00-4219 DEVELOPMENT FEES - PW CAPITAL 5,600 5,600 64,500 8.68% 10 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 25-000-42-00-4220 DEVELOPMENT FEES - PARK CAPITAL 400 400 5,000 8.00% Fines & Forfeits 25-000-43-00-4315 DUI FINES - - 8,000 0.00% 25-000-43-00-4316 ELECTRONIC CITATION FEES 514 514 800 64.21% Charges for Service 25-000-44-00-4418 MOWING INCOME - - 2,000 0.00% 25-000-44-00-4420 POLICE CHARGEBACK 3,654 3,654 43,844 8.33% 25-000-44-00-4421 PUBLIC WORKS CHARGEBACK - - 142,551 0.00% 25-000-44-00-4422 PARKS & RECREATION CHARGEBACK - - 75,000 0.00% 25-000-44-00-4425 COMPUTER REPLACEMENT CHARGEBACKS - - 5,664 0.00% Investment Earnings 25-000-45-00-4522 INVESTMENT EARNINGS - PARKS 77 77 1,000 7.74% Miscellaneous 25-000-46-00-4692 MISC REIMB - PARK CAPITAL - - 59,464 0.00% 25-000-48-00-4854 MISC INCOME - PW CAPITAL - - 1,000 0.00% TOTAL REVENUES: VEHICLE & EQUIPMENT 13,553 13,553 448,823 3.02% VEHICLE & EQUIPMENT EXPENDITURES POLICE CAPITAL EXPENDITURES Contractual Services 25-205-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 8,750 0.00% Capital Outlay 25-205-60-00-6070 VEHICLES - - 130,000 0.00% TOTAL EXPENDITURES: POLICE CAPITAL - - 138,750 0.00% GENERAL GOVERNMENT CAPITAL EXPENDITURES Contractual Services 25-212-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - - 5,664 0.00% TOTAL EXPENDITURES: GENERAL GOVERNMENT - - 5,664 0.00% PUBLIC WORKS CAPITAL EXPENDITURES Contractual Services 25-215-54-00-5448 FILING FEES 67 67 750 8.93% Supplies 25-215-56-00-5620 OPERATING SUPPLIES - - 1,000 0.00% Capital Outlay 25-215-60-00-6060 EQUIPMENT - - 130,000 0.00% 25-215-60-00-6070 VEHICLES - - 100,000 0.00% 185 Wolf Street Building 25-215-92-00-8000 PRINCIPAL PAYMENT 4,250 4,250 51,612 8.24% 25-215-92-00-8050 INTEREST PAYMENT 1,533 1,533 17,784 8.62% TOTAL EXPENDITURES: PW CAPITAL 5,850 5,850 301,146 1.94% 11 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 PARK & RECREATION CAPITAL EXPENDITURES Contractual Services 25-225-54-00-5495 OUTSDE REPAIR & MAINTENANCE - - 1,600 0.00% Capital Outlay 25-225-60-00-6010 PARK IMPROVEMENTS - - 59,464 0.00% 25-225-60-00-6013 BEECHER CENTER PARK - - 50,000 0.00% 25-225-60-00-6020 BUILDINGS & STRUCTURES - - 12,596 0.00% 25-225-60-00-6060 EQUIPMENT - - 10,400 0.00% 25-225-60-00-6070 VEHICLES - - 70,000 0.00% 185 Wolf Street Building 25-225-92-00-8000 PRINCIPAL PAYMENT 133 133 1,617 8.24% 25-225-92-00-8050 INTEREST PAYMENT 48 48 557 8.62% TOTAL EXPENDITURES: PARK & REC CAPITAL 181 181 206,234 0.09% TOTAL FUND REVENUES 13,553 13,553 448,823 3.02% TOTAL FUND EXPENDITURES 6,031 6,031 651,794 0.93% FUND SURPLUS (DEFICIT) 7,522 7,522 (202,971) DEBT SERVICE REVENUES 42-000-42-00-4208 RECAPTURE FEES-WATER & SEWER 400 400 8,000 5.00% 42-000-49-00-4901 TRANSFER FROM GENERAL 26,269 26,269 315,225 8.33% TOTAL REVENUES: DEBT SERVICE 26,669 26,669 323,225 8.25% DEBT SERVICE EXPENDITURES 42-420-54-00-5498 PAYING AGENT FEES - - 475 0.00% 2014B Refunding Bond 42-420-79-00-8000 PRINCIPAL PAYMENT - - 295,000 0.00% 42-420-79-00-8050 INTEREST PAYMENT - - 27,750 0.00% TOTAL FUND REVENUES 26,669 26,669 323,225 8.25% TOTAL FUND EXPENDITURES - - 323,225 0.00% FUND SURPLUS (DEFICIT) 26,669 26,669 - WATER FUND REVENUES Charges for Service 51-000-44-00-4424 WATER SALES (524) (524) 3,129,000 -0.02% 51-000-44-00-4425 BULK WATER SALES (1,950) (1,950) 5,000 -39.00% 51-000-44-00-4426 LATE PENALTIES - WATER - - 131,250 0.00% 12 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 51-000-44-00-4430 WATER METER SALES 9,850 9,850 60,000 16.42% 51-000-44-00-4440 WATER INFRASTRUCTURE FEE 454 454 795,000 0.06% 51-000-44-00-4450 WATER CONNECTION FEES 35,014 35,014 230,000 15.22% Investment Earnings 51-000-45-00-4500 INVESTMENT EARNINGS 149 149 22,557 0.66% Miscellaneous 51-000-46-00-4690 REIMB - MISCELLANEOUS 9,459 9,459 - 0.00% 51-000-48-00-4820 RENTAL INCOME 8,295 8,295 100,010 8.29% 51-000-48-00-4850 MISCELLANEOUS INCOME - - 250 0.00% Other Financing Sources 51-000-49-00-4910 SALE OF CAPITAL ASSETS - - - 0.00% 51-000-49-00-4923 TRANSFER FROM CITY-WIDE CAPITAL 8,658 8,658 103,895 8.33% 51-000-49-00-4952 TRANSFER FROM SEWER 6,260 6,260 75,125 8.33% TOTAL REVENUES: WATER FUND 75,666 75,666 4,652,087 1.63% WATER OPERATIONS EXPENSES Salaries & Wages 51-510-50-00-5010 SALARIES & WAGES 48,833 48,833 457,530 10.67% 51-510-50-00-5015 PART-TIME SALARIES - - 30,000 0.00% 51-510-50-00-5020 OVERTIME 439 439 22,000 2.00% Benefits 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 5,520 5,520 54,251 10.18% 51-510-52-00-5214 FICA CONTRIBUTION 3,646 3,646 37,576 9.70% 51-510-52-00-5216 GROUP HEALTH INSURANCE 15,972 15,972 107,430 14.87% 51-510-52-00-5222 GROUP LIFE INSURANCE 43 43 543 7.99% 51-510-52-00-5223 DENTAL INSURANCE 606 606 7,278 8.33% 51-510-52-00-5224 VISION INSURANCE 198 198 1,129 17.54% 51-510-52-00-5230 UNEMPLOYMENT INSURANCE 527 527 2,000 26.34% 51-510-52-00-5231 LIABILITY INSURANCE 6,659 6,659 30,961 21.51% Contractual Services 51-510-54-00-5401 ADMINISTRATIVE CHARGEBACK 10,352 10,352 124,225 8.33% 51-510-54-00-5412 TRAINING & CONFERENCES - - 9,200 0.00% 51-510-54-00-5415 TRAVEL & LODGING - - 4,000 0.00% 51-510-54-00-5426 PUBLISHING & ADVERTISING - - 500 0.00% 51-510-54-00-5429 WATER SAMPLES - - 8,000 0.00% 51-510-54-00-5430 PRINTING & DUPLICATING - - 3,250 0.00% 51-510-54-00-5440 TELECOMMUNICATIONS 392 392 40,000 0.98% 51-510-54-00-5445 TREATMENT FACILITY SERVICES 12,952 12,952 255,000 5.08% 51-510-54-00-5448 FILING FEES 67 67 3,000 2.23% 13 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 51-510-54-00-5452 POSTAGE & SHIPPING 2,590 2,590 19,000 13.63% 51-510-54-00-5460 DUES & SUBSCRIPTIONS 250 250 2,500 10.00% 51-510-54-00-5462 PROFESSIONAL SERVICES 4,536 4,536 155,000 2.93% 51-510-54-00-5465 ENGINEERING SERVICES - - 85,000 0.00% 51-510-54-00-5480 UTILITIES - - 309,520 0.00% 51-510-54-00-5483 JULIE SERVICES - - 3,000 0.00% 51-510-54-00-5485 RENTAL & LEASE PURCHASE 145 145 1,700 8.53% 51-510-54-00-5488 OFFICE CLEANING - - 788 0.00% 51-510-54-00-5490 VEHICLE MAINTENANCE SERVICES - - 12,000 0.00% 51-510-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 32,000 0.00% 51-510-54-00-5498 PAYING AGENT FEES - - 1,300 0.00% 51-510-54-00-5499 BAD DEBT - - 10,000 0.00% Supplies 51-510-56-00-5600 WEARING APPAREL - - 5,000 0.00% 51-510-56-00-5620 OPERATING SUPPLIES - - 16,000 0.00% 51-510-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - - 2,500 0.00% 51-510-56-00-5630 SMALL TOOLS & EQUIPMENT 4 4 4,000 0.10% 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 2,524 2,524 178,500 1.41% 51-510-56-00-5640 REPAIR & MAINTENANCE - - 27,500 0.00% 51-510-56-00-5664 METERS & PARTS - - 100,000 0.00% 51-510-56-00-5665 JULIE SUPPLIES - - 2,233 0.00% 51-510-56-00-5695 GASOLINE - - 23,540 0.00% Capital Outlay 51-510-60-00-6015 WATER TOWER PAINTING - - 18,000 0.00% 51-510-60-00-6025 ROAD TO BETTER ROADS PROGRAM - - 634,000 0.00% 51-510-60-00-6059 US34 (IL RT47/ORCHARD) PROJECT - - 7,700 0.00% 51-510-60-00-6060 EQUIPMENT - - 500,300 0.00% 51-510-60-00-6066 RTE 71 WATERMAIN REPLACEMENT - - 12,871 0.00% 51-510-60-00-6070 VEHICLES - - 90,000 0.00% 51-510-60-00-6079 ROUTE 47 EXPANSION 3,781 3,781 45,372 8.33% 51-510-60-00-6081 CATION EXCHANGE MEDIA REPLACEMENT - - 25,000 0.00% 2015A Bond 51-510-77-00-8000 PRINCIPAL PAYMENT - - 297,837 0.00% 51-510-77-00-8050 INTEREST PAYMENT 70,084 70,084 140,167 50.00% 2016 Refunding Bond 51-510-85-00-8000 PRINCIPAL PAYMENT - - 1,475,000 0.00% 51-510-85-00-8050 INTEREST PAYMENT - - 117,650 0.00% 14 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 IEPA Loan L17-156300 51-510-89-00-8000 PRINCIPAL PAYMENT - - 107,050 0.00% 51-510-89-00-8050 INTEREST PAYMENT - - 17,981 0.00% 2014C Refunding Bond 51-510-94-00-8000 PRINCIPAL PAYMENT - - 130,000 0.00% 51-510-94-00-8050 INTEREST PAYMENT - - 20,250 0.00% TOTAL FUND REVENUES 75,666 75,666 4,652,087 1.63% TOTAL FUND EXPENSES 190,120 190,120 5,828,132 3.26% FUND SURPLUS (DEFICIT)(114,454) (114,454) (1,176,045) SEWER FUND REVENUES Charges for Service 52-000-44-00-4435 SEWER MAINTENANCE FEES 538 538 1,024,850 0.05% 52-000-44-00-4440 SEWER INFRASTRUCTURE FEE 236 236 390,000 0.06% 52-000-44-00-4455 SW CONNECTION FEES - OPS 2,200 2,200 23,300 9.44% 52-000-44-00-4456 SW CONNECTION FEES - CAPITAL 10,800 10,800 180,000 6.00% 52-000-44-00-4462 LATE PENALTIES - SEWER - - 17,500 0.00% Investment Earnings 52-000-45-00-4500 INVESTMENT EARNINGS 71 71 7,473 0.95% Other Financing Sources 52-000-49-00-4901 TRANSFER FROM GENERAL 14,562 14,562 174,744 8.33% TOTAL REVENUES: SEWER FUND 28,407 28,407 1,817,867 1.56% SEWER OPERATIONS EXPENSES Salaries & Wages 52-520-50-00-5010 SALARIES & WAGES 26,709 26,709 250,561 10.66% 52-520-50-00-5015 PART-TIME SALARIES - - 5,000 0.00% 52-520-50-00-5020 OVERTIME - - 500 0.00% Benefits 52-520-52-00-5212 RETIREMENT PLAN CONTRIBUTION 2,983 2,983 28,403 10.50% 52-520-52-00-5214 FICA CONTRIBUTION 1,963 1,963 18,509 10.60% 52-520-52-00-5216 GROUP HEALTH INSURANCE 12,449 12,449 79,026 15.75% 52-520-52-00-5222 GROUP LIFE INSURANCE 26 26 314 8.33% 52-520-52-00-5223 DENTAL INSURANCE 418 418 5,021 8.33% 52-520-52-00-5224 VISION INSURANCE 133 133 736 18.01% 52-520-52-00-5230 UNEMPLOYMENT INSURANCE 277 277 750 36.95% 52-520-52-00-5231 LIABILITY INSURANCE 3,227 3,227 15,025 21.48% Contractual Services 52-520-54-00-5401 ADMINISTRATIVE CHARGEBACK 3,726 3,726 44,709 8.33% 15 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 52-520-54-00-5412 TRAINING & CONFERENCES - - 3,500 0.00% 52-520-54-00-5415 TRAVEL & LODGING - - 3,000 0.00% 52-520-54-00-5430 PRINTING & DUPLICATING - - 1,500 0.00% 52-520-54-00-5440 TELECOMMUNICATIONS - - 13,500 0.00% 52-520-54-00-5444 LIFT STATION SERVICES 92 92 64,000 0.14% 52-520-54-00-5462 PROFESSIONAL SERVICES 1,620 1,620 45,500 3.56% 52-520-54-00-5480 UTILITIES - - 23,820 0.00% 52-520-54-00-5483 JULIE SERVICES - - 3,000 0.00% 52-520-54-00-5485 RENTAL & LEASE PURCHASE 69 69 1,100 6.31% 52-520-54-00-5488 OFFICE CLEANING - - 788 0.00% 52-520-54-00-5490 VEHICLE MAINTENANCE SERVICES - - 10,000 0.00% 52-520-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 16,000 0.00% 52-520-54-00-5498 PAYING AGENT FEES - - 750 0.00% 52-520-54-00-5499 BAD DEBT - - 3,000 0.00% Supplies 52-520-56-00-5600 WEARING APPAREL - - 3,980 0.00% 52-520-56-00-5610 OFFICE SUPPLIES - - 1,000 0.00% 52-520-56-00-5613 LIFT STATION MAINTENANCE 71 71 8,000 0.89% 52-520-56-00-5620 OPERATING SUPPLIES 75 75 12,000 0.62% 52-520-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - - 10,000 0.00% 52-520-56-00-5630 SMALL TOOLS & EQUIPMENT - - 2,000 0.00% 52-520-56-00-5640 REPAIR & MAINTENANCE - - 5,000 0.00% 52-520-56-00-5665 JULIE SUPPLIES - - 2,233 0.00% 52-520-56-00-5695 GASOLINE - - 24,043 0.00% Capital Outlay 52-520-60-00-6001 SCADA SYSTEM - - 67,000 0.00% 52-520-60-00-6059 US34 (IL RT47/ORCHARD) PROJECT - - 650 0.00% 52-520-60-00-6060 EQUIPMENT - - 80,000 0.00% 52-520-60-00-6066 RTE 71 SEWER MAIN REPLACEMENT - - 34,223 0.00% 52-520-60-00-6070 VEHICLES 11,164 11,164 - 0.00% 52-520-60-00-6079 ROUTE 47 EXPANSION 1,873 1,873 22,488 8.33% 2003 IRBB Debt Certificates 52-520-90-00-8000 PRINCIPAL PAYMENT - - 140,000 0.00% 52-520-90-00-8050 INTEREST PAYMENT - - 22,850 0.00% 2011 Refunding Bond 52-520-92-00-8000 PRINCIPAL PAYMENT - - 885,000 0.00% 52-520-92-00-8050 INTEREST PAYMENT - - 252,948 0.00% 16 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 Other Financing Uses 52-520-99-00-9951 TRANSFER TO WATER 6,260 6,260 75,125 8.33% TOTAL FUND REVENUES 28,407 28,407 1,817,867 1.56% TOTAL FUND EXPENSES 73,137 73,137 2,286,552 3.20% FUND SURPLUS (DEFICIT)(44,730) (44,730) (468,685) LAND CASH REVENUES 72-000-47-00-4701 WHITE OAK - - 1,406 0.00% 72-000-47-00-4702 WHISPERING MEADOWS - - 4,699 0.00% 72-000-47-00-4704 BLACKBERRY WOODS 568 568 1,932 29.41% 72-000-47-00-4706 CALEDONIA 1,007 1,007 4,698 21.43% 72-000-47-00-4707 RIVERS EDGE - - 671 0.00% 72-000-47-00-4708 COUNTRY HILLS - - 4,358 0.00% 72-000-47-00-4711 FOX HIGHLANDS - - 3,298 0.00% 72-000-47-00-4724 KENDALL MARKETPLACE 324 324 2,752 11.77% 72-000-47-00-4725 HEARTLAND MEADOWS - - 3,522 0.00% 72-000-47-00-4727 CIMARRON RIDGE - - 1,377 0.00% 72-000-47-00-4736 BRIARWOOD - - 5,145 0.00% TOTAL REVENUES: LAND CASH 1,899 1,899 33,858 5.61% LAND CASH EXPENDITURES 72-720-54-00-5485 RENTAL & LEASE PURCHASE 5,290 5,290 5,287 100.05% 72-720-60-00-6013 BEECHER CENTER PARK - - 95,000 0.00% 72-720-60-00-6029 CALEDONIA PARK - - 85,000 0.00% 72-720-60-00-6047 AUTUMN CREEK - - 50,000 0.00% 72-720-60-00-6067 BLACKBERRY CREEK NATURE PRESERVE - - 5,000 0.00% TOTAL FUND REVENUES 1,899 1,899 33,858 5.61% TOTAL FUND EXPENDITURES 5,290 5,290 240,287 2.20% FUND SURPLUS (DEFICIT) (3,391) (3,391) (206,429) PARK & RECREATION REVENUES Charges for Service 79-000-44-00-4402 SPECIAL EVENTS 1,085 1,085 90,000 1.21% 79-000-44-00-4403 CHILD DEVELOPMENT 4,464 4,464 145,000 3.08% 79-000-44-00-4404 ATHLETICS AND FITNESS (13,032) (13,032) 370,000 -3.52% 79-000-44-00-4441 CONCESSION REVENUE - - 45,000 0.00% 17 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 Investment Earnings 79-000-45-00-4500 INVESTMENT EARNINGS 112 112 1,300 8.63% Reimbursements 79-000-46-00-4690 REIMB - MISCELLANEOUS - - - 0.00% Miscellaneous 79-000-48-00-4820 RENTAL INCOME 49,816 49,816 64,216 77.58% 79-000-48-00-4825 PARK RENTALS 1,120 1,120 17,500 6.40% 79-000-48-00-4843 HOMETOWN DAYS 1,675 1,675 120,000 1.40% 79-000-48-00-4846 SPONSORSHIPS & DONATIONS 1,872 1,872 20,000 9.36% 79-000-48-00-4850 MISCELLANEOUS INCOME - - 5,000 0.00% Other Financing Sources 79-000-49-00-4901 TRANSFER FROM GENERAL 109,107 109,107 1,309,284 8.33% TOTAL REVENUES: PARK & RECREATION 156,219 156,219 2,187,300 7.14% PARKS DEPARTMENT EXPENDITURES Salaries & Wages 79-790-50-00-5010 SALARIES & WAGES 65,029 65,029 601,936 10.80% 79-790-50-00-5015 PART-TIME SALARIES - - 59,000 0.00% 79-790-50-00-5020 OVERTIME - - 5,000 0.00% Benefits 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 7,275 7,275 70,570 10.31% 79-790-52-00-5214 FICA CONTRIBUTION 4,813 4,813 48,830 9.86% 79-790-52-00-5216 GROUP HEALTH INSURANCE 24,229 24,229 155,338 15.60% 79-790-52-00-5222 GROUP LIFE INSURANCE 54 54 645 8.34% 79-790-52-00-5223 DENTAL INSURANCE 846 846 9,708 8.72% 79-790-52-00-5224 VISION INSURANCE 263 263 1,537 17.11% Contractual Services 79-790-54-00-5412 TRAINING & CONFERENCES 23 23 7,000 0.32% 79-790-54-00-5415 TRAVEL & LODGING - - 3,000 0.00% 79-790-54-00-5422 VEHICLE & EQUIPMENT CHARGEBACK - - 75,000 0.00% 79-790-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - 875 0.00% 79-790-54-00-5440 TELECOMMUNICATIONS - - 8,100 0.00% 79-790-54-00-5462 PROFESSIONAL SERVICES 510 510 11,400 4.48% 79-790-54-00-5466 LEGAL SERVICES - - 2,000 0.00% 79-790-54-00-5485 RENTAL & LEASE PURCHASE 95 95 2,500 3.78% 79-790-54-00-5488 OFFICE CLEANING - - 3,078 0.00% 79-790-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 33,759 0.00% Supplies 79-790-56-00-5600 WEARING APPAREL - - 6,220 0.00% 79-790-56-00-5620 OPERATING SUPPLIES - - 25,000 0.00% 18 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 79-790-56-00-5630 SMALL TOOLS & EQUIPMENT - - 6,000 0.00% 79-790-56-00-5640 REPAIR & MAINTENANCE - - 71,000 0.00% 79-790-56-00-5646 ATHLETIC FIELDS & EQUIPMENT - - 55,000 0.00% 79-790-56-00-5695 GASOLINE - - 27,189 0.00% TOTAL EXPENDITURES: PARKS DEPT 103,136 103,136 1,289,685 8.00% RECREATION DEPARTMENT EXPENDITURES Salaries & Wages 79-795-50-00-5010 SALARIES & WAGES 40,602 40,602 387,576 10.48% 79-795-50-00-5015 PART-TIME SALARIES 240 240 23,500 1.02% 79-795-50-00-5045 CONCESSION WAGES - - 15,000 0.00% 79-795-50-00-5046 PRE-SCHOOL WAGES 561 561 40,000 1.40% 79-795-50-00-5052 INSTRUCTORS WAGES 840 840 40,000 2.10% Benefits 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION 4,544 4,544 49,493 9.18% 79-795-52-00-5214 FICA CONTRIBUTION 3,153 3,153 37,543 8.40% 79-795-52-00-5216 GROUP HEALTH INSURANCE 13,693 13,693 103,025 13.29% 79-795-52-00-5222 GROUP LIFE INSURANCE 38 38 475 8.03% 79-795-52-00-5223 DENTAL INSURANCE 526 526 6,744 7.79% 79-795-52-00-5224 VISION INSURANCE 170 170 1,092 15.57% Contractual Services 79-795-54-00-5412 TRAINING & CONFERENCES - - 5,000 0.00% 79-795-54-00-5415 TRAVEL & LODGING - - 3,000 0.00% 79-795-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - 875 0.00% 79-795-54-00-5426 PUBLISHING & ADVERTISING - - 55,000 0.00% 79-795-54-00-5440 TELECOMMUNICATIONS - - 8,750 0.00% 79-795-54-00-5447 SCHOLARSHIPS - - 2,500 0.00% 79-795-54-00-5452 POSTAGE & SHIPPING 213 213 3,500 6.07% 79-795-54-00-5460 DUES & SUBSCRIPTIONS 664 664 3,000 22.12% 79-795-54-00-5462 PROFESSIONAL SERVICES 195 195 140,000 0.14% 79-795-54-00-5480 UTILITIES - - 15,150 0.00% 79-795-54-00-5485 RENTAL & LEASE PURCHASE 135 135 3,000 4.49% 79-795-54-00-5488 OFFICE CLEANING - - 3,078 0.00% 79-795-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 3,000 0.00% Supplies 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 11,725 11,725 120,000 9.77% 79-795-56-00-5606 PROGRAM SUPPLIES 893 893 158,241 0.56% 79-795-56-00-5607 CONCESSION SUPPLIES - - 18,000 0.00% 19 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 79-795-56-00-5610 OFFICE SUPPLIES - - 3,000 0.00% 79-795-56-00-5620 OPERATING SUPPLIES - - 15,000 0.00% 79-795-56-00-5640 REPAIR & MAINTENANCE - - 2,000 0.00% 79-795-56-00-5695 GASOLINE - - 535 0.00% TOTAL EXPENDITURES: RECREATION DEPT 78,190 78,190 1,267,077 6.17% TOTAL FUND REVENUES 156,219 156,219 2,187,300 7.14% TOTAL FUND EXPENDITURES 181,326 181,326 2,556,762 7.09% FUND SURPLUS (DEFICIT)(25,107) (25,107) (369,462) LIBRARY OPERATIONS REVENUES Taxes 82-000-40-00-4000 PROPERTY TAXES - - 739,047 0.00% 82-000-40-00-4083 PROPERTY TAXES-DEBT SERVICE - - 822,953 0.00% Intergovernmental 82-000-41-00-4120 PERSONAL PROPERTY TAX 800 800 5,250 15.24% 82-000-41-00-4170 STATE GRANTS - - 20,000 0.00% Fines & Forfeits 82-000-43-00-4330 LIBRARY FINES - - 8,500 0.00% Charges for Service 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS - - 8,500 0.00% 82-000-44-00-4422 COPY FEES - - 3,800 0.00% Investment Earnings 82-000-45-00-4500 INVESTMENT EARNINGS 203 203 8,959 2.26% Miscellaneous 82-000-48-00-4820 RENTAL INCOME - - 1,750 0.00% 82-000-48-00-4850 MISCELLANEOUS INCOME - - 2,000 0.00% Other Financing Sources 82-000-49-00-4901 TRANSFER FROM GENERAL 5,911 5,911 26,584 22.24% TOTAL REVENUES: LIBRARY 6,914 6,914 1,647,343 0.42% LIBRARY OPERATIONS EXPENDITURES Salaries & Wages 82-820-50-00-5010 SALARIES & WAGES 31,602 31,602 289,742 10.91% 82-820-50-00-5015 PART-TIME SALARIES 19,929 19,929 190,000 10.49% Benefits 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 3,547 3,547 32,779 10.82% 82-820-52-00-5214 FICA CONTRIBUTION 3,886 3,886 35,952 10.81% 82-820-52-00-5216 GROUP HEALTH INSURANCE 10,625 10,625 76,764 13.84% 82-820-52-00-5222 GROUP LIFE INSURANCE 29 29 387 7.48% 20 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 82-820-52-00-5223 DENTAL INSURANCE 527 527 6,322 8.33% 82-820-52-00-5224 VISION INSURANCE 169 169 1,012 16.67% 82-820-52-00-5230 UNEMPLOYMENT INSURANCE 333 333 750 44.39% 82-820-52-00-5231 LIABILITY INSURANCE 5,578 5,578 25,834 21.59% Contractual Services 82-820-54-00-5412 TRAINING & CONFERENCES - - 3,000 0.00% 82-820-54-00-5415 TRAVEL & LODGING - - 1,500 0.00% 82-820-54-00-5426 PUBLISHING & ADVERTISING - - 2,500 0.00% 82-820-54-00-5440 TELECOMMUNICATIONS - - 7,200 0.00% 82-820-54-00-5452 POSTAGE & SHIPPING - - 750 0.00% 82-820-54-00-5460 DUES & SUBSCRIPTIONS 593 593 11,000 5.39% 82-820-54-00-5462 PROFESSIONAL SERVICES 3,865 3,865 40,000 9.66% 82-820-54-00-5466 LEGAL SERVICES - - 3,000 0.00% 82-820-54-00-5468 AUTOMATION 2,366 2,366 20,000 11.83% 82-820-54-00-5480 UTILITIES - - 11,798 0.00% 82-820-54-00-5495 OUTSIDE REPAIR & MAINTENANCE - - 50,000 0.00% 82-820-54-00-5498 PAYING AGENT FEES - - 1,700 0.00% Supplies 82-820-56-00-5610 OFFICE SUPPLIES - - 8,000 0.00% 82-820-56-00-5620 OPERATING SUPPLIES - - 4,000 0.00% 82-820-56-00-5621 CUSTODIAL SUPPLIES - - 7,000 0.00% 82-820-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - - 2,000 0.00% 82-820-56-00-5671 LIBRARY PROGRAMMING - - 2,000 0.00% 82-820-56-00-5675 EMPLOYEE RECOGNITION - - 300 0.00% 82-820-56-00-5685 DVD'S - - 500 0.00% 82-820-56-00-5686 BOOKS - - 1,500 0.00% 2006 Bond 82-820-84-00-8000 PRINCIPAL PAYMENT - - 75,000 0.00% 82-820-84-00-8050 INTEREST PAYMENT - - 20,238 0.00% 2013 Refunding Bond 82-820-99-00-8000 PRINCIPAL PAYMENT - - 610,000 0.00% 82-820-99-00-8050 INTEREST PAYMENT - - 121,850 0.00% TOTAL FUND REVENUES 6,914 6,914 1,647,343 0.42% TOTAL FUND EXPENDITURES 83,048 83,048 1,664,378 4.99% FUND SURPLUS (DEFICIT) (76,134) (76,134) (17,035) 21 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 LIBRARY CAPITAL REVENUES 84-000-42-00-4214 DEVELOPMENT FEES 3,500 3,500 50,000 7.00% 84-000-45-00-4500 INVESTMENT EARNINGS 16 16 500 3.18% TOTAL REVENUES: LIBRARY CAPITAL 3,516 3,516 50,500 6.96% LIBRARY CAPITAL EXPENDITURES 84-840-54-00-5460 E-BOOK SUBSCRIPTIONS - - 3,500 0.00% 84-840-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - - 15,000 0.00% 84-840-56-00-5683 AUDIO BOOKS - - 3,500 0.00% 84-840-56-00-5684 COMPACT DISCS & OTHER MUSIC - - 500 0.00% 84-840-56-00-5685 DVD'S - - 3,000 0.00% 84-840-56-00-5686 BOOKS - - 50,000 0.00% TOTAL FUND REVENUES 3,516 3,516 50,500 6.96% TOTAL FUND EXPENDITURES - - 75,500 0.00% FUND SURPLUS (DEFICIT) 3,516 3,516 (25,000) COUNTRYSIDE TIF REVENUES 87-000-40-00-4000 PROPERTY TAXES - - 153,965 0.00% TOTAL REVENUES: COUNTRYSIDE TIF - - 153,965 0.00% COUNTRYSIDE TIF EXPENDITURES Contractual Services 87-870-54-00-5401 ADMINISTRATIVE CHARGEBACK 956 956 11,475 8.33% 87-870-54-00-5462 PROFESSIONAL SERVICES - - 2,000 0.00% 87-870-54-00-5498 PAYING AGENT FEES - - 700 0.00% 2015A Bond 87-870-77-00-8000 PRINCIPAL PAYMENT - - 107,163 0.00% 87-870-77-00-8050 INTEREST PAYMENT 25,216 25,216 50,433 50.00% 2014 Refunding Bond 87-870-93-00-8050 INTEREST PAYMENT 25,358 25,358 50,715 50.00% TOTAL FUND REVENUES - - 153,965 0.00% TOTAL FUND EXPENDITURES 51,530 51,530 222,486 23.16% FUND SURPLUS (DEFICIT) (51,530) (51,530) (68,521) DOWNTOWN TIF REVENUES 88-000-40-00-4000 PROPERTY TAXES - - 76,000 0.00% TOTAL REVENUES: DOWNTOWN TIF - - 76,000 0.00% 22 % of Fiscal Year 8%Year-to-Date FISCAL YEAR 2021 ACCOUNT NUMBER DESCRIPTION May-20 Totals BUDGET % of Budget UNITED CITY OF YORKVILLE FISCAL YEAR 2021 BUDGET REPORT For the Month Ended May 31, 2020 DOWNTOWN TIF EXPENDITURES Contractual Services 88-880-54-00-5401 ADMINISTRATIVE CHARGEBACK 2,791 2,791 33,487 8.33% 88-880-54-00-5425 TIF INCENTIVE PAYOUT - - 26,877 0.00% 88-880-54-00-5462 PROFESSIONAL SERVICES - - 1,000 0.00% 88-880-54-00-5466 LEGAL SERVICES - - 15,000 0.00% Capital Outlay 88-880-60-00-6000 PROJECT COSTS - - 10,000 0.00% 88-880-60-00-6079 ROUTE 47 EXPANSION 624 624 7,488 8.33% FNBO Loan - 102 E Van Emmon Building 88-880-81-00-8000 PRINCIPAL PAYMENT - - 200,000 0.00% 88-880-81-00-8050 INTEREST PAYMENT - - 12,200 0.00% TOTAL FUND REVENUES - - 76,000 0.00% TOTAL FUND EXPENDITURES 3,415 3,415 306,052 1.12% FUND SURPLUS (DEFICIT) (3,415) (3,415) (230,052) DOWNTOWN TIF II REVENUES 89-000-40-00-4000 PROPERTY TAXES - - 25,000 0.00% TOTAL REVENUES: DOWNTOWN TIF II - - 25,000 0.00% DOWNTOWN TIF II EXPENDITURES 89-890-54-00-5425 TIF INCENTIVE PAYOUT - - 17,500 0.00% 89-890-54-00-5462 PROFESSIONAL SERVICES - - 5,000 0.00% TOTAL FUND REVENUES - - 25,000 0.00% TOTAL FUND EXPENDITURES - - 22,500 0.00% FUND SURPLUS (DEFICIT) - - 2,500 23 May YTD % of FY 2021 Actual Actual Budget Budget YTD Actual % Change GENERAL FUND (01) REVENUES Property Taxes -$ -$ 0.0% 3,337,703$ 266,903$ -100.00% Municipal Sales Tax 231,048 231,048 7.0% 3,284,400 211,897 9.04% Non-Home Rule Sales Tax 152,373 152,373 6.1% 2,493,900 157,270 -3.11% Electric Utility Tax - - 0.0% 715,000 - 0.00% Natural Gas Tax 22,870 22,870 8.6% 265,000 24,573 -6.93% Excise (Telecommunication) Tax 20,790 20,790 8.4% 246,075 32,276 -35.59% Cable Franchise Fees 63,267 63,267 21.1% 300,000 63,971 -1.10% Hotel Tax 1,239 1,239 1.5% 80,000 1,549 -20.00% Video Gaming Tax 7,193 7,193 5.1% 140,000 14,990 -52.01% Amusement Tax - - 0.0% 205,000 4,592 -100.00% State Income Tax 191,781 191,781 10.1% 1,897,310 381,988 -49.79% Local Use Tax 47,285 47,285 7.0% 675,281 45,940 2.93% Road & Bridge Tax - - 0.0% 130,000 10,903 -100.00% Building Permits 39,882 39,882 10.0% 400,000 46,319 -13.90% Garbage Surcharge 482 482$ 0.0% 1,297,650 873 -44.81% Investment Earnings 2,021 2,021$ 2.2% 89,878$ 11,033 -81.68% MOTOR FUEL TAX FUND (15) REVENUES Motor Fuel Tax 33,790$ 33,790$ 7.1% 472,697$ 42,104$ -19.75% Transportation Renewal Funds 22,626$ 22,626$ 7.1% 320,901$ -$ 0.00% WATER FUND (51) REVENUES Water Sales (524)$ (524)$ 0.0% 3,129,000$ 5,750$ -109.11% Water Infrastructure Fees 454 454 0.1% 795,000 610 -25.53% Late Penalties - - 0.0% 131,250 32 -100.00% Water Connection Fees 35,014 35,014 15.2% 230,000 35,220 -0.58% Water Meter Sales 9,850 9,850 16.4% 60,000 17,755 -44.52% SEWER FUND (52) REVENUES Sewer Maintenance Fees 538$ 538$ 0.1% 1,024,850$ 666$ -19.27% Sewer Infrastructure Fees 236 236 0.1% 390,000 (220) -207.49% Sewer Connection Fees 13,000 13,000 6.4% 203,300 29,000 -55.17% PARKS & RECREATION (79) REVENUES Special Events 1,085$ 1,085$ 1.2% 90,000$ 22,500$ -95.18% Child Development 4,464 4,464 3.1% 145,000 14,922 -70.09% Athletics & Fitness (13,032) (13,032) -3.5% 370,000 37,842 -134.44% Rental Income 49,816 49,816 77.6% 64,216 48,650 2.40% Hometown Days 1,675 1,675 1.4% 120,000 6,775 -75.28% *May represents 8% of fiscal year 2021 UNITED CITY OF YORKVILLE MONTHLY ANALYSIS OF MAJOR REVENUES For the Month Ended May 31, 2020 * Fiscal Year 2020 For the Month Ended May 31, 2019 24 May YTD % of FY 2021 Actual Actual Budget Budget YTD Actual % Change GENERAL FUND (01) Revenues Local Taxes Property Taxes -$ -$ 0.0% 3,337,703$ 266,903$ -100.00% Municipal Sales Tax 231,048 231,048 7.0% 3,284,400 211,897 9.04% Non-Home Rule Sales Tax 152,373 152,373 6.1% 2,493,900 157,270 -3.11% Electric Utility Tax - - 0.0% 715,000 - 0.00% Natural Gas Tax 22,870 22,870 8.6% 265,000 24,573 -6.93% Excise (Telecommunication) Tax 20,790 20,790 8.4% 246,075 32,276 -35.59% Telephone Utility Tax 695 695 8.3%8,340 695 0.00% Cable Franchise Fees 63,267 63,267 21.1% 300,000 63,971 -1.10% Hotel Tax 1,239 1,239 1.5% 80,000 1,549 -20.00% Video Gaming Tax 7,193 7,193 5.1% 140,000 14,990 -52.01% Amusement Tax - - 0.0% 205,000 4,592 -100.00% Admissions Tax - - 0.0% 145,000 - 0.00% Business District Tax 26,313 26,313 6.5% 405,160 43,699 -39.79% Auto Rental Tax 1,247 1,247 8.2% 15,250 0 0.00% Total Taxes 527,035$ 527,035$ 4.5% 11,640,828$ 822,415$ -35.92% Intergovernmental State Income Tax 191,781$ 191,781$ 10.1% 1,897,310$ 381,988$ -49.79% Local Use Tax 47,285 47,285 7.0% 675,281 45,940 2.93% Cannabis Exise Tax 896 896 0.0% 15,218.00 - 0.00% Road & Bridge Tax - - 0.0% 130,000 10,903 -100.00% Personal Property Replacement Tax 2,414 2,414 14.6% 16,500 4,406 -45.22% Other Intergovernmental 20,276 20,276 56.4% 35,925 - 0.00% Total Intergovernmental 262,651$ 262,651$ 9.5% 2,770,234$ 443,237$ -40.74% Licenses & Permits Liquor Licenses 3,081$ 3,081$ 4.7% 65,000$ 450$ 584.75% Building Permits 39,882 39,882 10.0% 400,000 46,319 -13.90% Other Licenses & Permits 310 310 3.3%9,500 1,777 -82.55% Total Licenses & Permits 43,273$ 43,273$ 9.1% 474,500$ 48,546$ -10.86% Fines & Forfeits Circuit Court Fines 863$ 863$ 2.2% 40,000$ 2,839$ -69.61% Administrative Adjudication 2,284 2,284 8.3% 27,500 1,471 55.24% Police Tows 3,000 3,000 6.7% 45,000 2,500 20.00% Other Fines & Forfeits - - 0.0%500 35 -100.00% Total Fines & Forfeits 6,146$ 6,146$ 5.4% 113,000$ 6,845$ -10.20% Charges for Services ^Garbage Surcharge 482$ 482$ 0.0% 1,297,650$ 873$ -44.81% ^Late PMT Penalties - Garbage - - 0.0% 25,000 2 -100.00% ^UB Collection Fees 13,942 13,942 8.4% 165,000 16,638 -16.20% Administrative Chargebacks 17,825 17,825 8.3% 213,896 17,070 4.42% Other Services - - 0.0%500 - 0.00% Total Charges for Services 32,249$ 32,249$ 1.9% 1,702,046$ 34,583$ -6.75% Investment Earnings 2,021$ 2,021$ 2.2% 89,878$ 11,033$ -81.68% UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended May 31, 2020 * Fiscal Year 2020 For the Month Ended May 31, 2019 25 May YTD % of FY 2021 Actual Actual Budget Budget YTD Actual % Change UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended May 31, 2020 * Fiscal Year 2020 For the Month Ended May 31, 2019 GENERAL FUND (01) (continued) Reimbursements/Miscellaneous/Transfers In Reimb - Engineering & Legal Expenses -$ -$ 0.0% 25,000$ -$ 0.00% Other Reimbursements 9,649 9,649 15.3% 63,000 296 3159.72% Rental Income - - 0.0%7,000 500 -100.00% Miscellaneous Income & Transfers In - - 0.0% 48,000 4,837 0.00% Total Miscellaneous 9,649$ 9,649$ 6.7% 143,000$ 5,633$ 71.29% Total Revenues and Transfers 883,025$ 883,025$ 5.2% 16,933,486$ 1,372,292$ -35.65% Expenditures Administration 93,625$ 93,625$ 9.4%992,350$ 111,331$ -15.90% 50 Salaries 64,139 64,139 10.5% 611,747 66,606 -3.70% 52 Benefits 25,969 25,969 12.3% 211,572 32,411 -19.88% 54 Contractual Services 3,517 3,517 2.3% 150,031 12,174 -71.11% 56 Supplies - - 0.0% 19,000 140 -100.00% Finance 50,753$ 50,753$ 9.0%562,508$ 48,863$ 3.87% 50 Salaries 32,610 32,610 10.0% 324,856 31,356 4.00% 52 Benefits 15,325 15,325 12.4% 123,295 14,813 3.46% 54 Contractual Services 2,818 2,818 2.5% 111,857 2,694 4.59% 56 Supplies - - 0.0%2,500 - 0.00% Police 484,921$ 484,921$ 8.0%6,064,220$ 614,276$ -21.06% Salaries 336,485 336,485 10.1% 3,323,608 336,944 -0.14% Overtime 4,467 4,467 4.0% 111,000 10,944 -59.18% 52 Benefits 134,741 134,741 6.1% 2,205,107 233,007 -42.17% 54 Contractual Services 9,228 9,228 3.0% 311,025 27,773 -66.77% 56 Supplies - - 0.0% 113,480 5,608 -100.00% Community Development 83,195$ 83,195$ 8.8%942,154$ 84,874$ -1.98% 50 Salaries 55,320 55,320 10.3% 535,995 57,405 -3.63% 52 Benefits 25,638 25,638 12.7% 201,768 25,788 -0.58% 54 Contractual Services 2,237 2,237 1.1% 194,700 1,681 33.05% 56 Supplies - - 0.0%9,691 - 0.00% PW - Street Ops & Sanitation 76,956$ 76,956$ 3.1%2,512,538$ 65,400$ 17.67% Salaries 47,751 47,751 9.0% 529,443 39,646 20.44% Overtime - - 0.0% 20,000 - 0.00% 52 Benefits 28,633 28,633 11.7% 245,418 22,516 27.17% 54 Contractual Services 436 436 0.0% 1,591,767 2,867 -84.78% 56 Supplies 136 136 0.1% 125,910 371 -63.27% Administrative Services 302,454$ 302,454$ 5.2%5,824,862$ 345,005$ -12.33% 50 Salaries - - 0.0%500 - 0.00% 52 Benefits 90,744 90,744 22.8% 398,253 83,038 9.28% 54 Contractual Services 34,194 34,194 1.1% 3,245,272 64,262 -46.79% 56 Supplies - - 0.0% 15,000 - 0.00% 99 Transfers Out 177,515 177,515 8.2% 2,165,837 197,705 -10.21% Total Expenditures and Transfers 1,091,904$ 1,091,904$ 6.5% 16,898,632$ 1,269,749$ -14.01% Surplus(Deficit)(208,879)$ (208,879)$ 34,854$ 102,543$ ^modified accruals basis *May represents 8% of fiscal year 2021 50 50 26 May YTD % of FY 2021 Actual Actual Budget Budget YTD Actual % Change WATER FUND (51) Revenues ^ Water Sales (524)$ (524)$ 0.0% 3,129,000$ 5,750$ -109.11% ^ Water Infrastructure Fees 454 454 0.1% 795,000 610 -25.53% ^ Late Penalties - - 0.0% 131,250 32 -100.00% Water Connection Fees 35,014 35,014 15.2% 230,000 35,220 -0.58% Bulk Water Sales (1,950) (1,950) -39.0% 5,000 - 0.00% Water Meter Sales 9,850 9,850 16.4% 60,000 17,755 -44.52% Total Charges for Services 42,845$ 42,845$ 1.0% 4,350,250$ 59,367$ -27.83% Investment Earnings 149$ 149$ 0.7% 22,557$ 1,619$ -90.80% Reimbursements/Miscellaneous/Transfers In Reimbursements 9,459$ 9,459$ 0.0%-$ -$ 0.00% Rental Income 8,295 8,295 8.3% 100,010 10,982 -24.47% Miscellaneous Income & Transfers In 14,918 14,918 8.3% 179,270 15,413 -3.21% Total Miscellaneous 32,672$ 32,672$ 11.7% 279,280$ 26,395$ 23.78% Total Revenues and Transfers 75,666$ 75,666$ 1.6% 4,652,087$ 87,381$ -13.41% Expenses Water Operations Salaries 48,833$ 48,833$ 10.0% 487,530$ 41,339$ 18.13% Overtime 439 439 2.0% 22,000 631 -30.42% 52 Benefits 33,171 33,171 13.8% 241,168 29,730 11.58% 54 Contractual Services 31,283 31,283 2.9% 1,078,983 36,504 -14.30% 56 Supplies 2,528 2,528 0.7% 359,273 9,136 -72.33% 60 Capital Outlay 3,781$ 3,781$ 1,333,243$ 3,781$ 0.00% Well Rehabilitations & Water Tower Paintin - - 0.0% 18,000 Road to Better Roads Program - - 0.0% 634,000 US 34 Project (IL Rte 47 to Orchard) - - 0.0% 7,700 Route 71 Watermain Replacement - - 0.0% 12,871 Route 47 Expansion 3,781 3,781 8.3% 45,372 Cation Exhange Media Replacement - - 0.0% 25,000 Vehicles & Equipment - - 0.0% 590,300 Debt Service 70,084$ 70,084$ 2,305,935$ 75,893$ -7.65% 2015A Bond 70,084 70,084 16.0% 438,004 2016 Refunding Bond - - 0.0% 1,592,650 IEPA Loan L17-156300 - - 0.0% 125,031 2014C Refunding Bond - - 0.0% 150,250 Total Expenses 190,120$ 190,120$ 3.3% 5,828,132$ 197,014$ -3.50% Surplus(Deficit)(114,454)$ (114,454)$ (1,176,045)$ (109,633)$ ^modified accruals basis *May represents 8% of fiscal year 2021 94 Charges for Services 89 50 6025 6059 6022 6066 6081 6079 6070 77 85 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENSES AND TRANSFERS For the Month Ended May 31, 2020 * Fiscal Year 2020 For the Month Ended May 31, 2019 27 May YTD % of FY 2021 Actual Actual Budget Budget YTD Actual % Change SEWER FUND (52) Revenues ^Sewer Maintenance Fees 538$ 538$ 0.1% 1,024,850$ 666$ -19.27% ^Sewer Infrastructure Fees 236 236 0.1% 390,000 (220) -207.49% River Crossing Fees - - 0.0% - 300 -100.00% ^Late Penalties - - 0.0% 17,500 4 -100.00% Sewer Connection Fees 13,000 13,000 6.4% 203,300 29,000 -55.17% Total Charges for Services 13,774$ 13,774$ 0.8% 1,635,650$ 29,750$ -53.70% Investment Earnings 71$ 71$ 1.0% 7,473$ 598$ -88.12% Reimbursements/Miscellaneous/Transfers In Miscellaneous Income & Transfers In 14,562 14,562 8.3% 174,744 48,228 -69.81% Total Miscellaneous 14,562$ 14,562$ 8.3% 174,744$ 48,228$ -69.81% Total Revenues and Transfers 28,407$ 28,407$ 1.6% 1,817,867$ 78,576$ -63.85% Expenses Sewer Operations Salaries 26,709$ 26,709$ 10.5% 255,561$ 17,779$ 50.23% Overtime - - 0.0%500 47 -100.00% 52 Benefits 21,477 21,477 14.5% 147,784 15,955 34.61% 54 Contractual Services 5,507 5,507 2.4% 234,167 6,752 -18.44% 56 Supplies 146 146 0.2% 68,256 293 -50.19% 60 Capital Outlay 13,037$ 13,037$ 204,361$ 1,873$ 596.07% SCADA - - 0.0% 67,000 US 34 Project (IL Rte 47 to Orchard)- - 0.0%650 Route 71 Sewer Main Replacement - - 0.0% 34,223 Vehicles & Equipment 11,164 11,164 14.0% 80,000 Route 47 Expansion 1,873 1,873 8.3% 22,488 Debt Service -$ -$ 1,300,798$ -$ 0.00% 2003 IRBB Debt Certificates - - 0.0% 162,850 2011 Refunding Bond - - 0.0% 1,137,948 99 Transfers Out 6,260$ 6,260$ 8.3% 75,125$ 6,156$ 1.70% Total Expenses and Transfers 73,137$ 73,137$ 3.2% 2,286,552$ 48,855$ 49.70% Surplus(Deficit)(44,730)$ (44,730)$ (468,685)$ 29,721$ ^modified accruals basis *May represents 8% of fiscal year 2021 6079 90 92 6070 Charges for Services 50 6001 6059 6066 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENSES AND TRANSFERS For the Month Ended May 31, 2020 * Fiscal Year 2020 For the Month Ended May 31, 2019 28 May YTD % of FY 2021 Actual Actual Budget Budget YTD Actual % Change PARKS & RECREATION FUND (79) Revenues Charges for Services Special Events 1,085$ 1,085$ 1.2% 90,000$ 22,500$ -95.18% Child Development 4,464 4,464 3.1% 145,000 14,922 -70.09% Athletics & Fitness (13,032) (13,032) -3.5% 370,000 37,842 -134.44% Concession Revenue - - 0.0% 45,000 5,681 -100.00% Total Charges for Services (7,483)$ (7,483)$ -1.2% 650,000$ 80,945$ -109.24% Investment Earnings 112$ 112$ 8.6%1,300$ 126$ -11.00% Reimbursements/Miscellaneous/Transfers In Reimbursements -$ -$ 0.0%-$ -$ 0.00% Rental Income 49,816 49,816 77.6% 64,216 48,650 2.40% Park Rentals 1,120 1,120 6.4% 17,500 2,838 -60.54% Hometown Days 1,675 1,675 1.4% 120,000 6,775 -75.28% Sponsorships & Donations 1,872 1,872 9.4% 20,000 5,419 -65.45% Miscellaneous Income & Transfers In 109,107 109,107 8.3% 1,314,284 118,764 -8.13% Total Miscellaneous 163,590$ 163,590$ 10.7% 1,536,000$ 182,446$ -10.34% Total Revenues and Transfers 156,219$ 156,219$ 7.1% 2,187,300$ 263,517$ -40.72% Expenditures Parks Department 103,136$ 103,136$ 8.0%1,289,685$ 117,699$ -12.37% Salaries 65,029 65,029 9.8% 660,936 71,401 -8.92% Overtime - - 0.0%5,000 73 -100.00% 52 Benefits 37,480 37,480 13.1% 286,628 43,310 -13.46% 54 Contractual Services 627 627 0.4% 146,712 2,495 -74.85% 56 Supplies - - 0.0% 190,409 420 -100.00% Recreation Department 78,190$ 78,190$ 6.2%1,267,077$ 103,631$ -24.55% 50 Salaries 42,243 42,243 8.3% 506,076 52,928 -20.19% 52 Benefits 22,123 22,123 11.2% 198,372 24,062 -8.06% 54 Contractual Services 1,206 1,206 0.5% 245,853 7,058 -82.91% 56 Hometown Days 11,725 11,725 9.8% 120,000 10,800 8.56% 56 Supplies 893 893 0.5% 196,776 8,783 -89.83% Total Expenditures 181,326$ 181,326$ 7.1% 2,556,762$ 221,330$ -18.07% Surplus(Deficit)(25,107)$ (25,107)$ (369,462)$ 42,187$ *May represents 8% of fiscal year 2021 YORKVILLE PARKS & RECREATION STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended May 31, 2020 * Fiscal Year 2020 For the Month Ended May 31, 2019 50 29 May YTD % of FY 2021 Actual Actual Budget Budget YTD Actual % Change LIBRARY OPERATIONS FUND (82) Revenues Property Taxes -$ -$ 0.0% 1,562,000$ 123,669$ -100.00% Intergovernmental Personal Property Replacement Tax 800$ 800$ 15.2%5,250$ 1,460$ -45.21% State Grants - - 0.0% 20,000 - 0.00% Total Intergovernmental 800$ 800$ 3.2% 25,250$ 1,460$ -45.21% Library Fines -$ -$ 0.0%8,500$ 434$ -100.00% Charges for Services Library Subscription Cards -$ -$ 0.0%8,500$ 1,193$ -100.00% Copy Fees - - 0.0%3,800 294 -100.00% Program Fees - - 0.0%- - 0.00% Total Charges for Services -$ -$ 0.0% 12,300$ 1,487$ -100.00% Investment Earnings 203$ 203$ 2.3%8,959$ 735$ -72.43% Reimbursements/Miscellaneous/Transfers In Miscellaneous Reimbursements -$ -$ 0.0%-$ -$ 0.00% Rental Income - - 0.0%1,750 200 -100.00% DVD Rental Income - - 0.0%- - 0.00% Miscellaneous Income - - 0.0%2,000 1,981 -100.00% Transfer In 5,911 5,911 22.2% 26,584 5,588 5.78% Total Miscellaneous & Transfers 5,911$ 5,911$ 19.5% 30,334$ 7,770$ -23.92% Total Revenues and Transfers 6,914$ 6,914$ 0.4% 1,647,343$ 135,555$ -94.90% Expenditures Library Operations 83,048$ 83,049$ 5.0%1,664,378$ 83,303$ -0.31% 50 Salaries 51,531 51,532 10.7% 479,742 50,537 1.97% 52 Benefits 24,693 24,693 13.7% 179,800 24,676 0.07% 54 Contractual Services 6,824 6,824 4.5% 152,448 8,090 -15.65% 56 Supplies - - 0.0% 25,300 - 0.00% 99 Debt Service - - 0.0% 827,088 - 0.00% Total Expenditures and Transfers 83,048$ 83,049$ 5.0% 1,664,378$ 83,303$ -0.31% Surplus(Deficit)(76,134)$ (76,135)$ (17,035)$ 52,251$ *May represents 8% of fiscal year 2021 YORKVILLE PUBLIC LIBRARY STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended May 31, 2020 * Fiscal Year 2020 For the Month Ended May 31, 2019 30 DATE: 06/09/2020 UNITED CITY OF YORKVILLE PAGE: 1TIME: 09:46:42 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2021 ACTIVITY THROUGH FISCAL PERIOD 01PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________01-110-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 1,000.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 12,000.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________01-120-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 GJ-200531FE 06/02/2020 01 UB CC Fees - Apr 2020 611.98 06/02/2020 07 UB Paymentus Fees - Apr 2020 1,218.83 06/02/2020 13 FNBO Analysis Chrg - Apr 2020 301.68 _________________________________ TOTAL PERIOD 01 ACTIVITY 2,132.49 0.00 YTD BUDGET 5,416.67 TOTAL ACCOUNT ACTIVITY 2,132.49 0.00 ANNUAL REVISED BUDGET 65,000.00 ENDING BALANCE 2,132.49_____________________________________________________________________________________________________________________________________________________01-210-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 3,062.50 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 36,750.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________01-220-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 7,708.34 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 92,500.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________01-410-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 AP-200525MB 05/19/2020 02 MINER#100594-MAY 2020 MANAGED FIRST NATIONAL BANK 900088 052520-K.GREGORY-B 366.85 _________________________________ TOTAL PERIOD 01 ACTIVITY 366.85 0.00 YTD BUDGET 768.75 TOTAL ACCOUNT ACTIVITY 366.85 0.00 ANNUAL REVISED BUDGET 9,225.00 ENDING BALANCE 366.85_____________________________________________________________________________________________________________________________________________________01-640-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 687.50 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 8,250.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________11-111-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 260.50 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 3,126.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________12-112-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 260.50 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 3,126.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________23-230-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 416.67 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 5,000.00 ENDING BALANCE 0.00 DATE: 06/09/2020 UNITED CITY OF YORKVILLE PAGE: 2TIME: 09:47:10 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2021 ACTIVITY THROUGH FISCAL PERIOD 01PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________25-205-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 0.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 0.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________25-225-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 0.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 0.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________51-510-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 GJ-00521PRE 05/28/2020 32 Itron-May Host Srvcs 624.39 AP-200525MB 05/19/2020 07 MINER#100594-MAY 2020 MANAGED FIRST NATIONAL BANK 900088 052520-K.GREGORY-B 430.65 AP-200526B 05/19/2020 36 JUNE 2020 HOSTING SERVICES ITRON 532821 555744 624.39 GJ-200531FE 06/02/2020 03 UB CC Fees - Apr 2020 819.90 06/02/2020 09 UB Paymentus Fees - Apr 2020 1,632.94 06/02/2020 15 FNBO Analysis Chrg - Apr 2020 404.18 _________________________________ TOTAL PERIOD 01 ACTIVITY 4,536.45 0.00 YTD BUDGET 12,916.67 TOTAL ACCOUNT ACTIVITY 4,536.45 0.00 ANNUAL REVISED BUDGET 155,000.00 ENDING BALANCE 4,536.45_____________________________________________________________________________________________________________________________________________________52-520-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 AP-200525MB 05/19/2020 09 MINER#100594-MAY 2020 MANAGED FIRST NATIONAL BANK 900088 052520-K.GREGORY-B 287.10 GJ-200531FE 06/02/2020 05 UB CC Fees - Apr 2020 382.46 06/02/2020 11 UB Paymentus Fees - Apr 2020 761.73 06/02/2020 17 FNBO Analysis Chrg - Apr 2020 188.54 _________________________________ TOTAL PERIOD 01 ACTIVITY 1,619.83 0.00 YTD BUDGET 3,791.67 TOTAL ACCOUNT ACTIVITY 1,619.83 0.00 ANNUAL REVISED BUDGET 45,500.00 ENDING BALANCE 1,619.83_____________________________________________________________________________________________________________________________________________________79-790-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 AP-200525MB 05/19/2020 11 MINER#100594-MAY 2020 MANAGED FIRST NATIONAL BANK 900088 052520-K.GREGORY-B 510.40 _________________________________ TOTAL PERIOD 01 ACTIVITY 510.40 0.00 YTD BUDGET 950.00 TOTAL ACCOUNT ACTIVITY 510.40 0.00 ANNUAL REVISED BUDGET 11,400.00 ENDING BALANCE 510.40_____________________________________________________________________________________________________________________________________________________79-795-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 GJ-200531FE 06/02/2020 19 PR CC Fees - Apr 2020 195.19 _________________________________ TOTAL PERIOD 01 ACTIVITY 195.19 0.00 YTD BUDGET 11,666.67 TOTAL ACCOUNT ACTIVITY 195.19 0.00 ANNUAL REVISED BUDGET 140,000.00 ENDING BALANCE 195.19_____________________________________________________________________________________________________________________________________________________82-820-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 GJ-00521PRE 05/28/2020 55 Sound Inc-May Srvc Aggrmnt 97.00 DATE: 06/09/2020 UNITED CITY OF YORKVILLE PAGE: 3TIME: 09:47:47 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2021 ACTIVITY THROUGH FISCAL PERIOD 01PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________82-820-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 AP-200511B 05/04/2020 01 MAY 2020 COPIER LEASE DLL FINANCIAL SERVIC 104889 67565916 194.48 05/04/2020 02 MAY-JULY 2020 MAINTENANCE SOUND INCORPORATED 104891 R168569 929.52 05/04/2020 03 ANNUAL SERVICE AGREEMENT TODAY'S BUSINESS SOL 104892 10498 2,644.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 3,865.00 0.00 YTD BUDGET 3,333.34 TOTAL ACCOUNT ACTIVITY 3,865.00 0.00 ANNUAL REVISED BUDGET 40,000.00 ENDING BALANCE 3,865.00_____________________________________________________________________________________________________________________________________________________87-870-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 166.67 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 2,000.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________88-880-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 83.34 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 1,000.00 ENDING BALANCE 0.00_____________________________________________________________________________________________________________________________________________________89-890-54-00-5462 (E) PROFESSIONAL SERVICES_____________________________________________________________________________________________________________________________________________________01 05/01/2020 BEGINNING BALANCE 0.00 YTD BUDGET 416.67 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 5,000.00 ENDING BALANCE 0.00 GRAND TOTAL 13,226.21 0.00 TOTAL DIFFERENCE 13,226.21 0.00 Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #2 Tracking Number ADM 2020-41 Treasurer’s Report for May 2020 Administration Committee – June 17, 2020 Majority Approval Rob Fredrickson Finance Name Department May Revenues YTD Revenues Revenue Budget % of Budget May Expenses YTD Expenses Expense Budget % of Budget General Fund01 - General 883,025$ 883,025$ 16,933,486$ 5% 1,091,904$ 1,091,904$ 16,898,632$ 6%Special Revenue Funds15 - Motor Fuel Tax 265,772 265,772 813,861 33% 6,149 6,149 1,117,462 1%79 - Parks and Recreation 156,219 156,219 2,187,300 7% 181,326 181,326 2,556,762 7%72 - Land Cash 1,899 1,899 33,858 6% 5,290 5,290 240,287 2%87 - Countryside TIF - - 153,965 0% 51,530 51,530 222,486 23%88 - Downtown TIF - - 76,000 0% 3,415 3,415 306,052 1%89 - Downtown TIF II - - 25,000 0% - - 22,500 0%11 - Fox Hill SSA - - 16,034 0% - - 37,326 0%12 - Sunflower SSA - - 20,363 0% - - 20,326 0%Debt Service Fund42 - Debt Service 26,669 26,669 323,225 8% - - 323,225 0%Capital Project Funds25 - Vehicle & Equipment 13,553 13,553 448,823 3% 6,031 6,031 651,794 1%23 - City-Wide Capital 67,372 67,372 1,335,670 5% 71,970 71,970 1,628,147 4%Enterprise Funds *51 - Water 75,666 75,666 4,652,087 2% 190,120 190,120 5,828,132 3%*52 - Sewer 28,407 28,407 1,817,867 2% 73,137 73,137 2,286,552 3%Library Funds82 - Library Operations 6,914 6,914 1,647,343 0% 83,048 83,048 1,664,378 5%84 - Library Capital 3,516 3,516 50,500 7% - - 75,500 0%Total Funds 1,529,010$ 1,529,011$ 30,535,382$ 5% 1,763,918$ 1,763,918$ 33,879,561$ 5%* Fund Balance EquivalencyRob Fredrickson, Finance Director/TreasurerUNITED CITY OF YORKVILLE TREASURER'S REPORT - for the month ending May 31, 2020Cash BasisAs Treasurer of the United City of Yorkville, I hereby attest, to the best of my knowledge, that the information contained in this Treasurer's Report is accurate as of the date detailed herein. Further information is available in the Finance Department. Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #3 Tracking Number ADM 2020-42 Cash Statement for April 2020 Administration Committee – June 17, 2020 Informational None Rob Fredrickson Finance Name Department First National West Suburban Associated Illinois Trust Illinois Funds Old Second Grand Totals Restricted at IMET General Fund01 - General 1,712,236$ 126,280$ 3,390,622$ 100,952$ 1,412,962$ -$ 6,743,052$ 42,464$ Special Revenue Funds15 - Motor Fuel Tax - - - - 639,491 - 639,491 - 72 - Land Cash243,143 - - - - - 243,143 - 87 - Countryside TIF(1,141,784) - - - - - (1,141,784) - 88 - Downtown TIF(1,237,101) - - - - - (1,237,101) - 89 - Downtown TIF II(73,799) - - - - - (73,799) - 11 - Fox Hill SSA14,562 - - - - - 14,562 - 12 - Sunflower SSA(15,130) - - - - - (15,130) - Debt Service Fund42 - Debt Service3,984 - - - - - 3,984 - Capital Project Funds23 - City-Wide Capital278,633 77,516 694,989 - - - 1,051,137 53,517 25 - Police Capital65,667 - - - - - 65,667 - 25 - General Gov Capital2,499 - - - - - 2,499 - 25 - Public Works Capital90,172 - - - - - 90,172 - Enterprise Funds51 - Water642,751 412,761 1,449,739 - - - 2,505,251 7,114 52 - Sewer374,119 140,305 529,251 - - - 1,043,675 33,437 Agency Funds90 - Developer Escrow 173,093 - - - - - 173,093 - 95 - Escrow Deposit317,775 344,190 - - - - 661,965 - Total City Funds1,450,820$ 1,101,052$ 6,064,600$ 100,952$ 2,052,453$ -$ 10,769,878$ 136,532$ Distribution %13.47% 10.22% 56.31%0.94% 19.06%Library Funds82 - Library Operations54$ -$ -$ -$ 236,531$ 401,042$ 637,626$ 4,126$ 84 - Library Capital4,750 - - - - 128,777 133,527 - Library Totals 4,804$ -$ -$ -$ 236,531$ 529,819$ 771,154$ 4,126$ Distribution %0.62%30.67% 68.70%Park and Recreation Funds79 - Parks and Recreation 634,613$ -$ -$ -$ -$ -$ 634,613$ -$ 25 - Park & Rec Capital443,296 - - - - - 443,296 1,221 Park & Rec Totals 1,077,909$ -$ -$ -$ -$ -$ 1,077,909$ 1,221$ Distribution % 100.00%UNITED CITY OF YORKVILLECASH AND INVESTMENT SUMMARY - as of April 30, 2020Cash Summary 1 FinancialAccrued Type of Investment Institution FDIC # Interest Rate Original Cost Maturity Date Interest to Date Value at Maturity FundCertificate of Deposit (CD) Sonabank 57968 2.49% 243,800$ 6/17/2020 5,270$ 249,868$ General (01)Certificate of Deposit (CD)Western Alliance Bank57512 1.62% 246,000 2/25/2021 699 249,917 General (01)489,800$ 5,969$ 499,785$ UNITED CITY OF YORKVILLECASH AND INVESTMENT SUMMARY - as of April 30, 2020Investments Summary Investment Totals2 Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #4 Tracking Number ADM 2020-43 Website Report for May 2020 Administration Committee – June 17, 2020 Informational None. See attached memo. Erin Willrett Administration Name Department 0 5,000 10,000 15,000 20,000 25,000 30,000 Total Visits Total Visits Summary Yorkville’s website and social media analytics report for May 2020. Background Every month at the Administration Committee meeting, the website data from the previous month will be highlighted. This month’s highlight is May 1, 2020 – May 31, 2020. Website Visits: May 2019 June 2019 July 2019 Aug 2019 Sept 2019 Oct 2019 Nov 2019 Dec 2019 Jan 2020 Feb 2020 March 2020 April 2020 May 2020 Unique Visitors 13,163 17,246 21,699 20,358 13,262 14,179 11,539 8,911 10,678 10,151 14,408 12,529 12,747 Returning Visits 6,377 8,412 10,546 9,629 6,405 7,084 5,659 3,593 4,785 4,458 5,233 4,841 4,832 Total Visits 17,219 22,768 20,020 27,106 17,156 18,975 15,297 11,244 14,041 13,192 18,067 15,953 16,173 Visit Times (Averages):  2 minutes 35 second average visit duration  2.7 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: June 17, 2020 Subject: Website Report for May 2020 Website Statistics: March 2020 April 2020 May 2020i Top 5 Pages Visited 1. Homepage 2. Online Utility Payments 3. My Gov Hub Transition Page 4. Parks and Recreation Homepage 5. St. Patrick’s Day Event Page 1. Homepage 2. Online Utility Payments 3. My Gov Hub Transition Page 4. COVID-19 Update 5. Pick-Up Service Schedules 1. Homepage 2. COVID-19 Update 3. Online Utility Payments 4. Facilities Overview 5. My Gov Hub Transition Page March 2020 April 2020 May 2020ii Top 5 Downloads 1. Mayor’s COVID-19 March 17th Letter 2. Annual Drinking Water Quality Report 3. Residential Permit Application 4. 2018 ICC Building Code Update 5. Fence Permit 1. Residential Permit Application 2. Annual Drinking Water Quality Report 3. Concrete and Paver Patio Information 4. Fence Permit 5. Shed and Accessory Structures 1. Residential Permit Application 2. Pool Permit Information 3. Concrete and Paver Patio Information 4. Annual Drinking Quality Report 5. Park and Playground Information March 2020 April 2020 May 2020 Top 5 Searches 1. True 2. Jobs (Employment was 3rd) 3. Novel Coronavirus 4. Garbage 5. Chickens 1. True 2. Meters 3. Chickens 4. Garbage 5. Request for Meter Reading 1. True 2. Pool 3. Meter 4. Request for Meter Reading 5. Permit March 2020 April 2020 May 2020 Top 5 Website Referrers 1. Facebook 2. patch.com 3. weareyorkville.org 4. r.search.aol.com 5.kendallcountynow.com 1. Facebook 2. newsbreakapp.com 3. weareyorkville.org 4. patch.com 5. r.search.aol.com 1. Facebook 2. r.search.aol.com 3. Patch.com 4. dnserrorassist.att.net 5. q985online.com City Facebook Data: May 2020 Total Page Followers: 5,899 (an increase of 173 followers from April) Total Page Likes: 5,730 Total Average Reach: 3,385 Highest Viewed Post: “The City of Yorkville has worked to accommodate outdoor dining options for all restaurants…” (Posted May 28, 2020 at 5:23 pm) Highest Viewed Post Reach: 30,167; 3,277 Post Clicks; 1,203 Reactions, Comments & Shares Parks and Recreation Facebook Data: May 2020 Total Page Followers: 3,285 (an increase of 38 followers from April) Total Page Likes: 3,217 Total Average Reach: 2,013 Highest Viewed Post: “LEARN A NEW SKILL WHILE AT HOME!” (Posted May 14, 2020, 10:00 am) Highest Viewed Post Reach: 2,929; 36 Post Clicks; 15 Reactions, Comments & Shares Police Facebook Data: May 2020 Total Page Followers: 2,499 (an increase 150 of followers from April) Total Page Likes: 2,381 Total Average Reach: 2,307 Highest Viewed Post: “Update: ARREST made regarding May 4th shooting and April 2nd robbery:” (Posted May 15, 2020, 7:45 pm) Highest Viewed Post Reach: 18,952; 3,458 Post Clicks; 370 Reactions, Comments & Shares City Twitter Data: May 2020 Total Followers: 1,653 (7 new followers from April) Total Tweet Impressions: 5,923 Total Profile Visits: 128 Yorkville Twitter Mentions: 4 Top Tweet (earned 451 Impressions): “Advanced Disposal will resume bulk item collection beginning with collections on Monday, May 11th…” Recommendation: This is an informational item. ihttps://www.yorkville.il.us/; https://www.yorkville.il.us/745/COVID-19-Update; https://www.yorkville.il.us/131/Online-Utility-Payments; https://www.yorkville.il.us/facilities/featureoverview; https://www.yorkville.il.us/573/MyGovHub-Transition-Page ii https://www.yorkville.il.us/DocumentCenter/View/5804/Residential-Permit-Application-PDF; https://www.yorkville.il.us/DocumentCenter/View/6652/Pool-2018?bidId=; https://www.yorkville.il.us/DocumentCenter/View/6655/Concrete-Patio-and-Brick-Pavers-2018?bidId=; https://www.yorkville.il.us/DocumentCenter/View/6094/2018-Annual-Drinking-Water-Quality-Report- PDF?bidId=; https://www.yorkville.il.us/DocumentCenter/View/124/Parks-Map-and-Matrix-PDF?bidId= Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number New Business #5 Tracking Number ADM 2020-44 Required Reporting to Municipality by Yorkville Police Pension Board Administration Committee – June 17, 2020 See attached memo. Rob Fredrickson Finance Name Department Please see the attached “Required Reporting to Municipality by the Yorkville Police Pension Board”. Information for this “required report” is derived from the Actuarial Valuations for the Fiscal Year Ended 2019 as prepared by the City’s actuary, MWM Consulting Group (Column 1 – please see Exhibit A for full report) and by the Illinois Department of Insurance (IDOI) Public Pension Division (Column 2 – please Exhibit B for full report). There are three primary differences between the two valuations including: the actuarial funding methods used; the investment rate of return; and the funding target. The City’s actuary uses the Entry Age Normal Funding Method, as required by the Governmental Accounting Standards Board (GASB). The State uses the Projected Unit Credit funding method. For investment rate of return, the City uses a rate of 7%, which is based on the historical rates of return for the Yorkville Police Pension Fund. The State uses an investment return rate of 6.50%, which is based on assumed expectations for all Police Pension Funds (i.e. Article 3 Pension Funds) throughout Illinois, excluding Chicago. Pursuant to the Funding Policy, the City’s funding target is 100%, in comparison with the State’s target of 90% funding by the year 2040. The attached “required report” summarizes various financial, investment and annuitant information associated with the Yorkville Police Pension Fund. Highlights from the report are discussed below and will focus on the City’s actuarial valuation numbers (1st column) unless specified otherwise.  Section 1 shows total fund assets, valued at $10,501,652 – which is a 11.94% increase over the previous year.  Section 2 identifies estimated receipts (revenues) from employee and employer (i.e. City) contributions for FY 2021, for a total of $1,469,088.  Section 3(b) is important from the City’s perspective because it tells us the recommended funding requirement for the Pension Fund, currently calculated at $1,226,371. This amount, along with an additional $4,233 to cover the full interest cost of the unfunded liability, was the exact amount ($1,230,604) levied for the Police Pension Fund during the 2019 tax levy process. This represents an increase of $119,120 (10.7%) in comparison to the actuarial determined contribution amount for 2018 of $1,111,484. The reasons for this increase are as follows: o As we get closer to the year 2040, there is less time to spread out the remaining costs associated with the unfunded liability (i.e. the amortization period is shrinking each year). o Normal cost continues to increase, as each year of additional service by current employees generates additional pension benefits. o The actual Changes in actuarial assumptions pertaining to mortality; and retirement and termination rates based on the most recent experience study conducted by the Illinois Department of Insurance. Memorandum To: Administration Committee From: Rob Fredrickson, Finance Director Date: June 10, 2020 Subject: Required Reporting to Municipality by Yorkville Pension Board This will be the eighth year in a row that the City has either met or exceeded the actuarial funding recommendation.  Section 4 identifies income received from the investment of Fund assets, as well as the projected and actual rates of return for the Pension Fund’s investments for the current and preceding fiscal year. Sections 5 and 6 summarize the number of active employees and the amounts paid to annuitants (pensioners).  Section 7 shows the funding ratio of the Fund (47.1%), which is calculated by dividing total assets of $10.4M by the total accrued liability of $22.1M. Section 8 shows the unfunded accrued liability amount (difference between total assets and the accrued liability) of $11,600,871, which is an increase of 9.7% over the previous year’s amount of $10,574,654.  Section 9 has to do with the statutory limits imposed on the Fund regarding the percentage of total assets invested in equities. As you may recall, in September 2018 the Pension Fund exceeded $10 million in total assets, which allowed the Fund to increase the percentage of assets invested in equities to 65% of the total portfolio (45% was the previous statutory limit for Funds under $10 million). As shown on page 7 of the MWM Actuarial Valuation, the Funds assets were allocated as follows: 64% equities (includes mutual funds); 34% fixed income (i.e. bonds); and 2% cash. As mentioned above, the funding ratio increased by 3.3% at FYE 2019, from 45.6% to 47.1%. Fund assets increased by ~12% as a direct result of increased contributions and positive investment returns. The investment return for FY 19 was 8.02% (money-weighted rate of return was 7.56%), which exceeded the assumed rate of return (7.0%) and last year’s actual return of 5.46%. The equity side of the portfolio did quite well in FY 2019; as the result of more assets being allocated to the equity side of the portfolio and positive market timing, yielded a money weighted rate of return (MWRR) of 11.4% (net). After yielding a net MWRR of negative 1.2% in FY 18, the fixed income side yielded a positive 3.6% in FY 19 due to gradual increases in the interest rate environment. In general, looking ahead to future fiscal periods, if the long-term actual rate of return exceeds the assumed rate; and actual salary increases are less than assumed; and the City continues to fully fund the plan based on the actuarial recommendation; the percent funded should continue to increase, with the ultimate goal of fully funding the Police Pension Fund by 2040. The rate of return and salary increase assumptions will be reviewed annually by staff and revised accordingly (with City Council approval) should they prove to not be reflective of the Pension Fund’s actual long-term performance. However, staff does expect the City’s contribution amount to increase in the short run until the State extends the amortization period beyond 2040. Nonetheless, the City may be able to mitigate these increases by reducing the funding target, which is currently at 100%. The FYE 20 actuarial valuation will be completed later on this fall, once the audit is finalized, and will be presented to City Council as part of the 2020 tax levy discussion. The “Required Report to the Municipality by the Yorkville Pension Board” is an informational item and requires no formal action by the City Council. This report will also be presented to the Yorkville Police Pension Board at their upcoming meeting on June 23, 2020. (40 ILCS 5/3-143) (from chapter 108 1/2, paragraph 3143) Section 3143. Report by pension board. City's IDOI Actuarial Actuarial Valuation Valuation (1)Total Assets (actuarial value): $ 10,501,652 $ 10,450,231 Total Assets (market value): 10,403,718$ 10,403,718$ (2) Estimated Receipts during the next succeeding fiscal year from: Participant Contributions deducted from payroll 242,717$ 242,717$ City Contribution 1,226,371$ 1,090,320$ (3) Estimated amount required during the next succeeding fiscal year to: (a) pay all pensions and other obligations provided in this Article 746,128$ 746,128$ (b) meet the annual requirements of the fund as provided in Sections 3-125- and 3-127; Funding Requirement 1,226,371$ 1,090,320$ (4) Total Net Income received from investment of net assets: 751,520$ 717,071$ Assumed Investment Return: 7.00% 6.50% Actual Investment Return:8.02% - Total Net Income received from investment of net assets (FYE 4/30/2018): 453,379$ 409,710$ Assumed Investment Return (FYE 4/30/2018): 7.00% 6.25% Actual Investment Return (FYE 4/30/2018):5.46% - (5) Total number of active employees that are financially contributing to the fund 28 28 Required Reporting to Municipality by Yorkville Police Pension Board As of April 30, 2020 The pension board shall report annually to the city council or board of trustees of the municipality on the condition of the pension fund at the end of its most recently completed fiscal year. The report shall be made prior to the council or board meeting held for the levying of taxes for the year for which the report is made. (6) Disbursements to: (i) Annuitants in receipt of a regular retirement pension 10 10 Total number of annuitants: 10 10 Total amount that was disbursed in benefits: 597,064$ - (ii) Recipients being paid a disability pension - - Total number of annuitants: - - Total amount that was disbursed in benefits: -$ -$ (iii) Survivors and children in receipt of benefits - - Total number of annuitants: - - Total amount that was disbursed in benefits: -$ -$ (7) Funded ratio of the fund 47.07% 47.00% (8) Unfunded Liability 11,600,871$ 11,704,907$ (9) Investment Policy of the pension board under the statutory investment restrictions imposed on the fund. Certification Witness my hand this 23rd day of June 2020. Greg Sibenaller, President Yorkville Police Pension Board I, Greg Sibenaller, President of the Police Pension Board, United City of Yorkville, Kendall County, Illinois, do hereby certify that this document is a true and correct copy of: “Required Reporting to Municipality By Pension Board” as outlined in 40 ILCS 5/3-143. Actuarial Valuation City of Yorkville Yorkville Police Pension Fund As of May 1, 2019 For the Year Ending April 30, 2020 VALUATION SUMMARY Contributions..........................................................................................................................................1 Statutory Minimum Funding Cost Elements...........................................................................................1 Funding Policy Actuarially Determined Contribution Cost Elements.....................................................2 Contriubtion to Avoid Negative Funding................................................................................................2 Financial Thumbnail Ratios.....................................................................................................................2 Plan Maturity Measures.........................................................................................................................3 Participant Data Summary......................................................................................................................3 VALUATION RESULTS Significant Events, Risk Disclosures and Issues Influencing Valuation Results.......................................4 Actuarial Certification.............................................................................................................................6 FINANCIAL AND ACTUARIAL EXHIBITS Exhibit 1 - Statement of Market Assets Available for Benefits..............................................................7 Exhibit 2 - Statement of Changes in Net Assets Available for Benefits..................................................8 Exhibit 3 - Determination of the Actuarial Value of Assets....................................................................9 Exhibit 4 - Determination of Statutory Minimum Required Annual Contribution.................................10 Exhibit 5 - Determination of Funding Policy Annual Contribution.........................................................11 Exhibit 6 - Determination of Contribution Required to Prevent Negative Funding...............................11 Exhibit 7 - Summary of Participant Data as of May 1, 2019...................................................................12 SUMMARY OF PRINCIPAL PLAN PROVISIONS Definitions...............................................................................................................................................13 Pension (3-111).......................................................................................................................................13 Pension to Survivors (3-112)...................................................................................................................14 Disability Pension Line of Duty (3-114.1)................................................................................................14 Disability Pension Not on Duty (3-114.2)...............................................................................................15 Other Provisions......................................................................................................................................15 Glossary of Terms...................................................................................................................................16 SUMMARY OF ACTUARIAL ASSUMPTIONS AND COST METHOD Nature of Actuarial Calculations.............................................................................................................18 Assumptions............................................................................................................................................18 Asset Valuation Methods........................................................................................................................19 Actuarial Cost Methods..........................................................................................................................19 Table of Contents SECTION 1SECTION 2SECTION 3SECTION 4SECTION 5 CONTRIBUTIONS Current Prior Year Valuation Valuation as of 5/1/2019 as of 5/1/2018 Contribution Required To Prevent Negative Funding $1,230,604 (50.2%)N/A Actuarially Determined Funding Policy Contribution $1,226,371 (50.1%)$1,111,484 (43.7%) Statutory Minimum Contribution per 40 ILCS 5/3 Section 125 $1,035,331 (42.3%)$987,657 (38.8%) Current Prior Year Item Valuation Valuation as of 5/1/2019 as of 5/1/2018 Accrued Liability $ 21,273,616 $ 18,895,425 Market Value of Assets $ 10,403,718 $ 9,089,345 Actuarial (Smoothed) Value of Assets $ 10,501,652 $ 9,381,882 Normal Cost (employer) $ 389,134 $ 425,946 Amortization Amount $ 562,586 $ 480,609 Statutory Minimum Contribution $ 1,035,331 $ 987,657 Illinois statues require employers to contribute at least the amount necessary such that assets will equal at least 90% of the accrued liability by 2040. The minimum amount is determined under the Projected Unit Credit funding method, with smoothed assets, and is equal to the normal cost plus the amortization amount. Section 1: Summary of Principal Valuation Results STATUTORY MINIMUM FUNDING COST ELEMENTS () amounts expressed as a percentage of payroll The plan sponsor must contribute at least the statutorily required minimum contribution under Illinois statutes equal to the normal cost plus the amount necessary to amortize the unfunded accrued liability such that by 2040, the liabilities will be 90% funded. Other contribution amounts are shown including Funding Policy Contribution and the contribution required to prevent negative funding. Item MWM Consulting Group was retained to prepare an actuarial valuation as of May 1, 2019 for the Yorkville Police Pension Fund.The purpose of the actuarial valuation was to determine the financial position and the annual actuarial requirements of the pension fund under Illinois statute 40 ILCS 5/3, Section 125,and to develop a recommended minimum contribution amount. For quick reference, some of the key results of the valuation, along with selected financial and demographic information for the year ending April 30, 2020 are summarized in this overview section along with (for comparison) the results from the prior year. Page 1 Accrued Liability Market Value of Assets Actuarial (Smoothed) Value of Assets Normal Cost (employer) Amortization Amount Actuarially Determined Funding Policy Contribution Accrued Liability Market Value of Assets Actuarial (Smoothed) Value of Assets Normal Cost (employer) Amortization Amount Amount of Contribution Needed to Avoid Negative Funding FINANCIAL THUMBNAIL RATIOS Tests Liquidity Ratio (based upon year ended) Coverage Ratio (Market Value Assets) Annual Benefit Payments (expected) Annual Contributions (expected) Members City as of 5/1/2019 as of 5/1/2018 This chart summarizes traditional financial ratios as applied to the pension plan. This liquidity ratio relates the cash flow position of the Fund by comparing the investment income plus employer and employee contributions to the annual benefit payments. Maintaining a ratio well above 100% prevents the liquidation of assets to cover benefit payments. The increase in benefits paid over the years is generally a result of the maturing of the pension plan. Coverage of the Accrued Liabilities by the Assets is the Coverage Ratio and is one indication of the long term funding progress of the plan. $ 242,717 $ 252,038 $ 1,226,371 $ 1,111,484 5/1/2019 Valuation 5/1/2018 Valuation 304%306% 47.07% $ 22,102,523 The statutory minimum contribution amortization amount is based upon a percentage of increasing payroll and, in the early years of funding, may not be sufficient to cover the interest cost on the unfunded liability. In order to avoid an increase in the unfunded liability (known as negative funding) , the minimum amortization amount must be adjusted to be at least equal to the interest on the unfunded liability. The amount shown in the table as “Contribution to Avoid Negative Funding” provides for interest on 100% of the unfunded liability. $ 10,403,718 $ 10,501,652 $ 375,283 $ 812,061 AMOUNT REQUIRED TO AVOID NEGATIVE FUNDING Item Current Prior Year Valuation Valuation $ 1,230,604 45.55% $ 746,128 $ 564,511 $ 9,381,882 $ 355,667 $ 666,615 $ 1,111,484 Prior Year Valuation as of 5/1/2018 $ 19,956,536 $ 9,089,345 $ 10,501,652 $ 375,283 $ 754,979 $ 1,226,371 FUNDING POLICY CONTRIBUTION COST ELEMENTS Item The funding policy contribution amount is determined under the Entry Age Normal funding method, with smoothed assets, and is equal to the normal cost plus the amortization amount. 100% of the unfunded liability is amortized as a level percentage of pay on a closed basis over 21 years Current Valuation as of 5/1/2019 $ 22,102,523 $ 10,403,718 Page 2 PLAN MATURITY MEASURES Tests Ratio of Market Value of Assets to Active Participant Payroll is a measure of volatility risk associated with asset losses Ratio of Accrued Liability to Payroll is a measure of volatility risk associated with changes in assumptions Ratio of retired life Actuarial Accrued Liability to total Actuarial Accrued Liability Percentage of Contributions less Benefit Payments to Market Value of Assets Ratio of Benefit Payments to Contributions Support Ratio: Ratio of Active Participants to Retired Participants Tier 1 Tier 2 Total Tier 1 Tier 2 Total Active Members Vested 16 0 16 20 0 20 Non-Vested 0 12 12 1 9 10 Total Active 16 12 28 21 9 30 Terminated entitled to future benefits 3 3 6 2 2 4 Retired 10 0 10 7 0 7 Surviving Spouse 0 0 0 0 0 0 Minor Dependent 0 0 0 0 0 0 Disabled 0 0 0 0 0 0 Total 29 15 44 30 11 41 as of 5/1/2018as of 5/1/2019 Item This chart includes financial relationship measures which are meant to help understand the risks associated with the plan. The ratio of Market Value of Assets to Active Payroll is measure of volatility risk associated with asset losses. The higher the ratio, the greater the volatility in contribution risks. The Ratio of Accrued Liability to Payroll is a measure of the volatility risk associated with assumption or other changes in liabilities. The higher the ratio, the greater the volatility in contribution risks. The Ratio of retired life actuarial accrued liability to total actuarial accrued liability is a measure of the maturity of the Plan. A mature plan will have a ratio above 60%. The Support Ratio (Actives: Retirees). A number less than 1 indicates a more mature plan. PARTICIPANT DATA SUMMARY The Actuarial Valuation takes into account demographic and benefit information for active employees, vested former employees, and retired pensioners and beneficiaries. The statistics for the past two years are compared in the chart. Prior Year Valuation Valuation 6.71%8.97% 0.49 0.41 1.75 2.73 Current Year 0.54 0.41 5/1/2019 Valuation 5/1/2018 Valuation 4.25 1.31 9.02 2.73 Page 3 • The funded ratio measurement is dependent upon the actuarial cost method which, in combination with the plan’s amortization policy, affects the timing and amounts of future contributions. The amounts of future contributions will most certainly differ from those assumed in this report due to future actual experience differing from assumed experience based upon the actuarial assumptions. Attainment of a funded status measurement in the Actuarial Valuation of 90% or 100% is not synonymous with no required future annual contributions. Even if the funded status attained is 100%, the plan would still require future normal cost contributions (i.e., contributions to cover the annual cost of the active membership accruing an additional year of service credit). The mortality table was updated to RP2014 Healthy Annuitant with Blue Collar Adjustments projected generationally from 2013 with scale MP2018. The retirement and termination rates were updated to reflect the most recent experience studies by the Illinois Department of Insurance. SECTION 2: VALUATION RESULTS Significant Events, Disclosure Risks and Issues Influencing Valuation Results Actuarial valuations are snapshot calculations which incorporate and reflect the experience and events of the past year such as changes in the demographics of the plan participants, gains and losses in the plan assets, changes in actuarial assumptions about future experience and outside influences such as legislation. Some of the more significant issues affecting the Plan’s contribution level are described here. Asset Performance for yearend 4/30/2019 The approximate 8.02% return (not time weighted)on net assets was above the actuarial assumption of 7.00% in effect for the 2018/2019 year. Change in Assumptions Funded Status The funded ratio measurement presented in the Actuarial Valuation Report for the Fund is the ratio of the actuarial value of fund assets available for benefits compared to the actuarial accrued liability.By monitoring changes in the funding ratio each year, one can determine whether or not funding progress is being made. Please understand that: 7.06%5.46%8.02% -5.00% 15.00% 2016 2017 2018 2019 Historical Rates of Return Rate of Return on Assets Assumed Rate of Return Page 4 • The funded ratio measurement is a different result depending upon whether the market value of assets or the actuarial value of assets is used. Negative Funding The current Funding Policy amortizes the unfunded amount based upon a level percentage of payroll. This amortization method develops dollar amounts which increase as payroll increases. The dollar amounts under this amortization method in the early years are less than the interest on the unfunded liability. For 2019,the interest on the unfunded is $812,061, whereas the funding policy amortization is $754,979. (See exhibits 5 and 6 on page 11). The dollar amounts towards the end of the closed amortization period are necessarily much larger, and if payroll does not increase as expected, the amortization amount can dramatically increase the contribution as a percentage of payroll. Since the Funding Policy percentage of payroll amortization is slightly less than the negative funding amount,at this point, the dollar value of the interest on the unfunded liability is not completely covered, and adds to the unfunded liability. Assuming the Funding Policy Contributions are received (and the actuarial assumptions are met) each year through 2040,the Fund’s funded ratio is projected to increase to 100%by 2040.If only the Minimum Statutory contributions are made, the Fund’s funded ratio would be projected to increase to 90%by 2040 and would require steeper contributions in years closer to 2040. The ability of the fund to reach 100%is heavily dependent on the City contributing the Funding Policy Employer Contribution each and every year. Actuarial standards do not require the actuary to evaluate the ability of the City or other contributing entity to make such required contributions to the Fund when due. Such an evaluation is not within the actuary’s domain of expertise. Consequently, the actuary performed no such evaluation. The articulated Funding Policy amortizes 100%the unfunded amount based upon a level percentage of pay. The statutory funding required amortization method develops dollar amounts which also increase as payroll increases. The dollar amounts towards the end of the closed amortization period are necessarily much larger, and if payroll does not increase as expected, the amortization amount can dramatically increase the contribution as a percentage of payroll. The employer contribution is expected to be paid according to the funding policy, which exceeds the required statutory minimum amount. An additional funding contribution amount is included which determines the amount necessary to prevent negative funding. Employer Contributions 0.00% 25.00% 50.00% 75.00% 100.00% 2015 2016 2017 2018 2019 Funded Percentages Funded Ratios - Market Assets Funded Ratios - Smoothed Assets Page 5 ACTUARIAL CERTIFICATION MWM CONSULTING GROUP Kathleen E Manning, FSA Daniel W. Colby, FSA Date Managing Principal & Consulting Actuary Consulting Actuary MWM Consulting Group MWM Consulting Group The results shown in this report have been calculated under the supervisions of a qualified Actuary as defined in appropriate State statutes. All results are based upon demographic data submitted by the Fund / City, financial data submitted by the Fund, applications of actuarial assumptions, and generally accepted actuarial methods. This valuation report has been prepared at the request of City of Yorkville to assist in administering the Plan and meeting specified financial and accounting requirements. This valuation report may not otherwise be copied or reproduced in any form without the consent of the Fund sponsor and may only be provided to other parties in its entirety. The information and valuation results shown in this report are prepared with reliance upon information and data provided to us, which we believe to the best of our knowledge to be complete and accurate and include: • Employee census data submitted by the City of Yorkville. This data was not audited by us but appears to be consistent with prior information, and sufficient and reliable for purposes of this report. We believe the assumptions and methods used are within the range of possible assumptions that are reasonable and appropriate for the purposes for which they have been used.In our opinion, all methods, assumptions and calculations are in accordance with requirements and the procedures followed and presentation of results are in conformity with generally accepted actuarial principles and practices. The undersigned actuary meets the Qualification Standards of the American Academy of Actuaries to render the actuarial opinions contained herein. There is no relationship between the City of Yorkville and MWM Consulting Group that impacts our objectivity. I certify that the results presented in this report are accurate and correct to the best of my knowledge. This is to certify that MWM Consulting Group has prepared an Actuarial Valuation of the Plan as of May 1, 2019 for the purposes of determining statutory contribution requirements for the Fund in accordance with the requirements of 40 ILCS 5/3, Section 125,of determining the funding policy contribution amount (the Actuarially Determined Contribution). The funding policy is selected by the City. The contributions determined are net of contributions made by active member police officers during the year. The measurements shown in this actuarial valuation may not be applicable for other purposes. Actuarial valuations involve calculations that require assumptions about future events. Certain of the assumptions or methods are mandated for specific purposes. Future actuarial measurements may differ significantly from the current measurements presented in the report due to such factors as experience that deviates from the assumptions, changes in assumptions, increases or decreases expected as part of the natural operation of the methodology used for these measurements (such as the end of an amortization period,or additional cost or contributions based on the Plan’s funded status)and changes in plan provisions or applicable law. This report does not include an analysis of the potential range of such future measurements. • Financial data submitted by the City of Yorkville. Page 6 9/27/2019 Exhibit 1 - Statement of Market Value of Assets 4/30/2019 4/30/2018 1. Investments at Fair Value: a. Cash and Cash equivalents $ 0 $ 0 b. Money Market Mutual Funds 218,695 888,971 c. Municipal Bonds 488,526 536,093 d. Certificates of Deposit 0 0 e. US Government and Agency Bonds 3,020,656 3,647,358 f. Common and Preferred Stocks 3,251,008 2,875,120 g. Insurance Contracts (at contract value): 0 0 h. Mutual Funds 3,402,045 1,109,957 i. Accrued Interest and receivables 25,362 33,802 j. Other 0 0 k. Subtotal Assets (a + b + c +d + e + f + g+ h+ i +j) $ 10,406,292 $ 9,091,301 2. Liabilities: a. Expenses Payable $ 2,574 $ 1,956 b. Liability for benefits due and unpaid 0 0 c. Other Liabilities 0 0 d. Total Liabilities $ 2,574 $ 1,956 3. Net Market Value of Assets Available for Benefits: (1k – 2d) $ 10,403,718 $ 9,089,345 Item Plan Year Ending SECTION 3 - FINANCIAL AND ACTUARIAL EXHIBITS Page 7 4/30/2019 4/30/2018 Additions Contributions Employer $ 963,361 $ 966,211 Plan Member 243,941 249,421 Other (adjustment to beginning of year market value) (243) 0 Total Contributions $ 1,207,059 $ 1,215,632 Investment Income Realized and Unrealized Gains/(Losses) $ 523,223 $ 1,545 Interest 100,715 423,271 Dividends 79,268 28,563 Other Income 48,314 0 Investment Expenses 0 0 Net Investment Income 751,520 453,379 Total additions $ 1,958,579 $ 1,669,011 Deductions Benefits $ 597,064 $ 501,417 Refunds 0 0 Administrative and Investment Expenses 47,142 43,426 Total deductions $ 644,206 $ 544,843 Total increase (decrease) $ 1,314,373 $ 1,124,168 Net Market Value of Assets Available for Benefits: Beginning of year $ 9,089,345 $ 7,965,177 End of year $ 10,403,718 $ 9,089,345 Item Plan Year Ending Exhibit 2 - Statement of Change in Net Assets Page 8 1. Expected Return on Assets a. Market Value of Assets as of Beginning of Year 9,089,345$ b. Income and Disbursements During the year i. Contributions Received (weighted 50%)603,530$ ii. Benefit Payments and Expenses (weighted 50%)322,103 iii. Weighted net income (other than investment income) (i) – (ii)281,427 c. Market Value adjusted for income and disbursements 9,370,772$ d. Expected Return on Assets at assumed rate of 7.00%655,954$ 2. Actual Return on Assets for year a. Market Value of Assets (Beginning of Year)9,089,345$ b. Income (less investment income)1,207,059 c. Disbursements 644,206 d. Market Value of Assets (End of Year)10,403,718 e. Actual Return on Assets (d) – (a) – (b) + (c)751,520 f. Investment Gain/(Loss) for year 2(e) - 1(d) 95,566$ 3. Actuarial Value of Assets a. Market Value of Assets as of End of Year 10,403,718$ b. Deferred Investment gains/(losses) i. 80% of 2019 gain of $95,566 (76,453) ii. 60% of 2018 loss of $(127,661)76,597 iii. 40% of 2017 gain of $4,122 (1,649) iv. 20% of 2016 loss of $(497,196)99,439 v. Total 97,934 c. Actuarial Value of Assets for statutory funding 3(a) + 3(b)(iv)10,501,652$ The Chart Below shows the comparison of smoothed to market asseets over the past five years Under 40 ILCS 5/3,the statutory minimum required contribution is to be determined based upon Actuarial Value of Assets, which are asset values which have been smoothed over a five-year period, beginning with the year 2011.The Actuarial Value of Assets has been calculated below based upon the market value of assets at May 1, 2019 with adjustments for the preceding year’s gains/losses, which are reflected at the rate of 20%per year. Exhibit 3 – Actuarial Value of Assets $- $5,000,000 $10,000,000 $15,000,000 2015 2016 2017 2018 2019 Smoothed vs Market Assets Market Value of Assets Actuarial (Smoothed) Value of Assets Page 9 Present Value of Benefits as of 5/1/2019 Projected Unit Credit (PUC) Normal Cost as of 5/1/2019 PUC Actuarial Accrued Liability as of 5/1/2019 1. Active Officers a) Normal & Early Retirement 14,331,650$ 493,641$ 7,796,888$ b) Vested Withdrawal 991,932 53,051 643,355 c) Pre-Retirement Death 311,764 13,925 184,328 d) Disability 1,422,190 71,234 796,398 e) Total Active Police Officers 17,057,536$ 631,851$ 9,420,969$ 2. Inactive Police Officers and Survivors: a) Normal Retirees 11,697,204$ 11,697,204$ b) Widows (survivors)0 0 c) Deferred Vested 155,443 155,443 d) Disabled 0 0 e) Total - Nonactive 11,852,647$ 11,852,647$ 3. Total – All 28,910,183$ 21,273,616$ Amount 2,449,210$ 389,134 242,717 21,273,616 19,146,254 10,501,652 8,644,602 562,586 83,611 $1,035,331 (42.3%) *() amount as a percent of payroll Exhibit 4- Determination of the Statutory Minimum Required Contribution 6. Actuarial Value of Assets (Exhibit 3) 7. Unfunded Actuarial Balance 8. Amortization of Unfunded Balance over 21 years as a level percentage of payroll 9. Interest on (2), (3) and (8) 10. Minimum statutory tax levy contribution per 40 ILCS 5/3 – (2) + (8) + (9) Under 40 ILCS 5/3,the statutory minimum required contribution is to be determined based upon the Projected Unit Credit actuarial funding method, where the unfunded liability is amortized such that 90%of the liability will be funded as of 2040.Under the statute,90%of the unfunded liability is to be amortized as a level percentage of payroll over the period through 2040.The mandated funding method, the Projected Unit Credit funding method, requires the annual cost of the plan to be developed in two parts: that attributable to benefits allocated to the current year (the normal cost); and that allocated to benefits attributable to prior service (the accrued liability). Funding Elements for 40 ILCS 5/3 Minimum Statutory Contribution under 40 ILCS 5/3 Item 1. Annual Payroll 2. Normal Cost (net of employee/member contributions) 3. Employee Contributions (expected) 4. Funding Actuarial Liability 5. 90% of Funding Actuarial Liability Page 10 Present Value of Benefits as of 5/1/2019 Entry Age Normal Cost as of 5/1/2019 Entry Age Accrued Liability as of 5/1/2019 1. Active Officers a) Normal & Early Retirement 14,331,650$ 468,210$ 9,203,297$ b) Vested Withdrawal 991,932 63,030 286,931 c) Pre-Retirement Death 311,764 13,796 159,596 d) Disability 1,422,190 72,964 600,052 e) Total Active Police Officers 17,057,536$ 618,000$ 10,249,876$ 2. Inactive Police Officers and Survivors: a) Normal Retirees 11,697,204$ 11,697,204$ b) Widows (survivors)0 0 c) Deferred Vested 155,443 155,443 d) Disabled 0 0 e) Total - Nonactive 11,852,647$ 11,852,647$ 3. Total – All 28,910,183$ 22,102,523$ Amount 375,283$ 242,717 22,102,523 22,102,523 10,501,652 11,600,871 754,979 96,109 $1,226,371 (50.1%) Amount 375,283$ 242,717 22,102,523 10,501,652 11,600,871 812,061 43,260 $1,230,604 (50.2%) 4. Actuarial Value of Assets (Exhibit 3) 5. Unfunded Actuarial Balance 6. Interest on Unfunded Liability 7. Interest on (1), (2) 8. Contribution Necessary to Prevent Negative Funding (1) + (6) + (7) Exhibit 6- Contribution Necessary to Prevent Negative Funding Item 1. Normal Cost (net of employee/member contributions) 2. Employee Contributions (expected) 3. 100% of Funding Actuarial Liability 6. Unfunded Actuarial Balance 7. Amortization of Unfunded Balance over 21 years as a level percentage of payroll 8. Interest on (1), (2) and (7) 9. Actuarially Determined Funding Policy Contribution for Tax Levy (1) + (7) + (8) 2. Employee Contributions (expected) 3. Funding Actuarial Liability 4. 100% of Funding Actuarial Liability 5. Actuarial Value of Assets (Exhibit 3) Exhibit 5- Determination of the Funding Policy Contribution Funding Elements for Funding Policy Contribution The Tax Levy amount based upon the articulated funding policy is the actuarially determined contribution, rather than the amount determined as the minimum under 40 ILCS 5/3.The funding policy contribution is developed below, based upon the Entry Age Normal Funding Method, with 100%of the unfunded accrued liability amortized as a level percentage of payroll over the 21 years through FYE 2040.The contribution is then the sum of the Normal Cost (developed under the entry age method,but where the total normal cost is not less than 17.5%) plus the amortization payment. Also shown is the contribution amount necessary to prevent negative funding. 1. Normal Cost (net of employee/member contributions) Actuarially Determined Funding Policy Contribution for Tax Levy Item Page 11 Tier 1 Tier 2 Total 16 0 16 0 12 12 16 12 28 3 3 6 10 0 10 0 0 0 0 0 0 0 0 0 29 15 44 0 - 4 5 - 9 10 - 14 15 - 19 20 - 24 25 - 29 30 - 34 35 - 39 40+ Under 20 0 20 - 24 1 1 25 - 29 2 2 4 30 - 34 3 2 1 6 35 - 39 6 6 40 - 44 2 2 3 7 45 - 49 1 1 2 50 - 54 1 1 2 55 - 59 0 60 - 64 0 65 & Over 0 Total 6 6 9 5 1 1 0 0 0 28 Retired Members Minor Dependents Disabled Participants Total Vested Non-Vested Terminated Members entitled to future benefits Surviving Spouses Average Length of Service: Participant Data Exhibit 7 – Summary of Participant Data as of May 1, 2019 37.2 years 10.7 years Active Employee Participants AGE AND SERVICE DISTRIBUTION AS OF MAY 1, 2019 Average Age: Age Group Service Total Item As of 5/1/2019 Active Members Total Actives Page 12 SECTION 4 - SUMMARY OF PRINCIPAL PLAN PROVISIONS This summary provides a general description of the major eligibility and benefit provisions of the pension fund upon which this valuation has been based.It is not intended to be,nor should it be interpreted as,a complete statement of all provisions Definitions Tier 1 – For Police Officers first entering Article 3 prior to January 1, 2011 Tier 2 – For Police Officers first entering Article 3 after December 31, 2010 Police Officer (3-106):Any person appointed to the police force and sworn and commissioned to perform police duties. Persons excluded from Fund (3-109):Part-time officers,special police officer,night watchmen,traffic guards,clerks and civilian employees of the department.Also,police officers who fail to pay the required fund contributions or who elect the Self-Managed Plan option. Creditable Service (3-110):Time served by a police officer,excluding furloughs in excess of 30 days,but including leaves of absences for illness or accident and periods of disability where no disability pension payments have been received and also including up to 3 years during which disability payments have been received provided contributions are made. Pension (3-111) Normal Pension Age Tier 1 - Age 50 with 20 or more years of creditable service. Tier 2 - Age 55 with 10 or more years of creditable service. Normal Pension Amount Tier 1 -50%of the greater of the annual salary held in the year preceding retirement or the annual salary held on the last day of service,plus 2½%of such annual salary for service from 20 to 30 year (maximum 25%)]. Tier 2 -2½%of Final Average salary for each year of service.Final Average Salary is the highest salary based on the highest consecutive 96 months of the final 120 months of service Early Retirement at age 50 with 10 or more years of service but with a penalty of ½%for each month prior to age 55. Annual Salary capped at $106,800 increased yearly by the lesser of ½of the Consumer Price Index-Urban (CPI-U) or 3%. Salary for valuations beginning in 2013 is $109,971.43. Minimum Monthly Benefit: $1,000 Maximum Benefit Percentage: 75% of salary Page 13 Termination Retirement Pension Date Separation of service after completion of between 8 and 20 years of creditable service. Termination Pension Amount Commencing at age 60,2½%of annual salary held in the year preceding termination times years of creditable service or refund of contributions,or for persons terminating on or after July 1,1987,2½%of annual salary held on the last day of service times years of credible service, whichever is greater. Pension Increase Non-Disabled Tier 1 -3%increase of the original pension amount after attainment of age 55 for each year elapsed since retirement,followed by an additional 3%of the original pension amount on each May 1 thereafter. Effective July 1,1993,3%of the amount of pension payable at the time of the increase including increases previously granted, rather than 3% of the originally granted pension amount. Tier 2 -The lesser of ½of the Consumer Price Index-Urban (CPI-U)or 3%increase of the original pension amount after attainment of age 60,followed by an additional 3%of the original pension amount on each May 1 thereafter. Disabled 3%increase of the original pension amount after attainment of age 60 for each year he or she received pension payments, followed by an additional 3% of the original pension amount in each May 1 thereafter. Pension to Survivors (3-112 ) Death of Retired Member Tier 1 - 100% of pension amount to surviving spouse (or dependent children). Tier 2 –66 2/3%of pension amount to surviving spouse (or dependent children),subject to the following increase:the lesser of ½of the Consumer Price Index-Urban (CPI-U)or 3%increase of the original pension amount after attainment of age 60,followed by an additional 3%of the original pension amount on each May 1 thereafter. Death While in Service (Not in line of duty) With 20 years of creditable service, the pension amount earned as of the date of death. With between 10 and 20 years of creditable service,50%of the salary attached to the rank for the year prior to the date of death. Death in Line of Duty 100% of the salary attached to the rank for the last day of service year prior to date of death. Minimum Survivor Pension $1,000 per month to all surviving spouses. Page 14 Disability Pension - Line of Duty (3-114.1) Eligibility Suspension or retirement from police service due to sickness, accident or injury while on duty. Pension Greater of 65%of salary attached to rank at date of suspension or retirement and the retirement pension available. Minimum $1,000 per month. Disability Pension - Not on Duty (3-114.2) Eligibility Suspension or retirement from police service for any cause other than while on duty. Pension 50% of salary attached to rank at date of suspension or retirement. Minimum $1,000 per month. Other Provisions Marriage after Retirement (3-120) No surviving spouse benefit available. Refund (3-124) At death prior to completion of 10 years of service,contributions are returned without interest to widow. At termination with less than 20 years of service, contributions are refunded upon request. Contributions by Police Officers (3-125.1) Beginning May 1,2001,9.91%of salary including longevity,but excluding overtime pay,holiday pay, bonus pay, merit pay or other cash benefit. Page 15 GLOSSARY Actuarial Accrued Liability See Entry Age Normal Cost Method and Projected Unit Credit Cost Method. Actuarial Assumptions The economic and demographic predictions used to estimate the present value of the plan’s future obligations.They include estimates of investment earnings,salary increases,mortality,withdrawal and other related items.The Actuarial Assumptions are used in connection with the Actuarial Cost Method to allocate plan costs over the working lifetimes of plan participants. Actuarial Cost Method The method used to allocate the projected obligations of the plan over the working lifetimes of the plan participants. Also referred to as an Actuarial Funding Method. Actuarial Funding Method See Actuarial Cost Method Actuarial Gain (Loss) The excess of the actual Unfunded Actuarial Accrued Liability over the expected Unfunded Actuarial Accrued Liability represents an Actuarial Loss.If the expected Unfunded Actuarial Accrued Liability is greater, an Actuarial Gain has occurred. Actuarial Present Value The value of an amount or series of amounts payable or receivable at various times,determined as of a given date by the application of a particular set of Actuarial Assumptions . Actuarial Value of Assets The asset value derived by using the plan’s Asset Valuation Method. Asset Valuation Method A valuation method designed to smooth random fluctuations in asset values.The objective underlying the use of an asset valuation method is to provide for the long-term stability of employer contributions. Employee Retirement Income Security Act of 1974 (ERISA) The primary federal legislative act establishing funding,participation,vesting,benefit accrual, reporting, and disclosure standards for pension and welfare plans. Entry Age Normal Cost Method One of the standard actuarial funding methods in which the Present Value of Projected Plan Benefits of each individual included in the Actuarial Valuation is allocated on a level basis over the earnings of the individual between entry age and assumed exit age(s).The portion of this Actuarial Present Value allocated to a valuation year is called the Normal Cost .The portion of this Actuarial Present Value not provided for at a valuation date by the Actuarial Present Value of future Normal Costs is called the Actuarial Accrued Liability . Page 16 GLOSSARY (Continued) Normal Cost The portion of the Present Value of Projected Plan Benefits that is allocated to a particular plan year by the Actuarial Cost Method .See Entry Age Normal Cost Method for a description of the Normal Cost under the Entry Age Normal Cost Method.See Projected Unit Credit Cost Method for a description of the Normal Cost under the Projected Unit Credit Cost Method. Present Value of Future Normal Costs The present value of future normal costs determined based on the Actuarial Cost Method for the plan. Under the Entry Age Normal Cost Method ,this amount is equal to the excess of the Present Value of Projected Plan Benefits over the sum of the Actuarial Value of Assets and Unfunded Actuarial Accrued Liability. Present Value of Projected Plan Benefits The present value of future plan benefits reflecting projected credited service and salaries.The present value is determined based on the plan’s actuarial assumptions. Projected Unit Credit Cost Method One of the standard actuarial funding methods in which the Present Value of Projected Plan Benefits of each individual included in the Actuarial Valuation is allocated by a consistent formula to valuation years. The Actuarial Present Value allocated to a valuation year is called the Normal Cost .The Actuarial Present Value of benefits allocated to all periods prior to a valuation year is called the Actuarial Accrued Liability . Unfunded Actuarial Accrued Liability The excess of the Actuarial Accrued Liability over the Actuarial Value of Assets. Page 17 Mortality Retirement Tier 1 Age Age Age Age 50 15.00%61 25.00%50 15.00%61 25.00% 51 15.00%62 25.00%51 15.00%62 25.00% 52 20.00%63 25.00%52 20.00%63 25.00% 53 20.00%64 25.00%53 20.00%64 25.00% 54 20.00%65 100%54 20.00%65 100% 55 25.00%66 100%55 25.00%66 100% 56 25.00%67 100%56 25.00%67 100% 57 25.00%68 100%57 25.00%68 100% 58 25.00%69 100%58 25.00%69 100% 59 25.00%70 100%59 25.00%70 100% 60 25.00%60 25.00% Tier 2 Age Age Age Age 50 5.00%61 25.00%50 5.00%61 25.00% 51 5.00%62 25.00%51 5.00%62 25.00% 52 5.00%63 25.00%52 5.00%63 25.00% 53 5.00%64 25.00%53 5.00%64 25.00% 54 5.00%65 100%54 5.00%65 100% 55 40.00%66 100%55 40.00%66 100% 56 25.00%67 100%56 25.00%67 100% 57 25.00%68 100%57 25.00%68 100% 58 25.00%69 100%58 25.00%69 100% 59 25.00%70 100%59 25.00%70 100% 60 25.00%60 25.00% Withdrawal Age Age 25 10.40%25 10.40% 40 1.90%40 1.90% 50 1.50%50 1.50% 55 1.50%55 1.50% The results documented in this report are estimates based on data that may be imperfect and on assumptions about future events, some of which are mandated assumptions. Certain provisions may be approximated or deemed immaterial and therefore are not valued. Assumptions may be made about participant data or other factors. A range of results, different from those presented in this report could be considered reasonable. The numbers are not rounded,but this is for convenience and should not imply precisions, which is not inherent in actuarial calculations. Nature of Actuarial Calculations SECTION 5 - SUMMARY OF ACTUARIAL ASSUMPTIONS AND COST METHODS Annual Actuarial Valuation Funding Policy Amount for Tax Levy Annual Actuarial Valuation Statutory Minimum Actuarial Assumption Interest 7.00% per annum 7.00% per annum RP2014 Healthy Annuitant with Blue Collar Adjustments Projected Generationally from 2013 with Scale MP2018 RP2014 Healthy Annuitant with Blue Collar Adjustments Projected Generationally from 2013 with Scale MP2018 Rates of retirement for all ages are:Rates of retirement for all ages are: Rates of termination are based upon age only. Sample rates for selected ages are: Rates of termination are based upon age only. Sample rates for selected ages are: Tier 1 Tier 2 Page 18 Disability Age Age 25 0.03%25 0.03% 40 0.42%40 0.42% 50 0.71%50 0.71% 55 0.90%55 0.90% Salary Increase 60%of disablities are assumed to occur in the line of duty 60%of disablities are assumed to occur in the line of duty Assets are valued at fair market value and smoothed over five years, reflecting gains and losses at 20% per year. Entry Age Normal Cost Method Percentage Married Asset Valuation Method Actuarial Cost Methods This is the mandated actuarial method to be used in determining the statutory contribution requirements and under PA 096- 1495. This method determines the present value of projected benefits and prorates the projected benefit by service to date to determine the accrued liability. Amounts attributable to past service are amortized as a level percentage of pay with the goal of reaching 90% of the accrued liability by 2040. 3.50% per annum 3.50% per annum 5% per annum 5% per annum Payroll Growth This method projects benefits from entry age to retirement age and attributes costs over total service, as a level percentage of pay. Amounts attributable to past service have been amortized over 21 years on a closed basis as a level percentage of pay. Assets are valued at fair market value and smoothed over three years, reflecting gains and losses at 20% per year. Projected Unit Credit Cost Method 80% are married, females are assumed to be 3 years younger 80% are married, females are assumed to be 3 years younger Annual Actuarial Valuation Funding Policy Amount for Tax Levy Actuarial Assumption Item Annual Actuarial Valuation Statutory Minimum Rates of disability are based upon age only. Sample rates for selected ages are: Rates of disability are based upon age only. Sample rates for selected ages are: Page 19 Showing Assets and Liabilities of the Fund in Accordance with Actuarial Reserve Requirements as of May 1, 2019 Summary Accrued Liability $22,155,138 Actuarial Value of Assets $10,450,231 Unfunded Accrued Liability $11,704,907 Funded Ratio 47% Liabilities Reserves for Annuities and Benefits in Force Head Count: Present Value: Retirement Annuities 10 12,563,078 Disability Annuities 0 0 Surviving Spouse Annuities 0 0 Minor Dependent Annuities 0 0 Deferred Retirement Annuities 3 396,225 Handicapped Dependent Annuities 0 0 Dependent Parent Annuities 0 0 Terminated Liabilities 3 4,608 Total:16 $12,963,911 Accrued Liabilities for Active Members 28 $9,191,227 Total Accrued Liabilities $22,155,138 Total Normal Cost for Active Members $674,161 Total Normal Cost as a Percentage of Payroll 28% Total Annual Payroll $2,450,118 Amortization of Unfunded Liabilities: Total Accrued Liability $22,155,138 90% Funded Ratio Target $19,939,624 Actuarial Value of Assets $10,450,231 Liabilities Subject to Amortization $9,489,393 Amortization Period 21 years Amortization Payment, Beginning of Year $592,421 This report is provided to the Board and Municipality as part of the Public Pension Division advisory services under Section 1A-106 of the Illinois Pension Code. This report should not be relied upon for purposes other than determining the current tax levy required under the Illinois Pension Code. The assumptions have been set based on expectations for all Article 3 funds in the State of Illinois. The actuarial methods are prescribed by the Illinois Pension Code and do not necessarily represent the approach recommended by either the actuary or the Department of Insurance. This report was prepared under the direct supervision of the undersigned: Brad Lee Armstrong (Enrolled Actuary #17-5614) Lance Weiss (Enrolled Actuary #17-2468) GRS Deputy Director Public Pension Division Illinois Department of Insurance 1/8/2020 6:03:32 PM Page 1 of 3Fund Number: 3335 BID: 20190401 YORKVILLE POLICE PENSION FUND Actuarial Valuation Report Assets Actuarial Value of Assets Current Year Gain/(Loss): Market value of assets as of April 30, 2018 $9,089,102 Benefit payments during fiscal year 2019 (597,064) Administrative expense during fiscal year 2019 (12,693) Total contributions during fiscal year 2019 1,207,302 Expected return during fiscal year 2019 586,742 Expected market value of assets as of April 30, 2019 $10,273,389 Actual market value of assets as of April 30, 2019 $10,403,718 Investment gain/(loss) during the fiscal year $130,329 Development of Actuarial Value of Assets (market value less unrecognized amounts): Market value of assets as of April 30, 2019 $10,403,718 Unrecognized gain/(loss) from fiscal 2019 104,263 Unrecognized gain/(loss) from fiscal 2018 (66,260) Unrecognized gain/(loss) from fiscal 2017 11,033 Unrecognized gain/(loss) from fiscal 2016 (95,549) Actuarial value of assets as of April 30, 2019 $10,450,231 Actuarially Determined Employer Contributions Actuarially determined amount to provide the employer normal cost based on the annual payroll of active participants as of May 1, 2019. $431,354 Amount necessary to amortize the unfunded accrued liability as determined by the State of Illinois Department of Insurance over the remaining 21 years as prescribed by Section 3-125 of the Illinois Pension Code. $592,421 Interest to the end of the fiscal year.$66,545 Total suggested amount of employer contributions to arrive at the annual requirements of the fund as prescribed by Section 3-125 of the Illinois Pension Code. * $1,090,320 *The above figure is the suggested amount which should be obtained by the fund from the municipality exclusive of any other items of income, such as interest on investments, contributions from participants, etc. These items have already been taken into consideration in arriving at this amount. 1/8/2020 6:03:32 PM Page 2 of 3Fund Number: 3335 BID: 20190401 YORKVILLE POLICE PENSION FUND Actuarial Valuation Report Actuarial Information The following methods have been prescribed in accordance with Section 3-125 of the Illinois Pension Code. Funding method Projected Unit Credit Amortization method Normal cost, plus an additional amount (determined as a level percentage of payroll) to bring the plan's funded ratio to 90% by the end of fiscal year 2040. Asset valuation method Investment gains and losses are recognized over a 5-year period. Actuarial Assumptions Interest rate 6.50% Interest rate, prior fiscal year 6.25% Healthy mortality rates - Male RP-2014 Healthy Annuitant with Blue Collar Adjustment, males Healthy mortality rates - Female RP-2014 Healthy Annuitant with Blue Collar Adjustment, females Disability mortality rates - Male 115% of RP-2014 Healthy Annuitant with Blue Collar Adjustment, males Disability mortality rates - Female 115% of RP-2014 Healthy Annuitant with Blue Collar Adjustment, females Decrements other than mortality Experience tables Rate of service-related deaths 10% Rate of service-related disabilities 60% Salary increases Service-related table with rates grading from 11.00% to 3.50% at 33 years of service Payroll growth 3.50% Tier 2 cost-of-living adjustment 1.25% Marital assumptions for active members 80% of members are assumed to be married; male spouses are assumed to be 3 years older than female spouses. The actuarial assumptions used for determining the above amounts are based on experience for all Article 3 funds for the State of Illinois in aggregate. The Department of Insurance has approved the above actuarial assumptions. Contact the Department of Insurance for complete experience tables. Data and Fund Information The above valuation uses personnel data as reported to the Department of Insurance in the Schedule P. Specifically, the following data items have been determined as of the date of the Actuarial Valuation Report: attained age, annual salary or pension, completed years of service of each individual participant. The fund specific information used in the production of this document was provided to the Department of Insurance by your pension fund board of trustees through the fund’s annual statement filing. Additional critical information regarding actuarial assumptions and methods, and important actuarial disclosures are provided in the Actuarial Valuation Report Disclosures Document located on the following Illinois DOI Website (https://insurance.illinois.gov/Applications/Pension/FOIAReporting/FOIAPortal.aspx) 1/8/2020 6:03:32 PM Page 3 of 3Fund Number: 3335 BID: 20190401 YORKVILLE POLICE PENSION FUND Actuarial Valuation Report Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number Old Business #1 Tracking Number ADM 2020-38 Cable Consortium – Exit and Moving Forward – Strategy – Plan Providing Services Administration Committee – June 17, 2020 A discussion will take place at the meeting. Bart Olson Administration Name Department Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number Old Business #2 Tracking Number ADM 2020-39 Governing Ordinance – Discussion of Review and Changes Administration Committee – June 17, 2020 A discussion will take place at the meeting. Bart Olson Administration Name Department