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

{"sheet":"Sheet1","index":0,"n_rows":56,"n_cols":11,"rows_kept":56,"merged":[[0,0,1,1],[2,4,2,9],[3,4,3,9],[4,4,4,9],[7,0,7,4],[8,0,8,4],[9,0,9,4],[10,0,11,10],[12,0,12,4],[13,0,13,4],[14,0,14,4],[15,0,15,4],[16,0,16,4],[17,0,17,4],[18,0,18,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[23,0,23,4],[24,0,24,4],[25,0,25,4],[26,0,26,4],[27,0,27,4],[28,0,28,4],[29,0,29,4],[30,0,30,4],[31,0,31,4],[32,0,32,4],[33,0,33,4],[34,0,34,4],[35,0,35,4],[36,0,36,4],[37,0,37,4],[38,0,38,4],[39,0,39,4],[40,0,40,4],[42,0,43,10],[44,0,44,4],[45,0,45,4],[46,0,46,4],[47,0,47,4],[49,0,49,4]]}
["ANNEXURE A"]
[]
["RFP NO:",{"$nulls":3},"Bid No. CO/080/09/2023"]
["RFP NAME:",{"$nulls":3},"Commercial Insurance Broker"]
["BIDDER NAME"]
[]
[" FEES STRUCTURE"]
[{"$nulls":5},"Year 1","Year 2","Year 3","Year 4","Year 5","Total Contract"]
["POLICY CLASS",{"$nulls":4},"Price\n(incl VAT)","Price\n(incl VAT)","Price\n(incl VAT)","Price\n(incl VAT)","Price\n(incl VAT)","Price\n(incl VAT)"]
["Broker Annual Service Fee",{"$nulls":4},{"$f":"E10*1.14","v":0},{"$f":"F10*1.14","v":0},{"$f":"G10*1.14","v":0},{"$f":"H10*1.14","v":0},{"$f":"H10*1.14","v":0},{"$f":"SUM(F10:J10)","v":0}]
["Premiums (exclusive of commisions) payable as follows: "]
[]
[{"$nulls":5},"Year 1","Year 2","Year 3","Year 4","Year 5","Total Contract"]
["POLICY CLASS",{"$nulls":4},"TOTAL Price\n(incl VAT)","TOTAL Price\n(incl VAT)","TOTAL Price\n(incl VAT)","TOTAL Price\n(incl VAT)","TOTAL Price\n(incl VAT)","TOTAL Price\n(incl VAT)"]
[]
["1. Property Damage/ \nBusiness Interruption\n",{"$nulls":4},{"$f":"E16*1.14","v":0},0,0,0,{"$f":"H16*1.14","v":0},{"$f":"SUM(F16:J16)","v":0}]
["2. General Public Liability"]
["        2.1 Public Liability (Primary Layer)",{"$nulls":4},0,0,0,0,{"$f":"H18*1.14","v":0},{"$f":"SUM(F18:J18)","v":0}]
["        2.2 Umbrella Layer  Liability",{"$nulls":4},0,0,0,0,0,0]
["3. Professional Indemnity",{"$nulls":4},0,0,0,0,0,0]
["4. Directors and Officers Liability",{"$nulls":4},0,0,0,0,0,0]
["5. Employment Practices Liability",{"$nulls":4},0,0,0,0,0,0]
["6. Commercial Crime",{"$nulls":4},0,0,0,0,0,0]
["7. Motor Fleet",{"$nulls":4},0,0,0,0,0,0]
["8. International Business",{"$nulls":4},0,0,0,0,0,0]
["9. Personal Accident",{"$nulls":4},{"$f":"E26*1.14","v":0},{"$f":"F26*1.14","v":0},{"$f":"G26*1.14","v":0},{"$f":"H26*1.14","v":0},0,0]
["10. Contract Works",{"$nulls":4},0,0,0,0,0,0]
["11. Cyber liability",{"$nulls":4},0,0,0,0,0,0]
["12. Plant All Risks",{"$nulls":4},0,0,0,0,0,0]
["13. Marine",{"$nulls":4},{"$f":"E30*1.14","v":0},{"$f":"F30*1.14","v":0},{"$f":"G30*1.14","v":0},{"$f":"H30*1.14","v":0},0,0]
["14.  SASRIA (riot & strike)"]
["        15.1 Material Damage",{"$nulls":4},{"$f":"E32*1.14","v":0},{"$f":"F32*1.14","v":0},{"$f":"G32*1.14","v":0},{"$f":"H32*1.14","v":0},{"$f":"H32*1.14","v":0},{"$f":"SUM(F32:J32)","v":0}]
["        15.2 Money",{"$nulls":4},0,0,0,0,0,0]
["        15.3 Transit",{"$nulls":4},0,0,0,0,0,0]
["        15.4 Contract Works",{"$nulls":4},0,0,0,0,0,0]
["        15.5 Motor",{"$nulls":4},{"$f":"E36*1.14","v":0},{"$f":"F36*1.14","v":0},{"$f":"G36*1.14","v":0},{"$f":"H36*1.14","v":0},0,0]
["        15.6 Marine",{"$nulls":4},0,0,0,0,0,0]
["        15.7 Spectrometer",{"$nulls":4},{"$f":"E38*1.14","v":0},{"$f":"F38*1.14","v":0},{"$f":"G38*1.14","v":0},{"$f":"H38*1.14","v":0},0,0]
["15. Medical evacuation ",{"$nulls":4},{"$f":"E39*1.14","v":0},{"$f":"F39*1.14","v":0},{"$f":"G39*1.14","v":0},{"$f":"H39*1.14","v":0},{"$f":"H39*1.14","v":0},{"$f":"SUM(F39:J39)","v":0}]
["16. Broker fees",{"$nulls":4},{"$f":"E40*1.14","v":0},{"$f":"F40*1.14","v":0},{"$f":"G40*1.14","v":0},{"$f":"H40*1.14","v":0},{"$f":"H40*1.14","v":0},{"$f":"SUM(F40:J40)","v":0}]
["Total Annual Costs",{"$nulls":4},{"$f":"SUM(F16:F40)","v":0},{"$f":"G10+SUM(G16:G19)","v":0},0,0,0,0]
[]
["Adhoc costing"]
[]
["1. Risk assessment specialist to perform risk assessments (total estimated costs based on hours multiplied by the rate) ",{"$nulls":4},{"$f":"E45*1.14","v":0},{"$f":"F45*1.14","v":0},{"$f":"G45*1.14","v":0},{"$f":"H45*1.14","v":0},{"$f":"H45*1.14","v":0},{"$f":"SUM(F45:J45)","v":0}]
["2. Valuation services such as new asset replacement costs (total estimated costs based on hours multiplied by the rate) ",{"$nulls":4},0,0,0,0,{"$f":"H46*1.14","v":0},{"$f":"SUM(F46:J46)","v":0}]
["3. Other (please specify)…....",{"$nulls":4},{"$f":"E47*1.14","v":0},{"$f":"F47*1.14","v":0},{"$f":"G47*1.14","v":0},{"$f":"H47*1.14","v":0},{"$f":"H47*1.14","v":0},{"$f":"SUM(F47:J47)","v":0}]
["4. Other (please specify)…....",{"$nulls":4},0,0,0,0,0,0]
[]
["Grant total per year",{"$nulls":4},{"$f":"+F41+F45+F46+F47+F48","v":0},{"$f":"+G41+G45+G46+G47+G48","v":0},0,0,0,0]
[]
["GRANT TOTAL OF BID",{"$nulls":9},{"$f":"SUM(F50:K50)","v":0}]
[]
["- Please note that the 2024/25 figures are estimations for evaluation purposes and the final cover requirements will be communicated before commencement of the insurance cover for finalisation of the insurance"]
["-The bidder is required to give annual service fee split over 5 years"]
["- The bidder is required to give commission percentage and multiply by the the estimated annual claim for 5 years to arrive at the estimated contractual fee."]