{"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":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":[]}
[]
["M&I 2025 Sch A-4 F.Z27.XLSM"]
["09/29/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I CONSTRUCTION COSTS TO BE REPAID BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2023"]
["2025 M&I WATER RATES"]
[]
["Category","A) Component / Facility","Related Footnotes","B) Total Allocated Construction Costs as of 9/30/23\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/23\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","-",10657911.92,815672.63000000012,9842239.2899999991,3960975.9999999991,2.4848015463999999]
["Storage","All Other Contractors","-",41672303.405328751,509170.12,41163133.285328753,13811368.091428567,2.9803805831000001]
["Total","  Total Storage","-",52330215.325328752,1324842.75,51005372.575328752,"-","-"]
["Conveyance","Contra Costa Canal System   ","-",0,0,0,"-","-"]
["Conveyance","All Other Contractors","-",27236680.960000001,295505.88999999996,26941175.07,9575789.9999999981,2.8134676168000001]
["Total","Total Conveyance","-",27236680.960000001,295505.88999999996,26941175.07,"-","-"]
["Conveyance Pumping","Dos Amigos PP, Construction only","-",295165.75,7700.75,287465,637622.29537074966,0.45083900310000002]
["Conveyance Pumping","Dos Amigos PP, PUE only","-",607830.8669254391,0,607830.8669254391,646281.29537074966,0.94050511950000004]
["Conveyance Pumping","O'Neill Pump-Generator Plant","-",3757366.3828376438,158863.57,3598502.812837644,4632793.9999999991,0.7767456988]
["Conveyance Pumping","Jones PP, FK/Madera Exchange ","1/",4246097.68,0,4246097.68,2585824.9999999995,1.6420669148]
["Conveyance Pumping","Jones PP, All Other Contractors","1/",8507628.25,22818.520000000004,8484809.7300000004,5038675.9999999991,1.6839363615]
["Total","Total Conveyance Pumping","-",17414088.929763082,189382.84000000003,17224706.089763083,"-","-"]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",943319.09327223804,60913.26,882405.83327223803,170175.00000000009,5.1852847554999997]
["Direct Pumping","Colusa County WD Relift PP","-",38257.458734849097,0,38257.458734849097,4811.0000000000027,7.9520803855000004]
["Direct Pumping","Contra Costa PP (Contra Costa WD)","-",5528366.6969774608,4056,5524310.6969774608,5009811.9999999972,1.1026982044]
["Direct Pumping","Kanawha WD Relift PP","-",2030.9602069455466,0,2030.9602069455466,482.99999999999983,4.2048865568]
["Direct Pumping","Pleasant Valley PP (City of Coalinga)","-",220864.49166816572,6217.7199999999993,214646.77166816572,270267,0.79420266500000003]
["Direct Pumping","Pleasant Valley WD Canalside Relift PP","-",39926.8866050219,0,39926.8866050219,270267,0.147731268]
["Direct Pumping","San Benito County WD, Pacheco PP","-",265976.79726804898,0,265976.79726804898,"-","-"]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",445370.86274010001,15649.349999999999,429721.51274010004,"-","-"]
["Total","   Total San Benito County WD","-",711347.66000814899,15649.349999999999,695698.31000814901,185529.99999999994,3.7497887674000001]
["Direct Pumping","San Luis WD Canalside Relifts & Turnouts","-",85437.353435033307,0,85437.353435033307,36122,2.3652442676000001]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",1557831.687735518,0,1557831.687735518,"-","-"]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",5412499.5153633691,0,5412499.5153633691,"-","-"]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",9063091.6080522798,115667.27,8947424.3380522802,"-","-"]
["Total","   Total Santa Clara WD","-",16033422.811151167,115667.27,15917755.541151168,3775445.9999999991,4.2161258672999997]
["Direct Pumping","Shasta PP (City of Shasta Lake)","-",614442.54964353004,16388.68,598053.86964352999,93680.000000000015,6.3840080021999999]
["Direct Pumping","State Delta PP (Cross Valley Canal)","-",17539.656543939338,0,17539.656543939338,8659,2.0255983997999998]
["Direct Pumping","Westlands WD Relifts","-",918597.10857523931,4987.08,913610.02857523935,202612.99999999994,4.5091382515999996]
["Total","Total Direct Pumping","-",25153552.726821739,223879.36,24929673.36682174,"-","-"]
["Sub-total","Sub-total","-",122134537.94191356,2033610.8399999999,120100927.10191357,"-","-"]
["Other Costs","Deferred Interest Capitalized  ","-",21277763,0,21277763,"-","-"]
["Other Costs","Programmatic EIS Capitalized","2/",1624377.1273268,0,1624377.1273268,"-","-"]
["Other Costs","All others","-",7837166.455000001,0,7837166.455000001,"-","-"]
["Total","Total Other Costs","-",30739306.582326803,0,30739306.582326803,17772344.091428567,1.7296146430999999]
["Grand Total","   Grand Total","-",152873844.52424037,2033610.8399999999,150840233.68424037,"-","-"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,""]

{"sheet":"Footnotes","index":1,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["M&I 2025 Sch A-4 F.Z27.XLSM"]
["09/13/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I CONSTRUCTION COSTS TO BE REPAID BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2023"]
["2025 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",2514767.9085849989,0.33292997699999999,4246097.68]
["All Other Contractors",5038675.9999999991,0.66707002299999996,8507628.25]
["Total",7553443.908584998,1,12753725.93]
[]
["2/"]
["In accordance with Public Law 102-575, Section 3409 - Environmental Review, programmatic environmental impact statement (PEIS) costs treated as construction costs."]