|
Plus/ (Minus)Ending Variance
<br />1/1 Beginning 2023 YTD 2023 YTD Accrual Surplus Cash Balance Cash Reserve Above/(Below)
<br />Enterprise Funds Cash Balance Revenue Expenditures Adjustments (Deficit)12/31/2023 Requirement Reserve Req.
<br />600 Consolidated Building 2,112,163.65 2,148,665.91 2,175,719.60 5,492.51 (21,561.18)2,090,602.47 543,929.90 1,546,672.57
<br />601 Parking Garages 864,960.88 932,779.69 1,253,861.76 16,108.74 (304,973.33)559,987.55 313,465.44 246,522.11
<br />602 Morris Performing Arts Center Operations 435,479.03 882,667.56 1,390,779.90 461,240.25 (46,872.09)388,606.94 139,077.99 249,528.95
<br />610 Solid Waste Operations 294,832.02 8,224,054.64 7,503,159.22 (138,452.85)582,442.57 877,274.59 750,315.92 126,958.67
<br />611 Solid Waste Capital 1,582,026.77 901,599.27 900,883.76 -715.51 1,582,742.28 - -
<br />620 Water Works Operations 4,758,782.95 22,183,456.79 18,861,893.93 (146,946.22)3,174,616.64 7,933,399.59 943,094.70 6,990,304.89
<br />622 Water Works Capital 11,059,854.29 96,489.30 4,237,906.91 (293,707.83)(4,435,125.44)6,624,728.85 - -
<br />624 Water Works Customer Deposit 1,315,511.44 32,979.43 -(4,117.39)28,862.04 1,344,373.48 1,344,373.48 -
<br />625 Water Works Sinking (Debt Service)2,273,787.36 2,790,130.46 1,401,674.98 (10,636.70)1,377,818.78 3,651,606.14 - 3,651,606.14
<br />626 Water Works Bond Reserve 1,432,109.47 36,636.60 -3,530.19 40,166.79 1,472,276.26 1,472,276.26 -
<br />629 Water Works Operations & Maintenance Reserve 2,946,775.39 74,062.14 -7,441.21 81,503.35 3,028,278.74 3,144,277.72 (115,998.98)
<br />640 Sewer Repair Insurance 1,951,962.78 757,025.93 917,061.67 13,601.11 (146,434.63)1,805,528.15 229,265.42 1,576,262.73
<br />641 Sewage Works Operations 13,821,062.52 43,361,031.20 36,921,307.89 (273,582.97)6,166,140.34 19,987,202.86 1,846,065.39 18,141,137.47
<br />642 Sewage Works Capital 15,204,814.68 691,587.84 3,265,885.44 51,093.00 (2,523,204.60)12,681,610.08 - 12,681,610.08
<br />643 Sewage Works Operations & Maintenance Reserve 5,586,493.45 140,406.90 -14,107.04 154,513.94 5,741,007.39 6,154,782.03 (413,774.64)
<br />649 Sewage Sinking (Debt Service)3,631,819.04 9,864,622.08 6,100,100.82 4,508.24 3,769,029.50 7,400,848.54 - 7,400,848.54
<br />653 Sewage Debt Service Reserve 3,773,871.30 94,849.76 -9,529.79 104,379.55 3,878,250.85 3,878,250.85 -
<br />654 Sewage Works Customer Deposit 1,185,441.52 31,772.81 -138,190.01 169,962.82 1,355,404.34 1,355,404.34 -
<br />667 Storm Sewer 1,285,692.83 1,390,709.73 676,423.20 155,347.76 869,634.29 2,155,327.12 - 2,155,327.12
<br />670 Century Center 945,928.24 4,232,734.60 4,576,738.32 (639,799.09)(983,802.81)(37,874.57)1,144,184.58 (1,182,059.15)
<br />671 Century Center Capital 986,966.11 523,877.91 415,616.64 2,492.13 110,753.40 1,097,719.51 800,000.00 297,719.51
<br /> Total Enterprise Funds $77,450,335.72 $99,392,140.55 $90,599,014.04 ($624,561.07)$8,168,565.44 $85,618,901.16 $24,058,764.01 $53,352,666.02
<br />Internal Service Funds
<br />222 Central Services 305,778.14 9,132,417.20 10,085,905.09 17,792.07 (935,695.82)(629,917.68)1,008,590.51 (1,638,508.19)
<br />226 Liability Insurance 5,760,772.80 3,925,455.34 3,021,317.47 (499,514.67)404,623.20 6,165,396.00 1,510,658.74 4,654,737.27
<br />278 Take Home Vehicle Police 750,477.36 79,031.71 1,040.27 1,895.13 79,886.57 830,363.93 750,000.00 80,363.93
<br />279 IT / Innovation / 311 Call Center 4,698,328.43 9,409,653.33 9,426,437.59 (28,271.72)(45,055.98)4,653,272.45 - -
<br />711 Self-Funded Employee Benefits 10,708,563.15 18,154,703.98 19,237,372.90 (35,585.11)(1,118,254.03)9,590,309.12 4,809,343.23 4,780,965.90
<br />713 Unemployment Compensation 77,878.33 10,255.24 77,692.96 35,171.65 (32,266.07)45,612.26 19,423.24 26,189.02
<br />714 Parental Leave 410,517.25 296,420.95 83,395.63 1,036.74 214,062.06 624,579.31 6,671.65 617,907.66
<br /> Total Internal Service Funds $22,712,315.46 $41,007,937.75 $41,933,161.91 ($507,475.91)($1,432,700.07)$21,279,615.39 $8,104,687.36 $8,521,655.58
<br />Fiduciary Funds
<br />701 Fire Pension 360,077.71 4,070,522.56 4,043,751.20 907.65 27,679.01 387,756.72 404,375.12 (16,618.40)
<br />702 Police Pension 616,514.83 5,995,004.21 6,115,326.23 1,554.54 (118,767.48)497,747.35 611,532.62 (113,785.27)
<br />709 Payroll Clearing ---(14,841.85)(14,841.85)(14,841.85)- -
<br />718 State Tax Withholding Fund 351,228.03 --(28,480.58)(28,480.58)322,747.45 322,747.45 -
<br />726 Police Distributions Payable 1,048,916.01 --(64,950.49)(64,950.49)983,965.52 983,965.52 -
<br />Total Fiduciary Funds $2,376,736.58 $10,065,526.77 $10,159,077.43 ($105,810.73)($199,361.39)$2,177,375.19 $2,322,620.71 ($130,403.67)
<br />Total City Controlled Funds $316,420,312.60 $361,840,126.75 $375,977,661.78 ($7,033,984.75)($21,171,519.78)$ 295,248,792.82 $ 111,747,406.92 $ 139,720,229.01
<br />Redevelopment Commission Controlled Funds
<br />Tax Increment Financing Funds
<br />324 TIF - River West Development Area 35,127,336.20 21,292,504.62 21,959,245.39 301,145.22 (365,595.55)34,761,740.65 - -
<br />422 TIF - West Washington 1,443,740.14 529,432.29 99,745.33 3,248.44 432,935.40 1,876,675.54 - -
<br />429 TIF - River East Development Area (NE Dev)11,899,914.41 6,530,161.07 3,603,824.37 (13,080.76)2,913,255.94 14,813,170.35 - -
<br />430 TIF - Southside Development Area #1 15,162,731.64 4,005,992.98 6,447,976.57 30,001.79 (2,411,981.80)12,750,749.84 - -
<br />435 TIF - Douglas Road 357,934.03 243,948.89 -615.70 244,564.59 602,498.62 - -
<br />436 TIF - River East Residential Area (NE Res)6,838,774.53 7,363,125.89 5,236,835.02 37,464.20 2,163,755.07 9,002,529.60 - -
<br />Total Tax Increment Financing Funds $70,830,430.95 $39,965,165.74 $37,347,626.68 $359,394.59 $2,976,933.65 $73,807,364.60 --
<br />Redevelopment Funds
<br />433 Redevelopment General 3,754,261.07 1,830,992.60 2,170,908.58 10,979.97 (328,936.01)3,425,325.06 542,727.15 2,882,597.92
<br />439 Certified Technology Park 11,263.77 283.09 -28.45 311.54 11,575.31 - 11,575.31
<br />452 2018 TIF Park Bond Capital 2,302,851.06 57,792.44 7,480.00 5,814.55 56,126.99 2,358,978.05 - 2,358,978.05
<br />454 Airport Urban Enterprise Zone 414,758.14 10,424.24 -1,047.35 11,471.59 426,229.73 - 426,229.73
<br />Total Redevelopment Funds $6,483,134.04 $1,899,492.37 $2,178,388.58 $17,870.32 ($261,025.89)$6,222,108.15 $542,727.15 $5,679,381.01
<br />Debt Service Funds
<br />315 Airport 2003 Debt Reserve 1,047,152.50 26,318.38 -2,644.27 28,962.65 1,076,115.15 1,076,115.15 -
<br />328 SBCDA 2003 Debt Reserve 1,750,679.96 44,000.34 -4,420.82 48,421.16 1,799,101.12 1,799,101.12 -
<br />351 2018 TIF Park Bond Debt Service Reserve 1,046,766.16 26,308.67 -2,643.30 28,951.97 1,075,718.13 1,075,718.13 -
<br />352 2019 South Shore Double Tracking Debt Service 14,695.68 1,035,503.20 1,030,125.00 -5,378.20 20,073.88 - 20,073.88
<br />353 2020 TIF Library Bond Debt Service Reserve 326,944.35 15.00 8.24 -6.76 326,951.11 326,951.11 -
<br />Total Debt Service Funds $4,186,238.65 $1,132,145.59 $1,030,133.24 $9,708.39 $111,720.74 $4,297,959.39 $4,277,885.51 $20,073.88
<br />Total Redevelopment Commission Funds $81,499,803.64 $42,996,803.70 $40,556,148.50 $386,973.30 $2,827,628.50 $84,327,432.14 $4,820,612.66 $5,699,454.89
<br />Grand Total $397,920,116.24 $404,836,930.45 $416,533,810.28 ($6,647,011.45)($18,343,891.28)$379,576,224.96 $116,568,019.57 $145,419,683.90
|