{"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/20/2025"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF FY 2024 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","-","-","-",5228031.306066893]
["Total","Total San Felipe Unit","1/","-","-",1353609.4684199276]
["Black Butte D & R","County of Colusa","-",6,2.0465199999999998E-5,106.992706]
["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","-",4,1.3643500000000001E-5,71.328644999999995]
["Black Butte D & R","Whitney Const.","-",0,0,0]
["Total","Total Black Butte D & R","-",10,3.4108700000000001E-5,178.32135099999999]
["Clear Creek Unit","Clear Creek CSD","-",2096,7.1491916000000003E-3,37376.197498000001]
["Total","Total Clear Creek Unit","-",2096,7.1491916000000003E-3,37376.197498000001]
["Contra Costa Canal","Contra Costa WD ","-",87528,0.2985469677,1560812.893467]
["Total","Total Contra Costa Canal","-",87528,0.2985469677,1560812.893467]
["Cow Creek Unit","Bella Vista WD","-",4254,1.4509857399999999E-2,75857.988733999999]
["Total","Total Cow Creek Unit","-",4254,1.4509857399999999E-2,75857.988733999999]
["Cross Valley Canal","County of Fresno","-",471,1.6065216000000001E-3,8398.9452189999993]
["Cross Valley Canal","County of Tulare","-",0,0,0]
["Total","Total Cross Valley Canal","-",471,"-",8398.9452189999993]
["Delta-Mendota Canal","Byron Bethany ID","-",1194,4.0725834000000004E-3,21291.593511999999]
["Delta-Mendota Canal","City of Tracy","-",6923,2.36134798E-2,123452.01164]
["Delta-Mendota Canal","Del Puerto WD","-",71,2.42172E-4,1266.082797,null,null,null,null,null,null,""]
["Delta-Mendota Canal","Department of VA","-",312,1.0641926E-3,5563.6322280000004]
["Delta-Mendota Canal","Panoche WD - DMC","-",25,8.5271800000000006E-5,445.80363999999997]
["Delta-Mendota Canal","San Luis WD - DMC","-",3,1.0232599999999999E-5,53.496352999999999]
["Delta-Mendota Canal","Santa Nella County WD - DMC","-",62,2.114742E-4,1105.593738]
["Total","Total Delta-Mendota Canal","-",8590,2.9299406399999998E-2,153178.21390800001]
["Folsom D & R","City of Folsom","-",7018,2.3937512800000001E-2,125146.06630799999]
["Folsom D & R","City of Roseville","-",30931,0.1055017395,551566.39695099997]
["Folsom D & R","El Dorado ID - FD&R","-",7011,2.3913636700000001E-2,125021.24131,null,null,null,null,null,null,""]
["Folsom D & R","Placer County WD","-",0,0,0]
["Folsom D & R","Sacramento County WA","-",10067,3.43372672E-2,179516.307886]
["Folsom D & R","San Juan WD","-",2850,9.7209905000000003E-3,50821.642659999998]
["Total","Total Folsom D & R","-",57877,0.19741114669999998,1032071.655115]
["Folsom-South Canal","East Bay MUD","-",0,0,0]
["Folsom-South Canal","Sacramento County WA - FSC","-",3672,1.2524728799999999E-2,65479.674266000002]
["Folsom-South Canal","Sacramento MUD","-",3170,1.08124702E-2,56527.932701999998]
["Total","Total Folsom-South Canal","-",6842,2.3337198999999999E-2,122007.60696800001,null,null,null,null,null,null,""]
["Friant Dam","County of Madera","-",19,6.4806600000000004E-5,338.81093399999997]
["Friant Dam","Fresno County WW #18","-",72,2.4558289999999998E-4,1283.9150890000001]
["Total","Total Friant Dam","-",91,3.1038949999999995E-4,1622.7260230000002]
["Friant-Kern Canal","Arvin-Edison WSD","-",471,1.6065216000000001E-3,8398.9452189999993]
["Friant-Kern Canal","City of Fresno","-",59999,0.20464902109999999,1069911.4890670001]
["Friant-Kern Canal","City of Lindsay","-",2780,9.4822293000000005E-3,49573.391631999999]
["Friant-Kern Canal","City of Orange Cove","-",1299,4.4307252E-3,23163.970054000001]
["Friant-Kern Canal","Delano-Earlimart ID","-",274,9.3457939999999997E-4,4886.0103609999996]
["Friant-Kern Canal","Lindsay-Strathmore ID","-",410,1.3984583000000001E-3,7311.1837729999997]
["Friant-Kern Canal","Shafter-Wasco ID","-",174,5.9349209999999997E-4,3102.7952789999999,null,null,null,null,null,null,""]
["Friant-Kern Canal","Terra Bella ID","-",1176,4.0111877000000001E-3,20970.614870000001]
["Total","Total Friant-Kern Canal","-",66583,0.2271062147,1187318.400255]
["New Melones D & R","Stockton East WD","-",31883,0.1087488915,568542.60926199995]
["Total","Total New Melones D & R","-",31883,0.1087488915,568542.60926199995]
["Sacramento River","City of Redding - SR","-",2324,7.9268709000000007E-3,41441.929224]
["Sacramento River","City of West Sacramento","-",3829,1.3060235999999999E-2,68279.322673000002]
["Sacramento River","Lake California P.O.A.","-",200,6.8217479999999997E-4,3566.4312110000001]
["Sacramento River","Riverview Golf & CC","-",25,8.5271800000000006E-5,445.80363999999997]
["Total","Total Sacramento River","-",6378,2.1754553500000003E-2,113733.48674800001]
["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","-",2274,7.7563272000000004E-3,40550.321422000001]
["San Luis Canal - Fresno","City of Coalinga","-",3753,1.28010096E-2,66924.078938000006]
["San Luis Canal - Fresno","City of Huron","-",951,3.2437410000000001E-3,16958.379497000002]
["San Luis Canal - Fresno","State of CA","-",1,3.4108999999999998E-6,17.832291999999999]
["San Luis Canal - Fresno","Westlands WD","-",4077,1.39061328E-2,72701.697625000001]
["Total","Total San Luis Canal - Fresno","-",11056,3.7710621499999999E-2,197152.30977400002]
["San Luis Canal - Tracy","Pacheco WD - SLC","-",0,0,0]
["San Luis Canal - Tracy","Panoche WD - SLC","-",118,4.0248310000000001E-4,2104.1942469999999]
["San Luis Canal - Tracy","San Luis WD - SLC","-",243,8.2884229999999998E-4,4333.2134919999999]
["San Luis Canal - Tracy","Santa Nella County WD - SLC","-",259,8.8341630000000003E-4,4618.5280730000004]
["Total","Total San Luis Canal - Tracy","-",620,2.1147417000000001E-3,11055.935812]
["Shasta Dam","Centerville CSD","-",1121,3.8235895999999998E-3,19989.846130000002]
["Shasta Dam","Mountain Gate CSD","-",581,1.9817176999999998E-3,10360.482174999999]
["Shasta Dam","Shasta CWA  ","-",91,3.1038950000000001E-4,1622.7260229999999]
["Total","Total Shasta Dam","-",1793,6.1156967999999997E-3,31973.054328000002,null,null,null,null,null,null,""]
["Spring Creek Conduit","City of Redding - SCC","-",6314,2.1536257600000001E-2,112592.228948]
["Spring Creek Conduit","Shasta CWA   - SCC","-",0,0,0]
["Spring Creek Conduit","Shasta CSD  ","-",403,1.3745821999999999E-3,7186.3587740000003,null,null,null,null,null,null,""]
["Total","Total Spring Creek Conduit","-",6717,2.2910839799999999E-2,119778.587722]
["Tehama-Colusa Canal","Colusa County WD","-",128,4.3659189999999999E-4,2282.5161210000001]
["Tehama-Colusa Canal","Kanawha WD","-",36,1.2279150000000001E-4,641.95780600000001]
["Total","Total Tehama-Colusa Canal","-",164,5.5938340000000002E-4,2924.473927]
["Toyon Pipeline","City of Redding - TP","-",17,5.7984900000000001E-5,303.14687199999997]
["Toyon Pipeline","City of Shasta Lake  ","-",210,7.1628350000000002E-4,3744.7525620000001]
["Toyon Pipeline","US Forest Service - TP","-",0,0,0]
["Total","Total Toyon Pipeline","-",227,7.7426839999999997E-4,4047.8994339999999]
["Subtotal","Total A/F/Expense without San Felipe Unit","-",293180,0.99839347829999991,5228031.3055450004]
["San Felipe Unit","SB County WD - IB","-",3119,3.5473011399999997E-2,48016.604103999998]
["San Felipe Unit","SC Valley WD - IB","-",84807,0.96452698859999997,1305592.8643159999]
["Total","Total San Felipe Unit","-",87926,1,1353609.4684199998]
["GRAND TOTAL","GRAND TOTAL","-",381106,"-",6581640.7739650002]
[]
["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)."]