Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2012-11-28 RMLD Board of Commissioners Packet
i z LU U c 0 .y 2 d UI i a v Y L a L; c u LAc v c di F �i a c Cl C 0' N N of © N N as L Z ^� L l AL W ^0' ti 0) cnc N ■� Y;. N s i z LU U c 0 .y 2 d UI i a v Y L a L; c u LAc v c di F �i a c Cl C V 1.00, 0) IL c w c � ai v a c O Ln i C � O 4-J O o 1 N 0 � 06 D C v� +- 7 M U -0 -0 (3) cy) c " U LL N M rp al + C Ln ro 2 N C �_ = X O 0— o Z s C W .}' N in +� v 0 c C • Ul 0 m Ln Ln 0 ra c 0 'L °�' a� W N O ? '+� o v � ro Ln +, O Q1 41 } r6 ro .'n 0 vi t in v D C 2 V w w � V� m co . . . . . . . . . . c C O a� v E v � v V 41 C s r ,- J ■ O > .C: O c v v a U-) a H v C °> c c LU C Y d D L J Ln s L °1 ai O Z D V) m aj L r +-1 v O V) rn � = v v Z c v O U Ln w 06 O � � i V ti W ■ ■ U ro V V) fo V 0 m r 0 v uj V + C C + C O .0 vi "t r0 �O M -d Tv N r0200 C 7-O N � � 0 0i Z o °1 V a Ln V N v 0 i C 00`0 V i C N 4' C 41 +1 V1 C '�L � 4J N V 00 v O-++ 41 O N L-0 O -p v m V1E -- lJ LL ■ ■ ■ ■ ■ Myn vs O KE I. - -J I a �I E �j O +� 4� T to 41 � .§ cz Ln O V 41 � V O N N O D a) O C V t O Ln t Q N Q1 O_ r0 4/ 2 = m 2 ■ ■ ■ ■ Ln _ v N Ln N v ir- ca tn T i O O O V O L L O t v 'O V 0 N 4+ Ln O L6 =) T o = 0 Q _ 0 i1 ■ • V) X Ln w C' 4- o o C- -0 o ro ,V D ra W E �j O +� 4� T to 41 � .§ cz Ln O V 41 � V O N N O D a) O C V t O Ln t Q N Q1 O_ r0 4/ 2 = m 2 ■ ■ ■ ■ Ln _ v N Ln N v ir- ca tn T i O O O V O L L O t v 'O V 0 N 4+ Ln O L6 =) T o = 0 Q _ 0 i1 ■ • Ul C- 0 4J (O, V O U 1 ,i 0 im. 4 � au C aj c a v v E Q v E E O a o V � � 06 0) c ro 06 v +o ro � ro � 0 O in kn -0 ;I � v 0 Q ro 0 M +- 0/ = oZ 0 im. 4 � au C aj c a v v E Q v E E O a o V � � i aJ a a O v v v � ra c v a0- i L aj ro ai a E aj i ro 06 a! ro � � 4-. v > kn ro M v = oZ Ln v T O CL Ln CL � -0 u 0) > ro i aJ a a O v v v � ra c v a0- i L aj ro ai a E aj i Ln C- 0 �4-J t�1 `^^ `T V L: X m 3 j! l t- Q t r6 L a a 4 ro c L O 41 .+, _0 ro C: C v N � L O E O I^ v °o 4+ Q N 3 j! l t- Q t r6 L a a 4 ro L 4-j id C v O C E O -0 4+ _ ro N v C LJ in L In O O • O .4-J u t W 0 V) L O O n • Ul O C- _0 0 Oli C 0 a 06 IA 3 v 0 0 -0 0 ro O ` a1 ro 0 v l� ° �- Q v M V O N it T o 0 C: �- o AM V �. cp Ln,. X W 0 v � a `�° ° o ° 'O N (0 � Q= ro 4� Ov ro Q 2i t C C- 0 V L O N C- O) c •4-J V) X a W v L O C O O 4 p �1 C r6 ru _ N Ln _ iJl f0 L L 4 C y... a--+ U) C a--� ro G1 O rp ro O v +' Z U- a O u c r6 i D 4-J 111 U i0 4-+ ._ .., I iii, V I .X 'C v as LU o h: Ln ai L c Ln ra o v i E Y C' o .Y -O v 7 O �� v_ E ro >ro0 c c L O O� v v v O 'O C c `� O Q ai v _O1� Y m U N 1J OZS 0 m N 'O N C O 'L m Ln Ov p 0 4� ro i `*o o M cCN G Ln cVf • • • �/ G C: O •,_ 4-, - to O V j O) O ro N ro (a " -o M f0 C 4-0 @ O J O 4� L Q1 C 0 Ln {A 4J }' v71 C � 4- C 0 01 � Ln C 4— r6 = a0 N F— O O vi ■■ Ln 41 4J fa ra 4J J U tn rV Al u (A Q) a' v f n, 4— �n CL � rB C: lu W ti W- c O Ln N E L C X a1 4-J ai 4- C ro V C ..> V kn "o Ln I a L v L o c In E W fp X O Q N Q) C c v � O O L i--j ro Q ro C L aj L Q ro > > co W _ Q ro L ro ru aj —v 4-J 4- Q E V c: O O v `^ L ro 2 0 O v p Ln ro rB ro v Q N Ln ro ro ate+ C2 _ Q 0 O E }' E v v + 4-j c rB O 0 - N +� Ln N O 0 0 0 L>1 C a v (� L r0 V ro i 'n O O O N vii O 0 C O X v r Ul O ro -W W ro Ln M O O _r_ ; 7 c 2 0 » E 0 .@ ■ % 2 [ 0 � v ( . y.; � � § and \ a ,a] _ ƒk� r o ƒ /k/ Ln a Ln � .2 ¥ .f / _0 u u u I a ,a] _ r o ƒ a 3)k / \ E % 3 4 k \ / ± R ° & / /yEO$ § 0- I ry v ra 0 O 4. O� a. a� 0 v c w �� v L in CL cu Z: N > O V O 4! D V V rp O V O_ 0 C Q �2 FC E O § m � o O O O LL Ln a l L Ql 0 Ln O� U') ro L N C Gl ++ 0 p N 0 00 0 D O 4-1 O 0 V O V vii N O 0 01 N Q Q O a� Qwv H 0 j 0 0 ° °o °o ° o °o °o o °o °) o °o °o °° oo 00 00 ap t-0 � O U') 4i W H N kA N M kA W kA a1 al r6 ° ° 0 O r i V) > -0 aJ L a1 Laj 01 (L) Q CO — U ro O +., ° Cl CL U ° O �� o L a1 o L o W O cij L 4+ L X O O O ro �� ro 4_ +� U U N U U E r6 C (6 2 C r—° ro o CL —T = o °- -s-- on on O O . H 0 j 0 ry c Ln i-J O a) s 0 >s t u aJ ro kn ro � kn O c V) k � a) M ra . � V) v +-J a) +, °- EZ a) Ln s O _0 Q l -C pl � ra u D iJ M ro O S O � Ln S 4-J ateJ Ln 4-J C: C Ln 0 u aJ c E Ln 0 Ln ai C O p L _ a--+ ra LL a1 O `� ro O ro 4-J ro > j 41 N N O _O -0 O W W E d 2 0 ry c J u N Q Q N O 0 C p O 0 0 Q 0 0 0 a o p 0 O o O 0 Q ei N M 4p {q tli Hi c O O O O� Ol ei O O O O 0 0 0 0 tjC ei ri N W I I N Q 0 Lf O i- O 0 O O 0 m �Y�II� IY LLI LL LL I■II� � ICY IIY IN NI II IA III oil IN N Q Q N O 0 C p O 0 0 Q 0 0 0 a o p 0 O o O 0 Q ei N M 4p {q tli Hi c O O O O� Ol ei O O O O 0 0 0 0 tjC ei ri N W I I N Q 0 Lf O i- O 0 O O 0 m LLI LL LL LL N N N • 1 - �W Ol Q1 ro lO T ^� ` :D 55 4J N -O u L O 0 V V) V O ro rya — � rB O +-+ rB Q V `•^ O 4— _I u c Ln O Ol O+_j .2 O _0 > }, — r6 ra -O -c- rc) O_ -Q :D 'ro 01 ra u Ol E � N rB > O U) • PERFORMANCE PLANAND REVIEW READING MUNICIPAL LIGHT DEPARTMENT GENERAL MANAGER FY2012 PROCESS The Board of Commissioners (Board) of the Reading Municipal Light Department (RMLD) is responsible for hiring and evaluating the General Manager (GM), setting his/her compensation and establishing policies that guide the GM in the operations of the RMLD, according to Chapter 164 of the Massachusetts General Laws. This document describes the goals and objectives set by the Board for the GM. It also serves as an evaluation form for the Board to use at the completion of the fiscal year. The Board has established the following seven criteria for evaluating the GM's performance for the period July 1, 2011 — June 30, 2012, with the relative weight to be given each factor: Finance 20% ANN Energy Efficiency and Load Management 20% System Reliability 20% Leadership 10% Board Relations 10% Employee Relations 100/0 Community Relations 10% At the end of the fiscal year, each Commissioner is expected to complete this evaluation form within two weeks after receiving it. In addition, the GM will be required to do a self - assessment on this same form. The General Manager Committee will review all evaluation forms and make a recommendation to the Board regarding the GM's compensation for fiscal year 2012. The Committee will also recommend to the Board goals for future performance including priorities, goals, and timetables. Scoring Guidelines: Each Commissioner is responsible for independently assessing the performance of the GM using this document. These scores should reflect not only the completion of each task or activity, but also the quality of the results. In addition to numerical scoring, written comments describing the basis for the numerical score are highly desirable and stmnaly encouraged. The score in each performance category has a wide range (i.e., from 1 to 20 points). Scores at the very high end of the range should reflect performance where all tasks / activities were completed on time with a high degree of quality. Scores at the very low end of the range would signify that few if any of the tasks / activities were completed, were late, and ® were completed with unacceptable quality ATTACHMENT 2 1. FINANCE Goal: Meaningful budgets are developed in a timely manner. Expenses are accurately tracked and reported. Cash reserves are prudently invested. Financial targets are met. Plans are developed to meet unexpected contingencies. Minimum Tasks to be completed: 1. Provide the basis for the estimates found in the Capital & Operating budgets. 2. Create Capital & Operating budgets and submit to CAB and the Board. 3. On a monthly basis provide the Board with actual expenditures and variance with respect to the Capital and Operating Budgets. 4. On a quarterly basis update the Six Year Financial Plan and provide to the Board. 5. On a quarterly basis provide the Board with a report on the Retirement trust general ledger & Town cash reconciliation. 6. Perform a Cost of Service (COS) study, when necessary, and provide the CAB and the Board with a rate adjustment recommendation. 7. Create a plan to show how the RMLD will meet its 8% return. 8. If required, report to the Board on matters raised in the FY2011 audit letter. 9. If the rate - stabilization fund misses its year -end goal by more than $0.5 million, prepare a plan to address the issue. Overall Score: (1 — 20 points) Comments: • 10 11. ENERGY EFFICIENCY AND LOAD MANAGEMENT Goal: Assess peak demand and energy needs to determine amounts of capacity and energy necessary to meet system requirements. Consider and implement energy efficiency, load management and conservation measures. Seek a diverse power supply portfolio, including environmentally responsible power. Minimum Tasks to be completed: 1. Continue the power supply procurement strategy, including obtaining bids from renewable projects. 2. Manage the fuel clause and deferred -fuel- account balance. 3. Implement the Conservation and Energy Efficiency Program approved by the Board. 4. Keep up to date on new industry technologies and inform the Board of suggested operational changes to meet these trends. 5. Create new initiatives to address the Board's commitment to green power. 6. Continue the RMLD's efforts to maintain reasonable rates including the provision of monthly rate comparisons to the Board. 7. Propose budget funding to decrease the RMLD energy use at the 230 Ash Street complex by at least 5% in FY 13. 11 Comments: H Overall Score: (1 — 20 points) III. THE RELIABILITY OF THE RMLD SYSTEM • Goal: Construct and maintain an electric distribution system capable of delivering electric service with a high degree of reliability. Measure the reliability of the RMLD's distribution system against industry standards. Minimum Tasks to be completed: 1. Provide an annual report to the Board dated December 3191 of the previous year's safety incidents. 2. Provide an annual report to the Board dated December 31 regarding security issues, including the recommendation of new measures and/or procedures. 3. Maintain SAIFI and CAIDI indices on a monthly basis and provide an explanation if RMLD's reliability measures exceed industry standards or RMLD's historical performance. 4. Maintain an outage database detailing the nature and duration of an outage and RMLD's response to the outage. 5. Prepare a five-year capital plan report annually for presentation to the Board that addresses future needs of the RMLD's distribution system, the date of the report to be in conjunction with the release of the Capital Budget. 6. Modify and re- evaluate the capital and operating budgets throughout the year to address concerns affecting the reliability of the distribution system. • 7. Complete the second phase of the Meter Upgrade Project. 8. To propose budget funding for a twenty -five year plan for increasing the RMLD's resistance to hurricanes and ice storms. Overall Score: (1 — 20 points) Comments: • ® IV. MANAGE EMPLOYEES 11 L_J Goal: Keep employees informed about Board initiatives and policies. Assure that competent individuals are hired, trained and promoted. Negotiate contracts and conduct business with the bargaining units in a professional manner. Provide effective leadership to direct reports. Minimum Tasks to be completed: 1. Maintain a highly skilled and knowledgeable workforce. 2. On an annual basis, provide a Summary of Grievances report to the Board dated December 31 ". 3. Participate in negotiations, when necessary, with the three bargaining units for renewal contracts; keep the Board apprised of the outcome of these negotiations. 4. Assure that appropriate training is provided for all staff. 5. Submit a report to the Board on the safety incidents at the RMLD by December 30. Overall Score: (1 — 10 points) Comments: V. LEADERSHIP • Goal: Delegate tasks and monitor performance of key staff. Identify and bring to the attention of the Board changes in legislation that may affect the running of a public power utility. Participate in training programs, conferences and seminars to develop enhanced personal skills and to contribute to the development of others. Minimum Tasks to be completed: 1. Maintain comprehensive coverage of new information related to governmental regulations, financial conditions, technological changes, energy, and resource developments as they relate to public utilities. 2. Bring issues regarding these matters to the attention of the Board. 3. Discuss long -range goals for capital expansion with the Board. 4. Assure that the goals and implementing strategies of the strategic plan are being followed. Overall Score: (1 — 10 points) Comments: • • ® VI. RELATIONSHIP WITH THE BOARD Goal: Actively keep the Board informed of major issues and strategic direction of the RMI.D. Maintain professional working relationships with elected Commissioners. Provide needed information to the Board to assist it in making decisions. Minimum Tasks to be completed: 1. Communicate effectively with Board members. 2. Provide useful information to the Board that is helpful in Board decision - making. 3. Respond to the voted requests of the Board and meet time commitments made to the Board. 4. Provide quarterly updates to the Board on the progress of the "implementing strategies" from the RMLD's strategic plan. 5. Identify current issues, problems or projects that should concern the Board. Comments: E l_J Overall Score: (1 — 10 points) VII. RELATIONSHIP WITH THE COMMUNITY SERVED BY THE RMLD • Goal: Maintain good working relationships with all the constituent groups that interface with the RMLD Minimum Tasks to be completed: 1. Continue a good working relationship with the Town Managers in the four towns served by RMLD. 2. Attend all meetings of the CAB. 3. Continue to maintain working relationships with state and national utility associations and groups, and forward to the Board's attention new matters being raised by these entities. 4. Assure that an Annual Report is given at the Subsequent Town Meeting of the Town of Reading. 5. Communicate effectively with community and business interests in the four towns served by the RMLD. 6. Communicate effectively with customers regarding rate increases, or other relevant information. 7. Seek to influence government concerning the emerging needs of the RMLD. 8. Evaluate the cost and the effectiveness of the RMLD's public relations programs. 9. Provide an annual report to the Board on Customer Service programs. 10. Assure that Customer Service training is provided to all positions that have consistent contact with residential or commercial customers. Overall Score: (1 —10 points) Comments: 0 Calculation of Annual Raise: Total Score Possible: 100 points Calculation of Annual Increase: Composite Score: greater than 95 90-95 85 -90 80-85 75-80 70-75 65-70 < 65% CPI + 2 %' CPI + 1.4% CPI + 0.9% CPI + 0.6% CPI + 0.3% CPI CPI % - 0.5% (if negative, no increase) No Raise, written warning. The Board may consider awarding an increase in pay that is higher than CPI + 2% if the GM performs extraordinary work during the evaluation period. E H 0 • r� u To: Vincent Cameron From: Energy Services Date: November 19, 2012 Subject: Purchase Power Summary - October, 2012 Energy Services Division (ESD) has completed the Purchase Power Summary for the month of October, 2012. ENERGY The RMLD's total metered load for the month was 55,581,443 kwh, which is a.5 1% increase from the October, 2011 figures. Table l is a breakdown by source of the energy purchases. L-A ATTACHMENT TABLE 1 Amount of Cost of % of Total Total $ $ as a Resource Energy Energy Energy Costs % (kWh) ($/Mv ) Millstone #3 3.620,479 $6.99 6.40% $25,298 0.97% Seabrook 109,749 $8.25 0.19% $905 0.03% Stonybrook Intermediate 1,733,401 $50.36 2.00% $57,079 2.20% JP Morgan 8,878,200 $56.29 15.68% $499,769 19.26% NeslEm 4.083,000 $45.46 7.21% $185,628 7.15% NYPA 1.731,560 $4.38 3.06% $7.546 0.29% ISO Interchange 17.289,147 $36.51 30.54% $631.190 24.32% NEMA congestion 0 $0.00 0.00% $12,644 0.49% Coop Resales 90,215 $131.60 0.78% $11,872 0.46% MacOuade 18,192,000 $58.02 32.14% $1,55,483 40.67% Summit Hydm 527,857 $5173 0.93% $27,306 1.05% Braintree Watson unit 250,296 $54.59 0.44% $13,665 0.53% SWA Ri,er Projects 700,620 $95.80 1.24% 566,982 2.58% Stonybrook Peaking 0 50.00 0.00% $9 0.00% Monthly Total 56,606,524 $45.85 100.00% $2,595,375 100.00% L-A ATTACHMENT Table 2 breaks down the ISO interchange between the DA LMP Settlement and the RT • Net Energy for the month of October, 2012. ISO DA LIMP " Table 2 Amount Cost % Of Total Resource of Energy of Energy Energy (kWh) ($I") ISO DA LIMP " 16,958,370 38.04 29.96 % Settlement Total Coat $ RT Net Energy '• 330,778 42.20 0.58% Settlement 51.70 ISO Interchange 17,289,147 36.51 30.54% (subtotal) 7,742 ' Independent System Operator Day -Ahead Locatlonal Marginal Price Real nme Net Energy 17.23% CAPACITY The RMLD hit a demand of 95,568 kW, which occurred on October 15, at 7 pm. The o RMLD's monthly UCAP requirement for October, 2012 was 211,731 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 Coat $ %of Total Cost Millstone #3 4,991 51.70 $258,023 18.60% Seabrook 7,742 30.87 $238,998 17.23% Stonybrook Peaking 24,981 192 $48080 347% Stonybrook CC 42,925 3.75 $161,183 11.62% N1'PA 4,019 3.37 $13,539 0.980% Hydro Quebec 4,584 4.42 $20,279 1.46% Neatera 60,000 5.50 $330,000 23.79% Braintree Watson Unit 10,520 10.99 $115,579 8.33% ISO -NE Supply Auction 51,969 3.87 $201,294 14.51% Total 211,731 $6.55 $1,386,975 100.00% 01 Table 4 shows the dollar amounts for energy and capacity per source. 6,830 ® 7,234 $279,306 Table 4 3679 364 Coat of $215,446 Indian River 2100 92 % of Amt of Energy Pr Resource Energy Capacity Total coat Total Cost (kWh) ($IkWh) Millstone #3 $25198 $258,023 $283,321 7.11% 3,620,479 0.0783 Seabrook $905 $238,998 $239,903 6.02% 109,749 2.1859 StoMbrook Intermediate $57,079 $161,183 $218,262 5.48% 1.133,401 0.1926 Hydro Quebec SO $20,279 520,279 0.51% - 0.0000 JP Morgan 5499.769 SO $499.769 12.55% 8,878,200 0.0563 NextEm $185,628 5330,000 $515,628 12.95% 4,063,000 0.1263 • NYPA $7,548 $18539 $21,085 0,53% 1,731,560 0.0122 ISO Interchange 5631,190 $201,294 $032,484 20.90% 17,289,147 otI482 Name Congestion $12.644 50 $12,644 032% - 0.0000 MaCQuarie $1,055,483 50 $1.055,483 26.50% 18,192,000 0.0580 • Summit Hydro $27,306 $0 $27,306 0.69% 527,857 0.0517 Braintree Watson Unit $13.655 $115,579 $12 &243 3.25% 250,296 0.5164 • Svdft Riwr Projects $66.982 $0 $66.982 1.68% 700,620 0.0956 Coop Resales $11,872 $0 $11,872 0.30% 90,215 0.1316 Storrybrook Peaking $9 $48.080 548,088 1.24% - 0.0000 Monthly Total $2,595,375 $1,386,975 $3,982,351 100.00% 56,606,524 0.0704 • Renewable Resources 5.23% QRENEWABLE ENERGY CERTIFICATES (RECs The RMLD's Renewable Energy Certificates through the month of September, 2012 have an estimated market value of $610,945, based on market prices as of November 16, 2012. Table 5 shows the amount of banked and projected RECs for the Swift River Hydro Projects, as well as the estimate market value. Table 5 Swift River RECs Summary Period - January - September 2012 Banked Pralerad Total W. RECs RECs RECs Dollars Woronow 6,830 394 7,234 $279,306 Paoli 3679 364 4063 $215,446 Indian River 2100 92 2192 $116.193 Turners fiats 750 0 750 $0 Grand Total 13,359 870 14,130 $610,945 kar TRANSMISSION • The RMLD's total transmission costs for the month of October were $845,905. This is an decrease of 13.6% from the September transmission cost of $979,543. In October, 2011 the transmission costs were $727,145. • • I Table 6 Current Month Last Month Last Year Peak Demerol (kW) 95,568 129,569 97,508 Energy (kWh) 56,606,524 58,633,476 55,392,262 Energy ($) $2,595,375 $2,646,309 $2,955,398 Capacity ($) $1.386,975 $1,540,823 $1,348,586 Transmission ($) $845,905 $979,543 $727,145 Total $4.828,255 $5,166.675 $5,031,130 • • I G 11 It k k .e. ! (\ 7(k }\ ! ... ` 4 «§ i// n¥ a■ r §# #! � -- -- -- §| !| ## (f ##K #E ! ! ! ! _ . . . F■ §f &5 !!<f#!§ ct ;�§ ■#;■ 7/ !$| ■� )i ■ r! «! «!! � !! ■�` Tim \2 ! .e. ! ! ... ` 4 «§ r §# #! !| ##K #E #e !!<f#!§ ;�§ ■#;■ r! «! «!! � !! !2222!/ !! .. . # ###■ ■# E 0 4w a PROJECT DESCRIPTION READING MUNICIPAL LIGHT DEPARTMENT FY 13 CAPITAL BUDGET VARIANCE REPORT FOR PERIOD ENDING OCTOBER 31, 2012 Ego L VoU 3 PrQIadw 1 Ease. Street Remnducmring 2 4W13 off Remaductmng - West Street 3 Upgrading of Old Lynne" Center UROr(PanrI CARRYOVER) 5 Shady Lane Area - Reconductodnq 6 Federal Street - Reconductoing Total System Projects St,tlon U,Iadec ACTUAL YTD ACTUAL ANNUAL Stands u R COST COST BUDGET REMAINING TOWN OCTOBER THRU 10131112 AMOUNT BALANCE LC 200 200 191,855 197855 W 1.591 5.42 188,193 182,))1 LC 29.390 105,342 492.143 3N.a01 IN 12.000 184 199.042 198.858 W 583 175585 174.702 St,tlon U,Iadec 32,339 97,495 5 158 Stands u R 119.]09 118.09 9 Relay Replacement Proiecl-(French CARRYOVER) 4130 161779 151]40 9 Station 4 Getaway Replacement -4W13 R 558!10 203,300 Total Station Projects 551.853 550.853 SCADA ProlecM W 56,16) 58.18] 10 SOWn 5 RTU (Remote Terminal Unlp Replecemenl 474,861 340 16.709 80.653 51,944 4 Stffion4RTU(RemOte Terminal UnlOReplamment(Panal CARRYOVER) R 11000 12.000 Total SCADA Projects 150 000 150 00 N C < In Connect(.. 12 SIIVInA lnelal at O id"! harou "roue r."uBMmera ALL 13 Service Installations � Residential Cuslomere ALL Total service Connections 14 R au C do n Various Routine Conaucaon Towl Construction Project, Other Protect, 15 GIs 16 Trans(ormerUCapaoMm Annual PurOases 17A Meter Annual Purchases ITS Meter Upgrade P.).- (Panel CARRYOVER) 9C Mew Upgrade Protect Comma iaN 18 PuMuseveMCurs 19 Purchase Line Oeparlment Vehicles W Purchase Ni Pour Dolly 21 Automated Bull5l1 Systems 22 Engineering "all" soloi 6 data c.hsrrdh (CARRYOVER) 23 Gina Station Generator 2e Centel Repairs- Station One 25 New CarpearO 26 Water Herter Centrers Response Technology 27 Haroware Upgrades 29 Soeware and Licari TOTAL FY 13 CAPITAL PROJECT EXPENDITURES El Total Other Projects 1,925 6.095 03074 58,978 13,2" 70,01 207,923 131482 ALL 194,901 710.861 589211 2))827 2]9.682 922,682 2629316 2,66),216 9,184 32,339 97,495 5 158 44,810 142,924 284,000 141076 49.710 19.)10 0,905 361.115 558!10 203,300 551.853 550.853 65 000 65 NO 2)13)1 474,861 570000 05.199 11000 12.000 150 000 150 00 76709 76.789 55000 58,000 400000 400,000 35000 35.000 189,366 189990 3361111 146621 2622 24776 126629 101853 30423 40.569 118002 70.433 6Th 711 12)48)1 349308 2218231 653364 2 12 266 6423416 42211149 ATTACHMENT • Ll Reading Municipal Light Department Engineering and Operations Monthly Report October 2012 FY 2013 Capital Plan E &O Construction - System Proiects 1. Reconductoring of Essex St. Lynnfield Center - Engineering Labor; 2. 4W13 OH Reconductoring Project, West St., Wilmington -Engineering Labor. 3. Upgrading of Old Lynnfield Center URDs - (Continuation of phase 1) Engineering labor. Cutting over services and installing pull boxes and box pads; extended conduits from street to box pad locations; installed new transformer pads; padmount transformer deliveries and installation; Install cable; terminate secondary cables; grounded all padmounts from ground rod; installed load break; permanently connected padmounts and energized; Phase 1 completed. 5. Shady Lane Drive Area, Wilmington - Reconductoring - No activity ir6. Federal Street, Wilmington - Reconductoring - No activity Station Upgrades 6. Station 4 Relay Replacement Project - Reading - No activity 9. Station 4 Getaway Replacement - 4W13 - No activity SCADA Proiects 10. Station 5 RTU Replacement, Wilmington -No activity 4. Station 4 RTU Replacement - Senior Tech labor; cut in wiring. 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 replacement/installations, primary or secondary cable replacement/installations etc. This portion of the project comes under routine construction. Notable services this month: Relocated a temporary service at Reading Woods. 13. Service Installations —Residential Customers— This item includes new or upgraded overhead and underground services, temporary overhead services, and large underground development. 14. Routine Construction —The drivers of the Routine Construction budget category YTD are listed. This is not an inclusive list of all items within this category. Pole Settin_WTransfers $97,811 Maintenance OverheadIVnderground $259,989 Pro'ects Assigned as Re uired $87,914 Pole Damage includes knockdowns some reimbursable $44,452 Station Group $14,199 HazmabOil Spills $0 Porcelain Cutout Replacement Program $0 Lighting Street Light Connections $7,251 Storm Trouble $32,550 Underground Subdivisions $36,141 Animal Guard Installation $18,221 Miscellaneous Capital Costs $112,455 TOTAL $710,984 'In the month of October, zero (0) cutouts were charged under this program. Approximately 29 cutouts were installed new or replaced because of damage making a total of 29 cutouts replaced this month. .,_,., iii ir 11 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 — 61.61 minutes RMLD 4 year average outage (2006 -2009) — 50.96 minutes per outage On average, RMLD customers that experience an outage are restored in 61.61 minutes. System Average Interruption Frequency ( SAIFI) — Measures how many outages each customer experiences per year on average. SAIFI = Total number of customer's interrupted / Total number of customers. RMLD 12 month system average - .34 outages per year RMLD 4 year average outage frequency - .82 The graph below tracks the month -by -month SAP performance. q 0 c LL M. 0.80 0.84 0.70 .69 0 0.60 0.50 0.150 0.40 0.30 0.20 21 7 17 D.10 11 0.00 ^^ ^^ ^M1 ^M1 ^M1 ^ry ^M1 ^ry ^ry �A ^ry ^ry ^ry Q°� 0 PSI S )� ) r e!� d' —RMLD monthly outage frequency RMLD 12 month system average outage frequency .34 —RMLD 4 year overage outage frequency 82 (2006 -200 Months Between Interruptions (MBTI) Another view of the SAIFI data is the number of months Reading customers have no interruptions. At this time, the average RMLD customer experiences an outage approximately every 35 months. 4 ' Dt: November 26, 2012 To: RMLB, Vincent F. Cameron, Jr., Jeanne Foti Fr: Bob Fournier Sj: October 31, 2012 Report The results for the first four months ending October 31, 2012, for the fiscal year 2013 will be summarized in the following paragraphs. 1) Change in Net Assets: (Page 3A) For the month of October, the net loss or the negative change in net assets was $711,078, decreasing the year to date net income to $1,827,412. The year to date budgeted net income was $1,449,017, resulting in net income being over budget by $378,395 or 26.11 %. Actual year to date fuel expenses exceeded fuel revenues by $320,024. 2) Revenues: (Page IIB) Year to date base revenues were under budget by $565,007 or 3.27 %. Actual base revenues were $16.7 million compared to the budgeted amount of $17.3 million. 3) Expenses: (Page 12A) *Year to date purchased power base expense was under budget by $881,662 or 8.08 %. Actual purchased power base costs were $10.0 million compared to the budgeted amount of $10.9 million. *Year to date operating and maintenance (O &M) expenses combined were under budget by $226,377 or 5.5 %. Actual O &M expenses were $3.9 million compared to the budgeted amount of $4.1 million. *Depreciation expense and voluntary payments to the Towns were on budget. 4) Cash: (Page 9) *Operating Fund was at $10,158,162. • Capital Fund balance was at $3,662,562. • Rate Stabilization Fund was at $6,684,769. • Deferred Fuel Fund was at $1,950,020. • Energy Conservation Fund was at $378,704. 5) General Information: Year to date kwh sales (Page 5) were 258,818.903 which is 498,000 thousand kwh or .19 %, behind last year's actual figure. GA W revenues collected ytd were $258,658 bringing the total collected since inception to $1,555.744. 6) Budget Variance: Cumulatively, the five divisions were under budget by $221,024 or 3.38 %. ATTACHMENTS �1J FINANCIAL REPORT OCTOBER 31, 2012 v ISSUE DATE: NOVEMBER 26, 2012 N l n NET ASSETS TOW OF READING, MASSACHUSETTS INVESTED IN CAPITAL ASSETS, NET OF RELATED DEBT RESTRICTED FOR DEPRECIATION FUND (P.9) UNRBSTRI CTED 63.559,160.63 4,302,802.15 33,856,596.19 69,646,306.18 3,661,561.96 25,052,604.69 MUNICIPAL LIGHT DEPARTMENT 95.]16.538.9] 98.361,1)1.83 EUSIN8S8 -SVPB PROPRIETARY FUND 108.3]).80].68 109. 1fi 1.691.96 STATEMENT OF NET ASSETS 9/30/12 PREVIOUS YEAR CURRENT YEAR ASSETS CURRENT UNRESTRICTED CASH (SCH A P.9) 10,139,260.18 10,161,162.65 RESTRICTED CASH (S CH A P.9) 1],563,99].]] 19,206,956.13 RESTRICTED INVESTMENTS (SCH A P.9) 11100,000.00 0.00 RECEIVABLES, NET (SCH 5 P.10) 8,311,266.76 7,611,615.36 PREPAID EXPENSES (SCN B P.10) 996,685.20 1,116,522.99 INVENTORY 1,536,388.63 1,673,163.31 TOTAL CURRENT ASSETS 60,768,598.46 39.669.130.63 NONCURRENT INVESTMENT IN ASSOCIATED CO (SCE C P.2) 70,068.61 66,959.35 CAPITAL ASSETS, NET (BCH C P.21 67,559,140.43 69,646,306.10 TOTAL NONCURRENT ASSETS 61.619.109.01 69,693,266.53 108,3]].80].68 109.161 ,696.96 TOTAL ASSETS LIABILITIES ACCOUNTS DEPOSIT 7.593,153.02 585,]23.1] 5,166.,420.36 636,620.11 CUSTOMER DEPOSITS 315,009.96 390,663.15 CUSTOMER ADVANCES FOR CONST0.UCTION 1,119,683.70 1,515,517.66 ACC0.O8D LTABZLISISB TOTAL CURRENT LIABILITIES 9,726,569.93 7.817,106.37 NONCURRENT 0.00 0.00 EN BONDS PAYABLE, NET OF CURRENT PORTION 2,982,915.76 ACCRUED EMPLOYEE COMPENSATED ABSENCES 2,936,698.58 EN TOTAL NONCURRENT LIABILITIES 2.936.698.58 ],981.915.]6 12,661,368.51 30 600,011.13 TOTAL LIABILITIES n NET ASSETS INVESTED IN CAPITAL ASSETS, NET OF RELATED DEBT RESTRICTED FOR DEPRECIATION FUND (P.9) UNRBSTRI CTED 63.559,160.63 4,302,802.15 33,856,596.19 69,646,306.18 3,661,561.96 25,052,604.69 TOTAL NET ASSETS (P.3) 95.]16.538.9] 98.361,1)1.83 TOTAL LIABILITIES AND NET ASSETS 108.3]).80].68 109. 1fi 1.691.96 TOWN OF ANADING, MASSACHMSETTS MUNICIPAL LIGNT DEPARTMENT NONCURRENT ASSET SCHEDULE 9/30/12 SCNEOULE OF INVESTMENTS IN ASSOCIATED COMPANIES NEW ENGL HYDRO ELECTRIC MEN ENGLAND NITRO TRANSMISSION TOTAL INVESTMENTS IN ASSOCIATED COMPANIES SCREDOLE OF CAPITAL ASSETS LAND STRUCTURES AND INPROVEMENTS EDUIPIffi1T AND FURNISHINGS INFRASTRUCTURE TOTAL CAPITAL ASSETS, NET TOTAL NONCURRENT ASSETS 1]1 SC3®ULE C PREVIOUS TEAR CURRENT YEAR 15,]4].64 2,9]5.]4 54,320.97 43,982.61 70.068.61 46.958 35 1,265,842.23 6,537,440.54 1],885,386.95 46.8]0.5]0 ]3 67,559.140.43 67,629,209.04 1,265,84].]3 6,]30,]]].16 12,851,923.34 48.]98.363 45 69 66�- ®'306'18 69,693.]64.53 n 21 TOW 09 READING. MASSACHUSETTS NOHICIPAL LIGHT DEPARTMINT BOSITS -TYPE PROPRIETARY FUND 9TATRMENP OF REVENUES, IIPRN9R9 AND CHANGES IN FOOD NET' ASSETS 1,233,116.17 9,320,607.36 10,033,532.96 9/30/13 2,955,398.39 2,595,375.45 13,197,373.59 12,403,011.25 NDMTR - 10.11% MONTH 617,591.69 LAST YNAR 962,694.57 CURRENT YEAR 3,865,253.35 YTD t 3,115,564.54 LAST YEAR CURRENT YEAR TO DATE 313,038.01 TO DATE 918,636.51 CRANOR OPERATING REVINUR9: (SCH D 1.11) - 15.98% 396,027.47 305,469.18 11184,109.88 1,321,676.73 BASE REVENUE FORD, REVENUE PDRCEASED POKER CAPACITY FORFEITED DISCOUNTS EN6ROY CONSERVATION REVENUE GAM REVOKE NYPA CREDIT 3,643,450.86 3,853,952.53 (10,841.90) 73,655.53 561155.65 57,073.70 (45,133.69) 3,377,968.30 3,389,147.98 152,401.19 96,307.74 49,512.66 50,311.37 (48.701.28) 16,753,391.04 13,993,903.41 (49,360.34) 331,587.73 195,647.93 259,294.43 (335.495.98) 16,737,003.14 13,283,719.39 753,578.33 375,197.33 254,827.03 358,656.69 (301.732,18) -0.15% - 13.13% - 1690.69% 13.15% 30.35% -0.25% - 14.34% 0.88% TOTAL OPERATING REVOKES 6,626,345.59 9,966,877.80 31.347,967.26 30,481,329.91 -2.45% OPERATING ZXPWSK9: (SON B 1.12) PDA.SED TONER BASE PORCNASSD POKER FUEL OPERATING NAINTSNRNCE DEPRECIATION VOLUNTARY PAYMRNTB TO TOW$ TOTAL OPERATING EXPENSES OPERATING INCOME &PRNATING REVENUES (EEPERSES) CONTAIBPPIONS IN AID OF CONST RETURN ON INVESTNZNT TO READING INTEREST INMM INTEREST EXPENSE OTHER (NOSE AND AMORT) TOTAL NONOPRRATINO REV (EXP) CHANGE IN EST ASSETS NSL ASSETS AT BEGINNING OP YEAR "I ASSETS AT BND OP OCTOBER 3,078,533.97 1,233,116.17 9,320,607.36 10,033,532.96 7.65% 2,955,398.39 2,595,375.45 13,197,373.59 12,403,011.25 - 10.11% 617,591.69 962,694.57 3,865,253.35 3,115,564.54 0.74% 335,394.98 313,038.01 918,636.51 771,058.33 - 15.98% 396,027.47 305,469.18 11184,109.88 1,321,676.73 3.19% 113.000.00 114.000.00 452.000.00 456.000.00 0.88% 6,355,946.50 6,523,693.68 28,537,870.59 38,000,844.10 -1.88% 210,402.09 (556,815.80) 2,710,086.67 2,400,485.81 -6.47% 0.00 3,601.00 24,104.99 40,347.75 67.38% (183,839.75) (160,785.55) (735,319.00) (755,14].321 2.10% 8,646.49 2,175.44 43,953.05 '12,368.30 - 71.81% (506.03) (355.95) (3,020.40) (1,03].411 - 49.10% 63,774.19 28,401.11 72,157.19 50,365.63 - 30.20% 1111.915.101 (154.36].981 (597 13].171 (653,071.971 9.37% 156,486.99 (711.078.761 2,113,956.50 1,837,413.04 93,603,583.47 96,534,059.99 95.716,536.97 _ 96.361,472 .83 - 13.51% 3.13% 3.76% TONS OF READING. MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS -TYP3 PROPRIETARY FUND STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FORD NET ASSETS 9/30/12 OPERATING REVRNBES: (SCR P P.11B) BABE REVENUE PURL REVENUE PURCNABRD POWER CAPACITY FORFEITED DISCOUNTS SNEROY CONSERVATION REVEN E, SAW REVENUE NYPA CREDIT TOTAL OPERATING REVENUES OPERATING EXPENSES: (SCH 0 P.12A) PURCHASED POWER RASE PURCHASED POWER PURL OPERATING MAINTENANCE DEPRECIATION VOLUNTARY PAYMEWTS TO TOWNS TOTAL OPERATING EXPENSES OPERATING INCOME NONOPERATINO REVENUES (EXPENSES) CONTRIBUTIONS IN AID OF COVET RETURN ON INVESTMENT TO READING INTEREST INCOME INTEREST EXPENSE OTHER (MDSE AND MORT) TOTAL NONOPERATING RN (EXP) CHANGE IN NET ASSETS "I ASSETS AT BEGINNING OF YEAR NET ASSETS AT END OF OCTOBER • ( ) • ACTUAL UNDER BUDGET ACTUAL BUDGET % YEAR TO DATE YEAR TO DATE VARIANCE- CBANGB 16,]2],083.14 17,392,090.00 (565,007.86) -3.27% 12,283,719.39 11,585,043.00 690,676.39 6.03% ]83,5]8.23 792,610.00 (9,031.]]) -1.14% 3]5,19].32 380,425.00 (5,22].]8) -1.37% 254,827.02 261,652.00 (6,824.98) -2.61% 258,658.69 00 261,652.00 00 _ (2,993.311 -1.14% (201.]32.]8) (333.332.00) 31.599 22 - 13.54% 30,481,329.91 30,340,140.00 141,189.91 0.47% 10,033,533.96 10,915,195.00 (881,662.04) -8.08% 13,401,011.25 11,]06,]91.00 695,230.35 5.94% 3,115,564.84 3,150,308.00 (134,743.16) -4.15% 771,858.33 863,493.00 (91,634.67) 3.24% 1,231,876.72 1,216,668.00 5,208.71 0.43% 456,000 00 456.000 00 _ 0.00 0.00% 28,000,844.10 18,400,455.00 (407,610.90) -1.43% 1,480,485.81 1,931,685.00 568,800.81 28.41% . 40,34].]5 300,000.00 (159,652.25) - 79.83% (755,142.32) (755,000.00) (142.33) 0.02% 13,388.38 33,333.00 (30,943.63) - 62.83% (1,032.41) (1,000.00) (32.41) 3.24% 50,365.63 40,000.00 10,365.63 25.91% I65J.0]3.971 (4B2.6fi 8.001 (1]0.604.9]1 35.30% 1,827,412.84 1,449,017.00 378,395.84 96,534,059.99 96,534,059.99 0.00 98.361.4]3.8] 97,983.076.99 Z 378 395.64 (3A) 36.11% 0.00% 0.39% 0 L Lm SOURCE OF CAPITAL PONDS: DEPRECIATION POND BALANCE 7/1/13 TOWN OF READING, WASSACNUSSTTS NONICIPAL LIOBT DePARTI AECONCI LIATI OF CAPITAL FU PPNOS • 9/30/13 9/ L Lm SOURCE OF CAPITAL PONDS: DEPRECIATION POND BALANCE 7/1/13 3,635,305.70 CONBTRGCTION FUND SAWN CS 7/1/13 2,000,000.00 IETESSSS 0 DEPRECIATION PDND IT 13 2,765.51 DEPRECIATION TRANSISR IT 13 1.331,076.73 TOTAL SOURCE OF CAPITAL PONDS 5,059,027.96 OSS OF CAPITAL PONDS: LESS PAID ADDITIONS TO PLANT TBAO OCTOBER 2,197,266.00 GENERAL LEDGER CAPITAL PONDS BALANCE 10/31/13 3.662.561.96 IO TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARRNT SALES OF KILOWATT HOURB 9/30/13 /30 /12 SALES OF ELECTRICITY: MONTH LAST YEAR MONTH CURRENT YEAR LAST YEAR TO DATE CURRENT YEAR TO DATE YTD 6 CHANDP RESIDENTIAL SALES COMM. AND INDUSTRIAL SALES PRIVATE STREET LIGHTING 19,204,221 35,363,504 73,515 16,591,003 31,442,265 73,263 9),139,43) 152,036,997 391,463 98,024,733 150,183,420 192,550 1.736 -1.236 0.376 TOTAL PRIVATE CONSUMERS Sf .640.1{1 {8.101.531 149.{67.091 349.300.703 -0.076 MUNICIPAL SALES: STREET LIGHTING MUNICIPAL BUILDINGS 339,113 753,753 237,606 699,570 956,168 3,352,749 950,394 3,254,856 -0.626 -3.916 TOTAL MUNICIPAL CONSUMERS 991.965 9261176 K,309,017 4.205.240 -2.416 SALES FOR RESALE 370,035 193,350 1,36),1)9 1,331,570 -2.606 SCHOOL 1,231,607 1,0)0,)88 4,173,908 3,981,390 -4.596 TOTAL KILOWATT HOURS SOLD 5).133.)48 50 397,845 259.]1).001 258.810.903 -0.196 TOWN OF READING, HASSACHUSETT9 MUNICIPAL LIGHT DEPARTMENT KILOWATT HOURS SOLD BY TOWN 9/30/13 TOTAL HEADING LYH1JIIRLD NO.RE7UNINO WILNINMON MONTH RESIDENTIAL 16,591,003 5,387,541 2,]73,21] 3,997,139 4,944,095 COMM R IND 31,442,165 3,452,317 232,649 4,728,584 23,028,715 PVT ST LIGHTS 73,263 13,585 1,360 21,316 37,001 PUB ST LIGHTS 137,606 60,536 32,500 40,043 84,527 MMUC SLOGS 688,570 138,999 130,779 144,950 283,841 SALES /RESALE 193,350 193,350 0 0 0 SCHOOL 1,070,768 368,369 236,931 142,040 3]3,4]8 50.]97.845 9.634.7]3 2,897.441 9,064.071 28.701.609 TOTAL YEAR TO DATE RESIDENTIAL 98,824,733 30,442,396 14,569,]]4 23,183,082 30,630,031 COMM A in 150,183,420 18,501,256 1,145,356 23,268,999 107,267,809 PVT HE LIGHTS 291,550 54,340 5,440 85,204 147,566 PUB HE LIGHTS 950,384 312,144 119,960 160,171 338,108 MUNI BLOCS 3,254,856 721,671 582,607 696,582 1,353,995 SALES /RESALE 1,331,570 1,331,570 0 0 0 SCHOOL 3,901,390 11418,469 865,532 457,720 1,209,649 TOTAL 358.810.903 53,791.867 17,298.119 17.881.759 140.847.158 LAST YEAR TO DATE RESIDENTIAL 97,139,437 30,117,496 14,]]4,889 22,959,737 29,837,325 COMM R IND 153,036,997 19.120,695 1,214,776 13,516,318 108,185,008 PVT SS LIGHTS 291,463 56,314 5,440 84,940 144,759 PUB ST LIGHTS HUNT BLDOS 956,268 3,352,149 331,744 760,691 119,748 572,468 159,530 705,918 345,356 1,313,67]0 SALES /RESALE 1,367,179 4,171,908 1,367,179 1,519,523 0 945,654 0 515,840 1,191,891 SCHOOL TOTAL 159.317.001 5).36).851 17.092.915 47.943.363 14L017.911 KILOWATT HODAS SOLD TO TOTAL TOTAL READING LYNNPIELD NO.RBADING WILMINGTON MONTE 63.51% 16.96% 4.51% 9.40% 9.79% RESIDENTIAL 61.15% 6.03% 0.00% 9.04% 45.79% COMM A 0.03% 0.06% 0.04% 0.08% LIGHTS PVT ST LIGHTS 0.47% 0.16% 0.08% 0.17% PUB ST LISHT9 0.47% 0.38% 0.24% 0.24% 0.19% 0.% MUNI SLOGS 1.37% 0.38% 0.00% 0. 0.0000% SALES /3E6.U,E 0.38% 0.47% 0.384 38% 0.654 SCHOOL 3.131 0.73\ TOTAL 100.004 19.154 5.75% 18.01% 57.084 YEAR TO DATE R8SIDMIA1 38.18% 11.16% 5.63% 8.96% 11.83% 41.45% COMM R IND 58.03% 7.15% 0.44% 6.99% 0.06% PVT ST LIGHTS 0.11% 0.02% 0.00% 0.03% 0.06% 0.14% PUB ST LIGHTS 0.37% 0.12% 0.05% 0.17% 0.48% NUWI BLOGS 1.16% 0.18% 0.23% 0.00% 0.00% SALES /RESALE 0.51% 0.51% 0.00% 0.19% 0.47% SCHOOL 1.54% 0.55% 0.33% TOTAL 100.00% 10.394 6.68% 18.504 54.43\ LAST YEAR TO DATE WIND 37.63% 17.37% 5.49% 8.05% cam 6 IND 50.11% 7.37% 0.47% 9.07% 41.72% 41.06% PVT ST LIGHTS PVT 0.37% 0.12% 0.00% 0.06% 0.14% 0.14% PUB SS LIGHTS 0.29% 0.12% 0.05% 0.06% 0. MDNI BLDGS 1.19% 0.39% 0.12% 0.37% 0.00 0.00% 00% SALES /RESALE 0.53% 0.59% 0.00% 0.]0\ % 0.464 SCHOOL 1.61\ 0.59% 0.164 TOTAL 100.00% 30.534 18.484 54.40\ 161 TOW OF READINO, NASSACNOSETTS MUNICIPAL LICAT DEPARTNENP PORNOLA INCOME 9/30/11 TOTAL OPERATING REVENUES AOD: POLE RENTAL LESS: (P.3) 30,481,319.91 INTEREST INCOME ON CUSTOMER DEPOSITS OPERATING EXPENSES (P.3) CUSTOMER DEPOSIT INTEREST EXPENSE PORNULA INCOME (LOSS) 0.00 406.54 (18,000,844.10) (1,031.41) 3.4'19.859.94 u SALE OF RWH (P.51 RHB PURCHASED A" USE COST PER RHH AVE BASE SALE PER ENH AVE COST PER AM AVB SALE PER ENH FUEL CHARGE REVSHUR (P.3) LOAD FACTOR M TOWN OF READING, MASSACHUSETTS IHINICIPAL LIGHT DEPARTMENT GENERAL STATISTICS 9/30/12 HOME OF OCT 2011 57,123,748 55,392,262 0.037524 0.063762 0.090878 0.113725 2,852,952.53 77.82% 97,508 NOMH OF % CHAH HB YRAR THRO OCT 2012 2011 2012 OCT 2011 OCT 2012 50,297,045 -1.86% -0.19% 259,317,001 258,018,903 56,606,524 -2.10% 1.42% 260,444,723 264,152,924 0.039450 -3.35% 6.14% 0.035707 0.037984 0.065171 5.79% 0.04% 0.064602 0.064629 0.085299 -3.93% -4.31% 0.000763 0.004934 0.112671 1.15% -5.46% 0.110566 0.112089 2,369,147.98 -5.67% - 12.22% 13,993,802.42 12.283,719.39 81.14% 95.568 RH _^ I i 3 Z L 100 Zl d3S Zion zL lnr zt Nnr ZL AM a adv U atlW A 83d ZL Nvr 030 AON 100 d3S L 0nv LL lnr L Nnr AVW adv u avW 83d L L Nvr 0 L 030 0L AON OL 100 OL d3S of Onv o inr OL Nnr OL AM OL adv OL ay" OL 83d OL NVr 60 030 60 AON 60100 60 d3S U-) O Lo W lii O ^^ll W I� � N I O O O O O O 0 Eft Y> Efl ff} 6q (D m m �y 41-, 4-- �I* I I I I _^ I i 3 Z L 100 Zl d3S Zion zL lnr zt Nnr ZL AM a adv U atlW A 83d ZL Nvr 030 AON 100 d3S L 0nv LL lnr L Nnr AVW adv u avW 83d L L Nvr 0 L 030 0L AON OL 100 OL d3S of Onv o inr OL Nnr OL AM OL adv OL ay" OL 83d OL NVr 60 030 60 AON 60100 60 d3S U-) O Lo O lii O co I� � N T- O O O O O O Eft Y> Efl ff} 6q 0 .J 2 TOW OF READING, NASSACHOSETTS NUNICIPAL LIGHT DEPARPRENT SCHEDULE OF CASH AND INVESTMENTS 9/30/12 SCHEDULE A PRHVIOOS YEAR CURRENT YEAR UNRESTRICTED CASH CASH - OPERATING FORD 10,136,260 -28 10,156,162.65 CASH - PETTY CASH 3,000.00 3,000.00 TOTAL UNRESTRICTED CASH 10,139.260.3E 10.161,162.65 RESTRICTED CASH CASH - DEPRECIATION PUNT 4,302,803.25 0.00 3,662,561.96 11000,000.00 CASH - TOW PATMENT 1,192,000.00 200,000.00 1,311,142.00 0.00 CASH - DEFERRED FUEL RESERVE 3.016,258.63 0.0E 1,950,019.84 DTD 09/10/101 CASH - RATE STABILIZATION FORD 5,059,433.61 • FREDDIE MAC 6,684,760.87 / CASH - UNCOLLECTIBLB ACCTS RESERVE 300,000.00 MATTEM 09/15/20 300,000.00 200,000.001 CASH - SIM LEAVE BENEFITS 1,946,177.34 2,905,384.73 CASH - HAZARD WASTE RESERVE 150,000.00 150,000.00 CASH - CUSTONER DEPOSITS 565.723.27 636,420.43 CASH - ENERGY CONSERVATION 139,384.57 375,703.93 CASH - DIED 972,318.10 1,345,954.38 TOTAL RESTRICTED CASH 1>. 563.997.77 19.204.956.13 RESTRICTED INVESTRENTR RATE STABILIZATION 1,000,000.00 0.00 SICK LEAVE BENEFITS 11000,000.00 0.00 ••• OPSB 200,000.00 0.00 TOTAL RESTRICTED INVESTMNNTS 2.200.000.00 PREDDIE MAC 0.0E TOTAL CASH BALANCE 39.903.358.05 29.366.118.78 OCT 3011 PREDDIE MAC 1,000,000.001 DTD 09/10/101 INT 2.00 %1 MATURITY 09/15/20 • FREDDIE MAC 1,000,000.00 / DTD 09/10/101 IM 2.00 %, MATTEM 09/15/20 ••• FREDDIE MAC 200,000.001 DTD 09/10/101 INT 2.00%1 MATURITY 09/15/20 191 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPART1WNWY SCHEDULE OF ACCOUNTS RECEIVABLE 9/30/11 SCHEDULE OF PREPAYMENTS PREPAID INSURANCE 531,446.51 PREPAYMENT PORCNAHSD PONBR (3.186.38) PREPATICENT PASRy 138,330.65 PREPAYMENT WATSON 214,570.71 PURCHASED POWER WORKING CAPITAL 14.513.70 TOTAL PREPAYMENT 996.685.10 ACCOUNTS RECEIVABLE ACING OCTOBER 1013 RESIDENTIAL AND COMMERCIAL PREVIOUS YEAR SCHEDULE OF ACCOUNTS RECEIVABLE RESIDENTIAL AND COMMERCIAL 3,950,161.04 1,466,5]0.0] ACCOUNTS RECEIVABLE - OTHER 101,715.33 ACCOUNTS RECEIVABLE - LIENS 14,579.16 (129,595.81) ACCOUNTS RECEIVABLE - E LOYEE ADVANCES 891.14 SALES DISCOUNT LIABILITY (317,843.67) 2,]36.9]4.21 RESERVE FOR =COLLECTIBLE ACCOUNTS (267.641.41) TOTAL ACCOUNTS RECEIVABLE BILLED 3,481,971.39 1,709,909.98 UNBILLED ACCOUNTS RECEIVABLE 4,830,294.37 TOTAL ACCOUNTS RECEIVABLE, NET 0 31�� ]66 7®x6 SCHEDULE OF PREPAYMENTS PREPAID INSURANCE 531,446.51 PREPAYMENT PORCNAHSD PONBR (3.186.38) PREPATICENT PASRy 138,330.65 PREPAYMENT WATSON 214,570.71 PURCHASED POWER WORKING CAPITAL 14.513.70 TOTAL PREPAYMENT 996.685.10 ACCOUNTS RECEIVABLE ACING OCTOBER 1013 RESIDENTIAL AND COMMERCIAL LESS: SALES DISCOUNT LIABILITY 1,466,5]0.0] GENERAL LEDGER BALANCE (129,595.81) 2,]36.9]4.21 CONSENT 1,709,909.98 80.02% 30 DAYS 314,495.09 16.06% 60 DAYS 47,961.76 2.14% 90 DAYS 16,967.40 0.76% OVER 90 DAYS 67.589 90 3.02% TOTAL ] ]3924,01 300.00% U., SCHEDULE B CURRENT YEAR 2,466,520.02 471,861.86 13,583.91 89].14 (229,595.811 ]36,773.611 1,496,488.51 4,915,936.83 7.41].415.34 641,141.7] 73,594.]9 ]41,849.31 345,413.96 14,5]3.70 1,]16.51].99 C TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REVENUE 9/30/13 SCHEDULE D MUNICIPAL SALES: MONTH MONTH LAST YEAR CURRENT YEAR YTD % SALES OF ELECTRICITY LAST YEAR STREET LIGHIINO CDRAENT YEAR TO DATE 37,917.05 TO DATE 136,314.37 CHANGE RESIDENTIAL SALES 1,469,306.13 - 18.08% ],097,1]4.39 MUNICIPAL BUILDINGS 1],81],646.93 1],347,5]1.86 4.67% DOW AND INDUSTRIAL SALES 3.732,581.76 3,313,]4].89 16,695,386.17 119.263.50 15,557,137.08 106.845.64 -6.82% PRIVATE STREET LIGHTING 5,907.]] 483.300.13 5,707.37 - 11.24% 29.149.46 DAN REVENUE ]],778.04 - 31.86% TOTAL PRIVATE CONSUMERS 6.20].]95.16 5.416.124.65 SALES FOR RISALE ]9 541,18].56 37.927.487.98 (45,133.69) -5.47% MUNICIPAL SALES: 6,496,403.39 5,667,116.28 30,746,193.46 39,010,801.53 -5.64% STREET LIGHIINO ]9,]38.94 37,917.05 136,314.37 111,662.20 - 18.08% MUNICIPAL BUILDINGS 90,023.56 80,938.79 407,180.55 370,637.93 -8.97% TOTAL MUNICIPAL CONSUMERS 119.263.50 106.845.64 543.494.9] 483.300.13 - 11.24% DAN REVENUE 57,073.70 50,311.27 259,294.41 258,658.69 SALES FOR RISALE 32,156.57 22,496.25 (45,133.69) 168,373.04 (48,781.28) 154,747.61 (235,495.98) -8.04% (201,732.70 SCHOOL 137,189.16 119,649.54 493,343.94 446,265.81 -9.34% 60 SUB -TOTAL 6,496,403.39 5,667,116.28 30,746,193.46 39,010,801.53 -5.64% FORFEITED DISCOUNTS 73,658.53 96,307.74 331,587.73 375,197.21 13.15% PURCRASED POWER CAPACITY (10,841.98) 152,401.19 (49,160.34) 783,578.33 - 1690.69% ENERGY CONSERVATION - RESIDENTIAL ENERGY CONSERVATION - COMMERCIAL 19,208.94 36,979.71 16,605.36 33,917.33 73,760.93 121,887.06 98,870.89 155,956.13 34.04% 37.95% DAN REVENUE 57,073.70 50,311.27 259,294.41 258,658.69 -0.25% NTPA CREDIT (45,133.69) (48,781.28) (235,495.98) (201,732.70 - 14.34% TOTAL REVENUE -2.45% 6.626.348.59 5.966.87].88 31.247.96].]6 30.481.329.91 TOM OF RBADIRG, HA66ACHU58TT8 MONLCIPAL LIOHi DBPARTNENT SCHEDULE OF 0P8MTIN0 RHVRRpB BY TORN 9/30/12 MONTH TOTAL READING LYMFIELD TOTAL NO.READING NILNINGTON RESIDENTIAL INDUS /NDEI BLOO PUB.ST.LIGNT6 PRV.ST.LIGNTS CO -OP RESALE SCHOOL ],09],174.39 3,394,171.68 37,917.05 5,707.37 32,496.25 119,649.54 RESIDENTIAL INDUS /NUNS BLDG PUB.ST.LIGMB PRV.ST RESALE SCHOOL RESALE SCHOOL 683,232.92 417,012.61 6,976.30 1,041.47 22,496.25 42,043.59 12.06% 7.36! 0.16% 0.02% 0.40\ 0.)4\ 285,859.63 40,647.25 3,551.79 104.25 0.00 26,135.05 8.07% 9.10% 0.091 0.03% 0.00% 0.28% 503,575.05 533,703.68 5,229.50 1,731.62 0.00 16,093.39 6]5,506.)9 2,403,808.14 10,159.46 3,840.03 0.00 35,377.52 TOTAL 30.)46.193.46 TOTAL 6.699.33039 . 30.741 ] 1113.255.89 18.6)% 5 843.890.56 THIS YEAR TO DATE 15 989 )16.62 TOTAL _ 166).116.]8 1. D4. 801.11 RESIDENTIAL INDUST.LIII BLDG PUB.BT.LIGHT9 PRV.ST RESALE CO -OP RHBALE SCHOOL 356.297.97 13.164 7,35! 0.11% 0.01! 0.55% 0.55{ _1058.323.]4 9.97% 8.814 0.07% 0.02! 0.00% 0.19! ,_07),691.94 THIS YEAR TO DATE TOTAL 100.00\ 21.7]4 7.39! _ 19. pfi! 51.91\ RESIDENTIAL INDUS /NUNI BLDG PUB.ST.LIGNTS PRV.ST.LZGHTS CO -OP RESALE SCHOOL 12,347,572.86 15,9]),775.01 111,663.20 22,778.04 154,747.61 446,365.81 3,817,)0).36 2,133,150.43 35,905.20 4,173.48 154,747.61 160,8]5.16 1,810,335.10 194,983.33 14,201.16 417.00 000 96,083.89 . ],893,065.]9 3,554,743.28 20,918.00 61881.21 0.00 56,345.84 12.95% ).54% 0.14% 0.03t o.sst 0.59% 3,836,565.11 11,044,097.98 40,637.84 11,306 6.00 133,010.93 .35 12.83% 38.51! 0.1) 0.05 0.004. 0.45% TOTAL 100.00% ]1.799 7.19% TOTAL 39.010.801.53 _ 6,306.509.]4 1]311 1.115.920.45 5.531.953.6) 15,056,418.31 LAST YEAR TO DATE RESIDENTIAL. INDUS /NUNI BLDG PUB.ST.LIOMB PRV.ST.LIGMe CO -OP RESALE SCHOOL 12,817,646.93 17,102,566.)] 136,314.37 29,149.46 168,273.04 493,242.94 3,981,107.08 3,319,305.44 44,524.29 5,500.80 168,273.04 180,719.74 1,873,731.68 211,779.72 16,851.13 535.10 0.00 109,358.36 TOTAL 3,018,744.49 2,719,663.19 34,005.74 8,937.00 0.00 63,540.14 LYNNPIELD 3,944,063.68 11,840,918.37 50,933.21 14,176.56 0.00 139,6]4.80 NILMZNOTON RESIDENTIAL INDUS /NUNS BLDG PUB.ST.LIGMB PRV.ST RESALE SCHOOL RESALE SCHOOL 37.01% 59.89% 0.19% 0.40% 0.90! ].11\ 12.06% 7.36! 0.16% 0.02% 0.40\ 0.)4\ 5.04% 0')2% 0.00% 0.00! 0.00% 0.16! 8.07% 9.10% 0.091 0.03% 0.00% 0.28% 11.01% 4].Q\ 0.05% 0.05% 0.00% 0.634 TOTAL 30.)46.193.46 TOTAL 6.699.33039 . 30.741 ] 1113.255.89 18.6)% 5 843.890.56 THIS YEAR TO DATE 15 989 )16.62 PERCENTAGE OF OPERATING INCONB TO TOTAL NONTN TOTAL READING LYNNPIELD NO.RKADING NILMZNOTON RESIDENTIAL INDUS /NUNS BLDG PUB.ST.LIGMB PRV.ST RESALE SCHOOL RESALE SCHOOL 37.01% 59.89% 0.19% 0.40% 0.90! ].11\ 12.06% 7.36! 0.16% 0.02% 0.40\ 0.)4\ 5.04% 0')2% 0.00% 0.00! 0.00% 0.16! 8.07% 9.10% 0.091 0.03% 0.00% 0.28% 11.01% 4].Q\ 0.05% 0.05% 0.00% 0.634 TOTAL 100.004 30.741 6.28\ 18.6)% 59.311 THIS YEAR TO DATE RESIDENTIAL INDUST.LIII BLDG PUB.BT.LIGHT9 PRV.ST RESALE CO -OP RHBALE SCHOOL 42.56% 54.901 0.38% 0.08% 0.531 1.559 13.164 7,35! 0.11% 0.01! 0.55% 0.55{ 6.]1\ 0.05% 0.05! 0'00% 0.00% 0.33% 9.97% 8.814 0.07% 0.02! 0.00% 0.19! 11.19% 38.07% 0.14% 0.05\ 0.00! 0.48! TOTAL 100.00\ 21.7]4 7.39! _ 19. pfi! 51.91\ LAST YEAR TO DATE RESIDENTIAL INDUS /NUNS BLDG PUB.ST.LIGMB PRV.ST.LIGMB CO -OP RESALE SCHOOL 41.69% 55.62% 0 44! 0.10% 0.55% 1.60% 12.95% ).54% 0.14% 0.03t o.sst 0.59% 6.09! 0.69% 0.05% 0.00% a.ao\ 0.36% 9.83! 8.88% O.OBt 0'031 O.00! 0.20% 12.83% 38.51! 0.1) 0.05 0.004. 0.45% TOTAL 100.00% ]1.799 7.19% 19.034 5].01% 1]311 • ( ) . ACTUAL UNDER BUDGET or 11101 TOWN OF RB ING, MASSACHUSETTS MUNICIPAL LIGHT MUNIC REV6NUE VARIANCE VARIANCE BUDGETED REPORT 9/30/13 SCHEDULE E ACEOAL BUDGET YEAR TO DATE YEAR TO DATE VARIANCE • CHANGE SALES OF ELECTRICITY: RESIDENTIAL 9,653,615.94 1,569,221.00 (115,605.26) -2.94% COMM AND INDUSTRIAL SALES PRIVATE STREET LIGHTING 8,656,300.00 8,991,984.00 (313,484.00) -3.49% MUNICIPAL BUILDINGS PUBLIC STREET LIGHTING 66,518.70 69,540.00 (1,011.30) -1.51% SALES FOR RESALE 91,499.92 110,939.00 (19,441.08) - 19.52% SCHOOL 259.149.98 292,606.00 (15.456.22) -5.69% TOTAL EASE SALES 16,729,083.14 19.292.090.00 (565,009.86) -3.19% TOTAL FUEL SALES 12.283.919.39 11,585.043.00 698,676.39 6.03% ® TOTAL OPERATING REVEEDE 29,010,801.53 28,099,133.00 133.668.53 0.46% FORFEITED DISCOUNTS 395,199.22 360,425.00 (5,229.98) -1.39% PURCHASED POWER CAPACITY 983,598.23 992,610.00 (9,031.99) -1.14% ENERGY CONSERVATION - RESIDENTIAL 98,890.89 98,014.00 856.89 0.89% ENERGY CONSERVATION - COMMERCIAL 155,956.13 163,638.00 (9.681.89) .4.69% GAN REVENUE 258,658.69 261,652.00 (2,993.31) -1.14% PARRY CREDIT (201,932.98) (233,332.00) 31,599.22 - 13.54% TOTAL OPERATING REVENUES 0.49% 30.481,329.91 30.340.140.00 141,169.91 • ( ) . ACTUAL UNDER BUDGET or 11101 TORN OF READING, HASSACHUSETTS MUNICIPAL LIGHT DEPARTEEBT SCHEDULE OF OPERATING EXPENSES 9/30/13 SCHEDULE E io OPERATION EXPENSES: NORTH LAST YEAR DUMB[ CURRENT LAST YEAR CURRENT YEAR YTD % 3.19% MAINE OF TRAN8MI89ION PLANT IRAN TO DATE TO DATE CHANSON PURCHASED POKER BASE ¢YPBN9R 2,078,533.97 MAIST OF STRUCT AND EGUIPRT 2,233,116.17 9.310.60] 36 908.40 908.40 0.00% SAINT OF LINES - 19 134,339.31 134,]33.5] 10.033.531.96 7.65% OPERATION SUP AND ENGINEERING SIT 41,995.30 SAINT OF LINES - UG 66,593.71 174,038.90 186,135.01 484,217.53 STATION SOP LABOR AND RISC 11,983.39 SAINT OP LINE TRANSFORMERS 13,956.59 45,183.18 72,793.19 6.95% LIM RISC LABOR AND EXPENSE 61,150.44 NAINT OF 8T IT 6 BIG 9YSTEC 79,054.60 1,535.48 29,744.06 - 34.17% STATION LABOR AND EXPENSE 37,674.31 MAINT OF SAILORS AND STOCYROON (51.77) 46,345.75 129,014.58 111,993.96 -7.43% STREET LIGHTING EXPENSE 9,417.35 MAINT OP METERS 77,365.14 157,962.18 186,724.91 18.21% NETER EXPENSE NAINT OF DEN PLANT 6,834.17 33,358.10 14,361.69 - 26.97% - 45.79% 21,576.61 31,412.73 65,022.04 66,515.09 - 21.76% RISC DISTRIBUTION EXPENSE 25,116.83 TOTAL NAINTE9ANCB EXPENSES 41,385.07 91 108,979.89 O1 115,344.01 5.84% MIRE READING LABOR 6 EXPENSE 6,813.52 8,113.39 33,310.10 32,093.41 51 4.65% 33 ACCT R COLL LABOR A EXPENSE 87,335.05 178,107.71 39],]81.95 514,290.14 UNCOLLECTISLE ACCOUNTS 16,000.00 8,333.33 64,000.00 33,333.31 19.29% ENERGY AUDIT EXPENSE 33,341.23 60,363.24 139,914.21 156,109.10 - 47.92% ADMIS 6 on SALARIES 57,750.68 89,514.45 143,307.65 154,951.94 11.65% 4.79% OFFICE SUPPLIER 6 EXPENSE 36,698.17 11,721.94 69,143.39 61,788.54 OUTSIDE SERVICES 46,913.11 44,881.09 115,188.21 124,613.17 - 10.64% PROPERTY INSURANCE 31,]78.]1 31,925.41 117,150.88 116,960.60 8.36% INJURIES AND DAMAGES 718.57 51005.55 (6,827.06) -0.15% RNPIOYEES PENSIONS 6 BENEFITS 111,011.63 139,740.66 534,940.81 15,311.99 - 324.43% MISO GENERAL ASPERSE 7,599.41 10,345.81 680,714.72 27.15% RENT EXPENSE 636.37 55,204.83 48,960.68 - 11.31% ENERGY CONSERVATION 31,950.00 13,774.20 55,863.87 76,113.08 36.15% 41,245.94 102,813.04 169,184.11 - 16.53% TOTAL OPERATION EXPENSES R]]_aet NAINTERANCR EXPENSES: 296,027.47 305,469.18 11184,109.88 1,221,876.72 3.19% MAINE OF TRAN8MI89ION PLANT 337.10 217.10 13,797,272.59 12,402,011.25 - 10.11% MAIST OF STRUCT AND EGUIPRT 16,300.88 13,850.99 908.40 908.40 0.00% SAINT OF LINES - 19 134,339.31 134,]33.5] 64,690.34 45,548.55 - 19.59% SAINT OF LINES - UG 15,946.71 537,105.75 484,217.53 -8.14% SAINT OP LINE TRANSFORMERS 7,599.63 4,]73.5] 72,793.19 18,845.31 - 60.37% NAINT OF 8T IT 6 BIG 9YSTEC 1,535.48 14,013.60 11,919.07 - 50.39% MAINT OF SAILORS AND STOCYROON (51.77) 46,345.75 18.13 35,133.87 (136.74) (303.33) - 14.54% MAINT OP METERS 171,514.15 150,174.77 - 12.45% NAINT OF DEN PLANT 8,159.64 6,517.82 5,418.36 38,741.17 15,579.04 - 45.79% ],13].95 39,086.65 34,867.17 19.97% TOTAL NAINTE9ANCB EXPENSES 135.294 91 31J.038 O1 918 636 51 771.858 33 - 15.98% DEPRECIATION EXPENSE 296,027.47 305,469.18 11184,109.88 1,221,876.72 3.19% PURCRABSD POWER FUEL EXPENSE 2,955,398.39 2,595,375.45 13,797,272.59 12,402,011.25 - 10.11% VOLUNTARY PAYNTNTS TO TOMES 113,000.00 114.000.00 452,000.00 456,000.00 0.88% TOTAL OPERATING EXPENSES 6 ]55.916.50 6 521.693.6E 28.5]].878.89 3B 000.816.10 -1.68% Ll 1111 ( 1 • ACTUAL UNDER BUDGET 1 i2.1 TONE OF READING, MASSACHOSRTTS MUNICIPAL LIGHT DEPARTMENT BUDGETED OPERATING EXPRESS VARIANCE REPORT 9/30/13 SCHEDULE O ACTUAL SUDOBT OPERATION EXPENSES: YEAR TO DATE YZAA TO DATE VARIANCE CHANGE PORCHASED PCN6R BASE EXPENSE 10,915.195.00 (881,662.04) -8.08% 10.0]).5]].96 OPERATION SUP AND ENGINEERING SEP 186,135.01 155,909.00 30,1]6.0] 19.39% STATION SUP LABOR AND MISC 29,744.06 27,487.00 3,357.06 8.21% LING MISC LABOR AND EXPENSE 311,993.96 317,462.00 (5,466.04) -2.51% STATION LABOR AND EXPRESS 186,724.93 146,431.00 40,292.92 27.52% STREET LIGHTING EXPENSE 34,361.69 27,615.00 (3,152.31) - 11.78% EATER EXPENSE 66,525.09 46,666.00 19,859.09 42.56% MISC DISTRIBUTION EXPRESS 115,344.01 119,564.00 (4,219.99) -3.53% M IER READING LABOR 6 EXPENSE 31,093.41 33,889.00 (1,795.59) -5.30% ACCT 8 COLL LABOR R EXPENSE 514,29D.24 447,259.00 67,031.24 14.99% UNCOLLECTIBLE ACCOUNTS 33,333.32 33,332.00 1.32 0.00% ENERGY AUDIT BXPRNSE 156,109.10 154,411.00 1,688.20 1.09% AUNTS c GEN SALARIES 354,951.94 147,791.00 7,160.94 2.69% OFFICE SUPPLIES 6 EXPENSE 61,788.54 84,776.00 (]],989.46) - 37.12% OUTSIDE SERVICES 124,813.17 261,776.00 (137,962.83) - 52.50% PROPERTY INSURANCE 126,960.68 157,172.00 (30,211.32) - 19.22% INJURIES AND DAMAGES 15,321.99 19,197.00 (3,875.01) - 20.19% ENFLOYBRS PENSIONS 6 BENEFITS 680,714.73 661,904.00 18,810.72 3.84% MISC GENERAL EXPENSE 48,960.68 97,329.00 (48,368.32) - 49.70% RENT EXPENSE 76,113.08 70,668.00 5,445.08 7.71% ENERGY CONSERVATION 169,304.12 238,657.00 (69,372.88) - 29.07% TOTAL OPERATION EXPENSES 3.250.308.00 (134.743.16) -4.15% 3,115.564.84 MAINTENANCE EXPENSES: MAINT OF TRANSMISSION PLANT 908.40 1,000.00 (91.60) -9.16% MAINT OF STRUCT AND BDUIPMEET 45,548.55 41,157.00 4,391.55 10.67% MAINT OF LINES - ON 484,217.53 397,330.00 86,887.53 21.87% NAINT OF LINES - UG 28,845.]] 55,]]3.00 (36,377.78) - 47.77% NAINT OF LINE TRANSFORMERS 11,919.07 77,828.00 (65,908.93) - 84.69% MAINT OF ST LT 6 SIG SYSTEM (202.32) 3,104.00 (3,406.32) - 106.31% MAINT OF GARAGE AND STOCXROOM 150,174.77 219,418.00 (69,243.13) - 31.56% SAINT OF MBTBRS 15,579.84 24,629.00 (91049.16) - 36.74% MAINT OF ME PLANT 34,867.27 43,704.00 (8,836.73) - 20.21% TOTAL MAINTENANCE EXPENSES 771.858.33 863. 493.00 (91, 634.67) - 10.61% DEPRECIATION EXPRESS 1,221,876.72 1,116,668.00 5,308.71 0.43% PORCHASED POWER FUEL EXPENSE 11,402,011.35 11,706,791.00 695,320.25 5.94% VOLUNTARY PAYNENTS TO TOWNS 456,000.00 4561000.00 0.00 0.00% TOTAL OPERATING EXPENSES -1.43% (407,610.901 38.408.455.00 38.000.844.30 ( 1 • ACTUAL UNDER BUDGET 1 i2.1 TORN OF READING, MASSACHUSETTS MBNICIPAL LIGHT OEPARTHBNP BUDGETED OPERATING EXPENSE VARIANCE REPORT 9/30/13 i RESPONSIBLE 468,949.00 REMAINING SENIOR OPERATION EXPENSES: MANAGER 2013 ANNUAL BUDGET ACTUAL YEAR TO DATE BUDGET REMAINING 79,813.00 29,744.06 BALANCE BUDGET % PURCHASED pawn BABE EXPENSE GP 63.73% BY 671,309.00 30.102.]{].00 10.033.532.96 459,315.04 68.42% 20.069.309.0{ 66.67% OPERATION BUY AND ENGINEERING EST STATION SOP LABOR AND MISC LINE MISC LABOR AND EXPENSE STATION LABOR AND EXPENSE STREET LIGETING EXPENSE 6RTER EXPENSE RISC DISTRIBUTION EXPENSE METER READING LABOR R EXPENSE ACCT R COLL LABOR 6 EXPENSE UNCOLLECTIBLE ACCOUNTS ENERGY AUDIT EXPENSE ROME R GSN SALARIES OFFICE SUPPLIES R EXPENSE OUTSIDE SERVICES PROPERTY INSURANCE INSURIES AND DAMAGES EMPLOYEES PENSIONS F BENEFITS MISC GENERAL EXPENSE RENT EXPENSE ENERGY CONSERVATION TOTAL OPERATION EXPENSES MAINTENANCE EXPENSES MAINT OF TRANSMISSION PLANT MAINT OF STRUCT AND EQUIPNI MAIM OF LINES - ON MAINT OF LINES - OG HAIM OF LINE TRANSFORMERS MAINI OF ST IT A SIG SYSTEM SAINT OF GARAGE AND STOCKROOM MAINT OF METERS MAINT OF OEN PLANT TOTAL MAINTENANCE EXPENSES DEPRECIATION EXPENSE PURCASED POWER FUEL EXPENSE VOLUNTARY PAYMENTS TO TONES TOTAL OPERATING EXPENSES NE 468,949.00 286,135.02 283,813.98 60.31% XS 79,813.00 29,744.06 501068.94 63.73% BY 671,309.00 211,993.96 459,315.04 68.42% KS 448,249.00 186,724.92 361,524.08 59.34% KS 83,106.00 34,362.69 56,743.31 70.68% X8 197,329.00 66,525.09 130,803.91 66.29% XS 366,489.00 115,344.01 251,144.99 68.53% R8 69,946.00 32,093.41 37,852.59 54.13% RP 1,385,210.00 514,290.24 8]0,919.)6 62.87% RB 100,000.00 33,333.33 66,666.68 66.67% Sp 479,013.00 156,109.20 322,903.80 67.41% VC 761,068.00 254,951.94 506,116.06 66.50% VC 253,950.00 61,788.54 192,161.46 75.67% VC 507,135.00 134,813.17 382,311.83 75.39% RE 471,500.00 126,960.68 344,539.32 73.07% KS 56,619.00 15,321.99 41,397.01 72.94% KS 1,089,623.00 680,)14.)2 11308,908.38 63.98% VC 200,785.00 48,960.68 151,824.32 75.62% KS 312,000.00 76,113.08 135,086.92 64.20% IF 697,983.00 169,384.13 530,698.89 )5.]5% 8.823.105.00 ).335.564 B4 6.384.501.16 71.33% RS 31000.00 908.40 2,091.60 69.72% RS 114,120.00 45,548.55 60,571.45 60.09% KS 1,250,421.00 484,217.53 )66,303.4] 61.28% XS 385,371.00 28,845.33 256,535.78 89.89% XS 188,500.00 11,919.07 176,580.93 93.68% XS 9,684.00 (202.32) 9,986.32 103.09% KS 672,589.00 150,174.77 522,414.23 77.67% RE 47,393.00 15,579.84 31,812.16 67.13% RF 131,330.00 34,86].3] 96,452.73 73.45% 2.81].401 00 ))1.858.33 1.930.538.67 68.52% BY 3,650,000.00 1,231,876.72 3,438,133.38 66.52% UP 30,500,000.00 12,402,011.35 16,097,990.75 59.34% RP 1,36B4O00.00 456,000.00 913,000.00 66.67% 8383 )6� +.500.00 3838 00��e.844.10 49,)23,360.90 59.36% uvn jr TORN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT PROFESSIONAL SERVICES 10/31/101] PROFESSIONAL SERVICES BY PROJECT PROFESSIONAL SERVICES BY VENDOR ITEM DEPARTMENT ACTUAL BUDGET NELANSON HEATH 6 COMPANY VARIANCE 1 RMLD AND PENSION TRUST AUDIT FEES ACCOUNTING 29,000.00 STONE CONSULTING INC. 33,250.00 (3,250.00) 15,901.46 ] PENSION ACTUARIAL EVALUATION ACCOUNTING 3,750.00 OUNCAS 6 ALLEN 0.00 3,750.00 39,493.39 3 LEGAL- FERC /ISO ISSUES ENERGY SERVICE 0.00 RICHARD HIGGINS ARBITRATOR 6,000.00 16,000.00) 1,732.50 4 LEGAL- POSER SUPPLY ISSUES ENERGY SERVICE 3,259.00 TOTAL 15,000.00 (13,741.00) 5 PROFESSIONAL SERVICES ENERGY SERVICE 2,895.80 81000.00 (5,104.30) 6 RISC COMPLIANCE AND AUDIT E 6 O 3,533.50 3,350.00 182.50 7 LOAD CAPACITY STUDY ENGINEERING 0.00 7,500.00 (7,500.00) 6 STRGM HARDENING STUDY ENGINEERING 0.00 50,000.00 (50,000.00) 9 LEGAL - GENERAL, MMMEC AUDIT ON 15,873.36 50,000.00 (34,137.64) 10 LEGAL SERVICES - GENERAL HR 40,505.33 30,600.00 91905.33 11 LEGAL SERVICES - NEGOTIATIONS ME 11698.06 18,400.00 (16,701.94) 13 LEGAL GENBRAL BLDG. MAINT. 9,125.90 500.00 8,625.90 13 SURVEY RIGHT OF NAY HIM. MAINT. 0.00 1,668.00 (1,666.00) 14 ENVIRONMENTAL BLDG. MAINT. 0.00 1,668.00 (11668.00) 15 ENGINEERING SERVICES BLDG. MAIN]. 14,110.05 2,040.00 11,378.05 16 REPAIR RAMP AND DECE AREA BLDG. SAINT. 0.00 30,000.00 (30,000.00) 17 INSURANCE CONSULTANT GEN. BENEFIT 0.00 3,333.00 (3,332.00) 18 LEGAL GEN. BENEFIT 0.00 11665.00 (1,668.00) 19 SITE ASSESSMENT FOR MAJOR UPGRADE ACCOUNTING ],056.37 0.00 3,056.27 TOTAL 134,013.17134,813.17 363,776.00�137�9fi ].5]1].5]1 PROFESSIONAL SERVICES BY VENDOR ACTUAL NELANSON HEATH 6 COMPANY 39.000.00 HUDSON RIVER ENERGY GROUP 31895.80 STONE CONSULTING INC. 3,750.00 RUBIN AND HUMAN 15,901.46 UTILITY SERVICES INC. 3,532.50 OUNCAS 6 ALLEN 11,355.8D CROATS HALL R STEWART 39,493.39 MERGERS TORREY R SPENCER 13,355.55 RICHARD HIGGINS ARBITRATOR 3,710.00 JM ASSOCIATES 1,732.50 COGSDALE 2,056.27 TOTAL 1]4,813.17 (13) DATE Sun -12 Jul -12 Aug -12 Sap -12 Oct -12 RMLD DEFERRED PURL CASH RESERVE ANALYSIS 09/30/12 GROSS MONTHLY CHARGES REVENUES NYPA CREDIT DEFERRED 3,501,715.28 A9 3,492,843.61 (61,106.90) (149,978.57) 3,578,611.20 2,914,978.35 (44,365.00) (707,998.65) 2,646,309.32 3,486,749.45 (47,478.80) 792,961.33 2,595,375.45 2,389,147.98 (48,781.28) (255,008.75) 2,270,044.48 2,120,065.91 1,412,067.26 2,205,028.59 1,950,019.84 M A9 TOTAL DEFERRED 2,270,044.48 2,120,065.91 1,412,067.26 2,205,028.59 1,950,019.84 M m DIVISION ENGINEERING AND OPERATIONS ENERGY SERVICES GENERAL MANAGER FACILITY MANAGER BUSINESS DIVISION SUB -TOTAL RMLD BUDGET VARIANCE REPORT FOR PERIOD ENDING OCTOBER 31, 2012 ACTUAL BUDGET VARIANCE 1,371,323 1,384,060 (12,737) 331,683 422,247 (90,563) 263,755 332,601 (68,847) 1,231,956 1,323,863 (91,907) 3,122,728 3,079,698 43,030 (407,466) -1.409 6,321,445 6,542,469 (221,024) CHANGE -0.92% - 21.459 - 20.70% -6.949 1.409 -3.389 PURCHASED POWER - BASE 10,033,533 10,915,195 (881,662) -8.089 PURCHASED POWER - FUEL 12,402,011 11,706,791 695,220 5.949 TOTAL 28,756,989 29,164,455 (407,466) -1.409 • 11 part time employee 'a part time employee and a coop student '^ part time employee and a temp RMLD STAFFING REPORT FOR FISCAL YEAR ENDING JUNE, 2013 13 BUD JUL AUG SEP OCT TOTAL 12 12 12 12 G,ENZEAL_MHNBS#EB GENERAL MANAGER 2.00 2.00 2.00 2.00 2.00 HUMAN RESOURCES 1.00 1.00 1.00 1.00 1.00 COMMUNITY RELATIONS 1.00 1.00 1.00 1.00 1.00 TOTAL 4.00 4.00 4.00 4.00 4.00 BUSINESS ACCOUNTING 2.00 2.00 2.00 2.00 2.00 CUSTOMER SERVICE •* 7.75 7.75 7.75 7.75 7.75 MGMT INFORMATION SYS • 6.25 6.00 6.00 6.00 6.00 MISCELLANEOUS 1.00 1.00 1.00 1.00 1.00 TOTAL 17.00 16.75 16.75 16.75 16.75 ENGINEERING c OPE ATIONB AGM E60 2.00 2.00 1.00 1.00 1.00 ENGINEERING 5.00 5.00 5.00 5.00 5.00 LINE 21.00 21.00 21.00 21.00 21.00 METER 4.00 3.00 3.00 3.00 3.00 STATION 8.00 8.00 8.00 8.00 8.00 TOTAL 40.00 39.00 38.00 38.00 38.00 PROJECT BUILDING 2.00 2.00 2.00 2.00 2.00 GENERAL BENEFITS 2.00 1.00 2.00 2.00 2.00 TRANSPORTATION _ MATERIALS MGMT 4.00 3.00 4.00 4.00 4.00 TOTAL 8.00 6.00 8.00 8.00 8.00 ZHERGY SERVIM ENERGY SERVICES • 5.50 4.50 4.50 4.50 4.50 TOTAL 5.50 4.50 4.50 4.50 4.50 RMLD TOTAL 74.50 70.25 71.25 71.25 71.25 CONTRACTORS UG LINE 2.00 2.00 2.00 2.00 2.00 TOTAL 2.00 2.00 2.00 2.00 2.00 GRAND TOTAL 76.50 72.25 73.25 73.25 73.25 part time employee 'a part time employee and a coop student '^ part time employee and a temp RMLD CO) 40 u Reading Municipal Light Department RELIABLE POWER FOR GENERATIONS 230 Ash Street P.O. Box 150 Reading, MA 01867 -0250 Tel: (781) 944-1340 FAA: (791) 942-2409 Web: www.tmld.com November 16, 2012 Town of Reading Municipal Light Board Subject: 750 MCM Cable On October 17, 2012 a bid invitation was placed as a legal notice in the Reading Chronicle requesting proposals for 750 MCM Cable for the Reading Municipal Light Department. Specifications were emailed to the following: The Okonite Company WESCO Yale Electrical Supply Graybar Electric Arthur Hurley Company Hasgo Power Shamrock Power Pirelli Cables & Systems Power Sales Group HD Supply, Inc. Hendrix Wire & Cable Corp Champion Wire & Cable Anixter Wire & Cable Yusen Assoc HD Supply Utilities MetroWest Electric Sales Power Tech - UPSC E.L. Flowers General Cable USA Power Cable Robinson Sales Eupen Cable Power & Telephone Enterprise Bids were received from Irby, Hasgo Power, Arthur Hurley Company, Yale Electric, The Okonite Company and WESCO. The bids were publicly opened and read aloud at 11:00 a.m. November 8, 2012 in the Town of Reading Municipal Light Department's Board Room, 230 Ash Street, Reading, Massachusetts. The bids were reviewed, analyzed and evaluated by the General Manager and the staff. Move that bid 2013 -07 for 750 MCM be awarded to: Yale Electric East LLC for a total cost of $117,873.75 Item Quantity Description Total Cost 1 6,375' 750 MCM CU 15 kV concentric neutral power cable $117,873.75 as the lowest qualified bidder on the recommendation of the General Manager. File: Bid /FY13/ Cable /2013 -07 ATTACHMENT 6 RMLDCO) Rf ad;nq Municipal Light Department aceeotvcal Li cexua— 230 AA So-et, P.O. Box 150 Reading,MA01867 -0250 The Capital budget allocation for the purchase of the underground cable for the Station 4 Getaway Replacement - 4W13 Reading project was estimated at $102,000. When the project was originally estimated there were 3 reels of 750 MCM CU in stock for this project. These reels have since been used, hence the need for an additional 1275' over the 5100' that was detailed in the Capital Project description. File: Bid /FY13/ Cable /2013 -07 s v D � (§ ) k \ / j ` \(k\) ( §% \{ ))\ \k £I!2| / k / )! \!k \ !! k)\ ! §w ) & ■ EE k � 2 /),,,l. `! } \ ® / e �§ � {))rlE -E 1/ 2 � ®j , w | | | i\ ) §!; kkkr!!!! ;!a! ) k \ / j ` \(k\) ( §% \{ ))\ \k £I!2| / k / )! \!k \ !! k)\ ! §w ) m RMLD 0 6F r] Reading Maoiaipal Light Departmem PELIAa LE FOYER FOR GENERATIONS 230 Ash Sneet P.O. Box 150 Reading, MA01867 -0250 Tel: (791) 944-1340 Fax: (781) 942-2409 Web: www.tmld.c0. November 16, 2012 Town of Reading Municipal Light Board Subject: Single Phase Pole Mounted Transformers On October 17, 2012 a bid invitation was placed as a legal notice in the Reading Chronicle requesting proposals for Single Phase Pole Mounted Transformers for the Reading Municipal Light Department. An invitation to bid was emailed to the following: Power Sales Group WESCO Graybar Electric Company EDI Yale Electric Supply Shamrock Power Sales Hughes Supply Ward Transformer Sales Jordan Transformer IF Gray Metro West Electric Sales, Inc. Power Tech -UPSC Hasgo Power Robinson Sales Stuart C. Irby HD Supply HD Industrial Services Bids were received from WESCO, Graybar Electric Company, Moloney, Sutart C. Irby and Yale Electric Supply. The bids were publicly opened and read aloud at 11:00 a.m. November 8, 2012 in the Town of Reading Municipal Light Departments Board Room, 230 Ash Street, Reading, Massachusetts. The bids were reviewed, analyzed and evaluated by the General Manager and the staff Move that bid 2013 -08 for Single Phase Pole Mounted Transformers be awarded to: WESCO for a total cost of $103,410.00 Item (desc.) M Manufacturer Unit Cost Total Net Cost 1(25 kVa) 15 Power Partners /ABB 982.00 $14,730.00 2 (37 1/2 kVa) 30 Power Partners /ABB 1,180.00 $35,400.00 3 (50 Wa) 40 Power Partners /ABB 1,332.00 $53,280.00 as the lowest qualified bidder on the recommendation of the General Manager File: Bid /FY13 /TR 2013-118 R1Vll� iTT l.11 Tl ReadingMuun�cipalLightDepanmem \ R¢LIAR LE p ER i0R GENERATIONS 230 Ash Street, P.O. Box 150 Reading, MA 01867-0250 The Capital Budget allocation for the purchase of these units under the Transformer project was estimated for 60 units at $96,000. Department is purchasing 85 units for $103.410. These quantities will bring the RMLD Inventory back up to the necessary level. File: Bid /FY13 /TR 2013-08 s o rw e € E r « ¢ � o a JE 'm g U U m m o w E m w.m LLa w " 4m = E i !F o 2 4aj0 {SE6 o ° 3 °N 98i q °Q$QC$ 88$ $ °8 Ev 23$ g m�° ma25 mofk m `�i$W m2' a B in 8E26 ;�Qs m mcEa0N5 $ bm 21 000 000 000 000 000 000 E e� €wpm aa¢a aaa aaa aaa aaa 2 °� �8m '°� �i 3 S 'S 3 i 3 S n m ppS �;pp m m N N N Pi E z�weE�g $° € €¢g E �gn 303 fsE�ES 616 000 2EE G ca4 6c .N� 333 UUU CUUt� a 5 �uN 0 o e "3Ey �S b nE d �Y � UY�Y yY�Y =Y O SY «Y 2'Y�Y Y � N WN�°y TAO CNfr1N ONip,N ���n N �V�h O^ 1 °v E E E E E EE! 2 22 I 22 a gx d a p6 A �l 11 0 RMLD CO) E Reading Municipal Light Department RELIABLE POWER FOR cExeannoxs 230 Ash Str P.O. Box 150 Reading, MA 01867 -0250 Te1:(781)944 -1340 FEE: (781)942 -7409 Web: www.tmld.com November 16, 2012 Town of Reading Municipal Light Board Subject: Single Phase Pad Mounted FR3 Transformers On October 17, 2012 a bid invitation was placed as a legal notice in the Reading Chronicle requesting proposals for Single Phase Pad Mounted FR3 Transformers for the Reading Municipal Light Department. An invitation to bid was emailed to the following: Power Sales Group WESCO Graybar Electric Company EDI Yale Electric Supply Shamrock Power Sales Hughes Supply Ward Transformer Sales Jordan Transformer IF Gray Metro West Electric Sales, Inc. PowerTech -UPSC Hasgo Power Robinson Sales Stuart C. Irby HD Supply HD Industrial Services ERMCO Bids were received from WESCO, Graybar Electric Company, Yale Electric and Stuart C. Irby. The bids were publicly opened and read aloud at 11:00 a.m. November 8, 2012 in the Town of Reading Municipal Light Department's Board Room, 230 Ash Street, Reading, Massachusetts. The bids were reviewed, analyzed and evaluated by the General Manager and the staff. Move that bid 2013 -09 for Single Phase Pad Mounted FR3 Transformers be awarded to: WESCO for a total cost of $60,788.00 Item (desc.) -Qty Manufacturer Unit Cost Total Net Cost 1(25 kVa) 4 ERMCO 1,957.00 $7,828.00 2 (37'/2 kVa) 8 ERMCO 2,186.00 $17,488.00 3 (50 kVa) 12 ERMCO 2,434.00 $29,208.00 4 (75 kVa) 2 ERMCO 3,132.00 $6,264.00 as the lowest qualified bidder on the recommendation of the General Manager File Bid /FY13/TR2013-09 RMLD1Ox>♦I �,2t. Muooicipallig6t Dcp rtmeet Jaeons ee v mea eos sexeanr,oxs 230 Ash Street, P.O. Box 150 Reading, MA 01867 -0250 The Capital Budget allocation for the purchase of these units under the Transformer project was estimated at $48,000. The estimated cost of $48,000 was determined using the actual cost of transformers purchased in February of 2012. These units will mostly be used to replace live front transformers in the Departments older underground subdivisions. File Bid /MWIR 2013-09 • • ra | ! ! . , • r }.!!) R@ :! ` !)!! ) \\�� \ / \{ � )i`!• I /!) |! !! •_ \_/ ;j2 } !]!1! , \\{, \!\ §9 \ \{! §\ e/ " l•i ;i • ! !! B# gp 0020 R# Q.'21 HQ E nb a� gg ..Rg 5@ ~ «M aJ\p!R! \ Q 6, /gam / - | G| vm \\ 2) §/] !#\qg 6! \ -E - - {/{ _- �1a- II;. | ! �7 C RMLD C ) CO Reading Municipal Light Department RELIABLE POWER eoa..... Anon' 230 Ash Strut P.O. Box 150 Reading, MA 01867 -0250 Tel: (781) 944.1340 Fax: (781) 942 -7409 Web: www.nWdcom November 16, 2012 Town of Reading Municipal Light Board Subject: Three Phase Pole Mounted Transformers On October 17, 2012 a bid invitation was placed as a legal notice in the Reading Chronicle requesting proposals for Three Phase Pole Mounted Transformers for the Reading Municipal Light Department. An invitation to bid was emailed to the following: Power Sales Group WESCO Graybar Electric Company EDI Yale Electric Supply Shamrock Power Sales Hughes Supply Ward Transformer Sales Jordan Transformer IF Gray Metro West Electric Sales, Inc. Power Tech -UPSC Hasgo Power Robinson Sales Stuart C. Irby HD Supply HD Industrial Services ® Bids were received from WESCO, Moloney Electric Inc. and Shamrock Power Sales Group. The bids were publicly opened and read aloud at 11:00 am November 8, 2012 in the Town of Reading Municipal Light Department's Board Room, 230 Ash Street, Reading, Massachusetts. IC-1 The bids were reviewed, analyzed and evaluated by the General Manager and the staff. Move that bid 2013 -10 for Three Phase Pole Mounted Transformers be awarded to: WESCO for a total cost of $40,274.00 Item (desc.) oy Manufacturer Unit Cost Total Net Cost 1(30 kVa) 2 ABB /Power Partners 2,433.00 $4,866.00 2 (45 kVa) 2 ABB /Power Partners 2,605.00 $5,210.00 3 (75 kVa) 2 ABB /Power Partners 3,065.00 $6,130.00 4 (150 kVa) 2 ABB /Power Partners 4,570.00 $9,140.00 5 (225 kVa) 2 ABB /Power Partners 4,856.00 $9,712.00 6 (300 kVa) 1 ABB /Power Partners 5,216.00 $5,216.00 as the lowest qualified bidder on the recommendation of the General Manager File: Bid /FY13 /TR 201 }30 RT iT T rl @a 9 Muenici Leigh[ Department 1��1�1_l (0) 4QLIABLE P WQR F 4 GENERATIONS 230 Ash Street, Box 150 • Reading, MAGI P.O. .O. 025 0 The Capital Budget allocation for the purchase of these units under the Transformer project was estimated at $80,000. These quantities will bring the RMLD inventory back up to the necessary level. �" / Iu,._ i Peter Price 11 • File: Bid /FY13 /TR 2013 -10 u | / �! !§ t�) }))) }0000! l - - -!!! | \A !| ; !� !) ) !| ! .| !\ !) !} E� 11 #q5d J\§| | | §( || |) ||]) H HOO 00000; \}} } § }| }} \/� \ \{ d!§ \) r !! � d`| !§ r na \ §E£� 4 ...... | / �! !§ t�) }))) }0000! l - - -!!! | \A !| ; !� !) ) !| ! .| !\ !) !} E� 11 #q5d J\§| | | §( || |) ||]) H HOO 00000; \}} } § }| }} !!!!!! M R22 ) - - ---� ))|!!! uTH1 !B `•`* ! � El 0 U RMLD C ) CO Reading Municipal Light Department RELIABLE POWER FOR nEx¢eAnoxs 230 Ash Street P.O. Box 150 Reeding, MA01867-0250 Tel: (781) 944-1340 Fax: (781) 942-2409 Web: E, .ssold.com November 16, 2012 Town of Reading Municipal Light Board Subject: Three Phase Pad Mounted Dead Front Loop Feed Transformers On October 17, 2012 a bid invitation was placed as a legal notice in the Reading Chronicle requesting proposals for Three Phase Pad Mounted Dead Front Loop Feed Transformers for the Reading Municipal Light Department. An invitation to bid was emailed to the following: Power Sales Group WESCO Graybar Electric Company ED] Yale Electric Supply Shamrock Power Sales Hughes Supply Ward Transformer Sales Jordan Transformer IF Gray Metro West Electric Sales, Inc. Power Tech -UPSC Hasgo Power Robinson Sales Stuart C. Irby • HD Supply HD Industrial Services Bids were received from WESCO, Stuart C. Irby Co., Graybar Electric, Yale Electric East LLC, and Moloney Electric Inc. The bids were publicly opened and read aloud at 11:00 a.m. November 8, 2012 in the Town of Reading Municipal Light Departments Board Room, 230 Ash Street, Reading, Massachusetts. The bids were reviewed, analyzed and evaluated by the General Manager and the staff. Move that bid 2013 -11 for Three Phase Pad Mounted Dead Front Loop Feed Transformers be awarded to: Graybar Electric Company for a total cost of $80,208.00 Item (desc.l 4tY Manufacturer Unit Cost Total Net Cost 1(300 kVa 208/12o) 3 Cooper Power 12,122.00 36,366.00 2 (500 kVa 208/120) 3 Cooper Power 14,614.00 43,842.00 as the lowest qualified bidder on the recommendation of the General Manager File: Bids /M3 /7[7/201311 RMLD CO) MBVicipal LightD penmen[ /I/ BLE POW¢¢ pOR LEN ERASIONE — 230 Ash Street, P.O. Box 150 Reading, MA 01867 -0250 • These units will be used in the Johnson Woods Phase 2 project in Reading and to bring the RMLD Inventory back up to the necessary level. p Peter Price • • File: Bids /M3 /TR /201341 ! � | , ! ! !! _ • !! _ !/ ! \\ / / , ;,! � °° ■■ \ !@! /! dog! 0 0E! 00 0, !// �00 G « !°°! \ 88 q I s. -■� .> ;!4 �! : ! ||°�® !9 #! !§ § §2. x =_ ! � | El 0 RMLD l J E C Reading Maniap.1 Light Department RELIABLE POWER FOR GENBRATION6 230 Ash Street P.O. Box 150 Reading, MA 01867 -0250 Tel: (781) 944-1340 Fax: (781) 942-2409 Web: mwEPPmld.cum November 16, 2012 Town of Reading Municipal Light Board Subject: Three Phase Pad Mounted Transformers On October 17, 2012 a bid invitation was placed as a legal notice in the Reading Chronicle requesting proposals for Three Phase Pad Mounted Transformers for the Reading Municipal Light Department. An invitation to bid was emailed to the following: Power Sales Group WESCO Graybar Electric Company EDI Yale Electric Supply Shamrock Power Sales Hughes Supply Ward Transformer Sales Jordan Transformer IF Gray Metro West Electric Sales, Inc. PowerTech -UPSC Hasgo Power Robinson Sales Stuart C. Irby HD Supply HD Industrial Services Bids were received from Graybar Electric Company, WESCO, Stuart C Irby, Yale Electric East LLC and Moloney Electric Inc. The bids were publicly opened and read aloud at 11:00 a.m. November 8, 2012 in the Town of Reading Municipal Light Department's Board Room, 230 Ash Street, Reading, Massachusetts. The bids were reviewed, analyzed and evaluated by the General Manager and the staff Move that bid 2013 -12 for Three Phase Pad Mounted Transformers be awarded to WESCO for a total cost of $35,195.00 Item(desc.) Manufacturer Qty Unit Cost Total Net Cost 1(500 We 13800 Delta w /taps 277/480) ERMCO 2 9,010.00 $18,020.00 2 (1000 kVa 13800 Delta w /taps 120/208) ERMCO 1 17,175.00 $17,175.00 as the lowest qualified bidder on the recommendation of the General Manager. File: Bid /FY13 /TR 2013-12 RMLDMuvcipel Light Department FLIApLB VOV9R FOp NQRArtONi - 230 Ash Street, P.O. Bop 150 Rending, MA01867 -0250 • The Capital Budget allocation for the purchase of these units under the Transformer project was estimated at $60,000. These quantities will bring the RMLD inventory back up to the necessary level. cent F. p .. Peter Price File: Bid /FY13 /TR 201312 Q ! | ! ! i!| . § \! {{ ! ! )! ! \] ! | ji ` \\ a• ` ! 9 j`|!! p! &Q F x /R! ±& ( .: 1 B; \ d $ d 29 §) �§ )( / . .. }} } \§ \} | / e )/\ || E ! | Ll El C RE RMLD CO) Reading Municipal Light Department Reading POWER FOR GENERALIONS 230 Ash Sweet Q P.O. Box P.O. D Reading, M A01867 -0250 Tel: (781) 944-1340 Fas:(781)942 -2409 Web: www.mdd.coen 11 November 16, 2012 Town of Reading Municipal Light Board Subject: Commercial Meters On October 19, 2012 a bid invitation was placed as a legal notice in the Reading Chronicle requesting proposals for Commercial Meters for the Reading Municipal Light Department An Invitation to bid was entailed to the following: WESCO Graybar Electric Company Austin International Inc. Power Tech UPSC Stuart Irby Holbrook Associates Sensus Metering Systems AvCom Inc. 1F Gray Meterman Supply Inc. Shamrock Power Hasgo Power Robinson Sales EL Flowers Power Sales HD Supply Yale Electric MetroWest Electric Sales, Inc. FORM 5S Class 20 Commercial Three Phase Meter with 3 ERTS Itron Bids were received from Avcom and Graybar Electric The bids were publicly opened and read aloud at 11:00 a.m. November 8, 2012 in the Town of Reading Municipal Light Departments Board Room, 230 Ash Street, Reading, Massachusetts. The bids were reviewed, analyzed and evaluated by the General Manager and the staff. Move that bid 2013 -13 for Commercial Meters be awarded to: AvCom Inc. for a total cost of $430,028.60 Item ldesc.) Manufacture Qty Unit Total Net Cost 1- FORM 2S Residential TOU /Commercial Meters with 3 ERTS Itron 680 $170.53 $115,960.40 2 - FORM 2S Residential TOU /Commercial Meters with 3 ERTS Itron 16 $181.90 $2,910.40 3 - FORM 5S Class 20 Commercial Three Phase Meter with 3 ERTS Itron 32 $198.95 $6,366.40 4 -FORM 6S /9S Class 20 Commercial Three Phase Meter with 3 ERTS Itron 340 $198.95 $67,643.00 5 - FORM 12S Class 200 Meter with 3 ERTS Itron 260 $198.95 $51,727.00 6 -FORM 16S Class 200 Commercial Three Phase Meter with 3 ERTS Itron 860 $198.95 $171,097.00 7- FORM 16S Class 320 Commercial Three Phase Meter with 3 ERTS Itron 72 $198.95 $14,324.40 total $430,028.60 as the lowest qualified bidder on the recommendation of the General Manager. Fite: Bids /FY13 /Meters 201343 RMLDCO) ng Municipal Light D partment ,�, /� /J // RBLIARLP P WPR rOR GENERATIONS 230 Ash Street, P.O. Box 150 Reading, MA 01867-0250 These meters are for the Commercial Meter Upgrade Project 17C. The Capital Budget allowed for these units is $510,000. File: Bids /FY13/Metem 201113 • • C, J ` §//9t },,�r. !{| ! ! //ƒ ) � � - 4 !,. \!!. } / \..I !!! /. G ©g // \! /A E -is) ,Z8 mW8,- \ ��H! | § § \§! {� !! ! |;�2E !!! §!!!,!°§ U C i | |; t• �a` !,• as # .2 ,!! .! I§■ |!§ | §§ ;§§ || |; as as ago Is | |} ■| ■ §! ! |{ ; §; `'■ i!, &` 5 G« Q, |�! aa- � §!! |; �.. ■ ■; '- .ate »�• \| ;g7 .., ■� ! |2 ;! -» ».o -::a- .0 !;; !a; ■;. ) �!.2 .01M. § JOIN EM. U M. U P -B | ! �1,, D El U Account Payable Warrant - October 26 Page I of 1 Account Payable Warrant - October 26 Jeanne FDti Sent: Tuesday, October 30, 2012 2:44 PM .. To: Accounting Group Cc: Vincent Cameron; Patricia Mellino There were no Account Payable Warrant questions for October 26. - Thanks. Jeanne Foti Executive Assistant Reading Municipal Light Department 781- 942 -6434 Phone 781 -942 -2409 Fax GPlease consider the environment before printing this a -mail. kaw httos: / /owa.rmld.wm/owa/ ?ae= Item& t =IPM. Note &id= RgAAAACOkZIrTkKI,06ijBI 6Pv 10/30/91)1? Acccoont Payable Warrant and Payroll Page 1 of 1 Acccount Payable Warrant and Payroll Jeanne FoU Sent: Tuesday, November 06, 2012 6:00 AM To: Aanunting Group Cc: Vincent Cameron; Patricia Malmo Good morning. There were no questions on the Account Payable Warrant for November 2 and the Payroll for November 5. Thanks. Jeanne Pod Executive Assistant Reading Municipal Light Department 781 - 942 -6434 Phone 781 - 942 -2409 Fax %ease consider the environment before prinbeg this e-mail. hnnc / /nwannid cnm /nwa /9ar> =1tam. Pit =IPM Nnt ,kid =R o A A A AC01r71,11cK l(16nRl 6Pvd 11/6/7012 j j Account Payable Warrant- November 16 Account Payable Warrant - November 16 Jeanne Foti V Sent: Monday, November 19, 2012 7:03 AM To: Amounting Group Cc: Vincent Cameron; Patricia Mellino Good moming. There were no Account Payable Warrant questions for November 16. Thanks Jeanne Foti Executive Assistant Reading Municipal Light Department fw 781- 942 -6434 Phone 781 - 942 -2409 Fax Please consider the errvironment before printing this a -mall. G Pagc 1 of 1 Payroll Payroll Jeanne Foti Sent: Tuesday, November 20, 2012 4:18 PM To: Accounting Group Cc: wncent Cameron; Patricia Mellino Good afternoon. There were no Payroll questions this Payroll. Jeanne Fall Executive Assistant Reading Municipal Light Department 781- 942 -6434 Phone 781- 942 -2409 Fax Please consider the environment before printing this e-mail. Page 1 of 1 https: / /owa.rmid.com/owal?ae= Item&t-- IPM. Note& id= RRAAAACOkZlrndCLO6UBL6Pv... 11/20/201') j e❑ •