{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["1 Instructions","2 Tenderer Input","3 Final Offer"],"read":"whole","date_system":"1900"}

{"sheet":"1 Instructions","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"merged":[[0,0,0,5]]}
["ACSA MECHANICAL PUMP REPAIRS – TENDERER PRICING WORKBOOK"]
[]
["Item","Instruction"]
["Purpose","This workbook calculates the tenderer’s evaluated final offer for the 36-month NEC3 TSC contract."]
["Tenderer inputs","Complete only the yellow cells on the Tenderer Input sheet."]
["Rates","Enter all rates excluding VAT. Rates include workshop overheads, supervision, standard consumables, quality control, administration and profit."]
["Evaluation quantities","The Employer-fixed quantities apply equally to all tenderers for evaluation only and do not guarantee work."]
["Replacement components","The annual provisional sum is R500 000 excluding VAT."]
["Third-party services","The annual provisional sum is R50 000 excluding VAT."]
["Mark-up","Enter the percentage applicable to each approved item or service value band."]
["Escalation","Years 2 and 3 are evaluated at 6% per annum. Actual contract escalation remains governed by the Contract Data."]
["Submission","Carry the final offer amounts from the Final Offer sheet to the signed Form of Offer and Acceptance."]
[]
["Colour key","Yellow","Tenderer input","Blue","Employer assumption","Green = calculated result"]

{"sheet":"2 Tenderer Input","index":1,"n_rows":35,"n_cols":6,"rows_kept":35,"merged":[[0,0,0,5],[20,0,20,4],[28,0,28,2]]}
["TENDERER INFORMATION, RATES AND MARK-UPS"]
[]
["Tenderer information","Tenderer input"]
["Tenderer legal name"]
["Company registration number"]
["VAT registration number"]
[]
["Rate ID","Activity description","Unit","Representative annual quantity","Tenderer rate excl. VAT","Annual evaluated amount"]
["R01","Strip, clean and inspect a submersible pump, including inspection report and repair quotation","Pump",16,null,{"$f":"IF(E9=\"\",\"\",D9*E9)","v":""}]
["R02","Strip, clean and inspect a horizontal centrifugal pump, including inspection report and repair quotation","Pump",1,null,""]
["R03","Mechanical fitter","Hour",141,null,""]
["R04","Electric motor rewinding technician","Hour",40,null,""]
["R05","Machinist","Hour",42,null,""]
["R06","Artisan assistant","Hour",83,null,""]
["R07","Dynamic balancing of rotating assembly","Each",17,null,""]
["R08","Hydraulic performance testing","Pump",17,null,""]
["R09","Electrical testing and certification","Pump",17,null,""]
["R10","Complete motor rewind – up to and including 4.0 kW","Each",2,null,""]
["R11","Complete motor rewind – greater than 4.0 kW up to and including 7.5 kW","Each",1,null,""]
["R12","Complete motor rewind – greater than 7.5 kW up to and including 11.0 kW","Each",2,null,""]
["Sub-total A – annual inspection, labour and workshop services",{"$nulls":4},{"$f":"SUM(F9:F20)","v":{"v":0,"d":"R0.00"}}]
[]
[]
["Approved item or service value band","Tendered mark-up","Evaluation amount","Evaluated mark-up"]
["R0 – R2 000",null,{"v":2000,"d":"R2,000.00"},{"$f":"IF(B25=\"\",\"\",B25*C25)","v":""}]
["R2 001 – R5 000",null,{"v":5000,"d":"R5,000.00"},{"$f":"IF(B26=\"\",\"\",B26*C26)","v":""}]
["R5 001 – R10 000",null,{"v":10000,"d":"R10,000.00"},{"$f":"IF(B27=\"\",\"\",B27*C27)","v":""}]
["R10 001 – R50 000",null,{"v":50000,"d":"R50,000.00"},{"$f":"IF(B28=\"\",\"\",B28*C28)","v":""}]
["Sub-total D – evaluated third-party mark-up",null,null,{"$f":"SUM(D25:D28)","v":{"v":0,"d":"R0.00"}}]
[]
[]
["Input control","Result"]
["Tenderer information complete",{"$f":"IF(AND(B4<>\"\",B5<>\"\",B6<>\"\"),\"PASS\",\"FAIL\")","v":"FAIL"}]
["All mandatory rates complete",{"$f":"IF(COUNT(E9:E20)=12,\"PASS\",\"FAIL\")","v":"FAIL"}]
["All mark-up inputs complete",{"$f":"IF(COUNT(B25:B28)=4,\"PASS\",\"FAIL\")","v":"FAIL"}]

{"sheet":"3 Final Offer","index":2,"n_rows":31,"n_cols":3,"rows_kept":31,"merged":[[0,0,0,3],[30,0,30,2]]}
["FINAL OFFER TO ACSA – 36 MONTHS"]
[]
["Tenderer information","Value"]
["Tenderer legal name",{"$f":"IF('2 Tenderer Input'!B4=\"\",\"\",'2 Tenderer Input'!B4)","v":""}]
["Company registration number",{"$f":"IF('2 Tenderer Input'!B5=\"\",\"\",'2 Tenderer Input'!B5)","v":""}]
["VAT registration number",{"$f":"IF('2 Tenderer Input'!B6=\"\",\"\",'2 Tenderer Input'!B6)","v":""}]
[]
["Year 1 cost element","Basis","Amount excluding VAT"]
["Sub-total A – inspection, labour and workshop services","Tendered rates × fixed annual quantities",{"$f":"'2 Tenderer Input'!F21","v":{"v":0,"d":"R0.00"}}]
["Sub-total B – replacement components provisional sum","Employer allowance",{"v":500000,"d":"R500,000.00"}]
["Sub-total C – third-party services provisional sum","Employer allowance",{"v":50000,"d":"R50,000.00"}]
["Sub-total D – evaluated third-party mark-up","Tendered mark-up × evaluation amounts",{"$f":"'2 Tenderer Input'!D29","v":{"v":0,"d":"R0.00"}}]
["Sub-total E – evaluated tender price for Year 1","A + B + C + D",{"$f":"SUM(C9:C12)","v":{"v":550000,"d":"R550,000.00"}}]
[]
[]
["Evaluation period","Calculation","Amount excluding VAT"]
["Year 1","Base year",{"$f":"C13","v":{"v":550000,"d":"R550,000.00"}}]
["Year 2","Year 1 × 1.06",{"$f":"C17*1.06","v":{"v":583000,"d":"R583,000.00"}}]
["Year 3","Year 2 × 1.06",{"$f":"C18*1.06","v":{"v":617980,"d":"R617,980.00"}}]
["Total evaluated tender price – 36 months","Year 1 + Year 2 + Year 3",{"$f":"SUM(C17:C19)","v":{"v":1750980,"d":"R1,750,980.00"}}]
[]
[]
["Total evaluated tender price excluding VAT","36-month evaluated amount",{"$f":"C20","v":{"v":1750980,"d":"R1,750,980.00"}}]
["VAT at 15%","15% of amount excluding VAT",{"$f":"C23*15%","v":{"v":262647,"d":"R262,647.00"}}]
["Final offer including VAT","Amount excluding VAT + VAT",{"$f":"C23+C24","v":{"v":2013627,"d":"R2,013,627.00"}}]
[]
[]
["Submission status",null,{"$f":"IF(AND('2 Tenderer Input'!B33=\"PASS\",'2 Tenderer Input'!B34=\"PASS\",'2 Tenderer Input'!B35=\"PASS\"),\"READY FOR SUBMISSION\",\"INCOMPLETE\")","v":"INCOMPLETE"}]
["Final offer statement","The tenderer offers to execute the services at the rates entered in this workbook. The calculated 36-month amounts must be carried to the signed Form of Offer and Acceptance."]
[]
["The representative quantities and provisional sums are for tender evaluation and budgeting only and do not guarantee any volume of work."]