{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OUTPUT","Footnotes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":66,"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":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
["IRR 2025 Sch A-5 F.Z27.XLSM"]
["09/25/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION CONSTRUCTION AND PROJECT USE ENERGY COSTS BY COMPONENT"]
["AS OF SEPTEMBER 30, 2023"]
["2025 IRRIGATION WATER RATES"]
[]
["Category ","A) Component/Facility","B) Irrigation\nConstruction \nCosts at \n09/30/2023\n\n<Cost Allocation>","C) Allocation of Project Use Energy Construction Costs: Historical & \nProjected \n(1981-2030)\n KWH Per AF \n1/\n\n <Sch A-7>","D) Allocation of Project Use Energy Construction Costs:   \nRatio of \nTotal \n\n(C/Total C)","E) Allocation of Project Use Energy Construction Costs: CVP PUE \nConstruction \nCosts at \n09/30/2023\n(BOR)    1/\n\n(D*PUE BOR)","F) Allocation of Project Use Energy Construction Costs: CVP PUE \nConstruction \nCosts at\n09/30/2023\n (DOE)    1/\n\n(D*PUE DOE)","G) Total Irrigation\nConstruction \nCosts at\n09/30/2023\n\n(B+E+F)"]
["Storage     2/","San Felipe Unit Contractors",3419189.55312252,"-","-","-","-",3419189.55312252]
["Storage     2/","All Other Contractors",339041063.04071718,8811392192.7467861,0.1992883667,19550912.929400999,16513396.1876674,375105372.15778553]
["Total","Total Storage",342460252.5938397,8811392192.7467861,0.1992883667,19550912.929400999,16513396.1876674,378524561.71090806,null,null,null,""]
["Conveyance","Contra Costa WD     3/",0,"-","-","-","-",0]
["Conveyance","All Other Contractors    4/",379537030.60000002,"-","-","-","-",379537030.60000002]
["Total","Total Conveyance",379537030.60000002,"-","-","-","-",379537030.60000002]
["Conveyance Pumping","Corning Pumping Plant",2529062.5,68087817,1.5399507E-3,151074.75940425799,127603.113215618,2807740.3726198757]
["Conveyance Pumping","DMC - California Aqueduct Intertie",26962640.82,0,0,0,0,26962640.82,null,null,null,""]
["Conveyance Pumping","Dos Amigos Pumping Plant",14350686.98,5764907486,0.13038563850000001,12791304.920448501,10803990.927246001,37945982.827694505]
["Conveyance Pumping","O'Neill Pump-Generator Plant",11178506.970000001,2496701369,5.6468209200000001E-2,5539736.5116164498,4679058.4215655699,21397301.903182022]
["Conveyance Pumping","Jones Pumping Plant",31998349.609999999,19248129309,0.43533736429999997,42708177.327564001,36072845.048715897,110779371.9862799]
["Total","Total Conveyance Pumping",87019246.879999995,27577825981,0.62373116269999995,61190293.519033208,51683497.510743082,199893037.9097763]
["Direct Pumping    2/","Bella Vista WD (Wintu PP)",659106.67000000004,148737991,3.3640259E-3,330023.16468455299,278749.29877818201,1267879.133462735]
["Direct Pumping    2/","Colusa County WD Canalside Relifts",12601685.050000001,228603513,5.1703544000000004E-3,507230.55420848698,428424.96053157299,13537340.564740062]
["Direct Pumping    2/","Colusa Service Area - Cortina",141792.21,"-","-","-","-",141792.21]
["Direct Pumping    2/","Colusa Service Area - Davis",180305.28,"-","-","-","-",180305.28]
["Direct Pumping    2/","Contra Costa Pumping Plants",0,"-","-","-","-","-"]
["Direct Pumping    2/","Corning WD Canalside Relifts",2779835.16,107409098,2.4292850999999998E-3,238321.69562756101,201294.97759136901,3219451.8332189298]
["Direct Pumping    2/","Dunnigan WD Canalside Relifts",1700383.63,2580303,5.8359000000000001E-5,5725.2299596819003,4835.7327829716996,1710944.5927426536]
["Direct Pumping    2/","Kanawha WD Canalside Relifts",2751873.36,32792221,7.4166580000000002E-4,72760.109978434106,61455.775854091902,2886089.2458325261]
["Direct Pumping    2/","Orland-Artois WD Canalside Relifts",7496789.3700000001,70617786,1.5971714E-3,156688.31799768799,132344.524392208,7785822.2123898966]
["Direct Pumping    2/","Panoche WD Relifts",17103.890379600227,1914982,4.33114E-5,4249.0057210673003,3588.8613042787001,24941.757404946227]
["Direct Pumping    2/","Proberta WD Canalside Relifts",172158.29,5268311,1.191541E-4,11689.450181444699,9873.3252385319993,193721.06541997672]
["Direct Pumping    2/","San Benito County WD:   ","-","-","-","-","-","-"]
["Direct Pumping    2/","San Benito County WD: Pacheco Pumping Plant",0,125524293,2.8389986999999999E-3,278516.08856796601,235244.59096975799,513760.67953772401]
["Direct Pumping    2/","San Benito County WD: Gianelli, William R. Pump-Generator Plant   2/",124431.013374474,189301622,4.2814586000000003E-3,420026.64623892901,354769.43934879301,899227.09896219603]
["Direct Pumping    2/","San Luis WD Canalside Relift Pumping Plants",8367156.0996203981,925445510,2.0930917600000001E-2,2053399.07344459,1734373.8654877499,12154929.038552739]
["Direct Pumping    2/","Santa Clara Valley WD:   ","-","-","-","-","-","-"]
["Direct Pumping    2/","Santa Clara Valley WD: Coyote Pumping Plant ",0,36933556,8.353309E-4,81948.996640244601,69217.036237071807,151166.03287731641]
["Direct Pumping    2/","Santa Clara Valley WD: Pacheco Pumping Plant",0,128321214,2.9022571000000001E-3,284721.96747064701,240486.29693933099,525208.26440997794]
["Direct Pumping    2/","Santa Clara Valley WD: Gianelli, William R. Pump-Generator Plant    2/",127203.57278536999,193519624,4.3768577000000003E-3,429385.64460159303,362674.38212258997,919263.59950955305]
["Direct Pumping    2/","State-Delta Pumping Plant (Cross Valley Canal)",0,711689517,1.60963714E-2,1579112.5238857199,1333774.58259854,2912887.1064842599]
["Direct Pumping    2/","Westlands WD:","-","-","-","-","-","-"]
["Direct Pumping    2/","Westlands WD: Pleasant Valley Canalside Relifts",1335194.3799999999,24325181,5.5016570000000005E-4,53973.254312605699,45587.729597090198,1434755.3639096958]
["Direct Pumping    2/","Westlands WD: Pleasant Valley Pumping Plant",9865050.7200000007,318232180,7.1974973000000003E-3,706100.638747914,596397.704706394,11167549.063454308]
["Direct Pumping    2/","Westlands WD: Westlands WD Canalside Relifts",36136523.200000003,4538729272,0.1026530115,10070633.439424399,8506015.0616241395,54713171.701048538]
["Direct Pumping    2/","Westside WD Canalside Relifts",7002376.6299999999,35118387,7.9427700000000003E-4,77921.459872277701,65815.235484851204,7146113.3253571289]
["Total","Total Direct Pumping",91458968.526159838,7825064561,0.17698047059999999,17362427.261565804,14664923.381589515,123486319.16931517]
["Direct Pumping    2/","San Luis Drain",52381551.920000002,"-","-","-","-",52381551.920000002]
["Direct Pumping    2/","Other Costs",53065714.020000003,"-","-","-","-",53065714.020000003]
["Grand Total","Grand Total",1005922764.5399995,44214282734.746788,0.99999999999999978,98103633.710000008,82861817.079999998,1186888215.3300002]
[]
[null,null,null,null,null,null,null,null,""]

{"sheet":"Footnotes","index":1,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["IRR 2025 Sch A-5 F.Z27.XLSM"]
["09/25/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION CONSTRUCTION AND PROJECT USE ENERGY COSTS BY COMPONENT"]
["AS OF SEPTEMBER 30, 2023"]
["2025 IRRIGATION WATER RATES"]
[]
["Footnotes:"]
[]
["1/ The costs (BOR - $98,103,633.71 and DOE - $82,861,817.08) are allocated to components based on the ratios identified under \"Allocation of Project Use Energy Costs\".  "]
["They are then suballocated to individual facilities based on the historical and projected 1981-2030 KWHs per A/F."]
[]
["2/ Allocation of Storage Costs:"]
[]
["-","San Felipe Unit\nStorage","San Felipe Unit \nSan Benito","San Felipe Unit\nSanta Clara","All Other\nStorage\nContractors","Total"]
["Historical and Projected 1981-2030 Irrigation Del. (Sch A-7)",1207638.0000000002,597166,610472.00000000023,111538678.29999019,112746316.29999019]
["Ratios",1.0711108299999999E-2,5.2965455999999999E-3,5.4145627000000002E-3,0.98928889170000001,1]
["Allocated Gianelli, WR Pump-Generator Costs",251634.58615984401,124431.013374474,127203.57278536999,23241227.1338402,23492861.720000044]
["Allocated Other Storage Costs",3419189.55312252,"-","-",315799835.90687698,319219025.4599995,null,""]
["Total",3670824.1392823639,124431.013374474,127203.57278536999,339041063.04071718,342711887.17999953]
[]
["3/ Contra Costa Water District's conveyance facility costs are recovered through a repayment contract."]
[]
["4/ Glide WD's cost of the Relift Pumping Plant is included in conveyance for ratesetting purposes."]