{"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":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":11,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2024 Sch B-6A.Z28"]
["2025-09-15"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I PROJECT USE ENERGY OPERATION & MAINTENANCE COSTS"]
["BY FACILITY AND/OR COMPONENT"]
["2026 M&I WATER RATES"]
[]
["Category","A) Facility/Contractor\n<Ref>","Related Footnotes","B) Unpaid/(Credit) Previous Period","C) Project Use Energy Cost\nFY2024","D) True-Up\nFY2023","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,41986.450000000004,0,41986.450000000004,-41986.450000000004,0,0,0]
["Storage (Based on Offset)","All Others","-",0,-207611.95522534003,0,-207611.95522534003,207611.95522534003,0,0,0]
["Total","Storage Total (Based on Offset)","-",0,-165625.50522534002,0,-165625.50522534002,165625.50522534002,0,0,0]
["Direct Pumping (Based on Offset)","City of Shasta Lake","-",0,43865.055999999997,0,43865.055999999997,-43865.055999999997,0,0,0]
["Direct Pumping (Based on Offset)","Cross Valley Canal Contractors (Dos Amigos & Banks)","-",0,8657.6033600967003,0,8657.6033600967003,-8657.6033600967003,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,379154.16041964799,0,379154.16041964799,-379154.16041964799,0,0,0]
["Direct Pumping (Based on Offset)","Wintu PP (Bella Vista WD)","-",0,98912.315178239995,0,98912.315178239995,-98912.315178239995,0,0,0]
["Total","Direct Pumping Total (Based on Offset)","-",0,530589.13495798467,0,530589.13495798467,-530589.13495798467,0,0,0]
["Direct Pumping (Direct Cost)","Contra Costa WD","-",-3543640.43,537752.84719999996,0,-3005887.5828,0,-1760040.52,0,-4765928.0999999996]
["Direct Pumping (Direct Cost)","Colusa County WD","-",0.19,1055.8665597726001,0,1056.0565597726002,0,-2780.38,0,-1724.32]
["Direct Pumping (Direct Cost)","Kanawha WD","-",-0.4,46.031862619499996,0,45.631862619499998,0,-91.82,0,-46.19]
["Direct Pumping (Direct Cost)","San Benito County WD","1/, 3/",-0.67,61373.382213008634,0,61372.712213008635,0,-57202.46,0,4170.25]
["Direct Pumping (Direct Cost)","Santa Clara Valley WD","1/, 3/",0,1687432.026737333,0,1687432.026737333,0,-2180483.1,492825.85,-225.22]
["Direct Pumping (Direct Cost)","San Luis WD ","-",-3162.69,4296.5909037725996,0,1133.9009037725996,0,-9300.98,0,-8167.08]
["Direct Pumping (Direct Cost)","Westlands WD  ","-",-0.43,391628.59704196203,0,391628.16704196204,0,-45380.63,0,346247.54]
["Total","Direct Pumping Total (Direct Cost)","-",-3546804.43,2683585.3425184684,0,-863219.08748153155,0,-4055279.89,492825.85,-4425673.12]
["Grand Total","Grand Total","-",-3546804.43,3048548.972251113,0,-498255.4577488869,-364963.62973264465,-4055279.89,492825.85,-4425673.12]
[]
[]
["Needed based on Column F"]
[]
["Facility/Contractor","Total Cost FY2024"]
["Storage",-165625.50522534002]
["Direct Pumping",530589.13495798467]
["Storage & Direct Pumping Total",364963.62969999999]
["Applied (offset/credit) **",364963.62969999999,null,1]
[]
[]
["Amount Applied to \"Other\" Cost is a Credit in Accounting for following Contractors; "]
[]
["Facility/Contractor","J) Unpaid/(Credit) Previous Period **","K) Other Cost Rate x AF","L) Total Available             J+K","M) Applied to \"Other\" Cost","N) Charge Adjustment","O) Unpaid/ (Remaining)   SUM(L:N)"]
["Contra Costa WD",-310503.27091125981,-396895.16,-707398.43091125973,160384.42646194785,0,-547014.00444931188]
["Colusa County Water District",-487.49025869112046,-611.32000000000005,-1098.8102586911205,247.03301391913664,0,-851.77724477198376]
["Kanawha Water Districit",-21.497274170179963,-18.36,-39.857274170179963,7.4192340109195642,0,-32.438040159260396]
["San Benito County Water District",-0.21136558895523194,-11197.21,-11197.421365588954,4524.766953126833,0,-6672.6544124621214]
["Santa Clara Valley Water District",-3.927072393707931E-3,-481051.59,-481051.59392707242,194391.84736029053,0,-286659.74656678189]
["San Luis Water Districit",-2060.0450553301143,-2647.11,-4707.1550553301149,1069.69109709397,0,-3637.4639582361451]
["Westlands Water District",-0.68470788766171609,-10736.13,-10736.814707887661,4338.4455796107768,0,-6398.3691282768841]
["Total",-313073.20350000018,-903156.88,-1216230.0834999999,364963.62969999999,0,-851266.45380000013]
[]
["**"]
["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"]
["2024 Storage Deliveries (Excludes 215 Water)",87926,3119,84807,"-","-"]
["2024 Storage Deliveries (Excludes 215 Water) Ratios",1,3.5470000000000002E-2,0.96453,"-","-"]
["2023 Storage Deliveries (for True-Up)",113971,8871,105100,"-","-"]
["2023 Storage Deliveries (for True-Up) Ratios",1,7.7840000000000006E-2,0.92215999999999998,"-","-"]
["Gianelli, WR Pump Generator (2024 Estimate)",1196334.83,42434,1153900.83,169719.120353598,1366053.950353598]
["Gianelli, WR Pump Generator (2023 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"]
["2024 Storage Deliveries (Excludes 215 Water)",87926,3119,84807,293180,381106]
["2024 Storage Deliveries (Excludes 215 Water) Ratios",0.23071,3.5470000000000002E-2,0.96453,0.76929000000000003,1]
["2023 Storage Deliveries (for True-Up)",113971,8871,105100,249762,363733]
["2023 Storage Deliveries (for True-Up) Ratios",0.31334000000000001,7.7840000000000006E-2,0.92215999999999998,0.68666000000000005,1]
["Other PUE Offset Storage Cost (2024 Estimate)",41986.450000000004,1489.26,40497.19,140001.54999999999,181988]
["Other PUE Offset Storage Cost (2023 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 (2024 Estimate)",533954.95384856605,18939.382213008637,515015.5716355574]
["Pacheco PP (2023 True-Up)",0,0,0]
[]
[]
[]
["Note:  Storage Expense Allocation"]
[]
["Contra Costa WD Costs","San Felipe Unit Contractors","All Other Contractors","Total"]
["2024 Estimate Gianelli, WR Pump Generator",0,169719.120353598,169719.120353598]
["2024 Estimate Other PUE Offset Storage Cost",41986.450000000004,140001.54999999999,181988]
["2024 Estimate Regeneration Credit for FY 2024",0,-517332.62557893799,-517332.62557893799]
["2024 Estimate: Total",41986.450000000004,-207611.95522534003,-165625.50522533996]
["2023 True-Up Gianelli, WR Pump Generator",0,0,0]
["2023 True-Up Other PUE Offset Storage Cost",0,0,0]
["2023 True-Up Regeneration Credit for FY 2024",0,0,0]
["2023 True-Up: Total",0,0,0]