Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2013-03-27 RMLD Board of Commissioners Packet
• To: Vincent Cameron From: Energy Services Date: March 21, 2013 Subject: Purchase Power Summary - January, 2013 Energy Services Division (ESD) has completed the Purchase Power Summary for the month of January, 2013. ENERGY The RMLD's total metered load for the month was 60,727,318 kWh, which is a 2.1% increase from the January, 2012 figures. Table I is a breakdown by source of the energy purchases. TABLE t Amount of Cost of % of Total Total $ $ as a ® Resource Energy Energy Energy Costs % (kWh) ($IMwh) Millstone p3 3,713,509 $6.99 6,10% $25,948 1.03% Seabrook 5.897,256 $8.20 9.69% $48,365 1,92% Stonybrook Intermediate 3,503,224 $10837 5.76% $379.658 1505% JP Morgan 9,354,800 $58.55 15.37% $547,677 21.71% NextEra 9,502,000 $69.51 15.61% $660.453 26.18% NYPA 1,940,647 $4.92 3.19% $9,547 038% ISO Interchange 3,641,386 $59.95 5.82% $212,291 8.41% NEMA Congestion 0 $0.00 0.00% - $658,628 - 26.10% Coop Resales 122,685 $110.90 0.20% $13,606 0.54% Maccuane 9,200,000 $38.41 15.12% $353,349 14.00% Summit Hydro 994,950 $5561 1.63% $55,332 2.19% Braintree Watson Unit 481,029 $129.32 0.79% $62,208 2.47% Swift River Projects 1,529,467 $99.78 2.51% $152,613 6.05% Constellation Energy 11,048.400 $59.21 18.15% $654,143 25.93% Stonybrook Peaking 37,315 $176.97 0.06% $6.603 0.26% Monthly Total 60,866.668 $41.45 100.00% $2,523,167 100.00% • ATTACHMENT t Table 2 breaks down the ISO interchange between the DA LMP Settlement and the RT • Net Energy for the month of January, 2013. Table 2 Amount Cost %of Total Resource of Energy of Energy Energy (kWh) ($ /Mwh) ISO DA LMP • 6,320,346 85.31 10.38% Settlement RT Net Energy " - 2,778,961 74.34 -4.57% Settlement ISO Interchange 3,541,386 59.95 5.82°/ (subtotal) Independent System Operator Day -Ahead Locational Marginal Price Real Time Net Energy CAPACITY The RMLD hit a demand of 108,799 kW, which occurred on January 23, at 7 pm. The RMLD's monthly UCAP requirement for January, 2013 was 211,827 Ms. Table 3 shows the sources of capacity that the RMLD utilized to meet its requirements. • Table 3 Source Amount (kWs) Cost ($NWT month) Total Cost $ %of Total Cost Millstone #3 4,991 46.21 $230,645 15.41% Seabrook 7,742 49.44 $382,780 25.57% Stonybrook Peaking 24,981 2.00 $49,926 3.34% Stonybrook CC 42,925 3.85 $165,129 11.03% NYPA 4,019 3.57 $14,347 0.96% Hydro Quebec 4,584 4.70 $21,550 1.44% Nesters 60,000 5.50 $330,000 22.04% Braintree Watson Unit 10,520 11.01 $115,836 7.74% ISO -NE Supply Auction 52,065 3.59 $186,771 12.48% Total 211,827 $7.07 $1,496,984 100.00% • RENEWABLE ENERGY CERTIFICATES (RECs) The RMLD sold 12,613 2012 RECs (Quarter 1 and Quarter 2) for $582,097.75 in January, 2013. 750 Quarter 1 and 2 RECs remain banked for retirement. Table 5 shows the amount of banked and projected RECs for the Swift River Hydro Projects through January, 2013, as well as their estimated market value. Table 4 shows the dollar amounts for energy and capacity per source. Table 5 Table 4 Swift River RECs Summary Cost of Period - January 2012 - January 2013 % of Amt of Energy Power Resource Energy Capacity Total cost Total Cost (kWh) ( $/kWh) 1,465 Millstone #3 $25,948 $230,645 $256,594 6.38% 3,713,509 110691 Indian Rives Seabrook $48,365 $382,780 $431.145 10.72% 5,897,256 0.0731 751 $a Stan,brook Intermediate $379,658 $165,129 $5"787 13.55% 3,503,224 0.1555 Hydro Ouebec $0 $21,550 $21,550 0.54% - amoo JP Morgan $547,677 $0 $547,677 13.62% 9,354,800 0.0585 Ne %tba $660.453 $330,000 $990.453 24.64% 9,502,000 0.1042 a NYPA $9,54] $14,347 $23,894 0.59% 1,940,647 0.0123 ISO Interchange $212,291 $186,771 $399.062 9.93% 3,541,386 0.1127 Name Congestion - $658.628 $0 - $658,628 - 16.38% - 0.0000 MacOuane $353,349 $0 $353,349 8.79% 9200,000 0.(X384 a Summit Hytlro $55,332 $0 $55,332 1.38% 994,950 0.0556 Braintree Watson Unit $62.208 $115,836 $178,0" 4.43% 481,029 0.3701 e Swift Riser Projects $152,613 $0 $152,613 3.80% 1,529,467 0.0998 Coop Resales $13,606 $0 $13,606 0.34% 122,685 0.1109 Consteoation Energy $654,143 $0 $654,143 16.27% 11,048,400 0.0592 Stonybrook Peaking $6,603 $49,926 $56,530 1.41% 37,315 1.5149 Monthly Total $2,523,167 $1,496,984 $4,020,150 100.00% 60.866,668 0.0660 ® Renewable Resources 7.34% RENEWABLE ENERGY CERTIFICATES (RECs) The RMLD sold 12,613 2012 RECs (Quarter 1 and Quarter 2) for $582,097.75 in January, 2013. 750 Quarter 1 and 2 RECs remain banked for retirement. Table 5 shows the amount of banked and projected RECs for the Swift River Hydro Projects through January, 2013, as well as their estimated market value. Table 5 Swift River RECs Summary Period - January 2012 - January 2013 Banked Projected Total Est. RECS RECs RECS Oollan Worenoco 394 1,465 1,859 $67,390 Pepperell 384 0 384 $20,352 Indian Rives 92 737 829 $39,061 Turners falls 751 0 751 $a Grand Total 1,621 2,202 3,823 $126,803 The RMLD's total transmission costs for the month of January were $774,307. This is an increase of 4.8% from the December transmission cost of $738,628. In January, 2012 the transmission costs were $638,899. Table 6 r11 r2L • Current Month Last Month Last Year Peak Demand (kW) 108,799 108,921 106,558 Energy (kWh) 60,866.668 59,364,911 59,550,250 Energy ($) $2,523,167 $2,868,713 $3,338,331 Capacity (S) $1,496,984 $1,528,363 $1,337,348 Transmission ($) $774,307 $738,628 $638,899 Total $4.794,458 $5,135,703 $5,314,578 r11 r2L • Total System Projects Station Upgrades Station #4 8 Relay Replacement Project - (Partial CARRYOVER) R 9 Station 4 Getaway Replacement -4W13 R Total Station Projects SCADA Projects 10 Station 5 RTU (Remote Terminal Unit) Replacement W 4 Station 4 RTU (Remote Terminal Unit) Replacement (Partial CARRYOVER) R Total SCADA Projects New Customer Service Connections 12 Service Installations- CommerciaVlnduslrial Customers ALL 13 Service Installations- Residential Customers ALL Total Service Connections 14 Routine Construction Various Routine Contruction ALL Total Construction Projects Other Projects 15 GIS 16 TransformersrCapacitors Annual Purchases 17A Meter Annual Purchases 17B Meter Upgrade Project - (Partial CARRYOVER) 17C Meter Upgrade Project- Commercials 18 Purchase Vehicles 19 Purchase Line Department Vehicles 20 Purchase New Pole Dally 21 Automated Building Systems 22 Engineering Analysis software 8 data conversion - (CARRYOVER) 23 Gaw Station Generator 24 Capital Repairs - Station One 25 New Carpeting 26 Water Heater Demand Response Technology 27 Hardware Upgrades 28 Software and Licensing TOTAL FY 13 CAPITAL PROJECT EXPENDITURES Q Total Other Projects 119,309 119.309 4,430 161,779 157,349 56,163 56,163 148,680 80,653 (68,235) 6,574 63,074 56,500 17,012 152,416 207,923 55,507 80,346 3121/2013 READING MUNICIPAL LIGHT DEPARTMENT 968,211 (223,860) 347,396 284,000 2:08 PM FY 13 CAPITAL BUDGET VARIANCE REPORT 54,141 159,863 (4,431) 1,844,905 2,929,910 FOR PERIOD ENDING FEBRUARY 28, 2013 88,862 3,733 420,802 551,853 131,051 65,000 65,000 474,861 ACTUAL YTD ACTUAL ANNUAL 12.000 12,600 COST COST BUDGET REMAINING p PROJECT DESCRIPTION TOWN FEBRUARY THRU V28113 AMOUNT BALANCE 55,000 E80 Construction - System Projects 400,000 400,000 1 Essex Street - Reconductorirg LC 200 197,855 197,655 2 4W13 OH Reconductoring - West Street W 319 14,608 188,193 173,585 3 Upgrading of Old Lynnfield Center URDS (Partial CARRYOVER) LC 266 121,554 492,143 370,589 5 Shady Lane Area - Reconductoring W 30,953 95,677 199,042 103,365 6 Federal Street - Reconductoring W 30,966 88,486 175,565 87,079 Total System Projects Station Upgrades Station #4 8 Relay Replacement Project - (Partial CARRYOVER) R 9 Station 4 Getaway Replacement -4W13 R Total Station Projects SCADA Projects 10 Station 5 RTU (Remote Terminal Unit) Replacement W 4 Station 4 RTU (Remote Terminal Unit) Replacement (Partial CARRYOVER) R Total SCADA Projects New Customer Service Connections 12 Service Installations- CommerciaVlnduslrial Customers ALL 13 Service Installations- Residential Customers ALL Total Service Connections 14 Routine Construction Various Routine Contruction ALL Total Construction Projects Other Projects 15 GIS 16 TransformersrCapacitors Annual Purchases 17A Meter Annual Purchases 17B Meter Upgrade Project - (Partial CARRYOVER) 17C Meter Upgrade Project- Commercials 18 Purchase Vehicles 19 Purchase Line Department Vehicles 20 Purchase New Pole Dally 21 Automated Building Systems 22 Engineering Analysis software 8 data conversion - (CARRYOVER) 23 Gaw Station Generator 24 Capital Repairs - Station One 25 New Carpeting 26 Water Heater Demand Response Technology 27 Hardware Upgrades 28 Software and Licensing TOTAL FY 13 CAPITAL PROJECT EXPENDITURES Q Total Other Projects 119,309 119.309 4,430 161,779 157,349 56,163 56,163 148,680 80,653 (68,235) 6,574 63,074 56,500 17,012 152,416 207,923 55,507 80,346 62,762 1,212,071 968,211 (223,860) 347,396 284,000 (63,396) 54,141 159,863 (4,431) 1,844,905 2,929,910 1,085,006 5,941 62,762 97,495 34,733 101,062 347,396 284,000 (63,396) 54,141 49,710 (4,431) 11,626 475,553 564,416 88,862 3,733 420,802 551,853 131,051 65,000 65,000 474,861 570,000 95,139 12.000 12,600 150,000 150,000 76,789 76,789 55,000 55,000 400,000 400,000 35,000 35.000 190,614 336,611 145,997 8,827 73,184 126,629 53,445 79,315 119,002 39,687 131,190 2,178,628 3,493,506 1,314,877 291,053 4,023,533 6423416 2,399,883 ATTACHMENT 2 [l \ § 0 0 \ §/ .| K!!lEf, \\ §! §« ;K§■■ §r !; ...... § i \} \\ )\!} r §!m,lK !| .\ !/ ....... Mi I . ;E 9 k| \ } } \ \ \\ §/ .| K!!lEf, ;K§■■ §r !; ...... r §!m,lK !| .\ !/ ....... Mi I . ;E 9 k| \ } } \ \ \\ Reading Municipal Light Department Engineering and Operations Monthly Report February 2013 FY 2013 Capital Plan E &O Construction - System Proiecfs 1 Reconductoring of Essex Street, Lynnfield Center - No Activity. 2 4W13 OH Reconductoring Project, West Street, Wilmington - Engineering Labor. 3 Upgrading of Old Lynnfield Center URDs - (Phase 1 Completed). Engineering Labor: work on specifications for Phase 2. 5 Shady Lane Drive Area, Wilmington - Reconductoring - Line Department., make ready work. Install poles, and primary and secondary cable, and upgrade transformers. Energized new secondaries. 6 Federal Street, Wilmington - Reconductoring - Line Department. Pole framing and wiring for reconductoring. Primary wire pull for salt shed. Transfer UG subdivision into new primary. Station Upgrades 8 Station 4 Relay Replacement Project - Reading - No Activity. 9 Station 4 Getaway Replacement - 4W13 — No Activity. SCADA Proiecfs 10 Station 5 RTU Replacement, Wilmington — No Activity. 4 Station 4 RTU Replacement — 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 replacements /installations, primary or secondary cable replacements/installations, etc. This portion of the project comes under routine construction. No Activity. March 21, 2013 Ofd D i1 L • 13 Service Installations - Residential Customers - This item includes new or upgraded overhead and underground services, temporary overhead services, and large underground development. Routine Construction: 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 Seftin ranters $251,503 Maintenance Overhead/Underground $267,476 Projects Assigned as Required $234,484 Pole Damage includes knockdowns some reimbursable $70,837 Station Group $14,199 Hazmat/Oil Spills $727 Porcelain Cutout Replacement Program $0 Lighting Street Light Connections $17,976 Storm Trouble $132,804 Underground Subdivisions $43,914 Animal Guard Installation $31,440 Miscellaneous Capital Costs $146,710 TOTAL $1,212,071 'In the month of February, zero (0) cutouts were charged under this program. Approximately 22 cutouts were installed new or replaced because of damage making a total of 22 cutouts replaced this month. March 21, 2013 0 0 0 Reliability Report ® Two key industry standard metrics have been identified to enable the RMLD to measure and track system reliability. A rolling 12 -month view is being used for the purposes of this report. Customer Average Interruption Duration Index (CAIDI) measures how quickly the RMLD restores power to customers when their power goes out. aqn L E CAIDI = Total of Customer Interruption Duration for the Month in Minutes +Total Number of Customers Interrupted. RMLD 12 -month system average outage duration: 65.34 minutes RMLD four -year average outage (2006- 2009): 50.98 minutes per outage On average, RMLD customers that experience an outage are restored in 65.34 minutes. 1ao.7z 120.00 88.89 78.30 78.82 w a 100.00 C_ 71 M 80.00 d � 60.00 O E 4000 0 20.00 0.00 .A�ry ,�r�ti O )of )3v P�f yO � cWs O" 19 110 �- Mm"" minutes per wlage — • RMLD 12 month system average Wage duration 65.31 RMLD / year avere Dote duretian 50-98 2006 -2009 1ao.7z 88.89 78.30 78.82 March 21, 2013 3 0 0 Q System Average Interruption Frequency (SAIFI) — Measures how many outages each customer experiences per year on average. SAIFI = Total Number of Customers Interrupted +Total Number of Customers RMLD 12 -month system average: 0.29 outages per year RMLD four -year average outage frequency: 0.62 The graph below tracks the month -by -month SAIFI performance. F'al • �r�A �A D� '� Olp Y Qo �— FOLD monthly outage frequency • RMLD 12 month system average outage frequency.29 RhLD 4 year average outage frequency .62 (2008-2012) Months Between Interruptions (MBTI) Another view of the SAIFI data is the number of months RMLD customers have no interruptions. At this time, the average RMLD customer experiences an outage approximately every 41.4 months. March 21, 2013 4 0.80 0.70 • 0.60 c e 0.50 c 0.40 • c 0.30 I° u. 0.20 ® 0.10 0.00 • �r�A �A D� '� Olp Y Qo �— FOLD monthly outage frequency • RMLD 12 month system average outage frequency.29 RhLD 4 year average outage frequency .62 (2008-2012) Months Between Interruptions (MBTI) Another view of the SAIFI data is the number of months RMLD customers have no interruptions. At this time, the average RMLD customer experiences an outage approximately every 41.4 months. March 21, 2013 4 E E • Dt: March 13, 2013 To: RMLB, Kevin Sullivan., Jeanne Foti Fr: Bob Fournier Sj: January 31, 2013 Report The results for the first seven months ending January 31, 2013, for the fiscal year 2013 will be summarized in the following paragraphs. 1) Change in Net Assets: (Page 3A) For the month of January, the net income or the positive change in net assets was $615,841, increasing the year to date net income to $2,305,881. The year to date budgeted net income was $1,300,120, resulting in net income being over budget by $1,005,761 or 77.4 %. Actual year to dale fuel revenue exceeded fuel expenses by $184,558. 2) Revenues: (Page 11 B) Year to date base revenues were under budget by $1,226,115 or 4.27 %. Actual base revenues were $27.4 million compared to the budgeted amount of $28.6 million. 3) Expenses: (Page 12A) *Year to date purchased power base expense was under budget by $1,321,494 or 7.31 %. Actual purchased power base costs were $16.7 million compared to the budgeted amount of $18.0 million. *Year to date operating and maintenance (O &M) expenses combined were over budget by $120,292 or 1.68°/x. Actual O &M expenses were $7.3 million compared to the budgeted amount of $7.1 million. *Depreciation expense and voluntary payments to the Towns were on budget. 4) Cash: (Page 9) *Operating Fund was at $11,243,242. • Capital Fund balance was at $3,043,039. • Rate Stabilization Fund was at $6,687,657. • Deferred Fuel Fund was at $2,454,602. • Energy Conservation Fund was at $228,018. 5) General Information: Year to date kwh sales (Page 5) were 423.859,725 which is 4.4 million kwh or 1.06°/x, ahead last year's actual figure. GAW revenues collected ytd were • $423,744 bringing the total collected since inception to $1,720,828. 6) Budget Variance: Cumulatively, the five divisions were over budget by $124,130 or 1.09 %. ATTACIiMFNT3 H E FINANCIAL REPORT ® JANUARY 31, 2013 1, ISSUE DATE: MARCH 13, 2013 E A NET ASSETS TOWN OP READING, MASSACHUSETTS INVESTED IN CAPITAL ASSETS, NET OF RELATED DEBT MUNICIPAL LIGHT DEPARTMENT 70,267,391.39 RESTRICTED FOR DEPRECIATION POND (P.9) BUSINESS -TYPE PROPRIETARY FORD STATEMENT OF NET ASSETS 3,043,039.84 UNRESTRICTED 1/31/13 35,529,510.28 TOTAL NET ASSETS )P.31 96.0]),855X3 PREVIOUS YEAR CURRENT YEAR ASSETS 107 352.961.98 110.333.335.01 CURRENT UNRESTRICTED CASH (am A P.9) 9,621,141.12 11,246,242.08 RESTRICTED CASH (SON A P.9) 16,361,528.39 18,078,365.04 RECEIVABLES, NET (E® R P.10) 7,606,499.01 7,452,630.39 PREPAID EXPENSES (am B P.30) 2,210,522.49 1,581,926.88 INVENTORY 11403,358.34 1,559,620.98 TOTAL CURRENT ASSETS J9 X25.049.)5 39,918.885.39 NONCURRENT INVESTMENT IN ASSOCIATED CO (SON C P.2) 73,765.66 46,958.35 CAPITAL ASSETS, NET (SON C P.2) 67,854,146.97 70,267,391.29 TOTAL NONCURRENT ASSETS 6].927.913.63 70.314.349.64 TOTAL ASSETS 10],352.961.98 110.233.235.01 LIABILITIES CURRENT ACCOUNTS PAYABLE 6,270,495.64 5,798,865.28 CUSTOMER DEPOSI TS AD CUSTOMER ADVANCES FOR CONSTRUCLION 604,366.69 294,339.94 678,]]5.42 401,932.15 ACCRUED LIABILITIES 1,221,183.70 1,527,360.54 TOTAL CURRENT LIABILITIES 8,390.407.97 8.406.933.39 NONCURRENT ACCRUED EMPLOYEE COMPENSATED ABSENCES 3,934,696.56 3,986,360.21 TOTAL NONCURRENT LIABILITIES ].934.698.58 2.986,360.21 TOTAL LIABILITIES 11.335.106.55 11.393.293.60 A NET ASSETS INVESTED IN CAPITAL ASSETS, NET OF RELATED DEBT 67,854,146.97 70,267,391.39 RESTRICTED FOR DEPRECIATION POND (P.9) 41010,961.89 3,043,039.84 UNRESTRICTED 24,163,)46.5] 35,529,510.28 TOTAL NET ASSETS )P.31 96.0]),855X3 98.839,941.41 TOTAL LIABILITIES AND NET ASSETS 107 352.961.98 110.333.335.01 TONS OF RBADINO, MASSACKUS=S MUNICIPAL LIDNT DEPARTMENT NONCURRENT ASSET SCHEDULE 1/31/13 6CHBD0Le C SCHEDULE OF INVESTMENTS IN ASSOCIATED COMPANIES NEW ENGLAND HYDRO ELECTRIC NEW ENGLAND HYDRO TRANSMISSION TOTAL INVESTMENTS IN ASSOCIATED COMPANIES SCHEDULE OF CAPITAL ASSETS LAND STRUCTURES AND IMPROVEMENTS EQUIPMENT AND FURNISHINGS INFRASTRUCTURE TOTAL CAPITAL ASSETS, NET TOTAL NONCURRENT ASSETS PREVIOUS YEAR CURRENT YEAR 15,747.64 2,975.74 58,018.02 43,962.61 73,765.66 46.956.35 1,265,842.23 6,585,553.34 12,930,140.56 47.072.610.84 67.854.146.97 67,927.912.63 1,265,842.23 6,792,724.53 13,051,889.95 49,156,934.58 70.267.391.29 70.314.349.64 Ll • TONS OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT ROSINESS -TYPE PROPRIETARY POND STATEMENT OF REVRNOES, EXPENSES AND CHANGES IN POND EST ASSETS 14,934,146.54 16,756,324.54 13.10% 1/31/13 1,513,166.59 11,747,767.61 20,538,707.51 -9.71% EDWIN 451,931.67 xONIM 821,500.47 LMT YGR 4,969,315.69 CURRENT YEAR 5,765,300.31 m \ 16.02% LMT YEAR 281,566.15 CURRENT YSM TO RATE TO DATE CMAN06 OPERATING REVENUES: (SCH D P.11) 196,017.47 305,469.18 1,072,191.19 2,135,194.16 3.19% BASE AEV®mE 3,745,311.16 3,656,167.70 17,280,961.11 17,458,000.00 94L 0.65% FUEL REVENUE 3,114,395.49 3,076,167.45 11,541,547.15 21,087,111.13 -6.46% PURCHASED POWER CAPACITY (10,759.13) 169,473.07 (79,673.49) 1,143,664.41 - 1711.11% FORFEITED DISCOUNTS 67,893.05 96,411.66 566,459.19 607,131.02 7.10% ENERGY CONSERVATION REVENUE 55,711.95 55,051.68 353,107.69 417,296.73 18.14% 0AW REVENUE 56,637.77 55,945.06 419,401.61 423,744.27 1.041 HYPA CREDIT (51,411.30) (70.691.631 (397.814.54) (363,955.93) -8.51% TOTAL OPZMTIEO REVENUES 61997,689.99 7,040,746.19 50,665,090.93 50,913,103.63 0.45% OPERATING EEFENSZS: (SCH N 1.12) PURCHASED POWER BASE PORCMSED POWER FUEL OPERATING WAINTINNICN DEPRECIATION VOLONTMY PAYMORTN TO TOWNS TOTAL OPERATING EXPENSES OPERATING INCOME LPERATING REVEUER (EXPENSES) CONTRIBUTIONS IN AID OF CONRT RETURN ON INVESTNNNI TO READING INTEREST INCOME INTEREST EXPENSE OTMR (ROSE AND ABORT) TOTAL NONOP6RATIN0 AN (MP) CRAMS. IN NET ASSETS MET ASSETS AT BEGINNING OF YEAR NET ASSETS AT END OF JARUMY L 1,970,196.64 1,313,115.74 14,934,146.54 16,756,324.54 13.10% 3,336,331.18 1,513,166.59 11,747,767.61 20,538,707.51 -9.71% 451,931.67 821,500.47 4,969,315.69 5,765,300.31 16.02% 281,566.15 178,918.45 1,800,611.68 1,531,714.35 - 14.93% 196,017.47 305,469.18 1,072,191.19 2,135,194.16 3.19% 113.000.00 114,000.00 707,186.00 791.383.OD 94L 0.53% 5,453,153.11 6,356.160.43 47,311,119.61 47,511,714.37 0.45% 544,936.86 684,565.76 3,373,961.11 3,391,479.36 0.52% 3,975.90 108.84 37,619.54 47,187.79 35.40% (183,829.75) 1188,785.581 (1,286.806.15) (1,311,499.06) 1.70% 3,867.39 3,194.31 60,559.01 19,468.49 - 67.85% (500.31) (250.50) (5,116.99) (1.858.35) - 45.33% 130,015.08 117,408.58 144,158.43 171,103.21 - 19.51% (46.471.60) (66.734.35) 1949.688.36) TI, -085,51L. 94L 14.31% 496.065.16 615.841.41 2,424,372.96 1,305,001.62 1931 93.603,581.47 96,534,059.99 96.027,655.41 96.639.941.41 -4.88% 3.13% 2.93% OPERATING EXPENSES: (SCE B P.12A) PURCHASED POWER BASE PURCHASED POWER FUEL OPERATING NAINTENANCE DEPRECIATION VOLUNTARY PAYMENTS TO TOWNS TOTAL OPERATING EXPENSES OPERATING INCOME NONOPERATING REVENUES (EXPENSES) CONTRIBUTIONS IN AID OF CONST RETURN ON INVESTMENT TO READING INTEREST INCOME INTEREST EXPENSE OTHER (NOSE AND AMORT) TOTAL NONOPERATING REV (EXP) CHANGE IN NET ASSETS NET ASSETS AT BEGINNING ON YEAR NET ASSETS AT END OF JANUARY • ( ) = ACTUAL UNDER BUDGET 16,756,324.54 TOWN OF READING, WASSACHUSETTS 18,077,819.00 (1,321,494.46) -7.31% MUNICIPAL LIGHT DBPARTWENT 19,810,564.00 728,143.81 3.68% BUSINESS -TYPE PROPRIETARY FORD 5,765,300.31 51669,396.00 95,904.31 STATENBNT OF REVENUES, EXPENSES AND CHANGRS IN FORD NET ASSETS 1,531,724.35 1,507,336.00 1/31/13 1.62% 2,138,284.36 2,129,169.00 ACTUAL BUDGET 9,115.26 0.43% % 791.383.00 YEAR TO DATE YEAR TO DATE VARIANCE. (6,617.00) CHANGE OPERATING REVENUES: (SCH P P.S1B) BASE REVENUE 27,458,000.00 20,684,115.00 (1,]]6,115.00) -4.27% PURL REVENUE 21,087,222.13 19,109,629.00 1,977,593.13 10.35% PURCHASED POWER CAPACITY 1,283,664.41 1,307,416.00 (33,751.59) -1.82% FORFEITED DISCOUNTS 607,231.02 631,050.00 (23,617.96) -3.77% ENBROY CONSERVATION REVENUE 417,396.73 431,597.00 (14,300.27) -3.31% UAW REVENUE 423,744.27 431,597.00 (7,652.73) -1.82% STYR CREDIT (363,955.93) (408.331.00) 44,375.07 - 10.87% TOTAL OPERATING REVENUES 50,913,203.63 50,187,073.00 726,130.63 1.45% OPERATING EXPENSES: (SCE B P.12A) PURCHASED POWER BASE PURCHASED POWER FUEL OPERATING NAINTENANCE DEPRECIATION VOLUNTARY PAYMENTS TO TOWNS TOTAL OPERATING EXPENSES OPERATING INCOME NONOPERATING REVENUES (EXPENSES) CONTRIBUTIONS IN AID OF CONST RETURN ON INVESTMENT TO READING INTEREST INCOME INTEREST EXPENSE OTHER (NOSE AND AMORT) TOTAL NONOPERATING REV (EXP) CHANGE IN NET ASSETS NET ASSETS AT BEGINNING ON YEAR NET ASSETS AT END OF JANUARY • ( ) = ACTUAL UNDER BUDGET 16,756,324.54 18,077,819.00 (1,321,494.46) -7.31% 20,538,707.81 19,810,564.00 728,143.81 3.68% 5,765,300.31 51669,396.00 95,904.31 1.69% 1,531,724.35 1,507,336.00 24,388.35 1.62% 2,138,284.36 2,129,169.00 9,115.26 0.43% 791.383.00 798.000.00 001 (6,617.00) -0.83% 47,521,724.27 47,992,284.00 (470,559.73) -0.98% 3,391,479.36 2,194,789.00 1,196,690.36 54.51% 47,167.79 300,000.00 (152,812.21) - 84.27% (1,321,499.08) (1,321,250.00) (349.08) 0.02% 19,460.49 58,331.00 (38,86].51) - 66.62% (2,850.35) (1,750.00) (1,108.35) 63.33% 171,103.21 70,000.00 103,103.21 145.86% 11.085.597.941 (694.669 001 (190,938.94) 21.34% ],305,881.4] 1,300,120.00 1,005,761.42 96,534,059.99 96,534,059.99 0.00 98.839.941.41 97.834.179.99 1.005,761.4] 77.36% 0.00% 1.03% • TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT RECONCILIATION OF CAPITAL FUNDS 1/31/13 SOURCE OF CAPITAL FUNDS: DEPRECIATION FUND BALANCE 7/1/13 3,635,305.70 CONSTRUCTION FUND BALANCE 7/1/13 31000,000.00 INTEREST ON DEPRECIATION FUND PY 13 4,308.73 DEPRECIATION TRANSFER FY 13 2,138,284.26 TOTAL SOURCE OF CAPITAL FUNDS 6,777,798.60 USE OF CAPITAL FUNDS: LESS PAID ADDITIONS TO PLANT THRU JANUARY 3,734,758.64 GENERAL LEDGER CAPITAL FUNDS BALANCE 1/31/13 3,043,039.84_ TONS OF READING, MASSACHUSETTS MUNICIPAL LI DBPART • SAL85 OF KILOWATT HOURS 1/31/13 SALES OF ELECTRICITY: MORIE LAST YEAR MONTH CURRENT YEAR LAST YEAR TO DATE CURRENT YEAR TO DATE YTD % CHANGE RESIDENTIAL SALES COME. AND INDUSTRIAL SALES PRIVATE STREET LIGHTING 11,441,291 31,431,195 73,195 11,750,213 31,468.411 71.807 156,374,445 245,114,771 510,436 159,439,088 246,614,313 512,643 1.96% 0.57% 0.43% TOTAL PRIVATE CONSUMERS 5].916,781 53.291.442 402.109.fi53 406,566,044 1.11% MUNICIPAL SALES: STREET LIGHTING MUNICIPAL BUILDINGS 139,195 858,971 238,739 846,690 1,673,927 51666,816 11666,601 5,657,511 -0.444 -0.16% TOTAL MUNICIPAL CONSUMERS 1.098.166 1.085.429 7.340.74] 7.314.111 -0.23% BALES FOR RESALE 181,836 258,032 2,049,706 2,066,265 0.81% SCHOOL 1,316,235 1,197,463 7,900,456 7,903,304 0.04% TOTAL KILOWATT MOORS BOLD 56.644.119 55.9]1.366 4194_ 0O 557 42],859.715 1.06% • 151 TOWN OF READING, NLSSACRUBETTS HGNICIPAL LIGHT DSPARTMBNT KILOWATT HOURS BOLD BY TOWN 1/31/13 TOTAL READING LYNNPIXLD NO.RBADINO WILNINOTON MONTH RESIDENTIAL 31,750,113 6,947,668 3,012,506 4,950,353 61839,686 cold A ING 31,468,433 4,193,163 250,081 4,921,661 32,104.517 PVT ST LIGHTS )3,80) 13,585 11360 30,860 37,003 PUB ST LIGHTS 338,739 80,536 31,500 41,176 84,527 3RdI BLDGS 846.690 369,081 141,496 135,484 310,628 SALES /RESALE 258,032 258,033 0 0 0 SCHOOL 1,197,463 456,342 268,061 171,520 401,640 TOTAL 55.932.366 1].21),308 3.)06.004 10.331.054 39.))8.000 YEAR TO DATE RESIDENTIAL 159.439.088 49,64],04) 23,043,007 36,882,566 49,871,468 COMM A IND 246,614.313 30,814,113 1,897,354 38,033,748 175,868,988 PVT ST LIGHTS 513,643 95,095 9.520 149,153 258,876 PUB ST LIGHTS 1,666,601 563,)5] 317,460 183,700 591,689 NUNI SLOGS 5,657,511 1,410,833 999,495 1,116,764 3,130,419 SALBS/RRSALE 2,066,265 2,066,265 0 0 0 SCHOOL 7,903,304 2,791,517 1,713,651 1,000,330 2,396,806 TOTAL 4]3.859.735 87,384.)4] ]).890.487 )).466.250 231.118.246 LAST YEAR TO DATE R88IDWIIAL 156,374,445 48,878,075 33,339,481 36,480,411 48,676,467 com A IND 245,224,771 31,163,673 1,975,518 38,029,964 174,055,616 PVT ST LIGHTS 510,436 97,575 9,510 149,664 253,677 PUB ST LIGHTS 1,673,937 563,353 237,101 379,240 604,333 HUNI SLUGS 51666,816 1,408,517 966,513 1,136,938 2,154,858 to SALES /RESALE 3,049,706 1,049,706 0 0 0 SCHOOL 7.900,456 1,B16,875 1,746,008 11008,080 2,319,493 TOTAL 119.900,55) 86.98).6)3 37.364.143 77.084.398 118.064.444 KILOWATT HOURS SOLD TO TOTAL TOTAL RBADINO LYNNPI81D NO.RBADINO NILNINGTON HONTX 38.26% 12.50% 5.45% 12.23% RESIDENTIAL 50.13% 7.02% 0.45% 6.80% 8.04% 39.53% COEN & COMX A IND 0.43% 0.02% 0.06% 0.04% 0.07% PVT ST LIGHTS 0.14% 0.06% 0.07% PUB 8T LIGHTS 0.43% 0.25% 0.23% 0.56% WUNI BLDGS 1.51% 0.46% 0.00% 0.00% 0.00% 0.00% SALES/RESALE 0.46% 0.31h 0.714 sCH00u 2.32% 2.33% 0.82% 0.489 TOTAL 100.00% 31.84% 6.63% 18.]9\ 53.]4% YEAR TO DATE R89IDM7IIAL 37.62% 11A1% 5.44% 8.70% 11.77% COHN A ING 58.30% 7.37% 0.45% 8.97% 41.51% PVT ST LIGHTS 0.12% 0.02% 0.00% 0.04% 0.06% 0.14% PUB ST LIGHTS 0.39% 0.13% 0.05% 0.07% 0.50% HUNI BLDGS 1.33% 0.33% 0.34% 0.264 O.OD% SALES /RESALE 0.49% 0.49% 0.00% 0.00% SCHOOL 1.85% 0.66% 0.40% 0.24% 0.55% 100.00% 10.61% 6.58% 18.29% 51.53\ TOTAL LAST YEAR TO DATE 37.29% 17.65% 5.33% 8.70% 58.47% 7.43% 0.00% 9.074 41.50% 11.50% COM11 A ING cow &Win 0.13% 0.02% 0.00% 0.04% 0.06% PVT ST LIGHTS 0.13% 0.05% 0.07% 0.15% © FUS HUN ST LIGHTS HUNT SLOGS 0.40\ 1.49% 0.34% 0.69% 0.33% 0.00% 0.00% 0.00% 0.51% 0.00% SALES /RESALE 0.49% 0.671 0.434 0.21% 0.55% SCHOOL 1.884 TOTAL 100.00 % ]0.73% fi.50\ 18.39% 54.38% 161 TOWN OF RRADING, MSSACHUSZTTS MM[ICIPAL LIGHT DEPARTM TORNGLA INCOME 1/31/13 TOTAL OPERATING REVENUES ADD: POLE RENTAL LEM (P.3) 50,913,203.63 INTEREST INCOME ON CUSTOMER DEPOSITS OPERATING RZYMSES (P. 3) CUSTONXR DEPOSIT INTEREST EXPRESS PORMGLA INCOME (LOSS) 0.00 820.1E (17,521,728.27) (2,858.35) 3.389.881.19 • C r- 6-1 A SALE OF RWR (P.5) RNR PURCHASED A" BASE COST PER INS AVE BASE SALE PER EWH AVE COST PER RWH AVE SALE PER EWE FUEL CHARGE REVENUE (P.3) LOAD FACTOR �m TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT GENERAL STATISTICS 1/31/13 MONTH OF JAN 2012 56,644,119 59,550,250 0.033086 0.066110 0.089145 0.121100 3.114,395.49 76.56% 106,558 MON1A of % CHANGE YEAR THRU JAN 3013 1011 2013 JAN 2012 JAN 2013 55,932,366 -3.46% 1.06% 419,400,557 423,859,725 60.866,668 -2.87% 2.35% 433.579,697 443,749,414 0.038003 - 48.69% 9.63% 0.034444 0.037761 0.063531 3.42% -0.41% 0.065048 0.064781 0.079457 -5.47% -3.30% 0.086909 0.084045 0.116937 -1.65% -3.$9% 0.118797 0.114531 2,987,105.82 - 10.36% -6.46% 22,542,547.15 21,087,222.13 76.64% 108,799 N Y V3 i f, J e, °4y 2��7n erh. 2� .8 J� 1 �i ON ;r00 d �� 7n <<�On �iSSa O`�yn J O d0 O"'o+ Oi JO d O� �b O'/y,, I ! 4 O�y�ob Oi �Y _1 piSSy., ti^ Lr) o Lri N Lr) o Q) n. Z C: Q C) CD CD N > 0 0 6 U) 7FD � (6 � N Y V3 i f, J e, °4y 2��7n erh. 2� .8 J� 1 �i ON ;r00 d �� 7n <<�On �iSSa O`�yn J O d0 O"'o+ Oi JO d O� �b O'/y,, I ! 4 O�y�ob Oi �Y _1 piSSy., ti^ Lr) o Lri o Lr) o Q C) CD CD 6 TOWN OF RRMINO, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF CASH AND INVESTMENTS `V 1/31/1] 9CNEDOLB A UNRESTRICTED CASH CASH - OPERATING FORD CASH - PETTY CASH TOTAL UNRESTRICTED CASH RESTRICTED CASH CASH - DEPRECIATION FUND CASH - TONE PAYNEWT CASH - DEFERRED FUEL RESERVE CASH - RATE STABILIZATION FUND CASE - UNCOLLECTIBLE ACCTS RESERVE CASH - SIM LEAVE BENEFITS CASH - HAZARD WASTE RESERVE CARS - =STONER DEPOSITS CASH - ENERGY CONSERVATION CASH - DIES TOTAL RESTRICTED CASH C TOTAL CASH BALANCE I PREVIOUS YEAR CURRENT YEAR 9,618,141.11 11,143,141.08 3,000.00 3,000.00 9.611.141.11 11,346,141.08 4,010,961.89 3,043,039.84 596,000.00 303,705.50 1,453,189.78 1,454,603.87 6,068,389.05 6,687,657.73 100,000.00 100,000.00 1,951,851.04 3,986,790.43 150,000.00 150,000.00 604,388.69 678,775.41 173,774.13 118,018.09 1,173,973.83 1,346,595.16 18.078.165.04 18,381.538.39 M ]6,001,669.51 19.314.507.11 TOWN OF READING, NA86ACHD98TT6 MUNIC2PAL LIGXT DEPART SCHEDULE OF ACCOUNTS RECEIVABLE 1/31/11 6CREDULB B SCHEDULE OF PRBPATHENT8 PREPAID INSURANCE PREVIOUS YEAR 2,724,477.21 CURRpT' YEAR BCN8OUL8 OF ACCOUNTS RECEIVABLE PREPAYMENT PURCHASED POWER 336,853.70 )251,411.19) RESIDENTIAL AND COMERCIAL 3,298,034.16 138,330.65 ],]14,477.11 241,849.31 ACCOUNTS RECEIVABLE - OTHER 173,757.74 155,415.85 251,176.04 188,303.79 ACCOUNTS RECEIVABLE - LIENS 68,665.99 14,533.70 44,306,27 14,523.70 ACCOUNTS RECEIVABLE - ENPLOYFE ADVANCES 891.14 2.210.523.49 892.14 1.551.9]6.88 SALES DISCOUNT LIABILITY (1]1,24].53) 60 DAYS (247,159.94) RESERVE FOR UNCOLLECTIBLB ACCOUNTS (290,897.86) (136,895 16) TOTAL ACCOUNI6 RECEIVABLE BILLED 2,979,204.64 1,536,593.56 90 DAYS UNFILLED ACCOUNTS RECEIVABLE 4,830,294.37 2.22% 4,915,936.83 TOTAL ACCOUNTS RECEIVABLE, NET ],808,499.01 100.00% ],152.830.39 SCHEDULE OF PRBPATHENT8 PREPAID INSURANCE 1,465,398.59 2,724,477.21 1,388,591.16 PREPAYMENT PURCHASED POWER 336,853.70 )251,411.19) 941 PREPAYMENT PASHT 138,330.65 GENERAL LEDGER BALANCE 241,849.31 .!417177!117' 1 PREPAYMENT WATSON 155,415.85 188,303.79 CURRENT PURCHASED POWER WORKING CAPITAL 14,533.70 86.19% 14,523.70 TOTAL PRRPAYNBNT 2.210.523.49 1.551.9]6.88 ACCOUNTS RECEIVABLE AGING JANUARY 1013: • RESIDENTIAL AND COMERCIAL 2,724,477.21 LESS: SALES DISCOUNT LIABILITY 5 941 GENERAL LEDGER BALANCE .!417177!117' 1 1]1] CURRENT 1,135,241.13 86.19% 30 DAYS 139,859.47 9.28% 60 DAYS 48,046.56 1.941 90 DAYS 91156.86 0.37% OVER 90 DAYS 55.013 15 2.22% TOTAL 2,47],]17.1] 100.00% K M TONE OF READING, MASSACHIJSE S MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REVENUE% 1/31/13 BCNBOULB U MUNICIPAL SALES: MONTH MONTH LAST YEAR CURRENT YEAR YTD % SALES OF ELECTRICITY: LAST YEAR CURRENT YEAR TO DATE TO DATE CHANGE RESIDENTIAL SALES 2,986,106.37 1,889,149.37 20,631,157.21 104.255.50 30,323,491.43 101,903.38 -1.50% COME AND INDUSTRIAL SALES 3,545,526.02 658,093.28 3,536,717.37 -4.64% 27,056,607.04 TOTAL MUNICIPAL CONSUMERS 36,190,297.21 -3.20% PRIVATE STREET LIGHTING 6,336.67 6,210.70 47,717.11 41,196.88 21,452.71 - 13.66% TOTAL PRIVATE CONSUMERS 6.537.969.06 132,990.64 6.433.097.44 159,537.31 47.735.581.48 35,092.33 46.553.985.51 31,937.02 -3.48% MUNICIPAL SALES: 6,859,617.75 6,734,555.15 49,813,509.37 48,545,111.13 -2.57% STREET LIGHTING 30,461.88 29,316.83 226,471.87 198,410.96 - 13.39% MUNICIPAL BUILDINGS 104.255.50 101,903.38 690,109.80 658,093.28 -4.64% TOTAL MUNICIPAL CONSUMERS 134,717.30 131.220.31 916.581.6] 856.512.24 -6.55% ENERSY CONSERVATION - RESIDENTIAL 21,452.71 21,763.78 132,990.64 159,537.31 SALES FOR RESALE 35,092.33 31,937.02 33,159.14 252,014.50 33,288.90 244,461.22 220,109.05 -3.00% 157,769.41 SCHOOL 151,838.98 149.300.48 56,637.77 919.331.72 55,945.06 890,263.15 419,402.62 -3.16% 413,]44.3] 5UB -T0TAL 6,859,617.75 6,734,555.15 49,813,509.37 48,545,111.13 -2.57% FORFEITED DISCOUNTS 87,893.05 96,411.86 566,459.18 607,131.02 1.10% PURCHASED POWER CAPACITY (10,759.23) 169,473.07 (]9,6]3.49) 1,283,664.41 - 1711.16% ENERSY CONSERVATION - RESIDENTIAL 21,452.71 21,763.78 132,990.64 159,537.31 19.95% ENERGY CONSERVATION - COMMERCIAL 33,159.14 33,288.90 220,109.05 157,769.41 17.06% GAN REVENUE 56,637.77 55,945.06 419,402.62 413,]44.3] 1.04% NYPA CREDIT (51,411.30) (70,691.63) (397,014.54) (363,955.93) -8.51% TOTAL REVENUE 0.45% 6.997,689.99 ].040.746.19 50.685.090.93 50,913.203.63 TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT SCHEDULE OF OPERATING REVENUE BY TOWN 1/31/13 MONTH TOTAL READING LYNIRIELD 9.49\ 8.98\ 0.09% 0.03% 0.00\ o.a3% NO.READING WILMINGTON RESIDENTIAL ],889,149.3) READING 935,562.43 NO.RBADING 398,41].3] RESIDENTIAL INDUS /MONI BLDG PUB. ST.LIGHTS PRV.ST.LIGHTS CO -OP RESALE SCHOOL 657,095.14 908,074.44 INDUS /NUNS SLOG 3,628,630.75 TOTAL 530,745.35 13 47,135.26 10.81\ 583,784.98 SL 2,467,965.26 PUB.ST.LIGHTS 39,316.83 WET YEAR TO DATE 9,SB0.30 TOTAL 3,795.53 51147.59 10,793.41 PRV.ST.LIGHTS 6,220.70 RESIDENTIAL INDUS /NUNS BLDG PUB. ST. LIGHTS PRV.ST.LIGHTS CO -OP RESALE SCHOOL 1,143.34 114.44 1,845.37 3,117.55 CO -OP RESALE 31,937.02 RESIDENTIAL INDUS /MUNI HIM PU9.ST. LIGHTS PRV.ST.LIGHTS CO -OP RESALE SCHOOL 31,937.02 0.00 0.00 9.67% 8.82% 0.07% 0.03% 0.00% 0.298 13.09% 36.26% 0.16% 0.068 0.00% 0.551 SCHOOL 149,300.48 TOTAL 53,)7).63 30,596.71 20,190.44 0.00 45,735.70 25 94� 1_�- 310,13 100.00% 31.93% ).148 18.83! 5..30! TOTAL 6.734.555.15 1.551.745.96 480,059.31 Z 1,367.063.53 3.435.686.36 THIS YEAR TO DATE RRSIDENTIAL INDUS /MUNI BLDG PUB. ST. LIGHTS PRV.ST.LIGHTS CO -OP RESALE SCHOOL 30,323,491.43 36,040,390.49 198,418.96 41,196.88 244,461.33 890,263.15 6,352,961.93 3,661,073.17 64,243.42 7,535.56 244,461.22 317,217.32 21919,089.95 334,160.58 25,425.25 753.53 0.00 190,737.90 9.49\ 8.98\ 0.09% 0.03% 0.00\ o.a3% 4,695,143.55 4,282,003.04 36,154.88 12,409.78 0.00 115,908.20 1].838 38.78% 0 0.05 0.00% o.sa\ 6,355,296.01 18,571,075.70 ]],595.41 20,498.02 0.00 266,399.73 TOTAL READING LYNNPIRLD NO.RBADING WILMINGTON RESIDENTIAL INDUS /MONI BLDG PUB. ST.LIGHTS PRV.ST.LIGHTS CO -OP RESALE SCHOOL 43.90% 53.88% 0.44% 0.09% 0.47% 2.22% 13.74% 7.88% 0.14% 0.02% 0.47% 0.78% 5.92% 0.70% 0.06% 0.00% 0.00% 0.45% 9.76% 8.65% 0.08% 0.03% 0.00% 0.30% TOTAL 18.545].. .] 13 _ 10.64).491.61 10.81\ 3 47�rp l6p,]B SL 9,141,698.16 35,285.864.88 WET YEAR TO DATE Mm TOTAL 100.00% ]].03% 7 .134 RESIDENTIAL INDUS /NUNS BLDG PUB. ST. LIGHTS PRV.ST.LIGHTS CO -OP RESALE SCHOOL 20.631,257.22 27,746,716.84 226,471.87 47,717.32 252,014.50 919,331.73 61464,504.95 3,023,007.92 73,925.06 8,917.68 253,014.50 332,052.32 2,938,871.91 352,644.62 28,007.06 873.00 0.00 199,337.84 4,801,274.13 4,433,337.19 40,374.65 14,702.26 0.00 120,267.15 6,426,606.23 19,138,727.11 85,085.10 23,334.38 0.00 267,674.41 RESIDENTIAL INDUS /MUNI HIM PU9.ST. LIGHTS PRV.ST.LIGHTS CO -OP RESALE SCHOOL 41.86% 55.31% 0.41% 0.09% 0.508 1.831 13.09% 7.54% 0.13% 0.02% 0.50% 0.651 6.01% 0.69% 0.05% 0.008 0.00% 0.398 9.67% 8.82% 0.07% 0.03% 0.00% 0.298 13.09% 36.26% 0.16% 0.068 0.00% 0.551 TOTAL t9 823.509.37 10.953.4]].13 3,519.B14.0 9.909.955.]8 25 94� 1_�- 310,13 100.00% PERCESTAGB OF OPERATING INCOME TO TOTAL 12.84% 7.62% 0.15% 0.02% 0.50\ 0.64% 5.91% 0.71% 0.06\ 0.00% 0.00% 0.39\ 9.49\ 8.98\ 0.09% 0.03% 0.00\ o.a3% 1].838 38.78% 0 0.05 0.00% o.sa\ MONTH TOTAL READING LYNNPIRLD NO.RBADING WILMINGTON RESIDENTIAL INDUS /MONI BLDG PUB. ST.LIGHTS PRV.ST.LIGHTS CO -OP RESALE SCHOOL 43.90% 53.88% 0.44% 0.09% 0.47% 2.22% 13.74% 7.88% 0.14% 0.02% 0.47% 0.78% 5.92% 0.70% 0.06% 0.00% 0.00% 0.45% 9.76% 8.65% 0.08% 0.03% 0.00% 0.30% 13.48% 36.65% 0.16% 0.04% 0.00% 0.69% ).OT 10.81\ SL JS% Mm TOTAL 100.00% ]].03% 7 .134 ME YEAR TO DATE RESIDENTIAL INDUS /MUNI HIM PU9.ST. LIGHTS PRV.ST.LIGHTS CO -OP RESALE SCHOOL 41.86% 55.31% 0.41% 0.09% 0.508 1.831 13.09% 7.54% 0.13% 0.02% 0.50% 0.651 6.01% 0.69% 0.05% 0.008 0.00% 0.398 9.67% 8.82% 0.07% 0.03% 0.00% 0.298 13.09% 36.26% 0.16% 0.068 0.00% 0.551 TOTAL 100.00% 31.93% ).148 18.83! 5..30! LAST YEAR TO DATE RESIDENTIAL INDUS /MUNI BLDG PU9.ST.LIOHTS PRV.ST RESALE CO -OP RE9AL8 SCHOOL 41.07% 56.09% 0.46% 0.10\ 0.50\ 1.70% 12.84% 7.62% 0.15% 0.02% 0.50\ 0.64% 5.91% 0.71% 0.06\ 0.00% 0.00% 0.39\ 9.49\ 8.98\ 0.09% 0.03% 0.00\ o.a3% 1].838 38.78% 0 0.05 0.00% o.sa\ 1]t TOTAL 100.00\ 31.7% ).OT 10.81\ SL JS% Mm • ( ) . ACTUAL ORDER BUDGET M.) TOWN OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED REVENUE VARIANCE REPORT 1/31/13 ACTUAL BUDGET i YEAR TO DATE YEAR TO DATE VARIANCE • CHANGE SALES OF ELECTRICITY, RESIDENTIAL 13,386,197.66 13,963,589.00 (577,391.34) .4.45% CORE AND INDUSTRIAL SALES PRIVATE STREET LIGHTING 14,332,614.9O 14,938,493.00 (605,878.10) -4.06% MUNICIPAL BUILDINGS PUBLIC STREET LIGHTING 115,077.15 118,337.00 (3,149.85) -1.66% SALES FOR RESALE 143,033.13 169,763.00 (37,739.87) - 16.33% SCHOOL 493.077.16 504.043.00 (11. 965.84) -3.37% TOTAL BASE SALES 37,458,000.00 38,684,115.00 (1.336,115.00) -4.37% TOTAL FUEL SALES 31,087,333.13 19,109,629.00 1.977,593.13 10.35% TOTAL OPERATING REVENUE 48,545,313.13 47,793,744.00 751,478.13 1.57% FORFEITED DISCOUNTS 607,333.03 631,050.00 (33,017.98) -3.77% PURCHASED POWER CAPACITY 1,383,664.41 1,307,416.00 (33,751.59) -1.83% ENERGY CONSERVATION - RESIDENTIAL 159,537.31 160,783.00 (11354.69) -0.78% ENERGY CONSERVATION - COMMERCIAL 357,769.43 370,815.00 (13,045.58) -4.83% DAN REVENUE 433,744.37 431,597.00 (7.053.73) -1.83% PARRY CREDIT (363,955.93) (408,331.00) 44,375.07 - 10.87% TOTAL OPERATING REVENUES 1.45% 50.913.303.63 50.187.073.00 736.130.63 • ( ) . ACTUAL ORDER BUDGET M.) TOM! OR READING, HA68AC8088TT8 NGRICIPAL LIGHT OBPARTHENT SCHEDULE OF OPERATING EXPENSES 1/31/13 8CX8DOL8 8 NAINTNNANCN EXPENSES: NGN7H HUNTS LAST YEAR CURRENT YEAR YID % OPERATION BXPRNR68: LAST YEAR MAINS OF TMU8MI88ION PLANT SAINT OP STRUCT AND nuipNT HAINT OF LINES - ON MI. OF LIMES - US MINT OF LINE 9RAR8PORNEXS MINT OF ST IT A SIG SYSTEM MINT OF DAMON AND STOCXROOS MINT OP PROBES MINT OF GeN PLANT CURRENT YEAR TO DATE 237.08 16,067.16 141,)17.4] 18,675.63 43,739.35 (8.23) 42,085.56 2,125.44 14,388.99 TO DATR 11589.58 168,042.40 1.070,013.21 115,281.36 31,187.43 (350.51) 398,546.82 49,608.01 46,703.38 CHANGE PURCHASED POWER EASE 8 %PBNER 1.9]0.296 64 3,313.125 74 14.934,246.54 15 16.756.324.54 45 11800,622.69 1.531.731.35 - 18.93\ DEPRECIATION EXPENSE 296,027.47 305,469.18 12.30% OPERATION SUP AND ENGINEERING SIR 33,507.31 3.19% 39,914.20 PURCHASED POWER PURL EXPENSE 309,)02.)4 299,498.24 -3.29% STATION SUP LABOR AND RISC 7,736.16 -9.71% 7,696.39 VOLUNTARY PAYMENTS TO TURNS 66,914.43 44,093.81 - 34.11% LINE MISC LABOR AND EXPENSE 38,506.15 0.53% 62,418.80 TOTAL OPERATING EXPENSES 384,941.18 400,433.80 4.02% STATION LABOR AND EXPENSE 29,667.64 0.45% 43,335.68 282,853.46 317,214.49 12.15% STREET LIGHTING EXPENSE 14,177.67 9,748.55 66,081.51 48,827.26 - 28.28% HETER EXPRESS 8,060.36 18,345.70 150,325.95 110,515.47 - 26.48% MISC DISTRIBUTION EXPENSE 25,739.70 30,326.14 194,912.25 201,229.35 3.24% M IER READING LABOR A EXPENSE 6,977.37 ],115.]0 53,854.07 52,402.29 -2.70% ACCT R COLL LABOR A EXPRESS 112,805.63 125,758.47 811,869.78 8801951.87 8.51% UHCOLLECTIBLE ACCOUNTS 16,000.00 8,333.33 112,000.00 58,333.31 - 47.938 ENERGY AUDIT EXPENSE 30,615.79 53,563.94 262,482.13 288,454.90 9.90\ ADMIN A GEN SALARIES 55,022.95 77,020.95 437,113.65 456,951.13 4.54% OFFICE SUPPLIES A EXPENSE 19,168.89 25,443.87 126,641.10 143,783.]] 13.54% OUTSIDE SERVICES 36,302.15 52,961.81 223,657.00 252,062.90 12.70% PROPERTY INSURANCE 23,265.13 22,936.17 218,567.84 213,253.59 -2.43% INGURIES AND DAMAGES 3,968.18 4,649.05 7,936.23 38,051.34 253.91% EmLOYE88 PENSIONS A BENEFITS (62,284.63) 164,706.93 682,198.42 1,260,881.14 04.83% RISC GENERAL EXPENSE 9,144.80 61445.08 120,960.38 106,850.82 - 11.66% RENT EXPENSE 5,695.29 15,313.91 103,891.72 119,064.09 14.60% MERGE CONSERVATION 39,835.13 45,365.80 350,221.85 482,439.67 37.75% TOTAL OPERATION EXPENSES 452.931 67 821.500 41 4.969 115 69 5,765,300,31 16 02% NAINTNNANCN EXPENSES: MAINS OF TMU8MI88ION PLANT SAINT OP STRUCT AND nuipNT HAINT OF LINES - ON MI. OF LIMES - US MINT OF LINE 9RAR8PORNEXS MINT OF ST IT A SIG SYSTEM MINT OF DAMON AND STOCXROOS MINT OP PROBES MINT OF GeN PLANT 227.00 ]6,364.]1 140,390.83 9,400.19 18,389.191 (48.03) 49,668.05 9,454.55 5,489.96 237.08 16,067.16 141,)17.4] 18,675.63 43,739.35 (8.23) 42,085.56 2,125.44 14,388.99 11589.58 168,042.40 1.070,013.21 115,281.36 31,187.43 (350.51) 398,546.82 49,608.01 46,703.38 1.589.58 81,299.14 906,066.89 97,547.63 77,726.50 (258.30) 200.867.94 21,023.99 65,861.98 0.00% - 56.77% - 15.32% - 15.38% 149.22% - 26.31% -5.92% - 57.62% 41.02% TOTAL MINTENANCE EXPENSES 202.566 15 3)8.918 45 11800,622.69 1.531.731.35 - 18.93\ DEPRECIATION EXPENSE 296,027.47 305,469.18 2,072,192.29 3,138,284.26 3.19% PURCHASED POWER PURL EXPENSE 3,338,331.18 2,523,166.59 22,747,767.61 30,538,707.81 -9.71% VOLUNTARY PAYMENTS TO TURNS 113,000.00 114,000.00 )8),186.00 791,383.00 0.53% TOTAL OPERATING EXPENSES 6 45� 3353,11 6,356.180.1) 4).311.139.61 4).5]1.)34.]] 0.45% • TONS OF READING, MASSACNOSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED OPERATING EXPENSE VARIANCE REPORT 1/31/13 BCNEDOLE G • ( ) . ACTUAL UNDER BUDGET Ili Al ACTUAL BUDGET % OPERATION EXPENSES: YEAR TO DATE YEAR TO OATS VARIANCE • CHANGE PURCHASED POWER BASE EXPENSE 16.]56.J34.54 18.011,819.00 (1,331.494.46) -7.31% OPERATION SUP AND ENGINEERING REP 299,498.24 375,343.00 34,256.14 8.81% STATION SUP LABOR AND MISC 44,092.81 46,847.00 (2,754.19) -5.86% LINE MISC LABOR AND EXPENSE 400,433.80 357,367.00 13,066.80 3.37% STATION LABOR AND EXPENSE 317,314.49 263,909.00 53,305.49 30.20% STREET LIONTING EXPENSE 48,837.26 48,596.00 331.26 0.48% ENTER EXPENSE 110,515.47 99,015.00 11,500.47 11.61% MISC DISTRIBUTION EXPENSE 201,339.35 313,433.00 (11,203.65) -5.27% METER READING LABOR % EXPENSE 52,403.29 56,888.00 (4,4B5.71) -7.69% ACCT A COLL LABOR A EXPENSE 880,951.87 806,759.00 74,193.87 9.30% UNCOLLECTIBLE ACCOUNTS 58,333.31 58,331.00 3.31 0.00% ENERGY AUDIT EXPENSE 388,454.90 283,515.00 4,939.98 1.74% ADMEN A GEN SALARIES 456,951.13 440,815.00 16,136.12 3.66% OFFICE SUPPLIES 6 EXPENSE 143,]83.]7 148,274.00 (4,490.13) -3.03% OUTSIDE SERVICES 353,062.90 369,433.00 (117,370.10) - 31.77% PROPERTY INSURANCE 313,253.59 175,051.00 (61,797.41) - 22.47% INTURIES AND DAMAGES 28,051.34 33,231.00 (5,179.66) - 15.59% EMPLOYEES PENSIONS G BENEFITS 1,360,881.14 1,183,307.00 ]],574.14 6.56% MISC GENERAL EXPENSE 106,858.82 141,025.00 (34,166.18) - 24.33% RIFT EXPENSE 119,064.09 123,669.00 (4,604.91) -3.72% ENERGY CONSERVATION 482,439.67 415,690.00 66,749.67 16.06% TOTAL OPERATION EXPENSES 5.669.396 .00 95.904.31 3.69% 5. 765,300.31 { MAINTENANCE EXPENSES: MAINT OF TRANSMISSION PLANT 11589.58 1,750.00 (160.43) -9.17% MAINT OF STRUCT ANT EQUIPMENT 811299.14 60,156.00 13,143.14 19.28% MAINT OF LINES - ON 906,066.89 701,490.00 304,576.89 29.16% SAINT OF LINES - 00 97,547.63 96,759.00 788.63 0.82% PAINT OF LINE TRANSFORMERS 77,726.50 126,199.00 (48,472.50) - 38.41% SAINT OF ST IT 6 SIG SYSTEM (358.30) 51656.00 (5,914.30) - 104.57% WAIST OF GARAGE AND STOCXROOM 380,867.94 390,534.00 (109,656.06) - 28.08% MAINT OF METERS 31,022.99 40,320.00 (19,297.01) - 47.86% MAINT OF GEN PLANT 65,861.98 76,462.00 (10,610.02) - 13.89% TOTAL MAINTENANCE EXPENSES 1,SOi.J36.00 34.388.35 1.62% 1.5]1.734.35 DEPRECIATION EXPENSE 3,136,284.16 3,139,169.00 9,115.26 0.43% PURCHASED POWER FUEL EXPENSE 30,538,707.81 19,810,564.00 728,143.81 3.68% VOLUNTARY PAYMENTS TO TOWNS 791,383.00 798,000.00 (6,617.00) -0.83% TOTAL OPERATING EXPENSES -0.98% (470.559.73) 47.992.284.00 47.521.734.2) • ( ) . ACTUAL UNDER BUDGET Ili Al TONS OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT BUDGETED OPERATING EXPENSE VARIANCE REPORT 1/31/13 i OPERATION EXPENSES: RESPONSIBLE SENIOR MANAGER 3813 ANNUAL BUDGET ACTUAL YEAR TO DATE REMAINING BUDGET BALANCE REMAINING BUDGET % PURCHASED PONER BASE EXPENSE JP 30.103 A4S 00 16 756.324.54 13.346.417.46 44.34% OPERATION SUP AND ENGINEERING REP STATION SUP LABOR AND MIBC LINE MIBC LABOR AND EXPENSE STATION LABOR AND EXPENSE STREET LIGHTING EXPENSE METER EXPENSE MIBC DISTRIBUTION EXPENSE ENTER READING LABOR R EXPENSE ACCT i CULL LABOR i EXPENSE UNCOLLBCRIBLE ACCOONTS ENERGY AUDIT EXPENSE ADMAN A GEN SALARIES OPPICB SUPPLIES i EXPENSE OUTSI0E SERVICES PROPERTY INSURANCE INJURIES AND DAMAGES EMPLOYEES PENSIONS i BENEFITS MISC GENERAL EXPENSE RENT EXPRESS ENERGY CONSERVATION XS XS RE R8 RE R8 AS HE RP RP JP VC VC VC RE RE RB VC BE JP 468,949.00 79,813.00 671,309.00 448,249.00 83,106.00 197,329.00 366,489.00 69,946.00 100,000.00 479,013.00 761,068.00 507,1]5.00 471,500.00 561619.00 1,889,623.00 200,785.00 212,000.00 697,983.00 399,498.24 11,092.81 400,433.80 317,214.49 48,827.36 110,515.47 201,]]9.35 52402]9 , 880,951.87 58,333.31 288,454.90 15695113 , 143,]83.7) ]53, Ofi ].90 213,253.59 28,051.34 11260,881.14 106,058.82 119,064.09 481,439.67 .1,385,]30.00 .]53,950.00 169,450.76 35,]]0.19 ]70,875.]0 131,034.51 34,278.74 66,613.53 1fi 5,359.65 17,543.71 504,258.13 11,666.69 190,558.0] 101,116.02 110,166.23 355,062.10 258,246.41 28,567.66 6]0,]11.86 93,926.18 93,935.91 215,543.33 36.13% 44.75{ 40.35% 29.23% 41.25{ 43.99{ 45.09% 25.09% 3fi.4O4 41.40% 39.67% 39.78% 13.38{ 50.38% 54.77% 50.46% 33.27{ 46.78% 43.84% 30.88% TOTAL OPERATION EXPENSES 8.823.105.00 5.765.300.31 3.fi34.765.69 41.20% MAINTENANCE BXPENS83t • SAINT OF TRANSMISSION PLANT SAINT MAINT! OF LINES OF LIN6S E ON AND EQOI PMT - MAIM OF LINES - UG MAIM OF LINE TRANSFORMERS MAINT OF 8T IT A SIG SYSTEM MAIM OF GARAGE AND STOCKROOM MAINT OF METERS MAIM OF GIN PLANT RS KS KS KS RS KS KS KS RP 3,000.00 114,120.00 1,250,131.00 285,371.00 188,500.00 9,684.00 672,589.00 47,392.00 131,330.00 1,589.58 81,299.14 906,066.89 97,547.63 ]7,]36.50 (258.30) 280,067.94 21,022.99 65,861.98 1,410.4] 32,820.86 344,354.11 187,823.37 110,773.50 9,912.30 391,721.06 36,369.01 65,458.02 47.03{ 28.76% 27.54% 65.82{ 58.77{ 102.67% 58.34% 55.64% 49.85% TOTAL MAIMENANCB EXPENSES 2.817.101.00 5.531,]34.35 1.170.6]3.65 41.55% DEPRECIATION EXPENSE RP 3,650,000.00 2,138,284.36 1,511,715.74 41.42% PURCHASED POWER PURL EXPENSE JP 30,500,000.00 20,538,707.81 9,961,292.19 32.66% VOLUNTARY PAYMENTS TO TOWNS RP 1,368,000.00 791,383.00 576,617.00 12.15% TOTAL OPERATING EXPENSES 8383 t6�- �c'S00'005 pp,p0 ,] 531.]]1.]] 3�0 ]01,980.)3 36.05{ • 12W C C TOM OF READING, MASSACHUSETTS MUNICIPAL LIGHT DEPARTMENT PROFESSIONAL SERVICES /31/2013 PROFESSIONAL SERVICES BY VENDOR PROFESSIONAL SERVICES BY PROJECT MRLANSON BIRTH 6 COMPANY 33,750.00 HUDSON RIVER ENERGY GROUP 21895.80 STONE CONSULTING INC. 3,750.00 ITEM DEPARTMENT ACTUAL BOUGHT VARIANCE 1 RPLO) AND PENSION TRUST AUDIT FEES ACCOUNTING 32,750.00 32,250.00 81,311.31 500.00 WHORES TORREY 6 SPENCER 2 PENSION ACTUARIAL EVALUATION ACCOUNTING 3,750.00 0.00 2,062.00 3,750.00 MICHAEL BROW ARBITRATOR 3 LEGAL- FERC /ISO ISSUES ENERGY SERVICE 0.00 10,500.00 1,732.50 (10,500.00) COGSDALE 4 LEGAL- POKER SUPPLY ISSUES ENERGY SERVICE 18,065.80 26,250.00 (8,164.20) 5 PROFESSIONAL SERVICES ENERGY SERVICE 9,939.80 14,000.00 (4,D60.20) 6 NERC COMPLIANCE AND AUDIT R R O 7,995.00 10,850.00 (2,855.00) 7 LOAD CAPACITY STUDY ENGINEERING 0.00 11,250.00 (11,250.00) 8 STROM HARDENING STUDY ENGINEERING 0.00 50,000.00 (50,000.00) 9 LEGAL - GENERAL, MMMEC AUDIT GM 63,000.78 87,500.00 (24,499.221 10 LEGAL SERVICES - GENERAL HE 62,037.88 39,600.00 21,437.80 11 LEGAL SERVICES- NEGOTIATIONS BR 27,584.42 36,000.00 (9,315.50) 12 LEGAL GENERAL BLDG. PAINT. 10,300.90 875.00 9,425.90 13 SURVEY RIGHT OF NAY BLDG. PAINT. 0.00 21919.00 (2,919.00) 14 ENVIRONMENTAL BLDG. MAINT. 0.00 2,919.00 (3,919.00) 15 ENGINEERING SERVICES BLDG. PAINT. 14,116.05 4,970.00 9,146.05 16 REPAIR HARP AND DECK AREA BLDG. MAINT. 0.00 30,000.00 (30,000.00) 17 INSURANCE CONSULTANT GEN. BENEFIT 0.00 5,831.00 (5,031.00) 18 LEGAL GEN. BENEFIT 0.00 2,919.00 (2,919.00) 19 SITE ASSESSMENT FOR MAJOR UPGRADE ACCOUNTING 2,056.27 0.00 2,056.27 20 GENERAL BANKRUPTCY ACCOUNTING 1 444.00 0.00 1,444.00 TOTAL 252.062.90 369,431.00 (117,370.101 PROFESSIONAL SERVICES BY VENDOR (13) ACTUAL MRLANSON BIRTH 6 COMPANY 33,750.00 HUDSON RIVER ENERGY GROUP 21895.80 STONE CONSULTING INC. 3,750.00 ROBIN AND RUDMAN 35,603.16 UTILITY SERVICES INC. 7,995.00 DUNCAN R ALLEN 57,228.32 CROATS HALL R STENART 81,311.31 WHORES TORREY 6 SPENCER 12,385.55 RICHARD HIGGINS ARBITRATOR 2,710.00 GRANT MOTHER ARBITRATOR 2,062.00 MICHAEL BROW ARBITRATOR 3,538.99 CMEEC 7,044.00 JM ASSOCIATES 1,732.50 COGSDALE 2,056.27 TOTAL 253.062.90 (13) RMLD BUDGET VARIANCE REPORT FOR PERIOD ENDING JANUARY 31, 2013 DIVISION ACTUAL BUDGET VARIANCE CHANGE ENGINEERING AND OPERATIONS 2,553,105 2,408,678 144,427 20,538,708 19,810,564 ENERGY SERVICES 800,076 750,249 49,827 6.00% 6.64% 98,846.062 GENERAL MANAGER 524,100 548,449 (24,349) -4.44% FACILITY MANAGER 2,210,284 2,329,382 (119,097) -5.11% BUSINESS DIVISION 5,463,464 5,390,141 73,322 1.36% SUB -TOTAL 11,551,030 11,426,899 124,130 1.09% PURCHASED POWER - BASE 16,756,325 18,077,819 (1,321,494) -7.31% PURCHASED POWER - FUEL 20,538,708 19,810,564 728,144 3.68% TOTAL 98,846.062 49,315 282 (969 220) -0.95% j ARLO DEFERRED PURL CASH RESERVE ANALYSIS 1/31/13 Il GROSS MONTHLY TOTAL DATE CHARGES REVENUES NYPA CREDIT DEFERRED DEFERRED Sun -12 2,270,044.48 Jul -12 3,581,715.28 3,492,043.61 161,106.901 (149,978.57) 2,120,065.91 Aug -12 3,578,611.20 2,914,978.35 (44,365.80) (707,998.65) 1,412,067.26 Sep -12 2,646,309.32 3,486,749.45 (47,478.80) 792,961.33 2,205,028.59 Oct -12 2,595,375.45 2,389,147.98 (48,781.28) (255,008.75) 1,950,019.84 Nov -12 2,744,817.28 2,740,129.47 (22,566.16) 127,253.971 1,922,765.87 Dec -12 2,068,712.69 2,987,105.82 (68,965.36) 49,427.77 1,972,193.64 Jan -13 2,523,166.59 3,076,267.45 (70,691.63) 482,409.23 2,454,602.87 Il RMLD STAFFING REPORT FOR FISCAL YEAR ENDING JUNE, 213 F- 1 J CENty'gAlt-HAK&GEB 13 NDD TOTAL JUL 12 AUG 12 SEP 12 OCT 12 NOW 12 DEC 12 JAN 13 GENERAL MANAGER HUMAN RESOURCES COMMUNITY RELATIONS TOTAL 2.00 1.00 1.00 4.00 2.00 1.00 1.00 9.00 2.00 1.00 1.00 4.00 2.00 1.00 1.00 4.00 2.00 1.00 1.00 4.00 2.00 1.00 2.00 4.00 2.00 1.00 1 00 4.00 2.00 1.00 1.00 4.00 EU9INE8E ACCOUNTING CUST0MR SERVICE •• MGNS INFORMATION SYS • MISCELLANEOUS TOTAL ENGIN_ 2.00 7.75 6.25 1.00 17.00 2.00 7.75 6.00 1.00 15.75 2.00 7.75 6.00 1.00 16.75 2.00 7.75 6.00 1.00 16.75 2.00 7.75 6.00 1.00 16.75 2.00 7.75 6.00 1.00 16.75 2.00 7.75 6.00 1.00 16.75 2.00 7.75 6.00 1.00 16.75 8ER_S 4 OPERATIM AGM 860 ENGINEERING LINE METER STATION TOTAL 2.00 5.00 21.00 4.00 0.00 40.00 2.00 5.00 21.00 3.00 5.00 39.00 1.00 5.00 21.00 3.00 8.00 38.00 1.00 5.00 21.00 3.00 8.00 38.00 1.00 5.00 21.00 3.00 8 00 38.00 1.00 5.00 21.00 3.00 B 00 38.00 2.00 5.00 21.00 3.00 B 00 39 00 2.00 5.00 21.00 3.00 B 00 39 00 PR4JFCL BUILDING GENERAL BENEFITS TRANSPORTATION 2.00 2.00 2.00 1.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2 2• MATERIALS MGMT TOTAL a.�SR° 4.00 6.00 3.00 6.00 4.00 0.00 4.00 8.00 4.00 a.00 4 00 8.00 4:00 0.00 4 00 8.00 P,NggpY ENERGY SERVICES • TOTAL 5.50 5.50 4.50 4.50 4.50 4.50 f.50 4.50 f 50 4 50 4 50 4!50 4.50 4.50 5.50 5.50 RNLD TOTAL 74.50 70.25 71.25 71.25 71.2S 71.25 72.25 73.25 CONTRACTORS U0 LINE TOTAL 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2 00 2.00 2 00 2.00 2 00 2.00 2 00 2.00 GRAND TOTAL 76.50 72.25 73.25 73.25 73.25 73.25 74.25 75.25 Iq RMLD \� ) Reading Municipal F Light aeunn.e a o cexunonnr 230 Ash Sven P.O. Box 150 `e Reading, HA 01867 -0250 n):(781)944 -1340 Fax: (781) 942 -2419 Web....nakicom March 22, 2013 Town of Reading Municipal Light Board Subject. Pick Up Truck with Lift Gate On March 6, 2013 a bid invitation was placed as a legal notice in the Reading Chronicle, Lynnfield Villager, North Reading Transcript and Wilmington Town Crier requesting proposals for one Pick Up Truck with Lift Gate for the Reading Municipal Light Department. An invitation to bid was sent to the following 11 companies: Bonnell Motors, Inc. Central Dodge, Inc. Inter -State Ford Truck Sales, Inc. Lannon Chevrolet Liberty Chevrolet Inc. MHQ Municipal Vehicles Moore GMC Truck, Inc. Place Motors, Inc. Sentry Ford ® Stoneham Motor Co., Inc. Woburn Foreign Motors Bids were received from five companies, Bunnell Motors, Inc., Central Dodge, Inc., Liberty Chevrolet Inc., Moore GMC Truck, Inc. and Stoneham Motor Co., Inc. The bids were publicly opened and read aloud at 11:00 a.m. March 20, 2013 in the Town of Reading Municipal Light DepartmenPs Audio Visual Spurr Room, 230 Ash Street, Reading, Massachusetts. The bids were reviewed, analyzed and evaluated by the Interim General Manager and the staff. Move that bid 2013 -27 for: one Pick Up Truck with Lift Gate be awarded to: Bonnell Motors, Inc. for $28,850.00 as the lowest qualified and responsive bidder on the recommendation of the Interim General Manager. The FY2013 Capital Budget amount for this item is $30,000.00 Kev Sullivan David Poison Paula O'Leary / • ATTACHMENT -4 /$ ) /k / ! � km ) §k ) ) ) ) ) ! $ \ | ! k { 4 # \ !!fk! ) \)7\ !!f!! }\ \k/ !!! „ x�( ƒ� ))k)k 2222) lfffff ) a a # 7 � m ■ # \ � k { 4 # \ !!fk! ) \)7\ !!f!! }\ \k/ !!! „ x�( ƒ� ))k)k 2222) lfffff \ � _ \ ® ) # ƒ k { 4 # \ !!fk! ) \)7\ !!f!! }\ \k/ !!! „ x�( ƒ� ))k)k 2222) lfffff RMLD Co)..Ll..t. It"diag Mvoiipel Light Deplranmt NOVIB IOR O8N881TION5 230 Ash Suwt `r P.O. Box 150 Reading. MA 01867 -0250 Tel: (781) 9141340 Fax: (781)942 -2409 Web: w ..rndd.c March 22, 2013 Town of Reading Municipal Light Board Subject: Pick Up Truck with Plow On March 6, 2013 a bid invitation was placed as a legal notice in the Reading Chronicle, Lynnfield Villager, North Reading Transcript and Wilmington Town Crier requesting proposals for one Pick Up Truck with Plow for the Reading Municipal Light Department. An invitation to bid was sent to the following 11 companies: Bonnell Motors, Inc. Central Dodge, Inc. Inter -State Ford Truck Sales, Inc. Lannon Chevrolet Liberty Chevrolet Inc. MHQ Municipal Vehicles Moore GMC Truck, Inc. Place Motors, Inc. Sentry Ford r Stoneham Motor Co., Inc. Woburn Foreign Motors �/ Bids were received from five companies; Bonnet] Motors, Inc., Central Dodge, Inc., Liberty Chevrolet Inc., Moore GMC Truck, Inc. and Stoneham Motor Co., Inc. The bids were publicly opened and read aloud at 11:00 a.m. March 20, 2013 in the Town of Reading Municipal Light Department's Audio Visual Spurr Room, 230 Ash Street, Reading, Massachusetts. The bids were reviewed, analyzed and evaluated by the Interim General Manager and the staff. Move that bid 2013 -28 for: one Pick Up Truck with Plow be awarded to: Stoneham Motor Co., Inc. for $31,003.00 as the lowest qualified and responsive bidder on the recommendation of the Interim General Manager. The FY2013 Capital Budget amount for this item is $35,000.00 Keviq SultivWn '< _G David Polson Paula O'Leary C ! 7 !!!!! ;! §§! !!!!! $ * }kkkf !!!!, ,., ;�•, _!.! .... ..., ;.. ;, ! `,p; M;|\ ;!| ', |�§ |!_, ` l�� ; ; �A`� )|/ .,_ _,_ ,r� . ! ■( is. !§ ;!! _,� ;!; {§ { |( . , . )() § {) } k | |§ § |. \ i\ !` || . , . � !r C n Jeanne Foti From: Jeanne Foti Sent: Monday, February 25, 2013 7:05 AM To: Accounting Group Cc: Kevin Sullivan; Patricia Mellino Subject: Account Payable Warrant - Friday, February 22 Good morning. There were no Account Payable Warrant questions - Friday, February 22, Thanks, Jeanne Foti Reading Municipal Light Department Executive Assistant 230 Ash Street Reading, MA 01867 781- 942 -6434 Phone 781- 942 -2409 Fax lease consider the environment before printing this e-mail. C Jeanne Foti From: Jeanne Foti . Sent: Tuesday, February 26, 2013 7:09 AM To: Accounting Group Cc Kevin Sullivan; Patricia Mellino Subject: Payroll - February 25, 2013 Attachments: Payroll Suggestion - February 25, 2013.pdf Tracking: Recipient Delivery Read Accounting Group Kevin Sullivan Delivered, 2/26/2013709 AM Patricia Mellino Delivered: 2/26/20137:09 AM Read: 2/26/2013799 AM b(ournier@RMLD.corn Delivered. 2/26/2013 7:30 AM skazanjian @RMLD.com Delivered. 2/26/20137:10 AM wmarkie icz @RMLD.com Delivered: 2/26/2013710 AM Wendy Markievvicz Read: 2/26/2013 8.14 AM Bob Fournier Read: 2/26/2013 8:40 AM Good morning. Please see attached Payroll suggestion from Commissioner Stempeck. • Thanks. Jeanne Foti Reading Municipal Light Department Executive Assistant 230 Ash Street Reading, MA 01867 781 - 942 -6434 Phone 781- 942 -2409 Fax Please consider the environment before printing this e-mail, • PLEASE NOTE. COMMISSIONER STEMPECK AND BOB FOURNIEI HAVE DISCUSSED THIS • Reading Municipal Light Department Payroll Removal Sheet Date Commissioner Payroll Comment Employee C jC,,�k 7 JW 71u;,,. ill /L: kit/ aoL /.k r'I f C ✓ G, � c `{Z' -G1? !'- �iv =✓1- 'Y7-e �vr„a.S;A r dx egcL ya tr VP-r 4 tip- �- 4Q 4,, , 4� col, -74 ;, it k2- E-2 A-7 4--7 PLEASE NOTE. COMMISSIONER STEMPECK AND BOB FOURNIER HAVE DISCUSSED THIS Jeanne From Kevin Sullivan Sent: Wednesday, March 06, 2013 3:18 PM To: Gina Snyder; RMLD Board Members Group Cc: Jeanne Foti; Bob Fournier; Dave Poison; Tom O'Connor; Peter Price Subject: RE: Account Payable Questions - March 1 Please see responses to this week's A/P questions below. Ai, "I'suf r do Engineering and Operations Manager Reading Municipal Light Department 781 942 -6407 office From: Jeanne Fob Sent: Monday, March 04, 2013 8:46 AM To: Kevin Sullivan Subject: Account Payable Questions - March I Snyder 1. Century Bank - What are the lock box charges, messenger service, CD - ROM, web inquiry, data transmission + unprocessable returns? These are costs associated with the payment collection processes of Century Bank. 2. Collins - P.O. Reminder - While an emergency on 2/15, should have been done PO same day. PO should have been created for an estimated amount when the service call was placed and adjusted when the actual amount was billed. Administrative staff was out of the office training on the day the service call was placed and the emergent nature of the call was not communicated. Instead the PO was created when the invoice was received for the actual value of the work performed. 3. Crowley -What was this for? This invoice was for work performed in connection with obtaining payment on recalcitrant pole damage reimbursements (3). Crowley also represented the RMLD in Woburn District Court twice. The RMLD has an additional 4 pole damage cases that have not made it to court as of this writing. 4. Image Technology (+others) - P.O. Reminder! Bill date 1/25 PO 2/25. As with all invoices, we are working toward having a closer relationship between purchase order and invoice. Specifically, it was believed that the freight was not charged for the item delivered. I would term the reason that the timing of the purchase order does not match the invoice, an internal misunderstanding between the vendor and an employee. S. Office Depot - Why 2 copies of Windows Pro 8 - don't we have a site license for discounted multiple users? Two copies were installed on two pc's. Microsoft does not give special discounts for multiple users. 6. PURMA- P.O. Reminder! Invoice, 1 /18, PO 2/26. This is a large sum net to have a PO! Mow did that happen? • Original invoice dated 1/18 was sent via email and misplaced until PURMA contacted RMLD on 2/26 to confirm the invoice was received. Once the situation was identified the PO was created without e delay. In the future PURMA should send invoices to Accounting for processing not individual email accounts. 7. Verizon - Is this phone number in use? These charges are for the mobile internet, 8. Wilmington Police - No record of end time Voegelin + Nally 2/6 and on 2/15 it looks like Jepson + Nally were charged from 8 - noon to 8 to 1 to give 8 hours for 5 hours. The time for both Voegelin and Nally on 2/6/13 was 9:30am to 2:30pm. Jepson and Nally worked from Sam to 1pm on 2/15/13. All four police officers were paid 8 hours because they all worked more than 4 hours. Per contract, more than 4 hours worked equals 8 hours pay for Wilmington Police details. Jeanne Foil Reading Municipal Light Department Executive Assistant 230 Ash Street Reading, MA 01867 781 - 942 -6434 Phone 781 - 942 -2409 Fax Cease consider the environment before printing this e-mail. Q Jeanne Poti From: Jeanne Foti • Sent: Monday, March 11, 2013 7:03 AM To: Accounting Group Cc: Kevin Sullivan: Patricia Mellino Subject: Account Payable Warrant - March 8 Tracking: Radpient Accounting Group Kevin Sullivan Patricia Mdlino bfournier @RMLD.corn skazanpan @RMLD.com wmarkiewicz @RMLD.corn Good morning. Dellvesy Del vered 3/11/2013 7:04 AM Delivered: 3 /11/2013 704 AM Delivered'. 3/11/2013 704 AM Delivered: 3 /11/2013 704 AM Delivered 3/11/2013 7:04 AM There were no questions for the Account Payable Warrant - March 8. Thanks. Jeanne Foti Reading Municipal Light Department Executive Assistant 230 Ash Street Reading, MA 01867 781- 942 -6434 Phone 781 - 942 -2409 Fax Please consider the environment before printing this e-mail. Read Read 3/11/2013728 AM • • Jeanne Foti -rom: Leanne Fon Sent: Tuesday, March 12, 2013 7:09 AM To: Accounting Group Cc: Kevin Sullivan; Patricia Mellino Subject: Payroll - March 11 Tracking: R«iplent Accounting Group Kevin Sullivan Patricia Mellino bfournier @RMLD.com skazanjian @RMLO co. wmarkiewicz @RMLD.com Good morning. There were no Payroll questions for March 11. Thanks. Canne Foti Reading Municipal Light Department Executive Assistant 230 Ash Street Reading, MA 01867 781 - 942 -6434 Phone 781 - 942 -2409 Fax Please consider the environment before printing this e-mail. Delivery Delivered 3/12/2013 710 AM Delivered'. 3/1712013 7:10 AM Delivered: 3/12/2013 7.30 AM Delivered: 3/12/2013 7:10 AM Delivered: 3/12/2013 7:10 AM Jeanne From: Sent: To: Cc: Subject: Tracking: Good morning. Jeanne Foti Monday, March 18, 2013 7:16 AM Accounting Group Kevin Sullivan, Patricia Mellino Account Payable Warrant - March 15 Reciplent Accounting Group Kevin Sullivan Patricia Mellino bfournier @RMLD4onn skazanjian @RMLDcorn .arkiMiaz@RMLD.com Wendy Maikiewicz Bob Fournier Delivery Delivered. 3/18/2013 7:17 AM Delivered: 3/18/2013 7:17 AM Delivered: 3118/2013 7;17 AM Delivered. 3/18/2013 7:17 AM Delivered: 3/18/2013 7:17 AM There were no Account Payable Warrant questions for March 15. Thanks. Jeanne Foti Reading Municipal Light Department Executive Assistant 230 Ash Street Reading, MA 01867 781 - 942 -6434 Phone 781 - 942 -2409 Fax Please consider the environment before printing this e-mail. Reed Read. 3/18/2013 7:47 AM Read: 3/19/2013 7:39 AM Read: 3/18/2013 7:48 AM Read'. 3/18/2013 8:30 AM •