Loading...
HomeMy WebLinkAbout2012-06-27 RMLD Board of Commissioners Packet• rici tz ct bio 64w H u a Q d 'L .O9 O l j ~ T < Y y Y yr e 3 u W � J mJ a a� I Q CO'k. Q � :54� x w E2 z 0 i 0 t. r z 0 a "r n x 3 d 'L .O9 O l j ~ T < Y y Y yr e 3 u W � J mJ a a� I Q CO'k. Q � :54� x w E2 z 0 rizi v� b �^l 5W r ^^ v, . O 0 V/ ri V, P64 `n N 3 N O N O ti b N C Q O C a c G C c E 0 r z 0 a 0 rizi v� b �^l 5W r ^^ v, . O 0 V/ ri V, P64 `n N 3 N O N O ti b N C Q O C a c G C c E 0 • J d_ .O a m 1 7 V d S w C W r W m .22t222§ m `a d m m ry d a n¢nnnnS.nn S 0 E 0 0 0 0 0 0 0 2 UUUUUUUUU a O m o_ goo, C py�j C m m J p , 0 0 0 0 E U a E 0 $$o o$$oo o$ U Fk 0 W d c 9 U N 0 09900 0 0 a 0 � 2 = a m > m rn� E o ¢ 7 Sc m dO E d a m x E A_ Ma rn� maco C C y C m mmu]Ur wa: ro n W a 0 `o_ 0 0 0 55 m1U 9 w 9 2 2 2 y' 2 C m a t C C C mC C C O x 0 0 0 0 0 0 U U o U U U U U m a m a a m m m a m v m ry d m v m d a o. EEEE E o.n a E E E E E E E E E E 2 UUUUUUUUU a m .- 0 00000 �a000���a E Soo °° oo Ea 0 U a E 890088000 0 oo 0 o 0 U aft a 000000ao° Q N� Y�h r NOO(O �p 000 00� N N E A oaa a m �Z3 awE E E `-°m EE -zc 0 ,g 0 2 0 p N U U U Q ttl m 0 q O d5 �m t m d E.9 E E E d Q C Oy N N q -.5 E 0 H ¢r�rrrrUU U ATTACHMENT V N .O L a a� v L 0) Q L E L O U) C m LL r A, m co I, OLo V co N suo!II!W ul s.ielloo � U 7 N V 2 a a 1m mm T T t cO C Q N Y R 0 • .dy V d �O L a 01 a L CL 3 R C3 d t i+ 01 C C O v 'i ■ .r M N N N N T O O 0 m H _ o fp F d d CL IL lT N 01 V7 M r N M r N LL O N r ja ______ __ _________________ ______ _____ -- __._________ -- _. N ' y M 7 Il N > as Ot M W O (0 7 7 D � C p O O O N 0 0 O K M0 ID oom 0O � 0 o CO — o t- M 0 0 V — 66 0 O N 0 0 0 0 0 0 0 0 0 0 0 0 Q O O > p (i O 1�a N 1- CO co aD m E O U 7 O O O O N O O N 0 7 O 0000 co a V co M O M M O O O E 0 M M V N I- � N � M O o N O O O aN 'O O O N O O O O 0 0 0 0 O O O O as O O N m N N V N N N N LL E E a) E E E E >. E >. E E rn £ m m — p, N N LL M N 41 co lL Co co lL M co J lL L N �° J� J D U N J U NJCC V N w m m � c U o -j o° o o o° 2 aa) U LL 2LL a°1i (iLLQLL am) ULL2LL a) F L) (L cc LL r M N N N N T O O 0 m H _ o fp F d d CL IL 6/21/2012 5'.14 PM READING MUNICIPAL LIGHT DEPARTMENT FY 12 CAPITAL BUDGET VARIANCE REPORT FOR PERIOD ENDING MAY 31, 2012 ALL 6 PROJECT DESCRIPTION ANNUAL (1,175,362) ESO Construction - System Protects ' 1 SW9 Reconductonng- BellaMVale Street ' 2 High Capacity Tie 4W18 and 3W8 Franklin Street THRU 5131112 3 Upgrading Old Lynn6eld Ctr URDS W SCADA Projects 242,649 4 RTU Replacement 122,873 Distribution Automation Projects 34,893 5 Reclosums 2,642 6 Capacitor Banks R 7 SCADA Radio Communication System 130,255 128,615 Station Upgrades (Station a4 GAWI 4,881 8 Relay Replacement Project 193,020 9 115kV Disconnect Replacement 76,225 105,052 Now Customer Servics Connecgons ALL 12 Service Installations- Commercialllndusirial Customers 231,386 13 Service Installations- Residential Customers 62,068 14 Routine Construction 34,785 R Various Routine Contraction 52,970 88,565 Total Construction Projects ALL 10,299 Other Projects 62,530 15 GIS 11,098 16 Transformers/Capacitors Annual Purchases 45,197 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 Software and Data Conversion 23 Plotter 27 Hardware Upgrades 28 Software and Licensing OTH Cooling Tower Replacement Total Other Projects TOTAL RMLD CAPITAL PROJECT EXPENDITURES 29 Force AccountlReimbursabla Projects TOTAL FY 12 CAPITAL PROJECT EXPENDITURES completed pro /acts ALL ACTUAL YTD ACTUAL ANNUAL (1,175,362) 157,352 COST COST BUDGET 222.142 TOWN MAY THRU 5131112 AMOUNT VARIANCE W 160,588 242,649 82,061 R 122,873 157,766 34,893 LC 1,632 2,642 579,927 577,285 R 9,155 1,640 130,255 128,615 ALL 4,881 4,881 197,901 193,020 ALL 30,630 76,225 105,052 26,827 ALL 94,435 55,631 231,386 231,386 R 62,068 64,671 99,656 34,785 R 3,232 52,970 88,565 35,615 ALL 10,299 54,710 62,530 7,620 ALL 11,098 160,820 206,017 45,197 ALL 153,404 2,191,744 1,016,382 (1,175,362) 157,352 277,244 2,895,964 3,118,106 222.142 9,750 20,496 50,000 29,504 157,352 198,800 41,48 12,123 57,528 46,360 (11,188) 475,666 970,577 1,740,656 770,079 31,544 36,000 4,456 386,000 386,000 75,000 75,000 20,845 20,845 30,000 9,155 76,690 76,690 18,000 18,000 5,755 68,466 40,000 (26,466) 8,109 38,804 94,435 55,631 18,706 - (18,706) 832,247 1.382,317 2,]91,941 1,09,624 809,492 4,278,281 5,910,047 1,831,766 ALL 809492 4,278,281 5,910,047 1631,766 Reading Municipal Light Department Engineering and Operations Monthly Report May 2012 FY 2012 Capital Plan E &O Construction - System Proiects 1. 5W9 Reconductoring - Ballardvale Street -Wilmington -Complete 2. High Capacity Tie 4W1 8/3W8 Franklin Street - Reading - Complete 3. Upgrading of Old Lynnfield Center URDs - Engineering labor. SCADA Proiects 4. RTU Replacement at Station 4 - Reading - No activity. Distribution Automation MA) Proiects f 5. Reclosers - Engineering labor; built and assembled frames for reclosers; installed disconnect switches; 6. Capacitor Banks - Install and energize new capacitor banks on Lowell Road and Elm Street, North Reading; Main Street, Lynnfield; and Fordham Road, Wilmington; Line Crew, Engineering, and Senior Techs labor 7. SCADA Radio Communication System - No activity. Station Upgrades 8. Relay Replacement Project - Station 4 - Reading - Purchased relays. 9. 115 kV Disconnect Replacement - Station 4 - Reading - Senior Techs and Line Crew labor to install disconnect switches. New Customer Service Connections 12. Service installations - Commercial /Industrial Customers - This item includes new service connections, upgrades, and service replacements for the commercial and industrial customers. This represents the time and materials associated with the replacement of an existing or installation of a new overhead service, the connection of an underground service, etc. This does not include the time and materials associated with pole replacements /installations, transformer replacement/installations, primary or secondary cable replacement/installations etc. This portion of the project comes under routine construction. Notable: 30 Haven Street Condos, Reading, 35 Upton Drive, Wilmington (Solar Project), and 1 Burlington Avenue, Wilmington (Solar Project). 13. Service Installations — Residential Customers — This item includes new or upgraded overhead and underground services, temporary overhead services, and large underground development. . 14. Routine Construction — The drivers of the Routine Construction budget category YTD are listed. This is not an inclusive list of all items within this category. Pole Settin ransfers $295,182 Maintenance Overhead/Underground $769,343 Projects Assigned as Required $426,731 Pole Damage includes knockdowns some reimbursable $41,694 Station Group $2.967 Hazmat/Oil Spills $3,118 Porcelain Cutout Replacement Program $7,642 Lighting Street Li ht Connections $101,114 Storm Trouble $80,356 Underground Subdivisions $57,760 Animal Guam Installation $66,982 Miscellaneous Capital Costs $338,855 TOTAL $2,191,744 *In the month of May three cutouts were charged under this program. Approximately 32 cutouts were installed new or replaced because of damage • making a total of 35 cutouts replaced this month. L] • Reliability Report Two key industry standard metrics have been identified to enable the RMLD to measure and track system reliability. A rolling 12 -month view is being used for the purposes of this report. Customer Average Interruption Duration Index ( CAIDI) — Measures how quickly the RMLD restores power to customers when their power goes out. CAIDI = Total of Customer Interruption Duration for the Month in Minutes/ Total number of customers interrupted. RMLD 12 month system average outage duration — 64.14 minutes RMLD 4 year average outage (2006 -2009) — 50.98 minutes per outage On average, RMLD customers that experience an outage are restored in 64.14 minutes. 180.00 55.09 i en nn a 140.00 c 120.00 d 100.00 7 O 80.00 m E 60.00 0 40.00 U 20.00 0.00 'e, 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 - .40 outages per year RMLD 4 year average outage frequency - .82 The graph below tracks the month -by -month SAIFI performance. e c m v 'u E 0 u C v v v LL r.vv 0.91 0.90 0 0.80 0.70 0.60 0.50 0.50 0.40 1 0.30 .21 0.20 .11 0.10 D.00 RMLD 12 month system average outage frequency .40 RMLD 4 year average outage frequency .82 (2006 -2009) 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 30 months. • • ATTACITNIENT 3 E To: Vincent Cameron From: Energy Services Date: June 20, 2012 Subject: Purchase Power Summary — May, 2012 Energy Services Division (ESD) has completed the Purchase Power Summary for the month of May, 2012. ENERGY The RMLD's total metered load for the month was 57,990,756 kwh, which was relatively flat (0.6% increase), compared to the May, 2011 figures. Table 1 is a breakdown by source of the energy purchases. TABLE 1 % of Amount of Cost of Total Total $ $ as a Resource Energy Energy Energy Costs % (1,M) (S/Mwh) Millstone $3 3,691,155 $6.99 6.35% 525,792 1.23% Seabrook 4,985,534 $8.12 8.58% 540,504 1.93% Stonybrook Intermediate 693,742 $54.76 1.19% $37,989 1.81% JP Morgan 5,193,000 $55.52 8.94% $288,335 13.74% NextEre 5,819,000 $4357 10.02% $253,526 12.08% NYPA 2,174,687 54.92 3.74% $10,699 0.51% ISO Interchange 12,296,775 $22.47 21.17% $276,255 13.16% NEMA Congestion 0 $0.00 0.00% - $303,952 - 14.48% Coop Resales 94,307 $143.62 0.16% $13,544 0.65% MacOuene 19,948,800 $5855 34.34% $1.168,055 55.66% Braintree Watson Un4 544,711 $52.98 0.94% $28,861 1.38% Swift River Projects 2,643,823 $97.93 4.55% $258,907 12.34% Stonybrook Peaking 0 $0.00 0.00% $34 0.00% Monthly Total 58,085,534 $36.13 100.00% $2,098.551 100.00% Table 2 breaks down the ISO interchange between the DA LMP Settlement and the RT Net Energy for the month of May, 2012. • CAPACITY • The RMLD hit a demand of 112,240 kW, which occurred on May 31, 2012 at 5 pm. The RMLD's monthly UCAP requirement for May, 2012 was 200,926 kWs. Table 3 shows the sources of capacity that the RMLD utilized to meet its requirements. Table 3 Table 2 Amount Cost %of Total Resource of Energy of Energy Energy (kWh) ($ /Mwh) Total Cost $ ISO DA LMP 12,504,915 28.89 21.53% Settlement RT Net Energy •• - 208,140 367.79 -0.36% Settlement Stonybrook Peaking 24,981 ISO Interchange 12,296,775 22.47 21,17% (subtotal) 42,925 2.01 $50,292 • independent system Operator Day -Ahead Lomhonal Marginal Price '• Real Time Net Energy 4,666 3.87 $166,056 CAPACITY • The RMLD hit a demand of 112,240 kW, which occurred on May 31, 2012 at 5 pm. The RMLD's monthly UCAP requirement for May, 2012 was 200,926 kWs. Table 3 shows the sources of capacity that the RMLD utilized to meet its requirements. Table 3 Cost Source Amount (kWe) ($/kW- %of Total month) Total Cost $ Cost Millstone #3 4,991 51.72 Seabrook 7910 8258,126 19.13% Stonybrook Peaking 24,981 49.81 $393,987 29.20% Stonybrook CC 42,925 2.01 $50,292 3.73% NYPA 4,666 3.87 $166,056 12.31% Hydro Quebec 4,274 3.07 $14,347 1.06% Braintree Watson Unit 10,520 0 . 00 $15,146 1.12% ISO -NE Supply Auction 100,659 10.61 $111'641 827% 3.37 $339,627 25.17% Total 200,926 $6.72 $1,349,221 100.00% • Resource Table 4 shows the dollar amounts for energy and capacity per source. Table 4 %of Amt of Energy Energy Capacity Total at Total Coat (kWh) $25,792 $40,504 $37,989 $0 $288,335 $253,526 $10,699 $276,255 - $303,952 $1,168,055 $28,861 $258,907 $13,544 $34 Millstone e3 Seabrook Stonybrook Intermediate Hydra Quebec JP Morgan Ne #Era NYPA ISO Interchange Name Congestion MacOuarie Braintree Watson Unit Swift River Projects Coop Resales Stonybrook Peaking Monthly Total ' Renewable Resources $2,098,551 $258,126 $393,987 $166,066 $15,146 $0 $0 $14,347 $339,627 $0 $0 $111,641 $0 $0 $50,292 $1,349,221 $283,918 $434,491 $204,045 $15,146 $288,335 $253,526 $25,047 $615,882 - $303,952 $1,168,055 $140,502 $258,907 $13,644 $50,326 $3,447,772 8.23% 12.60% 5.92% 0.44% 8.36% 7.35% 0.73% 17.86% -8.82% 33.88% 4.08% 7.51% 0.39% 46% 100.00% 3,691,155 4,985,534 693,742 5,193,000 5,819,000 2,174,687 12,296,775 19,948,800 544,711 2,643823 94,307 58,085,534 Cost of Power ($IkWh) 0.0769 0o672 0.2941 0.0000 0.0555 0.0436 0.0115 0 0501 0.0000 0.0586 0.2579 0.0979 0.1436 0.0000 0.0594 TRANSMISSION The RMLD's total transmission costs for the month of May were $600,009. This is a decrease of 2% from the April transmission cost of $613,473. In May, 2011 the transmission cost were $574,627. Table 5 l Current Month Last Month Last Year Peak Demand (kW) 112,240 104,469 121,532 Energy (kWh) 58,085,534 52,585,631 57,739,678 Energy ($) $2,098,551 $2,154,730 $3,015,862 Capacity ($) $1,349,221 $1,352,937 $1,524,643 Transmission ($) $600,009 5613,473 $574,627 Total $4,047,782 $4,121,140 $5,115,132 l U z ti U �V W �I a z A 9 N. a n E E 0 V 5 W v c v a �d a �A a O a T O a C Y O M G O C V y�C i CO O 6 O Z V C 0 V �L c 41 E 0 S E e E 0 Pi 3 N doa V T a E T a d Tv d cA c m v w 9 V V h n F • • ATTACHMENT 4 Dt: June 21, 2012 ® To: RMLB, Vincent F. Cameron, Jr., Jeanne Foti Fr: Bob Fournier Sj: May 31, 2012 Report The results for the eleven months ending May 31, 2012, for the fiscal year 2012 will be summarized in the following paragraphs. 1) Change in Net Assets: (Page 3A) For the month of May, the net income or the positive change in net assets was $168,536, increasing the year to date net income to $3,193,230. The year to date budgeted net income was $4,688,354, resulting in net income being under budget by $1,495,123 or 31.89 %. Actual year to date fuel expenses exceeded fuel revenues by $409,603. 2) Revenues: (Page 11B) Year to date base revenues were under budget by $2,614,771 or 6.01 %. Actual base revenues were $40.8 million compared to the budgeted amount of $43.4 million. 3) Expenses: (Page 12A) *Year to date purchased power base expense was under budget by $1,971,863 or 7.99 %. Actual purchased power base costs were $22.7 million compared to the budgeted amount of $24.7 million. *Year to date operating and maintenance (O &M) expenses combined were under budget by $286,843 or 2.69 %. Actual O &M expenses were $10.3 million compared to the budgeted amount of $10.6 million. *Depreciation expense and voluntary payments to the Towns were on budget 4) Cash (Page 9) *Operating Fund was at $9,892,165. *Capital Fund balance was at $3,286,854. * Rate Stabilization Fund was at $6,074,335. * Deferred Fuel Fund balance was at $2,645,621. * Energy Conservation Fund balance was at $262,121. 5) General Information: Year to date kwh sales (Page 5) were 626,748,638 which is 23.9 million kwh or 3.67 %, behind last year's actual figure. GAW revenues collected ytd were $626,798 bringing the total collected since inception to $1,233,970. 6) Budget Variance: Cumulatively, the five divisions were under budget by $345,480 or 2.0 %. 0 FINANCIAL REPORT • MAY 31, 2012 �, ISSUE DATE: JUNE 21, 2012 4 NET ASSETS TOM OF READING, NASSACHUSETTS INVESTED IN CAPITAL ASSETS, "I OF RELATED DEBT MUNICIPAL LIG= OEPARTNBNT 68,582,488.36 RESTRICTED FOR DEPRECIATION POND (P.9) BUSINESS -TYPE PROPRIETARY FUND 3,286,854.31 UNRESTRICTED STATEMENT OF NET ASSETS 16927,470.08 TOTAL NET ASSETS (P.3) 5/31/1] 96.796.811.]5 PERVIOUS YEAR CURRENT YEAR ASSETS CURRENT UNRESTRICTED CASH (SCH A P.9) 8,590,981.06 9,895,165.01 RESTRICTED CASH (SCH A P.9) 16,387,]9].35 19,162,596.07 RESTRICTED INVESTMENTS (SCH A P.9) 2,200,000.00 0.00 RECEIVABLES, NET (SCH B P.10) 6,809,951.83 6,176,981.98 PREPAID EXPENSES (S CH B P.10) 915,909.52 1,029,153.23 1 EVENED BY 1,652,115.35 1,504,041.60 TOTAL CURRENT ASSETS 36.SSfi.750.11 37.868.736.89 NONCURRENT INVEST1UHiT IN ASSOCIATED CO (SCR C P.2) 85,253.67 61,574.36 CAPITAL ASSETS, NET (SCH C P.1) 67,709,105.13 68,582,480.36 TOTAL NONCURRENT ASSETS 67,799.350.00 68.646061.71 TOTAL ASSETS 104.351.108.91 106,51].799.61 LIABILITIES CURRENT ACCOUNTS PAYABLE 6,055,263.53 4.583,936.92 CUSTONRR DEPOSITS ® 559,235.03 615,661.49 CUSTOMER ADVANCES FOR CONSTRUCTION 194,124.56 340,505.17 ACCRUED LIABILITIES 1,366953.66 1,]]3,183.70 TOTAL CURRENT LIABILITIES 8.275.576.78 6.781.288.28 NONCURRENT ACCRUED EMPLOYEE COMPENSATED ABSENCES 3,020.032.75 2,934.698.58 TOTAL NONCURRENT LIABILITIES 3.0]0.032.75 2.934.698.58 TOTAL LIABILITIES 11.295.609.53 9,715,986.86 4 NET ASSETS INVESTED IN CAPITAL ASSETS, "I OF RELATED DEBT 67,709,105.13 68,582,488.36 RESTRICTED FOR DEPRECIATION POND (P.9) 4,487,841.36 3,286,854.31 UNRESTRICTED 10,858,551.89 16927,470.08 TOTAL NET ASSETS (P.3) 93.055.999.38 96.796.811.]5 TOTAL LIABILITIES AND MT ASSETS 104.3516108.91 106,512,799.61 I1) TONS ON READING, MASSACHUSETTS MUNICIPAL LIGHT DEPART6ffiiT NONCURRENT ASSET SCHEDULE 5/31/13 SCNEOCLE OF INVESTMENTS IN ASSOCIATED COMPANIES NEW ENGLAND HYDRO ELECTRIC NEW ENGLAND HYDRO TRANSMISSION TOTAL INVESTMENTS IN ASSOCIATED COMPANIES SCHEDULE OF CAPITAL ASSETS LAND STRUCTORES AND INPRO,,,RNTS EQUIPMENT AND FURNISHINGS INFRASTRUCTURE TOTAL CAPITAL ASSETS, NET TOTAL NONCURRENT ASSETS 111 SCN Dmz C PREVIOUS FEAR CURRENT IRAN 13,538.60 11,631.19 61,)15.0) 46,943.17 85.153.67 61.574.36 1,365,843.13 6,886,443.43 13,499,188.19 46,057,631.38 6).)09.105 13 67,794.358.80 1,365,841.13 6,))8,053.51 13,033,604.15 47,505,988.46 68.581.488 36 fi B,644,061 .)1 • TONN OP READING, MASSACITUSNTTS INNICIPAL LIOST DEPARTMENT BUSINESS -TYPR PROPRIETARY FUND STATBMRNT OF REVENUES. EEPBNSRS AND CSANUES IN FUND NRT ASSETS OPERATING EXPENSES: INCH E P.12) PORCEASED POWER BASE PORCNAS® POWER FUEL OPERATING MAINTENANCE DEPRECIATION VOLUNTARY PAYMENTS TO TOWNS TOTAL OPERATING EXPENSES OPERATING INCOME 4WPERATIM0 REVENUES (=,.SES) CONTRIBUTIONS IN AID OP CONST RETOAN ON INVESTMENT TO READING INTEREST INCOME INTEREST EXPENSE OTBHR (MDSE AND AM)RTI TDTAL NONOPERATINO RN (8XP) CNANGE IN NET ASSETS EST ASSETS AT BEGINNING OF YEAR NET ASSETS AT END OF NAY 2,100,655.69 1,952,992.83 5/31/12 25,181,471.63 22,707.902.18 -9.82% SB1 3,015,861.75 NONTE MONTH LAST YEAR CORRQPP YEAR YTD t LAST THAN CORRERT YEAR TO DATE 7,846,508.34 TO DATE 0.93% CHANGE OPERATING REVENGES: IBM D P.11) 180,746.53 3,592,025.07 2,530,190.77 - 29.561 287,729.05 3,320,456.79 3,230,775.49 41,629,209.20 40,872.659.51 -1.82% BASE REVEROE 2,681,151.10 1,205,885.00 2,344,120.24 1,239,186.00 36,985,800.09 2.76% 32,653,406.45 - 11.71% FUEL RN8IN3E 37,591.24 (9,376.89) 1,316,688.36 (119,068.00) - 109.03% FURCNASED POWER CAPACITT 72,044.18 55,711.23 934,577.34 829,403.37 - 11.25% FORFEITED DISCOUNTS 34,534.58 48,567.85 460,055.02 557,251.34 21.13% ®2ERGY CONSERVATION REVENUE 50,129.95 49,363.61 510,743.02 626,798.83 22.72% GAS REVENGE (37.496.39) (33.019.19) 1682.791.671 (596.184.54) - 12.68% NYPA CREDIT TOTAL OPERATING REVENUES 61158,441.45 5,686,142.34 81,156,282.16 74,824,266.96 -7.80% OPERATING EXPENSES: INCH E P.12) PORCEASED POWER BASE PORCNAS® POWER FUEL OPERATING MAINTENANCE DEPRECIATION VOLUNTARY PAYMENTS TO TOWNS TOTAL OPERATING EXPENSES OPERATING INCOME 4WPERATIM0 REVENUES (=,.SES) CONTRIBUTIONS IN AID OP CONST RETOAN ON INVESTMENT TO READING INTEREST INCOME INTEREST EXPENSE OTBHR (MDSE AND AM)RTI TDTAL NONOPERATINO RN (8XP) CNANGE IN NET ASSETS EST ASSETS AT BEGINNING OF YEAR NET ASSETS AT END OF NAY 2,100,655.69 1,952,992.83 25,181,471.63 22,707.902.18 -9.82% SB1 3,015,861.75 2,098,550.90 36,336,953.37 32,466,825.39 - 10.65% 625,589.44 720,722.99 7,774,527.39 7,846,508.34 0.93% 228,341.75 180,746.53 3,592,025.07 2,530,190.77 - 29.561 287,729.05 296,027.47 3,165,019.55 3,256,302.17 2.88% 110.000.00 113.000.00 1,205,885.00 1,239,186.00 2.76% 6,368,177.68 5,362,042.72 77,255,882.01 70,047.002.85 -9.33% (209,736.23) 324.099.62 3,900,400.15 4,777,264.11 22.48% 14,720.64 0.00 61,884.66 54,965.54 -11. SB1 (180,990.00) (183,829.75) (11990,890.00) (2,022,117.25) 1.57% 3,089.09 3,572.46 98,278.65 77,135.65 - 21.51% (1,003.48) (503.00) (13,311.11) (7,234.50) - 45.65% 2,405.00 15,197.40 179,172.42 313,226.73 74.72% (161.770.75) (155,562.891 11.661.]65.381 11.584.0]3.831 -4.85% (371.514.98) 169.536.73 2,235,634.77 3,193,230.28 M 90,819,864.61 93,603,582.47 93.055.499.36 96.796.81].]5 42.83% 3.07% 4.02% TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUSINESS -TYPE PROPRIETARY POSED STATEMENT OF REVENUES, EXPRNBBS AND CHANGES IN FORD NET ASSETS 5/31/12 OPERATING RBVENNBS: (8CH F P.11B) BASE REVENUE FUEL REVERSE PURCHASED POWER CAPACITY FORFEITED DISCOUNTS MERGE CONSERVATION REVENUE MN REVENUE NYPA CREDIT TOTAL OPERATING REVENUES OPERATING EXPENSES: (SCE G P.12A) PURCHASED POWER BABE PURCHASED POWER FUEL OPERATING MAINTENANCE DEPRECIATION VOLUNTARY PAYMENTS TO TOWNS TOTAL OPERATING EXPENSES OPERATING INCOME NONOPBRATING REVENUES (RIPENESS) CONTRIBUTIONS IN AID OF CONST RETURN ON INVESTMENT TO READING INTEREST INCONB INTEREST EXPENSE OTHER (MORE AND MORT) TOTAL NONOPERATING REV (SAP) CHANGE IN NET ASSETS NET ASSETS AT BEGINNING OF YEAR NET ASSETS AT RED OF MAY ( ) = ACTUAL UNDER BUDGET ACTUAL BUDGET % YEAR TO MTN YEAR TO DATE VARIANCE+ CHANGE 40,872,659.51 43,487,431.00 (2,614,]]1.49) -6.01% 32,653,406.45 3],3]3,802.00 (4,]20,395.55) - 12.63% (119,068.00) (123,503.00) 4,435.00 -3.595 829,403.37 956,724.00 (127,320.63) - 13.31% 557,251.34 481,]1].00 75,534.34 15.68% 626,798.83 00 635,943.00 (9,144.17) -1.44% (596,104 54) (550.000.00) (46,184,54) 8.40% 74,824,266.96 82,262,114.00 (7,437,847.04) -9.04% 22,]0],982.18 24,679,846.00 (1,971,863.82) -9.99% 32,466,825.39 36,321,863.00 (3,855,037.61) - 10.61% 7,846,508.34 8,100,129.00 (253,620.66) -3.13% 2,530,198.]] 2,563,422.00 (33,223.23) -1.305 3.256,302.17 3,300,000.00 (43,697.83) -1.32% 1.239.186 00 1.243.000.00 (31814.00) -0.31% ]0,04],002.85 76,208,260.00 (6,161,257.15) -8.08% 4,]9],264.11 6,053,854.00 (1,276,509.89) - 21.09% 54,965.54 400,000.00 (345,034.46) - 86.26% (2,022,127.25) (2,035,000.00) 12,8]2.]5 -0.63% ]],135.65 165,000.00 (87,864.35) - 53.25% (7,234.50) (5,500.00) (1,734.50) 31.54% 313,226.73 110,000.00 203,226.73 184.75% (1.584.033.831 13.365.500.001 (318.533.831 16.005 3,193,230.20 4,688,354.00 (1,495,123.72) 93,603,582.47 93,603,582.49 0.00 96 ]9�_ ®•812.45 _�8 291.936.E (1,495.123.921 (3A) - 31.89% 0.00% -1.52% P 0 A TONN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT RECONCILIATION OF CAPITAL FUNDS 5/31/12 SOURCE OF CAPITAL FUNDS: DEPRECIATION FUND EALANCE 7/1/11 CONSTRUCTION FUND BALANCE 7/1/11 INTEREST ON DEPRECIATION FUND FY 12 DEPRECIATION TRANSFER FY 12 FORCED ACCOUNTS REIMBURSEMENT DAN SUBSTATION (PY 12) TOTAL SOURCE OF CAPITAL FUNDS USE OF CAPITAL FUNDS: PAID ADDITIONS TO PLANT TNRU MAY PAID ADDITIONS TO UAW THAD MAY TOTAL USE OF CAPITAL FONDS GENERAL LEDGER CAPITAL FUNDS BALANCE 5/31/12 PAID ADDITIONS TO PAID ADDITIONS TO PAID ADDITIONS TO PAID ADDITIONS TO PAID ADDITIONS TO TOTAL SAW SAW SAW GAW SAW FROM PY 12 FROM PY 11 FROM FY 1D FROM FY 09 FROM FY OD (4) 4,293,280.94 (15,000.00) 4,297,944.13 0.00 10,BBE.95 3,256,302.17 0.00 0.00 7,565,135.25 4,278,280.94 3 286,854.31 (15,000.00) 531,704.00 1,372,876.00 3,136,764.00 1,095,975.00 6.922.399.00 TONS OF READING, OASSACHUSETTS HONICIPAL LIONS DEPARTMENT SALES OF KILOWATT HOURS 5/31/11 SALES OF ELECTRICITY: NORTH LAST YEAR NORTH CONSENT YEAR LAST YEAR TO DATE CURRENT YEAR TO DATE YTD % CHARGE RESIDENTIAL BALES COM- AND INDUSTRIAL SALES PRIVATE STREET LIGHTING 16,024,893 32,784,610 72,646 15,712,953 31,290,950 73,075 239,846,917 381,689,568 792,756 218,226,577 370,441,334 804,208 -4.84% -2.95% 1.44% 914.]90 TOTAL PRIVATE CONSUNIRS 11.765.396 11,366.244 -3.39% -3.67% 48.881.1f9 4].086.978 622.329.241 599.472,119 MUNICIPAL SALES: STREET LIGHTING MUNICIPAL BUILDINGS TOTAL RUNICIPAL CONSONERS SALES FOR RESALE SCHOOL TOTAL RILONATT HOURS SOLD 239,009 137,586 2.627,623 1,625,863 -0.07% 675,782 713,339 9,137,773 8,740,381 -4.35% 914.]90 950.9]5 11.765.396 11,366.244 -3.39% 195,043 102,644 3,172,498 1,960,202 -6.69% 1,126,807 11111,885 13,355,501 12,950,073 -3.04% 51,118.789 49.352.43] 650,622.636 616.748.6)8 -3.67% 151 • 171 TOWN OF READING, MASSACHUSETTS MONICIPAL LIGHT DEPARTMENT KILOWATT HOOKS SOLO BY TOWN KILOWATT BOMB SOLD TO TOTAL 5/31/12 TOTAL TOTAL READING LYNHFIELD W.READING WILMINGTON MONTH 31.86% 30.37% 4.38% 7.70% 9.28% COME I COME 4 IND RESIDENTIAL 15,]2],953 5,068,403 3,160,765 3,665,493 4,828,293 PVT ST LIGHTS COMN R IND 31,290,950 3,938,431 234,657 4,784,753 33,333,109 PUB ST LIGHTS PVT 8T LIGHTS 73,075 13,737 1,360 21,276 36,703 MUNI BLDGB PUB ST LIGHTS 137,586 80,536 33,480 40,043 84,537 SALES /P85ALE MUNI BLDGS 713,339 173,108 123,696 145,134 171,299 SCHOOL BALES / REBALE 202,644 302,644 0 0 0 TOTAL SCHOOL 1,111,885 395,514 238,809 140,760 336,733 TOTAL 49.352,43] 9.871.473 2.791.849 8.797.459 17.890.651 YEAR TO DATE 36.41% 11.47% 5.10% 0.50% 11.34% COMB B In HESIDBHTIAL 228,226,577 71,861,373 31,961,479 53,304,898 71,097,827 PVT 8T LIGHTS comm A IND 370,441,334 46,930,641 3,962,600 57,312,471 263,227,631 PUB ST LIGHTS PVT 8T LIGHTS 604,108 152,727 14,960 137,416 399,105 MUNI BLOW PUB 8T LIGHTS 2,635,863 885,396 357,0]] 439,172 944,373 SALES / RESALS BONI BIGGS 8,740,301 11174,894 1,491,155 1,697,173 3,277,159 SCHOOL BALES /RESALE 2,960,202 2,960,302 0 0 0 TOTAL SCHOOL 13,950,073 4,619,044 1,808,363 1,662,200 3,859,666 TOTAL 616.748.638 129.694.077 39.595.579 114.653,330 393.805.65] LAST YEAR 36.86% 17.59% 5.47% 8.61% TO DATE 58.67% 0.33% 0.47% 8.89% 41.49% 41.99% PVT ST LIGHTS RESIDENTIAL 239,846,917 75,421,333 33,638,637 56,042,693 74,754,265 PUB 8T LIGHTS COIGN 4 IND 381,689,568 47,593,444 3,079,588 57,811,502 373,205,034 MONI BLD39 PVT ST LIGHTS 792,756 154,129 14,960 ]3],489 391,178 SALES/RESALE PUB ST LIGHTS 2,627,623 884,796 356,959 437,167 948,701 ® HURI ELMS 9,137,773 2,487,520 3,173,498 1,582,051 0 1,817,936 0 3,350,276 0 TOTAL BALES /RESALE 3,171,498 6.37% 10.16% 54.80% SCHOOL 13,355,501 4,729,018 2,836,157 1,757,040 4,032,486 TOTAL 650.6]3,636 134.443.538 41.498.342 118.098,816 356.581.940 KILOWATT BOMB SOLD TO TOTAL TOTAL READING LVNNIISLD NO.READING WILMINGTOM MONTH TIND 31.86% 30.37% 4.38% 7.70% 9.28% COME I COME 4 IND 63.40% 0.98% 0.48% 9.00% 45.15% PVT ST LIGHTS 0.15% 0.03% 0.0 0.04% 0.07% PUB ST LIGHTS 0.48% 0.% 0.07% 7% 0.08% 0.17% MUNI BLDGB 1.45% 0.3535% 0.35% 0.39% 0.55% SALES /P85ALE 0.41% 0.41% 0.00% 0.00% 0.00% SCHOOL 1.35% 0.804 0.48% 0.19% 0.68% TOTAL 100.00k ]0.00% S.fibt 17.B3% 56.519 YEAR TO DATE REBIDENTIAL 36.41% 11.47% 5.10% 0.50% 11.34% COMB B In 59.11% 7.49% 0.47% 9.14% 42.00% PVT 8T LIGHTS 0.13% 0.03% 0.00% 0.04% 0.06% PUB ST LIGHTS 0.43% 0.14% 0.06% 0.07% 0.15% MUNI BLOW 1.39% 0.36% 0.14% 0.27% 0.51% SALES / RESALS 0.47% 0.47% 0.00% 0.00% 0.00% SCHOOL 3.07% 0.74% 0.45% 0.37% 0.61% TOTAL 100.00% 10.69Y 6.32% 18.29% 54.70% LAST YEAR TO DATE RESIDENTIAL 36.86% 17.59% 5.47% 8.61% COME COMM B IND 58.67% 0.33% 0.47% 8.89% 41.49% 41.99% PVT ST LIGHTS 0.1% 0.03% 0.00% 0.04% .5% PUB 8T LIGHTS 0.44 1% 0.14% 0.05% 0.07% 0.115% 0 MONI BLD39 1.40% 0.38% 0.14% 0.30% 0.50% SALES/RESALE 0.49% 0.49% 0.00% 0.00% 0.00% eCX00L 3.05% 0.734 0.441 0.37% 0.614 TOTAL 100.00% 30.67% 6.37% 10.16% 54.80% (6) TOWN OF READING, MASSACHUSETTS HUNICIPAL LIGHT DEPARTNENT PORHOLA INCOME 5/31/12 TOTAL OPERATING REVENUES ADD: POOR RENTAL LESS: (P.3) 74,824,266.96 INTEREST INCOME ON CUSTOMER DEPOSITS OPERATING EXPENSES (P.3) CUSTOMR DEPOSIT INTEREST EXPENSE FORMULA INCONH (LOSS) 1,455.00 1,342.91 (70,047,002.85) (7,234.50) 4.772 827.52 11 SALE OF KWH (P. 5) KWH PURCHASED AVE EASE COST PER EWE AVE EASE SALE PER KWH AVE COST PER KWH AVE SALE PER KWH FUEL CHARGE REVENUE (P.3) LOAD FACTOR FEAR LOAD TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT GENERAL STATISTICS 5/31/12 MONTH OF MAY 2011 51,118,789 53,431,859 0.041910 0.065007 0.093353 0.118479 2,681,181.10 79.06% 92,584 MONTH OF MAY 2012 49,352,432 58,267,384 0.033518 0.065463 0.069534 0.112961 2,344,120.24 71.11% 112,240 Im % CHANGE YEAR THRU 2011 2012 MAY 2011 MAY 2012 4.95% -3.67% 650,622,636 626,748,630 4.12% 6.32% 613,733,632 652,543,829 -3.74% -7.47% 0.037607 0.034799 11.82% 2.23% 0.063794 0.065214 -4.51% -7.99% 0.091900 0.084553 0.16% -2.98% 0.120921 0.117313 -6.46% - 11.71% 36,985,800.09 32,653,406.45 N i 3 I 0 0 N N � � c o > can � U p U LZ U N co T 1 1 -y 1 N i 3 I 0 0 TOWN OF READING, NASSACHOSETTS NDNICIPAL LIGHT DEPARTMENT SCHEDULE OF CASH AND INVESTMENTS 5/31/11 UNRESTRICTED ASH: CASH - OPERATING POND CASH - PETTY CASH TOTAL UNRESTRICTED CASH RESTRICTED CASH' CASH - DEPRECIATION POND CASH - TOWN PAYMNI CASH - DEFERRED FUEL RESERVE CASH - RATE STABILIZATION FUND CASH - UNCOLLECTIBLE ACCTS RESERVE CASH - SICK LEAVE BENEFITS CASH - RAEARD WASTE "SERVE CASH - COSTOEIR DEPOSITS CASH - ENBRGY CONSERVATION CASH - OPEB TOTAL RESTRICTED CASH ON RATE STABILIZATION SICK LEAVE BUYBACK OPER TOTAL RESTRICTED INVESTMENTS lill TOTAL CASH BALANCE PREVIOUS YEAR 8,587,981.06 3,000.00 8.590.901.06 4,487,649.36 1,456,250.00 1,191,167.14 4,395,411.49 100,000.00 1,036,980.50 150,000.00 559,135.03 194,]]9.06 615,116.]] 16.38],]91.35 11000,000.00 11000,000.00 100,000.00 1,100.000.00 ]],1]8,]]3.41 SCHEDULE A 9,891,165.01 3,000.00 9,895.165.01 3,186,854.31 1,700,000.00 2,645,621.30 6,074,335.60 100,000.00 3,955,744.59 150,000.00 635,661.49 262,111.28 1,174,156.50 19.161,596.0] D.00 0.00 0.00 0.00 19,05],]61.08 MAY 3011 • PREDDIE NAC 1,000,000.00; DID 09/10/10; INT 1.00 %; NATURITY 09/15/10 +• PREDDIE MAC 11000,000.00, DID 09/10/10; IM 2.00%; MATURITY 09/15/10 +•• FREDDIE MAC 100,000.00; DID 09/10/10; INT 1.00%; MATURITY 09/15/10 (9) TOW OF READING, MASSACHUSETTS MUNICIPAL LIGHT DHPARTMRiT SCHEDULE OF ACCOUNTS RECEIVABLE 5/31/12 • SCHEDULE B SCHEDULE OF ACCOUNTS RHCEIVABL@ PRNIOOS YEAR CURRENT YWl RESIDENTIAL BED COMMERCIAL ACCOUNTS RECEIVABLE - OTHER 3,209,896.38 1,818,5]7.5] ACCOUNTS RECEIVABLE - LIENS 124,343.83 130,]2].23 ACCOUNTS RECEIVABLE - EMPLOYER ADVANCES 83,925.83 33,509.80 SALES DISCOUNT LIABILITY 892.14 892.14 RESERVE FOR UNCOLLECTIBLE ACCOUNTS (304,636.06) (219,729.88) TOTAL ACCOUNTS RECEIVABLE BILLED (359.629.40) 2,754,792.72 (317.289.25) 1,446,987.61 UDlILLED ACCOUNTS RECEIVABLE 4,055,159.11 4,830,294.37 TOTAL ACCOUNTS RECEIVABLE, NET 6 809,951.83 6�2]6,9B1.90 SCHEDULE OF PRBPAYIE%TS PREPAID INSURANCE 510,364.13 PREPAYMENT PURCHASED POWER 553,126.44 PREPAYMENT PAENY 22,046.35 BJ,324.59 PREPAYMENT WATSON ]39,666.6) 240,783.65 PURCHASED POWER WORKING CAPITAL 119,308.71 133,394.85 14,523.70 14,513.70 TOTAL PREPAYMENT 915,909.52 _1.029.152.23 ACCOUNTS RECEIVABLE AGING MAY 3012: RESIDENTIAL AND COMMERCIAL LESS: SALES DISCOUNT LIABILITY 1,818,5]].57 GENERAL LEDGER BALANCE (219.729.88) 1,598,847.69 CURRENT 1,263,833.32 79.05% 30 DAYS 206,918.02 11.94% 60 DAYS 47,951.00 3.00% 90 DAYS 14,219.51 0.89% OVER 90 DAYS 65.925.84 4.12% TOTAL 1,598.897.69 100.00% J TOM OF READING, MASSACHUSETTS NGNICIPAL LIGHT DEPARIKENT SCHEDULE OF OPERATING REV8NO8 CBOB -TOTAL 6,001,637.89 5/31/12 78,615,009.29 73,526,065.96 -6.47% k 72,044.18 55,711.23 934,577.34 SCHEDULE D . 11.25% SALES OF ELECTRICITY: NORTH LAST YEAR MONTH CURRENT YEAR LAST YEAR TO DATE CURRENT YEAR TO DATE YTD t CHANGE RESIDENTIAL BALES COW AND INDUSTRIAL BALES PRIVATE STREET LIGHTING 2,127,214.61 3,577,773.61 10,489.65 ENERGY CONSERVATION - RESIDENTIAL ENERGY CONSERVATION - C06DDIRCIAL 1,995,338.55 3,315,297.13 5,714.54 31,765,231.41 43,118,367.69 116,342.15 ]9,803,994.2] 40,426,798.03 71,212.93 -6.17% -6.34% - 38.79% TOTAL PRIVATE CONSUMERS 5.715.477.87 SAW REVENUE 5.31fi.J50.2] 74.999.941.25 70.30].005.33 -6.26% 22.72% NYPA CR ®IT (37,496.39) (33,019.19) (682,791.67) MUNICIPAL BALES: (596,184.54) - 12.68% TOTAL REVENGE 6.158,411.45 5686,142.34 81,156.382.16 STREET LIGHTING MUNICIPAL BUILDINGS 45,837.15 85,094.92 27,990.59 84,133.10 509,500.84 1,118,928.43 340,283.60 1,051,070.67 - 33.21% -6.06% TOTAL MUNICIPAL CONSUMERS 130.933.07 112.1]2.69 1.628.437.]7 1.391.354.27 - 19.56% BALES FOR RESALE 23,907.42 23,639.92 392,677.44 359,439.96 -6.46% SCHOOL 131,320.53 122,782.90 1,593,953.33 1,473,266.50 -7.57% CBOB -TOTAL 6,001,637.89 5,574,895.73 78,615,009.29 73,526,065.96 -6.47% FORFEITED DISCOUNTS 72,044.18 55,711.23 934,577.34 829,403.37 . 11.25% PURCHASED POWER CAPACITY 37,591.24 (9,376.89) 1,318,688.36 (119,Ofi 8.00) - 109.03R ENERGY CONSERVATION - RESIDENTIAL ENERGY CONSERVATION - C06DDIRCIAL 11,216.78 23,317.80 15,733.46 32,834.39 135,206.81 324,848.21 104,903.86 352,347.48 51.55% 8.47% SAW REVENUE 50,129.95 49,363.61 510,743.82 626,798.83 22.72% NYPA CR ®IT (37,496.39) (33,019.19) (682,791.67) (596,184.54) - 12.68% TOTAL REVENGE 6.158,411.45 5686,142.34 81,156.382.16 74.814.366.96 -7.80% 1lv, TONN OF RRAOINO, MASSACHUSETTS MUNICIPAL LIGHT DEPARTREHT SCHEDULE OF OPERATING REVENGE BY TOW 5/31/12 El MONTH TOTAL READING LYNNPIELD 6,946,909.56 6,615,925.41 61,507.93 22,054.77 0.00 193,965.41 NO.R&1DING WILRINGTON RESIDENTIAL INDUS /HUNS BLDG PUB.ST.LIGHTB PRV.ST.LIGHTB CO -OP RESALE SCHOOL 1,995,338.55 3,399,429.23 27,990.59 5,714.54 23,639.92 1]],782.90 645,560.75 463,540.93 9,002.25 1,056.81 23,639.92 44,081.99 272,291.64 41,673.41 3,559.25 104.71 0.00 25,7)3.]0 464,523.23 539,192.78 5,242.40 1,722.65 0.00 16,064.35 612,962.93 2,355,014.11 10,186.69 2,830.37 0.00 36,863.36 TOTAL 73.526,065.96 1�_14),fifil.)1 x_048,045.85 13,840.363.09 38,489.995.31 TOTAL 55 5) 89573895.p3 1,186.890.65 343.402.21 1.026.)45.Q ),_01),85).46 THIS YEAR TO DATE RESIDENTIAL INDUS /MUNI BLDG PUB.ST.LIGHTS PRV.ST.LIGHTS CO -OP RBSALB SCHOOL 29,803,994.27 41,477,869.70 340,283.60 71,212.93 359,439.96 1,473,266.50 9,40 7,736.10 5,727,780.65 109,336.70 13,231.70 359,439.96 530,136.60 4,161,868.48 5]8,3]6.70 42,486.44 1,298.62 0.00 314,015.63 6,946,909.56 6,615,925.41 61,507.93 22,054.77 0.00 193,965.41 9,287,460.13 28,605,785.94 126,952.53 34,627.84 0.00 435,190.86 TOTAL 73.526,065.96 1�_14),fifil.)1 x_048,045.85 13,840.363.09 38,489.995.31 LAST YEAR TO DATE RESIDENTIAL INDUS /NVNI BLDG PUB. ST.LIGHTS PRV.ST.LIGHTS CO -OP RESALE SCHOOL 31,765,231.41 44,237,296.12 509,508.84 116,342.15 392,677.44 1,593,953.33 10,030,157.48 6,006,467.96 178,284.33 21,952.74 392,677.44 566,765.36 4,421,931.22 563,212.57 62,070.21 2,178.95 0.00 332,874.25 7,425,291.94 6,913,481.51 84,044.57 35,981.95 0.00 214,407.65 9,887,050.77 30, 754,134.08 185,109.73 56,228.51 0.00 479,906.07 TOTAL 78,615.009.29 1 >, 19fi.305.31 5,302.267.20 1414 67,�.10].6I207,62 41 ]63 229.Sfi PERCENTAGE OF OPERATING INCONB TO TOTAL MONTH TOTAL READING LYNNPIELD NO.RBADING NILNING ON RESIDENTIAL INDUS /NUNI BLDG PUB.Si.LIGHT9 PRV.6T.LIGHTB CO-OP RESALE SCHOOL 35.81% fi 0.49% 0.19% 0.42% 0'42% 2.70; 11.58! 8.31% 0.16% 0.02; 0.79% 0.79{ 4.50% G.JS% 0.00% 0.00% 0.46% 0.46% 8.67% 9.69! 0.09% 0.03% 0.00% 0.29% 29% 11.02% 12.25% 0.18% 0.05% 0.004 0.66% TOTAL 100.00% 21.28% 6.15 18.41% 54.16% THIS YEAR TO DATE RESIDENTIAL INDUS /NUNS BLDG PUB.ET.LIGHTB PRV.9T.LIGHTS CO -OP RESALE SCHOOL 40.54% 56.41% 0.46; 0.10% 0'19$ 2.00% 12.80% 7.79% 0.15% 0.02% 0.49\ 0.724 5.66% 0.72% 0.06% 0.00% 0.00% 0.4]; 9.45% 9.00% 0.00% 0.03% 0.00% 0.26% 12.63% 38.91% 0.1>% 0.05% 0.00% 0.59; TOTAL 100.00% 21.96{ LAST YEAR TO DATE RESIDENTIAL INDUS /MUM BLDG PUE.ST.LIGHTS PRV.ST.LIGHTS CO -OP RESALE SCHOOL 40.41% 56.27% 0.658 0.15% 0.50% 2.02% 12.76% 7.64; 0.23% 0.03\ 0.72% 0.72; 5.62% 0.08% 0.08% 0.004 0.00% O.43% 9.45% 8.79% 0.11% 0.05! 0.27% 0.2 >% 12.58% 39.134 0.23% 0.00 0.00 0.61% TOTAL 100.00% 21.88% 6.84; 18.fi); 111A) TOWN OF READING, BA SACHUSETT6 NIMICIPAL LIGHT DEPARTMENT BUDGETED REVENUE VARIANCE REPORT 5/31/12 u SALES OF ELECTRICITY: RESIDENTIAL MM AHD INDUSTRIAL SALES PRIVATE STREET LIGHTING MOHICIPAL BUILDINGS PUBLIC STREET LIGHTING SALES FOR RESALE SCHOOL TOTAL BASE BALES TOTAL PDSL SALES TOTAL OPERATING REVENUE FORFEITED OI SCOONTS PORCHASED POHER CAPACITY ENERGY CONSERVATION - RESIDENTIAL ENSRGY CONBBRVATION - COMMERCIAL SAW REVENE NYPA CREDIT TOTAL OPERATING REVENORS • ( ) . ACNAL ORDER BUDGET 4 BCNFDOLE P ACTUAL BUDGET % YEAR TO DATE YEAR TO DATE VARIANCE • CHANGE 17,8]4,23].36 19,157,548.00 (1,283,310.64) -6.70% 21,705,419.93 22,769,432.00 (984,011.07) -4.32% 204,199.36 471,849.00 (267,649.64) - 56.72% 204,501.77 157,916.00 (53,414.23) - 20.73% 604.301.09 030,686.00 (26,384.91) -3.18% 40,872,659.51 43,487,431.00 (1,614,771.49) -6.01% 32,653,406.45 37. 373.802.00 (4,720,395.55) - 12.63% 73,526,065.96 80,861,233.00 (7,335,167.04) -9.07% 829,403.37 956,724.00 (117,320.63) - 13.31% (119,068.00) (123,503.00) 4,435.00 -3.59% 204,903.86 1]8,0]9.00 26,824.66 15.06% 352,347.48 303,638.00 48,709.48 16.04% 626,798.83 635,943.00 (9,144.171 -1.44% (596,184.54) (550,000.00) (46,184.54) 8.40% -9.044 74, 824,166.96 82.162.114.00 1],43].84).041 11111 TORN OF READING. MASSACHUSETTS MUNICIPAL LIG= DEPAETMBNT SCHEDULE OF OPERATING EXPENSES 5/31/13 • ECH ®ULE e OPERATION EXPENSES, MONTH LAST YEAR MONTH LAST YEAR CURRENT YEAR Y71, % CURRENT YEAR TO DATE TO DATE CHANGE PURCHASED POWER BASE EXPENSE 3.100.655.69 1.952.991.83 15.181.1]1 63 11.707,981 38 -9.82% OPERATION SUPER AND ENGIN -TRAM 0.00 OPERATION SUP AND ENGINEERING NTP 33,780.0] 0.00 0.00 0.00 0.00% STATION SUP LABOR AND MISC 9,123.52 50,553.46 412,397.65 473,678.54 14.86% LING MISC LABOR AND EXPENSE 46,093.19 10,514.35 100,951.73 104,149.30 3.17% STATION LABOR AND EXPENSE 34,156.19 93,916.00 574,949.03 643,156.73 11.86% HIM= LIGHTING EXPENSE 6,167.29 41,463.01 410,291.82 425,893.18 3.80% H INE EXPENSE 17,363.04 10,870.17 84,431.41 109.931.67 30.20% MI6C DI6TRIBVTION BAPBN68 16,068.53 ,6. 118,30.81 - 33.01% ENTER READING LABOR G EXPENSE , 5,204.40 .05 32,736.71 300,667.52 312,358.96 3.89% ACCT G COIL LABOR G EXPENSE 100,564.06 8,116.41 fi5,118.13 84,453.62 39.69% ACCOUNTS 15,000.00 115,035.18 1,166.946.15 1,306,784.01 11.98% ENERGY AUDIT ENERGY AUDIT EXPENSE 36,191.41 16.000.00 165,000.00 176,000.00 6.67% ADMIX R 0m SALARIES 51,518.69 48,639.40 353,584.74 401,167.90 13.74% OFFICE SUPPLIES 0 EXPENSE 26,749.47 69,319.75 637,396.00 697,513.35 9.43% OUTSIDE SERVICES 14,904.97 249,093.47 101,661.97 - 18.90% PROPERTY INSURANCE 41,407.88 18,775.00 239,348.53 360,651.62 50.68% INJURIES AND DAMAGES 31,705.39 33,864.71 342,888.27 354,801.05 3.50% EMPLOYEES PENSIONS G BENEFITS 1,671.18 99,179.08 3,920.56 40,433.57 21,097.13 - 45.84% MISC GENERAL EXPENSE 7,514.38 86,095.48 1,440,789.06 1,145,110.33 - 30.51% RENT 8Xe®98N 7,107.32 146,943.21 157,067.02 6.094 ENERGY CONSERVATION 14,611.67 18,569.83 194,637.59 103,891.83 -0.40% 19,111.48 25,141.95 574,158.42 465,918.34 - 18.85% TOTAL OPERATION EXPENSES 625, 389.44 730 711.99 7,774,527.39 7 846 508.34 0.93% MAINTENANCE EEP@ISRS: • MINT OF TRANSMISSION PLANT 117.08 337.09 MAINT OF 6TRUCT AND BQUIPNT 12,424.35 3,197.93 3,197.90 0.00% MAINT OF LINES - OR 113,706.48 81600.18 148,965.76 214,120.41 43.74% MAINT OF LINTS - UG 94,399.59 1,160,619.79 1,459,517.16 15.05% MAINT OF LINE TRJSSFORMERS 19,538.64 18,346.01 17,900.35 147,199.32 167,159.09 13.56% WANT OF ST IT G SIG SYSTEM (33.18) 9,882.25 1,335,188.65 47,451.61 - 96.45% MAINT OF GARAGE AND STOCKROOM 37,940.20 (15.90) (161.35) (361.38) 121.59% MAINT OF METERS 35, 718.69 560,795.91 479,413.18 - 14.51% MAINT OF am PLANT PLANT 7,901.38 3,014.13 19,566.14 151.351 8,190.89 11,112.07 99,163.83 85,780.74 - 13.58% TOTAL MAINTENANCE EXPENSES 228.343 75 190.]48.53 _ 3.593.015.07 3.530.198.]7 - 29.56% DEPRECIATION EXPENSE 187,729.05 296,027.47 3,165,019.55 3,256,302.17 1.88% PURCHASED POWER FUEL EXPENSE 3,015,861.75 2,098,550.90 36,336,953.37 31,466,815.39 - 10.65% VOLUNTARY PAYMENTS TO TOWNS 110,D00.00 113,000.00 1.205,885.00 1,139,186.00 2.76% TOTAL OPERATING EXPENSES 6,368.177.68 5.363.041.]1 7],355.881.01 J0 0047,002.85 -9.33% • (17) • ( I = ACTUAL UNDER BUDGET (13x) TOWN OF READING, NASSACNGSETTS MUNICIPAL LIGHT DEPARTNENT BUDGETED OPERATING EXPENSE VARIANCE REPORT 5/31/12 SCHEDULE G ACTUAL BUDGET i OPERATION EXPENSES: YEAR TO DATE YEAR TO DATE VARIANCE • CHANCE PURCHASED POWER BASE EXPENSE 24.6]9.84fi.00 (1.9)1,863.821 -7.991 33.]0].983.18 OPERATION SUPER AND ENGIN -TRANS 0.00 0.00 0.00 0.00% 18.96% OPERATION SUP AND ENGINEERING RXP 4]3,6]0.54 398,184.00 75,494.54 STATION SUP LABOR AND RISC 104,149.30 56,171.00 47,978.30 85.41% LINE NISC LABOR AND EXPENSE 643,156.73 644,698.00 (1,)41.2)) -0.27% STATION LABOR AND EXPENSE 435,893.18 401,756.00 24,137.18 6.01% STREET LIGHTING EXPENSE 109,931.67 77.588.00 32,343.67 41.69% 59.27% NETER EXPENSE 210,330.81 137,081.00 81,249.81 MISC DISTRIBUTION EXPENSE 312,358.96 318,834.00 (6,475.04) -2.03% NETER READING LABOR A EXPENSE 84,453.62 69,040.00 15,413.62 22.33% ACCT 6 COLL LABOR 6 EXPENSE 1,306,784.03 1,295,441.00 11,343.02 0.88% 0.00% UNCOLLECTIBLE ACCOUNTS 176,000.00 176: 000.00 0.00 6.46% ENERGY AUDIT EXPENSE 402,167.98 377,767.00 34,400.98 ADRIN R GEN SALARIES 697.513.35 674,030.00 23,482.35 3.48% OFFICE SUPPLIES 6 EXPENSE 202,661.97 243,646.00 (40,984.03) - 16.82% OUTSIDE SERVICES 360,652.62 433,360.00 (]2,60).38) - 16.76% PROPERTY INSURANCE 354,882.05 436,2)2.00 (71,389.95) - 16.75% - 57.21% IN.)URIES AND DAMAGES 21,697.12 51,173.00 (29,375.88) - 14.55% ERPLOYEES PENSIONS 6 BENEFITS 1,145,130.23 1,340,122.00 (195,001.77) MISC GENERAL EXPENSE 157,067.03 193,882.00 (36,814.98) - 18.99% 194,33].00 (10,445.17) -S.J)% RENT EXPENSE 965,918.34 590,647.00 (134,720.66) - 21.131 ENERGY CONSERVATION TOTAL OPERATION EXPENSES 8.100,129.00 125J.620.fi61 -3.1]i 7,846.508.34 MAINTENANCE EXPENSES: MINT OF TRANSMISSION PLANT 2,497.90 2,750.00 (252.10) -9.17% MINT OF BIRO= AND RQUIPNENT 214,120.41 96,649.00 117,471.41 121.54% MINT OF LINES - OR 1,459,517.16 1,275,545.00 183,973.16 14.43% MINT OF LINES - 00 167,159.09 196,002.00 (28,842.91) - 14.72% MINT OF LINE TRANSFORMERS 47,451.61 180,277.00 (133,825.39) - 73.68% - 104.13% MINT OF $T IT A BIG SYSTeM (361.38) 8,753.00 (9,114.38) (120,921.82) - 21.19% MINT OF GARAGE AND STOCEROOM 479,423.10 608,345.00 MINT OF METERS 74,610.06 78,303.00 (3,692.94) -4.72% 85,]80.)4 116,798.00 (31,017.26) - 26.56% MINT OF GEN PLANT TOTAL MINTERANCE EXPENSES 2.563,4]].00 (33.223.23) -1.30% 1.530.198.]7 DEPRECIATION EXPENSE 3,256,302.17 3,300,000.00 (43,697.83) -1.32i PURCHASED POWER FUEL EXPENSE 32,466,625.39 36,331,663.00 13,955,037.61) - 10.614 VOLUNTARY PAYRRMS TO TOWS 1,339,186.00 1,343,000.00 (3,814.00) -0.31% TOTAL OPERATING EXPENSES -8.08% (6.161,25].151 ]6,200.260.00 70,04).002.85 • ( I = ACTUAL UNDER BUDGET (13x) TOWN OF RBAOING, HASSACHUSETTS MUNICIPAL LIGHT DEPARTHENT BUDGETED OPERATING EXPENSE VARIANCE REPORT 11]q 5/31/12 OPERATION 88P8N588: RESPONSIBLE SENIOR NANAGHR 2013 ANNUAL BUDGET YEAR TO DATE RENAINING BUDGET BALANCE REXAINING BUDGET % PURCHASED POWER BASE EXPENSE JP 2],403.1]].00 33.]0].982 IB 9.694.199.83 17.13% OPERATION SUPER AND BNGIN -TRANS OPERATION SUP AND ENGINEERING ESP STATION SUP LABOR AND NISC LINE NISC LABOR AND EXPENSE STATION LABOR AND EXPENSE STREET LIGHTING EXPENSE METER EXPENSE NISC DISTRIBUTION EXPENSE ACCT &BALING LABOR F EXPENSE ACCT F COIL LABOR F EXPENSE ENERGY ACCOUNTS RNKRGY AUDIT SALARIES OFFICE 6 UPN IALARIES OUTSID SUPPLIES 6 8%P6N38 OUTSIDE SERVICES PROPERTY INSURANCE INJURIES AND DAMAGES KMPLOYENE AL EXPENSE 6 BENEPITS NI SC EXPENSE E %PBN38 SENT ER EXPENSE ENERGY CONBEAVATION KS KS KS RS KS RS RS JD RB RP RP GP VC VC VC JD JD JD VC JD IF 0.00 438,974.00 63,909.00 692,484.00 991,924.00 8533000 ,. 153,130.00 351,500.00 76,220.00 1,93],]55.00 193,000.00 414,098.00 745,939.00 365,700.00 459,]50.00 455,000.00 55,859.00 1,441,637.00 103,091.00 ]1],000.00 693,789.00 0.00 473,678.54 104,149.30 643,156.73 425,893.18 109,931.67 318,330.81 312,358.96 84,453.63 1,306,789.03 176,000.00 902,167.98 697,512.35 302,661.97 360,652.62 359,883.05 31,897.13 1,145,120.23 15],06].03 463,991.83 965,918.31 0.00 (34,704.54) (41,240.30) 49,337.27 16,030.82 (24,593.67) (66,300.81) 90,199.09 (8,233.62) 130,470.98 16,000.00 11,930.02 48,426.65 63,038.03 93,597.38 110,117.95 33,961.80 246,516.]7 96,033.98 ]8,108.1] 17],8]0.66 0.00% -7.91% - 65.56% 7.13% 3.63% - 28.82% - 93.52% 11.39% - 10.80% 8.99% 8.33% 3.88% 6.49% 33.73% 10.60% 23.68% 20.57% 20.57% 32.664 13.36% 27.63% TOTAL OPERATION EXPENSES 8,83J.105.00 ].846.508.34 9]6.596 66 11.07% MAINTENANCE EXPENSES: • WAIST OF TRANSNIISION PLANT WAIST OF LINES STRUCT KAINT OF LINES - OR AND SOUIPMT NAINT OF LI NAINT OF LINE M - NG SRANSPORNERI SAINT OF ST IT 6 BIG SYSTEN NAINT OF GARAGE AND STOCKROOM (MINT OF G ETERB SAINT OF eN PLANT KB KI KS RE KS JD JD Re RP 3,000.00 10],07].00 1,419,953.00 214,037.00 188,500.00 9,636.00 663,139.00 85444 ,.00 127,620.00 3,497.90 214,120.41 1,459,517.16 157,159.09 47,451.61 (361.38) 479,423.18 74,610.O6 85,]90.]4 503.10 (107,048.41) (39,564.16) 46,8]].91 141,048.39 9,997.38 182,715.82 10,833.94 41,839.26 16.79% - 99.98% -2.79% 21.90% 74.83% 103.75% 27.59% 12.68% 32.78% TOTAL MAINTENANCE B%PBN568 2,817,401 00 2.530.198.]] _ 287.]0].23 10.19% UBPRECIATION EXPENSE RP 3,600,000.00 3,356,302.17 343,697.03 9.55% PURCHASED POWER FUEL EXPENSE JP 39,760,817.00 32,466,825.39 7,301,991.61 10.36% VOLUNTARY PAYNENTS TO TOWNS BY 1,356,000.00 1,339,186.00 116,814.00 8.61% TOTAL OPERATING EXPENSES _72500 on ]0.04] OOI.B5 13,720,497.15 16.38% 11]q PROFESSIONAL SERVICES BY PROJECT ITEM 1 ENID AND PENSION TRUST AUDIT FEES 1 PENSION ACTUARIAL EVALUATION 3 LEGAL- FERC /ISO ISSUES 4 LEGAL- POWER SUPPLY ISSUES 5 PROFESSIONAL SERVICES 6 NERC COMPLIANCE 7 LOAD CAPACITY STUDY 10IS 8 LEGAL SERVICES- GENERAL 9 LEGAL SERVICES - GENERAL 10 LEGAL SERVICES - NEGOTIATIONS 11 LEGAL GENERAL 11 SURVEY RIGHT OF NAY 13 ENVIRONMENTAL 14 STATION 1 STRUCTURAL FEASABILITY 15 DEMOLITION OF CONTROL CENTER 16 INSURANCE CONSULTANT 17 LEGAL TOTAL C, PROFESSIONAL SERVICES BY VENDOR TONS OF READINO, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT PROFESSIONAL SERVICES 05/31/3011 ROMARRE INSURANCE ROBIN AND RUDMAN UTILITY SERVICES INC. KELANSON SHAM A COMPANY DUNCAN AND ALLEN CHOATE HALL AND STSNART PROFESSIONAL SHVIRONMRTAL SERVICES CMERC FRANCESCO DEMOLITION INC. COVINO ENVIRONMENTAL ASSOCIATION TOTAL ILW DEPARTMENT ACTUAL BOUGHT VARIANTS ACCOUNTING 34,940.00 31,150.00 1,690.00 ACCOUNTING 0.00 6,000.00 (61000.00) ENERGY SERVICE 0.00 16,500.00 (16,500.00) ENERGY SERVICE 51,488.90 41,150.00 10,138.90 ENERGY SERVICE 7,484.31 11,000.00 (14,515.68) E 6 O 17,091.40 14,100.00 1,891.40 ENGINEERING 0.00 15,000.00 (15,000.00) GM 107,179.11 45,837.00 61,441.11 HE 51,561.14 38,500.00 13,061.14 ER 16,037.52 7,000.00 9,037.51 BLDG. MAZNT. 1,311.50 1,375.00 937.50 BLDG. MAINT. 0.00 4,587.00 (4,587.00) BLDG. MAINT. 7,350.69 4,597.00 1,763.69 BLDG. MAINT. 665.00 75,000.00 (74,335.00) BLDG. MAINT. 57,981.50 100,000.00 (41,017.50) GEN. BENEFIT 6,450.33 4,SB7.00 1,871.33 GEN. BENEFIT 0 00 4 587.00 (4,567.00) 360,651.61 433,1fi 0.00 171,607.38) (13) ACTUAL 6,041.66 146,676.03 16,406.67 44,153.62 9,115.87 67,598.76 2,140.00 4,169.31 56,800.00 7,350.69 3fi 0,652.fi1 DIVISION ENGINEERING AND OPERATIONS ENERGY SERVICES GENERAL MANAGER FACILITY MANAGER BUSINESS DIVISION SUB -TOTAL PURCHASED POWER - BASE PURCHASED POWER - FUEL TOTAL ENLD BUDGET VARIANCE REPORT FOR PERIOD ENDING MAY 31, 2012 ACTUAL BUDGET VARIANCE 4,230,005 3,832,130 397,876 927,130 1,048,626 (121,496) 738,427 657,017 81,410 2,644,201 3,227,747 (583,546) 8,361,814 8,481,537 (119,723) 16,901,577 17.247 056 (345,480) 22,707,982 24,679,846 32,466,825 36,321,863 CHANGE 10.38% - 11.59% 12.39% - 18.08% -1.41% -2.00% (1,971,864) -7.998 (3,855,038) - 10.61% 72,076,384 78,248,765 (6 172,381) -7.898 • V MD OSPBRAED FUEL GeX RESERVE ANALY6I8 05/31/13 GROSS MOMTH7.T TOTAL DATE CHARGES REV8NDE6 NTPA CREDIT DHPERRRD DEPBRRAD 3,055,224.78 Jvv -11 Jul -31 4,131,396.83 4,049,745.45 (79,163.6 5) (160,815.03) 3,894,909.'!5 Aug -11 3,795,607.97 3,924,541.80 (53,338.74) 76,605.09 3,971,014.84 eap -31 2,914,869.40 3,166,562.64 (58,869.90) 192,823.34 3,163,838.18 Oat -11 2,955,398.39 2,852,952.53 (45,133.69) (147,579.55) 3,016,258.63 N,11 2,643,246.46 2,544,526.70 (47,451.31) (146,171.07) 2,870,D87.56 Daa -11 2,968,917.38 2,889,822.54 (63,455.95) (143,550.79) 3,727,536.77 J. -12 3,338,331.18 3,114,395.49 (51,411.30) (275,346.99) 3,452,189.76 Fab -12 2,679,936.88 2,594,141.71 (62,465.74) (348,260.91) 2,103,938.87 Mas -12 2,585,840.21 2,644,228.46 (62,96D.97) (4,572.72) 3,099,356.15 Apr -12 2,154,739.79 2,538,368.89 (39,924.10) 333,715.00 3,433,071.15 May -12 2,098,550.90 2,344,120.24 (33,019.19) 212,550.15 2,645,631.30 WILD START G REPORT MR PIaCAi. YEAR ENDING JUNE, 2012 ACTUAL n 12 BUD TOTAL JUL 11 AUG 11 SEP 11 GC 11 GOV 11 NEC 11 JAN 12 PRS 12 NAR 12 ARE 12 MAY 12 GENERAL MANAGER MOMAN RESOURCES CONNUNITY RELATIONS TOTAL 2 1 1 4 S 1 1 4 ] 1 1 4 2 1 1 4 2 1 1 4 2 1 1 4 2 1 1 4 ] 1 1 4 ] 1 1 4 3 1 1 4 3 1 1 4 2 1 1 BUSINESS ACCOUNTING CUSTONBR SERVICE • MGM INFORMATION SYS • MISCELLANEOUS TOTAL 2.00 7.75 6.25 1 17.00 1.50 8.75 5.25 1 16.50 1.50 8.75 5.25 1 16.50 1.50 8.75 5.25 1 16.50 2.00 8.75 5.25 1 17.00 2.00 0.75 5.25 1 17 DO 5.00 6.75 5.25 1 1) 00 5.00 8.75 5.25 1 1) 00 2.00 5.75 5.25 1 17 00 2.00 8.75 6.25 1 18 00 2.00 8.75 6.25 1 18.00 5.00 8.75 6.25 18 ENOINRRRINn a OPERATIONS AM EFO ENGINEERING LINE POSTER STATION �TAL 2 5 21 4 8 40 2 5 20 4 6 39 2 5 20 4 8 39 2 5 20 4 8 39 S 5 2D 4 B 39 $ 5 20 1 8 39 3 5 20 4 E 39 2 5 21 4 7 39 2 5 21 4 7 39 S 5 21 4 ) 39 2 5 21 4 ) 39 3 5 21 4 ) 39 PROTECT GENERAL TRANSPORTATION TATIONTS TRANSPORTATION MATERIALS MGMT TOTAL 2 2 0 4 8 2 2 0 4 8 2 2 0 4 8 2 ] 4 8 2 5 4 8 2 2 4 8 5 3 4 8 2 3 4 8 2 2 4 8 5 ] 4 8 S 1 4 ) 4 RENEW SERVICES ENERGY SERVICES • TOTAL 5.5 5.5 5.5 5.5 5.5 5.5 5.5 5.5 5.5 5.5 5.5 5 5 5.5 5 5 4.5 4 5 4.S 4 5 4.5 4 5 4.5 4.5 4 5 4.5' RELD TOTAL 74.5 73 73 73 )3.5 7I 5 73 5 7] 5 72.5 73.5 72.5 72.S CONTRACTOR• UC LINE 2 x z a 2 a a z a a z a TOTAL 2 2 2 2 2 a ] 22 22 ] GR TOTAL 76.5 75 75 75 75.5 75.5 75.5 74.5 74.5 75.5 74.5 74.5 part time employee 'N pert time employee and 8 coop alUEent '^ pan time employee and a tamp • RMLD CO) June 20, 2012 Reding Municipal Light Department rtunote ravu row csxceanons 230 Ash Street P.O. Box 170 Reding, MA 01867 -0270 1h1:(781)944 -1340 Fax: (781) 942 -2409 Web: www.mdd.win Town of Reading Municipal Light Board ATTACHMENTS Subject: SCADA -Ready Capacitor Bank Controls On May 9, 2012 a bid invitation was placed as a legal notice in the Reading Chronicle requesting proposals for SCADA -Ready Capacitor Bank Controls for the Reading Municipal Light Department. An invitation to bid was entailed to the following: Power Tech (UPSC) J.F. Gray & Associates Shamrock Power Sales Hasgo Power Sales Robinson Sales E.L. Flowers & Associates Power Sales Group MetroWest Electric Sales, Inc. HD Supply Utilities HD Industrial Services Genergy WESCO Graybar Electric Company Stuart C. Irby Co. Yale Electric Supply Cooper Industries Bids were received from CG Automation, Graybar Electric Supply and Power Tech (UPSC) The bids were publicly opened and read aloud at 11:00 a.m. June 6, 2012 in the Town of Reading Municipal Light Department's Board Room, 230 Ash Street, Reading, Massachusetts. The bids were reviewed, analyzed and evaluated by the General Manager and the staff. Move that bid 2012 -46 for SCADA -Ready Capacitor Bank Controls be awarded to: Power Tech (UPSC) for a total cost of $19,683.00 Item desc. Qty Manufacturer Unit Cost Total Net Cost 1 - SCADA -Ready Capacitor Bank Controls 12 HD Electric Co. 1,640.25 19,683.00 as the lowest qualified bidder on the recommendation of the General Manager. The total Capital Budget allocation for "Distribution Automation Installation - Capacitors Banks" is $30,000. ince.0 eron Jr. - -_ -- Kee X1Iivn ^ — Peter Price File Bid / FP 1 212012 Capantnn Controls )!) ! ! CO /!. I H AI ! ! � ! ! ■|)! !f ! \ ! ! !2 - $ ! OR ! |/ ) !4 9 §! § | !■ | | # | �,... ) -20 .6 � °�� � \ \ - } Si ± : \( ) }k \\ RE RMLD ( J a June 20, 2012 Aeedieg Mmicipal Light Department eeua■�a eowea roe eeneunoxs 230 Ash Seeet P.O. Roa 150 Reading, MA 018674250 W: (781) 9441340 Fax:(781)942 -2409 Web: sysvw.tmld.com Town of Reading Municipal Light Board Subject: Licensed Site Professional (ISP) Services On June 4, 2012 a bid invitation was placed as a legal notice in the Reading Chronicle requesting proposals for Licensed Site Professional (LSP) Services for the Reading Municipal Light Department. An invitation for the request for proposal was emailed to the following: Ankiewicz Environmental Services ATC Associates Inc. Cushing, Jammallo, and Wheeler, Inc. EBI ENSOL, Inc. EnTact Solutions, Inc. Fay, Spofford & Thomdike, Inc. GEI Consultants, Inc. Geolnsight, Inc. Goldman Environmental Consultants, Inc. Lord Associates, Inc. Nobis Engineering Inc. Ransom Environmental Consultants, Inc. Sak Environmental Weston & Sampson Engineers Woodward & Curran • A bid was received from Cushing, Jammallo, and Wheeler, Inc. A no bid was received from Vineyard Engineering & Environmental Services, Inc. The bids were publicly opened and read aloud at 11:00 a.m. June 18, 2012 in the Town of Reading Municipal Light Department's Board Room, 230 Ash Sheet, Reading, Massachusetts. The bids were reviewed, analyzed and evaluated by the General Manager and the staff. Move that bid 201248 for Licensed Site Professional (LSP) Services be awarded to: Cushing, Jammallo, and Wheeler, Inc., for a three yew period beginning July 1, 2012 for an estimated cost of $27,OOD.00 per year based on a 3 year average at the rates indicated in their price proposal, as the lowest, most qualified bidder on the recommendation of the General Manager. i /7t a 1ff Nick DAlleva File: Bid /Fr12 /2012 48 LSP RFP 2012 -48 Licensed Site Professional (LSP) Services Engineering Evaluation Minimal Criteria Cushing, Jammallo & Wheeler Licensed in Mass as a hazardous Waste Site yes Cleanup professional They demonstrate the knowledge with On call, available, willing to res and 24/7 es Demonstrated 15 Min response time to initial Stated /demonstrated they could comply contact. utilities for a period of more than 5 years. Demonstrated, experience, ability to effectively yes sample and screen soil samples in the field for 85 Constitution Lane, Danvers, MA MODF 13.3 miles, 18 minutes Ma uest MODF - Mineral Oil DielectricFluid Demonstrated ability to perform soil and yes groundwater sampling, oversee soil boring contractor, perform soil characterization and oversee the installation of monitoring wells. Demonstrated ability to provide training and other yes environmental consulting services (SPCC plan) (SPCC - Spill Prevention Control and Countermeasures) Comparative Criteria Cushing, Jammallo & Wheeler Demonstrated knowledge of Mass contingency This category is 'Highly Advantageous' - Plan, emphasis on LRA, IRA, RAO, Method 1 and They demonstrate the knowledge with 3 Risk Characterizations, in furnishing services to electrical utilities in Mass, numerous MODF cleanups and they have experience with several Massachusetts utilities for a period of more than 5 years. Must have principal location to afford minimal This category is 'Highly Advantageous' response time between notification and arrival on 85 Constitution Lane, Danvers, MA site of incident. 13.3 miles, 18 minutes Ma uest Cushing, Jammallo, and Wheeler, Inc. was able to show more than five years of experience performing LSP services relating to MODF releases for electrical utilities in Massachusetts. J M }m „| ! §| || §! §( � j!§ ! .� \! aj )k ]j � �)! �)� � �(§ §\ /� !� 5iM �)§ a |l |' � §( MCI \� ) |A � ! �• !!< :!. ); !| i |A � :!. ._. June 2 and May 25 - Payables Questions June 2 and May 25 - Payables Questions Vincent Cameron Seat: Wednesday, June 06, 2012 11:51 AM ki/ To: Phil Padno; Bob Soli; Gina Snyder; Mamie West Cc: Bob Fournier; Wendy Markiewia; Steve Kaun)ian; Jeanne Fob Categorlm; Red Category Attachments: DOC.PDF (288 KB) ; Mass. Comm. Blll.pdf (16 KB) June 2, 2012 Snyder 1. Rubin Rudman - Pis have detail on NSTAR + Hydro Quebec. Page I of 3 This work was performed relating to developing the contracts for the power supply bid on May 18, 2012 and some energy conservation information. The RMLD went out for bid on May 18, 2012 and the bidders contracts have to be in place prior to going out to bid. One of the bidders was Hydro Quebec was one of the bidders. The NStar activity had to do with information on their conservation programs. 2. Nat Grid + NE Power - Are Y's switched on list? 16,485 is NE, 23,625 is NGrid. (Also noted by Commissioner West.) No, they are correct. The invoice for $16,485.43 lists New England Hydro -Trans Corp on the invoice but the instructions on the bill states "checks should be made payable to National Grid ". The invoice for $23,625.56 is from National Grid but the instructions on the invoice states that "payment by check should go to New England Power Co. ". • 3. Postage wire form Mass Communications - Where's the bill with this? Attached is the bill from Mass Communication for the postage. It will be attached to the wire. 4. HD Supply + Schweitzer - These look like the exact same equipment, w/2 bills from 2 companies for the same thing. Please explain. The Schweitzer bid was awarded in November, 2011 and the relays were purchased in December, 2012. The HD supply was bid was awarded in May and the relays were purchased in May, 2012. Two separate bids. The relay replacement work was not going to be performed at the same time do to substation maintenance scheduling, so we did two separate bids 5. Kathleen Good - Please explain. This is for a court reporter service for an union arbitration. The RMLD splits the cost with the union. 6. Healthy Air + DNS 4VAC + what the various replacement of the unit long term if replaced. The roof top units that replacement. Alpha Mechanical - Please provide an overview of all the contractors do with it. Maintenance, breakdowns versus s. I'm interested in cost of O +M whether we'd save $ in the were replaced were 17 years old and in needs of https: / /owa.rm[d.com/owa/ ?ae= Item &t = IPM. Note& id= RgAAAACOkZlrlkKLQ6uBL6Pyd... 6/19/2012 June 2 and May 25 - Payables Questions Page 2 of 3 I will get the information you requested with regard to HVAC maintenance, replacement, etc. May 25, 2012 • O'Neill 1. Bryan - Lodging listed Th /Fri on internal form; should be W /Th. Yes. The notation has been made on the forms. 2. Evans - Dates not listed on internal form. We are not able to book flights through the RMLD? We were not able to get an invoice, draw up a PO and get prior approval for conference. The dates are now on the form. The flights were paid for by the employee. There was no PO because the conference, flight, and hotel were paid for by the employee. The Engineering and Operations Manager gave prior approval for the trip and signed a travel authorization form prior to the trip. 3. Rubin and Rudman - I thought we had already paid them for DPU PowerPoint, etc. This is for work done in Jan /Feb. Please double check. There were two meetings with the Commonwealth of Massachusetts state officials. The first meeting occurred on December 12, 2012 with Bobbi Garnick Gates who is the Executive Director of was Executive Office of the Energy and Environmental Affairs (EOEEA). The RMLD, Braintree Electric Light Department (BELD), and Energy New England (ENE) set up a meeting through Rubin and Rudman to present the three systems energy conservation and renewable energy programs. The three systems wanted to also obtain some insight as to how the EOEEA viewed municipals with respect to energy • conservation and renewable energy. The RMLD paid $1,500 for Rubin and Rudman•s role in setting up the meeting and discussing the presentation content. The meeting was very worthwhile in educating Ms. Garnick Gates where the municipal sector is with respect to energy conservation and renewable energy programs. The Mass. Department of Public Utilities (MDPU) Commissioners, upon hearing about our meeting with Ms. Garnick Gates, asked the RMLD, GELD, and ENE to attend a meeting with them to discuss our energy conservation and renewable energy programs and also discuss the municipalization bill. We were surprised that the MDPU asked us to come before them, which was a signal that they are very interested in the content of the information we provided. This MDPU meeting created a good amount of up front work by Rubin and Rudman work to ensure that our presentation and message to the MDPU Commissioners was appropriate. The meeting took place on February 14, 2012 and lasted for about an hour and fifteen minutes. The meeting was very informative for the MDPU Commissioners and they asked many probing questions about our energy conservation and renewable energy activities. They also asked some very direct questions relating to the municipalization bill. I reported on these meetings at the February Board meetings. In researching this issue I noticed that I wrote on the first Rubin and Rudman Meeting invoice "meeting with Mass DPU Commissioners ". This was incorrect and should been noted as "meeting with EOEEA ". My error. 4. Please provide a copy of the PowerPoint mentioned in Rubin a Rudman invoice. • It is attached. Page 3 of 3 - Is Blank https: / /owa. nnid.com/owa/ ?ae= ltcm &t =IPM. Note &id= RgAAAACOkZlrlkKLQ6uB L6Pyd... 6/19/2012 0 IMM H ♦♦w^^ V♦ T� w Q cn Q Z Q J a V J J Q a V Z -0 co L co w L Co a, �w 70 N N (1) Z� L C c: o— U- :3CU 0.0— o)o N 0 �o 2w Irl- N co �i 3 a� O O c 0 U 0 c L 3 ^O LL O a 0 4- a) c m m (n CD c� C c a) u . . . . . . U N Q a) Y L R1 2 C a) a) L cu 0 L () O a U) o Lj 0 a� 0 � � J CD E O L LL O a) O 0 . . N IWO a 0 J J W � O +.. C a) IoW o�w J "0 J � U � Q � W N c w O) Z cu aa) 0 c m ir w (n CD c� C c a) u . . . . . . U N Q a) Y L R1 2 C a) a) L cu 0 L () O a U) o Lj 0 a� 0 � � J CD E O L LL O a) O 0 . . N IWO a E c� a � � p ca _rZ i C U t � w O J O L C E Lm (0 m C O °' w � E U c� C co p c a� O J C - - U U) C 'E m O C E � cv L � U ' O � E C U C U C 0 (6 I rm- m L .2 a a � o -o aic Co 3 >, C c U C a) c0 @ .L.- -0 a) 7 E cL C L Y U E L �3� O .� > U co uj O O U = C '0 Q) w >1 - O L ` c a N O (0 C c uci 'OO.�E° CL - mo N Y c0 � c @ L c E o M o 0) m m2 > Q) o a m '> 3 ns U c "0 c .0 C aNi 70 C 0 Co N c cu " ac9 m U 7 U) 3 C o Cl a� a) — (1) c w v`>i o 0 .a U N c6 c6 E U C C cn a) m 0 ao a) 7 E C U =:.. cu =T oTm a) U E a a) U O 0 CL T to O_ O •U > C > -N () a) U 'E N C a) .O p. O) O .= c 0) N U P O N O �� ..-� voi L ccn Of m voi (j �l cLQ 3 0 J 0 M .r✓ 'i1 a+ s V W L .F� LO O O O O N c0 O c L to N j m N O co N N ch U O E C r O N N E o C r i Q 0 O y "J N CSI r : "-• N O co CD U Z -0 N N V "O "c cu N cn m -C fA O O U Q Q N O -0 . -p J F- cn � fl- c0 (� � m N w Z O O O m a� wol -0 LO c O Cl) c 3: D J - 1.00, �w � ¥ k k a) /c / � � ± E / c / k 0 / ƒ m f o E 2 b m = 0 3 § f 2 \ 2 s � ) q o \�� C m /% cu 7/f 7� //$ § a (v m E E 0 c cu C 0 5 a) 2 0 6 q > § / g o c M M = 3 E C 7 4)m2c @� 3 a) 2 f 2m =3o 0a) -1\0- o2gmw �: - 1.00, �w � ¥ /c \ \/f / I @ / ° 0 .7 ° m 2 § �. U) E \�� /% \2 //$ U) (v 0 / E 0 C 0 m 6 0 = CL 3 c o c ® @� EE 2m =3o o2gmw 22 2 2E E t - E qk��f � a " =3 / C 2 (D (D (n #Zm @$ - 1.00, �w It V NE r a.+ D W m O U > co -0-0 O a p aOf J (v cn — >, U- L CL a� cU E 0 o c`a °� uj — c cn >% w. EQ E ° o M Z o c 0) ` O 00 cZ E o E m IoW E C m o E E 0) NN W cn o 00 (� V Q) a) M Cu Ld (6 (n cn W _ O 0 E o 0 3} E 0 m a,o O M cn o � 00 � ;~ o O a2i 'Wd L- C o o ICON — 3 O 0 4-- cn a ca O f0 7 p o V o 3 O •V J O N p O J (0 _ O _c C . (1) > of cu 0 � �c ��� :3 0 _ / U) @c6 E13 / �� ko� °' ca m ��9�j Oc�E c §�® 2222 - cmE -o °a %ƒ 0 2 'cn cu 0 $ e e U 7 CL _ @ \� O 7 2U m[E.§CO �.22a- 0/_ jCo .g @ c D �R� o w p§= -C 75 /EE% -ƒ 3 2 2' C) \ � L Wb N d 7 W a c 3 0 v Y A ca {0 v a J M «d V d 0 L a N 0 J W m �iifflF I Y W � u 3i r° J r•� C d L W J G co O rn a� C _U Co N � N _ N 00 C J O Of r O ZC U) a o a) O � C O 00 O� r m C_ _� O O O = O. cn C �' CD -0 O C L W O 0 Z 6 _C C L E'- E cn O U U_ L cQ N U U -o I� r _ O O O C c O >, J 00 M E N N O _C O � Y cu cu U) of P1 (n _O L N O C co L 0 C O w N C O U N N ca Of • • • irwI L C O E 0) rn m a� cu r O N L N O U O T O O O f!3 i cl N co c6 O T- EF? Z O O r Q U) Z 0 Iftw ./ & £ ) /\ j _ % i q , § > } 0 \ >1 \ ; e / ( e \ / ) T ¥ { \ D § t \ \ § 0 M $ k \ }/ &c ! J $ @ \ 2 4 I\ @\ 0 a. U) \£ ; _ _0 §) c ) 0` %4 $ { \§`2 <I /% 7 3 }[ @ - -// 0- 0 0 }@ \k : //) ��2\�( = f — r m %\ \»t0)E:3 D /E / c / ƒ n 7 7a m 'u -- ,072%%0 /E } / \ \ \ \ \ k ( k } \ \ § \0CU 0/§=2\ cn 2) § >,,,,, =I °�@� « u @ 0 0 _ V L L O O O N 69 O m 0 m 0 C m N f6 .a N a) U c m Q CL m m .c a� N 0 0 co V a) 9 u Ln 0 0 N a) U C N L a) E 0 N 7 U m E E U a a) (n c 0 V co T 2) a) N (0 C ` O O C EN a O N U C -0 O C co E (o 0 c N (6 ` co O �O O .N N v a) .O o oa- t >, o � Q) U c C a) 2 v.0 m 3 U � �C: o � U C 0 c m E E N 6 9 N U 0 b LO 0 C) N a) U C N co U L O c (o 0 (C) N N Wo K.. U co L O N LO O n O N N O EN OL w 0) o N -C W C N.0 E E C O (n (0 Cl) N Val U O O a) U_ m `o>')> C C wU) m a O Z ca C C 'j (D O (n a N >N cu (`0 O a O W 0 O w C N m O O 0 LO m m O tea` a 0 3 C a3 O TU C C U N �S N .w J J E 0 a w C w m y.r a C 0 N N as c� o c � U O L N C 3 0 a cu Ac W L V 3 21 Q c J :o Y 0 0 cu C 7 O LL t (6 0] c is c m A H L Q) C -C 0) CO E L C O p > a E c� O (D d m LiC) -bS >�: J C i > Q L O N E U O X lw N O O E N cm N C cn .� 30 +�-� >, -C O %C-13 C U c o E U'u - mc� J p — � U) � o --c p cn i% X Q x c O .r/ a m _0 N N cn C N O :3 N N QZ O U c0 O C 0 UCO,C w Lp .n E N p C: cu ` O i- In L N O N >% 5) E N c2 C i E U O O + N 3 0= U� o tvr ' SE CD fin a� c �o > >, E UCU O o° m0-pccu L � ti _0 � - > N L -0 � O E O N ca O O � � W U U (0 'C o (� C i o N N j cn O O U -p — N +r N (n i C U) 0) cu c .N.N O1O W> 0) C C c c W� C U ._ W�Wa�0�WOEa) W W w N I'II N L Y O` ., O a c c c c N �.O cc Oc E+= m C N C . m N N c O Ol C C N N a '0 N c N m C O) N C m _7 N m c ° Co O U N C Y E U � o N N C � N N w E > 7 N C C O E m � N N C a > > m OLL N.E N N N -O _ t O m n U O N C d p N O O N N m U 0 W U > T N U CM a N a c •� vi a> w L O c 3 N L N 0).W Y O C �� as OL CL U Q N C N U N cm ao U E L) O N 07 C N N N co a) N O y U N CL F N N N NO N c C N U N O.0 O) U m W� .-� C: L N m L > 3 N 3 > _O cu E � m Co J U aQm H N C a N C .0 c - _m Q f0 U O) L p 'C cu cu �p o C N U a .N M c a �aa) >o � N — C: -a Co -C 7 N (L C: N J m N LO N 3 ~ N � f0 N O U O d N 7 CL O_L U C c 0 N a 0 $ m c an N C c N a -0 c c o N N C c o m U o > 0) o 0 a) U 2 c x N N N NO N c C N U N O.0 O) U m W� .-� C: L N m L > 3 N 3 > _O cu E � m Co J U aQm H N C a N C .0 c - _m Q f0 U O) L p 'C cu cu �p o C N U a .N M c a �aa) >o � N — C: -a Co -C 7 N (L C: N J m N LO N 3 ~ N � f0 N O U O d N 7 CL O_L U C ,W,` L 4) T C W 0 0 c0 N O m N @ n C C C_ 'O CD = 0 0) @ U U 7 a) E 4 L C a) '0 i0 N a)t-. N O t 3 O) C O C U ._. U O o`Ti c� @ u C 3 0 3 ci CL c aci Q c Q >, o f6 N 0) O 'D a) cco o I m m CD C L C X `C' w a) C N N N O S C (V U C V 0 C O) -o O a) 'C a) , o a' .O Co C O L a . U 00 O a) " L (0 (9 ` > E Co 0 N a C 0 C U f0 N O T E O _O N r U •a) O) C Y o O m i w ` >. > L V) `0) c0 a) � N N 0 N U -0 j O C Q) (a ' V) O. U a) m (V L OU f0 3 N C •y 0 U C c (n o 3 m a) O aka) rnM=OU 0 V) Q Q) a) ) C 3 .0 a) U) c a) a o c 'c Y U) :3 >c °Q omLa t v aCi U N c 3 a) c w y �i)E 0022. -Lm w U 'O w N T L)� o m W r- W E Z'` c Z; cu 2 Z Z O W aco w�5a 2a2w5w-a U) L O yyU_..�.. N O N m � ui Z O 0 C C C U cn C cu — +, a) O U C 3 � O Q �. c CU C N O O) (D U) E C a)-0 U) m N co L L a) cu 3 C�� 0 O O O Q 3lu M C Q 0- � OC- cp 4— 4�- O -p Co _ +_ U C a cu N C C ��' cn N C N O � -C .O O U) CIO N N ( O > Co O L •— -C C _O (B L C Q> 0)-- � �� U Y C co •— U C .� N U _C C .. (n N= N cn cD C p to O U >EC�2 6 MASS Communications, Inc. 50 Jy1ek Road LeombAter MA 014505988 Invoice for Postage Phone'. (9]0) 8409880 Fae: (9]8) 840.1811 Attn Reading Municipal Light Department Job Name: RMLD Monthly Postage Prepay Reading Municipal Light Department Invokes 22166 CwCode: WILD 230 Ash Street P.O. Box 150 Invoice Date: 5/4/2012 Reading MA 01867 -0250 POs: Job Number: 22166 Project: RMLD Monthly Postage Prepay Postage Due In: 61112012 Postage Affixed: Meter Drop Date: Postage Amount: $10,250.00 Expected Qty.: 29,000 Special Instructions: It you are meiikg m our permit account, pkaae make your the payabb to MAss coMmumcallow Inc. Pleeu in cafe w your cnaa memo or deunpow and that tN8 check is to, 'Postage Pre- paymm' Include a phol.opy of Ihh imuiee vAth your peymem L Account Payable Questions - June 8 Account Payable Questions - June 8 Vincent Cameron Set: Tuesday, June 12, 2012 7:47 AM To: Phil Pacino; Bob Sall; Gina Snyder; Marsle West CC.. Bob Fournle; Steve Ka:anllan; Wendy Marldelli Jeanne Fob Categorlas: Red Category Snyder 1. Wm Crowley - Please provide details. Attorney Mr. Crowley has a practice in Reading. He handles the RMLD's legal matters with respect to pole damage (vehicles) and theft of electricity. 2. Wilmington Chamber -What is our annual budget for Chamber /Rotary type of payments? Page 1 of I The RMLD's annual budget in FY12 for Chamber, Rotary, MEAM, and Public Relations Society activities is $5,565. https: / ,'owa.rmid.com /owa/ ?ae= Item &t =IPM. Note &id= RgAAAACOkZlrlkKLQ6uBL6Pyd... 6/12/2012 • • r, L J Account Payable Questions - June 15 Vincent Cameron Sent: Tuesday, June 19, 2012 10:59 AM To: Phil Pacino; Bob Soil; Gina Snyder; Mande West Cc: Bob Fournier; Steve Kazan)lan; Wendy Markiewkz; Jeanne FoU Categories: Red Category Snyder 1. Century Bank - Why these bank charges with the new service online? These credit card charges are for the payments we take at the counter, which do not presently go through Invoice Cloud. We plan on switching the counter payments over to Invoice Cloud soon. 2. HT Berry -Ship 5/25 PO 6/8 need to strongly remind people that PO should be done upfront (This is = an emergency purchase!) Yes, I will reinforce with staff. 3. Reading Police - Holmes blue slip 1 pm - 2:30 pm charged 8 hours. (Note Pico also but his slip is 8 am to 2 pm for the 8 hours) What was the circumstances? There were two slips for Holmes. The first slip shows the detail on Main Street, Reading from 1 pm to 2:30 pm. The second slip showed the detail on Main, Minot and Lincoln streets from 8 am to 1 pm. The details were on two different slips because they were for two different work orders. 4. Survalent - Did this come in under budget or are there additional purchases if so please have details on PO. The remaining balance on the PO ($29k) is for installation, programming, and training provided by Survalent. I will have that noted on the PO. https: / /owa.mld.com/owa/ ?ae ltem &t =1PM. Note &id= RgAAAACOkZirlkKLQ6uBL6Pyd... 6/19/2012 HVAC Maintenace versus Replacement Explanation Page I of I HVAC Maintenace versus Replacement Explanation Vincent Cameron Sent: Tuesday, June 19, 2012 1:19 PM • To: Phil Padno; Bob Soli; Gina Snyder; Mamie West Cc: Bob Fournier; Steve Kazan)lan; Wendy Markiewki; Jeanne Fob Categorlee: Red Category Attachments: HVAC Clarlaratbn.dac (29 KB) ; Exhibit A_20100.05 HVAC PM -Lxls (67 KB) Included in the June 2 payable questions was the following; Question 6.. Healthy Air + DNS Alpha Mechanical - Please provide an overview of all the HVAC + what the various contractors do with it Maintenance, breakdowns versus replacement of the units. I'm interested in cost of O +M whether we'd save $ in the long term if replaced. Answer The roof top units that were replaced were 17 years old and in need of replacement. I will get the information you requested with regard to HVAC maintenance, replacement, etc. Please see the attachments for the background info on the maintenance versus replacement you requested. E L� https: / /owa.rmid.com /owa/ ?ae= Item &t =1 PM. Note& id= Rg.AAAACOkZlrlkKLQ6uBL6Pyd... 6/19/2012 DNS LLC DBA Aloha Mechanical Services In January 2010 DNS LLC DBA Alpha Mechanical Services was awarded bid 2010 -05 HVAC Maintenance and Repair Services. This is a 3 year contract. Under this contract Alpha Mechanical provides PM services (see attached schedule) and repair services as needed. The RMLD can at any time obtain quotes from other vendors if a repair cost is more than $5,000. HealthvAir Solutions In March 2012 HeaithyAir Solutions was awarded bid 2012 -36 for the replacement of two 7.5 ton RTU's. Monies Invested From September 2010 to the end of 2011 the RMLD has spent approximately $7,724.00 in repairing these three RTUs. This was only to keep them going the aging units repairs were being put on hold and band aids put in place while it was being decided what to do. Replacement of 5 ton RTU In September of 2010 the 5 ton RTU continued to have cooling issues endangering the RMLD servers. Since this unit was original to the building and parts were becoming obsolete and sometimes unobtainable the RMLD was considering replacing the unit. In January 2011 it was realized that due to uneven cooling, mismatched loads, conflicting controls and Q poor air distribution the Bryant unit that feeds the Computer Server and Mail Rooms would have to be replaced. These two areas are very critical to the operation of the RMLD and are served by this one 5 ton unit. In March of 2011 the unit was replaced by Alpha Mechanical. The Bryant 558DEX060000AAAA, 5 ton RTU was replaced with one Carrier 50TCA06A2A6AOAOAO, 5 ton RTU for a cost of $7,460.00. Replacement of two 7.5 ton RTUs The remaining two 7.5 ton RTU's also original to the building were in much more severe condition. The units suffered from worn and stripped gears, economizers not operating properly, one unit had the heat exchangers rotting out and compressors rapping. Again with parts either obsolete or unobtainable (band aids were no longer working) it was decided that the RMLD could only benefit by replacing the two 7.5 ton units the Bryant 558DEX090000ABMA was replaced with one Carrier SOHCD08A2A6- OAOAO; which cools the mezzanine area (electric and telephone rooms need to be cooled) and Bryant 5BODEV09012SABMA was replaced with one Carrier 48HCED08A2A6- OAOAO; which heats and cools the Meter Department for a total cost of $19,600.00 and one change order $1,245.00 for replacement of gas shutoff valve for the 48HC unit and low ambient controls for the 50HC unit for a total of $20,845.00. After being awarded the bid both units were replaced by HealthyAir Solutions. CIS' 0 e 9 a u i. ! I . t. N! jj' i,� � Ji li�j'jj'j!'ti��l �• i�1j� jdjj• 1 ;f�? jj• 1. ff•ij•�!• !. t• j�i 4 ll.11.il• 4 I• 1 ii !` � fill 1 I =l lid 9 i. �i s 6 ►l,�l.il•i�� j t•il, A A ll l� J e 7 0 e 9 a u � I � 0 | d!! ! ) � g�• � !� . viii •� •� •! • i � . [q �l I HE § i � §$t q $ :! �: ]! `; |i� !,`! -- ., � |• i| } m |is i ejill � \ d � � 0 !| !| || !| !! !| ! � !| |. ' ' •| !| !| ! ; •' $ : � ) . / . $ . !| ` x , § t m, m W •:— ` � �! - - �! • ! � ƒ / !, - }� � !` 2 _ d � � 0