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
   88   89   90   91   92   93   94   95   96   97   98