Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
14. Light & Water_201707171855391389
LIGHT AND WATER Public Benefit Programs Consumer Services Water Water Utility Electric Utility 288 PROGRAM DESCRIPTION: LIGHT AND WATER PUBLIC BENEFITS PROGRAM PROGRAM COMMENTARY 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 17-18 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 16-17 PROGRAM HIGHLIGHTS: •Achieved estimated gross annual energy savings of 3,599,078 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., 289 BUDGET UNIT: DESCRIPTION Acct.# OPERATIONS 6625 Program Expense FUND 24 DIVISION -PUBLIC BENEFIT PROGRAMS-BUDGET DETAIL VARIANCE REVISED YEAR END EST ADOPTED 16-17 16-17 17 -18 848,500 848,500 948,500 VARIANCE Explanation 100,000 Increased budget for commercial/ industrial audits & retrofit rebates for energy efficiency program. 290 Account Number 2440739xxx 6625 LIGHT & WATER -PUBLIC BENEFITS PROGRAM ACTIVITY DETAIL Description Program Expense -Low Income Assistance Program, Energy Efficiency Program, Renewables Program, Research & Development. Administration of PBC. 291 BUDGET UNIT: 2440739xxx L&W PUBLIC BENEFIT PROGRAMS DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE PERSONNEL 2440739085 ADMINISTRATION OF PBC 6003 Salaries/Regular 77,271 122,819 113, 150 112,423 102,905 (10,245) 6006 Salaries/Temp & Part-Time 6,414 6045 Salaries/Education Incentive 1,240 1, 146 1,024 6069 AllowancesNehicle 255 270 254 270 6101 PERS/Employee Contribution 5,973 9,404 8,045 8,604 7,300 (745) 6105 PERS/Employer Contribution 8,227 14,347 12, 120 13,773 15,485 3,365 6109 PARS/Employer Contribution 6,465 11,321 10,775 10,646 9,235 (1,540) 6125 FICNEmployer Contrib/Med 1,587 2,357 1,925 2,096 1,765 (160) 6140 Life Insurance Allocation 208 323 305 283 275 (30) 6155 Workers' Comp Allocation 3,582 5,352 4,535 4,897 4,130 (405) 6160 LTD Insurance Allocation 625 969 875 806 805 (70) 6165 Unemployment Allocation 85 124 135 108 120 (15) 6175 Benefits/Flex Plan 13,737 28, 128 19, 150 19, 150 18,345 (805) 6180 Deferred Come/Emelo er Paid 1,530 1,590 1,550 1,550 1,460 (90) SUBTOTAL 137,425 213,188 172,835 189,592 162,095 (10,740) PERSONNEL SUBTOTAL 137,425 213,188 172,835 189,592 162,095 (10,740) 292 BUDGET UNIT: 2440739xxx L&W PUBLIC BENEFIT PROGRAMS DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE OPERATIONS 2440739081 RESIDENTIAL LOW INCOME 6625 Program Expense 48,039 43,200 50,000 50,000 50,000 SUBTOTAL 48,039 43,200 50,000 50,000 50,000 2440739082 ENERGY EFFICIENCY PROGRAM 6625 Program Exeense 464,821 531, 179 678,500 678,500 778,500 100,000 SUBTOTAL 464,821 531, 179 678,500 678,500 778,500 100,000 2440739083 RESEARCH & DEVELOPMENT 6625 Program Exeense 3,085 3,255 10,000 10,000 10,000 SUBTOTAL 3,085 3,255 10,000 10,000 10,000 2440739084 RENEWABLES 6625 Program Expense 60,000 60,000 60,000 SUBTOTAL 60,000 60,000 60,000 2440739085 ADMINISTRATION OF PBC 6625 Program Expense 18,411 12,210 50,000 50,000 50,000 6825 Maint & Repair/Vehicle 1,630 298 500 500 6850 Lease Patments 3,311 2,549 1,800 1,500 1,500 (300) SUBTOTAL 23,353 15,056 52,300 51,500 52,000 (300) OPERATIONS SUBTOTAL 539,297 592,691 850,800 850,000 950,500 99,700 PUBLIC BENEFIT PROG FUND TOTAL 676,723 805,879 1,023,635 1,039,592 1,112,595 88,960 293 Budget Division: LIGHT AND WATER - PUBLIC BENEFIT PROGRAMS FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 Adopted Adopted Adopted Adopted Adopted Adopted Adopted Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Utility Programs Specialist(a)0.70 0.70 $66,905 $68,245 Asst Director-Cust Care and Solutions 0.05 0.00 16,275 0 Customer Service Representaive III (b)0.30 0.30 20,030 20,335 Director of Utililites (c)0.05 0.05 9,940 9,470 Utilities Admin and Financial Svcs Manager (d)0.00 0.05 - 4,855 (a) .30 FTE Water (b) 9.70 FTE Cust Care Recs and Coll (c) .95 FTE Admin (d) .95 FTE Admin TOTAL 1.10 1.10 $113,150 $102,905 TOTAL - - - - Full Time Positions Part Time Positions 294 PROGRAM DESCRIPTION: LIGHT AND WATER CONSUMER SERVICES PROGRAM COMMENTARY 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 2017-18 STRATEGIC GOALS: •Convert customers that are paying automatically to new electronic payment system that is integrated with Utility Billing system •Offer customers new options to request and process payment extensions both online and over the phone •Complete lobby remodeling to improve customer service and make more customer service staff available to the public •Initiate utility modernization project by approving advanced metering infrastructure (AMI) contract and commencing pilot phase FY 2016-17 PROGRAM HIGHLIGHTS: •Integrated credit card payments made across the cashier's counter and over the phone with Utility Billing System. •Developed contract with AMI vendor to implement turnkey AMI project, and submitted grant application to Bureau of Reclamation to finance portion of AMI project. •Developed new web account management page (webconnect) and web payment portal for autopay customers. •Completed design and bid package for lobby remodeling project. •Installed new utility payment drop box on Azusa Avenue. 295 BUDGET UNIT: DESCRIPTION Acct.# OPERATIONS 6201 Uniforms & Laundry 6220 Training Schools 6235 Meetings & Conferences 6399 Professional Services/Other 6415 Computer Software Support 6493 Outside Services & Repairs 6566 Small Tools CAPITAL OUTLAY 7150 Office Furniture & Equipment ALL FUND 31 DIVISIONS -CONSUMER SERVICES-BUDGET DETAIL VARIANCE REVISED 16-17 16,700 1,700 28,250 17,500 174,253 190,037 400 YEAR END EST ADOPTED 16-17 17-18 17,500 18,000 500 8,400 28,050 29,050 17,500 67,500 180,000 180,000 190,453 190,370 750 750 14,453 VARIANCE Ex lanation 1,300 Increase due to 3 FT Meter Readers Placed and YTD Expenses up. 6,700 Increase due to tuition reimbursement. 800 Increase due to additional training expected. 50,000 Increase due to assess CIS System Options. 5,747 Increase due to higher CIS costs. 333 Increase due to rounded up. 350 Increase due to additional expenses are expected. 14,453 Increase due to office partitions and furniture for Customer Service's back office to create new workstation and separate Supervisory work area with higher partition similar to creating closed office work environment to allow one on one meetings with CSR staff. 296 LIGHT & WATER -CONSUMER SERVICES ACTIVITY DETAIL Account Number 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. 6230 Dues/Subscriptions -Azusa Chamber of Commerce, California Municipal Management Association (CMUA), Southern California Public Power Authority (SCPPA), and American Public Power Association (APPA). ($250 for Admin) 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 -Transcription Services for Utility Board Minutes, professional services for L&W Administration. Consultant to provide technical assessment of customer information system and options to upgrade or replace system. 6415 Computer Software Services -Utility Billing System maintenance, and enhancements programming, including integration with other systems. Also includes billing system maintenance for Time-of-Use (TOU) customers and Itron meter data management system. 6493 Outside Services & Repairs -Charter Communication cable TV services, 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. 6499 Contract Services & Fees -Azusa Chamber of Commerce, Golden Week, City's Annual Winter Festival by Recreation & Family Services Department, Recreation's Gym Decal, Rose Parade, Civic Leadership, and other miscellaneous donations. 6539 Printing, Binding & Duplicating -Utility Board Minutes Book, 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) 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. 297 BUDGET UNIT: ALL FUND 31 DIVISIONS-CONSUMER SERVICES (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE PERSONNEL 6003 Salaries/Regular 1,752,887 1,735,940 1,957,605 1,621,403 2,258,315 300,710 6006 Salaries/Temp & Part-Time 257,888 286,204 322,430 248,994 137,850 (184,580) 6030 Overtime Pay/Regular 17 6033 Overtime Pay/Premium 5,070 2,934 12,500 1,954 12,500 6039 Salaries/Education Incentive 404 1,593 1,283 6045 Standby Pay/Premium 7,411 6,882 5,482 6947 Salaries/Bonuses 6048 Salaries/Language Pay 22,276 22,524 21,225 20,849 21,690 465 6063 Salaries/Jury Duty 2,541 317 6069 Allowances/Vehicle 26,725 28,272 27,930 27,260 27,930 6070 Allowances/Telephone 435 1,280 250 846 900 650 6072 Salaries/Injury 3,110 34,065 101 6075 Vacation Pay-Off 38,590 52,949 24,420 6078 Sick Leave Pay-Off 5,533 21,374 6079 Adm Lve Pay-Off 1, 145 1,985 6091 Leave Liability Adjustments 17,274 (59,371) 6101 PERS/Employee Contribution 130,025 130,246 155,860 116,555 167,565 11,705 6105 PERS/Employer Contribution 185,088 163,835 234,357 238,769 313,280 78,923 6107 Apple Pay Plan 355 3,127 1,164 1,275 (1,852) 6109 PARS/Employer 86,628 156,831 113,815 107,686 125,580 11,765 6125 FICA/Employer Contrib/Med 32,796 32,987 39,945 30,918 42,585 2,640 6133 Retiree Health Premium Reimb 10,273 11, 152 12,255 12,255 12,625 370 6140 Life Insurance Allocation 4,428 4,322 5,260 3,781 6,075 815 6155 Workers' Comp Allocation 82,889 84, 141 92,300 76,498 96,975 4,675 6160 LTD Insurance Allocation 13,589 13,265 15,245 10,976 17,580 2,335 6165 Unemployment Allocation 2,086 2,049 2,765 1,841 2,940 175 6175 Benefits/Flex Plan 412,208 419,077 445,985 444, 186 510,925 64,940 6180 Deferred Comp/Emploler Paid 6,246 9,978 10, 170 11,345 10,710 540 PERSONNEL SUBTOTAL 3,107,544 3,163,219 3,473,024 3,010,552 3,767,300 294,276 298 BUDGET UNIT: DESCRIPTION Acct.# OPERATIONS 6201 Uniforms & Laundry 6210 Employee Awards 6220 Training Schools 6230 Dues & Subscriptions 6240 Mileage Reimbursement 6235 Meetings & Conferences 6301 Legal Fees 6399 Professional Services/Other 6415 Computer Software Support 6423 Administrative Allocation 6430 Custodial Services 6493 Outside Services & Repairs 6499 Contract Services & Fees 6518 Postage 6521 Messenger Service 6530 Office Supplies 6539 Printing, Binding & Duplicating 6551 Fuel and Oil 6554 Supplies/Custodial & Cleaning 6563 Supplies/Special 6564 Supplies/Medical-Dental 6566 Small Tools 6569 Small Equipment 6570 Computer Peripherals/Misc 6572 Office Furniture & Equipment 6601 Advertising Expense 6615 Safety & Security Services Exp 6670 IT Allocation 6760 Insurance Allocation 6805 Maintenance/Land Improvements 6815 Maint & Repairs/Bldgs 6825 Maint & Repair I Vehicle 6835 Maint & Repair/Equipment ALL FUND 31 DIVISIONS-CONSUMER SERVICES (SUMMARY) ACTUAL ACTUAL REVISED 14-15 15-16 16-17 14,017 15,086 16,700 100 195 1, 101 1,700 65 149 100 118 100 16,665 17,776 28,250 18,792 18, 104 23,000 2,470 1,000 17,500 102,824 141,992 174,253 957,610 1,304,298 1,387,775 9,545 10,880 25,100 156,216 130,504 190,037 42,785 57,500 108,548 115,927 135,000 344 320 450 11,463 12,809 13,800 3,807 6,491 7,000 20,486 16,411 17,500 3,755 2,016 4,000 9,276 6,701 12,299 330 416 1,000 597 797 400 1,444 558 2,000 9 30,393 1,000 972 2,000 500 2,888 2,947 6,000 356,583 626,770 616,410 585,350 553,282 712, 170 10,678 9,768 12,000 17,472 2,368 23,700 12,264 12,864 12,500 42,627 40,827 56,750 YEAR END EST 16-17 17,500 500 100 100 28,050 21,000 17,500 180,000 1,387,775 24,221 190,453 57,500 135,000 163 13,800 5,481 15,000 4,000 11,393 1,000 750 1,500 1,000 2,000 500 5,000 605,410 712, 170 12,000 23,700 12,500 55,856 ADOPTED 17-18 18,000 8,400 100 100 29,050 23,000 67,500 180,000 25, 100 190,370 57,500 135,000 350 13,800 6,750 15,000 4,000 12,300 1,000 750 2,000 1,000 2,000 500 6,000 640,462 1,172,570 12,000 23,700 12,500 54,750 VARIANCE 1,300 6,700 800 50,000 5,747 (1,387,775) 333 (100) (250) (2,500) 350 24,052 460,400 (2,000) 299 BUDGET UNIT: ALL FUND 31 DIVISIONS-CONSUMER SERVICES (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 6840 Rent/Office Furniture & Equip 3,639 3,970 6,000 6,000 6,000 6850 Lease Payments 2,890 3,400 2,600 (3,400) 6904 Utilities/Other 15,059 4,873 16,000 16,000 16,000 6915 Utilities/Telephone 39,620 50,807 71,200 71,191 71,200 7050 Donations/Contribution 0 50, 193 OPERATIONS SUBTOTAL 2,567,522 3,196,378 3,655,094 3,638,713 2,808,752 (846,342) 300 BUDGET UNIT: DESCRIPTION Acct.# CAPITAL OUTLAY 7130 Structures/Other 7140 Equipment & Machinery 7150 Office Furniture & Equipment 7142 Comeuter Eguiement CAPITAL SUBTOTAL TRANSFERS OUT 5950 Transfers Out TRANSFERS OUT SUBTOTAL CONSUMER SERVICE FUND TOTAL: ALL FUND 31 DIVISIONS-CONSUMER SERVICES {SUMMARY) ACTUAL 14-15 4,360 4,360 677, 114 677,114 6,356,540 ACTUAL 15-16 10,650 9,943 69,871 90,465 428,790 428,790 6,878,852 REVISED YEAR END EST ADOPTED 16-17 16-17 17-18 67,540 67,540 1,819 14,452 57,140 57, 140 124,680 124,680 16,271 548,355 548,355 523, 176 548,355 548,355 523,176 7,801,153 7,322,300 7,115,499 VARIANCE (65,721) 14,452 (57,140) (108,409) {25, 179) (25,179) (685,654) 301 Budget Division: LIGHT AND WATER - CONSUMER SERVICES (ALL) FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 Adopted Adopted Adopted Adopted Adopted Adopted Adopted Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Director of Utilities (a) 0.95 0.95 $188,880 179,885 Cashiers 4,600 2,496 $57,825 $26,045 Utilities Admin and Financial Svcs Manager (b)1.00 0.95 106,020 92,260 Drought Tech 5,000 1,830 104,865 20,030 Util Comm. & Environ Specialist (e)0.60 0.60 44,390 50,115 Cust Srv Rep I 2,000 1,664 40,995 27,470 Senior Management Analyst 1.00 1.00 82,750 84,160 Meter Reader 4,368 1,664 118,745 31,360 Senior Administrative Technician 1.00 1.00 56,780 57,350 Water Education Specialist 0 1,560 0 32,945 Asst Director-Cust Care and Solutions(c)0.95 1.00 131,230 139,460 Customer Care Operations Supervisor 1.00 1.00 42,270 86,955 Customer Services Representative III 9.70 9.70 624,195 650,520 Field Services Representative 2.00 2.00 142,670 151,080 Field Services Supervisor 1.00 1.00 76,195 82,030 Meter Reader 4.00 6.00 263,170 398,670 City Manager(d)0.30 0.30 59,550 59,550 Customer Care Lead (g)1.00 1.00 65,420 66,575 Utilities Systems Analyst (f)1.00 1.00 74,085 64,895 Utility Financial/Accounting Analyst 0.00 1.00 0 65,405 Cashier 0.00 1.00 0 29,405 (a) .05 FTE Public Benefit (b) .05 FTE Public Benefit (c) .05 FTE Public Benefits (d) .10 FTE CFD-Rosedale; .60 FTE Administration (e) .40 FTE Solid Waste (f) Reclassed from Admin Analyst in FY 16/17 (g) Position added in FY 16/17 TOTAL 25.50 29.50 $1,957,605 $2,258,315 TOTAL 15,968 9,214 $322,430 $137,850 Full Time Positions Part Time Positions 302 BUDGET UNIT: ALL FUND 31 DIVISIONS -CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE PERSONNEL 3140701928 Utility Board 6069 AllowancesNehicle 21,101 21,121 21,000 21,000 21,000 Subtotal 21, 101 21,121 21,000 21,000 21,000 3140702920 Utility Administration 6003 Salaries/Regular 403,930 430, 109 538,370 377,734.05 588,725 50,355 6006 Salaries/Temp & Part-Time 15,255 6033 Overtime Pay/Premium 975 29 6045 Salaries/Education Incentive 2,553 2,174 1,365 6048 Salaries/Language Pay 2,977 3,441 3,840 4,416 3,840 6063 Salaries/Jury Duty 110 6069 AllowancesNehicle 5,624 7,151 6,930 6,260 6,930 6070 Allowances/Telephone 435 1,280 250 846 900 650 6075 Vacation Pay-Off 21,394 10,760 20,362 6078 Sick Leave Pay-Off 2,088 1,362 6079 Adm Lve Pay-Off 1,145 1,985 6101 PERS/Employee Contribution 29,243 31,009 38,100 25,511 41,655 3,555 6105 PERS/Employer Contribution 36,606 46,840 57,265 44, 131 73,670 16,405 6109 PARS/Employer Contribution 28,563 34,281 34,695 37,439 33,575 (1, 120) 6125 FICA/Employer Contrib/Med 7,474 7,628 9,100 6,851 10,040 940 6140 Life Insurance Allocation 951 978 1,455 830 1,595 140 6155 Workers' Comp Allocation 17,297 17,673 21,975 15,690 23,990 2,015 6160 LTD Insurance Allocation 3,325 3,626 4,190 2,788 4,585 395 6165 Unemployment Allocation 437 432 625 381 695 70 6175 Benefits/Flex Plan 55,257 56,816 78,330 78,330 91,925 13,595 6180 Deferred Come/Emelo}:'.er Paid 4,176 7,825 7,920 9,838 8,370 450 Subtotal 639,815 663,415 803,045 634,757 890,495 87,450 303 BUDGET UNIT: ALL FUND 31 DIVISIONS -CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 3140711902 Field Services 6003 Salaries/Regular 414,676 396,820 482,035 410,782.23 631,780 149,745 6006 Salaries/Temp & Part-Time 135,584 183,693 223,610 163,530 84,335 (139,275) 6030 Overtime Pay/Regular 17 6033 Overtime Pay/Premium 3,812 1,925 5,000 1,203 5,000 6048 Salaries/Language Pay 3,133 4,033 3,930 4,151 5,750 1,820 6063 Salaries/Jury Duty 317 6072 Salaries I Injury 404 30,978 6075 Vacation Pay-Off 10,822 7,247 1,612 6078 Sick Leave Pay-Off 2,522 3,347 6101 PERS/Employee Contribution 30,390 31,532 44,625 29,985 48,855 4,230 6105 PERS/Employer Contribution 46,962 69,624 67,112 77,736 94,815 27,703 6107 APPLE/EM PL YR CON 355 2,817 725 1,010 (1,807) 6109 PARS/Employer Contribution 19, 117 25,756 26,220 22,669 34,370 8,150 6125 FICA/Employer Contrib/Med 9,150 9,503 12,125 9,083 12,820 695 6140 Life Insurance Allocation 1,056 1,065 1,290 974 1,695 405 6155 Workers' Comp Allocation 22,459 24,944 28,375 23,395 28,865 490 6160 LTD Insurance Allocation 3, 115 3,001 3,750 2,673 4,920 1,170 6165 Unemployment Allocation 557 566 835 552 885 50 6175 Benefits/Flex Plan 108,768 116,929 126,490 126,490 162,630 36,140 Subtotal 812,931.75 913,244.59 1,028,214.00 876,842.95 1,117,730.00 89,516 3140711903 Customer Records & Collections 6003 Salaries/Regular 828,816 777,443 805,970 709,571.46 898,350 92,380 6006 Salaries/Temp & Part-Time 107,049 102,511 98,820 85,465 53,515 (45,305) 6033 Overtime Pay/Premium 283 980 7,500 751 7,500 6045 Salaries/Education Incentive 3,618 3,321 2,820 6048 Salaries/Language Pay 16,166 15,050 13,455 12,282 12, 100 (1,355) 6072 Salaries/Injury 2,707 3,088 101 6075 Vacation Pay-Off 6,373 34,942 2,445 6078 Sick Leave Pay-Off 923 16,666 6091 Leave Liability Adjustment 17,274 (59,371) 6101 PERS/Employee Contribution 62,901 58,375 63,925 52,315 67,270 3,345 6105 PERS/Employer Contribution 92,124 33,628 96,140 103,803 127,435 31,295 6107 APPLE/EM PL YR CON 310 439 265 (45) 6109 PARS/Employer Contribution 30,648 83,538 39,815 35,155 43,730 3,915 6125 FICA/Employer Contrib/Med 14,569 13,869 16,595 13,068 17,470 875 304 BUDGET UNIT: ALL FUND 31 DIVISIONS -CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 6133 Retiree Health Premium Reimb 10,273 11, 152 12,255 12,255 12,625 370 6140 Life Insurance Allocation 2,154 1,954 2,165 1,685 2,415 250 6155 Workers' Comp Allocation 38,865 36,205 36,700 32,428 38,540 1,840 6160 LTD Insurance Allocation 6,344 5,680 6,285 4,697 6,990 705 6165 Unemployment Allocation 994 930 1,160 818 1,205 45 6175 Benefits/Flex Plan 234,410 228,786 225,820 225,820 240,220 14,400 6180 Deferred CometEml)lo}'.:er Paid 540 315 540 540 Subtotal 1,479,463 1,369,059 1,427,455 1,295,918 1,530,170 102,715 3140711920 Employee Related 6003 Salaries/Regular 105,464 131,569 131,230 123,315 139,460 8,230 6045 Salaries/Education 1,240 1,388 1,297 6101 PERS/Employee Contribution 7,490 9,330 9,210 8,744 9,785 575 6105 PERS/Employer Contribution 9,396 13,743 13,840 13,099 17,360 3,520 6109 PARS/Employer 8,301 13,256 13,085 12,424 13,905 820 6125 FICA/Employer Contrib/Med 1,603 1,987 2,125 1,917 2,255 130 6140 Life Insurance Allocation 267 325 350 292 370 20 6155 Workers' Comp Allocation 4,268 5,318 5,250 4,984 5,580 330 6160 LTD Insurance Allocation 805 959 1,020 818 1,085 65 6165 Unemployment Allocation 97 121 145 91 155 10 6175 Benefits/Flex Plan 13,772 16,546 15,345 13,546 16,150 805 6180 Deferred Come/Emelo}'.:er Paid 1,530 1,838 1,710 1,507 1,800 90 Subtotal 154,233.19 196,379.12 193,310.00 182,033.21 207,905.00 14,595 PERSONNEL SUBTOTAL 3,107,544 3,163,219 3,473,024 3,010,552 3,767,300 294,276 305 BUDGET UNIT: ALL FUND 31 DIVISIONS -CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 3140701928 Utility Board 6235 Meetings & Conferences 1,453 1,682 2,500 2,500 2,500 6301 Legal Fees 18,060 16,146 20,000 20,000 20,000 6399 Professional Services 2,500 2,500 2,500 6521 Messenger Service 36 63 100 100 100 6539 Printing, Binding & Duplicating 62 250 250 6670 IT Allocation 6,798 6,597 18,000 7,000 13,300 (4,700} Subtotal 26,408 24,488 43,100 32,100 38,650 (4,450) 3140702921 Consumer Services -Administrative 6220 Training Schools 500 500 7,200 6,700 6230 Dues & Subscriptions 65 149 100 100 100 6235 Meetings & Conferences 11,665 12,578 17,550 17,550 17,550 6301 Legal Fees 732 829 3,000 1,000 3,000 6399 Professional Services/Other 2,470 1,000 15,000 15,000 15,000 6493 Outside Services & Repairs 269 770 370 353 370 0 6499 Contract Services & Fees 42,785 57,500 57,500 57,500 6521 Messenger Service 82 121 250 63 250 6530 Office Supplies 4,723 4,130 3,800 3,800 3,800 6539 Printing, Binding & Duplicating 1,883 5,357 4,000 3,981 4,000 6563 Supplies/Special 1,718 504 800 800 800 6564 Supplies/Medical-Dental 25 27 200 200 200 6570 Computer Peripherals/Misc 9 1,000 1,000 1,000 6572 Office Furniture & Equipment 648 1,000 1,000 1,000 6601 Advertising Expense 500 500 500 6915 Utilities/Telephone 1,098 1,938 2,200 2,191 2,200 7050 Donations/Contribution 0 50,193 Subtotal 67,524 78,243 107,770 105,539 114,470 6,700 306 BUDGET UNIT: ALL FUND 31 DIVISIONS -CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 3140702927 Utilities -Administration 6423 Administrative Allocation 957,610 1,304,298 1,387,775 1,387,775 0 (1,387,775) 6570 Computer Peripherals 30,393 0 6760 Insurance Allocation 585,350 553,282 712,170 712,170 1,172,570 460,400 Subtotal 1,542,960 1,887,973 2,099,945 2,099,945 1,172,570 (927,375) 3140702935 General Plant -Maintenance 6430 Custodial Services 9,545 10,880 25,100 24,221 25,100 6493 Outside Services & Repairs 158 1,472 4,500 4,600 4,500 6554 Supplies/Custodial & Cleaning 3,755 2,016 4,000 4,000 4,000 6563 Supplies/Special 968 1,934 2,000 2,093 2,000 6615 Safety & Security Services Exp 2,888 2,947 6,000 5,000 6,000 6805 Maintenance/Land Improvements 10,678 9,768 12,000 12,000 12,000 6815 Maint & Repairs/Bldgs 17,472 2,368 23,700 23,700 23,700 6835 Maint & Repair/Equipment 28,932 23,442 40,750 39,856 40,750 6840 RenUOffice Furniture & Equip 3,639 3,970 6,000 6,000 6,000 6904 Utilities/Other 15,059 4,873 16,000 16,000 16,000 Subtotal 93,093 63,671 140,050 137,469 140,050 3140711902 Field Services 6201 Uniforms & Laundry 6,032 7,058 6,700 7,500 8,000 1,300 6235 Meetings & Conferences 298 9 1,200 1,000 2,000 800 6493 Outside Services & Repairs 6,061 840 2,500 2,500 2,500 6521 Messenger Service 110 6539 Printing, Binding & Duplicating 71 1,000 1,000 1,000 6551 Fuel and Oil 20,486 16,411 17,500 15,000 15,000 (2,500) 6563 Supplies/Special 4,592 3,012 7,999 8,000 8,000 1 6566 Small Tools 597 797 400 750 750 350 6825 Maint & Repair I Vehicle 12,264 12,864 12,500 12,500 12,500 6835 Maint & Repair/Equipment 13,297 16,974 13,000 13,000 13,000 6915 Utilities/Telephones 4,854 6,393 7,000 7,000 7,000 Subtotal 68,553 64,469 69,799 68,250 69,750 (49) 307 BUDGET UNIT: ALL FUND 31 DIVISIONS -CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 3140711903 Customer Records & Collections 6201 Uniforms & Laundry 7,985 8,028 10,000 10,000 10,000 6235 Meetings & Conferences 1,641 506 4,000 4,000 4,000 6240 Mileage Reimb 118 6399 Professional Services 50,000 50,000 6415 Computer Software Services 102,824 141,992 174,253 180,000 180,000 5,747 6493 Outside Services & Repairs 149,728 127,421 182,667 183,000 183,000 333 6518 Postage 108,548 115,927 135,000 135,000 135,000 6521 Messenger Service 226 25 100 (100) 6530 Office Supplies 6,741 8,679 10,000 10,000 10,000 6539 Printing, Binding & Duplicating 1,791 1,134 2,000 500 1,500 (500) 6563 Supplies/Special 1,969 1,251 1,500 500 1,500 6569 Small Equipment 1,444 558 2,000 1,500 2,000 6572 Office Furniture & Equipment 324 1,000 1,000 1,000 6670 IT Allocation 349,785 620,173 598,410 598,410 627, 162 28,752 6835 Maint & Repair/Equipment 398 410 3,000 3,000 1,000 (2,000) 6915 Utilities/Teleehone 33,668 42,476 62,000 62,000 62,000 Subtotal 766,748 1,069,024 1,185,930 1,188,910 1,268,162 82,232 3140711920 Employee Related 6210 Employee Awards 100 6220 Training Schools 195 1, 101 1,200 1,200 6235 Meetings & Conferences 1,608 3,000 3,000 3,000 3,000 6563 Supplies/Special 29 6564 Supplies/Medical-Dental 305 389 800 800 800 6850 Lease Pa ments 2,890 3,400 2,600 (3,400) Subtotal 2,237 8,510 8,500 6,500 5,100 (3,400) OPERATIONS SUBTOTAL 2,567,522 3,196,378 3,655,094 3,638,713 2,808,752 (846,342) 308 BUDGET UNIT: ALL FUND 31 DIVISIONS -CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE CAPITAL OUTLAY Consumer Services Administrative 7140 Equip & Machiner 4,360 Subtotal 4,360 3140711902 Field Services 7140 Eguiement & Machine!}'. 10,650 Subtotal 10,650 Customer Records & Collection 7140 Equipment & Machinery 67,540 67,540 1,819 (65,721) 7142 Computer Equipment 49,340 49,340 (49,340) 7150 Office Furniture & Eguiement 14,452 14,452 Subtotal 116,880 116,880 16,271 (100,609) 3140702920 Utility Administration 7142 Computer Equie 52,145 7,800 7,800 (7,800} Subtotal 52,145 7,800 7,800 (7,800) 3140702927 Utilities -Administration 7142 Computer Equip 17,726 7150 Office Furniture 9,943 Subtotal 27,669 CAPITAL SUBTOTAL 4,360 90,465 124,680 124,680 16,271 (108,409) TRANSFERS OUT 3110130000 Promotion/Membership 5950 Transfers Out 69,327 Subtotal 69,327 3140711903 Customer Records and Collections 5950 Transfers Out 7,528 8,380 8,380 8,380 10,630 2,250 Subtotal 7,528 8,380 8,380 8,380 10,630 2,250 309 BUDGET UNIT: ALL FUND 31 DIVISIONS -CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 3140711920 Employee Related Expenses 5950 Transfers Out 600,259 420,410 539,975 539,975 512,546 (27,429) Subtotal 600,259 420,410 539,975 539,975 512,546 (27,429) TRANSFERS OUT SUBTOTAL 677,114 428,790 548,355 548,355 523,176 (25,179) CONSUMER SERVICE FUND TOTAL: 6,356,540 6,878,852 7,801,153 7,322,300 7,115,499 (685,654) 310 Budget Division: LIGHT AND WATER - CONSUMER SERVICES-ADMINISTRATION FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 Adopted Adopted Adopted Adopted Adopted Adopted Adopted Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Director of Utilities(a) 0.95 0.95 188,880$ 179,885$ Utility Admin & Financial Svcs Mgr(b)1.00 0.95 106,020 92,260 Senior Management Analyst 1.00 1.00 82,750 84,160 Senior Administrative Technician 1.00 1.00 56,780 57,350 City Manager(c)0.30 0.30 59,550 59,550 Util Comm. & Enviro Specialist(d)0.60 0.60 44,390 50,115 Utility Financial/Accounting Analyst 0.00 1.00 - 65,405 (a) .05 FTE Public Benefit (b) .05 FTE Public Benefit (c) .30 FTE Solid Waste, .40 City Mgr. Admin (d) .40 FTE Solid Waste TOTAL 4.85 5.80 $538,370 $588,725 TOTAL - - - - Full Time Positions Part Time Positions 311 Budget Division: LIGHT AND WATER - CONSUMER SERVICES-CUSTOMER CARE FIELD SRV FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 Adopted Adopted Adopted Adopted Adopted Adopted Adopted Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Field Services Representative 2.00 2.00 $142,670 151,080 Drought Tech 5,000 1,830 $104,865 20,030 Field Services Supervisor 1.00 1.00 76,195 82,030 Meter Reader 4,368 1,664 118,745 31,360 Meter Reader 4.00 6.00 263,170 398,670 Water Education Specialist 0 1,560 - 32,945 TOTAL 7.00 9.00 $482,035 $631,780 TOTAL 9,368 5,054 $223,610 $84,335 Full Time Positions Part Time Positions 312 Budget Division: LIGHT AND WATER - CONSUMER SERVICES-CUST. CARE RECS & COLL. FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 Adopted Adopted Adopted Adopted Adopted Adopted Adopted Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Customer Care Operations Supervisor 1.00 1.00 $42,270 $86,955 Cashiers 4,600 2,496 $57,825 $26,045 Customer Services Representative III (a)9.70 9.70 624,195 650,520 Cust Srv Rep I 2,000 1,664 40,995 27,470 Customer Care Lead 1.00 1.00 65,420 66,575 Utilities Systems Analyst 1.00 1.00 74,085 64,895 Cashier 0.00 1.00 0 29,405 (a) .30 FTE Public Benefit TOTAL 12.70 13.70 $805,970 $898,350 TOTAL 6,600 4,160 $98,820 $53,515 Full Time Positions Part Time Positions 313 Budget Division: LIGHT AND WATER - CONSUMER SERVICES-CUST. CARE EMPLOYEE EXP. FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 Adopted Adopted Adopted Adopted Adopted Adopted Adopted Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Asst Director-Cust Care and Solutions(a)0.95 1.00 $131,230 $139,460 TOTAL 0.95 1.00 $131,230 $139,460 TOTAL - - - - Full Time Positions Part Time Positions 314 PROGRAM DESCRIPTION: LIGHT AND WATER WATER UTILITY PROGRAM COMMENTARY Water Utility is the division of Light and Water that is responsible for supplying reliable, high quality drinking water to approximately 110,000 customers in Azusa and portions of Glendora, Covina, West Covina, Irwindale, and Los Angeles County. Production of water comes from groundwater wells, surface water treatment, and the purchase of treated and untreated imported water. Water is transmitted through 281 miles of pipeline to business, industrial, and residential customers. The Water Utility is composed of three Sections: Production, Distribution, and Administration. The Production Section of the Water Utility operates a 12 million gallon per day (MGD) advanced membrane filtration plant treating naturally occurring and imported water from the San Gabriel River. This section operates and maintains 11 groundwater wells, 13 reservoirs, 9 booster stations, and 15 pressure regulating stations in 10 pressure zones. The Production Section consistently meets or exceeds water quality regulations, collecting and testing over 200 samples each month with an outside certified laboratory. The Distribution Section of the Water Utility operates, maintains, and repairs over 280 miles of water pipeline from 2 to 36 inches. This section maintains several thousand valves and over 2,400 fire hydrants. The Administration Section includes division management, support staff, and water engineering. Water Engineering provides technical and civil engineering support to the Division. They are responsible for the Capital Improvement Program (CIP), project management, as well as material specification and design review. Engineering issues conditions of approval for all development projects, conducts plan checks, and determines utility related fees for services requested by customers. In addition, Engineering develops technical documents including staff reports, memos, requests for proposals, and contracts. The Water Utility, as a team, works continuously to achieve its mission of providing reliable, high quality water to its customers. FY 17-18 STRATEGIC GOALS: •Meet or exceed all regulatory requirements for safety, water quality, and water supply •Provide reliable service and aesthetically pleasing water to all customers •Maintain high customer service standards and increase positive relationships with the public •Investigate and implement treatment options for new water supply sources •Increase the use of asset management and GIS programs to efficiently operate the water system •Continue to educate customers on Azusa's local hydrology and the need for continued conservation •Ensure water revenues are adequate for maintaining required debt coverage •Continue investing in the Capital Improvement Program to maintain water facilities and provide for future demand •Construct the Ditch Gate and River gate Improvement Projects in conjunction with the San Gabriel River Water Committee 315 FY 16-17 PROGRAM HIGHLIGHTS: •Achieved State mandated water conservation savings. •Performed timely repairs of numerous main, service, and fire hydrant leaks. •Purchased a new backhoe for water construction and repairs •Created an interactive water system map in GIS that includes main lines, fire hydrants, reservoirs, booster pumps, and wells. •Implemented GIS in Sedaru with water modeling and fire flow test capabilities •Completed Supervisory Control and Data Acquisition (SCADA) system and radio network upgrades •Hired and oriented five new employees •Installed fire and domestic services for new residential and commercial developments including: William Homes, (2) McDonalds, Starbucks, Waba Grill, Five Guys, Hilton Hotel, and the aquatic center at Northview High School •Designed and managed construction of a 24-inch water main Blend Line to Heck Reservoir CIP project 316 BUDGET UNIT: DESCRIPTION Acct.# OPERATIONS 6231 Outside Assessments 6235 Meetings & Conferences 6340 Special Studies 6493 Outside Services & Repairs 6563 Supplies/Special 6593 Water Rights Adjudicated Assessments 6805 Maintenance/Land Improvements 6835 Main! & Repair/Equipment 6904 Utilities/Other 7005 Principal Payment CAPITAL OUTLAY 7135 Vehicles ALL FUND 32 DIVISIONS -WATER -BUDGET DETAIL VARIANCE REVISED 16-17 284,040 1,200 2,000 699,698 587,850 1,684,500 30,000 19,750 1,000,000 1,885,000 107.722 YEAR END EST 16-17 260,000 2,416 2,000 228,750 256,461 1,639,766 20,840 14,200 1, 164,098 1,885,000 74,000 ADOPTED 17-18 396,000 6,000 24,500 703,200 661,350 2,375,000 60,000 22,750 1,200,000 1,940,000 134,165 VARIANCE Explanation 111,960 Increase due to new fee schedule from SWRCB for Water System and assessments from SGVWA. 4,800 Increase for professional development and industry conferences for Water Administration and Engineering including: Association of California Water Agencies Spring or Fall Conference ($699p/person p/conference ), American Water Works Association Spring or Fall Conference ($545p/person), Southern California Water Utilities Association ($25p/person p/session), and miscellanous training programs. 22,500 Increase due to Aspan Well Treatment Study 3,502 This account includes water quality sampling which has increased. 73,500 This account includes in-lieu power generation costs for San Gabriel Valley Municipal Water District. Variance is based on estimate from Power Resources. 690,500 FYl 7 estimated production = 17,534AF. Increased Watermaster Redevelopment Assessment from $20p/AF to $40p/AF. 30,000 Increase due to cost to rehab/demo house at 1700 Barranca 3,000 Increase due to cost and frequency of repairs to aging equipment 200,000 To bring inline with YTD Actuals 55,000 Per Debt Payment Schedule. 26,443 New Chevy Silverado 2500HD Work Truck with Utility Service Body to replace old vehicle; New Ford F-650 Dump Truck OAE to replace old vehicle. 317 LIGHT & WATER -WATER ACTIVITY DETAIL Account Number Description 3240721795 3240721795 3240722704 3240721791, 3240722701 3240722XXX, 3240723XXX 3240722704 3240721798 3240722704 3240722726 3240721530 6220 Training Schools -Safety and industry related training including: Federal and California Occupational Safety and Health Act, American Water Works Association, Operational Support Tools Hazardous Materials, and California Specialized Training Institute. 6230 Dues/Subscriptions -Includes: Building News International (Green Book), Engineering News Record, Urban Water Institute, Water Education Foundation, and Association of California Water Agencies. 6231 Outside Assessment -Assessments from outside agencies including: Water Quality Authority, San Gabriel River Water Committee, State Water Resources Control Board, and San Gabriel Valley Protective Association. 6235 6493 6563 6340 6593 6904 7001 Meetings/Conferences -Industry related meetings and conferences including: California Municipal Utilities Association, San Gabriel Valley Water Association, Association of California Water Agencies, and American Water Works Association. Outside Services & Repairs -Contract civil engineering design and construction vendors necessary to repair and replace water production and distribution system facilities and equipment. Includes laboratory costs for water quality sampling. Supplies/Special -Includes San Gabriel Valley Municipal Water District in-lieu power generation costs. Special Studies -Outside consultant fees for water treatment feasibility study at Well 10. Water Rights Adjudicated Assessments -Assessments associated with Main San Gabriel Basin Watermaster. Utilities/Other -Increased volume and cost of fuel for Water Division vehicles. 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. 318 BUDGET UNIT: ALL FUND 32 DIVISIONS -WATER (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED 14-15 15-16 16-17 16-17 17-18 VARIANCE PERSONNEL 6003 Salaries/Regular 1,848,070 1,485,989 1,951,435 1,346,407 2,087,540 136, 105 6006 Salaries/Part-Time 1,736 6030 Overtime Pay/Regular 6,783 7,199 9,000 9,157 9,000 6033 Overtime Pay/Premium 128, 111 96,786 100,000 123,305 100,000 6039 Standby Pay/Premium 62,017 59,501 75,000 60,764 75,000 6045 Salaries/Education Incentive 16,375 16,750 13,627 6048 Salaries/Language Pay 12,334 13,270 13,200 14,648 13,200 6063 Salaries/Jury Duty 1,580 2,096 2,582 6072 Salaries/Injury 404 2,160 6075 Vacation Pay-Off 64,245 140,034 89,214 6078 Sick Leave Pay-Off 5,126 8,172 4,289 6091 Leave Liability Adjustments 42,439 (110,902) 6101 PERS/Employee Contribution 129,454 128,239 138,205 106, 131 147,725 9,520 6105 PERS/Employer Contribution 174,764 149,990 207,770 202,231 284,620 76,850 6109 PARS/Employer Contribution 68,616 125,239 116,960 77,786 96,770 (20, 190) 6125 FICNEmployer Contrib/Med 33,706 33,739 35,500 28,541 37,440 1,940 6133 Retiree Health Premium Reimb 15,254 15,741 16,200 16,200 16,690 490 6140 Life Insurance Allocation 4,705 4,502 5,235 3,759 5,590 355 6155 Workers' Comp Allocation 79,871 77,370 78,580 68,768 84,035 5,455 6160 LTD Insurance Allocation 14,133 13, 144 15, 190 10,274 16,245 1,055 6165 Unemployment Allocation 2,176 2,175 2,445 1,853 2,565 120 6175 Benefits/Flex Plan 437,573 451,718 483, 135 483, 135 481,385 (1,750) 6180 Deferred Comp/Emploter Paid 2,970 2,916 7,380 3,578 7,380 PERSONNEL SUBTOTAL 3,152,441 3,040,900 3,255,235 2,891,887 3,465,185 209,950 319 BUDGET UNIT: ALL FUND 32 DIVISIONS -WATER (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE OPERATIONS 6201 Uniforms & Laundry 16,763 12,538 25,000 12,000 25,000 6215 Tuition Reimbursement 5,280 4,152 1,905 6220 Training Schools 5,083 9,771 5,500 2,203 5,500 6230 Dues & Subscriptions 25,363 36,880 31,750 31,720 31,750 6231 Outside Assessments 242,203 262,929 284,040 260,000 396,000 111,960 6235 Meetings & Conferences 598 1, 112 1,200 2,416 6,000 4,800 6253 Licenses/Certifications 551 1,892 3,750 1, 105 3,750 6301 Legal Fees 25,499 16,065 57,500 76,000 57,500 6320 Fiscal Agent Fees 1,500 1,500 3,000 3,000 3,000 6340 Special Studies 73,953 2,000 2,000 24,500 22,500 6345 Program Consultants 8,875 5,000 2,600 5,000 6399 Professional Services 40,799 32,372 58,360 52,000 50,000 (8,360) 6424 Consumer Services Allocation 4,072,337 4,388,600 4,804,833 4,804,833 4,211,493 (593,340) 6430 Custodial Services 5,800 8,057 12,400 2,900 12,400 6493 Outside Services & Repairs 447,965 472,608 699,698 228,750 703,200 3,502 6518 Postage 100 100 6521 Messenger Service 882 2,237 2,900 1,060 1,250 (1,650) 6527 Supplies/Computer 9,000 9,000 9,000 6530 Office Supplies 3,471 5,342 6,250 4,850 6,250 6539 Printing, Binding & Duplicating 223 1,694 1,700 1,545 1,700 6551 Fuel and Oil 61,572 43,094 60,000 45,000 60,000 6554 Supplies/Custodial 1,959 1,226 2,750 1, 186 2,750 6560 Repair Parts 32,489 6,446 32,300 19,631 32,300 6563 Supplies/Special 2,038,871 2, 124, 177 587,850 256,461 661,350 73,500 6564 Supplies/Medical-Dental 1,210 2,864 1,500 1,009. 1,500 6566 Small Tools 4,995 5,477 7,250 2,485 7,250 6569 Small Equipment 17,619 62,454 66,500 19,982 66,500 6572 Office Furniture & Equipment 1,350 1,500 1,350 6591 Water for Resale 2,019,000 82,976 165,960 205,721 133,294 (32,666) 6593 Water Rights Adjudicated Assessment 1,684,500 1,639,766 2,375,000 690,500 6601 Advertising Expense 583 800 1,000 600 1,000 6605 Filing Costs 975 315 10,000 600 10,000 6610 Bond Administration 1,750 1,750 2,250 6,250 2,250 320 BUDGET UNIT: ALL FUND 32 DIVISIONS -WATER (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 6633 Water Conservation Program 151,220 63,916 300,000 300,000 225,000 (75,000) 6801 RenULand 2,610 5,220 6,000 4,440 6,000 6805 Maintenance/Land Improvements 31,430 29,639 30,000 20,840 60,000 30,000 6815 Maint & Repairs/Bldgs 9,605 4,617 34,100 5,900 34,100 6825 Maintenance Repair Vehicle 46,547 40,223 35,500 20,100 35,500 6827 Garage Allocation 3,000 (3,000) 6830 RenUEquipment 1,381 1, 117 2,750 500 2,750 6835 Maint & Repair/Equipment 15,005 21,847 19,750 14,200 22,750 3,000 6850 Lease Payments 4,365 3,993 4,760 4,760 10,553 5,793 6904 Utilities/Other 1, 109,347 948,995 1,000,000 1,164,098 1,200,000 200,000 6905 Utilities/Electricity 10,776 7,413 15,000 12,000 15,000 6910 Utilities/Natural Gas 992 917 1,000 700 1,000 6915 Utilities/Telephone 11,518 12,951 13,000 11,660 13,000 7001 Interest Expense 2,871,805 1,862,756 2,210,265 2,210,265 2,146,963 (63,302) 7005 Principal Payment 1,780,000 1,885,000 1,885,000 1,940,000 55,000 7010 Franchise Fee (2%) 359,080 324,737 299,095 299,095 381, 151 82,056 7013 Water Rights Lease Expense 1,495,356 1,496,845 1,526,333 1,526,333 1,558,538 32,205 7015 Tax/Property 2,480 2,407 3,000 3,000 3,000 7055 Uncollectible Accounts 35,856 36,777 55,000 36,000 36,000 (19,000! OPERATIONS SUBTOTAL 17,165,279 12,536,527 16,080,744 15,218,968 17,404,032 1,323,287 CAPITAL OUTLAY 7130 Structures/Other 52,050 14,913 0 (0) 7135 Structures/Other (38,314) 107,722 74,000 134, 165 26,443 7140 Vehicles 192, 150 190,000 (192,150) 7145 Computer Eguiement {27,000! 79,481 CAPITAL OUTLAY SUBTOTAL 25,050 56,080 299,872 264,000 134,165 (165,707) TRANSFERS OUT 5950 Transfer Out {150,416} 352,186 190,000 190,000 249,960 59,960 TRANSFERS OUT SUBTOTAL (150,416) 352,186 190,000 190,000 249,960 59,960 WATER FUND TOTAL: 20,192,355 15,985,692 19,825,852 18,564,856 21,253,342 1,427,490 321 Budget Division: LIGHT AND WATER - WATER (ALL) FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 Adopted Adopted Adopted Adopted Adopted Adopted Adopted Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Assistant Director-Water Operations 1.00 1.00 $135,110 $119,830 Water System Engineer 1.00 1.00 98,745 105,890 Engineer Associate 1.00 1.00 85,900 61,290 Office Specialist II (a)1.00 1.00 35,280 38,675 Utility Programs Specialist(a)0.30 0.30 29,480 29,245 Water Production Supervisor 1.00 1.00 106,600 93,935 Water Production Operator III 4.00 4.00 312,280 318,625 Water Production Operator II 1.00 1.00 71,700 77,065 Water Production Operator I 1.00 1.00 65,240 59,780 Water Distribution Supervisor 1.00 1.00 106,600 112,890 Water Distribution Crew Supervisor 2.00 2.00 161,605 171,235 Water Distribution Services Specialist 1.00 1.00 78,665 69,170 Water Distribution Equipment Operator 2.00 2.00 135,175 145,565 Water Distribution Worker III 3.00 3.00 221,280 234,840 Water Distribution Worker II 1.00 0.00 65,240 0 Water Distribution Worker I 3.00 4.00 30,840 228,250 Welder/Water Dist Worker I 2.00 2.00 147,780 156,700 Water System Administrator 1.00 1.00 63,915 64,555 (a) .70 FTE Public Benefits TOTAL 27.30 27.30 $1,951,435 $2,087,540 TOTAL - - - - Full Time Positions Part Time Positions 322 BUDGET UNIT: ALL FUND 32 DIVISIONS -WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE PERSONNEL 3240721790 City Water 6003 Salaries/Regular 237,900 144,838 384,515 212,271 354,930 (29,585) 6006 Salaries/Part-Time 1,736 6045 Salaries/Education Incentive 1,897 1,396 1,774 6048 Salaries/Language Pay 306 2,240 2,400 2,400 6091 Leave Liability Adjustments 42,439 (110,902) 6101 PERS/Employee Contribution 18,048 15,569 27,035 13,641 25,130 (1,905) 6105 PERS/Employer Contribution 24,751 26,801 40,645 26,234 46,515 5,870 6109 PARS/Employer Contribution 12,687 11,206 26,255 12,682 13,470 (12,785) 6125 FICA/Employer Contrib/Med 4,512 4,403 6,585 3,776 6,165 (420) 6133 Retiree Health Premium Reimb 15,254 15,741 16,200 16,200 16,690 490 6140 Life Insurance Allocation 672 532 1,030 556 955 (75) 6155 Workers' Comp Allocation 10,867 8,715 15,380 9,520 14,295 (1,085) 6160 LTD Insurance Allocation 2,024 1,566 2,995 1,581 2,760 (235) 6165 Unemployment Allocation 257 258 450 222 420 (30) 6175 Benefits/Flex Plan 45,277 38,644 69,445 69,445 67,695 (1,750) 6180 Deferred Come/Emelo er Paid 2,970 2,916 5,220 3,578 5,220 Subtotal 451,568 287,966 595,755 397,670 556,645 (39, 110) 323 BUDGET UNIT: ALL FUND 32 DIVISIONS -WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 3240722700 Production -Source of Supply 6003 Salaries/Regular 528,930 537,778 619,735 431,067 613,960 (5,775) 6012 Salaries/Comp-Time 25,975 18,471 11,539 6015 SalariesNacation 20, 127 27,873 14,801 6024 Salaries/Sick Leave 11,303 23,926 40,990 6027 Salaries/Bereavement 1,950 1,356 2,598 6030 Overtime Pay/Regular 3,117 1,842 5,000 1,797 5,000 6033 Overtime Pay/Premium 14,382 13,750 20,000 22,975 20,000 6039 Standby Pay/Premium 32,877 28,366 40,000 25,690 40,000 6045 Salaries/Education Incentive 7,562 7,682 6,204 6048 Salaries/Language Pay 4,742 6,029 6,000 5,640 3,600 (2,400) 6101 PERS/Employee Contribution 42,412 45,578 44,000 36,149 43,430 (570) 6105 PERS/Employer Contribution 56,528 76,375 66,135 67,333 84,325 18, 190 6109 PARS/Employer Contribution 20,814 30,685 39,185 24,700 31,865 (7,320) 6125 FICA/Employer Contrib/Med 11,415 12,234 11, 145 9,522 11,025 (120) 6140 Life Insurance Allocation 1,503 1,533 1,665 1,202 1,640 (25) 6155 Workers' Comp Allocation 25,328 26,164 25,030 21,786 24,700 (330) 6160 LTD Insurance Allocation 4,475 4,439 4,825 3,095 4,775 (50) 6165 Unemployment Allocation 710 760 770 560 765 (5) 6175 Benefits/Flex Plan 136,976 150,830 142,640 142,640 142,640 6180 Deferred Come/Emelo er Paid 2,160 2,160 Subtotal 985,879 1,080,895 1,028,290 889, 182 1,029,885 1,595 3240723750 Transmission/Distribution 6003 Salaries/Regular 849,884 803,372 947,185 703,070 1,118,650 171,465 6030 Overtime Pay/Regular 3,666 5,357 4,000 7,360 4,000 6033 Overtime Pay/Premium 111, 775 81, 147 80,000 99,819 80,000 6039 Standby Pay/Premium 29, 140 31, 136 35,000 35,075 35,000 6045 Salaries/Education Incentive 6,916 7,672 5,649 6048 Salaries/Language Pay 7,286 7,241 7,200 6,768 7,200 6063 Salaries/Jury Duty 975 1,390 1,283 6072 Salaries/Injury 404 691 6075 Vacation Pay-Off 29,794 26, 160 69,577 6078 Sick Leave Pay-Off 1,646 652 4,289 6101 PERS/Employee Contribution 68,995 67,092 67,170 56,341 79, 165 11,995 324 BUDGET UNIT: ALL FUND 32 DIVISIONS -WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED 14-15 15-16 16-17 16-17 17-18 VARIANCE 6105 PERS/Employer Contribution 93,485 46,814 100,990 108,664 153,780 52,790 6109 PARS/Employer Contribution 35, 116 83,348 51,520 40,404 51,435 (85) 6125 FICA/Employer Contrib/Med 17,779 17, 102 17,770 15,242 20,250 2,480 6140 Life Insurance Allocation 2,531 2,436 2,540 2,002 2,995 455 6155 Workers' Comp Allocation 43,676 42,490 38, 170 37,462 45,040 6,870 6160 LTD Insurance Allocation 7,634 7,138 7,370 5,597 8,710 1,340 6165 Unemployment Allocation 1,209 1, 157 1,225 1,070 1,380 155 6175 Benefits/Flex Plan 255,320 262,245 271,050 271,050 271,050 Subtotal 1,714,994 1,672,038 1,631,190 1,605,036 1,878,655 247,465 PERSONNEL SUBTOTAL 3,152,441 3,040,900 3,255,235 2,891,887 3,465,185 209,950 325 BUDGET UNIT: DESCRIPTION Acct.# 3240721507 Taxes 7010 Franchise Fee (2%) 7015 Tax/Proeertz'. Subtotal 3240721530 Interest Expense 7001 Interest Exeense Subtotal 3240721530 Principal Expense 7005 Princieal Exeense Subtotal 3240721790 Administrative & General 6230 Dues & Subscript 6320 Fiscal Agent Fees 6325 Appraisal Fees 6399 Professional Services/Other 6423 Administrative Allocation 6424 Consumer Services Allocation 6601 Advertising Expense 6610 Bond Administration Subtotal 3240721791 Miscellaneous 6215 Tuition Reimbursement 6220 Training Schools 6230 Dues & Subscriptions 6235 Meetings & Conferences 6253 Licenses/Certifications 6530 Office Supplies 6539 Printing, Binding & Duplicating 6625 Program Expense ALL FUND 32 DIVISIONS -WATER (DETAILS) ACTUAL 14-15 359,080 2.480 361,560 2,871,805 2,871,805 1,780,000 1,780,000 705 1,500 40,799 4,072,337 583 1,750 4,117,675 2,640 2,453 3,705 598 31 150,564 ACTUAL 15-16 324,737 2,407 327, 144 1,862,756 1,862,756 1,500 32,372 4,388,600 800 1,750 4,425,022 4,152 7,155 18,078 1, 112 45 REVISED 16-17 299,095 3,000 302,095 2,210,265 2,210,265 1,885,000 1,885,000 3,000 58,360 4,804,833 1,000 2,250 4,869,443 3,000 6,000 1,000 250 YEAR END EST ADOPTED 16-17 17-18 VARIANCE 299,095 381,151 82,056 3,000 3,000 302,095 384, 151 82,056 2,210,265 2, 146,963 (63,302) 2,210,265 2, 146,963 (63,302) 1,885,000 1,940,000 55,000 1,885,000 1,940,000 55,000 3,000 3,000 52,000 50,000 (8,360) 804,790 804,790 4,804,833 4,211,493 (593,340) 600 1,000 6,250 2,250 4,866,683 5,072,533 203,090 1,905 283 3,000 6,000 6,000 2,216 5,000 4,000 105 250 45 326 BUDGET UNIT: ALL FUND 32 DIVISIONS -WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 6633 Water Conservation Program 151,220 63,916 300,000 300,000 225,000 (75,000) 7055 Uncollectible Accounts 35,856 36,777 55,000 36,000 36,000 (19,000) Subtotal 347,066 131,234 365,250 346,554 275,250 (90,000) 3240721792 Office Supplies & Other Expenses 6530 Office Supplies 21 793 100 50 100 6563 Supplies/Special 339 178 500 1,200 500 6915 Utilities/T eleehone 845 565 2,000 1,260 2,000 Subtotal 1,206 1,535 2,600 2,510 2,600 3240721795 Employee Related 6201 Uniforms & Laundry 16,763 12,538 25,000 12,000 25,000 6215 Tuition Reimbursement 2,640 6220 Training Schools 2,630 2,616 2,500 1,920 2,500 6230 Dues & Subscriptions 470 655 750 720 750 6253 Licenses/Certifications 551 1,892 3,500 1,000 3,500 6301 Legal Fees 595 7,500 7,500 6563 Supplies/Special 840 236 1,000 1,000 1,000 6564 Supplies/Medical-Dental 1,210 2,864 1,500 1,009 1,500 6825 Maintenance & RepairNehicle 500 100 500 6915 Util/Teleehone 210 (23 Subtotal 25,908 20,778 42,250 17,749 42,250 3240721798 Outside Services 6301 Legal Fees 24,904 16,065 50,000 76,000 50,000 6340 Special Studies 73,953 2,000 2,000 24,500 22,500 6345 Program Consultants 8,875 5,000 2,600 5,000 6493 Outside Services & Repairs 18,630 25,000 2,500 2,500 Subtotal 43,534 123,892 59,500 80,600 82,000 22,500 3240721903 Transportation 6493 Outside Services & Repairs 3,046 500 500 6551 Fuel and Oil 61,572 43,094 60,000 45,000 60,000 6560 Repair Parts 11 500 500 327 BUDGET UNIT: ALL FUND 32 DIVISIONS -WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 6563 Supplies/Special 215 500 158 500 6569 Small Equipment 25 500 500 6825 Maintenance & RepairNehicle 46,472 40,223 35,000 20,000 35,000 6827 Garage Allocation 3,000 (3,000) 6835 Maint & Repair/Equipment 3,747 2,000 1,700 2,000 6850 Lease Palments 4,365 3,993 4,760 4,760 10,553 5,793 Subtotal 112,409 94,354 106,760 71,618 109,553 2,793 3240722701 Production -Supervision & Engineering 6235 Meetings & Conferences 200 200 1,000 800 6493 Outside Services & Repairs 29,537 27, 168 20,000 27,000 30,000 10,000 6518 Postage 100 100 6521 Messenger Service 739 1,972 2,650 1,000 1,000 (1,650) 6527 Supplies/Computer/Small Equip 4,000 4,000 4,000 6530 Office Supplies 583 1,846 2,000 2,000 2,000 6539 Printing, Binding & Duplicating 223 1,649 1,500 1,500 1,500 6554 Supplies/Custodial & Cleaning 128 250 250 6563 Supplies/Special 233 487 650 650 6566 Small Tools 36 6569 Small Equipment 1,154 822 1,250 1,250 1,250 6572 Office Furniture & Equipment 1,000 1,000 1,000 6830 Rent/Equipment 161 148 500 500 500 6835 Maintenance and Repair/Equipment 250 250 6915 Utilities/Telephone 8,454 9,371 8,000 6,400 8,000 Subtotal 41,248 43,464 42,350 44,850 51,500 9,150 3240722704 Purchased Water 6230 Dues & Subscriptions 20,483 18, 147 25,000 25,000 25,000 6231 Outside Assessments 242,203 262,929 284,040 260,000 396,000 111,960 6493 Outside Services & Repairs 15,805 131,498 1,000 175,000 43,502 6591 Water for Resale 2,019,000 82,976 165,960 205,721 133,294 (32,666) 6563 Supplies/Special 1,363,648 1,675,072 1,500 50,000 100,000 98,500 7013 Water Rights Lease Expense 1,495,356 1,496,845 1,526,333 1,526,333 1,558,538 32,205 328 BUDGET UNIT: ALL FUND 32 DIVISIONS -WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED 14-15 15-16 16-17 16-17 17-18 VARIANCE 6593 Water Rights Adjudicated Assessments 1,684,500 1,639,766 2,375,000 690,500 Subtotal 5, 140,690 3,551,774 3,818,831 3,707,820 4,762,832 944,001 3240722707 Maintenance of Structures & Improvements 6493 Outside Services & Repairs 9,451 8,923 5,500 5,000 5,500 6554 Supplies/Custodial 500 500 500 6563 Supplies/Special 105 154 500 500 500 6569 Small Equipment 500 500 500 6805 Maintenance/Land Improvements 22,839 23,011 20,000 20,000 20,000 6815 Maint & Reeairs/Bldgs 20,000 5,000 20,000 Subtotal 32,394 32,088 47,000 31,500 47,000 3240722708 Maintenance of Reservoirs 6493 Outside Services & Repairs 14,425 8,465 24,000 5,000 19,000 (5,000) 6563 Sueelies/Seecial 408 1, 164 1,750 500 1,750 Subtotal 14,833 9,629 25,750 5,500 20,750 (5,000) 329 BUDGET UNIT: ALL FUND 32 DIVISIONS -WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 3240722711 Maintenance of Wells 6493 Outside Services & Repairs 30,769 24,842 75,000 20,000 50,000 (25,000) 6563 Supplies/Special 9,559 10,448 10,000 5,000 10,000 6569 Small Equiement 6,560 20,000 5,000 20,000 Subtotal 46,888 35,290 105,000 30,000 80,000 (25,000) 3240722726 Fuel or Power Purchase 6904 Utilities/Other 1,109,347 948,995 1,000,000 1, 164,098 1,200,000 200,000 6905 Utilities/Electricity 10,776 7,413 15,000 12,000 15,000 6910 Utilities/Natural Gas 992 917 1,000 700 1,000 Subtotal 1,121,115 957,326 1,016,000 1,176,798 1,216,000 200,000 3240722732 Maintenance of Pumps/Boosters 6493 Outside Services & Repairs 44,698 69,248 75,000 5,000 80,000 5,000 6560 Repair Parts 100 100 6563 Sueplies/Seecial 886 1,088 1,000 500 1,000 Subtotal 45,584 70,336 76, 100 5,500 81, 100 5,000 3240722744 Chemicals & Filtering Materials 6493 Outside Services & Repairs 5,000 5,000 6563 Sueelies/Special 294,870 165,579 250,000 150,000 225,000 (25,000) Subtotal 294,870 165,579 255,000 150,000 230,000 (25,000) 3240722747 Maintenance of Structure & Improvements (Filter Plant) 6430 Custodial Services 2,120 3,173 5,000 2,400 5,000 6493 Outside Services & Repairs 21,271 13,234 25,000 21,000 25,000 6530 Office Supplies 260 102 500 500 500 6554 Supplies/Custodial 498 587 1,000 500 1,000 6563 Supplies/Special 8,429 6,278 15,000 10,000 15,000 6815 Maint & Repairs/Bldgs 750 778 1,500 300 1,500 Subtotal 33,327 24,152 48,000 34,700 48,000 330 BUDGET UNIT: ALL FUND 32 DIVISIONS -WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 3240722748 Maintenance of Water Treatment Equipment 6493 Outside Services & Repairs 57,254 66,181 55,000 20,000 55,000 6563 Supplies/Special 21,663 16,307 25,000 11,000 25,000 6569 Small Equipment 3,125 1,237 10,000 3,000 10,000 Subtotal 82,042 83,724 90,000 34,000 90,000 3240723751 Supervision & Engineering 6521 Messenger Service 143 265 250 60 250 6527 Supplies/Computer 5,000 5,000 5,000 6530 Office Supplies 1,669 2,553 2,750 2,000 2,750 6539 Printing, Binding & Duplicating 200 200 6554 Supplies/Custodi 163 6563 Supplies/Special 26 2 200 100 200 6572 Office Furniture & Equipment 350 500 350 6815 Maint & Repairs/Bldgs 100 100 100 6830 Rent/Equipment 505 415 1,000 1,000 6915 Utilities/Teleehone 2,009 3,038 3,000 4,000 3,000 Subtotal 4,515 6,273 12,850 11,760 12,850 3240723752 Storage Facilities 6563 Supplies/Special 400 2,000 2,000 6830 Rent/Eguiement 715 554 1,250 1,250 Subtotal 1, 115 554 3,250 3,250 3240723753 Transmission & Distribution 6493 Outside Services & Repairs 500 500 6563 Sueelies/Seecial 1,979 2,973 500 500 Subtotal 1,979 2,973 1,000 1,000 3240723754 Meter 6493 Outside Services & Repairs 794 4,000 4,000 4,000 6563 Supplies/Special 84,354 27,682 50,000 8,655 50,000 6569 Small Equipment 1,067 54,874 30,000 10,000 30,000 Subtotal 86,215 82,556 84,000 22,655 84,000 331 BUDGET UNIT: ALL FUND 32 DIVISIONS-WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 3240723755 Customer Installation 6493 Outside Services & Repairs 271 1,200 1,200 6563 SueeliestSeecial 2,373 1,500 1,500 Subtotal 2,644 2,700 2,700 3240723759 Maintenance of Structures & Improvements 6430 Custodial Services 3,680 4,884 7,400 500 7,400 6493 Outside Services & Repairs 2,226 5,000 300 5,000 6530 Office Supplies 709 49 800 200 800 6554 Supplies/Custodial 1,001 639 1,000 186 1,000 6563 Supplies/Special 2,666 1,353 7,500 700 7,500 6805 Maintenance/Land Improvements 8,591 6,628 10,000 840 40,000 30,000 6815 Maint & Reeairs/Bldgs 8,855 3,839 12,500 500 12,500 Subtotal 25,502 19,618 44,200 3,226 74,200 30,000 3240723761 Maintenance of Transmission & Distribution Mains 6493 Outside Services & Repairs 207,970 196,456 250,000 120,000 225,000 (25,000) 6530 Office Supplies 199 100 100 100 6554 Supplies/Custodial 169 6560 Repair Parts 24,218 3,331 25,000 18,231 25,000 6563 Supplies/Special 221,552 191,320 200,000 15,000 200,000 6566 Small Tools 4,850 4,077 4,500 1,940 4,500 6569 Small Equipment 351 3,730 4,250 232 4,250 6605 Filing Costs 975 315 10,000 600 10,000 6801 Rent/Land 2,610 5,220 6,000 4,440 6,000 6825 Maintenance and RepairNehicle 75 6835 Maint & Reeair/Eguiement 14,963 16,636 15,000 12,000 18,000 3,000 Subtotal 477,932 421,085 514,850 172,543 492,850 (22,000) 332 BUDGET UNIT: ALL FUND 32 DIVISIONS -WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 3240723763 Maintenance of Services 6560 Repair Parts 1,840 607 1,500 200 1,500 6563 Supplies/Special 16,696 15,595 15,000 1,500 15,000 6566 Small Tools 60 809 1,750 300 1,750 6835 Maint & Repair/Equipment 42 771 2,500 500 2,500 Subtotal 18,638 17,783 20,750 2,500 20,750 3240723764 Maintenance of Meters 6493 Outside Services & Repairs 12,896 12,016 20,000 450 20,000 6560 Repair Parts 2,988 1,506 3,200 600 3,200 6563 Supplies/Special 4,211 1,690 1,750 250 1,750 6566 Small Tools 50 339 1,000 245 1,000 Subtotal 20, 145 15,551 25,950 1,545 25,950 3240723765 Maintenance of Hydrants 6560 Repair Parts 3,433 991 2,000 600 2,000 6563 Supplies/Special 1,960 2,000 398 2,000 Subtotal 3,433 2,951 4,000 998 4,000 3240723766 Maintenance of Miscellaneous Plants 6560 Repair Parts 10 6563 Supplies/Special 3,636 4,395 6566 Small Tools 251 6569 Small Equipment 5,360 1,767 6835 Maint & Reeair/Equipment 693 Subtotal 9,007 7,106 OPERATIONS SUBTOTAL 17,165,279 12,536,527 16,080,744 15,218,968 17,404,032 1,323,287 333 BUDGET UNIT: ALL FUND 32 DIVISIONS -WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED 14-15 15-16 16-17 16-17 17-18 VARIANCE CAPITAL OUTLAY 3200000000 City Water 7135 Vehicles (60,647) 7,055 (7,055) 7145 Lines, Mains&Swr {793,310} {41,630) Subtotal (793,310) (102,277) 7,055 (7,055) 3240721903 Transportation 7135 Vehicles 27,250 (27,250) Subtotal 27,250 (27,250) 3240722700 Production/Source of Supply 7135 Vehicles 22,333 73,417 74,000 36,290 (37, 127} Subtotal 22,333 73,417 74,000 36,290 (37, 127) 3240723751 Supervision & Engineering 7135 Vehicles 97,875 97,875 Subtotal 97,875 97,875 3240723761 Maintenance of Transmission & Distribution Mains 7135 7140 Office Furniture & Equipment 192,150 190,000 192,150) Subtotal 192,150 190,000 (192,150) 3280000721 CIP/Water 7130 Structures/Other 52,050 14,913 0 (0) 7145 Lines, Mains&Swr 766,310 121,111 Subtotal 818,360 136,024 0 (0) CAPITAL OUTLAY SUBTOTAL 25,050 56,080 299,872 264,000 134,165 (165,707) 334 BUDGET UNIT: ALL FUND 32 DIVISIONS -WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE TRANSFERS OUT 3200000000 General 5950 Transfer Out (150,416) 352, 186 190,000 190,000 249,960 59,960 Subtotal (150,416) 352, 186 190,000 190,000 249,960 59,960 TRANSFERS OUT SUBTOTAL (150,416) 352,186 190,000 190,000 249,960 59,960 WATER FUND TOTAL: 20,192,355 15,985,692 19,825,852 18,564,856 21,253,342 1,427,490 335 Budget Division: LIGHT AND WATER - WATER-CITY FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 Adopted Adopted Adopted Adopted Adopted Adopted Adopted Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Assistant Director-Water Operations 1.00 1.00 $135,110 $119,830 Water System Engineer 1.00 1.00 98,745 105,890 Engineer Associate 1.00 1.00 85,900 61,290 Office Specialist II (a)1.00 1.00 35,280 38,675 Utility Programs Specialist(b)0.30 0.30 29,480 29,245 (a) Underfilled as an Office Specialist I for FY1718 (b) .70 FTE Public Benefits TOTAL 4.30 4.30 $384,515 $354,930 TOTAL - - - - Full Time Positions Part Time Positions 336 Budget Division: LIGHT AND WATER - WATER SOURCE OF SUPPLY FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 Adopted Adopted Adopted Adopted Adopted Adopted Adopted Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Water Production Supervisor 1.00 1.00 $106,600 $93,935 Water Production Operator III 4.00 4.00 312,280 318,625 Water Production Operator II 1.00 1.00 71,700 77,065 Water Production Operator I 1.00 1.00 65,240 59,780 Water System Administrator 1.00 1.00 63,915 64,555 TOTAL 8.00 8.00 $619,735 $613,960 TOTAL - - - - Full Time Positions Part Time Positions 337 Budget Division: LIGHT AND WATER - WATER TRANSMISSION & DISTRIBUTION FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 Adopted Adopted Adopted Adopted Adopted Adopted Adopted Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Water Distribution Supervisor 1.00 1.00 $106,600 $112,890 Water Distribution Crew Supervisor 2.00 2.00 161,605 171,235 Water Distribution Services Specialist 1.00 1.00 78,665 69,170 Water Distribution Equipment Operator 2.00 2.00 135,175 145,565 Water Distribution Worker III 3.00 3.00 221,280 234,840 Water Distribution Worker II 1.00 0.00 65,240 0 Water Distribution Worker I 3.00 4.00 30,840 228,250 Welder/Water Dist Worker I 2.00 2.00 147,780 156,700 TOTAL 15.00 15.00 $947,185 $1,118,650 TOTAL - - - - Full Time Positions Part Time Positions 338 PROGRAM DESCRIPTION: LIGHT AND WATER ELECTRIC UTILITY PROGRAM COMMENTARY 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 17 4 Rules for Electric utility Substations. 339 FY 2017-18 STRATEGIC GOALS: •Start the planning, design and construction of recommended substation capacity improvements •Complete RP3 renewal application and obtain Reliable Public Power Provider designation from APPA •Implement a Pilot Project to deploy limited number of AMI remote disconnect residential electric meters •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 •Start identifying, and if economic contract, renewable energy to replace San Juan power post 2020 and meet the 50%-by-2030 RPS requirement •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 electric Cost of Service & Rates study and publish new electric rates •Undertake study and evaluate economic feasibility of energy storage at Kirkwall FY 2016-17 PROGRAM HIGHLIGHTS: •Completed urgent underground cable repairs at various locations within City •Obtained APPA Certificate of Excellence in Reliability (2016) •Completed safety inspections of various utility lines and equipment using infrared scan and ultrasound •Installed Level 2 dual ports EV charging stations at Azusa Parking Structure I Gold Line Train Station •Completed multiple joint pole replacements with Edison at various locations within City •Met compliance standards for safety regulations reporting requirements -SF6 •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. •Completed 20-year Integrated Resource Plan (IRP) Achieved NERC Reliability Standards compliance •Achieved SBX1 2 (Renewable Portfolio Standard) compliance (20% RPS) •Achieved AB32 (Greenhouse gas/cap-and-trade) compliance •Finalized SO-year Hoover power replacement/extension contract (years 2017 -2067) 340 BUDGET UNIT: DESCRIPTION OPERATING 6230 Dues & Subscriptions 6240 Mileage Reimbursement 6340 Special Studies 6399 Professional Services/Other 6521 Messenger Service 6850 Lease Payments 7005 Principal Payment ALL FUND 33 DIVISIONS -ELECTRIC-BUDGET DETAIL VARIANCE REVISED 16-17 23,000 100 105,000 19,447 - 3,400 650,000 YEAR END EST ADOPTED 16-17 17-18 45,000 45,000 100 900 105,000 140,000 22,000 27,000 200 500 3,500 10,500 650,000 780,000 VARIANCE Explanation 22,000 Increase due to APPA Annual Dues and CMUA. 800 Increase due to local/airport business travel. 35,000 Increase due to Electric Rates study and Energy Storage study. 7,553 Increase due to FARECal Acctg Svcs, Auditing Svcs, & Close Out. 500 Increase for mailings to Sacramento due to frequency of regulatory reporting. 7, 100 Increase due to Electric Vehicle Lease. 130,000 Increase per Debt Payment Schedule. 341 LIGHT & WATER -ELECTRIC ACTIVITY DETAIL Account Number Description 3340733xxx, 3340735xxx, 33407 45xxx, 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. ISO cont. 6340 Special Studies -Update of distribution system and integrated resources plans, reliability and energy storage studies, and GO 165 pole load recalculations; Electric Rates study and Energy Storage study. 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. 342 BUDGET UNIT: ALL FUND 33 DIVISIONS -ELECTRIC (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE PERSONNEL 6003 Salaries/Regular 2,092,732 1,707,808 2,382,435 1,650,481 2,662,645 280,210 6012 Salaries/Comp-Time 43,995 58,809 75,396 6015 Salaries/Vacation 94,199 50, 167 55,779 6024 Salaries/Sick Leave 134,825 66,704 46,924 6027 Salaries/Bereavement 1,430 2,810 6030 Overtime Pay/Regular 29,747 25,808 20,000 40,376 20,000 6033 Overtime Pay/Premium 120,253 215,592 130,000 122,032 130,000 6039 Standby Pay/Premium 35,732 29,913 40,000 28,952 40,000 6045 Salaries/Education Incentive 7,947 7,954 7,434 6048 Salaries/Language Pay 9,952 8,449 8,400 8,216 10,800 2,400 6063 Salaries/Jury Duty 7,234 8,724 2,757 6072 Salaries/Injury 2,406 9,136 6075 Vacation Pay-Off 88,870 117,758 42,275 6078 Sick Leave Pay-Off 7,869 5,921 6101 PERS/Employee Contribution 141,044 129,498 168,215 119,183 188,005 19,790 6105 PERS/Employer Contribution 193,082 154,310 252,865 237,459 365,235 112,370 6109 PARS/Employer Contribution 91,902 172,274 161,775 121,183 148,680 (13,095) 6125 FICA/Employer Contrib/Med 35,493 34,851 40,510 31,404 45, 115 4,605 6133 Retiree Health Premium Reimb 4,409 5,413 6,160 6,160 6,350 190 6140 Life Insurance Allocation 5,083 4,811 6,370 4,461 7,105 735 6155 Workers' Comp Allocation 89,228 84,738 95,645 81,059 106,950 11,305 6160 LTD Insurance Allocation 14,564 13,676 18,520 12, 125 20,705 2,185 6165 Unemployment Allocation 2,159 2,253 2,780 1,996 3, 110 330 6175 Benefits/Flex Plan 336,272 320,599 402, 170 276,845 438,310 36, 140 6180 Deferred Come/Emplo er Paid 7,920 9,281 11,340 8,406 11,340 PERSONNEL SUBTOTAL 3,304,305 3,247,255 3,747,185 2,980,904 4,204,350 457,165 343 BUDGET UNIT: ALL FUND 33 DIVISIONS -ELECTRIC (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED 14-15 15-16 16-17 16-17 17-18 VARIANCE OPERATIONS 6201 Uniforms & Laundry 25,627 28,217 30,000 30,000 30,000 6220 Training Schools 6,759 5,614 22,260 22,260 22,260 6225 Training Materials 132 1,000 1,000 1,000 6230 Dues & Subscriptions 23,125 23,467 23,000 45,000 45,000 22,000 6235 Meetings & Conferences 10,476 1,646 13,000 13,000 13,000 6240 Mileage Reimbursement 100 100 900 800 6301 Legal Fees 98,316 65, 102 222,500 152,500 152,500 (70,000) 6340 Special Studies 92,603 54, 156 105,000 105,000 140,000 35,000 6345 Program Consultants 2,487 2,490 5,000 5,000 5,000 6399 Professional Services/Other 43,944 29,802 19,447 22,000 27,000 7,553 6423 Administrative Allocation 667,015 667,015 6424 Consumer Services Allocation 2, 192,799 2,363,093 2,587,217 2,587,217 2,807,662 220,445 6430 Custodial Services 4,880 6,943 5,000 5,000 5,000 6493 Outside Services & Repairs 4,232,139 3,988,629 5,010,636 4,265,009 4,979,055 (31,581) 6518 Postage 200 (200) 6521 Messenger Service 639 555 200 500 500 6530 Office Supplies 3,319 6,364 4,100 4,100 4,100 6551 Fuel and Oil 51,373 37,790 25,000 25,000 25,000 6554 Supplies/Custodial & Cleaning 748 874 900 900 900 6563 Supplies/Special 17,442 21,358 35,000 35,000 35,000 6564 Supplies/Medical-Dental 1,006 1,985 1,500 1,500 1,500 6566 Small Tools 4,308 14,918 16,500 16,500 16,500 6569 Small Equipment 15,799 17, 142 19,000 19,000 19,000 6590 Electricity For Resale 28,834,815 25,726,445 25,800,285 24,653,010 17,459,287 (8,340,998) 6601 Advertising Expense 1,872 1,950 2,000 2,000 2,000 6610 Bond Administration 4,250 4,250 4,250 4,250 4,250 6625 Program Expenses 155,894 182,001 327,100 327,100 (327,100) 6805 Maint/Land Improvements 1,550 7,500 7,500 7,500 6815 Maint & Repairs/Bldgs 21,717 22,642 17,600 17,600 17,600 6825 Maint & Repair I Vehicle 36,465 14,952 36,000 36,000 36,000 6835 Maint & Repair/Equipment 854 2,015 8,500 8,500 8,500 6850 Lease Payments 2,795 3,378 3,400 3,500 10,500 7,100 6904 Utilities/Other 26,675 20,958 18,000 18,000 18,000 6905 Utilities I Electricity 10,208 9,748 10,000 10,000 10,000 344 BUDGET UNIT: ALL FUND 33 DIVISIONS -ELECTRIC (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 6910 Utilities/Natural Gas 442 688 700 700 700 6915 Utilities/Telephone 8,689 1,864 8,700 8,700 8,700 7001 Interest Expense 254,443 225,136 200,915 200,915 172,690 (28,225) 7005 Principal Payment 650,000 650,000 780,000 130,000 7010 Franchise Fee (2%) 780,399 731,136 757,765 757,765 685,858 (71,907) 7012 In-lieu Fee (8%) 3,121,597 2,924,543 3,031,055 3,031,055 2,743,432 (287,623) 7055 Uncollectible Accounts 56,636 56,476 80,000 65,000 65,000 {15,000) OPERATIONS SUBTOTAL 40,147,222 36,598,327 39,110,129 37,156,881 31,027,909 (8,082,220) CAPITAL OUTLAY 7130 Structures/Other 30,622 52,971 85,000 85,000 85,000 7140 Equipment & Machinery 269,857 250,177 475,000 475,000 475,000 7145 Lines, Mains & Sewers 315,135 318,748 330,000 330,000 330,000 CAPITAL OUTLAY SUBTOTAL 615,614 621,895 890,000 890,000 890,000 TRANSFERS OUT 5950 Transfer Out 95,050 136,762 116,615 116,615 225,565 108,950 TRANSFERS OUT SUBTOTAL 95,050 136,762 116,615 116,615 225,565 108,950 ELECTRIC FUND TOTAL: 44,162,190 40,604,240 43,863,929 41,144,399 36,347,824 (7,516,105) 345 Budget Division: LIGHT AND WATER - ELECTRIC (ALL) FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 Adopted Adopted Adopted Adopted Adopted Adopted Adopted Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Assistant Director-Electric Operations 1.00 1.00 $139,310 $140,660 Electric Distribution Supervisor 1.00 1.00 133,540 141,165 Electric Crew Supervisor 3.00 3.00 332,530 377,290 Line Mechanic 8.00 8.00 821,700 844,175 Line Mechanic Helper 1.00 1.00 62,090 67,130 Senior Electric Test Technician 1.00 1.00 104,275 110,420 Electrical Test Technician 1.00 1.00 79,205 83,790 Apprentice Elect Test Technician 1.00 1.00 80,420 85,235 Office Specialist II 1.00 1.00 26,560 41,390 Apprentice Line Mechanic 0.00 2.00 0 160,890 Senior Electrical Engineer 1.00 1.00 124,035 131,195 Electrical Engineer 1.00 1.00 98,675 94,655 Assistant Director-Resource Management 1.00 1.00 153,355 154,890 Power Resources Coordinator 1.00 1.00 120,375 121,550 Power Resources Scheduler 1.00 1.00 106,365 108,210 TOTAL 23.00 25.00 $2,382,435 $2,662,646 TOTAL - - - - Full Time Positions Part Time Positions 346 BUDGET UNIT: ALL FUND 33 DIVISIONS -ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED 14-15 15-16 16-17 16-17 17-18 VARIANCE PERSONNEL Distribution Operations-Supervision & Engineering 6003 Salaries/Regular 231,219 242,090 272,850 217,631 281,825 8,975 6045 Salaries/Education Incentive 2,062 2,064 1,929 6075 Vacation Pay-Off 29,930 13,656 6078 Sick Leave Pay-Off 2,531 2,368 6101 PERS/Employee Contribution 19,087 20, 143 19,145 18,927 19,775 630 6105 PERS/Employer Contribution 24,187 31,362 28,770 31,566 38,255 9,485 6109 PARS/Employer Contribution 15,936 22,470 21, 155 21,086 21,705 550 6125 FICA/Employer Contribution 2,595 2,425 4,455 2,202 4,585 130 6133 Retiree Health Premium Reimb 4,409 5,413 6,160 6,160 6,350 190 6140 Life Insurance Allocation 677 700 725 631 750 25 6155 Workers' Comp Allocation 10,820 11,533 10,910 10,822 11,270 360 6160 LTD Insurance Allocation 1,937 1,930 2,125 1,659 2,195 70 6165 Unemployment Allocation 262 255 305 220 315 10 6175 Benefits/Flex Plan 34,303 36,878 34,220 30,226 34,220 6180 Deferred Comp/Emploler Paid 1,800 1,935 1,800 1,586 1,800 Subtotal 414,097 399,523 402,620 346,095 423,045 20,425 Distribution Operations-Overhead Lines 6003 Salaries/Regular 480,299 397,235 608, 160 424,345 809,595 201,435 6030 Overtime Pay/Regular 13,635 11,387 10,000 17,274 10,000 6033 Overtime Pay/Premium 55, 111 90,352 60,000 54,055 60,000 6039 Standby Pay/Premium 17,866 14,957 20,000 14,057 20,000 6045 Salaries/Education Incentive 301 302 282 6048 Salaries/Language Pay 2,966 2,408 2,400 2,576 4,800 2,400 6063 Salaries/Jury Duty 520 721 1,379 6072 Salaries/Injury 1,203 4,568 6075 Vacation Pay-Off 8,842 28,779 8,406 6078 Sick Leave Pay-Off 710 6101 PERS/Employee Contribution 36,732 29,435 43,035 26,456 57,315 14,280 6105 PERS/Employer Contribution 53,007 55,754 64,710 68,203 111,535 46,825 6109 PARS/Employer Contribution 19, 152 22,517 33,080 20,473 25,550 (7,530) 6125 FICA/Employer Contrib/Med 10,509 9,638 10,430 9,279 13,905 3,475 347 BUDGET UNIT: ALL FUND 33 DIVISIONS -ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 6140 Life Insurance Allocation 1,427 1,142 1,630 1, 164 2,165 535 6155 Workers' Comp Allocation 25,062 21,306 24,430 22,037 32,580 8,150 6160 LTD Insurance Allocation 4,006 3,214 4,725 3,160 6,295 1,570 6165 Unemployment Allocation 641 605 710 586 960 250 6175 Benefits/Flex Plan 95,054 80,654 108,420 79,461 144,560 36, 140 Subtotal 914,664 839,814 991,730 822,462 1,299,260 307,530 Distribution Operations-Underground Lines 6003 Salaries/Regular 480,295 397,779 608, 160 355,902 639,890 31,730 6030 Overtime Pay/Regular 13,635 11,387 10,000 17,274 10,000 6033 Overtime Pay/Premium 55, 111 93,025 60,000 50,770 60,000 6039 Standby Pay/Premium 17,866 14,957 20,000 14,057 20,000 6045 Salaries/Education Incentive 301 302 282 6048 Salaries/Language Pay 2,965 2,420 2,400 2,256 2,400 6101 PERS/Employee Contribution 36,731 29,508 43,035 26,436 45,250 2,215 6105 PERS/Employer Contribution 53,007 (14,093) 64,710 56, 161 88,195 23,485 6109 PARS/Employer Contribution 19, 152 22,573 33,080 20,473 34,790 1,710 6125 FICA/Employer Contrib/Med 10,509 9,694 10,430 8,009 10,880 450 6140 Life Insurance Allocation 1,426 1,145 1,630 1,004 1,705 75 6155 Workers' Comp Allocation 25,062 21,399 24,430 19,223 25,700 1,270 6160 LTD Insurance Allocation 4,004 3,221 4,725 2,696 4,975 250 6165 Unemployment Allocation 640 609 710 503 750 40 6175 Benefits/Flex Plan 95,053 81,032 108,420 63,781 108,420 Subtotal 914,655 774,346 991,730 717,881 1,052,955 61,225 Distribution Operations-Meters 6003 Salaries/Regular 154,860 154,467 263,900 156,395 279,445 15,545 6033 Overtime Pay/Premium 10,001 28,548 10,000 16,596 10,000 6045 Sal/Ed Inc 904 905 846 6048 Salaries/Language Pay 1,206 1,207 1,200 1, 128 1,200 6101 PERS/Employee Contribution 12,952 13,293 18,630 12,538 19,720 1,090 6105 PERS/Employer Contribution 16,267 21, 138 28,000 22,330 38,240 10,240 6109 PARS/Employer Contribution 7, 112 10,293 14,360 9,709 15,200 840 6125 FICA/Employer Contrib/Med 3,278 3,734 4,630 3,239 4,855 225 6140 Life Insurance Allocation 455 459 705 417 745 40 348 BUDGET UNIT: ALL FUND 33 DIVISIONS -ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 6155 Workers' Comp Allocation 7,587 8,158 10,605 7,689 11,225 620 6160 LTD Insurance Allocation 1,367 1,347 2,050 1, 169 2, 175 125 6165 Unemployment Allocation 206 236 320 205 335 15 6175 Benefits/Flex Plan 36, 188 38,903 54,210 31,883 54,210 Subtotal 283,980 327,863 408,610 291,474 437,350 28,740 Distribution Operations-Miscellaneous Distribution 6003 Salaries/Regular 19,701 29,647 26,560 35,819 41,390 14,830 6048 Salaries/Language Pay 404 6075 Vacation Pay-Off 3,410 6101 PERS/Employee Contribution 948 20 1,885 23 2,920 1,035 6105 PERS/Employer Contribution 2,701 4,880 2,835 6,357 5,710 2,875 6125 FICA/Employer Contrib/Med 527 558 620 644 835 215 6140 Life Insurance Allocation 61 73 70 85 110 40 6155 Workers' Comp Allocation 984 1, 198 1,060 1,452 1,655 595 6160 LTD Insurance Allocation 188 220 205 246 320 115 6165 Unemployment Allocation 32 36 45 41 60 15 6175 Benefits/Flex Plan 10,777 13,342 16, 150 14,252 16, 150 6180 Deferred Come/Emeloter Paid 180 446 540 476 540 Subtotal 44,414 50,737 49,970 59,876 69,690 19,720 Engineering 6003 Salaries/Regular 87,414 118,329 222,710 114,775 225,850 3,140 6045 Salaries/Education Incentive 1,459 1,460 1,365 6101 PERS/Employee Contribution 8,273 9,192 15,635 8,667 15,860 225 6105 PERS/Employer Contribution 10,380 13,537 23,500 12,981 30,715 7,215 6109 PARS/Employer Contribution 9,165 13,057 22,205 12,312 13,080 (9,125) 6125 FICA/Employer Contrib/Med 2,006 2,069 3,695 1,887 3,740 45 349 BUDGET UNIT: ALL FUND 33 DIVISIONS -ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 6140 Life Insurance Allocation 99 320 590 289 600 10 6155 Workers' Comp Allocation 4,713 5,238 8,910 4,939 9,035 125 6160 LTD Insurance Allocation 296 940 1,730 802 1,755 25 6165 Unemployment Allocation 29 124 255 115 255 6175 Benefits/Flex Plan 16,209 17,498 32,300 14,393 32,300 6180 Deferred Come/Emeloyer Paid 1,800 1,935 3,600 1,586 3,600 Subtotal 188,770 206, 140 335, 130 189,760 336,790 1,660 Resource Mgmt-Admin 6003 Salaries/Regular 344,904 368,261 380,095 345,614 384,650 4,555 6045 Salaries/Education Incentive 2,918 2,921 2,730 6048 Salaries/Language Pay 2,412 2,414 2,400 2,256 2,400 6101 PERS/Employee Contribution 26,322 27,906 26,850 26, 137 27,165 315 6105 PERS/Employer Contribution 33,533 41,732 40,340 39,861 52,585 12,245 6109 PARS/Employer Contribution 21,384 81,364 37,895 37,130 38,355 460 6125 FICA/Employer Contrib/Med 6,068 6,733 6,250 6,143 6,315 65 6140 Life Insurance Allocation 938 972 1,020 871 1,030 10 6155 Workers' Comp Allocation 14,999 15,904 15,300 14,896 15,485 185 6160 LTD Insurance Allocation 2,766 2,805 2,960 2,393 2,990 30 6165 Unemployment Allocation 349 388 435 325 435 6175 Benefits/Flex Plan 48,689 52,291 48,450 42,850 48,450 6180 Deferred Comp/Employer Paid 4,140 4,965 5,400 4,758 5,400 Subtotal 543,724 648,832 567,395 553,355 585,260 17,865 PERSONNEL SUBTOTAL 3,304,305 3,247,255 3,747,185 2,980,904 4,204,350 457,165 350 BUDGET UNIT: ALL FUND 33 DIVISIONS -ELECTRIC (DETAILS) Acct.# 3340734270 7001 7005 3340735800 6530 3340735830 6554 6563 6566 3340735840 6566 3340735850 6905 DESCRIPTION OPERATIONS Interest -Long-Term Debt Interest Expense Principal Payment Subtotal ACTUAL 14-15 254,443 254,443 Distribution Operations-Supervision & Engineering Office Supplies 11 Subtotal 11 Distribution Operations-Overhead Lines Supplies/Custodial & Cleaning 3 Supplies/Special 464 Small Tools 2,606 Subtotal 3,073 Distribution Operations-Underground Lines Small Tools 427 Subtotal 427 Distribution Operations-Street Lighting & Signal Utilities I Electricity 10,208 Subtotal 10,208 ACTUAL 15-16 225, 136 225, 136 36 36 515 7,879 8,394 1,107 1,107 9.748 9,748 REVISED YEAR END EST ADOPTED 16-17 16-17 17 -1 8 200,915 200,915 172,690 650,000 650,000 780,000 850,915 850,915 952,690 100 100 100 100 100 100 1,000 1,000 1,000 10,000 10,000 10,000 11,000 11,000 11,000 3,000 3,000 3,000 3,000 3,000 3,000 10,000 10,000 10,000 10,000 10,000 10,000 VARIANCE (28,225) 130,000 101,775 351 BUDGET UNIT: ALL FUND 33 DIVISIONS -ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 3340735860 Distribution Operations-Meters 6566 Small Tools 414 500 500 500 Subtotal 414 500 500 500 3340735880 Distribution Operations-Miscellaneous Distribution 6201 Uniforms & Laundry 25,627 28,217 30,000 30,000 30,000 6220 Training Schools 7,408 5,614 16,000 16,000 16,000 6225 Training Materials 132 1,000 1,000 1,000 6230 Dues & Subscriptions 23,010 23,467 23,000 45,000 45,000 22,000 6235 Meetings & Conferences 4,981 310 8,000 8,000 8,000 6240 Mileage Reimbursement 100 100 100 6301 Legal Fees 1,091 3,272 2,500 2,500 2,500 6340 Special Studies 31,386 4,241 50,000 50,000 50,000 6493 Outside Service/Repair 12,705 8,256 1,000 1,000 1,000 6521 Messenger Service 278 457 200 200 200 6530 Office Supplies 1,261 1,751 1,000 1,000 1,000 6551 Fuel and Oil 51,373 37,790 25,000 25,000 25,000 6563 Supplies/Special 5,903 8,657 5,000 5,000 5,000 6564 Supplies/Medical-Dental 1,006 1,985 1,500 1,500 1,500 6566 Small Tools 862 5,932 3,000 3,000 3,000 6569 Small Equipment 15,799 13,917 15,000 15,000 15,000 6601 Advertising Expense 1,872 1,950 2,000 2,000 2,000 6825 Maint & Repair I Vehicle 35,913 14,673 35,000 35,000 35,000 6835 Maint & Repair/Equipment 789 1,967 5,000 5,000 5,000 6850 Lease Payments 7,000 6904 Utilities/Other 26,675 20,958 18,000 18,000 18,000 6910 Utilities/Natural Gas 442 688 700 700 700 6915 Utilities/Teleehone 7,136 7,200 7,200 7,200 Subtotal 255,648 184,102 250,200 272,200 279,200 29,000 352 BUDGET UNIT: ALL FUND 33 DIVISIONS -ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE 3340735910 Distribution Maintenance-Structures 6430 Custodial Services 4,880 6,943 5,000 5,000 5,000 6493 Outside Services & Repairs 1, 184 2,706 2,500 2,500 2,500 6554 Supplies/Custodial & Cleaning 745 874 900 900 900 6805 Maint/Land Improvement 1,550 7,500 7,500 7,500 6815 Maint & Reeairs/Bldgs 21,717 22,642 17,600 17,600 17,600 Subtotal 30,076 33, 165 33,500 33,500 33,500 3340735920 Distribution Maintenance-Station Equipment 6493 Outside Services & Repairs 445 14,562 30,000 30,000 30,000 6563 Supelies/Seecial 444 164 10,000 10,000 10,000 Subtotal 889 14,727 40,000 40,000 40,000 3340735930 Distribution Maintenance-Overhead Lines 6493 Outside Services & Repairs 175,833 204,497 261,079 261,079 261,079 6563 Sueelies/Seecial 1,804 3,178 4,000 4,000 4,000 Subtotal 177,637 207,676 265,079 265,079 265,079 3340735940 Distribution Maintenance-Underground Lines 6493 Outside Services & Repairs 23,881 8,577 51, 162 51, 162 51, 162 0 6563 Supplies/Special 3,580 3,448 2,000 2,000 2,000 6566 Small Tools 6601 Advertising Expn 6835 Maint & Reeair/Equiement 65 48 500 500 500 Subtotal 27,526 12,073 53,662 53,662 53,662 0 3340735950 Distribution Maintenance-Transformer Lines 6493 Outside Services & Repairs 10,000 10,000 10,000 Subtotal 10,000 10,000 10,000 353 BUDGET UNIT: ALL FUND 33 DIVISIONS -ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED 14-15 15-16 16-17 16-17 17-18 VARIANCE 3340735960 Distribution Maintenance-Street Lighting & Signals 6563 Sueelies/Seecial 703 5,000 5,000 5,000 Subtotal 703 5,000 5,000 5,000 3340735970 Distribution Maintenance-Meters 6563 Supplies/Special 5,247 4,692 8,000 8,000 8,000 6835 Maint & Reeair/Eguiement 3,000 3,000 3,000 Subtotal 5,247 4,692 11,000 11,000 11,000 3340739040 Customer Accounts-Uncollectible Accounts 7055 Uncollectible Accounts 56,636 56,476 80,000 65,000 65,000 (15,000) Subtotal 56,636 56,476 80,000 65,000 65,000 (15,000) 3340745800 Engineering 6220 Training Schools (649) 1,000 1,000 1,000 6230 Dues & Subscriptions 115 6235 Meetings & Conferences 50 89 2,000 2,000 2,000 6340 Special Studies 24,553 30,000 30,000 30,000 6345 Program Consultants 2,487 2,490 5,000 5,000 5,000 6399 Professional Services/Other 27, 122 14,048 14,502 12,000 12,000 (2,502) 6530 Office Supplies 2,028 3,549 2,000 2,000 2,000 6825 Maint & Reeair I Vehicle 552 279 1,000 1,000 1,000 Subtotal 31,705 45,008 55,502 53,000 53,000 (2,502) 3340775550 Resource Management -Purchased Power 6590 Electricitl For Resale 28,834,815 25,726,445 25,800,285 24,653,010 17,459,287 (8,340, 998) Subtotal 28,834,815 25,726,445 25,800,285 24,653,010 17,459,287 (8,340,998) 354 BUDGET UNIT: ALL FUND 33 DIVISIONS -ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED 14-15 15-16 16-17 16-17 17-18 VARIANCE 3340775570 Resource Management-Admin 6220 Training Schools 5,260 5,260 5,260 6235 Meetings & Conferences 5,444 1,247 3,000 3,000 3,000 6240 Mileage Reimbursement 800 800 6301 Legal Fees 50,039 59,669 120,000 100,000 100,000 (20,000) 6340 Special Studies 61,217 25,363 25,000 25,000 60,000 35,000 6521 Messenger Service 361 98 300 300 6530 Office Supplies 19 1,028 1,000 1,000 1,000 6569 Small Equipment 3,225 4,000 4,000 4,000 6625 Program Expenses 155,894 182,001 327,100 327, 100 (327, 100) 6850 Lease Payments 2,795 3,378 3,400 3,500 3,500 100 6915 Utilities/Teleehone 1,553 1,864 1,500 1,500 1,500 Subtotal 277,322 277,872 490,260 470,360 179,360 (310,900) 3340785560 Resources Management -Scheduling & Dispatch 6230 Dues & Subscriptions 6493 Outside Services & Repairs 612,009 416,379 604,825 486,397 570, 103 (34,722) Subtotal 612,009 416,379 604,825 486,397 570, 103 (34,722) 3340785650 Resources Management -Transmission 6493 Outside Services & Repairs 3,406,081 3,333,652 4,050,070 3,422,871 4,053,211 3, 141 Subtotal 3,406,081 3,333,652 4,050,070 3,422,871 4,053,211 3, 141 3340799030 Administrative & General 6230 Dues & Subscript 6301 Legal Fees 47, 187 2,161 100,000 50,000 50,000 (50,000) 6399 Professional Services/Other 16,822 15,754 4,945 10,000 15,000 10,055 6423 Administrative Allocation 667,015 667,015 6424 Consumer Services Allocation 2, 192,799 2,363,093 2,587,217 2,587,217 2,807,662 220,445 Subtotal 2,256,808 2,381,008 2,692, 162 2,647,217 3,539,677 847,515 3340799270 Franchise Fees 7010 Franchise Fee (2%) 780,399 731,136 757,765 757,765 685,858 (71,907) 7012 In-lieu Fee (8%) 3, 121,597 2,924,543 3,031,055 3,031,055 2,743,432 (287,623) 355 BUDGET UNIT: ALL FUND 33 DIVISIONS -ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE Subtotal 3,901,996 3,655,678 3,788,820 3,788,820 3,429,290 (359,530) 3340799302 Interest Transfers 6610 Bond Administration 4,250 4,250 4,250 4,250 4,250 7009 Bank Service Char9e Subtotal 4,250 4,250 4,250 4,250 4,250 OPERATIONS SUBTOTAL 40,147,222 36,598,327 39,110,129 37,156,881 31,027,909 (8,082,220) 356 BUDGET UNIT: ALL FUND 33 DIVISIONS -ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED 14-15 15-16 16-17 16-17 17-18 VARIANCE CAPITAL OUTLAY 3340733620 Station Equipment 7140 Eguiement & Machine!}'. 24,324 17,260 75,000 75,000 75,000 Subtotal 24,324 17,260 75,000 75,000 75,000 3340733640 Poles, Towers & Fixtures 7130 Structures/Other 22,231 24,985 35,000 35,000 35,000 Subtotal 22,231 24,985 35,000 35,000 35,000 3340733650 Overhead Conductors & Dev 7145 Lines, Mains & Sewers 24,252 29,921 30,000 30,000 30,000 Subtotal 24,252 29,921 30,000 30,000 30,000 3340733660 Underground Conduit 7130 Structures/Other 1,999 5,358 25,000 25,000 25,000 Subtotal 1,999 5,358 25,000 25,000 25,000 3340733670 Underground Conductors & Dev 7145 Lines, Mains & Sewers 290,882 288,827 300,000 300,000 300,000 Subtotal 290,882 288,827 300,000 300,000 300,000 3340733680 Line Transformers 7140 Equipment & Machine!}'. 124,980 141, 136 250,000 250,000 250,000 Subtotal 124,980 141, 136 250,000 250,000 250,000 3340733700 Meters 7140 Eguipment & Machine!}'. 80,521 91,767 150,000 150,000 150,000 Subtotal 80,521 91,767 150,000 150,000 150,000 3340733730 Street Lighting 7130 Structures/Other 6,392 22,628 25,000 25,000 25,000 7140 Equipment & Machinery 24,667 14 357 BUDGET UNIT: ALL FUND 33 DIVISIONS -ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED YEAR END EST ADOPTED Acct.# 14-15 15-16 16-17 16-17 17-18 VARIANCE Subtotal 31,059 22,642 25,000 25,000 25,000 3340733940 Tools, Shop Equipment 7140 Equipment & Machine!}'. 15,365 Subtotal 15,365 CAPITAL OUTLAY SUBTOTAL 615,614 621,895 890,000 890,000 890,000 TRANSFERS OUT 3300000000 General 5950 Transfers Out 64,031 105, 147 85,000 85,000 185,000 100,000 Subtotal 64,031 105, 147 85,000 85,000 185,000 100,000 3340735830 Dist Oper -Overhead Line Expenses 5950 Transfers Out 10,322 10,500 10,500 10,500 14,815 4,315 Subtotal 10,322 10,500 10,500 10,500 14,815 4,315 3340735840 Dist Oper -Underground Line Expenses 5950 Transfers Out 10,322 10,500 10,500 10,500 14,815 4,315 Subtotal 10,322 10,500 10,500 10,500 14,815 4,315 3340735860 Dist Oper -Meters 5950 Transfers Out 10,374 10,615 10,615 10,615 10,935 320 Subtotal 10,374 10,615 10,615 10,615 10,935 320 TRANSFERS OUT SUBTOTAL 95,050 136,762 116,615 116,615 225,565 108,950 ELECTRIC FUND TOTAL: 44,162,190 40,604,240 43,863,929 41,144,399 36,347,824 (7 ,516, 105) 358 Budget Division: LIGHT AND WATER - ELECTRIC DISTRIBUTIONS & OPERATIONS FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 Adopted Adopted Adopted Adopted Adopted Adopted Adopted Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Assistant Director-Electric Operations 1.00 1.00 $139,310 $140,660 Electric Distribution Supervisor 1.00 1.00 133,540 141,165 Electric Crew Supervisor 3.00 3.00 332,530 377,290 Line Mechanic 8.00 8.00 821,700 844,175 Line Mechanic Helper 1.00 1.00 62,090 67,130 Senior Electric Test Technician 1.00 1.00 104,275 110,420 Electrical Test Technician 1.00 1.00 79,205 83,790 Apprentice Elect Test Technician 1.00 1.00 80,420 85,235 Office Specialist II 1.00 1.00 26,560 41,390 Apprentice Line Mechanic 0.00 2.00 0 160,890 TOTAL 18.00 20.00 $1,779,630 $2,052,145 TOTAL - - - - Full Time Positions Part Time Positions 359 Budget Division: LIGHT AND WATER - ELECTRIC ENGINEERING FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 Adopted Adopted Adopted Adopted Adopted Adopted Adopted Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Senior Electrical Engineer 1.00 1.00 $124,035 $131,195 Electrical Engineer 1.00 1.00 98,675 94,655 TOTAL 2.00 2.00 $222,710 $225,850 TOTAL - - - - Full Time Positions Part Time Positions 360 Budget Division: LIGHT AND WATER - RESOURCES MANAGEMENT FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 FY 16-17 FY 17-18 Adopted Adopted Adopted Adopted Adopted Adopted Adopted Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Assistant Director-Resource Management 1.00 1.00 $153,355 $154,890 Power Resources Coordinator 1.00 1.00 120,375 121,550 Power Resources Scheduler 1.00 1.00 106,365 108,210 TOTAL 3.00 3.00 $380,095 $384,650 TOTAL - - - - Full Time Positions Part Time Positions 361