Page 35 - Dalworthington Gardens FY19 Budget
P. 35

120-ENTERPRISE FUND SUMMARY




 Beginning Fund Balance              528,874        1,595,236        1,751,901


                                                                       FY 17/18                   FY 18/19
                                                                                       r
                                                                                      P
                     FY 17/18                      FY 18/19           Projected                   oposed Budget
 FY 11/12       FY 12/13       FY 13/14       FY 14/15       FY 15/16       FY 16/17       FY 17/18
 REVENUE CATEGORY    Amended                       Proposed          Over/(Under)                                der)
                                                                                            /(
                                                                                        O
                                                                                            r
                                                                                         v
                                                                                              U
                                                                                          e
                                                                                               n
 Actual  Actual  Actual  Actual  Actual  Actual  Projected
                      Budget                        Budget             FY17/18                                  /18
                                                                                          F
                                                                                             1
                                                                                              7
                                                                                           Y
                                                                   Amended Budget         Projected
 Water/Sewer Sales & Fees             1,217,413            1,115,606            1,219,464            1,073,419            1,133,983            1,492,984            1,444,891         1,603,718          1,615,557                       158,827                          11,839

 Charges for Services                130,412                132,686                120,581                129,956                160,960                176,715                169,392             165,182             169,392                          (4,210)                            4,210
 Other Revenue                   37,455                  33,850                  41,417                  32,902                  35,861                227,113                  42,196               44,384                44,162                           2,188                              (222)

 Other Sources                  838,644                         -                       -                       -                                -                                 -
 TOTAL REVENUE             1,385,280            1,282,143            1,381,462            1,236,277            1,330,805            2,735,456            1,656,479         1,813,284          1,829,111                       156,805                          15,826
                                                                       FY 17/18                   FY 18/19
                     FY 17/18                      FY 18/19           Projected                   oposed Budget
                                                                                       r
                                                                                      P
     FY 16/17                       FY 17/18
                                                                                        O
                                                                                              U
                                                                                               n
                                                                                            /(
                                                                                            r
                                                                                         v
 EXPENSE CATEGORY    Amended                       Proposed          Over/(Under)                                der)
                                                                                          e
       Actual                       Projected
                                                                                              7
                                                                                          F
                                                                                           Y
                                                                                             1
                      Budget                        Budget             FY17/18                                  /18
                                                                   Amended Budget         Projected

 Personnel Salary & Wages                  192,183                240,232             241,827             223,127                           1,595                         (18,699)
 Personnel Taxes & Benefits                   92,833                113,023             110,882                95,747                          (2,141)                         (15,135)
 Training & Travel                         200                    1,500                     940                  2,329                             (560)                            1,388

 Materials & Supplies                   20,046                  21,023               20,862                55,613                             (161)                          34,751

 Utilities                   27,653                  36,092               32,792                37,267                          (3,300)                            4,475
 Bad Debt                   19,459                    4,000                  4,000                  4,000                                -                                 -
 Maintenance                   35,491                  30,779                  9,599                19,950                        (21,180)                          10,351
 Consultants                   10,141                    9,900               11,175                15,250                             1,275                            4,075
 Contractual             1,089,439            1,116,865         1,136,447          1,227,255                         19,582                          90,808
 Other Expenses                181,648                  31,062               34,492                75,547                             3,430                          41,055


 Capital Outlay                           -                   53,974               53,603                25,400                             (371)                         (28,203)
 Other Uses                         -                           -                         -                       -                                -                                   -
 TOTAL EXPENSES             1,669,093            1,658,450         1,656,620          1,781,485                          (1,830)                        124,866
 REVENUE OVER EXPENSES             1,066,363                   (1,971)             156,665                47,625                       158,636                      (109,039)
 ENDING FUND BALANCE           1,595,236        1,751,901        1,799,526                                 47,625
 Claim on Cash Beginning Balance              (395,579)            (238,914)
 Revenue over Expenses                        156,665                47,625
 Ending Balance Claim on Cash               (238,914)          (191,289)
   30   31   32   33   34   35   36   37   38   39   40