HomeMy WebLinkAbout2022.02 February Monthly Report
To: Kelley A. Gandurski, Interim City Manager
From: Hitesh Desai, CFO/City Treasurer
Subject: February 2022 Monthly Financial Report
Date: April 1, 2022
Please find attached the unaudited financial statements as of February 28, 2022. A summary by fund
for revenues, expenditures, fund and cash balances is as follows:
City of Evanston
Cash & Investment Summary by Fund
February 28, 2022
Fund #Fund Revenue Expense Net Fund Balance Cash Balance
100 General 23,514,062 16,816,596 6,697,466 36,944,627 33,855,362
170 American Rescue Plan 2,953 1,358,333 (1,355,380) 15,457,991 15,457,991
175 General Assistance 237,395 162,676 74,719 685,165 685,262
176 Health and Human Services 53,083 276,861 (223,778) 1,808,346 1,808,156
177 Reparations 2,862 424 2,438 267,062 267,062
180 Good Neighbor 223 93 130 902,293 902,293
200 MFT 531,582 303,219 228,362 5,279,463 5,032,807
205 E911 239,405 194,077 45,328 1,570,951 1,214,227
210 Special Service Area (SSA) #9 75,952 - 75,952 (130,799) (130,799)
215 CDBG 6 59,314 (59,308) 1,515 1,515
220 CD Loan 51,043 - 51,043 361,974 362,732
235 Neighborhood Improvement 5 2 3 22,146 22,146
240 Home 262 10,372 (10,110) 15,626 15,626
250 Affordable Housing 32,058 29,500 2,558 2,634,582 2,780,578
320 Debt Service 2,749,153 7,109 2,742,044 4,032,611 4,032,611
330 Howard Ridge 48,892 66,354 (17,462) 2,810,121 2,810,119
335 West Evanston 228,282 14,170 214,112 3,466,317 3,466,317
340 Dempster-Dodge-TIF 27 28,640 (28,613) 296,391 296,391
345 Chicago Main-TIF 95,244 44,129 51,115 1,002,643 1,002,643
350 Special Service Area (SSA) #6 27,471 0 27,471 29,250 29,250
355 Special Service Area (SSA) #7 24,290 0 24,289 33,004 95,161
360 Special Service Area (SSA) #8 11,455 - 11,455 14,672 (47,485)
415 Capital Improvements 76,716 27,977 48,739 11,585,224 12,007,681
416 Crown Construction 2,092 150,010 (147,918) 5,581,900 5,581,900
417 Crown Community CTR Maintenance 29,167 - 29,167 379,163 379,163
420 Special Assessment 49,874 77,500 (27,626) 2,105,969 2,101,688
505 Parking 1,444,508 1,298,522 145,986 (2,026,271) 684,631
510 Water 3,170,820 2,185,896 984,925 14,064,814 12,717,020
515 Sewer 1,155,325 755,677 399,648 10,075,537 4,804,008
520 Solid Waste 801,251 655,600 145,651 310,053 (341,761)
600 Fleet 522,876 396,114 126,762 845,416 (516,819)
601 Equipment Replacement 304,147 157,493 146,654 375,594 (846,356)
605 Insurance 3,183,493 3,861,004 (677,511) (5,897,978) (1,920,880)
Grand Total 38,665,975 28,937,663 9,728,312 114,905,374 108,610,240
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 February 28, 2022. 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 sh ow the General Fund as of February 28, 2022 with a fund
balance of $36,944,627 and cash balance of $33,855,362 . The attached financials show General
Fund revenues at 20% of budget and expenses at 14 % of budget. The General Fund revenues are
higher mainly because of property tax revenues received.
Staff continues to monitor Police and Fire overtime expenses. Through February, Police had spent
16% of budget for overtime, and Fire had spent 19 % of the annual budget .
Overtime
Expenses
2021 Actual 2022 Budget 2022 YTD % Budget
Enterprise Funds
Parking fund revenues through February 28, 2022, are at 12% of budget and expenses are at 11%.
As the economy continues to improve in post-pandemic time, we expect Parking revenues to
increase.
Through February 28, 2022, overall Water Fund appears low on revenue and expenses. Water Fund
operating revenues and expense s are in line with the budget, b ut capital projects funded with IEPA
loan/debt will take place later in the year. These projects are budgeted in Other Revenue and
expenses in Capital Outlay.
Through February 28, 2022, the Sewer Fund also appears low on expenses mainly due to the capital
projects and debt servic e payments occurring later in the year.
Through February 28, 2022, the Solid Waste Fund has a fund balance of $310,053 and a negative
cash balance of $341,761.
Other Funds
Through February 28, 2022, the SSA #9 Fund is showing negative fund and cash bal ance of
$130,799.
Through February 28, 2022, the Capital Improvements Fund is showing a fund balance of
$11,585,224 and a cash balance of $12,007,681. The fund continues to spend down Series 2021 and
Series 2020 bond proceeds.
Through February 28, 2022, the Crown Construction fund is showing fund and cash balance
of $5,581,900. The fund continues to spend down balances from bond proceeds and gifts from the
Friends of Robert Crown.
Through February 28, 2022, the Insurance Fund is showing a negative fund balance of $5,897,978
and a negative cash balance of $1,920,880. 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 Febru ary 28, 2022 year -to-date financial information and
reports which to the best of my knowledge appear accurate and complete.
Fund Category Governmental Funds
Fund Type GENERAL FUND
Fund 100 - GENERAL FUND
REVENUE
12 LEGISLATIVE .00 .00 .00 .00 +++(200.00)
14 CITY CLERK 80,500.00 (14.00)34.00 80,466.00 0 49.00
15 CITY MANAGER'S OFFICE 76,832,408.00 7,566,702.36 14,825,773.59 62,006,634.41 19 81,180,242.66
17 LAW 537,000.00 52,071.50 100,626.25 436,373.75 19 503,273.80
19 ADMINISTRATIVE SERVICES 3,432,000.00 364,093.55 694,110.32 2,737,889.68 20 3,623,013.25
21 COMMUNITY DEVELOPMENT 4,974,700.00 243,013.25 736,613.86 4,238,086.14 15 6,171,539.34
22 POLICE 1,188,000.00 1,822,140.24 1,879,766.75 (691,766.75)158 12,567,925.87
23 FIRE MGMT & SUPPORT 3,043,600.00 2,746,678.58 3,355,040.99 (311,440.99)110 13,402,233.85
24 HEALTH 874,242.00 85,292.56 486,176.69 388,065.31 56 1,537,028.50
26 PUBLIC WORKS .00 .00 .00 .00 +++5.00
30 PARKS AND RECREATION 5,580,175.00 1,173,916.57 1,403,792.14 4,176,382.86 25 6,363,294.76
40 PUBLIC WORKS AGENCY 644,000.00 25,438.26 32,127.71 611,872.29 5 345,990.52
99 NON-DEPARTMENTAL 20,723,062.00 .00 .00 20,723,062.00 0 .00
REVENUE TOTALS $117,909,687.00 $14,079,332.87 $23,514,062.30 $94,395,624.70 20%$125,694,396.55
EXPENSE
12 LEGISLATIVE .00 .00 .00 .00 +++1,245.00
13 CITY COUNCIL 579,384.00 40,801.39 87,062.95 492,321.05 15 532,135.11
14 CITY CLERK 343,573.00 15,180.73 28,236.76 315,336.24 8 200,419.53
15 CITY MANAGER'S OFFICE 6,232,882.39 382,032.30 745,870.68 5,487,011.71 12 6,262,679.93
17 LAW 970,341.14 60,142.74 109,219.69 861,121.45 11 538,632.06
19 ADMINISTRATIVE SERVICES 11,449,182.64 670,131.62 1,198,416.33 10,250,766.31 10 11,017,111.83
21 COMMUNITY DEVELOPMENT 4,488,316.71 212,551.97 426,959.78 4,061,356.93 10 3,441,972.15
22 POLICE 29,280,597.55 4,274,328.17 6,439,524.78 22,841,072.77 22 39,668,310.09
23 FIRE MGMT & SUPPORT 16,823,271.83 2,741,240.61 4,271,820.06 12,551,451.77 25 26,237,840.19
24 HEALTH 1,453,836.00 144,408.62 274,898.24 1,178,937.76 19 1,999,318.61
30 PARKS AND RECREATION 12,101,740.47 572,149.58 1,075,582.18 11,026,158.29 9 11,218,562.68
40 PUBLIC WORKS AGENCY 13,444,799.45 1,183,163.71 2,159,004.97 11,285,794.48 16 11,864,238.76
99 NON-DEPARTMENTAL 20,723,062.00 .00 .00 20,723,062.00 0 .00
EXPENSE TOTALS $117,890,987.18 $10,296,131.44 $16,816,596.42 $101,074,390.76 14%$112,982,465.94
Fund 100 - GENERAL FUND Totals
REVENUE TOTALS 117,909,687.00 14,079,332.87 23,514,062.30 94,395,624.70 20%125,694,396.55
EXPENSE TOTALS 117,890,987.18 10,296,131.44 16,816,596.42 101,074,390.76 14%112,982,465.94
Fund 100 - GENERAL FUND Net Gain (Loss)$18,699.82 $3,783,201.43 $6,697,465.88 $6,678,766.06 35,816%$12,711,930.61
Fund Type GENERAL FUND Totals
Page 1 of 2Run by Jessica Tapia on 04/05/2022 13:28:37 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualOrganizationOrganization Description
Fund Category Governmental Funds
REVENUE TOTALS 117,909,687.00 14,079,332.87 23,514,062.30 94,395,624.70 20%125,694,396.55
EXPENSE TOTALS 117,890,987.18 10,296,131.44 16,816,596.42 101,074,390.76 14%112,982,465.94
Fund Type GENERAL FUND Net Gain (Loss)$18,699.82 $3,783,201.43 $6,697,465.88 $6,678,766.06 35,816%$12,711,930.61
Fund Category Governmental Funds Totals
REVENUE TOTALS 117,909,687.00 14,079,332.87 23,514,062.30 94,395,624.70 20%125,694,396.55
EXPENSE TOTALS 117,890,987.18 10,296,131.44 16,816,596.42 101,074,390.76 14%112,982,465.94
Fund Category Governmental Funds Net Gain (Loss)$18,699.82 $3,783,201.43 $6,697,465.88 $6,678,766.06 35,816%$12,711,930.61
Grand Totals
REVENUE TOTALS 117,909,687.00 14,079,332.87 23,514,062.30 94,395,624.70 20%125,694,396.55
EXPENSE TOTALS 117,890,987.18 10,296,131.44 16,816,596.42 101,074,390.76 14%112,982,465.94
Grand Total Net Gain (Loss)$18,699.82 $3,783,201.43 $6,697,465.88 $6,678,766.06 35,816%$12,711,930.61
Page 2 of 2Run by Jessica Tapia on 04/05/2022 13:28:37 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualOrganizationOrganization Description
Fund Category Governmental Funds
Fund Type GENERAL FUND
Fund 176 - HUMAN SERVICES FUND
REVENUE
Department 24 - HEALTH
Property Taxes 3,110,000.00 .00 .00 3,110,000.00 0 3,110,000.00
Interfund Transfers .00 .00 .00 .00 +++450,000.00
Intergovernmental Revenue 194,000.00 25,888.67 52,477.34 141,522.66 27 221,265.60
Other Revenue 2,000.00 .00 .00 2,000.00 0 2,940.00
Interest Income .00 144.47 605.63 (605.63)+++1,601.63
Department 24 - HEALTH Totals $3,306,000.00 $26,033.14 $53,082.97 $3,252,917.03 2%$3,785,807.23
REVENUE TOTALS $3,306,000.00 $26,033.14 $53,082.97 $3,252,917.03 2%$3,785,807.23
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies 736,373.00 .00 .00 736,373.00 0 .00
Department 21 - COMMUNITY DEVELOPMENT Totals $736,373.00 $0.00 $0.00 $736,373.00 0%$0.00
Department 24 - HEALTH
Salary and Benefits 1,705,819.94 112,547.00 217,779.64 1,488,040.30 13 1,580,847.63
Services and Supplies 1,024,810.00 18,766.89 18,997.39 1,005,812.61 2 460,374.37
Insurance and Other Chargebacks .00 .00 .00 .00 +++8,861.29
Community Sponsored Organizations 143,333.00 26,700.00 26,700.00 116,633.00 19 498,019.53
Miscellaneous 258,000.00 183.62 13,384.03 244,615.97 5 175,643.87
Department 24 - HEALTH Totals $3,131,962.94 $158,197.51 $276,861.06 $2,855,101.88 9%$2,723,746.69
EXPENSE TOTALS $3,868,335.94 $158,197.51 $276,861.06 $3,591,474.88 7%$2,723,746.69
Fund 176 - HUMAN SERVICES FUND Totals
REVENUE TOTALS 3,306,000.00 26,033.14 53,082.97 3,252,917.03 2%3,785,807.23
EXPENSE TOTALS 3,868,335.94 158,197.51 276,861.06 3,591,474.88 7%2,723,746.69
Fund 176 - HUMAN SERVICES FUND Net Gain (Loss)($562,335.94)($132,164.37)($223,778.09)$338,557.85 40%$1,062,060.54
Page 1 of 44Run by Jessica Tapia on 04/05/2022 13:23:01 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 170 - AMERICAN RESCUE PLAN
REVENUE
Department 99 - NON-DEPARTMENTAL
Intergovernmental Revenue 21,586,827.00 .00 .00 21,586,827.00 0 21,586,827.00
Interest Income .00 810.89 2,952.87 (2,952.87)+++26,544.74
Department 99 - NON-DEPARTMENTAL Totals $21,586,827.00 $810.89 $2,952.87 $21,583,874.13 0%$21,613,371.74
REVENUE TOTALS $21,586,827.00 $810.89 $2,952.87 $21,583,874.13 0%$21,613,371.74
EXPENSE
Department 99 - NON-DEPARTMENTAL
Miscellaneous 22,250,000.00 .00 .00 22,250,000.00 0 .00
Interfund Transfers 8,150,000.00 679,166.67 1,358,333.34 6,791,666.66 17 4,800,000.00
Department 99 - NON-DEPARTMENTAL Totals $30,400,000.00 $679,166.67 $1,358,333.34 $29,041,666.66 4%$4,800,000.00
EXPENSE TOTALS $30,400,000.00 $679,166.67 $1,358,333.34 $29,041,666.66 4%$4,800,000.00
Fund 170 - AMERICAN RESCUE PLAN Totals
REVENUE TOTALS 21,586,827.00 810.89 2,952.87 21,583,874.13 0%21,613,371.74
EXPENSE TOTALS 30,400,000.00 679,166.67 1,358,333.34 29,041,666.66 4%4,800,000.00
Fund 170 - AMERICAN RESCUE PLAN Net Gain (Loss)($8,813,173.00)($678,355.78)($1,355,380.47)$7,457,792.53 15%$16,813,371.74
Page 3 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 175 - GENERAL ASSISTANCE FUND
REVENUE
Department 24 - HEALTH
Property Taxes 1,300,000.00 207,748.81 211,458.64 1,088,541.36 16 1,318,390.85
Other Revenue 27,500.00 436.00 25,712.56 1,787.44 94 2,585.00
Interest Income 1,000.00 102.75 223.77 776.23 22 1,445.64
Department 24 - HEALTH Totals $1,328,500.00 $208,287.56 $237,394.97 $1,091,105.03 18%$1,322,421.49
REVENUE TOTALS $1,328,500.00 $208,287.56 $237,394.97 $1,091,105.03 18%$1,322,421.49
EXPENSE
Department 24 - HEALTH
Salary and Benefits 469,870.53 36,061.89 72,814.83 397,055.70 15 495,273.49
Services and Supplies 864,482.00 48,334.19 89,861.47 774,620.53 10 601,561.03
Miscellaneous 7,000.00 .00 .00 7,000.00 0 4,676.28
Department 24 - HEALTH Totals $1,341,352.53 $84,396.08 $162,676.30 $1,178,676.23 12%$1,101,510.80
EXPENSE TOTALS $1,341,352.53 $84,396.08 $162,676.30 $1,178,676.23 12%$1,101,510.80
Fund 175 - GENERAL ASSISTANCE FUND Totals
REVENUE TOTALS 1,328,500.00 208,287.56 237,394.97 1,091,105.03 18%1,322,421.49
EXPENSE TOTALS 1,341,352.53 84,396.08 162,676.30 1,178,676.23 12%1,101,510.80
Fund 175 - GENERAL ASSISTANCE FUND Net Gain (Loss)($12,852.53)$123,891.48 $74,718.67 $87,571.20 (581%)$220,910.69
Page 4 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 177 - REPARATIONS FUND
REVENUE
Department 15 - CITY MANAGER'S OFFICE
Other Taxes 400,000.00 .00 .00 400,000.00 0 .00
Other Revenue .00 275.00 2,775.00 (2,775.00)+++48,187.29
Interest Income .00 44.42 87.10 (87.10)+++391.22
Department 15 - CITY MANAGER'S OFFICE Totals $400,000.00 $319.42 $2,862.10 $397,137.90 1%$48,578.51
REVENUE TOTALS $400,000.00 $319.42 $2,862.10 $397,137.90 1%$48,578.51
EXPENSE
Department 15 - CITY MANAGER'S OFFICE
Services and Supplies .00 168.94 423.92 (423.92)+++2,095.79
Miscellaneous 400,000.00 .00 .00 400,000.00 0 .00
Department 15 - CITY MANAGER'S OFFICE Totals $400,000.00 $168.94 $423.92 $399,576.08 0%$2,095.79
EXPENSE TOTALS $400,000.00 $168.94 $423.92 $399,576.08 0%$2,095.79
Fund 177 - REPARATIONS FUND Totals
REVENUE TOTALS 400,000.00 319.42 2,862.10 397,137.90 1%48,578.51
EXPENSE TOTALS 400,000.00 168.94 423.92 399,576.08 0%2,095.79
Fund 177 - REPARATIONS FUND Net Gain (Loss)$0.00 $150.48 $2,438.18 $2,438.18 +++$46,482.72
Page 5 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 180 - GOOD NEIGHBOR FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Other Revenue .00 .00 .00 .00 +++1,000,000.00
Interest Income .00 60.97 223.40 (223.40)+++883.93
Department 99 - NON-DEPARTMENTAL Totals $0.00 $60.97 $223.40 ($223.40)+++$1,000,883.93
REVENUE TOTALS $0.00 $60.97 $223.40 ($223.40)+++$1,000,883.93
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies .00 26.97 93.32 (93.32)+++466.38
Miscellaneous 1,000,000.00 .00 .00 1,000,000.00 0 34,920.59
Interfund Transfers .00 .00 .00 .00 +++414,151.77
Department 99 - NON-DEPARTMENTAL Totals $1,000,000.00 $26.97 $93.32 $999,906.68 0%$449,538.74
EXPENSE TOTALS $1,000,000.00 $26.97 $93.32 $999,906.68 0%$449,538.74
Fund 180 - GOOD NEIGHBOR FUND Totals
REVENUE TOTALS .00 60.97 223.40 (223.40)+++1,000,883.93
EXPENSE TOTALS 1,000,000.00 26.97 93.32 999,906.68 0%449,538.74
Fund 180 - GOOD NEIGHBOR FUND Net Gain (Loss)($1,000,000.00)$34.00 $130.08 $1,000,130.08 0%$551,345.19
Page 6 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 185 - LIBRARY FUND
REVENUE
Department 48 - LIBRARY
Property Taxes 7,252,000.00 1,149,665.35 1,168,916.68 6,083,083.32 16 7,298,616.48
Licenses, Permits and Fees 115,767.00 .00 .00 115,767.00 0 .00
Fines and Forfeitures .00 .00 .00 .00 +++4,466.46
Charges for Services .00 .00 34.58 (34.58)+++287.03
Interfund Transfers 217,911.00 .00 .00 217,911.00 0 250,000.00
Intergovernmental Revenue 472,866.00 9,211.99 9,211.99 463,654.01 2 330,037.73
Other Revenue 410,000.00 1,947.28 5,560.36 404,439.64 1 438,206.07
Library Revenue 174,800.00 7,134.48 11,375.89 163,424.11 7 118,262.91
Interest Income 15,000.00 401.54 916.40 14,083.60 6 10,403.29
Department 48 - LIBRARY Totals $8,658,344.00 $1,168,360.64 $1,196,015.90 $7,462,328.10 14%$8,450,279.97
REVENUE TOTALS $8,658,344.00 $1,168,360.64 $1,196,015.90 $7,462,328.10 14%$8,450,279.97
EXPENSE
Department 48 - LIBRARY
Salary and Benefits 6,132,692.20 423,740.77 690,762.43 5,441,929.77 11 5,514,203.32
Services and Supplies 2,136,767.00 132,787.02 136,661.73 2,000,105.27 6 2,017,312.21
Capital Outlay 8,500.00 .00 .00 8,500.00 0 1,463.52
Miscellaneous .00 14,085.92 27,491.82 (27,491.82)+++1,500.00
Interfund Transfers 379,653.00 31,637.75 63,275.50 316,377.50 17 361,212.00
Department 48 - LIBRARY Totals $8,657,612.20 $602,251.46 $918,191.48 $7,739,420.72 11%$7,895,691.05
EXPENSE TOTALS $8,657,612.20 $602,251.46 $918,191.48 $7,739,420.72 11%$7,895,691.05
Fund 185 - LIBRARY FUND Totals
REVENUE TOTALS 8,658,344.00 1,168,360.64 1,196,015.90 7,462,328.10 14%8,450,279.97
EXPENSE TOTALS 8,657,612.20 602,251.46 918,191.48 7,739,420.72 11%7,895,691.05
Fund 185 - LIBRARY FUND Net Gain (Loss)$731.80 $566,109.18 $277,824.42 $277,092.62 37,965%$554,588.92
Page 7 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 200 - MOTOR FUEL TAX FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Intergovernmental Revenue 3,656,700.00 253,378.85 530,367.33 3,126,332.67 15 4,525,093.15
Interest Income 12,000.00 619.38 1,214.29 10,785.71 10 4,985.72
Department 40 - PUBLIC WORKS AGENCY Totals $3,668,700.00 $253,998.23 $531,581.62 $3,137,118.38 14%$4,530,078.87
REVENUE TOTALS $3,668,700.00 $253,998.23 $531,581.62 $3,137,118.38 14%$4,530,078.87
EXPENSE
Department 26 - PUBLIC WORKS
Capital Outlay .00 .00 .00 .00 +++163,434.00
Department 26 - PUBLIC WORKS Totals $0.00 $0.00 $0.00 $0.00 +++$163,434.00
Department 40 - PUBLIC WORKS AGENCY
Services and Supplies 1,038,000.00 129,054.70 129,054.70 908,945.30 12 844,024.91
Capital Outlay 3,261,000.00 .00 .00 3,261,000.00 0 1,389,278.60
Interfund Transfers 1,044,987.00 87,082.25 174,164.50 870,822.50 17 1,044,984.00
Department 40 - PUBLIC WORKS AGENCY Totals $5,343,987.00 $216,136.95 $303,219.20 $5,040,767.80 6%$3,278,287.51
EXPENSE TOTALS $5,343,987.00 $216,136.95 $303,219.20 $5,040,767.80 6%$3,441,721.51
Fund 200 - MOTOR FUEL TAX FUND Totals
REVENUE TOTALS 3,668,700.00 253,998.23 531,581.62 3,137,118.38 14%4,530,078.87
EXPENSE TOTALS 5,343,987.00 216,136.95 303,219.20 5,040,767.80 6%3,441,721.51
Fund 200 - MOTOR FUEL TAX FUND Net Gain (Loss)($1,675,287.00)$37,861.28 $228,362.42 $1,903,649.42 (14%)$1,088,357.36
Page 9 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 205 - EMERGENCY TELEPHONE (E911) FUND
REVENUE
Department 22 - POLICE
Other Taxes 1,400,000.00 239,161.22 239,161.22 1,160,838.78 17 1,442,228.44
Other Revenue .00 .00 .00 .00 +++641.17
Interest Income 7,000.00 65.99 244.15 6,755.85 3 735.62
Department 22 - POLICE Totals $1,407,000.00 $239,227.21 $239,405.37 $1,167,594.63 17%$1,443,605.23
REVENUE TOTALS $1,407,000.00 $239,227.21 $239,405.37 $1,167,594.63 17%$1,443,605.23
EXPENSE
Department 22 - POLICE
Salary and Benefits 768,615.60 58,907.40 115,505.29 653,110.31 15 601,010.24
Services and Supplies 393,700.00 23,192.51 36,883.34 356,816.66 9 340,785.60
Capital Outlay 450,000.00 23,650.35 23,650.35 426,349.65 5 256,588.76
Insurance and Other Chargebacks 18,230.00 1,519.17 3,038.34 15,191.66 17 18,228.00
Miscellaneous .00 .00 .00 .00 +++1,000.00
Interfund Transfers 90,000.00 7,500.00 15,000.00 75,000.00 17 90,000.00
Department 22 - POLICE Totals $1,720,545.60 $114,769.43 $194,077.32 $1,526,468.28 11%$1,307,612.60
EXPENSE TOTALS $1,720,545.60 $114,769.43 $194,077.32 $1,526,468.28 11%$1,307,612.60
Fund 205 - EMERGENCY TELEPHONE (E911) FUND Totals
REVENUE TOTALS 1,407,000.00 239,227.21 239,405.37 1,167,594.63 17%1,443,605.23
EXPENSE TOTALS 1,720,545.60 114,769.43 194,077.32 1,526,468.28 11%1,307,612.60
Fund 205 - EMERGENCY TELEPHONE (E911) FUND Net Gain (Loss)($313,545.60)$124,457.78 $45,328.05 $358,873.65 (14%)$135,992.63
Page 10 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 210 - SPECIAL SERVICE AREA (SSA) #9
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Property Taxes 595,000.00 75,758.10 75,951.51 519,048.49 13 603,007.19
Interest Income .00 .00 .00 .00 +++28.29
Department 21 - COMMUNITY DEVELOPMENT Totals $595,000.00 $75,758.10 $75,951.51 $519,048.49 13%$603,035.48
REVENUE TOTALS $595,000.00 $75,758.10 $75,951.51 $519,048.49 13%$603,035.48
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies 575,000.00 .00 .00 575,000.00 0 595,125.30
Department 21 - COMMUNITY DEVELOPMENT Totals $575,000.00 $0.00 $0.00 $575,000.00 0%$595,125.30
EXPENSE TOTALS $575,000.00 $0.00 $0.00 $575,000.00 0%$595,125.30
Fund 210 - SPECIAL SERVICE AREA (SSA) #9 Totals
REVENUE TOTALS 595,000.00 75,758.10 75,951.51 519,048.49 13%603,035.48
EXPENSE TOTALS 575,000.00 .00 .00 575,000.00 0%595,125.30
Fund 210 - SPECIAL SERVICE AREA (SSA) #9 Net Gain (Loss)$20,000.00 $75,758.10 $75,951.51 $55,951.51 380%$7,910.18
Page 11 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 215 - CDBG FUND
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Intergovernmental Revenue 3,684,820.00 .00 .00 3,684,820.00 0 2,317,923.49
Interest Income .00 6.07 6.07 (6.07)+++.00
Department 21 - COMMUNITY DEVELOPMENT Totals $3,684,820.00 $6.07 $6.07 $3,684,813.93 0%$2,317,923.49
REVENUE TOTALS $3,684,820.00 $6.07 $6.07 $3,684,813.93 0%$2,317,923.49
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Salary and Benefits 589,421.52 28,751.98 57,411.31 532,010.21 10 356,130.39
Services and Supplies 506,200.00 1,854.13 1,860.57 504,339.43 0 42,137.12
Capital Outlay .00 .00 .00 .00 +++476,341.73
Insurance and Other Chargebacks .00 .00 .00 .00 +++352,222.69
Community Sponsored Organizations 75,000.00 .00 .00 75,000.00 0 927,080.49
Miscellaneous 2,515,000.00 42.40 42.40 2,514,957.60 0 164,011.07
Department 21 - COMMUNITY DEVELOPMENT Totals $3,685,621.52 $30,648.51 $59,314.28 $3,626,307.24 2%$2,317,923.49
EXPENSE TOTALS $3,685,621.52 $30,648.51 $59,314.28 $3,626,307.24 2%$2,317,923.49
Fund 215 - CDBG FUND Totals
REVENUE TOTALS 3,684,820.00 6.07 6.07 3,684,813.93 0%2,317,923.49
EXPENSE TOTALS 3,685,621.52 30,648.51 59,314.28 3,626,307.24 2%2,317,923.49
Fund 215 - CDBG FUND Net Gain (Loss)($801.52)($30,642.44)($59,308.21)($58,506.69)7,399%$0.00
Page 12 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 220 - CDBG LOAN FUND
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Other Revenue 100,000.00 47,362.57 50,931.45 49,068.55 51 172,475.57
Interest Income .00 31.33 112.01 (112.01)+++.00
Department 21 - COMMUNITY DEVELOPMENT Totals $100,000.00 $47,393.90 $51,043.46 $48,956.54 51%$172,475.57
REVENUE TOTALS $100,000.00 $47,393.90 $51,043.46 $48,956.54 51%$172,475.57
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies 175,000.00 .00 .00 175,000.00 0 44,369.59
Department 21 - COMMUNITY DEVELOPMENT Totals $175,000.00 $0.00 $0.00 $175,000.00 0%$44,369.59
EXPENSE TOTALS $175,000.00 $0.00 $0.00 $175,000.00 0%$44,369.59
Fund 220 - CDBG LOAN FUND Totals
REVENUE TOTALS 100,000.00 47,393.90 51,043.46 48,956.54 51%172,475.57
EXPENSE TOTALS 175,000.00 .00 .00 175,000.00 0%44,369.59
Fund 220 - CDBG LOAN FUND Net Gain (Loss)($75,000.00)$47,393.90 $51,043.46 $126,043.46 (68%)$128,105.98
Page 13 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 235 - NEIGHBORHOOD IMPROVEMENT
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Interest Income .00 1.50 5.48 (5.48)+++22.09
Department 21 - COMMUNITY DEVELOPMENT Totals $0.00 $1.50 $5.48 ($5.48)+++$22.09
REVENUE TOTALS $0.00 $1.50 $5.48 ($5.48)+++$22.09
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies .00 .66 2.29 (2.29)+++.00
Department 21 - COMMUNITY DEVELOPMENT Totals $0.00 $0.66 $2.29 ($2.29)+++$0.00
EXPENSE TOTALS $0.00 $0.66 $2.29 ($2.29)+++$0.00
Fund 235 - NEIGHBORHOOD IMPROVEMENT Totals
REVENUE TOTALS .00 1.50 5.48 (5.48)+++22.09
EXPENSE TOTALS .00 .66 2.29 (2.29)+++.00
Fund 235 - NEIGHBORHOOD IMPROVEMENT Net Gain (Loss)$0.00 $0.84 $3.19 $3.19 +++$22.09
Page 14 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 240 - HOME FUND
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Intergovernmental Revenue 540,453.00 .00 .00 540,453.00 0 504,713.62
Other Revenue 25,000.00 125.00 250.00 24,750.00 1 35,955.41
Interest Income 150.00 5.22 11.81 138.19 8 94.16
Department 21 - COMMUNITY DEVELOPMENT Totals $565,603.00 $130.22 $261.81 $565,341.19 0%$540,763.19
REVENUE TOTALS $565,603.00 $130.22 $261.81 $565,341.19 0%$540,763.19
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Salary and Benefits 70,680.63 4,886.29 9,771.33 60,909.30 14 58,507.28
Services and Supplies 500,565.00 595.00 600.24 499,964.76 0 488,948.85
Insurance and Other Chargebacks .00 .00 .00 .00 +++(2,965.34)
Miscellaneous 500.00 .00 .00 500.00 0 101.50
Department 21 - COMMUNITY DEVELOPMENT Totals $571,745.63 $5,481.29 $10,371.57 $561,374.06 2%$544,592.29
EXPENSE TOTALS $571,745.63 $5,481.29 $10,371.57 $561,374.06 2%$544,592.29
Fund 240 - HOME FUND Totals
REVENUE TOTALS 565,603.00 130.22 261.81 565,341.19 0%540,763.19
EXPENSE TOTALS 571,745.63 5,481.29 10,371.57 561,374.06 2%544,592.29
Fund 240 - HOME FUND Net Gain (Loss)($6,142.63)($5,351.07)($10,109.76)($3,967.13)165%($3,829.10)
Page 15 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 250 - AFFORDABLE HOUSING FUND
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Other Taxes 75,000.00 .00 .00 75,000.00 0 15,453.00
Intergovernmental Revenue 658,000.00 .00 .00 658,000.00 0 623,954.63
Other Revenue 140,600.00 31,250.00 31,250.00 109,350.00 22 129,166.70
Interest Income 5,700.00 375.32 808.27 4,891.73 14 7,428.56
Department 21 - COMMUNITY DEVELOPMENT Totals $879,300.00 $31,625.32 $32,058.27 $847,241.73 4%$776,002.89
REVENUE TOTALS $879,300.00 $31,625.32 $32,058.27 $847,241.73 4%$776,002.89
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Salary and Benefits 180,075.00 13,966.79 27,677.74 152,397.26 15 174,931.83
Services and Supplies 2,065,050.00 5.00 10.00 2,065,040.00 0 1,294,027.21
Capital Outlay 10,000.00 .00 .00 10,000.00 0 4,200.00
Insurance and Other Chargebacks 17,000.00 .00 .00 17,000.00 0 (54,375.72)
Community Sponsored Organizations 166,000.00 .00 .00 166,000.00 0 507,564.69
Miscellaneous 67,500.00 629.81 1,812.31 65,687.69 3 19,413.66
Department 21 - COMMUNITY DEVELOPMENT Totals $2,505,625.00 $14,601.60 $29,500.05 $2,476,124.95 1%$1,945,761.67
EXPENSE TOTALS $2,505,625.00 $14,601.60 $29,500.05 $2,476,124.95 1%$1,945,761.67
Fund 250 - AFFORDABLE HOUSING FUND Totals
REVENUE TOTALS 879,300.00 31,625.32 32,058.27 847,241.73 4%776,002.89
EXPENSE TOTALS 2,505,625.00 14,601.60 29,500.05 2,476,124.95 1%1,945,761.67
Fund 250 - AFFORDABLE HOUSING FUND Net Gain (Loss)($1,626,325.00)$17,023.72 $2,558.22 $1,628,883.22 0%($1,169,758.78)
Fund Type Special Revenue Funds Totals
REVENUE TOTALS 42,874,094.00 2,025,980.03 2,369,762.83 40,504,331.17 6%43,287,617.77
EXPENSE TOTALS 56,376,489.48 1,749,508.56 3,038,063.07 53,338,426.41 5%24,445,942.83
Fund Type Special Revenue Funds Net Gain (Loss)($13,502,395.48)$276,471.47 ($668,300.24)$12,834,095.24 5%$18,841,674.94
Page 17 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 186 - LIBRARY DEBT SERVICE FUND
REVENUE
Department 48 - LIBRARY
Property Taxes 506,625.00 .00 .00 506,625.00 0 482,243.00
Department 48 - LIBRARY Totals $506,625.00 $0.00 $0.00 $506,625.00 0%$482,243.00
REVENUE TOTALS $506,625.00 $0.00 $0.00 $506,625.00 0%$482,243.00
EXPENSE
Department 48 - LIBRARY
Debt Service 506,625.00 .00 .00 506,625.00 0 482,243.89
Department 48 - LIBRARY Totals $506,625.00 $0.00 $0.00 $506,625.00 0%$482,243.89
EXPENSE TOTALS $506,625.00 $0.00 $0.00 $506,625.00 0%$482,243.89
Fund 186 - LIBRARY DEBT SERVICE FUND Totals
REVENUE TOTALS 506,625.00 .00 .00 506,625.00 0%482,243.00
EXPENSE TOTALS 506,625.00 .00 .00 506,625.00 0%482,243.89
Fund 186 - LIBRARY DEBT SERVICE FUND Net Gain (Loss)$0.00 $0.00 $0.00 $0.00 +++($0.89)
Page 18 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 330 - HOWARD-RIDGE TIF FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes 1,100,000.00 40,375.93 40,375.93 1,059,624.07 4 1,241,923.98
Other Revenue 5,366.00 3,947.23 7,894.46 (2,528.46)147 27,381.64
Interest Income 400.00 273.33 621.84 (221.84)155 6,384.08
Department 99 - NON-DEPARTMENTAL Totals $1,105,766.00 $44,596.49 $48,892.23 $1,056,873.77 4%$1,275,689.70
REVENUE TOTALS $1,105,766.00 $44,596.49 $48,892.23 $1,056,873.77 4%$1,275,689.70
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 265,000.00 1.04 1.84 264,998.16 0 155,849.02
Capital Outlay 785,000.00 .00 .00 785,000.00 0 391,989.20
Miscellaneous .00 .00 .00 .00 +++18,200.00
Interfund Transfers 398,113.00 33,176.08 66,352.16 331,760.84 17 218,112.00
Department 99 - NON-DEPARTMENTAL Totals $1,448,113.00 $33,177.12 $66,354.00 $1,381,759.00 5%$784,150.22
EXPENSE TOTALS $1,448,113.00 $33,177.12 $66,354.00 $1,381,759.00 5%$784,150.22
Fund 330 - HOWARD-RIDGE TIF FUND Totals
REVENUE TOTALS 1,105,766.00 44,596.49 48,892.23 1,056,873.77 4%1,275,689.70
EXPENSE TOTALS 1,448,113.00 33,177.12 66,354.00 1,381,759.00 5%784,150.22
Fund 330 - HOWARD-RIDGE TIF FUND Net Gain (Loss)($342,347.00)$11,419.37 ($17,461.77)$324,885.23 5%$491,539.48
Page 19 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 335 - WEST EVANSTON TIF FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes 1,450,000.00 223,651.55 228,014.10 1,221,985.90 16 1,774,424.08
Other Revenue 11,000.00 .00 .00 11,000.00 0 171,504.26
Interest Income 4,000.00 133.05 267.50 3,732.50 7 5,468.09
Department 99 - NON-DEPARTMENTAL Totals $1,465,000.00 $223,784.60 $228,281.60 $1,236,718.40 16%$1,951,396.43
REVENUE TOTALS $1,465,000.00 $223,784.60 $228,281.60 $1,236,718.40 16%$1,951,396.43
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 5,000.00 4.15 1,669.87 3,330.13 33 68,183.57
Capital Outlay 1,765,000.00 .00 .00 1,765,000.00 0 332,637.00
Miscellaneous 200,000.00 .00 .00 200,000.00 0 18,000.00
Interfund Transfers 75,000.00 6,250.00 12,500.00 62,500.00 17 75,000.00
Department 99 - NON-DEPARTMENTAL Totals $2,045,000.00 $6,254.15 $14,169.87 $2,030,830.13 1%$493,820.57
EXPENSE TOTALS $2,045,000.00 $6,254.15 $14,169.87 $2,030,830.13 1%$493,820.57
Fund 335 - WEST EVANSTON TIF FUND Totals
REVENUE TOTALS 1,465,000.00 223,784.60 228,281.60 1,236,718.40 16%1,951,396.43
EXPENSE TOTALS 2,045,000.00 6,254.15 14,169.87 2,030,830.13 1%493,820.57
Fund 335 - WEST EVANSTON TIF FUND Net Gain (Loss)($580,000.00)$217,530.45 $214,111.73 $794,111.73 (37%)$1,457,575.86
Page 20 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 340 - DEMPSTER-DODGE TIF FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes 160,000.00 .00 .00 160,000.00 0 282,948.21
Interest Income .00 13.29 26.63 (26.63)+++538.94
Department 99 - NON-DEPARTMENTAL Totals $160,000.00 $13.29 $26.63 $159,973.37 0%$283,487.15
REVENUE TOTALS $160,000.00 $13.29 $26.63 $159,973.37 0%$283,487.15
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 2,000.00 .41 .73 1,999.27 0 1,821.75
Interfund Transfers 171,833.00 14,319.41 28,638.82 143,194.18 17 168,924.00
Department 99 - NON-DEPARTMENTAL Totals $173,833.00 $14,319.82 $28,639.55 $145,193.45 16%$170,745.75
EXPENSE TOTALS $173,833.00 $14,319.82 $28,639.55 $145,193.45 16%$170,745.75
Fund 340 - DEMPSTER-DODGE TIF FUND Totals
REVENUE TOTALS 160,000.00 13.29 26.63 159,973.37 0%283,487.15
EXPENSE TOTALS 173,833.00 14,319.82 28,639.55 145,193.45 16%170,745.75
Fund 340 - DEMPSTER-DODGE TIF FUND Net Gain (Loss)($13,833.00)($14,306.53)($28,612.92)($14,779.92)207%$112,741.40
Page 21 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 345 - CHICAGO-MAIN TIF
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes 1,000,000.00 87,340.65 95,165.63 904,834.37 10 1,207,607.53
Interest Income .00 39.22 78.82 (78.82)+++2,772.11
Department 99 - NON-DEPARTMENTAL Totals $1,000,000.00 $87,379.87 $95,244.45 $904,755.55 10%$1,210,379.64
REVENUE TOTALS $1,000,000.00 $87,379.87 $95,244.45 $904,755.55 10%$1,210,379.64
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 5,000.00 1.22 2.17 4,997.83 0 1,835.12
Capital Outlay 1,090,000.00 .00 .00 1,090,000.00 0 1,308,890.49
Miscellaneous 250,000.00 .00 .00 250,000.00 0 9,950.00
Interfund Transfers 264,763.00 22,063.58 44,127.16 220,635.84 17 262,848.00
Department 99 - NON-DEPARTMENTAL Totals $1,609,763.00 $22,064.80 $44,129.33 $1,565,633.67 3%$1,583,523.61
EXPENSE TOTALS $1,609,763.00 $22,064.80 $44,129.33 $1,565,633.67 3%$1,583,523.61
Fund 345 - CHICAGO-MAIN TIF Totals
REVENUE TOTALS 1,000,000.00 87,379.87 95,244.45 904,755.55 10%1,210,379.64
EXPENSE TOTALS 1,609,763.00 22,064.80 44,129.33 1,565,633.67 3%1,583,523.61
Fund 345 - CHICAGO-MAIN TIF Net Gain (Loss)($609,763.00)$65,315.07 $51,115.12 $660,878.12 (8%)($373,143.97)
Page 22 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 350 - SPECIAL SERVICE AREA (SSA) #6
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes 221,000.00 26,018.22 27,470.72 193,529.28 12 221,554.12
Interest Income .00 .13 .29 (.29)+++66.54
Department 99 - NON-DEPARTMENTAL Totals $221,000.00 $26,018.35 $27,471.01 $193,528.99 12%$221,620.66
REVENUE TOTALS $221,000.00 $26,018.35 $27,471.01 $193,528.99 12%$221,620.66
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 221,000.00 .01 .01 220,999.99 0 223,914.21
Department 99 - NON-DEPARTMENTAL Totals $221,000.00 $0.01 $0.01 $220,999.99 0%$223,914.21
EXPENSE TOTALS $221,000.00 $0.01 $0.01 $220,999.99 0%$223,914.21
Fund 350 - SPECIAL SERVICE AREA (SSA) #6 Totals
REVENUE TOTALS 221,000.00 26,018.35 27,471.01 193,528.99 12%221,620.66
EXPENSE TOTALS 221,000.00 .01 .01 220,999.99 0%223,914.21
Fund 350 - SPECIAL SERVICE AREA (SSA) #6 Net Gain (Loss)$0.00 $26,018.34 $27,471.00 $27,471.00 +++($2,293.55)
Page 23 of 44Run by Jessica Tapia on 04/05/2022 13:23:02 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 355 - SPECIAL SERVICE AREA (SSA) #7
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes 142,000.00 22,134.14 24,283.63 117,716.37 17 144,157.43
Interest Income .00 2.98 6.02 (6.02)+++102.44
Department 99 - NON-DEPARTMENTAL Totals $142,000.00 $22,137.12 $24,289.65 $117,710.35 17%$144,259.87
REVENUE TOTALS $142,000.00 $22,137.12 $24,289.65 $117,710.35 17%$144,259.87
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 140,000.00 .09 .16 139,999.84 0 135,898.36
Department 99 - NON-DEPARTMENTAL Totals $140,000.00 $0.09 $0.16 $139,999.84 0%$135,898.36
EXPENSE TOTALS $140,000.00 $0.09 $0.16 $139,999.84 0%$135,898.36
Fund 355 - SPECIAL SERVICE AREA (SSA) #7 Totals
REVENUE TOTALS 142,000.00 22,137.12 24,289.65 117,710.35 17%144,259.87
EXPENSE TOTALS 140,000.00 .09 .16 139,999.84 0%135,898.36
Fund 355 - SPECIAL SERVICE AREA (SSA) #7 Net Gain (Loss)$2,000.00 $22,137.03 $24,289.49 $22,289.49 1,214%$8,361.51
Page 24 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 360 - SPECIAL SERVICE AREA (SSA) #8
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes 60,200.00 11,454.76 11,454.76 48,745.24 19 49,544.06
Interest Income .00 (.04).00 .00 +++11,207.75
Department 99 - NON-DEPARTMENTAL Totals $60,200.00 $11,454.72 $11,454.76 $48,745.24 19%$60,751.81
REVENUE TOTALS $60,200.00 $11,454.72 $11,454.76 $48,745.24 19%$60,751.81
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 60,200.00 .00 .00 60,200.00 0 58,580.02
Department 99 - NON-DEPARTMENTAL Totals $60,200.00 $0.00 $0.00 $60,200.00 0%$58,580.02
EXPENSE TOTALS $60,200.00 $0.00 $0.00 $60,200.00 0%$58,580.02
Fund 360 - SPECIAL SERVICE AREA (SSA) #8 Totals
REVENUE TOTALS 60,200.00 11,454.72 11,454.76 48,745.24 19%60,751.81
EXPENSE TOTALS 60,200.00 .00 .00 60,200.00 0%58,580.02
Fund 360 - SPECIAL SERVICE AREA (SSA) #8 Net Gain (Loss)$0.00 $11,454.72 $11,454.76 $11,454.76 +++$2,171.79
Fund Type Debt Service Funds Totals
REVENUE TOTALS 4,660,591.00 415,384.44 435,660.33 4,224,930.67 9%5,629,828.26
EXPENSE TOTALS 6,204,534.00 75,815.99 153,292.92 6,051,241.08 2%3,932,876.63
Fund Type Debt Service Funds Net Gain (Loss)($1,543,943.00)$339,568.45 $282,367.41 $1,826,310.41 (18%)$1,696,951.63
Page 25 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD
REVENUE
Department 48 - LIBRARY
Other Revenue 480,000.00 .00 .00 480,000.00 0 .00
Department 48 - LIBRARY Totals $480,000.00 $0.00 $0.00 $480,000.00 0%$0.00
REVENUE TOTALS $480,000.00 $0.00 $0.00 $480,000.00 0%$0.00
EXPENSE
Department 48 - LIBRARY
Capital Outlay 680,000.00 .00 .00 680,000.00 0 405,832.11
Department 48 - LIBRARY Totals $680,000.00 $0.00 $0.00 $680,000.00 0%$405,832.11
EXPENSE TOTALS $680,000.00 $0.00 $0.00 $680,000.00 0%$405,832.11
Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD Totals
REVENUE TOTALS 480,000.00 .00 .00 480,000.00 0%.00
EXPENSE TOTALS 680,000.00 .00 .00 680,000.00 0%405,832.11
Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD Net Gain (Loss)($200,000.00)$0.00 $0.00 $200,000.00 0%($405,832.11)
Page 26 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 320 - DEBT SERVICE FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Property Taxes 13,436,256.00 2,329,284.65 2,370,036.70 11,066,219.30 18 14,316,070.00
Interfund Transfers 2,267,041.00 188,920.08 377,840.16 1,889,200.84 17 1,197,420.00
Other Revenue .00 .00 .00 .00 +++4,007,188.01
Interest Income 1,500.00 549.79 1,276.54 223.46 85 14,056.67
Department 99 - NON-DEPARTMENTAL Totals $15,704,797.00 $2,518,754.52 $2,749,153.40 $12,955,643.60 18%$19,534,734.68
REVENUE TOTALS $15,704,797.00 $2,518,754.52 $2,749,153.40 $12,955,643.60 18%$19,534,734.68
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies .00 .00 .00 .00 +++56,520.35
Debt Service 15,690,075.00 .00 .00 15,690,075.00 0 18,909,105.88
Miscellaneous .00 3,642.54 7,109.24 (7,109.24)+++.00
Department 99 - NON-DEPARTMENTAL Totals $15,690,075.00 $3,642.54 $7,109.24 $15,682,965.76 0%$18,965,626.23
EXPENSE TOTALS $15,690,075.00 $3,642.54 $7,109.24 $15,682,965.76 0%$18,965,626.23
Fund 320 - DEBT SERVICE FUND Totals
REVENUE TOTALS 15,704,797.00 2,518,754.52 2,749,153.40 12,955,643.60 18%19,534,734.68
EXPENSE TOTALS 15,690,075.00 3,642.54 7,109.24 15,682,965.76 0%18,965,626.23
Fund 320 - DEBT SERVICE FUND Net Gain (Loss)$14,722.00 $2,515,111.98 $2,742,044.16 $2,727,322.16 18,625%$569,108.45
Page 27 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 415 - CAPITAL IMPROVEMENTS FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Charges for Services .00 .00 .00 .00 +++168,794.05
Intergovernmental Revenue .00 .00 .00 .00 +++340,579.38
Other Revenue 12,253,000.00 72,853.02 72,853.02 12,180,146.98 1 9,062,090.05
Interest Income .00 1,888.42 3,863.43 (3,863.43)+++14,158.15
Department 40 - PUBLIC WORKS AGENCY Totals $12,253,000.00 $74,741.44 $76,716.45 $12,176,283.55 1%$9,585,621.63
Department 99 - NON-DEPARTMENTAL
Other Revenue .00 .00 .00 .00 +++(80,880.22)
Interest Income .00 .00 .00 .00 +++892.68
Department 99 - NON-DEPARTMENTAL Totals $0.00 $0.00 $0.00 $0.00 +++($79,987.54)
REVENUE TOTALS $12,253,000.00 $74,741.44 $76,716.45 $12,176,283.55 1%$9,505,634.09
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits .00 .00 .00 .00 +++710,222.39
Services and Supplies .00 6,540.34 6,545.34 (6,545.34)+++2,191,655.52
Capital Outlay 16,455,000.00 17.45 17.45 16,454,982.55 0 5,585,783.68
Miscellaneous .00 .00 1,026.81 (1,026.81)+++.00
Department 40 - PUBLIC WORKS AGENCY Totals $16,455,000.00 $6,557.79 $7,589.60 $16,447,410.40 0%$8,487,661.59
Department 99 - NON-DEPARTMENTAL
Miscellaneous .00 10,446.03 20,387.77 (20,387.77)+++.00
Department 99 - NON-DEPARTMENTAL Totals $0.00 $10,446.03 $20,387.77 ($20,387.77)+++$0.00
EXPENSE TOTALS $16,455,000.00 $17,003.82 $27,977.37 $16,427,022.63 0%$8,487,661.59
Fund 415 - CAPITAL IMPROVEMENTS FUND Totals
REVENUE TOTALS 12,253,000.00 74,741.44 76,716.45 12,176,283.55 1%9,505,634.09
EXPENSE TOTALS 16,455,000.00 17,003.82 27,977.37 16,427,022.63 0%8,487,661.59
Fund 415 - CAPITAL IMPROVEMENTS FUND Net Gain (Loss)($4,202,000.00)$57,737.62 $48,739.08 $4,250,739.08 (1%)$1,017,972.50
Page 28 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 416 - CROWN CONSTRUCTION FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Intergovernmental Revenue .00 .00 .00 .00 +++1,000,000.00
Other Revenue 1,000,000.00 .00 .00 1,000,000.00 0 2,800,000.00
Interest Income .00 1,037.52 2,092.46 (2,092.46)+++12,174.21
Department 40 - PUBLIC WORKS AGENCY Totals $1,000,000.00 $1,037.52 $2,092.46 $997,907.54 0%$3,812,174.21
REVENUE TOTALS $1,000,000.00 $1,037.52 $2,092.46 $997,907.54 0%$3,812,174.21
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Services and Supplies .00 5.00 10.00 (10.00)+++13,829.13
Capital Outlay 800,000.00 .00 .00 800,000.00 0 699,411.48
Interfund Transfers 900,000.00 75,000.00 150,000.00 750,000.00 17 .00
Department 40 - PUBLIC WORKS AGENCY Totals $1,700,000.00 $75,005.00 $150,010.00 $1,549,990.00 9%$713,240.61
EXPENSE TOTALS $1,700,000.00 $75,005.00 $150,010.00 $1,549,990.00 9%$713,240.61
Fund 416 - CROWN CONSTRUCTION FUND Totals
REVENUE TOTALS 1,000,000.00 1,037.52 2,092.46 997,907.54 0%3,812,174.21
EXPENSE TOTALS 1,700,000.00 75,005.00 150,010.00 1,549,990.00 9%713,240.61
Fund 416 - CROWN CONSTRUCTION FUND Net Gain (Loss)($700,000.00)($73,967.48)($147,917.54)$552,082.46 21%$3,098,933.60
Page 29 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 417 - CROWN COMMUNITY CTR MAINTENANCE
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Interfund Transfers 175,000.00 14,583.33 29,166.66 145,833.34 17 174,996.00
Department 40 - PUBLIC WORKS AGENCY Totals $175,000.00 $14,583.33 $29,166.66 $145,833.34 17%$174,996.00
REVENUE TOTALS $175,000.00 $14,583.33 $29,166.66 $145,833.34 17%$174,996.00
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Capital Outlay .00 .00 .00 .00 +++.00
Department 40 - PUBLIC WORKS AGENCY Totals $0.00 $0.00 $0.00 $0.00 +++$0.00
EXPENSE TOTALS $0.00 $0.00 $0.00 $0.00 +++$0.00
Fund 417 - CROWN COMMUNITY CTR MAINTENANCE Totals
REVENUE TOTALS 175,000.00 14,583.33 29,166.66 145,833.34 17%174,996.00
EXPENSE TOTALS .00 .00 .00 .00 +++.00
Fund 417 - CROWN COMMUNITY CTR MAINTENANCE Net Gain (Loss)$175,000.00 $14,583.33 $29,166.66 ($145,833.34)17%$174,996.00
Page 30 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 420 - SPECIAL ASSESSMENT FUND
REVENUE
Department 26 - PUBLIC WORKS
Other Taxes 125,000.00 3,162.92 45,289.23 79,710.77 36 97,651.61
Other Revenue .00 .00 .00 .00 +++(1,109.75)
Interest Income 30,000.00 252.42 4,584.50 25,415.50 15 17,656.23
Department 26 - PUBLIC WORKS Totals $155,000.00 $3,415.34 $49,873.73 $105,126.27 32%$114,198.09
REVENUE TOTALS $155,000.00 $3,415.34 $49,873.73 $105,126.27 32%$114,198.09
EXPENSE
Department 26 - PUBLIC WORKS
Services and Supplies .00 5.00 10.00 (10.00)+++60.00
Department 26 - PUBLIC WORKS Totals $0.00 $5.00 $10.00 ($10.00)+++$60.00
Department 40 - PUBLIC WORKS AGENCY
Capital Outlay 650,000.00 .00 .00 650,000.00 0 144,685.95
Interfund Transfers 464,938.00 38,744.84 77,489.68 387,448.32 17 489,324.00
Department 40 - PUBLIC WORKS AGENCY Totals $1,114,938.00 $38,744.84 $77,489.68 $1,037,448.32 7%$634,009.95
EXPENSE TOTALS $1,114,938.00 $38,749.84 $77,499.68 $1,037,438.32 7%$634,069.95
Fund 420 - SPECIAL ASSESSMENT FUND Totals
REVENUE TOTALS 155,000.00 3,415.34 49,873.73 105,126.27 32%114,198.09
EXPENSE TOTALS 1,114,938.00 38,749.84 77,499.68 1,037,438.32 7%634,069.95
Fund 420 - SPECIAL ASSESSMENT FUND Net Gain (Loss)($959,938.00)($35,334.50)($27,625.95)$932,312.05 3%($519,871.86)
Fund Type Capital Project Funds Totals
REVENUE TOTALS 29,767,797.00 2,612,532.15 2,907,002.70 26,860,794.30 10%33,141,737.07
EXPENSE TOTALS 35,640,013.00 134,401.20 262,596.29 35,377,416.71 1%29,206,430.49
Fund Type Capital Project Funds Net Gain (Loss)($5,872,216.00)$2,478,130.95 $2,644,406.41 $8,516,622.41 (45%)$3,935,306.58
Fund Category Governmental Funds Totals
REVENUE TOTALS 80,608,482.00 5,079,929.76 5,765,508.83 74,842,973.17 7%86,062,983.71
EXPENSE TOTALS 102,089,372.42 2,117,923.26 3,730,813.34 98,358,559.08 4%60,538,146.00
Fund Category Governmental Funds Net Gain (Loss)($21,480,890.42)$2,962,006.50 $2,034,695.49 $23,515,585.91 (9%)$25,524,837.71
Page 31 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 505 - PARKING SYSTEM FUND
REVENUE
Department 19 - ADMINISTRATIVE SERVICES
Licenses, Permits and Fees .00 .00 .00 .00 +++375.00
Charges for Services 8,873,975.00 587,654.35 1,024,076.90 7,849,898.10 12 7,686,900.24
Intergovernmental Revenue 2,300,000.00 191,666.67 383,333.34 1,916,666.66 17 950,000.00
Other Revenue 486,700.00 19,702.60 36,192.42 450,507.58 7 335,233.97
Interest Income 20,000.00 483.14 905.04 19,094.96 5 38,999.24
Department 19 - ADMINISTRATIVE SERVICES Totals $11,680,675.00 $799,506.76 $1,444,507.70 $10,236,167.30 12%$9,011,508.45
REVENUE TOTALS $11,680,675.00 $799,506.76 $1,444,507.70 $10,236,167.30 12%$9,011,508.45
EXPENSE
Department 15 - CITY MANAGER'S OFFICE
Salary and Benefits 334,851.42 21,792.79 43,540.54 291,310.88 13 251,903.29
Department 15 - CITY MANAGER'S OFFICE Totals $334,851.42 $21,792.79 $43,540.54 $291,310.88 13%$251,903.29
Department 19 - ADMINISTRATIVE SERVICES
Salary and Benefits 813,004.00 47,728.71 96,560.67 716,443.33 12 624,260.73
Services and Supplies 4,550,316.00 284,128.14 498,985.02 4,051,330.98 11 3,786,085.86
Capital Outlay 2,025,000.00 .00 .00 2,025,000.00 0 25,706.93
Insurance and Other Chargebacks 351,502.00 29,291.83 58,583.66 292,918.34 17 351,504.00
Depreciation Expense .00 .00 .00 .00 +++2,916,281.02
Debt Service 72,900.00 .00 .00 72,900.00 0 47,164.44
Miscellaneous 50,000.00 2,740.90 2,740.90 47,259.10 5 .00
Interfund Transfers 3,132,390.00 261,032.50 522,065.00 2,610,325.00 17 3,132,384.00
Department 19 - ADMINISTRATIVE SERVICES Totals $10,995,112.00 $624,922.08 $1,178,935.25 $9,816,176.75 11%$10,883,386.98
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits 489,417.38 36,889.13 76,045.71 413,371.67 16 537,134.71
Miscellaneous .00 .00 .00 .00 +++300.00
Department 40 - PUBLIC WORKS AGENCY Totals $489,417.38 $36,889.13 $76,045.71 $413,371.67 16%$537,434.71
EXPENSE TOTALS $11,819,380.80 $683,604.00 $1,298,521.50 $10,520,859.30 11%$11,672,724.98
Fund 505 - PARKING SYSTEM FUND Totals
REVENUE TOTALS 11,680,675.00 799,506.76 1,444,507.70 10,236,167.30 12%9,011,508.45
EXPENSE TOTALS 11,819,380.80 683,604.00 1,298,521.50 10,520,859.30 11%11,672,724.98
Fund 505 - PARKING SYSTEM FUND Net Gain (Loss)($138,705.80)$115,902.76 $145,986.20 $284,692.00 (105%)($2,661,216.53)
Page 32 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 510 - WATER FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Licenses, Permits and Fees 50,000.00 7,726.83 7,926.83 42,073.17 16 50,696.30
Charges for Services 23,443,200.00 1,518,005.96 3,141,956.05 20,301,243.95 13 20,567,164.48
Intergovernmental Revenue .00 .00 .00 .00 +++3,000,000.00
Other Revenue 29,834,150.00 .00 92.61 29,834,057.39 0 2,257,500.64
Interest Income 70,000.00 3,402.05 20,844.88 49,155.12 30 46,780.41
Department 40 - PUBLIC WORKS AGENCY Totals $53,397,350.00 $1,529,134.84 $3,170,820.37 $50,226,529.63 6%$25,922,141.83
Department 71 - UTILITIES
Other Revenue .00 .00 .00 .00 +++2,772,225.94
Department 71 - UTILITIES Totals $0.00 $0.00 $0.00 $0.00 +++$2,772,225.94
REVENUE TOTALS $53,397,350.00 $1,529,134.84 $3,170,820.37 $50,226,529.63 6%$28,694,367.77
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits 6,004,605.36 459,829.28 909,047.28 5,095,558.08 15 5,792,780.99
Services and Supplies 5,347,760.00 191,447.71 200,375.13 5,147,384.87 4 3,438,090.15
Capital Outlay 164,400.00 .00 .00 164,400.00 0 21,950.00
Insurance and Other Chargebacks .00 .00 .00 .00 +++19,484.16
Contingencies 1,000.00 .00 .00 1,000.00 0 28.75
Miscellaneous 15,000.00 31,225.08 68,603.79 (53,603.79)457 9,180.19
Interfund Transfers 180,000.00 15,000.00 1,140,922.51 (960,922.51)634 (930,922.51)
Department 40 - PUBLIC WORKS AGENCY Totals $11,712,765.36 $697,502.07 $2,318,948.71 $9,393,816.65 20%$8,350,591.73
Department 71 - UTILITIES
Salary and Benefits .00 4,535.69 4,535.69 (4,535.69)+++.00
Services and Supplies .00 .00 .00 .00 +++34,179.81
Insurance and Other Chargebacks 1,585,843.00 132,153.58 264,307.16 1,321,535.84 17 1,539,648.00
Debt Service 3,596,365.00 .00 .00 3,596,365.00 0 5,406,937.51
Interfund Transfers 4,049,559.00 337,463.25 674,926.50 3,374,632.50 17 4,049,568.00
Department 71 - UTILITIES Totals $9,231,767.00 $474,152.52 $943,769.35 $8,287,997.65 10%$11,030,333.32
EXPENSE TOTALS $20,944,532.36 $1,171,654.59 $3,262,718.06 $17,681,814.30 16%$19,380,925.05
Fund 510 - WATER FUND Totals
REVENUE TOTALS 53,397,350.00 1,529,134.84 3,170,820.37 50,226,529.63 6%28,694,367.77
EXPENSE TOTALS 20,944,532.36 1,171,654.59 3,262,718.06 17,681,814.30 16%19,380,925.05
Fund 510 - WATER FUND Net Gain (Loss)$32,452,817.64 $357,480.25 ($91,897.69)($32,544,715.33)0%$9,313,442.72
Page 33 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 513 - WATER DEPR IMPRV &EXTENSION FUND
EXPENSE
Department 71 - UTILITIES
Services and Supplies 3,465,000.00 .00 34,100.00 3,430,900.00 1 468,530.30
Capital Outlay 33,036,000.00 .00 .00 33,036,000.00 0 5,563,648.03
Interfund Transfers .00 .00 (1,110,922.51)1,110,922.51 +++1,110,922.51
Department 71 - UTILITIES Totals $36,501,000.00 $0.00 ($1,076,822.51)$37,577,822.51 (3%)$7,143,100.84
EXPENSE TOTALS $36,501,000.00 $0.00 ($1,076,822.51)$37,577,822.51 (3%)$7,143,100.84
Fund 513 - WATER DEPR IMPRV &EXTENSION FUND Totals
REVENUE TOTALS .00 .00 .00 .00 +++.00
EXPENSE TOTALS 36,501,000.00 .00 (1,076,822.51)37,577,822.51 (3%)7,143,100.84
Fund 513 - WATER DEPR IMPRV &EXTENSION FUND Net Gain (Loss)($36,501,000.00)$0.00 $1,076,822.51 $37,577,822.51 (3%)($7,143,100.84)
Page 34 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 515 - SEWER FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Charges for Services 10,113,594.00 550,872.49 1,154,929.58 8,958,664.42 11 10,373,596.78
Other Revenue 2,001,000.00 .00 .00 2,001,000.00 0 (10,632.04)
Interest Income 25,000.00 101.33 395.38 24,604.62 2 4,547.39
Department 40 - PUBLIC WORKS AGENCY Totals $12,139,594.00 $550,973.82 $1,155,324.96 $10,984,269.04 10%$10,367,512.13
REVENUE TOTALS $12,139,594.00 $550,973.82 $1,155,324.96 $10,984,269.04 10%$10,367,512.13
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits 1,383,914.00 106,482.30 210,183.82 1,173,730.18 15 1,346,850.47
Services and Supplies 1,471,800.00 10,287.02 10,723.17 1,461,076.83 1 1,982,019.49
Capital Outlay 3,538,100.00 .00 .00 3,538,100.00 0 198,816.30
Insurance and Other Chargebacks 352,190.00 29,349.17 58,698.34 293,491.66 17 332,256.00
Miscellaneous 1,500.00 9,276.15 18,104.48 (16,604.48)1,207 500.00
Interfund Transfers 871,164.00 72,597.01 145,194.02 725,969.98 17 855,384.00
Department 40 - PUBLIC WORKS AGENCY Totals $7,618,668.00 $227,991.65 $442,903.83 $7,175,764.17 6%$4,715,826.26
Department 71 - UTILITIES
Salary and Benefits .00 .00 .00 .00 +++8,211.26
Debt Service 3,772,691.00 293,312.74 312,773.53 3,459,917.47 8 869,531.30
Department 71 - UTILITIES Totals $3,772,691.00 $293,312.74 $312,773.53 $3,459,917.47 8%$877,742.56
EXPENSE TOTALS $11,391,359.00 $521,304.39 $755,677.36 $10,635,681.64 7%$5,593,568.82
Fund 515 - SEWER FUND Totals
REVENUE TOTALS 12,139,594.00 550,973.82 1,155,324.96 10,984,269.04 10%10,367,512.13
EXPENSE TOTALS 11,391,359.00 521,304.39 755,677.36 10,635,681.64 7%5,593,568.82
Fund 515 - SEWER FUND Net Gain (Loss)$748,235.00 $29,669.43 $399,647.60 ($348,587.40)53%$4,773,943.31
Page 35 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 520 - SOLID WASTE FUND
REVENUE
Department 26 - PUBLIC WORKS
Charges for Services .00 .00 .00 .00 +++3,331.00
Department 26 - PUBLIC WORKS Totals $0.00 $0.00 $0.00 $0.00 +++$3,331.00
Department 40 - PUBLIC WORKS AGENCY
Property Taxes 1,332,500.00 .00 .00 1,332,500.00 0 1,332,500.00
Licenses, Permits and Fees 297,000.00 876.00 17,841.00 279,159.00 6 293,124.87
Charges for Services 4,516,450.00 359,167.34 691,419.18 3,825,030.82 15 4,538,514.91
Other Revenue 122,000.00 258.90 91,990.74 30,009.26 75 133,951.81
Department 40 - PUBLIC WORKS AGENCY Totals $6,267,950.00 $360,302.24 $801,250.92 $5,466,699.08 13%$6,298,091.59
REVENUE TOTALS $6,267,950.00 $360,302.24 $801,250.92 $5,466,699.08 13%$6,301,422.59
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits 1,492,909.00 109,739.91 223,616.63 1,269,292.37 15 1,583,453.40
Services and Supplies 3,786,776.00 191,227.11 377,440.79 3,409,335.21 10 3,636,763.72
Capital Outlay 525,000.00 2,043.86 4,208.86 520,791.14 1 455,668.27
Miscellaneous 15,000.00 .00 .00 15,000.00 0 8,806.23
Interfund Transfers 302,000.00 25,166.67 50,333.34 251,666.66 17 302,004.00
Department 40 - PUBLIC WORKS AGENCY Totals $6,121,685.00 $328,177.55 $655,599.62 $5,466,085.38 11%$5,986,695.62
EXPENSE TOTALS $6,121,685.00 $328,177.55 $655,599.62 $5,466,085.38 11%$5,986,695.62
Fund 520 - SOLID WASTE FUND Totals
REVENUE TOTALS 6,267,950.00 360,302.24 801,250.92 5,466,699.08 13%6,301,422.59
EXPENSE TOTALS 6,121,685.00 328,177.55 655,599.62 5,466,085.38 11%5,986,695.62
Fund 520 - SOLID WASTE FUND Net Gain (Loss)$146,265.00 $32,124.69 $145,651.30 ($613.70)100%$314,726.97
Fund Type Enterprise Funds Totals
REVENUE TOTALS 83,485,569.00 3,239,917.66 6,571,903.95 76,913,665.05 8%54,374,810.94
EXPENSE TOTALS 86,777,957.16 2,704,740.53 4,895,694.03 81,882,263.13 6%49,777,015.31
Fund Type Enterprise Funds Net Gain (Loss)($3,292,388.16)$535,177.13 $1,676,209.92 $4,968,598.08 (51%)$4,597,795.63
Page 36 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Proprietary Funds
Fund Type Internal Service Funds
Fund 600 - FLEET SERVICES FUND
REVENUE
Department 19 - ADMINISTRATIVE SERVICES
Charges for Services 3,127,440.00 258,953.33 517,906.66 2,609,533.34 17 3,107,436.00
Other Revenue 69,000.00 4,968.88 4,968.88 64,031.12 7 15,773.20
Interest Income 1,000.00 .00 .00 1,000.00 0 .00
Department 19 - ADMINISTRATIVE SERVICES Totals $3,197,440.00 $263,922.21 $522,875.54 $2,674,564.46 16%$3,123,209.20
REVENUE TOTALS $3,197,440.00 $263,922.21 $522,875.54 $2,674,564.46 16%$3,123,209.20
EXPENSE
Department 19 - ADMINISTRATIVE SERVICES
Salary and Benefits 1,276,620.55 83,535.12 182,051.19 1,094,569.36 14 1,174,245.36
Services and Supplies 2,034,507.00 189,156.00 213,162.44 1,821,344.56 10 1,928,363.52
Capital Outlay .00 .00 .00 .00 +++22,858.68
Insurance and Other Chargebacks .00 .00 899.88 (899.88)+++18,168.28
Miscellaneous .00 .00 .00 .00 +++600.00
Department 19 - ADMINISTRATIVE SERVICES Totals $3,311,127.55 $272,691.12 $396,113.51 $2,915,014.04 12%$3,144,235.84
EXPENSE TOTALS $3,311,127.55 $272,691.12 $396,113.51 $2,915,014.04 12%$3,144,235.84
Fund 600 - FLEET SERVICES FUND Totals
REVENUE TOTALS 3,197,440.00 263,922.21 522,875.54 2,674,564.46 16%3,123,209.20
EXPENSE TOTALS 3,311,127.55 272,691.12 396,113.51 2,915,014.04 12%3,144,235.84
Fund 600 - FLEET SERVICES FUND Net Gain (Loss)($113,687.55)($8,768.91)$126,762.03 $240,449.58 (112%)($21,026.64)
Page 37 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Proprietary Funds
Fund Type Internal Service Funds
Fund 601 - EQUIPMENT REPLACEMENT FUND
REVENUE
Department 19 - ADMINISTRATIVE SERVICES
Charges for Services 224,885.00 18,740.40 37,480.80 187,404.20 17 224,868.00
Intergovernmental Revenue 1,600,000.00 133,333.33 266,666.66 1,333,333.34 17 850,000.00
Other Revenue 960,217.00 .00 .00 960,217.00 0 157,294.00
Interest Income .00 .00 .00 .00 +++200.07
Department 19 - ADMINISTRATIVE SERVICES Totals $2,785,102.00 $152,073.73 $304,147.46 $2,480,954.54 11%$1,232,362.07
REVENUE TOTALS $2,785,102.00 $152,073.73 $304,147.46 $2,480,954.54 11%$1,232,362.07
EXPENSE
Department 19 - ADMINISTRATIVE SERVICES
Services and Supplies .00 .00 .00 .00 +++101.15
Capital Outlay 2,750,000.00 157,493.00 157,493.00 2,592,507.00 6 1,367.42
Department 19 - ADMINISTRATIVE SERVICES Totals $2,750,000.00 $157,493.00 $157,493.00 $2,592,507.00 6%$1,468.57
Department 26 - PUBLIC WORKS
Depreciation Expense .00 .00 .00 .00 +++1,525,498.02
Department 26 - PUBLIC WORKS Totals $0.00 $0.00 $0.00 $0.00 +++$1,525,498.02
EXPENSE TOTALS $2,750,000.00 $157,493.00 $157,493.00 $2,592,507.00 6%$1,526,966.59
Fund 601 - EQUIPMENT REPLACEMENT FUND Totals
REVENUE TOTALS 2,785,102.00 152,073.73 304,147.46 2,480,954.54 11%1,232,362.07
EXPENSE TOTALS 2,750,000.00 157,493.00 157,493.00 2,592,507.00 6%1,526,966.59
Fund 601 - EQUIPMENT REPLACEMENT FUND Net Gain (Loss)$35,102.00 ($5,419.27)$146,654.46 $111,552.46 418%($294,604.52)
Page 38 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Proprietary Funds
Fund Type Internal Service Funds
Fund 605 - INSURANCE FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Charges for Services .00 2,386.57 2,386.57 (2,386.57)+++7,170.63
Other Revenue 11,248,243.00 841,740.92 1,705,297.98 9,542,945.02 15 10,440,070.43
Workers Compensation and Liability 825,000.00 63,000.00 125,500.00 699,500.00 15 1,581,986.03
Insurance 8,827,914.00 807,245.81 1,350,308.32 7,477,605.68 15 9,278,100.45
Department 99 - NON-DEPARTMENTAL Totals $20,901,157.00 $1,714,373.30 $3,183,492.87 $17,717,664.13 15%$21,307,327.54
REVENUE TOTALS $20,901,157.00 $1,714,373.30 $3,183,492.87 $17,717,664.13 15%$21,307,327.54
EXPENSE
Department 99 - NON-DEPARTMENTAL
Salary and Benefits 4,751.36 6,717.68 29,715.64 (24,964.28)625 553,718.61
Services and Supplies 2,994,200.00 141,559.28 1,231,848.33 1,762,351.67 41 1,884,045.60
Insurance and Other Chargebacks 16,957,400.00 1,258,660.24 2,599,440.34 14,357,959.66 15 15,626,040.77
Miscellaneous .00 .00 .00 .00 +++300.00
Department 99 - NON-DEPARTMENTAL Totals $19,956,351.36 $1,406,937.20 $3,861,004.31 $16,095,347.05 19%$18,064,104.98
EXPENSE TOTALS $19,956,351.36 $1,406,937.20 $3,861,004.31 $16,095,347.05 19%$18,064,104.98
Fund 605 - INSURANCE FUND Totals
REVENUE TOTALS 20,901,157.00 1,714,373.30 3,183,492.87 17,717,664.13 15%21,307,327.54
EXPENSE TOTALS 19,956,351.36 1,406,937.20 3,861,004.31 16,095,347.05 19%18,064,104.98
Fund 605 - INSURANCE FUND Net Gain (Loss)$944,805.64 $307,436.10 ($677,511.44)($1,622,317.08)(72%)$3,243,222.56
Fund Type Internal Service Funds Totals
REVENUE TOTALS 26,883,699.00 2,130,369.24 4,010,515.87 22,873,183.13 15%25,662,898.81
EXPENSE TOTALS 26,017,478.91 1,837,121.32 4,414,610.82 21,602,868.09 17%22,735,307.41
Fund Type Internal Service Funds Net Gain (Loss)$866,220.09 $293,247.92 ($404,094.95)($1,270,315.04)(47%)$2,927,591.40
Fund Category Proprietary Funds Totals
REVENUE TOTALS 110,369,268.00 5,370,286.90 10,582,419.82 99,786,848.18 10%80,037,709.75
EXPENSE TOTALS 112,795,436.07 4,541,861.85 9,310,304.85 103,485,131.22 8%72,512,322.72
Fund Category Proprietary Funds Net Gain (Loss)($2,426,168.07)$828,425.05 $1,272,114.97 $3,698,283.04 (52%)$7,525,387.03
Page 39 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Fiduciary Funds
Fund Type Pension Trust Funds
Fund 700 - FIRE PENSION FUND
REVENUE
Department 23 - FIRE MGMT & SUPPORT
Other Revenue 11,764,044.00 78,240.46 (4,356,998.84)16,121,042.84 (37)20,999,855.36
Interest Income 2,500,000.00 .00 117,814.59 2,382,185.41 5 3,441,785.24
Department 23 - FIRE MGMT & SUPPORT Totals $14,264,044.00 $78,240.46 ($4,239,184.25)$18,503,228.25 (30%)$24,441,640.60
REVENUE TOTALS $14,264,044.00 $78,240.46 ($4,239,184.25)$18,503,228.25 (30%)$24,441,640.60
EXPENSE
Department 23 - FIRE MGMT & SUPPORT
Salary and Benefits 11,318,287.00 903,815.59 1,822,955.44 9,495,331.56 16 10,669,535.56
Miscellaneous 225,000.00 .00 25,341.42 199,658.58 11 213,704.68
Department 23 - FIRE MGMT & SUPPORT Totals $11,543,287.00 $903,815.59 $1,848,296.86 $9,694,990.14 16%$10,883,240.24
EXPENSE TOTALS $11,543,287.00 $903,815.59 $1,848,296.86 $9,694,990.14 16%$10,883,240.24
Fund 700 - FIRE PENSION FUND Totals
REVENUE TOTALS 14,264,044.00 78,240.46 (4,239,184.25)18,503,228.25 (30%)24,441,640.60
EXPENSE TOTALS 11,543,287.00 903,815.59 1,848,296.86 9,694,990.14 16%10,883,240.24
Fund 700 - FIRE PENSION FUND Net Gain (Loss)$2,720,757.00 ($825,575.13)($6,087,481.11)($8,808,238.11)(224%)$13,558,400.36
Page 40 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification
Fund Category Fiduciary Funds
Fund Type Pension Trust Funds
Fund 705 - POLICE PENSION FUND
REVENUE
Department 22 - POLICE
Other Revenue 17,481,538.00 125,416.36 (8,797,604.35)26,279,142.35 (50)36,164,184.57
Interest Income 1,500,000.00 .00 155,486.44 1,344,513.56 10 3,591,523.09
Department 22 - POLICE Totals $18,981,538.00 $125,416.36 ($8,642,117.91)$27,623,655.91 (46%)$39,755,707.66
REVENUE TOTALS $18,981,538.00 $125,416.36 ($8,642,117.91)$27,623,655.91 (46%)$39,755,707.66
EXPENSE
Department 22 - POLICE
Salary and Benefits 15,814,448.00 1,233,619.38 2,784,973.10 13,029,474.90 18 14,968,884.24
Miscellaneous 300,000.00 .00 19,003.14 280,996.86 6 348,090.41
Department 22 - POLICE Totals $16,114,448.00 $1,233,619.38 $2,803,976.24 $13,310,471.76 17%$15,316,974.65
EXPENSE TOTALS $16,114,448.00 $1,233,619.38 $2,803,976.24 $13,310,471.76 17%$15,316,974.65
Fund 705 - POLICE PENSION FUND Totals
REVENUE TOTALS 18,981,538.00 125,416.36 (8,642,117.91)27,623,655.91 (46%)39,755,707.66
EXPENSE TOTALS 16,114,448.00 1,233,619.38 2,803,976.24 13,310,471.76 17%15,316,974.65
Fund 705 - POLICE PENSION FUND Net Gain (Loss)$2,867,090.00 ($1,108,203.02)($11,446,094.15)($14,313,184.15)(399%)$24,438,733.01
Fund Type Pension Trust Funds Totals
REVENUE TOTALS 33,245,582.00 203,656.82 (12,881,302.16)46,126,884.16 (39%)64,197,348.26
EXPENSE TOTALS 27,657,735.00 2,137,434.97 4,652,273.10 23,005,461.90 17%26,200,214.89
Fund Type Pension Trust Funds Net Gain (Loss)$5,587,847.00 ($1,933,778.15)($17,533,575.26)($23,121,422.26)(314%)$37,997,133.37
Fund Category Fiduciary Funds Totals
REVENUE TOTALS 33,245,582.00 203,656.82 (12,881,302.16)46,126,884.16 (39%)64,197,348.26
EXPENSE TOTALS 27,657,735.00 2,137,434.97 4,652,273.10 23,005,461.90 17%26,200,214.89
Fund Category Fiduciary Funds Net Gain (Loss)$5,587,847.00 ($1,933,778.15)($17,533,575.26)($23,121,422.26)(314%)$37,997,133.37
Page 41 of 44Run by Jessica Tapia on 04/05/2022 13:23:03 PM
Income Statement
Through 02/28/22
Summary Listing
Annual MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget Total ActualClassification