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

{"sheet":"COVER SHEET","index":0,"n_rows":47,"n_cols":11,"rows_kept":47,"merged":[[1,10,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],[47,0,47,12],[48,0,48,12],[49,0,49,12]]}
[]
[{"$nulls":10},"ANNEXURE A3"]
{"$rows_empty":11}
["PRICING SUBMISSION"]
[]
[]
["RFP NO:",{"$nulls":3},"DMV/BID/01/2024/25"]
[]
["RFP NAME:",{"$nulls":3},"REQUEST FOR TENDER FOR APPOINTMENT OF TRAVEL MANAGEMENT COMPANY TO PROVIDE TRAVEL MANAGEMENT SERVICES TO THE DEPARTMENT OF MILITARY VETERANS FOR THE PERIOD OF 36 MONTHS (THREE YEARS)"]
[]
["BIDDER NAME"]
[]
[]
["PRICE INSTRUCTIONS"]
[]
["1.  STRUCTURE OF THE TENDER"]
["This spreadsheet for DMV/BID/01/2024/25 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 hard copy of the Pricing Schedule. "]
["2.1.2 Bidders must sign all paper copies of their Pricing Schedule."]
["2.1.3 Bidders must complete and submit transactional fee model -offsite"]
["2.1.4 Bidders must reference 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 spreadsheet ."]
["2.2.2 All worksheets in the electronic copy of the Pricing Schedule are password protected."]
["2.2.3 Bidders must not unprotect the spreadsheets and/or make any changes to the spreadsheets or change the formatting\n         of the Pricing Schedule."]
["2.2.4 Cells are formatted to automatically indicate South African Rands, ordinary text fields and percentages (%) where \n         applicable."]
["2.2.5 Input cells are highlighted in light green. The Bidder must complete all input cells for the bid. No other cells must be\n        changed in any way whatsoever."]
["2.2.6 The Bidders are required to input the following cells only:"]
[]
[]
["2.3  Currency and VAT"]
["2.3.1 Bidders’ proposed Pricing Schedules must be firm and not indicative."]
["2.3.2 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":"2. TRANSACTION FEE OFFSITE ","index":1,"n_rows":67,"n_cols":9,"rows_kept":67,"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],[49,0,49,2],[51,0,51,1],[51,3,51,4],[52,3,52,8],[53,3,53,8],[54,3,54,8],[56,0,56,1],[57,0,57,8],[59,3,59,5],[60,3,60,5],[61,3,61,5],[62,3,62,5],[63,3,63,5],[64,3,64,5],[65,3,65,5],[66,3,66,5]]}
[null,null,"TEMPLATE 2: TRANSACTION FEE MODEL"]
[]
[]
[null,null,"OFF-SITE SERVICES"]
[]
[]
["RFP NO:",null,"DMV/BID/01/2024/25"]
["RFP NAME:",null,"REQUEST FOR TENDER FOR APPOINTMENT OF TRAVEL MANAGEMENT COMPANY TO PROVIDE TRAVEL MANAGEMENT SERVICES TO THE DEPARTMENT OF MILITARY VETERANS FOR THE PERIOD OF 36 MONTHS (THREE YEARS)"]
["BIDDER NAME"]
[]
["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",140,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",285,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 ",11520,null,0,{"$f":"E16*C16","v":0},null,0,0]
[4,"Air Travel – International (Re-issue)",0,null,0,0,null,0,0]
[5,"Air Travel – Regional (Re-issue)",0,null,0,0,null,0,0]
[6,"Air Travel – Domestic (Re-issue)",0,null,0,0,null,0,0]
[7,"Refunds – Air Domestic",0,null,0,0,null,0,0]
[8,"Refunds – Air Regional",0,null,0,0,null,0,0]
[9,"Refunds – Air International",0,null,0,0,null,0,0]
[10,"Car Rental – Domestic",6483,null,0,0,null,0,0]
[11,"Car Rental – Regional ",285,null,0,0,null,0,0]
[12,"Car Rental – International",87,null,0,0,null,0,0]
[13,"Transfers/Shuttle – Domestic",5851,null,0,0,null,0,0]
[14,"Transfers/Shuttle – Regional",80,null,0,0,null,0,0]
[15,"Transfers/Shuttle – International",60,null,0,0,null,0,0]
[16,"Accommodation – Domestic",5184,null,0,0,null,0,0]
[17,"Accommodation – Regional",360,null,0,0,null,0,0]
[18,"Accommodation – International",140,null,0,0,null,0,0]
[19,"Bus/Coach Bookings",669,null,0,0,null,0,0]
[20,"Train bookings – International",0,null,0,0,null,0,0]
[21,"Visa Assistance \n(Provision of documents and advice)",0,null,0,0,null,0,0]
[22,"Courier services for travel documentation (visa & passports)",425,null,0,0,null,0,0]
[23,"SMS Notifications",0,null,0,0,null,0,0]
[24,"Cancellations",0,null,0,0,null,0,0]
[25,"Changes to bookings",0,null,0,0,null,0,0]
[26,"After Hours Services",618,null,0,0,null,0,0]
[27,"Additional Ad-hoc Reports (per report)",0,null,0,0,null,0,0]
[28,"Customised Reports (per report)",0,null,0,0,null,0,0]
[29,"Debtors Account Reconciliation",0,null,0,0,null,0,0]
[30,"Insurances",425,null,0,0,null,0,0]
[31,"Conferences/Events",225,null,0,0,null,0,0]
[32,"Foreign Exchange Orders(FOREX)",425,null,0,0,null,0,0]
[33,"Conferences Accommodation ",4200,null,0,0,null,0,0]
[34,"Conferences Bus/Railway/Ferry( To include 3 meals on route e.g Breakfast ,Lunch and Dinner)",933,null,0,0,null,0,0]
[35,"Parking (Including Airport Parking)",519,null,{"$f":"D48*1.15","v":0},0,null,0,0]
[null,"Total",{"$f":"SUM(C14:C48)","v":38914},null,null,{"$f":"SUM(F14:F48)","v":0},null,null,{"$f":"SUM(I14:I48)","v":0}]
["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)",null,"Percentage where Departmental officials source quotations and check the suitability of conference facilities and later request the bidder to confirm the booking and bill the Department (not exceeding 2,5%)"]
[2,"Conference Transaction Fee (as a % of the Total turnover of the event)",null,"Percentage where the bidder does everything for conference bookings"]
[]
["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,{"$f":"SUM(C61:C66)","v":{"v":1,"d":"100%"}}]

{"sheet":"Price Declaration ","index":2,"n_rows":60,"n_cols":8,"rows_kept":60,"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,3],[18,4,18,8],[19,0,19,1],[19,2,19,3],[19,4,19,6],[19,7,19,8],[20,0,20,8],[21,0,21,3],[21,4,21,8],[24,0,24,8],[25,0,25,3],[25,4,25,8],[26,0,26,1],[26,2,26,3],[26,4,26,6],[26,7,26,8],[27,0,27,8],[28,0,28,3],[28,4,28,8],[31,0,31,8],[32,0,32,3],[32,4,32,8],[33,0,33,1],[33,2,33,3],[33,4,33,6],[33,7,33,8],[34,0,34,8],[35,0,35,3],[35,4,35,8],[38,0,38,8],[39,0,39,3],[39,4,39,8],[40,0,40,1],[40,2,40,3],[40,4,40,6],[40,7,40,8],[41,0,41,8],[42,0,42,3],[42,4,42,8],[43,0,43,8],[44,0,44,8],[45,0,45,8],[47,0,47,8],[48,0,48,8],[49,0,49,8],[50,0,50,2],[50,4,50,8],[51,0,51,8],[52,0,52,8],[53,0,53,8],[54,0,54,8],[55,0,55,8],[56,0,56,8],[57,0,57,8],[58,0,58,8],[59,0,59,8],[60,0,60,8]]}
{"$rows_empty":7}
["RFP NO:",null,"DMV/BID/01/2024/25 "]
["RFP NAME:",null,"REQUEST FOR TENDER FOR APPOINTMENT OF TRAVEL MANAGEMENT COMPANY TO PROVIDE TRAVEL MANAGEMENT SERVICES TO THE DEPARTMENT OF MILITARY VETERANS FOR THE PERIOD OF 36 MONTHS (THREE YEARS)"]
["BIDDER NAME"]
[]
[]
["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 ON-SITE / OFF-SITE travel management service to the Department of Military Veterans at the following total amounts (including VAT)"]
[]
["Template 1: Transaction Fee (On-Site)"]
["TRADITIONAL BOOKING",{"$nulls":3},"ON-LINE BOOKING"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,"(incl. VAT)",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"(incl. VAT)"]
["In words:"]
[]
[]
[]
["Template 2: Transaction Fee (Off-Site)"]
["TRADITIONAL BOOKING",{"$nulls":3},"ON-LINE BOOKING"]
[{"$f":"'2. TRANSACTION FEE OFFSITE '!F49","v":0},null,"(incl. VAT)",null,{"$f":"'2. TRANSACTION FEE OFFSITE '!I49","v":0},null,null,"(incl. VAT)"]
["In words:"]
[]
[]
[]
["Template 3: Management Fee (On-Site)"]
["TRADITIONAL BOOKING",{"$nulls":3},"ON-LINE BOOKING"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,"(incl. VAT)",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"(incl. VAT)"]
["In words:"]
[]
[]
[]
["Template 4: Management Fee (Off-Site)"]
["TRADITIONAL BOOKING",{"$nulls":3},"ON-LINE BOOKING"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,"(incl. VAT)",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"(incl. VAT)"]
["In words:"]
[]
[]
["We undertake to hold this offer open for acceptance for a period of 90 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 Military Veterans"]
[]
[]
["We understand that Department of Military Veterans 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:…………………………………………."]