Loading...
HomeMy WebLinkAbout2011-06-22 RMLD Board of Commissioners Minutes Reading Municipal Light Board of Commissioners Regular Session 230 Ash Street R E(;F V E D Reading,MA 01867 TOWN C! E R K June 22,2011 S Start Time of Regular Session: 7:32 p.m. ryi z� End Time of Regular Session: 9:15 p.m. 12. 5.3 Attendees: Commissioners- Richard Hahn,Chairman Philip B.Pacino,Vice Chair Gina Snyder,First Secretary Mary Ellen O'Neill,Second Secretary Robert Soli,Commissioner Staff: Vinnie Cameron,General Manager Beth Ellen Antonio,Human Resources Manager Jared Carpenter,Energy Efficiency Engineer Jeanne Foti,Executive Assistant Robert Fournier,Accounting/Business Manager Jane Parenteau,Energy Services Manager William Seldon,Senior Energy Analyst Kevin Sullivan,E&O Manager Citizens'Advisory Board John Norton,Secretary Chairman Hahn called the meeting to order and stated that the meeting of the Reading Municipal Light Department(RMLD) Board of Commissioners is being broadcast live at the RMLD's office at 230 Ash Street,Reading,MA. Live broadcasts are available only in Reading due to technology constraints. This meeting was video taped for distribution to the community television stations in North Reading,Wilmington and Lynnfield. Opening Remarks/Approval of Meeting Agenda hairman Hahn asked the Board members present if there were suggested changes or additions to the agenda. There were .ione. Introductions There were no members of the public present, and the CAB representative, Secretary John Norton had no report for the Board. Quarterly Conservation Program Update—Mr.Carpenter(Attachment 1) Mr. Carpenter presented his quarterly Energy Conservation Program update. Mr. Carpenter addressed the following: Residential Audit Program—home energy usage changes after an audit,how to make the program more effective,new project overview,and demand response update. Mr. Carpenter reported that there has been a large increase in FY 2011 for residential audit requests. There have been 146 audits performed through April from 210 phone requests. Mr. Carpenter explained that the current residential audit format has been changed to include such options as thermal imaging scans,blower door tests and insulation analysis. Mr. Carpenter added that the new audit format is less expensive and more efficient. Mr. Carpenter stated that with the new audit format residential customers receive an electronic 21 page report whereas with the past process this did not occur.Feedback has been positive. Discussion followed including tracking results and providing specific recommendations on ENERGYSTAR appliances in the audits. Mr.Pacino entered the meeting at this time. Mr. Carpenter said that possible ways to improve the audit process are that the RMLD streamline the process,create a follow _up program,create a self audit(this software might be difficult to specify)and phone consultations with customers. T4s. O'Neill asked if the audits look at the rate a customer is on to evaluate whether it may be more advantageous if they switch to the Residential Time of Use rate or the Hot Water Heater rate. Mr.Carpenter replied,not really. Ms.O'Neill asked if the RMLD can analyze the hourly use of a residential customer. Mr.Carpenter responded that it could be done. Regular Session Meeting Minutes 2 June 22,2011 Quarterly Conservation Program Update—Mr.Carpenter(Attachment 1) Ms. O'Neill questioned if the RMLD is developing a new program for the Time of Use rate. Ms. O'Neill said that she was looking for public relations effort for the new Time of Use rate as well as assistance in making it work for customers who sign onto this rate. Mr. Cameron responded that a press release and a write up for the Reading Patch are ready to be released. - Mr. Cameron added that there is information on the RMLD's website on the Time of Use rate,however,this can be expanded and enhanced. Discussion followed. Mr. Carpenter said that on the demand response side it is moving in a positive direction. Mr. Carpenter said that the slowdown was in communicating from our meter to the customer consistently, but equipment is on the way. Mr. Carpenter stated that they are moving forward and the towns will reap the benefits with the current effort working with the schools in North Reading and Wilmington on how to implement a Demand Response program. Ms. O'Neill said that she had received an e-mail from a customer asking what the RMLD is doing in terms of its building at 230 Ash Street and what is the goal for FY 2012. Mr. Carpenter said that there are new variable speed pumps;variable speed drives for the chillers and magnetic conduction lighting for the meter area that will reduce energy consumption in the building. Other lights are being ordered for the garages that are more energy efficient. Mr. Cameron pointed out that in FY 2012 the interior lights are being evaluated for after hour's security use to possibly save on usage as well as heating and cooling zones being adjusted to building hours. Mr. Carpenter said that once the changes are made then they will have the data to determine the effect of the changes. Report from Board Committee—Chairman Hahn(Attachment 2) Power&Rate Committee—Report of June 22 Meeting Swift River Trading Company,LLC—Indian River Hydroelectric Chairman Hahn reported that prior to the RMLD Board meeting;the Power&Rate Committee met at 6:30 p.m.and discussed a potential renewable purchase opportunity from a hydroelectric facility. Mr. Hahn said that a couple of months ago, the RMLD signed power contracts with three facilities to increase the amount of renewable generation in the RMLD's power supply portfolio. This additional fourth project was not available at the time; however, it is now available. Chairman Hahn said that the Power&Rate Committee voted 2:0:0 to recommend to the full Board to accept this purchase. Chairman Hahn said that the Citizens' Advisory Board voted 5:0:0 in favor of adding these renewable projects which are at the same price as the other three projects. The contracts for these projects are for a 15-year period. Ms. Snyder made a motion seconded by Mr. Pacino that the RMLD Board of Commissioners vote to authorize the General Manager of the Reading Municipal Light Department to finalize negotiations and execute a contract with Swift River Trading Company, LLC for the output of the Indian River Hydroelectric facility owned and operated by Swift River Trading Company,LLC. Motion carried 5:0:0. Commissioner Soli's Handout—May 25,2011 Chairman Hahn said that Mr. Soli's inquiry on the Street Light rate(attachment)was discussed,but no conclusions have been reached at this time. Chairman Hahn said that there was a memo handed out with suggested policy directions for renewable energy. Chairman Hahn added that Ms. Snyder provided an e-mail summarizing the results of a Vermont Law School Study on the benefits of renewables on power supply and their effective place in the power supply portfolio. Chairman Hahn said that these items will be addressed at the next Power & Rate Committee meeting. An effort will be made to schedule this meeting in July. Approval of May 25,2011 Board Minutes Ms. Snyder made a motion seconded by Mr. Pacino to approve the Regular Session meeting minutes of May 25, 2011 with the suggested change by Commissioner Soli,on page two,first paragraph to change"ratepayers"to"customers." Motion carried 5:0:0. Mr. Pacino suggested that the minutes be shorter, less than seven pages. Ms. Snyder commented that there was a lot of discussion at the meeting. Chairman Hahn commented any opportunities to condense the details of the discussion should be taken because the minutes are not a stenographic record. Regular Session Meeting Minutes 3 June 22,2011 General Manager's Report—Mr.Cameron Vehicle Days Mr. Cameron said that the.RMLD will participate in two vehicle days in August at the public libraries in Reading and North jading. Ms. O'Neill commented that she would like to see a good presence at Vehicle Day. She noted that the Reading vehicle Day is at the Reading Library on Tuesday,August 16,7:30 a.m.to 9:30 a.m. Update on Green Communities Act—Board Request Mr. Cameron said that at the last Board meeting an update on the Green Communities Act was requested. Ms. O'Neill clarified that she meant to ask for an update on the comprehensive Massachusetts legislation. Discussion followed. Mr.Cameron said that he will have a response to the Board on this issue. Financial Report—May,2011—Mr.Fournier(Attachment 3) Mr. Fournier reported on the Financial Report for May 2011. Mr. Fournier apologized for his tardiness for the Financial Report. Chairman Hahn said that there is no need for the apology considering the usual Board meeting would be next week. Mr. Fournier reported that the eleven-month year to date Net Income is$2.2 million. The year to date budgeted Net Income is $1.9 million, making the difference $273,000. Mr. Fournier said that the year to date Fuel Expenses exceeded Fuel Revenues by$34,000. The energy conservation expenses exceeded energy conservation revenues by$114,000. The GAW soil remediation expenses total $1.3 million for this fiscal year bringing the total cost combining the two fiscal years to roughly$2.4 million. Mr. Fournier said that the Operating and Maintenance expenses were over budget by $600,000 or 5.5%. Actual Operating and Maintenance expenses were $11.3 million compared to the budgeted amount of $10.7 million; major expenses over budget were the maintenance of line transformers by $647,000, which represents the GAW soil remediation expense, and employee benefits by$338,000. he Depreciation Expense and Voluntary Payments to the Towns were on budget. Cumulatively,all five divisions were over uudget by$550,000(3.2%). Mr.Fournier reported that the RMLD will be conducting its physical inventory at the end of next week and the FY 2011 audit the week of August 8. Mr. Fournier said that Mr. Pacino had e-mailed him a couple of questions concerning expenses on page 12a. The first question was on the Accounting and Collection Labor expense,Mr.Fournier explained that the actual expense is$1.1 million versus$1.3 million with a variance of$103,000 under budget due to manpower,with the Accounting Assistant reduced hours from 40 to 32 hours per week, a full time person budgeted was not hired in Customer Service and a retirement in February as well as a resignation in May, which total $74,000 out of the $103,000. Mr. Fournier reported that those positions should be filled in FY 2012. Also the RMLD's disconnects and bounce charge fees were approximately $26,000 over budget. The meter expense side actual expense was$283,000 versus$437,000;$153,000 under budget which is mostly related to labor. There was a $27,000 savings from the retirement of the Meter Supervisor in the spring and overtime labor budgeted for the meter projects for the year was $170,000,but the project was started in January 2011. In other areas, employee education is under budget by$2,400,vehicle expense$14,000 and supplies$2,000,which comes to$153,000. Mr. Soli asked on the Energy Conservation expenses exceeding revenues. He was under the impression that it was going to be a non profit— non loss. Mr. Fournier said that it is the timing of the projects. At one point the account was up to the $300,000. Mr. Soli noted that employee benefits are over budget and asked if any legislative changes are going to impact this. Mr.Cameron replied he does not believe so,but he can get back to Mr. Soli. Power Supply Report—May,2011—Ms.Parenteau(Attachment 4) he RMLD's total metered load for May was approximately 57.7 MWh,a decrease of 2.28%compared to last May. In June, ne Fuel Charge Adjustment was raised by one-half mill to $.0585 per kilowatt hour. Ms. Parenteau said that they anticipate that this will remain the same in July. Regular Session Meeting Minutes 4 June 22,2011 Power Supply Report—May,2011—Ms.Parenteau(Attachment 4) Ms.Parenteau reported that the RMLD purchased approximately 24% of its energy requirement from the ISO Spot Market at an average cost of$43.43 per megawatt hour. The RMLD hit a peak of 121.5 MW at 4:00 p.m. on May 27, 2011. The RMLD's monthly capacity requirement was 212.96 MW. The RMLD paid$1.524 million for capacity,which is equivalent to - $7.16 per kW-month. Ms.Parenteau reported that transmission costs for May were$574,000 which represents a decrease of 7.4%from April. Ms. O'Neill asked if it would be of any interest to see how the RMLD's peak demand has changed season-to-season over the years. Ms.Parenteau said that she could provide this on a calendar year basis,but noted that weather really drives usage. Discussion followed. Engineering and Operations Report—May,2011 -Mr.Sullivan(Attachment 5) Gaw Update Mr. Sullivan reported on the Engineering and Operations Report for May 2011. Mr. Sullivan said that the Gaw Project had no changes in the tangible milestones with the transfer scheme control wiring on schedule for completion in July. He added that the Gaw project is up to$2.4 million for the soil remediation expense with this month's expense of$15,000. Mr. Sullivan stated that as of this week ten out of 15 projects will be completed. He listed the following projects worked on during the month: Projects 1,2,5,and 36. Mr. Sullivan said that there were no commercial installations and 30-35 residential installations for the month. In routine construction there were 41 cutouts replaced making a total of 379 for FY 2011. Mr. Sullivan reported on the Reliability Report: Customer Average Interruption Duration Index(CAIDI) is at 56.31 minutes, the rolling average is 46.23 minutes, which is up slightly from April to May by two minutes, and the rolling average is 4.5 minutes below the four year average. The System Average Interruption Frequency Index(SAIFI)was 0.25 incidents,with the rolling average 0.49. The rolling average decreased due to the dropping of the May 2010 SAIFI of 2.79 which was high. The Months between Interruptions(MBTI)increased from 23 to 24 months. Mr. Sullivan provided an update on the reliability statistics numbers (including the May 1 storm): 93 calls, 19 outages, 618 customers affected,no feeder outages, 14 area outages,and five service outages. Mr. Sullivan reported that the running total of installed meters is about 6,000. Ms. Snyder inquired if that was for residential meters. Mr. Sullivan replied,yes. M.G.L.Chapter 30B Bid(Attachment 6) 2011-12 Sale of Surplus Meters Mr. Sullivan reported that this bid is for residential meters that will be removed as a result of the meter installation project and will be surplus. Mr. Sullivan said that this bid was sent out to nine bidders with two responding. Mr. Sullivan explained that one of the bidders,T&D Surplus,did not complete the required form. Ms. Snyder made a motion seconded by Mr. Pacino that bid 2011-12 for Surplus Watt Hour Meters be awarded to TDI (Transformer Decommissioning, Incorporated) Division of VPG, Incorporated for total revenue of $27,500.00 on the recommendation of the General Manager. Motion carried 5:0:0. General Discussion BOARD MATERIAL AVAILABLE BUT NOT DISCUSSED Rate Comparisons,June,2011 E-Mail responses to Account Payable/Payroll Questions r Regular Session Meeting Minutes 5 June 22,2011 Upcoming Meetings :MLD Board Meetings Wednesday,July 27,2011 Wednesday,August 31,2011—Ms.Snyder said that she will not be in attendance at this meeting. There will be a Power&Rate Committee meeting at a date to be determined in July. Executive Session At 8:45 p.m. Ms. Snyder made a motion seconded by Ms. O'Neill that the Board go into Executive Session to approve Executive Session meeting minutes of March 30,2011,to discuss strategy with respect to MMWEC Arbitration and return to Regular Session for adjournment. Mr. Soli,Abstain;Ms. Snyder,Aye;Mr.Pacino,Aye;Ms. O'Neill,Aye;and Chairman Hahn,Aye. Motion carried 4:0:1. (Mr. Soli abstained.) Adjournment At 9:15 p.m.Ms. Snyder made a motion seconded by Mr.Pacino to adjourn the Regular Session. Motion carried 5:0:0. A true copy of the RMLD Board of Commissioners minutes as approved by a majority of the Commission. Gina Snyder, Secretary RMLD Board of Commissioners a� Q., clt ^t ;-.qn 4.� O CC3 GC3 � � O • N U � � 1 U � W U ------ ___ N U � � N H ct p o ct cnC:) Ct 4-4 � � O 4-4 ctc O U cn ct r--a U U O p .0 ct ct O ct ct • Ctct� CU 0 bQ O N � © U 'Nct bA U ct d' • � U 0 HN -:. �F t fit �t�Niy f rip til j! '�4N1uAM74Si ti at I p` � ��iBra« r m' •U �_ kir H i 5r JUL AW (r a r/ Sm 'h >1 bj) am)t O £Fd�sy 4I cot �'� �i (nLot gil x a r led F d i i 'y a 9 . LV rt�. yfi 'rrt r Skln vk' /'R !"ALV It C014 O U ct ct ct Uct ct ct N U Q ct ct ct ct bA ct ct ct ct Ln ._� ct ° N Ct w ' ct ct ct i�. ✓� U N � W � ct y_ O CCS (n CL O O 'm C6 N — — C2 (DQ J 0 m to O OS 0 C W CO cn O $� ct , a N � oo ct �'-i L Ea ; m C C O .0 U * C = co o U U CO p W/ d C6 C6 � Z L m t�o o U U 0 0 0 -o o ¢ 3 U o U ¢ 0 o S � �T T F-o E-o O m ►— vU �— O o o oz ct ct ct ct O � U ctU ct ct cn � Q U c • �ct bbCtc O llci O ct �, ct READING MUNICIPAL LIGHT DEPARTMENT Attachment 2 '1 To: RMLD Board of Commissioners Date: June 13, 2011 From: Vinnie Cameron 4" Subject: Response to Commissioner Soli May 25, 2011-Street Light Rate Inquiry At the May 25, 2011 Reading Municipal Light Department (RMLD) Board Meeting Commissioner Soli circulated a spreadsheet during the Power and Rate Committee report. Commissioner Soli's handout included statistics questioning the validity and accuracy of the methodology for developing new street light rates included in my.Proposed Street Light Rate memo. Chairman Hahn referred the handout to the Power and Rate Committee. Below is my analysis of Commissioner Soli's handout. Attached are Commissioner Soli's handout and a memo from me to the RMLD Board of Commissioners on the Proposed Street Light Rate, dated April 14, 2011 (My Memo). My Memo was the basis for my recommendation to the Power and Rate Committee, Citizens' Advisory Board (CAB), and the RMLD Board to adjust the RMLD's Street Light Rate. Commissioner Soli's handout includes Tables 1, 2, and 3 from the May 25, 2011 RMLD Board meeting. Table 1 shows the Street Light Rates, as proposed in My Memo. Commissioner Soli's Total per lamp in his Table 1 is basically the same as what appears in Table 2 of My Memo. Commissioner Soli's Table 2, shows the Street Light Expenses from the Operating Budgets for the FY10 (actual), FY11 (�/2 actual and 1/z budget), FY11 (12 months budget), and FY12 budget. Table 3 appears to be a calculation, similar to Table 1, using Operation and Maintenance costs from the FY12 Operating Budget from Table 2. The result is Total per lamp costs, which are significantly different from what I recommended in My Memo and the RMLD Board approved at the 5/25/11 Board meeting. The difference in Commissioner Soli's calculation, as compared to my calculation, is that he uses only Street Light related costs from the FY12 Operating Budget as the street light maintenance cost. In developing a "cost of service" type rate for the street lights, the maintenance costs should reflect not only the maintenance costs directly related to the street lights but also a portion of the maintenance costs of the RMLD's distribution system and administrative and general costs. In Table 2 of My Memo I used $169,181 as the street light maintenance costs, which represents the costs from the FY11 Cost of Service Study allocated to the streetlights, minus depreciation. The description of how the maintenance costs were developed is clearly stated in the first paragraph of page 2 of My Memo and was discussed at both the Power and Rate Committee and the 5/25/11 Board meetings. Commissioner Solis calculation understates the cost of maintaining the street lights on the RMLD's system. The street lights cannot operate correctly without a well maintained distribution system along with administrative and general support. The total maintenance costs for the street lights are identified in Exhibit 5 of the FY11 Cost of Service Study. My Memo captures the appropriate costs that should be allocated to the street lights in order that they operate in an economic and efficient fashion and are billed accordingly. a o"o vii W)i. rn rn m o r N rn w m m r m rn o o r r r r w ci rn rn — m m C� m It "�r er r \0 \ to N N m m m rt7 et e 1 N m tri cm FR fA iA iF} rg -GR 69 iO;3 4,9� ta9 p tf3 ff,- tai .6. i r ty4 H d S Ov m0 M N 000 ev r � �_t in Ch h m ci frCT tft O ri N t ' C dti O �(1 N0 N t° 0\ 4n rl r N cn N p v �' m SNC m m ~ r- rl � � h O M N r a< 1D Ct m w dr m _ r O 00 N h CT tt7 It m w el N w - O h N tC .� M N O\ d N OD - O h ri tti m cm N a !h M -� to r t4 � C14 tD Vl = .� Q � 5 .� K1 E tD C1 N td Vl o. o M M y m w-' - rW CD, m o m eF C � m --� O r- w L) _ U m 00 W' ot f/g COm m O D O O O O O � K3 m cn m m [n t7-: r °i' ri rt ori oo e+i m m m en m "'T .-i .--i N N N C4 N N +', '� N N •-t .-r .--, .-i -t .+9 6? 00 N eg O O� Go cn m N M O ^- N V1 "t M OO; t[ t m h - tc m tD t^ oo er O co ti tri •-� m it Pl SY tD ti t+') C7 e19'`. m r trno N-+ o N—. e►t e°Dr, �' rn co o vi d ri N 't r rri n+ tk aw 0\ rn v� rt ra v� a, ai er+ = o oIn r- � w 00 o rte- v c plQl ' N 'r' #n M c*v'i ~ ^' - m ODy .h-r N tp 00 y o ° m rsNa in O i— rn rr N rn v t L s� try 0 O� - m m tD a, < to ON M .fn OD C a, = m Oq t`D c�i [rl CV O C 5 ri O t` O ^J tlI a Ny t*1 ny N 'J O N C7 C� O An in w N W vi in O 07 t- N OD U 00 'ch' rl CV U'1 K] r M -i ,� N..~ c��t_ CND Q O O O O Do O O r V1 h t''� N OD tp OD -V-h rl CV W) tR r m OD OD -- Obi N *►7 tD r t- oo V7 0.y \J5 0.i tO tD p. vl r N r r - N Z W th v i Y! kn V1 W) [�• N N N N N N O;.Zj .oG m O o. al v .r C"7 p V'1 � to a writ ti O O h r.. N N N N N N N O O -' ...r .-i .ti ,-i ,-i cli pa...-i N N tD � 1 ..r c+t o O, to r th `�. r1 Ch .O' C 011 OO O+ r- J t7 N O, todGO mh � Nm 0\.� t -EN Irl t*1 'Y t N N OD xn •+: m O as N as '� .-� wr " N .cz cz '^O� N o %wn o o a W o j o o o O o V) rn in CAED api cK c 'w rn m CO EQ CZ ca •u $ a n. fl m o oU `10 a� ur a a cc N tc to .� a at W) Z M 7- 2 x 2 READING MUNICIPAL LIGHT DEPARTMENT To: RMLD Board of Commissioners , Date:April 14, 2011 From: Vinnie Cameron Subject: Proposed Street Light Rate The Reading Municipal Light Department (RMLD) filed a rate increase in August, 2010 and received approval from the Massachusetts Department of Public Utilities (MDPU) for a rate increase That became effective on September 1, 2010. At this time, the RMLD decided to assess the Street Light Rate to see if there'could be changes to its structure, which would more closely reflect the cost of service included in the FY11 Cost of Service Study(PY11 Coss). The FY11 COSS showed that the allocated Cost of Service was $246,083, which represents fhe allocated capital and operating costs of the street lights in the RMLD's service territory. According to the FY11 COSS, the existing street light revenues are expected to be$619,877, which represents an over recovery of$373;795. Table 1 shows the Street Light Cost Components, which include the bracket, arm, fixture, photo cell, and bulb. The brackets only apply.to the 400 Watt Mercury and 400 Watt I-iigh Pressure Sodium lights. The poles are charged separately. Table.2 shows the Street Light Capital and Operating Costs,which includes the capital and operating casts allocated to each type of street light the RNILD provides to the four towns, Column.l snows the type of street light the RMLD offers to the four towns. The Capital Costs of each street Light represents the cost of the street light is shown in Column 2. The Annua1 Carrying Charge,(8%),which represents the depreciation, discount-rate,insurance, etc.,.is used to calculate the Annual Capital Cost of each street light. This Annual Capital Cost represents the amount per kWh the RIVILD should recover annuallyrto pay for the capital cost of each type of street light on the system. Column :3.shows the Annual Capital Cost of the street light type and,.is calculated by multiplying the Total. Capital Cost by the Annual Carrying Charge. Column 4 is the Annual. Energy each of.the street light types uses annually. Column 5 shows the Capital Cost per kWh,which is the Annual.Capital Cost, divided by the Aral Energy. The Number of Street'Lights in the next column.represents the amount of each type of street light installed within the four towns the RYZ.D serves. The Total lcWh is the Numbex of Street Lights multiplied times the .Annual Energy. The Total Capital Costs for each street-light type is derived by multiplying the Annual Capital Cost times the Number of Street Lights. The next set of columns is used to determine the maintenance cost for each street light type. The Maintenance Factor is a factor assigned to each street light type and represents an estimate of the activity the RMLD expends annually to maintain the street lights on the RMLD system. The next column is the Allocated Maintenance Costs for each street light type, which is calculated by applying the Maintenance Factor to the Budgeted Maintenance Costs of $169,118 and Number of Street Lights. The total Allocated Maintenance Cost is $169,181, which is .04% higher than the Budgeted Maintenance Costs shown at the top of the page. The Budgeted Maintenance Costs have been adjusted to account for depreciation expense component of the Street Light Rate that is in the Annual Carrying Charge. The Maintenance Cost per kWh is calculated by dividing the Allocated Maintenance Costs by the Total kWh. The Annual Cost per Street Light is calculated by summing the Annual Capital Cost and the Allocated Maintenance Costs and dividing it by the Number of Street Lights. The Annual Cost per kWh is the Annual Cost per Street Light divided by the Annual Energy. The average Annual Cost per kWh is$.0686. The Annual Cost per Street Light is used to calculate the Street Light Rate and appears in the filed Street Light Rate. There is an alternative rate structure that the RMLD could charge for its street lights. Chapter 164 of the Massachusetts General Laws, which largely govern the municipal electric utilities in Massachusetts,has made an exception for street light rates in Section 58, shown below. - E �Y P _ 4' 2 Section 58 allows a municipal electric utility to base the street light rate on an average rate as an alternative to a cost of service rate. The average rate for street lights is the RMLD's average cost per kWh that is calculated by dividing the RMLD's annual operating expenses by the annual kWh sales. (See the bold area of the Section 58 above.) Table 3 shows the calculation for the Average Street Light Rate, which is based on the FY11 Operating Budget. The law states that the costs for the street light rate should include the "sum of all operating expenses". Table 3 shows the Total Operating Expense minus the Fuel Expense because fuel is charged separately. The Total Operating Expense reflects the FY11 Operating Budget minus the Purchased Power Fuel Expense. Table 3 Average Cost per kWh Street Light Cost Operating Expense $831555,091 Fuel Expense ($39,271,794) Total Operating Expense $44,283,297 Total kWh Sales 683,056,320 Average Cost per kWh $.064831 The Total kWh Sales is from the revenue projection also included in the FY11 Cost of Service Study and the resulting Cost per kWh is$.064831. Table 4 shows the comparison of the proposed Cost of Service Street Light Rate and the Average Street Light Rate. The Existing Street Light Rate is what the RMLD presently has on file at the Massachusetts Department of Public Utilities (MDPU) and is in the RMLD's Street Light rate. The Proposed COSS Rate is taken from the Annual Cost per Street Light shown in Column 12 of Table 2. The Average Rate is the Annual Energy shown in Column 4 of Table 2 multiplied by $.064831, which is the RMLD's Average Cost per kWh shown on Table 3. 3 Table 4 Comparison of the.Street Light Pates Cost of Service Rate versus the Average Pate Existing Light Type Proposed Average COSS Rate COSS Rate Rate 58 Watt Incandescent $24..09 $50.83 $13.04 95 Watt Incandescent $3447 $50.83 $23.86 50 Watt HP'S $60.69 $27.50 $13.82 100 Watt HPS $63.86 $27.55 $32.93 100 Watt Merc. Vapor $63.98 $37 96 $33.72 100 Watt Merc. Vapor U/G $92.30 $37.96 $33.71 175 Watt Mercury Vapor $100.93 $3828 $55.75 250 Watt HPS Flood $109.48 $50.66 $79.61 400 Watt Merc Flood $165.65 $49.71 $11929 400 Watt HFS $165.52 $49.76 $118.51 Note: HPS-High Pressure Sodium U/G—Underground The result shows that the Proposed COSS Rates, in most instances,- are less than the existing rates. (The Existing COSS Rates were developed in 1985 and have.been escalated in several rate filings since then. The back-up detail to the Street Light Rate from the 1985 COSS'is not available..) Table 4 also shows:Shat the Average Cost Rates.are lower than.the Existing COSS Rate and,in some instances,lower than the Proposed COSS Rates, Table. 5A is the Revenue Proof of the Existing .Street Light Pate, which shows that the .Revenue Requirement Class Total is $246,083, which is also reflected in the FY11 Cost of Service Study. The Forecast Class Total using the E)dsting Street Light Rates is$619,877 or an over recovery of$373,795 against the Revenue Requirement Class Total. Table. 5B shows the Revenue Proof using the Proposed Cost of Service Street Light Rates, which results in Forecast Class Total revenues of$259,834,which is lower than the Existing Street Light Forecast Class Total in Table 3A by $619,877. The difference between the two rates is $360,043, which is a negative impact oil the RMLD's income. The Proposed Street Light Rate revenue is $13,751 higher than the Revenue Requirement Class Total of $246,083, however,the caulculation of this rate -more closely represents the Cost of Service of the street lights. Table 5C shows the Revenue Proof for the Average Street Light Pate, which is SI_,709 and is $374 lower than the Revenue Requirement Class Total. The.Average Street Light 4 Fate would have an estimated negative affect on income of 5374,168, which would translate into savings for the four towns and the customers who have private street lights. In-summa_ry, the Existing Street Light Rates over recover the Revenue Requirement Class Total by 5373,793. The Proposed Street Light Rate is based on the present capital cost of the street lights in the four towns and the nnaintenance costs in the FY11 Cost of Service Study, which results in an over recovery of $13,751 as shown in Table B. The Average Cost Street Light Rate is based on the RMLD's average (non-fuel) cost of a kWh and is close to the Forecast Class Total revenues in the Cost of Service Study;however,it is not a fair representation of the Street Light Cost of Service. The RMLD recommends the Proposed .Cost of Service Street Light Rate, which as stated above, more closely reflects the cost of service rate and provides savings to customers on the street light rate. 5 Cn. Cn d M M P- N C5 d D CO OD M P7 M M M Cn Cn CCt fig {f} £f,} bS 6c} H} H3 8F} D H M M N r Cp CO Ln Cl) N OO N N CA f• O O d C9 CD N OO h- CiJ ^ } EH bF} 63 ff3 64 tFD bg bg O EF3 bl v CV N ffl EF3 tag 6S £F1 EF3 if} Vfl O o 6 � o tl. `o T � o o rn rn o o d .tp N N O J OD d. O O C7 CD � cr � O � o o Lri co ai ai � Ln L.p cri (.� •-. fH Ef} GF} 64 EH EPr b4 N N LL J Cn Cn CA d D7 C� CA �F '[i et e1 V q et rt tD � 69 G9 t- H} D LNt7 Lf e39- 69- OO -- L LO L L D c L a U U > > Cl) m ? .P .P Cl) _U U U U U U . Q. _N N _N LL cl) 0 0 0 Ln O .O O �}- N D D m m D N m m a, m N t mM y A A m =Y EA fag fR 63 tR GA K fH tp, V}ffl . C-tU c n to m m m ED tD " m•m m w m m N m 1. A IA O C A A A A m to to ❑ <r (,>� u�fh vt fA to ffi fR fg va M - l9 N c� L ¢ `m n M m LL'1 m to A N m D1 W m Ql M N N N er L O 0 0 O O D O O O O _ � n v>ce to aF ff3 fi3 fn .» ft) fi� m o U m m A T O �- D m C O W — M m D m m N m M m N vi m m t0 ^ N O N tT L N rn N m O m 01 m T[t1 U N 40i in M M 49 fF} ffd U f9 fH (H Mi M D U D D A A N N N N N N pm N N O O r r e- r r r U c `o U V L LL W 01 A O m N A m m m M m N @ W N m r D A N m M M N to !' tT r M A CO fA 4' N m !n CD F *0> tri - G ti p ,U �, u;• M fFt �, m V Q,t :m p tH eq +.s trr(ty � U — Cq eC 01N m O W O O O m O C �*' m c m r o v m m m N m A ' O Q L _ O N CV C tq O 4 O r m m M A M m O m -T N 'a D y +^ A m m m A d � � to ttl C. m N 'M ID A m M C D C M N m N m 'C tD A tr r Q A Q M r .- w � a rn V #O > M ^m e W N N N m N N O m Y D O O 0 0 0 0 0 0 0 a `m � � � asrA � rnusw �n w a U y D U m � � ocDv � w "•tQn°Oi m rn N <LU C m U c m m m A m m m m — m co m rn M c a D to m b r tri tri A N D O fR K N N N ' � td fA /R fe9 G4 fir K fA IH n m U o `o a a CD to V U > > C .0 L 2 L y. m m m s 3i�: 3S i W N o 0 0 0tr, D o o '' m.mo mhmto W L ' f cf) Wom m m �r N m N p m - ' h m m h h m -t 0) Am m h;n N m , m N m V N o= mC° LL m N CV m e r- D W CD D a 00 C) m y m o m ELI e� E» U) mm mome Qt O C N <A m CD O7 N =— � m� N 0- m ACD R'1 W O 0) Lr) m N m In et t17 U m > N d N m « C) = rn LL 0 o a o .0 ID >m D a co 79m > d iT f- ul m CO [0 Q c N CD.CD N N 6 O m � � Am m tih +-r- r, U m v o c c v N W o m m A r m m= m cl C15 t U-U mco . a� r co my a o d _ c c LL 0 m 0 0 o tr N o 0 0 _m cR7a U m ILL ^ N CG �� m d e� C) Z _ m .O 72 U L v V o } r D .• � � � Cn U ^' a, o T, Li� iv U D .111 0) . U cotta p ti m m m ° p z m a)ami � r m ;_ CC L` WD to m pC31= U D ED v C) i,l M .CD mtm M LO N !�. NCD ICD [D C�9 a? C m N tLr)eY�•- W LL1 G9 6q fii m O m CD ".. N m m N p !�m M- p 'C O Q at N}_ W rl-i Cb CO W a �N MN r U mom? o = W U a r U Lr W W LL `L LC Q1 a ED M w m ! p m to 00 � O � C) W � tfi C W N t27 CP O mC -Ma 0 o c c mom m -p CD m N CD C m W'D «- a) N N 0)�M CD Ch O W V) m tf) CMD N to W d +. U} mDr er 6' O O m mW.c o sa N d y W G C > O V � p mccomm fir°EN 10 to ; �.h rntoZ � Nin W U W D C CO tV MM UU r m M D m m C7 L) v m LL W �7D O 6 m !!!!N C! O O CO m U ?,N L � L to m d � W G C cm II'i•Cp W U W 111 N D tl W N N D CG LT 41 W G o z a.'3^ U D Lu LI) m v ti D ° c CL d m p d.� U D w W IL =tto a D IW) rn m 'r ED a, co 'V' CD N C N •—N N C N LU c�? filr e mo m to NCD m t,- Cl C% ° m 1� m C' .,J- f� N y0 �? m C:) m W N m aNiD m VA CD LL m m ay er ti o C C) O � o m Z ca 6s o m GL Lr ea 661 � rnm moco � D C N m a� CD C17 ' CA m O m w ti CD t° co N m lN to Qf cai Lu > Uy � tv w 66. O O m m D L) en 0.. y o ti D o d o c m �m m D m m m m m o m C CI ' ' � COM m ti 0--Lu N `ca m c cv t*i cri V �) m m > o > > yi m e e ° 0 0 o Q co � U a� d N 03 CA N U C w�� U co S N a J �U J N } _ 'D N (n D W ° Nr O N -� N Cn Ll ZT ° m co n is m J o D w ° Q,° r to a I LL o L' W Dt: June 22, 2011 attachment 3 To: RMLB, Vincent F. Cameron, Jr., Jeanne Foti Fr: Bob Fournier Sj: Financial Report May 31, 2011 The results for the eleven month period ending May 31, 2011, for the fiscal year 2011 will be summarized in the following paragraphs. 1) Change in Net Assets or Net Income: (Page 3A) For the month of May, the net loss or the negative change in net assets was $371,515, decreasing the year to date net income to $2,235,635. The year to date budgeted net income was $1,962,604, the difference being$273,031, or 13.91%. Year to date fuel expenses exceeded fuel revenues by $33,945. Year to date energy conservation expenses exceeded energy conservation revenues by $114,103. Year to date GAW soil remediation expenses totalled $1,279,713 bringing the total cost to date for this project to $2,376,145. 2) Revenues: (Page 11B) Year to date base revenues were over budget by $4,308,549 or 11.54 %. Actual base revenues were $41.6 million compared to the budgeted amount of$37.3 million. 3) Expenses: (Page 12A) *Year to date purchased power base expense was under budget by $231,975 or .91%. Actual purchased power base costs were $25.2 million compared to the budgeted amount of$25.4 million. *Year to date operating and maintenance (O&M) expenses combined were over budget by $597,884 or 5.55%. Actual O&M expenses were $11.3 million compared to the budgeted amount of$10.7 million. The major expenses that were over budget were maintenance of line transformers ($647,076) and employee benefits ($338,276). *Depreciation expense and voluntary payments to the Towns were on budget. 4) Cash: (Page 9) *Operating Fund balance was at$8,587,981. *Capital Funds balance was at$4,487,842. *Rate Stabilization Fund balance was at$5,395,421. *Deferred Fuel Fund balance was at $2,292,167. *Energy Conservation balance was at $194,779. 5) General Information: Year to date kwh sales (Page 5) were 4.14%, or 25.8 million kwh ahead of last year's figure. GAW revenues to date increased to $510,744. 6) Budget Variance: Cumulatively, the five divisions were over budget by $549,926 or 3.20 %. FINANCIAL REPORT MAY 319 2011 ISSUE DATE : JUNE 2212011 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS-TYPE PROPRIETARY FUND STATEMENT OF NET ASSETS 5/3Z/11 PREVIOUS YEAR CURRENT YEAR ASSETS CURRENT UNRESTRICTED CASH (SCH A P.9) 7,630,465.87 6,590,981.06 RESTRICTED CASH (SCH A P.9) 15,762,877.42 16,387,792.35 RESTRICTED INVESTMENTS (SCH A P.9) 4,400,000.00 2,200,000.00 RECEIVABLES, NET (SCH B P.10) 7,622,159.99 6,809,951.83 PREPAID EXPENSES (SCH B P.10) 884,605.52 915,909.52 INVENTORY 1,520,660.50 1,652,115.35 TOTAL CURRENT ASSETS 38,020,769.30 36,556,750.11 NONCURRENT INVESTMENT IN ASSOCIATED CO (SCH C P.2) 97,690.11 85,253.67 CAPITAL ASSETS, NET (SCH C P.2) 65,645,350.23 67,709,105.13 TOTAL NONCURRENT ASSETS 65,743,040.34 67,794,356.80 TOTAL ASSETS 103,763,809.64 104,351,108.91 LIABILITIES CURRENT ACCOUNTS PAYABLE 8,254,013.94 6,055,263.53 CUSTOMER DEPOSITS 500,252.93 559,235.03 CUSTOMER ADVANCES FOR CONSTRUCTION 313,586.41 294 124.56 ACCRUED LIABILITIES 954,137.59 1,366,953.66 TOTAL CURRENT LIABILITIES 10,021,990.82 8,275.576.78 NONCURRENT ACCRUED EMPLOYEE COMPENSATED ABSENCES 2,873,114.33 3,020,032.75 TOTAL NONCURRENT LIABILITIES 2,873,114.33 3,020,032.75 TOTAL LIABILITIES 12,895,105.15 11,295,609.53 NET ASSETS INVESTED IN CAPITAL ASSETS, NET OF RELATED DEBT 65,645,350.23 67,709,105.13 RESTRICTED FOR DEPRECIATION FUND (P.9) 5,794,641.85 4,487,842.36 UNRESTRICTED 19,428,712.41 20,858,551.89 TOTAL NET ASSETS (P.3) 90.868,704.49 93,055,499.38 TOTAL LIABILITIES AND NET ASSETS 103,763,809.64 104,351,108.91 tl) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT NONCURRENT ,ASSET SCHEDULE 5/31/11 SCHEDULE C PREVIOUS YEAR CURRENT YEAR SCHEDULE OF INVESTMENTS IN ASSOCIATED COMPANIES NEW ENGLAND HYDRO ELECTRIC 36,244.74 23,538.60 NEW ENGLAND HYDRO'TRANSMISSION 61,445.37 61,715.07 TOTAL INVESTMENTS IN ASSOCIATED COMPANIES 97,690.11 85,253.67 SCHEDULE OF CAPITAL ASSETS LAND 1,265,842.23 1,265,842.23 STRUCTURES AND IMPROVEMENTS 7,005,719.88 6,886,443.43 EQUIPMENT AND FURNISHINGS 13,122,544.39 13,499,188.19 INFRASTRUCTURE 44,251,243.73 46,057,631.26 TOTAL UTILITY PLANT 65,645,350.23 67,709,105.13 TOTAL NONCURRENT ASSETS 65,743,040.34 67,794,358.80 C2) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS-TYPE PROPRIETARY FUND STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND NET ASSETS 5/31/11 MONTH MONTH LAST YEAR CURRENT YEAR YTD OPERAfiING REVENUES: (SCH D P.11) LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE BASE REVENUE 2,970,593.99 3,320,456.79 35,613,824.49 41,629,209.20 16,89% FUEL REVENUE 2,702,442.95 2,681,181.10 39,136,962.26 36,985,800.09 -5.50% PURCHASED POWER CAPACITY 529,410.04 37,591.24 4,244,356.62 1,318,688.36 -68.93$ FORFEITED DISCOUNTS 61,963.02 72,044.18 789,974.97 934,577.34 16.30% ENERGY CONSERVATION REVENUE 43,210.50 34,534.58 502,209.70 450,055.02 -8.39% GAW REVENUE 0.00 50,129.95 0.00 510,743.82 100.00% PASNY CREDIT (29,.674.62) (37.496,39) (481,597.59) (682,791.67) 41.98% TOTAL OPERATING REVENUES 6,277,945.68 6,158,441.45 79,805,730.45 81,156,282.16 1.69% OPERATING EXPENSES: (SCH E P.12) PURCHASED POWER BASE 2,198,144.27 2,100,555.69 25,226,774.99 25,181,471.63 -0.18% PURCHASED POWER FUEL 3,058,960.72 3,015,861.75 36,755,984.99 36,336,953.37 -1.14% OPERATING 545,914.73 625,569.44 7,378,118.00 7,774,527.39 5.37% MAINTENANCE 255,516.06 228,341.75 2,628,615.48 3,592,025.07 35.64% DEPRECIATION 280,105.78 287,729.05 3,081,163.58 3,165,019.55 2.7296 VOLUNTARY PAYMENTS TO TOWNS 104,500.00 110,000.00 1,149,246.00 1.205,885.00 4,93.% TOTAL OPERATING EXPENSES 6,543,143.56 6,368,177.68 76,220,103.04 77,255,882.01 1.36% OPERATING INCOME (265,197.88) (209,736.23) 3,585,627_41 3,900,400.15 8.78% -OPERATING REVENUES (EXPENSES) NTRIBUTIONS IN AID OF CONST 82,767.68 14,720.64 842,848.75 61,864.66 -92.66% TURN ON INVESTMENT TO READING (162,222.50) (180,990.00) (2,004,447.50) (1,990,890.00) INTEREST INCOME 2,546.33 3,089.09 160,403.38 98,278.65 38.73% INTEREST EXPENSE (1,257.14) (1,003.48) (19,562.31) (13,311.11) -31.96% OTHER (MDSE AND AMORT) 4,927.74 2,405.00 264,118.64 179,272.42 32.12% TOTAL NONOPERATING REV (EXP) (93,237.89) _ (161,778.75) (756,639,04) (1,664,765.38) 120.02% CHANGE IN NET ASSETS (358,435.77) (371,514.98) 2,828,988.37 2,235,634.77 -20.97% NET ASSETS AT BEGINNING OF YEAR 88,039,716.12 90,819,864.61 3.16% NET ASSETS AT END OF MAY 90,868,704.49 93,055,499.38 2.41% (3) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS-TYPE PROPRIETARY FUND STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND NET ASSETS 5/31/11 ACTUAL BUDGET a YEAR TO DATE YEAR TO DATE VARSANCE* CHANGE OPERATING REVENUES: (SCE F P.11B) BASE REVENUE 41,629,209.20 37,320,660.00 4,308,549.20 11.54% FUEL REVENUE 36,985,800.09 37,015,567.00 (29,766.91) -0.08% PURCHASED POWER CAPACITY 1,318,686.36 4,935,241.00 (3,616,552.64) -73.28% FORFEITED DISCOUNTS 934,577.34 621,055.00 113,522.34 13.83% ENERGY CONSERVATION REVENUE 460,055.02 491,678.00 (31,622.98) =6.43% GAW REVENUE 510,743.82 270,000.00 240,743.82 89.16% PASNY CREDIT 1682,791.671 f550,000.00) (132,791.67) 24.140 TOTAL OPERATING REVENUES 81,156,282.16 80,304,221.00 852,061.16 1.06% OPERATING EXPENSES: (SCH G P.12A) , PURCHASED POWER BASE 25,181,471.63 25,413,447.00 (231,975.37) -0.91% PURCHASED POWER FUEL 36,336,953.37 36,658,915.00 (321,961.63) -0.88% OPERATING 7,774,527.39 7,910,241.00 (135,713.61) -1.72% MAINTENANCE 3,592,025.07 2,858,427.00 733,598.07 .25.66% DEPRECIATION 3,165,019.55 3,208,337.00 (43,317.45) VOLUNTARY PAYMENTS TO TOWNS 1,205,885.00 1,210,000.00 (4.115.00) -0.34% TOTAL OPERATING EXPENSES 77,255,862.01 77,259,367.00 (3,484.99) 0.00% OPERATING INCOME 3,900,400.15 3,044,854.00 855,546.15 26.10% NONOPERATING REVENUES (EXPENSES) CONTRIBUTIONS IN AID OF CONST 61,884.66 400,000.00 (338,115.34) -84.53% RETURN ON INVESTMENT TO READING (1,990,890.00) (1,993,750.00) 2,860.00 -0.14% INTEREST INCOME 98,276.65 412,500.00 (314,221.35) -76.17% INTEREST EXPENSE (13,311.11) (11,000.00) (2,311.11) 21.01% OTHER (MDSE AND AMORT) 179,272.42 110,000.00 69,272.42 62.97% TOTAL NONOPERATING REV (EXP) (1,664,765.38) (1,062,250.00) (582,515.38) 53.82% CHANGE IN NET ASSETS 2,235,634.77 1,962,604.00 273,030.77 13.91% NET ASSETS AT BEGINNING OF YEAR 90,619,864.61 88,039,716.12 2,780,148.49 3.16% NET ASSETS AT END OF MAY 93,055,499.38 90,002,320.12 3,053,179.26 3.39% * ( ) = ACTUAL UNDER BUDGET (3A) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT RECONCILIATION OF CAPITAL FUNDS 5/31/11 SOURCE OF CAPITAL FUNDS: DEPRECIATION FUND BALANCE 7/1/10 4,801,693.77 CONSTRUCTION FUND BALANCE 7/1/10 0.00 INTEREST ON DEPRECIATION FUND FY 11 14,146.17 DEPRECIATION TRANSFER FY 11 3,165,019.55 FORCED ACCOUNTS REIMBURSEMENT 0.00 GAW SUBSTATION FY 11 499,608.00 TOTAL SOURCE OF CAPITAL FUNDS 8,480,467.49 USE OF CAPITAL FUNDS: PAID ADDITIONS TO PLANT THRU MAY 3,493,017.13 PAID ADDITIONS TO GAW THRU MAY 499,608.00 TOTAL USE OF CAPITAL FUNDS 3,992,625.13 GENERAL LEDGER CAPITAL FUNDS BALANCE 5/31/11 _ 4,487,842.36 PAID ADDITIONS TO GAW FROM FY 11 499,608.00 PAID ADDITIONS TO GAW FROM FY 10 1,372,876.00 PAID ADDITIONS TO CAW FROM FY 09 3,136,764.00 PAID ADDITIONS TO GAW FROM FY O8 1,895,975.00 TOTAL 6,905,223.00 (q� TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SALES OF R'rT.OWATT HOURS 5/31/11 MONTH MONTH LAST YEAR CURRENT YEAR YTD SALES OF ELECTRICITY: LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE RESIDENTIAL SALES 17,019,117 16,024,893 226,083,307 239,846,917 6.09% COMM. AND INDUSTRIAL SALES 33,088,692 31,784,610 369,799,146 381,689,568 3.22% PPSVATE STREET LIGHTING 70,898 72,646 781,191 792,756 1.480 TOTAL PRIVATE CONSUMERS 50,178,707 47,882,149 596,663,644 622,329,241 4.30% MUNICIPAL SALES: STREET LIGHTING 238,853 239,009 2;613,243 2,627,623 0.55% MUNICIPAL BUILDINGS 753,230 675,781 9,080,537 9,137,773 0.63% TOTAL MUNICIPAL CONSUMERS 992,083 914,790 11,693,780 11,765,396 0.610 SALES FOR RESALE 236,376 195,043 2,975,540 3,172,498 6.62% SCHOOL 1,181,759 1,126,807 13;442,564 13,355,.501 -0.65% TOTAL KILOWATT HOURS SOLD 52,586,925 50,118,789 624,775,528 650,622,636 4.14% 15) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT KILOWATT HOURS SOLD BY TOWN 5/31/11 TOTAL READING LYNNFIELD NO.READING WILMINGTON ATH RESIDENTIAL 16,024,893 5,090,013 2,148,440 3,903,283 4,883,157 COMM & IND 31,784,610 3,840,963 248,761 4,789,860 22,905,026 PVT ST LIGHTS 72,646 14,081 1,360 21,288 35,917 PUB ST LIGHTS 239,009 80,436 32,437 39,837 86,299 MUNI BLDGS 675,781 184,039 137,944 132,540 221,258 SALES/RESALE 195,043 195,043 0 0 0 SCHOOL 1,126,807 405,156 248,189 149,120 324,342 TOTAL 50,118,789 9,809,731 2,817,131 9,035,928 28,455,999 YEAR TO DATE RESIDENTIAL 239,846,917 75,421,333 33,628,627 56,042,692 74,754,265 COMM & IIID 381,689,568 47,593,444 3,079,588 57,811;502 273,205,034 PVT ST LIGHTS 792,756 154,129 14,960 232,489 391,178 PUB ST LIGHTS 2,627,623 884,796 356,959 437,167 948,701 MUNI BLDGS 9,137,773 2,487,520 1,562,051 1,817,926 3,250,276 SALES/RESALE 3,172,498 3,172,498 0 0 0 SCHOOL 13,355,501 4,729,816 2,836,157 1,757,040 4,032,486 TOTAL 650,622,636 134,443,536 41,498,342 118,098,816 356,581,940 LAST YEAR TO DATE RESIDENTIAL 226,083,307 71,212,463 31,638,905 52,539;106 70,692,833 COMM & IND 369,799,146 45,938,025 2,971,937 57,876,589 263,012,595 PVT ST LIGHTS 761,191 153,349 14,960 230,442 382,440 PUB ST LIGHTS 2,613,243 868,631 3.60,837 436,638 947,137 MUNI BLDGS 9,060,537 2,447,331 1,521,472 1,714,961 3,396,773 SALES/RESALE 2,975,540 2,975,540 0 0 0 SCHOOL 13,442,564 4,899,631 2,734,839 1,750,760 4,057,334 TOTAL 624,775,528 128,494,970 39,242,950 114,548,496 342,489,112 KILOWATT HOURS SOLD TO TOTAL MONTH TOTAL READING LYNNFIELD NO-READING WILMINGTON RESIDENTIAL 31.97% 10.16% 4.29% 7.79% 9.73% COMM & IND 63,42% 7.66% 0.50% 9.56% 45.70% PVT ST LIGHTS 0.14% 0.03% 0.00% 0.04% 0.07% PUB ST LIGHTS 0.48% 0.16% 0.06% 0.08% 0.18% MUNI BLDGS 1.35% 0.37% 0.26% 0.26% 0.44% SALES/RESALE 0.39% 0.39% 0.00% 0.00% 0.00% SCHOOL 2.25% 0.81% 0.50% 0,30% 0.64% TOTAL 100.00% 19.58% 5.63% 18.03% 56.76% YEAR TO DATE RESIDENTIAL 36.86% 11.59% 5.17% 8.61% 11.49% COMM & IND 58.67% 7.32% 0,47% 8.89% 41.99% PVT ST LIGHTS 0.12% 0.02% 0.00% 0.04% 0.06% PUB ST LIGHTS 0.41% 0.14% 0.05% 0.07% 0.15% MUNI BLDGS 1.40% 0.3B% 0.24% 0.28% 0.50% SALES/RESALE 0.49% 0.49% 0.00% 0.00% 0.00% SCHOOL 2.05% 0.73% 0.44% 0.27% LAST YEAR TOTAL 100.00% 20.67% 6.37% 18.16% 54.80% TO DATE RESIDENTIAL 36.18% 11.40% 5.06% 8.41% 11.319. COMM & IND 59.19% 7.35% 0.48% 9.26% 42.10% PVT ST LIGHTS 0.13% 0.02% 0.00% 0.04% 0.07% PUB ST LIGHTS 0.42% 0.14% 0.06% 0.07% 0.15% MUNI BLDGS 1.45% 0.39% 0.24% 0.27% 0.55% SALES/RESALE 0.48% 0.46% 0.00% 0.00% 0.009. SCHOOL 2.15% 0.76% 0.44% 0.28% 0.65% TOTAL 100.00% 20.56% 6.28% 18.33% 54.63% (6) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT FORMULA INCOME 5/31/11 TOTAL OPERATING REVENUES (P.3) 81,156,282.16 ADD: POLE RENTAL 99,586.40 CUSTOMER DEPOSIT INTEREST INCOME 1,439.39 LESS: OPERATING EXPENSES (P.3) (77,255,882.01) CUSTOMER DEPOSIT INTEREST EXPENSE (13,311.11) FORMULA INCOME (LOSS) 3,988,114.83 (7) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT GENERAL STATISTICS 5/31/11 MONTE OF MONTE OF $ CHANGE YEAR THRU MAY 2010 MAY 2011 2010 2011 MAY 2010 MAY 2011 SALE OF KWE (P.5) 52,588,925 50,118,789 —2.930 4.14% 624,775,52.8 650,622,636 KWE PURCHASED 59,563,301 57,739,678 —1.66% 3.46% 649,003,520 671,473,310 AVE BASE COST PER KWH 0.036904 0.036381 7.72% —3.52% 0.038870 0.037502 AVE BASE SALE PER KWH 0.056487 0.066252 2.31% 12.25% 0.057003 0.063984 AVE COST PER KWH 0.088261 0.088614 —11.47% —4.07% 0.095505 0.091617 AVE SALE PER WE 0.107875 0.119748 —10.97% 0.99% 0.119644 0.120830 FUEL CHARGE REVENUE (P.3) 2,672,768.13 2,643,684.71 —22.70% —6.09% 38,655,364.67 36;303;008.42 LOAD FACTOR 54:08% 65.08% PEAK LOAD 150,886 121,532 !e) i dw << O .� U O O °,Jbn o (3) �p VJ nom`` VJ W (Q °1pp I °` fib O�,�n o,e o OZ db 0/�6r7, 0��y ■ 0 O sip 60 p� `V 60' JO OO 60�b 6 6 60 db 60 VI/ 6�y (90 6 Jop 'PC �p� °apo �0 is) 6��6 I s ^ 0 LO 0 0 M r*.— LO N �- 0 C) 0 0 0 0 co o a o 0 0 o co 69- 69- 69- 61:� GPJ- GCXI 69- TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF CASH AND INVESTMENTS 5/31/11 SCHEDULE A PREVIOUS YEAR CURRENT YEAR UNRESTRICTED CASH CASH - OPERATING FUND 7,827,465.B7 6,587,981.06 CASH - PETTY CASH 3,000.00 3,000.00 TOTAL UNRESTRICTED CASH 7,630,465.87 8,590,961.06 RESTRICTED CASH CASA - DEPRECIATION FUND 5,794,641.85 4,487,842.36 CASH - TOWN PAYMENT 1,433,625.00 1,456,250.00 CASH - DEFERRED FUEL RESERVE 3,638,773.93 2,292,167.14 CASH - RATE STABILIZATION FUND 2,413,286.73 4,395,421.49 CASH - UNCOLLECTIBLE ACCTS RESERVE 28,988.15 200.,000.00 CASH - SICK LEAVE BENEFITS 1;416,652.68 2,036;980.50 CASH - INSURANCE RESERVE 35,251.72 0.00 CASH - HAZARD WASTE RESERVE 150,000.00 150,000.00 CASH - CUSTOMER DEPOSITS 500,252.93 559,235.03 CASH - ENERGY CONSERVATION 351,404.43. 194,779.06 CASH - OPER 0.00 615,116.77 TOTAL RESTRICTED CASK 15,762,877.42 16,387,792.35 RESTRICTED INVESTMENTS RATE STABILIZATION * 2,900,000.00 1,000,000.00 SICK LEAVE BENEFITS ** 1,500,000.00 1,000,000.00 OPER *** 0.00 200,000.00 TOTAL RESTRICTED INVESTMENTS 4,400,000.00 2,200,000.00 TOTAL CASH BALANCE 27,993,343.29 27,178,773.41 MAY 2010 * FED HOME LOAN MTG CORP 1,400,000.00; DTD 07/02/09; INT 3.259.; MATURITY 07/15/14 * FED HOME LOAN MTG CORP 1,500,000.00; DTD 01/23/09; INT 2.00%; MATURITY 01/15/13 ** FED HOME LOAN MTG CORP 500,000.00; DTD 01/23/09; INT 2.00%; MATURITY 01/15/13 ** FED HOME LOAN MTG CORP 500,000.00; DTD 06/01/09; INT 3.70%; MATURITY 06/11/16 ** FED NATIONAL MTG ASSN 500,000.00; DTD 05/07/09; INT 3.00%; MATURITY..05/15/15 MAY 2011 FREDDIE MAC 1,000,000.00; DTD 09/10/10; INT 2.00%; MATURITY 09/1_5/20 ** FREDDIE MAC 1,000,000.00; DTD 09/10/10; INT 2.00%; MATURITY 09/15/20 *** FREDDIE MAC 200,000.00; DTD 09/10/10; INT 2.00%; MATURITY 09/15/20 (9) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF ACCOUNTS RECEIVABLE 5/31/11 SCHEDULE B PREVIOUS YEAR CURRENT YEAR SCHEDULE OF ACCOUNTS RECEIVABLE RESIDENTIAL AND COMMERCIAL 3,675,586.75 3,209,696.38 ACCOUNTS RECEIVABLE - OTHER 108,689.67 124,343.83 ACCOUNTS RECEIVABLE - LIENS 132,603.97 83,925.83 ACCOUNTS RECEIVABLE - EMPLOYEE ADVANCES 1,067.16 892.14 SALES DISCOUNT LIABILITY (275,327.28) (304,636.06) RESERVE FOR UNCOLLECTIBLE ACCOUNTS (193,405.06) (359,629.40) TOTAL ACCOUNTS RECEIVABLE BILLED 3,449,215.41 2,754,792.72 UNBIT-10 ACCOUNTS RECEIVABLE 4,172,944.58 4,Q551159.11 TOTAL ACCOUNTS RECEIVABLE, NET 7,622,159.99 6,809,951.83 SCHEDULE OF PREPAYMENTS PREPAID INSURANCE 508,047.31 520,364.13 PREPAYMENT PURCHASED POWER (20,482.36) 22,046.35 PREPAYMENT.PASNY 256,672.66 239,666.63 PREPAYMENT WATSON 125,844.21 119,308.71 PURCHASED POWER WORKING CAPITAL 14,523.70 14,523.70 TOTAL PREPAYMENT 884,605.52 915,909.52 ACCOUNTS RECEIVABLE AGING MAY 2011: RESIDENTIAL AND COMMERCIAL 3,209,896.38 LESS: SALES DISCOUNT LIABILITY (304,636.06) GENERAL LEDGER BALANCE 2,905,260.32 CURRENT 2,319,018.45 79.83% 30 DAYS 311,382.45 10.72% 60 DAYS 89,606.92 3.08% 90 DAYS 54,134.27 1.86% OVER 90 DAYS 131,118.23 4.51% TOTAL 2,905,260.32 100.00% (10) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REVENUE 5/31/11 SCHEDULE D MONTH MONTH LAST YEAR CURRENT YEAR YTD SALES OF ELECTRICITY: LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE RESIDENTIAL SALES 2,039,341.17 2,127,214.61 29,699,606.89 31,765,231.41 6.96% COMM AND INDUSTRIAL SALES 3,332,727.85 3,577,773.61 41,298,057.37 43,118,367.69 4.41% PRIVATE STREET LIGHTING 9,539.52 10,489.65 113,713.17 116,342.15 2.31% TOTAL PRIVATE CONSUMERS 51361,608.54 5,715,477:87 71,111,377.43 74,999,941.25 5.47% MUNICIPAL SALES: STREET LIGHTING 43,507,50 45,837.15 506,270.53 509,5OB.B4 0.64% MUNICIPAL BUILDINGS 83,206.28 85,094.92 1,093,457.37 1,118,926.43 2.33% TOTAL MUNICIPAL CONSUMERS 126,713.78 130,932.07 1,599,727.90 1,628;437.27 1,79% SALES FOR RESALE 26,753.93 23,907.42 371,576.72 392,677.44 5.66% SCHOOL 137,960.69 131,320.53 1,668,102.70 1,593,953.33 -4.45% SUB-TOTAL .5,673,036.94 6,Op1,637.89 74,750,786.75 76,615,009.29 0.08 ?ITED DISCOUNTS 61,963.02 72,044.18 789,974.97 934,577.34 18.30% PURCHASED POWER CAPACITY 529,410.04 37,591.24 4,244,356.62 1,318,688.36 -68.93% ENERGY CONSERVATION - RESIDENTIAL 6,472.37 11,216.78 113,058.57 135,206.81 19.59 ENERGY CONSERVATION - COMMERCIAL 34,738.13 23,317.80 389,151.13 324,848.21 -16.52% GAW REVENUE 0.00 50,129.95 0.00 510,743.82 100.00% PASNY CREDIT (29,674.62) (37,496.39) (481,597.59) (682,791.67) 41.78% TOTAL REVENUE 6,277,945.68 6,158,441.45 79,805,730.45 81,156,2$2.16 1.69% TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REVENUE BY TOWN 5/31/11 TOTAL, READING LYNNFIELD NO.READING WILMINGTON MONTH RESIDENTIAL 2,127,214.61 678,024.92 284,031.62 516,689.68 648,468.39 INDUS/MUNI BLDG 3,662,868.53 483,031.53 46,469.57 575,867.47 2,557,479.96 PUB.ST.LIGHTS 45,837.15 16,026.89 5,566.70 7,576.81 .16,662.75 PRV".ST.LIGHTS 10,489.65 1,977.74 195.04 3,234.63 5,082.24 CO-OP RESALE 23,907.42 23,907.42 0.00 0.00 0.00 SCHOOL 131,320.53 47,370.44 28,411.18 17,777.17 37,761.74 TOTAL 6,001,637.89. 1,250,338.94 364,696.11 1,121,147.76 3,265,455.08 THIS YEAR TO DATE RESIDENTIAL 31,765,231.41 10.;030,157.48 4,421,931.22 7,425,291.94 9,887,850.77 INDUS/MUNI BLDG 44,237,296.12 6,006,467.96 563,212.57 6,913,461.51 30,754,134.08 PUB.ST.LIGHTS 509,508.84 178,284.33 62,070.21 84,044.57 185,109.73 PRV.ST.LIGHTS 116,342.15 21,952.74 2,178.95 35,981.95 56,228.51 CO-OP RESALE 392,677.44 392,677.44 0.00 0.00 0.00 SCHOOL 1,593,953.33 566,765.36 332,874.25 214,407.65 479,906.07 TOTAL 78,615,009.29 17,196,305.31 5,382,267.18 14,673,207.63 41,363,229.17 LAST YEAR TO DATE RESIDENTIAL 29,699,606.89 . 9,379,376.69 .4,143,147.36" 6,904,722.69 9,272,360.15 INDUS/MUNI BLDG 42,391,514.74 5,670,967.30 532,889.66 6,784,225.81 29,403,431.97 PUB.ST.LIGHTS 506,270.53 175,663.95 62,470.01 83,903.06 184,233.51 PRV.ST.LIGHTS 113,713.17 21,832.14 2,177.99 35,142.52 54,560.52 CO-OP RESALE 371,578.72 371,578.72 0.00 0.00 0.00 SCHOOL" 1,668,102.70 606,694.57 .334,674.12 223,572.68 503,161.33 TOTAL 74,750,786.75 16,226,113.37 5,075,359.14 14,031,566.76 39,417,747.48 PERCENTAGE OF OPERATING INCOME TO TOTAL TOTAL READING LYNNFIELD NO.READING WILMINGTON MONTH RESIDENTIAL 35.44% 11.30% 4.73% 8.61% 10.60% IMUS/MUNI BLDG 61.03% 8.05% 0.77% 9.60% 42.61% PUB.ST.LIGHTS 0.77% 0.27% 0.09% 0.13% 0.28% PRV.ST.LIGHTS 0.17% 0.03% 0.00% 0.05% 0.099. CO-OP RESALE 0.40% 0.40% 0.00% 0.00% 0.00% SCHOOL 2.19% 0.79% 0.47% 0.30% 0.63% TOTAL, 100.00% 20.64% 6.06% 18.69% 54.41% THIS YEAR TO DATE RESIDENTIAL 40.41% 12.76% 5.62% 9.45% 12.58% INDUS/MUNI BLDG 56.27% 7.64% 0.72% 8.79% 39.12% PUB.ST.LIGHTS 0.659. 0.23% 0.08% 0.11% 0.23% PRV.ST.LIGHTS 0.15% 0.03% 0.00% 0.05% 0.07% CO-OP RESALE 0.50% 0.50% 0.009. 0.00% 0.00% SCHOOL 2.02% 0.72% 0.42% 0.27% 0.61% TOTAL 100.00% 21.88% 6.84% 18.67% 52.61% LAST YEAR TO DATE RESIDENTIAL 39.739. 12.55% 5.54% 9.24% 12.40% INDUS/MUNI BLDG 56.71% 7.59% 0.71% 9.08% 39.33% PUB.ST.LIGHTS 0.68% 0.23% 0.08% 0.11% 0.26%: PRV.ST.LIGHTS 0.15% 0.03% 0.00% 0.05% 0.07%' CO-OP RESALE 0.50% 0.50% 0.00% 0.00% 0.00% SCHOOL 2.23% 0.81% 0.45% 0.30% 0.67% TOTAL 1D0.00% 21.71% 6.78% 18.78% 52.73% (11A) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED REVENUE VARIANCE REPORT 5/31/11 SCHEDULE F ACTUAL BUDGET SALES OF ELECTRICYEAR TO DATE YEAR TO DATE VARIANCE * CHANGE ITY: RESIDENTIAL 16,180,999.59 16,186,586.00 1,994,413.59 12.32% COMM AND INDUSTRIAL SALES PRIVATE STREET LIGHTING 22,045,512.26 19,632,848.00 2,412,664.26 12.29% MUNICIPAL BUILDINGS PUBLIC STREET LIGHTING 359,736.76 492,916.00 (133,179.22) -27.02% SALES FOR RESALE 213,463.56 227,039.00 (13,575.44) -5.98% SCHOOL 629,497.01 781,271.00 48,226.01 6.17% TOTAL BASE SALES 41,629,209.20 37,320,660.00 4,308,549.20 11.54% TOTAL FUEL SALES 36,965,800.09 37,015,587.00 (29,706.91) -0.06% TOTAL OPERATING REVENUE 78,615,009.29 74,336,247.00 4,278,762.29 5.76% FORFEITED DISCOUNTS 934,577.34 621,055.00 113,522_34 13.63% PURCHASED POWER CAPACITY 1,316,688.36 4,935,24.1.00 (3,616,552.64) -73.28% ENERGY CONSERVATION - RESIDENTIAL 135,206.81 106,640.00 28,566.81 26.79% ENERGY CONSERVATION - COMMERCIAL 324,848.21 385,038.00 (60,189.79) -15.63% GAS`' REVENUE 510,743.82 270,000.00 240,743.82 89.16% PASNY CREDIT (682,791.67) (550,000.00) (132,791.67) 24.14% TOTAL OPERATING REVENUES 81,156,282.16 00,304,221.00 852,061.16 1.06% * ( ) = ACTUAL UNDER BUDGET (115) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING EXPENSES 5/31/11 SCHEDULE E MONTE MONTH LAST YEAR CURRENT YEAR YTD % OPERATION EXPENSES: LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE PURCHASED POWER BASE EXPENSE 2,198,144.27 2,100,655.69 25,226,774.99 25,181,471.63 -0.18% OPERATION SUPER AND ENGIN-TRANS 0.00 0.00 0.00 0.00 0.00% OPERATION SUP AND ENGINEERING EXP 36,541.50 33,780.07 379,850.48 412,397.65 8.57% STATION SUP LABOR AND MISC 8,650.76 9,123.52 75,381.00 100,951.73 33.92% LINE MISC LABOR AND EXPENSE 61,161.15 46,093.19 614,439.62 574,949.03 -6.43% STATION LABOR AND EXPENSE 32,755.91 34,256.19 418,295.62 410,292.82 -1.91% STREET LIGHTING EXPENSE 3,955.52 6,167.29 49,200.50 84,432.41 71.61% METER EXPENSE 23,134.56 17,363.04 346,533.32 283,699.00 -18.13% MISC DISTRIBUTION EXPENSE 24,656.85 27,134.05 292,709.37 300,667.52 2.72% METER READING LABOR & EXPENSE 4,604.65 5,204.40 64,020.58 65,118.12 1.71% ACCT & COLL LABOR & EXPENSE 122,926.29 100,564.06 1,241,395.06 1,166,946.25 -6.00% UNCOLLECTIBLE ACCOUNTS 12,500.00 15,000.00 137,992.92 165,000.00 19.57% ENERGY AUDIT EXPENSE (547.83) 36,191.41 3B0,711.64 353,584.74 -7.13% ADMIN & GEN SZJ-ARIES 54,866.88 51,528:69 692,516.82 637,396.00 -7.96% OFFICE SUPPLIES & EXPENSE 27,174.24 26,749.47 251,978,.08 249,893.47 -0.83% OUTSIDE SERVICES 56,530.91 41,407.88 281,078.56 239,348.53 -14.85% PROPERTY INSURANCE 30,773.24 31,705.39 344,002.85 342,888.27 -0.32% INJURIES AND DAMAGES 4,467.18 2,671.18 52,310.87 40,433.57 -22.71% EMPLOYEES PENSIONS & BENEFITS 57,224.65 99,279.08 1,097;768.76 1,440,789.06 31.25% MISC GENERAL EXPENSE 10,016.28 7,514.38 139,823.82 146,943.21 5.09% RENT EXPENSE 14,067.59 14,644.67 176,588.46 184,637.59 4.56% ENERGY CONSERVATION 58,452.40 19,211.48 341,519.67 574,158.42 66.12% TOTAL OPERATION EXPENSES 645 914.73 625 589.44 7,376,118.00 7 779 527.39 5.37% MAINTENANCE EXPENSES: MAINT OF TRANSMISSION PLANT 227.08 227.08 2,497.90 2,497.92 0.06' MAINT OF STRUCT AND EQUIPMT 22,012.49 12,424.35 105,929.73 148,965..76 40.63% M7= OF LINES - OR 108,669.75 123,706.48 1,087,068.11 1,268,619.79 16.70% MAINT OF LINES - UG 11,840.35 19,538.64 163,324.11 147,199.32 -9.87% MART OF LINE TRANSFORMERS ** 58,742.93 18,346.01 722,831.04 1,335,288.65 84.73% MAINT OF ST IT & SIG SYSTEM (18.29) (33.26) (86.85) (1.62.35) 86.93% MAINT OF GARAGE AND STOCKROOM 46,761.05 37,940.20 461,536.18 560,785.91 21.50% M&= OF METERS 0.00 7,901.38 531.31 29,566.24 5464.78% MPSNT OF GEN PLANT 7,282.70 8,290.89 85,183.95 99,263.83 16.53% TOTAL MAINTENANCE EXPENSES 255.518.06 226,341.75 2,628,615.48 3,592,025.07 36.64% DEPRECIATION EXPENSE 280,105.78 287,729.05 3,061,163.58 3,165,019.55 2.72% PURCHASED POWER FUEL EXPENSE 3,058,960.72 3,015,861.75 36,755,984.99 36,336,953.37 -1.14% VOLUNTARY PAYMENTS TO TOWNS 104,500.00 110,000.00 1,149,246.00 1,205,885.00 4.93% TOTAL OPERATING EXPENSES 6.543,143.56 6,366,177.68 76,220,103.04 77.255,862.01 1.36% ** FY 11 YTD total includes G&W soil remediation expenses totalling $1,279,713.49 Total costs to date for entire project is $2,376,145.29. (12) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED OPERATING EXPENSE VARIANCE REPORT 5/31/11 SCHEDULE G ACTUAL BUDGET OPERATION EXPENSES: YEAR TO DATE YEAR TO DATE VARIANCE * CHANGE PURCHASED POWER BASE EXPENSE 25,181,471.63 25,413,447.00 (.231,975.37) -0.91% OPERATION SUPER AND ENGIN-TRANS 0.00 0.00 0.00 0..00% OPERATION SUP AND ENGINEERING EXP 412,397.65 400,141.00 12,256.65 3.060 STATION SUP LABOR AND MISC 100,951.73 76,672.00 24,279.73 31.67% LINE MISC LABOR AND EXPENSE 574,949.03 487,444.00 87,505.03 17.95% STATION LABOR AND EXPENSE 410,292.62 386,616.00 23,676.82 6.12% STREET LIGHTING EXPENSE 64,432.41 60,535.00 23,897.41 39.48% METER EXPENSE 283,699.00 437,564.00 (153,865.00) -35.16% " MISC DISTRIBUTION EXPENSE 300,667.52 313,994.00 (13,326.48) -4.24% METER READING LABOR & EXPENSE 65,118.12 58,316.00 6,802.12 11.66% ACCT & COLL LABOR & EXPENSE 1,166,946.25 1,270,162.00 (103,215.75) -8.13% UNCOLLECTIBLE ACCOUNTS 165,000.00 165,000.00 0.00 0.00% ENERGY AUDIT EXPENSE 353,584.74. 438,148.00 (64,563.26) -19.30% ADMIN & GEN SALARIES 637,396.00 701,593.00 (64,197.00) -9.15% OFFICE SUPPLIES & EXPENSE 249,893.47 255,009.00 (5,115.53) -2.01%' OUTSIDE SERVICES 239,348.53 274,734.00 (35,385.47) -12.88% PROPERTY INSURANCE 342,888.27 436,933.00 (96,044.73) -21.BB% INJURIES AM DAMAGES 40,433.57 59,443.00 (19,009.43) -31.98% EMPLOYEES PENSIONS & BENEFITS 1,440,789.06 1,102,513.00 338,276.06 30.68% MISC GENERAL EXPENSE 146,943.21 203,301.00 (56,357.79) -27.72% RENT EXPENSE 184,637.59 194,337.00 (9,699.41) -4.99% ENERGY CONSERVATION 574,158.42 585,786.00 (11,627.58) -1.980 TOTAL OPERATION EXPENSES 7,774,527.39 7,910,241.00 (135,713.61) -1.720 MAINTENANCE EXPENSES: MRINT OF TRANSMISSION PLANT 2,497.92 2,750.00 (252.08) -9.17% MA-= OF STRUCT AND EQUIPMENT 148,965.76 168,656.00 (19,690.24) -11.67% MAINT OF LINES - OH 1,266,619.79 1,065,468.00 203,151.79 19.07% MAINT OF LINES - UG 147,199.32 174,220.00 (27,020.68) -15.51% M&INr OF LINE TRANSFORMERS ** 1,335,288.65 688,212.00 647,076.65 94.02% MAINT OF ST IT & SIG SYSTEM (162.35) 8,043.00 % MAINT OF GARA&M AND STOCKROOM 560,785.91 626,564.00 (8,205.35) --10.02% (65,778.09) -10.500 MAINT OF METERS 29,566.24 3,514.00 26,052.24 741.38% MA,TNT OF GEN PLANT 99,263.83 121,000.00 (21,736.17) -17.96% TOTAL MAINTENANCE EXPENSES 3,592,025.07 2,858,427.00 733.596.07 .25.66% DEPRECIATION EXPENSE 3,165,019.55 3,208,337.00 (43,317.45) -1.35% PURCHASED POWER FUEL EXPENSE 36,336,953.37 36,658,915.00 (321,961.63) -0.88% VOLUNTARY PAYMENTS TO TOWNS 1,205,885.00 1,210,000.00 (4,115.00) -0.34% TOTAL OPERATING EXPENSES 77,255,882.01 77,259,367.00 (3,484.99) 0.00% * ( ) = ACTUAL UNDER BUDGET ** FY 11 YTD total includes GAW soil remediation expenses totalling $1,279,713.49 Total costs to date for entire -project is $2,376,145.29. i (12A) TOWN OF READING; MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED OPERATING EXPENSE VARIANCE REPORT 5/31/11 RESPONSIBLE REMAINING SENIOR 2011 ACTUAL BUDGET REMAINING OPERATION EXPENSES: MANAGER ANNUAL BUDGET YEAR TO DATE BALANCE BUDGET PURCHASED POWER BASE EXPENSE JP 27,711,514.00 25,181,471.63 2,530,102.37 9.13% OPERATION SUPER AND ENGIN-TRANS KS 0.00 0.00 0.00 0.00% OPERATION SUP AND ENGINEERING EXP KS 441,828.00 412,397.65 29,430.35 6.66% STATION SUP LABOR AND MISC KS 85,205.00 100,951.73 (15,746.73) -18.48% LINE MISC LABOR AND EXPENSE KS 520,806.00 574,949.03 (54,143.03) 10.40% STATION LABOR AND EXPENSE KS 426,438.00 410,292.62 16,145.18 3.79% STREET LIGHTING EXPENSE KS 66,694.00 84,432.41 (17,736.41) -26.60% METER EXPENSE DA 482,771.00 263,699.00 199,072.00 41.24% MISC DISTRIBUTION EXPENSE JD 347,115.00 300,667.52 46,447.48 13.38% METER READING LABOR & EXPENSE DA 64,358.00 65,118.12 (760.12) -1.18% ACCT & COLL LABOR & EXPENSE RF 1,397,984.00 1,166,946.25 231,037.75 16.53% UNCOLLECTIBLE ACCOUNTS RF 180,000.00 165,000.00 15,000.00 8.33% ENERGY AUDIT EXPENSE, JP 494,776.00 353,584.74 141,191.26 28.54% ADS & GEN SALARIES VC 776,849.00 637,396.00 139,453.00 17.95% OFFICE SUPPLIES & EXPENSE VC 278,100.00 249,893.47 28,206.53 10.14% OUTSIDE SERVICES VC 293,500.00 239,348.53 54,151.47 18.45% PROPERTY INSURANCE JD 478,900.00 342,888.27 136,011.73 28.40% INJURIES AND DAMAGES JD 64,805.00 40,433.57 24,371.43 37.61% EMPLOYEES PENSIONS & BENEFITS JD 1,188,607.00 1,440,789.06 (252,182.06) -21.22% 1,11SC GENERAL EXPENSE VC 212,096.00 146,943.21 65,152,79 30.72% RENT EXPENSE JD 212,000.00 184,637.59 27,362.41 12.91% ENERGY CONSERVATION JP 643,,730.00 574,158.42 69,571•.58 10.81% TOTAL OPERATION EXPENSES 6;656,562.00 7,774,527.39 862,034.61 10.19% bM.INTENANCE EXPENSES MAINT OF TRANSMISSION PLANT KS 3,000.00 2,497.92 502.08 16.74% MAINT OF STRUCT AND EQUIPMT KS 187,404.00 148,965.76 38,438.24 20.51% MAINT OF LINES - OH KS 1,199,735.00 1,268,619.79 (66,884.79) -5.74% MRINT OF LINES- UG KS 190,256.00 147,199.32 43,058.68 22.63% MAINT OF LINE TRANSFORMERS ** KS 693,500.00 1,335,288.65 (541,788.65) -92.54% MAINT OF ST LT & SIG SYSTEM JD 8,857.00 (162.35) 9,019.35 101.83% MAINT OF GARAGE AND STOCKROOM JD 676,532.00 560,785.91 115,746.09 17.11% MAINT OF METERS DA 3,875.00 29,566.24 (25,691.24) -663.00% bD= OF GEN PLANT RF 132,000.00 99,263.83 32,736.17 24.80% TOTAL MAINTENANCE EXPENSES. 3,095,161.00 3,592,025.07 (496,864.07) -16.05% DEPRECIATION EXPENSE RF 3,500,000.00 3,165,019.55 334,980.45 9.57% PURCHASED POWER FUEL EXPENSE JP 39,512,664.00 36,336,953.37 3,175,710.63 8.04% VOLUNTARY PAYMENTS TO TOWNS RF 1,320,000.00 1,205,865.00 114,115.00 6.65% TOTAL OPERATING EXPENSES 63,795,961.00 77,255,882.01 6,540,078.99 7.80% ** FY 11 YTD total includes GAW soil remediation expenses totalling $1,279,713.49 Total costs to date for entire project is $2,376,145.29. (126) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT PROFESSIONAL SERVICES 5/31/2011 PROFESSIONAL SERVICES BY PROJECT ITEM DEPARTMENT ACTUAL BUDGET VARIANCE 1 RMLD AND PENSION TRUST AUDIT FEES ACCOUNTING 31,750.00 36,000.00 (4,250.00) 2 PENSION ACTUARIAL EVALUATION ACCOUNTING 6,000.00 1,000.00 5,000.00 3 LEGAL- FERC/ISO ISSUES ENERGY SERVICE 0.00 16,500.00 (16,500.00) 4 LEGAL- POWER SUPPLY ISSUES ENERGY SERVICE 49,437.71 44,000.00 5,437.71 5 PROFESSIONAL SERVICES ENERGY SERVICE 0.00 27,500.00 (27,500.00) 6 NERC COMPLIANCE E & O 8,812.50 6,675.00 1,937.50 7 ENGINEERING STUDIES ENGINEERING 0.00 15,000.00 (15;000.00) 8 LEGAL SERVICES- GENERAL GM 131,399.25 45,837.00 65,562.25 9 LEGALSERVICES- ARBITRATION HR 3,625.59 16,000.00 (12,374.41) 10 LEGAL GENERAL HR 3,726.46 38,500..0.0 (34,773.54) 11 LEGAL GENERAL BLDG. MAINT. 0.00 1,375.00 (1,375.00) SURVEY RIGHT OF WAY BLDG. MAINT. 0.00 4,587.00 (4,587.00) s ENVIRONMENTAL BLDG. MAINT. 1,472.00 4,587.00 (3,115.00) 14 ENGINEERING SERVICES BLDG. MAINT. 0.00 7,810.00 (7,810.00) 15 INSURANCE CONSULTANT GEN. BENEFIT 3,125.02 9,163.00 (61037.96) TOTAL 239,348.53 274,734.00 (35,385.47) PROFESSIONAL SERVICES BY VENDOR ACTUAL MELANTSON HEATH & COMPANY PC 56,798.03 RUBIN AND RUDMAN 131,067.68 DUNCAN AND ALLEN 23,571.25 WILLIAM F CROWLEY ATTORNEY 650.00 CHOATE HALL AND STEWART 7,152.05 UTILITY SERVICES INC. 8,812.50 AMERICAN ARBITRATION ASSOCIATION 200.00 COVINO ENVIRONMENTAL ASSOCIATES 1,472.00 ROMAREE INSURANCE 3,125.02 FIG LEAF SOFTWARE INC 500.00 STONE CONSULTING INC. 6,000.00 TOTAL 239,348.53 (13) 6/22/2011 RMLD 1:40 PM BUDGET VARIANCE REPORT FOR PERIOD ENDING MAY 31, 2011 DIVISIONS AND DEPARTMENTS ACTUAL BUDGET VARIANCE CHANGE ENGINEERING AND OPERATIONS: E&O MGR 183,367 163,861 (514) -0.280 ENGINEERING 413,158 416,051 (2,893) -0.70% LINE 2,077,702 1,798,688 279,014 15.51% METER READING 65,118 58,319 6,800 11.66% METER TECHNICIANS 284,444 437,794 (153,350) -35.03% STATION OP 511,245 463,289 47,956 10.350 STATION TECHS 1,513,821 860,846 652,975 75.85% DIVISION TOTAL 5,048,854 4218 867 629,987 19.670 ENERGY SERVICES DIVISION TOTAL 977,129 1,112,381 (135 252) -12.16% GENERAL MANAGER: GENERAL MANAGER 401,584 332,119 69,465 20..92% HUMAN RESOURCES 106,379 188,557 (62,178) -43.58% COMMUNITY RELATIONS 134,451 165,622 (31,371) -18.92% CAB 4,553 13,689 (9,136) -66.74% BOARD 3,664 7,375 (3,711) -50.31% DIVISION TOTAL 650,631 707,561 (56,930) -8.050 FACILITY MANAGER; GENERAL BENEFITS 2,072,577 1,894,440 176,136 9.40% BUILDING MAINTENANCE 562,333 644,922 (82,589) -12.81% MATERIALS MANAGEMENT 300,937 315,370 (14,433) -4.58% DIVISION TOTAL 2,925,846 2 854 732 81,114 2.84% BUSINESS DIVISION: ACCOUNTING 669,463 705,526 (36,063) -5.11% CUSTOMER SERVICE 546,351 602,856 (56,505) -9.37% MES 506,508 531,729 (25,221) -4.7496 MISCELLANEOUS DEDUCTIONS 6,406,876 6,458,082 (51,206) -0.79% DIVISION TOTAL 8,129,198 8,298,192 (168,994) =2.04% DIVISION TOTALS 17,741,659 17,191,734 549,926 3.20% PURCHASED POWER-BASE 25,181.,472 25,413,447 (231,975) -0.91% PURCHASED POWER - FUEL 36,336,953 36,658,915 (321,962) -0.88% TOTAL, 79,260 ,OB4 79,264,096 (4,011) -0.01% RMLD DEFERRED FUEL CASH RESERVE ANALYSIS 5/31/11 GROSS MONTHLY TOTAL DATE CHARGES REVENUES PASNY CREDIT DEFERRED DEFERRED Jun-10 2,326,112.09 Jul-10 4,555,108.56 3,536,618.90 (96,501.74) (1,116,991.40) 1,209,120.69 Aug-10 4,151,671.47 3,658,721.48 (49,929.96) (543,079.95) 666,040.74 Sep-10 3,437,061.39 4,007,231.89 (52,662.99) 517,467.51 1,183,528.25 Oct-10 2,586,224.15 3,632,658.99 (62,298.35) 984,336.49 2,167,864,74 Nov-10 2,717,341.26 3,468,972.22 (32,335.11) 719,295.85 2,867,160.59 Dec-10 3,562,794.01 3,213,632.76 (71,724.91) (440,686.16) 2,446,474.43 Jan-11 3,620,614.67 3,629,698.16 (59,937.36) (51,053.87) 2,395,420.56 Feb-11 2,983,759.61 3,153,393.61 (92,678.30) 76,955.70 2,472,376.26 Mar-11 2,937,424.70 2,992,700.15 (92,444.57) (37,169.12) 2,435,207.14 Apr-11 2,748,671.80 3,010,590.83 (32,781.99) 229,137.04 2,664,344.18 May-11 3,015,861.75 2,661,181.10 (37,496.39) (372,177.04) 2,292,167.14 Rn�D STAFFING REPORT FOR FISCAL YEAR ENDING JUNE, 2011 ACTUAL 11 BUD JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY TOTAL 10 10 10 10 10 10 11 11 11 11 11 GENERAL MANAGEF2 GENERAL MANAGER 2 2 2 2 2 2 2 2 2 2 2 2 HUMAN RESOURCES * 1.5 1 1 1 1 1 1 1 1 1 1 1 COWUNITY RELATIONS 1.5 1 1 1 1 1 1 1 1 1 1 1 TOTAL, 5 4 4 4 4 4 4 4 4 4 4 4 BUSINESS ACCOUNTING * 1.80 1.80 1.80 1.60 1.80 1.80 1.80 1.80 1.80 1.80 1.80 1.80 CUSTOMER SERVICE * 8.75 7.75 7.75 7..75 7.75 7.75 7.75 7.75 6.75 6.75 6.75 5.75 MGMT INFORMATION SYS * 5.25 5.25 5.25 5.25 5.25 5.25 5.25 5.25 5.25 5.25 5.25 5.25 MISCELLANEOUS 1 1 1 1 1 1 1 1 1 1 1 1 TOTAL 16.80 15.80 15.80 15.80 15.80 15.80 15.80 15.80 14.80 14.80 14.80 13.80 ENGINEERING & OPERATIONS AGM E&O 2 2 2 2 2 2 2 2 2 2 2 2 ENGINEERING 5 5 5 5 5 5 5 5 5 5 5 5 LINE 20 19 19 19 19 19 19 19 20 20 20 20 METER 6 6 6 6 6 6 6 6 6 5 5 5 STATION 9 9 9 9 9 9 9 9 9 8 8 6 TOTAL 42 41 41 41 41 41 41 41 42 40 40 40 PROJECT BUILDING 2 2 2 2 2 2 .2 2 2 2 2 GENERAL BENEFITS 2 2 2 2 2 2 2 2 2 2 2 TRANSPORTATION 0 0 0 0 0 0 0 0 0 0 0 MATERIALS MGMT 4 4 4 4 4 4 4 4 4 4 4 TOTAL 8 8 6 8 8 8 8 8 8 8 8 8 ENERGY SERVICES ENERGY SERVICES *# 5.5 5.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 5.5 TOTAL 5.5 5.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 5.5 RMLD TOTAL 77.3 74.3 73.3 73.3 73.3 73.3 73.3 73.3 73.3 71.3 71.3 71.3 CONTRACTORS UG LINE 2 2 2 2 2 2 2 2 2 2 2 2 TOTAL 2 2 2 2 2 2 2 2 2 2 2 2 GRAND TOTAL 79.3 76.3 75.3 75.3 75.3 75.3 75.3 75.3 75.3 73.3 73.3 73.3 *part time employee *#pact time employee and a coop student Attachment 4 To: Vincent Cameron From: Energy Services Date: June 17, 2011 Subject: Purchase Power Summary—May,2011 Energy Services Division (ESI, ) has completed the Purchase Power Summary for the month of May, 2011. ENERGY The RMLD's total metered load for the month was 57,661,057 kWh, which was a decrease of 2.28 % compared to May, 2010 figures. Table 1 is a breakdown by source of the energy purchases. TABLE 1 .Amount of Cost of %of Total Total$ $as a Resource Energy Energy Energy Costs % (kWh) ($/Mwh) Millstone#3 3,704,713 $5.54 6.42% $20,522 0.68% Seabrook 1,384,647 $8.86 2.40% $12,265 0.41% JP Morgan 3,434,400 $52.68 5.95% $180,918 6.00% Stonybrook CC 996,965 $58.66 1.73% $58,486 1.94% Constellation 7,440,000 $61.60 12.89%. $458,269 15.20% NYPA 1,999,608 $4.92 3.46% $9,838 0.33% ISO interchange 13,957,515 $43.43 24.17% $606,125 20.10% NEMA Congestion 0 $0.00 0.00% -$17,483 -0.58% Coop Resales 80,644 $131.98 0.14% $10,644 0.35% Stonybrook Peaking 0 $0.00 0.00% $8 0.00% MacQuarie 21,885,400 $64.39 37.90% $1,409,119 46.72% Braintree Watson Unit 302,650 $76.95 0.52% $23,290 0.77% Swift River Projects 2,553,136 $95.51 4.42% $243,862 8.09% Monthly Total 57,739,678 $52.23 100.00% $3,015,862 100.00% Table 2 Amount Cost % of Total Resource of Energy of Energy Energy (kWh) ($/Mwh) ISO DA LMP* 15,293,988 44.62 26.49% Settlement RT Net Energy** -1,336,473 57.08 -2.31% Settlement ISO Interchange 13,957,515 43.43 24.17% (subtotal) Table 2 breaks down the ISO interchange between the DA LMP Settlement and the RT Net Energy for month of May, 2011. CAPACITY The RMLD hit a demand of 121,532 kWs, which occurred on May 27,2011 at 4 pm. The RMLD's monthly UCAP requirement for May, 2011 was 212,960 kWs. Table 3 shows the sources of capacity that the RMLD utilized to meet its requirement. Table 3 Source Amount(kWs) Cost($/kW-month) Total Cost$ %of Total Cost Millstone#3 4,991 $62.12 $310,058 20.34% Seabrook 7,902 $56.65 $447,628 29.36% Stonybrook Peaking 24,981 $1.97 $49,334 3.24% Stonybrook CC 42,925 $3.27 `$140,474 9.21% NYPA 0 $2.96 $11,896 0.78% Hydro Quebec 6,570 $3.59 $23,555 1.54% ISO-NE Supply Auction 115,071 $3.70 $426,024 27.94% Braintree Watson Unit 10,520 $11.00 $115,673 7.59% Total 212,960 $7.16 $1,524,643 100.00% *ISO DA LMP: Independent System Operator Day-Ahead Locational Marginal Price **RT Net Energy: Real-Time Net Energy Table 4 Resource Energy Capacity Total cost %of Total Cost Millstone#3 $20,522 $310,058 $330,580 7.28% Seabrook $12,265 $447,628 $459,894 10.13% Stonybrook CC $58,486 $140,474 $198,961 4.38% Hydro Quebec $0 $23,555 $23,555 0.52% Constellation $458,269 $0 $458,269 10.09% NYPA $9,838 $11,896 $21,734 0.48% ISO Interchange $606,125 $426,024 $1,032,149 22.73% NEMA Congestion -$17,483 $0 -$17,483 -0.39% Coop Resales $10,644 $0 $10,644 0.23% Stonybrook Peaking $8 $49,334 $49,342 1.09% JP Morgan $180,918 $0 $180,918 3.98% MacQuarie $1,409,119 $0 $1,409,119 31.03% Braintree Watson Unit $23,290 $115,673 $138,963 3.06% Swift River Projects $243,862 $0 $243,862 5.37% Monthly Total $3,015,862 $1,524,643 $4,540,504 100.00% Table 4 shows the total dollar amounts for energy and capacity per source. TRANSMISSION The RMLD's total transmission costs for the month of May, 2011 are $574,627. This is a decrease of 7.39% from the March 2011 cost of$620,461. In 2010,the transmission costs for the month of May, 2010 were $540,275. Table 5 Current Month Last Month Last Year Peak Demand(kW) 121,532 92,584 150,886 Energy(kWh) 57,739,678 53,431,859 59,563,301 Energy($) $3,015,862 $2,748,672 $3,058,961 Capacity($) $1,524,643 $1,616,704 $1,655,184 Transmission($) $574,627 $620,461 $540,275 Total $5,115,132 $4,985,837 $5,254,420 Table 5 shows the current month vs. last month and last year(May, 2010). C;) 0 0 c c c •L _L •L Q L C 0 Q U N L c E a) L N U) U L L L 2 (n c to C c c N m a) a) N 0 a) a) N C C N N N N N m 0 C' N U) a asaaa a'ca 'ca a aaaa a o 'm a UUUUUUUUUZ UUww Z UUw °r m m � p p C 0000000Or r Q 0000000rr Q o r o 0 o r r o 0 0 0 o r r r r w+ C U 0 0 Q) C C � t6 � U ,000Mt``'i (` M O -5 O D D O G O 0 O O O O O O. U CQj d m CL 0000000 Q- 0000000 0 E 000000000 °° E 0000000mo Q r r r r r r r 0 0 Q r r r r r r r 0 r .. U V I c d d 0 0 0 0 0 0 0 0 0 twC 0000 N00000 .w OOO ,00 `OOO ` O` � ;+ O O O O p 0 0 0 p N r M I,- r r 0 r t0 V p ' .a ' 0 TAU p NO Z: — h Or G) t CD � a) m a3 m a) m � CO m i w m N N 0 •0 m U- J:) is O000000t- o L N (n CL a� c� a) E cc Y t m -0 Q- a) a)_ � � � � a) a) � 0 � CLo m � CoomaEiaEi Nc' 0 o m $ 0 m m m 3 G C 0 a) 0- c o U = v •,` c c -I UU UUQm E N U) 0� a`) c � o � '� � w co � 000o L W E c tLmUF- Cn (D r � rrrr Q.N 0- - F- c c c c C L = L L L L C U L. tU a o 0 0 0 0 65 0 c 0 0 0 a> L m .� H 5 0-W 0 0 n 0 L) a� (D E �_ E E E aa) H •a N C C Lc i i .c W U o o 0 o 0 L Q df U 0 .0 N cn U N in in 0 c C c c c ° a _ c c c c c c C cm Lo a3 m m cu '- a) to c) U) C) UUUU t� � Ft � f� F�- F�- F- CoILL U f � � � U 69- < rL y S. **O LM !,/ T Q) L / t4 pcl Lm H Y k � _ � CO h- CO U-) d- M N O suoill1w ut sielloa o• (� N C'7LL 1` N F _ CD u a x M C�1 CC} CD CD / W m W W Cc im V C0 O r O LO CO LO O O ti dt co to CDCa co t- O O LO CO In oD O tt O O d• d L'ul oo I — — O 1` M r- M O M O O w CL L G( yCO O � rCd I ✓1 C6 06 75 \ `, / CD O O O (O N r LO LO O o Us) O sr cfl ►n .�., M McOtet- mU') mmd � McoM r E O M M d• N r N T- N r- U-) O O N w ,CD N O O O N O 0 0 0 0 0 0 0 O ------ ---- -------------------- --------------- .— L�/+ 00 C) O r 0 O O Ir- CD e- N�V N N N N ,cn s E E N E >, >, E S= .r.+ C Co L Q C6 i =- 2) L O. O O (D O a- o '� � d. O � 'Cn O cn F N CU W O CoCN co W O co Co O cu .S1 JCU - () J LLl -0 CU O O -0 coto c H d to : D cn � !� N c� IL) V c�a o o73o o o o 0 0 LL U a. A L U arKLL Q a 6/22/2011 READING MUNICIPAL LIGHT DEPARTMENT 12:19 PM FY 11 CAPITAL BUDGET VARIANCE REPORT FOR PERIOD ENDING MAY 31,2011 ACTUAL YTD ACTUAL ANNUAL COST COST BUDGET # PROJECT DESCRIPTION TOWN MAY THRU 5131/11 AMOUNT VARIANCE E&O Construction-System Proiects 1 4W14 Reconductoring-West Street W 486 81,980 234,470 152,490 2 4W14 Extension-Woburn Street W 18,363 36,892 157,958 121,066 ** 3 Station#4 Getaway 4W17 Replacements(FY10 Budget) R 157,877 169,928 12,051 ** 4 Boutwell Street W 96,215 125,955 29,740 `* 5 Chestnut Street W 19,862 123,519 171,933 48,414 ** 6 Haverhill Street-Reconductoring(FY10 Budget) R 143 102,718 100,534 (2,184) ** 7 URD Completions-Perkins Farm-Lynnfield NR,L 45,068 72,484 .27,416 and Chestnut Village,North Reading(FY10 Budget) ** 8 Salem St.to Glen Rd. 13kV Feeder Tie(FY10 Budget) W 11,531 11,334 (197) ** 22 Wilmington-Main Street(FY10 Budget) W 30,834 34,975 4,141 33 4W4 Reconductoring(formerly Project 3) W 103,315 103,315 36 3W8 Salem Street&Baystate Road(formerly Project 6) R 14,110 176,667 207,439 30,772 ** 37 Elm Street(Formerly Project 7) NR 155,262 132,011 (23,251) Station Unarades Station#4 ** 38 11 5k Insulator Replacement (formerly Project 8) R 68,058 144,323 76,265 9 11 5k Disconnect Replacement R 7,016 87,975 80,959 11 Transformer Replacement Part 1 -Contractual Labor R 340,235 545,500 205,265 Part 2-Procured Equipment R 7,162 30,000 22,838 Part 3-RMLD Labor R 104,584 64,324 (40,260) Part 4-Feeder Re-Assignment R 47,627 236,034 188,407 Station#5 ** 23 15kV Circuit Breaker Replacement(Carryover FY10 Bud) W 125,552 158,731 33,179 New Customer Service Connections 12 Service Installations-Commercial/Industrial Customers ALL 66,279 55,055 (11,224) ` 13 Service Installations O/H&U/G-Residential Customers ALL 20,682 184,668 200,345 15,677 14 Routine Construction Various Routine Construction ALL 103,381 936,423 982,565 46,142 Total Construction Projects 177,028 2,906,166 4,027,188 1,121,021 Other Projects 15 GIS 4,313 16,438 20,000 3,562 16 Transformers/Capacitors Annual Purchases 8,579 281,715 190,167 (91,548) 17 Meter Annual Purchases 246,314 765,875 519,561 18 Purchase Two New Small Vehicles 45,107 64,000 18,893 19 Replace Line Department Vehicles 349,279 360,000 10,721 20 Purchase Pole Trailer 15,000 15,000 21 Upgrade Lighting Stockroom and Meter Room 3,798 22,400 18,602 24 Enlarge Parking Area and Construct Island 10,775 10,775 27 Hardware Upgrades 7,742 9,152 33,700 24,548 28 Software and Licensing 3,648 96,476 92,828 29 Chiller Replacement 131,008 (131,008) Total Other Projects 20,633 1,086,459 1,578,393 491,934 TOTAL RMLD CAPITAL PROJECT EXPENDITURES 197,661 3,992,625 5,605,581 1,612,956 29 Force Account/Reimbursable Projects ALL - - TOTAL FY 11 CAPITAL PROJECT EXPENDITURES197,661 3,992,625 5,605,581 1,612,956 ** completed projects Reading Municipal Light Department Engineering and Operations Monthly Report May, 2011 FY 2099 Capital Plan E&O Construction — System Projects 1. 4W14 Reconductoring —West Street—Wilmington — Underground work and stock. 2. 4W14 Extension —Woburn Street- Wilmington — Transfer transformer, secondary cable, two services and fiber optic, replace cross arms transfer lateral, wired gang- operated switch. 3. Station #4 Getaway 4W17 Replacements — Reading (FY10 Budget) — Project complete 4. Boutwell Street—Wilmington — Project complete. 5. Chestnut'Street—Wilmington Make-ready work for pole transfers; pole transfers; installed underground splice to extend up to new pole; framed for secondary transfers. 6. Haverhill Street— Reading — Reconductoring - (FY10 Budget) — Project complete. 7. URD Completions — Project complete. 8. Salem Street to Glen Road 13 kV Feeder Tie —Wilmington —(FY10 Budget)— Project complete. 22. Wilmington — Main Street (FY 10 Budget) Project complete. 33. 4W4 Reconductoring — Wilmington — No activity. 36. 3W8 Salem & Bay State Road— Reading — Installed gang-operated switch, converted load to new circuit; transferred secondary, engineering labor; transferred riser pole to new spacer cable; connected new taps to new spacer cable; and transferred primary. 37. Elm Street— North Reading — Project complete. Substation Upgrade Proiects 38. 115kV Insulator Replacement— Station 4— Reading — Project complete. 8. 11 5k Disconnect Replacement— Station 4— Reading — No activity. 1 11. Transformer Replacement— Station 4 — Reading — No activity. Part 1 — Contractual Labor— Part 2 — Procured Equipment— Part 3 — RMLD Labor— Senior Tech labor Part 4 — Feeder Re-Assignment— 23. 15kV Circuit Breaker Replacement — Project complete. New Customer Service Connections 92. Service installations — Commercial/Industrial Customers—This item includes new service connections, upgrades, and service replacements for the commercial and industrial customers. This represents the time and materials associated with the replacement of an existing or installation of a new overhead service, the connection of an underground service, etc. This does not include the time and materials associated with pole replacements/installations, transformer replacement/installations, primary or secondary cable replacement/installations etc. This portion of the project comes under routine construction. Note: No commercial services this month. 13. Service Installations — Residential Customers—This item includes new or upgraded overhead and underground services, temporary overhead services, and large underground development. 14. Routine Construction—The drivers of the Routine Construction budget category YTD are listed. This is not an inclusive list of all items within this category. Note: These numbers are preliminafy. Pole SettinglTransfers $200,920 Maintenance Overhead/Underground $321,294 Projects Assigned as Required $55,895 Pole Damage (includes knockdowns) some reimbursable $59,290 Station Group $9,740 Hazmat/Oil Spills $0 Porcelain Cutout Replacement Program $27,576 Lighting Street Light Connections $36,895 Storm Trouble $9,957 Underground Subdivisions $51,724 Animal Guard Installation $4,067 Miscellaneous Capital Costs $250,735 TOTAL $1,028,093 *In the month of May, 19 cutouts were charged under this program. Approximately 22 cutouts were installed new or replaced because of damage making a total of 41 cutouts replaced this month. 2 Reliability Report Two key industry standard metrics have been identified to enable the RMLD to measure and track system reliability. A rolling 12-month view is being used for the purposes of this report. Customer Average Interruption Duration Index (CAIDI) — Measures how quickly the RMLD restores power to customers when their power goes out. CAIDI = Total of Customer Interruption Duration for the Month in Minutes/Total number of customers interrupted. RMLD 12 month system average outage duration —46.23 minutes RMLD 4 year average outage (2006-2009) — 50.98 minutes per outage On average, RMLD customers that experience an outage are restored in 46.23 minutes. 80.00 70.66 70.00 60.00 54.9 54.69 56.31 50.00 40.00 35.7 30.00 25: 1 ` p 20.00 N 10.00 U 0.00 _—:--Monthly minutes per outage - - RMLD 12 month system average outage duration 46.23 RMLD 4 year average outage duration 50.98 (2006-2009) t` 3 System Average Interruption Frequency (SAIFI) — Measures how many outages each customer experiences per year on average. SAIFI =Total number of customer's interrupted /Total number of customers. RMLD 12 month system average - .49 outages per year RMLD 4 year average outage frequency- .82 The graph below tracks the month-by-month SAIFI performance. 1.20 1.12 1.13 1.00 'Zi 0.80 C 0.54 0 0.60 0 0.40 - - - "035 - - --- - - - -- � 20 0.25 LL 0.20 0.00 N(j NS) NIZ) �1Z, � �^Al --0 RMLD monthly outage frequency — - - RMLD 12 month system average outage frequency .49 RMLD 4 year average outage frequency .82(2006-2009) Months Between Interruptions (MBTI) Another view of the SAIFI data is the number of months Reading customers have no interruptions. At this time, the average RMLD customer experiences an outage every 24 months. 4 RM/��� Reading Municipal Light Department RELIABLE POWER FOR GENERATIONS 230 Ash street P.O.Box lso Attachment 5 Reading,MA 01867-0250 Tel:(781)944-1340 Fax:(781)942-2409 Web:www.rmld.com June 14, 2011 Town of Reading Municipal Light Board Subject: Surplus Watt-Hour Meters On March 12, 2011 a bid invitation was placed as a legal notice in the Reading Chronicle requesting proposals for Surplus Watt-Hour Meters for the Reading Municipal Light Department An invitation to bid was emailed to the following: Austin International Hialeah Meter Company Reynolds Metering Services Texas Meter&Device Co. Meter Technical Services,Inc US Blster Solutions TD Surplus,Inc. Scrap Safe,Inc. TDI(Transformer Decommissioning,Inc.)Division of VPG,Inca Bids were received from TD Surplus, Inc. and TDI(Transformer Decommissioning,Inc.) Division of VPG,Inc. The bids were publicly opened and read aloud at 1i:oo..a.m, June 8, 2o11 in the Town of Reading Municipal Light Department's Board Room,ego Ash Street,Reading,Massachusetts. The bids were reviewed,analyzed and evaluated by the General Manager and the staff. Move that bid 2011-12 for Surplus Watt-Hour Meter be .awarded to: TDI (Transformer Decommissioning,Inc.)Division of VPG,Inc. for a total cost of$27,500.00 Unit Cos Ouanti Net Cost $1.10 25,000 $27,500.00 as the only qualified bidder on the recommendation of the General Manager. This surplus is being disposed of according to RMLD Policy 2. o , intent F.Cam on,Jr. V�t� Nick D'Alleva File:Bid/FY11/Meter/2011-12 Surplus Waft Hour Meter IFB 2011-12 Certified All forms Check or Authorized Bidder Unit Cost Q�t Total Net Cost filled out Bid Bond signature TDI (Transformer Decommissioning, $1.10 25,000 $27,500.00yes yes yes inc.) Division of VPG,Inc. Description:(various manufacturers) Shipping 24,000 form 2S C1 200 240V 30A, 3 wire, and 1;000 meter of n/a miscellaneous configurations. Standard Itron or compatible ERT, .75% mechanical 25%solid state. T&D Surplus, Inc. $1.11 25,000 $27,750.00 yes no* yes Description:(various manufacturers) Shipping 24,000 form 2S Cl 200 240V 30A, 3 wire, and 1,000 meter of T&D Surplus can pick up any number of miscellaneous configurations. Standard Itron or compatible ERT, pallets as long as it's truck is in your area. 75% mechanical 25%solid state. Otherwise 1/2 trailer load minimum, about 30-50 pallets. Most of the time we are very flexible. I. J *Revised price was submitted but bidder did not include additional bid security check to cover 10%of total bid price. Therefore, bid considered.non-responsive. o' A N 0 v ci 0 Ri O O'? M O N O W � O O ? N r A d W W m W tOD c V N`� Obi O o ut W S..QNL H HN wN e� H6 NN� W N O2 -fN W U N J < 9 O C W � LOD r b cq m io r M ri J ' Mci l9 N� H N(D q N N pC;Q p N W J .C a e N QFF dO O1.(p OL M V i� � a 3 ❑ v?w� mLaN oma' rno �C�3: ten= a M O W 26 M "O co N a w r m O Oi ci Rei r n N r W N N M Wm e m S a v 0 NO p0 N yO Lti p0 O % a O r a a tfDO� opo mm� wmo �� � m W^ ~ N N r N W a M O A T A r LO A p u0i N W wN Kcs r 6 W p N W p1 � W a 4! Y- oQ M OL 1� V CF M W Z N V o O^ 0 W n M d. M w O O O r O r m N r LM(1 T n a r2c5ci O ❑ w �` N w N C N w N — W N LV N N 6 z a W m ❑ O N C (7 A z d ~ a J otl Q w Wp a J ❑ a ? ❑ F S x O O a g f�9 Z 4 = N V O L7 Z O U O 2 O 2 O a Q z Q a U a a U a cwi a v < z a J VOJ U W �O U W U W z J U W p J LSj W O U Zm z m LL U m LL ❑ m w W m w Y. LC LL z W O Q O Q Y LL Q 6 Y LL m Q Y LL Q Y u w a Y LL O Q W O W QQ W 4~i O W W O W O W a O W z r a z Jeanne FoU From: Vincent Cameron Sent: Thursday, May 26, 2011 3:51 PM To: Richard Hahn; Phil Pacino; Gina Snyder; Mary Ellen O'Neill; Bob Soli Cc: Bob Fournier; Lee Ann Fratoni;Kevin Sullivan; Jeanne Foti Subject: FW: Account Payable Questions-May 20 Soli 1. Viewpoint-Will this be paid by 5/29 so discount applies? No. The payable process can't meet that date. Snyder 1. Aspiundh -What does "patrolling off Burlington Ave." mean? The tree crew was told to patrol Burlington Ave and adjacent areas to determine if there were tree problems. This was done as part of a tree related outage that occurred. 2. .Duncan + Allen -Do you have an electronic copy of FERC order#745 that you can send me? It is available on the FERC website. O'Neill 1. Asplundh -Where did Greenwood/Curran crew work on Friday, April 29? What towns are streets located in worked by the Greenwood/Curran crew and the Blasetti/Tomey crew the last week of April? They were still on Keniston Road, Lynnfield. Lynnfieid and Wilmington. 2. Carpenter-What was purchased by personal credit card of$42.56. Why didn't this go through the PO process? I will look into this. 3. Fournier-Reading Lumber, Market Basket. If the petty cash policy is implemented, as I was told it was,why is it not being used for some of these purchases to reduce this paperwork? Myself and Bob Fournier have decided to start the petty cads process on July 1 (start of the fiscal year). 4. Fournier-Why are we buying Tums for the office?Why is Mr. Fournier being reimbursed for a purchase on Mr. Cameron's credit card? We have purchased Tums and Aspirin for office for employees use. Mr. Fournier did not use my credit card. My company credit card has not even been issued. Mr. Fournier is being reimbursed for using his own money. 5. Town of Reading Police Department-Two RNILD detail sheets are not signed by the specific police officers.They should be filled out properly. They have been signed by the officers. O'Neill -Payroll 5131/2011 1. OT Sheet- I thought all employee last names were on this sheet whether or not he/she this time(or ever) received OT. At least one missing-the E+O Manager. Mr. Sullivan will be put on the O/T sheet. 2. Meter Upgrade Project- Is the residential portion being done on overtime in addition, to regular time? If yes, Why? The Meter Upgrade Project was initially planned to be performed by RMLD employees on both on straight time and overtime. The straight time loaded rate for an RMLD employee is 1.578 times the employee pay rate. The overtime rate is 1.5 times the employees pay rate. Jeanne Foti Executive Assistant Reading Municipal Light Department 781-942-6434 Phone 781-942-2409 Fax Please consider the environment before printing this e-mail. 5/31/2011 Jeanne Fob From: Vincent Cameron Sent: Wednesday, June 01, 2011 1:42 PM To: Richard Hahn; Phil Pacino; Gina Snyder; Mary Ellen O'Neill; Bob Soli Cc: Bob Fournier; Lee Ann Fratoni; Kevin Sullivan; Jeanne Foti Subject: FW:Account Payable Questions -May 27 Soli 1. Asplundh -Take down 6 oaks on private property-please explain. On the invoice I wrote"Clearing trees for line work." The RMLD is reconductoring a distribution line on Woburn Street, Wilmington. The distribution line is right next to the property lines because there is no sidewalk, so the RMLD had to take down privately owned trees to assure no interference with the lines. The alternative was to have the line go across the street light, which would cost more than $9k and to have tree go out to the line from time to time and trim the trees away from the lines. The residents who owned the trees gave the RMLD permission to take down the trees. Snyder 1. Alpha Mechanical- I would prefer to see PO prior to work 4/19 to 4/22 Bill 4/30, PO 5/11. This work was for consultant fees for the cooling tower project and was a necessary"add on"to previous work. 2. Hastings-PO doesn't match bill? The PO was for$1,071. The bill was for components for jumpers ($384+$555+$81+$51=$1,071) The shipping was$32.24 and was not on the PO. Did you mean the shipping caused the difference? If so, that happens from time to time because the RMLD or the vendor doesn't know the exact shipping cost at the time of the P0. 3. Memorandum JOZ-is there some documentation where this $27,590 refund is from? Yes. We have a lot of documentation when the developer applied for the project. It is in a folder in Engineering if you would like to review it. 4. Shea-Why three separate fees for the permit test? The first permit test was not passed. The RMLD will pay for one retest. The other fee was for the book. O'Neill 1. Asplundh - I echo Mr. Soli's comments. Additionally, why were six live trees up to 50" (4+feet) in girth taken down in lieu of trimming. Does RMLD need to work on private property? See Item 1 under Mr. Soli's comments. The RMLD will take down trees if they are in the way of RMLD construction. It is a lot less expensive to take the trees down now than to have to send crews out in an emergency and repair tree damage on this line in the future. The RMLD has to work on private property from time to time and does it with the permission of the property owner unless the RMLD has an existing easement. 6/1/2011 2. Energy Egghead - I believe the Board needs to discuss these POs and revisit the recent bid award. Please let me know your concerns with the POs and the bid? The PO states what work is expected to be done based on the bid. The recent bid was performed according to 30B bid laws. 3. HD Supply Utilities-Are these two units transformers? If so, why were they not included in the blanket transformer bid? These are not transformers, they are pad mounted three-phase switches. 4. Tyndale- PO states contract expires - 5/31/2011 but new bid has not gone to the Board. What is the total paid-to-date on PO of approximately$33,600. There is a requisition currently in the system for the second year(contract begins June 1, 2011)of the three year contract the Board voted on February 24, 2010. 5. Wesco-Should these gang switches have gone out for bid as PO is$25,632? 1 assume by asking about"going out for bid"you mean the invitation for Bid process. No, they should not have gone out for bid. They are three separate pieces of equipment. On the PO are three 900 amp Omniruptor switches with manual operated handles for$9,090, three 900 amp Omniruptor switches hot sick operated for $7,950,and three 600 amp Omniruptor switches hot stick operated. Since there are three distinct products on the PO, and each product-was under$25k,the purchase of the items required three quotes according to 30B bid laws. 6/1/2011 Jeanne Fob From: Vincent Cameron Sent: Tuesday, June 07, 2011 11:14 AM To: Richard Hahn; Phil Pacino; Gina Snyder; Phil Pacino; Bob Soli Cc: Bob Fournier; Lee Ann Fratoni; Joe Donahoe; Jeanne Foti Subject: FW: Account Payable-June 3 Snyder 1. Alpha Mechanical -Why were they doing this work on OT? The invoices in question were for repairs to the chilled water gauges and piping.The first invoice was to replace two broken gauges. When this was completed, and the system refilled, a cracked 4" pipe was discovered pouring water on to the floor of the mezzanine. This work had to be performed immediately. 2. Tony's Marble—What is this for? The materials were for replacing the floor in front of the cafeteria door. O'Neill 1. Carpenter-Where is documentation that the pre-approval process was followed? Yes, the process was followed. There was a tuition reimbursement authorization form which was . misplaced. The form that was attached was redone. 2. DNS/Alpha Mechanical- First invoice says May, 2010 installment-did they mean 2011? Fourth PO - not signed. Why weren't invoices#2..and#3 covered by bid contract? Yes, 2011. PO signed. No, the work on invoices 2 and 3 was beyond scheduled maintenance and included replacing gauges and other related work. 3. Liberty Chevrolet-PO on third invoice not signed. It has been signed. 4. In General - My expectations are that all questions from the Commissioners will henceforth be answered honestly and that the "chain of custody"for all employee reimbursements be unimpeachable. No comment. Payroll - O'Neill 1. Please review for me again why we're doing some of the residential meter upgrade project on overtime. The meter upgrade project is being performed in house by the Meter Tech Readers and the SeniorMeter Techs. The original schedule included doing a certain amount of this work on overtime. 2. 1 thought we had more than 17 lineman. Is that OT list a comprehensive one? The RMLD presently has seventeen Lineman. There are also two Troubiemen that are on the Department listing. Yes, in my opinion it is a comprehensive Fist. 6/7/2011 Jeanne Fofi From: Vincent Cameron Sent: Thursday, June 16, 2011 2:44 PM To: Richard Hahn; Phil Pacino; Gina Snyder;Mary Eilen O'Neill; Bob Soli Cc: Bob Fournier; Lee Ann Fratoni; Kevin Sullivan; Jeanne Foti Subject: Answer to Payables 6/13/2011 Snyder 1. Fishbach and Moore-Several indications of"mapping out cables"on "underground" + "investigate manholes". The latter 5/18/11 at Atlantic. I would like to see this coordinate with the GIS. Our contractors + OT line area shouldn't have to spend hours mapping out services when we have GIS. The mapping effort is done as front end work to upgrade underground services. in addition,the mapping work done in the field is also put into the GIS. 2. Stuart Irby-What about the statement balance of$9,721.34? That statement is not a separate bill but the back up to the$176 bill, because the RMLD sent back the equipment and took a credit for the equipment that we did not order. The bill for$9,721.34 includes the equipment for$176 that was returned. O'Neill 1. PLM -What is the.paid to date total on this$302,544. contract? According to the notations on PO 08-11810 the RMLD has paid $255,118 ($302,544-$34,306-$13,120). 6/16/2011