Page 62 - Dalworthington Gardens FY20 Approved Budget
P. 62

ENTERPRISE FUND P&L DETAILS            2017-18      2018-19           2018-19               2019-20

                                                                                                                                           % of
                                                                                                                                          Projected
                                  Account Number  Account Description          ACTUAL     Amended Budget   Projected  % of Budget  Proposed Budget  FY 2018-19
                                  00.4300      Water Sales: Billed                         1,026,453                      929,678  $                  894,220  96%  $             1,061,668  119%

                                  00.4301      Water Sales: Non-Billed                             8,565                               -  $                          -  0%  $                         -  0%



                                  00.4305      Sewer Sales: Billed                              550,528                      511,468  $                518,560  101%  $                623,380  120%
                                  00.4315      Permits & Fees:Connection Fees                         2,524                           2,276  $                    2,713  119%  $                     2,600  96%

                                  00.4318      Permits & Fees:Sewer Tap Fee                            260                               -  $                         390  0%  $                         -  0%
                                  00.4320      Permits & Fees:Meter & Tap Fee                         (1,096)                              -  $                    1,525  0%  $                         -  0%

                                  00.4400      Impact Fees: DWG Water                              (2,943)                              -  $                        -    0%  $                         -  0%
                                  00.4405      Impact Fees: Sewer                                    (356)                              -  $                          -  0%  $                         -  0%

                                  Total Water/Sewer Sales & Fees                          1,583,936                    1,443,422  $            1,417,408  98%  $              1,687,648  119%


                                  00.4465      Chrg for Serv:Refuse Collectio                      168,481                      172,733  $                172,852  100%  $                177,172   102%


                                  00.4470      Chrg for Serv:Haz Waste Collection Fee                             -                           2,571  $                    2,601  101%  $                    10,416  400%

                                  Total Charges for Service                                   168,481                      175,304  $                175,453  100%  $                187,588  107%
                                  00.4800      Other Rev:Int from Investments                         2,401                           4,327  $                    4,289  99%  $                     4,500  105%


                                  00.4805      Other Rev:Delinquent Charge                       23,854                        21,484  $                  19,718  92%  $                  21,000   107%



                                  00.4810      Other Rev:Cellular Tower Lease                       14,692                        14,692  $                  14,692  100%  $                  14,692  100%

                                  00.4815      Other Rev:CC Online Payments                         1,268                           1,424  $                    1,530  107%  $                     1,450  95%

                                  00.4816      Other Rev: Sales Tax Discount                              69                                53  $                          49  94%  $                          36  73%

                                  00.4890      Other Rev: Miscellaneous                            3,084                              140  $                         210  150%  $                        150  71%


                                  Total Other Revenue                                             45,368                        42,119  $                  40,488  96%  $                  41,828   103%
                                  00.4900      Transfer In                                      154,563                               -  $                          -  0%  $                         -  0%

                                  Total Other Uses                                            154,563                              -    $                          -  0%  $                        -    0%



                                  TOTAL REVENUES                                          1,952,347                  1,660,845  $            1,633,349  98%  $            1,917,064  117%



                                  40.6000      Personnel:Salaries Full Time                    205,196                      188,364  $                  188,306  100%  $                208,743   111%

                                  40.6005      Personnel:Salaries Part Time                       13,601                           7,810  $                    7,572  97%  $                         -  0%

                                  40.6015      Personnel:Salaries Standby                          8,796                           9,579  $                    9,573  100%  $                     9,600  100%
                                  40.6020      Personnel:Salaries Overtime                         7,648                           3,815  $                    3,267  86%  $                     3,380  103%

                                  40.6025      Personnel:Salaries Sick Leave                         1,274                              813  $                       813  100%  $                     2,087  257%



                                  40.6036      Personnel:Supplements                             10,758                        11,089  $                  11,089  100%  $                  11,673  105%

                                  40.6050      Personnel:Service Pay-Longevit                         1,803                              884  $                       884  100%  $                     1,041  118%

                                  Total Salaries & Wages                                      249,076                      222,353  $                221,504  100%  $                236,524  107%



                                  40.6030      Personnel:FICA(SS) & MediCare                       18,191                        15,993  $                  15,724  98%  $                    17,503  111%
                                  40.6031      Personnel: SUTA Taxes                                  817                                34  $                          34  99%  $                          34  100%

                                  40.6042      Personnel:ER-Life/AD&D Ins                                 42                              141  $                       141  100%  $                        162  115%
                                  40.6043      Personl:AffordableCareActFees                         1,219                               -  $                        -    0%  $                         -  0%

                                  40.6045      Personnel:TMRS                                    45,391                        46,425  $                  45,700  98%  $                    50,167  110%


                                  40.6046      Personnel:ER Long Term Disab                            691                              649  $                       648  100%  $                        746  115%


                                  40.6047      Personnel:Employee Health Ins                       36,741                        27,748  $                  27,803  100%  $                    35,151  126%
                                  40.6048      Personnel:Health Savings Acct                         2,011                           2,974  $                    2,999  101%  $                     3,174  106%

                                  40.6049      Personnel:ER Short Term Disab                            394                              361  $                       361  100%  $                        412  114%

                                  40.6099      Personnel:TMRS OPED Supplemental Exp                            796                               -  $                        -    0%  $                         -  0%



                                  Total Taxes & Benefits                                      106,291                        94,325  $                  93,410  99%  $                107,348  115%
   57   58   59   60   61   62   63   64   65   66   67