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

{"sheet":"2. TRANSACTION FEE OFFSITE ","index":0,"n_rows":40,"n_cols":6,"rows_kept":40,"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],[34,0,34,1],[35,0,35,3],[35,4,35,5],[37,0,37,1],[37,3,37,4],[38,3,38,5],[39,3,39,5]]}
[null,null,"TEMPLATE 2: TRANSACTION FEE MODEL"]
[]
[]
[null,null,"OFF-SITE SERVICES"]
[]
[]
["RFP NO:",null,"SCMU8-22/23-0034"]
["RFP NAME:",null,"TRAVEL MANAGEMENT SERVICES OF CHRIS HANI DISTRICT FOR A PERIOD OF  36 MONTHS WITH A PROBATION PERIOD OF 12 MONTHS"]
["BIDDER NAME"]
[]
["1.1  TRANSACTION FEES - (MANAGEMENT OR SERVICE FEE)"]
[{"$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 – Regional",null,null,{"$f":"D14*1.14","v":0},{"$f":"E14*C14","v":0}]
[2,"Air Travel – Domestic ",12,null,0,0]
[3,"Air Travel – International",2,null,0,0]
[4,"Air Travel – Regional (Re-issue)",null,null,0,0]
[5,"Air Travel – Domestic (Re-issue)",2,null,0,0]
[6,"Refunds – Air Domestic",3,null,0,0]
[7,"Refunds – Air Regional",null,null,0,0]
[8,"Car Rental – Domestic",12,null,0,0]
[10,"Transfers/Shuttle – Domestic",null,null,0,0]
[11,"Accommodation – Domestic",150,null,0,0]
[12,"Accommodation – Regional",null,null,0,0]
[13,"Accommodation – International",2,null,0,0]
[14,"Courier services for travel documentation (visa & passports)",null,null,0,0]
[15,"SMS Notifications",400,null,0,0]
[16,"Parking Bookings",null,null,0,0]
[17,"Cancellations",4,null,0,0]
[18,"Changes to bookings",15,null,0,0]
[19,"After Hours Services",45,null,0,{"$f":"E31*C31","v":0}]
[21,"Shuttle Services",0,null,0,0]
[22,"Visa & Passports",2,null,0,0]
[null,"Total",{"$f":"SUM(C14:C33)","v":649},null,null,{"$f":"SUM(F14:F33)","v":0}]
["Percentage is on Traditional Booking",null,null,"Percentage Traditional",{"v":1,"d":"100.00%"},{"$f":"F34*E35","v":0}]
["PRICE THAT WILL BE USED FOR EVALUATION PURPOSES",{"$nulls":3},{"$f":"F35","v":0}]
[]
["1.2  CONFERENCE TRANSACTION FEE"]
["Item","Description","Percentage Fee","Comment"]
[1,"Conference Transaction Fee "]