Loading...
HomeMy WebLinkAbout2013-03-27 RMLD Board of Commissioners Minutes Reading Municipal Light Board of Commissioners Regular Session 230 Ash Street Reading,MA 01867 March 27,2013 Start Time of Regular Session: 6:30 p.m. End Time of Executive Session: 7:45 p.m. Reconvene Regular Session: 7:50 p.m. End Time of Regular Session: 8:45 p.m. Commissioners: Philip B.Pacing,Chairman Gina Snyder,Vice Chair Marcie West,Secretary Roberi Soli,Commissioner John Stempeck,Commissioner Staff: Kevin Sullivan,Interim General Manager Beth Ellen Antonio,Human Resources Manager Jeanne Foti,Executive Assistant Robert Fournier,Accounting/Business Manager Jane Parenteau,Energy Services Manager David Polson,Facilities Manager Citizens' Advisory Board: George Hooper,Vice Chairman Opening Remarks Chairman Pacino called the meeting to order and stated that the meeting was being videotaped. Executive Session At 6:31 p.m. Mr. Stempeck made a motion seconded by Ms. West that the Board go into Executive Session for Chapter 164 Section 47D Exemption from public records and open meeting requirements in certain instances to discuss competitively sensitive issues,to �rpprove the Executive Session meeting minutes February 27, 2013,to discuss strategy with respect to collective bargaining and union negotiations, to approve the release of Executive Session meeting minutes of February 29, 2012, March 29, 2012, July 25,2012 and October 1,2012 and return to the Regular Session for the release of 2012 Executive Session minutes and continue in Regular Session. Motion carried by a polling of the Board: Ms.West,Aye;Mr.Soli;Aye•,Chairman Pacino,Aye;Mr.Stempeck,Aye;and Ms.Snyder Aye. Reconvene the Regular Session At 7:50 p.m.the RMLD Board reconvened in Regular Session. Ms.West was not present at this point in the meeting. Executive Session Minutes Mr.Stempeck made a motion seconded by Ms. Snyder that the Board authorize the release of Executive Session meeting minutes of February 29,2012,March 29,2012,July 25,2012 and October 1,2012. Motion carried 4:0:0. Introductions Vice Chair Snyder was presented a meter Imp in recognition of her service to the RMLD Board of Commissioners. Chairman Pacino acknowledged Citizens' Advisory Board Vice Chairman George Hooper's attendance at the meeting. Public Comment There were no members of the public present. Approval of Board Minutes Mr.Stempeck made a motion seconded by Mr. Soli that the RMLD Board of Commissioners approve the Regular Session meeting minutes of February 20,2013 as presented and the February 27,2013 with the change presented by Ms.Snyder. Motion carried 4:0:0. `vts. Snyder said that there was a customer asking about the audits at the February 20, RMLD Board meeting. It was stated that the audits would begin in early March. Is it back on track;have they begun again? Mr.Sullivan responded that it his intention to address this in the General Manager's Report. Regular Session Meeting Minutes 2 March 27,2013 Approval of Board Minutes Ms. Snyder had a follow up question; if an RMLD customer has natural gas can they call National Grid directly to obtain an audit. Mr.Fournier responded that RMLD customers that heat with natural gas should call the RMLD in order that the audit be recorded as scheduled. Then the Department will work with Next Step Living to work on a date for the audit. Ms. Snyder added her change to the February 27 meeting minutes—Ms. Snyder clarified that discussion at the January meeting was that the Board makes decisions regarding capital expenditures but the Board declined to proceed at the last meeting. Mr. Sullivan asked if Ms. Snyder made the comment at the February 27 meeting. Ms. Snyder replied,yes. Mr. Sullivan reminded the Board that Ms. Foti listens to the tapes of the meeting while typing the minutes. Ms. Snyder added that the minutes get edited down. Mr. Sullivan said that if the minutes were edited down he is unsure if it would be in the current format,however will take the clarification. General Manager's Report—Mr.Sullivan—Interim General Manager RMLD Provided Coloring Books and Pencils for Little Treasures Schoolhouse for Earth Day Concert Tueul y April 16 2013 For the past two years, RMLD has provided coloring books and pencils the First and Second Annual Earth Day Concerts featuring Wayne from Maine,sponsored in pan by Little Treasures Schoolhouse,Inc. The concert will he held on Tuesday,April 16 at 10 a.m. at the Reading Memorial High School Performing Arts Center. Earth Day,Saturday—April 27 2013 The RMLD will be participating in Earth Day,Saturday,April 27 at the Matters Cabin, 1481 Main Street,Reading,from 10:00 a.m.to 2:00 p.m. American Public Power Association—Engineering and Operations Conference Mr. Sullivan reported that he just returned from the APPA E&O Conference which was a terrific conference. One of the issues addressed was the Regional Transmission Operators(RTOs)as well as the Independent System Operators(ISOs)around the country. In the future,they will be managing conventional power supply portfolios of coal,gas,nuclear and renewables. Due to the expanding and collapsing voltage fields of renewables,a concern is how that will he managed. Town of Reading—Other Post Employment Be ft(OPEB) The BUILD will share in the cost of creating the trust document for the OPEB with the Town. Mr. Sullivan thanked Vice Chair Snyder for her suggestion on the synergy with the Town relative to the OPEB. • RMLD—Energy Audits The Department had a productive meeting with Next Step Living, its energy auditor on March 25. The RMLD received clarification on reports and invoices. Next Step Living understands that no open solicitations for energy audits will take place while they are out in the community. Requests for audits must scan with a call or a visit to the RMLD website. Mr. Sullivan added that Ms. Parenteau and Mr.Fournier were in attendance at this meeting. Solar Initiative with the Town of Reading Mr. Sullivan attended the preliminary meeting with the Town of Reading and Broadway Electric who is the solar developer that the town has selected to determine the feasibility of photovoltaics being placed on some of the Reading schools. The developer has looked at eleven sites for photovoltaic panels. MMWEC Billing RMLD received a memo today relative to the receipt of February's billing which the RMLD should receive on April 4. This evening, both the Power Supply Report and the Financial Report for January are being presented. Budget Review Process—Fiscal Year 2014 With RMLD's Citizens'Advisory Bard Wednesday,April 3,2013,Operating Budget and Wednesday,April 10,2013,Capital Budget Chairman Pacino asked is this for the CAB presentation. Mr. Sullivan responded,yes. Chairman Pacino expressed his concern on the composition of the Board after April 2 relative to having the full Board present at the meeting on April 3. Mr. Sullivan pointed out that any new members of the RMLD Board must be sworn in prior to that meeting. Power Supply Report—January 2013—Ms.Parenteau(Attachment 1) Ms. Parenteau presented the January Power Supply Report provided in the Commissioner packets covering power supply charges, energy costs, fuel charges and collections, fuel reserve balance, spot market purchases, capacity costs, as well as the percentage RMLD's hydro projects. Regular Session Meeting Minutes 3 March 27,2013 Power Supply Report—January 2013—Ms.Parenteau(Attachment 1) Mr. Soli asked why the MacQuarie contract became so inexpensive. Ms. Parenteau explained that MacQuarie is made up of two contracts. They bought out the old Integrys contract which was a fixed contract with the other component of that contract being heal t ,ate indexed. Due to the decline in the price of natural gas, the natural gas commodity has reduced significantly in the second half. hey were able to purchase at$38 a megawatt hour. In January,7.3%of RMLD's energy purchases were from hydro generation.Ms.Formalism reported that RMLD has signed four hydro Purchase Power Agreements. The RMLD has sold 12,613 — 2012 RECS for the first and second quarter which resulted in a net revenue of$581,000 which was credited to the Fuel Charge in that month. Currently banked for 2012 quarters one and two RMLD has seven hundred fifty RECs that they plan on retiring. Through January 2013, the total estimated RECs are 3,823 with an estimated market value of$126,000. On energy efficiency, the RMLD for the commercial sector, has garnered approximately one megawatt of capacity savings which results in 4,500 megawatt hours of energy savings. This includes eighteen lighting rebates, nine customer rebates that include chillers, pumping systems,controllers,solar,variable speed drives and refrigeration. On the residential side,the RMLD garnered 1/2 kilowatts of capacity savings and 81 megawatt hours of savings with 579 rebates costing $28,970. There have been 207 residential energy audits completed costing$41,400. As Mr. Sullivan mentioned,the audits are no longer on hold. Assessments are being scheduled this week. To date,there have been 85 natural gas audits billed to National Grid saving the RMLD$17,000. Engineering and Operations Report—February 2013—Mr.Sullivan(Attachment 2) Mr. Sullivan presented the report included in the Commissioner packets covering the monthly capital projects, an update on the metering project and reliability reporting. Mr.Sullivan reported that he anticipates spending$5.2 million in fiscal year 2013. Projects that will be carried into Fiscal Year 2014 include: Project 3 Upgrading of Old Lynnfield Center URDs and Project 8 and Station 4 Relay Replacement Project,as well as other projects—Project 19,21,22,24,25 and 26. There is approximately$1 million that will be available in fiscal year 2014. Mr. Soli said that the Board had asked the retired General Manager to report on projects that will carry over more than one year. Also, that the reporting demonstrates the total cost and the total budget. The only report that the Board ever received relative to this was on the Gaw project. Mr. Soli said that we never received a report and has not seen a report on the meter project on paper. It is his hope j, hat the reporting on tarty overs will be from the start. As stewardships of the budget,it would be good to see the carryovers. Mr. Stempeck asked about the Station 1 project that came in at$3 million. Mr. Sullivan responded that we are in the process of this. Mr. Stempeck added that he does not believe that this was voted unless there were alternative uses. Mr. Sullivan stated that the fiscal year 2013 budget was approved therefore, a vote was taken. Mr. Soli added that there will be bids on the project. Mr. Sullivan concurred. Mr.Soli asked about the animal guard installations are that to keep the squirtels out Mr.Sullivan responded that this for all types of wildlife,to include birds and raccoons,this initiative is for overhead transformers. Mr. Sullivan reported that the Customer Average Interruption Duration (CAIDI) for the month was 69.29 minutes that is above the Department's four year average. In February, there were 93 customers affected by outages with 72 customers affected in North Reading for two separate incidents. The two separate incidents required clean ups due to leaking transformers. These factors impact the CAfDI number. Discussion ensued. The System Average Interruption Frequency(SAIFI)values have been good which holds true for the month of February. The average February SAIFI is 0.34,but in February 2013, was at 0.04. The Months Between Interruptions (MBTU is at 41 months interruption for the year. Mr. Sullivan reported on the meter upgrade project. Currently,commercial meters are being installed due to the weather conditions. Once the snow clears the residential meter installations will resume. Ms. Snyder said that in the CAB minutes they were given, there was a concern on the commercial meter change outs affecting their service. Mr. Sullivan commented that they schedule the commercial customers prior to making the meter change. Mr. Stempeck clarified on the larger commercial customers during the meter change out, would they would need to resort to their emergency backup. Mr. Sullivan said the smaller commercial customers are the ones that will be most impacted by the meter change. Regular Session Meeting Minutes 4 March 27,2013 Financial Report—January 2013—Mr.Fournier(Attachment 3) Mr.Fournier reported that due to the MMWEC billing system upgrade,that this has caused a delay,resulting in the January Financials being presented. Mr. Fournier presented the financial report included in the Commissioner packets for the first seven months; n income $615,000, increasing the year to date income to $2.3 million. Year to date kilowatt hour sales were 423,000,000 kilowa� hours sold which is I%ahead of last year's actual figure. Mr.Fournier pointed out that the Department received revenues from the sale of Renewable Energy Certificates for$582,000 coupled with the June 2012 proceeds of$344,000,brings the total to$926,000 which is netted against the fuel expense. The Department of Public Utilities Report for 2012 has been completed. The next month will consist of the budget review process. Mr. Stempeck asked how much the Department originally paid for the RECs. Ms. Paremeau responded that it is bundled within the contract price which came in a little under ten cents for capacity, energy and the RECs. The RECs were not purchased separately; they were purchased on the product. Mr. Stempeck asked is it difficult to separate the RECs out. Ms. Parenteau responded that one way to determine this is found in Table 4. This shows the costs of hydros, the average proceeds, the average per kilowatt hour to determine the average cost of that power by backing out the RECs. Mr. Soli questioned page I1 b energy conservation residential and commercial $417,000, two separate lines, page 12 a there is the energy conservation charge $482,000 why the difference. Mr. Fournier responded that the two are not meant to equal. The energy conservation charge is based on per kilowatt hour sold each month with a fund that accumulates. The energy conservation fund is at $228,000 which goes back to the inception of the program. In the early years of the program we collected more than we spent. Mr. Soli summarized that 11 b is the income whereas 12 a, is the outcome. Mr. Fournier explained that some years the Department overcollected or undemollected based on the activity of the particular programs being administered within that year. Before,there was a separate rate for residential and commercial customers when the program started, now it is the same rate for both classes of customers. Mr. Soli added for the commercial customers there was a dedicated person who is no longer with us, won't there be a lot of dollars being collected without providing the service. Mr.Fournier added that the program is still intact. Mr. Sullivan stated that the position will be filled. Mr. Soli asked if the rate should be changed where we are not providing the service. Discussion ensued. Chairman Pastmo pointed out that with the added funds you could expand the program out more than it is now and the position is going to be filled. Mr. Soli asked on page 13, Cogsdale are they going to perform a major upgrade, $2,000 was spent. Mr. Fournier explained tha* Cogsdale came out because there were software changes required on the meter project. This was not budgeted. Two representatives From Cogsdale and these monies represent the cost of their travel which was for less than a week. Mr. Soli asked if there is any more work that is anticipated. Mr. Fournier said that on the commercial side of the meter upgrade project, they may have to come in to tweak the software. M.C.L.Chapter 30B Bids(Attachment 4) IFB 2013-27 One(1)Pick Up Truck with Litt Gate Mr. Polson reported that eleven companies were sent the bid with five respondents with four being responsive. The Department is recommending that the bid be awarded to Bernell Motors for a Ford F250 with a lift gate. Mr. Stempeck asked if the lift gate is hydraulically operated. Mr.Polson replied yes,it is mounted on the back of the vehicle. Mr. Soli asked if the F250 is a pickup truck. Mr. Polson responded that it is. Mr. Soli asked if this was on the state schedule because frequently in the past this is how vehicles were procured. Mr.Polson said that the state contract was looked into for this vehicle,however the lift gate was not offered,therefore they went out for competitive bid. Mr. Stempeck made a motion seconded by Mr. Soli that bid 2013-27 for one Pick Up Truck with Lift Gate be awarded to Bernell Motors,Inc.for$28,850.00 as the lowest qualified and responsive bidder on the recommendation of the Interim General Manager. Motion carried 4:0:0. IFB 2013-28 One(1)Pick Up Truck with Plow Mr. Polson reported that eleven companies were sent the bid with five respondents with fora being responsive. This is for a Ford F250 with a plow. The Department is recommending that the bid be awarded to Stoneham Motor Co. Inc. for a Ford F250 with a plow. Mr. Stempeck asked how many trucks have plows on them. Mr. Polson responded that we have one pickup truck with a plow and one with a sander with a plow. Mr.Solt asked if this was on the state schedule. Mr. Polson responded that the state contract did not offer everything the Departme� needed. Regular Session Meeting Minutes 5 Much 27,2013 M.G.L.Chapter 30B Bids(Attachment 4) IFB 2013.28 One(1)Pick Up Truck with Plow Cr. Stempeck made a motion seconded by Ms. Snyder that bid 2013-28 for one Pick Up Truck with Plow be awarded to Stoneham otor Co.,Inc.for$31,003.00 as the lowest qualified and responsive bidder on the recommendation of the Interim General Manager. Motion carried 4:0:0. General Discussion Ms. Snyder staled that she had a concern that she wanted to express. Going back a ways,there was the position of Assistant General Manager, now there is not one and there are not many opportunities for senior staff to get that kind of experience. It is going to take quite a while longer than anticipated in hire a new General Manager. Ms. Snyder suggested having a rotation which often happens where she works when a manager is gone for an extended time. They will rotate staff into that position in order to give everyone the expertise. There are senior staff that could be considered and rotated in the Interim General Manager position. Ms. Snyder made a motion that the RMLD Board of Commissioners pursuant to Commonwealth of Massachusetts, General Laws Chapter 164,Section 56,appoint senior staff on a rotating basis to the position of Interim General Manager with Mr. Sullivan and Ms. Parenteau in those roles, and that Ms. Parenteau be appointed for the three month period starting, April 1 or it could be May I and could include anyone that is on the same level would rotate in if it continues beyond that for the search for the new General Manager. Mr. Sullivan stated that this type of decision should be left up to the General Manager. Ms. Snyder responded that the General Manager has retired. Mr.Sullivan commented the Interim General Manager. Ms. Snyder said that they just had a lecture on how the Board is responsible for appointing the General Manager. Ms. Snyder said that this gives senior staff the opportunity to get expertise which is something that should be considered. Mr.Sullivan said that he thinks that the Board is over reaching on this. Chairman Pacino asked for clarification on the motion. Ms. Snyder clarified that senior staff on a rotating basis in the position of Interim General Manager. Ms. Snyder commented that there was discussion at the RMLD Board meeting on February 20 that was called suddenly, with a blank for the dates and people,this motion parallels that motion,Ms. Snyder moved that the RMLD Board of Commissioners pursuant to Commonwealth of Massachusetts, General Laws Chapter 164, Section 56 appoints senior staff on a rotating basis for the position of Interim General Manager with Mr. Sullivan and Ms. Parenteau in those roles with Ms. Parenteau being appointed for the next three month period starting April 1 or the motion could be amended to start May 1. `Chairman Pacino stated that after this evening the composition of the Board will be changing and is unsure if this should be left for new Board to decide. In terms of the General Manager Search Committee,the recruiter has been given a timeline with the anticipation by June a new General Manager would be in place. Chairman Pacino said that he could not support this at this point. Mr.Stempeck stated that it is a good idea. Senior staff should have the opportunity to assume the role for some period of time because it is temporary. Having the opportunity to rotate through is a good learning experience it helps prepare those in the organization in step up. In general, he is in favor of it. What he understands at the next Board mecting the constituency can change. Mr.Soli seconded the motion and moved to amend the dale to April 15,Ms. Snyder accepted the change. Chairman Pacino added that he is opposed to this because the new Board should be given the opportunity to make this decision. It is not a wise decision going forward. We should stay the way we are since a General Manager should be in place by June. Chairman Pacino said that the retired General Manager let us down in the fact that he did not vain someone to bring along. He hopes with the new General Manager will work to bring someone along. Chairman Patina added that we need one person to tan the Department. To have someone on April 15 to counterbalance the current decisions,it is not the best for the Department, it is best to wait until a new General Manager is in place. It is a short period of time for training. Ms. Snyder made a motion seconded by Mr. Soli that the RMLD Board of Commissioners pursuant to Commonwealth of Massachusetts, General Laws Chapter 164, Section 56, appoints senior staff on a rotating basis for the position of Interim General Manager with Mr. Sullivan and Ms. Parenteau in those roles with Ms. Parenteau being appointed for the next three month period starting April 15. Motion carried 3:1:0. Chairman Pacino voted against this motion. BOARD MATERIAL AVAILABLE BUT NOT DISCUSSED Rate Comparisons,March 2013 4iiwE-Mail responses to Account Payable/PaymR Questions Regular Session Meeting Minutes 6 March 27,2013 RMLD Board Meetines Wednesday,April 24,2013 and Wednesday,May 29,2013 Citizens'Adviso Board Meeting-Budget C ittee Meetings Wednesday,April 3,2013,North Reading Town Hall,Room 10,7:00 p.m. Wednesday,April 10,2013,RMLD SpurrIAV Room,7:00 p.m. Adjournment At 8:45 pm.Mr.Soli made a motion seconded by Mr.Stempeck to adjourn the Regular Session. Motion carried 4:0:0. A true copy of the RMLD Board of Commissioners minutes as approved by a majority of the Commission. John Stempeck,Secretary Pro Tem RMLD Board of Commissioners • • To: Vincent Cameron From: Energy Services Date: March 21, 2013 Subject: Purchase Power Summary—January, 2013 Energy Services Division (ESD) has completed the Purchase Power Summary for the month of January, 2013. ENERGY The RMLD's total metered load for the month was 60,727,318 kwh, which is a 2.1% increase from the January, 2012 figures. Table I is a breakdown by source of the energy purchases. TABLE 1 Amount of Cost of %of Total Total$ $..a Resource Energy Energy Energy Casts % (kWh) ($IMwh) Millstone#3 3,713,509 $5.99 6.10% $25.948 1.03% Seabrook 5,897,256 $8.20 9.69% 548,365 1.92% Stonybrook Intermediate 3,503,224 $108.37 5.76% $379,658 1505% JP Morgan 9,354,800 $58.55 15.37% $547,677 21.71% Ne#Era 9,502,000 $69.51 1561% $660,453 26.18% NYPA 1,940,647 $4.92 3.19% $9,547 0.38% ISO Interchange 3,541,386 $59.95 5.82% $212,291 541% NEMA Congestion 0 $0.00 000% -$658,628 -26.10% Coop Resales 122,685 $110.90 020% $13,606 0.54% MacOuarie 9,200,000 $38.41 15.12% $353,349 14.00% Summit Hydro 994,950 $55.61 1.63% $55,332 2.19% Braintree Watson Unit 461,029 $129.32 0.79% $62,208 2.47% Swift River Projects 1,529,467 $99.78 2.51% $152,613 6.05% Constellation Energy 11,048,400 $59.21 18.15% $654,143 2593% Stonybrook Peaking 37,315 $176.97 0.06% $6,603 0.26% Monthly Total 60,866,668 $4145 100.00% $2,523,167 100.00% A1TACMAENT1 Table 2 breaks down the ISO interchange between the DA LMP Settlement and the RT Net Energy for the month of January, 2013. Table 2 Amount Cost %of Total Resource of Energy of Energy Energy (kWh) ($/Mwh) ISO DA LMP6,320,346 85.31 10.38% Settlement RT Net Energy" -2,778,961 74.34 -4.57% Settlement ISO Interchange 3,541,386 59.95 5.82% (subtotal) "Independent System Operator Day-Ahead Locational Marginal Price Real Time Net Energy CAPACITY The RMLD hit a demand of 108,799 kW, which occurred on January 23, at 7 pm. The RMLD's monthly UCAP requirement for January, 2013 was 211,827 kWs. Table 3 shows the sources of capacity that the RMLD utilized to meet its requirements. • Table 3 Source Amount(kWs) Cost($/kW-month) Total Cost$ %of Total Cost Millstone#3 4,991 46.21 $230,645 15.41% Seabrook 7,742 49.44 $382,780 25.57% Slonybrook Peaking 24,981 2.00 $49,926 3.34% Stonybrook CC 42,925 3.85 $165,129 1103% NYPA 4,019 3.57 $14,347 0.96% Hydro Quebec 4,584 4.70 $21,550 1.44% Neztera 60,000 5.50 $330,000 22.04% Braintree Watson Unit 10,520 11.01 $115,836 7.74% ISO-NE Supply Auction 52,065 3.59 $186,771 12.48% Total 211,827 $7.07 $1,496,984 100.00% • Table 4 shows the dollar amounts for energy and capacity per source. Table 4 Cost of %of Amt of Energy Power Resource Energy Capacity Total cost Total Cost (kWh) ($IkWh) Millstone N3 $25,948 $230.645 $256,594 6.38% 3,713,509 0.0691 Seabrook $48,365 $382,780 $431,145 10.72% 5,897,256 0.0731 Stonybrook Intermediate $379,658 $165,129 $544,787 13.55% 3,503,224 0.1555 flydro Quebec $0 $21,550 $21,550 0.54% - 0.0000 JP Morgan $547.677 $0 $547,677 13.62% 9,354,800 0.0585 NeadEra $660.453 $330.000 $990453 24.64% 9,502,000 0.1042 ' NYPA $9,547 $14,347 $23.894 0.59% 1,940,647 0.0123 ISO Interchange $212,291 $186,771 $399.062 9.93% 3,541,386 0.1127 Nemo Congestion -$658,628 $0 -$558,628 -16.38% - 0.0000 MacOume $353,349 $0 $353,349 8.79% 9,200,000 0.0384 ' Summit Hydro $55,332 $0 $55,332 1.38% 994,950 0.0556 Braintree Wilson Unit $52,208 $115,836 $178. 4 4.43% 481,029 0.3701 ' Swift Riler Projects $152,613 $0 $152,613 3.80% 1,529,467 0.0998 Coop Resales $13,606 $0 $13,606 0.34% 122,685 0.1109 constellation Energy 9654,143 $0 $654,143 16.27% 11,048,400 0,0592 Stonybrook Peaking $6,603 $49.926 $56,530 1.41% 37,315 1.5149 Monthly Total $2,523,167 $1,496,984 $4.020,150 100.00% 60.866,668 0.0660 ® ' Renewable Resources 7.3,1 RENEWABLE ENERGY CERTIFICATES (RECO The RMLD sold 12,613 2012 RECs(Quarter 1 and Quarter 2) for$582,097.75 in January, 2013. 750 Quarter 1 and 2 RECs remain banked for retirement. Table 5 shows the amount of banked and projected RECs for the Swift River Hydro Projects through January, 2013, as well as their estimated market value. Table 5 Swift River RECs Summary Period - January 2012-January 2013 Banked Projected Total Fat. RIC, alis Inc, Dollars woronoca 394 1,465 1,859 $67,390 Pepperell 364 0 384 $20,357 Indlan River 92 737 829 $39,061 Turners Fall, 751 0 751 $0 Grand Total 1,621 2,202 3,823 $126,803 TRANSMISSION The RMLD's total transmission costs for the month of January were$774,307. This is an increase of 4.8%from the December transmission cost of$738,628. In January, 2012 the transmission costs were $638,899. Table 6 Current Month Last Month Last Year Peak Demand(kW) 108799 108,921 106,558 Energy(kWh) 60,866,668 59,364,911 59,550,250 Energy($) $2,523,167 $2,868.713 $3,338,331 Capacity($) $1.4969a4 $1,528,363 $1,337,348 Transmission ($) $774,307 $738,628 $638,899 • Total $4,794.458 $5,135,703 $5,314,578 • 3121/2013 READING MUNICIPAL LIGHT DEPARTMENT 2'06 PM FY 13 CAPITAL BUDGET VARIANCE REPORT FOR PERIOD ENDING FEBRUARY 28,2013 ACTUAL YTD ACTUAL ANNUAL COST COST BUDGET REMAINING 8 PROJECT DESCRIPTION TOWN FEBRUARY THRU 2/28/13 AMOUNT BALANCE E&O Construction-System Prolects 1 Essex Street-Rewnductoring LC 200 197,855 197,655 2 4W130H Rewnductoring-West Street W 319 14,608 188,193 173,585 3 Upgrading of Old Lynnfield Center URDs (Partial CARRYOVER) LC 266 121,554 492,143 370,589 5 Shady Lane Area-Rewnductoring W 30,953 95,677 199,042 103,365 6 Federal Street-Rewnductoring W 30,966 88.486 175,565 87,079 Telal System Projects Station Upgrades Station M4 8 Relay Replacement Project-(Partial CARRYOVER) R 119,309 119,309 9 Station 4 Getaway Replacement-4W13 R 4,430 161,779 157,349 Total Station Projects SCADA Protects 10 Station 5 RTU(Remote Terminal Unit)Replacement W 56,163 56,163 4 Station 4 RTU(Remote Terminal Unit)Replacement(Partial CARRYOVER) R 148,888 80,653 (68,235) Total SCADA Projects New Customer Service Connections 12 Service Installations-Commercial/Industrial Customers ALL 6,574 63,074 56500 13 Service Installations-Residential Customers ALL 17,012 152,416 207,923 55,507 QTotal Service Connections 14 Routine Construction Various Routine Contraction ALL 80,346 1,212,071 988,211 (223,860) Total Construction Projects 159,863 1,6",805 2,929910 1,085,006 Other Protects 15 GIS 5,941 62,762 97,495 34,733 16 TmnsfovnerslCapecimm Annual Purchases 101,062 347,396 284,000 (63,391 17A Meter Annual Purchases 54,141 49,710 (4,431) 17B Meter Upgrade Project-(Partial CARRYOVER) 11,626 475,553 564,416 88,862 17C Meter Upgrade Project-Commercials 3.733 420,802 551.853 131,051 18 Purchase Vehicles 65.000 65,000 19 Purchase Line Department Vehicles 474,861 570.000 95.139 20 Purchase New Pole Dolly 12,000 12.000 21 Automated Building Systems 150,000 150,000 22 Engineering Analysis software 8 data conversion-(CARRYOVER) 76,789 76,789 23 Gaw Station Generator 55,000 55,000 24 Capital RepairsStationOne 400,000 400,000 25 New Carpeting 35,000 35,000 26 Water Heater Demand Response Technology 190,614 336,611 145,997 27 Hardware Upgrades 8,827 73,184 126.629 53,445 28 Software and Licensing 79,315 119,002 39,607 Total Other Projects 131,190 2,178,628 3,493,505 1,314,877 TOTAL FY 13 CAPITAL PROJECT EXPENDITURES 291,053 4,023,533 6423,416 2,399,883 ATTACHMENT 2 � � ` : ; • . • ° VON _ . [ } § § ! ; ! - - ) . \ \ . . ) ( f } } \ \ ! § } ; • l : , r In ; \ | ` ° ! ■ f § r ` @ \ � Ed > | ^ \ § Iv1 f § = ea wi - - ` ~ � ;g . . , > . : . \ \ \ Reading Municipal Light Department Engineering and Operations Monthly Report February 2013 FY 2013 Capital Plan E&O Construction-Svstem Proiects 1 Reconductoring of Essex Street, Lynnfield Center- No Activity. 2 4WI3 OH Reconductoring Project, West Street, Wilmington - Engineering Labor. 3 Upgrading of Old Lynnfield Center URDs - (Phase 1 Completed). Engineering Labor. work on specifications for Phase 2. 5 Shady Lane Drive Area, Wilmington - Reconductoring - Line Department.,make ready work. Install poles, and primary and secondary cable, and upgrade transformers. Energized new secondaries. 6 Federal Street, Wilmington - Reconductoring - Line Department., Pole framing and wiring for reconductoring. Primary wire pull for salt shed. Transfer UG subdivision into new primary. Station Upgrades 8 Station 4 Relay Replacement Project- Reading - No Activity. 9 Station 4 Getaway Replacement-4W I3- No Activity. SCADA Proiects 10 Station 5 RTU Replacement, Wilmington - No Activity. 4 Station 4 RTU Replacement- No Activity, New Customer Service Connections 12 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 replacements/installations, primary or secondary cable replacements/installations, etc. This portion of the project comes under routine construction. No Activity. March 21,2013 1 13 Service Installations—Residential Customers—This item includes new or upgraded overhead and underground services, temporary overhead services, and large underground development. Routine Construction: 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. Pole SeffinglTransfers $251,503 Maintenance Overhead/Underground $267,476 Projects Assigned as Required $234,484 Pole Damage includes knockdowns some reimbursable $70,837 Station Group $14,199 Hazmat/Oil Spills $727 Porcelain Cutout Replacement Program $0 Lighting Street Light Connections $17,976 Storm Trouble $132,804 Underground Subdivisions $43,914 ® Animal Guard Installation $31,440 Miscellaneous Capital Costs $146,710 TOTAL $1,212,071 'In the month of February, zero (0) cutouts were charged under this program. Approximately 22 cutouts were installed new or replaced because of damage making a total of 22 cutouts replaced this month. March 21,2013 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: 65.34 minutes RMLD four-year average outage (2006-2009): 50.98 minutes per outage On average, RMLD customers that experience an outage are restored in 65.34 minutes. 120.00 e 100.72 1DD.00 88.89 ...EEE 79.30 7662 80.00 g 60.00 — — b z 0 40.00 0 U 20.00 0.00 'Oro oti/ 0 0 ',yeti ClY +e �—Mwthq minutes per outage RMLD 12 month system average wtage G rabw 65.31 RMLDI year avers Dote Cu w5098200&2009 March 21,2013 3 System Average Interruption Frequency(SAIFI)—Measures how many outages each customer experiences per year on average. SAIFI =Total Number of Customers Interrupted a Total Number of Customers RMLD 12-month system average: 0.29 outages per year RMLD tour-year average outage frequency: 0.62 The graph below tracks the month-by-month SAIFI performance. 0.90 061 0.80 0 � 0.70 .69 0.60 6 0.50 m0.40 0.39 033 0.30 LL 0.20 7 1 .19 11 0.09 ® 0.10 0.00 IV 10 'go Goy t�7, 01 )f Qa` RMLD monthly outage frequency — RMLD 12 month system average outage frequenry.29 —RMLD 4 year average outage frequency.62(2008-2012) Months Between Interruptions(MBTI) Another view of the SAIFI data is the number of months RMLD customers have no interruptions. At this time, the average RMLD customer experiences an outage approximately every 41.4 months. March 21,2013 4 ® Dt: March 13, 2013 To: RMLB, Kevin Sullivan., Jeanne Foti Fr: Bob Fournier Sj: January 31, 2013 Report The results for the first seven months ending January 31, 2013, for the fiscal year 2013 will be summarized in the following paragraphs. 1)Change in Net Assets: (Page 3A) For the month of January, the net income or the positive change in net assets was $615,841, increasing the year to date net income to $2,305,881. The year to date budgeted net income was $1,300,120, resulting in net income being over budget by $1,005,761 or 77.4%. Actual year to date fuel revenue exceeded fuel expenses by $184,558. 2) Revenues: (Page I1 B) Year to date base revenues were under budget by $1,226,115 or 4.27%. Actual base revenues were$27.4 million compared to the budgeted amount of$28.6 million. ® 3) Expenses: (Page 12A) *Year to date purchased power base expense was under budget by$1,321,494 or 7.31%. Actual purchased power base costs were $16.7 million compared to the budgeted amount of$18.0 million. *Year to date operating and maintenance (O&M)expenses combined were over budget by $120,292 or 1.68%. Actual O&M expenses were$7.3 million compared to the budgeted amount of$7.1 million. *Depreciation expense and voluntary payments to the Towns were on budget. 4) Cash: (Page 9) *Operating Fund was at $11,243,242. * Capital Fund balance was at $3,043,039. * Rate Stabilization Fund was at $6,687,657. * Deferred Fuel Fund was at $2,454,602. * Energy Conservation Fund was at $228,018. 5) General Information: Year to date kwh sales (Page 5) were 423,859,725 which is 4.4 million kwh or 1.06%, ahead last year's actual figure. GA W revenues collected ytd were ® $423,744 bringing the total collected since inception to $1,720,828. 6) Budget Variance: Cumulatively, the five divisions were over budget by $124,130 or 1.09%. ATTACHMENT 3 FINANCIAL REPORT JANUARY 31 , 2013 ISSUE DATE : MARCH 13, 2013 TONS OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS-TYPE PROPRIETARY FUND 4AWSTATEMENT OF NET ASSETS /31/13 PREVIOUS YEAR CURRENT YEAR ASSETS CURRENT UNUtSTRICTRD CASH (SCH A P.9) 9,621,141.12 11,246,242.08 RESTRICTED CASH (SCH A P.9) 18,381,528.39 18.0]8,]65.04 RECEIVABLES, NET (SCH R P.10) 7,008,499.01 ],45],830.39 PREPAID MESSES (SCH B P.10) 2,210,522.49 1,581,926.88 INVENTORY 1,403,356.34 1,559,620.98 TOTAL CURRENT ASSETS 39.4]5.049.35 39.918.885.37 NONCURRENT INVESTMENT IN ASSOCIATED CO (SCH C P.]) 73,765.66 46,958.35 CAPITAL ASSETS, NET (SCH C P.2) 67,854,146.97 70,267,391.39 TOTAL NONCURRENT ASSETS 67.937,912.63 70,314,349.64 TOTAL ASSETS 307.151.961.98 110.]33,235.01 LIABILITIES CURRENT ACCOUNTS PAYABLE 6,170,495.64 5,798,865.28 CUSTOMER DEPOSITS 604,368.69 678,775.42 CUSTOMER ADVANCES FOR CONSTRUCTION 194,339.94 401,932.15 ACCRUED LIABILITIES 1,113,383.70 1,527,360.54 TOTAL CURRENT LIABILITIES 8,J90.40i.9i 8.406.933.39 NONCURRENT ACCRUED MLOYR6 COMPENSATED ABSENCES 1,934,690.50 2,986,360.21 TOTAL NONCURRENT LIABILITIES ].9]4.690.50 2,986,360.21 TOTAL LIABILITIES 13.]]5.106.55 11.393,293.60 NET ASSETS INVESTED IN CAPITAL ASSETS, NET OF RELATED DEBT 67,054,146.97 70,167,391.29 RESTRICTED FOR DEPRECIATION FUND (P.9) 41010.961.89 3,043,039.84 UNRSSTRI CTBD 24,161,746.57 ]5,529,510.]8 TOTAL NET ASSETS (P.3) 96.0]7.855.43 98,839.941.41 TOTAL LIABILITIES AND NET ASSETS l0i.J53.961.98 130.33J.2J5,01 Ill TOM OF RRADINO, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT NONCURR ASSET SCHEDULE • 1/31/13 SCNeOULe C PREVIOUS YEAR CURRENT YGR SCHEDULE OF INVESTXRNTS IN ASSOCIATED COMPANIES NEW ENGLAND HYDRO ELECTRIC 15,]6].66 2,975.74 NEW ENGLAND HYDRO TRANSMISSION 58,018.02 63,983.61 TOTAL INVESTMENTS IN ASSOCIATED COMPANIES ]3.]65.66 46,958.35 SCHEDULE OF CAPITAL ASSETS LAND 1,265,862.23 1,365,862.23 STRUCTURES AND IMPROVEMENTS 6,585,553.36 6,]93,]26.53 EQUIPMENT AND FURNISMINGS 12,930,160.56 13,051,889.95 INFRASTRUCTURE 6].0]2,610.86 69.156.936.5E TOTAL CAPITAL ASSETS, NET6],856,166.9] 70.261.391.29 TOTAL NONCURRENT ASSETS 6].92].912.63 ]0.316.369.66 TOWN OF READING. MASSACHUSETTS NONICIPAL LIGHT DePAATNBNt 8USIN888-TYPR PROPRIETARY POND STATEMENT OF REV8NUXS, EXPENSES AND CRA.YOE9 IN FORD NET ASSETS 1/31/13 MOMS MONTE LAST FRAE CURRENT YEAR YTD \ OPERATING REVENUES: (9CN D P.11) N LABS YEAR CORRS YEAR TO DATE TO DATE CRANOR EASE REVENUE 3,]45,2]2.26 3,658,287.70 27,200,962.22 27,458,000.00 0.65% FUEL REVENGE 3,114,395.49 3,076,267.45 22,542,50.15 21,087,222.13 -6.6% PDRCMA9N POWER CAPACITY (10,759.23) 169,473.07 (79,673.49) 1,203,664.41 -1711.16% FORFEITED DIBCOUNT9 87,893.05 961411.BG 566,459.20 607,232.02 7.20% =RGY CONSERVATION REPNOR 55,711.95 55,052.68 353,207.69 417,296.73 18.14% DAN REVENUE 56,637.77 55,945.06 419,402.62 423,744.27 1.04% NYPA CREDIT 151.411.301 (70,691.53) (397.814.54) (363.955.93) -5.51% TOTAL OPERATING RRVNDH9 6,997,689.99 7,040,746.19 50,685,090.93 50,913,203.63 0.45% OPERATING EXPENSES: (SCE E P.12) PURCHASED POWER BASE 1,970,296.64 2,313,125.74 14,934,246.54 16.756,324.54 12.20% PUNCNA9N POWER FUEL 3,330,331.18 2,523.166.59 22,747,767.61 20,538,707.81 -9.71% OPERATING 452,931.67 021,500.47 4,969,115.69 5,765,300.31 16.02% MAINSNANCE 282,566.15 278,910.45 1,800,621.68 1,531,724.35 -14.93\ DEPRECIATION 296,027.47 305.469.18 2,072,192.29 2,138,284.26 3.19\ VOLUNTARY PAYMENTS TO TONS 111 000.00 114.000.00 787,186.00 791.303.00 0.53% TOTAL OPERATING EXPENSES 6,453,153.11 6,356,180.43 47,311,129.81 47,521,724.27 0.45% ({,, OPERATING INCOME 544,536.80 684,565.76 3,373,961.12 3,391,479.36 0.52\ `OPERATING REVENGES (EXPENSES) CONTRIBUTIONS IN AID OF CONST 3,975.90 708.84 37,629.64 47,187.79 25.40% RETURN ON INVESTMENT TO READING (183,829.75) (188,765.58) (1,256,808.25) (1,331,499.00) 2.70% INTEREST INCOME 3,867.39 2,194.31 60,559.01 19.460.49 -67.85% INTEREST EXPENSE (500.22) (250.50) (5,226.99) (2,858.35) -45.32% OTHER (MORE AND AMORT) 130,015.08 117,408.58 244,158.43 172,103.21 -29.51% .IAS. NONOPERATIND REV (UP) (46,471.60) (68.724.35) (949.688.16) 11.095.597.54) 14.31% CHANGE IN NET ASSETS 498.065.20 615.841.41 1.424,272.96 2,305,881.42 -4.08% NET ASSETS AT BEGINNING Of YEAR 93,603,502.47 96.534,059.99 3.13% .I ASSETS AT END OT SANDART 96.027.855.43 98.BJ9.941.41 2.93% Ill TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS-TYPE PROPRIETARY FORD • STATEMENT OF REVENUES, EXPENSES AND CHANCES IN FORD NET ASSETS 1/31/13 ACTUAL SUZUKI } YEAR TO DATE YEAR TO DATE VARIANCE• CHANGE OPERATING REVENUES: (SCH P P.11B) BABE REVENUE 27,458,000.00 28,684,115.00 (1,226,115.00) -4.17} PURL REVENUE 21,087,222.13 19,109,629.00 1,977,593.13 10.35} PURCHASED POWER CAPACITY 1,283,664.41 1.307,416.00 (23.751.59) -1.82} FORFEITED DISCOUNTS 607,132.02 531,050.00 (23,817.98) -3.77} ENERGY CONSERVATION REVENUE 417,296.73 431,597.00 (14,300.27) -3.31} DAN REVENUE 423,744.27 431,597.00 (7,852.73) -1.82} NYPA CREDIT (363.955.93) (409.331.00) 44.375.07 -10.87} TOTAL OPERATING RBVENOEB 50,913,203.63 50,187,073.00 726,130.63 1.454 OPERATING BXPSNSES: (SCH 0 P.12A) PURCHASED POWER BASK 16,756,324.54 18.077,819.00 (1,321,494.46) -7.31} PURCHASED POWER FUEL 20,538.707.61 19,810,564.00 728,143.81 3.68} OPERATING 5,765,300.31 5,669,396.00 95,904.31 1.69} MAINTENANCE 1,531,734.35 1,507,336.00 24,388.35 1.63} DEPRECIATION 2,138,284.36 2,129,169.00 9,115.26 0.43} VOLUNTARY PAYMENTS TO TOWNS 791.383.00 798.000.00 (6.617.00) -0.83} TOTAL OPERATING EXPENSES 0,521,724.27 47,992,384.00 (470,559.73) .0.98% OPERATING INCOME 3,391,479.36 2,194,789.00 1,196,690.36 $4.52% • NONOPERATINO REVENUES (EXPENSES) CONTRIBUTIONS IN AID OF CONST 47,187.79 300,000.00 (253,811.11) -84.27} RETURN ON INVESTMENT TO READING (1,321,499.08) (1,321,250.00) (249.08) 0.02% INTEREST INCOME 19,468.49 58,331.00 (38,662.51) -66.62% INTEREST EXPENSE (2,858.35) (1,750.00) (1,108.35) 63.33} OTHER (915E AND AMORT) 172,103.21 70,000.00 102,103.21 145.86} TOTAL WOROPERATINC REV (EXP) (1.085.597.94) (894.669.00) (190.928.94) 21.34} CHANGE IN NET ASSETS 2,305,881.42 1,300,120.00 1,005,761.42 77.36} NET ASSETS AT BEGINNING OF YEAR 96,534,059.99 96,534,059.99 0.00 0.00% NET ASSETS AT END OF JANUARY 98.839.941.41 97.834,179.99 1.005.761.42 1.03% • 1 1 • ACTUAL UNDER BUDGET • ILI TOW OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT RECONCILIATION OF CAPITAL PONDS V 1/31/13 SOURCE OF CAPITAL FUNDS: DEPRECIATION FOND BALANCE 1/1/12 2,635,305.70 CONSTRUCTION FUND BALANCE 7/1/13 2,000,000.00 INTEREST ON DEPRECIATION POND FY 13 6,308.73 DEPRECIATION TRANSFER FY 13 3.138.386.36 TOTAL SOURCE OF CAPITAL PONDS 6,711,798.68 USE OF CAPITAL FUNDS: LESS PAID ADDITIONS TO PLANT THEO GANGARY 3,136758.86 GENERAL LEDGER CAPITAL FUNDS BALANCE 1/31/13 3.063.039.06 10 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SALES OF KILOWATT ROUES 1/31/13 MONTH HUNTS LAST YEAR CURRENT YEAR YYD 1 SALES OF ELECTRICITY: LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE RESIDENTIAL SALES 22,442,292 21,750,213 156,374,445 159,439,088 1.96% COMM. AND INDUSTRIAL SALES 31,431,195 31,468,422 245,234,771 346,614,313 0.57% PRIVATE STREET LIGHTING 73,295 72,807 510,436 512,643 0.43% TOTAL PRIVATE CONSUMERS 53.946,782 53,291.442 402,109,652 406.566.044 1.11% MUNICIPAL SALES: STREET LIGNTING 239,295 238,739 1,673,927 11666,601 -0.44% MUNICIPAL BUILDINGS 858,971 846,690 5,666,816 5,657,511 -0.16% TOTAL MUNICIPAL CONSUMERS 1.098,266 1,085.429 7,340,743 7.324,112 -0.23% SALES FOR RESALE 282,836 258,032 2,049,706 2,066,265 0.81% SCHOOL 1,316,235 1,297,463 7,900,456 7,903,304 0.04% TOTAL KILOWATT HOURS SOLD 56,644.119 55.932,366 419.400,557 423,859,725 1.06% • • TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTIGNT KILOWATT HOURS SOLD BY TOWN 1/31/13 TOTAL READING LYNHPIELD NO.READING WILMINGTON WORTH RESIDENTIAL 21,750,213 6,947,668 3,012,506 4,950,353 6,839,686 COKE 6 IND 31,468,4]] 4,192,163 250,081 4,921,661 22,104,51) PVT ST LIGHTS 72,807 13,585 1,360 20,860 3),00] PUB ST LIGHTS 238,739 60,536 32,500 41,176 84,527 HURT BLOOD 846,690 269,082 141,496 125,484 310,628 SALES/RESALE 258,032 258,032 0 0 0 SCHOOL 1,297,463 456,242 268,061 171,520 401,640 TOTAL 55,932.366 12,117.308 3.706.004 10,33 1.051 29.))8.000 YEAR TO DATE RESIDENTIAL 159,439,088 49,642,047 23,043,007 36,882,566 49,871,468 COMM 6 IND 246,614,313 30,814,223 1,897,354 38,033,748 175,868,988 PVT ST LIGHTS 512,643 95,095 9,520 149,152 258,876 PUB ST LIGHTS 11666,601 563,752 227,460 283,700 591,689 MUNI BLDOS 5,657,511 1,410,833 999,495 1,116,764 2,130,419 SALBS/RSSALB 2,066,265 2,066,265 0 0 0 SCHOOL 7,903,304 2,)92,52) 1,713,651 11000,320 21396,806 TOTAL 423.859,)]5 8).384.742 ]7.890,487 )).466,350 2]1.118.246 LAST YEAR TO DATE RESIDENTIAL 156,374,445 48,878,075 22,339,481 36,480,422 48,676,467 COMM A IND 245,224,))1 31,163,673 1,975,518 38,029,964 174,055,616 PVT ST LIGHTS 510,436 97,575 91510 149,664 253,677 FOR ST LIGHTS 1,6)3,92) 563,252 ]]7,102 279,240 604,333 (`I WUNI BLDGB 5,666,816 1,408,517 966,513 1,136,928 2,154,858 SALES/RREALE 2,049,706 2,049,706 0 0 0 SCHOOL 7,900,456 2,826,875 1,746,008 1,008,080 2,319,493 TOTAL 419.400,557 86.98),6)3 27.]64.342 )).081.]98 220,064.444 KILOWATT HOURS SOLD TO TOTAL TOTAL READING LYNNPIRLD NO.READINO WILMINGTON WORTH RESIDENTIAL 38.89% 12.42% 5.39% 8.85% 12.23% COMM R IND 56.26% 7.50% 0.45% 5.80% 39.51% PVT ST LIGHTS 0.13% 0.02% 0.00% 0.04% 0.07% PUB ST LIGHTS 0.43% 0.14% 0.06% 0.07% 0.10 MUNI BLOOD 1.51% 0.48% 0.25% 0.22% 0.56% SALES/RESALE 0.46% 0.46% 0.00% 0.00% 0.00% SCHOOL 2.32% 0.82% 0.48% 0.31% 0.71% TOTAL 100.00% 21.844 6.631 18.29% 53.24% YEAR TO DATE RESI08HTIAL 37.62% 11.71% 5.44% 8.70% 11.77% COHN R IMO 56.20% 7.27% 0.45% 8.97% 41.51% PVT ST LIGHTS 0.12% 0.02% 0.00% 0.04% 0.06% PUB ST LIGHTS 0.39% 0.13% 0.05% 0.07% 0.14% MUNI BL00D 1.33% 0.33% 0.24% 0.26% 0.50% SALES/RESALE 0.49% 0.49% 0.00% 0.00% 0.00% SCHOOL 1.05% 0.66% 0.40% 0.24% 0.55% TOTAL 100.00% 20.61% 6.58% 18.28% 54.53% LAST YEAR TO DATE RESIDBMIAL 37.29% 11.65% 5.33% 8.70% 11.61% COMM A INO 58.47% 7.43% 0.47% 9.07% 41.50% PVT ST LIGHTS 0.12% 0.02% 0.00% 0.04% 0.06% PUB ST LIGHTS 0.40% 0.13% 0.05% 0.07% 0.15% MUNI BLOOD 1.35% 0.34% 0.23% 0.27% 0.51% SALES/RESALE 0.49% 0.49% 0.00% 0.00% 0.00% SCHOOL 1.88% 0.67% 0.42% 0.24% 0.55% TOTAL 100.00% 20.73% 6 SO% 18.39% 54.38% 161 TOM OF READING, MASSACROSETTS MUNICIPAL LIGHT DEPARTMENT PORMDLA INCONE 1/31/13 TOTAL OPERATING REVENUES (P.3) 50,913,203.63 ADO: POLE RENTAL 0.00 INTEREST INCOME ON CUSTOMER DEPOSITS 810.18 LESS: OPERATING EXPENSES (P.3) (47,521,724.27) CUSTOMER 0EPOSIT INTEREST EXPENSE (2,856.35) PORINLA INCOME (LOSS) 3.389,111.19 • TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMRST GENERAL STATISTICS 1/31/13 NORTH OF MONTH OF CHANGE YEAR THXU SAN 2012 SAN 2013 2012 2013 TAN 2012 SAN 2013 BALE OF EWN (P.5) 56,611,119 55,932,366 -3.16% 1.06% 619,100,557 623,859,725 ENE PURCHASED 59,550,250 60,866,668 -2.87% 2.35% 433,579,697 443,719,116 AVE BABE COST PER RNH 0.033086 0.038003 -68.69% 9.63% 0.036666 0.037761 An BASE SALE PER ENE 0.066118 0.063531 3.62% -0.61% 0.065068 0.066781 AVE COST PER EWH 0.009165 0.079657 -5.67% -3.30% 0.086909 0.086015 AVE SALE PER EWH 0.121100 0.116937 -1.65% -3.59% 0.118797 0.116531 FUEL CHARGE REVENUE (P.3) 3,116,395.69 2,987,105.02 -10.36% -6.66% 22,512,567.15 21,081,222.13 LOAD FACTOR 76.56% 76.61% PEAR LOAD 106,558 108,799 �e� r'Oro O C) riWAI N U i N ro rm r. &� 42, J� !'N �aS •� tSS 3 14&1 Y ofa pate's i s p�7 pith pi °b p��b$ � S , ^ 1 ^) U') 1'b ') CD U') CD nCD W r� LO (N T— CD C) CD CD C) Q CD 6q Ef? UD Gq H} ER '� TOWN OF RRADINO, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCH®ULE OF CASH AND INVBETXENTE 1/31/13 SCHEDULE A PREVIOUS YEAR CURRENT YEAR UNRESTRICTED CASH CASH - OPERATING FUND 9,618,141.12 11,243,242.08 CASH - PETTY CASH 3,000.00 3,000.00 TOTAL UNRESTRICTED CASH 9.6]1.141.12 11.24fi.]4].OB RESTRICTED CASH CASH - DEPRECIATION POND 4,010,961.69 3,043,039.84 CASH - TOM PAYNE T 596,000.00 30],)85.50 CASH - DEFERRED FUEL RESERVE 2,45],189.)8 2,454,60].8) CASH - RATE STABILIZATION FUND 6,068,389.05 6,687,657.73 CASH - UNCOLLBCTIBLE ACCTS RESERVE 200,000.00 200,000.00 CASH - SIM LEAVE BENEFITS 2,952,851.04 ],986,)90.43 CASH - HAZARD WASTE RESERVE 150,000.00 150,000.00 CASH - CUSTOMER DEPOSITS 604,388.69 678,775.42 CASH - ENERGY CONSERVATION 1)3,))4.1] ]]3,018.09 CASH - OPEN 1,1)2,9)3.82 1,346,595.16 TOTAL RESTRICTED CASH 18.381,528.39 18.0)3,365.04 `rte TOTAL CASH BALANCE 28.002.669.51 ]9.334.50).12 191 T01M OR READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF ACCOUNTS RECEIVABLE 1/31/13 BCH®OLE E PREVIOUS YEAR CURRENT YEAR SCHEDULE OF ACCOUNTS RECEIVABLE RESIDENTIAL AND CONNERCIAL 3,298,034.16 3,714,477.21 ACCOUNTS RECEIVABLE - OTHER 1]3,]5].]4 351,376.04 ACCOUNTS RECEIVABLE - LIENS 68,665.99 44,306.37 ACCOUNTS RECEIVABLE - ENPLOYEE ADVANCES 893.14 892.14 SALES DISCOUNT LIABILITY (3]3,34].53) (147,159.94) RESERVE FOR UNCOLLECTIBLE ACCOUNTS (390.897.86) (136.898.16) TOTAL ACCOUNTS RECEIVABLE BILLED 3,978,304.64 2,536,893.56 UNBILLED ACCOUNTS RECEIVABLE 4,830,294.37 4,915,936.83 TOTAL ACCOUNTS RECEIVABLE, NET ].008.499.01 ],453.830.39 SCHEDULE OF PREPAYMENTS PREPAID INSURANCE 1,465,398.59 1,388,593.36 PREPAYMENT PURCHASED POWER 336,853.70 (351,433.19) PREPAYMENT PAS" 238.330.65 241,849.32 PREPAYMENT WATSON 155,415.85 188,383.79 PURCHASED POWER WOREING CAPITAL 14,533.70 14,523.70 TOTAL PREPAYMENT 2.210,512.49 1.581.926.88 AM Np ACCOUNTS RECEIVABLE AGING JANUARY 2013: RESIDENTIAL AND COMMERCIAL 3,734,477.21 LESS: SALES DISCOUNT LIABILITY 1247.159.941 GENERAL LEDGES BALANCE CURRENT 2,135,141.13 86.19% 30 DAYS 339,859.47 9.38% 60 DAYS 48,048.56 1.94% 90 DAYS 91156.86 0.37% OVER 90 DAYS 55.011.15 2.33% TOTAL 1.47].31].1] 100.00% IWI TOW OF READING, MASSACHUSETTS MUNICIPAL LIGHT DBPARTMRNT ( SCHEDULE OF OPRRATING REVENUE ``. 1/31/13 SCN80UL8 D HOSTS ROME LAST YEAR CURRENT! YEAR YTD % SALES OF ELECTRICITY: LAST YEAR CUNRRIT THAI, TO DATE TO DATE CHANGE RESIDENTIAL SALES 2,986,106.37 2,889,149.37 20,631,257.22 20,322,491.43 -1.50% CORS AND INDUSTRIAL SALES 3,545,526.02 3,526,727.37 2],056,60).04 26,190,297.21 -3.20% PRIVATE STREET LIGHTING 6,336.67 6,220.40 47,717.22 41,196.88 -13.66% TOTAL PRIVATE CONSUNERS 6.537,969.06 fi.122.09].f4 4].]35.581.48 46,553.985.52 -2.48% MUNICIPAL SALES: STREET LIGHTING 30,461.88 29,316.83 226,471.87 198,418.96 -12.39% MUNICIPAL BUILDINGS 104,255.50 101,903.38 690,109.80 658,093.28 -4.64% TOTAL MUNICIPAL CONSUNRRS 134.]1].38 131.220.21 916.581.67 856.512.24 -6.55% SALES POR RESALE 35,092.33 31,937.02 252,014.50 244,461.22 -3.00% SCHOOL 151,838.98 149,300.48 919,331.72 890,263.15 -3.16% SUE-TOTAL 6,859,61].]5 6,734,555.15 49,823,509.37 48,545,222.13 -2.57% PORPeITED DISCOUNTS 87,893.05 96,411.86 566,459.28 607,232.02 7.20% PURCHASED POWER CAPACITY (10,]59.231 169,4]3.0] (]9,6]3.49) 1,283,664.41 -1711.16% ENERGY CONSERVATION - RESIDENTIAL 22,452.71 21,763.78 132,998.64 159,527.31 19.95% ENERGY CONSERVATION - CONBIBRCIAL 33,259.24 33,288.90 220,209.05 25],]69.42 17.06% GAN REVENUE 56,637.77 55,945.06 419,402.62 423,]44.2] 1.04% SIVA CREDIT (51,411.30) (70,691.63) (397,814.54) (363,955.93) -8.51% TOTAL REVENUE 6.99].689.99 ].040.]46.19 50.685.090.93 50.913.203.63 0.45% TOM OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REPRNUE BY TOMN 1/31/23 TOTAL READING LYNNBISLD NO.RSADINO WILMINGTON MONTH RSSIDERNIAL 2,889,149.37 925,562.42 398,41].3] 657,095.14 908,074.44 INDUS/MUNI BLDG 3,628,630.75 530,745.25 47,135.26 582,784.98 2,467,965.26 PUS.ST.LIGHTS 29,316.83 9,580.30 3,795.53 51147.59 10,793.41 PRV.ST.LIGNTB 6,220.70 1,143.34 114.44 1,845.37 3,117.55 CO-OP RESALE 31,937.02 31,937.02 0.00 0.00 0.00 SCHOOL 149,300.48 52,777.63 30,596.71 20,190.44 45,735.70 TOTAL fi.]34,555.15 1,551,745.96 180.059.31 1.267.063.52 3.435.686.36 THIS YEAR TO DATE RESIDENTIAL 20,322,491.43 61352,962.92 2,919,089.95 4,695,143.55 61355,296.01 INDUS/MUNI BLDG 26,048,390.49 3,661,072.17 334,160.58 4,281,082.04 18,571,075.70 PUB.ST.LIGHTS 198,418.96 64,243.42 25,425.25 36,154.88 72,595.41 PRV.ST.LIGHTS 41,196.88 7,535.56 753.52 12,409.78 20,498.02 CO-OP RESALE 244,461.22 244,461.22 0.00 0.00 0.00 SCHOOL 890,263.15 317,217.32 190,737.90 315,908.20 266,399.73 TOTAL 48.545,111.1) 10.64].991.61 3.470.167.18 9.141.698.46 ]5.285,864 .88 LAST YEAR TO DATE: RESIDENTIAL 20,631,257.22 6,464,504.95 2,9]8,8]1.91 4,801,274.13 6,426,606.23 INDUS/MUNI BLDG 27,746,716.84 3,822,007.92 352,644.62 4,433,337.19 19,138,727.11 PUB.ST.LIGHTS 226,471.87 72,925.06 28,087.06 40,374.65 85,085.10 PRV.ST.LIOWS 47,717.12 8,917.68 873.00 14,702.26 23,224.28 CO-OP RESALE 152,014.50 252,014.50 0.00 0.00 0.00 SCHOOL 919,331.72 332,052.32 199,337.84 120,267.15 267,674.41 TOTAL 49,823.509.3] 10.95].4]].13 3.519.814.43 9.409.955.38 25,941,317.13 PERCENTAGE OF OPERATING INCOME TO TOTAL TOTAL READING LYNNPIELD NO.RRADING WILMINGTON MONTH RESIDENTIAL 42.90% 13.70 5.92% 9.76% 13.48% INDUS/MUNI BLDG 53.88% 7.99% 0.70% 8.65% 36.65% PUS.ST.LIGHYS 0.44% 0.14\ 0.06% 0.08% 0.16% PRV.ST.LIGHTS 0.09% 0.02\ 0.00% 0.03% 0.04% CO-OP RESALE 0.47% 0.47\ 0.00% 0.00% 0.00% SCHOOL 2.22% 0.78% 0.45% 0.30% 0.69% TOTAL 100.00% 23.03\ 7.13% 18.82% 51.0]1 THIS YEAR TO DATE RESIDENTIAL 41.86% 13.09% 6.01% 9.67% 13.09% INDUS/MUNI BLDG 55.31% 7.54% 0.69% 8.82% 38.26% PUB.ST.LIGHTS 0.41% 0.13% 0.05% 0.07% 0.16% PRV.ST.LIGHTS 0.09% 0.02% 0.00% 0.03% 0.04\ CO-OP RESALE 0.50% 0.50% 0.00% 0.00% 0.00% SCHOOL 1.63% 0.65% 0.39% 0.24% 0.55% TOTAL100.00\ 21.93% 7.14% 18.83% 53.10\ LAST YEAR TO DATE RESIDENTIAL 41.07% 12.84% 5.91% 9.49% 12.83% INDUS/ROHI BLDG 56.09% 7.62% 0.71% 8.98% 38.78% PUB.ST.LIGHTS 0.46% 0.15% 0.06% 0.08% 0.17 PRV.ST.LIGHTS 0.10% 0.02% 0.00\ 0.03% 0.05 CO-OP RESALE 0.50% 0.50% 0.00% 0.00% 0.00% SCHOOL 1.78% 0.64% 0.39% 0.23% 0.52% TOTAL 100.00% 31.77% 7.07! SB.Blt 111A1 TOW OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTNORT BUDGETED REVENUE VARIANCE REPORT 140 /31/13 SCHEDULE P ACTUAL BUDGET % SALES OF ELECTRICITY: YEAR TO DATE YEAR TO DATE VARIANCE • CIGNOE RESIDENTIAL 12,386,197.66 12.963,589.00 (5]],391.34) -4.45% CORN AND INDUSTRIAL SALES PRIVATE STREET LIGHTING 14,322,614.90 14,928,493.00 (605,878.10) -4.06% MUNICIPAL BUILDINGS PUBLIC STREET LIGHTING 115,0]].15 118,227.00 (3,149.85) -2.66% SALES FOR RESALE 142,033.13 169,763.00 (2],]29.8]) -16.33% SCHOOL 492,077.16 504.043 00 (11.965 84) -2.37% TOTAL EASE SALES 37,458,000.00 28,684,115.00 (1,326,115.00) -4.27% TOTAL FUEL SALES 21.087.222.13 19,109,629.00 1.9]],593.13 10.35% TOTAL OPERATING REVENUE 48,545,222.13 47,793,744.00 751,478.13 1.57% FORFEITED DISCOUNTS 607,232.02 631,050.00 (23,817.98) -3.77% PURCHASED POWER CAPACITY 1,263,664.41 1,307,416.00 (23,751.59) -1.82% ENERGY CONSERVATION - RESIDENTIAL 159,527.31 160,782.00 (1,254.69) -0.78% ENERGY CONSERVATION - COMMERCIAL 357,769.42 270,815.00 (13,045.58) -4.82% GAN REVENUE 433,744.27 431,597.00 (7,852.]3) -1.82% PASNY CREDIT (363,955.93) (408,331.00) 44,375.07 -10.87% TOTAL OPERATING REVENUES 50,913.203.63 SO.15].0]3.00 __T26 1.45% 1 I ACTUAL ORDER BUDGET TOMS OF READING, MAMACMOBBTTB MUNICIPAL LIM URBANTWONT SCHEDULE OF OPERATING EXPENSES 1/31/13 SCHEDULE 8 MONTH MONTS LAST YEAR CURRENT YEAR PTO 1 OPERATION EXPENSES: LAST FORM CURRENT YEAR TO DATE TO DATE CHANGE PURCHASED POWER BASE EXPENSE 1,970 296.64 2,313.125.94 14,934 246.54 16,756,324.54 13.30% OPERATION SUP AND MOINERRING EXP 32,507.31 39,914.20 309,702.74 299,498.24 -3.29% STATION SUP LABOR AND MISC 7,736.16 7,696.39 66,914.43 44.092.81 -34.11% LINE RISC LABOR ANO EXPRESS 38.506.15 62,418.60 384,941.18 400,433.80 4.02% STATION LABOR AND EXPENSE 29.667.64 43.335.68 282,853.46 317,214.49 12.15% STREET LIGHTING EXPENSE 14,177.67 9,748.55 68,081.51 48,837.26 -26.28% METER EXPENSE 6,080.36 18,345.70 150,325.95 110,515.47 -26.48% MISC DISTRIBUTION EXPENSE 25,739.70 30,326.14 194,912.25 201,229.35 3.24% WATER READING LABOR 6 EXPENSE 6,977.37 7.115.70 53,854.07 52,402.29 -2.70% ACCT R COLL LABOR A EXPENSE 112,805.63 125,758.47 811,869.78 880,951.87 8.51% UNCOLLRCTIBLE ACCOUNTS 16,000.00 8,333.33 112.000.00 58,333.31 -47.92% XMW AUDIT EXPENSE 30,615.79 53.563.94 262,482.13 288,454.98 9.90% ADMIN A GEN SALARIES 55.022.95 77,020.95 437,113.65 456,951.12 4.54% OFFICE SUPPLIES A EXPENSE 19.168.89 25.443.87 126,641.10 143.783.77 13.54% OUTSIDE SERVICES 36,302.15 52.961.81 223,657.00 252,062.90 12.70% PROPERTY INSURANCE 23.265.13 22,936.17 210,567.B4 213.253.59 -2.43% INJURIES AND DAMAGES 3,968.18 4,849.05 7,926.23 28,051.34 253.91% EMPLOYEES PENSIONS A BENEFITS (62,284.63) 164,706.93 682,198.42 1,260,881.14 84.83% RISC GENERAL EXPENSE 9,144.80 6,445.08 120,960.38 106,858.82 -11.66% RENT EXPENSE 5,695.29 15,313.91 103,891.72 119,064.09 14.60% ENBaOY CONSERVATION 39,035.13 45,265.80 350.221.85 482,439.67 37.75% TOTAL OPERATION EXPENSES 452,931.67 821.500.47 4.969.115.69 5,765.300.31 16.02% MAINTENANCE EIPMSES: • SAINT OF TRANSMISSION PLANT 227.08 227.08 11589.58 11599.58 0.00% SAINT OF STRUCT AND EGUSPMT 76,364.71 16,067.16 188,042.40 81,299.14 -56.77% PAINT OF LINES - ON 140,399.83 141,717.47 1,070,013.21 906,066.89 -15.32% SAINT OF LINES - UG 9.400.19 18,675.63 115,281.36 97,547.63 -15.38% SAINT OF LIPS TRANSFORMHAS (8.389.19) 43,739.35 31.187.43 77,726.50 149.22% SAINT OF ST IT A BIO SYSTEM (48.03) (8.23) (350.51) (258.30) -26.31% MINT OP GARAGE AND STOCKROOM 49.669.05 42,065.56 298,546.82 200,867.94 -5.92% MINT OP MIMS 9.454.55 2,125.44 49,608.01 21,022.99 -57.62% MINT OF OEM PLANT 5.489.96 14,288.99 46,703.39 65,861.90 41.02% TOTAL MINTINANCE EXPENSES 282,566.15 278.919.45 1.800.621.69 1.531.724.35 -14.93% DEPRECIATION EXPENSE 296,027.47 305,469.18 2,072,192.29 2,138,284.26 3.19% PURCHASED RONBE FUEL EXPENSE 3,338,331.18 2.523.166.59 22,747,767.61 20,538,707.81 -9.71% VOLUNTARY PAYMeMI TO TOMS 113,000.00 114,000.00 787.186.00 791.383.00 0.53% TOTAL OPERATING EXPENSES 6,453.153.11 6.356.180.43 47,311.129.81 47.521.724.27 0.45% TOWN OF READING, NASSACROSETTS MUNICIPAL LIGHT DBPARTNEM BUDGETED OPERATING EXPENSE VARIANCE REPORT 1/31/13 SCHEDULE G ACTUAL BUDGET OPERATION EXPENSES: YRAR TO DATE YEAR TO DATE VARIANCE • CHARGE PURCHASED POWER BASE EXPENSE 16.356.329.54 18.0)).819.00 11,333.494.161 -7.31% OPERATION BUT AND ENGINEERING EXP 399,498.34 375,242.00 24,256.24 8.81% STATION SUP LABOR AND RISC 44,092.61 46,847.00 (3,754.19) -5.88% LINE NISC LABOR AND EXPENSE 400,433.80 38),36).00 13,066.00 3.37% STATION LABOR AND EXPENSE 317,214.49 363,909.00 53,305.49 20.20% STREET LIGHTING EXPENSE 48,827.26 48,596.00 231.26 0.48% WHIRR EXPENSE 110,515.97 99,015.00 11,500.47 11.61% RISC DISTRIBUTION EXPENSE 201,339.35 212,433.00 (11,202.65) -5.27% WRIER READING LABOR i EXPENSE 52,402.29 56,888.00 (4,485.71) -7.89% ACCT F COLL LABOR 6 EXPENSE 080,951.87 806,759.00 74,192.87 9.30% UNCOLLECTIBLE ACCOUNTS 58,333.31 58,331.00 3.31 0.00% ENERGY AUDIT EXPENSE 288,454.98 383,515.00 4,939.98 1.74% BONIN R GEN SALARIES 456,951.13 440,815.00 16,136.12 3.66% OFFICE SUPPLIES F EXPENSE 143,783.77 148,274.00 (4,490.33) -3.03% OUTSIDE SERVICES 252,062.90 369,433.00 (117,370.10) -31.77% PROPERTY INSURANCE 213,253.59 375,051.00 (61,797.41) -33.47% INJURIES AND DANAGES 28,051.34 33,231.00 (51179.66) -15.59% ERPLOYRES PENSIONS 6 BENEFITS 1,360,801.14 1,183,307.00 77,574.14 6.56% MISC GENERAL EXPENSE 106,858.83 141,025.00 (34,166.18) -24.33% REM EXPENSE 119,064.09 133,669.00 14,604.911 -3.73% ENERGY CONSERVATION 482,439.67 415,690.00 66,749.67 16.06% TOTAL OPERATION EXPENSES 5.765.300.31 5,669.396.00 95,904.31 1.69% MAINTENANCE EXPENSES: low NAINT OF TRANSMISSION PLANT 1,589.58 1,750.00 (160.42) -9.17% HAIM OF BIRO= AND RQUIPMBNT 81,299.14 68,156.00 13,143.14 19.28% NAINT OF LINES - ON 906,O66.89 701,490.00 204,576.89 29.16% WAINT OF LINES - UG 97,547.63 96,759.00 788.63 0.63% WAINT OF LINE TRANSPORNERS 77,726.50 126,199.00 (48,472.50) -38.41% WAINT OF ST IT 6 SIG SYSTEN (258.30) 5,656.00 (5,914.30) -104.57% HAINT OF GARAGE AND STOCKROOM 280,867.94 390,524.00 (109,656.06) -28.08% MAIM OF NETERS 31,022.99 40,320.00 (19,397.01) -47.66% MAIM OP GER PLAM 65,861.98 76,402.00 (10,630.03) -13.89% TOTAL NAIMENANCE EXPENSES 1.531.)34.]5 1.507.336 00 24.388.35 1.63% DEPRECIATION EXPENSE 3,138,284.36 2,129,169.00 91115.26 0.43% PURCHASED POWER FUEL EXPENSE 30,538,707.61 19,810,564.00 728,143.81 3.68% VOLUNTARY PAYMENTS TO TOWNS 791,383.00 798,000.00 (6,617.00) -0.83% TOTAL OPERATING EXPENSES 4).5]1,)]4.37 4).993,384.00 (4)0.559.73) -0.98% • ( 1 AC`UAL UNDER BODGM Ill Al TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED OPERATING EXPENSE VARIANCE REPORT 1/31/13 RESPONSIBLE REMAINING SENIOR 2013 ACTUAL BUDGET REMAINING OPERATION EXPENSES: MANAGER ANNUAL BUDGET YEAR TO DATE BALANCE BUDGET % PURCHASED POWER BASE EXPENSE JP 30,103.743.00 16,756,324.54 13.346,417.46 44.34% OPERATION SUP AND ENGINEERING EXP AS 468,949.00 299,498.24 169,450.76 36.13% STATION SUP LABOR AND MISC RS 79,813.00 44,092.81 35,720.19 44.754 LINE MISC LABOR AND EXPENSE HS 671,309.00 400.433.80 270,875.20 40.354 STATION LABOR AND EXPENSE AS 448,249.00 317,314.49 131,034.51 39.53% STREET LIGHTING EXPENSE KS 83,106.00 48,827.26 34,378.74 41.25% !BIER EXPENSE XS 197,339.00 110,515.47 86,813.53 43.99% MISC DISTRIBUTION EXPENSE KS 366,489.00 201,229.35 165,259.65 45.09% MIER READING LABOR i EXPENSE XE 69,946.00 52,402.29 17,543.71 25.08% ACCT A COLL LABOR A EXPENSE RR 1,385,210.00 880,951.87 504,258.13 36.40% UNCOLLECTIBLE ACCOUNTS RR 100,000.00 58,333.31 41,666.69 41.67% ENERGY AUDIT EXPENSE JP 479,013.00 288,454.98 190,558.02 39.78% ADMIN A GEN SALARIES VC 761,068.00 456,951.13 304,116.88 39.96% OFFICE SUPPLIES R EXPENSE VC 253,950.00 143,783.77 110,166.33 43.38% OUTSIDE SERVICES VC 507,125.00 252,063.90 255,063.10 50.30% PROPERTY INSURANCE KS 471,500.00 213,353.59 258,846.41 54.77% INJURIES AND DAMAGES KS 56,619.00 88,051.34 28,567.66 50.46% EMPLOYEES PENSIONS 6 BENEFITS AS 1,889,623.00 1.360,881.14 628,741.86 33.27% MISC GENERAL EXPENSE VC 200,785.00 106,858.62 93,926.18 46.78% REST EXPENSE HS 212,000.00 119,064.09 98,935.91 43.84% ENERGY CONSERVATION JP 697,983.00 482,439.67 215,543.33 30.88% TOTAL OPERATION EXPENSES 8,833.105.00 5.765.300.31 3,634,765.69 41.20% MAINTENANCE EXPENSES: • MAINT OF TRANSMISSION PLANT XS 31000.00 11589.58 1,410.43 47.01% MAINT OF BIRO= AND EQUIPMT XS 114,130.00 81,299.14 33,830.86 28.76% SAINT OF LINES - ON XS 1,350,481.00 906,066.89 344,354.11 27.544 MAINT OF LINES - UG XS 885.371.00 97,547.63 187,023.37 65.824 MINT OF LINE TRANSPOWSR5 XS 198.500.00 77,736.50 110,773.50 58.77% MAINT OF ST IT A SIG SYSTEM XS 9,694.00 (358.30) 9,948.30 102.67% SAINT OF GARAGE AND STOCKROOM XS 678,589.00 280,867.94 391,721.06 58.34% SAINT OF METERS XS 47,392.00 81,022.99 86,369.01 55.64% SAINT OF GEN PLANT RP 131,320.00 65,861.98 65,458.02 49.85% TOTAL MAINTENANCE EXPENSES 2,817.401.00 1.531.724.35 1.170.672 65 41.55% DEPRECIATION EXPENSE RF 3,650,000.00 6,138,284.26 1,511,715.74 41.42% PURCHASED POWER FUEL EXPENSE JP 30,500,000.00 60,538,707.81 9,961,293.19 32.66% VOLUNTARY PAYMENTS TO TONNE RP 1.368,000.00 791,383.00 576,617.00 42.15% TOTAL OPERATING EXPENSES 83.767.500.0047.531.724.27 30.201.480.73 36.05% • Ilial TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT PROFESSIONAL SERVICES 1/31/2013 PROFESSIONAL SERVICES BY PROJECT ITEM DEPARTMENT ACTUAL BUDGET VARIANCE 1 RMLD AND PENSION TRUST AUDIT FEES ACCOUNTING 32,750.00 32,150.00 500.00 2 PENSION ACTUARIAL EVALUATION ACCOUNTING 3,750.00 0.00 3,750.00 3 LEGAL- PBRC/ISO ISSUES ENERGY SERVICE 0.00 10,500.00 (10,500.001 4 LEGAL- POWER SUPPLY 288068 ENERGY SERVICE 18.085.00 26,250.00 (8,164.10) 5 PROFESSIONAL SERVICES ENERGY SERVICE 9,939.80 14,000.00 (4,060.20) 6 NERC COMPLIANCE AND AUDIT E 6 0 7,995.00 10,050.00 (2,855.00) 7 LOAD CAPACITY STUDY ENGINEERING 0.00 11,250.00 (11,250.00) 8 STROM BANISHING STUDY ENGINEERING 0.00 50,000.00 (50,000.00) 9 LEGAL-GENERAL, MMWEC AUDIT ON 63,000.78 87,500.00 (24,499.22) 10 LEGAL SERVICES-GENERAL BR 61,O37.8O 39,600.00 21,437.80 11 LEGAL SERVICES-NEGOTIATIONS NR 27,504.42 36,800.00 (9,215.50) 12 LEGAL GENERAL BLDG. MAINT. 10,300.90 875.00 9,425.90 13 SURVEY RIGHT OF NAY BLDG. MAINT. 0.00 2,919.00 (2,919.00) 14 ENVIRONMENTAL BLDG. MAINT. 0.00 2,919.00 (21919.00) 15 ENGINEERING SERVICES BLDG. MAINT. 14,118.05 4,970.00 9,148.05 16 REPAIR RAMP AND DECK AREA BLDG. MAINT. 0.00 30,000.00 (30,000.00) 17 INSURANCE CONSULTANT GEM. BENEFIT 0.00 5,031.00 (5,831.00) 18 LEGAL GEN. BENEFIT 0.00 2,919.00 (2,919.00) 19 SITE ASSESSMENT FOR MAJOR UPGRADE ACCOUNTING 2,O56.27 0.00 2,056.27 20 GENERAL BANKRUPTCY ACCOUNTING 1,144.00 0.00 1.444 00 TOTAL 2512!101612!50 369,433.00 1117,370.10) PROFESSIONAL SERVICES BY VENDOR ACTUAL MILANSON HEATH R COMPANY 32,750.00 HUDSON RIVER ENERGY GROUP 2,895.00 STORE CONSULTING INC. 3,750.00 ROBIN AND RODMAN 35,6O3.16 UTILITY SERVICES INC. 7,995.00 DUNCAN 6 ALLEN 57,228.32 CHOATE HALL 6 STEWART 81,311.31 MENDERS TORREY 6 SPENCER 12,385.55 RICHARD HIGGINS ARBITRATOR 2,710.00 GREAT WOOTERS ARBITRATOR 2,062.00 MICHAEL BROOM ARBITRATOR 2,538.99 CHREC 7,044.00 JM ASSOCIATES 1,732.50 COGSDALE 2,056.27 TOTAL 252,062.90 (13) RMLD BUDGET VARIANCE REPORT FOR PERIOD ENDING JANUARY 31, 2013 DIVISION ACTUAL BUDGET VARIANCE CHANGE ENGINEERING AND OPERATIONS 2,553,105 2,408,678 144,427 6.00% ENERGY SERVICES 800,076 750,249 49,827 6.64% GENERAL MANAGER 524,100 548,449 (24,349) -4.44% FACILITY MANAGER 2,210,284 2,329,382 (119,097) -5.11% BUSINESS DIVISION 5,463,464 5,390,141 73,322 1.36% SUB-TOTAL 11,551,030 11,426,899 124,130 1.09% PURCHASED POWER - BASE 16,756,325 18,071,819 (1,321,494) -7.31% PURCHASED POWER - FUEL 20,538,708 19,810,564 728,144 3.68% TOTAL 48,846,O62 49,315,282 (469,220) -0.95% RMLD DEFERRED PURL CASH RESERVE ANALYSIS 1/31/13 GROSS MONTELY TOTAL DATE CHARGES REVDNUES NYPA CREDIT DEFERRED DEFERRED Jun-12 2,2]0,Of 4.98 Jul-12 3,581,715.38 3,492,893.61 (61,106.90) (149,9]8.5]) 2,120,065.91 Aug-12 3,578,611.20 2,914,978.35 (44,365.80) (707,998.65) 1,412,06].26 Sap-12 2,646,309.32 3,986,749.45 (47,478.80) 792,961.33 2,205,028.59 Oct-12 2,595,375.45 2,389,147.98 (48,781.28) (255,OOB.75) 1,950,019.84 Nov-12 2,]44,81].28 2,740,129.47 (22,566.16) (27,253.97) 1,922,765.8] Dec-12 2,868,712.69 2,987,105.82 (68,965.36) 49,42].]7 1,972,193.64 Jan-13 2,523,166.59 3,076,267.45 (70,691.63) 482,409.23 2,454,602.87 AMLD STAFFING REPORT FOR FISCAL YEAR ENDING JUNE, 2013 13 BUD JUL AUG SEP OCT NOV DEC TAN TOTAL 12 12 12 12 12 12 13 GmN___- NANAGEB GENERAL MANAGER 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 RONAN RESOURCES 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 COMMUNITY RELATIONS 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 TOTAL 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 BUSINESS ACCOUNTING 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 CUSTONER SERVICE •• 7.75 7.75 7.75 7.75 7.75 7.75 7.75 7.75 NONT•INFORMATION SYS • 6.25 6.00 6.00 6.00 6.00 6.00 6.00 6.00 NISCELLANEOUS 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 TOTAL 17.00 16.75 16.75 16.75 16.15 16.75 16.75 16.75 BNOINEERING S OPEAATION9 AGN E4O 2.00 2.00 1.00 1.00 1.00 1.00 2.00 2.00 ENGINEERING 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 LINE 21.00 21.00 21.00 21.00 21.00 21.00 21.00 21.00 METER 4.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 STATION 8.00 8.00 8.00 8.00 8.00 8.00 E.DG 8.00 TOTAL 40.00 39.00 38.00 38.00 38.00 38.00 39.00 39.00 PROTECT BUILDING 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2• GENERAL BENEFITS 2.00 1.00 2.00 2.00 2.00 2.00 2.00 2 TRANSPORTATION - - _ _ _ NATERIALS NGNT 4.00 3.00 4.00 4.00 4.00 4.00 4.00 4.00 TOTAL 8.00 6.00 8.00 8.00 8.00 8.00 8.00 8.00 ENERGY MVICBS ENERGY SERVICES • 5.50 4.50 4.50 4.50 4.50 4.50 4.50 5.50 TOTAL 5.50 4.50 4.50 4.50 4.50 4.50 4.50 5.50 RNID TOTAL 74.50 70.25 71.25 71.25 71.25 71.25 72.25 73.25 COSTRACTORS UG LINE 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 TOTAL 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 GRAND TOTAL 76.50 72.25 73.25 73.25 73.25 73.25 74.25 75.25 • og Mme Light ( � RELIABLE RENRTw.& Q - 230 Mh Saed P.O.Box 150 Read.&MA 01867.0250 1b1:(781)944-1340 PER:(781)942-2409 Web:www.mdd.com March 22,2013 Town of Reading Municipal Light Board Subject Pick Up Truck with Lift Gate On March 6, 2013 a bid invitation was placed as a legal notice in the Reading Chronicle, Lynnfield Villager, North Reading Transcript and Wilmington Town Crier requesting proposals for one Pick Up Truck with Lift Gate for the Reading Municipal Light Department. An invitation to bid was sent to the following 11 companies: Bunnell Motors,Inc. Central Dodge,Inc. Inter-State Ford Truck Sales,Inc. Lannon Chevrolet Liberty Chevrolet Inc. MHQ Municipal Vehicles Moore GMC Truck,Inc. Place Motors,Inc. Sentry Ford ® Stoneham Motor Co.,Inc. Woburn Foreign Motors Bids were received from five companies; Bonnell Motors, Inc., Central Dodge, Inc., Liberty Chevrolet Inc., Moore GMC Truck,Inc.and Stoneham Motor Co.,Inc. The bids were publicly opened and read aloud at 11:00 a.m. March 20, 2013 in the Town of Reading Municipal Light Department's Audio Visual Spurr Room,230 Ash Street,Reading, Massachusetts. The bids were reviewed, analyzed and evaluated by the Interim General Manager and the staff. Move that bid 2013-27 for: one Pick Up Truck with Lift Gate be awarded to: Bunnell Motors,Inc.for$28,850.00 as the lowest qualified and responsive bidder on the recommendation of the Interim General Manager. The FY2013 Capital Budget amount for this item is$30,000.00. Kev Sulhva_ n David Polson Paula O'Leary • ATTACHMENT 4 � ! . § t � # A ) ! ! � ! ! \ k EEEEE . - - } 88sS ■ / } \ \ # ! 2 ! „ luV1T T CO) RradivB Muvidpd Light Departatnl LL neuwece eowu eoe cexenwrsons 270 Ah S P.O.Box 15050 Reading,MA 0186740250 Tel:(781)91.41340 Fu:(791)942-2409 Web:www.mdd.com March 22,2013 Town of Reading Municipal Light Board Subject: Pick Up Truck with Plow On March 6, 2013 a bid invitation was placed as a legal notice in the Reading Chronicle, Lynnfield Villager, North Reading Transcript and Wilmington Town Crier requesting proposals for one Pick Up Truck with Plow for the Reading Municipal Light Department. An invitation to bid was sent to the following 11 companies: Bonnell Motors,Inc. Central Dodge,Inc. Inter-State Ford Truck Sales,Inc. Lannon Chevrolet Liberty Chevrolet Inc. MHQ Municipal Vehicles Moore CMC Truck,Inc. Place Motors,Inc. Sentry Ford Stoneham Motor Co.,Inc. Woburn Foreign Motors Bids were received from five companies; Bonnell Motors, Inc., Central Dodge, Inc., Liberty Chevrolet Inc., Moore GMC Truck,Inc.and Stoneham Motor Co.,Inc. The bids were publicly opened and read aloud at 11:00 a.m. March 20, 2013 in the Town of Reading Municipal Light Department's Audio Visual Spurr Room,230 Ash Street,Reading,Massachusetts. The bids were reviewed, analyzed and evaluated by the Interim General Manager and the staff. Move that bid 2013-28 for: one Pick Up Truck with Plow be awarded to: Stoneham Motor Co.,Inc.for$31,003.00 as the lowest qualified and responsive bidder on the recommendation of the Interim General Manager. The FY2013 Capital Budget amount for this item is$35,000.00. Kevill?Sulliv n David Polson Paula O'Leary �- 0 � < � f � ! ] § # E $ ! k ! ! ! ! ! ! ( k ! ! i98S ! !#\ƒ ! | | \ \ ) � )|§) it§5 "I§§ - ,!§ HF. /! , , r ; !! . < ,!_ , ;1 . . , .!� ,,_ ... ,!= r� ■ ! No , ••- •- -. !! ��\ •- . , , , r >§| WE 4§6 >!p >)k NO /! § �•` �-` ! .), ! Jeanne Foti From: Jeanne Foti Sent: Monday, February 25,2013 7:05 AM To: Accounting Group Cc: Kevin Sullivan; Patricia Mellino Subject: Account Payable Warrant - Friday, February 22 Good morning. There were no Account Payable Warrant questions- Friday, February 22. Thanks. Jeanne Foti Reading Municipal Light Department Executive Assistant 230 Ash Street Reading, MA 01867 781-942-6434 Phone 781-942-2409 Fax alease consider the environment before printing this e-mail. l Jeanne Foti From: Jeanne Foti Sent: Tuesday, February 26, 2013 7:09 AM To: Accounting Group Cc: Kevin Sullivan; Patricia Mellino Subject: Payroll - February 25, 2013 Attachments: Payroll Suggestion - February 25, 2013.pdf Tracking: Recipient Delivery Read Accounting Group Kevin Sullivan Delivered.2/26/2013 7'.09 AM Patricia Mellino Delivered:2/26/2013 709 AM Read:2/26/2013 7'.39 AM bfournler@RMLD.com Delivered:2/26/20137'.10 AM skazanjian@RMLD.com Delivered,2/26/20137:10 AM wmarkiewicz@RMLD.com Delivered:2/26/20137.10 AM Wendy Markiewi¢ Read:2/26/2013 8'14 AM Bob Fournier Read:2/26/2013 840 AM Good morning. Please see attached Payroll suggestion from Commissioner Stempeck. Thanks. Jeanne Foti Reading Municipal Light Department Executive Assistant 230 Ash Street Reading, MA 01867 781-942-6434 Phone 781-942-2409 Fax Please consider the environment before printing this e-mail. • PLEASE NOTE 1 COMMISSIONER STEMPECK AND BOB FOURNIEI HAVE DISCUSSED THIS. • I� Reading Municipal Light Department Payroll Removal Sheet Date Commissioner Payroll Y Comment Employee 2 2i ' l3 jlN � /7 ( q 7 1 ev 7ki- z, L k�J VP<a7' ti (Q/, C16,1, n s i�n.� � ;71, Vg'I C' kCPC i -n A-7 4-, 7r Uvc� Aft PLEASE NOTE: COMMISSIONER STEMPECK AND BOB FOURNIER HAVE DISCUSSED THIS. Jeanne Foti From: Kevin Sullivan Sent: Wednesday, March 06, 2013 3;18 PM To: Gina Snyder; RMLD Board Members Group Cc: Jeanne Foti; Bob Fournier; Dave Polson; Tom O'Connor; Peter Price Subject: RE:Account Payable Questions March 1 Please see responses to this week's A/P questions below. kCrur,1'u7 r an Engineering and Operations Manager Reading Municipal Light Department 781 942-6407 office From: Jeanne Fob Sent: Monday, March 04, 2013 8:46 AM To: Kevin Sullivan Subject: Account Payable Questions - March 1 Snyder 1. Century Bank—What are the lock box charges, messenger service,CD—ROM, web inquiry,data transmission+ unprocessable returns? These are costs associated with the payment collection processes of Century Bank. 2. Collins-P.O. Reminder-While an emergency on 2/15, should have been done PO same day. PO should have been created for an estimated amount when the service call was placed and adjusted when the actual amount was billed. Administrative staff was out of the office training on the day the service call was placed and the emergent nature of the call was not communicated. Instead the PO was created when the invoice was received for the actual value of the work performed. 3. Crowley-What was this for? This invoice was for work performed in connection with obtaining payment on recalcitrant pole damage reimbursements (3). Crowley also represented the RMLD in Woburn District Court twice. The RMLD has an additional pole damage cases that have not made it to court as of this writing. 4. Image Technology (-others) - P.O. Reminder! Bill date 1/25 PO 2/25. As with all invoices, we are working toward having a closer relationship between purchase order and invoice. Specifically, it was believed that the freight was not charged for the item delivered. I would term the reason that the timing of the purchase order does not match the invoice, an internal misunderstanding between the vendor and an employee. S. Office Depot-Why 2 copies of Windows Pro 8-don't we have a site license for discounted multiple users? Two copies were installed on two pc's. Microsoft does not give special discounts for multiple users. • 6. PURMA-P.O. Reminder! Invoice, 1/18, PO 2/26. This is a large sum net to have a PO! Mow did that happen? t Original invoice dated 1/18 was sent via email and misplaced until PURMA contacted RMLD on 2/26 to confirm the invoice was received. Once the situation was identified the PO was created without • delay. In the future PURMA should send invoices to Accounting for processing not individual email accounts. 7. Verizon—Is this phone number in use? These charges are for the mobile internet. S. Wilmington Police—No record of end time Voegelin+Nally 2/6 and on 2/15 it looks like Jepson+ Nally were charged from 8-noon to 8 to 1 to give 8 hours for 5 hours. The time for both Voegelin and Nally on 2/6/13 was 9:30am to 2:30pm. Jepson and Nally worked from Sam to Spm on 2/15/13. All four police officers were paid 8 hours because they all worked more than 4 hours. Per contract, more than 4 hours worked equals 8 hours pay for Wilmington Police details. Jeanne Foti Reading Municipal Light Department Executive Assistant 230 Ash Street Reading, MA 01867 781-942-6434 Phone 781-942-2409 Fax `rlease consider the environment before printing this e-mail. 2 Jeanne Foti From: Jeanne Foti • Sent: Monday, March 11, 2013 7:03 AM To: Accounting Group Cc: Kevin Sullivan; Patricia Mellino Subject: Account Payable Warrant - March 8 Tracking: RecipleM Delivery Read Accounting Group Kevin Sullivan Delivered:3/11/2013 704 AM Patricia Mellino Delivered.3/11/2013704 AM Read.3/11/20137:28 AM btounuer@RMLD.com Delivered'.3/11/2013704 AM skazanjian@RMLD.com Delivered.3/11/2013 7'.04 AM wmarkiewicz@RMLDcom Delivered 3/11/2013704 AM Good morning. There were no questions for the Account Payable Warrant- March 8. Thanks. • Jeanne Foti Reading Municipal Light Department Executive Assistant 230 Ash Street Reading, MA 01867 781-942-6434 Phone 781-942-2409 Fax Please consider the environment before printing this e-mail. 1 Jeanne Foti Wrom: Jeanne Foti sent: Tuesday, March 12, 2013 7:09 AM To: Accounting Group Cc Kevin Sullivan; Patricia Mellino Subject: Payroll - March 11 Tracking: Redirlet Delivery Accounting Group Kevin Sullivan Delivered:3/12/1013 7'.10 AM Patricia Melling Delivered:3/12/2013 710 AM Vournier@RMLD.com Delivered:3/12/2013 7:10 AM skazanjian@RMLD.com Delivered:3/12/20137:10 AM wmarkiewicz@RMLD.com Delivered.3/12/2013710 AM Good morning. There were no Payroll questions for March 11. Thanks. Unne Foti Reading Municipal Light Department Executive Assistant 230 Ash Street Reading, MA 01867 781-942-6434 Phone 781-942-2409 Fax Please consider the environment before printing this e-mail. 1 Jeanne Foti From: Jeanne Foti Sent: Monday, March 18, 2013 7:16 AM To: Accounting Group Cc: Kevin Sullivan; Patricia Mellino Subject: Account Payable Warrant - March 15 Tracking: Recipient Delivery Read Accounting Group Kevin Sullivan Delivered 3/18/2013 7:17 AM Read 3/18/2013 747 AM Patricia Mellino Delivered 3/18/20137:17 AM Read:3/19/20137:39 AM bfournier@RMLD.com Delivered:3/18/20137:17 AM skazanjian@RMLD.com Delivered:3/18/20137:17 AM wmarkiewi¢@RMLD.com Delivered:3/18/20137:17 AM Wendy Markiewicz Read:3/18/2013 7:48 AM Bob Fournier Read:3/18/2013 8:30 AM Good morning. There were no Account Payable Warrant questions for March 15. Thanks. . Jeanne Fotl Reading Municipal Light Department Executive Assistant 230 Ash Street Reading, MA 01867 781-942-6434 Phone 781-942-2409 Fax Please consider the environment before printing this e-mail. • 1