IRR 2011 Sch A-11 F.Z13.XLSM

1/4/2011

CENTRAL VALLEY PROJECT

SCHEDULE OF ESTIMATED IRRIGATION PROJECT USE ENERGY COSTS

DIRECT PUMPING

2011 IRRIGATION WATER RATES

BCDE F GH I 

2011 Projected Deliveries Schedule A-12

Tehama-Colusa Canal Relifts 

Wintu Colusa Dunnigan Glenn Valley Kanawha Orland- Westside 

Facility/Contractor PP County WD WD WD WD Artois WD WD 

<Sch A-12> <Sch A-12> <Sch A-12> <Sch A-12> <Sch A-12> <Sch A-12> <Sch A-12> 

Corning Canal

Corning WD Proberta WD 

Cow Creek Unit

Bella Vista WD 7,693

Tehama-Colusa Canal

Colusa County WD 36,779Dunnigan WD 12,106Glenn Valley WD 930Kanawha WD 28,693Orland-Artois WD 32,714Westside WD 38,07 Total Deliveries 7,693 36,779 12,106 930 28,693 32,714 38,07

Est. 2011 Project Use Energy Cost 92,096 $ 289,764 $ 4,557 $ - $ 26,985 $ 47,793 $ 18,77

$ 

Cost Per A/F 11.97 $ 7.88 $ 0.38 $ - $ 0.94 $ 1.46 $ 0.4

$ 

A

Ref
IRR 2011 Sch A-11 F.Z13.XLSM

1/4/2011

CENTRAL VALLEY PROJECT

SCHEDULE OF ESTIMATED IRRIGATION PROJECT USE ENERGY COSTS

DIRECT PUMPING

2011 IRRIGATION WATER RATES

BCDE F GH I 

San Luis Canal Relifts

Westlands WD 1/

Panoche San Luis Westlands Pleasant Pleasant 

Facility/Contractor WD WD WD Relifts Valley PP Valley Rlfts Total 

<Sch A-12> <Sch A-12> <Sch A-12> <Sch A-12> <Sch A-12> (E+F) 

Cross Valley Canal

County of Fresno County of Tulare Hills Valley ID Kern-Tulare ID 5/ Lower Tule River ID - CV Pixley ID Rag Gulch WD 5/ 

Tri-Valley WD 

San Luis Canal

Panoche WD -SLC 41,479San Luis WD - SLC 46,286Westlands WD - SLC 608,637 68,280 12,950 676,917 2/Westlands WD - SLC (DD#2) 624 70 13 694 2/ Total Deliveries 41,479 46,286 609,261 68,350 12,963 677,611 Estimated 2011 Project Use Energy Cost 990 $ 539,950 $ 1,751,752 $ 254,155 $ 41,068 $ 2,046,976 $ 

Cost Per A/F 0.02 $ 11.67 $ $ 

3.02

A

Ref
IRR 2011 Sch A-11 F.Z13.XLSM

1/4/2011

CENTRAL VALLEY PROJECT

SCHEDULE OF ESTIMATED IRRIGATION PROJECT USE ENERGY COSTS

DIRECT PUMPING

2011 IRRIGATION WATER RATES

FOOTNOTES (FOR PAGES 1 AND 2)

1/ Westlands WD & (DD#2) deliveries are based on firm supplies:

Ratios Weslands WD Westlands WD DD#2

3/

 Westlands WD Relifts: High Side - Relift Pumps 0.26957 182,473 187 Low Side (LS) - Gravity Feed 0.62957 426,164 437 Subtotal 0.89913 608,637 624 Pleasant Valley PP: High Side - Relift Pump 0.01913 12,950 13 Coalinga Canal, LS - Gravity 0.08174 55,331 57 Subtotal (Pleasant Valley PP) 0.10087 68,280 70 Total - WWD Deliveries 1.0000 676,917 694

2/ Excludes Pleasant Valley Relifts deliveries as they are included with Pleasant Valley Pumping Plant.3/ Refer to Schedule A-5 worksheet "KWHSPERAF".

Allocated 2011 Deliveries
IRR 2011 Sch A-11 F.Z13.XLSM

1/4/2011

CENTRAL VALLEY PROJECT

SCHEDULE OF ESTIMATED IRRIGATION PROJECT USE ENERGY COSTS

DIRECT PUMPING

2011 IRRIGATION WATER RATES

FOOTNOTES - Cont.

4/ Dos Amigos and State Delta PP Costs: Dos State

Amigos PP Delta PP

2011 PUE Estimate

Direct Billed $ 120,557 1,749,806 $ Cross Valley Canal 2011 Projected Cost 73,045 $ 71,741 $ Total $ 192,298 1,822,851 $ 

Cross Valley Canal

Dos Amigos PP State Delta PP Projected 

2011 2011 2011 Dos 

Projection Projection Deliveries Amigos PP 

IrrigationCounty of Fresno 1,518 $ 1,491 $ 677 2.2

$ 

County of Tulare 2,714 $ 2,666 $ 1,210 2.2

$ 

Hills Valley ID 2,158 $ 2,120 $ 962 2.2

$ 

Kern-Tulare ID 5/ 25,856 $ 25,394 $ 11,527 2.2

$ 

Lower Tule River ID - CV 18,044 $ 17,722 $ 8,044 2.2

$ 

Pixley ID 19,902 $ 19,547 $ 8,872 2.2

$ 

Rag Gulch WD 5/ - $ - $ - - $ 

Tri-Valley WD 671 $ 659 $ 299 2.2

$ 

 Total Irrigation 70,864 $ 69,598 $ 31,591

M & ICounty of Fresno 673 $ 661 $ 300 2.2

$ 

County of Tulare 1,509 $ 1,482 $ 673 2.2

$ 

 Total M&I 2,181 $ 2,142 $ 973

Grand Total 73,045 $ 71,741 $ 32,564

5/ Rag Gulch WD assigned all of its entitlement to Kern-Tulare WD effective February 25, 2010.
IRR 2011 Sch A-11 F.Z13.XLSM

1/4/2011

SCHEDULE OF ESTIMATED IRRIGATION PROJECT USE ENERGY COSTS

DIRECT PUMPING

2011 IRRIGATION WATER RATES

C D E FG H I 

Acre-Feet Ratio of Acre-Feet F

M&I Irrigation M&I Irrigation Total Total $ M&I 

<Sch A-12> <Sch A-12> (C/(C+D)) (D/(C+D)) (E+F) <Meter Costs> (E*H) 

Used in Schedule 10

Storage: Friant D&R 2/ 173.60 100.00% 100.00% 12,344.22 12,344 Shasta D&R (Includes Jdg F Carr PH) 1,745.40 3,155.40 35.61% 64.39% 100.00% 176,147.11 62,734 Columbia Mowry (Based on Avg. KWH's) 79,381.18 562,166.33 12.37% 87.63% 100.00% 14,362.60 1,777 Folsom Pump Plant 42,414.60 100.00% 100.00% 141,744.16 141,744 New Melones Dam & Reservoir 34,788.60 100.00% 100.00% 2,643.00  Gianelli WR Pump-Gen Plt 3/ 9,989.28 539,781.76 1.82% 98.18% 100.00% 2,184,529.93 39,692 Regen. Credit - San Luis PP 9,989.28 539,781.76 1.82% 98.18% 100.00% (1,743,341.95) (31,676 SFU Gianelli WR PGP (Direct Pumping) 91,542.80 34,869.80 72.42% 27.58% 100.00%Conveyance Pumping: Corning Pumping Plant 16,336.00 100.00% 100.00% 183,695.30  Dos Amigos Pumping Plant 4/ 13,677.40 766,395.77 1.75% 98.25% 100.00% 1,749,806.07 30,680 O'Neill Pump-Gen Plt 105,813.20 805,986.60 11.60% 88.40% 100.00% 1,391,209.59 161,448 Regen. Credit - O'Neill Pump-Gen Plt 105,813.20 805,986.60 11.60% 88.40% 100.00% (155,574.31) (18,054 Jones Pumping Plant 186,186.79 1,783,758.81 9.45% 90.55% 100.00% 10,742,611.55 1,015,323 In-Lieu of Jones Pumping 120,556.93 Out-of-Basin Pumping: Coyote PP 43,609.90 9,395.60 82.27% 17.73% 100.00% 155,863.15 128,235 Pacheco PP 91,542.80 34,869.80 72.42% 27.58% 100.00% 1,280,610.95 927,365

Used in Schedule 11 Page 1

Direct Pumping: Glenn Valley WD 930.20 100.00% 100.00% Gianelli PGP - SFU 1/ 502,303.85 363,747 Contra Costa PP 87,340.40 100.00% 100.00% 699,419.05 699,419 Colusa CWD (Incl. Arb./Will O&M Office) 112.50 36,779.20 0.30% 99.70% 100.00% 290,649.83 886 Corning WD 11,110.40 100.00% 100.00% 45,040.08  Dunnigan WD 12,106.20 100.00% 100.00% 4,556.78  Kanawha WD 4.25 28,693.00 0.01% 99.99% 100.00% 26,989.07 4 Orland-Artois WD 32,714.00 100.00% 100.00% 47,792.68  Panoche WD - SLC 41,478.60 100.00% 100.00% 989.67  Westside WD 38,072.80 100.00% 100.00% 18,773.78  Pleasant Valley PP 6,774.40 55,387.38 10.90% 89.10% 100.00% 285,240.64 31,085 Pleasant Valley Relifts 12,963.00 100.00% 100.00% 41,068.17  Proberta WD 2,244.00 100.00% 100.00% 15,216.63  San Luis WD Relifts 620 46,286.00 1.32% 98.68% 100.00% 547,182.72 7,232 State-Delta PP - Cross Valley Canal 973 31,591.40 2.99% 97.01% 100.00% 71,740.74 2,142 Westlands WD Relifts 3,020.00 609,261.21 0.49% 99.51% 100.00% 1,760,435.46 8,683 Wintu PP 2,315.40 7,693.00 23.13% 76.87% 100.00% 119,814.80 27,718 City of Shasta Lake (Shasta PP) 5/ 2,554.80 100.00% 100.00% 40,212.45 40,212 Dos Amigos PP - Cross Valley Canal 73,045.08 2,18Reimbursable Billing 6,813.46Project General 10,281.32Nonreimbursable F&W 35,225.44

20,900,000.00 3,654,928

A B

Ref

CENTRAL VALLEY PROJECT
IRR 2011 Sch A-11 F.Z13.XLSM

1/4/2011

SCHEDULE OF ESTIMATED IRRIGATION PROJECT USE ENERGY COSTS

DIRECT PUMPING

2011 IRRIGATION WATER RATES

CENTRAL VALLEY PROJECT

FOOTNOTES (FOR PAGE 5)

1/ See Ratios in the Storage section2/ Irrigation contractor receives class 2 water which is not charged for the storage component.3/ According to MP-2810 (CB 06/93) only 70% of San Luis Canal Deliveries are stored in B.F. Sisk San Luis Reservoir and, therefore, require pumping by the WR Gianelli Pump-Generator.4/ Excludes estimated San Luis WD deliveries before Dos Amigos. The calculation reflects the relationship between actual deliveries versus actual exclusions over a 5 year period.

Source of data is Schedule A-12, worksheet "Input PUE", footnote #4.

46,286

less 4,721

41,565

Irrigation Deliveries *

Estimated

Total Excluded Ratio Exclusion

2005 71,899 8,6362006 74,635 9,1222007 80,058 8,0482008 66,552 5,8072009 68,004 5,223

Total 361,148 36,836 10.20% 4,721Total Dos Amigos Pumping Plant Irrigation Projected Water Deliveries less exclusions for San Luis Water District:

771,117

less 4,721

766,396

* Provided annually by Stacey Smith, CVOCO.

5/ It was determined in late 2000 that Shasta PP serves the City of Shasta Lake exclusively and accordingly is not a pooled storage cost. As a result, PUE O&M will be proactively

allocated to this contractor beginning in 2001.