{"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":44,"n_cols":23,"rows_kept":44,"merged":[[11,2,11,4],[12,2,12,4],[12,6,14,6],[13,2,13,4],[14,2,14,4],[16,5,16,7],[16,8,16,10],[16,11,16,13],[16,14,16,16],[16,17,16,19],[37,1,40,1],[37,2,37,3],[37,5,37,6],[38,2,38,3],[39,2,39,3],[39,5,39,6],[40,2,40,3],[40,5,40,6]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFB No","2853-2023"]
["RFx Title","PROCUREMENT OF ROUTERS AND NETWORK SWICHES FOR DHA FOR A PERIOD OF FIVE YEARS"]
["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":19.01,"d":"R19.01"},{"$nulls":3},"Mark with an X, which ROE is applicable"]
[null,"1 Euro",{"v":20.5,"d":"R20.50"}]
[null,"1 Pound (UK)",{"v":24.01,"d":"R24.01"}]
[]
[{"$nulls":5},"YEAR 1",null,null,"YEAR 2",null,null,"YEAR 3",null,null,"YEAR 4",null,null,"YEAR 5",null,null,"TOTAL"]
["Item No","Goods/Service description","Unit of measure","Forex %","Total Quantities over contract period","Qty ","Unit Price \n(Excl VAT)","Line Price Y1","Qty","Unit Price \n(Excl VAT)","Line Price Y2","Qty","Unit Price \n(Excl VAT)","Line Price Y3","Qty","Unit Price \n(Excl VAT)","Line Price Y4","Qty","Unit Price \n(Excl VAT)","Line Price Y5","Line Price Term \n(Excl VAT)","Forex Price portion","Price clarification comment"]
[1,"[Routers and Network Switches]"]
["1.1","Product - Router ","each",{"v":0,"d":"0%"},{"$f":"+F20+I20+L20+O20+R20","v":120},20,0,{"$f":"F20*G20","v":0},20,0,{"$f":"I20*J20","v":0},20,0,{"$f":"L20*M20","v":0},30,0,{"$f":"O20*P20","v":0},30,0,{"$f":"R20*S20","v":0},{"$f":"SUM(H20,K20,N20,Q20,T20)","v":0},{"$f":"D20*U20","v":0}]
["1.2","Product – Data Centre Core Switch ","each",{"v":0,"d":"0%"},{"$f":"+F21+I21+L21+O21+R21","v":4},0,null,null,2,0,{"$f":"I21*J21","v":0},2,0,{"$f":"L21*M21","v":0},0,null,null,0,null,null,{"$f":"SUM(H21,K21,N21,Q21,T21)","v":0},{"$f":"D21*U21","v":0}]
["1.3","Product – Switch (24 Port – 1GB)","each",{"v":0,"d":"0%"},340,60,0,{"$f":"F22*G22","v":0},60,0,{"$f":"I22*J22","v":0},60,0,0,80,0,{"$f":"O22*P22","v":0},80,0,{"$f":"R22*S22","v":0},0,0]
["1.4","Product – Switch (48 Port – 1GB)","each",{"v":0,"d":"0%"},100,20,0,0,20,0,0,20,0,0,20,0,0,20,0,0,0,0]
["1.5","Product – Switch (12 Port fibre – 1GB)","each",{"v":0,"d":"0%"},6,2,0,0,2,0,0,2,0,0,0,null,null,0,null,null,0,0]
["1.6","Product – Switch (12 Port fibre – 10GB)","each",{"v":0,"d":"0%"},6,2,0,0,2,0,0,2,0,0,0,null,null,0,null,null,0,0]
["1.7","Product – Switch (24 Port – 10GB","each",{"v":0,"d":"0%"},50,2,0,0,4,0,0,4,0,0,20,0,{"$f":"O26*P26","v":0},20,0,{"$f":"R26*S26","v":0},0,0]
["1.8","Product – Switch (48 Port – 10GB)","each",{"v":0,"d":"0%"},50,2,0,0,4,0,0,4,0,0,20,0,{"$f":"O27*P27","v":0},20,0,{"$f":"R27*S27","v":0},0,0]
["1.9","IPsec licenses","each",{"v":0,"d":"0%"},50,10,0,0,10,0,0,10,0,0,10,0,0,10,0,0,0,0]
["1.10","Maintenance and Support on new network devices (Line 1.1 to 1.8)","Monthly",{"v":0,"d":"0%"},60,12,0,0,12,0,0,12,0,0,12,0,{"$f":"O29*P29","v":0},12,0,0,0,0]
["1.11","Maintenance and Support on current network devices (as per attached equipment list. ANNEX A.5: Addendum A)","Monthly",{"v":0,"d":"0%"},36,12,0,0,12,0,0,12,0,0,0,null,null,0,null,null,0,0]
["1.12","Onsite Resources","Number of",{"v":0,"d":"0%"},10,2,0,0,2,0,0,2,0,0,2,0,0,2,0,0,0,0]
["1.13","Network Management and Monitoring tool (IT Asset Management)","Once-off",{"v":0,"d":"0%"},1,1,0,0,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":5},{"$f":"SUBTOTAL(9,H19:H32)","v":0},null,null,{"$f":"SUBTOTAL(9,K19:K32)","v":0},null,null,{"$f":"SUBTOTAL(9,N19:N32)","v":0},null,null,{"$f":"SUBTOTAL(9,Q19:Q32)","v":0},null,null,{"$f":"SUBTOTAL(9,T19:T32)","v":0},{"$f":"SUBTOTAL(9,U19:U32)","v":0},{"$f":"SUBTOTAL(9,V19:V32)","v":0}]
[null,"VAT (@15%)",{"$nulls":5},{"$f":"H33*0.15","v":0},null,null,{"$f":"K33*0.15","v":0},null,null,{"$f":"N33*0.15","v":0},null,null,{"$f":"Q33*0.15","v":0},null,null,{"$f":"T33*0.15","v":0},{"$f":"U33*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":5},{"$f":"H33+H34","v":0},null,null,{"$f":"K33+K34","v":0},null,null,{"$f":"N33+N34","v":0},null,null,{"$f":"Q33+Q34","v":0},null,null,{"$f":"T33+T34","v":0},{"$f":"U33+U34","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,null,"Capacity"]
[]
[null,null,"Signature (above)",null,null,"Date"]
[]
[]
[null,"Note (1):\nThe ROE stated above will apply for this tender and Bidder need to factor in any fluctuations of ROE risk as part of the Bid process in their Bid response.\nThis tender will be fixed and firm for the duration of the contract payable in SA Rands."]