{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OUTPUT","Footnote"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":28,"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":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Bureau of Reclamation logo"]
["2025 Cost of Service Additional Service Water Rates Sch TR-1.Z27.xlsm"]
["01/11/2025"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF WATER RATES FOR ADDITIONAL CVP SERVICES WHEN TRANSFERRING"]
["CVP WATER TO CVP M&I WATER CONTRACTORS"]
["2025 SPECIAL WATER RATES"]
[]
["Category","A) Component / Facility\n<Ref>","Related Footnotes","B) Net\nConstruction\nCosts\nat 9/30/2023\n<M&I Sch A-4, M&I Sch A-2Bc FSOD>","C) Construction with Int. Annualized Costs @ 0.023607\n","D) 7 Year Average Water\nDeliveries\n<M&I Sch A-7 divided by 50>","7 Year Average Water\nDeliveries Footnotes","E) Construction\nCost\nper Acre-Foot\n(C/D)"]
["Storage","San Felipe Unit","-",9842239.2899999991,337421.20605273522,79219.519999999975,"-",4.26]
["Storage","All Other Contractors","-",41163133.285328753,1411194.5126305821,276227.36182857136,"-",5.1100000000000003]
["Folsom SOD","San Felipe Unit","5/",1896015.8100000003,65001.05539552003,79219.519999999975,"-",0.82]
["Folsom SOD","All Other Contractors","5/",4848347.24,166215.74876211429,276227.36182857136,"-",0.6]
["Total","Storage","-",57749735.625328757,1979832.5228409516,"-","-",0]
["Conveyance","Contra Costa Canal System","1/",0,0,"-","-",0]
["Conveyance","All Other Contractors","-",26941175.07,923623.5288277861,191515.79999999996,"-",4.82]
["Total","Conveyance","-",26941175.07,923623.5288277861,"-","-",0]
["Conveyance Pumping","Dos Amigos Pumping Plant, Construction only","-",287465,9855.1543139680689,12752.445907414993,"  3/",0.77]
["Conveyance Pumping","Dos Amigos Pumping Plant, PUE only","-",607830.8669254391,20838.248100962526,12925.625907414993,"-",1.61]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, Construction only","-",1664792.97,57074.049432658641,92655.879999999976,"-",0.62]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, PUE only","-",1933709.842837644,66293.318837437342,92655.879999999976,"-",0.72]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, Construction only","2/",1528846.1426592106,52413.388267167698,51716.499999999993,"4/",1.01]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, PUE only","2/",2717251.5405722177,93155.456289310605,51716.499999999993,"4/",1.8]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, Construction only","2/",3063249.0373407886,105017.27850384433,100773.51999999997,"1/",1.04]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, PUE only","2/",5421560.6975142416,185867.20921345978,100773.51999999997,"1/",1.84]
["Total","Conveyance Pumping","-",17224706.09784954,590514.102958809,"-","-",0]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",882405.83327223803,30251.493762522347,3403.5000000000018,"-",8.89]
["Direct Pumping","Colusa County WD Relift PP","-",38257.458734849097,1311.5793557205345,96.220000000000056,"-",13.63]
["Direct Pumping","Contra Costa PP (Contra Costa WD)","-",5524310.6969774608,189389.78448512818,100196.23999999995,"-",1.89]
["Direct Pumping","Kanawha WD","-",2030.9602069455466,69.627350268647959,9.6599999999999966,"-",7.21]
["Direct Pumping","Pleasant Valley PP (City of Coalinga)","-",214646.77166816572,7358.7290897495095,5405.34,"-",1.36]
["Direct Pumping","Pleasant Valley WD Canalside Relift PP","-",39926.8866050219,1368.8123033022994,5405.34,"-",0.25]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",429721.51274010004,14732.130242239862,"-","-",0]
["Direct Pumping","San Benito County WD, Pacheco PP","-",265976.79726804898,9118.4748787213175,"-","-",0]
["Total","San Benito County WD","-",695698.31000814901,23850.60512096118,3710.599999999999,"-",6.43]
["Direct Pumping","San Luis WD Canalside Relift PP","-",85437.353435033307,2929.046326611181,710.7,"-",4.12]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",1557831.687735518,53407.098874029354,"-","-",0]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",8947424.3380522802,306744.29083213198,"-","-",0]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",5412499.5153633691,185556.56496680775,"-","-",0]
["Total","Santa Clara WD","-",15917755.541151168,545707.95467296906,75508.919999999984,"-",7.23]
["Direct Pumping","Shasta Pumping Plant (City of Shasta Lake)","-",598053.86964352999,20503.063584793737,1873.6000000000004,"-",10.94]
["Direct Pumping","State Delta PP (Cross Valley Canal)  ","-",17539.656543939338,601.3115400292977,173.18,"-",3.47]
["Direct Pumping","Westlands WD Relifts","-",913610.02857523935,31321.266291192882,4052.2599999999989,"-",7.73]
["Total","Direct Pumping","-",24929673.36682174,854663.2738832488,"-",0,0]
["Subtotal","-","-",126845290.16000003,4348633.4285107953,"-","-",0]
["Other Costs","Deferred Interest Capitalized ","-",21277763,729464.93597843277,"-","-",0]
["Other Costs","Programmatic EIS Capitalized  ","-",1624377.1273268,55688.474262556389,"-","-",0]
["Other Costs","All others","-",7837166.455000001,268681.35181075643,"-","-",0]
["Total","Other Costs","-",30739306.582326803,1053834.7620517456,355446.88182857132,"-",2.96]
["Grand Total","-","-",157584596.74232683,5402468.1905625407,"-","-",0]

{"sheet":"Footnote","index":1,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["2025 Cost of Service Additional Service Water Rates Sch TR-1.Z27.xlsm"]
["01/11/2025"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF WATER RATES FOR ADDITIONAL CVP SERVICES WHEN TRANSFERRING"]
["CVP WATER TO CVP M&I WATER CONTRACTORS"]
["2025 SPECIAL WATER RATES"]
[]
["Footnotes:"]
["1/"]
["Refer to M&I Water Rates, Schedule A-4."]
["Total Conveyance Pumping for Jones Pumping Plant less Delta Mendota Exchange."]
[]
["2/"]
["Suballocation of Jones Pumping Plant costs:"]
[]
["Facility/Contractor Ref","Historical &\nProjected\nDeliveries\n(1981-2030)\n(Sch A-7)","Ratio","M&I\nConstruction\nCosts\nat 9/30/2021","Project Use Energy\nBOR","Project Use Energy\nDOE","Project Use Energy\nTotal"]
["Jones Pumping Plant: Delta-Mendota Exchange",2514767.9085849989,0.33292997699999999,1528846.1426592106,1366825.3309636072,1350426.2096086103,2717251.5405722177]
["Jones Pumping Plant: All Other Contractors",5038675.9999999991,0.66707002299999996,3063249.0373407886,2738618.5322773624,2705760.6852368792,5444379.2175142411]
["Total  a/",7553443.908584998,1,4592095.18,4105443.8632409694,4056186.8948454894,8161630.7580864588]
[]
["a/",null,null,null,null,""]
["Jones Pumping Plant - Conveyance Pumping: "]
[]
["Total Construction (M&I Sch A-5)","less:  BOR PUE (M&I Sch A-5)","less:  DOE PUE (M&I Sch A-5)","Construction Allocation"]
[12753725.938086459,4105443.8632409698,4056186.8948454899,4592095.18]
[]
["3/"]
["Cross Valley Canal contractors are charged for PUE construction component only.  Therefore their deliveries are not included in determining the \"Construction only\" rate."]
[]
["4/"]
["Includes Friant Dam and Friant-Kern Canal."]
[]
["5/"]
["Folsom SOD Historical & Projected Deliveries are based on a new 50-year repayment period beginning in 2024."]