{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["1. TRANSACTION FEE OFFSITE "],"not_rendered":{"images":2,"defined_names":24},"read":"whole","date_system":"1900"}

{"sheet":"1. TRANSACTION FEE OFFSITE ","index":0,"n_rows":50,"n_cols":6,"rows_kept":50,"merged":[[0,2,2,5],[3,2,3,5],[6,2,6,5],[7,2,7,5],[9,3,9,4],[10,0,10,2],[10,3,10,5],[44,0,44,1],[45,0,45,3],[45,4,45,5],[47,0,47,1],[47,3,47,4],[48,3,48,5],[49,3,49,5]]}
[null,null,"PRICING SCHEDULE"]
[]
[]
[null,null,"OFF-SITE SERVICES"]
["DEPARTMENT OF HEALTH"]
[]
[null,null,"HEDPQ 0091/23/24: PROVISION OF TRAVEL MANAGEMENT SERVICES IN THE DEPARTMENT OF HEALTH FOR THE PERIOD OF SIX(6) MONTHS"]
["BIDDER NAME"]
[]
["1.1  TRANSACTION FEES"]
[{"$nulls":3},"TRADITIONAL 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",1,0,{"$f":"D13*1.15","v":0},{"$f":"E13*C13","v":0}]
[2,"Air Travel – Regional",1,0,{"$f":"D14*1.15","v":0},{"$f":"E14*C14","v":0}]
[3,"Air Travel – Domestic ",1,0,0,0]
[4,"Air Travel – International (Re-issue)",1,0,0,0]
[5,"Air Travel – Regional (Re-issue)",1,0,0,0]
[6,"Air Travel – Domestic (Re-issue)",1,0,0,0]
[7,"Refunds – Air Domestic",1,0,0,0]
[8,"Refunds – Air Regional",1,0,0,0]
[9,"Refunds – Air International",1,0,0,0]
[10,"Car Rental – Domestic",1,0,0,0]
[11,"Car Rental – Regional ",1,0,0,0]
[12,"Car Rental – International",1,0,0,0]
[13,"Transfers/Shuttle – Domestic",1,0,0,0]
[14,"Transfers/Shuttle – Regional",1,0,0,0]
[15,"Transfers/Shuttle – International",1,0,0,0]
[16,"Accommodation – Domestic",1,0,0,0]
[17,"Accommodation – Regional",1,0,0,0]
[18,"Accommodation – International",1,0,0,0]
[19,"Bus/Coach Bookings",1,0,0,0]
[20,"Train bookings – International",1,0,0,0]
[21,"Visa Assistance \n(Provision of documents and advice)",1,0,0,0]
[22,"Courier services for travel documentation (visa & passports)",1,0,0,0]
[23,"SMS Notifications",1,0,0,0]
[24,"Parking bookings",1,0,0,0]
[25,"Cancellations",1,0,0,0]
[26,"Changes to bookings",1,0,0,0]
[27,"After Hours Services",1,0,0,0]
[28,"Additional Ad-hoc Reports (per report)",1,0,0,0]
[29,"Customised Reports (per report)",1,0,0,0]
[30,"Travel Lodge card Reconciliation",1,0,0,0]
[31,"Debtors Account Reconciliation",1,0,0,0]
[null,"Total",{"$f":"SUM(C13:C43)","v":31},{"$f":"SUM(D13:D43)","v":0},{"$f":"D44*1.15","v":0},{"$f":"SUM(F13:F43)","v":0}]
["Percentage  for Traditional Booking",null,null,"Percentage Traditional",{"v":1,"d":"100.00%"},{"$f":"F44*E45","v":0}]
["PRICE THAT WILL BE USED FOR EVALUATION PURPOSES",{"$nulls":3},{"$f":"F45","v":0}]
[]
["1.2  CONFERENCE TRANSACTION FEE"]
["Item","Description","Percentage Fee","Comment"]
[1,"Conference Transaction Fee (as a % of the Total turnover of the event)"]