Loading...
HomeMy WebLinkAbout2022.06 June Monthly Report To: Luke Stowe , Interim City Manager From: Hitesh Desai, CFO/City Treasurer Subject: June 2022 Monthly Financial Report Date: July 29, 2022 Please find attached the unaudited financial statements as of June 30, 2022. A summary by fund for revenues, expenditures, fund and cash balances is as follows: City of Evanston Cash & Investment Summary by Fund June 30, 2022 Fund #Fund Revenue Expense Net Fund Balance Cash Balance 100 General 73,044,397 56,917,336 16,127,062 47,619,230 43,157,156 170 American Rescue Plan 21,644,992 4,132,463 17,512,530 17,539,074 34,325,901 175 General Assistance 760,601 508,941 251,660 861,978 861,978 176 Human Services 1,694,259 896,043 798,216 2,830,151 2,830,151 177 Reparations 3,666 101,122 (97,456) 408,259 408,259 178 Sustainability 117,969 - 117,969 117,969 117,969 180 Good Neighbor 1,085 59,153 (58,068) 844,095 844,095 185 Library 4,312,772 3,880,255 432,517 3,952,133 3,812,905 186 Library Debt Service 253,313 119,322 133,991 135,134 135,134 187 Library Capital Improvement FD - 104,032 (104,032) 774,094 774,094 200 MFT 2,284,164 1,060,878 1,223,286 6,304,110 6,027,122 205 E911 965,379 666,731 298,647 1,833,134 1,467,546 210 Special Service Area (SSA) #9 318,479 317,540 939 (205,811) (205,811) 215 CDBG 110,387 437,725 (327,338) (266,515) (266,515) 220 CDBG Loan 66,392 - 66,392 377,323 377,323 235 Neighborhood Improvement 27 5 22 22,165 22,165 240 Home 243,070 270,631 (27,560) (1,824) (1,824) 250 Affordable Housing 247,290 287,351 (40,062) 2,432,882 2,580,747 320 Debt Service 9,114,879 2,871,325 6,243,554 7,696,126 7,554,500 330 Howard Ridge 715,575 200,752 514,823 3,188,389 3,342,404 335 West Evanston 1,001,903 50,274 951,628 4,224,842 4,203,834 340 Dempster-Dodge-TIF 156,356 85,943 70,413 395,418 395,418 345 Chicago Main-TIF 674,221 177,250 496,971 1,448,498 1,448,498 350 Special Service Area (SSA) #6 122,609 - 122,609 124,388 124,388 355 Special Service Area (SSA) #7 82,159 77,075 5,084 13,798 13,798 360 Special Service Area (SSA) #8 32,924 30,517 2,407 5,624 5,624 415 Capital Improvements 1,560,898 1,858,844 (297,946) 11,307,591 11,436,750 416 Crown Construction 613,400 470,035 143,365 5,873,183 5,873,183 417 Crown Community CTR Maintenance 87,500 34,951 52,549 402,545 402,545 420 Special Assessment 74,259 243,939 (169,680) 1,963,915 1,963,915 505 Parking 5,370,260 4,725,042 645,218 1,376,284 979,460 510-513 Water 11,440,440 15,748,037 (4,307,597) 9,186,021 7,954,328 515 Sewer 4,329,015 3,312,249 1,016,766 6,619,667 5,268,268 520 Solid Waste 3,168,209 3,192,670 (24,461) 433,308 (469,405) 600 Fleet 1,568,822 1,644,229 (75,407) 643,209 (718,988) 601 Equipment Replacement 1,753,742 1,400,383 353,359 369,674 369,674 605 Insurance 10,065,444 10,387,495 (322,051) (4,821,232) (1,567,039) 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 June 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 June 30, 2022 with a fund balance of $47,619,230 and cash balance of $43,157,156 . The attached financials show General Fund revenues at 62% of budget and expenses at 48 % of budget. Additionally, taxes collected such as Sales and Income, are higher due to inflation. Per reports, the second installment of property tax disbursement from Cook County is expected to be delayed by 3 -5 months. City Staff is monitoring the cash balances closely to avoid any cash flow issues. Typically, the second installment bills are sen t out in July with a due date of August 1 . Expenses by Department Expenses 2021 Actual 2021 Budget % of Budget 2022 Actual 2022 Budget % of Budget LEGISLATIVE 795 - - - CITY COUNCIL 242,922 556,166 44%288,923 579,384 50% CITY CLERK 85,568 178,795 48%119,095 343,573 35% CITY MANAGER'S OFFICE 2,923,901 6,004,835 49%2,962,994 6,232,882 48% LAW 230,891 576,892 40%413,871 970,341 43% ADMINISTRATIVE SERVICES 4,818,951 10,360,246 47%5,771,607 11,449,183 50% COMMUNITY DEVELOPMENT 1,630,535 3,073,829 53%1,438,567 4,488,317 32% POLICE 20,152,264 39,734,286 51%13,514,860 29,280,598 46% FIRE MGMT & SUPPORT 13,671,267 26,006,574 53%8,473,157 16,823,272 50% HEALTH 989,125 1,556,420 64%1,030,793 1,453,836 71% PARKS AND RECREATION 4,640,929 11,329,361 41%4,658,483 12,101,740 38% PUBLIC WORKS AGENCY 5,947,840 11,642,791 51%6,217,823 13,444,799 46% NON-DEPARTMENTAL - - 12,027,164 20,723,062 58% Total 55,334,989 111,020,193 50%56,917,336 117,890,987 48% Staff continues to monitor Police and Fire overtime expenses. Through June, Police had spent 4 4% of budget for overtime, and Fire had spent 5 4% of the annual budget . Overtime Expenses 2021 Actual 2022 Budget 2022 YTD % Budget Enterprise Funds Parking fund revenues through June 30, 2022, are at 46 % of budget and expenses are at 40%. As the economy continues to improve in post -pandemic time, we expect Parking revenues to increase. Through June 30, 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. Expenses 2021 Actual 2021 Budget % of Budget 2022 Actual 2022 Budget % of Budget Salary and Benefits 34,721,478 68,210,034 51%34,227,334 74,503,722 46% Insurance and Other Chargebacks 13,905,341 25,368,239 55%13,927,945 24,383,062 57% Services and Supplies 4,830,719 13,313,796 36%6,429,765 15,131,213 42% Interfund Transfers 1,522,488 3,045,000 50%1,915,468 2,595,000 74% Miscellaneous 203,104 579,625 35%304,163 590,390 52% Community Sponsored Organizations 102,741 - 6,028 69,600 9% Capital Outlay 47,394 320,000 15%106,634 434,500 25% Contingencies 1,723 183,500 1%- 183,500 0% Total 55,334,989 111,020,193 50%56,917,336 117,890,987 48% Through June 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 June 30 , 2022, the Solid Waste Fund has a fund balance of $433,308 and a negative cash balance of $469,405 Other Funds Through June 30 , 2022, the SSA #9 Fund is showing a negative fund and cash balance of $205,811 . Through June 30 , 2022, the Capital Improvements Fund is showing a fund balance of $11,307,591 and a cash balance of $11,436,750. The fund continues to spend down Series 2021 and Series 2020 bond proceeds. Through June 30, 2022, the Crown Construction fund is showing fund and cash balance of $5,873,183 . The fund continues to spend down balances from bond proceeds and gifts from the Friends of Robert Crown. Through June 30 , 2022, the Insurance Fund is showing a negative fund balance of $4,821,232 and a negative cash balance of $1,567,039. 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 June 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 26,835,836 48,775,000 55%33,887,203 51,925,000 65% Property Taxes 16,239,155 28,298,539 57%16,081,417 28,774,164 56% Charges for Services 5,035,660 9,357,875 54%6,093,861 8,491,325 72% Licenses, Permits and Fees 4,946,955 8,085,550 61%4,231,100 8,085,550 52% Interfund Transfers 4,798,706 9,149,103 52%4,387,853 8,775,706 50% Intergovernmental Revenue 1,829,081 1,584,942 115%4,841,209 5,961,342 81% Fines and Forfeitures 1,337,784 4,123,500 32%1,877,341 3,723,500 50% Other Revenue 407,812 1,593,100 26%1,531,341 2,118,100 72% Interest Income 16,661 55,000 30%113,073 55,000 206% Revenue Total 61,447,649 111,022,609 55%73,044,397 117,909,687 62% Expenses LEGISLATIVE 795 - - - CITY COUNCIL 242,922 556,166 44%288,923 579,384 50% CITY CLERK 85,568 178,795 48%119,095 343,573 35% CITY MANAGER'S OFFICE 2,923,901 6,004,835 49%2,962,994 6,232,882 48% LAW 230,891 576,892 40%413,871 970,341 43% ADMINISTRATIVE SERVICES 4,818,951 10,360,246 47%5,771,607 11,449,183 50% COMMUNITY DEVELOPMENT 1,630,535 3,073,829 53%1,438,567 4,488,317 32% POLICE 20,152,264 39,734,286 51%13,514,860 29,280,598 46% FIRE MGMT & SUPPORT 13,671,267 26,006,574 53%8,473,157 16,823,272 50% HEALTH 989,125 1,556,420 64%1,030,793 1,453,836 71% PARKS AND RECREATION 4,640,929 11,329,361 41%4,658,483 12,101,740 38% PUBLIC WORKS AGENCY 5,947,840 11,642,791 51%6,217,823 13,444,799 46% NON-DEPARTMENTAL - - 12,027,164 20,723,062 58% Expenses Total 55,334,989 111,020,193 50%56,917,336 117,890,987 48% 170 AMERICAN RESCUE PLAN Revenue Intergovernmental Revenue 21,586,827 - 21,586,827 21,586,827 100% Interest Income 8,262 - 58,165 - Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget. Revenue Total 21,595,089 - 21,644,992 21,586,827 100% Expenses Capital Outlay 9,028 - Salary and Benefits 400 - Miscellaneous 12,787 22,250,000 0% Community Sponsored Organizations 6,000 - Services and Supplies - - Insurance and Other Chargebacks 29,247 - Interfund Transfers 4,075,000 8,150,000 50% Expenses Total 4,132,463 30,400,000 14% 175 GENERAL ASSISTANCE FUND Revenue Property Taxes 599,985 1,300,000 46%732,636 1,300,000 56% Other Revenue 2,585 27,500 9%25,713 27,500 94% Interest Income 777 1,000 78%2,253 1,000 225% Revenue Total 603,347 1,328,500 45%760,601 1,328,500 57% Expenses Services and Supplies 308,779 865,982 36%275,055 864,482 32% Salary and Benefits 245,492 452,062 54%233,887 469,871 50% Miscellaneous - 7,000 0%- 7,000 0% Expenses Total 554,271 1,325,044 42%508,941 1,341,353 38% 176 HUMAN SERVICES FUND Revenue Property Taxes 1,530,000 3,110,000 49%1,550,000 3,110,000 50% Interfund Transfers 225,000 450,000 50% Intergovernmental Revenue 67,998 125,000 54%141,750 194,000 73% Other Revenue 2,740 2,000 137%- 2,000 0% Interest Income 802 - 2,509 - Revenue Total 1,826,540 3,687,000 50%1,694,259 3,306,000 51% Expenses Salary and Benefits 743,466 1,697,148 44%710,517 1,705,820 42% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget. Miscellaneous 103,382 465,000 22%63,798 258,000 25% Services and Supplies 60,031 1,340,243 4%68,328 1,761,183 4% Community Sponsored Organizations 52,292 143,333 36%53,400 143,333 37% Insurance and Other Chargebacks 7,701 - Expenses Total 966,873 3,645,724 27%896,043 3,868,336 23% 177 REPARATIONS FUND Revenue Other Revenue 25,009 - 3,125 - Interest Income 142 - 541 - Other Taxes - 400,000 0%- 400,000 0% Revenue Total 25,151 400,000 6%3,666 400,000 1% Expenses Services and Supplies 25 - 1,097 - Miscellaneous - 400,000 0%100,024 400,000 25% Expenses Total 25 400,000 0%101,122 400,000 25% 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 502 - 1,085 - Revenue Total 1,000,502 1,000,000 100%1,085 - Expenses Interfund Transfers 414,152 380,000 109%- - Miscellaneous 11,113 620,000 2%40,000 1,000,000 4% Services and Supplies 269 - 201 - Capital Outlay 18,953 - Expenses Total 425,533 1,000,000 43%59,153 1,000,000 6% 185 LIBRARY FUND Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget. Revenue Property Taxes 3,959,723 7,252,000 55%4,052,831 7,252,000 56% Interfund Transfers 250,000 209,000 120%- 217,911 0% Other Revenue 125,134 400,000 31%137,344 410,000 33% Intergovernmental Revenue 117,033 238,000 49%23,130 472,866 5% Library Revenue 53,150 227,224 23%88,454 174,800 51% Interest Income 6,103 15,000 41%10,787 15,000 72% Fines and Forfeitures 4,478 - Charges for Services 111 - 225 - Licenses, Permits and Fees - 115,767 0% Revenue Total 4,515,731 8,341,224 54%4,312,772 8,658,344 50% Expenses Salary and Benefits 2,880,383 5,910,018 49%2,694,269 6,132,692 44% Services and Supplies 856,642 2,052,000 42%926,313 2,136,767 43% Interfund Transfers 180,606 361,226 50%189,827 379,653 50% Capital Outlay - 8,500 0%- 8,500 0% Miscellaneous 69,847 - Expenses Total 3,917,631 8,331,744 47%3,880,255 8,657,612 45% 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 124,950 482,243 26%119,322 506,625 24% Expenses Total 124,950 482,243 26%119,322 506,625 24% 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 374,928 449,000 84%104,032 680,000 15% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget. Expenses Total 374,928 449,000 84%104,032 680,000 15% 200 MOTOR FUEL TAX FUND Revenue Intergovernmental Revenue 3,002,301 3,656,700 82%2,272,062 3,656,700 62% Interest Income 2,774 12,000 23%12,103 12,000 101% Revenue Total 3,005,075 3,668,700 82%2,284,164 3,668,700 62% Expenses Interfund Transfers 522,492 1,044,987 50%522,494 1,044,987 50% Services and Supplies 415,005 1,038,000 40%455,356 1,038,000 44% Capital Outlay 28,955 2,284,000 1%83,029 3,261,000 3% Expenses Total 966,452 4,366,987 22%1,060,878 5,343,987 20% 205 EMERGENCY TELEPHONE (E911) FUND Revenue Other Taxes 722,726 1,321,600 55%964,280 1,400,000 69% Interest Income 449 7,000 6%1,098 7,000 16% Other Revenue 266 - Revenue Total 723,442 1,328,600 54%965,379 1,407,000 69% Expenses Salary and Benefits 276,765 742,978 37%372,219 768,616 48% Services and Supplies 110,012 374,000 29%205,209 393,700 52% Interfund Transfers 45,000 90,000 50%45,000 90,000 50% Insurance and Other Chargebacks 9,114 18,230 50%9,115 18,230 50% Capital Outlay 7,796 299,163 3%35,188 450,000 8% Expenses Total 448,687 1,524,371 29%666,731 1,720,546 39% 210 SPECIAL SERVICE AREA (SSA) #9 Revenue Property Taxes 298,855 592,665 50%318,404 595,000 54% Interest Income 3 - 75 - Revenue Total 298,859 592,665 50%318,479 595,000 54% Expenses Services and Supplies 299,214 575,000 52%317,540 575,000 55% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget. Expenses Total 299,214 575,000 52%317,540 575,000 55% 215 CDBG FUND Revenue Intergovernmental Revenue 132,451 2,758,514 5%110,178 3,684,820 3% Interest Income 209 - Revenue Total 132,451 2,758,514 5%110,387 3,684,820 3% Expenses Community Sponsored Organizations 214,023 80,000 268%110,136 75,000 147% Salary and Benefits 179,446 319,997 56%184,940 589,422 31% Insurance and Other Chargebacks 138,009 150,000 92%127,975 - Capital Outlay 95,150 - Miscellaneous 7,427 1,700,000 0%7,486 2,515,000 0% Services and Supplies 4,785 506,200 1%7,189 506,200 1% Expenses Total 638,841 2,756,197 23%437,725 3,685,622 12% 220 CDBG LOAN FUND Revenue Other Revenue 55,535 110,000 50%65,703 100,000 66% Interest Income 504 - 689 - Revenue Total 56,038 110,000 51%66,392 100,000 66% Expenses Services and Supplies - 175,000 0%- 175,000 0% Miscellaneous - - Expenses Total - 175,000 0%- 175,000 0% 235 NEIGHBORHOOD IMPROVEMENT Revenue Interest Income 14 - 27 - Revenue Total 14 - 27 - Expenses Services and Supplies 7 - 5 - Expenses Total 7 - 5 - 240 HOME FUND Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget. Revenue Intergovernmental Revenue 169,758 540,453 31%222,190 540,453 41% Other Revenue 15,448 25,000 62%20,627 25,000 83% Interest Income 34 150 23%253 150 169% Revenue Total 185,239 565,603 33%243,070 565,603 43% Expenses Services and Supplies 215,492 500,565 43%246,002 500,565 49% Salary and Benefits 33,562 63,876 53%31,481 70,681 45% Miscellaneous - 500 0%- 500 0% Insurance and Other Chargebacks (431) - (6,853) - Expenses Total 248,622 564,941 44%270,631 571,746 47% 250 AFFORDABLE HOUSING FUND Revenue Intergovernmental Revenue 162,013 658,000 25%178,188 658,000 27% Other Revenue 64,167 175,600 37%65,417 140,600 47% Other Taxes 15,453 75,000 21%- 75,000 0% Interest Income 4,617 5,700 81%3,684 5,700 65% Revenue Total 246,250 914,300 27%247,290 879,300 28% Expenses Services and Supplies 716,300 2,031,050 35%43,705 2,065,050 2% Community Sponsored Organizations 162,013 166,000 98%169,810 166,000 102% Salary and Benefits 89,357 202,684 44%88,845 180,075 49% Miscellaneous 13,574 102,510 13%2,991 67,500 4% Capital Outlay 4,200 10,000 42%- 10,000 0% Insurance and Other Chargebacks (27,309) 17,000 -161%(18,000) 17,000 -106% Expenses Total 958,134 2,529,244 38%287,351 2,505,625 11% 320 DEBT SERVICE FUND Revenue Property Taxes 7,049,442 13,936,263 51%7,968,098 13,436,256 59% Interfund Transfers 598,710 1,197,401 50%1,133,520 2,267,041 50% Interest Income 4,654 1,500 310%13,261 1,500 884% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget. Other Revenue (1,060) - - - Revenue Total 7,651,746 15,135,164 51%9,114,879 15,704,797 58% Expenses Debt Service 2,935,212 15,133,666 19%2,853,260 15,690,075 18% Services and Supplies 15 - 3 - Miscellaneous 18,062 - Expenses Total 2,935,227 15,133,666 19%2,871,325 15,690,075 18% 330 HOWARD-RIDGE TIF FUND Revenue Property Taxes 670,975 968,000 69%678,179 1,100,000 62% Other Revenue 3,947 5,366 74%32,029 5,366 597% Interest Income 3,137 400 784%5,366 400 1342% Revenue Total 678,059 973,766 70%715,575 1,105,766 65% Expenses Services and Supplies 154,163 335,000 46%1,695 265,000 1% Interfund Transfers 109,056 218,113 50%199,056 398,113 50% Capital Outlay (9,750) 500,000 -2%- 785,000 0% Expenses Total 253,469 1,053,113 24%200,752 1,448,113 14% 335 WEST EVANSTON TIF FUND Revenue Property Taxes 869,944 1,237,000 70%995,438 1,450,000 69% Other Revenue 171,504 11,000 1559%- 11,000 0% Interest Income 2,391 4,000 60%6,465 4,000 162% Revenue Total 1,043,839 1,252,000 83%1,001,903 1,465,000 68% Expenses Interfund Transfers 37,500 75,000 50%37,500 75,000 50% Services and Supplies 436 5,000 9%6,008 5,000 120% Capital Outlay - 500,000 0%6,767 1,765,000 0% Miscellaneous - 200,000 0%- 200,000 0% Expenses Total 37,936 780,000 5%50,274 2,045,000 2% 340 DEMPSTER-DODGE TIF FUND Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget. Revenue Property Taxes 93,669 147,000 64%155,622 160,000 97% Interest Income 247 - 735 - Revenue Total 93,916 147,000 64%156,356 160,000 98% Expenses Interfund Transfers 84,462 168,923 50%85,916 171,833 50% Services and Supplies 333 2,000 17%26 2,000 1% Expenses Total 84,795 170,923 50%85,943 173,833 49% 345 CHICAGO-MAIN TIF Revenue Property Taxes 460,178 879,000 52%671,852 1,000,000 67% Interest Income 1,511 - 2,369 - Other Revenue - 1,130,000 0% Revenue Total 461,690 2,009,000 23%674,221 1,000,000 67% Expenses Interfund Transfers 131,424 262,843 50%132,381 264,763 50% Capital Outlay 116,567 1,130,000 10%44,838 1,090,000 4% Services and Supplies 342 5,000 7%31 5,000 1% Miscellaneous - 250,000 0% Expenses Total 248,333 1,397,843 18%177,250 1,609,763 11% 350 SPECIAL SERVICE AREA (SSA) #6 Revenue Property Taxes 5,264 221,000 2%122,429 221,000 55% Interest Income 6 500 1%180 - Revenue Total 5,270 221,500 2%122,609 221,000 55% Expenses Services and Supplies 7,548 221,500 3%- 221,000 0% Expenses Total 7,548 221,500 3%- 221,000 0% 355 SPECIAL SERVICE AREA (SSA) #7 Revenue Property Taxes 76,800 154,800 50%81,991 142,000 58% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget. Interest Income 70 - 168 - Revenue Total 76,870 154,800 50%82,159 142,000 58% Expenses Services and Supplies 73,741 115,000 64%77,075 140,000 55% Expenses Total 73,741 115,000 64%77,075 140,000 55% 360 SPECIAL SERVICE AREA (SSA) #8 Revenue Property Taxes 31,525 60,200 52%32,923 60,200 55% Interest Income 1 - 0 - Revenue Total 31,525 60,200 52%32,924 60,200 55% Expenses Services and Supplies 30,893 60,200 51%30,517 60,200 51% Expenses Total 30,893 60,200 51%30,517 60,200 51% 415 CAPITAL IMPROVEMENTS FUND Revenue Intergovernmental Revenue 329,333 - Charges for Services 24,913 - 9,837 - Interest Income 7,589 - 21,738 - Interfund Transfers 956,470 - Other Revenue (510) 7,645,000 0%572,853 12,253,000 5% Revenue Total 361,326 7,645,000 5%1,560,898 12,253,000 13% Expenses Capital Outlay 1,581,609 9,705,000 16%1,045,432 16,455,000 6% Services and Supplies 660,853 - 747,043 - Salary and Benefits 353,070 696,766 51%- - Miscellaneous 66,369 - Expenses Total 2,595,532 10,401,766 25%1,858,844 16,455,000 11% 416 CROWN CONSTRUCTION FUND Revenue Other Revenue 2,200,000 1,000,000 220%600,000 1,000,000 60% Intergovernmental Revenue 1,000,000 - Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget. Interest Income 5,618 - 13,400 - Revenue Total 3,205,618 1,000,000 321%613,400 1,000,000 61% Expenses Capital Outlay 66,905 1,000,000 7%2,255 800,000 0% Services and Supplies 6,299 - 17,780 - Interfund Transfers - 637,500 0%450,000 900,000 50% Expenses Total 73,204 1,637,500 4%470,035 1,700,000 28% 417 CROWN COMMUNITY CTR MAINTENANCE Revenue Interfund Transfers 87,498 175,000 50%87,500 175,000 50% Revenue Total 87,498 175,000 50%87,500 175,000 50% Expenses Capital Outlay 34,951 - Expenses Total 34,951 - 420 SPECIAL ASSESSMENT FUND Revenue Other Taxes 54,421 125,000 44%67,536 125,000 54% Interest Income 3,134 30,000 10%6,723 30,000 22% Revenue Total 57,555 155,000 37%74,259 155,000 48% Expenses Interfund Transfers 244,662 489,314 50%232,469 464,938 50% Services and Supplies 30 - 30 - Capital Outlay - 500,000 0%11,440 650,000 2% Expenses Total 244,692 989,314 25%243,939 1,114,938 22% 505 PARKING SYSTEM FUND Revenue Charges for Services 3,024,550 10,133,725 30%4,059,806 8,873,975 46% Other Revenue 216,582 1,404,700 15%149,768 486,700 31% Interest Income 13,493 20,000 67%10,312 20,000 52% Licenses, Permits and Fees 150 - 375 - Intergovernmental Revenue 1,150,000 2,300,000 50% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget. Revenue Total 3,254,775 11,558,425 28%5,370,260 11,680,675 46% Expenses Services and Supplies 1,856,394 4,484,316 41%1,928,170 4,550,316 42% Interfund Transfers 1,566,192 3,132,390 50%1,566,195 3,132,390 50% Salary and Benefits 759,093 1,435,962 53%686,458 1,637,273 42% Insurance and Other Chargebacks 175,752 351,502 50%175,751 351,502 50% Capital Outlay 108,783 1,750,000 6%343,264 2,025,000 17% Debt Service 28,215 47,164 60%18,950 72,900 26% Miscellaneous - 50,000 0%6,255 50,000 13% Expenses Total 4,494,429 11,251,334 40%4,725,042 11,819,381 40% 510 WATER FUND Revenue Charges for Services 9,450,925 23,006,700 41%10,403,630 23,443,200 44% Other Revenue 377,878 19,629,150 2%941,029 29,834,150 3% Licenses, Permits and Fees 49,452 50,000 99%40,780 50,000 82% Interest Income 30,112 70,000 43%55,002 70,000 79% Revenue Total 9,908,367 42,755,850 23%11,440,440 53,397,350 21% Expenses Salary and Benefits 2,905,361 5,927,918 49%2,829,931 6,004,605 47% Interfund Transfers 2,114,784 4,229,559 50%3,225,702 4,229,559 76% Debt Service 1,245,620 2,318,294 54%1,290,240 3,596,365 36% Services and Supplies 1,230,757 4,793,710 26%1,438,813 5,347,760 27% Insurance and Other Chargebacks 773,953 1,539,653 50%792,921 1,585,843 50% Miscellaneous 7,952 15,000 53%186,676 15,000 1245% Contingencies - 1,000 0%- 1,000 0% Capital Outlay - 24,200 0%27,749 164,400 17% Expenses Total 8,278,427 18,849,334 44%9,792,032 20,944,532 47% 513 WATER DEPR IMPRV &EXTENSION FUND Expenses Capital Outlay 2,907,278 24,068,000 12%6,759,402 33,036,000 20% Services and Supplies 145,137 1,500,000 10%307,526 3,465,000 9% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget. Interfund Transfers (1,110,923) - Expenses Total 3,052,415 25,568,000 12%5,956,005 36,501,000 16% 515 SEWER FUND Revenue Charges for Services 4,545,320 10,375,408 44%4,325,787 10,113,594 43% Interest Income 1,871 25,000 7%3,227 25,000 13% Other Revenue (2,700) 2,001,000 0%- 2,001,000 0% Revenue Total 4,544,491 12,401,408 37%4,329,015 12,139,594 36% Expenses Debt Service 2,849,130 5,195,191 55%1,791,865 3,772,691 47% Salary and Benefits 660,982 1,425,266 46%656,606 1,383,914 47% Interfund Transfers 427,692 855,375 50%435,582 871,164 50% Insurance and Other Chargebacks 166,128 332,255 50%176,095 352,190 50% Services and Supplies 160,887 1,484,650 11%206,104 1,471,800 14% Capital Outlay 109,988 3,343,000 3%- 3,538,100 0% Miscellaneous - 1,500 0%45,997 1,500 3066% Expenses Total 4,374,807 12,637,237 35%3,312,249 11,391,359 29% 520 SOLID WASTE FUND Revenue Charges for Services 2,045,818 4,516,450 45%2,204,255 4,516,450 49% Property Taxes 650,000 1,332,500 49%666,250 1,332,500 50% Licenses, Permits and Fees 124,714 297,000 42%176,901 297,000 60% Other Revenue 72,755 122,000 60%120,803 122,000 99% Revenue Total 2,893,287 6,267,950 46%3,168,209 6,267,950 51% Expenses Services and Supplies 1,632,009 3,778,926 43%1,685,356 3,786,776 45% Salary and Benefits 711,327 1,405,702 51%747,141 1,492,909 50% Capital Outlay 197,407 505,000 39%143,913 525,000 27% Interfund Transfers 151,002 302,000 50%607,470 302,000 201% Miscellaneous 7,409 10,000 74%8,790 15,000 59% Expenses Total 2,699,154 6,001,628 45%3,192,670 6,121,685 52% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget. 600 FLEET SERVICES FUND Revenue Charges for Services 1,553,718 3,127,440 50%1,553,720 3,127,440 50% Other Revenue 2,720 69,000 4%15,102 69,000 22% Interest Income - 1,000 0%- 1,000 0% Revenue Total 1,556,438 3,197,440 49%1,568,822 3,197,440 49% Expenses Services and Supplies 777,722 2,034,507 38%1,055,878 2,034,507 52% Salary and Benefits 561,102 1,148,166 49%587,450 1,276,621 46% Capital Outlay 19,924 - Insurance and Other Chargebacks 14,883 - 900 - Expenses Total 1,373,631 3,182,673 43%1,644,229 3,311,128 50% 601 EQUIPMENT REPLACEMENT FUND Revenue Charges for Services 112,434 224,885 50%112,442 224,885 50% Other Revenue 79,290 1,060,217 7%841,299 960,217 88% Interest Income 160 - Intergovernmental Revenue 800,000 1,600,000 50% Revenue Total 191,884 1,285,102 15%1,753,742 2,785,102 63% Expenses Capital Outlay 977,096 1,600,000 61%1,392,195 2,750,000 51% Services and Supplies 70 - Debt Service 8,188 - Expenses Total 977,166 1,600,000 61%1,400,383 2,750,000 51% 605 INSURANCE FUND Revenue Other Revenue 5,050,527 10,402,039 49%5,147,311 11,248,243 46% Insurance 4,481,587 8,890,677 50%4,525,191 8,827,914 51% Workers Compensation and Liability 729,576 1,475,000 49%376,651 825,000 46% Charges for Services 830 - 16,291 - Revenue Total 10,262,520 20,767,716 49%10,065,444 20,901,157 48% Funds 2021 Actual YTD 2021 Budget % of Budget 2022 Actual YTD 2022 Budget % of Budget. Expenses Insurance and Other Chargebacks 7,681,921 16,641,267 46%8,451,448 16,957,400 50% Services and Supplies 1,381,908 2,914,200 47%1,876,729 2,994,200 63% Salary and Benefits 321,227 662,620 48%59,318 4,751 1248% Expenses Total 9,385,055 20,218,087 46%10,387,495 19,956,351 52%