{"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":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
["IRR 2024 Sch A-5 F.Z26.XLSM"]
["09/21/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION CONSTRUCTION AND PROJECT USE ENERGY COSTS BY COMPONENT"]
["AS OF SEPTEMBER 30, 2022"]
["2024 IRRIGATION WATER RATES"]
[]
["Category ","A) Component/Facility","B) Irrigation\nConstruction \nCosts at \n09/30/22\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/22\n(BOR)    1/\n\n(D*PUE BOR)","F) Allocation of Project Use Energy Construction Costs: CVP PUE \nConstruction \nCosts at\n09/30/22\n (DOE)    1/\n\n(D*PUE DOE)","G) Total Irrigation\nConstruction \nCosts at\n09/30/22\n\n(B+E+F)"]
["Storage     2/","San Felipe Unit Contractors",3521490.0368170901,"-","-","-","-",3521490.0368170901]
["Storage     2/","All Other Contractors",340295642.37839741,8637496003.0063229,0.20620586339999999,20197688.781102601,17037528.1509667,377530859.31046671]
["Total","Total Storage",343817132.41521448,8637496003.0063229,0.20620586339999999,20197688.781102601,17037528.1509667,381052349.34728378]
["Conveyance","Contra Costa WD     3/",0,"-","-","-","-",0]
["Conveyance","All Other Contractors    4/",380445220.25999999,"-","-","-","-",380445220.25999999]
["Total","Total Conveyance",380445220.25999999,"-","-","-","-",380445220.25999999]
["Conveyance Pumping","Corning Pumping Plant",2529062.5,68265632,1.6297284999999999E-3,159630.51921972301,134654.48915640599,2823347.508376129]
["Conveyance Pumping","DMC - California Aqueduct Intertie",26962640.82,0,0,0,0,26962640.82]
["Conveyance Pumping","Dos Amigos Pumping Plant",14358841.734999999,5658760916,0.13509351319999999,13232294.615534101,11161949.9863261,38753086.336860202]
["Conveyance Pumping","O'Neill Pump-Generator Plant",11220961.815000001,2450372628,5.8498574499999997E-2,5729885.5736085,4833379.0969940601,21784226.485602561]
["Conveyance Pumping","Jones Pumping Plant",32305916.920000002,19035985063,0.4544525096,44513236.448987603,37548628.821325101,114367782.19031271]
["Total","Total Conveyance Pumping",87377423.790000007,27213384239,0.64967432579999995,63635047.157349929,53678612.393801667,204691083.3411516]
["Direct Pumping    2/","Bella Vista WD (Wintu PP)",664363.75,150718546,3.5981547999999999E-3,352436.19962278201,297293.50410186202,1314093.4537246439]
["Direct Pumping    2/","Colusa County WD Canalside Relifts",12601688.65,228295807,5.4501829999999999E-3,533840.78521821601,450315.25660496898,13585844.691823186]
["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,107704038,2.5712549000000001E-3,251852.228597129,212447.05179446001,3244134.440391589]
["Direct Pumping    2/","Dunnigan WD Canalside Relifts",1700383.63,2578327,6.1553300000000006E-5,6029.0933359068003,5085.7723647780003,1711498.4957006846]
["Direct Pumping    2/","Kanawha WD Canalside Relifts",2751942.835,33155094,7.9152279999999996E-4,77528.984452470802,65398.683455341503,2894870.5029078121]
["Direct Pumping    2/","Orland-Artois WD Canalside Relifts",7496789.3700000001,70648028,1.6866043000000001E-3,165201.45541249099,139353.788330693,7801344.6137431841]
["Direct Pumping    2/","Panoche WD Relifts",17103.890379600227,1906454,4.5513399999999997E-5,4457.9987853529001,3760.4936201159999,25322.38278506913]
["Direct Pumping    2/","Proberta WD Canalside Relifts",172158.29,5284839,1.2616670000000001E-4,12357.920861811601,10424.3820593734,194940.59292118502]
["Direct Pumping    2/","San Benito County WD:   ","-","-","-","-","-","-"]
["Direct Pumping    2/","San Benito County WD: Pacheco Pumping Plant",0,126868282,3.0287693999999999E-3,296665.38439918502,250248.67413778201,546914.05853696703]
["Direct Pumping    2/","San Benito County WD: Gianelli, William R. Pump-Generator Plant   2/",127551.045133101,191328475,4.5676494000000002E-3,447397.37038141902,377396.90789144702,952345.32340596709]
["Direct Pumping    2/","San Luis WD Canalside Relift Pumping Plants",8367156.0996203981,919254685,2.1945678E-2,2149560.4781832299,1813237.0270759801,12329953.604879608]
["Direct Pumping    2/","Santa Clara Valley WD:   ","-","-","-","-","-","-"]
["Direct Pumping    2/","Santa Clara Valley WD: Coyote Pumping Plant ",0,37672382,8.9936550000000001E-4,88092.085113137204,74309.065569753599,162401.15068289079]
["Direct Pumping    2/","Santa Clara Valley WD: Pacheco Pumping Plant",0,130888327,3.1247413E-3,306065.75030522601,258178.244718323,564243.99502354907]
["Direct Pumping    2/","Santa Clara Valley WD: Gianelli, William R. Pump-Generator Plant    2/",131592.72465253499,197391054,4.7123833999999998E-3,461573.94247225899,389355.39228535898,982522.05941015296]
["Direct Pumping    2/","State-Delta Pumping Plant (Cross Valley Canal)",0,714648952,1.7061056099999999E-2,1671115.9212591599,1409650.6219375101,3080766.5431966698]
["Direct Pumping    2/","Westlands WD:","-","-","-","-","-","-"]
["Direct Pumping    2/","Westlands WD: Pleasant Valley Canalside Relifts",1335954.125,8457072,2.0189850000000001E-4,19775.786202844902,16681.637081848101,1372411.5482846929]
["Direct Pumping    2/","Westlands WD: Pleasant Valley Pumping Plant",9870664.0599999987,661822105,1.5799903000000001E-2,1547587.04870857,1305449.2617548101,12723700.370463379]
["Direct Pumping    2/","Westlands WD: Westlands WD Canalside Relifts",36157085.394999996,2412385863,5.7591703600000002E-2,5641058.3409545599,4758449.9061685298,46556593.642123081]
["Direct Pumping    2/","Westside WD Canalside Relifts",7002376.6299999999,35843719,8.5570920000000003E-4,83815.9876918722,70702.012753926407,7156894.6304457979]
["Total","Westside WD Canalside Relifts: Total Direct Pumping",91498743.144785628,6036852049,0.14411981060000001,14116412.761957623,11907737.683706861,117522893.59045009]
["Direct Pumping    2/","San Luis Drain",52381551.920000002,"-","-","-","-",52381551.920000002]
["Direct Pumping    2/","Other Costs",51894561.230000004,"-","-","-","-",51894561.230000004]
["Grand Total","Grand Total",1007414632.76,41887732291.006325,0.99999999979999998,97949148.700410157,82623878.228475258,1187987659.6888857]

{"sheet":"Footnotes","index":1,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["IRR 2024 Sch A-5 F.Z26.XLSM"]
["2023-09-21"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION CONSTRUCTION AND PROJECT USE ENERGY COSTS BY COMPONENT"]
["AS OF SEPTEMBER 30, 2022"]
["2024 IRRIGATION WATER RATES"]
[]
["Footnotes:"]
[]
["1/ The costs (BOR - $97,949,148.72 and DOE - $82,623,878.25) 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)",1226244.5714285718,603559.85714285728,622684.71428571455,110374531.21570449,111600775.78713305]
["-","-","-","-","-","-"]
["Ratios",1.0987778199999999E-2,0.49220185859999999,0.50779814140000001,0.98901222180000004,1]
["-","-","-","-","-","-"]
["Allocated Gianelli, WR Pump-Generator Costs",259143.76978563599,127551.045133101,131592.72465253499,23325585.105214398,23584728.875000034]
["Allocated Other Storage Costs",3521490.0368170901,null,"",316970057.27318299,320491547.31000006]
["Total",3780633.8066027262,127551.045133101,131592.72465253499,340295642.37839741,344076276.18500012]
[]
["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."]
[]
["5/"]
[]
["Reconciliation of Capital Costs for 2012 Water Service Rates CVP, as of September 30, 2010 - Table 20 with Ratesetting Schedule A-5:"]
[]
["Total Capital Costs @ 9/30/11 Per Schedule A-5","-","$1,188,523,143 "]
["-","-","-"]
["Less: Storage","-",361009205.19499999]
["Conveyance (In-Basin)",380553439.49000001,"-"]
["Less Contra Costa WD",108219.23000000001,380445220.25999999]
["Conveyance Pumping","-",87377423.790000007]
["Direct Pumping (In-Basin)","-",91239599.374999985]
["San Luis Drain","-",52381551.920000002]
["Project Use Energy (BOR)","-",97949148.719999999]
["Project Use Energy (DOE)","-",82623878.245000005]
["Difference","-",35497115.495000124]
[]
["Sources:"]
["Table 20 - Capital Costs for 2012 Water Service Rates Central Valley Project, California As of September 30, 2010"]
["Financial Statement for Period Ending September 30, 2010 Central Valley Project, California - Consolidated"]
["CVO Schedule of KWH's per acre foot"]