{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["OUTPUT"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"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":90,"n_cols":11,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
[]
["IRR 2024 Sch A-4 F.Z26.XLSM"]
["09/22/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION CONSTRUCTION COSTS TO BE REPAID BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2022"]
["2024 IRRIGATION WATER RATES"]
[]
[]
["Category","A) Component/Facility","Related Footnotes","B) Total \nConstruction \nCost\n\n<Sch A-5>","C) Cumulative\n Rescheduling \nFee \nRevenue\n\n<Sch B-2>","D) Allocation of Miscellaneous Irrigation Revenues: Cumulative\n Transfer Water \nand 215 Water Revenue\n\n<Sch B-2>","E) Allocation of Miscellaneous Irrigation Revenues: Net \nConstruction \nCost\n\n(B-C-D)","   F) Historical & Projected  Deliveries\n  1981-2030\n<Sch A-7>","G) 50-yr Construction\n Cost \nPer AF\n(E/F)"]
["Storage","San Felipe Unit Contractors","-",3521490.0368170901,739198.32000000007,612.22,2781679.4968170901,1226244.5714285718,2.2684540764999999]
["Storage","All Other Contractors","-",377530859.31046671,37111893.810000002,61623.66,340357341.84046668,110374531.21570444,3.0836583230999999]
["Folsom SOD","San Felipe Unit Contractors","6/",232658.44459740003,0,0,232658.44459740003,1037828.5714285715,0.2241781071]
["Folsom SOD","All Other Contractors","6/",16700270.565402603,0,0,16700270.565402603,73872964.285714328,0.22606742160000001]
["Total","Total Storage","-",397985278.35728383,37851092.130000003,62235.880000000005,360071950.34728384,"-","-"]
["Conveyance","Contra Costa WD","-",0,0,0,0,"-","-"]
["Conveyance","All Other Contractors","-",380445220.25999999,0,4013211.76,376432008.5,108479983.09856161,3.4700596159999999]
["Total","Total Conveyance","-",380445220.25999999,0,4013211.76,376432008.5,"-","-"]
["Conveyance Pumping","Corning Pumping Plant","-",2823347.508376129,0,16266.49,2807081.0183761287,846968.14285714284,3.3142698955999998]
["Conveyance Pumping","DMC - California Aqueduct Intertie","-",26962640.82,0,7114.06,26955526.760000002,27204939.571428567,0.99083207630000003]
["Conveyance Pumping","Dos Amigos Pumping Plant - Construction only","2/",14358841.735000001,0,872603.10737804347,13486238.627621958,38629024.146707878,0.34912190830000001]
["Conveyance Pumping","Dos Amigos Pumping Plant - PUE only","2/",24394244.601860203,0,380228.82262195653,24014015.779238246,41035249.575279303,0.58520457479999999]
["Conveyance Pumping","O'Neill Pump-Generator Plant","-",21784226.485602561,0,889919.2300000001,20894307.255602561,40038768.42857144,0.5218518969]
["Conveyance Pumping","Jones Pumping Plant: FK/Madera Exchange (class 1 only)","1/",41720940.351198502,0,32449.800000000003,41688490.551198505,30701894.645049259,1.3578474890000001]
["Conveyance Pumping","Jones Pumping Plant: All Other Contractors","1/",72646841.839114204,0,193450.28,72453391.559114203,50912541.982083797,1.4230951498]
["Total","Total Conveyance Pumping","-",204691083.3411516,0,2392031.7899999996,202299051.55115163,"-","-"]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",1314093.4537246439,0,31176.68,1282916.773724644,395171.85714285728,3.2464780842000001]
["Direct Pumping","Colusa County WD Relift PP","-",13585844.691823186,0,1601844.26,11984000.431823187,1660333.1428571437,7.2178288335999996]
["Direct Pumping","Colusa Service Area - Cortina","-",141792.21,0,2391.35,139400.85999999999,45321.714285714261,3.0758073077999999]
["Direct Pumping","Colusa Service Area - Davis","-",180305.28,0,8584.07,171721.21,130772.57142857148,1.3131286486]
["Direct Pumping","Contra Costa PP (Contra Costa WD)","-","-",0,0,0,"-","-"]
["Direct Pumping","Corning WD Relift PP","-",3244134.440391589,0,10799.51,3233334.9303915892,578432,5.5898272058999998]
["Direct Pumping","Dunnigan WD Relift PP","-",1711498.4957006846,0,73584.56,1637913.9357006846,468786.71428571409,3.4939427372999998]
["Direct Pumping","Kanawha WD Relift PP","-",2894870.5029078121,0,76451.350000000006,2818419.152907812,1353269.1428571437,2.0826745129000002]
["Direct Pumping","Orland-Artois WD Relift PP","-",7801344.6137431841,0,463212.6,7338132.0137431845,1748713.5714285709,4.1963030044999998]
["Direct Pumping","Panoche WD Relift PP","-",25322.38278506913,0,5547.99,19774.392785069133,1906454.4285714291,1.0372339600000001E-2]
["Direct Pumping","Proberta WD Relift PP","-",194940.59292118502,0,905.75,194034.84292118502,118760.42857142852,1.633834142]
["Direct Pumping","San Benito County WD: Gianelli, WR PGP","-",952345.32340596709,0,22599.600000000002,929745.72340596712,"-","-"]
["Direct Pumping","San Benito County WD: Pacheco PP","-",546914.05853696703,0,0,546914.05853696703,"-","-"]
["Total","Total San Benito County WD","-",1499259.3819429341,0,22599.600000000002,1476659.7819429343,603559.85714285728,2.4465838217]
["Direct Pumping","San Luis WD Canalside Relift PP","7/",12312991.894626001,0,1102349.69,11210642.204626001,2650676.7142857127,4.2293509971000001]
["Direct Pumping","Santa Nella County WD","7/",16961.710253648002,null,null,16961.710253648002,3651.428571428572,4.6452258127999997]
["Direct Pumping","Santa Clara Valley WD: Coyote PP","-",162401.15068289079,0,0,162401.15068289079,"-","-"]
["Direct Pumping","Santa Clara Valley WD: Gianelli, WR PGP","-",982522.05941015296,0,111255.41,871266.64941015292,"-","-"]
["Direct Pumping","Santa Clara Valley WD: Pacheco PP","-",564243.99502354907,0,0,564243.99502354907,"-","-"]
["Total","Total Santa Clara Valley WD","-",1709167.2051165928,0,111255.41,1597911.7951165927,622684.71428571455,2.5661651209]
["Direct Pumping","State Delta PP (CVC Contractors)","-",3080766.5431966698,0,88850.240000000005,2991916.3031966696,2406225.4285714277,1.2434064854]
["Direct Pumping","Westlands WD: Pleasant Valley Canalside Relifts","-",1372411.5482846929,0,0,1372411.5482846929,"-","-"]
["Direct Pumping","Westlands WD: Pleasant Valley PP","-",12723700.370463379,0,0,12723700.370463379,"-","-"]
["Direct Pumping","Westlands WD: Westlands WD Canalside Relifts","-",46556593.642123081,0,1735313.53,44821280.11212308,"-","-"]
["Total","Total Westlands WD","-",60652705.560871154,0,1735313.53,58917392.030871153,34005711.000000007,1.7325734501000001]
["Direct Pumping","Westside WD Canalside Relifts","-",7156894.6304457979,0,195248.66,6961645.9704457978,1723255.7142857146,4.0398217819999998]
["Total","Total Direct Pumping","-",117522893.59045015,0,5530115.2500000009,111992778.34045015,50421780.428571433,"-"]
["San Luis Drain","Panoche WD","3/",2590879.9780228399,0,0,2590879.9780228399,1906454.4285714291,"-"]
["San Luis Drain","San Luis WD","3/",3602281.3684189301,0,0,3602281.3684189301,2650676.7142857127,"-"]
["San Luis Drain","Santa Nella County WD","3/",4962.3139395890003,0,0,4962.3139395890003,3651.428571428572,"-"]
["San Luis Drain","Westlands WD ","3/",46183428.207237102,0,0,46183428.207237102,33983280.285714291,"-"]
["San Luis Drain","Total San Luis Drain","-",52381551.867618464,0,0,52381551.867618464,38544062.857142858,1.3590044220999999]
["Sub-total","Sub-total","-",1153026027.4165041,37851092.130000003,11997594.68,1103177340.6065042,"-","-"]
["Other Costs","Programmatic EIS Capitalized","4/",13902414.289501501,0,0,13902414.289501501,"-","-"]
["Other Costs","All Others","-",51894561.230000004,0,0,51894561.230000004,"-","-"]
["Total","Total Other Costs","-",65796975.519501507,0,0,65796975.519501507,129291812.82999018,0.50890287700000003]
["Grand Total","Grand Total","5/",1218823002.9360056,37851092.130000003,11997594.68,1168974316.1260056,"-","-"]
[]
["Footnotes"]
[]
["1/"]
["Jones Pumping Plant costs are allocated to the Delta Mendota Exchange Contractors and to all Others on the basis of their historical and projected deliveries."]
[]
["2/"]
["The Cross Valley Canal contractors are charged for PUE construction component only."]
[]
["3/"]
["San Luis Drain costs are allocated to Panoche WD, San Luis WD, Santa Nella County WD and Westlands WD on the basis of their historical and projected San Luis Canal deliveries. ",null,null,null,null,null,null,null,null,""]
[]
["4/"]
["In accordance with Public Law 102-575, Section 3409 - Environmental Review, the Programmatic Environmental Impact Statement (PEIS) costs are allocated based on"]
["the ratio of the Central Valley Project Plant-in-Service costs."]
[]
["5/",null,null,null,null,null,null,null,null,null,0]
["A reconciliation of the total net construction cost is as follows:"]
[]
["Amount to IRR Schedule A-2Bb\n(Non Intertie)\n(Reduced by Historical Assignment to M&I)","Amount to IRR Schedule A-2Bc\n(Intertie)","Amount to M&I Schedule A-2Bb\n(Historical Assignment to M&I)","Total"]
[1140284807.5774329,26955526.760000002,1733981.7885728951,1168974316.1260056]
[]
["6/"]
["For Folsom SOD Historical & Projected Deliveries are based on new 50-year repayment period beginning in 2024"]
[]
["7/"]
["San Luis WD Canalside Relift Pumping Plants costs are allocated to San Luis WD and Santa Nella County WD on the basis of their historical and projected San Luis Canal deliveries. "]