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

{"sheet":"1. TRANSACTION FEE OFFSITE ","index":0,"n_rows":51,"n_cols":6,"rows_kept":51,"merged":[[0,2,2,5],[3,2,3,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[10,3,10,4],[11,0,11,2],[11,3,11,5],[45,0,45,1],[46,0,46,3],[46,4,46,5],[48,0,48,1],[48,3,48,4],[49,3,49,5],[50,3,50,5]]}
[null,null,"PRICING SCHEDULE"]
[]
[]
[null,null,"OFF-SITE SERVICES"]
["DEPARTMENT OF HEALTH"]
[]
[]
[null,null,"HEDP 021/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":"D14*1.15","v":0},{"$f":"E14*C14","v":0}]
[2,"Air Travel – Regional",1,0,{"$f":"D15*1.15","v":0},{"$f":"E15*C15","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(C14:C44)","v":31},{"$f":"SUM(D14:D44)","v":0},0,{"$f":"SUM(F14:F44)","v":0}]
["Percentage  for Traditional Booking",null,null,"Percentage Traditional",{"v":1,"d":"100.00%"},{"$f":"F45*E46","v":0}]
["PRICE THAT WILL BE USED FOR EVALUATION PURPOSES",{"$nulls":3},{"$f":"F46","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)"]

{"sheet":"2. MANAGEMENT FEE OFFSITE","index":1,"n_rows":68,"n_cols":5,"rows_kept":68,"merged":[[0,3,2,5],[3,3,3,5],[6,3,6,5],[7,3,7,5],[8,3,8,5],[14,3,14,4],[16,1,16,3],[18,1,18,2],[40,1,40,3],[42,1,42,3],[43,1,43,2],[48,1,48,3],[50,1,50,3],[52,1,52,3],[54,1,54,3],[55,1,55,3],[56,1,56,3],[57,1,57,3],[63,1,63,3],[65,1,65,2]]}
[{"$nulls":3},"PRICING SCHEDULE"]
[]
[]
[{"$nulls":3},"OFF-SITE SERVICES"]
[null,"DEPARTMENT OF HEALTH"]
[]
[]
[{"$nulls":3},"HEDP 021/23/24: PROVISION OF TRAVEL MANAGEMENT SERVICES IN THE DEPARTMENT OF HEALTH FOR THE PERIOD OF THIRTY-SIX (36) MONTHS"]
[null,"BIDDER NAME"]
[]
[]
[null,"HEDP 021/23/24: PROVISION OF TRAVEL MANAGEMENT SERVICES IN THE LIMPOPO DEPARTMENT"]
[null,"OF HEALTH FOR A PERIOD OF THIRTY-SIX (36) MONTHS"]
[]
[]
[null,"1.1  MANAGEMENT FEES"]
[{"$nulls":4},"TRADITIONAL BOOKINGS"]
[null,"ITEM","Transaction Type",null,"Annual Cost\n(Excl VAT)"]
[null,"Fixed Costs (Management Fees)",null,"Estimated #"]
[null,1,"Compensation",null,0]
[null,null,"     Receptionist",null,0]
[null,null,"     Senior Travel Consultants",null,0]
[null,null,"     Intermediate Travel Consultants",null,0]
[null,null,"     Junior Travel Consultants",null,0]
[null,null,"     Travel Manager",null,0]
[null,null,"     Finance Manager / Accountant",null,0]
[null,null,"     Admin Back Office (Creditors/ Debtors /\n     Finance Processors",null,0]
[null,null,"     Strategic Account Manager",null,0]
[null,null,"     System Administrator",null,0]
[null,2,"Standard Monthly Reports (3 Std Reports x 12 months)",null,0]
[null,3,"Standard Weekly Reports (3 Weekly Report x 52 weeks)",null,0]
[null,4,"* Communication (SMS, Email alerts, \nIndustry updates)",null,0]
[null,5,"Marketing",null,0]
[null,6,"Technology (Software Licences)",null,0]
[null,7,"Computing / GDS Fees",null,0]
[null,8,"Office Leasing (if applicable)",null,0]
[null,9,"Utility bills (phone, broadband, electricity, etc.",null,0]
[null,10,"Assocciation membership fees",null,0]
[null,11,"Banking Services (Interest, Merchant Fees, etc.)",null,0]
[]
[null,"Total Fixed Annual Cost (Excl VAT)",null,null,{"$f":"SUM(E20:E40)","v":0}]
[]
[{"$nulls":4},"TRADITIONAL BOOKINGS"]
[null,"Variable Costs ",null,"Estimated #","Annual Cost\n(Excl VAT)"]
[null,1,"After-Hours (VIP/Executive Travel Consultant)\n(Estimated at 20 Calls per month",1,0]
[null,2,"After-Hours Call Center / Contact Number(17h00 - 8h00 Weekdays; 24 hours weekends and public holidays)\n(Estimated at 20 Calls per month",1,0]
[null,3,"Stationery (Estimated per annum)",1,0]
[null,4,"Training & Recruitment (own Staff estimated per annum)",1,0]
[null,"Total Variable Annual Cost (Excl VAT)",null,null,{"$f":"SUM(E45:E48)","v":0}]
[]
[null,"TOTAL PER ANNUM (Excl VAT)",null,null,{"$f":"E41+E49","v":0}]
[]
[null,"Traditional Booking",null,null,{"v":1,"d":"100.00%"}]
[{"$nulls":4},"Percentage Traditional"]
[null,"GRAND TOTAL PER ANNUM (Excl VAT)(%)",null,null,{"$f":"E51*E53","v":0}]
[null,"GRAND TOTAL PER ANNUM (Excl VAT)",null,null,{"$f":"E55+E55","v":0}]
[null,"GRAND TOTAL PER ANNUM (Incl VAT)  \n(PRICE THAT WILL BE USED FOR EVALUATION PURPOSES",null,null,{"$f":"E56*1.15","v":0}]
[null,"MONTHLY MANAGEMENT FEE (Incl VAT)",null,null,{"$f":"E57/12","v":0}]
[]
[null,null,"Cost of Additional items (per incident)","Unit Price\n(excl VAT)","Unit Price\n(incl VAT)"]
[null,1,"Courier Services",0,{"$f":"D61*1.15","v":0}]
[null,2,"Visa Services",0,{"$f":"D62*1.15","v":0}]
[null,3,"Customised Reports (per report)",0,0]
[{"$nulls":4},{"$f":"E61:E63","v":0}]
[{"$nulls":4},0]
[null,"1.2  CONFERENCE TRANSACTION FEE",null,null,0]
[null,"Item","Description","Percentage Fee","Comment"]
[null,1,"Conference Transaction Fee (as a % of the Total turnover of the event)"]