{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PUE DP","PUE Other","Footnotes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":4,"defined_names":165,"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":"PUE DP","index":0,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2023 Sch B-6A.Z27"]
["09/26/2024"]
[null,null,null,"CENTRAL VALLEY PROJECT"]
[null,null,null,"SCHEDULE OF M&I PROJECT USE ENERGY OPERATION & MAINTENANCE COSTS"]
[null,null,null,"BY FACILITY AND/OR COMPONENT"]
[null,null,null,"2025 M&I WATER RATES"]
[]
["Category","A) Facility/Contractor\n<Ref>","Related Footnotes","B) Unpaid/(Credit) Previous Period","C) Estimated Project Use Energy Cost\nFY2023","D) True-Up\nFY2022","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,25139.75,0,25139.75,-25139.75,0,0,0]
["Storage (Based on Offset)","All Others","-",0,796530.99021433701,0,796530.99021433701,-796530.99021433701,0,0,0]
["Total","Storage Total (Based on Offset)","-",0,821670.74021433701,0,821670.74021433701,-821670.74021433701,0,0,0]
["Direct Pumping (Based on Offset)","City of Shasta Lake","-",0,578.44560000000001,0,578.44560000000001,-578.44560000000001,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,69588.451867524898,0,69588.451867524898,-69588.451867524898,0,0,0]
["Direct Pumping (Based on Offset)","Wintu PP (Bella Vista WD)","-",0,137030.53347443399,0,137030.53347443399,-137030.53347443399,0,0,0]
["Total","Direct Pumping Total (Based on Offset)","-",0,207197.43094195891,0,207197.43094195891,-207197.43094195891,0,0,0]
["Direct Pumping (Direct Cost)","Contra Costa WD","4/",-2380842.2000000002,349397.025514081,0,-2031445.1744859191,0,-1512195.26,0,-3543640.43]
["Direct Pumping (Direct Cost)","Colusa County WD","-",2417.88,900.58612861840004,0,3318.4661286184,0,-1997.28,-1321,0.19]
["Direct Pumping (Direct Cost)","Kanawha WD","-",0.37,47.103685113099999,0,47.473685113099997,0,-66.87,19,-0.4]
["Direct Pumping (Direct Cost)","San Benito County WD","1/, 3/",-272930.23,296316.31310858403,0,23386.083108584047,0,-233106.75,0,-209720.67]
["Direct Pumping (Direct Cost)","Santa Clara Valley WD","1/, 3/",0.12,3012977.0019,0,3012977.1219000001,0,-2568330.2400000002,0,444646.88]
["Direct Pumping (Direct Cost)","San Luis WD ","-",0.47,5843.1425144601999,0,5843.6125144602001,0,-9006.2999999999993,0,-3162.69]
["Direct Pumping (Direct Cost)","Westlands WD  ","-",2.98,27308.9008105758,0,27311.8808105758,0,-36748.31,0,-9436.43]
["Total","Direct Pumping Total (Direct Cost)","-",-2651350.61,3692790.0736614326,0,1041439.4636614327,0,-4361451.01,-1302,-3321313.5500000003]
["Grand Total","Grand Total","-",-2651350.61,4721658.2448177282,0,2070307.6348177288,-1028868.1711562959,-4361451.01,-1302,-3321313.5500000003]

{"sheet":"PUE Other","index":1,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2023 Sch B-6A.Z27"]
["09/26/2024"]
[null,null,null,"CENTRAL VALLEY PROJECT"]
[null,null,null,"SCHEDULE OF M&I PROJECT USE ENERGY OPERATION & MAINTENANCE COSTS"]
[null,null,null,"BY FACILITY AND/OR COMPONENT"]
[null,null,null,"2025 M&I WATER RATES"]
[]
["Facility/Contractor","J) Available From Previous Period **","K) Rate x AF in FY 2023 for \"Other\" Cost","L) Total Available             J+K","M) Applied to \"Other\" Cost 5/","N) Charge Adjustment","O) Unpaid/ (Remaining)   SUM(L:N)"]
["Contra Costa WD",-161364.94814022054,-445114.12,-606479.0681402206,295975.79722896079,0,-310503.27091125981]
["Colusa County Water District",-262.6540299229157,-671.04,-933.69402992291566,446.2037712317952,0,-487.49025869112046]
["Kanawha Water Districit",-14.373975672904038,-21.26,-35.633975672904043,14.136701502724081,0,-21.497274170179963]
["San Benito County Water District",-13690.736708020799,-78045,-91735.736708020791,51895.525342431836,0,-39840.211365588955]
["Santa Clara Valley Water District",-346123.05110996892,-1005315.88,-1351438.931109969,668478.38718289661,0,-682960.54392707243]
["San Luis Water Districit",-1149.9950891289809,-2716.11,-3866.105089128981,1806.0600337988667,0,-2060.0450553301143]
["Westlands Water District",-0.80564706497716543,-15417.94,-15418.745647064978,10252.060939177316,0,-5166.6847078876617]
["Total",-522606.56470000005,-1547301.35,-2069907.9147000001,1028868.1712,0,-1041039.7435000003]

{"sheet":"Footnotes","index":2,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2023 Sch B-6A.Z27"]
["09/26/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I OPERATION & MAINTENANCE EXPENSE AND PROJECT USE ENERGY COST"]
["BY FACILITY AND/OR COMPONENT FOR FY 2023"]
["2025 IRRIGATION WATER RATES"]
[]
["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"]
["2023 Storage Deliveries (Excludes 215 Water)",113971,8871,105100,"-","-"]
["2023 Storage Deliveries (Excludes 215 Water) Ratios",1,7.7840000000000006E-2,0.92215999999999998,"-","-"]
["2022 Storage Deliveries (for True-Up)",63334,1997,61337,"-","-"]
["2022 Storage Deliveries (for True-Up) Ratios",1,3.1530000000000002E-2,0.96847000000000005,"-","-"]
["Gianelli, WR Pump Generator (2023 Estimate)",3175685.78,247195.38,2928490.4,1019853.62466817,4195539.40466817]
["Gianelli, WR Pump Generator (2022 True-Up)",0,0,0,0,0]
[]
["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"]
["2023 Storage Deliveries (Excludes 215 Water)",113971,8871,105100,249762,363733]
["2023 Storage Deliveries (Excludes 215 Water) Ratios",0.31334000000000001,7.7840000000000006E-2,0.92215999999999998,0.68666000000000005,1]
["2022 Storage Deliveries (for True-Up)",63334,1997,61337,147440,210774]
["2022 Storage Deliveries (for True-Up) Ratios",0.30048000000000002,3.1530000000000002E-2,0.96847000000000005,0.69952000000000003,1]
["Other PUE Offset Storage Cost (2023 Estimate)",25139.75,1956.88,23182.87,55091.78,80231.53]
["Other PUE Offset Storage Cost (2022 True-Up)",0,0,0,0,0]
[]
["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 (2023 Estimate)",631050.01424182998,49120.933108584053,581929.08113324596]
["Pacheco PP (2022 True-Up)",0,0,0]
[]
["4/"]
["Contra Costa WD's FY 2013 - FY 2022 PUE credit is applied to FY 2023 costs."]
["Note: Storage Expense Allocation"]
[]
["Contra Costa WD Costs","San Felipe Unit Contractors","All Other Contractors","Total"]
["2023 Estimate Gianelli, WR Pump Generator",0,1019853.62466817,1019853.62466817]
["2023 Estimate Other PUE Offset Storage Cost",25139.75,55091.78,80231.53]
["2023 Estimate Regeneration Credit for FY 2023",0,-278414.41445383301,-278414.41445383301]
["2023 Estimate: Total",25139.75,796530.99021433701,821670.74021433701]
["2022 True-Up Gianelli, WR Pump Generator",0,0,0]
["2022 True-Up Other PUE Offset Storage Cost",0,0,0]
["2022 True-Up Regeneration Credit for FY 2023",0,0,0]
["2022 True-Up: Total",0,0,0]
[]
["5/"]
["Amount Applied to \"Other Cost\" is a Credit in Accounting for these Contractors."]
[]
["Facility/Contractor","Total Cost FY2023"]
["Storage",821670.74021433701]
["Direct Pumping",207197.43094195891]
["Storage & Direct Pumping Total",1028868.1712]
["Applied (offset/credit) **",1028868.1712]
[]
["**"]
["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 "]
["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)."]