HomeMy WebLinkAbout2021.10 October Monthly Report
To: Kelley A. Gandurski, Interim City Manager
From: Hitesh Desai, CFO/City Treasurer
Subject: October 2021 Monthly Financial Report
Date: December 3, 2021
Please find attached the unaudited financial statements as of October 31, 2021. A summary by fund
for revenues, expenditures, fund and cash balances is as follows:
Fund # Fund Name Revenue Expense Net Fund Balance Cash Balance
100 General 106,711,325 95,691,342 11,019,983 28,486,250 24,615,589
170 American Rescue Plan 21,609,614 4,800,000 16,809,614 16,809,614 16,809,614
175 General Assistance 1,313,898 919,833 394,065 783,600 783,473
176 Health and Human Services 3,698,913 1,895,218 1,803,695 2,773,758 2,773,569
177 Reparations 31,720 1,750 29,970 248,112 248,111
180 Good Neighbor 1,000,785 449,457 551,328 902,146 902,146
185 Library 8,010,860 6,604,901 1,405,959 4,300,798 4,313,061
186 Library Debt Service 482,243 124,950 357,293 358,438 358,438
187 Library Capital Improvement FD - 386,219 (386,219) 897,739 897,739
200 MFT 4,030,383 2,951,572 1,078,811 5,041,554 4,819,159
205 E911 1,081,319 798,881 282,438 1,672,068 1,315,344
210 Special Service Area (SSA) #9 601,023 299,214 301,809 87,149 87,149
215 CDBG 859,467 1,191,375 (331,908) (271,085) (271,085)
220 CD Loan 103,187 16,710 86,477 269,302 269,301
235 Neighborhood Improvement 20 9 11 22,132 22,131
240 Home 341,012 348,114 (7,102) 22,463 22,463
250 Affordable Housing 444,203 1,659,295 (1,215,092) 2,586,691 2,719,582
320 Debt Service 19,248,055 7,019,894 12,228,161 12,949,619 12,949,619
330 Howard Ridge 1,284,133 728,169 555,964 2,892,007 2,874,448
335 West Evanston 1,946,790 461,958 1,484,832 3,279,462 3,279,462
340 Dempster-Dodge-TIF 283,360 141,235 142,125 354,388 354,388
345 Chicago Main-TIF 1,135,865 1,375,158 (239,293) 1,085,379 1,085,379
350 Special Service Area (SSA) #6 220,271 7,548 212,723 216,795 216,795
355 Special Service Area (SSA) #7 139,199 73,741 65,458 65,811 65,811
360 Special Service Area (SSA) #8 60,048 30,893 29,155 30,201 30,200
415 Capital Improvements 9,421,473 5,855,442 3,566,031 14,084,543 14,407,148
416 Crown Construction 3,210,218 1,744,902 1,465,316 4,096,200 5,384,458
417 Crown Community CTR Maintenance 145,830 - 145,830 320,830 320,830
420 Special Assessment 73,039 407,820 (334,781) 2,318,686 2,314,405
505 Parking 7,857,632 7,407,628 450,004 938,961 1,093,300
510 Water 25,129,680 22,883,914 2,245,766 13,155,313 15,526,351
515 Sewer 8,393,986 6,989,536 1,404,450 6,306,396 4,996,305
520 Solid Waste 5,150,177 4,820,836 329,341 179,016 (504,559)
600 Fleet 2,592,250 2,411,850 180,400 920,081 (429,155)
601 Equipment Replacement 1,197,844 1,160,820 37,024 560,568 560,568
605 Insurance 17,137,151 15,346,469 1,790,682 (6,673,007) (2,194,128)
Grand Total 254,946,973 197,006,654 57,940,319 122,071,977 123,017,410
Memorandum
Please note that the attached supporting documents have been updated to show further fund
and department analysis.
Included above are ending fund and cash balances as of October 31, 2021. Cash balance represents
liquid cash and/or invested assets which can be used (or easily sold) to support and fund current
ooperations. Fund balance includes illiquid assets or future cash receipts or disbursements such as
receivables (including property tax) due to the City and accounts payable/accrued expenses. All fund
balances are unaudited.
General Fund
The unaudited financial statements show the General Fund as of October 31, 2021 with a fund
balance of $28,486,250 and cash balance of $24,615,589. The attached financials show General
Fund revenues at 96% of budget and expenses at 86% of budget against a target of 83%. The 2020
ending balance for the General Fund is $17,466,267.
The Cook County second installment property tax bills for tax year 2020 went out during the last week
of August with a due date of October 1. General Fund revenues are high because most of the
property tax revenues are received by October 31. Whereas, expenses are slightly above target
because of an additional payroll in the month of October (3 payrolls).
Staff continues to monitor Police and Fire overtime expenses. Through October, Police had spent
75% of budget for overtime, and Fire had spent 130% over the annual budget. For Police, this is
below target of 83%. Overtime is higher in Fire Department due to the onboarding/ training of new
firefighters. Overtime will begin to decrease once recruits are fully trained. Fire overtime is also high
because of Firefighter/Paramedics serving at vaccine clinics. This cost is expected to be covered by
FEMA reimbursement.
Overtime
Expenses
2020 Actual 2021 Budget 2021 YTD % Budget
Police $913,232 $ 1,484,322 $1,119,163 75%
Fire $1,651,457 $ 959,956 $1,250,305 130%
Enterprise Funds
Parking fund revenues through October 31, 2021 are at 68% of budget and expenses are at 66%. The
fund ended 2020 with a fund balance of $488,957.
Through October 31, 2021 , the Water Fund appears low on revenue and expenses. This is because
capital projects funded with IEPA loan/debt will take place later in the year/next year. These projects
are budgeted in Other Revenue and expenses in Capital Outlay. The 2020 ending fund balance is
$10,909,547.
The Water Fund revenues reflect payment from the Village of Skokie at the rate of $1.26 per 1000
gallons as agreed upon recently.
Through October 31, 2021, the Sewer Fund also appears low on expenses mainly due to the capital
projects and debt service payments occurring later in the year. The 2020 ending fund balance is
$4,901,944.
Through October 31, 2021, the Solid Waste Fund has a fund balance of $179,016 and a negative
cash balance of $504,559. The fund ended 2020 with a fund balance of $(150,325).
Other Funds
Through October 31, 2021, the SSA #9 Fund is showing fund and cash balance of $87,149.
Through October 31, 2021, the Capital Improvements Fund is showing a fund balance of $14,084,543
and a cash balance of $14,407,148. The fund continues to spend down Series 2021 and Series 2020
bond proceeds.
Through October 31, 2021, the Crown Construction fund is showing fund balance of $4,096,200 and
cash balance of $5,384,458. The fund continues to spend down balances from bond proceeds and
gifts from the Friends of Robert Crown.
Through October 31, 2021, the Insurance Fund is showing a negative fund balance of $6,673,007 and
a negative cash balance of $2,194,128. Fund balance is significantly lower than cash balance due to
accrued liabilities for pending litigations.
If there are any questions on the attached report, please contact me by phone at (847) 448-8082 or by
email: hdesai@cityofevanston.org. Detailed fund summary reports can be found at:
http://www.cityofevanston.org/city-budget/financial-reports/.
CERTIFICATION OF ATTACHED FINANCIAL REPORTS
As required per Illinois Statute 65 ILCS 5/3.1-35-45 I, Hitesh Desai, Treasurer of the City of Evanston,
hereby affirm that I have reviewed the October 31, 2021 year-to-date financial information and reports
which to the best of my knowledge appear accurate and complete.
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
28,298,539.00 8,134,724.70 28,305,773.27 (7,234.27)100 29,359,627.04
48,775,000.00 6,621,604.21 49,357,784.57 (582,784.57)101 49,738,362.28
8,085,550.00 584,586.32 7,272,093.54 813,456.46 90 9,189,637.18
4,123,500.00 293,125.16 2,792,289.47 1,331,210.53 68 2,990,415.44
9,357,875.00 777,880.32 7,536,045.18 1,821,829.82 81 7,527,170.00
9,149,103.00 730,759.00 7,721,741.77 1,427,361.23 84 9,269,103.00
1,584,942.00 175,055.26 2,700,257.42 (1,115,315.42)170 3,242,220.10
1,593,100.00 220,797.01 998,476.92 594,623.08 63 1,603,485.28
55,000.00 1,868.22 26,862.45 28,137.55 49 68,280.09
111,022,609.00 17,540,400.20 106,711,324.59 4,311,284.41 96%112,988,300.41
LEGISLATIVE .00 .00 795.00 (795.00)+++3,139.75
CITY COUNCIL 556,165.60 59,243.27 422,804.55 133,361.05 76 472,270.09
CITY CLERK 178,794.66 27,648.79 164,392.13 14,402.53 92 183,831.96
CITY MANAGER'S OFFICE 6,004,834.63 704,577.18 5,114,484.72 890,349.91 85 10,136,584.81
LAW 576,892.00 66,220.72 424,862.63 152,029.37 74 511,640.20
ADMINISTRATIVE SERVICES 10,360,246.39 1,062,954.06 8,537,368.27 1,822,878.12 82 9,295,177.88
COMMUNITY DEVELOPMENT 3,073,829.11 356,251.16 2,716,239.33 357,589.78 88 3,150,001.53
POLICE 39,734,285.59 5,742,018.69 34,329,662.06 5,404,623.53 86 38,724,587.22
FIRE MGMT & SUPPORT 26,006,574.05 4,062,300.69 23,270,394.55 2,736,179.50 89 26,265,320.62
HEALTH 1,556,419.50 189,489.40 1,641,265.10 (84,845.60)105 1,331,233.68
PARKS AND RECREATION 11,329,360.87 915,430.78 9,352,473.25 1,976,887.62 83 9,550,408.37
PUBLIC WORKS AGENCY 11,642,790.99 1,105,376.84 9,716,600.65 1,926,190.34 83 11,566,540.90
LIBRARY .00 .00 .00 .00 +++30.00
111,020,193.39 14,291,511.58 95,691,342.24 15,328,851.15 86%111,190,767.01
111,022,609.00 17,540,400.20 106,711,324.59 4,311,284.41 96%112,988,300.41
111,020,193.39 14,291,511.58 95,691,342.24 15,328,851.15 86%111,190,767.01
$2,415.61 $3,248,888.62 $11,019,982.35 $11,017,566.74 456,199%$1,797,533.40
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type GENERAL FUND
Fund 100 - GENERAL FUND
Property Taxes
Other Taxes
Licenses, Permits and Fees
Fines and Forfeitures
Charges for Services
Interfund Transfers
Intergovernmental Revenue
Other Revenue
Interest Income
REVENUE TOTALS
EXPENSE TOTALS
Fund 100 - GENERAL FUND Net Gain (Loss)
REVENUE TOTALS
EXPENSE TOTALS
Fund 100 - GENERAL FUND Totals
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
3,110,000.00 .00 3,110,000.00 .00 100 3,110,000.00
450,000.00 37,500.00 375,000.00 75,000.00 83 100,000.00
125,000.00 26,340.00 209,599.60 (84,599.60) 168 50,548.97
2,000.00 200.00 2,940.00 (940.00) 147 95,950.00
.00 70.20 1,373.26 (1,373.26) +++ 800.72
$3,687,000.00 $64,110.20 $3,698,912.86 ($11,912.86) 100% $3,357,299.69
$3,687,000.00 $64,110.20 $3,698,912.86 ($11,912.86) 100% $3,357,299.69
736,373.00 .00 .00 736,373.00 0 .00
$736,373.00 $0.00 $0.00 $736,373.00 0% $0.00
1,697,148.21 163,967.21 1,310,955.13 386,193.08 77 1,217,849.18
603,870.00 3,730.38 329,081.34 274,788.66 54 338,286.16
.00 .00 8,861.29 (8,861.29) +++ 10,268.14
143,333.00 .00 88,125.27 55,207.73 61 735,569.47
465,000.00 32,790.73 158,194.50 306,805.50 34 112,670.28
.00 .00 .00 .00 +++ 3,352.00
$2,909,351.21 $200,488.32 $1,895,217.53 $1,014,133.68 65% $2,417,995.23
$3,645,724.21 $200,488.32 $1,895,217.53 $1,750,506.68 52% $2,417,995.23
3,687,000.00 64,110.20 3,698,912.86 (11,912.86) 100% 3,357,299.69
3,645,724.21 200,488.32 1,895,217.53 1,750,506.68 52% 2,417,995.23
$41,275.79 ($136,378.12) $1,803,695.33 $1,762,419.54 4,370% $939,304.46
REVENUE TOTALS
EXPENSE TOTALS
Fund 176 - HUMAN SERVICES FUND Net Gain (Loss)
Interfund Transfers
Department 24 - HEALTH Totals
EXPENSE TOTALS
Fund 176 - HUMAN SERVICES FUND Totals
Salary and Benefits
Services and Supplies
Insurance and Other Chargebacks
Community Sponsored Organizations
Miscellaneous
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies
Department 21 - COMMUNITY DEVELOPMENT Totals
Department 24 - HEALTH
Intergovernmental Revenue
Other Revenue
Interest Income
Department 24 - HEALTH Totals
REVENUE TOTALS
Fund 176 - HUMAN SERVICES FUND
REVENUE
Department 24 - HEALTH
Property Taxes
Interfund Transfers
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type GENERAL FUND
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
.00 .00 21,586,827.00 (21,586,827.00) +++ .00
.00 2,887.63 22,786.54 (22,786.54) +++ .00
$0.00 $2,887.63 $21,609,613.54 ($21,609,613.54) +++ $0.00
$0.00 $2,887.63 $21,609,613.54 ($21,609,613.54) +++ $0.00
.00 850,000.00 4,800,000.00 (4,800,000.00) +++ .00
$0.00 $850,000.00 $4,800,000.00 ($4,800,000.00) +++ $0.00
$0.00 $850,000.00 $4,800,000.00 ($4,800,000.00) +++ $0.00
.00 2,887.63 21,609,613.54 (21,609,613.54) +++ .00
.00 850,000.00 4,800,000.00 (4,800,000.00) +++ .00
$0.00 ($847,112.37) $16,809,613.54 $16,809,613.54 +++ $0.00
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 170 - AMERICAN RESCUE PLAN
REVENUE
Department 99 - NON-DEPARTMENTAL
Intergovernmental Revenue
Interest Income
Department 99 - NON-DEPARTMENTAL Totals
REVENUE TOTALS
EXPENSE
Department 99 - NON-DEPARTMENTAL
Interfund Transfers
EXPENSE TOTALS
Fund 170 - AMERICAN RESCUE PLAN Net Gain (Loss)
Department 99 - NON-DEPARTMENTAL Totals
EXPENSE TOTALS
Fund 170 - AMERICAN RESCUE PLAN Totals
REVENUE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
1,300,000.00 325,800.79 1,310,171.19 (10,171.19) 101 1,100,904.14
27,500.00 .00 2,585.00 24,915.00 9 42,115.91
1,000.00 75.80 1,142.07 (142.07) 114 3,131.62
$1,328,500.00 $325,876.59 $1,313,898.26 $14,601.74 99% $1,146,151.67
$1,328,500.00 $325,876.59 $1,313,898.26 $14,601.74 99% $1,146,151.67
452,062.40 51,682.15 409,191.40 42,871.00 91 406,614.05
865,982.00 47,782.40 505,964.91 360,017.09 58 708,132.08
7,000.00 262.70 4,676.28 2,323.72 67 4,910.00
$1,325,044.40 $99,727.25 $919,832.59 $405,211.81 69% $1,119,656.13
$1,325,044.40 $99,727.25 $919,832.59 $405,211.81 69% $1,119,656.13
1,328,500.00 325,876.59 1,313,898.26 14,601.74 99% 1,146,151.67
1,325,044.40 99,727.25 919,832.59 405,211.81 69% 1,119,656.13
$3,455.60 $226,149.34 $394,065.67 $390,610.07 11,404% $26,495.54
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 175 - GENERAL ASSISTANCE FUND
REVENUE
Department 24 - HEALTH
Property Taxes
Other Revenue
Interest Income
Department 24 - HEALTH Totals
REVENUE TOTALS
EXPENSE
Department 24 - HEALTH
Salary and Benefits
Services and Supplies
Miscellaneous
Department 24 - HEALTH Totals
EXPENSE TOTALS
Fund 175 - GENERAL ASSISTANCE FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 175 - GENERAL ASSISTANCE FUND Net Gain (Loss)
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
3,110,000.00 .00 3,110,000.00 .00 100 3,110,000.00
450,000.00 37,500.00 375,000.00 75,000.00 83 100,000.00
125,000.00 26,340.00 209,599.60 (84,599.60) 168 50,548.97
2,000.00 200.00 2,940.00 (940.00) 147 95,950.00
.00 70.20 1,373.26 (1,373.26) +++ 800.72
$3,687,000.00 $64,110.20 $3,698,912.86 ($11,912.86) 100% $3,357,299.69
$3,687,000.00 $64,110.20 $3,698,912.86 ($11,912.86) 100% $3,357,299.69
736,373.00 .00 .00 736,373.00 0 .00
$736,373.00 $0.00 $0.00 $736,373.00 0% $0.00
1,697,148.21 163,967.21 1,310,955.13 386,193.08 77 1,217,849.18
603,870.00 3,730.38 329,081.34 274,788.66 54 338,286.16
.00 .00 8,861.29 (8,861.29) +++ 10,268.14
143,333.00 .00 88,125.27 55,207.73 61 735,569.47
465,000.00 32,790.73 158,194.50 306,805.50 34 112,670.28
.00 .00 .00 .00 +++ 3,352.00
$2,909,351.21 $200,488.32 $1,895,217.53 $1,014,133.68 65% $2,417,995.23
$3,645,724.21 $200,488.32 $1,895,217.53 $1,750,506.68 52% $2,417,995.23
3,687,000.00 64,110.20 3,698,912.86 (11,912.86) 100% 3,357,299.69
3,645,724.21 200,488.32 1,895,217.53 1,750,506.68 52% 2,417,995.23
$41,275.79 ($136,378.12) $1,803,695.33 $1,762,419.54 4,370% $939,304.46
REVENUE TOTALS
EXPENSE TOTALS
Fund 176 - HUMAN SERVICES FUND Net Gain (Loss)
Interfund Transfers
Department 24 - HEALTH Totals
EXPENSE TOTALS
Fund 176 - HUMAN SERVICES FUND Totals
Salary and Benefits
Services and Supplies
Insurance and Other Chargebacks
Community Sponsored Organizations
Miscellaneous
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies
Department 21 - COMMUNITY DEVELOPMENT Totals
Department 24 - HEALTH
Intergovernmental Revenue
Other Revenue
Interest Income
Department 24 - HEALTH Totals
REVENUE TOTALS
Fund 176 - HUMAN SERVICES FUND
REVENUE
Department 24 - HEALTH
Property Taxes
Interfund Transfers
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type GENERAL FUND
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
400,000.00 .00 .00 400,000.00 0 .00
.00 .00 .00 .00 +++ 200,000.00
.00 180.00 31,410.29 (31,410.29) +++ 16,806.50
.00 38.11 309.59 (309.59) +++ .00
$400,000.00 $218.11 $31,719.88 $368,280.12 8% $216,806.50
$400,000.00 $218.11 $31,719.88 $368,280.12 8% $216,806.50
.00 277.38 1,749.98 (1,749.98) +++ .00
400,000.00 .00 .00 400,000.00 0 .00
$400,000.00 $277.38 $1,749.98 $398,250.02 0% $0.00
$400,000.00 $277.38 $1,749.98 $398,250.02 0% $0.00
400,000.00 218.11 31,719.88 368,280.12 8% 216,806.50
400,000.00 277.38 1,749.98 398,250.02 0% .00
$0.00 ($59.27) $29,969.90 $29,969.90 +++ $216,806.50
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 177 - REPARATIONS FUND
REVENUE
Department 15 - CITY MANAGER'S OFFICE
Other Taxes
Interfund Transfers
Other Revenue
Interest Income
Department 15 - CITY MANAGER'S OFFICE Totals
REVENUE TOTALS
EXPENSE
Department 15 - CITY MANAGER'S OFFICE
Services and Supplies
Miscellaneous
Department 15 - CITY MANAGER'S OFFICE Totals
EXPENSE TOTALS
Fund 177 - REPARATIONS FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 177 - REPARATIONS FUND Net Gain (Loss)
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
1,000,000.00 .00 1,000,000.00 .00 100 1,000,000.00
.00 37.30 785.47 (785.47) +++ 1,805.35
$1,000,000.00 $37.30 $1,000,785.47 ($785.47) 100% $1,001,805.35
$1,000,000.00 $37.30 $1,000,785.47 ($785.47) 100% $1,001,805.35
.00 25.42 384.91 (384.91) +++ 497.43
620,000.00 23,300.00 34,920.59 585,079.41 6 33,034.90
380,000.00 .00 414,151.77 (34,151.77) 109 870,000.04
$1,000,000.00 $23,325.42 $449,457.27 $550,542.73 45% $903,532.37
$1,000,000.00 $23,325.42 $449,457.27 $550,542.73 45% $903,532.37
1,000,000.00 37.30 1,000,785.47 (785.47) 100% 1,001,805.35
1,000,000.00 23,325.42 449,457.27 550,542.73 45% 903,532.37
$0.00 ($23,288.12) $551,328.20 $551,328.20 +++ $98,272.98
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 180 - GOOD NEIGHBOR FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Other Revenue
Interest Income
Department 99 - NON-DEPARTMENTAL Totals
REVENUE TOTALS
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies
Fund 180 - GOOD NEIGHBOR FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 180 - GOOD NEIGHBOR FUND Net Gain (Loss)
Miscellaneous
Interfund Transfers
Department 99 - NON-DEPARTMENTAL Totals
EXPENSE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
7,252,000.00 1,802,851.46 7,254,222.18 (2,222.18) 100 7,268,891.26
.00 .00 4,509.40 (4,509.40) +++ 22,320.17
.00 36.46 208.29 (208.29) +++ 149.90
209,000.00 .00 250,000.00 (41,000.00) 120 199,414.25
238,000.00 21,478.00 254,025.34 (16,025.34) 107 285,045.65
400,000.00 (2,735.02) 174,859.60 225,140.40 44 427,372.39
227,224.00 7,144.95 64,346.71 162,877.29 28 71,720.03
15,000.00 447.52 8,688.00 6,312.00 58 26,949.16
$8,341,224.00 $1,829,223.37 $8,010,859.52 $330,364.48 96% $8,301,862.81
$8,341,224.00 $1,829,223.37 $8,010,859.52 $330,364.48 96% $8,301,862.81
5,910,018.36 605,397.88 4,769,282.08 1,140,736.28 81 5,405,967.44
2,052,000.00 186,991.00 1,533,145.40 518,854.60 75 1,714,948.94
8,500.00 .00 1,463.52 7,036.48 17 775.00
.00 .00 .00 .00 +++ 600.00
361,226.00 30,101.00 301,010.00 60,216.00 83 354,375.00
$8,331,744.36 $822,489.88 $6,604,901.00 $1,726,843.36 79% $7,476,666.38
$8,331,744.36 $822,489.88 $6,604,901.00 $1,726,843.36 79% $7,476,666.38
8,341,224.00 1,829,223.37 8,010,859.52 330,364.48 96% 8,301,862.81
8,331,744.36 822,489.88 6,604,901.00 1,726,843.36 79% 7,476,666.38
$9,479.64 $1,006,733.49 $1,405,958.52 $1,396,478.88 14,831% $825,196.43
EXPENSE TOTALS
Fund 185 - LIBRARY FUND Net Gain (Loss)
Department 48 - LIBRARY Totals
EXPENSE TOTALS
Fund 185 - LIBRARY FUND Totals
REVENUE TOTALS
Salary and Benefits
Services and Supplies
Capital Outlay
Miscellaneous
Interfund Transfers
Interest Income
Department 48 - LIBRARY Totals
REVENUE TOTALS
EXPENSE
Department 48 - LIBRARY
Charges for Services
Interfund Transfers
Intergovernmental Revenue
Other Revenue
Library Revenue
Fund 185 - LIBRARY FUND
REVENUE
Department 48 - LIBRARY
Property Taxes
Fines and Forfeitures
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
3,656,700.00 257,531.84 4,026,483.11 (369,783.11) 110 4,346,950.35
12,000.00 267.79 3,899.52 8,100.48 32 18,013.10
$3,668,700.00 $257,799.63 $4,030,382.63 ($361,682.63) 110% $4,364,963.45
$3,668,700.00 $257,799.63 $4,030,382.63 ($361,682.63) 110% $4,364,963.45
.00 .00 163,434.00 (163,434.00) +++ 25,472.95
.00 .00 .00 .00 +++ 1,044,987.00
$0.00 $0.00 $163,434.00 ($163,434.00) +++ $1,070,459.95
1,038,000.00 8,095.25 625,300.47 412,699.53 60 684,583.03
2,284,000.00 109,523.34 1,292,017.95 991,982.05 57 1,316,209.69
1,044,987.00 87,082.00 870,820.00 174,167.00 83 .00
$4,366,987.00 $204,700.59 $2,788,138.42 $1,578,848.58 64% $2,000,792.72
$4,366,987.00 $204,700.59 $2,951,572.42 $1,415,414.58 68% $3,071,252.67
3,668,700.00 257,799.63 4,030,382.63 (361,682.63) 110% 4,364,963.45
4,366,987.00 204,700.59 2,951,572.42 1,415,414.58 68% 3,071,252.67
($698,287.00) $53,099.04 $1,078,810.21 $1,777,097.21 (154%) $1,293,710.78
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 200 - MOTOR FUEL TAX FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Intergovernmental Revenue
Interest Income
Department 40 - PUBLIC WORKS AGENCY Totals
REVENUE TOTALS
EXPENSE
Department 26 - PUBLIC WORKS
Capital Outlay
Interfund Transfers
Department 26 - PUBLIC WORKS Totals
Department 40 - PUBLIC WORKS AGENCY
Services and Supplies
Capital Outlay
REVENUE TOTALS
EXPENSE TOTALS
Fund 200 - MOTOR FUEL TAX FUND Net Gain (Loss)
Interfund Transfers
Department 40 - PUBLIC WORKS AGENCY Totals
EXPENSE TOTALS
Fund 200 - MOTOR FUEL TAX FUND Totals
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
1,321,600.00 120,765.03 1,080,390.72 241,209.28 82 1,460,634.96
.00 .00 .00 .00 +++ 240,821.00
.00 .00 266.17 (266.17) +++ .00
7,000.00 20.28 661.69 6,338.31 9 5,531.23
$1,328,600.00 $120,785.31 $1,081,318.58 $247,281.42 81% $1,706,987.19
$1,328,600.00 $120,785.31 $1,081,318.58 $247,281.42 81% $1,706,987.19
742,978.48 65,354.33 473,200.23 269,778.25 64 561,536.22
374,000.00 7,182.17 227,694.89 146,305.11 61 241,438.39
299,163.00 .00 7,795.66 291,367.34 3 506,613.00
18,230.00 1,519.00 15,190.00 3,040.00 83 18,229.00
.00 .00 .00 .00 +++ 500.00
90,000.00 7,500.00 75,000.00 15,000.00 83 260,000.00
$1,524,371.48 $81,555.50 $798,880.78 $725,490.70 52% $1,588,316.61
$1,524,371.48 $81,555.50 $798,880.78 $725,490.70 52% $1,588,316.61
1,328,600.00 120,785.31 1,081,318.58 247,281.42 81% 1,706,987.19
1,524,371.48 81,555.50 798,880.78 725,490.70 52% 1,588,316.61
($195,771.48) $39,229.81 $282,437.80 $478,209.28 (144%) $118,670.58
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 205 - EMERGENCY TELEPHONE (E911) FUND
REVENUE
Department 22 - POLICE
Other Taxes
Intergovernmental Revenue
Other Revenue
Interest Income
Department 22 - POLICE Totals
REVENUE TOTALS
EXPENSE
Department 22 - POLICE
Salary and Benefits
Services and Supplies
Capital Outlay
Insurance and Other Chargebacks
Fund 205 - EMERGENCY TELEPHONE (E911) FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 205 - EMERGENCY TELEPHONE (E911) FUND Net Gain (Loss)
Miscellaneous
Interfund Transfers
Department 22 - POLICE Totals
EXPENSE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
592,665.00 96,552.97 601,015.86 (8,350.86) 101 603,396.20
.00 2.18 7.18 (7.18) +++ 87.15
$592,665.00 $96,555.15 $601,023.04 ($8,358.04) 101% $603,483.35
$592,665.00 $96,555.15 $601,023.04 ($8,358.04) 101% $603,483.35
575,000.00 .00 299,213.69 275,786.31 52 591,950.27
$575,000.00 $0.00 $299,213.69 $275,786.31 52% $591,950.27
$575,000.00 $0.00 $299,213.69 $275,786.31 52% $591,950.27
592,665.00 96,555.15 601,023.04 (8,358.04) 101% 603,483.35
575,000.00 .00 299,213.69 275,786.31 52% 591,950.27
$17,665.00 $96,555.15 $301,809.35 $284,144.35 1,709% $11,533.08
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 210 - SPECIAL SERVICE AREA (SSA) #9
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Property Taxes
Interest Income
Department 21 - COMMUNITY DEVELOPMENT Totals
REVENUE TOTALS
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies
EXPENSE TOTALS
Fund 210 - SPECIAL SERVICE AREA (SSA) #9 Net Gain (Loss)
Department 21 - COMMUNITY DEVELOPMENT Totals
EXPENSE TOTALS
Fund 210 - SPECIAL SERVICE AREA (SSA) #9 Totals
REVENUE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
2,758,514.00 62,299.16 859,467.47 1,899,046.53 31 1,698,645.65
$2,758,514.00 $62,299.16 $859,467.47 $1,899,046.53 31% $1,698,645.65
$2,758,514.00 $62,299.16 $859,467.47 $1,899,046.53 31% $1,698,645.65
319,997.01 35,759.02 295,244.11 24,752.90 92 365,979.08
506,200.00 17,632.78 22,551.56 483,648.44 4 71,266.08
.00 .00 127,730.49 (127,730.49) +++ 607,132.53
150,000.00 143,256.18 281,264.73 (131,264.73) 188 292,237.53
80,000.00 35,192.95 420,221.11 (340,221.11) 525 282,315.50
1,700,000.00 12,631.68 44,363.17 1,655,636.83 3 70,077.60
.00 .00 .00 .00 +++ 12,111.33
$2,756,197.01 $244,472.61 $1,191,375.17 $1,564,821.84 43% $1,701,119.65
$2,756,197.01 $244,472.61 $1,191,375.17 $1,564,821.84 43% $1,701,119.65
2,758,514.00 62,299.16 859,467.47 1,899,046.53 31% 1,698,645.65
2,756,197.01 244,472.61 1,191,375.17 1,564,821.84 43% 1,701,119.65
$2,316.99 ($182,173.45) ($331,907.70) ($334,224.69) (14,325%) ($2,474.00)
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 215 - CDBG FUND
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Intergovernmental Revenue
Department 21 - COMMUNITY DEVELOPMENT Totals
REVENUE TOTALS
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Salary and Benefits
Services and Supplies
Capital Outlay
Insurance and Other Chargebacks
Community Sponsored Organizations
Miscellaneous
Interfund Transfers
EXPENSE TOTALS
Fund 215 - CDBG FUND Net Gain (Loss)
Department 21 - COMMUNITY DEVELOPMENT Totals
EXPENSE TOTALS
Fund 215 - CDBG FUND Totals
REVENUE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
110,000.00 3,082.00 102,537.92 7,462.08 93 74,015.96
.00 34.05 648.59 (648.59) +++ 2,387.91
$110,000.00 $3,116.05 $103,186.51 $6,813.49 94% $76,403.87
$110,000.00 $3,116.05 $103,186.51 $6,813.49 94% $76,403.87
175,000.00 16,710.00 16,710.00 158,290.00 10 120,955.83
.00 .00 .00 .00 +++ 8.50
$175,000.00 $16,710.00 $16,710.00 $158,290.00 10% $120,964.33
$175,000.00 $16,710.00 $16,710.00 $158,290.00 10% $120,964.33
110,000.00 3,116.05 103,186.51 6,813.49 94% 76,403.87
175,000.00 16,710.00 16,710.00 158,290.00 10% 120,964.33
($65,000.00) ($13,593.95) $86,476.51 $151,476.51 (133%) ($44,560.46)
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 220 - CDBG LOAN FUND
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Other Revenue
Interest Income
Department 21 - COMMUNITY DEVELOPMENT Totals
REVENUE TOTALS
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies
REVENUE TOTALS
EXPENSE TOTALS
Fund 220 - CDBG LOAN FUND Net Gain (Loss)
Miscellaneous
Department 21 - COMMUNITY DEVELOPMENT Totals
EXPENSE TOTALS
Fund 220 - CDBG LOAN FUND Totals
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
.00 .89 19.64 (19.64) +++ 334.15
$0.00 $0.89 $19.64 ($19.64) +++ $334.15
$0.00 $0.89 $19.64 ($19.64) +++ $334.15
.00 .61 9.24 (9.24) +++ 77.70
.00 .00 .00 .00 +++ 150,000.00
$0.00 $0.61 $9.24 ($9.24) +++ $150,077.70
$0.00 $0.61 $9.24 ($9.24) +++ $150,077.70
.00 .89 19.64 (19.64) +++ 334.15
.00 .61 9.24 (9.24) +++ 150,077.70
$0.00 $0.28 $10.40 $10.40 +++ ($149,743.55)
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 235 - NEIGHBORHOOD IMPROVEMENT
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Interest Income
Department 21 - COMMUNITY DEVELOPMENT Totals
REVENUE TOTALS
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies
Interfund Transfers
EXPENSE TOTALS
Fund 235 - NEIGHBORHOOD IMPROVEMENT Net Gain (Loss)
Department 21 - COMMUNITY DEVELOPMENT Totals
EXPENSE TOTALS
Fund 235 - NEIGHBORHOOD IMPROVEMENT Totals
REVENUE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
.00 .00 .00 .00 +++ 31,207.45
540,453.00 .00 311,835.68 228,617.32 58 427,547.16
25,000.00 .00 29,109.41 (4,109.41) 116 12,333.55
150.00 9.44 66.94 83.06 45 114.73
$565,603.00 $9.44 $341,012.03 $224,590.97 60% $471,202.89
$565,603.00 $9.44 $341,012.03 $224,590.97 60% $471,202.89
63,875.72 3,409.71 53,138.47 10,737.25 83 12,520.85
500,565.00 5.24 297,615.62 202,949.38 59 411,196.39
.00 (2,309.97) (2,741.11) 2,741.11 +++ 25,398.32
500.00 .00 101.50 398.50 20 47.85
$564,940.72 $1,104.98 $348,114.48 $216,826.24 62% $449,163.41
$564,940.72 $1,104.98 $348,114.48 $216,826.24 62% $449,163.41
565,603.00 9.44 341,012.03 224,590.97 60% 471,202.89
564,940.72 1,104.98 348,114.48 216,826.24 62% 449,163.41
$662.28 ($1,095.54) ($7,102.45) ($7,764.73) (1,072%) $22,039.48
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 240 - HOME FUND
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Charges for Services
Intergovernmental Revenue
Other Revenue
Interest Income
Department 21 - COMMUNITY DEVELOPMENT Totals
REVENUE TOTALS
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Salary and Benefits
Services and Supplies
Insurance and Other Chargebacks
Miscellaneous
EXPENSE TOTALS
Fund 240 - HOME FUND Net Gain (Loss)
Department 21 - COMMUNITY DEVELOPMENT Totals
EXPENSE TOTALS
Fund 240 - HOME FUND Totals
REVENUE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
75,000.00 .00 15,453.00 59,547.00 21 76,650.00
658,000.00 44,328.15 325,181.03 332,818.97 49 255,299.89
175,600.00 .00 96,666.69 78,933.31 55 655,416.71
5,700.00 880.25 6,901.98 (1,201.98) 121 27,280.46
$914,300.00 $45,208.40 $444,202.70 $470,097.30 49% $1,014,647.06
$914,300.00 $45,208.40 $444,202.70 $470,097.30 49% $1,014,647.06
202,683.56 15,586.84 148,429.15 54,254.41 73 118,297.21
2,031,050.00 4,403.01 1,225,542.96 805,507.04 60 398,862.20
10,000.00 .00 4,200.00 5,800.00 42 2,800.00
17,000.00 (20,162.42) (47,471.04) 64,471.04 (279) (34,214.97)
166,000.00 4,980.73 311,343.06 (145,343.06) 188 246,094.03
102,510.00 348.00 17,250.66 85,259.34 17 406,628.08
$2,529,243.56 $5,156.16 $1,659,294.79 $869,948.77 66% $1,138,466.55
$2,529,243.56 $5,156.16 $1,659,294.79 $869,948.77 66% $1,138,466.55
914,300.00 45,208.40 444,202.70 470,097.30 49% 1,014,647.06
2,529,243.56 5,156.16 1,659,294.79 869,948.77 66% 1,138,466.55
($1,614,943.56) $40,052.24 ($1,215,092.09) $399,851.47 75% ($123,819.49)
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 250 - AFFORDABLE HOUSING FUND
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Other Taxes
Intergovernmental Revenue
Other Revenue
Interest Income
Department 21 - COMMUNITY DEVELOPMENT Totals
REVENUE TOTALS
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Salary and Benefits
Services and Supplies
Capital Outlay
Insurance and Other Chargebacks
Community Sponsored Organizations
Miscellaneous
Department 21 - COMMUNITY DEVELOPMENT Totals
EXPENSE TOTALS
Fund 250 - AFFORDABLE HOUSING FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 250 - AFFORDABLE HOUSING FUND Net Gain (Loss)
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
482,243.00 .00 482,243.00 .00 100 480,145.00
$482,243.00 $0.00 $482,243.00 $0.00 100% $480,145.00
$482,243.00 $0.00 $482,243.00 $0.00 100% $480,145.00
482,243.00 .00 124,950.26 357,292.74 26 438,095.05
$482,243.00 $0.00 $124,950.26 $357,292.74 26% $438,095.05
.00 .00 .00 .00 +++ 42,049.00
$0.00 $0.00 $0.00 $0.00 +++ $42,049.00
$482,243.00 $0.00 $124,950.26 $357,292.74 26% $480,144.05
482,243.00 .00 482,243.00 .00 100% 480,145.00
482,243.00 .00 124,950.26 357,292.74 26% 480,144.05
$0.00 $0.00 $357,292.74 $357,292.74 +++ $0.95
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 186 - LIBRARY DEBT SERVICE FUND
REVENUE
Department 48 - LIBRARY
Property Taxes
Department 48 - LIBRARY Totals
REVENUE TOTALS
EXPENSE
Department 48 - LIBRARY
Debt Service
Department 48 - LIBRARY Totals
Fund 186 - LIBRARY DEBT SERVICE FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 186 - LIBRARY DEBT SERVICE FUND Net Gain (Loss)
Department 99 - NON-DEPARTMENTAL
Debt Service
Department 99 - NON-DEPARTMENTAL Totals
EXPENSE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
968,000.00 533,950.11 1,259,481.41 (291,481.41) 130 1,227,407.93
5,366.00 3,947.23 19,039.95 (13,673.95) 355 20,631.95
400.00 949.79 5,611.36 (5,211.36) 1,403 12,998.83
$973,766.00 $538,847.13 $1,284,132.72 ($310,366.72) 132% $1,261,038.71
$973,766.00 $538,847.13 $1,284,132.72 ($310,366.72) 132% $1,261,038.71
335,000.00 124.20 154,419.86 180,580.14 46 352,868.87
500,000.00 391,989.20 391,989.20 108,010.80 78 382,140.14
.00 .00 .00 .00 +++ 731.37
218,113.00 18,176.00 181,760.00 36,353.00 83 314,020.09
$1,053,113.00 $410,289.40 $728,169.06 $324,943.94 69% $1,049,760.47
$1,053,113.00 $410,289.40 $728,169.06 $324,943.94 69% $1,049,760.47
973,766.00 538,847.13 1,284,132.72 (310,366.72) 132% 1,261,038.71
1,053,113.00 410,289.40 728,169.06 324,943.94 69% 1,049,760.47
($79,347.00) $128,557.73 $555,963.66 $635,310.66 (701%) $211,278.24
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 330 - HOWARD-RIDGE TIF FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes
Other Revenue
Interest Income
Department 99 - NON-DEPARTMENTAL Totals
REVENUE TOTALS
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies
Capital Outlay
Miscellaneous
Interfund Transfers
Department 99 - NON-DEPARTMENTAL Totals
Fund 330 - HOWARD-RIDGE TIF FUND Net Gain (Loss)
EXPENSE TOTALS
Fund 330 - HOWARD-RIDGE TIF FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
1,237,000.00 398,185.77 1,770,998.11 (533,998.11) 143 1,697,958.33
11,000.00 .00 171,504.26 (160,504.26) 1,559 10,282.60
4,000.00 365.36 4,287.90 (287.90) 107 6,070.52
$1,252,000.00 $398,551.13 $1,946,790.27 ($694,790.27) 155% $1,714,311.45
$1,252,000.00 $398,551.13 $1,946,790.27 ($694,790.27) 155% $1,714,311.45
5,000.00 16,132.20 66,821.11 (61,821.11) 1,336 787.35
500,000.00 .00 332,637.00 167,363.00 67 111,700.00
200,000.00 .00 .00 200,000.00 0 382,670.00
75,000.00 6,250.00 62,500.00 12,500.00 83 135,000.00
$780,000.00 $22,382.20 $461,958.11 $318,041.89 59% $630,157.35
$780,000.00 $22,382.20 $461,958.11 $318,041.89 59% $630,157.35
1,252,000.00 398,551.13 1,946,790.27 (694,790.27) 155% 1,714,311.45
780,000.00 22,382.20 461,958.11 318,041.89 59% 630,157.35
$472,000.00 $376,168.93 $1,484,832.16 $1,012,832.16 315% $1,084,154.10
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 335 - WEST EVANSTON TIF FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes
Other Revenue
Interest Income
Department 99 - NON-DEPARTMENTAL Totals
REVENUE TOTALS
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies
Capital Outlay
Miscellaneous
Interfund Transfers
Department 99 - NON-DEPARTMENTAL Totals
Fund 335 - WEST EVANSTON TIF FUND Net Gain (Loss)
EXPENSE TOTALS
Fund 335 - WEST EVANSTON TIF FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
147,000.00 143,692.71 282,948.21 (135,948.21) 192 170,306.49
.00 .00 .00 .00 +++ 100,000.00
.00 34.59 411.87 (411.87) +++ 795.89
$147,000.00 $143,727.30 $283,360.08 ($136,360.08) 193% $271,102.38
$147,000.00 $143,727.30 $283,360.08 ($136,360.08) 193% $271,102.38
2,000.00 .20 464.83 1,535.17 23 772.52
168,923.00 14,077.00 140,770.00 28,153.00 83 165,870.00
$170,923.00 $14,077.20 $141,234.83 $29,688.17 83% $166,642.52
$170,923.00 $14,077.20 $141,234.83 $29,688.17 83% $166,642.52
147,000.00 143,727.30 283,360.08 (136,360.08) 193% 271,102.38
170,923.00 14,077.20 141,234.83 29,688.17 83% 166,642.52
($23,923.00) $129,650.10 $142,125.25 $166,048.25 (594%) $104,459.86
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 340 - DEMPSTER-DODGE TIF FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes
Interfund Transfers
Interest Income
Department 99 - NON-DEPARTMENTAL Totals
REVENUE TOTALS
EXPENSE
Department 99 - NON-DEPARTMENTAL
Fund 340 - DEMPSTER-DODGE TIF FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 340 - DEMPSTER-DODGE TIF FUND Net Gain (Loss)
Services and Supplies
Interfund Transfers
Department 99 - NON-DEPARTMENTAL Totals
EXPENSE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
879,000.00 249,088.95 1,133,475.71 (254,475.71) 129 1,145,554.72
1,130,000.00 .00 .00 1,130,000.00 0 .00
.00 148.31 2,389.76 (2,389.76) +++ 5,057.19
$2,009,000.00 $249,237.26 $1,135,865.47 $873,134.53 57% $1,150,611.91
$2,009,000.00 $249,237.26 $1,135,865.47 $873,134.53 57% $1,150,611.91
5,000.00 .87 476.85 4,523.15 10 785.07
1,130,000.00 232,396.23 1,155,641.32 (25,641.32) 102 251,298.71
262,843.00 21,904.00 219,040.00 43,803.00 83 260,610.00
$1,397,843.00 $254,301.10 $1,375,158.17 $22,684.83 98% $512,693.78
$1,397,843.00 $254,301.10 $1,375,158.17 $22,684.83 98% $512,693.78
2,009,000.00 249,237.26 1,135,865.47 873,134.53 57% 1,150,611.91
1,397,843.00 254,301.10 1,375,158.17 22,684.83 98% 512,693.78
$611,157.00 ($5,063.84) ($239,292.70) ($850,449.70) (39%) $637,918.13
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 345 - CHICAGO-MAIN TIF
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes
Other Revenue
Interest Income
Department 99 - NON-DEPARTMENTAL Totals
REVENUE TOTALS
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies
Capital Outlay
Interfund Transfers
Department 99 - NON-DEPARTMENTAL Totals
EXPENSE TOTALS
Fund 345 - CHICAGO-MAIN TIF Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 345 - CHICAGO-MAIN TIF Net Gain (Loss)
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
221,000.00 156,659.25 220,256.16 743.84 100 224,827.08
500.00 7.52 14.80 485.20 3 315.81
$221,500.00 $156,666.77 $220,270.96 $1,229.04 99% $225,142.89
$221,500.00 $156,666.77 $220,270.96 $1,229.04 99% $225,142.89
221,500.00 .05 7,548.52 213,951.48 3 226,411.95
$221,500.00 $0.05 $7,548.52 $213,951.48 3% $226,411.95
$221,500.00 $0.05 $7,548.52 $213,951.48 3% $226,411.95
221,500.00 156,666.77 220,270.96 1,229.04 99% 225,142.89
221,500.00 .05 7,548.52 213,951.48 3% 226,411.95
$0.00 $156,666.72 $212,722.44 $212,722.44 +++ ($1,269.06)
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 350 - SPECIAL SERVICE AREA (SSA) #6
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes
Interest Income
Department 99 - NON-DEPARTMENTAL Totals
REVENUE TOTALS
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies
EXPENSE TOTALS
Fund 350 - SPECIAL SERVICE AREA (SSA) #6 Net Gain (Loss)
Department 99 - NON-DEPARTMENTAL Totals
EXPENSE TOTALS
Fund 350 - SPECIAL SERVICE AREA (SSA) #6 Totals
REVENUE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
154,800.00 47,567.60 139,121.00 15,679.00 90 141,256.43
.00 2.60 77.78 (77.78) +++ 91.37
$154,800.00 $47,570.20 $139,198.78 $15,601.22 90% $141,347.80
$154,800.00 $47,570.20 $139,198.78 $15,601.22 90% $141,347.80
115,000.00 .01 73,740.98 41,259.02 64 140,994.91
$115,000.00 $0.01 $73,740.98 $41,259.02 64% $140,994.91
$115,000.00 $0.01 $73,740.98 $41,259.02 64% $140,994.91
154,800.00 47,570.20 139,198.78 15,601.22 90% 141,347.80
115,000.00 .01 73,740.98 41,259.02 64% 140,994.91
$39,800.00 $47,570.19 $65,457.80 $25,657.80 164% $352.89
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 355 - SPECIAL SERVICE AREA (SSA) #7
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes
Interest Income
Department 99 - NON-DEPARTMENTAL Totals
REVENUE TOTALS
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies
EXPENSE TOTALS
Fund 355 - SPECIAL SERVICE AREA (SSA) #7 Net Gain (Loss)
Department 99 - NON-DEPARTMENTAL Totals
EXPENSE TOTALS
Fund 355 - SPECIAL SERVICE AREA (SSA) #7 Totals
REVENUE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
60,200.00 17,326.09 48,850.79 11,349.21 81 59,743.95
.00 1.77 11,196.72 (11,196.72) +++ 24.15
$60,200.00 $17,327.86 $60,047.51 $152.49 100% $59,768.10
$60,200.00 $17,327.86 $60,047.51 $152.49 100% $59,768.10
60,200.00 .01 30,893.11 29,306.89 51 58,722.29
$60,200.00 $0.01 $30,893.11 $29,306.89 51% $58,722.29
$60,200.00 $0.01 $30,893.11 $29,306.89 51% $58,722.29
60,200.00 17,327.86 60,047.51 152.49 100% 59,768.10
60,200.00 .01 30,893.11 29,306.89 51% 58,722.29
$0.00 $17,327.85 $29,154.40 $29,154.40 +++ $1,045.81
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 360 - SPECIAL SERVICE AREA (SSA) #8
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes
Interest Income
Department 99 - NON-DEPARTMENTAL Totals
REVENUE TOTALS
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies
Department 99 - NON-DEPARTMENTAL Totals
EXPENSE TOTALS
Fund 360 - SPECIAL SERVICE AREA (SSA) #8 Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 360 - SPECIAL SERVICE AREA (SSA) #8 Net Gain (Loss)
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
449,000.00 .00 .00 449,000.00 0 .00
$449,000.00 $0.00 $0.00 $449,000.00 0% $0.00
$449,000.00 $0.00 $0.00 $449,000.00 0% $0.00
449,000.00 .00 386,219.11 62,780.89 86 94,525.25
$449,000.00 $0.00 $386,219.11 $62,780.89 86% $94,525.25
$449,000.00 $0.00 $386,219.11 $62,780.89 86% $94,525.25
449,000.00 .00 .00 449,000.00 0% .00
449,000.00 .00 386,219.11 62,780.89 86% 94,525.25
$0.00 $0.00 ($386,219.11) ($386,219.11) +++ ($94,525.25)
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD
REVENUE
Department 48 - LIBRARY
Other Revenue
Department 48 - LIBRARY Totals
REVENUE TOTALS
EXPENSE
Department 48 - LIBRARY
Capital Outlay
Department 48 - LIBRARY Totals
Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD Net Gain (Loss)
EXPENSE TOTALS
Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD Totals
REVENUE TOTALS
EXPENSE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
13,936,263.00 3,657,877.32 14,232,476.59 (296,213.59) 102 12,814,108.59
1,197,401.00 99,785.00 997,850.00 199,551.00 83 3,319,053.04
.00 (1,155.57) 4,009,247.93 (4,009,247.93) +++ 12,054,284.90
1,500.00 1,240.13 8,480.02 (6,980.02) 565 24,864.03
$15,135,164.00 $3,757,746.88 $19,248,054.54 ($4,112,890.54) 127% $28,212,310.56
$15,135,164.00 $3,757,746.88 $19,248,054.54 ($4,112,890.54) 127% $28,212,310.56
.00 5.88 49,213.81 (49,213.81) +++ 133,807.04
15,133,666.00 .00 6,970,680.53 8,162,985.47 46 27,774,476.37
$15,133,666.00 $5.88 $7,019,894.34 $8,113,771.66 46% $27,908,283.41
$15,133,666.00 $5.88 $7,019,894.34 $8,113,771.66 46% $27,908,283.41
15,135,164.00 3,757,746.88 19,248,054.54 (4,112,890.54) 127% 28,212,310.56
15,133,666.00 5.88 7,019,894.34 8,113,771.66 46% 27,908,283.41
$1,498.00 $3,757,741.00 $12,228,160.20 $12,226,662.20 816,299% $304,027.15
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 320 - DEBT SERVICE FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes
Interfund Transfers
Other Revenue
Interest Income
Department 99 - NON-DEPARTMENTAL Totals
REVENUE TOTALS
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies
Debt Service
Department 99 - NON-DEPARTMENTAL Totals
EXPENSE TOTALS
Fund 320 - DEBT SERVICE FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 320 - DEBT SERVICE FUND Net Gain (Loss)
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
.00 79,313.39 184,675.70 (184,675.70) +++ .00
.00 .00 .00 .00 +++ 470,000.04
.00 .00 331,168.38 (331,168.38) +++ .00
7,645,000.00 .00 8,969,069.48 (1,324,069.48) 117 6,833,019.50
.00 1,719.62 10,639.78 (10,639.78) +++ 24,813.33
$7,645,000.00 $81,033.01 $9,495,553.34 ($1,850,553.34) 124% $7,327,832.87
.00 (3,313.92) (74,972.80) 74,972.80 +++ 18,170.77
.00 .00 892.68 (892.68) +++ 61,116.40
$0.00 ($3,313.92) ($74,080.12) $74,080.12 +++ $79,287.17
$7,645,000.00 $77,719.09 $9,421,473.22 ($1,776,473.22) 123% $7,407,120.04
696,766.01 77,003.84 580,269.11 116,496.90 83 676,147.47
.00 184,325.11 1,394,023.76 (1,394,023.76) +++ 1,564,539.87
9,705,000.00 1,078,830.00 3,881,149.35 5,823,850.65 40 7,018,081.23
$10,401,766.01 $1,340,158.95 $5,855,442.22 $4,546,323.79 56% $9,258,768.57
.00 .00 .00 .00 +++ 85.00
.00 .00 .00 .00 +++ 290,000.00
$0.00 $0.00 $0.00 $0.00 +++ $290,085.00
$10,401,766.01 $1,340,158.95 $5,855,442.22 $4,546,323.79 56% $9,548,853.57
7,645,000.00 77,719.09 9,421,473.22 (1,776,473.22) 123% 7,407,120.04
10,401,766.01 1,340,158.95 5,855,442.22 4,546,323.79 56% 9,548,853.57
($2,756,766.01) ($1,262,439.86) $3,566,031.00 $6,322,797.01 (129%) ($2,141,733.53)
Fund 415 - CAPITAL IMPROVEMENTS FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 415 - CAPITAL IMPROVEMENTS FUND Net Gain (Loss)
Department 99 - NON-DEPARTMENTAL
Services and Supplies
Interfund Transfers
Department 99 - NON-DEPARTMENTAL Totals
EXPENSE TOTALS
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits
Services and Supplies
Capital Outlay
Department 40 - PUBLIC WORKS AGENCY Totals
Other Revenue
Interest Income
Department 99 - NON-DEPARTMENTAL Totals
REVENUE TOTALS
EXPENSE
Intergovernmental Revenue
Other Revenue
Interest Income
Department 40 - PUBLIC WORKS AGENCY Totals
Department 99 - NON-DEPARTMENTAL
Fund 415 - CAPITAL IMPROVEMENTS FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Charges for Services
Interfund Transfers
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
.00 .00 .00 .00 +++ 2,000,000.00
.00 .00 1,000,000.00 (1,000,000.00) +++ .00
1,000,000.00 .00 2,200,000.00 (1,200,000.00) 220 2,037,500.00
.00 998.91 10,218.44 (10,218.44) +++ 90,687.56
$1,000,000.00 $998.91 $3,210,218.44 ($2,210,218.44) 321% $4,128,187.56
$1,000,000.00 $998.91 $3,210,218.44 ($2,210,218.44) 321% $4,128,187.56
.00 5.00 6,319.13 (6,319.13) +++ 333,461.83
1,000,000.00 131,596.00 1,738,582.39 (738,582.39) 174 8,172,492.39
637,500.00 .00 .00 637,500.00 0 637,500.00
$1,637,500.00 $131,601.00 $1,744,901.52 ($107,401.52) 107% $9,143,454.22
$1,637,500.00 $131,601.00 $1,744,901.52 ($107,401.52) 107% $9,143,454.22
1,000,000.00 998.91 3,210,218.44 (2,210,218.44) 321% 4,128,187.56
1,637,500.00 131,601.00 1,744,901.52 (107,401.52) 107% 9,143,454.22
($637,500.00) ($130,602.09) $1,465,316.92 $2,102,816.92 (230%) ($5,015,266.66)
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 416 - CROWN CONSTRUCTION FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Interfund Transfers
Intergovernmental Revenue
Other Revenue
Interest Income
Department 40 - PUBLIC WORKS AGENCY Totals
REVENUE TOTALS
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Services and Supplies
Capital Outlay
Interfund Transfers
Department 40 - PUBLIC WORKS AGENCY Totals
Fund 416 - CROWN CONSTRUCTION FUND Net Gain (Loss)
EXPENSE TOTALS
Fund 416 - CROWN CONSTRUCTION FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
175,000.00 14,583.00 145,830.00 29,170.00 83 175,000.00
$175,000.00 $14,583.00 $145,830.00 $29,170.00 83% $175,000.00
$175,000.00 $14,583.00 $145,830.00 $29,170.00 83% $175,000.00
175,000.00 14,583.00 145,830.00 29,170.00 83% 175,000.00
.00 .00 .00 .00 +++ .00
$175,000.00 $14,583.00 $145,830.00 ($29,170.00) 83% $175,000.00
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 417 - CROWN COMMUNITY CTR MAINTENANCE
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Interfund Transfers
Department 40 - PUBLIC WORKS AGENCY Totals
Fund 417 - CROWN COMMUNITY CTR MAINTENANCE Net Gain (Loss)
REVENUE TOTALS
Fund 417 - CROWN COMMUNITY CTR MAINTENANCE Totals
REVENUE TOTALS
EXPENSE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
125,000.00 .00 61,249.68 63,750.32 49 168,414.88
.00 .00 (1,109.75) 1,109.75 +++ .00
30,000.00 896.85 12,899.28 17,100.72 43 35,236.30
$155,000.00 $896.85 $73,039.21 $81,960.79 47% $203,651.18
$155,000.00 $896.85 $73,039.21 $81,960.79 47% $203,651.18
.00 5.00 50.00 (50.00) +++ 60.00
.00 .00 .00 .00 +++ .00
.00 .00 .00 .00 +++ 477,930.00
$0.00 $5.00 $50.00 ($50.00) +++ $477,990.00
500,000.00 .00 .00 500,000.00 0 .00
489,314.00 40,777.00 407,770.00 81,544.00 83 .00
$989,314.00 $40,777.00 $407,770.00 $581,544.00 41% $0.00
$989,314.00 $40,782.00 $407,820.00 $581,494.00 41% $477,990.00
155,000.00 896.85 73,039.21 81,960.79 47% 203,651.18
989,314.00 40,782.00 407,820.00 581,494.00 41% 477,990.00
($834,314.00) ($39,885.15) ($334,780.79) $499,533.21 40% ($274,338.82)
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 420 - SPECIAL ASSESSMENT FUND
REVENUE
Department 26 - PUBLIC WORKS
Other Taxes
Other Revenue
Interest Income
Department 26 - PUBLIC WORKS Totals
REVENUE TOTALS
EXPENSE
Department 26 - PUBLIC WORKS
Services and Supplies
Capital Outlay
Interfund Transfers
Department 26 - PUBLIC WORKS Totals
Department 40 - PUBLIC WORKS AGENCY
Capital Outlay
Interfund Transfers
Department 40 - PUBLIC WORKS AGENCY Totals
EXPENSE TOTALS
Fund 420 - SPECIAL ASSESSMENT FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 420 - SPECIAL ASSESSMENT FUND Net Gain (Loss)
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
.00 .00 375.00 (375.00) +++ 75.00
10,133,725.00 673,270.17 6,560,761.53 3,572,963.47 65 6,937,516.53
.00 .00 .00 .00 +++ 140,907.09
.00 .00 950,000.00 (950,000.00) +++ .00
1,404,700.00 38,678.73 327,865.58 1,076,834.42 23 348,622.73
20,000.00 3,501.15 18,629.59 1,370.41 93 53,583.60
$11,558,425.00 $715,450.05 $7,857,631.70 $3,700,793.30 68% $7,480,704.95
.00 .00 .00 .00 +++ 2,831.29
$0.00 $0.00 $0.00 $0.00 +++ $2,831.29
$11,558,425.00 $715,450.05 $7,857,631.70 $3,700,793.30 68% $7,483,536.24
255,033.38 29,671.94 196,100.54 58,932.84 77 270,658.21
$255,033.38 $29,671.94 $196,100.54 $58,932.84 77% $270,658.21
693,477.26 72,133.25 596,619.29 96,857.97 86 764,801.44
4,484,316.00 350,225.89 3,114,146.21 1,370,169.79 69 3,970,535.24
1,750,000.00 114.06 141,787.63 1,608,212.37 8 8,004.00
351,502.00 29,292.00 292,920.00 58,582.00 83 350,666.04
.00 .00 .00 .00 +++ 2,899,592.72
47,164.00 .00 28,215.00 18,949.00 60 11,644.07
$487,451.58 $54,593.85 $427,519.21 $59,932.37 88% $546,492.30
$11,251,334.22 $797,062.99 $7,407,627.88 $3,843,706.34 66% $13,454,301.02
11,558,425.00 715,450.05 7,857,631.70 3,700,793.30 68% 7,483,536.24
11,251,334.22 797,062.99 7,407,627.88 3,843,706.34 66% 13,454,301.02
$307,090.78 ($81,612.94) $450,003.82 $142,913.04 147% ($5,970,764.78)
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 505 - PARKING SYSTEM FUND
REVENUE
Department 19 - ADMINISTRATIVE SERVICES
Licenses, Permits and Fees
Charges for Services
Interfund Transfers
Intergovernmental Revenue
Other Revenue
Interest Income
Department 19 - ADMINISTRATIVE SERVICES Totals
Department 40 - PUBLIC WORKS AGENCY
Other Revenue
Department 40 - PUBLIC WORKS AGENCY Totals
REVENUE TOTALS
EXPENSE
Department 15 - CITY MANAGER'S OFFICE
Salary and Benefits
Department 15 - CITY MANAGER'S OFFICE Totals
Department 19 - ADMINISTRATIVE SERVICES
Salary and Benefits
Services and Supplies
Capital Outlay
Insurance and Other Chargebacks
Depreciation Expense
Debt Service
REVENUE TOTALS
EXPENSE TOTALS
Fund 505 - PARKING SYSTEM FUND Net Gain (Loss)
Department 40 - PUBLIC WORKS AGENCY Totals
EXPENSE TOTALS
Fund 505 - PARKING SYSTEM FUND Totals
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
50,000.00 14,955.00 62,408.90 (12,408.90) 125 61,116.67
23,006,700.00 1,620,694.87 16,979,576.24 6,027,123.76 74 23,591,431.45
.00 .00 3,000,000.00 (3,000,000.00) +++ .00
19,629,150.00 151,048.74 2,278,570.98 17,350,579.02 12 298,660.82
70,000.00 2,252.96 36,898.35 33,101.65 53 71,542.67
$42,755,850.00 $1,788,951.57 $22,357,454.47 $20,398,395.53 52% $24,022,751.61
.00 .00 2,772,225.94 (2,772,225.94) +++ 143,910.27
$0.00 $0.00 $2,772,225.94 ($2,772,225.94) +++ $143,910.27
$42,755,850.00 $1,788,951.57 $25,129,680.41 $17,626,169.59 59% $24,166,661.88
5,927,918.46 611,642.09 4,792,794.36 1,135,124.10 81 5,618,144.35
4,793,710.00 346,118.66 2,468,601.00 2,325,109.00 51 3,212,472.18
24,200.00 21,950.00 21,950.00 2,250.00 91 .00
.00 3,612.96 18,580.92 (18,580.92) +++ .00
.00 .00 .00 .00 +++ 2,865,860.20
1,000.00 .00 .00 1,000.00 0 .00
15,000.00 .00 8,580.19 6,419.81 57 300.00
180,000.00 15,000.00 150,000.00 30,000.00 83 11,418,966.32
$10,941,828.46 $998,323.71 $7,460,506.47 $3,481,321.99 68% $23,115,743.05
$18,849,334.46 $1,497,844.12 $16,254,335.19 $2,594,999.27 86% $29,397,422.67
42,755,850.00 1,788,951.57 25,129,680.41 17,626,169.59 59% 24,166,661.88
18,849,334.46 1,497,844.12 16,254,335.19 2,594,999.27 86% 29,397,422.67
$23,906,515.54 $291,107.45 $8,875,345.22 ($15,031,170.32) 37% ($5,230,760.79)
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 510 - WATER FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Licenses, Permits and Fees
Charges for Services
Intergovernmental Revenue
Other Revenue
Interest Income
Department 40 - PUBLIC WORKS AGENCY Totals
Department 71 - UTILITIES
Other Revenue
Department 71 - UTILITIES Totals
REVENUE TOTALS
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits
Services and Supplies
Capital Outlay
Insurance and Other Chargebacks
Depreciation Expense
Contingencies
Miscellaneous
Interfund Transfers
Department 40 - PUBLIC WORKS AGENCY Totals
Department 71 - UTILITIES
EXPENSE TOTALS
Fund 510 - WATER FUND Net Gain (Loss)
EXPENSE TOTALS
Fund 510 - WATER FUND Totals
REVENUE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
1,500,000.00 21,114.62 207,967.22 1,292,032.78 14 1,060.49
24,068,000.00 864,374.60 6,421,611.62 17,646,388.38 27 420,882.76
.00 .00 .00 .00 +++ (11,246,385.32)
$25,568,000.00 $885,489.22 $6,629,578.84 $18,938,421.16 26% ($10,824,442.07)
$25,568,000.00 $885,489.22 $6,629,578.84 $18,938,421.16 26% ($10,824,442.07)
.00 .00 .00 .00 +++ .00
25,568,000.00 885,489.22 6,629,578.84 18,938,421.16 26% (10,824,442.07)
($25,568,000.00) ($885,489.22) ($6,629,578.84) $18,938,421.16 26% $10,824,442.07
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 513 - WATER DEPR IMPRV &EXTENSION FUND
EXPENSE
Department 71 - UTILITIES
Services and Supplies
Capital Outlay
REVENUE TOTALS
EXPENSE TOTALS
Fund 513 - WATER DEPR IMPRV &EXTENSION FUND Net Gain (Loss)
Interfund Transfers
Department 71 - UTILITIES Totals
EXPENSE TOTALS
Fund 513 - WATER DEPR IMPRV &EXTENSION FUND Totals
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
10,375,408.00 690,552.74 8,395,876.80 1,979,531.20 81 10,242,065.74
2,001,000.00 (2,942.78) (5,386.53) 2,006,386.53 (0) 385,501.29
25,000.00 369.60 3,495.74 21,504.26 14 15,110.87
$12,401,408.00 $687,979.56 $8,393,986.01 $4,007,421.99 68% $10,642,677.90
.00 .00 .00 .00 +++ 47,866.81
$0.00 $0.00 $0.00 $0.00 +++ $47,866.81
$12,401,408.00 $687,979.56 $8,393,986.01 $4,007,421.99 68% $10,690,544.71
1,425,265.69 150,799.62 1,116,430.83 308,834.86 78 1,332,414.71
1,484,650.00 243,777.77 921,571.54 563,078.46 62 394,477.24
3,343,000.00 2,750.62 120,194.64 3,222,805.36 4 .00
332,255.00 27,688.00 276,880.00 55,375.00 83 306,557.04
.00 .00 .00 .00 +++ 3,773,558.96
1,500.00 .00 500.00 1,000.00 33 1,456.21
855,375.00 71,282.00 712,820.00 142,555.00 83 1,337,532.00
$7,442,045.69 $496,298.01 $3,148,397.01 $4,293,648.68 42% $7,145,996.16
.00 .00 .00 .00 +++ 60,949.08
5,195,191.00 367,255.78 3,841,138.54 1,354,052.46 74 726,343.24
$5,195,191.00 $367,255.78 $3,841,138.54 $1,354,052.46 74% $787,292.32
$12,637,236.69 $863,553.79 $6,989,535.55 $5,647,701.14 55% $7,933,288.48
12,401,408.00 687,979.56 8,393,986.01 4,007,421.99 68% 10,690,544.71
12,637,236.69 863,553.79 6,989,535.55 5,647,701.14 55% 7,933,288.48
($235,828.69) ($175,574.23) $1,404,450.46 $1,640,279.15 (596%) $2,757,256.23Fund 515 - SEWER FUND Net Gain (Loss)
EXPENSE TOTALS
Fund 515 - SEWER FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Department 40 - PUBLIC WORKS AGENCY Totals
Department 71 - UTILITIES
Salary and Benefits
Debt Service
Department 71 - UTILITIES Totals
Capital Outlay
Insurance and Other Chargebacks
Depreciation Expense
Miscellaneous
Interfund Transfers
REVENUE TOTALS
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits
Services and Supplies
Interest Income
Department 40 - PUBLIC WORKS AGENCY Totals
Department 71 - UTILITIES
Other Revenue
Department 71 - UTILITIES Totals
Fund 515 - SEWER FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Charges for Services
Other Revenue
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
.00 250.00 2,071.00 (2,071.00) +++ 2,184.00
$0.00 $250.00 $2,071.00 ($2,071.00) +++ $2,184.00
1,332,500.00 .00 1,332,500.00 .00 100 1,332,500.00
297,000.00 378.00 212,375.42 84,624.58 72 298,870.04
4,516,450.00 373,597.91 3,471,096.83 1,045,353.17 77 4,245,578.25
122,000.00 30,505.08 132,133.96 (10,133.96) 108 71,739.00
$6,267,950.00 $404,480.99 $5,148,106.21 $1,119,843.79 82% $5,948,687.29
$6,267,950.00 $404,730.99 $5,150,177.21 $1,117,772.79 82% $5,950,871.29
1,405,702.00 167,050.81 1,206,512.40 199,189.60 86 1,333,777.77
3,778,926.00 328,603.78 2,933,949.93 844,976.07 78 3,519,042.76
505,000.00 5,193.34 421,168.81 83,831.19 83 104,512.20
.00 .00 .00 .00 +++ 41,124.85
10,000.00 .00 7,534.40 2,465.60 75 8,143.41
302,000.00 25,167.00 251,670.00 50,330.00 83 322,362.00
$6,001,628.00 $526,014.93 $4,820,835.54 $1,180,792.46 80% $5,328,962.99
.00 .00 .00 .00 +++ (13,022.26)
$0.00 $0.00 $0.00 $0.00 +++ ($13,022.26)
$6,001,628.00 $526,014.93 $4,820,835.54 $1,180,792.46 80% $5,315,940.73
6,267,950.00 404,730.99 5,150,177.21 1,117,772.79 82% 5,950,871.29
6,001,628.00 526,014.93 4,820,835.54 1,180,792.46 80% 5,315,940.73
$266,322.00 ($121,283.94) $329,341.67 $63,019.67 124% $634,930.56
Fund 520 - SOLID WASTE FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 520 - SOLID WASTE FUND Net Gain (Loss)
Department 40 - PUBLIC WORKS AGENCY Totals
Department 71 - UTILITIES
Salary and Benefits
Department 71 - UTILITIES Totals
EXPENSE TOTALS
Services and Supplies
Capital Outlay
Depreciation Expense
Miscellaneous
Interfund Transfers
Department 40 - PUBLIC WORKS AGENCY Totals
REVENUE TOTALS
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits
Department 40 - PUBLIC WORKS AGENCY
Property Taxes
Licenses, Permits and Fees
Charges for Services
Other Revenue
Fund 520 - SOLID WASTE FUND
REVENUE
Department 26 - PUBLIC WORKS
Charges for Services
Department 26 - PUBLIC WORKS Totals
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
3,127,440.00 258,953.00 2,589,530.00 537,910.00 83 3,070,014.00
69,000.00 .00 2,719.84 66,280.16 4 14,453.78
1,000.00 .00 .00 1,000.00 0 .00
$3,197,440.00 $258,953.00 $2,592,249.84 $605,190.16 81% $3,084,467.78
$3,197,440.00 $258,953.00 $2,592,249.84 $605,190.16 81% $3,084,467.78
1,148,166.41 139,249.92 957,068.82 191,097.59 83 1,134,913.86
2,034,507.00 113,262.81 1,416,935.46 617,571.54 70 1,316,444.13
.00 .00 20,127.72 (20,127.72) +++ 3.92
.00 .00 17,718.34 (17,718.34) +++ 7,999.49
.00 .00 .00 .00 +++ 900.00
$3,182,673.41 $252,512.73 $2,411,850.34 $770,823.07 76% $2,460,261.40
$3,182,673.41 $252,512.73 $2,411,850.34 $770,823.07 76% $2,460,261.40
3,197,440.00 258,953.00 2,592,249.84 605,190.16 81% 3,084,467.78
3,182,673.41 252,512.73 2,411,850.34 770,823.07 76% 2,460,261.40
$14,766.59 $6,440.27 $180,399.50 $165,632.91 1,222% $624,206.38
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Proprietary Funds
Fund Type Internal Service Funds
Fund 600 - FLEET SERVICES FUND
REVENUE
Department 19 - ADMINISTRATIVE SERVICES
Charges for Services
Other Revenue
Interest Income
Department 19 - ADMINISTRATIVE SERVICES Totals
REVENUE TOTALS
EXPENSE
Department 19 - ADMINISTRATIVE SERVICES
Salary and Benefits
Services and Supplies
Capital Outlay
Insurance and Other Chargebacks
Miscellaneous
EXPENSE TOTALS
Fund 600 - FLEET SERVICES FUND Net Gain (Loss)
Department 19 - ADMINISTRATIVE SERVICES Totals
EXPENSE TOTALS
Fund 600 - FLEET SERVICES FUND Totals
REVENUE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
224,885.00 18,739.00 187,390.00 37,495.00 83 1,479,425.00
.00 850,000.00 850,000.00 (850,000.00) +++ .00
1,060,217.00 .00 160,294.00 899,923.00 15 158,320.03
.00 .00 159.62 (159.62) +++ 432.99
$1,285,102.00 $868,739.00 $1,197,843.62 $87,258.38 93% $1,638,178.02
$1,285,102.00 $868,739.00 $1,197,843.62 $87,258.38 93% $1,638,178.02
.00 .00 69.90 (69.90) +++ 35,725.99
1,600,000.00 122,298.00 1,160,750.02 439,249.98 73 648,105.00
$1,600,000.00 $122,298.00 $1,160,819.92 $439,180.08 73% $683,830.99
.00 .00 .00 .00 +++ 1,532,788.60
$0.00 $0.00 $0.00 $0.00 +++ $1,532,788.60
$1,600,000.00 $122,298.00 $1,160,819.92 $439,180.08 73% $2,216,619.59
1,285,102.00 868,739.00 1,197,843.62 87,258.38 93% 1,638,178.02
1,600,000.00 122,298.00 1,160,819.92 439,180.08 73% 2,216,619.59
($314,898.00) $746,441.00 $37,023.70 $351,921.70 (12%) ($578,441.57)
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Proprietary Funds
Fund Type Internal Service Funds
Fund 601 - EQUIPMENT REPLACEMENT FUND
REVENUE
Department 19 - ADMINISTRATIVE SERVICES
Charges for Services
Intergovernmental Revenue
Other Revenue
Interest Income
Department 19 - ADMINISTRATIVE SERVICES Totals
REVENUE TOTALS
EXPENSE
Department 19 - ADMINISTRATIVE SERVICES
Services and Supplies
Capital Outlay
Department 19 - ADMINISTRATIVE SERVICES Totals
Department 26 - PUBLIC WORKS
REVENUE TOTALS
EXPENSE TOTALS
Fund 601 - EQUIPMENT REPLACEMENT FUND Net Gain (Loss)
Depreciation Expense
Department 26 - PUBLIC WORKS Totals
EXPENSE TOTALS
Fund 601 - EQUIPMENT REPLACEMENT FUND Totals
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
.00 .00 7,170.63 (7,170.63) +++ 247,262.46
.00 .00 .00 .00 +++ 2,000,000.00
10,402,039.00 830,597.66 8,381,601.35 2,020,437.65 81 9,707,994.97
1,475,000.00 123,062.09 1,224,132.92 250,867.08 83 2,876,171.13
8,890,677.00 754,059.88 7,524,245.79 1,366,431.21 85 6,492,580.46
$20,767,716.00 $1,707,719.63 $17,137,150.69 $3,630,565.31 83% $21,324,009.02
$20,767,716.00 $1,707,719.63 $17,137,150.69 $3,630,565.31 83% $21,324,009.02
662,619.98 64,121.85 510,814.45 151,805.53 77 618,397.39
2,914,200.00 77,401.49 1,595,671.12 1,318,528.88 55 3,465,872.47
16,641,267.00 1,316,899.23 13,239,982.99 3,401,284.01 80 14,110,030.08
.00 .00 .00 .00 +++ 300.00
$20,218,086.98 $1,458,422.57 $15,346,468.56 $4,871,618.42 76% $18,194,599.94
$20,218,086.98 $1,458,422.57 $15,346,468.56 $4,871,618.42 76% $18,194,599.94
20,767,716.00 1,707,719.63 17,137,150.69 3,630,565.31 83% 21,324,009.02
20,218,086.98 1,458,422.57 15,346,468.56 4,871,618.42 76% 18,194,599.94
$549,629.02 $249,297.06 $1,790,682.13 $1,241,053.11 326% $3,129,409.08
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Proprietary Funds
Fund Type Internal Service Funds
Fund 605 - INSURANCE FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Charges for Services
Interfund Transfers
Other Revenue
Workers Compensation and Liability
Insurance
Department 99 - NON-DEPARTMENTAL Totals
REVENUE TOTALS
EXPENSE
Department 99 - NON-DEPARTMENTAL
Salary and Benefits
Services and Supplies
Insurance and Other Chargebacks
Miscellaneous
Department 99 - NON-DEPARTMENTAL Totals
EXPENSE TOTALS
Fund 605 - INSURANCE FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 605 - INSURANCE FUND Net Gain (Loss)
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
11,815,000.00 6,229,498.14 18,660,237.00 (6,845,237.00) 158 19,601,260.66
2,500,000.00 153,955.37 1,782,092.26 717,907.74 71 2,174,018.22
$14,315,000.00 $6,383,453.51 $20,442,329.26 ($6,127,329.26) 143% $21,775,278.88
$14,315,000.00 $6,383,453.51 $20,442,329.26 ($6,127,329.26) 143% $21,775,278.88
10,805,300.00 882,222.92 8,907,032.67 1,898,267.33 82 10,399,738.82
225,000.00 18,376.10 165,694.26 59,305.74 74 148,468.04
$11,030,300.00 $900,599.02 $9,072,726.93 $1,957,573.07 82% $10,548,206.86
$11,030,300.00 $900,599.02 $9,072,726.93 $1,957,573.07 82% $10,548,206.86
14,315,000.00 6,383,453.51 20,442,329.26 (6,127,329.26) 143% 21,775,278.88
11,030,300.00 900,599.02 9,072,726.93 1,957,573.07 82% 10,548,206.86
$3,284,700.00 $5,482,854.49 $11,369,602.33 $8,084,902.33 346% $11,227,072.02
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Fiduciary Funds
Fund Type Pension Trust Funds
Fund 700 - FIRE PENSION FUND
REVENUE
Department 23 - FIRE MGMT & SUPPORT
Other Revenue
Interest Income
Department 23 - FIRE MGMT & SUPPORT Totals
REVENUE TOTALS
EXPENSE
Department 23 - FIRE MGMT & SUPPORT
Salary and Benefits
REVENUE TOTALS
EXPENSE TOTALS
Fund 700 - FIRE PENSION FUND Net Gain (Loss)
Miscellaneous
Department 23 - FIRE MGMT & SUPPORT Totals
EXPENSE TOTALS
Fund 700 - FIRE PENSION FUND Totals
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
18,214,700.00 10,298,891.09 32,414,149.66 (14,199,449.66) 178 28,106,377.21
1,500,000.00 101,981.00 2,624,734.69 (1,124,734.69) 175 2,579,448.58
$19,714,700.00 $10,400,872.09 $35,038,884.35 ($15,324,184.35) 178% $30,685,825.79
$19,714,700.00 $10,400,872.09 $35,038,884.35 ($15,324,184.35) 178% $30,685,825.79
14,326,000.00 1,194,586.05 12,547,750.67 1,778,249.33 88 13,459,230.47
375,000.00 60,399.15 325,951.10 49,048.90 87 399,999.29
$14,701,000.00 $1,254,985.20 $12,873,701.77 $1,827,298.23 88% $13,859,229.76
$14,701,000.00 $1,254,985.20 $12,873,701.77 $1,827,298.23 88% $13,859,229.76
19,714,700.00 10,400,872.09 35,038,884.35 (15,324,184.35) 178% 30,685,825.79
14,701,000.00 1,254,985.20 12,873,701.77 1,827,298.23 88% 13,859,229.76
$5,013,700.00 $9,145,886.89 $22,165,182.58 $17,151,482.58 442% $16,826,596.03
Income Statement
Through 10/31/21
Summary Listing
Classification
Fund Category Fiduciary Funds
Fund Type Pension Trust Funds
Fund 705 - POLICE PENSION FUND
REVENUE
Department 22 - POLICE
Other Revenue
Interest Income
Department 22 - POLICE Totals
REVENUE TOTALS
EXPENSE
Department 22 - POLICE
Salary and Benefits
Miscellaneous
Department 22 - POLICE Totals
EXPENSE TOTALS
Fund 705 - POLICE PENSION FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 705 - POLICE PENSION FUND Net Gain (Loss)