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

{"sheet":"3 years pricing Schedule","index":0,"n_rows":41,"n_cols":6,"rows_kept":41,"merged":[[0,1,0,5],[2,1,2,4],[3,1,4,1],[5,1,5,4],[6,1,6,4],[7,1,7,4],[9,1,9,4],[10,1,11,1],[12,1,12,4],[13,1,13,4],[14,1,14,4],[16,1,16,4],[17,1,18,1],[19,1,19,4],[20,1,20,4],[21,1,21,4],[23,1,23,4],[24,1,25,1],[26,1,26,4],[27,1,27,4],[28,1,28,4],[30,1,30,4],[31,1,31,4],[33,1,33,4],[34,1,34,5],[35,1,35,6],[36,1,36,6],[37,1,37,4],[38,1,38,4],[39,1,39,4],[40,1,40,4]]}
[null,"Annexure E:  Pricing Schedule for Insurance Broking Services for a period of three (3) years: TCC/2023/06/0001/32490/RFP"]
[]
[null,"Portfolio A: Pricing Schedule"]
[null,"Annual Broking fee (R)","Year 1 (12 Months) Excl. VAT","Year 2 (12 Months) Excl. VAT","Year 3 (12 Months) Excl. VAT","TOTAL PRICE, exclusive of VAT"]
[null,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"SUM(C5:E5)","v":{"v":0,"d":"R0.00"}}]
[null,"VAT 15% (if applicable)",{"$nulls":3},{"$f":"F5*15%","v":{"v":0,"d":"R0.00"}}]
[null,"Unconditional Discount(s)",{"$nulls":3},{"v":0,"d":"R0.00"}]
[null,"Total Inclusive of VAT (where applicable)",{"$nulls":3},{"$f":"(F5+F6)-F7","v":{"v":0,"d":"R0.00"}}]
[]
[null,"Portfolio B: Pricing Schedule"]
[null,"Annual Broking fee (R)","Year 1 (12 Months) Excl. VAT","Year 2 (12 Months) Excl. VAT","Year 3 (12 Months) Excl. VAT","TOTAL PRICE, exclusive of VAT"]
[null,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"SUM(C12:E12)","v":{"v":0,"d":"R0.00"}}]
[null,"VAT 15% (if applicable)",{"$nulls":3},{"$f":"F12*15%","v":{"v":0,"d":"R0.00"}}]
[null,"Unconditional Discount(s)",{"$nulls":3},{"v":0,"d":"R0.00"}]
[null,"Total Inclusive of VAT (where applicable)",{"$nulls":3},{"$f":"(F12+F13)-F14","v":{"v":0,"d":"R0.00"}}]
[]
[null,"Portfolio C: Pricing Schedule"]
[null,"Annual Broking fee (R)","Year 1 (12 Months) Excl. VAT","Year 2 (12 Months) Excl. VAT","Year 3 (12 Months) Excl. VAT","TOTAL PRICE, exclusive of VAT"]
[null,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"SUM(C19:E19)","v":{"v":0,"d":"R0.00"}}]
[null,"VAT 15% (if applicable)",{"$nulls":3},{"$f":"F19*15%","v":{"v":0,"d":"R0.00"}}]
[null,"Unconditional Discount(s)",{"$nulls":3},{"v":0,"d":"R0.00"}]
[null,"Total Inclusive of VAT (where applicable)",{"$nulls":3},{"$f":"(F19+F20)-F21","v":{"v":0,"d":"R0.00"}}]
[]
[null,"Portfolio D: Pricing Schedule"]
[null,"Annual Broking fee (R)","Year 1 (12 Months) Excl. VAT","Year 2 (12 Months) Excl. VAT","Year 3 (12 Months) Excl. VAT","TOTAL PRICE, exclusive of VAT"]
[null,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"SUM(C26:E26)","v":{"v":0,"d":"R0.00"}}]
[null,"VAT 15% (if applicable)",{"$nulls":3},{"$f":"F26*15%","v":{"v":0,"d":"R0.00"}}]
[null,"Unconditional Discount(s)",{"$nulls":3},{"v":0,"d":"R0.00"}]
[null,"Total Inclusive of VAT (where applicable)",{"$nulls":3},{"$f":"(F26+F27)-F28","v":{"v":0,"d":"R0.00"}}]
[null,"Notes to Pricing:"]
[null,"a)         Prices must be quoted in South African Rand, exclusive of VAT (refer to \"Green\" cells)"]
[null,"b)         Transnet requires that the Insurance Broking Services be provided on an Annual Broking Fee basis and not on a Commission basis."]
[null,"c)         If the:"]
[null,"                   ·       Annual broking fee is left blank; the respondent will be excluded for that particular portfolio."]
[null,"                   ·       The annual broking fee should include all  cost related to the scope of service the (Traveling fee, Administration fee, Labour fee, Training Fee, Claims handling fee and Claims Settlement fee (per claim)    "]
[null,"d)         To facilitate like-for-like comparison bidders must submit pricing strictly in accordance with this pricing schedule and not utilise a different format.  Deviation from this pricing schedule could result in a bid being declared non responsive."]
[null,"e)         Please note that should you have offered a discounted price(s), Transnet will only consider such price discount(s) in the final evaluation stage if offered on an unconditional basis."]
[null,"f) Bidder to provide a breakdown of pricing on a separate sheet."]
[null,"g)  PPPFA formula is going to be applied on the Total price per Portfolio inclusive of VAT."]
[null,"N.B. Failure to submit a pricing schedule at the closing date of this tender will result in the respondent being disqualified."]
[null,"                   Travelling and Accommodation will be strictly in accordance with Transnet’s travel policy. "]