HomeMy WebLinkAbout2021.11 November Monthly Report
To: Kelley A. Gandurski, Interim City Manager
From: Hitesh Desai, CFO/City Treasurer
Subject: November 2021 Monthly Financial Report
Date: December 23, 2021
Please find attached the unaudited financial statements as of November 30, 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 115,257,679 102,510,053 12,747,626 30,213,893 26,570,859
170 American Rescue Plan 21,611,506 4,800,000 16,811,506 16,811,506 16,811,506
175 General Assistance 1,321,359 1,002,732 318,627 708,162 708,034
176 Health and Human Services 3,742,367 2,017,078 1,725,290 2,695,353 2,695,164
177 Reparations 33,311 1,922 31,389 249,531 249,531
180 Good Neighbor 1,000,849 449,489 551,360 902,178 902,178
185 Library 8,144,810 7,174,474 970,336 3,865,175 3,877,438
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,300,953 3,059,595 1,241,358 5,204,101 4,981,707
205 E911 1,205,386 1,162,882 42,505 1,432,135 3,049,434
210 Special Service Area (SSA) #9 603,035 595,125 7,910 (206,750) (206,750)
215 CDBG 1,193,907 1,432,888 (238,982) (178,159) (178,159)
220 CD Loan 172,545 44,370 128,175 311,000 311,000
235 Neighborhood Improvement 21 10 11 22,132 22,132
240 Home 366,440 369,809 (3,370) 26,195 26,195
250 Affordable Housing 583,117 1,685,078 (1,101,962) 2,699,821 857,410
320 Debt Service 19,422,156 7,026,197 12,395,959 13,117,418 13,117,418
330 Howard Ridge 1,288,525 746,346 542,179 2,878,222 2,860,663
335 West Evanston 1,951,000 468,213 1,482,787 3,277,417 3,277,417
340 Dempster-Dodge-TIF 283,444 155,312 128,132 340,395 340,395
345 Chicago Main-TIF 1,210,256 1,537,191 (326,935) 997,737 997,737
350 Special Service Area (SSA) #6 221,578 223,914 (2,336) 1,737 1,737
355 Special Service Area (SSA) #7 144,251 73,741 70,510 70,863 70,863
360 Special Service Area (SSA) #8 60,668 30,893 29,775 30,820 30,820
415 Capital Improvements 9,413,873 6,603,560 2,810,313 13,328,826 13,651,430
416 Crown Construction 3,811,195 1,753,782 2,057,413 4,688,297 5,976,554
417 Crown Community CTR Maintenance 160,413 - 160,413 335,413 335,413
420 Special Assessment 74,616 570,350 (495,733) 2,157,734 2,153,453
505 Parking 8,293,808 8,085,121 208,687 697,644 850,030
510 Water 26,861,526 24,661,440 2,200,086 13,109,633 15,415,538
515 Sewer 9,407,111 8,319,596 1,087,515 5,989,461 4,466,506
520 Solid Waste 5,811,440 5,065,853 745,587 595,262 (356,194)
600 Fleet 2,856,094 2,695,855 160,239 899,919 (451,343)
601 Equipment Replacement 1,216,611 1,412,784 (196,173) 327,371 327,371
605 Insurance 18,824,410 16,928,960 1,895,450 (6,568,239) (2,089,574)
Grand Total 271,332,503 213,175,782 58,156,721 122,288,379 122,910,087
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 November 30, 2021. Cash
balance represents liquid cash and/or invested assets which can be used (or easily sold) to support
and fund current operations. 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 November 30, 2021 with a fund
balance of $30,213,893 and cash balance of $26,570,859. The attached financials show General
Fund revenues at 104% of budget and expenses at 92% of budget against a target of 92%. 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 November 30. Expenses are on target for the eleven months
ended November 30, 2021.
Staff continues to monitor Police and Fire overtime expenses. Through November, Police had spent
85% of budget for overtime, and Fire had spent 135% over the annual budget. For Police, this is
below target of 92%. 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,263,472 85%
Fire $1,651,457 $ 959,956 $1,300,235 135%
Enterprise Funds
Parking fund revenues through November 30, 2021 are at 72% of budget and expenses are at 72%.
The fund ended 2020 with a fund balance of $488,957.
Through November 30, 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 November 30, 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 November 30, 2021, the Solid Waste Fund has a fund balance of $595,262 and a negative
cash balance of $356,194. The fund ended 2020 with a negative fund balance of $150,325.
Other Funds
Through November 30, 2021, the SSA #9 Fund is showing negative fund and cash balance of
$206,750.
Through November 30, 2021, the Capital Improvements Fund is showing a fund balance of
$13,328,826 and a cash balance of $13,651,430. The fund continues to spend down Series 2021 and
Series 2020 bond proceeds.
Through November 30, 2021, the Crown Construction fund is showing fund balance of $4,688,297
and cash balance of $5,976,554. The fund continues to spend down balances from bond proceeds
and gifts from the Friends of Robert Crown.
Through November 30, 2021, the Insurance Fund is showing a negative fund balance of $6,568,239
and a negative cash balance of $2,089,574. 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 November 30, 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
.00 .00 (200.00)200.00 +++.00
500.00 (80.00)49.00 451.00 10 47.00
68,600,003.00 6,830,254.13 73,123,817.89 (4,523,814.89)107 71,948,682.90
537,000.00 40,752.50 446,454.49 90,545.51 83 374,776.51
3,958,500.00 368,548.60 3,252,223.82 706,276.18 82 2,468,829.67
4,974,700.00 301,286.13 5,648,315.89 (673,615.89)114 7,577,748.81
12,599,461.00 199,793.90 12,259,901.30 339,559.70 97 12,098,944.12
12,420,378.00 432,855.45 12,921,426.24 (501,048.24)104 12,282,439.34
1,272,842.00 18,616.00 1,317,089.65 (44,247.65)103 888,088.69
.00 .00 5.00 (5.00)+++5.13
6,021,025.00 351,214.13 5,960,544.60 60,480.40 99 5,095,070.90
638,200.00 3,113.34 328,050.89 310,149.11 51 253,667.34
$111,022,609.00 $8,546,354.18 $115,257,678.77 ($4,235,069.77)104%$112,988,300.41
.00 .00 795.00 (795.00)+++3,139.75
556,165.60 48,427.22 471,231.77 84,933.83 85 472,270.09
178,794.66 14,416.27 178,808.40 (13.74)100 183,831.96
6,004,834.63 448,858.96 5,563,343.68 441,490.95 93 10,136,584.81
576,892.00 48,064.28 472,926.91 103,965.09 82 511,640.20
10,360,246.39 836,829.07 9,374,197.34 986,049.05 90 9,295,177.88
3,073,829.11 231,046.63 2,947,285.96 126,543.15 96 3,150,001.53
39,734,285.59 2,196,953.53 36,526,615.59 3,207,670.00 92 38,724,587.22
26,006,574.05 1,343,480.47 24,613,875.02 1,392,699.03 95 26,265,320.62
1,556,419.50 130,288.71 1,771,553.81 (215,134.31)114 1,331,233.68
11,329,360.87 692,074.73 10,044,547.98 1,284,812.89 89 9,550,408.37
11,642,790.99 828,270.74 10,544,871.39 1,097,919.60 91 11,566,540.90
.00 .00 .00 .00 +++30.00
$111,020,193.39 $6,818,710.61 $102,510,052.85 $8,510,140.54 92%$111,190,767.01
111,022,609.00 8,546,354.18 115,257,678.77 (4,235,069.77)104%112,988,300.41
111,020,193.39 6,818,710.61 102,510,052.85 8,510,140.54 92%111,190,767.01
$2,415.61 $1,727,643.57 $12,747,625.92 $12,745,210.31 527,719%$1,797,533.40
Fund 100 - GENERAL FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 100 - GENERAL FUND Net Gain (Loss)
40 PUBLIC WORKS AGENCY
48 LIBRARY
EXPENSE TOTALS
23 FIRE MGMT & SUPPORT
24 HEALTH
30 PARKS AND RECREATION
19 ADMINISTRATIVE SERVICES
21 COMMUNITY DEVELOPMENT
22 POLICE
14 CITY CLERK
15 CITY MANAGER'S OFFICE
17 LAW
EXPENSE
12 LEGISLATIVE
13 CITY COUNCIL
30 PARKS AND RECREATION
40 PUBLIC WORKS AGENCY
REVENUE TOTALS
23 FIRE MGMT & SUPPORT
24 HEALTH
26 PUBLIC WORKS
19 ADMINISTRATIVE SERVICES
21 COMMUNITY DEVELOPMENT
22 POLICE
14 CITY CLERK
15 CITY MANAGER'S OFFICE
17 LAW
Fund Type GENERAL FUND
Fund 100 - GENERAL FUND
REVENUE
12 LEGISLATIVE
Income Statement
Through 11/30/21
Summary Listing
Organization Organization Description
Fund Category Governmental Funds
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 412,500.00 37,500.00 92 100,000.00
125,000.00 5,833.00 215,432.60 (90,432.60) 172 50,548.97
2,000.00 .00 2,940.00 (940.00) 147 95,950.00
.00 121.41 1,494.67 (1,494.67) +++ 800.72
$3,687,000.00 $43,454.41 $3,742,367.27 ($55,367.27) 102% $3,357,299.69
$3,687,000.00 $43,454.41 $3,742,367.27 ($55,367.27) 102% $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 116,269.01 1,427,224.14 269,924.07 84 1,217,849.18
603,870.00 3,357.13 332,438.47 271,431.53 55 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 2,233.91 160,428.41 304,571.59 35 112,670.28
.00 .00 .00 .00 +++ 3,352.00
$2,909,351.21 $121,860.05 $2,017,077.58 $892,273.63 69% $2,417,995.23
$3,645,724.21 $121,860.05 $2,017,077.58 $1,628,646.63 55% $2,417,995.23
3,687,000.00 43,454.41 3,742,367.27 (55,367.27) 102% 3,357,299.69
3,645,724.21 121,860.05 2,017,077.58 1,628,646.63 55% 2,417,995.23
$41,275.79 ($78,405.64) $1,725,289.69 $1,684,013.90 4,180% $939,304.46
Income Statement
Through 11/30/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type GENERAL FUND
Fund 176 - HUMAN SERVICES FUND
REVENUE
Department 24 - HEALTH
Property Taxes
Interfund Transfers
Intergovernmental Revenue
Other Revenue
Interest Income
Department 24 - HEALTH Totals
REVENUE TOTALS
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies
Department 21 - COMMUNITY DEVELOPMENT Totals
Department 24 - HEALTH
Salary and Benefits
Services and Supplies
Insurance and Other Chargebacks
Community Sponsored Organizations
Miscellaneous
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
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 1,892.80 24,679.34 (24,679.34) +++ .00
$0.00 $1,892.80 $21,611,506.34 ($21,611,506.34) +++ $0.00
$0.00 $1,892.80 $21,611,506.34 ($21,611,506.34) +++ $0.00
.00 .00 4,800,000.00 (4,800,000.00) +++ .00
$0.00 $0.00 $4,800,000.00 ($4,800,000.00) +++ $0.00
$0.00 $0.00 $4,800,000.00 ($4,800,000.00) +++ $0.00
.00 1,892.80 21,611,506.34 (21,611,506.34) +++ .00
.00 .00 4,800,000.00 (4,800,000.00) +++ .00
$0.00 $1,892.80 $16,811,506.34 $16,811,506.34 +++ $0.00
Income Statement
Through 11/30/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 7,305.58 1,317,476.77 (17,476.77) 101 1,100,904.14
27,500.00 .00 2,585.00 24,915.00 9 42,115.91
1,000.00 155.22 1,297.29 (297.29) 130 3,131.62
$1,328,500.00 $7,460.80 $1,321,359.06 $7,140.94 99% $1,146,151.67
$1,328,500.00 $7,460.80 $1,321,359.06 $7,140.94 99% $1,146,151.67
452,062.40 36,607.28 445,798.68 6,263.72 99 406,614.05
865,982.00 46,292.42 552,257.33 313,724.67 64 708,132.08
7,000.00 .00 4,676.28 2,323.72 67 4,910.00
$1,325,044.40 $82,899.70 $1,002,732.29 $322,312.11 76% $1,119,656.13
$1,325,044.40 $82,899.70 $1,002,732.29 $322,312.11 76% $1,119,656.13
1,328,500.00 7,460.80 1,321,359.06 7,140.94 99% 1,146,151.67
1,325,044.40 82,899.70 1,002,732.29 322,312.11 76% 1,119,656.13
$3,455.60 ($75,438.90) $318,626.77 $315,171.17 9,221% $26,495.54
Income Statement
Through 11/30/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
400,000.00 .00 .00 400,000.00 0 .00
.00 .00 .00 .00 +++ 200,000.00
.00 1,550.00 32,960.29 (32,960.29) +++ 16,806.50
.00 41.45 351.04 (351.04) +++ .00
$400,000.00 $1,591.45 $33,311.33 $366,688.67 8% $216,806.50
$400,000.00 $1,591.45 $33,311.33 $366,688.67 8% $216,806.50
.00 172.10 1,922.08 (1,922.08) +++ .00
400,000.00 .00 .00 400,000.00 0 .00
$400,000.00 $172.10 $1,922.08 $398,077.92 0% $0.00
$400,000.00 $172.10 $1,922.08 $398,077.92 0% $0.00
400,000.00 1,591.45 33,311.33 366,688.67 8% 216,806.50
400,000.00 172.10 1,922.08 398,077.92 0% .00
$0.00 $1,419.35 $31,389.25 $31,389.25 +++ $216,806.50
Income Statement
Through 11/30/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 63.65 849.12 (849.12) +++ 1,805.35
$1,000,000.00 $63.65 $1,000,849.12 ($849.12) 100% $1,001,805.35
$1,000,000.00 $63.65 $1,000,849.12 ($849.12) 100% $1,001,805.35
.00 31.85 416.76 (416.76) +++ 497.43
620,000.00 .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 $31.85 $449,489.12 $550,510.88 45% $903,532.37
$1,000,000.00 $31.85 $449,489.12 $550,510.88 45% $903,532.37
1,000,000.00 63.65 1,000,849.12 (849.12) 100% 1,001,805.35
1,000,000.00 31.85 449,489.12 550,510.88 45% 903,532.37
$0.00 $31.80 $551,360.00 $551,360.00 +++ $98,272.98
Income Statement
Through 11/30/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 40,273.55 7,294,495.73 (42,495.73) 101 7,268,891.26
.00 .00 4,509.40 (4,509.40) +++ 22,320.17
.00 35.87 244.16 (244.16) +++ 149.90
209,000.00 .00 250,000.00 (41,000.00) 120 199,414.25
238,000.00 26,568.79 280,594.13 (42,594.13) 118 285,045.65
400,000.00 57,357.22 232,216.82 167,783.18 58 427,372.39
227,224.00 8,837.13 73,183.84 154,040.16 32 71,720.03
15,000.00 878.01 9,566.01 5,433.99 64 26,949.16
$8,341,224.00 $133,950.57 $8,144,810.09 $196,413.91 98% $8,301,862.81
$8,341,224.00 $133,950.57 $8,144,810.09 $196,413.91 98% $8,301,862.81
5,910,018.36 401,389.47 5,170,671.55 739,346.81 87 5,405,967.44
2,052,000.00 136,582.60 1,669,728.00 382,272.00 81 1,714,948.94
8,500.00 .00 1,463.52 7,036.48 17 775.00
.00 1,500.00 1,500.00 (1,500.00) +++ 600.00
361,226.00 30,101.00 331,111.00 30,115.00 92 354,375.00
$8,331,744.36 $569,573.07 $7,174,474.07 $1,157,270.29 86% $7,476,666.38
$8,331,744.36 $569,573.07 $7,174,474.07 $1,157,270.29 86% $7,476,666.38
8,341,224.00 133,950.57 8,144,810.09 196,413.91 98% 8,301,862.81
8,331,744.36 569,573.07 7,174,474.07 1,157,270.29 86% 7,476,666.38
$9,479.64 ($435,622.50) $970,336.02 $960,856.38 10,236% $825,196.43
Income Statement
Through 11/30/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 185 - LIBRARY FUND
REVENUE
Department 48 - LIBRARY
Property Taxes
Fines and Forfeitures
Charges for Services
Interfund Transfers
Intergovernmental Revenue
Other Revenue
Library Revenue
Interest Income
Department 48 - LIBRARY Totals
REVENUE TOTALS
EXPENSE
Department 48 - LIBRARY
Salary and Benefits
Services and Supplies
Capital Outlay
Miscellaneous
Interfund Transfers
EXPENSE TOTALS
Fund 185 - LIBRARY FUND Net Gain (Loss)
Department 48 - LIBRARY Totals
EXPENSE TOTALS
Fund 185 - LIBRARY FUND Totals
REVENUE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
3,656,700.00 270,148.71 4,296,631.82 (639,931.82) 118 4,346,950.35
12,000.00 421.75 4,321.27 7,678.73 36 18,013.10
$3,668,700.00 $270,570.46 $4,300,953.09 ($632,253.09) 117% $4,364,963.45
$3,668,700.00 $270,570.46 $4,300,953.09 ($632,253.09) 117% $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 20,940.75 646,241.22 391,758.78 62 684,583.03
2,284,000.00 .00 1,292,017.95 991,982.05 57 1,316,209.69
1,044,987.00 87,082.00 957,902.00 87,085.00 92 .00
$4,366,987.00 $108,022.75 $2,896,161.17 $1,470,825.83 66% $2,000,792.72
$4,366,987.00 $108,022.75 $3,059,595.17 $1,307,391.83 70% $3,071,252.67
3,668,700.00 270,570.46 4,300,953.09 (632,253.09) 117% 4,364,963.45
4,366,987.00 108,022.75 3,059,595.17 1,307,391.83 70% 3,071,252.67
($698,287.00) $162,547.71 $1,241,357.92 $1,939,644.92 (178%) $1,293,710.78
Income Statement
Through 11/30/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 124,032.85 1,204,423.57 117,176.43 91 1,460,634.96
.00 .00 .00 .00 +++ 240,821.00
.00 .00 266.17 (266.17) +++ .00
7,000.00 35.00 696.69 6,303.31 10 5,531.23
$1,328,600.00 $124,067.85 $1,205,386.43 $123,213.57 91% $1,706,987.19
$1,328,600.00 $124,067.85 $1,205,386.43 $123,213.57 91% $1,706,987.19
742,978.48 48,003.23 521,203.46 221,775.02 70 561,536.22
374,000.00 64,754.51 292,449.40 81,550.60 78 241,438.39
299,163.00 241,724.00 249,519.66 49,643.34 83 506,613.00
18,230.00 1,519.00 16,709.00 1,521.00 92 18,229.00
.00 500.00 500.00 (500.00) +++ 500.00
90,000.00 7,500.00 82,500.00 7,500.00 92 260,000.00
$1,524,371.48 $364,000.74 $1,162,881.52 $361,489.96 76% $1,588,316.61
$1,524,371.48 $364,000.74 $1,162,881.52 $361,489.96 76% $1,588,316.61
1,328,600.00 124,067.85 1,205,386.43 123,213.57 91% 1,706,987.19
1,524,371.48 364,000.74 1,162,881.52 361,489.96 76% 1,588,316.61
($195,771.48) ($239,932.89) $42,504.91 $238,276.39 (22%) $118,670.58
Income Statement
Through 11/30/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 1,991.33 603,007.19 (10,342.19) 102 603,396.20
.00 21.11 28.29 (28.29) +++ 87.15
$592,665.00 $2,012.44 $603,035.48 ($10,370.48) 102% $603,483.35
$592,665.00 $2,012.44 $603,035.48 ($10,370.48) 102% $603,483.35
575,000.00 295,911.61 595,125.30 (20,125.30) 104 591,950.27
$575,000.00 $295,911.61 $595,125.30 ($20,125.30) 104% $591,950.27
$575,000.00 $295,911.61 $595,125.30 ($20,125.30) 104% $591,950.27
592,665.00 2,012.44 603,035.48 (10,370.48) 102% 603,483.35
575,000.00 295,911.61 595,125.30 (20,125.30) 104% 591,950.27
$17,665.00 ($293,899.17) $7,910.18 ($9,754.82) 45% $11,533.08
Income Statement
Through 11/30/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 334,439.05 1,193,906.52 1,564,607.48 43 1,698,645.65
$2,758,514.00 $334,439.05 $1,193,906.52 $1,564,607.48 43% $1,698,645.65
$2,758,514.00 $334,439.05 $1,193,906.52 $1,564,607.48 43% $1,698,645.65
319,997.01 25,283.61 320,527.72 (530.71) 100 365,979.08
506,200.00 6.20 22,557.76 483,642.24 4 71,266.08
.00 97,980.03 225,710.52 (225,710.52) +++ 607,132.53
150,000.00 .00 281,264.73 (131,264.73) 188 292,237.53
80,000.00 28,388.17 448,609.28 (368,609.28) 561 282,315.50
1,700,000.00 89,855.11 134,218.28 1,565,781.72 8 70,077.60
.00 .00 .00 .00 +++ 12,111.33
$2,756,197.01 $241,513.12 $1,432,888.29 $1,323,308.72 52% $1,701,119.65
$2,756,197.01 $241,513.12 $1,432,888.29 $1,323,308.72 52% $1,701,119.65
2,758,514.00 334,439.05 1,193,906.52 1,564,607.48 43% 1,698,645.65
2,756,197.01 241,513.12 1,432,888.29 1,323,308.72 52% 1,701,119.65
$2,316.99 $92,925.93 ($238,981.77) ($241,298.76) (10,314%) ($2,474.00)
Income Statement
Through 11/30/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 69,307.44 171,845.36 (61,845.36) 156 74,015.96
.00 50.61 699.20 (699.20) +++ 2,387.91
$110,000.00 $69,358.05 $172,544.56 ($62,544.56) 157% $76,403.87
$110,000.00 $69,358.05 $172,544.56 ($62,544.56) 157% $76,403.87
175,000.00 27,659.59 44,369.59 130,630.41 25 120,955.83
.00 .00 .00 .00 +++ 8.50
$175,000.00 $27,659.59 $44,369.59 $130,630.41 25% $120,964.33
$175,000.00 $27,659.59 $44,369.59 $130,630.41 25% $120,964.33
110,000.00 69,358.05 172,544.56 (62,544.56) 157% 76,403.87
175,000.00 27,659.59 44,369.59 130,630.41 25% 120,964.33
($65,000.00) $41,698.46 $128,174.97 $193,174.97 (197%) ($44,560.46)
Income Statement
Through 11/30/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 1.60 21.24 (21.24) +++ 334.15
$0.00 $1.60 $21.24 ($21.24) +++ $334.15
$0.00 $1.60 $21.24 ($21.24) +++ $334.15
.00 .78 10.02 (10.02) +++ 77.70
.00 .00 .00 .00 +++ 150,000.00
$0.00 $0.78 $10.02 ($10.02) +++ $150,077.70
$0.00 $0.78 $10.02 ($10.02) +++ $150,077.70
.00 1.60 21.24 (21.24) +++ 334.15
.00 .78 10.02 (10.02) +++ 150,077.70
$0.00 $0.82 $11.22 $11.22 +++ ($149,743.55)
Income Statement
Through 11/30/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 20,848.02 332,683.70 207,769.30 62 427,547.16
25,000.00 4,564.00 33,673.41 (8,673.41) 135 12,333.55
150.00 15.50 82.44 67.56 55 114.73
$565,603.00 $25,427.52 $366,439.55 $199,163.45 65% $471,202.89
$565,603.00 $25,427.52 $366,439.55 $199,163.45 65% $471,202.89
63,875.72 2,371.15 55,509.62 8,366.10 87 12,520.85
500,565.00 19,323.84 316,939.46 183,625.54 63 411,196.39
.00 .00 (2,741.11) 2,741.11 +++ 25,398.32
500.00 .00 101.50 398.50 20 47.85
$564,940.72 $21,694.99 $369,809.47 $195,131.25 65% $449,163.41
$564,940.72 $21,694.99 $369,809.47 $195,131.25 65% $449,163.41
565,603.00 25,427.52 366,439.55 199,163.45 65% 471,202.89
564,940.72 21,694.99 369,809.47 195,131.25 65% 449,163.41
$662.28 $3,732.53 ($3,369.92) ($4,032.20) (509%) $22,039.48
Income Statement
Through 11/30/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 106,559.00 431,740.03 226,259.97 66 255,299.89
175,600.00 32,083.34 128,750.03 46,849.97 73 655,416.71
5,700.00 271.59 7,173.57 (1,473.57) 126 27,280.46
$914,300.00 $138,913.93 $583,116.63 $331,183.37 64% $1,014,647.06
$914,300.00 $138,913.93 $583,116.63 $331,183.37 64% $1,014,647.06
202,683.56 10,896.64 159,325.79 43,357.77 79 118,297.21
2,031,050.00 13,674.40 1,239,217.36 791,832.64 61 398,862.20
10,000.00 .00 4,200.00 5,800.00 42 2,800.00
17,000.00 .00 (47,471.04) 64,471.04 (279) (34,214.97)
166,000.00 .00 311,343.06 (145,343.06) 188 246,094.03
102,510.00 1,212.50 18,463.16 84,046.84 18 406,628.08
$2,529,243.56 $25,783.54 $1,685,078.33 $844,165.23 67% $1,138,466.55
$2,529,243.56 $25,783.54 $1,685,078.33 $844,165.23 67% $1,138,466.55
914,300.00 138,913.93 583,116.63 331,183.37 64% 1,014,647.06
2,529,243.56 25,783.54 1,685,078.33 844,165.23 67% 1,138,466.55
($1,614,943.56) $113,130.39 ($1,101,961.70) $512,981.86 68% ($123,819.49)
Income Statement
Through 11/30/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 11/30/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 .00 1,259,481.41 (291,481.41) 130 1,227,407.93
5,366.00 3,947.23 22,987.18 (17,621.18) 428 20,631.95
400.00 445.20 6,056.56 (5,656.56) 1,514 12,998.83
$973,766.00 $4,392.43 $1,288,525.15 ($314,759.15) 132% $1,261,038.71
$973,766.00 $4,392.43 $1,288,525.15 ($314,759.15) 132% $1,261,038.71
335,000.00 1.19 154,421.05 180,578.95 46 352,868.87
500,000.00 .00 391,989.20 108,010.80 78 382,140.14
.00 .00 .00 .00 +++ 731.37
218,113.00 18,176.00 199,936.00 18,177.00 92 314,020.09
$1,053,113.00 $18,177.19 $746,346.25 $306,766.75 71% $1,049,760.47
$1,053,113.00 $18,177.19 $746,346.25 $306,766.75 71% $1,049,760.47
973,766.00 4,392.43 1,288,525.15 (314,759.15) 132% 1,261,038.71
1,053,113.00 18,177.19 746,346.25 306,766.75 71% 1,049,760.47
($79,347.00) ($13,784.76) $542,178.90 $621,525.90 (683%) $211,278.24
Income Statement
Through 11/30/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 3,425.97 1,774,424.08 (537,424.08) 143 1,697,958.33
11,000.00 .00 171,504.26 (160,504.26) 1,559 10,282.60
4,000.00 783.34 5,071.24 (1,071.24) 127 6,070.52
$1,252,000.00 $4,209.31 $1,950,999.58 ($698,999.58) 156% $1,714,311.45
$1,252,000.00 $4,209.31 $1,950,999.58 ($698,999.58) 156% $1,714,311.45
5,000.00 4.53 66,825.64 (61,825.64) 1,337 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 68,750.00 6,250.00 92 135,000.00
$780,000.00 $6,254.53 $468,212.64 $311,787.36 60% $630,157.35
$780,000.00 $6,254.53 $468,212.64 $311,787.36 60% $630,157.35
1,252,000.00 4,209.31 1,950,999.58 (698,999.58) 156% 1,714,311.45
780,000.00 6,254.53 468,212.64 311,787.36 60% 630,157.35
$472,000.00 ($2,045.22) $1,482,786.94 $1,010,786.94 314% $1,084,154.10
Income Statement
Through 11/30/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 .00 282,948.21 (135,948.21) 192 170,306.49
.00 .00 .00 .00 +++ 100,000.00
.00 84.23 496.10 (496.10) +++ 795.89
$147,000.00 $84.23 $283,444.31 ($136,444.31) 193% $271,102.38
$147,000.00 $84.23 $283,444.31 ($136,444.31) 193% $271,102.38
2,000.00 .49 465.32 1,534.68 23 772.52
168,923.00 14,077.00 154,847.00 14,076.00 92 165,870.00
$170,923.00 $14,077.49 $155,312.32 $15,610.68 91% $166,642.52
$170,923.00 $14,077.49 $155,312.32 $15,610.68 91% $166,642.52
147,000.00 84.23 283,444.31 (136,444.31) 193% 271,102.38
170,923.00 14,077.49 155,312.32 15,610.68 91% 166,642.52
($23,923.00) ($13,993.26) $128,131.99 $152,054.99 (536%) $104,459.86
Income Statement
Through 11/30/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 74,131.82 1,207,607.53 (328,607.53) 137 1,145,554.72
1,130,000.00 .00 .00 1,130,000.00 0 .00
.00 259.12 2,648.88 (2,648.88) +++ 5,057.19
$2,009,000.00 $74,390.94 $1,210,256.41 $798,743.59 60% $1,150,611.91
$2,009,000.00 $74,390.94 $1,210,256.41 $798,743.59 60% $1,150,611.91
5,000.00 1.50 478.35 4,521.65 10 785.07
1,130,000.00 140,127.52 1,295,768.84 (165,768.84) 115 251,298.71
262,843.00 21,904.00 240,944.00 21,899.00 92 260,610.00
$1,397,843.00 $162,033.02 $1,537,191.19 ($139,348.19) 110% $512,693.78
$1,397,843.00 $162,033.02 $1,537,191.19 ($139,348.19) 110% $512,693.78
2,009,000.00 74,390.94 1,210,256.41 798,743.59 60% 1,150,611.91
1,397,843.00 162,033.02 1,537,191.19 (139,348.19) 110% 512,693.78
$611,157.00 ($87,642.08) ($326,934.78) ($938,091.78) (53%) $637,918.13
Income Statement
Through 11/30/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 1,255.30 221,511.46 (511.46) 100 224,827.08
500.00 51.53 66.33 433.67 13 315.81
$221,500.00 $1,306.83 $221,577.79 ($77.79) 100% $225,142.89
$221,500.00 $1,306.83 $221,577.79 ($77.79) 100% $225,142.89
221,500.00 216,365.69 223,914.21 (2,414.21) 101 226,411.95
$221,500.00 $216,365.69 $223,914.21 ($2,414.21) 101% $226,411.95
$221,500.00 $216,365.69 $223,914.21 ($2,414.21) 101% $226,411.95
221,500.00 1,306.83 221,577.79 (77.79) 100% 225,142.89
221,500.00 216,365.69 223,914.21 (2,414.21) 101% 226,411.95
$0.00 ($215,058.86) ($2,336.42) ($2,336.42) +++ ($1,269.06)
Income Statement
Through 11/30/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 5,036.43 144,157.43 10,642.57 93 141,256.43
.00 16.10 93.88 (93.88) +++ 91.37
$154,800.00 $5,052.53 $144,251.31 $10,548.69 93% $141,347.80
$154,800.00 $5,052.53 $144,251.31 $10,548.69 93% $141,347.80
115,000.00 .09 73,741.07 41,258.93 64 140,994.91
$115,000.00 $0.09 $73,741.07 $41,258.93 64% $140,994.91
$115,000.00 $0.09 $73,741.07 $41,258.93 64% $140,994.91
154,800.00 5,052.53 144,251.31 10,548.69 93% 141,347.80
115,000.00 .09 73,741.07 41,258.93 64% 140,994.91
$39,800.00 $5,052.44 $70,510.24 $30,710.24 177% $352.89
Income Statement
Through 11/30/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 612.89 49,463.68 10,736.32 82 59,743.95
.00 7.31 11,204.03 (11,204.03) +++ 24.15
$60,200.00 $620.20 $60,667.71 ($467.71) 101% $59,768.10
$60,200.00 $620.20 $60,667.71 ($467.71) 101% $59,768.10
60,200.00 .04 30,893.15 29,306.85 51 58,722.29
$60,200.00 $0.04 $30,893.15 $29,306.85 51% $58,722.29
$60,200.00 $0.04 $30,893.15 $29,306.85 51% $58,722.29
60,200.00 620.20 60,667.71 (467.71) 101% 59,768.10
60,200.00 .04 30,893.15 29,306.85 51% 58,722.29
$0.00 $620.16 $29,774.56 $29,774.56 +++ $1,045.81
Income Statement
Through 11/30/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
EXPENSE TOTALS
Fund 360 - SPECIAL SERVICE AREA (SSA) #8 Net Gain (Loss)
Department 99 - NON-DEPARTMENTAL Totals
EXPENSE TOTALS
Fund 360 - SPECIAL SERVICE AREA (SSA) #8 Totals
REVENUE TOTALS
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 11/30/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 73,652.69 14,306,129.28 (369,866.28) 103 12,814,108.59
1,197,401.00 99,785.00 1,097,635.00 99,766.00 92 3,319,053.04
.00 (1,029.96) 4,008,217.97 (4,008,217.97) +++ 12,054,284.90
1,500.00 1,693.89 10,173.91 (8,673.91) 678 24,864.03
$15,135,164.00 $174,101.62 $19,422,156.16 ($4,286,992.16) 128% $28,212,310.56
$15,135,164.00 $174,101.62 $19,422,156.16 ($4,286,992.16) 128% $28,212,310.56
.00 6,302.50 55,516.31 (55,516.31) +++ 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 $6,302.50 $7,026,196.84 $8,107,469.16 46% $27,908,283.41
$15,133,666.00 $6,302.50 $7,026,196.84 $8,107,469.16 46% $27,908,283.41
15,135,164.00 174,101.62 19,422,156.16 (4,286,992.16) 128% 28,212,310.56
15,133,666.00 6,302.50 7,026,196.84 8,107,469.16 46% 27,908,283.41
$1,498.00 $167,799.12 $12,395,959.32 $12,394,461.32 827,501% $304,027.15
Income Statement
Through 11/30/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 (15,969.95) 168,705.75 (168,705.75) +++ .00
.00 .00 .00 .00 +++ 470,000.04
.00 9,411.00 340,579.38 (340,579.38) +++ .00
7,645,000.00 .00 8,969,069.48 (1,324,069.48) 117 6,833,019.50
.00 1,912.37 12,552.15 (12,552.15) +++ 24,813.33
$7,645,000.00 ($4,646.58) $9,490,906.76 ($1,845,906.76) 124% $7,327,832.87
.00 (2,953.71) (77,926.51) 77,926.51 +++ 18,170.77
.00 .00 892.68 (892.68) +++ 61,116.40
$0.00 ($2,953.71) ($77,033.83) $77,033.83 +++ $79,287.17
$7,645,000.00 ($7,600.29) $9,413,872.93 ($1,768,872.93) 123% $7,407,120.04
696,766.01 57,716.29 637,985.40 58,780.61 92 676,147.47
.00 71,163.47 1,465,187.23 (1,465,187.23) +++ 1,564,539.87
9,705,000.00 619,237.67 4,500,387.02 5,204,612.98 46 7,018,081.23
$10,401,766.01 $748,117.43 $6,603,559.65 $3,798,206.36 63% $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 $748,117.43 $6,603,559.65 $3,798,206.36 63% $9,548,853.57
7,645,000.00 (7,600.29) 9,413,872.93 (1,768,872.93) 123% 7,407,120.04
10,401,766.01 748,117.43 6,603,559.65 3,798,206.36 63% 9,548,853.57
($2,756,766.01) ($755,717.72) $2,810,313.28 $5,567,079.29 (102%) ($2,141,733.53)
Income Statement
Through 11/30/21
Summary Listing
Classification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 415 - CAPITAL IMPROVEMENTS FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Charges for Services
Interfund Transfers
Intergovernmental Revenue
Other Revenue
Interest Income
Department 40 - PUBLIC WORKS AGENCY Totals
Department 99 - NON-DEPARTMENTAL
Other Revenue
Interest Income
Department 99 - NON-DEPARTMENTAL Totals
REVENUE TOTALS
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits
Services and Supplies
Capital Outlay
Department 40 - PUBLIC WORKS AGENCY Totals
Department 99 - NON-DEPARTMENTAL
Services and Supplies
Interfund Transfers
Department 99 - NON-DEPARTMENTAL Totals
EXPENSE TOTALS
Fund 415 - CAPITAL IMPROVEMENTS FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 415 - CAPITAL IMPROVEMENTS 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 .00 .00 +++ 2,000,000.00
.00 .00 1,000,000.00 (1,000,000.00) +++ .00
1,000,000.00 600,000.00 2,800,000.00 (1,800,000.00) 280 2,037,500.00
.00 976.27 11,194.71 (11,194.71) +++ 90,687.56
$1,000,000.00 $600,976.27 $3,811,194.71 ($2,811,194.71) 381% $4,128,187.56
$1,000,000.00 $600,976.27 $3,811,194.71 ($2,811,194.71) 381% $4,128,187.56
.00 7,505.00 13,824.13 (13,824.13) +++ 333,461.83
1,000,000.00 1,375.00 1,739,957.39 (739,957.39) 174 8,172,492.39
637,500.00 .00 .00 637,500.00 0 637,500.00
$1,637,500.00 $8,880.00 $1,753,781.52 ($116,281.52) 107% $9,143,454.22
$1,637,500.00 $8,880.00 $1,753,781.52 ($116,281.52) 107% $9,143,454.22
1,000,000.00 600,976.27 3,811,194.71 (2,811,194.71) 381% 4,128,187.56
1,637,500.00 8,880.00 1,753,781.52 (116,281.52) 107% 9,143,454.22
($637,500.00) $592,096.27 $2,057,413.19 $2,694,913.19 (323%) ($5,015,266.66)
Income Statement
Through 11/30/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 160,413.00 14,587.00 92 175,000.00
$175,000.00 $14,583.00 $160,413.00 $14,587.00 92% $175,000.00
$175,000.00 $14,583.00 $160,413.00 $14,587.00 92% $175,000.00
175,000.00 14,583.00 160,413.00 14,587.00 92% 175,000.00
.00 .00 .00 .00 +++ .00
$175,000.00 $14,583.00 $160,413.00 ($14,587.00) 92% $175,000.00
Income Statement
Through 11/30/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 1,303.14 62,552.82 62,447.18 50 168,414.88
.00 .00 (1,109.75) 1,109.75 +++ .00
30,000.00 273.93 13,173.21 16,826.79 44 35,236.30
$155,000.00 $1,577.07 $74,616.28 $80,383.72 48% $203,651.18
$155,000.00 $1,577.07 $74,616.28 $80,383.72 48% $203,651.18
.00 5.00 55.00 (55.00) +++ 60.00
.00 .00 .00 .00 +++ .00
.00 .00 .00 .00 +++ 477,930.00
$0.00 $5.00 $55.00 ($55.00) +++ $477,990.00
500,000.00 121,747.50 121,747.50 378,252.50 24 .00
489,314.00 40,777.00 448,547.00 40,767.00 92 .00
$989,314.00 $162,524.50 $570,294.50 $419,019.50 58% $0.00
$989,314.00 $162,529.50 $570,349.50 $418,964.50 58% $477,990.00
155,000.00 1,577.07 74,616.28 80,383.72 48% 203,651.18
989,314.00 162,529.50 570,349.50 418,964.50 58% 477,990.00
($834,314.00) ($160,952.43) ($495,733.22) $338,580.78 59% ($274,338.82)
Income Statement
Through 11/30/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
Fund 420 - SPECIAL ASSESSMENT FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 420 - SPECIAL ASSESSMENT FUND Net Gain (Loss)
Capital Outlay
Interfund Transfers
Department 40 - PUBLIC WORKS AGENCY Totals
EXPENSE TOTALS
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 425,786.12 6,986,547.65 3,147,177.35 69 6,937,516.53
.00 .00 .00 .00 +++ 140,907.09
.00 .00 950,000.00 (950,000.00) +++ .00
1,404,700.00 5,485.77 333,351.35 1,071,348.65 24 348,622.73
20,000.00 4,904.51 23,534.10 (3,534.10) 118 53,583.60
$11,558,425.00 $436,176.40 $8,293,808.10 $3,264,616.90 72% $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 $436,176.40 $8,293,808.10 $3,264,616.90 72% $7,483,536.24
255,033.38 21,746.54 217,847.08 37,186.30 85 270,658.21
$255,033.38 $21,746.54 $217,847.08 $37,186.30 85% $270,658.21
693,477.26 50,305.01 646,924.30 46,552.96 93 764,801.44
4,484,316.00 276,930.30 3,391,076.51 1,093,239.49 76 3,970,535.24
1,750,000.00 .00 141,787.63 1,608,212.37 8 8,004.00
351,502.00 29,292.00 322,212.00 29,290.00 92 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
50,000.00 .00 .00 50,000.00 0 .00
3,132,390.00 261,032.00 2,871,352.00 261,038.00 92 4,631,907.00
$10,508,849.26 $617,559.31 $7,401,567.44 $3,107,281.82 70% $12,637,150.51
487,451.58 37,887.20 465,406.41 22,045.17 95 523,157.26
.00 .00 .00 .00 +++ 23,335.04
.00 300.00 300.00 (300.00) +++ .00
$487,451.58 $38,187.20 $465,706.41 $21,745.17 96% $546,492.30
$11,251,334.22 $677,493.05 $8,085,120.93 $3,166,213.29 72% $13,454,301.02
11,558,425.00 436,176.40 8,293,808.10 3,264,616.90 72% 7,483,536.24
11,251,334.22 677,493.05 8,085,120.93 3,166,213.29 72% 13,454,301.02
$307,090.78 ($241,316.65) $208,687.17 ($98,403.61) 68% ($5,970,764.78)
Income Statement
Through 11/30/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
Miscellaneous
Interfund Transfers
Department 19 - ADMINISTRATIVE SERVICES Totals
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits
Fund 505 - PARKING SYSTEM FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 505 - PARKING SYSTEM FUND Net Gain (Loss)
Services and Supplies
Miscellaneous
Department 40 - PUBLIC WORKS AGENCY Totals
EXPENSE TOTALS
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
50,000.00 (4,812.60)57,596.30 (7,596.30)115 61,116.67
23,006,700.00 1,739,807.55 18,719,383.79 4,287,316.21 81 23,591,431.45
.00 .00 3,000,000.00 (3,000,000.00)+++.00
19,629,150.00 (8,583.93)2,269,987.05 17,359,162.95 12 298,660.82
70,000.00 5,434.09 42,332.44 27,667.56 60 71,542.67
$42,755,850.00 $1,731,845.11 $24,089,299.58 $18,666,550.42 56%$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,731,845.11 $26,861,525.52 $15,894,324.48 63%$24,166,661.88
5,927,918.46 432,185.12 5,224,979.48 702,938.98 88 5,618,144.35
4,793,710.00 226,364.34 2,694,965.34 2,098,744.66 56 3,212,472.18
24,200.00 .00 21,950.00 2,250.00 91 .00
.00 903.24 19,484.16 (19,484.16)+++.00
.00 .00 .00 .00 +++2,865,860.20
1,000.00 .00 .00 1,000.00 0 .00
15,000.00 600.00 9,180.19 5,819.81 61 300.00
180,000.00 15,000.00 165,000.00 15,000.00 92 11,418,966.32
$10,941,828.46 $675,052.70 $8,135,559.17 $2,806,269.29 74%$23,115,743.05
.00 .00 .00 .00 +++(120,875.19)
.00 .00 34,179.81 (34,179.81)+++.00
1,539,653.00 128,304.00 1,411,344.00 128,309.00 92 1,513,955.00
2,318,294.00 101,942.74 4,203,911.65 (1,885,617.65)181 1,089,040.81
4,049,559.00 337,464.00 3,712,104.00 337,455.00 92 3,799,559.00
$7,907,506.00 $567,710.74 $9,361,539.46 ($1,454,033.46)118%$6,281,679.62
$18,849,334.46 $1,242,763.44 $17,497,098.63 $1,352,235.83 93%$29,397,422.67
42,755,850.00 1,731,845.11 26,861,525.52 15,894,324.48 63%24,166,661.88
18,849,334.46 1,242,763.44 17,497,098.63 1,352,235.83 93%29,397,422.67
$23,906,515.54 $489,081.67 $9,364,426.89 ($14,542,088.65)39%($5,230,760.79)
Income Statement
Through 11/30/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
Salary and Benefits
Services and Supplies
Insurance and Other Chargebacks
Debt Service
Interfund Transfers
EXPENSE TOTALS
Fund 510 - WATER FUND Net Gain (Loss)
Department 71 - UTILITIES Totals
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 28,469.71 236,436.93 1,263,563.07 16 1,060.49
24,068,000.00 506,292.53 6,927,904.15 17,140,095.85 29 420,882.76
.00 .00 .00 .00 +++ (11,246,385.32)
$25,568,000.00 $534,762.24 $7,164,341.08 $18,403,658.92 28% ($10,824,442.07)
$25,568,000.00 $534,762.24 $7,164,341.08 $18,403,658.92 28% ($10,824,442.07)
.00 .00 .00 .00 +++ .00
25,568,000.00 534,762.24 7,164,341.08 18,403,658.92 28% (10,824,442.07)
($25,568,000.00) ($534,762.24) ($7,164,341.08) $18,403,658.92 28% $10,824,442.07
Income Statement
Through 11/30/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 1,014,965.61 9,410,842.41 964,565.59 91 10,242,065.74
2,001,000.00 (2,622.91) (8,009.44) 2,009,009.44 (0) 385,501.29
25,000.00 782.55 4,278.29 20,721.71 17 15,110.87
$12,401,408.00 $1,013,125.25 $9,407,111.26 $2,994,296.74 76% $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 $1,013,125.25 $9,407,111.26 $2,994,296.74 76% $10,690,544.71
1,425,265.69 104,769.25 1,221,200.08 204,065.61 86 1,332,414.71
1,484,650.00 31,145.79 952,717.33 531,932.67 64 394,477.24
3,343,000.00 70,854.00 191,048.64 3,151,951.36 6 .00
332,255.00 27,688.00 304,568.00 27,687.00 92 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 784,102.00 71,273.00 92 1,337,532.00
$7,442,045.69 $305,739.04 $3,454,136.05 $3,987,909.64 46% $7,145,996.16
.00 .00 .00 .00 +++ 60,949.08
5,195,191.00 1,024,321.43 4,865,459.97 329,731.03 94 726,343.24
$5,195,191.00 $1,024,321.43 $4,865,459.97 $329,731.03 94% $787,292.32
$12,637,236.69 $1,330,060.47 $8,319,596.02 $4,317,640.67 66% $7,933,288.48
12,401,408.00 1,013,125.25 9,407,111.26 2,994,296.74 76% 10,690,544.71
12,637,236.69 1,330,060.47 8,319,596.02 4,317,640.67 66% 7,933,288.48
($235,828.69) ($316,935.22) $1,087,515.24 $1,323,343.93 (461%) $2,757,256.23
Income Statement
Through 11/30/21
Summary Listing
Classification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 515 - SEWER FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Charges for Services
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
Miscellaneous
Interfund Transfers
Department 40 - PUBLIC WORKS AGENCY Totals
Department 71 - UTILITIES
Salary and Benefits
Debt Service
Department 71 - UTILITIES Totals
Fund 515 - SEWER FUND Net Gain (Loss)
EXPENSE TOTALS
Fund 515 - SEWER 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
.00 940.00 3,011.00 (3,011.00) +++ 2,184.00
$0.00 $940.00 $3,011.00 ($3,011.00) +++ $2,184.00
1,332,500.00 .00 1,332,500.00 .00 100 1,332,500.00
297,000.00 13,725.00 226,100.42 70,899.58 76 298,870.04
4,516,450.00 645,114.04 4,116,210.87 400,239.13 91 4,245,578.25
122,000.00 1,483.25 133,617.21 (11,617.21) 110 71,739.00
$6,267,950.00 $660,322.29 $5,808,428.50 $459,521.50 93% $5,948,687.29
$6,267,950.00 $661,262.29 $5,811,439.50 $456,510.50 93% $5,950,871.29
1,405,702.00 111,481.62 1,317,994.02 87,707.98 94 1,333,777.77
3,778,926.00 104,445.84 3,038,395.77 740,530.23 80 3,519,042.76
505,000.00 3,239.76 424,408.57 80,591.43 84 104,512.20
.00 .00 .00 .00 +++ 41,124.85
10,000.00 682.83 8,217.23 1,782.77 82 8,143.41
302,000.00 25,167.00 276,837.00 25,163.00 92 322,362.00
$6,001,628.00 $245,017.05 $5,065,852.59 $935,775.41 84% $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 $245,017.05 $5,065,852.59 $935,775.41 84% $5,315,940.73
6,267,950.00 661,262.29 5,811,439.50 456,510.50 93% 5,950,871.29
6,001,628.00 245,017.05 5,065,852.59 935,775.41 84% 5,315,940.73
$266,322.00 $416,245.24 $745,586.91 $479,264.91 280% $634,930.56
Income Statement
Through 11/30/21
Summary Listing
Classification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 520 - SOLID WASTE FUND
REVENUE
Department 26 - PUBLIC WORKS
Charges for Services
Department 26 - PUBLIC WORKS Totals
Department 40 - PUBLIC WORKS AGENCY
Property Taxes
Licenses, Permits and Fees
Charges for Services
Other Revenue
Department 40 - PUBLIC WORKS AGENCY Totals
REVENUE TOTALS
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits
Services and Supplies
Capital Outlay
Depreciation Expense
Miscellaneous
Interfund Transfers
Department 40 - PUBLIC WORKS AGENCY Totals
Department 71 - UTILITIES
Salary and Benefits
Department 71 - UTILITIES Totals
EXPENSE TOTALS
Fund 520 - SOLID WASTE FUND Totals
REVENUE TOTALS
EXPENSE TOTALS
Fund 520 - SOLID WASTE FUND Net Gain (Loss)
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,848,483.00 278,957.00 91 3,070,014.00
69,000.00 4,891.31 7,611.15 61,388.85 11 14,453.78
1,000.00 .00 .00 1,000.00 0 .00
$3,197,440.00 $263,844.31 $2,856,094.15 $341,345.85 89% $3,084,467.78
$3,197,440.00 $263,844.31 $2,856,094.15 $341,345.85 89% $3,084,467.78
1,148,166.41 89,118.87 1,046,187.69 101,978.72 91 1,134,913.86
2,034,507.00 191,805.20 1,608,740.66 425,766.34 79 1,316,444.13
.00 2,030.96 22,158.68 (22,158.68) +++ 3.92
.00 449.94 18,168.28 (18,168.28) +++ 7,999.49
.00 600.00 600.00 (600.00) +++ 900.00
$3,182,673.41 $284,004.97 $2,695,855.31 $486,818.10 85% $2,460,261.40
$3,182,673.41 $284,004.97 $2,695,855.31 $486,818.10 85% $2,460,261.40
3,197,440.00 263,844.31 2,856,094.15 341,345.85 89% 3,084,467.78
3,182,673.41 284,004.97 2,695,855.31 486,818.10 85% 2,460,261.40
$14,766.59 ($20,160.66) $160,238.84 $145,472.25 1,085% $624,206.38
Income Statement
Through 11/30/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 206,129.00 18,756.00 92 1,479,425.00
.00 .00 850,000.00 (850,000.00) +++ .00
1,060,217.00 .00 160,294.00 899,923.00 15 158,320.03
.00 28.54 188.16 (188.16) +++ 432.99
$1,285,102.00 $18,767.54 $1,216,611.16 $68,490.84 95% $1,638,178.02
$1,285,102.00 $18,767.54 $1,216,611.16 $68,490.84 95% $1,638,178.02
.00 14.28 84.18 (84.18) +++ 35,725.99
1,600,000.00 251,950.00 1,412,700.02 187,299.98 88 648,105.00
$1,600,000.00 $251,964.28 $1,412,784.20 $187,215.80 88% $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 $251,964.28 $1,412,784.20 $187,215.80 88% $2,216,619.59
1,285,102.00 18,767.54 1,216,611.16 68,490.84 95% 1,638,178.02
1,600,000.00 251,964.28 1,412,784.20 187,215.80 88% 2,216,619.59
($314,898.00) ($233,196.74) ($196,173.04) $118,724.96 62% ($578,441.57)
Income Statement
Through 11/30/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 819,295.39 9,200,896.74 1,201,142.26 88 9,707,994.97
1,475,000.00 116,667.00 1,340,799.92 134,200.08 91 2,876,171.13
8,890,677.00 751,296.49 8,275,542.28 615,134.72 93 6,492,580.46
$20,767,716.00 $1,687,258.88 $18,824,409.57 $1,943,306.43 91% $21,324,009.02
$20,767,716.00 $1,687,258.88 $18,824,409.57 $1,943,306.43 91% $21,324,009.02
662,619.98 45,706.32 556,520.77 106,099.21 84 618,397.39
2,914,200.00 157,863.20 1,753,534.32 1,160,665.68 60 3,465,872.47
16,641,267.00 1,378,621.54 14,618,604.53 2,022,662.47 88 14,110,030.08
.00 300.00 300.00 (300.00) +++ 300.00
$20,218,086.98 $1,582,491.06 $16,928,959.62 $3,289,127.36 84% $18,194,599.94
$20,218,086.98 $1,582,491.06 $16,928,959.62 $3,289,127.36 84% $18,194,599.94
20,767,716.00 1,687,258.88 18,824,409.57 1,943,306.43 91% 21,324,009.02
20,218,086.98 1,582,491.06 16,928,959.62 3,289,127.36 84% 18,194,599.94
$549,629.02 $104,767.82 $1,895,449.95 $1,345,820.93 345% $3,129,409.08
Income Statement
Through 11/30/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
REVENUE TOTALS
EXPENSE TOTALS
Fund 605 - INSURANCE FUND Net Gain (Loss)
Miscellaneous
Department 99 - NON-DEPARTMENTAL Totals
EXPENSE TOTALS
Fund 605 - INSURANCE FUND Totals
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual
11,815,000.00 2,412,607.96 21,072,844.96 (9,257,844.96) 178 19,601,260.66
2,500,000.00 .00 1,782,092.26 717,907.74 71 2,174,018.22
$14,315,000.00 $2,412,607.96 $22,854,937.22 ($8,539,937.22) 160% $21,775,278.88
$14,315,000.00 $2,412,607.96 $22,854,937.22 ($8,539,937.22) 160% $21,775,278.88
10,805,300.00 872,304.59 9,779,337.26 1,025,962.74 91 10,399,738.82
225,000.00 .00 165,694.26 59,305.74 74 148,468.04
$11,030,300.00 $872,304.59 $9,945,031.52 $1,085,268.48 90% $10,548,206.86
$11,030,300.00 $872,304.59 $9,945,031.52 $1,085,268.48 90% $10,548,206.86
14,315,000.00 2,412,607.96 22,854,937.22 (8,539,937.22) 160% 21,775,278.88
11,030,300.00 872,304.59 9,945,031.52 1,085,268.48 90% 10,548,206.86
$3,284,700.00 $1,540,303.37 $12,909,905.70 $9,625,205.70 393% $11,227,072.02
Income Statement
Through 11/30/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 107,189.00 32,521,338.66 (14,306,638.66) 179 28,106,377.21
1,500,000.00 .00 2,624,734.69 (1,124,734.69) 175 2,579,448.58
$19,714,700.00 $107,189.00 $35,146,073.35 ($15,431,373.35) 178% $30,685,825.79
$19,714,700.00 $107,189.00 $35,146,073.35 ($15,431,373.35) 178% $30,685,825.79
14,326,000.00 1,197,560.06 13,745,310.73 580,689.27 96 13,459,230.47
375,000.00 .00 325,951.10 49,048.90 87 399,999.29
$14,701,000.00 $1,197,560.06 $14,071,261.83 $629,738.17 96% $13,859,229.76
$14,701,000.00 $1,197,560.06 $14,071,261.83 $629,738.17 96% $13,859,229.76
19,714,700.00 107,189.00 35,146,073.35 (15,431,373.35) 178% 30,685,825.79
14,701,000.00 1,197,560.06 14,071,261.83 629,738.17 96% 13,859,229.76
$5,013,700.00 ($1,090,371.06) $21,074,811.52 $16,061,111.52 420% $16,826,596.03
Income Statement
Through 11/30/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
REVENUE TOTALS
EXPENSE TOTALS
Fund 705 - POLICE PENSION FUND Net Gain (Loss)
Miscellaneous
Department 22 - POLICE Totals
EXPENSE TOTALS
Fund 705 - POLICE PENSION FUND Totals