{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","PM1.1","PM2.1","Drop-down list"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":3,"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":"Instructions","index":0,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[32,6,32,7],[2,3,2,9],[3,3,3,9],[11,4,11,9],[13,4,13,9],[15,6,15,8],[11,2,11,3],[13,2,13,3],[15,2,15,5],[32,2,32,5]]}
[]
[]
[null,null,null,"Water Price Determination Information Requirements \nMinor and Intermediate Retailers"]
[null,null,null,"Pricing schedule and Pricing Policy Statement"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Pricing year:",null,"2023-24"]
[]
[null,null,"Retailer Name:",null,"Adelaide Plains Council"]
[]
[null,null,"Instructions for Completion"]
[null,null,1,"Pricing  Schedule (PM1.1)"]
[null,null,null,"a. Complete each applicable cell highlighted grey. "]
[null,null,null,"b. If any service is not applicable to the licensee, that section can be ignored."]
[null,null,null,"c. Please do not unhide or update any hidden cell or sheet."]
[null,null,null,"d. Please provide the information relating to the pre-filled information first."]
[null,null,null,"e. Please do not delete or update any of the pre-filled text."]
[null,null,null,"f. Use the 'Add Row' to add extra rows for providing information (if applicable). Alternatively, insert rows using Excel functionality."]
[null,null,null,"g. Use the 'Delete Last row' button to delete the last added row of data in that section. Alternatively, delete rows using Excel functionality."]
[null,null,null,"h. For  'Sewerage & Trade Waste Retail Services', please provide locations (if applicable) with the Units of Measurement. For example per property - Adelaide."]
[null,null,2,"Pricing Policy Statement (PM2.1) - complete all four sections highlighted blue."]
[null,null,3,"A licensee must send a completed template in an excel format to reporting@escosa.sa.gov.au by 30 November."]
[null,null,4,"For assistance please email reporting@escosa.sa.gov.au or phone 8463 4444 and ask to speak with someone regarding reporting."]
[]
[null,null,null,"In addition to the information requirements set out in this template, licensees must also provide information required by "]
[null,null,null,"https://www.escosa.sa.gov.au/industry/water/retail-pricing/minor-and-intermediate-retailers-price-determination"]
[]
[null,null,"Sheets to complete"]
[null,null,"Price Monitoring Reporting:"]
[null,null,1,"PM1.1","PM1.1 - Pricing Schedule"]
[null,null,2,"PM2.1","PM2.1 - Pricing Policy Statement"]

{"sheet":"PM1.1","index":1,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[39,0,44,0],[22,0,23,0],[22,2,23,2],[22,5,23,5],[30,0,31,0],[30,2,31,2],[30,5,31,5],[22,1,23,1],[30,1,31,1],[3,0,4,0],[3,2,4,2],[3,5,4,5],[11,0,12,0],[11,2,12,2],[11,5,12,5],[3,1,4,1],[11,1,12,1]]}
[]
["PROFORMA PM1.1 – Pricing Schedule",null,"Please read Instructions before completing (click here)."]
[]
["Drinking Water Retail Services","Indicator_Code (Internal Use)","Unit of measurement",{"$f":"+Instructions!E12","v":"2023-24"},"Previous Year","Percentage Price Change"]
[null,null,null,"$/unit","$/unit"]
["Annual supply charges","PM1.1-101","per property",null,null,{"$f":"IF(D6=\"\",\"\",(D6-E6)/E6)","v":""}]
["Usage charges","PM1.1-102","kilolitre",null,null,{"$f":"IF(D7=\"\",\"\",(D7-E7)/E7)","v":""}]
["Please add any other applicable information by adding additional rows below"]
[]
[]
[]
["Sewerage & Trade Waste Retail Services","Indicator_Code (Internal Use)","Unit of measurement/Location",{"$f":"$D$4","v":"2023-24"},{"$f":"$E$4","v":"Previous Year"},"Percentage Price Change"]
[null,null,null,"$/unit","$/unit"]
["Annual Service charge - Occupied - Malalla CWMS","PM1.1-201","per connection",740,692,{"$f":"IF(D14=\"\",\"\",(D14-E14)/E14)","v":6.9364161849710976E-2}]
["Annual Service charge - Vacant - Malalla CWMS","PM1.1-202","per connection",740,692,{"$f":"IF(D15=\"\",\"\",(D15-E15)/E15)","v":6.9364161849710976E-2}]
["Connection charge - Occupied - Malalla CWMS","PM1.1-203","per connection",4500,4500,0]
["Connection charge - Vacant - Malalla CWMS","PM1.1-204","per connection",4500,4500,0]
["Annual Service charge - Occupied - Middle Beach CWMS",null,"per connection",488,456,7.0175438596491224E-2]
["Annual Service charge - Vacant - Middle Beach CWMS",null,"per connection",488,456,7.0175438596491224E-2]
["Connection charge - Occupied - Middle Beach CWMS",null,"per connection",4500,4500,0]
["Connection charge - Vacant - Middle Beach CWMS",null,"per connection",4500,4500,0]
[]
["Non-Drinking Water Retail Services","Indicator_Code (Internal Use)","Unit of measurement",{"$f":"$D$4","v":"2023-24"},{"$f":"$E$4","v":"Previous Year"},"Percentage Price Change"]
[null,null,null,"$/unit","$/unit"]
["Supply charges","PM1.1-301","p.a",null,null,{"$f":"IF(D25=\"\",\"\",(D25-E25)/E25)","v":""}]
["Usage charges","PM1.1-302","kilolitre",null,null,{"$f":"IF(D26=\"\",\"\",(D26-E26)/E26)","v":""}]
["Please add any other applicable information by adding additional rows below",null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[]
["Other Ancillary & Related Retail Services","Indicator_Code (Internal Use)","Unit of measurement",{"$f":"$D$4","v":"2023-24"},{"$f":"$E$4","v":"Previous Year"},"Percentage Price Change"]
[null,null,null,"$/unit","$/unit"]
["Item 1","PM1.1-401",null,null,null,{"$f":"IF(D33=\"\",\"\",(D33-E33)/E33)","v":""}]
["Item 2",null,null,null,null,{"$f":"IF(D34=\"\",\"\",(D34-E34)/E34)","v":""}]
["Please add any other applicable information by adding additional rows below"]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[]
["Application of Prices"]
[" {Add explanatory narrative on application of prices}"]
[]
[]
[]
[]
[]
[]
["Link to Current Prices on the Licensee's website"]
["[link to website]"]
[]
["Instructions"]

{"sheet":"PM2.1","index":2,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,0,10,0],[4,1,10,1],[11,0,15,0],[11,1,15,1],[16,0,18,0],[16,1,18,1]]}
[]
["PROFORMA PM2.1 – Pricing Policy Statement","Please read Instructions before completing (click here)."]
[]
["Question","Response"]
["Please provide a description of the regulated Retail Services currently offered, as specified on the Pricing Schedule.","Small Council managed sewer scheme (Mallala and Middle Beach)"]
[]
[]
[]
[]
[]
[]
["Please provide information on how the current pricing policies have been developed.","Council is currently not charging CWMS customers on full costs recovery bases as it would put a significant financial burden on CWMS customers. Elected Members and the community is well aware of the current under-pricing and Council is planning to increase CWMS service charge to achieve full cost recovery overtime."]
[]
[]
[]
[]
["Please describe the rationale for the price movements between the 2022-23 and 2023-24","Price increase due to CPI (also whole of life costing revised and new contractor contract increases)"]
[]
[]
["Please provide a link to the Pricing Policy Statement on the licensee's website","https://www.apc.sa.gov.au/__data/assets/pdf_file/0032/357773/Community-Wastewater-Management-System-Policy.pdf"]
[]
["Instructions"]

{"sheet":"Drop-down list","index":3,"n_rows":74,"n_cols":9,"rows_kept":74,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Retailers Water"]
[null,"Retailer Name","Code","Industry",null,null,null,null,"Reporting year"]
[null,"Adelaide Hills Berry Farm","ABD","Water",null,null,null,null,"2021-22"]
[null,"Adelaide Hills Council","AHC","Water",null,null,null,null,"2022-23"]
[null,"Adelaide Plains Council","APC","Water",null,null,null,null,"2023-24"]
[null,"Alano Utilities Pty Ltd","ALA","Water",null,null,null,null,"2024-25"]
[null,"Alexandrina Council","ALE","Water",null,null,null,null,"2025-26"]
[null,"Berri Barmera Council","BER","Water",null,null,null,null,"2026-27"]
[null,"BHP Billiton Olympic Dam Corporation Pty Ltd (Water)","BHP","Water",null,null,null,null,"2027-28"]
[null,"Cape Jaffa Anchorage Essential Services Pty Ltd","CJA","Water",null,null,null,null,"2028-29"]
[null,"City of Onkaparinga - sewerage ","ONS","Water",null,null,null,null,"2029-30"]
[null,"City of Onkaparinga - water","ONW","Water",null,null,null,null,"2023-31"]
[null,"City of Playford","PLA","Water"]
[null,"City of Port Adelaide Enfield","PAE","Water"]
[null,"City of Port Lincoln","PLI","Water"]
[null,"City of Salisbury","SAL","Water"]
[null,"City of Tea Tree Gully","TTG","Water"]
[null,"Clare & Gilbert Valleys Council ","CGV","Water"]
[null,"Coorong District Council ","COR","Water"]
[null,"Copper Coast Council","COP","Water"]
[null,"CPE Tonsley Pty Ltd","CPW","Water"]
[null,"District Council of Barunga West","BAW","Water"]
[null,"District Council of Ceduna","CED","Water"]
[null,"District Council of Cleve - Arno Bay","CLA","Water"]
[null,"District Council of Cleve - Cleve","CLC","Water"]
[null,"District Council of Coober Pedy (Water)","COO","Water"]
[null,"District Council of Elliston","ELL","Water"]
[null,"District Council of Franklin Harbour","FRA","Water"]
[null,"District Council of Grant  ","GRA","Water"]
[null,"District Council of Karoonda East Murray","KEM","Water"]
[null,"District Council of Kimba ","KIM","Water"]
[null,"District Council of Lower Eyre Peninsula","LEP","Water"]
[null,"District Council of Loxton Waikerie ","LOX","Water"]
[null,"District Council of Mount Barker ","MBA","Water"]
[null,"District Council of Mount Remarkable ","MRE","Water"]
[null,"District Council of Orroroo Carrieton ","ORR","Water"]
[null,"District Council of Peterborough","PET","Water"]
[null,"District Council of Robe","ROB","Water"]
[null,"District Council of Streaky Bay ","STR","Water"]
[null,"District Council of Tumby Bay ","TUM","Water"]
[null,"ERA Water","ERA","Water"]
[null,"F.B. Pipeline Pty Ltd","FBP","Water"]
[null,"Fairmont Utilities Pty Ltd","FAI","Water"]
[null,"Kangaroo Island Council","KAN","Water"]
[null,"Kingston District Council ","KIN","Water"]
[null,"Light Regional Council ","LIT","Water"]
[null,"Lightsview ReWater Supply Co Pty Ltd","LRS","Water"]
[null,"Michell Infrastructure Pty Ltd","MII","Water"]
[null,"Mid Murray Council ","MMC","Water"]
[null,"Monarto Water Network Ltd","MON","Water"]
[null,"Municipal Council of Roxby Downs (Water)","ROX","Water"]
[null,"Naracoorte Lucindale Council ","NAR","Water"]
[null,"Northern Areas Council ","NAC","Water"]
[null,"NWIC Pty Ltd","NWC","Water"]
[null,"Port Augusta City Council   ","PAU","Water"]
[null,"Port Pirie Regional Council ","PPI","Water"]
[null,"Regional Council of Goyder - Burra ","GOB","Water"]
[null,"Regional Council of Goyder - Eudunda ","GOE","Water"]
[null,"Renmark Paringa Council","REN","Water"]
[null,"Robusto Investments Pty Ltd","RIN","Water"]
[null,"Rural City of Murray Bridge ","MUB","Water"]
[null,"Southern Mallee District Council ","SMD","Water"]
[null,"Tatiara District Council ","TAT","Water"]
[null,"The Barossa Council","BAR","Water"]
[null,"The City of Charles Sturt ","CHA","Water"]
[null,"The Corporation of the City of Marion","MAR","Water"]
[null,"The Corporation of the City of Whyalla","WHY","Water"]
[null,"The Flinders Ranges Council - Hawker","FRH","Water"]
[null,"The Flinders Ranges Council - Quorn","FRQ","Water"]
[null,"Wakefield Regional Council ","WAK","Water"]
[null,"Wattle Range Council ","WAT","Water"]
[null,"Wudinna District Council","WUD","Water"]
[null,"Yorke Peninsula Council ","YOR","Water"]