Page 123 - Ord 866 Adopting a revised Fiscal Year 17-18 and new proposed Fiscal Year 18-19 budget
P. 123

FIVE YEAR FINANCIAL FORECAST
            ALL MUNICIPAL FUNDS


                                                                 ESTIMATED  PROPOSED  1      2       3       4
                           DESCRIPTION                            FY 17- 18  FY 18- 19  FY 19- 20  FY 20- 21  FY 21- 22  FY 22- 23

                     INTERNAL SERVICE -  M&R FUNDS



            FUND 510 - UTILITY MAINT/ REPLACE
            Interest  Income                                vision  16, 350  16, 350  14, 500  14, 500  14, 500  14, 500
            Transfers  In from UF 500                       vision    0      5,000    5,000   5,000   5,000    5,000
            Total Revenues &   Transfers  In                        16, 350  21, 350  19, 500  19, 500  19, 500  19, 500
            Sewer Easement  Cleaning  Machine               vision    0 (   45, 000)    0       0       0        0
            Repaint  Ground  Storage  Tank                  vision    0 (   90, 000)    0       0       0        0
            Pump Station Equipment                          vision    0 (   90, 000)    0       0       0        0
            Total Expenditures &   Transfers  Out                      0 (  225, 000)   0        0       0       0
            NET CHANGE  TO FUND BALANCE                             16, 350 (  203, 650)  19, 500  19, 500  19, 500  19, 500
            Beginning  Fund Balance                                829, 333  845, 683  642, 033  661, 533  681, 033  700, 533
            Ending  Fund Balance                                   845, 683  642, 033  661, 533  681, 033  700, 533  720, 033
            Restricted/  Committed/  Assigned                      845, 683  642, 033  661, 533  681, 033  700, 533  720, 033
            Unassigned  Ending Balance ( projected)                   0        0        0       0       0        0




            FUND 600 - GENERAL MAINT/ REPLACEMENT
            Firefighter  Equipment  Fees                tied to vision  6,000  6,000  6,000   6,000   6,000    6,000
            Interest  Income                            tied to vision  2,290  2,290  2,165   2,165   2,165    2,165
            WA Keller Police Sub- Station               tied to vision  25, 000  0      0       0       0        0
            Transfer  in from GF                        tied to vision  387, 750  1,000, 799  579, 537  498, 660  447, 350  447, 350
            Total Revenues &  Transfers  In                        421, 040  1, 009, 089  587, 702  506, 825  455, 515  455, 515
            WA- Irrigation System                       tied to vision (  6,500)(  6,500)(  15,000)(  5,000)(  5,000)(  5,000)
            WA- 15 Ton Split HVAC System                tied to vision (  6,500)(  14, 000)(  10, 000)(  25, 000)(  25, 000)(  25, 000)
            WA- 2 Ton Roof Top Units                    tied to vision (  7,500)(  7,500)(  15,000)(  10,000)(  10,000)(  10,000)
            WA- AC ton/ 7.5 ton server room             tied to vision (  6,500)(  6,500)  0 (  20, 000)(  20, 000)(  20, 000)
            WA- HVAC System Replacement                 tied to vision (  7,500)(  7,500)  0 (  5,000)(  5,000)(  5,000)
            WA- Update Security  System                 tied to vision (  2,750)(  2,750)(  5,000)(  8,000)(  8,000)(  8,000)
            WA- Update Security Cameras                 tied to vision (  10,300)(  10,300)(  2,000)(  12,000)(  12,000)(  12,000)
            WA- Heater Boilers                          tied to vision (  9,675)(  9,675)  0 (  25, 000)(  25, 000)(  25, 000)
            WA- Painting/ Cloth Wall R& M               tied to vision (  6,500)(  6,500)(  10,000)(  8,000)(  8,000)(  8,000)
            WA- Ext Envrnmt  Imprvmts  Irrig            tied to vision (  7,500)(  7,500)  0 (  12, 000)(  12, 000)(  12, 000)
            WA- Parking Lot                             tied to vision  0 (  25,000)    0       0       0        0
            WA Playground  Equipment                    tied to vision  0 (  5,000)     0       0       0        0
            WA- Plumbing Repair/ Replacement            tied to vision (  2,775)(  9,000)(  15,000)(  5,000)(  5,000)(  5,000)
            WA- Carpet/ VCT Flooring                    tied to vision (  25, 000)(  35, 000)(  15, 000)(  15, 000)(  15, 000)(  15, 000)
            WA- Envrnmt Bldg UG light/ water            tied to vision (  2,750)(  10,000)  0 (  5,000)(  5,000)(  5,000)
            WA- Refurbish  Classrooms                   tied to vision (  21, 000)(  30, 000)(  35, 000)(  25, 000)(  25, 000)(  25, 000)
            WA- Interior Building R& M                  tied to vision (  5,500)(  15,000)(  10,000)(  15,000)(  15,000)(  15,000)
            WA- Exterior  Paint &  Wood R& M            tied to vision (  4,500)(  4,500)(  4,000)(  8,000)(  8,000)(  8,000)
            WA- Roof Repairs                            tied to vision (  47,550)(  47,550)(  15,000)(  5,000)(  5,000)(  5,000)
            WA- Mechanical  Equipment                   tied to vision  0 (  25, 000)   0       0       0        0
            WA- Furniture/ Interior Bldg                tied to vision (  7,000)(  15,000)  0   0       0        0
            WA- Keller Police Substation                tied to vision (  25, 000)  0   0       0       0        0
            Dept 17 - Westlake Academy Facilities (                212, 300)(  299, 775)(  151, 000)(  208, 000)(  208, 000)(  208, 000)
            Trail Repairs and Maintenance               tied to vision  0 (  10,000)(  10,000)(  10,000)(  10,000)(  10,000)
            Park Repairs  and Maintenance               tied to vision  0 (  10, 000)(  10, 000)(  10, 000)(  10, 000)(  10, 000)
            Dept 19 - Town Parks                                      0 (   20,000)(  20,000)(  20,000)(  20,000)(  20,000)
            Servers &  Network Storage                  tied to vision (  15,000)(  40,000)(  15,000)(  15,000)(  15,000)(  15,000)
            Network  Printers/ Peripheal  Dev           tied to vision (  5,000)(  5,000)(  5,000)(  5,000)(  5,000)(  5,000)
            Network Equipment                           tied to vision  0 (  115, 000)(  25,000)(  25,000)(  25,000)(  25,000)
            Server Replacements                         tied to vision (  5,000)(  20, 000)(  12, 500)(  100, 000)(  12, 500)(  12, 500)
            Phone System/ Peripheal Devices             tied to vision (  5,000)(  65,000)(  10,000)(  10,000)(  10,000)(  10,000)
            Dept 20 -  Town IT Dept (                               30, 000)(  245, 000)(  67, 500)(  155, 000)(  67, 500)(  67, 500)








                                                             109
   118   119   120   121   122   123   124   125   126   127   128