{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["OUTPUT"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":13,"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":"OUTPUT","index":0,"n_rows":99,"n_cols":7,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2022 Sch B-1A F.Z26.xlsm"]
["07/28/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF FY 2022 M&I ALLOCATED O&M EXPENSES (INCLUDING EXT O&M)"]
["BY PERMANENT CONTRACTOR"]
["Category","A) Contractor","B) O&M Expenses: Water Marketing\n<Sch B-4B>","C) O&M Expenses: Storage  1/\n<Sch B-4B>","D) O&M Expenses: PUE Offset & Credit\n<Sch B-5>","E) O&M Expenses: Direct Pumping and Other 2/\n<Sch B-6> + \n<Sch B-1C>","F) O&M Expenses: Total\n(B+C+D+E)"]
["Black Butte D & R","County of Colusa",88.659133999999995,346.07481531385849,92.641955999999993,0,527.37590531385854]
["Black Butte D & R","Elk Creek CSD",0,0,0,0,0]
["Black Butte D & R","US Forest Service - BB",64.479292999999998,251.69102550098799,67.376035999999999,0,383.546354500988]
["Black Butte D & R","Whitney Const Inc.",0,0,0,0,0]
["Total","Total Black Butte D & R",153.13842699999998,597.76584081484646,160.01799199999999,0,910.92225981484648]
["Clear Creek Unit","Clear Creek CSD",0,0,0,0,0]
["Total","Total Clear Creek Unit",0,0,0,0,0]
["Contra Costa Canal","Contra Costa WD",469288.917067,1831837.3993751281,14426.931397517154,5888.5673999999999,2321441.8152396455]
["Total","Total Contra Costa Canal",469288.917067,1831837.3993751281,14426.931397517154,5888.5673999999999,2321441.8152396455]
["Cow Creek Unit","Bella Vista WD",10228.040142,39924.459415844227,142660.19344749369,1186.2264,193998.91940533792]
["Total","Total Cow Creek Unit",10228.040142,39924.459415844227,142660.19344749369,1186.2264,193998.91940533792]
["Cross Valley Canal","County of Fresno",0,0,0,0,0]
["Cross Valley Canal","County of Tulare",0,0,0,0,0]
["Total","Total Cross Valley Canal",0,0,0,0,0]
["Delta-Mendota Canal","Byron Bethany ID",32.239730999999999,125.845512750494,33.688018,0,191.77326175049399]
["Delta-Mendota Canal","City of Tracy",30821.139071000001,120308.22202047227,32205.721383,0,183335.08247447226]
["Delta-Mendota Canal","Del Puerto WD",0,0,0,0,0]
["Delta-Mendota Canal","Department of VA",2571.1148859999998,10036.172409101897,2686.6174810000002,0,15293.904776101896]
["Delta-Mendota Canal","Panoche WD - DMC",201.498109,786.5338804405875,210.54995700000001,0,1198.5819464405874]
["Delta-Mendota Canal","San Luis WD - DMC",24.179841,94.384248812870496,25.266044999999998,0,143.83013481287048]
["Total","Total Delta-Mendota Canal",33650.171638,131351.1580715781,35161.842883999998,0,200163.17259357811]
["Folsom D & R","City of Folsom",8059.9213040000004,31461.355226623498,8421.9982959999998,0,47943.274826623499]
["Folsom D & R","City of Roseville",17627.047885,68805.983697582589,18418.910222999999,0,104851.9418055826]
["Folsom D & R","El Dorado ID - FD&R",0,0,0,0,0]
["Folsom D & R","Placer County WA",0,0,0,0,0]
["Folsom D & R","Sacramento County WA",0,0,0,0,0]
["Folsom D & R","San Juan WD",0,0,0,0,0]
["Total","Total Folsom D & R",25686.969188999999,100267.33892420609,26840.908518999997,0,152795.21663220611]
["Folsom-South Canal ","East Bay MUD",257232.38797800001,1004089.147482254,268788.07436600002,115432.018731018,1645541.628557272]
["Folsom-South Canal ","Sacramento County WA-FSC",0,0,0,0,0]
["Folsom-South Canal ","Sacramento MUD",36342.18505,141859.24989274435,37974.790092000003,16308.412108981989,232484.63714372634]
["Total","Total Folsom-South Canal ",293574.57302800001,1145948.3973749983,306762.864458,131740.43083999999,1878026.2657009983]
["Friant Dam","County of Madera",394.93615799999998,1541.6064979435514,412.67794099999998,0,2349.2205969435513]
["Friant Dam","Fresno County WW #18",2401.8565079999998,9375.4840414118025,2509.7555419999999,0,14287.0960914118]
["Total","Total Friant Dam",2796.7926659999998,10917.090539355355,2922.4334829999998,0,16636.316688355353]
["Friant-Kern Canal","Arvin-Edison WSD",2724.2533130000002,10633.937791916742,2846.6353490000001,0,16204.826453916743]
["Friant-Kern Canal","City of Fresno",178446.657412,696554.40151398419,186463.041398,0,1061464.1003239842]
["Friant-Kern Canal","City of Lindsay",20383.540929999999,79565.767002249835,21299.233591,0,121248.54152324983]
["Friant-Kern Canal","City of Orange Cove",8865.9133999999995,34607.490749385848,9264.1981250000008,0,52737.602274385848]
["Friant-Kern Canal","Delano-Earlimart ID",1168.688523,4561.8965079554073,1221.1897530000001,0,6951.7747839554067]
["Friant-Kern Canal","Lindsay-Strathmore ID",3143.3693119999998,12269.928538673164,3284.5793349999999,0,18697.877185673162]
["Friant-Kern Canal","Shafter-Wasco ID",1241.2278759999999,4845.0487963940186,1296.987762,0,7383.2644343940183]
["Friant-Kern Canal","Terra Bella ID",10880.893811,42472.829556791723,11369.697699,0,64723.421066791721]
["Total","Total Friant-Kern Canal",226854.54457699994,885511.30045735103,237045.563012,0,1349411.4080463508]
["New Melones D & R","Stockton East WD",0,0,0,0,0]
["Total","Total New Melones D & R",0,0,0,0,0]
["Sacramento River","City of Redding - SR",22148.663719,86455.803888589377,23143.651242,0,131748.11884958937]
["Sacramento River","City of West Sacramento",0,0,0,0,0]
["Sacramento River","Lake California P.O.A.",0,0,0,0,0]
["Sacramento River","Riverview Golf & CC",0,0,0,0,0]
["Total","Total Sacramento River",22148.663719,86455.803888589377,23143.651242,0,131748.11884958937]
["San Felipe Unit","SB County WD - IB",16095.662765999999,52935.856333999996,-38992.804704201902,9801.5773662742067,39840.291762072295]
["San Felipe Unit","SC Valley WD - IB",494371.39209899999,1625902.1653410001,-978258.35556795413,301627.21074551711,1443642.4126175633]
["Total","Total San Felipe Unit",510467.05486500001,1678838.021675,-1017251.160272156,311428.78811179131,1483482.7043796356]
["San Luis Canal - Fresno","City of Avenal",18836.036029999999,73525.186982226107,19682.209966999999,0,112043.43297922611]
["San Luis Canal - Fresno","City of Coalinga",30337.543779,118420.54070721485,160644.40649487168,3363.3058000000001,312765.79678108648]
["San Luis Canal - Fresno","City of Huron",5795.0834409999998,22620.714500151294,6055.4167989999996,0,34471.214740151292]
["San Luis Canal - Fresno","State of CA",0,0,0,0,0]
["San Luis Canal - Fresno","Westlands WD",31691.61046,123706.04811073559,26733.180156046816,21725.511699999999,203856.35042678242]
["Total","Total San Luis Canal - Fresno",86660.273710000009,338272.49030032783,213115.2134169185,25088.817499999997,663136.79492724629]
["San Luis Canal - Tracy","Pacheco WD - SLC",0,0,0,0,0]
["San Luis Canal - Tracy","Panoche WD - SLC",1273.467607,4970.8943091445126,1330.67578,0,7575.0376961445127]
["San Luis Canal - Tracy","San Luis WD - SLC",5682.2444660000001,22180.255435024566,2545.6130505708402,7963.8033999999998,38371.916351595406]
["Total","Total San Luis Canal - Tracy",6955.7120730000006,27151.149744169081,3876.2888305708402,7963.8033999999998,45946.95404773992]
["Shasta D&R","Centerville CSD",386.87626699999998,1510.1452340059279,404.255968,0,2301.2774690059277]
["Shasta D&R","Mountain Gate CSD",2079.4597039999999,8117.0298319068634,2172.8756100000001,0,12369.365145906864]
["Shasta D&R","Shasta CWA  ",386.87626699999998,1510.1452340059279,404.255968,0,2301.2774690059277]
["Total","Total Shasta D&R",2853.2122380000001,11137.32029991872,2981.3875459999999,0,16971.920083918718]
["Spring Creek Conduit","City of Redding - SCC",2055.2798630000002,8022.6455830939922,2147.6095650000002,0,12225.535011093993]
["Spring Creek Conduit","Shasta CWA   - SCC",104.778915,408.99780118910547,109.486028,0,623.26274418910555]
["Spring Creek Conduit","Shasta CSD  ",1370.1866319999999,5348.4303883959956,1431.7397100000001,0,8150.3567303959953]
["Total","Total Spring Creek Conduit",3530.24541,13780.073772679094,3688.8353029999998,0,20999.154485679093]
["Tehama-Colusa Canal","Colusa County WD",128.95875599999999,503.38159200197595,-639.94274031857606,1643.0899649999999,1635.4875726833998]
["Tehama-Colusa Canal","Kanawha WD",56.419403000000003,220.22930356336448,16.558081339863307,270.67110000000002,563.87788790322782]
["Total","Total Tehama-Colusa Canal",185.37815899999998,723.61089556534046,-623.38465897871276,1913.7610649999999,2199.3654605866277]
["Toyon Pipeline","City of Redding - TP",72.539353000000006,283.15228843861149,75.798008999999993,0,431.48965043861148]
["Toyon Pipeline","City of Shasta Lake  ",3715.6237379999998,14503.684668244432,5012.6162889999996,10.1188,23242.04349524443]
["Toyon Pipeline","US Forest Service - TP",0,0,0,0,0]
["Total","Total Toyon Pipeline",3788.1630909999999,14786.836956683044,5088.4142979999997,10.1188,23673.533145683043]
["Grand Total  ","Grand Total  ",1698821.8499990001,6317500.2175322073,8.9836557799571892E-4,485220.51351679128,8501542.5819463637]
[]
["FOOTNOTES"]
["1/"]
["Component","Amount"]
["Storage (Sch. B-4A)",6263908.2932089996]
["Storage - XO&M (Sch. B-1C)",53591.924323208703]
["Total Storage",6317500.2175322082]
["2/"]
["Component","Amount"]
["Direct Cost (Pumping & Other) (Sch. B-6)",424867.11083999998]
["Direct Cost (Pumping & Other) - XO&M (Sch. B-1C)",60353.402676791295]
["Total Direct Cost",485220.51351679128]