Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2013-10-30 RMLD Board of Commissioners Minutes
Reading Municipal Light Board of Commissioners Staff: Coleen O'Brien, General Manager Beth Ellen Antonio, Human Resources Manager Jeanne Fort, Executive Assistant Bob Fournier, Accounting/Business Manager Priscilla Gottwald, Community Relations Manager Jane Parenteau, Energy Services Manager William Seldon, Senior Energy Analyst Kevin Sullivan, Engineering and Operations Manager Citizens' Advisory Board: Dave Nelson, Member and Tom 011ila, Secretary Call Meeting to Order Chairman Stempeck called the meeting to order and stated that the meeting was being videotaped, it is live in Reading only. Opening Remarks Chairman Stempeck read the RMLD Board of Commissioners Code of Conduct. Introductions � haimt m Stempeck welcomed CAB Members Mr. Dave Nelson and Mr. Tom 011ila, CAB Secretary. There was nothing to port at this time. Public Comment There was no public comment. Regular Session Minutes August 14, 2013 Mr. Pacino made a motion seconded by Mr. Talbot to approve the Regular Session meeting minutes of August 14, 2013, as corrected. Motion carried 5:0:0. Report of the Chairman Ad Hoc Power & Rate Committee Meeting Report Chairman Stempeck reported that them was an Ad Hoc Power & Rate Committee session before this evening's RMLD Board meeting that was an exchange of Mr. Solis New York Power Authority (NYPA) analysis and thanked him fm his work for the various scenarios. Chairman Stempeck commended everyone for their efforts. Ms. O'Brien explained that a Cost of Service, Cost Allocation and Rate Design Scope of Work is being developed. Given the forecasted increase in transmission and capacity costs and the six year plan presented to Standard and Poor's at the recent credit review, a rate review to ensure proper revenue collection is needed. As part of [he scope, the NYPA calculations would be included for the third party consultant to provide further recommendations. As part of the Cost of Service Study, there will be a cost allocation and rate designs going forward to look at NYPA at that time as Mr. Solt has requested. Ms. O'Brien stated that we will make sure that the Cost of Service Study will be done in a transparent means with sufficient data provided back to the Commissioners. The presentation will be in an understandable format. RMLD Board Attendance at RMLD Citizens' Advisory Board Meetings hairman Stempeck commented that Ms. Foti will come up with a vocational schedule for the RMLD Board members to over attendance at RMLD Citizens' Advisory Board meetings. Mr. Soli will be the Secretary for this evening's meeting. Regular Session 230 Ash Street Reading, MA 01867 ` October 30, 2013 Start Time of Regular Session: 7:30 p.m. End Time of Regular Session: 8:02 p.m. Commissioners: John Stempeck, Chairman Philip B. Pacing Vice Chaim Robert Soli, Secretary David Talbot, Commissioner David Mancuso, Commissioner Staff: Coleen O'Brien, General Manager Beth Ellen Antonio, Human Resources Manager Jeanne Fort, Executive Assistant Bob Fournier, Accounting/Business Manager Priscilla Gottwald, Community Relations Manager Jane Parenteau, Energy Services Manager William Seldon, Senior Energy Analyst Kevin Sullivan, Engineering and Operations Manager Citizens' Advisory Board: Dave Nelson, Member and Tom 011ila, Secretary Call Meeting to Order Chairman Stempeck called the meeting to order and stated that the meeting was being videotaped, it is live in Reading only. Opening Remarks Chairman Stempeck read the RMLD Board of Commissioners Code of Conduct. Introductions � haimt m Stempeck welcomed CAB Members Mr. Dave Nelson and Mr. Tom 011ila, CAB Secretary. There was nothing to port at this time. Public Comment There was no public comment. Regular Session Minutes August 14, 2013 Mr. Pacino made a motion seconded by Mr. Talbot to approve the Regular Session meeting minutes of August 14, 2013, as corrected. Motion carried 5:0:0. Report of the Chairman Ad Hoc Power & Rate Committee Meeting Report Chairman Stempeck reported that them was an Ad Hoc Power & Rate Committee session before this evening's RMLD Board meeting that was an exchange of Mr. Solis New York Power Authority (NYPA) analysis and thanked him fm his work for the various scenarios. Chairman Stempeck commended everyone for their efforts. Ms. O'Brien explained that a Cost of Service, Cost Allocation and Rate Design Scope of Work is being developed. Given the forecasted increase in transmission and capacity costs and the six year plan presented to Standard and Poor's at the recent credit review, a rate review to ensure proper revenue collection is needed. As part of [he scope, the NYPA calculations would be included for the third party consultant to provide further recommendations. As part of the Cost of Service Study, there will be a cost allocation and rate designs going forward to look at NYPA at that time as Mr. Solt has requested. Ms. O'Brien stated that we will make sure that the Cost of Service Study will be done in a transparent means with sufficient data provided back to the Commissioners. The presentation will be in an understandable format. RMLD Board Attendance at RMLD Citizens' Advisory Board Meetings hairman Stempeck commented that Ms. Foti will come up with a vocational schedule for the RMLD Board members to over attendance at RMLD Citizens' Advisory Board meetings. Mr. Soli will be the Secretary for this evening's meeting. Regular Session Meeting Minutes 2 October 30, 2013 Report of the Committee Policy Committee Meeting Report — Vice Chair Pacino • Mr. Pacino reported that the Policy Committee met last week A couple of policies were reviewed including The Alcohol and Controlled Substance Testing Program Policy for Non -CDL Employees with recommended changes to be adopted at a future meeting. There were additional questions on the Travel Policy that they will be re- addressing. There was discussion on separating operational policies versus Board policies. General Manager's Report —Ms. O'Brien — General Manager Ms. O'Brien stated that Ms. Gottwald will be presenting the upcoming activities on the calendar. Ms. Gottwald reported on the following: RMLD Open House for Public Power Week— October 10 The RMLD held its Open House for Public Power Week which was well attended. RMLD Board of Commissioners that attended were Chairman Stempeck, Commissioners Soli and Mancuso. CAB members Dave Nelson, Member and Tom Gilds, Secretary were also at this event. Ms. Gottwald expressed her appreciation for their attendance. RMLD's Annual Report Subsequent Town Meeting — November 12 RMLD's Annual Report will be ready and given out at the Reading Subsequent Town Meeting on November 12. RMLD's Historic Calendars Will Be Ready — December 2 RMLD's Historic Calendars will be ready for the public on December 2. Trains will be set up the week of November 20 Retired RMLD Chief Engineer, Paul Carson, will be setting up his trains in the RMLD lobby early this year for the holiday season. T- Shirts need to be Judged week of November 25 • The T- Shirts will be returned from die schools and will be judged the week of November 25. If anyone is interested in assisting with the judging Ms. Gottwald would appreciate the assistance. The T -Shirt award ceremony will be January 9, 2014. Tree Lighting — December 1 The RMLD participates in the tree lighting ceremony which will mke place at 4:30 pm on December 1. This event is sponsored by the Reading -North Reading Chamber of Commerce. RMLD Gift Certificates The RMLD offers gift certificates that can be purchased in any denomination to be used towards a customer's bill. Parker Middle School — Festival of Lights — December 7 This festival will be held at the Parker Middle School. The RMLD decorates and donates a tree. Ms. O'Brien thanked Ms. Gottwald for the festive holiday decorating in the RMLD lobby. Ms. Gottwald said that as part of the RMLD Open House for Public Power Week, BUILD customer, Jack Devir was the recipient of the LED retrofit for his home. Ms. O'Brien said that a before and after analysis would be performed to provide valuable dam on LED conversions and associated homeowner cost savings. The analysis could be expected on the website by January. General Manager's Report —Ms. O'Brien — General Manager American Public Power Association (APPA) Legislative Rally Monday, March 12, 2014 to Wednesday, March 14, 2014 — Board approval is necessary for attendance. Ms. O'Brien explained that the APPA Legislative Rally provides the municipals an opportunity to lobby for publicly owned and operated municipals. Mr. Pacino made a motion seconded by Mr. Soh to authorize the General Manager to participate in the APPA Legislative Rally on March 12, 2014 to March 14, 2014. Motion carried 5:0:0. Regular Session Meeting Minutes October 30, 2013 General Manager's Report — Ms. O'Brien — General Manager � ED Streetlights Ws. O'Brien stated that she is in favor of an LED pilot program. She is proposing that the RMLD go forward with a pilot program similar to one that she has done previously. Ms. O'Brien reported that the RMLD will be looking at maintenance costs, ability of the Lineworkers to install and operate them, LED failure (including lighting assemblies and driver mechanisms), determining an LED failure, funding of the capital project. Illumination studies and lessons learned from other communities that have convened, are incorporated into the pilot analysis. The RMLD is short staffed in the Energy Efficiency area; therefore this pilot project will be postponed until calendar year 2014. Chairman Stempeck said that he would like to thank Mr. Frederick Van Magness for providing significant background on LEDs. Mr. Talbot asked if there is a rate policy that needs to be considered for a special rate for LED streetlights. Ms. O'Brien replied that streetlights are under a municipal rate, but the RMLD can look to we if others are providing a reduced rate for LEDs. Mr. Talbot asked if the RMLD or the towns pay for the electricity for streetlights. Ms. O'Brien responded that the town DPW budget is typical of who pays for the electricity. RMLD owns, maintains and operates the streetlights. Mr. Pacino added that there are some streedights that are privately financed because he and neighbors adopted a streetlight because the Town had deemed it to be shut off. Mr. Talbot asked if the RMLD is going to retrofit for LED at an intersection, can it been done in the next quarter (the first quarter of the year). Ms. O'Brien said that it is a staffing issue at this very moment. Mr. Talbot added that Metropolitan Area Planning Council (MAPC) is a good resource. Ms. O'Brien said that Mr. Krishnan had mentioned that when he did his MAPC presentation. On another matter, Mr. Pacino added that the Department has historically given a presentation at the November, Subsequent Town Meeting. Ms. O'Brien said that historically, the General Manager and the Chairman attend. Chairman Stempeck said 4 at he would be happy to make the report in conjunction with Ms. O'Brien. Power Supply Report— September 2013 —Ms. Parenteau (Attachment 1) Ms. Parenteau presented the September Power Supply Report provided in the Commissioner packets covering power supply charges, energy costs, fuel charges and collections, fuel reserve balance, spot market purchases, capacity costs, as well as the percentage of RMLD's hydro projects and energy efficiency measures installed. Engineering and Operations Report — September 2013 —Mr. Sullivan (Attachment 2) Financial Update of Meter Upgrade Project and Fixed Network Project. This was requested by Commissioner Sall. Mr. Sullivan repotted that the analysis for the meter upgrade project was requested by Commissioner Soli. The meter upgrade project, the actual to budget is under by approximately 15% and the fixed network is under budget by 3 %. The fixed network project is complete and the meter upgrade project is ongoing at 90% complete. Mr. Sullivan reported the Customer Average Interruption Duration Index (CABJI) for September; monthly average value was 45 minutes of outage which was a tranquil month. The average System Average Interruption Frequency (SAIFI) was low for the month. Months Between Interruptions (MBTI) is up from 27 months to 32 months for September. Mr. Soli asked to have a report on how many more cutouts need to be replaced, and could this be reported on at the next meeting. Mr. Sullivan replied that he will try to do this for the next meeting. Financial Report — September 2013 — Mr. Fournier (Attachment 3) Mr. Fournier presented the September Financial Report included in the Commissioner packet for the first throe months; net income $1.4 million, increasing the year to date net income to $1.9 million. Year to date kilowatt hour sales were 202,000,000 kilowatt hours sold which is 6.3 million lessor 3.1% behind last year's actual figure. Mr. Fournier pointed out that the total revenues from the Gaw project from inception are at $2.1 million with the cost at $2.5 million. By January or February the $2.5 million will be recovered. Li Regular Session Meeting Minutes 4 Ocmber 3Q 2013 Financial Report — September 2013 — Mr. Fournier (Attachment 3) Other Post Employment Benefits (OPEB) • At the RMLD Board meeting on February 27, 2013 the Board voted to create an OPEB Trust instrument in alignment with the Town of Reading. Mr. Fournier reported that he spoke with the Town Manager, Town Accountant, and Town Treasurer as well as our auditors. Mr. Fournier stated that the Town is getting close in its process to create the trust. Mr. Fournier said that he will provide the Board more information on this over the course of the winter. RMLD Restricted Funds Investments This was discussed at the RMLD Audit Committee meeting on September 25, 2013. Mr. Fournier reported that the Audit Subcommittee met on September 25 and discussed the Restricted Fond money and how the Department can enhance its return to the interest income. Mr. Fournier reported that currently, the money is in the Massachusetts Municipal Repository Trust account with a 115 of 1 interest. Mr. Fournier said that he and Ms. O'Brien will be discussing this in a few weeks. Mr. Fournier pointed out that in this week's Account Payable Warrant there will be the first invoice for the Purchasing curd. The Purchasing card works as a corporate credit card. Mr. Fourier said the BUILD received the card last month. The RMLD is using the cud when vendors will not take a Purchase Order which is usually required for software or hardware purchases. The cud is in Mr. Fournier's name and has a $2,000 maximum. If an exception to this amount is required, it is handled via the Town Treasurer. General Discussion There was no discussion BOARD MATERIAL AVAILABLE BUT NOT DISCUSSED Rate Comparisons, October 2013 E -Mail responses to Account Payable/Payroll Questions • RMLD Board Meetings Tuesday, November 12, 2013 — To" of Reading, Subsequent Town Meeting Wednesday, December 11, 2013 — RMLD Board Meeting Thursday, January 9,2014 — T-Shirt Award Ceremony Citizens' Advisory Board Meeting Wednesday, December 4, 2013 Fiscal Year 2015 Budget Meetings April 2, 2014 — Lynnfield —April 9, 2014 Adjournment Al 8:02 p.m. Mr. Soli made a motion seconded by Mr. Pacmo to adjourn the Regular Session. Chairman Stempeck polled the Board. Motion carried by a Foiling of the Board: Mr. Soli, Aye; Mr. Pacino; Aye; Chairman Stempeck, Aye; Mr. Mancuso; Aye, and Mr. Talbot; Aye. Motion carried 5:0:0. A true copy of the RMLD Board of Commissioners minutes as approved by a majority of the Commission. Robert Soli, Secretary RMLD Board of Commissioners • To: Coleen O'Brien From: Maureen McHugh, Jane Parenteau Date: October 23, 2013 Subject Purchase Power Summary - September, 2013 Energy Services Division (ESD) has completed the Purchase Power Summary for the month of September, 2013. ENERGY The RM1A's total metered load for the month was 58,602,233 kWh, which is a .11% increase from the September, 2012 figures. Table 1 is a breakdown by source of the energy purchases. • Attachment 1 Table 1 ® Amount of Cost of % of Total Total $ $ m e Resource Energy Energy Energy Costs % (kWh) ($/Mwh) Millstone k3 3,547,380 $6.99 6.05% $24,788 1.14% Seabrook 5.696,515 $8.22 9.72% $46,1305 2.16% Stonybrook Intermediate 967,192 $67.34 1.65% $65,135 3.00% JP Morgan 5,596,000 $59.24 9.55% $331,492 15.29% Ne #Ere 9,022,000 $46.05 15.39% $415,504 19.16% NVPA 1,750,812 $4.92 2.99% $8,614 0.40% ISO Interchange 8,731,283 $32.33 14.90% $282,259 13.02% NEMA Congestion 0 $0.00 0.00% $38,329 1.77% Coop Resales 13,183 $137.18 0.02% $1,808 0.08% MacOuede 9,520,000 $40.12 16.24% $381,910 17.61% Summit Hydro/Collins /Pioneer 270,248 $70.07 0.46% $18,936 0.87% Braintree Watson Unit 663,329 $61.19 1.13% $40,587 1.87% Swift River Projects 518,933 $101.52 0.89% $52,680 2.43% Ezalon 12,318,000 $37.27 21.02% $459,115 21.17% Stonybrook Peaking 0 $0.00 0.00% $272 0.01% Monthly Total 58,614,875 $36.99 100.00% $2,168,234 100.00% • Attachment 1 Table 2 breaks down the ISO interchange between the DA LMP Settlement and the RT . Net Energy for the month of September, 2013. Table 2 Amount Cost %of Total Resource of Energy of Energy Energy (kWh) ($/Mwh) ISO DA LMP 8,696,798 36.55 14.84% Settlement RT Net Energy" 34,485 - 1033.02 0.06% Settlement ISO Interchange 8,731,283 32.33 14.90% (subtotal) ' Independent System Operator Day-Ahead Locational Marginal Price " Real Time Net Energy SEPTEMBER 2013 ENERGY BY RESOURCE &a 2 • M'Jlstone N3 mk ■Seabrook ate, • Stonybrook Intermediate ■JPMuigan ■ Nebdbra ■ NYPA ■ ISO Interchange ■Marnuarle • Summa Hydro • Braintree Watson tlnit • Swltt River Projects • Pxelon • Stom brook Peaking u CAPACITY The RMLD hit a demand of 156,230 kW, which occurred on September 11, at 5 pm. The RMLD's monthly UCAP requirement for September, 2013 was 214,413 kW s. 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 N3 4,950 49.22 $243,616 16.35% Seabrook 7,903 46.99 $371,327 24.93% Stonybrook Peaking 24,981 1.98 $49,459 3.32% Stonybrook CC 42,925 3.29 $141,362 9.49% NYPA 4,019 4.02 $16,172 1.09% Hydro Quebec 4,683 4.35 $20,386 1.37% Ne #era 60,000 5.50 $330,000 22.15% Braintree Watson Unit 10,520 10.93 $115,027 7.72% ISO -NE Supply Auction 54,432 3.72 $202,388 13.59% Total 214,413 $6.95 $1,489,738 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 e3 $24,788 $243,616 $268,403 7.34% 3,547,380 0.0757 Seabrook $46.805 $371,327 $418,132 11.43% 5,695,515 0.0734 Stonybrook Intermediate $65,135 $141,362 $206,497 5.65% 967,192 0.2135 Hydro Quebec $0 $20,386 $20,386 0.56% - 0.0000 JP Morgan $331,492 $0 $331,492 9.06% 5,596,000 0.0592 NextEra $415,504 $330,000 $745,504 20.38% 9,022,000 0.0826 a NYPA $8.614 $16,172 $24,786 0.68% 1,750,812 0.0142 ISO Interchange $282,259 $202,388 $484,647 13.25% 8,731,283 0.0555 Name Congestion $38,329 $0 $38,329 1.05% - 0.0000 MacQuane 5381,910 $0 $381,910 10.44% 9,520,000 0.0401 e Summit Hydro/Collins/Pioneer $18,936 SO $18,936 0.52% 270,248 0.0701 Braintree Watson Unit $40,587 $115,027 $155,615 4.25% 663,329 0.2346 Swift River Projects $52,680 $0 $52,680 1.44% 518,933 0.1015 Coop Resales $1,808 $0 $1,808 0.05% 47,382 0.0382 Constellation Energy $459,115 $0 $459,115 12.55% 12,318,000 0.0373 Stonybrook Peaking $272 $49,459 $49,731 1.36% - 0.0000 Monthly Total $2,168,234 $1,489,738 $3,657,972 100.00% 58,649,074 0.0624 Renewable Resources 4.33% • RENEWABLE ENERGY CERTIFICATES (RECD Table 5 shows the amount of banked and projected RECs for the Swift River Hydro Projects through September, 2013, as well as their estimated market value. • TRANSMISSION • The RMLD's total transmission costs for the month of September were $931,368. This is a decrease of 23.8% from the August transmission cost of $1,223,588. In September, 2012 the transmission costs were $979,543. Table 6 Current Month Table 5 Peak Demand (kW) 156,230 140,045 Swift River RECir Summary 58,649,074 67,363,709 58,633,476 Period - January 2013 - September 2013 $2,767,250 Banked Protected Total Eat. $1,540,623 REC4 RM RECF Oollarr Woronaca 3,652 929 4,581 $239,305 Pepperell 140.3 926 2409 $142,131 Indian River 1251 396 1647 $97,173 Turners Falls 1172 269 1441 $0 RECC Sold 4605 It 245,712 Grand Total 7,558 2,320 14,683 $724,321 • TRANSMISSION • The RMLD's total transmission costs for the month of September were $931,368. This is a decrease of 23.8% from the August transmission cost of $1,223,588. In September, 2012 the transmission costs were $979,543. Table 6 40 Current Month Last Month fast Year Peak Demand (kW) 156,230 140,045 129,569 Energy (kWh) 58,649,074 67,363,709 58,633,476 Energy ($) $2,168,234 $2,767,250 $2,646,309 Capacity ($) $1,489,738 $1,485.670 $1,540,623 Transmission($) $931,368 $1,223,588 $979,543 Total $4,589,340 $5,476,509 $5,188,675 40 0 � k \ \\ ! :- -- -- =a� ■� -- i ## § } m !¥; k \ !)[ n-2. \)) §\ Analysis of Capital Projects CJ Meter Upgrade Project As of 6/30/13 Budget Actual Variance 1,912,973 1,613,801 (299,172) Project Timeline Contract award for meters 11/2010 Residential installations complete 6/2013 Commercial installations expected completion 12/2013 Fixed Network Project As of 6/30/13 Budget Actual Variance 1,502,514 1,451,414 (51,100) Project Timeline Contract award for fixed network equipment 12/2011 Fixed network installation completed 6/2013 Anchment 2 READING MUNICIPAL LIGHT DEPARTMENT ® FY 14 CAPITAL BUDGET VARIANCE REPORT FOR PERIOD ENDING SEPTEMBER 30, 2013 ACTUAL YTO COST COST THRU ANNUAL REMAINING PROJECT DESCRIPTION TOWN SEP SEP 2013 BUDGET BALANCE ESO Construction- System Projects 1 5W9 Reconductoring - Wildwood Street W $ 169,494 $ 169,494 2 4W4 Reconductodng W $ 166,340 $ 166,340 3 Upgrading Old Lynnfeld Center URDS (Trog Hawlay) (Partial Carryover) LC 22,555 37,794 $ 140,827 $ 103,033 4 Upgrading Old Lynni Center URDS (Cook's Farm) LC $ 410,983 $ 410,983 5 4W5 -4W6 Tie R $ 96,596 $ 96,596 6 URD Upgrade$ -Ali Towns ALL 2,208 2,208 $ 210,005 $ 207,797 7 Stepdown Area Upgrades - All Towns ALL $232,817 $ 232,817 Total System Projects Station Upgrades 8 Relay Replacement Project- Gaw Slabon(Carryover) R $ 117,181 $ 117,181 9 Gaw Station 35 kv Potential Transformer (PT) Replacement R $ 40,288 S 40,288 10 Station 3- Replacement of Service Cutouts NR $ 30,126 $ 30,126 11 Station 4 Getaway Replacement -4W13 R $ 245,147 $ 245,147 15 Station 5- Getaway Replacements 5W9 and 5W10 W $ 95,343 $ 95,343 Total Station Projects SCADA Projects CrRTU Replacement - Station 3 NR $ 84,109 $ 84,109 Total SCADA Projects New Customer Service Connections 12 Service Installations- COmmemial8ndustrial ALL 2,904 19,294 $ 55549 $ 36,255 13 Service Installations- Residential Customers ALL 24,523 53,951 $ 200,302 $ 146,351 Total Service Connections 14 Routine Construction ALL Various 166,829 463,114 $ 1,014506 $ 551,192 Total Construction Projects 219,019 576,361 $ 3,309,414 $ 2,733,053 Other Projects 16 Transformers $ 284,000 $ 284,000 17A Meter Purchases $ 138,000 $ 138,000 17C AMR High - powered ERT Comm. Meter Upgrade Project (Partial Carryover) 8,703 148,177 $ 114,601 S (33,576; 17D AMR High - Powered ERT 500 Club Meter Upgrade Project $ 92,713 $ 92,713 18 Purchase New Pick -up Trucks $ 70,000 $ 70,DOO 19 Purchase Two New Line Department Vehicles $ 400,000 $ 400,000 20 Build Covered Storage (Multi -year Project) $ 150,000 $ 150,000 21 HVAC System Upgrade (Multi -year Project) $ 275,000 $ 275,000 22 Engineering Analysis Software and Data Conversion (Partial Carryover) $ 37,081 $ 37,081 23 New Radio System (Multi -year Project) $ 100,000 $ 100,000 24 Repairs - 226 Ash Stiset, Station i (Multi -year Project) $ 520,000 $ 520,000 26 Communication Equipment $ 100,000 $ 100,000 27 Hardware Upgrades 4,113 4,113 $ 181,000 $ 176,887 8 Software and Licensing 3,415 30,857 $ 180,200 $ 149,343 9 Master Site Plan and Photovoltaic Generation Installation $ 150,000 $ 150,000 Total Other Projects $ 16,231 183,147 $2,792,594 $ 2,609,447 TOTAL CAPITAL BUDGET S 235.251 759,508 $ 6,102,008 $ 5.342,501 Reading Municipal Light Department Engineering and Operations • Monthly Report September 2013 FY 2014 Capital Plan E &O Construction - System Proiects 1 5W9 Reconductoring- Wildwood Street: Project scheduled for October. 2 4W4 Reconductoring: Project not yet scheduled. 3 Upgrading of Old Lynnfield Center URDs (Trog Hawley - Partial Carryover): Installed splices to connect into primary loop. Energized new primary. Finished primary loop. Installed pull boxes. Cut over services. Line department installed new padmount transformers and secondary. 4 Upgrading of Old Lynnfield Center URDs (Cook's Farm): Project not yet scheduled. 5 4W5 -4W6 Tie: Project scheduled for October 6 URD Upgrades — All Towns: Quail Run, Wilmington — Replaced padmount transformer and repaired faulted primary loop 7 Stepdown Area Upgrades — All Towns: No charges for the month. Station Upgrades 8 Station 4 (Gaw) Relay Replacement Project (Partial Carryover): Project not yet scheduled. 9 Station 4 (Gaw) 35kv Potential Transformer Replacement: Project not yet scheduled. 10 Station 3 — Replacement of Service Cutouts: Project not yet scheduled. 11 Station 4 (Gaw) Getaway Replacement — 410113: Project not yet scheduled. 15 Station 5 — Getaway Replacements 5W9 and 5W10: Project schedule for November. SCADA Proiects 30 Station 3- RTU Replacement: Project not yet scheduled. October 25, 2013 1 New Customer Service Connections 12 Service Installations — Commercial/Industrial Customers — This item includes new • service connections, upgrades, and service replacements for the commercial and industrial customers. This represents the time and materials associated with the replacement of an existing or installation of a new overhead service, the connection of an underground service, etc. This does not include the time and materials associated with pole replacements/installations, transformer replacements/installations, primary or secondary cable replacements/installations, etc. This portion of the project comes under routine construction. Projects include North Reading Middle and High Schools and 300 Lowell Street (Burton's Grill) in Wilmington. 13 Service Installations —Residential Customers —This item includes new or upgraded overhead and underground services, temporary overhead services. Routine Construction 14 Routine Construction —The drivers of the Routine Construction budget category YTD are listed. This is not an inclusive list of all items within this category. Pole Setting/Transfers 70,351.53 Maintenance Overhead/Underground 170,151.70 Projects Assigned as Required 85 700.66 Pole Damage/Knockdowns - Some Reimbursable 22,688.44 Station Group 2,067.14 Hazmaf/Oil Spills 51,785.61 Porcelain Cutout Replacement Program 1 - Lighting Street Light Connections 6,195.09 Storm Trouble 6,450.72 Underground Subdivisions new construction 4,205.11 Animal Guard Installation 1,021.55 Miscellaneous Capital Costs 42,496.45 YTD TOTAL: 5463.714.00 (1) In September (0) cutouts were charged under this program. Approximately 19 cutouts were installed new or replaced because of damage making a total of 19 cutouts replaced this month. a] October 25, 2013 IL E Reliability Report Two key industry standard metrics have been identified to enable the RMLD to measure and track system reliability. A rolling 12 -month view is being used for the purposes of this report. Customer Average Interruption Duration Index (CAIDI) measures how quickly the RMLD restores power to customers when their power goes out. CAIDI = Total of Customer Interruption Duration for the Month in Minutes _ Total Number of Customers Interrupted. RMLD 12 -month system average outage duration: 53.19 minutes RMLD five -year average outage (2008 -12): 52.6 minutes per outage On average, RMLD customers that experience an outage are restored in 53.19 minutes October 25, 2013 3 System Average Interruption Frequency (SAIFI) — Measures how many outages each customer experiences per year on average. SAIFI = Total Number of Customers Interrupted a Total Number of Customers RMLD 12 -month system average: 0.38 outages per year RMLD five -year average outage frequency (2008.12): 0.62 The graph below tracks the month -by -month SAIFI performance. Months Between Interruptions (MBTI) Another view of the SAIFI data is the number of months RMLD customers have no interruptions. At this time, the average RMLD customer experiences an outage approximately every 32 months. October 25, 2013 4 Dt: October 25, 2013 • To: RMLB, Coleen O'Brien, Jeanne Fail Fr. Bob Fournier Sj: September 30, 2013 Report The results for the first three months ending September 30, 2013, for the fiscal year 2014 will be summarized in the following paragraphs. 1) Change in Net Assets: (Page 3A) For the month of September, the net income or the positive change in net assets was $1,463,882, bringing the year to date net income to $1,907,009. The year to date budgeted net income was $2,828,292, resulting in net income being under budget by $921,282 or 32.6 %. Actual year to date fuel revenues exceeded fuel expenses by $885,517. 2) Revenues: (Page I1B) Year to date base revenues were under budget by $659,035 or 4.8 %. Actual base revenues were $13.1 million compared to the budgeted amount of $13.8 million. 3) Expenses: (Page 12A) • *Year to date purchased power base expense was under budget by $85,514 or 1.1 %. Actual purchased power base costs were $7.8 million compared to the budgeted amount of $7.9 million. *Year to date operating and maintenance (O &M) expenses combined were under budget by $68,868 or 2.1 %. Actual O &M expenses were $3.2 million compared to the budgeted amount of $3.3 million. *Depreciation expense and voluntary payments to the Towns were on budget. 4) Cash: (Page 9) *Operating Fund was at $8,226,356. • Capital Fund balance was at $4,420,232. • Rate Stabilization Fund was at $6,695,667. • Deferred Fuel Fund was at $3,495,004. • Energy Conservation Fund was at $437,139. 5) General Information: Yew to date kwh sales (Page 5) were 202,169,978 which is 6.3 million kwh or 3.1 %, behind last year's actual figure. GAW revenues collected ytd were $202,191 bringing the total collected since inception to $2,195,416. • 6) Budget Variance: Cumulatively, the five divisions were under budget by $67,830 or 1.3 %. Attachment 3 FINANCIAL REPORT SEPTEMBER 30, 2013 ISSUE DATE: OCTOBER 25, 2013 taw ASSETS CURRENT UNRESTRICTED CASH RESTRICTED CASH RECEIVABLES, NET PREPAID EXPENSES INVENTORY TOTAL CURRENT ASSETS NONCURRENT INVESTMENT IN ASSOCIATED CO CAPITAL ASSETS, NET TOTAL NONCURRENT ASSETS TOTAL ASSETS TORN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS -TYPE PROPRIETARY FUND STATEMENT OF NET ASSETS 9/30/13 PREVIOUS YEAR CURRENT YEAR (SCH A P.9) 11,444,030.39 CURRENT 8,229,356.39 PAYABLE (SCH A P.9) 19,639,949.68 CUSTOMER ADVANCES FOR CONSTRUCTION 20,202,747.62 ACCRUED LIABILITIES (SCH B P.10) 9,405,647.09 NONCURRENT 8,195,375.49 ACCRUED EMPLOYEE COMPENSATED ABSENCES (0 CH B P.10) 1,669,804.10 1,411,727.14 2,982,915.76 3,132,560.84 1,449,231.83 2.982,915.76 1,521,933.75 3,132,560.04 43.609.463.17 39.561.140.39 (SM C P.2) 61,574.36 9.383.032.14 37,060.48 (SCH C P.2) 69,277,575.61 70,009,019.31 69.339.199.97 70.046.079.79 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 0 M 112.998,61].14 109,607,220.10 8,110,834.57 LIABILITIES 4,906,426.64 CURRENT 581,105.60 PAYABLE • CUSTOMER DEPOSITS DEPOSITS 308,559.17 CUSTOMER ADVANCES FOR CONSTRUCTION 427,304.15 ACCRUED LIABILITIES 1,812,646.43 TOTAL CURRENT LIABILITIES 170,301.90 NONCURRENT 10.893.145.77 ACCRUED EMPLOYEE COMPENSATED ABSENCES 6.250,471.30 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 0 M 112.998,61].14 109,607,220.10 8,110,834.57 4,906,426.64 581,105.60 746,358.61 308,559.17 427,304.15 1,812,646.43 170,301.90 10.893.145.77 6.250,471.30 2,982,915.76 3,132,560.84 2.982,915.76 3,132,560.04 13.076.061.53 9.383.032.14 69,277,575.61 70,009,019.31 3,553,740.93 3,679,743.06 26,241,227.07 26,535,425.67 99.072.551.61 100 224 188.04 112,948,613.14 109,607.220.10 TONE OF READING, NASSACHNSETTS MUNICIPAL LIGMT ..EARTHENT NONCURRENT ASSET SCHEDULE 9/30/13 SCHEDULE OF INVESTMENTS IN ASSOCIATED COMPANIES NEW ENGLAND HYDRO ELECTRIC NEW ENGLAND HYDRO TRANSMISSION TOTAL INVESTMENTS IN ASSOCIATED C01@ANIES SCHEDULE OF CAPITAL ASSETS LAND STRUCTURES AND IMPROVEMENTS EQUIPMRNT AND FURNISHINGS INFRASTRUCTURE TOTAL CAPITAL ASSETS, NET TOTAL NONCURRENT ASSETS l31 1,265,842.23 6,685,437.16 12,341,591.34 48.984,704.88 69.277,575.61 69.339,149.97 1,265,842.23 6,430,802.65 12,464,470.46 49,847,903.97 70,009,019.31 70,046.079.79 • E SCUROULE C PREVIOUS YEAR CUBREMT YEAR 2,975.74 3,261.87 58,598.62 33,798.61 61,574.36 37.060.48 1,265,842.23 6,685,437.16 12,341,591.34 48.984,704.88 69.277,575.61 69.339,149.97 1,265,842.23 6,430,802.65 12,464,470.46 49,847,903.97 70,009,019.31 70,046.079.79 • E OPERATING EXPENSES: (8CH E P.12) FONCNA9E0 POWER BASE TOW OF READING, HASSACN09NTT9 2,424,682.96 7,600,416.79 7,811,025.76 0.14% HDNICIPAL LID. DEPARMMI PORCBABED POWER FUEL 2,646,309.32 2,160,234.24 9,806,635.00 BO5INE88 -TYPE PROPRIETARY FUND STATEMENT OF REVEND68, EXPENSES AND CHANGES IN FORD NET ASSETS - 14.35% OPERATING 607,564.45 9/30/13 2,152,069.97 2,567,919.66 19.28% MONTH NORM LAST YEAR 280,641.65 CURRENT YEAR 458,820.32 YTD t 673,512.51 LABS YEAR CURRENT YEAR TO DATE DEPRECIATION TO DATE CHANGE OPERATING RNENUES: (SCH D P.11) 916,407.54 944,900.65 3.111 VOLUNTARY PAYMENTS TO TONNE 114,000.00 BASE REVENGE 4,657,037.04 4,300,093.22 13,449,113.84 13,155,956.58 -2.10% FUEL REVENUE 3,486,749.45 3,096,134.62 9,894,571.41 9,434,647.92 -4.65% PURCHASED POSER CAPACITY 222,443.57 23,406.80 631.177.04 66,739.15 - 89.11% FORFEITED DISCOUNTS 93,320.33 76,781.65 270,889.40 TOTAL NONOPERATING REV (ESP) 223,391.1D - 19.90% ENERGY CONSERVATION REVENUE 72,361.13 67,828.50 205,304.34 -3.63% 199,161.06 -2.94% DAN REVXNDE 73,410.73 68,822.22 208,347.42 202,191.02 2,031,703.35 -2.95% 1.963.882.9] "PA CREDIT (47,475.80) (61.811.13) (152,951.50) (149.297.25) -2.39% TOTAL OPERATINO REVENUES 8,557,860.25 7,659,256.08 24,514,452.03 23,134,891.38 96,534,059.99 -5.63% 98,317,178.79 OPERATING EXPENSES: (8CH E P.12) FONCNA9E0 POWER BASE 2,520,662.38 2,424,682.96 7,600,416.79 7,811,025.76 0.14% PORCBABED POWER FUEL 2,646,309.32 2,160,234.24 9,806,635.00 0,399,033.69 - 14.35% OPERATING 607,564.45 770,965.79 2,152,069.97 2,567,919.66 19.28% MAINTENANCE 155,083.78 280,641.65 458,820.32 673,512.51 46.79% DEPRECIATION 305,469.10 314,969.55 916,407.54 944,900.65 3.111 VOLUNTARY PAYMENTS TO TONNE 114,000.00 116 666.67 342.000.00 350.000.01 2.34% TOTAL OPERATING EXPENSES 6,349.089.11 6,084,160.86 21,477,150.42 20,747,200.28 -3.40% OPERATING INCOME 2,108,771.14 1,515,095.22 3,037,301.61 2,387,691.10 - 21.39% COMBATING REVENUES (EXPENSES) CONTRIBUTIONS IN AID OF CONST 4,051.18 (280.37) 36,746.75 4,937.38 - 86.56% RETURN ON INVESTMENT TO READING (188,785.58) (191,760.41) (566,356.74) (575,305.25) 1.58% INTEREST INCOME 2,970.63 2,285.65 9,612.94 7,361.47 - 23.42% INTEREST EXPENSE (257.20) (254.60) (776.46) (770.30) -0.78% OTHER (MDSE AND MORT) 4,953.18 78,804.93 21,963.52 83,094.93 278.33% TOTAL NONOPERATING REV (ESP) (177,067.79) (111.212.90) (498.809.99) (480.681.85) -3.63% CHANGE IN "I ASSETS 2,031,703.35 1.963.882.9] 2,538,491.62 1,907,009.25 - 24.88% "I ASSETS AT BEGINNING OF YEAR 96,534,059.99 98,317,178.79 1.85% "I ASSETS AT EST OF SEPTENBER 99.073,551.61 100.2]4.188.09 1.16% u (31 TOWN OF READING, MASSACHUSETTS HONICIPAL LIGHT DEPARTMENT BUSINESS -TYPE PROPRIETARY FUND STATEMENT OF REVENUES, EXPENSES AND CHANGES IN POND NET ASSETS 9/30/13 TOTAL OPERATING REVENUES 23,134,891.38 24,352,920.00 (1,118,028.63) -4.61% OPERATING EXPENSES: (SCH G P.12A) PURCHASED POWER BASE ACTUAL BUDGET (85,514.34) % PURCHASED POWER FUEL YEAR TO DATE YEAR TO DATE VARIANCE- CHANGE OPERATING REVENUES: (SCH P P.11B) -0.83% OPERATING 2,567,919.66 2,520,523.00 47,397.66 BASE REVENUE 13,155,956.58 13,814,992.00 673,512.51 (659,035.42) 789,778.00 -4.77% (116,265.49) FUEL REVENUE 9,434,647.92 9,583,134.00 944,908.65 (147,486.08) 943,800.00 -1.54% 11108.65 PURCHASED POWER CAPACITY 68,739.15 309,819.00 350,000.01 (241,079.05) 349998.00 - 77.81% 2.01 PORFEITED DISCOUNTS 223,391.10 303,930.00 1,907,009.25 (80,538.90) 2,838,293.00 - 26.50% (921,282.75) ENERGY CONSERVATION REVENUE 199,261.86 208,522.00 98,317,178.79 (9,259.14) 98,317,178.79 -4.44% 0.00 SAN REVENUE 101,191.02 208,522.00 300,33{.180.04 (6,330.98) 101145.470.79 -3.04% (931.]83.75] NYPA CREDIT 1149,297.25) (174,999.00) 25,701.75 - 14.69% TOTAL OPERATING REVENUES 23,134,891.38 24,352,920.00 (1,118,028.63) -4.61% OPERATING EXPENSES: (SCH G P.12A) PURCHASED POWER BASE 7,811,025.76 7,896,540.00 (85,514.34) -1.08% PURCHASED POWER FUEL 8,399,833.69 8,470,341.00 (70,507.31) -0.83% OPERATING 2,567,919.66 2,520,523.00 47,397.66 1.88% MAINTENANCE 673,512.51 789,778.00 (116,265.49) - 14.72% DEPRECIATION 944,908.65 943,800.00 11108.65 0.12% VOLUNTARY PAYMENTS TO TOWNS 350,000.01 349998.00 2.01 0.00% TOTAL OPERATING EXPENSES 20,747,200.28 20,970,979.00 1223,778.73) -1.07% • OPERATING INCOME 2,387,691.10 3,381,941.00 (894,249.90) - 27.25% • NONOPERATINO REVENUES (EXPENSES) CONTRIBUTIONS IN AID OF CONST 4,937.38 50,000.00 (45,062.62) - 90.13% RETURN ON INVESTNENT TO READING (575,305.15) (575,400.00) 94.75 -0.02% INTEREST INCURS 7,361.47 13,501.00 (5,139.53) - 41.11% INTEREST EXPENSE (770.38) (750.00) (10.38) 2.73% OTHER (MOSS AND AMORT) 83,094.93 60,000.00 23,094.93 38.49% TOTAL NONOPERATING REV (EXP) (480,681.85) (453.649.00) (27,032.85) 5.96% CHANGE IN NET ASSETS 1,907,009.25 2,838,293.00 (921,282.75) - 32.57% NET ASSETS AT BEGINNING OF YEAR 98,317,178.79 98,317,178.79 0.00 0.00% NET ASSETS AT END OF SEPTEfEER 300,33{.180.04 101145.470.79 (931.]83.75] -0.91% • ( ) - ACTUAL ORDER BUDGET (3A) 3 G W TOM OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT RECONCILIATION OF CAPITAL FUNDS 9/30/13 SOURCE OF CAPITAL FUNDS: DEPRECIATION FORD BALANCE 7/1/13 2,733,146.98 CONSTRUCTION FUND BALANCE 7/1/13 11500,000.00 INTEREST ON DEPRECIATION FUND BY 14 1,687.63 DEPRECIATION TRANSFER FY 14 944.908.65 TOTAL SOURCE OF CAPITAL FUNDS 5,179,743.06 USE OF CAPITAL FUNDS: LESS PAID ADDITIONS TO PLANT THRU SEPTENRER 759,510.35 GENERAL LEDGER CAPITAL FUNDS BALANCE 9/30/13 4.420.231.71 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SALES OF KILOWATT HOURS 9/30/13 MUNICIPAL SALES: MONTH NORTH LAST YEAR CURRENT YEAR YTD % SALES OF ELECTRICITY: LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE RESIDENTIAL SALES 28,615,201 25,540,399 82,232,730 80,169,552 -2.51% CONN. AND INDUSTRIAL SALES 42,247,434 40,557,855 118,741,155 114,464,916 -3.60% PRIVATE STREET LIGHTING 72,942 73,957 219,287 222,003 1.24% TOTAL PRIVATE CONSUMERS 70.935,577 66,172,211 201.193.172 194.856,471 -3.15% MUNICIPAL SALES: STREET LIGHTING 237,606 239,515 712,778 718,505 0.80% MUNICIPAL BUILDINGS 894,308 875,337 2,566,286 2,461,219 -4.09% TOTAL MUNICIPAL CONSUMERS 1.131,914 1.114.832 3.279,064 3,179.724 -3.03% SALES FOR RESALE 401,955 365,264 1,138,210 1,089,486 -4.28% SCHOOL 1,153,299 1,159,553 2,910,602 3,044,297 4.59% TOTAL KILOWATT HOURS SOLD 73.622,745 6S,S11 860 208,521,058 202,169,975 -3.05% 151 • C, TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT KILOWATT HOURS SOLD BY TOWN to 9/30/13 TOTAL READING LYNNPIELD NO.READING WILMINGTON MONTH RESIDENTIAL 25,540,399 8,355,664 3,678,696 6,082,559 7,913,480 cow 6 IND 40,557,855 4,937,863 396,805 6,260,065 18,963,122 PVT ST LIGHTS 73,957 13,129 1,360 22,030 37,438 PUB ST LIGHTS 239,515 80,662 32,500 41,686 84,667 MUNI BLDGS 875,317 197,823 179,751 166,202 331,541 SALES /RESALE 365,264 365,264 0 0 0 SCHOOL 1,159,553 406,306 265,058 130,180 349,909 TOTAL 68.011.860 14.356.]11 4.554.1]0 1].]10,032 37.190.157 YEAR TO DATE RESIDENTIAL 80,169,551 24,831,914 11,054,932 18,651,433 24,831,273 COMM 6 IND 114,464,916 14,024,549 961,054 17,719,602 81,759,711 PVT ST LIGHTS 222,003 39,307 4,080 66,526 112,010 PUB ST LIGHTS 718,505 241,986 97,500 125,018 254,001 MUNI BLDGS 2,461,219 567,010 505,645 495,125 893,429 SALES /RESALE 1,089,486 1,089,486 0 0 0 SCHOOL 3,044,297 1,111,061 726,618 350,960 847,650 TOTAL 202.169 970 91,905.403 14.149.829 37,416.664 108,698,002 LAST YEAR TO DATE RESIDENTIAL 82,232,730 25,054,849 12,296,002 19,195,943 25,685,936 cow A IND 118,741,155 15,048,939 912,707 18,540,415 84,239,094 PVT ST LIGHTS 219,287 40,755 4,080 63,888 110,564 PUB ST LIGHTS 711,778 241,608 97,460 120,129 253,501 MUNI BLDGS 2,566,206 582,673 461,820 551,632 970,153 SALES /RESALE 1,130,220 1,138,220 0 0 0 SCHOOL 2,910,602 11050,100 620,601 345,680 886,221 TOTAL 208.521.058 43,157,149 14.400,678 38.817,607 112,145,549 KILOWATT HOURS SOLD TO TOTAL TOTAL READING LYNNPIELD NO.READING WILMINGTON MONTH RESIDENTIAL 37.12% 12.14% 5.35% 8.84% 10.79% COMM 6 IND 58.93% 7.18% 0.58% 9.10% 42.07% PVT ST LIGHTS 0.11% 0.02% 0.00% 0.03% 0.06% PUB ST LIGHTS 0.35% 0.12% 0.05% 0.06% 0.12% HUNI BLDGS 1.27% 0.29% 0.26% 0.24% 0.48% SALES / RESALE 0.53% 0.53% 0.00% 0.00% 0.00% SCHOOL 1.69% 0.59% 0.39% 0.20% 0.51% TOTAL 100.00% 20.87% 6.63% 18.47% 54.03% YEAR TO DATE RESIDENTIAL 39.65% 12.26% 5.86% 9.23% 12.28% cow 6 IND 56.62% 6.94% 0.48% 8.76% 40.44% PVT ST LIGHTS 0.11% 0.02% 0.00% 0.03% 0.06% PUB ST LIGHTS 0.36% 0.12% 0.05% 0.06% 0.13% MUNI BLDGS 1.21% 0.28% 0.25% 0.24% 0.44% SALES /RESALE 0.54% 0.54% 0.00% 0.00% 0.00% SCHOOL 1.51% 0.55% 0.36% 0.18% 0.42% TOTAL 100.00% 20.73% ].00% 18.50% 53.77% LAST YEAR TO DATE RESIDENTIAL 39.43% 12.02% 5.90% 9.21% 12.30% cow 6 IND 56.94% 7.22% 0.44% 8.89% 40.39% PVT ST LIGHTS 0.11% 0.02% 0.00% 0.03% 0.06% PUB ST LIGHTS 0.34% 0.12% 0.05% 0.06% 0.11% MUNI BLDGS 1.23% 0.20% 0.22% 0.26% 0.47% SALES /RESALE 0.55% 0.55% 0.00% 0.00% 0.00% SCHOOL 1.40% 0.50% 0.30% 0.17% 0.43% TOTAL 100.00% 20.71% 6.91% 18.62% 53.76% 161 TOM OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT FORMULA INCOME • 9/30/13 TOTAL OPERATING REVENUES (P.3) 23,134,591.35 ADD: POLE RENTAL ]],296.08 INTEREST INCOME ON CUSTOMER DEPOSITS 347.94 LESS: OPERATING EXPENSES (P.3) (20,747,200.28) CUSTOMER DEPOSIT INTEREST EXPENSE (770.30) FORMULA INCOME (LOSS) 3.464,564.]4 E 0 OI 111 SALE OF KM (P.S) AVE PURCHASED A" RASE COST PER KM AVE RASE SALE PER AM AVE COST PER RNE AVE SALE PER HRH PUHL CHARGE REVENUE (P. 3) LOAD FACTOR PEAK LOAD 0 TOW OF READING, MASSACHUSETTS EUNICIPAL LIGHT DEPARTMENT GENERAL STATISTICS 9/30/13 MONTH OF SEP 2012 73,622,745 58,633,476 0.042990 0.063255 0.088123 0.110615 3,486,749.45 61.999 129,569 MONTH OF 9 CHANGE YEAR THRU SEP 2013 2012 1013 SEP 2012 SEP 2013 68,811,860 3.139 -3.054 208,521,050 202,169,976 58,649,074 1.129 -3.689 207,546,400 199,904,885 0.041342 6.429 3.969 0.037504 0.039074 0.063769 -0.529 0.899 0.064498 0.065074 0.078312 -3.019 -4.419 0.084834 0.081093 0.100764 -6.66% -0.199 0.111949 0.111741 3,096,134.62 - 11.199 -4.659 9,894,571.41 9,434,647.92 51.429 156,230 (1) fi Ob U ^�^11 W > � O (A U O N it III (' e( � U i � i edyy�b� 4-- 2< d I• I* 2 <O�, V I r<HyOyn, it (< � J • 7O b I i (i JO ('114 <iO�4 O(�n j J �i7 0 I 01 0b p�JO O 00 Lo 91t O O O O O O TOWN OF READING, NASSACHDBETTS NVNICIPAL LIGHT DEPARTMENT SCHEDULE OF CASH AND INVESTMENTS 9/30/13 u UNRESTRICTED CASH CASH - OPERATING POND CASH - PETTY CASH TOTAL UNRESTRICTED CASH RESTRICTED CASH CASH - DEPRECIATION FUND CASH - CONSTRUCTION FUND CASH - TURN PAYIQNT CASH - DEFERRED FUEL RESERVE CASH - RATE STABILIZATION FUND CASH - UNCOLLECPIBLE ACCTS RESERVE CASH - SIM LEAVE BENEFITS CASH - HAZARD WASTE REBER" CASH - CDSTONSR DEPOSITS CASH - ENERGY CONSERVATION CASH - OPEH TOTAL RESTRICTED CASH TOTAL CASH BALANCE c SCHEDULE A PREVIOUS YEAR CURRENT YEAR 11.441,830.39 8,236,356.39 3,000.00 3,000.00 11.999, B3a .39 8.319.356.39 3,553,748.93 3,679,743.O6 656,100.32 740,489.65 908,356.50 935,305.27 2,305.028.59 3,495,004.36 6.683,641.02 6,695,667.33 200,aoo.00 300,000.00 2,984,836.31 3,133,039.93 150,000.00 150,000.00 581,105.60 746,358.61 371,417.19 437,139.52 1,345,704.42 0.00 19,639,949.68 20,202,747.62 191 31,084,780.07 20 932,109.01 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF ACCOUNTS RECEIVABLE 9/30/13 SCHEDULE B SCHEDULE OF PREPAYMENTS PREPAID INSURANCE PREVIOUS YEAR 4,382,722.72 CURRENT YEAR SCHEDULE OF ACCOUNTS RECEIVABLE PREPAYMENT PURCHASED POWER 278,189.85 45,427.17 RESIDENTIAL AND COMMERCIAL 4,593,945.14 241,849.32 4,382,722.72 242,260.90 ACCOUNTS RECEIVABLE - OTHER 443,722.77 245,413.96 191,098.46 230,801.89 ACCOUNTS RECEIVABLE - LIENS 28,084.71 14,523.]0 28,097.35 14,523.70 ACCOUNTS RECEIVABLE - EMPLOYEE ADVANCES 892.14 1,669,804.18 892.14 1.411.73].14 SALES DISCOUNT LIABILITY (345,386.49) (336,183.12) 60 DAYS REBER" FOR UNCOLLECTIBLE ACCOUNTS (231.548.01) 2.12% (229.274.56) TOTAL ACCOUNTS RECEIVABLE BILLED 4,489,720.26 4,037,352.99 UNSILLED ACCOUNTS RECEIVABLE 4,915,936.83 47.410.44 4,158,022.50 1.17% TOTAL ACCOUNTS RECEIVABLE, NET 9.405.64].09 TOTAL 8,195.375.49 SCHEDULE OF PREPAYMENTS PREPAID INSURANCE 889,827.35 4,382,722.72 8]8,]13.48 PREPAYMENT PURCHASED POWER 278,189.85 45,427.17 PREPAYMENT PASNY 241,849.32 GENERAL LEDGER BALANCE 242,260.90 {,0{6,539.60 PREPAYMENT WATSON 245,413.96 230,801.89 PURCHASED POWER WORKING CAPITAL 14,523.]0 3,529,054.48 14,523.70 87.21% TOTAL PREPAYMENT 1,669,804.18 30 DAYS 1.411.73].14 ACCOUNTS RECEIVABLE AGING SEPTEMBER 2013: RESIDENTIAL AND COMMERCIAL 4,382,722.72 LESS: SALES DISCODNT LIABILITY (336,183.12) GENERAL LEDGER BALANCE {,0{6,539.60 CURRENT 3,529,054.48 87.21% 30 DAYS 375,232.35 9.27% 60 DAYS 85,673.12 2.12% 90 DAYS 9,169.21 0.23% OVER 90 DAYS 47.410.44 1.17% TOTAL 4.046.539.60 100.00% (101 I TOM ON READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REVENUE 9/30/13 SCHEDULE D SALES FOR MONTH 46,702.18 MONTH 41,577.45 LAST YEAR 132,251.36 CURRENT YEAR YTp % SALES OF RLECTRICITY: LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE RESIDENTIAL SALES 3,562,227.24 3,132,641.80 10,250,398.47 222,443.57 9,961,643.09 23,406.60 -2.82% 631,177.04 COME AND INDUSTRIAL SALES 4,273,355.21 4,057,260.29 12,243,894.19 (47,470.80) 11,788,188.40 (61,811.13) -3.72% (152,951.501 PRIVATE STREET LIGHTING 51660.95 5,595.73 17,070.67 B,557,860.25 17,178.79 0.63% TOTAL PRIVATE CONSUMERS 7,841.243.40 7,195.497.82 22,511,363.33 7.659,]56.08 21,767,010.28 24,514,452.03 -3.31% 13.134,891.38 MUNICIPAL SALES: STREET LIGHTING 27,917.05 27,072.58 83,745.15 02,409.26 -1.60% MUNICIPAL BUILDINGS 99,752.10 95,737.98 289,709.14 278,037.77 -4.03% TOTAL MUNICIPAL CONSUMERS 127.669.15 122,010 56. 373,454.29 360,447.03 -3.48% SALES FOR RESALE 46,702.18 7,484,227.84 41,577.45 23,343,685.25 132,251.36 22,590,604.50 125,810.59 -3.23% -4.86% FORFEITED DISCOUNTS SCHOOL 128,172.56 124,342.01 326,616.27 337,328.60 3.28% 222,443.57 0 SUE -TOTAL 8,143,787.29 7,484,227.84 23,343,685.25 22,590,604.50 -3.23% FORFEITED DISCOUNTS 93,328.33 76,781.85 278,889.48 223,391.10 - 19.90% PURCHASED POWER CAPACITY 222,443.57 23,406.60 631,177.04 68,739.15 - 89.11% ENERGY CONSERVATION - RESIDENTIAL 28 14.91 25,554.01 82,265.53 80,206.52 -2.501 ENERGY CONSERVATION - COMMERCIAL 43 :746.22 42,274.49 123,038.81 119,056.34 -3.24% SAW REVENUE 73,418.73 68,822.22 208,347.42 202,191.02 -2.95% NYPA CREDIT (47,470.80) (61,811.13) (152,951.501 (149,397.25) -2.39% TOTAL REVENGE B,557,860.25 -5.63% 7.659,]56.08 24,514,452.03 13.134,891.38 Sr UU TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REVENUE BY TOWN . 9/30/13 PERCENTAGE OF OPERATING TOTAL TOTAL READING LYNNPIELD NO.RBADING WILMINGTON NORTH TOTAL READING LYNNPIELD NO.RHAOING WILMINGTON MONTH RESIDENTIAL 3,132,641.80 1,02],16].11 449,253.91 41.86% 744,412.98 13.72% 911,807.80 6.00% INDUS /MUNI BLDG 4,152,998.27 12.19% 548,281.45 INDUS /NUNS BLDG 60,207.74 660,125.00 2,884,384.08 8.82% PUB.ST.LIGHTS 27,072.58 8,808.47 0.36% 3,4]9.2] 0.12% 4,793.23 0.05% 9,991.61 PRV.ST.LIGHTS 5,595.73 PRV.ST.LIGHTS 979.46 101.21 1,728.85 0.02% 2,786.21 0.04% CO -OP RESALE 41,577.45 0.56% 41,5]].45 0.56% 0.00 0.00% 0.00 0.00 SCHOOL 124,342.01 44,032.99 28,199.54 0.20% 15,044.46 0.49% 31,065.02 TOTAL TOTAL ].481,227.84 2.33% 1.6]0.816.93 7.23% 541.241.6) 1.426.104.52 3,816.034.]2 THIS YEAR TO DATE RESIDENTIAL 44.10% RESIDENTIAL 9,961,643.09 6.48% 3,102,957.12 1,463,052.89 2,319,914.15 53.41% 3,075,718.93 7.11% INDUS /NUNS BLDG 12,066,226.17 8.53% 1,606,957.16 37.05% 161,557.73 PON ST.LIGHTS 1,926,936.10 8,370,775.18 PUB.ST.LIGHTS 82,409.26 26,828.73 10,600.31 0.08% 14,582.09 0.01% 30,398.14 0.00% PRV.ST.LIGHTS 17,178.79 0.05% 3,025.09 CO -OP RESALE 310.43 5,319.37 8,523.90 0.00% CO -OP RESALE 125,818.59 125,818.59 1.49% 0.00 0.55% 0.00 0.35% 0.00 SCHOOL 337,328.60 TOTAL 123,798.95 78,654.72 40,968.64 19.06% 93,906.29 51.25% TOTAL 22590.604.50 4,989,385.63 1,714,176.06 1,307.720.3fi 11579,322.45 LAST YEAR TO DATE 43.91% 13.43% 6.53% 10.24% 13.71% INDUS /MUNI BLDG RESIDENTIAL 10,250,398.47 7.35% 3,134,474.44 0.66% 1,524,375.47 2,390,490.24 3,201,058.32 0.36% INDUS /MUN1 BLDG 12,533,603.33 1,716,137.82 0.07% 154,336.07 0.1 2,022,039.60 PRV.ST.LIGHTS 8,641,089.84 PUS.ST.LIGHTS 83,745.15 0.00% 26,920.90 10,649.37 15,688.50 0.57% 30,478.38 0.57% PRV.ST.LIGHTS 17,070.67 0.00% 3,132.01 0.0 312.75 SCHOOL 51159.59 8,466.32 CO -OP RESALE 132,251.36 132,251.36 0.00 100.00% 0.00 21.99% 7.54% SCHOOL 326,616.27 51.31% 118,781.58 69,948.84 40,252.45 30.�0,0o 97,633.40 _ TOTAL 23.393.685.25 5.131.]06.11 1.]59.622.50 4.4]3.630.38 11,978,726.26 PERCENTAGE OF OPERATING INCOME TO TOTAL TOTAL READING LYNNPIELD NO.RHAOING WILMINGTON MONTH RESIDENTIAL 41.86% 13.72% 6.00% 9.95% 12.19% INDUS /NUNS BLDG 55.49% 7.33% 0.80% 8.82% 38.54% PUE.ST.LIGHTS 0.36% 0.12% 0.05% 0.06% 0.13% PRV.ST.LIGHTS 0.07% 0.01% 0.00% 0.02% 0.04% CO -OP RESALE 0.56% 0.56% 0.00% 0.00% 0.00% SCHOOL 1.66% 0.59% 0.38% 0.20% 0.49% TOTAL 100.00% 2.33% 7.23% 19.05% 51.39% THIS YEAR TO DATE RESIDENTIAL 44.10% 13.74% 6.48% 10.27% 13.61% INDUS /HUNS BLDG 53.41% 7.11% 0.72% 8.53% 37.05% PON ST.LIGHTS 0.36% 0.12% 0.05% 0.06% 0.13% PRY.ST.LIGHTS 0.08% 0.01% 0.00% 0.02% 0.05% CO -OP RESALE 0.56% 0.56% 0.00% 0.00% 0.00% SCHOOL 1.49% 0.55% 0.35% 0.18% 0.41% TOTAL 100.00% 22.09% 7.60% 19.06% 51.25% LAST YEAR TO DATE RESIDENTIAL 43.91% 13.43% 6.53% 10.24% 13.71% INDUS /MUNI BLDG 53.69% 7.35% 0.66% 8.66% 37.02% PUB.ST.LIGHTS 0.36% 0.12% 0.05% 0.07% 0.1 PRV.ST.LIGHTS 0.07% 0.01% 0.00% 0.02% 0.0 CO -OP RESALE 0.57% 0.57% 0.00% 0.00% 0.0 SCHOOL 1.40% 0.51% 0.30% 0.17% 0.42% TOTAL 100.00% 21.99% 7.54% 19.16% 51.31% FORFEITED DISCOUNTS 223,391.10 TOM OF READING, MASSACHUSETTS 303,930.00 (80,538.90) - 26.50% PURCHASED PONER CAPACITY MUNICIPAL LIGHT DEPARI!KENT 309,819.00 (241,079.85) - 77.81% BUDGETED REVENUE VARIANCE REPORT 82,233.00 (2,026.48) -2.46% 9/30/13 119,056.34 126,299.00 (7,232.66) -5.73% SAN REVENUE 202,191.03 SCHEDULE P (6,330.98) -3.04% ACTUAL BUDGET (149,297.25) (174,999.00) % 25,701.75 - 14.69% YEAR TO DATE YEAR TO DATE 23 139 091.30 VARIANCE • CHANGE SALES OF ELECTRICITY: -4.61% RESIDENTIAL 6,216,924.02 6,554,255.00 (337,330.98) -5.15% COMM AND INDUSTRIAL SALES PRIVATE STREET LIGHTING 6,618,935.32 6,928,531.00 (309,595.68) -4.47% MUNICIPAL BUILDINGS PUBLIC STREET LIGHTING 48,878.99 49,894.00 (11015.01) -2.03% j SALES FOR RESALE 7S.145.02 93,864.00 (16,718.98) - 10.20% SCHOOL 196,073.23 190.448.00 5,625.23 2.95% TOTAL BASE SALES 13,155,956.59 13,814,992.00 (659,035.42) -4.77% TOTAL FUEL SALES 9,434,647.92 9.582.134.00 (147,486.08) -1.54% TOTAL OPERATING REVENUE 22,590,604.50 23,397,126.00 (806,521.50) -3.45% FORFEITED DISCOUNTS 223,391.10 303,930.00 (80,538.90) - 26.50% PURCHASED PONER CAPACITY 68,739.15 309,819.00 (241,079.85) - 77.81% ENERGY CONSERVATION - RESIDENTIAL 80,206.52 82,233.00 (2,026.48) -2.46% ENERGY CONSERVATION - COMMERCIAL 119,056.34 126,299.00 (7,232.66) -5.73% SAN REVENUE 202,191.03 208,522.00 (6,330.98) -3.04% PASNY CREDIT (149,297.25) (174,999.00) 25,701.75 - 14.69% TOTAL OPERATING REVENUES 23 139 091.30 24,253,930.00 11,118,028.621 -4.61% • ( ) = ACTUAL UNDER BUDGET I TOM OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING EXPENSES • 9/30/13 SCHEDULE e MONTH MONTH LAST YEAR CNRFAM, YEAR YTD % OPERATION EXPENSES: LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE PURCHASED POWER BASE EXPENSE 2.520.662.38 2,424,682.96 ],800.416.]9 ],811.025.]6 0.14% OPERATION SUP AND ENGINEERING SIP 30,352.73 44,470.64 119,542.30 132,154.69 10.55% MAINT OF STATION SUP LABOR AND MISC 2,692.85 6,792.17 15,787.47 2],001.]9 71.03% LINE MISC LABOR AND EXPENSE 36,659.87 9,253.18 42,755.50 14,459.58 132.939.36 21,697.57 160,485.30 40,968.41 20.72% 88.02% STATION LABOR AND EXPENSE 28,972.30 LINES - ON 35,871.02 109,359.78 121,955.72 11.52% STREET LIGHTING EXPENSE 4,422.61 MAINT OF 6,799.51 9,838.13 17,528.42 17,856.13 16,627.25 24,072.65 -5.14% 49,853.69 METER EXPENSE 7,330.11 12,591.25 LINE TRANSFORMERS 34,112.36 42,963.09 25.95% MISC DISTRIBUTION EXPENSE 21,054.51 0.00% 30,154.36 SAINT OF 73,958.94 (83.18) 81,911.70 (64.26) 10.75% (220.45) MIER READING LABOR i EXPENSE 5,138.91 3,254.48 23,970.02 GARAGE AND STOCKROOM 11,026.42 - 54.00% ACCT 6 COLL LABOR c EXPENSE 88,633.79 109,480.40 104,316.38 -4.75% 336,182.53 MAINT OF 364,441.99 397.31 8.41% 3,026.99 UNCOLLECIIBLE ACCOUNTS 8,333.33 10,500.00 24,999.99 31,500.00 0. PLANT 26.OD% ENERGY AUDIT EXPENSE 20.280.75 27,629.32 32,558.81 32,243.84 95,745.96 16.70% 107,744.30 12.53% ADMIN 6 GEN SALARIES 47,652.90 67,215.62 165,427.49 225,991.98 36.61% OFFICE SUPPLIES 6 EXPENSE 20,647.93 27,251.18 49,065.60 61,434.14 25.21% OUTSIDE SERVICES 49,522.36 61,252.60 79,932.06 70.634.39 - 11.63% PROPERTY INSURANCE 31,678.42 29.926.02 95,035.26 89,778.06 -5.53% INJURIES AND DAMAGES 3,940.15 3,305.95 10,316.44 9,400.60 -8.10% EMPLOYEES PENSIONS 6 BENEFITS 148,298.34 172,913.94 540,974.04 832,793.43 53.94% MISC GENERAL EXPENSE 13,888.61 23.952.65 38,614.07 44.291.16 14.70% RENT EXPENSE 13,837.19 27,323.71 62,330.80 54,558.65 - 12.48% ENERGY CONSERVATION 23,426.79 35,810.00 127,030.18 81,145.00 - 36.13% TOTAL OPERATION EXPENSES 60) 564.45 778,965.79 2,152,069.97 2,567,919.66 19.28% MAINTENANCE EXPENSES: MAINT OF TRANSMISSION PLANT 227.10 227.08 681.30 681.29 -0.01§ MAIMS OF STRUCT AND EQUIPMT 9,253.18 14,459.58 21,697.57 40,968.41 88.02% MAINT OF LINES - ON 81,152.83 121,256.10 249,483.96 359,467.03 44.00% MAINT OF LINES - US 9,838.13 17,856.13 24,072.65 49,853.69 107.10% MAINT OF LINE TRANSFORMERS 6,231.04 71,367.07 10,383.59 73,450.55 0.00% SAINT OF ET IT 6 BIG SYSTEM (83.18) (64.26) (220.45) (235.11) 6.65% MAINT OF GARAGE AND STOCKROOM 40,740.81 39,282.19 114,940.90 109,480.40 -4.75% MAINT OF METERS 397.31 3,026.99 10,151.48 7,602.46 - 25.11% MAINT OF 0. PLANT 7,326.56 13,230.]] 27,629.32 32,243.84 16.70% TOTAL MAINTENANCE EXPENSES 155.083.78 280,641.65 458.820.32 673.512.51 46.79% DEPRECIATION EXPENSE 305,469.18 314,969.55 916,407.54 944,908.65 3.11% PURCHASED POWER FUEL EXPENSE VOLUNTARY PAYMENTS TO TOWNS TOTAL OPERATING EXPENSES 2.646,309.32 2,168,234.24 9,806,635.80 114.000.00 116,666.67 342,000.00 0,399,033.69 - 14.35% 350,000.01 2.34% 6.349.089.11 6.084,160.86 31,4]1,150.42 20 747200.28 -3.40% li TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED OPERATING EXPENSE VARIANCE REPORT 9/30/13 SCHEDULE G • MAINTENANCE EXPENSES MINT OF TRANSMISSION PLANT ACTUAL BUDGET (68.76) -9.17% % OPERATION EXPENSES: YEAR TO DATE YEAR TO GATE VARIANCE ' GRANGE PURCHASED POWER BASE EXPENSE ).811,025.)6 59.19% ],896.540.00 MAINT OF LINES - ON (85,514.24) -1.08% (39,813.97) -9.97% OPERATION SUP AND ENGINEERING EXP 132,154.69 115,162.00 26,992.69 14.76% STATION SUP LABOR AND MISC 2],001.]9 22,159.00 4,042.79 21.85% LING MISC LABOR AND EXPENSE 160,485.30 185,567.00 (25,081.70) - 13.52% STATION LABOR AND EXPENSE 121,955.72 109,406.00 12,549.72 11.47% STREET LIGHTING EXPENSE 16,627.25 22,943.00 (6,315.75) - 27.53% METER EXPENSE 42,963.09 48,416.00 (5,452.91) - 11.26% MISC DISTRIBUTION EXPENSE 81,911.70 97,664.00 (15,752.30) - 16.13% METER READING LABOR 6 EXPENSE 11,026.42 11,588.00 (561.58) 944,908.65 -4.85% 943,800.00 ACCT R COLL LABOR 6 EXPENSE 364,441.99 386,662.00 (22,220.01) 8,399,633.69 -5.75% 8,470,341.00 UNCOLLECTIBLE ACCOUNTS 31,500.00 31,500.00 0.00 350,000.01 0.00% 349,998.00 ENERGY AUDIT EXPENSE 10],]44.30 101,814.00 5,930.30 5.82% ADMIN R SHE SALARIES 225,991.98 196,221.00 29,])0.98 20,]4).200.28 15.17% OFFICE SUPPLIES 6 EXPENSE 61,434.14 67,050.00 (5,615.86) -8.38% OUTSIDE SERVICES 70,634.39 142,027.00 (71,392.61) - 50.27% PROPERTY INSURANCE 89,))8.06 115,125.00 (25,346.94) - 22.02% INJURIES AND DAMAGES 9,480.60 14,924.00 (5,443.40) - 36.47% EMPLOYEES PENSIONS 6 BENEFITS 832.793.43 561,574.00 271,219.43 48.30% MSC GENERAL EXPENSE: 44,291.16 78,533.00 (34,241.64) - 43.60% RENT EXPENSE 54,558.65 53,001.00 1,557.65 2.94% ENERGY CONSERVATION 81,145.00 159,186.00 (78,041.00) - 49.03% TOTAL OPERATION EXPENSES 2.56].919.66 47,397.66 1.88% 3.520.531.00 • MAINTENANCE EXPENSES MINT OF TRANSMISSION PLANT 681.24 750.00 (68.76) -9.17% MAINT OF STRUCT AND EQUIPMENT 40,960.41 25,735.00 15,233.41 59.19% MAINT OF LINES - ON 359,467.03 399,281.00 (39,813.97) -9.97% MAINT OF LINES - UG 49,853.69 121,387.00 (71,533.31) - 58.93% MAINT OF LINE TRANSFORMERS 73,450.55 41,851.00 31,599.55 75.50% M.AINT OF ST IT 4 SIG SYSTEM (235.11) 2,644.00 12,879.11) - 108.89% MAINT OF GARAGE AND STOCKROOM 109,480.40 147,194.00 (37,713.60) - 25.62% MAINT OF METERS 7,602.46 14,960.00 (),35].54) - 49.18% MAINT OF GEN PLANT 32,243.84 35,976.00 (3,732.16) - 10.37% TOTAL MAINTENANCE EXPENSES 6]3.512.51 ]09,]]8.00 - 14.72% (116.265.49) DEPRECIATION EXPENSE 944,908.65 943,800.00 1,108.65 0.12% PURCHASED POWER FUEL EXPENSE 8,399,633.69 8,470,341.00 (70,507.31) -0.83% VOLUNTARY PAYMENTS TO TOWNS 350,000.01 349,998.00 2.01 0.00% TOTAL OPERATING EXPENSES -1.07% 20 9"!0 9]9.00 20,]4).200.28 (223,778.72) ( ) = ACTUAL UNDER BUDGET cw (12A) TOM OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED OPERATING EXPENSE VARIANCE EXPORT 9/30/13 • • (128) RESPONSIBLE REMAINING SENIOR 2014 ACTUAL BUDGET REMAINING OPERATION EXPENSES: MANAGER ANNUAL BUDGET YEAR TO DATE BALANCE BUDGET % PURCHASED POWER BASE EXPENSE JP 29,123,336.00 7,811,025.76 21,312.310.24 73.10% OPERATION SUP AND ENGINEERING RAP RE 467,978.00 132,154.69 335,823.31 71.76% STATION SUP LABOR AND MIBC RS 90,088.00 27,001.79 63,086.21 70.03% LINE MIBC LABOR AND EXPENSE AS 729,521.00 160,485.30 569,035.70 78.00% STATION LABOR AND EXPENSE XS 446,308.00 121,955.72 324,352.28 72.67% STREET LIGHTING EXPENSE KS 90,729.00 16,627.25 74,101.75 81.67% METER EXPENSE RE 218,064.00 42,963.09 175,100.91 80.30% MISC DISTRIBUTION EXPENSE RE 396,379.00 81,911.70 314,467.30 79.34% METER READING LABOR F EXPENSE RE 46,322.00 11,026.42 35,295.58 76.20% ACCT 6 COLL LABOR 6 EXPENSE RP 1,570,864.00 364,441.99 1,206,422.01 76.80% UNCOLLECTIBLE ACCOUNTS RP 126,000.00 31,500.00 94,500.00 75.00% ENERGY AUDIT EXPENSE JP 416,982.00 107,744.30 309,237.70 74.16% ADMIN A GEN SALARIES CO 794,002.00 225,991.98 568,010.02 71.54% OFFICE SUPPLIES 6 EXPENSE CO 268,000.00 61,434.14 206,565.86 77.08% OUTSIDE SERVICES CO 419,150.00 70,634.39 348,515.61 03.15% PROPERTY INSURANCE KS 460,600.00 89,778.06 370,021.94 80.51% INJURIES AND DAMAGES AS 58,206.00 9,480.60 48,725.40 83.71% EMPLOYEES PENSIONS 6 BENEFITS KS 1,870,479.00 832,793.43 1,037,685.57 55.48% MISC GENERAL EXPENSE CO 219,695.00 44,291.16 175.403.04 79.84% RENT EXPENSE RS 212,000.00 54,558.65 157,441.35 74.26% ENERGY CONSERVATION JP 636,761.00 81,145.00 555,616.00 87.26% TOTAL OPERATION EXPENSES 9,538,128.00 2.567.919.66 6,970.208.34 73.08% MAINTENANCE EXPENSES: • MAIM OF TRANSMISSION PLANT KS 3,000.00 681.24 2,318.76 77.29% (MINT OF STRUCT AND EQUIPMT AS 105,738.00 40,968.41 64,769.59 61.25% MAINT OF LINES - ON KS 1,604,829.00 359,467.03 1,245,361.97 77.60% MAINT OF LINES - US RE 485,432.00 49,853.69 435,578.31 89.73% MAINT OF LINE TRANSPORMERS RE 160,000.00 73,450.55 86,549.45 54.09% MAINT OF ST IT A BIG SYSTEM XS 10,487.00 (235.11) 10,722.11 102.24% MAINT OF GARAGE AND STOCKROOM AS 668,507.00 109,480.40 559,026.60 83.62% MAINT OF METERS AS 41,160.00 7,602.46 33,557.54 81.53% MAINT OF GEN PLANT RP 145,480.00 32,243.84 113,236.16 77.84% TOTAL MAINTENANCE EXPENSES 3,229.63].00 673,512.51 2.551,120.49 79.11% DEPRECIATION EXPENSE RF 3,775,200.00 944,908.65 2,030,291.35 74.97% PURCHASED POWER PURL EXPENSE JP 31,709,470.00 8,399,833.69 23,389,636.31 73.50% VOLUNTARY PAYMENTS TO TOWS RP 1,400,000.00 350,000.01 1,049,999.99 75.00% TOTAL OPERATING EXPENSES 73.69% 70.050.767.00 20 747200.28 58.103,566.72 • (128) c C� TOWN OF READING. MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT PROFESSIONAL SERVICES 9/30/2013 PROFESSIONAL SERVICES BY PROJECT PROPESSIONAL SERVICES BY VENDOR ITEM DEPARTMENT ACTUAL BUDGET 1 AMID AND PENSION TRUST AUDIT PEES ACCOUNTING 17,000.00 2,362.50 32,250.00 DUNCAN AND ALLEN 2 PENSION ACTUARIAL EVALUATION ACCOUNTING 0.00 0.00 624.99 3 LEGAL- PERC /ISO ISSUES ENERGY SERVICE 0.00 WILLIAM CROWLEY 4,500.00 4 LEGAL- POWER SUPPLY ISSUES ENERGY SERVICE 14,726.72 1,352.00 11,250.00 TOTAL 5 PROFESSIONAL SERVICES ENERGY SERVICE 41144.00 6,000.00 6 MAC COMPLIANCE AND AUDIT E F 0 3,714.50 4,000.00 7 LEGAL ENGINEERING 0.00 3,750.00 8 LEGAL - GENERAL GM 10,382.89 37,500.00 9 LEGAL SERVICES- OTHER HR 495.05 10,500.00 10 LEGAL SERVICES - NEGOTIATIONS HR 13,966.51 0.00 11 LEGAL SERVICES - ARBITRATION BE 4,629.73 21,900.00 12 LEGAL GENERAL BLDG. MAINT. 0.00 375.00 13 SURVEY RIGHT OF NAY BLDG. MAINT. 0.00 1,251.00 14 ENVIRONMENTAL BLDG. MAINT. 0.00 1,251.00 15 INSURANCE CONSULTANT GEN. BENEFIT 0.00 2,499.00 16 LEGAL GEN. BENEFIT 0.00 1,151.00 17 LEGAL MATS MGMT GEN. BENEFIT 950.00 3.750.00 18 DSA BASIC CLIENT SERVICE ENGINEERING 624.99 0.00 TOTAL 70,634.39 142,027.00 PROPESSIONAL SERVICES BY VENDOR ACTUAL MELANSON BRAIN 6 COMPANY 17,000.00 UTILITY SERVICES, INC. 2,362.50 DUNCAN AND ALLEN 4,901.54 RUBIN AND ANDEAN 18,998.07 DOBLE ENGINEERING 624.99 CHOATE HALL R STEWART 19,091.29 WILLIAM CROWLEY 2,080.00 BEtRYDUM 4,144.00 PLM 1,352.00 TOTAL 70,634.39 (13) (14) SELO DEFERRED FUEL CASE RESERVE ANALYSIS 9/30/13 • GROSS MONTHLY TOTAL DATE CHARGES REVENUES NYPA CREDIT DEFERRED DEFERRED Jun -13 2,609,487.38 Ju1-13 3,464,349.32 2,953,072.91 (53,841.00) (565,117.41) 2,044,369.97 Aug -13 2,767,250.13 3,385,440.39 (33,645.12) 584,545.14 2,628,915.11 Sep -13 2,168,234.24 3,096,134.62 (61,811.13) 866,089.25 3,495,004.36 (14) RMLD STAFFING REPORT FOR FISCAL YEAR ENDING JUNE, 2014 • CONTRACTORS US LINE 2.00 14 BUD TUL AUG SEP 2.00 TOTAL 13 13 13 GENERAL MANAGER GENERAL MANAGER 2.00 2.00 2.00 2.00 HUMAN RESOURCES 1.00 1.00 1.00 1.00 COMMUNITY RELATIONS 1.00 1.00 1.00 1.00 TOTAL 4.00 4.00 4.00 4.00 BUSINESS ACCOUNTING 2.00 2.00 2.00 2.00 CUSTOMER SERVICE 7.75 7.75 7.75 7.75 MONT INFORMATION SYS 6.00 6.00 6.00 6.00 MISCELLANEOUS 1.00 1.00 1.00 1.00 TOTAL 16.75 16.75 16.75 16.75 ENGINEERING & OPERATIONS 2.00 2.00 2.00 2.00 AGN E &O ENGINEERING 5.00 5.00 5.00 5.00 LINE 22.00 21.00 21.00 21.00 METER 3.00 3.00 3.00 3.00 STATION 8.00 8.00 8.00 8.00 TOTAL 40.00 39.00 39.00 39.00 PROJECT BUILDING 2.00 2.00 2.00 2.00 GENERAL BENEFITS 2.00 2.00 2.00 2.00 TRANSPORTATION - - - - MATERIALS NGMT 4.00 4.00 4.00 4.00 TOTAL 8.00 8.00 8.00 8.00 ENERGY SERVICES ENERGY SERVICES 4.50 3.50 3.50 3.50 TOTAL 4.50 3.50 3.50 3.50 RMLD TOTAL 73.25 71.25 71.25 71.25 CONTRACTORS US LINE 2.00 2.00 2.00 2.00 TOTAL 2.00 2.00 2.00 2.00 GRAND TOTAL 75.25 73.25 73.25 73.25 (15) RMD •BUDGET VARIANCE REPORT FOR PERIOD ENDING SEPTEMBER 30, 2013 DIVISION ACTUAL BUDGET VARIANCE CHANGE ENGINEERING AND OPERATIONS 1,121,957 1,181,442 (59,485) -5.03% ENERGY SERVICES 207,292 282,751 (75,460) - 26.69% GENERAL MANAGER 177,748 247,723 (69,975) - 28.25% FACILITY MANAGER 1,223,813 1,040,879 182,934 17.57% BUSINESS DIVISION 2,381,607 2,427,452 (45,845) -1.89% SUB -TOTAL -1.31% 5,112,417 5,180,247 (67,830) PURCHASED POWER - BASE 7,811,026 7,896,540 (1,321,494) -1.08% PURCHASED POWER - FUEL 8,399,834 6,470,341 728,144 -0.83% TOTAL -1.04% 21,323,276 21,547,128 (661,180) • 11 16 10 I G ( | § § \ � \| \� .,- i; ■ !I, ,|. ! || . .,t .!� (& )(t i!! ! || !| r ;!7 |. !|§ -■, �; \�§ \ (( |! , -■ !! | ■| ;; || lip t 22 || Foti srom: Jeanne Foti Thursday, October 24, 2013 11:18 AM To: RMLD Board Members Group Subject Account Payable Warrant and Payroll - No Questions Good morning. In an effort to save paper, the following timeframes had no Account Payable Warrant and Payroll questions. This e-mail will be printed for the Board Book for the RMLD Board meeting on October 30, 2013. Account Payable Warrant — No Questions September 20, September 27, October4, October 18 Payroll — No Questions September 23, October 7 and October 21. anne Foil ading 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. E* Jeanne Fotl From: Coleen O'Brien • Sent Wednesday, October 16, 2013 10:23 AM To: John Stempeck cc Jeanne Foti; Patricia Mellino; Accounting Group Subject RE: Account Payable Warrant Questions - October 14 Good morning: Below, please find Information pertaining to each of your AP questions. 1. Avis Car Rental moved out of the service territory. This is a refund. 2. Exelon Energy always sends a reconciliation email prior to sending out monthly Invoice. The correspondence is done with an email in lieu of phone, for formal paper trail. Macquelre reconciliation Is also done by email similarly, as well as JP Morgan. The amount of on peak and off peak as per the contract is verified by calculation based on hours. lane or Bill verifies the actual MWH deliveries through CMARS. A copy of the email relating to the reconciliation request may not always be attached to the Invoice as you saw It this time, but always occurs. 3. In 2012, Business wanted to set up a customer relationship management database to track payment plans that were arranged with RMLD customers . RMLD used it for 2012 and then only had two log Ins for 2013. Intuit billed for the entire year of 2013. RMLD called Intuit to Inquire about the charge for 2013 and Franklin Perkins, Sales Rep, said that RMLD would not have to pay for 2013 for only two log Ins. The software was unsustainable due to high maintenance. Even though the Sales Rep said that RMLD could disregard the bill for 2013, It had already been given to a collection agency. i Please let me know if you need further Information on any of the Items. •a/ Enjoy your day. Coleen CoieervM. 0'8r caz General Manager Reading Municipal light Department 230 Ash Street Reading, MA 01867 From: Patricia Melllno sent: Tuesday, October 15, 2013 7:39 AM To: Accounting Group Cc Coleen O'Brien; Jeanne Fod Subject: Account Payable Warrant Questions - October 14 Goad Morning, Attached are the Account Payable Warrant Questions for October 14, 2013. Thanks. El