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

{"sheet":"COVER SHEET","index":0,"n_rows":47,"n_cols":11,"rows_kept":47,"merged":[[1,10,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],[46,0,46,12],[47,0,47,12],[48,0,48,12],[49,0,49,12]]}
[]
[{"$nulls":10},"ANNEXURE A3"]
{"$rows_empty":11}
["PRICING SUBMISSION"]
[]
[]
["RFB NO:",{"$nulls":3},"RFB 02-2023"]
[]
["RFB NAME:",{"$nulls":3},"APPOINTMENT OF A TRAVEL MANAGEMENT AGENCY TO PROVIDE  TRAVEL MANAGEMENT AND RELATED SERVICES INCLUSIVE OF ONLINE TRAVEL SOLUTIONS TO THE ENTIRE DOJ&CD AND NPA FOR A PERIOD OF THREE YEARS"]
[]
["BIDDER NAME"]
[]
[]
["PRICE INSTRUCTIONS"]
[]
["1.  STRUCTURE OF THE TENDER"]
["This spreadsheet for RFB 02-2023 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 both 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 sign all paper copies of their Pricing Schedule."]
["2.1.3 Bidders must complete and submit ALL templates 1.1 & 1.2,which are management fee model onsite and offsite,\n         transactional fee model onsite and offsite"]
["2.1.4 Bidders must reference main document section 9.2 for current travel volumes"]
["2.2  Input spreadsheets"]
["2.2.1 The Pricing Schedule templates are contained within the one (1) Excel spreadsheet ."]
["2.2.2 All worksheets in the electronic copy of the Pricing Schedule are password protected."]
["2.2.3 Bidders must not unprotect the spreadsheets and/or make any changes to the spreadsheets or change the formatting\n         of the Pricing Schedule."]
["2.2.4 Cells are formatted to automatically indicate South African Rands, ordinary text fields and percentages (%) where \n         applicable."]
["2.2.5 Input cells are highlighted in light green. The Bidder must complete all input cells for the bid. No other cells must be\n        changed in any way whatsoever."]
["2.2.6 The Bidders are required to input the following cells only:"]
[]
[]
["2.3  Currency and VAT"]
["2.3.1 Bidders’ proposed Pricing Schedules must be firm and not indicative."]
["2.3.2 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":"2. TRANSACTION FEE OFFSITE DOJ","index":1,"n_rows":59,"n_cols":9,"rows_kept":59,"merged":[[0,2,2,7],[3,2,3,7],[6,2,6,7],[7,2,7,7],[8,2,8,7],[10,3,10,4],[11,0,11,2],[11,3,11,5],[11,6,11,8],[54,0,54,2],[56,0,56,1],[56,3,56,4],[57,3,57,8],[58,3,58,8]]}
[null,null,"TRANSACTION FEE MODEL"]
[]
[]
[null,null,"OFF-SITE SERVICES"]
[]
[]
["RFB NO:",null,"RFB  02-2023"]
["RFB NAME:",null,"APPOINTMENT OF A TRAVEL MANAGEMENT AGENCY TO PROVIDE  TRAVEL MANAGEMENT AND RELATED SERVICES INCLUSIVE OF ONLINE TRAVEL SOLUTIONS TO THE ENTIRE DOJ&CD FOR A PERIOD OF THREE YEARS"]
["BIDDER NAME"]
[]
["1.1  TRANSACTION FEES"]
[{"$nulls":3},"TRADITIONAL BOOKINGS",null,null,"ONLINE BOOKINGS"]
["ITEM","Transaction Type","Estimated Volume","Unit Price\n(excl VAT)","Unit Price\n(incl VAT)","TOTAL Price\n(incl VAT)","Unit Price\n(excl VAT)","Unit Price\n(incl VAT)","TOTAL Price\n(incl VAT)"]
[1,"Air Travel – International",67,null,{"$f":"D14*1.14","v":0},{"$f":"E14*C14","v":0},null,{"$f":"G14*1.14","v":0},{"$f":"H14*C14","v":0}]
[2,"Air Travel – Regional",32,null,{"$f":"D15*1.14","v":0},{"$f":"E15*C15","v":0},null,{"$f":"G15*1.14","v":0},{"$f":"H15*C15","v":0}]
[3,"Air Travel – Domestic ",{"v":8453,"d":"8,453"},null,0,0,null,0,0]
[4,"Air Travel – International (Re-issue)",0,null,0,0,null,0,0]
[5,"Air Travel – Regional (Re-issue)",0,null,0,0,null,0,0]
[6,"Air Travel – Domestic (Re-issue)",0,null,0,0,null,0,0]
[7,"Refunds – Air Domestic",0,null,0,0,null,0,0]
[8,"Refunds – Air Regional",0,null,0,0,null,0,0]
[9,"Refunds – Air International",0,null,0,0,null,0,0]
[10,"Car Rental – Domestic",{"v":2371,"d":"2,371"},null,0,0,null,0,0]
[11,"Car Rental – Regional ",0,null,0,0,null,0,0]
[12,"Car Rental – International",0,null,0,0,null,0,0]
[13,"Transfers/Shuttle – Domestic",{"v":7418,"d":"7,418"},null,0,0,null,0,0]
[14,"Transfers/Shuttle – Regional",0,null,0,0,null,0,0]
[15,"Transfers/Shuttle – International",0,null,0,0,null,0,0]
[16,"Transfer No Show",0,null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[17,"Accommodation – Domestic",{"v":34574,"d":"34,574"},null,0,0,null,0,0]
[18,"Accommodation – Regional",0,null,0,0,null,0,0]
[19,"Accommodation – International",47,null,0,0,null,0,0]
[20,"Bus/Coach Bookings",462,null,0,0,null,0,0]
[21,"Train bookings – International",0,null,0,0,null,0,0]
[22,"Visa Assistance \n(Provision of documents and advice)",0,null,0,0,null,0,0]
[23,"SMS Notifications",0,null,0,0,null,0,0]
[24,"Parking bookings",15,null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[25,"Airport Parking bookings",0,null,0,0,null,0,0]
[26,"Cancellations",0,null,0,0,null,0,0]
[27,"Changes to bookings",0,null,0,0,null,0,0]
[28,"After Hours Services",885,null,0,0,null,0,0]
[29,"Additional Ad-hoc Reports (per report)",0,null,0,0,null,0,0]
[30,"Customised Reports (per report)",0,null,0,0,null,0,0]
[31,"Travel Lodge card Reconciliation",0,null,0,0,null,0,0]
[32,"Debtors Account Reconciliation/BillBack",0,null,0,0,null,0,0]
[33,"Foreign Exchange",0,null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[34,"Insurance",0,null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[35,"Insurance Regional",0,null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[36,"Conference",333,null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[37,"Other (Corporate Management Fee)",{"v":26659,"d":"26,659"},null,0,0,null,0,0]
[38,"courier services for travel documentation",0,null,0,0]
[39,"other (cargo and food)",1,null,0,0]
[40,"other (Specify)",0,null,0,0]
[null,"Total",{"$f":"SUM(C14:C53)","v":{"v":81317,"d":"81,317"}},null,null,{"$f":"SUM(F14:F53)","v":0},null,null,{"$f":"SUM(I14:I53)","v":0}]
["Percentage Split between Online Booking  and Traditional Booking",null,null,"Percentage Traditional",null,null,"Percentage Online"]
[]
["1.2  CONFERENCE TRANSACTION FEE"]
["Item","Description","Percentage Fee","Comment"]
[1,"Conference Transaction Fee (as a % of the Total turnover of the event)"]

{"sheet":"2. TRANSACTION FEE OFFSITENPA ","index":2,"n_rows":59,"n_cols":9,"rows_kept":59,"merged":[[0,2,2,7],[3,2,3,7],[6,2,6,7],[7,2,7,7],[8,2,8,7],[10,3,10,4],[11,0,11,2],[11,3,11,5],[11,6,11,8],[54,0,54,2],[56,0,56,1],[56,3,56,4],[57,3,57,8],[58,3,58,8]]}
[null,null,"TRANSACTION FEE MODEL"]
[]
[]
[null,null,"OFF-SITE SERVICES"]
[]
[]
["RFB NO:",null,"RFB  02-2023"]
["RFB NAME:",null,"APPOINTMENT OF A TRAVEL MANAGEMENT AGENCY TO PROVIDE  TRAVEL MANAGEMENT AND RELATED SERVICES INCLUSIVE OF ONLINE TRAVEL SOLUTIONS TO THE ENTIRE DOJ&CD FOR A PERIOD OF THREE YEARS"]
["BIDDER NAME"]
[]
["1.1  TRANSACTION FEES"]
[{"$nulls":3},"TRADITIONAL BOOKINGS",null,null,"ONLINE BOOKINGS"]
["ITEM","Transaction Type","Estimated Volume","Unit Price\n(excl VAT)","Unit Price\n(incl VAT)","TOTAL Price\n(incl VAT)","Unit Price\n(excl VAT)","Unit Price\n(incl VAT)","TOTAL Price\n(incl VAT)"]
[1,"Air Travel – International",{"$f":"58+80","v":138},null,{"$f":"D14*1.14","v":0},{"$f":"E14*C14","v":0},null,{"$f":"G14*1.14","v":0},{"$f":"H14*C14","v":0}]
[2,"Air Travel – Regional",{"$f":"22+4","v":26},null,{"$f":"D15*1.14","v":0},{"$f":"E15*C15","v":0},null,{"$f":"G15*1.14","v":0},{"$f":"H15*C15","v":0}]
[3,"Air Travel – Domestic ",{"$f":"4797+3489","v":{"v":8286,"d":"8,286"}},null,0,0,null,0,0]
[4,"Air Travel – International (Re-issue)",null,null,0,0,null,0,0]
[5,"Air Travel – Regional (Re-issue)",0,null,0,0,null,0,0]
[6,"Air Travel – Domestic (Re-issue)",0,null,0,0,null,0,0]
[7,"Refunds – Air Domestic",3,null,0,0,null,0,0]
[8,"Refunds – Air Regional",0,null,0,0,null,0,0]
[9,"Refunds – Air International",0,null,0,0,null,0,0]
[10,"Car Rental – Domestic",{"$f":"1134+1118","v":{"v":2252,"d":"2,252"}},null,0,0,null,0,0]
[11,"Car Rental – Regional ",0,null,0,0,null,0,0]
[12,"Car Rental – International",0,null,0,0,null,0,0]
[13,"Transfers/Shuttle – Domestic",{"$f":"1033+1+1029","v":{"v":2063,"d":"2,063"}},null,0,0,null,0,0]
[14,"Transfers/Shuttle – Regional",0,null,0,0,null,0,0]
[15,"Transfers/Shuttle – International",2,null,0,0,null,0,0]
[16,"Transfer No Show",1,null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[17,"Accommodation – Domestic",{"$f":"10885+10736","v":{"v":21621,"d":"21,621"}},null,0,0,null,0,0]
[18,"Accommodation – Regional",0,null,0,0,null,0,0]
[19,"Accommodation – International",{"$f":"40+40","v":80},null,0,0,null,0,0]
[20,"Bus/Coach Bookings",{"$f":"4+3","v":7},null,0,0,null,0,0]
[21,"Train bookings – International",0,null,0,0,null,0,0]
[22,"Visa Assistance \n(Provision of documents and advice)",0,null,0,0,null,0,0]
[23,"SMS Notifications",0,null,0,0,null,0,0]
[24,"Parking bookings",6,null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[25,"Airport Parking bookings",0,null,0,0,null,0,0]
[26,"Cancellations",0,null,0,0,null,0,0]
[27,"Changes to bookings",0,null,0,0,null,0,0]
[28,"After Hours Services",4,null,0,0,null,0,0]
[29,"Additional Ad-hoc Reports (per report)",0,null,0,0,null,0,0]
[30,"Customised Reports (per report)",0,null,0,0,null,0,0]
[31,"Travel Lodge card Reconciliation",0,null,0,0,null,0,0]
[32,"Debtors Account Reconciliation/BillBack",49,null,0,0,null,0,0]
[33,"Foreign Exchange",0,null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[34,"Insurance",48,null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[35,"Insurance Regional",0,null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[36,"Conference",49,null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[37,"Other (Corporate Management Fee)",{"$f":"29597+13042","v":{"v":42639,"d":"42,639"}},null,0,0,null,0,0]
[38,"courier services for travel documentation",0,null,0,0]
[39,"other (cargo and food)",2,null,0,0]
[40,"other (Specify) Car hire damages & Laundry  Tours Domestic",{"$f":"6+7+1","v":14},null,{"$f":"D53*1.14","v":0},{"$f":"E53*C53","v":0}]
[null,"Total",{"$f":"SUM(C14:C53)","v":{"v":77290,"d":"77,290"}},null,null,{"$f":"SUM(F14:F53)","v":0},null,null,{"$f":"SUM(I14:I53)","v":0}]
["Percentage Split between Online Booking  and Traditional Booking",null,null,"Percentage Traditional",null,null,"Percentage Online"]
[]
["1.2  CONFERENCE TRANSACTION FEE"]
["Item","Description","Percentage Fee","Comment"]
[1,"Conference Transaction Fee (as a % of the Total turnover of the event)"]

{"sheet":"Consolid","index":3,"n_rows":59,"n_cols":9,"rows_kept":59,"merged":[[0,2,2,7],[3,2,3,7],[6,2,6,7],[7,2,7,7],[8,2,8,7],[10,3,10,4],[11,0,11,2],[11,3,11,5],[11,6,11,8],[54,0,54,2],[56,0,56,1],[56,3,56,4],[57,3,57,8],[58,3,58,8]]}
[null,null,"TRANSACTION FEE MODEL"]
[]
[]
[null,null,"OFF-SITE SERVICES"]
[]
[]
["RFB NO:",null,"RFB  02-2023"]
["RFB NAME:",null,"APPOINTMENT OF A TRAVEL MANAGEMENT AGENCY TO PROVIDE  TRAVEL MANAGEMENT AND RELATED SERVICES INCLUSIVE OF ONLINE TRAVEL SOLUTIONS TO THE ENTIRE DOJ&CD AND NPA FOR A PERIOD OF THREE YEARS"]
["BIDDER NAME"]
[]
["1.1  TRANSACTION FEES"]
[{"$nulls":3},"TRADITIONAL BOOKINGS",null,null,"ONLINE BOOKINGS"]
["ITEM","Transaction Type","Estimated Volume","Unit Price\n(excl VAT)","Unit Price\n(incl VAT)","TOTAL Price\n(incl VAT)","Unit Price\n(excl VAT)","Unit Price\n(incl VAT)","TOTAL Price\n(incl VAT)"]
[1,"Air Travel – International",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C14+'2. TRANSACTION FEE OFFSITENPA '!C14","v":205},null,{"$f":"D14*1.14","v":0},{"$f":"E14*C14","v":0},null,{"$f":"G14*1.14","v":0},{"$f":"H14*C14","v":0}]
[2,"Air Travel – Regional",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C15+'2. TRANSACTION FEE OFFSITENPA '!C15","v":58},null,{"$f":"D15*1.14","v":0},{"$f":"E15*C15","v":0},null,{"$f":"G15*1.14","v":0},{"$f":"H15*C15","v":0}]
[3,"Air Travel – Domestic ",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C16+'2. TRANSACTION FEE OFFSITENPA '!C16","v":{"v":16739,"d":"16,739"}},null,0,0,null,0,0]
[4,"Air Travel – International (Re-issue)",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C17+'2. TRANSACTION FEE OFFSITENPA '!C17","v":0},null,0,0,null,0,0]
[5,"Air Travel – Regional (Re-issue)",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C18+'2. TRANSACTION FEE OFFSITENPA '!C18","v":0},null,0,0,null,0,0]
[6,"Air Travel – Domestic (Re-issue)",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C19+'2. TRANSACTION FEE OFFSITENPA '!C19","v":0},null,0,0,null,0,0]
[7,"Refunds – Air Domestic",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C20+'2. TRANSACTION FEE OFFSITENPA '!C20","v":3},null,0,0,null,0,0]
[8,"Refunds – Air Regional",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C21+'2. TRANSACTION FEE OFFSITENPA '!C21","v":0},null,0,0,null,0,0]
[9,"Refunds – Air International",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C22+'2. TRANSACTION FEE OFFSITENPA '!C22","v":0},null,0,0,null,0,0]
[10,"Car Rental – Domestic",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C23+'2. TRANSACTION FEE OFFSITENPA '!C23","v":{"v":4623,"d":"4,623"}},null,0,0,null,0,0]
[11,"Car Rental – Regional ",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C24+'2. TRANSACTION FEE OFFSITENPA '!C24","v":0},null,0,0,null,0,0]
[12,"Car Rental – International",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C25+'2. TRANSACTION FEE OFFSITENPA '!C25","v":0},null,0,0,null,0,0]
[13,"Transfers/Shuttle – Domestic",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C26+'2. TRANSACTION FEE OFFSITENPA '!C26","v":{"v":9481,"d":"9,481"}},null,0,0,null,0,0]
[14,"Transfers/Shuttle – Regional",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C27+'2. TRANSACTION FEE OFFSITENPA '!C27","v":0},null,0,0,null,0,0]
[15,"Transfers/Shuttle – International",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C28+'2. TRANSACTION FEE OFFSITENPA '!C28","v":2},null,0,0,null,0,0]
[16,"Transfer No Show",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C29+'2. TRANSACTION FEE OFFSITENPA '!C29","v":1},null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[17,"Accommodation – Domestic",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C30+'2. TRANSACTION FEE OFFSITENPA '!C30","v":{"v":56195,"d":"56,195"}},null,0,0,null,0,0]
[18,"Accommodation – Regional",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C31+'2. TRANSACTION FEE OFFSITENPA '!C31","v":0},null,0,0,null,0,0]
[19,"Accommodation – International",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C32+'2. TRANSACTION FEE OFFSITENPA '!C32","v":127},null,0,0,null,0,0]
[20,"Bus/Coach Bookings",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C33+'2. TRANSACTION FEE OFFSITENPA '!C33","v":469},null,0,0,null,0,0]
[21,"Train bookings – International",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C34+'2. TRANSACTION FEE OFFSITENPA '!C34","v":0},null,0,0,null,0,0]
[22,"Visa Assistance \n(Provision of documents and advice)",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C35+'2. TRANSACTION FEE OFFSITENPA '!C35","v":0},null,0,0,null,0,0]
[23,"SMS Notifications",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C36+'2. TRANSACTION FEE OFFSITENPA '!C36","v":0},null,0,0,null,0,0]
[24,"Parking bookings",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C37+'2. TRANSACTION FEE OFFSITENPA '!C37","v":21},null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[25,"Airport Parking bookings",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C38+'2. TRANSACTION FEE OFFSITENPA '!C38","v":0},null,0,0,null,0,0]
[26,"Cancellations",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C39+'2. TRANSACTION FEE OFFSITENPA '!C39","v":0},null,0,0,null,0,0]
[27,"Changes to bookings",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C40+'2. TRANSACTION FEE OFFSITENPA '!C40","v":0},null,0,0,null,0,0]
[28,"After Hours Services",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C41+'2. TRANSACTION FEE OFFSITENPA '!C41","v":889},null,0,0,null,0,0]
[29,"Additional Ad-hoc Reports (per report)",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C42+'2. TRANSACTION FEE OFFSITENPA '!C42","v":0},null,0,0,null,0,0]
[30,"Customised Reports (per report)",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C43+'2. TRANSACTION FEE OFFSITENPA '!C43","v":0},null,0,0,null,0,0]
[31,"Travel Lodge card Reconciliation",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C44+'2. TRANSACTION FEE OFFSITENPA '!C44","v":0},null,0,0,null,0,0]
[32,"Debtors Account Reconciliation/BillBack",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C45+'2. TRANSACTION FEE OFFSITENPA '!C45","v":49},null,0,0,null,0,0]
[33,"Foreign Exchange",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C46+'2. TRANSACTION FEE OFFSITENPA '!C46","v":0},null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[34,"Insurance",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C47+'2. TRANSACTION FEE OFFSITENPA '!C47","v":48},null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[35,"Insurance Regional",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C48+'2. TRANSACTION FEE OFFSITENPA '!C48","v":0},null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[36,"Conference",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C49+'2. TRANSACTION FEE OFFSITENPA '!C49","v":382},null,"R             - ","R                     - ",null,"R           - ","R                      - "]
[37,"Other (Corporate Management Fee)",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C50+'2. TRANSACTION FEE OFFSITENPA '!C50","v":{"v":69298,"d":"69,298"}},null,0,0,null,0,0]
[38,"courier services for travel documentation",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C51+'2. TRANSACTION FEE OFFSITENPA '!C51","v":0},null,0,0]
[39,"other (cargo and food)",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C52+'2. TRANSACTION FEE OFFSITENPA '!C52","v":3},null,0,0]
[40,"other (Specify) Car hire damages & Laundry  Tours Domestic",{"$f":"'2. TRANSACTION FEE OFFSITE DOJ'!C53+'2. TRANSACTION FEE OFFSITENPA '!C53","v":14},null,0,0]
[null,"Total",{"$f":"SUM(C14:C53)","v":{"v":158607,"d":"158,607"}},null,null,{"$f":"SUM(F14:F53)","v":0},null,null,{"$f":"SUM(I14:I53)","v":0}]
["Percentage Split between Online Booking  and Traditional Booking",null,null,"Percentage Traditional",null,null,"Percentage Online"]
[]
["1.2  CONFERENCE TRANSACTION FEE"]
["Item","Description","Percentage Fee","Comment"]
[1,"Conference Transaction Fee (as a % of the Total turnover of the event)"]

{"sheet":"Price Declaration ","index":4,"n_rows":40,"n_cols":8,"rows_kept":40,"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],[12,0,12,8],[15,0,15,8],[16,0,16,8],[17,0,17,8],[18,0,18,3],[18,4,18,8],[19,0,19,1],[19,2,19,3],[19,4,19,6],[19,7,19,8],[20,0,20,8],[21,0,21,3],[21,4,21,8],[23,0,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,2],[30,4,30,8],[31,0,31,8],[32,0,32,8],[33,0,33,8],[34,0,34,8],[35,0,35,8],[36,0,36,8],[37,0,37,8],[38,0,38,8],[39,0,39,8],[40,0,40,8]]}
{"$rows_empty":7}
["RFB NO:",null,{"$f":"'COVER SHEET'!$E17","v":"RFB 02-2023"}]
["RFB NAME:",null,{"$f":"'COVER SHEET'!$E19","v":"APPOINTMENT OF A TRAVEL MANAGEMENT AGENCY TO PROVIDE  TRAVEL MANAGEMENT AND RELATED SERVICES INCLUSIVE OF ONLINE TRAVEL SOLUTIONS TO THE ENTIRE DOJ&CD AND NPA FOR A PERIOD OF THREE YEARS"}]
["BIDDER NAME",null,{"$f":"'COVER SHEET'!$E21","v":0}]
[]
[]
["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 DOJ&CD at the following total amounts (including VAT)"]
[]
["Template 1: Transaction Fee (Off-Site)"]
["TRADITIONAL BOOKING",{"$nulls":3},"ON-LINE BOOKING"]
[{"$f":"'2. TRANSACTION FEE OFFSITENPA '!F54","v":0},null,"(incl. VAT)",null,{"$f":"'2. TRANSACTION FEE OFFSITENPA '!I54","v":0},null,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 DOJ&CD"]
[]
["We understand that DOJ&CD are 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: ………………………………………."]
["Fax No: ………………………………………."]
["Cell No: ………………………………………."]
["Email:…………………………………………."]