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

{"sheet":"RRM Pricing Schedule","index":0,"n_rows":139,"n_cols":6,"rows_kept":139,"merged":[[0,0,0,2],[2,0,2,1],[2,2,2,4],[3,0,3,5],[4,0,4,5],[11,0,13,0],[20,0,21,0],[27,0,29,0],[31,0,32,0],[39,0,41,0],[50,0,52,0],[54,0,62,0],[64,0,66,0],[67,0,70,0],[72,0,81,0],[87,0,90,0],[93,0,94,0],[96,0,97,0],[99,0,105,0],[106,0,109,0],[115,0,116,0],[123,1,123,4]]}
["SOUTH AFRICAN NATIONAL ROADS AGENCY SOC LTD"]
[]
["CONTRACT:",null,"R.524-012-2024/1F"]
[{"$f":"\"CONSULTING ENGINEERING SERVICES FOR THE ROUTINE ROAD MAINTENANCE OF NATIONAL ROUTE R524 FROM LOUIS TRICHARDT TO PUNDA MARIA KRUGER PARK GATE\"","v":"CONSULTING ENGINEERING SERVICES FOR THE ROUTINE ROAD MAINTENANCE OF NATIONAL ROUTE R524 FROM LOUIS TRICHARDT TO PUNDA MARIA KRUGER PARK GATE"}]
["Note to tenderer:\nThe tenderer will be declared non-responsive if:\n   *   A signed Form of Offer is submitted with an incomplete Pricing Schedule.\n   *   A signed Form of Offer is submitted without a Pricing Schedule, but only the Summary of Pricing Schedule submitted."]
[]
["C2.2","PRICING SCHEDULE  (Incorporating SBD3)"]
[]
["Item","Description","Unit","Quantity","Rate","Total  (R)"]
[3200,"DETAILED ASSESSMENT PHASE"]
[32.01,"Detailed assessment phase:"]
[null,"(a) Road Condition Report","Lump Sum",1,null,{"$f":"E12*D12","v":{"v":0,"d":"R0.00"}}]
[null,"(b) Travel and subsistence cost","Lump Sum",1,null,{"$f":"E13*D13","v":{"v":0,"d":"R0.00"}}]
[null,"(c) Toll fees","Prime Cost",1,{"v":5000,"d":"R5,000.00"},{"$f":"E14","v":{"v":5000,"d":"R5,000.00"}}]
[32.02,"Occupational Health and Safety requirements","Lump Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"TOTAL  CARRIED  FORWARD  TO  SUMMARY",{"$nulls":3},{"$f":"SUM(F12:F15)","v":{"v":5000,"d":"R5,000.00"}}]
[]
["Item","Description","Unit","Quantity","Rate","Total  (R)"]
[3300,"TENDER DOCUMENTATION"]
[33.01,"Tender Documentation:"]
[null,"(a)   Preparation of Tender Documents","Lump Sum",1,null,{"$f":"E21*D21","v":{"v":0,"d":"R0.00"}}]
[null,"(b)   Tender Documents on flash drive","Number",1,null,{"$f":"E22*D22","v":{"v":0,"d":"R0.00"}}]
[null,"TOTAL  CARRIED  FORWARD  TO  SUMMARY",{"$nulls":3},{"$f":"SUM(F20:F22)","v":{"v":0,"d":"R0.00"}}]
[]
["Item","Description","Unit","Quantity","Rate","Total  (R)"]
[3400,"SITE INSPECTION AND TENDER PERIOD"]
[34.01,"Site inspection and Tender period"]
[null,"(a)   Service Providers’ Cost","Lump Sum",1,null,{"$f":"E28","v":{"v":0,"d":"R0.00"}}]
[null,"(b)   Provision of pre-recorded video of the scope of the works","Prime Cost",1,{"v":20000,"d":"R20,000.00"},{"$f":"E29","v":{"v":20000,"d":"R20,000.00"}}]
[null,"(c)   Handling cost i.r.o. item 34.01(b)","%",{"$f":"F29","v":{"v":20000,"d":"R20,000.00"}},null,{"$f":"E30*D30","v":{"v":0,"d":"R0.00"}}]
[34.02,"Tender Evaluation Report"]
[null,"(a)   Compilation of Tender Evaluation and Report","Lump Sum",1,null,{"$f":"E32*D32","v":{"v":0,"d":"R0.00"}}]
[null,"(b)   Disbursements","Lump Sum",1,null,{"$f":"E33*D33","v":{"v":0,"d":"R0.00"}}]
[34.03,"Preparation of Works contract documents","Lump Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"TOTAL  CARRIED  FORWARD  TO  SUMMARY",{"$nulls":3},{"$f":"SUM(F27:F34)","v":{"v":20000,"d":"R20,000.00"}}]
[]
["Item","Description","Unit","Quantity","Rate","Total  (R)"]
[3500,"ADMINISTRATION & MONITORING OF WORKS CONTRACT"]
[35.01,"Engineer and Head Office"]
[null,"(a)   Cost to fulfil the duties of Engineer","Month",60,null,{"$f":"E40*D40","v":{"v":0,"d":"R0.00"}}]
[null,"(b)   Head Office overhead costs","Month",60,null,{"$f":"E41*D41","v":{"v":0,"d":"R0.00"}}]
[null,"(c)   Occupational Health and Safety obligations:"]
[null,"     (i)  Continuous compliance and monthly internal audits","Month",60,null,{"$f":"E43*D43","v":{"v":0,"d":"R0.00"}}]
[null,"      (ii) External audits","Prime cost",1,{"v":650000,"d":"R650,000.00"},{"$f":"E44","v":{"v":650000,"d":"R650,000.00"}}]
[null,"      (iii) Handling costs i.r.o. sub-item 35.01(c)(ii)","%",{"$f":"F44","v":{"v":650000,"d":"R650,000.00"}},null,{"$f":"E45*D45","v":{"v":0,"d":"R0.00"}}]
[null,"(d)   Training of Assistant Contract Engineer:"]
[null,"     (i)  Training by Contract Engineer","Prov. Sum",1,{"v":660000,"d":"R660,000.00"},{"$f":"E47","v":{"v":660000,"d":"R660,000.00"}}]
[null,"    (ii) Remuneration of Assistant Contract Engineer","Prov. Sum",1,{"v":700000,"d":"R700,000.00"},{"$f":"E48","v":{"v":700000,"d":"R700,000.00"}}]
[null,"    (iii) Disbursements","Prime cost",1,{"v":200000,"d":"R200,000.00"},{"$f":"E49","v":{"v":200000,"d":"R200,000.00"}}]
[35.02,"Establishment of Supervisory team on site"]
[null,"(a)   Relocation cost of individual site personnel","Prime Cost",1,{"v":100000,"d":"R100,000.00"},{"$f":"E51","v":{"v":100000,"d":"R100,000.00"}}]
[null,"(b)   Handling cost i.r.o. sub-item 35.02(a)","%",{"$f":"F51","v":{"v":100000,"d":"R100,000.00"}},null,{"$f":"E52*D52","v":{"v":0,"d":"R0.00"}}]
[null,"(c)   Establishment of office equipment","Lump Sum",1,null,{"$f":"E53*D53","v":{"v":0,"d":"R0.00"}}]
[35.03,"Provision of Supervisory Staff and Equipment"]
[null,"(a)   Site Supervision Staff","Prov. Sum",1,{"v":11000000,"d":"R11,000,000.00"},{"$f":"E55","v":{"v":11000000,"d":"R11,000,000.00"}}]
[null,"(b)   Mark-up i.r.o. sub-item 35.03(a)","%",{"$f":"F55","v":{"v":11000000,"d":"R11,000,000.00"}},null,{"$f":"E56*D56","v":{"v":0,"d":"R0.00"}}]
[null,"(c)   Project Liaison Officer","Prov. Sum",1,{"v":1200000,"d":"R1,200,000.00"},{"$f":"E57","v":{"v":1200000,"d":"R1,200,000.00"}}]
[null,"(d)   Handling cost i.r.o. sub-item 35.03(c)","%",{"$f":"F57","v":{"v":1200000,"d":"R1,200,000.00"}},null,{"$f":"E58*D58","v":{"v":0,"d":"R0.00"}}]
[null,"(e)   Accommodation","Prov. Sum",1,{"v":1150000,"d":"R1,150,000.00"},{"$f":"E59","v":{"v":1150000,"d":"R1,150,000.00"}}]
[null,"(f)    Mark-up i.r.o. sub-item 35.03(e)","%",{"$f":"F59","v":{"v":1150000,"d":"R1,150,000.00"}},null,{"$f":"E60*D60","v":{"v":0,"d":"R0.00"}}]
[null,"(g)   Provision and monthly cost of office equipment","Month",60,null,{"$f":"E61*D61","v":{"v":0,"d":"R0.00"}}]
[null,"(h)   Trainee","Prov. Sum",1,{"v":400000,"d":"R400,000.00"},{"$f":"E62","v":{"v":400000,"d":"R400,000.00"}}]
[null,"(i)    Handling cost i.r.o. sub-item 35.03(h)","%",{"$f":"F62","v":{"v":400000,"d":"R400,000.00"}},null,{"$f":"E63*D63","v":{"v":0,"d":"R0.00"}}]
[35.04,"Transport for site personnel and additional duties"]
[null,"(a)   Travelling to perform duties","Prov. Sum",1,{"v":2000000,"d":"R2,000,000.00"},{"$f":"E65","v":{"v":2000000,"d":"R2,000,000.00"}}]
[null,"(b)   Handling cost i.r.o. item 35.04(a)","%",{"$f":"F65","v":{"v":2000000,"d":"R2,000,000.00"}},null,{"$f":"E66*D66","v":{"v":0,"d":"R0.00"}}]
[null,"(c)   Toll fees","Prime Cost",1,{"v":10000,"d":"R10,000.00"},{"$f":"E67","v":{"v":10000,"d":"R10,000.00"}}]
[35.05,"Assistance at Clarification Meeting, Tender Period and Tender Evaluation of sub-contract packages"]
[null,"(a)   Service Provider’s cost","Number",5,null,{"$f":"E69*D69","v":{"v":0,"d":"R0.00"}}]
[null,"(b)   Tender Evaluation","Number",15,null,{"$f":"E70*D70","v":{"v":0,"d":"R0.00"}}]
[null,"(c)   Evaluation Report","Number",15,null,{"$f":"E71*D71","v":{"v":0,"d":"R0.00"}}]
[35.06," Reporting of structures safety inspections","Number",3,null,{"$f":"E72*D72","v":{"v":0,"d":"R0.00"}}]
[35.07,"Routine Maintenance and Slope Management System"]
[null,"(a) Incident response"]
[null,"     (i) Level 1 incident","Number",10,null,{"$f":"E75*D75","v":{"v":0,"d":"R0.00"}}]
[null,"     (ii) Level 2 incident","Number",10,null,{"v":0,"d":"R0.00"}]
[null,"     (iii) Level 3 incident","Number",10,null,{"v":0,"d":"R0.00"}]
[null,"     (iv) Level 4 incident","Number",10,null,{"v":0,"d":"R0.00"}]
[null,"(b) Post-rain or seismic event inspection","Number",12,null,{"v":0,"d":"R0.00"}]
[null,"(c) Routine Maintenance Inspections","Number",8,null,{"v":0,"d":"R0.00"}]
[null,"(d) Continuous monitoring","Number",8,null,{"v":0,"d":"R0.00"}]
[null,"(e) Reporting and record keeping costs","Month",10,null,{"v":0,"d":"R0.00"}]
[null,"TOTAL  CARRIED  FORWARD  TO  SUMMARY",{"$nulls":3},{"$f":"SUM(F40:F82)","v":{"v":18070000,"d":"R18,070,000.00"}}]
[]
["Item","Description","Unit","Quantity","Rate","Total  (R)"]
[3600,"ADDITIONAL DUTIES"]
[36.01,"Additional duties by Service Provider"]
[null,"(a)   Personnel – Category A","Hour",50,null,{"$f":"E88*D88","v":{"v":0,"d":"R0.00"}}]
[null,"(b)   Personnel – Category B","Hour",300,null,{"$f":"E89*D89","v":{"v":0,"d":"R0.00"}}]
[null,"(c)   Personnel – Category C","Hour",500,null,{"$f":"E90*D90","v":{"v":0,"d":"R0.00"}}]
[null,"(d)   Personnel – Category D","Hour",500,null,{"$f":"E91*D91","v":{"v":0,"d":"R0.00"}}]
[36.02,"Additional duties by Employer","Hour","-",{"v":-1500,"d":"-R1,500.00"},"Rate only"]
[36.03,"Disbursements"]
[null,"(a)   Disbursements","Prime cost",1,{"v":450000,"d":"R450,000.00"},{"$f":"E94","v":{"v":450000,"d":"R450,000.00"}}]
[null,"(b)   Handling cost i.r.o. item 36.03(a)","%",{"$f":"F94","v":{"v":450000,"d":"R450,000.00"}},null,{"$f":"E95*D95","v":{"v":0,"d":"R0.00"}}]
[36.04,"Additional duties by sub-service provider"]
[null,"(a)   Additional duties","Prime cost",1,{"v":600000,"d":"R600,000.00"},{"$f":"E97","v":{"v":600000,"d":"R600,000.00"}}]
[null,"(b)   Handling cost i.r.o. item 36.04(a)","%",{"$f":"F97","v":{"v":600000,"d":"R600,000.00"}},null,{"$f":"E98*D98","v":{"v":0,"d":"R0.00"}}]
[36.05,"Payment and Monthly reporting costs","Month",60,null,{"$f":"E99*D99","v":{"v":0,"d":"R0.00"}}]
[36.06,"Project Liaison Committee (PLC)"]
[null,"(a)   Establishment of PLC","Lump sum",1,null,{"$f":"E101*D101","v":{"v":0,"d":"R0.00"}}]
[null,"(b)   Liaison/meetings with the PLC during Design and Construction Phase","Prov. Sum",1,{"v":200000,"d":"R200,000.00"},{"$f":"E102","v":{"v":200000,"d":"R200,000.00"}}]
[null,"(c)   PLC stipend","Prov. Sum",1,{"v":450000,"d":"R450,000.00"},{"$f":"E103","v":{"v":450000,"d":"R450,000.00"}}]
[null,"(d)   Handling cost i.r.o. item 36.06(c)","%",{"$f":"F103","v":{"v":450000,"d":"R450,000.00"}},null,{"$f":"E104*D104","v":{"v":0,"d":"R0.00"}}]
[null,"(e)  Training of PLC members","Prov. Sum",1,{"v":250000,"d":"R250,000.00"},{"$f":"E105","v":{"v":250000,"d":"R250,000.00"}}]
[null,"(f)   Handling cost i.r.o. item 36.06(e)","%",{"$f":"F105","v":{"v":250000,"d":"R250,000.00"}},null,{"$f":"E106*D106","v":{"v":0,"d":"R0.00"}}]
[36.07,"Market Analysis and Databases"]
[null,"(a)   Market Analysis","Lump sum",1,null,{"$f":"E108*D108","v":{"v":0,"d":"R0.00"}}]
[null,"(b)   Establishment and maintenance of Targeted Enterprise database","Month",60,null,{"$f":"E109*D109","v":{"v":0,"d":"R0.00"}}]
[null,"(c)   Establishment and maintenance of a Targeted Labour database","Month",60,null,{"$f":"E110*D110","v":{"v":0,"d":"R0.00"}}]
[null,"TOTAL  CARRIED  FORWARD  TO  SUMMARY",{"$nulls":3},{"$f":"SUM(F87:F110)","v":{"v":1950000,"d":"R1,950,000.00"}}]
[]
["Item","Description","Unit","Quantity","Rate","Total  (R)"]
[3700,"OFF-SITE MATERIALS TESTING"]
[37.01,"Off-site materials testing"]
[null,"(a)   Off-site testing by an external SANAS accredited laboratory","Prime cost",1,{"v":150000,"d":"R150,000.00"},{"$f":"E116","v":{"v":150000,"d":"R150,000.00"}}]
[null,"(b)   Handling cost i.r.o. item 37.01(a)","%",{"$f":"F116","v":{"v":150000,"d":"R150,000.00"}},null,{"$f":"E117*D117","v":{"v":0,"d":"R0.00"}}]
[null,"TOTAL  CARRIED  FORWARD  TO  SUMMARY",{"$nulls":3},{"$f":"SUM(F116:F117)","v":{"v":150000,"d":"R150,000.00"}}]
[]
[null,"Prime Cost (PC) and Provisional Sum (PS) sub-total",{"$nulls":3},{"$f":"SUMIFS($F$11:$F$118,$C$11:$C$118,\"Prime cost\")+SUMIFS($F$11:$F$118,$C$11:$C$118,\"prov. sum\")","v":{"v":20195000,"d":"R20,195,000.00"}}]
[null,"Handling Costs & Mark-Up Costs on Prime Cost (PC) and Provisional Sum (PS) sub-total",{"$nulls":3},{"$f":"SUMIFS($F$11:$F$118,$B$11:$B$118,\"*Handling cost*\")+SUMIFS($F$11:$F$118,$B$11:$B$118,\"*Mark-up*\")","v":{"v":0,"d":"R0.00"}}]
[null,"Prime Cost (PC) and Provisional Sum (PS) sub-total including Handling & Mark-Up Costs",{"$nulls":3},{"$f":"SUM(F120:F121)","v":{"v":20195000,"d":"R20,195,000.00"}}]
[]
["CONTRACT PRICE","Contract Price (excl provisional & prime cost sums and the respective tendered mark-up (if any)) but including provision for site supervision staff (payment item 35.03 (a) and (b)) to be performed by this Targeted Enterprise\n* Value used to calculate the subcontacting % on the B7 Returnable Form",{"$nulls":3},{"$f":"F135-F122+F55+F56","v":{"v":11000000,"d":"R11,000,000.00"}}]
[]
["C2.3","SUMMARY OF PRICING SCHEDULE"]
[]
[{"$f":"A10","v":3200},{"$f":"B10","v":"DETAILED ASSESSMENT PHASE"},{"$nulls":3},{"$f":"F16","v":{"v":5000,"d":"R5,000.00"}}]
[{"$f":"A19","v":3300},{"$f":"B19","v":"TENDER DOCUMENTATION"},{"$nulls":3},{"$f":"F23","v":{"v":0,"d":"R0.00"}}]
[{"$f":"A26","v":3400},{"$f":"B26","v":"SITE INSPECTION AND TENDER PERIOD"},{"$nulls":3},{"$f":"F35","v":{"v":20000,"d":"R20,000.00"}}]
[{"$f":"A38","v":3500},{"$f":"B38","v":"ADMINISTRATION & MONITORING OF WORKS CONTRACT"},{"$nulls":3},{"$f":"F83","v":{"v":18070000,"d":"R18,070,000.00"}}]
[{"$f":"A86","v":3600},{"$f":"B86","v":"ADDITIONAL DUTIES"},{"$nulls":3},{"$f":"F111","v":{"v":1950000,"d":"R1,950,000.00"}}]
[{"$f":"A114","v":3700},{"$f":"B114","v":"OFF-SITE MATERIALS TESTING"},{"$nulls":3},{"$f":"F118","v":{"v":150000,"d":"R150,000.00"}}]
[]
[null,"SUB-TOTAL",{"$nulls":3},{"$f":"SUM(F128:F134)","v":{"v":20195000,"d":"R20,195,000.00"}}]
[]
[null,"VAT (15%)",{"$nulls":3},{"$f":"F135*0.15","v":{"v":3029250,"d":"R3,029,250.00"}}]
[]
[null,"TENDER SUM CARRIED FORWARD TO FORM OF OFFER (C1.1.1)",{"$nulls":3},{"$f":"SUM(F135:F137)","v":{"v":23224250,"d":"R23,224,250.00"}}]