{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["RIMS Pricing Schedule"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"RIMS Pricing Schedule","index":0,"n_rows":196,"n_cols":6,"rows_kept":196,"merged":[[1,2,1,4],[2,0,2,5],[4,3,4,4]]}
["SOUTH  AFRICAN  NATIONAL  ROADS  AGENCY  SOC  LTD"]
[null,"CONTRACT: ","X.002-218-2024/1 & X.002-220-2024/1"]
["CONSULTING ENGINEERING SERVICES FOR THE OPERATIONS AND MAINTENANCE OF INCIDENT MANAGEMENT SYSTEMS IN THE GAUTENG PROVINCE"]
[]
["C2.2","PRICING   SCHEDULE  (Incorporating SBD3)"]
[]
[]
["ITEM NO","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[3200,"ADMINISTRATION AND MONITORING OF THE PROJECT"]
[32.01,"Project Leader and Head Office"]
["(a)","Duties of the Project leader","Month",36,null,{"$f":"D12*E12","v":0}]
["(b)","Head Office overhead costs","Month",36,null,{"$f":"D13*E13","v":0}]
["(c)","Occupational Health and Safety Obligations and requirements","Month",36,null,0]
["(d)","Reporting","Month",36,null,0]
[]
[32.02,"Establishment of supervisory personnel and regional RIMS office"]
["(a)","Relocation cost of individual supervisory personnel: RIMS office"]
["i)","RIMS Co-ordinator","PC Sum",{"v":40000,"d":"R 40,000.00"},1,{"$f":"D19","v":{"v":40000,"d":"R 40,000.00"}}]
["ii)","RIMS Administrator/ Data capturer","PC Sum",{"v":10000,"d":"R 10,000.00"},1,{"$f":"D20","v":{"v":10000,"d":"R 10,000.00"}}]
["iii)","Handling cost i.t.o. item 32.02(a)(i) & (ii)","%",{"$f":"F20+F19","v":{"v":50000,"d":"R 50,000.00"}},null,{"$f":"D21*E21","v":0}]
[]
["(b)","Establishment of dedicated RIMS Provincial office including office furniture and equipment","Lump Sum",1,null,{"$f":"D23*E23","v":0}]
[]
[32.03,"Provision of Monitoring personnel and RIMS office "]
["(a)","RIMS Coordinator","Prov. Sum",{"v":4000000,"d":"R 4,000,000.00"},1,{"$f":"D26","v":{"v":4000000,"d":"R 4,000,000.00"}}]
["(b)","Handling cost i.t.o. item 32.03(a)","%",{"$f":"F26","v":{"v":4000000,"d":"R 4,000,000.00"}},null,{"$f":"D27*E27","v":0}]
["(c)","RIMS Administrator/ Data Capturer","Prov. Sum",{"v":2000000,"d":"R 2,000,000.00"},1,{"$f":"D28","v":{"v":2000000,"d":"R 2,000,000.00"}}]
["(d)","Handling cost i.t.o. item 32.03(c)","%",{"$f":"F28","v":{"v":2000000,"d":"R 2,000,000.00"}},null,{"$f":"D29*E29","v":0}]
["(e)","RIMS Coordinator Support/ (Assistance)","Prov. Sum",{"v":1000000,"d":"R 1,000,000.00"},1,{"$f":"D30","v":{"v":1000000,"d":"R 1,000,000.00"}}]
["(f)","Handling cost i.t.o. item 32.03(e)","%",{"$f":"F30","v":{"v":1000000,"d":"R 1,000,000.00"}},null,{"$f":"D31*E31","v":0}]
["(g)","Trainee","Prov. Sum",{"v":300000,"d":"R 300,000.00"},1,{"$f":"D32","v":{"v":300000,"d":"R 300,000.00"}}]
["(h)","Handling cost i.t.o. item 32.03 (g)","%",{"$f":"F32","v":{"v":300000,"d":"R 300,000.00"}},null,{"$f":"D33*E33","v":0}]
["(i)","Accommodation","Prov. Sum",{"v":720000,"d":"R 720,000.00"},1,{"$f":"D34","v":{"v":720000,"d":"R 720,000.00"}}]
["(j)","Handling cost i.r.o item 32.03(i)","%",{"$f":"F34","v":{"v":720000,"d":"R 720,000.00"}},null,{"$f":"D35*E35","v":0}]
["(k)","Provision and monthly cost of office equipment","Month",36,null,{"$f":"D36*E36","v":0}]
[]
[32.04,"Meetings"]
["(a)","Steering Committee Meetings "]
["(i)","City of Johannesburg Metropolitan based System","number",12,null,{"$f":"D40*E40","v":0}]
["(ii)","City of Tshwane Metropolitan based system","number",12,null,{"$f":"D41*E41","v":0}]
["(iii)","Sedibeng Municipality based System","number",12,null,0]
["(iv)","West Rand Municipality based System","number",12,null,0]
["(v)","Ekurhuleni Metropolitan Municipality based System","number",12,null,0]
["(b)","Working/ Task Group Meetings "]
["(i)","City of Johannesburg Metropolitan based System","number",12,null,{"$f":"D46*E46","v":0}]
["(ii)","City of Tshwane Metropolitan based system","number",12,null,{"$f":"D47*E47","v":0}]
["(iii)","Sedibeng Municipality based System","number",12,null,0]
["(iv)","West Rand Municipality based System","number",12,null,0]
["(v)","Ekurhuleni Metropolitan Municipality based System","number",12,null,0]
["(c)","RIMS Meetings "]
["(i)","Provincial Coordinating Advisory Committee (PCAC) ","number",12,null,{"$f":"D52*E52","v":0}]
["(ii)","National Technical Committee (NTC)","number",12,null,{"$f":"D53*E53","v":0}]
["(iii)","Post Incident Assessment (PIA)","number",24,null,{"$f":"D54*E54","v":0}]
["(iv)","Simulations ","number",24,null,0]
["(d)","SANRAL Project Meetings "]
["(i)","Project Progress Meeting","number",18,null,{"$f":"D57*E57","v":0}]
["(ii)","Planning /Focus Group Meeting","number",12,null,{"$f":"D58*E58","v":0}]
[]
[]
[32.05,"Reports"]
["(a)","RIMS Provincial Report","number",3,null,{"$f":"D62*E62","v":0}]
["(b)","RIMS Guideline Plans"]
["(i)","Preparation base document and mapping of alternate route in GIS per system (Digitization per RIMS system)","number",1,null,{"$f":"D64*E64","v":0}]
["(ii)","Annual update (per system)","number",3,null,{"$f":"D65*E65","v":0}]
[]
[]
[32.06,"Training Sessions"]
["(a)","1 Day RIMS Workshop (non-accredited) "]
["(i)","City of Johannesburg Metropolitan based System","number",9,null,{"$f":"D70*E70","v":0}]
["(ii)","City of Tshwane Metropolitan based system","number",9,null,0]
["(iii)","Sedibeng Municipality based System","number",9,null,0]
["(iv)","West Rand Municipality based System","number",9,null,0]
["(v)","Ekurhuleni Metropolitan Municipality based System","number",9,null,0]
["(vii)","Refreshments","Prov. Sum",{"v":100000,"d":"R 100,000.00"},1,{"$f":"D75","v":{"v":100000,"d":"R 100,000.00"}}]
["(viii)","Handling cost i.t.o. item 32.06 (a) (vii)","%",{"$f":"F75","v":{"v":100000,"d":"R 100,000.00"}},null,{"$f":"D76*E76","v":0}]
["(ix)","Hiring of Venues","Prov. Sum",{"v":200000,"d":"R 200,000.00"},1,{"$f":"D77","v":{"v":200000,"d":"R 200,000.00"}}]
["(x)","Handling cost i.t.o. item 32.06 (a) (ix)","%",{"$f":"F77","v":{"v":200000,"d":"R 200,000.00"}},null,{"$f":"D78*E78","v":0}]
["(b)","Formal Training (TETA Accredited) "]
["(i)","Theoretical Training  (2 + 1 Days)"]
["(a)","City of Johannesburg Metropolitan based System","number",6,null,{"$f":"D81*E81","v":0}]
["(b)","City of Tshwane Metropolitan based system","number",6,null,{"$f":"D82*E82","v":0}]
["(c)","Sedibeng Municipality based System","number",6,null,{"$f":"D83*E83","v":0}]
["(d)","West Rand Municipality based System","number",6,null,{"$f":"D84*E84","v":0}]
["(e)","Ekurhuleni Metropolitan Municipality based System","number",6,null,{"$f":"D85*E85","v":0}]
["(ii)","Refreshments","Prov. Sum",{"v":200000,"d":"R 200,000.00"},1,{"$f":"D86","v":{"v":200000,"d":"R 200,000.00"}}]
["(iii)","Handling cost i.t.o. item 32.06 (b) (ii)","%",{"$f":"F86","v":{"v":200000,"d":"R 200,000.00"}},null,{"$f":"D87*E87","v":0}]
["(iv)","Hiring of Venues","Prov. Sum",{"v":400000,"d":"R 400,000.00"},1,{"$f":"D88","v":{"v":400000,"d":"R 400,000.00"}}]
["(v)","Handling cost i.t.o. item 32.06 (b) (iv)","%",{"$f":"F88","v":{"v":400000,"d":"R 400,000.00"}},null,{"$f":"D89*E89","v":0}]
["(vi)","Review & Assessment of Portfolio of Evidence (PoE)","number",1000,null,0]
["(vii)","Moderator Assessment & verification of PoE","Prov. Sum",{"v":200000,"d":"R 200,000.00"},1,{"$f":"D91","v":{"v":200000,"d":"R 200,000.00"}}]
["(viii)","Handling cost i.t.o. item 32.06 (b) (vii)","%",{"$f":"F91","v":{"v":200000,"d":"R 200,000.00"}},null,{"$f":"D92*E92","v":0}]
[]
[32.07,"Transport for supervisory personnel"]
["(a)","Travelling to perform duties","Prov. Sum",{"v":1500000,"d":"R 1,500,000.00"},1,{"$f":"D95","v":{"v":1500000,"d":"R 1,500,000.00"}}]
["(b)","Handling cost i.t.o. item 32.07(a)","%",{"$f":"F95","v":{"v":1500000,"d":"R 1,500,000.00"}},null,{"$f":"D96*E96","v":0}]
[]
["3200 TOTAL CARRIED FORWARD TO SUMMARY PAGE",{"$nulls":4},{"$f":"SUM(F12:F97)","v":{"v":10670000,"d":"R 10,670,000.00"}}]
[]
[3300,"ADDITIONAL DUTIES"]
[33.01,"Additional duties "]
["(a)","Personnel - Category A","hour",20,null,{"$f":"D102*E102","v":0}]
["(b)","Personnel - Category B","hour",40,null,0]
["(c) ","Personnel - Category C","hour",160,null,0]
["(d) ","Personnel - Category D","hour",180,null,0]
[]
[33.02,"Additional Duties by Employer","hour",null,{"v":-1500,"d":"R -1,500.00"},"Rate Only"]
[]
[33.03,"Prepare of GIS based Maps as ordered by the Employer"]
["(c)","Personnel - Category C (GIS & CAD Specialist)","hour",240,null,{"$f":"D110*E110","v":0}]
["(d)","Personnel - Category D (GIS & CAD Operator)","hour",600,null,0]
[]
[33.04,"Project Continuity"]
["(a)","Project continuity and transfer of RIMS operation by previous Serivce Provider","Month",2,{"v":250000,"d":"R 250,000.00"},{"$f":"D114*E114","v":{"v":500000,"d":"R 500,000.00"}}]
["(b)","Handling cost i.t.o. item 33.04(a)","%",{"$f":"F114","v":{"v":500000,"d":"R 500,000.00"}},null,{"$f":"D115*E115","v":0}]
["(c) ","Handover and transfer of RIMS operation to the subsequent Service Provider.","Prov. Sum",{"v":500000,"d":"R 500,000.00"},1,{"$f":"D116","v":{"v":500000,"d":"R 500,000.00"}}]
["(d) ","Handling cost i.t.o. item 33.04(c)","%",{"$f":"F116","v":{"v":500000,"d":"R 500,000.00"}},null,{"$f":"D117*E117","v":0}]
[]
["3300 TOTAL CARRIED FORWARD TO SUMMARY PAGE",{"$nulls":4},{"$f":"SUM(F102:F118)","v":{"v":1000000,"d":"R 1,000,000.00"}}]
[]
[3400,"DISBURSEMENTS (where not covered by other items)"]
[34.01,"Disbursements"]
["(a)","Disbursements","Prov. Sum",{"v":750000,"d":"R 750,000.00"},1,{"$f":"D123","v":{"v":750000,"d":"R 750,000.00"}}]
["(b)","Handling cost i.t.o. item 34.01(a)","%",{"$f":"F123","v":{"v":750000,"d":"R 750,000.00"}},null,{"$f":"D124*E124","v":0}]
["3400 TOTAL CARRIED FORWARD TO SUMMARY PAGE",{"$nulls":4},{"$f":"SUM(F123:F124)","v":{"v":750000,"d":"R 750,000.00"}}]
[]
[3500,"ROAD SAFETY AUDITS (APPRAISALS)"]
[35.01,"Project leader/Design Specialist and Head Office"]
["(a)","Duties of the Project leader/Design Specialist","Month",36,null,{"$f":"D129*E129","v":0}]
["(b)","Head Office overhead costs","Month",36,null,{"$f":"D130*E130","v":0}]
[35.02,"Meetings and Site Inspections"]
["(a)","SANRAL project progress meetings","number",12,null,{"$f":"D132*E132","v":0}]
["(b)","Task group meetings","number",12,null,0]
["(c)","RIMS Provincial Coordinating Advisory Committee (On instruction of the employer)","number",12,null,0]
["(d)","Site Inspections"]
["(i)","City of Johannesburg Metropolitan based System","number",12,null,{"$f":"D136*E136","v":0}]
["(ii)","City of Tshwane Metropolitan based system","number",12,null,{"$f":"D137*E137","v":0}]
["(iii)","Sedibeng Municipality based System","number",12,null,0]
["(iv)","West Rand Municipality based System","number",12,null,0]
["(v)","Ekurhuleni Metropolitan Municipality based System","number",12,null,0]
[35.03,"Hazardous Location Database and Report"]
["(a)","Prepare, continuously update and maintain Provincial Hazardous Location Database Register","Month",36,null,{"$f":"D142*E142","v":0}]
["(b)","Provincial Hazardous Location analysis and prepare Report (Bi-annual )","number",6,null,{"$f":"D143*E143","v":0}]
["(c)","Preparation of Provincial Hazardous Location Map"]
["(i)","Preparation of base document","Lump Sum",1,null,{"$f":"D145*E145","v":0}]
["(ii)","Bi-Annual update and revision","number",6,null,{"$f":"D146*E146","v":0}]
["(d) ","Review Major Crash Investigation Report issued by relevant authority (on instruction of the Employer)","number",12,null,0]
[35.04,"Road Safety Audit (Appraisal)"]
["(a)","Procurement of Targeted Enterprises for the Road Safety Audits (Appraisals) sub-services","number (of Tender process)",3,null,{"$f":"D149*E149","v":0}]
["(b)","Management, Monitoring, Guidance, Mentoring and Review of Road Safety Audits (Appraisals) undertaken by Targeted Enterprise","number (of Audits)",18,null,{"$f":"D150*E150","v":0}]
["(c)","Road Safety Appraisals undertaken by Targeted Enterprise (TE)","Prov. Sum",{"v":5000000,"d":"R 5,000,000.00"},1,{"$f":"D151","v":{"v":5000000,"d":"R 5,000,000.00"}}]
["(d)","Handling cost i.t.o. item 35.04(c)","%",{"$f":"F151","v":{"v":5000000,"d":"R 5,000,000.00"}},null,{"$f":"D152*E152","v":0}]
["(e) ","Road Safety Audit Summary Report","number",3,null,0]
["3500 TOTAL CARRIED FORWARD TO SUMMARY PAGE",{"$nulls":4},{"$f":"SUM(F129:F153)","v":{"v":5000000,"d":"R 5,000,000.00"}}]
[]
[3600,"ADDITIONAL DUTIES"]
[36.01,"Additional Duties"]
["(a)","Personnel - Category A","hour",0,null,{"$f":"D158*E158","v":0}]
["(b)","Personnel - Category B","hour",80,null,{"$f":"D159*E159","v":0}]
["(c)","Personnel - Category C (DS  RS)","hour",320,null,{"$f":"D160*E160","v":0}]
["(d)","Personnel - Category D","hour",480,null,{"$f":"D161*E161","v":0}]
[36.02,"Transport to perform additional duties"]
["(a)","Travelling to perform additional duties","Prov. Sum",{"v":150000,"d":"R 150,000.00"},1,{"$f":"D163","v":{"v":150000,"d":"R 150,000.00"}}]
["(b)","Handling cost i.t.o. item 36.02(a)","%",{"$f":"F163","v":{"v":150000,"d":"R 150,000.00"}},null,{"$f":"D164*E164","v":0}]
[36.03,"Specialist Services and specialist advice"]
["(a)","Specialist services or advice provided by or procured by service provider","Prov. Sum",{"v":600000,"d":"R 600,000.00"},1,{"$f":"D166","v":{"v":600000,"d":"R 600,000.00"}}]
["(b)","Handling cost i.t.o. item 36.03(a)","%",{"$f":"F166","v":{"v":600000,"d":"R 600,000.00"}},null,{"$f":"D167*E167","v":0}]
["3600 TOTAL CARRIED FORWARD TO SUMMARY PAGE",{"$nulls":4},{"$f":"SUM(F158:F167)","v":{"v":750000,"d":"R 750,000.00"}}]
[]
[3700,"DISBURSEMENTS (where not covered by other items)"]
[37.01,"Additional Duties"]
["(a)","Disbursements","Prov. Sum",{"v":100000,"d":"R 100,000.00"},1,{"$f":"D172","v":{"v":100000,"d":"R 100,000.00"}}]
["(b)","Handling cost i.t.o. item 37.01(a)","%",{"$f":"F172","v":{"v":100000,"d":"R 100,000.00"}},null,{"$f":"D173*E173","v":0}]
["3700 TOTAL CARRIED FORWARD TO SUMMARY PAGE",{"$nulls":4},{"$f":"SUM(F172:F173)","v":{"v":100000,"d":"R 100,000.00"}}]
[]
[]
[]
["C2.3","SUMMARY  OF  PRICING  SCHEDULE "]
[]
[{"$f":"A10","v":3200},{"$f":"B10","v":"ADMINISTRATION AND MONITORING OF THE PROJECT"},{"$nulls":3},{"$f":"F98","v":{"v":10670000,"d":"R 10,670,000.00"}}]
[{"$f":"A100","v":3300},{"$f":"B100","v":"ADDITIONAL DUTIES"},{"$nulls":3},{"$f":"F119","v":{"v":1000000,"d":"R 1,000,000.00"}}]
[{"$f":"A121","v":3400},{"$f":"B121","v":"DISBURSEMENTS (where not covered by other items)"},{"$nulls":3},{"$f":"F125","v":{"v":750000,"d":"R 750,000.00"}}]
[null,"SUB-TOTAL (A)",{"$nulls":3},{"$f":"SUM(F180:F182)","v":{"v":12420000,"d":"R 12,420,000.00"}}]
[{"$f":"A127","v":3500},{"$f":"B127","v":"ROAD SAFETY AUDITS (APPRAISALS)"},{"$nulls":3},{"$f":"F154","v":{"v":5000000,"d":"R 5,000,000.00"}}]
[{"$f":"A156","v":3600},{"$f":"B156","v":"ADDITIONAL DUTIES"},{"$nulls":3},{"$f":"F168","v":{"v":750000,"d":"R 750,000.00"}}]
[{"$f":"A170","v":3700},{"$f":"B170","v":"DISBURSEMENTS (where not covered by other items)"},{"$nulls":3},{"$f":"F174","v":{"v":100000,"d":"R 100,000.00"}}]
[null,"SUB-TOTAL (B)",{"$nulls":3},{"$f":"SUM(F184:F186)","v":{"v":5850000,"d":"R 5,850,000.00"}}]
[]
[null,"SUB TOTAL (C): ADD SUB TOTAL (A) AND (B) ABOVE",{"$nulls":3},{"$f":"F187+F183","v":{"v":18270000,"d":"R 18,270,000.00"}}]
[]
[null,"VAT   (15%) ON SUB TOTAL (C)",{"$nulls":3},{"$f":"ROUND((F189*0.15),2)","v":{"v":2740500,"d":"R 2,740,500.00"}}]
[]
[null,"TENDER SUM CARRIED FORWARD TO FORM OF OFFER  (C1.1.1)",{"$nulls":3},{"$f":"F189+F191","v":{"v":21010500,"d":"R 21,010,500.00"}}]
[]
[]
["SIGNED BY TENDERER:      ………………………………………….................................…………………."]