142 - CIP FUND-City Hall CIP FUND-City Hall Year to Date BUDGET VS. ACTUAL REPORT (BAR) FY 2023-24 FY 2023-24 OVR/(UNDER) % OF BUDGET YTD Ending December 31, 2023 BUDGET YTD BUDGET YTD Other Revenue 10,000 4,038 (5,962) 40.4% Other Financing Sources 10,200 5,373 (4,827) 52.7% TOTAL REVENUES $ 20,200 $ 9,411 $ (10,789) 46.6% Material & Supplies 0.0% Projects 840,616 2,400 (838,216) 0.3% Maintenance 0.0% Capital Outlay 60,000 (60,000) 0.0% Other Financing Uses 0.0% TOTAL EXPENDITURES $ 900,616 $ 2,400 $ (898,216) 0.3% Revenue Over/(Under) Expenditures $ (880,416) $ 7,011 $ 887,427 CIP FUND-City Hall CURRENT MONTH BUDGET VS. ACTUAL REPORT (BAR) BUDGET ACTUAL OVR/(UNDER) % OF BUDGET Month Ending December. 31, 2023 DEC DEC BUDGET DEC Other Revenue 1,500 1,341 (159) 89.4% Other Financing Sources 1,700 1,816 116 106.8% TOTAL REVENUES $ 3,200 $ 3,157 $ (43) 98.7% Material & Supplies 0.0% Projects 2,400 2,400 0.0% Maintenance 0.0% Capital Outlay 0.0% Other Financing Uses 0.0% TOTAL EXPENDITURES $ $ 2,400 $ 2,400 0.0% Revenue Over/(Under) Expenditures $ 3,200 $ 757 $ (2,443) Note: Funding Sources 2017 Bond proceeds ARPA funds $75K from General Fund 01/18/2024 Page 34 of 47 e / 5 143 - Street Sales Tax Fund Street Sales Tax Fund Year to Date BUDGET VS. ACTUAL REPORT (BAR) FY 2023-24 FY 2023-24 OVR/(UNDER) % OF BUDGET YTD Ending December 31, 2023 BUDGET YTD BUDGET YTD Taxes 151,083 34,096 (116,988) 22.6% Other Revenue 6,861 2,649 (4,212) 38.6% Other Financing Sources 0.0% TOTAL REVENUES $ 157,945 $ 36,745 $ (121,200) 23.3% Maintenance 40,000 3,971 (36,029) 9.9% Consultants 0.0% Capital Outlay 74,806 36,852 (37,954) 49.3% Other Financing Uses 0.0% TOTAL EXPENDITURES $ 114,806 $ 40,822 $ (73,983) 35.6% Revenue Over/(Under) Expenditures $ 43,139 $ (4,077) $ (47,216) Street Sales Tax Fund CURRENT MONTH BUDGET VS. ACTUAL REPORT (BAR) BUDGET ACTUAL OVR/(UNDER) % OF BUDGET Month Ending December 31, 2023 DEC DEC BUDGET DEC Taxes 11,809 11,143 (666) 94.4% Other Revenue 517 847 330 164.0% Other Financing Sources 0.0% TOTAL REVENUES $ 12,326 $ 11,990 $ (336) 97.3% Maintenance 3,971 3,971 0.0% Consultants 0.0% Capital Outlay 26,581 8,658 (17,923) 32.6% Other Financing Uses 0.0% TOTAL EXPENDITURES $ 26,581 $ 12,628 $ (13,953) 47.5% Revenue Over/(Under) Expenditures $ (14,255) $ (638) $ 13,617 01/18/2024 Page 36 of 47 150 - DEBT SERVICE FUND DEBT SERVICE FUND Year to Date BUDGET VS. ACTUAL REPORT (BAR) FY 2023-24 FY 2023-24 OVR/(UNDER) % OF BUDGET YTD Ending December. 31, 2023 BUDGET YTD BUDGET YTD Taxes 357,659 171,816 (185,843) 48.0% Other Revenue 7,404 1,084 (6,319) 14.6% Other Sources 0.0% TOTAL REVENUES $ 365,063 $ 172,900 $ (192,163) 47.4% Debt Service 361,919 (361,919) 0.0% Other 3,000 (3,000) 0.0% TOTAL EXPENDITURES $ 364,919 $ $ (364,919) 0.0% Revenue Over/(Under) Expenditures $ 144 $ 172,900 $ 172,756 DEBT SERVICE FUND CURRENT MONTH BUDGET VS. ACTUAL REPORT (BAR) BUDGET ACTUAL OVR/(UNDER) % OF BUDGET Month Ending December. 31, 2023 DEC DEC BUDGET DEC Taxes 150,363 129,648 (20,715) 86.2% Other Revenue 1,136 503 (632) 44.3% Other Sources 0.0% TOTAL REVENUES $ 151,498 $ 130,152 $ (21,347) 85.9% Debt Service 0.0% Other 0.0% TOTAL EXPENDITURES $ $ $ 0.0% Revenue Over/(Under) Expenditures $ 151,498 $ 130,152 $ (21,347) 01/18/2024 Page 38 of 47 180 - PRFDC FUND Parks & Rec. Facilities Development Corp Year to Date (PRFDC) Fund BUDGET VS. ACTUAL REPORT (BAR) FY 2023-24 FY 2023-24 OVR/(UNDER) % OF BUDGET YTD Ending December. 31, 2023 BUDGET YTD BUDGET YTD Taxes 151,083 34,096 (116,988) 22.6% Charges for Service 1,500 120 (1,380) 8.0% Other Revenue 22,100 5,643 (16,457) 25.5% Other Financing Sources 0.0% TOTAL REVENUES $ 174,683 $ 39,859 $ (134,825) 22.8% Salary & Wages 53,527 8,247 (45,280) 15.4% Taxes & Benefits 23,635 3,861 (19,774) 16.3% Training 190 14 (175) 7.5% Materials & Supplies 6,255 1,291 (4,964) 20.6% Utilities 7,237 1,213 (6,024) 16.8% Maintenance 16,446 595 (15,851) 3.6% Consultants 2,000 (2,000) 0.0% Contractual 6,777 1,105 (5,672) 16.3% Other 13,415 590 (12,825) 4.4% Capital Outlay 1,650 1,650 0.0% Transfer Out 0.0% TOTAL EXPENDITURES $ 129,482 $ 18,566 $ (110,916) 14.3% Revenue Over/(Under) Expenditures $ 45,201 $ 21,292 $ (23,909) Parks & Rec. Facilities Development Corp CURRENT MONTH (PRFDC) Fund BUDGET VS. ACTUAL REPORT (BAR) BUDGET ACTUAL OVR/(UNDER) % OF BUDGET Month Ending December. 31, 2023 DEC DEC BUDGET DEC Taxes 11,809 11,143 (666) 94.4% Charges for Service 125 (125) 0.0% Other Revenue 1,842 1,938 96 105.2% Other Sources 0.0% TOTALI REVENUES $ 13,776 $ 13,081 $ (695) 95.0% Salary & Wages 3,555 2,462 (1,093) 69.3% Taxes & Benefits 1,841 1,064 (777) 57.8% Training 16 14 (2) 89.9% Materials & Supplies 1,625 9 (1,616) 0.5% Utilities 522 324 (199) 62.0% Maintenance 933 (933) 0.0% Consultants 167 (167) 0.0% Contractual 55 55 100.0% Other 1,126 292 (834) 26.0% Capital Outlay 0.0% Transfer Out 0.0% TOTAL EXPENDITURES $ 9,840 $ 4,220 $ (5,620) 42.9% Revenue Over/(Under) Expenditures $ 3,936 $ 8,861 $ 4,925 01/18/2024 Page 40 of 47 3 - V W / 2 - e - 3 4E 4 - 41 E a - - 4 L a 6 5 8 N E 6 E 3 a 5 LA L E 8 a 8 9 8 14 00 9 - ? 1 1 8 8 9? 8 3 8 4 E 2 9 - 9 B 2 9 5 8 3 A - N 9 8 9 8 W 3 8 9 8 9 a 8 E S € 185 - CCPD FUND Crime Control & Prevention District Year to Date (CCPD) Fund BUDGET VS. ACTUAL REPORT (BAR) FY 2023-24 FY: 2023-24 OVR/(UNDER) % OF BUDGET YTD Ending December. 31, 2023 BUDGET YTD BUDGET YTD Taxes 299,770 67,912 (231,857) 22.7% Other Revenue 7,200 2,271 (4,929) 31.5% Other Sources 10,000 (10,000) 0.0% TOTAL REVENUES $ 316,970 $ 70,183 $ (246,786) 22.1% Salary & Wages 170,521 45,620 (124,901) 26.8% Taxes & Benefits 92,782 22,126 (70,656) 23.8% Materials & Supplies 0.0% Consultants 0.0% Contractual 14,000 (14,000) 0.0% Other 0.0% Capital 202,208 20,993 (181,215) 10.4% TOTAL EXPENDITURES $ 479,511 $ 88,739 $ (390,772) 18.5% Revenue Over/(Under) Expenditures $ (162,542) $ (18,556) $ 143,986 Crime Control & Prevention District CURRENT MONTH (CCPD) Fund BUDGET VS. ACTUAL REPORT (BAR) BUDGET ACTUAL OVR/(UNDER) % OF BUDGET Month Ending December 31, 2023 DEC DEC BUDGET DEC Taxes 23,526 22,252 (1,274) 94.6% Other Revenue 600 765 165 127.4% Other Sources 5,000 (5,000) 0.0% TOTAL REVENUES $ 29,126 $ 23,017 $ (6,110) 79.0% Salary & Wages 14,653 16,616 1,964 113.4% Taxes & Benefits 7,388 7,783 396 105.4% Materials & Supplies 0.0% Consultants 0.0% Contractual 0.0% Other 0.0% Capital 20,736 20,993 257 101.2% TOTAL EXPENDITURES $ 42,776 $ 45,392 $ 2,616 106.1% Revenue Over/Under) Expenditures $ (13,650) $ (22,376) $ (8,726) 01/18/2024 Page 44 of 47 00 3 3 E a 207 - VOL FIRE DONATION FUND VOLI FIRE DONATION FUND Year to Date BUDGET VS. ACTUAL REPORT (BAR) FY 2023-24 FY 2023-24 OVR/(UNDER) % OF BUDGET YTD Ending December 31, 2023 BUDGET YTD BUDGET YTD Other Revenue 4,000 972 (3,028) 24.3% TOTAL REVENUES $ 4,000 $ 972 $ (3,028) 24.3% Materials & Supplies 0.0% Other Uses 0.0% TOTAL EXPENDITURES $ $ $ 0.0% Revenue Over/(Under) Expenditures $ 4,000 $ 972 $ (3,028) VOLI FIRE DONATION FUND CURRENT MONTH BUDGET VS. ACTUAL REPORT (BAR) BUDGET ACTUAL OVR/(UNDER) % OF BUDGET Month Ending December 31, 2023 DEC DEC BUDGET DEC Other Revenue 333 326 (8) 97.7% TOTAL REVENUES $ 333 $ 326 $ (8) 97.7% Materials & Supplies 0.0% Other Uses 0.0% TOTAL EXPENDITURES $ $ $ 0.0% Revenue Over/(Under) Expenditures $ 333 $ 326 $ (8) 01/18/2024 Page 46 of 47 - - B : d Dalworthingion CITY OF DALWORTHINGTON GARDENS PG Gardens Number of YTD YTD Permits Issued OCT 2022 NOV 2022 DEC 2022 Fiscal 22-23 OCT2 2023 NOV: 2023 DEC: 2023 Fiscal 23-24 Alarm System 1 0 1 2 0 1 I 2 Backflow 1 0 0 3 0 0 3 Building 7 5 2 14 6 3 4 13 Cert. of Occupancy 4 3 8 7 7 4 18 Electrical 2 0 6 8 1 2 0 3 Fence 2 2 ) 4 0 0 1 Heating/AC 1 2 3 1 2 0 3 Liquor U U 0 Misc.-Other U 2 2 0 0 0 Operational 0 0 J Plumbing 3 2 4 0 2 3 5 Red Tag 1 Roof L 1 Fire Alarm/Suppression 0 0 Sign 0 2 0 2 Special Use 0 0 0 U 0 0 Sprinkler System 0 0 1 0 1 Swimming Pool 0 0 0 0 0 0 0 0 Permit Subtotal 19 16 22 57 21 19 14 54 Life Safety Inspections 0 0 2 2 0 1 0 1 Totals 19 16 24 59 21 20 14 55 Fees of YTD YTD Permits Issued OCT 2022 NOV 2022 DEC 2022 Fiscal 22-23 OCT 2023 NOV 2023 DEC: 2023 Fiscal 23-24 Alarm System $ 10 $ $ 10 $ 20.00 $ $ 10 $ 10 $ 20 Backflow $ 35 $ $ $ 35.00 $ 105 $ $ $ 105 Building $ 2,659 $ 6,626 $ 400 $ 9,684.95 $ 4,455 $ 21,586 $ 2,460 $ 28,501 Cert. of Occupancy $ 100 $ 400 $ 300 $ 800.00 $ 700 $ 700 $ 400 $ 1,800 Electrical $ 240 $ $ 1,040 $ 1,280.00 $ 341 $ 320 $ $ 661 Fence $ 150 $ 1,571 $ $ 1,721.18 $ $ 200 $ $ 200 Heating/AC $ 120 $ $ 240 $ 360.00 $ 120 $ 591 $ $ 711 Liquor $ $ $ $ $ $ $ $ Misc.-Other $ $ 125 $ $ 125.00 $ $ $ $ Operational $ $ $ $ $ $ $ $ Plumbing $ 440 $ 165 $ 410 $ 1,015.00 $ $ 240 $ 285 $ 525 Red Tag $ $ 100 $ $ 100.00 $ $ $ 100 $ 100 Roof $ $ $ 400 $ 400.00 $ $ $ 200 $ 200 Fire Alarm/Suppression $ $ $ $ $ 600 $ $ $ 600 Sign $ 200 $ $ 200 $ 400.00 $ 200 $ 200 $ $ 400 Special Use $ $ $ $ $ $ $ $ Sprinkler System $ $ $ 870 $ 870.00 $ 200 $ $ $ 200 Swimming Pool $ $ $ $ $ $ $ $ Permit Subtotal $ 3,954 $ 8,988 $ 3,870 $ 16,811 $ 6,721 $ 23,847 $ 3,455 $ 34,023 Life Safety Inspections $ $ $ 260 $ 260.00 $ $ 130 $ $ 130 Total $ 3,954 $ 8,988 $ 4,130 $ 17,071 $ 6,721 $ 23,977 $ 3,455 $ 34,153 Billed Usage OCT 2022 NOV 2022 DEC. 2022 Fiscal 22-23 OCT: 2023 NOV 2023 DEC: 2023 Fiscal 23-24 Water Gallons 25,542,199 19,507,523 8,078,715 53,128,437 19,538,828 11,886,984 10,524,036 41,949,848 Sewer Gallons 10,532,345 10,832,128 6,196,132 27,560,605 9,159,913 7,480,854 7,315,884 23,956,651