M&I 2002 Sch B-1A F.Z06.XLS

09/25/2003

CENTRAL VALLEY PROJECT

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

BY PERMANENT CONTRACTOR

2004 M& I WATER RATES

Total O&M Expenses Operating Results 

Water Water Conveyance Direct Surplus of Expense 

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

1/ 2/ 

Black Butte D & R

County of Colusa 847.12 127.38 305.11 432.50 414.62 226.10 188.52 Elk Creek CSD 135.00 41.54 99.49 141.03 (6.03) (20.00) 13.97 Whitney Const Inc. 225.00 69.23 165.82 235.05 (10.05) 73.75 (83.80) 

Total BB D & R 1,207.12 238.15 570.43 808.59 398.53 279.84 118.69 

Clear Creek Unit

Clear Creek CSD 65,594.66 4,286.76 10,267.78 14,554.53 51,040.13 178,774.14 (127,734.01) 

Contra Costa Canal

Contra Costa WD 2,909,797.96 228,909.43 548,291.46 413,074.52 1,190,275.40 1,719,522.56 2,740,350.34 (1,020,827.78) 

Cow Creek Unit

Bella Vista WD 380,002.34 17,418.41 41,721.14 19,073.00 78,212.55 301,789.79 235,965.94 65,823.85 

Cross Valley Canal

County of Fresno 25,113.60 1,993.84 4,775.71 328.76 7,098.32 18,015.28 8,376.16 9,639.12 County of Tulare 722.18 722.18 (722.18) 43,664.93 (44,387.11) 

Total CV Canal 25,113.60 1,993.84 4,775.71 1,050.95 7,820.50 17,293.10 52,041.09 (34,747.99) 

Delta-Mendota Canal

City of Tracy 241,648.80 20,846.70 49,932.71 2,538.20 73,317.62 168,331.18 133,733.69 34,597.49 Del Puerto WD 428.03 41.54 99.49 4.48 145.51 282.52 90.29 192.23 (132.41) Department of VA 1,984.74 171.69 411.24 9.98 592.92 1,391.82 6,929.90 (5,538.08) 132.41 Panoche WD - DMC 1,137.52 85.85 205.62 10.33 301.80 835.72 682.95 152.78 Plain View WD 31,801.58 3,325.84 7,966.15 131.18 11,423.17 20,378.41 3,613.25 16,765.17 San Luis WD - DMC 1,879.50 362.77 868.91 44.42 (109.64) 1,166.46 713.04 (59.00) 772.04 

Total DM Canal 278,880.17 24,834.38 59,484.14 2,738.58 (109.64) 86,947.47 191,932.70 144,991.08 46,941.63 

Folsom D & R

City of Roseville 180,864.00 55,650.28 133,295.41 188,945.69 (8,081.69) 230,105.11 (238,186.81) El Dorado ID - FD&R 129,000.82 16,454.72 39,412.88 55,867.60 73,133.22 58,259.96 14,873.26 Sacramento County WA 75,118.80 11,940.89 28,601.20 40,542.09 34,576.71 71,839.24 (37,262.53) San Juan WD 115,455.65 19,592.25 46,928.00 66,520.24 48,935.41 40,822.52 8,112.88 

Total Folsom D & R 500,439.27 103,638.13 248,237.49 351,875.63 148,563.64 401,026.84 (252,463.19) 

Folsom-South Canal

East Bay MUD 3,861,899.11 (3,861,899.11) Sacramento MUD 427,533.92 91,309.56 218,707.68 437,687.80 747,705.04 (320,171.12) 2,080,046.16 (2,400,217.28) 

Total FS Canal 427,533.92 91,309.56 218,707.68 437,687.80 747,705.04 (320,171.12) 5,941,945.28 (6,262,116.39) 
M&I 2002 Sch B-1A F.Z06.XLS 

09/25/2003 

CENTRAL VALLEY PROJECT

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

BY PERMANENT CONTRACTOR

2004 M& I WATER RATES

Total O&M Expenses Operating Results 

Water Water Conveyance Direct Surplus of Expense 

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

1/ 2/ 

Friant Dam

County of Madera 3,988.16 429.23 1,028.10 1,457.33 2,530.83 2,008.29 522.53 Fresno County WW #18 2,385.00 440.31 1,054.64 1,494.94 890.06 (45.00) 935.06 

Total Friant Dam 6,373.16 869.54 2,082.74 2,952.28 3,420.88 1,963.29 1,457.59 

Friant-Kern Canal

Arvin-Edison WSD 179.73 179.73 (179.73) (5,872.00) 5,692.27 City of Fresno 590,620.00 163,555.79 391,754.25 7,579.14 562,889.18 27,730.82 3,931,216.88 (3,903,486.06) City of Lindsay 73,507.84 6,662.75 15,958.84 566.03 23,187.62 50,320.22 33,508.94 16,811.28 City of Orange Cove 72,422.04 4,098.45 9,816.74 691.02 14,606.20 57,815.84 (35,770.38) 93,586.22 Delano-Earlimart ID 4,716.82 501.23 1,200.56 1,701.79 3,015.03 1,544.73 1,470.30 Lindsay-Strathmore ID 16,232.00 1,536.92 3,681.28 89.52 5,307.71 10,924.29 2,105.74 8,818.54 Shafter-Wasco ID 8,249.52 780.92 1,870.49 117.06 2,768.47 5,481.05 6,394.01 (912.96) Terra Bella ID 17,772.45 1,725.23 4,132.32 327.09 6,184.63 11,587.82 17,957.56 (6,369.74) 

Total FK Canal 783,520.67 178,861.28 428,414.47 9,549.58 616,825.33 166,695.34 3,951,085.48 (3,784,390.14) 

Sacramento River

City of Redding - SR 12,931.81 1,775.07 4,251.71 6,026.78 6,905.03 25,057.66 (18,152.63) City of West Sacramento 66,941.64 9,670.12 23,162.20 32,832.32 34,109.32 46,214.35 (12,105.04) Diamond Lands Corp. 54.97 (54.97) Lake California P.O.A. 1,800.00 553.84 1,326.59 1,880.43 (80.43) 796.32 (876.76) Riverview Golf & CC 225.00 69.23 165.82 235.05 (10.05) 99.29 (109.35) 

Total Sacramento River 81,898.45 12,068.27 28,906.32 40,974.59 40,923.86 72,222.59 (31,298.73) 

San Felipe Unit

SB County WD - IB 81,437.02 6,241.83 10,130.39 754.37 12,640.16 29,766.74 51,670.28 107,648.60 (55,978.32) SC Valley WD - IB 5,224,790.13 316,530.38 513,723.99 25,175.43 1,769,053.77 2,624,483.56 2,600,306.57 2,679,231.07 (78,924.50) 

Total SF Unit 5,306,227.15 322,772.21 523,854.38 25,929.79 1,781,693.93 2,654,250.30 2,651,976.85 2,786,879.67 (134,902.82) 

San Luis Canal - Fresno

City of Avenal 23,732.27 7,022.75 16,821.12 726.82 24,570.69 (838.42) 192,945.12 (193,783.53) City of Coalinga 134,979.53 16,211.03 38,829.19 1,009.84 5,212.21 61,262.26 73,717.27 339,289.14 (265,571.87) City of Huron 68,101.73 5,134.14 12,297.46 301.95 17,733.55 50,368.18 151,962.24 (101,594.06) State of CA 690.08 52.62 126.03 178.64 511.44 165.33 346.11 Westlands WD 278,290.06 17,124.87 41,018.05 1,763.52 15,006.42 74,912.86 203,377.20 112,262.04 91,115.16 

Total SLC - Fresno 505,793.67 45,545.39 109,091.84 3,802.14 20,218.63 178,658.00 327,135.67 796,623.87 (469,488.20) 

San Luis Canal - Tracy

Broadview WD 1,006.43 72.00 172.46 1.03 245.49 760.94 312.67 448.27 Pacheco WD - SLC 1,283.99 52.62 126.03 4.13 182.77 1,101.22 78.58 1,022.63 Panoche WD - SLC 3,194.88 216.00 517.37 8.61 741.98 2,452.90 1,224.86 1,228.05 San Luis WD - SLC 38,178.70 1,650.46 3,953.23 148.74 (3.91) 5,748.51 32,430.19 10,568.46 21,861.74 

Total SLC - Tracy 43,664.00 1,991.07 4,769.08 162.51 (3.91) 6,918.75 36,745.25 12,184.57 24,560.69 
M&I 2002 Sch B-1A F.Z06.XLS

09/25/2003

CENTRAL VALLEY PROJECT

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

BY PERMANENT CONTRACTOR

2004 M& I WATER RATES

Total O&M Expenses Operating Results 

Water Water Conveyance Direct Surplus of Expense 

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

1/ 2/ 

Shasta Dam

Centerville CSD 30,822.18 2,999.07 7,183.47 10,182.53 20,639.65 24,394.01 (3,754.36) Mountain Gate CSD 3,150.00 969.23 2,321.53 3,290.75 (140.75) 1,486.19 (1,626.94) Shasta CWA 10,683.00 3,287.07 7,873.29 11,160.36 (477.36) 25,681.09 (26,158.45) 

Total Shasta Dam 44,655.18 7,255.36 17,378.28 24,633.64 20,021.54 51,561.28 (31,539.75) 

Sly Park

El Dorado ID - SP 296,640.00 54,764.13 54,764.13 241,875.87 23,117.30 218,758.57 

Spring Creek Conduit

City of Redding - SCC 85,966.47 16,438.10 39,373.09 55,811.19 30,155.28 25,222.90 4,932.38 Shasta County #25 1,638.00 504.00 1,207.19 1,711.19 (73.19) 3,130.11 (3,203.31) Shasta CSD 6,462.00 1,988.30 4,762.45 6,750.75 (288.75) 6,292.77 (6,581.52) 

Total SC Conduit 94,066.47 18,930.40 45,342.73 64,273.13 29,793.34 34,645.78 (4,852.44) 

Sugar Pine Reservoir

Foresthill PUD 91,800.00 2,990.76 2,990.76 88,809.24 88,809.24 

Tehama-Colusa Canal

Colusa County WD 6,394.35 612.00 1,465.88 2,077.88 4,316.47 1,368.75 2,947.72 

Toyon Pipeline

City of Redding - TP 744.00 127.38 305.11 15.15 447.65 296.35 (305.00) 601.35 City of Shasta Lake 55,344.18 7,213.82 17,278.79 24,492.61 30,851.57 (10,985.20) 41,836.77 US Forest Service 220.00 30.46 72.96 103.42 116.58 (2.18) 118.76 

Total Toyon Pipeline 56,308.18 7,371.67 17,656.87 15.15 25,043.68 31,264.50 (11,292.39) 42,556.88 

San Felipe Out-Of-Basin Facilities

SB County WD - OB 96,922.00 96,922.00 517,752.03 (420,830.03) SC Valley WD - OB 4,915,029.00 4,915,029.00 13,967,923.78 (9,052,894.78) 

Total SF Unit 5,011,951.00 5,011,951.00 14,485,675.82 (9,473,724.82) 

Grand Total 16,917,861.32 1,126,660.73 2,311,018.41 479,885.56 2,234,997.47 6,152,562.17 10,765,299.15 31,901,410.54 (21,136,111.40) 1/ Includes FY 1995 adjustment for Arroyo Pasejero. Ref; 2002 Sch B-1B2/ Ref: PFR M&I INT CHRG ADJ SUMMARY.XLS; Worksheet: ADJ SUMMARY 3/ Ref: PFR M&I INT CHRG ADJ SUMMARY.XLS; Worksheet: ADJ '024/ Ref 2003 M&I Water Rates, Sch A-6A.Z05

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

I:\wtrates\RATES\2004\M&I\[M&I 2002 Sch B-1A F.Z06.xls]OUTPUT