Loading...
HomeMy WebLinkAbout15. Light WaterLIGHT AND WATER Public Benefit Programs  Recycling and Solid Waste   Consumer Services  Water  Utility  Electric Utility  312 THIS PAGE INTENTIONALLY LEFT BLANK 313 LIGHT AND WATER PUBLIC BENEFITS PROGRAM PROGRAM COMMENTARY PROGRAM DESCRIPTION: The California electric restructuring legislation (AB 1890) signed into law on September 23, 1996, requires municipal electric utilities to expend 2.85% of their retail revenues to fund investments in energy conservation. AB 1890 authorized municipal utilities to impose a surcharge on customers to pay for these investments, and, at this time, the usage surcharge, referred to as the public benefit charge (PBC) is expected to continue indefinitely for all California Publicly Owned Utilities. The Public Benefits program provides cost-effective demand-side management services to promote energy-efficiency and energy conservation; investment in renewable energy resources and technologies consistent with existing statutes and regulations; research, development and demonstration programs that advance science or technology which would not result from regulated competitive market environments; and services provided to low-income electricity customers, including but not limited to, targeted energy efficiency services and rate discounts. FY 15-16 STRATEGIC GOALS:  Continue to promote the availability of an electric discount rate for economic development  Continue to leverage utility programs and rates to encourage city and local business growth while targeting specific economic development areas  Continue to implement City energy efficiency projects for City facilities to reduce utility consumption and expenses FY 14-15 PROGRAM HIGHLIGHTS:  Achieved estimated gross annual energy savings of 2,896,975 kWh in the most recent reporting period from several conservation programs such as: (1) Commercial & Industrial Energy Partnership program which provides energy audits for businesses and annual incentives up to $10,000 or 50% of project cost, except for lighting retrofits which have a 100% incentive up to $1,500 and 50% above that, up to the maximum rebate of $10,000; (2) CFL & LED giveaways to promote energy efficient lighting; (3) Residential Weatherization Rebate Program; (4) Energy Star Appliance Rebate Program for refrigerators, washing machines, dishwashers, LED TV, air conditioners and other Energy Star rated appliances; (5) Shade Tree Program; (6) Residential Low Income assistance; (7) Educational and online learning opportunities regarding energy conservation; (8) Small Business Retrofit program; and (9) The “Keep Your Cool” program, targeted at small independently owned and operated convenience stores. 314 Budget Division: LIGHT AND WATER - PUBLIC BENEFIT PROGRAMS FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Utility Programs Specialist(a)0.70 0.70 $61,710 $61,710 Asst Director-Cust Care and Solutions(b)0.15 0.05 17,585 6,485 Utility Adm & Fin Svc Mgr (c)0.00 0.05 - 4,955 Customer Service Representaive III (d)0.00 0.30 - 19,015 Director of Utililites (e)0.00 0.05 - 9,100 (a) .30 FTE Water (b) .95 FTE Consumer Services-Employee Expense (c) .70 FTE Admin, .25 FTE Solid Waste (d) .70 FTE Admin, .30 FTE Cust Care and Solution (e) .90 FTE Admin, .05 Public Benefit TOTAL 0.85 1.15 $79,295 $101,265 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 315 BUDGET UNIT: 2440739xxx L&W PUBLIC BENEFIT PROGRAMS DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct. #12-13 13-14 14-15 14-15 15-16 VARIANCE PERSONNEL ADMINISTRATION OF PBC 6003 Salaries/Regular 72,600 80,935 79,295 79,515 101,265 21,970 6006 Salaries/Temp & Part-Time 7,610 5,258 7,470 6,353 - (7,470) 6045 Salaries/Education Incentive 1,120 1,240 1,235 1,205 1,090 (145) 6069 Allowances/Vehicle - - - - 270 270 6101 PERS/Employee Contribution 5,700 5,882 5,830 5,803 7,285 1,455 6105 PERS/Employer Contribution 7,855 7,881 7,280 7,980 11,655 4,375 6109 PARS/Employer Contribution 5,535 6,089 9,350 5,981 13,940 4,590 6125 FICA/Employer Contrib/Med 1,375 1,631 1,505 1,549 1,770 265 6140 Life Insurance Allocation 195 214 220 202 270 50 6155 Workers' Comp Allocation 3,255 3,572 3,600 3,483 4,105 505 6160 LTD Insurance Allocation 555 618 635 607 790 155 6165 Unemployment Allocation 75 89 100 83 120 20 6175 Benefits/Flex Plan 12,060 13,379 13,730 13,730 19,155 5,425 6180 Deferred Comp/Employer Paid 130 1,275 1,530 1,530 1,550 20 SUBTOTAL 118,065 128,061 131,780 128,020 163,265 31,485 PERSONNEL SUBTOTAL 118,065 128,061 131,780 128,020 163,265 31,485 316 2440739xxx 6625 Program Expense - Low Income Assistance Program, Energy Efficiency Program, Renewables Program, Research & Development. Administration of PBC. LIGHT & WATER - PUBLIC BENEFITS PROGRAM ACTIVITY DETAIL Account Number Description 317 BUDGET UNIT: 2440739xxx L&W PUBLIC BENEFIT PROGRAMS DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct. #12-13 13-14 14-15 14-15 15-16 VARIANCE OPERATIONS RESIDENTIAL LOW INCOME 6625 Program Expense 50,615 48,620 50,000 50,000 50,000 - SUBTOTAL 50,615 48,620 50,000 50,000 50,000 - - ENERGY EFFICIENCY PROGRAM - 6625 Program Expense 966,855 525,006 678,500 625,000 678,500 - SUBTOTAL 966,855 525,006 678,500 625,000 678,500 - - RESEARCH & DEVELOPMENT - 6625 Program Expense - - 10,000 3,100 10,000 - SUBTOTAL - - 10,000 3,100 10,000 - - RENEWABLES - 6625 Program Expense - - 60,000 25,000 60,000 - SUBTOTAL - - 60,000 25,000 60,000 - - ADMINISTRATION OF PBC - 6551 Fuel and Oil - - 2,000 - - (2,000) 6625 Program Expense 37,045 50,198 50,000 50,000 50,000 - 6825 Maint & Repair/Vehicle - 72 8,000 2,000 2,000 (6,000) 6850 Lease Payments 845 3,311 3,500 3,500 3,350 (150) SUBTOTAL 37,890 53,581 63,500 55,500 55,350 (8,150) OPERATIONS SUBTOTAL 1,055,360 627,206 862,000 758,600 853,850 (8,150) TRANSFERS ADMINISTRATION OF PBC 5950 Transfers To 2,845 10,337 - 5,325 - - TRANSFERS SUBTOTAL 2,845 10,337 -5,325 -- 318 BUDGET UNIT: 2440739xxx L&W PUBLIC BENEFIT PROGRAMS DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct. #12-13 13-14 14-15 14-15 15-16 VARIANCE PUBLIC BENEFIT PROG FUND TOTAL 1,176,270 765,604 993,780 891,945 1,017,115 23,335 319 LIGHT AND WATER RECYCLING AND SOLID WASTE PROGRAM COMMENTARY PROGRAM DESCRIPTION: Recycling and Solid Waste Management programs are managed by the Administrative Division of the Utilities Department. Refuse collection and recycling services are provided on a contract basis by Athens Services. Through Athens Services, the City’s “Green Waste” is diverted to Recycled Wood Products where it is recycled into a variety of landscape and gardening products. Utilities Administration works closely with the Customer Service division on rate setting, billing, customer service and public information issues. Utilities Administration also administers two State-provided block grant programs (the Used Oil Recycling Block Grant and the Beverage Container Recycling Grant), and promotes smart gardening and composting, use of reusable grocery bags, and proper disposal of “sharps” medical waste and other recycling & conservation programs. Division activities include support of code enforcement regarding illegal disposal issues and violations of Athens Services’ Exclusive Franchise Agreement. FY 15-16 STRATEGIC GOALS:  Maintain a waste diversion rate of 50% or more to stay in compliance with the State’s recycling mandate, AB 939  Develop additional waste diversion programs to make progress toward the 2020 goal of 75% waste diversion as set by AB 341  Develop and promote programs that will ensure the city’s compliance with AB 1826 “Organic Waste Recycling” and AB 1594 “Compostable Organics Management”  Maintain competitive rates for refuse collection services  Promote recycling and proper disposal of used motor oil, household hazardous wastes and sharps medical waste  Enhance public information and promotion of various recycling programs such as backyard composting, compost and mulch distribution, e-waste, and paper recycling  Continue consideration of automated residential trash collection service for residential customers FY 14-15 PROGRAM HIGHLIGHTS:  Identified volume discounted landfill rates given to Athens by the Los Angeles County Sanitation District in FYs 2012/13 and 2013/14 and passed on credits to customers in FY 14-15 rates  Achieved a waste diversion rate of more than 65% in the most recent compliance period  Implemented a City-employee recycling program, including white paper, batteries, beverage containers, ink cartridge, and foam cup recycling  Secured Used Oil Recycling and Beverage Container Recycling Grants from CalRecycle  Installed Sharps collection centers at the City’s Senior Center, providing a no-cost disposal solution for customers 320 Budget Division: LIGHT AND WATER - RECYCLING AND SOLID WASTE FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Utilities Admin and Financial Svcs Manager (a)0.25 0.25 $24,095 $25,365 Director of Utililites (b)0.00 0.05 0 9,100 Senior Administrative Technician (c)0.50 0.50 30,770 30,770 City Manager(d)0.00 0.20 - 39,700 (a) .70 FTE Admin, .05 FTE Public Benefit (b) .90 FTE Admin, .05 Public Benefit (c) .50 FTE Admin (d) .50 City Mgr Admin, .30 Light & Water Admin TOTAL 0.75 1.00 $54,865 $104,935 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 321 BUDGET UNIT: 3940750065/3640750000 LIGHT & WATER-SOLID WASTE MGT DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct. #12-13 13-14 14-15 14-15 15-16 VARIANCE PERSONNEL OIL BLOCK GRANT 6003 Salaries/Regular 1,621 --- SUBTOTAL - 1,621 --- - AB 939 FEE 6003 Salaries/Regular 42,400 46,168 54,865 59,805 106,405 51,540 6033 OT/Premium -141 -1,055 - - 6045 Sal/Ed Inc -176 -355 - - 6047 Sal/Bonus -1,285 ---- 6048 Sal/Lang Pay ---1,095 -- 6070 Allowances/Telephone ----600 600 6101 PERS/Employee Contribution 3,085 3,374 3,850 3,885 7,440 3,590 6105 PERS/Employer Contribution 3,775 4,190 4,820 4,865 11,875 7,055 6109 PARS/Employer Contribution 930 -1,695 -4,350 2,655 6125 FICA/Employer Contrib/Med 755 856 960 960 1,790 830 6140 Life Insurance Allocation 115 125 145 140 280 135 6155 Workers' Comp Allocation 1,755 1,973 2,165 2,235 4,280 2,115 6160 LTD Insurance Allocation 335 368 420 415 815 395 6165 Unemployment Allocation 45 52 65 60 125 60 6175 Benefits/Flex Plan 10,045 10,553 12,115 16,155 16,155 4,040 6180 Deferred Comp/Employer Paid 60 548 720 1,000 1,000 280 SUBTOTAL 63,300 69,808 81,820 92,025 155,115 73,295 PERSONNEL SUBTOTAL 63,300 71,429 81,820 92,025 155,115 73,295 322 Description 2840750xxx 3640750xxx 3940750xxx 6235 Meetings/Conferences - For attendance at forums of Southern California Waste Management Forum, Solid Waste Association of North America (SWANA), California Resource Recovery Association (CRRA) and other locally sponsored recycling/solid waste conferences 6301 Legal Fees - This amount cover expenses for solid waste legal consultation for solid waste matters 6625 Program Expenses - Program expenses in this cost center cover programs such as used oil block grant administration ($13,542), beverage container recycling program ($12,560) disposal of hazardous waste generated from city facilities ($15,000), sharps collection program advertising and implementation ($3,000), e-waste collection event ($1000), smart gardening and composting workshop ($3,000), compost-mulch giveaway event ($1,000), shred day event ($1,000), reusable bag purchases ($2,500), and other commercial recycling program public education campaign ($9,500) 6455 Refuse Contract - This is the amount expected to be billed by Azusa Light & Water for residential refuse collection services provided by Athens Services. This is amount paid to Athens Services excluding City fees, such as the Franchise Fee and AB 939 Fee 6518 Postage - This amount covers refuse rate adjustment Public Hearing Notice mailing postage 6539 Printing, Binding, Duplicating - This amount covers printing of refuse rate adjustment Public Hearing Notice 7055 Uncollectible Accounts - This is for write offs of uncollectible accounts. Account Number LIGHT & WATER - RECYCLING AND SOLID WASTE ACTIVITY DETAIL 323 BUDGET UNIT: 3940750065/3640750000 LIGHT & WATER-SOLID WASTE MGT DESCRIPTION REVISED YEAR END EST ADOPTED Acct. #14-15 14-15 15-16 VARIANCE Explanation 6455 Refuse Collection 3,002,500 3,000,000 3,333,500 331,000 Increase due to change in MV Landfill ($28.86 to $29.53) and RWP ($23.69 to $24.40) rates, elimination of one-time credit, and 2% est. increase in residential customers 5950 Transfers Out 682,660 685,675 747,935 65,275 Franchise Fee ($553,000 to $615,600) and CS Billing allocation to Refuse ($132,335 vs. $129,660) - Increase due to change in MV Landfill ($28.86 to $29.53) and RWP ($23.69 to $24.40) rates, elimination of one-time credit, and 2% est. increase in residential customers 324 BUDGET UNIT: 3940750065/3640750000 LIGHT & WATER-SOLID WASTE MGT DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct. #12-13 13-14 14-15 14-15 15-16 VARIANCE OPERATIONS OIL BLOCK GRANT 6625 Program Expense 9,975 9,715 13,400 13,400 13,540 140 SUBTOTAL 9,975 9,715 13,400 13,400 13,540 140 BEVERAGE CONTAINER RECYCLING 6625 Program Expense -9,983 12,560 10,000 12,560 - SUBTOTAL - 9,983 12,560 10,000 12,560 - AB 939 FEE 6235 Meetings & Conferences 5 323 1,000 1,000 1,000 - 6240 Mileage Reimb - 24 --- - 6301 Legal Fees -10,497 12,000 12,000 10,000 (2,000) 6340 Special Studies - 23,959 24,000 -- (24,000) 6518 Postage 1,820 1,696 2,000 2,000 2,000 - 6527 Supplies/Computer 60 30 150 150 - (150) 6539 Printing, Binding & Duplicating 1,785 285 2,500 2,500 2,500 - 6625 Program Expense 25,665 163,677 36,000 36,000 36,000 - 6915 Utilities/Telephone 630 621 --- - 7025 Overhead Expense 16,830 -33,655 33,655 - (33,655) SUBTOTAL 46,795 201,112 111,305 87,305 51,500 (59,805) REFUSE CONTRACT 6455 Refuse Collection 2,801,090 2,913,584 3,002,500 2,800,000 3,333,500 331,000 7055 Uncollectible Accounts 33,950 24,671 26,000 21,000 25,000 (1,000) SUBTOTAL 2,835,040 2,938,255 3,028,500 2,821,000 3,358,500 330,000 OPERATIONS SUBTOTAL 2,891,810 3,159,064 3,165,765 2,931,705 3,436,100 270,335 325 BUDGET UNIT: 3940750065/3640750000 LIGHT & WATER-SOLID WASTE MGT DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct. #12-13 13-14 14-15 14-15 15-16 VARIANCE TRANSFERS OUT REFUSE CONTRACT 5950 Transfers Out 675,410 639,662 682,660 685,675 747,935 65,275 SUBTOTAL 675,410 639,662 682,660 685,675 747,935 65,275 TRANSFERS OUT SUBTOTAL 675,410 639,662 682,660 685,675 747,935 65,275 SOLID WASTE MGMT. TOTAL 3,630,520 3,870,155 3,930,245 3,709,405 4,339,150 408,905 FUNDING: AB 939 FEE FUND 39 (110,095) (270,920) (193,125) (179,330) (206,615) (13,490) GRANT FUND 28 (9,975) (21,318) (25,960) (23,400) (26,100) (140) REFUSE FUND 36 (3,510,450) (3,577,917) (3,711,160) (3,506,675) (4,106,435) (395,275) Total Funding (3,630,520) (3,870,155) (3,930,245) (3,709,405) (4,339,150) (408,905) 326 LIGHT & WATER CONSUMER SERVICES PROGRAM COMMENTARY PROGRAM DESCRIPTION: This portion of the budget consists of the Utility Board, Utilities Administration, and Customer Service. The City Council meets monthly as the Utility Board pursuant to the Azusa Municipal Code to provide policy direction to the Utilities Department. Utilities Administration administers the Utility Board agenda process and coordinates preparation of the Department budget, work plan, legislative monitoring, property management, facilities maintenance, purchasing, payment processing, payroll, and assists with work order tracking and billing. Utilities Administration also conducts financial analysis, prepares various reports, and determines when rate adjustments are necessary. Customer Service consists of three cost centers, including Records and Collections, Meter Reading, and Supervision. Customer Service is responsible for electric and water utility billing, collections, answering customer calls, assisting walk-in customers, meter reading, turning services on and off, month-end closing of utility financial records and maintaining the financial reporting interface to Finance Department. Additionally, Customer Service bills for sewer, solid waste collection, public benefits program and community maintenance fees. This division is responsible for key account services for large business customers and both water & electric conservation programs. FY 2015-16 STRATEGIC GOALS:  Complete full deployment of new Utility customer service phone management system to include integration with the utility billing system to provide customers with enhanced self-service options over the phone  Integrate credit and debit card payments with the utility billing system and install credit card swipers at the cashier counter  Complete due diligence review of a utility modernization project to include two way automated meters and enhanced customer/utility information availability FY 2014-15 PROGRAM HIGHLIGHTS:  Coordinated preparation and issuance of Request for Proposals for utility modernization project involving mass meter replacements and deployment of wireless network to read meters. Issued RFP and evaluated proposals received with other managers.  Implemented new Customer Service Telephone System, which uses internet and softphones to provide enhanced service to utility customers at reduced wait times. System includes management features that allow us to improve the quality of service provided to customers. 327 FY 2014-15 PROGRAM HIGHLIGHTS (continued):  Formulated contract with outside vendor to provide electronic payment options to customers that will result in customers being able to use credit and debit cards to make payments to cashiers, over the telephone, and via the web, at no cost to customers, and all payments will be integrated with billing system to update customer payment status in real time.  Continued to make changes to disconnect and reconnect procedures for delinquent customers to reduce complaints. Changes include option to allow customers to pay reconnect charge with next bill, not disconnecting customers if payment is made day of scheduled shut off if the shut off has not already been performed, and reconnecting customers as soon as possible once shut off has occurred--as opposed to waiting until after 3:00 pm (previous procedure). These changes have dramatically reduced the number of adverse interactions with customers regarding shut offs. 328 Budget Division: LIGHT AND WATER - CONSUMER SERVICES (ALL) FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Director of Utilities(a) 1.00 0.90 $182,000 $163,800 Cashiers 3,327 3,327 $53,455 $53,455 Utilities Admin and Financial Svcs Manager(b)0.75 0.70 72,820 69,350 Drought Tech 3,396 3,396 62,590 62,590 Senior Management Analyst 1.00 1.00 76,280 76,280 Cust Srv Rep I 1,670 1,670 32,685 32,840 Senior Administrative Technician(c)0.50 0.50 30,770 30,770 Meter Reader 4,368 4,368 111,560 111,560 Asst Director-Cust Care and Solutions(d)0.85 0.95 112,015 123,215 Customer Care Operations Supervisor 1.00 1.00 82,760 85,980 Customer Services Representative III 11.00 10.70 669,940 679,930 Field Services Representative 2.00 2.00 138,240 141,750 Field Services Supervisor 1.00 1.00 73,495 77,170 Meter Reader 4.00 4.00 264,540 273,120 Administrative Analyst 1.00 1.00 66,945 70,290 City Manager(e)0.30 0.30 59,550 59,550 (a) .05 FTE Solid Waste, .05 Public Benefit (b) .25 FTE Solid Waste, .05 FTE Public Benefit (c) .50 FTE Solid Waste, 50 FTE Admin (d) .05 FTE Public Benefits (e) .10 FTE CFD-Rosedale; .60 FTE Administration TOTAL 24.40 24.05 $1,829,355 $1,851,205 TOTAL 12,761 12,761 $260,290 $260,445 Full Time Positions Part Time Positions 329 BUDGET UNIT: ALL FUND 31 DIVISIONS-CONSUMER SERVICES (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 PERSONNEL 6003 Salaries/Regular 1,631,155 1,691,891 $1,829,355 1,716,356 1,851,205 21,850 6006 Salaries/Temp & Part-Time 120,005 154,795 260,290 237,964 260,445 155 6033 Overtime Pay/Premium 3,990 2,079 20,000 5,727 5,500 (14,500) 6039 Salaries/Education Incentive -400 -590 -- 6045 Standby Pay/Premium 4,435 6,744 4,485 7,200 4,630 145 6047 Salaries/Bonuses -13,172 ---- 6048 Salaries/Language Pay 18,185 18,048 18,270 18,567 15,600 (2,670) 6063 Salaries/Jury Duty 850 609 -608 -- 6069 Allowances/Vehicle 27,020 26,720 25,560 26,090 25,860 300 6070 Allowances/Telephone 300 301 450 195 900 450 6091 Leave Liability Adjustments 31,940 (9,451) ---- 6101 PERS/Employee Contribution 121,565 123,655 137,220 124,857 140,095 2,875 6105 PERS/Employer Contribution 215,300 175,508 170,950 177,095 222,510 51,560 6109 PARS/Employer 284,825 71,917 95,795 81,442 133,320 37,525 6125 FICA/Employer Contrib/Med 28,470 30,187 34,955 32,137 35,590 635 6133 Retiree Health Premium Reimb 11,045 9,968 11,160 9,580 10,425 (735) 6140 Life Insurance Allocation 4,300 4,385 4,885 4,263 4,990 105 6155 Workers' Comp Allocation 71,040 75,633 83,355 79,936 85,490 2,135 6160 LTD Insurance Allocation 12,565 13,146 14,100 13,014 14,420 320 6165 Unemployment Allocation 1,915 1,956 2,515 2,047 2,555 40 6175 Benefits/Flex Plan 414,210 408,126 430,545 424,315 424,315 (6,230) 6179 Affordable Care Act Penalty --4,545 -18,000 13,455 6180 Deferred Comp/Employer Paid 2,230 4,586 5,740 7,775 7,775 2,035 PERSONNEL SUBTOTAL 3,004,495 2,823,766 3,154,175 2,969,150 3,263,625 109,450 330 Budget Division: LIGHT AND WATER - CONSUMER SERVICES-ADMINISTRATION FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Director of Utilities(a) 1.00 0.90 $182,000 $163,800 Utility Admin & Fiscal Svc Mgr(b)0.75 0.70 $72,818 $69,350 Senior Management Analyst 1.00 1.00 $76,280 $76,280 Senior Administrative Technician(c)0.50 0.50 $30,770 $30,770 City Manager(c)0.30 0.30 $59,550 $59,550 (a) .05 FTE Solid Waste, .05 Public Benefit (b) .25 FTE Solid Waste, .05 FTE Public Benefit (c) .50 FTE Solid Waste TOTAL 3.55 3.40 $421,418 $399,750 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 331 Budget Division: LIGHT AND WATER - CONSUMER SERVICES-CUSTOMER CARE FIELD SRV FY 14-15 FY 15-16 FY 14-15 FY 15-16FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Field Services Representative 2.00 2.00 $138,240 $141,750 Drought Tech 3,396 3,396 $62,590 $62,590 Field Services Supervisor 1.00 1.00 73,495 77,170 Meter Reader 4,368 4,368 111,560 111,560 Meter Reader 4.00 4.00 264,540 273,120 TOTAL 7.00 7.00 $476,275 $492,040 TOTAL 7,764 7,764 $174,150 $174,150 Full Time Positions Part Time Positions 332 Budget Division: LIGHT AND WATER - CONSUMER SERVICES-CUST. CARE RECS & COLL. FY 15-16 FY 14-15 FY 15-16 FY 14-15 FY 15-16FY 14-15 FY 15-16 FY 14-15 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Administrative Analyst 1.00 1.00 $66,943 $70,290 Cashiers 3,327 3,327 $53,455 $53,455 Customer Care Operations Supervisor 1.00 1.00 82,760 85,980 Cust Srv Rep I 1,670 1,670 32,685 32,840 Customer Services Representative III (a)11.00 10.70 669,940 679,930 (a) .30 FTE Public Benefit TOTAL 13.00 12.70 $819,643 $836,200 TOTAL 4,997 4,997 $86,140 $86,295 Full Time Positions Part Time Positions 333 Budget Division: LIGHT AND WATER - CONSUMER SERVICES-CUST. CARE EMPLOYEE EXP. FY 15-16FY 14-15 FY 15-16 FY 14-15 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Asst Director-Cust Care and Solutions (a)0.85 0.95 $112,014 $123,215 (a) .05 FTE Public Benefits TOTAL 0.85 0.95 $112,014 $123,215 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 334 Description 3140701xxx, 3140702xxx, 3140711xxx, 6220 Training Schools - American Public Power Association (APPA) training workshops; California Municipal Utilities Association (CMUA) training workshops; Liebert Cassidy Whitmore training workshops via City’s membership in the San Gabriel Valley Employment Relations Consortium; and other work related training as deemed necessary by Utilities Administration and Customer Services Division. 6235 Meeting/Conferences - APPA Legislative Rally, APPA National Conference, CEC Meetings, CMUA Annual Conference and Board Meetings, CMUA Capitol Day and Utility Managers Summit, Executive Steering Committee, Light & Water Key Accounts Meeting, Lodi Energy Center Meetings, National League of Cities Conference, NCPA Annual Conference and Directors Meeting, Public Officials Workshop, San Juan Power Operations Meetings, SCPPA Congressional Tour, State of the City, Utility Billing System Users' meeting, California Municipal Rates Group (CMUG) meeting, and National Association of Credit Management (NACM) conference. 6399 Professional Services - Accounting services for FARECal Certificates of Participation, San Gabriel Property Renovation Project Feasibility Study and Hazardous Materials Assessment, other miscellaneous. 6415 Computer Software Services - Utility Billing System maintenance, and enhancement programming, including integration programming with Interactive Voice Response (IVR) system to provide balance information to customers; also billing system maintenance for Time-of-Use (TOU) customers. 6493 Outside Services & Repairs - Pest control services, document archive/retrieve services, locksmith services, after hours answering service, lockbox, bill print and mail and online billing and payment services, credit card processing services, and temporary employment agency services. 6539 Printing, Binding & Duplicating - Copier's printing & service fees, business card printing, utility billing inserts, and door hangers. 6601 Advertising Expense - Recreation Gym Decal and miscellaneous. ($1,000 for Admin) 6815 Maintenance & Repair of Building - Light & Water Office building roof annual maintenance and other miscellaneous repairs 6825 Maintenance & Repair of Vehicles - Miscellaneous repairs for trucks used by Meter Readers and Field Service Representatives. 6835 Maintenance & Repair of Equipment - Azusa Light & Water heating, ventilation and air conditioning (HVAC) equipment, elevator, fire extinguishers, waterfall, outdoor LED electronic sign, automatic doors, vending machines, printers, fax machine, ice machine, drinking fountains, and office equipment maintenance and repairs, and repairs of meter reading hand held units and other equipment 6915 Utilities/Telephone - inContact Call Management System and Usage Fees, cell phone service, and cellular service to read Time of Use meters. LIGHT & WATER - CONSUMER SERVICES ACTIVITY DETAIL Account Number 335 DescriptionAccount Number 7050 Donations/Contributions - Azusa Chamber of Commerce, Golden Week, City's Annual Winter Festival by Recreation & Family Services Department, Rose Parade, Civic Leadership, and other miscellaneous donations. 336 BUDGET UNIT: ALL FUND 31 DIVISIONS-CONSUMER SERVICES (SUMMARY) DESCRIPTION REVISED YEAR END EST ADOPTED Acct. #14-15 14-15 15-16 VARIANCE Explanation 6201 Uniform & Laundry 14,900 16,000 16,000 1,100 Increase in uniform costs due to addition of PT staff 6301 Legal Fees 18,500 20,500 23,000 4,500 Anticipate increase in cost for legal review of UB packets 6415 Computer Software Support 129,300 132,000 160,250 30,950 $30,750 Webconnect from S&S; $15,000 IVR programming; $8,700 Itron MV-90 License Maint; $25,000 3rd Party Software Licenses; $2,800 enQuesta Server Maint; $43,000 enQuesta Maint; $35,000 for Programming of billing system enhancement 6423 Administrative Allocation 957,610 957,610 1,135,115 177,505 Administrative allocation increased but the transfer out (Acct 5950) decreased by $277,575 thus the net of both accounts is an over reduction. 6430 Custodial Services 11,700 11,700 14,040 2,340 Increase for Progreen Building Maintenance janitorial services contract 6493 Outside Services & Repairs 171,000 172,000 201,800 30,800 $1,100 Orkin Pest Control (general pests and fleas), $1,000 Alpine Exterminators (termites), $500 Raven Pest Control (Birds), $500 Barney's Locksmith, $1,100 Misc, $34,800 for InvoiceCloud absorbed credit card fees; Equifax $7,200; Garda $5,000; InfoSend/InvoiceCloud ACH Processing $8,500; InfoSend Bill Print and Mail $60,000; InfoSend/InvoiceCloud $26,000; Inland Desert Answering Svc $11,000; Iron Mtn $1,500; RT Lawrence $27,000; Temp Agency $10,000; Wells Escrow Acct $1,500; $4,000 Bee Removal Service; $1,100 Misc. 6760 Insurance Allocation 585,350 585,350 662,740 77,390 Due to increase insurance costs 6850 Lease Payments --5,000 5,000 New vehicle lease Customer Service division ($281.50/month + $1500 down payment) 6904 Utilities/Other 14,000 16,000 16,000 2,000 Increased budget to better align with actuals 337 BUDGET UNIT: ALL FUND 31 DIVISIONS-CONSUMER SERVICES (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 OPERATIONS 6201 Uniforms & Laundry 14,605 16,279 14,900 16,000 16,000 1,100 6220 Training Schools 2,015 2,269 1,500 1,500 1,500 - 6230 Dues & Subscriptions -57 250 -100 (150) 6240 Mileage Reimbursement 25 59 100 100 100 - 6235 Meetings & Conferences 14,470 11,858 26,750 12,400 25,750 (1,000) 6301 Legal Fees 26,315 19,405 18,500 20,500 23,000 4,500 6399 Professional Services/Other 16,330 23,645 85,000 21,000 31,000 (54,000) 6415 Computer Software Support 108,255 92,416 129,300 132,000 160,250 30,950 6423 Administrative Allocation 971,980 954,320 957,610 957,610 1,135,115 177,505 6430 Custodial Services 10,045 9,138 11,700 11,700 14,040 2,340 6493 Outside Services & Repairs 143,135 169,497 171,000 172,000 201,800 30,800 6518 Postage 125,300 122,974 160,000 160,000 135,000 (25,000) 6521 Messenger Service 575 260 750 650 550 (200) 6530 Office Supplies 11,675 10,245 13,800 13,800 13,800 - 6539 Printing, Binding & Duplicating 5,090 4,112 10,000 7,500 8,000 (2,000) 6551 Fuel and Oil 17,990 19,109 23,000 23,000 23,000 - 6554 Supplies/Custodial & Cleaning 3,205 3,588 4,000 4,000 4,000 - 6563 Supplies/Special 9,320 7,696 11,200 8,800 10,500 (700) 6564 Supplies/Medical-Dental 375 733 1,550 600 700 (850) 6566 Small Tools 645 -2,000 1,000 2,000 - 6569 Small Equipment -5,938 2,000 2,000 2,000 - 6570 Computer Peripherals/Misc 515 -1,000 500 1,000 - 6572 Office Furniture & Equipment 3,315 988 4,000 500 2,000 (2,000) 6601 Advertising Expense -546 1,000 -500 (500) 6615 Safety & Security Services Exp 1,935 2,580 6,000 5,000 5,000 (1,000) 6670 IT Allocation 649,375 508,371 717,570 717,570 594,255 (123,315) 6760 Insurance Allocation 529,270 597,925 585,350 585,350 662,740 77,390 6805 Maintenance/Land Improvements 8,325 8,993 12,000 12,000 12,000 - 6815 Maint & Repairs/Bldgs 21,645 18,296 28,600 27,000 23,700 (4,900) 6825 Maint & Repair / Vehicle 12,855 9,916 15,000 12,400 15,000 - 6835 Maint & Repair/Equipment 21,510 20,809 55,700 49,000 41,000 (14,700) 6840 Rent/Office Furniture & Equip 5,560 3,970 6,000 6,000 6,000 - 6850 Lease Payments ----5,000 338 BUDGET UNIT: ALL FUND 31 DIVISIONS-CONSUMER SERVICES (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 6904 Utilities/Other 13,810 14,364 14,000 16,000 16,000 2,000 6915 Utilities/Telephone 9,215 10,365 70,300 38,800 69,800 (500) 7009 Bank Service Charges -66,002 500 --(500) 7050 Donations/Contribution 50,995 55,033 57,500 57,500 57,500 - 7140 Equip & Machiner -2,507 4,360 --(4,360) OPERATIONS SUBTOTAL 2,809,675 2,794,262 3,223,790 3,093,780 3,319,700 90,910 TRANSFERS OUT 5950 Transfers Out 551,875 719,895 703,125 747,725 428,790 (274,335) TRANSFERS OUT SUBTOTAL 551,875 719,895 703,125 747,725 428,790 (274,335) CONSUMER SERVICE FUND TOTAL: 6,366,045 6,337,923 7,081,090 6,810,655 7,012,115 (73,975) 339 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Utility Board 6235 Meetings & Conferences 1,080 720 3,000 900 2,000 (1,000) 6301 Legal Fees 22,495 18,885 15,000 18,000 20,000 5,000 6521 Messenger Service 75 -300 -100 (200) 6539 Printing, Binding & Duplicating -226 --- - 6670 IT Allocation 13,775 8,168 18,000 18,000 18,000 - Subtotal 37,425 27,999 36,300 36,900 40,100 3,800 Utility Administration 6601 Advertising Expn -546 --- - Subtotal -546 --- - Consumer Services - Administrative 6220 Training Schools 495 518 500 500 500 - 6230 Dues & Subscriptions -57 250 -100 (150) 6235 Meetings & Conferences 10,495 7,397 17,550 8,000 17,550 - 6240 Mileage Reimbursement -45 --- - 6301 Legal Fees 1,075 378 1,500 500 1,000 (500) 6399 Professional Services/Other 11,310 23,645 85,000 21,000 31,000 (54,000) 6493 Outside Services & Repairs -27 800 200 200 (600) 6521 Messenger Service 190 92 250 250 250 - 6530 Office Supplies 2,495 2,923 3,800 3,800 3,800 - 6539 Printing, Binding & Duplicating 2,355 2,469 3,500 3,500 3,500 - 6563 Supplies/Special 140 758 2,000 800 800 (1,200) 6564 Supplies/Medical-Dental 55 191 800 100 200 (600) 6570 Computer Peripherals/Misc 515 -1,000 500 1,000 - 6572 Office Furniture & Equipment 1,610 -2,000 -1,000 (1,000) 6601 Advertising Expense --1,000 -500 (500) 6915 Utilities/Telephone 1,860 1,317 2,000 1,500 1,500 (500) 7050 Donations/Contribution 50,995 55,033 57,500 57,500 57,500 - 7140 Equip & Machiner -2,507 4,360 --(4,360) Subtotal 83,590 97,356 183,810 98,150 120,400 (63,410) 340 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Utilities - Administration 6423 Administrative Allocation 971,980 954,320 957,610 957,610 1,135,115 177,505 6760 Insurance Allocation 529,270 597,925 585,350 585,350 662,740 77,390 Subtotal 1,501,250 1,552,245 1,542,960 1,542,960 1,797,855 254,895 General Plant - Maintenance 6430 Custodial Services 10,045 9,138 11,700 11,700 14,040 2,340 6493 Outside Services & Repairs 1,080 4,187 4,600 3,100 4,600 - 6554 Supplies/Custodial & Cleaning 3,205 3,588 4,000 4,000 4,000 - 6563 Supplies/Special 730 860 1,000 1,000 1,000 - 6615 Safety & Security Services Exp 1,935 2,580 6,000 5,000 5,000 (1,000) 6805 Maintenance/Land Improvements 8,325 8,993 12,000 12,000 12,000 - 6815 Maint & Repairs/Bldgs 21,645 18,296 28,600 27,000 23,700 (4,900) 6835 Maint & Repair/Equipment 16,260 18,518 35,900 35,000 25,000 (10,900) 6840 Rent/Office Furniture & Equip 5,560 3,970 6,000 6,000 6,000 - 6904 Utilities/Other 13,810 14,364 14,000 16,000 16,000 2,000 Subtotal 82,595 84,494 123,800 120,800 111,340 (12,460) Field Services 6201 Uniforms & Laundry 5,150 5,933 4,900 6,000 6,000 1,100 6235 Meetings & Conferences -1,071 1,200 500 1,200 - 6493 Outside Services & Repairs 15,375 19,649 2,100 6,000 4,000 1,900 6521 Messenger Service 215 134 100 100 100 - 6539 Printing, Binding & Duplicating -452 2,000 500 1,000 (1,000) 6551 Fuel and Oil 17,990 19,109 23,000 23,000 23,000 - 6563 Supplies/Special 6,830 5,189 7,000 5,000 7,000 - 6566 Small Tools 645 -2,000 1,000 2,000 - 6825 Maint & Repair / Vehicle 12,855 9,916 15,000 12,400 15,000 - 6835 Maint & Repair/Equipment 330 32 13,000 13,000 13,000 - 6915 Utilities/Telephones 4,625 6,138 6,300 6,300 6,300 - Subtotal 64,015 67,622 76,600 73,800 78,600 2,000 341 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Customer Records & Collections 6201 Uniforms & Laundry 9,455 10,346 10,000 10,000 10,000 - 6235 Meetings & Conferences --2,000 500 2,000 - 6415 Computer Software Services 108,255 92,416 129,300 132,000 160,250 30,950 6493 Outside Services & Repairs 125,960 145,633 162,500 162,500 192,500 30,000 6518 Postage 125,300 122,974 160,000 160,000 135,000 (25,000) 6521 Messenger Service 95 35 100 300 100 - 6530 Office Supplies 9,180 7,322 10,000 10,000 10,000 - 6539 Printing, Binding & Duplicating 2,535 966 3,500 3,000 3,000 (500) 6563 Supplies/Special 1,620 888 1,000 1,800 1,500 500 6564 Supplies/Medical-Dental 115 78 --- - 6569 Small Equipment -5,938 2,000 2,000 2,000 - 6572 Office Furniture & Equipment 1,705 988 2,000 500 1,000 (1,000) 6670 IT Allocation 635,600 500,204 699,570 699,570 576,255 (123,315) 6835 Maint & Repair/Equipment 4,920 2,260 6,800 1,000 3,000 (3,800) 6915 Utilities/Telephone 2,730 2,910 62,000 31,000 62,000 - 7009 Bank Service Charges -66,002 500 -- (500) Subtotal 1,027,470 958,959 1,251,270 1,214,170 1,158,605 (92,665) Employee Related 6220 Training Schools 1,520 1,751 1,000 1,000 1,000 - 6235 Meetings & Conferences 2,895 2,670 3,000 2,500 3,000 - 6240 Mileage Reimbursement 25 14 100 100 100 - 6301 Legal Fees 2,745 142 2,000 2,000 2,000 - 6399 Professional Services/Other 5,020 ---- - 6493 Outside Services & Repairs 720 -1,000 200 500 (500) 6539 Printing, Binding & Duplicating 200 -1,000 500 500 (500) 6563 Supplies/Special --200 200 200 - 6564 Supplies/Medical-Dental 205 464 750 500 500 (250) 6850 Lease Payments ----5,000 Subtotal 13,330 5,041 9,050 7,000 12,800 3,750 OPERATIONS SUBTOTAL 2,809,675 2,794,262 3,223,790 3,093,780 3,319,700 95,910 342 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 TRANSFERS OUT 5950 Transfers Out 551,875 719,895 703,125 747,725 428,790 (274,335) Subtotal 551,875 719,895 703,125 747,725 428,790 (274,335) TRANSFERS OUT SUBTOTAL 551,875 719,895 703,125 747,725 428,790 (274,335) CONSUMER SERVICE FUND TOTAL: 6,366,045 6,337,923 7,081,084 6,810,655 7,012,115 (68,969) 343 LIGHT AND WATER WATER UTILITY PROGRAM COMMENTARY PROGRAM DESCRIPTION: Water Utility is the division of Light and Water that is responsible for supplying water to its customers through the production of water from groundwater wells, surface water treatment, and the purchase of treated and untreated imported water. The Water Production side of the Water Utility operates a 12 million gallon per day (MGD) water filtration plant at the mouth of San Gabriel Canyon (upgradable to 16 MGD), which treats water from the San Gabriel River consisting of naturally occurring water and untreated imported water. The Water Distribution side of the Water Utility operates, maintains, and repairs a water distribution system consisting of about 243 miles of water pipeline of various sizes, valves, and fire hydrants serving a population of approximately 110,000 in the cities of Azusa, Glendora, Covina, West Covina, Irwindale, and Los Angeles County. The Water Utility regularly replaces water mains for reasons of age, excessive repair requirements and inadequate flow. Water Operations also responds to customer inquiries and requests, and encourages water conservation through various programs. FY 15-16 STRATEGIC GOALS: Meet or exceed all regulatory requirements and goals for water supply quality and adequacy Provide reliable service and high quality water to our customers, while encouraging customers to use water efficiently Continue to identify and implement strategic water supply initiatives to meet future water supply demands Maintain a comprehensive program of providing financial/technical assistance to water customers to reduce water consumption Continue and enhance enforcement/education of mandatory water use restrictions Refinance water debt to reduce annual debt service costs Ensure that water revenues are adequate for maintaining required debt coverage Begin replacement of aged transmission mains on Azusa Ave. FY 14-15 PROGRAM HIGHLIGHTS: Designed, Constructed and Implemented the Sludge Dewatering Retrofit Project W-281 at the Water Treatment Plant in an efficient and cost effective manner Purchased a new vactor hydroexcavator truck for emergency repair and excavations, including a storage shed and foundation slab to house the new equipment Secured 3000 Acre-Feet of Pre-Purchased water through Upper District during the critical stages of drought in June 2014 From the 2013 production benchmark achieved approximately 9% water conservation within the Azusa Light & Water service area At the Water Treatment Plant facility replaced all 792 membrane modules due to Warranty Issues at no cost to Azusa Light & Water Water Distribution crew replaced approximately half-mile of aged pipeline on a portion of Gladstone Street, 2nd Street, and 9th Street 344 Budget Division: LIGHT AND WATER - WATER (ALL) FY 14-15 FY 15-16FY 14-15 FY 15-16 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Assistant Director-Water Operations 1.00 1.00 $129,115 $129,115 Water System Engineer 1.00 1.00 89,290 93,755 Engineer Associate 1.00 1.00 85,960 94,695 Office Specialist II (a)1.00 1.00 40,290 37,290 Utility Programs Specialist(a)0.30 0.30 26,450 26,450 Water Production Supervisor 1.00 1.00 103,380 107,435 Water Production Operator III 3.00 3.00 228,600 234,585 Water Production Operator II 2.00 2.00 137,840 142,380 Water Production Operator I 1.00 1.00 65,880 65,880 Water Distribution Supervisor 1.00 1.00 102,480 106,535 Water Distribution Crew Supervisor 2.00 2.00 171,000 177,660 Water Distribution Services Specialist 1.00 1.00 76,265 79,225 Water Distribution Equipment Operator 2.00 2.00 141,630 147,270 Water Distribution Worker III 2.00 2.00 141,690 148,160 Water Distribution Worker II 2.00 2.00 126,640 127,600 Water Distribution Worker I 3.00 3.00 159,330 161,810 Welder/Water Dist Worker I 2.00 2.00 142,270 148,020 Water System Administrator 1.00 1.00 63,915 63,915 (a) .70 FTE Public Benefits TOTAL 27.30 27.30 $2,032,025 $2,091,780 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 345 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 PERSONNEL 6003 Salaries/Regular 1,825,400 1,888,464 2,032,025 1,785,335 2,091,780 59,755 6006 Salaries/Part-Time ---2,535 -- 6030 Overtime Pay/Regular 6,280 8,988 17,000 5,785 9,000 (8,000) 6033 Overtime Pay/Premium 87,960 100,586 110,000 89,695 100,000 (10,000) 6039 Standby Pay/Premium 66,360 62,077 75,000 60,990 75,000 - 6045 Salaries/Education Incentive 11,870 17,729 12,085 16,090 9,390 (2,695) 6047 Salaries/Bonuses 6,629 ---- 6048 Salaries/Language Pay 14,410 14,359 12,000 11,720 6,000 (6,000) 6091 Leave Liability Adjustments 85,660 (28,066) ---- 6101 PERS/Employee Contribution 130,845 133,888 144,630 126,090 121,230 (23,400) 6105 PERS/Employer Contribution 232,730 175,731 180,060 168,665 235,175 55,115 6109 PARS/Employer Contribution 59,635 65,399 73,420 62,000 114,070 40,650 6125 FICA/Employer Contrib/Med 32,065 33,897 38,370 33,015 38,830 460 6133 Retiree Health Premium Reimb 13,880 13,612 14,110 14,995 14,970 860 6140 Life Insurance Allocation 4,775 4,979 5,465 4,530 5,560 95 6155 Workers' Comp Allocation 78,180 81,192 90,260 77,270 91,650 1,390 6160 LTD Insurance Allocation 13,500 14,287 15,795 13,640 16,275 480 6165 Unemployment Allocation 2,080 2,183 2,745 2,135 2,775 30 6175 Benefits/Flex Plan 450,170 453,470 484,050 484,050 484,050 - 6180 Deferred Comp/Employer Paid 285 2,940 3,960 3,960 3,960 - PERSONNEL SUBTOTAL 3,116,085 3,052,346 3,310,975 2,962,500 3,419,715 108,740 346 Budget Division: LIGHT AND WATER - WATER-CITY FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Assistant Director-Water Operations 1.00 1.00 $129,115 $129,115 Water System Engineer 1.00 1.00 89,290 93,755 Engineer Associate 1.00 1.00 85,960 94,695 Office Specialist II (a)1.00 1.00 40,290 37,290 Utility Programs Specialist(b)0.30 0.30 26,450 26,450 (a) Underfilled as a Office Assistant I for FY15-16 (b) .70 FTE Public Benefits TOTAL 4.30 4.30 $371,105 $381,305 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 347 Budget Division: LIGHT AND WATER - WATER SOURCE OF SUPPLY FY 15-16FY 14-15 FY 15-16 FY 14-15 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Water Production Supervisor 1.00 1.00 $103,380 $107,435 Water Production Operator III 3.00 3.00 228,600 234,585 Water Production Operator II 2.00 2.00 137,840 142,380 Water Production Operator I 1.00 1.00 65,880 65,880 Water System Administrator 1.00 1.00 63,915 63,915 TOTAL 8.00 8.00 $599,615 $614,195 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 348 Budget Division: LIGHT AND WATER - WATER TRANSMISSION & DISTRIBUTION FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Water Distribution Supervisor 1.00 1.00 $102,480 $106,535 Water Distribution Crew Supervisor 2.00 2.00 171,000 177,660 Water Distribution Services Specialist 1.00 1.00 76,265 79,225 Water Distribution Equipment Operator 2.00 2.00 141,630 147,270 Water Distribution Worker III 2.00 2.00 141,690 148,160 Water Distribution Worker II 2.00 2.00 126,640 127,600 Water Distribution Worker I 3.00 3.00 159,330 161,810 Welder/Water Dist Worker I 2.00 2.00 142,270 148,020 TOTAL 15.00 15.00 $1,061,305 $1,096,280 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 349 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 PERSONNEL City Water 6003 Salaries/Regular 274,950 284,072 371,105 246,625 381,305 10,200 6006 Salaries/Part-Time ---2,535 - - 6030 Overtime Pay/Regular 235 ---- - 6033 Overtime Pay/Premium 45 340 --- - 6045 Salaries/Education Incentive 1,890 1,897 1,885 1,845 1,890 5 6047 Sal/Bonus -6,629 --- - 6048 Salaries/Language Pay 2,400 2,412 2,400 445 - (2,400) 6091 Leave Liability Adjustments 85,660 (28,066) --- - 6101 PERS/Employee Contribution 19,625 20,267 26,135 17,525 - (26,135) 6105 PERS/Employer Contribution 23,540 25,122 32,540 22,480 42,760 10,220 6109 PARS/Employer Contribution 11,690 11,764 11,540 11,545 15,510 3,970 6125 FICA/Employer Contrib/Med 4,550 4,881 6,390 4,234 6,565 175 6133 Retiree Health Premium Reimb 13,880 13,612 14,110 14,995 14,970 860 6140 Life Insurance Allocation 745 751 990 625 1,015 25 6155 Workers' Comp Allocation 11,180 11,807 14,850 10,140 15,330 480 6160 LTD Insurance Allocation 2,120 2,193 2,855 1,900 2,965 110 6165 Unemployment Allocation 280 294 440 240 455 15 6175 Benefits/Flex Plan 51,070 51,832 69,455 69,455 69,455 - 6180 Deferred Comp/Employer Paid 285 2,940 3,960 3,960 3,960 - Subtotal 504,145 412,746 558,655 408,550 556,180 (2,475) Production - Source of Supply 6003 Salaries/Regular 576,640 581,185 599,615 563,475 614,195 14,580 6030 Overtime Pay/Regular 3,240 4,242 13,000 3,115 5,000 (8,000) 6033 Overtime Pay/Premium 13,700 17,673 31,430 13,545 20,000 (11,430) 6039 Standby Pay/Premium 32,940 29,731 40,000 32,655 40,000 - 6045 Salaries/Education Incentive 4,805 7,565 4,800 7,240 4,500 (300) 6048 Salaries/Language Pay 6,010 5,492 3,600 4,170 4,800 1,200 6101 PERS/Employee Contribution 41,475 41,904 42,970 40,575 43,835 865 6105 PERS/Employer Contribution 78,000 56,693 53,495 53,995 69,570 16,075 6109 PARS/Employer Contribution 16,595 19,088 23,025 18,475 38,890 15,865 6125 FICA/Employer Contrib/Med 10,725 11,322 12,160 11,185 12,065 (95) 350 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 6140 Life Insurance Allocation 1,395 1,523 1,620 1,435 1,615 (5) 6155 Workers' Comp Allocation 24,790 25,066 27,795 24,445 27,540 (255) 6160 LTD Insurance Allocation 3,920 4,348 4,685 4,280 4,780 95 6165 Unemployment Allocation 615 696 840 695 830 (10) 6175 Benefits/Flex Plan 142,325 139,451 143,515 143,515 143,515 - Subtotal 957,175 945,982 1,002,550 922,800 1,031,135 28,585 Transmission/Distribution 6003 Salaries/Regular 973,810 1,023,207 1,061,305 975,235 1,096,280 34,975 6030 Overtime Pay/Regular 2,805 4,745 4,000 2,670 4,000 - 6033 Overtime Pay/Premium 74,215 82,574 78,570 76,150 80,000 1,430 6039 Standby Pay/Premium 33,420 32,346 35,000 28,335 35,000 - 6045 Salaries/Education Incentive 5,175 8,267 5,400 7,005 3,000 (2,400) 6048 Salaries/Language Pay 6,000 6,456 6,000 7,105 1,200 (4,800) 6101 PERS/Employee Contribution 69,745 71,716 75,525 67,990 77,395 1,870 6105 PERS/Employer Contribution 131,190 93,916 94,025 92,190 122,845 28,820 6109 PARS/Employer Contribution 31,350 34,547 38,855 31,980 59,670 20,815 6125 FICA/Employer Contrib/Med 16,790 17,694 19,820 17,595 20,200 380 6140 Life Insurance Allocation 2,635 2,705 2,855 2,470 2,930 75 6155 Workers' Comp Allocation 42,210 44,318 47,615 42,685 48,780 1,165 6160 LTD Insurance Allocation 7,460 7,746 8,255 7,460 8,530 275 6165 Unemployment Allocation 1,185 1,193 1,465 1,200 1,490 25 6175 Benefits/Flex Plan 256,775 262,187 271,080 271,080 271,080 - Subtotal 1,654,765 1,693,618 1,749,770 1,631,150 1,832,400 82,630 PERSONNEL SUBTOTAL 3,116,085 3,052,346 3,310,975 2,962,500 3,419,715 108,740 351 THIS PAGE INTENTIONALLY LEFT BLANK 352 3240721xxx, 3240722xxx, 3240723xxx, 6220 Training Schools - Federal and California Occupational Safety and Health Act (OSHA) Safety training, American Water Works Association training in areas of Valve Flushing and Excavation; Operational Support Tools (OSTS) Hazardous Materials training. California Specialized Training Institute (CSTI) 6230 Dues/Subscriptions - San Gabriel Valley Water Assn., AWWA, San Gabriel Valley Protective Association, Building News International (Green Book), Engineering News Record, Urban Water Institute, Department of Health Drinking Water, Water Education Foundation, Assn. of Calif Water Agencies 6231 Outside Assessment - Assessments from outside water entities, such as the Water Quality Authority, Committee of 9, Watermaster, and San Gabriel Valley Protective Association 6235 Meetings/Conferences - California Municipal Utilities Association Annual Conference, San Gabriel Valley Water Association meetings, San Gabriel Basin Water Master m eetings, San Gabriel Valley Water Association Legislative Committee, Three Valleys meetings. State and Congressional Rep Meetings. San Gabriel Valley Protective Association, Assn. of Calif Water Agencies (ACWA) 6493 Outside Services & Repairs - Design Engineers, Civil Engineers and Geologists and other vendors necessary to repair and maintain water production and distribution system facilities and equipment 6563 Supplies Special - Purchased water costs, chemicals and other supplies to treat water. These costs are difficult to forecast and may change depending on a number of variables 6564 Supplies/Medical-Dental - Purchase of first-aid kits for field staff 6625 Program Expenses - Costs associated with DRiP Program to promote drought resistant landscapes and water conserving irrigation systems. Some costs include promotion of mandatory water conservation measures as needed 7001 Interest Expense - Interest expense on long-term debt of two bonds: (1) 2006 Revenue Parity Bonds - issued to finance construction of new water treatment plant and other major infrastructure such as reservoirs; and (2) 2012 Refunding Revenue Bonds - refunded the 2003 Certificates of Participation used to refinance the purchase of the Azusa Valley Water Company Account Number Description LIGHT & WATER - WATER ACTIVITY DETAIL 353 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (SUMMARY) DESCRIPTION REVISED YEAR END EST ADOPTED Acct. #14-15 14-15 15-16 VARIANCE Explanation 6231 Outside Assessments 200,000 225,000 655,000 455,000 Assessments from outside water entities: increase due to higher SGVWA assessments from $0.70.AF to $26.43/AF (16,594 AF); SGBWQA assessments $10/AF for prescriptive pumping rights (10,006.2+3,655.99 AF); Committee of Nine $6,627.90/month 6633 Water Conservation Program 200,000 200,000 300,000 100,000 Costs associated with the promotion of water conservation and rebate programs such as DRiP which promotes drought resistant landscapes and water conserving irrigation systems. Increase due to potential partnership with So Cal Water $mart and turf removal rebates 7005 Principal Payment 1,780,000 1,735,000 1,855,000 75,000 Scheduled bond debt service payments: $1,145,000 for 2006 and $710,000 for 2012A Bonds. Budget may be revised mid-year to reflect refinancing of 2006 debt 354 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 OPERATIONS 6201 Uniforms & Laundry 13,085 14,616 25,000 14,500 25,000 - 6215 Tuition Reimbursement 175 ----- 6220 Training Schools 6,830 9,315 5,500 3,500 5,500 - 6225 Training Matrl -1,170 ---- 6230 Dues & Subscriptions 39,885 25,170 36,500 35,750 36,750 250 6240 Mileage Reimb - 22 ---- 6231 Outside Assessments 146,570 211,330 200,000 225,000 655,000 455,000 6235 Meetings & Conferences 355 466 1,200 700 1,200 - 6253 Licenses/Certifications 3,065 2,541 4,750 3,150 3,750 (1,000) 6301 Legal Fees 18,235 38,551 70,000 37,500 57,500 (12,500) 6320 Fiscal Agent Fees 4,225 795 3,000 3,000 3,000 - 6325 Appraisal Fees - 2,800 ---- 6340 Special Studies - -2,000 -2,000 - 6345 Program Consultants 3,490 4,365 5,000 5,000 5,000 - 6399 Professional Services (2,367) 9,060 55,185 40,000 50,000 (5,185) 6424 Consumer Services Allocation 4,071,770 4,057,772 4,451,825 4,380,910 4,412,760 (39,065) 6430 Custodial Services 5,980 5,821 7,500 7,500 7,500 - 6485 Public Nsnce Abt -700 ---- 6493 Outside Services & Repairs 488,650 461,990 632,450 560,700 622,200 (10,250) 6518 Postage 5 6 750 -100 (650) 6521 Messenger Service 250 846 1,000 1,000 1,000 - 6527 Supplies/Computer -127 1,500 -1,000 (500) 6530 Office Supplies 4,435 4,798 5,640 5,205 5,750 110 6539 Printing, Binding & Duplicating 1,510 1,626 7,700 1,600 1,700 (6,000) 6551 Fuel and Oil 61,640 52,216 50,000 62,000 60,000 10,000 6554 Supplies/Custodial 2,285 2,216 7,350 2,450 3,350 (4,000) 6560 Repair Parts 29,295 9,348 33,280 30,800 32,300 (980) 6563 Supplies/Special 1,565,060 1,046,536 2,100,090 1,568,400 1,518,980 (581,110) 6564 Supplies/Medical-Dental 1,545 2,224 2,000 1,000 1,500 (500) 6566 Small Tools 3,785 2,668 7,500 5,250 7,250 (250) 6569 Small Equipment 11,510 22,297 82,520 37,000 66,500 (16,020) 6572 Office Furniture & Equipment -300 1,350 1,000 1,350 - 6591 WATER FOR RESALE --2,019,000 2,019,000 -(2,019,000) 355 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 6601 Advertising Expense 980 947 1,500 500 1,000 (500) 6605 Filing Costs 18,610 1,899 15,000 15,000 10,000 (5,000) 6610 Bond Administration 500 1,750 2,500 1,750 1,750 (750) 6613 Bond-Arbitrage - 111,641 ---- 6633 Water Conservation Program 70,555 122,520 200,000 200,000 300,000 100,000 6801 Rent/Land 5,220 5,220 6,000 6,000 6,000 - 6805 Maintenance/Land Improvements 27,570 23,701 38,000 32,500 38,000 - 6815 Maint & Repairs/Bldgs 9,595 4,819 12,980 14,750 12,650 (330) 6825 Maintenance Repair Vehicle 38,005 48,884 35,450 45,000 35,500 50 6827 Garage Allocation - -3,000 3,000 3,000 - 6830 Rent/Equipment 1,815 597 3,750 3,100 3,250 (500) 6835 Maint & Repair/Equipment 4,645 5,282 24,750 6,250 24,750 - 6850 Lease Payments 1,605 4,758 4,760 4,760 4,760 - 6904 Utilities/Other 1,043,280 1,216,541 1,070,000 1,300,000 1,050,000 (20,000) 6905 Utilities/Electricity 15,475 14,606 25,000 15,000 25,000 - 6910 Utilities/Natural Gas 850 878 5,500 1,000 1,000 (4,500) 6915 Utilities/Telephone 11,345 13,415 11,730 11,860 12,000 270 7001 Interest Expense 2,981,340 2,768,402 2,871,790 2,871,790 2,804,890 (66,900) 7005 Principal Payment --1,780,000 1,735,000 1,855,000 75,000 7010 Franchise Fee (2%) 374,185 373,842 347,145 347,395 300,975 (46,170) 7013 Water Rights Lease Expense 1,454,350 1,473,252 1,495,360 1,495,350 1,496,845 1,485 7015 Tax/Property 2,470 2,507 4,000 2,600 3,000 (1,000) 7055 Uncollectible Accounts 62,875 51,169 58,000 40,000 55,000 (3,000) OPERATIONS SUBTOTAL 12,606,538 12,238,322 17,835,805 17,204,520 15,632,310 (2,203,495) CAPITAL OUTLAY 7130 Structures/Other --581,870 --(581,870) 7145 Computer Equipment - -309,420 --(309,420) CAPITAL OUTLAY SUBTOTAL --891,290 --(891,290) 356 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 TRANSFERS OUT 5950 Transfer Out 160,050 186,390 150,000 224,250 125,000 (25,000) TRANSFERS OUT SUBTOTAL 160,050 186,390 150,000 224,250 125,000 (25,000) WATER FUND TOTAL: 15,882,673 15,477,058 22,188,070 20,391,270 19,177,025 (3,011,045) 357 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 OPERATIONS Taxes - 7010 Franchise Fee (2%) 374,185 373,842 347,145 347,395 300,975 (46,170) 7015 Tax/Property 2,470 2,507 4,000 2,600 3,000 (1,000) Subtotal 376,655 376,349 351,145 349,995 303,975 (47,170) Interest Expense 6613 Bond-Arbitrage -111,641 --- - 7001 Interest Expense 2,981,340 2,768,402 2,871,790 2,871,790 2,804,890 (66,900) Subtotal 2,981,340 2,880,043 2,871,790 2,871,790 2,804,890 (66,900) Principal Expense 7005 Principal Expense --1,780,000 1,735,000 1,855,000 75,000 Subtotal --1,780,000 1,735,000 1,855,000 75,000 Administrative & General 6320 Fiscal Agent Fees 4,225 795 3,000 3,000 3,000 - 6325 Appraisal Fees -2,800 --- - 6399 Professional Services/Other (2,367)9,060 55,185 40,000 50,000 (5,185) 6424 Consumer Services Allocation 4,071,770 4,057,772 4,451,825 4,380,910 4,412,760 (39,065) 6601 Advertising Expense 980 947 1,500 500 1,000 (500) 6610 Bond Administration 500 1,750 2,500 1,750 1,750 (750) Subtotal 4,075,108 4,073,124 4,514,010 4,426,160 4,468,510 (45,500) Miscellaneous 6220 Training Schools 2,870 7,710 3,000 3,000 3,000 - 6225 Training Matrl -1,170 --- - 6230 Dues & Subscriptions 5,215 4,751 5,750 5,000 6,000 250 6235 Meetings & Conferences 315 466 1,000 500 1,000 - 6240 Mileage Reimb -22 --- - 6253 Licenses/Certifications 150 -250 150 250 - 6485 Public Nsnce Abt -700 --- - 358 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 6539 Printing, Binding & Duplicating -45 --- - 6633 Water Conservation Program 70,555 122,520 200,000 200,000 300,000 100,000 7055 Uncollectible Accounts 62,875 51,169 58,000 40,000 55,000 (3,000) Subtotal 141,980 188,553 268,000 248,650 365,250 97,250 Office Supplies & Other Expenses 6530 Office Supplies 360 --30 100 100 6563 Supplies/Special 475 181 310 300 500 190 6569 Small Equipment --190 -- (190) 6915 Utilities/Telephone 765 855 730 1,360 1,000 270 Subtotal 1,600 1,036 1,230 1,690 1,600 370 Employee Related 6201 Uniforms & Laundry 13,085 14,616 25,000 14,500 25,000 - 6215 Tuition Reimbursement 175 ---- - 6220 Training Schools 3,960 1,605 2,500 500 2,500 - 6230 Dues & Subscriptions 555 986 750 750 750 - 6253 Licenses/Certifications 2,915 2,541 4,500 3,000 3,500 (1,000) 6301 Legal Fees -1,271 5,000 7,500 7,500 2,500 6563 Supplies/Special 10 795 300 1,000 1,000 700 6564 Supplies/Medical-Dental 1,545 2,224 2,000 1,000 1,500 (500) 6825 Maintenance & Repair/Vehicle 150 -450 -500 50 Subtotal 22,395 24,038 40,500 28,250 42,250 1,750 Outside Services 6301 Legal Fees 18,235 37,280 65,000 30,000 50,000 (15,000) 6340 Special Studies --2,000 -2,000 - 6345 Program Consultants 3,490 4,365 5,000 5,000 5,000 - 6493 Outside Services & Repairs 375 757 22,420 25,000 2,500 (19,920) Subtotal 22,100 42,402 94,420 60,000 59,500 (34,920) Transportation 6493 Outside Services & Repairs 235 -500 -500 - 6551 Fuel and Oil 61,640 52,216 50,000 62,000 60,000 10,000 359 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 6560 Repair Parts 1,480 283 500 500 500 - 6563 Supplies/Special 25 152 500 500 500 - 6569 Small Equipment --500 500 500 - 6825 Maintenance & Repair/Vehicle 37,855 48,872 35,000 45,000 35,000 - 6827 Garage Allocation --3,000 3,000 3,000 - 6835 Maint & Repair/Equipment 670 190 2,000 -2,000 - 6850 Lease Payments 1,605 4,758 4,760 4,760 4,760 - Subtotal 103,510 106,470 96,760 116,260 106,760 10,000 Production - Supervision & Engineering 6235 Meetings & Conferences 40 -200 200 200 - 6493 Outside Services & Repairs 26,985 36,130 25,000 25,000 25,000 - 6518 Postage 5 6 750 -100 (650) 6521 Messenger Service 185 627 750 750 750 - 6527 Supplies/Computer/Small Equip --1,000 -500 (500) 6530 Office Supplies 1,405 1,314 1,500 1,500 1,500 - 6539 Printing, Binding & Duplicating 1,510 1,581 7,500 1,500 1,500 (6,000) 6554 Supplies/Custodial & Cleaning 475 96 350 350 350 - 6563 Supplies/Special 300 179 1,500 500 500 (1,000) 6569 Small Equipment 605 -2,000 2,000 1,000 (1,000) 6572 Office Furniture & Equipment --1,000 1,000 1,000 - 6830 Rent/Equipment 185 245 1,500 1,500 1,000 (500) 6835 Maintenance and Repair/Equipment --250 250 250 - 6915 Utilities/Telephone 8,565 8,874 7,500 8,500 9,000 1,500 Subtotal 40,260 49,053 50,800 43,050 42,650 (8,150) Purchased Water 6230 Dues & Subscriptions 34,115 19,433 30,000 30,000 30,000 - 6231 Outside Assessments 146,570 211,330 200,000 225,000 655,000 455,000 6493 Outside Services & Repairs 59,650 6,628 50,000 85,000 50,000 - 6591 WATER FOR RESALE 2,019,000 2,019,000 - (2,019,000) 6563 Supplies/Special 916,400 427,913 1,400,000 900,000 850,000 (550,000) 7013 Water Rights Lease Expense 1,454,350 1,473,252 1,495,360 1,495,350 1,496,845 1,485 Subtotal 2,611,085 2,138,556 5,194,360 4,754,350 3,081,845 (2,112,515) 360 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Maintenance of Structures & Improvements 6493 Outside Services & Repairs 4,490 3,976 4,500 4,500 4,500 - 6554 Supplies/Custodial --5,000 500 1,000 (4,000) 6563 Supplies/Special 245 165 2,000 500 1,000 (1,000) 6569 Small Equipment --500 500 500 - 6805 Maintenance/Land Improvements 25,065 21,437 28,000 22,500 28,000 - 6815 Maint & Repairs/Bldgs 410 219 750 750 750 - Subtotal 30,210 25,797 40,750 29,250 35,750 (5,000) Maintenance of Reservoirs 6493 Outside Services & Repairs 11,300 15,144 24,000 15,000 24,000 - 6563 Supplies/Special 715 508 1,000 1,000 1,000 - 6825 Mnt Repair Veh -12 -- - Subtotal 12,015 15,663 25,000 16,000 25,000 - 361 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Maintenance of Wells 6493 Outside Services & Repairs 47,220 63,690 50,000 10,000 100,000 50,000 6563 Supplies/Special 9,140 6,157 10,000 10,000 10,000 - 6569 Small Equipment 740 -20,000 10,000 20,000 - Subtotal 57,100 69,847 80,000 30,000 130,000 50,000 Fuel or Power Purchase 6904 Utilities/Other 1,043,280 1,216,541 1,070,000 1,300,000 1,050,000 (20,000) 6905 Utilities/Electricity 15,475 14,606 25,000 15,000 25,000 - 6910 Utilities/Natural Gas 850 878 5,500 1,000 1,000 (4,500) Subtotal 1,059,605 1,232,025 1,100,500 1,316,000 1,076,000 (24,500) Maintenance of Pumps/Boosters 6493 Outside Services & Repairs 49,845 45,522 45,000 45,000 100,000 55,000 6560 Repair Parts 65 -280 -100 (180) 6563 Supplies/Special 2,405 3,158 4,000 3,000 4,000 - Subtotal 52,315 48,680 49,280 48,000 104,100 54,820 Chemicals & Filtering Materials 6493 Outside Services & Repairs -4,281 5,000 5,000 5,000 - 6563 Supplies/Special 316,035 262,408 350,000 350,000 300,000 (50,000) Subtotal 316,035 266,689 355,000 355,000 305,000 (50,000) Maintenance of Structure & Improvements (Filter Plant) 6430 Custodial Services 2,275 2,099 3,750 3,750 3,750 - 6493 Outside Services & Repairs 11,680 24,531 23,670 25,000 25,000 1,330 6530 Office Supplies 350 45 500 500 500 - 6554 Supplies/Custodial 640 687 1,000 600 1,000 - 6563 Supplies/Special 26,490 15,124 25,030 15,000 25,030 - 6815 Maint & Repairs/Bldgs 1,895 1,057 1,860 1,000 1,800 (60) Subtotal 43,330 43,543 55,810 45,850 57,080 1,270 362 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Maintenance of Water Treatment Equipment 6493 Outside Services & Repairs 45,495 48,402 65,000 50,000 55,000 (10,000) 6563 Supplies/Special 18,675 18,701 25,000 20,000 25,000 - 6569 Small Equipment 8,455 4,877 10,000 5,000 10,000 - Subtotal 72,625 71,980 100,000 75,000 90,000 (10,000) Supervision & Engineering 6521 Messenger Service 65 219 250 250 250 - 6527 Supplies/Computer -127 500 -500 - 6530 Office Supplies 1,270 3,282 2,750 2,500 2,750 - 6539 Printing, Binding & Duplicating --200 100 200 - 6563 Supplies/Special -828 200 100 200 - 6572 Office Furniture & Equipment -300 350 -350 - 6815 Maint & Repairs/Bldgs -26 370 -100 (270) 6830 Rent/Equipment 35 37 1,000 1,000 1,000 - 6915 Utilities/Telephone 2,015 3,685 3,500 2,000 2,000 (1,500) Subtotal 3,385 8,505 9,120 5,950 7,350 (1,770) Storage Facilities 6563 Supplies/Special 1,610 -2,000 500 2,000 - 6830 Rent/Equipment 1,595 315 1,250 600 1,250 - Subtotal 3,205 315 3,250 1,100 3,250 - Transmission & Distribution 6493 Outside Services & Repairs --500 -500 - 6563 Supplies/Special 5,050 2,578 3,000 1,000 3,000 - Subtotal 5,050 2,578 3,500 1,000 3,500 - Meter 6493 Outside Services & Repairs -6,342 4,000 3,000 4,000 - 6563 Supplies/Special 54,825 65,262 75,000 70,000 70,000 (5,000) 6569 Small Equipment -17,176 45,000 10,000 30,000 (15,000) Subtotal 54,825 88,780 124,000 83,000 104,000 (20,000) 363 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Customer Installation 6493 Outside Services & Repairs -1,200 1,180 1,200 1,200 20 6560 Repair Parts --800 -- (800) 6563 Supplies/Special 995 740 1,500 1,000 1,500 - Subtotal 995 1,940 3,480 2,200 2,700 (780) Maintenance of Structures & Improvements 6430 Custodial Services 3,705 3,722 3,750 3,750 3,750 - 6493 Outside Services & Repairs 505 3,007 5,000 2,000 5,000 - 6530 Office Supplies 980 157 890 650 800 (90) 6554 Supplies/Custodial 1,170 1,433 1,000 1,000 1,000 - 6563 Supplies/Special 2,960 1,285 2,500 1,500 2,500 - 6805 Maintenance/Land Improvements 2,505 2,264 10,000 10,000 10,000 - 6815 Maint & Repairs/Bldgs 7,290 3,516 10,000 13,000 10,000 - Subtotal 19,115 15,385 33,140 31,900 33,050 (90) Maintenance of Transmission & Distribution Mains 6493 Outside Services & Repairs 228,530 187,015 287,130 250,000 200,000 (87,130) 6530 Office Supplies 70 --25 100 100 6560 Repair Parts 25,160 7,923 25,000 25,000 25,000 - 6563 Supplies/Special 192,860 217,195 175,000 175,000 200,000 25,000 6566 Small Tools 3,725 2,420 4,500 4,500 4,500 - 6569 Small Equipment 1,620 244 3,000 3,000 3,000 - 6605 Filing Costs 18,610 1,899 15,000 15,000 10,000 (5,000) 6801 Rent/Land 5,220 5,220 6,000 6,000 6,000 - 6835 Maint & Repair/Equipment 3,840 4,473 15,000 5,000 15,000 - Subtotal 479,635 426,389 530,630 483,525 463,600 (67,030) 364 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Maintenance of Services 6560 Repair Parts 2,545 1,018 1,500 2,000 1,500 - 6563 Supplies/Special 15,005 18,092 12,500 12,500 12,500 - 6566 Small Tools 60 248 1,750 250 1,750 - 6835 Maint & Repair/Equipment 135 -5,000 500 5,000 - Subtotal 17,745 19,358 20,750 15,250 20,750 - Maintenance of Meters 6493 Outside Services & Repairs 2,340 15,367 19,550 15,000 20,000 450 6560 Repair Parts --3,200 3,200 3,200 - 6563 Supplies/Special 120 33 1,750 -1,750 - 6566 Small Tools --500 500 500 - Subtotal 2,460 15,400 25,000 18,700 25,450 450 Maintenance of Hydrants 6560 Repair Parts 45 124 2,000 100 2,000 - 6563 Supplies/Special 640 -2,000 -2,000 - Subtotal 685 124 4,000 100 4,000 - Maintenance of Miscellaneous Plants 6560 Repair Parts -- - 6563 Supplies/Special 80 5,082 5,000 5,000 5,000 - 6566 Small Tools --750 -500 (250) 6569 Small Equipment 90 -1,330 6,000 1,500 170 6835 Maint & Repair/Equipment -619 2,500 500 2,500 - Subtotal 170 5,700 9,580 11,500 9,500 (80) CIP/Water 7130 Structures/Other --581,870 -- (581,870) 7145 Lines, Mains&Swr --309,420 -- (309,420) Subtotal --891,290 -- (891,290) OPERATIONS SUBTOTAL 12,606,538 12,238,322 18,727,095 17,204,520 15,632,310 (3,094,785) 365 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 TRANSFERS OUT General 5950 Transfer Out 160,050 186,390 150,000 224,250 125,000 (25,000) Subtotal 160,050 186,390 150,000 224,250 125,000 (25,000) TRANSFERS OUT SUBTOTAL 160,050 186,390 150,000 224,250 125,000 (25,000) WATER FUND TOTAL: 15,882,673 15,477,058 22,188,070 20,391,270 19,177,025 (3,011,045) 366 LIGHT & WATER ELECTRIC UTILITY PROGRAM COMMENTARY PROGRAM DESCRIPTION: Electric Utility consists of Power Resources Management, Engineering and Electric Operations. Power Resources Management is responsible for short-term, mid-term and long-term power resource planning and procurement; short- term and mid-term power resource optimization, trading, and scheduling; after-the-fact energy accounting and financial settlements with the California Independent System Operator (CAISO) and various trading counterparties; power and capacity contract origination and negotiation, and all wholesale transactions bill & invoice processing; NERC/WECC compliance; participation in all pertinent state and federal regulatory processes; representing City’s interest in various industry forums; regulatory compliance and associated monitoring and reporting, including state Renewable Portfolio Standard (RPS), Greenhouse Gases (GHG) regulation, and new federal Environmental Protection Agency’s (EPA) rules for existing power plants; all financial planning associated with power resources and transmission management; power resource and transmission asset and contract management; and special projects. Engineering is responsible for planning, engineering, project management and construction of budgeted utility capital improvement projects, determining standard methods of construction, and providing overall utility business/technical support and interaction with customers or other governmental agencies doing electric service related projects within the City. Engineering is also responsible for determining and imposing utility related fees or charges necessary for utility requested services by customers. Finally, Engineering provides overall technical support and functional supervision to field operations to ensure that customer utility services or improvements are constructed in compliance with approved plans or specifications. Electric Operations manages the safe and reliable distribution of electric power from Azusa’s Substations through the electric distribution system to homes, business and industries. Electric Operations is responsible for construction, maintenance and operation of the electric distribution system and compliance with the various State of California General Orders governing construction, inspection and maintenance of those facilities: General Order 95 Rules for Overhead Line Construction, General Order 128 Rules for Construction of Underground Electric Supply and Communications Systems, General Order 165 Inspection Cycles for Electric Distribution Facilities, and General Order 174 Rules for Electric utility Substations. FY 2015-16 STRATEGIC GOALS:  Complete preparation of 20 year electric system master plan to include TOD, APU and other community expansion projects  Complete electric services to new residential and commercial customers in an efficient and timely manner  Terminate the utility’s participation in the San Juan coal plant by 2018 to improve the greenhouse gas footprint of local power supplies  Develop/install EV Public Charging Stations within the Azusa  Ensure adequate and least cost electric power resources to serve the community while complying with NERC, WECC, CAISO, CARB and CEC regulations  Complete ten year integrated power resource plan to ensure smart future expansion of power supplies 367 FY 2014-15 PROGRAM HIGHLIGHTS: Received American Public Power Association Award for Reliable Public Power Provider (RP3) Designation 2015-18 Met compliance standards for safety regulations reporting requirements - SF6 and GO 165/174 Completed underground and overhead power lines across railway line at three crossing locations, which will support the proposed Metro Gold Line Railway Extension to Azusa Completed multiple underground line extensions and services to new homes in the Rosedale Community Secured California Energy Commission Grant Award to install DC Fast Charge EV Public Charging Station at Citrus Crossing Shopping Center Continued making progress toward the Renewable Portfolio Standard goal of 33% renewable energy by 2020, executing ten (10) renewable energy contracts with associated renewable energy deliveries to begin in 2016 368 Budget Division: LIGHT AND WATER - ELECTRIC (ALL) FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Assistant Director-Electric Operations 1.00 1.00 $130,315 $130,315 Electric Distribution Supervisor 1.00 1.00 128,160 132,980 Electric Crew Supervisor 3.00 3.00 344,600 357,560 Line Mechanic 7.00 7.00 712,310 739,750 Line Mechanic Helper (a)1.00 1.00 69,770 102,500 Senior Electric Test Technician 1.00 1.00 101,120 105,085 Electrical Test Technician 1.00 1.00 86,789 92,865 Apprentice Elect Test Technician 1.00 1.00 78,426 79,995 Office Specialist II (b)1.00 1.00 50,410 46,215 Senior Electrical Engineer 1.00 1.00 109,890 109,890 Electrical Engineer 1.00 1.00 97,660 102,805 Assistant Director-Resource Management 1.00 1.00 144,510 144,510 Power Resources Coordinator 1.00 1.00 112,405 112,405 Power Resources Scheduler 1.00 1.00 99,555 99,555 TOTAL 22.00 22.00 $2,265,920 $2,356,430 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 369 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 PERSONNEL 6003 Salaries/Regular 2,001,840 1,978,850 2,265,920 2,034,255 2,356,430 90,510 6030 Overtime Pay/Regular 4,430 19,576 10,000 35,245 20,000 10,000 6033 Overtime Pay/Premium 76,960 104,623 150,000 135,325 130,000 (20,000) 6039 Standby Pay/Premium 47,370 41,853 40,000 39,680 40,000 - 6045 Salaries/Education Incentive 7,275 7,906 6,700 7,730 4,950 (1,750) 6047 Salaries/Bonuses -14,562 --- - 6048 Salaries/Language Pay 6,000 7,471 6,000 9,415 6,000 - 6101 PERS/Employee Contribution 144,800 137,284 159,795 138,040 166,525 6,730 6105 PERS/Employer Contribution 241,375 182,765 198,995 186,525 264,425 65,430 6109 PARS/Employer Contribution 80,720 84,681 98,370 83,995 147,605 49,235 6125 FICA/Employer Contrib/Med 32,120 33,533 37,515 35,490 38,510 995 6133 Retiree Health Premium Reimb 4,155 4,282 4,225 4,270 4,465 240 6140 Life Insurance Allocation 5,065 4,931 6,040 4,865 6,305 265 6155 Workers' Comp Allocation 83,645 85,005 98,780 87,625 101,895 3,115 6160 LTD Insurance Allocation 13,935 13,775 17,565 13,995 18,330 765 6165 Unemployment Allocation 2,120 2,064 2,850 2,135 2,930 80 6175 Benefits/Flex Plan 335,940 323,002 384,140 377,900 384,140 - 6180 Deferred Comp/Employer Paid 690 6,990 10,080 10,080 10,080 - PERSONNEL SUBTOTAL 3,088,440 3,053,153 3,496,975 3,206,569 3,702,590 205,615 370 Budget Division: LIGHT AND WATER - ELECTRIC DISTRIBUTIONS & OPERATIONS FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Assistant Director-Electric Operations 1.00 1.00 $130,315 $130,315 Electric Distribution Supervisor 1.00 1.00 128,160 132,980 Electric Crew Supervisor 3.00 3.00 344,600 357,560 Line Mechanic 7.00 7.00 712,310 739,750 Line Mechanic Helper (a)1.00 1.00 69,770 102,500 Senior Electric Test Technician 1.00 1.00 101,120 105,085 Electrical Test Technician 1.00 1.00 86,789 92,865 Apprentice Elect Test Technician 1.00 1.00 78,426 79,995 Office Specialist II (b)1.00 1.00 50,410 46,215 (a) Position Overfilled as Line Mechanic (b) Position underfilled as a Office Specialist I TOTAL 17.00 17.00 $1,701,900 $1,787,265 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 371 Budget Division: LIGHT AND WATER - ELECTRIC ENGINEERING FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Senior Electrical Engineer 1.00 1.00 $109,890 $109,890 Electrical Engineer 1.00 1.00 97,660 102,805 TOTAL 2.00 2.00 $207,550 $212,695 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 372 Budget Division: LIGHT AND WATER - POWER PURCHASES FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted FY 14-15 FY 15-16 FY 14-15 FY 15-16 Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Assistant Director-Resource Management 1.00 1.00 $144,510 $144,510 Power Resources Coordinator 1.00 1.00 112,405 112,405 Power Resources Scheduler 1.00 1.00 99,555 99,555 TOTAL 3.00 3.00 $356,470 $356,470 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 373 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 PERSONNEL Distribution Operations-Supervision & Engineering 6003 Salaries/Regular 256,195 262,067 259,370 255,975 263,295 3,925 6045 Salaries/Education Incentive 1,750 2,045 1,750 2,005 1,750 - 6047 Sal/Bonus -3,005 ---- 6101 PERS/Employee Contribution 18,205 18,638 18,335 18,390 18,600 265 6105 PERS/Employer Contribution 27,885 23,439 22,795 23,075 29,485 6,690 6109 PARS/Employer Contribution 13,830 14,638 14,325 14,465 20,225 5,900 6125 FICA/Employer Contribution 2,080 2,316 2,160 2,655 2,145 (15) 6133 Retiree Health Premium Reimb 4,155 4,282 4,225 4,270 4,465 240 6140 Life Insurance Allocation 685 688 695 650 705 10 6155 Workers' Comp Allocation 10,320 10,684 10,445 10,425 10,600 155 6160 LTD Insurance Allocation 1,805 1,918 2,020 1,880 2,050 30 6165 Unemployment Allocation 235 250 295 265 300 5 6175 Benefits/Flex Plan 33,600 34,217 34,225 34,225 34,225 - 6180 Deferred Comp/Employer Paid 150 1,500 1,800 1,800 1,800 - Subtotal 370,895 379,686 372,440 370,080 389,645 17,205 Distribution Operations-Overhead Lines 6003 Salaries/Regular 549,495 547,577 559,850 561,100 599,910 40,060 6030 Overtime Pay/Regular 2,215 9,544 5,000 16,095 10,000 5,000 6033 Overtime Pay/Premium 36,590 50,732 70,000 61,765 60,000 (10,000) 6039 Standby Pay/Premium 23,685 20,926 20,000 19,839 20,000 - 6045 Salaries/Education Incentive 585 725 300 293 150 (150) 6048 Salaries/Language Pay 1,200 1,927 1,200 2,951 1,200 - 6101 PERS/Employee Contribution 39,275 36,800 39,860 36,108 42,375 2,515 6105 PERS/Employer Contribution 73,735 51,368 49,700 51,762 67,365 17,665 6109 PARS/Employer Contribution 17,330 18,807 20,215 17,444 32,720 12,505 6125 FICA/Employer Contrib/Med 10,140 10,198 11,010 10,569 11,465 455 6140 Life Insurance Allocation 1,450 1,435 1,505 1,408 1,600 95 6155 Workers' Comp Allocation 23,350 24,090 26,395 24,924 27,650 1,255 6160 LTD Insurance Allocation 3,985 3,968 4,385 3,977 4,665 280 6165 Unemployment Allocation 670 642 760 650 790 30 6175 Benefits/Flex Plan 98,835 95,789 99,395 99,395 99,395 - Subtotal 882,540 874,528 909,575 908,280 979,285 69,710 374 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Distribution Operations-Underground Lines 6003 Salaries/Regular 549,490 547,577 565,935 561,095 599,900 33,965 6030 Overtime Pay/Regular 2,215 9,544 5,000 16,095 10,000 5,000 6033 Overtime Pay/Premium 36,590 50,732 70,000 61,765 60,000 (10,000) 6039 Standby Pay/Premium 23,685 20,926 20,000 19,840 20,000 - 6045 Salaries/Education Incentive 585 725 300 295 150 (150) 6048 Salaries/Language Pay 1,200 1,927 1,200 2,950 1,200 - 6101 PERS/Employee Contribution 39,275 36,800 39,860 36,105 42,375 2,515 6105 PERS/Employer Contribution 73,735 51,368 49,700 51,765 67,365 17,665 6109 PARS/Employer Contribution 17,330 18,807 20,215 17,445 32,720 12,505 6125 FICA/Employer Contrib/Med 10,140 10,198 11,010 10,570 11,465 455 6140 Life Insurance Allocation 1,450 1,435 1,505 1,410 1,600 95 6155 Workers' Comp Allocation 23,350 24,090 26,395 24,925 27,650 1,255 6160 LTD Insurance Allocation 3,985 3,967 4,385 3,975 4,665 280 6165 Unemployment Allocation 670 642 760 650 790 30 6175 Benefits/Flex Plan 98,835 95,789 99,395 99,395 99,395 - Subtotal 882,535 874,526 915,660 908,280 979,275 63,615 Distribution Operations-Meters 6003 Salaries/Regular 140,865 102,114 266,335 172,830 277,945 11,610 6030 Overtime Pay/Regular -488 -3,055 -- 6033 Overtime Pay/Premium 3,780 3,159 10,000 11,795 10,000 - 6045 Sal/Ed Inc 35 -880 -- 6048 Salaries/Language Pay 1,200 1,206 1,200 1,170 1,200 - 6101 PERS/Employee Contribution 11,565 7,364 18,110 12,440 19,610 1,500 6105 PERS/Employer Contribution 21,685 9,400 22,535 15,565 31,110 8,575 6109 PARS/Employer Contribution 4,400 3,764 9,200 6,355 15,120 5,920 6125 FICA/Employer Contrib/Med 1,530 1,756 2,920 3,180 3,030 110 6140 Life Insurance Allocation 385 269 680 435 745 65 6155 Workers' Comp Allocation 5,845 4,216 10,700 7,355 11,165 465 6160 LTD Insurance Allocation 1,060 770 1,995 1,310 2,160 165 6165 Unemployment Allocation 165 110 320 200 335 15 6175 Benefits/Flex Plan 27,205 18,511 54,215 54,215 54,215 - Subtotal 219,685 153,161 398,210 290,785 426,635 28,425 375 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Distribution Operations-Miscellaneous Distribution 6003 Salaries/Regular 44,110 49,679 50,410 20,945 46,215 (4,195) 6047 Sal/Bonus -1,500 ---- 6101 PERS/Employee Contribution 3,110 3,502 3,560 1,375 3,260 (300) 6105 PERS/Employer Contribution 3,800 4,352 4,435 1,890 5,185 750 6125 FICA/Employer Contrib/Med 865 973 965 495 905 (60) 6140 Life Insurance Allocation 115 129 135 50 125 (10) 6155 Workers' Comp Allocation 1,765 2,047 2,015 840 1,850 (165) 6160 LTD Insurance Allocation 345 387 390 165 360 (30) 6165 Unemployment Allocation 55 56 65 30 60 (5) 6175 Benefits/Flex Plan 15,445 15,680 16,150 9,910 16,150 - 6180 Deferred Comp/Employer Paid 45 495 540 540 540 - Subtotal 69,655 78,801 78,665 36,240 74,650 (4,015) Engineering 6003 Salaries/Regular 105,510 110,977 207,550 113,075 212,695 5,145 6045 Salaries/Education Incentive 1,450 1,459 1,450 1,420 1,450 - 6047 Sal/Bonus -2,536 ---- 6101 PERS/Employee Contribution 7,510 7,895 14,700 8,040 15,010 310 6105 PERS/Employer Contribution 9,060 9,778 18,290 10,040 23,815 5,525 6109 PARS/Employer Contribution 7,915 8,332 15,425 8,485 21,205 5,780 6125 FICA/Employer Contrib/Med 1,545 1,825 3,510 2,080 3,575 65 6140 Life Insurance Allocation --560 -570 10 6155 Workers' Comp Allocation 4,280 4,599 8,385 4,580 8,565 180 6160 LTD Insurance Allocation --1,620 -1,655 35 6165 Unemployment Allocation --240 -245 5 6175 Benefits/Flex Plan 15,505 15,738 32,305 32,305 32,305 - 6180 Deferred Comp/Employer Paid 150 1,500 3,600 3,600 3,600 - Subtotal 152,925 164,638 307,635 183,625 324,690 17,055 376 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Power Purchases-Other Expenses 6003 Salaries/Regular 356,175 358,859 356,470 349,235 356,470 - 6045 Salaries/Education Incentive 2,905 2,918 2,900 2,835 1,450 (1,450) 6047 Sal/Bonus -7,521 ---- 6048 Salaries/Language Pay 2,400 2,412 2,400 2,345 2,400 - 6101 PERS/Employee Contribution 25,860 26,285 25,370 25,580 25,295 (75) 6105 PERS/Employer Contribution 31,475 33,060 31,540 32,430 40,100 8,560 6109 PARS/Employer Contribution 19,915 20,335 18,990 19,800 25,615 6,625 6125 FICA/Employer Contrib/Med 5,820 6,267 5,940 5,940 5,925 (15) 6140 Life Insurance Allocation 980 975 960 910 960 - 6155 Workers' Comp Allocation 14,735 15,279 14,445 14,575 14,415 (30) 6160 LTD Insurance Allocation 2,755 2,766 2,770 2,690 2,775 5 6165 Unemployment Allocation 325 363 410 340 410 - 6175 Benefits/Flex Plan 46,515 47,278 48,455 48,455 48,455 - 6180 Deferred Comp/Employer Paid 345 3,495 4,140 4,140 4,140 - Subtotal 510,205 527,812 514,790 509,275 528,410 13,620 PERSONNEL SUBTOTAL 3,088,440 3,053,153 3,496,975 3,206,565 3,702,590 205,615 377 THIS PAGE INTENTIONALLY LEFT BLANK 378 Description 3340733xxx, 3340735xxx, 3340745xxx, 3340775xxx, 3340785xxx, 6220 Training Schools - California-Nevada Apprentice Program for Line Mechanics, plus on the job training to become certified Journeyman; Mesa Hot Line School; High Voltage Training for All Electric Crews (required); other training for Supervisors, Line Mechanics, and Meter Technicians on new equipment, maintenance and construction techniques. 6230 Dues & Subscriptions - California Municipal Utilities Association (CMUA), California Utilities Emergency Association (CUEA), Barclays Law Publications Subscription, Electric Safety Orders (Updates). 6235 Meetings & Conferences - Western Underground Committee meetings, Asset Management seminar (CUEA), meetings on CAISO Transmission Planning and other topics, American Public Power Association (APPA) Engineering & Operations annual meeting; Transmission & Distribution Expo/Conference; Relay seminars; and CMUA meetings. 6340 Special Studies - Update of distribution system and integrated resources plans, reliability and energy storage studies, and GO 165 pole load recalculations, IRP cases/scenarios 6493 Outside Services - Cost for third party and California Independent System Operator (CAISO) transmission services; real time electric load scheduling/dispatching services. Other services to support electric distribution system. 6590 Electricity for Resale -Purchase of electricity for distribution and sale to retail customers 6625 Program Expenses - This amount is for compliance with State's solar power mandate, Senate Bill 1, and provides funding to customers interested in installing photovoltaic equipment 7130 Structures & Other - Includes poles, towers and fixtures – anything that supports overhead lines; substation structures; and underground structures including pull boxes and vaults 7140 Equipment & Machinery - Includes transformers, switches, power equipment, street light equipment, substation equipment such as breakers and panels and laboratory equipment 7145 Lines, Mains & Sewers - Underground cable and overhead conductors and subfeeds to residential and commercial buildings LIGHT & WATER - ELECTRIC ACTIVITY DETAIL Account Number 379 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (SUMMARY) DESCRIPTION REVISED YEAR END EST ADOPTED Acct. #14-15 14-15 15-16 VARIANCE Explanation 6201 Uniform & Laundry 20,000 25,000 30,000 10,000 In the process of changing vendor that currently provides uniform laundry service due to poor performance 6230 Dues & Subscription 22,500 22,900 23,000 500 Increased budget to better align with actual dues and subscription services paid 6399 Professional Consultants 10,000 18,000 13,000 3,000 Added $3K to budget for preparation of annual bond disclosure reports 6493 Outside Services & Repairs 4,403,570 4,153,215 4,914,180 510,610 Increase due to SCE raising their transmission rates on existing contracts (we have 4 existing contracts with them now); ISO has raised TAC rates (due to Valley Electric joining the ISO and SDG&E raising their transmission rates dramatically) 6825 Maint. & Repair / Vehicles 31,000 31,000 36,000 5,000 Increase due to need for vital repairs for electric operation's old bucket and line trucks 6904 Utilities/Other 15,000 18,000 18,000 3,000 Increased budget to better align with actuals 7005 Principal Payment 585,000 585,000 620,000 35,000 Schedule bond debt service payments: $620K for 2003C and $0 for 2012B Bonds 380 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 OPERATIONS 6201 Uniforms & Laundry 16,990 16,175 20,000 25,000 30,000 10,000 6220 Training Schools 22,545 8,680 22,260 18,000 22,260 - 6225 Training Materials 5,700 57 1,000 1,000 1,000 - 6230 Dues & Subscriptions 22,970 24,456 22,500 22,900 23,000 500 6235 Meetings & Conferences 17,025 6,948 16,000 9,500 16,000 - 6240 Mileage Reimbursement 30 20 200 -100 (100) 6301 Legal Fees 101,095 121,537 282,500 112,000 222,500 (60,000) 6340 Special Studies 35,140 10,522 230,000 123,450 140,000 (90,000) 6345 Program Consultants 1,920 1,509 5,000 4,300 5,000 - 6399 Professional Services/Other (13,765) 9,993 10,000 18,000 13,000 3,000 6424 Consumer Services Allocation 2,192,490 2,184,954 2,397,140 2,358,950 2,376,100 (21,040) 6430 Custodial Services 4,425 4,620 5,000 4,860 5,000 - 6493 Outside Services & Repairs 3,401,300 3,529,571 4,403,570 4,153,215 4,914,180 510,610 6521 Messenger Service 975 1,133 200 200 200 - 6530 Office Supplies 2,830 3,560 4,240 3,050 4,100 (140) 6539 Printing, Binding & Duplicating - 56 --- - 6551 Fuel and Oil 27,175 28,881 25,800 40,000 25,000 (800) 6554 Supplies/Custodial & Cleaning 1,390 1,790 900 900 900 - 6563 Supplies/Special 20,740 17,250 45,000 40,500 35,000 (10,000) 6564 Supplies/Medical-Dental 1,335 890 1,500 1,000 1,500 - 6566 Small Tools 3,735 15,430 16,600 7,500 16,500 (100) 6569 Small Equipment 3,310 417 19,000 -19,000 - 6590 Electricity For Resale 29,119,310 29,702,508 31,114,030 29,335,075 30,772,590 (341,440) 6601 Advertising Expense 1,425 1,774 2,000 2,000 2,000 - 6610 Bond Administration 2,500 4,250 4,250 4,250 4,250 - 6625 Program Expenses 408,010 382,252 425,000 321,000 327,100 (97,900) 6805 Maint/Land Improvements 590 611 15,000 -7,500 (7,500) 6815 Maint & Repairs/Bldgs 18,010 14,850 17,600 17,600 17,600 - 6825 Maint & Repair / Vehicle 29,300 29,403 31,000 31,000 36,000 5,000 6827 Garage Allocation --3,800 -- (3,800) 6835 Maint & Repair/Equipment 5,170 7,271 8,500 5,800 8,500 - 6850 Lease Payments - -5,000 3,400 3,400 (1,600) 6904 Utilities/Other 17,020 17,193 15,000 18,000 18,000 3,000 6905 Utilities / Electricity 9,810 9,659 11,000 10,000 10,000 (1,000) 381 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 6910 Utilities/Natural Gas 670 656 700 700 700 - 6915 Utilities/Telephone 9,435 10,179 8,400 8,700 8,700 300 7001 Interest Expense 348,005 291,429 253,550 253,550 219,015 (34,535) 7005 Principal Payment --585,000 585,000 620,000 35,000 7009 Bank Service Charge 2,725 ---- - 7010 Franchise Fee (2%) 726,060 735,365 767,765 764,640 774,000 6,235 7012 In-lieu Fee (8%) 2,904,235 2,941,461 3,073,385 3,058,560 3,095,990 22,605 7055 Uncollectible Accounts 116,800 65,832 80,000 73,100 80,000 - OPERATIONS SUBTOTAL 39,588,430 40,203,146 43,949,390 41,436,700 43,875,685 (73,705) ----- CAPITAL OUTLAY 7130 Structures/Other 35,950 25,797 85,000 55,000 85,000 - 7140 Equipment & Machinery 238,240 432,094 616,700 541,700 475,000 (141,700) 7145 Lines, Mains & Sewers 229,965 369,995 330,000 325,000 330,000 - CAPITAL OUTLAY SUBTOTAL 504,155 827,885 1,031,700 921,700 890,000 (141,700) TRANSFERS OUT 5950 Transfer Out 109,355 121,380 30,350 123,370 31,615 1,265 TRANSFERS OUT SUBTOTAL 109,355 121,380 30,350 123,370 31,615 1,265 ELECTRIC FUND TOTAL: 43,290,380 44,205,564 48,508,415 45,688,339 48,499,890 (8,525) 382 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 OPERATIONS Interest - Long-Term Debt 7001 Interest Expense 348,005 291,429 253,550 253,550 219,015 (34,535) 7005 Principal Payment --585,000 585,000 620,000 35,000 Subtotal 348,005 291,429 838,550 838,550 839,015 465 Distribution Operations-Supervision & Engineering 6530 Office Supplies 75 18 240 50 100 (140) Subtotal 75 18 240 50 100 (140) Distribution Operations-Overhead Lines 6563 Supplies/Special 410 117 1,000 500 1,000 - 6566 Small Tools 1,270 10,883 10,000 5,000 10,000 - Subtotal 1,680 11,000 11,000 5,500 11,000 - Distribution Operations-Underground Lines 6566 Small Tools -2,075 3,100 1,000 3,000 (100) Subtotal -2,075 3,100 1,000 3,000 (100) Distribution Operations-Street Lighting & Signal 6905 Utilities / Electricity 9,810 9,659 11,000 10,000 10,000 (1,000) Subtotal 9,810 9,659 11,000 10,000 10,000 (1,000) 383 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Distribution Operations-Meters 6566 Small Tools --500 500 500 - Subtotal --500 500 500 - Distribution Operations-Miscellaneous Distribution 6201 Uniforms & Laundry 16,990 16,175 20,000 25,000 30,000 10,000 6220 Training Schools 20,790 5,978 16,000 15,000 16,000 - 6225 Training Materials 205 57 1,000 1,000 1,000 - 6230 Dues & Subscriptions 22,970 22,456 22,500 22,900 23,000 500 6235 Meetings & Conferences 4,340 2,378 8,000 3,000 8,000 - 6240 Mileage Reimbursement 30 -200 -100 (100) 6301 Legal Fees 4,645 4,393 2,500 2,000 2,500 - 6340 Special Studies 7,140 5,777 50,000 35,000 50,000 - 6430 Custodial Services 385 ----- 6493 Outside Service/Repair 300 -12,180 12,180 1,000 (11,180) 6521 Messenger Service 645 669 200 200 200 - 6530 Office Supplies 855 933 1,000 900 1,000 - 6551 Fuel and Oil 27,175 28,881 25,000 40,000 25,000 - 6563 Supplies/Special 4,605 5,970 5,000 5,000 5,000 - 6564 Supplies/Medical-Dental 1,335 890 1,500 1,000 1,500 - 6566 Small Tools 2,415 -3,000 1,000 3,000 - 6569 Small Equipment -245 15,000 -15,000 - 6601 Advertising Expense 1,425 480 2,000 2,000 2,000 - 6825 Maint & Repair / Vehicle 29,275 29,403 30,000 30,000 35,000 5,000 6827 Garage Allocation --3,800 --(3,800) 6835 Maint & Repair/Equipment 810 98 5,000 5,000 5,000 - 6904 Utilities/Other 17,020 17,193 15,000 18,000 18,000 3,000 6910 Utilities/Natural Gas 670 656 700 700 700 - 6915 Utilities/Telephone 7,890 8,745 7,200 7,200 7,200 - Subtotal 171,915 151,376 246,780 227,080 250,200 3,420 384 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Distribution Maintenance-Structures 6430 Custodial Services 4,040 4,620 5,000 4,860 5,000 - 6493 Outside Services & Repairs 1,020 2,725 2,500 2,000 2,500 - 6554 Supplies/Custodial & Cleaning 1,390 1,790 900 900 900 - 6563 Supplies/Spcl -410 ---- 6805 Maint/Land Improvement 590 611 15,000 -7,500 (7,500) 6815 Maint & Repairs/Bldgs 18,010 14,850 17,600 17,600 17,600 - Subtotal 25,050 25,006 41,000 25,360 33,500 (7,500) Distribution Maintenance-Station Equipment 6493 Outside Services & Repairs 30,830 13,829 40,000 20,000 30,000 (10,000) 6563 Supplies/Special 630 853 10,000 10,000 10,000 - Subtotal 31,460 14,681 50,000 30,000 40,000 (10,000) Distribution Maintenance-Overhead Lines 6493 Outside Services & Repairs 198,500 174,394 200,000 160,000 200,000 - 6563 Supplies/Special 5,740 3,602 4,000 4,000 4,000 - Subtotal 204,240 177,997 204,000 164,000 204,000 - Distribution Maintenance-Underground Lines 6493 Outside Services & Repairs 9,345 3,458 30,000 25,000 30,000 - 6563 Supplies/Special 3,460 2,454 2,000 2,000 2,000 - 6566 Small Tools 50 2,472 ---- 6601 Advertising Expn -1,294 ---- 6835 Maint & Repair/Equipment 3,595 6,434 500 -500 - Subtotal 16,450 16,112 32,500 27,000 32,500 - Distribution Maintenance-Transformer Lines 6493 Outside Services & Repairs 5,815 3,360 10,000 4,000 10,000 - Subtotal 5,815 3,360 10,000 4,000 10,000 - 385 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Distribution Maintenance-Street Lighting & Signals 6563 Supplies/Special --15,000 15,000 5,000 (10,000) Subtotal --15,000 15,000 5,000 (10,000) Distribution Maintenance-Meters 6563 Supplies/Special 5,895 3,845 8,000 4,000 8,000 - 6835 Maint & Repair/Equipment 765 739 3,000 800 3,000 - Subtotal 6,660 4,584 11,000 4,800 11,000 - Customer Accounts-Uncollectible Accounts 7055 Uncollectible Accounts 116,800 65,832 80,000 73,100 80,000 - Subtotal 116,800 65,832 80,000 73,100 80,000 - Engineering 6220 Training Schools -910 1,000 1,000 1,000 - 6235 Meetings & Conferences --2,000 1,500 2,000 - 6340 Special Studies 28,000 -30,000 -30,000 - 6345 Program Consultants 1,920 1,509 5,000 4,300 5,000 - 6399 Professional Services/Other 5,785 5,922 10,000 15,000 10,000 - 6530 Office Supplies 1,810 2,609 2,000 2,000 2,000 - 6539 Prnt,Bindng&Dupl -56 ---- 6551 Fuel and Oil --800 --(800) 6825 Maint & Repair / Vehicle 25 -1,000 1,000 1,000 - Subtotal 37,540 11,007 51,800 24,800 51,000 (800) Resource Management - Purchased Power 6590 Electricity For Resale 29,119,310 29,702,508 31,114,030 29,335,075 30,772,590 (341,440) Subtotal 29,119,310 29,702,508 31,114,030 29,335,075 30,772,590 (341,440) 386 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Resource Management - Planning 6220 Training Schools 1,755 1,793 5,260 2,000 5,260 - 6225 Training Materials 5,495 ----- 6235 Meetings & Conferences 12,685 4,570 6,000 5,000 6,000 - 6240 Mileage Reimbursement -20 ---- 6301 Legal Fees 96,450 58,085 120,000 50,000 120,000 - 6340 Special Studies -4,745 150,000 88,450 60,000 (90,000) 6521 Messenger Service 330 464 ---- 6530 Office Supplies 90 -1,000 100 1,000 - 6569 Small Equipment 3,310 172 4,000 -4,000 - 6625 Program Expenses 408,010 382,252 425,000 321,000 327,100 (97,900) 6850 Lease Payments --5,000 3,400 3,400 (1,600) 6915 Utilities/Telephone 1,545 1,435 1,200 1,500 1,500 300 Subtotal 529,670 453,536 717,460 471,450 528,260 (189,200) Resources Management - Transmission 6230 Dues & Subscriptions ----- 6493 Outside Services & Repairs 537,820 541,630 703,320 594,220 708,600 5,280 Subtotal 537,820 541,630 703,320 594,220 708,600 5,280 Resources Management - Transmission by Others 6493 Outside Services & Repairs 2,617,670 2,790,174 3,405,570 3,335,815 3,932,080 526,510 Subtotal 2,617,670 2,790,174 3,405,570 3,335,815 3,932,080 526,510 Administrative & General 6230 Dues & Subscript -2,000 --- 6301 Legal Fees -59,059 160,000 60,000 100,000 (60,000) 6399 Professional Services/Other (19,550) 4,071 -3,000 3,000 3,000 6424 Consumer Services Allocation 2,192,490 2,184,954 2,397,140 2,358,950 2,376,100 (21,040) Subtotal 2,172,940 2,250,084 2,557,140 2,421,950 2,479,100 (78,040) Franchise Fees 7010 Franchise Fee (2%) 726,060 735,365 767,765 764,640 774,000 6,235 7012 In-lieu Fee (8%) 2,904,235 2,941,461 3,073,385 3,058,560 3,095,990 22,605 387 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Subtotal 3,630,295 3,676,827 3,841,150 3,823,200 3,869,990 28,840 Interest Transfers 6610 Bond Administration 2,500 4,250 4,250 4,250 4,250 - 7009 Bank Service Charge 2,725 ----- Subtotal 5,225 4,250 4,250 4,250 4,250 - OPERATIONS SUBTOTAL 39,588,430 40,203,146 43,949,390 41,436,700 43,875,685 (73,705) 388 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 CAPITAL OUTLAY Station Equipment 7140 Equipment & Machinery 16,430 5,884 75,000 50,000 75,000 - Subtotal 16,430 5,884 75,000 50,000 75,000 - Poles, Towers & Fixtures 7130 Structures/Other 23,500 22,625 35,000 25,000 35,000 - 7140 Equipment & Machinery -1,299 ---- 7145 Lines, Mains & Sewers 180 64 ---- Subtotal 23,680 23,988 35,000 25,000 35,000 - Overhead Conductors & Dev 7145 Lines, Mains & Sewers 20,775 30,192 30,000 25,000 30,000 - Subtotal 20,775 30,192 30,000 25,000 30,000 - Underground Conduit 7130 Structures/Other 12,450 2,942 25,000 5,000 25,000 - 7140 Equipment & Machinery 1,760 ----- Subtotal 14,210 2,942 25,000 5,000 25,000 - Underground Conductors & Dev 7145 Lines, Mains & Sewers 209,010 339,739 300,000 300,000 300,000 - Subtotal 209,010 339,739 300,000 300,000 300,000 - Line Transformers 7140 Equipment & Machinery 124,250 289,510 250,000 250,000 250,000 - Subtotal 124,250 289,510 250,000 250,000 250,000 - Meters 7140 Equipment & Machinery 72,270 61,509 150,000 100,000 150,000 - Subtotal 72,270 61,509 150,000 100,000 150,000 - 389 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED VARIANCE Acct. #12-13 13-14 14-15 14-15 15-16 Street Lighting 7130 Structures/Other -230 25,000 25,000 25,000 - 7140 Equipment & Machinery 23,530 24,890 ---- Subtotal 23,530 25,120 25,000 25,000 25,000 - Tools, Shop Equipment 7140 Equipment & Machinery -49,002 141,700 141,700 -(141,700) Subtotal -49,002 141,700 141,700 -(141,700) CAPITAL OUTLAY SUBTOTAL 504,155 827,885 1,031,700 921,700 890,000 (141,700) TRANSFERS OUT Dist Oper - Overhead Line Expenses 5950 Transfers Out 4,265 10,091 10,090 10,090 10,500 410 Subtotal 4,265 10,091 10,090 10,090 10,500 410 Dist Oper - Underground Line Expenses 5950 Transfers Out 4,265 10,091 10,090 10,090 10,500 410 Subtotal 4,265 10,091 10,090 10,090 10,500 410 Dist Oper - Meters 5950 Transfers Out 100,825 101,199 10,170 103,190 10,615 445 Subtotal 100,825 101,199 10,170 103,190 10,615 445 TRANSFERS OUT SUBTOTAL 109,355 121,380 30,350 123,370 31,615 1,265 ELECTRIC FUND TOTAL: 43,290,380 44,205,564 48,508,415 45,688,335 48,499,890 (8,525) 390 THIS PAGE INTENTIONALLY LEFT BLANK 391