Page 93 - City of DWG FY 2022-23 BUDGET
P. 93
185 - CCPD FUND 2020-21 2021-22 2021-22 2022-23 Variance Variance
FY 22/23
VARIANCE % Proposed Proposed FY 22/23
Actual + % of Budget vs
Proposed Budget
Original mended YTD Actual + Proposed Budget vs
A
ACTUAL Projected vs Amended FY 21/22
Budget Budget Projected Budget FY 21/22 vs FY 21/22
Amended Budget Actual plus Actual + Amended Budget
Budget Projected
Account Number Account Description Projected
00.4030 Taxes:SalesTax-CrimeControl PD 276,653 267,167 267,167 293,023 25,856 110% 301,813 103% 8,791 34,646
Total Sales & Use Taxes $ 276,653 $ 267,167 267,167 $ 293,023 $ 25,856 110% $ 301,813 103% $ 8,791 $ 34,646
00.4800 Other Revenue: Interest on Invest 89 95 95 661 566 699% 750 113% 89 655
Total Other Revenue $ 89 $ 95 95 $ 661 $ 566 699% $ 750 113% $ 89 $ 655
00.4900 Transfer In - 10,000 20,000 65,872 45,872 659% 10,000 15% (55,872) (10,000)
Total Other Sources $ - $ 10,000 20,000 $ 65,872 $ 45,872 659% $ 10,000 15% $ (55,872) $ (10,000)
TOTAL REVENUE $ 276,742 $ 277,262 287,262 $ 359,555 $ 72,294 130% $ 312,563 87% $ (46,992) $ 25,302
50.6000 Personnel Salaries: Full Time 113,422 85,074 85,074 87,018 1,944 102% 92,483 106% 5,465 7,409
50.6020 Personnel Salaries: Overtime 11,921 11,190 11,190 15,409 4,219 138% 12,019 78% (3,390) 829
50.6036 Personnel: Supplements 5,749 5,300 5,300 4,885 (414) 92% 5,409 111% 524 109
50.6025 Personnel: SLBB - 393 393 - (393) 0% 357 0% 357 (36)
50.6050 Personnel: Longevity Service Pay - 943 943 943 - 100% 928 98% (15) (15)
Total Personnel Salary & Wages $ 131,092 $ 102,900 102,900 $ 108,256 $ 5,356 105% $ 111,197 103% $ 2,941 $ 8,297
50.6030 Personnel:FICA(SS) & MediCare 9,379 7,615 7,615 7,704 90 101% 8,229 107% 524 614
50.6031 Personnel:SUTA Taxes - 340 340 - (340) 0% 12 0% 12 (329)
50.6042 Personnel:ER-Life/AD&D Ins - 36 36 36 0 100% 35 96% (1) (1)
50-6045 Personnel:Cafeteria TMRS - 22,512 22,512 22,622 110 100% 24,458 108% 1,836 1,946
50.6046 Personnel:ER-LongTerm Disab - 288 288 288 (0) 100% 310 107% 21 21
50.6047 Personnel:Employee Health In - 15,289 15,289 15,225 (64) 100% 15,672 103% 447 383
50.6048 Personnel: Employer HSA - 3,418 3,418 5,060 1,642 148% 6,742 133% 1,682 3,324
50.6049 Personnel:ER-ShortTerm Disab - 219 219 219 0 100% 211 96% (8) (8)
Total Personnel Taxes & Benefits $ 9,379 $ 49,718 49,718 $ 51,155 $ 1,437 103% $ 55,668 109% $ 4,513 $ 5,950
50.6205 Mat/Supplies: Legal Notices - - - - - 0% - 0% - -
50.6270 Mat/Supplies: Emergency Equipment 56 9,500 18,962 - (18,962) 0% - 0% - (18,962)
Total Materials & Supplies $ 56 $ 9,500 18,962 $ - $ (18,962) 0% $ - 0% $ - $ (18,962)
50.7015 Consultants: Legal Regular - - - - - 0% - 0% - -
Total Consultants $ - $ - - $ - $ - 0% $ - 0% $ - $ -
50.7335 Contractual-Street Cameras - 5,000 5,000 5,000 - 100% 5,000 100% - -
Total Contractual $ - $ 5,000 5,000 $ 5,000 $ - 100% $ 5,000 100% $ - $ -
50.8085 Other:Interest on Cash Deficit - - - - - 0% - 0% - -
Total Other $ - $ - - $ - $ - 0% $ - 0% $ - $ -
50.9100 Capital Outlay:Vehicles - 108,000 251,545 334,865 83,320 310% 120,000 36% (214,865) (131,545)
50.9350 Capital Outlay:Equipment 21,820 24,822 24,822 36,962 12,140 149% - 0% (36,962) (24,822)
Total Capital Outlay $ 21,820 $ 132,822 276,367 $ 371,827 $ 95,460 280% $ 120,000 32% $ (251,827) $ (156,367)
50.9700 Transfer Out - - - - - 0% - 0% - -
Total Othe Uses $ - $ - - $ - $ - 0% $ - 0% $ - $ -
TOTAL EXPENDITURES $ 162,347 $ 299,940 452,947 $ 536,237 $ 83,290 179% $ 291,864 54% $ (244,373) $ (161,083)
Revenue Over/(Under) Expenditures $ 114,395 $ (22,678) (165,685) $ (176,682) $ (10,997) $ 20,699 $ 0 $ 197,381 $ 186,384