The URL can be used to link to this page

Home My WebLink About2014-04-24 RMLD Board of Commissioners MinutesReading Municipal Light Board of Commissioners kECEIVEO Regular Session (OWN CLERK 230 Ash street Reading, MA 01867 I! ADING, MASS. April 24, 2014 1014 NOV 2U A 4 09 Start Time of Regular Session: 5:35 p.m. End Time of Regular Session: 6:57 p.m. Commissioners: John Stempeck, Chairman Philip B. Patin, Vice Chair Robert Sall, Secretary Pro-Tern David Talbot, Commissioner (Remote Participation) Thomas O'Rourke, Commissioner Stab: Bob Fournier, AccountingBusiness Manager Coleen O'Brien, General Manager Humid Jaffari, Director of E &O David Poison, Facilities Manager Mark Uvanni, IT Manager Jane Parenteau, Director of Integrated Resources Patricia Menin% Operational Assistant Citizens' Advisory Board: Dennis Kelley Public: None Call Meeting to Order Chairman Sworpeck called the meeting to order and stated hat the meeting was being videotaped, it is live m Reading o Y. AM tang Remarks qqWmm Stempeck read the RMLD Board of Commissioners Code of Conduct. Chairman Swrapeck welcomed new Commissioner Thomas O'Rourke and Dennis Kelley Citizens' Advisory Board (CAB) member. Chairman Stempeck stated that Commissioner Talbot would be attending the meeting via remote participation due to geographic distance. Discussion of Fiscal Year 2015 Capital and Operating Budgets Fiscal Year 2015 Operating Budget Ms. O'Brien thanked the Board for allowing the staff to present the Operating and Capital budgets this evening. The RML annually files a DPU report which provides the outline and basis for all electric utility budgets, FERC accounting essentially divides electric budgets into operating, the 500 and 900 series numbers and the capital which is the 300 series numbers. Ms. O'Brien stated that this evening each division manager will first provide the highlights of their opemting budget „ Sddi happened, capital outlay. Ms. O'Brien said that the budget has been reformatd to tell a story via a six -year Plan, purposes are backed how we are doing and what we plan to do in the future. The justifications m what we do for all intended in large by engineering standards, science and a sprinkle of politics. Ms. O'Brien said that the objective is straight forward, we want the decal on the side of our trucks that says "Reliable for Generations" to be true. To maintain that Objective a utility must have strategic plans in place that address the electric system, its power supply I and employees along with its financta health. Ms. O'Brien said that these plans address efficiency, safety and procedures to optimize reliability, when formalized and implemented on a consistent basis we will be true to our motto. The six-year plan will remain updated, the operating six- year financials focus on revenues and our statutory duty to cover all of our production costs. The RMLD Capital Six -Year Plan focusses on reliability and the essential enterprise projects and appropriate funding including the Depreciation Fund balances. Ms. O'Brien mentioned one issue is the Percent change a difference from the FFY14 budget, rather a percent differen g ce from what has been spentMMs. O'Brien then is tumed the meeting Mr. Fournier. v distributed arhandout that this evening themeethmg and be presenting the FY15 the Board when they should refer ttoMr. Foamier said that he had it Regular Session Meeting Minutes April 24, 2014 Discussion of Fiscal Year 2015 Capital and Operating Budgets Fiscal Year 2015 Operating Budget This evening they would only sc reviewing the sum reference but it would not be discussed, mary section and that the individual division's detail will be used as a Mr. Fournier reported that the Six -Year Plan shows the current year as seven months • actual and projecting out for the remaining Five months of this fnscal year. The FYIS Operating gadget which will be presented tonight andigoing out four more years to show that picture. Mr. Fournier noted that the bottom line showing the RORpercentage which is the Rate of Return, by statute we are allowed to make up to 8% of ow net plant and those percentages show what we are anticipating based on those revenue and expense projections for those upcoming years. Mr. Fournier asked the Board to look at the first page of the handout Opemfing Budget Draft 1. This draft shows what is contained in this budget and that in FYI the RMLD is projecting to about eighty -seven million dollars in expenses stating that this business is a highly fixed cost business. The purchase power base cost, fuel cost, depreciation, our commitments to the towns and normal accounting processes which are the miscellaneous deductions for loss and disposal and of the $87M, seventy- three million of that is more or less fixed costs or 84% of the budget that leaves about 16% or $14M of semi - variable costs which entails the balance of the budget. Some of the obvious items are labor expense, employee pensions and benefits, overtime, insurances, and training which all are normal accounting activities that take part during the year. Mr. Fournier said that the 16% is really a fraction of the total budget. Mr. Foamier stated that each division manager will explain the main drivers that make up the 2015 budget to arrive at that $2.5 million Net Income. Mr. Fournier said that on the last page of the three page handout, RMLD noticed some changes or adjustments that needed to be made in the $2.5M that was presented in Draft 1. The first two were a re- classification justment from the Capital labor budget to the Operating budget which was a decrease in net income of about $15,800 and a $45 ad the CAB side to be as accurate as possible. Mr. Fournier reported that the big ticket item was the decrease in the tree trimming expense from $757,000 to $640,000 and stated that there will be a Draft IL Mr. Fournier stated that Draft II represents a Net Income of $2.6M and that was what the CAB had recommended at their last meeting. Mr. Fournier said that the CAB is on board with this figure. Mr. Fournier explained that they just covered the summary and the rest of tht pages are the detail and that it breaks out the revenue and other expenses. Mr. Fournier stated that the next section is the description of RMLD's Power Supply which Ms. Parenteau will present. Mr. Pacino entered the meeting at 5:45 p.m. E Ms. Parenteau reported that in the past with several new Board members one of the recommendations was that the various projects and unit entitlements be listed with a description. Ms. Parenmau said that following the description section is a list of the Purchase Power Expenses which are broken down by project type as well as capacity, transmission and energy. Some of the contracts are long -term unit contracts while some are energy only contracts. Ms. wa Pammeau reported that the Capacity total s at $16.3M and Transmission at $12.556M for a total of $28.889M for the FY15 budget. Fuel is projected to come in at $36.249M based on the market conditions at the time the budget was created. Chairman Stempeck asked if there were any questions. Mr. Soli asked if transmission should go up during the yea, is there any response that the RMLD makes. Ms. Parenteau replied yes, currently within ow rate structure the RMLD has a Purchase Power adjustment which looks at the forecasted transmission costs and it compares the actual transmission costs. If there is an increase midstream we are able to make adjustments through the Purchase Power Adjustment costs. Mr. Fournier stated that the division managers would be addressing the key points within their budgets on the Budget/Actual Comparison Summary which is typically found in the monthly Financials. Ms. Pareamau reported on the Integrated Resources and Planning (IR&P) division. Within this division there are two primary focuses one being the wholesale side which is the Power Supply and the other focus in the group is the retail side with the efficiency programs as well as working with the RMLD's commercial customers and municipal towns. The RMLD is integrating both the wholesale side along with the customer base as well as tying into the electrical benefit for the short and long term reliability of the electrical system. The RMLD is actually integrating all of the programs with the electrical side, the wholesale side and the customer side and focusing the Integrated Resources and Planning budget in that direction. Mr. Talbot asked if there was an increase in the efforts in this direction on how the RMLD will help commercial customers. • Ms. Pamiateau replied that the group is increasing their personnel, working on economic development programs to work with the municipalities that the RMLD serves in Wilmington, North Reading, Reading and portions of Lynntield to try to row the kilowatt how sales that allows the RMLD to have lower rates. g Regular Session Meeting Minutes April 24, 2014 Discussion of Fiscal Year 2015 Capital and Operating Budgets Fiscal Year 2015 Operating Budget 6r Talbot asked for clarification of what line item Ms. Parenteau was referring to. Ms. Parenteau replied that it was basically e strategy that the RMLD was moving forward with so there is no one particular line item. It is the direction that the Integrated Resources and Planning group along with the RMLD is working towards in terms of programs and staffing. Mr. Talbot asked if the RMLD has enough communications infrastructure to do what Ms. Parenteau was talking about. Ms. Parenteau replied that she and Mr. Seldom have been actively working with Mr. laffari and the E &O group to utilize an outside vendor in lieu of having active personnel within the Department to assist them with that so that they would have the communication capabilities without utilizing any fiber. Mr. Soli asked if Ms. Parenteau projected load growth for next year and if so how much. Ms. Parenteau replied that the RMLD has projected a flat growth minus the economic development piece, and that over the last five years the growth bas been flat to slightly decreasing. Chairman Stempeck said that there was talk of a meeting from Town Hall for economic growth or developing an economic growth portfolio. Ms. O'Brien reported on the budgets for the General Manager, Human Resources, Community Relations, the CAB and Board. With respect to the General Manager's budget, the legal fees were being categorized in such a way that it did not make a lot of sense. They were reallocated so all legal fees that have to do with Power Supply would be under Integrated Resources & Planning, all legal fees that have to do with employees and unions would be put under Human Resources and all legal fees that may have to do with general questions or Chapter 164 statutory questions would come under the General Manager. Ms. O'Brien stated that there is a part time Tech Adndn that will be going into Integrated Resources & Planning to help with all of these programs moving forward and the other half was put into the General Manager's budget but needed to be reallocated to Community Relations. It is the RMLD's intent that Community Relations will be highly supporting Integrated Resources & Planning so that we can have a much better effort to convey in the public what we are doing on a consistent and regular is. s. O'Brien said that the miscellaneous under the General Manager is APPA, NEPPA and all of the industry related dues. As far as Human Resources is concerned other than the reallocation of the legal fees the miscellaneous has to do with the physicals, drug and alcohol testing,job postings, new employees, want ads and items of that nature. Ms. O'Brien reported that the supplies under Community Relations in general have to do with the Public Power Week open house along with the Rotary and Chamber dues. The CAB is a budget that is based on the Twenty Year plan that has to do with navel, training and consultants. That figure was adjusted slightly back down to $15,000 to comet the typo that Mr. Fournier spoke of Mr. Pacino asked what is appropriate for the CAB and is that in compliance with the Twenty Year Agreement, stating there is a set amount in the Twenty Year agreement that they are to have each year. Ms. O'Brien replied that there was a typo and now this is in accordance with the plan. Mr. Fournier said that Mr. Pacino may not have been here when he reported that there was a $45 adjustment to get the CAB back to a level $15,000 level which is where they needed to be. Mr. Poison, Facilities Manager stated that he is responsible for four budgets. In the General Benefits budget the main drivers are pension increases, OPEB (Other Post - Employment Benefits) and healthcare. Mr. Poison noted that in the Transportation budget which includes the fleet, there is no amount listed there because the money is allocated to the different operating groups and that budget is level funded with no changes. Mr. Pelson reported that the RMLD has developed an eight to ten year plan for vehicle replacement which is in line with industry standards for other utility companies for the larger vehicles. The Building Maintenance budget is for the interior and exterior building maintenance for all the RMLD facilities and that there is no significant change. Materials Management is responsible for all the warehousing and insurances with no major change. Mr. Fournier reported that the Business division is responsible for Administration section as well as internal and external customers. There are no major changes anticipated in FY15 from what we have currently in place except for some of the obligations that are required through agreements that need to be in effect. Them are four departments that comprise of this division and except for normal increases there are really no significant changes happening this year in the Business division. Chairman Stempeck asked if there were any questions. Mr. Pacino asked what the depreciation rate is. Mr. Fournier replied cc percent Regular Session Meeting Minutes April 24, 2014 Discussion of Fiscal Year 2015 Capital and Operating Budgets Fiscal Year 2015 Operating Budget Mr. Fournier said that the last division to report would be Engineering & Operations. He then instructed the group to refer to page seven of the handout. Mr. Jaffari, Director of Engineering & Operations stated that he is in charge of Engineering & Operations, Technical Services and Facilities. The main drivers in the budget for operating expenses are education, preventative maintenance program, tree trimming, metering, street tights, outside services, labor and supplies. Mr. Jaffari stated that education is a main driver in the budget and reported that he and Ms. O'Brien were developing the CDPs (Career Development Plans) for the employees in response to their needs, skills and training that they need in order to do their job more effectively and efficiently. Training programs for the Substation Technical Services and Engineers in the area of the SCADA, Milsoft which is an engineering model, electrical code and outage management system. Mr. Jafftri reported that another driver is the preventative maintenance program which includes hazardous waste, transformer disposal, pole inspection, maintenance of the aged overhead and underground facilities, also replacing the porcelain cutouts, the infra -red scan of the distribution system and substations as well as Ore substation vegetation. RMLD is revamping the cyclic tree trimming program. Mr. Jaffari stated that once we have the engineering load flow model along with reliability indices they would indicate to us the problem areas. Then, we would modify the maintenance program to respond to the needs of the areas and make changes. Expenditures in metering for calibration tools and testing meters, street light maintenance, outside services include the NERC (North American Electric Reliability Corporation) compliance consultants, the standards keep getting increased. Mr. Jaffari reported that the RMLD is getting ready to be in compliance with another NERC standard on BES (Bulk Electric System), which is coming right around the corner. Labor is another driver in the budget, the department needs to hive two more staff in Technical Services in order to officially form the Technical Services group so they can perform testing at the substations. This will insure that RMLD can maintain the substations to make sure that reliability starts with the source for Stations 3, 4 & 5. Mr. Jaffari stated that there will be one new staff person in engineering to maintain the GIS model; right now the RMLD is • trying to bring that model up- to-date, the dam is being compiled with the assistance of consultants. Another new hire as part of the career development succession planning that Ms. O'Brien started is an Assistant General Foreman. The next driver is supplies which include fire- resistant clothing, substation testing a big ticket item at $150,000 to test all devices at the substations including transformers, breakers and relays so we set the baseline for moving forward to start the cyclic maintenance program (3 -5 years) for testing and making sure that the substations are reliable. Chairman Stempeck asked if they are tested once per year, once every three years and asked what the cycle is. Mr. Jaffari replied that the breakers and relays should be tested every two to three years, personal preference for transformer testing is every three years, but can be tested up to every five years. The RMLD equipment has not been tested in so long that the current states is not known at this time, once there is confidence that the relays are functioning properly they can be tested in a two to three year cycle. Chairman Stempeck asked if the training described also have to do with the RMLD performing the underground as opposed to using outside services. Ms. O'Brien replied that the UPG (United Power Group) will be performing a baseline assessment and testing that will double as training for Technical Services employees to get them off the ground. As Mr. Jaffari stated this will give us a baseline of where of our equipment is so that we can come up with a cycle of maintenance program. The RMLD will go with Fischbach & Moore until the end of that contract so we will be able to double up on not only the underground work but also get the training aspect out of it as well. Chairman Stempeck asked what was left on the length of the contract. Ms. O'Brien stated that it was her belief that the Fischbach & Moore contract goes through 2015 and the UPG for the maintenance will be three to four months and then there will be a baseline to put into the program and we are off and running from there. Mr. Jaffari said that they have already developed a cyclic maintenance program that will automatically tell us when the next due date is, this was done for Stations 3,4 & 5 and we are nowjust waiting for the dam to be compiled, once the dam is entered the software will figure out the next due date for retesting. Ms. O'Brien stated that was done in- house. Mr. O'Rourke asked on education and development, how much is instructor -led versus online and how much is in -house versus outsouroed. Mr. Jaffari replied that mostly the training will be outside and that some of the in -house training he can provide himself, as well as Ms. O'Brien and other employees. For example; the Milsoft training will initially be done by the vendor then the subsequent training for engineers he can do himself Mr. Jaffari stated that because of his affiliation with ECNE and the fact that he teaches courses for them training will be discounted for the RMLD employees. Regular Session Meeting Minutes April 24, 2014 Discussion of Fiscal Year 2015 Capital and Operating Budgets mcal Year 2015 Operating Budget r. O'Rourke asked if there was much training online. Mr. 7affarl replied that it is his experience that for technical courses you really need in class interaction with an instructor and the classroom environment is much better for learning. Remote courses are much better for refresher courses once you have the basic understanding and knowledge from the classroom environment. Mr. Founder as he stated at the outset that there would be Draft B this draft will show approximately $100,000 increase in Net Income from Draft I from $2.5M to $2,652,997. The CAB did take a vote at 5:0:0, and made a recommendation to accept that figure for the FY15 Operating Budget. Fiscal Year 2015 Operating Budget Mr. Pacino made a motion seconded by Mr. O'Rourke that the RMLD Board of Commissioners move to recommend the Fiscal Year 2015 Operating Budget with an Adjusted Net Income of $2,652,997 as presented. Chairman Stempeck polled the Board. Motion carried by a polling of the Board: Mr. Talbot; Aye, Mr. Pachro; Aye, Mr. O'Rourke; Aye, Mr. Soll; Aye, and Chairman Stempeck, Aye. Motion carried 5:0:0. Mr. Soli stated that he would like to make an amendment to the motion Mr. Soli made a motion that the non -fuel FY15 Operating Budget with an Adjusted Net Income of $2.65M as it was be approved and that the fuel budget target a $2.5M a year end balance with progress towards these goals be reported to the RMLD each month. Chair m r Stempeck asked Mr. Soli to comment on the amendment and to explain why. Mr. Soli asked if someone would second the motion. Chaimum Stempeck asked if there was a second. Mr. Pacino replied that he did not understand the amendment and it would be appropriate to explain what it is that is trying to be accomplished. Mr. Soli replied that the number 4id not change and said that in the spring we got into trouble because the Board could not see that the real bottom line was missed as opposed to businesses where they have one bottom line we have two. One bottom line we are allowed to make profit, the other is the fuel charge that we are allowed to pass through to the customers but not make any money and this motion mixes those two up. Mr. Soli said that we really should keep our eye on two balls, how we are doing towards the meant that is 8% taking out the fuel and then how is the fuel doing towards meeting the reserve. Chairman Stempeck said so this is to provide more visibility and transparency into what it is, it is not depending on the budgeted numbers but tracking it on a month by month or quarter by quarter basis. Mr. Soli stated that we do get the numbers, but no one has been subtracting out the fuel. Ms. O'Brien asked Ms. Parenteau to speak to this unbundling and make a recommendation on the motion. Ms. Parenteau said that it is her understanding with the new Cost of Service and how the Department is going to be unbundling thew rates so that the distribution charge will be separated with the power supply charges which will include capacity, transmission and fuel. Ms. Parenteau believes the point that Mr. Soli is making is because the way the rates are currently structured part of the power supply costs are embedded in the base rates which make it difficult to track as he had said. The Cost of Service proposal and the directive that the consultant is working on is to unbundle those rates so that there will be much more transparency in terra of the power supply being a pass through and the 8% that the Board is speaking of Ms. Parenteau stated that this should help the Board in team of those financials and the transparency of the power supply skewing the overall bottom line. Chairman Stempeck asked then that this will accomplish the same thing that Mr. Soli is asking for. Ms. Parenteau replied yes. Chairman Stempeck stated that if it does not then it can be addressed in tears of another motion at the next meeting or the appropriate meeting to then further unbundle it so we get an idea of what is happening and then asked Mr. Soli if that would serve the purpose. Chairman Stempeck asked how difficult is it to meet Mr. Soli's motion, is it merely a redistribution of the financials to basically reconstitute them or is it significantly more difficult to do the unbundling at this point in time. Mr. O'Rourke said that the amount is not changing so we can approve the amount as originally motioned it sounds like it is a reporting or displaying data issue which he is in favor to have visibility on items that are not so easy to find but that could be accomplished with an addendum or summary to be reported monthly. Mr. O'Rourke is not sure it changes the motion. Ms. Brien said that we spoke to this issue which is one of the objectives of unbundling, when you unbundle you are separating all of power supply including fuel which are all pass - throughs and the RMLD does not make money on any of them. Ms. O'Brien stated that we are working towards unbundling and to do that will be part of the Cost of Service presentation Regular Session Meeting Minutes April 24, 2014 Discussion of Fiscal Year 2015 Capital and Operating Budgets Fiscal Year 2015 Operating Budget • Ms. O'Brien believes that the billing system is going to be able to handle that, so we working towards that objective and is not sure the purpose it serves right at this very moment when we are working towards what Mr. Soli had requested. Mr. Soli said that in the past Cost of Service studies the capacity and transmission we made money on. Mr. Soli recollected that when the new set of rates came out the PPA that was on the bill then went into the base charge. Ms. Parentean said that we do not make money on it what happens is that it is a part of revenue and when you look at the Mr. Fournier's calculation in terms of what the Department is able to cam a mmm on that is our net plan which comes out of the revenue so we never make any money on capacity or transmission. Ms. Parenteau stated that we collect revenue for our rate stmcrure and are able to earn a return on the net plant. Chairman Stempeck said that he would like to table this to an online discussion. Ms. Parenteau stated that we could accomplish what Mr. Soli is requesting through a reporting mechanism, unbundling the rates would accomplish this and that is scheduled to be implemented for this this fiscal year. Chairman Stempeck asked if Mr. Soli would withdraw his motion and move to table it to see if the reporting can accomplish the same mechanism. Mr. Soli replied that we have two balls that we should keep our eyes on and previously we only kept our eye on one and it got us in trouble. Mr. Patina commented that he did not fully understand what Mr. Soh was trying to accomplish. Chairman Stempeck said that they should look at it and consider it absolutely but right at this moment he did not understand it either. Mr. Pacino said that they should vote on the budget, instruct the Department to take a look at this and report back to the Board at the next meeting in order for the Board to get a better understanding of what this is trying to do. Mr. Soli stated that was fine. Chairman Stempeck said that he would like to go back to the original motion and if everyone is in favor a roll call vote would have to be taken because Mr. Talbot is participating remotely. Discussion of Fiscal Year 2015 Capital and Operating Budgets Fiscal Year 2015 Capital Budget Ms. O'Brien reported that the RMLD staff has done an excellent job generating the new capital outlay which now includes • similar to the Operating Budget a six-year plan. While we are here tonight to focus on FY15 and have provided to you where we expect to land at the end of FY14, what is scheduled for FY15 and then what is planned for FY16 through FY19. New focus items that were mentioned previously include the GIS which is the mapping system that produces the geographically correct map of our system assets, the GIS as Mr. Jaffmi stated is the basis for our engineering modeling software that works to determine the accuracy of our system, coordination and promotion as well as our future reliability planning addressing capacity and Flexibility to meet the challenges of the future including areas that we may be able to get additional kilowatt hour sales. The second area that was discussed previously is the lack of system maintenance where we are developing a predictive asset management system that would tie into the GIS and serve as a basis for assessing the current condition of our assets, with the appropriate data loaded, it will support predictive maintenance to extend the life of the equipment and schedule replacements prior to any equipment failure. The LED streetlight conversion of which the pilot report is completed the Board will be receiving a copy of that this week. It includes converting approximately 8,000 lights at less than S3M for significant energy savings to each of the towns and a decrease in maintenance. Engineering is finalizing the pilot program. It targets the areas for the pilot program LED light placements within each town. Ms. O'Brien said that she along with Ms. Parmtem and Project Engineer Brian Smith are meefing with each of the Town Managers and the CAB representatives from each town to go over the pilot. Ms. O'Brien reported that the streetlight ram is being produced and will be presented at the Cost of Service presentation. Inventory is now being stocked with LEDs and the RMLD will no longer carry the conventional lights and the towns will be credited for any lights that the RMLD replaces. Ms. O'Brien turned the focus m the capital outlay spreadsheet where it shows the six-year plan for Facilities, MIS and the System. On the right hand side is a tickler with an explanation of the objective of the project and on page two is where the funding schedule can be found for the plant depreciation. Ms. O'Brien explained that some of the items that go beyond FYIS it does not necessarily mean the money will be spent it is a place holder and that we are taking a conservative approach to make sure that we have the funding. The table lists the starting amounts what we might be looking for and any type of force accounts where we might gel any state reimbursements or bonding and it shows where we will land. Mr. Polson reported that the 14VAC budget was a multi-year plan that was discussed and approved in previous years and reflects is the plan out over a period of two years. Regular Session Meeting Minutes April 24, 2014 Discussion of Fiscal Year 2015 Capital and Operating Budgets Fiscal Year 2015 Capital Budget Jff�jhc Muster Site Plan is very similar that was approved last year with place holders for FY16 and FYI for anticipated work Wt will be the result of the Muster Site Plan. The Station 1 Rehabilitation Project will be part of the overall site plan and was moved out pending the outcome of Muster Site Plan for the best use of the buildings. The Covered Storage is the same situation falling under the site plan as well. Mr. Poison stated that the Oil Containment Project is new and that the RMLD has a consultant studying the facilities. Mr. Poison reported that right now the RMLD is in compliance and has a Spill Prevention, Control and Countermeasure Plan (SPCC) and that we are evaluating the facilities for opportunities to mitigate any potential risk that we might have. The RMLD will have studies performed this year and work performed next year. The Security Upgrades are to make sure that the RMLD is compliant with the NERC and FERC requirements at the substations and that the RMLD on a regular basis makes security improvements at its facilities. Mr. Polson stated that over the next few years there will be added security at the substations. Mr. Polson said that the Rolling Stock Replacement Project was developed as a ten year plan. The plan helps to make sure that we are levelizing our vehicle replacement and reducing maintenance costs on the fleet Chairman Stempeck asked if the Rolling Stock was getting more reliable. Mr. Poison replied that we have reduced some of our stock including trucks, trailers and vehicles and we are constantly evaluating the stock while reducing the fleet. Mr. Poison stated that we do need in maintain enough vehicles to address situations like severe weather and to ensure that the vehicles are all operating correctly. The history of the fleet is that they have all been up and naming during critical times and credits this to a very good vehicle maintenance plan. Mr. Poison said that this too will be evaluated as part of the Organizational Study. Mr. Uvanni reported on three items in the Capital Budget, Hardware and Software Upgrades and Licensing. The fast project the Great Plains/Cogsdale Update. The RMLD will be updating the backoffice Financial and Customer Service Management ?ware which is about ran years old and is at the end of its lifecycle. A conversion/migration will be performed and will take approximately the rest of calendar year 2014 and could possibly go into calendar year 2015. Mr. Uvanni stated that it is going m be a big project personnel wise because it touches everybody and there will be a lot of training and testing involved. Mr. Uvami said that there will be Hardware and Software Upgrades and Licensing and that this year the hardware line item for the most part encompasses fuming everything into virtual machines. Mr. Uvanni reported that we are just about done but there are a few left and then to virtualize all of the servers, the related software, the backup software, storage area networks and replication software that goes with it. On the pure software side Mr. Uvanni stated that money is always put aside for custom programming to build up the integration between Outage Management, GIS, Utility Authorization Number Management System and other specific software for backup and replication of virtual machines and related systems. Mr. Uvanni reported that the Great Plains/Cogsdale is the big project this year. Chairman Stempeck asked if there had been my issues relative in this Heartbleed Bug virus. Mr. Uvanni replied that it is a wide spread issue and that people use open source software for SSL for Secure Sockets Layer connections so it affected roughly two - thirds of all secure websites. Mr. Uvanni stated that we have not run into it yet, the big companies like Microsoft, the Gurgles and a lot of the major banks have already patched it but obviously it caught a lot of people by surprise. Mr. O'Rourke asked on the Customer Service software update what is the expected go live date and is there much of a potential impact on Customer Service when that happens. Mr. Uvanni replied that the go live date is the second or thud week of December, we really want to do it by the end of the year but it really is a big undertaking mostly training and extensive testing. There are so many things that it touches from metering to service orders, credit and collections, receivables, the bill itself which will have a change of format. Mr. O'Rourke asked if it was a hard cut or do you ran parallel systems. Mr. Uvanni replied that you nun parallel for certain things but it is very difficult to ran parallel in everything, you almost create more work and more confusion by trying to tie everything out. The bottom line is to make sure that your receivables bill for bill ties out that is really the main concern . Mr. anni said that if he were to choose a bill on the current system with all things being equal is that bill going to look the same. �s is the bottom line on the new system so that is really where you test. Regular Session Meeting Minutes April 24, 2014 Discussion of Fiscal Year 2015 Capital and Operating Budgets Fiscal Year 2015 Capital Budget Mr. Uvanni stated that he had been through a few of these before and there is a process that they will follow and as far as • customer service for our customers the impact is minimal to none. Mr. Jaffxi reported on the capital authorization improvement projects for his section starting with Project 108, Relay Replacement - Station 4. Currently at the Gaw substation there are electromechanical relays that are not capable of bringing analog data to the Remote Terminal Unit (RTU) back to the SCADA only one phase. In order to enhance the capability and use the full capacity of the SCADA system we need in replace those with solid state relays so we can bring more power quality data back especially power factor and the harmonics. Mr. Jaffan reported on Project 130, Remote Terminal Unit (RTU) Replacement- Station 3 and said that there are actually two RTU replacements one at Station 3 and one at Station 5. Station 5 should be complete by the end of June to mid -July 2014 and Station 3 will be done in FY2015. The current RTU at Station 3 is not capable of providing all the data such as voltage, current and the effect on harmonics by upgrading that it is going in be operating the SCADA system now they will be synced in to bring more data back for engineering and analysis. Project 122, Engineering Analysis Software & Data Conversion this project along with Project 125, GIS go hand in hand. Mr. Jaffari explained earlier that GIS is a platform for engineering models and once we have the data in the GIS database completed then we can convert that model into an engineering Milsoft model. Then, the Department will have an up -m -date load flow model that we can perform all sorts of engineering analysis. Mr. Jaffari reported on stale- funded project on West Street, Reading. This project is scheduled for construction completion in FY2015 to widen the road. The next project is Pole Line Upgrade- Lowell Street, Wilmington. This area is of old construction and needs to be brought up-to-code by upgrading the poles, wires and circuits. Mr. Pacino asked where they are going to widen West Street. Mr. Jaffari replied that it would be close to Route 93. The next project discussed was Distribution Protection & Automation. Mr. Jaffan reported that once they have the working load flow model and the Reliability Study recommendations, this will provide the road map for automation in order to further sectionalize the circuits. Mr. Jaffan said adding more protective devices prevents tripping breakers due to a fault at the end of a circuit and it minimizes the affected outage areas. Mr. Jaffari stated that you have to have a road map for planning tan to fifteen years ahead. Mr. laffni reported on the SCADA System Upgrades stating that the Surveillance Software is upgraded for free and that they are also going to provide us with the Outage Management System upgrade for free. However, there are some costs involved for installation and training and that will be about $60,000. Once the SCADA System is brought up -to-date with the RTUs at the substations we will have the capability to bring data back from substations to SCADA for engineering analysis. This is going to enhance the capability of the engineers in order to do all sons of engineering analysis. The LED Street Light Pilot Area project will be in four areas, one area in each of the few towns. Mr. Jaffan reported that there will be eighty lights then subsequently the following years FY 16, FY 17 and FYI the RMLD will be spending close to $1.2M each year in order in change out all the street lights m LED efficient lights. Mr. Jaffari reported that the Outage Management Software & Integration project goes hand in hand with the SCADA System upgrade. The Predictive Asset Management Program project which is a number of predictive programs and once we have the working model we can develop these programs in order to protect our assets. Mr. Jaffari reported on the Substation Test Equipment project, as we form the Technical Services group so they can test the substations we will need to provide them with the testing equipment. Mr. Jaffari stated that right now we rely on UPG and once the RMLD staff is trained we will be taking the ownership and will be testing our 13.8 kv equipment from A -Z including transformers and breakers. However, for some 35kv devices and 115kv we will still have to rely on outside services like UPG. Mr. Patron left the meeting at 6:45 p.m. The Arc Flash Study project, Mr. Jaffari reported this is another requirement that we need to meet This study is going to be performed as soon as the Milsoft model has been completed. Mr. Jaff ni said the Are Flash Study will we which devices need to completely shut down in order to perform switching or maintenance work safely. Regular Session Meeting Minutes April 24, 2014 Discussion of Fiscal Year 2015 Capital and Operating Budgets Fiscal Year 2015 Capital Budget f fr. Jaffari reported that the RFP has been sent out for the Organizational/Reliability Study to provide a road map for the next %pwenty years with an outline on the priority on how we need to allocate the money and the spending in order to make sure that we are going in the right direction with a plan in place. Mr. Jaffari stated that the rest of the projects me continued and are historic to previous years FY 13 continuing to FY19. Mr. Soli said that he was the Board representative at the CAB meeting and had written down a few notes that may be of interest. It looks like the depreciation for next yen will be at 3% the General Manager had said that sometime in the future that it might be necessary to fund this plan to increase the depreciation to 5 %. Ms. O'Brien stated that what is in here beyond FYI is place holders, it does show that one way of doing it is that the DPU allows you to increase your depreciation up to 5% and you have to file. This targets areas like the facilities, if we are looking at the efficiency use of all of our facilities and we would spend a certain amount of money to renovate the architectural building next door or whatever we are going to do with that along with the LED street lights we would ramp up to five then back down to thee. Mr. Soli said that within the Capital Budget between improvements that are probably pretty well thought out but we do not know what the escalation is and these are prosperous times and other things that look to be just place holders there is about $ IM in here of what seems to be somewhat or quite iffy. Mr. Soli asked if the Board could get a report of how the plan is fleshing out. Chairman Stempeck said that those place holders are there because we are doing things new and differently and that we are setting that foundation for the future and sometimes it is very difficult to we into the future unless you have them in place. Chairman Stempeck stated that clearly we are all about reliability and lowering the costs where we cau. Mr. Jaffari said reliability, efficiency and productivity are the three main ingredients behind all the forecasting of the capital improvements moving forward. Ms. O'Brien stated that prior to this budget you never saw what happened in FY14, now we are letting you know how we are doing with last year and as soon as this gets approved and we get into FY15 then you will get a how we are doing in FYI with h of the budgets. Ms. O'Brien said that Mr. Jaffari would go over them quickly during the meetings. Chairman Stempeck 'd that clearly the visibility of the future years is the way it should be done. Ms. O'Brien stated that there was talk at one of the meetings that we me upgrading the Ballardvale Area to Target. Ms. O'Brien said that we are probably looking at some kind of substation in that area and are waiting for the consultant. Mr. O'Rourke said that it gives you visibility and enables discussion and if you are not on the radar screen you do not have a chance to talk about it. Mr. O'Rourke asked that something like the GIS in the systems area is there much support or interface with the Information Technology group because a lot of your areas have a heavy IT component. Mr. Jaffari replied that there is close coordination and at the last meeting it was mentioned that he and Mr. Uvanni had provided a technology roadmap and would share that with him. This roadmap shows how all the different technologies come together and it shows haw they managed. Ms. O'Brien said that it operates on a super highway like a service bus where you have outage management, metering, data, SCADA where this all integrates in so it can all be managed where not one system can be down and effect everything else. Fiscal Year 2015 Capital Budget Mr. Soli made a motion seconded by Mr. O'Rourke that the RMLD Board of Commissioners move to approve the Fiscal Yew 2015 Capital Budget dated March 28, 2014 in the amount of $5,849,673 as presented. Chairman Stempeck polled the Board. Motion carried by a polling of the Board: Mr. Talbot; Aye, Mr. O'Rourke; Aye, Mr. Sofi; Aye, and Chairman Stempeck, Aye. Motion carried 4:0:0. (Mr. Pathan was not present for this motion.) Adjournment At 6:57 p.m. Mr. Soli made a motion seconded by Mr. O'Rourke move to adjourn the Regular Session. Chairman Stempeck polled the Board. Motion carried by a polling of the Board: Mr. Talbot; Aye, Mr. O'Rourke; Aye, Mr. Soli; Aye, and Chairman Stempeek, Aye. don carried 4:0:0. (Mr. Patron was not present for this motion.) A true copy of the RMLD Board of Commissioners minutes as approved by a majority of the Commission. Robert Soli, Secretary Pro -Tam - RMLD Board of Commissioners READING MUNICIPAL LIGHT DEPARTMENT FY 2015 • CAPITAL BUDGET MARCH 28, 2014 Coleen O'Brien General Manager U FY15 CAPITAL BUDGET TABLE OF CONTENTS Capital Improvements Spreadsheet ..................................................... Page 1-2 Facilities Management ................................................... .......................Page3 -16 0 Management Information Systems ( MIS) ................... ...........................Page 17 -25 System ................... ..................... Page 26 -77 • 11 r1 �J Reading Municipal Light Department SYSTEM PROFILE (based on CY 20131 SERVICE TERRITORY 51 square miles serving Reading, North Reading, Wilmington and part of Lynnfield TOTAL OPERATING REVENUES $78,928,607 NUMBER OF CUSTOMERS 29,599 ANNUAL PEAK LOAD 167,759 kW on July 19, 2013 ANNUAL SALES 696,522,779 kWh PLANTVALUE $128,824,441 (Gross) $69,875,363 (Net) SUPPLY VOLTAGE 115 kV Station 4: (3) 60 MVA Transformers (2) 40 MVA Transformers SUPPLY CAPACITY 260 MVA Connected, 200 MVA Firm Station 3: (2) 60 MVA Transformers 120 MVA Connected, 60 MVA Firm DISTRIBUTION SYSTEM VOLTAGE 13,800 volt Wye 4,160 volt Wye OVERHEAD PRIMARY LINES All 335 miles UNDERGROUND PRIMARY LINES All 135 miles DISTRIBUTION TRANSFORMERS 3,729 — 253.37 MVA Capacity DISTRIBUTION SUBSTATIONS (3) 380 MVA Capacity 17,225 poles Ownership: 65 %Verizon, 35 %RMLD Ownership By Town: North Reading —RMLD Lynnfield — Verizon Reading • east of Main Street — Verizon UTILITY POLES • west of Main Street, east of West Street, south of Prescott Street — Verizon • west of West Street —RMLD • west of Main Street, north of Prescott Street —RMLD Wilmington • all poles with 35 kV sub - transmission circuits, and Concord Street— RMLD • all other locations in Wilmington — Verizon APPLICATION SOFTWARE Billing and Accounting Great Plains /Cogsdale General PC Windows 2012, 2008, SQL, Office 2013, 2008, 2012 Exchange 2010, Windows 7, 8, 8.1 Sharepoint Itron FORECASTING Matrix ND (Daily Forecasting — Ener Services ENGINEERING ANALYSIS Milsoft (in process) 3/28/2014 E u 0 sc e3GC1 2 o xR 5 ii i ^ £ ; E Tl 11 Till n sor ssxxrrxe e e xnn n r nn aYx xre• „• •a o se �- a55 M9909 a55 s" 5 5E 555 X5;$555 5- yy qt F S 9j C Y 3� 1 I $ i � 11 "s 55 121 1 i ij "d 3 5KE 5 5Sd S E E E� "e.s T 5x E Sn s 555 d z:- s Y.s 5� .SEE d d �8 E 9 5 -' Etlp F �5S 5 5gd� S -8 SG gg gg ff ; 3 0 sc e3GC1 2 o xR 5 |a !! ; !§ |� |� .| 0 F '1 . ....Z..., ,,,,.,ll..,.•| !° ��•!!!'� ,| � .•j | ! ; 2; •g!•!!! |!`�! ! ;�! |•!•!: ! `.! !§ |� |� .| 0 F M n i1 LJ FACILITIES MANAGEMENT Continuing Projects: Page# Projectp 88 HVAC System Upgrade 4 121 89 Master Facilities Site Plan 6 129 Rehabilitation of Station 1- Pending Master Facilities Site Plan 124 Building Covered Storage - Pending Master Facilities Site Plan 120 New Projects for FY1S: X Oil Containment Facility Construction 9 TBD 86 Security Upgrades - All Sites 11 TBD Annual Projects: X Rolling Inventory 14 11g FY15 Capital Budget — March 28, 2014 Page 3 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: HVAC System Upgrade - 230 Ash Street SCHEDULE: FY14 -16 EMimeletl: FY14 $501000 EOtimBled: "IS 5250,000 ESTIMATED TOTAL PROJECT COST: PROJECT#: 121 RMLO RMLO CREW CREW CREW OTHER OTHER MATERIAL ITEM WEEKS LABOR VEHICLE LABOR VEHICLE aam. TOTAL 4 -Me0 COSTS COSTS 609,DT9 SWD,M 3399,079 ce 00ilem, Chilleq entl Total RMUD Craw Wooka TOtal UM C.. Wraka TOTAL Page 5 I m ,a $350000 FY13 ESTIMATED COST: $399,079 EMimeletl: FY14 $501000 EOtimBled: "IS 5250,000 ESTIMATED TOTAL PROJECT COST: $699,079 LIT/ ® CAPITAL PROJECT SUMMARY Project Name: Master Facilities Site Plan Project Schedule: FY14 -17 Project Manager: David Poison Facilities Manager Reason for Expenditure: The Master Facilities Site Plan will continue into FY15 finalizing options and creating bid documents to begin addressing building use and storage allocation requirements. The final plan will also include the photovoltaic recommendations as part of the Facilities Master Plan. Brief Description/Scope: Complete the assessment of the office space, Station 1, garage and leased warehouse space. Finalize recommendations and create a long- term strategic plan based on current and future needs working collaboratively with other Town agencies. Barriers: None anticipated at this time. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) Status Update From Prior Fiscal Year: FY14 The study will be Influenced by the Organizational Study and additional collaboration with the Town. Facilities Master Site Plan RFP will be sent out at the end of March 2014. FY15 Capital Budget - March 28, 2014 Page 6 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET • CAPITAL PROJECT NAME: Master Facllitles Site Plan SCHEDULE: FY14 -17 Unit Cast $2742 Oer week Unit Cost 0 PROJECTM 129 Unit Cost RMLO RMLO 0 UnitCest CREW CREW NEW ITEM CREW LABOR VEHICLE OTHER OTHER MATERIAL WEEKS COST COST LABOR VEHICLE AMISC TOTAL $38,000 $38,000 consultant to perform Master Plan for Ash Street Camws. TOTAL $12341 FY 15 ESTIMATED COST: $50,$41 Estimated: FY14 .$40,000 :'ESTIMATED PROJECT COST: b`$100341.- Page 7 EM I $12,341 $12,341 Unit Cast $2742 Oer week Unit Cost 0 I�—I L J • Unit Cost Unit Cost 0 UnitCest TOTAL $12341 FY 15 ESTIMATED COST: $50,$41 Estimated: FY14 .$40,000 :'ESTIMATED PROJECT COST: b`$100341.- Page 7 EM �r i 0 FACILITIES MANAGEMENT NEW PROJECTS FY15 Capital Budget -March 28, 2014 Page 8 16 CAPITAL PROJECT SUMMARY n U Project Name: Oil Containment Facility Construction Project Schedule: FY14 -15 Project Manager: David Poison Facilities Manager Reason for Expenditure: Perform a study and take temporary measures related to all containment at Station 3 and the Ash Street Campus Brief DescriptiordScope: RMLD stores new and used oil filled equipment in multiple locations. This project provides engineering and design services, centralizes the location of the equipment and provides temporary containment measures. There will be two containment areas, one at the Ash Street Campus and a second at Station 3. Permanent concrete containment areas will be installed in FY15. Barriers: Engineering, Design & Permitting Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FY15 Capital budget —March 26, 2014 Page 9 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: Olt ConMinm t Facility Construction SCHEDULE: FY2D14 -15 PROJEUt. TEO RMLD RMLD CREW CREW CREW OTHER men MATERIAL ITEM WEEKS LABOR VEHICLE LABOR VEHICLE AMISC. TOTAL 4.Man COSTS COSTS $80.000 $E0,)W TOTAL ,gg ggg FYI5 ESTIMATED COST: $80000 E08mated: F 14 480100) ESTIMATED TOTAL PROJECT COST: $180,000 Page 10 r► CAPITAL PROJECT SUMMARY V Project Name: Security Upgrades — All Sites Project Schedule: FY15 -19 Project Manager: David Poison Facilities Manager Reason for Expenditure: Security enhancements at our substations and other owned and leased facilities. Brief Description/Scope: Scope of work includes upgrades and modification or our cameras, access control points, entry point alarms, and perimeter fencing. Barriers: None anticipated at this time. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FYI Capital Budget — March 28, 2014 Page 11 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: Seculily Upgrades - AII Sites SCHEDULE: FY15 -19 PROJECTO: TBD TOTAL 510.970 $50,000 RMLD RMLD $60,970 ElSmet.d: FYIS $25,000 CREW CREW CREW OTHER OTHER MATERIAL $25,D00 ITEM WEEKS LABOR VEHICLE LABOR VEHICLE 6 MISC TOTAL Page 12 4 -Men COSTS COSTS $10,970 $50,000 $60870 end mOdgka$on! b 9CC659 COnV0 p01ntl, 81011118 !M fencing. TOTAL 510.970 $50,000 FY1S ESTIMATED COST: $60,970 ElSmet.d: FYIS $25,000 FY17 $25,DOO ma $25,D00 FY19 $25,000 ESTIMATED PROJECT COST: $160,970 Page 12 L FACILITIES MANAGEMENT ANNUAL PROJECTS E !I FY15 Capital Budget —March 28, 2014 Page 13 *► CAPITAL PROJECT SUMMARY Project Name: Rolling Stock Replacement (vehicles, trailers and fork trucks) Project Schedule: Annual Project Manager: David Polson Facilities Manager Reason for Expenditure: Replace vehicles based on an 8 -10 year cycle to reduce maintenance costs and improve reliability. Vehicles removed from the fleet will be disposed of under RMLD Policy No. 2 "Surplus Material." Brief Description/Scope: In FY 2015 four (4) new vehicles will be purchased and six (6) vehicles /trailers will be retired. Barriers: Lead time for line trucks is +/- 300 days once the order is placed. Bid process and award must be completed early to ensure delivery within Fiscal Year 2015. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) Status Update From Prior Fiscal Year: FY15 Capital Budget —March 28, 2014 Page 14 TABLE 1: ROLLING STOCK CAPITAL OUTLAY Vehicle ID B Year uat Mileage ate Cvrtenl NLleage Average Annual hlainlenanre Costa Department Vehicle Type 3014 2015 Comment 3 2W5 l2/29/1J 29,848 $96035 pool Toyota p w surplus 3 New VeMele -Sub Melntenanee Tech Services Box Tmck $150,000.00 4 2005 1/14/11 78,000 81.60!8] Meter Fmd F150 Su[ IUB 7 2007 10/31/13 104,663 $],9]3.33 Customee Service Ford Eeeape w0l be shrpluttdwhen new vehicle la received $MAIq.W 9 m 12/19/13 196,939 $15,5615 We Inter- 40B.clet Surplus 10 2014 2/1/14 0 $0.00 We Inter - 40'Bucket $183,24410 11 1999 12/30/13 0,427 $14,618.05 We Fmd 55 Bucket Surplus 13 2008 1/21/14 91,638 $ ;038.16 We GF Fend Escape will be suTlural when new ehice b received $ %'"m 14 1998 12/4/13 62.081 $11,413.n We Inter - 45'Ulgdrk $M,750.00 30 1999 10/17113 73,993 $1,32265 We Ford Van m 30 M14 2/1/14 0 $0.00 Sbtinw Ford - F I50 31 M14 2/1/14 0 E0.00 EBgineeeng Fotd -F -150 35 2002 9/16/13 12,495 $3,0'/6.35 Line Ford F150 r$29,%5.00 m 2001 12/11/13 49,041 $16,315.01 Line Slerling -55B 1,et 44 2014 2/1/14 0 $0.00 line Intem SYMM 48 2000 1212/13 49,128 $]1,558.]8 We Chevy-40'Bucket $umius TS 1979 n/a I.p We Nevlen Cable Surplus Scrap T6 19]9 n/a Insp We Nevlen Cable surplus no 1984 n/a lnsp one Nevlen Cargo $umlus Scrap Tll 1984 n/a In, We Nevlen Cargo u lus Scmp Page 15 J E a FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: Rolling Stock Replacement RMLD RMLD CHEW CREW HEW ITEM CREW LABOR VEHICLE OTHER OTHER MATERIAL WEEKS COST COST LABOR VEHICLE SMISC $150,000 562,000 $231.]50 SCHEDULE: FY15 PROJECT k: 118 TOTAL 5150,000 eMCla 552,000 a6kle azR1,75p �Micle 0 0 0 0 TOTAL S -}.]50 TOTAL PROJECT COST: $433,750 Page 16 MIS Continuing Projects: Puee4 Proienn None n/a New Projects for FY15: X Great Plains /Cogsdale Update 19 T8D Annual Projects:' X Hardware Upgrades 22 127 X $oftware Upgrades 24 128 • FY15 Capital Budget — March 28, 2014 Page 17 0 • "I A&I NEW PROJECTS FY75 Capital Budget —March 28, 2014 Page 18 ® CAPITAL PROJECT SUMMARY Project Name: Great Plains/Cogsdale Upgrade Project Schedule: FY15 -16 Project Manager: Mark Uvanni MIS Manager Reason for Expenditure: We are currently using Great Plains/Cogsdale Version 10 as our financial management and customer service management (CSM) software. Version 10 will no longer be supported by the end of 2014 (calendar) or shortly thereafter. We will be doing a'data conversion' upgrade to Great Plains/Cogsdale 2013. The costs Include software, hardware, training, consulting, custom programming and project management. System will provide new work order system capability and integration with Engineering and customer data -bases for improved customer service and system reliability. Brief Description/Scope: Upgrade will be a'data conversion' update to Version 2013 (most current stable build). It will update current CSM and financial systems to the newest version. Project will encompass software, hardware, consulting (CDM), training, custom programming, and project management (RMLD and CDM) Barriers: Successful interfacing of various adjunct systems. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a 0 FYI Capital Budget — March 28, 2014 Page 19 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: Greet Pleins/Cogsdele Upgrade RMLO PMLO CREW CREW CREW OTHER OTHER ITEM WEEKS LABOR VEHICLE LABOR VEHICLE 4Man COSTS COSTS SCHEDULE: FY15-16 PROJECT f: TBD MATERIAL a MISC. TOTAL molmo SS10.w0 S1w,= flw,w0 T 0 T 0 P., M TOTAL f4fp pfp FY15 ESTIMATED COST: .5390,000 Esllmata4: E 16 3M." ESTIMATED TOTAL PROJECT COST: $400,000 G V C MIS ANNUAL PROJECTS FY15 Capital Budget — March 28, 2014 Page 21 CAPITAL PROJECT SUMMARY Project Name: Hardware Upgrades Project Schedule: Annual Project Manager: Mark Uvanni, MIS Manager Reason for Expenditure: This is an amount annually reserved for failed and /or obsolete computer and related equipment. This budget item is also used for unforeseen purchases which may be necessary. Brief Descriptlon/Scope: General hardware purchases plus the following specific projects. • Vmware ESXI Servers plus contract labor • Upgrade EMC SAN Storage • New GIS Server Barriers: None anticipated at this time. Iftw Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) We Status Update From Prior Fiscal Year: n/a FY15 Capital Budget —March 28, 2014 Page 22 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET • CAPITAL PROJECT NAME: Hardware Upgrades SCHEDULE: FY15 PROJECT p: 127 RMLO RMLC CREW CREW NEW CREW LABOR VEHICLE OTHER OTHER MATERIAL ITEM WEEKS COST COST LABOR VEHICLE tMISC TOTAL slam SEC.= sST,Geo General OaMwam PUmEevs.M Netexelim. 2AI weeks MS AMnInlKwam UMCOet tt,m] Perweek tt+,mB szt,am Vmwen ESXI Server que CmtrW LeEOr sx,mo s+t,om s+s,sm UpxreJe EMO SANB . wMlu u L¢4YNnismwn u..0 a...� ttsm a.sm tlo,mo TOTAL so. m SE!sw TOTAL PROJECT COST: -;j-OL7M Pags 2s Im 12 t► CAPITAL PROJECT SUMMARY 16 Project Name: Software and Licensing Project Schedule: Annual Project Manager: Mark Uvanni, MIS Manager Reason for Expenditure: Each year RMLD must renew existing software licenses and purchase new software, either to update existing users or for new users. Additionally, new software may be added at the request of various operating units. This item includes these ad hoc purchases as well as more specific items (outlined below) which are anticipated at this time. Brief Description/Scope; In addition to the standard software and licensing purchases described above, we anticipated the following: • Custom programing /development for OM /UAN /GIS /GPS • Veeam One -an additional cluster license • Sharepoint on -site standard and 80 CAL's Barriers: None anticipated at this time. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FY15 Capital Budget - March 28, 2014 Page 24 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: Software and Licensing SCHEDULE: FY15 PROJECT 128 RMLO RMLD $112600 CREW CREW NEW COST: CREW LABOR VEHICLE OTHER OTHER MATERIAL ITEM WEEKS COST COST LABOR VEHICLE 6MISC TOTAL 58,coo 6ao,000 Sae 000 General aoAwere purcheam. 6501000 650,000 Cum. pm6rammkly0evekipmenl OMNANR3ISrOPS 61,000 67,500 66.500 Veean One - a00aunal VM CW9ar LiCenee $2,807 par week • 62,500 615,000 617,500 ShamPalnt On -Site StenOaM aw 90 CAL's O.SS vgek(s) MIS Aftinistration TOTAL 56.500 $112600 TOTAL PROJECT COST: F ;j22w Page 25 r� �U.IHTu Continuing Projects Update: Page# Project # 116 5W9 OH Reconductoring— Balladvale Area 27 101 % Upgrade Old Lynnfleld Center URDs (Cook's Farm) 29 104 39 4W5 -4W6 Tie 31 105 9 Relay Replacement—Station 4(Gaw) 33 108 X Remote Terminal Unit(RTU) Replacement - Station 3 35 130 X Engineering Analysis Software and Data Conversion 37 122 X GIS 39 125 New Projects for FY15: X Routine Construction 89 Force Account (Mass DOT) West Street, Reading 42 TBD 9 Pole Line Upgrade— Lowell Street, W 44 TBD 39 Distribution Protection & Automation 46 TBD 39 SCADA System Upgrade 48 TBD 96 LED Street Light Conversion 50 131 9 Outage Management Software & Integration 52 TBD 9 Predictive Asset Management System 54 TBD 9 Substation Test Equipment 56 TBD 9 Arc Flash Study 58 TBD 39 Organizational 5tudy /Reliability Study 60 TBD Annual Projects X Transformers, Capacitors & Reclosers 63 116 X Communication Equipment (Fiber) 65 126 X Meters 67 117 X URD Upgrades — AII Towns 69 106 H Step -down Area Upgrades — AII Towns 71 107 X New Service Installations 73 Commercial /Industrial 112 Residential 113 X Routine Construction 77 114 FY15 Capital Budget — March 28, 2014 Page 26 0 CAPITAL PROJECT SUMMARY Project Name: 5W9 Reconductoring — Balladvale Area, Wilmington Project Schedule: FY14 -16 Project Manager: Peter Price, Chief Engineer Reason for Expenditure: 5W9 is a 336 spacer cable circuit that feeds Ballardvale Street and Research Drive in Wilmington. This feeder construction dates back to the 1980s. This circuit has seen heavy loading during the summer peaks and is experiencing load growth. This load growth includes the new Target Store and associated retail mall as well as some proposed projects on Research Drive. The project will add to the long -term reliability of the area and contingency planning by increasing the feeder capacity. Brief Description/Scope: Reconductor existing 336 spacer cable with 795 spacer cable, upgrade brackets as needed, and re -use existing messenger cable. Barriers: This is a Verizon set area. Also, we will need a flagman to reconductor over the railroad tracks on Middlesex Ave in North Wilmington. Change in Scope of Work from Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: FY14 The framing for Wildwood Street was started in January. The primary cable for this project is now in stock. We may have two crews work on this project to get the FY14 scheduled work completed before June 1. FY15 Capital Budget - March 28, 2014 Page 27 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: SW9 Reconducloring- Balladvale Area, W. SCHEDULE: FY2014 -16 PROJECT#: 101 RMLD RMLD CREW CREW CREW OTHER OTHER MATERIAL ITEM WEEKS LABOR VEHICLE LABOR VEHICLE aMISC, TOTAL 4Mm COSTS COSTS 5.0 593.693 514,720 $85,000 $173,419 lnelaa 25,2001eal of 795 spacer raps, (5,4(0circuK leM). Re+ue exlM9lg 3O $35,135 55,520 $10,000 SS0.855 Wormal, dwaaa BD pogo w0a new - ellaneouasleavae, wnrsacbn. Unit Cast 511,712 St,840 per weak 0 3,628 53,629 e Details If epplkede) 524.807 $24,90] 10.0 weal Total RMLD Crew Week. 11.0 Total UIG Crew W eeW TOTAL _=120,1127 $20,240 $28.427 $75.900 HIS ESTIMATED COST: $252,504 EebnaWd: FY14 $169,494 Esllm aid: FYI6 $196,480 ESTIMATED TOTAL PROJECT COST: $616,481 Page 28 • J C CAPITAL PROJECT SUMMARY Project Name: Upgrading of Old Lynnfield Center URDs (Cook's Farm) Project Schedule: FY14-15 Project Manager: Peter Price, Chief Engineer Reason for Expenditure: This is one of the original Lynnfield underground subdivisions and is over 40 years old. This area does not conform to the Department's current construction standards. When this system was installed, the design called for fiber duct, 2,400 volt primary cable, and no manholes. With this type of design, an underground cable failure could result in a significant outage for some customers. Brief Description/Scope: The first phase of this project was the Townsend and Needham Road Subdivision (FY12). The second phase is Russell Road, Trog Hawley and Charing Cross (FYI 3). and the third phase will be Cooks Farm, Cortland Lane, and Tophet Road (FY14). This project would require building a new underground distribution system within the public way. This involves the installation of manholes, conduits, transformers, underground primary and secondary cable, pull boxes, etc. The transformers would be ® replaced in the same location. The Department would intercept the customer's existing service and place a pull box on the property. If the customer wants to upgrade their service at the same time, they would be responsible from the pull box to the house. In FY14 the Department will begin Cooks Farm lane, Cortland Lane, and Trophet Road. Engineering will petition the Town for permission to install the underground electric facilities and meet with the customers affected by this construction to explain the project and scope of work. 11 This project will require procuring an excavation contractor and may require the complete repaving of the subdivision. Barriers: None anticipated at this time. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: FY14 This project will start in FY14 and continue into FY15. This was the same case for the previous two subdivisions. The construction season for this type of project runs from mid -April to mid - October. FY15 Capital Budget — March 29, 2014 Page 29 12.0 $68]1] S4B0 EBBiW FISCAL 2015 CAPITAL BUDGET COST SHEET 1 CAPITAL PROJECT NAME: UnmdnpgELMnflAd Center URDe(Coohb Fenn) SCHEDULE: FY1415 PROJECT t: 104 UNt Coat CREW CREW NEW • CREW LABOR VEHICLE OTHER OTHER MATERIAL ITEM WEEKS COST COST LABOR VEHICLE AMISC TOTAL 4m n S26 BO> ComplMe lnpaEpbn Of: 0.0 E93,fi93 $14,720 f1 413 8,000 feet 01 um .,A11 5,4 Rotor WG 1N primary 1,M had of = 4T won0ary 12.0 $68]1] S4B0 EBBiW Total RMLD Craw Walks 8.0 Total UIO Craw Weakn 12.0 TOTAL 20.0 $93,893 $14.M $10&041 $aEp W FYI S ESTHAATED COST: $278934 Estimated: FY14 $174,000 ESTIMATED TOTAL PROJECT COST: $390934" Papa 30 J 1 Unit Cap 0 $14,517 UNt Coat W,629 • Wit GV I D $24,80] S26 BO> Total RMLD Craw Walks 8.0 Total UIO Craw Weakn 12.0 TOTAL 20.0 $93,893 $14.M $10&041 $aEp W FYI S ESTHAATED COST: $278934 Estimated: FY14 $174,000 ESTIMATED TOTAL PROJECT COST: $390934" Papa 30 J 11 11 11 CAPITAL PROJECT SUMMARY Project Name: 4W5-4W6 Tie Project Schedule: FY14 -15 Project Manager: Peter Price, Chief Engineer Reason for Expenditure: With the development of the Addison Wesley Property and South Main Street, there is a need to shift a portion of the 4W6 distribution onto another circuit. Circuit 4W5 was extended down Oak Street from West Street many years ago in anticipation of the development of South Main Street. This project would complete the circuit extension down Oak Street to Summer Street. This project will add to the long -term reliability of the area and switching contingencies. Brief Description/Scope: Install approximately 1,500 circuit of 556 spacer and messenger, conductor 1,500 feet of secondary cable. Verizon to replace six (6) poles and the RMLD will install two (2) laminated poles. Barriers: None anticipated at this time. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: FY14 Laminated poles will be set by RMLD in FY14. Waiting for Verizon to replace other poles. FYI Capital Budget — March 28, 2014 Page 31 FISCAL 201S CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: 4W5 - 4W5 Tie HMLO RMLD SCHEDULE: FY2Di4 -15 PROJECTm 105 ell I 1 $11,712 $1,81 4/0 0 1,5001eet ...o cJaq rade 15 Miscellanaoes pole Me Femtom. en I meteBMS. TOW RMLD Cm WaoKa 3.0 Total UAT Crow weeks TOTAL Page 32 $3,000 $3.000 $2,400 s1.4s2 68,a3t TOTAL $37,878 $18552 $3.030 Sz 400 sta5z se,631 $36,136 $5520 $10,382 $18275 FYIS ESTIMATED COST:. $70312 Eetimated: FY14 $35,000 FSTIMA7ED' TOTAL PROJECT COST: ;$1x53121 0 2 Fm CREW CREW NEW CREW LABOR VEHICLE OTHER OTHER MATERIAL ITEM WEEKS COST COST LABOR VEHICLE aM130 4 Man Install 2 $23,423 $3,8$0 $10,875 ell I 1 $11,712 $1,81 4/0 0 1,5001eet ...o cJaq rade 15 Miscellanaoes pole Me Femtom. en I meteBMS. TOW RMLD Cm WaoKa 3.0 Total UAT Crow weeks TOTAL Page 32 $3,000 $3.000 $2,400 s1.4s2 68,a3t TOTAL $37,878 $18552 $3.030 Sz 400 sta5z se,631 $36,136 $5520 $10,382 $18275 FYIS ESTIMATED COST:. $70312 Eetimated: FY14 $35,000 FSTIMA7ED' TOTAL PROJECT COST: ;$1x53121 0 2 Fm 0 CAPITAL PROJECT SUMMARY Project Name: Relay Replacement - Station 4 (Gaw) Project Schedule: FY15 -15 Project Manager: Nick D'Alleva Technical Services Manager Reason for Expenditure: Replace the existing electo- mechanical protective relay systems on the 15kV feeder breakers at The Gaw Substation. These relays will be able to provide more information back to the SCADA; they also store vast amounts of data for down - loading and evaluating. Brief Description/Scope: Replace relays and rewire feeder cubicle for installation of this equipment previously purchased. Test and commission new relays. Barriers: None anticipated at this time Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) none Status Update From Prior Fiscal Year: This project is a carry-over from FY14. FY15 Capital Budget —March 28, 2014 Page 33 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: Relay R. RMLD CREW CREW LABOR ITEM WEEKS COST Total RMLD Crew Waaka Total WE Crew Weeks Iplacemenl RMLD CREW VEHICLE COST - Sla0on 4(Gaw) SCHEDULE: FY15 -16 PROJECT 9: 108 NEW OTHER OTHER MATERIAL LABOR VEHICLE b MISC TOTAL S1,114 51,114 525,812 525,812 $14,107 114,1 DT U 405 Se,405 $2,552 52,582 TOTAL 439,919 $10.091 FY15 ESTIMATED COST: §50,000 Estimated FY16 $97,000 Pape I ESTIMATED. TOTAL'. PROJECT COST: $117, 1 0 CAPITAL PROJECT SUMMARY Project Name: Remote Terminal Unit (RTU) Replacement — Station 3 Project Schedule: FY15 Project Manager: Peter Price, Chief Engineer Reason for Expenditure: The existing RTU was installed in 2000 and uses a legacy TeleGyr 8979 protocol. This was done so that it would work with the old TeleGyr SCADA system. The existing RTU is not IP addressable, nor does it have an Ethernet connection. The RTU needs to be upgraded to add the functionality of the existing SEL relays at Station 3. A new RTU will give the Department the ability to communicate with the SEL relays, similar to what is being done at Station 4. Brief Description /Scope: Bid and purchase a pre -wired RTU enclosure, with required technical support, that will replace the existing RTU enclosure at Station 3. Contract with SEL for technical assistance and any required hardware for the interconnection. Station Supervisor and Senior Technicians will re -wire and terminate control wiring within the new RTU cabinet. Engineering will program and configure SCADA for new comm -line and RTU Barriers: None anticipated at this time. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: FY14 This project was carried over from FY14. FY15 Capital Budget —March 28, 2014 Page 35 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: RTUReplacement Station3 SCHEDULE: FYIS PROJECTS: 130 HW o RMLo CREW CREW CREW OTHER "ER MATERIAL .ITEM WEEKS LABOR VEHICLE L100R VEHICLE IMISC TOTAL 4Men COSTS COSTS 55.WB S55W0 '. rox RN W W PmMeO eiRloeue NvwlleneaM eSMPnent. IeWA SenpTTaRi LSbor. 7.743 Moults& mMro 6CAOApdnW IWm fto o lion cebinet to rew M. 11,012 511.012 10,&12 ❑e�3M Cmew DNP wmBn W IaoM SCAO KWWK FM T.MI RMLD Cn. WMu TWM OID Q— Wnks TOTAL MM3 AV o00 FYI B ESTIMgTEO COST: BBA 84f Ppe b 0 G CAPITAL PROJECT SUMMARY Project Name: Engineering Analysis Software & Data Conversion Project Schedule: FY14 -15 Project Manager: Peter Price, Chief Engineer Reason for Expenditure: This software purchase and data conversion will allow the Engineering department to perform engineering analysis on the distribution system. Internally, the department would be able to perform fault current calculations, arc flash calculations, load flow and voltage drop calculations, load balancing, voltage regulator settings, etc. This new software would work with the existing coordination software that the Engineering department uses. Brief Description/Scope: Take the existing databases and newly collected as -built data, and core ESRI data for the GIS project and have it converted for use in the electric model by the Milsoft and Windmill software provider. Purchase the software necessary to perform the engineering analysis and to update map /land -base data. Purchase of server for software and databases. ® Barriers: GIS as -built data completion. C Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: FY14 RMLD needs to work with contractor to gather data for the ESRI model before Milsoft completes final data conversion. FY15 Capital Budget — March 28, 2014 Page 37 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: Engineering Analysis SORWIVe B Data Convertimn RMLC RMLY CREW CREW CREW OTHER OTHER ITEM WEEKS LABOR VEHICLE LABOR VEHICLE 4 Men COSTS COSTS To lRMLO Crew Wmkm Te lWO crew W.N SCHEDULE: FY14 -15 PROJECTS: 122 MATERIAL S MISC TOTAL ]55000 f55,OW • I a TOTAL E55.000 FYIS ESTIMATED COST: SSS,WO Esllmatack PY14 S2S.000 ESTIMATED PROJECT COST: S8O000 J Pp. 38 0 • CAPITAL PROJECT SUMMARY Project Name: GIS Project Schedule: FY14 -15 Project Manager: Hamid Jaffad, Director of Engineering and Operations Reason for Expenditure: GIS and GPS technology is used by electric companies to locate and map all of its assets in a geographically accurate format. This will facilitate system modeling, including contingency and reliability planning, developing system protection and coordination studies, creating maps, developing maintenance programs. This will enable us to make sound operational decisions by having data attributes in an engineering accurate scale of units. The RMLD GIS database does not reflect an as- built condition of the electric system with the data that has been inputted. Over 60 % of data has never been entered and no attribute list per system property unit has been developed. Critical electrical data that is necessary to build a valid engineering model is missing because the GIS database has not been fully updated since its creation. The goal of the GIS project is to evaluate the RMLD GIS database integrity and its data accuracy system wide, collect more field data, and bring the ESRI database up -to -date. RMLD is creating a template of desired GIS attributes to include the Milsoft WindMilMap required attributes for engineering analysis. RMLD does not have enough resources to collect pole by pole data throughout its service territory as this is a tedious and time consuming task. Staff augmentation using an outside data collector will be performed along with a data integration effort. Brief Description/Scope: Staff augmentation for comprehensive data collection to produce GIS as -built Barriers: None anticipated at this time. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FY15 Capital Budget —March 28, 2014 Page 39 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: DIE SCHEDULE: FY14-15 • PROJECT t. 150 TOTAL 11S0.. FY1S ESTIMATED CAST: 5160,000 Eelim0lea FY14 5501000 ESTIMATED PROJECT COST: $200,000 P., 40 J RMLO AMID CREW CREW CREW OTHER O R MATERIA- REM WEEKS LABOR VEHICLE LABOR VEHICLE 6MISC TOTAL 4 -Wn COSTS COSTS S+s m +soaoo Sien nuamaRM4on m T wmw.I V ieN. nsa agile cwernm. � O O wn wn O umlcml I uMCm O Ptiu OelalM (fleg4Wle) e la) 1U., Crvl TOTAL 11S0.. FY1S ESTIMATED CAST: 5160,000 Eelim0lea FY14 5501000 ESTIMATED PROJECT COST: $200,000 P., 40 J 0 • L SYSTEM NEW PROJECTS FY15 Capital Budget - March 28, 2014 Page 41 • CAPITAL PROJECT SUMMARY E Project Name: Force Account — West Street, Reading Project Schedule: FY15 Project Manager: Peter Price, Chief Engineer Reason for Expenditure: MassDOT is reconstructing West Street, In Reading, from the Woburn town line to the intersection of Summer Avenue. The reconstruction includes the widening of the roadway, the installation of traffic signals and the resurfacing of the road. This work will require the RMLD to relocate poles, transfer construction, lower and raise manhole covers, and relocate conduits. Brief Description/Scope: Replace approximately 38 poles and 15 anchors, frame and transfer primaries, secondaries, transformers, services and street lights on 42 poles, relocate primary conduits and cables feeding Westcroft Circle, and lower and raise manhole frames and covers. All work except for the lowering and raising of the manhole frames and covers is reimbursable. Barriers: Verizon is responsible to replace 4 of the poles. The RMLD will need to petition the Town of Reading for any of the pole and conduit relocations. The MassDOT has approved these relocations, but they must be formally presented and approved by the Town. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FY15 Capital Budget — March 28, 2014 Page 42 1 $11,712 $1,5410 513,552 Fm Man •1 $5,726 $40 55755 $10,088 510.000 $27,255 52],288 Total RMLO Crew Weak. 11.0 Total U/O Crew Weeks 1.0 TOTAL $134,554 $20,260 $36,176 5]0500 TOTAL PROJECT COST: §2231510 Page 43 FISCAL 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: FA (MessDOT) West Street, R SCHEDULE: FV15 PROJECT%: TEID RMLO RMLD CREW CREW NEW CREW LABOR VEHICLE OTHER OTHER MATERIAL ITEM WEEKS COST COST LABOR VEHICLE $MISC TOTAL 4Man 0.5 552,102 $0.290 $23,000 583,982 approximately 38 P.. .d hom on West Sleet between Street eM Summer avenue. June Coal $11,712 51,8410 Sea bore at lee 5.5 $64,414 $10,120 $7,500 502,030 a2 mbM nar,forapaaer primary toaM And fiery fable antl IrenalBr. 1 $11,712 $1,5410 513,552 Fm Man •1 $5,726 $40 55755 $10,088 510.000 $27,255 52],288 Total RMLO Crew Weak. 11.0 Total U/O Crew Weeks 1.0 TOTAL $134,554 $20,260 $36,176 5]0500 TOTAL PROJECT COST: §2231510 Page 43 O CAPITAL PROJECT SUMMARY Project Name: Pole Line Upgrade — Lowell Street, Wilmington Project Schedule: FY15 Project Manager: Peter Price, Chief Engineer Reason for Expenditure: This section of Lowell Street currently has three (3) spacer cable circuits and two (2) aerial cable circuits. These poles are under - sized, under-classed, and over 30 years old. This project will upgrade the poles to the proper strength and height class, create the proper clearance between utilities, and benefit the long -tens reliability of the system. Brief Description/Scope: Replace approximately twenty poles with 55' -i poles along a section of Lowell Street in Wilmington, between West Street and Woburn Street. Frame poles with new hardware and transfer the three (3) spacer cable circuits, the two (2) aerial cable circuits, two (2) gang operated switches, four (4) primary laterals, secondaries, services, and street lights. Barriers: This is a Verizon set area, but they will not set 55' poles. Therefore, RMLD will set poles. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FY15 Capital Budget —March 28, 2014 Page 44 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET RMLD 2 2 wxMM • CAPITAL PROJECT NAME: Pde Line Upgrade - Lowell SlreeLW SCHEDULE: FYIS eaw.r PROJECTS: TBO I zo pol x krx (9) xnn regw 0.a $4%040 $7,30 $7,300 J.. M m zlnow,u hraaM em nmna 691,SCE um cal $11 712 s1.e <a ...,..x UIICM $1V12 SLNao �um can O • En01re LM.) SI05.<W WILD RMLD 2 2 wxMM CREW CREW CREW OTHER OTHER MATERIAL eaw.r ITEM WEEI(5 LABOR VEHICLE LABOR VEHICLE 611013C TOTAL Rmx OMMa Plxpl.w.) 10.0 xtlek(R COSTS COSH Un,t Curl 4WJ xrxrt 5.0 SWASS 39,200 512,000 6m.)Se Im1a1 eRp'oNnMelVlweNy (20) 55 11 painmlpMl R. Wal 3l)e RSIh. Twmr+Na rWOhumdma (Si ape[Br[pFM tlrHW UWMO(2) eenal c0W tlrtWLL Unn Cast S11,712 61.840 pxwxx I zo pol x krx (9) xnn regw 0.a $4%040 $7,30 $7,300 J.. M m zlnow,u hraaM em nmna 691,SCE um cal $11 712 s1.e <a ...,..x UIICM $1V12 SLNao �um can O • En01re LM.) SI05.<W 7859 n,zSS 2 2 wxMM I Unit cas+ Gees eaw.r FYISESTIMATED CDBT: $1)3,330 $24.em sx4,ar7 Rmx OMMa Plxpl.w.) 10.0 xtlek(R Un,t Curl Mai xrxrt TRNAMLDCraw Wxb &0 T.. UID Crew Wxb TOTAL SI05.<W SiS.NO f21003 $11.300 FYISESTIMATED CDBT: $1)3,330 Papa 43 0 CAPITAL PROJECT SUMMARY Project Name: Distribution Protection & Automation Project Schedule: FY15 -19 Project Manager: Peter Price, Chief Engineer Reason for Expenditure: Increase distribution line protection. Brief Description/Scope: Install 13.8kV feeder reclosers on 13.8kV feeders to increase feeder protection along the primary distribution feeders serving all four (4) communities. Barriers: None anticipated at this time. Change In Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: ( n/a Lw- FY15 Capital Budget — March 28, 2014 Page 46 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: DisWOutlon PmAeldion and Automadm SCHEDULE: FYIS-19 $69;270 E510ated H16 PROJECT#: TBD $30,000 RMLO RMLO $30,000 FY19 CREW CREW CREW OTHER OTHER MATERIAL ITEM WEEKS LABOR VEHICLE LABOR VEHICLE E MISC TOTAL COSTS COSTS 4 -Man quell and lnelalL 110 $11.112 $1,840 $BIp00 $84,582 R.Msem y41h SCAM ready TaUl RMLO Crew W..b 1.0 T.%l WO Crow Waelo Torsi $0 E0 $2,178 $2,178 $2.481 32pB1 $11.712 $1.00 $415:2 $0 651000 FY15 ESTIMATED COST: $69;270 E510ated H16 $30,000 H17 $30,000 FY18 $30,000 FY19 530,000 ESTIMATED PROJECT COST: $199,210 •I LA Peg. 47 J • CAPITAL PROJECT SUMMARY Project Name: SCADA System Upgrades - Hardware Project Schedule: FY15 Project Manager: Peter Price, Chief Engineer Reason for Expenditure: SCADA Servers are original to the SCADA installation in 2000. Servers are running on Microsoft Server 2000 and need to be upgraded to the most current version. Brief Description/Scope: Purchase two new servers, one work station, two 16 port Ethernet switches, four 32" monitors and related hardware and cabling. Survalent to provide on -site technical assistance, as required. Barriers: None anticipated at this time. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) I n/a Status Update From Prior Fiscal Year: n/a FY15 Capital Budget— March 28, 2014 Page 48 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET u CAPITAL PROJECT NAME: SCADAUpgade SCHEDULE: 1-V15 PROJECT P: TED TOTAL slo,xe a62eoo FY15 ESTIMATED COST: 533,985 PNa49 • RAW R&D CREW CREW CREW OTHER OTHER MATERIAL ITEM WEEKS LABOR VEHICLE LABOR VEHICLE 6MISC TOTALL 4NM COSTS COSTS $¢0,0W 620,000 PuN hw (21161 -M Mm W: ewers aM MekOeeNware 510,000 P¢e apvOr 310,000 310,000 Onrelle MGNaI ecalalv¢a. UNI Cal E1.`AO fI,500 PuMUaE4YrcW wukMauon eMbur (41ma11on (azl Um Cal 515,000 315,0.0 PurUieae OM99yelem wMxam and IatlnYCalewvlwelaay5lam i�Agtllm Ias4iM400romwl. UNI Coel stp,e5e sta,eee Eagreallq L.eW: L OWaew Umf l sius aisY � O um cRn TOTAL slo,xe a62eoo FY15 ESTIMATED COST: 533,985 PNa49 • 0 CAPITAL PROJECT SUMMARY Project Name: LED Street Light Pilot Area — All Towns Project Schedule: FY15 Project Manager: Brian Smith, Engineering Project Manager Reason for Expenditure: Street light technology has advanced greatly over the years and has moved towards the installation and use of the more energy efficient and longer lasting LED replacements. This project will allow us to evaluate the performance of, monitor the energy usage of and get feedback on the lighting provided by this newer technology. With this information we can determine if this is the path that the RMLD will choose for street lighting in the future Brief Description /Scope: Purchase and install approximately 80 LED street lights, 20 per town, in the pilot area that is chosen. The replacements will be a direct replacement with an LED fixture that has approximately the same lumen output as the original fixture. Barriers: None anticipated at this time. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FY15 Capital Budget — March 28, 2014 Page 50 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: LED Street Light Pilot SCHEDULE: FY15 PROJECTS: 131 RMLD RMLD CREW CREW NEW CREW LABOR VEHICLE OTHER OTHER MATERIAL ITEM WEEBS COST COST LABOR VEHICLE OMISC TOTAL 2 Men 1 35,855 $YN $24,400 j31,1)E PM Prv".A,. I.MIOMRpuree. M LED Light MdureB°M PWRIcelH UMI Cpl 55.556 3920 5305 Muhl $800 £600 P.M.. MBIeR BM Bttl¢le v Tdrk l+Edr: 52519 50,519 IM°I Me4n dM 9ccFeld JUN, Cos, 52519 pr wx0 I UM1 CM PWCe DeW4: 32481 52,481 1 wNL(B( UrM CmI $2.461 UNI Coe, TOTAL $8,375 $020 02,401 114000 Teta1 RMLD Crew Week$ 1.00 PYI5ESTIMATEOCOST: 836,775 Total JIG Cmw eel. PBge 51 O a ® CAPITAL PROJECT SUMMARY Project Name: Outage Management Software & Integration Project Schedule: FY15 Project Manager: Peter Price, Chief Engineer Reason for Expenditure: To create a live, real time Outage Management System (OMS). Once integrated, this will give the RMLD a real time OMS system that will import network connectivity from ESRI and Milsoft, customer information from Cogsdale, and outage data from the Itron Fixed Network. Brief Description/Scope: Survalent Technologies, the RMLD's SCADA manufacturer will provide the Survalent SmartOMS software for the dual redundant servers, the System Configuration Status interface, the MultiSpeak GIS Batch interface for ESRI and WindMil, the MultiSpeak CIS interface for Cogsdale, the MultiSpeak AMR interface for the Itron Fixed Network, and the OMS Outage Portal. Survalent to also provide one week of remote training for the programming and maintenance of SCADA Master System and OMS, one week on -site installation, commissioning, and assistance. Also Includes the first year of support for ® the OMS. Barriers: Standard MultiSpeak interfaces are included. Survalent will evaluate and quote custom interfaces as required. New SCADA servers and the WindMil projects must be completed prior to this project. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FY15 Capital Budget — March 28, 2014 Page 52 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET • CAPRALPROJECTMAME: Owage Manegenem Software &lntegralior SCHEDOLE: PY15 PROJECT#: TOD 510.000 510,000 Cumam Pmpmnminp Unit Coal O un3 cam O t UM can Enynarkp umr $14,517 311,511 d wiek(sl Urvt Cost Sa 5J4 Pdlu U." (lleppllutlel waekla) I Unit Caal I Al- RMLD MILD CREW CREW CREW OTHER OTHER WiTERUM. 380,51] ITEM WEEKS LABOR VEHICLE LABCR VEHICLE IMMC TOTAL aMa Cosm COSTS SaD,pop SBD,D00 SolMere PurcAaae 510.000 510,000 Cumam Pmpmnminp Unit Coal O un3 cam O t UM can Enynarkp umr $14,517 311,511 d wiek(sl Urvt Cost Sa 5J4 Pdlu U." (lleppllutlel waekla) I Unit Caal I Al- EIABI] #mom FYlB ESTWATED COST: 380,51] Paw" u 0 CAPITAL PROJECT SUMMARY 11111. Project Name: Predictive Asset Management Program Project Schedule: FY15 -19 Project Manager: Nick D'Alleva Technical Services Manager Reason for Expenditure: This project is necessary to either purchase or design an Asset Management System that will track and trend the condition of RMLD's distribution and substation equipment. Brief Description/Scope: The RMLD will be exploring a predictive asset management program that can track the maintenance of distribution and substation equipment. The system will also allow RMLD to address maintenance issues that might arise in similar types of equipment. Barriers: None anticipated at this time. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FY15 Capital Budget — March 28, 2014 Page 54 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: Pratliclive Asset M »apemen) AMLD RMLO CHEW CHEW CREW OTHER OTHER ITEM WEEKS LABOR VEHICLE LABOR VEHICLE ". COSTS COSTS SCHEDULE: FY15-19 PROJECT* TED MATEWK A MIBC TOTAL 181=00 C TOTAL 5SO.0oo FY15 ESTIMATED COST: 550,000 EatlmmeS Fula sea,oao EtHmeled $3a,Onn 118 E611 Mod ll1 E60 melee FYt9 S3a,00n 530,11Jp ESTIMATED PROJECT COST: $350,000 P., 55 0 0 CAPITAL PROJECT SUMMARY Project Name: Substation Test Equipment Project Schedule: FY15 -18 Project Nick D'Alleva Manager: Technical Services Manager Reason for Expenditure: This project is necessary to purchase several pieces of test equipment to be used by the Technical Services department. Brief Description/Scope: The RMLD is formulating a distribution and substation preventative maintenance program. In order to perform many of the electrical tests, additional test equipment will need to be purchased. Barriers: None anticipated at this time. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FY15 Capital Budget — March 28, 2014 Page 56 FISCAL 2015 CAPITAL BUDGET COST SHEET • CAPITAL PROJECT NAME: Substation Test Equipment SCHEDULE: FY15 -18 PROJECT #: TBD RMLD RMLO CREW CREW NEW CREW LABOR VEHICLE OTHER OTHER MATERIAL ITEM WEEKS COST COST LABOR /EHICLI &MISC TOTAL $121,000 $121,000 $0 a $0 TOTAL 0.0 0 $0 $0 $0 $121000 FY15 ESTIMATED COST: $121,000 FY16 $50,000 FY17 $50,000 FY18 $50,000 ESTIMATED PROJECT COST: $271,000 Page 57 CAPITAL PROJECT SUMMARY Project Name: Arc Flash Study Project Schedule: FY15 Project Manager: Hamid Jaffari, Director of Engineering and Operations Reason for Expenditure: Arc Flash is the result of a rapid release of energy due to an arcing fault between a phase bus bar and another phase bus bar, neutral or a ground. During an arc fault the air is ionized and becomes conductive. Am faults are generally limited to systems where the bus voltage is in excess of 120 volts. The purpose of this study is to bring RMLD Into compliance with NEC and NFPA70E Arc Flash requirements. The NEC only requires that Am Flash labels be displayed to warn of potential electric Arc Flash hazards. A detailed study of the RMLD system is required to determine the NEC required Arc Flash labels and suggestions to reduce Arc Flash energy. NFPA70E, 2004, article 130.3 states, "A flash hazard analysis shall be done in order to protect personnel from the possibility of being injured by an arc flash" This option . requires the employer to provide either an independent outside source or a qualified Internal source to perform this analysis in accordance with the calculations defined by the NFPA70E or IEEE 1584. This option defines what level of PPE is required to protect RMLD employees when working near or energized devices. Brief Description/Scope: Qualified outside energy consultant to perform detailed report in accordance with NFPA70E. G Barriers: GIS and Milsoft modeling complete. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FY15 Capital Budget — March 28, 2014 Page 58 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET • CAPITAL PROJECT NAME: Am Rnh Study SCHEDULE: FY15 PROJECT B: TOO TOT& SI%m FYI ESTIMATED COST: 555000 P.B. 59 u BMLD BMLD CREW CREW CREW OTHER OTHER MATERIAL ITEM WEEKS LABOR VEHICLE LABOR VEHICLE SWSC TOTAL .M.n COSTS COSTS mm s�s.000 CeNUIM W PRI^^E.IUdy. uml cost O O wu can O uml con DNI�n O Ptllu o.IMI.m RMk.Eisl ss.wls) um Coel TOT& SI%m FYI ESTIMATED COST: 555000 P.B. 59 u u CAPITAL PROJECT SUMMARY Project Name: Organizational/Reliability Study Project Schedule: FY15 -16 Project Coleen O'Brien, General Manager Managers: Hamid Jaffad, Director of E &O Reason for Expenditure: The purpose of this study is to prepare a guideline for RMID to provide excellent customer service including competitively priced electricity as a result of diligence in the areas of power supply risk management, system reliability and flexibility, and overall business efficiency. This project includes both an Electric System Reliability Study and Organizational Study. The Organizational Study includes an assessment of the current organizational set up and recommending the required system facilities, engineering and operational functions, safety, and energy efficiency measures as they relate to current and future trending Industry practices and standards. The reliability study includes an evaluation of RMLD distribution system to: 1) prepare a long and short range system planning study to provide adequate substation and feeder capacity for anticipated load growth, and 2) provide a roadmap to improve system reliability, introduce reasonable system distribution automation, and improve operating flexibility by Incorporating system expansion plans with overall system rehabilitation and operation objectives. Brief Description/Scope: Barriers: None anticpated at this time. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n!a Status Update From Prior Fiscal Year: n/a %. FY15 Capital Budget - March 28, 2014 Page 60 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT • NAME: Organlzeawd B RNlabiOy SIOCV SCHEDULE: FY15 -1fi FYISSCOPE: RMLD PMLO CAM CRM CREW OTHER 0111EB MATERIAL ITEM WEEKS LABOR VEHICLE LABOR VEHCLE LMISC TOTAL 4 -Man COSTS COSTS Con,i,lanl la mMUq etu0y. $100.000 IOD OW 0 Anil Ca,t 0 uml CUx 0 M Un Coel can.. Bx.LSmacpl=aMel waexlal L� L1,' Cu T.W RMIDc.w.k. T.W WOCnwwa.M TOTAL slop aoo �— FYIS ESTIMATED COST: sIBO,000 FI16 S10D.Wo S2OO,C00. ESTIMATED PROJECT COST: wd P.B. 51 SYSTEM ANNUAL PROJECTS FY15 Capital Budget —March 26, 2014 Page 62 �" CAPITAL PROJECT SUMMARY Project Name: Transformers & Capacitors Project Schedule: Annual Project Manager: Peter Price, Chief Engineer Reason for Expenditure: A major quantity of standard units is necessary for proposed projects and stock on an ongoing basis. Brief Description /Scope: a) Three -phase padmount transformers (commercial services) Quantity: 8 units b) Single -phase padmount transformers for proposed subdivisions and stock. Quantity: 70 units c) Three -phase polemount transformers for proposed commercial projects and stock Quantity: 10 units d) Single -phase polemount transformers for proposed residential services and stock. Quantity: 60 units e) Submersible transformers for stock. Quantity: 4 units f) 1200 kVar capacitor banks. Quantity: 4 units `. Barriers: None anticipated at this time Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FY15 Capital Budget — March 28, 2014 Page 63 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: Transformers and Capacitors SCHEDULE: FY15 PROJECT M: 116 ITEM padmaMt transformers proposed subdi0siions and stock ]0 units CREW CREW NEW CREW LABOR VEHICLE OTHER OTHER MATERIAL WEEKS COST COST LABOR VEHICLE a MISC $98,000 TOTAL $98,000 $154,000 Sts4000 $60,000 $80,000 • pnaseporemoum transformers posed residential servlces and War capacitor banks $84,000 $84000 $20.000 $20000 sm'" $30000 TOTAL $444,000 TOTAL PROJECT COST $444,006' Page 64 Q CAPITAL PROJECT SUMMARY Project Name: Communication Equipment (for Fiber Optic) Project Schedule: Annual Project Manager: Peter Price, Chief Engineer Reason for Expenditure: As the RMLD expands its use of the fiber optic network to establish communication with metering equipment, recloser controls, capacitor bank controls and other distribution equipment, the Department will create fiber nodes at various locations along the fiber optic network. Each node will require an enclosure, a fiber optic interface, a power supply, cabling, fiber optic cable, and the termination of the fiber optic cable. Brief Description/Scope: Purchase materials and procure fiber optic cable splicers as needed. Barriers: None anticipated at this time. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FY15 Capital Budget — March 28, 2014 Page 65 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET • CAPITAL PROJECT NAME: Communication Equipment (Fiber) SCHEDULE: FY15 PROJECT #: 126 RMLO RMLO CREW CREW NEW CREW LABOR VEHICLE OTHER OTHER MATERIAL ITEM WEEKS COST COST LABOR VEHICLE AMISC TOTAL 4 -Man $15,000 St5,000 R�r nods materials to incwde the enclosure, pewit Panel, power supply and Elhemet .mIclt. 3.0 units IUnt Cost $5000 Contact labor and man for 615 ,000 nne 515000 splbinB fib,r. 3.0 unEs lunit Cost $5000 O un6 Coat unit Cost I� O Unit Cost O Unit Cast TOTAL #REFI 530,000 TOTAL PROJECT COST. 2;,:Sa bobs • Papa 66 CAPITAL PROJECT SUMMARY Project Name: Meter Purchases (including 500 Club) Project Schedule: Annual Project Manager: Nick D'Alleva, Technical Services Manager Reason for Expenditure: Purchase of meters and metering equipment for new construction, upgrades, and failures. Additionally, the existing "500 Club" commercial meters which are manually read meters will be replaced. The proposal is to replace the existing meters with meters that can be read remotely with the fixed network system. Brief Description/Scope: 100 residential time -of -use (TOU) meters — AMR and miscellaneous hardware will be purchases for stock. ® The RMLD will begin changing out all "500 Club" commercial meters. In the same fashion as the commercial upgrade, the data will be transmitted to the RMLD via the fiber optic system which encircles the territory. The new data will provide reads at the desktop and additional consumption information. This fixed network offers the ability to remotely: a. Perform all reads from the office; b. Amend the frequency of reads to maintain the read cycle; c. Monitor and discuss customer usage from a monthly, daily, or hourly perspective. Barriers: None anticipated at this time. Change In Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: FY14 "500 Club" commercial upgrade is a carry-over. FY15 Capital Budget —March 28, 2014 Page 67 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: Meters 52,90) SCHEDULE: FY16 53.629 PROJECT#: 117 RMLD RMLD CREW CREW NEW CREW LABOR VEHICLE OTHER OTHER MATERIAL ITEM WEEKS COST COST LABOR VEHICLE S MISC TOTAL 520,000 F $20,000 Far stw. Rnitl tlal TOU ERT Meters AMR .ee0e9 Ange,..I. W male, Mete. an0 misceAeneom auppll.. $3.671 $15,33/ Ubor 1 week(s) Regular Time $10,000 510,000 355,000 555,000 $550 eeN E3,BT1 per week $153341 $10,895 910,885 52,90) Per week 53,829 53.629 TOTAL 901.530 $05000 TOTAL PROJECT COST: $128,530 Page BS CAPITAL PROJECT SUMMARY Project Name: URD Upgrades - All Towns Project Schedule: Annual Project Manager: Peter Price, Chief Engineer Reason for Expenditure: There are 244 +/- underground residential subdivisions in the RMLD service territory, of which, 65 +/- are over 25 years old. These subdivisions are in need of new primary cable and transformers. Some of the URDs are in step -down areas and need to be upgraded before they can be converted to 7,979 volts. Also, most of the existing transformers are live -front units. The new pad mount transformers will be dead -front units which will improve reliability by eliminating the possibility of animal contacts within the pad transformer Brief Description /Scope: Replace primary and neutral cables, and pad- mounted transformers as needed in the various URDs. Replace precast transformer pads with fiberglass box pads as needed for elevation requirements Barriers: None anticipated at this time. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FY15 Capital Budget - March 26, 2014 Page 69 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET • CAPITAL PROJECT NAME: URD Upgrades - All Towns SCHEDULE: FY2015 PROJECT k: 108 RMLD RMLD CREW CREW CREW OTHER OTHER MATERIAL ITEM WEEKS LABOR VEHICLE LABOR VEHICLE &MISC. TOTAL LMW1 COSTS COSTS 10.0 $117.118 $19,400 $135,518 Valellapersed. (Tuded oners A. dR Inclued1n An al Trasfanne Included In Annual Tonelumer PurcOase) UNI Coal $11,712 $1,840 $35,135 $,520 $20,500 $00,955 InaMll eprodmaMY 7,000IoM ol tA1 N UO loubl3.0 e and ],000 feel of s2 cu neulydl. Unit reel EI1J12 St B40 $TO,00o $30,OW Materials: spiked. ended, federalbm, condeadds, box pads, lope. Vic. I June cost $74.443 $520 §74,9GT 16.149 518,119 Poke 08131E (If applicable) week(,) )Unit Cost Total RMLD Crew Weeks 13.0 Total ul0 Crew Weeks 13.0 TOTAL $152259 523920 f92590 f520 590000 FY15 ESTIMATED COST: {319,880. Page 70 EI L CAPITAL PROJECT SUMMARY Project Name: Step -down Area Upgrades — All Towns Project Schedule: Annual Project Manager: Peter Price, Chief Engineer Reason for Expenditure: There are 32 +/- step -down areas in the RMLD service territory. These are areas on the RMLD distribution system that were originally fed from 4kV distribution circuits. When the RMLD began moving load over to the 13.8kV distribution circuits, most areas were converted and some areas were re -fed with pole- mounted step -down transformers. Most of the distribution system in these areas are 30+ years old and in need of upgrades before they can be converted. Brief Description/Scope: Replace poles, primary cable, secondary cable, and overhead transformers, as needed, in the various step -down areas. Convert areas to 13.8kV and remove step -down transformers. Barriers: None anticipated at this time. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FY15 Capital Budget — March 28, 2014 Page 71 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: Step-down Area Upgrades - All Towns SCHEDULE: FY15 • PROJECTM: 107 RMLO RMLO CREW CREW CREW OTHER OTHER MATERIAL ITEM WEEKS LABOR VEHICLE LABOR VEHICLE AMISC. TOTAL a -Man COSTS COSTS 3.0 $35,136 §5,520 $7.M $47� 10 d 1N PH., 5.0 350,558 $9,200 $14,WO 561,J5$ Cost $11,7t2 31,810 2A $23,423.14 $3,080 $21, P60 E4 &103 to... H6MWare $13000 $13,000 5200 par sore for alopmMoretely 83 pa ef. unit Cast $ W • ground clot week(f) Unll Call ser'elp Laoor'. ],259 3],259 2 week(.) Unit COS 3029 P sek Delells(it aPPIK.M.) 54,961 2.0 week(,) E4,981 Un6 Gas, Teel RMLO Crew Weeks 10.0 Total UM Crew Wasks TOTAL _ $117.110 518.100 f12220 $ pp FY15 ESTIMATED COST: $202,738 Pape 72 LM CAPITAL PROJECT SUMMARY Project Name: Service Installations (Commercial and Residential) Project Schedule: Annual Project Manager: n/a Reason for Expenditure: To install new and upgraded services for both residential and commercial/industrial customers in the service territory. Brief Description/Scope: • Service Installations- Commercial/Industrial Customers: This item includes new service connections, upgrades, and service replacements for commercial and industrial customers. This represents the time and materials associated with the replacement of an existing or installation of a new overhead service drop and 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. These aspects of a project are captured under Routine Construction. • Service Installations - Residential Customers: This item includes new or upgraded overhead and underground services. Barriers: None anticipated at this time. Change in Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FY15 Capital Budget - March 28, 2014 Page 73 FISCAL 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: Service instellatlans- Commerclekindustrlal SCHEDULE: FY15 $15893 CREW LABOR PROJECT k: 112 i4ary Sea D0.Ce11 Ion,11 D Unit Cost L� Unit Cost 0 Unit Cost 0 Unit Cost Unit Cost Uon r. ,m Total RMLD Crew Weeks 3.0 Tetel U/0 Crew Weeks TOTAL CREW CREW NEW $15893 CREW LABOR VEHICLE OTHER OTHER MATERIAL ITEM WEEKS COST COST LABOR VEHICLE &MISC TOTAL 4 -Man 3 35,135 5,520 15,893 $Sfi 54B i4ary Sea D0.Ce11 Ion,11 D Unit Cost L� Unit Cost 0 Unit Cost 0 Unit Cost Unit Cost Uon r. ,m Total RMLD Crew Weeks 3.0 Tetel U/0 Crew Weeks TOTAL 3.0 $35135 55,520 $15893 TOTAL PROJECT COST R—,K Page 74 -1 4W FISCAL 2015 CAPITAL BUDGET COST SHEET C CAPITAL PROJECT NAME: Sen ce Installations - Residential Customers SCHEDULE: FY15 Y.6 SO PROJECT 11: 113 BMW RMLO CREW CREW NEW CREW LABOR VEHICLE OTHER OTHER MATERIAL ITEM WEEKS COST COST LABOR VEHICLE B MISC TOTAL 2 -Men 30 $175,674 $21,600 $56,250 $259,524 1 7l� J 0 7 0 Tolat RMLO Crew Weeks 30.0 2 -man crews Total UIG Crew Weeks TOTAL 30.0 175,674 $27,600 Y.6 SO TOTAL PROJECT COST 259;524 Page 76 C Page 76 FY15 Capital Budget — March 28, 2014 %W CAPITAL PROJECT SUMMARY Iftw Project Name: Routine Construction Project Schedule: Annual Project Manager: n/a Reason for Expenditure: Routine Construction covers capital projects that develop during the year involving items shown below. Brief Description/Scope: • Capital Construction - transformer installation, overhead and underground system upgrades, miscellaneous projects, pole damage, etc. • Street Lights - new equipment installation • Pole setting/transfers • Engineering labor • General Line Foreman Labor • Underground capital construction • Police details associated with Routine Capital work • Overtime associated with Routine Capital work Barriers: None anticipated at this time. Change In Scope of Work From Prior Fiscal Year: Increase (Decrease) n/a Status Update From Prior Fiscal Year: n/a FYI Capital Budget -March 28, 2014 Page 77 FISCAL YEAR 2015 CAPITAL BUDGET COST SHEET CAPITAL PROJECT NAME: Routine Construction SCHEDULE: FYIS $3,312 4 -Man PROJECT 8: 113 I mm LEUd e FlS CREW CREW NEW E8 CREW LABOR VEHICLE OTHER OTHER MATERIAL D ITEM WEE" COST COST LABOR VEHICLE BMISC TOTAL 4 -Man ek A) CePIW Conareceon IS $`75574 M7,600 550,000 u^ 5253214 b) Sew Light lnelalleliane 3.6 $21,061 $3,312 4 -Man 2 -Men I mm LEUd e FlS 27.0 Unit C9e E8 $920 8.0 D TOTAL DA 5180000 _$542, 19B $80.032 S1B4.2B1 ek 4 -Men c) Pale SeMnNlrenMera 12 $140539 $22,080 $35,000 E197,618 I Un'1Cml E .712 n - - ar ween in En9lrwelkg Lebor 529.034 8.0 weeks UN1 COSt el Oanaal Line Forman Labor $85,615 565,615 I 26A weeks Ml Cast 2-M. Q UA3 C9nmwlkm 8 334,358 5240 $75,000 5109398 • L u c P., x 9) Police Delags $49,615 S19 fits L 2aa weska Wtlt CoM 2 9a waex 4Men h)pe0ime 15 $170,548 $27,600 $196,148 Page 78 • 4 -Man 2 -Men Total RMLO Cray WNW 27.0 35 Total U/0 how Weeks 8.0 TOTAL DA 5180000 _$542, 19B $80.032 S1B4.2B1 TOTAL PROJECT COST °,„SB47,ZB9I: Page 78 • 1:16 PM READING MUNICIPAL LIGHT DEPARTMENT 312812014 2015 OPERATING BUDGET SUMMARY DRAFT i 1` MARCH 31, 2014 OTHER INCOME MDSEANDJOBBING PURCHASED POWER - BASE 28,889,014 2014 29,167,159 3.73% 26,117,958 2015 OPERATION EXPENSE 7 MTHS ACT 13.23% FY 13 .2.92% BUDGET %CHANGE 5MTHS BUD %CHANGE ACTUAL 3,003,950 [Al [A] 6IB1 [B] (Bl 6 [Cl ICI OPERATING REVENUE: 3,777,786 36.47% 3,665,630 . 16.46% TOWN PAYMENTS SALES OF ELEC - BASE 50,449,523.00 8.73% 46,400,000 2.64% 45,206,258 SALES OF ELEC - FUEL 36,949,646.00 14.45% 32,284,101 -6.02% 34,351,756 ENERGY CONSERVATION 692,860.00 0.96% 686,292 0.12% 685,480 PURCHASE POWER ADJUSTMENT O.OD • 100.00% 1,139,813 0.147. 1,138,193 GAIN REVENUE 0.00 . 100.00% 692,642 -0.50% 696,142 NYPA CREDIT (700,000.00) 7.26% (652,649) -7.68% - 706.940 TOTAL OPERATING REVENUE 87,392,029 8.49% 80,550,199 . 1.01% 81,372,809 OTHER INCOME MDSEANDJOBBING PURCHASED POWER - BASE 28,889,014 4.95% 29,167,159 3.73% 26,117,958 10D.DD0 OPERATION EXPENSE 10,786,355 13.23% 9,526,178 .2.92% 9,812,641 15.16% MAINTENANCE EXPENSE 3,357,261 11.76% 3,003,950 . 69.39% 2,768,230 626,428 DEPRECIATION EXPENSE 3,892,000 3.02% 3,777,786 36.47% 3,665,630 . 16.46% TOWN PAYMENTS 1,416,000 1.25% 1,398,521 . 61.85 °A 1375900 SUB -TOTAL 48,340,629 3.13% 46,873,594 2.48% 45,740,259 4,187 PURCHASED POWER -FUEL 36,249,653 14.60% 31,631,195 -5.03% 33,305,373 . 11.51% TOTAL OPERATING EXPENSES 84,590,262 7.75% 78,504,789 -0.68% 79,045,632 2,770,886 NET OPERATING INCOME 2,801,747 36.98% 2,045,410 . 12.11% 2,327,257 OTHER INCOME MDSEANDJOBBING 276,000 23.56% 223,370 . 33.25% 334,634 INTEREST INCOME 10D.DD0 114.61% 46,596 90.70% 24,434 FORFEITED DISCOUNTS 1,109,890 15.16% 963,743 4.57% 921,639 MISCELLANEOUS REVENUE 750,000 19.73% 626,428 . 33.78% 946,040 TOTAL OTHER INCOME 2,235,890 20.2D% 1,860,137 . 16.46% 2,226,747 MISCELLANEOUS INCOME DEDUCTIONS: CUSTOMER DEPOSIT INTEREST EXP 3,000 . 28.35% 4,187 265.68% 1,145 OTHER DEDUCTIONS (ROI) 2,482,863 1.30% 2,450,999 . 11.51% 2,769,741 TOTAL MISCELLANEOUS DEDUCTIONS 2,485,863 1.25% 2,455,186 . 11.39% 2,770,886 NET INCOME 2,551,773 75.94% 1,450,361 - 18.66% 1,783,118 Page 1 1:09 PM READING MUNICIPAL LIGHT DEPARTMENT MM014 2015 OPERATING BUDGET SUMMARY DRAFT 7 MARCH 31, 2014 2014 2016 7 MTHS ACT FY 13 BUDGET % CHANGE 5MTHS BUD %CHANGE ACTUAL [A] [A] 3 [e] [B) [B] 3 [D] [C] PROJECTED REVENUE RESIDENTIAL REVENUE 21,850,876 8.15% 20,204,971 0.87% 20,0]0,706 COMMERCIAL REVENUE 28,006,544 10.66% 2.62% 24,861,227 25,309,613 STREET LIGHT REVENUE: PUBLIC 221,493 12.34% 197,158 0.70% 195,783 PRIVATE 68,823 88.58% 40,830 52.24% 26,820 SUB TOTAL 290,316 21.99% 237,988 6.91% 222,603 COOP - RESALE REVENUE 301,002 26.32% - 18.31% 293,721 239,062 TOTAL BASE REVENUE 50,649,528 9.70% 45,990,834 1.73% 45 FUEL REVENUE 36,949,646 19.10% 31,024,101 -9.69% 34,351,756 LESS PASNY CREDIT (700,000) 7.26% (652,845) .7.68% (706,940) TOTAL NET FUEL REVENUE 36,249,646 19.35% 30,371,856 .9.73% 33,646,316 PURCHASED POWER ADJUSTMENT(PPA) 1,050,886 63.29% 6345% 1,138,193 643,562 ENERGY CONSERVATION - RESIDENTIAL 256,568 0.64% 264,440 -0.91% 256,789 ENERGY CONSERVATION- COMMERCIAL 436,292 1.03% 431,852 0.74% 428,691 TOTAL ENERGY CONSERVATION 692,860 0.96% 888,292 0.12% 685,480 GAW REVENUE 0 . 100.00% 892,542 -0.60% 696,142 TOTAL REVENUES B8µ2,913 12.83% 78,384,486 -3.67% 81,372,886 ft, 2 li Paps 3 1:11 PM READING MUNICIPAL LIGHT DEPARTMENT 3126/3014 2015 OPERATING BUDGET SUMMARY DRAFT 1 • MARCH 31, 2014 C.' 2014 2015 7 MTHS ACT FY 13 BUDGET %CHANGE 5MTHS BUD %CHANGE ACTUAL (A) [A] & [B] [BI [B] & [C1 [Cl 2,014 2015 7 MTHS ACT FY 13 BUDGET %CHANGE 6MTHS BUD %CHANGE ACTUAL [A] [A3 & [B] [B] [B] & [C] [C] PROJECTED MISCELLANEOUS REVENUE MMWEC FLUSH OF FUNDS 500,000 0.00% 500,000 15.23% 433,900 CONTRIBUTIONS IN AID OF CONSTRUCTION 200,000 161.68% 76,428 - 83.15% 453,679 SURPLUS APPLIED TO DEPRECIATION 50,000 0.00% 501000 •14.47% 58,461 TOTAL MISCELLANEOUS REVENUE 750,000 19.73% 626,428 - 33.78% 946,040 Paps 3 1:12 PM READING MUNICIPAL LIGHT DEPARTMENT 3128%1014 2016 OPERATING BUDGET SUMMARY DRAFT 1 MARCH 31, 2014 J 2014 2015 7 MTHS ACT FY 13 BUDGET %CHANGE 5MTHS BUD %CHANGE ACTUAL (A) (A) 6IB] [B] [B] 3 (Cl (c] OPERATING EXPENSES: 555 PURCHASED POWER 65,138,657 7.14% 60,798,354 -1.02% 61,423,331 TOTAL PURCHASED POWER 65,138,887 7.14% 60,798,364 .1.02% 51,423,331 560 MAINT OF TRANS PLANT 3,000 5.78% 2,036 4.07% 2,725 TOTAL TRANSMISSION EXP 1,000 5.78% 2,836 4.07% 2,725 580 OPERSUPERBENGIN 583,655 18.27% 493,524 .1.99% 503,570 581 OPERATION LABOR 93,027 - 10.07% 103,444 36.06% 76,028 5811 OPERATION LABOR MISC 657,269 - 15.77% 780,307 11.53% 699,687 582 OPERATION SUPPLIES B EXP 398,849 -1633% 476,102 -0.46% 478,208 585 STREET LIGHTING EXP 82,907 1.93% 81,339 7.81% 75,447 586 METER EXP 247,938 11.67% 222,018 18.18% 107,867 588 MISC DISTRIBUTION EXP 402,885 T.6TY6 374,169 6.41% 351,642 590 MAINT OF STRUCTURE & EQUIP 484,026 223.25% 149,735 5.91% 141,374 593 MAINT OF LINES OH 1,792,794 10.92% 1,616,M4 4.87% 1,541,147 594 MAINT OF LINES UG 130,694 .59.51% 322,749 57.69% 204,673 595 MAINT OF LINE TRANSFORMS 156,000 9.63% 142,299 -2.12% 145,386 596 MAINT OF ST LT S SIG SYS 9,745 142.48% 4,019 - 3367.48% (1' 597 MAINT OF METERS 43,200 108.73% 20,740 - 51.20% TOTAL DISTRIBUTION EXP 5,081,084 6.19% 4,786,689 7.63% 4l 60 902 METER READING LABOR d EXP 30,922 - 14.69% 36,246 •51.51% 74,751 903 ACCT B COLL LABOR B EXP 1,705,333 11.16% 1,534,169 2.89% 1,491,101 904 UNCOLLECTABLE ACCTS 120,000 4.76% 126,000 232.28% 37,920 TOTAL CUST ACCT EXP 1,856,255 9.42% 1,696,445 5.78% 1,603,772 916 ENERGY AUDIT EXP 1,267,096 33.90% 946,302 . 21.96% 1,212,536 920 ADMIN B GENERAL SALARIES 642,170 1.22% 832,033 8.30% 768,257 9211 OFFICE SUPPLIES EXP 301,000 9.67% 274,458 -0.58% 276,073 923 OUTSIDE SERVICE EMPLOYED 351,650 . 15.88% 418,019 - 34.00% 633,341 924 PROPERTY INSURANCE 453,200 15.29% 393,089 6.23% 369,873 925 INJURIES S DAMAGES 49,059 5.07% 46,692 2.19% 45,691 926 EMPLOYEES PENSIONS 8 BENS 2,746,619 35.98% 2,019,837 -7.09% 2,174,071 930 MISC GENERAL EXP 240,772 41.77% 169,832 6.17% 159,956 931 RENT EXPENSE 212,000 6.75% 198,601 1.11% 196,422 932 1 MAINT OF GARAGE S STCKRM 567,531 .5.69% 601,777 5.34% 571,295 935 MTNOFGENPLANT 170,180 18.55% 143,548 20.37% 119,256 TOTAL ADMIN d GEN EXP 7,201,277 19.14% 6,0",188 •7.39% 6,528,801 GRAND TOTAL 79,282,282 8.12% 73,328,482 -0.91% 74,004,089 LESS: PURCHASED POWER (65,138,667) 7.14% (60,798,354) •198.98% 61,423,331 MAINTENANCE EXPENSES (3,357,261) 11.76% (3,003,950) 8.52 %. (2,768,229; TOTAL OPERATION EXPENSE 10,786,355 13.23% 9,528,178 •83.76% 50,655,102 W Page 4 1:14 PM READING MUNICIPAL LIGHT DEPARTMENT 3128=4 2015 OPERATING BUDGET SUMMARY DRAFT 1 (� MARCH 31, 2014 l MAINTENANCE EXPENSE 568 MTN OF TRANS. PLANT 590 MTN OF STRUCTURES 593 MTN OF LINES - OH 594 MTN OF LINES - UG 595 MTN OF LINE TRANS. 596 MTN OF ST. LIGHTS 597 MAINTOFMETERS 932 1 MTN OF GEN PLANT 935 MTN OF GEN PLANT TOTAL MAINTENANCE EXPENSES DEPRECIATION EXPENSE: 403 DEPRECIATION EXPENSE OTHER TAXES: 408 OTHER TAXES (2 %TOWN PAYMTS) INTEREST ON CUSTOMER DEPOSITS: 419.2 INTEREST EXP ON CUST DEP 3,892,000 3.02% 3,777,787 3.06% 3,665,630 1A16,000 1.25% 1,398,522 1.64% 1,375,900 3,000 - 28.35% 4,187 265.68% 1,145 PB815 2014 2015 7 MTHS ACT FY 13 BUDGET %CHANGE 5MTHS BUD %CHANGE ACTUAL [A] JAI 6IB1 [e1 IBI B ICI [CI 3,000 5.63% 2,840 4.22% 2,725 484,026 223.25% 149,735 5.91% 141,374 1,792,794 10.92% 1,616,244 4.87% 1,541,147 130,694 - 59.61% 322,749 57.69% 204,673 156,000 9.63% 142,299 .2.12% 145,386 9,745 142AB% 4,019 - 3367.48% (123) 43,290 108.73% 20,740 - 51.20% 42 ,496 567,531 -6.69% 601,777 5.341/6 571,295 170,180 16.55% 143,548 20.37% 119,266 11.76% 8.52% 3,357,261 3,003,951 2,768,229 3,892,000 3.02% 3,777,787 3.06% 3,665,630 1A16,000 1.25% 1,398,522 1.64% 1,375,900 3,000 - 28.35% 4,187 265.68% 1,145 PB815 Description of RMLD's Power Supply Stony Brook Intermediate Unit The Stony Brook Intermediate Unit is a 354 - megawatt, combined -cycle power plant that entered commercial operation In 1981. The unit's three gas turbines generate electricity using either No. 2 oil or natural gas, With additional electricity produced using a single steam turbine in the combined -cycle process. MMW EC completed construction of a natural gas pipeline to serve the Intermediate Unit in September 2002. The RMLD has a Life of Unit (LOU) entitlement for 14.453% of the unit or approximately 51 Mws. The RMLD has paid off the debt service associated with this project. Quick Facts — Stonybrook Intermediate Unit Location Ludlow, Massachusetts On -Line Date 1981 Fuel No. 2 oil /natural gas Principal Owner /Operator MMWEC Total Capacity 354 megawatts Stony Brook Peaking Unit The Stony Brook Peaking Unit is a 172 - megawatt peaking plant that entered commercial operation in 1982. The unit's two turbines generate electricity using No. 2 oil. The RMLD has a Life of Unit (LOU) entitlement for 19.518% of the unit which is equivalent to approximately 33 Mws. The RMLD has paid off the debt service associated with this project. Group, Inc. NextEra owns 88.2% of Seabrook Station. The other owners are MMWEC (11.59 %) and two Massachusetts municipal utilities, the Taunton Municipal Lighting Plant (0.13 %) and Hudson Light & Power Department (0.08 %). NextEra has announced plans to seek an extension of its Seabrook operating license from the current license expiration of 2030 to 2050. RMLD signed 3 different projects to finance Seabrook, Mix 1, Project 4, and Project 5. The debt service associated with these projects will be paid -off in 2014, 2017 & 2018 respectively. The RMLD has a Life of Unit (LOU) for 0.635% or approximately 8 Mws of the unit. Quick Facts — Seabrook Station Location Seabrook, New Hampshire On -Line Date 1990 Fuel Nuclear— Pressurized Water Reactor Principal Owner /Operator NextEra Energy Resources, LLC Total Capacity 1,244 megawatts Millstone Unit 3 Millstone Unit 3 is a 1,237- megawatt nuclear generating plant located in Waterford, Connecticut. Millstone Unit 3, which began operation in 1986, is the newest and largest of the Millstone Station's three nuclear units, one of which is retired from service. The principal owner and operator of Millstone Station Is Dominion Nuclear Connecticut, Inc., a subsidiary of Virginia -based Dominion Resources, Inc. Dominion Connecticut owns 93.4% of Millstone Unit 3. The Nuclear Regulatory Commission (NRC) on November 28, 2005 approved Dominion Nuclear Connecticut's request for a 20 -year operating license extension for Millstone's Unit 3 reactor. The license now expires in November, 2045. RMLD signed two different projects to finance Millstone #3, Mix 1 and Project 3. The debt service associated with these projects will be paid off in 2014 & 2018 respectively. The RMLD has a LOU agreement for 0.404% of the units which equates to approximately 4.6 Mws. 0 6/1/2015 - 5/31/2016 $5.90 $6.40 6/1/2016- 5/31/2017 $6.15 $6.65 JP Morgan In June, 2010 the RMLD signed a system power contract with JP Morgan that is effective from January 1, 2011 through December 31, 2014. The RMLD receives enery only from this contract. The amount of energy purchased fluctuates on a monthly basis for both the on -peak and off -peak period. RMLD has secured fixed pricing for this contract. NextEra Energy Power Marketing, LLC In June, 2011 the RMLD signed a system power contract with NextEra that is effective from January 1, 2012 through December 31, 2015. The RMLD receives enery only from this contract. The amount of energy purchased fluctuates on a monthly basis for both the on -peak and off -peak period. RMLD has secured fixed pricing for this contract.. Exelon In June, 2012 the RMLD signed a system power contract with Exelon that is effective from January 1, 2013 through December 31, 2016. The RMLD receives enery only from this contract. The amount of energy purchased fluctuates on a monthly basis for both the on -peak and off -peak period. RMLD has secured fixed pricing for this contract. BP Energy In July, 2013 the RMLD signed a system power contract with SP Energy that is effective from January 1, 2014 through December 31, 2017. The RMLD receives enery only from this contract. The amount of energy purchased fluctuates on a monthly basis for both the on -peak and off -peak period. RMLD has secured fixed pricing for this contract. Swift River Hydro In March, 2011 the RMLD signed a purchase power agreements with Swift River Hydro LLC for the output of four hydro systems located in Massachusetts that are effective from February 1, 2011 through January 31, 2026. The Swift River Trading Company is ] Indian River Hydro: 15 year term beginning on February 1, 2011 and ending January 31, 2026. RMLD is purchasing all of the products produced by or attributable to the facility. The facility has a nameplate capacity of 1.4 Mws. The products include, but are not limited to, Energy, Installed Capacity, Ancillary Services, Renewable Energy Certificates and Environmental Attributes (to the extent not included in the RECs). The contract price for these products is $100 /Mwh for the first year, escalated 2.25% thereafter. The facility Is not currently qualified for FCM. Until the Seller qualifies the facility for FCM the contract price is reduced by $5.00 /Mwh. Collins Hydro In August, 2013 the RMLD signed a purchase power agreements with Swift River Hydro LLC.for the output of Collins Hydro located in between Ludlow and Wilbraham Massachusetts. The contract with Swift River Hydro Is effective from September 1, 2013 through August 31, 2028. The RMLD receives enery only from this contract. The average annual generation is approximately 5,667 megawatt-hours per year. AMk Pioneer Hydro In August, 2013 the RMLD signed a purchase power agreements with Ware River Power Inc. for the output of Pioneer Hydro located in Ware, Massachusetts. The contract for Pioneer Hydro is effective from September 1, 2013 through August 31, 2028. The RMLD receives enery only from this contract. The average annual generation Is approximately 4,480 megawatt-hours per year. KI 4/15/2014 READING MUNICIPAL LIGHT DEPARTMENT 244 PM 2015 BUDGET SUMMARY ® PURCHASED POWER EXPENSE TOTAL NUCLEAR MIX #1 -MILLSTONE C 924,765 MILLSTONE -TRANSMISSION T 17,664 MILLSTONE• ENERGY E 160,523 NUCLEAR MIX #1- SEABROOK C 70,731 SEABROOK- TRANSMISSION T 180 SEABROOK- ENERGY E 19,823 PROJECT 03 -DEBT SERVICE C 1,283,131 PROJECT 03 TRANSMISSION T 12,624 PROJECT 03 ENERGY E 123,087 PROJECT #4 -DEBT SERVICE C 3,345,119 PROJECT #4• TRANSMISSION T 4,104 PROJECT #4 - ENERGY E 486,505 PROJECT #5 -DEBT SERVICE C 436,780 PROJECT #5- TRANSMISSION T 504 PROJECT #5- ENERGY E 60,037 NYPA - CAPACITY' C 206,064 NYPA - TRANSMISSION' T 634,410 NYPA - ENERGY' E 110,874 REMVEC" E 9,000 ISO -NE CAPACITY C 2,265,114 ISO -NE TRANSMISSION "' T 11,810,652 ISO -NE ENERGY E 6,116,209 NEMA CONGESTION "'• E (711,600) HYDRO QUEBEC SUPPORT SERVICES C 277,200 STONYBROOK PEAKING PROJECT CAPACITY STONYBROOK PEAKING PROJECT - TRANSM C T 572,830 33,592 STONYBROOK PEAKING PROJECT ENERGY E 397,230 STONYBROOK INTERMEDIATE PROJECT • CAPACI C 1,316,835 STONYBROOK INTERMEDIATE PROJECT -TR T 42,997 STONYBROOK INTERMEDIATE PROJECT • ENER E 1,747,295 J P MORGAN E 7,293,496 NEXTERA E 6,098,655 EXELON E 4,798,187 BRAINTREE WATSON- CAPACITY C 1,550,718 BRAINTREE WATSON- ENERGY E 640,261 COOP I RESALE E 25,200 MACQUARIE I INTEGRYS E 5,486,096 SWIFT RIVER HYDRO E 3,368,775 NEXTERA CAPACITY PURCHASE C 4,083,000 TOTAL BUDGETED PURCHASED POWER 65,138,667 TOTAL CAPACITY PURCHASED C 16,332,287 TOTAL TRANSMISSION PURCHASED T 12,556,727 TOTAL 28,889,014 TOTAL ENERGY PURCHASED E 36,249,653 4iiw •PASNY: POWER AUTHORITY FOR THE STATE OF NEW YORK •' REMVEC: RHODE ISLAND, EASTERN MASSACHUSETTS, VERMONT ENERGY CONTROL •" ISO -NE: INDEPENDENT SYSTEM OPERATOR - NEW ENGLAND "• NEMA: NORTHEAST MASSACHUSETTS § ak# # #p# # #§k #¥ / ##§ °! # § §�§§GeE»[ *7 �) {§!]§i § | ; ■■!E! ®§] us k\ \ ® (. )k [§§{2 §§2§{2( 7 § ■erlrk# #!r #" | � ®)};■S;K§f[ / �{ !ow�� \X z } o \\\ §!)F]§§ 5 @q ! z w§§ �)§ � | - (Zw �\ ( (| w ulw/ \ � §$7 §E! w- ,zzz wMH a ! f {{ \!|t) ! | ( ,_.2 2:19 PM 3/2812014 DIVISION BUSINESS DIVISION ENERGY SERVICES ENGINEERING AND OPERATIONS FACILITY GENERAL HANAOER SUB -TOTAL PURCHASED POWER BASE PURCHASED POWER "EL TOTAL RJUM BMGBT / ACTUAL CONFARISON 60XNMY RCNE➢OL8 ORART 1 3/31/14 Page i 3014 2015 7 EMIRS ACT YY 13 BUDGET % CHANGE 5 LATHS BUD t CHANGE ACTCAL [A] [A] 8 [B] (B[ IB] a [C] [C] 10,143,540 3.91% 9,761,564 1.79% 9,589,645 11405,396 33.09% 1,063,954 0.54% 1,058,281 4,966,221 5.89% 41689,811 1.47% 4,622,001 4,623,594 21.19% 3,812,130 2.99% 3,701,470 798,728 -4.25% 834.165 1.48% 621.967 21,937.470 8.81% 20,161,624 1.86% 19,793,444 28,689,020 -0.95% 29,167,159 17.25% 24,876,985 36,249,650 14.60% 31,631,195 - 10.86% 35,484,630 8].09fi. 198 7.551 80.959.978 1.90% EU. 155,059 Page i 2:21 PM mm 3/282014 ENERGY SERVICES DIVISION BUDGET / ACTUAL COMPARISON SOSBIAEY SCHHDOLE DRAFT 1 3/31/14 2015 2016 EODST 7 MTBB ACT n 13 ENERGY SERVICES 75 TOTAL 5 LATHS HOD ACTUAL 01 -75 -5916 -000 ENERGY SERV HAP 68,000 28.58% 37,330 15.97% 32,189 01 -75. 5916.101 LABOR RHO 623,184 26.52% 339,659 - 15.66% 601,995 01 -75. 5916.102 LABOR OT - - 100.00% 113 - 96.86% 3,577 01.75 -5916 -103 EH HDUCATION 15,600 227.11% 6,769 - 69.65% 91672 01- 75.5916 -105 SUPPLIES - 0.00% - 0.00% - 01 -75- 5916 -109 EHY ACCOUNT 1,500 - 76.62% 5,910 1210.62% 451 01 -75 -5921 -000 OFFICE SUPPLIH9 - 0.00% - - 100.00% 79 01- 75.5923 -000 OUTBIDS SHRVICHS 138,300 17.55% 117,653 15.01% 102,295 01.75- 5916 -M CONSERVATIOM 776,612 39.49% 558,320 9.86% 508,223 O TOTAL 11605.396 32.09% 1.063.956 0.54% 1,OS8,281 E Page 2 2:23 PM ® 32&2014 GENERAL EAEAGIR 51 RELY GENERAL MANAGER DIVISION BUDGET / ACTUAL COMPARISON SUMMARY 9CHRDULE DRAFT 1 3/31/14 01 -51- 5920 -101 LABOR RIG O1.51. 5920 -102 LABOR OT 01 -51 -5921 -000 OFFICE SUPPLIES 01 -51 -5923 -000 OUTSIDE SERVICES 01 -51- 5930 -103 EE EDUCATION 01.51 -5930 -105 MIBC GENERAL 01-51- 5930 -106 VEHICLE SUB -TOTAL HUMAN RESOURCES 52 01- 52- 5930.101 LABOR REO 01 -52 -5921 -000 OFFICE EOPPLIES 01 -52 -5923 -000 OUTSIDE SERVICES 01.52- 5930 -103 BE EDUCATION 01 -52. 5930.105 SUPPLIES 01 -53. 5930.109 MIBC OnRRAL SOB -TOTAL ITY RELATIONS 54 54- 5920 -101 LABOR REO 01- 54.5910 -102 LABOR M 01.54.5921.000 OFFICE SUFFIXES 01.54- 5930.109 EXEC OINERAL 01.54.5930.103 ER EDUCATION 01 -54 -5930 -105 SUPPLIES BUB -TOTAL CAB 56 01 -56- 5920 -101 LABOR "a 01- 56- 5910 -102 LABOR OT 01 -56. 5930.105 SUPPLIES 01.56- 5930.109 MISC GQlEIIAL BOB -TOTAL BOARD 58 01 -58- 5930 -109 MIeC GENERAL SUB -TOTAL GRAND TOTAL .` 2015 1.99% 112,183 2014 BUDGET 651 64,000 ] MTES ACT TOTAL 6,580 46.22% 5 MIES am 268,865 7.86% 534 249,283 • - 100.00% 199,431 234 - •100.00% 153 53,000 - 69.07% 171,382 91000 184.63% 3,163 55,000 3.00% 53,396 4,650 - 419.86% (1,457) 390.515 - 17.98% 476.153 114,411 1.99% 112,183 - 0.00% 651 64,000 17.16% 54,614 6,580 46.22% 41500 900 ]1.]6% 534 13,540 31.47% 10,299 199,431 9.50% 181.130 94,516 21.86% ]],564 - - 100.00% 651 53.60% 0.00% - 82,320 21.01% 68,020 2,400 2.96% 2,331 6,990 - 27.13% 9,592 186.226 17.75% 158.159 5,014 83.70% 2,735 1,200 104.08% 588 53.60% 0.00% -6.48% 8,811 73.13% 51095 15,045 78.73% 81418 7,500 - 19.40% 9,305 7,500 - 19.40% 9.305 ]98.]26 -4.15% 834.165 Page 3 9Y 13 ACTUAL -5.39% 263,497 - 63.35% 1,405 - 84.88% 1,012 53.60% 111,5]] -6.48% 3,381 - 32.58% 79,198 - 75.80% (6,021) 4.87% 454.049 6.05% 73,511 105,783 0.00% 0.00% - - 46.28% 58,002 101,680 2594.61% 117.01% 167 1].49% 136.058 446 - 14.20% 12,003 - 17.24% 220.079 5.51% 73,511 100.00% - 0.00% 1].2]% 58,002 1764.80% 125 117.01% 4,410 16.14% 136.058 ]11.5]% 337 13.51% SIB 0.00% - 17.26% 61158 20.03% 7.013 95.16% 4,768 95.16% 4.166 1.48% 811.96] 2:25 PM RMLD 3/2812014 FACILITY MANAGER DIVISION BUDGET / ACTUAL COMPARISON SUMMARY SCHEDULE DRAFT 1 3/31/14 GRNBAAL BENEFITS 53 01.53- 5920.101 LABOR REG 01 -53- 5920 -102 LABOR OT 01- 53- 5921 -000 OFFICE SUPPLIES 01.53. 5930.103 BE EDUCATION 01.53.5930 -105 SUPPLIES 01 -53- 5923.000 OUTSIDE SERVICES 01.53- 5924 -000 PROPERTY INSURANCE 01- 53- 5925.000 INJURIES 6 DARA069 01 -53- 5926 -000 BE PENS 6 BENEFIT 01 -53 -5930 -109 RISC GENERAL 01-53. 5931.000 RENT SUB -TOTAL TRANSPORTATION 63 01-63- 5933.109 RISC GENERAL 01- 63- 5933.101 LABOR REG 01 -63- 5933 -102 LABOR OT 01 -63. 5933 -103 BE EDUCATION 01 -63- 5933 -105 SUPPLIES LEER ALLOCATION RECLASS SUB -TOTAL BUILDING MAINTMARCE 64 01.64. 5923.000 OUTSIDE SERVICES 01 -64- 5932.101 LABOR REG 01 -64. 5932.102 LABOR OT 01.64 -5932 -103 EE RDUCATION 01- 64.5932 -105 SUPPLIER SUB -TOTAL MATERIALS NANAGENENT 60 01 -60 -5586 -109 NIBC DIST REP 01- 60- 5588.101 LABOR REG 01- 60- 5588 -102 LABOR OT 01.60 -5588 -103 EB EDUCATION 01- 60.5588 -105 SUPPLIES 01- 60 -SSBS -104 ABP EXPENSES 01 -60. 5921.000 OFFICE SUPPLIES SOB -TOTAL GRAND TOTAL 2015 BUDGET TOTAL 104,050 21,600 1,000 27,000 453,200 49,059 2,746,619 3,300 212,000 3.617.828 (236,072) 2014 - 19.87% 7 USES ACT 65,370 5 NTEB BUD - 22.17% 133,692 - 100.00% 228 - 100.00% 11015 71900.00% 30 138.66% 419 170.00% 10,000 15.29% 393,089 5.07% 46,692 35.98% 2,019,837 49.12% 2,213 6.75% 198,601 28.94% 2.805.816 (236,072) 181.37% - 19.87% (83,902) 65,370 16.42% 380.00% 56,151 8,400 57.98% -4.73% 5,317 2,400 380.00% 13,873 500 392,920 - 978.54% -2.27% (44,724) (233,016) - 449.57% 572.64% 66,658 10,350 100,951 32,000 2,400 432,180 577.881 70,000 294,625 15,000 10,260 13,000 25,000 427.685 0.00% 116.21% 4,787 - 19.87% 125,977 11.95% 28,585 380.00% 500 -3.25% 446,716 -4.73% 606.565 5.53% FY 13 66,333 5.19% 79.16% 280,087 26.42% - 111865 553.09% - 68.42% 1,571 -6.29% 2,198 13,873 - 100.00% 1.69% 440 -2.27% 35,230 25,580 7.04% 572.64% 399.749 4.6236594 21.29% 3,012,130 Page 4 E9/ C 11650.98% FY 13 - 30.99% ACTUAL 79.16% 74,622 100.00% - 100.00% (303,43]L - 68.42% 95 100.00% 2,198 54.85% 61458 1.69% 366,560 32.53% 35,230 -0,34% 2,026,826 572.64% 329 0.94% 196,756 2.89% 2.726,876 11650.98% (714) - 30.99% 81,372 - 55.23% 11,877 100.00% - - 68.34% (303,43]L - 77.09} 290,8 - 95.21% 99,979 -2.74% 129,530 16.93% 24,446 156.41% 195 21.29% 368,308 -2.55% 622.458 46.90% 44,548 0.77% 277,946 25.29% 9,470 516.08% 255 51.11% 91181 - 94.85% 8,538 1063.79% 2,198 13.52% 352.136 2.99% 3.701,970 RMLD BUSINESS DIVISION BUDOET / ACTUAL COMPARISON SUMMARY SCM6DULE DRAFT 1 3/31/14 01 -59- 5903.101 LABOR REG 01.59. 5903 -102 LABOR OT 01.59. 5903.103 RE EDUCATION 01 -59 -5903 -105 SUPPLIES 01 -59 -5921 -000 OFFICE SUPPLIES 01.59- 5923 -000 OUTSIDE SERVICES SUM -TOTAL CGBTOMER SERVICE 62 01.62- 5903 -101 LABOR REG 01 -62- 5903 -102 LABOR OT 01 -62 -5903 -103 BE EDUCATION 01 -62 -5903 -104 TEMP LABOR 01.62 -5903 -105 SUPPLIES 01- 62- 5903 -1DO VEHICLE 01 -62- 5903.109 RES ENERGY AUDITS 01-62- 5904 -000 UNCOLLBCT ACCOUNTS 62 -5921 -000 OFFICE SUPPLIES SUB -TOTAL MIS 61 01- 61- 5903 -101 LABOR PEO 01 -62. 5903 -102 LABOR OT 01- 61.5903 -103 BE EDUCATION 01- 61- 5903 -1D5 0MLIES 01.61- 5935.000 MEN am PLANT 01 -61. 5921.000 OFFICE SUPPLIES 800 -TOTAL MISCELLANEOUS DEDUCTIONS 57/77 01 -77 -5403 -000 DEPRECIATION I" 01 -77- 5408.000 VOLUNTARY FAYMENTS Dl -77 -5419 -000 INTEREST ERP 01- 77- 5426 -000 OTHER DEDUCTIONS 01- 57- 5920.101 BE LABOR REO 01 -57- 5930.109 BE MISC GENERAL BOB -TOTAL GRAND TOTAL 2015 BODORT TOTAL 217,219 400 6,200 333,000 276,000 35,000 525,214 2,000 4,800 16,000 4,660 120,000 674,674 $62,439 EDO 9,600 21,000 170,180 764,019 3,892,000 1,416,000 3,000 2,482,863 40,764 2,400 7,837,027 10,143,540 2:27 PM 147.22% 328/2014 C. 5 MINE BUD RMLD BUSINESS DIVISION BUDOET / ACTUAL COMPARISON SUMMARY SCM6DULE DRAFT 1 3/31/14 01 -59- 5903.101 LABOR REG 01.59. 5903 -102 LABOR OT 01.59. 5903.103 RE EDUCATION 01 -59 -5903 -105 SUPPLIES 01 -59 -5921 -000 OFFICE SUPPLIES 01.59- 5923 -000 OUTSIDE SERVICES SUM -TOTAL CGBTOMER SERVICE 62 01.62- 5903 -101 LABOR REG 01 -62- 5903 -102 LABOR OT 01 -62 -5903 -103 BE EDUCATION 01 -62 -5903 -104 TEMP LABOR 01.62 -5903 -105 SUPPLIES 01- 62- 5903 -1DO VEHICLE 01 -62- 5903.109 RES ENERGY AUDITS 01-62- 5904 -000 UNCOLLBCT ACCOUNTS 62 -5921 -000 OFFICE SUPPLIES SUB -TOTAL MIS 61 01- 61- 5903 -101 LABOR PEO 01 -62. 5903 -102 LABOR OT 01- 61.5903 -103 BE EDUCATION 01- 61- 5903 -1D5 0MLIES 01.61- 5935.000 MEN am PLANT 01 -61. 5921.000 OFFICE SUPPLIES 800 -TOTAL MISCELLANEOUS DEDUCTIONS 57/77 01 -77 -5403 -000 DEPRECIATION I" 01 -77- 5408.000 VOLUNTARY FAYMENTS Dl -77 -5419 -000 INTEREST ERP 01- 77- 5426 -000 OTHER DEDUCTIONS 01- 57- 5920.101 BE LABOR REO 01 -57- 5930.109 BE MISC GENERAL BOB -TOTAL GRAND TOTAL 2015 BODORT TOTAL 217,219 400 6,200 333,000 276,000 35,000 525,214 2,000 4,800 16,000 4,660 120,000 674,674 $62,439 EDO 9,600 21,000 170,180 764,019 3,892,000 1,416,000 3,000 2,482,863 40,764 2,400 7,837,027 10,143,540 7.25% 2014 147.22% 7 MTHB ACT 34.19% 5 MINE BUD 9.75% 197,917 100.00% 200 100.00% - 15.31% 286,790 11.53% 247,464 -9.09% 36,500 12.29% 772.871 7.25% 499,720 147.22% 809 34.19% 3,577 0.00% - -4.53% 16,854 - 419.86% (1,457) 0.00% 7.671,746 -4.76% 126,00D 0.00% - 5.83% 637.503 10.46% 3,777,787 509,164 - 65.13% - 28.35% 2,294 - 32.06% 2,451,000 14,130 106.90% 140.00% 10,150 18.55% 7.671,746 143,548 100.00% 15.18% 138 12.45% 619.680 679.444 3.02% 3,777,787 1.25% 1,398,522 - 28.35% 4,187 1.30% 2,451,000 3.66% 39,250 140.00% 1,000 2.15% 7.671,746 Page 6 3.91% 9.761.564 4.35% FY 13 - 88.70% ACTUAL 5.07% 188,360 100.00% 16,660 0.00% - 27.92% 225,760 13.21% 218,584 0.47% 38,320 15.18% 1,303 671.024 4.35% 469,283 - 88.70% 7,159 7.87% 3,316 - 100.00% 16,660 - 21.65% 24,064 - 75.80% (6,021) 0.00% - 21.28% 103,896 - 100.00% 1,303 2.88% 619.680 15.66% 440,175 - 85.51% 15,837 330.27% 3,284 - 61.05% 26,060 62.27% SB,460 - 90.88% 12,278 15.93% 586.094 6.35% 3,552,329 3.47% 1,351,568 186.78% 1,460 - 11.51% 2,769,914 6.18% 36,967 64.20% 609 -0.53% 71 12,047 1.79% 9,509,645 227 PM RNLD 22.53% 426,014 0.53% 423,763 312812014 ENGINEERING AND OPERATIONS DIVISION - 51.39% 51,432 - 30.77% BUDGET / ACTUAL D09D?ARISON SDNNAEY BDREDDLE DRAFT 1 24,000 193.15% 8,187 - 33.74% 3/31/14 01 -65- 5590.105 SUPPLIES 8,000 -7.26% 8,626 26.50% 6,019 01.65- 5580 -106 VEHICLE 4,660 - 734.06% (735) - 84.78% 2015 2014 - - 100.00% B1 - 92.07% BUDGET 7 LATHS ALT 13150D 75.14% BY 13 X60 NGR 55 TOTAL 3 ETEH am 597.168 19.12% ACTON, 01- 55- 5920 -101 LABOR REG 211,040 -1.42% 214,096 14.92% 186,997 01.55- 5920 -102 LABOR CT 1,500 106.33% 727 - 80.21% 31000 3,673 01- 55.5921 -000 OFFICE SUPPLIES - 0.00% - - 100.00% 513,259 197 01.55- 5930.103 BE EDUCATION 9,600 200.75% 3,192 - 64.59% 90,000 9,091 01-55- 5930 -106 VEHICLE 4,660 - 320.87% (2,110) - 64.96% 54,000 (6,021) 01- 55.5923 -000 OUTSIDE SERVICES 10,500 - 21.44% 13,365 - 34.34% 25,000 20,355 01- 55- 5930.105 NISC GXMRAL 500 56.74% 319 - 33.25% 26,605 478 808 -TOTAL 238.601 3.56% 230.389 7.27% 8,000 214.770 01.65 -SSB0 -101 LABOR REG 522,008 22.53% 426,014 0.53% 423,763 01.65- 5580 -102 LABOR OT 25,000 - 51.39% 51,432 - 30.77% 74,296 01 -65 -5500 -103 BE EDUCATION 24,000 193.15% 8,187 - 33.74% 12,356 01 -65- 5590.105 SUPPLIES 8,000 -7.26% 8,626 26.50% 6,019 01.65- 5580 -106 VEHICLE 4,660 - 734.06% (735) - 84.78% (4,828) 01 -63 -5921 -000 OFFICE SUPPLIES - - 100.00% B1 - 92.07% 1,021 01- 65- 3923.00D OUTSIDE SERVICES 13150D 75.14% 7,708 100.00% - SUB -TOTAL 597.168 19.12% $01,313 - 2.36% LIM 66 01.66. 5568 -109 NTN OF TRANS SIP 31000 5.63% 2,640 4.22% 2,725 01- 66- 5501 -101 LABOR NISC 513,259 - 23.25% 668,706 16.13% 575,531 01.65. 5581 -109 GSMRAL EIP 90,000 7.67% 83,587 1.21% 82,589 01.66. 5581.103 BE EDUCATION 54,000 92.76% 28,014 - 38.75% 45,738 01- 66.5585 -109 STEHET LIGHT EIP 25,000 6.10% 23,563 - 48.86% 46,074 01.66- 5585 -1D1 LABOR REG ST LIO 26,605 - 15.77% 31,585 - 21.72% 40,347 01 -66- 5585 -102 LABOR OT ST LIGHT 8,000 17.34% 6,818 - 34.12% 10,349 01- 66- 5585 -106 VEHICLE ST LIGHT 23,302 20.28% 19,373 -5.27% 20,451 01 -66. 5593.000 NTN OF LIMB 144,621 - 36.39% 227,670 4.14% 216,623 01 -66- 5593 -101 LABOR REG NTN LING 490,586 3.52% 473,920 -5.56% 501,812 01- 66- 5593.103 LABOR OT NTN LIM 241,566 - 19.14% 299,112 - 33.72% 451,361 01 -66- 5593 -106 VEHICLE NTN OH LIM 156,452 83.97% 06,131 217.49% 27,129 01-78. 5593.110 TRM TRIMUG 757,069 43.00% 529,411 26.47% 418,609 01 -66 -5594 -109 XTN UG LIM 104,755 - 62.52% 279,487 100.00% - 01- 66- 5594 -lD1 LABOR RBG UG LIME 15,559 - 37.20% 24,777 308.19% 6,070 01 -66- 5594 -102 LABOR OT UG LIM 5,000 - 40.71% 8,433 581.18% 1,238 01.66- 5594 -106 VEHICLE NTN M LIM 5,380 - 46.47% 10,051 - 410.60% (3,336) 01.66 -5596 -109 ST IT 6 0I0 ■IP 250 142.72% 103 - 99.95% 203,132 01-66- 5596 -101 LABOR "a ST LT /BG 6,915 124.74% 3,077 100.OD% - 01 -66- 5596 -102 LABOR OT ST LT /80 250 142.72% 103 100.00% - 01 -66- 5596 -106 VEHICLE ST LT /50 21330 216.60% 736 - 312.10% (347) 01 -66- 5921 -000 OFFICE SUPPLIES - - - 100.00% 302 SOB -TOTAL 2.676.399 -4.67% 2.807,497 6.00% 2. 48,697 • Page 6 2:28 PM RHLD - 51.39% - 30.77% 51,432 193.15% 3/2812014 ENGINEERING AND OPERATIONS DIVISION -7.26% 26.50% BUDGET / ACTUAL COMPARISON SOSNARY SCHEDULE DRAFT 1 - 84.78% (735) - 300.00% 3/31/14 81 75.14% 100.00% 7,706 C 31,585 - 21.72% 40,347 17.34% 6,818 - 34.12% 2015 20.28% 2014 -5.27% 20,451 - 36.39% EGDOST 4.14% 7 MTES AM 3.52% FY 13 SO SON 55 TOTAL - 19.14% 5 MTEE ROD - 33.72% ACTUAL 01 -55- 5920.101 LABOR RB(2 211,840 -1.42% 217.49% 214,696 14.92% 166,997 01 -55- 5920 -102 LABOR OT 11500 106.33% - 62.52% 727 - 80.21% 3,673 01-55- 5931 -ODO OFFICE SOPPLIES 0.00% 308.19% - •100.00% 197 01- 55.5930.103 BE SDOCATION 91600 200.75% - 46.47% 3,192 - 64.89% 91091 01 -55- 5930 -106 "RIms 4,660 •320.87% - 99.95% (2,110) - 64.96% (6,021) 01.55- 5923.000 ODTSIDS SERVICES 10,500 - 21.44% 142.72% 13,365 •34.34% 20,355 01 -55 -5930 -105 RISC GENERAL 500 56.74% - 312.10% 319 - 33.26% 478 S08 -TOTAL 238.601 3.56% -4.67% 230.389 7.27% 214.770 ]ENGINEERING 65 01 -65- 5580 -101 LABOR US 01 -65- 5580 -102 LABOR OT 01.65- 5580.103 BE EDUCATION 01 -65- 5580 -105 BUFPLIRS 01.65- 5580 -106 VEHICLE 01 -65- 5921 -000 OFFICE SUPPLIES 01 -65- 5923.000 OUTSIDE SERVICES 600 -TOTAL �3 66 01 -65 -5568 -109 STN OF TRANS REF 01.66. 5561 -101 LABOR NISC 01- 65- 5581.109 OBNEML UP 01- 66- 5581 -103 RR EDUCATION 01- 66.5585 -109 STREET LIGHT EIP 01.66- 5585.101 LABOR REG ST LIGHT 01- 66- 5585 -102 LABOR OT ST LIGHT 01 -66. 5585 -106 VEHICLE ST LIGHT 01- 66.5593 -000 HTN OF LIMB 01- 66- 5593 -101 LABOR REG STN LINE 01- 66- 5593 -102 LABOR OT NTH LINE 01-66- 5593 -106 VEHICLE STN OR LINK O1 -76- 5593 -110 TARE TRI39TING 01.66.5594 -109 STN DO LINE 01 -66- 5594 -101 LABOR REG 00 LINKS 01- 66- 5594.102 LABOR OT GO LING 01 -66. 5594.106 VBEICLB STE UG LINE 01 -66 -5596 -109 ST IT R SIG UP 01 -66. 5596 -101 LABOR RAG ST LT /SG 01 -66- 5596 -SD2 LABOR OT 9T LT /SG 01- 66- 5596 -106 VEHICLE 6T LT /SG 01.66 -5921 -000 OFFICE BOPPLIAS SOB -TOTAL 4* 522,006 25,000 24,000 8,000 4,660 13,500 597,168 3,000 513,259 90,000 54,000 25,000 26,605 6,000 23,302 144,621 490,566 241,866 158,452 757,069 104,755 15,559 5,000 5,380 250 6,915 250 2,330 22.53% 426,014 - 51.39% - 30.77% 51,432 193.15% - 33.74% 8,187 -7.26% 26.50% 6,626 - 734.06% - 84.78% (735) - 300.00% - 92.07% 81 75.14% 100.00% 7,706 19.12% 501.313 0.53% 2,840 423,763 - 30.77% - 23.25% 74,296 - 33.74% 575,831 12,356 26.50% 1.21% 6,819 - 84.78% 28,014 (4,828) - 92.07% 6.10% 1,021 100.00% 46,074 - 15.77% •3.36% 513.427 5.63% 2,840 4.22% 2,725 - 23.25% 668,706 16.13% 575,831 7,67% 83,597 1.21% 82,589 92.76% 28,014 - 38.75% 45,738 6.10% 23,563 - 48.86% 46,074 - 15.77% 31,585 - 21.72% 40,347 17.34% 6,818 - 34.12% 10,349 20.28% 19,373 -5.27% 20,451 - 36.39% 227,670 4.14% 218,623 3.52% 473,920 -5.56% 501,612 - 19.14% 299,112 - 33.72% 451,261 83.97% 86,131 217.49% 27,129 43.00% 529,411 26.47% 418,609 - 62.52% 279,487 100.00% - - 37.20% 24,777 308.19% 6,070 - 40.71% 8,433 581.18% 1,238 - 46.47% 10,051 - 410.60% (3,236) 142.72% 103 - 99.95% 203,132 124.74% 3,077 100.00% - 142.72% IDS 100.00% - 216.60% 736 - 312.10% (347) - - 100.00% 302 -4.67% 2.807.497 6.00% 2.648.697 Page 7 ° HEM o RUH ° o U 4 s °° 3 c Jill az czay �t "sSd^ � 7.r � $ • � 6 S A c SSS° d °rt R '1 1 � 9 5 MAI "erl R 1=C$Cp�yS(l :�n � y { G SS NiRA Y qS7 'gy lb ISS° d +g n S a "a9y HaS d^ k .IIc � —11 5 �3RAF G B •S S i :.r .97iii Ira pi q mN: l ® C Q ka?, ^ SR � ° HEM o RUH ° o U 4 DIE II I A E I a 5 i 9! € 1% 1 £ �. w 3 AID ' gffi a 1 16 5 1� 3a 2 F 14 1' z p . ax N d a #sF �ffi � 6x a u a 6 Rai I I 13 �p A a k 0 E I € 0 fill F o0 S oqa m oo I °° I # °1° Al d 1 9 00 k s I °° I # °1° f Al d 1 9 f � °�$'��.�RQ776�$�$�� SCSR ^n'.°^.�39 �1 SR�R • 8x S �i $ �iy$=?< 9?�R$ Q ='s? "s$$ =� 4 � °� �° 5`_Y .•�E9��n$3$.$$$�R$$'3 '� ax •FR. i�$ir5' °a "7� %�gz "Rx# � sg k _ %C6Z'a�BS�Am H•- �^. &F:$$ %$85��a��,598.8 �3� x R` �° ^ N 6$= c'is'E_ K7ICngg . FxwAR xx 5 Y piRxzYS`•:c6 $I, 'Ya YFFF ° KFN H unwonwunwunwunwunwwunwwoonwun w°wwewwww° u n ww i �• S6'w :�2 w y wflE€ 8 9 R$i6 iAo 3 ® HIM l _ 111,9 �1::w11 � € 11111.11 °° "_ z luv Pi a" $ 3$3y6aeB$ m l 123$ 3F11111ji m 6 I- a 9a6a�ss "6ewxa °an #Aga 6g6x.•Y3s6$ # ( a^ w Y Br.s Rvue F�^�'g�_6 9 B $$ $sgi$°$gB$°?a6 Biaa EY##E$aI6tl.6 A u ; Y � a � _S $j $$ �ga.��3�?e °B6x saa 3geRa$as3E$B 3 p}B 9i IN $$ R °sB -S M2 3 °?a6 ^Ba3 eFS "q$ !IF SIn g B 1 a° p I ma IN EBg $Ba "Sd3: � |! | !|! °`E|! !!! °`l!! ■ . ;, § °• § |! , ■ | | |'`! |! ■ ■! |! |'! || ■ , | |!�`! |! , ■|g! q; ,IMIER" | |„ , � ......'.. | � \` \� ii i §� |• |■ |! | � \` \� ii