The URL can be used to link to this page

Home My WebLink About2009-12-16 RMLD Board of Commissioners MinutesStart Time of Regular Session: End Time of Regular Session: Attendees: Commissioners: Mary Ellen O'Neill, Chairman Philip Pacino, Secretary Ellen Kearns, Commissioner Staff: Reading Municipal Light Board of Commissioners Regular Session 230 Ash Street 7:30 p.m. 9:54 p.m. Reading, MA 01867 December 16, 2009 Richard Hahn, Vice Chair Robert Soli, Commissioner RECEIV TOWN CLE READI1C, MASS. 2010 FEB -14 P Vinnie Cameron, General Manager Beth Ellen Antonio, Human Resources Manager Jared Carpenter, Energy Efficiency Engineer Jeanne Foti, Executive Assistant Robert Fournier, Accounting/Business Manager Jane Parenteau, Energy Services Manager Kevin Sullivan, Engineering and Operations Manager Citizens' Advisory Board: George Hooper Opening Remarks /Approval of Meeting Agenda Chairman O'Neill asked if there were any suggested comments or changes to the agenda. There were none. Introductions -Chairman O'Neill introduced CAB member George Hooper. Chairman O'Neill stated that the Citizens' Advisory oard had met on November 30, and asked if there was anything Mr. Hooper wanted to report. Mr. Hooper said that there was nothing in particular that he wanted to report from the meeting. Presentation - Quarterly Energy Efficiency Update - Jared Carpenter - Attachment 1 Chairman O'Neill stated that there would be a 'quarterly presentation on the RMLD's Energy Efficiency and Conservation Program. Chairman O'Neill introduced Jared Carpenter, RMLD Energy Efficiency Engineer. Mr. Carpenter explained that in his presentation he would be detailing the energy efficiency and conservation programs over the last year. Mr. Carpenter reported on the process he uses in assisting a customer on assessing his or her usage and means of reduction. Chairman ONeill inquired about the number of commercial energy audits performed. Mr. Carpenter replied that no commercial energy audits have been performed except the one performed by ENE for Wilmington in a little over a year. Mr. Carpenter said that the Town of Wilmington has performed fifteen energy audits on its buildings. Mr. Carpenter anticipates that the RMLD will be taking a minimum of 232 kilowatts off the grid during the summer due to conservation measures. Ms. Kearns asked if Mr. Carpenter could monitor the 40 customers he has worked with to reduce their consumption to compare their usage before and after the audit and to evaluate what may not have worked if little had changed. Mr. Carpenter replied that he is monitoring eight of the recipients of the audits because these customers had a spike in their usage. Mr. Carpenter does call these customers when their usage increases and once he calls the usage reduces. Mr. Carpenter said that he could monitor more of these types of customers. Ms. Kearns suggested that Mr. Carpenter consider sending out a survey six months after the audit. Mr. Carpenter said that he will send out a survey as a means to follow up on these customers. Mr. Carpenter stated that he has galled customers and when the usage is up the customers tend not to call him back. Chairman ONeill asked what the average kilowatt hour usage would be to recharge an electric car, e.g., a Toyota Prius that is driven 40 miles daily. Mr. Carpenter will get back to Chairman ONeill on this. Regular Session Meeting Minutes December 16, 2009 Presentation - Quarterly Energy Efficiency Update - Jared Carpenter - Attachment 1 Ms. Parenteau pointed," (that an off peak rate may need to be developed to accommodate the electric charging of vehicles. Chairman, ffeill stated that she would like to see something in next year's budget that the RMLD will do with its buildings to improv& i&bner'gy effk ncy and set an example for its customers. Mr. Carpenter mentioned that he along with Mr. Donahoe have looked through the building for energy savings. Currently they have the cooling tower going out to bid and in the garage the lights will be replaced with more energy efficient lighting. Chairman O'Neill also asked if priorities had been set for the upcoming year. Mr. Carpenter replied that at the next meeting when the energy efficiency /conservation program is discussed he will talk about these. Discussion followed. The Board thanked Mr. Carpenter for his presentation. Approval of November 18, 2009 Board Minutes Mr. Hahn made a motion seconded by Mr. Pacino to approve the Regular Session meeting minutes of November 18, 2009 as presented. Motion carried 5:0:0. General Manager's Report — Mr. Cameron American Public Power Association 2010 Legislative Rally Mr. Cameron reported that it is required that he receive Board approval to attend the American Public Power Association 2010 Legislative Rally, February 22 to February 24, 2010 in Washington, DC. Mr. Cameron explained that he is part of a contingency that meets with every Representative and Senator in New England, however, when required, they meet with legislators from outside of New England. Mr. Cameron said that Mr. Carakatsane would be attending because at the last CAB meeting they authorized one person to attend. Chairman O'Neill commented that she wants to make sure that the RMLD's message to Washington includes supporting climate change. Mr. Cameron said that part of NEPPA's message in the Washington meetings is support of climate change legislation. Chairman O'Neill asked what the primary agenda is. Mr. Cameron replied that it would be on climate change, energy conservation, and ISO oversight at the FERC. Mr. Cameron explained that the Legislative Rally is an opportunity to visit Capitol Hill. The contingent from New England will meet on Monday, Tuesday and Wednesday with Senators and Representatives from throughout New England and others from around the United States. Mr. Hahn said that this allows the opportunity for the contingent to express its concerns on issues affecting them and they have the highest office that will listen to their concerns. Mr. Hahn made a motion seconded by Mr. Pacino to authorize the General Manager to attend the 2010 APPA Legislative Rally. Motion carried 5:0:0. Mr. Cameron said that 2010 is the second extension on the Twenty Year Agreement. The Twenty Year Agreement binds the four towns together with the RMLD. The Twenty Year Agreement provides for a ten year notice of a ten year option to leave the RMLD's service territory. Mr. Cameron will provide the Board with a copy of the notice that has been sent to the four towns regarding the extension of the Twenty Year Agreement. 2 Mr. Cameron explained that in the past, the extension of the Twenty Year Agreement has been done by either by r Town Meeting or Selectmen. Mr. Cameron will be attending the Town of Reading Selectmen's meeting in January. Mr. Pacino indicated his interest in attending these meetings as he is one of the original architects of the agreement. Regular Session Meeting Minutes December 16, 2009 meral Manager's Report — Mr. Cameron jn another matter, Mr. Cameron reported that the T -Shirt contest is on Thursday, January 7 at 7:00 p.m. if the Commissioners want to attend. Mr. Cameron reported that the food drive at the RMLD received a very generous response. Food has been given to the Reading and North Reading food pantries. Mr. Cameron said that RMLD employee Laurie Ann Sylvia coordinates a gift drive with RMLD employees for children in the towns of Reading, North Reading and Wilmington. The RMLD employees have donated gifts to these children. Mr. Soli asked for an explanation on the PPA portion of his bill. Mr. Cameron said that he would provide a more in depth explanation at the next Board meeting. The PPA has increased to 9 mills per kilowatt-hour. In the budget the forecast for the PPA was 5.3 to 5.5 mills a kilowatt -hour in order to recover the base power supply costs during fiscal year 2010. The RMLD needed to recover $1 million that was taken from the Rate Stabilization Fund in 2009 to meet increased expenses, particularly higher power supply costs. Mr. Soli asked if that was due to an increase in transmission. Mr. Cameron answered affirmatively. Mr. Cameron explained that the RMLD is trying to recover additional transmission costs from 2009. The RMLD is also performing a reforecast because July and August were not good weather months and the projected revenues were not met. Mr. Cameron will be coming back to the Board on the reforecast because he would like the month of December to be included. Mr. Cameron added that retired RMLD employee Paul Carson has model trains on display under the Christmas tree the RMLD lobby. The RMLD is open from 8 to 4:30 Monday through Friday and the public is welcome to come to see the trains. Chairman O Neill asked if the RMLD is open on December 24. Mr. Cameron said that the RMLD is open on December 24, however is closed on December 25. Financial Report, October and November Highlights, 2009— Mr. Fournier — Attachment 2 Mr. Fournier said that the year to date results for the first four months is positive. Mr. Fournier said that the only extraordinary item that is ongoing is the Gaw substation clean up. Mr. Fournier reported on the financial highlights for October and November. Mr. Fournier commented that kilowatt hour sales lag behind last year's sales by 14.5 million kilowatt hours or 5.6 %. Mr. Soli asked if that is primarily due to commercial sector. Mr. Fournier replied affirmatively. Mr. Fournier replied that the kilowatt hour sales are down $553,000. Mr. Fournier reported that the liens were placed between September and November on the overdue accounts of homeowners in the four towns. Chairman O'Neill noted that the current level of the Deferred Fuel Cash Reserve is $3.2 million. The target level as voted by the Board is to be $2.6 to $2.9. Chairman O'Neill asked what steps are being taken to get the DFCR into the Board approved range. Ms. Parenteau replied that the Fuel Charge adjustment for November and December has been reduced to 6.10 and, as a result, at the end of December this fund will be at $2.78 million. Ms. Parenteau reported on the October Purchase Power Summary and the November Highlights. s. Kearns asked about how the use of electricity at RMLD compares with other public utilities in Massachusetts. As. Parenteau replied that based on a municipal system survey which has taken into account the weather and the economy, the usage is down by a range of 3% to 10% for most municipal systems compared to last year. Regular Session Meeting Minutes December 16, 2009 Power Supply Report October and November Highlights, 2009 — Ms. Parenteau — Attachment 3 Ms. Kearns said that she was interested in knowing how other municipalities had reforecasted their projected use. Ms. Parenteau replied that while a significant number of municipal utilities have reforecasted their use that within this grouping of municipals there was only one municipal that had load growth due to a new development. Ms. Parenteau said that reduction in use is related in part to the economy, the weather, and to customers conserving for personal or financial reasons. Mr. Soli asked if Table 1, cost of energy for New York Power Authority, usually reflected a higher amount than zero. Ms. Parenteau said that she will provide Mr. Soli with a corrected page because the cost of energy should be $4.92 instead of zero. Chairman O'Neill polled the Board to see if they wanted the November report with the Board book in January although it will contain two months of reporting. The Board agreed to have two months of reporting in the January Board book. Engineering and Operations Report October and November Highlights, 2009 — Mr. Sullivan - Attachment 4 Gaw Update Mr. Sullivan reported on the Gaw project. Mr. Sullivan provided an update on the soil remediation activities. Mr. Hahn asked when the two new remaining transformers would be energized. Mr. Sullivan was hoping that 110B would be in place, depending on the weather, in January and the new 110A in the spring. Mr. Hahn asked if there was a high probability that all three new transformers would be in before the summer. Mr. Sullivan replied affirmatively. Chairman O'Neill asked for public clarity if all the additional soil tests had been taken and if all the results had come in. Mr. Sullivan replied that not all test and sampling had been done. Chairman O'Neill followed up by wanting to know why this has not been completed. Mr. Sullivan explained that there is additional sampling that needs to be performed in the right of way and on the fence line that has not been completed. Mr. Sullivan said that the sampling started around the substation building because it was core to the project and is almost complete. Mr. Sullivan then reported on the Capital Plan. Chairman O'Neill would like an indication of projects that are complete such as an asterisk. Chairman ONeill asked about Project 5 High Capacity Tie which was scheduled to be done in the second quarter. Mr. Sullivan replied that priorities change and he defers to the Chief Engineer for the order of the projects. If a particular job needed Verizon poles set, that could change the priority. Mr. Sullivan will get back to Chairman O'Neill on this project. Mr. Sullivan reported on the Reliability Report. Chairman O'Neill asked Mr. Sullivan if he looks at the reliability numbers in terms of what the RMLD goal should be. Mr. Sullivan said that he would like to measure the RMLD against itself for a four year timeline and he would like to have this new benchmarking ready for the February Board meeting. General Discussion Ms. Kearns explained that a couple of months ago she received the APPA booklet, Evaluating Your Utilities Energy Services Program, which suggests some conservation ideas. Ms. Kearns would like to talk with Mr. Carpenter about the programs in the book. Chairman ONeill said that she, Ms. Kearns and Mr. Cameron could discuss the information provided in the APPA booklet on energy conservation programs. Chairman ONeill noted that the Board does not have an annual meeting, only reorganization in April following the town election. Chairman O'Neill would like to see a retrospective of the RMLD put together because there are various oral and written histories of the RMLD available. Chairman ONeill suggested this would be very appropriate for the Board's reorganization meeting and would be something that could be shared with RCTV. 4 Regular Session Meeting Minutes December 16, 2009 'eneral Discussion liairman O'Neill was invited to the Annual Meeting of the Nimble Thimblers, a community group that uses the RMLD Cafeteria for its meetings. The group expressed its gratitude for the opportunity to use the RMLD facilities. Ms. Kearns asked that if there are any requirements for an annual meeting. Mr. Cameron responded that there is no requirement. BOARD MATERIAL AVAILABLE BUT NOT DISCUSSED Rate Comparisons, November 2009 E -Mail responses to Account Payable/Payroll Questions Upcoming Meetings Thursday, January 7, 2010 — T -Shirt Contest Awards Wednesday, January 27, 2010 Wednesday, February 24, 2010 CAB Meeting — Monday, January 11, 2010 Commissioner Pacino will cover this meeting. Vice Chair Hahn will back this up. On another matter, on the Rate Comparisons, Mr. Soli said that Wakefield, which has generally been above the other the municipals, is now 8% below the municipals and inquired what actions they have taken to facilitiate this change. Mr. Cameron replied that he will get back to Mr. Soli. Executive Session At 9:07 p.m. Mr. Pacino made a motion seconded by Mr. Hahn that the Board go into Executive Session to discuss strategy with respect to collective bargaining, litigation, Chapter 164 Section 47D, exemption from public records and open meeting requirements in certain instances, deployment of security devices, and return to Regular Session for the release of Executive Session minutes and adjournment. lotion carried 5:0:0. —Mr. Pacino, Aye; Mr. Hahn, Aye; Chairman O'Neill, Aye; Ms. Kearns, Aye; and Mr. Pacino. Aye. The Board re- entered Regular Session at 9:49 p.m. Release of Executive Session Minutes Mr. Pacino made a motion seconded by Mr. Hahn that the Reading Municipal Light Board of Commissioners approve the release of the Executive Session meeting minutes, as redacted, for January 28, 2004; February 18, 2004,; March 10, 2004; April 21, 2004; May 26, 2004; June 15, 2004; July 21, 2004; September 28, 20004; October 28, 2004; November 10, 2004; and December 1, 2004. Motion carried 5:0:0. Motion to Adjourn At 9:54 p.m. Mr. Pacino made a motion seconded by Mr. Hahn to adjourn the Regular Session. Motion carried 5:0:0. A true copy of the RMLD Board of Commissioners minutes as approved by a majority of the Commission. Philip B. Pacino, Secretary RMLD Board of Commissioners N U U 4-� w bA W �1 4� ct O O N N N U N Q N CC3 W ct ct `t c ct ct O ct u - u P� Ct a� ct ct ''"' •� N ct U �r bz c� ° a ct •� c ct f oc OC o0 OC SIN p 00 .ion) oU ^ N i OO -�--� �—' O ' ct U w V p p U oc 4-4 U ct O °; -T:s, ct U �—+ cj N ct ct ct r ct � O O •—+ r—+ N ct •'—+ •ct .ct W N rn cd ct ct UD ct cd o o� clt —q ct 00 bi) 0 110 kr) ct ti) 00 kr) 1-� ct 0 rw� UD 00 ct ct = ct Lr) ct ct ct ct cn cc by UD bb v) bj) Ct ct ri� 0 p ct Ct co bb m Ct r-- ct ct c) ct > m 00 n ct n V Vc �j u • • • • • • 0 • N n V V N O U 0 O t U ct O ct to O •-r' p cc3 p N � � O �cn +� ct 0 ct U ct ct Ct clt ct ct O O ct 0 0 U ct •� O U � N •� ct .4-4 U ct ct ct ct UD Ct ct ct W O U c ct ct o cn t- W N � c U bb U �^ a � c ct U U O W� � U • • • • N N W 7 O N c� U O cc3 • N blJ O O 0 c� Q� 4- ct U O ct � O ct bQ ct � O b.Q � O b,A � Q W • • /0"-- ct O U a� cr 3 Z 0 O ct •• LM T o ,� o �, U � � o '� G • LV I M 7045d AM $�4 z N m 4110 ` lui4 Y��iy�rt•� � 1 n�� 4i�1n rro r'i �'t1F11 I'M11 , j- N qq.,rAt, 1 � it - aa, 1W t _43 1" iM , �ry t ., fgpg Ty� e a �.; �'" , f � - d i.. � �-� t +,.. J +� 4 �� J � _ t �� s ..� µ �, �y.�. �k �� ,o:' A N O LJ M-W "PO-M Lig I ct 0 wral Dt: December 3, 2009 To: RMLB, Vincent F. Cameron, Jr., Jeanne Foti 1 Fr: Bob Fournier / /,L- Y � 31J Sj: October 31, 2009 Report The results for the first four months ending October 31, 2009, for the fiscal year 2010 will be summarized in the following paragraphs. Overall, the year to date results are positive. The full financial impact of the GAW Substation incident is still unknown. 1) Change in Net Assets or Net Income: (Page 3A) For the month of October, net income or the positive change in net assets was $525,105, bringing the year to date net income for the first four months to $2,378,099. The budgeted net income for this period was $1,325,080, resulting in net income being over budget by $1,053,019, or 79.5 %. The difference between the actual fuel expense and the actual fuel revenue is $1,609,834 with revenues exceeding expenses. 2) Revenues: (Page 11B) Base revenues were under budget by $553,061 or 3.8 %. Actual base revenues were at $13.8 million compared to the budgeted amount of $14.4 million. All sectors were under budget except for the residentials. 3) Expenses: (Page 12A) *Purchased power base expense was $145,481 or 1.57% over budget. Actual purchased power base costs were $9.4 million compared to the budgeted amount of $9.3 million. '`Operating and Maintenance (O &M) expenses combined were under budget by $507,845 or 14.0 %. Actual O &M expenses were $3.1 million compared to the budgeted amount of $3.6 million. The major expenses that were under budget are energy audit expense and conservation ($110,000), overhead maintenance ($51,000), garage and stockroom ($42,000) and professional services ($65,000). '`Depreciation expense and voluntary payments to the Towns were on budget. 4) Cash: (Page 9) "Operating Fund balance was at $7,376,633. *Capital Funds balance was at $5,570,467. *Rate Stabilization Fund balance was at $5,258,473. *Deferred Fuel Fund balance was at $3,236,959. 5) General Information: Kwh sales continue to lag behind last year's figure by 14.5 million kwh or 5.6 %. 6) Budget Variance: All five divisions were under budget cumulatively by $516,304 or 8.7 %. 7) Trends: The fuel charge remained at $.0665 in October. ASSETS CURRENT UNRESTRICTED CASH RESTRICTED CASH RESTRICTED INVESTMENTS RECEIVABLES, NET PREPAID EXPENSES INVENTORY TOTAL CURRENT ASSETS NONCURRENT INVESTMENT IN ASSOCIATED CO CAPITAL ASSETS, NET OTHER ASSETS TOTAL NONCURRENT ASSETS TOTAL ASSETS TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS -TYPE PROPRIETARY FUND STATEMENT OF NET ASSETS 10/31/09 PREVIOUS YEAR (SCH A P.9) (SCH A P.9) (SCH A P.9) (SCH B P.10) (SCH B P.10) (SCH C P.2) (SCH C P.2) (SCH C P.2) LIABILITIES CURRENT ACCOUNTS PAYABLE CUSTOMER DEPOSITS CUSTOMER ADVANCES FOR CONSTRUCTION ACCRUED LIABILITIES CURRENT PORTION OF BONDS PAYABLE TOTAL CURRENT LIABILITIES NONCURRENT BONDS PAYABLE, NET OF CURRENT PORTION ACCRUED EMPLOYEE COMPENSATED ABSENCES TOTAL NONCURRENT LIABILITIES TOTAL LIABILITIES NET ASSETS INVESTED IN CAPITAL ASSETS, NET OF RELATED DEBT RESTRICTED FOR DEPRECIATION FUND (P.9) UNRESTRICTED TOTAL NET ASSETS (P.3) TOTAL LIABILITIES AND NET ASSETS (1) 9,388,138.28 13,111,700.89 4,400,000.00 10,156,418.67 869,726.57 1,445,105.18 39,371,089.59 122,391.17 61,351,401.27 18,343.90 CURRENT YEAR 7,379,633.80 14,403,662.27 4,400,000.00 8,259,879.94 995,669.12 1,414,162.18 36,853,007.31 108,967.43 65,370,356.94 14,523.70 61,492,136.34 65,493,848.07 100,863.225.93 102,346,855.38 6,305,665.89 7,153,620.30 492,157.55 495,854.70 669,476.81 473,421.88 500,702.57 933,028.40 550,000.00 0.00 8.518.002.82 9,055,925.28 0.00 0.00 2,682,217.58 2,873,114.33 2,682,217.58 2,873,114.33 11,200,220.40 11,929,039.61 60,801,401.27 65,370,356.94 4,015,293.47 5,290,866.10 24,846,310.79 19,756,592.73 89,663,005.53 90,417,815.77 100,863,225.93 102,346,855.38 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT NONCURRENT ASSET SCHEDULE 10/31/09 SCHEDULE OF INVESTMENTS IN ASSOCIATED COMPANIES NEW ENGLAND HYDRO ELECTRIC NEW ENGLAND HYDRO TRANSMISSION TOTAL INVESTMENTS IN ASSOCIATED COMPANIES SCHEDULE OF CAPITAL ASSETS LAND STRUCTURES AND IMPROVEMENTS EQUIPMENT AND FURNISHINGS INFRASTRUCTURE TOTAL CAPITAL ASSETS, NET CONSTRUCTION WORK IN PROGRESS TOTAL UTILITY PLANT SCHEDULE OF OTHER ASSETS PURCHASED POWER WORKING CAPITAL UNAMORTIZED DEBT EXPENSE TOTAL OTHER ASSETS TOTAL NONCURRENT ASSETS (2) SCHEDULE C PREVIOUS YEAR CURRENT YEAR 46,153.24 41,937.50 76,237.93 67,029.93 122,391.17 108,967.43 1,265,842.23 7,288,907.18 6,990,207.10 43,969,844.76 59,514,801.27 1,836,600.00 61,351,401.27 14,523.70 3,820.20 18,343.90 61,492,136.34 1,265,842.23 6,997,417.80 12,406,597.06 44,700,499.85 0.00 65,370,356.94 14,523.70 0.00 14,523.70 65,493,848.07 - TOWN OF READING, MASSACHUSETTS 2,014,398.59 8,826,997.54 9,435,800.36 ' MUNICIPAL LIGHT DEPARTMENT 3,206,685.71 22,621,466.15 14,302,737.00 — 36.77% BUSINESS —TYPE PROPRIETARY FUND 864,703.70 2,643,970.44 2,541,731.16 STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND NET ASSETS 140,158.08 844,824.21 577,436.10 — 31.65% 10/31/09 261,200.00 280,105.78 1,044,800.00 1,120,423.12 MONTH MONTH LAST YEAR CURRENT YEAR YTD 418,000.00 LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE OPERATING REVENUES: (SCH D P.11) 395,143.57 525,105.10 2,039,976.84 2,378,099.65 16.57% BASE REVENUE 3,108,210.99 3,048,387.80 13,661,781.19 13,853,400.72 1.40% FUEL REVENUE 4,852,009.38 3,559,022.94 23,668,330.59 15,912,571.45 — 32.77% PURCHASED POWER CAPACITY 222,978.11 375,462.27 1,226,233.33 1,050,561.56 — 14.335, FORFEITED DISCOUNTS 66,546.15 71,444.89 284,968.83 276,708.58 —2.90% ENERGY CONSERVATION REVENUE 44,765.68 43,515.31 44,765.68 195,820.07 337.43% PASNY CREDIT 0.00 (41,650.59) 0.00 (112,268.92) 100.00% TOTAL OPERATING REVENUES 8,294,510.31 7,056,182.62 38,886,079.62 31,176,793.46 — 19.83% OPERATING EXPENSES: (SCH E P.12) PURCHASED POWER BASE 2,140,800.99 2,014,398.59 8,826,997.54 9,435,800.36 6.90% PURCHASED POWER FUEL 4,419,355.11 3,206,685.71 22,621,466.15 14,302,737.00 — 36.77% OPERATING 651,860.29 864,703.70 2,643,970.44 2,541,731.16 —3.87% MAINTENANCE 202,794.26 140,158.08 844,824.21 577,436.10 — 31.65% DEPRECIATION 261,200.00 280,105.78 1,044,800.00 1,120,423.12 7.24% VOLUNTARY PAYMENTS TO TOWNS 100,750.00 104,500.00 403,000.00 418,000.00 3.72% TOTAL OPERATING EXPENSES 7,776,760.65 6,610,551.86 36,385,058.34 28,396,127.74 — 21.96% OPERATING INCOME 517,749.66 445,630.76 2,501,021.28 2,780,665.72 11.18% NONOPERATING REVENUES (EXPENSES) CONTRIBUTIONS IN AID OF CONST 30,701.55 211,565.34 87,715.26 222,014.05 153.11% " "?TURN ON INVESTMENT TO READING (176,060.50) (182,222.50) (704,242.00) (728,890.00) 3.50% rEREST INCOME 18,045.25 10,738.92 107,381.21 49,391.33 — 54.00% ..__._atEREST EXPENSE (4,083.73) (1,290.85) (15,951.93) (9,607.79) — 39.77% OTHER (MDSE AND AMORT) 8,791.34 40,683.43 64,053.02 64,526.34 0.74% TOTAL NONOPERATING REV (EXP) (122,606.09) 79,474.34 (461,044.44) (402,566.07) — 12.68% CHANGE IN NET ASSETS 395,143.57 525,105.10 2,039,976.84 2,378,099.65 16.57% NET ASSETS AT BEGINNING OF YEAR 87,623,028.69 88,039,716.12 0.48% NET ASSETS AT END OF OCTOBER 89,663,005.53 90,417,815.77 0.84% (3) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS -TYPE PROPRIETARY FUND STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND NET ASSETS 10/31/09 OPERATING REVENUES: (SCH F P.11B) BASE REVENUE FUEL REVENUE PURCHASED POWER CAPACITY FORFEITED DISCOUNTS ENERGY CONSERVATION REVENUE PASNY CREDIT TOTAL OPERATING REVENUES OPERATING EXPENSES: (SCH G P.12A) PURCHASED POWER BASE PURCHASED POWER FUEL OPERATING MAINTENANCE DEPRECIATION VOLUNTARY PAYMENTS TO TOWNS TOTAL OPERATING EXPENSES OPERATING INCOME NONOPERATING REVENUES (EXPENSES) CONTRIBUTIONS IN AID OF CONST RETURN ON INVESTMENT TO READING INTEREST INCOME INTEREST EXPENSE OTHER (MDSE AND AMORT) TOTAL NONOPERATING REV (EXP) CHANGE IN NET ASSETS NET ASSETS AT BEGINNING OF YEAR NET ASSETS AT END OF OCTOBER * ( ) = ACTUAL UNDER BUDGET ACTUAL BUDGET % YEAR TO DATE YEAR TO DATE VARIANCE* CHANGE 13,853,400.72 14,406,462.00 (553,061.28) -3.84% 15,912,571.45 15,632,780.00 279,791.45 1.79% 1,050,561.56 1,200,000.00 (149,438.44) - 12.45% 276,708.58 316,94.3.00 (40,234.42) - 12.69% 195,820.07 215,851.00 (20,030.93) -9.28% (112,268.92) 0.00 (112,268.92) 100.00% 31,176,793.46 31,772,036.00 (595,242.54) -1.87% 9,435,800.36 9,290,319.00 145,481.36 1.57% 14,302,737.00 15,632,780.00 (1,330,043.00) -8.51% 2,541,731.16 2,907,729.00 (365,997.84) - 12.59% 577,436.10 719,284.00 (141,847.90) - 19.7291. 1,120,423.12 1,130,000.00 (9,576.88) -0.859, 418,000.00 418,000.00 0.00 0.00% 2,378,099.65 1,325,080.00 1,053,019.65 28,396,127.74 30,098,112.00 (1,701,984.26) -5.65% 2,780,665.72 1,673,924.00 1,106,741.72 66.12% 222,014.05 200,000.00 22,014.05 11.01% (728,890.00) (728,900.00) 10.00 0.00% 49,391.33 150,000.00 (100,608.67) - 67.07% (9,607.79) (9,444.00) (163.79) 1.73% 64,526.34 39,500.00 25,026.34 63.36% (402,566.07) (348,844.00) (53,722.07) 15.40% 2,378,099.65 1,325,080.00 1,053,019.65 79.47% 88,039,716.12 88,070,125.81 (30,409.69) -0.03% 90,417,815.77 89 395 205.81 1,022,609.96 1.14% (3A) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT RECONCILIATION OF CAPITAL FUNDS 10/31/09 SOURCE OF CAPITAL FUNDS: DEPRECIATION FUND BALANCE 7/1/09 4,403,129.56 CONSTRUCTION FUND BALANCE 7/1/09 1,000,000.00 INTEREST ON DEPRECIATION FUND FY 10 10,709.17 DEPRECIATION TRANSFER FY 10 1,120,423.12 FORCED ACCOUNTS REIMBURSEMENT 0.00 GAW SUBSTATION (FY 10) 869 896.00 TOTAL SOURCE OF CAPITAL FUNDS 7,404,157.85 USE OF CAPITAL FUNDS: PAID ADDITIONS TO PLANT THRU OCTOBER 963,794.12 PAID ADDITIONS TO GAW THRU OCTOBER 869,896.00 GENERAL LEDGER CAPITAL FUNDS BALANCE 10/31/09 5,570,467.73 PAID ADDITIONS TO GAW FROM FY 10 869,896.00 PAID ADDITIONS TO GAW FROM FY 09 3,136,764.00 PAID ADDITIONS TO GAW FROM FY 08 1,895,975.00 TOTAL 5,902,635.00 (4) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SALES OF KILOWATT HOURS 10/31/09 (5) MONTH MONTH LAST YEAR CURRENT YEAR YTD % SALES OF ELECTRICITY: LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE RESIDENTIAL SALES 18,128,329 18,431,922 91,708,872 89,058,643 -2.8951. COMM. AND INDUSTRIAL SALES 33,908,662 32,598,345 157,850,938 144,927,128 -8.19% PRIVATE STREET LIGHTING 70,658 70,576 284,861 283,273 -0.56% TOTAL PRIVATE CONSUMERS 52,107,649 51,100,843 249,844,671 234,269,044 -6.23% MUNICIPAL SALES: STREET LIGHTING 241,591 237,205 966,084 948,754 -1.79% MUNICIPAL BUILDINGS 673,040 749,704 5,078,390 3,304,319 - 34.93% TOTAL MUNICIPAL CONSUMERS _ 914,631 986,909 6,044,474 4,253,073 - 29.64% SALES FOR RESALE 220,602 211,029 1,245,100 1,181,614 -5.10% SCHOOL 1,301,289 1,223,808 1,301,289 4,193,288 222.24% TOTAL KILOWATT HOURS SOLD 54,544,171 53,522,589 258,435,534 243,897,019 -5.63% (5) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT KILOWATT HOURS SOLD BY TOWN 10/31/09 TOTAL READING LYNNFIELD _:NTH NO.READING WILMINGTON RESIDENTIAL 18,431,922 5,936,636 2,715,777 4,162,780 5,616,729 COMM & IND 32,598,345 4,074,702 251,663 5,098,103 23,173,877 PVT ST LIGHTS 70,576 13,563 1,360 20,881 34,772 PUB ST LIGHTS 237,205 78,631 32,851 39,710 86,013 MUNI BLDGS 749,704 170,927 123,622 153,715 301,440 SALES /RESALE 211,029 211,029 0 0 0 SCHOOL 1,223,808 437,650 241,129 151,520 393,509 TOTAL 53,522,589 10,923,138 3,366,402 9,626,709 29,606,340 YEAR TO DATE RESIDENTIAL 89,058,643 27,532,197 13,154,434 20,537,509 27,834,503 COMM & IND 144,927,128 18,015,803 1,170,772 22,593,140 103,147,413 PVT ST LIGHTS 283,273 56,432 5,440 83,212 138,189 PUB ST LIGHTS 948,754 314,524 131,404 158,774 344,052 MUNI BLDGS 3,304,319 797,476 562,500 664,630 1,279,713 SALES /RESALE 1,181,614 1,181,614 0 0 0 SCHOOL 4,193,288 1,595,902 897,802 478,680 1,220,904 TOTAL 243 897,019 49,493,948 15,922,352 44,515,945 133,964,774 LAST YEAR TO DATE RESIDENTIAL 91,708,872 28,971,415 13,331,617 21,369,267 28,036,573 COMM & IND 162,929,328 21,191,652 2,468,894 28,477,436 110,791,346 PVT ST LIGHTS 284,861 55,084 5,480 87,509 136,788 PUB ST LIGHTS 966,084 332,468 131,424 158,244 343,948 MUNI BLDGS 0 0 0 0 0 SALES /RESALE 1,245,100 1,245,100 0 0 0 SCHOOL 1,301,289 492,731 267,745 161,680 379,133 TOTAL 52,288,450 16,205,160 50,254,136 139,687,788 258,435,534 KILOWATT HOURS SOLD TO TOTAL TOTAL READING LYNNFIELD NO.READING WILMINGTON MONTH RESIDENTIAL 34.44% 11.090 5.07% 7.78% 10.505. COMM & IND 60.91% 7.61% 0.47% 9.53% 43.30% PVT ST LIGHTS 0.13% 0.0391 0.00% 0.04% 0.065, PUB ST LIGHTS 0.44% 0.15% 0.06% 0.07% 0.16% MUNI BLDGS 1.40% 0 .32% 0.23% 0.29% 0.56% SALES /RESALE 0.39% 0.39% 0.00% 0.00% 0.00% SCHOOL 2.29% 0.82 % 0.45% 0.28% 0.74% TOTAL 20.41% 6.28% 17.99% 55.32 °0 100.00% YEAR TO DATE RESIDENTIAL 36.51% 11.29% 5.39% 8.42% 11.41% COMM & IND 59.43% 7.39% 0.48 % 9.26% 42.3091 PVT ST LIGHTS 0.12% 0.02% 0.00% 0.03% 0.07% PUB ST LIGHTS 0.39% 0.13% 0.05% 0.07% 0.14% MUNI BLDGS 1.35% 0.33% 0.23% 0.27% 0.52s' SALES /RESALE 0.48% 0.48% 0.00% 0.009, 0.0090 SCHOOL 1.72% 0.65% 0.37% 0.20% 0.50% TOTAL 20.29% 6.52% 18.25% 54.94% 100.0051. LAST YEAR TO DATE RESIDENTIAL 35.49% 11.21% .5.169, 8.27% 10.85% COMM & IND 63.05% 8.20% 0.96% 11.02% 42.87% PVT ST LIGHTS 0.11% 0.02% 0.00% 0.03% 0.06% PUB ST LIGHTS 0.379-. 0 . 13 % 0.05% 0,06% 0.13% MUNI BLDGS 0.00% 0.00% 0,00% 0.00% 0.00% SALES /RESALE 0.48% 0.48% 0.00% 0.00% 0.00% SCHOOL 0.50% 0.19% 0.10 % 0.06 °a 0.15 TOTAL 6.271 19.44% 54.06% 100.00% 20.23% (6) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT FORMULA INCOME 10/31/09 TOTAL OPERATING REVENUES (P.3) 31,176,793.46 ADD: POLE RENTAL 37,806.00 INTEREST INCOME ON CUSTOMER DEPOSITS 11080.90 LESS: OPERATING EXPENSES (P.3) (28,396,127.74) BOND INTEREST EXPENSE (4,445.77) CUSTOMER DEPOSIT INTEREST EXPENSE (5,162.02) FORMULA INCOME (LOSS) 2,809,944.83 (7) SALE OF KWH (P.5) KWH PURCHASED AVE BASE COST PER KWH AVE BASE SALE PER KWH AVE COST PER KWH AVE SALE PER KWH FUEL CHARGE REVENUE (P.3) LOAD FACTOR PEAK LOAD TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT GENERAL STATISTICS 10/31/09 MONTH OF OCT 2008 54,544,171 57,092,505 0.037497 0.056985 0.114904 0.145941 4,852,009.38 79.87% 97,921 MONTH OF % CHANGE YEAR THRU OCT 2009 2008 2009 OCT 2008 OCT 2009 53,522,589 -0.755. -5.63% 258,435,534 243,897,019 54,904,618 -2.05% - 4.809, 259,383,843 246,931,886 0.036689 20.27% 12.29% 0.034031 0.038212 0.056955 0.45% 7.45% 0.052863 0.056800 0.095094 73.14% - 20.71% 0.121243 0.096134 0.123451 48.86% - 15.51% 0.144447 0.122043 3,559,022.94 104.70% - 32.77% 23,668,330.59 15,912,571.45 80.11% 93,890 (8) 60100 (3) I rM, 60 dDS < 60 Onv 4-� 60 Nnr (D > 60 Nnr 0 60 AM 0 0 60 add VJ L- (D 60 UVA CD 60 Ehl cz cz 60 NVP 4— 90 Oda 20 AON tz( 80100 so d3s x k, so env o -inr so Nnr 90 AVA 110 HdV 20 UVA 43 90 El-i 90 NVP zo 0�0 LO AON zo 100 /-0 d�S zo Onv Lo -inr IL` ZO Nnr ✓ zo AM LO HdV LO UVA LO 03=1 LO NVr 90 ODO 90 AON 90100 LO 0 LO 0 LO 0 LO 0 0 CO I"-- LO '71- N T- 0 0 C) 0 C) 0 O C) 0 -Ga to 6S to 69- -ca UNRESTRICTED CASH CASH - OPERATING FUND CASH - PETTY CASH TOTAL UNRESTRICTED CASH TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF CASH AND INVESTMENTS 10/31/09 PREVIOUS YEAR 9,385,138.28 3,000.00 9,388,138.28 RESTRICTED CASH CASH - DEPRECIATION FUND 4,015,293.47 CASH - CONSTRUCTION FUND 714,626.21 CASH - TOWN PAYMENT 1,107,200.00 CASH - BOND PAYMENTS 193,600.00 CASH - DEFERRED FUEL RESERVE 1,952,195.14 CASH - RATE STABILIZATION FUND 3,208,162.18 CASH - UNCOLLECTIBLE ACCTS RESERVE 28,988.15 CASH - SICK LEAVE BENEFITS 1,214,226.47 CASH - INSURANCE RESERVE 35,251.72 CASH - HAZARD WASTE RESERVE 150,000.00 CASH - CUSTOMER DEPOSITS 492,157.55 TOTAL RESTRICTED CASH 13,111,700.89 RESTRICTED INVESTMENTS RATE STABILIZATION * 2,900,000.00 SICK LEAVE BENEFITS ** 1,500,000.00 TOTAL RESTRICTED INVESTMENTS 4,400,000.00 TOTAL CASH BALANCE 26,899,839.17 OCTOBER 2008 • FED HOME LOAN MTG CORP • FED HOME LOAN MTG CORP ** FED HOME LOAN MTG CORP ** FED HOME LOAN MTG CORP ** FED HOME LOAN MTG CORP OCTOBER 2009 * FED HOME LOAN MTG CORP FED HOME LOAN MTG CORP ** FED HOME LOAN MTG CORP FED HOME LOAN MTG CORP FED NATIONAL MTG ASSN SCHEDULE A CURRENT YEAR 7,376,633.80 3,000.00 7,379,633.80 5,290,866.10 279,601.63 1,146,900.00 0.00 3,236,959.78 2,358,473.65 28,988.15 1,380,766.54 35,251.72 150,000.00 495,854.70 14,403,662.27 2,900,000.00 1,500,000.00 4,400,000.00 26,183,296.07 1,500,000.00; DTD 12/13/07; INT 4.35 %; MATURITY 12/15/12 1,400,000.00; DTD 05/08/08; INT 4.00 %; MATURITY 11/15/13 500,000.00; DTD 01/17/08; INT 4.25 %; MATURITY 07/15/13 500,000.00; DTD 01/25/08; INT 4.25 %; MATURITY 01/15/15 500,000.00; DTD 11/13/07; INT 5.25 9,.; MATURITY 11/13/17 1,400,000.00; DTD 07/02/09; INT 3.25 %; MATURITY 07/15/14 1,500,000.00; DTD 01/23/09; INT 2.00 %; MATURITY 01/15/13 500,000.00; DTD 01/23/09; INT 2.00 51.; MATURITY 01/15/13 500,000.00; DTD 06/01/09; INT 3.70 %; MATURITY 06/11/16 500,000.00; DTD 05/07/09; INT 3.00 %; MATURITY 05/15/15 (9) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF ACCOUNTS RECEIVABLE 10/31/09 SCHEDULE OF ACCOUNTS RECEIVABLE RESIDENTIAL AND COMMERCIAL ACCOUNTS RECEIVABLE - OTHER ACCOUNTS RECEIVABLE - LIENS ACCOUNTS RECEIVABLE - EMPLOYEE ADVANCES SALES DISCOUNT LIABILITY RESERVE FOR UNCOLLECTIBLE ACCOUNTS TOTAL ACCOUNTS RECEIVABLE BILLED UNBILLED ACCOUNTS RECEIVABLE TOTAL ACCOUNTS RECEIVABLE, NET SCHEDULE OF PREPAYMENTS PREPAID INSURANCE PREPAYMENT PURCHASED POWER PREPAYMENT PASNY PREPAYMENT WATSON TOTAL PREPAYMENT * ACCOUNTS RECEIVABLE AGING OCTOBER 2009: RESIDENTIAL AND COMMERCIAL LESS: SALES DISCOUNT LIABILITY GENERAL LEDGER BALANCE CURRENT 30 DAYS 60 DAYS 90 DAYS OVER 90 DAYS TOTAL (10) PREVIOUS YEAR 5,535,708.70 243,481.59 51,480.44 1,067.16 (259,380.69) (178,300.28) 5,394,056.92 4,762,361.75 10,156,418.67 459,579.03 42,130.14 368,017.40 0.00 869,726.57 4,186,245.83 (245,137.57) 3,941,108.26 3,217,674.47 81.65% 439,941.86 11.16% 159,189.74 4.04% 54,770.70 1.39% 69,531.49 1.76% 3,941,108.26 100.00% SCHEDULE B CURRENT YEAR 4,186,245.83 235,138.95 110,946.55 1,067.16 (245,137.57) (201,325.56) 4,086,935.36 4,172,944.58 8,259,879.94 510,864.16 33,888.12 324,535.66 126,381.18 995,669.12 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REVENUE 10/31/09 (11) SCHEDULE D - -' MONTH MONTH LAST YEAR CURRENT YEAR YTD SALES OF ELECTRICITY: LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE RESIDENTIAL SALES 2,866,783.09 2,496,249.53 14,279,462.51 11,924,830.09 - 16.49% COMM AND INDUSTRIAL SALES 4,701,724.08 3,774,932.86 21,521,694.85 16,524,580.81 - 23.22% PRIVATE STREET LIGHTING 12,185.14 10,549.78 49,191.98 42,021.55 - 14.58% TOTAL PRIVATE CONSUMERS 7,580,692.31 6,281,732.17 35,850,349.34 28,491,432.45 - 20.53% MUNICIPAL SALES: STREET LIGHTING 53,054.11 46,948.32 212,499.93 186,828.58 - 12.08% MUNICIPAL BUILDINGS 100,924.61 94,367.39 873,216.66 406,259.96 - 53.48% TOTAL MUNICIPAL CONSUMERS 153,978.72 141,315.71 1,085,716.59 593,088.54 - 45.37% SALES FOR RESALE 33,380.46 27,123.26 201,876.97 150,760.23 - 25.32% SCHOOL 192,168.88 157,239.60 192,168.88 530,690.95 176.16% SUB -TOTAL 7,960,220.37 6,607,410.74 37,330,111.78 29,765,972.17 - 20.26% F °°FEITED DISCOUNTS 66,546.15 71,444.89 284,968.83 276,708.58 -2.90% PURCHASED POWER CAPACITY 222,978.11 375,462.27 1,226,233.33 1,050,561.56 - 14.33% ENERGY CONSERVATION - RESIDENTIAL 9,049.73 9,219.96 9,049.73 44,549.64 392.28% ENERGY CONSERVATION - COMMERCIAL 35,715.95 34,295.35 35,715.95 151,270.43 323.54% PASNY CREDIT 0.00 (41,650.59) 0.00 (112,268.92) 100.00% TOTAL REVENUE 7,056,182.62 31,176,793.46 - 19.83% 8,294,510.31 38,886,079.62 (11) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REVENUE BY TOWN 10/31/09 THIS YEAR TO DATE TOTAL READING LYNNFIELD NO.READING WILMINGTON MONTH 11,924,830.09 3,695,943.40 1,751,312.11 2,756,827.33 3,720,747.25 RESIDENTIAL 2,496,249.53 805,780.08 365,755.74 564,051.68 760,662.03 INDUS /MUNI BLDG 3,869,300.25 515,598.24 41,812.62 620,896.46 2,690,992.93 PUB.ST.LIGHTS 46,948.32 16,247.32 5,819.54 7,800.00 17,081.46 PRV.ST.LIGHTS 10,549.78 1,985.32 203.90 3,267.07 5,093.49 CO -OP RESALE 27,123.26 27,123.26 0.00 0.00 0.00 SCHOOL 157,239.60 56,098.53 30,828.24 20,089.53 50,223.30 TOTAL 6 607 410.74 1,422,832.75 444,420.04 1,216,104.74 3,524,053.21 THIS YEAR TO DATE RESIDENTIAL 11,924,830.09 3,695,943.40 1,751,312.11 2,756,827.33 3,720,747.25 INDUS /MUNI BLDG 16,930,840.78 2,242,858.82 206,323.96 2,691,737.60 11,789,920.39 PUB.ST.LIGHTS 186,828.58 64,680.73 23,149.25 31,010.25 67,988.35 PRV.ST.LIGHTS 42,021.54 8,192.54 809.23 12,915.16 20,104.62 CO -OP RESALE 150,760.23 150,760.23 0.00 0.00 0.00 SCHOOL 530,690.95 200,567.97 111,515.13 63,662.21 154,945.64 TOTAL 29,765,972.17 6,363,003.69 2,093,109.66 5,556,152.56 15,753,706.26 LAST YEAR TO DATE RESIDENTIAL 14,279,462.51 4,523,628.17 2,066,096.41 3,328,831.39 4,360,906.54 INDUS /MUNI BLDG 22,394,911.51 3,007,422.97 355,952.66 3,920,401.71 15,111,134.17 PUB.ST.LIGHTS 212,499.93 75,205.50 26,330.36 34,694.41 76,269.66 PRV.ST.LIGHTS 49,191.98 ' 9,354.71 953.43 15,735.04 23,148.80 CO -OP RESALE 201,876.97 201,876.97 0.00 0.00 0.00 SCHOOL 192,168.88 72,736.94 38,929.00 24,609.71 55,893.23 TOTAL 37,330,111.78 7,890,225.26 2,488,261.86 7,324,272.26 19,627,352.40 PERCENTAGE OF OPERATING INCOME TO TOTAL TOTAL READING LYNNFIELD NO.READING WILMINGTON MONTH RESIDENTIAL 37.78% 12.20% 5.54% 8.54% 11.50% INDUS /MUNI BLDG 58.56% 7.80% 0.63% 9.40% 40.73% PUB.ST.LIGHTS 0.7191. 0.25% 0.09% 0.129, 0.25% PRV.ST.LIGHTS 0.16% 0.03% 0.00% 0.05% 0.08% CO -OP RESALE 0.41% 0.41% 0.00% 0.00% 0.00% SCHOOL 2.38% 0.85% 0.47% 0.30% 0.76% TOTAL 100.00% 21.54% 6.73% 18.41% 53.32% THIS YEAR TO DATE RESIDENTIAL 40.06% 12.42% 5.88% 9.26% 12.50% . INDUS /MUNI BLDG 56.88% 7.53% 0.69% 9.04% 39.62% PUB.ST.LIGHTS 0.63% 0.22% 0.08% 0.10% 0.23% PRV.ST.LIGHTS 0.14% 0.03% 0.00% 0.04% 0.07% CO -OP RESALE 0.51% 0.51% 0.00 % 0.00% 0.00% SCHOOL 1.78% 0.67% 0.37% 0.21% 0.53% TOTAL 100.00% 21.38% 7.02% 18.65% 52.95% LAST YEAR TO DATE RESIDENTIAL 38.26% 12.12% 5.53% 6.92% 11.69% INDUS /MUNI BLDG 59.99% 8.06% 0.95% 10.50% 40.48% PUB.ST.LIGHTS 0.57% 0.20% 0.07% 0.09% 0.21% PRV.ST.LIGHTS 0.13% 0.03% 0.00% 0.04% 0.06% CO -OP RESALE 0.54% 0.54% 0.00% 0.00% 0.00% SCHOOL 0.51% 0.19% 0.10% 0.07% 0.15% TOTAL 100.00% 21.14% 6.65% 19.62% 52.59.1 (11A) TOWN OF READING, MASSACHUSETTS * ( ) = ACTUAL UNDER BUDGET (11B) MUNICIPAL LIGHT DEPARTMENT BUDGETED REVENUE VARIANCE REPORT 10/31/09 SCHEDULE F ACTUAL BUDGET YEAR TO DATE YEAR TO DATE VARIANCE * CHANGE SALES OF ELECTRICITY: RESIDENTIAL 6,110,301.40 5,939,763.00 170,538.40 2.87% COMM AND INDUSTRIAL SALES PRIVATE STREET LIGHTING 7,287,844.63 7,929,858.00 (642,013.37) -8.10% MUNICIPAL BUILDINGS PUBLIC STREET LIGHTING 124,922.45 172,871.00 (47,948.55) - 27.74% SALES FOR RESALE 73,543.90 80,219.00 (6,675.10) -8.32% SCHOOL 256,788.34 283,751.00 (26,962.66) -9.50% TOTAL BASE SALES 13,853,400.72 14,406,462.00 (553,061.28) -3.84% TOTAL FUEL SALES 15,912,571.45 15,632,780.00 279,791.45 1.79% TOTAL OPERATING REVENUE 29,765,972.17 30,039,242.00 (273,269.83) -0.91% FORFEITED DISCOUNTS 276,708.58 316,943.00 (40,234.42) - 12.699, PURCHASED POWER CAPACITY 1,050,561.56 1,200,000.00 (149,438.44) - 12.45% ENERGY CONSERVATION - RESIDENTIAL 44,549.64 64,754.00 (20,204.36) - 31.20% ENERGY CONSERVATION - COMMERCIAL 151,270.43 151,097.00 173.43 0.11% PASNY CREDIT (112,268.92) 0.00 (112,268.92) 100.00% TOTAL OPERATING REVENUES 31,176,793.46 31 772 036.00 (595,242.54) -1.87% * ( ) = ACTUAL UNDER BUDGET (11B) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING EXPENSES 10/31/09 SCHEDULE E DEPRECIATION EXPENSE PURCHASED POWER FUEL EXPENSE VOLUNTARY PAYMENTS TO TOWNS 261,200.00 4,419,355.11 100,750.00 280,105.78 1,044,800.00 1,120,423.12 7.24% 3,206,685.71 22,621,466.15 14,302,737.00 - 36.77% 104,500.00 403,000.00 418,000.00 3.72% TOTAL OPERATING EXPENSES 7,776,760.65 6,610,551.86 36,385,058.34 28,396,127.74 - 21.96% (12) MONTH MONTH LAST YEAR CURRENT YEAR YTD =a OPERATION EXPENSES: LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE PURCHASED POWER BASE EXPENSE 2,140,800.99 2,014,398.59 8,826,997.54 9,435,800.36 6.90% OPERATION SUPER AND ENGIN -TRANS 0.00 0.00 0.00 0.00 0.00% OPERATION SUP AND ENGINEERING EXP 29,824.87 27,163.23 130,354.67 115,467.45 - 11.42% STATION SUP LABOR AND MISC 7,504.99 2,943.67 32,359.46 6,736.01 - 79.18% LINE MISC LABOR AND EXPENSE 48,945.52 52,068.27 189,383.75 199,270.78 5.22% STATION LABOR AND EXPENSE 37,205.99 31,121.28 167,248.55 157,316.08 -5.94% STREET LIGHTING EXPENSE 4,474.02 5,546.22 15,498.00 15,005.24 -3.18% METER EXPENSE 28,580.14 30,268.50 131,336.69 120,616.04 -8.16% MISC DISTRIBUTION EXPENSE 27,890.52 24,643.75 114,158.04 101,165.62 - 11.38% METER READING LABOR & EXPENSE 6,541.26 5,715.99 27,354.09 28,442.59 3.98% ACCT & COLL LABOR & EXPENSE 117,408.15 123,083.99 517,268.45 446,443.73 - 13.69% UNCOLLECTIBLE ACCOUNTS 10,400.00 12,500.00 41,600.00 50,000.00 20.19% ENERGY AUDIT EXPENSE 36,250.80 25,720.33 168,142.89 138,454.80 - 17.66% ADMIN & GEN SALARIES 58,070.46 57,529.88 260,418.84 244,271.52 -6.20% OFFICE SUPPLIES & EXPENSE 29,481.87 25,342.10 89,904.23 80,605.99 - 10.34% OUTSIDE SERVICES 38,509.33 50,707.77 91,181.57 105,745.99 0.00% PROPERTY INSURANCE 26,282.19 31,399.35 105,128.76 127,494.60 21.27% INJURIES AND DAMAGES 5,363.28 3,694.79 21,233.02 17,783.22 - 16.25% EMPLOYEES PENSIONS & BENEFITS 94,090.86 257,255.50 416,732.81 35.8,458.82 - 13.96% MISC GENERAL EXPENSE 21,646.32 7,701.87 59,301.44 43,336.30 - 26.92% RENT EXPENSE 14,226.72 13,967.21 56,202.18 55,382.58 -1.46% ENERGY CONSERVATION 9,163.00 76,330.00 9,163.00 129,733.80 1315.84% TOTAL OPERATION EXPENSES 651,860.29 864 703.70 2,643,970.44 2 541 731.16 -3.87% MAINTENANCE EXPENSES: MAINT OF TRANSMISSION PLANT 227.08 227.08 908.32 908.32 0.00°1 - - MAINT OF STRUCT AND EQUIPMT 20,697.76 801.19 120,467.27 15,029.51 -87.' MAINT OF LINES - OH 124,520.87 78,373.83 444,186.73 289,032.59 - 34., MAINT OF LINES - UG 17,287.91 3,363.53 52,273.30 38,339.52 - 26.66% MAINT OF LINE TRANSFORMERS 1,192.34 16,605.26 25,150.68 43,992.47 74.92% MAINT OF ST LT & SIG SYSTEM 11.58 12.81 20.79 (75.00) - 460.75% MAINT OF GARAGE AND STOCKROOM 33,050.00 29,793.00 172,633.02 158,463.88 -8.21% MAINT OF METERS 0.00 0.00 0.00 531.31 100.00% MAINT OF GEN PLANT 5,806.72 10,981.38 29,184.10 31,213.50 6.95% TOTAL MAINTENANCE EXPENSES 202,794.26 140,158.08 844,824.21 577,436.10 - 31.650 DEPRECIATION EXPENSE PURCHASED POWER FUEL EXPENSE VOLUNTARY PAYMENTS TO TOWNS 261,200.00 4,419,355.11 100,750.00 280,105.78 1,044,800.00 1,120,423.12 7.24% 3,206,685.71 22,621,466.15 14,302,737.00 - 36.77% 104,500.00 403,000.00 418,000.00 3.72% TOTAL OPERATING EXPENSES 7,776,760.65 6,610,551.86 36,385,058.34 28,396,127.74 - 21.96% (12) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED OPERATING EXPENSE VARIANCE REPORT 10/31/09 * ( ) = ACTUAL UNDER BUDGET (12A) SCHEDULE G ACTUAL BUDGET OPERATION EXPENSES: YEAR TO DATE YEAR TO DATE VARIANCE * CHANGE PURCHASED POWER BASE EXPENSE 9,435,800.36 9,290,319.00 145,481.36 1.57% OPERATION SUPER AND ENGIN -TRANS 0.00 0.00 0.00 0.00% OPERATION SUP AND ENGINEERING EXP 115,467.45 137,066.00 (21,598.55) - 15.76% STATION SUP LABOR AND MISC 6,736.01 22,867.00 (16,130.99) - 70.54% LINE MISC LABOR AND EXPENSE 199,270.78 195,692.00 3,578.78 1.83% STATION LABOR AND EXPENSE 157,316.08 138,841.00 18,475.08 13.31% STREET LIGHTING EXPENSE 15,005.24 25,993.00 (10,987.76) - 42.27% METER EXPENSE 120,616.04 136,101.00 (15,484.96) - 11.38% MISC DISTRIBUTION EXPENSE 101,165.62 111,768.00 (10,602.38) -9.49% METER READING LABOR & EXPENSE 28,442.59 21,728.00 6,714.59 30.90% ACCT & COLL LABOR & EXPENSE 446,443.73 473,060.00 (26,616.27) -5.63% UNCOLLECTIBLE ACCOUNTS 50,000.00 50,000.00 0.00 0.00% ENERGY AUDIT EXPENSE 138,454.80 378,075.00 (239,620.20) - 63.38% ADMIN & GEN SALARIES 244,271.52 250,429.00 (6,157.48) -2.46% OFFICE SUPPLIES & EXPENSE 80,605.99 88,322.00 (7,716.01) -8.74% OUTSIDE SERVICES 105,745.99 171,344.00 (65,598.01) - 38.28% PROPERTY INSURANCE 127,494.60 147,724.00 (20,229.40) - 13.69% INJURIES AND DAMAGES 17,783.22 20,314.00 (2,530.78) - 12.46% EMPLOYEES PENSIONS & BENEFITS 358,458.82 381,820.00 (23,361.18) -6.12% MISC GENERAL EXPENSE 43,336.30 85,917.00 (42,580.70) - 49.56% RENT EXPENSE 55,382.58 70,668.00 (15,285.42) - 21.63% ENERGY CONSERVATION 129,733.80 0.00 129,733.80 100.00% TOTAL OPERATION EXPENSES 2,541,731.16 2,907,729.00 (365,997.84) - 12.59% MAINTENANCE EXPENSES: MAINT OF TRANSMISSION PLANT 908.32 1,000.00 (91.68) -9.17% MAINT OF STRUCT AND EQUIPMENT 15,029.51 49,693.00 (34,663.49) - 69.76% - MAINT OF LINES - OH 289,032.59 340,430.00 (51,397.41) - 15.10% MAINT OF LINES - UG 38,339.52 47,933.00 (9,593.48) - 20.015. MAINT OF LINE TRANSFORMERS 43,992.47 36,168.00 7,824.47 21.63% MAINT OF ST LT & SIG SYSTEM (75.00) 3,228.00 (3,303.00) - 102.32% MAINT OF GARAGE AND STOCKROOM 158,463.88 200,540.00 (42,076.12) - 20.98% MAINT OF METERS 531.31" 1,592.00 (1,060.69) - 66.63% MAINT OF GEN PLANT 31,213.50 38,700.00 (7,486.50) - 19.34% TOTAL MAINTENANCE EXPENSES 577,436.10 719,284.00 (141,847.90) - 19.72% DEPRECIATION EXPENSE 1,120,423.12 1,130,000.00 (9,576.88) -0.85% PURCHASED POWER FUEL EXPENSE 14,302,737.00 15,632,780.00 (1,330,043.00) -8.51% VOLUNTARY PAYMENTS TO TOWNS 418,000.00 418,000.00 0.00 0.00% TOTAL OPERATING EXPENSES -5.65% (1,701,984.26) 30,098,112.00 28,396,127.74 * ( ) = ACTUAL UNDER BUDGET (12A) TOTAL OPERATING EXPENSES os,007,, u.uu Zb,396,127.74 56,293,602.26 (12B) 66.47% TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED OPERATING EXPENSE VARIANCE REPORT 10/31/09 RESPONSIBLE REMAINING OPERATION EXPENSES: SENIOR 2010 ACTUAL BUDGET REMAINING MANAGER ANNUAL BUDGET YEAR TO DATE BALANCE BUDGET % PURCHASED POWER BASE EXPENSE JP 26,794,251.00 64.78% 9,435,800.36 17,358,450.64 OPERATION SUPER AND ENGIN -TRANS KS 0.00 OPERATION SUP AND ENGINEERING EXP KS 398,196.00 0.00 115,467.45 0.00 282,728.55 0.005. STATION SUP LABOR AND MISC KS 71,651.00 6,736.01 64,914.99 71.00% 90.60% LINE MISC LABOR AND EXPENSE KS 576,553.00 199,270.78 377,282.22 65.449. STATION LABOR AND EXPENSE KS 423,826.00 157,316.08 266,509.92 62.88% STREET LIGHTING EXPENSE KS 79,519.00 15,005.24 64,513.76 81.13% METER EXPENSE MISC DISTRIBUTION EXPENSE DA 424,973.00 120,616.04 304,356.96 71.62% METER READING LABOR & EXPENSE JD 345,498.00 101,165.62 244,332.38 70.72% ACCT & COLL LABOR & EXPENSE DA 66,772.00 28,442.59 38,329.41 57.4051. UNCOLLECTIBLE ACCOUNTS RF 1,462,217.00 446,443.73 1,015,773.27 69.47% ENERGY AUDIT EXPENSE RF 150,000.00 50,000.00 100,000.00 66.67% ADMIN & GEN SALARIES JP 1,105,759.00 138,454.80 967,304.20 87.48% OFFICE SUPPLIES & EXPENSE VC 776,201.00 244,271.52 531,929.48 68.53% OUTSIDE SERVICES VC 264,600.00 80,605.99 183,994.01 69.549. PROPERTY INSURANCE VC 398,500.00 105,745.99 292,754.01 73.469' INJURIES AND DAMAGES JD 443,150.00 127,494.60 315,655.40 71.23% EMPLOYEES PENSIONS & BENEFITS JD JD 60,039.00 17,783.22 42,255.78 70.38% MISC GENERAL EXPENSE 1,093,185.00 358,458.82 734,726.18 67.21% RENT EXPENSE VC 223,038.00 43,336.30 179,701.70 80.57% ENERGY CONSERVATION JD 212,000.00 55,382.58 156,617.42 73.885' JP 0.00 129,733.80 (129,733.80) 100.00% TOTAL OPERATION EXPENSES 8,575,677.00 70.36% 2,541,731.16 6,033,945.84 MAINTENANCE EXPENSES: MAINT OF TRANSMISSION PLANT KS 3,000.00 908.32 2,091.68 69.72% MAINT OF STRUCT AND EQUIPMT KS 158,859.00 15,029.51 143,829.49 90.540'' MAINT OF LINES - OH MAINT OF LINES - UG KS 1,060,849,00 289,032.59 771,816.41 72.75% MAINT OF LINE TRANSFORMERS KS 144,228.00 38,339.52 105,888.48 73.42% MAINT OF ST LT & SIG SYSTEM KS 93,500.00 43,992.47 49,507.53 52.95% MAINT OF GARAGE AND STOCKROOM JD JD 9,888.00 (75.00) 9,963.00 100.76% MAINT OF METERS 625,632.00 158,463.88 467,168.12 74.67% MAINT OF GEN PLANT DA 4,863.00 531.31 4,331.69 89.07% RF 116,100.00 31,213.50 84,886.50 7.3.11% TOTAL MAINTENANCE EXPENSES 2,216,919.00 1,639,482.90 73.95% 577,436.10 DEPRECIATION EXPENSE RF 3,390,000.00 1,120,423.12 2,269,576.88 66.95% PURCHASED POWER FUEL EXPENSE JP 42,458,883.00 14,302,737.00 28,156,146.00 66.31% VOLUNTARY PAYMENTS TO TOWNS RF 1,254,000.00 418,000.00 836,000.00 66.67% TOTAL OPERATING EXPENSES os,007,, u.uu Zb,396,127.74 56,293,602.26 (12B) 66.47% TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT PROFESSIONAL SERVICES 10/31/09 PROFESSIONAL SERVICES BY PROJECT ITEM DEPARTMENT ACTUAL BUDGET 1 RMLD AND PENSION TRUST AUDIT FEES ACCOUNTING 29,750.00 33,000.00 2 PENSION ACTUARIAL EVALUATION ACCOUNTING 0.00 5,000.00 3 IT CONSULTING ACCOUNTING HEALTH RESOURCES 10,000.00 4 LEGAL- FERC /ISO ISSUES ENERGY SERVICE 0.00 16,668.00 5 LEGAL- POWER SUPPLY ISSUES ENERGY SERVICE 21,898.35 16,668.00 6 PROFESSIONAL SERVICES ENERGY SERVICE 0.00 16,668.00 7 NERC COMPLIANCE E & 0 1,906.25 3,332.00 8 ENGINEERING STUDIES ENGINEERING 876.57 7,500.00 9 LEGAL SERVICES- GENERAL GM 30,614.73 16,668.00 10 LEGAL SERVICES - ARBITRATION HR 15,563.70 0.00 11 LEGAL GENERAL HR 5,032.84 13,332.00 12 LEGAL SERVICES - UNION CONTRACT HR 103.55 22,500.00 13 LEGAL GENERAL BLDG. MAINT. 0.00 500.00 14 SURVEY RIGHT OF WAY BLDG. MAINT. 0.00 1,668.00 15 ENVIRONMENTAL BLDG. MAINT. 0.00 1,668.00 16 ENGINEERING SERVICES BLDG. MAINT. 0.00 2,840.00 17 LEGAL GEN. BENEFIT 0.00 3,332.00 18 PROPERTY APPRAISAL GEN. BENEFIT 0.00 0.00 TOTAL 105,745.99 171,344.00 PROFESSIONAL SERVICES BY VENDOR iT *4411.191 CHOATE HALL AND STEWART 19,600.09 PLM ELECTRIC 876.57 UTILITY SERVICE 1,906.25 DUNCAN AND ALLEN 8,636.99 MELANSON HEATH AND COMPANY 34,515.52 KATHLEEN GOOD- ARBITRATOR 300.00 HEALTH RESOURCES 200.00 GARRY WOOTERS- ARBITRATOR 600.00 RUBIN AND RUDMAN 39,110.57 TOTAL 105,745.99 (13) RMLD BUDGET VARIANCE REPORT FOR PERIOD ENDING OCTOBER 31, 2009 DIVISION ACTUAL BUDGET VARIANCE % CHANGE ENGINEERING AND OPERATIONS 1,092,913 1,238,032 (145,119) - 11.72% ENERGY SERVICES 290,112 428,247 (138,136) - 32.269. GENERAL MANAGER 239,798 278,379 (38,581) - 13.86% FACILITY 849,294 975,357 (126,063) - 12.92% BUSINESS DIVISION 2,925,436 2,993,841 (68,405) -2.28% SUB -TOTAL 5,397,552 5,913,856 (516,304) - 8.73% PURCHASED POWER - BASE 9,435,800 9,290,319 145,481 1.57% PURCHASED POWER - FUEL 14,302,737 15,632,780 (439,227) -8.51% TOTAL 29,136,090 30,836,955 (810,050) -5.52% 12/3/2009 RMLD ENGINEERING AND OPERATIONS BUDGET VARIANCE REPORT FOR PERIOD ENDING OCTOBER 31, 2009 ENGINEERING 65 01 -65- 5580 -101 LABOR REG 13,356 30,128 36,193 25,097 ACTUAL BUDGET ACT /BUD -" LABOR OT 3,502 2,441 1,630 1,663 YTD YTD VARIANCE E &O MGR 55 EE EDUCATION 7UL AUG SEP OCT TOTAL TOTAL % 01 -55- 5920 -101 LABOR REG 12,834 14,016 17,172 13,955 57,977 57,289 1.20% 01 -55 -5920 -102 LABOR OT 0 0 0 0 0 1,000 - 100.00% 01 -55- 5921 -000 OFFICE SUPPLIES 0 0 11 51 63 332 - 81.14% 01 -55- 5930 -103 EE EDUCATION 0 0 1,354 930 2,284 7,100 - 67.84% 01 -55 -5930 -106 VEHICLE (561) (314) (286) (71) (1,232) 1,750 - 170.43% 01 -55- 5923 -000 OUTSIDE SERVICES 0 1,031 475 400 1,906 3,332 - 42.79% 01 -55- 5930 -105 MISC GENERAL 0 0 0 0 0 400 - 100.00% SUB -TOTAL 27,098 12,273 14,733 18,725 15,266 60,997 71,202 - 14.33% ENGINEERING 65 01 -65- 5580 -101 LABOR REG 13,356 30,128 36,193 25,097 104,775 101,249 3.48% 01 -65- 5580 -102 LABOR OT 3,502 2,441 1,630 1,663 9,236 15,900 - 41.91% 01 -65- 5580 -103 EE EDUCATION 0 0 800 335 1,135 16,500 - 93.12% 01 -65- 5580 -105 SUPPLIES 125 137 922 125 1,310 1,668 - 21.49% 01 -65- 5580 -106 VEHICLE (450) (252) (229) (57) (988) 1,750 - 156.48% 01 -65- 5921 -000 OFFICE SUPPLIES 9 205 92 121 427 332 28.47% 01 -65- 5923 -000 OUTSIDE SERVICES 0 877 0 0 877 7,500 - 88.31% SUB -TOTAL 264 16,541 33,536 39,409 27,284 116,771 144,899 - 19.41% LINE 66 01 -66- 5568 -109 MAINT OF TRANS EXP 227 227 227 227 908 1,000 -9.17% 01 -66 -5581 -101 LABOR MISC 46,688 52,011 28,374 40,284 167,357 131,523 27.25% 01 -66- 5581 -109 GENERAL EXP 4,321 3,923 8,542 8,516 25,302 41,668 - 39.28% O' `- 5581 -103 EE EDUCATION 0 0 3,343 3,268 6,611 22,500 - 70.629, C 5585 -109 STREET LIGHT EXP 630 907 1,252 1,560 4,350 6,668 - 34.77% 01,-o- 5585 -101 LABOR REG ST LIGHT 1,261 1,008 1,909 2,665 6,843 6,576 4.06% 01 -66- 5585 -102 LABOR OT ST LIGHT 444 129 344 234 1,151 4,000 - 71.23% 01 -66- 5585 -106 VEHICLE ST LIGHT 264 372 939 1,088 2,662 8,748 - 69.57% 01- 66- 5593 -000 MAINT OF LINES 1,288 (799) 1,694 7,915 10,098 16,000 - 36.89% 01 -66- 5593 -101 LABOR REG MAINT LINE (630) 28,783 65,052 8,736 101,940 102,041 -0.10% 01 -66- 5593 -102 LABOR OT MAINT LINE 27,098 21,697 21,170 22,259 92,224 80,240 14.94% 01 -66- 5593 -106 VEHICLE MAINT OH LINE (4,824) 2,615 7,022 16,606 21,419 59,484 - 63.99% 01 -78- 5593 -110 TREE TRIMMING 6,825 18,737 14,932 22,856 63,351 82,664 - 23.36% 01 -66- 5594 -109 MAINT UG LINE 1,602 12,307 18,545 1,765 34,219 38,588 - 11.32% 01 -66- 5594 -101 LABOR REG UG LINES 0 349 2,171 1,192 3,712 4,540 - 18.25% 01 -66- 5594 -102 LABOR OT UG LINE 0 199 0 0 199 1,668 - 88.10% 01- 66- 5594 -106 VEHICLE UG LINE (561) (148) 513 406 210 3,138 - 93.3151. 01 -66 -5596 -109 ST LT & SIG EXP 0 0 0 0 0 168 - 100.00% 01 -66- 5596 -101 LABOR REG ST LT /SG 0 0 0 0 0 2,018 - 100.005. 01 -66- 5596 -102 LABOR OT ST LT /SG 0 0 0 0 0 168 - 100.00% 01 -66 -5596 -106 VEHICLE ST LT /SG (47) (22) (19) 13 (75) 875 - 108.57% 01 -66 -5921 -000 OFFICE SUPPLIES 0 0 0 0 0 168 - 100.00% SUB -TOTAL 84,587 142,293 176,010 139,592 542,481 614,441 - 11,714 Page 1 12/3/2009 RMLD ENGINEERING AND OPERATIONS BUDGET VARIANCE REPORT FOR PERIOD ENDING OCTOBER 31, 2009 GRAND TOTAL 179,134 281 752 362,429 269,598 1,092,913 1 238 032 - 11.72% Page 2 ACTUAL BUDGET ACT/B,_ -' YTD YTD VARIANCE METER READING 80 IUL AUG SEP OCT TOTAL TOTAL % 01 -80- 5902 -101 LABOR REG 8,632 5,861 4,845 4,583 23,921 18,103 32.14% 01 -80- 5902 -102 LABOR OT 0 0 0 0 0 668 - 100.00% 01 -80 -5902 -105 SUPPLIES 0 0 0 0 0 332 - 100.00% 01 -80- 5902 -106 VEHICLE 1,204 1,172 1,014 1,133 4,522 2,624 72.311 SUB -TOTAL 9,836 7,032 5,859 5,716 28,443 21,727 30.911 METER TECHNICIANS 67 01 -67- 5586 -109 METER TECH EXP 210 200 700 589 1,699 4,000 - 57.53% 01 -67- 5586 -101 LABOR REG 20,604 29,921 39,209 29,104 118,838 123,184 -3.531 01 -67 -5586 -102 LABOR OT 615 202 404 498 1,719 1,668 3.031 01 -67 -5586 -103 EE EDUCATION 0 0 0 0 0 2,000 - 100.005, 01 -67- 5586 -106 VEHICLE (912) (539) (267) 78 (1,639) 5,249 - 131,231 01 -67 -5921 -000 OFFICE SUPPLIES 0 0 0 0 0 168 - 100,001 SUB -TOTAL 20,517 29,785 40,046 30,269 120,616 136t269 - 11,491 STATION 68 01 -68- 5581 -109 STATION OP 376 376 376 566 1,692 1,668 1.4691. 01 -68- 5581 -101 LABOR REG SUP 0 0 2,666 2,378 5,044 21,200 - 76,211 01 -68- 5582 -109 STATION SUPPLIES (209) (273) (672) (1,650) (2,805) 2,500 - 212,191 01 -68- 5582 -101 LABOR REG 21,033 29,719 36,586 22,911 110,249 87,888 25.441 01 -68- 5582 -102 LABOR OT 11,167 12,674 15,489 9,746 49,077 40,080 22.451 01 -68- 5582 -103 EE EDUCATION 0 0 0 0 7,500 - 100.0091. 01 -68- 5582 -105 SUPPLIES (5) 468 161 136 759 0 100.0^°1, 01 -68- 5582 -106 VEHICLE (168) (94) (86) (21) (369) 875 -142'; SUB -TOTAL 32,193 42,869 54,520 34,065 163,647 161,710 1.20% 01 -68- 5590 -109 SENIOR TECH EXP 61 64 0 0 145 5,000 - 97,101 01 -68- 5590 -101 LABOR REG (4,909) 7,180 10,682 155 13,109 32,665 - 59,871 01 -68 -5590 -102 LABOR OT 449 448 0 281 1,177 4,660 - 74.74% 01 -68- 5590 -103 EE EDUCATION 0 0 405 0 405 4,332 - 90.65% 01 -68 -5590 -105 SUPPLIES 106 165 310 387 968 2,160 - 55,201 01 -68- 5590 -106 VEHICLE (168) (94) (86) (21) (369) 875 - 142.19% 01 -68- 5595 -000 TRANSFORMER MAINT 7,097 3,740 16,550 16,605 43,992 36,168 21.63% 01 -68 -5597 -109 MAINT METERS 531 0 0 0 531 668 - 20.46% 01 -68- 5597 -101 LABOR REG 0 0 0 0 0 755 - 100,001 01 -68- 5597 -102 LABOR OT 0 0 0 0 0 168 - 100.00% 01 -68 -5921 -000 OFFICE SUPPLIES 0 0 0 0 0 332 - 100.00% SUB -TOTAL 3r187 11,504 27,862 17,406 59,958 8-7,783 - 31.70% GRAND TOTAL 179,134 281 752 362,429 269,598 1,092,913 1 238 032 - 11.72% Page 2 12/3/2009 RMLD BUSINESS DIVISION BUDGET VARAANCE REPORT FOR PERIOD ENDING OCTOBER 31, 2009 - - -- ACTUAL BUDGET ACT /BUD YTD YTD VARIANCE ACCOUNTING 59 JUL AUG SEP OCT TOTAL TOTAL % 01 -59- 5903 -101 LABOR REG 13,107 16,160 19,395 14,509 63,170 61,938 1.99% 01 -59- 5903 -102 LABOR OT 0 0 0 0 0 200 - 100.00% 01 -59 -5903 -103 EE EDUCATION 0 0 0 0 0 0 0.00% 01- 59- 5903 -105 SUPPLIES 9,571 33,686 595 27,631 71,483 88,532 - 19.26% 01 -59- 5921 -000 OFFICE SUPPLIES 3,191 20,701 29,833 24,653 78,379 80,000 -2.03% 01 -59- 5923 -000 OUTSIDE SERVICES 0 0 24,000 5,750 29,750 48,000 - 38.02% SUB -TOTAL 25,8 9 70,547 73,623 72,543 242,782 278,670 - 12.88% CUSTOMER SERVICE 62 01- 62- 5903 -101 LABOR REG 32,203 42,301 45,245 37,653 157,402 162,579 -3.18% 01 -62- 5903 -102 LABOR OT 0 0 0 0 0 1,000 - 100.00% 01 -62- 5903 -103 EE EDUCATION 0 0 0 0 0 1,500 - 100.00% 01- 62- 5903 -105 SUPPLIES 156 1,391 1,607 7,280 10,434 5,000 108.67% 01 -62- 5903 -106 VEHICLE (561) (314) (286) (71) (1,232) 1,750 - 170.43% 01 -62- 5903 -109 RES ENERGY AUDITS 0 140 (140) 1,680 1,680 0 100.00% 01- 62- 5904 -000 UNCOLLECT ACCOUNTS 12,500 12,500 12,500 12,500 50,000 50,000 0.00% 01 -62- 5921 -000 OFFICE SUPPLIES 0 13 106 187 306 800 - 61.73% SUB -TOTAL 44,298 56,031 59,032 59,229 218,590 222,629 -1.81% MIS 61 01 -61- 5903 -101 LABOR REG 29,072 34,187 39,909 32,388 135,555 136,162 -0.45% -.62 -5903 -102 LABOR OT 0 0 0 0 0 400 - 100.00% ;1 -5903 -103 EE EDUCATION 0 398 0 0 398 6,000 - 93.3791 -61- 5903 -105 SUPPLIES 1,421 1,799 2,321 2,014 7,554 8,000 -5.57% 01 -61 -5935 -000 MAINT GEN PLANT 5,289 7,890 7,052 10,981 31,214 38,700 - 19.34% 01 -61- 5921 -000 OFFICE SUPPLIES 0 692 104 321 1,117 4,000 - 72.09% SUB -TOTAL 35,782 44,965 49,386 45,704 175,837 193,262 -9.02% MISCELLANEOUS DEDUCTIONS 57/77 01 -77 -5403 -000 DEPRECIATION EXP 280,106 280,106 280,106 280,106 1,120,423 1,130,000 -0.85% 01 -77- 5408 -000 VOLUNTARY PAYMENTS 104,500 104,500 104,500 104,500 418,000 418,000 0.001 01 -77- 5419 -000 INTEREST EXP 1,304 1,277 1,291 1,291 5,162 5,000 3.24% 01 -77 -5426 -000 OTHER DEDUCTIONS 182,225 182,220 182,223 182,223 728,890 728,900 0.00% 01 -77- 5427 -000 INTEREST EXP BONDS 2,222 0 2,224 0 4,446 4,444 0.04% 01 -77- 5428 -000 AMORT DEBT EXP 122 122 122 1,099 1,465 500 192.96% 01 -57- 5920 -101 AC /BUS MGR LABOR REG 174 3,422 3,422 2,738 9,757 11,636 - 16.15% 01 -57- 5930 -109 AC /BUS MGR MISC GEN 0 0 0 85 85 800 - 89.44% SUB -TOTAL 570,653 571,647 573,887 572,040 2,288,227 2 299 280 -0.48% GRAND TOTAL 676,602 743,190 756,128 749,516 2,925,436 2 993 841 -2.28% Page 3 J: 10 1" lvi 12/2/2009 RMLD FACILITY DIVISION BUDGER VARIANCE REPORT FOR PERIOD ENDING OCTOBER 31, 2009 GRAND TOTAL 166,823 190,481 125,314 366,677 849,294 975,357 - 12.92% Page 4 ACTUAL BUDGET ACT /BUD YTD YTD VARIANCE GENERAL BENEFITS 53 JUL AUG SEP OCT TOTAL TOTAL % 01 -53- 5920 -101 LABOR REG 5,213 9,412 9,436 5,924 29,984 28,675 4.565. 01- 53- 5921 -000 OFFICE SUPPLIES 0 0 0 0 0 340 - 100.00% 01 -53- 5930 -103 EE EDUCATION 501 8 0 0 509 1,668 - 69.47% 01 -53- 5930 -105 SUPPLIES 0 0 25 0 25 332 - 92.52% 01 -53- 5923 -000 OUTSIDE SERVICES 0 0 0 0 0 3,332 - 100.00% 01 -53- 5924 -000 PROPERTY INSURANCE 31,020 31,020 34,055 31,399 127,495 147,724 - 13.69% 01 -53- 5925 -000 INJURIES & DAMAGES 3,064 3,060 7,965 3,695 17,783 20,314 - 12.46% 01 -53 -5926 -000 EE PENS & BENEFIT 63,504 57,787 (20,088) 257,256 358,459 381,820 -6.12% 01 -53- 5930 -109 MISC GENERAL 0 0 0 0 0 1,000 - 100.00% 01 -53- 5931 -000 RENT 13,446 13,968 14,001 13,967 55,383 70,668 SUB -TOTAL 116,748 115,255 45,394 312,240 589,637 655,873 - 10.10% TRANSPORTATION 63 01 -63- 5933 -109 MISC GENERAL (160) (40) 10 0 (190) (60,880) - 99.69% 01 -63- 5933 -101 LABOR REG 5,813 1,340 4,868 6,145 18,165 18,616 -2.42% 01 -63- 5933 -102 LABOR OT 428 134 294 667 1,524 2,600 - 41.38% 01 -63- 5933 -103 EE EDUCATION 0 0 0 75 75 1,000 - 92.50% 01 -63- 5933 -105 SUPPLIES (33,182) (16,617) 18,971 (10,310) (41,139) 126,140 - 132.61% LESS ALLOCATION RECLASS 27,101 15,184 (24,143) 3,422 21,564 (87,476) - 124.65% SUB -TOTAL (0) 0 0 (0) (0) 0 0.00% BUILDING MAINTENANCE 64 01 -64- 5923 -000 OUTSIDE SERVICES 0 0 0 0 0 6,676 -100, M'. " 01-64-5932-101 LABOR REG 5,887 10,927 13,274 10,325 40,414 40,628 -0.53% 01 -64- 5932 -102 LABOR OT 373 1,108 2,725 3,848 8,055 4,000 101.37% 01 -64- 5932 -103 EE EDUCATION 0 0 0 0 0 1,000 - 100.00% 01 -64- 5932 -105 SUPPLIES 22,749 36,840 34,787 15,619 109,995 154,910 - 28.99% SUB -TOTAL 29,009 48,876 50,786 29,793 158,464 207,214 - 23.53% MATERIALS MANAGEMENT 60 01 -60- 5588 -109 MISC DIST EXP 1,071 3,771 3,711 3,694 12,247 15,000 - 18.36% 01- 60- 5588 -101 LABOR REG 19,372 21,521 24,769 20,028 85,690 89,418 -4.17% 01 -60- 5588 -102 LABOR OT 0 0 0 0 0 1,332 - 100.00% 01 -60 -5588 -103 EE EDUCATION 0 223 0 66 289 700 - 58.76% 01- 60- 5588 -105 SUPPLIES 623 807 654 856 2,940 5,000 - 41.19% 01 -60- 5588 -104 RFP EXPENSES 0 0 0 0 0 320 - 100.00% 01 -60 -5921 -000 OFFICE SUPPLIES 0 28 0 0 28 500 - 94.41% SUB -TOTAL 21,066 26,350 29,133 24,644 101,194 112,270 -9.87% GRAND TOTAL 166,823 190,481 125,314 366,677 849,294 975,357 - 12.92% Page 4 ;s: 10 rivi 12/2/2009 RMLD GENERAL MANAGER DIVISION BUDGET VARIANCE REPORT FOR PERIOD ENDING OCTOBER 31, 2009 BOARD 58 01 -58- 5930 -109 MISC GENERAL 0 0 1,866 0 1,866 2,500 - 25.38% SUB -TOTAL 0 0 1,866 0 1,866 2,500 - 25.38% GRAND TOTAL 40,189 59,149 57,710 82,750 239,798 278,379 - 13.86% Page 5 ACTUAL BUDGET ACT /BUD YTD YTD VARIANCE GENERAL MANAGER 51 JUL AUG SEP OCT TOTAL TOTAL % 01 -51- 5920 -101 LABOR REG 16,146 19,776 22,754 18,546 77,221 78,819 -2.0391. 01 -51 -5921 -000 OFFICE SUPPLIES 84 110 70 9 274 832 - 67.07% 01 -51- 5923 -000 OUTSIDE SERVICES 0 4,397 934 25,283 30,615 16,668 83.67% 01 -51- 5930 -103 EE EDUCATION 0 0 479 0 479 5,000 - 90.43% 01 -51- 5930 -105 MISC GENERAL 4,364 4,318 4,274 4,281 17,237 18,332 -5.97% 01 -51- 5930 -106 VEHICLE (561) (314) (286) (71) (1,232) 1,750 - 170.4351 SUB -TOTAL 20,033 28,287 28,225 48,048 124,593 121,400 2.63% HUMAN RESOURCES 52 01 -52- 5920 -101 LABOR REG 8,777 11,327 9,349 9,614 39,066 40,565 -3.70% 01 -52 -5921 -000 OFFICE SUPPLIES 0 0 0 0 0 100 - 100.00% 01 -52- 5923 -000 OUTSIDE SERVICES 0 3,176 1,738 15,786 20,700 35,832 - 42.23% 01 -52 -5930 -103 EE EDUCATION 385 125 (480) (50) (20) 4,000 - 100.50% 01 -52- 5930 -105 SUPPLIES 0 0 63 548 611 425 43.75% 01 -52 -5930 -109 MISC GENERAL 237 1,150 984 431 2,802 7,080 - 60.43% SUB -TOTAL 9,399 15,778 11,653 26,330 63,159 88,002 - 28.23% COMMUNITY RELATIONS 54 01 -54 -5920 -101 LABOR REG 5,789 8,193 9,318 6,754 30,054 30,399 -1.14% 01 -54 -5921 -000 OFFICE SUPPLIES 0 0 0 0 0 250 - 100.00% 54 -5930 -109 MISC GENERAL 2,768 6,891 5,147 779 15,585 30,630 - 49.12% 54 -5930 -103 EE EDUCATION 0 0 0 0 0 0 0.00% 01 -54- 5930 -105 SUPPLIES 0 0 0 180 180 250 - 28.00% SUB -TOTAL 8,557 15,084 14,465 7,713 45,819 61,529 - 25.53% CAB 56 01 -56- 5920 -101 LABOR REG 0 0 212 0 212 1,647 - 87.13% 01 -56- 5920 -102 LABOR OT 0 0 0 0 0 400 - 100.0091. 01 -56 -5930 -109 MISC GENERAL 2,200 0 1,289 660 4,149 2,900 43.06% SUB -TOTAL 2,200 0 1,501 660 4,361 4,947 - 11.859. BOARD 58 01 -58- 5930 -109 MISC GENERAL 0 0 1,866 0 1,866 2,500 - 25.38% SUB -TOTAL 0 0 1,866 0 1,866 2,500 - 25.38% GRAND TOTAL 40,189 59,149 57,710 82,750 239,798 278,379 - 13.86% Page 5 - 11 1 - 12/2/2009 RMLD ENERGY SERVICES DIVISION BUDGET VARIANCE REPORT FOR PERIOD ENDING OCTOBER 31, 2009 Page 6 ACT /BUD VARIANCE - 108.88% -0.25% - 54.15% -97.78% -85.37% - 56.21% -55.85% - 100.00% -31.07% -5.85% -32.2651. ACTUAL BUDGET YTD YTD ENERGY SERVICES 75 JUL AUG SEP OCT TOTAL TOTAL 01 -75- 5916 -000 ENERGY SERV EXP 310 310 7,090 (8,894) (1,184) 13,332 01 -75 -5916 -101 LABOR REG 26,544 37,539 39,758 34,614 138,455 138,797 01 -75- 5916 -103 EE EDUCATION 0 997 149 0 1,146 2,500 01 -75- 5916 -109 KEY ACCOUNT 0 37 0 0 37 1,668 01 -75- 5921 -000 OFFICE SUPPLIES 25 0 0 0 25 168 01 -75 -5923 -000 OUTSIDE SERVICES 0 0 18,410 3,488 21,898 50,004 01 -75- 5916 -402 RES CONSERVE PROG 10,391 13,266 12,576 3,751 39,983 90,564 01 -75 -5916 -403 RES CONSERVE OTHER 0 0 0 0 0 6,865 01 -75- 5916 -502 COMM CONSERVE PROG 620 0 5,242 68,809 74,671 108,332 01 -75- 5916 -503 COMM CONSERVE OTHER 3,770 3,770 3,770 3,770 15,080 16,017 GRAND TOTAL 41,660 55,919 86,994 105,539 290,112 428,247 Page 6 ACT /BUD VARIANCE - 108.88% -0.25% - 54.15% -97.78% -85.37% - 56.21% -55.85% - 100.00% -31.07% -5.85% -32.2651. RMLD DEFERRED FUEL CASH RESERVE ANALYSIS 10/31/09 GROSS MONTHLY TOTAL DATE CHARGES REVENUES PASNY CREDIT DEFERRED DEFERRED Jun -09 1,739,394.25 Jul -09 4,071,238.32 3,748,077.09 (3,440.16) (326,601.39) 1,412,792.86 Au9-09 4,051,360.93 4,269,717.20 (35,903.32) 182,452.95 1,595,245.81 Sep -09 2,973,452.04 4,335,754.22 (31,274.85) 1,331,027.33 2,926,273.14 Oct -09 3,206,685.71 3,559,022.94 (41,650.59) 310,686.64 3,236,959.78 RMLD STAFFING REPORT FOR FISCAL YEAR ENDING JUNE, 2010 ACTUAL 10 BUD JUL AUG SEP OCT TOTAL 09 09 09 09 GENERAL MANAGER GENERAL MANAGER 2 2 2 2 2 HUMAN RESOURCES 1.5 1.5 1.5 1.5 1.5 COMMUNITY RELATIONS 1.5 1.5 1.5 1.5 1.5 TOTAL 5 5 5 5 5 BUSINESS ACCOUNTING 2 2 2 2 2 CUSTOMER SERVICE 9 9 9 9 9 MGMT INFORMATION SYS 6 6 6 6 6 MISCELLANEOUS 1 1 1 1 1 TOTAL 18 18 18 18 18 ENGINEERING & OPERATIONS 2 2 2 3 3 AGM E &O ENGINEERING 5 5 5 3 3 LINE 20 18 18 19 19 METER 7 7 7 7 7 STATION 9 9 9 10 10 TOTAL 43 41 41 42 42 PROJECT BUILDING 2 2 2 2 2 GENERAL BENEFITS 2 2 2 2 2 TRANSPORTATION 0 0 0 0 0 MATERIALS MGMT 4 4 4 4 4 TOTAL 8 8 8 8 8 ENERGY SERVICE4 ENERGY SERVICES 6 6 6 6 6 TOTAL 6 6 6 6 6 RMLD TOTAL 80 78 78 79 79 CONTRACTORS UG LINE 2 2 2 2 2 TOTAL 2 2 2 2 2 GRAND TOTAL 82 80 80 81 81 READING MUNICIPAL LIGHT DEPARTMENT Dt: December 11, 2009 To: RMLB, Vincent F. Cameron, Jr., Jeanne Foti Fr: Bob Fournier ij Sj: November 2009 Draft Revenue Report Base revenues for the month were $2,951,574 which is $241,536 or 7.56% under budget. Actual base revenues through November were at $16.8 million compared to the budgeted amount of $17.0 million or 1.2% under budget. Actual year to date base revenues remained flat when compared to last year's actual figure. Kilowatt hour sales for the month of November were down by 4,221,875 compared to last November, making the year to date total decrease 18,760,390 or 5.9 %. To: Vincent Cameron From: Energy Services Date: December 8, 2009 Subject: Purchase Power Summary— October, 2009 Energy Services Division (ESD) has completed the Purchase Power Summary for the month of October 2009. ENERGY The RMLD's total metered load for the month was 54,852,114 kWhs, which was a decrease of 3.87 % compared to October, 2008 figures. Table 1 is a breakdown by source of the energy purchases. TABLE 1 Amount of Cost of % of Total Total $ $ as a Resource Energy Energy Energy Costs % (kWh) ($ /Mwh) Millstone #3 3,702,967 $4.61 6.74% $17,089 0.53% Seabrook 0 $0.00 0.00% $0 0.00% Stonybrook 1,312,850 $56.69 2.39% $74,432 2.32% Constellation 22,320,000 $67.96 40.65% $1,516,923 47.31% PASNY 1,888,317 $0.00 3.44% $9,291 0.29% ISO Interchange 12,211,233 $38.95 22.24% $476,290 14.85% NEMA Congestion 0 $0.00 0.00% - $13,580 -0.42% Coop Resales 52,348 $132.77 0.10% $6,950 0.22% Stonybrook Peaking 55,505 $245.24 0.10% $13,612 0.42% Integrys 12,720,000 $79.84 23.17% $1,015,569 31.67% Braintree Watson Unit 641,398 $140.49 1.17% $90,111 2.81% Monthly Total 54,904,618 $58.40 100.00% $3,206,686 100.00% Resource ISO DA LMP Settlement RT Net Energy Settlement ISO Interchange (subtotal) 12,211,233 39.67 22.24% Table 2 breaks down the ISO interchange between the DA LMP Settlement and the RT Net Energy for month of October, 2009. CAPACI'T'Y The RMLD hit a demand of 93,890 kWs, which occurred on October 28, 2009 at 7 pm. The RMLD's monthly UCAP requirement for October 2009 was 250,315 kWs. Table 3 shows the sources of capacity that the RMLD utilized to meet its requirement. Source Millstone #3 Seabrook Stonybrook Peaking Stonybrook CC Pasny HQICC ISO -NE Supply Auction Braintree Watson Unit Total Table 3 Amount (kWs) Cost ($ /kW- month) Total Cost $ % of Total Cost 4,995 Table 2 $319,147 Amount Cost % of Total of Energy of Energy Energy (kWh) ($ /Mwh) 3.69% 12,339,150 41.74 22.47% - 127,917 18.38 -0.23% 12,211,233 39.67 22.24% Table 2 breaks down the ISO interchange between the DA LMP Settlement and the RT Net Energy for month of October, 2009. CAPACI'T'Y The RMLD hit a demand of 93,890 kWs, which occurred on October 28, 2009 at 7 pm. The RMLD's monthly UCAP requirement for October 2009 was 250,315 kWs. Table 3 shows the sources of capacity that the RMLD utilized to meet its requirement. Source Millstone #3 Seabrook Stonybrook Peaking Stonybrook CC Pasny HQICC ISO -NE Supply Auction Braintree Watson Unit Total Table 3 Amount (kWs) Cost ($ /kW- month) Total Cost $ % of Total Cost 4,995 63.89 $319,147 22.17% 7,904 40.91 $323,365 22.46% 32,456 1.6379375 $53,161 3.69% 50,684 3.3955246 $172,099 11.95% 6,328 1.879853 $11,896 0.83% 5,631 3.93 $22,114 1.54% 131,553 4.08 $537,098 37.30% 10,764 0.09 $942 0.07% 250,315 $5.75 $1,439,821 100.00% TRANSMISSION The RMLD's total transmission costs for the month of October, 2009 are $567,712. This is a 32.55% decrease from the September, 2009 cost of $841,693. In 2008, the transmission costs for the month of October, were $611,750. .. ...... ............ ......... ___... _....... �.w. Table 5 Table 4 ....... .... ...... ........ ........... .._....... Resource Energy Capacity Total cost % of Total Cost Millstone #3 $17,089 $319,147 $336,236 7.24% Seabrook $0 $323,365 $323,365 6.96% Stonybrook $74,432 $172,099 $246,530 5.31% HQ II $0 $22,114 $22,114 0.48% Constellation $1,516,923 $0 $1,516,923 32.65% PASNY $9,291 $11,896 $21,186 0.46% ISO Interchange $476,290 $537,098 $1,013,388 21.81% Nema Congestion - $13,580 $0 - $13,580 -0.29% Coop Resales $6,950 $0 $6,950 0.15% Stonybrook Peaking $13,612 $53,161 $66,773 1.44% Integrys $1,015,569 $0 $1,015,569 21.86% Braintree Watson Unit $90,111 $942 $91,053 1.96% Monthly Total $3,206,686 $1,439,821 $4,646,507 100.00% Table 4 shows the total dollar amounts for energy and capacity per source. TRANSMISSION The RMLD's total transmission costs for the month of October, 2009 are $567,712. This is a 32.55% decrease from the September, 2009 cost of $841,693. In 2008, the transmission costs for the month of October, were $611,750. .. ...... ............ ......... ___... _....... �.w. Table 5 ....... .... ...... ........ ........... .._....... . ................................... Current Month . ................. ............ ............ Last Month _......_..... Last Year ............... .. _..... .......... Peak Demand (kW) 93,890 104,481 97,921 Energy (kWh) 54,904,618 55,562,196 57,092,505 �. .. .,._. ...... ergy ($) _ , _ ..m...� .,......_...� ...... .........�... $3,206,686 .._.._ $2,973,452 �..,.,.... $4,419,355'. ........,... ;Capacity ($) _.......... _ ......... $1,439,821' .......... $1,622,793; _..... $1,526,099 .......... 'Transmission ($) ._,_,.. . ....... $567,712 ....... ..... ... ... . ......... .. $841,693; ....,.. .,., .... . ...... - $611,750' ..........,. . . _..: Total $5,214.219 $5,437,939 $6,557,204 Table 5 shows the current month vs. last month and last year (October, 2008). To: Vincent Cameron From: Energy Services Date: December 11, 2009 Subject: Preliminary Purchased Power Information — November, 2009 The Purchased Power Summary for the month of November, 2009 is incomplete awaiting several invoices. With the available information, the following has been determined for the month of November, 2009. • The RMLD hit a peak of 99,097 kWs, which occurred on November 23 at 6:00 pm. • The RMLD metered load for the month was 52,425,534 kWhs. • The RMLD's metered load decreased by 6.94 % compared to November, 2008. Once the Purchased Power and all financials have been completed for the month of November 2009, copies will be distributed to the members of the RMLD Board. I I I ED O 0 U) 0 U) Q) Q) CD > m '0 co m cc 0- - 0) a) CL C) C) (D 0) M cn C) o cm E W _0 co m co Co co C: CO 0 .0 u� — o E t !Z U) -4-- 0) 0 co m U) U) Cc U) CD (D 0 N E _0 E U) m - 0 C.) E o E U) o U) _0 0) 0 = 0 -0 () -0 -0 (D (1) (1), a) 0 0) 0 CY) E c 0 — — — 0 0 a) E - E .;-- 0 M 0 (D — 2 2 0 0 > co m cc CL 0. a CL a E E E E E 00 E 0 E E 00 E E E E: E C<) (D o —co 0 c a) M C) 0 0 x cc X M a) 0 0 0 0 0 0 0 Q. M m Z E w U) LU cn [if 3: z C) C) C) C) C) -'0 7 C'n "W < M N a1 t6 t4 0 0 rn 0) co 0) 'Z 0) 0) m cn CD C) 0 Q1 O CD C) C) 0) 0 C) 0 0 0 co rl- N N Ul) m E O E r N 0 C) C:) N N 0 0 N O 0 0 C) 0 CD AD E c c o o c) Lo u) c) c) E c) c c o c) Lo to 0 C) 0 0 co C) C) C) co co 0 C) 0 0 0 C:) N N L) 0) m m C3) cn a) C) CD C) 0 0 0 0 0 0 M O CD CC) CO M cn CD 0 C� CD m C) m :? CIJ LO C%4 C N N m N C) m 0 C (D co ti I- Opp 07 N C:) C 0 0 0 0 cn v. -0 a) co E CU L) > 45 a) rt, cm C: E E CD aEi L) F: U) 0 0) 0 E m a) C 0 0 0 0 T L) L— C .=: 0 0) E t Q) cm a_ a) f2 to 0 0 a) a) CL (mo 0 U) o 0 0 -0 E U) 0 C-) o < m 4) C C) C) 0 0 0 C) CD LLJ E (1) cc E C) C: CL to CO L L L L L =3 M 2 .2 — — .2 — .2 .0 — CD U) L) E E E E E m a) cr Lli L) 0 0 z 0 .�= a) O. LU 75 _0 0 0 �2 (D G) , C) cn cn U) U) 0 > U) (n ch cn C: C: C: U) a) 0 -0 L) c cn a) 0 0 0 C: 0 c 0 m 0 -�e c Ln Cl) L) U) L) 0 0 0 0 F– Q/ i-- H H Cf) LL 12/11/2009 READING MUNICIPAL LIGHT DEPARTMENT 10:54 AM FY10 CAPITAL BUDGET VARIANCE REPORT FOR PERIOD ENDING NOVEMBER 30, 2009 ACTUAL YTD ACTUAL COST COST ANNUAL REMAINING # PROJECT DESCRIPTION TOWN NOVEMBER THRU 11/30/09 BUDGET BALANCE 4 kV Retirement - Stepdown Areas 1 Reading 22 Wilmington - Main Street NEW System Projects 2 Station #4 Getaway 4W30 Replacements 3 Station #4 Getaway 4W17 Replacements NEW 4 Salem Street Area 5 High Capacity Tie 4W1 8/3W 8 Franklin Street 6 Haverhill Street - Reconductoring NEW URD Upgrades 7 URD Completions- Sanborn Village, Reading; Perkins Farm, Lynnfield; and Chestnut Village, North Reading New Circuits and Circuit Expansions 8 Salem Street to Glen Rd 131kV Feeder Tie 9 Reading Center -Main Street 10 Reading Center -Haven Street Station Upgrades Station #4 11 Transformer Replacement -Part 1- Contractual Labor 11 Transformer Replacement -Part 2- Procured Equipment 11 Transformer Replacement -Part 3 -RMLD Labor 11 Transformer Replacement -Part 4- Feeder Re- Assignment Station #5 23 15kV Circuit Breaker Replacement NEW New Customer Service Connections 12 Service installations- Commercial /Industrial Customers 13 Service Installations - Residential Customers 14 Routine Construction Various Routine Construction Total Construction Projects Other Projects 15 GIS 16 Transformers /Capacitors Annual Purchases 17 Meter Annual Purchases 18 Purchase Two New Small Vehicles 19 Replace Line Department Vehicles 20 Cooling Towers 21 Security Upgrades 27 Hardware Upgrades 8 Software and Licensing Total Other Projects TOTAL RMLD CAPITAL PROJECT EXPENDITURES R $78,125 $31,415 ($46,710) W R $112,152 $112,152 R $40,269 $133,644 $201,712 $68,068 R $432,405 $170,779 $170,779 W $109,129 $171,923 $62,794 R $129,004 $129,004 R $23,004 $30,298 . $184,460 $154,162 VAR $38,496 $38,496 W $80,063 $80,063 R $5,363 $13,932 $8,569 R $23,311 $23,311 R $2,528 $532,752 $1,231,500 $698,748 R $980 $149,531 $344,800 $195,269 R $31,676 $222,797 $432,405 $209,607 R $186,823 $186,823 $228,159 $228,159 W $200,248 $157,528 $157,528 ALL $7,860 $24,029 $54,184 $30,155 ALL $17,119 $84,047 $176,623 $92,576 ALL $137,116 $605,348 $1,537,896 $932,548 $260,552 $1,975,063 $5,320,343 $3,345,280 $7,600 $40,000 $52,984 $12,984 $1,792 $16,249 $241,389 $225,140 $4,600 $12,740 $139,360 $126,620 $33,544 $62,000 $28,456 $186,823 $186,823 $3537823 $167,000 $200,248 $200,248 $25,000 $25,000 $43,700 $43,700 $1,465 $32,142 $94,410 $62,268 $202.280 $321.498 $1.212.913 $891,415 $462.832 $2,2961561 $6,533,256 $4,236,695 Reading Municipal Light Department Engineering and Operations Monthly Report November, 2009 FY 2010 Capital Plan 4 kV Retirement - Stepdown Areas 1. Reading - Project Complete. 22. Main Street - Wilmington - No activity. System Projects 2. Station #4 Getaway Feeder 4W30 Replacement - Reading - Underground work on Causeway Road including installation of underground cable, splicing and terminations. 3. Station #4 Getaway Feeder 4W17 - Wilmington - No activity. 4. Salem Street Area - Wilmington - Project Complete. 5. High Capacity Tie 4W1813W8 Franklin Street - Reading - No activity. 6. Haverhill Street - Reading /Lynnfield - Framing for new spacer cable and make - ready work continued. Installed messenger, anchors and guys UR® Upgrades 7. URD Completions - Sanborn Village, Reading; Perkins Farm, Lynnfield; and Chestnut Village, North Reading - No activity. New Circuits and Circuit Expansions 8. Salem Street to Glen Road 13 kV Feeder Tie - Wilmington - No activity. 9. Reading Center - Main Street - No activity. 10. Reading Center - Haven Street - No activity. Substation Upgrade Proiects 11. Transformer Replacement - Station 4 - Reading Part 1 - Contractual Labor - Invoices paid to Fischbach and Moore. Part 2 - Procured Equipment - Sundry electrical equipment. Part 3 - RMLD Labor - Relay panel relocations and control wire modifications. Part 4 - Feeder Re- Assignment - No activity. 23. 151kV Circuit Breaker Replacement - Station 5 - Wilmington - No activity. New Customer Service Connections 12. Service Installations — Commercial /Industrial Customers — This item includes new service connections, upgrades, and service replacements for the commercial and industrial customers. This represents the time and materials associated with the replacement of an existing or installation of a new overhead service, the connection of an underground service, etc. This does not include the time and materials associated with pole replacements /installations, transformer replacement/installations, primary or secondary cable replacement/installations etc. This portion of the project comes under routine construction. 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 Setting/Transfers $ 91,134 Maintenance Overhead /Underground $198,283 Projects Assi ned as Required $ 94,411 Pole Damage (includes knockdowns) some reimbursable $ 31,843 Station Group $ 32,190 Hazmat/Oil Spills $ 10,158 Porcelain Cutout Replacement Program $ 47,140* Lighting Street Light Connections $ 12,812 Storm Trouble $ 724 Underground Subdivisions $ 32,155 Miscellaneous Capital Costs $ 54,498 TOTAL $605,348 *In the month of November, 37 cutouts were charged under this program. Approximately seven cutouts were installed new or replaced because of damage making a total of 44 cutouts replaced this month. 29 — Force Accounts — The Commonwealth of Massachusetts requires utility plant equipment relocations in conjunction with various roadway reconstruction projects. No projects scheduled at this time 2 Reliability Report Two key industry standard metrics have been identified to enable the RMLD to measure and track system reliability. A rolling 12 -month view is being used for the purposes of this report. Customer Average Interruption Duration Index (CAIDI) — Measures how quickly the RMLD restores power to customers when their power goes out. CAIDI = Total of Customer Interruption Duration for the Month in Minutes/ Total number of customers interrupted. RMLD System CAIDI — 39.53 minutes Industry Average — 65.91 minutes per outage (APPA 2005 Reliability Survey) On average, RMLD customers that experience an outage are restored in 39.53 minutes. 120.00 N 99.57 100.00 C 80.00 tM d 63. 5 :23 60.00 568 0 44.68 L. 40.00 35.76 36:97 O 1' .26 23.89 20.00 U 0.00 cps 3 System Average Interruption Frequency (SAIFI) — Measures how many outages each customer experiences per year on average. SAIFI = Total number of customer's interrupted / Total number of customers. RMLD System Average - .48 outages per year Industry Average —1.6 outages per year (APPA 2005 Reliability Survey) Top quartile performance for the industry is one outage or less per year. 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 Reading customers have no interruptions. At this time, the average RMLD customer experiences an outage every 25 months. id