The URL can be used to link to this page

Home My WebLink About2009-10-28 RMLD Board of Commissioners MinutesReading Municipal Light Board of Commissioners Regular Session 230 Ash Street Reading, MA 01867 October 28, 2009 Start Time of Regular Session: 7:30 p.m. End Time of Regular Session: 10:02 P.M. Attendees: Commissioners: Mary Ellen O'Neill, Chairman Philip Pacino, Secretary Ellen Kearns, Commissioner Staff: Vinnie Cameron, General Manager Jeanne Foti, Executive Assistant .Jane Parenteau, Energy Services Manager Citizens' Advisory Board: Quincy Vale Guest: Joe Jammallo, Cushing, Jammallo & Wheeler, Inc. Richard Hahn, Vice Chair Robert Soli, Commissioner RECDVED TOW CLERK RE'mNi'C. H Ass. 1009 NOV 23 A 11: 21, Beth Ellen Antonio, Human Resources Manager Robert Fournier, Accounting/Business Manager Kevin Sullivan, Engineering and Operations Manager Opening Remarks/Approval of Meeting Agenda Chairman O'Neill reported that two Commissioners are not currently present and the agenda is tight therefore the agenda will be taken out of order. troductions Chairman O'Neill introduced CAB member Quincy Vale. Ms. Kearns entered the meeting at this point. General Manager's Report - Mr. Cameron Mr. Cameron reported on the following: 1. Chairman O'Neill will be making the presentation to Subsequent Town Meeting that will take place on November 9, 2009. 2. RMLD calendars will be available on December 1, 2009. The RMLD employees are participating in a food drive in three of the towns the RMLD serves. Lynnfield does not have a food pantry. Employees are bringing in items specified by the food pantries. Donations will be accepted until November 20, 2009. Good Neighbor Energy Fund Blanket Drive blanket donations will be accepted until November 18, 2009. The Reading Christmas Lighting ceremony will take place on Sunday, November 29, 2009 from 2-4 p.m. On Friday, Mr. Cameron said he will be attending a conference, "Pursuing All Cost-Effective Demand Resources in New England (and Beyond)" featuring FERC Chair Jon Wellinghoff at Foley Hoag LLP. Quarterly Financial Update - Quarter 1 - Fiscal Year 2010 - Attachment 1 - Mr. Fournier ',,Tr. Fournier presented the Financial Report for Quarter 1 of Fiscal Year 2010. Mr. Fournier reported on the RMLD's new website which has been up one month with favorable comments. Most of the activity on the new website is for the online payment. Regular Session Meeting Minutes October 28, 2009 2 Quarterly Financial Update - Quarter 1 - Fiscal Year 2010 - Attachment 1 - Mr. Fournier MI;-,Hahn asked since RMLD's sales are down six percent if that is consistent with other utilities. Mr. Fournier replied that he has not performed comparisons with other utilities. Mr. Cameron commented that the sales for ,other.utilities are down. NIr. Cameron said that the Department is looking at the commercial sales make up eeause the residential sales have not decreased significantly. The Department is also looking at the sales figures and may reforecast sales for the remainder of the year. Chairman O'Neill said that the Energy Efficiency/Conservation Report would be on the Commission's December agenda. Power Supply Report, September 2009 - Attachment 2 - Ms. Parenteau Ms. Parenteau presented the Power Supply Report for September. Ms. Kearns asked about how the Braintree Watson Unit working capital pre-payments were being treated. Ms. Parenteau replied that she and Mr. Fournier met to look at the Braintree bill. Ms. Parenteau explained that part of the way Braintree billed the RMLD is that they put the working capital for fuel on the bill and melded it with the Fuel Charge. It was booked as an expense for the months of June, July and August. It required the RMLD to take it out of the expense portion and put it in the working capital Mr. Hahn asked about the capacity costs for the Watson Unit as reflected in the attachment. Ms. Parenteau explained that the debt service was booked twice in August rather than an adjustment being made for two months going forward to October. Until the next pre-payment on the debt service is due in February 2010, the Department will accrue costs on the balance sheet as an expense. Engineering and Operations Update, September 2009 - Attachment 3 - Mr. Sullivan Gaw Update Mr. Sullivan reported on the Gaw substation. Mr. Sullivan commented that the Gaw schedule has changed since the soil contamination issue. Mr. Hahn asked if the 11 OC transformer is energized at the Gaw substation. Mr. Sullivan replied affirmatively. Mr. Sullivan reported on the Engineering and Operations Report for September. Mr. Hahn asked in response to Mr. Sullivan's explanation of outages for the month what a neutral wire condition is. Mr. Sullivan explained that occurs when the neutral is broken on the house service. Report of Board Committee Power Contracts, Rate Setting, Green Power Committee - Mr. Hahn Mr. Hahn reported that the Power Contracts, Rate Setting, Green Power Committee met along with Mr. Cameron and RMLD staff. There were three items discussed in public session and they did not go into executive session as previously anticipated. Mr. Hahn stated that the first item was a report on Poly Chlorinated Biphenyls (PCB's) at the Gaw Substation. During the construction and installation of the three new transformers, excavation was required. It was found that some of the soil that was disturbed and placed in a pile did contain these chemicals. At the meeting, there was a draft report prepared by Cushing, Jammallo & Wheeler, Inc. that contained a preliminary plan that describes what was found in their investigation to date. It is Mr. Hahn's understanding that Cushing, Jammallo & Wheeler, Inc. will file a plan on RMLD's behalf with the federal Environmental Protection Agency and the state's Department of Environmental Protection to obtain a plan to permanently remedy the site. The committee went over the report in significant detail at the meeting. Also in attendance at the meeting were residents of Causeway Road. It was helpful to understand where we are and why the construction has been delayed. Mr. Hahn said that Mr. Jammallo, one of the principals of Cushing, Jammallo & Wheeler, Inc. is present this evening to answer any questions. Mr. Vale inquired if there was any indication of groundwater contamination by the PCB's. Mr. Jammallo replied that to date no groundwater sampling has been performed. Excavation to date has reached 13 feet and the groundwater is probably at 25 feet. The expanded testing will include the installation of three monitoring wells. Regular Session Meeting Minutes October 28, 2009 *.port of Board Committee ower Contracts, Rate Setting, Green Power Committee - Mr. Hahn Mr. Soli asked if there have been any checks performed on the perimeter to see if the PCB's were there. Mr. Jammallo replied "yes". Sampling and testing was performed along the two fence lines that abut residential properties, at the northerly boundary and the southeast boundary. No PCB's were identified in any of those forty samples. In response to questions from Chairman O'Neill, Mr. Jammallo said that the final report containing the plan for expanded sampling will be submitted to the EPA by the end of this week. After it is submitted, he will contact the EPA to get a sense of what their turnaround time will be. Approval from the EPA is required before the RMLD can proceed with the additional sampling and site remediation. Braintree Electric Light Department Revised Contract Mr. Hahn said that the RMLD has a unit entitlement contract with Braintree Electric Light Department Watson Unit. There have been amendments to the original agreements, which were explained by Ms. Parenteau and Mr. Seldon. Mr. Pacino entered the meeting at this point. Ms. Kearns asked what the downside to the amended agreement is. Mr. Hahn replied that there is none. It is his understanding that all unit entitlement holders are being asked to sign the amendment. Ms. Parenteau concurred. Mr. Hahn made a motion seconded by Mr. Pacino that the RMLD Board of Commissioners authorize the General Manager to execute the Amended and Restated Unit Power Contract between Braintree Electric Light Department (BELD) and the Reading Municipal Light Department (RMLD) to purchase a unit entitlement, not to exceed ten percent (10%), in the Thomas A. Watson Power Plant based on the recommendation of the Power Contracts, Rate '''etting, and Green Power Committee. _Aotion carried 5:0:0. Concord Steam Mr. Hahn explained that Concord Steam is a renewable energy project that the RMLD looked at several months ago. This project is a wood fired power plant to feed a district heating system in the City of Concord, New Hampshire. As a result of some developments in the project, the price has decreased and the project is being brought back to the Commission. Mr. Hahn said that if you add up the spot costs components and compare it to the cost of the proposed price, the spot prices are a little low but not by very much, 11¢/kWh for Concord Steam and 10¢/kWh for the market. The committee was shown prices for other types of projects such as photovoltaic, solar and even tax-exempt wind whose prices were much higher than Concord Steam. The RMLD is looking at procuring five megawatts from the project. The committee recommended authorizing the General Manager to re-enter negotiations. This is a good opportunity for the Board to add this to the RMLD's portfolio. A motion to recommend this was made and passed at the committee meeting. Ms. Kearns commented that in the past she was in attendance at a committee meeting where this project was discussed. The issue at that meeting for this project was if there was enough wood and the cost of wood. Based on the committee meeting held on Monday more information was provided regarding wood supply. Mr. Hahn stated that there were two reports that described where the wood supply would come from, the volume of supply the project would need, and the proximity of the wood supply. Mr. Hahn said that the information provided on the wood supply was reassuring. -Mr. Vale stated that he is in support of pursuing this project because of the interest the RMLD has in renewable )rojects. Mr. Vale pointed out that he has been involved in some wood projects in the past. He has had an opportunity to talk to the Massachusetts State Forester about the supply of wood and there is an ample supply. Mr. Vale said that he supports this project and the use of wood as a renewable fuel supply in this instance. Regular Session Meeting Minutes October 28, 2009 Report of Board Committee Power Contracts, Rate Setting, Green Power Committee - Mr. Hahn Concord Steam Mr. Hahn made a motion seconded by Mr. Pacino that the RMLD Board of Commissioners authorize the General Manager to re-enter negotiations with Concord Steam Corporation for all market products and attributes of the proposed wood burning plant at a capacity not to exceed 5 MW and for the General Manager to present to the RMLD Board a finalized power supply agreement for execution by the General Manager based on the recommendation of the Power Contracts, Rate Setting, and Green Power Committee. Motion carried 5:0:0. Approval of September 30, 2009 Board Minutes Mr. Hahn made a motion seconded Mr. Pacino to approve the Regular Session meeting minutes of October 28, 2009 with the change presented by Ms. Kearns on page two to replace the word "three" with the word "four". Motion carried 4:0:1. Mr. Soli abstained. General Discussion -Analysis of August, 2009 Fuel Charges - Mr. Soli Chairman O Neill reported that Mr. Soli asked to make a brief remark on his material on the analysis of the August 2009 Fuel Charge. Chairman O'Neill pointed out that the Board did vote on May 27, 2009 that it would take no further action on this matter. Chairman O'Neill wanted Mr. Soli to have the opportunity to make his point. Mr. Soli said that this is relative to the 2009 August Fuel Charges and the Residential Fuel Credit. Mr. Soli noted that the information from RMLD's Annual Report states "all of the benefit from the Niagara Power should go to the residents." In his analysis for the August 2009 Fuel Credit, he computed that 62.2% of the Niagara Power went to the non residential customers. Mr. Soli said that this leads him to believe that the RMLD has a believability problem. 4 Mr. Cameron responded to Mr. Soli's assertions. Mr. Cameron said that the Department's stand on this issue has not changed. The RMLD has had its auditors, Melanson Heath, come in and review how the RMLD calculates the PASNY credit and further how much of that PASNY credit goes back to the customer. Mr. Cameron said that Melanson Heath agrees with the methodology the RMLD utilizes. Mr. Cameron also stated the entire PASNY credit goes back to the residential customers. Chairman O'Neill stated there would be no further discussion on this issue. BOARD MATERIAL AVAILABLE BUT NOT DISCUSSED Rate Comparisons, September 2009 E-Mail responses to Account Payable/Payroll Questions Upcoming Meetings Monday, November 9, Subsequent Town Meeting - Chairman O'Neill will also attend the pre-Town Meeting, meeting. Wednesday, November 18, RMLD Board of Commissioners Wednesday, December 23; RMLD Board of Commissioners (possibly earlier start time) CAB Rotation Secretary Pacino will cover the November 30 CAB meeting. Executive Session At 8:35 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, and to return to Regular Session for the release of Executive Session minutes and subsequent adjournment. Motion carried by a polling of the Board 5:0:0. Mr. Soli, Aye; Ms. Kearns, Aye; Chairman O'Neill, Aye; Mr. Hahn, Aye; and Mr. Pacino, Aye. The Board re-entered Regular Session at 10:00 p.m. Regular Session Meeting Minutes October 28, 2009 elease of Executive Session Minutes -Ar. Hahn made a motion seconded by Mr. Pacino that the Reading Municipal Light Department Board of Commissioners approve the release of the Executive Session meeting minutes, as redacted, from January 9, 2003, January 23, 2003, February 13, 2003, February 27, 2003, March 13, 2003, March 27, 2003 and April 22, 2003. Motion carried 5:0:0. Adjournment At 10:02 p.m. Mr. Hahn made a motion seconded by Mr. Pacino 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 Dt: October 23, 2009 To: RMLB, Vincent F. Cameron, Jr., Jeanne Foti Fr: Bob Fournier Sj: September 2009 Report The results for the first three months ending September 30, 2009, for the fiscal year 2010 will be summarized in the following paragraphs. Overall, the year to date results are positive. GAW Substation incident is still ongoing. 1) Change in Net Assets or Net Income: (Page 3A) Net income or the positive change in net assets for the first three months was $1,852,995. The budgeted net income for this period was $1,294,671, resulting in net income being over budget by $558,323, or 43.2%. The difference between the actual fuel expense and the actual fuel revenue is $1,257498, with revenues exceeding expenses. 2) Revenues: (Page 11B) Base revenues were under budget by $588,536 or 5.1%. Actual base revenues were at $10.8 million compared to the budgeted amount of $11.4 million. Only the residential sector was over budget. 3) Expenses: (Page 12A) *Purchased power base expense was $182,016 or 2.51%0 over budget. Actual purchased power base costs were $7.4 million compared to the budgeted amount of $7.2 million. *Operating and Maintenance (O&M) expenses combined were under budget by $593,194 or 21.9%. Actual O&M expenses were $2.1 million compared to the budgeted amount of $2.7 million. The major expenses that were under budget are energy audit expense and conservation ($107,000), overhead maintenance ($44,000), employee pension/benefits ($198,000) and professional services ($56,000). *Depreciation expense and voluntary payments to the Towns were on budget. 4) Cash: (Page 9) *Operating Fund balance was at $4,285,835. *Capital Funds balance was at $5,524,782. '''Rate Stabilization Fund balance was at $5,257,417. "Deferred Fuel Fund balance was at $2,926,273. 5) General Information: TBA 6) Budget Variance: All five divisions were under budget cumulatively by $600,270, or 13.5%. 7) Trends: The fuel charge remained at $.0665 in September. TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS-TYPE PROPRIETARY FUND STATEMENT OF NET ASSETS 9/30/09 ASSETS CURRENT UNRESTRICTED CASH (SCH A P.9) RESTRICTED CASH (SCH A P.9) RESTRICTED INVESTMENTS (SCH A P.9) RECEIVABLES, NET (SCH B P.10) PREPAID EXPENSES (SCH B P.10) INVENTORY TOTAL CURRENT ASSETS NONCURRENT INVESTMENT IN ASSOCIATED CO (SCH C P.2) CAPITAL ASSETS, NET (SCH C P.2) OTHER ASSETS (SCH C P.2) TOTAL NONCURRENT ASSETS TOTAL ASSETS PREVIOUS YEAR CURRENT YEAR 9,004,392.18 12,383,127.75 4,400,000.00 10,538,618.58 1,167,468.40 1,526,948.63 39,020,555.54 122,391.17 61,284,033.66 18,633.90 4,288,835.90 13,756,638.22 4, 400, 000.00 9,812,819.85 1,262,960.65 1,496,241.63 35,017,496.25 108,967.43 64,775,402.64 15,622.27 61,425,058.73 64,899,992.34 100,445,614.27 99,917,488.59 LIABILITIES CURRENT ACCOUNTS PAYABLE 6,367,420.70 5,297,030.07 CUSTOMER DEPOSITS 483,431.29 493,602.07 CUSTOMER ADVANCES FOR CONSTRUCTION 691,757.17 705,309.36 ACCRUED LIABILITIES 402,925.09 625,312.40 CURRENT PORTION OF BONDS PAYABLE 550,000.00 0.00 TOTAL CURRENT LIABILITIES 8,495,534.25 7,121,253.90 NONCURRENT BONDS PAYABLE, NET OF CURRENT PORTION 0.00 0.00 ACCRUED EMPLOYEE COMPENSATED ABSENCES 2,682,217.58 2,873,114.33 TOTAL NONCURRENT LIABILITIES 2,682,217.58 2,873,114.33 TOTAL LIABILITIES 11,177,751.83 9,994,368.23 NET ASSETS INVESTED IN CAPITAL ASSETS, NET OF RELATED DEBT 60,734,033.66 64,775,402.64 RESTRICTED FOR DEPRECIATION FUND (P.9) 3,746,008.08 5,008,575.87 UNRESTRICTED 24,787,820.70 20,139,141.85 TOTAL NET ASSETS (P.3) 89,267,862:44 89,923,120.36 TOTAL LIABILITIES AND NET ASSETS 100,445,614.27 99,917,488.59 (1) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT NONCURRENT ASSET SCHEDULE 9/30/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 SCHEDULE C PREVIOUS YEAR 46,153.24 76,237.93 122,391.17 1,265,842.23 7,288,907.18 6,966,361.65 43,926,322.60 59,447,433.66 1,836,600.00 CURRENT YEAR 41,937.50 67,029.93 108,967.43 1,265,842.23 6,997,417.80 11,760,574.52 44,751,568.09 0.00 61,284,033.66 64,775,402.64 14,523.70 14,523.70 4,110.20 1,098.57 18,633.90 15,622.27 61,425,058.73 64,899,992.34 (2) TOWN OF. READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS-TYPE PROPRIETARY FUND STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND NET ASSETS 9/30/09 MONTH MONTH LAST YEAR CURRENT YEAR YTD LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE OPERATING REVENUES: (SCH D P.11) BASE REVENUE FUEL REVENUE PURCHASED POWER CAPACITY FORFEITED DISCOUNTS ENERGY CONSERVATION REVENUE PASNY CREDIT TOTAL OPERATING REVENUES OPERATING EXPENSES: (SCH E P.12) PURCHASED POWER BASE PURCHASED POWER FUEL OPERATING. MAINTENANCE DEPRECIATION VOLUNTARY PAYMENTS TO TOWNS TOTAL OPERATING EXPENSES OPERATING INCOME ERATING 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 SEPTEMBER 3,289,859.57 3,672,441.83 10,553,570.20 10,805,012.92 2.38% 6,105,632.95 4,335,754.22 18,816,321.21 12,353,548.51 -34.351 615,744.93 345,388.37 1,003,255.22 675,099.29 -32.711 78,104.32 75,978.81 218,422.68 205,263.69 -6.02% 0.00 52,400.16 0.00 152,304.76 100.00% 0.00 (31,274.85) 0.00 (70,618.33) 100.00% 10,089,341.77 8,450,688.54 30,591,569.31 24,120,610.84 -21.15% 2,163,583.72 2,475,027.86 6,686,196.55 7,421,401.77 11.001 4,735,865.70 2,973,452.04 18,202,111.04 11,096,051.29 -39.04% 738,191.46 601,510.22 1,992,125.88 1,677,027.46 -15.821 274,498.48 216,563.67 642,029.92 437,278.02 -31.89% 261,200.00 280,105.78 783,600.00 840,317.34 7.24% 100.750.00 104.500.00 302,250.00 313.500.00 3.72% 8,274,089.36 6,651,159.57 28,608,313.39 21,785,575.88 -23.859. 1,815,252.41 1,799,528.97 1,983,255.92 2,335,034.96 17.740 12,236.20 5,235.78 57,029.89 10,448.71 -81.68% (176,060.50) (182,222.50) (528,181.50) (546,667.50) 3.50% 21,004.46 6,243.16 89,335.96 38,652.41 -56.73% (4,012.95) (3,514.53) (11,868.20) (8,316.94) -29.92% 10,908.45 10,509.61 55,261.68 23,842.91 -56.850 (135,924.34) (163,748.48) (338,422.17) (482,040.41) 42.44% 1,679,328.07 1,635,780.49 1,644,833.75 1,852,994.55 12.66% 87,623,028.69 88,070,125.81 0.510 89 267 862.44 89,923,120.36 0.73% (3) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS-TYPE PROPRIETARY FUND STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND NET ASSETS 9/30/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 ACTUAL BUDGET % YEAR TO DATE YEAR TO DATE VARIANCE* CHANGE 10,805,012.92 11,393,549.00 (588,536.08) -5.17% 12,353,548.51 12,167,656.00 185,892.51 1.53% 675,099.29 900,000.00 (224,900.71) -24.99% 205,263.69 250,659.00 (45,395.31) -18.11% 152,304.76 171,092.00 (18,787.24) -10.98% (70,618.33) 0.00 (70,618.33) 100.00% 24,120,610.84 24,882,956.00 (762,345.16) -3.06% 7,421,401.77 7,239,385.00 182,016.77 2.51% 11,096,051.29 12,167,656.00 (1,071,604.71) -8.81% 1,677,027.46- 2,170,325.00 (493,297.54) -22.73% 437,278.02 537,175.00 (99,896.98) -18.60%_ 840,317.34 847,500.00 (7,182.66) -0.85% 313,500.00 313,500.00 0.00 0.00% 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 21,785,575.88 23,275,541.00 (1,489,965.12) -6.405. 2,335,034.96 1,607,415.00 727,619.96 45.279o 10,448.71 100,000.00 (89,551.29) -89.55% (546,667.50) (546,675.00) 7.50 0.009o 38,652.41 112,500.00 (73,847.59) -65.64% (8,316.94) (81194.00) (122.94) 1.50% 23,842.91 29,625.00 (5,782.09) -19.525. (482,040.41) (312,744.00) (169,296.41) 54.13% 1,852,994.55 1,294,671.00 558,323.55 43.12% NET ASSETS AT BEGINNING OF YEAR 88,070,125.81 88,070,125.81 0.00 0.009. NET ASSETS AT END OF SEPTEMBER 89,923,120.36 89,364,796.81 558,323.55 0.629. * ( ) = ACTUAL UNDER BUDGET (3A) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT RECONCILIATION OF.CAPITAL FUNDS 9/30/09 SOURCE OF CAPITAL FUNDS: DEPRECIATION FUND BALANCE 7/1/09 CONSTRUCTION FUND BALANCE 7/1/09 INTEREST ON DEPRECIATION FUND FY 10 DEPRECIATION TRANSFER FY 10 FORCED ACCOUNTS REIMBURSEMENT GAW SUBSTATION (FY 10) TOTAL SOURCE OF CAPITAL FUNDS USE OF CAPITAL FUNDS: PAID ADDITIONS TO PLANT THRU SEPTEMBER PAID ADDITIONS TO GAW THRU SEPTEMBER GENERAL LEDGER CAPITAL FUNDS BALANCE 9/30/09 PAID ADDITIONS TO GAW FROM FY 09 PAID ADDITIONS TO GAW FROM FY 08 TOTAL 4,403,129.56 11000,000.00 8,524.72 840,317.34 0.00 231,441.00 6,483,412.62 727,.189.04 231,441.00 5,524,782.58 3,136,764.00 1,895,975.00 5,032,739.00 (4) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SALES OF KILOWATT HOURS 9/30/09 MONTH MONTH LAST YEAR CURRENT YEAR YTD % SALES OF ELECTRICITY: LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE RESIDENTIAL SALES 21,378,686 23,692,725 73,580,543 70,626,721 -4.01% COMM. AND INDUSTRIAL SALES 42,043,295 38,854,473 123,942,276 112,328,783 -9.379o PRIVATE STREET LIGHTING 70,813 70,628 214,203 212,697 -0.70% TOTAL PRIVATE CONSUMERS 63,492,794 62,617,826 197,737,022 183,168,201 -7.3796 MUNICIPAL SALES: STREET LIGHTING 241,511 237,183 724,493 711,549 -1.79% MUNICIPAL BUILDINGS 925,116 895,898 4,405,350 2,554,615 -42.01% TOTAL MUNICIPAL CONSUMERS 1,166,627 1,133,081 5,129,843 3,266,164 -36.33% SALES FOR RESALE 297,494 349,866 1,024,498 970,585 -5.26% SCHOOL 0 1,101,901 0 2,969,480 100.00% TOTAL KILOWATT HOURS SOLD 64,956,915 65,202,674 203,891,363 190,374,430 -6.6391. (5) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT KILOWATT HOURS SOLD BY TOWN 9/30/09 TOTAL READING LYNNFIELD NO.READING WILMINGTON MONTH RESIDENTIAL 23,692,725 7',870,066 2,829,130 6,143,582 6,849,947 COMM-& IND 38,854,473 4,797,718 334,850 6,258,812 27,463,093 PVT ST LIGHTS 70,628 14,171 1,360 20,689 34,408 PUB ST LIGHTS 237,183 78,631 32,851 39,688 86,013 MUNI BLDGS 895,898 219,333 157,243 182,622 336,700 SALES/RESALE 349,866 349,866 0 0 0 SCHOOL 1,101,901 415,735 242,575 115,240 328,351 TOTAL 65,202,674 13,745,520 3,598,009 12,760,633 35,098,512 YEAR TO DATE RESIDENTIAL 70,626,721 21,595,561 10,438,657 16,374,729 22,217,774 COMM & IND 112,328,783 13,941,101 919,109 17,495,037 79,973,536 PVT ST LIGHTS 212,697 42,869 4,080 62,331 103,417 PUB ST LIGHTS 711,549 235,893 98,553 119,064 258,039 MUNI BLDGS 2,554,615 626,549 438,878 510,915 978,273 SALES/RESALE 970,585 970,585 0 0 0 SCHOOL 2,969,480 1,158,252 656,673 327,160 827,395 TOTAL 190,374,430 38,570,810 12,555,950 34,889,236 104,358,434 LAST YEAR TO DATE RESIDENTIAL 73,580,543 22,947,629 10,890,909 17,017,819 22,724,186 COMM & IND 128,347,626 16,911,809 2,087,933 22,473,209 86,874,675 PVT ST LIGHTS 214,203 41,217 4,120 66,407 102,459 PUB ST LIGHTS 724,493 249,351 98,553 118,658 257,931 MUNI BLDGS 0 0 0 0 0 SALES/RESALE 1,024,498 1,024,498 0 0 0 SCHOOL 0 0 0 0 0 TOTAL 203,891,363 41,174,504 13,081,515 39,676,093 109,959,251 KILOWATT HOURS SOLD TO TOTAL TOTAL READING LYNNFIELD NO.READING WILMINGTON MONTH RESIDENTIAL 36.34% 12.07% 4.34% 9.42% 10.51% COMM & IND 59.59% 7.36% 0.51% 9.60% 42.12% PVT ST LIGHTS 0.11% 0.02% 0.00% 0.03% 0.06% PUB ST LIGHTS 0.36% 0.12% 0.05% 0.06% 0.13% NMI BLDGS 1.37% 0.34% 0.24% 0.28s. 0.51% SALES/RESALE 0.54% 0.54% 0.00% 0.00% 0.00% SCHOOL 1.69% 0.64% 0.37% 0.18% 0.509. TOTAL 100.00% 21.09% 5.51% 19.57% 53.83% YEAR TO DATE RESIDENTIAL 37.10% 11.34% 5.48% 8.6091. 11.68% COMM & IND 59.01% 7.32% 0.48% 9.19% 42.02% PVT ST LIGHTS 0.11% 0.02% 0.00% 0.03% 0.06% PUB ST LIGHTS 0.37% 0.12% 0.05% 0.06% 0.14% MUNI BLDGS 1.34% 0.33% 0.23% 0.2791. 0.519. SALES/RESALE 0.51% 0.51% 0.00% 0.0096 0.00% SCHOOL 1.56% 0.61% 0.34% 0.17% 0.44% TOTAL 100.00% 20.25% 6.58% 18.32% 54.85% LAST YEAR TO DATE RESIDENTIAL 36.09% 11.25% 5.34% 8.35% 11.15% COMM & IND 62.94% 8.29% 1.02% 11.0291. 42.61% PVT ST LIGHTS 0.11% 0.02% 0.00% 0.03% 0.06% PUB ST LIGHTS 0,36% 0.12% 0.05% 0.06% 0.13% MUNI BLDGS 0.00% 0.00% 0.00% 0.00% 0.00% SALES/RESALE 0.50% 0.50% 0.00% 0.00% 0.00% SCHOOL 0.00% 0.00% 0.00% 0.00% 0.00% TOTAL 100.00% 20.18% 6.41% 19.46% 53.95% (6) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT FORMULA INCOME 9/30/09 TOTAL OPERATING REVENUES (P.3) ADD:' POLE RENTAL INTEREST INCOME ON CUSTOMER DEPOSITS LESS: OPERATING EXPENSES (P.3) BOND INTEREST EXPENSE CUSTOMER DEPOSIT INTEREST EXPENSE FORMULA INCOME (LOSS) 24,120,610.84 0.00 860.42 (21,785,575.88) (4,445.77) (3,871.17) 2,327,578.44 (7) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT GENERAL STATISTICS 9/30/09 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 MONTH OF SEP 2008 64,956,915 60,996,650 0.035471 0.050647 0.113112 0.144642 6,105,632.95 59.8851. 139,540 MONTH OF . CHANGE YEAR THRU SEP 2009 2008 2009 SEP 2008 SEP 2009 65,202,674 -1.01% -6.630 203,891,363 190,374,430 55,562,196 -2.08% -5.07% 202;291,338 192,027,268 0.044545 20.40% 16.93% 0.033052 0.038648 0.056323 -1.36% 9.65% 0.051761 0.056757 0.098061 78.31% -21.62% 0.123032 0.096431 0.122820 51.66% -15.55% 0.144047 0.121647 4,335,754.22 114.93% -34.35% 18,816,321.21 12,353,548.51 72.85% 104,481 (8) 60 d9S W i ! ~ i ! I 60 and VJ ~ ! ~ i I 601nr C- 60 Nnr (n VJ 60 AM O 60 UdH U 0 I j 60 UVA r11 V l~ n1 60 99d 60 NVr (D (D I 80 034 v, tz tz i 16+- j so noN j , 80100 I 80 d3S 80 and so Nnr 80 Nnr 80 AHA 80 )JdH I I 80 UVA I I 80 93d I 80 Ndr ! ! Lo 0B4 ELI LO AON LO 100 LO d3S Lo and LO IM j LO Nnr LO AHW LO Hdd LO UM LO 9:1d I j LO NVr 90 0Da i 90 AON 90 100 I ! 90 d3S I "r- o M t~ LO 't- N -T- r 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ta 69- 69- 60- (Da 6c> 09- 6s TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF CASH AND INVESTMENTS 9/30/09 SCHEDULE A PREVIOUS YEAR CURRENT YEAR UNRESTRICTED CASH CASH - OPERATING FUND 9,001,392.18 4,285,835.90 CASH - PETTY CASH 3,000.00 3,000.00 TOTAL UNRESTRICTED CASH 9,004,392.18 4,288,835.90 RESTRICTED CASH CASH - DEPRECIATION FUND 3,746,008.08 5,008,575.87 CASH - CONSTRUCTION FUND 1,029,707.82 516,206.71 CASH - TOWN PAYMENT 830,400.00 860,175.00 CASH - BOND PAYMENTS 145,200.00 0.00 CASH - DEFERRED FUEL RESERVE 1,519,540.87 2,926,273.14 CASH - RATE STABILIZATION FUND 3,203,678.35 2,357,417.40 CASH --"UNCOLLECTIBLE ACCTS RESERVE 28,988.15 28,988.15 CASH - SICK LEAVE BENEFITS 1,210,921.47 1,380,148.16 CASH - INSURANCE RESERVE 35,251.72 35,251.72 CASH - HAZARD WASTE RESERVE 150,000.00 150,000.00 CASH - CUSTOMER DEPOSITS 483,431.29 493,602.07 TOTAL RESTRICTED CASH 12,383,127.75 13,756,638.22 RESTRICTED INVESTMENTS RATE STABILIZATION * 2,900,000.00 2,900,000.00 SICK LEAVE BENEFITS 1,500,000.00 1,500,000.00 TOTAL RESTRICTED INVESTMENTS 4,400,000.00 4,400,000.00 TOTAL CASH BALANCE 25,787,519.93 22,445,474.12 SEPTEMBER 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 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%; MATURITY 11/13/17 SEPTEMBER 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 1,400,000.00; DTD 05/08/08; INT 3.50%; MATURITY 11/15/13 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%; MATURITY 01/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%; MATURITY 11/13/17 (9) SCHEDULE OF ACCOUNTS RECEIVABLE TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF ACCOUNTS RECEIVABLE 9/30/09 PREVIOUS YEAR RESIDENTIAL AND COMMERCIAL 5,894,260.98 ACCOUNTS RECEIVABLE - OTHER 283,106.48 ACCOUNTS RECEIVABLE - LIENS 49,868.13 ACCOUNTS RECEIVABLE - EMPLOYEE ADVANCES 1,067.16 SALES DISCOUNT LIABILITY (261,720.73) RESERVE FOR UNCOLLECTIBLE ACCOUNTS (190,325.19) TOTAL ACCOUNTS RECEIVABLE BILLED 5,776,256.83 UNBILLED ACCOUNTS RECEIVABLE 4,762,361.75 TOTAL ACCOUNTS RECEIVABLE, NET SCHEDULE OF PREPAYMENTS PREPAID INSURANCE PREPAYMENT PURCHASED POWER PREPAYMENT PASNY PREPAYMENT WATSON TOTAL PREPAYMENT * ACCOUNTS RECEIVABLE AGING SEPTEMBER 2009: RESIDENTIAL AND COMMERCIAL LESS: SALES DISCOUNT LIABILITY GENERAL LEDGER BALANCE CURRENT 30 DAYS 60 DAYS 90 DAYS OVER 90 DAYS TOTAL 10,538,618.58 673,350.71 126,100.29 368,017.40 0.00 1,167,468.40 SCHEDULE B CURRENT YEAR 5,829,701.14 223,187.95 98,922.67 1,067.16 (312,778.86) (200,224.79) 5,639,875.27 4,172,944.58 9,812,819.85 732,103.82 79,939.99 324,535.66 126,381.18 1, 262, 960. 65 5,829,701.14 (312,778.86) 5,516,922.28 4, 810, 129.04 87.20% 480,151.59 8.70% 128,802.59 2.33% 32,185.86 0.58% 65,653.20 1.19% 5,516,922.28 100.00% (10) TOWN OF READING, MASSACHUSETTS MUNICI PAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REVENUE 9/30/09 SCHEDULE D MONTH MONTH LAST YEAR CURRENT YEAR YTD SALES OF ELECTRICITY: LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE RESIDENTIAL SALES 3,350,642.82 3,194,028.75 11,412,679.42 9,428,580.56 -17.39% COMM AND INDUSTRIAL SALES 5,662,063.04 4,460,485.98 16,819,970.77 12,749,647.95 -24.20% PRIVATE STREET LIGHTING 12,331.15 10,574.80 37,006.84 31,471.77 -14.96% TOTAL PRIVATE CONSUMERS 9,025,037.01 7,665,089.53 28,269,657.03 22,209,700.28 -21.44°1 MUNICIPAL SALES: STREET LIGHTING 53,447.44 46,979.43 159,445.82 139,880.26 -12.27% MUNICIPAL BUILDINGS 267,566.69 110,438.24 772,292.05 311,892.57 -59.61% TOTAL MUNICIPAL CONSUMERS 321,014.13 157,417.67 931,737.87 451,772.83 -51.51% SALES FOR RESALE 49,441.38 44,990.60 168,496.51 123,636.97 -26.62% SCHOOL 0.00 140,698.25 0.00 373,451.35 100.00% SUB-TOTAL 9,395,492.52 8,008,196.05 29,369,891.41 23,158,561.43 -21.15% FORFEITED DISCOUNTS 78,104.32 75,978.81 218,422.68 205,263.69 -6.02% PURCHASED POWER CAPACITY 615,744.93 345,388.37 1,003,255.22 675,099.29 -32.71% ENERGY CONSERVATION - RESIDENTIAL 0.00 11,850.66 0.00 35,329.68 100.00% ENERGY CONSERVATION - COMMERCIAL 0.00 40,549.50 0.00 116,975.08 100.00% PASNY CREDIT 0.00 (31,274.85) 0.00 (70,618.33) 100.00% TOTAL REVENUE 10,089,341.77 8,450,688.54 30,591,569.31 24,120,610.84 -21.15% (11) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REVENUE BY TOWN 9/30/09 TOTAL READING LYNNFIELD NO.READING WILMINGTON MONTH RESIDENTIAL 3,194,028.75 1,062,220.10 381,364.29 826,172.53 924,271.83 INDUS/NUNI BLDG 4,570,924.22 603,083.29 59,492.81 750,028.03 3,158,320.09 PUB.ST.LIGHTS 46,979.43 16,261.39 5,825.42 7,795.76 17,096.86 PRV.ST.LIGHTS 10,574.80 2,073.61 204.00 3,236.31 5,060.88 CO-OP RESALE 44,990.60 44,990.60 0.00 0.00 0.00 SCHOOL 140,698.25 52,619.48 30,478.69 15,683.96 41,916.12 TOTAL 8,008,196.05 1,781,248.47 477,365.21 1,602,916.59 4,146,665.78 THIS YEAR TO DATE RESIDENTIAL 9,428,580.56 2,890,163.32 1,385,556.37 2,192,775.65 2,960,085.22 INDUS/MUNI BLDG 13,061,540.53 1,727,260.58 164,511.34 2,070,841.14 9,098,927.46 PUB.ST.LIGHTS 139,880.26 48,433.41 17,329.71 23,210.25 50,906.89 PRV.ST.LIGHTS 31,471.76 6,207.22 605.33 9,648.09 15,011.13 CO-OP RESALE 123,636.97 123,636.97 0.00 0.00 0.00 SCHOOL 373,451.35 144,469.44 80,686.89 43,572.68 104,722.34 TOTAL 23,158,b61.43 4,940,170.94 _l, 648, 689.62 4,340,047.82 12,229,653.05 LAST YEAR TO DATE RESIDENTIAL 11,412,679.42 3,569,578.28 1,681,322.44 2,641,842<46 3,519,936.24 INDUS/MUNI BLDG 17,592,262.82 2,387,232.92 299,789.01 3,083,764.30 11,821,476.59 PUB.ST.LIGHTS 159,445.82 56,435.65 19,755.66 26,027.70 57,226.81 PRV.ST.LIGHTS 37,006.84 7,010.43 718.80 11,919.53 17,358.08 CO-OP RESALE 168,496.51 168,496.51 0.00 0.00 0.00 SCHOOL 0.00 TOTAL 29,369,891.41 6,188,753.79 2,001,585.91 5,763,553.99 15,415,997.72 PERCENTAGE OF OPERATING INCOME TO TOTAL TOTAL READING LYNNFIELD NO.READING WILMINGTON MONTH RESIDENTIAL 39.88% 13.26% 4.76% 10.32% 11.54% INDUS/MUNI BLDG 57.08% 7.53% 0.74% 9.37% 39.44% PUB.ST.LIGHTS 0.59% 0.20% 0.07% 0.109, 0.21% PRV.ST.LIGHTS 0.13% 0.03% 0.00% 0.04% 0.06% CO-OP RESALE 0.56% 0.56% 0.00% 0.00% 0.00% SCHOOL 1.76% 0.66% 0.38% 0.2051 0.52% TOTAL 100.00% 22.24% 5.96% 20.02% 51.78% THIS YEAR TO DATE RESIDENTIAL 40.71% 12.48% 5.98% 9.47% 12.78% INDUS/MUNI BLDG 56.41% 7.46% 0.71% 8.94% 39.30% PUB.ST.LIGHTS 0.60% 0.21% 0.07% 0.10% 0.22% PRV.ST.LIGHTS 0.14% 0.03% 0.00% 0.04% 0.07% CO-OP RESALE 0.53% 0.53% 0.00% 0.00% 0.00% SCHOOL 1.61% 0.62% 0.35% 0.19% 0.45% TOTAL 100.00% 21.33% 7.11% 18.74% 52.82% LAST YEAR TO DATE RESIDENTIAL 38.86% 12.15% 5.72% 9.00% 11.99% INDUS/MUNI BLDG 59.90% 8.13% 1.02% 10.50% 40.25% PUB.ST.LIGHTS 0.54 % 0.19% 0.07% 0.09% 0.19% PRV.ST.LIGHTS 0.13% 0.03% 0.00% 0.04% 0.06% CO-OP RESALE 0.57% 0.57% 0.00% 0.00% 0.00% SCHOOL 0.0091. 0.00% 0.00% 0.00% 0.00% TOTAL 100.00% 21.0791. 6.81% 19.63% 52.49% (11A) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED REVENUE VARIANCE REPORT 9/30/09 SCHEDULE F ACTUAL BUDGET % YEAR TO DATE YEAR TO DATE VARIANCE * CHANGE SALES OF ELECTRICITY: RESIDENTIAL 4,839,551.39 4,769,037.00 70,514.39 1.48% COMM AND INDUSTRIAL SALES PRIVATE STREET LIGHTING 5,630,327.26 6,215,549.00 (585,221.74) -9.42% MUNICIPAL BUILDINGS PUBLIC STREET LIGHTING 93,748.23 129,819.00 (36,070.77) -27.79%" SALES FOR RESALE 60,454.07 66,516.00 (6,061.93) -9.11% SCHOOL 180,931.97 212,628.00 (31,696.03) .-14.91% TOTAL BASE SALES 10,805,012.92 11,393,549.00 (588,536.08) -5.17% TOTAL FUEL SALES 12,353,548.51 12,167,656.00 185,892.51 1.53% TOTAL OPERATING REVENUE 23,158,561.43 23,561,205.00 (402,643.57) -1.71% FORFEITED DISCOUNTS 205,263.69 250,659.00 (45,395.31) -18.11% PURCHASED POWER CAPACITY 675,099.29 900,000.00 (224,900.71) -24.99% ENERGY CONSERVATION - RESIDENTIAL 35;329.68 51,327.00 (15,997.32) -31.17% ENERGY CONSERVATION - COMMERCIAL 116,975.08 119,765.00 (2,789.92) -2.33% PASNY CREDIT (70,618.33) 0.00 (70,618.33) 100.00% TOTAL OPERATING REVENUES 24,120,610.84 24,882,956.00 (762,345.16) -3.06% * ( ) = ACTUAL UNDER BUDGET (I IB) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING EXPENSES 9/30/09 SCHEDULE E MONTH MONTH LAST YEAR CURRENT YEAR YTD % OPERATION EXPENSES: LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE PURCHASED POWER BASE EXPENSE 2,163,583.72 2,475,027.86 6,686,196.55 7,421,401.77 11.00% OPERATION SUPER AND ENGIN-TRANS 0.00 0.00 0.00 0.00 0.00% OPERATION SUP AND ENGINEERING EXP 32,066.75 39,316.66 100,529.80 88,304.22 -12.16% STATION SUP LABOR AND MISC 9,048.76 3,041.18 24,854.47 3,792.34 -84.74% LINE MISC LABOR AND EXPENSE 36,881.25 40,259.95 140,438.23 147,202.51 4.82% STATION LABOR AND EXPENSE 50,885.35 51,883.41 130,042.56 126,194.80 -2.96% STREET LIGHTING EXPENSE 4,313.63 4,444.35 11,023.53 9,459.02 -14.19% METER EXPENSE 44,524.56 40,045.93 102,756.55 90,347.54 -12.08% MISC DISTRIBUTION EXPENSE 36,536.98 29,133.18 86,267.52 76,521.87 -11.30% METER READING LABOR & EXPENSE 5,745.76 5,858.55 20,812.83 22,726.60 9.20% ACCT & COLL LABOR & EXPENSE 157,829.19 108,645.76 399,876.48 323,359.74 -19.14% UNCOLLECTIBLE ACCOUNTS 10,400.00 12,500.00 31,200.00 37,500.00 20.19% ENERGY AUDIT EXPENSE 64,059.48 46,996.66 131,892.09 112,734.47 -14.53% ADMIN & GEN SALARIES 88,676.36 71,662.11 202,348.38 186,741.64 -7.71% OFFICE SUPPLIES & EXPENSE 26,087.85- 30,205.39 60,422.36 55,263.89 -8.54% OUTSIDE SERVICES 28,044.67 45,557.27 52,672.24 55,038.22 0.00% PROPERTY INSURANCE 26,282.19 34,055.43 78,846.57 96,095.25 21.88% INJURIES AND DAMAGES 5,429.66 7,965.14 15,869.74 14,088.43 -11.22% EMPLOYEES PENSIONS & BENEFITS 85,485.70 (20,088.10) 322,641.95 101,203.32 -68.63% MISC GENERAL EXPENSE 11,610.20 14,438.29 37,655.12 35,634.43 -5.37% RENT EXPENSE 14,283.12 14,001.46 41,975.46 41,415.37 -1.33% ENERGY CONSERVATION 0.00 21,587.60 0.00 53,403.80 100.00% TOTAL OPERATION EXPENSES 738,191.46 601 510.22 1,992,125.88 1,677,027.46 -15.82% MAINTENANCE EXPENSES: MAINT OF TRANSMISSION PLANT 227.08 227.08 681.24 681.24 0.00% MAINT OF STRUCT AND EQUIPMT 37,543.74 10,906.27 99,769.51 14,228.32 -85.74% MAINT OF LINES - OH 167,966.55 109,869.01 319,665.83 210,658.76 -34.10% MINT OF LINES - UG 9,931.21 21,228.33 34,985.39 34,975.99 -0.03% MAINT OF LINE TRANSFORMERS 6,889.65 16,550.27 23,958.34 27,387.21 14.31% MAINT OF ST LT & SIG SYSTEM 32.36 (19.01) 9.21 (87.81) -1053.42% MAINT OF GARAGE AND STOCKROOM 43,636.71 50,749.36 139,583.02 128,670.88 -7.82% MINT OF METERS 0.00 0.00 0.00 531.31 100.00% MAINT OF GEN PLANT 8,271.18 7,052.36 23,377.38 20,232.12 -13.45% TOTAL MAINTENANCE EXPENSES 274,498.48 216,563.67 642,029.92 437,278.02 -31.89% DEPRECIATION EXPENSE 261,200.00 280,105.78 783,600.00 840,317.34 7.24% PURCHASED POWER FUEL EXPENSE 4,735,865.70 2,973,452.04 18,202,111.04 11,096,051.29 -39.04% VOLUNTARY PAYMENTS TO TOWNS 100,750.00 104,500.00 302,250.00 313,500.00 3.72% TOTAL OPERATING EXPENSES 8,274,089.36 6,651,159.57 --28, 608, 313.39 21,785,575.88 -23.85% (12) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT PROFESSIONAL SERVICES 9/30/09 PROFESSIONAL SERVICES BY PROJECT ITEM DEPARTMENT ACTUAL BUDGET VARIANCE 1 RMLD AND PENSION TRUST AUDIT FEES ACCOUNTING 24,000.00 33,000.00 (91000.00) 2 PENSION ACTUARIAL EVALUATION ACCOUNTING 0.00 5,000.00 (51000.00) 3 IT CONSULTING ACCOUNTING 0.00 0.00 0.00 4 LEGAL- FERC/ISO ISSUES ENERGY SERVICE 0.00 12,501.00 (12,501.00) 5 LEGAL- POWER SUPPLY ISSUES ENERGY SERVICE 18,410.15 12,501.00 5,909.15 6 PROFESSIONAL SERVICES ENERGY SERVICE 0.00 12,501.00 (12,501.00) 7 NERC COMPLIANCE E & O 1,506.25 2,499.00 (992.75) 8 ENGINEERING STUDIES ENGINEERING 876.57 3,750.00 (2,873.43) 9 LEGAL SERVICES- GENERAL GM 5,331.33 12,501.00 (7,169.67) 10 LEGAL SERVICES- ARBITRATION HR 987.06 0.00 987.06 11 LEGAL GENERAL HR 3,823.31 9,999.00 (6;175.69) 12 LEGAL SERVICES- UNION CONTRACT HR 103.55 0.00 103.55 13 LEGAL GENERAL BLDG. MAINT. 0.00 375.00 (375.00) 14 SURVEY RIGHT OF WAY BLDG. MAINT. 0.00 1,251.00 (1,251.00) 15 ENVIRONMENTAL BLDG. MAINT. 0.00 1,251.00 (1,251.00) 16 ENGINEERING SERVICES BLDG. MAINT. 0.00 2,130.00 (2,130.00) 17 LEGAL GEN. BENEFIT 0.00 2,499.00 (2,499.00) 18 PROPERTY APPRAISAL GEN. BENEFIT 0.00 0.00 0.00 TOTAL 55,038.22 111,758.00 (56,719.78) PROFESSIONAL SERVICES BY VENDOR ACTUAL CHOATE HALL AND STEWART 4,913.92 PLM ELECTRIC 876.57 UTILITY SERVICE 1,506.25 DUNCAN AND ALLEN 2,052.16 MELANSON HEATH AND COMPANY 24,000.00 RUBIN AND RUDMAN 21,689.32 TOTAL 55,038.22 (13) RMLD BUDGET VARIANCE REPORT FOR PERIOD ENDING SEPTEMBER 30, 2009 DIVISION ACTUAL BUDGET VARIANCE % CHANGE ENGINEERING AND OPERATIONS 823,315 928,343 (105,028) -11.31% ENERGY SERVICES 184,573 311,309 (126,736) -40.71% GENERAL MANAGER 157,047 187,592 (30,545) -16.28% FACILITY 482,618 745,217 (262,600) -35.240 BUSINESS DIVISION 2,175,920 2,251,282 (75,361) -3.35% SUB-TOTAL 3,823,473 4,423,743 (600,270) -13.57% PURCHASED POWER - BASE 7,421,402 7,239,385 182,017 2.51% PURCHASED POWER - FUEL 11,096,051 12,167,656 (493,614) -8.81% TOTAL 22,340,926 23,830,784 (911,868) -6.259. 9:03 PM 10/22/2009 RMLD ENGINEERING AND OPERATIONS BUDGET VARIANCE REPORT FOR PERIOD ENDING SEPTEMBER 30, 2009 ENGINEERING 65 01 -65 -5580 -101 LABOR REG 13,356 30,128 36,193 ACTUAL BUDGET ACT /BUD 01 -65- 5580 -102 LABOR OT 3,502 2,441 1,630 YTD YTD VARIANCE E &O MGR 55 JUL AUG SEP TOTAL TOTAL % 01 -55- 5920 -101 LABOR PEG 12,834 14,016 17,172 44,021 43,809 0.48% 01 -55 -5920 -102 LABOR OT 0 0 0 0 500 - 100.00% 01 -55- 5921 -000 OFFICE SUPPLIES 0 0 11 11 249 - 95.47% 01 -55- 5930 -103 EE EDUCATION 0 0 1,354 1,354 3,550 - 61.87% 01 -55- 5930 -106 VEHICLE (561) (314) (286) (11161) 1,325 - 187.6791. 01 -55- 5923 -000 OUTSIDE SERVICES 0 1,031 475 1,506 2,499 - 39.73% 01 -55- 5930 -105 MISC GENERAL 0 0 0 0 300 - 100.00% SUB -TOTAL 12,273 14,733 18,725 45,731 52,232 - 12.45% ENGINEERING 65 01 -65 -5580 -101 LABOR REG 13,356 30,128 36,193 79,678 77,927 2.25% 01 -65- 5580 -102 LABOR OT 3,502 2,441 1,630 7,573 11,925 - 36.49% 01- 65- 5580 -103 EE EDUCATION 0 0 800 800 13,500 - 94.07% 01 -65- 5580 -105 SUPPLIES 125 137 922 1,185 1,251 -5.31% 01 -65- 5580 -106 VEHICLE (450) (252) (229) (931) 1,325 - 170.30% 01 -65 -5921 -000 OFFICE SUPPLIES 9 205 92 305 249 22.64% 01 -65 -5923 -000 OUTSIDE SERVICES 0 877 0 877 3,750 - 76.62% SUB -TOTAL 16,541 33,536 39,409 89,486 109,926 - 18.59% 7,INE 66 01 -66- 5568 -109 MAINT OF TRANS EXP 227 227 227 681 750 -9.17% 01 -66 -5581 -101 LABOR MISC 46,688 52,011 28,374 127,073 102,961 23.42% 01 -66 -5581 -109 GENERAL EXP 4,321 3,923 8,542 16,786 31,251 - 46.29% 01 -66- 5581 -103 EE EDUCATION 0 0 3,343 3,343 10,500 - 68.16% 01 -66 -5585 -109 STREET LIGHT EXP 630 907 1,252 2,789 5,001 - 44.23% 01 -66 -5585 -101 LABOR REG ST LIGHT 1,261 1,008 1,909 4,178 5,148 - 18.84% 01 -66- 5585 -102 LABOR OT ST LIGHT 444 129 344 917 3,000 - 69.43% 01 -66- 5585 -106 VEHICLE ST LIGHT 264 372 939 1,574 6,623 - 76.23% 01 -66- 5593 -000 MAINT OF LINES 1,288 (799) 1,694 2,183 8,250 - 73.54% 01 -66- 5593 -101 LABOR REG MAINT LINE (630) 28,783 65,052 93,204 79,864 16.709. 01 -66- 5593 -102 LABOR OT MAINT LINE 27,098 21,697 21,170 69,965 60,180 16.26% 01 -66- 5593 -106 VEHICLE MAINT OH LINE (4,824) 2,615 7,022 4,813 45,037 - 89.31% 01 -78- 5593 -110 TREE TRIMMING 6,825 18,737 14,932 40,495 62,099 - 34.79% 01 -66- 5594 -109 MAINT UG LINE 1,602 12,307 18,545 32,454 28,941 12.14% 01 -66- 5594 -101 LABOR REG UG LINES 0 349 2,171 2,519 3,470 - 27.39% 01 -66- 5594 -102 LABOR OT UG LINE 0 199 0 199 1,251 - 84.13% 01 -66- 5594 -106 VEHICLE UG LINE (561) (148) 513 (196) 2,366 - 108.28% 01 -66- 5596 -109 ST LT & SIG EXP 0 0 0 0 126 - 100.00% 01 -66- 5596 -101 LABOR REG ST LT /SG 0 0 0 0 1,542 - 100.00% 01 -66- 5596 -102 LABOR OT ST LT /SG 0 0 0 0 126 - 100.00% 01 -66- 5596 -106 VEHICLE ST LT /SG (47) (22) (19) (88) 662 - 113.26% 01 -66- 5921 -000 OFFICE SUPPLIES 0 0 0 0 126 - 100.00% r SUB -TOTAL 84,587 142,293 176,010 402,890 459,274 - 12.28% Page 1 9:03 PM 10/22/2009 RXLD ENGINEERING AND OPERATIONS BUDGET VARIANCE REPORT FOR PERIOD ENDING JULY 31, 2009 METER READING 80 01- 80- 5902 -101 LABOR REG 01 -80- 5902 -102 LABOR OT 01 -80 -5902 -105 SUPPLIES 01 -80- 5902 -106 VEHICLE SUB -TOTAL METER TECHNICIANS 67 01 -67 -5586 -109 METER TECH EXP 01 -67- 5586 -101 LABOR REG 01 -67 -5586 -102 LABOR OT 01 -67- 5586 -103 EE EDUCATION 01 -67- 5586 -106 VEHICLE 01 -67- 5921 -000 OFFICE SUPPLIES SUB -TOTAL STATION 68 01 -68- 5581 -109 STATION OF 01 -68- 5581 -101 LABOR REG SUP 01 -68- 5582 -109 STATION SUPPLIES 01 -68- 5582 -101 LABOR REG 01 -68- 5582 -102 LABOR OT 01 -68- 5582 -103 EE EDUCATION 01 -68- 5582 -105 SUPPLIES 01 -68- 5582 -106 VEHICLE SUB -TOTAL 01 -68- 5590 -109 SENIOR TECH EXP 01 -68- 5590 -101 LABOR REG 01 -68- 5590 -102 LABOR OT 01 -68- 5590 -103 EE EDUCATION 01 -68- 5590 -105 SUPPLIES 01- 68- 5590 -106 VEHICLE 01 -68- 5595 -000 TRANSFORMER NAINT 01 -68- 5597 -109 MAINT METERS 01 -68- 5597 -101 LABOR REG 01 -68- 5597 -102 LABOR OT 01 -68- 5921 -000 OFFICE SUPPLIES SUB -TOTAL GRAND TOTAL 210 200 700 ACTUAL BUDGET ACT /BUD 29,921 39,209 89,734 YTD YTD VARIANCE JUL AUG SEP TOTAL TOTAL % 8,632 5,861 4,845 19,337 13,843 39.69% 0 0 0 0 501 - 100.00% 0 0 0 0 249 - 100.00% 1,204 1,172 1,014 3,389 1,987 70.58% 9,836 7,032 5,859 22,727 16,580 37.07% 210 200 700 1,110 3,000 20,604 29,921 39,209 89,734 94,171 615 202 404 1,221 1,251 0 0 0 0 2,000 (912) (539) (267) (11718) 3,974 0 0 0 0 126 20,517 29,785 40,046 90,348 104,522 -63.00 % -4.71% - 2.40 - 100.00% - 143.22% - 100.00% -13.56% 376 376 376 1,127 1,251 -9.93% 0 0 2,666 2,666 16,399 - 83.75% (209) (273) (672) (1,155) 1,875 - 161.58% 21,033 29,719 36,586 87,338 67,357 29.66% ' 11,167 12,674 15,489 39,331 30,060 30.84% 0 0 0 0 3,750 - 100.00% (5) 468 161 623 0 100.00% (168) (94) (86) (348) 662 - 152.52% 32,193 42,869 54,520 129,582 121,355 6.7891. 81 64 0 145 3,750 - 96.13% (4,909) 7,180 10,682 12,954 25,598 - 49.40% 449 448 0 897 3,495 - 74.35% 0 0 405 405 3,249 - 87.53% 106 165 310 581 1,620 - 64.13% (168) (94) (86) (348) 662 - 152.52% 7,097 3,740 16,550 27,387 24,626 11.21% 531 0 0 531 501 6.05% 0 0 0 0 577 - 100.009. 0 0 0 0 126 - 100.009. 0 0 0 0 249 - 100.00% 3,187 11,504 27,862 42,552 64,454 - 33.98% 179,134 _281_,752 362,429 823,315 928,343 - 11.31% Page 2 8:51 PM 10/22/2009 RMLD BUSINESS DIVISION BUDGET VARAINCE REPORT FOR PERIOD ENDING SEPTEMBER 30, 2009 MISCELLANEOUS DEDUCTIONS 57/77 01 -77- 5403 -000 DEPRECIATION EXP 280,106 280,106 280,106 ACTUAL BUDGET ACT /BUD 01 -77 -5408 -000 VOLUNTARY PAYMENTS 104,500 104,500 104,500 YTD YTD VARIANCE ACCOUNTING 59 INTEREST EXP TUL AUG SEP TOTAL TOTAL % 01 -59- 5903 -101 LABOR REG 13,107 16,160 19,395 48,661 47,364 2.74% 01 -59- 5903 -102 LABOR OT 0 0 0 0 100 - 100.00% 01 -59 -5903 -103 EE EDUCATION 0 0 0 0 0 0.00% 01 -59- 5903 -105 SUPPLIES 9,571 33,686 595 43,852 66,399 - 33.96% 01 -59 -5921 -000 OFFICE SUPPLIES 3,191 20,701 29,833 53,726 60,000 - 10.46% 01 -59r 5923 -000 OUTSIDE SERVICES 0 0 24,000 24,000 38,000 - 36.84% SUB -TOTAL 25,869 70,547 73,823 170,239 211,863 - 19.65% CUSTOMER SERVICE 62 01 -62- 5903 -101 LABOR REG 32,203 42,301 45,245 119,749 124,150 -3.54% 01- 62- 5903 -102 LABOR OT 0 0 0 0 1,000 - 100.00% 01 -62 -5903 -103 EE EDUCATION 0 0 0 0 750 - 100.0091. 01 -62- 5903 -105 SUPPLIES 156 1,391 1,607 3,154 3,750 - 15.90% 01 -62- 5903 -106 VEHICLE (561) (314) (286) (11161) 1,325 - 187.67% 01 -62- 5903 -109 RES ENERGY AUDITS 0 140 (140) 0 0 0.00% 01 -62 -5904 -000 UNCOLLECT ACCOUNTS 12,500 12,500 12,500 37,500 37,500 0.00% 01 -62 -5921 -000 OFFICE SUPPLIES 0 13 106 119 600 - 80.10% SUB -TOTAL 44,298 56,031 59,032 159,361 169,075 -5.75% MIS 61 01 -61- 5903 -101 LABOR REG 29,072 34,187 39,909 103,167 103,377 -0.20% 01 -62- 5903 -102 LABOR OT 0 0 0 0 200 - 100.00% 01 -61- 5903 -103 EE EDUCATION 0 398 0 398 3,000 - 86.73% 01 -61- 5903 -105 SUPPLIES 1,421 1,799 2,321 5,541 6,000 -7.66% 01 -61- 5935 -000 MAINT GEN PLANT 5,289 7,890 7,052 20,232 29,025 - 30.29% 01 -61 -5921 -000 OFFICE SUPPLIES 0 692 104 796 3,000 - 73.48% SUB -TOTAL 35,782 44,965 49,386 130,133 144,602 - 10.01% MISCELLANEOUS DEDUCTIONS 57/77 01 -77- 5403 -000 DEPRECIATION EXP 280,106 280,106 280,106 840,317 847,500 -0.85% 01 -77 -5408 -000 VOLUNTARY PAYMENTS 104,500 104,500 104,500 313,500 313,500 0.009. 01 -77- 5419 -000 INTEREST EXP 1,304 1,277 1,291 3,871 3,750 3.23% 01 -77- 5426 -000 OTHER DEDUCTIONS 182,225 162,220 182,223 546,668 546,675 0.00% 01 -77- 5427 -000 INTEREST EXP BONDS 2,222 0 2,224 4,446 4,444 0.04% 01 -77 -5428 -000 AMORT DEBT EXP 122 122 122 366 375 -2.34% 01 -57- 5920 -101 AC /BUS MGR LABOR REG 174 3,422 3,422 7,019 8,898 - 21.11% 01 -57- 5930 -109 AC /BUS MGR MISC GEN 0 0 0 0 600 - 100.00% SUB -TOTAL 570,653 571,647 573,887 1,716 187 1,725,742 -0.55% GRAND TOTAL 676,602 743,190 756,128 2,175,920 2,251,282 -3.35% Page 3 9:27 PM 10/22/2009 MATERIALS MANAGEMENT 60 01 -60- 5588 -109 MISC DIST EXP RMLD 3,771 3,711 8,553 11,250 FACILITY DIVISION BUDGER VARIANCE REPORT LABOR REG 19,372 21,521 24,769 FOR PERIOD ENDING SEPTEMBER 30, 2009 -3.97% 01- 60- 5588 -102 LABOR OT 0 0 0 0 ACTUAL BUDGET ACT /BUD EE EDUCATION 0 223 0 YTD YTD VARIANCE GENERAL BENEFITS 53 JUL AUG SEP TOTAL TOTAL % 01 -53- 5920 -101 LABOR REG 5,213 9,412 9,436 24,060 21,928 9.72% 01 -53 -5921 -000 OFFICE SUPPLIES 0 0 0 0 255 - 100.00% 01 -53- 5930 -103 EE EDUCATION 501 8 0 509 1,251 - 59.29% 01 -53- 5930 -105 SUPPLIES 0 0 25 25 249 - 90.02% 01 -53- 5923 -000 OUTSIDE SERVICES 0 0 0 0 2,499 - 100.00% 01 -53 -5924 -000 PROPERTY INSURANCE 31,020 31,020 34,055 96,095 110,793 - 13.27% 01 -53 -5925 -000 INJURIES & DAMAGES 3,064 3,060 7,965 14,088 15,348 -8.21% 01 -53- 5926 -000 EE PENS & BENEFIT 63,504 57,787 (20,088) 101,203 299,340 - 66.19% 01 -53 -5930 -109 MISC GENERAL 0 0 0 0 750 - 100.00% 01 -53- 5931 -000 RENT 13,446 13,968 14,001 41,415 53,001 - 21.86% SUB -TOTAL 116,748 115,255 45,394 277,397 505,414 - 45.11% TRANSPORTATION 63 01 -63- 5933 -109 MISC GENERAL (160) (40) 10 (190) (45,660) - 99.58% 01 -63- 5933 -101 LABOR REG 5,813 1,340 4,868 12,020 14,236 - 15.56% 01 -63- 5933 -102 LABOR OT 428 134 294 857 1,950 - 56.07% 01 -63- 5933 -103 EE EDUCATION 0 0 0 0 500 - 100.00% 01 -63- 5933 -105 SUPPLIES (33,182) (16,617) 18,971 (30,829) 95,205 - 132.38% LESS ALLOCATION RECLASS 27,101 15,184 (24,143) 18,142 (66,231) - 127.39% SUB -TOTAL (0) 0 0 (0) 0 0.00% BUILDING MAINTENANCE 64 01 -64 -5923 -000 OUTSIDE SERVICES 0 0 0 0 5,007 - 100.00% 01- 64- 5932 -101 LABOR REG 5,887 10,927 13,274 30,089 31,069 - 3.15% 01 -64- 5932 -102 LABOR OT 373 1,108 2,725 4,206 3,000 40.21% 01 -64- 5932 -103 EE EDUCATION 0 0 0 0 500 - 100.00% 01 -64- 5932 -105 SUPPLIES 22,749 36,840 34,787 94,376 114,710 - 17.73% SUB -TOTAL 29,009 48,876 50,786 128,671 154,286 - 16.60% MATERIALS MANAGEMENT 60 01 -60- 5588 -109 MISC DIST EXP 1,071 3,771 3,711 8,553 11,250 - 23.98% 01 -60 -5588 -101 LABOR REG 19,372 21,521 24,769 65,662 68,378 -3.97% 01- 60- 5588 -102 LABOR OT 0 0 0 0 999 - 100.00% 01 -60- 5588 -103 EE EDUCATION 0 223 0 223 525 - 57.52% 01 -60- 5588 -105 SUPPLIES 623 807 654 2,084 3,750 - 44.42% 01 -60 -5588 -104 RFP EXPENSES 0 0 0 0 240 - 100.00% 01 -60- 5921 -000 OFFICE SUPPLIES 0 28 0 28 375 - 92.55% SUB -TOTAL 21,066 26,350 29,133 76,550 85,517 - 10.49% GRAND TOTAL 166,823 190,481 125,314 482,618 745,217 - 35.24% Page 4 8:45 PM 10/22/2009 RMLD GENERAL MANAGER DIVISION BUDGET VARIANCE REPORT FOR PERIOD ENDING SEPTEMBER 30, 2009 GENERAL MANAGER 51 01 -51- 5920 -101 LABOR REG 01 -51- 5921 -000 OFFICE SUPPLIES 01- 51- 5923 -000 OUTSIDE SERVICES 01 -51 -5930 -103 EE EDUCATION 01 -51- 5930 -105 MISC GENERAL 01 -51- 5930 -106 VEHICLE SUB -TOTAL HUMAN RESOURCES 52 01 -52- 5920 -101 LABOR REG 01- 52- 5921 -000 OFFICE SUPPLIES 01 -52- 5923 -000 OUTSIDE SERVICES 01 -52- 5930 -103 EE EDUCATION 01 -52- 5930 -105 SUPPLIES 01 -52 -5930 -109 MISC GENERAL SUB -TOTAL COMMUNITY RELATIONS 54 01 -54- 5920 -101 LABOR REG 01 -54- 5921 -000 OFFICE SUPPLIES 01 -54- 5930 -109 MISC GENERAL 01 -54- 5930 -103 EE EDUCATION 01 -54- 5930 -105 SUPPLIES SUB -TOTAL CAB 56 01 -56- 5920 -101 LABOR REG 01 -56- 5920 -102 LABOR OT 01 -56- 5930 -109 MISC GENERAL SUB -TOTAL BOARD 58 01 -58- 5930 -109 MISC GENERAL SUB -TOTAL GRAND TOTAL 8,777 11,327 9,349 ACTUAL BUDGET ACT /BUD 0 0 0 YTD YTD VARIANCE ,UL AUG SEP TOTAL TOTAL o 16,146 19,776 22,754 58,676 60,273 -2.65% 84 110 70 265 624 - 57.56% 0 4,397 934 5,331 12,501 - 57.3591 0 0 479 479 2,500 - 80.8691. 4,364 4,318 4,274 12,956 13,749 -5.779. (561) (314) (286) (1,161) 1,325 - 187.679. 20,033 28,287 28,225 76,545 90.972 - 15.86% 8,777 11,327 9,349 29,453 31,021 -5.06% 0 0 0 0 50 - 100.00% 0 3,176 1,738 4,914 9,999 - 50.86% 385 125 (480) 30 1,600 - 98.13% 0 0 63 63 75 - 16.2491. 237 1,150 984 2,370 4,160 - 43.029. 9_,399 15,778 11,653 36,830 46,905 - 21.48% 5,789 8,193 9,318 23,300 23,247 0.23% 0 0 0 0 125 - 100.00% 2,768 6,891 5,147 14,806 20,110 - 26.38% 0 0 0 0 0 0.00% 0 0 0 0 125 - 100.00% 8,557 15,084 14,465 38,106 43,607 - 12.61% 0 0 212 212 1,259 - 83.17% 0 0 0 0 300 - 100.00% 2,200 0 1,289 3,489 2,175 60.41% 2,200 0 1,501 3,701 3,734 -0.899-6 0 0 1,866 1,866 2,375 - 21.45% 0 0 1,866 1,866 2,375 - 21.45% 40,189 59,149 57,710 157,047 187,592. - 16.28% Page 5 8:42 PM 10/22/2009 RMLD ENERGY SERVICES DIVISION BUDGET VARIANCE REPORT FOR PERIOD ENDING SEPTEMBER 30, 2009 s Page 6 ACTUAL BUDGET ACT /BUD YTD YTD VARIANCE ENERGY SERVICES 75 JUL AUG SEP TOTAL TOTAL % 01 -75- 5916 -000 ENERGY SERV EXP 310 310 7,090 7,710 9,999 - 22.89% 01 -75- 5916 -101 LABOR REG 26,544 37,539 39,758 103,841 106,139 - 2.16% 01- 75- 5916 -103 EE EDUCATION 0 997 149 1,146 1,250 -8.29% 01 -75- 5916 -109 KEY ACCOUNT 0 37 0 37 1,251 - 97.04% 01 -75 -5921 -000 OFFICE SUPPLIES 25 0 0 25 126 - 80.49% 01 -75- 5923 -000 OUTSIDE SERVICES 0 0 18,410 18,410 37,503 - 50.91% 01- 75- 5916 -402 RES CONSERVE PROG 10,391 13,266 12,576 36,232 56,294 - 35.64% 01 -75 -5916 -403 RES CONSERVE OTHER 0 0 0 0 5,249 - 100.00% 01 -75- 5916 -502 COMM CONSERVE PROG 620 0 5,242 5,862 81,249 - 92.79% 01 -75 -5916 -503 COMM CONSERVE OTHER 3,770 3,770 3,770 11,310 12,249 -7.66% GRAND TOTAL 41,660 55,919 86,994 184,573 311,309 - 40.71% s Page 6 RMLD DEFERRED FUEL CASH RESERVE ANALYSIS 9/30/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 Aug -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 RMLD STAFFING REPORT FOR FISCAL YEAR ENDING JUNE, 2010 ACTUAL 10 BUD JUL AUG SEP TOTAL 09 09 09 Gy-NERAT, MANAGER GENERAL MANAGER 2 2 2 2 HUMAN RESOURCES 1.5 1.5 1.5 1.5 COMMUNITY RELATIONS 1.5 1.5 1.5 1.5 TOTAL 5 5 5 BUSINESS ACCOUNTING 2 2 2 2 CUSTOMER SERVICE 9 9 9 9 MGMT INFORMATION SYS 6 6 6 6 MISCELLANEOUS 1 1 1 1 TOTAL 18 18 18 18 ENGINEERING & OPERATIONS AGM E&O 2 2 2 2 ENGINEERING 5 5 5 5 LINE 20 18 18 18 METER 7 7 7 7 STATION 9 9 9 10 TOTAL 43 41 41 42 PROJECT BUILDING 2 2 2 2 GENERAL BENEFITS 2 2 2 2 TRANSPORTATION 0 0 0 0 MATERIALS NGMT 4 4 4 4 TOTAL 8 8 8 8 ETA' - - -- SERVICES ENERGY SERVICES 6 6 6 6 TOTAL 6 6 6 6 RMLD TOTAL 80 78 78 79 CONTRACTORS UG LINE 2 2 2 2 TOTAL 2 2 2 2 GRAND TOTAL 82 80 80 81 I, Cli Ll� "L clt c:� 0i c:� c:� c� ci 11� cli O cD ci cD 0 0 LLI 11� c� ci c� c� cN� cL q -i 1. q N O M -i m �NL OL czi c;� cL oR� c� q Ll� "L 11� q M q cli -cL 11� 11� "L Of N N N < m m R q M IR ci m 0 0 IA R Lp N z W r In . . . . . . 6 Ni Vr 16 u� .1i & 11 16 cT r,: -i �6 6 m c, I i . . . I cl� cIL IL oi ;ji c7 a z W m M cl m R 49 N q N Of 9 7 m q IR n 14 Iq h a1 R LI? oR < w a O ir (n w a: 0 �L q cli -�i q .9- q Ot W Ili -i Ll� 11� It "L C� OL z O O W W V N N q m m r OL L'i 2 < w Z cc F- w cc < d 0 z z x m 0 (n w uj Lu z u" g U =3 Ir < Q z In mz i:_ zo L) 0 N In w 6 E IS w cc q w� w zw u, 6w m w u) z L. W. d o�- 73 10 zw w u :, x a) i; j , w z cc - < > w Iz w u) wo g w z M z w w w < - Sz cc uj w L) o > W 'Lun 'r c w I u, a 21, 'z uzj uc, 'o 0 z 'z wwH� L>u� > >m ow m rw <a x� w- z o w x L>LI, m w I z m w mo , c - < < w z m in C) z > w zm w z z'- z o w -w u" LLI O wo2w Qoo= w owoz,-< w < Z , w 2 o x I m z S, ir rw w w z c o x 2 z , z , m w a cc w o w w tc w w z am I c � m a, o w uj o cc < w w w o w , < z w w o z LLI zoo�',u M< w <z�a: z WWNooW z ED CC I w z z z- < w w uj u o P m o) w (D o o 0 w w 'r z uj o Z5 z < cc Ir w , , I I-, L) u cc z �: - c: o < L) cc z It uj z < I < w w � m a o w L) u) z < m 0 z o 0 cc w w x < "InDmawo < zwz :,::. w < < 0 z 5 w o >w z w w < lu m m o a z o F- 0 o w m 0 0 0 c) z u m o o w z �- E �i < 0 >- o z z w 0 z m < z m L) m S. 0 ra To: Vincent Cameron From: Energy Services Date: October 21, 2009 Subject: Purchase Power Summary— September, 2009 Energy Services Division (ESD) has completed the Purchase Power Summary for the month of September 2009. ENERGY The RMLD's total metered load for the month was 55,496,286 kWhs, which was a decrease of 8.87 % compared to September, 2008 figures. Table 1 is a breakdown by source of the energy purchases. `Includes a decrease to $ 126,381.18 due to Working Capital. Working Capital prepayments were treated as an expense. Reverse the expense. TABLE 1 Amount of Cost of % of Total Total $ $ as a Resource Energy Energy Energy Costs % (kWh) ($ /Mwh) Millstone #3 3,550,456 $4.61 6.39% $16,385 0.55% Seabrook 5,668,092 $6.77 10.20% $38,369 1.29% Stonybrook 778,147 $49.90 1.40% $38,829 1.31% Constellation 21,600,000 $67.17 38.88% $1,450,818 48.79% PASNY 1,631,958 $4.92 2.94% $8,029 0.27% ISO Interchange 6,256,503 $41.82 11.26% $262,341 8.82% NEMA Congestion 0 $0.00 0.00% - $12,179 - 0.41% Coop Resales 65,778 $132.86 0.12% $8,739 0.29% Stonybrook Peaking 23,810 $182.62 0.04% $4,348 0:15% Integrys 15,768,000 $80.64 28.38% $1,271,602 42.77% *Braintree Watson Unit 219,452 - $518.70 0.39 % - $113,830 -183% Monthly Total 55,562,196 $53.52 100.00% $2,973,452 100.00 % `Includes a decrease to $ 126,381.18 due to Working Capital. Working Capital prepayments were treated as an expense. Reverse the expense. Table 2 breaks down the ISO interchange between the DA LMP Settlement and the RT Net Energy for month of September, 2009. CAPACITY The RMLD hit a demand of 104,481 kWs, which occurred on September 23, 2009 at 8 pm. The RMLD's monthly UCAP requirement for September 2009 was 228,092 kWs. Table 3 shows the sources of capacity that the RMLD utilized to meet its requirement. Table 3 Source Amount (kWs) Cost ($ /kW- month) Total Cost $ % of Total Cost Millstone #3 4,980 Table 2 $318,998 19.66% Amount Cost % of Total Resource of Energy of Energy Energy 2.07 (kWh) ($ /Mwh) Stonybrook CC ISO DA LMP 10,909,359 38.24 19.63% Settlement 4,533 2.62 $11,896 RT Net Energy - 4,652,856 28.53 -8.37% Settlement 2.60% ISO -NE Supply Auction 125,496 ISO Interchange 6,256,503 45.58 11.26% (subtotal) 2.29 $21,062 1.30 % Table 2 breaks down the ISO interchange between the DA LMP Settlement and the RT Net Energy for month of September, 2009. CAPACITY The RMLD hit a demand of 104,481 kWs, which occurred on September 23, 2009 at 8 pm. The RMLD's monthly UCAP requirement for September 2009 was 228,092 kWs. Table 3 shows the sources of capacity that the RMLD utilized to meet its requirement. Table 3 Source Amount (kWs) Cost ($ /kW- month) Total Cost $ % of Total Cost Millstone #3 4,980 64.06 $318,998 19.66% Seabrook 7,909 63.12 $499,189 30.76% Stonybrook Peaking 25,868 2.07 $53,463 3.29% Stonybrook CC 44,495 3.88 $172,480 10.63% Pasny 4,533 2.62 $11,896 0.73% HQI CC 5,631 7.49 $42,157 2.60% ISO -NE Supply Auction 125,496 4.01 $503,549 31.03% Braintree Watson Unit 9,180 2.29 $21,062 1.30 % Total 228,092 $7.11 $1,622,793 100.00% TRANSMISSI ®N The RMLD's total transmission costs for the month of September, 2009 are $841,693. This is a 9.34% increase from the August, 2009 cost of $769,792. In 2008, the transmission costs for the month of September, were $576,694. Table 5 Table 4 ........... Resource Energy Capacity Total cost % of Total Cost Millstone #3 $16,385 $318,998 $335,383 7.30% Seabrook $38,369 $499,189 $537,558 11.70% Stonybrook $38,829 $172,480 $211,309 4.60% HO II $0 $42,157 $42,157 0.92% Constellation $1,450,818 $0 $1,450,818 31.57% PASNY $8,029 $11,896 $19,925 0.43% ISO Interchange $262,341 $503,549 $765,890 16.66% Nema Congestion - $12,179 $0 - $12,179 -0.26% Coop Resales $8,739 $0 $8,739 0.19% Stonybrook Peaking $4,348 $53,463 $57,812 1.26% Integrys $1,271,602 $0 $1,271,602 27.67% Braintree Watson Unit - $113,830 $21,062 - $92,768 -2.02% Monthly Total $2,973,452 $1,622,793 $4,596,246 100.00% Table 4 shows the total dollar amounts for energy and capacity per source. TRANSMISSI ®N The RMLD's total transmission costs for the month of September, 2009 are $841,693. This is a 9.34% increase from the August, 2009 cost of $769,792. In 2008, the transmission costs for the month of September, were $576,694. Table 5 shows the current month vs. last month and last year (September, 2008). Table 5 ........... ........................ . ......... Current Month ............. Last Month ............ ................... .............. Last Year .. .......... _ . ........... !Peak Demand (kW) ............................ �_. _..., 104,481 .... _m........ .... .. 155,759 _, _ ................. _....... 139,540 Energy (kWh), �..�........�., _,m.�.._ ,19 55,5626 __.....7„ .. ... _._,.... 2,835,439: ...__._. ...,._._ , w..__ 60,996,650 Energy($) .......... $2,973,452 ............ ... ........... .............. ., ....... .. ...... $4,051,361 ..._ ...... _ .... ,.,.............. ...........,, $4,735,866 Capacity ($) ....... _._.........,, $1,622,793z ;......... .............. ., ......... ,, ..... $1,880,365 ............... .. ............... ..... $1,583,417 Transmission ($) ............ ........ $841,693 _ . ..__.. .. $769,792 .._._._. _ .......... ...... ..... $576,694 Total $5,437,939 $6,701,518 $6,895,976 Table 5 shows the current month vs. last month and last year (September, 2008). am am Mal m IN am bi am am am MIN am am kiln IN kiln m all= P MIN allow WINE MIN am allow now m am I vi c C: 0 0 0 0 0 (1) W 0 0 0 to c C cu c Q 0 (D CD E cu cu -0 "0 "a - O C C a) a) C C: E 0 0 0 0 0 > M >% >% m (D > CU CL cu cn (D _0 C o o ca U) 0) cc '0 0 ca 0 co a) 0) 4.0 0 0) 0) 0) Co Z a) 0 1- 0 4- C C: = L) C: 0) a) a) C: C: o C.) '0 '0 cn E to a) Z (n cn 0 =5 a) >11 0 0) 0 1- E c 0 E c 0 co C) w CU co E = = :3 a) C CU a) a) (D a) a) a) r- CU 0 0 M 0 M 0 (D .0 -0 y E a) 0) 0) Z Z Z -0 (1) (1) a) -0 .- (D c L- a) (1) r E to a) E -C c,,-) 0 a) a) ca m cu c E E E E.U. -D E E E E E E C) 0 0 a) �: 0 0 0 " a) 0 0 0 0 0 'T-- 0 r 0 to CO ly- UUUUUr U r U m M 0 0 0 0000 00000 0 0 4) 0 00000 4) 000000 00 LO co m rl- C14 N 0 0 E c) �R !R E T- N 2 CD CD O �5 (0 C\l CV) 0 r,l- iz: co Cc> O C Oro 0 C) C) 0`O a) 0- 'o C) D C) 0 0 DOOM LO C) a) CL ' C) 0 0 0 Cl 00000 V) CD 0 E TI- co E o 0 u 0 co 0) 000000 0 m 0 0 0 0 0 0 m 0 0 0 m 06 co co co 0 CD CO N- m m N r U*) r� T r O I- W 4- U) a o C5 C) 0 2 N N !��j N o 64 Qq -C-11 Q Z! IN !R rl- CN r- N "- LO LO CO co r- r- co 0 0 0 0 — 0 C) C> r 0 CD C) CD o 0 0 (L E Ri E ca ca CL 0 4) a (D a) > CD a) M 0 E 0 c' cu E E U) a) 0) o (n 40 U) C'. "0 a) c 0 0) L) 0 &- C: E cu a) a) OC Lo - 0 t2 0 0 3: E 02 E 0 0) 2 .0 0 CL L a) (D a) L- a) a) CL L- 0) cu 0 L- c 4- %4.- U) r- c-- L) 0 0 — a) 0 co L- U) 0 < L- m a) -0 a) E 75 .9; CD r- ,C: co _0 r_ CD C 0 CO L- .§ _j :2 m .5 c cc 0 C: a) a) m iTo C) U) rt 0 T- T- T- T- 0) CL .0) co iL W LM 0 U) 0) o o c -0 o o o -.;-- • 0 0 0 0 U) E 0" E E E a) E cu (D CD- W Lu 0 L- Z 0 0 a) 13) L -0 '0 R > , 2 LOP (D 0 .0) a) cn (n 0 cn cn 0 U) co U) 0) 0 C: -�e C: C: C: co c -0 c: 0 U5 = C M a) 0 0 0 C 0 C 0 C 0 LO co cc cu cu cu a) 0 o U) 0 0 0 L) C) L- T- " L- L- �-- V- I-- �- F- t- F- (n LL 10:37 AM READING MUNICIPAL LIGHT DEPARTMENT $32,400 $52,984 $20,584 10/22/2009 FY10 CAPITAL BUDGET VARIANCE REPORT $231,973 $8,140 FOR PERIOD ENDING SEPTEMBER 30, 2009 $131,220 $31,510 $62,000 $30,490 ACTUAL YTD ACTUAL $353,823 $353,823 COST COST ANNUAL REMAINING # PROJECT DESCRIPTION TOWN SEPTEMBER THRU 9/30/09 BUDGET BALANCE 4 kV Retirement - Stepdown Areas $43,700 $22,321 $22,321 $94,410 $72,089 1 Reading R $20,475 $76,598 $31,415 ($45,183) 22 Wilmington - Main Street NEW W $445,524 $958,631 $112,152 $112,152 SVstem Protects 2 Station 44 Getaway 4W30 Replacements R $79,549 $81,544 $201,712 $120,168 3 Station #4 Getaway 4W17 Replacements NEW R $170,779 $170,779 4 Salem Street Area W $36,909 $109,129 $171,923 $62,794 5 High Capacity Tie 4W 18/3W8 Franklin Street R $129,004 $129,004 6 Haverhill Street - Reconductoring NEW R $184,460 $184,460 URD Upgrades 7 URD Completions- Sanborn Village, Reading; Perkins VAR $38,496 $38,496 Farm, Lynnfield; and Chestnut Village, North Reading New Circuits and Circuit Expansions 8 Salem Street to Glen Rd 13kV 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 28 Software and Licensing Total Other Projects TOTAL RMLD CAPITAL PROJECT EXPENDITURES $80,063 $80,063 $5,363 $13,932 $8,569 $23,311 $23,311 R $1,231,500 $1,231,500 R $84,821 $89,014 $344,800 $255,786 R $41,299 $142,427 $432,405 $289,978 R $228,159 $228,159 W $157,528 $157,528 ALL $4,045 $54,184 $50,139 ALL $21,035 $50,023 $176,623 $126,600 ALL $124,740 $296,701 $1,537,896 $1,241,195 $408,827 $854,844 $5,320,343 $41465,499 $4,960 $32,400 $52,984 $20,584 $9,416 $9,416 $241,389 $231,973 $8,140 $139,360 $131,220 $31,510 $62,000 $30,490 $353,823 $353,823 $200,248 $200,248 $25,000 $25,000 $43,700 $43,700 $22,321 $22,321 $94,410 $72,089 $36,697 $103,787 $1,212,913 $1,109,126 $445,524 $958,631 $6,533,256 $5,574,625 Reading Municipal Light Department Engineering and Operations Monthly Report September, 2009 FY 2010 Capital Plan 4 kV Retirement - Stepdown Areas 1. Reading - Work continued on Prescott Street, Washington, and Boyce Streets — Installed primary cable, transformers, secondary cable, spacers, and hardware. Transferred services. 22. Main Street - Wilmington - No activity. System Proiects 2. Station #4 Getaway Feeder 4W30 Replacement - Reading - Underground work continued on Lowell Street, Reading, including setting up manholes installation of new feeder cable. 3. Station #4 Getaway Feeder 4W17 - Wilmington - No activity. 4. Salem Street Area - Wilmington - Reconductoring continued: Installed pole line, spacer cable, spacers, tri blocks, taps, lightning arrestors, and energized. 5. High Capacity Tie 4W18/3W8 Franklin Street - Reading - No activity. 6. Haverhill Street - Reading /Lynnfield - No activity. URD 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 Projects 11. Transformer Replacement - Station 4 - Reading Part 1 - Contractual Labor - No financial activity. Part 2 - Procured Equipment - Installed substation structure switches, aluminum panels. Part 3 - RMLD Labor - Relay and control wire modifications. Part 4 - Feeder Re- Assignment - No activity. 23. 15kV 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. No financial activity. 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 $ 28,522 Maintenance Overhead /Underground $108,403 Projects Assi gned as Required $ 87,815 Pole Damage (includes knockdowns) some reimbursable $ 21,735 Station Group $ 1,012 Hazmat/Oil Spills $ 2,262 Porcelain Cutout Replacement Program $ 8,718* Lighting Street Light Connections $ 6,258 Storm Trouble $ 0 Underground Subdivisions $ 24,200 Miscellaneous Capital Costs $ 7,776 TOTAL $296,701 *In the month of September, 28 cutouts were charged under this program. Approximately 25 cutouts were installed new or replaced because of damage making a total of 53 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. 0 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 — 41.58 minutes Industry Average — 65.91 minutes per outage (APPA 2005 Reliability Survey) On average, RMLD customers that experience an outage are restored in 41.58 minutes. 120.00 m 99.57 100.00 _c 80.00 63. c� 60.00 O 44.68 40.00 — - - -- Al 35:76 36.97 E 23 :89 - - - _ .26 20.00 - V 0.00 CP �o Oo �� <-Z� Cjo� 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 - .64 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. 3.50 N 3.00 c "a 2.50 0 , 2.00 0 1.50 as Cr 1.00 L 0- 0.50 0.00 (Z�' o`b o`b 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 18.75 months. II f TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED OPERATING EXPE NSE VARIANCE REPORT 9/30/09 SCHEDULE G ACTUAL BUDGET OPERATION EXPENSES: YEAR TO DATE YEAR TO DATE VARIANCE * CHANGE PURCHASED POWER BASE EXPENSE 7,421,401.77 7,239,385.00 182,016.77 2.51% OPERATION SUPER AND ENGIN-TRANS 0.00 0.00 0.00 0.00% OPERATION SUP AND ENGINEERING EXP 88,304.22 105,927.00 (17,622.78) -16.64% STATION SUP LABOR AND MISC 3,792.34 17,650.00 (13,857.66) -78.51% LINE MISC LABOR AND EXPENSE 147,202.51 144,713.00 2,489.51 1.72% STATION LABOR AND EXPENSE 126,194.80 103,703.00 22,491.80 21.69% STREET LIGHTING EXPENSE 9,459.02 19,773.00 (10,313.98) -52.16% METER EXPENSE 90,347.54 104,396.00 (14,048.46) -13.46% MISC DISTRIBUTION EXPENSE 76,521.87 85,141.00 (8,619.13) -10.12% METER READING LABOR & EXPENSE 22,726.60 16,581.00 6,145.60 37.06% ACCT & COLL LABOR & EXPENSE 323,359.74 357,414.00 (34,054.26) -9.53% UNCOLLECTIBLE ACCOUNTS 37,500.00 37,500.00 0.00 0.00% ENERGY AUDIT EXPENSE 112,734.47 273,680.00 (160,945.53) -58.81% ADMIN & GEN SALARIES 186,741.64 191,234.00 (4,492.36) -2.35% OFFICE SUPPLIES & EXPENSE 55,263.89 66,154.00 (10,890.11) -16.46% OUTSIDE SERVICES 55,038.22 111,758.00 (56,719.78) -50.75% PROPERTY INSURANCE 96,095.25 110,793.00 (14,697.75) -13.27% INJURIES AND DAMAGES 14,088.43 15,348.00 (1,259.57) -8.21% EMPLOYEES PENSIONS & BENEFITS 101,203.32 299,340.00 (198,136.68) -66.19% MISC GENERAL EXPENSE 35,634.43 56,219.00 (20,584.57) -36.61% RENT EXPENSE 41,415.37 53,001.00 (11,585.63) -21.86% ENERGY CONSERVATION 53,403.80 0.00 53,403.80 100.00% TOTAL OPERATION EXPENSES 1,677,027.46 2,170,325.00 (493,297.54) -22.73% MAINTENANCE EXPENSES: MAINT OF TRANSMISSION PLANT 681.24 750.00 (68.76) -9.17% MAINT OF STRUCT AND EQUIPMENT 14,228.32 38,375.00 (24,146.68) -62.92% MAINT OF LINES - OH 210,658.76 255,431.00 (44,772.24) -17.53% MAINT OF LINES - UG 34,975.99 36,027.00 (11051.01) -2.929,o MAINT OF LINE TRANSFORMERS 27,387.21 24,626.00 2,761.21 11.21% MAINT OF ST LT & SIG SYSTEM (87.81) 2,456.00 (2,543.81) -103.58% MAINT OF GARAGE AND STOCKROOM 128,670.88 149,280.00 (20,609.12) -13.81% MAINT OF METERS 531.31 1,205.00 (673.69) -55.91% MAINT OF GEN PLANT 20,232.12 29,025.00 (8,792.88) -30.29% TOTAL MAINTENANCE EXPENSES 437,278.02 537,175.00 (99,896.98) -18.60% DEPRECIATION EXPENSE 840,317.34 847,500.00 (7,182.66) -0.85% PURCHASED POWER FUEL EXPENSE 11,096,051.29 12,167,656.00 (1,071,604.71) -8.81% VOLUNTARY PAYMENTS TO TOWNS 313,500.00 313,500.00 0.00 0.00% TOTAL OPERATING EXPENSES 21,785,575.88 23 275 541.00 (1,489,965.12) -6.40% * ( ) = ACTUAL UNDER BUDGET (12A) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED OPERATING EXPENSE VARIANCE REPORT 9/30/09 RESPONSIBLE REMAINING SENIOR 2010 ACTUAL BUDGET REMAINING OPERATION EXPENSES: MANAGER ANNUAL BUDGET YEAR TO DATE BALANCE BUDGET % PURCHASED POWER BASE EXPENSE JP 26,794,251.00 7,421,401.77 19,372,849.23 72.30% OPERATION SUPER AND ENGIN-TRANS KS 0.00 0.00 0.00 0.005. OPERATION SUP AND ENGINEERING EXP KS 398,196.00 88,304.22 309,891.78 77.829. STATION SUP LABOR AND MISC KS 71,651.00 3,792.34 67,858.66 94.71% LINE MISC LABOR AND EXPENSE KS 576,553.00 147,202.51 429,350.49 74.475. STATION LABOR AND EXPENSE KS 423,826.00 126,194.80 297,631.20 70.229. STREET LIGHTING EXPENSE KS 79,519.00 9,459.02 70,059.98 88.10% METER EXPENSE DA 424,973.00 90,347.54 334,625.46 78.74% MISC DISTRIBUTION EXPENSE JD 345,498.00 76,521.87 268,976.13 77.859o METER READING LABOR & EXPENSE DA 66,772.00 22,726.60 44,045.40 65.96% ACCT & COLL LABOR & EXPENSE RF 1,462,217.00 323,359.74 1,138,857.26 77.89% UNCOLLECTIBLE ACCOUNTS RF 150,000.00 37,500.00 112,500.00 75.009. ENERGY AUDIT EXPENSE JP 1,105,759.00 112,734.47 993,024.53 89.80% ADMIN & GEN SALARIES VC 776,201.00 186,741.64 589,459.36 75.94% OFFICE SUPPLIES & EXPENSE VC 264,600.00 55,263.89 209,336.11 79.11% OUTSIDE SERVICES VC 398,500.00 55,038.22 343,461.78 86.195, PROPERTY INSURANCE JD 443,150.00 96,095.25 347,054.75 78.325. INJURIES AND DAMAGES JD 60,039.00 14,088.43 45,950.57 76.539. EMPLOYEES PENSIONS & BENEFITS JD 1,093,185.00 101,203.32 991,981.68 90.74% MISC GENERAL EXPENSE VC 223,038.00 35,634.43 187,403.57 84.02% RENT EXPENSE JD 212,000.00 41,415.37 170,584.63 80.46% ENERGY CONSERVATION JP 0.00 53,403.80 (53,403.80) 0.005, TOTAL OPERATION EXPENSES 8,575,677.00 1,677,027.46 6,898,649.54 80.44% MAINTENANCE EXPENSES: MAINT OF TRANSMISSION PLANT KS 3,000.00 681.24 2,318.76 77.29% MAINT OF STRUCT AND EQUIPMT KS 158,859.00 14,228.32 144,630.68 91.04% MAINT OF LINES - OH KS 1,060,849.00 210,658.76 850,190.24 80.14% MAINT OF LINES - UG KS 144,228.00 34,975.99 109,252.01 75.75% MAINT OF LINE TRANSFORMERS KS 93,500.00 27,387.21 66,112.79 70.71% MAINT OF ST LT & SIG SYSTEM JD 9,888.00 (87.81) 9,975.81 100.89% MAINT OF GARAGE AND STOCKROOM JD 625,632.00 128,670.88 496,961.12 79.439. MAINT OF METERS DA 4,863.00 531.31 4,331.69 89.07% MAINT OF GEN PLANT RF 116,100.00 20,232.12 95,867.88 82.57% TOTAL MAINTENANCE EXPENSES 2,216,919.00 437;278.02 1,779,640.98 80.28% DEPRECIATION EXPENSE RF 3,390,000.00 840,317.34 2,549,682.66 75.21% PURCHASED POWER FUEL EXPENSE JP 42,458,883.00 11,096,051.29 31,362,831.71 73.87% VOLUNTARY PAYMENTS TO TOWNS RF 1,254,000.00 313,500.00 940,500.00 75.00% TOTAL OPERATING EXPENSES 84,689,730.00 21,785,575.88 62,904,154.12 74.28% (its)