The URL can be used to link to this page

Home My WebLink About2012-04-11 Finance Committee PacketThe Town of Reading - Finance Contrnittee http://www.readingma.gov/Pages/ReadingMA_MeetingCal/SO 1784B... Google Search opmr� Fad . JU Finance Committee Wednesday, April 11, 2012 at 7:30 PM Town Hall Conference Room Printer - Friendly Version Agenda Water & Sewer update FY12 budget status FY13 BOS Rate Hearing update from 4/10/12 Revote Town Meeting Warrant Article 4 - amend 2012 -2021 CIP Article 6 - amend FY12 budget Article 13 - FY13 budget (Water) Article 14 - Chapter 90 funds . Other business COMMON GUS Town of Reading, Massachusetts 16 Lowell Street, Reading, MA 01867 Website Disclaimer Virtual Towns & Schools Website 1 of 1 4/11/2012 2:00 PM I Budgets .Water Budget is $5,802,870 o gross decrease from FY12 but a net 'crease including use of $550,000 of FY12 reserves ,300,000 to offset rates and $250,000 at November -2011 Town Meeting for capital) FY13 Sewer Budget is $5,772,546 A increase from FY12 with no reserves used Forecast of Rates 13 (MWRA) budget holds to the 3.9% crease commitment made during the _a.,,M' ent of the FY11 budget as part of a le -ye strategy to keep rates especially low wring these difficult economic times for our - ~communities ... these measure will not be - sustainable in future years ..." Source: Massachusetts Water Resources Authority Proposed FY13 Budget http.//www. mwra. com/ financ% eblflt3proposed /executivesummary POT t Other Assumptions: T t 10% for early payment — no change es from interest & penalties for late payments drop because of increased warnings from the Town :y_enues from real estate liens also dropped for the e reason Brest income is slightly lower _ $65,000 less revenues ( on rates) equired User Paymets Budgets + Other Assumptions needed from water /sewer users to FY13 budgets: r $5,620,870 —Sewer $5,625,546 t J/ Town of Reading Water Sewer Billing Volume Actual 4 -Year Ave. 'WATER VOLUME (HCF): FY08 FY09 FY10 FY11 FY08 -FY11 Jvt�st Qtr (Jul -Sep) 209,704 204,469 184,668 224,584 205,856 C ll,, `('2nd Qtr (Oct -Dec) �'L, 203,550 `176,615 91 183,595 Qi�T90,940 0188,675 c, _a. _1,3rd Qtr (Jan -Mar) 161,771 155,419 159,371 156,382 158,236 A '4th Qtr (April -Jun) 157,747 147,897 151,755 155,146 153,136 / 1� /�T+tOTAL 732,772 684,400 679,389 727,052 705,903 L U-1 A< Actual 4 -Year Ave. SEWER VOLUME (HCF): FY08 FY09 FY10 FYI FY08 -FY11 1st Qtr (Jul -Sep) 204,648 201,722 180,619 217,367 201,089 2nd Qtr (Oct -Dec) 197,916 174,006 181,022 185,784 184,682 3rd Qtr (Jan -Mar) 158,163 152,681 157,370 152,638 155,213 4th Qtr (April -Jun) 155,267 145,086 149,850 150,952 150,289 TOTAL 715,994 673,495 668,861 706,741 691,273 SEWER % OF WATER: 1 st Qtr (Jul -Sep) 97.6% 98.66% 97.81% 96.79% 97.68% 2nd Qtr (Oct -Dec) 97.2% 98.52% 98.60% 97.30% 97.88% 3rd Qtr (Jan -Mar) 97.8% 98.23% 98.23% 98.23% 98.23% 4th Qtr (April -Jun) 98.4% 98.09% 98.09% 98.09% 98.09% TOTAL 97.7% 98.41% 98.45% 97.21% 97.93% A= Actual Usage Analysis FY2011 � l Projected "BUDGET" FY12 FY13 29.2% 212,5071 A 26.7% g b�° 67,033 'V A 22.4% 153,136 A 21.7% 147,625 P 100.0% 680,301 P 650,000 1 76 SK Fc,• F�'IZ Pk SeFtrnS Projected "BUDGET" FY12 FY13 29.1% 207,576 A 26.7% 164,072 A 22.5% 149,561 A 21.7% 144,447 P 100.0% 665,656 P 635,000 97.68% 98.23% 97.67% 97.85% 97.85% 97.69% The Impc Reading change - 6.9% change -18% rta nce of ,VO 'u mew MWRA System 196.6 mgd -3.8% -24% F clMWRA forecast for 2030: 243 mgd uding population & new economic growth - - ~- & ongoing conservation efforts No one has accurately forecast the longer -term impact of conservation efforts * Note FY13 MWRA charges based on CY11 kin- yen:, h e Importance,: _o,�.a`u m r147.06k s: projected usage only 6.8,0,300 hcf vs. 188.7k (- 21.7k) vs. 158.2k (- 5 .1k) vs. 153.1k (- 5.5k projected) -fa.te 8.27 HCF projected 705,000 = $5,830,350 _ actual 680,300 = $5,626,081 Projected revenue deficit $ 204,269 Similar results for sewer fund, billed at 97.5% of water fund based on historic usage patterns 0 r 6 ±70/b MWRA expenses +2.5% other expenses +2.0% wages 5% conservation in FY14; 3 % /yr thereafter no further impact from Other Assumptions - -" use $100k reserves FY14 -16 in each fund '.- E5ti�t5: FY14: +9.0% - " FY15: +6.6% - FY16: +8.9% FY17: +7.0% Worksheets: FY13 Rates FY13 W -S Rate Calc Draft.xls Long term EF FY13 budget summary.xls Rates a ,, per- ibo,cubic feet Water Sewer Combined $7.65 $7.59 $15.24 % $7.73 $8.02 $15.75 $8.03 $8.44 $16.47 "Y ^`^ $8.27 $8.57 $16.84 msuggestion: $200k each of water & sewer reserves $9.48 $9.71 $19.19 = 1- year _ - 4 -year avg. + 5.5% + 6.4% + 5.9% Minimum suggestion: $100k each of water & sewer reserves FY13 $9.65 $9.89 $19.54 — 1 -year — 4 -year avg. + 6.0 % + 6.8% + 6.4% ±70/b MWRA expenses +2.5% other expenses +2.0% wages 5% conservation in FY14; 3 % /yr thereafter no further impact from Other Assumptions - -" use $100k reserves FY14 -16 in each fund '.- E5ti�t5: FY14: +9.0% - " FY15: +6.6% - FY16: +8.9% FY17: +7.0% Worksheets: FY13 Rates FY13 W -S Rate Calc Draft.xls Long term EF FY13 budget summary.xls re — Water & Sewer w entire cost structure: ter FY13 Sewer What costs other than MWRA or Debt can be reduced? What capital projects can be deferred? ure — Water & Sewer policies: nrvation — right thing to do, increases rates ik, detection — if rn residents to pay - ff Efficiency already planned: RFP shortly to greatly improve online presence by late CY12 and consolidate billing with real estate taxes (new MA law allows this). Each will reduce expenses. IvIVV" /070 Wages 5% Expenses 12% 170/b Capital 6% 23% Debt 1% What costs other than MWRA or Debt can be reduced? What capital projects can be deferred? ure — Water & Sewer policies: nrvation — right thing to do, increases rates ik, detection — if rn residents to pay - ff Efficiency already planned: RFP shortly to greatly improve online presence by late CY12 and consolidate billing with real estate taxes (new MA law allows this). Each will reduce expenses. Water Enterprise Fund (5;04 Capital + Debt Approved Requested Projected =_> Le end: Debt Issued and Debtx not eta roved) Water Ent. Fund Capital& Debt FY -2012 FY•2013 FY -2014 FY -2015 FY -2016 FY -2017 FY -2018 FY -2019 FY -2020 FY -2021 FY -2022 Water CAPITAL Water SupUl 783 ?500] 1643 ?000] 626 ?000 480 ?_000 510 ?000 200. ?000 300 ?000)�2T2 ?000 487J,000 720 ?000 450?000I Treatment Plant Design 1 Debt Debt Debt Debt I MWRA ($3.18mil partial join) 2 Debt Debt Debt Debt Debt Debt Debt Debt Debt Debt Debt MWRA ($7.8mil full join) 3 Debt Debt Debt Debt Debt Debt Debt Debt Debt Debt Debt WTP demo & chlorine ($800k) 4 Debt Debt Debt Debt Debt Debt Debt WTP demo & chlorine ($450k) 5 Debt Wells Upgrade - removed $200k from FYI Well Abandonment 1 225,000 Hydraulic Study - 2nd Connect 94,000 56,000 Replace Pickup Truck #3 (2003) 37,000 Water Distribution Various Water Mains ($2.471mi1) 61 Debt WM:Haverhill &Howard ($2.285m) 7 Debt Debt Debt Debt Debt Debt Debt Debt Debt Debt WM: Howard - County- Summer 414,500 i I I I WM: South - West- Gleason($lm) 8 Debtx I Debtx Debtx Debtx Debtx WM: Causway Road loop 276 000 WM: H St. loop (Ivy St.) - moved to FY14 350,00 _ WM: Larch Lane -moved to FYI 5 120,000 Water Main Lining - FYI amount deleted 200,000 200,000 200,000 1 200,000 200,000 200,000 200,000 Meter Replacement 250,000 250,000 250,000 Water System Hydraulic Model 85,000 Tank Inspect & Design: Auburn(FY12) 70,000 12,000 12,000 Tank Maintenance: Auburn Tank Maintenance: Bear Hill - moved to FY15 550,000 _ 220,000 Bear Hill Storage Tank ($1.15mil) 9 Debtx Debtx Debtx Debtx Booster Station SCADA 165,000 SCADA Upgrade (every 5 yrs) 20,000 25,000 Replace Bob Cat loader Replace Pickup Truck #12 (1997)_ _ 40,000 Replace Van #2 Replace Truck #6 120,000 Replace Truck #14 120;000 Replace Backhoe #420E _ 100,000 Replace Utility Truck #5 150,000 FY12 Preliminary Water Revenues REVENUE: FY06A FY07A FY08A FY09A User Payments: Other Revenue: Abatements Service Const. /Renew. Real Estate Liens Interest Charges Interest Income Reimbursements: Grants Retiree Fed Ins Subsidy Gulf Oil Spec. Asmt/Hazard. Waste Premiums from Sale of Bonds Transfer from Reserve: MTBE Subtotal - Other Revenues GRAND TOTAL REVENUE REQ'T: FY10A FY11A FY12B FY13B $3,153,401 $3, 833, 282 $4,123,007 $4,709,384 $4,154,823 $5,013,454 $ 5,127,965 $ 5,270,670 $ 5,007,414 (5,430) (1,518) (55,361) (7,086) (53,151) (10,000) (8,000) (8,000) 36,433 29,852 26,529 40,727 43,855 2,060 37,037 37,000 85,491 101,565 . 133,284 175,733 166,253 166,941 170,000 125,000 21,218 25,852 29,696 33,425 42,399 31,096 42,208 25,000 97,733 100,727 78,189 40,457 4,218 4,740 3,500 3,000 0 25,903 200,000 0 0 0 0 0 5,832 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 56,838 80,143 0 0 0 0 0 729,154 400,000 250,000 370,975 425,000 225,000 550,000 0 813,641 964,599 739,219 742,480 660,063 1,442,215 419,837 794,745 182,000 h� �5 2.79% $4,118,000 $4,572,501 $4,865,487 $5,369,447 $5,597,038 $5,433,291 5,922,710 �dS �lio��ti 3s °rte 4/11 /2012 Page W1 FY13 W- S_Rate_Calc_Draft W Rev M2 FY09 A FY10A FY11A FY12B FY73B $4,546,290 $4,990,133 $5,064,533 $ 5,199,130 $ 5,625,546 8.20% $ 5,136,281 (12,112) (56,411) Preliminary Sewer Revenues REVENUE: (14,000) 3,468 - FY05A FY06 A FY07 A FY08 A User Payments: $3,354,726 $3,648,887 $3,528,952 $4,024,655 Other Revenue: 3,000 31,879 41,357 30,959 Abatements (12,211) (3,462) (1,197) (48,010) Service Const Revew, 3,000 5,281 5,281 5,156 Real Estate Liens 92,639 95,606 117,879 142,665 Inspection Fees 875 1,875 4,755 3,913 Interest Charges 20,035 23,911 28,068 28,697 Interest Income 27,428 71,925 59,775 47,796 Spec. Assessments 19,476 8,290 5,016 6,202 Reimbursements:Septic Tank Sewage Disposal 2,872 Grants - - - 36,270 Premiums from Sale of Bond 3,082 Walker's Brook 1&1 36,997 56,317 Transfer from Reserve: - 10,000 600,000 200,000 FY09 A FY10A FY11A FY12B FY73B $4,546,290 $4,990,133 $5,064,533 $ 5,199,130 $ 5,625,546 8.20% $ 5,136,281 (12,112) (56,411) (12,000) (14,000) (14,000) 3,468 - 168,748 161,954 159,258 170,000 125,000 1,000 3,217 1,297 2,710 3,000 31,879 41,357 30,959 40,773 25,000 20,382 3,733 2,514 3,000 3,000 5,281 5,281 5,156 5,281 5,000 - 3,000 43,249 2,997 330,000 100,000 Subtotal - Other Revenues 148,242 211,017 851,293 476,932 591,895 265,128 161,006 348,190 207,764 147,000 GRAND TOTAL REVENUE REQ'T: $3,502,968 $3,859,904 $4,380,245 $4,501,587 $5,138,185 $5,255,261 $5,412,723 5,406,894 5,772,546 ff u1cKUf' FY13 W- S_Rate_Calc_Draft O4/11/2012 Page S1 SRev 6' TOWN OF READING FY2013 PRELIMINARY Water & Sewer Rate Calculation (price per 100 cubic feet) Water Fund Reserves Balance - July 1, 2011 $986,630 (adjusted for Nov 'l1 TM) Target Balance 10% of Budget (minimum) $580,287 Available for pricing offsets $406,343 3 yrs $135,448 5 yrs $81,269 no reserves use in Svrs use in 3vrs Required User Payments Allowance for 10% discount and 2% lien to tax bills Required Billing User Billing Volume - 100 Cu Ft Rate per 100 Cu Ft USE - FY2011 FY2012 FY2013 4/11/2012 USED: $0 $100,000 $;1:SOT000 $5,270,870 $5,170,870 P$5 0.88 $ 718,755 $ 705,119 Sewer Fund $987,837 $577,255 $410,582 $136,861 $82,116 1 in Svrs use in 3vm $ 767,120 $ 753,484 650,000 650,000 650,000 635,000 635,000 $9.2148 $9.0400 $8.9526 $10.0672 $9.8882 $9.21 $9.04 $8.96 $10.07 $9.89 Water Water Water Sewer Sewer $8.03 $8.03 $8.03 $8.44 $8.44 $8.27 $8.27 $8.27 $8.57 $8.57 $9.21 $9.04 $8.96 $10.07 _ - $9.89 705,000 705,000 705,000 }° 690,000. 690,000 690,000 8.3% 6.4% 5.0% 7.0% 5.0% 3.2% 680,000 680,000 680,000 663,000 663,000 663,000 13.5% 11.1% 9:6% - 12.5% L. 10.2 % 8.5% Page 2 adjusted for $200k revenue deficit FY13 W- S_Rate_Calc_Draf RCalc Enterprise Fund Budgets Assumptions for FY14-FY16: Wages 2.00% MWRA 4.60% CM) (115i, 8.80% Expenses . % 2,50% 2.50% 2.50% 11,321,675 5.03% 11,990,189 9.75% 12,730,674 10,03% 13,452,245 9.50% 13,899,504 7.07% Other Assumptions 1.30% Apr11111,2012 Approved Percent Approved Percent Requested Percent Estimated Percent Estimated Percent Estimated Percent Estimated Percent No. FY-201 Chang FY -2012 Chang FY -2013 Change FY .2014 Chang FY -2015 Chang FY -2016 Change FY -2017 Change LLL�gaT Storm water Yi Salaries and Wages 70,076 000% 127,765 82,32% 134,232 5,06% 136,917 2.00% 139,655 MIN 142,448 2,00% 145,297 2.00% Y2 Expenses 19,750 7.34% 58,885 19815% 64,080 8.82% 65,682 2.50% 67,324 2,50% 69,007 2.50% 70,732 2.50% Y3 Debt Service Y 288,000 44.00% 190,000 -3403% 190,000 0,00% 190,000 0.00% 200,000 5,26% 200,000 0.00% 200,000 H0% V51 Storm 377,826 29.66% 376,650 -0.31% 388,312 3.10% 392,599 1.10% 406,979 3.66% 411,455 1.10% 416,029 1.11% Reserves (30,000 ) (20,000) (2sG00) 135,000) Net Storm Water 347,826 19.37% 376,650 8.29% 388,312 3.10%1 372,599 4.05% 381,979 2. 381,029 -0AI% estimated revenues @$40 is $390k $40 7 $40 $40 $40 $40 Reserve d levels Target Excess Storm Water , 275,590 376,011 376,011 356,011 331,011 301,011 266,011 150,000 77'Y Water 1,485,064 986,630 Nova -25N 836,630 686,630 686,630 686,630 588,468 17% Sewer 792,756 987,837 837,837 687,837 687,837 687,837 :86,630 87,837 709,674 .39 U", g iiftw, vyaier WI Salaries and Wages 632,349 0.00% 639,490 1.13% 656,788 270% 669,924 2.00% 683,322 2.00% 696,989 2.00% 710,928 200% W2a Expenses 2,698,736 -1.31% 955,044 1,013,206 609% 1,038,536 2.50% 1,064,500 2.50% 1,091,112 2.50% 1,118,390 250% W21i MWRA Assessment 1,759,085 1,813,825 311% 1,897,261 4.60% 2,054,734 8.30% 2,180,072 6,10% 2,371,919 8.80% W3 Debt Service 1,839,206 -2.70-/. 1,785,591 -2.92% 1,326,051 2574% 1,299,286 -2.02% 1,271,721 -2.12% 1,406,505 10.60% 1,365,733 -2,90% W4 Capital Outlay 263,000 -22.65-/. 783,500 197.91% 643.000 -1793% 626,000 -2.64% 480,000 -23.32% 510,000 6.25% 200,000 6078% W5 Water Fund 5A33,291 -2.93% 5,922,70 9.01% 5A52,870 .7.93% 5,531,007 1,43% 5,554,276 0.42% 5,894,678 5.95% 5,766,970 .2.00% Reserves (225,0410) (550,000) Novi 125% (150,000) 1 (150,000) Net —Water Fund 5,208,2911 0.70% 5,372,70 3.16% 5,302,870 .1.30% 5,381,007 1.47% 5,554.276 3.22%1 5,884,678 5.95%1 7.34% offsets for gen'l fund (377,367) (377.367) (384.916 ) 200% (394,539) (404,402) (414,512) (424,875) Syr W99 Water Fund voted 5,055,924 5,545,343 5,067954 -861% 5,136,468 5,149,874 5470,166 5,342,095 L Sewer X1 Salaries and Wages 308,147 7.64% 267,908 13.05% 275,11" 2,70% 280,647 2,00% 286,260 2.00% 291,985 200% 297,825 2.00% X2a Expenses 4,444,463 1.13% 655,304 668,124 196% 684,827 2.50% 701,948 2.50% 719,496 250% 737,484 2.50% X21b MWRA Assessment 4164,476 4,383,478 5.26% 4,585,118 4.60% 4965,683 8.30% 5268.589 610% 5,732,225 8.80% X3 Debt Service 165,113 32.93% 162,206 1.76% 1115,800 -2861% 106,934 -7,66% 106,934 0.00% 451,667 32238% 433,517 A.02% X4 Capital Outlay 556,001 2356% 157,000 71.76% 330,000 110,19% 682,000 106.67% 670,000 -1.76% 365,000 000% 445,000 0.00% X6 Sewer Fund 5,473,724 4.111% 5,406,894 .1.22% 5,772,546 6.76% 6,339,526 9.82% 6,730,824 6.17% 7,096,738 5.44% 7,646,051 7.74% Reserves 161001 150000 1 (150.000) Net —Sewer Fund 5,312,723 3.05% 5,406,894 1.77% 5,622546 3.99% 6,189,526 10.0M 6,730,824 8.75%1 7,096,738 5.44%1 41A7% offsets for gen'l fund (259,004) (259,004) (264,198) 201% (270,803) (277,573) (284.512) (291,625) Syr X99 Sewer Fund voted 5,214,720 5,147,890 5,508,348 7.00% 6,068,723 6,453,251 6,812,226 _j 7,354,426 W&S gross 10,907,015 11,329,604 11,225,416 11,870,533 12,285,101 12,981,416 13,413,021 W&S reserves (386,001) (550,000 ) 300,000) 1 300.000 ) 0 0 0 WS jW&S combined net 10,521,014 1.811- 10,779,604 — 1AAIR 10,925,416 I I IR� I 1 15TOi3i 5.90% 12�85,01 I 6A8%j 12,981, 11,321,675 5.03% 11,990,189 9.75% 12,730,674 10,03% 13,452,245 9.50% 13,899,504 7.07% Other Assumptions 1.30% Finance Committee Report: No report. Bylaw Committee Report: No report. ARTICLE 3 To choose all other necessary Town Officers and Special Committees and determine what instructions shall be given Town Officers and Special Committees, and to see what sum the Town will vote to appropriate by borrowing or transfer from available funds, or otherwise, for the purpose of funding Town Officers and Special Committees to carry out the instructions given to them, or take any other action with respect thereto. Board of Selectmen Background: This Article appears on the Warrant of all Town Meetings. There are no known Instructional Motions at this time. The Town Moderator requires that all proposed Instructional Motions be submitted to the Town Clerk in advance so that Town Meeting Members may be "warned" as to the subject of an Instructional Motion in advance of the motion being made. Instructional Motions are normally held until the end of all other business at Town Meeting. Finance Committee Report: No report. Bylaw Committee Report: No report. 4/ To see if the Town will vote to amend the FY 2012 - FY 2021 Capital Improvements provided for in Section 7 -7 of the Reading Home Rule Charter and as previously amended, or take action with respect thereto. Board of Selectmen Background: This Article is included in every Town Meeting Warrant. Town Bylaws prohibit Town Meeting from approving any Capital Expenditure unless the project is included in the Capital Improvements Program (CIP). Bond ratings agencies also want to ensure that changes to a long -term CIP are adequately described. The following changes are proposed to the 2012 -2021 CIP: General Fund FYI increase by $194,000: ♦ $ 70,000 DPW Bulldozer to replace 1971 Bulldozer (was scheduled for FY14) ♦ $ 50,000 DPW Highway Pickup with added Hot Box equipment replace 1997 vehicle (was in FYI 5) ♦ $306,000 additional road repairs funded by 40R (replaces $231,000 road repairs) ♦ $ 39,000 additional sidewalk/pedestrian safety - $25k funded by 40R (replaces $50,000 sidewalks) ♦ $ 10,000 Town facilities — Town Hall carpet FYI increase by $331,250: ♦ $ 58,000 Main St. Fire station floor repairs ♦ $135,000 Sidewalk Snow Plow (replaces two smaller sidewalk Plows $78,000 + $66,750 previously proposed) ♦ ($10,000) street signs eliminated ♦ $230,000 additional road repairs funded by 40R ♦ $ 63,000 additional sidewalk/pedestrian safety funded by 40R FY14 increase by $327,000: ♦ $500,000 Birch Meadow Pavilion (replaces $430,000 Imagination Station) April 23, 2012 Annual Town Meeting 4 Report on the Warrant ♦ $ 45,000 Hunt Park playground (swaps with FY15 $45,000 Wood End upper playground) ♦ $207,000 additional road repairs funded by 40R ♦ $ 50,000 additional sidewalk/pedestrian safety funded by 40R FY15 and beyond: ♦ Several additions, deletions and changes Storm Water Enterprise Fund FY14 decrease by $10,000: ♦ $140,000 Drainage Improvement projects (replaces $150,000 Saugus River Design & Permitting) FY15 and beyond: Several additions, deletions and changes Water Enterprise Fund FY13 decrease by $336,000: ($276,000) Causeway Road water main moved from FY13 to FY14 ($ 60,000) Water conservation program moved to operating budget FY14 decrease by $269,000: ♦ $276,000 Causeway Road water main moved from FY13 Q ($220,000) Bear Hill Water tank maintenance moved from FY14 to FY15 ($ 50,000) Water conservation program moved to operating budget • ($225,000) well abandonment moved out to FY16 ♦ ($ 50,000) well upgrade removed (Note that the Ivy St/Belmont St water main remains in FY14 and $120,000 Larch Lane water main remains in FY15) FY15 and beyond: ♦ Several additions, deletions and changes Sewer Enterprise Fund FY13 increase by $130,000: ♦ $130,000 "Poet's Corner' Sewer Main repair FY14 increase by $645,000: ♦ $ 75,000 for Sewer Main projects ♦ $300,000 for West St. Sewer Station repairs ♦ $270,000 for Joseph's Way Sewer Station repairs FY15 and beyond: ♦ Several additions, deletions and changes — note addition of several Sewer Station repairs Finance Committee Report: The Finance Committee recommends the proposed amendments to the FY 2012 — FY 2021 Capital Improvements Program by a vote of 7 -0 -0 at their meeting on March 28, 2012. Bylaw Committee Report: No report. ARTICLE 5 To see if the Town will vote to adopt Massachusetts General Laws Chapter 32B, Section 20 which allows the Town to set up an irrevocable trust for "Other Post Employment Benefits Liabilities' or take any action with respect thereto. Board of Selectmen April 23, 2012 Annual Town Meeting 5 Report on the Warrant relieve reliance upon the operating budget and will hopefully one day fully fund our obligation. The next Article will begin to fund the liability, and a second deposit is proposed as part of Article 13 (the FYI Budget). In the coming months the Finance Committee will meet with Town officials to discuss formalizing a disciplined approach or policy for meeting this long term obligation. Bylaw Committee Report: No report. ARTICLE 6 j To see if the Town will vote to amend one or more of the votes taken under Article 28 of the Warra of the Annual Town Meeting of April 25, 2011 as amended under Article 5 of the Warrant of the Subse nt Town Meeting of November 14, 2011; and to see what sum the Town will vote to appropriate by bZ-Frowing or transfer from available funds, or otherwise, as the result of any such amended votes for the operation of the Town and its government, or take any other action with respect thereto. Board of Selectmen Background: The following budget amendments are proposed for the FY12 budget: General Fund - Wages and Expenses Account Line Description Decrease Increase B99 Benefits: $97,000 - $500,000 Health Insurance + $500,000 OPEB Trust Fund - $50,000 Unemployment - $35,000 Medicare - $25,000 Worker Comp. Ins. early payment discount + $13,000 Pension Assessment - military leave C99 Capital: $475,000 +$306,000 DPW Roads* + $ 39,000 DPW curb /sidewalk ($25k from 40R funds *) + $ 70,000 DPW replace 1971 Bulldozer before FY14 + $ 50,000 DPW replace 1997 Hwy pickup before FYI + $ 10,000 Town Facilities Town Hall carpet E99 Vocational Education $25,000 - $25,000 lower enrollment than anticipated H91 Accounting wages $5,000 + $5,000 overlap for new Town Accountant 191 Finance wages $55,000 - $37,000 Open clerical position not filled - $11,000 Technology position open until filled - $ 7,000 Surplus from combining elections 192 Finance expenses $50,000 + $24,000 Assessors outsourced property inspection + $11,000 Technology required by new library system + $15,000 Technology for Town Hall K91 Community Services wages $13,000 $ 8,000 Health inspector (now a Melrose employee) $ 5,000 Various positions due to staff turnover K92 Community Services expenses $23,000 + $ 8,000 Health inspector (Melrose employee) + $15,000 Consultant for housing Ian April 23, 2012 Annual Town Meeting Report on the Warrant L91 Library wages Decrease $1,500 + $1,500 overlap for new librarian W99 and X99 Transfers needed because of a revenue deficit in each fund caused by low water usage in FY12 M91 Public Works wages $20,000 + $20,000 Overtime caused by storms in the fall of 2011 M92 Public Works expenses $15,000 + $15,000 for variety of expenses related to fall storms M93 Public Works — Snow & Ice $38,500 M94 Public Works — Street Lights $10,000 M95 Public Works Rubbish $125,000 N91 Public Safety wages — Overtime in Fire department $95,000 V99 Town Facilities $10,000 + $10,000 for Community Service area — handicap accessibility and customer service Subtotals $363,500 $694,500 Subtotals excluding items in *C99 $363,500 Items in *C99 *$331,000 Net from Operating Transfers None *From 40R Smart Growth Stabilization Fund $331,000 Finance Committee Report: The Finance Committee recommends the proposed FY 2012 budget transfers by a vote of 7 -0 -0 at their meeting on March 28, 2012. Enterprise Funds Account Line Description Decrease Increase W99 and X99 Transfers needed because of a revenue deficit in each fund caused by low water usage in FY12 Net from: Water Reserves (W99) Sewer Reserves (X99) $200,000 $200,000 Finance Committee Report: The Finance Committee recommends the proposed FY 2012 budget transfers by a vote of 7 -0 -0 at their meeting on March 28, 2012. Bylaw Committee Report: No report. ARTICLE 7 To see if the Town will vote to approve the FY 2013 — FY 2022 Capital Improvements Program as provided for in Section 7 -7 of the Reading Home Rule Charter, or take any other action with respect thereto. Board of Selectmen Background: Please see the Blue Pages in the Appendix of this Warrant Report for the FY 2012 — FY 2021 Capital improvements Program. Finance Committee Report: The Finance Committee voted 7 -0 at their March 28, 2012 meeting to recommend the subject matter of this Article. Placing items in the capital improvement program is a prerequisite but does not authorize spending funds towards these items. Bylaw Committee Report: No report. April 23, 2012 Annual Town Meeting 8 Report on the Warrant , 1 (9 FY13 Spending Scorecard Line Category FY11 Budget revised FY12 Budget FY13 FINCOM % revised _ change $12,845,486; $13,329,635' 3.8% $948,000; $1,937,700104.4% $6,063,446! $4,539,575' - 25.1% $419,341 $325,000 - 22.5% FINCOM votes % Bdgt Town Meeting Member- Notes B99 !Benefits C99 D99 E99 $ 11,712,081 7 -0 -0 17.2% Capital $ 1,223,000 7 -0 -0 2.5% Debt service $ 6,158,003 7 -0 -0 5.9% Vocational Education $ 327,946 7 -0 -0 0.4% Total Shared Costs $ 19,421,030 $ 20,276,275 $ 20,131,910 -0.7% 26.0% $212,611 $217,279! 2.2% $487,330 $491,350. 0.8% $156,779 $159,709' 1.9% $1,300' $1,100. - 15.4% $1,089,226 $1,108,433' 1.8% $458,321 $511,350 11.6% $150,000 $150,000' 0.0% $753,480 $729,282 -3.2% $372,999 $415,050. 11.3% $987,717 $1,007,579. 2.09/. $253,813; $283,000 11.5% $2,291,4141 $2,348,947, 2.5% $836,930' $805,400 -3.8% $565,000 $600,000', 6.2% $253,575 $200,000'. - 21.19/. $1,472,159' $1,500,000. 1.9% $7,595,269 .$8,092,552 6.5% $366,014 $377,925' 3.3% G91 !Town Administration wages $ 211,646 7 -0 -0 0.3% G92 !Town Administration expenses $ 442,000 7 -0 -0 0.6% H91 Accounting wages $ 155,770 7 -0 -0 0.2% H92 'Accounting expenses $ 1,550 7 -0 -0 0.0% 191 iFinancewages $ 1,137,410 7 -0 -0 1.4% 192 Finance expenses $ 506,800 7 -0 -0 . 0.7% J92 FINCOM reserves $ 150,000 7 -0 -0 0.2% K91 Community Services wages $ 885,557 7 -0 -0 0.9% K92 ;Community Services expenses $ 263,485- 7 -0 -0 0.5% L91 (Library wages $ 966,006 7 -0 -0 1.3% L92 Library expenses M91 Public Works wages $ 268,817 7 -0 -0 0.4% $ 2,351,314 7 -0 -0 3.0% M92 Public Works expenses $ 739,026 7 -0 -0 1.0% M93 Public Works Snow & Ice $ 525,000 7 -0 -0 0.8% M94 .Public Works Street Lights $ 241,500 7 -0 -0 0.3% M95 ,Public Works Rubbish $ 1,560,770 7 -0 -0 1.9% N91 Public Safety wages $ 7,543,727 7 -0 -0 10.4% N92 . Public Safety expenses. $ 353,854 7 -0 -0 0.5% Total Municipal Gov'tj $ 18,304,232 $ 18,303,937 $ 18,998,956 3.8% 24.5% $37,053,287 $704,1166 0.6% U99 School Department $ 36,390,308 $36,005,307 V99 Town Facilities $ 740,693 $699,8771 7 -0 -0 0.9% Total School & Facilities! $ 37,131,001 $ 36,705,184 $ 37,757,453 2.9% 48.7% VOTED GENERAL FUND $ 74,856,263 $ 75,285,396 $ 76,888,319 2.1% 99.2% State Assessments $ 552,912 $ 585,896 $ 617,079 5.3% 0.8% TOTAL $ 75,409,175 $ 75,871,292 $ 77,505,398 1 2.2% 100.0% W991Water X99 Y99 $5,295,343 $5,067,954 -4.3% 8 $5,147,90. $5,508,348' 7.0% $376,650' $388,312 3.1% Enterprise Fund $ 5,055,924 7 -0 -0 46.2% was $5,417,954 �SewerEnterpriseFund $ 5,214,720 7 -0 -0 50.2% iStorm Water Enterprise Fund $ 347,826 7 -0 -0 3.5% TOTAL ENTERPRISE FUNDS $10,618,470 $10,819,883 I $10,964,614 1.3% ! " I GRAND TOTAL VOTED $ 85,474,733 $ 86,105,279 1 $ 87,852,933 1 2.001. NS of �J Finance Committee Report: FINCOM budget votes for each line item from their meeting on March 28, 2012 are shown in the budget section. All lines were approved by a vote of 7 -0 -0. Bylaw Committee Report: No report. ICLE 14 To see what sum the Town will vote to appropriate by borrowing, whether in anticipation f reimburse nt from the State under Chapter 44, Section 6, Massachusetts General Laws, or pursuant to a nabling authority or from the tax levy, or transfer from available funds, or otherwise, for highway projects in accordance with Chapter 90, Massachusetts General Laws, or take any other action with respect thereto. Board of Selectmen Background: The purpose of this Article is to make Chapter 90 funds for road improvements available to the Town for expenditure. The Art i orizes expenditures upon receipt of the grant. The FY 2013 Chapter 90 allocation is anticipated to bqjqQ3 01 ightly more than the $597,663 for FY 2012. At the time of printing of this warrant, the state was ju nning to approve a multi -year Chapter 90 bond authorization, and the total state -wide FY 2013 appropriation in the proposed bond bill is expected to be $200 million, the same as for FY 2012. Finance Committee Report: At its March 28, 2012 meeting, the Finance Committee voted to recommend the subject matter of Article 14 by a vote of 7 -0. We vote at town meeting each year to approve the acceptance and use of these funds for road improvements from the State, the only issue being the precise sum of money available from the state. Though the final allocation for FY13 for Reading was not known as of this vote, barring any new or different contingencies. placed by the State on the funds, the committee believes that that the town should accept whatever level of funding is offered. Bylaw Committee Report: No report ARTICLE 15 To see what sum the Town will raise by borrowing pursuant to G.L. Chapter 44, §7(1) or transfer from available funds, or otherwise, and appropriate for the purpose of making improvements to the Whittier Road, Tennyson Road, Tennyson Circle, Wadsworth Road and Browning Terrace area surface drains, sewers and sewerage systems, including the costs of engineering services, plans, documents, cost estimates, bidding services and all related expenses incidental thereto and necessary in connection therewith, said sum to be spent under the direction of the Town Manager; and to see if the Town will authorize the Town Manager, the Board of Selectmen, or any other agency of the Town to apply for a grant or grants to be used to defray all or any part of said sewer construction and /or reconstruction and related matters; and to see if the Town will vote to authorize the Town Manager to enter into any or all agreements as may be necessary to carry out the purposes of this Article; and to see if the Town will authorize the Town Manager, the Board of Selectmen, or any other agency of the Town to apply for a non - interest bearing loan from the Massachusetts Water Resources Authority, and to authorize the Treasurer - Collector, with the approval of the Board of Selectmen, to borrow pursuant to said loan, or take any other action with respect thereto. Board of Selectmen Background: This Article will be Indefinitely Postponed. The following background is given for Town Meeting's information. During the recent Inflow and Infiltration study and subsequent video inspection it was determined that the Whittier Road and Tennyson Road area sewer system has numerous structural deficiencies, substantial inflow and infiltration and a cross connection with the drainage system. Based on the extent of the sewer main's deteriorated condition, portions of the sewer system in this area must be replaced and re- habilitated to April 23, 2012 Annual Town Meeting 17 Report on the Warrant 20 \\ bo K ,� (41 F113 FY IZ c'Oa EVERETT 4 56.61 41,667.00 119651 649,769 652,024 (2,255) GEORGETOWN 4 56.23 8,183.00 2060 303,515 292,776 10,739 GLOUCESTER 4 87.53 28,789.00 10680 673,945 672,797 1,147 GROVELAND 4 39.6 6,459.00 1118 213,757 214,370 (613) HAMILTON 4 44.85 7,764.00 1362 246,225 246,889 (664) HAVERHILL 4 216.99 60,879.00 18745 1,501,214 1,496,501 4,713 IPSWICH 4 72.94 13,175.00 5085 442,076 442,110 (34) LAWRENCE 4 120.59 76,377.00 24497 1,292,171 1,287,003 5,168 LEXINGTON 4 117.45 31,394.00 192881 924,164 930,607 (6,443) LINCOLN 4 51.31 6,362.00 2104 272,907 272,191 716 LOWELL 4 183.87 106,519.00 33922 1,861,415 1,861,676 (262) LYNN 4 153.19 90,329.00 22757 1,487,729 1,490,031 (2,303) LYNNFIELD 4 66.13 11,596.00 5162 405,915 413,766 (7,851) MALDEN 4 92.61 59,450.00 13422 925,750 937,089 (11,339) MANCHESTER 4 23.6 5,136.00 1663 148,827 149,660 (833) MARBLEHEAD 4 65.78 19,808.00 4589 449,162 454,796 (5,634) MEDFORD 4 91.82 56,173.00 172721 952,924 956,798 (3,874) MELROSE 4 71.49 26,983.00 5814 533,857 535,619 (1,762) MERRIMAC 4 33.95 6,338.00 800 186,247 186,215 32 METHUEN 4 174.73 47,255.00 15256 1,199,746 1,198,324 1,422 MIDDLETON 4 45.9 8,987.00 4552 300,594 300,932 (338) NAHANT 4 16.5 3,410.00 444 93,349 93,572 (223) NEWBURY 4 53.56 6,666.00 1361 273,931 267,761 6,170 NEWBURYPORT 4 67.33 17,416.00 10576 519,698 522,087 (2,390) NORTH ANDOVER 4 117.23 28,352.00 137061 829,732 828,430 1,302 NORTH READING 4 75.97 14,892.00 7063 491,368 488,273 3,095 PEABODY 4 159.41 51,251.00 23942 1,279,53Z- 1,280,923 (1,336) READING 4 88.82 24,747.00 6892 603,012 597,663 5,349 REVERE 4 85.46 51,755.00 8955 , 792,786 (3,872) ROCKPORT 4 33.29 6,952.00 1247 193,466 194,373 (907) ROWLEY 4 41.66 5,856.00 2616 238,040 238,106 (65) SALEM 4 88.45 41,340.00 19458 874,160 870,920 3,240 SALISBURY 4 35.88 8,283.00 28751 233,896 232,064 1,832 SAUGUS 4 77.68 26,628.00 10360 616,690 613,256 3,434 SOMERVILLE 4 88.46 75,754.00 22092 1,128,210 1,119,718 8,492 STONEHAM 4 65.15 21,437.00 6925 488,069 492,932 (4,863) SWAMPSCOTT 4 42.55 13,787.00 3429 302,863 302,932 (69) �1 04/11/2012 13:31 TOWN OF READING blelacheur NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20132 FY13 Enterprise Funds WATER 2011 2012 2012 ACTUAL ORIG BUD REVISED BUD 0450 WATER - OPERATIONS 05 EXPENSES 61005519 519000 MEDICARE 7,500.00 7,750.00 5,793.85 61005519 519700 RETIREMENT 27,927.00 73,126.00 26,724.00 61005519 519750 OPEB CONTR .00 47,664.00 .00 61005529 529433 HAZ WST DI 10,000.00 10,000.00 6,025.59 61005530 530110 LEGAL COUN 10,000.00 5,000.00 .00 61005530 530480 PRIMACEY A 5,500.00 5,500.00 5,551.27 61005530 530491 SVC WKFLD 7,000.00 8,000.00 7,857.29 61005531 531000 PRDEV TRN 2,500.00 5,000.00 2,569.52 61005574 574000 HEALTH INS 165,000.00 155,000.00 139,748.59 61005574 574010 PROP /CASUA 45,000.00 30,000.00 23,017.00 61005574 574550 WC INSURNC 36,000.00 20,000.00 15,411.00 TOTAL EXPENSES 201,929.95 316,427.00 367,040.00 232,698.11 07 DEBT SERVICE 61007591 591000 DEBT PRINC 1,375,000.00 61007591 592000 LTDEBTINT 463,325.00 TOTAL DEBT SERVICE 1,838,325.00 09 OTHER FINANCING USES 2012 2012 ACTUAL PROJECTION PG 1 bgnyrpts FOR PERIOD 99 2013 PCT 4- FINCOM CHANGE 7,500.00 7,500.00 .00 7,500.00 7,750.00 3.3% 27,927.00 27,927.00 27,927.00 27,927.00 73,126.00 161.8% .00 .01 .00 .00 47,664.00 .0% 10,000.00 10,000.00 .00 10,000.00 10,000.00 .0% 10,000.00 10,000.00 .00 10,000.00 5,000.00 -50.0% 5,500.00 5,500.00 5,267.71 5,500.00 5,500.00 .0% 7,000.00 7,000.00 4,189.50 7,000.00 8,000.00 14.3% 2,500.00 2,500.00 5,539.00 2,500.00 5,000.00 100.0°% 165,000.00 165,000.00 118,771.74 165,000.00 155,000.00 -6.1% 45,000.00 40,000.00 24,001.00 45,000.00 30,000.00 -25.0% 36,000.00 36,000.00 16,234.00 36,000.00 20,000.00 -44.4% 316,427.00 311,427.01 201,929.95 316,427.00 367,040.00 17.9°% 1,598,500.00 415,591.00 2,014,091.00 1,370,000.00 415,591.00 1,785,591.00 1,370,000.00 289,666.25 1,659,666.25 1,598,500.00 415,591.00 2,014,091.00 958,500.00 -30.0% 367,551.00 -11.616 1,326,051.00 -25.7% 61009596 596111 WAGE -TWNMG - 14,896.00 14,896.00 14,896.00 11,171.97 14,896.00 15,194.00 2.0% 04/11/2012 13:31 TOWN OF READING blelacheur NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20132 FY13 Enterprise Funds WATER 2011 2012 2012 ACTUAL ORIG BUD REVISED BUD 2012 ACTUAL 2012 PROJECTION IPG 2 bgnyrpts FOR PERIOD 99 2013 PCT 4- FINCOM CHANGE 61009596 596121 WAGE -ACTNG 10,078.00 10,078.00 10,078.00 7,558.47 10,078.00 10,280.00 2.0 %; 61009596 596122 EXP ACTNG 180.00 180.00 180.00 135.00 180.00 184.00 2.2% 61009596 596131 WAGE -FINCE 32,032.00 32,032.00 32,032.00 24,023.97 32,032.00 32,673.00 2.0% 61009596 596132 EXEFINANCE 21,653.00 21,653.00 21,653.00 16,239.78 21,653.00 22,086.00 2.0% 61009596 596141 WAGE HR 4,900.00 4,900.00 4,900.00 3,674.97 4,900.00 4,998.00 2.0% 61009596 596142 EXP HR 2,264.00 2,264.00 2,264.00 1,698.03 2,264.00 2,309.00 2.016 61009596 596151 WAGE TECHN 31,777.00 31,777.00 31,777.00 23,832.72 31,777.00 32,413.00 2.0% 61009596 596152 EXP TECH 30,418.00 30,418.00 30,418.00 22,813.47 30,418.00 31,026.00 2.0% 61009596 596161 WAGEDPWADM 104,690.00 104,690.00 104,690.00 78,517.53 104,690.00 106,784.00 2.0% 61009596 596171 WAGE ENGIN 98,407.00 98,407.00 98,407.00 73,805.22 98,407.00 100,375.00 2.0% 61009596 596181 WAGE HGWY 6,730.00 6,730.00 6,730.00 5,047.47 6,730.00 6,865.00 2.016 61009596 596182 EXP HGWY 19,342.00 19,342.00 19,342.00 14,506.47 19,342.00 19,729.00 2.0% 61009596 596500 XFERTO ENT .00 .00 414,500.00 .00 .00 .00 - 100.0% TOTAL OTHER FINANCING USES 377,367.00 377,367.00 791,867.00 283,025.07 377,367.00 384,916.00 -51.4% TOTAL WATER - OPERATIONS 2,448,390.11 2,707,885.00 2,888,885.01 2,144,621.27 2,707,885.00 2,078,007.00 -28.1% 0451 WATER - DISTRIBUTION 03 SALARIES 61013511 511401 SUPERVISOR 38,826.33 39,609.00 39,609.00 30,500.75 39,609.00 40,393.00 2.0% 61013511 511403 FOREMAN 58,182.46 59,837.00 59,837.00 47,882.91 59,837.00 61,896.00 3.4% 61013511 511405 WRKNG FRMN 125,585.72 110,842.00 110,842.00 85,498.17 110,842.00 114,576.00 3.4% 61013511 511409 EQUIP OPER 122,832.48 141,149.00 141,149.00 110,566.37 141,149.00 143,571.00 1.7% 04/11/2012 13:31 blelacheur PROJECTION: 20132 WATER 61013511 511413 61013511 511417 61013511 511471 61013511 511481 61013511 515000 61013511 516050 61013511 516060 61013511 516080 61013512 512000 61013517 517017 TOTAL SALARIES 05 EXPENSES 61015521 521301 61015521 521303 61015521 521392 61015530 530420 61015530 530470 61015530 530472 61015530 530474 61015530 530478 61015531 531000 TOWN OF READING NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS FY13 Enterprise Funds 2011 ACTUAL SKLLD LABR 57,211.78 LABORER 33,032.16 CLERK(S) 17,268.40 SNOW REMOV .00 OVERTIME 52,509.30 OUT OF GRA 5,517.60 ONCALL PRM 10,492.00 LONGEVITY 6,825.00 WAGES TEMP 5,303.74 SCK LV BBK .00 2012 2012 2012 2012 ORIG BUD REVISED BUD ACTUAL PROJECTION IPG 3 bgnyrpts FOR PERIOD 99 2013 PCT 4- FINCOM CHANGE 79,672.00 79,672.00 32,898.81 79,672.00 42,220.00 -47.0% 33,032.00 33,032.00 51,126.95 33,032.00 67,076.00 103.1% 17,598.00 17,598.00 13,350.31 17,598.00 18,640.00 5.9% - 6,500.00 - 6,500.00 .00 - 6,500.00 - 6,500.00 .0% 50,000.00 50,000.00 65,462.75 50,000.00 55,000.00 10.0% 3,000.00 3,000.00 3,204.08 3,000.00 4,500.00 50.0% 8,818.00 8,818.00 8,262.00 8,818.00 10,000.00 13.4% 7,500.00 7,500.00 5,550.00 7,500.00 7,500.00 .0% 7,192.00 7,192.00 4,865.20 7,192.00 8,000.00 11.2% .00 .00 2,968.64 .00 .00 .0% 533,586.97 5 551,749.00 5 551,749.00 4 462,136.94 5 551,749.00 5 566,872.00 2 2.7% ELECTRICIT 10,497.81 1 11,000.00 1 11,000.00 6 6,950.64 1 11,000.00 1 11,000.00 . .0% NATRL GAS 301.91 5 500.00 5 500.00 1 198.30 5 500.00 5 500.00 . .0% WRLS PHONE 2,864.58 . .00 . .00 2 2,146.56 . .00 1 1,500.00 . .0% PLCE DTAIL 10,413.62 1 15,000.00 1 15,000.00 1 13,423.81 1 15,000.00 1 16,000.00 6 6.7% WTR SYSTEM 1,730.69 1 10,000.00 1 10,000.00 5 5,049.76 1 10,000.00 1 10,000.00 . .0% MAIN PIPE/ 760.00 1 10,000.00 1 10,000.00 . .00 1 10,000.00 1 10,000.00 . .0% SVC PIPE /M 59,001.75 5 50,000.00 5 50,000.00 6 62,522.05 5 50,000.00 5 50,000.00 . .0% CROSS CONN 5,160.00 8 8,000.00 8 8,000.00 1 1,820.00 8 8,000.00 8 8,000.00 . .0% PRDEV TRN 00 . .00 . .00 1 1,400.00 . .00 .00 . .0 °s 04/11/2012 13:31 (TOWN OF READING blelacheur NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20132 FY13 Enterprise Funds WATER 2011 2012 2012 2012 ACTUAL ORIG BUD REVISED BUD ACTUAL 61015536 536000 LIC SFTWR 10,000.00 10,000.00 7,000.00 61015540 540470 WD GEN SUP 27,000.00 25,000.00 24,160.62 61015540 540472 MAIN PIPE 33,000.00 30,000.00 23,288.30 61015540 540474 SVC METERS 7,000.00 7,000.00 380.00 61015554 554000 UNFM /CLTH 5,500.00 5,500.00 4,227.97 61015578 578100 LICENSES 750.00 750.00 347.00 TOTAL EXPENSES 70,000.00 .00 70,000.00 150,134.25 08 CAPITAL EXPENDITURES 61018584 584410 BOBCATLOAD .0% 275,000.00 44,044.20 61018584 584411 VAN #2 100.0°% 1,014,499.00 37,933.61 61018584 584418 TRUCK #12 28.4% .00 61018585 585451 METRINSTAL 177,916.09 61018585 585452 BOOSTER TE .00 61018585 585461 TANK INSP .00 61018588 588450 SYSTEMS - 92,245.27 TOTAL CAPITAL EXPENDITURES 167,648.63 TOTAL WATER - DISTRIBUTION 851,369.85 0452 WATER - SUPPLY / TREATMENT 03 SALARIES IPG 4 bgnyrpts FOR PERIOD 99 2012 2013 PCT PROJECTION 4- FINCOM CHANGE 10,000.00 10,000.00 .00 10,000.00 10,000.00 .0% 27,000.00 27,000.00 8,824.02 27,000.00 25,000.00 -7.4% 33,000.00 33,000.00 18,902.21 33,000.00 30,000.00 -9.1% 7,000.00 7,000.00 .00 7,000.00 7,000.00 .0% 5,500.00 5,500.00 3,621.99 5,500.00 5,500.00 .0% 750.00 750.00 855.00 750.00 750.00 .0°% 187,750.00 187,750.00 125,714.34 187,750.00 185,250.00 -1.3% .00 .00 .00 .00 .00 .0% .00 .00 .00 .00 .00 .0% 40,000.00 40,000.00 39,954.45 40,000.00 .00 - 100.0% .00 .00 .00 .00 .00 .0°% 165,000.00 165,000.00 .00 165,000.00 .00 - 100.0°% 70,000.00 70,000.00 .00 70,000.00 550,000.00 685.7% .00 .00 .00 .00 .00 .0% 275,000.00 275,000.00 39,954.45 275,000.00 550,000.00 100.0°% 1,014,499.00 1,014,499.00 627,805.73 1,014,499.00 1,302,122.00 28.4% 61023511 511461 SUPERVISOR 84,062.88 83,741.00 83,741.00 64,738.08 83,741.00 85,416.00 2.0% 04/11/2012 13:31 blelacheur PROJECTION: 20132 WATER TOWN OF READING INEXT YEAR / CURRENT YEAR BUDGET ANALYSIS FY13 Enterprise Funds 2011 2012 2012 ACTUAL ORIG BUD REVISED BUD 2012 ACTUAL 2012 PROJECTION PG 5 Ibgnyrpts FOR PERIOD 99 2013 PCT 4- FINCOM CHANGE 61023511 511481 SNOW RMVL .00 - 500.00 - 500.00 .00 - 500.00 - 500.00 .0°% 61023511 515000 OVERTIME 5,958.50 4,500.00 4,500.00 6,834.14 4,500.00 5,000.00 11.1°% TOTAL SALARIES 90,021.38 87,741.00 87,741.00 71,572.22 87,741.00 89,916.00 2.5% 05 EXPENSES 61025521 521301 ELECTRICIT 24,596.31 21,000.00 21,000.00 17,198.38 21,000.00 24,000.00 14.3% 61025521 521308 FUEL OIL 2,077.62 3,000.00 3,000.00 1,518.11 3,000.00 3,000.00 .0% 61025521 521309 SWR /STM WA 214.72 500.00 500.00 161.04 500.00 500.00 .0% 61025521 521390 TELEPHONE 1,616.96 3,000.00 3,000.00 682.27 3,000.00 2,500.00 -16.7% 61025524 524471 MWRA VALVE .00 10,000.00 10,000.00 .00 10,000.00 10,000.00 .0% 61025530 530000 OUT PRFSVC 5,781.00 10,000.00 10,000.00 1,558.50 10,000.00 10,000.00 .0°% 61025530 530457 WELLS 2,073.86 .00 .00 .00 .00 .00 .0% 61025540 540000 DEPT SUPP 1,439.80 6,000.00 6,000.00 1,301.74 6,000.00 6,000.00 .0°% 61025540 540455 WELLS 10,990.54 20,000.00 20,000.00 8,863.05 20,000.00 20,000.00 .0% 61025540 540499 WTR EMERGN .00 .00 .00 1,180.44 .00 .00 .0% 61025563 563400 MWRA 1,726,878.00 1,759,085.00 1,759,085.00 1,417,911.20 1,759,085.00 1,813,825.00 3.1% TOTAL EXPENSES 1,775,668.81 1,832,585.00 1,832,585.00 1,450,374.73 1,832,585.00 1,889,825.00 3.1% O8 CAPITAL EXPENDITURES 61028583 583000 PLANT .00 30,000.00 94,000.00 93,630.00 30,000.00 56,000.00 -40.4% 61028585 585453 EMERG ENGI .00 .00 .00 .00 .00 37,000.00 .0% TOTAL CAPITAL EXPENDITURES .00 30,000.00 94,000.00 93,630.00 30,000.00 93,000.00 -1.1% TOTAL WATER - SUPPLY / TREAT 1,865,690.19 1,950,326.00 2,014,326.00 1,615,576.95 1,950,326.00 2,072,741.00 2.9% 0990 OTHER FINANCING SOURCES /USES 09 OTHER FINANCING USES 04/11/2012 13:31 (TOWN OF READING blelacheur NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20132 FY13 Enterprise Funds WATER 2011 2012 2012 2012 ACTUAL ORIG BUD REVISED BUD ACTUAL 61009590 599910 DEBT COSTS .00 TOTAL OTHER FINANCING USES .00 TOTAL OTHER FINANCING SOURCE .00 TOTAL WATER 5,165,450.15 GRAND TOTAL 5,165,450.15 2012 PROJECTION IPG 6 bgnyrpts FOR PERIOD 99 2013 PCT 4- FINCOM CHANGE .00 .00 2,500.00 .00 .00 .0% .00 .00 2,500.00 .00 .00 .0% .00 .00 2,500.00 .00 .00 .0% 5,672,710.00 5,917,710.01 4,390,503.95 5,672,710.00 5,452,870.00 -7.9% 5,672,710.00 5,917,710.01 4,390,503.95 5,672,710.00 5,452,870.00 -7.9% ** END OF REPORT - Generated by Bob LeLacheur **