Loading...
HomeMy WebLinkAbout2022.04 April Monthly Report To: Kelley A. Gandurski, Interim City Manager From: Hitesh Desai, CFO/City Treasurer Subject: April 2022 Monthly Financial Report Date: May 27, 2022 Please find attached the unaudited financial statements as of April 30, 2022. A summary by fund for revenues, expenditures, fund and cash balances is as follows: City of Evanston Cash & Investment Summary by Fund April 30, 2022 Fund #Fund Revenue Expense Net Fund Balance Cash Balance 100 53,949,203General 41,147,156 12,802,047 43,088,832 37,828,355 170 3,262American Rescue Plan 2,724,167 (2,720,905) 14,092,467 14,092,467 175 747,526General Assistance 338,375 409,151 1,019,597 1,019,469 176 1,647,367Human Services 574,434 1,072,934 3,105,057 3,104,868 177 3,154Reparations 53,767 (50,613) 455,101 455,101 180 Good Neighbor 440 10,999 (10,560) 891,603 891,603 185 4,146,307Library 2,476,079 1,670,229 5,114,583 5,050,617 186 253,313Library Debt Service - 253,313 254,457 254,457 187 -Library Capital Improvement FD 94,112 (94,112) 784,014 784,014 200 MFT 1,775,217 710,714 1,064,503 6,115,604 5,868,339 205 486,642E911 377,494 109,148 1,634,771 1,278,047 210 317,643Special Service Area (SSA) #9 - 317,643 110,892 110,892 215 110,244CDBG 242,063 (131,819) (70,996) (70,996) 220 18,834CD Loan - 18,834 329,765 329,765 235 Neighborhood Improvement 11 4 7 22,150 22,150 240 230,322Home 259,740 (29,418) (3,682) (3,682) 250 165,638Affordable Housing 219,562 (53,924) 2,578,100 2,725,955 320 8,596,914Debt Service 19,142 8,577,772 9,868,339 9,868,339 330 698,078Howard Ridge 133,857 564,221 3,237,786 3,391,802 335 964,847West Evanston 26,721 938,126 4,190,328 4,190,328 340 155,825Dempster-Dodge-TIF 57,304 98,521 423,525 423,525 345 633,062Chicago Main-TIF 113,626 519,436 1,470,964 1,470,964 350 122,471Special Service Area (SSA) #6 - 122,471 124,250 124,250 355 81,801Special Service Area (SSA) #7 - 81,801 90,515 90,515 360 31,548Special Service Area (SSA) #8 - 31,548 34,766 34,766 415 Capital Improvements 665,603 10,962,989 11,161,201 416 5,394Crown Construction 320,025 (314,631) 5,415,187 5,415,187 417 58,333Crown Community CTR Maintenance 23,076 35,257 385,253 385,253 420 62,211Special Assessment 166,439 (104,228) 2,029,367 2,025,086 505 3,472,114Parking 3,005,154 466,960 (1,384,903) 932,083 7,261,964510-513 Water 6,547,743 714,221 16,060,349 11,962,930 515 2,637,484Sewer 1,959,522 677,961 10,900,915 5,103,167 520 2,334,661Solid Waste 1,753,402 581,258 1,039,268 137,885 600 1,040,782Fleet 1,074,607 (33,825) 684,829 (677,406) 601 1,424,769Equipment Replacement 1,297,669 127,100 356,040 163,794 605 6,743,030Insurance 7,105,359 (362,330) (5,582,796) (1,606,198) 92,107 (573,496) 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 April 30, 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 April 30, 2022 with a fund balance of $43,088,832 and cash balance of $37,828,355. The attached financials show General Fund revenues at 46% of budget and expenses at 35% of budget. The General Fund revenues are higher mainly because of property tax revenues collected. Additionally, taxes collected such as Sales and Income, are higher due to inflation. Expenses 2021 Actual YTD 2021 Budget % 2022 Actual YTD 2022 Budget % LEGISLATIVE - - - - CITY COUNCIL 142,589.90 556,165.60 26% 197,207.17 579,384.00 34% CITY CLERK 57,267.14 178,794.66 32% 66,874.79 343,573.00 19% CITY MANAGER'S OFFICE 1,801,485.67 6,004,834.63 30% 1,618,783.24 6,232,882.39 26% LAW 158,931.39 576,892.00 28% 277,288.05 970,341.14 29% ADMINISTRATIVE SERVICES 2,941,444.56 10,360,246.39 28% 3,463,272.25 11,449,182.64 30% COMMUNITY DEVELOPMENT 1,005,974.01 3,073,829.11 33% 959,513.56 4,488,316.71 21% POLICE 15,356,396.70 39,734,285.59 39% 9,308,439.00 29,280,597.55 32% FIRE MGMT & SUPPORT 10,480,524.72 26,006,574.05 40% 5,753,085.15 16,823,271.83 34% HEALTH 613,978.97 1,556,419.50 39% 645,485.52 1,453,836.00 44% PARKS AND RECREATION 2,763,906.30 11,329,360.87 24% 2,704,030.46 12,101,740.47 22% PUBLIC WORKS AGENCY 4,058,576.52 11,642,790.99 35% 4,305,783.02 13,444,799.45 32% NON-DEPARTMENTAL - - 11,847,394.01 20,723,062.00 57% Expenses Total 39,381,870.88 111,020,193.39 35% 41,147,156.22 117,890,987.18 35% Staff continues to monitor Police and Fire overtime expenses. Through April, Police had spent 37% of budget for overtime, and Fire had spent 35% of the annual budget. Overtime Expenses 2021 Actual 2022 Budget 2022 YTD % Budget Enterprise Funds Parking fund revenues through April 30, 2022, are at 30% of budget and expenses are at 25%. As the economy continues to improve in post-pandemic time, we expect Parking revenues to increase. Through April 30, 2022, overall Water Fund appears low on revenue and expenses. Water Fund operating revenues and expenses are in line with the budget, but 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 April 30, 2022, the Sewer Fund also appears low on expenses mainly due to the capital projects and debt service payments occurring later in the year. Through April 30, 2022, the Solid Waste Fund has a fund balance of $1,039,268 and a cash balance of $137,885. GF Expenses (category) 2021 YTD Actual 2021 Budget % 2022 YTD Actual 2022 Budget % Salary and Benefits 24,154,490.22 68,210,033.83 35% 23,776,567.20 74,503,722.18 32% Insurance and Other Chargebacks 11,769,142.83 25,368,239.00 46% 13,103,452.56 24,383,062.00 54% Services and Supplies 2,332,671.80 13,313,795.56 18% 3,118,925.12 15,131,213.00 21% Interfund Transfers 1,014,992.00 3,045,000.00 33% 864,999.92 2,595,000.00 33% Miscellaneous 82,711.50 579,625.00 14% 212,837.41 590,390.00 36% Capital Outlay 21,470.19 320,000.00 7% 70,374.01 434,500.00 16% Community Sponsored Organizations 5,756.82 0.00 0.00 69,600.00 0% Contingencies 635.52 183,500.00 0% 0.00 183,500.00 0% Expenses Total 39,381,870.88 111,020,193.39 35% 41,147,156.22 117,890,987.18 35% Other Funds Through April 30, 2022, the SSA #9 Fund is showing fund and cash balance of $110,892. Through April 30, 2022, the Capital Improvements Fund is showing a fund balance of $10,962,989 and a cash balance of $11,161,201. The fund continues to spend down Series 2021 and Series 2020 bond proceeds. Through April 30, 2022, the Crown Construction fund is showing fund and cash balance of $5,415,187. The fund continues to spend down balances from bond proceeds and gifts from the Friends of Robert Crown. Through April 30, 2022, the Insurance Fund is showing a negative fund balance of $5,582,796 and a negative cash balance of $1,606,198. 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 April 30, 2022 year-to-date financial information and reports which to the best of my knowledge appear accurate and complete. Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget 100 GENERAL FUND Revenue Other Taxes 16,640,370 48,775,000 34%23,474,952 51,925,000 45% Property Taxes 14,106,290 28,298,539 50%15,792,721 28,774,164 55% Licenses, Permits and Fees 3,511,374 8,085,550 43%2,424,261 8,085,550 30% Interfund Transfers 3,337,188 9,149,103 36%2,925,235 8,775,706 33% Charges for Services 2,616,244 9,357,875 28%3,891,010 8,491,325 46% Intergovernmental Revenue 1,357,036 1,584,942 86%3,003,296 5,961,342 50% Fines and Forfeitures 764,064 4,123,500 19%1,145,116 3,723,500 31% Other Revenue 199,837 1,593,100 13%1,256,701 2,118,100 59% Interest Income 11,107 55,000 20%35,911 55,000 65% Revenue Total 42,543,509 111,022,609 38%53,949,203 117,909,687 46% Expenses LEGISLATIVE - - - - CITY COUNCIL 142,590 556,166 26%197,207 579,384 34% CITY CLERK 57,267 178,795 32%66,875 343,573 19% CITY MANAGER'S OFFICE 1,801,486 6,004,835 30%1,618,783 6,232,882 26% LAW 158,931 576,892 28%277,288 970,341 29% ADMINISTRATIVE SERVICES 2,941,445 10,360,246 28%3,463,272 11,449,183 30% COMMUNITY DEVELOPMENT 1,005,974 3,073,829 33%959,514 4,488,317 21% POLICE 15,356,397 39,734,286 39%9,308,439 29,280,598 32% FIRE MGMT & SUPPORT 10,480,525 26,006,574 40%5,753,085 16,823,272 34% HEALTH 613,979 1,556,420 39%645,486 1,453,836 44% PARKS AND RECREATION 2,763,906 11,329,361 24%2,704,030 12,101,740 22% PUBLIC WORKS AGENCY 4,058,577 11,642,791 35%4,305,783 13,444,799 32% NON-DEPARTMENTAL - - 11,847,394 20,723,062 57% Expenses Total 39,381,871 111,020,193 35%41,147,156 117,890,987 35% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget 170 AMERICAN RESCUE PLAN Revenue Intergovernmental Revenue - 21,586,827 0% Interest Income 3,262 - Revenue Total 3,262 21,586,827 0% Expenses Services and Supplies - - Miscellaneous - 22,250,000 0% Capital Outlay 7,500 - Interfund Transfers 2,716,667 8,150,000 33% Expenses Total 2,724,167 30,400,000 9% 175 GENERAL ASSISTANCE FUND Revenue Property Taxes 530,501 1,300,000 41%721,065 1,300,000 55% Other Revenue 2,585 27,500 9%25,713 27,500 94% Interest Income 479 1,000 48%749 1,000 75% Revenue Total 533,566 1,328,500 40%747,526 1,328,500 56% Expenses Services and Supplies 209,252 865,982 24%178,581 864,482 21% Salary and Benefits 165,140 452,062 37%159,794 469,871 34% Miscellaneous - 7,000 0%- 7,000 0% Expenses Total 374,391 1,325,044 28%338,375 1,341,353 25% 176 HUMAN SERVICES FUND Revenue Property Taxes 1,530,000 3,110,000 49%1,550,000 3,110,000 50% Interfund Transfers 150,000 450,000 33% Intergovernmental Revenue 43,332 125,000 35%96,283 194,000 50% Other Revenue 1,740 2,000 87%- 2,000 0% Interest Income 449 - 1,085 - Revenue Total 1,725,521 3,687,000 47%1,647,367 3,306,000 50% Expenses Salary and Benefits 474,054 1,697,148 28%482,716 1,705,820 28% Miscellaneous 82,047 465,000 18%44,508 258,000 17% Community Sponsored Organizations 11,756 143,333 8%26,700 143,333 19% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Insurance and Other Chargebacks 7,701 - Services and Supplies 5,987 1,340,243 0%20,510 1,761,183 1% Expenses Total 581,545 3,645,724 16%574,434 3,868,336 15% 177 REPARATIONS FUND Revenue Other Revenue 23,724 - 2,925 - Interest Income 48 - 229 - Other Taxes - 400,000 0%- 400,000 0% Revenue Total 23,773 400,000 6%3,154 400,000 1% Expenses Services and Supplies 15 - 767 - Miscellaneous - 400,000 0%53,000 400,000 13% Expenses Total 15 400,000 0%53,767 400,000 13% 180 GOOD NEIGHBOR FUND Revenue Other Revenue 1,000,000 1,000,000 100% Interest Income 353 - 440 - Revenue Total 1,000,353 1,000,000 100%440 - Expenses Interfund Transfers 414,152 380,000 109%- - Services and Supplies 225 - 149 - Capital Outlay 850 - Miscellaneous - 620,000 0%10,000 1,000,000 1% Expenses Total 414,376 1,000,000 41%10,999 1,000,000 1% 185 LIBRARY FUND Revenue Property Taxes 3,501,221 7,252,000 48%3,989,032 7,252,000 55% Interfund Transfers 250,062 209,000 120%- 217,911 0% Other Revenue 84,372 400,000 21%119,772 410,000 29% Library Revenue 74,503 227,224 33%24,767 174,800 14% Intergovernmental Revenue 9,435 238,000 4%9,212 472,866 2% Fines and Forfeitures 4,478 - Interest Income 3,592 15,000 24%3,387 15,000 23% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Charges for Services 66 - 138 - Licenses, Permits and Fees - 115,767 0% Revenue Total 3,927,728 8,341,224 47%4,146,307 8,658,344 48% Expenses Salary and Benefits 2,003,178 5,910,018 34%1,720,911 6,132,692 28% Services and Supplies 501,841 2,052,000 24%554,592 2,136,767 26% Interfund Transfers 120,404 361,226 33%126,551 379,653 33% Capital Outlay - 8,500 0%- 8,500 0% Miscellaneous 74,024 - Expenses Total 2,625,423 8,331,744 32%2,476,079 8,657,612 29% 186 LIBRARY DEBT SERVICE FUND Revenue Property Taxes 200,000 482,243 41%253,313 506,625 50% Revenue Total 200,000 482,243 41%253,313 506,625 50% Expenses Debt Service - 482,243 0%- 506,625 0% Expenses Total - 482,243 0%- 506,625 0% 187 LIBRARY CAPITAL IMPROVEMENT FD Revenue Other Revenue - 449,000 0%- 480,000 0% Revenue Total - 449,000 0%- 480,000 0% Expenses Capital Outlay 104,377 449,000 23%94,112 680,000 14% Expenses Total 104,377 449,000 23%94,112 680,000 14% 200 MOTOR FUEL TAX FUND Revenue Intergovernmental Revenue 1,695,385 3,656,700 46%1,771,395 3,656,700 48% Interest Income 2,123 12,000 18%3,822 12,000 32% Revenue Total 1,697,509 3,668,700 46%1,775,217 3,668,700 48% Expenses Interfund Transfers 348,328 1,044,987 33%348,329 1,044,987 33% Services and Supplies 336,945 1,038,000 32%328,825 1,038,000 32% Capital Outlay - 2,284,000 0%33,560 3,261,000 1% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Expenses Total 685,273 4,366,987 16%710,714 5,343,987 13% 205 EMERGENCY TELEPHONE (E911) FUND Revenue Other Taxes 475,237 1,321,600 36%486,177 1,400,000 35% Interest Income 328 7,000 5%466 7,000 7% Other Revenue 266 - Revenue Total 475,831 1,328,600 36%486,642 1,407,000 35% Expenses Salary and Benefits 182,982 742,978 25%253,458 768,616 33% Services and Supplies 45,147 374,000 12%52,771 393,700 13% Interfund Transfers 30,000 90,000 33%30,000 90,000 33% Insurance and Other Chargebacks 6,076 18,230 33%6,077 18,230 33% Capital Outlay 1,950 299,163 1%35,188 450,000 8% Expenses Total 266,155 1,524,371 17%377,494 1,720,546 22% 210 SPECIAL SERVICE AREA (SSA) #9 Revenue Property Taxes 187,249 592,665 32%317,607 595,000 53% Interest Income 3 - 35 - Revenue Total 187,252 592,665 32%317,643 595,000 53% Expenses Services and Supplies 150,791 575,000 26%- 575,000 0% Expenses Total 150,791 575,000 26%- 575,000 0% 215 CDBG FUND Revenue Intergovernmental Revenue 73,517 2,758,514 3%110,178 3,684,820 3% Interest Income 66 - Revenue Total 73,517 2,758,514 3%110,244 3,684,820 3% Expenses Salary and Benefits 120,335 319,997 38%127,380 589,422 22% Capital Outlay 43,200 - Community Sponsored Organizations 37,517 80,000 47%110,136 75,000 147% Services and Supplies 3,669 506,200 1%4,324 506,200 1% Miscellaneous 614 1,700,000 0%224 2,515,000 0% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Insurance and Other Chargebacks - 150,000 0% Expenses Total 205,335 2,756,197 7%242,063 3,685,622 7% 220 CDBG LOAN FUND Revenue Other Revenue 52,131 110,000 47%18,543 100,000 19% Interest Income 340 - 292 - Revenue Total 52,471 110,000 48%18,834 100,000 19% Expenses Miscellaneous 9 - Services and Supplies - 175,000 0%- 175,000 0% Expenses Total 9 175,000 0%- 175,000 0% 235 NEIGHBORHOOD IMPROVEMENT Revenue Interest Income 11 - 11 - Revenue Total 11 - 11 - Expenses Services and Supplies 6 - 4 - Expenses Total 6 - 4 - 240 HOME FUND Revenue Intergovernmental Revenue 150,692 540,453 28%214,228 540,453 40% Other Revenue 15,323 25,000 61%16,063 25,000 64% Interest Income 22 150 15%30 150 20% Revenue Total 166,037 565,603 29%230,322 565,603 41% Expenses Services and Supplies 151,303 500,565 30%238,030 500,565 48% Salary and Benefits 23,021 63,876 36%21,709 70,681 31% Miscellaneous - 500 0%- 500 0% Expenses Total 174,324 564,941 31%259,740 571,746 45% 250 AFFORDABLE HOUSING FUND Revenue Intergovernmental Revenue 108,974 658,000 17%130,793 658,000 20% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Other Revenue 32,917 175,600 19%33,333 140,600 24% Interest Income 3,564 5,700 63%1,511 5,700 27% Other Taxes - 75,000 0%- 75,000 0% Revenue Total 145,454 914,300 16%165,638 879,300 19% Expenses Community Sponsored Organizations 108,974 166,000 66%122,432 166,000 74% Salary and Benefits 60,222 202,684 30%61,253 180,075 34% Services and Supplies 20,154 2,031,050 1%32,945 2,065,050 2% Miscellaneous 2,067 102,510 2%2,932 67,500 4% Capital Outlay - 10,000 0%- 10,000 0% Insurance and Other Chargebacks - 17,000 0%- 17,000 0% Expenses Total 191,417 2,529,244 8%219,562 2,505,625 9% 320 DEBT SERVICE FUND Revenue Property Taxes 6,209,374 13,936,263 45%7,837,866 13,436,256 58% Interfund Transfers 399,140 1,197,401 33%755,680 2,267,041 33% Interest Income 2,023 1,500 135%3,367 1,500 224% Other Revenue 20 - - - Revenue Total 6,610,557 15,135,164 44%8,596,914 15,704,797 55% Expenses Services and Supplies 6 - Debt Service - 15,133,666 0%- 15,690,075 0% Miscellaneous 19,142 - Expenses Total 6 15,133,666 0%19,142 15,690,075 0% 330 HOWARD-RIDGE TIF FUND Revenue Property Taxes 632,854 968,000 65%675,975 1,100,000 61% Interest Income 2,289 400 572%1,498 400 374% Other Revenue - 5,366 0%20,605 5,366 384% Revenue Total 635,142 973,766 65%698,078 1,105,766 63% Expenses Services and Supplies 149,995 335,000 45%1,153 265,000 0% Interfund Transfers 72,704 218,113 33%132,704 398,113 33% Capital Outlay - 500,000 0%- 785,000 0% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Expenses Total 222,699 1,053,113 21%133,857 1,448,113 9% 335 WEST EVANSTON TIF FUND Revenue Property Taxes 811,105 1,237,000 66%963,034 1,450,000 66% Other Revenue 171,504 11,000 1559%- 11,000 0% Interest Income 1,315 4,000 33%1,809 4,000 45% Revenue Total 983,924 1,252,000 79%964,844 1,465,000 66% Expenses Interfund Transfers 25,000 75,000 33%25,000 75,000 33% Services and Supplies 344 5,000 7%1,705 5,000 34% Capital Outlay - 500,000 0%17 1,765,000 0% Miscellaneous - 200,000 0%- 200,000 0% Expenses Total 25,344 780,000 3%26,721 2,045,000 1% 340 DEMPSTER-DODGE TIF FUND Revenue Property Taxes 93,669 147,000 64%155,622 160,000 97% Interest Income 146 - 203 - Revenue Total 93,814 147,000 64%155,825 160,000 97% Expenses Interfund Transfers 56,308 168,923 33%57,278 171,833 33% Services and Supplies 333 2,000 17%26 2,000 1% Expenses Total 56,641 170,923 33%57,304 173,833 33% 345 CHICAGO-MAIN TIF Revenue Property Taxes 411,723 879,000 47%632,420 1,000,000 63% Interest Income 902 - 642 - Other Revenue - 1,130,000 0% Revenue Total 412,625 2,009,000 21%633,062 1,000,000 63% Expenses Capital Outlay 116,567 1,130,000 10%25,341 1,090,000 2% Interfund Transfers 87,616 262,843 33%88,254 264,763 33% Services and Supplies 340 5,000 7%30 5,000 1% Miscellaneous - 250,000 0% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Expenses Total 204,523 1,397,843 15%113,626 1,609,763 7% 350 SPECIAL SERVICE AREA (SSA) #6 Revenue Property Taxes 2,831 221,000 1%122,429 221,000 55% Interest Income 3 500 1%42 - Revenue Total 2,834 221,500 1%122,471 221,000 55% Expenses Services and Supplies 0 221,500 0%- 221,000 0% Expenses Total 0 221,500 0%- 221,000 0% 355 SPECIAL SERVICE AREA (SSA) #7 Revenue Property Taxes 65,192 154,800 42%81,741 142,000 58% Interest Income 42 - 60 - Revenue Total 65,235 154,800 42%81,801 142,000 58% Expenses Services and Supplies 0 115,000 0%- 140,000 0% Expenses Total 0 115,000 0%- 140,000 0% 360 SPECIAL SERVICE AREA (SSA) #8 Revenue Property Taxes 29,351 60,200 49%31,548 60,200 52% Interest Income 1 - - - Revenue Total 29,352 60,200 49%31,548 60,200 52% Expenses Services and Supplies 64,512 60,200 107%- 60,200 0% Expenses Total 64,512 60,200 107%- 60,200 0% 415 CAPITAL IMPROVEMENTS FUND Revenue Interest Income 5,963 - 9,417 - Charges for Services 9,837 - Other Revenue (353) 7,645,000 0%72,853 12,253,000 1% Revenue Total 5,610 7,645,000 0%92,107 12,253,000 1% Expenses Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Capital Outlay 540,929 9,705,000 6%285,816 16,455,000 2% Services and Supplies 262,219 - 323,865 - Salary and Benefits 235,223 696,766 34%- - Miscellaneous 55,923 - Expenses Total 1,038,372 10,401,766 10%665,603 16,455,000 4% 416 CROWN CONSTRUCTION FUND Revenue Other Revenue 2,000,000 1,000,000 200%- 1,000,000 0% Interest Income 3,731 - 5,394 - Revenue Total 2,003,731 1,000,000 200%5,394 1,000,000 1% Expenses Capital Outlay 21,140 1,000,000 2%2,255 800,000 0% Services and Supplies 6,289 - 17,770 - Interfund Transfers - 637,500 0%300,000 900,000 33% Expenses Total 27,429 1,637,500 2%320,025 1,700,000 19% 417 CROWN COMMUNITY CTR MAINTENANCE Revenue Interfund Transfers 58,332 175,000 33%58,333 175,000 33% Revenue Total 58,332 175,000 33%58,333 175,000 33% Expenses Capital Outlay 23,076 - Expenses Total 23,076 - 420 SPECIAL ASSESSMENT FUND Revenue Other Taxes 49,480 125,000 40%57,255 125,000 46% Interest Income 2,415 30,000 8%4,956 30,000 17% Revenue Total 51,895 155,000 33%62,211 155,000 40% Expenses Interfund Transfers 163,108 489,314 33%154,979 464,938 33% Services and Supplies 20 - 20 - Capital Outlay - 500,000 0%11,440 650,000 2% Expenses Total 163,128 989,314 16%166,439 1,114,938 15% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget 505 PARKING SYSTEM FUND Revenue Charges for Services 2,061,390 10,133,725 20%2,617,594 8,873,975 29% Other Revenue 121,148 1,404,700 9%84,988 486,700 17% Interest Income 1,392 20,000 7%2,790 20,000 14% Licenses, Permits and Fees 150 - 75 - Intergovernmental Revenue 766,667 2,300,000 33% Revenue Total 2,184,080 11,558,425 19%3,472,114 11,680,675 30% Expenses Services and Supplies 1,322,973 4,484,316 30%1,266,599 4,550,316 28% Interfund Transfers 1,044,128 3,132,390 33%1,044,130 3,132,390 33% Salary and Benefits 524,109 1,435,962 36%480,013 1,637,273 29% Insurance and Other Chargebacks 117,168 351,502 33%117,167 351,502 33% Capital Outlay 86,061 1,750,000 5%89,864 2,025,000 4% Debt Service - 47,164 0%- 72,900 0% Miscellaneous - 50,000 0%7,380 50,000 15% Expenses Total 3,094,439 11,251,334 28%3,005,154 11,819,381 25% 510 WATER FUND Revenue Charges for Services 6,026,419 23,006,700 26%6,659,830 23,443,200 28% Other Revenue 349,415 19,629,150 2%535,578 29,834,150 2% Interest Income 21,019 70,000 30%37,076 70,000 53% Licenses, Permits and Fees 10,080 50,000 20%29,480 50,000 59% Revenue Total 6,406,934 42,755,850 15%7,261,964 53,397,350 14% Expenses Salary and Benefits 1,941,791 5,927,918 33%1,986,500 6,004,605 33% Interfund Transfers 1,409,856 4,229,559 33%2,520,776 4,229,559 60% Services and Supplies 783,501 4,793,710 16%715,390 5,347,760 13% Insurance and Other Chargebacks 513,216 1,539,653 33%528,614 1,585,843 33% Debt Service 33,752 2,318,294 1%33,752 3,596,365 1% Miscellaneous 7,952 15,000 53%168,622 15,000 1124% Capital Outlay - 24,200 0%27,749 164,400 17% Contingencies - 1,000 0%- 1,000 0% Expenses Total 4,690,068 18,849,334 25%5,981,404 20,944,532 29% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget 513 WATER DEPR IMPRV &EXTENSION FUND Expenses Capital Outlay 1,852,111 24,068,000 8%1,469,124 33,036,000 4% Services and Supplies 51,955 1,500,000 3%208,138 3,465,000 6% Interfund Transfers (1,110,923) - Expenses Total 1,904,066 25,568,000 7%566,339 36,501,000 2% 515 SEWER FUND Revenue Charges for Services 2,894,086 10,375,408 28%2,636,350 10,113,594 26% Interest Income 1,095 25,000 4%1,134 25,000 5% Other Revenue 51 2,001,000 0%- 2,001,000 0% Revenue Total 2,895,233 12,401,408 23%2,637,484 12,139,594 22% Expenses Debt Service 1,589,611 5,195,191 31%992,008 3,772,691 26% Salary and Benefits 429,084 1,425,266 30%452,177 1,383,914 33% Interfund Transfers 285,128 855,375 33%290,388 871,164 33% Insurance and Other Chargebacks 110,752 332,255 33%117,397 352,190 33% Services and Supplies 97,671 1,484,650 7%58,805 1,471,800 4% Capital Outlay 13,489 3,343,000 0%- 3,538,100 0% Miscellaneous - 1,500 0%48,748 1,500 3250% Expenses Total 2,525,735 12,637,237 20%1,959,522 11,391,359 17% 520 SOLID WASTE FUND Revenue Charges for Services 1,374,081 4,516,450 30%1,450,148 4,516,450 32% Property Taxes 650,000 1,332,500 49%666,250 1,332,500 50% Licenses, Permits and Fees 75,624 297,000 25%99,269 297,000 33% Other Revenue 71,477 122,000 59%118,993 122,000 98% Revenue Total 2,171,182 6,267,950 35%2,334,661 6,267,950 37% Expenses Services and Supplies 986,615 3,778,926 26%1,012,469 3,786,776 27% Salary and Benefits 496,620 1,405,702 35%505,689 1,492,909 34% Interfund Transfers 100,668 302,000 33%100,667 302,000 33% Capital Outlay 23,577 505,000 5%128,705 525,000 25% Miscellaneous 6,393 10,000 64%5,873 15,000 39% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Expenses Total 1,613,873 6,001,628 27%1,753,402 6,121,685 29% 600 FLEET SERVICES FUND Revenue Charges for Services 1,035,812 3,127,440 33%1,035,813 3,127,440 33% Other Revenue - 69,000 0%4,969 69,000 7% Interest Income - 1,000 0%- 1,000 0% Revenue Total 1,035,812 3,197,440 32%1,040,782 3,197,440 33% Expenses Services and Supplies 493,985 2,034,507 24%681,514 2,034,507 33% Salary and Benefits 374,164 1,148,166 33%392,193 1,276,621 31% Capital Outlay 19,924 - Insurance and Other Chargebacks 3,645 - 900 - Expenses Total 891,718 3,182,673 28%1,074,607 3,311,128 32% 601 EQUIPMENT REPLACEMENT FUND Revenue Charges for Services 74,956 224,885 33%74,962 224,885 33% Other Revenue 63,090 1,060,217 6%816,474 960,217 85% 160 - Intergovernmental Revenue 533,333 1,600,000 33% Revenue Total 138,206 1,285,102 11%1,424,769 2,785,102 51% Expenses Capital Outlay 732,064 1,600,000 46%1,297,669 2,750,000 47% Services and Supplies 70 - Expenses Total 732,134 1,600,000 46%1,297,669 2,750,000 47% 605 INSURANCE FUND Revenue Other Revenue 3,373,166 10,402,039 32%3,474,310 11,248,243 31% Insurance 3,083,891 8,890,677 35%3,015,833 8,827,914 34% Workers Compensation and Liability 488,876 1,475,000 33%250,500 825,000 30% Charges for Services 799 - 2,387 - Revenue Total 6,946,732 20,767,716 33%6,743,030 20,901,157 32% Expenses Insurance and Other Chargebacks 5,115,637 16,641,267 31%5,539,464 16,957,400 33% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Services and Supplies 1,065,324 2,914,200 37%1,519,937 2,994,200 51% Salary and Benefits 226,027 662,620 34%45,958 4,751 967% Expenses Total 6,406,987 20,218,087 32%7,105,359 19,956,351 36%