{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["COVER SHEET","1. TRANSACTION FEE OFFSITE ","2. MANAGEMENT FEE OFFSITE","Price Declaration "],"not_rendered":{"images":4,"defined_names":36},"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 B"]
{"$rows_empty":11}
["PRICING SUBMISSION"]
[]
[]
["BID NO:",{"$nulls":3},"CPSI0004/2023"]
[]
["BID 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 BID 0004/2017 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/are management fee model offsite and\n         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  \n        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 will be calculated on Bidders’ input pricing; therefore Bidders \n         must complete the templates with unit prices excluding VAT."]

{"sheet":"1. TRANSACTION FEE OFFSITE ","index":1,"n_rows":57,"n_cols":9,"rows_kept":57,"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,5],[11,6,11,8],[51,0,51,1],[52,0,52,3],[52,4,52,8],[54,0,54,1],[54,3,54,4],[55,3,55,8],[56,3,56,8]]}
[null,null,"ANNEXURE B - TEMPLATE 1: TRANSACTION FEE MODEL"]
[]
[]
[null,null,"OFF-SITE SERVICES"]
[]
[]
["BID NO:",null,{"$f":"'COVER SHEET'!$E17","v":"CPSI0004/2023"}]
["BID NAME:",null,{"$f":"'COVER SHEET'!$E19","v":"THE PROVISION OF TRAVEL MANAGEMENT SERVICES FOR A PERIOD OF 36 MONTHS"}]
["BIDDER NAME",null,{"$f":"'COVER SHEET'!$E21","v":"<NAME OF BIDDER TO BE FILLED IN HERE>"}]
[]
["1.1  TRANSACTION FEES"]
[{"$nulls":3},"TRADITIONAL BOOKINGS",null,null,"ONLINE BOOKINGS"]
["ITEM","Transaction Type","Estimated Volume","Unit Price\n(excl VAT)","Unit Price\n(incl VAT)","TOTAL Price\n(incl VAT)","Unit Price\n(excl VAT)","Unit Price\n(incl VAT)","TOTAL Price\n(incl VAT)"]
[1,"Air Travel – International",6,null,{"$f":"D14*1.15","v":0},{"$f":"E14*C14","v":0},null,{"$f":"G14*1.15","v":0},{"$f":"H14*C14","v":0}]
[2,"Air Travel – Regional",null,null,{"$f":"D15*1.15","v":0},{"$f":"E15*C15","v":0},null,{"$f":"G15*1.15","v":0},{"$f":"H15*C15","v":0}]
[3,"Air Travel – Domestic ",378,null,0,0,null,0,0]
[4,"Air Travel – International (Re-issue)",null,null,0,0,null,0,0]
[5,"Air Travel – Regional (Re-issue)",null,null,0,0,null,0,0]
[6,"Air Travel – Domestic (Re-issue)",null,null,0,0,null,0,0]
[7,"Refunds – Air Domestic",null,null,0,0,null,0,0]
[8,"Refunds – Air Regional",null,null,0,0,null,0,0]
[9,"Refunds – Air International",null,null,0,0,null,0,0]
[10,"Car Rental – Domestic",78,null,0,0,null,0,0]
[11,"Car Rental – Regional ",1,null,0,0,null,0,0]
[12,"Car Rental – International",1,null,0,0,null,0,0]
[13,"Transfers/Shuttle – Domestic",281,null,0,0,null,0,0]
[14,"Transfers/Shuttle – Regional",null,null,0,0,null,0,0]
[15,"Transfers/Shuttle – International",1,null,0,0,null,0,0]
[16,"Accommodation – Domestic",242,null,0,0,null,0,0]
[17,"Accommodation – Regional",null,null,0,0,null,0,0]
[18,"Accommodation – International",9,null,0,0,null,0,0]
[19,"Bus/Coach Bookings",null,null,0,0,null,0,0]
[20,"Train bookings – International",null,null,0,0,null,0,0]
[21,"Visa Assistance \n(Provision of documents and advice)",null,null,0,0,null,0,0]
[22,"Courier services for travel documentation (visa & passports)",null,null,0,0,null,0,0]
[23,"SMS Notifications",null,null,0,0,null,0,0]
[24,"Parking bookings",57,null,0,0,null,0,0]
[25,"Cancellations",null,null,0,0,null,0,0]
[26,"Changes to bookings",null,null,0,0,null,0,0]
[27,"After Hours Services",5,null,0,0,null,0,0]
[28,"Additional Ad-hoc Reports (per report)",null,null,0,0,null,0,0]
[29,"Customised Reports (per report)",null,null,0,0,null,0,0]
[30,"Travel Lodge card Reconciliation",null,null,0,0,null,0,0]
[31,"Debtors Account Reconciliation",null,null,0,0,null,0,0]
[32,"Other (Specify)",null,null,0,0,null,0,0]
[33,"Other (Specify)",null,null,0,0,null,0,0]
[34,"Other (Specify)",null,null,0,0,null,0,0]
[35,"Other (Specify)",null,null,0,0,null,0,0]
[36,"Other (Specify)",null,null,0,0,null,0,0]
[37,"Other (Specify)",null,null,0,0,null,0,0]
[null,"Total",{"$f":"SUM(C14:C50)","v":1059},null,null,{"$f":"SUM(F14:F50)","v":0},null,null,{"$f":"SUM(I14:I50)","v":0}]
["Percentage Split between Online Booking  and Traditional Booking",null,null,"Percentage Traditional",{"v":0.2,"d":"20.00%"},{"$f":"F51*E52","v":0},"Percentage Online",{"v":0.8,"d":"80.00%"},{"$f":"I51*H52","v":0}]
["PRICE THAT WILL BE USED FOR EVALUATION PURPOSES",{"$nulls":3},{"$f":"F52+I52","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":2,"n_rows":77,"n_cols":6,"rows_kept":77,"merged":[[0,3,2,5],[3,3,3,5],[6,3,6,5],[7,3,7,5],[8,3,8,5],[10,1,10,2],[10,3,10,4],[11,3,11,4],[13,1,13,3],[15,1,15,2],[42,1,42,3],[44,1,44,3],[45,1,45,2],[54,1,54,3],[56,1,56,3],[57,4,57,5],[58,1,58,3],[60,1,60,3],[61,1,61,3],[61,4,61,5],[62,1,62,3],[62,4,62,5],[63,1,63,3],[63,4,63,5],[66,5,72,5],[74,1,74,2],[75,4,75,5],[76,4,76,5]]}
[{"$nulls":3},"ANNEXURE B - TEMPLATE 2: MANAGEMENT FEE MODEL"]
[]
[]
[{"$nulls":3},"OFF-SITE SERVICES"]
[]
[]
[null,"BID NO:",null,{"$f":"'COVER SHEET'!$E17","v":"CPSI0004/2023"}]
[null,"BID NAME:",null,{"$f":"'COVER SHEET'!$E19","v":"THE PROVISION OF TRAVEL MANAGEMENT SERVICES FOR A PERIOD OF 36 MONTHS"}]
[null,"BIDDER NAME",null,{"$f":"'COVER SHEET'!$E21","v":"<NAME OF BIDDER TO BE FILLED IN HERE>"}]
[]
[null,"ESTIMATED TRANSACTION VOLUMES PER ANNUM *"]
[{"$nulls":3},"See Section 15.2 of the bid document"]
[null,"1.1  MANAGEMENT FEES"]
[{"$nulls":4},"TRADITIONAL BOOKINGS","ONLINE BOOKINGS"]
[null,"ITEM","Transaction Type",null,"Annual Cost\n(Excl VAT)","Annual Cost\n(Excl VAT)"]
[null,"Fixed Costs (Management Fees)",null,"Estimated #"]
[null,1,"Compensation"]
[null,null,"     Receptionist"]
[null,null,"     Senior Travel Consultants"]
[null,null,"     Intermediate Travel Consultants"]
[null,null,"     Junior Travel Consultants"]
[null,null,"     Travel Manager"]
[null,null,"     Finance Manager / Accountant"]
[null,null,"     Admin Back Office (Creditors/ Debtors /\n     Finance Processors"]
[null,null,"     Strategic Account Manager"]
[null,null,"     System Administrator"]
[null,2,"Standard Monthly Reports (3 Std Reports x 12 months)"]
[null,3,"Standard Weekly Reports (3 Weekly Report x 52 weeks)"]
[null,4,"* Communication (SMS, Email alerts, \nIndustry updates)"]
[null,5,"Marketing"]
[null,6,"Technology (Software Licences)"]
[null,7,"Computing / GDS Fees"]
[null,8,"Office Leasing (if applicable)"]
[null,9,"Utility bills (phone, broadband, electricity, etc."]
[null,10,"Assocciation membership fees"]
[null,11,"Banking Services (Interest, Merchant Fees, etc.)"]
[null,12,"Other (Specify)"]
[null,13,"Other (Specify)"]
[null,14,"Other (Specify)"]
[null,15,"Other (Specify)"]
[null,16,"Other (Specify)"]
[null,17,"Profit"]
[null,"Total Fixed Annual Cost (Excl VAT)",null,null,{"$f":"SUM(E17:E42)","v":0},{"$f":"SUM(F17:F42)","v":0}]
[]
[{"$nulls":4},"TRADITIONAL BOOKINGS","ONLINE BOOKINGS"]
[null,"Variable Costs ",null,"Estimated #","Annual Cost\n(Excl VAT)","Annual Cost\n(Excl VAT)"]
[null,1,"After-Hours (VIP/Executive Travel Consultant)\n(Estimated at 20 Calls per month",{"$f":"20*12","v":240}]
[null,2,"After-Hours Call Center / Contact Number(17h00 - 8h00 Weekdays; 24 hours weekends and public holidays)\n(Estimated at 50 Calls per month",{"$f":"50*12","v":600}]
[null,3,"Stationery (Estimated per annum)"]
[null,4,"Training & Recruitment (own Staff estimated per annum)"]
[null,5,"Other (Specify)"]
[null,6,"Other (Specify)"]
[null,7,"Other (Specify)"]
[null,8,"Other (Specify)"]
[null,"Total Variable Annual Cost (Excl VAT)",null,null,{"$f":"SUM(E47:E54)","v":0},{"$f":"SUM(F47:F54)","v":0}]
[]
[null,"TOTAL PER ANNUM (Excl VAT)",null,null,{"$f":"E43+E55","v":0},{"$f":"F43+F55","v":0}]
[]
[null,"Percentage Split between Online Booking  and Traditional Booking",null,null,{"v":0.2,"d":"20.00%"},{"v":0.8,"d":"80.00%"}]
[{"$nulls":4},"Percentage Traditional","Percentage Online"]
[null,"SPLIT GRAND TOTAL PER ANNUM (Excl VAT)",null,null,{"$f":"E57*E59","v":0},{"$f":"F57*F59","v":0}]
[null,"GRAND TOTAL PER ANNUM (Excl VAT)",null,null,{"$f":"E61+F61","v":0}]
[null,"GRAND TOTAL PER ANNUM (Incl VAT)  \n(PRICE THAT WILL BE USED FOR EVALUATION PURPOSES",null,null,{"$f":"E62*1.15","v":0}]
[null,"MONTHLY MANAGEMENT FEE (Incl VAT)",null,null,{"$f":"E63/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",null,{"$f":"D67*1.15","v":0},"These services will only be done on request from the Tendering Institution and will be invoiced accordingly.\n\nThese costs are ADDITIONAL to the monthly Management Fee.\n\nThese items will not be used for evaluation purposes."]
[null,2,"Visa Services",null,{"$f":"D68*1.15","v":0}]
[null,3,"Customised Reports (per report)",null,0]
[null,4,"Other (Specify)",null,0]
[null,5,"Other (Specify)",null,0]
[null,6,"Other (Specify)",null,0]
[null,7,"Other (Specify)",null,0]
[]
[null,"1.2  CONFERENCE TRANSACTION FEE"]
[null,"Item","Description","Percentage Fee","Comment"]
[null,1,"Conference Transaction Fee (as a % of the Total turnover of the event)"]

{"sheet":"Price Declaration ","index":3,"n_rows":42,"n_cols":5,"rows_kept":42,"merged":[[7,0,7,1],[7,2,7,8],[8,0,8,1],[8,2,8,8],[9,0,9,1],[9,2,9,8],[12,0,12,8],[15,0,15,8],[16,0,16,8],[17,0,17,8],[18,0,18,1],[18,2,18,3],[18,4,18,6],[18,7,18,8],[19,0,19,8],[20,0,20,8],[21,0,21,8],[22,0,22,1],[22,2,22,3],[22,4,22,6],[22,7,22,8],[23,0,23,8],[24,0,24,8],[25,0,25,8],[26,0,26,8],[27,0,27,8],[28,0,28,8],[29,0,29,8],[30,0,30,8],[31,0,31,8],[32,0,32,2],[32,4,32,8],[33,0,33,8],[34,0,34,8],[35,0,35,8],[36,0,36,8],[37,0,37,8],[38,0,38,8],[39,0,39,8],[40,0,40,8],[41,0,41,8],[42,0,42,8]]}
{"$rows_empty":7}
["BID NO:",null,{"$f":"'COVER SHEET'!$E$17","v":"CPSI0004/2023"}]
["BID NAME:",null,{"$f":"'COVER SHEET'!$E$19","v":"THE PROVISION OF TRAVEL MANAGEMENT SERVICES FOR A PERIOD OF 36 MONTHS"}]
["BIDDER NAME",null,{"$f":"'COVER SHEET'!$E$21","v":"<NAME OF BIDDER TO BE FILLED IN HERE>"}]
[]
[]
["Price Declaration"]
["Dear Sir/Madam,"]
[]
["Having read through and examined the Request For Proposal (BID) Document, the General Conditions, The Requirement and all other Annexures to the BID Document, we offer to provide OFF-SITE travel management service to the CPSI at the following total amounts (including VAT)"]
[]
["Template 1: Transaction Fee (Off-Site)"]
[{"$f":"'1. TRANSACTION FEE OFFSITE '!E53","v":0},null,"(incl. VAT)"]
["In words:"]
[]
["Template 2: Management Fee (Off-Site)"]
[{"$f":"'2. MANAGEMENT FEE OFFSITE'!E63","v":0},null,"(incl. VAT)"]
["In words:"]
[]
[]
["We undertake to hold this offer open for acceptance for a period of 120 days from the date of submission of offers. We further undertake that upon final acceptance of our offer, we will commence with the provision of service when required to do so by the CPSI"]
[]
["We understand that CPSI are not bound to accept the lowest or any offer and that we must bear all costs which we have incurred in connection with preparing and submitting this bid."]
[]
["We hereby undertake for the period during which this bid remains open for acceptance not to divulge to any persons, other than the persons to which the bid is submitted, any information relating to the submission of this bid or the details therein except where such is necessary for the submission of this bid."]
[]
["Signature",{"$nulls":3},"Date"]
["Print name of signatory: ……………………………………………………………………………. "]
["Designation: ………………………………………………………………………………………….  "]
[]
["FOR AND ON BEHALF OF: COMPANY NAME"]
[]
["Tel No: ………………………………………."]
["Fax No: ………………………………………."]
["Cell No: ………………………………………."]
["Email:…………………………………………."]