M&I 2006 Sch B-2 F (CY ADJ).Z10.xls

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2006 M&I REVENUES

2008 M&I WATER RATES

(CURRENT YEAR ADJUSTMENT)

Sources for Current Year Adjustments: FY 2006 WDR Part 3 - Adjustment as of Sept 30 2006, Adjustment as of Oct-Nov, 2006, Adjustment as of Dec-Jan 2007FY 2006 WDR - Part 3 - as of Feb 2007, Part 3 - as of May 2007, Reconciliation of M&I Water Revenues provided by the Water Accounting Team

 Tota

Delivered Unused / Paid Water Other W

Facility/Contractor A/F Revenues A/F Revenues Receipts A/F ReBlack Butte D & R

County of Colusa 1/Elk Creek CSD 2/US Forest Service - BB 3/ 3 45.36 3 Whitney Const. 4/ (25) (375.00) (25) 

Total BB D & R 3 45.36 (25) (375.00) (22) 

Clear Creek Unit

Clear Creek CSD 5/ 167 5,069.68 167 

Contra Costa Canal

Contra Costa WD 6/ 1 16.75 1 

Cow Creek Unit

Bella Vista WD 7/ 74 2,516.74 74 

Cross Valley Canal

County of Fresno 8/County of Tulare 9/

Total CV Canal

Delta-Mendota Canal

Byron Bethany ID 10/ 1 19.90 1 

City of Tracy 11/ (324) (7,691.76) (324) Del Puerto WD 12/ 1 19.11 2 37.28 3 Department of VA 13/ (1) (43.20) (1) Panoche WD - DMC 14/ 2 40.50 2 San Luis WD - DMC 15/ 2 30.00 2 

Total DM Canal (319) (7,625.45) 2 37.28 (317) 

Folsom D & R

City of Roseville 16/ 6,796 61,164.00 6,796 El Dorado ID - FD&R 17/ 2,374 35,610.00 2,374 Sacramento County WA 18/ 1,907 36,499.52 1,907 San Juan WD 19/ 951 18,097.53 951 

Total Folsom D & R 12,028 151,371.05 12,028 

Folsom-South Canal

East Bay MUD 20/Sacramento MUD 21/ 503 6,443.43 3,656.81 503 

Total FS Canal 503 6,443.43 3,656.81 503 

Schedule Pg 1 of 12

9/18/2007
M&I 2006 Sch B-2 F (CY ADJ).Z10.xls Schedule 

Pg 2 of 12

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2006 M&I REVENUES

2008 M&I WATER RATES

(CURRENT YEAR ADJUSTMENT)

 Tota

Delivered Unused / Paid Water Other W

Facility/Contractor A/F Revenues A/F Revenues Receipts A/F ReFriant Dam

County of Madera 22/ (1) (25.28) (1) Fresno County WW #18 23/

Total Friant Dam (1) (25.28) (1) 

Friant-Kern Canal

Arvin Edison WSD 24/City of Fresno 25/ (8) (2,281.09) (8) City of Lindsay 26/ 53 1,276.98 53 City of Orange Cove 27/ (488) (8,349.68) (488) Delano-Earlimart ID 28/ 25 555.75 25 Lindsay-Strathmore ID 29/ 95 1,440.20 95 Shafter-Wasco ID 30/ 107 2,420.34 107 

Terra Bella ID 31/ 177 6,106.50 177 

Total FK Canal (39) 1,169.00 (39) 

Sacramento River

City of Redding - SR 32/ (115) (1,725.00) (115) 

City of West Sacramento 33/ 312 4,680.00 312 Lake California P.O.A. 34/Meyer Crest Ltd. 35/Riverview Golf & CC 36/

Total Sacramento River 197 2,955.00 197 

San Felipe Unit

SB County WD - IB 37/ 327 18,259.82 327 SC Valley WD - IB 38/ 42,671 1,826,574.55 42,671 

Total SF Unit 42,998 1,844,834.37 42,998 

San Luis Canal - Fresno

City of Avenal 39/ 11 158.51 11 

City of Coalinga 40/ 97 1,710.11 97 

City of Huron 41/ 3 45.00 3 

State of CA 42/ 2 70.92 2 Westlands WD 43/ (66) (1,356.96) (66) 

Total SLC - Fresno 47 627.58 47 

9/18/2007
M&I 2006 Sch B-2 F (CY ADJ).Z10.xls

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2006 M&I REVENUES

2008 M&I WATER RATES

(CURRENT YEAR ADJUSTMENT)

 Tota

Facility/Contractor Delivered Unused / Paid Water Other W

A/F Revenues A/F Revenues Receipts A/F Re

San Luis Canal - Tracy

Broadview WD 44/ 4 89.32 4 Pacheco WD - SLC 45/Panoche WD - SLC 46/ 11 357.54 11 

San Luis WD - SLC 47/ 74 1,736.78 74 

Total SLC - Tracy 89 2,183.64 89 

Shasta Dam

Centerville CSD 48/ 97 1,909.00 97 Mountain Gate CSD 49/ 24 419.28 24 Shasta CWA 50/ 134 2,744.34 134 

Total Shasta Dam 255 5,072.62 255 

Spring Creek Conduit

City of Redding - SCC 51/ 186 2,886.72 186 

Shasta CWA - SCC 52/ 41 953.68 41 Shasta CSD 53/ (11) (184.03) (11) 

Total SC Conduit 216 3,656.37 216 

Tehama-Colusa Canal

Colusa County WD 54/ (1) (22.57) (1) Kanawha WD 55/ 1 34.97 1 

Total Tehama-Colusa Canal

Toyon Pipeline

City of Redding - TP 56/ (5) (75.00) (5) City of Shasta Lake 57/ (39) ($842.01) (39) 

US Forest Service - TP 58/ 10 150.00 10 

Total Toyon Pipeline (34) (767.01) (34) 

San Felipe Out-Of-Basin Facilities

SB County WD - OB 59/ 327 14,061.00 327 SC Valley WD - OB 60/ 42,671 1,834,853.00 42,671 

Total SF Unit 42,998 1,848,914.00 42,998 

Total Permanent Contractors 56,185 3,866,470.25 (23) (337.72) 3,656.81 56,162 

Non-Permanent Contractors

Central San Joaquin WCDCity of Sacramento 61/ 33,174 $298,566.00 33,174 Corning WD 62/ 8 421.28 8 

Dunnigan WD 63/ (30) (917.40) (30) 

Fresno ID 64/ 70 949.20 70 

Garfield WD 65/ 14 358.26 14 

Lindmore ID 66/ 1 25.59 1 

Schedule Pg 3 of 12

9/18/2007
M&I 2006 Sch B-2 F (CY ADJ).Z10.xls Schedule 

Pg 4 of 12

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2006 M&I REVENUES

2008 M&I WATER RATES

(CURRENT YEAR ADJUSTMENT)

 Tota

Delivered Unused / Paid Water Other W

Facility/Contractor A/F Revenues A/F Revenues Receipts A/F ReNon-Permanent Contractors (Continued)

Lower Tule River IDOrange Cove ID 67/ 14 358.26 14 

Orland-Artois WD 68/ (42) ($1,501.50) (42) 

Siddiqui, J & ASMUD w/o Delta 69/ 

36,059.20

So. California WCStockton-East WD 70/ 2,238 50,049.14 2,238 

Stony Creek WD 71/ 18 341.19 18 Tea Pot Dome WD 72/ (1) (25.59) (1) 

Total Non-Perm CVP Contractors 35,464 348,624.43 - 36,059.20 35,464 

Non-Storable Project 215 Contractors

City of Lindsay City of Orange Cove 73/ 362 3,786.52 362 County of Tulare 74/ 1 10.46 1 San Juan WD Shafter Wasco ID

Total Project 215 Contractors 363 3,796.98 363 

Special Supplemental 215 Water Revenues

City of LindsayCity of Orange CoveShafter Wasco ID

Total Supplemental 215 Contractor

Rescheduled Water

Del Puerto WD Santa Clara Valley WD 75/ 1,833 10,833.03 1,833 

Total Rescheduled Water 1,833 10,833.03 1,833 

Warren Act Contractors

Delta Lands Recl. Dist. No. 770 76/ (1,191) (12,457.86) (1,191) Dos Palos Pwr Auth (CCID) 77/ 7 126.91 7 

El Dorado ID (Folsom D&R) 78/ 600 9,450.00 600 Madera ID 79/ (1) (10.46) (1) Sacramento Suburban WD 80/ 4,104 64,581.44 4,104 San Juan WD 81/ 3,131 38,037.61 3,131 

Total Warren Act Contractors 6,650 99,727.64 6,650 

Non-Project Water Contractors

Contra Costa WD 82/ (1,620) (11,609.65) (1,620) 

Grand Totals 98,875 4,317,842.68 (23) (337.72) 39,716.01 98,852 

9/18/2007
M&I 2006 Sch B-2 F (CY ADJ).Z10.xls

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2006 M&I REVENUES

2008 M&I WATER RATES

(CURRENT YEAR ADJUSTMENT)

Adjustment details

Adjustment

Contractor A/F Rate Period Amount

Black Butte D & R

1/ County of Colusa2/ Elk Creek CSD3/ US Forest Service - BB 15.12 09/06 30.24 2

 15.12 09/06 15.12 1

3 45.36

4/ Whitney Const. 15.00 02/06 (375.00) (25)

Clear Creek Unit

5/ Clear Creek CSD 32.15 10/05 7,008.70 218

 38.02 09/06 (1,939.02) (51)

167 5,069.68

Contra Costa Canal

6/ Contra Costa WD 16.75 06/06 (19,262.50) (1,150)

 16.75 07/06 4,489.00 268 16.75 08/06 14,790.25 883

1 16.75

Cow Creek Unit

7/ Bella Vista WD 34.01 09/06 2,516.74 74

Cross Valley Canal

8/ County of Fresno9/ County of Tulare

Delta-Mendota Canal

10/ Byron Bethany ID 19.90 09/06 79.60 4

 19.90 09/06 (59.70) (3)

1 19.90

11/ City of Tracy 23.74 09/06 (7,691.76) (324)12/ Del Puerto WD 19.11 09/06 19.11 1

 18.64 02/06 37.28 2

 56.39 3

13/ Department of VA 43.20 09/06 (43.20) (1)14/ Panoche WD - DMC 20.25 04/06 40.50 215/ San Luis WD - DMC 15.00 09/06 30.00 2

Schedule Pg 5 of 12

9/18/2007
M&I 2006 Sch B-2 F (CY ADJ).Z10.xls Schedule 

9/18/2007 Pg 6 of 12

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2006 M&I REVENUES

2008 M&I WATER RATES

(CURRENT YEAR ADJUSTMENT)

Adjustment details

Adjustment

Contractor A/F Rate Period Amount

16/ City of Roseville 9.00 01/06 12,789.00 1,421

 9.00 02/06 13,014.00 1,446

 9.00 09/06 (35,361.00) (3,929)

 9.00 09/06 35,361.00 3,929

 9.00 09/06 35,361.00 3,929

6,796 61,164.00

17/ El Dorado ID - FD&R 15.00 01/06 3,555.00 237

 15.00 02/06 2,325.00 155 15.00 08/06 14,865.00 991 15.00 09/06 14,865.00 991

2,374 35,610.00

18/ Sacramento County WA 15.48 01/06 4,922.64 318

 15.48 02/06 6,470.64 418 21.44 04/06 8,683.20 405 21.44 09/06 7,696.96 359 21.44 08/06 8,726.08 407

1,907 36,499.52

19/ San Juan WD 19.03 09/06 (18,097.53) (951)

 19.03 09/06 18,097.53 951 19.03 09/06 18,097.53 951

951 18,097.53

Folsom-South Canal

20/ East Bay MUD21/ Sacramento MUD 12.81 01/06 550.83 43

 12.81 02/06 397.11 31

 12.81 09/06 2,549.19 199 12.81 08/06 2,946.30 230

503 6,443.43

SMUD Transportation Rate 7.27 01/06 312.61 43

 7.27 02/06 225.37 31

 7.27 09/06 1,446.73 199 7.27 08/06 1,672.10 230

503 3,656.81

Friant Dam

22/ County of Madera 25.28 09/06 (25.28) (1)23/ Fresno County WW #18 15.00 03/06 (30.00) (2)

 15.00 03/06 15.00 1

 15.00 09/06 15.00 1

-
M&I 2006 Sch B-2 F (CY ADJ).Z10.xls

9/18/2007

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2006 M&I REVENUES

2008 M&I WATER RATES

(CURRENT YEAR ADJUSTMENT)

Adjustment details

Adjustment

Contractor A/F Rate Period Amount

Friant-Kern Canal

24/ Arvin Edison WSD25/ City of Fresno 85.83 10/05 (6,351.42) (74)

 85.83 11/05 (2,918.22) (34)

 85.83 12/05 (1,115.79) (13)

 56.84 10/05 4,206.16 74

 56.84 11/05 1,932.56 34

 56.84 12/05 738.92 13

 85.83 10/05 2,918.22 34

 85.83 11/05 1,716.60 20 85.83 12/05 343.32 4

 56.84 09/06 (3,751.44) (66)

(8) (2,281.09)

26/ City of Lindsay 24.04 10/05 1,586.64 66

 23.82 09/06 (309.66) (13)

53 1,276.98

27/ City of Orange Cove 17.11 05/06 (3,422.00) (200)

 17.11 06/06 (4,311.72) (252) 17.11 09/06 (615.96) (36)

(488) (8,349.68)

28/ Delano-Earlimart ID 22.41 02/06 156.87 7

 22.16 09/06 398.88 18

25 555.75

29/ Lindsay-Strathmore ID 15.16 05/06 379.00 25

 15.16 05/06 363.84 24

 15.16 09/06 697.36 46

95 1,440.20

30/ Shafter-Wasco ID 22.62 09/06 2,420.34 10731/ Terra Bella ID 34.50 09/06 6,106.50 177

Sacramento River

32/ City of Redding - SR 15.00 09/06 (1,725.00) (115)33/ City of West Sacramento 15.00 12/05 3,150.00 210

 15.00 09/06 1,530.00 102

312 4,680.00

34/ Lake California P.O.A.35/ Meyer Crest Ltd. 15.00 03/06 3,450.00 230

 15.00 09/06 (3,450.00) (230)

-

36/ Riverview Golf & CC

Schedule Pg 7 of 12
M&I 2006 Sch B-2 F (CY ADJ).Z10.xls Schedule 

9/18/2007 Pg 8 of 12

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2006 M&I REVENUES

2008 M&I WATER RATES

(CURRENT YEAR ADJUSTMENT)

Adjustment details

Adjustment

Contractor A/F Rate Period Amount

San Felipe Unit

37/ SB County WD - IB 36.13 01/06 12,211.94 338

 37.08 09/06 (407.88) (11)

3-9/06 6,455.76

327 18,259.82

38/ SC Valley WD - IB 45.71 10/05 623,210.14 13,634

 45.71 12/05 (37,847.88) (828) 41.15 09/06 (152,584.20) (3,708) 45.37 08/06 1,523,207.01 33,573

4-9/06 (129,410.52)

42,671 1,826,574.55

San Luis Canal - Fresno

39/ City of Avenal 14.41 09/06 158.51 1140/ City of Coalinga 17.63 09/06 1,710.11 9741/ City of Huron 15.00 09/06 45.00 342/ State of CA 35.46 10/05 35.46 1

 35.46 11/05 35.46 1

2 70.92

43/ Westlands WD 20.56 06/06 616.80 30

 20.56 09/06 (1,973.76) (96)

(66) (1,356.96)

San Luis Canal - Tracy

44/ Broadview WD 27.22 12/05 27.22 1

 20.70 04/06 20.70 1

 20.70 09/06 41.40 2

4 89.32

45/ Pacheco WD - SLC46/ Panoche WD - SLC 35.34 10/05 141.36 4

 35.34 01/06 106.02 3

 27.54 09/06 110.16 4

11 357.54

47/ San Luis WD - SLC 23.47 09/06 1,736.78 74

Shasta Dam

48/ Centerville CSD 19.15 11/05 1,455.40 76

 21.60 03/06 (21.60) (1)

 21.60 09/06 475.20 22

97 1,909.00

49/ Mountain Gate CSD 17.47 08/06 419.28 24
M&I 2006 Sch B-2 F (CY ADJ).Z10.xls

9/18/2007

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2006 M&I REVENUES

2008 M&I WATER RATES

(CURRENT YEAR ADJUSTMENT)

Adjustment details

Adjustment

Contractor A/F Rate Period Amount

50/ Shasta CWA 24.25 10/05 (291.00) (12)

 20.79 07/06 1,018.71 49

 20.79 08/06 1,018.71 49

 20.79 09/06 (62.37) (3)

 20.79 05/06 1,039.50 50

 20.79 07/06 20.79 1

134 2,744.34

Spring Creek Conduit

51/ City of Redding - SCC 15.52 08/06 2,886.72 18652/ Shasta CWA - SCC 20.82 10/05 (41.64) (2)

5.58 03/06 50.22

 20.82 10/05 291.48 14

 20.82 11/05 166.56 8

 20.82 12/05 166.56 8

 20.82 01/06 187.38 9

 20.82 02/06 166.56 8

5.58 04/06 55.80

 22.31 09/06 (89.24) (4)

41 953.68

53/ Shasta CSD 16.73 08/06 (184.03) (11)

Tehama-Colusa Canal

54/ Colusa County WD 22.57 04/06 (67.71) (3)

 22.57 09/06 45.14 2

(1) (22.57)

55/ Kanawha WD 34.97 09/06 34.97 1

Toyon Pipeline

56/ City of Redding - TP 15.00 09/06 (75.00) (5)57/ City of Shasta Lake 21.59 09/06 237.49 11

 21.59 05/06 (1,079.50) (50)

 (842.01) (39)

58/ US Forest Service - TP 15.00 09/06 150.00 10

San Felipe Out-Of-Basin Facilities

59/ SB County WD - OB 43.00 01/06 14,534.00 338

 43.00 09/06 (473.00) (11)

327 14,061.00

60/ SC Valley WD - OB 43.00 10/05 586,262.00 13,634

 43.00 12/05 (35,604.00) (828) 43.00 09/06 (159,444.00) (3,708) 43.00 08/06 1,443,639.00 33,573

42,671 1,834,853.00

Schedule Pg 9 of 12
M&I 2006 Sch B-2 F (CY ADJ).Z10.xls Schedule 

9/18/2007 Pg 10 of 1

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2006 M&I REVENUES

2008 M&I WATER RATES

(CURRENT YEAR ADJUSTMENT)

Adjustment details

Adjustment

Contractor A/F Rate Period Amount

Non-Permanent Contractors

61/ City of Sacramento 9.00 01/06 16,443.00 1,827

 9.00 03/06 18,513.00 2,057

 9.00 02/06 21,249.00 2,361

 9.00 04/06 25,695.00 2,855

 9.00 08/06 54,873.00 6,097

 9.00 05/06 58,851.00 6,539

 9.00 06/06 67,995.00 7,555

 9.00 07/06 73,881.00 8,209

 9.00 08/06 15,939.00 1,771

 9.00 08/06 (54,873.00) (6,097)

33,174 298,566.00

62/ Corning WD 52.66 09/06 421.28 863/ Dunnigan WD 30.58 09/06 (917.40) (30)64/ Fresno ID 13.56 06/06 827.16 61

 13.56 06/06 67.80 5

 13.56 06/06 54.24 4

70 949.20

65/ Garfield WD 25.59 09/06 358.26 1466/ Lindmore ID 25.59 09/06 25.59 167/ Orange Cove ID 25.59 09/06 358.26 1468/ Orland-Artois WD 35.75 09/06 (1,859.00) (52)

 35.75 09/06 357.50 10

 (1,501.50) (42)

69/ SMUD w/o Delta 7.27 01/06 9,014.80 1,240

 7.27 02/06 9,014.80 1,240

 7.27 08/06 9,014.80 1,240

 7.27 09/06 9,014.80 1,240

4,960 36,059.20

70/ Stockton-East WD 20.26 11/05 2,188.08 108

 17.65 04/06 5,930.40 336 17.65 05/06 10,960.65 621

 17.65 04/06 (5,930.40) (336)

 17.65 05/06 (10,960.65) (621)

 12.80 05/06 (8,076.80) (631)

 20.26 12/05 54,114.46 2,671

 20.26 12/05 1,823.40 90

2,238 50,049.14
M&I 2006 Sch B-2 F (CY ADJ).Z10.xls

9/18/2007

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2006 M&I REVENUES

2008 M&I WATER RATES

(CURRENT YEAR ADJUSTMENT)

Adjustment details

Adjustment

Contractor A/F Rate Period Amount

71/ Stony Creek WD 20.26 10/05 101.30 5

 20.26 11/05 81.04 4

 17.65 08/06 35.30 2

 17.65 08/06 35.30 2

 17.65 07/06 70.60 4

 17.65 07/06 88.25 5

 17.65 05/06 (70.60) (4)

 17.65 06/06 (88.25) (5)

 17.65 08/06 35.30 2

 17.65 08/06 35.30 2

 17.65 17.65 1

18 341.19

72/ Tea Pot Dome WD 25.59 09/06 (25.59) (1)

Non-Storable Project 215 Contractors

73/ City of Orange Cove 10.46 05/06 1,150.60 110

 10.46 06/06 2,635.92 252

362 3,786.52

74/ County of Tulare 10.46 03/06 10.46 1

Rescheduled Water

75/ Santa Clara Valley WD 5.91 01/06 10,833.03 1,833

Warren Act Contractors

76/ Delta Lands Recl. Dist. No. 770 10.46 05/06 (12,457.86) (1,191)77/ Dos Palos Pwr Auth (CCID) 18.13 09/06 (1,269.10) (70)

 18.13 09/06 1,396.01 77

7 126.91

78/ El Dorado ID (Folsom D&R) 15.75 04/06 3,291.75 209

 15.75 09/06 2,772.00 176 15.75 08/06 3,386.25 215

600 9,450.00

79/ Madera ID 2 10.46 03/06 20.92

-1 10.46 03/06 (10.46)

 10.46 04/06 (10.46) (1)

-1 10.46 03/06 (10.46)

(1) (10.46)

80/ Sacramento Suburban WD 704 15.71 01/06 11,059.84

710 15.71 02/06 11,154.10680 15.75 03/06 10,710.00

 15.75 09/06 (31,657.50) (2,010)

 15.75 09/06 31,657.50 2,010

 15.75 09/06 31,657.50 2,010

4,104 64,581.44

Schedule Pg 11 of 1
M&I 2006 Sch B-2 F (CY ADJ).Z10.xls Schedule 

9/18/2007 Pg 12 of 1

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2006 M&I REVENUES

2008 M&I WATER RATES

(CURRENT YEAR ADJUSTMENT)

Adjustment details

Adjustment

Contractor A/F Rate Period Amount

81/ San Juan WD 11.17 10/05 12,041.26 1,078

 11.17 01/06 3,094.09 277 11.17 02/06 2,893.03 259

 13.19 09/06 (20,009.23) (1,517)

 13.19 09/06 20,009.23 1,517

 13.19 09/06 20,009.23 1,517

3,131 38,037.61

Non-Project Water Contractors

82/ Contra Costa WD 8.31 08/06 (7,337.73) (883)

 8.31 07/06 (2,227.08) (268)

 4.36 09/06 (2,044.84) (469)

(1,620) (11,609.65)

Subtotal 147,313 4,357,220.97Less:Sacramento MUD - Transportation 503Sacramento MUD w/o Delta 4,960San Benito County WD - O/B 327Santa Clara Valley WD - O/B 42,671

 - 48,461

Grand Total 4,357,220.97 98,852