MICHAEL R. PEEVEY

APPENDIX A

1 of 2

                     

APPLE VALLEY RANCHOS WATER COMPANY

Test Year 2003

Summary of Earnings

                     
   

(At Present Rates)

 

ADOPTED

   

AVR

 

ORA

     

At Present

 

At Authorized

 
   

Updated

 

Updated

     

Rates

 

ROR

   

'(Dollars in Thousands)

     

(Dollars in Thousands)

Operating Revenues:

                 
 

Water

10,384.5

 

10,455.9

     

10,743.5

 

12,343.8

 

Deferred

(1.6)

 

(1.6)

     

(1.6)

 

(1.6)

Total Revenues

10,386.1

 

10,457.5

     

10,745.1

 

12,345.4

Expenses:

                 

O&M Expenses

                 
 

Payroll-Operations

465.0

 

330.1

     

465.0

 

465.0

 

Operations-Other

112.1

 

112.1

     

112.1

 

112.1

 

Purchased Power

1,064.4

 

1,237.1

     

1,237.1

 

1,237.1

 

Leased Water Rights

207.9

 

252.7

     

252.7

 

252.7

 

Replenishment Charges

151.4

 

149.0

     

149.0

 

149.0

 

Chemicals

16.8

 

16.8

     

16.8

 

16.8

 

Payroll-Customer

256.9

 

182.4

     

256.9

 

256.9

 

Customers-Other

87.3

 

87.3

     

87.3

 

87.3

 

Payroll-Maintenance

213.1

 

151.3

     

213.1

 

213.1

 

Maintenance-Other

1,069.6

 

1,071.1

     

1,069.6

 

1,069.6

 

Uncollectibles 0.46%

47.8

 

48.1

     

49.4

 

56.8

 

Subtotal O&M

3,692.2

 

3,637.9

     

3,909.0

 

3,916.4

                     

A&G Expenses

                 
 

Payroll

758.0

 

566.9

     

758.0

 

758.0

 

Payroll-Benefits

463.5

 

430.5

     

463.5

 

463.5

 

Insurance

472.9

 

349.8

     

446.2

 

446.2

 

Uninsured Property Damage

1.6

 

1.6

     

1.6

 

1.6

 

Regulatory Commission Expenses

58.3

 

48.7

     

48.7

 

48.7

 

Outside Services

98.3

 

93.3

     

98.3

 

98.3

 

Office Supplies

177.4

 

177.4

     

177.4

 

177.4

 

A&G Transferred

(205.0)

 

(205.5)

     

(205.0)

 

(205.0)

 

Miscellaneous

28.4

 

28.4

     

28.4

 

28.4

 

Franchise Requirements 1.05%

109.1

 

109.8

     

112.8

 

129.6

Main Office Allocation

                 
 

A&G Expenses

715.0

 

595.4

     

715.0

 

715.0

 

Data Processing

155.9

 

123.3

     

155.9

 

155.9

 

Subtotal A&G

2,833.4

 

2,319.6

     

2,800.8

 

2,817.6

                     
 

Ad Valorem Taxes

326.4

 

333.8

     

326.2

 

326.2

 

Payroll Taxes

164.6

 

130.4

     

159.7

 

159.7

 

Depreciation Expenses

1,227.7

 

1,192.3

     

1,217.1

 

1,217.1

 

California Income Tax

104.2

 

177.6

     

120.3

 

259.6

 

Federal Income Tax

410.5

 

697.4

     

466.7

 

1,002.6

Total Operating Expenses

8,759.1

 

8,489.0

     

8,999.80

 

9,699.20

Net Operating Revenue

1,627.0

 

1,968.5

     

1,745.3

 

2,646.1

Rate Base

27,903.5

 

23,862.9

     

27,883.0

 

27,883.0

Rate of Return

5.83%

 

8.25%

     

6.26%

 

9.49%

APPENDIX A

2 of 2

APPLE VALLEY RANCHOS WATER COMPANY

Test Year 2004

Summary of Earnings

                     
   

(At Present Rates)

ADOPTED

   

AVR

 

ORA

 

At Present

 

At 2003

 

At Authorized

   

Updated

 

Updated

 

Rates

 

Rates

 

ROR

   

'(Dollars in Thousands)

     

(Dollars in Thousands)

Operating Revenues:

                 
 

Water

12,779.6

 

11,044.2

 

10,950.6

 

12,588.3

 

12,897.9

 

Deferred

(1.3)

 

(2.5)

 

(2.5)

 

(2.5)

 

(2.5)

Total Revenues

12,780.8

 

11,046.7

 

10,953.1

 

12,590.8

 

12,900.4

Expenses:

                 

O&M Expenses

                 
 

Payroll-Operations

491.7

 

341.0

 

491.7

 

491.7

 

491.7

 

Operations-Other

115.4

 

115.4

 

115.4

 

115.4

 

115.4

 

Purchased Power

1,080.8

 

1,257.4

 

1,257.4

 

1,257.4

 

1,257.4

 

Leased Water Rights

226.3

 

273.9

 

273.9

 

273.9

 

273.9

 

Replenishment Charges

152.2

 

150.0

 

150.0

 

150.0

 

150.0

 

Chemicals

13.7

 

13.7

 

13.7

 

13.7

 

13.7

 

Payroll-Customer

271.7

 

188.4

 

271.7

 

271.7

 

271.7

 

Customers-Other

89.4

 

89.4

 

89.4

 

89.4

 

89.4

 

Payroll-Maintenance

225.3

 

156.3

 

225.3

 

225.3

 

225.3

 

Maintenance-Other

1,074.0

 

1,076.6

 

1,074.0

 

1,074.0

 

1,074.0

 

Uncollectibles 0.46%

58.8

 

50.8

 

50.4

 

57.9

 

59.3

 

Subtotal O&M

3,799.5

 

3,712.9

 

4,012.9

 

4,020.4

 

4,021.8

                     

A&G Expenses

                   
 

Payroll

796.6

 

561.8

 

796.6

 

796.6

 

796.6

 
 

Payroll-Benefits

489.2

 

448.9

 

489.2

 

489.2

 

489.2

 

Insurance

557.5

 

373.8

 

509.5

 

509.5

 

509.5

 

Uninsured Property Damage

1.7

 

1.6

 

1.7

 

1.7

 

1.7

 

Regulatory Commission Expenses

58.3

 

48.3

 

48.3

 

48.3

 

48.3

 

Outside Services

102.0

 

97.0

 

102.0

 

102.0

 

102.0

 

Office Supplies

182.5

 

182.5

 

182.5

 

182.5

 

182.5

 

A&G Transferred

(164.5)

 

(168.8)

 

(164.5)

 

(164.5)

 

(164.5)

 

Miscellaneous

29.2

 

29.2

 

29.2

 

29.2

 

29.2

 

Franchise Requirements 1.05%

134.2

 

116.0

 

115.0

 

132.2

 

135.5

Main Office Allocation

                 
 

A&G Expenses

736.5

 

613.1

 

736.5

 

736.5

 

736.5

 

Data Processing

159.5

 

112.9

 

159.5

 

159.5

 

159.5

 

Subtotal A&G

3,082.7

 

2,436.3

 

3,005.5

 

3,022.7

 

3,026.0

                     
 

Ad Valorem Taxes

342.6

 

296.7

 

342.0

 

342.0

 

342.0

 

Payroll Taxes

173.9

 

115.6

 

168.7

 

168.7

 

168.7

 

Depreciation Expenses

1,338.5

 

1,288.1

 

1,327.9

 

1,327.9

 

1,327.9

 

California Income Tax

294.8

 

204.7

 

95.6

 

238.2

 

265.2

 

Federal Income Tax

1,027.9

 

717.8

 

327.0

 

828.0

 

931.7

                     

Total Operating Expenses

10,059.9

 

8,772.0

 

9,279.60

 

9,947.90

 

10,083.30

                     

Net Operating Revenue

2,721.0

 

2,274.7

 

1,673.5

 

2,642.9

 

2,817.1

                     

Rate Base

29,740.3

 

25,555.7

 

29,715.7

 

29,715.7

 

29,715.7

                     

Rate of Return

9.15%

 

8.90%

 

5.63%

 

8.89%

 

9.48%

APPENDIX D

 

Page 1 of 5

 

APPLE VALLEY RANCHOS WATER COMPANY

 

ADOPTED QUANTITIES

 

NET-TO-GROSS MULTIPLIER

 

1.7763

   

Uncollectible Rate

   

0.46%

   

Franchise Fee

   

1.05%

   

Federal Tax Rate

   

34.00%

   

State Tax Rate

   

8.84%

   
       

2003

2004

 

DOMESTIC WATER CONSUMPTION (KCcf)

       
             

Domestic Water Sales

   

5,734.5

5,844.7

 

Unaccounted Water (10%)

 

637.2

649.4

 

Total Water Production (KCcf)

 

6,371.7

6,494.1

 
             

Make-up ($130/AF)

   

$91,000

$91,000

 

Administrative ($2.35/AF)

 

$33,618

$34,386

 

Biological ($0.56/AF)

   

$8,011

$8,194

 

Total Replenishment Cost

 

$132,629

$133,580

 
             

Water Rights Lease (AF)

   

3,887

4,214

 

Lease Water Costs ($70/AF)

 

$252,681

$273,930

 
             

PURCHASED POWER

         
             

Pumping Cost

         

Electric

   

$1,169,267

$1,188,989

 

Gas

     

$29,509

$30,087

 

Total

     

$1,198,776

$1,219,076

 
             

Cost per A.F.

         

Electric

   

$73.75

$73.75

 

Gas

     

$69.50

$69.50

 
             

DOMESTIC WATER CONSUMPTION (Ccf/Customer)

       
             

Residential

   

305.7

305.7

 

Business

   

768.5

768.5

 

Public Authority

   

7,939.0

7,939.0

 

Pressure Irrigation (Landscape)

 

2,748.3

2,748.3

 

Industrial

   

317.2

317.2

 
             

Appendix D - Page 2 of 5

APPLE VALLEY RANCHOS WATER COMPANY

ADOPTED QUANTITIES

 
 
 
             
             
             
       

2003

2004

 

IRRIGATION WATER CONSUMPTION (Ccf)

       
             

Water Sales

   

297,547

297,547

 

Unaccounted Water (71.2%)

 

737,003.0

737,003.0

 

Total Water Production (Ccf)

 

1,034,550.0

1,034,550.0

 
             

Make-up ($130/AF)

   

$9,100

$9,100

 

Adminstrative ($2.35/AF)

 

$5,581

$5,581

 

Biological ($0.56/AF)

   

$1,704

$1,704

 

Total Replenishment Cost

 

$16,385

$16,835

 
             
             

PURCHASED POWER

         
             

Pumping Cost

         

Electric

   

$38,324

$38,324

 
             

Cost per A.F.

   

$16.14

$16.14

 
             
             

Water Consumption (Ccf/ Irrigation Customer)

       
             

Metered Service

   

148,773.7

148,773.7

 
             
             

Appendix D - Page 3 of 5

APPLE VALLEY RANCHOS WATER COMPANY

ADOPTED QUANTITIES

 
 
 
             
       

Utility Plant In Service

 
       

(Dollars in Thousands)

 
       

2003

2004

 

UTILITY PLANT IN SERVICE

       

Beginning Of Year Balance

 

48,217.1

52,190.6

 

Additions

   

4,380.0

3,520.0

 

Retirements

   

406.6

520.8

 

End Of Year Balance

   

52,190.6

55,189.7

 

Average Balance

   

50,203.8

53,690.1

 
             
             
             
             
       

Apple Valley Ranchos Water Company

 
       

Depreciation Reserve

 
       

(Dollars in Thousands)

 

DEPRECIATION RESERVE

       

Beginning Of Year Balance

 

10,752.9

11,633.9

 

Annual Accrual

   

1,287.6

1,385.5

 

Net Retirements

   

406.6

520.8

 

End Of Year Balance

   

11,633.9

12,498.5

 
             

Average Balance

   

11,193.4

12,066.2

 
             
             

Appendix D - Page 4 of 5

APPLE VALLEY RANCHOS WATER COMPANY

ADOPTED QUANTITIES

             
       

Adopted Rate Base Summary

 
       

(Dollars in Thousands)

 
 

RATE BASE

         

AVERAGE BALANCES

       

PLANT IN SERVICE

   

50,203.8

53,690.1

 

WORK IN PROGRESS

   

0.0

0.0

 

MATERIALS & SUPPLIES

 

145.5

147.1

 

WORKING CASH

   

802.6

776.9

 

SUBTOTAL

   

51,151.96

54,614.12

 

LESS:

         

DEPRECIATION RESERVE

 

11,193.4

12,066.2

 

ADVANCES

   

8,648.5

9,296.0

 

CONTRIBUTIONS

   

1,379.9

1,302.9

 

UNAMORTIZED ITC

   

105.0

100.1

 
             

DEFERRED INCOME TAX

 

2,944.9

3,131.5

 

SUBTOTAL

   

24,271.62

25,896.71

 
             

PLUS:

         

METHOD 5 ADJUSTMENT

 

31.4

27.1

 

NET DISTRICT RATE BASE

 

26,911.8

28,744.5

 

MAIN OFFICE ALLOCATION

 

971.2

971.2

 

TOTAL RATE BASE

   

27,883.0

29,715.7

 
             
             

Appendix D - Page 5 of 5

APPLE VALLEY RANCHOS WATER COMPANY

ADOPTED QUANTITIES

             
       

Adopted Income Tax Calculations

 
       

(Dollars in Thousands)

 
             
 

INCOME TAX

   

2003

2004

 
             

OPERATING REVENUES

 

12,345.4

12,900.4

 
             

EXPENSES

         
 

OPERATIONS & MAINTENANCE

 

3,859.6

3,962.5

 
 

UNCOLLECTIBLES .46%

 

56.8

59.3

 
 

ADMINISTRATIVE & GENERAL

 

2,888.0

2,890.6

 
 

FRANCHISE FEES 1.05%

 

129.6

135.5

 
 

AD VALOREM TAXES

 

326.2

342.0

 
 

PAYROLL TAXES

 

159.7

168.7

 
 

MEALS ADJUSTMENT

 

-8.5

-8.7

 
             
 

SUBTOTAL

   

7,211.4

7,549.8

 
             

DEDUCTIONS

         
 

CA TAX DEPRECIATION

 

1,237.6

1,331.7

 
 

INTEREST

   

959.2

1,019.2

 
             

CA TAXABLE INCOME

   

2,937.2

2,999.6

 
             

CCFT @ 8.84%

   

259.6

265.2

 
             

DEDUCTIONS

         
 

FED. TAX DEPRECIATION

 

1,103.9

1,329.7

 
 

INTEREST

   

959.2

1,019.2

 
 

CA TAX

   

120.3

265.2

 
             

FIT TAXABLE INCOME

   

2,950.6

2,742.0

 
             

FIT (BEFORE ADJUSTMENT) 34.00%

 

1,003.2

932.3

 
             
 

PRORATED ADJUSTMENT

       
 

INVESTMENT TAX CREDIT

 

-0.6

-0.6

 
             

NET FEDERAL INCOME TAX

 

1,002.6

931.7

 

APPENDIX F

APPLE VALLEY RANCHOS WATER COMPANY

2003 BILL COMPARISON

APPLE VALLEY AND VICINITY

Comparison of typical bills for residential metered customers of various usage level and

average level at present and authorized rates for bi-monthly billing.

   
               
               
   

General Metered Service (5/8X3/4-inch meter)

   
               
   

TEST YEAR 2003

   
               
   

Bi-Monthly

Present

Authorized

Percent

   
   

Usage (Ccf)

Rates

Rates

Increase

   
               
   

0

$33.10

$37.12

12.2%

   
   

20

$55.64

$63.52

14.2%

   
   

50 (Avg)

$89.45

$103.12

15.3%

   
   

60

$100.72

$116.32

15.5%

   
   

80

$123.26

$142.72

15.8%

   
               
               
   

TEST YEAR 2004

   
               
   

Bi-Monthly

Present

Authorized

Percent

   
   

Usage (Ccf)

Rates

Rates

Increase

   
               
   

0

$37.12

$38.62

4.0%

   
   

20

$63.52

$65.42

3.0%

   
   

50 (Avg)

$103.12

$105.62

2.4%

   
   

60

$116.32

$119.02

2.3%

   
   

80

$142.72

$145.82

2.2%

   
               
               
   

(END OF APPENDIX F)

Previous PageTop Of PageGo To First Page