{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Information","OUTPUT","Linked Input"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":6,"defined_names":2,"comments":1,"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":"Information","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Corning WD - 2023 M&I Water Rates Sch O-5.Z25.xlsm"]
["01/09/2023"]
[]
[]
[]
["1/26/2022","slf","removed construction rates since contractor converted to WIIN Act"]
[]
["10/26/2022","JH","Updated file names, title, headings, and date"]
[null,null,"Updated Linked Input & Output tabs. "]
[null,null,"Awaiting for 2023 FC (FA-1I) to be completed"]
["10/27/2022",null,"2023 FC (FA-1I) interest rate is the same as FY 2019, no update needed."]
[]
["01/09/2023","KJ ","Review"]

{"sheet":"OUTPUT","index":1,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"+Information!A1","v":"Corning WD - 2023 M&I Water Rates Sch O-5.Z25.xlsm"}]
[{"$f":"+Information!A2","v":"01/09/2023"}]
["CENTRAL VALLEY PROJECT"]
["CORNING WATER DISTRICT"]
["CORNING CANAL"]
["CONTRACT NO. 14-06-200-6575-P"]
["2023 M&I WATER RATES "]
["FOR TIERED PRICING PURPOSES"]
["Category","Component","Cost of Service\nRate per Acre-Foot\n<Sch S-2, A-8, A-11, A-2A>","Full Cost\nRate per Acre-Foot\n<Sch S-2, A-8, A-11, A-2A>"]
["Construction Costs per Acre-Foot","Storage",0,"TBD"]
["Construction Costs per Acre-Foot","Other Cost",0,"TBD"]
["Construction Costs per Acre-Foot","Conveyance",0,"TBD"]
["Construction Costs per Acre-Foot","Conveyance Pumping",0,"TBD"]
["Construction Costs per Acre-Foot","Direct Pumping",0,"TBD"]
["Total","Total Capital",{"$f":"SUM(C11:C15)","v":0},{"$f":"SUM(D11:D15)","v":0}]
["O&M Cost per Acre-Foot","Water Marketing ",{"$f":"[1]OUTPUT!$E$161","v":15.52},"TBD"]
["O&M Cost per Acre-Foot","Conveyance",{"$f":"[1]OUTPUT!$I$161","v":0},"TBD"]
["O&M Cost per Acre-Foot","Conveyance Pumping",{"$f":"[2]OUTPUT!$M$320","v":0},"TBD"]
["O&M Cost per Acre-Foot","Storage",{"$f":"[1]OUTPUT!$G$169","v":17.23},"TBD"]
["O&M Cost per Acre-Foot","Direct Pumping Offset",{"$f":"[3]Output!$V$47","v":8.8000000000000007},"TBD"]
["Total","Total O&M",{"$f":"SUM(C17:C21)","v":41.55},{"$f":"SUM(D17:D21)","v":0}]
["Grand Total","-",{"$f":"+C16+C22","v":41.55},{"$f":"+D16+D22","v":0}]

{"sheet":"Linked Input","index":2,"n_rows":65,"n_cols":19,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
[{"$f":"+OUTPUT!A2","v":"Corning WD - 2023 M&I Water Rates Sch O-5.Z25.xlsm"}]
[{"$f":"+OUTPUT!A3","v":"01/09/2023"}]
[]
[null,"Special Rates 2023 Sch S-1.Z25.XLSM"]
[]
[null,null,null,null,null,null,null,null,"Net Unpaid",null,"Unpaid Construction",null,"FY 2023",null,"Unpaid "]
[null,null,null,null,null,null,null,null,"Construction",null,"Annualized Costs",null,"Projected",null,"Construction Rate"]
[null,"Conveyance Pumping",null,null,null,null,null,null,"at 9/30/2021",null,"8 Remaining Yrs",null,"Deliveries",null,"Per Acre Foot"]
[null,null,"Corning Pumping Plant"]
[null,null,null,null,"Capital only",null,null,null,{"$f":"[4]OUTPUT!$M$29","v":145533.30114163971},null,{"$f":"+I10/8","v":18191.662642704963},null,{"$f":"[4]OUTPUT!$Q$29","v":5423.2857142857138},null,{"$f":"ROUND(+K10/M10,2)","v":3.35}]
[null,null,null,null,"PUE only",null,null,null,{"$f":"[4]OUTPUT!$M$30","v":17102.288987386972},null,{"$f":"+I11/8","v":2137.7861234233715},null,{"$f":"[4]OUTPUT!$Q$30","v":5423.2857142857138},null,{"$f":"ROUND(+K11/M11,2)","v":0.39}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I10:I11)","v":162635.59012902668},null,null,null,null,null,{"$f":"SUM(O10:O11)","v":3.74}]
[]
[null,"Direct Pumping"]
[null,null,"Corning WD Relift PP",null,null,null,null,null,{"$f":"[4]OUTPUT!$M$60","v":187415.80931607261},null,{"$f":"+I15/8","v":23426.976164509077},null,{"$f":"[4]OUTPUT!$Q$60","v":5132.1428571428569},null,{"$f":"ROUND(+K15/M15,2)","v":4.5599999999999996}]
[]
[null,"Special Rates 2023 Sch S-2.Z25.XLSM"]
[]
[null,null,null,null,null,null,null,null,"Net Unpaid",null,"Unpaid Construction",null,null,null,{"$f":"M6","v":"FY 2023"},null,"Unpaid Construction Rate"]
[null,null,null,null,null,null,null,null,"Construction",null,"Annulized Cost",null,"Annual Interest @",null,"Projected ",null,"Construction"]
[null,null,null,null,null,null,null,null,{"$f":"I8","v":"at 9/30/2021"},null,{"$f":"K8","v":"8 Remaining Yrs"},null,{"$f":"+K36","v":8.0119999999999997E-2},null,"Deliveries",null,"only","Interest","Total"]
[]
[null,null,"Storage",null,null,null,null,null,{"$f":"[5]OUTPUT!$M$19","v":2158285.299800545},null,{"$f":"+I23/8","v":269785.66247506812},null,{"$f":"+I23*M$21","v":172921.81822001966},null,{"$f":"[5]OUTPUT!$S$19","v":245181.57142857148},null,{"$f":"ROUND(+K23/O23,2)","v":1.1000000000000001},{"$f":"ROUND(+M23/O23,2)","v":0.71},{"$f":"+Q23+R23","v":1.81}]
[]
[null,null,"Conveyance",null,null,null,null,null,{"$f":"[5]OUTPUT!$M$26","v":1417022.4699999951},null,{"$f":"+I25/8","v":177127.80874999939},null,{"$f":"+I25*M$21","v":113531.8402963996},null,{"$f":"[5]OUTPUT!$S$26","v":172696.71428571426},null,{"$f":"ROUND(+K25/O25,2)","v":1.03},{"$f":"ROUND(+M25/O25,2)","v":0.66},{"$f":"+Q25+R25","v":1.69}]
[]
[null,null,"Other Costs",null,null,null,null,null,{"$f":"[5]OUTPUT!$M$89","v":1629023.4636188005},null,{"$f":"+I27/8","v":203627.93295235006},null,{"$f":"+I27*M$21","v":130517.35990513829},null,{"$f":"[5]OUTPUT!$S$89","v":331768.71428571432},null,{"$f":"ROUND(+K27/O27,2)","v":0.61},{"$f":"ROUND(+M27/O27,2)","v":0.39},{"$f":"+Q27+R27","v":1}]
[]
[]
[null,"M&I 2023 Sch A-13"]
[]
[null,null,"M&I COMPOSITE INTEREST RATE FOR CAPITAL",null,null,null,null,null,null,null,{"$f":"[6]Manual_Input!K7","v":2.3754608109186889E-2}]
[]
[null,"IRR 2023 FC (FA-1I)"]
[]
[null,null,"FULL COST COMPOSITE INTEREST RATE FOR CAPITAL",null,null,null,null,null,null,null,8.0119999999999997E-2]
[]
[null,"Full Cost Rates:",null,null,null,null,null,null,null,null,null,"Cost of Service Rates:"]
[]
[null,"Conveyance Pumping Rate Calculation",null,null,null,null,null,null,null,null,null,"Conveyance Pumping Rate Calculation"]
[]
[null,null,"Irrigation Capital Rate",null,null,null,{"$f":"+O12","v":3.74},null,null,null,null,null,"Irrigation Capital Rate",null,{"$f":"+O12","v":3.74}]
[]
[null,null,"M&I interest",null,null,null,null,null,null,null,null,null,"M&I Interest"]
[null,null,null,null,null,{"$f":"+I12","v":162635.59012902668},null,"Net Unpaid Construction",null,null,null,null,null,{"$f":"+I12","v":162635.59012902668},null,"Net Unpaid Construction"]
[null,null,null,null,null,{"$f":"+K36","v":8.0119999999999997E-2},null,"Times M&I Composite Interest Rate for Capital",null,null,null,null,null,{"$f":"+K32","v":2.3754608109186889E-2},null,"Times M&I Composite Interest Rate for Capital"]
[null,null,null,null,null,{"$f":"+F45*F46","v":13030.363481137618},null,null,null,null,null,null,null,{"$f":"+N45*N46","v":3863.3447081213722}]
[null,null,null,null,null,{"$f":"+M11","v":5423.2857142857138},null,"Divide by 2023 projected deliveries",null,null,null,null,null,{"$f":"+M11","v":5423.2857142857138},null,{"$f":"H48","v":"Divide by 2023 projected deliveries"}]
[null,null,null,null,null,null,{"$f":"ROUND(+F47/F48,2)","v":2.4},null,null,null,null,null,null,null,{"$f":"ROUND(+N47/N48,2)","v":0.71}]
[]
[null,null,"Total",null,null,null,{"$f":"+G42+G49","v":6.1400000000000006},null,null,null,null,null,"Total",null,{"$f":"+O42+O49","v":4.45}]
[]
[]
[null,"Direct Pumping Rate Calculation",null,null,null,null,null,null,null,null,null,"Direct Pumping Rate Calculation"]
[]
[null,null,"Irrigation Construction Rate",null,null,null,{"$f":"+O15","v":4.5599999999999996},null,null,null,null,null,"Irrigation Capital Rate",null,{"$f":"+O15","v":4.5599999999999996}]
[]
[null,null,"M&I interest",null,null,null,null,null,null,null,null,null,"M&I interest"]
[null,null,null,null,null,{"$f":"+I15","v":187415.80931607261},null,"Net Unpaid Construction",null,null,null,null,null,{"$f":"+I15","v":187415.80931607261},null,"Net Unpaid Construction"]
[null,null,null,null,null,{"$f":"+F46","v":8.0119999999999997E-2},null,"Times M&I Composite Interest Rate for Capital",null,null,null,null,null,{"$f":"+N46","v":2.3754608109186889E-2},null,"Times M&I Composite Interest Rate for Capital"]
[null,null,null,null,null,{"$f":"+F59*F60","v":15015.754642403737},null,null,null,null,null,null,null,{"$f":"+N59*N60","v":4451.9891037694024}]
[null,null,null,null,null,{"$f":"+M15","v":5132.1428571428569},null,{"$f":"H48","v":"Divide by 2023 projected deliveries"},null,null,null,null,null,{"$f":"+M15","v":5132.1428571428569},null,{"$f":"H48","v":"Divide by 2023 projected deliveries"}]
[null,null,null,null,null,null,{"$f":"ROUND(+F61/F62,2)","v":2.93},null,null,null,null,null,null,null,{"$f":"ROUND(+N61/N62,2)","v":0.87}]
[]
[null,null,"Total",null,null,null,{"$f":"+G56+G63","v":7.49},null,null,null,null,null,"Total",null,{"$f":"+O56+O63","v":5.43}]