Loading...
HomeMy WebLinkAbout11 Light and WaterLIGHT & WATER Public Benefit Programs  Recycling and Solid Waste     Consumer Services    Water  Utility    Electric Utility  323 THIS PAGE INTENTIONALLY LEFT BLANK 324 LIGHT AND WATER PUBLIC BENEFIT PROGRAMS PROGRAM COMMENTARY PROGRAM DESCRIPTION: The California electric restructuring legislation (AB 1890) signed into law on September 23, 1996, requires municipal electric utilities to impose a usage charge to fund investments in energy conservation. The usage surcharge, which is about 2.85%, is referred to as the public benefit charge (PBC), and is authorized to continue in effect until January 1, 2012. Proceeds from the PBC support programs that provide 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. STRATEGIC GOALS: The public benefits fund has an accumulated a balance of about $2 million and the PBC is expected to generate an additional $900,000 during FY 2010-11. The main strategic goal of this division is therefore to increase customer participation in energy-efficiency, energy-conservation, renewable energy, and other eligible programs funded by the PBC. A variety of channels will be used to promote program participation, including outreach to the Chamber of Commerce, direct mailers, utility billing inserts, and web page advertisements. FY 10-11 PROGRAM HIGHLIGHTS: Several conservation programs have been developed over the years by the Public Benefits Program division. Some of these include: (1) Commercial & Industrial Energy Partnership program which provides energy audits for businesses and incentives up to $10,000 or 50% of project cost. With this year’s budget, Partnership incentives will be increased to 100% for the first $1,500. (2) LED TV and Computer Monitor Program which provides rebates of up to $750 or 25% of the cost of LED TVs and monitors. (3) CFL Giveaways to promote energy efficient lighting. (4) Weatherization Rebate Program. (5) Refrigerator Rebate Program. With this year’s budget additional appliances such as washing machines and dishwashers will be added to the program. (6) Air Conditioner Rebate Program. (7) Shade Tree Program. (8) Residential Low Income assistance. (9) Educational and online learning opportunities regarding energy conservation are also funded through the PBC budget. (10) About $200,000 will be made available through this year’s budget for ICE Energy or thermal storage units to offset peak power demand for some customers. 325 Budget Division: LIGHT AND WATER - PUBLIC BENEFIT PROGRAMS FY 09-10 FY 10-11 FY 09-10 FY 10-11 FY 09-10 FY 10-11 FY 09-10 FY 10-11 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Hours Hours Wages Wages Business Dev/Pub Benefit Prog Coord (a)0.70 0.70 $55,965 $55,965 Pks Maint (AQMD)606 2,080 $9,600 $32,905 Asst Director-Cust Care and Solutions(b)0.00 0.15 0 19,050 Cust Serv Rep I 832 0 12,400 0 Customer Service Representative II 0.00 0.05 0 2,510 (a) .30 FTE Water (b) .85 FTE Consumer Services-Employee Expense (c) .95 FTE Consumer Services-Records & Collections TOTAL 0.70 0.90 $55,965 $77,525 TOTAL 1,438 2,080 $22,000 $32,905 Full Time Positions Part Time Positions 326 BUDGET UNIT: 2440739xxx L&W PUBLIC BENEFIT PROGRAMS DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #07-08 08-09 09-10 10-11 VARIANCE PERSONNEL ADMINISTRATION OF PBC 6003 Salaries/Regular 70,705 50,800 55,965 77,525 21,560 6006 Salaries/Temp & Part-Time - - 22,000 32,905 10,905 6015 Salaries/Vacation 4,490 3,665 - - - 6024 Salaries/Sick Leave 2,995 - - - - 6045 Salaries/Education Incentive 1,460 1,020 1,015 1,015 - 6063 Salaries/Jury Duty - 260 - - - 6101 PERS/Employee Contribution 5,600 3,920 4,890 5,595 705 6105 PERS/Employer Contribution 9,985 6,720 8,160 9,195 1,035 6109 PARS/Employer Contribution 1,125 3,070 3,585 4,810 1,225 6125 FICA/Employer Contrib/Med 1,375 975 1,150 1,340 190 6140 Life Insurance Allocation 295 180 160 205 45 6155 Workers' Comp Allocation 3,185 2,265 2,770 3,145 375 6160 LTD Insurance Allocation 830 490 435 605 170 6165 Unemployment Allocation 70 50 80 95 15 6175 Benefits/Flex Plan 13,105 9,990 9,995 13,670 3,675 6180 Deferred Comp/Employer Paid 1,080 1,245 1,260 1,260 - SUBTOTAL 116,300 84,650 111,465 151,365 39,900 PERSONNEL SUBTOTAL 116,300 84,650 111,465 151,365 39,900 327 Cost 2440739000 6625 $950,830 LIGHT & WATER - PUBLIC BENEFITS PROGRAM ACTIVITY DETAIL Account Number Description Program Expense - Low Income Assistance Program ($40,000), Energy Efficiency Program ($800,830), Renewables Program ($60,000), Research & Development ($10,000), Other Program Expenses ($40,000). 328 BUDGET UNIT: 2440739xxx L&W PUBLIC BENEFIT PROGRAMS DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #07-08 08-09 09-10 10-11 VARIANCE OPERATIONS RESIDENTIAL LOW INCOME 6625 Program Expense 23,010 28,525 40,000 40,000 - SUBTOTAL 23,010 28,525 40,000 40,000 - ENERGY EFFICIENCY PROGRAM 6625 Program Expense 577,880 236,610 714,590 800,830 86,240 SUBTOTAL 577,880 236,610 714,590 800,830 86,240 RESEARCH & DEVELOPMENT 6625 Program Expense - - 10,000 10,000 - SUBTOTAL - - 10,000 10,000 - RENEWABLES 6625 Program Expense - - 60,000 60,000 - SUBTOTAL - - 60,000 60,000 - ADMINISTRATION OF PBC 6551 Fuel and Oil - - 1,000 1,000 - 6625 Program Expense 18,585 26,710 40,000 40,000 - 6825 Maint & Repair/Vehicle - - 7,200 7,200 - SUBTOTAL 18,585 26,710 48,200 48,200 - OPERATIONS SUBTOTAL 619,475 291,845 872,790 959,030 86,240 PUBLIC BENEFIT PROG FUND TOTAL 735,775 376,495 984,255 1,110,395 126,140 329 THIS PAGE INTENTIONALLY LEFT BLANK 330 LIGHT AND WATER RECYCLING AND SOLID WASTE PROGRAM COMMENTARY PROGRAM DESCRIPTION: Recycling and Solid Waste is a division of the Utilities Department and its primary responsibilities are to ensure compliance with the California Integrated Waste Management Act of 1989 (AB 939) and to administer the refuse collection and recycling contract with Athens Services. This division works closely with the Customer Service division of the Utilities Department on rate setting, billing, customer service and public information issues. Recycling and Solid Waste also administers two State-provided block grant programs, the Used Oil Recycling Block Grant and the Beverage Container Recycling Grant, and promotes use of reusable bags and proper disposal of “sharps” medical waste. Division activities include support of code enforcement regarding illegal disposal issues and violations of Athens Services Exclusive Franchise Agreement. STRATEGIC GOALS: • Maintain a waste diversion rate of 50% or more to stay in compliance with the State’s recycling mandate, AB 939. • Maintain competitive rates for refuse collection services. • Consider how closure of Puente Hills landfill in 2013 will impact service charges and waste diversion. • Promote recycling and proper disposal of used motor oil, household hazardous wastes and sharps medical waste. • Support community organizations that help implement programs like backyard composting. FY 10-11 PROGRAM HIGHLIGHTS: • Prepare the AB 939 Annual Report for calendar year 2009 and submit it to the California Department of Resources Recycling & Recovery. • Prepare and implement refuse rate adjustments pursuant to contract terms with Athens Services. • Administer Used Oil Recycling and Beverage Container Grant Programs, and perform maintenance on school recycling bins. • Promote use of reusable grocery bags and proper disposal of sharps by distribution of mail back containers. • Provide financial support for collection and disposal of hazardous waste generated at City facilities. • Support the City’s Cleaner, Greener and More Beautiful Azusa program by scheduling a Household Hazardous Waste and Electronic Waste Round-up in the City, and by updating and mailing a booklet about the City’s Recycling Programs to all homes and businesses in Azusa. 331 Budget Division: LIGHT AND WATER - RECYCLING AND SOLID WASTE FY 09-10 FY 10-11 FY 09-10 FY 10-11 FY 09-10 FY 10-11 FY 09-10 FY 10-11 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Hours Hours Wages Wages Assistant to the Director of Utilities(a)0.25 0.25 24,915 $25,365 Senior Administrative Technician (b)0.50 0.50 30,770 30,770 (a) .75 FTE LW Administration (b) .50 FTE LW Administration TOTAL 0.75 0.75 $55,685 $56,135 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 332 BUDGET UNIT: 3940750065/3640750000 LIGHT & WATER-SOLID WASTE MGT DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #07-08 08-09 09-10 10-11 VARIANCE PERSONNEL AB 939 FEE 6003 Salaries/Regular 34,730 33,575 55,685 56,135 450 6012 Salaries/Comp-Time 40 25 - - - 6015 Salaries/Vacation 3,805 1,695 - - - 6024 Salaries/Sick Leave 3,970 1,885 - - - 6027 Salaries/Bereavement 240 - - - - 6045 Salaries/Education Incentive 490 365 365 365 - 6063 Salaries/Jury Duty - 30 - - - 6101 PERS/Employee Contribution 3,045 2,725 3,985 4,015 30 6105 PERS/Employer Contribution 5,390 4,675 6,625 6,600 (25) 6109 PARS/Employer Contribution 460 1,360 1,600 1,625 25 6125 FICA/Employer Contrib/Med 745 680 970 985 15 6140 Life Insurance Allocation 160 130 155 150 (5) 6155 Workers' Comp Allocation 1,730 1,565 2,240 2,260 20 6160 LTD Insurance Allocation 455 370 435 435 - 6165 Unemployment Allocation 45 45 70 70 - 6175 Benefits/Flex Plan 7,190 6,825 10,705 11,290 585 6180 Deferred Comp/Employer Paid 505 570 720 720 - SUBTOTAL 63,000 56,520 83,555 84,650 1,095 PERSONNEL SUBTOTAL 63,000 56,520 83,555 84,650 1,095 333 Cost 2840750065 3940750065 6220 $1,000 6235 $1,600 6625 $42,470 6455 $3,260,000 7055 $30,000 Training Schools - Training by California Resource Recovery Association and on general solid waste recycling program development and implementation and administration of used oil block grant program and beverage container recycling grant program. Uncollectible Accounts - Due to the economy, a higher incidence of non-payment is occurring increasing the need to budget more cost for write-offs. Meeting/Conferences - San Gabriel Valley Council of Governments Solid Waste Committee, Los Angeles County Integrated Waste Management Task Force, California Department of Resources Recycling and Recovery, and workshop attendance. Program Expenses - In addition to expenses for used oil recycling ($8,230) program and school recycling ($2,640) program, Program Expenses are also used to: (1) support the Public Works Department's proper disposal of hazardous waste ($6,400); (2) promote use of reusable grocery bags ($7,500); (3) promote proper disposal of sharps waste ($7,700); (4) promote backyard composting ($5,000); and (5) help to publicize the City's annual Clean, Green & More Beautiful Azusa month activities ($5,000). Refuse Contract - This amount is used to pay Athens Service for collection of residential solid waste and processing of waste at contractor's material recovery facility. This amount also includes landfill disposal costs. Given low inflation and reduced disposal tonnages due to economcy, rates are not expected to increase substantially. LIGHT & WATER - RECYCLING AND SOLID WASTE ACTIVITY DETAIL Account Number Description 334 BUDGET UNIT: 3940750065/3640750000 LIGHT & WATER-SOLID WASTE MGT DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #07-08 08-09 09-10 10-11 VARIANCE OPERATIONS OIL BLOCK GRANT 6625 Program Expense 16,855 11,575 13,000 8,230 (4,770) SUBTOTAL 16,855 11,575 13,000 8,230 (4,770) BEVERAGE CONTAINER RECYCLING 6625 Program Expense 8,720 7,485 13,000 640 (12,360) SUBTOTAL 8,720 7,485 13,000 640 (12,360) AB 939 FEE 6220 Training Schools - 350 1,000 1,000 - 6235 Meetings & Conferences 170 305 1,645 1,600 (45) 6301 Legal Fees - 730 500 4,000 3,500 6493 Outside Services & Repairs - - 200 200 - 6518 Postage 2,090 1,310 2,500 1,500 (1,000) 6527 Supplies/Computer - 105 1,000 500 (500) 6530 Office Supplies - 40 200 200 - 6539 Printing, Binding & Duplicating 1,790 1,840 3,000 2,000 (1,000) 6572 Office Furniture & Equipment - - 1,000 500 (500) 6625 Program Expense 29,290 34,790 49,645 33,600 (16,045) 6915 Utilities/Telephone - - 710 710 - 7025 Overhead Expense 33,655 33,655 33,655 33,655 - SUBTOTAL 66,995 73,125 95,055 79,465 (15,590) REFUSE CONTRACT 6455 Refuse Collection 3,216,975 2,990,300 3,267,500 3,260,000 (7,500) 7055 Uncollectible Accounts 30,760 37,970 40,000 30,000 (10,000) SUBTOTAL 3,247,735 3,028,270 3,307,500 3,290,000 (17,500) OPERATIONS SUBTOTAL 3,340,305 3,120,455 3,428,555 3,378,335 (50,220) 335 BUDGET UNIT: 3940750065/3640750000 LIGHT & WATER-SOLID WASTE MGT DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #07-08 08-09 09-10 10-11 VARIANCE TRANSFERS OUT AB 939 FEE 5950 Transfers Out 68,920 150,000 - - - SUBTOTAL 68,920 150,000 - - - REFUSE CONTRACT 5950 Transfers Out 610,000 585,800 590,000 541,400 (48,600) SUBTOTAL 610,000 585,800 590,000 541,400 (48,600) TRANSFERS OUT SUBTOTAL 678,920 735,800 590,000 541,400 (48,600) SOLID WASTE MGMT. TOTAL 4,082,225 3,912,775 4,102,110 4,004,385 (97,725) FUNDING: AB 139 FEE FUND 39 (198,915) (279,645) (178,610) (164,115) (14,495) GRANT FUND 28 (25,575) (19,060) (26,000) (8,870) (17,130) REFUSE FUND 36 (3,857,735) (3,614,070) (3,897,500) (3,831,400) (66,100) Total Funding (4,082,225) (3,912,775) (4,102,110) (4,004,385) (97,725) 336 LIGHT & WATER CONSUMER SERVICES PROGRAM COMMENTARY PROGRAM DESCRIPTION: This portion of the budget consists of the Utility Board, Utilities Administration, and Customer Service. The City Council meets monthly as the Utility Board pursuant to the Azusa Municipal Code to provide policy direction to the Utilities Department. Utilities Administration administers the Utility Board agenda process and coordinates preparation of the Department budget, work plan, legislative monitoring, property management, facilities maintenance, purchasing, payment processing, payroll, and assists with work order tracking and billing. Utilities Administration also conducts financial analysis, prepares various reports, and determines when rate adjustments are necessary. Customer Service consists of three cost centers, including Records and Collections, Meter Reading, and Supervision. Customer Service is responsible for electric and water utility billing, collections, answering customer calls, assisting walk-in customers, meter reading, turning services on and off, and 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 and electric conservation programs. STRATEGIC GOALS: The goal of Utilities Administration is to provide administrative support to the Utility Board and various Utility divisions to ensure that communication between the Board and Utilities staff is effective and results-oriented. Administrative services also aims at providing accurate financial forecasts for budgeting and rate setting purposes so that the Azusa Light & Water’s operational and capital requirements are met through affordable and predictable utility rates. Customer Service is charged to ensure that its operations are managed efficiently and in a cost effective manner, and also in a way that ensures customers experience a high degree of satisfaction with our services. Customer Service will continue to offer a variety of services and programs to customers so customers have choices in billing, payment options, and how they communicate with the utility. 337 FY 10-11 PROGRAM HIGHLIGHTS: Utilities Administration will continue to administer Utility Board agenda process and provide support services to various Utility divisions in the areas of payroll processing, accounts payable/receivable, purchase orders, property management, facilities maintenance, annual operating budget preparation, monthly and quarterly budget reporting, and debt service administration including preparation and filing of annual disclosure reports. Utilities Administration will monitor the water and electric funds for compliance with bond funding covenants and City reserve policy requirements. A third party review of the electric fund will be completed and special rate adjustment mechanisms will be considered to account for fluctuations in purchased power costs and wholesale revenues. Consideration will be made to provide administrative services to FARECal (a Joint Powers Authority formed under California Municipal Utilities Association) to assist them in administering debt service filing and auditing functions as required by State statutes since Azusa Light & Water issued significant amount of long term debt (about $32 million) through FARECal in 2003, and since FARECal has been unable to fulfill its obligations. Utilities Administration also plans to assess its property management functions and consider options to managing properties owned by the Azusa Light & Water. Current projects include the remodeling of the second floor elevator lobby area; replacing two malfunctioning compressors for HVAC water chiller; repairing potholes in the drive-thru window path, clean up motor oil stains and repaint safety bars; repairing broken foot steps adjacent to the fountain at the corner of Azusa Ave. and Foothill Blvd., repaint fountain’s rock features, perform maintenance on water pump, and cap-off broken lights or replace them with LED energy saving lights; upgrade L&W building’s lightings with LED energy saving lights (funded by Public Benefit Programs for showcase purposes); and finally, repair portions of the water utility property on Barranca property, including roof of house and garage, and some exterior areas (funded by Water Division). Customer Service will continue Call Recording, online bill presentment and payment for utility customers and implement cash payment service for customers at six walk-in payment centers. A Customer Information System upgrade is planned to start this fiscal year and be completed in 2011-12. This division will also continue representing the department in keeping information current on the Light & Water web site. Customer Service will re-evaluate existing electric and water rebate programs to help the community conserve these resources and will seek to increase public awareness of customer programs and services offered by the utility. 338 THIS PAGE INTENTIONALLY LEFT BLANK 339 Budget Division: LIGHT AND WATER - CONSUMER SERVICES (ALL) FY 09-10 FY 10-11 FY 09-10 FY 10-11 FY 09-10 FY 10-11 FY 09-10 FY 10-11 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Hours Hours Wages Wages Director of Utilities 1.00 1.00 $175,000 $175,000 Cashiers 3,120 3,120 $52,385 $54,910 Assistant to the Director of Utilities(a)0.75 0.75 74,745 76,095 Drought Techs 3,120 1,560 42,510 26,090 Senior Management Analyst 1.00 1.00 76,095 76,095 Cust Srv Rep I 1,560 2,080 28,765 40,525 Senior Administrative Technician(b)0.50 0.50 30,770 30,770 Office Spec I 1,560 1,560 27,295 28,565 Asst Director-Cust Care and Solutions(c)1.00 0.85 127,010 107,955 Customer Care Operations Supervisor 1.00 1.00 76,190 77,960 Customer Services Representative I 2.00 2.00 88,410 89,955 Customer Services Representative II(d)3.00 3.95 138,525 200,425 Customer Services Representative III 6.00 5.00 335,205 295,550 Field Services Representative 2.00 2.00 125,480 128,250 Field Services Supervisor 1.00 1.00 69,945 72,510 Meter Reader 6.00 6.00 351,440 364,100 Administrative Analyst 1.00 1.00 65,315 68,025 (a) .25 FTE Recycling and Solid Waste (b) .50 FTE Recycling and Solid Waste (c) .15 FTE Public Benefits (d) .05 FTE Public Benefits TOTAL 26.25 26.05 $1,734,130 $1,762,690 TOTAL 9,360 8,320 $150,955 $150,090 Full Time Positions Part Time Positions 340 BUDGET UNIT: ALL FUND 31 DIVISIONS-CONSUMER SERVICES (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 PERSONNEL 6003 Salaries/Regular 1,478,765 1,594,875 1,734,130 1,762,690 28,560 6006 Salaries/Temp & Part Time 49,595 98,515 150,955 150,090 (865) 6012 Salaries/Comp-Time 3,005 5,465 - - - 6015 Salaries/Vacation 84,905 88,945 - - - 6024 Salaries/Sick Leave 57,260 55,220 - - - 6027 Salaries/Bereavement 6,185 740 - - - 6033 Overtime Pay/Premium 15,825 13,700 30,000 15,000 (15,000) 6039 Salaries/Education Incentive 350 - - - - 6045 Standby Pay/Premium 1,875 2,010 1,990 1,990 - 6048 Salaries/Language Pay 13,995 22,250 15,600 15,480 (120) 6063 Salaries/Jury Duty 735 840 - - - 6069 Allowances/Vehicle 5,425 5,425 5,400 26,400 21,000 6072 Salaries/Injury 2,250 475 - - - 6091 Leave Liability Adjustments 25,635 19,990 - - - 6101 PERS/Employee Contribution 120,780 132,745 124,795 125,395 600 6105 PERS/Employer Contribution 215,365 227,595 208,325 206,860 (1,465) 6109 PARS/Employer 46,475 61,600 70,235 66,595 (3,640) 6125 FICA/Employer Contrib/Med 24,815 27,180 30,625 33,320 2,695 6133 Retiree Health Premium Reimb 7,655 7,740 8,305 9,070 765 6140 Life Insurance Allocation 7,880 6,645 5,015 4,745 (270) 6155 Workers' Comp Allocation 69,370 76,215 79,230 78,010 (1,220) 6160 LTD Insurance Allocation 17,095 16,175 13,575 13,700 125 6165 Unemployment Allocation 1,845 2,115 2,375 2,400 25 6175 Benefits/Flex Plan 366,630 394,480 446,395 445,215 (1,180) 6180 Deferred Comp/Employer Paid 6,155 7,410 8,640 8,370 (270) 6199 Benefits/Other - - 43,300 - - PERSONNEL SUBTOTAL 2,629,870 2,868,350 2,978,890 2,965,330 29,740 341 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 PERSONNEL Utility Board 6069 Allowances/Vehicle - - - 21,000 21,000 Subtotal - - - 21,000 21,000 Utility Administration 6003 Salaries/Regular 318,095 356,510 356,610 357,960 1,350 6006 Salaries/Temp & Part-Time - 11,780 27,295 28,565 1,270 6012 Salaries/Comp-Time 745 2,290 - - - 6015 Salaries/Vacation 13,855 16,485 - - - 6024 Salaries/Sick Leave 16,955 14,370 - - - 6027 Salaries/Bereavement 5,320 - - - - 6033 Overtime Pay/Premium 875 2,825 - - - 6045 Salaries/Education Incentive 970 1,105 1,090 1,090 - 6063 Salaries/Jury Duty - 95 - - - 6069 Allowances/Vehicle 5,425 5,425 5,400 5,400 - 6101 PERS/Employee Contribution 25,925 29,300 25,855 25,250 (605) 6105 PERS/Employer Contribution 46,255 50,275 43,195 41,680 (1,515) 6109 PARS/Employer Contribution 18,710 26,885 29,195 28,330 (865) 6125 FICA/Employer Contrib/Med 2,915 3,435 3,510 6,430 2,920 6140 Life Insurance Allocation 3,020 2,210 1,050 965 (85) 6155 Workers' Comp Allocation 14,785 16,805 16,015 15,720 (295) 6160 LTD Insurance Allocation 3,760 4,240 2,850 2,780 (70) 6165 Unemployment Allocation 395 510 445 445 - 6175 Benefits/Flex Plan 45,735 49,200 48,105 50,430 2,325 6180 Deferred Comp/Employer Paid 4,535 5,130 6,300 6,300 - Subtotal 528,275 598,875 566,915 571,345 4,430 342 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 Field Services 6003 Salaries/Regular 468,685 499,030 546,865 564,860 17,995 6006 Salaries/Temp & Part Time 13,875 11,010 42,510 26,090 (16,420) 6012 Salaries/Comp-Time 2,180 2,300 - - - 6015 Salaries/Vacation 29,895 27,220 - - - 6024 Salaries/Sick Leave 15,770 14,685 - - - 6027 Salaries Bereavement 285 - - - - 6033 Overtime Pay/Premium 11,625 6,610 15,000 - (15,000) 6039 Standby Pay/Premium 350 - - - - 6048 Salaries/Language Pay 3,595 3,565 2,400 2,400 - 6063 Salaries/Jury Duty 220 - - - - 6072 Salaries / Injury 2,250 45 - - - 6101 PERS/Employee Contribution 37,470 39,210 38,710 39,965 1,255 6105 PERS/Employer Contribution 66,810 67,215 64,605 65,930 1,325 6109 PARS/Employer Contribution 12,550 13,000 13,950 12,770 (1,180) 6125 FICA/Employer Contrib/Med 9,435 9,720 11,020 10,890 (130) 6140 Life Insurance Allocation 1,960 1,760 1,550 1,510 (40) 6155 Workers' Comp Allocation 21,920 22,680 24,875 23,730 (1,145) 6160 LTD Insurance Allocation 5,405 4,770 4,255 4,395 140 6165 Unemployment Allocation 585 605 750 750 - 6175 Benefits/Flex Plan 127,885 136,145 157,290 157,635 345 6199 Benefits/Other - - 20,300 - (20,300) Subtotal 832,750 859,570 944,080 910,925 (33,155) Customer Records & Collections 6003 Salaries/Regular 578,775 628,800 703,645 731,915 28,270 6006 Salaries/Temp & Part Time 35,720 75,725 81,150 95,435 14,285 6012 Salaries/Comp-Time 80 875 - - - 6015 Salaries/Vacation 32,835 37,515 - - - 6024 Salaries/Sick Leave 21,860 20,815 - - - 6027 Salaries Bereavement 580 740 - - - 6033 Overtime Pay/Premium 3,325 4,265 15,000 15,000 - 6045 Salaries/Education Incentive 905 905 900 900 - 6048 Salaries/Language Pay 10,400 18,685 13,200 13,080 (120) 6063 Salaries/Jury Duty 515 150 - - - 6072 Salaries/Injury - 430 - - - 343 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 6091 Leave Liability Adjustment 25,635 19,990 - - - 6101 PERS/Employee Contribution 48,060 55,195 51,310 52,595 1,285 6105 PERS/Employer Contribution 85,660 94,595 85,615 86,725 1,110 6109 PARS/Employer Contribution 13,340 14,660 18,950 18,575 (375) 6125 FICA/Employer Contrib/Med 10,270 11,870 14,045 14,250 205 6133 Retiree Health Premium Reimb 7,655 7,740 8,305 9,070 765 6140 Life Insurance Allocation 2,405 2,260 2,055 1,985 (70) 6155 Workers' Comp Allocation 27,350 31,495 33,260 34,240 980 6160 LTD Insurance Allocation 6,615 6,055 5,480 5,685 205 6165 Unemployment Allocation 755 875 1,040 1,085 45 6175 Benefits/Flex Plan 179,905 195,390 226,730 224,355 (2,375) 6180 Deferred Comp/Employer Paid 540 540 540 540 - 6199 Benefits/Other - - 23,000 - (23,000) Subtotal 1,093,185 1,229,570 1,284,225 1,305,435 21,210 Employee Related 6003 Salaries/Regular 113,210 110,535 127,010 107,955 (19,055) 6015 Salaries/Vacation 8,320 7,725 - - - 6024 Salaries/Sick Leave 2,675 5,350 - - - 6063 Salaries/Jury Duty - 595 - - - 6101 PERS/Employee Contribution 9,325 9,040 8,920 7,585 (1,335) 6105 PERS/Employer Contribution 16,640 15,510 14,910 12,525 (2,385) 6109 PARS/Employer 1,875 7,055 8,140 6,920 (1,220) 6125 FICA/Employer Contrib/Med 2,195 2,155 2,050 1,750 (300) 6140 Life Insurance Allocation 495 415 360 285 (75) 6155 Workers' Comp Allocation 5,315 5,235 5,080 4,320 (760) 6160 LTD Insurance Allocation 1,315 1,110 990 840 (150) 6165 Unemployment Allocation 110 125 140 120 (20) 6175 Benefits/Flex Plan 13,105 13,745 14,270 12,795 (1,475) 6180 Deferred Comp/Employer Paid 1,080 1,740 1,800 1,530 (270) Subtotal 175,660 180,335 183,670 156,625 (27,045) PERSONNEL SUBTOTAL 2,629,870 2,868,350 2,978,890 2,965,330 (13,560) 344 Cost 3140701xxx, 3140702xxx, 3140711xxx, 6220 $1,500 6230 $750 6235 $25,000 6415 $128,600 6493 $195,670 6564 $4,800 continued Training Schools - American Public Power Association training workshops on finance, rate setting and utility accounting; workshops sponsored by the California Municipal Utilities Association; and other work related training as deemed necessary by Utilities Administration and Customer Services Division. ($500 for Admin Svcs; $1,000 for Cust Svcs) Dues/Subscriptions - California Municipal Utilities Association, Southern California Public Power Authority, American Public Power Association, and Customer Service Newsletter for CSR's. ($250 for Admin Svcs; $500 for Cust Svcs) Meeting/Conferences - Meeting/Conferences - California Municipal Utilities Association (CMUA) Annual Conference and Board meetings, CMUA Capitol Day, CMUA Utility Managers Summit, American Public Power Association (APPA) conferences, APPA Legislative Rally, Southern California Public Power Association (SCPPA) Congressional Tour, San Gabriel Valley Water Committee (SGVWC) Meeting, American Water Works Association (AWWA) Conference, Three Valley Water Municipal Water District Meeting, Light & Water Key Accounts Meeting, Northern California Power Agency (NCPA) Annual Meeting and Strategic Workshop, Lodi Energy Center (LEC), Transmission Agency of Northern California (TANC) Anniversary, CAISO Stakeholder Symposium, Public Officials Workshop, State of the City, National League of Cities Conference, Executive Steering Committee, and Users' meeting of Customer Information System service provider, S&S, and NACM conference. ($7,100 for UB; $8,100 for Admin Svcs; $9,800 for Cust Svcs) Computer Software Services - Customer Service Program-related expenses, including Customer Information System maintenance, phone system maintenance, and various software licenses. ($128,600 for Cust Svcs) Outside Services & Repairs - Pest Control Services, Office Equipment repair services, Iron Mountain archive, locksmith services, Itron maintenance, Verizon - TOU customer modem bills, FSR Nextel cell phones, after hours answering service, lockbox, bill print and mail and online billing services, armored car service, temporary employment agency, and customer communications. ($7,370 for Admin Svcs; $189,400 for Cust Svcs) Supplies/Medical-Dental - Anticipates purchase of Automated External Defibrillator (AED), training, & program management per Director and other first aid and medical supplies. ($3,800 for Admin Svcs; $1,000 for Cust Svcs). LIGHT & WATER - CONSUMER SERVICES ACTIVITY DETAIL Account Number Description 345 CostAccount Number Description 6601 $4,200 6815 $26,000 6825 $10,000 6835 $50,300 6915 $7,100 7050 $59,905 Maintenance & Repair of Building - Light & Water Office building roof annual maintenance, 2nd floor elevator lobby remodeling, and other miscellaneous repairs ($26,000 for Admin Svcs) Advertising Expense - Recreation Gym Decal, City's Civic Leadership, and miscellaneous. ($4,200 for Admin Svcs) Maintenance & Repair of Vehicles - Meter Reader trucks: Car wash and tires-$5,000; Truck body repairs- $5,000 Maintenance & Repair of Equipment - Azusa Light & Water heating, ventilation and air conditioning (HVAC) equipment (including water chiller compressors replacement), elevator, waterfall, outdoor LED electronic sign, automatic doors, ice machine, drinking fountains, drive-thru window equipment, and office equipment maintenance and repairs ($35,000 for Admin Svcs; $15,300 for Cust Svcs) Donations/Contributions - Azusa Chamber of Commerce, Winter Festival by Recreation & Family Services Dept., Golden Week Taste of Town, Job Shadow Day Sponsorship, and other miscellaneous donations desired by the Utility Board. ($54,700 for UB & Admin Svcs) Utilities/Telephone - Cell phone charges. ($2,000 for Admin Svcs; $5,100 for Cust Svcs) 346 BUDGET UNIT: ALL FUND 31 DIVISIONS-CONSUMER SERVICES (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 OPERATIONS 6201 Uniforms & Laundry 16,635 12,780 21,000 16,000 (5,000) 6210 Employee Awards - 110 1,000 500 (500) 6215 Tuition Reimbursement - - 3,500 2,000 (1,500) 6220 Training Schools 2,180 2,365 4,000 1,500 (2,500) 6230 Dues & Subscriptions 525 450 1,000 750 (250) 6235 Meetings & Conferences 25,885 7,590 26,000 25,000 (1,000) 6301 Legal Fees 18,730 14,250 22,000 16,500 (5,500) 6399 Professional Services/Other 2,390 15,505 22,500 22,500 - 6415 Computer Software Support - 63,500 125,200 128,600 3,400 6423 Administrative Allocation 1,079,960 1,114,035 1,260,475 1,276,000 15,525 6430 Custodial Services 14,235 4,130 15,000 15,000 - 6493 Outside Services & Repairs 177,955 151,765 242,600 195,670 (46,930) 6518 Postage 133,780 167,900 180,000 170,000 (10,000) 6521 Messenger Service 430 655 1,000 975 (25) 6530 Office Supplies 15,545 14,190 16,800 15,800 (1,000) 6539 Printing, Binding & Duplicating 14,250 15,590 32,300 21,500 (10,800) 6551 Fuel and Oil 18,375 16,070 18,500 18,000 (500) 6554 Supplies/Custodial & Cleaning 2,695 2,885 4,000 4,000 - 6563 Supplies/Special 8,880 7,625 11,850 15,210 3,360 6564 Supplies/Medical-Dental 940 910 2,000 4,800 2,800 6566 Small Tools 240 275 3,000 3,000 - 6569 Small Equipment 3,665 8,115 12,500 5,000 (7,500) 6570 Computer Peripherals/Misc - 240 1,000 500 (500) 6572 Office Furniture & Equipment 2,810 5,245 9,000 4,000 (5,000) 6601 Advertising Expense - 3,170 2,000 4,200 2,200 6615 Safety & Security Services Exp 11,290 10,865 12,500 12,500 - 6625 Program Expense 108,110 - - - - 6670 IT Allocation 537,305 494,315 515,165 519,085 3,920 6740 Claims Expense/Liability 358,260 358,260 358,260 394,085 35,825 6805 Maintenance/Land Improvements 14,610 16,295 18,000 16,400 (1,600) 6815 Maint & Repairs/Bldgs 81,880 52,760 33,000 26,000 (7,000) 6825 Maint & Repair / Vehicle 9,090 14,530 9,000 10,000 1,000 6827 Garage Allocation 580 790 5,000 1,000 (4,000) 347 BUDGET UNIT: ALL FUND 31 DIVISIONS-CONSUMER SERVICES (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 6835 Maint & Repair/Equipment 29,950 25,580 57,200 50,300 (6,900) 6840 Rent/Office Furniture & Equip 4,400 3,890 5,000 4,500 (500) 6904 Utilities/Other 5,750 6,635 10,000 10,000 - 6915 Utilities/Telephone 4,925 5,045 7,200 7,100 (100) 7009 Bank Service Charges 985 2,485 2,000 1,000 (1,000) 7050 Donations/Contribution 58,150 53,435 57,440 59,905 2,465 7075 Fee Collection Expense 6,950 3,370 3,000 1,000 (2,000) OPERATIONS SUBTOTAL 2,772,340 2,677,605 3,130,990 3,079,880 (51,110) TRANSFERS OUT 5950 Transfers Out 135,805 195,810 195,515 194,245 (1,270) TRANSFERS OUT SUBTOTAL 135,805 195,810 195,515 194,245 (1,270) CONSUMER SERVICE FUND TOTAL: 5,538,015 5,741,765 6,305,395 6,239,455 (65,940) 348 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 OPERATIONS Utility Board 6235 Meetings & Conferences 5,820 2,005 6,480 7,100 620 6301 Legal Fees 13,520 11,580 10,000 10,000 - 6521 Messenger Service 255 240 250 275 25 6670 IT Allocation - 7,355 18,000 18,000 - Subtotal 19,595 21,180 34,730 35,375 645 Utility Administration 6399 Professional Services - 12,000 - - - Subtotal - 12,000 - - - Consumer Services - Administrative 6220 Training Schools 1,120 350 1,140 500 (640) 6230 Dues & Subscriptions 250 - 500 250 (250) 6235 Meetings & Conferences 10,050 5,540 8,100 8,100 - 6301 Legal Fees 1,320 - 2,000 1,500 (500) 6399 Professional Services/Other 2,390 3,505 22,500 22,500 - 6493 Outside Services & Repairs 975 1,730 1,000 1,000 - 6521 Messenger Service 75 205 250 250 - 6530 Office Supplies 5,265 2,475 6,000 5,000 (1,000) 6539 Printing, Binding & Duplicating 235 595 800 500 (300) 6551 Fuel and Oil - 1,755 500 - (500) 6563 Supplies/Special 1,800 2,520 2,500 2,500 - 6564 Supplies/Medical-Dental 260 315 500 3,800 3,300 6569 Small Equipment - - 380 - (380) 6570 Computer Peripherals/Misc - 240 1,000 500 (500) 6572 Office Furniture & Equipment - 1,580 2,840 2,000 (840) 6601 Advertising Expense - 3,170 2,000 4,200 2,200 6915 Utilities/Telephone 910 1,180 2,000 2,000 - 7050 Donations/Contribution 58,150 53,435 57,440 59,905 2,465 Subtotal 82,800 78,595 111,450 114,505 3,055 349 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 Utilities - Administration 6423 Administrative Allocation 1,079,960 1,114,035 1,260,475 1,276,000 15,525 6740 Claims Expense/Liability 358,260 358,260 358,260 394,085 35,825 Subtotal 1,438,220 1,472,295 1,618,735 1,670,085 51,350 General Plant - Maintenance 6430 Custodial Services 14,235 4,130 15,000 15,000 - 6493 Outside Services & Repairs 1,910 4,005 5,700 5,270 (430) 6554 Supplies/Custodial & Cleaning 2,695 2,885 4,000 4,000 - 6563 Supplies/Special 630 105 1,350 1,210 (140) 6615 Safety & Security Services Exp 11,290 10,790 12,500 12,500 - 6805 Maintenance/Land Improvements 14,610 16,295 18,000 16,400 (1,600) 6815 Maint & Repairs/Bldgs 81,880 52,760 33,000 26,000 (7,000) 6835 Maint & Repair/Equipment 24,475 19,225 39,480 35,000 (4,480) 6840 Rent/Office Furniture & Equip 3,805 3,890 5,000 4,500 (500) 6904 Utilities/Other 5,750 6,635 10,000 10,000 - Subtotal 161,280 120,720 144,030 129,880 (14,150) Field Services 6201 Uniforms & Laundry 4,265 3,440 11,000 6,000 (5,000) 6235 Meetings & Conferences 4,405 - 3,240 1,200 (2,040) 6493 Outside Services & Repairs 10,065 20,495 21,700 20,000 (1,700) 6518 Postage 1,020 5 - - - 6521 Messenger Service 100 210 250 250 - 6539 Printing, Binding & Duplicating 870 - 1,500 1,000 (500) 6551 Fuel and Oil 18,375 14,315 18,000 18,000 - 6563 Supplies/Special 5,510 4,965 7,000 9,000 2,000 6566 Small Tools 240 275 3,000 3,000 - 6569 Small Equipment - - 3,790 - (3,790) 6825 Maint & Repair / Vehicle 9,090 14,530 9,000 10,000 1,000 6827 Garage Allocation 580 790 5,000 1,000 (4,000) 6915 Utilities/Telephones - 175 - - - Subtotal 54,520 59,200 83,480 69,450 (14,030) 350 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 Customer Records & Collections 6201 Uniforms & Laundry 12,260 9,165 10,000 10,000 - 6235 Meetings & Conferences - 25 - - - 6415 Computer Software Services - 63,500 125,200 128,600 3,400 6493 Outside Services & Repairs 155,055 124,295 198,200 167,400 (30,800) 6518 Postage 132,760 167,895 180,000 170,000 (10,000) 6521 Messenger Service - - 250 200 (50) 6530 Office Supplies 10,280 11,715 10,800 10,800 - 6539 Printing, Binding & Duplicating 1,645 900 5,000 5,000 - 6563 Supplies/Special 940 35 500 2,000 1,500 6566 Small Tools - - - - - 6569 Small Equipment 3,665 8,115 8,330 5,000 (3,330) 6572 Office Furniture & Equipment 2,810 3,665 6,160 2,000 (4,160) 6615 Safety and Security - 75 - - - 6625 Program Expense 93,110 - - - - 6670 IT Allocation 537,305 486,960 497,165 501,085 3,920 6835 Maint & Repair/Equipment 5,475 6,355 17,720 15,300 (2,420) 6840 Rent/Office Furniture & Equip 595 - - - - 6915 Utilities/Telephone 4,015 3,690 5,200 5,100 (100) 7009 Bank Service Charges 985 2,485 2,000 1,000 (1,000) 7075 Fee Collection Expense 6,950 3,370 3,000 1,000 (2,000) Subtotal 967,850 892,245 1,069,525 1,024,485 (45,040) Employee Related 6201 Uniforms & Laundry 110 175 - - - 6210 Employee Awards - 110 1,000 500 (500) 6215 Tuition Reimbursement - - 3,500 2,000 (1,500) 6220 Training Schools 1,060 2,015 2,860 1,000 (1,860) 6230 Dues & Subscriptions 275 450 500 500 - 6235 Meetings & Conferences 5,610 20 8,180 8,600 420 6301 Legal Fees 3,890 2,670 10,000 5,000 (5,000) 351 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 6493 Outside Services & Repairs 9,950 1,240 16,000 2,000 (14,000) 6539 Printing, Binding & Duplicating 11,500 14,095 25,000 15,000 (10,000) 6563 Supplies/Special - - 500 500 - 6564 Supplies/Medical-Dental 680 595 1,500 1,000 (500) 6625 Program Expense 15,000 - - - - Subtotal 48,075 21,370 69,040 36,100 (32,940) OPERATIONS SUBTOTAL 2,772,340 2,677,605 3,130,990 3,079,880 (51,110) TRANSFERS OUT Promotion/Membership 5950 Transfers Out 75,805 75,720 77,695 75,775 (1,920) Subtotal 75,805 75,720 77,695 75,775 (1,920) Customer Care & Solutions - Administration 5950 Transfers Out 60,000 93,785 94,660 94,660 - Subtotal 60,000 93,785 94,660 94,660 - Customer Records and Collections 5950 Transfers Out - 7,555 8,160 8,810 650 Subtotal - 7,555 8,160 8,810 650 Employee Related Expenses 5950 Transfers Out - 18,750 15,000 15,000 - Subtotal - 18,750 15,000 15,000 - TRANSFERS OUT SUBTOTAL 135,805 195,810 195,515 194,245 (1,270) CONSUMER SERVICE FUND TOTAL: 5,538,015 5,741,765 6,305,395 6,239,455 (65,940) 352 LIGHT AND WATER WATER UTILITY PROGRAM COMMENTARY PROGRAM DESCRIPTION: Water Utility is the division of Light and Water that is responsible for supplying water to its customers through the production of water from groundwater wells, surface water treatment, and the purchase of treated and untreated imported water. The Water Production side of the Water Utility operates a 12 million gallon per day (MGD) water filtration plant at the mouth of San Gabriel Canyon, which treats water from the San Gabriel River consisting of naturally occurring water and untreated imported water. The Water Distribution side of the Water Utility operates, maintains, and repairs a water distribution system consisting of nearly 300 miles of water pipeline of various sizes, valves, and fire hydrants serving a population of approximately 103,000 in the cities of Azusa, Glendora, Covina, West Covina, Irwindale, and Los Angeles County. The Water Utility has a main replacement program in which a set number of miles of water main are replaced each year for reasons of age, excessive repair requirement and inadequate flow. Water Operations also responds to customer inquiries and requests, and encourages water conservation through various programs. The new Treatment Plant is designed to ultimately produce16 MGD and meet future water quality standards. STRATEGIC GOALS: • Ensure reliable and efficient water production and distribution operations and strive to provide excellent service to our customers. • Meet or exceed all regulatory requirements and goals for water supply quality and adequacy. • Provide reliable service and high quality water to our customers. FY 10-11 PROGRAM HIGHLIGHTS: • Continue to institute the capital improvements to the water distribution system called for by the Year 2005 Water Master Plan Update. • Operate the new Water Treatment Plant (WTP) Upgrade in an efficient and cost effective manner. • Assist the developers of projects in the system service area in their efforts to complete their projects. • Continue to urge the proper use and conservation of water within the Azusa Light & Water water system. • Continue to seek means to enhance the Azusa Light & Water water supply to provide reliability and sustainability of water supply. 353 Budget Division: LIGHT AND WATER - WATER (ALL) FY 09-10 FY 10-11 FY 09-10 FY 10-11 FY 09-10 FY 10-11 FY 09-10 FY 10-11 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Hours Hours Wages Wages Assistant Director-Water Operations 1.00 1.00 $127,010 $127,010 Water System Engineer 1.00 1.00 90,320 87,740 Associate Engineer 1.00 1.00 96,475 96,475 Office Specialist II 1.00 1.00 37,410 40,050 Business Dev/Pub Benefit Prog Coord(a)0.30 0.30 23,985 23,985 Water Production Supervisor 1.00 1.00 95,195 97,345 Water Production Operator III 4.00 4.00 276,920 284,920 Water Production Operator II 2.00 2.00 127,900 130,720 Water System Administrator 1.00 1.00 62,665 62,665 Water Distribution Supervisor 1.00 1.00 93,395 96,445 Water Distribution Crew Supervisor 2.00 2.00 156,650 160,180 Water Distribution Services Specialist 1.00 1.00 70,210 71,860 Welder 1.00 1.00 61,975 65,600 Water Distribution Equipment Operator 2.00 2.00 128,350 133,240 Water Distribution Worker II 3.00 3.00 160,325 172,205 Water Distribution Worker I 4.00 4.00 190,195 196,175 Welder/Water Dist Worker I 1.00 1.00 55,355 59,425 (a) .70 FTE Public Benefits TOTAL 27.30 27.30 $1,854,335 $1,906,040 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 354 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 PERSONNEL 6003 Salaries/Regular 1,283,140 1,482,955 1,854,335 1,906,040 51,705 6012 Salaries/Comp-Time 18,555 28,790 - - - 6015 Salaries/Vacation 74,805 105,660 - - - 6024 Salaries/Sick Leave 59,520 50,285 - - - 6027 Salaries/Bereavement 840 2,285 - - - 6030 Overtime Pay/Regular 11,805 5,180 13,000 17,000 4,000 6033 Overtime Pay/Premium 135,405 87,205 125,000 140,000 15,000 6039 Standby Pay/Premium 71,400 68,070 75,000 75,000 - 6045 Salaries/Education Incentive 4,195 4,885 4,590 9,990 5,400 6048 Salaries/Language Pay 4,815 6,120 4,800 8,400 3,600 6063 Salaries/Jury Duty 1,455 320 - - - 6072 Salaries/Injury 19,565 13,440 - - - 6087 Const Contra/WO Labor (4,275) - - - - 6091 Leave Liability Adjustments 49,765 40,250 - - - 6101 PERS/Employee Contribution 103,800 119,940 131,275 135,520 4,245 6105 PERS/Employer Contribution 188,885 205,630 219,155 223,595 4,440 6109 PARS/Employer Contribution 28,920 39,395 44,195 45,365 1,170 6125 FICA/Employer Contrib/Med 26,735 29,725 35,120 36,740 1,620 6133 Retiree Health Premium Reimb 6,705 8,145 7,110 9,070 1,960 6140 Life Insurance Allocation 5,590 5,430 5,260 5,115 (145) 6155 Workers' Comp Allocation 65,415 72,015 83,480 86,255 2,775 6160 LTD Insurance Allocation 15,040 14,745 14,430 14,830 400 6165 Unemployment Allocation 1,715 1,945 2,535 2,625 90 6175 Benefits/Flex Plan 315,040 374,095 462,360 467,025 4,665 6180 Deferred Comp/Employer Paid 2,070 3,045 3,960 3,960 - 6199 Benefits/Other - - 52,400 - (52,400) PERSONNEL SUBTOTAL 2,490,905 2,769,555 3,138,005 3,186,530 48,525 355 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 PERSONNEL City Water 6003 Salaries/Regular 222,800 239,235 375,200 375,260 60 6015 Salaries/Vacation 12,970 14,830 - - - 6024 Salaries/Sick Leave 6,100 5,270 - - - 6027 Salaries/Bereavement - 1,725 - - - 6045 Salaries/Education Incentive 1,460 1,940 1,890 1,890 - 6087 Const Contra/WO Labor (4,275) - - - - 6063 Salaries/Jury Duty 355 110 - - - 6091 Leave Liability Adjustments 49,765 40,250 - - - 6101 PERS/Employee Contribution 17,125 18,490 26,540 26,545 5 6105 PERS/Employer Contribution 30,555 31,720 44,320 43,805 (515) 6109 PARS/Employer Contribution 1,770 8,240 9,680 9,680 - 6125 FICA/Employer Contrib/Med 4,050 4,400 6,355 6,405 50 6133 Retiree Health Premium Reimb 6,705 8,145 7,110 9,070 1,960 6140 Life Insurance Allocation 910 830 1,060 1,000 (60) 6155 Workers' Comp Allocation 9,745 10,615 15,085 15,085 - 6160 LTD Insurance Allocation 2,530 2,275 2,920 2,920 - 6165 Unemployment Allocation 250 265 440 440 - 6175 Benefits/Flex Plan 36,200 38,075 61,350 64,735 3,385 6180 Deferred Comp/Employer Paid 2,070 3,045 3,960 3,960 - Subtotal 401,085 429,460 555,910 560,795 4,885 Production - Source of Supply 6003 Salaries/Regular 469,025 504,740 562,680 575,650 12,970 6012 Salaries/Comp-Time 815 1,415 - - - 6015 Salaries/Vacation 34,385 40,270 - - - 6024 Salaries/Sick Leave 10,725 8,940 - - - 6027 Salaries/Bereavement - 560 - - - 6030 Overtime Pay/Regular 4,915 4,935 10,000 13,000 3,000 6033 Overtime Pay/Premium 17,910 22,745 25,000 40,000 15,000 6039 Standby Pay/Premium 36,195 36,410 40,000 40,000 - 6045 Salaries/Education Incentive 2,130 2,110 2,100 5,100 3,000 6048 Salaries/Language Pay 3,610 3,635 3,600 3,600 - 356 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 6063 Salaries/Jury Duty 640 - - - - 6072 Salaries/Injury - 9,340 - - - 6101 PERS/Employee Contribution 34,605 40,685 40,020 41,135 1,115 6105 PERS/Employer Contribution 65,500 69,755 66,820 67,880 1,060 6109 PARS/Employer Contribution 10,435 11,650 13,805 14,100 295 6125 FICA/Employer Contrib/Med 9,495 10,695 11,585 11,845 260 6140 Life Insurance Allocation 1,935 1,835 1,605 1,550 (55) 6155 Workers' Comp Allocation 22,305 24,670 26,180 27,095 915 6160 LTD Insurance Allocation 5,325 4,950 4,380 4,480 100 6165 Unemployment Allocation 580 660 780 820 40 6175 Benefits/Flex Plan 105,230 119,405 139,340 139,600 260 6199 Benefits/Other - - 19,400 - (19,400) Subtotal 835,760 919,405 967,295 985,855 18,560 Transmission/Distribution 6003 Salaries/Regular 591,315 738,980 916,455 955,130 38,675 6012 Salaries/Comp-Time 17,740 27,375 - - - 6015 Salaries/Vacation 27,450 50,560 - - - 6024 Salaries/Sick Leave 42,695 36,075 - - - 6027 Salaries/Bereavement 840 - - - - 6030 Overtime Pay/Regular 6,890 245 3,000 4,000 1,000 6033 Overtime Pay/Premium 117,495 64,460 100,000 100,000 - 6039 Standby Pay/Premium 35,205 31,660 35,000 35,000 - 6045 Salaries/Education Incentive 605 835 600 3,000 2,400 6048 Salaries/Language Pay 1,205 2,485 1,200 4,800 3,600 6063 Salaries/Jury Duty 460 210 - - - 6072 Salaries/Injury 19,565 4,100 - - - 6101 PERS/Employee Contribution 52,070 60,765 64,715 67,840 3,125 6105 PERS/Employer Contribution 92,830 104,155 108,015 111,910 3,895 6109 PARS/Employer Contribution 16,715 19,505 20,710 21,585 875 6125 FICA/Employer Contrib/Med 13,190 14,630 17,180 18,490 1,310 6140 Life Insurance Allocation 2,745 2,765 2,595 2,565 (30) 6155 Workers' Comp Allocation 33,365 36,730 42,215 44,075 1,860 357 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 6160 LTD Insurance Allocation 7,185 7,520 7,130 7,430 300 6165 Unemployment Allocation 885 1,020 1,315 1,365 50 6175 Benefits/Flex Plan 173,610 216,615 261,670 262,690 1,020 6199 Beneftis/Other - - 33,000 - (33,000) Subtotal 1,254,060 1,420,690 1,614,800 1,639,880 25,080 PERSONNEL SUBTOTAL 2,490,905 2,769,555 3,138,005 3,186,530 48,525 358 THIS PAGE INTENTIONALLY LEFT BLANK 359 Cost 3240721xxx, 3240722xxx, 3240723xxx, 6220 $12,500 6230 $77,850 6231 $200,000 6235 $2,250 6493 $853,500 6563 $2,213,500 6625 $148,500 7001 $3,370,925 Training Schools - Federal and California Occupational Safety and Health Act (OSHA) Safety training, American Water Works Association training in areas of Valve Flushing and Excavation; Operational Support Tools (OSTS) Hazardous Materials training. California Specialized Training Institute (CSTI). LIGHT & WATER - WATER ACTIVITY DETAIL Account Number Description Dues/Subscriptions - San Gabriel Valley Water Association, American Water Works Association, San Gabriel Valley Protective Association, Building News International (Green Book), Engineering News Record, Urban Water Institute, Department of Health Drinking Water, Azusa Agriculture Water Charge. Meetings/Conferences - California Municipal Utilities Association Annual Conference, San Gabriel Valley Water Association meetings, San Gabriel Basin Water Association meetings, San Gabriel Valley Water Association Legislative Committee, Three Valleys meetings. State and Congressional Rep Meetings. San Gabriel Valley Protective Association. Program Expenses - Costs associated with DRiP Program to promote drought resistant landscapes and water conserving irrigation systems. Some costs include promotion of mandatory water conservation measures if these continue to be necessary. Outside Assessment - Assessments from outside water entities, such as the Water Quality Authority, Committee of 9, Watermaster, and Protective Association. Outside Services & Repairs - Design Engineers, Civil Engineers and other vendors necessary to maintain water production and distribution system. Interest Expense - Debt Service on 2003 Certificates of Participation which refinanced the purchase costs associated with buy out of Azusa Valley Water Company. Amount also includes interest only payments on the 2006 Revenue Parity Bonds, which were issued to finance construction of new water treatment plant and other major infrastructure such as reservoirs. Supplies Special - Purchased water costs and other supplies to treat water. Costs are expected to be lower due to continued conservation and carryover water rights from prior year conservation. These costs are difficult to forecast and may change depending on a number of variables. 360 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 OPERATIONS 6201 Uniforms & Laundry 12,375 15,640 17,500 17,500 - 6215 Tuition Reimbursement 105 - 1,000 1,000 - 6220 Training Schools 67,870 8,200 15,000 12,500 (2,500) 6230 Dues & Subscriptions 15,860 36,805 77,850 77,850 - 6231 Outside Assessments 127,765 116,565 300,000 200,000 (100,000) 6235 Meetings & Conferences 1,190 665 3,250 2,250 (1,000) 6253 Licenses/Certifications 2,310 1,800 7,500 7,500 - 6301 Legal Fees 142,710 15,690 135,000 130,000 (5,000) 6320 Fiscal Agent Fees - 1,500 1,500 1,500 - 6345 Program Consultants 6,455 - - - - 6399 Professional Services - 32,395 - - - 6424 Consumer Services Allocation 3,625,660 3,866,570 4,085,025 4,055,645 (29,380) 6430 Custodial Services 5,200 1,285 10,000 7,500 (2,500) 6493 Outside Services & Repairs 618,550 649,410 875,000 853,500 (21,500) 6506 Periodicals 10 - - - - 6518 Postage 2,500 3,855 2,500 2,500 - 6521 Messenger Service 1,250 675 1,500 1,500 - 6527 Supplies/Computer 680 390 5,000 5,000 - 6530 Office Supplies 4,480 4,465 10,050 6,000 (4,050) 6539 Printing, Binding & Duplicating 58,560 21,265 38,300 38,300 - 6551 Fuel and Oil 52,215 45,720 48,500 48,500 - 6554 Supplies/Custodial 2,070 2,585 6,250 4,000 (2,250) 6560 Repair Parts 1,950 3,330 24,000 11,500 (12,500) 6563 Supplies/Special 3,343,740 1,718,060 3,427,000 2,213,500 (1,213,500) 6564 Supplies/Medical-Dental 1,405 1,885 2,500 3,000 500 6566 Small Tools 3,700 4,765 8,500 8,500 - 6569 Small Equipment 101,940 57,040 200,000 125,000 (75,000) 6572 Office Furniture & Equipment - 33,585 5,000 2,250 (2,750) 6601 Advertising Expense 300 - 3,000 2,000 (1,000) 6605 Filing Costs 6,090 9,240 3,000 3,500 500 6625 Program Expense 137,660 116,555 148,500 148,500 - 6801 Rent/Land 5,220 2,610 7,500 1,500 (6,000) 6805 Maintenance/Land Improvements 19,955 16,295 57,500 30,000 (27,500) 361 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 6815 Maint & Repairs/Bldgs 4,830 7,305 20,000 21,500 1,500 6825 Maintenance Repair Vehicle 42,240 46,005 42,250 42,250 - 6827 Garage Allocation 2,070 535 750 750 - 6830 Rent/Equipment 200 215 14,600 7,100 (7,500) 6835 Maint & Repair/Equipment 9,255 11,920 10,000 12,000 2,000 6904 Utilities/Other 939,045 824,920 1,100,000 1,100,000 - 6905 Utilities/Electricity 47,375 56,870 150,000 150,000 - 6910 Utilities/Natural Gas 920 780 5,500 5,500 - 6915 Utilities/Telephone 11,930 12,270 12,000 13,500 1,500 7001 Interest Expense 3,384,910 3,361,365 3,312,435 3,370,925 58,490 7009 Bank Service Charge 4,000 2,500 2,500 2,500 - 7010 Franchise Fee (2%) 322,540 283,995 358,155 390,665 32,510 7013 Water Rights Lease Expense 1,234,990 1,326,105 1,326,110 1,392,415 66,305 7015 Tax/Property 2,190 3,035 4,000 4,000 - 7055 Uncollectible Accounts 40,395 54,270 60,000 45,000 (15,000) 7080 Uncollectible Accounts - 1,405 - - - OPERATIONS SUBTOTAL 14,416,665 12,782,340 15,945,525 14,579,900 (1,365,625) TRANSFERS OUT 5950 Transfer Out 1,449,165 835,975 8,000 200,000 192,000 TRANSFERS OUT SUBTOTAL 1,449,165 835,975 8,000 200,000 192,000 WATER FUND TOTAL: 18,356,735 16,387,870 19,091,530 17,966,430 (1,125,100) 362 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 OPERATIONS City Water 7080 Refund - 1,405 - - - Subtotal - 1,405 - - - Taxes 7010 Franchise Fee (2%) 322,540 283,995 358,155 390,665 32,510 7015 Tax/Property 2,190 3,035 4,000 4,000 - Subtotal 324,730 287,030 362,155 394,665 32,510 Interest Expense 7001 Interest Expense 3,384,910 3,361,365 3,312,435 3,370,925 58,490 Subtotal 3,384,910 3,361,365 3,312,435 3,370,925 58,490 Administrative & General 6320 Fiscal Agent Fees - 1,500 1,500 1,500 - 6424 Consumer Services Allocation 3,625,660 3,866,570 4,085,025 4,055,645 (29,380) 7009 Bank Service Charge 4,000 2,500 2,500 2,500 - Subtotal 3,629,660 3,870,570 4,089,025 4,059,645 (29,380) Miscellaneous 6220 Training Schools 250 705 7,500 5,000 (2,500) 6230 Dues & Subscriptions 4,235 5,090 7,500 7,500 - 6235 Meetings & Conferences 1,165 515 3,000 2,000 (1,000) 6539 Printing, Binding & Duplicating 48,885 13,810 27,500 27,500 - 6625 Program Expense 137,660 116,555 148,500 148,500 - 7055 Uncollectible Accounts 40,395 54,270 60,000 45,000 (15,000) Subtotal 232,590 190,945 254,000 235,500 (18,500) Office Supplies & Other Expenses 6220 Training School - 225 - - - 6230 Meetings & Conferences - 80 - - - 6527 Supplies/Computer/Small Equip - - 1,500 1,500 - 6530 Office Supplies 170 430 900 570 (330) 363 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 6563 Supplies/Special 10 45 1,000 1,000 - 6569 Small Equipment - - 660 540 (120) 6601 Advertising Expense 300 - 3,000 2,000 (1,000) 6825 Maintenance & Repair/Vehicle 95 - 750 750 - 6830 Rent/Equipment - - 100 100 - 6915 Utilities/Telephone 415 420 1,000 1,000 - Subtotal 990 1,200 8,910 7,460 (1,450) Employee Related 6201 Uniforms & Laundry 12,280 15,640 17,500 17,500 - 6215 Tuition Reimbursement 105 - 1,000 1,000 - 6220 Training Schools 67,620 7,270 7,500 7,500 - 6230 Dues & Subscriptions 250 225 350 350 - 6235 Meetings & Conferences 25 150 - - - 6253 Licenses/Certifications 2,310 1,800 7,500 7,500 - 6301 Legal Fees - - 10,000 5,000 (5,000) 6563 Supplies/Special 200 - 1,000 1,000 - 6564 Supplies/Medical-Dental 1,405 1,610 2,500 3,000 500 6825 Maintenance & Repair/Vehicle 75 - 1,500 1,500 - Subtotal 84,270 26,695 48,850 44,350 (4,500) Regulatory Commission 6493 Outside Services & Repairs 425 530 3,000 3,000 - 6551 Fuel and Oil 2,195 5,200 3,500 3,500 - 6605 Filing Costs 20 50 500 500 - Subtotal 2,640 5,780 7,000 7,000 - Outside Services 6201 Uniforms & Laundry 95 - - - - 6301 Legal Fees 142,710 15,690 125,000 125,000 - 6345 Program Consultants 6,455 - - - - 6399 Professional Services - 32,395 - - 6493 Outside Services & Repairs 8,270 16,805 53,000 40,000 (13,000) Subtotal 157,530 64,890 178,000 165,000 (13,000) 364 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 Transportation 6493 Outside Services & Repairs 2,865 - 5,000 5,000 - 6551 Fuel and Oil 50,020 40,520 45,000 45,000 - 6560 Repair Parts 15 1,495 2,500 1,340 (1,160) 6563 Supplies/Special 400 715 1,500 1,500 - 6569 Small Equipment 5,065 765 3,300 2,670 (630) 6825 Maintenance & Repair/Vehicle 42,070 46,005 40,000 40,000 - 6827 Garage Allocation 2,070 535 750 750 - 6835 Maint & Repair/Equipment - 130 4,000 4,000 - Subtotal 102,505 90,165 102,050 100,260 (1,790) Production - Supervision & Engineering 6235 Meetings & Conferences - - 250 250 - 6493 Outside Services & Repairs 29,190 29,400 35,000 35,000 - 6518 Postage 2,500 3,855 2,500 2,500 - 6521 Messenger Service 1,250 465 1,250 1,250 - 6527 Supplies/Computer/Small Equip 150 390 2,000 2,000 - 6530 Office Supplies 1,965 1,355 2,550 1,630 (920) 6539 Printing, Binding & Duplicating 8,915 7,455 10,000 10,000 - 6554 Supplies/Custodial & Cleaning 275 665 1,250 670 (580) 6563 Supplies/Special 1,300 3,205 2,000 2,000 - 6569 Small Equipment 70 75 7,530 6,080 (1,450) 6572 Office Furniture & Equipment - 32,280 4,000 1,500 (2,500) 6830 Rent/Equipment 170 210 8,000 4,000 (4,000) 6915 Utilities/Telephone 8,240 8,765 7,500 7,500 - Subtotal 54,025 88,120 83,830 74,380 (9,450) Purchased Water 6230 Dues & Subscriptions 11,375 31,410 70,000 70,000 - 6231 Outside Assessments 127,765 116,565 300,000 200,000 (100,000) 6493 Outside Services & Repairs 60,770 60,770 50,000 50,000 - 6563 Supplies/Special 2,889,080 1,242,525 2,750,000 1,500,000 (1,250,000) 7013 Water Rights Lease Expense 1,234,990 1,326,105 1,326,110 1,392,415 66,305 Subtotal 4,323,980 2,777,375 4,496,110 3,212,415 (1,283,695) 365 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 Maintenance of Structures & Improvements 6493 Outside Services & Repairs 1,670 13,010 5,000 5,000 - 6554 Supplies/Custodial 65 125 1,000 670 (330) 6563 Supplies/Special 365 200 1,000 1,000 - 6569 Small Equipment - - 660 540 (120) 6805 Maintenance/Land Improvements 16,405 14,260 20,000 10,400 (9,600) 6815 Maint & Repairs/Bldgs 1,440 1,440 1,000 1,000 - Subtotal 19,945 29,035 28,660 18,610 (10,050) Maintenance of Reservoirs 6493 Outside Services & Repairs 19,090 16,720 25,000 25,000 - 6563 Supplies/Special - 12,140 10,000 10,000 - Subtotal 19,090 28,860 35,000 35,000 - Maintenance of Wells 6493 Outside Services & Repairs 52,915 10,080 175,000 175,000 - 6563 Supplies/Special 3,790 2,885 17,500 17,500 - 6569 Small Equipment 20,335 235 49,500 39,970 (9,530) Subtotal 77,040 13,200 242,000 232,470 (9,530) Fuel or Power Purchase 6904 Utilities/Other 939,045 824,920 1,100,000 1,100,000 - 6905 Utilities/Electricity 47,375 56,870 150,000 150,000 - 6910 Utilities/Natural Gas 920 780 5,500 5,500 - Subtotal 987,340 882,570 1,255,500 1,255,500 - Maintenance of Pumps/Boosters 6493 Outside Services & Repairs 12,400 26,130 70,000 70,000 - 6560 Repair Parts - - 500 280 (220) 6563 Supplies/Special 825 630 5,000 5,000 - Subtotal 13,225 26,760 75,500 75,280 (220) 366 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 Chemicals & Filtering Materials 6493 Outside Services & Repairs - - 10,000 10,000 - 6563 Supplies/Special 159,475 222,875 400,000 400,000 - Subtotal 159,475 222,875 410,000 410,000 - Maintenance of Structure & Improvements (Filter Plant) 6430 Custodial Services - - 5,000 3,750 (1,250) 6493 Outside Services & Repairs 7,490 710 10,000 30,000 20,000 6530 Office Supplies 25 - 910 580 (330) 6554 Supplies/Custodial 750 555 2,000 1,330 (670) 6563 Supplies/Special 1,320 8,195 7,500 7,500 - 6815 Maint & Repairs/Bldgs 535 1,115 1,000 2,500 1,500 Subtotal 10,120 10,575 26,410 45,660 19,250 Maintenance of Water Treatment Equipment 6493 Outside Services & Repairs 7,030 16,045 30,000 40,000 10,000 6563 Supplies/Special 8,085 15,245 20,000 20,000 - 6569 Small Equipment 11,655 13,935 13,200 10,650 (2,550) Subtotal 26,770 45,225 63,200 70,650 7,450 Supervision & Engineering 6521 Messenger Service - 210 250 250 - 6527 Supplies/Computer 530 - 1,500 1,500 - 6530 Office Supplies 1,765 1,460 3,640 2,330 (1,310) 6539 Printing, Binding & Duplicating 760 - 800 800 - 6563 Supplies/Special 2,250 15 1,000 1,000 - 6569 Small Equipment 215 - - - - 6572 Office Furniture & Equipment - 1,305 1,000 750 (250) 6815 Maint & Repairs/Bldgs - 15 500 500 - 6830 Rent/Equipment 30 5 3,000 1,500 (1,500) 6915 Utilities/Telephone 3,275 3,085 3,500 5,000 1,500 Subtotal 8,825 6,095 15,190 13,630 (1,560) 367 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 Storage Facilities 6530 Office Supplies 20 - 450 - (450) 6563 Supplies/Special 895 - 2,500 2,500 - 6830 Rent/Equipment - - 3,500 1,500 (2,000) Subtotal 915 - 6,450 4,000 (2,450) Transmission & Distribution 6493 Outside Services & Repairs - - 1,500 1,500 - 6530 Office Supplies - - 200 - (200) 6563 Supplies/Special 705 - 5,000 5,000 - Subtotal 705 - 6,700 6,500 (200) Meter 6563 Supplies/Special 197,770 145,860 100,000 150,000 50,000 6569 Small Equipment 61,715 38,465 120,200 60,560 (59,640) Subtotal 259,485 184,325 220,200 210,560 (9,640) Customer Installation 6493 Outside Services & Repairs 10,715 5,730 15,000 1,500 (13,500) 6560 Repair Parts - - 2,500 800 (1,700) 6563 Supplies/Special - - 15,000 1,500 (13,500) Subtotal 10,715 5,730 32,500 3,800 (28,700) Maintenance of Structures & Improvements 6430 Custodial Services 5,200 1,285 5,000 3,750 (1,250) 6493 Outside Services & Repairs 30 1,920 12,500 12,500 - 6530 Office Supplies 535 1,220 1,400 890 (510) 6554 Supplies/Custodial 980 1,240 2,000 1,330 (670) 6563 Supplies/Special 3,820 1,800 3,000 3,000 - 6564 Supplies/Medical - 275 - - - 6805 Maintenance/Land Improvements 3,550 2,035 37,500 19,600 (17,900) 6815 Maint & Repairs/Bldgs 2,855 4,735 17,500 17,500 - Subtotal 16,970 14,510 78,900 58,570 (20,330) 368 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 Maintenance of Transmission & Distribution Mains 6493 Outside Services & Repairs 395,015 440,010 275,000 275,000 - 6506 Periodicals 10 - - - - 6560 Repair Parts 345 70 2,500 1,330 (1,170) 6563 Supplies/Special 62,515 43,045 50,000 50,000 - 6566 Small Tools 2,745 3,555 4,500 4,500 - 6569 Small Equipment 1,720 2,505 3,300 2,660 (640) 6605 Filing Costs 6,070 9,190 2,500 3,000 500 6801 Rent/Land 5,220 2,610 7,500 1,500 (6,000) 6835 Maint & Repair/Equipment 7,365 10,485 5,000 5,000 - Subtotal 481,005 511,470 350,300 342,990 (7,310) Maintenance of Services 6560 Repair Parts 1,180 1,695 2,500 1,330 (1,170) 6563 Supplies/Special 3,845 12,130 15,000 15,000 - 6566 Small Tools 830 525 1,000 1,000 - 6835 Maint & Repair/Equipment 1,370 35 500 500 - Subtotal 7,225 14,385 19,000 17,830 (1,170) Maintenance of Meters 6493 Outside Services & Repairs 10,650 11,550 100,000 75,000 (25,000) 6560 Repair Parts - 25 7,500 3,200 (4,300) 6563 Supplies/Special 2,270 165 1,500 1,500 - 6566 Small Tools - - 500 500 - Subtotal 12,920 11,740 109,500 80,200 (29,300) Maintenance of Hydrants 6560 Repair Parts 130 10 5,000 2,680 (2,320) 6563 Supplies/Special 3,035 285 7,500 7,500 - Subtotal 3,165 295 12,500 10,180 (2,320) 369 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 Maintenance of Miscellaneous Plants 6493 Outside Services & Repair 25 - - - - 6560 Repair Parts 280 35 1,000 540 (460) 6563 Supplies/Special 1,785 6,100 10,000 10,000 - 6566 Small Tools 125 685 2,500 2,500 - 6569 Small Equipment 1,165 1,060 1,650 1,330 (320) 6835 Maint & Repair/Equipment 520 1,270 500 2,500 2,000 Subtotal 3,900 9,150 15,650 16,870 1,220 OPERATIONS SUBTOTAL 14,416,665 12,782,340 15,945,525 14,579,900 (1,365,625) TRANSFERS OUT General 5950 Transfer Out 1,401,665 835,975 - 195,000 195,000 Subtotal 1,401,665 835,975 - 195,000 195,000 Administrative & General 5950 Transfer Out 47,500 - 8,000 5,000 (3,000) Subtotal 47,500 - 8,000 5,000 (3,000) TRANSFERS OUT SUBTOTAL 1,449,165 835,975 8,000 200,000 192,000 WATER FUND TOTAL:18,356,735 16,387,870 19,091,530 17,966,430 (1,125,100) 370 LIGHT & WATER ELECTRIC UTILITY PROGRAM COMMENTARY PROGRAM DESCRIPTION: Electric Utility consists of Power Resources Management, Engineering and Electric Operations. Power Resource Management is responsible for short-term and long-term power resource planning and procurement; daily power resource scheduling and trading; after-the- fact financial settlements with trading counterparties, bill processing; participation in state and federal regulatory processes representing City’s interest; regulatory and legislative monitoring, reporting, and compliance; financial planning; 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 construction 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 following 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 and General Order 165 Inspection Cycles for Electric Distribution Facilities. STRATEGIC GOALS: The goals of Power Resources Management include: (1) ensuring reliable and efficient power resource infrastructure planning and procurement in a cost-effective and environmental responsible manner; (2) ensuring timely compliance with financial, regulatory and legislative directives, including reporting, information dissemination, auditing, and program evaluation; and (3) ensuring long-term stable and competitive retail electric rates. Engineering’s main goal is to ensure reliability of electric service through overall planning, construction of necessary improvement projects, and standardizing the methods and equipment used in constructing utility infrastructure and services. Engineering also seeks to manage capital improvement projects effectively with consideration to project timing, bid completion, compliance with approved plans and specifications, and that fees collected are used to pay for utility-related services per customer applications. 371 STRATEGIC GOALS: (continued) The goals of Electric Operations include: (1) construction, maintenance and improvement of the electric utility infrastructure; (2) compliance with state regulations for the construction and inspection of power lines per State of California General Orders 95, 128 and 165; (3) Maintaining programs that contribute to the electric system reliability, such as, infrared inspections, electric line clearance (tree trimming) and equipment inspections; and (4) Continue to provide excellent service to residential and commercial customers in a timely and professional manner. FY 10-11 PROGRAM HIGHLIGHTS: Power Resources (a) has made significant progress toward the Renewable Portfolio Standard of 20% renewable energy by 2010 with the operations of Garnet Wind Project in Palm Springs; and we are continuing to explore additional renewable energy opportunities through SCPPA and on our own; (b) continues to participate in the Lodi #2 Project development process led by NCPA, the project is currently focused in obtaining all the necessary permits, and preparing the Project Participation Agreement and the financing for the Project; (c) continues to be fully engaged in the transition to the California Independent System Operator’s new market structures currently anticipated to commence on April 1, 2009, internal scheduling process is in place for the new market structure, we are currently refining the financial settlement processing required by the new market paradigm; (d) explore opportunities to diversify our resource portfolio consistent with the anticipated greenhouse gas mandates; and (e) continues to cost effectively procure economic power resources to our customers reliably. Engineering will perform project planning and solicit contract for the new Supervisory Control and Substation Data Acquisition System. This new SCADA project will provide remote monitoring and control of substation circuit breakers and serve as a core business/operating tool to help achieve reliable and efficient field operations. Engineering will continue project planning for any new underground electric line extensions within downtown north Azusa including any future assessment of electricity needs for the redevelopment of downtown area. At Kirkwall Substation a newly constructed underground electric line extension along Gladstone Avenue will be energized to pick up reconfigured customer loads along Azusa Avenue, Cerritos and Citrus Avenue north of Arrow Highway. Engineering will lead overall planning and support for the Electric Division’s program application towards obtaining a Reliable Public Power Provider (RP3) designation from the American Public Power Association. Engineering will continue planning for electric infrastructure projects that will support the 20 year Specific Plan expansion at Azusa Pacific University, including the construction of underground line extensions and improvements at various locations, such as Foothill Boulevard and Alameda Avenue, Dalton Avenue and Foothill Boulevard, Azusa Avenue and 9th Street for the proposed Target Store Project, and Palm Drive Boulevard south of 9th Street. Electric Operations will continue General Order 165 Inspection & Maintenance Program. This program consists of an annual inspection patrol of Azusa electric system and is followed up by a more detailed inspection of over 6,000 major pieces of equipment and structures on a rotation schedule, repairs are scheduled accordingly. The electric crews will continue installing the electric facilities to support new and existing commercial and residential developments as needed, such as services to the new Target Store, and continue to replace or upgrade overhead open wire secondary bus lines and house services to triplex conductors and to replace older existing underground primary cables that are reaching the end of their life span. 372 THIS PAGE INTENTIONALLY LEFT BLANK 373 Budget Division: LIGHT AND WATER - ELECTRIC (ALL) FY 09-10 FY 10-11 FY 09-10 FY 10-11 FY 09-10 FY 10-11 FY 09-10 FY 10-11 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Hours Hours Wages Wages Assistant Director-Electric Operations 1.00 1.00 $133,930 $115,200 Power Res Tech 2080 0 $48,550 $0 Electric Distribution Supervisor 1.00 1.00 112,685 115,185 Electric Crew Supervisor 3.00 3.00 299,180 309,030 Line Mechanic 5.00 5.00 438,780 462,640 Line Mechanic Helper 1.00 1.00 65,570 65,570 Apprentice Line Mechanic 2.00 2.00 145,930 150,630 Senior Electric Test Technician 1.00 1.00 93,110 95,220 Electrical Test Technician 1.00 1.00 84,700 86,640 Apprentice Elec Test Technician 1.00 1.00 64,405 68,900 Senior Office Specialist 1.00 1.00 38,295 40,080 Senior Electrical Engineer 1.00 1.00 121,195 121,195 Electrical Engineer 1.00 1.00 101,850 104,065 Assistant Director-Resource Management 1.00 1.00 145,960 144,160 Power Resources Coordinator 1.00 1.00 112,140 112,140 Power Resources Scheduler 1.00 1.00 98,535 98,535 TOTAL 22.00 22.00 $2,056,265 $2,089,190 TOTAL 2,080 0 $48,550 $0 Full Time Positions Part Time Positions 374 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 PERSONNEL 6003 Salaries/Regular 1,593,600 1,687,820 2,056,265 2,089,190 32,925 6006 Salaries/Temp & Part Time 3,100 18,605 48,550 - (48,550) 6012 Salaries/Comp-Time 40,300 29,650 - - - 6015 Salaries/Vacation 113,430 114,645 - - - 6024 Salaries/Sick Leave 50,385 60,915 - - - 6027 Salaries/Bereavement 8,165 2,165 - - - 6030 Overtime Pay/Regular 16,950 9,175 21,500 21,500 - 6033 Overtime Pay/Premium 195,420 175,900 236,000 238,000 2,000 6039 Standby Pay/Premium 44,510 42,290 55,000 55,000 - 6045 Salaries/Education Incentive 5,890 8,080 7,310 5,855 (1,455) 6048 Salaries/Language Pay 6,025 6,025 6,000 6,000 - 6063 Salaries/Jury Duty 4,270 4,835 - - - 6101 PERS/Employee Contribution 123,920 137,525 145,825 148,030 2,205 6105 PERS/Employer Contribution 221,045 236,035 243,425 244,185 760 6108 PARS/Administration Fees 15,500 - - - - 6109 PARS/Employer Contribution 33,785 60,855 64,200 68,855 4,655 6125 FICA/Employer Contrib/Med 28,135 29,465 35,055 36,795 1,740 6133 Retiree Health Premium Reimb 3,270 4,180 3,565 5,165 1,600 6140 Life Insurance Allocation 6,730 5,960 5,820 5,580 (240) 6155 Workers' Comp Allocation 78,920 82,990 96,005 96,620 615 6160 LTD Insurance Allocation 18,545 16,215 16,005 16,255 250 6165 Unemployment Allocation 2,065 2,160 2,800 2,530 (270) 6175 Benefits/Flex Plan 272,080 293,850 361,080 368,080 7,000 6180 Deferred Comp/Employer Paid 6,210 9,780 10,080 10,080 - 6199 Benefits/Other - - 45,000 - (45,000) PERSONNEL SUBTOTAL 2,892,250 3,039,120 3,459,485 3,417,720 (41,765) 375 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 PERSONNEL Distribution Operations-Supervision & Engineering 6003 Salaries/Regular 201,115 206,355 246,615 230,385 (16,230) 6012 Salaries/Comp-Time - 210 - - - 6015 Salaries/Vacation 30,870 27,240 - - - 6024 Salaries/Sick Leave 6,930 7,425 - - - 6027 Salaries/Bereavement 1,520 - - - - 6030 Overtime Pay/Regular 520 1,085 1,000 1,000 - 6033 Overtime Pay/Premium 5,320 11,290 14,690 16,000 1,310 6039 Standby Pay/Premium 4,100 7,690 10,000 10,000 - 6045 Salaries/Education Incentive 300 300 300 300 - 6063 Salaries/Jury Duty - 4,160 - - - 6101 PERS/Employee Contribution 17,645 17,990 17,340 16,205 (1,135) 6105 PERS/Employer Contribution 31,480 30,865 28,985 26,760 (2,225) 6108 PARS/Administration Fee 15,500 - - - - 6109 PARS/Employer Contribution 4,490 10,350 11,130 9,990 (1,140) 6125 FICA/Employer Contribution - - 100 2,280 2,180 6133 Retiree Health Premium Reimb 3,270 4,180 3,565 5,165 1,600 6140 Life Insurance Allocation 930 815 700 610 (90) 6155 Workers' Comp Allocation 10,245 10,770 10,895 10,305 (590) 6160 LTD Insurance Allocation 2,445 2,105 1,920 1,790 (130) 6165 Unemployment Allocation 230 245 305 290 (15) 6175 Benefits/Flex Plan 27,405 28,995 31,745 32,570 825 6180 Deferred Comp/Employer Paid 1,080 1,740 1,800 1,800 - 6199 Benefits/Other - - 4,600 - (4,600) Subtotal 365,395 373,810 385,690 365,450 (20,240) Distribution Operations-Overhead Lines 6003 Salaries/Regular 343,390 374,755 474,730 493,935 19,205 6012 Salaries/Comp-Time 20,130 14,640 - - - 6015 Salaries/Vacation 17,325 23,200 - - - 6024 Salaries/Sick Leave 15,610 21,480 - - - 6027 Salaries/Bereavement 1,575 490 - - - 6030 Overtime Pay/Regular 8,095 4,045 10,000 10,000 - 376 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 6033 Overtime Pay/Premium 94,005 74,195 107,720 108,000 280 6039 Standby Pay/Premium 20,205 17,300 22,500 22,500 - 6045 Salaries/Education Incentive 605 605 600 600 - 6048 Salaries/Language Pay 1,205 1,205 1,200 1,200 - 6063 Salaries/Jury Duty 1,965 - - - - 6101 PERS/Employee Contribution 25,605 31,540 33,675 35,020 1,345 6105 PERS/Employer Contribution 45,665 54,170 56,150 57,710 1,560 6109 PARS/Employer Contribution 9,730 9,750 10,730 11,165 435 6125 FICA/Employer Contrib/Med 8,355 8,430 10,530 10,620 90 6140 Life Insurance Allocation 1,445 1,360 1,335 1,315 (20) 6155 Workers' Comp Allocation 18,625 19,445 23,965 25,450 1,485 6160 LTD Insurance Allocation 4,035 3,755 3,695 3,845 150 6165 Unemployment Allocation 525 545 715 730 15 6175 Benefits/Flex Plan 69,360 76,260 95,885 96,320 435 6199 Benefits/Other - - 16,700 - (16,700) Subtotal 707,455 737,170 870,130 878,410 8,280 Distribution Operations-Underground Lines 6003 Salaries/Regular 343,385 374,750 474,730 493,935 19,205 6012 Salaries/Comp-Time 20,130 14,640 - - - 6015 Salaries/Vacation 17,325 23,200 - - - 6024 Salaries/Sick Leave 15,610 21,480 - - - 6027 Salaries/Bereavement 1,575 490 - - - 6030 Overtime Pay/Regular 8,095 4,045 10,000 10,000 - 6033 Overtime Pay/Premium 94,005 74,195 102,820 103,000 180 6039 Standby Pay/Premium 20,205 17,300 22,500 22,500 - 6045 Salaries/Education Incentive 605 605 600 600 - 6048 Salaries/Language Pay 1,205 1,205 1,200 1,200 - 6063 Salaries/Jury Duty 1,965 - - - - 6101 PERS/Employee Contribution 25,605 31,540 33,675 35,020 1,345 6105 PERS/Employer Contribution 45,665 54,170 56,150 57,710 1,560 6109 PARS/Employer Contribution 9,730 9,750 10,730 11,165 435 6125 FICA/Employer Contrib/Med 8,355 8,430 10,460 10,550 90 6140 Life Insurance Allocation 1,445 1,360 1,335 1,315 (20) 6155 Workers' Comp Allocation 18,625 19,445 23,830 25,250 1,420 377 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 6160 LTD Insurance Allocation 4,035 3,755 3,695 3,845 150 6165 Unemployment Allocation 525 545 710 725 15 6175 Benefits/Flex Plan 69,360 76,260 95,885 96,320 435 6180 Deferred Comp/Employer Paid - - - - 6199 Benefits/Other - - 16,700 - (16,700) Subtotal 707,450 737,165 865,020 873,135 8,115 Distribution Operations-Meters 6003 Salaries/Regular 149,375 157,505 242,215 250,760 8,545 6012 Salaries/Comp-Time 40 160 - - - 6015 Salaries/Vacation 16,360 16,485 - - - 6024 Salaries/Sick Leave 5,100 3,870 - - - 6027 Salaries/Bereavement - 1,185 - - - 6030 Overtime Pay/Regular 240 - 500 500 - 6033 Overtime Pay/Premium 2,090 14,440 9,790 10,000 210 6048 Salaries/Language Pay 1,205 1,205 1,200 1,200 - 6063 Salaries/Jury-Duty 340 - - - - 6101 PERS/Employee Contribution 12,320 12,880 17,125 17,725 600 6105 PERS/Employer Contribution 21,975 22,090 28,605 29,255 650 6109 PARS/Employer Contribution 3,960 4,145 5,475 5,665 190 6125 FICA/Employer Contrib/Med 1,375 1,600 2,925 2,930 5 6140 Life Insurance Allocation 640 575 685 675 (10) 6155 Workers' Comp Allocation 6,955 7,565 10,300 10,500 200 6160 LTD Insurance Allocation 1,755 1,550 1,885 1,950 65 6165 Unemployment Allocation 180 200 305 65 (240) 6175 Benefits/Flex Plan 28,445 30,290 51,955 52,540 585 6199 Benefits/Other - - 7,000 - (7,000) Subtotal 252,355 275,745 379,965 383,765 3,800 Distribution Operations-Miscellaneous Distribution 6003 Salaries/Regular 39,305 40,995 38,295 40,080 1,785 6015 Salaries/Vacation 4,820 1,395 - - - 6024 Salaries/Sick Leave 2,940 1,265 - - - 6033 Overtime Pay/Premium - - 980 1,000 20 6101 PERS/Employee Contribution 3,550 3,440 2,710 2,835 125 378 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 6105 PERS/Employer Contribution 6,325 5,890 4,515 4,670 155 6125 FICA/Employer Contrib/Med 845 855 775 815 40 6140 Life Insurance Allocation 190 150 110 105 (5) 6155 Workers' Comp Allocation 2,015 1,810 1,555 1,645 90 6160 LTD Insurance Allocation 500 405 300 310 10 6165 Unemployment Allocation 55 55 55 55 - 6175 Benefits/Flex Plan 12,635 13,500 14,270 15,055 785 6180 Deferred Comp/Employer Paid 540 540 540 540 - Subtotal 73,720 70,300 64,105 67,110 3,005 Engineering 6003 Salaries/Regular 189,880 195,870 223,045 225,260 2,215 6015 Salaries/Vacation 15,430 16,000 - - - 6024 Salaries/Sick Leave 1,745 1,485 - - - 6027 Salaries/Bereavement 1,735 - - - - 6045 Salaries/Education Incentive 1,460 3,650 2,905 2,905 - 6101 PERS/Employee Contribution 14,765 15,240 15,875 16,030 155 6105 PERS/Employer Contribution 26,345 26,140 26,530 26,470 (60) 6109 PARS/Employer Contribution 2,150 11,940 7,770 14,440 6,670 6125 FICA/Employer Contrib/Med 3,295 3,445 3,690 3,745 55 6140 Life Insurance Allocation 785 570 635 605 (30) 6155 Workers' Comp Allocation 8,410 8,815 9,040 9,125 85 6160 LTD Insurance Allocation 2,165 1,545 1,735 1,755 20 6165 Unemployment Allocation 195 160 255 260 5 6175 Benefits/Flex Plan 26,025 27,560 28,535 30,110 1,575 6180 Deferred Comp/Employer Paid 1,890 3,480 3,600 3,600 - Subtotal 296,275 315,900 323,615 334,305 10,690 Power Purchases-Other Expenses 6003 Salaries/Regular 327,150 337,590 356,635 354,835 (1,800) 6006 Salaries/Temp & Part Time 3,100 18,605 48,550 - (48,550) 6015 Salaries/Vacation 11,300 7,125 - - - 6024 Salaries/Sick Leave 2,450 3,910 - - - 6027 Salaries/Bereavement 1,760 - - - - 6033 Overtime Pay/Premium - 1,780 - - - 379 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 6045 Salaries/Education Incentive 2,920 2,920 2,905 1,450 (1,455) 6048 Salaries/Language Pay 2,410 2,410 2,400 2,400 - 6063 Salaries/Jury Duty - 675 - - - 6101 PERS/Employee Contribution 24,430 24,895 25,425 25,195 (230) 6105 PERS/Employer Contribution 43,590 42,710 42,490 41,610 (880) 6109 PARS/Employer Contribution 3,725 14,920 18,365 16,430 (1,935) 6125 FICA/Employer Contrib/Med 5,910 6,705 6,575 5,855 (720) 6140 Life Insurance Allocation 1,295 1,130 1,020 955 (65) 6155 Workers' Comp Allocation 14,045 15,140 16,420 14,345 (2,075) 6160 LTD Insurance Allocation 3,610 3,100 2,775 2,760 (15) 6165 Unemployment Allocation 355 410 455 405 (50) 6175 Benefits/Flex Plan 38,850 40,985 42,805 45,165 2,360 6180 Deferred Comp/Employer Paid 2,700 4,020 4,140 4,140 - Subtotal 489,600 529,030 570,960 515,545 (55,415) PERSONNEL SUBTOTAL 2,892,250 3,039,120 3,459,485 3,417,720 (41,766) 380 THIS PAGE INTENTIONALLY LEFT BLANK 381 Cost 6220 $7,760 6230 $10,000 6235 $8,200 6493 $3,509,295 6590 $25,264,120 6625 $300,000 7130 $70,000 7140 $430,000 7145 $485,000Lines, Mains & Sewers - Underground cable and overhead conductors and subfeeds to residential and commercial buildings. Dues & Subscriptions - California Municipal Utilities Association (CMUA), California Utilities Emergency Association (CUEA), Barclays Law Publications Subscription, Electric Safety Orders (Updates). ($10,000 Distribution). Outside Services - Cost for third party and California Independent System Operator (CAISO) transmission services; real time electric load scheduling/dispatching services ($3,306,995). Other services to support electric distribution system ($202,300). Electricity for Resale - Purchase of electricity for distribution and sale to retail customers. Increase in costs reflect higher natural gas prices and market pricing through CAISO. Structures & Other - Includes poles, towers and fixtures – anything that supports overhead lines; substation structures; and underground structures including pull boxes and vaults. Equipment & Machinery - Includes transformers, switches, power equipment, street light equipment, substation equipment such as breakers and panels and laboratory equipment. 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. 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. ($2,500 Distribution; $5,260 Power Resources). 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. ($100 Distribution; $100 Engineering; $8,000 Power Resources). LIGHT & WATER - ELECTRIC ACTIVITY DETAIL Account Number Description 3340733xxx, 3340735xxx, 3340745xxx, 3340775xxx, 3340785xxx, 382 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 OPERATIONS 6201 Uniforms & Laundry 17,375 26,250 30,000 21,700 (8,300) 6215 Tuition Reimbursement - 2,720 - - - 6220 Training Schools 18,720 11,335 25,000 7,760 (17,240) 6225 Training Materials 1,500 1,365 1,500 900 (600) 6230 Dues & Subscriptions 7,895 8,525 10,000 10,000 - 6235 Meetings & Conferences 7,110 14,970 18,000 8,200 (9,800) 6240 Mileage Reimbursement 65 295 - - - 6301 Legal Fees 71,075 71,125 112,500 102,400 (10,100) 6340 Special Studies - 725 10,000 - (10,000) 6345 Program Consultants 1,835 2,550 20,000 3,200 (16,800) 6399 Professional Services/Other 705 - 10,000 - (10,000) 6424 Consumer Services Allocation 1,952,280 2,082,000 2,217,130 2,183,810 (33,320) 6430 Custodial Services 4,780 1,255 7,500 3,800 (3,700) 6493 Outside Services & Repairs 2,982,085 3,145,235 4,324,580 3,509,295 (815,285) 6521 Messenger Service 1,495 915 2,000 1,100 (900) 6530 Office Supplies 4,395 4,455 7,000 4,040 (2,960) 6539 Printing, Binding & Duplicating 280 110 1,000 80 (920) 6551 Fuel and Oil 21,290 21,780 20,000 17,500 (2,500) 6554 Supplies/Custodial & Cleaning 550 1,170 2,000 900 (1,100) 6563 Supplies/Special 43,270 40,490 55,000 25,300 (29,700) 6564 Supplies/Medical-Dental 2,460 2,430 2,500 2,200 (300) 6566 Small Tools 15,190 14,520 25,000 13,100 (11,900) 6569 Small Equipment 1,840 2,350 9,000 4,000 (5,000) 6590 Electricity For Resale 25,829,425 23,106,700 25,280,000 25,264,120 (15,880) 6601 Advertising Expense - 190 - - - 6610 Bond Administration - 5,000 - - - 6625 Program Expenses - 13,290 300,000 300,000 - 6805 Maint/Land Improvement 330 - - - - 6815 Maint & Repairs/Bldgs 11,535 18,250 25,000 17,600 (7,400) 6825 Maint & Repair / Vehicle 40,350 37,170 41,000 40,200 (800) 6827 Garage Allocation 3,230 2,370 5,000 3,800 (1,200) 6830 Rent/Equipment 35 20 150 150 - 6835 Maint & Repair/Equipment 7,590 6,985 20,000 1,200 (18,800) 6904 Utilities/Other 14,715 14,925 15,000 15,000 - 383 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 6905 Utilities / Electricity 8,815 10,200 10,000 5,700 (4,300) 6910 Utilities/Natural Gas - 350 1,500 700 (800) 6915 Utilities/Telephone 8,225 9,570 9,065 8,265 (800) 7001 Interest Expense 547,750 534,295 492,785 468,615 (24,170) 7009 Bank Service Charge 2,500 - 2,500 2,500 - 7010 Franchise Fee (2%) 606,015 636,740 639,640 691,255 51,615 7012 In-lieu Fee (8%) 2,424,065 2,546,965 2,558,555 2,765,005 206,450 7055 Uncollectible Accounts 76,725 105,320 110,000 70,000 (40,000) OPERATIONS SUBTOTAL 34,737,500 32,504,910 36,419,905 35,573,395 (846,510) CAPITAL OUTLAY 7130 Structures/Other 32,535 41,120 70,000 70,000 - 7135 Vehicles - 155,810 310,000 400,000 90,000 7140 Equipment & Machinery 475,275 293,335 430,000 430,000 - 7145 Lines, Mains & Sewers 554,385 393,655 485,000 485,000 - CAPITAL OUTLAY SUBTOTAL 1,062,195 883,920 1,295,000 1,385,000 90,000 TRANSFERS OUT 5950 Transfer Out 7,447,195 396,110 8,750 9,450 700 TRANSFERS OUT SUBTOTAL 7,447,195 396,110 8,750 9,450 700 ELECTRIC FUND TOTAL: 46,139,140 36,824,060 41,183,140 40,385,565 (797,575) 384 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 OPERATIONS Interest - Long-Term Debt 7001 Interest Expense 547,750 534,295 492,785 468,615 (24,170) Subtotal 547,750 534,295 492,785 468,615 (24,170) Distribution Operations-Supervision & Engineering 6530 Office Supplies 325 555 1,000 240 (760) 6539 Printing, Binding & Duplicating 200 110 1,000 80 (920) 6554 Supplies/Custodial & Cleaning 105 - - - - 6563 Supplies/Special 15 - - - - 6566 Small Tools 235 40 - - - Subtotal 880 705 2,000 320 (1,680) Distribution Operations-Overhead Lines 6530 Office Supplies 110 - - - - 6539 Printing, Binding & Duplicating 80 - - - - 6554 Supplies/Custodial & Cleaning 75 - - - - 6563 Supplies/Special 205 - - - - 6566 Small Tools 7,795 10,655 10,000 10,000 - Subtotal 8,265 10,655 10,000 10,000 - Distribution Operations-Underground Lines 6566 Small Tools 2,565 3,240 10,000 3,100 (6,900) Subtotal 2,565 3,240 10,000 3,100 (6,900) 385 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 Distribution Operations-Street Lighting & Signal 6905 Utilities / Electricity 8,815 10,200 10,000 5,700 (4,300) Subtotal 8,815 10,200 10,000 5,700 (4,300) Distribution Operations-Meters 6566 Small Tools 4,360 585 5,000 - (5,000) Subtotal 4,360 585 5,000 - (5,000) Distribution Operations-Miscellaneous Distribution 6201 Uniforms & Laundry 17,375 26,250 30,000 21,700 (8,300) 6220 Training Schools 11,720 10,455 16,450 2,500 (13,950) 6225 Training Materials 1,500 1,365 1,500 900 (600) 6230 Dues & Subscriptions 7,895 8,525 10,000 10,000 - 6235 Meetings & Conferences 2,085 3,060 5,000 100 (4,900) 6240 Mileage Reimbursement 65 295 - - - 6301 Legal Fees 8,190 11,270 12,500 2,400 (10,100) 6340 Special Studies - 725 - - - 6345 Program Consultants - - 10,000 - (10,000) 6521 Messenger Service 1,305 665 1,000 100 (900) 6530 Office Supplies 15 30 - - - 6551 Fuel and Oil 21,290 21,780 17,500 17,500 - 6563 Supplies/Special 8,890 19,035 10,000 5,600 (4,400) 6564 Supplies/Medical-Dental 2,460 2,430 2,500 2,200 (300) 6566 Small Tools 235 - - - - 6569 Small Equipment 245 545 5,000 - (5,000) 6601 Advertising Expense - 190 - - - 6815 Maint & Repairs/Bldgs 670 - - - - 6825 Maint & Repair / Vehicle 39,865 37,150 40,000 40,000 - 6827 Garage Allocation 3,230 2,370 5,000 3,800 (1,200) 6835 Maint & Repair/Equipment 3,870 5,960 10,000 - (10,000) 6904 Utilities/Other 14,715 14,925 15,000 15,000 - 6910 Utilities/Natural Gas - 350 1,500 700 (800) 6915 Utilities/Telephone 7,290 8,825 8,000 7,200 (800) Subtotal 152,910 176,200 200,950 129,700 (71,250) 386 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 Distribution Maintenance-Structures 6430 Custodial Services 4,780 1,255 7,500 3,800 (3,700) 6493 Outside Services & Repairs 2,125 4,320 10,000 2,600 (7,400) 6554 Supplies/Custodial & Cleaning 370 1,170 2,000 900 (1,100) 6805 Maint/Land Improvement 330 - - - - 6815 Maint & Repairs/Bldgs 10,865 18,250 25,000 17,600 (7,400) 6825 Maintenance and Repair - 20 - - - Subtotal 18,470 25,015 44,500 24,900 (19,600) Distribution Maintenance-Station Equipment 6493 Outside Services & Repairs 3,735 3,520 15,000 15,000 - 6563 Supplies/Special 9,385 2,905 10,000 1,100 (8,900) Subtotal 13,120 6,425 25,000 16,100 (8,900) Distribution Maintenance-Overhead Lines 6493 Outside Services & Repairs 124,640 137,340 175,000 175,000 - 6563 Supplies/Special 7,205 3,075 10,000 5,900 (4,100) 6835 Maint & Repair/Equipment 350 625 - - - Subtotal 132,195 141,040 185,000 180,900 (4,100) Distribution Maintenance-Underground Lines 6493 Outside Services & Repairs 7,505 16,450 25,000 9,700 (15,300) 6563 Supplies/Special 11,800 6,790 10,000 6,200 (3,800) 6835 Maint & Repair/Equipment 460 400 - - - Subtotal 19,765 23,640 35,000 15,900 (19,100) Distribution Maintenance-Transformer Lines 6493 Outside Services & Repairs - 20,950 15,000 - (15,000) Subtotal - 20,950 15,000 - (15,000) Distribution Maintenance-Street Lighting & Signals 6563 Supplies/Special 605 2,710 5,000 - (5,000) 6835 Maint & Repair/Equipment - - 5,000 - (5,000) Subtotal 605 2,710 10,000 - (10,000) 387 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 Distribution Maintenance-Meters 6563 Supplies/Special 5,165 5,975 10,000 6,500 (3,500) 6835 Maint & Repair/Equipment 2,910 - 5,000 1,200 (3,800) Subtotal 8,075 5,975 15,000 7,700 (7,300) Customer Accounts-Uncollectible Accounts 7055 Uncollectible Accounts 76,725 105,320 110,000 70,000 (40,000) Subtotal 76,725 105,320 110,000 70,000 (40,000) Engineering 6215 Tuition Reimbursement - 2,720 - - - 6220 Training Schools 6,315 880 3,290 - (3,290) 6235 Meetings & Conferences 2,495 3,000 5,000 100 (4,900) 6340 Special Studies - - 10,000 - (10,000) 6345 Program Consultants 1,835 2,550 10,000 3,200 (6,800) 6399 Professional Services/Other 705 - 10,000 - (10,000) 6530 Office Supplies 3,945 3,280 5,000 2,800 (2,200) 6551 Fuel and Oil - - 2,500 - (2,500) 6825 Maint & Repair / Vehicle 485 - 1,000 200 (800) Subtotal 15,780 12,430 46,790 6,300 (40,490) Operations Revenue-Purchased Power 6590 Electricity For Resale 25,829,425 23,106,700 25,280,000 25,264,120 (15,880) Subtotal 25,829,425 23,106,700 25,280,000 25,264,120 (15,880) Power Purchases-Other 6220 Training Schools 685 - 5,260 5,260 - 6235 Meetings & Conferences 2,530 8,910 8,000 8,000 - 6301 Legal Fees 62,885 59,855 100,000 100,000 - 6521 Messenger Service 190 250 1,000 1,000 - 6530 Office Supplies - 590 1,000 1,000 - 388 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 6569 Small Equipment 1,595 1,805 4,000 4,000 - 6625 Program Expenses - 13,290 300,000 300,000 - 6830 Rent/Equipment 35 20 150 150 - 6915 Utilities/Telephone 935 745 1,065 1,065 - Subtotal 68,855 85,465 420,475 420,475 - Transmission-System 6493 Outside Services & Repairs 589,035 590,350 735,200 656,170 (79,030) Subtotal 589,035 590,350 735,200 656,170 (79,030) Transmission-By Others 6493 Outside Services & Repairs 2,255,045 2,372,305 3,349,380 2,650,825 (698,555) Subtotal 2,255,045 2,372,305 3,349,380 2,650,825 (698,555) Administrative & General 6424 Consumer Services Allocation 1,952,280 2,082,000 2,217,130 2,183,810 (33,320) Subtotal 1,952,280 2,082,000 2,217,130 2,183,810 (33,320) Franchise Fees 7010 Franchise Fee (2%) 606,015 636,740 639,640 691,255 51,615 7012 In-lieu Fee (8%) 2,424,065 2,546,965 2,558,555 2,765,005 206,450 Subtotal 3,030,080 3,183,705 3,198,195 3,456,260 258,065 Interest Transfers 6610 Bond Administration - 5,000 - - - 7009 Bank Service Charge 2,500 - 2,500 2,500 - Subtotal 2,500 5,000 2,500 2,500 - OPERATIONS SUBTOTAL 34,737,500 32,504,910 36,419,905 35,573,395 (846,510) 389 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 CAPITAL OUTLAY Structures & Improvements 7130 Structures/Other 190 20 10,000 10,000 - Subtotal 190 20 10,000 10,000 - Station Equipment 7140 Equipment & Machinery - 4,860 25,000 25,000 - Subtotal - 4,860 25,000 25,000 - Poles, Towers & Fixtures 7130 Structures/Other 27,735 30,045 35,000 35,000 - 7140 Equipment & Machinery - 180 - - - 7145 Lines, Mains & Sewers 860 3,070 - - - Subtotal 28,595 33,295 35,000 35,000 - Overhead Conductors & Dev 7130 Structures/Other 105 1,560 - - - 7140 Equipment & Machinery 40 5 - - - 7145 Lines, Mains & Sewers 56,080 76,545 85,000 85,000 - Subtotal 56,225 78,110 85,000 85,000 - Underground Conduit 7130 Structures/Other 4,480 9,360 25,000 25,000 - 7140 Equipment & Machinery 70 100 - - - Subtotal 4,550 9,460 25,000 25,000 - Underground Conductors & Dev 7130 Structures/Other 25 5 - - - 7140 Equipment & Machinery 115 - - - - 7145 Lines, Mains & Sewers 497,445 314,040 400,000 400,000 - Subtotal 497,585 314,045 400,000 400,000 - 390 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 Line Transformers 7140 Equipment & Machinery 365,455 113,505 250,000 250,000 - Subtotal 365,455 113,505 250,000 250,000 - Meters 7140 Equipment & Machinery 77,995 145,845 90,000 90,000 - Subtotal 77,995 145,845 90,000 90,000 - Street Lighting 7130 Structures/Other - 130 - - - 7140 Equipment & Machinery 31,600 22,980 50,000 50,000 - Subtotal 31,600 23,110 50,000 50,000 - Transportation Equipment 7135 Vehicles - 155,810 310,000 400,000 90,000 Subtotal - 155,810 310,000 400,000 90,000 Tools, Shop Equipment 7140 Equipment & Machinery - 5,860 15,000 15,000 - Subtotal - 5,860 15,000 15,000 - CAPITAL OUTLAY SUBTOTAL 1,062,195 883,920 1,295,000 1,385,000 90,000 TRANSFERS OUT General 5950 Transfers Out 7,447,195 388,010 - - - Subtotal 7,447,195 388,010 - - - Dist Oper - Overhead Line Expenses 5950 Transfers Out - 4,050 4,375 4,725 350 Subtotal - 4,050 4,375 4,725 350 391 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #07-08 08-09 09-10 10-11 Dist Oper - Underground Line Expenses 5950 Transfers Out - 4,050 4,375 4,725 350 Subtotal - 4,050 4,375 4,725 350 TRANSFERS OUT SUBTOTAL 7,447,195 396,110 8,750 9,450 700 ELECTRIC FUND TOTAL: 46,139,140 36,824,060 41,183,140 40,385,565 (797,575) 392