{"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":35,"n_cols":19,"rows_kept":35,"merged":[[11,2,11,3],[12,2,12,3],[12,5,14,5],[13,2,13,3],[14,2,14,3],[16,4,16,16],[29,1,29,5],[31,1,34,1],[31,2,31,3],[31,4,31,5],[32,2,32,3],[33,2,33,3],[33,4,33,5],[34,2,34,3],[34,4,34,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFB No","RFB 2705- 2022"]
["RFB Title","Supply Procurement and installation of 10 routers with maintenance and support for a period of 60 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"]
["(d)  Prices that are dependent on Rate of Exchange (ROE) must use ROE indicated below, then enter in Column \"Forex %\" the percentage of the price that is ROE dependent (0% means the price is not ROE dependent)"]
[null,"Foreign currency","South African Rand (ZAR) exchange rate "]
[null,"1 US Dollar",{"v":18.28,"d":"R18.28"},null,null,"Mark with an X, which ROE is applicable"]
[null,"1 Euro",{"v":19.52,"d":"R19.52"}]
[null,"1 Pound (UK)",{"v":21.99,"d":"R21.99"}]
[]
[]
["Item No","Product/Service description","Unit of measure","Forex %","Qty ","Unit Price \n(Excl VAT)","Line Price Y1","Unit Price \n(Excl VAT) Y2","Line Price Y2","Unit Price \n(Excl VAT) Y3","Line Price Y3","Unit Price \n(Excl VAT) Y4","Line Price Y4","Unit Price \n(Excl VAT) Y5","Line Price Y5","Total","Forex Price portion","BRAND / MODEL (if applicable)","Price clarification comment"]
[1,"PRODUCT"]
["1.1","Router Category 1",null,{"v":0,"d":"0%"},5,0,{"$f":"E20*F20","v":0},{"$nulls":8},{"$f":"G20","v":0},{"$f":"D20*G20","v":0}]
["1.2","Router Category 2",null,{"v":0,"d":"0%"},5,0,{"$f":"E21*F21","v":0},{"$nulls":8},{"$f":"G21","v":0},{"$f":"D21*G21","v":0}]
[2,"SERVICES"]
["2.1","Installation of Category 1 routers",null,{"v":0,"d":"0%"},5,0,{"$f":"E23*F23","v":0},{"$nulls":8},{"$f":"G23","v":0}]
["2.2","Installation of Category 2 routers",null,{"v":0,"d":"0%"},5,0,{"$f":"E24*F24","v":0},{"$nulls":8},{"$f":"G24","v":0}]
["2.3","Maintenance and Support Category 1 (NBD)",null,{"v":0,"d":"0%"},5,0,{"$f":"$E$25*$F$25","v":0},0,{"$f":"E25*H25","v":0},0,{"$f":"E25*J25","v":0},0,{"$f":"E25*L25","v":0},0,{"$f":"E25*N25","v":0},{"$f":"SUM(G25,I25,K25,M25,O25)","v":0},{"$f":"D25*G25","v":0}]
["2.4","Maintenance and Support Category 2 (NBD)",null,{"v":0,"d":"0%"},5,0,{"$f":"$E$26*$F$26","v":0},0,{"$f":"E26*H26","v":0},0,{"$f":"E26*J26","v":0},0,{"$f":"E26*L26","v":0},0,{"$f":"E26*N26","v":0},{"$f":"SUM(G26,I26,K26,M26,O26)","v":0},{"$f":"D26*G26","v":0}]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G26)","v":0},null,{"$f":"SUBTOTAL(9,I19:I26)","v":0},null,{"$f":"SUBTOTAL(9,K19:K26)","v":0},null,{"$f":"SUBTOTAL(9,M19:M26)","v":0},null,{"$f":"SUM(O25:O26)","v":0},{"$f":"SUM(P20:P26)","v":0},{"$f":"SUBTOTAL(9,Q19:Q26)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G27*0.15","v":0},null,{"$f":"I27*0.15","v":0},null,0,null,0,null,{"$f":"O27*0.15","v":0},{"$f":"P27*0.15","v":0},{"$f":"Q27*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G27+G28","v":0},null,{"$f":"I27+I28","v":0},null,0,null,0,null,0,{"$f":"P27+P28","v":0},{"$f":"Q27+Q28","v":0}]
[null,"NB: If maintenance and support cost differs per year, the bidder must populate the cost per year in the applicable years."]
[]
[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"]