{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OUTPUTa","Footnotes_a"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":16,"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":"OUTPUTa","index":0,"n_rows":91,"n_cols":8,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2024 Sch A-2Ba F.Z26.XLSM"]
["12/16/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I ALLOCATED CONSTRUCTION COSTS PER ACRE-FOOT BY CONTRACTOR "]
["AS OF SEPTEMBER 30, 2022"]
["2024 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/2022\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/",5493.99532,5751.6465149484648,-257.65119494846476,44.684245999999995,"N/A"]
["Black Butte D&R","Elk Creek CSD","1/",2453.6741809999999,3449.5829488341815,-995.90876783418162,89.368492000000003,0]
["Black Butte D&R","US Forest Service - BB","-",1535.7911859999999,1142.2428721535671,393.54831384643285,56.539249000000005,6.96]
["Black Butte D&R","Whitney Const.","1/",3794.581514,5997.200255585477,-2202.618741585477,25.533855000000003,0]
["Total","Total Black Butte D&R","-",13278.042201,16340.672591521688,-3062.6303905216905,216.12584200000003,"-"]
["Clear Creek Unit","Clear Creek CSD","4/",639189.70134899998,707029.26614793262,-67839.564798932639,10032.069119,"N/A"]
["Total","Total Clear Creek Unit","-",639189.70134899998,707029.26614793262,-67839.564798932639,10032.069119,"-"]
["Contra Costa Canal","Contra Costa WD","4/",29113181.648173001,24327069.648062974,4786112.0001100264,517277.59500499995,"N/A"]
["Total","Total Contra Costa Canal","-",29113181.648173001,24327069.648062974,4786112.0001100264,517277.59500499995,"-"]
["Cow Creek Unit","Bella Vista WD","4/",2176931.4457129999,1945193.2805092609,231738.16520373896,23226.688524000001,"N/A"]
["Total","Total Cow Creek Unit","-",2176931.4457129999,1945193.2805092609,231738.16520373896,23226.688524000001,"-"]
["Cross Valley Canal","County of Fresno","4/",14895.872171000001,26256.624907127636,-11360.752736127635,548.97787500000004,"N/A"]
["Cross Valley Canal","County of Tulare","4/",53233.303671000001,54547.087142731099,-1313.783471731098,1225.6250250000001,"N/A"]
["Total","Total Cross Valley Canal","-",68129.175841999997,80803.712049858732,-12674.536207858733,1774.6029000000001,"-"]
["Delta-Mendota Canal","Byron Bethany ID","4/",271192.74239500001,228841.67109785063,42351.071297149378,4932.5935689999997,"N/A"]
["Delta-Mendota Canal","City of Tracy","4/",4974069.2877660003,4270247.2884369958,703821.99932900444,42929.705101,"N/A"]
["Delta-Mendota Canal","Del Puerto WD","4/",4778.6519859999999,5178.4674095680293,-399.81542356802947,19.150390000000002,"N/A"]
["Delta-Mendota Canal","Department of VA","4/",75831.894507000005,74909.18909185045,922.70541514955403,2549.7377740000002,"N/A"]
["Delta-Mendota Canal","Panoche WD","4/",10773.830508999999,12862.689664905552,-2088.8591559055531,154.11505099999999,"N/A"]
["Delta-Mendota Canal","San Luis WD","4/",45131.568170999999,93412.434414089395,-48280.866243089396,111.25465299999999,"N/A"]
["Delta-Mendota Canal","Santa Nella County WD",null,396.806939,0,396.806939,34.653087999999997,"N/A"]
["Total","Total Delta-Mendota Canal","-",5382174.782273001,4685451.7401152598,696723.04215774045,50731.209626000003,"-"]
["Folsom D&R","City of Folsom","4/",190442.98468299999,265579.04207500955,-75136.057392009563,18650.353020999999,"N/A"]
["Folsom D&R","City of Roseville","4/",5036545.7152039995,4723990.9641456865,312554.75105831306,143238.54128300003,"N/A"]
["Folsom D&R","El Dorado ID - FD&R","4/",1202318.9725339999,1060302.9833676377,142015.98916636221,24461.432781999996,"N/A"]
["Folsom D&R","Placer County WA","4/",186632.88340799999,183769.16,2863.7234079999907,31917.31834812697,"N/A"]
["Folsom D&R","Sacramento County  WA","4/",477372.98734400002,423636.7620171624,53736.225326837623,22483.470966999997,"N/A"]
["Folsom D&R","San Juan WD","4/",1070289.485233,1145785.4241367255,-75495.938903725473,1121.6657579999999,"N/A"]
["Total","Total Folsom D&R","-",8163603.0284059979,7803064.3357422221,360538.69266377785,241872.78215912697,"-"]
["Folsom-South Canal","East Bay MUD","4/",6821788.6727529997,5451607.7716263048,1370180.9011266949,41203.434140999998,"N/A"]
["Folsom-South Canal","Sacramento County  WA - FSC","4/",457513.96114000003,409321.48218484421,48192.478955155821,27359.525287000004,"N/A"]
["Folsom-South Canal","Sacramento MUD","4/",4860555.1412129998,4244793.8977761129,615761.24343688693,27359.525287000004,"N/A"]
["Total","Total Folsom-South Canal","-",12139857.775106,10105723.151587263,2034134.6235187375,95922.484714999999,"-"]
["Friant Dam","County of Madera","4/",23646.153364999998,24336.512470351088,-690.35910535108997,455.04976800000003,"N/A"]
["Friant Dam","Fresno County WW#18","3/",39503.207861000003,65078.376438867352,-25575.168577867349,820.731043,"N/A"]
["Total","Total Friant Dam","-",63149.361226000001,89414.88890921844,-26265.527683218439,1275.7808110000001,"-"]
["Friant-Kern Canal","Arvin-Edison WSD","3/",266706.22842100001,567156,-300449.77157899999,2942.7767509999999,"N/A"]
["Friant-Kern Canal","City of Fresno","3/",20956684.376715001,21385091,-428406.62328499928,266277.97966900002,"N/A"]
["Friant-Kern Canal","City of Lindsay","4/",789350.67501699994,784612.3210976494,4738.3539193505421,11177.444885999999,"N/A"]
["Friant-Kern Canal","City of Orange Cove","4/",493169.928029,516952.15475467301,-23782.226725673012,7008.131187,"N/A"]
["Friant-Kern Canal","Delano-Earlimart ID","3/",73779.269816999993,34792,38987.269816999993,2088.4565299999999,"N/A"]
["Friant-Kern Canal","Lindsay-Strathmore ID","3/",147554.63865199999,65349,82205.638651999994,3770.8031820000001,"N/A"]
["Friant-Kern Canal","Shafter-Wasco ID","3/",115825.352574,150417,-34591.647425999996,835.32181700000001,"N/A"]
["Friant-Kern Canal","Terra Bella ID","3/",391704.08966300002,362028,29676.089663000021,9361.805432000001,"N/A"]
["Total","Total Friant-Kern Canal","-",23234774.558887996,23866397.475852322,-631622.91696432163,303462.71945400012,"-"]
["New Melones D & R","Stockton-East WD","4/",3144937.8513210001,2617079.0034048967,527858.84791610343,147972.335555,"N/A"]
["Total","Total New Melones D & R","-",3144937.8513210001,2617079.0034048967,527858.84791610343,147972.335555,"-"]
["Sacramento River","City of Redding - SR    ","-",737717.86147899996,684215.72566022421,53502.135818775743,15109.658505999998,3.54]
["Sacramento River","City of West Sacramento","4/",1207179.0964820001,1252812.9408804043,-45633.844398404239,36544.417585999996,"N/A"]
["Sacramento River","Lake California P.O.A.","-",41229.574809999998,37331.695146091835,3897.8796639081629,1048.7118889999999,3.72]
["Sacramento River","Riverview Golf & CC   ","-",5692.2048370000002,5406.7046531546193,285.50018384538089,131.316968,2.17]
["Total","Total Sacramento River","-",1991818.7376079999,1979767.0663398749,12051.671268125048,52834.104948999993,"-"]
["San Felipe Unit","San Benito County WD","4/",2291937.274857,2101243.8146265345,190693.46023046551,34412.34072,"N/A"]
["San Felipe Unit","Santa Clara Valley WD","4/",50566210.250671998,49313872.268952124,1252337.9817198738,542695.63541300001,"N/A"]
["Total","Total San Felipe Unit","-",52858147.525528997,51415116.083578661,1443031.4419503394,577107.97613299999,"-"]
["San Luis Canal - Fresno","City of Avenal","4/",1227558.538185,993952.8865049103,233605.65168008965,15081.388881000001,"N/A"]
["San Luis Canal - Fresno","City of Coalinga","4/",3361120.8345340001,2942022.9918762548,419097.84265774535,35770.194635,"N/A"]
["San Luis Canal - Fresno","City of Huron","4/",562564.22531000001,549650.34709174116,12913.878218258847,6620.5637490000008,"N/A"]
["San Luis Canal - Fresno","State of CA","4/",2974.2504669999998,3816.5235603185706,-842.27309331857077,8.2073089999999986,"N/A"]
["San Luis Canal - Fresno","Westlands WD","4/",3085696.2842549998,2386063.156135302,699633.12811969779,18450.945776,"N/A"]
["Total","Total San Luis Canal - Fresno","-",8239914.1327509992,6875505.9051685268,1364408.2275824731,75931.300350000005,"-"]
["San Luis Canal - Tracy","Pacheco WD - SLC","4/",6258.352312,4683.4722265700984,1574.8800854299016,70.218098999999995,"N/A"]
["San Luis Canal - Tracy","Panoche WD - SLC","4/",39636.769244000003,30116.142052658608,9520.6271913413948,942,"N/A"]
["San Luis Canal - Tracy","San Luis WD - SLC ","4/",443403.78879299999,468583.62799065432,-25179.839197654335,3289,"N/A"]
["San Luis Canal - Tracy","Santa Nella County WD",null,5715.9442330000002,0,5715.9442330000002,369]
["Total","Total San Luis Canal - Tracy","-",495014.854582,503383.24226988305,-8368.3876878830397,4670.2180989999997,"-"]
["Shasta D&R","Centerville CSD","4/",152272.95641899999,125414.06064484049,26858.895774159508,3268,"N/A"]
["Shasta D&R","Mountain Gate CSD ","4/",137126.398457,110944.35997262938,26182.038484370627,2954.6317570000001,"N/A"]
["Shasta D&R","Shasta CWA ","4/",34935.692378,28351.00735963332,6584.6850183666793,630.13905699999998,"N/A"]
["Total","Total Shasta D&R","-",324335.04725399998,264709.42797710322,59625.619276896818,6852.7708140000004,"-"]
["Spring Creek Conduit","City of Redding - SCC","4/",744216.87216599996,507358.26130576804,236858.61086023191,33014.362176000002,"N/A"]
["Spring Creek Conduit","Shasta CWA - SCC","4/",26818.146648999998,23470.461785254123,3347.6848637458752,414.925139,"N/A"]
["Spring Creek Conduit","Shasta CSD","4/",114168.016317,103223.43902894766,10944.577288052344,1659.7005549999999,"N/A"]
["Total","Total Spring Creek Conduit","-",885203.03513199999,634052.16211996973,251150.87301203015,35088.987870000004,"-"]
["Tehama-Colusa Canal","Colusa County WD","4/",75177.542302999995,70079.793622727258,5097.7486802727362,804.31642299999999,"N/A"]
["Tehama-Colusa Canal","Kanawha WD","4/",5492.3709230000004,1672.0256284157374,3820.3452945842628,175.089291,"N/A"]
["Total","Total Tehama-Colusa Canal","-",80669.91322599999,71751.819251142995,8918.0939748569981,979.40571399999999,"-"]
["Toyon Pipeline","City of Redding - TP ","4/",39078.831187000003,229325.44762038617,-190246.61643338617,104.871188,"N/A"]
["Toyon Pipeline","City of Shasta Lake  ","4/",1302683.8588030001,1612338.3640517183,-309654.5052487182,7117.5619910000005,"N/A"]
["Toyon Pipeline","US Forest Service    ","1/",2208.5903170000001,4961.8425938732953,-2753.2522768732952,6.383462999999999,0]
["Total","Total Toyon Pipeline","-",1343971.280307,1846625.6542659779,-502654.37395897764,7228.8166420000007,"-"]
["Grand Total","Grand Total                    ","-",150358281.896887,139834478.53594387,10523803.360943133,2154457.9742811266,"-"]

{"sheet":"Footnotes_a","index":1,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["M&I 2024 Sch A-2Ba F.Z26.XLSM"]
["12/16/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I ALLOCATED CONSTRUCTION COSTS PER ACRE-FOOT BY CONTRACTOR "]
["AS OF SEPTEMBER 30, 2022"]
["2024 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."]
[]
["Const. repayment per Sch A-6","Const. 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."]
[]
[]
[null,"Reconciliation:"]
[null,"City of Tracy's allocated Construction Cost and Construction Repayment have been adjusted to include assigned historical costs and revenues from Banta-Carbona ID and West Side ID.  "]
[null,"Refer to the 2020 Irrigation Water Rates, Schedule A-2Ba, footnotes 4/ for assigned revenues and Schedule A-2Bb, footnote 4/ for assigned historical construction costs."]
[]
[]
[null,null,"Assigned "]
[null,null,"Historical","Assigned"]
[null,null,"Construction Costs","Revenues"]
[]
[null,"Banta-Carbona ID",857109.38896000001,263272.11]
[null,"West Side ID",374028.452934,163510.96]
[null,"West Side ID",471645.90349200001,352362.36]
[null,"Total",1702783.745386,779145.42999999993]
[]
[]
[null,"Total Allocated Costs",150358281.896887]
[null,"Less: Assigned Costs ",1702783.745386]
[null,"Subtotal",148655498.151501]
[]
[null,null,0]
[null,"Total per Schedule A-4",148655498.151501]