Cost Allocation Study Spreadsheet Appendix

150 Pages·2017·4.23 MB·English

Draft Central Valley Project
Final Cost Allocation Study
Cost Allocation Study Spreadsheet
Appendix

Bureau of Reclamation
Mid-Pacific Region January 2019
Mission Statements
The mission of the Department of the Interior is to protect and provide access to our
Nation’s natural and cultural heritage and honor our trust responsibilities to Indian
Tribes and our commitments to island communities.
The mission of the Bureau of Reclamation is to manage, develop, and protect water
and related resources in an environmentally and economically sound manner in the
interest of the American public.
Table of Contents
Page
Table 1. Total Separable and Allocated Joint Costs by Facility – Period 2 (2013 dollars) ........... 3  
Table 2. Cost Allocation Factors by Facility – Period 2 (2013 dollars) ...................................... 13  
Table 3. Separable and Remaining Joint Construction Costs by Facility – Period 2 (Unindexed)
....................................................................................................................................... 25 
Table 4. Separable and Remaining Joint IDC Costs by Facility – Period 2 (Unindexed) ........... 34 
Table 5. Separable and Remaining Joint OM&R Costs by Facility – Period 2 ........................... 43  
Table 6. Allocated Construction Costs across Authorized Purposes by Facility – Period 2
(Unindexed)...................................................................................................................52 
Table 7. Allocated IDC Costs across Authorized Purposes by Facility – Period 2 (Unindexed) 61  
Table 8. Allocated OM&R Costs across Authorized Purposes by Facility – Period 2 ................ 70  
Table 9. Water Supply Sub-allocation Factors ............................................................................ 80 
Table 10. Water Supply Construction Cost Sub-allocation by Facility – Period 2 (Unindexed) 81 
Table 11. Water Supply IDC Sub-allocation by Facility – Period 2 (Unindexed) ...................... 91  
Table 12. Water Supply OM&R Suballocation by Facility – Period 2 (Unindexed) ................ 101 
Table 13. Power Construction Cost Suballocation by Facility – Period 2 (Unindexed) ........... 112  
Table 14. Power IDC Suballocation by Facility – Period 2 (Unindexed) ................................. 121  
Table 15. Power OM&R Suballocation by Facility – Period 2 (Unindexed) ............................ 130  
Table 16. Summary of Reimbursable Costs and Cost Distributions – Period 2 (Unindexed) ... 139 
Table 17. Suballocation of Reimbursable Water Supply Construction Costs to CVPIA Functions
by Facility – Period 2 (Unindexed) ............................................................................. 140  
Table 18. Suballocation of Reimbursable Water Supply IDC Costs to CVPIA Functions by
Facility – Period 2 (Unindexed) .................................................................................. 149 
Table 19. Suballocation of Reimbursable Water Supply IDC Costs to CVPIA Functions by
Facility – Period 2 (Unindexed) .................................................................................. 158 
Table 20. Direct Assigned Cost Allocation by Facility – Period 2 (Unindexed) ...................... 167 
Table 21. Allocation of Reimbursable SOD Construction Costs by Facility – Period 2
(Unindexed)................................................................................................................. 176 

Cost Allocation Study Spreadsheet Appendix | iii
This page intentionally left blank.
iv | Draft Central Valley Project Final Cost Allocation Study
Appendix Summary
The tables in this appendix provide supporting data for the cost allocation spreadsheet described
in Chapter 10 of the Draft Central Valley Project Final Cost Allocation Study.

Cost Allocation Study Spreadsheet Appendix | 1
This page intentionally left blank.
2 | Draft Central Valley Project Final Cost Allocation Study
Table 1. Total Separable and Allocated Joint Costs by Facility – Period 2 (2013 dollars)
Total
Total Indexed Costs (construction,
(Construction, IDC, IDC, OM&R)
OM&R) for calculating Separable Remaining
Allocation Factors to Costs (2013 TS TS TS Joints –
Authorized Purposes dollars) = TSC TSC TSC C TSC C C Total = RJ RJ RJ RJ RJ RJ RJ
Remaining
No. Description of Facilities SCRB Total WS P FC FW R N WQ Joints WS P FC FW R N WQ
SCRB Total
Central Valley Project minus 0.000 0.000 0.000
(General) Separables 38.264% 10.247% 40.142% % % % 11.347%
Centralized Water & Power
1 System Control $73,679,004 $0 $0 $0 $0 $0 $0 $0 $73,679,004 $28,192,564 $7,549,954 $29,575,938 $0 $0 $0 $8,360,548
2 CVP Radio Network $6,599,327 $0 $0 $0 $0 $0 $0 $0 $6,599,327 $2,525,169 $676,239 $2,649,076 $0 $0 $0 $748,843
Los Banos Wfrowl Leased to
3 State of CA DFG $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Mendota Wfrowl Leased CA of
4 State of CA DFG $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Merced Natl Wlife Leased to
5 State of CA DFG $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
San Luis Waste Way Leased
6 CA of State of CA DFG $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
7 Telemetering Equipment $862,121 $0 $0 $0 $0 $0 $0 $0 $862,121 $329,882 $88,342 $346,069 $0 $0 $0 $97,827
American River Division:
Auburn/Folsom South Unit
American River Pumping
8 Station $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Folsom South Canal (16.4%
9 Portion) $26,172,703 $26,172,703 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Folsom South Canal -
10 Recreation Facilities $1,642,575 $0 $0 $0 $0 $1,642,575 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
11 No Hands Bridge $1,845,858 $0 $0 $0 $0 $1,845,858 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Permanent Operation Facilities
12 - Folsom South $223,310 $223,310 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
13 Union Hills Reservoir $100,400 $0 $0 $0 $0 $0 $0 $0 $100,400 $38,417 $10,288 $40,302 $0 $0 $0 $11,393
Folsom Unit
Carrier Current Equipment-
14 Folsom $160,811 $0 $160,811 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
15 Folsom Dam and Reservoir $657,309,519 $0 $0 $0 $0 $0 $0 $0 $657,309,519 $251,513,177 $67,355,098 $263,854,624 $0 $0 $0 $74,586,620
Folsom Dam Pumping Plant-
16 Enhancement $7,706,184 $7,706,184 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cost Allocation Study Spreadsheet Appendix | 3
Total
Total Indexed Costs (construction,
(Construction, IDC, IDC, OM&R)
OM&R) for calculating Separable Remaining
Allocation Factors to Costs (2013 TS TS TS Joints –
Authorized Purposes dollars) = TSC TSC TSC C TSC C C Total = RJ RJ RJ RJ RJ RJ RJ
Remaining
No. Description of Facilities SCRB Total WS P FC FW R N WQ Joints WS P FC FW R N WQ
17 Folsom Powerplant $420,468,523 $0 $420,468,523 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Folsom Pumps - 4160 Feeder
18 Cable Replacement $1,122,227 $1,122,227 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
19 Folsom Switchyard $21,159,024 $0 $21,159,024 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Nimbus Dam and Lake Natoma
20 Reservoir $67,905,789 $0 $8,580,070 $0 $0 $0 $0 $0 $59,325,719 $22,700,417 $6,079,160 $23,814,299 $0 $0 $0 $6,731,844
Nimbus Fish Hatchery and
21 Protection Facility $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
22 Nimbus Powerplant $71,045,827 $0 $71,045,827 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
23 Nimbus Switchyard $3,166,074 $0 $3,166,074 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Permanent Operating Facilities
24 - Folsom $28,827,360 $0 $0 $0 $0 $0 $0 $0 $28,827,360 $11,030,513 $2,953,966 $11,571,766 $0 $0 $0 $3,271,115
Replace Transformer
25 Replacement K3A $4,195,334 $0 $4,195,334 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Security Improvements -
26 Folsom $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Delta Division
27 Automated Meters $845,579 $0 $845,579 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Carrier Current Equipment-
28 Tracy $900,104 $0 $900,104 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Clayton Canal & Pumping
29 Plant $8,737,183 $8,737,183 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Columbia Mowry Pumping
30 Plant $8,324,517 $8,324,517 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
31 Contra Costa Canal $91,181,937 $91,181,937 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Contra Costa Canal System -
32 Deferred Maintenance $1,711,647 $1,711,647 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Contra Costa Distribution
33 System & Pump Plant $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
34 Contra Costa Fish Screen $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
35 Contra Costa Pumping Plant $16,564,200 $16,564,200 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
36 Contra Loma Dam & Reservoir $38,842,455 $38,842,455 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Contra Loma Dam & Reservoir
37 - Recreation Facilities $448,417 $0 $0 $0 $0 $448,417 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
38 Delta Cross Channel $40,699,239 $40,699,239 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
4 | Draft Central Valley Project Final Cost Allocation Study
Total
Total Indexed Costs (construction,
(Construction, IDC, IDC, OM&R)
OM&R) for calculating Separable Remaining
Allocation Factors to Costs (2013 TS TS TS Joints –
Authorized Purposes dollars) = TSC TSC TSC C TSC C C Total = RJ RJ RJ RJ RJ RJ RJ
Remaining
No. Description of Facilities SCRB Total WS P FC FW R N WQ Joints WS P FC FW R N WQ
39 Delta Mendota Canal $888,691,266 $888,691,266 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
40 Delta Mendota Intake Channel $33,157,516 $33,157,516 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
41 DMC-CA Intertie Easements $46,514,212 $46,514,212 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
42 Martinez Dam and Reservoir $13,719,240 $13,719,240 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Permanent Operating Facilities
43 - Tracy $14,076,424 $14,076,424 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
44 Shortcut Pipeline $24,569,833 $24,569,833 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Tracy FCF - Replace
45 Transformers $29,132 $0 $0 $0 $0 $0 $0 $0 $29,132 $11,147 $2,985 $11,694 $0 $0 $0 $3,306
Tracy Fish
46 Collection/Protection Facility $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Tracy Pumping Plant (C.W.
47 "Bill" Jones) $364,805,121 $364,805,121 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
48 Tracy Switchyard $40,634,428 $0 $40,634,428 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Ygnacio Canal & Pumping
49 Plant $7,710,734 $7,710,734 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Friant Division
Delano-Earlimart Irrigation
50 District $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
51 Exeter Irrigation District $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Friant Dam and Millerton $149,020,43
52 Lake/Reservoir $359,588,691 $210,568,256 $0 5 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
53 Friant-Kern Canal $1,118,922,160 $1,118,922,160 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
54 Ivanhoe Irrigation District $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
55 Lake Woollomes $93,082 $0 $0 $0 $0 $93,082 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
56 Lindmore Irrigation District $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Lindsay Strathmore Irrigation
57 District $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
58 Madera Canal $62,302,433 $62,302,433 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
59 Madera Irrigation District $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Permanent Operating Facilities
60 - Friant $823,120 $482,003 $0 $341,117 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
61 Plainview Distribution System $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
San Joaquin River Restoration
62 Project $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cost Allocation Study Spreadsheet Appendix | 5
Total
Total Indexed Costs (construction,
(Construction, IDC, IDC, OM&R)
OM&R) for calculating Separable Remaining
Allocation Factors to Costs (2013 TS TS TS Joints –
Authorized Purposes dollars) = TSC TSC TSC C TSC C C Total = RJ RJ RJ RJ RJ RJ RJ
Remaining
No. Description of Facilities SCRB Total WS P FC FW R N WQ Joints WS P FC FW R N WQ
Shafter-Wasco Irrigation
63 District $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
64 South San Joaquin MUD $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
65 Stone Corral Irrigation District $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
66 Tea Pot Dome Water District $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sacramento River Division -
Canals Unit
67 4-M Water District $629,489 $629,489 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Colusa County Water District
68 Relift Pumping Plant $47,694,439 $47,694,439 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
69 Colusa Service Area - Cortina $284,095 $284,095 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
70 Colusa Service Area - Davis $374,483 $374,483 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
71 Colusa Service Area - Other $3,904 $3,904 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
72 Corning Canal $63,884,655 $63,884,655 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
73 Corning Canal Pumping Plant $31,358,740 $31,358,740 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Corning Canal Relift Pumping
74 Plant $11,497,168 $11,497,168 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Glenn Valley Water District
75 Relift Pumping Plant $3,761,757 $3,761,757 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Distribution Systems:
Colusa County Water
76 District $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
77 Corning Water District $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
78 Dunnigan Water District $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
79 Orland-Artois Water District $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dunnigan Water District Relift
80 Pumping Plant $6,358,107 $6,358,107 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Glide Irrigation District Relift
81 Pumping Plant $3,768,060 $3,768,060 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Kanawha Water District Relift
82 Pumping Plant $10,299,678 $10,299,678 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
83 La Grande Water District $565,272 $565,272 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Orland-Artois Water District
84 Relift Pumping Plant $28,169,839 $28,169,839 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
6 | Draft Central Valley Project Final Cost Allocation Study