Word Document PDF Document

Appendix A

North Gualala Water Company

SUMMARY OF EARNINGS

Test Year 2010

 

Utility Estimated

Branch Estimated

 

Item

Present Rates

Requested Rates

Present Rates

Requested Rates

Recommended Rates

OPERATING REVENUES

         

Metered Rates

$738,053

$961,872

$747,209

$961,872

$953,132

Other Water Revenue

$13,400

$13,400

$13,400

$13,400

$13,400

Total Revenue

$751,453

$975,272

$760,609

$975,272

$966,532

           

OPERATING EXPENSES

         
           

Purchased Power

$75,077

$75,077

$71,411

$71,411

$71,411

Other Volume Related Expenses

$2,798

$2,798

$2,636

$2,636

$2,636

Employee Labor

$101,704

$101,704

$101,704

$101,704

$101,704

Materials

$21,525

$21,525

$21,525

$21,525

$21,525

Contract Work

$12,238

$12,238

$12,238

$12,238

$12,238

Water Testing

$13,815

$13,815

$13,815

$13,815

$13,815

Transportation

$28,637

$28,637

$28,637

$28,637

$28,637

Other Plant Maintenance

$0

$0

$0

$0

$0

Office Salaries

$71,624

$71,624

$71,624

$71,624

$71,624

Management Salaries

$70,233

$70,233

$70,233

$70,233

$70,233

Employee Benefits

$50,707

$50,707

$50,707

$50,707

$50,707

Uncollectibles

$751

$975

$975

$975

$975

Office Services & Rental

$6,000

$6,000

$6,000

$6,000

$6,000

Office Supplies and Exp

$32,589

$32,589

$32,589

$32,589

$32,589

Professional Services

$68,327

$68,327

$80,133

$80,133

$80,133

Insurance

$28,608

$28,608

$28,608

$28,608

$28,608

Regulatory Comm Exp

$6,800

$6,800

$4,680

$4,680

$4,680

General Expenses

$23,016

$23,016

$10,848

$10,848

$10,848

Subtotal

$614,449

$614,673

$608,364

$608,364

$608,364

           

Depreciation Expense

$39,042

$39,042

$39,042

$39,042

$39,042

Taxes other than income

$69,491

$69,491

$69,491

$69,491

$69,491

State Income Tax

$2,517

$22,280

$3,864

$22,840

$22,068

Federal Income Tax

$3,893

$72,850

$5,977

$75,109

$72,002

 

 

 

 

 

 

Total Deductions

$729,392

$818,336

$726,738

$814,846

$810,966

           

NET REVENUE

$22,061

$156,936

$33,871

$160,426

$155,567

           

RATE BASE

         
           

Average Plant

$3,159,203

$3,159,203

$3,159,203

$3,159,203

$3,159,203

Average Depreciation Reserve

$1,617,288

$1,617,288

$1,617,288

$1,617,288

$1,617,288

 

 

 

 

 

 

Net Plant

$1,541,915

$1,541,915

$1,541,915

$1,541,915

$1,541,915

           

Working Cash

$51,223

$51,223

$51,223

$51,223

$51,223

Materials and Supplies

$10,459

$10,459

$10,459

$10,459

$10,459

Less Advances

$0

$0

$0

$0

$0

Contributions

$1,003,957

$1,003,957

$1,003,957

$1,003,957

$1,003,957

           

Rate Base

$599,640

$599,640

$599,640

$599,640

$599,640

           

RATE OF MARGIN

3.1%

21.7%

4.7%

22.4%

21.7%

APPENDIX B

(END OF APPENDIX B)

APPENDIX C

             

North Gualala Water Company

             

COMPARISON OF RATES

TEST YEAR 2010

             
   

Tariff Rates

Recommended Increase

 

Tariff Description

 

Interim

Recommended

Dollars

Percentage

 

Service Charge:

           

5/8 x 3/4 inch meter

 

$30.02

$38.75

$8.73

29.1%

 

3/4-inch meter

 

$45.08

$58.12

$13.04

28.9%

 

1-inch meter

 

$75.09

$96.87

$21.78

29.0%

 

1-1/2 inch meter

 

$150.18

$193.74

$43.56

29.0%

 

2-inch meter

 

$240.34

$309.99

$69.65

29.0%

 

3-inch meter

 

$450.66

$581.23

$130.57

29.0%

 

4-inch meter

 

$751.14

$968.72

$217.58

29.0%

 
             

Quantity Charge:

           

First 300 cu. ft. of water, per 100 cu. ft.

 

$4.48

$5.64

$1.16

25.8%

 

Over 300 cu. ft. of water, per 100 cu. ft.

 

$5.69

$7.16

$1.47

25.8%

 
             

A monthly bill comparison for a customer with a 5/8 x 3/4 -inch meter is shown below:

   
   

Tariff Rates

Recommended Increase

 

Usage 100 cu. Ft.

 

Interim

Recommended

Dollars

Percentage

 

0

 

$30.02

$38.75

$8.73

29.1%

 

5

 

$54.84

$69.97

$15.13

27.6%

 

6

 

$60.53

$77.13

$16.60

27.4%

 

10

 

$83.29

$105.76

$22.47

27.0%

 

15

 

$111.74

$141.55

$29.81

26.7%

 

20

 

$140.19

$177.33

$37.14

26.5%

 

30

 

$197.09

$248.91

$51.82

26.3%

 
             

A monthly bill comparison for a customer with a 1-inch meter is shown below:

   
   

Tariff Rates

Recommended Increase

 

Usage 100 cu. Ft.

 

Interim

Recommended

Dollars

Percentage

 

0

 

$75.09

$96.87

$21.78

29.0%

 

5

 

$103.54

$132.66

$29.12

28.1%

 

6

 

$109.23

$139.82

$30.59

28.0%

 

10

 

$131.99

$168.45

$36.46

27.6%

 

15

 

$160.44

$204.24

$43.80

27.3%

 

20

 

$188.89

$240.02

$51.13

27.1%

 

30

 

$245.79

$311.60

$65.81

26.8%

 

APPENDIX D

North Gualala Water Company

ADOPTED QUANTITIES

TEST YEAR 2010

       

1. Purchased power

     
 

Vendor

Pacific Gas and Electric

       
 

kWh/Ccf

4.982

 
 

Adopted Usage kWh

407,458

 
 

Total Cost

$71,411

 
 

Composite Energy Cost ($/kWh)

$0.17526

 
       

2. Water Sales:

Ccf

69,763

 

Production:

Ccf

81,786

 

Non-Revenue:

%

14.7%

 
       

3. Number of Service Connections:

   
 

Meter Size

Average Number of Customers

 
       
 

5/8 x 3/4-inch

1019

 
 

3/4-inch

7

 
 

1-inch

10

 
 

1 1/2-inch

5

 
 

2-inch

2

 
 

3-inch

0

 
 

4-inch

0

 
       

4. Tax calculation:

     
 

Item

State Tax

Federal Tax

       
 

Operating Revenue

$966,532

$966,532

       
 

O & M Expenses

$608,364

$608,364

 

Taxes Other Than Income

$69,491

$69,491

 

Depreciation

$39,042

$39,042

 

Interest Expense

$0

$0

       
 

Taxable Income for State Tax

$249,636

 
 

State Tax

$22,068

 
       
 

Taxable Income for FIT

 

$227,568

 

Federal Income Tax

 

$72,002

 

Total Income Tax

 

$94,069

       

California Corporate Franchise Rate

 

8.84%

       

Federal Income Tax Rate

 

1st $50K

15%

   

Next $25K

25%

   

Next $25K

34%

   

Next $235K

39%

Top Of Page