Page 83 - CityofDalworthingtonGardensFY25AdoptedBudget
P. 83
185 - CCPD FUND 2022-23 2023-24 OCT-JUN JUL-SEP 2023-24 2024-25 Variance Variance
FY 24/25
VARIANCE % Proposed Proposed FY 24/25
Actual + % of Budget vs
Original mended 3 months YTD Actual + Proposed Budget vs
A
Proposed Budget
ACTUAL 9 mths Actual Projected vs Amended FY 23/24
Budget Budget Projected Projected Budget FY 23/24 vs FY 23/24
Amended Budget Actual plus Actual + Amended Budget
Budget Projected
Account Number Account Description Projected
00.4030 Taxes:SalesTax-CrimeControl PD 285,849 299,770 299,770 194,775 59,449 254,224 (45,546) 85% 254,355 100% 131 (45,415)
Total Sales & Use Taxes $ 285,849 $ 299,770 299,770 $ 194,775 $ 59,449 $ 254,224 $ (45,546) 85% $ 254,355 100% $ 131 $ (45,415)
00.4800 Other Revenue: Interest on Invest 7,719 7,200 7,200 5,167 1,200 6,367 (833) 88% 3,205 50% (3,162) (3,995)
Total Other Revenue $ 7,719 $ 7,200 7,200 $ 5,167 $ 1,200 $ 6,367 $ (833) 88% $ 3,205 50% $ (3,162) $ (3,995)
00.4900 Transfer In - 10,000 10,000 - 10,000 10,000 - 100% 10,000 100% - -
00.4955 Lease Proceeds 81,198 - - - - - 0% - 0% - -
Total Other Sources 81,198 10,000 10,000 - 10,000 10,000 - 100% $ 10,000 100% $ - $ -
TOTAL REVENUE $ 374,766 $ 316,970 316,970 $ 199,942 $ 70,649 $ 270,591 $ (46,378) 85% $ 267,560 99% $ (3,031) $ (49,410)
50.6000 Personnel Salaries: Full Time 93,223 97,300 97,300 70,864 25,869 96,734 (566) 99% 70,949 73% (25,785) (26,351)
50.6008 Personnel Salaries:Dispatch - 42,141 42,141 36,748 13,615 50,362 8,221 120% - 0% (50,362) (42,141)
50.6009 Personnel Salaries:Dispatch Overtime - 7,978 7,978 5,830 2,148 7,978 (0) 100% - 0% (7,978) (7,978)
50.6020 Personnel Salaries: Overtime 16,114 12,545 12,545 13,031 3,632 16,663 4,118 133% 9,359 56% (7,304) (3,186)
50.6025 Personnel: SLBB 1,760 1,751 1,751 2,724 - 2,724 972 156% 1,600 59% (1,124) (151)
50.6036 Personnel: Supplements 5,121 7,755 7,755 5,758 2,121 7,879 124 102% 4,165 53% (3,714) (3,590)
50.6050 Personnel: Longevity Service Pay 1,008 1,051 1,051 1,051 - 1,051 - 100% 805 77% (246) (246)
Total Personnel Salary & Wages $ 117,226 $ 170,521 170,521 $ 136,005 $ 47,385 $ 183,391 $ 12,869 108% $ 86,877 47% $ (96,513) $ (83,644)
50.6030 Personnel:FICA(SS) & MediCare 8,263 12,619 12,619 9,720 3,345 13,065 446 104% 6,429 49% (6,636) (6,190)
50.6031 Personnel:SUTA Taxes 12 21 21 152 - 152 131 735% 111 73% (41) 90
50.6042 Personnel:ER-Life/AD&D Ins 53 96 96 77 26 103 8 108% 43 41% (61) (53)
50-6045 Personnel:Cafeteria TMRS 25,782 40,797 40,797 31,576 11,245 42,821 2,023 105% 20,825 49% (21,996) (19,973)
50.6046 Personnel:ER-LongTerm Disab 232 297 297 246 82 328 31 111% 166 51% (162) (131)
50.6047 Personnel:Employee Health In 16,790 30,895 30,895 24,681 8,899 33,580 2,685 109% 18,930 56% (14,650) (11,965)
50.6048 Personnel: Employer HSA 6,307 7,770 7,770 3,427 894 4,322 (3,449) 56% 2,712 63% (1,610) (5,059)
50.6049 Personnel:ER-ShortTerm Disab 203 288 288 244 82 326 38 113% 146 45% (180) (141)
Total Personnel Taxes & Benefits $ 57,641 $ 92,782 92,782 $ 70,124 $ 24,572 $ 94,696 $ 1,914 102% $ 49,361 52% $ (45,335) $ (43,421)
50.6205 Mat/Supplies: Legal Notices - - - - - - - 0% - 0% - -
50.6270 Mat/Supplies: Emergency Equipment 4,622 - - - 34,647 34,647 34,647 0% - 0% (34,647) -
Total Materials & Supplies $ 4,622 $ - - $ - $ 34,647 $ 34,647 $ 34,647 0% $ - 0% $ (34,647) $ -
50.7015 Consultants: Legal Regular - - - - - - - 0% - 0% - -
Total Consultants $ - $ - - $ - $ - $ - $ - 0% $ - 0% $ - $ -
50.7335 Contractual-Street Cameras - 14,000 14,000 10,950 - 10,950 (3,050) 78% 16,300 149% 5,350 2,300
Total Contractual $ - $ 14,000 14,000 $ 10,950 $ - $ 10,950 $ (3,050) 78% $ 16,300 149% $ 5,350 $ 2,300
50.8085 Other:Interest on Cash Deficit 2 - - - - - - 0% - 0% - -
50.8090 Other:Leases-Principal 19,248 - - 13,487 - 13,487 13,487 0% 14,741 109% 1,254 14,741
50.8091 Other:Leases-Interest - - - 5,761 - 5,761 5,761 0% 4,507 78% (1,254) 4,507
Total Other 19,250 - - 19,248 - 19,248 19,248 0% 19,248 100% $ - $ 19,248
50.9100 Capital Outlay:Vehicles 140,374 140,000 202,208 60,379 90,000 150,379 (51,829) 107% 90,000 60% (60,379) (112,208)
50.9350 Capital Outlay:Equipment - - - - - 0% - 0% - -
50.9400 Capital Outlay:Leases 90,370 - - - - 0% - 0% - -
Total Capital Outlay $ 230,744 $ 140,000 202,208 $ 60,379 $ 90,000 $ 150,379 $ (51,829) 107% $ 90,000 60% $ (60,379) $ (112,208)
50.9700 Transfer Out - - - - - - - 0% - 0% - -
Total Othe Uses $ - $ - - - $ - $ - $ - 0% $ - 0% $ - $ -
TOTAL EXPENDITURES 429,484 $ 417,303 479,511 $ 296,706 $ 196,605 $ 493,311 $ 13,800 118% $ 261,787 53% $ (231,524) $ (217,725)
Revenue Over/(Under) Expenditures $ (54,718) $ (100,334) (162,542) $ (96,764) $ (125,956) $ (222,720) $ (60,178) $ 5,773 $ 0 $ 228,493 $ 168,315
