{"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":98,"n_cols":17,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2022 Sch B-4A F.Z26.XLSM"]
["7/28/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF FY 2022 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","-","-","-",4585070.2683246182]
["Total","Total San Felipe Unit","1/","-","-",1678838.0216753806]
["Black Butte D & R","County of Colusa","-",11,7.4606599999999998E-5,342.076503]
["Black Butte D & R","Elk Creek CSD","-",0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Black Butte D & R","US Forest Service - BB","-",8,5.4259399999999998E-5,248.783162]
["Black Butte D & R","Whitney Const.","-",0,0,0]
["Total","Total Black Butte D & R","-",19,1.28866E-4,590.85966499999995]
["Clear Creek Unit","Clear Creek CSD","-",0,0,0]
["Total","Total Clear Creek Unit","-",0,0,0]
["Contra Costa Canal","Contra Costa WD ","-",58225,0.39490640259999998,1810673.6053319999]
["Total","Total Contra Costa Canal","-",58225,0.39490640259999998,1810673.6053319999]
["Cow Creek Unit","Bella Vista WD","-",1269,8.6068909000000006E-3,39463.199568000004]
["Total","Total Cow Creek Unit","-",1269,8.6068909000000006E-3,39463.199568000004]
["Cross Valley Canal","County of Fresno","-",0,"-",0]
["Cross Valley Canal","County of Tulare","-",0,"-",0]
["Total","Total Cross Valley Canal","-",0,"-",0]
["Delta-Mendota Canal","Byron Bethany ID","-",4,2.7129699999999999E-5,124.391581]
["Delta-Mendota Canal","City of Tracy","-",3824,2.5935974000000001E-2,118918.263267]
["Delta-Mendota Canal","Del Puerto WD","-",0,"-",0,null,null,null,null,null,null,""]
["Delta-Mendota Canal","Department of VA","-",319,2.1635920000000002E-3,9920.2213520000005]
["Delta-Mendota Canal","Panoche WD - DMC","-",25,1.695605E-4,777.44680700000004]
["Delta-Mendota Canal","San Luis WD - DMC","-",3,2.0347300000000001E-5,93.293800000000005]
["Total","Total Delta-Mendota Canal","-",4175,2.8316603499999999E-2,129833.616807]
["Folsom D & R","City of Folsom","-",1000,6.7824199999999999E-3,31097.872288999999]
["Folsom D & R","City of Roseville","-",2187,1.48331525E-2,68011.046512999994]
["Folsom D & R","El Dorado ID - FD&R","-",0,"-",0,null,null,null,null,null,null,""]
["Folsom D & R","Placer County WD","-",0,0,0]
["Folsom D & R","Sacramento County WA","-",0,0,0]
["Folsom D & R","San Juan WD","-",0,"-",0]
["Total","Total Folsom D & R","-",3187,2.1615572499999999E-2,99108.918802]
["Folsom-South Canal","East Bay MUD","-",31915,0.21646093329999999,992488.58952799998]
["Folsom-South Canal","Sacramento County WA - FSC","-",0,0,0]
["Folsom-South Canal","Sacramento MUD","-",4509,3.0581931600000001E-2,140220.30532700001]
["Total","Total Folsom-South Canal","-",36424,0.24704286489999999,1132708.8948550001,null,null,null,null,null,null,""]
["Friant Dam","County of Madera","-",49,3.3233859999999999E-4,1523.795834]
["Friant Dam","Fresno County WW #18","-",298,2.0211612000000001E-3,9267.1661260000001]
["Total","Total Friant Dam","-",347,2.3534998000000001E-3,10790.961960000001]
["Friant-Kern Canal","Arvin-Edison WSD","-",338,2.2924578999999998E-3,10511.080559]
["Friant-Kern Canal","City of Fresno","-",22140,0.15016277810000001,688506.88927499996]
["Friant-Kern Canal","City of Lindsay","-",2529,1.7152740100000001E-2,78646.518653000006]
["Friant-Kern Canal","City of Orange Cove","-",1100,7.4606619999999998E-3,34207.659518]
["Friant-Kern Canal","Delano-Earlimart ID","-",145,9.8345089999999995E-4,4509.1914820000002]
["Friant-Kern Canal","Lindsay-Strathmore ID","-",390,2.6451437999999998E-3,12128.170193]
["Friant-Kern Canal","Shafter-Wasco ID","-",154,1.0444927E-3,4789.072424,null,null,null,null,null,null,""]
["Friant-Kern Canal","Terra Bella ID","-",1350,9.1562669999999992E-3,41982.127590999997]
["Total","Total Friant-Kern Canal","-",28146,0.1908979925,875280.70969499997]
["New Melones D & R","Stockton East WD","-",0,0,0]
["Total","Total New Melones D & R","-",0,0,0]
["Sacramento River","City of Redding - SR","-",2748,1.8638090100000001E-2,85456.952776000006]
["Sacramento River","City of West Sacramento","-",0,0,0]
["Sacramento River","Lake California P.O.A.","-",0,0,0]
["Sacramento River","Riverview Golf & CC","-",0,0,0]
["Total","Total Sacramento River","-",2748,1.8638090100000001E-2,85456.952776000006]
["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","-",2337,1.5850515499999999E-2,72675.727356999996]
["San Luis Canal - Fresno","City of Coalinga","-",3764,2.5529028799999999E-2,117052.39092999999]
["San Luis Canal - Fresno","City of Huron","-",719,4.8765600000000003E-3,22359.370267999999]
["San Luis Canal - Fresno","State of CA","-",0,0,0]
["San Luis Canal - Fresno","Westlands WD","-",3932,2.6668475300000001E-2,122276.83319999999]
["Total","Total San Luis Canal - Fresno","-",10752,7.2924579600000011E-2,334364.32175499998]
["San Luis Canal - Tracy","Pacheco WD - SLC","-",0,"-",0]
["San Luis Canal - Tracy","Panoche WD - SLC","-",158,1.0716224000000001E-3,4913.4640049999998]
["San Luis Canal - Tracy","San Luis WD - SLC","-",705,4.7816061000000003E-3,21923.999963999999]
["Total","Total San Luis Canal - Tracy","-",863,5.8532285E-3,26837.463968999997]
["Shasta Dam","Centerville CSD","-",48,3.2555620000000003E-4,1492.6980530000001]
["Shasta Dam","Mountain Gate CSD","-",258,1.7498644E-3,8023.2512340000003]
["Shasta Dam","Shasta CWA  ","-",48,3.2555620000000003E-4,1492.6980530000001]
["Total","Total Shasta Dam","-",354,2.4009767999999998E-3,11008.64734,null,null,null,null,null,null,""]
["Spring Creek Conduit","City of Redding - SCC","-",255,1.7295170999999999E-3,7929.9574339999999]
["Spring Creek Conduit","Shasta CWA   - SCC","-",13,8.8171500000000001E-5,404.27252299999998]
["Spring Creek Conduit","Shasta CSD  ","-",170,1.1530113999999999E-3,5286.6382890000004,null,null,null,null,null,null,""]
["Total","Total Spring Creek Conduit","-",438,2.9706999999999997E-3,13620.868246]
["Tehama-Colusa Canal","Colusa County WD","-",16,1.085187E-4,497.56586499999997]
["Tehama-Colusa Canal","Kanawha WD","-",7,4.7476899999999999E-5,217.684923]
["Total","Total Tehama-Colusa Canal","-",23,1.5599560000000001E-4,715.25078799999994]
["Toyon Pipeline","City of Redding - TP","-",9,6.1041800000000002E-5,279.880942]
["Toyon Pipeline","City of Shasta Lake  ","-",461,3.1266955999999999E-3,14336.119033999999]
["Toyon Pipeline","US Forest Service - TP","-",0,0,0]
["Total","Total Toyon Pipeline","-",470,3.1877373999999997E-3,14615.999975999999]
["Subtotal","Total A/F/Expense without San Felipe Unit","-",147440,1.0000000006999998,4585070.2715339996]
["San Felipe Unit","SB County WD - IB","-",1997,3.1531246999999998E-2,52935.856333999996]
["San Felipe Unit","SC Valley WD - IB","-",61337,0.96846875300000002,1625902.1653410001]
["Total","Total San Felipe Unit","-",63334,1,1678838.021675]
["GRAND TOTAL","GRAND TOTAL","-",210774,"-",6263908.2932089996]
[]
["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)."]