M&I 2012 Sch B-5 F.Z16.XLSM

08/15/2013

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2012 ALLOCATED M&I STORAGE EXPENSE

A B CD 

Ratio of A/F by 2012 Storage Total A/F 

Facility/Contractor Contractor Expense

Ref <Sch B-2> (B/(total a/f)) <Sch B-6> 

Black Butte D & R

County of Colusa 8 0.000021 $ 3,027,718.97 

Elk Creek CSD - - $ 3,027,718.97 

US Forest Service - BB 20 0.000053 $ 3,027,718.97 

Whitney Const. 25 0.000066 $ 3,027,718.97 

Total BB D & R 53 0.000139 

Clear Creek Unit

Clear Creek CSD 2,220 0.005839 $ 3,027,718.97 

Contra Costa Canal

Contra Costa WD 145,714 0.383282 $ 3,027,718.97 

Cow Creek Unit

Bella Vista WD 5,323 0.014001 $ 3,027,718.97 

Cross Valley Canal

County of Fresno - - $ 3,027,718.97 

County of Tulare - - $ 3,027,718.97 

Total CV Canal - - 

Delta-Mendota Canal

Byron Bethany ID 915 0.002407 $ 3,027,718.97 

City of Tracy 10,836 0.028503 $ 3,027,718.97 

Del Puerto WD 19 0.000050 $ 3,027,718.97 

Department of VA 273 0.000718 $ 3,027,718.97 

Panoche WD - DMC 22 0.000058 $ 3,027,718.97 San Luis WD - DMC 104 0.000274 $ 3,027,718.97 

Total DM Canal 12,169 0.032009 
CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2012 ALLOCATED M&I STORAGE EXPENSE

A B CD 

Ratio of A/F by 2012 Storage Total A/F 

Facility/Contractor Contractor Expense

Ref <Sch B-2> (B/(total a/f)) <Sch B-6> 

Folsom D & R

City of Roseville 33,290 0.087565 $ 3,027,718.97 

El Dorado ID - FD&R 5,799 0.015254 $ 3,027,718.97 

Placer County WD 85 0.000224 $ 3,027,718.97 

Sacramento County WA 1,200 0.003156 $ 3,027,718.97 San Juan WD 2,815 0.007405 $ 3,027,718.97 

Total Folsom D & R 43,189 0.113603 

Folsom-South Canal

East Bay MUD - - $ 3,027,718.97 

Sacramento County WA - FSC - - $ 3,027,718.97 

Sacramento MUD 29,484 0.077554 $ 3,027,718.97 

Total FS Canal 29,484 0.077554 

Friant Dam

County of Madera 22 0.000058 $ 3,027,718.97 

Fresno County WW #18 136 0.000358 $ 3,027,718.97 

Total Friant Dam 158 0.000416 

Friant-Kern Canal

Arvin-Edison WSD 567 0.001491 $ 3,027,718.97 

City of Fresno 47,663 0.125372 $ 3,027,718.97 

City of Lindsay 1,586 0.004172 $ 3,027,718.97 

City of Orange Cove 1,123 0.002954 $ 3,027,718.97 

Delano-Earlimart ID 272 0.000715 $ 3,027,718.97 Lindsay-Strathmore ID 444 0.001168 $ 3,027,718.97 

Shafter-Wasco ID 687 0.001807 $ 3,027,718.97 

Terra Bella ID 1,462 0.003846 $ 3,027,718.97 

Total FK Canal 53,804 0.141525 

New Melones D & R

Stockton East WD 51,934 0.136606 $ 3,027,718.97 
CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2012 ALLOCATED M&I STORAGE EXPENSE

A B CD 

Ratio of A/F by 2012 Storage Total A/F 

Facility/Contractor Contractor Expense

Ref <Sch B-2> (B/(total a/f)) <Sch B-6> 

Sacramento River

City of Redding - SR 2,403 0.006321 $ 3,027,718.97 

City of West Sacramento 9,106 0.023952 $ 3,027,718.97 Lake California P.O.A. 200 0.000526 $ 3,027,718.97 

Meyer Crest Ltd. 230 0.000605 $ 3,027,718.97 

Riverview Golf & CC 25 0.000066 $ 3,027,718.97 

Total Sacramento River 11,964 0.031470 

San Luis Canal - Fresno

City of Avenal 2,519 0.006626 $ 3,027,718.97 

City of Coalinga 5,924 0.015582 $ 3,027,718.97 

City of Huron 1,152 0.003030 $ 3,027,718.97 

State of CA 15 0.000039 $ 3,027,718.97 

Westlands WD 2,608 0.006860 $ 3,027,718.97 

Total SLC - Fresno 12,218 0.032138 

San Luis Canal - Tracy

Pacheco WD - SLC 12 0.000032 $ 3,027,718.97 

Panoche WD - SLC 45 0.000118 $ 3,027,718.97 

San Luis WD - SLC 590 0.001552 $ 3,027,718.97 

Total SLC - Tracy 647 0.001702 

Shasta Dam

Centerville CSD 853 0.002244 $ 3,027,718.97 

Mountain Gate CSD 773 0.002033 $ 3,027,718.97 

Shasta CWA 200 0.000526 $ 3,027,718.97 

Total Shasta Dam 1,826 0.004803 

Spring Creek Conduit

City of Redding - SCC 7,112 0.018707 $ 3,027,718.97 

Shasta CWA - SCC 183 0.000481 $ 3,027,718.97 Shasta CSD 615 0.001618 $ 3,027,718.97 

Total SC Conduit 7,910 0.020806 
CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2012 ALLOCATED M&I STORAGE EXPENSE

A B CD

Ratio of A/F by 2012 Storage Total A/F 

Facility/Contractor Contractor Expense

Ref <Sch B-2> (B/(total a/f)) <Sch B-6> 

Tehama-Colusa Canal

Colusa County WD 161 0.000423 $ 3,027,718.97 

Kanawha WD 4 0.000011 $ 3,027,718.97 

Total Tehama-Colusa Canal 165 0.000434 

Toyon Pipeline

City of Redding - TP 19 0.000050 $ 3,027,718.97 

City of Shasta Lake 1,409 0.003706 $ 3,027,718.97 

US Forest Service - TP (32) (0.000084) $ 3,027,718.97 

Total Toyon Pipeline 1,396 0.003672 Total AF/Cost without San Felipe Unit 380,174 1.000000 

San Felipe Unit 1/

SB County WD - IB 2,060 0.021303 $ 594,510.89 

SC Valley WD - IB 94,639 0.978697 $ 594,510.89 

Total San Felipe Unit 96,699 1.000000 GRAND TOTAL 476,873 

FOOTNOTES

1/ San Felipe Unit Contractors do not receive a Gianelli PGP regeneration credit therefore its allocated separately.

Total Storage cost per sch B-5 $ 3,622,229.86

 XO&M portion of Storage Cost See (B-1C) $ 387,647.44

Total Storage cost $ 4,009,877.30 *

* This amount agrees to storage cost component of Sch B-6.