Page 34 - Dalworthington Gardens FY19 Budget
P. 34

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
                                                                                                                                                                                                                  O
                    REVENUE CATEGORY                                                                                                           Amended                       Proposed          Over/(Under)                                der)
                                                                                                                                                                                                                    v
                                                                                                                                                                                                                       /(
                                                                                                                                                                                                                        U
                                                                                                                                                                                                                          n
                                                                                                                                                                                                                      r
                                                                                                                                                                                                                     e
                                                  Actual          Actual          Actual         Actual          Actual          Actual                       Projected
                                                                                                                                                Budget                        Budget              FY17/18                                  /18
                                                                                                                                                                                                                     F
                                                                                                                                                                                                                        7
                                                                                                                                                                                                                       1
                                                                                                                                                                                                                      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
                                                                                                                                                                                                                 P
                                                                                                                                                                                                                  r
                                                                                                                                                FY 17/18                     FY 18/19            Projected                   oposed Budget
                                                                                                                                FY 16/17                       FY 17/18
                    EXPENSE CATEGORY                                                                                                           Amended                       Proposed          Over/(Under)                                der)
                                                                                                                                                                                                                          n
                                                                                                                                                                                                                    v
                                                                                                                                                                                                                  O
                                                                                                                                                                                                                     e
                                                                                                                                                                                                                        U
                                                                                                                                                                                                                       /(
                                                                                                                                                                                                                      r
                                                                                                                                 Actual                       Projected
                                                                                                                                                                                                                      Y
                                                                                                                                                                                                                        7
                                                                                                                                                                                                                       1
                                                                                                                                                Budget                        Budget              FY17/18                                  /18
                                                                                                                                                                                                                     F
                                                                                                                                                                                             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)
   29   30   31   32   33   34   35   36   37   38   39