HomeMy WebLinkAbout2022.03 March Monthly Report
To: Kelley A. Gandurski, Interim City Manager
From: Hitesh Desai, CFO/City Treasurer
Subject: March 2022 Monthly Financial Report
Date: April 29, 2022
Please find attached the unaudited financial statements as of March 31, 2022. A summary by fund for
revenues, expenditures, fund and cash balances is as follows:
City of Evanston
Cash & Investment Summary by Fund
March 31, 2022
Fund #Fund Revenue Expense Net Fund Balance Cash Balance
100 General 42,775,812 31,792,281 10,983,531 41,510,824 37,600,017
170 American Rescue Plan 3,262 2,037,500 (2,034,238) 14,779,134 14,779,134
175 General Assistance 718,654 238,854 479,800 1,090,246 1,090,118
176 Human Services 1,630,785 402,538 1,228,248 3,260,371 3,260,182
177 Reparations 3,054 596 2,459 267,083 267,083
180 Good Neighbor 302 130 172 902,335 902,335
185 Library 3,975,733 1,592,043 2,383,689 5,828,044 5,769,151
186 Library Debt Service 253,313 - 253,313 254,457 254,457
187 Library Capital Improvement FD - - - 878,126 878,126
200 MFT 1,525,652 618,679 906,973 5,958,073 5,710,808
205 E911 365,914 266,050 99,864 1,625,487 1,268,762
210 Special Service Area (SSA) #9 312,970 - 312,970 106,219 106,219
215 CDBG 30 159,685 (159,656) (98,833) (98,833)
220 CD Loan 51,708 - 51,708 362,639 362,639
235 Neighborhood Improvement 7 3 4 22,147 22,147
240 Home 171,905 216,980 (45,075) (19,339) (19,339)
250 Affordable Housing 32,931 95,741 (62,810) 2,569,214 2,717,070
320 Debt Service 8,089,152 13,440 8,075,713 9,366,280 9,366,280
330 Howard Ridge 665,875 100,680 565,195 3,238,760 3,392,776
335 West Evanston 836,092 20,451 815,641 4,067,847 4,067,847
340 Dempster-Dodge-TIF 155,665 42,985 112,680 437,684 437,684
345 Chicago Main-TIF 601,391 91,561 509,830 1,461,358 1,461,358
350 Special Service Area (SSA) #6 118,884 0 118,884 120,664 120,664
355 Special Service Area (SSA) #7 76,413 0 76,413 85,128 85,128
360 Special Service Area (SSA) #8 30,167 - 30,167 33,385 33,385
415 Capital Improvements 84,318 286,590 (202,272) 11,334,213 11,532,425
416 Crown Construction 3,072 227,270 (224,198) 5,505,620 5,505,620
417 Crown Community CTR Maintenance 43,750 23,076 20,674 370,670 370,670
420 Special Assessment 51,765 127,690 (75,925) 2,057,670 2,053,389
505 Parking 2,390,220 2,154,446 235,775 (1,616,089) 706,328
510 Water 5,526,255 3,547,373 1,978,883 17,325,011 13,519,451
515 Sewer 2,054,341 1,297,805 756,537 10,979,490 4,989,474
520 Solid Waste 1,935,972 1,084,886 851,086 1,309,096 349,592
600 Fleet 781,829 776,263 5,565 724,219 (638,016)
601 Equipment Replacement 456,221 1,187,197 (730,976) (502,036) (694,282)
605 Insurance 4,809,080 5,747,585 (938,505) (6,158,972) (2,182,134)
Grand Total 80,532,495 54,150,376 26,382,119 139,436,227 129,347,715
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 March 31 , 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 show the General Fund as of March 31, 2022 with a fund balance
of $41,510,824 and cash balance of $37,600,017 . The attached financials show General Fund
revenues at 36% of budget and expenses at 27 % of budget. The General Fund revenues are higher
mainly because of property tax revenues collected.
Staff continues to monitor Police and Fire overtime expenses. Through March, Police had spent 20 %
of budget for overtime, and Fire had spent 24 % of the annual budget .
Overtime
Expenses
2021 Actual 2022 Budget 2022 YTD % Budget
Enterprise Funds
Parking fund revenues through March 31, 2022, are at 20 % of budget and expenses are at 18 %.
As the economy continues to improve in post -pandemic time, we expect Parking revenues to
increase.
Through March 31, 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 March 31, 2022, the Sewer Fund also appears low on expenses mainly due to the capital
projects a nd debt service payments occurring later in the year.
Through March 31 , 2022, the Solid Waste Fund has a fund balance of $1,309,096 and a cash balance
of $349,592.
Other Funds
Through March 31, 2022, the SSA #9 Fund is showing fund and cash balance of $106,219.
Through March 31 , 2022, the Capital Improvements Fund is showing a fund balance of $11,334,213
and a cash balance of $11,532,425. The fund continues to spend down Series 2021 and Series 2020
bond proceeds.
Through March 31 , 2022, the Crown Construction fund is showing fund and cash balance
of $5,505,620 . The fund continues to spend down balances from bond proceeds and gifts from the
Friends of Robert Crown.
Through March 31 , 2022, the Insurance Fund is showing a negative fun d balance of $6,158,972 and a
negative cash balance of $2,182,134 . 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.o rg/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 March 31, 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
14 CITY CLERK 80,500.00 124.00 158.00 80,342.00 0 .00
15 CITY MANAGER'S OFFICE 76,832,408.00 8,888,407.37 23,714,180.96 53,118,227.04 31 18,419,952.36
17 LAW 537,000.00 39,054.00 139,680.25 397,319.75 26 88,985.28
19 ADMINISTRATIVE SERVICES 3,432,000.00 257,912.50 952,022.82 2,479,977.18 28 709,716.20
21 COMMUNITY DEVELOPMENT 4,974,700.00 449,983.43 1,186,597.29 3,788,102.71 24 1,780,795.39
22 POLICE 1,188,000.00 (1,699,268.63)180,498.12 1,007,501.88 15 4,792,077.81
23 FIRE MGMT & SUPPORT 3,043,600.00 4,390,310.72 7,745,351.71 (4,701,751.71)254 4,716,564.73
24 HEALTH 874,242.00 109,919.97 596,096.66 278,145.34 68 578,066.00
30 PARKS AND RECREATION 5,580,175.00 570,793.69 1,974,585.83 3,605,589.17 35 1,381,820.22
40 PUBLIC WORKS AGENCY 644,000.00 56,919.85 89,047.56 554,952.44 14 67,445.14
99 NON-DEPARTMENTAL 20,723,062.00 6,197,592.88 6,197,592.88 14,525,469.12 30 .00
REVENUE TOTALS $117,909,687.00 $19,261,749.78 $42,775,812.08 $75,133,874.92 36%$32,535,423.13
EXPENSE
12 LEGISLATIVE .00 .00 .00 .00 +++795.00
13 CITY COUNCIL 579,384.00 45,022.78 132,085.73 447,298.27 23 101,300.73
14 CITY CLERK 343,573.00 22,537.06 50,773.82 292,799.18 15 36,737.14
15 CITY MANAGER'S OFFICE 6,232,882.39 388,050.89 1,133,921.57 5,098,960.82 18 1,233,759.52
17 LAW 970,341.14 74,168.15 183,387.84 786,953.30 19 108,238.13
19 ADMINISTRATIVE SERVICES 11,449,182.64 1,099,868.40 2,298,284.73 9,150,897.91 20 1,770,582.11
21 COMMUNITY DEVELOPMENT 4,488,316.71 241,220.24 668,180.02 3,820,136.69 15 672,249.37
22 POLICE 29,280,597.55 35,588.53 6,475,113.31 22,805,484.24 22 11,648,963.14
23 FIRE MGMT & SUPPORT 16,823,271.83 (225,319.06)4,046,501.00 12,776,770.83 24 8,029,976.12
24 HEALTH 1,453,836.00 150,187.07 425,085.31 1,028,750.69 29 404,113.26
30 PARKS AND RECREATION 12,101,740.47 767,894.16 1,843,476.34 10,258,264.13 15 1,801,461.52
40 PUBLIC WORKS AGENCY 13,444,799.45 966,046.33 3,125,051.30 10,319,748.15 23 2,974,426.47
Page 1 of 2Run by Jessica Tapia on 04/28/2022 13:36:19 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalOrganizationOrganization Description
Fund Category Governmental Funds
Fund Type GENERAL FUND
Fund 100 - GENERAL FUND
EXPENSE
99 NON-DEPARTMENTAL 20,723,062.00 11,410,420.23 11,410,420.23 9,312,641.77 55 .00
EXPENSE TOTALS $117,890,987.18 $14,975,684.78 $31,792,281.20 $86,098,705.98 27%$28,782,602.51
Fund 100 - GENERAL FUND Totals
REVENUE TOTALS 117,909,687.00 19,261,749.78 42,775,812.08 75,133,874.92 36%32,535,423.13
EXPENSE TOTALS 117,890,987.18 14,975,684.78 31,792,281.20 86,098,705.98 27%28,782,602.51
Fund 100 - GENERAL FUND Net Gain (Loss)$18,699.82 $4,286,065.00 $10,983,530.88 $10,964,831.06 58,736%$3,752,820.62
Fund Type GENERAL FUND Totals
REVENUE TOTALS 117,909,687.00 19,261,749.78 42,775,812.08 75,133,874.92 36%32,535,423.13
EXPENSE TOTALS 117,890,987.18 14,975,684.78 31,792,281.20 86,098,705.98 27%28,782,602.51
Fund Type GENERAL FUND Net Gain (Loss)$18,699.82 $4,286,065.00 $10,983,530.88 $10,964,831.06 58,736%$3,752,820.62
Fund Category Governmental Funds Totals
REVENUE TOTALS 117,909,687.00 19,261,749.78 42,775,812.08 75,133,874.92 36%32,535,423.13
EXPENSE TOTALS 117,890,987.18 14,975,684.78 31,792,281.20 86,098,705.98 27%28,782,602.51
Fund Category Governmental Funds Net Gain (Loss)$18,699.82 $4,286,065.00 $10,983,530.88 $10,964,831.06 58,736%$3,752,820.62
Grand Totals
REVENUE TOTALS 117,909,687.00 19,261,749.78 42,775,812.08 75,133,874.92 36%32,535,423.13
EXPENSE TOTALS 117,890,987.18 14,975,684.78 31,792,281.20 86,098,705.98 27%28,782,602.51
Grand Total Net Gain (Loss)$18,699.82 $4,286,065.00 $10,983,530.88 $10,964,831.06 58,736%$3,752,820.62
Page 2 of 2Run by Jessica Tapia on 04/28/2022 13:36:19 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalOrganizationOrganization Description
Fund Category Governmental Funds
Fund Type GENERAL FUND
Fund 176 - HUMAN SERVICES FUND
REVENUE
Department 24 - HEALTH
Property Taxes 3,110,000.00 1,550,000.00 1,550,000.00 1,560,000.00 50 1,530,000.00
Interfund Transfers .00 .00 .00 .00 +++112,500.00
Intergovernmental Revenue 194,000.00 27,527.67 80,005.01 113,994.99 41 27,499.00
Other Revenue 2,000.00 .00 .00 2,000.00 0 440.00
Interest Income .00 174.69 780.32 (780.32)+++287.29
Department 24 - HEALTH Totals $3,306,000.00 $1,577,702.36 $1,630,785.33 $1,675,214.67 49%$1,670,726.29
REVENUE TOTALS $3,306,000.00 $1,577,702.36 $1,630,785.33 $1,675,214.67 49%$1,670,726.29
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 115,538.07 333,317.71 1,372,502.23 20 307,868.39
Services and Supplies 1,024,810.00 1,272.37 20,269.76 1,004,540.24 2 4,561.98
Insurance and Other Chargebacks .00 .00 .00 .00 +++7,701.10
Community Sponsored Organizations 143,333.00 .00 26,700.00 116,633.00 19 .00
Miscellaneous 258,000.00 8,866.00 22,250.03 235,749.97 9 26,729.87
Department 24 - HEALTH Totals $3,131,962.94 $125,676.44 $402,537.50 $2,729,425.44 13%$346,861.34
EXPENSE TOTALS $3,868,335.94 $125,676.44 $402,537.50 $3,465,798.44 10%$346,861.34
Fund 176 - HUMAN SERVICES FUND Totals
REVENUE TOTALS 3,306,000.00 1,577,702.36 1,630,785.33 1,675,214.67 49%1,670,726.29
EXPENSE TOTALS 3,868,335.94 125,676.44 402,537.50 3,465,798.44 10%346,861.34
Fund 176 - HUMAN SERVICES FUND Net Gain (Loss)($562,335.94)$1,452,025.92 $1,228,247.83 $1,790,583.77 (218%)$1,323,864.95
Fund Type GENERAL FUND Totals
REVENUE TOTALS 3,306,000.00 1,577,702.36 1,630,785.33 1,675,214.67 49%1,670,726.29
EXPENSE TOTALS 3,868,335.94 125,676.44 402,537.50 3,465,798.44 10%346,861.34
Fund Type GENERAL FUND Net Gain (Loss)($562,335.94)$1,452,025.92 $1,228,247.83 $1,790,583.77 (218%)$1,323,864.95
Page 1 of 36Run by Jessica Tapia on 04/28/2022 13:26:56 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 .00
Interest Income .00 309.53 3,262.40 (3,262.40)+++.00
Department 99 - NON-DEPARTMENTAL Totals $21,586,827.00 $309.53 $3,262.40 $21,583,564.60 0%$0.00
REVENUE TOTALS $21,586,827.00 $309.53 $3,262.40 $21,583,564.60 0%$0.00
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 2,037,500.01 6,112,499.99 25 .00
Department 99 - NON-DEPARTMENTAL Totals $30,400,000.00 $679,166.67 $2,037,500.01 $28,362,499.99 7%$0.00
EXPENSE TOTALS $30,400,000.00 $679,166.67 $2,037,500.01 $28,362,499.99 7%$0.00
Fund 170 - AMERICAN RESCUE PLAN Totals
REVENUE TOTALS 21,586,827.00 309.53 3,262.40 21,583,564.60 0%.00
EXPENSE TOTALS 30,400,000.00 679,166.67 2,037,500.01 28,362,499.99 7%.00
Fund 170 - AMERICAN RESCUE PLAN Net Gain (Loss)($8,813,173.00)($678,857.14)($2,034,237.61)$6,778,935.39 23%$0.00
Page 2 of 36Run by Jessica Tapia on 04/28/2022 13:26:56 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 175 - GENERAL ASSISTANCE FUND
REVENUE
Department 24 - HEALTH
Property Taxes 1,300,000.00 481,163.79 692,622.43 607,377.57 53 473,459.66
Other Revenue 27,500.00 .00 25,712.56 1,787.44 94 2,585.00
Interest Income 1,000.00 95.52 319.29 680.71 32 315.14
Department 24 - HEALTH Totals $1,328,500.00 $481,259.31 $718,654.28 $609,845.72 54%$476,359.80
REVENUE TOTALS $1,328,500.00 $481,259.31 $718,654.28 $609,845.72 54%$476,359.80
EXPENSE
Department 24 - HEALTH
Salary and Benefits 469,870.53 35,881.58 108,696.41 361,174.12 23 111,282.91
Services and Supplies 864,482.00 40,296.25 130,157.72 734,324.28 15 158,446.58
Miscellaneous 7,000.00 .00 .00 7,000.00 0 .00
Department 24 - HEALTH Totals $1,341,352.53 $76,177.83 $238,854.13 $1,102,498.40 18%$269,729.49
EXPENSE TOTALS $1,341,352.53 $76,177.83 $238,854.13 $1,102,498.40 18%$269,729.49
Fund 175 - GENERAL ASSISTANCE FUND Totals
REVENUE TOTALS 1,328,500.00 481,259.31 718,654.28 609,845.72 54%476,359.80
EXPENSE TOTALS 1,341,352.53 76,177.83 238,854.13 1,102,498.40 18%269,729.49
Fund 175 - GENERAL ASSISTANCE FUND Net Gain (Loss)($12,852.53)$405,081.48 $479,800.15 $492,652.68 (3,733%)$206,630.31
Page 3 of 36Run by Jessica Tapia on 04/28/2022 13:26:56 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 150.00 2,925.00 (2,925.00)+++8,812.01
Interest Income .00 42.13 129.23 (129.23)+++8.92
Department 15 - CITY MANAGER'S OFFICE Totals $400,000.00 $192.13 $3,054.23 $396,945.77 1%$8,820.93
REVENUE TOTALS $400,000.00 $192.13 $3,054.23 $396,945.77 1%$8,820.93
EXPENSE
Department 15 - CITY MANAGER'S OFFICE
Services and Supplies .00 171.59 595.51 (595.51)+++10.12
Miscellaneous 400,000.00 .00 .00 400,000.00 0 .00
Department 15 - CITY MANAGER'S OFFICE Totals $400,000.00 $171.59 $595.51 $399,404.49 0%$10.12
EXPENSE TOTALS $400,000.00 $171.59 $595.51 $399,404.49 0%$10.12
Fund 177 - REPARATIONS FUND Totals
REVENUE TOTALS 400,000.00 192.13 3,054.23 396,945.77 1%8,820.93
EXPENSE TOTALS 400,000.00 171.59 595.51 399,404.49 0%10.12
Fund 177 - REPARATIONS FUND Net Gain (Loss)$0.00 $20.54 $2,458.72 $2,458.72 +++$8,810.81
Page 4 of 36Run by Jessica Tapia on 04/28/2022 13:26:56 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 78.65 302.05 (302.05)+++104.84
Department 99 - NON-DEPARTMENTAL Totals $0.00 $78.65 $302.05 ($302.05)+++$1,000,104.84
REVENUE TOTALS $0.00 $78.65 $302.05 ($302.05)+++$1,000,104.84
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies .00 36.62 129.94 (129.94)+++47.11
Miscellaneous 1,000,000.00 .00 .00 1,000,000.00 0 .00
Interfund Transfers .00 .00 .00 .00 +++414,151.77
Department 99 - NON-DEPARTMENTAL Totals $1,000,000.00 $36.62 $129.94 $999,870.06 0%$414,198.88
EXPENSE TOTALS $1,000,000.00 $36.62 $129.94 $999,870.06 0%$414,198.88
Fund 180 - GOOD NEIGHBOR FUND Totals
REVENUE TOTALS .00 78.65 302.05 (302.05)+++1,000,104.84
EXPENSE TOTALS 1,000,000.00 36.62 129.94 999,870.06 0%414,198.88
Fund 180 - GOOD NEIGHBOR FUND Net Gain (Loss)($1,000,000.00)$42.03 $172.11 $1,000,172.11 0%$585,905.96
Page 5 of 36Run by Jessica Tapia on 04/28/2022 13:26:56 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 185 - LIBRARY FUND
REVENUE
Department 48 - LIBRARY
Property Taxes 7,252,000.00 2,665,540.71 3,834,457.39 3,417,542.61 53 3,124,918.62
Licenses, Permits and Fees 115,767.00 .00 .00 115,767.00 0 .00
Fines and Forfeitures .00 .00 .00 .00 +++2,972.73
Charges for Services .00 71.32 105.90 (105.90)+++42.53
Interfund Transfers 217,911.00 .00 .00 217,911.00 0 250,000.00
Intergovernmental Revenue 472,866.00 .00 9,211.99 463,654.01 2 31,097.86
Other Revenue 410,000.00 108,901.05 114,461.41 295,538.59 28 67,079.78
Library Revenue 174,800.00 4,806.98 16,182.87 158,617.13 9 17,752.02
Interest Income 15,000.00 396.59 1,312.99 13,687.01 9 2,314.68
Department 48 - LIBRARY Totals $8,658,344.00 $2,779,716.65 $3,975,732.55 $4,682,611.45 46%$3,496,178.22
REVENUE TOTALS $8,658,344.00 $2,779,716.65 $3,975,732.55 $4,682,611.45 46%$3,496,178.22
EXPENSE
Department 48 - LIBRARY
Salary and Benefits 6,132,692.20 421,675.42 1,112,437.85 5,020,254.35 18 1,395,753.93
Services and Supplies 2,136,767.00 196,058.47 332,720.20 1,804,046.80 16 313,319.88
Capital Outlay 8,500.00 .00 .00 8,500.00 0 .00
Miscellaneous .00 24,480.35 51,972.17 (51,972.17)+++.00
Interfund Transfers 379,653.00 31,637.75 94,913.25 284,739.75 25 90,303.00
Department 48 - LIBRARY Totals $8,657,612.20 $673,851.99 $1,592,043.47 $7,065,568.73 18%$1,799,376.81
EXPENSE TOTALS $8,657,612.20 $673,851.99 $1,592,043.47 $7,065,568.73 18%$1,799,376.81
Fund 185 - LIBRARY FUND Totals
REVENUE TOTALS 8,658,344.00 2,779,716.65 3,975,732.55 4,682,611.45 46%3,496,178.22
EXPENSE TOTALS 8,657,612.20 673,851.99 1,592,043.47 7,065,568.73 18%1,799,376.81
Fund 185 - LIBRARY FUND Net Gain (Loss)$731.80 $2,105,864.66 $2,383,689.08 $2,382,957.28 325,730%$1,696,801.41
Page 6 of 36Run by Jessica Tapia on 04/28/2022 13:26:56 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 993,068.01 1,523,435.34 2,133,264.66 42 1,484,491.42
Interest Income 12,000.00 1,002.62 2,216.91 9,783.09 18 1,741.58
Department 40 - PUBLIC WORKS AGENCY Totals $3,668,700.00 $994,070.63 $1,525,652.25 $2,143,047.75 42%$1,486,233.00
REVENUE TOTALS $3,668,700.00 $994,070.63 $1,525,652.25 $2,143,047.75 42%$1,486,233.00
EXPENSE
Department 26 - PUBLIC WORKS
Capital Outlay .00 .00 .00 .00 +++.00
Department 26 - PUBLIC WORKS Totals $0.00 $0.00 $0.00 $0.00 +++$0.00
Department 40 - PUBLIC WORKS AGENCY
Services and Supplies 1,038,000.00 194,817.99 323,872.69 714,127.31 31 334,000.99
Capital Outlay 3,261,000.00 33,560.00 33,560.00 3,227,440.00 1 .00
Interfund Transfers 1,044,987.00 87,082.25 261,246.75 783,740.25 25 261,246.00
Department 40 - PUBLIC WORKS AGENCY Totals $5,343,987.00 $315,460.24 $618,679.44 $4,725,307.56 12%$595,246.99
EXPENSE TOTALS $5,343,987.00 $315,460.24 $618,679.44 $4,725,307.56 12%$595,246.99
Fund 200 - MOTOR FUEL TAX FUND Totals
REVENUE TOTALS 3,668,700.00 994,070.63 1,525,652.25 2,143,047.75 42%1,486,233.00
EXPENSE TOTALS 5,343,987.00 315,460.24 618,679.44 4,725,307.56 12%595,246.99
Fund 200 - MOTOR FUEL TAX FUND Net Gain (Loss)($1,675,287.00)$678,610.39 $906,972.81 $2,582,259.81 (54%)$890,986.01
Page 8 of 36Run by Jessica Tapia on 04/28/2022 13:26:56 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 126,427.19 365,588.41 1,034,411.59 26 356,657.98
Other Revenue .00 .00 .00 .00 +++266.17
Interest Income 7,000.00 81.04 325.19 6,674.81 5 265.33
Department 22 - POLICE Totals $1,407,000.00 $126,508.23 $365,913.60 $1,041,086.40 26%$357,189.48
REVENUE TOTALS $1,407,000.00 $126,508.23 $365,913.60 $1,041,086.40 26%$357,189.48
EXPENSE
Department 22 - POLICE
Salary and Benefits 768,615.60 55,933.45 171,438.74 597,176.86 22 112,557.66
Services and Supplies 393,700.00 6,890.06 43,773.40 349,926.60 11 34,443.28
Capital Outlay 450,000.00 130.00 23,780.35 426,219.65 5 1,950.00
Insurance and Other Chargebacks 18,230.00 1,519.17 4,557.51 13,672.49 25 4,557.00
Interfund Transfers 90,000.00 7,500.00 22,500.00 67,500.00 25 22,500.00
Department 22 - POLICE Totals $1,720,545.60 $71,972.68 $266,050.00 $1,454,495.60 15%$176,007.94
EXPENSE TOTALS $1,720,545.60 $71,972.68 $266,050.00 $1,454,495.60 15%$176,007.94
Fund 205 - EMERGENCY TELEPHONE (E911) FUND Totals
REVENUE TOTALS 1,407,000.00 126,508.23 365,913.60 1,041,086.40 26%357,189.48
EXPENSE TOTALS 1,720,545.60 71,972.68 266,050.00 1,454,495.60 15%176,007.94
Fund 205 - EMERGENCY TELEPHONE (E911) FUND Net Gain (Loss)($313,545.60)$54,535.55 $99,863.60 $413,409.20 (32%)$181,181.54
Page 9 of 36Run by Jessica Tapia on 04/28/2022 13:26:56 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 237,018.08 312,969.59 282,030.41 53 150,433.09
Interest Income .00 .00 .00 .00 +++1.26
Department 21 - COMMUNITY DEVELOPMENT Totals $595,000.00 $237,018.08 $312,969.59 $282,030.41 53%$150,434.35
REVENUE TOTALS $595,000.00 $237,018.08 $312,969.59 $282,030.41 53%$150,434.35
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies 575,000.00 .00 .00 575,000.00 0 .00
Department 21 - COMMUNITY DEVELOPMENT Totals $575,000.00 $0.00 $0.00 $575,000.00 0%$0.00
EXPENSE TOTALS $575,000.00 $0.00 $0.00 $575,000.00 0%$0.00
Fund 210 - SPECIAL SERVICE AREA (SSA) #9 Totals
REVENUE TOTALS 595,000.00 237,018.08 312,969.59 282,030.41 53%150,434.35
EXPENSE TOTALS 575,000.00 .00 .00 575,000.00 0%.00
Fund 210 - SPECIAL SERVICE AREA (SSA) #9 Net Gain (Loss)$20,000.00 $237,018.08 $312,969.59 $292,969.59 1,565%$150,434.35
Page 10 of 36Run by Jessica Tapia on 04/28/2022 13:26:56 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 .00
Interest Income .00 23.51 29.58 (29.58)+++.00
Department 21 - COMMUNITY DEVELOPMENT Totals $3,684,820.00 $23.51 $29.58 $3,684,790.42 0%$0.00
REVENUE TOTALS $3,684,820.00 $23.51 $29.58 $3,684,790.42 0%$0.00
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Salary and Benefits 589,421.52 28,807.64 86,218.95 503,202.57 15 82,120.66
Services and Supplies 506,200.00 1,862.01 3,722.58 502,477.42 1 3,597.29
Capital Outlay .00 .00 .00 .00 +++36,000.00
Community Sponsored Organizations 75,000.00 69,527.63 69,527.63 5,472.37 93 2,500.00
Miscellaneous 2,515,000.00 173.87 216.27 2,514,783.73 0 94.00
Department 21 - COMMUNITY DEVELOPMENT Totals $3,685,621.52 $100,371.15 $159,685.43 $3,525,936.09 4%$124,311.95
EXPENSE TOTALS $3,685,621.52 $100,371.15 $159,685.43 $3,525,936.09 4%$124,311.95
Fund 215 - CDBG FUND Totals
REVENUE TOTALS 3,684,820.00 23.51 29.58 3,684,790.42 0%.00
EXPENSE TOTALS 3,685,621.52 100,371.15 159,685.43 3,525,936.09 4%124,311.95
Fund 215 - CDBG FUND Net Gain (Loss)($801.52)($100,347.64)($159,655.85)($158,854.33)19,919%($124,311.95)
Page 11 of 36Run by Jessica Tapia on 04/28/2022 13:26:56 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 220 - CDBG LOAN FUND
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Other Revenue 100,000.00 619.60 51,551.05 48,448.95 52 32,999.59
Interest Income .00 44.66 156.67 (156.67)+++241.38
Department 21 - COMMUNITY DEVELOPMENT Totals $100,000.00 $664.26 $51,707.72 $48,292.28 52%$33,240.97
REVENUE TOTALS $100,000.00 $664.26 $51,707.72 $48,292.28 52%$33,240.97
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies 175,000.00 .00 .00 175,000.00 0 .00
Department 21 - COMMUNITY DEVELOPMENT Totals $175,000.00 $0.00 $0.00 $175,000.00 0%$0.00
EXPENSE TOTALS $175,000.00 $0.00 $0.00 $175,000.00 0%$0.00
Fund 220 - CDBG LOAN FUND Totals
REVENUE TOTALS 100,000.00 664.26 51,707.72 48,292.28 52%33,240.97
EXPENSE TOTALS 175,000.00 .00 .00 175,000.00 0%.00
Fund 220 - CDBG LOAN FUND Net Gain (Loss)($75,000.00)$664.26 $51,707.72 $126,707.72 (69%)$33,240.97
Page 12 of 36Run by Jessica Tapia on 04/28/2022 13:26:56 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 235 - NEIGHBORHOOD IMPROVEMENT
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Interest Income .00 1.92 7.40 (7.40)+++6.60
Department 21 - COMMUNITY DEVELOPMENT Totals $0.00 $1.92 $7.40 ($7.40)+++$6.60
REVENUE TOTALS $0.00 $1.92 $7.40 ($7.40)+++$6.60
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Services and Supplies .00 .90 3.19 (3.19)+++2.96
Department 21 - COMMUNITY DEVELOPMENT Totals $0.00 $0.90 $3.19 ($3.19)+++$2.96
EXPENSE TOTALS $0.00 $0.90 $3.19 ($3.19)+++$2.96
Fund 235 - NEIGHBORHOOD IMPROVEMENT Totals
REVENUE TOTALS .00 1.92 7.40 (7.40)+++6.60
EXPENSE TOTALS .00 .90 3.19 (3.19)+++2.96
Fund 235 - NEIGHBORHOOD IMPROVEMENT Net Gain (Loss)$0.00 $1.02 $4.21 $4.21 +++$3.64
Page 13 of 36Run by Jessica Tapia on 04/28/2022 13:26:56 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
Fund Category Governmental Funds
Fund Type Special Revenue Funds
Fund 240 - HOME FUND
REVENUE
Department 21 - COMMUNITY DEVELOPMENT
Intergovernmental Revenue 540,453.00 164,704.07 164,704.07 375,748.93 30 .00
Other Revenue 25,000.00 6,935.04 7,185.04 17,814.96 29 10,883.57
Interest Income 150.00 3.92 15.73 134.27 10 15.60
Department 21 - COMMUNITY DEVELOPMENT Totals $565,603.00 $171,643.03 $171,904.84 $393,698.16 30%$10,899.17
REVENUE TOTALS $565,603.00 $171,643.03 $171,904.84 $393,698.16 30%$10,899.17
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Salary and Benefits 70,680.63 4,886.29 14,657.62 56,023.01 21 15,561.20
Services and Supplies 500,565.00 201,721.99 202,322.23 298,242.77 40 605.72
Miscellaneous 500.00 .00 .00 500.00 0 .00
Department 21 - COMMUNITY DEVELOPMENT Totals $571,745.63 $206,608.28 $216,979.85 $354,765.78 38%$16,166.92
EXPENSE TOTALS $571,745.63 $206,608.28 $216,979.85 $354,765.78 38%$16,166.92
Fund 240 - HOME FUND Totals
REVENUE TOTALS 565,603.00 171,643.03 171,904.84 393,698.16 30%10,899.17
EXPENSE TOTALS 571,745.63 206,608.28 216,979.85 354,765.78 38%16,166.92
Fund 240 - HOME FUND Net Gain (Loss)($6,142.63)($34,965.25)($45,075.01)($38,932.38)734%($5,267.75)
Fund Type Special Revenue Funds Totals
REVENUE TOTALS 565,603.00 171,643.03 171,904.84 393,698.16 30%10,899.17
EXPENSE TOTALS 571,745.63 206,608.28 216,979.85 354,765.78 38%16,166.92
Fund Type Special Revenue Funds Net Gain (Loss)($6,142.63)($34,965.25)($45,075.01)($38,932.38)734%($5,267.75)
Fund Category Governmental Funds Totals
REVENUE TOTALS 565,603.00 171,643.03 171,904.84 393,698.16 30%10,899.17
EXPENSE TOTALS 571,745.63 206,608.28 216,979.85 354,765.78 38%16,166.92
Fund Category Governmental Funds Net Gain (Loss)($6,142.63)($34,965.25)($45,075.01)($38,932.38)734%($5,267.75)
Grand Totals
REVENUE TOTALS 565,603.00 171,643.03 171,904.84 393,698.16 30%10,899.17
EXPENSE TOTALS 571,745.63 206,608.28 216,979.85 354,765.78 38%16,166.92
Grand Total Net Gain (Loss)($6,142.63)($34,965.25)($45,075.01)($38,932.38)734%($5,267.75)
Page 1 of 2Run by Jessica Tapia on 04/28/2022 16:48:18 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 .00
Intergovernmental Revenue 658,000.00 .00 .00 658,000.00 0 .00
Other Revenue 140,600.00 416.67 31,666.67 108,933.33 23 32,083.34
Interest Income 5,700.00 456.51 1,264.78 4,435.22 22 2,775.02
Department 21 - COMMUNITY DEVELOPMENT Totals $879,300.00 $873.18 $32,931.45 $846,368.55 4%$34,858.36
REVENUE TOTALS $879,300.00 $873.18 $32,931.45 $846,368.55 4%$34,858.36
EXPENSE
Department 21 - COMMUNITY DEVELOPMENT
Salary and Benefits 180,075.00 13,796.37 41,474.11 138,600.89 23 40,772.60
Services and Supplies 2,065,050.00 24,569.00 24,579.00 2,040,471.00 1 1,874.77
Capital Outlay 10,000.00 .00 .00 10,000.00 0 .00
Insurance and Other Chargebacks 17,000.00 .00 .00 17,000.00 0 .00
Community Sponsored Organizations 166,000.00 26,755.61 26,755.61 139,244.39 16 .00
Miscellaneous 67,500.00 1,120.00 2,932.31 64,567.69 4 3,308.50
Department 21 - COMMUNITY DEVELOPMENT Totals $2,505,625.00 $66,240.98 $95,741.03 $2,409,883.97 4%$45,955.87
EXPENSE TOTALS $2,505,625.00 $66,240.98 $95,741.03 $2,409,883.97 4%$45,955.87
Fund 250 - AFFORDABLE HOUSING FUND Totals
REVENUE TOTALS 879,300.00 873.18 32,931.45 846,368.55 4%34,858.36
EXPENSE TOTALS 2,505,625.00 66,240.98 95,741.03 2,409,883.97 4%45,955.87
Fund 250 - AFFORDABLE HOUSING FUND Net Gain (Loss)($1,626,325.00)($65,367.80)($62,809.58)$1,563,515.42 4%($11,097.51)
Fund Type Special Revenue Funds Totals
REVENUE TOTALS 42,308,491.00 4,620,716.08 6,990,217.10 35,318,273.90 17%7,043,426.55
EXPENSE TOTALS 55,804,743.85 1,981,590.65 5,009,282.15 50,795,461.70 9%3,424,841.01
Fund Type Special Revenue Funds Net Gain (Loss)($13,496,252.85)$2,639,125.43 $1,980,934.95 $15,477,187.80 (15%)$3,618,585.54
Page 14 of 36Run by Jessica Tapia on 04/28/2022 13:26:56 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
Fund Category Governmental Funds
Fund Type Debt Service Funds
Fund 186 - LIBRARY DEBT SERVICE FUND
REVENUE
Department 48 - LIBRARY
Property Taxes 506,625.00 253,313.00 253,313.00 253,312.00 50 200,000.00
Department 48 - LIBRARY Totals $506,625.00 $253,313.00 $253,313.00 $253,312.00 50%$200,000.00
REVENUE TOTALS $506,625.00 $253,313.00 $253,313.00 $253,312.00 50%$200,000.00
EXPENSE
Department 48 - LIBRARY
Debt Service 506,625.00 .00 .00 506,625.00 0 .00
Department 48 - LIBRARY Totals $506,625.00 $0.00 $0.00 $506,625.00 0%$0.00
EXPENSE TOTALS $506,625.00 $0.00 $0.00 $506,625.00 0%$0.00
Fund 186 - LIBRARY DEBT SERVICE FUND Totals
REVENUE TOTALS 506,625.00 253,313.00 253,313.00 253,312.00 50%200,000.00
EXPENSE TOTALS 506,625.00 .00 .00 506,625.00 0%.00
Fund 186 - LIBRARY DEBT SERVICE FUND Net Gain (Loss)$0.00 $253,313.00 $253,313.00 $253,313.00 +++$200,000.00
Page 15 of 36Run by Jessica Tapia on 04/28/2022 13:26:56 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 612,648.04 653,023.97 446,976.03 59 592,301.79
Other Revenue 5,366.00 3,947.23 11,841.69 (6,475.69)221 .00
Interest Income 400.00 387.02 1,008.86 (608.86)252 1,647.38
Department 99 - NON-DEPARTMENTAL Totals $1,105,766.00 $616,982.29 $665,874.52 $439,891.48 60%$593,949.17
REVENUE TOTALS $1,105,766.00 $616,982.29 $665,874.52 $439,891.48 60%$593,949.17
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 265,000.00 1,149.74 1,151.58 263,848.42 0 560.88
Capital Outlay 785,000.00 .00 .00 785,000.00 0 .00
Interfund Transfers 398,113.00 33,176.08 99,528.24 298,584.76 25 54,528.00
Department 99 - NON-DEPARTMENTAL Totals $1,448,113.00 $34,325.82 $100,679.82 $1,347,433.18 7%$55,088.88
EXPENSE TOTALS $1,448,113.00 $34,325.82 $100,679.82 $1,347,433.18 7%$55,088.88
Fund 330 - HOWARD-RIDGE TIF FUND Totals
REVENUE TOTALS 1,105,766.00 616,982.29 665,874.52 439,891.48 60%593,949.17
EXPENSE TOTALS 1,448,113.00 34,325.82 100,679.82 1,347,433.18 7%55,088.88
Fund 330 - HOWARD-RIDGE TIF FUND Net Gain (Loss)($342,347.00)$582,656.47 $565,194.70 $907,541.70 (165%)$538,860.29
Page 16 of 36Run by Jessica Tapia on 04/28/2022 13:26:56 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 607,632.50 835,646.60 614,353.40 58 765,291.67
Other Revenue 11,000.00 .00 .00 11,000.00 0 171,504.26
Interest Income 4,000.00 178.02 445.52 3,554.48 11 752.69
Department 99 - NON-DEPARTMENTAL Totals $1,465,000.00 $607,810.52 $836,092.12 $628,907.88 57%$937,548.62
REVENUE TOTALS $1,465,000.00 $607,810.52 $836,092.12 $628,907.88 57%$937,548.62
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 5,000.00 31.00 1,700.87 3,299.13 34 340.85
Capital Outlay 1,765,000.00 .00 .00 1,765,000.00 0 .00
Miscellaneous 200,000.00 .00 .00 200,000.00 0 .00
Interfund Transfers 75,000.00 6,250.00 18,750.00 56,250.00 25 18,750.00
Department 99 - NON-DEPARTMENTAL Totals $2,045,000.00 $6,281.00 $20,450.87 $2,024,549.13 1%$19,090.85
EXPENSE TOTALS $2,045,000.00 $6,281.00 $20,450.87 $2,024,549.13 1%$19,090.85
Fund 335 - WEST EVANSTON TIF FUND Totals
REVENUE TOTALS 1,465,000.00 607,810.52 836,092.12 628,907.88 57%937,548.62
EXPENSE TOTALS 2,045,000.00 6,281.00 20,450.87 2,024,549.13 1%19,090.85
Fund 335 - WEST EVANSTON TIF FUND Net Gain (Loss)($580,000.00)$601,529.52 $815,641.25 $1,395,641.25 (141%)$918,457.77
Page 17 of 36Run by Jessica Tapia on 04/28/2022 13:26:56 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 155,621.52 155,621.52 4,378.48 97 93,668.57
Interest Income .00 16.63 43.26 (43.26)+++79.06
Department 99 - NON-DEPARTMENTAL Totals $160,000.00 $155,638.15 $155,664.78 $4,335.22 97%$93,747.63
REVENUE TOTALS $160,000.00 $155,638.15 $155,664.78 $4,335.22 97%$93,747.63
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 2,000.00 25.56 26.29 1,973.71 1 332.27
Interfund Transfers 171,833.00 14,319.41 42,958.23 128,874.77 25 42,231.00
Department 99 - NON-DEPARTMENTAL Totals $173,833.00 $14,344.97 $42,984.52 $130,848.48 25%$42,563.27
EXPENSE TOTALS $173,833.00 $14,344.97 $42,984.52 $130,848.48 25%$42,563.27
Fund 340 - DEMPSTER-DODGE TIF FUND Totals
REVENUE TOTALS 160,000.00 155,638.15 155,664.78 4,335.22 97%93,747.63
EXPENSE TOTALS 173,833.00 14,344.97 42,984.52 130,848.48 25%42,563.27
Fund 340 - DEMPSTER-DODGE TIF FUND Net Gain (Loss)($13,833.00)$141,293.18 $112,680.26 $126,513.26 (815%)$51,184.36
Page 18 of 36Run by Jessica Tapia on 04/28/2022 13:26:57 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 506,093.20 601,258.83 398,741.17 60 402,160.01
Interest Income .00 53.56 132.38 (132.38)+++550.76
Department 99 - NON-DEPARTMENTAL Totals $1,000,000.00 $506,146.76 $601,391.21 $398,608.79 60%$402,710.77
REVENUE TOTALS $1,000,000.00 $506,146.76 $601,391.21 $398,608.79 60%$402,710.77
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 5,000.00 26.80 28.97 4,971.03 1 338.36
Capital Outlay 1,090,000.00 25,341.45 25,341.45 1,064,658.55 2 116,566.73
Miscellaneous 250,000.00 .00 .00 250,000.00 0 .00
Interfund Transfers 264,763.00 22,063.58 66,190.74 198,572.26 25 65,712.00
Department 99 - NON-DEPARTMENTAL Totals $1,609,763.00 $47,431.83 $91,561.16 $1,518,201.84 6%$182,617.09
EXPENSE TOTALS $1,609,763.00 $47,431.83 $91,561.16 $1,518,201.84 6%$182,617.09
Fund 345 - CHICAGO-MAIN TIF Totals
REVENUE TOTALS 1,000,000.00 506,146.76 601,391.21 398,608.79 60%402,710.77
EXPENSE TOTALS 1,609,763.00 47,431.83 91,561.16 1,518,201.84 6%182,617.09
Fund 345 - CHICAGO-MAIN TIF Net Gain (Loss)($609,763.00)$458,714.93 $509,830.05 $1,119,593.05 (84%)$220,093.68
Page 19 of 36Run by Jessica Tapia on 04/28/2022 13:26:57 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 91,411.69 118,882.41 102,117.59 54 2,711.90
Interest Income .00 1.44 1.73 (1.73)+++1.70
Department 99 - NON-DEPARTMENTAL Totals $221,000.00 $91,413.13 $118,884.14 $102,115.86 54%$2,713.60
REVENUE TOTALS $221,000.00 $91,413.13 $118,884.14 $102,115.86 54%$2,713.60
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 221,000.00 (.01).00 221,000.00 0 .02
Department 99 - NON-DEPARTMENTAL Totals $221,000.00 ($0.01)$0.00 $221,000.00 0%$0.02
EXPENSE TOTALS $221,000.00 ($0.01)$0.00 $221,000.00 0%$0.02
Fund 350 - SPECIAL SERVICE AREA (SSA) #6 Totals
REVENUE TOTALS 221,000.00 91,413.13 118,884.14 102,115.86 54%2,713.60
EXPENSE TOTALS 221,000.00 (.01).00 221,000.00 0%.02
Fund 350 - SPECIAL SERVICE AREA (SSA) #6 Net Gain (Loss)$0.00 $91,413.14 $118,884.14 $118,884.14 +++$2,713.58
Page 20 of 36Run by Jessica Tapia on 04/28/2022 13:26:57 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 52,118.91 76,402.54 65,597.46 54 44,826.94
Interest Income .00 4.55 10.57 (10.57)+++26.30
Department 99 - NON-DEPARTMENTAL Totals $142,000.00 $52,123.46 $76,413.11 $65,586.89 54%$44,853.24
REVENUE TOTALS $142,000.00 $52,123.46 $76,413.11 $65,586.89 54%$44,853.24
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 140,000.00 (.16).00 140,000.00 0 .34
Department 99 - NON-DEPARTMENTAL Totals $140,000.00 ($0.16)$0.00 $140,000.00 0%$0.34
EXPENSE TOTALS $140,000.00 ($0.16)$0.00 $140,000.00 0%$0.34
Fund 355 - SPECIAL SERVICE AREA (SSA) #7 Totals
REVENUE TOTALS 142,000.00 52,123.46 76,413.11 65,586.89 54%44,853.24
EXPENSE TOTALS 140,000.00 (.16).00 140,000.00 0%.34
Fund 355 - SPECIAL SERVICE AREA (SSA) #7 Net Gain (Loss)$2,000.00 $52,123.62 $76,413.11 $74,413.11 3,821%$44,852.90
Page 21 of 36Run by Jessica Tapia on 04/28/2022 13:26:57 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 18,712.29 30,167.05 30,032.95 50 21,513.88
Interest Income .00 .00 .00 .00 +++.12
Department 99 - NON-DEPARTMENTAL Totals $60,200.00 $18,712.29 $30,167.05 $30,032.95 50%$21,514.00
REVENUE TOTALS $60,200.00 $18,712.29 $30,167.05 $30,032.95 50%$21,514.00
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies 60,200.00 .00 .00 60,200.00 0 .00
Department 99 - NON-DEPARTMENTAL Totals $60,200.00 $0.00 $0.00 $60,200.00 0%$0.00
EXPENSE TOTALS $60,200.00 $0.00 $0.00 $60,200.00 0%$0.00
Fund 360 - SPECIAL SERVICE AREA (SSA) #8 Totals
REVENUE TOTALS 60,200.00 18,712.29 30,167.05 30,032.95 50%21,514.00
EXPENSE TOTALS 60,200.00 .00 .00 60,200.00 0%.00
Fund 360 - SPECIAL SERVICE AREA (SSA) #8 Net Gain (Loss)$0.00 $18,712.29 $30,167.05 $30,167.05 +++$21,514.00
Fund Type Debt Service Funds Totals
REVENUE TOTALS 4,660,591.00 2,302,139.60 2,737,799.93 1,922,791.07 59%2,297,037.03
EXPENSE TOTALS 6,204,534.00 102,383.45 255,676.37 5,948,857.63 4%299,360.45
Fund Type Debt Service Funds Net Gain (Loss)($1,543,943.00)$2,199,756.15 $2,482,123.56 $4,026,066.56 (161%)$1,997,676.58
Page 22 of 36Run by Jessica Tapia on 04/28/2022 13:26:57 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 89,774.02
Department 48 - LIBRARY Totals $680,000.00 $0.00 $0.00 $680,000.00 0%$89,774.02
EXPENSE TOTALS $680,000.00 $0.00 $0.00 $680,000.00 0%$89,774.02
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%89,774.02
Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD Net Gain (Loss)($200,000.00)$0.00 $0.00 $200,000.00 0%($89,774.02)
Page 23 of 36Run by Jessica Tapia on 04/28/2022 13:26:57 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 5,150,292.77 7,520,329.47 5,915,926.53 56 5,519,687.39
Interfund Transfers 2,267,041.00 188,920.08 566,760.24 1,700,280.76 25 299,355.00
Other Revenue .00 .00 .00 .00 +++(80.37)
Interest Income 1,500.00 786.23 2,062.77 (562.77)138 774.99
Department 99 - NON-DEPARTMENTAL Totals $15,704,797.00 $5,339,999.08 $8,089,152.48 $7,615,644.52 52%$5,819,737.01
REVENUE TOTALS $15,704,797.00 $5,339,999.08 $8,089,152.48 $7,615,644.52 52%$5,819,737.01
EXPENSE
Department 99 - NON-DEPARTMENTAL
Services and Supplies .00 .00 .00 .00 +++.74
Debt Service 15,690,075.00 .00 .00 15,690,075.00 0 .00
Miscellaneous .00 6,330.49 13,439.73 (13,439.73)+++.00
Department 99 - NON-DEPARTMENTAL Totals $15,690,075.00 $6,330.49 $13,439.73 $15,676,635.27 0%$0.74
EXPENSE TOTALS $15,690,075.00 $6,330.49 $13,439.73 $15,676,635.27 0%$0.74
Fund 320 - DEBT SERVICE FUND Totals
REVENUE TOTALS 15,704,797.00 5,339,999.08 8,089,152.48 7,615,644.52 52%5,819,737.01
EXPENSE TOTALS 15,690,075.00 6,330.49 13,439.73 15,676,635.27 0%.74
Fund 320 - DEBT SERVICE FUND Net Gain (Loss)$14,722.00 $5,333,668.59 $8,075,712.75 $8,060,990.75 54,855%$5,819,736.27
Page 24 of 36Run by Jessica Tapia on 04/28/2022 13:26:57 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 415 - CAPITAL IMPROVEMENTS FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Charges for Services .00 5,902.70 5,902.70 (5,902.70)+++.00
Other Revenue 12,253,000.00 .00 72,853.02 12,180,146.98 1 .00
Interest Income .00 1,699.02 5,562.45 (5,562.45)+++4,036.10
Department 40 - PUBLIC WORKS AGENCY Totals $12,253,000.00 $7,601.72 $84,318.17 $12,168,681.83 1%$4,036.10
Department 99 - NON-DEPARTMENTAL
Other Revenue .00 .00 .00 .00 +++(641.34)
Interest Income .00 .00 .00 .00 +++758.29
Department 99 - NON-DEPARTMENTAL Totals $0.00 $0.00 $0.00 $0.00 +++$116.95
REVENUE TOTALS $12,253,000.00 $7,601.72 $84,318.17 $12,168,681.83 1%$4,153.05
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits .00 .00 .00 .00 +++159,162.34
Services and Supplies .00 229,897.82 236,443.16 (236,443.16)+++105,091.41
Capital Outlay 16,455,000.00 10,560.00 10,577.45 16,444,422.55 0 321,890.61
Miscellaneous .00 .00 1,026.81 (1,026.81)+++.00
Department 40 - PUBLIC WORKS AGENCY Totals $16,455,000.00 $240,457.82 $248,047.42 $16,206,952.58 2%$586,144.36
Department 99 - NON-DEPARTMENTAL
Miscellaneous .00 18,154.49 38,542.26 (38,542.26)+++.00
Department 99 - NON-DEPARTMENTAL Totals $0.00 $18,154.49 $38,542.26 ($38,542.26)+++$0.00
EXPENSE TOTALS $16,455,000.00 $258,612.31 $286,589.68 $16,168,410.32 2%$586,144.36
Fund 415 - CAPITAL IMPROVEMENTS FUND Totals
REVENUE TOTALS 12,253,000.00 7,601.72 84,318.17 12,168,681.83 1%4,153.05
EXPENSE TOTALS 16,455,000.00 258,612.31 286,589.68 16,168,410.32 2%586,144.36
Fund 415 - CAPITAL IMPROVEMENTS FUND Net Gain (Loss)($4,202,000.00)($251,010.59)($202,271.51)$3,999,728.49 5%($581,991.31)
Page 25 of 36Run by Jessica Tapia on 04/28/2022 13:26:57 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 416 - CROWN CONSTRUCTION FUND
REVENUE
Department 40 - PUBLIC WORKS AGENCY
Other Revenue 1,000,000.00 .00 .00 1,000,000.00 0 2,000,000.00
Interest Income .00 979.43 3,071.89 (3,071.89)+++2,950.61
Department 40 - PUBLIC WORKS AGENCY Totals $1,000,000.00 $979.43 $3,071.89 $996,928.11 0%$2,002,950.61
REVENUE TOTALS $1,000,000.00 $979.43 $3,071.89 $996,928.11 0%$2,002,950.61
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Services and Supplies .00 5.00 15.00 (15.00)+++6,284.13
Capital Outlay 800,000.00 2,255.00 2,255.00 797,745.00 0 18,752.50
Interfund Transfers 900,000.00 75,000.00 225,000.00 675,000.00 25 .00
Department 40 - PUBLIC WORKS AGENCY Totals $1,700,000.00 $77,260.00 $227,270.00 $1,472,730.00 13%$25,036.63
EXPENSE TOTALS $1,700,000.00 $77,260.00 $227,270.00 $1,472,730.00 13%$25,036.63
Fund 416 - CROWN CONSTRUCTION FUND Totals
REVENUE TOTALS 1,000,000.00 979.43 3,071.89 996,928.11 0%2,002,950.61
EXPENSE TOTALS 1,700,000.00 77,260.00 227,270.00 1,472,730.00 13%25,036.63
Fund 416 - CROWN CONSTRUCTION FUND Net Gain (Loss)($700,000.00)($76,280.57)($224,198.11)$475,801.89 32%$1,977,913.98
Page 26 of 36Run by Jessica Tapia on 04/28/2022 13:26:57 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 43,749.99 131,250.01 25 43,749.00
Department 40 - PUBLIC WORKS AGENCY Totals $175,000.00 $14,583.33 $43,749.99 $131,250.01 25%$43,749.00
REVENUE TOTALS $175,000.00 $14,583.33 $43,749.99 $131,250.01 25%$43,749.00
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Capital Outlay .00 23,076.00 23,076.00 (23,076.00)+++.00
Department 40 - PUBLIC WORKS AGENCY Totals $0.00 $23,076.00 $23,076.00 ($23,076.00)+++$0.00
EXPENSE TOTALS $0.00 $23,076.00 $23,076.00 ($23,076.00)+++$0.00
Fund 417 - CROWN COMMUNITY CTR MAINTENANCE Totals
REVENUE TOTALS 175,000.00 14,583.33 43,749.99 131,250.01 25%43,749.00
EXPENSE TOTALS .00 23,076.00 23,076.00 (23,076.00)+++.00
Fund 417 - CROWN COMMUNITY CTR MAINTENANCE Net Gain (Loss)$175,000.00 ($8,492.67)$20,673.99 ($154,326.01)12%$43,749.00
Page 27 of 36Run by Jessica Tapia on 04/28/2022 13:26:57 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
Fund Category Governmental Funds
Fund Type Capital Project Funds
Fund 420 - SPECIAL ASSESSMENT FUND
REVENUE
Department 26 - PUBLIC WORKS
Other Taxes 125,000.00 1,533.46 46,822.69 78,177.31 37 44,657.61
Interest Income 30,000.00 357.34 4,941.84 25,058.16 16 1,874.33
Department 26 - PUBLIC WORKS Totals $155,000.00 $1,890.80 $51,764.53 $103,235.47 33%$46,531.94
REVENUE TOTALS $155,000.00 $1,890.80 $51,764.53 $103,235.47 33%$46,531.94
EXPENSE
Department 26 - PUBLIC WORKS
Services and Supplies .00 5.00 15.00 (15.00)+++15.00
Department 26 - PUBLIC WORKS Totals $0.00 $5.00 $15.00 ($15.00)+++$15.00
Department 40 - PUBLIC WORKS AGENCY
Capital Outlay 650,000.00 11,440.00 11,440.00 638,560.00 2 .00
Interfund Transfers 464,938.00 38,744.84 116,234.52 348,703.48 25 122,331.00
Department 40 - PUBLIC WORKS AGENCY Totals $1,114,938.00 $50,184.84 $127,674.52 $987,263.48 11%$122,331.00
EXPENSE TOTALS $1,114,938.00 $50,189.84 $127,689.52 $987,248.48 11%$122,346.00
Fund 420 - SPECIAL ASSESSMENT FUND Totals
REVENUE TOTALS 155,000.00 1,890.80 51,764.53 103,235.47 33%46,531.94
EXPENSE TOTALS 1,114,938.00 50,189.84 127,689.52 987,248.48 11%122,346.00
Fund 420 - SPECIAL ASSESSMENT FUND Net Gain (Loss)($959,938.00)($48,299.04)($75,924.99)$884,013.01 8%($75,814.06)
Fund Type Capital Project Funds Totals
REVENUE TOTALS 29,767,797.00 5,365,054.36 8,272,057.06 21,495,739.94 28%7,917,121.61
EXPENSE TOTALS 35,640,013.00 415,468.64 678,064.93 34,961,948.07 2%823,301.75
Fund Type Capital Project Funds Net Gain (Loss)($5,872,216.00)$4,949,585.72 $7,593,992.13 $13,466,208.13 (129%)$7,093,819.86
Fund Category Governmental Funds Totals
REVENUE TOTALS 80,042,879.00 13,865,612.40 19,630,859.42 60,412,019.58 25%18,928,311.48
EXPENSE TOTALS 101,517,626.79 2,625,119.18 6,345,560.95 95,172,065.84 6%4,894,364.55
Fund Category Governmental Funds Net Gain (Loss)($21,474,747.79)$11,240,493.22 $13,285,298.47 $34,760,046.26 (62%)$14,033,946.93
Page 28 of 36Run by Jessica Tapia on 04/28/2022 13:26:57 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 505 - PARKING SYSTEM FUND
REVENUE
Department 19 - ADMINISTRATIVE SERVICES
Charges for Services 8,873,975.00 719,732.57 1,743,809.47 7,130,165.53 20 1,551,228.27
Intergovernmental Revenue 2,300,000.00 191,666.67 575,000.01 1,724,999.99 25 .00
Other Revenue 486,700.00 33,790.35 69,982.77 416,717.23 14 64,236.71
Interest Income 20,000.00 523.11 1,428.15 18,571.85 7 1,127.12
Department 19 - ADMINISTRATIVE SERVICES Totals $11,680,675.00 $945,712.70 $2,390,220.40 $9,290,454.60 20%$1,616,592.10
REVENUE TOTALS $11,680,675.00 $945,712.70 $2,390,220.40 $9,290,454.60 20%$1,616,592.10
EXPENSE
Department 15 - CITY MANAGER'S OFFICE
Salary and Benefits 334,851.42 21,792.85 65,333.39 269,518.03 20 58,638.91
Department 15 - CITY MANAGER'S OFFICE Totals $334,851.42 $21,792.85 $65,333.39 $269,518.03 20%$58,638.91
Department 19 - ADMINISTRATIVE SERVICES
Salary and Benefits 813,004.00 49,610.75 146,171.42 666,832.58 18 194,792.04
Services and Supplies 4,550,316.00 375,140.82 874,125.84 3,676,190.16 19 995,922.32
Capital Outlay 2,025,000.00 78,800.00 78,800.00 1,946,200.00 4 27,350.83
Insurance and Other Chargebacks 351,502.00 29,291.83 87,875.49 263,626.51 25 87,876.00
Debt Service 72,900.00 .00 .00 72,900.00 0 .00
Miscellaneous 50,000.00 2,440.67 5,181.57 44,818.43 10 .00
Interfund Transfers 3,132,390.00 261,032.50 783,097.50 2,349,292.50 25 783,096.00
Department 19 - ADMINISTRATIVE SERVICES Totals $10,995,112.00 $796,316.57 $1,975,251.82 $9,019,860.18 18%$2,089,037.19
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits 489,417.38 37,814.67 113,860.38 375,557.00 23 112,698.39
Department 40 - PUBLIC WORKS AGENCY Totals $489,417.38 $37,814.67 $113,860.38 $375,557.00 23%$112,698.39
EXPENSE TOTALS $11,819,380.80 $855,924.09 $2,154,445.59 $9,664,935.21 18%$2,260,374.49
Fund 505 - PARKING SYSTEM FUND Totals
REVENUE TOTALS 11,680,675.00 945,712.70 2,390,220.40 9,290,454.60 20%1,616,592.10
EXPENSE TOTALS 11,819,380.80 855,924.09 2,154,445.59 9,664,935.21 18%2,260,374.49
Fund 505 - PARKING SYSTEM FUND Net Gain (Loss)($138,705.80)$89,788.61 $235,774.81 $374,480.61 (170%)($643,782.39)
Page 29 of 36Run by Jessica Tapia on 04/28/2022 13:26:57 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 11,550.00 19,476.83 30,523.17 39 3,350.00
Charges for Services 23,443,200.00 2,005,743.00 5,147,699.05 18,295,500.95 22 4,474,299.97
Other Revenue 29,834,150.00 334,682.97 334,775.58 29,499,374.42 1 343,697.67
Interest Income 70,000.00 3,458.70 24,303.58 45,696.42 35 14,541.89
Department 40 - PUBLIC WORKS AGENCY Totals $53,397,350.00 $2,355,434.67 $5,526,255.04 $47,871,094.96 10%$4,835,889.53
REVENUE TOTALS $53,397,350.00 $2,355,434.67 $5,526,255.04 $47,871,094.96 10%$4,835,889.53
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits 6,004,605.36 427,128.34 1,336,175.62 4,668,429.74 22 1,320,738.09
Services and Supplies 5,347,760.00 324,065.05 524,440.18 4,823,319.82 10 369,669.96
Capital Outlay 164,400.00 .00 .00 164,400.00 0 .00
Contingencies 1,000.00 .00 .00 1,000.00 0 .00
Miscellaneous 15,000.00 61,939.14 130,542.93 (115,542.93)870 7,952.19
Interfund Transfers 180,000.00 15,000.00 1,155,922.51 (975,922.51)642 45,000.00
Department 40 - PUBLIC WORKS AGENCY Totals $11,712,765.36 $828,132.53 $3,147,081.24 $8,565,684.12 27%$1,743,360.24
Department 71 - UTILITIES
Salary and Benefits .00 9,048.69 13,584.38 (13,584.38)+++.00
Insurance and Other Chargebacks 1,585,843.00 132,153.58 396,460.74 1,189,382.26 25 384,912.00
Debt Service 3,596,365.00 .00 .00 3,596,365.00 0 .00
Interfund Transfers 4,049,559.00 337,463.25 1,012,389.75 3,037,169.25 25 1,012,392.00
Department 71 - UTILITIES Totals $9,231,767.00 $478,665.52 $1,422,434.87 $7,809,332.13 15%$1,397,304.00
EXPENSE TOTALS $20,944,532.36 $1,306,798.05 $4,569,516.11 $16,375,016.25 22%$3,140,664.24
Fund 510 - WATER FUND Totals
REVENUE TOTALS 53,397,350.00 2,355,434.67 5,526,255.04 47,871,094.96 10%4,835,889.53
EXPENSE TOTALS 20,944,532.36 1,306,798.05 4,569,516.11 16,375,016.25 22%3,140,664.24
Fund 510 - WATER FUND Net Gain (Loss)$32,452,817.64 $1,048,636.62 $956,738.93 ($31,496,078.71)3%$1,695,225.29
Page 30 of 36Run by Jessica Tapia on 04/28/2022 13:26:57 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 54,678.92 88,778.92 3,376,221.08 3 28,400.00
Capital Outlay 33,036,000.00 .00 .00 33,036,000.00 0 1,791,189.02
Interfund Transfers .00 .00 (1,110,922.51)1,110,922.51 +++.00
Department 71 - UTILITIES Totals $36,501,000.00 $54,678.92 ($1,022,143.59)$37,523,143.59 (3%)$1,819,589.02
EXPENSE TOTALS $36,501,000.00 $54,678.92 ($1,022,143.59)$37,523,143.59 (3%)$1,819,589.02
Fund 513 - WATER DEPR IMPRV &EXTENSION FUND Totals
REVENUE TOTALS .00 .00 .00 .00 +++.00
EXPENSE TOTALS 36,501,000.00 54,678.92 (1,022,143.59)37,523,143.59 (3%)1,819,589.02
Fund 513 - WATER DEPR IMPRV &EXTENSION FUND Net Gain (Loss)($36,501,000.00)($54,678.92)$1,022,143.59 $37,523,143.59 (3%)($1,819,589.02)
Page 31 of 36Run by Jessica Tapia on 04/28/2022 13:27:02 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 898,800.45 2,053,730.03 8,059,863.97 20 2,158,050.17
Other Revenue 2,001,000.00 .00 .00 2,001,000.00 0 (204.68)
Interest Income 25,000.00 216.02 611.40 24,388.60 2 1,036.34
Department 40 - PUBLIC WORKS AGENCY Totals $12,139,594.00 $899,016.47 $2,054,341.43 $10,085,252.57 17%$2,158,881.83
REVENUE TOTALS $12,139,594.00 $899,016.47 $2,054,341.43 $10,085,252.57 17%$2,158,881.83
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits 1,383,914.00 99,567.66 309,751.48 1,074,162.52 22 286,938.90
Services and Supplies 1,471,800.00 12,513.04 23,236.21 1,448,563.79 2 83,644.33
Capital Outlay 3,538,100.00 .00 .00 3,538,100.00 0 .00
Insurance and Other Chargebacks 352,190.00 29,349.17 88,047.51 264,142.49 25 83,064.00
Miscellaneous 1,500.00 16,121.30 34,225.78 (32,725.78)2,282 .00
Interfund Transfers 871,164.00 72,597.01 217,791.03 653,372.97 25 213,846.00
Department 40 - PUBLIC WORKS AGENCY Totals $7,618,668.00 $230,148.18 $673,052.01 $6,945,615.99 9%$667,493.23
Department 71 - UTILITIES
Debt Service 3,772,691.00 311,978.99 624,752.52 3,147,938.48 17 1,222,355.27
Department 71 - UTILITIES Totals $3,772,691.00 $311,978.99 $624,752.52 $3,147,938.48 17%$1,222,355.27
EXPENSE TOTALS $11,391,359.00 $542,127.17 $1,297,804.53 $10,093,554.47 11%$1,889,848.50
Fund 515 - SEWER FUND Totals
REVENUE TOTALS 12,139,594.00 899,016.47 2,054,341.43 10,085,252.57 17%2,158,881.83
EXPENSE TOTALS 11,391,359.00 542,127.17 1,297,804.53 10,093,554.47 11%1,889,848.50
Fund 515 - SEWER FUND Net Gain (Loss)$748,235.00 $356,889.30 $756,536.90 $8,301.90 101%$269,033.33
Page 32 of 36Run by Jessica Tapia on 04/28/2022 13:27:02 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
Fund Category Proprietary Funds
Fund Type Enterprise Funds
Fund 520 - SOLID WASTE FUND
REVENUE
Department 26 - PUBLIC WORKS
Charges for Services .00 172.00 172.00 (172.00)+++255.75
Department 26 - PUBLIC WORKS Totals $0.00 $172.00 $172.00 ($172.00)+++$255.75
Department 40 - PUBLIC WORKS AGENCY
Property Taxes 1,332,500.00 666,250.00 666,250.00 666,250.00 50 650,000.00
Licenses, Permits and Fees 297,000.00 81,176.80 99,017.80 197,982.20 33 67,576.11
Charges for Services 4,516,450.00 385,712.00 1,077,131.18 3,439,318.82 24 1,001,640.43
Other Revenue 122,000.00 1,410.45 93,401.19 28,598.81 77 50,876.26
Department 40 - PUBLIC WORKS AGENCY Totals $6,267,950.00 $1,134,549.25 $1,935,800.17 $4,332,149.83 31%$1,770,092.80
REVENUE TOTALS $6,267,950.00 $1,134,721.25 $1,935,972.17 $4,331,977.83 31%$1,770,348.55
EXPENSE
Department 40 - PUBLIC WORKS AGENCY
Salary and Benefits 1,492,909.00 105,499.34 329,115.97 1,163,793.03 22 343,372.95
Services and Supplies 3,786,776.00 292,747.14 670,187.93 3,116,588.07 18 663,247.85
Capital Outlay 525,000.00 .00 4,208.86 520,791.14 1 7,272.25
Miscellaneous 15,000.00 5,873.00 5,873.00 9,127.00 39 5,224.00
Interfund Transfers 302,000.00 25,166.67 75,500.01 226,499.99 25 75,501.00
Department 40 - PUBLIC WORKS AGENCY Totals $6,121,685.00 $429,286.15 $1,084,885.77 $5,036,799.23 18%$1,094,618.05
EXPENSE TOTALS $6,121,685.00 $429,286.15 $1,084,885.77 $5,036,799.23 18%$1,094,618.05
Fund 520 - SOLID WASTE FUND Totals
REVENUE TOTALS 6,267,950.00 1,134,721.25 1,935,972.17 4,331,977.83 31%1,770,348.55
EXPENSE TOTALS 6,121,685.00 429,286.15 1,084,885.77 5,036,799.23 18%1,094,618.05
Fund 520 - SOLID WASTE FUND Net Gain (Loss)$146,265.00 $705,435.10 $851,086.40 $704,821.40 582%$675,730.50
Fund Type Enterprise Funds Totals
REVENUE TOTALS 83,485,569.00 5,334,885.09 11,906,789.04 71,578,779.96 14%10,381,712.01
EXPENSE TOTALS 86,777,957.16 3,188,814.38 8,084,508.41 78,693,448.75 9%10,205,094.30
Fund Type Enterprise Funds Net Gain (Loss)($3,292,388.16)$2,146,070.71 $3,822,280.63 $7,114,668.79 (116%)$176,617.71
Page 33 of 36Run by Jessica Tapia on 04/28/2022 13:27:02 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 776,859.99 2,350,580.01 25 776,859.00
Other Revenue 69,000.00 .00 4,968.88 64,031.12 7 .00
Interest Income 1,000.00 .00 .00 1,000.00 0 .00
Department 19 - ADMINISTRATIVE SERVICES Totals $3,197,440.00 $258,953.33 $781,828.87 $2,415,611.13 24%$776,859.00
REVENUE TOTALS $3,197,440.00 $258,953.33 $781,828.87 $2,415,611.13 24%$776,859.00
EXPENSE
Department 19 - ADMINISTRATIVE SERVICES
Salary and Benefits 1,276,620.55 83,771.00 265,822.19 1,010,798.36 21 257,537.31
Services and Supplies 2,034,507.00 296,378.88 509,541.32 1,524,965.68 25 342,173.07
Capital Outlay .00 .00 .00 .00 +++19,924.22
Insurance and Other Chargebacks .00 .00 899.88 (899.88)+++.00
Department 19 - ADMINISTRATIVE SERVICES Totals $3,311,127.55 $380,149.88 $776,263.39 $2,534,864.16 23%$619,634.60
EXPENSE TOTALS $3,311,127.55 $380,149.88 $776,263.39 $2,534,864.16 23%$619,634.60
Fund 600 - FLEET SERVICES FUND Totals
REVENUE TOTALS 3,197,440.00 258,953.33 781,828.87 2,415,611.13 24%776,859.00
EXPENSE TOTALS 3,311,127.55 380,149.88 776,263.39 2,534,864.16 23%619,634.60
Fund 600 - FLEET SERVICES FUND Net Gain (Loss)($113,687.55)($121,196.55)$5,565.48 $119,253.03 (5%)$157,224.40
Page 34 of 36Run by Jessica Tapia on 04/28/2022 13:27:02 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
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 56,221.20 168,663.80 25 56,217.00
Intergovernmental Revenue 1,600,000.00 133,333.33 399,999.99 1,200,000.01 25 .00
Other Revenue 960,217.00 .00 .00 960,217.00 0 .00
Interest Income .00 .00 .00 .00 +++159.62
Department 19 - ADMINISTRATIVE SERVICES Totals $2,785,102.00 $152,073.73 $456,221.19 $2,328,880.81 16%$56,376.62
REVENUE TOTALS $2,785,102.00 $152,073.73 $456,221.19 $2,328,880.81 16%$56,376.62
EXPENSE
Department 19 - ADMINISTRATIVE SERVICES
Services and Supplies .00 .00 .00 .00 +++69.90
Capital Outlay 2,750,000.00 1,029,704.00 1,187,197.00 1,562,803.00 43 572,500.00
Department 19 - ADMINISTRATIVE SERVICES Totals $2,750,000.00 $1,029,704.00 $1,187,197.00 $1,562,803.00 43%$572,569.90
EXPENSE TOTALS $2,750,000.00 $1,029,704.00 $1,187,197.00 $1,562,803.00 43%$572,569.90
Fund 601 - EQUIPMENT REPLACEMENT FUND Totals
REVENUE TOTALS 2,785,102.00 152,073.73 456,221.19 2,328,880.81 16%56,376.62
EXPENSE TOTALS 2,750,000.00 1,029,704.00 1,187,197.00 1,562,803.00 43%572,569.90
Fund 601 - EQUIPMENT REPLACEMENT FUND Net Gain (Loss)$35,102.00 ($877,630.27)($730,975.81)($766,077.81)(2,082%)($516,193.28)
Page 35 of 36Run by Jessica Tapia on 04/28/2022 13:27:02 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification
Fund Category Proprietary Funds
Fund Type Internal Service Funds
Fund 605 - INSURANCE FUND
REVENUE
Department 99 - NON-DEPARTMENTAL
Charges for Services .00 .00 2,386.57 (2,386.57)+++785.67
Other Revenue 11,248,243.00 837,731.04 2,543,029.02 8,705,213.98 23 2,530,177.87
Workers Compensation and Liability 825,000.00 62,500.00 188,000.00 637,000.00 23 372,209.34
Insurance 8,827,914.00 725,355.73 2,075,664.05 6,752,249.95 24 2,197,452.48
Department 99 - NON-DEPARTMENTAL Totals $20,901,157.00 $1,625,586.77 $4,809,079.64 $16,092,077.36 23%$5,100,625.36
REVENUE TOTALS $20,901,157.00 $1,625,586.77 $4,809,079.64 $16,092,077.36 23%$5,100,625.36
EXPENSE
Department 99 - NON-DEPARTMENTAL
Salary and Benefits 4,751.36 6,725.32 36,440.96 (31,689.60)767 156,915.65
Services and Supplies 2,994,200.00 242,359.97 1,474,208.30 1,519,991.70 49 932,599.15
Insurance and Other Chargebacks 16,957,400.00 1,637,495.16 4,236,935.50 12,720,464.50 25 3,960,202.10
Department 99 - NON-DEPARTMENTAL Totals $19,956,351.36 $1,886,580.45 $5,747,584.76 $14,208,766.60 29%$5,049,716.90
EXPENSE TOTALS $19,956,351.36 $1,886,580.45 $5,747,584.76 $14,208,766.60 29%$5,049,716.90
Fund 605 - INSURANCE FUND Totals
REVENUE TOTALS 20,901,157.00 1,625,586.77 4,809,079.64 16,092,077.36 23%5,100,625.36
EXPENSE TOTALS 19,956,351.36 1,886,580.45 5,747,584.76 14,208,766.60 29%5,049,716.90
Fund 605 - INSURANCE FUND Net Gain (Loss)$944,805.64 ($260,993.68)($938,505.12)($1,883,310.76)(99%)$50,908.46
Fund Type Internal Service Funds Totals
REVENUE TOTALS 26,883,699.00 2,036,613.83 6,047,129.70 20,836,569.30 22%5,933,860.98
EXPENSE TOTALS 26,017,478.91 3,296,434.33 7,711,045.15 18,306,433.76 30%6,241,921.40
Fund Type Internal Service Funds Net Gain (Loss)$866,220.09 ($1,259,820.50)($1,663,915.45)($2,530,135.54)(192%)($308,060.42)
Fund Category Proprietary Funds Totals
REVENUE TOTALS 110,369,268.00 7,371,498.92 17,953,918.74 92,415,349.26 16%16,315,572.99
EXPENSE TOTALS 112,795,436.07 6,485,248.71 15,795,553.56 96,999,882.51 14%16,447,015.70
Fund Category Proprietary Funds Net Gain (Loss)($2,426,168.07)$886,250.21 $2,158,365.18 $4,584,533.25 (89%)($131,442.71)
Grand Totals
REVENUE TOTALS 190,412,147.00 21,237,111.32 37,584,778.16 152,827,368.84 20%35,243,884.47
EXPENSE TOTALS 214,313,062.86 9,110,367.89 22,141,114.51 192,171,948.35 10%21,341,380.25
Grand Total Net Gain (Loss)($23,900,915.86)$12,126,743.43 $15,443,663.65 $39,344,579.51 (65%)$13,902,504.22
Page 36 of 36Run by Jessica Tapia on 04/28/2022 13:27:02 PM
Income Statement
Through 03/31/22
Summary Listing
YTD MTD YTD Budget Less % of Prior Year
Budget Amount Actual Amount Actual Amount YTD Actual Budget YTD TotalClassification