{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":72,"n_cols":9,"rows_kept":72,"merged":[[0,2,2,7],[3,2,3,7],[6,0,6,1],[6,2,6,7],[7,0,7,1],[7,2,7,7],[8,0,8,1],[8,2,8,7],[10,0,10,1],[10,3,10,4],[11,0,11,2],[11,3,11,5],[11,6,11,8],[12,0,13,0],[12,1,13,1],[12,2,13,2],[34,0,35,0],[34,2,35,2],[34,3,35,3],[34,4,35,4],[34,5,35,5],[34,6,35,6],[34,7,35,7],[34,8,35,8],[36,0,37,0],[36,1,37,1],[36,3,37,3],[36,4,37,4],[36,5,37,5],[36,6,37,6],[36,7,37,7],[36,8,37,8],[54,0,54,2],[56,0,56,1],[56,3,56,4],[57,3,57,8],[58,3,58,8],[61,0,61,1],[62,0,62,8],[64,3,64,5],[65,3,65,5],[66,3,66,5],[67,3,67,5],[68,3,68,5],[69,3,69,5],[70,3,70,5],[71,3,71,5]]}
[null,null,"TEMPLATE 1: TRANSACTION FEE MODEL"]
[]
[]
[null,null,"OFF-SITE SERVICES"]
[]
[]
["RFP NO:",null,"BID NO: 02/2024/25"]
["RFP NAME:",null,"THE PROVISION OF TRAVEL MANAGEMENT SERVICES FOR A PERIOD OF 36 MONTHS"]
["BIDDER NAME"]
[]
["1.1  TRANSACTION FEES"]
[{"$nulls":3},"TRADITIONAL BOOKINGS",null,null,"ONLINE BOOKINGS"]
["ITEM","Transaction Type","Estimated Volume","Unit Price","Unit Price","TOTAL Price","Unit Price","Unit Price","TOTAL Price"]
[{"$nulls":3},"(excl VAT)","(incl VAT)","(incl VAT)","(excl VAT)","(incl VAT)","(incl VAT)"]
[1,"Air Travel – International",22,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[2,"Air Travel – Regional",22,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[3,"Air Travel – Domestic ",498,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[4,"Air Travel – International (Re-issue)",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[5,"Air Travel – Regional (Re-issue)",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[6,"Air Travel – Domestic (Re-issue)",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[7,"Refunds – Air Domestic",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[8,"Refunds – Air Regional",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[9,"Refunds – Air International",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[10,"Car Rental – Domestic",141,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[11,"Car Rental – Regional ",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[12,"Car Rental – International",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[13,"Transfers/Shuttle – Domestic",99,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[14,"Transfers/Shuttle – Regional",97,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[15,"Transfers/Shuttle – International",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[16,"Accommodation – Domestic",588,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[17,"Accommodation – Regional",11,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[18,"Accommodation – International",11,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[19,"Bus/Coach Bookings",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[20,"Train bookings – International",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[21,"Visa Assistance",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[null,"(Provision of documents and advice)"]
[22,"Courier services for travel documentation (visa & passports)",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[null,null,0]
[23,"SMS Notifications",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[24,"Parking bookings",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[25,"Cancellations",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[26,"Changes to bookings",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[27,"After Hours Services",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[28,"Additional Ad-hoc Reports (per report)",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[29,"Customised Reports (per report)",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[30,"Travel Lodge card Reconciliation",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[31,"Debtors Account Reconciliation",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[32,"Other (Specify) Insurance",22,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[33,"Other (Specify)Conferences/Events",25,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[34,"Other (Specify)",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[35,"Other (Specify)",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[36,"Other (Specify)",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[37,"Other (Specify)",0,null," R                -   "," R                         -   ",null," R              -   "," R                         -   "]
[null,"Total",948,null,null," R                         -   ",null,null," R                         -   "]
["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)"]
[]
[]
["1.3  COST ELEMENT BREAKDOWN"]
["This cost breakdown will be used for price adjustment purposes.  The formula for price adjustment is explained on the CPA tab."]
[]
["Item","Cost Element","Percentage weighted contribution","Index "]
[1,"Compensation",{"v":0.5,"d":"50%"}]
[2,"Administration cost",{"v":0.1,"d":"10%"}]
[3,"Overheads",{"v":0.2,"d":"20%"}]
[4,"Interest on Overdraft",{"v":0.1,"d":"10%"}]
[5,"Other (Specify)",{"v":0.05,"d":"5%"}]
[6,"Other (Specify)",{"v":0.05,"d":"5%"}]
[null,null,{"v":1,"d":"100%"}]