Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
11. Light and Water-FY1213_201210041507120718
LIGHT AND WATER Public Benefit Programs Recycling and Solid Waste Consumer Services Water Utility Electric Utility THIS PAGE INTENTIONALLY LEFT BLANK 310 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. AB 1890 authorized municipal utilities to impose a surcharge on customers to pay for these investments, and, at this time, the usage surcharge, referred to as the public benefit charge (PBC), is expected to continue indefinitely for all California Publicly Owned Utilities. The Public 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 $625,000 during FY 2012-13. 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 12-13 PROGRAM HIGHLIGHTS: Several conservation programs have been developed over the years under the Public Benefits Program and will continue during FY 12-13. 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, washing machines and dishwashers; (6) Air Conditioner Rebate Program; (7) Shade Tree Program; (8) Residential Low Income assistance; (9) Educational and online learning opportunities regarding energy conservation; and (10) ICE Energy or thermal storage units to offset peak power demand for some customers. The new “Keep Your Cool” program, targeted at small independently owned and operated convenience stores, was added last year and has been fully subscribed over the last six months of the fiscal year. 311 Budget Division: LIGHT AND WATER - PUBLIC BENEFIT PROGRAMS FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Business Dev/Pub Benefit Prog Coord (a)0.70 0.00 $61,560 $0 Drought Tech 390 390 $7,140 $7,140 Asst Director-Cust Care and Solutions(b)0.15 0.15 19,050 19,050 Customer Service Representative II (c)0.05 0.00 2,510 0 Economic & Community Dev Director (d)0.00 0.20 - 32,015 Assistant Director of Community Dev (e)0.00 0.20 - 22,665 (a) .30 FTE Water (b) .85 FTE Consumer Services-Employee Expense (c) FY 2011-12: 0.95 FTE Consumer Services-Records & Collections (a) .15 FTE Planning, .35 FTE Building, .30 FTE Comm. Improvement (b) .50 FTE Planning, .15 FTE Building, .15 FTE Comm. Improvement TOTAL 0.90 0.55 $83,120 $73,730 TOTAL 390 390 $7,140 $7,140 Full Time Positions Part Time Positions 312 BUDGET UNIT: 2440739xxx L&W PUBLIC BENEFIT PROGRAMS DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #09-10 10-11 11-12 12-13 VARIANCE PERSONNEL ADMINISTRATION OF PBC 6003 Salaries/Regular 51,920 73,755 83,120 73,730 (9,390) 6006 Salaries/Temp & Part-Time 4,010 - 7,140 7,140 - 6015 Salaries/Vacation 3,745 2,820 - - - 6024 Salaries/Sick Leave 565 1,605 - - - 6027 Salaries/Bereavement - 50 - - - 6045 Salaries/Education Incentive 1,020 1,020 1,015 290 (725) 6048 Salaries/Language - 120 120 - (120) 6069 Allowances/Vehicle - - - 1,080 1,080 6075 Vacation/Payoff - - - 20,680 20,680 6080 Sick Leave/Payoff - - - 27,655 27,655 6101 PERS/Employee Contribution 4,025 5,580 5,610 5,270 (340) 6105 PERS/Employer Contribution 6,725 9,250 10,060 9,765 (295) 6109 PARS/Employer Contribution 3,820 5,725 4,805 6,990 2,185 6125 FICA/Employer Contrib/Med 1,040 1,400 1,355 1,320 (35) 6140 Life Insurance Allocation 150 210 205 200 (5) 6155 Workers' Comp Allocation 2,450 3,175 3,150 3,290 140 6160 LTD Insurance Allocation 440 610 605 575 (30) 6165 Unemployment Allocation 55 80 95 85 (10) 6175 Benefits/Flex Plan 10,085 13,460 14,335 8,635 (5,700) 6180 Deferred Comp/Employer Paid 1,260 1,510 1,530 845 (685) SUBTOTAL 91,310 120,370 133,145 167,550 34,405 PERSONNEL SUBTOTAL 91,310 120,370 133,145 167,550 34,405 313 Cost 2440739000 6625 $1,218,000 LIGHT & WATER - PUBLIC BENEFITS PROGRAM ACTIVITY DETAIL Account Number Description Program Expense - Low Income Assistance Program ($50,000), Energy Efficiency Program ($1,038,000), Renewables Program ($60,000), Research & Development ($10,000), Other Program Expenses ($60,000). 314 BUDGET UNIT: 2440739xxx L&W PUBLIC BENEFIT PROGRAMS DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #09-10 10-11 11-12 12-13 VARIANCE OPERATIONS RESIDENTIAL LOW INCOME 6625 Program Expense 31,570 42,085 40,000 50,000 10,000 SUBTOTAL 31,570 42,085 40,000 50,000 10,000 ENERGY EFFICIENCY PROGRAM 6625 Program Expense 605,555 929,000 940,000 1,038,000 98,000 SUBTOTAL 605,555 929,000 940,000 1,038,000 98,000 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 2,000 1,000 6625 Program Expense 15,390 32,765 40,000 60,000 20,000 6755 Claims Expense/Unemployment - - - 23,400 6825 Maint & Repair/Vehicle - - 7,200 8,000 800 SUBTOTAL 15,390 32,765 48,200 93,400 21,800 OPERATIONS SUBTOTAL 652,515 1,003,850 1,098,200 1,251,400 129,800 PUBLIC BENEFIT PROG FUND TOTAL 743,825 1,124,220 1,231,345 1,418,950 187,605 315 THIS PAGE INTENTIONALLY LEFT BLANK 316 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. 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. Develop additional waste diversion programs to make progress toward the goal of 75% waste diversion as set by AB 341. 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. Modernize residential trash collection services by considering an automated trash collection system. FY 12-13 PROGRAM HIGHLIGHTS: Prepare AB 939 report for calendar year 2011 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. Review results of Commercial Recycling Technical Assistance program provided during FY 2011-12 and consider implementation of an organics collection program for certain businesses. 317 Budget Division: LIGHT AND WATER - RECYCLING AND SOLID WASTE FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary 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 318 BUDGET UNIT: 3940750065/3640750000 LIGHT & WATER-SOLID WASTE MGT DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #09-10 10-11 11-12 12-13 VARIANCE PERSONNEL AB 939 FEE 6003 Salaries/Regular 49,770 47,795 56,135 56,135 - 6012 Salaries/Comp-Time 185 430 - - - 6015 Salaries/Vacation 2,835 5,055 - - - 6024 Salaries/Sick Leave 1,840 2,290 - - - 6027 Salaries/Bereavement 480 - - - - 6045 Salaries/Education Incentive 365 365 365 365 - 6063 Salaries/Jury Duty - 60 - - - 6101 PERS/Employee Contribution 3,975 4,005 4,015 4,015 - 6105 PERS/Employer Contribution 6,640 6,640 7,210 7,445 235 6109 PARS/Employer Contribution 1,640 1,915 1,625 1,625 - 6125 FICA/Employer Contrib/Med 1,015 935 990 985 (5) 6140 Life Insurance Allocation 150 150 150 150 - 6155 Workers' Comp Allocation 2,260 2,280 2,260 2,260 - 6160 LTD Insurance Allocation 435 435 435 435 - 6165 Unemployment Allocation 65 60 70 70 - 6175 Benefits/Flex Plan 10,485 11,370 11,875 11,585 (290) 6180 Deferred Comp/Employer Paid 710 720 720 720 - SUBTOTAL 82,850 84,505 85,850 85,790 (60) PERSONNEL SUBTOTAL 82,850 84,505 85,850 85,790 (60) 319 Cost 3940750065 6235 $270 6625 $19,920 6455 $2,763,590 7055 $15,000 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. Uncollectible Accounts - This is for write offs of uncollectible accounts. LIGHT & WATER - RECYCLING AND SOLID WASTE ACTIVITY DETAIL Account Number Description 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,770), school beverage container recycling ($12,410), disposal of hazardous waste generated from city facilities ($9,490), promotion of proper disposal of sharps waste ($2,900), promotion of backyard composting ($5,530), and Commercial Recycling Programs ($2,000). 320 BUDGET UNIT: 3940750065/3640750000 LIGHT & WATER-SOLID WASTE MGT DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #09-10 10-11 11-12 12-13 VARIANCE OPERATIONS OIL BLOCK GRANT 6625 Program Expense 8,130 13,410 13,000 13,770 770 SUBTOTAL 8,130 13,410 13,000 13,770 770 BEVERAGE CONTAINER RECYCLING 6625 Program Expense 5,715 500 12,700 12,410 (290) SUBTOTAL 5,715 500 12,700 12,410 (290) AB 939 FEE 6220 Training Schools 895 - 500 - (500) 6235 Meetings & Conferences - 350 1,000 270 (730) 6301 Legal Fees 3,300 - 4,000 3,300 (700) 6493 Outside Services & Repairs - - 200 - (200) 6518 Postage 1,380 845 2,000 1,750 (250) 6527 Supplies/Computer - - 500 140 (360) 6530 Office Supplies - - 200 - (200) 6539 Printing, Binding & Duplicating 1,895 2,145 2,000 6,150 4,150 6572 Office Furniture & Equipment 590 - 500 - (500) 6625 Program Expense 32,990 84,775 158,900 19,920 (138,980) 6915 Utilities/Telephone 340 930 710 - (710) 7025 Overhead Expense 33,655 33,655 33,655 33,655 - SUBTOTAL 75,045 122,700 204,165 65,185 (138,980) REFUSE CONTRACT 6455 Refuse Collection 2,894,390 2,927,250 2,944,060 2,763,590 (180,470) 7055 Uncollectible Accounts 29,915 35,145 30,000 15,000 (15,000) SUBTOTAL 2,924,305 2,962,395 2,974,060 2,778,590 (195,470) OPERATIONS SUBTOTAL 3,013,195 3,099,005 3,203,925 2,869,955 (333,970) 321 BUDGET UNIT: 3940750065/3640750000 LIGHT & WATER-SOLID WASTE MGT DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED Acct. #09-10 10-11 11-12 12-13 VARIANCE TRANSFERS OUT REFUSE CONTRACT 5950 Transfers Out 590,000 541,400 602,190 675,410 73,220 SUBTOTAL 590,000 541,400 602,190 675,410 73,220 TRANSFERS OUT SUBTOTAL 590,000 541,400 602,190 675,410 73,220 SOLID WASTE MGMT. TOTAL 3,686,045 3,724,910 3,891,965 3,631,155 (260,810) FUNDING: AB 939 FEE FUND 39 (157,895) (207,205) (290,015) (150,975) (139,040) GRANT FUND 28 (13,845) (13,910) (25,700) (26,180) 480 REFUSE FUND 36 (3,514,305) (3,503,795) (3,576,250) (3,454,000) (122,250) Total Funding (3,686,045) (3,724,910) (3,891,965) (3,631,155) (260,810) 322 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 will continue 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 also 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. 323 THIS PAGE INTENTIONALLY LEFT BLANK 324 FY 12-13 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 continue to 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. In 2012-13, Customer Service will be able to process customer home banking payments in real-time, eliminating the current one week delay. Also, to improve the customer call experience, new call center software will be considered that can tell customers the estimated call hold time, has a customer call back feature if hold time is long, offers a customer survey after each call, and other features. Periodic updates to the Customer Information System will continue this year. 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. 325 Budget Division: LIGHT AND WATER - CONSUMER SERVICES (ALL) FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Director of Utilities 1.00 1.00 $182,000 $182,000 Cashiers 3,328 3,328 $58,570 $48,260 Assistant to the Director of Utilities(a)0.75 0.75 76,095 76,095 Drought Tech 1,560 1,170 27,295 22,485 Senior Management Analyst 1.00 1.00 76,095 76,095 Cust Srv Rep I 1,664 3,224 38,520 68,670 Senior Administrative Technician(b)0.50 0.50 30,770 30,770 Office Spec I 1,664 0 35,015 0 Asst Director-Cust Care and Solutions(c)0.85 0.85 107,955 107,955 Customer Care Operations Supervisor 1.00 1.00 79,460 80,435 Customer Services Representative II(d)0.95 0.00 50,370 0 Customer Services Representative II 10.00 11.00 573,095 647,995 Field Services Representative 2.00 2.00 130,770 132,410 Field Services Supervisor 1.00 1.00 73,900 65,465 Meter Reader 6.00 6.00 375,420 380,120 Administrative Analyst 1.00 1.00 59,520 59,520 City Manager(e)0.00 0.20 0 38,400 Finance Director(f)0.00 0.05 0 6,970 (a) .25 FTE Recycling and Solid Waste (b) .50 FTE Recycling and Solid Waste (c) .15 FTE Public Benefits (d) .05 FTE Public Benefits (e) .20 FTE CFD-Rosedale; .60 FTE Administration (f).25 FTE-CFD Rosedale; .65 FTE-Finance.; .05 FTE-PW Engineering TOTAL 26.05 26.35 $1,815,450 $1,884,230 TOTAL 8,216 7,722 $159,400 $139,415 Full Time Positions Part Time Positions 326 BUDGET UNIT: ALL FUND 31 DIVISIONS-CONSUMER SERVICES (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 PERSONNEL 6003 Salaries/Regular 1,563,740 1,590,650 1,815,450 1,884,230 68,780 6006 Salaries/Temp & Part-Time 146,940 148,765 159,400 139,415 (19,985) 6012 Salaries/Comp-Time 1,320 4,025 - - - 6015 Salaries/Vacation 95,530 104,020 - - - 6024 Salaries/Sick Leave 66,570 71,850 - - - 6027 Salaries/Bereavement 5,495 950 - - - 6033 Overtime Pay/Premium 8,225 1,175 12,500 12,500 - 6045 Standby Pay/Premium 5,915 4,050 4,105 4,340 235 6047 Salaries/Bonuses 43,365 - - - - 6048 Salaries/Language Pay 17,560 16,295 15,480 15,600 120 6063 Salaries/Jury Duty 425 2,085 - - - 6069 Allowances/Vehicle 5,115 26,425 27,375 26,400 (975) 6070 Allowances/Telephone - - 190 300 110 6072 Salaries/Injury 1,490 2,690 - - - 6091 Leave Liability Adjustments (8,980) (26,700) - - - 6101 PERS/Employee Contribution 132,765 137,640 132,480 134,130 1,650 6105 PERS/Employer Contribution 221,670 228,265 238,905 249,775 10,870 6109 PARS/Employer 54,645 65,350 72,065 73,720 1,655 6125 FICA/Employer Contrib/Med 31,430 31,630 34,810 34,870 60 6133 Retiree Health Premium Reimb 7,445 9,170 9,070 10,975 1,905 6140 Life Insurance Allocation 4,640 4,720 5,025 5,075 50 6155 Workers' Comp Allocation 78,375 78,040 81,875 82,465 590 6160 LTD Insurance Allocation 13,320 13,510 14,465 14,665 200 6165 Unemployment Allocation 2,275 2,125 2,510 2,520 10 6175 Benefits/Flex Plan 409,330 428,135 454,130 445,130 (9,000) 6180 Deferred Comp/Employer Paid 6,010 9,475 8,915 12,080 3,165 PERSONNEL SUBTOTAL 2,914,615 2,954,340 3,088,750 3,148,190 59,440 327 Budget Division: LIGHT AND WATER - CONSUMER SERVICES-ADMINISTRATION FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Director of Utilities 1.00 1.00 $182,000 $182,000 Office Spec I 1,054 0 $22,180 $0 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 City Manager(c)0.00 0.20 0 38,400 Asst. City Manager(d)0.00 0.00 0 0 Finance Director(e)0.00 0.05 0 6,970 (a) .25 FTE Solid Waste (b) .50 FTE Solid Waste (c) .20 FTE CFD-Rosedale; .60 FTE Administration (d) .10 FTE CFD-Rosedale; .80 FTE Administration (e).25 FTE-CFD Rosedale; .65 FTE-Finance.; .05 FTE-PW Engineering TOTAL 3.25 3.50 $364,960 $410,330 TOTAL 1,054 0 $22,180 $0 Full Time Positions Part Time Positions 328 Budget Division: LIGHT AND WATER - CONSUMER SERVICES-CUSTOMER CARE FIELD SRV FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Field Services Representative 2.00 2.00 $130,770 $132,410 Drought Tech 1,560 780 $27,295 $14,280 Field Services Supervisor 1.00 1.00 73,900 65,465 Meter Reader 6.00 6.00 375,420 380,120 TOTAL 9.00 9.00 $580,090 $577,995 TOTAL 1,560 780 $27,295 $14,280 Full Time Positions Part Time Positions 329 Budget Division: LIGHT AND WATER - CONSUMER SERVICES-CUST. CARE RECS & COLL. FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Administrative Analyst 1.00 1.00 $59,520 $59,520 Cashiers 3,328 3,328 $58,570 $48,260 Customer Care Operations Supervisor 1.00 1.00 79,460 80,435 Cust Srv Rep I 1,664 3,224 38,520 68,670 Customer Services Representative II (a)0.95 0.00 50,370 0 Office Spec II 610 0 12,835 0 Customer Services Representative III 10.00 11.00 573,095 647,995 Drought Tech 390 390 8,205 8,205 (a) .05 FTE Public Benefits TOTAL 12.95 13.00 $762,445 $787,950 TOTAL 5,992 6,942 $118,130 $125,135 Full Time Positions Part Time Positions 330 Budget Division: LIGHT AND WATER - CONSUMER SERVICES-CUST. CARE EMPLOYEE EXP. FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Asst Director-Cust Care and Solutions (a)0.85 0.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 331 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 PERSONNEL Utility Board 6069 Allowances/Vehicle - 21,000 21,000 21,000 - Subtotal - 21,000 21,000 21,000 - Utility Administration 6003 Salaries/Regular 328,520 345,945 364,960 410,330 45,370 6006 Salaries/Temp & Part-Time 24,725 20,695 22,180 - (22,180) 6012 Salaries/Comp-Time 185 430 - - - 6015 Salaries/Vacation 11,555 13,335 - - - 6024 Salaries/Sick Leave 5,410 6,140 - - - 6027 Salaries/Bereavement 1,440 - - - - 6045 Salaries/Education Incentive 2,545 2,555 2,605 2,540 (65) 6063 Salaries/Jury Duty - 180 - - - 6069 Allowances/Vehicle 5,115 5,425 6,375 5,400 (975) 6070 Allowances/Telephone - - 190 300 110 6101 PERS/Employee Contribution 26,390 27,345 28,380 29,070 690 6105 PERS/Employer Contribution 44,085 45,325 51,210 54,145 2,935 6109 PARS/Employer Contribution 17,615 28,730 32,030 32,575 545 6125 FICA/Employer Contrib/Med 5,890 6,340 7,065 6,870 (195) 6140 Life Insurance Allocation 875 910 1,090 1,115 25 6155 Workers' Comp Allocation 15,020 15,570 17,285 16,740 (545) 6160 LTD Insurance Allocation 2,695 2,835 3,115 3,190 75 6165 Unemployment Allocation 535 390 490 480 (10) 6175 Benefits/Flex Plan 47,230 50,285 55,605 54,940 (665) 6180 Deferred Comp/Employer Paid 3,670 7,380 6,845 10,010 3,165 Subtotal 543,500 579,815 599,425 627,705 28,280 332 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 Field Services 6003 Salaries/Regular 504,790 513,485 580,090 577,995 (2,095) 6006 Salaries/Temp & Part-Time 27,645 21,820 27,295 14,280 (13,015) 6012 Salaries/Comp-Time 820 2,345 - - - 6015 Salaries/Vacation 33,835 37,710 - - - 6024 Salaries/Sick Leave 9,420 12,215 - - - 6027 Salaries Bereavement 1,310 - - - - 6033 Overtime Pay/Premium 7,965 805 - - - 6047 Salaries/Bonuses 20,295 - - - - 6048 Salaries/Language Pay 3,650 3,150 2,400 2,400 - 6063 Salaries/Jury Duty - 865 - - - 6072 Salaries / Injury - 405 - - - 6101 PERS/Employee Contribution 40,060 42,405 41,030 40,890 (140) 6105 PERS/Employer Contribution 66,890 70,335 73,980 76,145 2,165 6109 PARS/Employer Contribution 13,595 13,120 13,115 13,070 (45) 6125 FICA/Employer Contrib/Med 10,595 10,240 11,140 10,865 (275) 6140 Life Insurance Allocation 1,490 1,530 1,555 1,540 (15) 6155 Workers' Comp Allocation 24,460 23,905 24,380 23,790 (590) 6160 LTD Insurance Allocation 4,200 4,320 4,505 4,505 - 6165 Unemployment Allocation 665 645 770 755 (15) 6175 Benefits/Flex Plan 142,390 149,975 158,625 154,980 (3,645) Subtotal 914,075 909,275 938,885 921,215 (17,670) Customer Records & Collections 6003 Salaries/Regular 615,930 627,705 762,445 787,950 25,505 6006 Salaries/Temp & Part-Time 94,570 106,250 109,925 125,135 15,210 6012 Salaries/Comp-Time 315 1,250 - - - 6015 Salaries/Vacation 41,625 49,855 - - - 6024 Salaries/Sick Leave 47,150 50,895 - - - 6027 Salaries Bereavement 2,745 950 - - - 6033 Overtime Pay/Premium 260 370 12,500 12,500 - 6045 Salaries/Education Incentive 3,370 1,495 1,500 1,800 300 6047 Salaries/Bonuses 23,070 - - - - 6048 Salaries/Language Pay 13,910 13,145 13,080 13,200 120 6063 Salaries/Jury Duty 425 1,040 - - - 6072 Salaries/Injury 1,490 2,285 - - - 333 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 6091 Leave Liability Adjustment (8,980) (26,700) - - - 6101 PERS/Employee Contribution 57,360 60,225 55,485 56,585 1,100 6105 PERS/Employer Contribution 95,725 99,895 100,025 105,345 5,320 6109 PARS/Employer Contribution 15,255 15,420 20,000 21,155 1,155 6125 FICA/Employer Contrib/Med 12,730 13,185 14,845 15,380 535 6133 Retiree Health Premium Reimb 7,445 9,170 9,070 10,975 1,905 6140 Life Insurance Allocation 1,935 1,990 2,095 2,135 40 6155 Workers' Comp Allocation 33,790 34,195 35,890 37,615 1,725 6160 LTD Insurance Allocation 5,430 5,510 6,005 6,130 125 6165 Unemployment Allocation 930 965 1,130 1,165 35 6175 Benefits/Flex Plan 205,405 214,885 226,445 222,085 (4,360) 6180 Deferred Comp/Employer Paid 540 540 540 540 - Subtotal 1,272,425 1,284,520 1,370,980 1,419,695 48,715 Employee Related 6003 Salaries/Regular 114,500 103,515 107,955 107,955 - 6015 Salaries/Vacation 8,515 3,120 - - - 6024 Salaries/Sick Leave 4,590 2,600 - - - 6101 PERS/Employee Contribution 8,955 7,665 7,585 7,585 - 6105 PERS/Employer Contribution 14,970 12,710 13,690 14,140 450 6109 PARS/Employer 8,180 8,080 6,920 6,920 - 6125 FICA/Employer Contrib/Med 2,215 1,865 1,760 1,755 (5) 6140 Life Insurance Allocation 340 290 285 285 - 6155 Workers' Comp Allocation 5,105 4,370 4,320 4,320 - 6160 LTD Insurance Allocation 995 845 840 840 - 6165 Unemployment Allocation 145 125 120 120 - 6175 Benefits/Flex Plan 14,305 12,990 13,455 13,125 (330) 6180 Deferred Comp/Employer Paid 1,800 1,555 1,530 1,530 - Subtotal 184,615 159,730 158,460 158,575 115 PERSONNEL SUBTOTAL 2,914,615 2,954,340 3,088,750 3,148,190 59,440 334 Cost 3140701xxx, 3140702xxx, 3140711xxx, 6220 $3,500 6230 $350 6235 $28,750 6415 $175,600 6493 $192,700 6539 $17,500 Dues/Subscriptions - Azusa Chamber of Commerce, CMUA, Southern California Public Power Authority (SCPPA), APPA, and Customer Service Newsletter for Customer Service Representatives (CSRs). ($250 for Admin; $100 for CS) Meeting/Conferences - APPA Legislative Rally, APPA National Conference, CEC Meetings, CMUA Annual Conference and Board Meetings, CMUA Capitol Day, CMUA Utility Managers Summit, Executive Steering Committee, Light & Water Key Accounts Meeting, Lodi Energy Center Meetings, National League of Cities Conference, NCPA Annual Conference and Directors Meeting, Public Officials Workshop, San Juan Power Operations Meetings, SCPPA Congressional Tour, State of the City, UAMPS Annual Meeting, and Users' meeting of Customer Information System service provider, Systems & Software (S&S), and National Association of Credit Management (NACM) conference. ($7,100 for UB; $16,450 for Admin; $5,200 for CS) Computer Software Services - Customer Service Program-related expenses, including Customer Information System maintenance, phone system maintenance, and various software licenses. ($175,600 for CS) Outside Services & Repairs - Pest control services, document archive/retrieve services, locksmith services, Itron maintenance, Verizon - TOU customer modem bills, 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,400 for Admin; $186,300 for CS) Printing, Binding & Duplicating - Copier's printing & copying fees, business card printing, and utility billing inserts. ($2,500 for Admin; $10,000 for CS). LIGHT & WATER - CONSUMER SERVICES ACTIVITY DETAIL Account Number Description Training Schools - American Public Power Association (APPA) training workshops; California Municipal Utilities Association (CMUA) training workshops; Liebert Cassidy Whitmore training workshops via City’s membership in the San Gabriel Valley Employment Relations Consortium; and other work related training as deemed necessary by Utilities Administration and Customer Services Division. ($500 for Admin; $3,000 for CS) 335 CostAccount Number Description 6601 $2,000 6815 $29,600 6825 $12,000 6835 $48,755 6915 $11,650 7050 $57,500 Maintenance & Repair of Vehicles - Miscellaneous repairs for Meter Reader trucks 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,755 for Admin; $12,000 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. ($57,500 for UB & Admin) Utilities/Telephone - Cell phone and other phone charges. ($2,650 for Admin; $9,000 for CS) Maintenance & Repair of Building - Light & Water Office building roof annual maintenance and other miscellaneous repairs ($29,600 for Admin) Advertising Expense - Recreation Gym Decal and miscellaneous. ($2,000 for Admin) 336 BUDGET UNIT: ALL FUND 31 DIVISIONS-CONSUMER SERVICES (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 OPERATIONS 6201 Uniforms & Laundry 14,310 13,090 15,000 15,000 - 6210 Employee Awards - - 300 300 - 6220 Training Schools 955 1,130 2,500 3,500 1,000 6230 Dues & Subscriptions 445 295 550 350 (200) 6235 Meetings & Conferences 21,150 13,635 22,300 28,750 6,450 6301 Legal Fees 15,745 11,570 14,500 13,500 (1,000) 6399 Professional Services/Other 32,500 39,080 44,060 40,000 (4,060) 6415 Computer Software Support 92,780 78,355 124,700 175,600 50,900 6423 Administrative Allocation 1,260,475 1,276,000 1,104,680 971,980 (132,700) 6430 Custodial Services 11,700 13,840 15,000 11,700 (3,300) 6493 Outside Services & Repairs 153,315 136,440 185,500 192,700 7,200 6518 Postage 136,610 144,735 170,000 160,000 (10,000) 6521 Messenger Service 460 525 950 900 (50) 6530 Office Supplies 12,660 11,385 17,000 15,800 (1,200) 6539 Printing, Binding & Duplicating 14,325 2,820 22,500 17,500 (5,000) 6551 Fuel and Oil 17,895 19,770 25,000 25,000 - 6554 Supplies/Custodial & Cleaning 3,995 3,280 4,170 4,000 (170) 6563 Supplies/Special 10,825 11,355 12,500 13,950 1,450 6564 Supplies/Medical-Dental 3,505 2,625 4,150 3,000 (1,150) 6566 Small Tools 15 3,515 3,000 3,000 - 6569 Small Equipment 1,280 3,335 5,000 5,000 - 6570 Computer Peripherals/Misc 1,995 45 500 500 - 6572 Office Furniture & Equipment 1,225 8,020 7,200 7,000 (200) 6601 Advertising Expense 5,910 2,000 3,000 2,000 (1,000) 6615 Safety & Security Services Exp 10,460 10,065 13,370 5,000 (8,370) 6625 Program Expense 2,880 - - - - 6670 IT Allocation 500,000 504,065 562,780 746,950 184,170 6740 Claims Expense/Liability 358,260 394,085 394,085 529,270 135,185 6805 Maintenance/Land Improvements 12,205 11,580 14,790 13,790 (1,000) 6815 Maint & Repairs/Bldgs 19,410 16,745 26,600 29,600 3,000 6825 Maint & Repair / Vehicle 8,825 13,500 11,000 12,000 1,000 6827 Garage Allocation 665 1,310 2,000 2,000 - 6835 Maint & Repair/Equipment 33,775 39,125 51,700 48,755 (2,945) 337 BUDGET UNIT: ALL FUND 31 DIVISIONS-CONSUMER SERVICES (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 6840 Rent/Office Furniture & Equip 3,930 4,445 4,500 4,270 (230) 6904 Utilities/Other 8,280 11,670 10,000 13,620 3,620 6915 Utilities/Telephone 5,795 9,230 11,100 11,650 550 7009 Bank Service Charges 1,915 205 500 500 - 7050 Donations/Contribution 54,700 54,745 59,905 57,500 (2,405) 7075 Fee Collection Expense 295 590 1,000 1,000 - 7080 Refund 65 - - - - OPERATIONS SUBTOTAL 2,835,535 2,868,250 2,967,390 3,186,935 219,545 TRANSFERS OUT 5950 Transfers Out 179,840 244,310 274,260 467,595 193,335 TRANSFERS OUT SUBTOTAL 179,840 244,310 274,260 467,595 193,335 CONSUMER SERVICE FUND TOTAL: 5,929,990 6,066,900 6,330,400 6,802,720 472,320 338 THIS PAGE INTENTIONALLY LEFT BLANK 339 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 OPERATIONS Utility Board 6235 Meetings & Conferences 6,690 2,475 7,100 7,100 - 6301 Legal Fees 9,820 9,220 10,000 10,000 - 6521 Messenger Service 235 205 350 300 (50) 6670 IT Allocation 8,345 3,300 18,000 18,000 - Subtotal 25,090 15,200 35,450 35,400 (50) Consumer Services - Administrative 6220 Training Schools 35 - 500 500 - 6230 Dues & Subscriptions 210 50 250 250 - 6235 Meetings & Conferences 12,590 8,905 11,000 16,450 5,450 6240 Mileage Reimbursement - 35 - - 6301 Legal Fees 440 - 1,500 1,500 - 6399 Professional Services/Other 32,500 39,080 44,060 40,000 (4,060) 6493 Outside Services & Repairs 1,015 110 970 800 (170) 6521 Messenger Service 135 85 250 250 - 6530 Office Supplies 2,755 1,645 4,000 3,800 (200) 6539 Printing, Binding & Duplicating 160 780 2,500 2,500 - 6563 Supplies/Special 3,330 2,810 2,250 2,250 - 6564 Supplies/Medical-Dental 1,995 695 2,150 1,000 (1,150) 6569 Small Equipment 1,280 - - - - 6570 Computer Peripherals/Misc 1,995 45 500 500 - 6572 Office Furniture & Equipment 1,225 1,210 2,200 2,000 (200) 6601 Advertising Expense 5,910 2,000 3,000 2,000 (1,000) 6915 Utilities/Telephone 1,780 1,865 2,000 2,650 650 7050 Donations/Contribution 54,700 54,745 59,905 57,500 (2,405) Subtotal 122,055 114,060 137,035 133,950 (3,085) 340 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 Utilities - Administration 6423 Administrative Allocation 1,260,475 1,276,000 1,104,680 971,980 (132,700) 6740 Claims Expense/Liability 358,260 394,085 394,085 529,270 135,185 Subtotal 1,618,735 1,670,085 1,498,765 1,501,250 2,485 General Plant - Maintenance 6430 Custodial Services 11,700 13,840 15,000 11,700 (3,300) 6493 Outside Services & Repairs 5,405 870 5,600 5,600 - 6554 Supplies/Custodial & Cleaning 3,995 3,280 4,170 4,000 (170) 6563 Supplies/Special 445 2,055 1,080 1,000 (80) 6564 Supplies/Medical - 510 - - - 6615 Safety & Security Services Exp 10,460 10,065 13,370 5,000 (8,370) 6805 Maintenance/Land Improvements 12,205 11,580 14,790 13,790 (1,000) 6815 Maint & Repairs/Bldgs 19,410 16,745 26,600 29,600 3,000 6835 Maint & Repair/Equipment 27,590 34,210 36,900 36,755 (145) 6840 Rent/Office Furniture & Equip 3,930 4,445 4,500 4,270 (230) 6904 Utilities/Other 8,280 11,670 10,000 13,620 3,620 Subtotal 103,420 109,270 132,010 125,335 (6,675) Field Services 6201 Uniforms & Laundry 4,500 4,460 5,000 5,000 - 6235 Meetings & Conferences - - 1,200 1,200 - 6493 Outside Services & Repairs 15,180 10,425 16,400 21,800 5,400 6521 Messenger Service 90 235 250 250 - 6539 Printing, Binding & Duplicating 725 - 1,000 1,000 - 6551 Fuel and Oil 17,895 19,770 25,000 25,000 - 6563 Supplies/Special 5,275 5,600 7,370 9,000 1,630 6566 Small Tools 15 3,515 3,000 3,000 - 6825 Maint & Repair / Vehicle 8,825 13,500 11,000 12,000 1,000 6827 Garage Allocation 665 1,310 2,000 2,000 - 6915 Utilities/Telephones 875 3,110 6,000 6,000 - Subtotal 54,045 61,925 78,220 86,250 8,030 341 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 Customer Records & Collections 6201 Uniforms & Laundry 9,810 8,630 10,000 10,000 - 6235 Meetings & Conferences - 15 - - - 6415 Computer Software Services 92,780 78,355 124,700 175,600 50,900 6493 Outside Services & Repairs 131,615 124,870 160,600 162,500 1,900 6518 Postage 136,610 144,735 170,000 160,000 (10,000) 6521 Messenger Service - - 100 100 - 6530 Office Supplies 9,905 9,740 13,000 12,000 (1,000) 6539 Printing, Binding & Duplicating 6,680 705 4,000 4,000 - 6563 Supplies/Special 1,665 850 1,630 1,500 (130) 6569 Small Equipment - 3,335 5,000 5,000 - 6572 Office Furniture & Equipment - 6,810 5,000 5,000 - 6625 Program Expense 2,880 - - - - 6670 IT Allocation 491,655 500,765 544,780 728,950 184,170 6835 Maint & Repair/Equipment 6,185 4,915 14,800 12,000 (2,800) 6915 Utilities/Telephone 3,140 4,255 3,100 3,000 (100) 7009 Bank Service Charges 1,915 205 500 500 - 7075 Fee Collection Expense 295 590 1,000 1,000 - 7080 Refund 65 - - - - Subtotal 895,200 888,775 1,058,210 1,281,150 222,940 Employee Related 6210 Employee Awards - - 300 300 - 6220 Training Schools 920 1,130 2,000 3,000 1,000 6230 Dues & Subscriptions 235 245 300 100 (200) 6235 Meetings & Conferences 1,870 2,240 3,000 4,000 1,000 6240 Mileage Reimbursement - 10 - - - 6301 Legal Fees 5,485 2,350 3,000 2,000 (1,000) 342 BUDGET UNIT: ALL FUND 31 DIVISIONS - CONSUMER SERVICES (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 6493 Outside Services & Repairs 100 165 1,930 2,000 70 6539 Printing, Binding & Duplicating 6,760 1,335 15,000 10,000 (5,000) 6563 Supplies/Special 110 40 170 200 30 6564 Supplies/Medical-Dental 1,510 1,420 2,000 2,000 - Subtotal 16,990 8,935 27,700 23,600 (4,100) OPERATIONS SUBTOTAL 2,835,535 2,868,250 2,967,390 3,186,935 219,545 TRANSFERS OUT Promotion/Membership 5950 Transfers Out 77,695 75,775 156,980 158,170 1,190 Subtotal 77,695 75,775 156,980 158,170 1,190 Customer Care & Solutions - Administration 5950 Transfers Out 79,590 106,160 94,660 94,660 - Subtotal 79,590 106,160 94,660 94,660 - Utilities - Administration 5950 Transfers Out - 39,755 - - - Subtotal - 39,755 - - - Customer Records and Collections 5950 Transfers Out 7,555 7,620 7,620 7,805 185 Subtotal 7,555 7,620 7,620 7,805 185 Employee Related Expenses 5950 Transfers Out 15,000 15,000 15,000 206,960 191,960 Subtotal 15,000 15,000 15,000 206,960 191,960 TRANSFERS OUT SUBTOTAL 179,840 244,310 274,260 467,595 193,335 CONSUMER SERVICE FUND TOTAL: 5,929,990 6,066,900 6,330,400 6,802,720 472,320 343 THIS PAGE INTENTIONALLY LEFT BLANK 344 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 about 243 miles of water pipeline of various sizes, valves, and fire hydrants serving a population of approximately 108,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 Hsu-Canyon Water Treatment Plant is designed to ultimately produce 16 MGD and meet future water quality standards; currently the capacity of the WTP is 12 MGD. 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 12-13 PROGRAM HIGHLIGHTS: Operate the Water Treatment Plant (WTP) Upgrade in an efficient and cost effective manner. Continue to 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. 345 Budget Division: LIGHT AND WATER - WATER (ALL) FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Assistant Director-Water Operations 1.00 1.00 $128,810 $128,810 Water System Engineer 1.00 1.00 85,030 85,030 Associate Engineer 1.00 1.00 84,865 80,060 Office Specialist II 1.00 1.00 42,050 37,625 Business Dev/Pub Benefit Prog Coord(a)0.30 0.00 26,385 0 Water Production Supervisor 1.00 1.00 99,230 100,455 Water Production Operator III 4.00 4.00 281,065 291,120 Water Production Operator II 2.00 2.00 121,135 119,555 Water System Administrator 1.00 1.00 63,915 63,915 Water Distribution Supervisor 1.00 1.00 98,330 99,555 Water Distribution Crew Supervisor 2.00 2.00 164,180 166,190 Water Distribution Services Specialist 1.00 1.00 73,235 74,130 Water Distribution Equipment Operator 2.00 2.00 135,860 137,570 Water Distribution Worker III 2.00 2.00 130,380 138,260 Water Distribution Worker II 1.00 2.00 60,700 118,695 Water Distribution Worker I 4.00 3.00 210,805 155,385 Welder/Water Dist Worker I 2.00 2.00 133,225 138,145 (a) .70 FTE Public Benefits TOTAL 27.30 27.00 $1,939,200 $1,934,500 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 346 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 PERSONNEL 6003 Salaries/Regular 1,540,075 1,524,430 1,939,200 1,934,500 (4,700) 6012 Salaries/Comp-Time 27,360 43,200 - - - 6015 Salaries/Vacation 99,630 83,640 - - - 6024 Salaries/Sick Leave 69,965 72,835 - - - 6027 Salaries/Bereavement 3,775 2,385 - - - 6030 Overtime Pay/Regular 14,110 8,670 17,000 17,000 - 6033 Overtime Pay/Premium 100,880 80,675 110,000 110,000 - 6039 Standby Pay/Premium 63,180 64,230 75,000 75,000 - 6045 Salaries/Education Incentive 11,790 11,370 9,390 8,950 (440) 6047 Salaries/Bonuses 52,585 - - - - 6048 Salaries/Language Pay 8,425 9,780 8,400 8,400 - 6063 Salaries/Jury Duty 4,420 3,050 - - - 6072 Salaries/Injury 29,610 565 - - - 6091 Leave Liability Adjustments 29,480 (36,495) - - - 6101 PERS/Employee Contribution 126,915 126,135 137,975 137,415 (560) 6105 PERS/Employer Contribution 211,965 209,105 248,815 255,955 7,140 6109 PARS/Employer Contribution 42,660 43,845 46,440 45,595 (845) 6125 FICA/Employer Contrib/Med 32,370 31,375 33,950 36,545 2,595 6133 Retiree Health Premium Reimb 8,265 11,050 9,070 13,805 4,735 6140 Life Insurance Allocation 4,790 4,660 5,210 5,190 (20) 6155 Workers' Comp Allocation 78,515 73,895 78,380 86,155 7,775 6160 LTD Insurance Allocation 13,465 13,070 15,105 15,050 (55) 6165 Unemployment Allocation 2,120 2,085 2,435 2,615 180 6175 Benefits/Flex Plan 404,650 412,315 472,800 457,625 (15,175) 6180 Deferred Comp/Employer Paid 3,420 3,285 3,960 3,420 (540) PERSONNEL SUBTOTAL 2,984,420 2,799,155 3,213,130 3,213,220 90 347 Budget Division: LIGHT AND WATER - WATER-CITY FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Assistant Director-Water Operations 1.00 1.00 $128,810 $128,810 Water System Engineer 1.00 1.00 85,030 85,030 Associate Engineer 1.00 1.00 84,865 80,060 Office Specialist II 1.00 1.00 42,050 37,625 Business Dev/Pub Benefit Prog Coord (a)0.30 0.00 26,385 0 (a) .70 FTE Public Benefits TOTAL 4.30 4.00 $367,140 $331,525 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 348 Budget Division: LIGHT AND WATER - WATER SOURCE OF SUPPLY FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Water Production Supervisor 1.00 1.00 $99,230 $100,455 Water Production Operator III 4.00 4.00 281,065 291,120 Water Production Operator II 2.00 2.00 121,135 119,555 Water System Administrator 1.00 1.00 63,915 63,915 TOTAL 8.00 8.00 $565,345 $575,045 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 349 Budget Division: LIGHT AND WATER - WATER TRANSMISSION & DISTRIBUTION FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Water Distribution Supervisor 1.00 1.00 $98,330 $99,555 Water Distribution Crew Supervisor 2.00 2.00 164,180 166,190 Water Distribution Services Specialist 1.00 1.00 73,235 74,130 Water Distribution Equipment Operator 2.00 2.00 135,860 137,570 Water Distribution Worker III 2.00 2.00 130,380 138,260 Water Distribution Worker II 1.00 2.00 60,700 118,695 Water Distribution Worker I 4.00 3.00 210,805 155,385 Welder/Water Dist Worker I 2.00 2.00 133,225 138,145 TOTAL 15.00 15.00 $1,006,715 $1,027,930 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 350 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 PERSONNEL City Water 6003 Salaries/Regular 264,500 242,245 367,140 331,525 (35,615) 6012 Salaries/Comp-Time 160 235 - - - 6015 Salaries/Vacation 19,260 9,175 - - - 6024 Salaries/Sick Leave 2,840 6,185 - - - 6045 Salaries/Education Incentive 1,855 1,895 1,890 1,450 (440) 6063 Salaries/Jury Duty 445 - - - - 6091 Leave Liability Adjustments 29,480 (36,495) - - - 6101 PERS/Employee Contribution 20,315 19,640 26,140 23,425 (2,715) 6105 PERS/Employer Contribution 33,940 32,560 47,145 43,645 (3,500) 6109 PARS/Employer Contribution 9,845 11,495 9,795 8,255 (1,540) 6125 FICA/Employer Contrib/Med 4,825 4,625 6,370 5,725 (645) 6133 Retiree Health Premium Reimb 8,265 11,050 9,070 13,805 4,735 6140 Life Insurance Allocation 770 695 985 885 (100) 6155 Workers' Comp Allocation 11,560 10,440 14,855 13,320 (1,535) 6160 LTD Insurance Allocation 2,210 1,975 2,875 2,580 (295) 6165 Unemployment Allocation 295 285 440 395 (45) 6175 Benefits/Flex Plan 47,445 46,045 68,070 61,775 (6,295) 6180 Deferred Comp/Employer Paid 3,420 3,285 3,960 3,420 (540) Subtotal 461,430 365,335 558,735 510,205 (48,530) Production - Source of Supply 6003 Salaries/Regular 506,635 464,235 565,345 575,045 9,700 6012 Salaries/Comp-Time 2,070 11,725 - - - 6015 Salaries/Vacation 26,230 22,545 - - - 6024 Salaries/Sick Leave 12,010 13,960 - - - 6030 Overtime Pay/Regular 10,940 6,315 13,000 13,000 - 6033 Overtime Pay/Premium 26,965 21,300 31,430 31,430 - 6039 Standby Pay/Premium 34,720 34,825 40,000 40,000 - 6045 Salaries/Education Incentive 5,695 4,465 3,600 3,900 300 6047 Salaries/Bonuses 19,405 - - - - 6048 Salaries/Language Pay 3,600 4,580 3,600 3,600 - 6063 Salaries/Jury Duty 1,090 180 - - - 351 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 6072 Salaries/Injury 23,785 565 - - - 6101 PERS/Employee Contribution 41,440 38,105 40,320 41,010 690 6105 PERS/Employer Contribution 69,215 63,120 72,720 76,390 3,670 6109 PARS/Employer Contribution 11,895 10,390 13,895 14,105 210 6125 FICA/Employer Contrib/Med 11,255 10,420 10,340 11,665 1,325 6140 Life Insurance Allocation 1,560 1,385 1,520 1,550 30 6155 Workers' Comp Allocation 26,170 22,500 22,910 26,675 3,765 6160 LTD Insurance Allocation 4,345 3,890 4,400 4,475 75 6165 Unemployment Allocation 690 665 715 805 90 6175 Benefits/Flex Plan 125,095 116,355 140,375 137,550 (2,825) Subtotal 964,810 851,525 964,170 981,200 17,030 Transmission/Distribution 6003 Salaries/Regular 768,940 817,950 1,006,715 1,027,930 21,215 6012 Salaries/Comp-Time 25,130 31,240 - - - 6015 Salaries/Vacation 54,140 51,920 - - - 6024 Salaries/Sick Leave 55,115 52,690 - - - 6027 Salaries/Bereavement 3,775 2,385 - - - 6030 Overtime Pay/Regular 3,170 2,355 4,000 4,000 - 6033 Overtime Pay/Premium 73,915 59,375 78,570 78,570 - 6039 Standby Pay/Premium 28,460 29,405 35,000 35,000 - 6045 Salaries/Education Incentive 4,240 5,010 3,900 3,600 (300) 6047 Salaries/Bonuses 33,180 - - - - 6048 Salaries/Language Pay 4,825 5,200 4,800 4,800 - 6063 Salaries/Jury Duty 2,885 2,870 - - - 6072 Salaries/Injury 5,825 - - - - 6101 PERS/Employee Contribution 65,160 68,390 71,515 72,980 1,465 6105 PERS/Employer Contribution 108,810 113,425 128,950 135,920 6,970 6109 PARS/Employer Contribution 20,920 21,960 22,750 23,235 485 6125 FICA/Employer Contrib/Med 16,290 16,330 17,240 19,155 1,915 6140 Life Insurance Allocation 2,460 2,580 2,705 2,755 50 6155 Workers' Comp Allocation 40,785 40,955 40,615 46,160 5,545 352 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 6160 LTD Insurance Allocation 6,910 7,205 7,830 7,995 165 6165 Unemployment Allocation 1,135 1,135 1,280 1,415 135 6175 Benefits/Flex Plan 232,110 249,915 264,355 258,300 (6,055) Subtotal 1,558,180 1,582,295 1,690,225 1,721,815 31,590 PERSONNEL SUBTOTAL 2,984,420 2,799,155 3,213,130 3,213,220 90 353 Cost 3240721xxx, 3240722xxx, 3240723xxx, 6220 $7,500 6230 $35,950 6231 $200,000 6235 $1,750 6493 $686,320 6554 $2,500 6563 $2,157,750 6625 $145,500 7001 $2,991,490 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, chemicals and other supplies to treat water. These costs are difficult to forecast and may change depending on a number of variables. 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 Master 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. Custodial supplies 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 354 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 OPERATIONS 6201 Uniforms & Laundry 13,920 14,920 15,000 30,000 15,000 6215 Tuition Reimbursement - - 1,000 1,000 - 6220 Training Schools 5,580 3,075 7,500 7,500 - 6221 POST Training 400 - - - - 6230 Dues & Subscriptions 55,530 25,685 56,000 35,950 (20,050) 6231 Outside Assessments 116,265 155,660 200,000 200,000 - 6235 Meetings & Conferences 230 245 1,750 1,750 - 6253 Licenses/Certifications 2,800 2,105 7,500 7,700 200 6301 Legal Fees 145,745 201,840 35,970 35,970 - 6320 Fiscal Agent Fees 4,000 1,500 3,000 3,000 - 6340 Special Studies - 18,000 - 2,000 2,000 6345 Program Consultants 675 - 10,000 10,000 - 6399 Professional Services 20,895 - 24,750 24,750 - 6424 Consumer Services Allocation 4,010,620 4,028,245 4,059,175 4,256,980 197,805 6430 Custodial Services 5,280 5,765 7,500 7,500 - 6490 Mortgage Service Fee (700) - - - - 6493 Outside Services & Repairs 584,250 607,950 590,000 686,320 96,320 6518 Postage 50 3,950 2,500 2,500 - 6521 Messenger Service 320 665 1,500 1,500 - 6527 Supplies/Computer - 1,625 5,000 3,750 (1,250) 6530 Office Supplies 4,885 3,985 6,000 6,210 210 6539 Printing, Binding & Duplicating 585 7,240 35,000 11,500 (23,500) 6551 Fuel and Oil 44,300 52,570 48,500 48,500 - 6554 Supplies/Custodial 1,590 980 3,500 3,000 (500) 6560 Repair Parts 785 66,180 41,500 35,120 (6,380) 6563 Supplies/Special 1,846,460 1,756,665 2,153,500 2,157,750 4,250 6564 Supplies/Medical-Dental 3,505 2,890 3,000 2,500 (500) 6566 Small Tools 3,720 3,455 8,500 8,750 250 6569 Small Equipment 53,685 123,015 89,000 109,830 20,830 6572 Office Furniture & Equipment 1,525 - 2,250 1,500 (750) 6599 Materials and Supplies/Other 55 - - - - 6601 Advertising Expense 1,300 - 3,500 1,500 (2,000) 6605 Filing Costs 32,175 4,825 13,500 15,150 1,650 355 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 6610 Bond Administration 2,500 2,500 2,500 2,500 - 6625 Program Expense 157,360 112,080 145,500 145,500 - 6801 Rent/Land 2,610 7,830 1,500 6,000 4,500 6805 Maintenance/Land Improvements 18,890 22,120 25,000 23,340 (1,660) 6815 Maint & Repairs/Bldgs 8,375 42,920 25,000 24,940 (60) 6825 Maintenance Repair Vehicle 42,855 30,815 42,250 41,750 (500) 6827 Garage Allocation 1,365 875 900 3,000 2,100 6830 Rent/Equipment 1,815 180 7,100 6,600 (500) 6835 Maint & Repair/Equipment 5,075 6,830 27,000 36,250 9,250 6850 Lease Payments 2,610 - - - - 6904 Utilities/Other 817,360 869,315 1,000,000 1,000,000 - 6905 Utilities/Electricity 51,420 32,855 75,000 50,000 (25,000) 6910 Utilities/Natural Gas 825 795 5,500 5,500 - 6915 Utilities/Telephone 14,625 15,005 13,500 13,500 - 7001 Interest Expense 3,320,895 3,277,695 3,325,670 2,991,490 (334,180) 7010 Franchise Fee (2%) 316,100 341,035 338,470 340,215 1,745 7013 Water Rights Lease Expense 1,326,110 1,392,410 1,424,440 1,454,355 29,915 7015 Tax/Property 3,645 2,390 4,000 4,000 - 7055 Uncollectible Accounts 69,360 57,505 45,000 25,000 (20,000) 7080 Refunds 3,050 3,115 - - - OPERATIONS SUBTOTAL 13,127,275 13,311,305 13,944,225 13,893,420 (50,805) TRANSFERS OUT 5950 Transfer Out 918,440 513,030 200,000 200,000 - TRANSFERS OUT SUBTOTAL 918,440 513,030 200,000 200,000 - WATER FUND TOTAL: 17,030,135 16,623,490 17,357,355 17,306,640 (50,715) 356 THIS PAGE INTENTIONALLY LEFT BLANK 357 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 OPERATIONS City Water 6815 Maintenance & Repair/Building 770 11,920 - - - 7080 Refund - 3,115 - - - Subtotal 770 15,035 - - - Taxes 6815 Maintenance and Repairs/Buildings - - 8,960 8,960 - 7010 Franchise Fee (2%) 316,100 341,035 338,470 340,215 1,745 7015 Tax/Property 3,645 2,390 4,000 4,000 - Subtotal 319,745 343,425 351,430 353,175 1,745 Interest Expense 7001 Interest Expense 3,320,895 3,277,695 3,325,670 2,991,490 (334,180) Subtotal 3,320,895 3,277,695 3,325,670 2,991,490 (334,180) Source of Supply 6610 Bond Administration 2,500 - - - - Subtotal 2,500 - - - - Administrative & General 6320 Fiscal Agent Fees 4,000 1,500 3,000 3,000 - 6399 Professional Services/Other - - 24,750 24,750 6424 Consumer Services Allocation 4,010,620 4,028,245 4,059,175 4,256,980 197,805 6601 Advertising Expense - - 1,500 1,500 - 6610 Bond Administration - 2,500 2,500 2,500 - Subtotal 4,014,620 4,032,245 4,090,925 4,288,730 197,805 Miscellaneous 6220 Training Schools - 600 2,500 2,500 - 6230 Dues & Subscriptions 4,930 4,555 5,390 5,500 110 6235 Meetings & Conferences 105 245 1,500 1,500 - 6253 Licenses/Certifications 65 30 - 200 200 358 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 6539 Printing, Binding & Duplicating - 1,860 24,500 1,000 (23,500) 6625 Program Expense 157,360 112,080 145,500 145,500 - 6825 Maintenance and Repair/Vehicle 465 - - - - 7055 Uncollectible Accounts 69,360 57,505 45,000 25,000 (20,000) 7080 Refund 3,050 - - - - Subtotal 235,335 176,875 224,390 181,200 (43,190) Office Supplies & Other Expenses 6527 Supplies/Computer/Small Equip - 1,000 1,500 1,500 - 6530 Office Supplies 360 - 570 570 - 6563 Supplies/Special 10 - 1,000 500 (500) 6569 Small Equipment - - 540 500 (40) 6601 Advertising Expense 1,300 - 2,000 - (2,000) 6825 Maintenance & Repair/Vehicle - - 750 750 - 6830 Rent/Equipment - - 100 100 - 6915 Utilities/Telephone 975 1,015 1,000 1,000 - Subtotal 2,645 2,015 7,460 4,920 (2,540) Employee Related 6201 Uniforms & Laundry 13,920 14,860 15,000 30,000 15,000 6215 Tuition Reimbursement - - 1,000 1,000 - 6220 Training Schools 5,580 2,475 5,000 5,000 - 6230 Dues & Subscriptions 250 - 260 450 190 6235 Meetings & Conferences 75 - - - - 6253 Licenses/Certifications 2,735 2,075 7,500 7,500 - 6301 Legal Fees - - 5,000 5,000 - 6345 Program Consultants 500 - 5,000 5,000 - 6539 Printing, Binding & Duplication - 80 - - - 6563 Supplies/Special - - 1,000 1,000 - 6564 Supplies/Medical-Dental 3,505 2,890 3,000 2,500 (500) 6825 Maintenance & Repair/Vehicle 10 65 1,500 1,000 (500) Subtotal 26,575 22,445 44,260 58,450 14,190 359 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 Regulatory Commission 6221 POST Training 400 - - - - 6493 Outside Services & Repairs 520 - 2,370 - (2,370) 6551 Fuel and Oil 2,855 3,265 3,500 3,500 - 6605 Filing Costs 20 75 500 150 (350) Subtotal 3,795 3,340 6,370 3,650 (2,720) Outside Services 6301 Legal Fees 5,615 695 25,000 25,000 - 6340 Special Studies - 18,000 - 2,000 2,000 6345 Program Consultants 175 - 5,000 5,000 - 6493 Outside Services & Repairs 95 2,975 9,860 8,500 (1,360) Subtotal 5,885 21,670 39,860 40,500 640 Transportation 6201 Uniforms & Laundry - 60 - - - 6493 Outside Services & Repairs 540 - 1,970 1,000 (970) 6551 Fuel and Oil 41,445 49,305 45,000 45,000 - 6560 Repair Parts 35 1,220 1,340 1,340 - 6563 Supplies/Special 270 355 1,500 1,500 - 6569 Small Equipment 365 - 2,170 2,000 (170) 6825 Maintenance & Repair/Vehicle 42,380 30,750 40,000 40,000 - 6827 Garage Allocation 1,365 875 900 3,000 2,100 6835 Maint & Repair/Equipment 495 235 3,750 3,500 (250) Subtotal 86,895 82,800 96,630 97,340 710 Production - Supervision & Engineering 6235 Meetings & Conferences 50 - 250 250 - 6490 Mortgage Service Fee (700) - - - - 6493 Outside Services & Repairs 39,550 25,500 27,610 27,610 - 6518 Postage 50 3,950 2,500 2,500 - 6521 Messenger Service 80 240 1,250 1,250 - 6527 Supplies/Computer/Small Equip - - 2,000 1,000 (1,000) 6530 Office Supplies 1,185 240 1,630 1,500 (130) 6539 Printing, Binding & Duplicating 45 5,150 10,000 10,000 - 360 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 6554 Supplies/Custodial & Cleaning 205 135 670 500 (170) 6563 Supplies/Special 210 55 2,000 2,000 - 6569 Small Equipment - 3,350 5,580 2,500 (3,080) 6572 Office Furniture & Equipment 535 - 1,500 1,000 (500) 6830 Rent/Equipment 1,815 180 4,000 4,000 - 6835 Maintenance and Repair/Equipment 30 15 250 250 - 6915 Utilities/Telephone 8,525 9,295 7,500 7,500 - Subtotal 51,580 48,110 66,740 61,860 (4,880) Purchased Water 6230 Dues & Subscriptions 50,350 21,130 50,350 30,000 (20,350) 6231 Outside Assessments 116,265 155,660 200,000 200,000 - 6493 Outside Services & Repairs 60,770 69,520 39,440 45,000 5,560 6563 Supplies/Special 1,269,525 1,196,440 1,400,000 1,400,000 - 7013 Water Rights Lease Expense 1,326,110 1,392,410 1,424,440 1,454,355 29,915 Subtotal 2,823,020 2,835,160 3,114,230 3,129,355 15,125 Maintenance of Structures & Improvements 6430 Custodial Services - 250 - - - 6493 Outside Services & Repairs 3,300 2,340 3,950 4,500 550 6554 Supplies/Custodial - - 670 500 (170) 6563 Supplies/Special 155 - 1,000 1,000 - 6569 Small Equipment - - 540 500 (40) 6805 Maintenance/Land Improvements 16,660 20,170 10,840 10,840 - 6815 Maint & Repairs/Bldgs - - 750 750 - Subtotal 20,115 22,760 17,750 18,090 340 Maintenance of Reservoirs 6493 Outside Services & Repairs 7,655 17,340 17,750 17,750 - 6563 Supplies/Special - 450 10,000 10,000 - Subtotal 7,655 17,790 27,750 27,750 - 361 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 Maintenance of Wells 6493 Outside Services & Repairs 113,200 29,945 126,210 125,000 (1,210) 6563 Supplies/Special 2,090 2,400 17,500 15,000 (2,500) 6569 Small Equipment 15,555 23,845 37,470 35,000 (2,470) Subtotal 130,845 56,190 181,180 175,000 (6,180) Fuel or Power Purchase 6904 Utilities/Other 817,360 869,315 1,000,000 1,000,000 - 6905 Utilities/Electricity 51,420 32,855 75,000 50,000 (25,000) 6910 Utilities/Natural Gas 825 795 5,500 5,500 - Subtotal 869,605 902,965 1,080,500 1,055,500 (25,000) Maintenance of Pumps/Boosters 6493 Outside Services & Repairs 42,270 32,305 55,220 55,220 - 6560 Repair Parts - - 280 280 - 6563 Supplies/Special 1,675 420 5,000 4,000 (1,000) Subtotal 43,945 32,725 60,500 59,500 (1,000) Chemicals & Filtering Materials 6493 Outside Services & Repairs 5,365 2,805 7,890 5,000 (2,890) 6563 Supplies/Special 274,005 320,290 400,000 400,000 - Subtotal 279,370 323,095 407,890 405,000 (2,890) Maintenance of Structure & Improvements (Filter Plant) 6430 Custodial Services 3,410 3,000 3,750 3,750 - 6493 Outside Services & Repairs 9,560 38,185 23,670 23,670 - 6530 Office Supplies 325 410 580 500 (80) 6554 Supplies/Custodial 985 510 1,160 1,000 (160) 6563 Supplies/Special 5,255 2,910 7,500 7,000 (500) 6815 Maint & Repairs/Bldgs 1,630 795 1,860 1,860 - Subtotal 21,165 45,810 38,520 37,780 (740) 362 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 Maintenance of Water Treatment Equipment 6493 Outside Services & Repairs 24,095 46,880 43,390 43,390 - 6563 Supplies/Special 8,335 16,725 20,000 20,000 - 6569 Small Equipment 6,310 5,170 8,150 10,000 1,850 Subtotal 38,740 68,775 71,540 73,390 1,850 Supervision & Engineering 6521 Messenger Service 240 425 250 250 - 6527 Supplies/Computer - 625 1,500 1,250 (250) 6530 Office Supplies 2,415 2,785 2,330 2,750 420 6539 Printing, Binding & Duplicating 540 150 500 500 - 6563 Supplies/Special - 95 1,000 500 (500) 6572 Office Furniture & Equipment 990 - 750 500 (250) 6815 Maint & Repairs/Bldgs - 15 370 370 - 6830 Rent/Equipment - - 1,500 1,250 (250) 6915 Utilities/Telephone 5,000 4,695 5,000 5,000 - Subtotal 9,185 8,790 13,200 12,370 (830) Storage Facilities 6563 Supplies/Special - - 2,500 2,000 (500) 6830 Rent/Equipment - - 1,500 1,250 (250) Subtotal - - 4,000 3,250 (750) Transmission & Distribution 6493 Outside Services & Repairs - - 790 500 (290) 6563 Supplies/Special 45 160 5,000 5,000 - Subtotal 45 160 5,790 5,500 (290) Meter 6493 Outside Services & Repairs - 4,640 - - - 6563 Supplies/Special 232,730 139,900 100,000 75,000 (25,000) 6569 Small Equipment 30,460 84,945 30,560 55,000 24,440 Subtotal 263,190 229,485 130,560 130,000 (560) 363 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 Customer Installation 6493 Outside Services & Repairs 4,950 - 1,180 1,180 - 6560 Repair Parts - 270 800 800 - 6563 Supplies/Special - - 1,500 1,500 - Subtotal 4,950 270 3,480 3,480 - Maintenance of Structures & Improvements 6430 Custodial Services 1,870 2,515 3,750 3,750 - 6493 Outside Services & Repairs - 2,105 8,680 8,000 (680) 6530 Office Supplies 600 550 890 890 - 6554 Supplies/Custodial 400 335 1,000 1,000 - 6563 Supplies/Special 3,025 1,935 3,000 2,500 (500) 6805 Maintenance/Land Improvements 2,230 1,950 14,160 12,500 (1,660) 6815 Maint & Repairs/Bldgs 5,975 30,190 13,060 13,000 (60) 6915 Utilities/Telephone 125 - - - - Subtotal 14,225 39,580 44,540 41,640 (2,900) Maintenance of Transmission & Distribution Mains 6493 Outside Services & Repairs 262,425 316,450 196,360 300,000 103,640 6560 Repair Parts 345 58,915 31,330 25,000 (6,330) 6563 Supplies/Special 41,465 53,610 140,000 175,000 35,000 6566 Small Tools 2,705 2,860 4,500 4,500 - 6569 Small Equipment 670 5,705 2,660 3,000 340 6599 Materials and Supplies/Other 55 - - - - 6605 Filing Costs 32,155 4,750 13,000 15,000 2,000 6801 Rent/Land 2,610 7,830 1,500 6,000 4,500 6835 Maint & Repair/Equipment 3,595 6,565 20,000 15,000 (5,000) 6850 Lease Payments 2,610 - - - - Subtotal 348,635 456,685 409,350 543,500 134,150 364 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 Maintenance of Services 6560 Repair Parts 305 275 1,330 1,500 170 6563 Supplies/Special 5,650 7,015 15,000 17,500 2,500 6566 Small Tools 675 595 1,000 1,750 750 6835 Maint & Repair/Equipment 195 15 500 15,000 14,500 Subtotal 6,825 7,900 17,830 35,750 17,920 Maintenance of Meters 6493 Outside Services & Repairs 9,955 16,960 23,660 20,000 (3,660) 6560 Repair Parts - 2,860 3,200 3,200 - 6563 Supplies/Special - 10 1,500 1,750 250 6566 Small Tools - - 500 500 - Subtotal 9,955 19,830 28,860 25,450 (3,410) Maintenance of Hydrants 6560 Repair Parts 20 2,635 2,680 2,500 (180) 6563 Supplies/Special 410 7,415 7,500 5,000 (2,500) Subtotal 430 10,050 10,180 7,500 (2,680) Maintenance of Miscellaneous Plants 6560 Repair Parts 80 5 540 500 (40) 6563 Supplies/Special 1,605 6,480 10,000 10,000 - 6566 Small Tools 340 - 2,500 2,000 (500) 6569 Small Equipment 325 - 1,330 1,330 - 6835 Maint & Repair/Equipment 760 - 2,500 2,500 - Subtotal 3,110 6,485 16,870 16,330 (540) CIP/Water 6301 Legal Fees 140,130 201,145 5,970 5,970 - 6399 Professional Services/Other 20,895 - - - - Subtotal 161,025 201,145 5,970 5,970 - OPERATIONS SUBTOTAL 13,127,275 13,311,305 13,944,225 13,893,420 (50,805) 365 BUDGET UNIT: ALL FUND 32 DIVISIONS - WATER (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. # 09-10 10-11 11-12 12-13 TRANSFERS OUT General 5950 Transfer Out 918,440 - 200,000 200,000 - Subtotal 918,440 - 200,000 200,000 - Administrative & General 5950 Transfer Out - 513,030 - - - Subtotal - 513,030 - - - TRANSFERS OUT SUBTOTAL 918,440 513,030 200,000 200,000 - WATER FUND TOTAL: 17,030,135 16,623,490 17,357,355 17,306,640 (50,715) 366 LIGHT & WATER ELECTRIC UTILITY PROGRAM COMMENTARY PROGRAM DESCRIPTION: Electric Utility consists of Power Resources Management, Engineering and Electric Operations. Power Resources Management is responsible for short-term, mid-term and long-term power resource planning and procurement; short term (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. 367 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 2013 with the installation of two additional wind turbines at Garnet Wind Project in Palm Springs. In FY 12-13, 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 12-13, Power Resources will continue to procure short term power and capacity as well as optimize power delivery from our long term resources. During FY 12-13, Engineering will upgrade the capability of the Supervisory Control and Data Acquisition (SCADA) system for Substation. As planned, SCADA will provide remote control and monitoring 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 new underground electric service line extensions within areas designated for new developments such as the Material Recovery Facility (MRF) along Gladstone Avenue & Irwindale Avenue including new commercial building at the northeast corner of Azusa & Arrow Highway. Engineering will continue support for the renewal of RP3 Designation and provide assistance in the areas of Electric System Improvements and Reliability Indices. Planning will also continue for electric infrastructure projects that will support the proposed Metro Gold Line Railway Extension to Azusa, including the construction of underground line extensions and improvements at various railroad crossings Electric Operations will continue General Order 165 Inspection & Maintenance Program and participate in the upcoming 2012 CPUC audit of Azusa’s electric system. 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 residential developments such as the 1,200 homes at Rosedale Subdivision, continue with replacement of some open wire secondary conductors in conjunction with upgrades of undersized overhead transformers As part of the RP3 Designation renewal, 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. 368 Budget Division: LIGHT AND WATER - ELECTRIC (ALL) FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Assistant Director-Electric Operations 1.00 1.00 $130,010 $130,010 Electric Distribution Supervisor 1.00 1.00 123,035 124,495 Electric Crew Supervisor 3.00 3.00 326,020 329,950 Line Mechanic 5.00 5.00 486,660 483,320 Line Mechanic Helper 1.00 1.00 66,880 67,730 Apprentice Line Mechanic 2.00 2.00 161,850 164,440 Senior Electric Test Technician 1.00 1.00 97,065 98,265 Electrical Test Technician 1.00 1.00 88,315 89,405 Apprentice Elec Test Technician 1.00 1.00 67,190 68,050 Senior Office Specialist 1.00 1.00 42,075 43,775 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,155,505 $2,165,845 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 369 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 PERSONNEL 6003 Salaries/Regular 1,617,140 1,774,095 2,155,505 2,165,845 10,340 6006 Salaries/Temp & Part-Time 19,120 - - - - 6012 Salaries/Comp-Time 27,250 57,350 - - - 6015 Salaries/Vacation 98,225 109,420 - - - 6024 Salaries/Sick Leave 57,580 65,955 - - - 6027 Salaries/Bereavement 4,770 7,365 - - - 6030 Overtime Pay/Regular 2,950 10,490 11,500 11,500 - 6033 Overtime Pay/Premium 136,165 73,090 167,000 167,000 - 6039 Standby Pay/Premium 38,750 30,585 50,000 50,000 - 6045 Salaries/Education Incentive 6,335 7,350 5,850 7,300 1,450 6047 Salaries/Bonuses 40,480 - - - - 6048 Salaries/Language Pay 6,005 6,025 6,000 6,000 - 6063 Salaries/Jury Duty 3,310 890 - - - 6101 PERS/Employee Contribution 131,560 140,290 152,675 153,495 820 6105 PERS/Employer Contribution 213,160 232,570 275,275 285,845 10,570 6109 PARS/Employer Contribution 55,920 67,660 70,355 70,545 190 6125 FICA/Employer Contrib/Med 29,910 30,465 33,160 36,495 3,335 6133 Retiree Health Premium Reimb 4,745 4,140 5,165 4,125 (1,040) 6140 Life Insurance Allocation 4,535 5,000 5,780 5,795 15 6155 Workers' Comp Allocation 79,370 82,290 86,690 96,300 9,610 6160 LTD Insurance Allocation 12,965 13,925 16,765 16,845 80 6165 Unemployment Allocation 2,170 2,070 2,545 2,775 230 6175 Benefits/Flex Plan 297,705 323,970 375,165 366,410 (8,755) 6180 Deferred Comp/Employer Paid 7,230 8,430 10,080 10,080 - PERSONNEL SUBTOTAL 2,897,350 3,053,425 3,429,510 3,456,355 26,845 370 Budget Division: LIGHT AND WATER - ELECTRIC DISTRIBUTIONS & OPERATIONS FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Assistant Director-Electric Operations 1.00 1.00 $130,010 $130,010 Electric Distribution Supervisor 1.00 1.00 123,035 124,495 Electric Crew Supervisor 3.00 3.00 326,020 329,950 Line Mechanic 5.00 5.00 486,660 483,320 Line Mechanic Helper 1.00 1.00 66,880 67,730 Apprentice Line Mechanic 2.00 2.00 161,850 164,440 Senior Electric Test Technician 1.00 1.00 97,065 98,265 Electrical Test Technician 1.00 1.00 88,315 89,405 Apprentice Elec Test Technician 1.00 1.00 67,190 68,050 Senior Office Specialist 1.00 1.00 42,075 43,775 TOTAL 17.00 17.00 $1,589,100 $1,599,440 TOTAL 0 0 $0 $0 Full Time Positions Part Time Positions 371 Budget Division: LIGHT AND WATER - ELECTRIC ENGINEERING FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary 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 372 Budget Division: LIGHT AND WATER - POWER PURCHASES FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 FY 11-12 FY 12-13 Revised Adopted Revised Adopted Revised Adopted Revised Adopted Position Title Allocation Allocation Salary Salary Position Title Allocation Allocation Salary Salary Assistant Director-Resource Management 1.00 1.00 $144,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 373 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 PERSONNEL Distribution Operations-Supervision & Engineering 6003 Salaries/Regular 142,760 227,835 253,045 254,505 1,460 6012 Salaries/Comp-Time 315 1,940 - - - 6015 Salaries/Vacation 12,460 13,885 - - - 6024 Salaries/Sick Leave 3,910 8,465 - - - 6030 Overtime Pay/Regular - - 1,000 1,000 - 6033 Overtime Pay/Premium 1,790 810 16,000 16,000 - 6039 Standby Pay/Premium 680 815 10,000 10,000 - 6045 Salaries/Education Incentive 540 1,760 1,750 1,750 - 6101 PERS/Employee Contribution 15,080 17,925 17,895 17,995 100 6105 PERS/Employer Contribution 18,510 29,705 32,305 33,560 1,255 6109 PARS/Employer Contribution 5,535 12,570 11,115 11,145 30 6125 FICA/Employer Contribution 340 2,125 2,135 2,520 385 6133 Retiree Health Premium Reimb 4,745 4,140 5,165 4,125 (1,040) 6140 Life Insurance Allocation 430 675 680 680 - 6155 Workers' Comp Allocation 6,705 10,195 10,190 11,330 1,140 6160 LTD Insurance Allocation 1,205 1,870 1,970 1,980 10 6165 Unemployment Allocation 270 255 290 315 25 6175 Benefits/Flex Plan 19,415 31,765 33,455 32,665 (790) 6180 Deferred Comp/Employer Paid 450 1,800 1,800 1,800 - Subtotal 235,140 368,535 398,795 401,370 2,575 Distribution Operations-Overhead Lines 6003 Salaries/Regular 425,885 461,670 520,705 522,720 2,015 6012 Salaries/Comp-Time 13,265 27,705 - - - 6015 Salaries/Vacation 19,955 28,115 - - - 6024 Salaries/Sick Leave 22,180 22,475 - - - 6027 Salaries/Bereavement 2,385 365 - - - 6030 Overtime Pay/Regular 1,475 5,025 5,000 5,000 - 6033 Overtime Pay/Premium 58,965 35,055 70,000 70,000 - 6039 Standby Pay/Premium 19,035 14,885 20,000 20,000 - 6045 Salaries/Education Incentive 600 605 600 600 - 6047 Salaries/Bonuses 16,740 - - - - 6048 Salaries/Language Pay 1,195 1,205 1,200 1,200 - 374 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 6063 Salaries/Jury Duty 1,185 180 - - - 6101 PERS/Employee Contribution 33,995 36,805 36,895 37,035 140 6105 PERS/Employer Contribution 56,815 61,020 66,455 68,895 2,440 6109 PARS/Employer Contribution 10,935 11,840 11,770 11,815 45 6125 FICA/Employer Contrib/Med 9,150 9,365 8,980 10,360 1,380 6140 Life Insurance Allocation 1,275 1,385 1,395 1,400 5 6155 Workers' Comp Allocation 21,860 22,190 20,900 24,780 3,880 6160 LTD Insurance Allocation 3,675 3,810 4,050 4,065 15 6165 Unemployment Allocation 590 610 620 715 95 6175 Benefits/Flex Plan 85,720 91,650 96,930 94,710 (2,220) Subtotal 806,880 835,960 865,500 873,295 7,795 Distribution Operations-Underground Lines 6003 Salaries/Regular 426,005 461,665 520,705 522,720 2,015 6012 Salaries/Comp-Time 13,265 27,705 - - - 6015 Salaries/Vacation 19,955 28,115 - - - 6024 Salaries/Sick Leave 22,180 22,475 - - - 6027 Salaries/Bereavement 2,385 365 - - - 6030 Overtime Pay/Regular 1,475 5,025 5,000 5,000 - 6033 Overtime Pay/Premium 62,790 35,055 70,000 70,000 - 6039 Standby Pay/Premium 19,035 14,885 20,000 20,000 - 6045 Salaries/Education Incentive 600 605 600 600 - 6047 Salaries/Bonuses 16,740 - - - - 6048 Salaries/Language Pay 1,195 1,205 1,200 1,200 - 6063 Salaries/Jury Duty 1,185 180 - - - 6101 PERS/Employee Contribution 34,005 36,805 36,895 37,035 140 6105 PERS/Employer Contribution 56,825 61,020 66,455 68,895 2,440 6109 PARS/Employer Contribution 10,940 11,840 11,770 11,815 45 6125 FICA/Employer Contrib/Med 9,205 9,365 8,980 10,360 1,380 6140 Life Insurance Allocation 1,280 1,385 1,395 1,400 5 375 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 6155 Workers' Comp Allocation 21,960 22,190 20,900 24,780 3,880 6160 LTD Insurance Allocation 3,680 3,805 4,050 4,065 15 6165 Unemployment Allocation 595 610 620 715 95 6175 Benefits/Flex Plan 85,760 91,650 96,930 94,710 (2,220) Subtotal 811,060 835,950 865,500 873,295 7,795 Distribution Operations-Meters 6003 Salaries/Regular 160,160 155,945 252,570 255,720 3,150 6012 Salaries/Comp-Time 405 - - - - 6015 Salaries/Vacation 15,910 20,130 - - - 6024 Salaries/Sick Leave 3,415 4,290 - - - 6027 Salaries/Bereavement - 1,610 - - - 6030 Overtime Pay/Regular - 440 500 500 - 6033 Overtime Pay/Premium 11,765 2,170 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,930 13,160 17,850 18,070 220 6105 PERS/Employer Contribution 21,600 21,815 32,205 33,675 1,470 6109 PARS/Employer Contribution 4,160 4,235 5,710 5,780 70 6125 FICA/Employer Contrib/Med 1,680 1,430 2,785 2,950 165 6140 Life Insurance Allocation 480 490 680 680 - 6155 Workers' Comp Allocation 7,815 7,445 10,150 10,695 545 6160 LTD Insurance Allocation 1,350 1,380 1,965 1,990 25 6165 Unemployment Allocation 210 190 305 320 15 6175 Benefits/Flex Plan 31,685 33,360 52,870 51,660 (1,210) Subtotal 281,770 269,295 388,790 393,240 4,450 Distribution Operations-Miscellaneous Distribution 6003 Salaries/Regular 35,305 35,660 42,075 43,775 1,700 6015 Salaries/Vacation 1,320 1,775 - - - 6024 Salaries/Sick Leave 1,825 2,045 - - - 6027 Salaries/Bereavement - 770 - - 6033 Overtime Pay/Premium - - 1,000 1,000 - 6101 PERS/Employee Contribution 2,715 2,840 2,975 3,095 120 6105 PERS/Employer Contribution 4,530 4,715 5,355 5,750 395 376 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 6125 FICA/Employer Contrib/Med 775 805 840 875 35 6140 Life Insurance Allocation 100 105 110 115 5 6155 Workers' Comp Allocation 1,540 1,610 1,685 1,790 105 6160 LTD Insurance Allocation 300 315 325 340 15 6165 Unemployment Allocation 55 55 60 60 - 6175 Benefits/Flex Plan 14,305 15,065 15,830 15,445 (385) 6180 Deferred Comp/Employer Paid 540 540 540 540 - Subtotal 63,310 66,300 70,795 72,785 1,990 Engineering 6003 Salaries/Regular 181,005 96,685 211,570 211,570 - 6015 Salaries/Vacation 19,355 7,395 - - - 6024 Salaries/Sick Leave 2,690 1,085 - - - 6045 Salaries/Education Incentive 2,680 1,460 1,450 1,450 - 6063 Salaries/Jury Duty 940 - - - - 6101 PERS/Employee Contribution 14,510 7,490 14,970 14,970 - 6105 PERS/Employer Contribution 24,260 12,415 27,020 27,905 885 6109 PARS/Employer Contribution 13,250 7,885 13,560 13,560 - 6125 FICA/Employer Contrib/Med 3,230 1,595 3,550 3,535 (15) 6140 Life Insurance Allocation 275 - 565 565 - 6155 Workers' Comp Allocation 8,265 4,265 8,520 8,520 - 6160 LTD Insurance Allocation 775 - 1,645 1,645 - 6165 Unemployment Allocation 100 - 245 245 - 6175 Benefits/Flex Plan 27,460 15,120 31,660 30,890 (770) 6180 Deferred Comp/Employer Paid 3,450 1,800 3,600 3,600 - Subtotal 302,245 157,195 318,355 318,455 100 Power Purchases-Other Expenses 6003 Salaries/Regular 246,020 334,635 354,835 354,835 - 6006 Salaries/Temp & Part Time 19,120 - - - - 6015 Salaries/Vacation 9,270 10,005 - - - 6024 Salaries/Sick Leave 1,380 5,120 - - - 6027 Salaries/Bereavement - 4,255 - - - 6033 Overtime Pay/Premium 855 - - - - 6045 Salaries/Education Incentive 1,915 2,920 1,450 2,900 1,450 377 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 6048 Salaries/Language Pay 2,410 2,410 2,400 2,400 - 6063 Salaries/Jury Duty - 530 - - - 6101 PERS/Employee Contribution 18,325 25,265 25,195 25,295 100 6105 PERS/Employer Contribution 30,620 41,880 45,480 47,165 1,685 6109 PARS/Employer Contribution 11,100 19,290 16,430 16,430 - 6125 FICA/Employer Contrib/Med 5,530 5,780 5,890 5,895 5 6140 Life Insurance Allocation 695 960 955 955 - 6155 Workers' Comp Allocation 11,225 14,395 14,345 14,405 60 6160 LTD Insurance Allocation 1,980 2,745 2,760 2,760 - 6165 Unemployment Allocation 350 350 405 405 - 6175 Benefits/Flex Plan 33,360 45,360 47,490 46,330 (1,160) 6180 Deferred Comp/Employer Paid 2,790 4,290 4,140 4,140 - Subtotal 396,945 520,190 521,775 523,915 2,140 PERSONNEL SUBTOTAL 2,897,350 3,053,425 3,429,510 3,456,355 26,843 378 Cost 6220 $22,260 6230 $22,500 6235 $15,000 6340 $45,000 6493 $3,993,370 6590 $28,579,410 6625 $300,000 7130 $110,000 7140 $275,000 7145 $335,000Lines, Mains & Sewers - Underground cable and overhead conductors and subfeeds to residential and commercial buildings. Dues & Subscriptions - California Municipal Utilities Association (CMUA), California Utilities Emergency Association (CUEA), Barclays Law Publications Subscription, Electric Safety Orders (Updates). ($10,000 Distribution). Outside Services - Cost for third party and California Independent System Operator (CAISO) transmission services; real time electric load scheduling/dispatching services ($3,694,788). Other services to support electric distribution system ($298,580). Electricity for Resale - Purchase of electricity for distribution and sale to retail customers. 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. Special Studies - Update of distribution planning model. 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. ($15,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. ($6,000 Distribution; $1,000 Engineering; $8,000 Power Resources). LIGHT & WATER - ELECTRIC ACTIVITY DETAIL Account Number Description 3340733xxx, 3340735xxx, 3340745xxx, 3340775xxx, 3340785xxx, 379 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 OPERATIONS 6201 Uniforms & Laundry 17,630 21,100 21,700 12,000 (9,700) 6220 Training Schools 25,950 29,265 16,260 22,260 6,000 6225 Training Materials 715 5 900 1,000 100 6230 Dues & Subscriptions 7,805 9,970 22,500 22,500 - 6235 Meetings & Conferences 3,325 12,045 10,000 15,000 5,000 6240 Mileage Reimbursement 160 40 - 200 200 6301 Legal Fees 52,370 79,990 102,400 152,500 50,100 6340 Special Studies - - 15,000 45,000 30,000 6345 Program Consultants 1,860 2,720 3,200 5,000 1,800 6399 Professional Services/Other 16,200 - 37,250 - (37,250) 6424 Consumer Services Allocation 2,159,565 2,169,055 2,185,710 2,380,950 195,240 6430 Custodial Services 4,260 4,055 3,800 4,620 820 6493 Outside Services & Repairs 3,128,880 3,578,890 3,750,000 3,993,370 243,370 6521 Messenger Service 415 350 1,100 1,100 - 6530 Office Supplies 3,985 4,020 4,140 4,340 200 6539 Printing, Binding & Duplicating 95 55 80 - (80) 6551 Fuel and Oil 21,910 24,160 20,800 20,800 - 6554 Supplies/Custodial & Cleaning 1,675 1,435 900 5,700 4,800 6563 Supplies/Special 19,235 19,505 29,800 31,800 2,000 6564 Supplies/Medical-Dental 1,400 2,175 2,200 2,500 300 6566 Small Tools 11,390 6,905 13,600 13,600 - 6569 Small Equipment 6,835 3,860 19,000 19,000 - 6590 Electricity For Resale 26,042,270 25,179,880 26,030,710 28,579,410 2,548,700 6601 Advertising Expense 700 - - 500 500 6610 Bond Administration 2,500 2,500 2,500 2,500 - 6625 Program Expenses 303,650 207,140 300,000 300,000 - 6645 Relocation Costs 4,935 - - - - 6815 Maint & Repairs/Bldgs 24,435 14,550 17,600 17,600 - 6825 Maint & Repair / Vehicle 40,035 53,740 41,000 41,000 - 6827 Garage Allocation 2,570 3,670 3,800 3,800 - 6830 Rent/Equipment 75 - 150 150 - 6835 Maint & Repair/Equipment 1,890 180 1,200 6,200 5,000 6904 Utilities/Other 16,250 15,735 15,000 15,000 - 6905 Utilities / Electricity 8,290 10,895 10,200 11,000 800 380 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (SUMMARY) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 6910 Utilities/Natural Gas 750 840 700 700 - 6915 Utilities/Telephone 11,285 11,245 8,265 8,400 135 7001 Interest Expense 511,390 482,415 443,160 416,400 (26,760) 7010 Franchise Fee (2%) 612,925 667,850 680,050 686,490 6,440 7012 In-lieu Fee (8%) 2,451,710 2,671,405 2,720,200 2,745,950 25,750 7055 Uncollectible Accounts 151,765 84,030 70,000 50,000 (20,000) OPERATIONS SUBTOTAL 35,673,085 35,375,675 36,604,875 39,638,340 3,033,465 CAPITAL OUTLAY 7130 Structures/Other 67,045 36,740 70,000 110,000 40,000 7140 Equipment & Machinery 236,775 225,805 280,000 275,000 (5,000) 7145 Lines, Mains & Sewers 255,165 244,980 335,000 335,000 - CAPITAL OUTLAY SUBTOTAL 558,985 507,525 685,000 720,000 35,000 TRANSFERS OUT 5950 Transfer Out 8,100 8,170 8,170 8,370 200 TRANSFERS OUT SUBTOTAL 8,100 8,170 8,170 8,370 200 ELECTRIC FUND TOTAL: 39,137,520 38,944,795 40,727,555 43,823,065 3,095,510 381 THIS PAGE INTENTIONALLY LEFT BLANK 382 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 OPERATIONS Interest - Long-Term Debt 7001 Interest Expense 511,390 482,415 443,160 416,400 (26,760) Subtotal 511,390 482,415 443,160 416,400 (26,760) Distribution Operations-Supervision & Engineering 6530 Office Supplies 400 5 240 240 - 6539 Printing, Binding & Duplicating 95 55 80 - (80) 6566 Small Tools 615 - - - - 6915 Utilities/Telephone - 125 - - - Subtotal 1,110 185 320 240 (80) Distribution Operations-Overhead Lines 6530 Office Supplies 35 - 100 100 - 6563 Supplies/Special 905 100 1,000 1,000 - 6566 Small Tools 8,170 6,415 10,000 10,000 - Subtotal 9,110 6,515 11,100 11,100 - Distribution Operations-Underground Lines 6554 Supplies/Custodial and Cleaning 485 - - 4,800 4,800 6563 Supplies/Special - 165 - - - 6566 Small Tools 2,605 490 3,100 3,100 - Subtotal 3,090 655 3,100 7,900 4,800 Distribution Operations-Street Lighting & Signal 6905 Utilities / Electricity 8,230 10,895 10,200 11,000 800 Subtotal 8,230 10,895 10,200 11,000 800 Distribution Operations-Meters 6566 Small Tools - - 500 500 - Subtotal - - 500 500 - 383 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 Distribution Operations-Miscellaneous Distribution 6201 Uniforms & Laundry 17,630 21,100 21,700 12,000 (9,700) 6220 Training Schools 24,680 29,230 10,000 16,000 6,000 6225 Training Materials 715 - 900 1,000 100 6230 Dues & Subscriptions 7,805 9,970 22,500 22,500 - 6235 Meetings & Conferences 35 390 1,000 6,000 5,000 6240 Mileage Reimbursement 160 - - 200 200 6301 Legal Fees 4,670 4,830 2,400 2,500 100 6340 Special Studies - - - 15,000 15,000 6430 Custodial Services - 310 - - - 6493 Outside Service/Repair - 1,185 - - - 6521 Messenger Service 350 215 100 100 - 6530 Office Supplies - 5 - - - 6551 Fuel and Oil 21,045 24,160 20,000 20,000 - 6563 Supplies/Special (2,015) 4,155 5,600 5,600 - 6564 Supplies/Medical-Dental 1,400 2,175 2,200 2,500 300 6569 Small Equipment 665 - 15,000 15,000 - 6601 Advertising Expense 700 - - 500 500 6825 Maint & Repair / Vehicle 39,960 53,740 40,000 40,000 - 6827 Garage Allocation 2,570 3,670 3,800 3,800 - 6835 Maint & Repair/Equipment 1,120 - - 5,000 5,000 6904 Utilities/Other 16,250 15,735 15,000 15,000 - 6905 Utilities/Electricity 60 - - - - 6910 Utilities/Natural Gas 750 840 700 700 - 6915 Utilities/Telephone 10,055 9,150 7,200 7,200 - Subtotal 148,605 180,860 168,100 190,600 22,500 Distribution Maintenance-Structures 6430 Custodial Services 4,260 3,745 3,800 4,620 820 6493 Outside Services & Repairs 8,205 2,440 2,520 2,500 (20) 6554 Supplies/Custodial & Cleaning 1,190 1,435 900 900 - 6815 Maint & Repairs/Bldgs 24,435 14,550 17,600 17,600 - Subtotal 38,090 22,170 24,820 25,620 800 384 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 Distribution Maintenance-Station Equipment 6235 Meeting & conferences - 285 - - - 6493 Outside Services & Repairs 10,935 25,920 30,690 30,690 - 6563 Supplies/Special 835 185 1,100 1,000 (100) Subtotal 11,770 26,390 31,790 31,690 (100) Distribution Maintenance-Overhead Lines 6493 Outside Services & Repairs 161,195 219,715 145,410 200,000 54,590 6530 Office Supplies - 255 - - - 6563 Supplies/Special 7,065 4,095 5,900 5,000 (900) Subtotal 168,260 224,065 151,310 205,000 53,690 Distribution Maintenance-Underground Lines 6493 Outside Services & Repairs 10,125 43,770 46,820 46,000 (820) 6563 Supplies/Special 4,460 3,600 6,200 6,200 - 6835 Maint & Repair/Equipment 110 180 - - - Subtotal 14,695 47,550 53,020 52,200 (820) Distribution Maintenance-Transformer Lines 6493 Outside Services & Repairs - - 19,390 19,390 - Subtotal - - 19,390 19,390 - Distribution Maintenance-Street Lighting & Signals 6563 Supplies/Special - - 2,000 5,000 3,000 Subtotal - - 2,000 5,000 3,000 Distribution Maintenance-Meters 6563 Supplies/Special 7,985 7,205 8,000 8,000 - 6835 Maint & Repair/Equipment 660 - 1,200 1,200 - Subtotal 8,645 7,205 9,200 9,200 - Customer Accounts-Uncollectible Accounts 7055 Uncollectible Accounts 151,765 84,030 70,000 50,000 (20,000) Subtotal 151,765 84,030 70,000 50,000 (20,000) 385 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 Engineering 6220 Training Schools 1,270 35 1,000 1,000 - 6235 Meetings & Conferences - - 1,000 1,000 - 6340 Special Studies - - - 30,000 30,000 6345 Program Consultants 1,860 2,720 3,200 5,000 1,800 6399 Professional Services/Other - 17,700 - (17,700) 6530 Office Supplies 3,460 3,155 2,800 3,000 200 6551 Fuel and Oil 865 - 800 800 - 6825 Maint & Repair / Vehicle 75 - 1,000 1,000 - Subtotal 7,530 5,910 27,500 41,800 14,300 Resource Management - Purchased Power 6590 Electricity For Resale 26,042,270 25,179,880 26,030,710 28,579,410 2,548,700 Subtotal 26,042,270 25,179,880 26,030,710 28,579,410 2,548,700 Resource Management - Other 6220 Training Schools - - 5,260 5,260 - 6225 Training Materials - 5 - - - 6235 Meetings & Conferences 3,290 11,370 8,000 8,000 - 6240 Mileage Reimbursement - 40 - - - 6301 Legal Fees 47,700 75,160 100,000 150,000 50,000 6340 Special Studies - - 15,000 - (15,000) 6399 Professional Services 16,200 - - - - 6521 Messenger Service 65 135 1,000 1,000 - 6530 Office Supplies 90 600 1,000 1,000 - 6569 Small Equipment 6,170 3,860 4,000 4,000 - 6625 Program Expenses 303,650 207,140 300,000 300,000 - 6645 Relocation Costs 4,935 - - - - 6830 Rent/Equipment 75 - 150 150 - 6915 Utilities/Telephone 1,230 1,970 1,065 1,200 135 Subtotal 383,405 300,280 435,475 470,610 35,135 386 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 Resources Management - Transmission 6493 Outside Services & Repairs 567,475 647,565 639,140 686,205 47,065 Subtotal 567,475 647,565 639,140 686,205 47,065 Resources Management - Transmission by Others 6493 Outside Services & Repairs 2,370,945 2,638,295 2,866,030 3,008,585 142,555 Subtotal 2,370,945 2,638,295 2,866,030 3,008,585 142,555 Administrative & General 6399 Professional Services/Other - - 19,550 - (19,550) 6424 Consumer Services Allocation 2,159,565 2,169,055 2,185,710 2,380,950 195,240 Subtotal 2,159,565 2,169,055 2,205,260 2,380,950 175,690 Franchise Fees 7010 Franchise Fee (2%) 612,925 667,850 680,050 686,490 6,440 7012 In-lieu Fee (8%) 2,451,710 2,671,405 2,720,200 2,745,950 25,750 Subtotal 3,064,635 3,339,255 3,400,250 3,432,440 32,190 Interest Transfers 6610 Bond Administration 2,500 2,500 2,500 2,500 - Subtotal 2,500 2,500 2,500 2,500 - OPERATIONS SUBTOTAL 35,673,085 35,375,675 36,604,875 39,638,340 3,033,465 387 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 CAPITAL OUTLAY Structures & Improvements 7130 Structures/Other 280 60 10,000 - (10,000) Subtotal 280 60 10,000 - (10,000) Station Equipment 7140 Equipment & Machinery 260 6,325 25,000 25,000 - Subtotal 260 6,325 25,000 25,000 - Poles, Towers & Fixtures 7130 Structures/Other 57,540 34,580 35,000 35,000 - 7140 Equipment & Machinery 355 - - - - 7145 Lines, Mains & Sewers 6,425 35 - - - Subtotal 64,320 34,615 35,000 35,000 - Overhead Conductors & Dev 7130 Structures/Other 125 - - - - 7145 Lines, Mains & Sewers 128,095 58,505 85,000 85,000 - Subtotal 128,220 58,505 85,000 85,000 - Underground Conduit 7130 Structures/Other 9,085 2,100 25,000 25,000 - 7140 Equipment & Machinery - - 25,000 25,000 Subtotal 9,085 2,100 25,000 50,000 25,000 Underground Conductors & Dev 7130 Structures/Other 15 - - - - 7145 Lines, Mains & Sewers 120,645 186,440 250,000 250,000 - Subtotal 120,660 186,440 250,000 250,000 - Line Transformers 7140 Equipment & Machinery 97,810 128,010 100,000 150,000 50,000 Subtotal 97,810 128,010 100,000 150,000 50,000 388 BUDGET UNIT: ALL FUND 33 DIVISIONS - ELECTRIC (DETAILS) DESCRIPTION ACTUAL ACTUAL REVISED ADOPTED VARIANCE Acct. #09-10 10-11 11-12 12-13 Meters 7140 Equipment & Machinery 83,730 55,960 90,000 50,000 (40,000) Subtotal 83,730 55,960 90,000 50,000 (40,000) Street Lighting 7130 Structures/Other - - - 50,000 50,000 7140 Equipment & Machinery 48,750 35,510 50,000 - (50,000) Subtotal 48,750 35,510 50,000 50,000 - Tools, Shop Equipment 7140 Equipment & Machinery 5,870 - 15,000 25,000 10,000 Subtotal 5,870 - 15,000 25,000 10,000 CAPITAL OUTLAY SUBTOTAL 558,985 507,525 685,000 720,000 35,000 TRANSFERS OUT Dist Oper - Overhead Line Expenses 5950 Transfers Out 4,050 4,085 4,085 4,185 100 Subtotal 4,050 4,085 4,085 4,185 100 Dist Oper - Underground Line Expenses 5950 Transfers Out 4,050 4,085 4,085 4,185 100 Subtotal 4,050 4,085 4,085 4,185 100 TRANSFERS OUT SUBTOTAL 8,100 8,170 8,170 8,370 200 ELECTRIC FUND TOTAL: 39,137,520 38,944,795 40,727,555 43,823,065 3,095,510 389 THIS PAGE INTENTIONALLY LEFT BLANK 390