{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OUTPUT","Footnotes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":28,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"OUTPUT","index":0,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Bureau of Reclamation logo"]
["2024 Full Cost Additional Service Water Rates Sch TR-2b.Z26.xlsm"]
["01/13/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I FULL COST ADDITIONAL SERVICE WATER RATES"]
["AS OF SEPTEMBER 30, 2022"]
["2024 SPECIAL WATER RATES"]
[]
[]
["Category","A) Component / Facility\n<Ref>","Related Footnotes","B) Total M&I Construction at 9/30/2022\n<Sch A-4>","C) Ratio of Total\n(B/$148,655,498)  excludes Folsom SOD","D) Allocation of Construction Repayment at 9/30/2022  1/\n(C*$139,055,334)","E) Unpaid M&I Construction: Net Unpaid Construction at 9/30/2022\n(B-D)","F) Unpaid M&I Construction: Annualized Costs Remaining Years\n(E/7)","G) Unpaid M&I Construction: Annual Interest @\n(E*0.08012) ","H) FY 2024 Projected Deliveries\n<Sch S-6>","I) Unpaid M&I Construction Cost Per Acre Foot: Construction Only\n(F/H)","J) Unpaid M&I Construction Cost Per Acre Foot: Interest\n(G/H)","K) Unpaid M&I Construction Cost Per Acre Foot: Total\n(I+J)"]
["Storage","San Felipe Unit","-",9431853.7400000002,6.3447728855191177E-2,8822745.0980567392,609108.64194326103,87015.520277608724,48801.784392494068,90406.71428571429,0.96,0.54,1.5]
["Storage","All Other Contractors","-",40487396.777021267,0.27235721031876248,37872722.721794732,2614674.0552265346,373524.86503236211,209487.68530474993,247094.09523809524,1.51,0.85,2.36]
["Folsom SOD","San Felipe Unit","7/",868475.55,"-",0,868475.55,17369.511000000002,69582.261066000006,90406.71428571429,0.19,0.77,0.96]
["Folsom SOD","All Other Contractors","7/",2373592.84,"-",0,2373592.84,47471.856799999994,190172.25834079998,247094.09523809524,0.19,0.77,0.96]
["Total","Storage","-",53161318.907021269,0.33580493917395365,46695467.819851473,6465851.0871697953,525381.75310997083,518043.98910404393,"-",0,0,0]
["Conveyance","Contra Costa Canal System","2/",0,"-",0,0,0,0,"-",0,0,0]
["Conveyance","All Other Contractors","-",26667619.59999999,0.17939208391437389,24945426.062421292,1722193.5375786982,246027.64822552833,137982.14623080529,180036.85714285713,1.37,0.77,2.14]
["Total","Conveyance","-",26667619.59999999,0.17939208391437389,24945426.062421292,1722193.5375786982,246027.64822552833,137982.14623080529,"-",0,0,0]
["Conveyance Pumping","Dos Amigos Pumping Plant, Construction only","3/",282406.18499999988,1.8997358893426768E-3,264168.40772274887,18237.777277251007,2605.396753893001,1461.2107154533505,12130.857142857143,0.21,0.12,0.32999999999999996]
["Conveyance Pumping","Dos Amigos Pumping Plant, PUE only","-",610621.29445152404,4.1076267074902873E-3,571187.40185121284,39433.892600311199,5633.4132286158856,3159.4434751369331,12408.857142857143,0.45,0.25,0.7]
["Conveyance Pumping","Dos Amigos Pumping Plant, Unpaid M&I Construction Per Acre Foot Total","-",0,"-",0,0,0,0,"-",0.66,0.37,1.0299999999999998]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, Construction only  ","-",1641110.5249999999,1.1039689384708423E-2,1535127.6895238487,105982.8354761512,15140.405068021601,8491.3447783492338,103033.57142857143,0.15,0.08,0.22999999999999998]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, PUE only  ","-",1903753.2862080932,1.280647745821706E-2,1780808.9943729199,122944.29183517327,17563.470262167608,9850.2966618340815,103033.57142857143,0.17,0.1,0.27]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, Unpaid M&I Construction Per Acre Foot Total","-",0,"-",0,0,0,0,"-",0.32,0.18,0.5]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, Construction only","4/, 5/",1508062.1722162066,1.0144678070415509E-2,1410671.5926964041,97390.579519802472,13912.939931400353,7802.9332311265734,47733.142857142855,0.28999999999999998,0.16,0.44999999999999996]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, PUE only","4/, 5/",2696842.6909966739,1.8141560348608747E-2,2522680.7251382433,174161.9658584306,24880.280836918657,13953.85670457746,47733.142857142855,0.52,0.28999999999999998,0.81]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, Unpaid M&I Construction Per Acre Foot Total","-",0,"-",0,0,0,0,"-",0.81,0.44999999999999996,1.26]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, Construction only Construction only  4/  6/","4/, 6/",2970111.7627837942,1.9979831217645672E-2,2778302.0939615825,191809.66882221168,27401.381260315953,15367.790666035598,110980.85714285714,0.25,0.14000000000000001,0.39]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, PUE only","4/, 6/",5343639.3713145964,3.5946463047156284E-2,4998547.4084597984,345091.96285479795,49298.851836399706,27648.768063926411,110980.85714285714,0.44,0.25,0.69]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, Unpaid M&I Construction Per Acre Foot Total","-",0,"-",0,0,0,0,"-",0.69,0.39,1.08]
["Total","Conveyance Pumping","-",16956547.287970886,0.11406606212358467,15861494.313726757,1095052.9742441294,156436.13917773275,87735.644296439641,"-",0,0,0]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",885051.07537456101,5.9537056236582953E-3,827894.52127262892,57156.554101932095,8165.2220145617275,4579.3831146467992,3638.5714285714284,2.2400000000000002,1.26,3.5]
["Direct Pumping","Colusa County WD Relift PP","-",38370.190829280757,2.581148447556555E-4,35892.245828076047,2477.9450012047091,353.99214302924418,198.53295349652129,126,2.81,1.58,4.3900000000000006]
["Direct Pumping","Contra Costa PP (Contra Costa WD)","-",5579969.2961099595,3.7536245650038748E-2,5219615.1585532604,360354.1375566991,51479.162508099871,28871.573501042731,81034,0.64,0.36,1]
["Direct Pumping","Kanawha WD","-",1959.9055208682541,1.3184211449597948E-5,1833.3349205322527,126.57060033600146,18.081514333714495,10.140836498920438,27.428571428571427,0.66,0.37,1.03]
["Direct Pumping","Pleasant Valley PP (City of Coalinga)","-",49734.201992766604,3.3456012464272634E-4,46522.369720021263,3211.8322727453415,458.83318182076306,257.33200169235676,5603.5714285714284,0.08,0.05,0.13]
["Direct Pumping","Canalside Relift PP (City of Coalinga)","-",214625.44948866754,1.4437774057955769E-3,200764.94871456371,13860.500774103828,1980.0715391576898,1110.5033220211988,5603.5714285714284,0.35,0.2,0.55000000000000004]
["Direct Pumping","San Benito County WD, Pacheco PP","-",249835.34593094399,1.6806330679030891E-3,233700.99180880067,16134.354122143326,2304.907731734761,1292.6844522661233,"-",0,0,0]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",402618.13871040707,2.7083972251121507E-3,376617.07948579494,26001.059224612138,3714.4370320874482,2083.2048650759243,"-",0,0,0]
["Total","San Benito County WD","-",652453.48464135104,4.38903029301524E-3,610318.0712945956,42135.413346755464,6019.3447638222096,3375.8893173420474,5390.8571428571431,1.1200000000000001,0.63,1.75]
["Direct Pumping","San Luis WD Canalside Relift PP","-",86055.487861171889,5.7889206203030354E-4,80498.028766934163,5557.4590942377254,793.92272774824653,445.26362263032655,515.28571428571433,1.54,0.86,2.4]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",1531596.6072296952,1.0302993338300055E-2,1432686.1750759219,98910.432153773261,14130.061736253323,7924.7038241603132,"-",0,0,0]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",5321350.1028961595,3.5796523968585119E-2,4977697.5798790129,343652.52301714662,49093.217573878086,27533.440144133787,"-",0,0,0]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",8793195.26482426,5.9151497077108053E-2,8225331.1552076694,567864.10961659066,81123.444230941517,45497.27246248124,"-",0,0,0]
["Total","Santa Clara WD","-",15646141.974950114,0.10525101438399323,14635714.910162605,1010427.0647875105,144346.72354107292,80955.416430775338,85015.857142857145,1.7,0.95,2.65]
["Direct Pumping","Shasta Pumping Plant (City of Shasta Lake)","-",599837.29753402702,4.0350831618355424E-3,561099.83491431235,38737.462619714672,5533.9232313878101,3103.6455050915392,1115,4.96,2.78,7.74]
["Direct Pumping","State Delta PP (Cross Valley Canal)  ","-",18110.338307963761,1.2182757134648554E-4,16940.773567459546,1169.5647405042146,167.0806772148878,93.705527009197667,278,0.6,0.34,0.94]
["Direct Pumping","Westlands WD Relifts","-",811492.06739718176,5.4588769164220429E-3,759085.95034473191,52406.117052449845,7486.5881503499777,4198.778098242281,2890.4285714285716,2.59,1.45,4.04]
["Total","Direct Pumping","-",24583800.770007916,0.16537431224898347,22996180.148059718,1587620.6219481935,226802.94599259907,127200.16423048926,"-",0,0,0]
["Subtotal","-","-",121369286.56500006,0.79463740000000005,110498568.34405923,10870718.220940817,1154648.4865058309,870961.94386177813,"-",0,0,0]
["Other Costs","Other Costs: Deferred Interest Capitalized ","-",21277763,0.14313471929103719,19903646.131588876,1374116.8684111238,196302.40977301769,110094.24349709923,"-",0,0,0]
["Other Costs","Other Costs: Programmatic EIS Capitalized  ","-",1608832.8485963999,1.082255865760162E-2,1504934.5038451103,103898.34475128958,14842.620678755655,8324.33538147332,"-",0,0,0]
["Other Costs","Other Costs: All others","-",7641684.1350000007,5.1405324590465526E-2,7148184.5564506408,493499.57854935993,70499.939792765697,39539.186233374712,"-",0,0,0]
["Total","Other Costs","-",30528279.983596403,0.20536260253910432,28556765.191884629,1971514.7917117733,281644.97024453903,157957.76511194726,337500.80952380953,0.83,0.47,1.2999999999999998]
["Grand Total","-","-",151897566.54859647,1.0000000025391045,139055333.53594387,12842233.012652591,1436293.4567503699,1028919.7089737253,"-",0,0,0]

{"sheet":"Footnotes","index":1,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["2024 Full Cost Additional Service Water Rates Sch TR-2b.Z26.xlsm"]
["01/13/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I FULL COST ADDITIONAL SERVICE WATER RATES"]
["AS OF SEPTEMBER 30, 2022"]
["2024 SPECIAL WATER RATES"]
[]
["FOOTNOTES:"]
["1/"]
["Refer to M&I Water Rates, Schedule A-2Ba.  Total Allocation of Construction Repayment is being reduced by the Assignment "]
[]
["Repayment as of 9/30/2022 (Column C of A-2Ba)","Construction Repayment per Assignment","Adjusted M&I Construction Repayment"]
[139834478.53594387,-779145,139055333.53594387]
[]
["2/"]
["Contra Costa WD's conveyance costs are recovered through a repayment contract."]
[]
["3/"]
["Cross Valley Canal contractors are charged for PUE constrcution component only.  Therefore their deliveries are not included in determining"]
[" the \"Construction only\" rate."]
[]
["4/"]
["Suballocation of Jones Pumping Plant costs:"]
[]
["Component/Facility","Historical & Projected Deliveries (1981-2030) (Sch A-7)","Ratio","M&I\nConstruction\nCosts\nat 9/30/2022","Project Use Energy\nBOR","Project Use Energy\nDOE","Project Use Energy\nTotal"]
["Jones Pumping Plant: Delta-Mendota Exchange",2504139.9169388572,0.33540808500000002,1508062.1722162066,1358744.7986512729,1338097.892345401,2696842.6909966739]
["Jones Pumping Plant: All Other Contractors",4961809.8571428582,0.66459191500000003,2988138.8427837943,2692275.0169601273,2651364.3543544691,5343639.3713145964]
["Total",7465949.7740817154,1,4496201.0150000006,4051019.8156114002,3989462.2466998701,8040482.0623112703]
[]
["a/"]
["Jones Pumping Plant - Conveyance Pumping:"]
[]
["Component/Facility","M&I\nConstruction\nCosts\nat 9/30/2021"]
["Total Construction Cost (M&I Sch A-5)",12536683.07731127]
["less:  BOR PUE (M&I Sch A-5)",4051019.8156114002]
["less:  DOE PUE (M&I Sch A-5)",3989462.2466998701]
["Capital Allocation",4496201.0150000006]
[]
["5/"]
["FY 2022 projected deliveries include Friant Dam and Friant-Kern Canal"]
[]
["6/"]
["FY 2022 projected deliveries for Jones PP do not include Delta Mendota Exchange contractors' deliveries."]
[]
["7/"]
["Folsom SOD has a repayment period of 50 years beginning in 2024."]