{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OUTPUT","Footnotes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"comments":1,"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":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2024 Sch A-4 F.Z26.XLSM"]
["09/28/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I CONSTRUCTION COSTS TO BE REPAID BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2022"]
["2024 M&I WATER RATES"]
[]
["Category","A) Component / Facility","Related Footnotes","B) Total Allocated Construction Costs as of 9/30/22\n\n<Sch A-5>","C) Cumulative Allocation of Miscellaneous M&I Revenue\n\n<Sch B-2>","D) Net Construction Costs as of 9/30/22\n\n(B-C)","E) Historical & Projected Deliveries 1981-2030\n\n<Sch A-7>","F) 50 - YR Construction Cost Per A/F\n\n(D/E)"]
["Storage","San Felipe Unit Contractors","-",10241241.85,809388.1100000001,9431853.7400000002,3884512.7142857155,2.4280661266000001]
["Storage","All Other Contractors","-",40926627.577021264,439230.8,40487396.777021267,13813593.853333332,2.9309821330000001]
["Folsom SOD","San Felipe Unit Contractors","3/",868475.55,null,868475.55,4520335.7142857164,0.1921263386]
["Folsom SOD","All Other Contractors","3/",2373592.84,null,2373592.84,12354704.761904765,0.1921205634]
["Total","  Total Storage","-",54409937.817021266,1248618.9100000001,53161318.907021269,"-","-"]
["Conveyance","Contra Costa Canal System   ","-",0,0,0,"-","-"]
["Conveyance","All Other Contractors","-",26956531.329999991,288911.73,26667619.59999999,9505391.8571428563,2.8055255375999999]
["Total","Total Conveyance","-",26956531.329999991,288911.73,26667619.59999999,"-","-"]
["Conveyance Pumping","Dos Amigos PP, Construction only","-",287010.99499999988,4604.8099999999995,282406.18499999988,640040.02975112537,0.44123206650000002]
["Conveyance Pumping","Dos Amigos PP, PUE only","-",610621.29445152404,0,610621.29445152404,648977.02975112537,0.94089816199999998]
["Conveyance Pumping","O'Neill Pump-Generator Plant","-",3688105.5412080931,143241.73000000001,3544863.8112080931,4559118.5714285728,0.7775327085]
["Conveyance Pumping","Jones PP, FK/Madera Exchange ","1/",4204904.8600000003,0,4204904.8600000003,2562658.1428571423,1.6408372189]
["Conveyance Pumping","Jones PP, All Other Contractors","1/",8331778.21,18027.080000000002,8313751.1299999999,4961809.8571428582,1.6755481103000001]
["Total","Total Conveyance Pumping","-",17122420.900659617,165873.62,16956547.280659616,"-","-"]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",945964.33537456102,60913.26,885051.07537456101,173140.57142857136,5.1117486102000003]
["Direct Pumping","Colusa County WD Relift PP","-",38370.190829280757,0,38370.190829280757,4933,7.7782669429000002]
["Direct Pumping","Contra Costa PP (Contra Costa WD)","-",5579969.2961099595,0,5579969.2961099595,5054462,1.1039689874]
["Direct Pumping","Kanawha WD Relift PP","-",1959.9055208682541,0,1959.9055208682541,473.42857142857156,4.1398125064000002]
["Direct Pumping","Pleasant Valley PP (City of Coalinga)","-",214625.44948866754,3511.24,211114.20948866755,274130.57142857136,0.7701228228]
["Direct Pumping","Pleasant Valley WD Canalside Relift PP","-",53245.441992766602,0,53245.441992766602,274130.57142857136,0.19423387080000001]
["Direct Pumping","San Benito County WD, Pacheco PP","-",249835.34593094399,0,249835.34593094399,"-","-"]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",418267.48871040705,15649.349999999999,402618.13871040707,"-","-"]
["Total","   Total San Benito County WD","-",668102.83464135102,15649.349999999999,652453.48464135104,174197.85714285704,3.7454736547]
["Direct Pumping","San Luis WD Canalside Relifts & Turnouts","-",86055.487861171889,0,86055.487861171889,36368.142857142877,2.3662326722999998]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",1531596.6072296952,0,1531596.6072296952,"-","-"]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",5321350.1028961595,0,5321350.1028961595,"-","-"]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",8908862.5348242596,115667.27,8793195.26482426,"-","-"]
["Total","   Total Santa Clara WD","-",15761809.244950114,115667.27,15646141.974950114,3710314.8571428582,4.2169310630999997]
["Direct Pumping","Shasta PP (City of Shasta Lake)","-",616225.97753402707,16388.68,599837.29753402702,94197,6.3679023486000004,0]
["Direct Pumping","State Delta PP (Cross Valley Canal)","-",18110.338307963761,0,18110.338307963761,8937,2.0264449265,0]
["Direct Pumping","Westlands WD Relifts","-",814993.6073971818,3501.54,811492.06739718176,201316.42857142864,4.0309281918000002]
["Total","Total Direct Pumping","-",24799432.110007912,215631.34000000003,24583800.770007912,"-","-"]
["Sub-total","Sub-total","-",123288322.1576888,1919035.6000000003,121369286.55768879,"-","-"]
["Other Costs","Deferred Interest Capitalized  ","-",21277763,0,21277763,"-","-"]
["Other Costs","Programmatic EIS Capitalized","2/",1608832.8485963999,0,1608832.8485963999,"-","-"]
["Other Costs","All others","-",7641684.1350000007,0,7641684.1350000007,"-","-"]
["Total","Total Other Costs","-",30528279.983596403,0,30528279.983596403,17698106.567619048,1.7249461047000001]
["Grand Total","   Grand Total","-",153816602.14128521,1919035.6000000003,151897566.54128519,"-","-"]

{"sheet":"Footnotes","index":1,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["M&I 2024 Sch A-4 F.Z26.XLSM"]
["09/28/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I CONSTRUCTION COSTS TO BE REPAID BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2022"]
["2024 M&I WATER RATES"]
[]
["Footnotes:"]
[]
["1/"]
["Suballocation of Jones Pumping Plant costs is as follows:"]
[]
["Jones Pumping Plant","Historical & Projected Deliveries (1981-2030) \n\n(Sch. A-7)","Ratio","Allocated Costs"]
["Delta-Mendota Exchange",2504139.9169388572,0.33540808500000002,4204904.8600000003]
["All Other Contractors",4961809.8571428582,0.66459191500000003,8331778.21]
["Total",7465949.7740817154,1,12536683.07]
[]
["2/"]
["In accordance with Public Law 102-575, Section 3409 - Environmental Review, programmatic environmental impact statement (PEIS) costs treated as construction costs."]
[]
["3/"]
["For Folsom SOD Historical & Projected Deliveries are based on new 50-year repayment period beginning in 2024."]