{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":[" SBD3.1.1 , Year 1","SBD3.1.2 Year 2 ","SBD3.1.3 Year 3","SBD3.1.4 Price total"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":" SBD3.1.1 , Year 1","index":0,"n_rows":86,"n_cols":9,"rows_kept":86,"merged":[[2,0,2,8],[3,0,3,8],[5,1,5,8],[7,1,7,8],[10,0,10,8],[11,0,11,1],[11,2,11,6],[12,0,12,8],[13,0,13,8],[15,0,15,8],[17,1,17,2],[17,5,17,8],[21,0,21,1],[23,0,23,2],[23,3,23,8],[24,0,24,2],[24,3,24,8],[25,0,25,2],[25,3,25,8],[26,0,26,2],[26,3,26,8],[27,0,27,2],[27,3,27,8],[29,0,29,8],[30,5,30,6],[30,7,30,8],[31,0,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[65,0,65,8],[67,1,67,4],[67,6,67,8],[68,0,70,0],[68,1,68,4],[68,5,70,5],[68,6,70,8],[69,1,69,4],[70,1,70,4],[72,1,72,5],[72,6,72,8],[73,1,73,5],[73,6,73,8],[74,1,74,5],[74,6,74,8],[75,1,75,5],[75,6,75,8],[76,1,76,5],[76,6,76,8],[78,0,78,8],[79,0,79,8],[80,0,80,8],[81,0,81,8],[82,0,82,8],[83,0,83,8],[84,0,84,8]]}
[{"$nulls":7},"SBD 3.1.1"]
[]
["PRICING SCHEDULE – FIRM PRICES"]
["(PURCHASES)"]
[]
["NOTE:","ONLY FIRM PRICES WILL BE ACCEPTED. NON-FIRM PRICES (INCLUDING PRICES SUBJECT TO RATES OF EXCHANGE VARIATIONS) WILL NOT BE CONSIDERED"]
[]
[null,"IN CASES WHERE DIFFERENT DELIVERY POINTS INFLUENCE THE PRICING, A SEPARATE PRICING SCHEDULE MUST BE SUBMITTED FOR EACH DELIVERY POINT "]
[]
[]
[]
["Name of bidder",{"$nulls":6},"Bid number: ","DIRCO 08-2025/2026"]
[]
["Closing date 30/01/2026 Time 11h00 AM"]
[]
["OFFER TO BE VALID FOR 120 DAYS FROM THE CLOSING DATE OF BID."]
[]
["ITEM NO.","DESCRIPTION",null,"UNIT","QUANTITY","BID PRICE IN RSA CURRENCY \n(INCLUDING VAT)"]
[]
["Required by: The Department of International Relations and Cooperation (DIRCO) "]
[]
["YEAR 1"]
[]
[{"$nulls":3},"TEMPLATE 1: TRANSACTION FEE MODEL"]
[{"$nulls":3},"OFF-SITE SERVICES"]
["RFP NO:",null,null,{"$f":"I12","v":"DIRCO 08-2025/2026"}]
["RFP NAME:",null,null,"THE PROVISION OF TRAVEL MANAGEMENT SERVICES FOR A PERIOD OF 36 MONTHS"]
["BIDDER NAME",null,null,{"$f":"C12","v":0}]
[]
["1.1 TRANSACTION FEES(A) - YEAR 1"]
[{"$nulls":5},"TRADITIONAL BOOKINGS (A)",null,"ONLINE BOOKING(B)"]
[{"$nulls":4},"A","B","C","D","E"]
["ITEM","Transaction Type",null,"Unit","Estimated  Number Of Transactions Per Annum","Unit Price (incl VAT)","TOTAL Price\n (incl VAT)\n (A x B = C)","Unit Price (incl VAT)","TOTAL Price\n(incl VAT)\n (A x D = E)"]
[1,"AIR TRAVEL",{"$nulls":3},{"$f":"SUM(F35:F43)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G35:G43)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(H35:H43)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(I35:I43)","v":{"v":0,"d":"R0.00"}}]
["1.1","Air Travel – International",null,"Per Ticket per order",1117,null,{"$f":"E35*F35","v":{"v":0,"d":"R0.00"}},null,{"$f":"E35*H35","v":{"v":0,"d":"R0.00"}}]
["1.2","Air Travel – Domestic ",null,"Per Ticket per order",1214,null,{"$f":"E36*F36","v":{"v":0,"d":"R0.00"}},null,{"$f":"E36*H36","v":{"v":0,"d":"R0.00"}}]
["1.3","Air Travel – International \n(Re-issue)",null,"Per Ticket per order",979,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.4","Air Travel – Domestic \n(Re-issue)",null,"Per Ticket per order",425,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.5","Refunds – Air Domestic",null,"Per Ticket per order",243,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.6","Refunds – Air International",null,"Per Ticket per order",559,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.7","Excess Luggage - Domestic",null,"Per Ticket per order",2,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.8 ","Excess Luggage - International",null,"Per Ticket per order",102,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.9","Charter Flights",null,"Per Order",1,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["2.","CAR RENTAL[1]",{"$nulls":3},{"$f":"SUM(F45)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G45)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(H45)","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[null,"Reservations [2] - Domestic ",null,"Per reservation per order",457,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["3.","SHUTTLE SERVICES [3] ",{"$nulls":3},{"$f":"SUM(F47:F48)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G47:G48)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(H47:H48)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(I47:I48)","v":{"v":0,"d":"R0.00"}}]
["3.1","Chauffer drive/Shuttle Service [4] reservation - Domestic",null,"Per reservation per order",1307,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["3.2","Bus/Coach Bookings",null,"Per reservation per order",5,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
[4,"ACCOMMODATION",{"$nulls":3},{"$f":"SUM(F50:F51)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G50:G51)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(H50:H51)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(I50:I51)","v":{"v":0,"d":"R0.00"}}]
["4.1","Reservations [7] – Domestic",null,"Per reservation per order",1434,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["4.2","Reservations (transit) - International",null,"Per reservation per order",6,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
[5,"AIRPORT PARKING",{"$nulls":3},{"$f":"SUM(F53)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G53)","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Airport Parking Reservations",null,"Per reservation per order",8,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
[6,"OTHER SERVICES",{"$nulls":3},{"$f":"SUM(F55:F62)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G55:G62)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(H55:H62)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(I55:I62)","v":{"v":0,"d":"R0.00"}}]
["6.1","Cancellations",null,"Per order",518,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.2","Changes to bookings",null,"Per order",109,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.3","After Hours Reservations/ Amendments",null,"Per order",292,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.4","Travel Insurance",null,"Per Person",1,null,{"$f":"E58*F58","v":{"v":0,"d":"R0.00"}},null,{"$f":"E58*H58","v":{"v":0,"d":"R0.00"}}]
["6.5","Additional Ad-hoc Reports (per report)",null,null,4,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.6","Customised Reports (per report)",null,null,4,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.7","Travel Lodge card Reconciliation",null,null,12,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.8","Debtors Account Reconciliation",null,null,12,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
[null,"Subtotal",{"$nulls":3},"A=",{"$f":"SUM(G34:G62)/2","v":{"v":0,"d":"R0.00"}},"B=    ",{"$f":"SUM(I34:I62)/2","v":{"v":0,"d":"R0.00"}}]
[]
[]
["1.2    CONFERENCE TRANSACTION FEE (C) - YEAR 1"]
[]
["Item","Description",{"$nulls":3},"% Fee","R= % x R5M"]
[1,"Conference Transaction Fee \n(as a % of the Total turnover of the event) inclusive: Conference venue, support facilities; ICT equipment, catering, laundry, parking,accommodation and transport[8].",{"$nulls":4},{"$f":"F69*B71","v":{"v":0,"d":"R0.00"}}]
[null,"Estimated figure:"]
[null,{"v":5000000,"d":"R5,000,000.00"}]
[]
["1.3","TOTAL",{"$nulls":4},"RAND"]
["A"," TRADITIONAL BOOKING",{"$nulls":4},{"$f":"G63","v":{"v":0,"d":"R0.00"}}]
["B","TOTAL ONLINE BOOKING ",{"$nulls":4},{"$f":"I63","v":{"v":0,"d":"R0.00"}}]
["C","TOTAL CONFERENCE FEE",{"$nulls":4},{"$f":"G69","v":{"v":0,"d":"R0.00"}}]
[null,"Grand TOTAL (A+B+C)",{"$nulls":4},{"$f":"SUM(G74:G76)","v":{"v":0,"d":"R0.00"}}]
[]
["[1] Car rental costs incurred on behalf of an employee required to travel to various locations within South Africa in performing his official duties.(Self Drive)"]
["[2] Reservation = per vehicle"]
["[3] Transport expenditure with an operator for local trips within the borders of South Africa. This category includes chauffer and shuttle services and taxi transport."]
["[4] A motor vehicle is reserved from a private rental firm together with a driver"]
["[5] Scheduled passenger services, within the South African Boundaries (Road Transport)"]
["[6] Scheduled passenger services, outside the South African Boundaries (Road Transport)"]
["[7] Accommodation reservation – reserving room(s). Order issued per Official/Family travelling"]
["[8] DIRCO reserves the right to decide the transaction type for determination of service fee."]

{"sheet":"SBD3.1.2 Year 2 ","index":1,"n_rows":86,"n_cols":9,"rows_kept":86,"merged":[[2,0,2,8],[3,0,3,8],[5,1,5,8],[7,1,7,8],[10,0,10,8],[11,0,11,1],[11,2,11,6],[12,0,12,8],[13,0,13,8],[15,0,15,8],[17,1,17,2],[17,5,17,8],[21,0,21,1],[23,0,23,2],[23,3,23,8],[24,0,24,2],[24,3,24,8],[25,0,25,2],[25,3,25,8],[26,0,26,2],[26,3,26,8],[27,0,27,2],[27,3,27,8],[29,0,29,8],[30,5,30,6],[30,7,30,8],[31,0,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[65,0,65,8],[67,1,67,4],[67,6,67,8],[68,0,70,0],[68,1,68,4],[68,5,70,5],[68,6,70,8],[69,1,69,4],[70,1,70,4],[72,1,72,5],[72,6,72,8],[73,1,73,5],[73,6,73,8],[74,1,74,5],[74,6,74,8],[75,1,75,5],[75,6,75,8],[76,1,76,5],[76,6,76,8],[78,0,78,8],[79,0,79,8],[80,0,80,8],[81,0,81,8],[82,0,82,8],[83,0,83,8],[84,0,84,8]]}
[{"$nulls":7},"SBD 3.1.2"]
[]
["PRICING SCHEDULE – FIRM PRICES"]
["(PURCHASES)"]
[]
["NOTE:","ONLY FIRM PRICES WILL BE ACCEPTED. NON-FIRM PRICES (INCLUDING PRICES SUBJECT TO RATES OF EXCHANGE VARIATIONS) WILL NOT BE CONSIDERED"]
[]
[null,"IN CASES WHERE DIFFERENT DELIVERY POINTS INFLUENCE THE PRICING, A SEPARATE PRICING SCHEDULE MUST BE SUBMITTED FOR EACH DELIVERY POINT "]
[]
[]
[]
["Name of bidder",null,{"$f":"' SBD3.1.1 , Year 1'!C12","v":0},{"$nulls":4},"Bid number: ",{"$f":"' SBD3.1.1 , Year 1'!I12","v":"DIRCO 08-2025/2026"}]
[]
[{"$f":"' SBD3.1.1 , Year 1'!A14","v":"Closing date 30/01/2026 Time 11h00 AM"}]
[]
[{"$f":"' SBD3.1.1 , Year 1'!A16","v":"OFFER TO BE VALID FOR 120 DAYS FROM THE CLOSING DATE OF BID."}]
[]
["ITEM NO.","DESCRIPTION",null,"UNIT","QUANTITY","BID PRICE IN RSA CURRENCY \n(INCLUDING VAT)"]
[]
["Required by: The Department of International Relations and Cooperation (DIRCO) "]
[]
["YEAR 2"]
[]
[{"$nulls":3},"TEMPLATE 2: TRANSACTION FEE MODEL"]
[{"$nulls":3},{"$f":"' SBD3.1.1 , Year 1'!D25","v":"OFF-SITE SERVICES"}]
["RFP NO:",null,null,{"$f":"' SBD3.1.1 , Year 1'!D26","v":"DIRCO 08-2025/2026"}]
["RFP NAME:",null,null,{"$f":"' SBD3.1.1 , Year 1'!D27","v":"THE PROVISION OF TRAVEL MANAGEMENT SERVICES FOR A PERIOD OF 36 MONTHS"}]
["BIDDER NAME",null,null,{"$f":"' SBD3.1.1 , Year 1'!C12","v":0}]
[]
["1.1 TRANSACTION FEES(A) - YEAR 2"]
[{"$nulls":5},"TRADITIONAL BOOKINGS (A)",null,"ONLINE BOOKING(B)"]
[{"$nulls":4},"A","B","C","D","E"]
["ITEM","Transaction Type",null,"Unit","Estimated  Number Of Transactions Per Annum","Unit Price (incl VAT)","TOTAL Price\n (incl VAT)\n (A x B = C)","Unit Price (incl VAT)","TOTAL Price\n(incl VAT)\n (A x D = E)"]
[1,"AIR TRAVEL",{"$nulls":3},{"$f":"SUM(F35:F43)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G35:G43)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(H35:H43)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(I35:I43)","v":{"v":0,"d":"R0.00"}}]
["1.1","Air Travel – International",null,"Per Ticket per order",1117,null,{"$f":"E35*F35","v":{"v":0,"d":"R0.00"}},null,{"$f":"E35*H35","v":{"v":0,"d":"R0.00"}}]
["1.2","Air Travel – Domestic ",null,"Per Ticket per order",1214,null,{"$f":"E36*F36","v":{"v":0,"d":"R0.00"}},null,{"$f":"E36*H36","v":{"v":0,"d":"R0.00"}}]
["1.3","Air Travel – International \n(Re-issue)",null,"Per Ticket per order",979,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.4","Air Travel – Domestic \n(Re-issue)",null,"Per Ticket per order",425,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.5","Refunds – Air Domestic",null,"Per Ticket per order",243,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.6","Refunds – Air International",null,"Per Ticket per order",559,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.7","Excess Luggage - Domestic",null,"Per Ticket per order",2,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.8 ","Excess Luggage - International",null,"Per Ticket per order",102,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.9","Charter Flights",null,"Per Order",1,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["2.","CAR RENTAL[1]",{"$nulls":3},{"$f":"SUM(F45)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G45)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(H45)","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[null,"Reservations [2] - Domestic ",null,"Per reservation per order",457,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["3.","SHUTTLE SERVICES [3] ",{"$nulls":3},{"$f":"SUM(F47:F48)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G47:G48)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(H47:H48)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(I47:I48)","v":{"v":0,"d":"R0.00"}}]
["3.1","Chauffer drive/Shuttle Service [4] reservation - Domestic",null,"Per reservation per order",1307,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["3.2","Bus/Coach Bookings",null,"Per reservation per order",5,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
[4,"ACCOMMODATION",{"$nulls":3},{"$f":"SUM(F50:F51)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G50:G51)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(H50:H51)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(I50:I51)","v":{"v":0,"d":"R0.00"}}]
["4.1","Reservations [7] – Domestic",null,"Per reservation per order",1434,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["4.2","Reservations (transit) - International",null,"Per reservation per order",6,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
[5,"AIRPORT PARKING",{"$nulls":3},{"$f":"SUM(F53)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G53)","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Airport Parking Reservations",null,"Per reservation per order",8,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
[6,"OTHER SERVICES",{"$nulls":3},{"$f":"SUM(F55:F62)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G55:G62)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(H55:H62)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(I55:I62)","v":{"v":0,"d":"R0.00"}}]
["6.1","Cancellations",null,"Per order",518,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.2","Changes to bookings",null,"Per order",109,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.3","After Hours Reservations/ Amendments",null,"Per order",292,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.4","Travel Insurance",null,"Per Person",1,null,{"$f":"E58*F58","v":{"v":0,"d":"R0.00"}},null,{"$f":"E58*H58","v":{"v":0,"d":"R0.00"}}]
["6.5","Additional Ad-hoc Reports (per report)",null,null,4,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.6","Customised Reports (per report)",null,null,4,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.7","Travel Lodge card Reconciliation",null,null,12,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.8","Debtors Account Reconciliation",null,null,12,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
[null,"SubTotal",{"$nulls":3},"A=",{"$f":"SUM(G34:G62)/2","v":{"v":0,"d":"R0.00"}},"B=    ",{"$f":"SUM(I34:I62)/2","v":{"v":0,"d":"R0.00"}}]
[]
[]
["1.2    CONFERENCE TRANSACTION FEE (C) - YEAR 2"]
[]
["Item","Description",{"$nulls":3},"% Fee","R= % x R5M"]
[1,"Conference Transaction Fee \n(as a % of the Total turnover of the event) inclusive: Conference venue, support facilities; ICT equipment, catering, laundry, parking,accommodation and transport[8].",{"$nulls":4},{"$f":"F69*B71","v":{"v":0,"d":"R0.00"}}]
[null,"Estimated figure:"]
[null,{"v":5000000,"d":"R5,000,000.00"}]
[]
["1.3","TOTAL",{"$nulls":4},"RAND"]
["A"," TRADITIONAL BOOKING",{"$nulls":4},{"$f":"G63","v":{"v":0,"d":"R0.00"}}]
["B","TOTAL ONLINE BOOKING ",{"$nulls":4},{"$f":"I63","v":{"v":0,"d":"R0.00"}}]
["C","TOTAL CONFERENCE FEE",{"$nulls":4},{"$f":"G69","v":{"v":0,"d":"R0.00"}}]
[null,"Grand TOTAL (A+B+C)",{"$nulls":4},{"$f":"SUM(G74:G76)","v":{"v":0,"d":"R0.00"}}]
[]
["[1] Car rental costs incurred on behalf of an employee required to travel to various locations within South Africa in performing his official duties.(Self Drive)"]
["[2] Reservation = per vehicle"]
["[3] Transport expenditure with an operator for local trips within the borders of South Africa. This category includes chauffer and shuttle services and taxi transport."]
["[4] A motor vehicle is reserved from a private rental firm together with a driver"]
["[5] Scheduled passenger services, within the South African Boundaries (Road Transport)"]
["[6] Scheduled passenger services, outside the South African Boundaries (Road Transport)"]
["[7] Accommodation reservation – reserving room(s). Order issued per Official/Family travelling"]
[{"$f":"' SBD3.1.1 , Year 1'!A86","v":"[8] DIRCO reserves the right to decide the transaction type for determination of service fee."}]

{"sheet":"SBD3.1.3 Year 3","index":2,"n_rows":86,"n_cols":9,"rows_kept":86,"merged":[[2,0,2,8],[3,0,3,8],[5,1,5,8],[7,1,7,8],[10,0,10,8],[11,0,11,1],[11,2,11,6],[12,0,12,8],[13,0,13,8],[15,0,15,8],[17,1,17,2],[17,5,17,8],[21,0,21,1],[23,0,23,2],[23,3,23,8],[24,0,24,2],[24,3,24,8],[25,0,25,2],[25,3,25,8],[26,0,26,2],[26,3,26,8],[27,0,27,2],[27,3,27,8],[29,0,29,8],[30,5,30,6],[30,7,30,8],[31,0,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[65,0,65,8],[67,1,67,4],[67,6,67,8],[68,0,70,0],[68,1,68,4],[68,5,70,5],[68,6,70,8],[69,1,69,4],[70,1,70,4],[72,1,72,5],[72,6,72,8],[73,1,73,5],[73,6,73,8],[74,1,74,5],[74,6,74,8],[75,1,75,5],[75,6,75,8],[76,1,76,5],[76,6,76,8],[78,0,78,8],[79,0,79,8],[80,0,80,8],[81,0,81,8],[82,0,82,8],[83,0,83,8],[84,0,84,8]]}
[{"$nulls":7},"SBD 3.1.3"]
[]
["PRICING SCHEDULE – FIRM PRICES"]
["(PURCHASES)"]
[]
["NOTE:","ONLY FIRM PRICES WILL BE ACCEPTED. NON-FIRM PRICES (INCLUDING PRICES SUBJECT TO RATES OF EXCHANGE VARIATIONS) WILL NOT BE CONSIDERED"]
[]
[null,"IN CASES WHERE DIFFERENT DELIVERY POINTS INFLUENCE THE PRICING, A SEPARATE PRICING SCHEDULE MUST BE SUBMITTED FOR EACH DELIVERY POINT "]
[]
[]
[]
["Name of bidder",null,{"$f":"' SBD3.1.1 , Year 1'!C12","v":0},{"$nulls":4},"Bid number: ",{"$f":"' SBD3.1.1 , Year 1'!I12","v":"DIRCO 08-2025/2026"}]
[]
[{"$f":"' SBD3.1.1 , Year 1'!A14","v":"Closing date 30/01/2026 Time 11h00 AM"}]
[]
[{"$f":"' SBD3.1.1 , Year 1'!A16","v":"OFFER TO BE VALID FOR 120 DAYS FROM THE CLOSING DATE OF BID."}]
[]
["ITEM NO.","DESCRIPTION",null,"UNIT","QUANTITY","BID PRICE IN RSA CURRENCY \n(INCLUDING VAT)"]
[]
["Required by: The Department of International Relations and Cooperation (DIRCO) "]
[]
["YEAR 3"]
[]
[{"$nulls":3},"TEMPLATE 3: TRANSACTION FEE MODEL"]
[{"$nulls":3},{"$f":"' SBD3.1.1 , Year 1'!D25","v":"OFF-SITE SERVICES"}]
["RFP NO:",null,null,{"$f":"' SBD3.1.1 , Year 1'!D26","v":"DIRCO 08-2025/2026"}]
["RFP NAME:",null,null,{"$f":"' SBD3.1.1 , Year 1'!D27","v":"THE PROVISION OF TRAVEL MANAGEMENT SERVICES FOR A PERIOD OF 36 MONTHS"}]
["BIDDER NAME",null,null,{"$f":"' SBD3.1.1 , Year 1'!C12","v":0}]
[]
["1.1 TRANSACTION FEES(A) - YEAR 3"]
[{"$nulls":5},"TRADITIONAL BOOKINGS (A)",null,"ONLINE BOOKING(B)"]
[{"$nulls":4},"A","B","C","D","E"]
["ITEM","Transaction Type",null,"Unit","Estimated  Number Of Transactions Per Annum","Unit Price (incl VAT)","TOTAL Price \n(incl VAT)\n (A x B = C)","Unit Price (incl VAT)","TOTAL Price\n(incl VAT)\n (A x D = E)"]
[1,"AIR TRAVEL",{"$nulls":3},{"$f":"SUM(F35:F43)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G35:G43)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(H35:H43)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(I35:I43)","v":{"v":0,"d":"R0.00"}}]
["1.1","Air Travel – International",null,"Per Ticket per order",1117,null,{"$f":"E35*F35","v":{"v":0,"d":"R0.00"}},null,{"$f":"E35*H35","v":{"v":0,"d":"R0.00"}}]
["1.2","Air Travel – Domestic ",null,"Per Ticket per order",1214,null,{"$f":"E36*F36","v":{"v":0,"d":"R0.00"}},null,{"$f":"E36*H36","v":{"v":0,"d":"R0.00"}}]
["1.3","Air Travel – International \n(Re-issue)",null,"Per Ticket per order",979,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.4","Air Travel – Domestic \n(Re-issue)",null,"Per Ticket per order",425,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.5","Refunds – Air Domestic",null,"Per Ticket per order",243,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.6","Refunds – Air International",null,"Per Ticket per order",559,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.7","Excess Luggage - Domestic",null,"Per Ticket per order",2,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.8 ","Excess Luggage - International",null,"Per Ticket per order",102,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["1.9","Charter Flights",null,"Per Order",1,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["2.","CAR RENTAL[1]",{"$nulls":3},{"$f":"SUM(F45)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G45)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(H45)","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[null,"Reservations [2] - Domestic ",null,"Per reservation per order",457,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["3.","SHUTTLE SERVICES [3] ",{"$nulls":3},{"$f":"SUM(F47:F48)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G47:G48)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(H47:H48)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(I47:I48)","v":{"v":0,"d":"R0.00"}}]
["3.1","Chauffer drive/Shuttle Service [4] reservation - Domestic",null,"Per reservation per order",1307,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["3.2","Bus/Coach Bookings",null,"Per reservation per order",5,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
[4,"ACCOMMODATION",{"$nulls":3},{"$f":"SUM(F50:F51)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G50:G51)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(H50:H51)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(I50:I51)","v":{"v":0,"d":"R0.00"}}]
["4.1","Reservations [7] – Domestic",null,"Per reservation per order",1434,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["4.2","Reservations (transit) - International",null,"Per reservation per order",6,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
[5,"AIRPORT PARKING",{"$nulls":3},{"$f":"SUM(F53)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G53)","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Airport Parking Reservations",null,"Per reservation per order",8,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
[6,"OTHER SERVICES",{"$nulls":3},{"$f":"SUM(F55:F62)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G55:G62)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(H55:H62)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(I55:I62)","v":{"v":0,"d":"R0.00"}}]
["6.1","Cancellations",null,"Per order",518,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.2","Changes to bookings",null,"Per order",109,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.3","After Hours Reservations/ Amendments",null,"Per order",292,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.4","Travel Insurance",null,"Per Person",1,null,{"$f":"E58*F58","v":{"v":0,"d":"R0.00"}},null,{"$f":"E58*H58","v":{"v":0,"d":"R0.00"}}]
["6.5","Additional Ad-hoc Reports (per report)",null,null,4,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.6","Customised Reports (per report)",null,null,4,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.7","Travel Lodge card Reconciliation",null,null,12,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
["6.8","Debtors Account Reconciliation",null,null,12,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
[null,"SubTotal",{"$nulls":3},"A=",{"$f":"SUM(G34:G62)/2","v":{"v":0,"d":"R0.00"}},"B=    ",{"$f":"SUM(I34:I62)/2","v":{"v":0,"d":"R0.00"}}]
[]
[]
["1.2    CONFERENCE TRANSACTION FEE (C) - YEAR 3"]
[]
["Item","Description",{"$nulls":3},"% Fee","R= % x R5M"]
[1,"Conference Transaction Fee \n(as a % of the Total turnover of the event) inclusive: Conference venue, support facilities; ICT equipment, catering, laundry, parking,accommodation and transport[8].",{"$nulls":4},{"$f":"F69*B71","v":{"v":0,"d":"R0.00"}}]
[null,"Estimated figure:"]
[null,{"v":5000000,"d":"R5,000,000.00"}]
[]
["1.3","TOTAL",{"$nulls":4},"RAND"]
["A"," TRADITIONAL BOOKING",{"$nulls":4},{"$f":"G63","v":{"v":0,"d":"R0.00"}}]
["B","TOTAL ONLINE BOOKING ",{"$nulls":4},{"$f":"I63","v":{"v":0,"d":"R0.00"}}]
["C","TOTAL CONFERENCE FEE",{"$nulls":4},{"$f":"G69","v":{"v":0,"d":"R0.00"}}]
[null,"Grand TOTAL (A+B+C)",{"$nulls":4},{"$f":"SUM(G74:G76)","v":{"v":0,"d":"R0.00"}}]
[]
["[1] Car rental costs incurred on behalf of an employee required to travel to various locations within South Africa in performing his official duties.(Self Drive)"]
["[2] Reservation = per vehicle"]
["[3] Transport expenditure with an operator for local trips within the borders of South Africa. This category includes chauffer and shuttle services and taxi transport."]
["[4] A motor vehicle is reserved from a private rental firm together with a driver"]
["[5] Scheduled passenger services, within the South African Boundaries (Road Transport)"]
["[6] Scheduled passenger services, outside the South African Boundaries (Road Transport)"]
["[7] Accommodation reservation – reserving room(s). Order issued per Official/Family travelling"]
[{"$f":"' SBD3.1.1 , Year 1'!A86","v":"[8] DIRCO reserves the right to decide the transaction type for determination of service fee."}]

{"sheet":"SBD3.1.4 Price total","index":3,"n_rows":67,"n_cols":9,"rows_kept":67,"merged":[[2,0,2,8],[3,0,3,8],[5,1,5,8],[7,1,7,8],[10,0,10,8],[11,0,11,1],[11,2,11,6],[12,0,12,8],[13,0,13,8],[15,0,15,8],[19,0,19,8],[21,1,21,8],[22,1,22,8],[23,1,23,8],[25,0,25,8],[26,0,26,8],[28,0,28,8],[29,0,29,8],[30,2,30,3],[30,4,30,5],[30,6,30,7],[31,2,31,3],[31,4,31,5],[31,6,31,7],[32,2,32,3],[32,4,32,5],[32,6,32,7],[33,2,33,3],[33,4,33,5],[33,6,33,7],[34,2,34,3],[34,4,34,5],[34,6,34,7],[35,2,35,3],[35,4,35,5],[35,6,35,7],[36,6,36,7],[38,0,38,2],[39,0,39,8],[40,0,40,1],[41,0,41,2],[42,0,42,8],[43,0,43,2],[44,0,44,8],[45,0,45,2],[46,0,46,8],[48,0,48,8],[50,0,50,8],[52,0,52,1],[52,2,52,5],[52,6,52,7],[53,0,53,4],[53,5,53,6],[54,0,54,1],[54,2,54,7],[56,0,56,1],[56,2,56,7],[58,4,58,8],[60,0,60,1],[60,2,60,5],[62,0,62,1],[62,2,62,5],[64,0,64,1],[64,2,64,5],[66,0,66,1],[66,2,66,5]]}
[{"$nulls":7},"SBD 3.1.4"]
[]
["PRICING SCHEDULE – FIRM PRICES"]
["(PURCHASES)"]
[]
["NOTE:","ONLY FIRM PRICES WILL BE ACCEPTED. NON-FIRM PRICES (INCLUDING PRICES SUBJECT TO RATES OF EXCHANGE VARIATIONS) WILL NOT BE CONSIDERED"]
[]
[null,"IN CASES WHERE DIFFERENT DELIVERY POINTS INFLUENCE THE PRICING, A SEPARATE PRICING SCHEDULE MUST BE SUBMITTED FOR EACH DELIVERY POINT "]
[]
[]
[]
["Name of bidder",null,{"$f":"' SBD3.1.1 , Year 1'!C12","v":0},{"$nulls":4},"Bid number: ",{"$f":"' SBD3.1.1 , Year 1'!I12","v":"DIRCO 08-2025/2026"}]
[]
[{"$f":"' SBD3.1.1 , Year 1'!A14","v":"Closing date 30/01/2026 Time 11h00 AM"}]
[]
[{"$f":"' SBD3.1.1 , Year 1'!A16","v":"OFFER TO BE VALID FOR 120 DAYS FROM THE CLOSING DATE OF BID."}]
[]
["Required by: The Department of International Relations and Cooperation (DIRCO) "]
[]
["1.     MANAGEMENT COMPANIES TO PROVIDE TRAVEL MANAGEMENT SERVICES FOR THE PERIOD OF 36 MONTHS"]
[]
["RFP NO:",{"$f":"' SBD3.1.1 , Year 1'!I12","v":"DIRCO 08-2025/2026"}]
["RFP NAME:","THE PROVISION OF TRAVEL MANAGEMENT SERVICES FOR A PERIOD OF 36 MONTHS"]
["BIDDER NAME",{"$f":"' SBD3.1.1 , Year 1'!D28","v":0}]
[]
["Price Declaration"]
["Dear Sir/Madam,\n\nHaving 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 DIRCO at the following total amounts (including VAT)"]
[]
[]
["Template 1 - 3: Transaction Fee (Off-Site)"]
[null,null,{"$f":"'SBD3.1.3 Year 3'!F31","v":"TRADITIONAL BOOKINGS (A)"},null,{"$f":"'SBD3.1.3 Year 3'!H31","v":"ONLINE BOOKING(B)"},null,"CONFERENCE FEE (C) ",null,"GRAND TOTAL\n(A+B+C)"]
["Period (Years)","SBD","Grand Total (incl. VAT)",null,"Grand Total (incl. VAT)",null,"Grand Total (incl. VAT)",null,"Grand Total (incl. VAT)"]
["Year 1","SBD 3.1.1",{"$f":"' SBD3.1.1 , Year 1'!G74","v":{"v":0,"d":"R0.00"}},null,{"$f":"' SBD3.1.1 , Year 1'!G75","v":{"v":0,"d":"R0.00"}},null,{"$f":"' SBD3.1.1 , Year 1'!G76","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(C33:H33)","v":{"v":0,"d":"R0.00"}}]
["Year 2","SBD 3.1.2",{"$f":"'SBD3.1.2 Year 2 '!G74","v":{"v":0,"d":"R0.00"}},null,{"$f":"'SBD3.1.2 Year 2 '!G75","v":{"v":0,"d":"R0.00"}},null,{"$f":"'SBD3.1.2 Year 2 '!G76","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(C34:H34)","v":{"v":0,"d":"R0.00"}}]
["Year 3","SBD 3.1.3",{"$f":"'SBD3.1.3 Year 3'!G74","v":{"v":0,"d":"R0.00"}},null,{"$f":"'SBD3.1.3 Year 3'!G75","v":{"v":0,"d":"R0.00"}},null,{"$f":"'SBD3.1.3 Year 3'!G76","v":{"v":0,"d":"R0.00"}},null,{"v":0,"d":"R0.00"}]
["Total Bid price (all inclusive)","(incl. VAT) ",{"$f":"SUM(C33:D35)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(E33:F35)","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(G33:H35)","v":{"v":0,"d":"R0.00"}},null,{"v":0,"d":"R0.00"}]
[{"$nulls":6},"In words:"]
[]
[]
["In case the Department decide to extend the contract for a period of up to one (1) year. The service provider must indicate the percentage adjustment for year 4"]
["Percentage: "]
[]
["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 DIRCO"]
[]
["We understand that DIRCO 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."]
[]
[" Note: These figures are projections based on the current trends and they may change during the tenure of the contract. The figures are meant for illustration purposes to assist the Bidder(s) to prepare their proposal."]
[]
["The prices will be used as indicative prices for purposes of comparison, the final award price will be based on the usage of the contract."]
[]
["Signature",{"$nulls":5},"Date  (YYYY-MM-DD)"]
[]
["Printe Name"]
[]
["Designation"]
[]
["FOR AND ON BEHALF OF: COMPANY NAME"]
[]
["Land line number"]
[]
["Fax number"]
[]
["Mobile number"]
[]
["Email"]