{"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":105,"n_cols":7,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2023 Sch B-1A F.Z27.xlsm"]
["08/13/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF FY 2023 M&I ALLOCATED O&M EXPENSES (INCLUDING EXT XO&M)"]
["BY PERMANENT CONTRACTOR"]
[]
[]
["Category","A) Contractor\n","B) O&M Expenses: Water Marketing\n\n<Sch B-4B>","C) O&M Expenses: Storage  1/\n\n<Sch B-4B>","D) O&M Expenses: PUE Offset & Credit\n\n<Sch B-5>","E) O&M Expenses: Direct Pumping and Other 2/\n\n<Sch B-6> + \n<Sch B-1C>","F) O&M Expenses: Total\n\n(B+C+D+E)"]
["Black Butte D & R","County of Colusa",42.503965000000001,106.33492869670786,19.134983999999999,0,167.97387769670786]
["Black Butte D & R","Elk Creek CSD",0,0,0,0,0]
["Black Butte D & R","US Forest Service - BB",7.0840800000000002,17.722415116117975,3.1891509999999998,0,27.995646116117975]
["Black Butte D & R","Whitney Const Inc.",0,0,0,0,0]
["Total","Total Black Butte D & R",49.588045000000001,124.05734381282583,22.324134999999998,0,195.96952381282583]
["Clear Creek Unit","Clear Creek CSD",6474.7770119999996,16198.33375113183,2914.8922550000002,0,25588.003018131829]
["Total","Total Clear Creek Unit",6474.7770119999996,16198.33375113183,2914.8922550000002,0,25588.003018131829]
["Contra Costa Canal","Contra Costa WD",512059.93910900003,1281050.728720472,-65450.552782960789,2085.2860999999998,1729745.4011465113]
["Total","Total Contra Costa Canal",512059.93910900003,1281050.728720472,-65450.552782960789,2085.2860999999998,1729745.4011465113]
["Cow Creek Unit","Bella Vista WD",12276.573893000001,30713.033696232455,142557.347863434,584.70989999999995,186131.66535266643]
["Total","Total Cow Creek Unit",12276.573893000001,30713.033696232455,142557.347863434,584.70989999999995,186131.66535266643]
["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",10370.977747000001,25945.690040996717,4668.9302809999999,0,40985.598068996718]
["Delta-Mendota Canal","City of Tracy",43679.951067000002,109276.72502398345,19664.360811999999,0,172621.03690298344]
["Delta-Mendota Canal","Del Puerto WD",212.520082,531.67376348353935,95.674762000000001,0,839.86860748353934]
["Delta-Mendota Canal","Department of VA",1933.9322079999999,4838.2333147002073,870.64071100000001,0,7642.8062337002075]
["Delta-Mendota Canal","Panoche WD - DMC",162.93203700000001,407.6168596707135,73.350707,0,643.89960367071353]
["Delta-Mendota Canal","San Luis WD - DMC",28.336062999999999,70.889659464471904,12.756603,0,111.9823254644719]
["Delta-Mendota Canal","Santa Nella County WD - DMC",0,0,0,0,0]
["Total","Total Delta-Mendota Canal",56388.649204000001,141070.82866229909,25385.713876000002,0,222845.1917422991]
["Folsom D & R","City of Folsom",34839.117602999999,87159.08757606821,15684.289091000001,0,137682.49427006821]
["Folsom D & R","City of Roseville",147163.03978399999,368166.50771523488,66251.610717000003,0,581581.15821623488]
["Folsom D & R","El Dorado ID - FD&R",28647.700700000001,71669.652177581098,12896.963186000001,0,113214.31606358109]
["Folsom D & R","Placer County WA",0,0,0,0,0]
["Folsom D & R","Sacramento County WA",35420.005725000003,88612.329548589885,15945.800171999999,0,139978.13544558987]
["Folsom D & R","San Juan WD",54192.608869000003,135576.86467930253,24397.074347999998,0,214166.54789630254]
["Total","Total Folsom D & R",300262.47268099996,751184.44169677666,135175.73751400001,0,1186622.6518917766]
["Folsom-South Canal ","East Bay MUD",0,0,0,0,0]
["Folsom-South Canal ","Sacramento County WA-FSC",14522.202272,36331.055023041852,6537.7780540000003,129457.31582182103,186848.35117086288]
["Folsom-South Canal ","Sacramento MUD",3527.8326959999999,8825.7880808267528,1588.2017080000001,31448.655258178962,45390.477743005715]
["Total","Total Folsom-South Canal ",18050.034968,45156.843103868603,8125.9797620000008,160905.97107999999,232238.82891386858]
["Friant Dam","County of Madera",99.176090000000002,248.11468662565167,44.648269999999997,0,391.93904662565171]
["Friant Dam","Fresno County WW #18",772.15622199999996,1931.7489306568596,347.61847,0,3051.5236226568595]
["Total","Total Friant Dam",871.332312,2179.8636172825113,392.26674000000003,0,3443.4626692825113]
["Friant-Kern Canal","Arvin-Edison WSD",2011.856315,5033.1803179775052,905.72145,0,7950.7580829775052]
["Friant-Kern Canal","City of Fresno",416673.86369799997,1042417.7246449433,187583.20447500001,0,1646674.7928179433]
["Friant-Kern Canal","City of Lindsay",7374.4451289999997,18449.087027878813,3319.9155989999999,0,29143.447755878813]
["Friant-Kern Canal","City of Orange Cove",8189.1053149999998,20487.17044823238,3686.6689740000002,0,32362.944737232381]
["Friant-Kern Canal","Delano-Earlimart ID",1445.1363530000001,3615.3831756880672,650.58867099999998,0,5711.1081996880675]
["Friant-Kern Canal","Lindsay-Strathmore ID",4611.6848319999999,11537.325462592802,2076.1432110000001,0,18225.1535055928]
["Friant-Kern Canal","Shafter-Wasco ID",1473.472158,3686.2728351525388,663.34527400000002,0,5823.0902671525391]
["Friant-Kern Canal","Terra Bella ID",9797.1737059999996,24510.170482591162,4410.6083509999999,0,38717.952539591162]
["Total","Total Friant-Kern Canal",451576.73750599992,1129736.3143950566,203296.19600500001,0,1784609.2479060565]
["New Melones D & R","Stockton East WD",258530.62198200001,646781.39481772552,116388.39571300001,0,1021700.4125127256]
["Total","Total New Melones D & R",258530.62198200001,646781.39481772552,116388.39571300001,0,1021700.4125127256]
["Sacramento River","City of Redding - SR",16838.670679999999,42126.30137601243,7580.6333850000001,0,66545.60544101242]
["Sacramento River","City of West Sacramento",18000.446923,45032.785761055777,8103.6556259999998,0,71136.888310055772]
["Sacramento River","Lake California P.O.A.",1416.800291,3544.4930762235954,637.83198800000002,0,5599.1253552235958]
["Sacramento River","Riverview Golf & CC",177.09994,443.06168990294941,79.729007999999993,0,699.89063790294949]
["Total","Total Sacramento River",36433.017833999998,91146.641903194759,16401.850007000001,0,143981.50974419474]
["San Felipe Unit","SB County WD - IB",62842.174233999998,105070.12878499999,-49938.758073431833,51673.003343188917,169646.54828875707]
["San Felipe Unit","SC Valley WD - IB",744528.52074800001,1244828.1510979999,-645295.40445189655,612520.71695195301,1956581.9843460566]
["Total","Total San Felipe Unit",807370.69498200004,1349898.2798829998,-695234.16252532834,664193.72029514192,2126228.5326348138]
["San Luis Canal - Fresno","City of Avenal",16179.858708,40478.112401213453,7284.0415659999999,0,63942.012675213453]
["San Luis Canal - Fresno","City of Coalinga",20933.223336999999,52369.887039128625,79012.419818524897,5284.0469000000003,157599.5770946535]
["San Luis Canal - Fresno","City of Huron",5433.4288409999999,13593.13129806249,2446.085736,0,21472.645875062492]
["San Luis Canal - Fresno","State of CA",14.167902,35.444830232235951,6.3783019999999997,0,55.991034232235947]
["San Luis Canal - Fresno","Westlands WD",25637.000178999999,64137.604335230957,1289.5092628226848,17703.393499999998,108767.50727705364]
["Total","Total San Luis Canal - Fresno",68197.678967,170614.17990386777,90038.434685347573,22987.440399999999,351837.73395621532]
["San Luis Canal - Tracy","Pacheco WD - SLC",0,0,0,0,0]
["San Luis Canal - Tracy","Panoche WD - SLC",1041.3481710000001,2605.2024530693425,468.80651899999998,0,4115.3571430693428]
["San Luis Canal - Tracy","San Luis WD - SLC",1933.9322079999999,4838.2333147002073,-935.41932279886669,0,5836.7461999013412]
["San Luis Canal - Tracy","Santa Nella County WD - SLC",1289.2881379999999,3225.4887301334716,580.42711399999996,2658.9602,7754.1641821334706]
["Total","Total San Luis Canal - Tracy",4264.5685169999997,10668.924497903021,113.81431020113325,2658.9602,17706.267525104155]
["Shasta D&R","Centerville CSD",1948.1003679999999,4873.6781449324435,877.01901299999997,0,7698.7975259324439]
["Shasta D&R","Mountain Gate CSD",3244.4725859999999,8116.8892901820336,1460.635278,0,12821.997154182032]
["Shasta D&R","Shasta CWA  ",580.88812199999995,1453.2424115216743,261.51116000000002,0,2295.6416935216744]
["Total","Total Shasta D&R",5773.4610759999996,14443.809846636152,2599.1654509999998,0,22816.436373636148]
["Spring Creek Conduit","City of Redding - SCC",32062.189146000001,80211.880742549969,14434.138322000001,0,126708.20821054997]
["Spring Creek Conduit","Shasta CWA   - SCC",0,0,0,0,0]
["Spring Creek Conduit","Shasta CSD  ",1317.6242010000001,3296.3788285979435,593.18379700000003,0,5207.1868265979429]
["Total","Total Spring Creek Conduit",33379.813347000003,83508.259571147908,15027.322119,0,131915.39503714791]
["Tehama-Colusa Canal","Colusa County WD",510.04809399999999,1276.0173843604941,-216.5842782317952,1633.9497550000001,3203.4309551286988]
["Tehama-Colusa Canal","Kanawha WD",191.2681,478.50651913518539,71.970608497275919,130.9468,872.6920276324613]
["Total","Total Tehama-Colusa Canal",701.316194,1754.5239034956794,-144.61366973451928,1764.896555,4076.1229827611601]
["Toyon Pipeline","City of Redding - TP",77.924107000000006,194.94700327729774,35.080737999999997,0,307.95184827729776]
["Toyon Pipeline","City of Shasta Lake  ",3945.7885230000002,9871.4136336777137,2354.807761,2.4457,16174.455617677715]
["Toyon Pipeline","US Forest Service - TP",0,0,0,0,0]
["Total","Total Toyon Pipeline",4023.71263,10066.360636955011,2389.8884990000001,2.4457,16482.407465955013]
["Grand Total  ","Grand Total  ",2576684.9902590001,5776296.8199508581,-4.3040889522671932E-5,855183.43023014185,9208165.2403969597]
[]
["FOOTNOTES"]
[]
["1/"]
["Component","Amount"]
["Storage (Sch. B-4A)",5741341.6000010008]
[null,34955.219949858103]
["Total Storage",5776296.8199508591]
[]
["2/"]
["Component","Amount"]
["Direct Cost (Pumping & Other) (Sch. B-6)",815705.47108000005]
[null,39477.959150141891]
["Total Direct Cost",855183.43023014197]