Page 45 - City of Westworth Village FY22 Budget
P. 45

45




             Water Fund Detail
                                                  Actual     Actual      Actual    Adopted   Projected  Proposed
                ACCT                               2018       2019       2020       2021       2021      2022
                                                       Water Fund Revenue
                        Additional Revenue
             02-500-525011 Interest Earned      $             1,249  $            1,919  $                 765  $           1,600  $             500  $           1,000
                        Total Additional Revenue  $            1,249  $           1,919  $                765  $          1,600  $             500  $          1,000

                        Miscellaneous Revenue
             02-500-565012 Miscellaneous Revenue  $                549  $              652  $              1,712  $             500  $             500  $             500
             02-500-565038 Return Check Charge  $                  60  $                60  $                   30  $             100  $             100  $             100
             02-500-565050 Water turn on Fees   $             4,335  $            6,105  $              3,890  $           4,500  $           4,500  $           4,500
             02-500-565051 Late Fees            $            14,346  $          13,347  $             13,458  $         12,500  $         18,000  $         12,500
             02-500-565052 Water/Sewer Setup Fees  $            79,239  $          69,281  $             45,535  $         45,000  $         45,000  $         45,000
             02-500-565055 Water Revenue        $          649,127  $        631,886  $           625,661  $       580,000  $       586,784  $       598,520
             02-500-565056 Sewer Revenue        $          498,637  $        490,172  $           481,888  $       505,000  $       517,330  $       594,929
             02-500-565057 Sanitation Revenue   $          130,733  $        138,778  $           146,714  $       138,000  $       148,954  $       148,800
             02-500-565059 Storm Sewer Fees     $            78,778  $          81,676  $             83,372  $       170,000  $       169,424  $       170,000
             02-500-XXXXX CLFRF Grant Funding                                               $       341,573  $       341,573
                        Total Miscellaneous Revenue   $     1,455,804  $    1,431,956  $      1,402,261  $   1,455,600  $   1,832,164  $   1,916,422

             Total Water Revenue                $     1,457,053 $    1,433,875 $      1,403,026 $   1,457,200 $   1,832,664 $   1,917,422
                                                      Water Fund Expenses
                                                          Water Fund

                        Payroll
             02-620-610001 Salaries             $            86,715  $          89,614  $             82,673  $       116,749  $       163,244  $       125,061
             02-620-610002 TMRS Retirement      $            11,094  $          10,910  $              9,171  $         14,577  $         24,491  $         16,251
             02-620-610003 Workers compensation  $                451  $              505  $                 363  $           2,550  $             598  $           2,678
             02-620-610004 Unemployement Comp   $                502  $              389  $                 115  $             432  $             753  $             432
             02-620-610005 Group Health Insurance  $             6,591  $          11,858  $             17,968  $         25,200  $         30,686  $         26,100
             02-620-610006 Medicare             $             1,256  $            1,208  $              1,216  $           1,761  $           2,379  $           1,887
             02-620-610007 FICA Social Security  $                609  $                46  $                  -  $              -  $              -  $              -
             02-620-610008 Overtime Pay         $             2,360  $               -  $              3,486  $           4,042  $           5,354  $           4,213
             02-620-610009 Cell Phone Allowance  $                  70  $              368  $                 490  $             840  $           1,348  $             840
             02-620-610012 Contract Services    $                 -  $            6,392  $              6,983  $         10,000  $              -  $         10,000
                        Total Payroll           $        109,648  $       121,290  $         122,464  $      176,152  $      228,852  $      187,462

                        Supplies
             02-620-615001 Office Supplies      $             8,129  $            3,694  $              3,080  $           5,000  $           5,000  $           5,000
             02-620-615002 Supplies             $            87,998  $          40,362  $             30,619  $         35,000  $         35,000  $         35,000
             02-620-615003 Printing             $             1,278  $              776  $                 587  $           1,000  $           1,000  $           1,000
             02-620-615004 Postage              $             4,347  $            4,749  $              4,364  $           4,300  $           4,300  $           4,300
             02-620-615005 Electric             $             1,534  $            1,751  $              1,265  $           3,000  $           3,000  $           3,000
             02-620-615006 Water                $                824  $              633  $                 702  $             700  $             700  $             700
             02-620-615009 Cable/Internet       $             2,892  $            3,089  $              3,115  $           3,000  $           3,000  $           3,000
             02-620-640000 Gas                  $                715  $              832  $                  -  $           1,000  $           1,000  $           1,000
                        Total Supplies          $        107,717  $         55,887  $           43,732  $        53,000  $        53,000  $        53,000
                        Training
             02-620-620001 Training             $             5,156  $            7,512  $              6,463  $           8,000  $           5,000  $           8,000
             02-620-620002 Dues & Memberships   $             3,184  $            3,307  $              3,177  $           3,500  $           3,500  $           3,500
                        Total Training          $            8,340  $         10,819  $             9,640  $        11,500  $          8,500  $        11,500
                        Equipment
             02-620-625001 Equipment/Rental     $             4,811  $          16,740  $                  -  $         10,000  $           5,000  $         55,000
             02-620-625004 Equipment Maintenance  $             6,719  $            6,971  $              4,087  $           7,000  $           7,000  $           7,000
             02-620-625014 Building Maintenance  $                 -  $            4,762  $              4,493  $           5,000  $           5,000  $           5,000
             02-620-625021 Contingency Fund     $                 -  $          16,599  $                  -  $         10,000  $         10,000  $         10,000
                        Total Equipment         $            4,811  $         45,073  $             8,580  $        32,000  $        27,000  $        77,000





                                              www.cityofwestworth.com
   40   41   42   43   44   45   46   47   48   49   50