Loading...
HomeMy Public PortalAboutSpecial Revenue Funds DetailFY2018 BUDGET PROJECTION •REVOLVING FUNDS •AMBULANCE •GOLF •WATER •CROSBY MANSION •RECREATION •TELECOMMUNICATIONS •CABLE ACCESS Town of Brewster 2198 Main Street Brewster, MA 02631 Total of 18 full-time employees and 18 on-call employees. Chief Deputy Group 1 Captain FF/EMT FF/EMT Call FF/EMT's Group 2 Captain FF/EMT FF/EMT Call FF/EMT's Group 3 Captain FF/EMT FF/EMT Call FF/EMT's Group 4 Captain FF/EMT FF/EMT Call FF/EMT's Inspector Admin. Assistant Fire Department Organizational Chart (January 2017) DAY SHIFT FF/EMT 24 Hour PositionsDAY SHIFT FF/PARAMEDICS Funding provided through SAFER Grant SPECIAL REVENUE FUND TOWN ADMINISTRATOR BOARD OF SELECTMEN FINANCE COMMITTEE EXPENDED EXPENDED EXPENDED EXPENDED APPROPRIATED RECOMMENDED RECOMMENDED RECOMMENDED WAGES: Full-time -$ -$ -$ -$ -$ $ 103,921 $ 103,921 $ 103,921 Part Time - Call -$ -$ -$ -$ -$ $ 35,000 $ 35,000 $ 35,000 Overtime -$ -$ -$ -$ -$ $ - $ - $ - Longevity -$ -$ -$ -$ -$ $ - $ - $ - Holiday Pay -$ -$ -$ -$ -$ $ - $ - $ - Educational Stipends -$ -$ -$ -$ -$ $ - $ - $ - Contractual Obligations -$ -$ -$ -$ -$ $ - $ - $ - SUB TOTAL -$ -$ -$ -$ -$ 138,921$ 138,921$ 138,921$ GENERAL EXPENSES; Clothing Allowance -$ -$ -$ -$ -$ $ 30,000 $ 30,000 $ 30,000 R&M Appa -$ -$ -$ -$ -$ $ 18,000 $ 18,000 $ 18,000 Breathing App Maint -$ -$ -$ -$ -$ $ - $ - $ - Hose Replacement/Repair -$ -$ -$ -$ -$ $ - $ - $ - Radio Maint -$ -$ -$ -$ -$ $ 5,000 $ 5,000 $ 5,000 Tuition/Education -$ -$ -$ -$ -$ $ 12,600 $ 12,600 $ 12,600 Medical Expense -$ -$ -$ -$ -$ $ 5,000 $ 5,000 $ 5,000 Hardware -$ -$ -$ -$ -$ $ 1,750 $ 1,750 $ 1,750 In-State Travel -$ -$ -$ -$ -$ $ 250 $ 250 $ 250 Dues/Subscriptions -$ -$ -$ -$ -$ $ 1,085 $ 1,085 $ 1,085 Misc. Ambulance Equipment -$ -$ -$ -$ -$ $ - $ - $ - Contracted Services -$ -$ -$ -$ -$ $ 20,600 $ 20,600 $ 20,600 EMS Supplies -$ -$ -$ -$ -$ $ 52,000 $ 52,000 $ 52,000 Admin / Leasing / Office Supplies -$ -$ -$ -$ -$ $ 9,100 $ 9,100 $ 9,100 General Ops -$ -$ -$ -$ -$ $ 3,500 $ 3,500 $ 3,500 Computers -$ -$ -$ -$ -$ $ 4,900 $ 4,900 $ 4,900 R&M Building -$ -$ -$ -$ -$ $ 21,000 $ 21,000 $ 21,000 Utilties -$ -$ -$ -$ -$ $ 28,000 $ 28,000 $ 28,000 Reserve for Unforseen Exp.-$ -$ -$ -$ -$ $ 115,000 $ 115,000 $ 115,000 SUB TOTAL -$ -$ -$ -$ -$ 327,785$ 327,785$ 327,785$ RESCUE EXPENSE: Rescue Billing -$ -$ -$ -$ -$ $ 30,000 $ 30,000 $ 30,000 Dispatch -$ -$ -$ -$ -$ $ 75,000 $ 75,000 $ 75,000 Car 230 (first response vehicle)-$ -$ -$ -$ -$ $ 60,000 $ 60,000 $ 60,000 Personal Protective Equipment -$ -$ -$ -$ -$ $ 20,000 $ 20,000 $ 20,000 Rescue /Pumper -$ -$ -$ -$ -$ $ 75,000 $ 75,000 $ 75,000 Ambulance Leases -$ -$ -$ -$ -$ $ 105,000 $ 105,000 $ 105,000 Laryngoscopes -$ -$ -$ -$ -$ $ 10,000 $ 10,000 $ 10,000 Computer Upgrades/mobile -$ -$ -$ -$ -$ $ 15,000 $ 15,000 $ 15,000 SUB TOTAL -$ -$ -$ -$ -$ 390,000$ 390,000$ 390,000$ STATION EXPENSE: Generator -$ -$ -$ -$ -$ $ - $ - $ - R&M Building -$ -$ -$ -$ -$ $ - $ - $ - Office Supplies -$ -$ -$ -$ -$ $ - $ - $ - Computer/Copy supply -$ -$ -$ -$ -$ $ - $ - $ - General Operations -$ -$ -$ -$ -$ $ - $ - $ - SUB TOTAL -$ -$ -$ -$ -$ -$ -$ -$ GRAND TOTAL -$ -$ -$ -$ -$ 856,706$ 856,706$ 856,706$ Vote 5-0-0 Vote 7-0-0 FY2018 AMBULANCE - MGL Chapter 40 S 5F FY2013 FY2014 FY2015 FY2016 FY2017 Fire 3/23/2017 DEPARTMENTAL INDEX Year FISCAL YEAR 2016 CURRENT FISCAL YEAR 2017 FISCAL YEAR 2018 FISCAL YEAR 2019 FISCAL YEAR 2020 FISCAL YEAR 2021 FISCAL YEAR 2022 NOTES B. FIRE DEPARTMENT 1. Service/Utility Vehicle #230 2008 60,000$ 2. Fire Chief's Vehicle # 231 2013 2020 3. Deputy Chiefs Vehicle #232 2007 47,000$ 4. Fire Prevention Vehicle #249 2010 50,000$ 5. Forestry Truck #F238* 1999 6 Forestry Truck #F240*2011 2025 7. Ambulance #A242 2010 54,000$ 54,000$ 54,000$ 54,000$ 54,000$ Lease End 2022 8. Ambulance #A243*2010 53,000$ 26,250$ 25,500$ 51,000$ 51,000$ 51,000$ Lease End 2021 9 Ambulance #A244*2014 50,000$ 26,250$ 25,500$ Lease End 2018 10. Heavy Rescue Vehicle #HR241 2005 2030 11. Ladder Truck #L237*2006 2031 12. Engine - Class A Pumper #E233*1989 37,500$ 75,000$ 75,000$ 75,000$ 75,000$ 75,000$ Lease - 10 Yrs 13. Custom Pumper #E234* (Engine)2009 54,000$ 54,000$ Lease End 7/20/18 14. Custom Pumper #E239* (Engine)2009 54,000$ 54,000$ Lease End 7/20/18 15. Rescue Boat #B246 17 Feet 2007 2018 16. Boat Trailer #246 2008 17. Inflatable Boat #247 2000 19,000$ 18. 3/4 Ton Trailer* 1986 19. Boat Trailer - #247 2007 20. Rescue Tool*(Jaws of Life) (Qty 3)1984/2005 100,000$ 2027 21. Breathing Apparatus (Qty 36 units)54,720$ Lease 22. Defibrillators-Paramedic* (Qty 4 units)120,000$ 23. AED Replacement 20,000$ 24. Airbag Replacement 25. Thermal Imaging Equipment*50,000$ 26. 800 Radio system - Portables/pagers/PASS 1996 60,000$ 30,000$ 27. Computers Equipment*/add & replace 15,000$ 25,000$ 28. Protective Clothing Equipment*25,000$ 20,000$ 25,000$ 29. Fire Hose Replacement* 15,000$ 30. Fire Station Replacement 13,500,000$ 30% design 31. Automatic CPR Devices (Qty 3 units) 32. EMS Infusion Pumps 15,000$ OEMS mandate 33. Assistance to Firefighter Grant 10,000$ 34. Training & Emergency Management 22,000$ 35. Laryngoscopes 10,000$ TOWN OF BREWSTER FISCAL YEAR 2017-2022 CAPITAL PLAN Fiscal Year 2018 Adopted by the Board of Selectmen (TBD) Fire 2/7/2017 Page 1 of 2 DEPARTMENTAL INDEX Year FISCAL YEAR 2016 CURRENT FISCAL YEAR 2017 FISCAL YEAR 2018 FISCAL YEAR 2019 FISCAL YEAR 2020 FISCAL YEAR 2021 FISCAL YEAR 2022 NOTES B. FIRE DEPARTMENT 36. Mobile Software License SUBTOTAL FIRE DEPARTMENT 13,825,720$ 366,000$ 285,000$ 410,000$ 355,000$ 180,000$ 129,000$ SOURCE OF FUNDS Year FISCAL YEAR 2016 CURRENT FISCAL YEAR 2017 FISCAL YEAR 2018 FISCAL YEAR 2019 FISCAL YEAR 2020 FISCAL YEAR 2021 FISCAL YEAR 2022 DEBT AUTHORIZATIONS N/A 13,500,000$ -$ -$ 50,000$ 100,000$ -$ -$ AMBULANCE RECEIPTS RESERVED N/A 325,720$ 180,500$ 285,000$ 360,000$ 255,000$ 180,000$ 129,000$ PROPERTY TAXES / AVAIL. FUNDS N/A 155,500$ -$ -$ -$ -$ -$ GRANTS, GIFTS & CPA N/A 30,000$ -$ -$ -$ -$ -$ GRAND TOTALS OF REVENUES 13,825,720$ 366,000$ 285,000$ 410,000$ 355,000$ 180,000$ 129,000$ *Italics denotes forecast. Fire 2/7/2017 Page 2 of 2 Golf Department Director of Golf Operations Pers Bylaw three year contract Golf Superintendent Pers. Bylaw Gr. IV Food & Beverage Operation Contract Service Asst. Operations Pers. Bylaw/ Gr. III Department Assistant (PT) Pers. Bylaw Gr. 1 (24 HPW) Pro Shop Clerks, Starters, Rangers, Attendents Pers. Bylaw Fixed Rate Golf Master Mechanic SEIU Gr. 4 Golf Irrigation Technician SEIU Gr. 3Golf Maint. Mechanic SEIU Gr. 3 Golf Groundsman SEIU Gr.3 Seasonal Groundsman (3) Town Administrator Appointed by the Board of Selectmen Asst. Town Administrator Pers. Bylaw Gr. V Asst. Operations Manager Pers. Bylaw/LRS Gr. 6 Golf Foremen (2 Positions) OPEIU Gr. 7B Golf Maint. Mechanic SEIU Gr. 3 Golf Groundsman SEIU Gr.3 Seasonal Groundsman Seasonal Groundsman (2) The Captains Golf Course FY 2018 Budget Narrative FY 2018 REVENUE & EXPENSE BUDGET PROJECTION Projected REVENUES: FY 2018 Season Passes $ 917,571 Golf Carts 707,983 Daily Green Fees 1,831,468 Driving Range 130,000 Pro Shop Gross Sales 300,000 Restaurant Rent 40,000 Miscellaneous 0 Total Revenues $3,927,022 EXPENSES: Wages $1,369,325 Operating Expenses 919,356 Pro Shop Purchases 230,000 Fringe Benefits 451,337 Property & Liability Ins. 58,000 Debt Service Principal 740,000 Debt Service Interest 96,277 Issuance Cost 10,000 Capital 258,756 Contingency 100,000 Total Expenses $4,233,051 TO GOLF RESERVE $ (306,029) Golf Fund Beginning Bal. $ 589,000 Less Golf Deficit $ 306,029 Golf Fund Ending Bal. $ 282,971 Notes: 1.Season Passes are based on the number of season pass holders in 2016 at the rates approved for 2017 (3% increase over 2016 rates). 2.Golf Carts are based on the riding cart usage in 2016 at the rates approved for 2017 ($1 increase in all cart rates). 3.Daily Green Fees are based on the same amount of play as 2016 at the rates approved for 2017 ($1 increase for all green fee categories). 4.No projected growth in Driving Range revenues. 5.No projected growth in Pro Shop Sales. 6.Restaurant rent is projected lower due to the fact that we are in the process of restructuring the lease agreement to either lower or eliminate a guaranteed minimum rent with the objective of improving the service to the customer. 7.There is no projection for Miscellaneous revenue. In FY 2017 this projection included an estimate for interest earned and energy credits. 8.The Golf Fund Beginning Balance represents the projected balance in the Golf Cart Receipts Reserved for Appropriation account at the close of FY 2017. Beginning in FY 2018 we are no longer running the separate accounts. 9.The expense line items are detailed in the budget spreadsheet and explained in the following pages. The debt service includes the bond for the expansion of the golf course ($795,200 P & I) that will be retired in 2020, and a short term borrowing for a golf improvement project ($41,077 P & I) that will expire in 2021. FY 2018 Budget Line Item Explanations WAGES: Full-time Maintenance – This line item includes the nine (9) full-time, year-round maintenance staff. There is no increase in staffing levels. Wages are shown with no increase per Town directive, other than a $10,000 increase for the Golf Course superintendent. The superintendent’s increase is being proposed in order to have that salary more in line with comparable facilities. Part-time Maintenance – This line item includes (17) seasonal maintenance staff (3 @ 40 weeks (union); 2 @ 32 weeks (union); 5 @ 25 weeks (non-union); 4 @ 20 weeks (non-union); and 3 @ 15 weeks (non-union). There is no increase in staffing levels or wages per Town directive. Full-time Administrative - This line item includes the three (3) full-time, year-round golf professional staff. There is no increase in staffing levels or wages based on Town directive. Part-time Administrative – This line item includes (1) senior clerk (part-time year-round), and all the pro shop clerks, starters, rangers, cart attendants, driving range attendants, and clubhouse attendants (part-time seasonal). The increase in this line item is due to an increase in the increase in the Town’s wage scale for these workers. Overtime – This line item is for overtime pay for the maintenance staff for weekend, holiday and special project/emergency coverage. Longevity – Per Town directive. GENERAL EXPENSES: Clothing-Maint. – This line item is for union negotiated clothing and shoe allowance for the maintenance staff and other weather and protective gear. Clothing-Admin. – This line item provides shirts and hats for the pro shop/outside staff. Oil/Grease-Maint. – This line item is used to purchase oil and grease to maintain the maintenance equipment. There is a requested increase in this line item based on past history. Diesel Fuel-Maint. – This line item is used to purchase diesel fuel for the maintenance equipment. Our annual usage is approximately 6,100 gallons. The estimated price per gallon for FY 2018 is $2.00. Heating-Maint. – This line item is to provide natural gas heat to the maintenance building garage area. Heating-Clubhouse – This line item is to provide natural gas heat to the pro shop, restaurant, and pavilion, as well as providing for the gas fired kitchen equipment. Gasoline-Maint. – This line item is to purchase gasoline for the maintenance equipment. Our annual usage is approximately 4,300 gallons. The estimated price per gallon for FY2018 is $2.00. Electricity-Maint. – This line item is to provide electricity to the maintenance building and haz. Mat. Building. The maintenance building lunch room, rest rooms and offices use electric heat, as well as the haz. Mat. Building. Electricity-Clubhouse – This line item is to provide electricity to the pro shop, restaurant, pavilion (including air-conditioning) and cart barns (electric powered carts). In the past two years there has been increased utilization of the function room which has resulted in higher electrical usage for parking lot lights and pavilion HVAC. Electricity-Irrigation – This line item is to provide electricity to the (2) golf course irrigation pumps, and to the cold storage building. Electricity-Driving Range – This line item is to provide electricity to the driving range building and driving range irrigation pump. R & M Equipment – This line item is used to purchase parts and for repairs to our maintenance equipment. R & M Irrigation – This line item is used for repairs to the irrigation system and for the annual service agreement for the irrigation computer system. As the irrigation system ages, more maintenance is required and has resulted in an increased request for this line item. Professional/Technical – This line item is used for soil and tissue tests on the golf course. These additional tests could indicate that we can reduce our lime applications, thus reducing costs in future years. Phone-Maint. – This line item covers the phone service for the maintenance building’s two phone lines. Phone-Clubhouse – This line item covers the phone service for the clubhouse’s four phone lines. Alarm-Maintenance – This line item pays for the burglar and fire alarm monitoring fees for the maintenance and cold storage buildings and repair and annual inspection costs associated with these alarms. Alarm-Clubhouse – This line item pays for the burglar and fire alarm monitoring fees for the clubhouse and pro shop and repair and annual inspection costs associated with these alarms. Office Supplies-Admin. – This line item includes such items as copy machine lease and service agreement, member bag tags, stationary/envelopes, postage, copy paper, printing, filing supplies, register tape, etc. Scorecards – This line item pays for scorecards, pencils and tournament scoreboard supplies. Maintenance Supplies – This line item covers the cost of power/hand/outdoor tools, painting supplies, maintenance building custodial supplies, cleaners/degreasers, nuts & bolts, etc. Range Supplies – This line item covers the cost of new range balls, tokens, E-Keys, range baskets, etc. We have included an increase in this line item to ensure that we are able to supply quality range balls for our customers use. Computer Supplies – This line item covers the cost of the annual service agreements for the point-of-sale, phone reservation, and on-line reservation computer systems, the broadband internet service, as well as other computer supplies. The increase is based on past usage and the need for a new handicap system computer. Office Supplies-Maint. – This line item covers the cost of maintenance copier and fax supplies, and parts program upgrades, etc. Custodial Supplies – This line item covers the cost of rest room paper products, cleaning supplies, and towels to clean carts, etc. We have reduced our request for this line item based on the fact that we are installing hand driers in the rest rooms and will not need to purchase as much in paper products. Rubbish Removal/Sanit. – This line item is used for the trash removal costs, portable toilets, and septic pumping. In FY2018 we are anticipating required pumping of the maintenance building, range building and snack bar building septic systems. Seed & Sod – This line item is used for overseeding, repairing wear areas around the golf course, and to fill divots. Tee & Green – This line item is for ball washer replacement, tee marker replacement, flag and flag stick replacement, tee towel replacement, tee sign repairs, signs, stakes and ropes, and bunker rake replacement, etc. Landscaping – This line item is used to maintain the various garden areas around the golf course property. Topsoil & Sand – This line item is used for topdressing greens, tees and fairways, bunker sand replacement, mulch & manures, t-base (cart path repair), and topsoil, etc. We are looking to increase top-dressing applications resulting in the increase in this line item. Fertilizer – We are planning no change to our fertilizer application program in FY2018. Fungicide – We are planning no change to our fungicide application program for FY2018. Insecticides – This line item is used for grub control and crane fly control. We have reduced our request in this line item based on our past history. Misc. (wetting agents) – This line item is used for soil amendments, the need for which is indicated by our soil testing. We have reduced our request for this line item based on past usage. Cart Lease – This line item covers the cost for our 140-cart fleet, and 4 maintenance utility. The amount is based on a 5-year lease that runs from January 1, 2015 through December 31, 2019. Clubhse Furnish/Repair – This line item covers the costs of general clubhouse building upkeep, HVAC maintenance, sprinkler system inspections, fire suppression inspections/repair, septic system inspections and maintenance, etc. As the building ages, the costs associated with this line item have increased significantly. Credit Card Expense – This line item covers the cost of our credit card processing fees. Our credit card volume in FY 2015 was $2,022,684 and in FY2016 it was $2,206,128. We are currently paying approximately 2.18% in credit card fees. We are projecting slightly higher credit card volume in FY 2018. In-State Travel-Maint. – This line item is used for mileage reimbursement for travel to seminars, meetings, etc. Meetings/Travel-Maint. – This line item covers the costs associated with trade shows, local and regional seminars and meetings, etc. Meetings/Travel Admin. – This line item is used to cover the costs for local and regional meetings/seminars/golf shows. Dues/Subsciptions-Maint. – This line item covers the costs of the GCSAA, Regional and Local dues for the Superintendent, the local dues for the 2 foremen, Mechanics Assn. dues, hoisting licenses and pesticide licenses. Dues/Subsciptions-Admin. – This line item covers the PGA dues for the Director and the golf professional staff, Mass. Golf Assn. dues, National Golf Foundation dues, United States Golf Assn. dues, and the Women’s Golf Assn of Mass. dues. Adverts/Markt/Promo – This line item covers the costs of advertising, marketing and promoting the Captains Golf Course. Included in these costs is the contract with a professional marketing and advertising firm. SPECIAL REVENUE FUND TOWN ADMINISTRATOR BOARD OF SELECTMEN EXPENDED EXPENDED EXPENDED EXPENDED APPROPRIATED RECOMMENDED RECOMMENDED WAGES: Full-time Maintenance 497,082$ 508,898$ 507,655$ 516,937$ 538,805$ $ 547,966 $547,966 Part-time Maintenance 216,619$ 215,461$ 234,480$ 238,073$ 262,081$ $ 266,174 $266,174 Full-time Administrative 200,714$ 208,598$ 217,026$ 225,548$ 232,626$ $ 232,362 $232,362 Part-time Administrative 201,509$ 197,402$ 197,661$ 209,826$ 217,014$ $ 232,107 $232,107 Overtime 54,223$ 54,250$ 43,575$ 39,218$ 45,000$ $ 45,000 $45,000 Longevity 16,847$ 17,228$ 17,297$ 16,640$ 17,771$ $ 18,053 $18,053 Contractual Obligations $ 27,663 $27,663 SUB TOTAL 1,186,993$ 1,201,837$ 1,217,694$ 1,246,242$ 1,313,297$ 1,369,325$ $1,369,325 GENERAL EXPENSES; Clothing-Maint 7,577$ 9,084$ 8,189$ 9,188$ 8,500$ $ 8,500 $8,500 Clothing-Admin 1,609$ 2,056$ 1,753$ 1,910$ 1,900$ $ 2,000 $2,000 Oil/Grease - Maint 6,170$ 3,160$ 4,246$ 3,739$ 3,000$ $ 4,000 $4,000 Diesel Fuel - Maint 20,267$ 18,205$ 21,252$ 15,692$ 10,275$ $ 12,200 $12,200 Heating - Maint 2,320$ 3,026$ 2,204$ 1,828$ 3,000$ $ 2,000 $2,000 Heating - Clubhouse 8,905$ 8,594$ 8,043$ 10,647$ 10,000$ $ 10,000 $10,000 Gasoline - Maintenance 14,635$ 13,469$ 13,176$ 12,236$ 6,732$ $ 8,600 $8,600 Electricity - Maint 8,240$ 8,603$ 10,157$ 9,770$ 11,000$ $ 11,000 $11,000 Electricity - Clubhouse 37,037$ 38,988$ 39,324$ 41,243$ 40,000$ $ 43,000 $43,000 Electricity-Irrigation 22,103$ 23,823$ 24,970$ 25,386$ 25,000$ $ 26,000 $26,000 Electricity-Drive Range 4,003$ 4,535$ 3,860$ 3,645$ 4,000$ $ 4,000 $4,000 R & M Equipment 82,715$ 73,041$ 78,697$ 64,255$ 75,000$ $ 75,000 $75,000 R&M Irrigation Maint.12,589$ 34,979$ 21,962$ 27,842$ 25,000$ $ 30,000 $30,000 Professional/Technical 3,846$ 6,178$ 2,535$ 2,219$ 5,000$ $ 5,000 $5,000 Phone - Maintenance 687$ 660$ 632$ 614$ 700$ $ 650 $650 Phone - Clubhouse 1,085$ 1,092$ 1,072$ 929$ 1,100$ $ 950 $950 Alarm - Maintenance 1,126$ 1,068$ 1,110$ 1,813$ 1,100$ $ 1,100 $1,100 Alarm - Clubhouse 3,090$ 5,029$ 3,949$ 7,528$ 3,000$ $ 3,500 $3,500 Office Supplies - Admin 9,031$ 9,497$ 11,180$ 10,005$ 9,000$ $ 9,000 $9,000 Score Cards 4,472$ 2,979$ 3,354$ 2,374$ 3,600$ $ 3,600 $3,600 Maintenance Supplies 7,319$ 8,878$ 7,194$ 11,522$ 8,500$ $ 8,500 $8,500 Range Supplies 15,164$ 8,905$ 5,750$ 10,977$ 8,000$ $ 10,000 $10,000 Computer Supplies 6,354$ 6,782$ 6,820$ 11,042$ 5,600$ $ 7,000 $7,000 Office Supplies - Maint 504$ 380$ 1,610$ 748$ 500$ $ 1,000 $1,000 Custodial Supplies 7,186$ 8,642$ 9,646$ 7,090$ 9,000$ $ 6,000 $6,000 Rubbish Removal/Sanit.7,279$ 7,548$ 7,699$ 15,412$ 8,000$ $ 10,000 $10,000 Seed & Sod 27,917$ 34,945$ 18,017$ 22,496$ 25,000$ $ 25,000 $25,000 Tee & Green 11,550$ 6,148$ 10,954$ 14,756$ 8,000$ $ 8,000 $8,000 Landscaping 5,045$ 3,727$ 3,818$ 3,711$ 4,500$ $ 4,500 $4,500 Topsoil & Sand 21,875$ 25,848$ 15,414$ 21,158$ 22,000$ $ 25,000 $25,000 Fertilizer 80,112$ 79,302$ 59,750$ 78,092$ 80,000$ $ 80,000 $80,000 Fungicide 145,552$ 135,135$ 132,726$ 123,783$ 142,000$ $ 142,000 $142,000 Insecticides 18,239$ 19,499$ 14,077$ 14,768$ 23,000$ $ 18,000 $18,000 Misc(wetting agents)72,572$ 49,312$ 36,243$ 51,844$ 60,000$ $ 55,000 $55,000 Cart Lease 112,985$ 112,985$ 116,065$ 119,986$ 119,986$ $ 119,986 $119,986 Clbhse Furnish/Repair 18,613$ 30,186$ 27,162$ 30,784$ 28,000$ $ 28,000 $28,000 Credit Card Expense 38,591$ 40,262$ 42,268$ 47,400$ 44,000$ $ 49,000 $49,000 In-State Travel - Maint.703$ 97$ -$ 606$ 450$ $ 450 $450 Note: Pro Shop previously reported in SRF. FY2017 FY2018 GOLF DEPARTMENT - MGL Chapter 40 S 5F FY2013 FY2014 FY2015 FY2016 Golf 2/14/2017 SPECIAL REVENUE FUND TOWN ADMINISTRATOR BOARD OF SELECTMEN EXPENDED EXPENDED EXPENDED EXPENDED APPROPRIATED RECOMMENDED RECOMMENDED FY2017 FY2018 GOLF DEPARTMENT - MGL Chapter 40 S 5F FY2013 FY2014 FY2015 FY2016 Meetings/Travel-Maint 1,365$ 1,053$ 340$ 1,165$ 1,000$ $ 2,500 $2,500 Meetings/Travel-Admin 23$ 60$ 1,039$ 583$ 200$ $ 500 $500 Dues/Subscripts - Maint 1,520$ 1,412$ 1,639$ 2,894$ 1,520$ $ 1,520 $1,520 Dues/Subscripts-Admin 2,230$ 2,230$ 2,230$ 2,230$ 2,300$ $ 2,300 $2,300 Adverts/Markt/Promo 50,661$ 52,384$ 61,517$ 61,259$ 55,000$ $ 55,000 $55,000 Pro Shop Purchases -$ -$ -$ -$ -$ $ 230,000 $230,000 Reserve for Unforseen Exp.-$ -$ -$ -$ -$ $ 100,000 $100,000 SUB TOTAL 904,867$ 903,785$ 843,645$ 907,169$ 903,463$ 1,249,356$ $1,249,356 DEBT SERVICE EXPENSE Principal -$ -$ -$ -$ -$ $ 700,000 $700,000 Interest -$ -$ -$ -$ -$ $ 95,200 $95,200 ST to LT Principal -$ -$ -$ -$ -$ $ 40,000 $40,000 ST to LT Interest -$ -$ -$ -$ -$ $ 1,077 $1,077 Issuance Costs -$ -$ -$ -$ -$ $ 10,000 $10,000 SUB TOTAL -$ -$ -$ -$ -$ 846,277$ $846,277 FRINGE BENEFITS Unemployment -$ -$ -$ -$ -$ $ 21,239 $21,239 Group Insurance -$ -$ -$ -$ -$ $ 201,526 $201,526 Life Insurance -$ -$ -$ -$ -$ $ 666 $666 Medicare -$ -$ -$ -$ -$ $ 19,500 $19,500 Retirement -$ -$ -$ -$ -$ $ 208,406 $208,406 SUB TOTAL -$ -$ -$ -$ -$ 451,337$ $451,337 GENERAL INSURANCE Workers Compensation -$ -$ -$ -$ -$ $ - $0 Auto Liability -$ -$ -$ -$ -$ $ - $0 General Liability -$ -$ -$ -$ -$ $ - $0 Claims -$ -$ -$ -$ -$ $ - $0 SUB TOTAL -$ -$ -$ -$ -$ 58,000$ $58,000 MO Figure EQUIPMENT EXPENSE Additional Equipment -$ -$ -$ -$ -$ $ - Vehicles & Replacement Equip -$ -$ -$ -$ -$ $ 258,756 $258,756 Repair & Maintenance Project -$ -$ -$ -$ -$ $ - Construction -$ -$ -$ -$ -$ $ - SUB TOTAL -$ -$ -$ -$ -$ 258,756$ $258,756 GRAND TOTAL 2,091,860$ 2,105,622$ 2,061,339$ 2,153,411$ 2,216,760$ 4,233,051$ $4,233,051 Vote 5-0-0 Note: Pro Shop Purchases previously captured in pro shop revolving fund. General Insurance is estimated at $58,000. The various line items will be populated once we receive the updated insurance policy. Contingency Note: Golf revenue, expenditures, and debt service were previously included in the General Fund budget. FY2018 budget establishes spending limits based upon "worst case scenario" as opposed to conservative. Unforeseen salary & expenditure appropriations are now included in budget. Golf General Fund Revenues for Fiscal Year 2016 were $2,857,450.88. This figure does not include golf cart revenue or the pro shop. As of December 20th, Fiscal Year 2017's golf general fund revenue is $1,364,358.88 compared to $1,407,382.33 in FY2016. Golf 2/14/2017 Fund TBD GOLF DEPT:635 Golf Department MGL CHP 40 Sec 53D Number of Positions in Department Full-time 12 Part-time 6 Seasonal 60 Temporary 0 Vacancies 0 New Positions Requested 0 TOTAL OF ALL POSITIONS 78 Position Avg Hours Per Week Bi-Weekly Salary / Hrly Rate Class & Step as of 6/30/17 (e.g., B -Step 3) Yearly Salary as of 6/30/17 COLA (Varies by Emp Group) Date of Hire FY 2018 Projected Salary Longevity Pay Education Pay Certification Pay Holiday Pay Other Total by Employee DIRECTOR OF OPERATIONS 40.00 4168.30 Contract 107,839 107,839 06/04/92 108,130 1,800 0 0 0 0 109,930 ASST. OPERATIONS MGR 40.00 2394.54 Bylaw Grade 2 61,950 61,950 07/07/97 62,117 1,500 0 0 0 0 63,617 ASST OPS / PRO SHOP MGR 40.00 2394.52 Bylaw Grade 3 61,949 61,949 05/23/96 62,116 1,500 0 0 0 0 63,616 MAINTENANCE SUPER 40.00 3283.70 Bylaw Grade 4 84,954 84,954 02/24/14 85,182 0 0 0 0 10,000 95,182 ASST SUPERINTENDENT 40.00 33.45 OPEIU Grade 7 69,234 69,234 09/18/90 69,420 1,950 0 0 0 0 71,370 ASST SUPERINTENDENT 40.00 32.39 OPEIU Grade 7 67,039 67,039 03/23/93 67,220 1,650 0 0 0 0 68,870 MASTER MECHANIC 40.00 29.33 SEIU Grade 4 60,705 60,705 04/22/85 60,869 2,250 0 0 0 0 63,119 IRRIGATION TECH 40.00 28.28 SEIU Grade 4 58,531 58,531 05/07/90 58,689 2,100 0 0 0 0 60,789 MAINTENANCE MECHANIC 40.00 26.42 SEIU Grade 3 54,685 54,685 06/17/96 54,832 1,500 0 0 0 0 56,332 SKILLED GROUNDSMAN 40.00 23.63 SEIU Grade 3 48,915 48,915 04/18/05 49,047 1,050 0 0 0 0 50,097 SKILLED GROUNDSMAN 40.00 23.18 SEIU Grade 3 47,975 47,975 08/14/08 48,104 600 0 0 0 0 48,704 GROUNDS WORK 40 WKS 40.00 21.75 SEIU Grade 3 34,620 34,620 04/22/02 34,713 924 0 0 0 0 35,637 GROUNDS WORK 40 WKS 40.00 20.91 SEIU Grade 2 33,623 33,623 03/07/16 33,714 578 0 0 0 0 34,291 GROUNDS WORK 40 WKS 40.00 18.94 SEIU Grade 2 30,456 30,456 03/07/16 30,538 0 0 0 0 0 30,538 GROUNDS WORK 32 WKS 40.00 19.70 SEIU Grade 2 25,342 25,342 03/28/16 25,410 0 0 0 0 0 25,410 GROUNDS WORK 32 WKS 40.00 20.97 SEIU Grade 2 26,976 26,976 03/28/16 27,048 651 0 0 0 0 27,699 MAINTENANCE MECHANIC 40.00 21.49 SEIU Grade 3 44,484 44,484 05/25/15 44,603 0 0 0 0 0 44,603 DEPARTMENT ASST.20.00 20.42 21,134 21,134 03/17/93 21,191 0 0 0 0 0 21,191 PRO SHOP WORKERS (Varies)(Varies) Bylaw 217,014 210,916 Varies 210,916 0 0 0 0 0 210,916 SEASONAL GROUNDS WORKER(S) (Varies)(Varies) Bylaw 114,750 114,750 Varies 114,750 0 0 0 0 0 114,750 *OPEIU Contract in Negotiations 770,329 498,280 18,053 0 0 0 10,000 0 45,000 1,341,661 19,500 1,361,161 Total Prorated Salary Total Seasonal Salary Total Longevity Total Education Salary Subtotal Medicare Total Personnel Services FY 2018 Personnel Spreadsheet Total Certification Pay Total Holiday Pay Total Other Pay Shift Differential Overtime As of 1/19/2017 Town of Brewster - FY18 Budget Projection DEPARTMENTAL INDEX Year FISCAL YEAR 2016 CURRENT FISCAL YEAR 2017 FISCAL YEAR 2018 FISCAL YEAR 2019 FISCAL YEAR 2020 FISCAL YEAR 2021 FISCAL YEAR 2022 NOTES D. GOLF DEPARTMENT 1. Spray Rig (300 Gallon Unit) (TS-1)*2008 30,000$ Lease - 5 Years 2. Spray Rig (300 Gal. Unit) (TS-2)*2008 30,000$ Lease - 5 Years 3. Spray Rig (300 Gallons) (TS-3)*2008 30,000$ Lease - 5 Years 4 Spray Rig (200 gallon unit) (T49)1991 5. Rough Mower* (T68)2001 35,000$ 6. Rotary Rough Mower (T61)*1997 8. Rough Mower (T67)2005 35,000$ 9. Rough Mower (T66)2006 35,000$ 10. Tee/Approach Mower (T311)2008 40,000$ 11. Tee/Approach Mower (T312)2008 40,000$ 12. Tee/Approach Mower (T313)2011 6,630$ 45,000$ Lease - 5 Years 13. Tee/Approach Mower (T314)2011 6,630$ 45,000$ Lease - 5 Years 14. Tee/Approach Mower (T315)2011 6,630$ 45,000$ Lease - 5 Years 15. Tee/Approach Mower (T316)2011 6,630$ 45,000$ Lease - 5 Years 16. Tee/Approach Mower (T317)2011 6,630$ 45,000$ Lease - 5 Years 17. Tee/Approach Mower (T318)2011 6,630$ 45,000$ Lease - 5 Years 18. Tee/Approach Mower (T319)2011 6,630$ 45,000$ Lease - 5 Years 19. Utility Tractor #FO46*1984 40,000$ 20. Utility Tractor #NH65*2001 30,000$ 2022 21. Utility Tractor #KU60 2007 2027 22 . Utility Tractor #KU47 2010 2030 23. Backhoe 1996 2025 24. Walk Behind Mowers #T11*1995 25. Walk Behind Mowers #T12*1995 26. Walk Behind Mowers #T13*1995 27. Walk Behind Mowers #T14*1995 28. Walk Behind Mowers #T15*1999 29. Walk Behind Mowers #T16*1999 30. Walk Behind Mowers #T17*1999 31. Walk Behind Mowers #T18*1999 32. Walk behind Mower #T19 2010 33. Fairway Mower #T55*2007 50,000$ Debt 34. Fairway Mower #T56*2007 50,000$ Debt 35. Fairway Mower #T57*2007 50,000$ Debt 36. Fairway Mower #T58*2007 50,000$ Debt TOWN OF BREWSTER FISCAL YEAR 2017-2022 CAPITAL PLAN Fiscal Year 2018 Adopted by the Board of Selectmen (TBD) Golf 2/14/2017 Page 1 of 4 DEPARTMENTAL INDEX Year FISCAL YEAR 2016 CURRENT FISCAL YEAR 2017 FISCAL YEAR 2018 FISCAL YEAR 2019 FISCAL YEAR 2020 FISCAL YEAR 2021 FISCAL YEAR 2022 NOTES 37. Utility Vehicle 2-WD #T42*1999 38. Utility Vehicle 4WD #T43*1999 39. Utility Vehicle 4WD #T44*1999 40. Utility Vehicle 4WD #T45*1999 5,133$ Debt 41. Utility Vehicle 4WD #T46 1999 30,000$ 42. Utility Vehicle 4WD #T47*1999 5,133$ Debt 43. Utility Vehicle 4WD #T48*1999 5,133$ Lease - 5 Years 44. Portabale Vacuum #T27 2004 31,489$ 45. Portable Vacuum #T26 2004 33,000$ 46. Portable Vacuum #T25 2007 33,000$ 47. Greens Aerifier #T72*1989 48. Greens Aerifier #T73*2003 28,000$ 49. Greens Aerifier #T74*2003 27,000$ Lease - 5 Years 50. Fairway Aerifier #T77*2002 13,000$ 40,000$ Lease - 5 Years 51. Fairway Aerifier #T76 2007 18,252$ Lease - 5 Years 52. Hydrojet Aerifier #T75*1994 2023 53. Fertilizer Spreader #LEL-4 2002 25,000$ 54. Tee & Green Top Dresser #TE-TT*1999 15,500$ 55. Fairway Verticut Unit #SI-VM*2005 2025 56. Grinder Equipment #FU610*1995 25,000$ 57. Fertilizer Spreader #LE-W*1984 58. One Ton Dump Truck 2009 59. 4 x 4 Truck #CH-PU 2004 30,000$ 2022 60. Homemade Trailer*1996 61. Compressor #SU-375 2006 2026 62. Reel Grinder Equipment #FU650*1995 45,000$ 2021 63. Fork Lift #DA-FL 2000 2025 64. Stump Grinder #MI-75T 2010 65. Weather Station Equipment #TW*2000 66. Fuel Tanks #FT* 2000 2022 67. Jockey Pump #JP1*2008 2022 68. Main Pump #MP1*2002 80,000$ 69. Main Pump #MP2*1998 70. Driving Range Pump #DRI*2002 2022 71. Fertigation System #FERT*2001 2022 72. HazMat Building 1998 2028 73. Maintenance Building Exterior siding*1985/1989 74. Cold Storage Exterior siding 1999/2006 75. Starter Shed 2001 2030 76. Clubhouse Painting*1999 20,000$ 77. Clubhouse roof and siding*1999 2024 78. Clubhouse carpeting*20,000$ 2022 78. HVAC System for Pavilion*2010 60,000$ 2025 Golf 2/14/2017 Page 2 of 4 DEPARTMENTAL INDEX Year FISCAL YEAR 2016 CURRENT FISCAL YEAR 2017 FISCAL YEAR 2018 FISCAL YEAR 2019 FISCAL YEAR 2020 FISCAL YEAR 2021 FISCAL YEAR 2022 NOTES 79. HVAC - Clubhouse*1999 30,000$ 80. Parking Lot Lighting* 81. Proshop Fixtures* 82. Course Renovation Project 300000 83. Cart Path Paving Project*30000 100,000$ 84. Sink Hole Repair Project 40,000$ -$ Lease 85. Irrigation System Upgrade (original course)2005 2,500,000$ 2025 86. Irrigation System Upgrade (new course)1998 2,500,000$ 2021 87. Point of Sale/Tee Time Reservation System 2000 88. Ball Dispenser Equipment (DR-1)*2005 2025 89. Electrical Service to Pumps 1984/1985 80,000$ 90. Golf Course Management Processor 17210 5,420$ 5,420$ 5,420$ Lease - 5 Years Golf 2/14/2017 Page 3 of 4 DEPARTMENTAL INDEX Year FISCAL YEAR 2016 CURRENT FISCAL YEAR 2017 FISCAL YEAR 2018 FISCAL YEAR 2019 FISCAL YEAR 2020 FISCAL YEAR 2021 FISCAL YEAR 2022 NOTES 91. Tee Renovations*170000 2021 92. Driving Range Tee 2008 40,000$ Debt 93. Kitchen Equipment (Consession) 94. Pump #1 Back Flow Preventor (Pumphouse) 95. Lightning Warning System* 96. Rough Mower*2015 6,420$ 6,420$ 6,420$ 6,420$ Lease - 5 Years 97. Rough Mower *2015 12,786$ 12,786$ 12,786$ 12,786$ Lease - 5 Years 98. Rough Mower*2015 12,786$ 12,786$ 12,786$ 12,786$ Lease - 5 Years 99. Utility Vehicle 2-WD*2015 5,156$ 5,156$ 5,156$ 5,156$ Lease - 5 Years 100. Utility Vehicle 2-WD*2015 5,156$ 5,156$ 5,156$ 5,156$ Lease - 5 Years 101. Utility Vehicle 2-WD*2015 5,156$ 5,156$ 5,156$ 5,156$ Lease - 5 Years 102. Utility Vehicle 2-WD*2015 5,156$ 5,156$ 5,156$ 5,156$ Lease - 5 Years 103. Greens Aerifier*2014 5,345$ 5,345$ 5,345$ Lease - 5 Years 104. Fairway Aerifier*2014 7,386$ 7,386$ 7,386$ Lease - 5 Years 105. Driving Range Vehicle*2014 2030 106. Fuel Pumps*1999 10,000$ 107. Tee/Approach Mowers w/rollers 45,000$ 108. 2-Blowers 14,000$ 109. Sod Cutter 5,000$ 110. Materials Handler 36,000$ 111. Ventrac Machine -$ 27,000$ SUBTOTAL GOLF EQUIPMENT 209,576$ 272,868$ 258,756$ 5,376,767$ 335,000$ 150,000$ 585,000$ SOURCE OF FUNDS Year FISCAL YEAR 2016 CURRENT FISCAL YEAR 2017 FISCAL YEAR 2018 FISCAL YEAR 2019 FISCAL YEAR 2020 FISCAL YEAR 2021 FISCAL YEAR 2022 DEBT AUTHORIZATIONS N/A -$ -$ -$ 5,000,000$ -$ -$ -$ GOLF RECEIPTS RESERVED N/A 209,576$ 272,868$ 258,756$ 376,767$ 335,000$ 150,000$ 585,000$ PROPERTY TAXES / AVAIL. FUNDS N/A -$ -$ -$ -$ -$ -$ -$ GRANTS, GIFTS & CPA N/A -$ -$ -$ -$ -$ -$ -$ GRAND TOTALS OF REVENUES 209,576$ 272,868$ 258,756$ 5,376,767$ 335,000$ 150,000$ 585,000$ *Italics denotes forecast. Golf 2/14/2017 Page 4 of 4 Water Department Town Administrator Appointed by the Board of Selectmen Water Superintendent Pers. Bylaw Gr. VI Treatment Plant Operator OPEIU Gr. 7B Foreman OPEIU Gr. 7B Adm. Sup. Deputy Collector OPEIU Gr. 6B Water Comission Five member board appointed by the Board of Selectmen Department Asst OPEIU Gr. 4A Department Asst OPEIU Gr. 4A Equipment Operator / Water Technician SEIU Gr. 4 WTO Cross Connection Surv. & Tester SEIU Gr. 5 Sys Maint Tec SEIU Gr. 3 Laborer SEIU Gr. 2 Laborer SEIU Gr. 2 Laborer SEIU Gr. 2 Laborer SEIU Gr. 2 Asst. Town Administrator Pers. Bylaw Gr. V Deane Keuch PE Paul Anderson Walter Rowles PE Superintendent Douglas Wilcock Board of Water Commissioners 165 COMMERCE PARK ROAD ∙ BREWSTER, MA 02631 ∙ 508-896-5454 ∙ FAX 508-896-4517 TOWN OF BREWSTER WATER DEPARTMENT List of Services Provided This department has mandatory monitoring and maintenance that is required for it to operate. The spring and fall are the most difficult times to schedule construction due to overlapping programs (hydrant flushing, seasonal turn on’s). Below is a brief description of the Department and a list of services provided annually. The Water Department consists of 9 field staff and 4 office. There are 135 miles of water main with 7,421 service connections to residential and commercial structures. Domestic and fire protection is maintained by two storage tanks (5 million gallons). The department reads meters and bills the customers twice a year. The ongoing meter replacement program is close to having all accounts on a radio read system. Field staff maintain existing infrastructure and install new when time permits. Monitoring of wells and treatment facilities Sampling of wells and throughout the system Flushing of all water main (done in the spring and fall) Hydrant maintenance Meter reading Cross connection testing and surveys Markouts of infrastructure Emergency repairs of leaks Curb to main replacements Meter replacements Seasonal turn ons and offs Snow removal at water facilities and assisting Highway (seasonal) Yard maintenance at 10 sites (seasonal) Building maintenance (9 structures) Responding to residents’ concerns Training required to maintain water licensing Replacement of 2” water mains with 8” and adding hydrants Replacing hydrants determined inadequate by the maintenance program Chemical deliveries and transfer of chemicals General maintenance of pumps and treatment facilities Emergency call outs SPECIAL REVENUE FUND TOWN ADMINISTRATOR BOARD OF SELECTMEN FINANCE COMMITTEE EXPENDED EXPENDED EXPENDED EXPENDED APPROPRIATED RECOMMENDED RECOMMENDED RECOMMENDED WAGES: Full-time 607,955$ 594,992$ 611,732$ 623,453$ 695,846$ $ 694,858 $ 694,858 $ 694,858 Part Time 2,712$ -$ -$ -$ -$ $ - $ - $ - Overtime 44,687$ 39,438$ 45,366$ 33,785$ 46,350$ $ 46,350 $ 46,350 $ 46,350 Standby Pay 13,250$ 13,000$ 13,250$ 13,000$ 13,250$ $ 13,250 $ 13,250 $ 13,250 Longevity 9,000$ 4,756$ 4,650$ 7,385$ 4,800$ $ 5,250 $ 5,250 $ 5,250 Contractual Obligations -$ -$ -$ -$ -$ $ 19,353 $ 19,353 $ 19,353 SUB TOTAL 677,604$ 652,186$ 674,998$ 677,623$ 760,246$ 779,061$ 779,061$ 779,061$ OPERATING EXPENSE: Propane/Natural Gas 15,543$ 18,356$ 10,211$ 14,543$ 20,000$ $ 18,000 $ 18,000 $ 18,000 Electricity 108,340$ 115,380$ 125,303$ 122,343$ 145,000$ $ 130,000 $ 130,000 $ 130,000 R & M Equipment 67,047$ 83,853$ 81,086$ 85,686$ 80,000$ $ 85,000 $ 85,000 $ 85,000 Professional Expense 35,517$ 32,344$ 36,990$ 27,540$ 35,000$ $ 35,000 $ 35,000 $ 35,000 Supplies 10,609$ 11,970$ 18,985$ 21,802$ 12,000$ $ 19,000 $ 19,000 $ 19,000 Postage 7,868$ 7,924$ 8,023$ 8,101$ 8,500$ $ 1,500 $ 1,500 $ 1,500 Small Tools & Equipment 68,755$ 80,847$ 63,435$ 73,368$ 80,000$ $ 80,000 $ 80,000 $ 80,000 Primary Assessment 4,212$ 3,860$ 3,799$ 3,858$ 5,000$ $ 4,000 $ 4,000 $ 4,000 In-State Travel 528$ 687$ 648$ 694$ 700$ $ 700 $ 700 $ 700 Scheduled System Maint 27,849$ 30,763$ 41,325$ 40,095$ 29,000$ $ 35,000 $ 35,000 $ 35,000 Reserve for Unforseen Exp.-$ -$ -$ -$ -$ $ 25,000 $ 25,000 $ 25,000 SUB TOTAL 346,267$ 385,985$ 389,806$ 398,029$ 415,200$ 433,200$ 433,200$ 433,200$ DEBT SERVICE EXPENSE Principal -$ -$ -$ -$ -$ $ 520,000 $ 520,000 $ 520,000 Interest -$ -$ -$ -$ -$ $ 190,624 $ 190,624 $ 190,624 Issuance Costs -$ -$ -$ -$ -$ $ 10,000 $ 10,000 $ 10,000 SUB TOTAL -$ -$ -$ -$ -$ 720,624$ 720,624$ 720,624$ FRINGE BENEFITS Unemployment -$ -$ -$ -$ -$ $ - $ - $ - Group Insurance -$ -$ -$ -$ -$ $ 178,521 $ 178,521 $ 178,521 Life Insurance -$ -$ -$ -$ -$ $ 484 $ 484 $ 484 Medicare -$ -$ -$ -$ -$ $ 11,000 $ 11,000 $ 11,000 Retirement -$ -$ -$ -$ -$ $ 149,707 $ 149,707 $ 149,707 SUB TOTAL -$ -$ -$ -$ -$ 339,712$ 339,712$ 339,712$ GENERAL INSURANCE Workers Compensation -$ -$ -$ -$ -$ $ - $ - $ - Auto Liability -$ -$ -$ -$ -$ $ - $ - $ - General Liability -$ -$ -$ -$ -$ $ - $ - $ - Claims -$ -$ -$ -$ -$ $ - $ - $ - SUB TOTAL -$ -$ -$ -$ -$ -$ -$ -$ Please review note below. FY2018 WATER DEPARTMENT - MGL Chapter 40 Section 5F FY2013 FY2014 FY2015 FY2016 FY2017 Contingency Water 3/23/2017 SPECIAL REVENUE FUND TOWN ADMINISTRATOR BOARD OF SELECTMEN FINANCE COMMITTEE EXPENDED EXPENDED EXPENDED EXPENDED APPROPRIATED RECOMMENDED RECOMMENDED RECOMMENDED FY2018 WATER DEPARTMENT - MGL Chapter 40 Section 5F FY2013 FY2014 FY2015 FY2016 FY2017 EQUIPMENT EXPENSE Additional Equipment -$ -$ -$ -$ -$ $ 9,500 $ 9,500 $ 9,500 Vehicles -$ -$ -$ -$ -$ $ 230,000 $ 230,000 $ 230,000 Well Repair & Maint -$ -$ -$ -$ -$ $ 80,000 $ 80,000 $ 80,000 Tank Repair & Maint -$ -$ -$ -$ -$ $ 250,000 $ 250,000 $ 250,000 Construction -$ -$ -$ -$ -$ $ 180,000 $ 180,000 $ 180,000 SUB TOTAL -$ -$ -$ -$ -$ 749,500$ 749,500$ 749,500$ GRAND TOTAL 1,023,871$ 1,038,171$ 1,064,805$ 1,075,651$ 1,175,446$ 3,022,097$ 3,022,097$ 3,022,097$ Vote 5-0-0 Vote 6-0-0 Note: Capital expenditures need to be updated once pricing has been received for a Dump Truck, Painting of Standpipe Tanks 1 & 2, and Construction for SCADA System Upgrade. Note: Scada & Tank Painting ($250,000 and $750,000 respectively) is subject to borrowing. Short term borrowing would occur in FY2018; Long term payment would be required in FY2019 going forward. Note: General Insurance is estimated at $58,000. The various line items will be populated once we receive the updated insurance policy. Note: Water revenue, expenditures, and debt service were previously included in the General Fund budget. FY2018 budget establishes spending limits based upon "worst case scenario" as opposed to conservative. Unforseen salary & expenditure appropriations are now included in budget. Water 3/23/2017 DEPARTMENTAL INDEX Year FISCAL YEAR 2016 CURRENT FISCAL YEAR 2017 FISCAL YEAR 2018 FISCAL YEAR 2019 FISCAL YEAR 2020 FISCAL YEAR 2021 FISCAL YEAR 2022 NOTES E. WATER DEPARTMENT 1. Water Construction Account*180,000$ 180,000$ 180,000$ 180,000$ 180,000$ 180,000$ 180,000$ 2. Loader/Backhoe*2006 130,000$ 2021 3. Pickup Truck 4 x 6 #1930*2005 55,000$ 4. Pickup Truck 4 x 2 #1970*2004 5. Service Van #1920*2004 50,000$ 6. Pickup Truck 4 x 2 #1990*2012 45,000$ 7. Pickup Truck #1950*2011 45,000$ 8. Pickup Truck #1900*2013 2024 -$40,000 9. 4 x 4 Truck #1980 2009 45,000$ 10. 6 x 2 Dump Truck #1960 1990 110,000$ 11. 4 x 4 Truck #1910 2006 47,000$ 12. Air Compressor*1987 30,000$ 13. Pump Replacement for Well No. 1*2000 40,000$ 14. Pump Replacement for Well No. 2*2003 40,000$ 15. Pump Replacement for Well No. 3*2011 40,000$ 16. Pump Replacement for Well No. 4*2011 40,000$ 40,000$ 17. Pump Replacement for Well No. 6 2013 2023 - $40,000 18. Well No.1 Cleaning Project*1971 40,000$ 19. Well No. 2 Cleaning Project*1971 40,000$ 20. Well No. 3 Cleaning Project*2011 40,000$ 21. Well No. 3 Treatment Plant 1972 3000000 22. Well No. 3 Electrical Service Replacement / Installation of Water Mains (Engineering)TBD 23. Well No. 3 Electrical Service Replacement / Installation of Water Mains 24. Well No. 4 Cleaning Project*2011 40,000$ 25. Well No. 6 Cleaning Project 2013 26. Tank No. 1 & Tank 2 Standpipe Rehabilation *2003 65,000$ 250,000$ 40,000$ Debt 27. Standpipe Asset Management Plan 28. Meter Reading Equipment*TBD 29. Water Main - Great Fields Road 450000 30. Water main - Red Top, North 420000 31. Transmission Main Black Duck 1200000 32. Pump Trailer #CD-150M 2002 33. Utility Trailer - flatbed shoring 1997 34. Trailer 2004 2024 TOWN OF BREWSTER FISCAL YEAR 2017-2022 CAPITAL PLAN Fiscal Year 2018 Adopted by the Board of Selectmen (TBD) Water 2/7/2017 Page 1 of 2 DEPARTMENTAL INDEX Year FISCAL YEAR 2016 CURRENT FISCAL YEAR 2017 FISCAL YEAR 2018 FISCAL YEAR 2019 FISCAL YEAR 2020 FISCAL YEAR 2021 FISCAL YEAR 2022 NOTES 35. Hole Hog 4"1987 10,000$ 36. Hole Hog 3"1987 37. Utility Cloud Technology 2015 38. SCADA Replacement Engineering Design 60,000$ 60,000$ 39. SCADA Replacement Construction 500,000$ 40. Mini Excavator 70,000$ 41. Drop Deck Tilt Trailer 9,500$ 42. Rte 6A Water Service Renewal SUBTOTAL WATER DEPARTMENT 325,000$ 512,000$ 1,249,500$ 275,000$ 310,000$ 345,000$ 225,000$ SOURCE OF FUNDS Year FISCAL YEAR 2016 CURRENT FISCAL YEAR 2017 FISCAL YEAR 2018 FISCAL YEAR 2019 FISCAL YEAR 2020 FISCAL YEAR 2021 FISCAL YEAR 2022 DEBT AUTHORIZATIONS N/A -$ -$ 750,000$ -$ -$ -$ -$ WATER FEES N/A 325,000$ 512,000$ 499,500$ 275,000$ 310,000$ 345,000$ 225,000$ PROPERTY TAXES / AVAIL. FUNDS N/A -$ -$ -$ -$ -$ -$ -$ GRANTS, GIFTS & CPA N/A -$ -$ -$ -$ -$ -$ -$ GRAND TOTALS OF REVENUES 325,000$ 512,000$ 1,249,500$ 275,000$ 310,000$ 345,000$ 225,000$ *Italics denotes forecast. Water 2/7/2017 Page 2 of 2 Fund 028 WATER DEPT:450 Water Department MGL CHP 40 Sec 53D Number of Positions in Department Full-time 13 Part-time 0 Seasonal 0 Temporary 0 Vacancies 0 New Positions Requested 0 TOTAL OF ALL POSITIONS 13 Position Avg Hours Per Week Bi-Weekly Salary / Hrly Rate Class & Step as of 6/30/17 (e.g., B -Step 3) Yearly Salary as of 6/30/17 COLA (Varies by Emp Group) Date of Hire FY 2018 Projected Salary Longevity Pay Education Pay Certification Pay Holiday Pay Other Total by Employee WATER SUPERINTENDENT 40.00 4175.55 Bylaw Grade 6 108,027 108,027 12/28/09 108,318 450 0 0 0 0 108,768 FOREMAN 40.00 29.94 OPEIU Grade 7 61,959 61,959 09/02/11 62,126 150 0 0 0 0 62,276 WTO CROSS 40.00 29.35 SEIU Grade 7 59,311 59,311 09/13/13 59,471 0 0 0 0 0 59,471 FOREMAN 40.00 27.86 OPEIU Grade 7 57,653 57,653 10/30/00 57,808 1,350 0 0 0 0 59,158 WATER SYSTEMS MAINT.40.00 26.42 SEIU Grade 3 54,685 54,685 05/17/99 54,832 1,500 0 0 0 0 56,332 SR. DEPARTMENT ASST.40.00 25.05 OPEIU Grade 6 51,842 51,842 06/20/16 51,981 0 0 0 0 0 51,981 LABORER 40.00 23.02 SEIU Grade 2 47,640 47,640 09/05/06 47,768 900 0 0 0 0 48,668 DEPARTMENT ASST.40.00 22.55 OPEIU Grade 4 46,679 46,679 11/08/10 46,804 300 0 0 0 0 47,104 LABORER 40.00 22.17 SEIU Grade 2 45,884 45,884 09/08/08 46,008 600 0 0 0 0 46,608 LABORER 40.00 20.48 SEIU Grade 2 42,393 42,393 04/01/14 42,507 0 0 0 0 0 42,507 LABORER 40.00 19.13 SEIU Grade 2 39,592 39,592 11/02/15 39,699 0 0 0 0 0 39,699 LABORER 40.00 19.13 SEIU Grade 2 39,592 39,592 12/28/15 39,699 0 0 0 0 0 39,699 DEPARTMENT ASST.35.00 20.84 OPEIU Grade 4 37,734 37,734 10/06/14 37,836 0 0 0 0 0 37,836 *OPEIU Contract in Negotiations 694,858 0 5,250 0 0 0 13,250 0 46,350 759,708 11,000 770,708 Salary Subtotal Medicare Total Personnel Services FY 2018 Personnel Spreadsheet Total Certification Pay Total Holiday Pay Total Other Pay (Stand-by Pay) Shift Differential Overtime Total Prorated Salary Total Seasonal Salary Total Longevity Total Education As of 1/25/2017 Town of Brewster - FY18 Budget Projection SPECIAL REVENUE FUND TOWN ADMINISTRATOR FINANCE COMMITTEE EXPENDED EXPENDED EXPENDED EXPENDED APPROPRIATED RECOMMENDED RECOMMENDED WAGES & BENEFITS: Full-time 5,625$ 32,625$ 33,943$ 35,278$ 36,383$ $ 36,340 $ 36,340 Health Insurance 471$ 6,033$ 6,141$ 6,753$ 2,775$ $ 8,778 $ 8,778 Life Insurance -$ -$ -$ -$ -$ $ 51 $ 51 Medicare Tax -$ -$ -$ -$ -$ $ 500 $ 500 SUB TOTAL 6,096$ 38,658$ 40,084$ 42,031$ 39,158$ 45,669$ 45,669$ GENERAL EXPENSES; Electricty 1,558$ 1,873$ 2,750$ 1,878$ 2,165$ $ 1,729 $ 1,729 Water Usage 594$ 564$ 682$ -$ -$ $ - $ - Heating Fuel 1,284$ 818$ 1,012$ 1,015$ $ - $ - Cable 2,120$ 2,830$ 3,338$ 3,698$ 3,700$ $ 4,035 $ 4,035 Trash Removal 908$ 1,388$ 1,156$ 1,546$ 1,231$ $ 1,231 $ 1,231 Repair & Maintenance 25,770$ 14,148$ 14,020$ 20,579$ 20,600$ $ 6,540 $ 6,540 Extraordinary Repair & Maint 43,518$ 57,344$ 16,458$ -$ 9,905$ $ - Property Insurance -$ -$ -$ -$ -$ $ 450 $ 450 Temporary Note Paydown -$ 10,000$ -$ -$ -$ $ - Temporary Note Interest 748$ 374$ 324$ -$ -$ $ - Contingency Reserve -$ -$ -$ -$ 122,226$ $ 18,346 $ 18,346 SUB TOTAL 76,500$ 89,339$ 38,728$ 28,712$ 160,842$ 32,331$ 32,331$ GRAND TOTAL 82,596$ 127,997$ 78,812$ 70,743$ 200,000$ 78,000$ 78,000$ FY2018 CROSBY MANSION - MGL Chapter 44 S53E 1/2 FY2013 FY2014 FY2015 FY2016 FY2017 Other Special Revenue 2/2/2017 Fund TBD / CROSBY MANSION DEPT:122 Crosby Mansion MGL CHP 44 Sec 53 E1/2 Number of Positions in Department Full-time 0 Part-time 1 Seasonal 0 Temporary 0 Vacancies 0 New Positions Requested 0 TOTAL OF ALL POSITIONS 1 Position Avg Hours Per Week Bi-Weekly Salary / Hrly Rate Class & Step as of 6/30/17 (e.g., B -Step 3) Yearly Salary as of 6/30/17 COLA (Varies by Emp Group) Date of Hire FY 2018 Projected Salary Longevity Pay Education Pay Certification Pay Holiday Pay Other Total by Employee PROPERTY MANAGER 25.25 27.74 PBL Grade 2 36,242 36,242 04/29/13 36,340 0 0 0 0 0 36,340 *OPEIU Contract in Negotiations 36,340 0 0 0 0 0 0 0 36,340 500 36,840 Medicare Total Personnel Services Total Holiday Pay Total Other Pay Shift Differential Overtime Salary Subtotal FY 2018 Personnel Spreadsheet Total Prorated Salary Total Seasonal Salary Total Longevity Total Education Total Certification Pay As of 1/19/2017 Town of Brewster - FY18 Budget Projection Vote 7-0-0 SPECIAL REVENUE FUND TOWN ADMINISTRATOR FINANCE COMMITTEE EXPENDED EXPENDED EXPENDED EXPENDED APPROPRIATED RECOMMENDED RECOMMENDED GENERAL EXPENSES; Professional Services -$ -$ -$ -$ -$ $ 20,000 Equipment -$ -$ -$ -$ -$ $ 75,400 Transfer to General Fund 76,750$ 112,947$ 65,000$ 66,300$ 97,626$ $ - GRAND TOTAL 76,750$ 112,947$ 65,000$ 66,300$ 97,626$ 95,400$ -$ SPECIAL REVENUE FUND TOWN ADMINISTRATOR FINANCE COMMITTEE EXPENDED EXPENDED EXPENDED EXPENDED APPROPRIATED RECOMMENDED RECOMMENDED GENERAL EXPENSES; Professional / Tech Services -$ -$ -$ -$ -$ $ 200,000 $ 200,000 Equipment -$ -$ -$ -$ -$ $ 139,000 $ 139,000 Transfer to General Fund 201,772$ 291,463$ 307,843$ 235,965$ 426,548$ $ - $ - GRAND TOTAL 201,772$ 291,463$ 307,843$ 235,965$ 426,548$ 339,000$ 339,000$ FY2013 FY2014 FY2015 FY2016 FY2017 FY2018 CABLE FRANCHISE - MGL Chapter 44 S53F 3/4 FY2018 TELECOMMUNICATIONS - MGL Chapter 44 S 53 E 1/2 FY2013 FY2014 FY2015 FY2016 FY2017 Other Special Revenue 2/2/2017 Recreation (PT)= Part time Employee Recreation Director Bylaw Grade 4 Recreation Commission Asst. Recreation Director Bylaw Grade 2 Asst. Town Administrator Pers. Bylaw Gr. V Program Coordinator Counselors (Qty 4)Pers Bylaw Fixed Rate Board of Selectmen Elected Town Administrator Appt.by Board of Selectmen Playground DirectorPers Bylaw Fixed Rate Sailing DirectorPers Bylaw Fixed Rate Waterfront DirectorPers Bylaw Fixed Rate Asst. DirectorPers Bylaw Fixed Rate Head LifeguardPers Bylaw Fixed RateAsst. DirectorPers Bylaw Fixed Rate InstructorsPers Bylaw Fixed Rate LifeguardsPers Bylaw Fixed Rate Youth LeaderPers Bylaw Fixed Rate Swim DirectorPers Bylaw Fixed Rate InstructorsPers Bylaw Fixed Rate Youth LeaderPers Bylaw Fixed Rate SPECIAL REVENUE FUND TOWN ADMINISTRATOR FINANCE COMMITTEE EXPENDED EXPENDED EXPENDED EXPENDED APPROPRIATED RECOMMENDED RECOMMENDED WAGES: Full-time 39,731$ 41,291$ 42,959$ 47,395$ 46,047$ $ 45,995 $ 45,995 Temp/Seasonal 23,694$ 46,789$ 40,145$ 48,036$ 42,841$ $ 43,914 $ 43,914 Longevity 150$ 300$ $ 450 $ 450 Health Insurance 5,115$ 11,439$ 14,709$ 16,176$ 17,625$ $ 19,387 $ 19,387 Medicare Tax $ 1,300 $ 1,300 SUB TOTAL 68,539$ 99,519$ 97,813$ 111,756$ 106,812$ 111,046$ 111,046$ GENERAL EXPENSES; R & M Ballfields -$ 67$ 628$ -$ 600$ $ 600 $ 600 Facility Maintenance 1,332$ -$ -$ 116$ 116$ $ 116 $ 116 Baseball / Softball 1,511$ -$ 189$ 114$ 190$ $ 190 $ 190 Skateboard Park -$ -$ -$ -$ -$ $ - $ - Meetings/Conferences -$ -$ -$ -$ -$ $ - $ - In-State-Travel -$ -$ -$ -$ -$ $ - $ - Playground 13,076$ -$ -$ -$ -$ $ - $ - Office Expense 2,774$ 1,742$ 1,510$ 5,059$ 5,100$ $ 5,100 $ 5,100 Office & Rec Supplies 9,540$ 8,496$ 4,475$ 4,301$ 4,475$ $ 4,475 $ 4,475 Youth Soccer 710$ -$ 1,343$ -$ 1,345$ $ 1,345 $ 1,345 Youth Basketball 4,511$ 1,781$ 446$ 788$ 790$ $ 790 $ 790 Boat Maintenance -$ -$ -$ -$ -$ $ - $ - Seasonal Programs 17,814$ 28,566$ 16,875$ 13,323$ 13,350$ $ 13,350 $ 13,350 Swim 116$ 1,112$ 1,734$ 2,892$ 2,900$ $ 2,900 $ 2,900 Office Maintenance -$ -$ -$ -$ -$ $ - $ - Credit Card Expense 1,447$ 2,837$ 2,558$ 2,801$ 2,800$ $ 2,800 $ 2,800 School Vacation Expense 150$ -$ -$ -$ -$ $ - $ - Special Events 3,537$ 4,109$ 1,879$ 1,612$ 1,880$ $ 1,880 $ 1,880 Summer Tennis 3,544$ 4,077$ 5,588$ 6,441$ 6,450$ $ 6,450 $ 6,450 Sailing Program 1,240$ 1,276$ 844$ 2,338$ 2,340$ $ 2,340 $ 2,340 Yoga 1,310$ 4,059$ 3,291$ 2,394$ 2,400$ $ 2,400 $ 2,400 Youth Sports -$ -$ -$ -$ 48,452$ $ 13,250 $ 13,250 SUB TOTAL 62,612$ 58,121$ 41,360$ 42,177$ 93,188$ 57,986$ 57,986$ GRAND TOTAL 131,151$ 157,640$ 139,173$ 153,934$ 200,000$ 169,032$ 169,032$ FY2017 FY2018 RECREATION - MGL Chapter 44 S 53 E1/2 FY2013 FY2014 FY2015 FY2016 Other Special Revenue 3/3/2017 DEPT:630 Number of Positions in Department MGL CHP 44 Sec 53 E1/2 Full-time 1 Part-time 0 Seasonal 6 Temporary 0 Vacancies 0 New Positions Requested 0 TOTAL OF ALL POSITIONS 7 Position Avg Hours Per Week Bi-Weekly Salary / Hrly Rate Class & Step as of 6/30/17 (e.g., B -Step 3) Yearly Salary as of 6/30/17 COLA (Varies by Emp Group) Date of Hire FY 2018 Projected Salary Longevity Pay Education Pay Certification Pay Holiday Pay Other Total by Employee ASST. REC DIRECTOR 35.00 1773.07 Bylaw Grade 2 45,871 45,871 10/13/08 45,995 450 0 0 0 0 46,445 SEASONAL INSTRUCTORS Varies 15.00 0 0 N/A 43,914 0 0 0 0 0 43,914 *OPEIU Contract in Negotiations 45,995 43,914 450 0 0 0 0 0 0 90,359 1,300 91,659 Salary Subtotal Medicare Total Personnel Services Total Certification Pay Total Holiday Pay Total Other Pay Shift Differential Overtime FY 2018 Personnel Spreadsheet Recreation Total Prorated Salary Total Seasonal Salary Total Longevity Total Education As of 2/22/2017 Town of Brewster - FY18 Budget Projection