Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
K. Light and Water
LIGHT AND WATER Public Benefit Programs Recycling and Solid Waste Consumer Services Water Utility Electric Utility 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 expend 2.85% of their retail revenues to fund investments in energy conservation and provides for establishment of a surcharge to collect such funds. The usage surcharge, referred to as the public benefit charge (PBC), is authorized to continue in effect until January 1, 2012 and in all likelihood will be extended by legislature before the sunset date. The Public Benefit program provides cost-effective demand-side management services to promote energy-efficiency and energy conservation; investment in renewable energy resources and technologies consistent with existing statutes and regulations; research, development and demonstration programs that advance science or technology which would not result from regulated competitive market environments; and services provided to low-income electricity customers, including but not limited to, targeted energy efficiency services and rate discounts. STRATEGIC GOALS: The Public Benefits fund has an accumulated a balance of about $2 million and the PBC is expected to generate an additional $750,000 during FY 2011-12. 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 11-12 PROGRAM HIGHLIGHTS: Several conservation programs have been developed over the years under the Public Benefits Program. 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, except for lighting retrofits which have a 100% incentive up to $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) Appliance Rebate Program for refrigerators, but under 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; and (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 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 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 Asst Director-Cust Care and Solutions(b)0.15 0.15 19,050 19,050 Customer Service Representative II 0.05 0.05 2,510 2,650 (a) .30 FTE Water (b) .85 FTE Consumer Services-Employee Expense (c) .95 FTE Consumer Services-Records & Collections TOTAL 0.90 0.90 $77,525 $77,665 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 326 BUDGET UNIT: 2440739xxx L&W PUBLIC BENEFIT PROGRAMS DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #08-09 09-10 10-11 11-12 VARIANCE PERSONNEL ADMINISTRATION OF PBC 6003 Salaries/Regular 50,800 51,920 77,525 77,665 140 6006 Salaries/Temp & Part-Time - 4,010 - - - 6015 Salaries/Vacation 3,665 3,745 - - - 6024 Salaries/Sick Leave - 565 - - - 6045 Salaries/Education Incentive 1,020 1,020 1,015 1,015 - 6048 Salaries/Language - - - 120 120 6101 PERS/Employee Contribution 3,920 4,025 5,595 5,610 15 6105 PERS/Employer Contribution 6,720 6,725 9,195 10,060 865 6109 PARS/Employer Contribution 3,070 3,820 4,810 4,805 (5) 6125 FICA/Employer Contrib/Med 975 1,040 1,340 1,355 15 6140 Life Insurance Allocation 180 150 205 205 - 6155 Workers' Comp Allocation 2,265 2,450 3,145 3,150 5 6160 LTD Insurance Allocation 490 440 605 605 - 6165 Unemployment Allocation 50 55 95 95 - 6175 Benefits/Flex Plan 9,990 10,085 13,670 14,335 665 6180 Deferred Comp/Employer Paid 1,245 1,260 1,260 1,530 270 SUBTOTAL 84,390 91,310 118,460 120,550 2,090 ENERGY EFFICIENCY PROGRAM 6006 Salaries/Temp & Part Time - 7,920 32,905 - (32,905) 6101 PERS/Employee Contribution - 265 - - - 6105 PERS/Employer Contribution - 435 - - - 6109 PARS/Employer - 155 - - - 6125 FICA/Employer Contrib/Med - 115 - - - 6155 Workers' Comp Allocation - 315 - - - 6165 Unemployment Allocation - 10 - - - SUBTOTAL - 9,215 32,905 - (32,905) PERSONNEL SUBTOTAL 84,390 100,525 151,365 120,550 (30,815) 327 Cost 2440739000 6625 $1,090,000 LIGHT & WATER - PUBLIC BENEFITS PROGRAM ACTIVITY DETAIL Account Number Description Program Expense - Low Income Assistance Program ($40,000), Energy Efficiency Program ($940,000), 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. #08-09 09-10 10-11 11-12 VARIANCE OPERATIONS RESIDENTIAL LOW INCOME 6625 Program Expense 28,525 31,570 40,000 40,000 - SUBTOTAL 28,525 31,570 40,000 40,000 - ENERGY EFFICIENCY PROGRAM 6625 Program Expense 236,610 605,555 800,830 940,000 139,170 SUBTOTAL 236,610 605,555 800,830 940,000 139,170 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 26,710 15,390 40,000 40,000 - 6825 Maint & Repair/Vehicle - - 7,200 7,200 - SUBTOTAL 26,710 15,390 48,200 48,200 - OPERATIONS SUBTOTAL 291,845 652,515 959,030 1,098,200 139,170 PUBLIC BENEFIT PROG FUND TOTAL 376,235 753,040 1,110,395 1,218,750 108,355 329 THIS PAGE INTENTIONALLY LEFT BLANK 330 LIGHT AND WATER RECYCLING AND SOLID WASTE PROGRAM COMMENTARY PROGRAM DESCRIPTION: Recycling and Solid Waste Management programs are managed by Administrative Division of the Utilities Department to ensure compliance with State laws. Refuse collection and recycling services are provided on a contract basis by Athens Services. Utilities Administration works closely with the Customer Service division on rate setting, billing, customer service and public information issues. Utilities Administration also administers two State-provided block grant programs (the Used Oil Recycling Block Grant and the Beverage Container Recycling Grant), and promotes use of reusable grocery 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. • Work with San Gabriel Valley Council of Governments to develop long term, low cost disposal options. FY 11-12 PROGRAM HIGHLIGHTS: • Prepare AB 939 report for calendar year 2010 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. • Promote use of reusable grocery bags and proper disposal of sharps waste 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. • Implement Commercial Recycling Technical Assistance program through workshops and by providing waste audits to businesses and advice on how to set up source separated recycling programs. 331 Budget Division: LIGHT AND WATER - RECYCLING AND SOLID WASTE FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 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 $25,365 $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 $56,135 $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. #08-09 09-10 10-11 11-12 VARIANCE PERSONNEL OIL BLOCK GRANT 6003 Salaries/Regular - 1,040 - - - SUBTOTAL - 1,040 - - - AB 939 FEE 6003 Salaries/Regular 33,575 49,770 56,135 56,135 - 6012 Salaries/Comp-Time 25 185 - - - 6015 Salaries/Vacation 1,695 2,835 - - - 6024 Salaries/Sick Leave 1,885 1,840 - - - 6027 Salaries/Bereavement - 480 - - - 6045 Salaries/Education Incentive 365 365 365 365 - 6063 Salaries/Jury Duty 30 - - - - 6101 PERS/Employee Contribution 2,725 3,975 4,015 4,015 - 6105 PERS/Employer Contribution 4,675 6,640 6,600 7,210 610 6109 PARS/Employer Contribution 1,360 1,640 1,625 1,625 - 6125 FICA/Employer Contrib/Med 680 1,015 985 990 5 6140 Life Insurance Allocation 130 150 150 150 - 6155 Workers' Comp Allocation 1,565 2,260 2,260 2,260 - 6160 LTD Insurance Allocation 370 435 435 435 - 6165 Unemployment Allocation 45 65 70 70 - 6175 Benefits/Flex Plan 6,825 10,485 11,290 11,875 585 6180 Deferred Comp/Employer Paid 570 710 720 720 - SUBTOTAL 56,520 82,850 84,650 85,850 1,200 PERSONNEL SUBTOTAL 56,520 83,890 84,650 85,850 1,200 333 Cost 3940750065 6220 $500 6235 $1,000 6625 $184,600 6455 $2,944,060 7055 $30,000 LIGHT & WATER - RECYCLING AND SOLID WASTE ACTIVITY DETAIL Account Number Description Training Schools - Training in compliance with AB 939, State regulations and block grants through organizations like the California Resources Recycling Association (CRRA). Uncollectible Accounts - This is for write offs of uncollectible accounts. Meetings/Conferences - For attendance at meetings of Southern California Waste Management Forum, Solid Waste Association of North America (SWANA), San Gabriel Valley Council of Governments Solid Waste Working Group, and Los Angeles County Integrated Waste Management Task Force. Program Expenses - Program expenses in this cost center cover programs such as used oil recycling ($13,000), school beverage container recycling ($12,700), disposal of hazardous waste generated from city facilities ($7,500), promotion of reusable grocery bags ($4,500), promotion of proper disposal of sharps waste ($6,000), promotion of backyard composting ($7,450), Program Advertising ($5,000), and Commercial Recycling Technical Assistance ($128,450). Refuse Contract - This is the amount expected to be billed by Azusa Light & Water for residential refuse collection services provided by Athens Services. This is amount paid to Athens Services excluding City fees, such as the Franchise Fee and AB 939 Fee. 334 BUDGET UNIT: 3940750065/3640750000 LIGHT & WATER-SOLID WASTE MGT DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #08-09 09-10 10-11 11-12 VARIANCE OPERATIONS OIL BLOCK GRANT 6625 Program Expense 11,575 8,130 8,230 13,000 4,770 SUBTOTAL 11,575 8,130 8,230 13,000 4,770 BEVERAGE CONTAINER RECYCLING 6625 Program Expense 7,485 5,715 640 12,700 12,060 SUBTOTAL 7,485 5,715 640 12,700 12,060 AB 939 FEE 6220 Training Schools 350 895 1,000 500 (500) 6235 Meetings & Conferences 305 - 1,600 1,000 (600) 6301 Legal Fees 730 3,300 4,000 4,000 - 6493 Outside Services & Repairs - - 200 200 - 6518 Postage 1,310 1,380 1,500 2,000 500 6527 Supplies/Computer 105 - 500 500 - 6530 Office Supplies 40 - 200 200 - 6539 Printing, Binding & Duplicating 1,840 1,895 2,000 2,000 - 6572 Office Furniture & Equipment - 590 500 500 - 6625 Program Expense 34,790 32,990 33,600 158,900 125,300 6915 Utilities/Telephone - 340 710 710 - 7025 Overhead Expense 33,655 33,655 33,655 33,655 - SUBTOTAL 73,125 75,045 79,465 204,165 124,700 REFUSE CONTRACT 6455 Refuse Collection 2,990,300 2,894,390 3,260,000 2,944,060 (315,940) 7055 Uncollectible Accounts 37,970 29,915 30,000 30,000 - SUBTOTAL 3,028,270 2,924,305 3,290,000 2,974,060 (315,940) OPERATIONS SUBTOTAL 3,120,455 3,013,195 3,378,335 3,203,925 (174,410) 335 BUDGET UNIT: 3940750065/3640750000 LIGHT & WATER-SOLID WASTE MGT DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #08-09 09-10 10-11 11-12 VARIANCE TRANSFERS OUT AB 939 FEE 5950 Transfers Out 150,000 - 117,200 - (117,200) SUBTOTAL 150,000 - 117,200 - (117,200) REFUSE CONTRACT 5950 Transfers Out 585,800 590,000 541,400 602,190 60,790 SUBTOTAL 585,800 541,400 602,190 60,790 TRANSFERS OUT SUBTOTAL 735,800 295,000 658,600 602,190 (56,410) SOLID WASTE MGMT. TOTAL 3,912,775 3,392,085 4,121,585 3,891,965 (229,620) FUNDING: AB 939 FEE FUND 39 (279,645) (158,935) (281,315) (290,015) 8,700 GRANT FUND 28 (19,060) (13,845) (8,870) (25,700) 16,830 REFUSE FUND 36 (3,614,070) (2,924,305) (3,831,400) (3,576,250) (255,150) Total Funding (3,912,775) (3,097,085) (4,121,585) (3,891,965) (229,620) 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, month-end closing of utility financial records and maintaining the financial reporting interface to Finance Department. Additionally, Customer Service bills for sewer, solid waste collection, public benefits program and community maintenance fees. This division is responsible for key account services for large business customers and both water & electric conservation programs. 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. In 2011-12, Customer Service will complete the Customer Information System upgrade to Version 4.0. 337 THIS PAGE INTENTIONALLY LEFT BLANK 338 FY 11-12 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 and calculate power cost adjustments semi-annually to ensure that retail rates are adequately recovering wholesale power costs. Utilities Administration will also provide administrative support to FARECal (a Joint Powers Authority formed under California Municipal Utilities Association) to assist them in administering debt service accounting, auditing and filing functions as required by State statutes. 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. 339 Budget Division: LIGHT AND WATER - CONSUMER SERVICES (ALL) FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 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 $182,000 $182,000 Cashiers 3,120 3,328 $54,910 $58,570 Assistant to the Director of Utilities(a)0.75 0.75 76,095 76,095 Drought Techs 1,560 1,560 26,090 27,295 Senior Management Analyst 1.00 1.00 76,095 76,095 Cust Srv Rep I 2,080 1,664 40,525 38,520 Senior Administrative Technician(b)0.50 0.50 30,770 30,770 Office Spec I 1,560 1,664 28,565 35,015 Asst Director-Cust Care and Solutions(c)0.85 0.85 107,955 107,955 Customer Care Operations Supervisor 1.00 1.00 77,960 79,460 Customer Services Representative I 1.00 0.00 42,125 0 Customer Services Representative II(d)3.95 0.95 200,425 50,370 Customer Services Representative III 6.00 10.00 345,505 573,095 Field Services Representative 2.00 2.00 128,250 130,770 Field Services Supervisor 1.00 1.00 72,510 73,900 Meter Reader 6.00 6.00 364,100 375,420 Administrative Analyst 1.00 1.00 68,025 69,690 (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.05 26.05 $1,771,815 $1,825,620 TOTAL 8,320 8,216 $150,090 $159,400 Full Time Positions Part Time Positions 340 BUDGET UNIT: ALL FUND 31 DIVISIONS-CONSUMER SERVICES (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 PERSONNEL 6003 Salaries/Regular 1,594,875 1,563,740 1,771,815 1,825,620 53,805 6006 Salaries/Temp & Part-Time 98,515 146,940 150,090 159,400 9,310 6012 Salaries/Comp-Time 5,465 1,320 - - - 6015 Salaries/Vacation 88,945 95,530 - - - 6024 Salaries/Sick Leave 55,220 66,570 - - - 6027 Salaries/Bereavement 740 5,495 - - - 6033 Overtime Pay/Premium 13,700 8,225 15,000 12,500 (2,500) 6045 Standby Pay/Premium 2,010 5,915 1,990 4,040 2,050 6047 Salaries/Bonuses - 43,365 - - - 6048 Salaries/Language Pay 22,250 17,560 15,480 15,480 - 6063 Salaries/Jury Duty 840 425 - - - 6069 Allowances/Vehicle 5,425 5,115 26,400 26,400 - 6072 Salaries/Injury 475 1,490 - - - 6091 Leave Liability Adjustments 19,990 (8,980) - - - 6101 PERS/Employee Contribution 132,745 132,765 125,395 129,940 4,545 6105 PERS/Employer Contribution 227,595 221,670 206,860 234,325 27,465 6109 PARS/Employer 61,600 54,645 66,595 68,825 2,230 6125 FICA/Employer Contrib/Med 27,180 31,430 33,320 34,225 905 6133 Retiree Health Premium Reimb 7,740 7,445 9,070 9,070 - 6140 Life Insurance Allocation 6,645 4,640 4,745 4,925 180 6155 Workers' Comp Allocation 76,215 78,375 78,010 80,385 2,375 6160 LTD Insurance Allocation 16,175 13,320 14,100 14,585 485 6165 Unemployment Allocation 2,115 2,275 3,250 3,320 70 6175 Benefits/Flex Plan 394,480 409,330 445,215 450,700 5,485 6180 Deferred Comp/Employer Paid 7,410 6,010 8,370 8,370 - PERSONNEL SUBTOTAL 2,868,350 2,921,635 2,975,705 3,082,110 106,405 341 Budget Division: LIGHT AND WATER - CONSUMER SERVICES-ADMINISTRATION FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 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 $182,000 $182,000 Office Spec I 1,560 1,054 $28,565 $22,180 Assistant to the Director of Utilities (a)0.75 0.75 76,095 76,095 Senior Management Analyst 1.00 1.00 76,095 76,095 Senior Administrative Technician(b)0.50 0.50 30,770 30,770 (a) .25 FTE Solid Waste (b) .50 FTE Solid Waste TOTAL 3.25 3.25 $364,960 $364,960 TOTAL 1,560 1,054 $28,565 $22,180 Full Time Positions Part Time Positions 342 Budget Division: LIGHT AND WATER - CONSUMER SERVICES-CUSTOMER CARE FIELD SRV FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Hours Hours Wages Wages Field Services Representative 2.00 2.00 $128,250 $130,770 Drought Techs 1,560 1,560 $26,090 $27,295 Field Services Supervisor 1.00 1.00 72,510 73,900 Meter Reader 6.00 6.00 364,100 375,420 TOTAL 9.00 9.00 $564,860 $580,090 TOTAL 1,560 1,560 $26,090 $27,295 Full Time Positions Part Time Positions 343 Budget Division: LIGHT AND WATER - CONSUMER SERVICES-CUST. CARE RECS & COLL. FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Hours Hours Wages Wages Administrative Analyst 1.00 1.00 $68,025 $69,690 Cashiers 3,120 3,328 $54,910 $58,570 Customer Care Operations Supervisor 1.00 1.00 77,960 79,460 Cust Srv Rep I 2,080 1,664 40,525 38,520 Customer Services Representative I 1.00 0.00 42,125 0 Office Spec II 0 610 0 12,835 Customer Services Representative II (a)3.95 0.95 200,425 50,370 Customer Services Representative III 6.00 10.00 345,505 573,095 (a) .05 FTE Public Benefits TOTAL 12.95 12.95 $734,040 $772,615 TOTAL 5,200 5,602 $95,435 $109,925 Full Time Positions Part Time Positions 344 Budget Division: LIGHT AND WATER - CONSUMER SERVICES-CUST. CARE EMPLOYEE EXP. FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Hours Hours Wages Wages Asst Director-Cust Care and Solutions (a)0.85 0.85 $107,955 $107,955 (a) .15 FTE Public Benefits TOTAL 0.85 0.85 $107,955 $107,955 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 345 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 PERSONNEL Utility Board 6069 Allowances/Vehicle - - 21,000 21,000 - 6160 LTD Insurance Allocation - - 400 400 - 6165 Unemployment Allocation - - 850 850 - Subtotal - - 22,250 22,250 - Utility Administration 6003 Salaries/Regular 356,510 328,520 357,960 364,960 7,000 6006 Salaries/Temp & Part-Time 11,780 24,725 28,565 22,180 (6,385) 6012 Salaries/Comp-Time 2,290 185 - - - 6015 Salaries/Vacation 16,485 11,555 - - - 6024 Salaries/Sick Leave 14,370 5,410 - - - 6027 Salaries/Bereavement - 1,440 - - - 6033 Overtime Pay/Premium 2,825 - - - - 6045 Salaries/Education Incentive 1,105 2,545 1,090 2,540 1,450 6063 Salaries/Jury Duty 95 - - - - 6069 Allowances/Vehicle 5,425 5,115 5,400 5,400 - 6101 PERS/Employee Contribution 29,300 26,390 25,250 25,840 590 6105 PERS/Employer Contribution 50,275 44,085 41,680 46,630 4,950 6109 PARS/Employer Contribution 26,885 17,615 28,330 28,790 460 6125 FICA/Employer Contrib/Med 3,435 5,890 6,430 6,480 50 6140 Life Insurance Allocation 2,210 875 965 990 25 6155 Workers' Comp Allocation 16,805 15,020 15,720 15,795 75 6160 LTD Insurance Allocation 4,240 2,695 2,780 2,835 55 6165 Unemployment Allocation 510 535 445 450 5 6175 Benefits/Flex Plan 49,200 47,230 50,430 52,175 1,745 6180 Deferred Comp/Employer Paid 5,130 3,670 6,300 6,300 - Subtotal 598,875 543,500 571,345 581,365 10,020 346 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 Field Services 6003 Salaries/Regular 499,030 504,790 564,860 580,090 15,230 6006 Salaries/Temp & Part-Time 11,010 27,645 26,090 27,295 1,205 6012 Salaries/Comp-Time 2,300 820 - - - 6015 Salaries/Vacation 27,220 33,835 - - - 6024 Salaries/Sick Leave 14,685 9,420 - - - 6027 Salaries Bereavement - 1,310 - - - 6033 Overtime Pay/Premium 6,610 7,965 - - - 6047 Salaries/Bonuses - 20,295 - - - 6048 Salaries/Language Pay 3,565 3,650 2,400 2,400 - 6072 Salaries / Injury 45 - - - - 6101 PERS/Employee Contribution 39,210 40,060 39,965 41,030 1,065 6105 PERS/Employer Contribution 67,215 66,890 65,930 73,980 8,050 6109 PARS/Employer Contribution 13,000 13,595 12,770 13,115 345 6125 FICA/Employer Contrib/Med 9,720 10,595 10,890 11,140 250 6140 Life Insurance Allocation 1,760 1,490 1,510 1,555 45 6155 Workers' Comp Allocation 22,680 24,460 23,730 24,380 650 6160 LTD Insurance Allocation 4,770 4,200 4,395 4,505 110 6165 Unemployment Allocation 605 665 750 770 20 6175 Benefits/Flex Plan 136,145 142,390 157,635 158,625 990 Subtotal 859,570 914,075 910,925 938,885 27,960 Customer Records & Collections 6003 Salaries/Regular 628,800 615,930 731,915 772,615 40,700 6006 Salaries/Temp & Part-Time 75,725 94,570 95,435 109,925 14,490 6012 Salaries/Comp-Time 875 315 - - - 6015 Salaries/Vacation 37,515 41,625 - - - 6024 Salaries/Sick Leave 20,815 47,150 - - - 6027 Salaries Bereavement 740 2,745 - - - 6033 Overtime Pay/Premium 4,265 260 15,000 12,500 (2,500) 6045 Salaries/Education Incentive 905 3,370 900 1,500 600 6047 Salaries/Bonuses - 23,070 - - - 6048 Salaries/Language Pay 18,685 13,910 13,080 13,080 - 6063 Salaries/Jury Duty 150 425 - - - 6072 Salaries/Injury 430 1,490 - - - 6091 Leave Liability Adjustment 19,990 (8,980) - - - 347 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 6101 PERS/Employee Contribution 55,195 57,360 52,595 55,485 2,890 6105 PERS/Employer Contribution 94,595 95,725 86,725 100,025 13,300 6109 PARS/Employer Contribution 14,660 15,255 18,575 20,000 1,425 6125 FICA/Employer Contrib/Med 11,870 12,730 14,250 14,845 595 6133 Retiree Health Premium Reimb 7,740 7,445 9,070 9,070 - 6140 Life Insurance Allocation 2,260 1,935 1,985 2,095 110 6155 Workers' Comp Allocation 31,495 33,790 34,240 35,890 1,650 6160 LTD Insurance Allocation 6,055 5,430 5,685 6,005 320 6165 Unemployment Allocation 875 930 1,085 1,130 45 6175 Benefits/Flex Plan 195,390 205,405 224,355 226,445 2,090 6180 Deferred Comp/Employer Paid 540 540 540 540 - Subtotal 1,229,570 1,272,425 1,305,435 1,381,150 75,715 Employee Related 6003 Salaries/Regular 110,535 114,500 107,955 107,955 - 6015 Salaries/Vacation 7,725 8,515 - - - 6024 Salaries/Sick Leave 5,350 4,590 - - - 6063 Salaries/Jury Duty 595 - - - - 6075 Vacation Pay-Off - 4,900 - - - 6078 Sick Leave Pay-Off - 2,120 - - - 6101 PERS/Employee Contribution 9,040 8,955 7,585 7,585 - 6105 PERS/Employer Contribution 15,510 14,970 12,525 13,690 1,165 6109 PARS/Employer 7,055 8,180 6,920 6,920 - 6125 FICA/Employer Contrib/Med 2,155 2,215 1,750 1,760 10 6140 Life Insurance Allocation 415 340 285 285 - 6155 Workers' Comp Allocation 5,235 5,105 4,320 4,320 - 6160 LTD Insurance Allocation 1,110 995 840 840 - 6165 Unemployment Allocation 125 145 120 120 - 6175 Benefits/Flex Plan 13,745 14,305 12,795 13,455 660 6180 Deferred Comp/Employer Paid 1,740 1,800 1,530 1,530 - Subtotal 180,335 191,635 156,625 158,460 1,835 PERSONNEL SUBTOTAL 2,868,350 2,921,635 2,966,580 3,082,110 115,530 348 Cost 3140701xxx, 3140702xxx, 3140711xxx, 6220 $2,500 6230 $550 6235 $22,300 6415 $124,700 6493 $192,200 6539 $22,500 Training Schools - American Public Power Association (APPA) training workshops on finance, rate setting and utility accounting; workshops sponsored by the California Municipal Utilities Association (CMUA); and other work related training as deemed necessary by Utilities Administration and Customer Services Division. ($500 for Administrative Services (AS); $2,000 for Customer Services (CS)) Dues/Subscriptions - CMUA, Southern California Public Power Authority (SCPPA), APPA, and Customer Service Newsletter for Customer Service Representatives (CSRs). ($250 for AS; $300 for CS) Meeting/Conferences - CMUA Annual Conference and Board meetings, CMUA Capitol Day, CMUA Utility Managers Summit, APPA conferences, APPA Legislative Rally, 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, Systems & Software (S&S), and National Association of Credit Management (NACM) conference. ($5,595 for Utility Board (UB); $13,395 for AS; $3,310 for CS) Computer Software Services - Customer Service Program-related expenses, including Customer Information System maintenance, phone system maintenance, and various software licenses. ($124,700 for CS) Outside Services & Repairs - Pest control services, document archive/retrieve services, 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. ($6,565 for AS; $178,935 for CS) Printing, Binding & Duplicating - Copier supplies, business card printing, and utility billing inserts. ($2,500 for AS; $20,000 for CS). LIGHT & WATER - CONSUMER SERVICES ACTIVITY DETAIL Account Number Description 349 CostAccount Number Description 6601 $3,000 6815 $26,600 6825 $11,000 6835 $51,700 6915 $11,100 7050 $59,905 Maintenance & Repair of Vehicles - Meter Reader trucks: Car wash and tires and other miscellaneous repairs ($11,000 for CS) Maintenance & Repair of Equipment - Azusa Light & Water heating, ventilation and air conditioning (HVAC) equipment, elevator, fire extinguishers, waterfall, outdoor LED electronic sign, automatic doors, vending machines, printers, fax machine, ice machine, drinking fountains, and office equipment maintenance and repairs ($36,900 for AS; $14,800 for CS) Donations/Contributions - Azusa Chamber of Commerce, Golden Week, City's Annual Winter Festival by Recreation & Family Services Department, Rose Parade, Civic Leadership, and other miscellaneous donations desired by the Utility Board. ($59,905 for UB & AS) Utilities/Telephone - Cell phone and other phone charges. ($2,000 for AS; $9,100 for CS) Maintenance & Repair of Building - Light & Water Office building roof annual maintenance and other miscellaneous repairs ($26,600 for AS) Advertising Expense - Recreation Gym Decal and miscellaneous. ($3,000 for AS) 350 BUDGET UNIT: ALL FUND 31 DIVISIONS-CONSUMER SERVICES (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 OPERATIONS 6201 Uniforms & Laundry 12,780 14,310 16,000 15,000 (1,000) 6210 Employee Awards 110 - 500 300 (200) 6215 Tuition Reimbursement - - 2,000 - (2,000) 6220 Training Schools 2,365 955 1,500 2,500 1,000 6230 Dues & Subscriptions 450 445 750 550 (200) 6235 Meetings & Conferences 7,590 21,150 18,784 22,300 3,516 6301 Legal Fees 14,250 15,745 16,500 14,500 (2,000) 6399 Professional Services/Other 15,505 32,500 22,500 15,500 (7,000) 6415 Computer Software Support 63,500 92,780 128,600 124,700 (3,900) 6423 Administrative Allocation 1,114,035 1,260,475 1,276,000 1,104,680 (171,320) 6430 Custodial Services 4,130 11,700 15,000 15,000 - 6493 Outside Services & Repairs 151,765 153,315 195,670 185,500 (10,170) 6518 Postage 167,900 136,610 170,000 170,000 - 6521 Messenger Service 655 460 975 950 (25) 6530 Office Supplies 14,190 12,660 15,800 17,000 1,200 6539 Printing, Binding & Duplicating 15,590 14,325 21,500 22,500 1,000 6551 Fuel and Oil 16,070 17,895 18,000 25,000 7,000 6554 Supplies/Custodial & Cleaning 2,885 3,995 4,000 4,170 170 6563 Supplies/Special 7,625 10,825 15,210 12,500 (2,710) 6564 Supplies/Medical-Dental 910 3,505 4,800 4,150 (650) 6566 Small Tools 275 15 3,000 3,000 - 6569 Small Equipment 8,115 1,280 5,000 5,000 - 6570 Computer Peripherals/Misc 240 1,995 500 500 - 6572 Office Furniture & Equipment 5,245 1,225 10,216 7,200 (3,016) 6601 Advertising Expense 3,170 5,910 4,200 3,000 (1,200) 6615 Safety & Security Services Exp 10,865 10,460 12,500 13,370 870 6625 Program Expense - 2,880 - - - 6670 IT Allocation 494,315 500,000 519,085 562,780 43,695 6740 Claims Expense/Liability 358,260 358,260 394,085 394,085 - 6805 Maintenance/Land Improvements 16,295 12,205 16,400 14,790 (1,610) 6815 Maint & Repairs/Bldgs 52,760 19,410 26,000 26,600 600 6825 Maint & Repair / Vehicle 14,530 8,825 10,000 11,000 1,000 6827 Garage Allocation 790 665 1,000 2,000 1,000 351 BUDGET UNIT: ALL FUND 31 DIVISIONS-CONSUMER SERVICES (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 6835 Maint & Repair/Equipment 25,580 33,775 50,300 51,700 1,400 6840 Rent/Office Furniture & Equip 3,890 3,930 4,500 4,500 - 6904 Utilities/Other 6,635 8,280 10,000 10,000 - 6915 Utilities/Telephone 5,045 5,795 7,100 11,100 4,000 7009 Bank Service Charges 2,485 1,915 1,000 500 (500) 7050 Donations/Contribution 53,435 54,700 59,905 59,905 - 7075 Fee Collection Expense 3,370 295 1,000 1,000 - 7080 Refund - 65 - - - OPERATIONS SUBTOTAL 2,677,605 2,835,535 3,079,880 2,938,830 (141,050) TRANSFERS OUT 5950 Transfers Out 195,810 179,840 205,745 195,385 (10,360) TRANSFERS OUT SUBTOTAL 195,810 179,840 205,745 195,385 (10,360) CONSUMER SERVICE FUND TOTAL: 5,741,765 5,937,010 6,261,330 6,216,325 (45,005) 352 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 OPERATIONS Utility Board 6235 Meetings & Conferences 2,005 6,690 7,100 7,100 - 6301 Legal Fees 11,580 9,820 10,000 10,000 - 6521 Messenger Service 240 235 275 350 75 6670 IT Allocation 7,355 8,345 18,000 18,000 - Subtotal 21,180 25,090 35,375 35,450 75 Utility Administration 6399 Professional Services 12,000 - - - - Subtotal 12,000 - - - - Consumer Services - Administrative 6220 Training Schools 350 35 500 500 - 6230 Dues & Subscriptions - 210 250 250 - 6235 Meetings & Conferences 5,540 12,590 8,100 11,000 2,900 6301 Legal Fees - 440 1,500 1,500 - 6399 Professional Services/Other 3,505 32,500 22,500 15,500 (7,000) 6493 Outside Services & Repairs 1,730 1,015 1,000 970 (30) 6521 Messenger Service 205 135 250 250 - 6530 Office Supplies 2,475 2,755 5,000 4,000 (1,000) 6539 Printing, Binding & Duplicating 595 160 500 2,500 2,000 6551 Fuel and Oil 1,755 - - - - 6563 Supplies/Special 2,520 3,330 2,500 2,250 (250) 6564 Supplies/Medical-Dental 315 1,995 3,800 2,150 (1,650) 6569 Small Equipment - 1,280 - - - 6570 Computer Peripherals/Misc 240 1,995 500 500 - 6572 Office Furniture & Equipment 1,580 1,225 2,000 2,200 200 6601 Advertising Expense 3,170 5,910 4,200 3,000 (1,200) 6915 Utilities/Telephone 1,180 1,780 2,000 2,000 - 7050 Donations/Contribution 53,435 54,700 59,905 59,905 - Subtotal 78,595 122,055 114,505 108,475 (6,030) 353 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 Utilities - Administration 6423 Administrative Allocation 1,114,035 1,260,475 1,276,000 1,104,680 (171,320) 6740 Claims Expense/Liability 358,260 358,260 394,085 394,085 - Subtotal 1,472,295 1,618,735 1,670,085 1,498,765 (171,320) General Plant - Maintenance 6430 Custodial Services 4,130 11,700 15,000 15,000 - 6493 Outside Services & Repairs 4,005 5,405 5,270 5,600 330 6554 Supplies/Custodial & Cleaning 2,885 3,995 4,000 4,170 170 6563 Supplies/Special 105 445 1,210 1,080 (130) 6615 Safety & Security Services Exp 10,790 10,460 12,500 13,370 870 6805 Maintenance/Land Improvements 16,295 12,205 16,400 14,790 (1,610) 6815 Maint & Repairs/Bldgs 52,760 19,410 26,000 26,600 600 6835 Maint & Repair/Equipment 19,225 27,590 35,000 36,900 1,900 6840 Rent/Office Furniture & Equip 3,890 3,930 4,500 4,500 - 6904 Utilities/Other 6,635 8,280 10,000 10,000 - Subtotal 120,720 103,420 129,880 132,010 2,130 Field Services 6201 Uniforms & Laundry 3,440 4,500 6,000 5,000 (1,000) 6235 Meetings & Conferences - - 1,200 1,200 - 6493 Outside Services & Repairs 20,495 15,180 20,000 16,400 (3,600) 6518 Postage 5 - - - - 6521 Messenger Service 210 90 250 250 - 6539 Printing, Binding & Duplicating - 725 1,000 1,000 - 6551 Fuel and Oil 14,315 17,895 18,000 25,000 7,000 6563 Supplies/Special 4,965 5,275 9,000 7,370 (1,630) 6566 Small Tools 275 15 3,000 3,000 - 6825 Maint & Repair / Vehicle 14,530 8,825 10,000 11,000 1,000 6827 Garage Allocation 790 665 1,000 2,000 1,000 6915 Utilities/Telephones 175 875 - 6,000 6,000 Subtotal 59,200 54,045 69,450 78,220 8,770 354 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 Customer Records & Collections 6201 Uniforms & Laundry 9,165 9,810 10,000 10,000 - 6235 Meetings & Conferences 25 - - - - 6415 Computer Software Services 63,500 92,780 128,600 124,700 (3,900) 6493 Outside Services & Repairs 124,295 131,615 167,400 160,600 (6,800) 6518 Postage 167,895 136,610 170,000 170,000 - 6521 Messenger Service - - 200 100 (100) 6530 Office Supplies 11,715 9,905 10,800 13,000 2,200 6539 Printing, Binding & Duplicating 900 6,680 5,000 4,000 (1,000) 6563 Supplies/Special 35 1,665 2,000 1,630 (370) 6569 Small Equipment 8,115 - 5,000 5,000 - 6572 Office Furniture & Equipment 3,665 - 8,216 5,000 (3,216) 6615 Safety and Security 75 - - - - 6625 Program Expense - 2,880 - - - 6670 IT Allocation 486,960 491,655 501,085 544,780 43,695 6835 Maint & Repair/Equipment 6,355 6,185 15,300 14,800 (500) 6915 Utilities/Telephone 3,690 3,140 5,100 3,100 (2,000) 7009 Bank Service Charges 2,485 1,915 1,000 500 (500) 7075 Fee Collection Expense 3,370 295 1,000 1,000 - 7080 Refund - 65 - - - Subtotal 892,245 895,200 1,030,701 1,058,210 27,509 Employee Related 6201 Uniforms & Laundry 175 - - - - 6210 Employee Awards 110 - 500 300 (200) 6215 Tuition Reimbursement - - 2,000 - (2,000) 6220 Training Schools 2,015 920 1,000 2,000 1,000 6230 Dues & Subscriptions 450 235 500 300 (200) 6235 Meetings & Conferences 20 1,870 2,384 3,000 616 6301 Legal Fees 2,670 5,485 5,000 3,000 (2,000) 355 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 6493 Outside Services & Repairs 1,240 100 2,000 1,930 (70) 6539 Printing, Binding & Duplicating 14,095 6,760 15,000 15,000 - 6563 Supplies/Special - 110 500 170 (330) 6564 Supplies/Medical-Dental 595 1,510 1,000 2,000 1,000 Subtotal 21,370 16,990 29,884 27,700 (2,184) OPERATIONS SUBTOTAL 2,677,605 2,835,535 3,079,880 2,938,830 (141,050) TRANSFERS OUT Promotion/Membership 5950 Transfers Out 75,720 77,695 75,775 78,105 2,330 Subtotal 75,720 77,695 75,775 78,105 2,330 Customer Care & Solutions - Administration 5950 Transfers Out 93,785 79,590 106,160 94,660 (11,500) Subtotal 93,785 79,590 106,160 94,660 (11,500) Customer Records and Collections 5950 Transfers Out 7,555 7,555 8,810 7,620 (1,190) Subtotal 7,555 7,555 8,810 7,620 (1,190) Employee Related Expenses 5950 Transfers Out 18,750 15,000 15,000 15,000 - Subtotal 18,750 15,000 15,000 15,000 - TRANSFERS OUT SUBTOTAL 195,810 179,840 205,745 195,385 (10,360) CONSUMER SERVICE FUND TOTAL: 5,741,765 5,937,010 6,261,330 6,216,325 (45,005) 356 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 regularly replaces water mains for reasons of age, excessive repair requirements and inadequate flow. Water Operations also responds to customer inquiries and requests, and encourages water conservation through various programs. The new Water Treatment Plant is designed to ultimately produce 16 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 11-12 PROGRAM HIGHLIGHTS: • Operate the new Water Treatment Plant (WTP) Upgrade in an efficient and cost effective manner. • Assist developers of projects in the system service area in their efforts to complete their projects. • Continue to encourage proper use and conservation of water within the Azusa Light & Water water system. • Manage maintenance and repair of the water distribution system in a timely and cost effective manner. • Continue to seek means to enhance the Azusa Light & Water water supply to provide reliability and sustainability of water supply. 357 Budget Division: LIGHT AND WATER - WATER (ALL) FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 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 $128,810 Water System Engineer 1.00 1.00 87,740 89,740 Associate Engineer 1.00 1.00 96,475 84,865 Office Specialist II 1.00 1.00 40,050 42,050 Business Dev/Pub Benefit Prog Coord(a)0.30 0.30 23,985 23,985 Water Production Supervisor 1.00 1.00 97,345 99,230 Water Production Operator III 4.00 4.00 284,920 281,065 Water Production Operator II 2.00 2.00 130,720 121,135 Water System Administrator 1.00 1.00 62,665 64,090 Water Distribution Supervisor 1.00 1.00 96,445 98,330 Water Distribution Crew Supervisor 2.00 2.00 160,180 164,180 Water Distribution Services Specialist 1.00 1.00 71,860 73,235 Water Distribution Equipment Operator 2.00 2.00 133,240 135,860 Water Distribution Worker III 0.00 2.00 0 130,380 Water Distribution Worker II 3.00 1.00 172,205 60,700 Water Distribution Worker I 4.00 4.00 196,175 210,805 Welder/Water Dist Worker I 2.00 2.00 125,025 133,225 (a) .70 FTE Public Benefits TOTAL 27.30 27.30 $1,906,040 $1,941,685 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 358 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 PERSONNEL 6003 Salaries/Regular 1,482,955 1,540,075 1,906,040 1,941,685 35,645 6012 Salaries/Comp-Time 28,790 27,360 - - - 6015 Salaries/Vacation 105,660 99,630 - - - 6024 Salaries/Sick Leave 50,285 69,965 - - - 6027 Salaries/Bereavement 2,285 3,775 - - - 6030 Overtime Pay/Regular 5,180 14,110 17,000 17,000 - 6033 Overtime Pay/Premium 87,205 100,880 140,000 110,000 (30,000) 6039 Standby Pay/Premium 68,070 63,180 75,000 75,000 - 6045 Salaries/Education Incentive 4,885 11,790 9,990 9,390 (600) 6047 Salaries/Bonuses - 52,585 - - - 6048 Salaries/Language Pay 6,120 8,425 8,400 8,400 - 6063 Salaries/Jury Duty 320 4,420 - - - 6072 Salaries/Injury 13,440 29,610 - - - 6091 Leave Liability Adjustments 40,250 29,480 - - - 6101 PERS/Employee Contribution 119,940 126,915 135,520 137,975 2,455 6105 PERS/Employer Contribution 205,630 211,965 223,595 248,815 25,220 6109 PARS/Employer Contribution 39,395 42,660 45,365 46,440 1,075 6125 FICA/Employer Contrib/Med 29,725 32,370 36,740 33,950 (2,790) 6133 Retiree Health Premium Reimb 8,145 8,265 9,070 9,070 - 6140 Life Insurance Allocation 5,430 4,790 5,115 5,210 95 6155 Workers' Comp Allocation 72,015 78,515 86,255 78,380 (7,875) 6160 LTD Insurance Allocation 14,745 13,465 14,830 15,105 275 6165 Unemployment Allocation 1,945 2,120 2,625 2,435 (190) 6175 Benefits/Flex Plan 374,095 404,650 467,025 472,800 5,775 6180 Deferred Comp/Employer Paid 3,045 3,420 3,960 3,960 - PERSONNEL SUBTOTAL 2,769,555 2,984,420 3,186,530 3,215,615 29,085 359 Budget Division: LIGHT AND WATER - WATER-CITY FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 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 $128,810 Water System Engineer 1.00 1.00 87,740 89,740 Associate Engineer 1.00 1.00 96,475 84,865 Office Specialist II 1.00 1.00 40,050 42,050 Business Dev/Pub Benefit Prog Coord (a)0.30 0.30 23,985 23,985 (a) .70 FTE Public Benefits TOTAL 4.30 4.30 $375,260 $369,450 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 360 Budget Division: LIGHT AND WATER - WATER SOURCE OF SUPPLY FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Hours Hours Wages Wages Water Production Supervisor 1.00 1.00 $97,345 $99,230 Water Production Operator III 4.00 4.00 284,920 281,065 Water Production Operator II 2.00 2.00 130,720 121,135 Water System Administrator 1.00 1.00 62,665 64,090 TOTAL 8.00 8.00 $575,650 $565,520 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 361 Budget Division: LIGHT AND WATER - WATER TRANSMISSION & DISTRIBUTION FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Hours Hours Wages Wages Water Distribution Supervisor 1.00 1.00 $96,445 98,330.00 Water Distribution Crew Supervisor 2.00 2.00 160,180 164,180.00 Water Distribution Services Specialist 1.00 1.00 71,860 73,235.00 Water Distribution Equipment Operator 2.00 2.00 133,240 135,860.00 Water Distribution Worker III 0.00 2.00 0 130,380.00 Water Distribution Worker II 3.00 1.00 172,205 60,700.00 Water Distribution Worker I 4.00 4.00 196,175 210,805.00 Welder/Water Dist Worker I 2.00 2.00 125,025 133,225.00 TOTAL 15.00 15.00 $955,130 $1,006,715 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 362 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 PERSONNEL City Water 6003 Salaries/Regular 239,235 264,500 375,260 369,450 (5,810) 6012 Salaries/Comp-Time - 160 - - - 6015 Salaries/Vacation 14,830 19,260 - - - 6024 Salaries/Sick Leave 5,270 2,840 - - - 6027 Salaries/Bereavement 1,725 - - - - 6045 Salaries/Education Incentive 1,940 1,855 1,890 1,890 - 6063 Salaries/Jury Duty 110 445 - - - 6091 Leave Liability Adjustments 40,250 29,480 - - - 6101 PERS/Employee Contribution 18,490 20,315 26,545 26,140 (405) 6105 PERS/Employer Contribution 31,720 33,940 43,805 47,145 3,340 6109 PARS/Employer Contribution 8,240 9,845 9,680 9,795 115 6125 FICA/Employer Contrib/Med 4,400 4,825 6,405 6,370 (35) 6133 Retiree Health Premium Reimb 8,145 8,265 9,070 9,070 - 6140 Life Insurance Allocation 830 770 1,000 985 (15) 6155 Workers' Comp Allocation 10,615 11,560 15,085 14,855 (230) 6160 LTD Insurance Allocation 2,275 2,210 2,920 2,875 (45) 6165 Unemployment Allocation 265 295 440 440 - 6175 Benefits/Flex Plan 38,075 47,445 64,735 68,070 3,335 6180 Deferred Comp/Employer Paid 3,045 3,420 3,960 3,960 - Subtotal 429,460 461,430 560,795 561,045 250 Production - Source of Supply 6003 Salaries/Regular 504,740 506,635 575,650 565,520 (10,130) 6012 Salaries/Comp-Time 1,415 2,070 - - - 6015 Salaries/Vacation 40,270 26,230 - - - 6024 Salaries/Sick Leave 8,940 12,010 - - - 6027 Salaries/Bereavement 560 - - - - 6030 Overtime Pay/Regular 4,935 10,940 13,000 13,000 - 6033 Overtime Pay/Premium 22,745 26,965 40,000 31,430 (8,570) 6039 Standby Pay/Premium 36,410 34,720 40,000 40,000 - 6045 Salaries/Education Incentive 2,110 5,695 5,100 3,600 (1,500) 6047 Salaries/Bonuses - 19,405 - - - 363 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 6048 Salaries/Language Pay 3,635 3,600 3,600 3,600 - 6063 Salaries/Jury Duty - 1,090 - - - 6072 Salaries/Injury 9,340 23,785 - - - 6101 PERS/Employee Contribution 40,685 41,440 41,135 40,320 (815) 6105 PERS/Employer Contribution 69,755 69,215 67,880 72,720 4,840 6109 PARS/Employer Contribution 11,650 11,895 14,100 13,895 (205) 6125 FICA/Employer Contrib/Med 10,695 11,255 11,845 10,340 (1,505) 6140 Life Insurance Allocation 1,835 1,560 1,550 1,520 (30) 6155 Workers' Comp Allocation 24,670 26,170 27,095 22,910 (4,185) 6160 LTD Insurance Allocation 4,950 4,345 4,480 4,400 (80) 6165 Unemployment Allocation 660 690 820 715 (105) 6175 Benefits/Flex Plan 119,405 125,095 139,600 140,375 775 Subtotal 919,405 964,810 985,855 964,345 (21,510) Transmission/Distribution 6003 Salaries/Regular 738,980 768,940 955,130 1,006,715 51,585 6012 Salaries/Comp-Time 27,375 25,130 - - - 6015 Salaries/Vacation 50,560 54,140 - - - 6024 Salaries/Sick Leave 36,075 55,115 - - - 6027 Salaries/Bereavement - 3,775 - - - 6030 Overtime Pay/Regular 245 3,170 4,000 4,000 - 6033 Overtime Pay/Premium 64,460 73,915 100,000 78,570 (21,430) 6039 Standby Pay/Premium 31,660 28,460 35,000 35,000 - 6045 Salaries/Education Incentive 835 4,240 3,000 3,900 900 6047 Salaries/Bonuses - 33,180 - - - 6048 Salaries/Language Pay 2,485 4,825 4,800 4,800 - 6063 Salaries/Jury Duty 210 2,885 - - - 6072 Salaries/Injury 4,100 5,825 - - - 6101 PERS/Employee Contribution 60,765 65,160 67,840 71,515 3,675 6105 PERS/Employer Contribution 104,155 108,810 111,910 128,950 17,040 6109 PARS/Employer Contribution 19,505 20,920 21,585 22,750 1,165 6125 FICA/Employer Contrib/Med 14,630 16,290 18,490 17,240 (1,250) 6140 Life Insurance Allocation 2,765 2,460 2,565 2,705 140 6155 Workers' Comp Allocation 36,730 40,785 44,075 40,615 (3,460) 364 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 6160 LTD Insurance Allocation 7,520 6,910 7,430 7,830 400 6165 Unemployment Allocation 1,020 1,135 1,365 1,280 (85) 6175 Benefits/Flex Plan 216,615 232,110 262,690 264,355 1,665 Subtotal 1,420,690 1,558,180 1,639,880 1,690,225 50,345 PERSONNEL SUBTOTAL 2,769,555 2,984,420 3,186,530 3,215,615 29,085 365 Cost 3240721xxx, 3240722xxx, 3240723xxx, 6220 $7,500 6230 $56,000 6231 $200,000 6235 $1,750 6493 $650,000 6554 $3,000 6563 $2,153,500 6625 $148,500 7001 $3,325,670 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. Supplies/Medical - Purchase of medical/first-aid kits for field staff. Outside Services & Repairs - Design Engineers, Civil Engineers and other vendors necessary to maintain water production and distribution system. Interest Expense - Interest expense of 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 expense 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. 366 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 OPERATIONS 6201 Uniforms & Laundry 15,640 13,920 17,500 15,000 (2,500) 6215 Tuition Reimbursement - - 1,000 1,000 - 6220 Training Schools 8,200 5,580 12,500 7,500 (5,000) 6221 POST Training - 400 - - - 6230 Dues & Subscriptions 36,805 55,530 77,850 56,000 (21,850) 6231 Outside Assessments 116,565 116,265 200,000 200,000 - 6235 Meetings & Conferences 665 230 2,250 1,750 (500) 6253 Licenses/Certifications 1,800 2,800 7,500 7,500 - 6301 Legal Fees 15,690 5,615 130,000 30,000 (100,000) 6320 Fiscal Agent Fees 1,500 4,000 - 3,000 3,000 6340 Special Studies - - 20,000 - (20,000) 6345 Program Consultants - 675 - 5,000 5,000 6399 Professional Services 32,395 - - - - 6424 Consumer Services Allocation 3,866,570 4,010,620 4,062,145 4,040,610 (21,535) 6430 Custodial Services 1,285 5,280 7,500 7,500 - 6490 Mortgage Service Fee - (700) - - - 6493 Outside Services & Repairs 649,410 584,250 823,500 650,000 (173,500) 6518 Postage 3,855 50 2,500 2,500 - 6521 Messenger Service 675 320 1,500 1,500 - 6527 Supplies/Computer 390 - 5,000 5,000 - 6530 Office Supplies 4,465 4,885 6,000 6,000 - 6539 Printing, Binding & Duplicating 21,265 585 38,300 35,000 (3,300) 6551 Fuel and Oil 45,720 44,300 48,500 48,500 - 6554 Supplies/Custodial 2,585 1,590 4,000 3,500 (500) 6560 Repair Parts 3,330 785 11,500 41,500 30,000 6563 Supplies/Special 1,718,060 1,846,460 2,213,500 2,153,500 (60,000) 6564 Supplies/Medical-Dental 1,885 3,505 3,000 3,000 - 6566 Small Tools 4,765 3,720 8,500 8,500 - 6569 Small Equipment 57,040 53,685 125,000 89,000 (36,000) 6572 Office Furniture & Equipment 33,585 1,525 2,250 2,250 - 6599 Materials and Supplies/Other - 55 - - - 6601 Advertising Expense - 1,300 3,500 3,500 - 6605 Filing Costs 9,240 32,175 13,500 13,500 - 367 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 6610 Bond Administration - 2,500 2,500 2,500 - 6625 Program Expense 116,555 157,360 148,500 148,500 - 6801 Rent/Land 2,610 2,610 1,500 1,500 - 6805 Maintenance/Land Improvements 16,295 18,890 30,000 25,000 (5,000) 6815 Maint & Repairs/Bldgs 7,305 7,605 33,500 25,000 (8,500) 6825 Maintenance Repair Vehicle 46,005 42,855 42,250 42,250 - 6827 Garage Allocation 535 1,365 750 900 150 6830 Rent/Equipment 215 1,815 7,100 7,100 - 6835 Maint & Repair/Equipment 11,920 5,075 12,000 12,000 - 6850 Lease Payments - 2,610 - - - 6904 Utilities/Other 824,920 817,360 1,100,000 1,000,000 (100,000) 6905 Utilities/Electricity 56,870 51,420 150,000 75,000 (75,000) 6910 Utilities/Natural Gas 780 825 5,500 5,500 - 6915 Utilities/Telephone 12,270 14,625 13,500 13,500 - 7001 Interest Expense 3,361,365 3,320,895 3,370,925 3,325,670 (45,255) 7009 Bank Service Charge 2,500 - - - - 7010 Franchise Fee (2%) 283,995 316,100 390,665 338,470 (52,195) 7013 Water Rights Lease Expense 1,326,105 1,326,110 1,392,415 1,424,440 32,025 7015 Tax/Property 3,035 3,645 4,000 4,000 - 7055 Uncollectible Accounts 54,270 69,360 45,000 45,000 - 7080 Refunds 1,405 - - - - OPERATIONS SUBTOTAL 12,782,340 12,962,430 14,598,400 13,937,940 (660,460) TRANSFERS OUT 5950 Transfer Out 835,975 918,440 200,000 200,000 - TRANSFERS OUT SUBTOTAL 835,975 918,440 200,000 200,000 - WATER FUND TOTAL: 16,387,870 16,865,290 17,984,930 17,353,555 (631,375) 368 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 OPERATIONS City Water 7080 Refund 1,405 - - - - Subtotal 1,405 - - - - Taxes 6815 Maintenance and Repairs/Buildings - - 12,000 8,960 (3,040) 7010 Franchise Fee (2%) 283,995 316,100 390,665 338,470 (52,195) 7015 Tax/Property 3,035 3,645 4,000 4,000 - Subtotal 287,030 319,745 406,665 351,430 (55,235) Interest Expense 7001 Interest Expense 3,361,365 3,320,895 3,370,925 3,325,670 (45,255) Subtotal 3,361,365 3,320,895 3,370,925 3,325,670 (45,255) Source of Supply 6610 Bond Administration - 2,500 - - - Subtotal - 2,500 - - - Administrative & General 6320 Fiscal Agent Fees 1,500 4,000 - 3,000 3,000 6424 Consumer Services Allocation 3,866,570 4,010,620 4,062,145 4,040,610 (21,535) 6601 Advertising Expense - - 1,500 1,500 - 6610 Bond Administration - - 2,500 2,500 - 7009 Bank Service Charge 2,500 - - - - Subtotal 3,870,570 4,014,620 4,066,145 4,047,610 (18,535) Miscellaneous 6220 Training Schools 705 - 5,000 2,500 (2,500) 6230 Dues & Subscriptions 5,090 4,930 7,500 5,390 (2,110) 6235 Meetings & Conferences 515 105 2,000 1,500 (500) 6253 Licenses/Certifications - 65 - - - 369 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 6539 Printing, Binding & Duplicating 13,810 - 27,500 24,500 (3,000) 6625 Program Expense 116,555 157,360 148,500 148,500 - 6825 Maintenance and Repair/Vehicle - 465 - - - 7055 Uncollectible Accounts 54,270 69,360 45,000 45,000 - Subtotal 190,945 232,285 235,500 227,390 (8,110) Office Supplies & Other Expenses 6220 Training School 225 - - - - 6230 Meetings & Conferences 80 - - - - 6527 Supplies/Computer/Small Equip - - 1,500 1,500 - 6530 Office Supplies 430 360 570 570 - 6563 Supplies/Special 45 10 1,000 1,000 - 6569 Small Equipment - - 540 540 - 6601 Advertising Expense - 1,300 2,000 2,000 - 6825 Maintenance & Repair/Vehicle - - 750 750 - 6830 Rent/Equipment - - 100 100 - 6915 Utilities/Telephone 420 975 1,000 1,000 - Subtotal 1,200 2,645 7,460 7,460 - Employee Related 6201 Uniforms & Laundry 15,640 13,920 17,500 15,000 (2,500) 6215 Tuition Reimbursement - - 1,000 1,000 - 6220 Training Schools 7,270 5,580 7,500 5,000 (2,500) 6230 Dues & Subscriptions 225 250 350 260 (90) 6235 Meetings & Conferences 150 75 - - - 6253 Licenses/Certifications 1,800 2,735 7,500 7,500 - 6301 Legal Fees - - 5,000 5,000 - 6345 Program Consultants - 500 - - - 6563 Supplies/Special - - 1,000 1,000 - 6564 Supplies/Medical-Dental 1,610 3,505 3,000 3,000 - 6825 Maintenance & Repair/Vehicle - 10 1,500 1,500 - Subtotal 26,695 26,575 44,350 39,260 (5,090) 370 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 Regulatory Commission 6221 POST Training - 400 - - - 6493 Outside Services & Repairs 530 520 3,000 2,370 (630) 6551 Fuel and Oil 5,200 2,855 3,500 3,500 - 6605 Filing Costs 50 20 500 500 - Subtotal 5,780 3,795 7,000 6,370 (630) Outside Services 6301 Legal Fees 15,690 5,615 125,000 25,000 (100,000) 6340 Special Studies - - 20,000 - (20,000) 6345 Program Consultants - 175 - 5,000 5,000 6399 Professional Services 32,395 - - - - 6493 Outside Services & Repairs 16,805 95 20,000 9,860 (10,140) Subtotal 64,890 5,885 165,000 39,860 (125,140) Transportation 6493 Outside Services & Repairs - 540 5,000 1,970 (3,030) 6551 Fuel and Oil 40,520 41,445 45,000 45,000 - 6560 Repair Parts 1,495 35 1,340 1,340 - 6563 Supplies/Special 715 270 1,500 1,500 - 6569 Small Equipment 765 365 2,670 2,170 (500) 6825 Maintenance & Repair/Vehicle 46,005 42,380 40,000 40,000 - 6827 Garage Allocation 535 1,365 750 900 150 6835 Maint & Repair/Equipment 130 495 4,000 3,750 (250) Subtotal 90,165 86,895 100,260 96,630 (3,630) Production - Supervision & Engineering 6235 Meetings & Conferences - 50 250 250 - 6490 Mortgage Service Fee - (700) - - - 6493 Outside Services & Repairs 29,400 39,550 35,000 27,610 (7,390) 6518 Postage 3,855 50 2,500 2,500 - 6521 Messenger Service 465 80 1,250 1,250 - 6527 Supplies/Computer/Small Equip 390 - 2,000 2,000 - 6530 Office Supplies 1,355 1,185 1,630 1,630 - 6539 Printing, Binding & Duplicating 7,455 45 10,000 10,000 - 371 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 6554 Supplies/Custodial & Cleaning 665 205 670 670 - 6563 Supplies/Special 3,205 210 2,000 2,000 - 6569 Small Equipment 75 - 6,080 5,580 (500) 6572 Office Furniture & Equipment 32,280 535 1,500 1,500 - 6830 Rent/Equipment 210 1,815 4,000 4,000 - 6835 Maintenance and Repair/Equipment - 30 - 250 250 6915 Utilities/Telephone 8,765 8,525 7,500 7,500 - Subtotal 88,120 51,580 74,380 66,740 (7,640) Purchased Water 6230 Dues & Subscriptions 31,410 50,350 70,000 50,350 (19,650) 6231 Outside Assessments 116,565 116,265 200,000 200,000 - 6493 Outside Services & Repairs 60,770 60,770 50,000 39,440 (10,560) 6563 Supplies/Special 1,242,525 1,269,525 1,500,000 1,400,000 (100,000) 7013 Water Rights Lease Expense 1,326,105 1,326,110 1,392,415 1,424,440 32,025 Subtotal 2,777,375 2,823,020 3,212,415 3,114,230 (98,185) Maintenance of Structures & Improvements 6493 Outside Services & Repairs 13,010 3,300 5,000 3,950 (1,050) 6554 Supplies/Custodial 125 - 670 670 - 6563 Supplies/Special 200 155 1,000 1,000 - 6569 Small Equipment - - 540 540 - 6805 Maintenance/Land Improvements 14,260 16,660 10,400 10,840 440 6815 Maint & Repairs/Bldgs 1,440 - 1,000 750 (250) Subtotal 29,035 20,115 18,610 17,750 (860) Maintenance of Reservoirs 6493 Outside Services & Repairs 16,720 7,655 25,000 17,750 (7,250) 6563 Supplies/Special 12,140 - 10,000 10,000 - Subtotal 28,860 7,655 35,000 27,750 (7,250) 372 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 Maintenance of Wells 6493 Outside Services & Repairs 10,080 113,200 175,000 126,210 (48,790) 6563 Supplies/Special 2,885 2,090 17,500 17,500 - 6569 Small Equipment 235 15,555 39,970 37,470 (2,500) Subtotal 13,200 130,845 232,470 181,180 (51,290) Fuel or Power Purchase 6904 Utilities/Other 824,920 817,360 1,100,000 1,000,000 (100,000) 6905 Utilities/Electricity 56,870 51,420 150,000 75,000 (75,000) 6910 Utilities/Natural Gas 780 825 5,500 5,500 - Subtotal 882,570 869,605 1,255,500 1,080,500 (175,000) Maintenance of Pumps/Boosters 6493 Outside Services & Repairs 26,130 42,270 70,000 55,220 (14,780) 6560 Repair Parts - - 280 280 - 6563 Supplies/Special 630 1,675 5,000 5,000 - Subtotal 26,760 43,945 75,280 60,500 (14,780) Chemicals & Filtering Materials 6493 Outside Services & Repairs - 5,365 10,000 7,890 (2,110) 6563 Supplies/Special 222,875 274,005 400,000 400,000 - Subtotal 222,875 279,370 410,000 407,890 (2,110) Maintenance of Structure & Improvements (Filter Plant) 6430 Custodial Services - 3,410 3,750 3,750 - 6493 Outside Services & Repairs 710 9,560 30,000 23,670 (6,330) 6530 Office Supplies - 325 580 580 - 6554 Supplies/Custodial 555 985 1,330 1,160 (170) 6563 Supplies/Special 8,195 5,255 7,500 7,500 - 6815 Maint & Repairs/Bldgs 1,115 1,630 2,500 1,860 (640) Subtotal 10,575 21,165 45,660 38,520 (7,140) 373 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 Maintenance of Water Treatment Equipment 6493 Outside Services & Repairs 16,045 24,095 40,000 43,390 3,390 6563 Supplies/Special 15,245 8,335 20,000 20,000 - 6569 Small Equipment 13,935 6,310 10,650 8,150 (2,500) Subtotal 45,225 38,740 70,650 71,540 890 Supervision & Engineering 6521 Messenger Service 210 240 250 250 - 6527 Supplies/Computer - - 1,500 1,500 - 6530 Office Supplies 1,460 2,415 2,330 2,330 - 6539 Printing, Binding & Duplicating - 540 800 500 (300) 6563 Supplies/Special 15 - 1,000 1,000 - 6572 Office Furniture & Equipment 1,305 990 750 750 - 6815 Maint & Repairs/Bldgs 15 - 500 370 (130) 6830 Rent/Equipment 5 - 1,500 1,500 - 6915 Utilities/Telephone 3,085 5,000 5,000 5,000 - Subtotal 6,095 9,185 13,630 13,200 (430) Storage Facilities 6563 Supplies/Special - - 2,500 2,500 - 6830 Rent/Equipment - - 1,500 1,500 - Subtotal - - 4,000 4,000 - Transmission & Distribution 6493 Outside Services & Repairs - - 1,500 790 (710) 6563 Supplies/Special - 45 5,000 5,000 - Subtotal - 45 6,500 5,790 (710) Meter 6563 Supplies/Special 145,860 232,730 150,000 100,000 (50,000) 6569 Small Equipment 38,465 30,460 60,560 30,560 (30,000) Subtotal 184,325 263,190 210,560 130,560 (80,000) 374 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 Customer Installation 6493 Outside Services & Repairs 5,730 4,950 1,500 1,180 (320) 6560 Repair Parts - - 800 800 - 6563 Supplies/Special - - 1,500 1,500 - Subtotal 5,730 4,950 3,800 3,480 (320) Maintenance of Structures & Improvements 6430 Custodial Services 1,285 1,870 3,750 3,750 - 6493 Outside Services & Repairs 1,920 - 12,500 8,680 (3,820) 6530 Office Supplies 1,220 600 890 890 - 6554 Supplies/Custodial 1,240 400 1,330 1,000 (330) 6563 Supplies/Special 1,800 3,025 3,000 3,000 - 6564 Supplies/Medical 275 - - - - 6805 Maintenance/Land Improvements 2,035 2,230 19,600 14,160 (5,440) 6815 Maint & Repairs/Bldgs 4,735 5,975 17,500 13,060 (4,440) 6915 Utilities/Telephone - 125 - - - Subtotal 14,510 14,225 58,570 44,540 (14,030) Maintenance of Transmission & Distribution Mains 6493 Outside Services & Repairs 440,010 262,425 265,000 256,360 (8,640) 6560 Repair Parts 70 345 1,330 31,330 30,000 6563 Supplies/Special 43,045 41,465 50,000 140,000 90,000 6566 Small Tools 3,555 2,705 4,500 4,500 - 6569 Small Equipment 2,505 670 2,660 2,660 - 6599 Materials and Supplies/Other - 55 - - - 6605 Filing Costs 9,190 32,155 13,000 13,000 - 6801 Rent/Land 2,610 2,610 1,500 1,500 - 6835 Maint & Repair/Equipment 10,485 3,595 5,000 5,000 - 6850 Lease Payments - 2,610 - - - Subtotal 511,470 348,635 342,990 454,350 111,360 375 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 Maintenance of Services 6560 Repair Parts 1,695 305 1,330 1,330 - 6563 Supplies/Special 12,130 5,650 15,000 15,000 - 6566 Small Tools 525 675 1,000 1,000 - 6835 Maint & Repair/Equipment 35 195 500 500 - Subtotal 14,385 6,825 17,830 17,830 - Maintenance of Meters 6493 Outside Services & Repairs 11,550 9,955 75,000 23,660 (51,340) 6560 Repair Parts 25 - 3,200 3,200 - 6563 Supplies/Special 165 - 1,500 1,500 - 6566 Small Tools - - 500 500 - Subtotal 11,740 9,955 80,200 28,860 (51,340) Maintenance of Hydrants 6560 Repair Parts 10 20 2,680 2,680 - 6563 Supplies/Special 285 410 7,500 7,500 - Subtotal 295 430 10,180 10,180 - Maintenance of Miscellaneous Plants 6560 Repair Parts 35 80 540 540 - 6563 Supplies/Special 6,100 1,605 10,000 10,000 - 6566 Small Tools 685 340 2,500 2,500 - 6569 Small Equipment 1,060 325 1,330 1,330 - 6835 Maint & Repair/Equipment 1,270 760 2,500 2,500 - Subtotal 9,150 3,110 16,870 16,870 - OPERATIONS SUBTOTAL 12,782,340 12,962,430 14,598,400 13,937,940 (660,460) 376 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 TRANSFERS OUT General 5950 Transfer Out 835,975 918,440 195,000 200,000 5,000 Subtotal 835,975 918,440 195,000 200,000 5,000 Administrative & General 5950 Transfer Out - - 5,000 - (5,000) Subtotal - - 5,000 - (5,000) TRANSFERS OUT SUBTOTAL 835,975 918,440 200,000 200,000 - WATER FUND TOTAL:16,387,870 16,865,290 17,984,930 17,353,555 (631,375) 377 THIS PAGE INTENTIONALLY LEFT BLANK 378 LIGHT & WATER ELECTRIC UTILITY PROGRAM COMMENTARY PROGRAM DESCRIPTION: Electric Utility consists of Power Resources Management, Engineering and Electric Operations. Power Resources Management is responsible for short-term, mid-term and long-term power resource planning and procurement; short term (including daily) power resource optimization, trading, and scheduling; after-the-fact energy accounting and financial settlements with the California Independent System Operator (CAISO) and trading counterparties, contract and transaction bill & invoice processing; participation in related state and federal regulatory processes; representing City’s interest in various industry forums; 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 electric service related projects within the City. Engineering is also responsible for determining and imposing utility related fees or charges necessary for utility requested services by customers. Finally, Engineering provides overall technical support and functional supervision to field operations to ensure that customer utility services or improvements are constructed in compliance with approved plans or specifications. Electric Operations manages the safe and reliable distribution of electric power from Azusa’s Substations through the electric distribution system to homes, business and industries. Electric Operations is responsible for construction, maintenance and operation of the electric distribution system and compliance with the various State of California General Orders governing construction, inspection and maintenance of those facilities: General Order 95 Rules for Overhead Line Construction, General Order 128 Rules for Construction of Underground Electric Supply and Communications Systems 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, procurement, and delivery in a cost-effective and environmentally 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. 379 THIS PAGE INTENTIONALLY LEFT BLANK 380 STRATEGIC GOALS: (continued) 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 or services. Engineering also seeks to manage capital improvement projects effectively with consideration to project timing, bid completion, compliance with approved plans and specifications, and ensure that fees collected are used to pay for utility-related services per customer applications. 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 efficient service to residential and commercial customers in a timely and professional manner and strive to maintain the RP3 Designation. FY 11-12 PROGRAM HIGHLIGHTS: Power Resources has made significant progress toward the Renewable Portfolio Standard of 20% renewable energy by 2010 with the installation of two additional wind turbines at Garnet Wind Project in Palm Springs. In FY 11-12, additional renewable energy opportunities will be explored to diversify our resource portfolio to meet anticipated greenhouse gas mandates. Power Resources has also successfully transitioned to the CAISO’s new market structures and established internal scheduling and settlements processes, and will continue to refine and enhance financial settlement processing required by the new market paradigm. During FY 11-12, Power Resources will continue to procure short term power and capacity as well as optimize power delivery from our long term resources. During FY 11-12, Engineering will perform functional testing and complete commissioning of the new Supervisory Control and Substation Data Acquisition System (SCADA). As planned, SCADA will provide remote monitoring and control of substation circuit breakers and also 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 areas designated for new developments. Engineering will continue support of the recently awarded RP3 Designation and provide assistance in the areas of System Improvements and Reliability Indices. Planning will also continue 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, Rockvale Avenue s/o Alosta Avenue, 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’s entire electric system and is followed up by detailed inspection of several major pieces of equipment and structures on a rotation schedule. When defects are uncovered, repairs are scheduled accordingly. The electric crews will continue installing electric facilities to support new and existing commercial and residential developments as needed, continue with removal of old V-style fuse cutouts and replace defective cutouts with new and continue to replace or upgrade overhead open wire secondary bus lines and house services to triplex conductors. In the next 24 months, Electric Operations will also focus and improve upon the 4 key elements of a reliable public power provider – RP3, namely, Safety, Workforce Development, Reliability and System Improvements. 381 Budget Division: LIGHT AND WATER - ELECTRIC (ALL) FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 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 $130,010 $130,010 0 0 0 $0 $0 Electric Distribution Supervisor 1.00 1.00 115,185 123,035 Electric Crew Supervisor 3.00 3.00 309,030 326,020 Line Mechanic 5.00 5.00 462,640 486,660 Line Mechanic Helper 1.00 1.00 65,570 66,880 Apprentice Line Mechanic 2.00 2.00 150,630 161,850 Senior Electric Test Technician 1.00 1.00 95,220 97,065 Electrical Test Technician 1.00 1.00 86,640 88,315 Apprentice Elec Test Technician 1.00 1.00 68,900 67,190 Senior Office Specialist 1.00 1.00 40,080 42,075 Senior Electrical Engineer 1.00 1.00 107,505 107,505 Electrical Engineer 1.00 1.00 104,065 104,065 Assistant Director-Resource Management 1.00 1.00 144,160 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,090,310 $2,155,505 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 382 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 PERSONNEL 6003 Salaries/Regular 1,687,820 1,617,140 2,090,310 2,155,505 65,195 6006 Salaries/Temp & Part-Time 18,605 19,120 - - - 6012 Salaries/Comp-Time 29,650 27,250 - - - 6015 Salaries/Vacation 114,645 98,225 - - - 6024 Salaries/Sick Leave 60,915 57,580 - - - 6027 Salaries/Bereavement 2,165 4,770 - - - 6030 Overtime Pay/Regular 9,175 2,950 21,500 11,500 (10,000) 6033 Overtime Pay/Premium 175,900 136,165 238,000 167,000 (71,000) 6039 Standby Pay/Premium 42,290 38,750 55,000 50,000 (5,000) 6045 Salaries/Education Incentive 8,080 6,335 5,855 5,850 (5) 6047 Salaries/Bonuses - 45,095 - - - 6048 Salaries/Language Pay 6,025 6,005 6,000 6,000 - 6063 Salaries/Jury Duty 4,835 3,310 - - - 6101 PERS/Employee Contribution 137,525 131,560 148,030 152,675 4,645 6105 PERS/Employer Contribution 236,035 213,160 244,185 275,275 31,090 6109 PARS/Employer Contribution 60,855 55,920 68,855 70,355 1,500 6125 FICA/Employer Contrib/Med 29,465 29,910 36,795 33,160 (3,635) 6133 Retiree Health Premium Reimb 4,180 4,745 5,165 5,165 - 6140 Life Insurance Allocation 5,960 4,535 5,580 5,780 200 6155 Workers' Comp Allocation 82,990 79,370 96,620 86,690 (9,930) 6160 LTD Insurance Allocation 16,215 12,965 16,255 16,765 510 6165 Unemployment Allocation 2,160 2,170 2,530 2,545 15 6175 Benefits/Flex Plan 293,850 297,705 368,080 375,165 7,085 6180 Deferred Comp/Employer Paid 9,780 7,230 10,080 10,080 - PERSONNEL SUBTOTAL 3,039,120 2,901,965 3,418,840 3,429,510 10,670 383 Budget Division: LIGHT AND WATER - ELECTRIC ENGINEERING FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Hours Hours Wages Wages Senior Electrical Engineer 1.00 1.00 $107,505 $107,505 Electrical Engineer 1.00 1.00 104,065 104,065 TOTAL 2.00 2.00 $211,570 $211,570 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 384 Budget Division: LIGHT AND WATER - ELECTRIC DISTRIBUTIONS & OPERATIONS FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 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 $130,010 130,010 Electric Distribution Supervisor 1.00 1.00 115,185 123,035 Electric Crew Supervisor 3.00 3.00 309,030 326,020 Line Mechanic 5.00 5.00 462,640 486,660 Line Mechanic Helper 1.00 1.00 65,570 66,880 Apprentice Line Mechanic 2.00 2.00 150,630 161,850 Senior Electric Test Technician 1.00 1.00 95,220 97,065 Electrical Test Technician 1.00 1.00 86,640 88,315 Apprentice Elec Test Technician 1.00 1.00 68,900 67,190 Senior Office Specialist 1.00 1.00 40,080 42,075 TOTAL 17.00 17.00 $1,523,905 $1,589,100 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 385 Budget Division: LIGHT AND WATER - POWER PURCHASES FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 FY 10-11 FY 11-12 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Hours Hours Wages Wages Assistant Director-Resource Management 1.00 1.00 $144,160 $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 3.00 3.00 $354,835 $354,835 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 386 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 PERSONNEL Distribution Operations-Supervision & Engineering 6003 Salaries/Regular 206,355 142,760 245,195 253,045 7,850 6012 Salaries/Comp-Time 210 315 - - - 6015 Salaries/Vacation 27,240 12,460 - - - 6024 Salaries/Sick Leave 7,425 3,910 - - - 6030 Overtime Pay/Regular 1,085 - 1,000 1,000 - 6033 Overtime Pay/Premium 11,290 1,790 16,000 16,000 - 6039 Standby Pay/Premium 7,690 680 10,000 10,000 - 6045 Salaries/Education Incentive 300 540 300 1,750 1,450 6063 Salaries/Jury Duty 4,160 - - - - 6047 Salaries/Bonuses - 4,615 - - - 6101 PERS/Employee Contribution 17,990 15,080 16,205 17,895 1,690 6105 PERS/Employer Contribution 30,865 18,510 26,760 32,305 5,545 6109 PARS/Employer Contribution 10,350 5,535 9,990 11,115 1,125 6125 FICA/Employer Contribution - 340 2,280 2,135 (145) 6133 Retiree Health Premium Reimb 4,180 4,745 5,165 5,165 - 6140 Life Insurance Allocation 815 430 610 680 70 6155 Workers' Comp Allocation 10,770 6,705 10,305 10,190 (115) 6160 LTD Insurance Allocation 2,105 1,205 1,790 1,970 180 6165 Unemployment Allocation 245 270 290 290 - 6175 Benefits/Flex Plan 28,995 19,415 32,570 33,455 885 6180 Deferred Comp/Employer Paid 1,740 450 1,800 1,800 - Subtotal 373,810 239,755 380,260 398,795 18,535 Distribution Operations-Overhead Lines 6003 Salaries/Regular 374,755 425,885 493,935 520,705 26,770 6012 Salaries/Comp-Time 14,640 13,265 - - - 6015 Salaries/Vacation 23,200 19,955 - - - 6024 Salaries/Sick Leave 21,480 22,180 - - - 6027 Salaries/Bereavement 490 2,385 - - - 6030 Overtime Pay/Regular 4,045 1,475 10,000 5,000 (5,000) 6033 Overtime Pay/Premium 74,195 58,965 108,000 70,000 (38,000) 6039 Standby Pay/Premium 17,300 19,035 22,500 20,000 (2,500) 387 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 6045 Salaries/Education Incentive 605 600 600 600 - 6047 Salaries/Bonuses - 16,740 - - - 6048 Salaries/Language Pay 1,205 1,195 1,200 1,200 - 6063 Salaries/Jury Duty - 1,185 - - - 6101 PERS/Employee Contribution 31,540 33,995 35,020 36,895 1,875 6105 PERS/Employer Contribution 54,170 56,815 57,710 66,455 8,745 6109 PARS/Employer Contribution 9,750 10,935 11,165 11,770 605 6125 FICA/Employer Contrib/Med 8,430 9,150 10,620 8,980 (1,640) 6140 Life Insurance Allocation 1,360 1,275 1,315 1,395 80 6155 Workers' Comp Allocation 19,445 21,860 25,450 20,900 (4,550) 6160 LTD Insurance Allocation 3,755 3,675 3,845 4,050 205 6165 Unemployment Allocation 545 590 730 620 (110) 6175 Benefits/Flex Plan 76,260 85,720 96,320 96,930 610 Subtotal 737,170 806,880 878,410 865,500 (12,910) Distribution Operations-Underground Lines 6003 Salaries/Regular 374,750 426,005 493,935 520,705 26,770 6012 Salaries/Comp-Time 14,640 13,265 - - - 6015 Salaries/Vacation 23,200 19,955 - - - 6024 Salaries/Sick Leave 21,480 22,180 - - - 6027 Salaries/Bereavement 490 2,385 - - - 6030 Overtime Pay/Regular 4,045 1,475 10,000 5,000 (5,000) 6033 Overtime Pay/Premium 74,195 62,790 103,000 70,000 (33,000) 6039 Standby Pay/Premium 17,300 19,035 22,500 20,000 (2,500) 6045 Salaries/Education Incentive 605 600 600 600 - 6047 Salaries/Bonuses - 16,740 - - - 6048 Salaries/Language Pay 1,205 1,195 1,200 1,200 - 6063 Salaries/Jury Duty - 1,185 - - - 6101 PERS/Employee Contribution 31,540 34,005 35,020 36,895 1,875 6105 PERS/Employer Contribution 54,170 56,825 57,710 66,455 8,745 6109 PARS/Employer Contribution 9,750 10,940 11,165 11,770 605 6125 FICA/Employer Contrib/Med 8,430 9,205 10,550 8,980 (1,570) 6140 Life Insurance Allocation 1,360 1,280 1,315 1,395 80 6155 Workers' Comp Allocation 19,445 21,960 25,250 20,900 (4,350) 6160 LTD Insurance Allocation 3,755 3,680 3,845 4,050 205 388 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 6165 Unemployment Allocation 545 595 725 620 (105) 6175 Benefits/Flex Plan 76,260 85,760 96,320 96,930 610 Subtotal 737,165 811,060 873,135 865,500 (7,635) Distribution Operations-Meters 6003 Salaries/Regular 157,505 160,160 250,760 252,570 1,810 6012 Salaries/Comp-Time 160 405 - - - 6015 Salaries/Vacation 16,485 15,910 - - - 6024 Salaries/Sick Leave 3,870 3,415 - - - 6027 Salaries/Bereavement 1,185 - - - - 6030 Overtime Pay/Regular - - 500 500 - 6033 Overtime Pay/Premium 14,440 11,765 10,000 10,000 - 6047 Salaries/Bonuses - 7,000 - - - 6048 Salaries/Language Pay 1,205 1,205 1,200 1,200 - 6101 PERS/Employee Contribution 12,880 12,930 17,725 17,850 125 6105 PERS/Employer Contribution 22,090 21,600 29,255 32,205 2,950 6109 PARS/Employer Contribution 4,145 4,160 5,665 5,710 45 6125 FICA/Employer Contrib/Med 1,600 1,680 2,930 2,785 (145) 6140 Life Insurance Allocation 575 480 675 680 5 6155 Workers' Comp Allocation 7,565 7,815 10,500 10,150 (350) 6160 LTD Insurance Allocation 1,550 1,350 1,950 1,965 15 6165 Unemployment Allocation 200 210 65 305 240 6175 Benefits/Flex Plan 30,290 31,685 52,540 52,870 330 Subtotal 275,745 281,770 383,765 388,790 5,025 Distribution Operations-Miscellaneous Distribution 6003 Salaries/Regular 40,995 35,305 40,080 42,075 1,995 6015 Salaries/Vacation 1,395 1,320 - - - 6024 Salaries/Sick Leave 1,265 1,825 - - - 6033 Overtime Pay/Premium - - 1,000 1,000 - 6101 PERS/Employee Contribution 3,440 2,715 2,835 2,975 140 6105 PERS/Employer Contribution 5,890 4,530 4,670 5,355 685 6125 FICA/Employer Contrib/Med 855 775 815 840 25 6140 Life Insurance Allocation 150 100 105 110 5 6155 Workers' Comp Allocation 1,810 1,540 1,645 1,685 40 389 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 6160 LTD Insurance Allocation 405 300 310 325 15 6165 Unemployment Allocation 55 55 55 60 5 6175 Benefits/Flex Plan 13,500 14,305 15,055 15,830 775 6180 Deferred Comp/Employer Paid 540 540 540 540 - Subtotal 70,300 63,310 67,110 70,795 3,685 Engineering 6003 Salaries/Regular 195,870 181,005 211,570 211,570 - 6015 Salaries/Vacation 16,000 19,355 - - - 6024 Salaries/Sick Leave 1,485 2,690 - - - 6045 Salaries/Education Incentive 3,650 2,680 2,905 1,450 (1,455) 6063 Salaries/Jury Duty - 940 - - - 6101 PERS/Employee Contribution 15,240 14,510 16,030 14,970 (1,060) 6105 PERS/Employer Contribution 26,140 24,260 26,470 27,020 550 6109 PARS/Employer Contribution 11,940 13,250 14,440 13,560 (880) 6125 FICA/Employer Contrib/Med 3,445 3,230 3,745 3,550 (195) 6140 Life Insurance Allocation 570 275 605 565 (40) 6155 Workers' Comp Allocation 8,815 8,265 9,125 8,520 (605) 6160 LTD Insurance Allocation 1,545 775 1,755 1,645 (110) 6165 Unemployment Allocation 160 100 260 245 (15) 6175 Benefits/Flex Plan 27,560 27,460 30,110 31,660 1,550 6180 Deferred Comp/Employer Paid 3,480 3,450 3,600 3,600 - Subtotal 315,900 302,245 320,615 318,355 (2,260) Power Purchases-Other Expenses 6003 Salaries/Regular 337,590 246,020 354,835 354,835 - 6006 Salaries/Temp & Part Time 18,605 19,120 - - - 6015 Salaries/Vacation 7,125 9,270 - - - 6024 Salaries/Sick Leave 3,910 1,380 - - - 6033 Overtime Pay/Premium 1,780 855 - - - 6045 Salaries/Education Incentive 2,920 1,915 1,450 1,450 - 6048 Salaries/Language Pay 2,410 2,410 2,400 2,400 - 6063 Salaries/Jury Duty 675 - - - - 6101 PERS/Employee Contribution 24,895 18,325 25,195 25,195 - 6105 PERS/Employer Contribution 42,710 30,620 41,610 45,480 3,870 390 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 6109 PARS/Employer Contribution 14,920 11,100 16,430 16,430 - 6125 FICA/Employer Contrib/Med 6,705 5,530 5,855 5,890 35 6140 Life Insurance Allocation 1,130 695 955 955 - 6155 Workers' Comp Allocation 15,140 11,225 14,345 14,345 - 6160 LTD Insurance Allocation 3,100 1,980 2,760 2,760 - 6165 Unemployment Allocation 410 350 405 405 - 6175 Benefits/Flex Plan 40,985 33,360 45,165 47,490 2,325 6180 Deferred Comp/Employer Paid 4,020 2,790 4,140 4,140 - Subtotal 529,030 396,945 515,545 521,775 6,230 PERSONNEL SUBTOTAL 3,039,120 2,901,965 3,418,840 3,429,510 10,670 391 Cost 6220 $16,260 6230 $10,000 6235 $10,000 6493 $3,750,000 6590 $26,030,710 6625 $300,000 7130 $70,000 7140 $280,000 7145 $335,000 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. ($10,000 Distribution; $1,000 Engineering; $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. ($1,000 Distribution; $1,000 Engineering; $8,000 Power Resources). LIGHT & WATER - ELECTRIC ACTIVITY DETAIL Account Number Description 3340733xxx, 3340735xxx, 3340745xxx, 3340775xxx, 3340785xxx, Lines, 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,505,165). Other services to support electric distribution system ($244,835). 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. 392 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 OPERATIONS 6201 Uniforms & Laundry 26,250 17,630 21,700 21,700 - 6215 Tuition Reimbursement 2,720 - - - - 6220 Training Schools 11,335 25,950 7,760 16,260 8,500 6225 Training Materials 1,365 715 900 900 - 6230 Dues & Subscriptions 8,525 7,805 10,000 10,000 - 6235 Meetings & Conferences 14,970 3,325 8,200 10,000 1,800 6240 Mileage Reimbursement 295 160 - - - 6301 Legal Fees 71,125 52,370 102,400 102,400 - 6340 Special Studies 725 1,860 - - - 6345 Program Consultants 2,550 - 3,200 3,200 - 6399 Professional Services/Other - 16,200 - - - 6424 Consumer Services Allocation 2,082,000 2,159,565 2,187,310 2,175,715 (11,595) 6430 Custodial Services 1,255 4,260 3,800 3,800 - 6493 Outside Services & Repairs 3,145,235 3,128,880 3,509,295 3,750,000 240,705 6521 Messenger Service 915 415 1,100 1,100 - 6530 Office Supplies 4,455 3,985 4,040 4,140 100 6539 Printing, Binding & Duplicating 110 95 80 80 - 6551 Fuel and Oil 21,780 21,910 17,500 20,800 3,300 6554 Supplies/Custodial & Cleaning 1,170 1,675 900 900 - 6563 Supplies/Special 40,490 19,235 25,300 29,800 4,500 6564 Supplies/Medical-Dental 2,430 1,400 2,200 2,200 - 6566 Small Tools 14,520 11,390 13,100 13,600 500 6569 Small Equipment 2,350 6,835 4,000 19,000 15,000 6590 Electricity For Resale 23,106,700 26,042,270 25,264,120 26,030,710 766,590 6601 Advertising Expense 190 700 - - - 6610 Bond Administration 5,000 2,500 2,500 2,500 - 6625 Program Expenses 13,290 303,650 300,000 300,000 - 6645 Relocation Costs - 4,935 - - - 6815 Maint & Repairs/Bldgs 18,250 24,435 17,600 17,600 - 6825 Maint & Repair / Vehicle 37,170 40,035 40,200 41,000 800 6827 Garage Allocation 2,370 2,570 3,800 3,800 - 6830 Rent/Equipment 20 75 150 150 - 6835 Maint & Repair/Equipment 6,985 1,890 1,200 1,200 - 6904 Utilities/Other 14,925 16,250 15,000 15,000 - 393 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 6905 Utilities / Electricity 10,200 8,290 5,700 10,200 4,500 6910 Utilities/Natural Gas 350 750 700 700 - 6915 Utilities/Telephone 9,570 11,285 8,265 8,265 - 7001 Interest Expense 534,295 511,390 468,615 443,160 (25,455) 7010 Franchise Fee (2%) 636,740 612,925 691,255 680,050 (11,205) 7012 In-lieu Fee (8%) 2,546,965 2,451,710 2,765,005 2,720,200 (44,805) 7055 Uncollectible Accounts 105,320 151,765 70,000 70,000 - OPERATIONS SUBTOTAL 32,504,910 35,673,085 35,576,895 36,530,130 953,235 CAPITAL OUTLAY 7130 Structures/Other 41,120 67,045 70,000 70,000 - 7135 Vehicles 155,810 305,845 619,500 - (619,500) 7140 Equipment & Machinery 293,335 236,775 430,000 280,000 (150,000) 7145 Lines, Mains & Sewers 393,655 255,165 485,000 335,000 (150,000) CAPITAL OUTLAY SUBTOTAL 883,920 864,830 1,604,500 685,000 (919,500) TRANSFERS OUT 5950 Transfer Out 396,110 8,100 9,450 8,170 (1,280) TRANSFERS OUT SUBTOTAL 396,110 8,100 9,450 8,170 (1,280) ELECTRIC FUND TOTAL: 36,824,060 39,447,980 40,609,685 40,652,810 43,125 394 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 OPERATIONS Interest - Long-Term Debt 7001 Interest Expense 534,295 511,390 468,615 443,160 (25,455) Subtotal 534,295 511,390 468,615 443,160 (25,455) Distribution Operations-Supervision & Engineering 6530 Office Supplies 555 400 240 240 - 6539 Printing, Binding & Duplicating 110 95 80 80 - 6566 Small Tools 40 615 - - - Subtotal 705 1,110 320 320 - Distribution Operations-Overhead Lines 6530 Office Supplies - 35 - 100 100 6563 Supplies/Special - 905 - 1,000 1,000 6566 Small Tools 10,655 8,170 10,000 10,000 - Subtotal 10,655 9,110 10,000 11,100 1,100 Distribution Operations-Underground Lines 6554 Supplies/Custodial and Cleaning - 485 - - - 6566 Small Tools 3,240 2,605 3,100 3,100 - Subtotal 3,240 3,090 3,100 3,100 - Distribution Operations-Street Lighting & Signal 6905 Utilities / Electricity 10,200 8,230 5,700 10,200 4,500 Subtotal 10,200 8,230 5,700 10,200 4,500 Distribution Operations-Meters 6566 Small Tools 585 - - 500 500 Subtotal 585 - - 500 500 395 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 Distribution Operations-Miscellaneous Distribution 6201 Uniforms & Laundry 26,250 17,630 21,700 21,700 - 6220 Training Schools 10,455 24,680 2,500 10,000 7,500 6225 Training Materials 1,365 715 900 900 - 6230 Dues & Subscriptions 8,525 7,805 10,000 10,000 - 6235 Meetings & Conferences 3,060 35 100 1,000 900 6240 Mileage Reimbursement 295 160 - - - 6301 Legal Fees 11,270 4,670 2,400 2,400 - 6340 Special Studies 725 - - - - 6521 Messenger Service 665 350 100 100 - 6530 Office Supplies 30 - - - - 6551 Fuel and Oil 21,780 21,045 17,500 20,000 2,500 6563 Supplies/Special 19,035 (2,015) 5,600 5,600 - 6564 Supplies/Medical-Dental 2,430 1,400 2,200 2,200 - 6569 Small Equipment 545 665 - 15,000 15,000 6601 Advertising Expense 190 700 - - - 6825 Maint & Repair / Vehicle 37,150 39,960 40,000 40,000 - 6827 Garage Allocation 2,370 2,570 3,800 3,800 - 6835 Maint & Repair/Equipment 5,960 1,120 - - - 6904 Utilities/Other 14,925 16,250 15,000 15,000 - 6905 Utilities/Electricity - 60 - - - 6910 Utilities/Natural Gas 350 750 700 700 - 6915 Utilities/Telephone 8,825 10,055 7,200 7,200 - Subtotal 176,200 148,605 129,700 155,600 25,900 Distribution Maintenance-Structures 6430 Custodial Services 1,255 4,260 3,800 3,800 - 6493 Outside Services & Repairs 4,320 8,205 2,600 2,520 (80) 6554 Supplies/Custodial & Cleaning 1,170 1,190 900 900 - 6815 Maint & Repairs/Bldgs 18,250 24,435 17,600 17,600 - 6825 Maintenance and Repair 20 - - - - Subtotal 25,015 38,090 24,900 24,820 (80) 396 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 Distribution Maintenance-Station Equipment 6493 Outside Services & Repairs 3,520 10,935 31,660 30,690 (970) 6563 Supplies/Special 2,905 835 1,100 1,100 - Subtotal 6,425 11,770 32,760 31,790 (970) Distribution Maintenance-Overhead Lines 6493 Outside Services & Repairs 137,340 161,195 119,740 145,410 25,670 6563 Supplies/Special 3,075 7,065 5,900 5,900 - 6835 Maint & Repair/Equipment 625 - - - - Subtotal 141,040 168,260 125,640 151,310 25,670 Distribution Maintenance-Underground Lines 6493 Outside Services & Repairs 16,450 10,125 48,300 46,820 (1,480) 6563 Supplies/Special 6,790 4,460 6,200 6,200 - 6835 Maint & Repair/Equipment 400 110 - - - Subtotal 23,640 14,695 54,500 53,020 (1,480) Distribution Maintenance-Transformer Lines 6493 Outside Services & Repairs 20,950 - - 19,390 19,390 Subtotal 20,950 - - 19,390 19,390 Distribution Maintenance-Street Lighting & Signals 6563 Supplies/Special 2,710 - - 2,000 2,000 Subtotal 2,710 - - 2,000 2,000 Distribution Maintenance-Meters 6563 Supplies/Special 5,975 7,985 6,500 8,000 1,500 6835 Maint & Repair/Equipment - 660 1,200 1,200 - Subtotal 5,975 8,645 7,700 9,200 1,500 Customer Accounts-Uncollectible Accounts 7055 Uncollectible Accounts 105,320 151,765 70,000 70,000 - Subtotal 105,320 151,765 70,000 70,000 - 397 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 Engineering 6215 Tuition Reimbursement 2,720 - - - - 6220 Training Schools 880 1,270 - 1,000 1,000 6235 Meetings & Conferences 3,000 - 100 1,000 900 6340 Special Studies - 1,860 - - - 6345 Program Consultants 2,550 - 3,200 3,200 - 6530 Office Supplies 3,280 3,460 2,800 2,800 - 6551 Fuel and Oil - 865 - 800 800 6825 Maint & Repair / Vehicle - 75 200 1,000 800 Subtotal 12,430 7,530 6,300 9,800 3,500 Resource Management - Purchased Power 6590 Electricity For Resale 23,106,700 26,042,270 25,264,120 26,030,710 766,590 Subtotal 23,106,700 26,042,270 25,264,120 26,030,710 766,590 Resource Management - Other 6220 Training Schools - - 5,260 5,260 - 6235 Meetings & Conferences 8,910 3,290 8,000 8,000 - 6301 Legal Fees 59,855 47,700 100,000 100,000 - 6399 Professional Services - 16,200 - - - 6521 Messenger Service 250 65 1,000 1,000 - 6530 Office Supplies 590 90 1,000 1,000 - 6569 Small Equipment 1,805 6,170 4,000 4,000 - 6625 Program Expenses 13,290 303,650 300,000 300,000 - 6645 Relocation Costs - 4,935 - - - 6830 Rent/Equipment 20 75 150 150 - 6915 Utilities/Telephone 745 1,230 1,065 1,065 - Subtotal 85,465 383,405 420,475 420,475 - Resources Management - Transmission 6493 Outside Services & Repairs 590,350 567,475 656,170 639,140 (17,030) Subtotal 590,350 567,475 656,170 639,140 (17,030) 398 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 Resources Management - Transmission by Others 6493 Outside Services & Repairs 2,372,305 2,370,945 2,650,825 2,866,030 215,205 Subtotal 2,372,305 2,370,945 2,650,825 2,866,030 215,205 Administrative & General 6424 Consumer Services Allocation 2,082,000 2,159,565 2,187,310 2,175,715 (11,595) Subtotal 2,082,000 2,159,565 2,187,310 2,175,715 (11,595) Franchise Fees 7010 Franchise Fee (2%) 636,740 612,925 691,255 680,050 (11,205) 7012 In-lieu Fee (8%) 2,546,965 2,451,710 2,765,005 2,720,200 (44,805) Subtotal 3,183,705 3,064,635 3,456,260 3,400,250 (56,010) Interest Transfers 6610 Bond Administration 5,000 2,500 2,500 2,500 - Subtotal 5,000 2,500 2,500 2,500 - OPERATIONS SUBTOTAL 32,504,910 35,673,085 35,576,895 36,530,130 953,235 CAPITAL OUTLAY Structures & Improvements 7130 Structures/Other 20 280 10,000 10,000 - Subtotal 20 280 10,000 10,000 - Station Equipment 7140 Equipment & Machinery 4,860 260 25,000 25,000 - Subtotal 4,860 260 25,000 25,000 - Poles, Towers & Fixtures 7130 Structures/Other 30,045 57,540 35,000 35,000 - 7140 Equipment & Machinery 180 355 - - - 7145 Lines, Mains & Sewers 3,070 6,425 - - - Subtotal 33,295 64,320 35,000 35,000 - 399 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 Overhead Conductors & Dev 7130 Structures/Other 1,560 125 - - - 7140 Equipment & Machinery 5 - - - - 7145 Lines, Mains & Sewers 76,545 128,095 85,000 85,000 - Subtotal 78,110 128,220 85,000 85,000 - Underground Conduit 7130 Structures/Other 9,360 9,085 25,000 25,000 - 7140 Equipment & Machinery 100 - - - - Subtotal 9,460 9,085 25,000 25,000 - Underground Conductors & Dev 7130 Structures/Other 5 15 - - - 7145 Lines, Mains & Sewers 314,040 120,645 400,000 250,000 (150,000) Subtotal 314,045 120,660 400,000 250,000 (150,000) Line Transformers 7140 Equipment & Machinery 113,505 97,810 250,000 100,000 (150,000) Subtotal 113,505 97,810 250,000 100,000 (150,000) Meters 7140 Equipment & Machinery 145,845 83,730 90,000 90,000 - Subtotal 145,845 83,730 90,000 90,000 - Street Lighting 7130 Structures/Other 130 - - - - 7140 Equipment & Machinery 22,980 48,750 50,000 50,000 - Subtotal 23,110 48,750 50,000 50,000 - 400 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #08-09 09-10 10-11 11-12 Transportation Equipment 7135 Vehicles 155,810 305,845 619,500 - (619,500) Subtotal 155,810 305,845 619,500 - (619,500) Tools, Shop Equipment 7140 Equipment & Machinery 5,860 5,870 15,000 15,000 - Subtotal 5,860 5,870 15,000 15,000 - CAPITAL OUTLAY SUBTOTAL 883,920 864,830 1,604,500 685,000 (919,500) TRANSFERS OUT General 5950 Transfers Out 388,010 - - - - Subtotal 388,010 - - - - Dist Oper - Overhead Line Expenses 5950 Transfers Out 4,050 4,050 4,725 4,085 (640) Subtotal 4,050 4,050 4,725 4,085 (640) Dist Oper - Underground Line Expenses 5950 Transfers Out 4,050 4,050 4,725 4,085 (640) Subtotal 4,050 4,050 4,725 4,085 (640) TRANSFERS OUT SUBTOTAL 396,110 8,100 9,450 8,170 (1,280) ELECTRIC FUND TOTAL: 36,824,060 39,447,980 40,609,685 40,652,810 43,125 401 THIS PAGE INTENTIONALLY LEFT BLANK 402