{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OUTPUT","Footnotes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":67,"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":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2024 Sch A-5 F.Z26.XLSM"]
["09/28/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I CONSTRUCTION AND PROJECT USE ENERGY COSTS BY COMPONENT"]
["AS OF SEPTEMBER 30, 2022"]
["2024 M&I WATER RATES"]
[]
["Category","Footnotes","A) Facility/Contractor","B) M&I Construction Cost at 09/30/22\n\n<Cost Allocation>","C) Allocation of Project Use Energy Construction Costs Historical & Projected (1981-2030) KWH Per AF  2/ \n\n <Sch A-7 & CVO)","D) Allocation of Project Use Energy Construction Costs Ratio of Total \n\n(C/Total C)","E) Allocation of Project Use Energy Construction Costs CVP PUE Construction Costs as of 09/30/22 (BOR) 2/\n\n(D*Total PUE BOR)","F) Allocation of Project Use Energy Construction Costs CVP PUE Construction Costs as of 09/30/22 (DOE) 2/ \n\n(D*Total PUE DOE)\n","G) Total M&I Construction Costs at 09/30/22\n\n(B+E+F)"]
["Storage        ","1/","San Felipe Unit Contractors",10241241.85,0,0,0,0,10241241.85]
["Storage        ","-","All Other Contractors",39709080.399999999,178446256.71793529,3.5976314946524E-2,613434.33171431394,604112.84530694596,40926627.577021264]
["Total","-","Total Storage",49950322.25,178446256.71793529,3.5976314946524E-2,613434.33171431394,604112.84530694596,51167869.427021265,null,null,null,""]
["Conveyance"," 3/","Contra Costa WD   ",0,"-","-","-","-",0]
["Conveyance","-","All Other Contractors",26956531.329999991,"-","-","-","-",26956531.329999991]
["Total","-","Total Conveyance",26956531.329999991,"-","-","-","-",26956531.329999991]
["Conveyance Pumping","-","Dos Amigos Pumping Plant",287010.995,89493932,1.80427538389E-2,307648.09180438,302973.20264714397,897632.28945152392]
["Conveyance Pumping","-","O'Neill Pump-Generator Plant",1784352.2549999999,279018057,5.6252463229116E-2,959164.16785679804,944589.11835129501,3688105.5412080931]
["Conveyance Pumping","-","Jones Pumping Plant",4496201.0149999997,1178429841,0.237581689198509,4051019.8156114002,3989462.2466998701,12536683.07731127]
["Total","-","Total Conveyance Pumping",6567564.2649999997,1546941830,0.31187690626652498,5317832.0752725787,5237024.5676983092,17122420.907970887]
["Direct Pumping","-","Bella Vista WD (Wintu PP)",495398.88,66035814,1.3313393544418E-2,227007.482114529,223557.97326003201,945964.33537456102]
["Direct Pumping","-","Colusa County WD",33742.199999999997,678288,1.3674875091999999E-4,2331.71125942354,2296.2795698572199,38370.190829280757]
["Direct Pumping","-","Contra Costa Pumping Plants",0,817811952,0.16487799124130401,2811344.6449934398,2768624.6511165202,5579969.2961099595]
["Direct Pumping","-","Kanawha WD",1880.7650000000001,11599,2.3384591230000002E-6,39.873208567664697,39.267312300589303,1959.9055208682541]
["Direct Pumping","-","Pleasant Valley Canalside Relifts",26512.485000000001,3918038,7.8991048427100004E-4,13468.8116543667,13264.1453383999,53245.441992766602]
["Direct Pumping","-","Pleasant Valley Pumping Plant",214283.84,50067,1.0093941971999999E-5,172.112417771547,169.49707089600901,214625.44948866754]
["Direct Pumping","-","San Benito County WD","-","-","-","-","-","-"]
["Direct Pumping","-","Pacheco Pumping Plant      ",0,36616390,7.3821821935270001E-3,125874.037049397,123961.308881547,249835.34593094399]
["Direct Pumping","1/","Gianelli, William R. Pump-Generator Plant   ",41493.919999999998,55220721,1.1132976879478E-2,189829.06510032501,186944.503610082,418267.48871040705]
["Direct Pumping","-","San Luis WD Canalside Relifts & Turnouts",0,12612472,2.5427838794260002E-3,43357.162402213398,42698.325458958498,86055.487861171889]
["Direct Pumping","-","Santa Clara Valley WD                  ","-","-","-","-","-","-"]
["Direct Pumping","-","Coyote Pumping Plant       ",0,224473997,4.5255907083229997E-2,771661.22097251005,759935.38625718502,1531596.6072296952]
["Direct Pumping","-","Pacheco Pumping Plant    ",0,779908183,0.157236262262031,2681045.05993282,2640305.0429633399,5321350.1028961595]
["Direct Pumping"," 1/","Gianelli, William R. Pump-Generator Plant  ",883800.77,1176169810,0.23712604732324399,4043250.6383160101,3981811.1265082499,8908862.5348242596]
["Direct Pumping","-","Shasta Pumping Plant",314152.02,44272590,8.9257385984619995E-3,152193.31108099499,149880.64645303201,616225.97753402707]
["Direct Pumping","-","State-Delta Pumping Plant (Cross Valley Canal)",0,2654289,5.3512771172399998E-4,9124.4951216144109,8985.8431863493497,18110.338307963761]
["Direct Pumping","-","Westlands WD Canalside Relift PP",717550.19500000007,14281510,2.8792764338230002E-3,49094.717389159297,48348.6950080225,814993.6073971818]
["Total","-","Total Direct Pumping",2728815.0750000002,3234715720,0.65214677878695304,11119794.343013141,10950822.691994771,24799432.110007912]
["Total","4/","Other Costs   ",7641684.1350000007,"-","-","-","-",7641684.1350000007]
["Grand Total","-","-",93844917.054999992,4960103806.7179356,1.000000000000002,17051060.750000034,16791960.105000027,127687937.91000006]
[null,null,null,null,null,null,null,null,null,""]

{"sheet":"Footnotes","index":1,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["M&I 2024 Sch A-5 F.Z26.XLSM"]
["09/28/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I CONSTRUCTION AND PROJECT USE ENERGY COSTS BY COMPONENT"]
["AS OF SEPTEMBER 30, 2022"]
["2024 M&I WATER RATES"]
[]
["Footnotes:"]
["1/ Allocation of Storage Costs:"]
[]
["Category","Storage San Felipe Unit","San Benito County WD San Felipe Unit Suballocation of Storage Costs (Dir. Pump. Appl. to SL/PG)","Santa Clara Valley WD San Felipe Unit Suballocation of Storage Costs (Dir. Pump. Appl. to SL/PG)","All Other Storage Contractors","Total"]
["Historical and Projected 1981-2030 M&I Deliveries (Sch A-7)",3884512.7142857155,174197.85714285704,3710314.8571428582,13813593.853333332,17698106.567619048]
["Ratios",0.21948699999999999,4.4844000000000002E-2,0.95515600000000001,0.78051300000000001,1]
["Allocated Gianelli, WR Pump-Generator Costs",925294.69,41493.919999999998,883800.77,3290420.54,4215715.2300000004]
["Allocated Other Storage Costs",10241241.85,0,0,36418659.859999999,46659901.710000001]
["Total",11166536.539999999,41493.919999999998,883800.77,39709080.399999999,50875616.939999998]
[]
["2/ These costs represent the total Pumping Project Use Power costs allocated to Irrigation for the CVP Bureau of Reclamation (BOR)  and Western Area Power Administration (DOE).  The costs are allocated to "]
["components based on the ratios identified above under \"Allocation of Project Use Energy Costs\".  They are then suballocated to individual facilities based on the historical and projected 1981-2030 KWHs/AF."]
[]
["3/ Allocated costs are recovered through a repayment contract."]
[]
["4/ This amount includes Level 2 Refuge Water Supply and Trinity River Restoration Program"]