M&I 2006 Sch B-1A F.Z10.XLS

9/18/2007

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2006 M&I REVENUES AND ALLOCATED O&M EXPENSES (INCLUDES CFO & PFR ADJUSTMENTS)

BY PERMANENT CONTRACTOR

2008 M& I WATER RATES

Total O&M Expenses Operating Results 

Water Water Conveyance Direct Surplus of 

Facility/Contractor Revenues Marketing Storage Conveyance Pumping Costs Total (DEFICIT) Interest Operations 

Black Butte D & R

County of Colusa 2.25 (2.25) Elk Creek CSD 135.00 46.90 110.93 157.84 (22.84) 15.88 (38.72) US Forest Service - BB 263.16 40.65 96.14 136.79 126.37 71.03 55.34 Whitney Const Inc. 3.23 (3.23) 

Total BB D & R 398.16 87.55 207.08 294.63 103.53 92.39 11.14 

Clear Creek Unit

Clear Creek CSD 77,564.81 6,625.92 15,671.30 22,297.22 55,267.59 39,766.98 15,500.61 

Contra Costa Canal

Contra Costa WD 1,523,812.59 265,277.44 627,421.49 347,910.06 1,240,609.00 283,203.59 283,203.59 

Cow Creek Unit

Bella Vista WD 9,494.14 684.79 1,619.64 1,964.88 4,269.31 5,224.83 23,978.38 (18,753.55) 

Cross Valley Canal

County of Fresno 1,966.00 (1,966.00) County of Tulare 6,262.22 (6,262.22) 

Total CV Canal 8,228.22 (8,228.22) 

Delta-Mendota Canal

Byron Bethany ID 16,745.32 2,770.44 6,552.51 9,322.95 7,422.37 2,417.63 5,004.74 City of Tracy 151,959.74 20,015.33 47,339.31 67,354.64 84,605.10 64,958.51 19,646.59 Del Puerto WD 800.35 125.08 295.82 420.90 379.45 45.17 334.28 Department of VA 3,130.64 234.52 554.67 789.19 2,341.45 2,344.00 (2.55) Panoche WD - DMC 617.24 87.55 207.08 294.63 322.61 91.04 231.57 San Luis WD - DMC 3,345.00 697.30 1,649.22 2,346.52 998.48 998.48 

Total DM Canal 176,598.29 23,930.22 56,598.61 80,528.84 96,069.45 69,856.36 26,213.10 

Folsom D & R

City of Roseville 331,866.00 115,301.58 272,705.78 388,007.36 (56,141.36) 6,348.38 (62,489.74) El Dorado ID - FD&R 60,525.00 12,617.07 29,841.29 42,458.36 18,066.64 674.22 17,392.42 Sacramento County WA 97,407.52 15,906.58 37,621.48 53,528.05 43,879.47 32,342.91 11,536.55 San Juan WD 135,526.72 22,326.12 52,804.67 75,130.79 60,395.93 6,150.38 54,245.56 

Total Folsom D & R 625,325.24 166,151.35 392,973.21 559,124.57 66,200.67 45,515.89 20,684.78 

Folsom-South Canal

East Bay MUD 450,792.93 (450,792.93) Sacramento MUD 753,889.00 179,659.59 424,922.26 917,939.72 1,522,521.57 (768,632.57) 546,466.90 (1,315,099.47) 

Total FS Canal 753,889.00 179,659.59 424,922.26 917,939.72 1,522,521.57 (768,632.57) 997,259.83 (1,765,892.40) 
M&I 2006 Sch B-1A F.Z10.XLS 

9/18/2007 

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2006 M&I REVENUES AND ALLOCATED O&M EXPENSES (INCLUDES CFO & PFR ADJUSTMENTS)

BY PERMANENT CONTRACTOR

2008 M& I WATER RATES

Total O&M Expenses Operating Results 

Water Water Conveyance Direct Surplus of 

Facility/Contractor Revenues Marketing Storage Conveyance Pumping Costs Total (DEFICIT) Interest Operations 

Friant Dam

County of Madera 990.28 128.20 303.22 431.42 558.86 430.49 128.37 Fresno County WW #18 2,115.00 440.89 1,042.78 1,483.68 631.32 631.32 

Total Friant Dam 3,105.28 569.10 1,346.00 1,915.10 1,190.18 430.49 759.69 

Friant-Kern Canal

Arvin-Edison WSD 697.39 (697.39) City of Fresno 3,107,589.54 170,863.60 404,118.40 574,982.00 2,532,607.54 1,325,109.36 1,207,498.18 City of Lindsay 28,498.10 3,724.15 8,808.17 12,532.32 15,965.78 6,277.73 9,688.05 City of Orange Cove 9,607.32 1,466.52 3,468.54 4,935.06 4,672.26 4,145.82 526.44 Delano-Earlimart ID 4,376.52 616.00 1,456.94 2,072.94 2,303.58 610.27 1,693.32 Lindsay-Strathmore ID 4,851.20 1,000.61 2,366.60 3,367.21 1,483.99 276.12 1,207.87 Shafter-Wasco ID 8,561.37 1,175.72 2,780.75 3,956.47 4,604.90 1,641.38 2,963.53 Terra Bella ID 38,636.80 4,055.60 9,592.11 13,647.71 24,989.09 5,701.00 19,288.09 

Total FK Canal 3,202,120.85 182,902.19 432,591.51 615,493.70 2,586,627.15 1,344,459.07 1,242,168.08 

Sacramento River

City of Redding - SR 41,595.00 8,670.91 20,508.03 29,178.94 12,416.06 12,416.06 City of West Sacramento 48,710.01 13,845.95 32,747.77 46,593.71 2,116.30 104.92 2,011.37 Lake California P.O.A. 3,000.00 625.38 1,479.12 2,104.50 895.50 895.50 Meyer Crest Ltd. 3,450.00 719.19 1,700.99 2,420.18 1,029.82 99.90 929.92 Riverview Golf & CC 375.00 78.17 184.89 263.06 111.94 111.94 

Total Sacramento River 97,130.01 23,939.60 56,620.80 80,560.41 16,569.60 204.82 16,364.78 

San Felipe Unit

SB County WD - IB 143,654.97 12,254.35 23,157.99 33,794.28 69,206.62 74,448.35 28,044.92 46,403.43 SC Valley WD - IB 4,081,032.90 288,363.40 544,941.01 1,218,067.59 2,051,372.01 2,029,660.89 625,552.30 1,404,108.60 

Total SF Unit 4,224,687.87 300,617.75 568,099.00 1,251,861.87 2,120,578.63 2,104,109.24 653,597.21 1,450,512.03 

San Luis Canal - Fresno

City of Avenal 39,974.13 8,958.59 21,188.43 30,147.02 9,827.11 38,003.61 (28,176.49) City of Coalinga 131,353.64 23,923.97 56,583.82 36,973.36 117,481.15 13,872.49 110,980.92 (97,108.43) City of Huron 17,109.60 3,664.74 8,667.66 12,332.39 4,777.21 37,824.90 (33,047.69) State of CA 390.06 34.40 81.35 115.75 274.31 9.62 264.70 Westlands WD 60,386.57 8,054.91 19,051.10 4,718.43 31,824.44 28,562.13 11,459.18 17,102.95 

Total SLC - Fresno 249,214.00 44,636.60 105,572.35 41,691.79 191,900.75 57,313.25 198,278.22 (140,964.97) 
M&I 2006 Sch B-1A F.Z10.XLS

9/18/2007

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2006 M&I REVENUES AND ALLOCATED O&M EXPENSES (INCLUDES CFO & PFR ADJUSTMENTS)

BY PERMANENT CONTRACTOR

2008 M& I WATER RATES

Total O&M Expenses Operating Results 

Water Water Conveyance Direct Surplus of 

Facility/Contractor Revenues Marketing Storage Conveyance Pumping Costs Total (DEFICIT) Interest Operations 

San Luis Canal - Tracy

Broadview WD 598.02 84.43 199.68 284.11 313.91 32.52 281.39 Pacheco WD - SLC 693.28 43.78 103.54 147.32 545.96 431.79 114.17 Panoche WD - SLC 1,635.36 168.85 399.36 568.22 1,067.14 214.53 852.61 San Luis WD - SLC 41,698.23 4,155.66 9,828.77 7,012.87 20,997.30 20,700.93 610.09 20,090.85 

Total SLC - Tracy 44,624.89 4,452.72 10,531.35 7,012.87 21,996.94 22,627.95 1,288.93 21,339.02 

Shasta Dam

Centerville CSD 19,582.75 2,979.94 7,048.02 10,027.96 9,554.79 4,970.02 4,584.77 Mountain Gate CSD 16,446.11 3,061.24 7,240.30 10,301.55 6,144.56 949.81 5,194.76 Shasta CWA 5,138.59 772.35 1,826.72 2,599.06 2,539.53 642.22 1,897.31 

Total Shasta Dam 41,167.45 6,813.53 16,115.04 22,928.57 18,238.88 6,562.05 11,676.84 

Spring Creek Conduit

City of Redding - SCC 70,226.24 14,236.81 33,672.22 47,909.03 22,317.21 4,007.33 18,309.88 Shasta CWA - SCC 3,792.58 540.95 1,279.44 1,820.40 1,972.18 686.04 1,286.14 Shasta CSD 13,923.89 2,617.22 6,190.13 8,807.35 5,116.54 367.49 4,749.05 

Total SC Conduit 87,942.71 17,394.99 41,141.79 58,536.77 29,405.94 5,060.87 24,345.07 

Tehama-Colusa Canal

Colusa County WD 5,510.73 759.84 1,797.13 1,059.26 3,616.23 1,894.50 275.04 1,619.45 Kanawha WD 139.88 12.51 29.58 1.38 43.47 96.41 71.48 24.93 

Total TC Canal 5,650.61 772.35 1,826.72 1,060.64 3,659.70 1,990.91 346.53 1,644.38 

Toyon Pipeline

City of Redding - TP 375.00 78.17 184.89 263.06 111.94 111.94 City of Shasta Lake 63,660.58 9,527.69 22,534.43 22,485.19 54,547.31 9,113.27 5,491.85 3,621.43 US Forest Service - TP 150.00 31.27 73.96 105.23 44.77 44.77 

Total Toyon Pipeline 64,185.58 9,637.13 22,793.27 22,485.19 54,915.59 9,269.99 5,491.85 3,778.14 

San Felipe Out-Of-Basin Facilities

SB County WD - OB 168,517.00 168,517.00 519,208.69 (350,691.69) SC Valley WD - OB 3,965,460.00 3,965,460.00 11,382,066.77 (7,416,606.77) 

Total SF Unit 4,133,977.00 4,133,977.00 11,901,275.47 (7,767,298.47) 

Grand Total 15,320,888.48 1,234,152.83 2,776,051.42 917,939.72 1,673,987.30 6,602,131.28 8,718,757.20 15,301,693.54 (6,582,936.35) 

1/ For contractor that chose option 2, costs have been deferred over a 5-year period beginning in FY 2003. See 2006 M&I Application of CFO & PFR Audit Adj Analysis.Z10

Note: "Total" amounts may vary slightly from those shown on supporting schedules due to rounding.