{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OUTPUT","Footnotes"],"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":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
["2025 Full Cost Additional Service Water Rates Sch TR-2b.Z27.xlsm"]
["01/20/2025"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I FULL COST ADDITIONAL SERVICE WATER RATES"]
["AS OF SEPTEMBER 30, 2023"]
["2025 SPECIAL WATER RATES"]
[]
["Category","A) Component / Facility\n<Ref>","Related Footnotes","B) Total M&I Construction at 9/30/2023\n<Sch A-4>","C) Ratio of Total\n<B/$150,840,233.69>\n                                                                            Folsom SOD <B/$6,744,363.05>","D) Allocation of Construction Repayment at 9/30/2023  1/\n<C*$140,255,138.20>\n                                                                            Folsom SOD <C/$0.00>","E) Unpaid M&I Construction: Net Unpaid Construction at 9/30/2023\n(B-D)","F) Unpaid M&I Construction: Annualized Costs Remaining Years\n(E/6)\nFolsom SOD                         (E/49)","G) Unpaid M&I Construction: Annual Interest @\n(E*0.08012) ","H) FY 2025 Projected Deliveries\n<Sch S-6>","I) Unpaid M&I Construction Cost Per Acre Foot: Construction Only\n(F/H)","J) Unpaid M&I Construction Cost Per Acre Foot: Interest\n(G/H)","K) Unpaid M&I Construction Cost Per Acre Foot: Total\n(I+J)"]
["Storage","San Felipe Unit","-",9842239.2899999991,6.5249430135964251E-2,9151567.8410924952,690671.44890750386,115111.90815125064,55336.596486469207,97963.71428571429,1.18,0.56000000000000005,1.74]
["Storage","All Other Contractors","-",41163133.285328753,0.27289226672301758,38274542.582536489,2888590.7027922645,481431.78379871073,231433.88710771623,245858.42857142849,1.96,0.94,2.9]
["Folsom SOD","San Felipe Unit","7/",1896015.8100000003,0.28112600047531544,0,1896015.8100000003,38694.200204081637,151908.7866972,97963.71428571429,0.39,1.55,1.94]
["Folsom SOD","All Other Contractors","7/",4848347.24,0.71887399952468445,0,4848347.24,98945.862040816326,388449.5808688,245858.42857142849,0.4,1.58,1.98]
["Total","Storage","-",57749735.625328757,1.3381416968589817,47426110.423628986,10323625.201699769,734183.7541948593,827128.85116018541,"-",0,0,0]
["Conveyance","Contra Costa Canal System","2/",0,"-",0,0,0,0,"-",0,0,0]
["Conveyance","All Other Contractors","-",26941175.07,0.17860735435449335,25050599.168256443,1890575.9017435573,315095.98362392624,151472.94124769382,187030.42857142855,1.68,0.81,2.4900000000000002]
["Total","Conveyance","-",26941175.07,0.17860735435449335,25050599.168256443,1890575.9017435573,315095.98362392624,151472.94124769382,"-",0,0,0]
["Conveyance Pumping","Dos Amigos Pumping Plant, Construction only","3/",287465,1.9057581187944238E-3,267292.36832440947,20172.631675590528,3362.105279265088,1616.2312498483132,12093.142857142855,0.28000000000000003,0.13,0.41000000000000003]
["Conveyance Pumping","Dos Amigos Pumping Plant, PUE only","-",607830.8669254391,4.0296335536396033E-3,565176.81095500174,42654.055970437359,7109.0093284062268,3417.4429643514409,12371.142857142855,0.56999999999999995,0.28000000000000003,0.85]
["Conveyance Pumping","Dos Amigos Pumping Plant, Unpaid M&I Construction Per Acre Foot Total","-",0,"-",0,0,0,0,"-",0.85,0.41000000000000003,1.26]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, Construction only  ","-",1664792.9699999997,1.1036796544585883E-2,1547967.4246295285,116825.5453704712,19470.924228411866,9360.0626950821515,110534.85714285714,0.18,0.08,0.26]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, PUE only  ","-",1933709.842837644,1.2819589280018539E-2,1798013.2661169027,135696.57672074134,22616.096120123559,10872.009726865796,110534.85714285714,0.2,0.1,0.30000000000000004]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, Unpaid M&I Construction Per Acre Foot Total","-",0,"-",0,0,0,0,"-",0.38,0.18,0.56000000000000005]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, Construction only","4/, 5/",1528846.1426592106,1.0135532843164657E-2,1421560.5596334103,107285.5830258003,17880.93050430005,8595.72091202712,48778.71428571429,0.37,0.18,0.55000000000000004]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, PUE only","4/, 5/",2717251.5405722177,1.8014103227356928E-2,2526570.537674841,190681.00289737666,31780.167149562778,15277.361952137817,48778.71428571429,0.65,0.31,0.96]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, Unpaid M&I Construction Per Acre Foot Total","-",0,"-",0,0,0,0,"-",1.02,0.49,1.51]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, Construction only Construction only  4/  6/","4/, 6/",3040430.5173407886,2.0156628261014515E-2,2827070.6823642142,213359.83497657441,35559.972496095732,17094.389978323139,118936.14285714286,0.3,0.14000000000000001,0.44]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, PUE only","4/, 6/",5444379.2175142411,3.609368060659001E-2,5062324.1615695013,382055.05594473984,63675.84265745664,30610.251082292554,118936.14285714286,0.54,0.26,0.8]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, Unpaid M&I Construction Per Acre Foot Total","-",0,"-",0,0,0,0,"-",0.84000000000000008,0.4,1.24]
["Total","Conveyance Pumping","-",17224706.09784954,0.11419172243516457,16015975.811267808,1208730.2865817316,201455.04776362196,96843.470560928341,"-",0,0,0]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",882405.83327223803,5.8499367951928977E-3,820483.69366222143,61922.139610016602,10320.356601669433,4961.2018255545299,3487.1428571428573,2.96,1.42,4.38]
["Direct Pumping","Colusa County WD Relift PP","-",38257.458734849097,2.5362900731699966E-4,35572.771472392051,2684.687262457046,447.44787707617434,215.0971434680585,116.28571428571429,3.85,1.85,5.7]
["Direct Pumping","Contra Costa PP (Contra Costa WD)","-",5524310.6969774608,3.6623588824753195E-2,5136646.5119404951,387664.18503696565,64610.697506160941,31059.654505161685,75905.428571428565,0.85,0.41,1.26]
["Direct Pumping","Kanawha WD","-",2030.9602069455466,1.3464313580209342E-5,1888.4391619400897,142.52104500545693,23.753507500909489,11.418786125837208,28.857142857142858,0.82,0.4,1.22]
["Direct Pumping","Pleasant Valley PP (City of Coalinga)","-",33709.166605021899,2.2347596380538272E-4,31343.65218756508,2365.5144174568195,394.25240290946994,189.52501512664037,5430,7.0000000000000007E-2,0.03,0.1]
["Direct Pumping","Canalside Relift PP (City of Coalinga)","-",220864.49166816572,1.4642279865375268E-3,205365.49860592006,15498.99306224566,2583.1655103742764,1241.7793241471222,5430,0.48,0.23,0.71]
["Direct Pumping","San Benito County WD, Pacheco PP","-",265976.79726804898,1.7633014134051895E-3,247312.0834227406,18664.713845308375,3110.7856408847292,1495.4168732861069,"-",0,0,0]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",429721.51274010004,2.8488520749484878E-3,399566.14147895994,30155.371261140099,5025.8952101900168,2416.0483454425448,"-",0,0,0]
["Total","San Benito County WD","-",695698.31000814901,4.6121534883536777E-3,646878.22490170051,48820.085106448474,8136.680851074746,3911.465218728652,6512.5714285714284,1.25,0.6,1.85]
["Direct Pumping","San Luis WD Canalside Relift PP","-",85437.353435033307,5.6640958014757747E-4,79441.853940548128,5995.4994944851787,999.24991574752983,480.35941949815248,497,2.0099999999999998,0.97,2.9799999999999995]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",1557831.687735518,1.0327693411779462E-2,1448512.0667407806,109319.62099473737,18219.936832456227,8758.6880340983571,"-",0,0,0]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",5412499.5153633691,3.5882333134032399E-2,5032681.5925980313,379817.92276533786,63302.987127556313,30431.011971958869,"-",0,0,0]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",8947424.3380522802,5.9317226704266451E-2,8319545.8289581528,627878.50909412745,104646.41818235458,50305.626148621486,"-",0,0,0]
["Total","Santa Clara WD","-",15917755.541151168,0.10552725325007831,14800739.488296963,1117016.0528542027,186169.34214236712,89495.326154678711,91451.142857142855,2.04,0.98,3.02]
["Direct Pumping","Shasta Pumping Plant (City of Shasta Lake)","-",598053.86964352999,3.9648166474164828E-3,556085.90681507927,41967.96282845072,6994.6604714084533,3362.4731818154714,1120.8571428571429,6.24,3,9.24]
["Direct Pumping","State Delta PP (Cross Valley Canal)  ","-",17539.656543939338,1.1627969616989246E-4,16308.824855986892,1230.8316879524464,205.13861465874106,98.614234838749994,278,0.74,0.35,1.0899999999999999]
["Direct Pumping","Westlands WD Relifts","-",913610.02857523935,6.0568059741856152E-3,849498.15895085351,64111.869624385843,10685.311604064307,5136.6429943057938,2971.5714285714284,3.6,1.73,5.33]
["Total","Direct Pumping","-",24929673.36682174,0.16527204152753777,23180253.024791665,1749420.3420300728,291570.05700501212,140163.5578034494,"-",0,0,0]
["Subtotal","-","-",126845290.16000003,1.79621282,111672938.4279449,15172351.732055131,1542304.8425874196,1215608.8207722569,"-",0,0,0]
["Other Costs","Other Costs: Deferred Interest Capitalized ","-",21277763,0.1410615886700419,19784612.613415517,1493150.3865844831,248858.39776408052,119631.20897314878,"-",0,0,0]
["Other Costs","Other Costs: Programmatic EIS Capitalized  ","-",1624377.1273268,1.0768858464115676E-2,1510387.7321245412,113989.39520225883,18998.232533709805,9132.8303436049773,"-",0,0,0]
["Other Costs","Other Costs: All others","-",7837166.455000001,5.195673768966505E-2,7287199.4250067538,549967.02999324724,91661.171665541202,44063.358443058969,"-",0,0,0]
["Total","Other Costs","-",30739306.582326803,0.20378718482382263,28582199.770546813,2157106.8117799889,359517.80196333153,172827.39775981271,343822.14285714278,1.05,0.5,1.55]
["Grand Total","-","-",157584596.74232683,2.0000000048238227,140255138.19849172,17329458.543835118,1901822.644550751,1388436.2185320696,"-",0,0,0]

{"sheet":"Footnotes","index":1,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["2025 Full Cost Additional Service Water Rates Sch TR-2b.Z27.xlsm"]
["01/20/2025"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I FULL COST ADDITIONAL SERVICE WATER RATES"]
["AS OF SEPTEMBER 30, 2023"]
["2025 SPECIAL WATER RATES"]
[]
["FOOTNOTES:"]
["1/"]
["Refer to M&I Water Rates, Schedule A-2Ba.  Total Allocation of Construction Repayment is being reduced by the Assignment "]
[]
["Repayment as of 9/30/2023 (Column C of A-2Ba)","Construction Repayment per Assignment","Adjusted M&I Construction Repayment"]
[141034283.19849169,-779145,140255138.19849169]
[]
["2/"]
["Contra Costa WD's conveyance costs are recovered through a repayment contract."]
[]
["3/"]
["Cross Valley Canal contractors are charged for PUE constrcution component only.  Therefore their deliveries are not included in determining"]
[" the \"Construction only\" rate."]
[]
["4/"]
["Suballocation of Jones Pumping Plant costs:"]
[]
["Component/Facility","Historical & Projected Deliveries (1981-2030) (Sch A-7)","Ratio","M&I\nConstruction\nCosts\nat 9/30/2023","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",7553443.908584998,1,4592095.18,4105443.8632409694,4056186.8948454894,8161630.7580864588]
[]
["a/"]
["Jones Pumping Plant - Conveyance Pumping:"]
[]
["Component/Facility","M&I\nConstruction\nCosts\nat 9/30/2021"]
["Total Construction Cost (M&I Sch A-5)",12753725.938086459]
["less:  BOR PUE (M&I Sch A-5)",4105443.8632409698]
["less:  DOE PUE (M&I Sch A-5)",4056186.8948454899]
["Capital Allocation",4592095.18]
[]
["5/"]
["FY 2023 projected deliveries include Friant Dam and Friant-Kern Canal"]
[]
["6/"]
["FY 2023 projected deliveries for Jones PP do not include Delta Mendota Exchange contractors' deliveries."]
[]
["7/"]
["Folsom SOD has a repayment period of 50 years beginning in 2024."]