{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["COVER SHEET","2. TRANSACTION FEE OFFSITE E.G.","Price Declaration "],"not_rendered":{"images":2,"defined_names":26},"read":"whole","date_system":"1900"}

{"sheet":"COVER SHEET","index":0,"n_rows":46,"n_cols":10,"rows_kept":46,"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],[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],[47,0,47,12]]}
[]
[{"$nulls":9},"ANNEXURE A2"]
{"$rows_empty":11}
["PRICING SUBMISSION"]
[]
[]
["RFP NO:",{"$nulls":3},"DEPARTMENT OF SPORT, ARTS AND CULTURE"]
[]
["RFP NAME:",{"$nulls":3},"APPOINTMENT OF FIVE (5) TRAVEL MANAGEMENT COMPANIES TO PROVIDE TRAVEL, ACCOMMODATION AND RELATED SERVICES TO THE DEPARTMENT FOR A PERIOD OF 36 MONTHS"]
[]
["BIDDER NAME"]
[]
[]
["PRICE INSTRUCTIONS"]
[]
["1.  STRUCTURE OF THE TENDER"]
["This spreadsheet for BID: DSAC-001-2023 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 of the Pricing Schedule.  It is advisable that the bidder completes the pricing schedule"]
["electronically and print it out once completed, and submit as part of the bid proposal."]
["2.1.2 Bidders must sign all paper copies of their Pricing Schedule."]
["2.1.3 Bidders must complete and submit the template attached ,which is transactional fee model offsite."]
["2.1.4 Bidders must reference RFP/BID main document section 14.(b) 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 including VAT."]

{"sheet":"2. TRANSACTION FEE OFFSITE E.G.","index":1,"n_rows":71,"n_cols":10,"rows_kept":71,"merged":[[0,2,2,8],[3,2,3,8],[6,2,6,8],[7,2,7,8],[8,2,8,8],[15,0,15,2],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,16,9],[59,0,59,2],[59,3,59,9],[61,0,61,1],[62,3,62,9],[63,3,63,9]]}
[null,null,"ANNEXURE A3: TRANSACTION FEE MODEL"]
[]
[]
[null,null,"OFF-SITE SERVICES"]
[]
[]
["RFP NO:",null,{"$f":"'COVER SHEET'!$E17","v":"DEPARTMENT OF SPORT, ARTS AND CULTURE"}]
["RFP NAME:",null,{"$f":"'COVER SHEET'!$E19","v":"APPOINTMENT OF FIVE (5) TRAVEL MANAGEMENT COMPANIES TO PROVIDE TRAVEL, ACCOMMODATION AND RELATED SERVICES TO THE DEPARTMENT FOR A PERIOD OF 36 MONTHS"}]
["BIDDER NAME",null,{"$f":"'COVER SHEET'!$E21","v":0}]
["The bidders will be evaluated according to pricing and specific goals."]
["Bidders must indicate the pricing for Year One (1).  The excel spreadsheet has been developed for automatically calculate Year 2, Year 3 and the Total Pricing for the Three (3) Years."]
["Consumer Price Index (CPI) for Year Two (2) is calculated at 4.45% and 4.48% for Year Three (3).  It must be noted that if the Current CPI for Year 2 and Year 3 is less/lower than the percentages"]
["used as part of the bidding process, the lowest CPI for that specific year will be the determining factor."]
["It remains the responsibility of the bidder to ensure that the calculations are correct when making use of this template."]
["The Department of Sport, Arts and Culture will not take responsibility for incorrect calculations and only provided the template to make it easier for the bidders to calculate their final price."]
[{"$nulls":3},"Transaction fee 2023/2024                (Year 1) (Incl. VAT)",null,"Transaction fee  2024/2025                Year 2 (Incl. VAT)",null,"Transaction fee 2025/2026                 Year 3 (Incl. VAT)",null,"Total Price for Three (3) Years (Including VAT)"]
["ITEM","Transaction Type","Estimated Number of Transactions Per Year","Unit Price\n(incl VAT)","TOTAL Price\n(incl VAT)","Unit Price\n(incl VAT)","TOTAL Price\n(incl VAT)","Unit Price\n(incl VAT)","TOTAL Price\n(incl VAT)"]
[1,"Air Travel – International",15,0,{"$f":"D18*C18","v":0},{"$f":"(D18*4.45%)+D18","v":0},{"$f":"F18*C18","v":0},{"$f":"(F18*4.48%)+F18","v":0},{"$f":"H18*C18","v":0},{"$f":"(E18+G18+I18)","v":0}]
[2,"Air Travel – Regional",20,0,{"$f":"D19*C19","v":0},{"$f":"(D19*4.45%)+D19","v":0},{"$f":"F19*C19","v":0},{"$f":"(F19*4.48%)+F19","v":0},{"$f":"H19*C19","v":0},{"$f":"(E19+G19+I19)","v":0}]
[3,"Air Travel – Domestic ",295,0,{"$f":"D20*C20","v":0},{"$f":"(D20*4.45%)+D20","v":0},{"$f":"F20*C20","v":0},{"$f":"(F20*4.48%)+F20","v":0},{"$f":"H20*C20","v":0},{"$f":"(E20+G20+I20)","v":0}]
[4,"Air Travel – International (Re-issue)",5,0,0,0,0,0,0,0]
[5,"Air Travel – Regional (Re-issue)",5,0,0,0,0,0,0,0]
[6,"Air Travel – Domestic (Re-issue)",5,0,0,0,0,0,0,0]
[7,"Air Travel – International (Refund)",5,0,0,0,0,0,0,0]
[8,"Air Travel – Regional (Refund)",5,0,0,0,0,0,0,0]
[9,"Air Travel – Domestic (Refund)",5,0,0,0,0,0,0,0]
[10,"Car Rental (With petrol card) All Types – International",5,0,0,0,0,0,0,0]
[11,"Car Rental (With petrol card) All Types – Regional",5,0,0,0,0,0,0,0]
[12,"Car Rental (With petrol card) All Types – Domestic",500,0,0,0,0,0,0,0]
[13,"Transfers (Point 2 Point) and Shuttle – International",5,0,0,0,0,0,0,0]
[14,"Transfers (Point 2 Point) and Shuttle – Regional",5,0,0,0,0,0,0,0]
[15,"Transfers (Point 2 Point) and Shuttle – Domestic",100,0,0,0,0,0,0,0]
[16,"Accommodation – International",10,0,0,0,0,0,0,0]
[17,"Accommodation – Regional",15,0,0,0,0,0,0,0]
[18,"Accommodation – Domestic",{"v":5000,"d":"5,000"},0,0,0,0,0,0,0]
[null,"Accommodation Group Bookings – Domestic        (101 - 200)",101,0,0,0,0,0,0,0]
[null,"Accommodation Group Bookings – Domestic        (201 - 400)",201,0,0,0,0,0,0,0]
[null,"Accommodation Group Bookings – Domestic        (401 and above)",401,0,0,0,0,0,0,0]
[19,"Train bookings – International",10,0,0,0,0,0,0,0]
[20,"Train bookings – Regional",15,0,0,0,0,0,0,0]
[21,"Train bookings – Domestic",75,0,0,0,0,0,0,0]
[22,"En-route catering / take aways (Full Service)",150,0,0,0,0,0,0,0]
[23,"Conferences/Events/Workshops Bookings (Full Service)",20,0,0,0,0,0,0,0]
[24,"Bus/Coach bookings (Government Officials & Non Employees)",15,0,0,0,0,0,0,0]
[25,"Taxis - From 15 Seater upwards",150,0,0,0,0,0,0,0]
[26,"Mini Busses - Semi Luxury 30 Seater upwards",50,0,0,0,0,0,0,0]
[27,"Mini Busses - Luxury 30 Seater upwards",50,0,0,0,0,0,0,0]
[28,"Busses - Semi Luxury 60 Seater upwards",15,0,0,0,0,0,0,0]
[29,"Busses - Luxury 70 Seater upwards",15,0,0,0,0,0,0,0]
[30,"Visa and Passports Assistance (Provision of documents and advice)",25,0,0,0,0,0,0,0]
[31,"Arranging air travel insurance (Domestic & International)",25,0,0,0,0,0,0,0]
[32,"Parking",50,0,0,0,0,0,0,0]
[33,"Travel vaccines and advice",25,0,0,0,0,0,0,0]
[34,"Cancellations (flights, accommodation, car hire, transfers and shuttle etc.)",105,0,0,0,0,0,0,0]
[35,"Changes to bookings (flights, accommodation, car hire, transfers and shuttle etc.)",100,0,0,0,0,0,0,0]
[36,"After Hours Services",250,0,0,0,0,0,0,0]
[37,"Ad-hoc Reports (per report)",12,0,0,0,0,0,0,0]
[38,"Monthly Management Reports",36,0,{"$f":"D58*C58","v":0},0,{"$f":"F58*C58","v":0},0,{"$f":"H58*C58","v":0},{"$f":"(E58+G58+I58)","v":0}]
[null,"Total",{"$f":"SUM(C18:C58)","v":{"v":7901,"d":"7,901"}},null,{"$f":"SUM(E18:E58)","v":0},null,{"$f":"SUM(G18:G58)","v":0},null,{"$f":"SUM(I18:I58)","v":0},{"$f":"SUM(J18:J58)","v":0}]
["PRICE THAT WILL BE USED FOR EVALUATION PURPOSES",null,null,{"$f":"J59","v":0}]
[]
["I, the undersigned (Full name and surname) "]
[]
["…………………………………………………………………………………………………………………………………..."]
[]
["Certify that the information as provided in the table above is true and correct (recalculated), and understood the above document in full."]
[]
[]
[]
["………………………………………..",null,null,"………………………….."]
["Signature",null,null,"Date"]

{"sheet":"Price Declaration ","index":2,"n_rows":42,"n_cols":5,"rows_kept":42,"merged":[[9,2,9,4],[10,0,10,1],[10,2,10,8],[11,0,11,1],[11,2,11,8],[12,0,12,1],[12,2,12,8],[15,0,15,8],[18,0,18,8],[19,0,19,8],[20,0,20,8],[21,0,21,1],[21,2,21,3],[21,4,21,6],[21,7,21,8],[22,0,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],[41,0,41,8],[42,0,42,8]]}
{"$rows_empty":9}
[null,null,"ANNEXURE A4"]
["RFP NO:",null,{"$f":"'COVER SHEET'!$E$17","v":"DEPARTMENT OF SPORT, ARTS AND CULTURE"}]
["RFP NAME:",null,{"$f":"'COVER SHEET'!$E$19","v":"APPOINTMENT OF FIVE (5) TRAVEL MANAGEMENT COMPANIES TO PROVIDE TRAVEL, ACCOMMODATION AND RELATED SERVICES TO THE DEPARTMENT FOR A PERIOD OF 36 MONTHS"}]
["BIDDER NAME",null,{"$f":"'2. TRANSACTION FEE OFFSITE E.G.'!C9:I9","v":0}]
[]
[]
["Price Declaration"]
["Dear Sir/Madam,"]
[]
["Having read through and examined the Request For Proposal (RFP) Document, the General Conditions, The Requirement and all other Annexures to the RFP Document, we offer to provide OFF-SITE travel management service to the Department of Sport, Arts and Culture at the following total amounts (including VAT)"]
[]
["Template 1: Transaction Fee (Off-Site)"]
[{"$f":"'2. TRANSACTION FEE OFFSITE E.G.'!J59","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 Department of Sport, Arts and Culture.  The Department reserves the right to enter into negotiations with the preferred bidders."]
[]
["We understand that Department of Sport, Arts and Culture 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: ………………………………………."]