{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["COVER SHEET","On Site","Off site","Summary"],"not_rendered":{"images":1,"defined_names":18},"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"]
[]
[]
["BID NO.:",{"$nulls":3},"STATS SA  002/24              CLOSING DATE: 11 DECEMBER 2024"]
[]
["BID NAME:",{"$nulls":3},"Appointment of an In-house Travel Management Company in respect of travel and accommodation arrangements for a period of 36 months"]
[]
["BIDDER NAME:"]
[]
[]
["PRICE INSTRUCTIONS"]
[]
["1.  STRUCTURE OF THE TENDER"]
["This spreadsheet for RFP/BID ________________ 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 the 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 sign all paper copies of their Pricing Schedule."]
["2.1.3 Bidders must complete and submit the templates attached, "]
["2.1.4 Bidders must reference main document section 6.2 for current travel volumes."]
["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 BIDDERS are highlighted in GREEN. The Bidder must complete all the relevant input cells for the bid. \n        No other cells must be changed in any way whatsoever."]
["2.2.4 Cells highlighted in YELLOW are for Stats SA purposes only. Please do not amend. 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(15%) will be calculated on Bidders’ input pricing; therefore Bidders \n         must complete the templates with unit prices excluding VAT."]

{"sheet":"On Site","index":1,"n_rows":54,"n_cols":6,"rows_kept":54,"merged":[[0,2,2,4],[3,2,3,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[11,0,11,2],[11,3,11,5],[53,0,53,5]]}
[null,null,"ANNEXURE A3.1: TRANSACTION FEE MODEL"]
[]
[]
[null,null,"ON-SITE SERVICES"]
[]
[]
["RFP NO.:",null,"STATS SA 002/24                                                                                  CLOSING DATE: 11 DECEMBER 2024"]
["RFP NAME:",null,{"$f":"'COVER SHEET'!$E19","v":"Appointment of an In-house Travel Management Company in respect of travel and accommodation arrangements for a period of 36 months"}]
["BIDDER NAME:"]
[]
["1.1  TRANSACTION FEES"]
[{"$nulls":3},"ONLINE BOOKINGS"]
["ITEM","Transaction type","Estimated volume","Unit price\n(excl VAT)","Unit price\n(incl VAT)","TOTAL price\n(incl VAT)"]
[1,"Air travel – international ",100,0,{"$f":"D14*1.15","v":0},{"$f":"E14*C14","v":0}]
[2,"Air travel – regional",2000,0,{"$f":"D15*1.15","v":0},0]
[3,"Air travel – domestic ",2000,0,0,0]
[4,"Air travel – international (re-issue)",2000,0,0,0]
[5,"Air travel – regional (re-issue)",2000,0,0,0]
[6,"Air travel – domestic (re-issue)",2000,0,0,0]
[7,"Refunds – air domestic",2000,0,0,0]
[8,"Refunds – air regional",2000,0,0,0]
[9,"Refunds – air international",2000,0,0,0]
[10,"Car rental – domestic",2000,0,0,0]
[11,"Car rental – regional ",2000,0,0,0]
[12,"Car rental – international",2000,0,0,0]
[13,"Transfers/shuttle – domestic",2000,0,0,0]
[14,"Transfers/shuttle – regional",2000,0,0,0]
[15,"Transfers/shuttle – international",2000,0,0,0]
[16,"Accommodation – domestic",2000,0,0,0]
[17,"Accommodation – regional",2000,0,0,0]
[18,"Accommodation – international",2000,0,0,0]
[19,"Bus/coach bookings",2000,0,0,0]
[20,"Train bookings – international",2000,0,0,0]
[21,"Visa assistance \n(provision of documents and advice)",2000,0,0,0]
[22,"SMS notifications",2000,0,0,0]
[23,"Parking bookings",2000,0,0,0]
[24,"Cancellations",2000,0,0,0]
[25,"Changes to bookings",2000,0,0,0]
[26,"After-hours services",2000,0,0,0]
[27,"Additional ad hoc reports (per report)",2000,0,0,0]
[28,"Customised reports ",2000,0,0,0]
[29,"Debtors account reconciliation",2000,0,0,0]
[30,"Travel vaccinations",2000,0,0,0]
[31,"Conference (cost per pax ) ",2000,0,0,0]
[31.1,"0-51 pax",100,0,0,0]
[31.2,"51-100 pax",100,0,0,0]
[31.3,"101-500 pax",100,0,0,0]
[31.4,"501-unlimited pax",100,0,0,{"$f":"E48*C48","v":0}]
[32,"Travel insurance",50,0,0,0]
[33,"Forex assistance",50,0,0,0]
[34,"Training and workshops",50,0,{"$f":"D51*1.15","v":0},0]
["NB","All air travel trips must be quoted as return trips irrespective of airlines "]
[null,"Total",{"$nulls":3},{"$f":"SUM(F14:F50)","v":0}]
["TOTAL PRICE THAT WILL BE USED FOR EVALUATION PURPOSES"]

{"sheet":"Off site","index":2,"n_rows":54,"n_cols":6,"rows_kept":54,"merged":[[0,2,2,4],[3,2,3,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[11,0,11,2],[11,3,11,5],[53,0,53,5]]}
[null,null,"ANNEXURE A3.2: TRANSACTION FEE MODEL"]
[]
[]
[null,null,"OFF-SITE SERVICES"]
[]
[]
["RFP NO.:",null,"STATS SA 002/24                                                               CLOSING DATE: 11 DECEMBER 2024"]
["RFP NAME:",null,{"$f":"'COVER SHEET'!$E19","v":"Appointment of an In-house Travel Management Company in respect of travel and accommodation arrangements for a period of 36 months"}]
["BIDDER NAME:"]
[]
["1.1  TRANSACTION FEES"]
[{"$nulls":3},"ONLINE BOOKINGS"]
["ITEM","Transaction type","Estimated volume","Unit price\n(excl VAT)","Unit price\n(incl VAT)","TOTAL price\n(incl VAT)"]
[1,"Air travel – international ",100,0,{"$f":"D14*1.15","v":0},{"$f":"E14*C14","v":0}]
[2,"Air travel – regional",2000,0,{"$f":"D15*1.15","v":0},0]
[3,"Air travel – domestic ",2000,0,0,0]
[4,"Air travel – international (re-issue)",2000,0,0,0]
[5,"Air travel – regional (re-issue)",2000,0,0,0]
[6,"Air travel – domestic (re-issue)",2000,0,0,0]
[7,"Refunds – air domestic",2000,0,0,0]
[8,"Refunds – air regional",2000,0,0,0]
[9,"Refunds – air international",2000,0,0,0]
[10,"Car rental – domestic",2000,0,0,0]
[11,"Car rental – regional ",2000,0,0,0]
[12,"Car rental – international",2000,0,0,0]
[13,"Transfers/shuttle – domestic",2000,0,0,0]
[14,"Transfers/shuttle – regional",2000,0,0,0]
[15,"Transfers/shuttle – international",2000,0,0,0]
[16,"Accommodation – domestic",2000,0,0,0]
[17,"Accommodation – regional",2000,0,0,0]
[18,"Accommodation – international",2000,0,0,0]
[19,"Bus/coach bookings",2000,0,0,0]
[20,"Train bookings – international",2000,0,0,0]
[21,"Visa assistance \n(provision of documents and advice)",2000,0,0,0]
[22,"SMS notifications",2000,0,0,0]
[23,"Parking bookings",2000,0,0,0]
[24,"Cancellations",2000,0,0,0]
[25,"Changes to bookings",2000,0,0,0]
[26,"After-hours services",2000,0,0,0]
[27,"Additional ad hoc reports (per report)",2000,0,0,0]
[28,"Customised reports ",2000,0,0,0]
[29,"Debtors account reconciliation",2000,0,0,0]
[30,"Travel vaccinations",2000,0,0,0]
[31,"Conference (cost per pax ) ",2000,0,0,0]
[31.1,"0-51 pax",100,0,0,0]
[31.2,"51-100 pax",100,0,0,0]
[31.3,"101-500 pax",100,0,0,0]
[31.4,"501-unlimited pax",100,0,0,0]
[32,"Travel insurance",50,0,0,0]
[33,"Forex assistance",50,0,0,0]
[34,"Training and workshops",50,0,0,0]
["NB","All air travel trips must be quoted as return trips irrespective of airlines "]
[null,"Total",{"$nulls":3},{"$f":"SUM(F14:F50)","v":0}]
["TOTAL PRICE THAT WILL BE USED FOR EVALUATION PURPOSES"]

{"sheet":"Summary","index":3,"n_rows":17,"n_cols":6,"rows_kept":17,"merged":[[0,2,2,4],[3,2,3,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[11,0,11,2],[11,3,11,5],[16,0,16,5]]}
[null,null,"ANNEXURE A3.3: TRANSACTION FEE SUMMARY"]
[]
[]
[null,null,"Summary Basket Price"]
[]
[]
["RFP NO.:",null,"STATS SA 002/24                                                                          CLOSING DATE: 11 DECEMBER 2024"]
["RFP NAME:",null,{"$f":"'COVER SHEET'!$E19","v":"Appointment of an In-house Travel Management Company in respect of travel and accommodation arrangements for a period of 36 months"}]
["BIDDER NAME:"]
[]
["1.1  TRANSACTION FEES"]
[{"$nulls":3},"ONLINE BOOKINGS"]
["ITEM","Transaction type","Estimated volume","Unit price\n(excl VAT)","Unit price\n(incl VAT)","TOTAL price\n(incl VAT)"]
[null,"Total Transaction Fee - Onsite",{"$nulls":3},{"$f":"'On Site'!F53","v":0}]
[null,"Total Transaction Fee - OffSite",{"$nulls":3},{"$f":"'Off site'!F53","v":0}]
[null,"TOTAL BASKET PRICE"]
["TOTAL PRICE THAT WILL BE USED FOR EVALUATION PURPOSES"]