{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["OUTPUT"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":109,"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":121,"n_cols":11,"rows_kept":121,"cut":false,"hidden":false,"merged":[]}
[]
["IRR 2024 Sch B-6A.Z28"]
["2025-08-12"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION  OPERATION & MAINTENANCE EXPENSE AND PROJECT USE ENERGY COST"]
["BY FACILITY AND/OR COMPONENT FOR FY 2024"]
["2026 IRRIGATION WATER RATES"]
[]
["Category","A) Facility/Contractor\n<Ref>","Related Footnotes","B) Unpaid/(Credit) Previous Period","C) Estimated 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,4376.46,0,4376.46,-4376.46,"-","-",0]
["Storage (Based on Offset)","All Others","-",0,-2739920.5841499502,0,-2739920.5841499502,2739920.5841499502,"-","-",0]
["Total","Storage Total (Based on Offset)","-",0,-2735544.1241499502,0,-2735544.1241499502,2735544.1241499502,"-","-",0]
["Direct Pumping (Based on Offset)","Corning WD","-",0,85176.998999999996,0,85176.998999999996,-85176.998999999996,"-","-",0]
["Direct Pumping (Based on Offset)","Cross Valley Canal Contractors (Dos Amigos & Banks)","-",0,472363.25211599702,0,472363.25211599702,-472363.25211599702,"-","-",0]
["Direct Pumping (Based on Offset)","Dunnigan WD","-",0,8184.8856999999998,0,8184.8856999999998,-8184.8856999999998,"-","-",0]
["Direct Pumping (Based on Offset)","Panoche WD","-",0,1075.9653000000001,0,1075.9653000000001,-1075.9653000000001,"-","-",0]
["Direct Pumping (Based on Offset)","Proberta WD","-",0,775.98230000000001,0,775.98230000000001,-775.98230000000001,"-","-",0]
["Direct Pumping (Based on Offset)","Glenn Valley WD","-",0,0,0,0,0,"-","-",0]
["Direct Pumping (Based on Offset)","Westside WD","-",0,23781.3766,0,23781.3766,-23781.3766,"-","-",0]
["Direct Pumping (Based on Offset)","Wintu PP (Bella Vista WD)","-",0,23995.653325762501,0,23995.653325762501,-23995.653325762501,"-","-",0]
["Total","Direct Pumping Total (Based on Offset)","-",0,615354.11434175947,0,615354.11434175947,-615354.11434175947,"-","-",0]
["Direct Pumping (Direct Cost)","Colusa County WD","-",-0.72608386387582868,433820.93213022698,0,433820.20604636311,"-",-36630,-1724.32,395465.8860463631]
["Direct Pumping (Direct Cost)","Kanawha WD","-",-0.28891767219465692,32513.839037380501,0,32513.550119708307,"-",-62211.24,null,-29697.689880291691]
["Direct Pumping (Direct Cost)","Orland-Artois WD","-",-73581.955324268216,130793.08130000001,0,57211.125975731789,"-",-260150.36,null,-202939.2340242682]
["Direct Pumping (Direct Cost)","San Benito County WD","1/, 3/",-0.14383722806815058,245863.00394648325,0,245862.86010925518,"-",-1915.56,null,243947.30010925519]
["Direct Pumping (Direct Cost)","Santa Clara Valley WD","1/, 3/",-0.91500011400785297,690088.617803175,0,690087.70280306099,"-",0,-492825.85,197261.85280306102]
["Direct Pumping (Direct Cost)","San Luis WD","-",-576380.31534902635,618885.90259622701,0,42505.587247200659,"-",-294649.74,null,-252144.15275279933]
["Direct Pumping (Direct Cost)","Westlands WD","4/",-0.17245825380086899,5758151.3456805963,0,5758151.1732223425,"-",-1534087.48,null,4224063.6932223421]
["Direct Pumping (Direct Cost)","Westlands WD DD #2","4/",0.74673173500013945,18543.189457794237,0,18543.936189529239,"-",0,null,18543.936189529239]
["Total","Direct Pumping Total (Direct Cost)","-",-649963.77023869159,7928659.9119518837,0,7278696.1417131918,0,-2189644.38,-494550.17,4594501.5917131919]
["Grand Total","Grand Total","-",-649963.77023869159,5808469.9021436926,0,5158506.1319050007,2120190.0098081906,-2189644.38,-494550.17,4594501.5917131919]
[]
[]
["Needed based on Column F"]
[]
["Facility/Contractor","Total Cost FY2024"]
["Storage",-2735544.1241499502]
["Direct Pumping",615354.11434175947]
["Storage & Direct Pumping Total",-2120190.0098081906]
["Applied (offset/credit) **",-2120190.0098081906,1]
[null," "]
[]
["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)"]
["Westlands Water District",0.46807045582681894,-24966.6,-24966.131929544172,-1520800.6426944423,0,-1545766.7746239866]
["Westlands Water District DD#2",7.3122555149893742E-3,0,7.3122555149893742E-3,-4800.5226261950984,0,-4800.5153139395834]
["Santa Clara Valley Water District",-106456.37321085535,0,-106456.37321085535,0,0,-106456.37321085535]
["San Benito County Water District",-0.64072735700756311,0,-0.64072735700756311,-16259.19276922274,0,-16259.833496579748]
["Colusa County Water District",-5.103901115944609E-3,0,-5.103901115944609E-3,-171384.75022304815,0,-171384.75532694926]
["Kanawha Water Districit",0.80017408281855751,-13577.85,-13577.049825917182,-28391.420367806375,0,-41968.470193723559]
["Orland-Artois Water Districit",63961.301631219729,-51249.5,12711.801631219729,-90717.274362186436,0,-78005.472730966707]
["San Luis Water Districit",-108234.77509460936,-16206.38,-124441.15509460936,-287836.20676528959,0,-412277.36185989896]
["Total",-150729.21694870893,-106000.33,-256729.54694870894,-2120190.0098081906,0,-2376919.5567568997]
[]
["Because Column M is a credit, it is being allocated from the ratio of PUE Other Cost (K) on the B2 over the last two years."]
["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"]
["2024 Storage Deliveries (Excludes 215 Water)",47170,12492,34678]
["2024 Storage Deliveries (Excludes 215 Water): Ratios",1,0.26483000000000001,0.73516999999999999]
["2023 Storage Deliveries (for True-Up)",2919,2919,0]
["2023 Storage Deliveries (for True-Up): Ratios",1,1,0]
[]
["Gianelli (2023 True-Up and 2024 Estimate)"," San Felipe Unit (Storage): Total","San Benito County WD","Santa Clara Valley WD","All Other Storage Contractors","Grand Total"]
["Gianelli, WR Pump Generator (2024 Estimate)",641927.62,170001.69,471925.93,1450752.1419711099,2092679.76197111]
["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)",47170,12492,34678,2505004,2552174]
["2024 Storage Deliveries (Excludes 215 Water): Ratios",1.848E-2,0.26483000000000001,0.73516999999999999,0.98151999999999995,1]
["2023 Storage Deliveries (for True-Up)",2919,2919,0,1805108,1808027]
["2023 Storage Deliveries (for True-Up): Ratios",1.6100000000000001E-3,1,0,0.99839,1]
["Other PUE Offset Storage Cost (2024 Estimate)",4376.46,1159.02,3217.44,232444.59,236821.05]
["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)",286452.87145143398,75861.313946483264,210591.5575049507]
["Pacheco PP (2023 True-Up)",0,0,0]
[]
["4/"]
["Allocation of Pleasant Valley PP, Pleasant Valley Relifts, & Westlands WD Relifts"]
[]
["Pleasant Valley PP, Pleasant Valley Relifts, & Westlands WD Relifts Costs","Total","Westlands WD DD ","Westlands WD DD #2"]
["2024 Storage Deliveries (Excludes 215 Water)",780777,778273,2504]
["2024 Storage Deliveries (Excludes 215 Water): Ratios",1,0.99678999999999995,3.2100000000000002E-3]
["2023 Storage Deliveries (for True-Up)",613119,611021,2098]
["2023 Storage Deliveries (for True-Up): Ratios",1,0.99658000000000002,3.4199999999999999E-3]
["2024 Estimate Pleasant Valley PP",1248110.6843803499,1244104.2490834889,4006.4352968609237]
["2024 Estimate Pleasant Valley Relifts",137864.57889999996,137422.03360173097,442.545298269]
["2024 Estimate Westlands WD Relifts",4390719.2718580402,4376625.0629953761,14094.208862664311]
["2024 Estimate: Total",5776694.53513839,5758151.3456805963,18543.189457794237]
["2023 True-Up Pleasant Valley PP",0,0,0]
["2023 True-Up Pleasant Valley Relifts",0,0,0]
["2023 True-Up Westlands WD Relifts",0,0,0]
["2023 True-Up: Total",0,0,0]
[]
["Note:  Storage Expense Allocation"]
[]
["Storage Expense Allocation Costs","San Felipe Unit Contractors","All Other Contractors","Total"]
["2024 Estimate Gianelli, WR Pump Generator",0,1450752.1419711099,1450752.1419711099]
["2024 Estimate Other PUE Offset Storage Cost",4376.46,232444.59,236821.05]
["2024 Estimate Regeneration Credit for FY 2023",null,-4423117.3161210604,-4423117.3161210604]
["2024 Estimate PUE Offset Storage Cost: Total",4376.46,-2739920.5841499502,-2735544.1241499502]
["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 2022",null,0,0]
["2023 True-Up PUE Offset Storage Cost: Total",0,0,0]