Loading...
HomeMy WebLinkAbout2016-03-31 RMLD Board of Commissioners Minutesrq k Town of Reading Meeting Minutes RFUIVED MASS. Board - Committee - Commission - Council: cQ�� 7 '� f ?:'' RMLD Board of Commissioners AU'Ur' P 5' 3�1 Date: 2016-03-31 Time: 7:35 PM Building: Reading Municipal Light Building Location: Selectmen Meeting Room Address: 230 Ash Street Purpose: Public Meeting Session: General Session Attendees: Members - Present: Thomas O'Rourke, Chairman David Talbot, Commissioner Dave Hennessy, Commissioner - Secretary Pro Tem Philip Pacino, Vice Chairman John Stempeck, Commissioner Members - Not Present: Others Present: Staff: Coleen O'Brien, General Manager Bob Fournier, Accouting/Business Manager Jane Parenteau, Director of Integrated Resources Jeanne Foti, Executive Assistant Paul McGonagle, Facilities Manager Wendy Markiewica, Senior Accountant Citizens Advisory Board: Dennis Kelley, Member Minutes Respectfully Submitted By: David Hennessy Topics of Discussion: Page 1 1 Reading Municipal Light Board of Commissioners Regular Session 230 Ash Street R 4:' F IVF• D Reading, MA 01867 r �- �r AG March 31, 2016 e�T\Ui��• i�if�d.i, Start Time of Regular Session: 7:35 p.m. End Time of Regular Session: 9:45 p.m. 281b AUG — I A Or 04 Commissioners: Thomas O'Rourke, Chairman Philip B. Pacino, Vice Chairman David Talbot, Commissioner John Stempeck, Commissioner Dave Hennessy, Commissioner - Secretary Pro Tem Staff: Coleen O'Brien, General Manager Jeanne Foti, Executive Assistant Bob Fournier, Accounting/Business Manager Wendy Markiewicz, Senior Accountant Jane Parenteau, Director of Integrated Resources Citizens' Advisory Board: Mark Chrisos, Member Call Meeting to Order Chairman O'Rourke called the meeting to order and stated that the meeting was being videotaped; it is live in Reading Opening Remarks Chairman O'Rourke read the RMLD Board of Commissioners Code of Conduct. Introductions Chairman O'Rourke acknowledged CAB representative, Mr. Mark Chrisos for joining the Board at the meeting this evening. Chairman O'Rourke stated that Mr. Dave Talbot is running late and asked RMLD Board Commissioner, Mr. Dave Hennessy, to act as Board Secretary for this evening's meeting. Public Comment There was no public comment. Report RMLD Board Member Attendance at RMLD Citizens' Advisory Board Meeting Commissioner Pacino attended the CAB meeting on February 24, 2016 Mr. Pacino reported that he attended the CAB meeting on February 24 in which there was various discussions. One topic addressed was the recent storms and related outage information that the RMLD provides through its APP and website. The home electric safety update was presented. Mr. Pacino said that Ms. O'Brien will be putting together a YouTube video to educate customers on home electric safety. There was discussion on a proposed distributive generator with some good feedback provided on by the CAB members relative to the payback calculation and impact on neighbors on the potential site. There was a status 4pdate on the Organizational and Reliability Study. Mr. Talbot asked what was the substance of the questions were relative to the distributive generation. Mr. Pacino responded that the discussion addressed the fact that the distributed generation is only in the proposal state. The questions were where the unit would be situated and built, potential noise levels as well as speaking to neighbors that may be potentially affected. Also, there was discussion on the cost associated with the project along with the payback period. Chairman O'Rourke attended the CAB meeting on March 23, 2016 Chairman O'Rourke reported that Ms. O'Brien presented the dashboards, the process for the CAB, Board and sta . There was discussion on the new way of contacting employees to come in for outage restoration during outages instead of the traditional phoning in. Ms. O'Brien explained that the RMLD will being using Skype for business this will alleviate the manual calling out. The Skype sends out an automatic call out message sent out by the Control Center employee explaining the needs during an outage for RMLD employees to come in. The RMLD employee can respond by phone which can be switched to text. Ms.O'Brien added that the goal is to minimize the amount of calls that come into the Control Room for safety purposes and being more efficient. Chairman O'Rourke mentioned that Skype for business can also be utilized for online meetings. Mr. Chrisos added that Ms. O'Brien did explain that by using such tools as the website, RMLD's APP and Skype frees up the Control Center operators to make the control room operations more efficient and quickly addressed during outages. Chairman O'Rourke reported that the capital and operating budgets will be presented in separate meetings by both Boards. The operating budget will not be voted on until the capital budget is presented. Regular Session Meeting Minutes 2 March 31, 2016 Chairman O'Rourke attended the CAB meeting on March 23, 2016 Ms. O'Brien added that as indicated from two years ago when going through the operating budget, Ms. Parbnteau will be having a rate discussion. RMLD is trying to get the information to the towns for their budgets. There will be a rate discussion as well as RMLD's Terms and Conditions. The RMLD's Terms and Conditions are being revised and have had legal review, but must be filed with the Department of Public Utilities (DPU) with the rates. Ms. O'Brien stated that Chris Pollart, Rubin and Rudman will be in attendance at the meeting for the Terms and Conditions. The rates and Terms and Conditions will be filed with the DPU for an implementation date of July 1. Report of the Chairman of the Board General Manager Vehicle Allowance Chairman O'Rourke reported at a General Manager Committee meeting in October, one of the items discussed the transitioning out of a company vehicle to a vehicle allowance, but more data needs to be reviewed and will vote this at the next Board meeting. Reorganization of RMLD Board Chairman Mr. Talbot made a motion seconded by Mr. Pacino to nominate Mr. O'Rourke for Chairman of the RMLD Board of Commissioners. Mr. Pacino made a motion seconded by Mr. Stempeck to close the nomination. Motion carried 5:0:0. Mr. Talbot made a motion seconded by Mr. Pacino to nominate Mr. O'Rourke for Chairman of the RMLD Board of Commissioners. Motion carried 5:0:0. Vice Chairman Chairman O'Rourke canvassed the Board members if there was any strong interest for Vice Chairman. Mr. Talbot said that he is happy to pass the baton. Mr. Stempeck added that whoever is Vice Chairman would segue into the Chairman position. Mr. Talbot commented that Mr. Hennessy could be considered, Mr. Hennessy said that he needs more experience. Mr. Talbot said that he would like that Mr. Pacino to be considered for Vice Chairman. Mr. Pacino made a motion seconded by Mr. Stempeck to nominate Mr. Talbot for Vice Chairman of the RMLD Board of Commissioners. No vote was taken. Chairman O'Rourke made a motion seconded by Mr. Stempeck to nominate Mr. Pacino for Vice Chairman of the RMLD Board of Commissioners. Mr. Pacino made a motion seconded by Mr. Stempeck to close the nomination. Motion carried 5:0:0. Mr. Talbot made a motion seconded by Mr. Pacino to nominate Mr. Pacino for Vice Chairman of the RMLD Board of Commissioners. Motion carried 5:0:0. Audit (Including Town of Reading Audit) Philip Pacino, Chair and serve on the Town of Reading Audit Committee John Stempeck Policy Committee Dave Hennessy, Chair Philip Pacino David Talbot General Manager Committee Thomas O'Rourke, Chair John Stempeck David Talbot The Account Payable and Payroll rotation will be changed to have Dave Hennessy to be in a non back up role and Phil Pacino will take over the backup role. Mr. Pacino made a motion seconded by Mr. Stempeck that all the appointments be approved as presented, Audit Committee, Policy Committee General Manager Committee, Account Payable Warrant and Payroll. Motion carried 5:0:0. Regular Session Meeting Minutes March 31, 2016 Report of the Chairman of the Board Peak Reduction Mr. Talbot said that he has been on the water heater demand controls for the past three years. Ms. Parenteau pointed RMLD is working on the water heater demand program. They are doing an audit of the communication between the RN water heaters. Mr. Talbot said that there needs to be new ways to reach out to customers about this such as a social mediE 4 out that the [LD and the campaign. Mr. Talbot said that on peak days, peak reduction should be a priority. Mr. Hennessy asked Mr. Talbot if there is an ing that the RMLD can learn from Concord. Mr. Talbot replied that he will provide the information he has from Concord. Mr. Tal of said that some of the measure may not only be the peak reduction, but also how well we were in reaching RMLD customers. M r. Hennessy pointed out the wording selected by Concord affected responses from customers. Mr. Talbot pointed out that in December, there was a seventy degree day and there could be many other similar weather anomalies. Mr. Talbot said that due to the weather changes, RMLD could get a prolonged heat wave that would cost RMLD money, enhanced RMLD communications could react to this. SmartGrid and voltage reduction are additional great tools to reduce the peak. Chairman O'Rourke asked what can be measured that would improve the reduction of the peak. Ms. O'Brien clarified that the Department is going to is present a chart that demonstrates what Integrated Resources pr grams are in addition to the recent seven additional programs that have been added within the last two year's programs. Ms. O'Brien said that the hot water heater program is not as simple as putting in a water heater module. An electrician came in to the RML to perform training on the water heater program. Ms. O'Brien explained that Ms. Parenteau will have a chart that shows a component of RMLD's peak demand program, here is where we are, the communications systems, barriers for implementation and what we expect/goal, this is how it was achieved. The RMLD is an electric utility, not electricians and there are lines of demar ation on the program; RMLD and customer ownership and responsibilities, i.e., loss of hot water, etc. Chairman O'Rourke said that he would like Ms. O'Brien and Ms. Parenteau to provide the Board with the information peak reduction programs via the informational presentation and at that point the Board can provide some input for more or les Mr. Chrisos stated that what Ms. O'Brien has outlined relative to the whole communication program is great. Mr. C 'sos pointed out that there should be a specific communications plan specific to address notifications to all the customers in the town's specific to those days, forget about the water heater for a minute and commercial customers. Mr. Chrisos said that what he heard when you get a communications plan and say hypothetically, July 10 when the expected peak is going to happen, Twitter, e-mails whatever, a simple plan that can be communicated to everyone instantly. Ms. O'Brien said that last year, the RMLD ran a campaign to encourage the increase in e-mails from customers as a mode of communication. Constant Contact, the town's 911 s stem will be utilized. Ms. O'Brien said that the database is being built. If you were to check with Concord, they have a great communications program they have been working on e-mails and texts for a long time. Mr. Talbot said that it is not only a top down operation from Ms. O'Brien and Ms. Parenteau. Mr. Talbot pointed out that in Reading, there is a Parent's Network on Facebook page a could post it himself and this will spread the message incrementally causing leveraging. Mr. Talbot mentioned that the Climate Committee is another source to get this information out. Chairman O'Rourke said that once the RMLD Board has the peak reduction presentation then the CAB will see it to get their support. Ms. O'Brien agreed. Report of RMLD Board Committee Fiber Optic Committee Meeting — Vice Chair Talbot Mr. Talbot reported that Raj Singh an unpaid consultant from RDDI spoke at the last Fiber Optic Committee meeting. The concept is to see if there is a market for internet access product down the road. The first step is to examine what the cost is to provide service to a business zone to see what it would cost the RMLD to undertake this endeavor and what the market opportunity might be. This economic development emphasis would be the rationale. Fiber is a tool for economic development as well as load growth to attract businesses. Mr. Talbot noted that Mr. Singh submitted a very low cost proposal for a section of Wilmington. It would give the RMLD a sense of where RMLD has its existing fiber and the cost of installing drops to the industrial area of Wilmington. Chairman O'Rourke noted that at the Fiber Optic Committee meeting there were ideas, suggestions and discussion on what possible location to put the fiber. The consensus of the Board was the best way to get their arms around this was to have a pilot. The cost r the study is $9,000. Mr. Talbot pointed out that seven other Massachusetts municipals are offering internet connection. Ms. O' rien clarified that she is under the impression that this falls into economic development for electric RMLD growth. The Board agreed. Mr. Talbot said that this is for the benefit for the four communities RMLD serves. Mr. Pacino added that the main goal is f r the electric growth. Mr. Pacino said that with added conservation efforts to mitigate rate increases the RMLD needs growth. Mr. Talbot said that the primary mission at the RMLD is to have a sustainable business which primarily consists of selling electricity, load growth translates into more electric sales by attracting businesses with fiber. Ms. O'Brien stated that part of the scope for Mr. Singh would be to look at the economic development and growth of RMLD's electric sales. Ms. O'Brien said that the RMLD does look at how it can add to its customer base. Chairman O'Rourke said that one of the questions that was raised and he is unsure if it,was answered was that it comes to the cost profile what the dedicated cost versus allocated costs to RMLD for this type of program. ghat would be the additional staff that would be required for the purpose of fiber optics? Regular Session Meeting Minutes 5 March 31, 2016 Report of RMLD Board Committee Fiber Optic Committee Meeting — Vice Chair Talbot Ms. O'Brien said that drops of RMLD's existing fiber loop is a good test, but if the next phase should arise, Mr. Pollart from Rubin & Rudman would have to come in to discuss the legalities of separating the two businesses. Mr. Talbot suggested discu sing this on an informal basis, Jim Lavelle, Holyoke Gas & Electric Department and Ken Goulart from Taunton Municipal Lighting Plant who IV could provide overview from their practical experience. Approval of Board Minutes October 29, 2015 and December 10, 2015 Mr. Pacino made a motion seconded by Mr. Stempeck to approve the Regular Session meeting minutes of October 9, 2015 as presented. Motion carried 5:0:0. Mr. Pacino made a motion seconded by Mr. Stempeck to approve the Regular Session meeting minutes of December 10, 2015 as presented. Motion carried 5:0:0. Ms. O'Brien requested that the Financial Report and the IFB 2016-22 Mailing Services for Municipal Electric Bills be taken out of order. Financial Report — January and February 2016 — Ms. Markiewicz (Attachment 1) Ms. Markiewicz reported on the February 2016 Financial Report. Ms. Markiewicz stated that Net Income or positive change in Net Assets was $369,181 thereby increasing the year to date Net Income to $888,648. The graph shows the actual to budgeted fluctuation patterns by month due to timing and other variables. The year to date budgeted Net Income was $2.3 million, resulting in Net Income being under budget by $1.4 million or 61.54%. This graph reflects the year to date budgeted amounts to actual were p etty accurate until the last couple of months because MMWEC recently started increasing their work in capital requirements which increased the RMLD's capacity expense. Year to date Base Revenues exceeded the budgeted amount by $207,400 or 1.31%. Actual Base Revenues were apprgximately $16 million compared to the budgeted amount of $15.8 million showing Base Revenues to be very close to budget.Year to d to Purchased Power Base expense was over budget by $738,000 or 3.6%. Actual Purchased Power Base costs were $20.4 million and budgeted Power Base costs were $21.lmillion. The Purchased Power Fuel expense was over budget by $85,000. Actual Purchased Power Fuel was $24 million andl the budgeted cost was $23.9 million. The Operating and Maintenance expenses combined were under budget by $801,000 or 8.2%. Actual Operating and'I Maintenance expenses were $9 million while budgeted expenses were $9.8 million. Energy Conservation was under budget by $245, 00 due to the timing of the process in the programs. Tree trimming expense is under budget by $195,000 due to the lack of any major s i torms. Hazardous Waste was under budget by $136,000 there haven't been any major hazardous material expenses. Maintenace of Garage & Stockroom was under budget by $85,000 because the lift equipment hasn't been removed. Overall cash is a very healthy $36.3 million. The pie chart shows the percentage and amount of each account. The Operating Fund was $14.6 million, the Capital Fund $5.5 million, Rate Stabilization Fund was $6.8 million, Deferred Fuel Fund was $3. million and Energy Conservation Fund was $743,643. The year to date kilowatt hour sales were 461.9 million which is 14.4 m Ilion kilowatt hours or 3.1% behind last year's actual figures. Ms. O'Brien commented that Ms. Markiewicz did a great job with the charts. The Board concurred. IFB 2016-22 Mailing Services for Municipal Electric Bills — Mr. Fournier Mr. Fournier reported that the RMLD went out to bid mid-January sending out fifteen bids with four responses. Befo a the bid was awarded, the RMLD tested to make sure the potential vendor could perform the billing function to RMLD's standar s. Chairman O'Rourke asked how many customers are paying online. Mr. Fournier responded that approximately 6,000 customers ae paperless of the 29,000 accounts. Mr. Fournier said that the RMLD does pay for the paperless customers for a minimal fee to Invze Cloud. Mr. Fournier said that RMLD has provided some incentive for customers in the past to sign up for paperless billing such as an IPod or (W IPad. Mr. Stempeck asked if the vendor has a minimum quantity and is it a fixed or variable cost. Mr. Fournier responded that it is a variable cost based on the amount processed. Chairman O'Rourke asked what is the bid pricing compared to the previous vendor. Regular Session Meeting Minutes March 31, 2016 Financial Report — January and February 2016 — Ms. Markiewicz (Attachment 1) IFB 2016-22 Mailing Services for Municipal Electric Bills — Mr. Fournier Mr. Fournier replied that the current proposed vendor came in significantly lower. Chairman O'Rourke asked if using is a recent occurrence at the RMLD. Mr. Fournier responded that the RMLD has utilized mailing services over the last t 0 mail service -ee years. taw Mr. Talbot asked what the savings would be. Mr. Fournier replied that the cost with this new vendor would be $10,0 0 to $12,000 annually. Mr. Pacino made a motion seconded by Mr. Stempeck that IFB 2016-22 - Mailing Services for Municipal Electric Bills be awarded to Data Integrators for $55,332 for a three (3) year total ($18,444/year), as the lowest qualified, responsive and responsible idder on the recommendation of the General Manager. Motion carried 5:0:0. General Manager's Report — Ms. O'Brien Ms. O'Brien said that she wanted to clarify Mr. Fournier's statement in which there was a raffle for IPod for anyone signed up for a certain period of time for paperless billing, it will not be an IPod per person, but the customers who sign up will be on lottery pool for one IPod. This incentive is being used to expand RMLD's electronic customer contact database. Ms. O'Brien said that the Operating and Capital Budgets will be sent electronically with the exception of the capital summary sheet due to its physical layout. Ms. O'Brien said that Ms. Rybak did a great job on the Capital Budget. Organizational and Reliability Study Update Ms. O'Brien stated that Mr. Jaffari is not present at this meeting because he is teaching a class for ECNE to kee local power engineers up to date and safe. Ms. O'Brien said that she has provided timelines for Leidos on the Organizational Study side and Booth & Ass ciates on the Reliability Study. As requested by the CAB, once a quarter an update would be provided. Ms. O'Brien commented that such items listed such as changing corporate culture cannot be committed to quarter one due to the fact this is an ongoing process of training, team meetings, Career Development Plans, etc. Ms. O'Brien asked the Board if they have any questions. Chairman 'Rourke said that some of the items listed are journeys, then asked are there some items that are overdue. Ms. O'Brien responded that for the Organizational Study timeline it is more the recommendations made which the RMLD accepted. Ms. O'Brien said that everything is being addressed; the recommendations have been started and are being implemented in parallel. Mr. Hennessy clarified that in the Organizational and Reliability study, "Provide management and leadership training" s me of that is currently being done this quarter. Ms. O'Brien responded that training has and is being provided to management. Mr. Hennessy asked who participates in the management training. Is the General Manager's Direct Reports or engineering management. Ms. O'Brien explained that with Leidos recommendation, each employee has a Career Development Program. Ms. O'Brienprovided an example of a Leader Lineman they will have the first level of supervisory training in a management class provided by Fred Pryor. Ms. O'Brien said that the goal has been met by implementing training in each employees' training schedule and budgeted for implementation. Mr. Hennessy clarified that it is customized for each employee. Ms. O'Brien concurred. Ms. O'Brien said that as far as the Booth & Associates Study on the Reliability side, Mr. Jaffari is not present, but he has addressed the items that were accepted by the RMLD. RMLD came up with alternate solutions that were more efficient and cot effective to achieve those means and objectives. Ms. O'Brien said that Mr. Jaffari has completed many items and others are in progress. Ms. O'Brien said that at the CAB meeting there was a question relative to a safety issue relative to the grounding of all the fences at the substations which has been completed. Chairman O'Rourke said that he likes the spreadsheet format because it holds everyone accountable. Ms. O'Brien said that the RMLD is almost completed with the Career Development process. Many of the job descriptions have been updated, wages evaluated, etc. The triangulation of market value, job description and Career Development has been sent back to Leidos for review. Ms. O'Brien explained that Leidos is in the second phase of this process. They are assisting the WALD to verify what RMLD has completed, working as an independent review which has been a big undertaking. Ms. O'Brien said tl lat Leidos has just sent a spreadsheet back to RMLD outlining their comments on job descriptions, etc. Chairman O'Rourke asked relative to Leidos, is it a fix fee based. Ms. O'Brien explained that the Leidos scope was in phases. Ms. O'Brien pointed out that Booth's work is completed. Ms. O'Brien said that the last phase Leidos will support the process/co-manage the strategic plan. There is buy in for the strategic plan when it is written by the company. RMLD Surplus Ms. O'Brien reported that under the Reading Municipal Light Department's (RMLD's) Policy #2, Surplus Material, the RMLD has available to offer the following at a fair market value price of $2,000.00, Spacesaver High -Density Mobile storage system, Regular Session Meeting Minutes March 31, 2016 RMLD Surplus Manufacture: Systematics, Inc. A Systec Partner, Authorized Sales and Service 800-229-8393, Size: Four Units 86"h xl, 40"w x 24"d, One unit 88"h x 40"w x 16"d. A photo of the system was sent out with the surplus offer. If the towns want to view the system they can contact Paula O'Leary. This item is being offered on a first come, first served basis to all four RMLD service communities. Ms. O'Brien said that this unit is a file rack that you would see in a doctor's office with hanging file folders. That area of the building is being reorganized for a more efficient use of that space. Ms. O'Brien reported that this is in conjunction with the fact tliat the RMLD had a records retention program to eliminate paper that was permissible under Records Retention law. A company cam out to onsite shredding for the RMLD as part of this effort. Ms. O'Brien pointed out that once the files are pulled out the tracks cannot be reused, it is also on Municibid and if there is no interest it will become scrap. Change in RMLD Board Meeting Schedule Ms. O'Brien reported that the change in the RMLD Board meeting schedule has been discussed with the CAB as well Technically, the RMLD receives information from MMWEC on power supply on the twentieth of the month. Currently, we have been jumping through hoops to get the data, but she and the team feel the data has not been scrubbed in a manner for quality control. Ms. O'Brien said that the CAB could meet on the first week of the month then the Board could meet thereafter, the second week of the month. This way the Board is getting information that is scrubbed and staff has had a meeting to go over the numbers. Ms. O'Briensaid that we are trying to present to the CAB then to the Board, similar to the budget process. Ms. O'Brien pointed out that the CAB has requested the Financial Report be part of their meeting. Chairman O'Rourke asked what the delta to pushing this out is. Ms. O'Brien replied two weeks. Mr. Hennessy added instead of the last week of the month, it will the second week of the following month. Chairman O'Rourke said that he is in favor f this for the efficiency, the only downside is that it minimizes response time to react to things in a timely manner, he does not see t iat as critical. Chairman O'Rourke pointed out that if you are looking at January Financials in the second week of March, it is a lot ger rear view look if there was a poor month, for revenue enhancement and cost reduction it would be a delayed response from th Board. Mr. Pacino stated that if there is anything that came up the General Manager would react before a Board meeting and get in ouch with the Chair. Ms. O'Brien noted that the problem is the timing of when RMLD receives the power supply numbers. Mr. Stempeck asked what is taking MMWEC so long with its billings. Ms. Parenteau explained that the MMWE billings can sometimes come out on the fourteenth or the fifteenth whereas there are times it does not come out until the twenty third. Ms. Parenteau stated that it is a manual process, what the holdup is, they have entitlements with Seabrook and Millstone End depend on (W Florida Power and Light as well as Dominion to get additional information. Mr. Stempeck asked about the process. Ms. Parenteau commented that MMWEC posts a memorandum invoice on their website which RMLD is able to access when we work on purchase power. With the ISO, RMLD receives its monthly bill the middle of the month as well, it is a reconciliation issue. Ms. O'Brien explained that the transactions in power supply, the matrix of the end users versus all the generators must be reconciled. RMLD's Office 365: SharePoint and Dashboard Ms. O'Brien presented dashboards that were illustrative in nature. Ms. O'Brien said that the RMLD has been buildir g dashboards. The places RMLD is currently getting its information is from Cogsdale, RMLD's billing system and Great Plains RM D's financial system. The second system RMLD is working on is the GIS system and is making headway with that, performing i pilot circuit. Next is building the SharePoint to be paperless internally, policies and procedures. With the dashboard you can retrieve data from any one of the buckets. You bring that data in for the data you need. The CAB and RMLD Board will have their own dashoards as well as the division managers. Outages will also be on the dashboards. Ms. O'Brien said that Eastern Utilities came in and resented their dashboard to the RMLD in the past. Ms. O'Brien said that she would like Eastern Utilities to come in or video conference a presentation on their dashboard again. RMLD will start to build out its website once the dashboards have been comple ed which will have more of a professional look and be more streamlined. Mr. Stempeck asked if RMLD has a software developer onsite. Ms. O'Brien said that Mark Uvanni has set up all the SharePoint and the current dashboards. Ms. O'Brien asked the Board to think of what they may want to see. Chairman O'Rourke thought this is great and the members will provide input after the presentation. Chairman O'Rourke asked if there is currently a RMLD Board dashboard. Ms. O'Brien replied that it is currently bei g developed. Chairman O'Rourke said that the RMLD has done a great job of the elimination of paper for the Board, but is hoping th t SharePoint will augment this. Ms. O'Brien said that there have been insurance issues lately, nothing concerning, but enough for her to have a better understanding of the PURMA insurance for utilities better. There is a one overnight training in which she needs approval, Paula O'Leary will be attending as well. When the RMLD has a pole hit subrogation is done internally and the recovery rate is not optimal. The RMLD may have PURMA help them with that and she needs to understand the process and how other utilities are handling similar issues. Regular Session Meeting Minutes 8 March 31, 2016 General Manager's Report — Ms. O'Brien RMLD's Office 365: SharePoint and Dashboard Mr. Pacino made a motion seconded by Mr. Stempeck to authorize the General Manager's to attend the PURMA program being held in Vermont. Motion carried 5:0:0. Ms. O'Brien reported on the Earth Day, Alternative Energy/Home & Car, sponsored by the Reading Climate Adviso' Committee will be held on Saturday, April 23, 10 a.m. to 2 p.m. at the RMLD, 230 Ash Street, Reading. Home Presenters: Solar options, heat pumps, geothermal, and biomass sources of alternative energy will be represented. Also, energy audits, RMLD rebate offers and LED bulbs display. Auto Presenters: Plug-in hybrids and all electric vehicles from local dealers to include (possibly others): Chevy Volt, hybrid, 53 mile range, battery only, BMW i3, all electric, 80 — 100 mile range, Tesla, all electric, 270 mile range. If you have any questions regarding Earth Day, please send an email to readingmassccp@hotmail.com. Power Supply Report — January and February 2016 — Ms. Parenteau (Attachment 2) Ms. Parenteau reported that for the January report, RMLD looked at heating degree days because weather is a big driv r for electric usage. Heating degrees indicates when home heating is typically used. It takes the day's average temperature the high and low and divides it by two, it takes that number and subtracts it from 65 to show the number of heating days. In January 2012-2014 it has been trending up, but has been a steady decrease since that timeframe. The graph shows the heating degree days and RMLD's peak demand. The next graph looks at kilowatt sales versus heating degree days for the timeframe January 2012-2016. Ms. Parenteapointed out that January is typically a cold month, this past January was considerably mild. The average heating days were slightl above 1125 compared to a peak of over 1375. Mr. Chrisos commented that this January is one of the top five mildest winters on record since the year 1888. Ms. Parenteau said that this winter was extremely mild and has a large impact on sales. The last graph looks at peak demand for calendar year 2015 and how RMLD's peak varies by season. The RMLD i definitely a summer peaking system which occurs in July or August which is weather related. It compares the peak for the winter and summer, the peak drops down during the months of October to November timeframe. Ms. Parenteau reported that this slide is for RMLDs renewable portfolio fiscal years 2014-2015 versus February. One thing to look at was RMLD's power supply portfolio and how its renewable projects increased over last fiscal year up until February 201. Hydro for fiscal years 2014-2015, 8.6%, the month of February 2016, 11.1 % of hydro. With wind the RMLD barely had anything for fiscal years 2012-2015, this February there are two projects, Jericho Wind which came online in December as well as Saddleback that has been online for approximately one year. That brought the wind percentage to 4.2%. In fiscal year, 2012-2015 there w no solar in RMLD's portfolio, now we have .2%. The graph shows the renewable resources by type in a pie graph view. What is interesting to point out is the amount of s stem power RMLD takes is about the same, but if you look at February of this year particularly with the oil and natural gas, the RMLb went from 4% in the fiscal year to less than .5% which is weather related. There was not a lot of oil and gas that needed to run in the prior timeframes. The last graph looks at RMLD's imbedded costs there has been a decline which is weather related. The past two winter eriods were extremely cold in February, there was natural gas constraints within this region where the ISO had to go out and procure oil and liquefied natural gas as back up. This year ISO followed its previous strategy, but it was not necessary to implement that and had a direct correlation to pricing. The pricing was typically a little over 6.5 cents for imbedded power supply, but came down to 5.5 cents that is passed through to our consumers. Mr. Stempeck commented that in terms with the renewables the RMLD is making very good progress for the goals it has for renewables. Ms. Parenteau replied that is correct. We look at the embedded costs as one of the directives Ms. O'Brien has given when we evaluate potential renewable projects, but keep them cost effective projec within the portfolio. Ms. O'Brien said that the charts were well done. Ms. Parenteau thanked Ms. Lamson and Ms. McHugh for their efforts. Engineering and Operations Report January and February 2016 — Mr. Jaffari (Attachment 3) Deferred in the absence of Mr. Jaffari and there were no questions by the Board. RMLD Procurement Requests Requiring Board Approval (Attachment 4) IFB 2016-16 Electric Forklift with Battery Charger and Trade -In Mr. Pacino asked if there is trade in with this bid. Ms. O'Brien responded that the RMLD is getting $3,000 for a 1995 Clark electric forklift which has served its useful life and over the past seven years the RMLD has spent $14,000 in repairs that the RML 3 is trading in. The current forklift has issues such as tilt control inconsistent, sudden jerking motion, unit lost ability to move sharply, challenging lag time and most problematic is that the unit has been used hard and used outside daily creating more wear and tear. Regular Session Meeting Minutes March 31, 2016 0 RMLD Procurement Requests Requiring Board Approval (Attachment 4) IFB 2016-16 Electric Forklift with Battery Charger and Trade -In Mr. Pacino made a motion seconded by Mr. Stempeck that IFB 2016-16 for one Electric Forklift with Battery Charger w th Trade -In be awarded to Lift Truck Parts & Service for $30,477.02 as the lowest qualified and responsive bidder on the recomm ndation of the General Manager. Motion carried 5:0:0. IFB 2016-25 Substation Control Devices Mr. Pacino made a motion seconded by Mr. Stempeck that IFB 2016-25 for Substation Control Devices be awarded to total cost of $44,544.00 as the lowest qualified bidder on the recommendation of the General Manager. Motion carried 5:0:0. General Discussion There was none. BOARD MATERIAL AVAILABLE BUT NOT DISCUSSED E -Mail responses to Account Payable/Payroll Questions Rate Comparisons, February and March 2016 RMLD Board Meetings Thursday, May 12, 2016, 6:30 pm Operational Budget, Terms and Conditions, Rate Discussion and Board Thursday, May 19, 20169 6:30 pm Capital Budget and Board Meeting No April meeting. RMLD Board Policy Committee Meeting To be determined. SCO for a CAB Meetings Wednesday, April 6, 2016, Operating Budget Review Wednesday, April 13, 2016, Capital Budget Review — To be covered by Commissioner Hennessy Wednesday, May 4, 2016, Regular Meeting Executive Session At 9:30 p.m. Mr. Pacino made a motion seconded by Mr. Stempeck that the Board go into Executive Session to approve the Executive Session meeting minutes of October 29, 2015 and December 10, 2015 discuss strategy with respect to collective bargaining and return to Regular Session for the sole purpose of adjournment. Chairman O'Rourke called for a poll of the vote: Mr. Pacino, Aye; Mr. Talbot, Aye; Chairman O'Rourke, Aye; Mr. Stempeck, Aye and Mr. Hennessy; Aye. Motion carried 5:0:0. Adjournment At 9:45 p.m., Mr. Pacino made a motion seconded by Mr. Talbot 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. David Hennessy, Secretary Pro Tem RMLD Board of Commissioners c a r LCL G A 'D U u C) C3 (3 w ILI c m 00 1 CO h Ln cri P, In ID IV t 0 aj Ht1l -C M ffi ■ r, Co Lri o 41, 00 00m Co t, 0 ■ U u C) C3 (3 w ILI c m m O O >a X17 aj a) C Lu • m of od r� �3! re rj 0 a) 0 —1 u� oa co O W , ■__- • It W m w kn • P c 0 lu uo ■ m J W p LL I ' W W W a D 7t t [ o0 09 O0C) 00000 : C] n Ci C: :� Ci C:� 000000000 OnO00000C) 0 0 n 0 0 0 CD C) C) mwr,tiOLn --I ni" -I cn Ln '-I m r--! (31 "I ,-I ai 00 UD -1 0 a) cn .,I r-4 M to �D rl W co Zn N --I cd Lr, (V r-4 r,4 W m r, OJ UD ry m Ln tio CL > 0 a) FINANCIAL REPORT JANUARY 31, 2016 ISSUE DATE: FEBRUARY 29, 2016 ASSETS CURRENT UNRESTRICTED CASH RESTRICTED CASH RESTRICTED INVESTMENTS RECEIVABLES, NET PREPAID EXPENSES OTHER DEFERRED DEBITS INVENTORY TOTAL CURRENT ASSETS NONCURRENT INVESTMENT IN ASSOCIATED CO CAPITAL ASSETS, NET TOTAL NONCURRENT ASSETS TOTAL ASSETS TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS -TYPE PROPRIETARY FUND STATEMENT OF NET ASSETS 1/31/16 (SCH A P.9) (SCH A P.9) (SCH A P.9) (SCH B P.10) (SCH B P.10) (SCH B P.10) (SCH C P.2) (SCH C P.2) LIABILITIES CURRENT ACCOUNTS PAYABLE CUSTOMER DEPOSITS CUSTOMER ADVANCES FOR CONSTRUCTION ACCRUED LIABILITIES TOTAL CURRENT LIABILITIES NONCURRENT ACCRUED EMPLOYEE COMPENSATED ABSENCES TOTAL NONCURRENT LIABILITIES TOTAL LIABILITIES NET ASSETS INVESTED IN CAPITAL ASSETS, NET OF RELATED DEBT RESTRICTED FOR DEPRECIATION FUND (P.9) UNRESTRICTED TOTAL NET ASSETS (P.3) TOTAL LIABILITIES AND NET ASSETS u PREVIOUS YEAR 11,522,798.06 21,412,555.78 1,292,906.26 8,526,102.90 2,427,520.14 0.00 1,490,441.14 46,672,324.28 26,993.75 69,512,012.08 CURRENT YEAR 10,898,477.1 21,091 052.8 1,284,061.4 8,362,181.7 2,641,259.88 1,547,815.00 1,729,535.25 47,554,383.2 26,993.75 70,413,182.81 69,539,005.83 70,440,17 116,211,330.11 117,994,55 6,948,038.36 7,885,014.14 839,254.91 905,204.16 565,058.48 967,879.1° 211,120.34 3,201,423.94 8.563.472.09 12.959.521.41 2,918,870.73 3,070,487.92 2.918.870.73 3,070,487.9-- 11,482,342.82 .070.487.9_ 11,482,342.82 16,030,009.34 69,512,012.08 70,413,182.8 5,825,309.97 6,350,404.0 29,391,665.24 25,200,963.6 104,728,987.29 116,211,330.11 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT NONCURRENT ASSET SCHEDULE 1/31/16 SCHEDULE OF INVESTMENTS IN ASSOCIATED COMPANIES NEW ENGLAND HYDRO ELECTRIC NEW ENGLAND HYDRO TRANSMISSION TOTAL INVESTMENTS IN ASSOCIATED COMPANIES SCHEDULE OF CAPITAL ASSETS STRUCTURES AND IMPROVEMENTS EQUIPMENT AND FURNISHINGS INFRASTRUCTURE TOTAL CAPITAL ASSETS, NET TOTAL NONCURRENT ASSETS (2) SCHEDULE C PREVIOUS YEAR CURRENTIYEAR 2,975.74 2,97 .74 24,018.01 24,01 .01 26,993.75 26,993.75 1,265,842.23 6,108,069.51 12,423,666.11 49,714,434.23 69,512,012.08 69,539,005.83 1,265,84P.23 6,574,48 .56 11,927,98 .85 70.413.181.84 70,440,171116.59 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS -TYPE PROPRIETARY FUND STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND NET ASSETS 1/31/16 OPERATING REVENUES: (SCH D P.11) BASE REVENUE FUEL REVENUE PURCHASED POWER CAPACITY FORFEITED DISCOUNTS ENERGY CONSERVATION REVENUE NYPA CREDIT TOTAL OPERATING REVENUES OPERATING EXPENSES: (SCH E P.12) PURCHASED POWER CAPACITY PURCHASED POWER TRANSMISSION PURCHASED POWER FUEL OPERATING MAINTENANCE DEPRECIATION VOLUNTARY PAYMENTS TO TOWNS TOTAL OPERATING EXPENSES OPERATING INCOME 1PERATING REVENUES (EXPENSES) 1%;ONTRIBUTIONS IN AID OF CONST RETURN ON INVESTMENT TO READING INTEREST INCOME INTEREST EXPENSE OTHER (MDSE AND AMORT) TOTAL NONOPERATING REV (EXP) CHANGE IN NET ASSETS NET ASSETS AT BEGINNING OF YEAR NET ASSETS AT END OF JANUARY MONTH MONTH LAST YEAR CURRENT YEAR YTD 8 LAST YEAR CURRENT YEAR TO DATE TO DATEI CHANGE 1,869,424.05 1,864,067.44 12,939,211.71 14,099,007.90 8.968 2,845,745.09 2,656,333.87 20,738,447.56 20,282,310.51 -2.208 2,526,828.66 2,075,758.47 17,564,396.05 17,498,194.81 -0.388 76,469.60 68,040.93 467,992.73 473,822.61 1.258 56,535.32 47,810.39 405,562.39 399,434.44 -1.518 (100,190.60) (108,747.38) (482,453.42) (629,549.39) 30.498 7,274,812.12 6,603,263.72 51,633,157.02 52,123,220.88 1 0.958 1,541,650.35 1,691,412.49 9,870,582.68 11,083 ' 628.14 12.298 805,943.23 873,183.82 7,265,172.90 7,686,115.05 5.798 3,456,178.99 3,163,761.69 19,290,344.43 21,019,051.42 8.968 1,003,026.29 778,110.02 6,423,655.11 6,053,646.95 -5.768 208,813.65 235,485.37 1,920,847.36 1,732,112.83 -9.838 321,788.79 328,732.65 2,252,521.53 2,301,128.55 2.168 118.000.00 118,000.00 816,754.00 814,973.00 -0.228 7,455,401.30 7,188,686.04 47,839,878.01 50,690,655.94 5.968 (180,589.18) (585,422.32) 3,793,279.01 1,432,564.94 -62.238 3,500.00 7,492.49 80,861.92 45,937.23 (194,405.25) (197,537.08) (1,360,836.76) (1,382,759.58) 10,660.93 10,131.95 81,545.81 79,246.33 (248.88) (1,156.02) (3,042.07) (2,243.03) 164,218.44 197,991.55 263,845.22 346,721.40 (16,274.76) 16,922.89 (937,625.88) (913,097.65) (196,863.94) (568,499.43) (3) 2,855,653.13 519,467.29 101,873,334.16 101,445,083.23 104,728,987.29 101,964,550.52 -43.198 1.618 -2.828 -26.278 31.418 -2.628 -0.428 -2.648 caj TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS -TYPE PROPRIETARY FUND STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND NET ASSETS 1/31/16 OPERATING REVENUES: (SCH F P.11B) BASE REVENUE FUEL REVENUE PURCHASED POWER CAPACITY FORFEITED DISCOUNTS ENERGY CONSERVATION REVENUE NYPA CREDIT TOTAL OPERATING REVENUES OPERATING EXPENSES: (SCH G P.12A) PURCHASED POWER - CAPACITY PURCHASED POWER - TRANSMISSION PURCHASED POWER FUEL OPERATING MAINTENANCE DEPRECIATION VOLUNTARY PAYMENTS TO TOWNS TOTAL OPERATING EXPENSES OPERATING INCOME NONOPERATING REVENUES (EXPENSES) CONTRIBUTIONS IN AID OF CONST RETURN ON INVESTMENT TO READING INTEREST INCOME INTEREST EXPENSE OTHER (MDSE AND AMORT) TOTAL NONOPERATING REV (EXP) CHANGE IN NET ASSETS NET ASSETS AT BEGINNING OF YEAR NET ASSETS AT END OF JANUARY * ( ) = ACTUAL UNDER BUDGET ACTUAL BUDGET 560,153.14 YEAR TO DATE YEAR TO DATE VARIANCE* 14,099,007.90 13,976,419.00 122,588.90 20,282,310.51 21,386,670.00 (1,104,359.49) 17,498,194.81 18,111,505.00 (613,310.19) 473,822.61 419,294.00 54,528.61 399,434.44 406,720.00 (7,285.56) (629,549.39) (525,000.00) (104,549.39) 52,123,220.88 53,775,608.00 (1,652,387.12) 11,083,628.14 10,523,475.00 560,153.14 7,686,115.05 7,588,030.00 98,085.05 21,019,051.42 20,861,670.00 157,381.42 6,053,646.95 6,446,190.00 (392,543.05) 1,732,112.83 2,245,358.00 (513,245.17) 2,301,128.55 2,323,510.00 (22,381.45) 814.973.00 826.000.00 (11,027.00) 50,690,655.94 50,814,233.00 (123,577.06) 1,432,564.94 2,961,375.00 (1,528,810.06) -5 45,937.23 150,000.00 (104,062.77) -6 (1,382,759.58) (1,382,500.00) (259.58) 79,246.33 87,500.00 (8,253.67) - (2,243.03) (1,225.00) (1,018.03) 8 346,721.40 210,000.00 136,721.40 6 (913,097.65) (936,225.00) 23,127.35 - 519,467.29 2,025,150.00 (1,505,682.71) 101,445,083.23 101,445,083.23 0.00 101,964,550.52 103,470,233.23 (1,505,682.7].) (3A) -7 ).88% 5.16% 3.39% 3.00% L.79% 3.91% 3.07% 5.32% 1.29% ).75% 6.09% 2.86% ).96% 1.33% 3.24% 1.63% 9.38% 0.02% 9.43% 3.10% 5.11% 2.47% 4.35% 0.00% 1.46% TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT RECONCILIATION OF CAPITAL FUNDS 1/31/16 SOURCE OF CAPITAL FUNDS: DEPRECIATION FUND BALANCE 7/1/15 CONSTRUCTION FUND BALANCE 7/1/15 INTEREST ON DEPRECIATION FUND FY 16 DEPRECIATION TRANSFER FY 16 TOTAL SOURCE OF CAPITAL FUNDS USE OF CAPITAL FUNDS: LESS PAID ADDITIONS TO PLANT THRU JANUARY TOTAL USE OF CAPITAL FUNDS GENERAL LEDGER CAPITAL FUNDS BALANCE 1/31/16 (4) 5,434,307.79 1,400,000.00 12,882.58 2,301,128.55 9,148,318.92 2,797,914.86 6,350,404.06 SALES OF ELECTRICITY: RESIDENTIAL SALES COMM. AND INDUSTRIAL SALES PRIVATE STREET LIGHTING TOTAL PRIVATE CONSUMERS MUNICIPAL SALES: STREET LIGHTING MUNICIPAL BUILDINGS TOTAL MUNICIPAL CONSUMERS SALES FOR RESALE SCHOOL TOTAL KILOWATT HOURS SOLD TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SALES OF KILOWATT HOURS 1/31/16 MONTH MONTH LAST YEAR CURRENT YEAR YTD'L% LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE 23,519,829 21,038,004 155,521,685 155,505,015 -0101% 31,327,972 25,233,906 240,458,635 234,328,395 -2155% 1,407,377 79,972 84,923 553,396 562,279 116111 48,836,335 54,927,773 46,356,833 396,533,716 390,395,689 -11155% 242,710 225,902 1,699,775 1,607,766 -5 877,249 797,344 5,622,101 5,401,485 -3 1,119,959 1,023,246 7,321,876 7,009,251 -4 248,384 230,843 2,020,077 1,957,144 -3 1,407,377 1,225,413 8,678,576 8,311,211 -4 57,703,493 48,836,335 414,554,245 407,673,295 -1 (5) 41% 92% 27% 12% 23% 66% TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT KILOWATT HOURS SOLD BY TOWN 1/31/16 TOTAL READING LYNNFIELD NO.READING WILMINGTON MONTH RESIDENTIAL 21,038,004 6,555,169 2,892,112 5,059,843 6,130,880 COMM & IND 25,233,906 3,888,151 253,411 4,970,313 16, 22,031 PVT ST LIGHTS 84,923 15,468 2,495 25,741 141,219 PUB ST LIGHTS 225,902 76,233 29,261 40,268 80,140 MUNI BLDGS 797,344 218,001 156,260 122,371 00,712 SALES/RESALE 230,843 230,843 0 0 0 SCHOOL 1,225,413 423,047 274,174 226,94001.252 TOTAL 48,836,335 11,406,912 3,607,713 10,445,476 231176,234 YEAR TO DATE 1 RESIDENTIAL 155,505,015 49,343,779 22,207,658 36,061,288 47, 92,290 COMM & IND 234,328,395 28,505,308 1,892,113 36,942,323 16688,651 PVT ST LIGHTS 562,279 95,976 11,641 174,765 79,897 PUB ST LIGHTS 1,607,766 542,277 212,556 284,024 68,909 MUNI BLDGS 5,401,485 1,237,492 1,200,170 966,145 1 ,97,678 SALES/RESALE 1,957,144 1,957,144 0 0 I 0 SCHOOL 8,311,211 2,857,868 1,787,396 1,736,320 1,)29,627 TOTAL 407,673,295 84,539,844 27,311,534 76,164,865 219 557.,052 LAST YEAR TO DATE RESIDENTIAL 155,521,685 48,418,009 22,561,349 35,807,724 48,134,603 COMM & IND 240,458,635 29,586,953 1,890,375 37,036,415 171, 44,892 PVT ST LIGHTS 553,396 93,610 10,668 173,708 75,410 PUB ST LIGHTS 1,699,775 571,190 229,526 298,750 600,309 MUNI BLDGS 5,622,101 1,423,815 1,179,468 1,005,993 2,1012,825 SALES/RESALE 2,020,077 2,020,077 0 0 0 SCHOOL 8,678,576 2,943,174 1,819,853 1,384,200 2,$31,349 TOTAL 414,554,245 85,056,828 27,691,239 75,706,790 22699,388 KILOWATT HOURS SOLD TO TOTAL TOTAL READING LYNNFIELD NO.READING WIILMINGTON MONTH RESIDENTIAL 43.08% 13.42% 5.92% 10.36%1 13.36$ COMM & IND 51.67% 7.96% 0.52% 10.18% 33.01% PVT ST LIGHTS 0.17$ 0.03$ 0.01$ 0.05$ 0.08% PUB ST LIGHTS 0.46% 0.16% 0.06% 0.08% 0.16$ MUNI BLDGS 1.64$ 0.45$ 0.32$ 0.25$ 0.62% SALES/RESALE 0.47$ 0.47$ 0.00$ 0.00$ 0.00% SCHOOL 2.51% 0.87% 0.56% 0.46% 0.62% TOTAL 100.00$ 23.36% 7.39% 21.38$ 47.87% YEAR TO DATE RESIDENTIAL 38.15% 12.10% 5.45% 8.85% 11.75% COMM & IND 57.48% 6.99% 0.46% 9.06% 40.97% PVT ST LIGHTS 0.14% 0.02% 0.00% 0.04% 0.08% PUB ST LIGHTS 0.39% 0.13% 0.05% 0.07% 0.14% MUNI BLDGS 1.32% 0.30% 0.29% 0.24% 0.49% SALES/RESALE 0.48% 0.48% 0.00% 0.00% 0.00$ SCHOOL 2.04% 0.70% 0.44% 0.43% 0.47% TOTAL 100.00% 20.72% 6.69% 18.69% 1 53.90% LAST YEAR TO DATE 1 RESIDENTIAL 37.52% 11.68% 5.44% 8.64% 11.76$ COMM & IND 58.00% 7.14% 0.46% 8.93% 41.47% PVT ST LIGHTS 0.13% 0.02% 0.00% 0.04% 0.07% PUB ST LIGHTS 0.41% 0.14% 0.06% 0.07% 0.14% MUNI BLDGS 1.36% 0.34% 0.28% 0.24% 0.50% SALES/RESALE 0.49% 0.49% 0.00% 0.00% 0.00% SCHOOL 2.09% 0.71% 0.44% 0.33% 0.61% TOTAL 100.00$ 20.52% 6.68% 18.25% 54.55% (6) A TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT FORMULA INCOME 1/31/16 TOTAL OPERATING REVENUES (P.3) 52,123,220.88 ADD: POLE RENTAL 0.00 INTEREST INCOME ON CUSTOMER DEPOSITS 2,618.83 LESS: OPERATING EXPENSES (P.3) (50,690,655.94) CUSTOMER DEPOSIT INTEREST EXPENSE (1,087.01) FORMULA INCOME (LOSS) 1,434,096.76 (7) SALE OF KWH (P.5) KWH PURCHASED AVE BASE COST PER KWH AVE BASE SALE PER KWH AVE COST PER KWH AVE SALE PER KWH FUEL CHARGE REVENUE (P.3) LOAD FACTOR PEAK LOAD TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT GENERAL STATISTICS 1/31/16 MONTH OF JAN 2015 57,703,493 61,776,997 0.024955 0.032397 0.080901 0.081714 2,845,745.09 77.60$ 109,061 MONTH OF $ CHANGE YEAR IITHRU JAN 2016 2015 2016 JAN 2015 JAI 2016 48,836,335 -0.78$ -1.66$ 414,554,245 4017,673,295 56,019,481 -4.46$ -24.13$ 418,371,883 3117,401,919 0.030193 -39.66$ 48.01$ 0.023593 1 0.034920 0.038170 -52.24$ 10.80$ 0.031212 0.034584 0.086669 -15.41$ 45.11$ 0.069701 0.101142 0.092562 -25.61$ 3.81$ 0.081238 0.084335 2,656,333.87 13.17$ -2.20$ 20,738,447.56 201? 82,310.51 76.50$ 100,307 (8) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF CASH AND INVESTMENTS 1/31/16 UNRESTRICTED CASH CASH - OPERATING FUND CASH - PETTY CASH TOTAL UNRESTRICTED CASH RESTRICTED CASH CASH - DEPRECIATION FUND CASH - TOWN PAYMENT CASH - DEFERRED FUEL RESERVE CASH - RATE STABILIZATION FUND CASH - UNCOLLECTIBLE ACCTS RESERVE CASH - SICK LEAVE BENEFITS CASH - HAZARD WASTE RESERVE CASH - CUSTOMER DEPOSITS CASH - ENERGY CONSERVATION TOTAL RESTRICTED CASH INVESTMENTS SICK LEAVE BUYBACK TOTAL CASH BALANCE Im (9) PREVIOUS YEAR 11,519,798.06 3,000.00 11,522,798.06 5,825,309.97 312,405.25 5,098,344.67 6,756,780.52 200,000.00 1,707,316.51 150,000.00 839,254.91 523,143.95 21,412,555.78 1,292,906.26 34,228,260.10 SCHEDULE A CURRENT YEAR 10,895,477.10 3,000.00 10,898,477.10 6,350,404.06 315,537.00 3,813,994.85 6,806,669.46 200,000.00 1,805,599.83 150,000.00 905,204.18 743,643.45 21,091,052.83 1,284,061.45 33,273,591.38 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF ACCOUNTS RECEIVABLE 1/31/16 SCHEDULE OF ACCOUNTS RECEIVABLE RESIDENTIAL AND COMMERCIAL ACCOUNTS RECEIVABLE - OTHER ACCOUNTS RECEIVABLE - LIENS ACCOUNTS RECEIVABLE - EMPLOYEE ADVANCES SALES DISCOUNT LIABILITY RESERVE FOR UNCOLLECTIBLE ACCOUNTS TOTAL ACCOUNTS RECEIVABLE BILLED UNBILLED ACCOUNTS RECEIVABLE TOTAL ACCOUNTS RECEIVABLE, NET SCHEDULE OF PREPAYMENTS PREPAID INSURANCE PREPAYMENT PURCHASED POWER PREPAYMENT PASNY PREPAYMENT WATSON PURCHASED POWER WORKING CAPITAL TOTAL PREPAYMENT OTHER DEFERRED DEBITS ACCOUNTS RECEIVABLE AGING JANUARY 2016: RESIDENTIAL AND COMMERCIAL LESS: SALES DISCOUNT LIABILITY GENERAL LEDGER BALANCE CURRENT 30 DAYS 60 DAYS 90 DAYS OVER 90 DAYS TOTAL Im (10) PREVIOUS YEAR 3,182,778.67 185,999.32 37,433.70 892.14 (233,751.34) (269.518.87) 2,903,833.62 5,622,269.28 SCHEDULE B CURRENT YEAR 3,165,867.00 423,983.3 21,644.6 543.5 (152,269.8) 263 937.0 ) 3,195,831.8, 5,166,349.9 8.526,102.90 8,362,181.7( 1,388,734.37 1,478,365.8! 556,401.78 564,555.6: 259,957.39 307,572.5( 209,726.49 275,895.8: 12,700.11 14,870.01 2,427,520.14 2,641,259.81 0.00 1,547,815.01 3,165,867.09 (152,269.80) 3,013,597.29 2,378,039.72 78.91% 358,037.70 11.88% 119,927.59 3.98% 73,472.20 2.44% 84,120.08 2.79% 3,013,597.29 100.00% TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REVENUE 1/31/16 SCHEDULE D MUNICIPAL SALES: STREET LIGHTING MONTH MONTH LAST YEAR CURRENT YEAR YTD % SALES OF ELECTRICITY: LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE RESIDENTIAL SALES 2,224,111.00 2,197,562.64 14,826,171.91 15,444,371.89 4.17% COMM AND INDUSTRIAL SALES 2,257,329.78 2,092,279.72 17,294,119.99 17,473,195.73 1.04% PRIVATE STREET LIGHTING 9,549.01 10,790.43 66,126.49 71,228.08 7.71% TOTAL PRIVATE CONSUMERS 4,490,989.79 4,300,632.79 32,186,418.39 32,988,795.70 2.49% MUNICIPAL SALES: STREET LIGHTING 29,865.45 26,037.23 209,030.65 98,007.88 -53.11% MUNICIPAL BUILDINGS 67,624.07 68,007.36 445,635.00 448,864.89 0.72% TOTAL MUNICIPAL CONSUMERS 97,489.52 94,044.59 654,665.65 546,872.77 -16.47% SALES FOR RESALE 21,078.97 21,549.90 172,862.46 170,867.54 I'i -1.15% SCHOOL 105,610.86 104,174.03 663,712.77 674,782.40 1.67% SUB -TOTAL 4,715,169.14 4,520,401.31 33,677,659.27 34,381,318.41 I'' 2.09% FORFEITED DISCOUNTS 76,469.60 68,040.93 467,992.73 473,822.61 !I 1.25% PURCHASED POWER CAPACITY 2,526,828.66 2,075,758.47 17,564,396.05 498 17 i -0.38%194.81 ENERGY CONSERVATION - RESIDENTIAL 23,532.17 21,047.03 155,586.76 155,576.74 -0.01% ENERGY CONSERVATION - COMMERCIAL 33,003.15 26,763.36 249,975.63 243,857.70 -2.45% NYPA CREDIT (100,190.60) (108,747.38) (482,453.42) (629,549.39)', 30.49% TOTAL REVENUE 7,274,812.12 6,603,263.72 51,633,157.02 52,123,220.88 III 0.95% Im Em TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REVENUE BY TOWN 1/31/16 TOTAL READING LYNNFIELD NO.READING WILMINGTON MONTH RESIDENTIAL 2,197,562.64 689,444.71 300,121.63 526,589.48 6811406.82 INDUS/MUNI BLDG 2,160,287.08 361,054.74 37,672.35 417,817.82 1,343}742.17 PUB.ST.LIGHTS 26,037.23 8,766.03 3,364.77 4,660.75 9 245.68 PRV.ST.LIGHTS 10,790.43 1,848.71 263.08 3,484.89 5 193.75 CO-OP RESALE 21,549.90 21,549.90 0.00 0.00 0.00 SCHOOL 104,174.03 36,115.86 22,280.73 21,005.21 24f772.23 TOTAL 4,520,401.31 1,118,779.95 363,702.56 973,558.15 2,060.65 THIS YEAR TO DATE RESIDENTIAL 15,444,371.89 4,932,045.96 2,186,928.88 3,570,813.76 4,7541583.29 INDUS/MUNI BLDG 17,922,060.62 2,475,943.34 267,456.60 2,936,615.99 12,242 044.69 PUB.ST.LIGHTS 98,007.88 33,236.05 12,720.95 17,615.45 34 435.43 PRV.ST.LIGHTS 71,228.08 11,766.34 1,459.77 23,213.13 34 788.84 CO-OP RESALE 170,867.54 170,867.54 0.00 0.000.00 SCHOOL 674,782.40 233,250.95 140,880.70 148,066.89 152I�583.86 TOTAL 34,381,318.41 7,857,110.18 2,609,446.88 6,696,325.23 17 218 436.12 LAST YEAR TO DATE RESIDENTIAL 14,826,171.91 4,637,538.10 2,135,880.29 3,405,283.77 4,647,469.75 INDUS/MUNI BLDG 17,739,754.99 2,480,723.03 250,885.12 2,873,065.99 12,135,080.85 PUB.ST.LIGHTS 209,030.65 70,099.61 28,168.56 36,876.85 73,885.63 PRV.ST.LIGHTS 66,126.49 10,985.44 1,296.12 21,505.70 321,339.23 CO-OP RESALE 172,862.46 172,862.46 0.00 0.00 0.00 SCHOOL 663,712.77 227,966.60 137,732.49 108,174.40 1891,839.28 TOTAL 33,677,659.27 7,600,175.24 2,553,962.58 6,444,906.71 17,078,614.74 PERCENTAGE OF OPERATING INCOME TO TOTAL TOTAL READING LYNNFIELD NO.READING WILMINGTON MONTH RESIDENTIAL 48.61% 15.25% 6.64% 11.65% 15.07% INDUS/MUNI BLDG 47.79% 7.99% 0.83% 9.24% 29.73% PUB.ST.LIGHTS 0.58% 0.19% 0.07% 0.10% 0.22% PRV.ST.LIGHTS 0.24% 0.04% 0.01% 0.08% 0.11% CO-OP RESALE 0.48% 0.48% 0.00% 0.00% 0.00% SCHOOL 2.30% 0.80% 0.49% 0.46% 0.55% TOTAL 100.00% 24.75% 8.04% 21.53% 45.68% THIS YEAR TO DATE RESIDENTIAL 44.92% 14.35% 6.36% 10.39% 13.82% INDUS/MUNI BLDG 52.12% 7.20% 0.78% 8.54% 35.60% PUB.ST.LIGHTS 0.29% 0.10% 0.04% 0.05% 0.10% PRV.ST.LIGHTS 0.21% 0.03% 0.00% 0.07% 0.11% CO-OP RESALE 0.50% 0.50% 0.00% 0.00% 0.00% SCHOOL 1.96% 0.68% 0.41% 0.43% 0.44% TOTAL 100.00% 22.86% 7.59% 19.48% -� 50.07% LAST YEAR TO DATE RESIDENTIAL 44.02% 13.77% 6.34% 10.11% 1 13.80% INDUS/MUNI BLDG 52.68% 7.37% 0.74% 8.53% 36.04% PUB.ST.LIGHTS 0.62% 0.21% 0.08% 0.11% 0.22% PRV.ST.LIGHTS 0.20% 0.03% 0.00% 0.06% 0.11% CO-OP RESALE 0.51% 0.51% 0.00% 0.00% 0.00% SCHOOL 1.97% 0.68% 0.41% 0.32% 0.56% TOTAL _100.00% 22.57% 7.57% 19.13% 50.73% Im (11B) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED REVENUE VARIANCE REPORT 1/31/16 SCHEDULE F ACTUAL BUDGET YEAR TO DATE YEAR TO DATE VARIANCE * CHANGE SALES OF ELECTRICITY: RESIDENTIAL 7,663,740.11 7,603,836.00 59,904.11 Oi,79% COMM AND INDUSTRIAL SALES PRIVATE STREET LIGHTING 6,040,210.98 5,829,298.00 210,912.98 3,.62% MUNICIPAL BUILDINGS PUBLIC STREET LIGHTING 64,874.05 221,129.00 (156,254.95) -70'i.66% SALES FOR RESALE 73,959.67 77,617.00 (3,657.33) -411.71% SCHOOL 256,223.09 244,539.00 11,684.09 41,.78% TOTAL BASE SALES 14,099,007.90 13,976,419.00 122,588.90 01,.68% TOTAL FUEL SALES 20,282,310.51 21,386,670.00 (1,104,359.49) -51.16% TOTAL OPERATING REVENUE 34,381,318.41 35,363,089.00 (981,770.59) -2,.78% FORFEITED DISCOUNTS 473,822.61 419,294.00 54,528.61 1.00% PURCHASED POWER CAPACITY 17,498,194.81 18,111,505.00 (613,310.19) -x•39% ENERGY CONSERVATION - RESIDENTIAL 155,576.74 156,313.00 (736.26)47% ENERGY CONSERVATION - COMMERCIAL 243,857.70 250,407.00 (6,549.30) - .62% NYPA CREDIT (629,549.39) (525,000.00) (104,549.39) 1.91% TOTAL OPERATING REVENUES 52,123,220.88 53,775,608.00 (1,652,387.12) -3.07% * ( ) = ACTUAL UNDER BUDGET (11B) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING EXPENSES 1/31/16 SCHEDULE E MONTH MONTH LAST YEAR CURRENT YEAR YTD % OPERATION EXPENSES: LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE PURCHASED POWER CAPACITY 1,541,650.35 1,691,412.49 9,870,582.68 11,083,628.14 12.29% PURCHASED POWER TRANSMISSION 805,943.23 873,183.82 7,265,172.90 7,686,115.05 5.79% TOTAL PURCHASED POWER 2,347,593.58 2,564,596.31 17,135,755.58 18,769,743.19 9.54% OPERATION SUP AND ENGINEERING EXP 43,671.73 44,754.63 309,364.06 317,019.40 2.47% STATION SUP LABOR AND MISC 16,426.47 13,167.24 93,661.10 88,712.54 -5.28% LINE MISC LABOR AND EXPENSE 122,812.61 29,845.60 492,564.08 411,409.43 -16.48% STATION LABOR AND EXPENSE 46,128.61 30,836.07 300,699.20 232,823.80 -22.57% STREET LIGHTING EXPENSE 7,347.04 13,381.99 54,610.66 70,515.07 29.12% METER EXPENSE 19,992.92 19,008.17 110,806.86 130,138.17 17.45% MISC DISTRIBUTION EXPENSE 41,345.86 38,932.31 259,715.59 258,409.61 -0.50% METER READING LABOR & EXPENSE 1,857.25 1,924.89 10,574.12 16,444.63 55.52% ACCT & COLL LABOR & EXPENSE 160,739.32 122,199.73 1,051,962.91 963,408.88 -8.42% UNCOLLECTIBLE ACCOUNTS 10,000.00 10,000.00 70,000.00 70,000.00 0.00% ENERGY AUDIT EXPENSE 35,221.03 55,715.28 237,222.29 330,721.86 39.41% ADMIN & GEN SALARIES 68,901.79 69,962.35 487,363.14 514,887.61 5.65% OFFICE SUPPLIES & EXPENSE 27,558.30 30,608.74 174,445.83 188,549.60 8.08% OUTSIDE SERVICES 28,395.44 10,530.85 239,243.82 191,653.85 -19.89% PROPERTY INSURANCE 31,070.39 30,594.30 210,252.92 218,048.711 3.71% INJURIES AND DAMAGES 3,070.27 3,627.56 26,070.72 28,173.88 1,593,232.94', 8.07% -9.37% EMPLOYEES PENSIONS & BENEFITS 247,934.19 193,472.01 1,757,985.52 MISC GENERAL EXPENSE 17,569.24 10,263.60 99,315.42 88,964.211 -10.42% RENT EXPENSE 14,514.48 14,385.08 98,117.43 100,135.81] 2.06% ENERGY CONSERVATION 58,469.35 34,899.62 339,679.44 240,396.9511 -29.23% TOTAL OPERATION EXPENSES 1,003,026.29 778 110.02 6,423,655.11 6 053 646.95 -5.76% 4WNTENANCE EXPENSES: MAINT OF TRANSMISSION PLANT 227.08 227.08 1,589.58 1,589.58'' 0.00% MAINT OF STRUCT AND EQUIPMT 29,640.30 41,190.66 332,251.43 217,441.42 -34.56% MAINT OF LINES - OH 127,359.96 125,439.45 1,039,748.23 969,092.22 -6.80% MAINT OF LINES - UG 311.96 4,704.68 77,479.82 68,899.791 -11.07% MAINT OF LINE TRANSFORMERS 0.00 7,752.67 60,065.12 87,669.33 45.96% MAINT OF ST LT & SIG SYSTEM (8.06) (44.05) (92.54) (368.90) 298.64% MAINT OF GARAGE AND STOCKROOM 43,995.58 44,240.70 271,799.85 313,151.87, 15.21% MAINT OF METERS 0.00 0.00 0.00 0.00'1 0.00% MAINT OF GEN PLANT 7,286.83 11,974.18 138,005.87 74,637.52 -45.92% TOTAL MAINTENANCE EXPENSES 208,813.65 1,920,847.36 1,732,112.83 -9.83% 235,485.37 DEPRECIATION EXPENSE 321,788.79 328,732.65 2,252,521.53 2,301,128.55, 2.16% PURCHASED POWER FUEL EXPENSE 3,456,178.99 3,163,761.69 19,290,344.43 21,019,051.42!, 8.96% VOLUNTARY PAYMENTS TO TOWNS 118,000.00 118,000.00 816,754.00 814,973.00' -0.22% TOTAL OPERATING EXPENSES 5.96% 50,690,655.941 47,839,878.01 7,188,686.04 7,455,401.30 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED OPERATING EXPENSE VARIANCE REPORT 1/31/16 SCHEDULE G (12A) ACTUAL BUDGET 1 % OPERATION EXPENSES: YEAR TO DATE YEAR TO DATE VARIANCE * CHANGE PURCHASED POWER CAPACITY 11,083,628.14 10,523,475.00 560,153.14 �.32% PURCHASED POWER TRANSMISSION 7,686,115.05 7,588,030.00 98,085.05 4.29% TOTAL PURCHASED POWER 18,769,743.19 658,238.19.63% 18,111,505.00 OPERATION SUP AND ENGINEERING EXP 317,019.40 372,529.00 (55,509.60) -14.90% STATION SUP LABOR AND MISC 88,712.54 48,718.00 39,994.54 8 .09% LINE MISC LABOR AND EXPENSE 411,409.43 397,125.00 14,284.43 .60% STATION LABOR AND EXPENSE 232,823.80 262,145.00 (29,321.20) -1 .19% STREET LIGHTING EXPENSE 70,515.07 54,724.00 15,791.07 2 .86% METER EXPENSE 130,138.17 128,622.00 1,516.1718% MISC DISTRIBUTION EXPENSE 258,409.61 268,933.00 (10,523.39) - .91% METER READING LABOR & EXPENSE 16,444.63 19,144.00 (2,699.37) -14.10% ACCT & COLL LABOR & EXPENSE 963,408.88 990,267.00 (26,858.12) -.71% UNCOLLECTIBLE ACCOUNTS 70,000.00 70,000.00 0.00 .00% ENERGY AUDIT EXPENSE 330,721.86 283,002.00 47,719.86 1 .86% ADMIN & GEN SALARIES 514,887.61 485,230.00 29,657.61 .11% OFFICE SUPPLIES & EXPENSE 188,549.60 175,700.00 12,849.60 .31% OUTSIDE SERVICES 191,653.85 243,127.00 (51,473.15) -2 .17% PROPERTY INSURANCE 218,048.71 271,950.00 (53,901.29) -1 .82% INJURIES AND DAMAGES 28,173.88 30,147.00 (1,973.12) 54% EMPLOYEES PENSIONS & BENEFITS 1,593,232.94 1,569,756.00 23,476.94 .50% MISC GENERAL EXPENSE 88,964.21 176,067.00 (87,102.79) _4.47% RENT EXPENSE 100,135.81 123,669.00 (23,533.19) 1 .03% ENERGY CONSERVATION 240,396.95 475,335.00 (234,938.05) -410.43% TOTAL OPERATION EXPENSES -6 I .09% i (392,543.05) 6,446,190.00 6,053,646.95 MAINTENANCE EXPENSES: MAINT OF TRANSMISSION PLANT 1,589.58 1,750.00 (160.42)17% MAINT OF STRUCT AND EQUIPMENT 217,441.42 226,268.00 (8,826.58) -3.90% MAINT OF LINES - OH 969,092.22 1,149,336.00 (180,243.78) -1p.68% MAINT OF LINES - UG 68,899.79 108,785.00 (39,885.21) 3 .66% MAINT OF LINE TRANSFORMERS 87,669.33 225,000.00 (137,330.67) 6 .04% MAINT OF ST LT & SIG SYSTEM (368.90) 5,900.00 (6,268.90) -1025% MAINT OF GARAGE AND STOCKROOM 313,151.87 390,692.00 (77,540.13) -1 .85% MAINT OF METERS 0.00 33,677.00 (33,677.00) -10 .00% MAINT OF GEN PLANT 74,637.52 103,950.00 (29,312.48) -2 .20% TOTAL MAINTENANCE EXPENSES 1,732,112.83 2,245,358.00 (513,245.17) -22.86% DEPRECIATION EXPENSE 2,301,128.55 2,323,510.00 (22,381.45) -10.96% PURCHASED POWER FUEL EXPENSE 21,019,051.42 20,861,670.00 157,381.42 0.75% VOLUNTARY PAYMENTS TO TOWNS 814,973.00 826,000.00 (11,027.00) -1.33% TOTAL OPERATING EXPENSES 0.24% (123,577.06) 50,814,233.00 50,690,655.94 * ( ) = ACTUAL UNDER BUDGET (12A) (12e) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED OPERATING EXPENSE VARIANCE REPORT 1/31/16 L RESPONSIBLE REMAINING SENIOR 2016 ACTUAL BUDGET REMAINING OPERATION EXPENSES: MANAGER ANNUAL BUDGET YEAR TO DATE BALANCE BUDGET % PURCHASED POWER CAPACITY JP 17,095,785.00 11,083,628.14 6,012,156.86 35.17% PURCHASED POWER TRANSMISSION JP 12,600,639.00 7,686,115.05 4,914,523.95 39.00% TOTAL PURCHASED POWER 29,696,424.00 18,769,743.19 10,926,680.81 36.79% OPERATION SUP AND ENGINEERING EXP HJ 629,691.00 317,019.40 312,671.60 49.65% STATION SUP LABOR AND MISC HJ 84,858.00 88,712.54 (3,854.54) -4.54% LINE MISC LABOR AND EXPENSE HJ 666,641.00 411,409.43 255,231.57 38.29% STATION LABOR AND EXPENSE HJ 448,347.00 232,823.80 215,523.20 48.07% STREET LIGHTING EXPENSE HJ 93,347.00 70,515.07 22,831.93 24.46% METER EXPENSE HJ 233,648.00 130,138.17 103,509.83 44.30% MISC DISTRIBUTION EXPENSE HJ 457,068.00 258,409.61 198,658.39 43.46% METER READING LABOR & EXPENSE HJ 32,578.00 16,444.63 16,133.37 49.52% ACCT & COLL LABOR & EXPENSE RF 1,693,219.00 963,408.88 729,810.12 l 43.10% UNCOLLECTIBLE ACCOUNTS JP 120,000.00 70,000.00 50,000.00 41.67% ENERGY AUDIT EXPENSE JP 482,273.00 330,721.86 151,551.14 31.42% ADMIN & GEN SALARIES CO 838,461.00 514,887.61 323,573.39 38.59% OFFICE SUPPLIES & EXPENSE CO 301,000.00 188,549.60 112,450.40 37.36% OUTSIDE SERVICES CO 377,332.00 191,653.85 185,678.15 49.21% PROPERTY INSURANCE HJ 466,200.00 218,048.71 248,151.29 53.23% INJURIES AND DAMAGES HJ 51,254.00 28,173.88 23,080.12 1 45.03% EMPLOYEES PENSIONS & BENEFITS HJ 2,633,591.00 1,593,232.94 1,040,358.06 39.50% MISC GENERAL EXPENSE CO 231,022.00 88,964.21 142,057.79 61.49% RENT EXPENSE HJ 212,000.00 100,135.81 111,864.19 52.77% ENERGY CONSERVATION JP 816,602.00 240,396.95 576,205.05 70.56% TOTAL OPERATION EXPENSES 10,869,132.00 6,053,646.95 4,815,485.05 44.30% MAINTENANCE EXPENSES: ! MAINT OF TRANSMISSION PLANT HJ 3,000.00 1,589.58 1,410.42 47.01% MAINT OF STRUCT AND EQUIPMT HJ 484,026.00 217,441.42 266,584.58 55.08% MAINT OF LINES - OH HJ 1,675,794.00 969,092.22 706,701.78 42.17% MAINT OF LINES - UG HJ 130,694.00 68,899.79 61,794.21 47.28% MAINT OF LINE TRANSFORMERS HJ 156,000.00 87,669.33 68,330.67 43.80% MAINT OF ST LT & SIG SYSTEM HJ 9,745.00 (368.90) 10,113.90 103.79% MAINT OF GARAGE AND STOCKROOM HJ 660,131.00 313,151.87 346,979.13 52.56% MAINT OF METERS HJ 43,875.00 0.00 43,875.00 100.00% MAINT OF GEN PLANT RF 178,200.00 74,637.52 103,562.48 58.12% TOTAL MAINTENANCE EXPENSES 3,341,465.00 1,732,112.83 1,609,352.17 48.16% DEPRECIATION EXPENSE RF 3,983,145.00 2,301,128.55 1,682,016.45 42.23% PURCHASED POWER FUEL EXPENSE JP 34,326,329.00 21,019,051.42 13,307,277.58 38.77% VOLUNTARY PAYMENTS TO TOWNS RF 1,416,000.00 814,973.00 601,027.00 42.45% TOTAL OPERATING EXPENSES 39.39% 32,941,839.06 50,690,655.94 83,632,495.00 (12e) PROFESSIONAL SERVICES BY VENDOR TOWN OF READING, MASSACHUSETTS ACTUAL MELANSON HEATH 28,500.00 MUNICIPAL LIGHT DEPARTMENT 36,468.78 CHOATE HALL & STEWART 589.60 COTTE MANAGEMENT CONSULTING LLC PROFESSIONAL SERVICES UTILITY SERVICE INC. 7,700.00 RUBIN AND RUDMAN 66,960.97 01/31/2016 17,146.25 PLM ELECTRIC POWER ENGINEERING 17,042.00 PROFESSIONAL SERVICES BY PROJECT 16,612.50 TOTAL 191,653.85 ITEM DEPARTMENT ACTUAL BUDGET VARIANCE 1 RMLD AND PENSION TRUST AUDIT FEES ACCOUNTING 28,895.25 35,000.00 (6,104.75) 2 LEGAL-FERC/ISO/POWER/OTHER INTEGRATED RESOURCES 55,158.60 80,675.00 (25,516.40) 3 NERC COMPLIANCE AND AUDIT E & O 20,475.85 9,500.00 10,975.85 4 LEGAL- SOLAR/FIBER ENGINEERING 17,042.00 5,831.00 111,211.00 5 LEGAL -GENERAL GM 27,419.40 43,750.00 (16,330.60) 6 LEGAL SERVICES HR 26,050.25 46,790.00 (20,739.75) 7 SURVEY RIGHT OF WAY/ ENVIRONMENTAL BLDG. MAINT. 0.00 5,831.00 (5,831.00) 8 INSURANCE CONSULTANT/OTHER GEN. BENEFIT 16,612.50 15,750.00 ' 862.50 TOTAL 191,653.85 243,127.00 (51,473.15) PROFESSIONAL SERVICES BY VENDOR ACTUAL MELANSON HEATH 28,500.00 DUNCAN AND ALLEN 36,468.78 CHOATE HALL & STEWART 589.60 COTTE MANAGEMENT CONSULTING LLC 633.75 UTILITY SERVICE INC. 7,700.00 RUBIN AND RUDMAN 66,960.97 SMERCZYNSKI & CONN, PC 17,146.25 PLM ELECTRIC POWER ENGINEERING 17,042.00 FLEET COUNSELOR SERVICES INC. 16,612.50 TOTAL 191,653.85 RMLD DEFERRED FUEL CASH RESERVE ANALYSIS 1/31/16 X14) GROSS MONTHLY TOTAL DATE CHARGES REVENUES NYPA CREDIT DEFERRED DEFERRED Jun -15 5,180,j285.15 Jul -15 3,492,949.80 3,083,024.15 (65,798.90) (475,724.55) 4,704,j560.60 Aug -15 3,269,589.09 3,172,916.67 (70,099.15) (166,771.57) 4,537,1789.03 Sep -15 3,302,139.93 3,385,022.47 (100,901.03) (18,018.49) 4,519,770.54 Oct -15 2,543,916.53 2,607,127.52 (105,545.52) (42,334.53) 4,477,1436.01 Nov -15 2,489,548.12 2,551,186.05 (87,425.40) (25,787.47) 4' 451'1648.54 Dec -15 2,757,146.26 2,826,699.78 (91,032.01) (21,478.49) 4,430,170.05 Jan -16 3,163,761.69 2,656,333.87 (108,747.38) (616,175.20) 3,813,1994.85 X14) DIVISION BUSINESS DIVISION INTEGRATED RESOURCES ENGINEERING AND OPERATIONS FACILITY GENERAL MANAGER SUB -TOTAL RMLD BUDGET / ACTUAL COMPARISON SUMMARY SCHEDULE 1/31/16 ACTUAL BUDGET VARIANCE 5,842,151 5,918,112 (75,961) 626,277 839,013 (212,736) 2,783,026 3,181,600 (398,573) 2,618,010 2,775,752 (157,741) 417,399 510,304 (92,905) 12,286,864 13,224,781 (937,917) VAR % -1.28% 25.36% -12.53% -5.68% I-18.21% -7.09% PURCHASED POWER BASE 18,769,743 18,111,505 658,238 3.63% PURCHASED POWER FUEL 21,019,051 20,861,670 157,381 0.75% TOTAL 52,075,658 52,197,956 (122,298) -0.23% O O O O O O O O O O Lr) O Ln Lli 1 r -i -i Ln .� � M dJ LL 0) L!1 1.0 00 M N Ql M Ol 10 C � p 00 06 Ln N Ln U Ql Ln 00 O 00 l0 > I� N O a) M Z 00 4mJ oo Ln O � M Ln 00 Ln M O (N 1:1- r -I � N N CLO r�-I p a a) M (.0 M O m 00 Ln m l0 m co M d' _ a -J O O Q m O O IO O 0 O 4-0L m N UD Q LL z GJ two V l0 r.1 Cr) N Lr)O N r- r - l0 00 v Q1 O 00 O O00 r-1 r -I r -I CO N m 01 O O l0 Q1 Z m 00 � r-1 O O am Lo a r- m N k.0 r - a) Ln =rte C c0 v =3 0.0 U 00 r� O O O O O LL r -I 00 O O O O O LI1 O Ln O Lfl N N 1 r -I l0 r.1 Cr) N Lr)O N r- r - l0 00 v Q1 O 00 O O00 r-1 r -I r -I CO N m 01 O O l0 Q1 Z m 00 � r-1 O O am Lo a r- m N k.0 r - a) Ln =rte C c0 v =3 0.0 U 00 r� N O LL r -I 00 m 00 N Lli l0 r.1 Cr) N Lr)O N r- r - l0 00 v Q1 O 00 O O00 r-1 r -I r -I CO N m 01 O O l0 Q1 Z m 00 � r-1 O O am Lo a r- m N k.0 r - a) Ln =rte C c0 v =3 0.0 U LL N m co LA qo 00 �D 00 Ln 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 r, o �o � � � � 4J ca ', O 4-J a-0 U a v N N W VC W W LM W � 3 m 0Q a 0 � L N M U L m CL V N O O O O N N fC O O -------------- o O O L rq N } OO------------- Lq I -q 4a N U o Q O ■ • o ti • N O d -J o Ln 0 0 N i-1 O L O m - pO } O o � N O O � - o L,m rq Ch ■ C) 0 0 0 0 O 0 0 0 O LqW W N 0 Z a Q W _Vf a = a Q � V a W W CL W O +� O 11:t 11:TM Ln rM-I Ct m +- N w r -I m I- m I- N Ln O ro roM -p M N ri n (3 }(v OIct 00 m M �t r- O O� M l0 00 r -I N M Lf1 l0 I� 00 Ol 00 I- O 00 Ict O N — M 00 c-4 -i o� rn� r, r-, CU M U 00 N N 00 Ql I, 00 0 } Q 1-0 o r1 � M n r, o N M Lr lD I� cr Q v O N N = Q V) O Z 0 LL ■ ■ a ■ ■ ■ ■ ■ 0000000000, 0000000000 0000000000 0000000000 IUD 0000000000 0000000000 OMOOrl-1OLnl;l-MNr-I ri LL O +� O 11:t 11:TM Ln rM-I Ct m +- N w r -I m I- m I- N Ln O ro roM -p M N ri n (3 }(v OIct 00 m M �t r- O O� M l0 00 r -I N M Lf1 l0 I� 00 Ol 00 I- O 00 Ict O N — M 00 c-4 -i o� rn� r, r-, CU M U 00 N N 00 Ql I, 00 0 } Q 1-0 o r1 � M n r, o N M Lr lD I� cr Q v O N N = Q V) O Z 0 LL ■ ■ a ■ ■ ■ ■ ■ •� ' d O r.NL. 4J N �e C N C FINANCIAL REPORT FEBRUARY 29, 2016 t,,, ISSUE DATE: MARCH 24, 2016 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS -TYPE PROPRIETARY FUND STATEMENT OF NET ASSETS 2/29/16 am CURRENT YEAR'', 14,636,061.165 20,427,919.09 1,284,061.45 8,055,499.20 2,123,765.16 1,547,815.00 1 9.90 AIA Ila 26, 993.15 71 1O4 AOA rl 10,495,643.2 889,381.63 967,879.15 i inn Tan ni 3,070,487. 71,195,894.,53 5,572,515.1,04 25,565,322.04 102.333.731.61 PREVIOUS YEAR ASSETS CURRENT UNRESTRICTED CASH (SCH A P.9) 12,001,155.54 RESTRICTED CASH (SCH A P.9) 21,084,408.77 RESTRICTED INVESTMENTS (SCH A P.9) 1,292,906.26 RECEIVABLES, NET (SCH B P.10) 10,666,277.35 PREPAID EXPENSES (SCH B P.10) 1,606,891.32 OTHER DEFERRED DEBITS (SCH B P.10) 0.00 INVENTORY 1,493,429.44 TOTAL CURRENT ASSETS 48,145,068.68 NONCURRENT INVESTMENT IN ASSOCIATED CO (SCH C P.2) 26,993.75 CAPITAL ASSETS, NET (SCH C P.2) 69,569,059.01 TOTAL NONCURRENT ASSETS 69,596,052.76 TOTAL ASSETS 117,741,121.44 LIABILITIES CURRENT ACCOUNTS PAYABLE 8,641,226.71 CUSTOMER DEPOSITS 834,764.91 CUSTOMER ADVANCES FOR CONSTRUCTION 560,369.71 ACCRUED LIABILITIES 138,095.59 TOTAL CURRENT LIABILITIES 10,174,456:92 NONCURRENT ACCRUED EMPLOYEE COMPENSATED ABSENCES 2,918,870.73 TOTAL NONCURRENT LIABILITIES 2,918,870.73 TOTAL LIABILITIES 13,093,327.65 NET ASSETS INVESTED IN CAPITAL ASSETS, NET OF RELATED DEBT 69,569,059.01 RESTRICTED FOR DEPRECIATION FUND (P. 9) 5,769,263.04 UNRESTRICTED 29,309,471.74 TOTAL NET ASSETS (P.3) 104,647,793.79 TOTAL LIABILITIES AND NET ASSETS 117,741,121.44 am CURRENT YEAR'', 14,636,061.165 20,427,919.09 1,284,061.45 8,055,499.20 2,123,765.16 1,547,815.00 1 9.90 AIA Ila 26, 993.15 71 1O4 AOA rl 10,495,643.2 889,381.63 967,879.15 i inn Tan ni 3,070,487. 71,195,894.,53 5,572,515.1,04 25,565,322.04 102.333.731.61 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT NONCURRENT ASSET SCHEDULE 2/29/16 SCHEDULE C PREVIOUS YEAR CURRENT YEAR SCHEDULE OF INVESTMENTS IN ASSOCIATED COMPANIES NEW ENGLAND HYDRO ELECTRIC 2,975.74 2,9 5.74 NEW ENGLAND HYDRO TRANSMISSION 24,018.01 24,0 8.01 TOTAL INVESTMENTS IN ASSOCIATED COMPANIES 26,993.75 26,9 3.75 SCHEDULE OF CAPITAL ASSETS LAND 1,265,842.23 1,265,8 2.23 STRUCTURES AND IMPROVEMENTS 6,180,734.51 7,222,5 8.66 EQUIPMENT AND FURNISHINGS 12,455,535.19 12,004,3 5.11 INFRASTRUCTURE 49,666,947.08 50,703,0 8.53 TOTAL CAPITAL ASSETS, NET 69,569,059.01 71,195,8 4.53 TOTAL NONCURRENT ASSETS 69,596,052.76 71,222,8 8.28 (2) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS -TYPE PROPRIETARY FUND STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND NET ASSETS 2/29/16 OPERATING REVENUES: (SCH D P.11) BASE REVENUE FUEL REVENUE PURCHASED POWER CAPACITY FORFEITED DISCOUNTS ENERGY CONSERVATION REVENUE NYPA CREDIT TOTAL OPERATING REVENUES OPERATING EXPENSES: (SCH E P.12) PURCHASED POWER CAPACITY PURCHASED POWER TRANSMISSION PURCHASED POWER FUEL OPERATING MAINTENANCE DEPRECIATION VOLUNTARY PAYMENTS TO TOWNS TOTAL OPERATING EXPENSES OPERATING INCOME NONOPERATING REVENUES (EXPENSES) TRIBUTIONS IN AID OF CONST TURN ON INVESTMENT TO READING INTEREST INCOME INTEREST EXPENSE OTHER (MDSE AND AMORT) TOTAL NONOPERATING REV (EXP) CHANGE IN NET ASSETS NET ASSETS AT BEGINNING OF YEAR NET ASSETS AT END OF FEBRUARY uq MONTH LAST YEAR MONTH CURRENT YEAR LAST YEAR CURRENT YEAR 3,579,980.29 996,019.46 3,056,024.39 TO DATE TO DATE 1,899,560.28 3,061,242.48 1,975,246.75 14,838,771.99 16,074,254.65 2,708,988.35 2,978,402.24 2,712,157.40 23,799,690.04 23,260,712.75 66,758.80 69,784.06 20,273,384.40 20,210,352.21 60,570.24 58,597.80 534,751.53 466,132.63 543,606.67 (114,961.73) (115,171.18) (597,415 15) 458,032.24 (744,720.57) 7,682,158.42 7,679,017.07 59,315,315.44 59,802,237.95 1,491,533.27 944,966.16 1,414,227.65 11,362,115.95 12,497,855.79 3,579,980.29 996,019.46 3,056,024.39 8,210,139.06 22,870,324.72 8,682,134.51 862,633.71 885,903.79 7,286,288.82 24,075,075.81 6,939,550.74 320,830.79 321,788.79 329,107.97 328,732.65 2,241,678.15 2,061,220.80 118,000.00 118,000.00 2,574,310.32 934,754.00 2,629,861.20 932.973.00 7,639,733.01 7,128,015.91 55,479,611.02 57,818,671.85 42,425.41 551,001.16 3,835,704.42 1,983,566.10 8,629.83 (194,405.26) 863.72 (197,537.08) 89,491.75 (1,555,242.02) 46,800.95 11,084.59 13,702.55 92,630.40 (1,580,296.66) 92,948.88 (251.38) 51,323.31 (184.37) 1,335.11 (3,293.45) (40) 315,168.53 3488,,056.056.51 (123,618.91) (181,820.07) (1,061,F44.79) (1,094,917.72) (81,193.50) 369,181.09 2,774,459.63 (3) YTD 6 CHANGE 8.336 -2.266 -0.316 1.666 -1.746 24.666 0.826 10.006 5.756 5.276 -4.766 -8.056 2.166 -0.196 4.226 -48.296 -47.706 1.616 0.346 -26.306 10.446 3.176 888,648.38 67.976 101,873,334.16 101,445,083.23 -0.426 104,647,793.79 102,333,731.61 -2.216 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS -TYPE PROPRIETARY FUND STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND NET ASSETS 2/29/16 OPERATING REVENUES: (SCH F P.11B) BASE REVENUE FUEL REVENUE PURCHASED POWER CAPACITY FORFEITED DISCOUNTS ENERGY CONSERVATION REVENUE NYPA CREDIT TOTAL OPERATING REVENUES OPERATING EXPENSES: (SCH G P.12A) PURCHASED POWER - CAPACITY PURCHASED POWER - TRANSMISSION PURCHASED POWER FUEL OPERATING MAINTENANCE DEPRECIATION VOLUNTARY PAYMENTS TO TOWNS TOTAL OPERATING EXPENSES OPERATING INCOME NONOPERATING REVENUES (EXPENSES) CONTRIBUTIONS IN AID OF CONST RETURN ON INVESTMENT TO READING INTEREST INCOME INTEREST EXPENSE OTHER (MDSE AND AMORT) TOTAL NONOPERATING REV (EXP) CHANGE IN NET ASSETS NET ASSETS AT BEGINNING OF YEAR NET ASSETS AT END OF FEBRUARY * ( ) = ACTUAL UNDER BUDGET ACTUAL BUDGET 703,732.79 YEAR TO DATE YEAR TO DATE VARIANCE* 16,074,254.65 15,866,845.00 207,409.65 23,260,712.75 24,590,078.00 (1,329,365.25) 20,210,352.21 20,441,549.00 (231,196.79) 543,606.67 476,007.00 67,599.67 458,032.24 460,601.00 (2,568.76) (744,720.57) (600,000.00) (144,720.57) 59,802,237.95 61,235,080.00 (1,432,842.05) 12,497,855.79 11,794,123.00 703,732.79 8,682,134.51 8,647,426.00 34,708.51 24,075,075.81 23,990,078.00 84,997.81 6,939,550.74 7,295,612.00 (356,061.26) 2,061,220.80 2,506,486.00 (445,265.20) 2,629,861.20 2,655,440.00 (25,578.80) 932,973.00 944,000.00 (11,027.00) 57,818,671.85 57,833,165.00 (14,493.15) 1,983,566.10 3,401,915.00 (1,418,348.90) CHANGE 1.31% 5.41% $1.13% 14.20% *0.56% }4.12% 2.34% 5.97% 0.40% 0.35% 4.88% 7.76% 0.96% 1.17% 0.03% 69% 46,800.95 150,000.00 (103,199.05) -08.80% -161.54% (1,580,296.66) (1,580,000.00) (296.66) 0.02% 92,948.88 100,000.00 (7,051.12) x7.05% (2,427.40) (1,400.00) (1,027.40) }73.39% 348,056.51 240,000.00 108,056.51 5.02% 10.32% (1,094,917.72) (1,091,400.00) (3,517.72) 888,648.38 2,310,515.00 (1,421,866.62) -161.54% 101,445,083.23 101,445,083.23 0.00 0.00% 102,333,731.61 103,755,598.23 (1,421,866.62) X1.37% (3A) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT RECONCILIATION OF CAPITAL FUNDS 2/29/16 SOURCE OF CAPITAL FUNDS: DEPRECIATION FUND BALANCE 7/1/15 5,434,307.79 CONSTRUCTION FUND BALANCE 7/1/15 1,400,000.00 INTEREST ON DEPRECIATION FUND FY 16 17,705.25 DEPRECIATION TRANSFER FY 16 2,629,861.20 TOTAL SOURCE OF CAPITAL FUNDS 9,481,874.24 USE OF CAPITAL FUNDS: LESS PAID ADDITIONS TO PLANT THRU FEBRUARY TOTAL USE OF CAPITAL FUNDS 3,909,359.20 GENERAL LEDGER CAPITAL FUNDS BALANCE 2/29/16 5,572,515.04 (4) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SALES OF KILOWATT HOURS 2/29/16 MUNICIPAL SALES: STREET LIGHTING MUNICIPAL BUILDINGS TOTAL MUNICIPAL CONSUMERS SALES FOR RESALE SCHOOL TOTAL KILOWATT HOURS SOLD 242,710 MONTH MONTH LAST YEAR CURRENT YEAR SALES OF ELECTRICITY: LAST YEAR CURRENT YEAR TO DATE TO DATE RESIDENTIAL SALES 23,343,797 20,189,956 178,865,482 175,694,971 COMM. AND INDUSTRIAL SALES 35,179,051 31,394,621 275,637,686 265,723,016 PRIVATE STREET LIGHTING 79,525 84,883 632,921 647,162 TOTAL PRIVATE CONSUMERS 58,602,373 51,669,460 455,136,089 442,065,149 MUNICIPAL SALES: STREET LIGHTING MUNICIPAL BUILDINGS TOTAL MUNICIPAL CONSUMERS SALES FOR RESALE SCHOOL TOTAL KILOWATT HOURS SOLD 242,710 225,854 1,942,485 1,833,620 1,024,376 817,744 6,646,477 6,219,229 1,267,086 1,043,596 8,588,962 8,052,849 317,534 247,150 2,337,611 2,204,294 1,639,613 1,319,021 10,318,189 9,630,232 61,826,606 54,279,229 476,380,851 461,952,524 (5) YTS CHANGE -�.77% -3.60% .25% -�.87% 60% .43% -�.24% - .70% -�.67% -x.03% TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT KILOWATT HOURS SOLD BY TOWN 2/29/16 TOTAL READING LYNNFIELD NO.READINGWILMINGTON MONTH RESIDENTIAL 20,189,956 6,269,089 3,025,777 4,526,570 6 368,520 COMM & IND 31,394,621 4,210,282 259,470 4,795,774 22 129,095 PVT ST LIGHTS 84,883 15,468 2,455 25,741 41,219 PUB ST LIGHTS 225,854 76,233 29,277 40,268 80,076 MUNI BLDGS 817,744 249,781 163,484 103,115 301,364 SALES/RESALE 247,150 247,150 0 0 0 SCHOOL 1,319,021 462,171 304,433 248,280 304,137 TOTAL 54,279,229 11,530,174 3,784,896 9,739,748 29,224,411 YEAR TO DATE RESIDENTIAL 175,694,971 55,612,868 25,233,435 40,587,858 54 260,810 COMM & IND 265,723,016 32,715,590 2,151,583 41,738,097 189 117,746 PVT ST LIGHTS 647,162 111,444 14,096 200,506 1321,116 PUB ST LIGHTS 1,833,620 618,510 241,833 324,292 1648,985 MUNI BLDGS 6,219,229 1,487,273 1,363,654 1,069,260 2,299,042 SALES/RESALE 2,204,294 2,204,294 0 00 SCHOOL 9,630,232 3,320,039 2,091,829 1,984,600 21233,764 TOTAL 461,952,524 96,070,018 31,096,430 85,904,613 248 881 463 LAST YEAR TO DATE RESIDENTIAL 178,865,482 55,629,800 25,715,875 40,756,425 561763,382 COMM & IND 275,637,686 34,452,729 2,187,350 42,608,138 196 389,469 PVT ST LIGHTS 632,921 107,028 12,159 198,548 315,186 PUB ST LIGHTS 1,942,485 652,739 262,296 341,435 686,015 MUNI BLDGS SALES/RESALE SCHOOL 6,646,477 2,337,611 10,318,189 1,774,221 2,337,611 3,469,096 1,376,538 0 2,160,829 1,160,581 0 1,719,100 2 2 335,137 0 969,164 TOTAL 476,380,851 98,423,224 31,715,047 86,784,227 259 458,353 KILOWATT HOURS SOLD TO TOTAL TOTAL READING LYNNFIELD NO.READING WILMINGTON MONTH RESIDENTIAL 37.19% 11.55% 5.57% 8.34% 11.73% COMM & IND 57.84% 7.76% 0.48% 8.84% 40.76% PVT ST LIGHTS 0.16% 0.03% 0.00% 0.05% 0.08% PUB ST LIGHTS 0.41% 0.14% 0.05% 0.07% 0.15% MUNI BLDGS 1.51% 0.46% 0.30% 0.19% 0.56% SALES/RESALE 0.46% 0.46% 0.00% 0.00% 0.00% SCHOOL 2.43% 0.85% 0.56% 0.46% 0.56% TOTAL 100.00% 21.25% 6.96% 17.95% 53.84% YEAR TO DATE RESIDENTIAL 38.03% 12.04% 5.46% 8.79% 11.74% COMM & IND 57.52% 7.08% 0.47% 9.04% 40.93% PVT ST LIGHTS 0.14% 0.02% 0.00% 0.04% 0.08% PUB ST LIGHTS 0.40% 0.13% 0.05% 0.07% 0.15% MUNI BLDGS 1.35% 0.32% 0.30% 0.23% 0.50% SALES/RESALE 0.48% 0.48% 0.00% 0.00% 0.00% SCHOOL 2.08% 0.72% 0.45% 0.43% 0.48% TOTAL 100.00% 20.79% 6.73% 18.60% 53.88% LAST YEAR TO DATE RESIDENTIAL 37.52% 11.68% 5.44% 8.64% 11.76% COMM & IND 58.00% 7.14% 0.46% 8.93% 41.47% PVT ST LIGHTS 0.13% 0.02% 0.00% 0.04% 0.07% PUB ST LIGHTS MUNI BLDGS 0.41% 1.36% 0.14% 0.34% 0.06% 0.28% 0.07% 0.24% 0.14% 0.50% SALES/RESALE 0.49% 0.49% 0.00% 0.00% 0.00% SCHOOL 2.09% 0.71% 0.44% 0.33% 0.61% TOTAL 100.00% 20.52% 6.68% 18.25% 54.55% (6) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT FORMULA INCOME 2/29/16 TOTAL OPERATING REVENUES (P.3) ADD: POLE RENTAL INTEREST INCOME ON CUSTOMER DEPOSITS LESS: OPERATING EXPENSES (P.3) CUSTOMER DEPOSIT INTEREST EXPENSE FORMULA INCOME (LOSS) (7) 59,802,237.95 0.00 3,532.60 (57,818,671.85) (2,427.40) 1,984,671.30 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT GENERAL STATISTICS 2/29/16 (8) MONTH OF FEB 2015 MONTH OF FEB 2016 CHANGE YEAR 2015 2016 FEB 2015 FEB 20 2016 SALE OF KWH (P.5) 61,826,606 54,279,229 0.20% -3.03% 476,380,851 4611,952,524 KWH PURCHASED 57,903,974 54,713,763 -3.38% 1.76% 476,275,857 484,666,417 AVE BASE COST PER KWH 0.025759 0.025848 -39.73% 8.09% 0.023656 10.025787 AVE BASE SALE PER KWH 0.030724 0.036390 -52.76% 11.71% 0.031149 10.034796 AVE COST PER KWH 0.085447 0.081703 -15.35% 4.99% 0.071875 AVE SALE PER KWH 0.080237 0.091262 -26.63% 10.075460 4.98% 0.081108 0.085149 FUEL CHARGE REVENUE (P.3) 3,061,242.48 2,978,402.24 12.23% -2.26% 23,799,690.04 23,24,0,712.75 LOAD FACTOR 72.88% 71.85% PEAK LOAD 108,841 104,312 III (8) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF CASH AND INVESTMENTS 2/29/16 SCHEDULE A PREVIOUS YEAR CURRENT YEAR UNRESTRICTED CASH CASH - OPERATING FUND 11,998,155.54 14,633,061.65 CASH - PETTY CASH 3,000.00 3,000.00 TOTAL UNRESTRICTED CASH 12,001,155.54 14,636,061.65 RESTRICTED CASH CASH - DEPRECIATION FUND CASH - TOWN PAYMENT CASH - DEFERRED FUEL RESERVE CASH - RATE STABILIZATION FUND CASH - UNCOLLECTIBLE ACCTS RESERVE CASH - SICK LEAVE BENEFITS CASH - HAZARD WASTE RESERVE CASH - CUSTOMER DEPOSITS CASH - ENERGY CONSERVATION TOTAL RESTRICTED CASH INVESTMENTS SICK LEAVE BUYBACK TOTAL CASH BALANCE (9) 5,769,263.04 624,810.50 4,464,645.13 6,766,780.52 200,000.00 1,707,316.51 150,000.00 834,764.91 566,828.16 21,084,408.77 1,292,906.26 34,378,470.57 5,572,515.04 631,074.00 3,621,201.52 6,805,075.72 200,000.00 1,815,027.73 150,000.00 889,381.63 743,643.45 20,427,919.09 1,284,061.45 36,348,042.19 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF ACCOUNTS RECEIVABLE 2/29/16 SCHEDULE OF ACCOUNTS RECEIVABLE RESIDENTIAL AND COMMERCIAL ACCOUNTS RECEIVABLE - OTHER ACCOUNTS RECEIVABLE - LIENS ACCOUNTS RECEIVABLE - EMPLOYEE ADVANCES SALES DISCOUNT LIABILITY RESERVE FOR UNCOLLECTIBLE ACCOUNTS TOTAL ACCOUNTS RECEIVABLE BILLED UNBILLED ACCOUNTS RECEIVABLE TOTAL ACCOUNTS RECEIVABLE, NET SCHEDULE OF PREPAYMENTS PREPAID INSURANCE PREPAYMENT PURCHASED POWER PREPAYMENT PASNY PREPAYMENT WATSON PURCHASED POWER WORKING CAPITAL TOTAL PREPAYMENT OTHER DEFERRED DEBITS ACCOUNTS RECEIVABLE AGING FEBRUARY 2016: RESIDENTIAL AND COMMERCIAL LESS: SALES DISCOUNT LIABILITY GENERAL LEDGER BALANCE CURRENT 30 DAYS 60 DAYS 90 DAYS OVER 90 DAYS TOTAL (10) PREVIOUS YEAR 5,448,830.14 154,341.39 35,318.68 892.14 (317,614.11) (277,760.17) 5,044,008.07 5,622,269.28 10,666,277.35 1,249,692.62 (128,773.22) 259,957.39 213,314.42 12,700.11 1,606,891.32 0.00 2,942,907.27 (152,622.24) 2,790,285.03 SCHEDULE B', CURRENT YEAR 2,942,907.87 351,348.40 19,198. 8 543. 3 (152,622. 4) (272,225. 9) 2,889,149.25 5,166,349.$5 6 055 499. 0 409,392.p4 1,109,272. 9 307,572. 0 282,6577 6577 14,870. 6 2,090,812.61 74.94% 362,035.36 12.97% 143,280.54 5.13% 72,599.40 2.60% 121,557.12 4.36% 2,790,285.03 100.00% TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REVENUE 2/29/16 w SCHEDULE D SALES OF ELECTRICITY: MONTH LAST YEAR MONTH CURRENT YEAR LAST YEAR CURRENT YEAR YTD $ TO DATE TO DATE CHANGE RESIDENTIAL SALES COMM AND INDUSTRIAL SALES 2,211,172.75 2,486,924.22 2,012,088.05 17,037,344.66 17,456,459.94 2.46% PRIVATE STREET LIGHTING 9,522.59 2,712,966.00 10,453.86 19,781,044.21 20,186,161.73 2.05% 75,649.08 81,681.94 7,97$ TOTAL PRIVATE CONSUMERS 4,707,619.56 4_,735,507.91 36,894,037.95 37,724,303 61 2.25$ MUNICIPAL SALES: STREET LIGHTING MUNICIPAL BUILDINGS 29,865.45 77,175.99 26,031.61 238,896.10 124,039.49 -48.08% 66,462.95 522,810.99 515,327.84 -1.43% TOTAL MUNICIPAL CONSUMERS 107,041.44 92,494.56 761,707.09 639,367.33 -16.06$ SALES FOR RESALE 26,931.07 21,832.11 199,793.53 192,699.65 -3.55% SCHOOL 119,210.69 103,814.41 782,923.46 778,596.81 -0.55% SUB -TOTAL 4,960,802.76 4,953,648.99 38,638,462.03 39,334,967.40 1.80% FO PED DISCOUNTS 4W 66,758.80 69,784.06 534,751.53 543,606.67 1.66% PURCHASED POWER CAPACITY 2,708,988.35 2,712,157.40 20,273,384.40 20,210,352.21 -0.31% ENERGY CONSERVATION - RESIDENTIAL ENERGY CONSERVATION - COMMERCIAL 23,384.19 37,186.05 20 205.26,970.95 175,782.00 i_ 38,392.54 287,161.68 282,250.24 -1.71% NYPA CREDIT (114,961.73) (115,171.18) (597,415.15) (744,720.57) 24.66$ TOTAL REVENUE 7,682,158.42 7,679,017.07 59,315,315.44 0.82$ 59,802,237.95 w TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REVENUE BY TOWN 2/29/16 LAST YEAR TO DATE RESIDENTIAL TOTAL READING LYNNFIELD NO.READING WILMINGTON ,385.62 MONTH 20,303,855.20 2,883,165.15 290,099.85 3,296,816.18 13,83 ,774.02 RESIDENTIAL 2,012,088.05 629,509.64 298,325.50 450,743.50 63},509.41 ,440.72 INDUS/MUNI BLDG 2,779,428.95 365,592.71 36,602.53 390,948.34 1'98,285.37 0.07% PUB.ST.LIGHTS 26,031.61 8,766.03 3,366.59 4,660.75 221,793.03 ,238.24 PRV.ST.LIGHTS 10,453.86 1,771.36 243.13 3,350.34 _ 19 58 ,089.03 CO-OP RESALE 21,832.11 21,832.11 0.00 0.00 100.00% 0.00 SCHOOL 103,814.41 36,321.75 22,614.16 21,235.80 2,642.70 10.22% TOTAL 4,953,648.99 1,063,793.60 361,151.91 870,938.73 --2,66 764.79 0.32% THIS YEAR TO DATE 0.04% 0.06% 0.11% 0.21% 0.03% RESIDENTIAL 17,456,459.94 5,561,555.60 2,485,254.38 4,021,557.26 5,381,092.70 0.00% INDUS/MUNI BLDG 20,701,489.57 2,841,536.05 304,059.13 3,327,564.33 14,22 ,330.06 PUB.ST.LIGHTS 124,039.49 42,002.08 16,087.54 22,276.20 4 ,673.67 PRV.ST.LIGHTS 81,681.94 13,537.70 1,702.90 26,563.47 3 ,877.87 CO-OP RESALE 192,699.65 192,699.65 0.00 0.00 10.00 SCHOOL 778,596.81 269,572.70 163,494.86 169,302.69 17 ,226.56 TOTAL _ 39,334,967.40 _8_,920,903.78 2,970,598.79 7,567,263.96 19,875.200.87 LAST YEAR TO DATE RESIDENTIAL 17,037,344.66 5,324,558.00 2,433,142.14 3,875,258.90 5,40 ,385.62 INDUS/MUNI BLDG 20,303,855.20 2,883,165.15 290,099.85 3,296,816.18 13,83 ,774.02 PUB.ST.LIGHTS 238,896.10 80,113.84 32,192.64 42,148.90 8 ,440.72 PRV.ST.LIGHTS 75,649.08 12,556.82 1,477.76 24,583.79 31,030.71 0.07% CO-OP RESALE SCHOOL 199,793.53 782,923.46 199,793.53 266,613.58 0.00 161,919.70 0.00 132,597.15 221,793.03 0.00 1 Af TOTAL 38,638,462.03 8,766,800.92 2,918,832.09 7,371,404.92 _ 19 58 0.57% 424.10 7.29% PERCENTAGE OF OPERATING INCOME TO TOTAL MONTH RESIDENTIAL INDUS/MUNI BLDG PUB.ST.LIGHTS PRV.ST.LIGHTS CO-OP RESALE SCHOOL TOTAL THIS YEAR TO DATE RESIDENTIAL INDUS/MUNI BLDG PUB.ST.LIGHTS PRV.ST.LIGHTS CO-OP RESALE SCHOOL TOTAL READING LYNNFIELD NO.READING WILMINGTON 10.03% 40.62% 12.71% 6.02% 9.10% 7.46% 12.79% 56.10% 7.38% 0.74% 7.89% 0.62% 40.09% 0.53% 0.18% 0.07% 0.09% PRV.ST.LIGHTS 0.19% 0.21% 0.04% 0.00% 0.07% 0.10% 0.44% 0.44% 0.00% 0.00% 0.00% 0.00% 2.10% 0.73% 0.46% 0.43% 0.48% 0.57% 7.29% 100.00% 53.65% 21.48% 100.00% 17.58% 44.38% 14.14% 6.32% 10.22% 13.70% 52.62% 7.22% 0.77% 8.46% 36.17% 0.32% 0.11% 0.04% 0.06% 0.11% 0.21% 0.03% 0.00% 0.07% 0.11% 0.49% 0.49% 0.00% 0.00% 0.00% 1.98% 0.69% 0.42% 0.43% 0.44% TOTAL 100.00% 22.68% 7.55% 19.24% LAST YEAR TO DATE (11A) RESIDENTIAL 44.09% 13.78% 6.30% 10.03% 13.98% INDUS/MUNI BLDG 52.55% 7.46% 0.75% 8.53% 35.81% PUB.ST.LIGHTS 0.62% 0.21% 0.08% 0.11% 0.22% PRV.ST.LIGHTS 0.20% 0.03% 0.00% 0.06% 0.11% CO-OP RESALE 0.52% 0.52% 0.00% 0.00% 0.00% SCHOOL 2.02% 0.69% 0.42% 0.34% 0.57% TOTAL 100.00% 22.69% 7.55% 19.07%50.69% (11A) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED REVENUE VARIANCE REPORT 2/29/16 (11B) SCHEDULE F ACTUAL BUDGET% I YEAR TO DATE YEAR TO DATE VARIANCE * CHANGE SALES OF ELECTRICITY: RESIDENTIAL 8,666,620.09 8,623,248.00 43,372.09 0.50% COMM AND INDUSTRIAL SALES PRIVATE STREET LIGHTING 6,939,095.33 6,620,845.00 318,250.33 14.81% MUNICIPAL BUILDINGS PUBLIC STREET LIGHTING 90,905.66 252,736.00 (161,830.34) -6.03% SALES FOR RESALE 83,434.28 87,640.00 (4,205.72) -{1.80% SCHOOL 294,199.29 282,376.00 11,823.29 4.19% TOTAL BASE SALES 16,074,254.65 15,866,845.00 207,409.65 1.31% TOTAL FUEL SALES 23,260,712.75 24,590,078.00 (1,329,365.25) -$.41% TOTAL OPERATING REVENUE 39,334,967.40 40,456,923.00 (1,121,955.60) -2.7796 FORFEITED DISCOUNTS 543,606.67 476,007.00 67,599.67 1 .20% PURCHASED POWER CAPACITY 20,210,352.21 20,441,549.00 (231,196.79) -:1.13% ENERGY CONSERVATION - RESIDENTIAL 175,782.00 177,147.00 (1,365.00) -, 77% ENERGY CONSERVATION - COMMERCIAL 282,250.24 283,454.00 (1,203.76) -�.42% NYPA CREDIT (744,720.57) (600,000.00) (144,720.57) 24.12% TOTAL OPERATING REVENUES 61,235,080.00 (1,432,842.05) -2.34% 59,802,237.95 * ( ) = ACTUAL UNDER BUDGET (11B) (12) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING EXPENSES 2/29/16 SCHEDULE Ei MONTH MONTH LAST YEAR CURRENT YEAR YTD � OPERATION EXPENSES: LAST YEAR CURRENT YEAR TO DATE TO DATE I CHANGE PURCHASED POWER CAPACITY 1,491,533.27 1,414,227.65 11,362,115.95 12,497,855. 9 10.00% PURCHASED POWER TRANSMISSION 944,966.16 996,019.46 8,210,139.06 8,682,134. 1 5.75% TOTAL PURCHASED POWER 2,436,499.43 2,410,247.11 19,572,255.01 21 179 990. 0 8.21% OPERATION SUP AND ENGINEERING EXP 40,444.31 49,462.92 349,808.37 366,4822 4.77% STATION SUP LABOR AND MISC 12,973.70 13,451.58 106,634.80 102,164. 2 -4.19% LINE MISC LABOR AND EXPENSE 81,500.02 48,766.09 574,064.10 460,175. 2 -19.84% STATION LABOR AND EXPENSE 42,315.07 32,249.38 343,014.27 265,073. 8 -22.72% STREET LIGHTING EXPENSE 5,382.73 6,774.98 59,993.39 77,290. 5 28.83% METER EXPENSE 21,736.06 17,957.69 132,542.92 148,095. 6 11.73% MISC DISTRIBUTION EXPENSE 44,208.59 36,423.86 303,924.18 294,833. 7 -2.99% METER READING LABOR & EXPENSE 1,495.61 614.30 12,069.73 17,058. 3 41.34% ACCT & COLL LABOR & EXPENSE 129,043.31 124,752.97 1,181,006.22 1,088,161. 5 -7.86% UNCOLLECTIBLE ACCOUNTS 10,000.00 10,000.00 80,000.00 80,000. 0 0.00% ENERGY AUDIT EXPENSE 35,929.48 43,529.40 273,151.77 374,251. 6 37.01% ADMIN & GEN SALARIES 59,182.14 72,643.27 546,545.28 587,530. 8 7.50% OFFICE SUPPLIES & EXPENSE 28,332.82 31,413.42 202,778.65 219,963. 2 8.47% OUTSIDE SERVICES 29,298.50 31,786.95 268,542.32 223,440. 0 -16.79% PROPERTY INSURANCE 31,242.39 27,632.72 241,495.31 245,681. 3 1.73% INJURIES AND DAMAGES 3,023.31 3,627.56 29,094.03 31,801. 4 9.31% EMPLOYEES PENSIONS & BENEFITS 250,015.06 255,993.34 2,008,000.58 1,849,226. 8 -7.91% MISC GENERAL EXPENSE 5,712.20 7,329.22 105,027.62 96,293. 3 -8.32% RENT EXPENSE 13,912.38 15,734.02 112,029.81 115,869. 3 3.43% ENERGY CONSERVATION 16,886.03 55,760.12 356,565.47 296,157. 7 -16.94% TOTAL OPERATION EXPENSES 862 633.71 885 903.79 7,286,288.82 6 939 550. 4 -4.76% 4wTENANCE EXPENSES: MAINT OF TRANSMISSION PLANT 227.08 227.08 1,816.66 1,816. 6 0.00% MAINT OF STRUCT AND EQUIPMT 32,153.33 33,655.47 364,404.76 251,096. 9 -31.09% MAINT OF LINES - OH 115,189.89 220,222.62 1,154,938.12 1,189,314. 4 2.98% MAINT OF LINES - UG 35,995.52 13,373.17 113,475.34 82,272. 6 -27.50% MAINT OF LINE TRANSFORMERS 1,256.20 1,227.17 61,321.32 88,896. 0 44.97% MAINT OF ST LT & SIG SYSTEM (13.84) (69.57) (106.38) (438. 7) 312.17% MAINT OF GARAGE AND STOCKROOM 126,174.51 49,599.25 397,974.36 362,751. 2 -8.85% MAINT OF METERS 0.00 33.34 0.00 33. 4 0.00% MAINT OF GEN PLANT 9,848.10 10,839.44 147,853.97 85,476. 6 -42.19% TOTAL MAINTENANCE EXPENSES 320,830.79 329,107.97 2,241,678.15 2,061,220.60 -8.05% DEPRECIATION EXPENSE 321,788.79 328,732.65 2,574,310.32 2,629,861.0 2.16% PURCHASED POWER FUEL EXPENSE 3,579,980.29 3,056,024.39 22,870,324.72 24,075,075.gl 5.27% VOLUNTARY PAYMENTS TO TOWNS 118,000.00 118,000.00 934,754.00 932,973.00 -0.19% TOTAL OPERATING EXPENSES 7,128,015.91 4.22% 7,639,733.01 55,479,611.02 57,818,671.t5 (12) MAINTENANCE EXPENSES: MAINT OF TRANSMISSION PLANT TOWN OF READING, MASSACHUSETTS 2,000.00 (183.34) *9.17% MUNICIPAL LIGHT DEPARTMENT 251,096.89 253,698.00 (2,601.11) BUDGETED OPERATING EXPENSE VARIANCE REPORT 1,189,314.84 1,304,959.00 (115,644.16) 2/29/16 MAINT OF LINES - UG 82,272.96 111,798.00 (29,525.04) -6.41% MAINT OF LINE TRANSFORMERS SCHEDULE G 225,000.00 (136,103.50) ACTUAL BUDGET (438.47) % OPERATION EXPENSES: YEAR TO DATE YEAR TO DATE VARIANCE * CHANGE PURCHASED POWER CAPACITY 12,497,855.79 11,794,123.00 703,732.79 15.97% PURCHASED POWER TRANSMISSION 8,682,134.51 8,647,426.00 34,708.51 0.40% TOTAL PURCHASED POWER 21,179,990.30 20,441,549.00 2,061,220.80 3.61% 738,441.30 47.76% OPERATION SUP AND ENGINEERING EXP 366,482.32 417,424.00 (50,941.68) -12.20% STATION SUP LABOR AND MISC 102,164.12 55,004.00 47,160.12 5.74% LINE MISC LABOR AND EXPENSE 460,175.52 447,241.00 12,934.52 12.89% STATION LABOR AND EXPENSE 265,073.18 296,895.00 (31,821.82) -0.72% STREET LIGHTING EXPENSE 77,290.05 61,974.00 15,316.05 4.71% METER EXPENSE 148,095.86 147,750.00 345.86 10.23% MISC DISTRIBUTION EXPENSE 294,833.47 304,042.00 (9,208.53) 3.03% METER READING LABOR & EXPENSE 17,058.93 21,573.00 (4,514.07) -0.92% ACCT & COLL LABOR & EXPENSE 1,088,161.85 1,121,188.00 (33,026.15) +2.95% UNCOLLECTIBLE ACCOUNTS 80,000.00 80,000.00 0.00 0.00% ENERGY AUDIT EXPENSE 374,251.26 318,899.00 55,352.26 J7.36% ADMIN & GEN SALARIES 587,530.88 549,394.00 38,136.88 16.94% OFFICE SUPPLIES & EXPENSE 219,963.02 200,800.00 19,163.02 i9.54% OUTSIDE SERVICES 223,440.80 274,767.00 (51,326.20) -6.68% PROPERTY INSURANCE 245,681.43 310,800.00 (65,118.57) - 0.95% INJURIES AND DAMAGES 31,801.44 34,368.00 (2,566.56) 77.47% EMPLOYEES PENSIONS & BENEFITS 1,849,226.28 1,782,464.00 66,762.28 13.75% MISC GENERAL EXPENSE 96,293.43 187,819.00 (91,525.57) - 8.73% RENT EXPENSE 115,869.83 141,336.00 (25,466.17) - 8.02% ENERGY CONSERVATION 296,157.07 541,874.00 (245,716.93) - 5.35% TOTAL OPERATION EXPENSES 6,939,550.74 7,295,612.00 (356,061.26) 14.88% MAINTENANCE EXPENSES: MAINT OF TRANSMISSION PLANT 1,816.66 2,000.00 (183.34) *9.17% MAINT OF STRUCT AND EQUIPMENT 251,096.89 253,698.00 (2,601.11) 1.03% MAINT OF LINES - OH 1,189,314.84 1,304,959.00 (115,644.16) +8.86% MAINT OF LINES - UG 82,272.96 111,798.00 (29,525.04) -6.41% MAINT OF LINE TRANSFORMERS 88,896.50 225,000.00 (136,103.50) - 0.49% MAINT OF ST LT & SIG SYSTEM (438.47) 6,675.00 (7,113.47) -1 6.57% MAINT OF GARAGE AND STOCKROOM 362,751.12 447,873.00 (85,121.88) - 9.01% MAINT OF METERS 33.34 35,683.00 (35,649.66) - 9.91% MAINT OF GEN PLANT 85,476.96 118,800.00 (33,323.04) -18.05% TOTAL MAINTENANCE EXPENSES 2,061,220.80 2,506,486.00 (445,265.20) 47.76% DEPRECIATION EXPENSE 2,629,861.20 2,655,440.00 (25,578.80) 70.96% PURCHASED POWER FUEL EXPENSE 24,075,075.81 23,990,078.00 84,997.81 0.35% VOLUNTARY PAYMENTS TO TOWNS 932,973.00 944,000.00 (11,027.00) +1.17% TOTAL OPERATING EXPENSES 57,818,671.85 57,833,165.00 (14,493.15) +-0.03% * ( ) = ACTUAL UNDER BUDGET (12A) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED OPERATING EXPENSE VARIANCE REPORT 2/29/16 RESPONSIBLE SENIOR OPERATION EXPENSES: MANAGER PURCHASED POWER CAPACITY JP PURCHASED POWER TRANSMISSION JP TOTAL PURCHASED POWER OPERATION SUP AND ENGINEERING EXP HJ STATION SUP LABOR AND MISC HJ LINE MISC LABOR AND EXPENSE HJ STATION LABOR AND EXPENSE HJ STREET LIGHTING EXPENSE HJ METER EXPENSE HJ MISC DISTRIBUTION EXPENSE HJ METER READING LABOR & EXPENSE HJ ACCT & COLL LABOR & EXPENSE RF UNCOLLECTIBLE ACCOUNTS JP ENERGY AUDIT EXPENSE JP ADMIN & GEN SALARIES CO OFFICE SUPPLIES & EXPENSE CO OUTSIDE SERVICES CO PROPERTY INSURANCE HJ INJURIES AND DAMAGES HJ EMPLOYEES PENSIONS & BENEFITS HJ MISC GENERAL EXPENSE CO RENT EXPENSE HJ ENERGY CONSERVATION JP TOTAL OPERATION EXPENSES MAINTENANCE EXPENSES: 84,858.00 102,164.12 REMAINING 666,641.00 2016 ACTUAL BUDGET 'REMAINING ANNUAL BUDGET YEAR TO DATE BALANCE BUDGET % 17,095,785.00 12,497,855.79 4,597,929.21 26.90% 12,600,639.00 8,682,134.51 3,918,504.49 31.10% 29,696,424.00 21,179,990.30 8,516,433.70 28.68% 120,000.00 80,000.00 629 691 00 366 482 32 263 206 68 108,021.74 84,858.00 102,164.12 (17,306.12) 666,641.00 460,175.52 206,465.48 448,347.00 265,073.18 183,273.82 93,347.00 77,290.05 16,056.95 233,648.00 148,095.86 85,552.14 457,068.00 294,833.47 162,234.53 32,578.00 17,058.93 15,519.07 1,693,219.00 1,088,161.85 605,057.15 120,000.00 80,000.00 40,000.00 482,273.00 374,251.26 108,021.74 838,461.00 587,530.88 250,930.12 301,000.00 219,963.02 81,036.98 377,332.00 223,440.80 153,891.20 466,200.00 245,681.43 220,518.57 51,254.00 31,801.44 19,452.56 2,633,591.00 1,849,226.28 784,364.72 231,022.00 96,293.43 134,728.57 212,000.00 115,869.83 96,130.17 816,602.00 296,157.07 520,444.93 10,869,132.00 6,939,550.74 3,929,581.26 MAINT OF TRANSMISSION PLANT HJ 3,000.00 1,816.66 1,183.34 MAINT OF STRUCT AND EQUIPMT HJ 484,026.00 251,096.89 232,929.11 MAINT OF LINES - OH HJ 1,675,794.00 1,189,314.84 486,479.16 MAINT OF LINES - UG HJ 130,694.00 82,272.96 48,421.04 MAINT OF LINE TRANSFORMERS HJ 156,000.00 88,896.50 67,103.50 MAINT OF ST IT & SIG SYSTEM HJ 9,745.00 (438.47) 10,183.47 MAINT OF GARAGE AND STOCKROOM HJ 660,131.00 362,751.12 297,379.88 MAINT OF METERS HJ 43,875.00 33.34 43,841.66 MAINT OF GEN PLANT RF 178,200.00 85,476.96 92,723.04 TOTAL MAINTENANCE EXPENSES 3,341,465.00 2,061,220.80 1,280,244.20 DEPRECIATION EXPENSE RF 3,983,145.00 2,629,861.20 1,353,283.80 PURCHASED POWER FUEL EXPENSE JP 34,326,329.00 24,075,075.81 10,251,253.19 VOLUNTARY PAYMENTS TO TOWNS RF 1,416,000.00 932,973.00 483,027.00 TOTAL OPERATING EXPENSES 83,632,495.00 57,818,671.85 25,813,823.15 (12B) a1.eo% -20.39% 30.97% 40.88% 17.20% 36.62% 35.49% 47.64% 35.73% 33.33% 22.40% 29.93% 26.92% 40.78% 47.30% 37.95% 29.78% 58.32% 45.34% 63.73% 36.15% 39.44% 48.12% 29.03% 37.05% 43.02% 104.50% 45.05% 99.92% 52.03% 38.31% 33.98% 29.86% 34.11% 30.87% PROFESSIONAL SERVICES BY VENDOR MELANSON HEATH DUNCAN AND ALLEN CHOATE HALL & STEWART COTTE MANAGEMENT CONSULTING LLC UTILITY SERVICE INC. RUBIN AND RUDMAN SMERCZYNSKI & CONN, PC PLM ELECTRIC POWER ENGINEERING FLEET COUNSELOR SERVICES INC. TOTAL ACTUAL 28,500.00 36,468.78 589.60 633.75 10,850.00 93,848.92 17,146.25 18,791.00 16,612.50 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT PROFESSIONAL SERVICES 02/29/2016 PROFESSIONAL SERVICES BY PROJECT ITEM DEPARTMENT ACTUAL BUDGET VARIANCE 1 RMLD AND PENSION TRUST AUDIT FEES ACCOUNTING 28,895.25 35,000.00 2 LEGAL-FERC/ISO/POWER/OTHER INTEGRATED RESOURCES 55,234.60 92,200.00 1(6,109.75) (36,965.40) 3 NERC COMPLIANCE AND AUDIT E & 0 23,625.85 10,375.00 13,250.85 4 LEGAL- SOLAR/FIBER ENGINEERING 18,791.00 6,664.00 12,127.00 5 LEGAL -GENERAL GM 54,117.35 50,000.00 4,117.35 6 LEGAL SERVICES HR 26,050.25 55,864.00 (29,813.75) 7 SURVEY RIGHT OF WAY/ ENVIRONMENTAL BLDG. MAINT. 0.00 6,664.00 (6,664.00) 8 INSURANCE CONSULTANT/OTHER GEN. BENEFIT 16,726.50 18,000.00 (1,273.50) TOTAL 223,440.80 274,767.00 (51,326.20) PROFESSIONAL SERVICES BY VENDOR MELANSON HEATH DUNCAN AND ALLEN CHOATE HALL & STEWART COTTE MANAGEMENT CONSULTING LLC UTILITY SERVICE INC. RUBIN AND RUDMAN SMERCZYNSKI & CONN, PC PLM ELECTRIC POWER ENGINEERING FLEET COUNSELOR SERVICES INC. TOTAL ACTUAL 28,500.00 36,468.78 589.60 633.75 10,850.00 93,848.92 17,146.25 18,791.00 16,612.50 RMLD DEFERRED FUEL CASH RESERVE ANALYSIS 2/29/16 GROSS DATE CHARGES REVENUES NYPA CREDIT Jun -15 TOTAL DEFERRED DEFERRED Jul -15 3,492,949.80 3,083,024.15 (65,798.90) Aug -15 3,269,589.09 3,172,916.67 (70,099.15) Sep -15 3,302,139.93 3,385,022.47 (100,901.03) Oct -15 2,543,916.53 2,607,127.52 (105,545.52) Nov -15 2,489,548.12 2,551,186.05 (87,425.40) Dec -15 2,757,146.26 2,826,699.78 (91,032.01) Jan -16 3,163,761.69 2,656,333.87 (108,747.38) Feb -16 3,056,024.39 2,978,402.24 (115,171.18) Im MONTHLY TOTAL DEFERRED DEFERRED 5,181 ,285.15 (475,724.55) 4,70 ,560.60 (166,771.57) 4,53 ,789.03 (18,018.49) 4,51 ,770.54 (42,334.53) 4,47 ,436.01 (25,787.47) 4,45 ,648.54 (21,478.49) 4,43 ,170.05 (616,175.20) 3,81 ,994.85 (192,793.33) 3,62 ,201.52 DIVISION BUSINESS DIVISION INTEGRATED RESOURCES ENGINEERING AND OPERATIONS FACILITY GENERAL MANAGER SUB -TOTAL PURCHASED POWER.BASE PURCHASED POWER FUEL TOTAL RMLD BUDGET / ACTUAL COMPARISON SUMMARY SCHEDULE 2/29/16 ACTUAL BUDGET 6,665,331 6,747,693 725,643 952,975 3,245,725 3,553,812 3,022,873 3,155,015 486,758 573,442 14,146,330 14,982,937 21,179,990 20,441,549 24,075,076 23,990,078 VARIANCE (82,362) (227,332) (308,087) (132,142) (86,684) (836,607) 738,441 84,998 59,401,396 59,414,564 (13,168) ,VAR -1.22% -23.85% -8.67% -4.19% -15.12% -5.58% 3.61% 0.35% -0.02% RMLD Reading Municipal Light Department RELIABLE POWER FOR GENERATIONS 230 Ash Street P.O. Box 150 Reading, MA 01867-0250 Tel: (781) 944-1340 Fax: (781) 942-2409 Web: www.rmld.com March 24, 2016 Town of Reading Municipal Light Board Subject: Mailing Services for Municipal Electric Bills On December 30, 2015, a bid invitation was placed as a legal notice in the Reading Daily Times Chron Middlesex East Section, requesting bids for RMLD's Mailing Services for Municipal Electric Bills. An invitation to bid was sent to the following 15 companies: Bill Trust Data Integrators Peregrine Solutions Boston Mailing Company JLS Mailing Services PKS Associates Cathedral Corporation Kubra Royco Mailing Services Collector Solutions Mailways, Inc. RR Donnelly D3, Inc. Mass Communications Touchpoint Customer Communicatioi Bids were received from four companies: Cathedral Corporation, Data Integrators, Mass Communicati and Touchpoint Customer Communications. The bids were publicly opened and read aloud at 11:00 A.M. on Thursday, January 14, 2016, in the Toi of Reading Municipal Light Department's Wilfred E. Spurr Room, 230 Ash Street, Reading, MA. The bids were reviewed, analyzed and evaluated by staff and recommended by the General Manager. Please see attached analysis. Move that bid 2016-22 - Mailing Services for Municipal Electric Bills be awarded to: Data Integrators $55,332 for a three (3) year total ($18,444/year), as the lowest qualified, responsive and responsible bk on the recommendation of the General Manager. The FY 2016 Operating Budget amount for this item is $24,000. 07 n O'Brien Aoliert E. Fournier i Paula O'Leary' j w r -I O N r -I N m 41 f0 ' ;F 0 X, X x XII w I U ' C(D Z C Z Z Z'' I - aa x X X m N' V L E ba t Ili u- :2 x x x x 3 p a` m IA C 0 4) 4J 4) (L) u z Z Z', z X W m M 03 c x x x' x' z- 04 IAU W C -p A y I I U ~ .Q boO X X X X W U t/1 + - Z �= � J 7 [a I u X X X X'i vi N I c N u ' N LnE JO 41 U 41 > ZaJ m O O O }Q Y I W i O p cu > N U a Z ti0 O v c cu a c r -0 W�M+ :3 p m oco v a w r -I O N r -I N m t0 r-1 O N N m m c `tea 5� c O a 0 c c IRT v oho a0o 000 m c M l0' 00 n 00 cf l0 1l O - N N M M M Ct ''Z G! L m CLO O C d O O O ` f0 O O O O � N ,-; 00 Q 001 OOI Ln Lf1 M > N 000 n 00 cT ko l0 1- 0 O N N M M M -:r a L Q a19i ° oL o 'o c c 0 0 0 0 0 a, > 0 0 a, c v m Ln Q 000 0 000 m c °�° N N m m m v ° m c L 10 M o d 0 «� � 0. c O c 0 0 0 0 0 0 r o M0 Ln Ln L Ln v rn 0 m o o rn rl' N N N M M M c E M O L fl m d ° Gl i. � Q O O O O O O W 4n Wm t 04 O 0 U o '^ m -cr o o rn .-I N N N M M M c W L C N 0 l7 ° Q 0 0 0 0 c c 0 _ZI0 r� 0 0 0Ln O a m o a m o CQCI c v rn rn c G O N N' N 0 M N M c a+ ni Nm O a O o �^ 0 c O ° N CL H c cI a �1 U� a Q j a O Q E E. a W N EO EO O U jM Lc C N40 d� m 0) 1 O OJI E °i EI °I I (D 0; ,� ofl of SI o Z i al 1'Y' o, ar m U O 7; U LI �' c yf U Q = 00:I CU E ',, OD' c cLOj E N UII Oj O Ali a0+ c 1 0 aI -p; 0 1 �` UI U f6 : U N. N �'I CCD aI o v'I ISI �ol 0 iu t0 r-1 O N N m m A" Forl s 'W 'r' .Wr/ 00 8 c) 0 L, Ln Ln Ln m m N " T-, r rl i i i i i ili i i i i i •► i i i • Y r � i bw i V LM Ln L � rl tx� 4J ri N� I � I C m CL r-4 C7 r4 AW law IW Ln Ln Ln r-- r -j r-- cn m r -j r -i rl 7-4 OOH Ln Ln Ln Ln r -A r -- Ln Ln c 3 r -- r -i CY) SO 1 e s q PAI vi Ln C3 pp r-4 CWI C? (U rmi 'gyp Ql r -A Ic r -j ri r -A El C') C3 C) C) ci Cl C) C:3 0 C C 31 Gl G3 C:2 C) Cm3 C.J C-3 C3 Cj Ln C Ln Ln C3 X13 Lrl Ln 'j cr, re) SO 1 e s q PAI vi Ln C3 pp r-4 CWI C? (U rmi 'gyp Ql r -A Ic r -j ri r -A :2� A2 ru 6 z Im 03U F E Im J. N � N � t0 rq � � IO l0 � Y1 � A N 9 0 I N A de 0 U}1 4- V) 4� w 11-0 r -- O N C`) r - O N D To: Coleen O'Brien b� ,, From�aureen McHugh, Jane Parenteau Date: February 24, 2016 Subject: Purchase Power Summary — January, 2016 Energy Services Division (ESD) has completed the Purchase Power Summary for the month of January, 2016. ENERGY The RMLD's total metered load for the month was 59,069,230 kWh, which is a 4.28% decrease from the January, 2015 figures. Table 1 is a breakdown by source of the energy purchases. Table 1 *Pepperell, Woronoco, Indian River, Turner Falls, Collins, Pioneer, Hosiery Mills, Summit Hydro Amount of Cost of % of Total Total $ $ as a Resource Energy Energy Energy Costs % (kWh) ($/Mwh) Millstone#3 3,051,452 $6.71 5.21% $20,475 0.66% Seabrook 5,549,726 $6.51 9.47% $36,143 1.16% Stonybrook Intermediate 761,266 $145.03 1.30% $110,404 3.53% Shell Energy 8,455,000 $64.07 14.43% $541,697 17.34% NextEra 0 $0.00 0.00% $0 0.00% NYPA 2,442,537 $4.92 4.17% $12,017 0.38% ISO Interchange 9,481,167 $41.23 16.18% $390,874 12.51% NEMA Congestion 0 $0.00 0.00% -$30,396 -0.97% Coop Resales 14,126 $148.66 0.02% $2,100 0.07% BP Energy 9,273,600 $46.90 15.83% $434,932 13.92% Hydro Projects* 3,961,058 $87.88 6.76% $348,080 11.14% Braintree Watson Unit 149,471 $178.00 0.26% $26,605 0.85% Saddleback Wind 1,711,387 $94.78 2.92% $162,198 5.19% One Burlington Solar 169,118 $35.70 0.29% $6,037 0.19% Exelon 13,510,800 $77.73 23.06% $1,050,131 33.62% Stonybrook Peaking 65,341 $186.58 0.11% $12,191 0.39% Monthly Total 58,596,049 $53.31 100.00% $3,123,489 100.00% *Pepperell, Woronoco, Indian River, Turner Falls, Collins, Pioneer, Hosiery Mills, Summit Hydro im Table 2 breaks down the ISO interchange between the DA LMP Settlement and the RT Net Energy for the month of January, 2016. Table 2 Amount Cost % of Total Resource of Energy of Energy Energy (kWh) ($/Mwh) ISO DA LMP * 6,569,991 $30.28 11.01% Settlement RT Net Energy 2,911,172 $67.99 4.88% Settlement ISO Interchange 9,481,167 $41.23 15.88% (subtotal) ' Independent System Operator Day -Ahead Locational Marginal Price " Real Time Net Energy JANUARY 2016 ENERGY BY RESOURCE 0.26% Stonybrook Peaking crook Inter.1.30% A ' 1 T 1 A�TTt7 The RMLD hit a demand of 105,260 kW, which occurred on January 19, at 7 pm. The RMLD's monthly UCAP requirement for January, 2016 was 224,696 Ms. 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,950 30.74 $152,138 9.26% Seabrook 7,910 50.10 $396,307 24.13% Stonybrook Peaking 24,981 1.98 $49,489 3.01% Stonybrook CC 42,925 7.11 $305,143 18.58% NYPA 4,019 4.19 $16,834 1.02% Hydro Quebec 0 0 $10,581 0.64% Nextera 60,000 5.90 $354,000 21.55% Braintree Watson Unit 10,520 10.98 $115,489 7.03% ISO -NE Supply Auction 67,389 3.60 $242,354 14.76% Hydro Projects 2,002 0.00 $0 0.00% Total 224,696 $7.31 $1,642,335 100.00% Table 4 shows the dollar amounts for energy and capacity per source. * Renewable Resources 14.14% Table 4 Cost of % of Amt of Energy Power Resource Energy Capacity Total cost Total Cost (kWh) ($/kWh) Millstone #3 $20,475 $152,138 $172,614 3.62% 3,051,452 0.0566 Seabrook $36,143 $396,307 $432,451 9.07% 5,549,726 0.0779 Stonybrook Intermediate $110,404 $305,143 $415,547 8.72% 761,266 0.5459 Hydro Quebec $0 $10,581 $10,581 0.22% - 0.0000 Shell Energy $541,697 $0 $541,697 11.37% 8,455,000 0.0641 NextEra $0 $354,000 $354,000 7.43% - 0.0000 ' NYPA $12,017 $16,834 $28,851 0.61% 2,442,537 0.0118 ISO Interchange $390,874 $242,354 $633,229 13.29% 9,481,167 0.0668 Nema Congestion -$30,396 $0 -$30,396 -0.64% - 0.0000 BP Energy $434,932 $0 $434,932 9.13% 9,273,600 0.0469 Hydro Projects $348,080 $0 $348,080 7.30% 3,961,058 0.0879 Braintree Watson Unit $26,605 $115,489 $142,094 2.98% 149,471 0.9506 * Saddleback Wind $162,198 $0 $162,198 3.40% 1,711,387 0.0948 One Burlington Solar $6,037 $0 $6,037 0.13% 169,118 0.0357 Coop Resales $2,100 $0 $2,100 0.04% 14,126 0.1487 Exelon Energy $1,050,131 $0 $1,050,131 22.03% 13,510,800 0.0777 Stonybrook Peaking $12,191 $49,489 $61,680 1.29% 65,341 0.9440 Monthly Total $3,123,489 $1,642,335 $4,765,824 100.00% 58,596,049 0.0813 * Renewable Resources 14.14% RENEWABLE ENERGY CERTIFICATES (RECs) Table 5 shows the amount of banked and projected RECs for the Swift River Hydro Projects through January 2016, as well as their estimated market value. TRANSMISSION The RMLD's total transmission costs for the month of January, 2016 were $873,184. This is a decrease of 8.59% from the December transmission cost of $955,262. In January, 2015 the transmission costs were $721,439. Table 6 Current Month Table 5 Last Year Peak Demand (kW) 105,260 RECs Summary 109,061 Energy (kWh) 59,693,490 Period - January 2015 - January 2016 61,776,997 Banked Projected Total Est. $3,456,179 RECs RECs RECs Dollars Woronoco 836 3,571 4,407 $189,501 Pepperell 1,939 3,237 5,176 $222,568 Indian River 817 2,325 3,142 $135,106 Turners Falls 132 1,582 1,714 $0 Saddleback 1087 7,511 8,598 $369,714 Jericho 0 961 961 $41,323 Sub total 4,811 19,187 5 1 RECs Sold 0 $0 Grand Total 4,811 19,187 23,998 $958,212 TRANSMISSION The RMLD's total transmission costs for the month of January, 2016 were $873,184. This is a decrease of 8.59% from the December transmission cost of $955,262. In January, 2015 the transmission costs were $721,439. Table 6 Current Month Last Month Last Year Peak Demand (kW) 105,260 100,307 109,061 Energy (kWh) 59,693,490 56,019,481 61,776,997 Energy ($) $3,163,762 $2,757,146 $3,456,179 Capacity ($) $1,642,335 $1,578,215 $1,541,650 Transmission($) $873,184 $955,262 $721,439 Total $5,679,280 $5,290,623 $5,719,269 To: Coleen O'Brien Fro ureen McHugh, Jane Parentea Date: March 22, 2016 Subject: Purchase Power Summary — February, 2016 Energy Services Division (ESD) has completed the Purchase Power Summary for the month of February, 2016. ENERGY The RMLD's total metered load for the month was 54,577,455 kWh, which is a 6.06% decrease from the February, 2015 figures. Table 1 is a breakdown by source of the energy purchases. Table 1 Resource Amount of Energy Cost of Energy % of Total Energy Total $ Costs $ as a % (kWh) ($/Mwh) Millstone #3 3,456,006 $6.72 6.32% $23,210 0.76% Seabrook 5,525,334 $6.32 10.10% $34,920 1.14% Stonybrook Intermediate 8,383 $1,501.27 0.02% $12,585 0.41% Shell Energy 7,500,600 $64.09 13.71% $480,730 15.73% NextEra 0 $0.00 0.00% $0 0.00% NYPA 2,187,312 $4.92 4.00% $10,762 0.35% ISO Interchange 6,314,773 $46.30 11.54% $292,344 9.57% NEMA Congestion 0 $0.00 0.00% -$74,331 -2.43% Coop Resales 11,454 $157.81 0.02% $1,808 0.06% BP Energy 8,783,400 $46.90 16.05% $411,941 13.48% Hydro Projects" 3,907,078 $82.13 7.14% $320,877 10.50% Braintree Watson Unit 199,177 $307.64 0.36% $61,275 2.01% Saddleback/Jericho Wind 2,317,661 $157.09 4.24% $364,075 11.91% One Burlington Solar 128,962 $70.00 0.24% $9,027 0.30% Exelon 14,310,000 $76.52 26.15% $1,095,040 35.83% Stonybrook Peaking 63,623 $184.87 0.12% $11,762 0.38% Monthly Total 54,713,763 $55.85 100.00% $3,056,024 100.00% 'Pepperell, Woronoco,lndian River,Turner Falls,Collins, Pioneer,Hosiery Mills, Summit Hydro Table 2 breaks down the ISO interchange between the DA LMP Settlement and the RT Net Energy for the month of February, 2016. Table 2 Amount Cost % of Total Resource of Energy of Energy Energy (kWh) ($/Mwh) ISO DA LMP " 12,054,511 $34.57 22.03% Settlement RT Net Energy '' -5,739,738 $21.70 -10.49% Settlement ISO Interchange 6,314,773 $46.30 11.54% (subtotal) * Independent System Operator Day -Ahead Locational Marginal Price ** Real Time Net Energy FEBRUARY 2016 ENERGY BY RESOURCE ■ One ■ Stonybrook v Jericho Wind, Burlington Peaking, 0.12% 1.44% Sola ■ Saddleback, 2.81% ■ BELD, 0.36` ■ Hydro Pro, 7.16°i ■ Millstone #3, 6.33% Stonybrook ntermediate, 0.02% NYPA, 4.01% CAPACITY The RMLD hit a demand of 104,312 M, which occurred on February 8, at 6 pm. The RMLD's monthly UCAP requirement for February, 2016 was 224,700 Ms. 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,950 30.71 $152,024 10.19% Seabrook 7,910 35.15 $278,018 18.64% Stonybrook Peaking 24,981 2.07 $51,675 3.46% Stonybrook CC 42,925 7.08 $303,945 20.38% NYPA 4,019 4.19 $16,834 1.13% Hydro Quebec 0 0 $7,292 0.49% Nextera 60,000 5.90 $354,000 23.73% Braintree Watson Unit 10,520 11.08 $116,573 7.82% ISO -NE Supply Auction 67,393 3.13 $211,211 14.16% Hydro Projects 2,002 0.00 $0 0.00% Total 224,700 $6.64 $1,491,572 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) ($/kWh) Millstone #3 $23,210 $152,024 $175,234 3.85% 3,456,006 0.0507 Seabrook $34,920 $278,018 $312,938 6.88% 5,525,334 0.0566 Stonybrook Intermediate $12,585 $303,945 $316,530 6.96% 8,383 37.7586 Hydro Quebec $0 $7,292 $7,292 0.16% - 0.0000 Shell Energy $480,730 $0 $480,730 10.57% 7,500,600 0.0641 NextEra $0 $354,000 $354,000 7.78% - 0.0000 't NYPA $10,762 $16,834 $27,595 0.61% 2,187,312 0.0126 ISO Interchange $292,344 $211,211 $503,555 11.07% 6,314,773 0.0797 Nema Congestion -$74,331 $0 -$74,331 -1.63% - 0.0000 BP Energy $411,941 $0 $411,941 9.06% 8,783,400 0.0469 * Hydro Projects $320,877 $0 $320,877 7.06% 3,907,078 0.0821 Braintree Watson Unit $61,275 $116,573 $177,847 3.91% 199,177 0.8929 Saddleback/Jericho $364,075 $0 $364,075 8.01% 2,317,661 0.1571 One Burlington Solar $9,027 $0 $9,027 0.20% 128,962 0.0700 Coop Resales $1,808 $0 $1,808 0.04% 11,454 0.1578 Exelon Energy $1,095,040 $0 $1,095,040 24.08% 14,310,000 0.0765 Stonybrook Peaking $11,762 $51,675 $63,437 1.39% 63,623 0.9971 Monthly Total $3,056,024 $1,491,572 $4,547,597 100.00% 54,713,763 0.0831 * Renewable Resources 15.61% RENEWABLE ENERGY CERTIFICATES (RECs) Current Month Table 5 shows the amount of banked and projected RECs for the Swift River Hydro (W Projects through February 2016, as well as their estimated market value. Table 5 104,312 RECs Summary 108,841 Period - January 2015 - January 2016 Banked Projected Total Est. RECs RECs RECs Dollars Woronoco 2,350 1,319 3,669 $157,767 Pepperell 3,977 1,828 5,805 $249,615 Indian River 2,321 747 3,068 $131,924 Turners Falls 1188 788 1,976 $0 Saddleback 2539 7,593 10,132 $435,676 Jericho 961 783 1744 $74,992 Sub total 13,336 13,058 4 $1,049,974 RECs Sold 0 $0 Grand Total 13,336 13,058 26,394 $1,049,974 Note: Sale of 11,814 RECs pending totaling $531,668. TRANSMISSION The RMLD's total transmission costs for the month of February, 2016 were $996,019. This is an increase of 14.07% from the January transmission cost of $873,184. In February, 2015 the transmission costs were $947,036. Table 6 Current Month Last Month Last Year Peak Demand (kW) 104,312 105,260 108,841 Energy (kWh) 54,713,763 59,693,490 57,903,974 Energy ($) $3,056,024 $3,163,762 $3,579,980 Capacity ($) $1,491,572 $1,642,335 $1,491,533 Transmission($) $996,019 $873,184 $947,036 Total $5,543,616 $5,679,280 $6,018,549 R co ]/ § � V/ § / \ % a q cn- Cl)G CN I a a \__ __ __ m p p q k g \ �k �k SKr m LO �__ 64 61). 6-k 69, 8 $ G q \@ w a 6& 6 0 2 0 64V __ / k kk C14 � n/k 2p60a / 22� w -® ®- ( m c 7 % % % ® ® ® k Cl) 0) (D - » \ a~ � m v .f Q $ b� k @ ® r 5 ® e w LO k k $ & & & LO 1- kk LQ a R § Q 7 ] 602 &C6 k\®- -- -® ^kk kk k� } C14 g 2 $ / G 7 � k / � b w 2 k ® co 1- m 2 G f C'4 LO + Cl) \ CO f / 0 r- to m r- m / } } } LL LL a a e � 2 - 2 k 2 r-©2 - o £ o - § ( 2 7 k MO '6 0,65 d v o o m l0 N N M M N 6 to f9 M tlf M M C M M M M N li a m 2 W (p fV F N M O m (0 Q H� M M t9 W 3� rn Q N o d a x C7 E a � N x m N � r as 8 O 0 c6 0 0 cI 0 m u 0 6 N *o� F- m � a {pp{pp �(pp 88 8 8 app N a Q OD (O N w N N G 1,: /9 f9 f9 /A t9 fA tl! M W /A .�. 'I'M O r M(p QM "1 o 0 V N M M d� NO - In N (O Q h n N Eo df en rn en en to .1ki df en of L r r N Q N O O N m Q M 0 � a N p N N N N cq (ND O O N N U H O a� ooV) w � g� ID, 3 0 8885888888 Q (D o Q N (7 N N N U N m V Qlo N N N N U C n 8 O N O�i (n0 (�O U) m � E o � d N n 5 ((O_ 7 T O W (V OI m N � LVi l;0 o M f9 d! 1A tl! fA (A f9 19 Ni NF o N M d N M N M N N N s s 5 5 8 8 5 5 5 5 M fV N aD O r (O (O N N N O W m o f9 1A tl! f9 IA fA 19 19 f9 tlf of a Nm (`') M M M C O th S M O1 N O N N S Y01 m ® U) O? t_ U m o p� C to M M f9 to V! M M to IA OrcqN IMM ►i .Y. LO 10 — O O, NO_ O, N OK `O 00 NO ";r LO M 0 10 M Ol LO N M O U 10 Lo `7 O, M I�t 10 M O 00 L6 rl� vi c`') M O� 16 Ni 00 O� Il� n O, N MM N m M I" ef} P� 10 b4 »- a) 3 t09 -t09 J O -6F} a) L c 64 O t09- ts4 b4 C M a) �i Lp v Q (D V) v <V) ;; tf} w N Ol N 'IT O� M LO O, M LO 10 1O _ LO N 10 "q 10 LO a0 M N O CO - LO v r� LO O O -..i cM CV lO 'ch L6 n n tf} tf} N to+ tf} b4 b4 t+4 LO N tf} `O to:)- tf} tf} tf} 0) 0) 0) 0) o o o 0 0 b- N 00 000 � N Y) O O O O c D O c D c C3 a) N O a) �3 a) (D O l0 N C a) O U N c ._ mEa) V - U N Q) !E c O a 0 D Q c 0 0 0 U a) c 0 O c oj U a- 0 O a) a) o E c O LU U c O -C O � U_ J E �`' E o O LU U E a LL _ 0 "n E O U N E U 3 c 0_ a� D W N 3 U N m a) V) O J a)0) _0 a) c O) 0)_0 »- a) 3 O) J O � a) L c to O c 3 0 C a) Lp v Q (D V) v <V) U UO c D O c D c C3 a) N O a) �3 a) (D O l0 N C a) O U N c ._ mEa) V - U N Q) !E c O a 0 D Q c 0 0 0 U a) c 0 O c oj U a- 0 O a) a) o E c O LU U c O -C O � U_ J E �`' E o O LU U O LO 10 � LO Iq LIO N n � " 0, C' 00 "O CV O NO "O 00 CN M O` W) � M of CN CN "q N CV O N � CV CV CV 00 LO P., M o O O N MM CV I*, CN c M o0 N � ol • O CN � Ni 00 M • _d d_(D � C � M � d G P W C O O o- C V N — C O (D N C O C G �n c v � o U o a o.O U cY c `NN O m OO � C Q dhe .N O ti O W C D C O C a E 3 C9 C h o o� (� C H o o r~ °1 d Q N` r ori E c N d am ham. a�� N 3 Ld 3 CV _N _N C1 Q O `* U 0 N '^ m �O ci >j 0 O N V v L 0^` N 3 ' W E O A� N V O N C:LO v •o C4 � c �, C LO N N t Q Q �i o • ap = - tVf ol LoQi L N C a) .� �- N _ a ' > � �0Lo� a E _ O �� W^ O N a O O V LOM ice. � V/ N C L 00 f 1 a% � y .� Q , Qi `� O �. L M = = N ^ d Q Q i O 'a Q E^ O O E C "5 �� N3 O L i a N o LO CL � 15Q- ° � H c O 51, PON* N Q O E O Ln •Q OCD N .O O O � •� N O O � � O a) LO LO O Z J � N � - - - ■ S , m � - - ■ ' ; ■ « 2 i � f � ! , § ! \ k -C -W ■ � \ a�! o { z • - o ! ° . \a$ k §)} |c-\ | < §2\ §kz �v � | |�! §.�` z S �`| ■� §;® ,l2�& s ,3 , C4 LA Ln Ln rl m N _ % .�( R K§kz !k� �kk ���` k�! B■3�e 2zw j� /) CL w ECL. : . _ c he . .. w = E � cc � b .. § 2 2 z f z § ƒ ui �+& m E cc § LU= 4 2 7 2 \ z L E® E. 2 2 0® § 2 c 2 z� _\ , � / s s - � m m = : _ ■ ° ; g k 15f 2/! k -C -W ■ � \ a�! o { k o c \ k �v � ] k c z / § IL C ).,§ _ �'om .�( R K§kz !k� �kk ���` k�! B■3�e 2zw ;z k 15f 2/! CL ( �) k > k ■ _ o { } o c & § § & § ] k c z / § CL ( �) k > V Q v v o m a Q o 0 ry m e o Ec O O N N N N � Z Q '0 n E � N rl N rl N � N N N N N N i J -- ° 01 o a o � d r i N ` o O pey p y ] S VI l- r N M ti t N ti ry N U N %0 4 Q a} m N8 8 a C N 8 N14 C O6 O G 0 m � e Q Q Q A N rl N rl N � N N N N N N y�y K a o � d r a N ` o O %0 4 Q a} m N8 8 a C N 8 N14 C O6 O G 0 7 c 0 T ry v w � Y Y w a •0 w U ■ ■ • • ■ • a 3 — O 3 0 �D � N 0 s v T ry F3 w � Y Y w •0 ■ ■ ■ • • ■ w 3 — O 3 m 2/24/2016 9:45 AM READING MUNICIPAL LIGHT DEPARTMENT FY 15 CAPITAL BUDGET VARIANCE REPORT FOR PERIOD ENDING JANUARY 31, 2016 PROJ DESCRIPTION CONSTRUCTION: 101 5W9 Reconductoring - Ballardvale Area 102 Pole Line Upgrade - Lowell Street, W 104 Upgrade Old Lynnfield Center URDs (Cook's Farm) 105 4W5 -4W6 Tie 106 URD Upgrades 107 Step-down Area Upgrades 110 Pole Line Upgrade - Woburn Street, W 212 Force Account West Street SUB -TOTAL STATION UPGRADES: 96 Station 4 (GAW) Back-up Generator 108 Station 4 (GAW) Relay Replacement Project 109 Station 4 (GAW) Transformer Replacement 111 Station Equipment Upgrade (all) 112 Station 4 (GAW) Switchgear/Breaker Replacement 113 Station 4 (GAW) Battery Bank Upgrade 130 Station 3 - Remote Terminal Unit (RTU) Replacement SUB -TOTAL NEW CUSTOMER SERVICES: New Service Installations (Commercial / Industrial) New Service Installations (Residential) SUB -TOTAL ROUTINE CONSTRUCTION: 114 Routine Construction SPECIAL PROJECTS / CAPITAL PURCHASES: 100 Distributed Generation 103 Distribution Protection and Automation 114 Fiber Optic Test Equipment 115 Fault Indicators 116 Transformers and Capacitors 117 Meter Purchases (including "500 Club") 122 Engineering Analysis Software and Data Conversion 125 GIS 126 Communication Equipment (Fiber Optic) 131 LED Street Light Implementation 134 Substation Test Equipment SUB -TOTAL ACTUAL COST YTD ANNUAL REMAINING TOWN JAN ADDITIONS BUDGET BALANCE W W LC R ALL ALL W R R R R ALL R R NR ALL ALL ALL ALL ALL ALL ALL ALL ALL ALL ALL ALL ALL ALL inn nnn inn nnn 1,838 95,386 113,000 1 17,61411 4,354 127,166 42,000 (85,166)1 23,262 35,611 - (35,611)1 97 4,669 340,000 335,331 2,069 13,539 352,000 338,461 ALL 91,000 91,0001 1,454 139,932 150,000 10,068 32,978 416,303 1,188,000 771,6971 30,235 30,235 107,000 76,765111 119 Security Upgrades All Sites 73,000 73,0001 50,000 41,000 41,000 ALL 8,589 254,000 254,0001 1,812 33,459 508,000 474,5411'., 425,441 600,000 57,000 57,0001, ALL 2,440 94,000 94,0001 32,047 63,694 1,134,000 1,070,3061 40,341 152,000 34,000 34,0001 6,520 76,310 164,000 87,690 6,520 76,310 198,000 121,690 150,000 136 Voltage Data Recorders 155,923 879,839 1,000,000 120,16111 4,469 4,469 2,164,000 2,159,531111 55,748 78,632 70,000 (8,632p 15,000 15,00011 50,000 50,000111 193,824 668,000 474,1761 27,565 69,391 219,000 149,609 73,250 73,000 (259) 420,000 420,0001 7,059 7,059 98,000 90,94111 61,011 317,826 1,200,000 882,174 51,540 100,000 48,460 155,853 795,991 5,077,000 47281,00 TOTAL CAPITAL BUDGET u 80, 50, 10. 441,85 50, OC 97,91 174,55 33,27 111,65 132,97 150.0( OTHER CAPITAL PROJECTS: 95 230 Ash St Building R 80,000 97 HVAC Roof Units - Garage R 50,000 98 IRD hardware ALL 10,000 99 Electric Vehicle Supply Equipment ALL 50,000 118 Rolling Stock Replacement ALL 6,150 448,000 119 Security Upgrades All Sites ALL 50,000 120 Great Plains / Cogsdale Upgrade ALL 8,589 29,090 127,000 121 HVAC System Upgrade - 230 Ash Street R 4,690 425,441 600,000 123 Oil Containment Facility Construction ALL 2,440 25,726 59,000 127 Hardware Upgrades ALL 5,567 40,341 152,000 128 Software and Licensing ALL 39,026 172,000 129 Master Facilities Site Plan R 150,000 136 Voltage Data Recorders ALL 50,000 SUB -TOTAL 21,286 565,774 1,998,000 TOTAL CAPITAL BUDGET u 80, 50, 10. 441,85 50, OC 97,91 174,55 33,27 111,65 132,97 150.0( m O Ol 10 M O, co M O M O r, O_ M 0� H O M = M N 10 00 Ol I" O N O, _M NP M O Iq 00 00 O� u O P-� m O O v O N LO 'V O, q LO 00 Ol V W e,4 M t4 L b4 CV4 b4 b4 LO 64 64 b4 tR Y b4 t" )) � I >3 5 N N U M I%t m O 00 00 N O O N O N N I� 00 Ol U-) N O 10 �f 10 Ol O, LO I� O M LO Ol O M 10 O. 00 '�t CM N to+ ch 0` 00 Lo K 64 044 t09 -b4 t09- 64 — 64M c - 3 0 c 64 a ( e.4 b4 V) Ln 0) 0) CD0) 000 000 000 �o N N .- O O O O C O a E Q v O L 0 a O aa) o o c Q O 0 Q Y N p '5 a ° w N coO o Q H N to E O U- 0 O H = O N E U u 3 0 3 a ° m � (D Q Y N � I >3 5 N N U 0 _0 v m J Q Q to 10 c - 3 0 c a ( V) Ln C O a E Q v O L 0 a O aa) o o c Q O 0 Q Y N p '5 a ° w N coO o Q H N to �n W, u O LO N 00 N Iq 00 M M r- C7 C'7 LO O r" r" Ol 10 N 00 M Ln Ld C1 12 O Lli -q� C1 ui 0 C1 CV � M LO (Y) N M r- N N N — M IJ 44 LO'ITO M ' ' ' O 00 � Ol 10 O O- � CY) ON ^ 114-00 10 • OO O L O � LO � �O N C7 O • _N) n N D a O E U ^}. yam-- rn N E V O i3 %- CL O U Q N NC: L U O � C L O 50E to L C O 3: C C a) c � y ca, C_ V H O F - a)0) -C OQ O o�� O U D O om- C7 a U N o 2: O O �n Q 3 U 0 J a -00E C: a 0-- 3 0 a) a s 0 a� a) v) 3 D c '7n � p U Q �>-" C<: O O C: 7C3 �{ Q ° 3 (°� p v> > O > O D (D v y D .61 ��Q o3 (/ 0 �,., •� (D 0 a��i ° a) a) U } E E U 0 > O O N L 0 O N N 3 Ld 3 M N � 3 O � a � o � U op O M Q O op � O N M v 7C) .. tn N <n .. c 0 LO�i — 0 } \ N N N O LO od • s IM oO,rn H O 000 O op N Lo O O C N O= �� C V O U *F"Q% CO)O O Lr) C-) a �C o O a) � a U - V L00 N � CL c C Q-. i U � •— � •— i `O O Lo C Qi O co 90. i 10 fl rA O �I _N O ^ 70 .o O O Q O O N LO LO O Z c I N Ch' d "' '' �,, o v t Y V I � O I� c E 0 J O u u 2 c a 0 W 1 F A W V C w {- CL > T 5 11 3 r Lo� Y �3 N 10 Z w N � H a a ba a �a or¢ O LL N a z W Z `y °L V W .. in Or a z ZE z uLLi c z <; :. ga Y uI`i a' n Z �; c a C Z J v 5z 0 -.2 M'OH 9!,dF-d 7 u t, Z a� Z T'. 3 z i 1 i 1Nqp z N( N Mj Vi M to to c a a nl l7 £ Y K c D. K o~ 0 O W OC Qz 9 d a -a ~ OC vat N N V is I to - d I- C £ y C o u u z1 a c c U I � N c I� �3 W m J O � C W c z c a 0 W 1 LL Z E t to W V C w {- > T 5 11 3 r Lo� Y �3 N to ILLn w N � H a a o 0z �a or¢ O LL N T - d I- C £ y C o u u z1 a z C z z c U E� CILCal r CL W a aci t to m W 9w �X Ii to M Y �3 N to ILLn w N � H a a o 0z �a or¢ O LL Y LU CC O c¢� ae '� c °L E cc I O Q' K �� 0¢ O s y o c tv F- LU a oc L'I z rp.{l0 cc ILLI N s C C T'. _ z H J i 1 i 1Nqp z A z °° z °° a c a a nl l7 £ Y K c D. K o~ OLL OC Qz 9 d a -a ~ OC vat O z ,an z Q a10r� ¢ y► z oe > c a 1J N a to Wit TIt it '��ppl 1 op {tp7 f cz V G O r 7 7 C u z � c C z s { d a R z C z z a1 3E Is z{ c 0 d } J9 c U E� CILCal r CLC m W 9w �X Ii to CL O 'W� Y �3 N CA ILLn w N � H a a 0z �a or¢ O LL Y LU CC O c¢� ae '� o�O p w O E cc I O Q' K �� 0¢ O s y o Y y o o F- �+ NI 73 C9E z K, z- 7- zi z rp.{l0 z C N> .. > LL Qi>~ z J C C T'. _ z H J i 1 i (7 jj a1 3E Is z{ c 0 d } J9 c U E� �) m CLC dI ECL L 00 IT .• C N �.... a "u C � i Cr :.....,.. ,_ c � Y LU CC O m{ LL W ->:_ ..:...:.:.g W W 3 Ln _j F a o. 0 ' LL Qi>~ z J Z C '. _ z H J > "" � W ci � � � ,POO FE" M ci 0 FE" � � � � � � 0 .� � � � � � � W V � � � POO .� � M � . & ( � }K a ------ - \ \ ��------ - � ( k � . @ � 2 § - on C 7 V z 0 t O r `o t0 N C ® W � d N u F y ti 3 0 o Q w L> A V 3 � O� a z 0 t O r N EMM 0 MIN=N 3/21/2016 12:25 PM READING MUNICIPAL LIGHT DEPARTMENT FY 15 CAPITAL BUDGET VARIANCE REPORT FOR PERIOD ENDING FEBRUARY 29, 2016 TOTAL CAPITAL BUDGET $ 1,111 ACTUAL COST YTD ANNUAL REMAINING PROJ DESCRIPTION TOWN FEB ADDITIONS BUDGET BALANCE j CONSTRUCTION: 101 5W9 Reconductoring - Ballardvale Area W 100,000 100,009 102 Pole Line Upgrade - Lowell Street, W W 1,724 97,110 113,000 15,89 104 Upgrade Old Lynnfield Center URDs (Cook's Farm) LC 113,073 240,239 42,000 (198,23 105 4W5 -4W6 Tie R 22,384 57,995 (57,990 106 URD Upgrades ALL 4,669 340,000 335,331 107 Step-down Area Upgrades ALL 593 14,132 352,000 337,868 110 Pole Line Upgrade - Woburn Street, W W 91,000 91,00 212 Force Account West Street R 139,932 150,000 10,068 SUB -TOTAL 137,774 554,077 1,188,000 633,923' STATION UPGRADES: 96 Station 4 (GAW) Back-up Generator R 9,808 40,043 107,000 66,957' 108 Station 4 (GAW) Relay Replacement Project R 73,000 73,000'i 109 Station 4 (GAW) Transformer Replacement R 41,000 41,0001 111 Station Equipment Upgrade (all) ALL 1,860 1,860 254,000 252,140', 112 Station 4 (GAW) Switchgear/Breaker Replacement R 549,950 583,409 508,000 (75,409 113 Station 4 (GAW) Battery Bank Upgrade R 57,000 57,000] 130 Station 3 - Remote Terminal Unit (RTU) Replacement NR 94,000 94,0001 SUB -TOTAL 561,618 625,312 1,134,000 508,688 NEW CUSTOMER SERVICES: New Service Installations (Commercial / Industrial) ALL 34,000 34,000. New Service Installations (Residential) ALL 14,028 90,338 164,000 73,662,1 SUB -TOTAL 14,028 90,338 198,000 107,662 ROUTINE CONSTRUCTION: 114 Routine Construction ALL 194,712 1,074,551 1,000,000 -(74,551) SPECIAL PROJECTS / CAPITAL PURCHASES: 100 Distributed Generation ALL 9,662 14,131 2,164,000 2,149,869 103 Distribution Protection and Automation ALL 1,940 80,572 70,000 (10,572) 114 Fiber Optic Test Equipment ALL 15,000 15,000 115 Fault Indicators ALL 50,000 50,000 116 Transformers and Capacitors ALL 193,824 668,000 474,176 117 Meter Purchases (including "500 Club") ALL 18,492 87,883 219,000 131,117 122 Engineering Analysis Software and Data Conversion ALL 73,250 73,000 (250) 125 GIS ALL 5,190 5,190 420,000 414,810 126 Communication Equipment (Fiber Optic) ALL 7,059 98,000 90,941 131 LED Street Light Implementation ALL 37,152 354,978 1,200,000 845,0221 134 Substation Test Equipment ALL 51,540 100,000 48,460 SUB -TOTAL 72,435 868,427 5,077,000 4,208,573 OTHER CAPITAL PROJECTS: 95 230 Ash St Building R 80,000 8000011 97 HVAC Roof Units - Garage R 50,000 50,000' 98 IRD hardware ALL 10,000 10,000 99 Electric Vehicle Supply Equipment ALL 50,000 50,000' 118 Rolling Stock Replacement ALL 6,150 448,000 441,850 119 Security Upgrades All Sites ALL 10,514 10,515 50,000 39,486 120 Great Plains / Cogsdale Upgrade ALL 29,090 127,000 97,910 121 HVAC System Upgrade - 230 Ash Street R 77,474 502,915 600,000 97,085 123 Oil Containment Facility Construction ALL 20,211 45,937 59,000 13,063'' I 127 Hardware Upgrades ALL 14,289 54,630 152,000 97,370 128 Software and Licensing ALL 8,392 47,418 172,000 124,583 1 129 Master Facilities Site Plan R 150,000 150,000 136 Voltage Data Recorders ALL 50,000 50.00 SUB -TOTAL 130s8n SQA ARA i QQn nnn 4 Ano zea i TOTAL CAPITAL BUDGET $ 1,111 R M L D 00, (W February 24, 2016 Reading Municipal Light Department RELIABLE POWER FOR GENERATIONS 230 Ash Street P.O. Boz 150 Reading, MA 01867-0250 Tel: (781) 944-1340 Fax: (781) 942-2409 Web: www.rmld.com Town of Reading Municipal Light Board Subject: Electric Forklift with Battery Charger and Trade -In On January 27, 2016 a bid invitation was placed as a legal notice in the Reading Chronicle, Middlesex requesting proposals for one Electric Forklift with Battery Charger and Trade -In for the Reading Muni Light Department. An invitation to bid was sent to the following six companies: Crown Lift Trucks Northland Industrial Truck Company, Inc. Chery Forklift NY Inc. Starlift Equipment Co. Lift Truck Parts & Service W. D. Matthews Machinery Co. Bids were received from three companies: Crown Lift Trucks, Lift Truck Parts & Service and . Industrial Truck Company, Inc. The bids were publicly opened and read aloud at 11:00 a.m. on February 11, 2016 in the Town of Readin Municipal Light Department's General Manager's Conference Room, 230 Ash Street, Reading, Massachusetts:, The bids were reviewed, analyzed and evaluated by staff and recommended by the General Manager. Mov that bid 2016-16 for one: Electric Forklift with Battery Charger and Trade -In be awarded to: Lift Truck Part & Service for $30,477.02 as the lowest qualified and responsive bidder on the recommendation of the General Manager. The FY2016 Capital Budget amount for this item is $35,000.00. ColO'Brien 1 Hamid Jaffar - Paul McGonagle Ir Attochment 4 cq C 0 N y O N U y ca N y U) y Q?•— d y C d >-LO �, p a CwDp k W y N x W y E2 L E rn 3 m N M L o o 2 c~ c 3 O o VCU e �° O o ° O : a 75 O C CL 'O m cc C p y y y Ci LL C t O O cc Q' O pal Od >-a N > M c y 0 ,�� vA N� `oV > ( C` ayim 3 CD EL V 0) m co > U o 00 O�d � U y C C O O LL O CD O m !0 O N \� o y Y y y O) � LN � C O N O� OC O. ° °vf0 > o °°>mQ > 3 3 3 ° T O C C 0` i. y N p m+ O� O N d O N co O f6 Y 3 M wU., ��, O) C Z y C Q) O .° m C U 0) 2 co d c0 Cc N J @ y Op C U CD 'y V >, !C U c`9 �'.• r N �? d C N0 t O m O Y 3. y CO c`o 0 O O o w c`a L U N v C4 CO LL L C VI O t O O 4! O E9 'Om y- C O O L U O O O C •0 O 'O m C LL L 0 a) p L co N N a p— 12 o °0 ca p) O o O coL t6 a U- `m C wi > N 0 > 0 O LL L O N N N O O CO O H°^ y N d Co > w w O 1p (D O O C5 N a)y c 7 d a p 011: O) C a► M a LO 'v 3 m O) o (D CO —J �M`o VI O O-" O 4) m � � 669 N N d O y L 4 w U d C O a > LD cc o3 m m- N0 CO- 2 w Ci C C L W Oa tic O N c2 N co O O 0 O 0 a) N X ° co 0 O r[2 3 m N O C 30 'y G O O ,; 0 O V O C i U c C`> L N 75 a cel 0 0 coo z 3 �' U O y 'm c n y� cc O M 1A cNi E9 C co t c0 m C E V 3 y p N 'p O 3 p C L N> w L L T 04 0 O ap C N -` G� N � Z X E O d N y N F— CO p CO 3 co �( ++ V W C X w L d G> a �oOL N ca N o O C) N-' U 50 o X 3 v o E cc cCC — X y~ N 7 V I N N C C CD M N C ~ Z y r O O N '� O O O C d N N N J 6M9 Cl) CNc (00 Coap co a = Vi C w = c rcm �� yr O m :.1 J O c`9 U O` LL wcmca L c6 d U d j >� >, E> > r > O c6 cc E 55O m uj N M N m V co D N O V w V) m :3N '0 N � t N > > d x C C > cV cV X 0 0 C-6 >. N Op U) 1, �+ U) C C*) U w y t 7 t v m 2 p .r^. v d co !CO 1co mco c G rn Lo c r C m o O t O m CD C C CL 0 C%4 r V O r C Vl U O O L 'C ` ui K Y d x L d m a o Z x a) rn° •� Mw W °a U w m W m m U J wC4z-- N .7�m �, o00 RMLD 00 (W March 11, 2016 Reading Municipal Light Department RELIABLE POWER FOR GENERATIONS 230 Ash Street P.O. Box 150 Reading, MA 01867-0250 Tel: (781) 944-1340 Fax: (781) 942-2409 Web: www.rmld.com Town of Reading Municipal Light Board Subject: Substation Control Devices On February 24. 2015 a bid invitation was placed as a legal notice in the Middlesex East section of the Daily Times Chronicle requesting proposals for Substation Control Devices the Reading Municipal Light Department. An invitation to bid was emailed to the following: WESCO Graybar Electric Company Stuart C. Irby Siemens Industry, Inc Gridstor Energy Corp. Bids were received from WESCO and Stuart C Irby. The bids were publicly opened and read aloud at 11:00 a.m. March 10, 2016 in the Town of Reading Municipal Light Department's Board Room, 230 Ash Street, Readin, Massachusetts. The bids were reviewed, analyzed and evaluated by staff and recommended to the General Manager. Move that bid 2016-25 for Substation Control Devices be awarded to: WESCO for a total cost of $44,544.00 Item (desc.) Qty Unit Cost Total Net Cost Item 1 Electroswitch Cat# 8846FB 15 $1,368.00 $20,520.00 Item 2 ABB Style# C774B430G24XO8 14 $192.00 $2,688.00 Item 3 Leadtronics LED lamp Cat# UTL 1835-1CW for white light indication 59 $50.00 $2,950.00 Item 5 ABB Style# C129A514G01XO8 14 $192.00 $2,688.00 Item 6 Electroswitch Cat# 92O3DD 14 $735.00 $10,290.00 Item 7 Electroswitch Cat# 2424E 1 $144.00 $144.00 Item 8 ABB Style# C129A539G01XO8 28 $188.00 $5,264.00 as the lowest qualified bidder on the recommendation of the General Manager. File: Bid/FY16/2016-25 Substation Control Devices RMLD Reading Municipal Light Department RELIABLE POWER FOR GENERATIONS 230 Ash Street, P.O. Box 150 Reading, MA 01867-0250 Stuart C Irby for a total cost of $114.10 Item (desc.) Qy Unit Cost Total Net Cost Item 4 Allied Cat# 273-0514 or equivalent 14 $8.15 $114.10 The total for all of these items is $44,658.10. The FY16 Capital Budget allocation for the purchase of these units under the Relay Replac$ment project was estimated at $50,000. C2&1k-. Coleen O'Brien 0 Nick D'Alleva File: Bid/FY16/2016-25 Substation Control Devices a to,e T 0 y C O O U � W vl O C O Y � � m T U U 00 h O a T Q �= C T O C m O O O O O O C', O O o o O o O aao 0 N COD 0 000 Of i0 to tG 01 40 N N N N N N O to Q to 00 0 0 0 0 0 0 Z H N OW h D O O 0 O01 < to ._�. U9 tD Ol t0 N r N FO N N N N O N r r Owl) r N 00 0 0 0 000 00 O O 0 0 0 0 0 0 co N O O N N OSI to O1 to 0 M 00 M r r P r .0 r 00 0 00 0 as a as a YYYYY Y Y 33 3 come 00 Q3333 O t0 N N C N t0 It N 1f1 M OD J C 0 j O tD m a u j Q oxW U - CV c o0409 co M E O O- cA N M E �. gym`—°vLQCMQ vnW�Ln oNUUN V U)'n U Y V V O N 0` 01 o o y O mmm3�'mmmm � W Q J O Q Q W W Q .� W r N M w M tD n 00 3: E aEi E U DEi E EE E EE 00 0 0 0 0 0 0 O O O r O f� O 0 LO CD LOCD10 Co LO to r to N r O N M M CO 0 - - - r co O O O N O LO 0 0 OO Or O�tOO 01 U) c0 0 U, CO N N .0 v N ¢O Q OQOO Y Q Y. Q Y Q Q NN y a N N to 3 ai m d� d ami CO N N r N 00 V N to CO c_o c Of J /0 aD > oD m m 4 Q X c X LL C, U o Wv o OO C7 C7 a0 M a pa ANN c`O') Oo v E r �ON� Lk m @ U 'CO, V F LUC L U-1 CN ULLU ti U m@ -3 m m U U (Q _d CO y.r-. = m N O7 m W Q J o Q Q W W Q 7 r N M 10 c0 t` co y m aEimUm maEiDEiDEi a Jeanne FoU From: Coleen O'Brien 114int: Thursday, March 03, 2016 9:33 AM o: RMLD Board Members Group Cc: Jeanne Foti Subject: Account Payable Warrant Question Categories: Blue Category Dave: • AT&T— Is the memo reporting that charges have been reduced to $20/month from $1,000+/month a tesult of my inquiry last year? The RMLD had been in therocess of researching p esea chmg its telephone billings prior to your inquiry, although the resultant reduction does speak to your concern. The RMLD is now on the Commonwealth of Massachusetts (COMA) st to contract, resulting in the lower charges. CcIeR vw M. O'3 rLe w General Manager (WReading Municipal Light Department 230 Ash Street Reading, MA 01867 Jeanne Foti From: Jeanne Foti ?nt: Tuesday, March 22, 2016 2:38 PM o: RMLD Board Members Group Subject: Account Payable and Payroll Questions Good afternoon. In an effort to save paper, the following timeframes had no Account Payable and Payroll questions. Account Payable Warrant — No Questions February 5, February 12, February 19, February 26, March 4, March 11 and March 18. Payroll — No Questions January 25, February 8, February 22, March 7 and March 21. This e-mail will be printed for the Board Packet for the RMLD Board meeting on March 31, 2016. Deanne Foti NWReading 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 W G C W a Q U t9JLU UZ Q m S C W O a Y LL � o: 0 z d ae O! M � N o N co V N N0 Nv r Of o_ O (1 ^ NN C O N � N � 0 N � � O N f9 N N o N M C4 CO N M o ^ O w U, N M o O 400 N 0 "rci K y 2 W Q U U J x Z LU Oro w N JLL YLL 0 W w p �uCL aa a: t0 G c H N M C; a w 4 � M N Non N h40O e O O Nc" N N c N N a M 6 H g ILx J J d W U Q i JV 2 m Q LuLL 0 B ILaat F W O x Q a Q U Z JU Z FO m W LL O ILLU at co T na OOoc io m N O V N O 40 � 40 N 6, N O N M cm 0) V N 40 00 r o Nt7 04 M �'i►ONN � gcg w FO E « O C $ ^ D Z �i z ry N W C Q a 1' �a c O �c N � g � N a C Y► (/ N� 4gi J 9 gC W a yE N t! 00 Go _j C N 1 COG N 40 9 e- gC a' O l0 W �[ 0 Ci lLCw Un$ N K W Q M 3� ^o 0 x $ 110 U) W 0: 0 O � m « N Z H W N co r NO 0 y W C N Z 3 W O -+ F a N Z O O N 1 Z W 0 W^ C N D 0: F K S � C7 N ~ J 44{ CL z o IL U Q x Cq D LO K LL O S U Z Z m x J W ga D Q a W G C W a Q U t9JLU UZ Q m S C W O a Y LL � o: 0 z d ae O! M � N o N co V N N0 Nv r Of o_ O (1 ^ NN C O N � N � 0 N � � O N f9 N N o N M C4 CO N M o ^ O w U, N M o O 400 N 0 "rci K y 2 W Q U U J x Z LU Oro w N JLL YLL 0 W w p �uCL aa a: t0 G c H N M C; a w 4 � M N Non N h40O e O O Nc" N N c N N a M 6 H g ILx J J d W U Q i JV 2 m Q LuLL 0 B ILaat F W O x Q a Q U Z JU Z FO m W LL O ILLU at co T na OOoc io m N O V N O 40 � 40 N 6, N O N M cm 0) V N 40 00 r o Nt7 04 M �'i►ONN N O O Dino C 4 AO O O Ui r w � pD aa,o Oa W M N N C O N N e - v � o O N n p V► r N CD O c o N N O L6 N w O QOD o O pp O N M p 6 - N o M M N p ci m 10 O o O O 100 N w61 zO H a_ W U K m C 0 L N M Lu q3a j U- z U w LL O z O Hxx N Q m x w O J LL W O Q H K O 7 oO ^ N K0a zPaW ae O � p Z N N N 9 W C Q p R Lz m M W co 8gY C1 N V H n N r�i Q 9 C LUJ L O Oco 01 Q O O � N C r QN W y W 1� V W pY 3 N � C G M ^ g w p cwK U N W 3 Y O x a, Cl) M . N O N N W C O Q L MN r N 06 r z N N ui O N A Oa O M p y � W LL' N Z J O zI..LU Q a F r a O F Z W O O M r N CL C z w O w n K N O K � rc x � (3 N J aI1iL F az a S o F - z IX O � V1 z J J Q N O O Dino C 4 AO O O Ui r w � pD aa,o Oa W M N N C O N N e - v � o O N n p V► r N CD O c o N N O L6 N w O QOD o O pp O N M p 6 - N o M M N p ci m 10 O o O O 100 N w61 zO H a_ W U K W O_ K O Lu a' 2 j U- z U w LL O z O C7 m x Z J Q m x w O J LL W O Q H K Q LL F F K O QF o9 K0a zPaW ae w CD M O M o r � 04 C) M t" M o O o p N N C; ui p p O N N < o M N 17 M O M N N N N N o N_ O N N O 04 M 6y Cl) N O o .0 m N O V V9. n M o a O t00 N n u►�c LL' a N W Z K W U U JUJ = z O m w K Q Y LL Wr-rcS O wa X at 0) C O 8 N N M ale o c w 4Z; VM OC, pp N Op 7 r N C •- N ' N O o O n a N G U N N u N N d wo°L w� M ' Ma .n- M � � r 1 A O p H N Cp O o N pp � N 6 r oco_ O w - O O a N N 0 Ml c0 of O`' N p, 'p mV). N N C N On ' M C c r N H O O � O n � r � 4^ O N N W � n o O r N n O H N 9L p. LU 0 x x c� J CL U W Q U Z J U Z OF uj m W Y a ae