{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Instructions to PM-don't print","Instructions","B-summary","B1-Wages","B2-Back End"],"not_rendered":{"images":2,"external_links":2,"defined_names":6,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Instructions to PM-don't print","index":0,"n_rows":10,"n_cols":1,"rows_kept":10,"merged":[[7,0,7,9],[8,0,8,9],[9,0,9,9]]}
{"$rows_empty":7}
["INSTRUCTIONS FOR PROJECT MANAGERS - do not print as part of bid"]
["Complete Intructions, B and B2 - red only"]
["See comments on spreadsheet to assist compiling"]

{"sheet":"Instructions","index":1,"n_rows":40,"n_cols":3,"rows_kept":40,"merged":[[7,0,7,12],[8,2,8,12],[10,0,10,12],[11,0,11,12],[12,0,12,12],[13,0,13,12],[14,0,14,12],[15,0,15,12],[17,0,17,12],[18,0,18,12],[19,0,19,12],[20,0,20,12],[21,0,21,12],[22,0,22,12],[23,0,23,12],[24,0,24,12],[25,0,25,12],[26,0,26,12],[27,0,27,12],[28,0,28,12],[29,0,29,12]]}
{"$rows_empty":7}
["PRICE INSTRUCTIONS"]
["DOT/12/2026/CS",null,"TERMS OF REFERENCES FOR THE APPOINTMENT OF A SERVICE PROVIDER /CONSULTANT TO RENDER GUARDING SECURITY SERVICES FOR THE DEPARTMENT OF TRANSPORT FOR A PERIOD OF 36 MONTHS"]
[]
["1.  STRUCTURE OF THE TENDER"]
["This spreadsheet  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.        "]
["2.1.2 Bidders must complete B-Summary,  B1-Wages and  B2-Back End"]
["2.1.2 Bidders must sign all pages of their Pricing Schedule."]
["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 . \n        The Bidder must complete all the relevant input cells for the bid. "]
["2.2.5 Bidders may provide additional breakdown of costs"]
["2.3  Currency and VAT"]
["2.3.1 All Bidders’ pricing must be quoted in South African Rands (ZAR)."]
["2.3.2 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."]
["2.3.3 If a Bidder is not VAT registered, please indicate and delete the formulas for Spreadsheet B-Summary J35."]
[]
["2.4  Other"]
["2. Rates used are in terms of the Schedule to the Main Agreement of the National Bargaining Council for the Private Security Sector (NBCPSS)."]
["3. Illustrative pricing guide (NBCPSS disclaimer)."]
["4. Maternity benefits not included in pricing structure."]
["5. Relief Security Officer is a permanent employee."]
["6. Share of overheads includes inter alia: liability/other insurance, payroll/admin, control centre, transport costs, fixed infrastructure, registers, OHS compliance, management & supervision, statutory fees."]
["7. PSIRA fees revised annually from April of each year."]
[]
["Contract Duration (months):",36]
["VAT rate:",0.15]
["DOT HQ Guarding Requirement:","25 x Grade C and 3 x Grade B (single building)"]

{"sheet":"B-summary","index":2,"n_rows":43,"n_cols":11,"rows_kept":43,"merged":[[1,6,4,10],[6,1,6,2],[6,3,6,5],[6,6,6,8],[6,9,6,10],[7,6,7,8],[9,1,9,2],[9,3,9,10],[11,1,11,2],[11,3,11,10],[14,1,14,4],[14,8,14,10],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[20,1,20,10],[21,1,24,8],[21,9,24,10],[26,1,26,6],[32,1,33,10],[35,1,35,4],[35,6,37,10],[36,1,39,4],[39,6,39,10],[40,1,40,4],[40,6,40,10],[41,1,41,4],[42,1,42,4]]}
[]
[{"$nulls":6},"ANNEXURE B\nPricing Schedule"]
[]
[]
[]
[]
[null,"Bid ref. number:",null,{"$f":"Instructions!A9","v":"DOT/12/2026/CS"},null,null,"Expected project start date:",null,null,"2026-06-01"]
[{"$nulls":6},"Expected duration (Months)",null,null,36]
[]
[null,"Description of bid:",null,{"$f":"Instructions!C9","v":"TERMS OF REFERENCES FOR THE APPOINTMENT OF A SERVICE PROVIDER /CONSULTANT TO RENDER GUARDING SECURITY SERVICES FOR THE DEPARTMENT OF TRANSPORT FOR A PERIOD OF 36 MONTHS"}]
[]
[null,"Name of bidder:"]
[]
[{"$nulls":5},"Max","Score"]
[null,"PPPFA points allocation",{"$nulls":4},{"$f":"SUM(G16:G18)","v":0},null,"Indicative project time frames"]
[null,"% Black Ownership",{"$nulls":6},"Start","End","Duration"]
[null,"% Black Ownership: Women ",{"$nulls":8},"36 months"]
[null,"% Black Ownership: BDG"]
[null,"BDG Details:"]
[]
[null,"TOTAL BID PRICE  incl. VAT"]
[null,"1. Total price required to produce/deliver all goods/services included in the Tor.\n2. Please ensure that this price matches the price indicated on SBD 1.\n3. This price will be used for PPPFA comparison purposes.",{"$nulls":7},{"$f":"G31","v":{"v":0,"d":"R0.00"}}]
[]
[]
[]
[]
[null,"PART 1: COSTING OF SERVICES"]
[null,null,"Description","Total Cost Year 1","Total Cost Year 2","Total Cost Year 3","Total Cost for Project\n (3 years)"]
[null,1,"Total cost of guards’ wages (incl VAT)",{"$f":"'B1-Wages'!E12","v":{"v":0,"d":"R0.00"}},{"$f":"'B1-Wages'!G12","v":{"v":0,"d":"R0.00"}},{"$f":"'B1-Wages'!I12","v":{"v":0,"d":"R0.00"}},{"$f":"'B1-Wages'!J12","v":{"v":0,"d":"R0.00"}}]
[null,2,"Security equipment & back end support (incl VAT)",{"$f":"'B2-Back End'!D10","v":{"v":0,"d":"R0.00"}},{"$f":"'B2-Back End'!F10","v":{"v":0,"d":"R0.00"}},{"$f":"'B2-Back End'!H10","v":{"v":0,"d":"R0.00"}},{"$f":"'B2-Back End'!I10","v":{"v":0,"d":"R0.00"}}]
[null,null,"TOTAL FOR THE PROJECT (INCL VAT)",{"$nulls":3},{"$f":"SUM(G29:G30)","v":{"v":0,"d":"R0.00"}}]
[]
[null,"Bidders may only complete green cells.  Any changes to formulas in this spread sheet will invalidate the bid"]
[]
[]
[null,"Confirmation by bidder",{"$nulls":4},"Bidders must print and sign all worksheets (Summary and Annexures B1 to B2)"]
[null,"Signature"]
[]
[]
[{"$nulls":6},"Blue coloured cells to be completed by DOT"]
[null,"Name:",{"$nulls":4},"Green coloured cells to be completed by bidder"]
[null,"Designation:"]
[null,"Date:"]

{"sheet":"B1-Wages","index":3,"n_rows":15,"n_cols":10,"rows_kept":15,"merged":[[0,2,0,9],[2,0,2,9],[4,0,4,2],[4,3,4,4],[9,0,9,3],[10,0,10,3],[11,0,11,3],[13,0,13,2],[14,0,17,2]]}
[{"$f":"Instructions!A9","v":"DOT/12/2026/CS"},null,{"$f":"Instructions!C9","v":"TERMS OF REFERENCES FOR THE APPOINTMENT OF A SERVICE PROVIDER /CONSULTANT TO RENDER GUARDING SECURITY SERVICES FOR THE DEPARTMENT OF TRANSPORT FOR A PERIOD OF 36 MONTHS"}]
[]
["Annexure B1: GUARDS AND SUPERVISOR(S) WAGES "]
[]
[{"$f":"\"Bidder Name: \"&'[2]Bid Summary'!D12","v":"Bidder Name: "}]
[]
["Description","Grade","No. Required ","Monthly Cost per Person (excl VAT) – Year 1 ","Year 1 Total","Monthly Cost per Person (excl VAT) – Year 2 ","Year 2 Total","Monthly Cost per Person (excl VAT) – Year 3 ","Year 3 Total","Total Cost (3 years)"]
["Guards","C",25,null,{"$f":"C8*D8","v":{"v":0,"d":"R 0.00"}},null,{"$f":"C8*F8","v":{"v":0,"d":"R 0.00"}},null,{"$f":"C8*H8","v":{"v":0,"d":"R 0.00"}},{"$f":"E8+G8+I8","v":{"v":0,"d":"R 0.00"}}]
["Guards","B",3,null,{"$f":"C9*D9","v":{"v":0,"d":"R 0.00"}},null,{"$f":"C9*F9","v":{"v":0,"d":"R 0.00"}},null,{"$f":"C9*H9","v":{"v":0,"d":"R 0.00"}},{"$f":"E9+G9+I9","v":{"v":0,"d":"R 0.00"}}]
["SUBTOTAL COST (EXCL VAT)",{"$nulls":3},{"$f":"SUM(E8:E9)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"SUM(G8:G9)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"SUM(I8:I9)","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(J8:J9)","v":{"v":0,"d":"R 0.00"}}]
["VAT @ 15%",{"$nulls":3},{"$f":"E10*VAT_Rate","v":{"v":0,"d":"R 0.00"}},null,{"$f":"G10*VAT_Rate","v":{"v":0,"d":"R 0.00"}},null,{"$f":"I10*VAT_Rate","v":{"v":0,"d":"R 0.00"}},{"$f":"J10*VAT_Rate","v":{"v":0,"d":"R 0.00"}}]
["TOTAL COST INCLUDING VAT",{"$nulls":3},{"$f":"E10+E11","v":{"v":0,"d":"R 0.00"}},null,{"$f":"G10+G11","v":{"v":0,"d":"R 0.00"}},null,{"$f":"I10+I11","v":{"v":0,"d":"R 0.00"}},{"$f":"J10+J11","v":{"v":0,"d":"R 0.00"}}]
[]
["Bidder signature"]
["Signature"]

{"sheet":"B2-Back End","index":4,"n_rows":13,"n_cols":9,"rows_kept":13,"merged":[[0,1,0,9],[2,0,2,9],[3,0,3,7],[3,8,3,9],[12,0,15,0]]}
[{"$f":"Instructions!A9","v":"DOT/12/2026/CS"},{"$f":"Instructions!C9","v":"TERMS OF REFERENCES FOR THE APPOINTMENT OF A SERVICE PROVIDER /CONSULTANT TO RENDER GUARDING SECURITY SERVICES FOR THE DEPARTMENT OF TRANSPORT FOR A PERIOD OF 36 MONTHS"}]
[]
["Annexure B2: SECURITY EQUIPMENT AND MACHINERY, OTHER OPERATIONAL COSTS (BACK END SUPPORT)"]
[]
["Description","Contract Duration (months) ","All-inclusive Monthly Cost (excl VAT)\nYear 1 ","Year 1 Total","All-inclusive Monthly Cost (excl VAT)\nYear 2 ","Year 2 Total","All-inclusive Monthly Cost (excl VAT)\nYear 3 ","Year 3 Total","Total Cost (3 years)"]
["Equipment in line with the scope of work",{"$f":"Contract_Months","v":36},null,{"$f":"C6*B6","v":{"v":0,"d":"R 0.00"}},null,{"$f":"E6*B6","v":{"v":0,"d":"R 0.00"}},null,{"$f":"G6*B6","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(H6,F6,D6)","v":{"v":0,"d":"R 0.00"}}]
["Other (e.g. profit, operational costs, etc)",{"$f":"Contract_Months","v":36},null,{"$f":"C7*B7","v":{"v":0,"d":"R 0.00"}},null,{"$f":"E7*B7","v":{"v":0,"d":"R 0.00"}},null,{"$f":"G7*B7","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(H7,F7,D7)","v":{"v":0,"d":"R 0.00"}}]
["SUBTOTAL COST (EXCL VAT)",null,null,{"$f":"SUM(D6:D7)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"SUM(F6:F7)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"SUM(H6:H7)","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(I6:I7)","v":{"v":0,"d":"R 0.00"}}]
["VAT @ 15%",null,null,{"$f":"D8*VAT_Rate","v":{"v":0,"d":"R 0.00"}},null,{"$f":"F8*VAT_Rate","v":{"v":0,"d":"R 0.00"}},null,{"$f":"H8*VAT_Rate","v":{"v":0,"d":"R 0.00"}},{"$f":"I8*VAT_Rate","v":{"v":0,"d":"R 0.00"}}]
["TOTAL COST INCLUDING VAT",null,null,{"$f":"D8+D9","v":{"v":0,"d":"R 0.00"}},null,{"$f":"F8+F9","v":{"v":0,"d":"R 0.00"}},null,{"$f":"H8+H9","v":{"v":0,"d":"R 0.00"}},{"$f":"I8+I9","v":{"v":0,"d":"R 0.00"}}]
[]
["Bidder signature"]
["Signature"]