{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["PRICING SCHEDULE"],"not_rendered":{"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"PRICING SCHEDULE","index":0,"n_rows":38,"n_cols":8,"rows_kept":38,"merged":[[11,4,11,6],[34,1,37,1],[34,2,34,3],[34,4,34,5],[35,2,35,3],[36,2,36,3],[36,4,36,5],[37,2,37,3],[37,4,37,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No","RFB 2767-2023"]
["RFx Title","PROCUREMENT OF THE ASSESSMENT AND DESIGN OF A NATIONAL DIGITIZED INTEGRATED WATER AND SANITATION MONITORING SYSTEM FOR THE DEPARTMENT OF WATER AND SANITATION (DWS), FOR A PERIOD OF 12 MONTHS."]
["Bidder Name "]
[]
["1. INSTRUCTION FOR COMPLETING THE PRICING SCHEDULE"]
["(a)  Bidder must complete/enter YELLOW cells only"]
["(b)  Unit and Line prices must be VAT EXCLUSIVE and in South African Rand (ZAR) currency."]
["(c) The price must include all cost to deliver the goods or render the service, including all applicable taxes, duty fees, logistics/delivery, storage, labour, overtime and subsistance and travel"]
[]
[{"$nulls":4},"YEAR 1",null,null,"TOTAL"]
["Item No","Goods/Service description","Unit of measure","Forex %","Qty ","Unit Price \n(Excl VAT)","Line Price Y1","Line Price Term \n(Excl VAT)"]
[1,"Comprehensive Assessment Report",{"$nulls":4},{"$f":"SUM(G15)","v":0},{"$f":"SUM(H15)","v":0}]
[1.1,"Assess existing systems and technology applications as well as gaps across the entire water and sanitation information value chain from observation and measurement, to data and information dissemination.","Assessment Report ",{"v":0,"d":"0%"},1,null,{"$f":"E15*F15","v":0},{"$f":"G15","v":0}]
[2,"A User Requirements Specification/ Report ",{"$nulls":4},{"$f":"SUM(G17:G18)","v":0},{"$f":"SUM(H17:H18)","v":0}]
["2.1","Assess water & sanitation monitoring and information management practitioners’ tools and systems needs","User Tools and System Aessement Report",{"v":0,"d":"0%"},1,null,{"$f":"E17*F17","v":0},{"$f":"G17","v":0}]
["2.2","Evaluate, validate and develop user requirements and user journeys","User requirement specification report",{"v":0,"d":"0%"},1,null,0,{"$f":"G18","v":0}]
[3,"Market Study and Due Diligence Report ",{"$nulls":4},{"$f":"SUM(G20)","v":0},{"$f":"SUM(H20)","v":0}]
["3.1","Conduct market study and due diligence on national water monitoring and information management digital solutions and/or platforms, including a shortlist of solution in order of affordability, cost analysis, scalability, best practice and international footprint, ease of integration and security.","Market Study and Due Dilligence report ",{"v":0,"d":"0%"},1,null,{"$f":"E20*F20","v":0},{"$f":"G20","v":0}]
[4,"Business Process Optimization Report ",{"$nulls":4},{"$f":"SUM(G22)","v":0},{"$f":"SUM(H22)","v":0}]
["4.1","Build, document and optimize the business processes for water resource monitoring and information management","Bussiness Process report",{"v":0,"d":"0%"},1,null,{"$f":"E22*F22","v":0},{"$f":"G22","v":0}]
[5,"Governance Framework Report ",{"$nulls":4},{"$f":"SUM(G24)","v":0},{"$f":"SUM(H24)","v":0}]
[5.1,"Develop a governance framework for the use and management of the system to ensure optimal use and information sharing","Governance Framework developed",{"v":0,"d":"0%"},1,null,{"$f":"E24*F24","v":0},{"$f":"G24","v":0}]
[6,"Detailed Design and Solution Architecture of a National Digitised Integrated  Water and Sanitation Monitoring System",{"$nulls":4},{"$f":"SUM(G26)","v":0},{"$f":"SUM(H26)","v":0}]
[6.1,"Design a comprehensive national integrated digitized water and sanitation monitoring system","Detailed design",{"v":0,"d":"0%"},1,null,{"$f":"E26*F26","v":0},{"$f":"G26","v":0}]
[7,"Detailed description of the build/assemble/acquire process of the National Digitised Integrated Water & Sanitation Monitoring System ",{"$nulls":4},{"$f":"SUM(G28:G29)","v":0},{"$f":"SUM(H28:H29)","v":0}]
[7.1,"Describe in detail a process to successfully build/assemble/acquire the system","Detailed process Report",{"v":0,"d":"0%"},1,null,{"$f":"E28*F28","v":0},{"$f":"G28","v":0}]
[7.2,"Develop a detailed proposed implementation plan for the designed National Digitized Integrated Water and Sanitation Monitoring System.","Proposed Implementation Plan ",{"v":0,"d":"0%"},1,null,0,{"$f":"G29","v":0}]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"G14+G16+G19+G21+G23+G25+G27","v":0},{"$f":"H14+H16+H19+H21+H23+H25+H27","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G30*0.15","v":0},{"$f":"H30*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G30+G31","v":0},{"$f":"H30+H31","v":0}]
[]
[]
[null,"I, the bidder, confirm that the price(s) and rate(s) quoted cover all the goods and/or works specified in the bidding documents; that the price(s) or rate(s) cover all my obligations and I accept that any mistakes regarding price(s), rate(s) or calculations will be at my own risk.\n[Note: First convert to PDF, then add signature]"]
[null,null,"Name",null,"Capacity"]
[]
[null,null,"Signature (above)",null,"Date"]