{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["COVER SHEET","1. TRANSACTION OFFSITE VAT ","2. TRANSACTION OFFSITE  NON VAT"],"not_rendered":{"images":1,"defined_names":33},"read":"whole","date_system":"1900"}

{"sheet":"COVER SHEET","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"merged":[[1,9,1,11],[13,0,13,12],[16,4,16,11],[18,4,18,11],[20,4,20,11],[23,0,23,12],[25,0,25,12],[26,0,26,12],[27,0,27,12],[28,0,28,12],[29,0,29,12],[30,0,30,12],[31,0,31,12],[32,0,32,12],[33,0,33,12],[34,0,34,12],[35,0,35,12],[36,0,36,12],[37,0,37,12],[38,0,38,12],[39,0,39,12],[40,0,40,12],[41,0,41,12],[42,0,42,12],[43,0,43,12],[44,0,44,12],[45,0,45,12],[46,0,46,12]]}
[]
[{"$nulls":9},"ANNEXURE A3"]
{"$rows_empty":11}
["PRICING SUBMISSION"]
[]
[]
["RFP NO:",{"$nulls":3},"PUDP 793"]
[]
["RFP NAME:",{"$nulls":3},"THE PROVISION OF TRAVEL MANAGEMENT SERVICES FOR A PERIOD OF 36 MONTHS"]
[]
["BIDDER NAME",{"$nulls":3},"<NAME OF BIDDER TO BE FILLED IN HERE>"]
[]
[]
["PRICE INSTRUCTIONS"]
[]
["1.  STRUCTURE OF THE TENDER"]
["This spreadsheet for RFP/BID PUDP 793 contains the financial response templates for the bid. The bid pricing submission instructions in this document must be read in conjunction with instructions or notes embedded in the various tabs of spreadsheet (Pricing Schedule)."]
[]
["2.  GENERAL INSTRUCTIONS FOR COMPLETING THE PRICING SCHEDULE TEMPLATES"]
["2.1  Tender submission format"]
["2.1.1 Bidders must submit  a paper copy and an electronic copy of the Pricing Schedule. In the event of a discrepancy, the\n         paper copy will prevail."]
["2.1.2 Bidders must sign all paper copies of their Pricing Schedule."]
["2.1.3 Bidders must complete and submit the templates attached ,which is transactional fee model offsite"]
["2.1.4 Bidders must reference RFP/BID main document section 15.2 for current travel volumes."]
["2.2  Input spreadsheets"]
["2.2.1 The Pricing Schedule templates are contained within the one (1) Excel Workbook"]
["2.2.2 Bidders must not  make any changes to the spreadsheets or change the formatting of the Pricing Schedule."]
["2.2.3 Cells are formatted to automatically indicate South African Rands, ordinary text fields and percentages (%) where \n         applicable."]
["2.2.4 Input cells FOR BIDDERS are highlighted in  GREEN. The Bidder must complete all the relevant input cells for the bid. \n        No other cells must be changed in any way whatsoever."]
["2.2.4 Input cells FOR THE TENDERING INSTITUTION are highlighted in  ORANGE. The Tendering Institution must complete all the relevant input cells for the bid. No other cells must be changed in any way whatsoever."]
[]
[]
["2.3  Currency and VAT"]
["2.3.1 All Bidders’ pricing must be quoted in South African Rands (ZAR)."]
["2.3.3 The Pricing Schedule template is designed such that VAT (15% VAT) will be calculated on Bidders’ input pricing; therefore Bidders must complete the templates with unit prices excluding VAT."]

{"sheet":"1. TRANSACTION OFFSITE VAT ","index":1,"n_rows":52,"n_cols":5,"rows_kept":52,"merged":[[0,2,2,7],[3,2,3,7],[6,2,6,7],[7,2,7,7],[8,2,8,7],[10,3,10,4],[11,0,11,2],[11,3,11,8],[12,4,12,8],[13,4,13,8],[14,4,14,8],[15,4,15,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[35,4,35,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,0,46,3],[46,4,46,8],[48,0,48,1],[48,3,48,4],[49,3,49,8],[50,3,50,8],[51,3,51,8]]}
[null,null,"TEMPLATE 1: TRANSACTION FEE MODEL"]
[]
[]
[null,null,"OFF-SITE SERVICES VAT VENDORS"]
[]
[]
["RFP NO:",null,{"$f":"'COVER SHEET'!$E17","v":"PUDP 793"}]
["RFP NAME:",null,{"$f":"'COVER SHEET'!$E19","v":"THE PROVISION OF TRAVEL MANAGEMENT SERVICES FOR A PERIOD OF 36 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)"]
[1,"Air Travel – International",1,null,{"$f":"D14*1.15","v":0}]
[2,"Air Travel – Regional",1,null,{"$f":"D15*1.15","v":0}]
[3,"Air Travel – Domestic ",1,null,0]
[4,"Air Travel – International (Re-issue)",1,null,0]
[5,"Air Travel – Regional (Re-issue)",1,null,0]
[6,"Air Travel – Domestic (Re-issue)",1,null,0]
[7,"Refunds – Air Domestic",1,null,0]
[8,"Refunds – Air Regional",1,null,0]
[9,"Refunds – Air International",1,null,0]
[10,"Car Rental – Domestic",1,null,0]
[11,"Car Rental – Regional ",1,null,0]
[12,"Car Rental – International",1,null,0]
[13,"Transfers/Shuttle – Domestic",1,null,0]
[14,"Transfers/Shuttle – Regional",1,null,0]
[15,"Transfers/Shuttle – International",1,null,0]
[16,"Accommodation – Domestic",1,null,0]
[17,"Accommodation – Regional",1,null,0]
[18,"Accommodation – International",1,null,0]
[19,"Bus/Coach Bookings",1,null,0]
[20,"Train bookings – International",1,null,0]
[21,"Visa Assistance (Provision of documents and advice)",1,null,0]
[22,"Courier services for travel documentation (visa & passports)",1,null,0]
[23,"SMS Notifications",1,null,0]
[24,"Parking bookings",1,null,0]
[25,"Cancellations",1,null,0]
[26,"Changes to bookings",1,null,0]
[27,"After Hours Services",1,null,0]
[28,"Additional Ad-hoc Reports (per report)",1,null,0]
[29,"Customised Reports (per report)",1,null,0]
[30,"Travel Lodge card Reconciliation",1,null,0]
[31,"Debtors Account Reconciliation",1,null,0]
[32,"Billback Fee",1,null,0]
[null,"Total",null,null,{"$f":"SUM(E14:I45)","v":0}]
["PRICE THAT WILL BE USED FOR EVALUATION PURPOSES",{"$nulls":3},{"$f":"E46","v":0}]
[]
["1.2  CONFERENCE TRANSACTION AND MERCHANT FEE"]
["Item","Description","Percentage Fee","Comment"]
[1,"Conference Transaction Fee (as a % of the Total turnover of the event)"]
[2,"Merchant Fee (as a % of the card usage)"]

{"sheet":"2. TRANSACTION OFFSITE  NON VAT","index":2,"n_rows":52,"n_cols":5,"rows_kept":52,"merged":[[0,2,2,7],[3,2,3,7],[6,2,6,7],[7,2,7,7],[8,2,8,7],[10,3,10,4],[11,0,11,2],[11,3,11,8],[12,4,12,8],[13,4,13,8],[14,4,14,8],[15,4,15,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[35,4,35,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,0,46,3],[46,4,46,8],[48,0,48,1],[48,3,48,4],[49,3,49,8],[50,3,50,8],[51,3,51,8]]}
[null,null,"TEMPLATE 1: TRANSACTION FEE MODEL"]
[]
[]
[null,null,"OFF-SITE SERVICES NON VAT"]
[]
[]
["RFP NO:",null,{"$f":"'COVER SHEET'!$E17","v":"PUDP 793"}]
["RFP NAME:",null,{"$f":"'COVER SHEET'!$E19","v":"THE PROVISION OF TRAVEL MANAGEMENT SERVICES FOR A PERIOD OF 36 MONTHS"}]
["BIDDER NAME"]
[]
["1.1  TRANSACTION FEES"]
[{"$nulls":3},"TRADITIONAL BOOKINGS"]
["ITEM","Transaction Type","Estimated Volume","Unit Price\n(excl VAT)","Total Price\n(incl VAT)"]
[1,"Air Travel – International",1,null,{"$f":"D14*C14","v":0}]
[2,"Air Travel – Regional",1,null,{"$f":"D15*C15","v":0}]
[3,"Air Travel – Domestic ",1,null,0]
[4,"Air Travel – International (Re-issue)",1,null,0]
[5,"Air Travel – Regional (Re-issue)",1,null,0]
[6,"Air Travel – Domestic (Re-issue)",1,null,0]
[7,"Refunds – Air Domestic",1,null,0]
[8,"Refunds – Air Regional",1,null,0]
[9,"Refunds – Air International",1,null,0]
[10,"Car Rental – Domestic",1,null,0]
[11,"Car Rental – Regional ",1,null,0]
[12,"Car Rental – International",1,null,0]
[13,"Transfers/Shuttle – Domestic",1,null,0]
[14,"Transfers/Shuttle – Regional",1,null,0]
[15,"Transfers/Shuttle – International",1,null,0]
[16,"Accommodation – Domestic",1,null,0]
[17,"Accommodation – Regional",1,null,0]
[18,"Accommodation – International",1,null,0]
[19,"Bus/Coach Bookings",1,null,0]
[20,"Train bookings – International",1,null,0]
[21,"Visa Assistance (Provision of documents and advice)",1,null,0]
[22,"Courier services for travel documentation (visa & passports)",1,null,0]
[23,"SMS Notifications",1,null,0]
[24,"Parking bookings",1,null,0]
[25,"Cancellations",1,null,0]
[26,"Changes to bookings",1,null,0]
[27,"After Hours Services",1,null,0]
[28,"Additional Ad-hoc Reports (per report)",1,null,0]
[29,"Customised Reports (per report)",1,null,0]
[30,"Travel Lodge card Reconciliation",1,null,0]
[31,"Debtors Account Reconciliation",1,null,0]
[32,"Billback Fee",1,null,0]
[null,"Total",null,null,{"$f":"SUM(E14:I45)","v":0}]
["PRICE THAT WILL BE USED FOR EVALUATION PURPOSES",{"$nulls":3},{"$f":"E46","v":0}]
[]
["1.2  CONFERENCE TRANSACTION AND MERCHANT FEE"]
["Item","Description","Percentage Fee","Comment"]
[1,"Conference Transaction Fee (as a % of the Total turnover of the event)"]
[2,"Merchant Fee (as a % of the card usage)"]