{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["OUTPUT"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":3,"defined_names":117,"comments":1,"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":98,"n_cols":11,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2022 Sch B-6A.Z26"]
["12/14/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I PROJECT USE ENERGY OPERATION & MAINTENANCE COSTS"]
["BY FACILITY AND/OR COMPONENT FOR FY 2022"]
["2024 M&I WATER RATES"]
[]
["Category","A) Facility/Contractor\n<Ref>","Related Footnotes","B) Unpaid/(Credit) Previous Period","C) Estimated Project Use Energy Cost\nFY2022","D) True-Up\nFY2021","E) Total\nSUM(B:D)","F) Offset: % of Applied *","G) Direct Pumping\nDP Rate x AF","H) Charge Adjustment\nSee Sch B-1","I) Unpaid/ (Remaining)\nSUM(E:H)"]
["Storage (Based on Offset)","San Felipe Unit Contractors","2/",0,44059.05,-44.063743502922733,44014.986256497083,-44014.986256497083,0,0,0]
["Storage (Based on Offset)","All Others","-",0,1241618.625805913,120.79695256932274,1241739.4227584824,-1241739.4227584824,0,0,0]
["Total","Storage Total (Based on Offset)","-",0,1285677.6758059131,76.733209066400008,1285754.4090149794,-1285754.4090149794,0,0,0]
["Direct Pumping (Based on Offset)","City of Shasta Lake","-",0,1130.9067,-0.83160000000000001,1130.0751,-1130.0751,0,0,0]
["Direct Pumping (Based on Offset)","Cross Valley Canal Contractors (Dos Amigos & Banks)","-",0,0,0,0,0,0,0,0]
["Direct Pumping (Based on Offset)","Panoche WD","-",0,0,0,0,0,0,0,0]
["Direct Pumping (Based on Offset)","Pleasant Valley PP (City of Coalinga)","-",0,129012.871380803,-68.866371931299994,128944.0050088717,-128944.0050088717,0,0,0]
["Direct Pumping (Based on Offset)","Wintu PP (Bella Vista WD)","-",0,132036.46983973699,-63.792130243300001,131972.6777094937,-131972.6777094937,0,0,0]
["Total","Direct Pumping Total (Based on Offset)","-",0,262180.24792053999,-133.4901021746,262046.75781836541,-262046.75781836541,0,0,0]
["Direct Pumping (Direct Cost)","Contra Costa WD","4/",-1493824.04,0,0,-1493824.04,0,-887018.16,0,-2380842.2000000002]
["Direct Pumping (Direct Cost)","Colusa County WD","-",-0.8,2715.1090774329,-1.073229706,2713.2358477268999,0,-295.36,0,2417.88]
["Direct Pumping (Direct Cost)","Kanawha WD","-",0.98,30250.5645,-1.8586221639,30249.685877836098,0,-13.32,-30236,0.37]
["Direct Pumping (Direct Cost)","San Benito County WD","1/, 3/",-304922.53999999998,61456.293622326411,-12.841108139515777,-243479.0874858131,0,-29451.14,0,-272930.23]
["Direct Pumping (Direct Cost)","Santa Clara Valley WD","1/, 3/",-245661.1,1950663.1453133035,-699.19043640428436,1704302.8548768992,0,-1194703.73,-509599,0.12]
["Direct Pumping (Direct Cost)","San Luis WD ","-",3480.4699999999993,153008.33505927,-7.4121396507000004,156481.39291961931,0,-19879.919999999998,-136601,0.47]
["Direct Pumping (Direct Cost)","Westlands WD  ","-",-0.36,114796.45849777199,-34.1223666956,114761.97613107639,0,-38458.33,-76300.67,2.98]
["Total","Direct Pumping Total (Direct Cost)","-",-2040927.3900000004,2312889.9060701048,-756.49790276000022,271206.01816734474,0,-2169819.96,-752736.67,-2651350.61]
["Grand Total","Grand Total","-",-2040927.3900000004,3860747.8297965578,-813.25479586820018,1819007.1850006897,-1547801.1668333448,-2169819.96,-752736.67,-2651350.61]
[]
[]
["Needed based on Column F"]
[]
["Facility/Contractor","Total Cost FY2022"]
["Storage",1285754.4090149794]
["Direct Pumping",262046.75781836541]
["Storage & Direct Pumping Total",1547801.1668]
["Applied (offset/credit) **",1547801.1668]
[]
[]
["Amount Applied to \"Other\" Cost is a Credit in Accounting for following Contractors; "]
[]
["Facility/Contractor","Available From Previous Period **","Rate x AF in FY 2022 for \"Other\" Cost","Total Available","Applied to \"Other\" Cost","Charge Adjustment","Remaining Available"]
["Contra Costa WD",442010.76343438652,195298.05,637308.81343438651,475943.86529416597,null,161364.94814022054]
["Colusa County Water District",967.74875561993565,69.599999999999994,1037.3487556199357,774.69472569701998,null,262.6540299229157]
["Kanawha Water Districit",53.87983437860936,2.89,56.76983437860936,42.395858705705322,null,14.373975672904038]
["San Benito County Water District",47786.160763559201,6285.23,54071.390763559204,40380.654055538405,null,13690.736708020799]
["Santa Clara Valley Water District",1113398.2847878907,253610.31,1367008.5947878908,1020885.5436779219,null,346123.05110996892]
["San Luis Water Districit",1.0002145936596207E-3,4541.8900000000003,4541.891000214594,3391.8959110856131,null,1149.9950891289809]
["Westlands Water District",4.2923950568365399E-2,8545.8799999999992,8545.9229239505676,6382.1172768855904,2163,0.80564706497716543]
["Total",1604216.8815000001,468353.85000000003,2072570.7315,1547801.1668000002,2163,522606.56470000005]
[]
["**"]
["Project Use Energy O&M cost recoverable through water rates are for Storage and Direct Pumping.  Beginning March 2016, there are 8 contractors that pay the Project Use Energy O&M based on Rates times their Acre-Feet. "]
["   These 8 contractors receive a credit to their O&M cost for paying WAPA on behalf of others for Storage and Direct Pumping Project Use Energy.  The credit is offset by allocating the credit to the contractors receiving the service.  "]
["   Any shortages in payment of Project Use Energy O&M cost will be recoverable in the following year under a similar process (See schedule B-6A for a detail summary of the remaining cost)."]
[]
["Footnotes"]
[]
["1/"]
["Allocation of Gianelli, WR Pump Generator"]
[]
["Gianelli, WR Pump Generator Costs"," San Felipe Unit (Storage): Total","San Benito County WD","Santa Clara Valley WD","All Other Storage Contractors","Grand Total"]
["2022 Storage Deliveries (Excludes 215 Water)",63334,1997,61337,"-","-"]
["2022 Storage Deliveries (Excludes 215 Water) Ratios",1,3.1530000000000002E-2,0.96847000000000005,"-","-"]
["2021 Storage Deliveries (for True-Up)",75398,1407,73991,"-","-"]
["2021 Storage Deliveries (for True-Up) Ratios",1,1.866E-2,0.98133999999999999,"-","-"]
["Gianelli, WR Pump Generator (2022 Estimate)",531102.4,16745.66,514356.74,1497237.95373107,2028340.3537310702]
["Gianelli, WR Pump Generator (2021 True-Up)",-38.71,-0.72,-37.99,-178.6070676077,-217.31706760770001]
[]
["2/"]
["Allocation of Other PUE storage costs"]
[]
["Other PUE Storage Costs"," San Felipe Unit (Storage): Total"," San Felipe Unit (Storage): San Benito County WD"," San Felipe Unit (Storage): Santa Clara Valley WD","All Other Contractors","Grand Total"]
["2022 Storage Deliveries (Excludes 215 Water)",63334,1997,61337,147440,210774]
["2022 Storage Deliveries (Excludes 215 Water) Ratios",0.30048000000000002,3.1530000000000002E-2,0.96847000000000005,0.69952000000000003,1]
["2021 Storage Deliveries (for True-Up)",75398,1407,73991,187442,262840]
["2021 Storage Deliveries (for True-Up) Ratios",0.28686,1.866E-2,0.98133999999999999,0.71314,1]
["Other PUE Offset Storage Cost (2022 Estimate)",44059.05,1389.18,42669.87,102569.85,146628.90000000002]
["Other PUE Offset Storage Cost (2021 True-Up)",-44.063743502922733,-0.82222945376453827,-43.241514049158198,-109.54339413537727,-153.6071376383]
[]
["3/"]
["Allocation of Pacheco Pumping Plant costs - Allocation is based on same water delivery ratios as shown in 1/ above."]
[]
["Pacheco Pumping Plant Costs","Total","San Benito County WD","Santa Clara Valley WD"]
["Pacheco PP (2022 Estimate)",1418034.68513563,44710.633622326415,1373324.0515133035]
["Pacheco PP (2021 True-Up)",-649.57707071360005,-12.121108139515776,-637.45596257408431]
["4/"]
["Contra Costa WD's FY 2013 - FY 2021 PUE credit is applied to FY 2022 costs."]
["Note:  Storage Expense Allocation"]
[]
["Contra Costa WD Costs","San Felipe Unit Contractors","All Other Contractors","Total"]
["2022 Estimate Gianelli, WR Pump Generator",0,1497237.95373107,1497237.95373107]
["2022 Estimate Other PUE Offset Storage Cost",44059.05,102569.85,146628.90000000002]
["2022 Estimate Regeneration Credit for FY 2022",0,-358189.17792515701,-358189.17792515701]
["2022 Estimate: Total",44059.05,1241618.625805913,1285677.6758059133]
["2021 True-Up Gianelli, WR Pump Generator",0,-178.6070676077,-178.6070676077]
["2021 True-Up Other PUE Offset Storage Cost",-44.063743502922733,-109.54339413537727,-153.6071376383]
["2021 True-Up Regeneration Credit for FY 2022",0,408.94741431239999,408.94741431239999]
["2021 True-Up: Total",-44.063743502922733,120.79695256932274,76.733209066399979]