{"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":96,"n_cols":13,"rows_kept":96,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2023 Sch B-1 F.Z27.XLSM"]
["09/24/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF FY 2023 M&I NET POSITION"]
["BY PERMANENT CONTRACTOR"]
[]
[]
["Category","A) Contractor","Related Footnotes","B) Total Water Charges\n\n<Sch B-2>","C) Total O&M Expenses\n\n<Sch B-1A>","D) Interest","E) Friant Division O&M Expense Adjustment","F) Charge Adj\n\n<B-3A>        <B-6A>","G) Voluntary Payment: Prior  Year\n\n<Sch B-3A>","H) Voluntary Payment: Current Year\n\n<Sch B-3A>","I) Results of Operations\n\n(B-C-D-E+F+G+H)","J) Construction/Deficit Recovery","K) Net Results of Operations\n\n(I-J)"]
["Black Butte D & R","County of Colusa","-",177.04000000000002,167.97387769670786,5.7611133655862838,0,0,0,0,3.3050089377058782,1.8599999999999999,1.45]
["Black Butte D & R","Elk Creek CSD","-",0,0,33.266505837865822,0,0,0,0,-33.266505837865822,0,-33.270000000000003]
["Black Butte D & R","US Forest Service - BB","-",36.92,27.995646116117975,23.377509931725292,0,0,0,0,-14.453156047843265,0,-14.45]
["Black Butte D & R","Whitney Const.","-",0,0,6.2848361769352845,0,0,0,0,-6.2848361769352845,0,-6.28]
["Total","Total Black Butte D & R","-",213.96000000000004,195.96952381282583,68.689965312112676,0,0,0,0,-50.699489124938495,1.8599999999999999,-52.550000000000004]
["Clear Creek Unit","Clear Creek CSD","-",30280.820000000003,25588.003018131829,143.93835284646397,0,0,0,0,4548.8786290217104,347.32,4201.5600000000004]
["Total","Total Clear Creek Unit","-",30280.820000000003,25588.003018131829,143.93835284646397,0,0,0,0,4548.8786290217104,347.32,4201.5600000000004]
["Contra Costa Canal","Contra Costa WD","-",2043181.1600000001,1729745.4011465113,144429.08409261535,0,0,0,0,169006.67476087343,46261.760000000002,122744.91]
["Total","Total Contra Costa Canal","-",2043181.1600000001,1729745.4011465113,144429.08409261535,0,0,0,0,169006.67476087343,46261.760000000002,122744.91]
["Cow Creek Unit","Bella Vista WD","-",208362.79,186131.66535266643,6191.1728904796755,0,0,0,0,16039.951756853901,0,16039.95]
["Total","Total Cow Creek Unit","-",208362.79,186131.66535266643,6191.1728904796755,0,0,0,0,16039.951756853901,0,16039.95]
["Cross Valley Canal","County of Fresno","-",0,0,3205.8752093001885,0,0,0,0,-3205.8752093001885,0,-3205.88]
["Cross Valley Canal","County of Tulare","-",0,0,8290.1978013010794,0,0,0,0,-8290.1978013010794,0,-8290.2000000000007]
["Total","Total Cross Valley Canal","-",0,0,11496.073010601267,0,0,0,0,-11496.073010601267,0,-11496.080000000002]
["Delta-Mendota Canal","Byron Bethany ID","-",47279.73,40985.598068996718,1322.9508486112577,0,0,0,0,4971.1810823920241,1771.44,3199.74]
["Delta-Mendota Canal","City of Tracy","-",204179.6,172621.03690298344,1622.9629201361333,0,0,0,0,29935.600176880427,2281.42,27654.18]
["Delta-Mendota Canal","Del Puerto WD","-",982.5,839.86860748353934,0,0,0,0,0,142.63139251646066,0,142.63]
["Delta-Mendota Canal","Department of VA","-",9092.7900000000009,7642.8062337002075,290.38730070092436,0,0,0,0,1159.5964655988691,338.52,821.08]
["Delta-Mendota Canal","Panoche WD - DMC","-",803.90999999999985,643.89960367071353,28.156752366670727,0,0,0,0,131.85364396261559,46.23,85.62]
["Delta-Mendota Canal","San Luis WD - DMC","-",125.98,111.9823254644719,0,0,0,0,0,13.997674535528105,0,14]
["Delta-Mendota Canal","Santa Nella County WD - DMC","-",0,0,0,0,0,0,0,0,0,0]
["Total","Total Delta-Mendota Canal","-",262464.51,222845.1917422991,3264.4578218149863,0,0,0,0,36354.86043588593,4437.6099999999997,31917.25]
["Folsom D & R","City of Folsom","-",161612.22,137682.49427006821,0,0,0,0,0,23929.725729931786,639.34,23290.39]
["Folsom D & R","City of Roseville","-",689281.32,581581.15821623488,10548.08368074986,0,0,0,0,97152.078103015199,8932.82,88219.26]
["Folsom D & R","El Dorado ID - FD&R","-",132966.72,113214.31606358109,1139.5761330546807,0,0,197716,0,216328.82780336423,525.72,215803.11]
["Folsom D & R","Placer County WA","-",0,0,325.88730727643878,0,0,0,0,-325.88730727643878,0,-325.89]
["Folsom D & R","Sacramento County WA","-",174150,139978.13544558987,3773.9825949626656,0,0,0,0,30397.881959447463,10400,19997.88]
["Folsom D & R","San Juan WD","-",250537.5,214166.54789630254,0,0,0,0,0,36370.952103697462,0,36370.949999999997]
["Total","Total Folsom D & R","-",1408547.7599999998,1186622.6518917766,15787.529716043646,0,0,197716,0,403853.57839217968,20497.879999999997,383355.7]
["Folsom-South Canal","East Bay MUD","-",0,0,110494.63512645832,0,0,400000,0,289505.36487354169,0,289505.36]
["Folsom-South Canal","Sacramento County WA","-",105493,186848.35117086288,20478.873129591135,0,0,0,0,-101834.22430045402,0,-101834.22]
["Folsom-South Canal","Sacramento MUD","-",28150.609999999986,45390.477743005715,17679.911522810831,0,0,0,34739,-180.77926581655629,0,-180.78]
["Total","Total Folsom-South Canal","-",133643.60999999999,232238.82891386858,148653.41977886029,0,0,400000,34739,187490.36130727112,0,187490.36]
["Friant Dam","County of Madera","1/",376.34000000000003,391.93904662565171,19.603180075992583,-42,0,0,0,6.7977732983557644,0,6.8]
["Friant Dam","Fresno County WW #18","1/",3205.41,3051.5236226568595,214.34675181050588,-327,0,0,0,266.53962553263455,146.06,120.48]
["Total","Total Friant Dam","-",3581.75,3443.4626692825113,233.94993188649846,-369,0,0,0,273.33739883099031,146.06,127.28]
["Friant-Kern Canal","Arvin-Edison WSD","1/",8619.4,7950.7580829775052,0,-852,-1350,0,0,170.64191702249445,170.4,0.24]
["Friant-Kern Canal","City of Fresno","1/",1678576.23,1646674.7928179433,0,-176457,0,0,0,208358.43718205672,0,208358.44]
["Friant-Kern Canal","City of Lindsay","1/",28875.57,29143.447755878813,1309.0530914131768,-3123,0,0,0,1546.0691527080089,0,1546.07]
["Friant-Kern Canal","City of Orange Cove","1/",33641.360000000001,32362.944737232381,548.93221341192816,-3468,0,0,0,4197.4830493556947,450.84000000000003,3746.64]
["Friant-Kern Canal","Delano-Earlimart ID","1/",5486.68,5711.1081996880675,894.18172506043834,-612,0,0,0,-506.60992474850536,0,-506.61]
["Friant-Kern Canal","Lindsay-Strathmore ID","1/",18145.29,18225.1535055928,1806.9564454180149,-1842,0,0,0,-44.819951010813384,0,-44.82]
["Friant-Kern Canal","Shafter-Wasco ID","1/",5837.5,5823.0902671525391,240.18766151609813,-624,0,0,0,398.22207133136271,118.55999999999999,279.66000000000003]
["Friant-Kern Canal","Terra Bella ID","1/",41144.25,38717.952539591162,492.75089849455173,-4149,0,0,0,6082.5465619142851,0,6082.55]
["Total","Total Friant-Kern Canal","-",1820326.28,1784609.2479060565,5292.0620353142085,-191127,-1350,0,0,220201.97005862926,739.8,219462.17]
["New Melones D & R","Stockton East WD","-",1195211.25,1021700.4125127256,21213.792718020592,0,0,650575.94999999995,0,802872.99476925377,0,802872.99]
["Total","Total New Melones D & R","-",1195211.25,1021700.4125127256,21213.792718020592,0,0,650575.94999999995,0,802872.99476925377,0,802872.99]
["Sacramento River","City of Redding - SR","-",86119.31,66545.60544101242,4445.3070270223743,0,0,0,0,15128.397531965209,15128.397531965209,0]
["Sacramento River","City of West Sacramento","-",84005.46,71136.888310055772,384.39558345331864,0,0,0,0,12484.176106490922,787.71,11696.47]
["Sacramento River","Lake California P.O.A.","-",7304.0000000000009,5599.1253552235958,73.473720434099306,0,0,0,0,1631.4009243423061,754,877.4]
["Sacramento River","Riverview Golf & CC","-",886.75,699.89063790294949,9.2152705796968579,0,0,0,0,177.64409151735367,68,109.64]
["Total","Total Sacramento River","-",178315.52000000002,143981.50974419474,4912.3916014894894,0,0,0,0,29421.618654315793,16738.107531965208,12683.509999999998]
["San Felipe Unit","SB County WD - IB","-",227617.5,169646.54828875707,7830.6293033842912,0,0,0,0,50140.32240785865,22000.079999999998,28140.240000000002]
["San Felipe Unit","SC Valley WD - IB","-",2400821.6,1956581.9843460566,24668.84758453165,0,0,0,0,419570.76806941186,0,419570.77]
["Total","Total San Felipe Unit","-",2628439.1,2126228.5326348138,32499.476887915942,0,0,0,0,469711.09047727054,22000.079999999998,447711.01]
["San Luis Canal - Fresno","City of Avenal","-",70694.64,63942.012675213453,6593.9523524457645,0,0,0,0,158.67497234078473,0,158.66999999999999]
["San Luis Canal - Fresno","City of Coalinga","-",294898.24,157599.5770946535,35179.396763249097,0,0,0,0,102119.26614209739,36316.949999999997,65802.320000000007]
["San Luis Canal - Fresno","City of Huron","-",54121.33,21472.645875062492,14216.336851530066,0,0,0,0,18432.347273407446,18432.347273407446,0]
["San Luis Canal - Fresno","State of CA","-",67.650000000000006,55.991034232235947,2.3501720698434356,0,0,0,0,9.3087936979206205,7.72,1.59]
["San Luis Canal - Fresno","Westlands WD     ","-",101643.93999999999,108767.50727705364,16515.926247670748,0,0,0,0,-23639.493524724399,0,-23639.49]
["Total","Total San Luis Canal - Fresno","-",521425.80000000005,351837.73395621532,72507.962386965519,0,0,0,0,97080.103656819134,54757.017273407444,42323.09]
["San Luis Canal - Tracy","Pacheco WD - SLC","-",0,0,49.707931252113667,0,0,0,0,-49.707931252113667,0,-49.71]
["San Luis Canal - Tracy","Panoche WD - SLC","-",5065.6499999999996,4115.3571430693428,351.55481966521461,0,0,0,0,598.73803726544247,191.1,407.64]
["San Luis Canal - Tracy","San Luis WD - SLC","-",5787.18,5836.7461999013412,27.619149480427385,0,0,5071.6099999999997,0,4994.4246506182317,267.54000000000002,4726.88]
["San Luis Canal - Tracy","Santa Nella County WD - SLC","-",3586.6,7754.1641821334706,0,0,0,0,0,-4167.5641821334702,0,-4167.5600000000004]
["Total","Total San Luis Canal - Tracy","-",14439.43,17706.267525104155,428.88190039775566,0,0,5071.6099999999997,0,1375.8905744980902,458.64,917.25]
["Shasta Dam","Centerville CSD","-",9006.25,7698.7975259324439,626.11053870688158,0,0,0,0,681.34193536067505,0,681.34]
["Shasta Dam","Mountain Gate CSD","-",15400.630000000001,12821.997154182032,910.12102564550457,0,0,0,0,1668.5118201724636,893.1,775.41]
["Shasta Dam","Shasta CWA  ","-",2629.4,2295.6416935216744,179.91907054701926,0,0,0,0,153.83923593130658,2.46,151.38]
["Total","Total Shasta Dam","-",27036.280000000002,22816.436373636148,1716.1506348994053,0,0,0,0,2503.6929914644452,895.56000000000006,1608.13]
["Spring Creek Conduit","City of Redding - SCC","-",150082.15999999997,126708.20821054997,6136.4883240126683,0,0,0,0,17237.463465437322,1855.6599999999999,15381.8]
["Spring Creek Conduit","Shasta CWA - SCC","-",0,0,79.027657094517423,0,0,0,0,-79.027657094517423,0,-79.03]
["Spring Creek Conduit","Shasta CSD  ","-",5951.88,5207.1868265979429,383.7203317436373,0,0,0,0,360.97284165842029,271.56,89.41]
["Total","Total Spring Creek Conduit","-",156034.03999999998,131915.39503714791,6599.2363128508223,0,0,0,0,17519.408650001227,2127.2199999999998,15392.179999999998]
["Tehama-Colusa Canal","Colusa County WD","-",1756.08,3203.4309551286988,148.89972456845302,0,0,0,0,-1596.250679697152,0,-1596.25]
["Tehama-Colusa Canal","Kanawha WD","-",815.86999999999989,872.6920276324613,90.181281201820227,0,0,0,0,-147.0033088342816,0,-147]
["Total","Total Tehama-Colusa Canal","-",2571.9499999999998,4076.1229827611601,239.08100577027324,0,0,0,0,-1743.2539885314336,0,-1743.25]
["Toyon Pipeline","City of Redding - TP","-",352.82,307.95184827729776,3.8647190246217797,0,0,0,0,41.003432698080474,2.09,38.909999999999997]
["Toyon Pipeline","City of Shasta Lake  ","-",38476.120000000003,16174.455617677715,0,0,0,0,0,22301.664382322288,0,22301.66]
["Toyon Pipeline","US Forest Service - TP","-",0,0,5.3739385938652298,0,0,0,0,-5.3739385938652298,0,-5.37]
["Total","Total Toyon Pipeline","-",38828.94,16482.407465955013,9.2386576184870091,0,0,0,0,22337.293876426505,2.09,22335.200000000001]
["Grand Total","Grand Total","-",10672904.950000001,9208165.2403969597,475686.58970170282,-191496,-1350,1253363.56,34739,2467301.6799013382,169411.00480537262,2297890.6600000006]
[]
["Footnotes"]
[]
["1/"]
["As per letter signed 7/23/2020, and Public Law 111-11; Title X, Water Marketing for the Friant Division is being reduced by $3.00."]