Loading...
HomeMy WebLinkAbout2022.05 May Monthly Report To: Kelley A. Gandurski, Interim City Manager From: Hitesh Desai, CFO/City Treasurer Subject: May 2022 Monthly Financial Report Date: June 24, 2022 Please find attached the unaudited financial statements as of May 31, 2022. A summary by fund for revenues, expenditures, fund and cash balances is as follows: City of Evanston Cash & Investment Summary by Fund May 31, 2022 Fund #Fund Revenue Expense Net Fund Balance Cash Balance 100 General 64,020,492 48,530,056 15,490,437 46,665,949 42,593,861 170 American Rescue Plan 18,671 3,406,577 (3,387,906) (3,361,362) 13,425,465 175 General Assistance 751,445 423,220 328,224 938,670 938,542 176 Human Services 1,672,444 744,573 927,872 2,959,995 2,959,806 177 Reparations 3,381 62,353 (58,972) 446,742 446,742 178 Sustainability 117,969 - 117,969 117,969 117,969 180 Good Neighbor 840 31,025 (30,184) 871,979 871,979 185 Library 4,245,215 3,096,975 1,148,240 4,597,433 4,533,702 186 Library Debt Service 253,313 - 253,313 254,457 254,457 187 Library Capital Improvement FD - 104,032 (104,032) 774,094 774,094 200 MFT 2,028,454 830,147 1,198,307 6,279,131 6,002,142 205 E911 600,739 564,121 36,618 1,571,105 1,205,517 210 Special Service Area (SSA) #9 317,682 317,540 142 (206,608) (206,608) 215 CDBG 110,268 275,356 (165,087) (104,264) (104,264) 220 CDBG Loan 65,114 - 65,114 376,045 376,045 235 Neighborhood Improvement 21 4 16 22,159 22,159 240 Home 232,684 264,631 (31,947) (6,211) (6,211) 250 Affordable Housing 240,888 284,897 (44,009) 2,428,935 2,576,801 320 Debt Service 8,826,543 16,505 8,810,039 10,120,985 10,120,985 330 Howard Ridge 700,519 167,574 532,945 3,206,510 3,360,526 335 West Evanston 966,885 34,673 932,212 4,517,054 4,517,054 340 Dempster-Dodge-TIF 155,980 71,623 84,356 409,361 409,361 345 Chicago Main-TIF 634,026 135,690 498,336 1,449,864 1,449,864 350 Special Service Area (SSA) #6 122,512 - 122,512 124,291 124,291 355 Special Service Area (SSA) #7 81,850 77,075 4,775 13,490 13,490 360 Special Service Area (SSA) #8 32,204 30,517 1,687 4,905 4,905 415 Capital Improvements 596,879 1,048,409 (451,530) 11,154,007 11,283,166 416 Crown Construction 608,329 395,030 213,299 5,943,117 5,943,117 417 Crown Community CTR Maintenance 72,917 34,951 37,966 387,962 387,962 420 Special Assessment 64,632 205,189 (140,557) 1,993,038 1,993,038 505 Parking 4,356,417 3,965,096 391,321 (2,410,542) 849,964 510-513 Water 9,239,236 10,031,477 (792,241) 18,540,994 10,638,915 515 Sewer 3,607,659 2,902,577 705,081 10,738,851 4,658,936 520 Solid Waste 2,734,152 2,240,569 493,583 951,593 663 600 Fleet 1,302,053 1,318,952 (16,899) 701,755 (660,480) 601 Equipment Replacement 1,600,473 1,392,195 208,278 416,839 224,593 605 Insurance 8,361,450 8,435,118 (73,668) (4,572,830) (1,318,098) 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 May 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 May 31, 2022 with a fund balance of $46,665,949 and cash balance of $42,593,861. The attached financials show General Fund revenues at 54% of budget and expenses at 41 % 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 Budget % 2022 Actual Budget % LEGISLATIVE 795 - CITY COUNCIL 206,989 556,165.60 37%242,656 579,384.00 42% CITY CLERK 72,446 178,794.66 41%89,984 343,573.00 26% CITY MANAGER'S OFFICE 2,386,490 6,004,834.63 40%2,013,562 6,232,882.39 32% LAW 197,333 576,892.00 34%345,085 970,341.14 36% ADMINISTRATIVE SERVICES 3,972,678 10,360,246.39 38%4,561,688 11,449,182.64 40% COMMUNITY DEVELOPMENT 1,351,522 3,073,829.11 44%1,179,867 4,488,316.71 26% POLICE 18,146,807 39,734,285.59 46%11,588,388 29,280,597.55 40% FIRE MGMT & SUPPORT 12,404,419 26,006,574.05 48%7,133,289 16,823,271.83 42% HEALTH 800,864 1,556,419.50 51%804,957 1,453,836.00 55% PARKS AND RECREATION 3,581,308 11,329,360.87 32%3,477,871 12,101,740.47 29% PUBLIC WORKS AGENCY 5,052,296 11,642,790.99 43%5,192,919 13,444,799.45 39% NON-DEPARTMENTAL - - 11,899,791 20,723,062.00 57% Expenses Total 48,173,946 111,020,193 43%48,530,056 117,890,987 41% Expenses 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Expenses Total 48,173,946 111,020,193 43% 48,530,056 117,890,987 41% Staff continues to monitor Police and Fire overtime expenses. Through May, Police had spent 34 % of budget for overtime, and Fire had spent 44 % of the annual budget. Overtime Expenses 2021 Actual 2022 Budget 2022 YTD % Budget Enterprise Funds Parking fund revenues through May 31, 2022, are at 37 % of budget and expenses are at 34%. As the economy continues to improve in post -pandemic time, we expect Parking revenues to increase. Through May 31, 2022, overall Water Fund appears low on revenue and expenses. Water Fund operating revenues and expense s are in line with the budg et, 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 May 31, 2022, the Sewer Fund also appears low on expenses mainly due to the capit al projects and debt service payments occurring later in the year. Through May 31, 2022, the Solid Waste Fund has a fund balance of $951,593 and a cash balance of $663. Other Funds Through May 31, 2022, the SSA #9 Fund is showing a negative fund and cash balance of $206,608 . Through May 31 , 2022, the Capital Improvements Fund is showing a fund balance of $11,154,007 and a cash balance of $11,283,166. The fund continues to spend down Series 2021 and Series 2020 bond proceeds. Through May 31, 2022, the Crown Construction fund is showing fund and cash balance of $5,943,117 . The fund continues to spend down balances from bond proceeds and gifts from the Friends of Robert Crown. Through May 31, 2022, the Insurance Fund is showing a negative fund balance of $4,572,830 and a negative cash balance of $1,318,098 . 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 (8 47) 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 May 31, 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 21,933,051 48,775,000 45%28,596,655 51,925,000 55% Property Taxes 16,239,155 28,298,539 57%15,877,224 28,774,164 55% Licenses, Permits and Fees 4,379,730 8,085,550 54%3,407,916 8,085,550 42% Interfund Transfers 4,067,947 9,149,103 44%3,656,544 8,775,706 42% Charges for Services 4,000,843 9,357,875 43%5,674,891 8,491,325 67% Intergovernmental Revenue 1,630,415 1,584,942 103%3,864,399 5,961,342 65% Fines and Forfeitures 1,044,993 4,123,500 25%1,507,083 3,723,500 40% Other Revenue 380,197 1,593,100 24%1,357,237 2,118,100 64% Interest Income 13,483 55,000 25%78,542 55,000 143% Revenue Total 53,689,814 111,022,609 48%64,020,492 117,909,687 54% Expenses LEGISLATIVE 795 - CITY COUNCIL 206,989 556,165.60 37%242,656 579,384.00 42% CITY CLERK 72,446 178,794.66 41%89,984 343,573.00 26% CITY MANAGER'S OFFICE 2,386,490 6,004,834.63 40%2,013,562 6,232,882.39 32% LAW 197,333 576,892.00 34%345,085 970,341.14 36% ADMINISTRATIVE SERVICES 3,972,678 10,360,246.39 38%4,561,688 11,449,182.64 40% COMMUNITY DEVELOPMENT 1,351,522 3,073,829.11 44%1,179,867 4,488,316.71 26% POLICE 18,146,807 39,734,285.59 46%11,588,388 29,280,597.55 40% FIRE MGMT & SUPPORT 12,404,419 26,006,574.05 48%7,133,289 16,823,271.83 42% HEALTH 800,864 1,556,419.50 51%804,957 1,453,836.00 55% PARKS AND RECREATION 3,581,308 11,329,360.87 32%3,477,871 12,101,740.47 29% PUBLIC WORKS AGENCY 5,052,296 11,642,790.99 43%5,192,919 13,444,799.45 39% NON-DEPARTMENTAL - - 11,899,791 20,723,062.00 57% Expenses Total 48,173,946 111,020,193 43%48,530,056 117,890,987 41% 170 AMERICAN RESCUE PLAN Revenue Intergovernmental Revenue 21,586,827 - - 21,586,827 0% Interest Income 3,980 - 18,671 - Revenue Total 21,590,807 - 18,671 21,586,827 0% Expenses Services and Supplies - - Miscellaneous 3,244 22,250,000 0% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Capital Outlay 7,500 - Interfund Transfers 3,395,833 8,150,000 42% Expenses Total 3,406,577 30,400,000 11% 175 GENERAL ASSISTANCE FUND Revenue Property Taxes 599,985 1,300,000 46%724,404 1,300,000 56% Other Revenue 2,585 27,500 9%25,713 27,500 94% Interest Income 628 1,000 63%1,328 1,000 133% Revenue Total 603,198 1,328,500 45%751,445 1,328,500 57% Expenses Services and Supplies 269,407 865,982 31%226,396 864,482 26% Salary and Benefits 208,938 452,062 46%196,824 469,871 42% Miscellaneous - 7,000 0%- 7,000 0% Expenses Total 478,345 1,325,044 36%423,220 1,341,353 32% 176 HUMAN SERVICES FUND Revenue Property Taxes 1,530,000 3,110,000 49%1,550,000 3,110,000 50% Interfund Transfers 187,500 450,000 42% Intergovernmental Revenue 57,165 125,000 46%120,472 194,000 62% Other Revenue 2,740 2,000 137%- 2,000 0% Interest Income 571 - 1,972 - Revenue Total 1,777,976 3,687,000 48%1,672,444 3,306,000 51% Expenses Salary and Benefits 615,029 1,697,148 36%587,252 1,705,820 34% Miscellaneous 91,640 465,000 20%52,197 258,000 20% Community Sponsored Organizations 47,590 143,333 33%53,400 143,333 37% Services and Supplies 8,647 1,340,243 1%51,724 1,761,183 3% Insurance and Other Chargebacks 7,701 - Expenses Total 770,607 3,645,724 21%744,573 3,868,336 19% 177 REPARATIONS FUND Revenue Other Revenue 24,424 - 3,025 - Interest Income 95 - 356 - Other Taxes - 400,000 0%- 400,000 0% Revenue Total 24,519 400,000 6%3,381 400,000 1% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Expenses Services and Supplies 20 - 931 - Miscellaneous - 400,000 0%61,422 400,000 15% Expenses Total 20 400,000 0%62,353 400,000 16% 178 SUSTAINABILITY FUND Revenue Interfund Transfers 117,969 - Revenue Total 117,969 - 180 GOOD NEIGHBOR FUND Revenue Other Revenue 1,000,000 1,000,000 100% Interest Income 405 - 840 - Revenue Total 1,000,405 1,000,000 100%840 - Expenses Interfund Transfers 414,152 380,000 109%- - Miscellaneous 11,113 620,000 2%30,000 1,000,000 3% Services and Supplies 247 - 175 - Capital Outlay 850 - Expenses Total 425,512 1,000,000 43%31,025 1,000,000 3% 185 LIBRARY FUND Revenue Property Taxes 3,959,723 7,252,000 55%4,007,676 7,252,000 55% Interfund Transfers 250,000 209,000 120%- 217,911 0% Intergovernmental Revenue 117,033 238,000 49%23,130 472,866 5% Other Revenue 114,895 400,000 29%125,604 410,000 31% Library Revenue 49,049 227,224 22%82,380 174,800 47% Interest Income 4,842 15,000 32%6,243 15,000 42% Fines and Forfeitures 4,478 - Charges for Services 93 - 182 - Licenses, Permits and Fees - 115,767 0% Revenue Total 4,500,112 8,341,224 54%4,245,215 8,658,344 49% Expenses Salary and Benefits 2,424,157 5,910,018 41%2,151,603 6,132,692 35% Services and Supplies 673,674 2,052,000 33%723,359 2,136,767 34% Interfund Transfers 150,505 361,226 42%158,189 379,653 42% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Capital Outlay - 8,500 0%- 8,500 0% Miscellaneous 63,824 - Expenses Total 3,248,336 8,331,744 39%3,096,975 8,657,612 36% 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 281,327 449,000 63%104,032 680,000 15% Expenses Total 281,327 449,000 63%104,032 680,000 15% 200 MOTOR FUEL TAX FUND Revenue Intergovernmental Revenue 1,940,764 3,656,700 53%2,021,342 3,656,700 55% Interest Income 2,462 12,000 21%7,112 12,000 59% Revenue Total 1,943,226 3,668,700 53%2,028,454 3,668,700 55% Expenses Interfund Transfers 435,410 1,044,987 42%435,411 1,044,987 42% Services and Supplies 368,806 1,038,000 36%361,176 1,038,000 35% Capital Outlay 28,955 2,284,000 1%33,560 3,261,000 1% Expenses Total 833,171 4,366,987 19%830,147 5,343,987 16% 205 EMERGENCY TELEPHONE (E911) FUND Revenue Other Taxes 590,026 1,321,600 45%599,867 1,400,000 43% Interest Income 388 7,000 6%872 7,000 12% Other Revenue 266 - Revenue Total 590,680 1,328,600 44%600,739 1,407,000 43% Expenses Salary and Benefits 232,852 742,978 31%323,530 768,616 42% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Services and Supplies 70,097 374,000 19%160,306 393,700 41% Interfund Transfers 37,500 90,000 42%37,500 90,000 42% Insurance and Other Chargebacks 7,595 18,230 42%7,596 18,230 42% Capital Outlay 1,950 299,163 1%35,188 450,000 8% Expenses Total 349,994 1,524,371 23%564,121 1,720,546 33% 210 SPECIAL SERVICE AREA (SSA) #9 Revenue Property Taxes 298,855 592,665 50%317,607 595,000 53% Interest Income 3 - 75 - Revenue Total 298,858 592,665 50%317,682 595,000 53% Expenses Services and Supplies 187,607 575,000 33%317,540 575,000 55% Expenses Total 187,607 575,000 33%317,540 575,000 55% 215 CDBG FUND Revenue Intergovernmental Revenue 73,517 2,758,514 3%110,178 3,684,820 3% Interest Income 90 - Revenue Total 73,517 2,758,514 3%110,268 3,684,820 3% Expenses Salary and Benefits 151,441 319,997 47%156,222 589,422 27% Insurance and Other Chargebacks 138,009 150,000 92% Community Sponsored Organizations 96,451 80,000 121%110,136 75,000 147% Capital Outlay 95,150 - Miscellaneous 7,114 1,700,000 0%3,724 2,515,000 0% Services and Supplies 3,840 506,200 1%5,274 506,200 1% Expenses Total 492,006 2,756,197 18%275,356 3,685,622 7% 220 CDBG LOAN FUND Revenue Other Revenue 52,761 110,000 48%64,653 100,000 65% Interest Income 430 - 461 - Revenue Total 53,191 110,000 48%65,114 100,000 65% Expenses Miscellaneous 9 - Services and Supplies - 175,000 0%- 175,000 0% Expenses Total 9 175,000 0%- 175,000 0% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget 225 ECONOMIC DEVELOPMENT FUND Expenses Services and Supplies - - Expenses Total - - 235 NEIGHBORHOOD IMPROVEMENT Revenue Interest Income 12 - 21 - Revenue Total 12 - 21 - 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,448 25,000 62%18,345 25,000 73% Interest Income 29 150 19%111 150 74% Revenue Total 166,168 565,603 29%232,684 565,603 41% Expenses Services and Supplies 177,345 500,565 35%238,035 500,565 48% Salary and Benefits 28,375 63,876 44%26,595 70,681 38% Miscellaneous - 500 0%- 500 0% Insurance and Other Chargebacks (431) - Expenses Total 205,289 564,941 36%264,631 571,746 46% 250 AFFORDABLE HOUSING FUND Revenue Intergovernmental Revenue 108,974 658,000 17%174,092 658,000 26% Other Revenue 64,167 175,600 37%65,000 140,600 46% Interest Income 3,960 5,700 69%1,797 5,700 32% Other Taxes - 75,000 0%- 75,000 0% Revenue Total 177,101 914,300 19%240,888 879,300 27% Expenses Services and Supplies 297,882 2,031,050 15%32,950 2,065,050 2% Community Sponsored Organizations 162,013 166,000 98%169,810 166,000 102% Salary and Benefits 75,772 202,684 37%75,049 180,075 42% Miscellaneous 11,349 102,510 11%2,991 67,500 4% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Capital Outlay 3,000 10,000 30%- 10,000 0% Insurance and Other Chargebacks (27,309) 17,000 -161%4,097 17,000 24% Expenses Total 522,707 2,529,244 21%284,897 2,505,625 11% 320 DEBT SERVICE FUND Revenue Property Taxes 7,049,442 13,936,263 51%7,875,650 13,436,256 59% Interfund Transfers 498,925 1,197,401 42%944,600 2,267,041 42% Interest Income 3,236 1,500 216%6,293 1,500 420% Other Revenue (1,135) - - - Revenue Total 7,550,467 15,135,164 50%8,826,543 15,704,797 56% Expenses Services and Supplies 10 - Debt Service - 15,133,666 0%- 15,690,075 0% Miscellaneous 16,505 - Expenses Total 10 15,133,666 0%16,505 15,690,075 0% 330 HOWARD-RIDGE TIF FUND Revenue Property Taxes 670,975 968,000 69%675,975 1,100,000 61% Interest Income 2,549 400 637%2,623 400 656% Other Revenue 447 5,366 8%21,921 5,366 409% Revenue Total 673,971 973,766 69%700,519 1,105,766 63% Expenses Services and Supplies 149,995 335,000 45%1,694 265,000 1% Interfund Transfers 90,880 218,113 42%165,880 398,113 42% Capital Outlay (9,750) 500,000 -2%- 785,000 0% Expenses Total 231,125 1,053,113 22%167,574 1,448,113 12% 335 WEST EVANSTON TIF FUND Revenue Property Taxes 869,944 1,237,000 70%963,720 1,450,000 66% Other Revenue 171,504 11,000 1559%- 11,000 0% Interest Income 1,859 4,000 46%3,164 4,000 79% Revenue Total 1,043,307 1,252,000 83%966,885 1,465,000 66% Expenses Interfund Transfers 31,250 75,000 42%31,250 75,000 42% Services and Supplies 434 5,000 9%3,406 5,000 68% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Capital Outlay - 500,000 0%17 1,765,000 0% Miscellaneous - 200,000 0%- 200,000 0% Expenses Total 31,684 780,000 4%34,673 2,045,000 2% 340 DEMPSTER-DODGE TIF FUND Revenue Property Taxes 93,669 147,000 64%155,622 160,000 97% Interest Income 197 - 358 - Revenue Total 93,866 147,000 64%155,980 160,000 97% Expenses Interfund Transfers 70,385 168,923 42%71,597 171,833 42% Services and Supplies 333 2,000 17%26 2,000 1% Expenses Total 70,718 170,923 41%71,623 173,833 41% 345 CHICAGO-MAIN TIF Revenue Property Taxes 460,178 879,000 52%632,880 1,000,000 63% Interest Income 1,208 - 1,146 - Other Revenue - 1,130,000 0% Revenue Total 461,387 2,009,000 23%634,026 1,000,000 63% Expenses Capital Outlay 116,567 1,130,000 10%25,341 1,090,000 2% Interfund Transfers 109,520 262,843 42%110,318 264,763 42% Services and Supplies 341 5,000 7%30 5,000 1% Miscellaneous - 250,000 0% Expenses Total 226,428 1,397,843 16%135,690 1,609,763 8% 350 SPECIAL SERVICE AREA (SSA) #6 Revenue Property Taxes 5,264 221,000 2%122,429 221,000 55% Interest Income 5 500 1%83 - Revenue Total 5,269 221,500 2%122,512 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 76,800 154,800 50%81,741 142,000 58% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Interest Income 55 - 109 - Revenue Total 76,855 154,800 50%81,850 142,000 58% Expenses Services and Supplies 16,625 115,000 14%77,075 140,000 55% Expenses Total 16,625 115,000 14%77,075 140,000 55% 360 SPECIAL SERVICE AREA (SSA) #8 Revenue Property Taxes 31,525 60,200 52%32,204 60,200 53% Interest Income 1 - 0 - Revenue Total 31,525 60,200 52%32,204 60,200 53% Expenses Services and Supplies 74,228 60,200 123%30,517 60,200 51% Expenses Total 74,228 60,200 123%30,517 60,200 51% 415 CAPITAL IMPROVEMENTS FUND Revenue Intergovernmental Revenue 329,333 - Interest Income 6,815 - 14,188 - Charges for Services 9,837 - Other Revenue (726) 7,645,000 0%572,853 12,253,000 5% Revenue Total 335,423 7,645,000 4%596,879 12,253,000 5% Expenses Capital Outlay 905,602 9,705,000 9%572,556 16,455,000 3% Services and Supplies 363,584 - 427,494 - Salary and Benefits 300,050 696,766 43%- - Miscellaneous 48,358 - Expenses Total 1,569,236 10,401,766 15%1,048,409 16,455,000 6% 416 CROWN CONSTRUCTION FUND Revenue Other Revenue 2,000,000 1,000,000 200%600,000 1,000,000 60% Intergovernmental Revenue 750,000 - Interest Income 4,617 - 8,329 - Revenue Total 2,754,617 1,000,000 275%608,329 1,000,000 61% Expenses Capital Outlay 59,127 1,000,000 6%2,255 800,000 0% Services and Supplies 6,294 - 17,775 - Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Interfund Transfers - 637,500 0%375,000 900,000 42% Expenses Total 65,421 1,637,500 4%395,030 1,700,000 23% 417 CROWN COMMUNITY CTR MAINTENANCE Revenue Interfund Transfers 72,915 175,000 42%72,917 175,000 42% Revenue Total 72,915 175,000 42%72,917 175,000 42% Expenses Capital Outlay 34,951 - Expenses Total 34,951 - 420 SPECIAL ASSESSMENT FUND Revenue Other Taxes 49,929 125,000 40%59,594 125,000 48% Interest Income 2,613 30,000 9%5,038 30,000 17% Revenue Total 52,542 155,000 34%64,632 155,000 42% Expenses Interfund Transfers 203,885 489,314 42%193,724 464,938 42% Services and Supplies 25 - 25 - Capital Outlay - 500,000 0%11,440 650,000 2% Expenses Total 203,910 989,314 21%205,189 1,114,938 18% 505 PARKING SYSTEM FUND Revenue Charges for Services 2,447,030 10,133,725 24%3,277,405 8,873,975 37% Other Revenue 193,437 1,404,700 14%114,006 486,700 23% Interest Income 5,575 20,000 28%6,597 20,000 33% Licenses, Permits and Fees 150 - 75 - Intergovernmental Revenue 958,333 2,300,000 42% Revenue Total 2,646,191 11,558,425 23%4,356,417 11,680,675 37% Expenses Services and Supplies 1,571,784 4,484,316 35%1,601,440 4,550,316 35% Interfund Transfers 1,305,160 3,132,390 42%1,305,163 3,132,390 42% Salary and Benefits 653,799 1,435,962 46%583,407 1,637,273 36% Insurance and Other Chargebacks 146,460 351,502 42%146,459 351,502 42% Capital Outlay 108,783 1,750,000 6%322,264 2,025,000 16% Debt Service - 47,164 0%- 72,900 0% Miscellaneous - 50,000 0%6,363 50,000 13% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Expenses Total 3,785,986 11,251,334 34%3,965,096 11,819,381 34% 510 WATER FUND Revenue Charges for Services 7,785,934 23,006,700 34%8,622,924 23,443,200 37% Other Revenue 361,612 19,629,150 2%535,554 29,834,150 2% Licenses, Permits and Fees 30,507 50,000 61%36,080 50,000 72% Interest Income 27,949 70,000 40%44,679 70,000 64% Revenue Total 8,206,002 42,755,850 19%9,239,236 53,397,350 17% Expenses Salary and Benefits 2,468,011 5,927,918 42%2,415,328 6,004,605 40% Interfund Transfers 1,762,320 4,229,559 42%2,873,239 4,229,559 68% Services and Supplies 1,006,019 4,793,710 21%1,136,314 5,347,760 21% Insurance and Other Chargebacks 641,520 1,539,653 42%660,768 1,585,843 42% Debt Service 135,695 2,318,294 6%135,695 3,596,365 4% Miscellaneous 7,952 15,000 53%160,161 15,000 1068% Capital Outlay - 24,200 0%27,749 164,400 17% Contingencies - 1,000 0%- 1,000 0% Expenses Total 6,021,517 18,849,334 32%7,409,254 20,944,532 35% 513 WATER DEPR IMPRV &EXTENSION FUND Expenses Capital Outlay 2,668,698 24,068,000 11%3,517,755 33,036,000 11% Services and Supplies 104,607 1,500,000 7%215,729 3,465,000 6% Interfund Transfers (1,110,923) - Expenses Total 2,773,305 25,568,000 11%2,622,562 36,501,000 7% 515 SEWER FUND Revenue Charges for Services 3,814,449 10,375,408 37%3,605,179 10,113,594 36% Interest Income 1,681 25,000 7%2,480 25,000 10% Other Revenue (2,892) 2,001,000 0%- 2,001,000 0% Revenue Total 3,813,239 12,401,408 31%3,607,659 12,139,594 30% Expenses Debt Service 2,613,932 5,195,191 50%1,708,694 3,772,691 45% Salary and Benefits 557,810 1,425,266 39%556,233 1,383,914 40% Interfund Transfers 356,410 855,375 42%362,985 871,164 42% Insurance and Other Chargebacks 138,440 332,255 42%146,746 352,190 42% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Services and Supplies 135,488 1,484,650 9%85,889 1,471,800 6% Capital Outlay 13,489 3,343,000 0%- 3,538,100 0% Miscellaneous - 1,500 0%42,031 1,500 2802% Expenses Total 3,815,569 12,637,237 30%2,902,577 11,391,359 25% 520 SOLID WASTE FUND Revenue Charges for Services 1,684,910 4,516,450 37%1,839,862 4,516,450 41% Property Taxes 650,000 1,332,500 49%666,250 1,332,500 50% Licenses, Permits and Fees 77,574 297,000 26%108,146 297,000 36% Other Revenue 72,721 122,000 60%119,893 122,000 98% Revenue Total 2,485,205 6,267,950 40%2,734,152 6,267,950 44% Expenses Services and Supplies 1,310,199 3,778,926 35%1,348,012 3,786,776 36% Salary and Benefits 612,523 1,405,702 44%619,362 1,492,909 41% Capital Outlay 192,793 505,000 38%138,999 525,000 26% Interfund Transfers 125,835 302,000 42%125,833 302,000 42% Miscellaneous 7,409 10,000 74%8,363 15,000 56% Expenses Total 2,248,759 6,001,628 37%2,240,569 6,121,685 37% 600 FLEET SERVICES FUND Revenue Charges for Services 1,294,765 3,127,440 41%1,294,767 3,127,440 41% Other Revenue 1,578 69,000 2%7,286 69,000 11% Interest Income - 1,000 0%- 1,000 0% Revenue Total 1,296,343 3,197,440 41%1,302,053 3,197,440 41% Expenses Services and Supplies 641,111 2,034,507 32%833,106 2,034,507 41% Salary and Benefits 475,653 1,148,166 41%484,946 1,276,621 38% Capital Outlay 19,924 - Insurance and Other Chargebacks 7,665 - 900 - Expenses Total 1,144,354 3,182,673 36%1,318,952 3,311,128 40% 601 EQUIPMENT REPLACEMENT FUND Revenue Charges for Services 93,695 224,885 42%93,702 224,885 42% Other Revenue 63,090 1,060,217 6%840,104 960,217 87% Interest Income 160 - Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget Intergovernmental Revenue 666,667 1,600,000 42% Revenue Total 156,945 1,285,102 12%1,600,473 2,785,102 57% Expenses Capital Outlay 854,331 1,600,000 53%1,392,195 2,750,000 51% Services and Supplies 70 - Expenses Total 854,401 1,600,000 53%1,392,195 2,750,000 51% 605 INSURANCE FUND Revenue Other Revenue 4,212,637 10,402,039 40%4,306,175 11,248,243 38% Insurance 3,796,308 8,890,677 43%3,725,984 8,827,914 42% Workers Compensation and Liability 612,909 1,475,000 42%313,000 825,000 38% Charges for Services 830 - 16,291 - Revenue Total 8,622,685 20,767,716 42%8,361,450 20,901,157 40% Expenses Insurance and Other Chargebacks 6,283,165 16,641,267 38%6,799,589 16,957,400 40% Services and Supplies 1,205,003 2,914,200 41%1,582,915 2,994,200 53% Salary and Benefits 278,430 662,620 42%52,614 4,751 1107% Expenses Total 7,766,598 20,218,087 38%8,435,118 19,956,351 42%