Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2012-03-29 RMLD Board of Commissioners Packet
To: Vincent Cameron From: Energy Services Date: March 21, 2012 Subject: Purchase Power Summary - February, 2012 Energy Services Division (ESD) has completed the Purchase Power Summary for the month of February, 2012. ENERGY The RMLD's total metered load for the month was 53,988,914 kwh, which was a decrease of 2.44 %, compared to the February, 2011 figures. Table 1 is a breakdown by source of the energy purchases. FJ .ATTACHNIENTI TABLE 1 % of Amour9 of Cost of Total Total $ $ as a Resource Energy Energy Energy Costa % (kWh) ($/Mwh) Millstone #3 3.413,879 $8.99 6.31% $23.855 0.83% Seabrook 4.675,198 $8.12 8.65% $37,983 1.32% JP Morgan 8,817,000 $56.49 16.30% $498,084 17.29% Sionybrook CC 91.631 $46.01 0.17% $4.216 0.15% NeMEna 10.085,000 $84.88 18.65% $654,268 22.72% NYPA 2,056.083 $4.92 3.80% $10.116 0.35% ISO Interchange 5,511,156 $32.12 10.19% $176,997 8.15% NEMA Congestion 0 $0.00 0.00% - $7.105 -025% Coop Resales $8,302 $132.19 0.16% $11.673 0.41% Stonybrook Peaking 0 $0.00 0.00% $11 0.00% Macao He 17,112,000 $7144 31.64% $1,258,878 43.64% Braintree Watson Unil 48,525 $95.05 0.09% $4.812 0.16% S.lt River Projects 2,178,076 $95.75 4.03% $208,549 7.24% Monthly Total 54,076,850 $53.26 100.00% $2,879,937 100.00% FJ .ATTACHNIENTI Table 2 breaks down the ISO interchange between the DA LMP Settlement and the RT Net Energy for the month of February, 2012. Table 2 N Amount Cost %of Total Resource of Energy of Energy Energy (kWh) ($/Mwh) ISO DA LMP' 7,030,225 32.07 13.00% Settlement RT Net Energy— - 1,519,069 31.88 -2.81% Settlement ISO Interchange 5,511,156 32.12 10.19% (subtotal) CAPACITY The RMLD hit a demand of 100,453 kW, which occurred on February 29, 2012 at 7 pm. The RMLD's monthly UCAP requirement for February, 2012 was 201,318 kWs. Table 3 shows the sources of capacity that the RMLD utilized to meet its requirements. Table 3 Amount of Cost of %of %of Capacity Capacity Total Total sour" (kWs) (S /kW- month) Capacity Total Cost$ Cost Millstone p3 4,991 $51.71 2.48% $258,106 19.31% Seabrook 7,910 $49.81 3.93% $393,971 29.47% Stonybrook Peaking 24,981 $2.02 12.41% $50,414 3.77% Stonybrook CC 42,925 $3.86 21.32% $165,597 12.39% NYPA 4,666 $2.81 2.32% $13,101 0.98% Hydro Quebec 4,274 $4.48 2.12% $19,148 1.43% ISO -NE Supply Auction 101,051 $3.24 50.19% $327,429 24.50% Braintree Watson Unit 10,520 $10.36 5.23% $108,951 8.15% Total 201,318 $6.64 100.00% $1,336,718 100.00% N Table 4 shows the dollar amounts for energy and capacity per source. Table 4 Cost of Amt. d %d Erurn, Poear Resource Energy Capacity Total cost Total Cost (kWh) ($kWh) Millstone #3 $23,855 $258,108 $281,960 6.69% 3.413,879 $0.0828 Seabrook $37,983 $393,971 5431.955 10.24% 4,875,196 $0.0924 Stonybrook CC 54,218 $165,597 $169,813 4.03% 91,831 $1,8532 Hydro Quebec 59 $19,148 $19,148 0.45% 0 $0.0000 NextEm $854,268 $0 $654,288 15.52% 10,085.000 $0.0849 NYPA $10,116 $13,101 $23.217 0.55% 2,058,083 $0.0113 ISO Interchange $176,997 $327,429 $504,426 11,96% 5,511,156 $0.0915 NEMA Congestion - $7,105 $0 47,10$ .0.17% 0 50.0000 Coop Resales $11,673 50 $11,673 0.28% 88,302 $0.1322 Stonyorook Peaking $11 $50,414 $50,425 1.20% 0 $0.0000 JP Morgan $498,084 $0 $498.084 11.81% 8,817,000 $0.0585 MacQuane $1,258,878 $0 $1,256.678 29.80% 17,112,000 $0.0734 Braintree Watson Unit 54,812 $108,951 $113.564 2.69% 48,525 $2.3403 SsW6 River Projects $208,549 $0 $208,549 4.95% 2,178,076 $0.0957 Monthly Total $2,879,937 $1,336,718 $4,216,655 100.00% 54,078,850 $0.0780 TRANSMISSION The RMLD's total transmission costs for the month of February were $581,199. This is a decrease of 9.93% from the January transmission costs of $638,899. In February, 2011 the transmission costs were $744,186. Table 5 shows costs for the current month vs. last month and last year (February, 2011) Table 5 Currant Month Last Month (Jan '12) Last Year (Feb *11) Peak Demand kW) 100.453 108,558 108,295 Energy (kWh) 54,078,850 59,550,250 55,387.717 Energy ($) $2.879.937 $3.338,331 $2,983,760 Capacity (S) $1,336,718 $1,337,348 $1.516.708 Transmission ($) $581.199 $638.899 $744,188 Total $4.797.854 $5,314,578 $5.244.654 I Fm anm d m a m a m d m m m d `m w v d _ry s E p Ep E E E Epp p Ep E F pF Z UVUUUUUUU d N ❑ o °oqo O U s d Ea 0 0 0 0 0 0 0 eo o o 8 6655 U a m a m a m d m a a s E E E E p Ep E E E 2 U UUUUVUQ0 d F ❑ mrngmg gmg moos c iaz N gvi rn a 3 E 000aOO ooib� O U d m E 888888888 0 V G d a _a t v C V N r W x V Q Q o m rng rn a o o �09990000 _o V U C TTU C l� f� • OW � I L�❑���❑� � Onnal O O O O � O N m a` � N V Em ma y �m €m�3aci CL ¢0 aciv Y ❑ O U n DC U U V a d U _ E m x 5 a U m 'aim c_o 0 00 H c:4�ro3� � C w E c m E n'rn r o o d 2 E E 2 2? a m o� o 0 02 t¢ (C L C L< C N C N YI OI O W 1(1 ` N N N4 0 0 0, 0 0 W d ; (7 iW Ui❑UUUUU � ¢r`�rrrrmLL V G d a _a t v C V N r W x V Q Q u .O CL W a m L 01 Q L ) C C L O U) C m LL 4 m co r-- m m v m N o oa suoipiw ui sielloa a. � d m v � ._ t o a` 5 a 0 0 H H 1 L C O d Y R 0 F 20 Y v d L a d v �v L CL Q 3 m d s Y C 0 Nm LL m N 3 H d .O a L AV I6 34312012 10:36 AM READING MUNICIPAL LIGHT DEPARTMENT FY 12 CAPITAL BUDGET VARIANCE REPORT FOR PERIOD ENDING FEBRUARY 29, 2012 8 PROJECT DESCRIPTION E60C L tl System Pm]Ocu 1 SW9 Recendudrng- 6atlardvale Susan 2 High Capacity Tie 4W18 and 3W8 Franklin Street 3 Upgrading Old Lynnfidd CV URDs SCADA Prolecb 4 RTU Replacement Distribution Automation Prolecb 6 Reclosurea 6 Capacitor Banks T SCADA Radio Communication System $Upon Upgrades (Station "GAIN) 8 Relay Replacement Project 9 115kV Disconnect Replacement thar, Customer Service Connections 12 Service Installations - Commerda0l idustrial Customers 13 Service Installations- Residential Customers 14 Routine Construction Various Routine Construction Total Construction Projects Other Prolecb 16 GIB 16 TransformerslCepachors Annual Purchases 17 Meter Annual Purchases 17A Meter Upgrade Project 18 Purchase New Small Vehicle 19 Purchase Line Department Vehicle 20 Purchase Puller Trailer 21 Roof Top Units 22 Engineering Soeware and Date Conversion 23 Plotter 27 Hardware Upgrades 23 Software and Licensing 0TH Coding Taxer Replacement Total Other Projects TOTAL RMLD CAPITAL PROJECT EXPENDITURES 21 Force AccountlReimbursable Projects TOTAL FY 12 CAPITAL PROJECT EXPENDITURES completed projects ALL ACTUAL YTD ACTUAL ANNUAL (514,685) 157,352 COST COST BUDGET 1002,788 TOWN FEBRUARY THRU L 22112 AMOUNT VARIANCE W 956 160,588 242,649 82,061 R 10,505 122,873 157,766 34.883 LC 75,000 377 579,927 579,550 R 30.000 1.840 130,255 128,615 ALL 197,901 197,901 ALL 2,072 11,614 105,052 93,438 ALL 94,435 68,375 231,386 231,386 R 08,706) 2,803 99,658 96.853 R 314,621 49,738 88,585 36,847 ALL 870 30,850 62,530 31.680 ALL 19,615 123,767 206,017 82,250 ALL 234,187 1,531,067 1,016,382 (514,685) 157,352 288.206 2,036,317 3.111106 1002,788 ALL - 314,621 2,680,461 5.910,OQ 3,229,596 8,715 50,000 41,205 157,352 198,800 41,448 7,855 46,360 38,505 45,021 361,071 1,740.656 1,379,585 31,544 38,000 4,456 386,000 388,000 75,000 75,060 30,000 30.000 76,690 78,690 18,000 18,000 1,395 33.831 40,000 6,169 26,080 94,435 68,375 18.706 - 08,706) 18.418 6461,u 2,T91,941 211880] 314,621 2,60,461 6,910,017 3,2",596 ALL - 314,621 2,680,461 5.910,OQ 3,229,596 Reading Municipal Light Department Engineering and Operations Monthly Report February 2012 FY 2012 Capital Plan E &O Construction — System Projects 1. 5W9 Reconductoring — Ballardvale Street - Wilmington — Engineering labor. 2. High Capacity Tie 4W1813WB Franklin Street — Reading — Pole transfers; install transformer; install taps; energized new spacer cable. 3. Upgrading of Old Lynnfield Center URDs — Engineering labor. SCADA Projects 4. RTU Replacement at Station 4 — Reading — No activity. Distribution Automation (DA) Projects 4 5. Reclosers — No activity. 6. Capacitor Banks — Build capacitor banks; Engineering and Senior Tech labor. 7. SCADA Radio Communication System — No activity. Station Upgrades 8. Relay Replacement Project — Station 4 — Reading — No Activity. 9. 115 kV Disconnect Replacement — Station 4 — Reading — 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 replacementlinstallations, primary or secondary cable replacement/installations etc. This portion of the project comes under routine construction. Notable: Commercial building at 57 -59 High Street, Reading. 13. Service Installations —Residential Customers— This item includes new or upgraded overhead and underground services, temporary overhead services, and large IVunderground development. 14. Routine Construction —The drivers of the Routine Construction budget category YTD are listed. This is not an inclusive list of all items within this category. Pole Settin g7ransfers $226,318 Maintenance OverheadNnde round $416,594 Projects Assi ned as Required $374,930 Pole Damage includes knockdowns some reimbursable $35,405 Station Group $2,967 Hazmat/Oil Spills $3,118 Porcelain Cutout Replacement Program $2,825 Lighting ( Street Li ht Connections $60,866 Storm Trouble $80,174 Underground Subdivisions $57,094 Animal Guard Installation $53,664 Miscellaneous Capital Costs $217,112 TOTAL $1,531,067 `In the month of February one cutout was charged under this program. Approximately 18 cutouts were installed new or replaced because of damage making a total of 19 cutouts replaced this month. I 11 P 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 Minutest Total number of customers interrupted. RMLD 12 month system average outage duration — 61.10 minutes RMLD 4 year average outage (2006.2009) — 50.98 minutes per outage On average, RMLD customers that experience an outage are restored in 61.10 minutes. 180.00 160.00 N d 140.00 C 120.00 d � 100.00 O 80.00 v E 60.00 0 40.00 U 4i 0.00 PQ e�P ��o �J� P�0 �� oa op System Average Interruption Frequency (SAIFI) - Measures how many outages each customer experiences per year on average. SAIFI = Total number of customer's interrupted / Total number of customers. RMLD 12 month system average - .45 outages per year RMLD 4 year average outage frequency - .82 The graph below tracks the month -by -month SAIFI performance. N C d V U C O T U G d LL SO �o P °A 1�10 o`' \° Omc+ lac ��r — HMLD monthly outage frequency --- RMLD 12 month system average outage frequency .45 s Months Between Interruptions (MBTI) Another view of the SAIFI data is the number of months Reading customers have no interruptions. At this time, the average RMLD customer experiences an outage approximately every 26.6 months. Is 0.91 0.90 - 0 — - - — -- - - - -.. 0.80 n 0.70 0.60 0.50 0.50 0.40 — _ - — - — . — — . V 5—_.__ 31 0.30 - 0 .21 0.23- 0.20 0.10 0.00 SO �o P °A 1�10 o`' \° Omc+ lac ��r — HMLD monthly outage frequency --- RMLD 12 month system average outage frequency .45 s Months Between Interruptions (MBTI) Another view of the SAIFI data is the number of months Reading customers have no interruptions. At this time, the average RMLD customer experiences an outage approximately every 26.6 months. Is Dt: March 22, 2012 ATTACHMENT 3 To: RMLB, Vincent F. Cameron, Jr., Jeanne Foti Fr. Bob Fournier Sj: February 29, 2012 Report The results for the eight months ending February 29, 2012, for the fiscal year 2012 will be summarized in the following paragraphs. 1) Change in Net Assets: (Page 3A) For the month of February, the net loss or the negative change in net assets was $171,275, decreasing the year to date net income to $2,252,998. The year to date budgeted net income was $5,152,642, resulting in net income being under budget by 2,899,643 or 56.27 %. Actual year to date fuel expenses exceeded fuel revenues by $951,296. 2) Revenues: (Page 11B) Year to date base revenues were under budget by $2,379,741 or 7.19 %. Actual base revenues were $30.7 million compared to the budgeted amount of $33.1 million. 3) Expenses: (Page 12A) *Year to date purchased power base expense was under budget by $1,227,727 or 6.79 %. Actual purchased power base costs were $16.8 million compared to the budgeted amount of $18.0 million. *Year to date operating and maintenance (O &M) expenses combined were under budget by $108,743 or 1.4 %. Actual O &M expenses were $7.7 million compared to the budgeted amount of $7.8 million. *Depreciation expense and voluntary payments to the Towns were on budget. 4) Cash (Page 9) *Operating Fund was at $9,393,162. *Capital Fund balance was at $3,993,461. • Rate Stabilization Fund was at $6,069,924. • Deferred Fuel Fund balance was at $2,103,928. • Energy Conservation Fund balance was at $178,810. 5) General Information: Year to date kwh sales (Page 5) were 471,283,857 which is 19.4 million kwh or 3.97 %, behind last year's actual figure. GAW revenues collected ytd were $471,296 bringing the total collected since inception to $1,078,469. 6) Budget Variance: Cumulatively, the five divisions were under budget by $151,980 or 1.2 %. \J FINANCIAL REPORT ® FEBRUARY 29, 2012 w ISSUE DATE: MARCH 22, 2012 NET ASSETS TOWN OF READING, MASSACHUSETTS INVESTED IN CAPITAL ASSETS, NET OF RELATED DEBT 67,514,565.76 MUNICIPAL LIGHT DBPARTNHNT 67,872,740.75 RESTRICTED FOR DEPRECIATION FUND (P.9) 4,676.350.65 BUSINESS -TYPE PROPRIETARY PUND UNRESTRICTED 20,964,B51.16 STATEMENT OF NET ASSETS TOTAL NET ASSETS (P.3) 93.055.767.57 95.856.560.89 2/29/13 TOTAL LIABILITIES AND NET A888T6 105.017.816.84 106.430.286.60 PREVIOUS YEAR CURRENT YEAR ASSETS CURRENT UNRESTRICTED CASH (SCH A P.9) 7,225,949.28 9,396,162.56 RESTRICTED CASH (SCH A P.9) 15,894,798.57 16,319,354.53 RESTRICTED INVESTMENTS (S CH A P.91 3,200,000.00 0.00 RECEIVABLES, NET (SCH B P.10) 8,660,820.16 7,403,407.33 PREPAID EXPENSES (SCH B P.10) 1,777,303.90 1,949,732.19 INVENTORY 1,656,277.91 1,405,233.69 TOTAL CURRENT ASSETS ]7.415.149.83 ]8 473.780.19 NONCURRENT INVESTMENT IN ASSOCIATED CO (S® C P.2) 881151.26 73,765.66 CAPITAL ASSETS, NET (SCH C P4) 67,514,565.76 67,872,740.75 TOTAL NONCURRENT ASSETS 67.603.717.03 67,946,506.41 TOTAL ASSETS 105,017.866.84 106.430.386.60 LIABILITIES CURRENT ACCOUNTS PAYABLE 6,964,736.44 5,510,734.48 603,349.01 CVSTO318R DEPOSITS 516,980.20 CUSTOMER ADVANCES FOR CONSTRUCTION 330,793.90 394,339.94 ACCRUED LIABILITIES 1,129,555.98 1,221,683.70 TOTAL CURRENT LIABILITIES 8.91].Ofi6.52 7,629,007.13 NONC RMT ACCRUED EMPLOYRB CONPENSATfiD ABSENCES 3.020.033.75 2,934,698.55 TOTAL NONCURRENT LIABILITIES 3.020 012.75 ] 934.698.5E TOTAL LIABILITIES 11.96].099.27 10.563.705.71 NET ASSETS INVESTED IN CAPITAL ASSETS, NET OF RELATED DEBT 67,514,565.76 67,872,740.75 RESTRICTED FOR DEPRECIATION FUND (P.9) 4,676.350.65 3,993,461.42 UNRESTRICTED 20,964,B51.16 23,990,378.73 TOTAL NET ASSETS (P.3) 93.055.767.57 95.856.560.89 TOTAL LIABILITIES AND NET A888T6 105.017.816.84 106.430.286.60 W TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT NONCURRENT ASSET SCHEDULE 3/19/12 SCHEDULE OF INVESTMENTS IN ASSOCIATED COMPANIES NEW ENGLAND HYDRO ELECTRIC NEW ENGLAND HYDRO TRANSMISSION TOTAL INVESTXZMTS IN ASSOCIATED COMPANIES SCHEDULE OF CAPITAL ASSETS LAND STRUCTURES AND IMPROVEMENTS EQUIPMENT AND FURNISHINGS INFRASTRUCTURE TOTAL CAPITAL ASSETS, NET TOTAL NONCURRENT ASSETS (xl 1,]65,842.23 SCHEDULE C 1,26$,862.33 PREVIOUS YEAR CURRENT YEAR 23,538.60 15.]1).61 66,612.66 581018.01 88.151.16 67,514.565.76 ]].)fi 5.66 75 1,]65,842.23 1,26$,862.33 6,685,376.77 6,639,578.36 13,169,)55.23 13,931,726.76 66,193,591.53 67,035,593.63 67,514.565.76 67.872 760 75 67.602,]1] .02 67,966.506.11 OPSMTINO S%PENS59: (9CH E 1.13) PVRCNASED PONTA BABE PURCNA96D POWER PURL OPERATING MAINTENANCE DEPRECIATION VOLUNTARY PAYMENTS TO TONN9 TOTAL OPERATING EXPENSES OPERATING INCOME `PIRATING REVENUES (EXPENSES) CONTRIBOI1099 IN AID OF CONST RETURN ON INVESTMENT TO READING INTEREST INCOME INTEREST EXPENSE OTHER (MDSE AND ABORT) TOTAL NONOPBRATINO Re (EXP) CHANGE IN NET ASSETS NET ASSETS AT BEGINNING OP YEAR NET ASSETS AT END OT FEBRUARY 1,163,102.35 TIMOR OF READING, MASSACHUSETTS 18,651,619.58 16,655,504.43 -9.63% MUNICIPAL LIM DEPARTMENT 1,079,936.88 27,634,995.12 25,617,704.49 EOEI6REE -TYPE PROPRIETARY POND 703,748.92 187,674.74 5,653,793.60 STATEMENT OB REVENUES, EE MSSS AND MONCES IN 1. NIT ASSETS 1.828 176,117.50 159,649.03 2,918,009.51 2/29/12 1,970,170.71 - 32.48% 187,719.05 196,017.47 MONT1 mM7H[ LABT YEAR 2,368,219.76 MEANT YEAR 1.88% YTD \ 110.000.00 "ST IRAN CURRINT YEAR TO DATE 875 065.00 TO DATE 900.186.00 CWMOE 2.77% OPERATING REVENUES: (SCN D P.11) 3,759,654.33 3,434,875.16 31,066,574.87 30,715,B37.38 -1.19% BASE REVENUE 3,153,393.61 2,594,141.71 28,301,328.01 25,136,688.06 . 11.18% FUEL RWEMDR 41,237.55 (91056.38) 1,190,798.38 (89,529.87) - 107.47% PORCMASED PONTA CAPACITY 83,708.41 70,491.05 697,456.41 636,950.33 -8.6B% FORFEITED DISCOUNTS 51,023.19 349,934.25 404,230.88 15.52% ENERGY CONSERVATION REVCN6 38,785.14 350,069.55 471,296.56 34.32% GAN REVENUX 56,324.44 51,893.94 (62.465.74) (520. 066.72) (460.280.18) - 11.50% NYPA CREDIT (92.678.30) TOTAL OPERATING REVENGES 7,041,505.10 6,130,102.93 61,462,091.75 56,815,193.86 -7.56% OPSMTINO S%PENS59: (9CH E 1.13) PVRCNASED PONTA BABE PURCNA96D POWER PURL OPERATING MAINTENANCE DEPRECIATION VOLUNTARY PAYMENTS TO TONN9 TOTAL OPERATING EXPENSES OPERATING INCOME `PIRATING REVENUES (EXPENSES) CONTRIBOI1099 IN AID OF CONST RETURN ON INVESTMENT TO READING INTEREST INCOME INTEREST EXPENSE OTHER (MDSE AND ABORT) TOTAL NONOPBRATINO Re (EXP) CHANGE IN NET ASSETS NET ASSETS AT BEGINNING OP YEAR NET ASSETS AT END OT FEBRUARY 1,163,102.35 1,921,157.69 18,651,619.58 16,655,504.43 -9.63% 2,983,159.61 1,079,936.88 27,634,995.12 25,617,704.49 -7.16% 703,748.92 187,674.74 5,653,793.60 5,756,790.43 1.828 176,117.50 159,649.03 2,918,009.51 1,970,170.71 - 32.48% 187,719.05 196,017.47 1,301,831.40 2,368,219.76 1.88% 110.000.00 _ 11l 000.00 875 065.00 900.186.00 2.77% 6,626,517.43 6,167,546.01 56,035,404.11 53,478,675.61 -7.85% 414,9B7.75 (37,443.09) 3,416,467.54 3,336,518.04 -1.63% 100.00 6,115.20 35,087.42 45,744.84 30.37% (180,990.00) (103,819.75) (1,447,910.00) (1,470,638.00) 1.57% 1,969.32 3,915.77 70,036.05 64,404.70 -7.93% (1,001.20) (501.39) (10,295.10) (5,718.36) - 44.36% 5,500.88 36,458.71 161,507.15 282,617.14 73.91% (17l 321.001 (133,631.461 - 11,190.584.581 (1,003 .519.611 -6.99% ]41.666.]5 (171,]74.541 ],235,90].96 2,252,996.41 OI 90,519,864.61 93,603,581.47 93.055.767.57 95 85 6,500 89 0.76% 3.07% 3.01% TONS OF READING, MASSACHUSETTS NUNICIPAL LIGHT DEPARTMENT BUSINESS -TYPE PROPRIETARY FUND STATEMENT OF REVERIES, EXPENSES AND CHARGES IN FUND NET ASSETS 2/29/12 OPERATING REVENUES: (SCE P P.11R) BASE REVENUE FUEL REVENUE PURCHASED POWER CAPACITY FORFEITED DISCOUNTS ENERGY CONSERVATION REVENUE GAN REVENUE NYPA CREDIT TOTAL OPERATING REVENUES OPERATING EXPENSES: (SCH 0 P.12A) PURCHASED POWER BASE PURCHASED POWER FUEL OPERATING WAINTENANCE DEPRECIATION VOLUNTARY PAYNBNTS TO TOWNS TOTAL OPERATING EXPENSES OPERATING INCOME NONOPERATING REVENUES (RXPENSES) CONTRIBUTIONS IN AID OF CONST RETURN ON INVESTRENT TO READING INTEREST INCOME INTEREST EEPENBE OTHER (RUSE AND AMORT) TOTAL NONOPERATING REV (SAY) CHANGE IN NET ASSETS "I ASSETS AT BEGINNING OF YEAR NET ASSETS AT ENO OF FEBRUARY ( ) = ACTUAL UNDER BUDGET ACTUAL BUDGET % YEAR TO DATE YEAR TO DATE VARIANCE- CHARGE 30,715,837.38 33,095,579.00 (2,379,741.62) -7.19% 25,136,688.86 28,555,504.00 (3,418,615.14) - 11.97% (89,529.87) (94,363.00) 4,833.13 -5.12% 636,950.33 728,103.00 (91,152.67) - 12.52% 404,230.88 368,057.00 36,173.80 9.83% 471,296.56 462,504.00 8,793.56 1.90% (460 280.28) (400.000.00) (60.280 28) 15.07% 56,815,193.86 63,715,384.00 (5,900,190.141 -9.41% 16,855,504.43 18,083,232.00 (1,337,727.57) -6.79% 25,637,704.49 27,355,705.00 (1,738,000.51) -6.32% 5,756,790.43 5,983,989.00 (]]7,198.57) -3.80% 1,970,270.71 11851,816.00 118,454.71 6.40% 2,368,219.76 2,400,000.00 (31,780.24) -1.32% 900.186.00 904.000.00 (3.814.00) -0.42% 53,478,675.82 56,578,742.00 (3,100,066.10) -5.48% 3,336,518.04 6,136,642.00 (2,800,123.96) - 45.63% it 45,744.84 300,000.00 (254,255.16) - 84.75% (1,470,638.00) (1,480,000.00) 9,362.00 -0.63% 64,484.78 120,000.00 (55,515.22) - 46.26% (5,738.38) (4,000.00) (1,738.38) 43.21% 282,617.14 801000.00 202,617.14 253.27% (1.083 519.631 1984.000.001 199.519.611 10.11% 2,353,998.42 5,152,642.00 (2,899,643.58) 93,603,583.47 93,603,582.47 0.00 95.856.580.69 90 756,]]4.47 13.699. 64J.581 ll.1 - 56.27% 0.00% -2.94% E IV TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT RECONCILIATION OF CAPITAL FUNDS 2/29/12 SOURCE OF CAPITAL FUNDS! DEPRECIATION FUND BALANCE 7/1/11 CONSTRUCTION FUND BALANCE 7/1/11 INTEREST ON DEPRECIATION FUND PY 12 DEPRECIATION TRANSFER PY 12 FORCED ACCOUNTS REIMBURSEMENT SAN SUBSTATION IPY 12) TOTAL SOURCE OF CAPITAL FUNDS USE OF CAPITAL FUNDS: PAID ADDITIONS TO PLANT THRU FEBRUARY PAID ADDITIONS TO SAW THRU FEBRUARY TOTAL USE OF CAPITAL FUNDS GENERAL LEDGER CAPITAL FUNDS BALANCE 2/29/12 PAID ADDITIONS TO PAID ADDITIONS TO PAID ADDITIONS TO PAID ADDITIONS TO PAID ADDITIONS TO TOTAL DAN DAN SAW DAN DAN FROM PY 12 FROM PY 11 FROM PY 30 FROM PY 09 FROM PY O8 2,680,450.92 O.00 4,297.944.13 0.00 7,748.45 2,368,219.76 0.00 0.00 6,673,912.34 2,680,450.92 3.993.461.42 0.00 531,784.00 1,372,876.00 3.136,764.00 1,895.975.00 6,93),399.00 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SALES OF KILOWATT HOURS ]/39/13 /29/12 E W MONTH MONTH LAST YEAR CURRENT YEAR YTD % SALES OF ELECTRICITY. LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE RESIDENTIAL SALES 21,553,664 19,102,964 185,141,203 175,477,409 -5.22% CONK. AND INDUSTRIAL SALES 31,894,561 30,118,446 284,367,623 375,343,217 -3.17% PRIVATE STREET LIGHTING 72,796 73,447 575,725 593,883 1.42% TOTAL PRIVATE CONSUMERS 53,511.031 49.29{,857 470.084.750 451,404.509 -3.97% MUtICIPAL SALES: STREET LIGHTING 239,009 239,338 11910,596 1,913,265 0.14% MUNICIPAL BUILDINGS 917,228 791,333 6,752,709 6,458,149 -4.36% TOTAL MUNICIPAL CONSUMERS 5, 156. 3J7 1,030,671 8.66].105 81371.414 -3.37% SALES FOR RESALE 299,087 247,609 2,433,871 2,297,395 -5.22% SCHOOL 1,334,900 1,310,003 9,570,800 9,210,539 -3.76% TOTAL KILOWATT HOURS SOLD 56,311,345 51,883.300 490,742.72fi 471,283,857 -3.975 E W TOWN OF REMING, MASSACHUSETTS MUNICIPAL LIGHT GNPARFKKNT KILOWATT NOOKS SOLD BY TOWN 2/19/11 TOTAL READING LYNNPIRL0 NO. RBAOING WILMINGTON MONTH RESIDENTIAL 19,102,964 6,055,241 2,531,801 4,594,874 5,911,047 COM4 A IND 30,118,446 3.906,338 242,659 4,643,589 21,325,860 PVT ST LIGHTS 73,447 13,737 1,360 11,108 36.142 PUB ST LIGHTS 139,338 80,536 32,480 39,963 86.359 HUNT SLOGS 791,333 249.915 131,474 126,364 182,580 SALES /RESALE 247,689 147,689 0 0 0 SCHOOL 1,310,083 464,151 269,787 171,310 404,825 TOTAL 51.883.300 11.017.607 ].110.561 9.598.218 18.056.913 YEAR TO DATE RESIDENTIAL 175,477,409 54,933,316 14.871,283 41,075,196 54,597,514 COHN 6 In 175,343,117 35,070,011 2,118,177 41,673,553 195,381,476 PVT ST LIGHTS 563,883 111,311 10,880 171,772 289,919 PUB ST LIGHTS 1,913,265 643,788 259,582 319,103 690,692 HUNT BLDGS 6,458,149 1,655,432 1,098,987 1,263,191 1,437,438 SALES /RESALE 2,197,395 1,197,395 0 0 0 SCHOOL 9,210,539 3,291,026 1,015,795 1,179.400 2,724,318 TOTAL 471.283.857 98.005.180 30.474.704 8fi,fi81.516 256.111.]57 LAST YEAR TO DATE RESIDENTIAL 185,141,202 57,919,838 26,593,942 43,062,148 57,565,274 COMM 6 in 284,367,813 35,399,357 2,309,891 41,877,297 103,781,178 PVT ST LIGHTS 575,715 111,918 10,880 170,401 181,515 PUB ST LIGHTS 1,910,596 643,488 259,646 317,656 689,804 MUSI SLOGS 6,752,709 1,795,994 1,165,679 1,367,101 2,413,834 SALES /RESALE 2.413,871 2.413,871 0 0 0 SCHOOL 9,570,800 3,403,340 2,033,713 1,245.000 2,888,829 TOTAL 490.741.716 101.697.714 31.373.763 89,039.705 267,631.534 KILOWATT HOURS SOLD TO TOTAL TOTAL READING LYNN7I3LD NO.READINS WILMINGTON MONTH RESIDENTIAL 36.82% 11.67% 6 50.14% 7.53% 0.47% 0.47% 8.95% 6.95% 41.41% 41.10% LIGHTS PVT ST LIGHTS PVT 0.14% 0.16% 0.06% 0.04% 0.07% PUB 8T LISHT9 0.40% 0.06% 0.08% 0.16% MUNI SLOGS 1.52% 1.52% 0.48% 0.16% 0.24% 0.54% SALES /AEBALE 0. 0.48% 0.00% 0.00% 0.00% SCHOOL 1.5]\ 53% 0.89\ 0.514 0.]]h 0.79\ TOTAL 100.00% 11.14% 6.191 18.50\ 54.07% YEAR TO DATE RESIDENTIAL 37.14% 11.66% 5.18% 8.72% 11.58% COME c IND 58.42% 7.44% 0.47% 9.05% 41.46% PVT BY LIGHTS 0.12% 0.02% 0.00% 0.04% 0.06% POE BY LIGHTS 0.41% 0.14% 0.06% 0.07% 0.14% MUNI RIDGE 1.37% 0.35% 0.13% 0.27% 0.52% SALES /RESALE 0.49% 0.49% 0.00% 0.00% 0.00\ SCHOOL 1.95% 0.70% 0.43% 0.25% 0.57% TOTAL 100.00t 10.80% 6.47% 18.40\ 54.33% LAST YEAR TO DATE 37.72% 17.31% 5.42% 8.77% CORESIDENTIAL COMM 4 IND 57.95% 7.11% 0.47% 0.74% 41.7]% 11.5]% IG PVT ST LIGHTS 0.2% 0.02% 0.0 0.0 0.07% P US ST LIGHTS 0.41% 0.33% 0.5% 0.6% 0. SORT: BLOG9 1. 0. 0.24% 0.28% 0.49% SALES/RESALE 0.49% 0.49% 0.00% 0.00% 0.00% SCHOOL 1.91% 0.69% 0.415 0.35\ 0.57\ TOTAL 100.00\ 10.71% 6.59\ 18.13\ 54.577L (6) TONS OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT FORMULA INCOME 1/39/13 TOTAL OPERATING RRPRNDRS ADD: POLE RENTAL LESS: (P.3) 56,815.193.86 IMNREST INCOME ON CUSTOMER DEPOSITS OPERATING EXPENSES (P.3) CUSTOMER DEPOSIT INTEREST EXPENSE PORMNLA INCOME (LOSS) 1,455.00 ]93.01 (53,478,675.83) (5,738.30) 3.333.0]6.60 11 11 0 in SALE OF EWH (P.S) IRS PURCHASED AVE BASE COST PER KWH AVE BASE SALE PER ERR AVE COST PER ERR AVE SALE PER HRH FUEL CHARGE REVENUE (P.3) LOAD FACTOR V LOAD 0 TORN OF READING, NASSACHUSETTB MUNICIPAL LIGHT DEPARTMENT! GENERAL STATISTICS 2/29/13 HOHTH OE FEB 3011 56,311,245 55,387,717 0.040859 0.066766 0.094730 0.122765 3,153,393.61 70.06% 108,295 NONTM OP FEB 2013 51,883,300 54.076,850 0.035528 0.066204 0.088785 0.116203 2.594,141.71 73.74% 100,453 m % CBAN08 YEAR THRU 2011 2013 FEE 2011 FEB 2012 4.99% -3.97% 490,742,726 471,283,857 4.90% -2.82% 501,785,567 487,656,547 -3.96% -7.01% 0.037171 0.034564 11.23% 2.77% 0.063420 0.065175 -5.28% -5.56% 0.092244 0.087117 .0.55% -2.07% 0.121012 0.118511 -7.23% . 11.18% 28,301,328.01 25,136,688.86 N (1) ::3 D c m i2 t, ray, J ,7 O `r b �i 'All °b o� u o� dp 0+ Y.1 O�O;�V Oi SS p o�� 6 01 01 obdN 01 &0 J Q� 4Y &0� yo°S S O:b 7n 60' 7n 006- �y 0 0 O O O O O O 9 69- W 69- Gr� P1 cu I I I I m i2 t, ray, J ,7 O `r b �i 'All °b o� u o� dp 0+ Y.1 O�O;�V Oi SS p o�� 6 01 01 obdN 01 &0 J Q� 4Y &0� yo°S S O:b 7n 60' 7n 006- �y 0 f O O O O O O 9 69- A 69- Gr� P1 0 f TOM OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHBDULB OF CASH AND INVSSTHBNTS 2/39/13 SCHEDULE A EI 191 PREVIOUS YEAR CURRENT YEAR UNRESTRICTED CASH: CASH - OPERATING FUND 7,223,949.38 9,393,162.56 CASH - PETTY CASH 3,000.00 3,000.00 TOTAL UNRESTRICTED CASH 2225694948 9.396.162.56 pETRICTBn CASH: CASH - DEPRECIATION YUNO 4,676,350.65 3,993.461.43 CASH - TOWN PAYN= 562,500.00 894,000.00 CASH - DEFERRED FUEL RESERVE 2,472.376.26 2,103,928.67 CASH - RATE STABILIZATION FORD 4,382,097.46 6,069,924.65 CASH - UNCOLLECTIBLB ACCTS RESERVE 200,000.00 300,000.00 CASH - SICK LEAVE BENEFITS 2,025,247.32 2,953,598.35 CASH - HAYARD WASTE RESERVE 150,000.00 150,000.00 CASH - CUSTOMER DEPOSITS $16,980.20 602,249.01 CASH - BEE BUY CONSERVATION 274,631.71 170,810.37 CASH - OPEN 614,624.97 1,173,281.95 TOTAL RESTRICTED CASH 15.894.798.57 18.319.254.53 EgSTID,wn INVESTMENTS • 11000,000.00 0.00 RATE STABILIZATION SICK LEAVE BUYBACK •r 1,000,000.00 0.00 OISE ur 200,000.00 0.00 TOTAL RESTRICTED INVESTHENTS 2.300.000.00 0.00 TOTAL CASH BALANCE 25.330.747.85 22715.417.08 YEH1011: • PREDDIE HAC 1,000,000.00; WD 09/10/10; INS 2.00•; MATURITY 09/15/20 •• PREDDIE EAC 1,000,000.00; DID 09/10/10; IHT 2.00 \; MATDRITY 09/15/20 ••• PREDDIE EAC 300,000.00; DTD 09/10/101 IM 2.00 %1 I,TDBITT 09/15/20 EI 191 TOM OF READING, NASEACXNSESTS MUNICIPAL LIOXT DEPARTHENT SCHEDULE OF ACCOUNTS RECEIVA BLL 2/29/12 SCHEDULE E if BCB60ULE OF ACCOUNTS RECEIVABLE PRSVI008 YEAR 2,869,268.20 CURRENT YEAR RESIDENTIAL AND CONNERCIAL 5,073,105.53 1,101,163.56 (]59 121 1,296,204.42 ACCOUNTS RECEIVABLE - OTHER 136,454.79 222,641.30 2,869,268.20 ACCOUNTS RECEIVABLE - LIENS 10],)68.97 198,8]].16 245,]4).57 ACCOUNTS RECEIVABLE - ENPLOYEE ADVANCER 89]892.14 239,666.63 65,168.95 238,330.65 SALES DISCOUNT LIABILITY .11 1384, (384,252.63) 11,308.71 89].14 155,415.85 RESERVE FOR 3UCOLLECTIBLE ACCOUNTS (323,307,75) 144,513.70 1254,121.11 ) ) TOTAL ACCOUNTS RECEIVABLE BILLED TOTAL PREPAYMENT _ 1 77®,303,90 (306,919,78) 1,949,7]2.19 72 5.45% 2,573,112.86 2,615.146.39 UNFILLED ACCOUNTS RECEIVABLE 4,055,159.11 4,830.294.37 TOTAL ACCOUNTS RECEIVABLE, NET 1.660.820.16 _ SCNEDDLB OF PRRPAYNBNTS 2,869,268.20 PREPAID INSURANCE 1,101,163.56 (]59 121 1,296,204.42 PREPAYMENT PURCHASED POWER 222,641.30 2 61 PREPAYMENT PARRY CURRENT 245,]4).57 PREPAYMENT WATSON 239,666.63 30 DAYS 238,330.65 EA PURCRBD POWER WORKING CAPITAL 11,308.71 60 DAYS 155,415.85 4.06% 144,513.70 90 DAYS 14,523.70 TOTAL PREPAYMENT _ 1 77®,303,90 OVER 90 DAYS 1,949,7]2.19 72 ACCOUNTS RECEIVABLE AGING FEBRUARY 2012: E RESIDENTIAL AND COMMERCIAL 2,869,268.20 LESS: SALES DISCOUNT LIABILITY (]59 121 011 GENERAL LEDGER BALANCE 2 61 CURRENT 1,999,135.16 76.0% 30 DAYS 312,434.74 11.95% 60 DAYS 106,290.25 4.06% 90 DAYS 54,676.52 2.09% OVER 90 DAYS 142.609 72 5.45% TOTAL 2,615.146.39 100.00% E Ito) TOM OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REVENUE 2/29/11 SCHEDULE 0 MUNICIPAL SALES: MONTH 37,664.16 MONTH 39,500.55 LAST YEAR 300,370.92 CONSENT! YEAR YTD % SALES OF ELECTRICITY: LAST YEAR CORRIXI YHAR TO DATE - 31.14% TO DATE 111,603.42 CHANGE RESIDENTIAL SALES 2,891,312.32 783,589.18 2,457,598.14 TOTAL MUNICIPAL CONSUMERS 14,403,018.33 122,749 23,088,855.36 1,199.646.28 -5.69% COW AND INDUSTRIAL SALES 3,659.967.96 (89,529.87) 3,168,535.35 - 107.V% 32,161,629.31 ENERGY CONSERVATION - RESIDENTIAL 30,315,141.39 -5.71% PRIVATE STREET LIGHTING 10,696.29 5,978.16 84,535.80 53,695.48 23,699.02 - 36.49% TOTAL PRIVATE CONSUMERS 6.561,876.57 253,014.49 5,732,111.75 152,113.41 56,729,103.33 -0.36% 53,467,693.23 SAN REVENUE -5.75% MUNICIPAL SALES: RESALE 37,664.16 6,029,016.87 39,500.55 59,385,901.00 300,370.92 STREET LIGHTING 46,434.68 39,270.34 -6.28% 371,399.86 255,762.21 - 31.14% MUNICIPAL BUILDINGS 111,603.42 93,479.38 818,044.42 783,589.18 -5.37% TOTAL MUNICIPAL CONSUMERS 150,036.10 122,749 71 1,199.646.28 1.039,331.39 - 13.35% BALES FOR RESALE 37,664.16 6,029,016.87 39,500.55 59,385,901.00 300,370.92 55,852,526.26 281,515.05 -5.95% -6.28% FORFEITED DISCOUNTS SCHOOL 195,669.11 144,654.85 1,156,904.35 1,063,986.57 -8.03% 42,137.55 SUB -TOTAL 6,913,047.94 6,029,016.87 59,385,901.00 55,852,526.26 -5.95% FORFEITED DISCOUNTS 03,708.41 70,491.05 697,455.41 636,950.33 -8.68% PURCHASED POMR CAPACITY 42,137.55 (9,856.38) 1.198,798.38 (89,529.87) - 107.V% ENERGY CONSERVATION - RESIDENTIAL 15,086.12 19,118.83 96,919.76 152,117.47 56.95% MEW CONSERVATION - COMMERCIAL 23,699.02 31,904.36 253,014.49 152,113.41 -0.36% SAN REVENUE 56,314.44 51,893.94 350,069.55 471,296.56 34.32% NYPA CREDIT (92,678.30) (62,465.74) (520,068.72) (460,280.28) . 11.50% TOTAL REVENUE -7.56% 7.041.505.16 6.130.101.93 fi1.462.891.75 56.815.19,3.06 m M) TOM OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARIPOUNT SCHEDULE OF OPERATING REVENUE BY TOM ]/29/12 MONTH TOTAL READING LYNNPIRLD NO.RRAUING WILMINOTON RESIDENTIAL INDUS /NUNS BLDG PUB. ST.LIGHTS PRV.ST.LIGHTS CO -OP RESALE SCHOOL 2,457,598.14 3,36],014.)3 29,270.34 5,978.26 29,500.55 144,654.05 781,345.52 481,978.43 9,]03.5] 1,091.12 29,500.55 51,499.43 324,492.54 44,188.03 3,640.44 108.10 0.00 29,465.06 590,226.05 533,794.83 5,330.26 11891.12 0.00 19,430.24 761,534.03 2,301,053.44 11,096.07 2,887.92 0,00 44,251.32 TOTAL 616.8) 1.354,618.62 401,094.97 1,150.680.50 ],121,8]2.78 THIS YEAR TO DATE RESIDENTIAL INDUS /RUNT BLDG PUB.ST.LIGHTS PRV.ST.LIGHTS CO -OP RESALE SCHOOL 23,088,855.36 31,108,731.57 255,742.21 53,695.48 281,515.05 1,063,986.57 ),245,850.4] 4,302,986.35 82,128.63 10,008.80 281,515.05 363,551.75 3,263,364.45 396,832.65 31,727.50 981.10 0.00 228,803.70 5,391,500.10 4,967,132.02 45,704.91 16,593.38 0.00 139,705.39 7,108,140.26 21,440,780.55 96,101.17 26,112.20 0.00 311,925.73 TOTAL 55 85].5]6.24 1].307.041.05 3.921.709.38 10_,560,635.89 29.063,139.93 LAST YEAR TO DATE RESIDENTIAL INDUS /NUNS BLDG PUB.ST.LIGHT8 PRV.ST.LIOHTS CO -OP RESALE SCHOOL 24,403,018.22 32,989,673.73 371,399.86 84,535.80 300,370.92 1,156,9D4.35 7,694,474.97 4,470,671.34 130,002.57 15,991.46 300,370.92 41],53).58 3,487,943.95 419,905.49 45,283.02 1,590.44 0.00 241,727.15 5,700,057.42 5,125,907.05 61,208.54 26,186.11 0.00 154,136.25 7,599,741.80 22,973,189.85 134,905.73 40,767.79 0.00 348,501.37 TOTAL 59.389.90]688 13 024,048.81 4,396,450.05 11,068.297.37 31 097 106.fi1 PERCENTAGE OF OPERATING INCONS TO TOTAL MONTH TOTAL READING LYNNPIELD NO.READING NILHINGTON RESIDENTIAL INDUS /RUNS BLDG PUB. ST.LIGHTS PRV.ST.LIGHTS CO -OP RESALE SCHOOL 40,76% 55.76% 0.49% 0.10% 0.49% 2.40% 12.96% 7.99% 0.15% 0.01% 0.49% 0.85% 5.38% 0.73% 0.064 0.00% 0.00% 0.49% 9.79% 8.85% 0.09% 0.03% 0.00% 0.32% 12.63% 38.18% 0.18% 0.05% 0.00% 0.73% TOTAL 100.004 ]].1)4 fi.67% 19.09% 51.))4 IRIS YEAR TO DATE RESIDENTIAL INDUS /RUNI BLDG PUB.6T.LIOHTS PRV.ST.LIGHTS CO -OP RESALE SCHOOL 41.34% 55.70% 0.46% 0.10% 0.50% 1.90% 12.97% 7.71% 0.15% 0.02% 0.50% 0.69% 5.84% 0.71% 0.06% 0.00% 0.00% 0.41% 9.65% 8.89% 0.08% 0.03% 0.00% 0.25% 12.88% 38.39% 0.17% 0.05% 0.00% 0.55% TOTAL 100.00} 22.014 7.0]} 18.904 52.04% LAST YEAR TO DATE RESIDENTIAL INDUS /RUNS BLDG PUB. ST. LIGHTS PRV. ST. RESALE CO -OP RESALE SCHOOL 41.22% 55.55% 0.63% 0.14% 0.51\ 1.95% 12.96% 7.53% 0.22% 0.51% 0.51\ 0.69% 5.87% 0.71% 0.08% 0.00% 0.00% 0.41% 9.60% 8.63% 0.10% 0.04% 0.00% 0.26% 12.79% 30.68% 0.33 0.07 0.00 0.59 TOTAL 100.006 31.91% ).0)A 18.63% 5].369 UW TOWN OF READING, ,SSACHUSRTTS ( ) . ACTUAL UNDER BUDGET n It UI NBNICIPAL LIGHT DEPARTNETT BDOORTW REVENUE VARIANCE 1/]9/1] REPORT SCHEDULE P ACTUAL YEAR TO DATE BEDGBT YEAR TO DATE VARIANCE • CHANGE SALES OF ELECTRICITY: RESIDENTIAL 13,710,816.69 14,867,955.00 (1,157,138.31) -7.78% COM AND INDUSTRIAL SALES PRIVATE STREET LIGHTING 16,116,381.18 17,086,084.00 (969,701.0]) -5.68% ROHICIPAL BUILDINGS PUBLIC STREET LIGHTING 154,100.17 343.908.00 (189,807.73) - 55.19% SALES FOR REGAIN 158,680.12 199,100.00 (40,419.88) 40.30% SCHOOL 575.858.12 598.533.00 (23,673,68) -3.79% TOTAL SASE SALES 30,715,837.38 33,095,579.00 (2,379,741.61) -7.19% TOTAL PUEL BALES 25.136.688.66 18,555.504.00 13.418 815.141 - 11.97% TOTAL OPERATING REVENUE 55,85],5]6.14 61,651,OB3.00 (5,798,556.76) -9.41% FORFEITED DISCOUNTS 636,950.33 718,103.00 (91,151.67) - 12.52% PURCRASED POWER CAPACITY (89,529.87) (94,363.00) 4,033.13 .5.12% ENERGY CONSERVATION - RESIDENTIAL 152,117.47 ENERGY CONSERVATION - C HKERCIAL 251,113.41 138,857.00 239,100.00 13,260.47 22,913.41 9.55% 10.00% CAN REVENUE 471,296.56 462,504.00 8,792.56 1.90% NYPA CREDIT (460.180.20) (400,000.00) (60,280.28) 15.07% TOTAL OPERATING REVSHSSS 56,815.193.86 6].715.384.00 15,900.190.141 -9.41% ( ) . ACTUAL UNDER BUDGET n It UI TOM OF READING, MASSACHUSETTS MUNICIPAL LIGHT DXPARYHHMT SCHEDULE OF OPERATING EXPENSES 2/39/12 SCHEDULE E 9 OPERATION EXPENSES: LA ST YEAR 327.08 MONTH 11816.68 LAST YEAR 11816.66 CURRENT YEAR YTD 4 98,418.68 URNORTH CREMPP YEAR TO DATE 111,514.66 TO DATE 195{6179 , CHAN08 PURCHASED POWER BASE E %P,NSB 2.363.101 35 1.911.25] 89 898,9)8.09 1,158,393.06 28.85% 16,095.15 10,332.03 18.651.819 58 _ 1fi,855,504 1J -9.63\ OPERATION SUPER AND ERGIN -TRANS 0.00 1,575.16 1,309,140.19 33,762.59 - 97.50% (0.90) 87,674.29 OPERATION SUP AND ENGINEERING EXP )5,414.61 0.00 0.00 0.00 0.00% STATION CUP LABOR AND RISC 395,156.37 3),]33.46 317,469.70 305 ,648.66 - 12.07% 317,486.30 40.640.13 13.69% 6,404.99 LINE R26C LABOR AEG EXPENSE 9,096.48 8,359.52 72,211.77 ]5,1]3.95 4.10% STATION LARGE AND EXPENSE 65,495.)) 53,108.37 63,396.95 - 45.91% 421,687.89 278,177.50 453,338.13 169.699 ].94% 3.918088 LIGHTING EEP8x86 36,500.56 71 33.860.43 304,]18.10 ]16,]33.88 3.93% METER HETEA 8,839.64 5,949.11 59,179.90 75,030.61 31.61% SPITE pIEADING DISTRIBUTION RXPBN88 27,747.19 35,71).99 15,095.89 210,838.66 165,411.84 - 34.61% LAS METER READING LABOR c EXPENSE 5.)80.35 36,532.33 330,005.81 131,444.53 0.65% ACCT c COIL LABOR A EXPENSE 101,)43.32 7,016.91 50,06].36 60,870.98 37.59% ACCOUNTS 110,819.86 858,644.7) 921,609.64 >.4fiq ENERGY ENERGY AUDIT 15,000.00 16,000.00 110,000.00 138,000.00 6.6)% ADMIN A SALARIES SALARZE9 30.660.]9 31,736.69 258,336.71 394,218.82 13.89% UPH OUTSID SUPPLIES 4 EXPENSE 53,649.41 19,699.82 5],3]1.00 464,706.0) 494,447.65 6.40% OUTSIDE 88RYICXS 21,78).31 178,367.11 148,428.41 - 16.78% PROPERTY INSURANCE 29,648.65 30,183.84 145,258.19 253,840.84 74.75% INJURIES AND DAMAGES 31,705.39 32,379.12 247,772.10 250,946.96 1.28% EMPLOYERS PENSIONS E BENEFITS 3,533.47 38,812.95 2,883.11 29,109.96 10,809.34 - 61.55% RENT EXPENSE a%P8N88 23,613.18 195,495.15 1,063,)51.61 8)],693.57 - 17.46% RENT EXPENSE 34,381.85 ),630.9> 116,348.81 128,591.35 10.52% ENERGY CONSERVATION 107,952.30 28,543.16 136,260.19 , . 1334)488 -3.81% 45,986.94 ]84,185.00 396,208.79 3.13% TOTAL OPERATION EXPENSES MAINTENANCE EXPENSES: MAINT OF TRANSMISSION PLANT MAINT OF STRUCI AND EQUIPMT MAINT OF LINES - ON MAINT OF LINES - 00 PRINT OF LINE TRANSFORMERS �• MAINT OF ST LT 6 SIG SYSTEM MINT OF GARAGE AND STOCKROOM MAINT OF METERS MAINS OF GEN PLANT TOTAL MAINTENANCE EXPENSES DEPRECIATION EXpEi9E PURCHASED POWER PVBL EXPENSE VOLUNTARY PAYMENTS TO TOWNS TOTAL OPERATING EXPENSES 32,351.90 327.08 11816.68 11816.66 0.001 98,418.68 7,423.39 111,514.66 195{6179 , . )5.30% 91069.38 88,2)8.85 898,9)8.09 1,158,393.06 28.85% 16,095.15 10,332.03 93,147.83 125,613.39 36.32% 1,575.16 1,309,140.19 33,762.59 - 97.50% (0.90) 87,674.29 (57.81) 18,933.88 (118.70) (408.33) 243.06% 3,671.71 6,543.46 395,156.37 317,469.70 - 12.07% 40.640.13 6,404.99 11,265.44 56,151.47 398.44% 98,188.03 53,108.37 - 45.91% 278,177.50 169.699 03 3.918088 51 1.9)0.3)0 71 - 32.181 287,729.05 296,027.47 2,301,832.40 2,368,219.76 2.88% 3,983,759.61 2,879,936.80 27,634,995.12 25,627,704.49 -7,26% 110,000.00 113,000.00 875.885.00 900,186.00 2.77% 6.636.51 >.42 616].546.01 �31 53.138.6]5.83 -7.05% PY 32 total includes SAW soil r mediation azpanaee totalling $0.00 Total costa to data for antito project is $2,482,915.80. liil H SAINT OF TRANSMISSION PLANT 1,816.66 TOM OF READING, MASSACHUSETTS 2,000.00 (183.34) -9.17% SAINT O8 STRUCT AND EQUIPMENT MUNICIPAL LIGHT DEPARTMENT 71,533.00 133,931.79 173.25% BUDGETED OPERATING EXPENSE VARIANCE REPORT 926,447.00 331,845.06 V 3/39/12 135,613.39 141,533.00 (16,919.61) - 11.89% SAINT OF LINE TRANSFORMERS • • 31,763.59 134,406.00 SCHEDULE D 45.62% SAINT OF BY IT R SIG SYSTEM (408.33) ACTUAL 6,361.00 BUDGET (6,769.32) - 106.41% SAINT OF GARAGE AND STOCEROOM 347,469.70 OPERATION EXPENSES: YEAR TO DATE YEAR TO DATE VARIANCE • CHANGE - 18.56% PURCHASED PONBR BASE EXPENSE 16,855,504.4] 56,151.47 18.083.333.00 56,939.00 (1,327,727.57) (787.53) -6.79% -1.38% OPERATION SUPER AND RNGIN -TRANS 0.00 0.00 0.00 0.00% TOTAL MAINTENANCE EXPENSES OPERATION SUP AND ENGINEERING EXP 347,486.20 1.851.816.00 287,831.00 118.454.71 59,655.30 6.40% 20.73% STATION SUP LABOR AND MISC 75,173.95 DEPRECIATION EXPENSE 40,044.00 35,139.95 87.73% -1.32% LINE MISC LABOR AND EXPENSE 453,338.13 35,627,704.49 467,350.00 37,355,705.00 (14,011.87) (1,720,000.51) -3.00% -6.33% STATION LABOR AND EXPENSE 316,713.88 291,630.00 35,083.88 6.60% TOTAL OPERATING EXPENSES STREET LIGMfING EXPENSE 78,030.63 56,427.00 31,603.63 -5.48% 38.29% 56.578.742.00 (3.100.066.181 METER EXPENSE 165,421.84 100,054.00 65,367.84 • ( ) . ACTUAL ORDER BUDGET 65.33% MISC DISTRIBUTION EXPENSE 321,444.58 330,193.00 (8,747.42) rwdiation expanses -3.80% "TER READING LABOR c EXPENSE 60,070.98 49,932.00 project is $2,482,825.80. 10,938.98 21.91% ACCT A COLL LABOR c EXPENSE 933.609.64 940,972.00 (18,282.36) -1.94% UNCOLLBCTIBLE ACCOUNTS 128,000.00 128,000.00 0.00 0.00% ENERGY AUDIT EXPENSE 394,318.83 274,956.00 19.262.82 7.01% ADMIN A Om SALARIES 494,447.65 486,775.00 7.673.65 1.58% OFFICE SUPPLIES 6 EXPENSE 148,438.41 177.213.00 (38,784.59) - 16.24% OUTSIDE SERVICES 253,840.84 338,880.00 (85,039.16) 45.09% PROPERTY INSURANCE 250,946.96 310,016.00 (59,069.04) - 19.05% INJURIES AND DAMAGES 10,809.34 37,349.00 (36,539.66) - 71.06% SE LOYSES PENSIONS 4 BENEFITS 877.693.57 1,034,691.00 (156,997.43) - 15.17% MISC GENERAL EXPENSE 128,591.35 154,502.00 (25.910.65) - 16.77% RENT EXPENSE 132,434.80 141,336.00 (8,901.13) -6.30% ENERGY CONSERVATION 396,208.79 435,839.00 (39,630.21) -9.09% TOTAL OPERATION EXPENSES 5.756.790.4) 5.983.989.00 (227,198.57) -3.80% H SAINT OF TRANSMISSION PLANT 1,816.66 2,000.00 (183.34) -9.17% SAINT O8 STRUCT AND EQUIPMENT 195,464.79 71,533.00 133,931.79 173.25% SAINT O9 LINES - ON 1,158,393.06 926,447.00 331,845.06 35.03% SAINT OF LINES - US 135,613.39 141,533.00 (16,919.61) - 11.89% SAINT OF LINE TRANSFORMERS • • 31,763.59 134,406.00 1101,643.41) 45.62% SAINT OF BY IT R SIG SYSTEM (408.33) 6,361.00 (6,769.32) - 106.41% SAINT OF GARAGE AND STOCEROOM 347,469.70 436,653.00 (79,183.30) - 18.56% SAINT OF METERS 56,151.47 56,939.00 (787.53) -1.38% SAINT OF GEN PLANT 53,108.37 84,944.00 (31,835.63) - 39.48% TOTAL MAINTENANCE EXPENSES 1.970.2]0.71 1.851.816.00 118.454.71 6.40% DEPRECIATION EXPENSE 2,360,319.76 2,400,000.00 (31,780.34) -1.32% PURCHASED PONBR FUEL EXPENSE 35,627,704.49 37,355,705.00 (1,720,000.51) -6.33% VOLUNTARY PAYMENTS TO TONNE 900,106.00 904,000.00 (3,814.00) -0.42% TOTAL OPERATING EXPENSES -5.48% 56.578.742.00 (3.100.066.181 53.478,675.63 • ( ) . ACTUAL ORDER BUDGET •• PY 13 total includes GAN sail rwdiation expanses totalling $0.00 Total coats to date for entire project is $2,482,825.80. II3q TOM OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED OPERATING EXPENSE VARIANCE REPORT 1/]9/11 ml TOTAL MAINTENANCE EXPENSES DEPRECIATION EXPENSE PURCHASED POWER FUEL EXPENSE VOLUNTARY PAYMENTS TO TOWNS TOTAL OPERATING EXPENSES 2.817,401.00 RESPONSIBLE 1,970.370.71 847.13D.29 455,814.00 REMAINING 33.61% RP 3,600,000.00 JP 39,768,817.00 1,368,119.76 25,627,704.49 SENIOR 2012 ACTUAL BUDGET REMAINING OPERATION EXPENSES: MANAGER ANNUAL BUDGET YEAR TO DATE BALANCE BUDGET % PURCHASED POWER BASE EXPENSE JP 2].40].177.00 16.855.504.43 10.546.672.57 38.49% OPERATION SUPER AND ENGIN -TRANS MS 0.00 0.00 0.00 0.00% OPERATION SUP AND ENGINEERING SAP BE 438,974.00 347,486.10 91,487.80 20.84% STATION SUP LABOR AND MISC ME 62,909.00 75,173.95 (12,264.95) - 19.50% LINE MISC LABOR AND EXPENSE RE 692,484.00 453,338.13 239,145.87 34.53% STATION LABOR AND EXPENSE RS 441,924.00 316,113.88 135,]10.1] 28.33% STREET LIGHTING EXPENSE MS 85,338.00 78,030.62 7,307.38 8.56% METER EXPENSE RS 153,130.00 165,421.84 (13,291.84) -8.74% MISC DISTRIBUTION EXPENSE JD 352,508.00 321,444.58 131,063.43 37.18% M IER READING LABOR R EXPENSE XS 76,220.00 60,870.98 15,349.02 20.14% ACCT R COLL LABOR 6 EXPENSE RP 1,427,255.00 922,689.94 504,565.36 35.35% UNCOLLECTIBLS ACCOUNTS AP 192,000.00 128,000.00 64,000.00 33.33% ENERGY AUDIT EXPENSE JP 414,098.00 294,218.82 119,879.18 28.95% ADMIN R GEN SALARIES VC 745,939.00 494,447.65 251,491.35 33.71% OFFICE SUPPLIES 6 EXPENSE VC 265,700.00 148,428.41 117,271.59 44.14% OUTSIDE SERVICES VC 454,250.00 253,840.84 200,409.26 44.11% PROPERTY INSURANCE OD 465,000.OD 250,946.96 214,053.04 46.03% INJURIES AND DAMAGES JD 55,859.00 10,809.34 45,049.66 00.65% EMPLOYEES PENSIONS 6 BENEFITS JD 1,441,637.OD 877,693.57 563,943.43 39.12% MISC GENERAL EXPENSE VC 203,091.OD 118,591.35 74,499.65 36.68% RENT EXPENSE JD 212,000.OD 132,434.00 79,565.12 37.53% ENERGY CONSERVATION Jp 643,789.00 396,200.79 247,590.31 38.46% TOTAL OPERATION EXPENSES 8.823.105.00 5.756,790.43 3.066.314.57 34.75% MAINTENANCE EXPENSES: 0 MAINT OF TRANSMISSION PLANT ES 3,000.00 1,816.66 1,183.34 39.44% SAINT OF STRUM AND EQUIPMT MB 107,072.00 195,464.79 (88,392.79) - 82.55% MAINT OF LINES - ON MS 1,419,953.00 1.158,292.06 161,660.94 18.43% MAINT OF LIN88 - GO RS 214,037.00 125,613.39 88,423.61 41.31% MAIM OF LINE TRANSFORMERS •• a$ 188,500.00 32,762.59 155,737.41 82.62% MAINT OF ST IT 9 SIG SYSTEM JD 9,636.00 (408.32) 10,044.32 104.24% MAIM OF DAMAGE AND STOCKROOM JD 662,139.00 347,469.70 314,669.30 47.52% MAINT OF METERS M8 85,444.00 56,151.47 29,]9].53 34.28% MAINT OF GEN PLANT RP 127,620.00 53,108.37 74,511.63 50.39% TOTAL MAINTENANCE EXPENSES DEPRECIATION EXPENSE PURCHASED POWER FUEL EXPENSE VOLUNTARY PAYMENTS TO TOWNS TOTAL OPERATING EXPENSES 2.817,401.00 11356,000.00 1,970.370.71 847.13D.29 455,814.00 30.07% 33.61% RP 3,600,000.00 JP 39,768,817.00 1,368,119.76 25,627,704.49 1,231,780.24 14,141,112.51 34.31% 35.56% RP 11356,000.00 900,186.00 455,814.00 33.61% 83.767.$00.00 53,478,675.8] 30.]68.8]4.18 36.16% •• FY 12 total Includes DAN soil remediation expenses totalling $0.00 Total costa to date for entire project is $2,482,825.80. 11 um i TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT PRGPBSSIGNAL SERVICES 02/29/2012 PROPB98IORA1 SERVICES BY PRO.I6CP 1 MD ANO PENSION TRUST AUDIT PRPE I FISSION ACTUARIAL EVALUATION 3 LEGAL- PIRC /I30 ISSUES 6 LEGAL- POWER SUPPLY ISSUES 5 PROFESSIONAL SERVICES 6 ERIC CO30•LIANCE 7 WAD CAPACITY STUDY /018 8 LEGAL SERVICES- GENERAL 9 LEGAL SRRVIC68- GINlGAL SO LEGAL SERVICES- NEGOTIATIONS 11 LEGAL GENERAL 12 SURVEY RIGHT OP NAY 13 RIVIRONI®PPAL 16 STATION 1 STRUCTURAL PEASAEILITY 15 DEMLITION OF CONTROL CENTER 16 INSURANCE CONSULTANT 17 LEGAL TOTAL PROFESSIONAL SERVICES BY VINOOR BONAIRE INSURANCE RORIE AND BOURSE UTILITY SERVICES INC. 1¢LAN80N N8AT8 L COMPANY DUNCAN AND ALLEN CROATS NAIL AND STEWART PROFESSIONAL NNVIRON3®1TAL SERVICES CON CMRC COVINO EWIRONID9PPA1 ASSOCIATION TOTAL DEPARTMENT ACTUAL BUDGET VARIANCE ACCOUNTING 36,990.00 31,250.00 21690.00 ACCOUNTING 0.00 0.00 0.00 ENERGY SERVICE 0.00 12,000.00 (12,000.00) ENERGY SERVICE 39,590.55 30,000.00 9,590.55 ENERGY SERVICE 7,686.32 16,000.00 (8,515.61) 16 O 12,890.00 11,700.00 1,190.00 ENGINEERING 9,280.00 11,250.00 (1,970.00) GH 99,139.66 33,336.00 65,803.66 NR 27,865.90 29,000.00 (136.10) NR 10,173.91 0.00 10,173.91 BLDG. SAINT. 2,312.50 1,000.00 1,312.50 BLDG. MAMT 0.00 3,336.00 (3,336.00) B.G. RAINY. 0.00 3,336.00 (3,336.00) SLOG. MINT. 0.00 50,000.00 (50,000.00) BLDG. MINT. 3,705.69 100,000.00 (96,296.31) GEN. BENEFIT 6,658.33 3,336.00 3,122.33 GEN. SMURFIT 0.00 3 336.00 11 336.00) 353 890.86 318.180.00 85,03 .161 113) 6,061.66 116,196.58 16,301.67 66,153.62 6,616.99 38,039.61 2,260.00 9,280.00 6,169.32 2,523.19 253.860.84 RNLD BUDGET VARIANCE REPORT FOR PERIOD ENDING FEBRUARY 29, 2012 DIVISION ENGINEERING AND OPERATIONS ENERGY SERVICES GENERAL MANAGER FACILITY MANAGER BUSINESS DIVISION SUB -TOTAL PURCHASED POWER - BASS PURCHASED POWER - FUEL TOTAL ACTUAL BUDGET VARIANCE 3,222,651 2,786,745 435,906 737,572 769,131 (31,559) 556,203 483,863 72,340 1,901,291 2,412,377 (511,086) 6,054,116 6,171,698 (117,581) 12,471,832 12r623,813 (151,980) CHANGE 15.644 -4.10% 14.958 - 21.198 -1.918 -1.208 16,855,504 18,083,232 (1,227,728) -6.798 25,627,704 27,355,705 (1,728,001) -6.328 54,955,041 58.062.750 (3 107 708) -5.358 1 N R)dD DEFERRED FUEL CASH RESERVE AMALYBIH 03/39/1] C GROSS MONTHLY TOTAL DATE CRAROEE REVENUES MA CREDIT DEFERRED DEFERRED Jun -11 3,055,234.7E Ju1-11 4,131,396.83 4,049,745.45 (79,163.65) (160,815.03) 2,894,409.75 Aug -11 3,795,607.97 3,924,541.80 (52,338.74) 76,605.09 3,971,014.64 e.p -LI 3,914,869.40 3,166,562.64 (56,669.90) 192,823.34 3,163,838.18 Oct -11 3,955,398.39 2,852,952.53 (45,133.69) (147,579.55) 3,016,358.63 Nov -11 2,643,246.46 2,544,526.70 (47,451.31) (146,171.07) 2,870,067.56 D.c -11 2,968,917.38 2,899,823.54 (63,455.95) (142,550.79) 3,727,536.77 Jan-12 3,338,331.16 3,114,395.49 (51,411.30) (275,346.99) 2,452,189.78 Feb -12 2,879,936.88 2,594,141.71 (62,465.74) (348,260.91) 2,103,928.87 C RMLD STAFFING REPORT FOR FISCAL YEAR ENDING JUNE, 2012 ACTUAL 12 BUD ML AUG SEP OCT NOV DEC JAN FEB TOTAL 11 11 11 11 11 11 12 12 GENERAL MANAGER GENERAL MANAGER 2 2 2 2 2 2 2 2 2 HUMAN RESOURCES 1 1 1 1 1 1 1 1 1 COMMUNITY RELATIONS 1 1 1 1 1 1 1 1 1 TOTAL 4 4 4 4 4 4 4 4 4 BDSTNRSS ACCOUNTING 2.00 1.50 1.50 1.50 2.00 2.00 2.00 2.00 2.00 CUSTOMER SERVICE + 7.75 8.75 8.75 8.75 8.75 8.75 8.75 8.75 8.75 MONT INFORMATION SYS + 6.25 5.25 5.25 5.25 5.25 5.25 5.25 5.25 5.25 MISCELLANEOUS 1 1 1 1 1 1 1 1 1 TOTAL 17.00 16.50 16.50 16.50 17.00 17.00 17.00 17.00 17.00 ENGINEERING F 0P8RATS0N5 2 2 2 2 2 2 2 2 2 AGN ERO ENGINEERING 5 5 5 5 5 5 5 5 LINE 21 20 20 20 20 20 20 21 METER 4 4 4 4 4 4 4 4 STATION 8 6 8 8 a 8 8 7 7 TOTAL 40 39 39 39 39 39 39 39 39 PROJECT BUILDING 2 2 2 2 2 2 2 2 2 GENERAL BENEFITS 2 2 2 2 2 2 2 2 2 TRANSPORTATION 0 0 0 0 0 0 0 0 0 MATERIALS MGNT 4 4 4 4 4 4 4 4 4 TOTAL 8 8 8 8 a 8 8 8 8 ENERGY SERVICES ENERGY SERVICES + 5.5 5.5 5.5 5.5 5.5 5.5 5.5 4.5 4.5 TOTAL 5.5 5.5 5.5 5.5 5.5 5.5 5.5 4.5 4.5 RMLD TOTAL 74.5 73 73 73 73.5 73.5 73.5 72.5 72.5 CONTRACTORS UG LINE 2 2 2 2 2 2 2 2 2 TOTAL 2 2 2 2 2 2 2 2 2 GRAND TOTAL 76.5 75 75 75 75.5 75.5 75.5 74.5 74.5 • part time employee •R part time employee and a coop student •" part time employee and a temp R,.ding MViripel Liabs..rr.m,o.n[ RMLD � [ .... . 230 Ash Suem P.O. Box MA P0. x 13041867 -0250 Tel: (791)9/41340 Fix: (781) 942-2409 Web: www.mad.com March 14, 2012 ATTACHMENTI Town of Reading Municipal Light Board Subject Replacement of Rooftop Air Conditioning Units On February 7, 2012 a bid invitation was placed as a legal notice in the Reading Chronicle requesting proposals for Replacement of Rooftop Air Conditioning Units for the Reading Municipal Light Department. An invitation to bid was sent to the following: Aaron Clayton Commercial All Seasons Cooling & Heating Alpha Mechanical Services, HVAC & Refrigeration Inc Atlantic Mechanical Berry & Loud Company, Inc. Breen & Sullivan Mechanical Contractors Services, Inc. Brooks & Brooks HVAC CAM HVAC Carrier Air Conditioning ® Service Colonial HVAC Cranney Companies Essex County Craftsmen, Inc. Hall Sheet Metal Works, Inc. Huntington Controls lake Industries Mechanical Management, Inc. Monahan Technologies, Inc. P.J. Dionne Co. Roger: %. Tremblay Contractors, Inc. *'Uthcrn Air, Inc. franc Company Controlled System HVAC, Inc. Emcore Service N.E. Commaire /Balco Falite Bros., Inc. Healthy Air Solutions James Devaney Fuel Company Limbach Company Mercury Mechanical Systems, Inc. Nexgen Mechanical, Inc. R.H. Young Ileating and Air Conditioning, Inc. Snowden Mechanical 54rbbins Duffy 201'_ -16 Replacement of Rooftop Air Conditioning Units.doe Cooling Unlimited, Inc. Enoch C. Shaw George T. Wilkinson, Inc. Honeywell Business Solutions Johnson Controls Lohrman HVAC Merrimack Valley Corp. NMA Construction Renaud HVAC & Controls, Inc. Soracco Plumbing & 1leating I'utal - Temperature Control, Inc. RMLD R••.di, `Muni i..I 1,& I1V:v' mum M)A,h Slr i. YO, Ron 1%X Reading. MA III s6z 02.14) Bids were received from CAM HVAC, Cranney Companies, Essex County Craftsmen, Inc., Faille Bros., Inc., Hall Sheet Metal Work', Inc., Healthy Au Solutions, Huntington Controls, Mercury Mechanical Systems, Inc., Monahan Technologies, Inc., and P.J. Dionne Co. Fhe bids were publicly opened and read aloud at 11:00 a.m. March 7, 2012 in the Town of Reading Municipal Light Department's General Manager's Conference Room, 230 Ash Street, Reading, Massachusetts. The bids were reviewed, analyzed and evaluated by the General Manager and the staff. Move that bid 2012 -36 for Replacement of Rooftop Air Conditioning Units be awarded to: Healthy Air Solutions for $19,600.00 Item 1 Healthy Air Solutions as the lowest qualified and responsive bidder on the recommendation of the General Manager. The FY2012 Capital Budget amount for this item is $30,000.0(), • 'L cent F. Cam n, Jr. i J6seph J. Donahoe i Cra1g wen '_012 -16 Replacement of Roufh)p Air Conditioning Units.doe $19,600.00 • 0 \ J 0 Z s sl o 0 0 O 0 0 0 M o ° o 0 c 0 O O o 0 m en � o ° o 0 c 0 a N � N C 4 C � n c v E a X N x a m E udi m E A E Y � RMLD, Reading Municipal Light Department [Fa .te[! r !e FU[ 4EX[[![IUN[ 270 Ash Street © Rea Box ISO Reading, MA 01867-0250 Tel: (791)944 -1710 Pas: (781) 942 -2409 Web: wwse.rmld cam March 14, 2012 Town of Reading Municipal Light Board Subject: Landscape Service On February 7, 2012 a bid invitation was placed as a legal notice in the Reading Chronicle requesting proposals for Landscape Service for the Reading Municipal Light Department An invitation to bid was emailed to the following: Consider It Done Donlon - Draper, Inc. Eagle Landscaping Earle, Kevin EZ Landscaping GTA Landscaping Hurst Landscaping Linehan Landscaping & Fuel Lubelczyk, Edward Macs Landscaping Maloney, Pat McCarthy, Paul MFB, Inc. NECC Corp. Rodriques, Orlando RMK Sawyer Strong Landscaping TM Landscaping Bids were received from Eagle Landscaping, Inc., James M. Linehan DBA David Linehan & Sons, and TM Landscaping, LLC. The bids were publicly opened and read aloud at 11.00 a.m. March 7, 2012 in the Town of Reading Municipal Light Department's General Manager's Conference Room, 230 Ash Street, Reading, Massachusetts, fhe bids were reviewed, analyzed and evaluated by the General Manager and the staff. t� u 2012-11 I ,Fnduape Fn'n a.Jor RC Jp brcunpul Light k pJm RM LD .I.. 2Y1 A.h Sta. 110 Rus VI Re:Winp. SI:\ o I VnNrl511 Move that bid 2012 -33 for Landscape Service be awarded to: Eagle Landscaping, Inc. for $66,M.00 Item 1 Eagle Landscaping, Inc. $66,540.00 as the lowest qualified and responsive bidder on the recommendation of the General Manager. (This is a three -year contract.) The FY2012 Operating Budget amount for this item is $38,000.00 1 cent F. car rion, Jr. /1 J. Donaho�e� \ Crar}t Owen '_012 -i3 I enJscape Fn icadur • • • > } f \) z » « } ai / - E i \ � � 2 m / k - 2 ° a \/ 7 ~ �� I \ \ 0 ) } f � 2� } / - �� 0 ) } f � u E ,. | „ | �•• all I'-, |�� !| � !| | � |`, �| ■ | | || | | | § || its \ ,! sit �| ■ |,| Answer to Payables 2/27/12 Page 1 of 1 Answer to Payables 2/27/12 Vincent Cameron ` 1 SaM: Wednesday, February 29, 2012 2:11 PM TO: RMLD Board Members Group Cc: Bob Fournier; Steve Kaaanlian; leanne Fob Categories: Red Category Snyder 1. Bay State Envelope - Did we get the envelopes we wanted + did they take back the ones with the note? (The PO from 2008.) Yes. The order was straightened out. 2. ERC - What are pop up wipes + what for? These are cleansing wipes. The are used by employees to clean their hands after working on equipment that is greasy or dirty. M https: / /t)wa.rmid.com/owa/' ?ac= Item& t = IPM. Notc& id= RgAAAACOkZl rlkKLQ6uBL6Pyd... 2/29/2012 Payroll Questions - February 24, 2012 Payroll Questions - February 24, 2012 Vincent Cameron Sent: Wednesday, February 29, 2012 2:18 PM To: RMLD Board Members Group 4: Bob Fournier; Steve Kazanjim; Jeanne Fob Cateporleen Red Category Hahn 1. Finne - Why a minimum with no OT? Page I of I A minimum Is an overtime call -in that guarantees three hours pay. The minimum line represents five minimum call -ins that Mr. Finnie worked during this pay period. The fifteen hours were paid at the overtime rate. 2. Schibilio - Which CAB meeting did he attend? The meeting was on 2/16/2012. We have an Electrical /Meth. Technician on duty when there is a meeting in the building, except for a RMLD Board meeting or a meeting held in the cafeteria. https: / /owa. rmld.com/owa/7ac= Item &t =IPM. Note& id =RgA AA ACOkZ I rl kK LQ6u B L6Pyd... 2/29/2012 13 a Account Payable Questions - March 2, 2012 Account Payable Questions - March 2, 2012 Vincent Cameron sent. Tuesday, March 06, 2012 9:23 AM To: RMLD Board Members Group CC: Bob Fournier; Steve Kazanlien; Wendy Marklewirz; Jeanne Fob Cat aporlq: Red Category Snyder 1. Fischbach & Moore - what happened on 1/29 to result in double time billing? Page I of I An underground cable faulted in a manhole on West Street on Sunday, 1/29/12, near the Reading/Wilmington town line. The cable needed to be repaired immediately. Fischbach & Moore was paid the double time rate to do the work. O'Neill t1. Kiley - Employee should be encouraged to submit expenses more expeditiously. Yes, I will remind the employee. P htips: / /owa.nnld.com/owai ?ae= Item &t =IPM. Note& id= RgAAAACOkZl rlkKLQ6uBL6Pyd... 3/6/2012 March 9 Payables Warrant Questions Page I of I March 9 Payables Warrant Questions Vincent Cameron Sant: Friday, March 16, 2012 1:51 PM To: Bob Soh; Gina Snyder; Marsle West; Mary Ellen O'Neill; Phil Padra Cc Bob Fournier; Steve Kazan)lan; Wendy Marklewkz; leanne Fall Cabporla : Red Category Atbchmerds: DDC.PDF (179 KB) Snyder JP Morgan - Please explain accounting on this. RMLD purchased 5082 Mwhs of on -peak power at a price of 561.85 /Mwh which when multiplied equals $314,321.70 plus 3735 Mwhs of off -peak power at a price of 549.20 /Mwhs which when multiplied equals $183,762.00. The sum of the on /off peak is the invoice cost of $498,083.70. 2. Woronoco a Indian River - Woronoco notes say it includes Indian River, but there's a separate wire to Indian River. Please explain. RMLD internal notation which indicates that when Energy Services verifies the amount of energy received from projects with the ISO -NE, the nodal locations for Woronoco and Indian river are totalized. 3. Asplundh - Please indicate locations for these bills + indicate who supervised. Attached are the sheets with the detail of the work. These sheets did not make it to the payables pile but we had them. Blasetti and Greenwood were the supervisors on the crews. 4. Office Depot - Why did RMLD buy 2 cartons of dish detergent. Shouldn't the 53.11 credit be applied to the 53.11 charge? The RMLD buys dish detergent for the cafeteria area. This is the least expensive source. The credit is issued on a separate invoice because what was sent had to be sent back. O'Neill 1. Asplundh - Check should be held until "weekly operation form" is filled out properly. The weekly operation form is filled out and attached. 2. Reading Chronicle - No copy of published ad for RFQ 2012 -28? Also, isn't it preferable to have "r.opic" of bid in ad headline; not just number? We have a copy on file. I had it attached 10 the payable. We usually put the number at the healing and the name and description in the first paregrnph. 3. Rubin ar.d Rudman - In exeart ive session if necessary, what were total le3al s_, to execaa bid? What : -an be done Ln future to Lower s:ch _gists? I '.ai I exc!3in rte :.e ial r;ss rel ar , d '-o the bid in . °..e https: / /owa.rmid.com/owai ?ae= Item &t =1 PM. Note& id= RgAAAACOkZlrlkKLQ6uBL6Pyd... 3/2012012 I'age Answer to Payables March 19, 2012 Vincent Cameron ,y se rR: Tuesday, March 20, 2012 11AII AM To: RMLD Board Members Group cc: Bob Fournier; Steve Kazanjlan; Wendy Markiewia; Jeanne Foci ,d"orin; Red Category AttachmeMa: Green Power MDPU Pres -PLY (114 KB) O'Neill 1. Rubin and Rudman - Please discuss in Executive Session if necessary and why the PP presentation was necessary. The RMLD, along with representatives from Braintree and ENE, used Rubin and Rudman to set up a meeting with the Massachusetts Department of Public Utility commissioners (Berwick, Westbrook, and Cash) to present our systems energy conservation and renewable energy initiatives. I gave the RMLD Board a report on this at the last RMLD Board meeting during the GM Report. Snyder 1. JCM Realty - What is being done on electric use? I spoke to the building owner and will meet with him to discuss the lighting within the building. I(i ^ 2. NGRID - Please explain accounting notes. ,%W NGRID lost a check from RMLD. We resent the check, which they misapplied the check to only one account. We straightened it out in this payment. 3. Reading W /S /SW 230 Ash Street - Both bills have 38.52 storm water? What is the storm water billing based on + is the impervious service serve. (RCN) removed? What is at 571 West Street? That is what we are charged for impervious service charge for the 208 Ash Street lot, which is beside the garage. 571 West Street is the back end of the RMLD's right of way out of the Gaw Substation. We have a service there. 4. Rubin and Rudman - Please provide copy of power point. It is attached. 5. Sterling - What was the error and can the 20,000 sheets be used? Yes, we are using them. A few stock numbers changed, but they can still be used. 6. Wilmington Family Counseling - What is this for? This is the Employee Assistance Program the RMLD provides for its employees. https:; owu.nnld.conn owa;1ae= Item &t =IPM. Note& id - RgAAAAC'OkZlrlkKLQ6uBL6Pyd... 120,2013 0 J C 00 O O r O O C U '0 (U O _O OD o N O 0 0 C ..0 Q o � O C N O O O co c O) O 11) O L 0) .- .� C �+ O Co W N L It O Z O C c� N C U) O E'— f U i m > 0-0 U C b ca U ' O � N O C O J O N 0) U) C O N N U N O C (6 N Y ca a� a N O a-. 12 cn O C m t L O C N C O U O N . . O NO L C O E ca r O N L L N U O T O LO O O Efl i N co co O i Z O O EJ4 i F— Z 0 11 .1 - } Q £ _ ; ( 76 / i 2 m § q (n > j c ] \ _> k E e 2 ) - CD 4-0 > } k \ 5� \ \ \ j CL a) g z \ i 0 ; 4 e 0 k 0 J 0. / \ 5 _ \ \ \ § ® \g$- \ 2 0 �§ \ \ � / \� 0 \kk \ /r °°/ 2 - eLo ; § o w = \) $ n ] 2 {�\ 2 (/ « \ ] \ C } § - \ } 2 °! E ° 2 j » ' / § § e / ! & 2 /- / } / o Of § : s ee,,& /[ §=,aR6» § §\ //} C)L)of ,, Of W, � a w `Ir C V O O N N O O •� o O � C N L � rn 3 O d a c V C O n CL m L � c) J ° 0 LL > O T DI a) a3 > O L co C E CL r N U O co LO O O p p (0 N NO N E t° E N n O L c > 0 r a) In `� j O O Ep O cA O .-+ N O O �. C N N 7 .L.+ w C U cu C N o O C O O E N N U 'a C E O E a) m o cn w w � . c CU M C z64 cu O DI C O O = O (D O E m> LO c9 C > O c0 O CD no a—�ic a wN en Na > o m CU a � o E c c O C N 0 Z N O a =mom o — r L 0 >. ESE cc o > 6M9 EA N U Q (n O. Q' _ N .n/ a w �Ir 0 U r c 4) L J 0 0 w c a s m m N 7 N O) C O N (C N U O N C 3 0 0 0 0 � m m U � ?Ihl � t m 3 c T C U C_ � O f0 mm c U . 00 O V I-- D N vi c 4O > E N L LL J > C L Q Q a) U i U 4O X 0 3 m o O "� .� �_' >, _C U c 0) E _U) c o o c � < � O Q.cn Q) L �-- X C: c Q a •