{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["COVER SHEET","Price Declaration ","2. TRANSACTION FEE OFFSITE "],"not_rendered":{"images":2,"defined_names":26},"read":"whole","date_system":"1900"}

{"sheet":"COVER SHEET","index":0,"n_rows":44,"n_cols":10,"rows_kept":44,"merged":[[1,9,1,11],[13,0,13,12],[16,4,16,11],[18,4,18,11],[20,4,20,11],[23,0,23,12],[25,0,25,12],[26,0,26,12],[27,0,27,12],[28,0,28,12],[29,0,29,12],[30,0,30,12],[31,0,31,12],[32,0,32,12],[33,0,33,12],[34,0,34,12],[35,0,35,12],[36,0,36,12],[37,0,37,12],[38,0,38,12],[39,0,39,12],[40,0,40,12],[41,0,41,12],[42,0,42,12],[43,0,43,12],[44,0,44,12],[45,0,45,12]]}
[]
[{"$nulls":9},"ANNEXURE A3"]
{"$rows_empty":11}
["PRICING SUBMISSION"]
[]
[]
["RFP NO:"]
[]
["RFP NAME:",{"$nulls":3},"TENDER FOR APPOINTMENT OF A TRAVEL MANAGEMENT COMPANY FOR THE DEPARTMENT OF COOPERARTIVE GOVERNANCE (DCOG) FOR THE PERIOD OF THIRTY SIX (36) MONTHS"]
[]
["BIDDER NAME"]
[]
[]
["PRICE INSTRUCTIONS"]
[]
["1.  STRUCTURE OF THE TENDER"]
["This spreadsheet for contains the financial response templates for the bid. The bid pricing submission instructions in this document must be read in conjunction with instructions or notes embedded in the various tabs of spreadsheet (Pricing Schedule)."]
[]
["2.  GENERAL INSTRUCTIONS FOR COMPLETING THE PRICING SCHEDULE TEMPLATES"]
["2.1  Tender submission format"]
["2.1.1 Bidders must  submit  a paper copy and an electronic copy of the Pricing Schedule. In the event of a discrepancy, the\n         paper copy will prevail."]
["2.1.2 Bidders must complete the Pricing Schedule in full and sign all paper copies of their Pricing Schedule."]
["2.1.3 Bidders must  FULLY COMPLETED templates attached ,which is transactional fee model offsite. "]
[" ."]
["2.2  Input spreadsheets"]
["2.2.1 The Pricing Schedule templates are contained within the one (1) Excel Workbook"]
["2.2.2 Bidders must not  make any changes to the spreadsheets or change the formatting of the Pricing Schedule."]
["2.2.3 Cells are formatted to automatically indicate South African Rands, ordinary text fields and percentages (%) where \n         applicable."]
["2.2.4 Input cells FOR THE TENDERING INSTITUTION are highlighted in  YELLOW. The Tendering Institution must complete all  \n        the relevant input cells for the bid. No other cells must be changed in any way whatsoever."]
[]
[]
["2.3  Currency and VAT"]
["2.3.1 All Bidders’ pricing must be quoted in South African Rands (ZAR)."]
["2.3.3 The Pricing Schedule template is designed such that VAT will be calculated on Bidders’ input pricing; therefore Bidders \n         must complete the templates with unit prices excluding VAT."]

{"sheet":"Price Declaration ","index":1,"n_rows":32,"n_cols":5,"rows_kept":32,"merged":[[7,0,7,1],[7,2,7,8],[8,0,8,1],[8,2,8,8],[9,0,9,1],[9,2,9,8],[10,0,10,8],[12,0,12,8],[13,0,13,8],[14,0,14,1],[14,2,14,3],[14,4,14,6],[14,7,14,8],[15,0,15,8],[16,0,16,8],[17,0,17,8],[18,0,18,8],[19,0,19,8],[20,0,20,8],[21,0,21,8],[22,0,22,8],[23,0,23,2],[23,4,23,8],[24,0,24,8],[25,0,25,8],[26,0,26,8],[27,0,27,8],[28,0,28,8],[29,0,29,8],[30,0,30,8],[31,0,31,8],[32,0,32,8]]}
{"$rows_empty":7}
["RFP NO:"]
["RFP NAME:",null,{"$f":"'COVER SHEET'!$E$19","v":"TENDER FOR APPOINTMENT OF A TRAVEL MANAGEMENT COMPANY FOR THE DEPARTMENT OF COOPERARTIVE GOVERNANCE (DCOG) FOR THE PERIOD OF THIRTY SIX (36) MONTHS"}]
["BIDDER NAME"]
["Price Declaration"]
["Dear Sir/Madam,"]
["Having read through and examined the Request For Proposal (RFP) Document, the General Conditions, The Requirement and all other Annexures to the RFP Document, we offer to provide OFF-SITE travel management service to the DCOG at the following total amounts (including VAT)"]
["Transaction Fee (Off-Site)"]
[{"$f":"'2. TRANSACTION FEE OFFSITE '!E47","v":0},null,"(incl. VAT)"]
["In words:"]
[]
["We undertake to hold this offer open for acceptance for a period of 120 days from the date of submission of offers. We further undertake that upon final acceptance of our offer, we will commence with the provision of service when required to do so by the DCOG"]
[]
["We understand that DCOG is not bound to accept the lowest or any offer and that we must bear all costs which we have incurred in connection with preparing and submitting this bid."]
[]
["We hereby undertake for the period during which this bid remains open for acceptance not to divulge to any persons, other than the persons to which the bid is submitted, any information relating to the submission of this bid or the details therein except where such is necessary for the submission of this bid."]
[]
["Signature",{"$nulls":3},"Date"]
["Print name of signatory: ……………………………………………………………………………. "]
["Designation: ………………………………………………………………………………………….  "]
[]
["FOR AND ON BEHALF OF: COMPANY NAME"]
[]
["Tel No: ………………………………………."]
["Mobile No: ………………………………………."]
["Email Address:…………………………………………."]

{"sheet":"2. TRANSACTION FEE OFFSITE ","index":2,"n_rows":47,"n_cols":6,"rows_kept":47,"merged":[[0,2,2,5],[3,2,3,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[11,3,11,4],[12,0,12,2],[12,3,12,5],[42,0,42,3],[42,4,42,5],[43,0,43,3],[43,4,43,5],[44,0,44,3],[44,4,44,5],[45,0,45,3],[45,4,45,5],[46,0,46,3],[46,4,46,5]]}
[]
[]
[]
[null,null,"ANNEXURE A3"]
[]
[null,"TRANSACTION FEE MODEL(OFF-SITE SERVICES)"]
[]
["RFP NO:",null,"COGTA (T) 03/2022"]
["RFP NAME:",null,{"$f":"'COVER SHEET'!$E19","v":"TENDER FOR APPOINTMENT OF A TRAVEL MANAGEMENT COMPANY FOR THE DEPARTMENT OF COOPERARTIVE GOVERNANCE (DCOG) FOR THE PERIOD OF THIRTY SIX (36) MONTHS"}]
["BIDDER NAME"]
[]
["1.1  TRANSACTION FEES"]
[{"$nulls":3},"ONLINE BOOKINGS"]
["ITEM","Transaction Type (Sector)","Units per year","Unit Price \n(excl. VAT)","Unit Price\n(incl. VAT)","TOTAL Price\n(incl VAT) Year 1"]
["1a","Air Travel – Domestic",{"v":12000,"d":"12,000"},null,{"$f":"ROUND(D15*1.15,2)","v":0},{"$f":"E15*C15","v":0}]
["1b","Air Travel – International",100,null,{"$f":"ROUND(D16*1.15,2)","v":0},{"$f":"E16*C16","v":0}]
["2a","Refunds – Air Domestic",150,null,0,0]
["2b","Refunds – Air International",10,null,0,0]
["3a","Accommodation – Domestic",{"v":8200,"d":"8,200"},null,0,0]
["3b","Accommodation – International",40,null,0,0]
["4a","Car Rental – Domestic",{"v":5000,"d":"5,000"},null,0,0]
["4b","Car Rental – International",50,null,0,0]
["5a","Transfers/Shuttle – Domestic",{"v":5900,"d":"5,900"},null,0,0]
["5b","Transfers/Shuttle – International",50,null,0,0]
["6a","Train bookings – Domestic",30,null,0,0]
["6b","Train bookings – International",5,null,0,0]
[7,"Parking bookings at airports",{"v":1500,"d":"1,500"},null,0,0]
[8,"Bus/Coach Bookings (including consultants fee)",10,null,0,0]
[9,"Charters (including consultant fees)",5,null,0,0]
[10,"Visa Assistance \n(Provision of documents and advice)",50,null,0,0]
[11,"Courier services for travel documentation (visa & passports)",60,null,0,0]
[12,"Customised / Reports (per report)",50,null,0,0]
[13,"Consultant Assistance with bookings during office hours / VIP surchage fee per booking (Office Hours)",500,null,0,{"$f":"E33*C33","v":0}]
[14,"Consultant Assistance with bookings after office hours / VIP surchage fee per booking (After Hours)",{"v":1500,"d":"1,500"},null,0,{"$f":"E34*C34","v":0}]
[15,"Monthly Travel Lodge card Reconciliation if utilised",12,null,0,0]
[16,"Monthly Debtors Account Reconciliation",12,null,0,0]
[17,"Bill-back fee per sector (excl. air travel)",200,null,0,{"$f":"E37*C37","v":0}]
[18,"Changes to online booking system (per hour)",240,null,0,{"$f":"E38*C38","v":0}]
[19," Fixed cost for venue booking for up to 150 people.",36,null,0,0]
[20," Fixed cost for venue booking for 151 up to 500 people.",6,null,0,{"$f":"E40*C40","v":0}]
[21," Fixed cost for venue booking for above 500 people.",2,null,0,0]
[null,"Total Year 1`",{"$nulls":3},{"$f":"SUM(F15:F41)","v":0}]
["Initial setup fee (Online booking tool) Incl. VAT",{"$nulls":3},0]
["Price for year 1",{"$nulls":3},{"$f":"F42+E43","v":0}]
["Price for year 2, asuming a 5% inflation adjustment",{"$nulls":3},{"$f":"F42*1.05","v":0}]
["Price for year 3, asuming a 5% inflation adjustment",{"$nulls":3},{"$f":"E45*1.05","v":0}]
["Total indicative contract price to be used in PPPFA calculation",{"$nulls":3},{"$f":"SUM(E44:F46)","v":0}]