{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OUTPUTa","Footnotes_a"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":20,"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":"OUTPUTa","index":0,"n_rows":91,"n_cols":8,"rows_kept":91,"cut":false,"hidden":false,"merged":[[94,1,94,7]]}
[]
["M&I 2025 Sch A-2Ba F.Z27.XLSM"]
["09/29/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I ALLOCATED CONSTRUCTION COSTS PER ACRE-FOOT BY CONTRACTOR "]
["AS OF SEPTEMBER 30, 2023"]
["2025 M&I WATER RATES"]
[]
["Category","A) Contractor","Related Footnotes","B) Construction Cost: Allocated Construction Cost\n\n<Sch A-2Bb>","C) Construction Cost: Repayment as of 09/30/2023\n\n<Sch A-6>","D) Construction Cost: Unpaid Allocated Construction Cost\n\n(B-C)","Present Worth Projected Deliveries 2024-2030\n\n<Sch A-13>","Allocated Construction Cost Per Acre-Foot\n\n(D/E)"]
["Black Butte D&R","County of Colusa","4/",5557.7943670000004,5751.6465149484648,-193.85214794846434,38.616169999999997,"N/A"]
["Black Butte D&R","Elk Creek CSD","1/",2416.2275509999999,3449.5829488341815,-1033.3553978341815,75.687691999999998,0]
["Black Butte D&R","US Forest Service - BB","-",1455.3885250000001,1142.2428721535671,313.14565284643299,37.843844999999995,8.27]
["Black Butte D&R","Whitney Const.","1/",3819.8061280000002,5997.200255585477,-2177.3941275854768,21.625053999999999,0]
["Total","Total Black Butte D&R","-",13249.216571000001,16340.672591521688,-3091.4560205216894,173.772761,"-"]
["Clear Creek Unit","Clear Creek CSD","4/",641766.42743399995,707029.26614793262,-65262.838713932666,8723.3925909999998,"N/A"]
["Total","Total Clear Creek Unit","-",641766.42743399995,707029.26614793262,-65262.838713932666,8723.3925909999998,"-"]
["Contra Costa Canal","Contra Costa WD","4/",29120501.300941002,24327069.648062974,4793431.6528780274,410364.760755,"N/A"]
["Total","Total Contra Costa Canal","-",29120501.300941002,24327069.648062974,4793431.6528780274,410364.760755,"-"]
["Cow Creek Unit","Bella Vista WD","4/",2162711.1225749999,1961233.2322661148,201477.89030888514,18852.413736999999,"N/A"]
["Total","Total Cow Creek Unit","-",2162711.1225749999,1961233.2322661148,201477.89030888514,18852.413736999999,"-"]
["Cross Valley Canal","County of Fresno","4/",14338.952456999999,26256.624907127636,-11917.672450127637,548.955332,"N/A"]
["Cross Valley Canal","County of Tulare","4/",52128.386580999999,54547.087142731099,-2418.7005617311006,1225.574695,"N/A"]
["Total","Total Cross Valley Canal","-",66467.339038000006,80803.712049858732,-14336.373011858737,1774.530027,"-"]
["Delta-Mendota Canal","Byron Bethany ID","4/",285309.67914999998,228841.67109785063,56468.008052149351,4652.4760490000008,"N/A"]
["Delta-Mendota Canal","City of Tracy","4/",5007471.8768779999,4270247.2884369958,737224.58844100405,38426.949836,"N/A"]
["Delta-Mendota Canal","Del Puerto WD","4/",5340.2915389999998,5178.4674095680293,161.8241294319705,39.388493000000004,"N/A"]
["Delta-Mendota Canal","Department of VA","4/",74220.844987000004,74909.18909185045,-688.34410485044646,2072.9159560000003,"N/A"]
["Delta-Mendota Canal","Panoche WD","4/",10827.901464,12862.689664905552,-2034.788200905552,128.978004,"N/A"]
["Delta-Mendota Canal","San Luis WD","4/",45061.011706999998,93412.434414089395,-48351.422707089398,69.50910300000001,"N/A"]
["Delta-Mendota Canal","Santa Nella County WD",null,349.88117,0,349.88117,29.348288000000004,"N/A"]
["Total","Total Delta-Mendota Canal","-",5428581.4868950015,4685451.7401152598,743129.74677973986,45419.565728999994,"-"]
["Folsom D&R","City of Folsom","4/",211459.945675,245285.31207500954,-33825.366400009545,17337.115263,"N/A"]
["Folsom D&R","City of Roseville","4/",5067238.9441170003,4723990.9641456865,343247.97997131385,118039.58862199998,"N/A"]
["Folsom D&R","El Dorado ID - FD&R","4/",1213379.550183,1258018.9833676377,-44639.433184637688,20077.318619000001,"N/A"]
["Folsom D&R","Placer County WA","4/",184297.40320599999,183769.16,528.24320599998464,27031.318344312178,"N/A"]
["Folsom D&R","Sacramento County  WA","4/",469699.56393800001,423636.7620171624,46062.801920837606,15732.999600000001,"N/A"]
["Folsom D&R","San Juan WD","4/",1148160.2462859999,1145785.4241367255,2374.8221492744051,5908.2738679999993,"N/A"]
["Total","Total Folsom D&R","-",8294235.6534050005,7980486.6057422217,313749.04766277864,204126.61431631213,"-"]
["Folsom-South Canal","East Bay MUD","4/",6730098.6392799998,5451607.7716263048,1278490.8676536949,24648.700712999998,"N/A"]
["Folsom-South Canal","Sacramento County  WA - FSC","4/",444493.70822700002,409321.48218484421,35172.226042155817,23171.246084999999,"N/A"]
["Folsom-South Canal","Sacramento MUD","4/",4872450.3348629996,4244793.8977761129,627656.43708688673,23171.246084999999,"N/A"]
["Total","Total Folsom-South Canal","-",12047042.68237,10105723.151587263,1941319.5307827375,70991.192882999996,"-"]
["Friant Dam","County of Madera","4/",23426.405176,24336.512470351088,-910.10729435108806,377.666133,"N/A"]
["Friant Dam","Fresno County WW#18","3/",39757.556941000003,65078.376438867352,-25320.819497867349,698.95266000000004,"N/A"]
["Total","Total Friant Dam","-",63183.962117000003,89414.88890921844,-26230.926792218437,1076.6187930000001,"-"]
["Friant-Kern Canal","Arvin-Edison WSD","3/",265580.39026199997,567156,-301575.60973800003,2377.9836909999999,"N/A"]
["Friant-Kern Canal","City of Fresno","3/",21338031.525361001,21385091,-47059.474638998508,232169.67629,"N/A"]
["Friant-Kern Canal","City of Lindsay","4/",787419.82702199998,784612.3210976494,2807.5059243505821,9389.9076700000005,"N/A"]
["Friant-Kern Canal","City of Orange Cove","4/",497349.14124800003,516952.15475467301,-19603.013506672985,5953.8409460000003,"N/A"]
["Friant-Kern Canal","Delano-Earlimart ID","3/",69804.674635000003,34792,35012.674635000003,1673.6247670000002,"N/A"]
["Friant-Kern Canal","Lindsay-Strathmore ID","3/",142798.95362700001,65349,77449.95362700001,2659.8817260000001,"N/A"]
["Friant-Kern Canal","Shafter-Wasco ID","3/",118702.775893,150417,-31714.224107000002,822.52440200000001,"N/A"]
["Friant-Kern Canal","Terra Bella ID","3/",389599.17341500003,362028,27571.173415000027,7586.5325729999995,"N/A"]
["Total","Total Friant-Kern Canal","-",23609286.461463004,23866397.475852322,-257111.01438932092,262633.97206499998,"-"]
["New Melones D & R","Stockton-East WD","4/",3416060.627663,3267654.9534048969,148405.67425810313,153506.22293600001,"N/A"]
["Total","Total New Melones D & R","-",3416060.627663,3267654.9534048969,148405.67425810313,153506.22293600001,"-"]
["Sacramento River","City of Redding - SR    ","-",745003.49490399996,699344.12319218938,45659.371711810585,12578.830911000001,3.63]
["Sacramento River","City of West Sacramento","4/",1183678.3202869999,1252812.9408804043,-69134.620593404397,27256.836772000002,"N/A"]
["Sacramento River","Lake California P.O.A.","-",41876.567556000002,38963.096070434141,2913.4714855658603,888.17188899999996,3.28]
["Sacramento River","Riverview Golf & CC   ","-",5779.164143,5584.3487446719728,194.81539832802719,111.214569,1.75]
["Total","Total Sacramento River","-",1976337.5468899999,1996704.5088876998,-20366.961997699924,40835.054141000008,"-"]
["San Felipe Unit","San Benito County WD","4/",2456111.9352460001,2101243.8146265345,354868.1206194656,35208.678305999994,"N/A"]
["San Felipe Unit","Santa Clara Valley WD","4/",51741323.587986,49313872.268952124,2427451.3190338761,494408.99110499996,"N/A"]
["Total","Total San Felipe Unit","-",54197435.523231998,51415116.083578661,2782319.4396533417,529617.66941099998,"-"]
["San Luis Canal - Fresno","City of Avenal","4/",1238711.126497,993952.8865049103,244758.23999208969,13009.015033,"N/A"]
["San Luis Canal - Fresno","City of Coalinga","4/",3328992.9508329998,2942022.9918762548,386969.95895674499,29356.011723,"N/A"]
["San Luis Canal - Fresno","City of Huron","4/",563484.84889799997,549650.34709174116,13834.501806258806,5611.7016890000004,"N/A"]
["San Luis Canal - Fresno","State of CA","4/",3003.1291030000002,3816.5235603185706,-813.3944573185704,6.9509099999999995,"N/A"]
["San Luis Canal - Fresno","Westlands WD","4/",3218431.9865760002,2386063.156135302,832368.83044069819,16065.098653999999,"N/A"]
["Total","Total San Luis Canal - Fresno","-",8352624.0419070004,6875505.9051685268,1477118.1367384731,64048.778009000001,"-"]
["San Luis Canal - Tracy","Pacheco WD - SLC","4/",6176.8905409999998,4683.4722265700984,1493.4183144299013,59.468900999999995,"N/A"]
["San Luis Canal - Tracy","Panoche WD - SLC","4/",40735.626201999999,30116.142052658608,10619.484149341391,854,"N/A"]
["San Luis Canal - Tracy","San Luis WD - SLC ","4/",441472.13036100002,468583.62799065432,-27111.497629654303,2686,"N/A"]
["San Luis Canal - Tracy","Santa Nella County WD",null,7292.6450130000003,0,7292.6450130000003,312,23.37]
["Total","Total San Luis Canal - Tracy","-",495677.29211700003,503383.24226988305,-7705.9501528830087,3911.4689010000002,"-"]
["Shasta D&R","Centerville CSD","4/",152251.42865300001,125414.06064484049,26837.368008159523,2656,"N/A"]
["Shasta D&R","Mountain Gate CSD ","4/",139477.76149,110944.35997262938,28533.401517370628,2630.5334360000002,"N/A"]
["Shasta D&R","Shasta CWA ","4/",34895.279435999997,28351.00735963332,6544.2720763666766,473.43423300000001,"N/A"]
["Total","Total Shasta D&R","-",326624.46957899997,264709.42797710322,61915.041601896824,5759.9676689999997,"-"]
["Spring Creek Conduit","City of Redding - SCC","4/",753472.06632099999,507358.26130576804,246113.80501523195,28559.746316000001,"N/A"]
["Spring Creek Conduit","Shasta CWA - SCC","4/",26460.753181,23470.461785254123,2990.2913957458768,291.93823699999996,"N/A"]
["Spring Creek Conduit","Shasta CSD","4/",115465.53297,103223.43902894766,12242.093941052342,1458.1465450000001,"N/A"]
["Total","Total Spring Creek Conduit","-",895398.35247200006,634052.16211996973,261346.19035203016,30309.831097999999,"-"]
["Tehama-Colusa Canal","Colusa County WD","4/",74452.838472000003,70079.793622727258,4373.0448492727446,628.67123200000003,"N/A"]
["Tehama-Colusa Canal","Kanawha WD","4/",5664.7927600000003,1672.0256284157374,3992.7671315842626,156.009322,"N/A"]
["Total","Total Tehama-Colusa Canal","-",80117.631232,71751.819251142995,8365.8119808570082,784.68055400000003,"-"]
["Toyon Pipeline","City of Redding - TP ","4/",39325.14028,229325.44762038617,-190000.30734038618,84.955572999999987,"N/A"]
["Toyon Pipeline","City of Shasta Lake  ","4/",1302851.8687779999,1612338.3640517183,-309486.49527371838,6059.6492490000001,"N/A"]
["Toyon Pipeline","US Forest Service    ","1/",2219.4215389999999,4961.8425938732953,-2742.4210548732954,5.4062650000000003,0]
["Total","Total Toyon Pipeline","-",1344396.4305969998,1846625.6542659779,-502229.22366897785,6150.0110869999999,"-"]
["Grand Total","Grand Total                    ","-",152531697.56849802,140695454.15024853,11836243.418249456,1859060.517463312,"-"]

{"sheet":"Footnotes_a","index":1,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["M&I 2025 Sch A-2Ba F.Z27.XLSM"]
["09/29/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I ALLOCATED CONSTRUCTION COSTS PER ACRE-FOOT BY CONTRACTOR "]
["AS OF SEPTEMBER 30, 2023"]
["2025 M&I WATER RATES"]
[]
["Footnotes:"]
[]
["1/"]
["Contractor has satisfied their obligation of allocated construction costs as of 9/30/2020."]
[]
["2/"]
["Allocated construction cost and repayment include historical costs and repayment associated with assignment from Banta Carbona ID and West side ID."]
["Construction Cost Repayment as of 9/30/2020 also includes contributed fund of $32,214.50 for DMC Intertie."]
[]
["Construction repayment per Sch A-6","Construction repayment per assignment","Additional repayment DMC Intertie ","Total repayment"]
[4270247.2884369958,779145.42999999993,32214.5,5081607.2184369955]
[]
["3/"]
["Contractor has entered into a 9(d) repayment contract for construction repayment."]
[]
["4/"]
["Construction component of rate is adjusted to reflect executed WIIN Act contracts."]