{"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":247,"n_cols":13,"rows_kept":247,"cut":false,"hidden":false,"merged":[]}
["Bureau of Reclamation logo"]
["Special Rates 2024 Sch S-2.Z26.XLSM"]
["01/13/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I UNPAID CONSTRUCTION COSTS BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2022"]
["2024 SPECIAL WATER RATES"]
[]
[]
["Category","A) Component/Facility\n\n","Related Footnotes\n","B) Total Construction at 9/30/2022\n\n<Sch A-4>","C) Ratio of Total\n\n<B/$148,655,498> excludes        Folsom SOD","D) Cumulative Construction Repayment at 9/30/2022\n1/\n\n<C*$139,055,334>","E) Net Unpaid Construction at 9/30/2022\n\n(B-D)\n","F) Unpaid Construction Annualized Costs 7\nRemaining Years\nE*\n\n(E/7)\n","G) Annual Interest @ 0.023596\n2/","H) FY 2024 Projected Deliveries\n\n\n<Sch S-6>","I) Unpaid Construction Cost Per Acre Foot Construction Only\n\n(F/H)","J) Unpaid Construction Cost Per Acre Foot Interest\n\n(G/H)","K) Unpaid Construction Cost Per Acre Foot Total\n\n(I+J)"]
["Storage","San Felipe Unit","-",9431853.7400000002,6.3447728855191177E-2,8822745.0999999996,609108.6400000006,87015.520000000091,14469.137039615083,90406.71428571429,0.96,0.16,1.1199999999999999]
["Storage","All Other Contractors","-",40487396.777021267,0.27235721031876248,37872722.719999999,2614674.0570212677,373524.86528875254,62110.557559924004,247094.09523809524,1.51,0.25,1.76]
["Folsom SOD","San Felipe Unit Contractors","8/",868475.55,"-",0,868475.55,17369.511000000002,20630.29634336671,90406.71428571429,0.19,0.23,0.42000000000000004]
["Folsom SOD","All Other Contractors","8/",2373592.84,"-",0,2373592.84,47471.856799999994,56383.767726901926,247094.09523809524,0.19,0.23,0.42000000000000004]
["Total","Total Storage","-",53161318.907021269,0.33580493917395365,46695467.82,6465851.087021268,525381.75308875262,153593.75866980772,"-","-","-","-"]
["Conveyance","Contra Costa Canal System","3/",0,"-",0,0,0,0,"-",0,0,0]
["Conveyance","All Other Contractors","-",26667619.59999999,0.17939208391437389,24945426.059999999,1722193.5399999917,246027.64857142739,40910.032632273411,180036.85714285713,1.37,0.23,1.6]
["Total","Total Conveyance","-",26667619.59999999,0.17939208391437389,24945426.059999999,1722193.5399999917,246027.64857142739,40910.032632273411,"-","-","-","-"]
["Conveyance Pumping","Dos Amigos Pumping Plant, Capital only","4/",282406.18499999988,1.8997358893426768E-3,264168.40999999997,18237.774999999907,2605.3964285714151,433.23119792335302,12130.857142857143,0.21,0.04,0.25]
["Conveyance Pumping","Dos Amigos Pumping Plant, PUE only","-",610621.29445152404,4.1076267074902873E-3,571187.4,39433.894451524015,5633.4134930748596,936.73670894705629,12408.857142857143,0.45,0.08,0.53]
["Total","Total Dos Amigos Pumping Plant","-",0,"-",0,0,0,0,"-",0.66,0.12,0.78]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, Capital only","-",1641110.5249999999,1.1039689384708423E-2,1535127.69,105982.83499999996,15140.404999999995,2517.5807118117909,103033.57142857143,0.15,0.02,0.16999999999999998]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, PUE only","-",1903753.2862080932,1.280647745821706E-2,1780808.99,122944.29620809318,17563.470886870455,2920.4935757830121,103033.57142857143,0.17,0.03,0.2]
["Total","Total O'Neill P-Generator/Pumping Plant","-","-","-","-","-",0,0,"-",0.32,0.05,0.37]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, Capital only","5/, 6/",1508062.1722162066,1.0144678070415509E-2,1410671.59,97390.582216206472,13912.940316600925,2313.4751141507199,47733.142857142855,0.28999999999999998,0.05,0.33999999999999997]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, PUE only","5/, 6/",2696842.6909966739,1.8141560348608747E-2,2522680.73,174161.96099667391,24880.280142381987,4137.1491311450936,47733.142857142855,0.52,0.09,0.61]
["Total","Total Friant Kern/Madera","-","-","-","-","-",0,0,"-",0.81,0.14000000000000001,0.95]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, Capital only","5/, 7/",2970111.7627837942,1.9979831217645672E-2,2778302.09,191809.67278379435,27401.381826256336,4556.3636086863671,110980.85714285714,0.25,0.04,0.28999999999999998]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, PUE only","5/, 7/",5343639.3713145964,3.5946463047156284E-2,4998547.41,345091.96131459624,49298.851616370892,8197.5243029395133,110980.85714285714,0.44,7.0000000000000007E-2,0.51]
["Total","Total All Other Contractors","-","-","-","-","-",0,0,"-",0.69,0.11000000000000001,0.8]
["Total","Total Conveyance Pumping","-",16956547.287970886,0.11406606212358467,15861494.310000001,1095052.9779708879,156436.13971012688,26012.554351386905,"-","-","-","-"]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",885051.07537456101,5.9537056236582953E-3,827894.52,57156.555374560994,8165.2221963658567,1357.7315738402106,3638.5714285714284,2.2400000000000002,0.37,2.6100000000000003]
["Direct Pumping","Colusa County WD Relift PP","-",38370.190829280757,2.581148447556555E-4,35892.25,2477.9408292807566,353.99154704010806,58.862513319332784,126,2.81,0.47,3.2800000000000002]
["Direct Pumping","Contra Costa PP (Contra Costa WD)","-",5579969.2961099595,3.7536245650038748E-2,5219615.16,360354.13610995933,51479.162301422759,8560.0712841096829,81034,0.64,0.11,0.75]
["Direct Pumping","Kanawha WD","-",1959.9055208682541,1.3184211449597948E-5,1833.33,126.57552086825422,18.082217266893458,3.0067518945445055,27.428571428571427,0.66,0.11,0.77]
["Direct Pumping","Pleasant Valley PP (City of Coalinga)","-",211114.20948866755,1.4201574250784564E-3,197480.46,13633.749488667556,1947.6784983810794,323.86437617321064,5603.5714285714284,0.35,0.06,0.41]
["Direct Pumping","Pleasant Valley WD Canalside Relift PP (City of Coalinga)","-",53245.441992766602,3.5818010535984687E-4,49806.85,3438.5919927666037,491.22742753808626,81.682405238354619,5603.5714285714284,0.09,0.01,9.9999999999999992E-2]
["Direct Pumping","San Benito County WD, Pacheco PP","-",249835.34593094399,1.6806330679030891E-3,233700.99,16134.355930944002,2304.9079901348573,383.26530224682898,"-","-","-","-"]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",402618.13871040707,2.7083972251121507E-3,376617.08,26001.058710407058,3714.4369586295797,617.64496011082156,"-","-","-","-"]
["Total","Total San Benito County WD","-",652453.48464135104,4.38903029301524E-3,610318.07000000007,42135.414641351061,6019.3449487644375,1000.9102623576505,5390.8571428571431,1.1200000000000001,0.19,1.31]
["Direct Pumping","San Luis WD Canalside Relift PP","-",86055.487861171889,5.7889206203030354E-4,80498.03,5557.4578611718898,793.92255159598426,132.01523357997701,515.28571428571433,1.54,0.26,1.8]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",1531596.6072296952,1.0302993338300055E-2,1432686.18,98910.427229695255,14130.061032813608,2349.5784368340837,"-","-","-","-"]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",5321350.1028961595,3.5796523968585119E-2,4977697.58,343652.52289615944,49093.217556594209,8163.3310074110695,"-","-","-","-"]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",8793195.26482426,5.9151497077108053E-2,8225331.1600000001,567864.10482425988,81123.443546322844,13489.389269836252,"-","-","-","-"]
["Total","Total Santa Clara WD","-",15646141.974950114,0.10525101438399323,14635714.92,1010427.0549501146,144346.72213573067,24002.298714081408,85015.857142857145,1.7,0.28000000000000003,1.98]
["Direct Pumping","Shasta Pumping Plant (City of Shasta Lake)","-",599837.29753402702,4.0350831618355424E-3,561099.82999999996,38737.467534027062,5533.9239334324375,920.19336044466093,1115,4.96,0.83,5.79]
["Direct Pumping","State Delta PP (Cross Valley Canal)  ","-",18110.338307963761,1.2182757134648554E-4,16940.77,1169.5683079637602,167.08118685196573,27.782636813554912,278,0.6,0.1,0.7]
["Direct Pumping","Westlands WD Relifts","-",811492.06739718176,5.4588769164220429E-3,759085.95,52406.117397181806,7486.5881995974005,1244.8867813367069,2890.4285714285716,2.59,0.43,3.02]
["Total","Total Direct Pumping","-",24583800.770007916,0.16537431224898347,22996180.139999997,1587620.6300079133,226802.94714398767,37713.305893189303,"-","-","-","-"]
["Subtotal","Subtotal","-",121369286.56500006,0.79463740000000005,110498568.33,10870718.235000061,1154648.4885142946,258229.65154665735,"-","-","-","-"]
["Other Costs","Deferred Interest Capitalized ","-",21277763,0.14313471929103719,19903646.129999999,1374116.870000001,196302.41000000015,32641.607744189838,"-","-","-","-"]
["Other Costs","Programmatic EIS Capitalized  ","-",1608832.8485963999,1.082255865760162E-2,1504934.5,103898.34859639988,14842.621228057125,2468.0645541836475,"-","-","-","-"]
["Other Costs","All others","-",7641684.1350000007,5.1405324590465526E-2,7148184.5599999996,493499.57500000112,70499.939285714441,11722.889006576579,"-","-","-","-"]
["Total","Total Other Costs","-",30528279.983596403,0.20536260253910432,28556765.189999998,1971514.793596402,281644.97051377175,46832.561304950068,337500.80952380953,0.83,0.14000000000000001,0.97]
["Grand Total","Total","-",151897566.54859647,1.0000000025391045,139055333.51999998,12842233.028596463,1436293.4590280664,305062.21285160742,"-","-","-","-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,2.4207491611354961E-2]

{"sheet":"Footnotes","index":1,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Special Rates 2024 Sch S-2.Z26.XLSM"]
["01/08/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I UNPAID CAPITAL COSTS BY COMPONENT AND/OR FACILITY"]
["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 09/30/2022 (Column C of A-2Ba)","Construction Repayment per Assignment","Adjusted M&I Construction Repayment"]
[139834478.53594387,-779145,139055333.53594387]
[]
["2/"]
["Annual Interest of 0.023596 is from M&I Schedule A-13."]
[]
["3/"]
["Contra Costa WD's conveyance costs are recovered through a repayment contract."]
[]
["4/"]
["Cross Valley Canal contractors are charged for PUE construction component only.  Therefore their deliveries are not included in determining the \"Construction only\" rate."]
[]
["5/"]
["Suballocation of Jones Pumping Plant costs:"]
[]
["Facility/Contractor\n<Ref>","Historical & Projected Deliveries (1981-2030)\n<Sch A-7>","Ratio","M&I Construction Costs at 9/30/2022","Project Use Energy: BOR","Project Use Energy: DOE","Project Use Energy: Total"]
["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]
["Jones Pumping Plant: Total  a/",7465949.7740817154,1,4496201.0150000006,4051019.8156114002,3989462.2466998701,8040482.0623112703]
[]
["a/"]
["Jones Pumping Plant - Conveyance Pumping:"]
[]
["Total Construction Cost (M&I Sch A-5)","less:  BOR PUE (M&I Sch A-5)","less:  DOE PUE (M&I Sch A-5)","   Capital Allocation"]
[12536683.07731127,4051019.8156114002,3989462.2466998701,4496201.0150000006]
[]
["6/"]
["FY 2024 projected deliveries include Friant Dam and Friant-Kern Canal."]
[]
["7/"]
["FY 2024 projected deliveries for Jones PP do not include Delta Mendota Exchange contractors' deliveries."]