{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Storage"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":26,"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":"Storage","index":0,"n_rows":101,"n_cols":17,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2023 Sch B-4A F.Z26.XLSM"]
["08/07/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF FY 2023 ALLOCATED M&I STORAGE EXPENSE"]
["BY COMPONENT AND CONTRACTOR"]
[]
["Category","A) Contractor","Related Footnotes","B) Total A/F\n<Sch B-2>","C) Ratio of A/F by Contractor\n(B/ (Total A/F))","D) Allocated Storage Expense\n(C * Total Expense)"]
["Total","Total All Other Contractors","-","-","-",4391443.32011698]
["Total","Total San Felipe Unit","1/","-","-",1349898.2798830206]
["Black Butte D & R","County of Colusa","-",6,2.40229E-5,105.495204]
["Black Butte D & R","Elk Creek CSD","-",0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"(D12/$D$92)*$F$92-(F12)","v":0}]
["Black Butte D & R","US Forest Service - BB","-",1,4.0037999999999997E-6,17.582460999999999]
["Black Butte D & R","Whitney Const.","-",0,0,0]
["Total","Total Black Butte D & R","-",7,2.8026700000000001E-5,123.077665]
["Clear Creek Unit","Clear Creek CSD","-",914,3.6594838000000001E-3,16070.415688999999]
["Total","Total Clear Creek Unit","-",914,3.6594838000000001E-3,16070.415688999999]
["Contra Costa Canal","Contra Costa WD ","-",72284,0.28941151980000002,1270934.2853910001]
["Total","Total Contra Costa Canal","-",72284,0.28941151980000002,1270934.2853910001]
["Cow Creek Unit","Bella Vista WD","-",1733,6.9386055999999998E-3,30470.493213000002]
["Total","Total Cow Creek Unit","-",1733,6.9386055999999998E-3,30470.493213000002]
["Cross Valley Canal","County of Fresno","-",0,0,0]
["Cross Valley Canal","County of Tulare","-",0,0,0]
["Total","Total Cross Valley Canal","-",0,"-",0]
["Delta-Mendota Canal","Byron Bethany ID","-",1464,5.8615802E-3,25740.797214999999]
["Delta-Mendota Canal","City of Tracy","-",6166,2.46875025E-2,108413.76794400001]
["Delta-Mendota Canal","Del Puerto WD","-",30,1.201143E-4,527.47514000000001,null,null,null,null,null,null,""]
["Delta-Mendota Canal","Department of VA","-",273,1.0930406E-3,4800.0258409999997]
["Delta-Mendota Canal","Panoche WD - DMC","-",23,9.2087699999999996E-5,404.39791500000001]
["Delta-Mendota Canal","San Luis WD - DMC","-",4,1.6015199999999999E-5,70.329842999999997]
["Delta-Mendota Canal","Santa Nella County WD - DMC","-",0,0,0]
["Total","Total Delta-Mendota Canal","-",7960,3.1870340499999997E-2,139956.793898]
["Folsom D & R","City of Folsom","-",4918,1.96907456E-2,86470.793233000004]
["Folsom D & R","City of Roseville","-",20774,8.3175182799999997E-2,365259.10090700001]
["Folsom D & R","El Dorado ID - FD&R","-",4044,1.61914142E-2,71103.677731999996,null,null,null,null,null,null,""]
["Folsom D & R","Placer County WD","-",0,0,0]
["Folsom D & R","Sacramento County WA","-",5000,2.0019058100000001E-2,87912.558967999998]
["Folsom D & R","San Juan WD","-",7650,3.0629159E-2,134506.21569099999]
["Total","Total Folsom D & R","-",42386,0.16970555969999998,745252.34653099999]
["Folsom-South Canal","East Bay MUD","-",0,0,0]
["Folsom-South Canal","Sacramento County WA - FSC","-",2050,8.2078137999999998E-3,36044.149084999997]
["Folsom-South Canal","Sacramento MUD","-",498,1.9938982000000001E-3,8756.0909310000006]
["Total","Total Folsom-South Canal","-",2548,1.0201712E-2,44800.240015999996,null,null,null,null,null,null,""]
["Friant Dam","County of Madera","-",14,5.6053400000000001E-5,246.15532899999999]
["Friant Dam","Fresno County WW #18","-",109,4.3641550000000001E-4,1916.4939320000001]
["Total","Total Friant Dam","-",123,4.9246890000000001E-4,2162.649261]
["Friant-Kern Canal","Arvin-Edison WSD","-",284,1.1370824999999999E-3,4993.4333489999999]
["Friant-Kern Canal","City of Fresno","-",58819,0.23550019620000001,1034185.763489]
["Friant-Kern Canal","City of Lindsay","-",1041,4.1679678999999997E-3,18303.394792999999]
["Friant-Kern Canal","City of Orange Cove","-",1156,4.6284061999999999E-3,20325.38349]
["Friant-Kern Canal","Delano-Earlimart ID","-",204,8.1677759999999996E-4,3586.8325359999999]
["Friant-Kern Canal","Lindsay-Strathmore ID","-",651,2.6064814E-3,11446.215333]
["Friant-Kern Canal","Shafter-Wasco ID","-",208,8.3279280000000001E-4,3657.1623789999999,null,null,null,null,null,null,""]
["Friant-Kern Canal","Terra Bella ID","-",1383,5.5372714999999996E-3,24316.613939999999]
["Total","Total Friant-Kern Canal","-",63746,0.25522697610000006,1120814.7993090004]
["New Melones D & R","Stockton East WD","-",36495,0.1461191054,641673.76934999996]
["Total","Total New Melones D & R","-",36495,0.1461191054,641673.76934999996]
["Sacramento River","City of Redding - SR","-",2377,9.5170602E-3,41793.630442000001]
["Sacramento River","City of West Sacramento","-",2541,1.0173685300000001E-2,44677.162351999999]
["Sacramento River","Lake California P.O.A.","-",200,8.007623E-4,3516.5022530000001]
["Sacramento River","Riverview Golf & CC","-",25,1.000953E-4,439.562837]
["Total","Total Sacramento River","-",5143,2.0591603100000001E-2,90426.857884000012]
["San Felipe Unit","SB County WD - IB","-",0,"-",0]
["San Felipe Unit","SC Valley WD - IB","-",0,"-",0]
["Total","Total San Felipe Unit","-",0,0,0]
["San Luis Canal - Fresno","City of Avenal","-",2284,9.1447057999999998E-3,40158.457199999997]
["San Luis Canal - Fresno","City of Coalinga","-",2955,1.18312634E-2,51956.322626000001]
["San Luis Canal - Fresno","City of Huron","-",767,3.0709234999999999E-3,13485.786491000001]
["San Luis Canal - Fresno","State of CA","-",2,8.0075999999999994E-6,35.164921999999997]
["San Luis Canal - Fresno","Westlands WD","-",3619,1.4489794300000001E-2,63631.110389000001]
["Total","Total San Luis Canal - Fresno","-",9627,3.8544694599999998E-2,169266.84162799999]
["San Luis Canal - Tracy","Pacheco WD - SLC","-",0,0,0]
["San Luis Canal - Tracy","Panoche WD - SLC","-",147,5.8856030000000001E-4,2584.6291980000001]
["San Luis Canal - Tracy","San Luis WD - SLC","-",273,1.0930406E-3,4800.0258409999997]
["San Luis Canal - Tracy","Santa Nella County WD - SLC","-",182,7.2869370000000001E-4,3200.017081]
["Total","Total San Luis Canal - Tracy","-",602,2.4102946000000001E-3,10584.672119999999]
["Shasta Dam","Centerville CSD","-",275,1.1010481999999999E-3,4835.1907629999996]
["Shasta Dam","Mountain Gate CSD","-",458,1.8337456999999999E-3,8052.7903050000004]
["Shasta Dam","Shasta CWA  ","-",82,3.2831260000000003E-4,1441.7661740000001]
["Total","Total Shasta Dam","-",815,3.2631064999999997E-3,14329.747242000001,null,null,null,null,null,null,""]
["Spring Creek Conduit","City of Redding - SCC","-",4526,1.81212514E-2,79578.448413000006]
["Spring Creek Conduit","Shasta CWA   - SCC","-",0,0,0]
["Spring Creek Conduit","Shasta CSD  ","-",186,7.4470899999999997E-4,3270.3473629999999,null,null,null,null,null,null,""]
["Total","Total Spring Creek Conduit","-",4712,1.8865960399999999E-2,82848.795775999999]
["Tehama-Colusa Canal","Colusa County WD","-",72,2.8827440000000001E-4,1265.9406879999999]
["Tehama-Colusa Canal","Kanawha WD","-",27,1.081029E-4,474.72775799999999]
["Total","Total Tehama-Colusa Canal","-",99,3.963773E-4,1740.6684459999999]
["Toyon Pipeline","City of Redding - TP","-",11,4.4041900000000003E-5,193.40750800000001]
["Toyon Pipeline","City of Shasta Lake  ","-",557,2.2301231000000001E-3,9793.4591909999999]
["Toyon Pipeline","US Forest Service - TP","-",0,0,0]
["Total","Total Toyon Pipeline","-",568,2.2741650000000003E-3,9986.8666990000002]
["Subtotal","Total A/F/Expense without San Felipe Unit","-",249762,1,4391443.3201180007]
["San Felipe Unit","SB County WD - IB","-",8871,7.7835589799999993E-2,105070.12878499999]
["San Felipe Unit","SC Valley WD - IB","-",105100,0.92216441019999995,1244828.1510979999]
["Total","Total San Felipe Unit","-",113971,1,1349898.2798829998]
["GRAND TOTAL","GRAND TOTAL","-",363733,"-",5741341.6000010008]
[]
["FOOTNOTES"]
[]
["1/"]
["San Felipe Unit contractors' share of the Gianelli WR Pumping-Generating Plant storage costs are included in the direct cost section (see schedule B-6, pages 2 & 3)"]