Page 87 - DWGFY24AdoptedBudget
P. 87
185 - CCPD FUND 2021-22 2022-23 OCT-JUN JUL-SEP 2022-23 2023-24 Variance Variance
FY 23/24
% Proposed
VARIANCE Proposed FY 23/24
Original mended 9 mths 3 months YTD Actual + Actual + % of Proposed Budget vs Budget vs
A
Proposed Budget
ACTUAL Amended FY 22/23
Budget Budget Actual Projected Projected Projected vs Budget Budget Actual plus FY 22/23 vs FY 22/23
Amended Budget Projected Amended Budget
Actual +
Account Number Account Description Projected
00.4030 Taxes:SalesTax-CrimeControl PD 294,486 301,813 301,813 222,987 76,782 299,769 (2,044) 99% 299,770 100% 1 (2,044)
Total Sales & Use Taxes $ 294,486 $ 301,813 301,813 $ 222,987 $ 76,782 $ 299,769 $ (2,044) 99% $ 299,770 100% $ 1 $ (2,044)
00.4800 Other Revenue: Interest on Invest 821 750 750 5,627 1,800 7,427 6,677 990% 7,200 97% (227) 6,450
Total Other Revenue $ 821 $ 750 750 $ 5,627 $ 1,800 $ 7,427 $ 6,677 990% $ 7,200 97% $ (227) $ 6,450
00.4900 Transfer In 9,200 10,000 66,672 - 66,672 66,672 - 667% 10,000 15% (56,672) (56,672)
Total Other Sources $ 9,200 $ 10,000 66,672 $ - $ 66,672 $ 66,672 $ - 667% $ 10,000 15% $ (56,672) $ (56,672)
TOTAL REVENUE $ 304,507 $ 312,563 369,235 $ 228,614 $ 145,254 $ 373,868 $ 4,633 120% $ 316,970 85% $ (56,899) $ (52,266)
50.6000 Personnel Salaries: Full Time 87,428 92,483 92,483 69,001 24,521 93,522 1,038 101% 97,300 104% 3,778 4,816
50.6008 Personnel Salaries:Dispatch - - - - - - - 0% 42,141 0% 42,141 42,141
50.6009 Personnel Salaries:Dispatch Overtime - - - - - - - 0% 7,978 0% 7,978 7,978
50.6020 Personnel Salaries: Overtime 16,944 12,019 12,019 12,564 523 13,087 1,068 109% 12,545 96% (542) 527
50.6025 Personnel: SLBB - 357 357 1,760 - 1,760 1,402 493% 1,751 100% (9) 1,394
50.6036 Personnel: Supplements 4,880 5,409 5,409 3,761 3,293 7,054 1,645 130% 7,755 110% 701 2,346
50.6050 Personnel: Longevity Service Pay 943 928 928 1,008 - 1,008 79 109% 1,051 104% 43 122
Total Personnel Salary & Wages $ 110,195 $ 111,197 111,197 $ 88,093.34 $ 28,337 $ 116,430 $ 5,233 105% $ 170,521 146% $ 54,091 $ 59,324
50.6030 Personnel:FICA(SS) & MediCare 7,874 8,229 8,229 6,216 1,532 7,748 (481) 94% 12,619 163% 4,871 4,390
50.6031 Personnel:SUTA Taxes - 12 12 12 - 12 - 100% 21 177% 9 9
50.6042 Personnel:ER-Life/AD&D Ins 36 35 35 38 1,491 1,529 1,494 4357% 96 6% (1,434) 61
50-6045 Personnel:Cafeteria TMRS 24,484 24,458 24,458 19,292 1,759 21,051 (3,407) 86% 40,797 194% 19,746 16,339
50.6046 Personnel:ER-LongTerm Disab 288 310 310 179 28 206 (104) 67% 297 144% 91 (13)
50.6047 Personnel:Employee Health In 15,225 15,672 15,672 12,433 6,210 18,643 2,972 119% 30,895 166% 12,252 15,224
50.6048 Personnel: Employer HSA 5,060 6,742 6,742 4,668 579 5,247 (1,495) 78% 7,770 148% 2,523 1,028
50.6049 Personnel:ER-ShortTerm Disab 219 211 211 153 2,921 3,074 2,864 1460% 288 9% (2,787) 77
Total Personnel Taxes & Benefits $ 53,186 $ 55,668 55,668 $ 42,991 $ 14,520 $ 57,511 $ 1,843 103% $ 92,782 161% $ 35,272 $ 37,115
50.6205 Mat/Supplies: Legal Notices - - - - - - - 0% - 0% - -
50.6270 Mat/Supplies: Emergency Equipment - - 23,584 4,622 18,962 23,584 (0) 0% - 0% (23,584) (23,584)
Total Materials & Supplies $ - $ - 23,584 $ 4,622 $ 18,962 $ 23,584 $ (0) 0% $ - 0% $ (23,584) $ (23,584)
50.7015 Consultants: Legal Regular - - - - - - 0% - 0% - -
Total Consultants $ - $ - - $ - $ - $ - $ - 0% $ - 0% $ - $ -
50.7335 Contractual-Street Cameras - 5,000 5,000 - - - (5,000) 0% 14,000 0% 14,000 9,000
Total Contractual $ - $ 5,000 5,000 $ - $ - $ - $ (5,000) 0% $ 14,000 0% $ 14,000 $ 9,000
50.8085 Other:Interest on Cash Deficit - - - - - - 0% - 0% - -
Total Other $ - $ - - $ - $ - $ - $ - 0% $ - 0% $ - $ -
50.9100 Capital Outlay:Vehicles 36,269 120,000 420,514 140,374 159,240 299,614 (120,900) 250% 140,000 47% (159,614) (280,514)
50.9350 Capital Outlay:Equipment - - 18,000 - 25,000 25,000 7,000 0% - 0% (25,000) (18,000)
Total Capital Outlay $ 36,269 $ 120,000 438,514 $ 140,374 $ 184,240 $ 324,614 $ (113,900) 271% $ 140,000 43% $ (184,614) $ (298,514)
50.9700 Transfer Out - - - - - - - 0% - 0% - -
Total Othe Uses $ - $ - - - $ - $ - $ - 0% $ - 0% $ - $ -
TOTAL EXPENDITURES $ 199,650 $ 291,864 633,962 $ 276,080 $ 246,059 $ 522,139 $ (111,824) 179% $ 417,303 80% $ (104,835) $ (216,659)
Revenue Over/(Under) Expenditures $ 104,856 $ 20,699 (264,727) $ (47,466) $ (100,804) $ (148,270) $ 116,457 $ (100,334) $ 0 $ 47,936 $ 164,393
