Loading...
HomeMy WebLinkAbout2011-03-23 Finance Committee PacketThe Town of Reading - FINCOM budget meeting http://www.readingrna.gov/Pages/ReadingNIA_MeetingCal/SO1689C5... r 1 t ~ ~pll , ~ Z 1 1ct -y Home Residents . Businesses FINCOM budget meeting Wednesday, March 23, 2011 at 7:00 PM RMLD conference room Printer-Friendly Version Public Works Capital Debt Benefits Enterprise Funds Google Search C« ,kl,v,JN CAUSE COMMO^' CAU`~ Town of Reading, Massachusetts 16 Lowell Street, Reading, MA 01867 Website Disclaimer Virtual Towns & Schools Website 1 of 1 9/17/20112:29 PY. Ali, Retirement Myth "The Town of Reading is generous to employees by offering a pension system." t"? Retirement Myth "The Town of Reading is generous to employees by offering a pension system." Retirement Fact Retirement Myth "%blic Pension System Employees already get a good retirement benefit from social security." This is in accordance with the requirements of MA state law. Eligible Teachers belong to the MA Teachers' Retirement System and eligible other employees belong to the Reading Contributory Retirement System. k Retirement Myth public Pension System Employees already get a good retirement benefit from social security." Retirement Fact In Massachusetts, public sector employees are not eli ible for social security benefits, unless they qualified in the private sector from another job. If so, they will lose 55% of their first tier social security benefits (about $4,500/year). Retirement Myth "The Public Pension System is Free for Public Employees, and the cost is borne by the taxpayers." Employee Contribution for Active Members Contributions by Employees hired • 1996-2009 9% of their pay plus 2% of pay over $30,000 SSI 6.2% • 1984 to 1996 8% of their pay plus 2% of pay over $30,000 SSI 5.7% • 1975 to 1984 7% of their pay plus 2% of pay over $30,000 SSI 4.9% to 5.4% • Before 1975 5% of their pay ssI 1.0% to 4.8% 'V Retirement Myth "The Public Pension System is Free for Public Employees, and the cost is borne by the taxpayers." Retirement Fact Today, Reading employees hired under age 30 that stay for 25 years will through a payroll deduction plus actuarial investment return assumptions pay more than the expected value of their retirement benefits. ellb, System Cost for Active Members Contribution as a percentage of payroll for active employees Town operations only (no enterprise funds) -Total Required Contribution* 15.1% • Employee Contribution 9.0% • Town Contribution 6.1% Comparison to Social Security -Total Social Security Contributions 12.4% • Employee Contribution 6.2% • Employer Contribution 6.2% -Note the Employee share is increasing and the Town share is decreasing 2 € Retirement Myth "While the current rules have changed, I wish I was a typical Reading Retiree. I'd be living on Easy Street." Reading Contributory Retirement System • Membership required for all employees 1690+ hrs/yr (32.5/wk) • Teachers covered by separate MA Teachers system • Public Employee Retirement Administration Commission • MGL Ch. 32 establishes/go'verns local retirement boards • Reading Retirement Board - 5 members • Retirement eligibility: - Age 55 or older with minimum 10 years of service - Any age with minimum 20 years of service • Benefits based on combination of age + service • Pension Reserves Investment Trust Fund - all State, Teachers and local systems that choose (or are forced) to invest Retirement Myth "While the current rules have changed, I wish I was a typical Reading Retiree. I'd be living on Easy Street." Retirement Fact In 2009 (the date of the last actuarial study) the average Town of Reading retirement pension paid was $22,224. As of February 2011, the pension payout distribution is: 38% $ 0 to $12,000 41% $12,000 to $30,000 17% $30,000 to $50,000 4% $50,000 to $85,000 Membership • Active members by Department: • Town and School 256 • RMLD 76 • Enterprise & Other 24 • Total 356(53%) • Retirees by Department: • Town and School 250 • RMLD 57 • Enterprise & Other 10 • Total 317(47%) 3 ~ku° System Cost for Active Members Contribution necessary to meet the actuarially determined retirement amount for current employees Town' operations only (no enterprise funds) • Total 2009 contribution required* $ 2,111,003 • Employee contributions $1,267,224 • From Town General Fund $ 843,779 General Fund 2009 pension assessment $2,653,102 • To fund current employees $ 843,779 • To fund retired employees $ 1,809,323 *Nate the Employee share is Increasing and the Town share is decreasing Savings Accumulated for Active Members and Retirees Reading System - Projected to be fully funded in 2028 (requirement is by 2040); Mass plans were not actuarially funded for the first 40 years; Despite the 2008 financial Collapse, as of June 30, 2009 • 36% of Mass Retirements Systems are over 75% funded • 93% of Mass Retirements Systems are over 50% funded. Savings Accumulated for Active Members and Retirees • System Totals at June 30, 2009 • Actuarial determined Liability $121,918,411 • Accumulated Savings $ 83,167,202 • Unfunded Liability $ 38,751,245 • Percent Funded at June 30, • 2005 69.96% • 2007 75.69% • 2009 68.22% Massachusetts Teachers' Retirement System (MTRS) • Employees must meet 4 eligibility criteria in order to participate in Mass Teachers' Retirement System: - Position - Certification - Contract - Status • M.G.L. Chapter 32, Sec 1 defines "Teacher" to also include the following: - School Social Worker, Adjustment Counselor, Psychologist - Principal or Assistant Principal - Superintendent or Assistant Superintendent 4 Massachusetts Teachers' Retirement System (MTRS) • MTRS Retirement Benefits are based on 3 factors: age on retirement date, years of creditable service, and average of your highest 3 consecutive years' salaries • Retirement Eligibility: - 20 years of creditable service, regardless of age, or - at least age 55 plus 10 years of creditable service • MTRS contribution rate is 11%. This contribution is made by the employee with no contribution made by the school or town. Dz= 2009/2010 Retirement Reforms • Employees who make less than $5,000 annually do not get any creditable service; • Dual System wages are not longer added together to calculate a benefit. The benefit from each position is calculated separately; • Accidental Disability Pensions will be based on 12 month avg. before the disability, not the pay on the day of the injury; • Elected officials are no longer eligible for Termination Allowance benefits if they do not get re-elected; • Consulting and Independent Contractor work is subject to the Post Retirement Earnings limitation of 960 hours or the difference between retirement benefit and the pay of the job the employee retired from; • Earnings subject to retirement will be capped. O Other Post Employment Benefits • OPEB = Liability for the cost of health insurance or other benefits for retirees - Retirement eligibility: 32.5+ hrs/wk - Health insurance eligibility: 20+ hrs/wk • Actuarial Liability as of June 30, 20D8 is $87,562,273; • Ch 32B sec 20 - A city, town, district, county or municipal lighting plant that accepts this section, may establish a separate fund, to be known as an Other Post Employment Benefits Liability Trust Fund, and a funding schedule for the fund; • Funds shall be invested and reinvested by the custodian consistent with the prudent investor rule set forth in chapter 203C. 2011 Proposed Retirement Reforms • Raise earliest retirement age from 55 to 60 and full benefit age from 65 to 67. Group 4 (Public Safety employees) would change from earliest retirement age from 45 to 50 and full benefit.age from 55 to 57; • Use 5 highest years pay for benefit calculation Instead of 3; • Eliminate Termination Early Retirement benefit for people who were terminated through no fault of their own; • Pro-rate benefits for people who move amongst Groups based on time spent employed in the Group; e Implement "Anti-spiking " Rules. Last 2 years of pensionable earnings cannot increase more than 7% plus inflation; • Eliminate "Double-Dipping" for elected officials. They can no longer collect a pension while being paid for service as an elected official. 5 a: ft, Health Insurance Myth "The Town of Reading is generous to employees by offering health insurance." Health Insurance Myth "The Town of Reading is generous to employees by offering health insurance." Health Insurance Fact MGL Chapter 32B sets the requirements the Town must follow in administering health and life insurance programs to eligible employees and retirees and their spouses and dependents. Reading accepted this Chapter on March 4, 1957. 91 Health Insurance Myth "Health Insurance is Free for Public Employees and the cost is borne by the taxpayers." ~ 011 Health Insurance Myth "Health Insurance is Free for Public Employees and the cost is borne by the taxpayers." Health Insurance Fact Employees and Retirees pay 29% of the premium costs through payroll deductions. In addition, several plan changes have been made in recent years to reduce the cost of premiums and shift additional out-of- pocket expenses to the employees. * Surrounding Towns l 2011 survey by Stoneham Board of Selectmen • Average employee share Is 25% of Towns surveyed; • In all cases the employee share used was the highest if the share changed among different products. For example in one Town - HMO employee pays 20% - enrollment is 50% - PPO employee pays 30% - enrollment is 50% - Avg employee pays 25%, but in the survey this Is reported as 30% • Maximum Employee/Retiree share by state law is 50% • Three lowest employee shares are all in the GIC (Saugus 10%, Melrose 13% and Stoneham 15%) ~kffi Health Insurance Myth "The Town of Reading should change to the State GIC and save a substantial amount of money." Health Insurance Fact We investigated all of the options a few years ago, and a new three-tiered "GIC-like" program offered by MIIA was the cheapest option for the Town. Reading became the first participant in this plan, and spent nearly $600,000 less in premiums than had been budgeted as if no changes occurred. Health Insurance Myth "The Town of Reading should change to the State GIC . and save a substantial amount of money." =4011 Comparison with the GIC FYi2 Full Monthly Cost GIC Tufts Health Navigator Ind: $590 Fam: $1,440 Preventative: $0 Specialists: $25, $351 $45 Emerg. Room: $100/visit Inpatient: $300, $700 Prescription Drug Retail: $10, $25, $50 Mail-in: $20, $50, $110 FY11 Full Monthly Cost SCBS HMO Network Blue Ind. $569 Fam: $1,525 Preventative: $10, $15, $20 Specialists: $25 Emerg. Room: $50/visit Inpatient: $200, $400 Prescription Drug Retail: $10, $20, $40 Mail-in: $20, $40, $90 2 0 Comparison with the GIC Key: What does the Town's share of the premiums cost? Three GIC communities surveyed pay 87.3% of GIC premiums: Cost to communities: Ind. $515 Family: $1,257 Reading pays 71% of BCBS premiums: Cost to Town: Ind. $458 Family: t1.229 (assume M2 is +13.5% vs. FY11 on previous slide) OD Health Insurance Myth "Health Insurance is a Municipal budget-buster." Health Insurance Fact This myth is true!! In FY11, Reading spent 10% of it's budget on health insurance and the national 9% annual increase is not affordable given the Town's revenue constraints. However, we are not alone Health Insurance Myth "Health Insurance is a Municipal budget-buster." V M What percent of your FY11 budget is health insurance? February 2011 survey by Stoneham Board of Selectmen Peabody 20% Walpole 12% Beverly 17% Canton 121/6 Wakefield 16% Newburyport 12% Melrose 14.6%(GIC) Wilmington 10.6% Tewksbury 14% Amesbury 10% Stoneham 13.5%(GIC) Belmont 10% Saugus 115%(GIC) North Reading 10% Sudbury 13.2% Reading 10.0% North Andover 12.9% Bedford 7.9% Wayland 12% Ipswich 7.9% The average without Reading was 12,6%, while Reading is 'only'at 10.0%, Ir Reading were at the average, we would spend another $1.9 million per year. del; Reading Heal th Insurance Rec ent History FYI 1 +9,5% +10.5% +4.9% 10.0% 9.5% 10.1% 9.1% 8.7% Background: MGL Chapter 32B • MGL Chapter 32B sets the requirements the Town must follow in administering health and life insurance programs to employees and retirees and their spouses and dependents; • Employees who regularly work 20 or more hours/week are eligible for health and life Insurance (for school employees it is 20 or more hours/week during the school year); • Employees enrolled in the health insurance program who retire may continue in the program; • If a retiree passes away, the surviving spouse may continue in the health Insurance program; • If an employee is not in the health insurance program at the time of retirement, there are restrictions on when he/she can enroll in the program. Premiums HMO PPO Medex FY12 +5.7% projected +13.5% +13.5% FY10 -2% -22% to - +1.9 (3•tlerj 27% Mdx2 Mdx3 FY07 +4.9 % +4.9% +2.9% bid) 0- Health Ins. % of Budget 11.3% Reading Health Insurance Recent History Premiums (annual rate FY06-FY11) HMO +4.4% PPO -0.2% Medex +3.2% Weighted average +3.2% Enrollment (annual) +23% Budget Cost (annual) +5.5% m1-101 _ Background: MGL Chapter 32B • Requiring MGL Ch. 328 Section 18 is a major point of the recent Governor's proposal to help communities save money; • Town Meeting in Reading already voted to accept this Section on April il, 1994; • Section 18 requires retirees who are eligible for Medicare to enroll in Parts A and B and then the Town offers a supplement to Medicare; • Employees Bc retirees hired after March 1986 are in Medicare. Both the employee and Town make contributions, just as in the private sector; • If a retiree is not eligible for Medicare, he/she would continue in the current plan (i.e. HMO or PPO). 4 . Background: MGL Chapter 32B February 2011 survey by Stoneham Board of Selectmen • Communities already requiring retirees to join Medicare: Amesbury, Bedford, Belmont, Beverly, Canton, Melrose, North Andover, North Reading, Peabody, Reading, Saugus, Stoneham, Sudbury, Tewksbury, Wakefield, Walpole, Wayland and Wilmington; • Communities NOT requiring retirees to join Medicare: Ipswich and Newburyport. Background: MGL,Chapter 32B • Another major point of the recent Governor's proposal to help communities save money is to force a 45-day negotiations window on unions & municipalities. A lack of agreement would force communities into the state-run GIC program if they do not have a substantially similar plan (however that is determined); • Town management supports efforts to have the right of plan design without bargaining - as the state itself enjoys; • Town management and all the unions from the Schools, RMLD and the Town have a very collaborative working relationship and have negotiated several changes to plan design over the past several years. Background: MGL Chapter 32B • MGL Ch. 32B Section 19 creates a Public Employee Committee (PEC) consisting of a representative from each bargaining unit in the Town, School Dept. and RMLD, plus one retiree; • Board of Selectmen accepted this Section on Jan. 11. 2005; • The Town is required to negotiate with the PEC on the pap design and cost sharing of the health insurance program; • No individual union may negotiate over health insurance; • The retiree member of the PEC has a 10% vote. The remaining 90% is divided between the 14 bargaining units based on the number of employees eligible for health' Insurance. Non-union employees do not vote; • Any agreement must be approved by 70% of the PEC. Q Life Insurance • Eligible employees can purchase a $5,000 term life insurance policy for $100.20/year with the Town paying 50% of the cost; • Currently the Town's share is under $40,000/year; • Employees can purchase additional life insurance for themselves, spouses and dependents, but the Town does no ,contribute to any of the premiums; • Employees enrolled in the life insurance program who retire can continue in the program with some restrictions; • The Town continues to pay 50% of the premium for the $5,000 policy for retirees. 5 C=6 C= Other Benefits • Disability insurance is available to some School employees through the MTA. There is no disability Insurance available to Town employees; • Dental Insurance is available to active eligible employees but the Town does no contribute to the premium; • Town and School employees can contribute to deferred compensation plans (403b and 457) to save for retirement; • Paid time off benefits such as sick, vacation, and floating holidays/personal days are available to eligible employees; • Some employees are eligible for sick leave buyback, but caps on the amount and eliminating it for new hires after a certain date is common. For example, in one union contract no one hired after 7-1-04 is eligible for sick leave buyback. FINCOM QUESTIONS - March 23, 2011 BENEFITS 1. 1 have many questions about the assumptions that went into the benefits figures, including the assumptions related to contract negotiations. 2. If we were to go to bid for health and life, would this be effective 2013? Yes - FYI 3. 3. Can you clarify the 3.3% per year being solely from added enrollment. Does that mean the per employee cost of healthcare has not risen in the past 4 years? Over a longer five-year period, the budget has increased 5.5%. Enrollment has run at +2.3% per year over that period - the balance is the increase in costs. From the presentation you will see that is composed of HMO +4.4%, Medex+3.2% and PPO -0.2%. 4. With regards to the health insurance, which is, certainly the biggest issue as you have,pointed out on more than one occasion, it would be helpful if there was a table that could be provided that would show the town's vs. employee expense share for Reading, and surrounding or like towns (75% Town, 25% Employee for Reading). You may have already done this in preparation or for other meetings. Survey in the presentation suggests 75% average Town share versus 71% in Reading. However due to methodology; the 75% figure has been understated in Town that pay different percents for different programs. Therefore Reading pays a.below average share - but it is difficult to say precisely how much. 5. What is the current average pension paid? It is hard to compare today's distrib to the average in 2009. Today it is $23,166. The distribution has been changed to match the $22,224 average from the actuarial study (2009). 6. What is the breakout between Town and School for Active and Retiree groups? Well get back on this one. 7. Health slides - would really benefit from some of these same types of slides including: a. What % of costs do employees pay in neighboring towns (did Stoneham survey this?) See Question 4. b. Comparison to private sector healthcare. split between EE/ER. Not sure how to do this - welcome any suggestions. c. Participation and cost splits between current EE / retiree & Town/School/Enterprise/RMLD d. Contribution of costs as a % of current payroll In the presentation. e. Comparison of costs for MIIA plan vs GIC plan In the presentation. 8. What are the ramifications of not fully funding the retirement obligations at this time, and await the rebound in the financial markets that took place last year and should continue to take place this year? Didn't know what penalties, if any, we would incur, or whether or not that would affect the town's rating. We wouldn't close the gap as quickly as 2028, and further the Retirement Board has case law to force the Town to make at least the same contribution as from the prior year (and possibly more). It would probably result in a downgrade of our debt ratings. FINCOM QUESTIONS - March 23, 2011 OTHER 9. There was a police detail in front of Danvers Savings Sat. and the officer was standing behind the barriers closing the road. It did not seem apparent that there was a need for an officer to be present during construction. Is this paid for out of the Towns DPW budget? Are there any plans to reduce these overtime expenses? Are there contractual or regulatory requirements that police details be present or is it a safety judgment call on the part of the police? Regarding the detail work on Saturday,question #1. That was a private detail hired by Danvers Bank, they apparently had a sewer issue that required them to work on the repair themselves. I believe at one point there was a question about the pipe and they did have a DPW worker on site for a consultation. That particular detail was completely paid for by Danvers Bank. In regards to the other parts of the question, the DPW and I work together to assess public safety issues with directing traffic vs. blocking roads. Jeff and his division heads are.very cognizant about the costs of details and trying to ensure that they are needed. There are police contractual issues regarding directing traffic. The Reading Police is the only entity that will do traffic control, per contract. It will be up to Jeff and Myself to determine the need and necessity for the safety of the workers and the motoring public. If there are any other questions please fell free to contact me. Jim 1 would concur with Jim's comments. As you know all division supervisors have a limited line item amount for police details, so as such, use these funds as judiciously as possible. It is strictly a safety issue. Without question, we use detail officers for traffic control when working on any major, high traffic volume streets. On side roads, dead ends, etc. it becomes a judgment call whether we need a detail officer or not, or if it becomes appropriate to simply block off, or detour a street (resident access only). The chief and I do work very well and closely on this, keeping the safety of all employees and the driving public as our top priority. Please let me know if you have any further questions. Jeff FINCOM QUESTIONS - March 23 2011 10. 1 would recommend the Snow be raised in light of the stress on free cash anticipated but believe Marsie may have already submitted this. Open for discussion. 11. Will we get regionalization and other zoning financial benefits Wed.? Yes - see handout 3123/11. 12. Can you clarify the Worker Comp 6.6% vs. the 20% increase anticipated. Yes - combination of 5% discount plus substantially less recent claims history. 13. Remind me how Causeway Road $280,000 is being financed? Free cash appropriation at last November Town Meeting - being repaid as a betterment by residents affected. What is the total being budgeted on roads vs. the estimated amount that would be needed to keep roads from deteriorating on average. To Maintain our road condition we would need to spend $860,000 and increase-the amount every year by $50,000. This will keep our roadway condition index at 75 to 74 over an 8 year period. To Improve our road conditions we would need to spend $1,200,000 and increase 4% per year. This will increase our pavement index form 75 to 81 over an 8 year period. 14. What makes motorizing the RMHS bleachers a priority? 15. For the Projected Use of R/E Funds can you remind me what the assumptions are in the spend rate of $300,000 and declining $50,000 per year. Declining usage based on weaning off the use of this to support capital. Can you clarify the total cost of the West Street Reconstruction and the Towns estimated cost ($475,000?). Are there any variables that could cause Town costs to go any higher? West Street - Total not including current 36k Eng amendment - $ 400,000 (this cost is far form being etched in stone at this time) Current Construction Estimate- Total project cost $ 7,907,254 of that amount it is estimated that the town's share non-participating items could be $250,000 (the value of non-participating items is based on actual bid costs when it occurs. These are items the state will not pay for and we are billed directly from the contractor. At the present time the estimates have not advanced far enough to provide a good estimate of these costs. The amount is an estimate based on Main St prices) Additional Engineering Costs - In the process of an amendment for $36,000. Will need additional $150,000 to complete to 100% design and provide bidding\construction services. Variables - Actual construction costs: Unforeseen extras which will increase consultant fees (Consultant fees during construction are typically for review of shop drawings. However if a problem arises the state will call the consultant in to review issues. Delays - The longer it takes to get the project out to bid, construction costs rise. Design changes between now, and time of bid requested by state. Changes in states eligible non participating items philosophy. 16. What is the average homeowner bill increase to transfer the engineer to the storm water enterprise fund? Without the engineer the suggested fee would have been unchanged at $40 for a single family home, and some reserves would have been generated, as it has in the past. The FYI 2 budget - including the engineer - is less than it was in FYI 1. As a % of the budget, the engineer is 13.8%. Public Works - Enterprise Funds FYl2 Budget Overview The Board of Selectmen will vote on new water, sewer and storm waters rates at an upcoming hearing prior to Town Meeting. This budget assumes no use of reserves to offset the costs of running these funds. Adjustments to these budgets will be needed in the event reserves are used. The new rates will be effective with the September 2011 billing. Storm Water Enterprise Fund The Storm Water division consists of some activities conducted under the general fund budget, and some in the enterprise fund budget. As a whole, they are responsible for the construction, maintenance and repair of all catch basins and drainage systems. As established by. Town Meeting several years ago, this Enterprise Fund conducts storm water activities that were not being done by the general fund. Federal regulations continue to bring new and expensive costs to the 'Town. During the past year, more than one FTE engineer has worked on these new regulations, and as was suggested a year ago, one FTE engineer has been transferred from the general fund into this enterprise fund. If this new work was not here, the position would have been eliminated by the general fund budget. Some drainage work previously classified as capital has been moved into the operating budget because it is considered annual general maintenance.. The $40 annual charge for a single family home will not need to change to support the FY12 budget. In FY11 $20,000 of reserves were used in the budget, but none are needed for FY12, leaving the reserve fund at approximately $275,000. Two large scale ($4.0 million Saugus River & $2.2 million Aberjona River) capital projects that have been in the Storm Water capital improvements plan since inception now are closer -to becoming reality. If these projects commence as scheduled, the $40 charge for single family homes will climb to $80 as the first third of this work begins. This budget does not yet forecast that new federal requirements will add any additional large scale projects. The chart below summarizes the FY12 budget: Storm Water Enterprise Fund Wages $127,765L+82%) Expenses $.58,885(+198%) Debt & Ca ital $190,000(-34%) Other none Gross budget $376,650 -0.3% Reserves $ 0 TBA Net budget $376,650(+5.5%) 03/19/2011 10:49 TOWN OF,READING blelaeheur INEXT YEAR.BUDGET HISTORICAL COMPARISON PROJECTION: 20122 FY2012 Enterprise Funds ACCOUNTS FOR: PRIOR FY3 PRIOR FY2 LAST FY1 STORM WATER MANAGEMENT ACTUALS ACTUALS ACTUALS IPG 6 b9nyrpts FOR PERIOD 99 CY CY REV PROJECTION PCT ACTUALS BUDGET LEVEL 3 CHANGE 0428 STORM WATER MANAGEMENT 03 SALARIES N 65003511 511417 65003511 511453 65003511 515000 65003511 516050 TOTAL SALARIES 05 EXPENSES LABORER AST CV ENG OVERTIME OUT OF GRA 65005519 519700 RETIREMENT 65005524 524428 DRAINMAINT 65005527 527301 EQUIP RENT. 65005530 530000 OUT PRFSVC 65005530 530110 LEGAL COUN 65005554 554000 CLOTHING 65005574 574.000 HEALTH INS TOTAL EXPENSES 08 CAPITAL EXPENDITURES 65008585 585000 ADDTNL EQU 65008588 588412 DRNGE IMPR 65008588. 588421 MAPPING DE_ 65008588 588425 DRAINAGE 65008588 588430 SAUG RIV D TOTAL CAPITAL EXPENDITURES 09 OTHER FINANCING USES 65009596 596500 XFERTO ENT TOTAL OTHER FINANCING USES TOTAL STORM WATER MANAGEMENT TOTAL STORM WATER MANAGEMENT GRAND TOTAL 57,226.64 67,122.77 68,695.19 47,765.79 70,076.00 71,615.00• 2.2% .00 .00 .00 .00 .00 52,150.00 .0% 1,421.57 2,416.89 2,491.57 458.04 .00 2,500.00 .0% .00 143.44 699.52 1,204.88 .00 1,500.00 .0% 58,64B.21 69,683.10 71,886.28 49,428.71 70,076.00 127,765.00 82.316 .00 2,310.00 2,412.00 847.00 847.00 885.00 4.5% .00 .00 .00 .00 .00 25,000.00 .0% .00 .00 .00 .00 7,803.00 7,000.00 -10.3% 4,595.00 4,964.14 .00 1,863.00 10,200.00 10,000.00 -2.0% .00 202'.50 .00 .00 .00 .00 .0% 440.86 374.68 800.00 800.00 900.00 1,000.00 11.1% .00 .00 .00 .00 .00 15,000.00 .0% 5,035.86 7,851.32 3,212.00 3,510.00 19,750.00 58,885.00 198.2% 95,690.08 .00 126,488.36 151,818.00 173,000.00 156,000.00 -9.8% .00 .00 .00 .00 55,000.00 .00 -100.0% .00 50,000.00 .00 .00 .00 40,000.00 .0% 14,780.96 13,910.00 31,418.21 4,209.34 60,000.00 .00 -100.0% .00 150,000.00 .00 .00 .00 .00 .0% 110,671..04 213,910.00 157,906.57 156,027.34 288,000.00 196,000.00 -31.9% .00 .00 200,000.00 .00 .00 .00 .0% .00 .00 200,000.00 .00 .00 .00 0% 355.11 174 291,444.42 433,004.85 208,966.05 377,826.00 382,650.00 1.3% , 174,355.11 291,444.42 433,004.85 208,966.05 377,826.00 382,650.00 1.3% 9,376,280.06 10,069,098.31 11,056,163.90 7,656,257.22 11,284,841.28 11,612,254.00 2.9% END OF REPORT - Gen erated by Bob LeLacheur MA Town of Reading Approved Requested . Projected , 31191201111:14 FY-2011 FY-2012 FY-2013 FY-2014 FY-2015 FY-2016 FY-2017 FY-2018 FY-2019 FY-2020 FY-2021 TOTAL Existing debt in green, new debt in yellow FY12-21 Public;Rrorlis?'StormRrater CAPTf 288,000: 9o,00D ;.:.200000 " 150,000 150,000 158500,. , t'100;000 ]00;000 400000 10.0;000 100,000 1;340,500 General Drainage Cash 60,000 move to Operating Budget Drainage improve (Project specific) Cash 55,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 800,000 MS4 Permit- Consult & Lab Testing Cash 40,000 50,000 50,000 50,000 190,000 Saugus River Improvement (I) 2.Omil Debt Debt Debt Debt Debt Debt Debt Debt Debt Saugus River Improvement(II) 2.0 mil Debt Debt Debt Debt Debt Debt Debt - Aberjona River Design cash 150,000 150,000 Aberjona River Improvement 2.2mi1 Debt Debt Debt Debt Debt - Sweeper: Elgin Pelican cash 150,000 150,OOD Truck. Int. #15 Cash 173,000 - TAKEUCHI Excavator (1985) Cash 58,500 58,500 W 2 Budget Town of Reading FY - 201 3/2011113:54 New - Not A roved in italics . Approved Debt Service FY 2011 Requested Debt'Servic FY 2012 Projected Projected Projected Debt Service Debt Service Debt Service FY -2013 FY - 2014 FY 2015 Projected Debt Service FY - 2016 Projected Debt Service FY 2017 Projected Debt Service FY - 2018 Projected Debt Service FY 2019 Projected Debt Service FY - 2020 torm": titer un _ $..:330;000 $ ;r317,000;;?$: 634,000. $`-':608,000°:=$ <945;000. $ :904,700 $ 864,400 Sau us River lmr ovement! 2.0 mil new 0 0 0 330,000 317,000 304,000 291,000 278,000 265,000 252,000 Saugus River Imp ovement II 2.0 mil new 0 0 0 0 0 330,000 317,000 304,000 291,000 278,000 Aber'ona River Improvement 2.2 mil new 0 0 0 0 0 0 0 363,000 348,700 334,400 Repayment of Principal: 0 . 0 0 200,000 200,000 400,000 400,000 620,000 620,000 620,000 Sau us River Imp ovement I 2.0 mil 10 r 200,000 200,000 200,000 200,000 200,000 200,000 200,000 Saugus River lmr ovement!/ 2.0 mil 10 r 200,000 200,000 200,000 200,000 200,000 Aber'ona River Improvement 2.2mit 10 r 220,000 220,000 220,000 Interest on Lon Term Debt: 0 .0 0 130,000 117,000 234,000 208,000 325,000 284,700 244,400 Saugus River tm ovement!) 2.0mit 10 r 130,000 117,000 104,000 91,000 78,000 65,000 52,000 Saugus River lmr ovement!!) 2.0mit 10 r 130,000 117,000 104,000 91,000 78,000 AbejonaRiver _Improvement 2.2 mil 10r - 143,000 128,700 114,400 -P Town of Reading FY - 2012 Budget 312011113:54 Projected Projected, Projected Projected Projected Projected Projected Projected ' Debt Service Debt ServiceDebt ServicEDebt ServiceDebt ServiceDebt ServiceDebt ServicOebt Service New - Not A raved in italics FY - 2021 FY 2022 FY - 2023 FY - 2024 FY 2025 FY - 2026 FY - 2027 FY 2028 torm ater un $ ' 9?4,100 783;800_ 743500 $ 503 200 475 900.: $:248,600 $ Z34;300- Saugus River lmrpovement(l) 2 0 mil new 239,000 226,000 213,000 0 0 0 0 0 Sauqus River lmrpovement(II) 2.0 mil new --'265,000 , 252,000 239,000 226,000 213,000 0 0 0_ . AberlonaRiverImprovement 2.2 mil new 320,100 305,800 291,500 277,200 262,900 248,600 234,300 0 Repayment of Principal: 620,000 620,000 620,000 420,000 420,000 220,000 220,000 0 Sauqus River lmrpovement(l) 2 0 mil 10yr 200,000 200,000 200,000, _ Sauqus River Imrpovement(II) Z 0 mil 10yr 200,000 200,000 200,000 200,000 200,000 Aberiona River Improvement 2.2 mil 10yr 220,000 220,000 220,000 220,000 220,000 220,000 220,000 Interest on Long Term Debt 204,100 163,800 123,500 83,200 55,900 28,600 14,300 0 Sauqus River lmrpovement(I) 20 mil 10yr 39,000 26,000 13,000 Sauqus River lmrpovement(Y) Z 0 mil 10yr 65,000 52,000 39,000 26,000 13,000 Aberiona River Improvement Z.2 mil 10yr _ 100,100 85,800 71,500 57,200 42,900 28,600 14,300 M 0) Water Enterprise Fund This fund is comprised of Water Supply and Water Distribution, and from a budget standpoint there is a section of shared overhead costs called Water Operations. Supply is responsible for the administrative management, operation, maintenance and security of the drinking water supply in accordance with all Federal, State and local regulations. This division also provides technical support. Distribution is responsible for maintaining and operating the municipal water distribution system in accordance to industry standards and all applicable regulations. In addition,. this division oversees water meter installation, repair and meter reading. The budget ,for Water Operations is up 7.6% for FY12, or an increase of $192,147. An interest free loan for work on a water main at Haverhill-Franklin-Wakefield was recently approved by Town Meeting. The timing of this to begin in FY12 was one year sooner than would be ideal from a financial standpoint - but the. attractive interest-free loan from the MWRA was not guaranteed to be in place one year from now. Advancing this project forward by one year alone explains $228,500 of the increase in Operations. MWRA water rates are only projected to be up about 2% for FY12. The gross water budget is up 4.4%. However there are other factors that affect the water rates, including the use of reserves to offset the costs, as well as the expected volume of usage. In FY11, $225,000 in reserves offset costs. If usage is unchanged and no reserves are used this year that would suggest an 8.9% increase in rates: Operations Supply. Distribution Wages $87,741 $551,749 -0.6% +1.4% Expenses $316,427 $1,832,585 $187,750 +5.9% -0.0% -1.5% Debt & Capital $2,014,091 $30,000 $275,000 +9.5% +100% +4.6% Other $377,367 0% TOTAL $2,707,885 $1,950,326 $1,014,499 +7.6% +1.6% +1.7% FY11 FY12 Change Gross budget $5,433,291 $5,672,710 +4.4% Reserves $225,000 $0 TBA Net budget. $5,208,291 $5,672,710 +8.9% 03/19/2011 10:49 (TOWN OF READING blelaaheur NEXT YEAR BUDGET HISTORICAL COMPARISON PROJECTION: 20122 FY2012 Enterprise Funds ACCOUNTS FOR: PRIOR FY3 PRIOR FY2 LAST FYI WATER ACTUALS ACTUALS ACTUALS 0450 WATER - OPERATIONS 05 EXPENSES 61005519 519000 MEDICARE 61005519 519700 RETIREMENT 61005529 529433 HAZ WST DI 61005530 530105 PRINTING' 61005530 530110 LEGAL COUN 61005530 530480 PRIMACEY A 61005530 530491' SVC WKFLD 61005531 531000 PRDEV TRN 61005574 574000 HEALTH INS 61005574 574010 PROP/CASUA 61005574 574500 DEDUCT/CLM 61005574 574550 WC INSURNC TOTAL EXPENSES 07 DEBT SERVICE 61007530 530705 DEBTCOSTS 61,007591 591000 DEBT PRINC 61007591 592000 LTDEBTINT TOTAL DEBT SERVICE 09 OTHER FINANC ING USES 61009596 596111 WAGE-TWNMG 61009596 596112 EXP SUPP 61009596 596121 WAGE-ACTNG 61009596 596122 EXP ACTNG 61009596 596131 WAGE-FINCE 61009596 596132 EXEFINANCE 61009596 596141 WAGE HR 61009596 596142 EXP HR 61009596 596151 WAGE TECHN 61009596 596152 EXP TECH 61009596 596161 WAGEDPWADM 61009596 596171 WAGE ENGIN 61009596 596181 WAGE HGWY 61009596 596162 EXP HGWY 61009596 596300 XFERCAPFND 61009596 596500 XFERTO ENT TOTAL OTHER FINANCING USES TOTAL WATER - OPERATIONS 0451 WATER - DISTRIBUTION "5,425.00 89,093.00 15,346.18 .00 15,000.00 5,828.03 5,546.76 4,044.25 170,952.00 .00 1,499.00 63,581.00 376,315.22 6,000.00 16,413.00 6,419.00 361.13 11,159.10 5,451.82 5,567.09 2,992.00 165,000.00 31,560.00 .00 20,332.00 271,275.14 7,000.00 17,075,00 7,771.40 .00 121.50 5,530.87 7,601.06 2,674.00 102,645.48 20,460.00 .00 15,905.00 186,784.31 LPG 3 bgnyrpts FOR PERIOD 99 CY CY REV PROJECTION PCT ACTUALS BUDGET LEVEL 3 CHANGE .00 26,724.00 5,563.00 .00 .00 5,551:27 3,957.17 1,770.00 104,848.18 23,017.00 .00 15,411.00 186,841.62 7,000.00 26,724.00 10,000.00 .00 16,000.00 5,531.00 7,140.00 3,000.00 149,500.00 44,000.00 .00 30,000.00 298,895.00 7,500.0.0 27,927.00 10,000.00 .00 10,000.00 5,500.00 7,000.00 2,500.00 165,000.00 45,000.00 00 36,000.00 316,427.00 7.1% 4.5% .0% -37.5% -.6% -2.0% -16.7% 10.4% 2.30 .0% 20.0% 5.9% 63,049.00 000.00 756 1,412.92 1,225,000.00 .00 1,375,000.00 .00 620,000.00 .00 1,375;000.00 .00 1,598,500.00 .0% 16.3% , 420,291.00 .557,170.00 514,352.50 247,.712.50 464,206.00 415,591.00 -10.5% 1,239,340.00 1,783,582.92. 1,889,352.50 867,712.50 1,839,206.00 2,014,091.00 9.5% 13,886.00 14,896.00 14,896.00 14,896.00 14,896.00 00 .0% 0% 3,234.00 .00 .00 .00 . . 95.00 30,247.00 180.00 32,032.00 180.00 32,032.00 180.00 32,032.00 180.00 32,032.00 .0% .0% , 6,009.00 4,090.00 21,653.00 4,900.00 21,653.00 4,'900.0.0 21,653.00 4,900.00 21,653.00 4,900.00 .0 .0- ,136.00 00 531 26 2,264.00 777 00 31 2,264.00 31,777.00 2,264.00 31,777.00 2,264.00 31,777.00 .0% .0% . , 27,255.00 . , 30,418.00 30,418.00 30,418.00 690.00 4 30,418.00 00 690 104 .0% 0% 110,313.00 99,945.00 104,690.00 98,407.00 104,690.00 98,407.00 10 , 98,407.00 . _ , 98,407.00 . .0% 6,730.00 6,730.00 6,730.00 6,730.00 6,730.00 .0% 75,000.00 .00 .00 .00 .00 .0% 438,600.00 2•,493,458.06 413,367.00 2,489,503.81 377,367.00 1,431,921.12 377,367.00 2,515,468.00 377,367.00 2,707,885.00 .0% 7.6% 14;061.00 3,187.00 9,084.00 9,226.00 10,078.00 10,078.00 10,078.00 10,078.00 .0% 98.00 28,897.00 5,680.00 4,025.00 1,136.00 22,158.00 23,667.00 84,928.00 94, 33.9.00 6,560.00 22,325.00 22,771.00 19,342.00 19,342.00 19,342.00 19,342.00 .0% .00 .00 .00 36,000.00 .00 .00 .00 .0% 320,145.00 1,935,800.22 03/19/2011 10:49 blelacheur PROJECTION: 20122 ACCOUNTS FOR: WATER TOWN OF READING (NEXT YEAR BUDGET FY2012 Enterprise Funds PRIOR FY3 ACTUALS HISTORICAL COMPARISON PRIOR FY2 LAST FY1 ACTUALS ACTUALS Y ACTUALS Y REV BUDGET LPG 4 bgnyrpts FOR PERIOD 99 PROJECTION PCT LEVEL 3 CHANGE 03 SALARIES 61013511 511401 SUPERVISOR 34,253.64 36,820.52 32 38,826.34 28 677 58 27,074.31 534.30 41 38,831.00 58,372.00 39,609.00 59,837.00 2.0% 2.5% 61013511 511403 FOREMAN RMN 54,578.36 32 465 72 58,065. 489.48 51 . , 89,073.54 , 94,758.04 104,907.00 110,842.00 5.79. 61013511 61013511 511405 511409 WRKNG F EQUIP OPER . , 136,820.74 , 146,249.46 117,118.54 85,922.88 17 58 148,531.00 00 995 83 141,149.00 672.00 79 -5.0% -5.1% 61013511 511413 SKLLD LABR 45,128.02 70 82,244.85 280 48 32 78,502.24 104.96 34 . 49,1 23,666.72 . , 33,032.00 , 33,032.00 .0% 61013511 511417 LABORER CLERK(S) 64,423. 905.34 15 . , 16,876:29 , 17,308.15 11,979.44 17,260.00 17,598.00 00 2.0% 0% 61013511 61013511 511471 511481 SNOW REMOV , -4,197.56 -7,709.63 11 65 .00 495 18 62 .00 337.35 31 -6,500.00 38,355.00 -6,500. 50,000.00 . 30.4% 61013511 5150.00 OVERTIME GRA 121,650.05 82 055 1 71,0 . 394.34 1 . , 1,894.10 , 3,732.24 1,882.00 3,000.00 59.4% 61013511 61013511 516050 516060 . OUT OF ONCALL PRM . , 8,130.00 , 10,270.46 9,760.00 7,564.00 25 00 8,818.00 00 500 7 8,818.00 500.00 7 .0% .0% 61013511 516080 LONGEVITY TEMP W 7,100.00 64 281 8 7,337.50 831.12 8 6,625.00 6,552.33 . 6,8 2,837.58 . , 9,126.00 , 7,192.00 -21.2% 61013512 512000 AGES . , , 07 595 565 515,715.30 520,937.66 386,349.44 544,109.00 551,749.00 1.4% TOTAL SALARIES . , 05 EXPENSES Qp 61015521 521301 ELECTRICIT 8,892.71 10,910.59 9,678.95 7,711.67 50 236 10,200.00 410.00 11,000.00 500. 7.8% 22 61015521 521303 NATRL GAS 352.10 00 483.79 87 035 3 353.50 2,902.39 . 2,033.16 .00 00 .0% 61015521 61015530 521392 530110 WRLS PHONE LEGAL, COUN . 1,728.00 . , .00 64 1 .00 583 69 9 .00 033.41 10 .00 10,700:00 .00 15,000.00 .0- 40.2% 61015530 530420 PLCE DTAIL 10,857.84 0 28 10,27 . 11' 141 1 . , . 516.96 5 , 306.94 15,234.00 10,000.00 -34.3% 61015530 530470 WTR SYSTEM MAIN PIPE/ . 7,78 990.00 9 . , 10,720.00 , 9,706.52 760.00 12,200.00 10,000.00 0 00 -18.0% 51 61015530 61015530 530472 530474 SVC PIPE/M , .00 45,325.19 60,933.11 00 00' 47,651.69 00 800 1 49,750.00 400.00 8 . 50,00 8,000.00 . -4.8% 61015530 530478 CROSS CONN 4,960.00 5,040.00 00 398 4,9 . 00 . , .00 , .00 .00 .0% 61015531 61015536 531000 536000 PRDEV TRN LIC SFTWR .00 .00 . 7,800.00 . 6,236.15 5,000.00 87 21 10,000.00 00 775 26 .10,000.00 000.00 27 .0% a- 61015540 540470 WD GEN SUP 19,055.09 61 088 21,488.07 78 633 28 24,736.81 406.91 24 21,8 . 10,884.75 . , 33,180.00 , 33,000.00 -.5% 61015540 61015540 540472 540474 MAIN PIPE SVC METERS . 29, 41,268.12 . , .00 , 151.00 949 21 380.00 97 149 3 7,625.00 500.00 5 7,000.00 5,500.00 -8.2% .0% 61015554 554000 UNFM/CLTH 1,029.98 8,825.21 315 00 . 3, 864 00 . , 347.00 , 714.00 750.00 5.0% 61015578 578100 LICENSES 794.0.0 . . 73 796 135 154,388.25 163,919.20 112,116.96 190,684.00 187;750.00 -1.5% TOTA L EXPENSES . , 08 CAPITAL EXPENDITURES 61018584 584410 BOBCATLOAD .00 .00 .00 00 43,827.95 61 933 37 45,000..00 38,000.00 .00 .00 -100.0% -100.0% 61018584 61018585 584411 585000 VAN #2 ADDTNL EQU .00 116,761.69 .00 .00 . 6,769.88 . , .00 00 347 .00 00 000 180 275,000.00 .00 .0%. -100.0%, 61018585 585451 METRINSTAL .00 63,225.75 00 206,774.00 86 595 57 . .00 . , .00 .00 O% 61018588 588450 SYSTEMS .00 . . , TOTAL CAPITAL EXPENDITURES 116,761.69 63,225.75 329 30 271,139.74 60 996 955 82,108.56 580,574.96. 263,000.00 997,793.00 275,000.00 1,014,499.00 4.6% •1.7% TOTA L WATER - DISTRIBUTION 818,153.49 . 733, . , 0452 WATER - S UPPLY / TREATMENT 03/19/2011 10:49 blelaCheur PROJECTION: 20122 ACCOUNTS FOR: WATER TOWN OF READING NEXT YEAR BUDGET FY2012 Enterprise Funds PRIOR FY3 ACTUALS HISTORICAL COMPARISON PRIOR FY2 LAST FYI ACTUALS ACTUALS Y ACTUALS Y REV BUDGET IPG 5 bgnyrpts FOR PERIOD 99 PROJECTION PCT LEVEL 3 CHANGE 03 SALARIES 61023511 511461 SUPERVISOR 78,383.52 83,798.33 84,062.88 58,618.56 00 84,048•.00 -500 00 83,741.00 -500.00 -.4% .0% 61023511.511481 SNOW RMVL -600.64 2 564 -232.14 18 403 3 .00 586.11 5 . 4,267.58 . 4,692.00 4,500.00 -4.146 61023511 515000 OVERTIME 7 . 31, . , , TOTAL SALARIES 109,347.15 86,969.37 89,648.99 62,886.14 88,240.00 87,741.00 -.6% OS EXPENSES 610.25521 521301 ELECTRICIT 22,108.08 13,910.65 24,721.78 00 18,512.75 62 077 2 20,000.00. 6,000.00 21,000.00 3,000.00 5.0% -50.0% 61025521 521308 521309 FUEL OIL SWR/STM WA 20,593.29 604.85 .00 .439.95. . 127.90 . , 161.04 470.00 500.00 00 00 6.41 61025521 61025521 521390 TELEPHONE 2,340.79 2,098.93 2,291.25 1,060.59 00 3,280.00 00 . 3,0 10,000.00 . 61025524 524471 MWRA VALVE OUT PRFSVC 00 288.81 72 .00 7,360.51 .00 12,155.56 . 1,358.00 . 10,200.00 10,000.00 0 -2.0% 0% 61025530 530000 61025530 530457 WELLS , 5,017.15 13 4 .00 96 806 1 .00- 242.16 5 1,377.76 875.53 00 7,000.00 .00 6,000.00 . -14.3% 61025540 540000 DEPT SUPP . 3,42 00 . , 92 384 8 , 13,486.93 3,763.00 57,962.00 20,000.00 -65.5% 61025540 540455 WELLS - . 00 . , 00 25,200.50 .00 .00 .00 .0% 61025540 540499 400 WTR EMERGN MWRA . 924.41 536 1 1,636,165.00 1,737,501.00 1,381,502 1,726,878: 00 1,759,085.0000 1:08 tp 61025563 563 61025563 563410 RESIDUALS , , 55,324.00 .00 .00 :4000 00 TOTAL EXPENSES 1,718,625.51 1,670,166.92 1,820,727.08 1,410,688.69 1,831,790.00 1,832,585.00 .0% 08 CAPITAL EXPENDITURES 61028583 583000 PLANT .00 .00 .00 00 .00 00 .00 .00 40,000.00 .00 .0% .0% 61028585 585452 BOOSTER TE .00 00 36,000.00 00 000 35 . .00 . .00 .00 .00 .0% 61028585 585453 EMERG ENGI WELLS . 000.00 75 . , :00 .00 .00 .00 .00 .0% 61028588 588455 , TOTAL CAPITAL EXPENDITURES PLY / TREAT 75,000.00, 972.66 902 1 71,000.00 1,828,136.29 .00 1,910,376.07 .00 1,473,574.83 .00 .1,920,030.00 40,000.00 1,960,326.00 00 0 2.1% 4 6-- TOTAL WATER - S UP , , 926.37 656 4 5,054,923.65 5,355,876.48 3,486,"070.91 5,433,291.00 5,682,71 . . TOTAL WATER , , Town of Reading, MA II Approved l Requested (Projected 3119!201111:14 I FY-2011 FY-2012 FY-2013 FY-2014 FY-2015 FY-2016 FY-2017 FY-2018 FY-2019 FY-2020 FY-2021 TOTAL FY12-21 O Existing debt in green new deot to yellow 350,000 262,00 487;000 370;000 000 255 ODD 000 365 000 506 0 895 9 757 000: Public Works= Water?'CAPITAL z63,0UO? 305,000 , , , , 968;00 ter Distribution W 263,000 275,000 751,000 570,000 460,009 285,000 235,000 300,000 262,000 437,000 370,000 3,945,000 a onn nnn onn nnn grin nnn vollmon 800,000 water main Lining uasu Various Water Mains ($2.471 mil) Debt WM - H St. Loop (Ivy St.) Cash WM - Causway Road Loop Cash WM - Larch Lane Cash WM - Haverhill-Franklin-Batch ($420k) Debt WM-Haverhill-Franklin-WkOd($1.865m) Debt WM-Howard-Cty-Summer($1.012m) FY15 WM-South-West-Gleason($1.02m) FY16 Meter Replacement cash 180,000 Water System Hydraulic Model Cash Storage Tank Inspection Cash, Tank inspecUDesign-Auburn Cash Tank Maintenance -Auburn Cash Tank Maintenance - Bear Hill Cash Storage Tank ($1.15mil.) FY19 Booster Station SCADA Cash SCADA Upgrade (every 5yrs) Cash Replace Bob Cat Loader . Cash 45,000 Pickup Truck #12 (1997-10yrs) Cash Replace Car #2 Cash Replace Van #2 Cash 36,000 Replace Truck #6 Cash Replace Tmck #14 Cash Replace Backhoe #420E Cash Replace Utility Truck #5 Cash Water Supply WTP design Debt Join MWRA (partial-$3.18mil) Debt Bmil) Join MWRA (full-$7 Debt . Plant demo & chlorine trmt ($800k debt) Debt Plant demo & chlorine cant ($450k debt) Debt Water Conservation Program Cash Wells Upgrade Cash Well Abandonment Cash Hydraulic Study - 2nd connection cash Pickup Truck #3 (2003 -10yrs) Cash 350,000 276,000 85,000 70,000 I 475,000 220,000 165,000 20,000 40,000 120,000 30,000 217;000 325,000 40,000 35,000 20,000 100,000 60,000 50,000 40,000 30,000 20,000 50,000 50,000 50,000 225,000- 30,000 120,000 37,000 350,000 276,000 120,000 50,000 250,000 '250,000 750,000 85,000 12,000 12,000 24,000 70,000 475,000 220,000 165,000 25,000 45,000 40,000 35,000 120,000 120,000 120,000 100,000 150,000 150,000 50,000 812,000 200,000 50,000 200,000 225,000 150,000 37,000 Town of Reading FY - 2012 Budget d t t d P 312011113:54 Approved Requested Projected Projected Projected Projected Projected Projected Projec e rojec e Debt Service Debt Service Debt Service Debt Service Debt Service Debt Service Debt Service Debt Service Debt Service Debt Service New - Not Approved m italics FY - 2011 FY - 2012 FY - 2013 FY- 2014 FY - 2015 FY 2016 FY - 2017 FY - 2018 FY - 2019 FY 2020 r. Fund Wate $1;839,206 ' $2014;0.91 $1';326,051;.;; $1299;286 $.1;539,901 :'-`j_$1;66.1;529 ;$;1,607,601 °$1,555;2:79 $.1;731,127 $ 1465;595::, , Join MWRA full $7.8m 08-28 Nov 01 662,513 647,400 632,775 618,150 603,525 588,656 571,350 553,800 538,200 522,600 Join MWRA artial $3.18m 07-27 A r 15 270,656 264,656 258,656 252,656 246,656 237,719 229,719 224,069 217,669 211,269 Demo WTP/chlorinate $0.8m 00-18 Jul 01 98,300 95,860 93,420 90,980 88,540 86,100 83,660 81,220 0 0 Demo WTP/chlorinate $450k 09-13 Feb 01 156,000 153,000 0 0 0 0 0 0 0 0 0 Water Treatment Plant Design 2005 119,800 116,300 112,700 109,000 104,500 0 0 0 0 Water Mains $2.471m WM:Hvrhill-Frnkln-Wkfld 08-12 2285k Apr 15 MWRA 531,938 508,375 228,500 0 228,500 0 228,500 0 228,500 0 228,500 0 228,500 0 228,500 0 228,500 0 228,500 WMHwrd--Cnt -Summer 1012k new 0 0 0 0 268,180 255,024 241,868 228,712 215,556 0 WM: South-West-Gleason 1002k new 0 0 0 0 0 265,530 252,504 239,478 226,452 213,426 Stora e Tank 1150k new 0 0 0 0 0 0 0 0 304,750 289,800. Repayment of Principal: 1,375,000 1,598,500 958,500 958,500 1,160,900 1,261,300 1,261,300 1,261,300 1,411,300 1,208,900 Join MWRA full $7.8m 0828 Nov 01 390,000 390,000 390,000 390,000 390,000 390,000 390,000 390,000 390,000 390,000 Join MWRA artial $3.18m 07-27 A r 15 160,000 160;000 160,000 160,000 160,000 160,000 160,000 160,000 160,000 160,000 Demo WTP/chlorinate $0.8m 09-18 Jul 01 80,000 80,006 80,000 80,000 80,000 80,000 • 80,000 80,000 Demo WTP/chlorinate $450k 10-12 Feb 01 150,000 150,000 Water Treatment Plant Design 2005 2005 100,000 100,000 100,000 100,000 100,000 Water Mains $2.471 m WM:Hvrhill-Frnkln-Wkfld 08-12 2285 Apr 15 MWRA 495,000 490,000 228,500 228,500 228,500 228,500 228,500 228,500 228,500 228,500 228,500 -Hwrd-Cnt -Summer WM 1012k 5 r 202,400 202,400 202,400 202,400 202,400 . • South-West-Gleason WM 1002k 5 r 200,400 200,400 200,400 200,400 200,400 . Stork e Tank 1750k 5 r 230,000 230,000 Interest on Lon Term Debt: 464,206 415,591 367,551 340,786 379,001 400,229 346,301 294,479 319,827 256,695 . 8m Join MWRA full $7 08-28 Nov 01 272,513 257,400 242,775 228,150 213,525 198,656 181,350 163,$00 148,200 132,600 . Join MWRA artial $3.18m 07-27 Apr 15 110,656 104,656 98,656 92,656 86,656 77,719 69,719 64,069 57,669 51,269 Demo WTP/chlorinate $0.8m 09-18 Jul 01 18,300 15,860 13,420 10,980 8,540 6,100 3,660 1,220 Demo WTP/chlorinate $450k 10-12 Feb 01 6,000 3,000 Water Treatment Plant Design 2005 2005 19,800 16,300 12,700 91000 4,500 Water Mains $2.471 m 08-12 Apr 15 36,938 18,375 0 0 0 WM:Hvrhill-Frnkln-Wkfld 2285 MWRA 0 0 0 0 780 65 0 624 52 0 39,468 26,312 13,156 WM.•Hwrd Cnt -Summer 1072k 5 r , , 130 65 704 52 39,078 26,052 13,026 WM.• South-West-Gleason 1002k 5 r , , 74,750 59,800 Storage Tank 1150k 5 r Town of Reading FY - 2012 Budget. 3120/1113:54 Projected Projected Projected Projected Projected Projected Projected Projected I Debt Service Debt ServicEDebt SenriceDebt ServiceDebt ServiceDebt ServicEDebt Service)ebt Service New - Not Approved in italics FY 2021 FY 2022 FY 2023 FY 2024 FY - 2025 FY 2026 FY 2027 FY - 2028 ' ::Water Furzd . -197 800 $;1,215,216 ;,`.$949,769 $.912,819 645 869. $ 623,575 $ 591;375 $569,588 ; $ Join MWRA(fu11$7 8m) 08-28 Nov 01 507,000 491,400 475,800 460,200 444,600 429,000 413,400 397,800 _ Join MWRA(partial $318m) 07-27 Apr 15 204,869 198,469 192,069 185,669 178,975 162,375 156,188 0__ . Demo WTP/chlorinate($0 8m) 09-18 Jul 01 0 0 0 0 0 0 0 0 Demo WTP/chlorinate ($450k) 09-13 Feb 01 0 0 0 0 0 0 0 0 Water Treatment Plant Design 2005 0 0 0 0' 0 0 0 0 Water Mains($2 471 m) 08-12 Apr 15 0 0 0 0 0 0 0 0 WM:Hvrhill-Frnkln-Wkfld 2285k MWRA 228,500 0 0 0 0 0 0 0 wM.-Hwrd-Cnt -Summer 1012k new 0 0 0 0 0 0 0 0 WM.• South-West-Gleason 1002k new 0 0 0 0 0 0 0 0 Storage Tank 1150k new 274,850 259,900 244,950 0 0 0 0 0 Repayment of Principal: 1,008,500 780,000 780,000 550,000 550,000 540,000 540,000 390,000 Join MWRA(full $7.8m) 08-28 Nov 01 390,000 390,000 390,000 390,000 390,000 390,000 .390,000 390,000 Join MWRA(partial $318m) 07-27 Apr 15 160,000 160,000 160,000 160,000 160,000 150,000 150,000 Demo WTP/chlorinate($0 8m) -09-18 Jul 01 N Demo WTP/chlorinate ($450k) 10-12 Feb 01 Water Treatment Plant Design 2005 2005 Water Mains($2 471 m) 08-12 Apr 15 - WM:Hvrhill-Frnkln-Wkfld 2285 MWRA 228,500 WM•Hwrd Cnty-Summer 1012k 5yr WM- South-West-Gleason 1002k 5yr Storage Tank 1150k 5yr 230,000 230,000 230,000 Interest on Lon Term Debt: 206,719 169,769 132,819 95,869 73,575 51,375 29,588 7,800 Join MWRA(full $7.8m) 08-28 Nov 01 117,000 101,400 85,800 70,200 54,600 39,000 23,400 7,800 Join MWRA(partial $318m) 07-27 Apr 15 44,869 38,469 32,069 25,669 18,975 12,375 6,188 Demo WTP/chlorinate($0 8m) 09-18 Jul 01 Demo WTP/chlorinate ($450k) 10-12 Feb 01 Water Treatment Plant Design 2005 2005 Water Mains($2 471 m) 08-12 Apr 15 WM:Hvrhill-Frnkln-Wkfld 2285 MWRA 0 WM•Hwrd Cnty-Summer 1012k 5yr WM: South-West-Gleason • 1002k 5yr Storage Tank 1150k 5yr 44,850 29,900 14,950 /1-1 03/19/2011 10:49 (TOWN OF READING blelaeheur NEXT YEAR BUDGET HISTORICAL COMPARISON PROJECTION: 20122 FY2012 Enterprise Funds ACCOUNTS FOR: PRIOR FY3 PRIOR FY2 LAST FYI CY CY REV SEWER ACTUALS ACTUALS. ACTUALS ACTUALS BUDGET PG 2 bgnyrpts FOR PERIOD 99 PROJECTION PCT LEVEL 3 CHANGE 62007591 591000 LT DBT PRI 62007591 592000 LTDEBTINT 62007593 593000 ST DBT INT TOTAL DEBT SERVICE 08 CAPITAL EXPENDITURES 62008585 585000 ADDTNL EQU 62008585 585451 METRINSTAL 62008588 588411 CALIF RD S 62008588 588505 INFLOW/INF 62008588 588510 SEW ST REH 62008588 588512 SEW ST STU 62008588 588541 GLEN ROAD 62008588 588542 W GROVE ST TOTAL CAPITAL EXPENDITURES 09 OTHER FINANCING USES W 677.00 83 167,543.00 167,543.00 41,800.00 160,800.00 160,800.00 .0% , 00 10,687.50 7,406.25 77,906.25 4,313.00 1,406.00 -67.4% . 5,951.94. .00 .00 .00 .00 .00 .0% 69,628.94 178,230.50 174,949.25 119,706.25 165,113.00 162,206.00 -1.8% 104,201.90 00 .00 .00 122,156.00 143,618.48 .00 .00 .00 180,000.00 167,000.00 .00 .0°s -100.0% . 00 .00 .00 58,481.29 246,001.28 .00 -100.01 . 277,197.13 67,579.57 • 140,422.41 00 00 79,500.00 00 100,000.00 00 000 30 100,000.00 000:00 30 .0% .0% .00 00 .00 .00 30,0 . 10,000.00 . .00 . , .00 , .00 .0% . .00 169,168.24 11,282.21 .00 .00 .00 00 .0% D% .00 10,000.00 .00 .00 .00 - . . 381,399.03 246,747.81 457,479.10 137,981.29 556,001.28 297,000.00 -46.6% 62009596 596111 WAGE-TWNMG 12,477.00 . 62009596 596112 EXP SUPP 2,826.00 62009596 596121 WAGE-ACTNG 7,990.00 62009596 596122 EXP ACTNG 87.00 62009596 596131 WAGE-FINCE 25,645.00 62009596 596132 EXEFINANCE 5,037:00 62009596 596141 WAGE HR 3,573.00 62009596 596142 EXP HR 1,008.00 62009596 596151 WAGE TECHN 19,662.00 62009596 596152 EXP TECH 21,001.00 62009596 596161 WAGEDPWADM 46.,773.00 62009596 596171 WAGE ENGIN 57,555.00 62009596 596181 WAGE HGWY 2,358.00 62009596 596182 EXP HGWY 12,312.00 62009596 596300 XFER TO CA .00 62009596 596500 XFERTO ENT .00 TOTAL OTHER FINANCING USES 218,306.00 TOTAL SEWER - OPERATIONS 4,544,998.58 0990 OTHER FINANCING'SOURCES/USES 09 OTHER FINANCING USES 62009590 599910 DEBT COSTS .00 TOTAL OTHER FINANCING USES .00 TOTAL OTHER FINANCING SOURCE .00 TOTAL SEWER 4,544,998.58 13,010.00 14,062.00 14,062.00 14,062.00 14,062.00 .0% 3,029.00 8,642.00 .00 9,517.00 .00 9,517.00 .00 9,517.D0 .00 9,517.00 .0% 0% 89.00 170.00 170.00 170.00 170.00 .0% 28,333.00 5,629.00 30,249.00 20,440.00 30,249.00 20,440.00 30,249.00 20,440.00 30,249.00 20,440.00 .0% .0% 3,831.00 4,628.00 4,628.00 4,628.00 4,628.00 7 00 .0% 0% 3,061.00 24,849.00 2,137.00 29,998.00 2,137.00 29,998.00 2,137.00 29,998.00 2,13 . 29,998.00 1 . .0% 25,536.00 28,715.00 28,715.00 28,715.00 5.00 28,7 .0% 0% 50,424.00 61,892.00 47,475.00 60,065.00 47,475.00 60,065.00 47,475.00 60,065.00 47,475.00 60,065.00 . .0% 2,419.00 .2,419.00 2,419.00 2,419.00 2,419.00 .0% 0° 12,558.00 9,129:00 9,129.00 9,129.00 9,129.00 00 s . 0% 75,000.00 .00 .00 33,000.00 .00 .00 .00 .00 . .00 . .0% 302.00 318 292,004.00 259,004.00 259,004.00 259,004.00 .0% , 4,722,730.24 5,264,282.57 3,961,220.26 5,473,724..28 5,546,894.00 1.3% .00 3,-000.00 .00 .00 .00 .0% .00 3,000.00 .00 .00 .00 .0% .00 3,000.00 .00 .00 .00 .0% . 4,722,730.24 5,267,282.57 3,961,220.26 5,473,724.28 5,546,894.00 1.3-. Town of Reading, MA Approved Requested Projected 3/191201111:14 FY-2011 FY-2012 FY-2013 FY-2014 FY-2015 FY-2016 FY-2017 FY-2018 FY-2019 FY-2020 FY-2021 TOTAL Existing debt in green, new debt in yellow FY12 21 Public Works _ Sewer GAPTTAIJ = 495,000 157 00D 130 Dtl0 37ODD 150,000 45,000 ??250;OOD zsa,DDD Z5 6,U011 1 26000s Infiowtlnfiltration Cash 100,000 . move to Operating Budget Seal Sewer Manholes cash move to Operating Budget Sewer Station Rehabilitation cash 30,000 move to Operating Budget Debt, FairviewtSunnyside$300kt4yrdebt) California Road - Sewer Main cash 185,000 75,000 Lewis Street - Sewer main cash 75,000 000 .250,000 250,000 250 750,000 Cash Meter Replacements 180,000 , 130 000 Backhoe 430D Cash 130,000 , Replace Vehicles Cash 82,000 37,000 150,000 45,000 314,000 -P Cn Sewer Enterprise. Fund The Sewer division is responsible for maintaining and operating the municipal main sewer systems . in accordance with all applicable state, federal and MWRA, regulations for the collection and discharge of wastewater. The specific. functions are: maintenance and repair of 100 miles of sewer mains and'12 pumping. stations; respond to customer complaints for sewer backups and drainage problems. The chart below summarizes the FY12 proposed budget: ~Pwpr Enternrise Fund Wages $ 267,908(-13.1%) Expenses $4,560,776 +9.0% Debt & Capital $ 319,206 -56% Other $ 259,004 0% Gross budget $5,406,894(-1.2%) Reserves $ 0 TBA : . Net budget $5,406,894(-+ 1.8% Wage costs in the current year were overstated, as seen by the year-to-date figure well below a 60% expended rate. The MWRA sewer rate is projected to increase by 6.2%, and some annual maintenance costs ($100,000 inflow & infiltration and $40,000 sewer station and manhole repairs) have been moved from capital to the operating budget. Aside from these factors, the remaining expense budget declined slightly from FYI I. Note that there is very low debt projected for this fund. At present the fund uses MWRA loans, but these are offered for three to five years at a time. If past patterns repeat, about $165,000, in annual debt should be projected forward for every year, but at present that cannot be guaranteed. 03/19/2011 10:49 TOWN OF READING I PG 1 blelaaheur. ( NEXT YEAR BUDGET HISTORICAL COMPARISON bgnyrpts PROJECTION: 20122 FY2012 Enterprise Funds FOR PERIOD 99 ACCOUNTS FOR: PRIOR FY3 PRIOR FY2 LAST FYI CY CY REV PROJECTION PCT SEWER ACTUALS ACTUALS ACTUALS ACTUALS BUDGET LEVEL 3 CHANGE 0440 SEWER- OPERATIONS 03 SALARIES 62003511 511401 SUPERVISOR 34,253.64 36,820.53 38,826.38 27,074.33 38,831.00 39,609.00 2.0% 52003511 511405 WRKNG FRMN 49,812.50 52,756.60 55,887.19 36,471.63 53,954.00 53,239.00 -1.3% 62093511 511409 EQUIP OP 48,384.06 50,964.18 51,907.68 37,190.56 51,908.00 51;908.00 .0% 62003511 511413 SKLLD LABR 38,068.30 67,217.19 37,375.53 3,500.21 40,987.00 .00 -100.01 62003511 511417 LABORER 37,770.97 3,272.96 57,800.14 37,289.27 62,862.00 66,062.00 5.1% 62003511 511471 CLERK(S) 15,9.05.34 16,876.53 17,308.47 11,979.76 17,260.00 17,598.00 2.036 - 62003511 511481 SNOW RMVL -2,516.52 -4,648.33 .00 .00 -2,500.00 -2,500.00 .0% 62003511 515000 OVERTIME 36,336.88 22,318.13 20,856.34 11,191.57 39,644.00 35,000.00 -11.7% 62003511 516050 OUT OF GRA 213.68 358.24 23.76 1,470.96 209.00 2,000.00 856.9% 62003511 516060 ONCALL PRM 1,628.00 2,390.00 2,644.00 1,464.00 2,942.00 2,942.00 .0% 62003511 516080 LONGEVITY 2,050.00 2,050.00 3,125.00 1,950.00 2,050.00 2,050.00 .0% TOTAL SALARIES 261,906.85 250,376.03 285,754.49 169,582.29 308,147.00 267,908:00 -13.1% OS EXPENSES 62005519 519000 MEDICARE 603.00. 700.00 1,000.00 .00 1,000.00 1,075.00 7.5% 62005519 519700 RETIREMENT 20,566.00 14,512.00 14,876.00 22,273.00 22,273.00 23,275.00 4.5% 62005521 521301 ELECTRICIT 25,155.27 29,451.57 28,536.59_ 18,689.02 32,250.00 33,'000.00 2.3% 62005524 524469 STATIONREP .00 .00 .00 .00 .00 30,000.00 .0% 62005524 524474 MANHOLE .00 .00 .00 .00 .00 10,000.00 .0% 62005524 524475 I&I REIMB .00 .00 500.00 00 800.00 00 .00 00 .00 000 00 100 .0% .0% 62005524 62005529 524476 529433 I&IPREVENT HAZ WST DI .00 .00 .00 9,206.43 . 8,429.33 . .00 . 10,000.00 , . 10,000.00 .0% 62005530 530000 PURCH SVC .00 15,701.31 19,793.05 10,008.13 16,650.00 16,650.00 .0% 62005530 62005530 530105 530110 PRINTING LGL COUNSL .00 2,000.00 361.12 229.50 .00 .00 .00 .00 .00 2,500.00 .00 2,500.00 .0% .096 62005530 530420 PLCE DTAIL 1,957.00 1,846.64 1,844.98 6,737.17 2,250.00 5,000.00 122.2% 62005530 530490 CNTSVCPUMP 7,476.38 12,607.08 18,895.01 5,174.63 15,7.25.00 15,000.00 -4.6% 62005530 62005530 530,491 530492 OTHCOMMSVC SYS INSPEC 16,107.68 15,793.45 .00 1,735.83 .00 14,750.00 .00 1,761.58 .00 16,950.00 .00 16,000.00 .0% -5.69. 62005531 531000 PRDEV TRN .00 .00 .00 .00 510.00 500.00 0 -2.0% 0% 62005536 536000 LIC SFTWR .00 7,000.00 1,000.00 .00 10,000.00 10,000.0 . 1 4% 62005540 540490 PMPSTASUPP 1,909.97 2,864.54 82 12,532.04 78 3 930 4,381.58 66 3 038 7,100.00 8,200 00 7,000.00 000.00 8 . - -2.4% 62005540 62005540 540493 540495 DIST SYS CHEMICALS 1,788:37 .00 2,277. 2,550.00 , . 3,355.96 , . 3,.339.48 . 13,300.00 , 12,000.00 -9.8% 62005554 554000 UNFM/CLOTH 928.94 3,414.06 2,844.91 1,399.99 2,200.00 2,200.00 .0% 62005563 563400 MWRA 3,410,216.70 3,555,143.00 3,844,457.00 3,137,665.60 3,921,051.00. 4,164,476.00 6.2% 62005574 574000 HEALTHINS 67,574.00 60,500.00 58,067.08 48,523.59 87,500.00 75,000.00 -14.3% 62005574 574010 P&C INSUR .00 663.00 627.00 726.00 1,000.00 1,100.00 10.0% 62005574 62005574 574500 574550 DEDUCT/CLM WC INSURNC .10,000.00 11,496.00 .00 8,250.00 8,415.00 10,161.00 .00 10,368.00 .00 15,000.00 .00 18,000.00 .0% 20.0% 62005578 578100 LICENSES 185.00 60.00 60.00. 60.00 .00 .00 .0% TOTAL EXPENSES 3,593,757.76 .3,729,073.90 `4,054,095.73 3,274,946.43 4,185,459.00 4,560,776.00 9.0% 07 DEBT SERVICE Town of Reading FY - 2012 Budget 312011113:54 New - Not Adin italics Approved [Debt Service FY - 2011 Requested Debt Servic FY 2012 Projected Projected Projected 'Projected Projected Projected Projected Projected Debt Service Debt Service Debt Service Debt Service Debt Service Debt Service Debt Service Debt Service FY - 2013 FY 2014 FY - 2015 FY 2016 FY - 2017 FY - 201FY - 2019 FY 2020 $ $ :1:65,113 $ ,1GZ2U6 $ 800.., $ 76;934 $ . 76 934 = $ $ 4 - 0 0 0 MWRA Inflow & Infiltration interest loan 85,800 85,800 0 0 0 85,800 76,934 76,93 0 0 Sunn side/Fairview Sewer 07-11 Nov 01 79,313 76,406 0 0 0 4 0 0 0 0 0 Dnnavmont of Prinrinal 760,800 160,800 85,800 76,934 76,93 MWRA Inflow & Infiltration MWRA Inflow & Infiltration MWRA Inflow & Infiitration 07-11 Nov 01 75,000 15,uuu 4,313 1,406 0 0 0 0 0 0 0 0 07-11 Nov 01 4,313 1,406 -4 Town of Reading FY - 2012 Budget 312011113:54 ' Projected Projected Projected Projected Projected Projected Projected Projected Debt Service Debt ServiceDebt ServICEDebt ServiceDebt ServICEDebt ServicEDebt Service)ebt Service New - Not Approved In italics ewer Fund< - FY 2021 FY-2022 S FY 2023 $ FY-2024 FY-2.0,25 = FY-2026 $ FY-20 27 FY 2028 MWRA Inflow & Infiltration interest loan 0 0 0 0 0 0 0 0 Sunn sidelFairview Sewer 07-11 Nov 01. 0 0 0 0 0 0 0 0 00 Repayment of Principal: 0 0 0 0 0 u u u MWRA Inflow & Infiltration MWRA Inflow & Infiltration MWRA Inflow & Infiltration Sunn side/Fairview Sewer 07-11 Nov 01 Interest on Lon Term Debt: 0 0 0 0 0 0 0 0 Sunn sidelFairview Sewer 07-11 Nov 01 ~1 Enterprise Fund Budgets Assum ationstorrY7s-rrro: wages f.wi° . - 1. 00% 5 5 00-/16 I Expenses 5.00% 5.00% . . d t P March 19, 2011 Approved Percent Requested Percent Estimated Percent Estimated Percent Estimated Percent Estimate 2016 FY ercen Chan e No FY - 2011 Change FY - 2012 Change FY - 2013 Change FY - 2014 Change FY - 2015 Change - g . Y1 Storm Water Salaries and Wages 70,076 0.00% 127,765 82.32% 130,320 2.00% 132,927 2.00% 135,585 1 2.00% 5 00% 138,297 575 71 2,00% 5 00% Y2 Expenses 19,750 -7.34% 58,885 198,15% 61,829 5.00% 64,921 330,000 5.00% 100.00% 67 68, 317,000 . -3.94% , 634,000 , 100.00% Y3 Y4 Debt Service Capital Outlay 288,000 44.00% 190,000 -34.03% 200,000 5.26% 150,000 -25.00% 150,000 752 0.00% 05% 1 158,500 372 002 1 5.67% 44% 49 Y5 Storm Water Fund 377,826 29.66% 376,650 -0.31% 392,150 4.127, 677,847 72.65% 670, . - , , 0000 . Reserves Net Storm Water 30,000 347,826 1937% 376,650 8.29`Y° 15,000 377,150 0.13°~ 677,847 79.73% 670,752 1.05% 952,372 41.99% $100 estimated SFhouse 387k/ $440 $40 +100kres. $80 +100kres. $80 LT tgt Reserve Fund levels Water 064 1 485 1,160,064 860,064 660,064 610,064 560,064 500k+ Sewer , , 792,756 792,756 792,756 792,756 717,756 617,756 590 410 500k+ 150k+ Storm Water 275,590 275,590 260,590 360,590 460,590 , "i W1 Water Salaries and Wages 632,349 0.00% 639,490 1.13% 652,280 2.00% 665,325 2.00% 678,632 44 2.00% 5 00% 692,205 041 299 3 2.00% 00% 5 W2 Expenses 2,698,736 -1.31% 2,714,129 0.57% 2,849,835 5.00% 2,992,327 286 5.00% 2 02% 3,141,9 901 1 539 . 52% 18 , , 529 661 1 . 7.90% W3 Debt Service 1,839,206 -2.70% 2,014,091 000 9.51% 97% 15 1,326,051 968 000 -34.16% 38% 217 1,299, 000 895 . - -7.54% , , 500,000 . -44.13% , , 365,000 -27.00% W4 Capital Outlay 263,000 -22.65%' % 305, 710 5 672 . 41% 4 , 166 796 5 . 2.18% , 5,851,939 0.96% 5,860,476 0.15% 6,017,774 2.68% W5 Water Fund 5,433,291 -2.93 , , . , , tgn nnni 150.0001 offsets forgen'ltund W99 Water Fund voted (sttsot) 5,055,924 te(r,Jul) 5,295,343 k-,..,.'/ 5,409,365 5,455,467 5,454,094 5,601,232 X1 Sewer Salaries and Wages 308,147 7.64% 267,908 -13.06% 273,266 2.00% 278,731 2.00% 284,306 498 2.00% 00% 5 289,992 473 858 5 2.00°!° 000/0 5 X2 Expenses 4,444,463 1.13% 4,819,780 8.44% 5,060,769 0 5.00% 10°! 47 5,313,807 934 76 5.00% 33% -10 5,579, 934 76 . 0.00% , , . -100.00% X3 Debt Service 165,113 32.93% 56% 23 162,206 157 000 -1.76% 76% -71 85,80 130 000 ° . - -17.20% , 37,000 . -71.54% , 100.00% 0.00% X4 X6 Capital Outlay Sewer Fund 556,001 473,724 5 . 4.16% , 5,406,894 . -1.220/a , 5,549,835 2,64% 5,706,473 2.82% 5,940,738 4.11% 6,148,465 3.50% , 75000 100,000 Reserves Net Sewer Fund 161,001 5,312,723 3 5,406,894 ' 1.77% 5,549,835 2.64% 5,706,473 2.82% 5,865,738 8 919 2.79% 6,048,465. 892) (285 3.12% offsets forgen'lfund (259,004) (259,004) (265,479) 4 6 (272,116) 434,357 5 , ) (27 819 5 661 , 5,862,573 X99 Sewer Fund voted 5,214,720 5;147,890 ,35 5,28 , , , W&S gross 10,907,015 11,079,604 11,346,001 % 11,558,412 0 11,801,214 000 125 12,166,239 000 150 W&S reserves 386,001 14 1 88% 325,000 604 754 10 22% 2 . nnn 046,001 11 2.71% 200,00 11,356,412 2.83% , 11,676,214 2.80% , 12,016,239 2.91% WS W&S net 10,521,0 . , , . , U i Benefits, Capital, Debt & Regional Schools FY12 Budgets BUDGETS FY10 FY11 FY12 Chan 2e' Benefits $10,951,082 $11,712,081 $12,845,486 +9.7% Capital $1,080,725 $1,273,000 $948,000 -25.5% Debt $5,765,113 $6,158,003 $6,063,446 -1.5% Regional Schools $377,964 $327,946 $369,343 +12.6% TOTAL $18,174,884 $19,471,030 $20,226,275 +3.9% Note: State Assessments $580,006 $568,602 $585,840 +3.0% (not voted by Town Mtg) N O Benefits Retirement ($3,097,986; +3.5%): Due to a previous decline in the investment value of retirement assets, the Retirement Board voted a larger than usual increase of +4.5% to the annual contribution required. Using actuarial assumptions, the Town is projected to meet all required funding dates: The Town's self- insured portion of this budget remains steady at $75,000; and a $15,000 expense pays the annual fees associated with seasonal and part-time employees' recent shift from social security to a 403(b) plan. premiums will be ameliorated by a 5% early payment discount. Recent claims are low, so we will absorb some of this increase by reducing that budget for FYI 2. . Worker Compensation ($325,000; +6.6%): The Town just received word to expect up to a 20% increase for FY12. This is not in line with recent claims history, and we will determine why that type of increase is projected. A $300,000 budget for n Unemployment Compensation ($150-,000; +20%): This is an increasingly difficult expense to forecast as the economy has slowed and federal eligibility rules continue to evolve. We have budgeted in anticipation of layoffs in the FY12 Town & School budgets. The FY11 budget of $125,000 is generally accurate for the year to date, but the monthly volatility is very high. Health & Life Insurance ($8,562,500; +12.3%): The FY12 budget allows for a 13.55% increase in health insurance premiums and an additional 2% in new enrollments, the latter a figure we have seen in FY 11 thus far. However, this budget makes some assumptions about changes that will save the Town about 3% and these are subject to collective bargaining. It also sets aside $20,000 to prepare to go out to bid if market conditions are appropriate next fall. Health insurance is the largest single budgeting challenge in municipal government finance, as it is in many private sector businesses. In the.public sector it is compounded by the fact the work force is about ten years older than in the private sector according to most recent studies. The public sector is also constrained by fact that engineering is not designing new products to sell and marketing is not enticing customers to buy more existing products. N Given the lower natural revenue growth, it is that much more imperative for the public sector to reign in health care costs, and the Town of Reading in conjunction with all of the unions from the Town, School and Light departments have made many plan design changes in recent years. These changes have been designed to shift the burden away from premium costs and onto the employees that use medical services in the form of higher out of pocket expenses. In addition, a shift to a so-called GIC look alike program'has served to make employees benefit from utilizing the most medical/cost-efficient providers. The Town pays 71% of total premiums, a figure that is still lower than many other communities who pay between 75% and 90% o. Over the past five years, the increase in health insurance budget costs is 5.5% per year - and 2.3% of that increase is from annual increases in enrollment, often brought on by spouses in the private sector losing their benefits. Medicare ($650,000; +7%): After a long history of underfunding this difficult to forecast expense, the MUNIS system was instrumental in properly projecting this beginning in FY10. A'7% increase is forecast, partly for rate increases and partly for ongoing demographic shifts in the workforce. .The annual rate of increase should now decrease in future years. Indemnification ($60,000; +3.9%): Police & Fire expenses can vary widely in this line item. Capital A similar amount of cash capital is available. in FY12. The large reduction shown above is due. to the fact that November Town Meeting added $280,000 for improvements to Causeway Road. The FINCOM 5% policy plus energy savings from performance contracting will support about $1 million in capital, and the priority projects amount to $948,000 of that allowance: Town Facilities ($222,000): $85,000 DPW security system; $40,000 Town Hall fire alarm upgrade, $25,000 exterior doors at the Senior Center; $20,000 carpetiflooring at Town Hall; $20,000 HVAC unit for Dispatch; $12,000 to rebuild front steps at Town Hall; $10,000 door replacements at the West-Side Fire Station; and $10,000 for two overhead doors at the DPW garage; School Facilities ($123,000): $25,000 each for PA systems at Birch Meadow and Kiliam; $25,000 to motorize RMHS field house bleachers; $24,000 to replace three cafeteria windows at Joshua Eaton; and $24,000 to replace tile damaged by moisture at Coolidge; Fire ($14,000) to replace firefighter air bottles; and Public Works ($589,000): $450,000 for local roads; $45,000 for the Joshua Eaton playground; $37,000 to replace a 1989 Chevy pickup for the Parks division; $32,000 to replace a 2000 Ford Explorer for the Engineering division; and $25,000 in general curb and sidewalk repairs for pedestrian safety. Debt There are no significant changes in FY12 for the Town's debt service. The $2 million Green Repairs program underway by the School Facilities department will replace windows at Birch Meadow elementary school, and replace the roof at Killain elementary school. Article 16 at the Annual Town Meeting this spring will provide a detailed update where the original scope of work will decrease and it may be desirable to increase the size of the debt authorization from $2.0 million to $2.25 million. This debt budget assumes one interest payment on the Town's share (52.79%) of a $2 million project. Town Meeting in November 2011 may need to make a small adjustment to this budget if Article 16 is approved, and the debt is sold. N N In FY13, the amount under this project will increase by about $100,000. In FY14 debt service on a $1.5 million cemetery garage is scheduled to begin, and in FYI 5 debt service on a $1.5 million Q DPW cold storage building is scheduled to begin. These three projects will take up a lot of slack in the debt budget that would have otherwise provided a big increase in annual `cash capital' that was previously forecast. Regional Schools The budget is increased for FY12 because of a new enrollment at Minuteman (costs include transportation). We have projected a 5% increase at Northeast but have not heard about our enrollment figures as of yet. N W Town of Reading, MA FY-2011 FY-2012 FY-2013 FY-2014 FY-2015 FY-2016 FY-2017 FY-2018 FY-2019 FY-2020 . FY-2021 FY12-21 ProjecteduseofSale ofR/EFund 300,000 300,000 250,000 200,000 150,000 100,000 50,000 - 1,050,000 NetAvailable Revenue annual % 5% NAR policy - debt & capital 3,540,577 3,533,287 2.12% 3,608,358 2.50% 3,698,567 2.50% 3,791,031 2.50% 3,865,807 2.50% 3,962,952 250% 4,082,526 250% 4,184,589 2,50% 4,2891204 4,396,434 39,452,755 9 " Debt Schedule - Net Included Debt 2,897,776 2,807,632 2,397,364 2,166,172 2,464,084 2,251,042 2,137,738 2,008,697 1,319,708 951,283 896,745 400,465 1 , Allowance for energy savings 317,869 300,000 655 1 025 300,000 994 510 1 300,000 395 832 1 300,000 947 1 626 300,000 934 765 1 300,000 2,145,214 300,000 2,373,829 300,000 3,154,881 300,000 3,637,921 300,000 3,799,609 3,000,000 23,052,290 - Avai ab a to fund Capita Dedicated funds to roads 960,670 (425,000) , , (450,000) , , (500,000) , , (550,000) , , (600,000) , , (650,000) (700,000) (750,000) (800,000) (850,000) (900,000) (6,750,000) Allocate to other requests 535,670 575,655 1,010,994 1,282,395 1,026,947 1,284,765 1,445,214 1,623,829 2,364,881 2,787,921 2,899,689 16,302,290 s Schools - Equipment - - 120,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 920,000 6 Buildings - Schools (non Energy) 1,020,000 49,000 105,000 127,000 471,000 526,000 130,000 39,000 1,504,000 685,000 ,000 3,63 Buildings - Schools (Energy) 1,000,000 74,000 12,000 12,000 - 42,000 158,000 - 15,000 25,000 26,000 364,000 000 1 635 Buildings - Town (non Energy) - 157,000 120,000 50,000 30,000 327,000 469,000 202,000 280,000 , , 240 OOD Buildings - Municipal (Energy) - 000 255 65,000 000 14 120,000 000 36 - 155,000 - 69,000 20,000 654,000 20,000 316,500 15,000 90,600 - 150,000 849,000 339,000 , 2,673,100 Public Safety - Fire , , , - 000 35 000 211 10,000 - - 35,000 291,000 PublicSafety - Police PublicWorks - Equipment 115,000 69,000 284,300 , 189,800 , 293,100 275;100 672,100 752,400 522,600 728,500 96,200 3,883,100 Public Works - Parks & Cemetery 45,000 45,000 75,000 778,000 295,000 200,600 545,000 730,600 1,450,800 767,000 45,000 4,932,000 Public Works - Roads 558,000 475,000 525,000 575,000 625,000 675,000 750,000 800,000 850,000 900,000 950,000 7,125,000 TOTAL CAPITAL 2,993,000 948,000 1,397,300 2,021,800 2,094,100 2,829,700 3,160,600 2,729,600 4,907,400 4,054,5(10 1,556,200 25,699,200 Dedicated to Roads (previous over-ride) 425,000 450,000 500,000 550,000 600,000 650,000 00 700,060 460 600 2 750,000 600 1 979 800,000 107 400 4 850,000 500 204 3 900,000 656,200 6,750,000 111,949,200 Capital Requests above road portion 2,568,000 0 498,000 655 575 897,300 994 1 010 1,471,800 282 395 1 1,494,100 947 026 1 2,179,7 765 284 1 , , 1,445,214 , , 1,623,829 , , 2,364,881 , , 2,787,921 2,899,689 16,302,290 Capital Funding to allocate Annual Surplus (Deficit) 568,00 (2,000,000) , 77,655 , , 113,694 , , (189,405) , , (467,153) , , (894,935) (1,015,386) (355;771) (1,742,519) (416,579) 2,243,489 Cumulative Surplus (Deficit) (189,405) (656,558) (1,551,493) (2,566,879) (2,922,650) (4,665,169) (5,081,74&) (2,838,259) 0 School Buildings 49,000 105,000 127,000 471,000 526,000 130,000 39,000 1,504,000 685,000 3,636,00 000 635 1 Town Buildings 157,000 120,000 50,000 00 30,000 327,000 000 62 469,000 178 000 202,000 000 15 280,000 15,000 25,000 26,000 , , 604,000 Energy Facilities Capital • 139,000 345,000 132,000 357,000 12,0 189,000 - 501,000 , 915,000 , 777,000 , 256,000 1,799,000 710,000 26,000 5,875,000 Facilities Debt 457 968 1 1,579,376 1,890,017 2,194,906 2,092,833 1,984,853 1,1361,177 1,319,708 951,283 896,745 16,739,354 Facilities Tot. , , 2,313,457 1,936,376 2,079,017 2,695,906 3,007,1133 2,761,853 2,117,177 3,118,708 1,661,283 922,745 22,614,354 000 45 000 75 778,000 295,000 200,600 545,000 730,600 1,450,800 767,000 45,000 4,932,000 Recreation , 000 83 , 300 340 379,800 398,100 939,100 988,600 843,000 707,600 1,577,500 435,200 6,692,200 Equipment Roads , 475,000 , 525,000 575,000 625,000 675,000 750,000 800,000 850,000 900,000 950,000 7,125,000 Technology - 100,000 100,000 275,000 100,000 100,000 . 100,000 100,000 100,000 100,000 1,075,000 24 200 Other Capital 603,000 1,040,300 1,832,800 1,593,100 1,914;700 2,383,600 2,473,600 3,108,400 3,344,500 1,530,200 , 19,8 Other Debt 175 839 817,988 276,155 269,178 158,209 152,885 147,520 - - - 2,661,109 Other Total , 1,442,175 1,858,288 2,108,955 1,862,278 2,072,909 2,536,485 2,621,120 3,108,400 3,344,500 1,530,200 22,485,309 ems.„ Y \t) G A S N -P MA Town of Reading FY-2011 FY-2012 FY-2013 FY-2014 FY-2015 FY-2016 FY-2017 rY-ZUUJ rY-zu-ty rY-4ucu rY -Luci r T iG-r i . , t 120 000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 . 100,000 920,000 c oo s - gmpmen , Technology - Districtwide Infrastructure 000 100 000 100 100,000 100,000 100,000 100,000 100,000 100,000 100,000 900,000 Technology - Instructional Equipment , , 20,000 Vehicles s (Total) i 000 020 2 000 123 20,000 117,000 139,000 471,000 568,000 288,000 39,000 1,519,000 710,000 26,000 4,000,000 ings - coo u ui tngs - coos (Energy) , , 1,000,000 , 74,009 12,000 12,000 - 42,000 158,000 15,000 25,009 26,000 364,009 Buildings - Schools (non Energy 1,020,000 49,000 105,000 127,000 471,000 526,000 130,000 39,000 1,504,000 685;000 - 3,636,000 Energy (Performance Contracting) various item sfinancedby DEBTfor13yTs 50,000 Electrical Systems Sch S h - 50,000 - 000 12 12,000 22,000 158,000 15,000 25,000 26,000 270,000 HVACIEnergy Mgmt Systems c , 000 44 Windows & Doors Sch 1,000,000 24,000 - 20,000 , Generators Sch - - Technology Infrastructure Sch Water Heater Sch ADA Compliance Sch _ Ceilings Sch 14,000 14,000 Classroom Furniture Sch - Compressors Sch Fire Alarms Sch - 181000 Cafeteria Equip. & Furniture Sch 18,000 Plumbing CapetrFiooring Sch Sch - - 24,000 83,000 109,000 79,000 - • 134,000 - 80,000 25,000 534,000 00 Roofing Sch 1,000,000 - 392,000 392,000 - - 1,504,000 685,000 2,973,0 Security System Sch 20,000 - Fire Supression System Sch - 000 50 97,000 Other . Sch 25,000 22,000 , - JAb- ~ nrej 14.- ,r~, dw Town of Reading, NU FY-2011 FY-2012 FY-2013 FY-2014 FY-2015 FY-2016 FY-2017 FY-2018 FY-2019 FY-2020 FY-2021 FY12-21 875 000 1 ut mgs - umcipa - 222,000 240,000 50,000 30,000 347,000 489,000 217,000 280,000 , . , _ 000 240 Buildings - untcipa (Energy Buildings - Municipal (non Energy) 65,000 157,000 120,000 120,000, - 50,000 30,000 20,000 327,000 20,000 469,000 15,000 202,000 _ 280,000 , 1,635,000 Energy (Performance Contracting) various items financed by DEBT (or 15yrs - Electrical Systems Mun n M - 000 20 35 000 20,000' 20,000 15,000 110,000 HVACIEnergy Mgmt Systems u , , 100,000 Windows & Doors Mun 45,000 55,000 30,000 Generator Mun 30,000 _ Technology Infrastructure Mun Water Heater mull ADA Compliance Mun , 10,000 Ceiling Mun 10,000 _ Furniture Mun Compressor MU/7 40,000 Fire Alarm Mun 40,000 - Kitchen/Cafeteria AMR Plumbing Capefflooring Mun Mun - 20,000 10,000 30,000 327,000 469,000 202,000 280,000 60,000 1,278,000 Roofing Mun - - - 85,000 N Security System Mun 85,000 01 Fire Supression System Mun 162,000. Other (DPW design'13,'14) Mun 12,000 100,000 50,000 , v vv ~ n 0 CJu"" "~S N M Town of Reading, MA FY-2011 FY-2012 FY-2013 FY-2014 FY-2015 FY-2016 FY-2017 FY-2018 FY-2019 FY-2020 FY-2021 FY12-21 Library umis ings. Shelving yr- o or renovation ecision Circulation System ($100k - hold for renovation decision) Debt Excl Debt Excl Debt Exc/ Debt Excl Debt Excl Debt Excl Debt Excl Debt Excl Debt Excl Renovation ($12mil project) - ire u is a et 255,000 14,000 36,000 155,000 69,000 654,000 3161500 90,600 150,000 849,000 339,000 2,673,100 y Pumper Eng #1(2010-$525k; next FY30) Debt Debt 'Debt Debt Debt Pumper Eng #2(2007-$410k; next FY25) Debt Debt Debt 630 000 Pumper Eng #3(1995: est $630k FY16) 630,000 804,000 , 804,000 Pumper Eng #4(2001: est $804k FY20) Ladder Trk 91(2008: $800k, next FY27) Debt Debt Debt Debt Debt Debt Debt Debt 284,000 294,000 Ambulance #1 (2000-10 yrs) 230,000 275,000 275,000 Ambulance #2 (2006 -10yrs) Patient Care Reporting System 25,000 41,500 41,500 Passenger Car#1(2005-10yrs) 45,000 45,000 Passenger Car#2 (1997 -10yrs) 45,600 45,600 Pickup Truck #3 (2006 -12yrs) ' 36,000 Pickup Truck #4 (1996 -12yrs) 36,000 000 69 Alarm Truck (1994-16yrs) 69,000 24 000 , 24,000 ALS Defibrillator (2006 - 5yrs) , 45,000 45,000 Rescue Tool(2006 -12yrs) 14,000 Breathing Air Bottles 14,000 45,000 45,000 Thermal Imaging (2010 -10yrs) 25,000 Fire Hose 25,000 000 130 150,000 260,000 Tumout Gear (2008 - 5yrs) , 000 35 211 000 10,000 35,000 291,000 u is a ety - Police/Dispatch , , 000 10 10,000 Handguns & Associated Leather (Police) , 16,000 Digital Fingerprint Scanner 16,000 000 35 70,000 Vehicle Video Integration 35,000 , 20,000 AEDs 20,000 175,000 Public Safety software ($175k) 175,000 MA Town of Reading FY-2011 FY-2012 FY-2013 FY-2014' FY-2015 FY-2016 FY-2017 FY-2018 FY-2019 FY-2020 FY-2021 FY12-21 100 883 3 , Public or - qurpment 115,000 69,000 284,300 189,800 293,100 275,100 672,100 752,400 522,600 728,500 96,200 0 , , 000 990 Large Trucks Life 115,000 60,000 115,000 64,000 280,000 123,000 72,000 276,00 , 000 123 Truck #4 - Sander (2001) 15 220,000 123,000 , 220,000 Truck #8-10 wheeler (2000) 15 136,000 136,000 Truck #9 - Sander (2004) 15 Truck #16 -Sander(1990) 15 115,000 140,000 140,000 ' Truck #19 - Sander (1987) 15 000<---.. 60 60,000 a. ump Truck C2 (1996) 10 , 000 60, 60,000 ZM Dump Truck C3 (1999) ' 10 000 115 115,000 Truck #10 (1996) 15 , 64 000 64,000 Dump truck #12 Parks (1997) 15 , 72,000 72,000 Dump truck #24 Parks (2000) 15 69 000 35,000 81,000 113,700 39,500 48,700 130,000 95,000. 611,900 Pick-ups/Cars/Vans , 35,000 Pickup Ford Utility #11 (1989) 10 35,000 31,000 Pickup Chevy #9 Parks (1986) 10 37,000 46,000 Pickup Ford Utility #C1 (1997) 10 46,000 000 46 46,000 Pickup Ford #2 Parks (1997) 10 , 85,000 85,000 Pickup Chevy Utility #1 (2008) 10 50,000 50,000 Pickup Ford Utility #4 (1997) 10 35,000 N Pickup Ford Utility #7 (1997) 10 35,000 36,500 v HV3 Ford Van (1995) 10 36,500 39,500 39,500 HV4 Ford Van (1995) 10 48,700 48,700 HV5 Ford Van COA (2003) 10 32,000 Survey #1 Ford Explorer (2000) 10 32,000 45,000 45,000 Car#2 Ford Sedan (2007) 10 45,000 45,000 Car#3 Ford Escape HYBRID (2008) 10 31,200 Cem. #4 Ford Sedan (1993) 10 31,200 400 32 000 200 96,000 180,000 613,400 t E i 105,000 , , pmen qu BackhoeslLoaderslHeavy 96,000 96,000 Backhoe Loader (Cem.)(2008) 10 200,000 200,000 Loader JD #624G (2007) 10 180,000 180,000 Loader Cat #928F (1994) 10 400 32 32,400 Bobcat Loader 743 (1987) 10 , 105,000 CAT Bulldozer 951 (1971) 105,000 r16 ~"au s Town of Reading, MA FY-2011 FY-2012 FY-2013 FY-2014 FY-2015 FY-2016 FY-2017 FY-2018 FY-2019 FY-2020 FY-2021 FY12-21 Specialty Equipment - Heavy Duty 168,700 255,000 217,000 135,000 111,000 886,700 48`700 Tractor Ford 445 (Parks) 15 48,700 82,000 82,000 Roller - Ferguson 46A (1988) 15 135,000 5,000 13 Screener (1994) 15 000 130 130,000 Pavement Leeboy Sprd (1998) 10 , 111,000 111,000 Sidewalk Snow Plow #3(2008) 10 120,000 Snow -Holder #1 C6000 (1995) 10 120,000 135,000 135,000 Snow - Holder #2 C9700 (1997) 10 000 125 125,000 Snow - Bombardier #1 (1993) 10 000 20 800 37 26,800 30,000 , 43,000 81,500 891600 66,500 395,200 Specialty Equipment - Light Duty , , 800 26 HW Comp2 INT Compr (1995) 10 26,800 21 000 , 21,000 300L Lebot (Roller) (1998) 10 , 37,800 Eager Beaver Trailer (1985) 15 37,800 66,500 66,500 1CH Woodsman Chipper (2004) 10 39,500 39,500 1GV Leaf Vac (1999) 10 46,000 46,000 2CH Mobark (1989.) 10 43,600 4 3,600 2GV Leaf Vac (2000) 10 42,000 42,000 SmithCo 60 Leaf Vac (1999) 10 20,000 Toro 48" LeafVac (1993) 10 20,000 000 30 N 00 FMC Truck Mount Sprayer 500gal 30,000 22,000 , 22,000 SmithCo 13-550 Infield (1994) 7 600 15 70,300 35,000 54,600 82,200 96,200 353,900 Lawnmowers , 500 17 , 17,500 Mower (Cem.) SKAG 72" (1998) 4 , 200 18 18,200 Mower (Cem.) SKAG 61" (1999) 4 300 70 , 96,200 166,500 Mower (Parks) TORO Gang (1996) 8 , 200 18 33,800 Mower (Cem.) SKAG 52" (1995) 4 15,600 500 17 , 17,500 Mower (Parks) SKAG 52" (1998) 4 , ,200 82 82,200 Mower - TORO Gang (2008) 6 200 18 18,200 912F#2 John Deere Mower (1989) 7 , 32,000 Engineering Equipment/Services - - 20,000 . 12,000 32,000 Survey Equipment/Plan Plotter 00 000 45 201000 75 000 12,000 000 778 295,000 200,600 545,000 730,600 1,450,800 167,000 45,000 4,932,000 Public or - Parks emett 45,0 , , , Public or - Cemetery Cam garage - design $100k (in Town Facilities FYI 3) Cem garage - $1.5mil (debt FY14-18) d - - 000 30 Debt 50,000 Debt 20,000 Debt 50,000 Debt 20,000 Debt 50,000 20,000 50,000 20,000 310,000 Groun s u is or cs - , 000 30 20,000 20,000 20,000 20,000 110,000 Fence Replacement , 000 50 50,000 50,000 50,000 200,000 Parking Lot Pavement , Cold storage building - design $50k (in Town Facilities FY14 ) D bt Debt Debt Cold storage building - $1.5mil (debt FY15-19) Debt Debt e N CD Town of Reading, MA u 1c or - ar s FY-2011 45,000 FY-2012 45,000 FY-2013 45,000 FY-2014 728,000 FY-2015_ 275,000 FY-2016 150,600 FY-2017 525,000 FY-2018 660,600 FY-2019 1,430,800 FY-2020 FY-2021 717,000 25,000 FY12-21 4,622 000 Tennis Courts -Bancroft Ave. $485k Debt Debt Debt 000 150 150,000 Artificial Turf@Parker MS $736k . Debt Debt Debt 250,000 , 250,000 Coolidge MS field upgrade (grass) Reconstruct Playgrounds Program 30,000 45,000 45,000 45,000 45,000 25,000 25,000 25,000 25,000 25,000 25,000 330,000 Killam Josh Eaton Sturges Wood End up Hunt Pk BM Tot lot Wood End do Mem Park B Meadow Barrows Playground safety surface 15,000 Memorial Park $650k grant in FY10 Washington Park $625k 129,000 233,000 100,000 s 462,000 (also playground in FY10) tennis ct backstop & shift field path 124,000 124,000 basketball ct Birch Meadow Complex = $2.116 mil 230,000 110,000 150,000 1,100,000 39,000 1,629,000 (also playgrounds in FY16&FY19) BB courts Man bkstop softball light fields & paths st. backstop 000 59 Multi-Purp cts dugouts 20,000 39,000 , Playground $430k (Imagination Station) 430,000 bleachers batting cage lot backstop 430,000 500 219 Barrows $296k 95,000 124,500 , (also playground in FY09) backstop tennis ct- 1 78 100 & infield 78, 00 , basketball ct 30,600 30,600 Killam $30.6k backstop (also playground in FYI 1) 140,000 39,000 179,000 Joshua Eaton $179k backstop backstop (also playground in FY12) & infield 50,000 50,000 Symonds Way $.50k backstop 125,000 125,000 Hunt Park $125k backstop (also playground in FY15) 63,800 63,800 . Sturges Park $178.7k tennis ct (also playground in FY13) 80,000 80,000 basketball ct 37,000 37,000 backstop 325,000 325,000 Wood End $325k field W O Town of Reading, MA FY-2011 FY-2012 FY-2013 FY-2014 FY-2015 FY-2016 FY-2017 FY-2018 FY-2019 FY-2020 FY-2021 FY12-21 Over-ride local share (previous schedule) 355,952 364,851 373,972 383,321 392,904 402,727 412,795 423,115 433,693 444,535 3,631,912 -50k/yr - Over-ride local share (new schedule) 425,000 450,000 500,000 550,000 600,000 650,000 700,000 750,000 800,000 850,000 900,000 6,750,000 Public Works - Roads 558,000 475,000 525,000 575,000 625,000 675,000 750,000 800,000 850,000 900,000 950,000 7,125,000 Sidewalk/Curb/Ped. SA Street Signs 40,000 10,000 . 25,000 25,000 25,000 25,000 25,000 50,000 50,000 50,000 50,000 50,000 375,000 Downtown Improve ($650k 10yr bond) Reconstruction: West Street Debt Debt Debt 7,500,000 Debt Debt Debt Debt Debt 7,500,000 Skim Coating & Crack Seal Patch Various Streets/local fund Repair Killam parking lot West Street design ($155k) West Street - Local share ($480k) Various Streets/Ch. 90 fund or grants 50,000 375,000 83,000 450,000 50,000 400,000 50,000 50,000 295,000 155,000 450,000 50,000 260,000 240,000 450,000 50,000 310,000 240,000 450,000 50,000 600,000 50,000 50,000 650,000 50,000 50,000 700,000 50,000 50,000 750,000 50,000 50,000 800,000 50,000 50,000 850,000 50,000 500,000 5,615,000 155,000 480,000 4,500,000 Total Cost of Roadwork 1,008,000 925,000 8,475,000 1,025,000 1;075,000 1,125,000 1,200,000 1,250,000 1,300,000 1,3501000 1,400,000 19,125,000 Chapter 90 or Grants General Fund Cost 450,000 558,000 450,000 475,000 7,950,000 525,000 450,000 575,000 450,000 625,000 450,000 675,000 450,000 750,000 450,000 800,000 450,000 850,000 450,000 900,000 450,000 950,000 12,000,000 7,125,000 /1---1 . w Debt Service Schedule `o\t~ S of 111-FY25 f Town of Reading FY - 21 Budget Requested Projected Projected Projected Projected Projected Projected rrq/ectea rrojectea vrojectea n uJeeiea rI VJU6LUU r-J-- J 25 3/20111 11:00 AM FY - 2011 FY - 2012 FY - 2013 FY - 2014 FY - 2015 FY - 2016 FY - 2017 FY - 2018 FY - 2019 FY - 2020 FY - 2021 FY - 2022 FY - 2023 FY - 2024. FY - 20 $ $ Debt Service Schedule $ $ $ $ $ $ $ $ $ $ $ $ Overview 003. 158 Hera ° un 6 e 6;063,446:; 5;696,530>, 5 412;9p6 5 701;880 5;465;201, :5,329 446 ;5;193,155 4 502,148;;; 4;.130,884 .;4;059;738 :3;522;694='.3;373 794 ;:-3,344,600 _ ;336,188?; , 1 . Principal 4,165,000 4,185,000 3,915;580 3,715,580 4,055,580 4,005,580 4,060,580 4,100,580 3,585,580 1 0 3,370,580 580 215 1 3,455,580 580 210 1 3,080,580 740 580 3,075,000 000 535 3,185,000 000 635 330,000 330,000 Within Levy Limit 2,595,000 2,570,000 2,250,580 1,990,580. 000 2,270,580 000 1 785 2,155,580 850 000 1 2,140,580 000 920 1 2,110,580 000 990 1 5,58 1,5 000 070 2 , , 2,155,000 , , 2,245,000 , 2,340,000 , 2,440,000 , 2,550,000 0 Debt Exclusion 1,570,000 1,615,000 1,665,000 1,725, , , , , , , , , , , 5 8 304 760 556 603 114 442 298 794 159 600 61188 003 993 terest 1 I 446 878 1 1,730,950 1,697,326 1,646,300 1,459,621 1,268,865 1,092,575 6 916, , , , , , , , n Within Levy Limit 764,812 , , 699,668 608,820 637,628 655,540 557,498 459,194 360,153 266,164 197,739 148,201 98,470 644 343 71,620 174 227 46,976 624 112 6,188. 0 Debt Exclusion 1,228,191 1,178,778 1,122,131 1,059,698 990,761 902,123 809,673 732,423 650,404 562,565 455,356 , , , Total Within Lev Limit: 3,359,812 3,269,668 2,859,400 2,628,208 2,926,120 2,713,078 2,599,774 2,470,733 1,781,744 1,413,319 1,358,781 839,050 30 714 706,620 620 706 681,976 976 681 336,188 188 336 Issued 3,359,812 3,242,106 2,726,257 2,100,322 2,022,990 1,851,704 1,780,156 1,692,871 1,345,639 1,299,470 1,247,689 , 7 , , 0 , 0 Approved not issued _ 0 27,563 133,143 130,386 127;630 . 124,874 122,118 119,361 116,605 113,849 111,093 108,336 0 0 0 Not approved 0 0 0 397,500 775,500 736,500 697,500 658,500 319,500 0 0 0 0 0 0 MSBA share(Coolidge) 462,036 462,036 462,036 4 462,036 462,036 084 464 2 462,036 042 251 2 462,036 137,738 2 462,036 697 008 2 462,036 319 708 1 462,036 951,283 462,036 896,745 462,036 377,014 0 706,620 681,976 336,188 Net Included Debt 2,897,776 889 122 School Buildings(net) 1 2,807,632 054,445 1 2,397,36 . 986,484 2,166,172 909,081 , , 845,426 , , 792,228 . , 733,960 , , 662,928 , , 474,940 439,240 403,265 (102,779) 346,508 333,620 0 0 , , Town Buildings 440,000 , 420,000 0 893 592 397,500 436 583 775,500 980 573 736,500 564 105 697,500 393 553 658,500 749 539 319,500 525,268 0 . 512,043 0 493,480 0 479,793 0 360,113 0 348,356 336,188 Energy/Green Repair 473,988 494,013 457 968 70°l0 1 , 376 1 579 , 1,890,017 , 2,194,906 , 2,092,833 , 1,984,853 , 1,861,177 1,319,708 951,283 896,745 377,014 706,620 681,976 336,188 Recreation 184,369 , , 178,565 , , 172,855 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Equipment 300,613 292,710 285,170 199,130 194,590 86,100 83,660 81,220 0 0 0 0 0 0 Roads .84,419 81;900 79,463 77,025 74,588 72,109 69,225 66,300 0 0 0 0 0 0 Technology 291,500 286,000 280,500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .0 3077° 839,175 , 817,988 276,155 269,178 158,209 152,885 147,520 0 6 4 565 717 2 356 700 2 644 683 2 174 2 667 662;624 0 2 Total Debt Exclusion: 2,798,191 2,793,778 2,787,131 2,784,698 2,775,761 2,752,123 2,729,673 7 2,722,423 423 722 2 2,720,40 404 720 2 , , 565 717 2 , , 356 700 2 , , 683 644 2 , , 2,667,174 , 2,662,624 0 Issued 2,798,191 2,793,778 2,787,131 2,784,698 925 72 2,775,761 695 800 2,752,123 779 830 29,673 2, 177 863 , , 895 575 , , 932,601 , , 971,942 , , 1,013,596 , , 1,057,565 1,103,848 1,154,759 0 MSBA share e2t. 698,872 722,014 745,155 , 7 , , , , 7 803 1 7 624 745 1 760 686 1 079 626 1 553,326 1 1,507,864 0 099 319 Net Excluded Debt 2 764 071 2 2,041,975 2,011,773 1,975,066 1,921,344 1,866,496 1,826,648 , , 8 , , , , , , , , , , , SCHOOLS per $400k SF home 219 216 212 206 200 196 192 187 181 174 168 162 400 104 104 104 104 104 104 104 104 104 104 Estimate for Library -local share $7mil of $12mil 970,049 970,049 970,049 970,049 970,049 970,049 970049 970,049 970,049 970,049 NI, ~Z~ Iv CLJ & _1 Debt Service Scheddle FY11-FY25 W N Town of Reading FY - 21 Budget 3120111 11:00 AM FY-2011 Requested FY-2012 Projected FY-2013 Projected Projected FY-2014 FY-2015 Projected FY-2016 Projected FY-2017 Projected Projected FY-2018 FY-2019 Projected Projected FY-2020 FY-2021 Projected Projected FY-2022 FY-2023 Projected Projected FY-2024 FY-2025 Debt Service Schedule $ Overview Principal + Interest' Within'Le 'L!imrt , .33S9,812T $ 3,269;668'; $ $ $ $ 2,859,400 ;2;628;208 2;926,120. Y7]3,078. $ $ $ $ $ $ $ $ 2599,774 _2,470i733r 1,781;74;4'. 9;413;319 ;1;356781 :639,05Q =,706,620-; .681976'. $ 336,:.188 Issued 3,359,812 3,242,106 2,726,257 2,100,322 2,022,990 1,851,704 1,780,156 1,692,871 1,345,639 1,299,470 1,247,689 730,714 706,520 681,976 336,188 Approved not issued 0 27,563 133,143 .130,386 127,630 124,874 122,118 119,361 116,605 113,849 111,093 108;336 0 0 0 Not approved 0 0 0 397,500 775,500 736,500 697500 658,500 319,500 0 0 0 0 0 0 remium RMHS 15,595 15,595 15,595 15,595 15,595 15,595 15,595, 15,595 15,595 15,595 15,595 15,595 15,595 15,595 0 Energy Improvements 473,988 466,450 459,750• 453,050 446,350 439,231 431,275 420,388 408,663 398,194 382,388 371,456 360,113 348,356. 336,188 Green Re W (1.05mil) 0 27,563 133,143 130,386 127,630. 124,874 122,118 119,361 116,605 113,849 111,093 108,336 0 0 0 BarrowsMd End $522k 47,025 45,900 44,775 43,650 42,525. 41,400 39,900 38,400. 37,200 36,000 34,800 33,600 32,400 31,200 0 Wood End 235,913 230,663 225,263 219,713 •212,963 206,213 199,463 193,463 187,463 181,463 175,313 169,125 162,825 156,450 . 0 Barrows 202,134 197,584 192,904 183,094 177,469 17.1,844 166,219 161,219 156,219 151,219 146,094 140,938 135,688 130,375 0 Coolidge 735,000 711;250 687,500 663,750 640,000 616,250 587,500 564,000 540,500 517,000 493,500 0 0 0 0 Parker@ 274,988 258,125 246,491 230,086 218,910 202,963 187,320 152,288 0 0 0 0 0 0 0 Joshua Eaton@ 53,203 41,830 25,839 15,229 0 0 0 0 0 0 0 0 0 0 0 Birch Meadow@ 21,068 15,534 10,153 0 0 0 0 0 0 0 0 0 0 0 0 Parker Turf $375k 82,125 79,219 76,406 0 0 0 0 0 0 0 0 0 0 0 0 Tennis Courts $485k 102,244 99,346 96,449 0 0 0 0 0 0 0 0 0 0 0 0 Downtown im r $650k 84,419 81,900 79,463 77,025 74,588 72,109 69,225 66,300 0 0 0 0 0 0 0 Police Station 440,000 420,000 0 0 0 0 0 0 0 0 0 0 0 0 0 Ladder truck $800k 98,300 95,860 93,420 90,980 88,540 86,100 83,660 81,220 0 0 0 0 0 0 0 Pum er En #2 $410k 87,600 84,500 81,500 0 0 0 0 0 0 0 0 0 0 0 0 Financial S s $1.1mi1 291,500 286,000 280,500 0 0 0 0 0 0 0 0 0 0 0 0 Pumper En#1$525k 114,713 112,350 110,250 108,150 106,050 0 0 0 0 0 0 0 0 0 0 •Cem. Garage ($1.5m 0 0 0 397,500 378,000 358,500 339,000 319,500 0 0 0 0 0 0 0 Cold Stara e ($15m) 0 0 0 0 397,500 376,000* 358,500 339,000 319,500 0 0 0 0 0 0 : Detit'Exelusion , 2,798091; -2,793;778 2;787,131 .2;784;698 2;775,761. 2;752,123 ;-2,729,673,::.2 722;423 "2;720;404 ,'2,717,565 ' 2;700,356 : 2,683 644: -2'667j174 > 2;662;624 BarrowsMd End $787k 75,725 68,850 67,163 65,475 63,788 62,100 59,850 57,600 55,800 54,000 52,200 50,400 48,600 46,800 0 RMHS 2,706,735 -2,709,550 2,704,950 2,704,575 2,697,775 2,676,275 2,656,525 2,651,925 2,652,106 2,651,468 2,636,469 2,621,969 2;607,719 2,605,394 0 Wood End 15,728 15,378 15,018 14,648 14,198 13,748 13,298 12,898 12,498 12,098 11,688 11,275 10,855 10,430 0 N -_.J 3 0 Debt Service Schedule FY11-FY25 W W Town of Reading FY -'I Budget Requested Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 312011111:00 AM FY - 2011 FY-2012 FY-2013 FY-2014 FY-2015 FY-2016 FY-2017 FY-2018 FY-'2019 FY-2020 FY-2021 FY-2022 FY-2023 FY-2024 FY-2025 Debt Service Schedule $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Overview Issued 2,595,000 2,570,000 2,145,000 1,585,000 1,565,000 1,450,000 1,435,000 1,405,000 1,110,000 1,110,000 1,105,000 635,000 635,000 635,00 33U,UUU Approved not issued 0 105,580 105 580 - 105,580 - 105,580 105,580.- 105,580 105,580 105,580 105,580 105,580 0 0 0 Alntannmvad -n 0- 0 300.000 600,000 600,000 600,000 600,000 300,0000 0 0 0 0 0 remium RMHS Energy Improvements 335,000 335,000 335,000 335,000 335,000 335,000 335,000 335,000 335,000 335,000 330,000 330,000 330,000 330,000 330,000 Green Repair (1.05mil). BarrowsMd End $522k Wood End 30,000 150,000 . 30,000 150,000 105,580 30,000 150,000 105,580 30,000 150,000 " 105,580 30,000 150,000 105,580-, 30,000- 150,000 105,580 30,000 150,000 105,580 30,000 150,000 105,580 30,000 150,000 105,580 30,000 150,000 105,580 30,000 150,000 105,580 30,000 150,000 30,000 150,000 30,000 150,000 Barrows 130,000 130,000 130,000 125,000 125,000 125,000 125,000 125,000 125,000 125,000 125,000 125,000 125,000 125,000 Coolidge 475,000 475,000 475,000 475,000 475,000 475,000 470,000 470,000 470,000 470,000 470,000 ParkeQ 230,000 220,000 215,000 205,000 200,000 190,000 180,000 150,000 Joshua Eaton@ 50,000 40,000 25,000 15,000 Birch Meadow@ 20,000 15,000 10,000 Parker Turf $375k 75,000 75,000 75,000 Tennis Courts $485k 95,000 95,000 95,000 own own m r Police Station 400,000 400,000 Ladder truck $800k 80,000 80,000 80,000, 80,000 80,000 80,000 80,000 80,000 Pumper En#2$410k 80,000 80,000 80,000 Financial S s $1.1mi1 275,000 275,000 275,000 Pumper En #1 $525k 105,000 105,000 105,000 105,000 105,000 Cem. Garage ($1.5m) 300,000 300,000 300,000 300,000 300,000 Cold Storage 015m) ;Debt Exclusion . 11570,000 BarrowsMd End $787k 50,000 RMHS 1,510,000 Wood End 10,000 ,?1;615;000. 45,000 1,560,000 10,000 ;1,665;000 .1,725,000 45,000 45,000 1,610,000 1,670,000 10,000 10,000 300,000 ;1,785;000 45,000 1,730,000 10,000 =M 300,000 - -7 850,000 ::1;920,000 . 45;000 45,000 1,795,000 1,865,000 10,000 10,000 300,000 =1,990;000= 45,000 1,935,000 10,000 300,000 :2;070;000 . 45,000 2,015,000 10,000 2;155;000. 45,000 2,100,000 10,000 -2 245;000;: 45,000 2,190,000 10,000 =2;390,000.:2,990,000' 45,000 45,000 .2,285,000 2,385,000 10,000 10,000 ; 2;550 000,- 0< 45,000 2,495,000 10,000 N tW,3 i W Debt Service Schedule FY11-FY25 Town of Reading FY -2' Budget Requested Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 3120111 11:00 AM FY - 2011 FY-2012 FY-2013 FY-2014. FY-2015 FY-2016 FY-2017 FY-2018 FY-2019 FY-2020 FY-2021 FY-2022 FY-2023 FY-2024 FY-2025 Debt Service Schedule $ $ $ $ $ $ $ $ $ $ $ $ $ $ Overview Issued 764,812 672,106 581,257 515,322 457,990 401,704 345,156 287,871 235,639 189,470 142,689 95,714 71,620 4b,yt6 b,166 Approved not issued 27,563 27,563 24,806 22,050 19,294 16,538 13,781 11,025 .8,269 5,513 2,756 0 0 0 A/nt nnnmvod n n 0 .97500 175.500 136,500 97,500 . 58,500 19,500 0 0_ 0 0 0 0 remium RMHS 15,595 15,595 15,595 15,595 15,595 15,595 15,595 15,595 15,595 15,595 15,595 15,595 15,595 15,595 Energy Improvements 138,988 131,450 124,750 118,050 111,350 104,231 96,275 85,388 73,663 63,194 52,388 41,456 30,113 18,356 6,188 Green Repair (1, 05mi# 27,563 27,563 24,806 22,050 19,294 16,538 13,781 11,025 8,269 5,513 2,756 BarrowsMd End $522k 17,025 15,900 _ 14,775 13,650 12,525 11,400 9,900 8,400 7,200 6,000 4,800 3,600 2,400 1,200 Wood End 85,913 80,663 75,263 69,713 62,963 56,213 49,463 43,463 37,463 31,463 25,313 19,125 12,825 6,450 Barrows Coolidge 72,134 260,000 67,584 236,250 62,904 212,500 5.8,094 188,750 52,469 165,000 46,844 141,250 41,219 117,500 36,219 94,000 31,219 70,500 26,219 47,000 21,094 23,500 15,938 10,688 5,375 Parker0 44,988 38,125 31,491 25,086 18,910 12,963 7,320 2,288 Joshua Eaton@ 3,203 1,830 839 229 Birch Meadow@ 1,068 534 153 Parker Turf $375k 7,125 4,219 1,406 Tennis Courts $485k 7;244 4,346 1,449 Downtown Im r $650k 19,419 16,900 14,463 12,025 9,588 7,109 4,225 1,300 Police Station 40,000 20,000 Ladder truck $800k 18,300 15,860 13,420 10,980 8,540 6,100 3,660 1,220 Pumper En #2 $410k 7,600 4,500 1,500 Financial S s $1.1mi1 16,500 11,000 , 5,500 Pumper En#1 $525k 9,713 7,350 5,250 3,150 1,050 Cem. Garage ($1.5m 97,500 78,000 58,500 39,000 19,500 Cold Storage ($15m) 'Debt'Ekcldsion _ :5 ;1,229;191=. 1°,178;7.78 ,1;122131. ::1;059,698 97500 78,000 ?:990,761., 902,123 58,500 809;67.3. 39,000 19,500 ' 732;423 650;404 .:5fi2,565 455,356.. ;343`64,V-.-'---, . :712;624. 0= BarrowsMd End $787k 25,725 23,850 22,163 20,475 18,788 17,100 14,850 12,600 10,800 9,000 7,200 5,400 3,600 1,800 RMHS 1,196,738 Wood End 5,728 1,149,550 5,378 1,094,950 5,018 1,034,575 4,648 967,775 4,198 881,275 3,748 791,525 3,298 716,925 2,898 637,106 2,498 551,468 2,098 446,469 1,688 336,969 1,275 222,719 855 110,394 430