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

{"sheet":"RFP Annexure A","index":0,"n_rows":174,"n_cols":8,"rows_kept":174}
["NOTE THAT THESE ARE ONLY INDICATIVE FIGURES FOR TENDER EVALUATIONS PURPOSES. FINAL INSURED VALUE WILL BE DETERMINED AT THE DATE OF CONTRACTING."]
[null,"ANNEXURE A: PRICING SCHEDULE"]
[null,"SPECIAL INVESTIGATING UNIT: Short-term Insurance: 60 months period"]
[null,"CLASS OF INSURANCE","Final Insured values Sums for RFP 30 Sep 2023","MONTHLY PREMIUM (YEAR 1) 01 APRIL 2024","YEAR 2 - 01 APRIL 2025","YEAR 3 - 01 APRIL 2026","YEAR 4 - 01 APRIL 2027","YEAR 5 - 01 APRIL 2028"]
[null,"SUMMARY","R","R"]
["A","Commercial"]
[null,"Fire Section"]
[null,"Claims Preparation Costs"]
[null,"Premises:"]
[null,"Fixtures and fittings",{"v":24866174.46717774,"d":"R24,866,174"}]
["B","Office Section"]
[null,"Claims Preparation Costs"]
[null,"Contents (Other office and leasehold improvements)",{"v":46886977.89395082,"d":"R46,886,978"}]
[null,"Documents"]
["C","Electronic equipment Section"]
[null,"Claims Preparation Costs"]
[null,"All premises owned, hired, leased by the Insured"]
[null,"Hardware, Software, peripheral equipment, including printers, scanners/faxes, Video conference equipment, Audio visual system & accessories",{"v":38553255.84512769,"d":"R38,553,256"}]
[null,"Servers",{"v":21247000,"d":"R21,247,000"}]
[null,"Laptops (1132)",{"v":43570618.08492819,"d":"R43,570,618"}]
[null,"Total Sum Insured for fire, premises content, office section, electronic equipment",{"$f":"SUM(C6:C20)","v":{"v":175124026.29118446,"d":"R175,124,026"}},{"$f":"SUM(D18:D20)","v":{"v":0,"d":"R0"}},{"v":0,"d":"R0"},{"v":0,"d":"R0"},{"v":0,"d":"R0"},{"v":0,"d":"R0"}]
["D","Business Interruption Section"]
[null,"Claims Preparation Costs",{"v":5000,"d":"R5,000"}]
[null,"Addilional Increase in cost of working",{"v":3500000,"d":"R3,500,000"}]
["E","Business All Risks Section"]
[null,"Claims Preparation Costs"]
[null,"Personal effects of employees R5,000 each maximum R50,000",{"v":50000,"d":"R50,000"}]
[]
[null,"SASRIA premium"]
[null,"Total for Liability, Business interruption, business all risks"]
[]
["F","Liability Insurance"]
[null,"Claims Preparation Costs",{"v":100000,"d":"R100,000"}]
[null,"Public Liability",{"v":5000000,"d":"R5,000,000"}]
[null,"Pollution Liability",{"v":5000000,"d":"R5,000,000"}]
[null,"General Liability",{"v":40000000,"d":"R40,000,000"}]
[null,"Statutory Defence Costs",{"v":250000,"d":"R250,000"}]
[null,"Wrongful Arrest",{"v":250000,"d":"R250,000"}]
[null,"Defamation",{"v":250000,"d":"R250,000"}]
[null,"Employers Liability",{"v":100000000,"d":"R100,000,000"}]
[null,"Breach of Copyright",{"v":250000,"d":"R250,000"}]
[null,"Advertising Liability",{"v":1000000,"d":"R1,000,000"}]
[null,"Custody and Control",{"v":75000,"d":"R75,000"}]
[null,"Top up liability",{"v":30000000,"d":"R30,000,000"}]
[null,"Total Monthly Premium for Liability"]
[]
[]
["G","Motor Fleet Policy"]
[null,"143 x sedans and bakkies (Write off period is over 8 years, and current book value is R53 million)",{"$f":"'[1]PIVOT-FINAL'!$G$16","v":{"v":63655187.51050001,"d":"R63,655,188"}}]
[null,"Car Hire (5000 days hire per annum)"]
[null,"Car Rental companies"]
[null,"SASRIA "]
[null,"Administration Fee"]
[null,"Total Monthly premium for vehicles"]
[null,"Total (Motor vehicles, office contents, laptops, servers)",{"$f":"C49+C21","v":{"v":238779213.80168447,"d":"R238,779,214"}}]
["H","Assistere Policy"]
[null,"Stated Benefits"]
[null,"Permanent employees: 600"]
[null,"Total Monthly premium"]
[]
["I","Petty cash risks"]
[null,"The following values per region must also be "]
[]
[null,"Region"]
[]
["1","Head Office/ Gauteng Proncial Office - Pretoria",{"v":28000,"d":"R28,000"}]
["2","East London",{"v":8000,"d":"R8,000"}]
["3","Durban",{"v":8000,"d":"R8,000"}]
["4","Cape Town",{"v":8000,"d":"R8,000"}]
["5","Bloemfontein",{"v":7000,"d":"R7,000"}]
["6","Mahikeng",{"v":8000,"d":"R8,000"}]
["7","Mthatha",{"v":5000,"d":"R5,000"}]
["8","Nelspruit",{"v":8000,"d":"R8,000"}]
["9","Limpopo",{"v":8000,"d":"R8,000"}]
[10,"Kimberly",{"v":5000,"d":"R5,000"}]
[]
[null,"Total petty cash value",{"$f":"SUM(C66:C76)","v":{"v":93000,"d":"R93,000"}}]
[]
[]
["Option A: ","TOTAL OVERALL MONTHLY  INSURANCE PREMIUM, INCLUDING LAPTOPS",null,"R"]
[]
["Option B:","TOTAL OVERALL MONTHLY  INSURANCE PREMIUM, EXCLUDING LAPTOPS",null,"R"]
[null,"(Prices should be inclusive of VAT and any other rates. Bidders are required to qoute on both options, SIU reserves the right to utilise the option that brings in value for money, failure to quote both options will result in the bid disqualified)"]
[]
[]
[null,"Detailed information per SIU office"]
[null,"Fire Section"]
[null,"Premises"]
[null,"1. East London"]
[null,"Fixtures and fittings",{"v":2156009.6039649337,"d":"R2,156,010"}]
[null,"2. Bloemfontein"]
[null,"Fixtures and fittings",{"v":1016930.0962224668,"d":"R1,016,930"}]
[null,"3. Meyerspark, Pretoria"]
[null,"Fixtures and fittings",{"v":13655276.439936372,"d":"R13,655,276"}]
[null,"4. Durban"]
[null,"Fixtures and fittings",{"v":3000694.146635616,"d":"R3,000,694"}]
[null,"5. Polokwane"]
[null,"Fixtures and fittings",{"v":990853.7769402711,"d":"R990,854"}]
[null,"6. Nelspruit"]
[null,"Fixtures and fittings",{"v":1232900.4317424647,"d":"R1,232,900"}]
[null,"7.Kimberly"]
[null,"Fixtures and fittings",{"v":92289.02174356164,"d":"R92,289"}]
[null,"8.Mahikeng"]
[null,"Fixtures and fittings",{"v":1150473.7738871227,"d":"R1,150,474"}]
[null,"9. Mthatha"]
[null,"Fixtures and filttngs"]
[null,"10. Cape Town",{"v":1570747.1761052082,"d":"R1,570,747"}]
[null,"Fixtures and filttngs"]
[null,null,{"$f":"SUM(C88:C108)","v":{"v":24866174.46717802,"d":"R24,866,174"}}]
[]
[null,"Office Section"]
[null,"Premise"]
[null,"1.East London"]
[null,"Contents",{"v":6312584.364172056,"d":"R6,312,584"}]
[null,"2. Bloemfontein"]
[null,"Contents",{"v":3294670.9508810947,"d":"R3,294,671"}]
[null,"3. Meyerspark, Pretoria"]
[null,"Contents",{"v":17234321.55581163,"d":"R17,234,322"}]
[null,"4. Durban"]
[null,"Contents",{"v":9255019.722256439,"d":"R9,255,020"}]
[null,"5.Polokwane"]
[null,"Contents",{"v":2793212.6952427393,"d":"R2,793,213"}]
[null,"6. Nelspruit"]
[null,"Contents",{"v":1218761.7531715068,"d":"R1,218,762"}]
[null,"7. Kimberly"]
[null,"Contents",{"v":85920.50271342465,"d":"R85,921"}]
[null,"8. Mahikeng"]
[null,"Contents",{"v":2130852.266652057,"d":"R2,130,852"}]
[null,"9. Mthatha"]
[null,"Contents",{"v":125890.26695671234,"d":"R125,890"}]
[null,"9. Cape Town"]
[null,"Contents",{"v":4435743.8160931505,"d":"R4,435,744"}]
[null,"Total Sum Insured",{"$f":"SUM(C112:C132)","v":{"v":46886977.893950805,"d":"R46,886,978"}}]
[]
[null,"Electronic Equipment Section"]
[null,"Premises"]
[null,"1. East London"]
[null,"Hardware, Software, Peripheral equipment including printers, Scanners/Faxes, Video Conference equipment, Audio visual system & accessories - As per assets register",{"$f":"1946890.00454356-C139","v":{"v":1759170.7430706834,"d":"R1,759,171"}}]
[null,"Servers",{"v":187719.26147287674,"d":"R187,719"}]
[null,"2. Bloemfontein"]
[null,"Hardware, Software, Peripheral equipment Including printers, Scanners/Faxes, Videoconference equipment, Audio visual system & accessories - As per assets register",{"$f":"1625785.99478027-C142","v":{"v":1073659.072599448,"d":"R1,073,659"}}]
[null,"Servers",{"v":552126.9221808219,"d":"R552,127"}]
[null,"3. Meyerspark, Pretoria"]
[null,"Hardware, Software, Peripheral equipment Including printers, Scanners/Faxes, video Conference equipment. Audio visual system & accessories As per assets register",{"$f":"48355599.7683737-C145","v":{"v":30346884.82145642,"d":"R30,346,885"}}]
[null,"Servers",{"v":18008714.946917277,"d":"R18,008,715"}]
[null,"4. Durban"]
[null,"Hardware, Software, Penpheral equipment including printers, Scanners/Faxes, Video Conference equipment, Audio visual system & accessories As per assets register",{"$f":"3040738.70547617-C148","v":{"v":1768550.8537084986,"d":"R1,768,551"}}]
[null,"Servers",{"v":1272187.8517676713,"d":"R1,272,188"}]
[null,"5. Polokwane"]
[null,"Hardware, Software, Peripheral equipment including printers, Scanners/Faxes, Video Conference equipment, Audio visual system & accessories - As per assets register",{"$f":"1080080.39665644-C151","v":{"v":1063514.0315934264,"d":"R1,063,514"}}]
[null,"Servers",{"v":16566.365063013698,"d":"R16,566"}]
[null,"6. Nespruit"]
[null,"Hardware, Software, Peripheral equipment including printers, Scanners/Faxes, Video Conference equipment. Audio visual system & accessories - As per assets register",{"$f":"1571030.96721534-C154","v":{"v":1337349.1953786276,"d":"R1,337,349"}}]
[null,"Servers",{"v":233681.77183671235,"d":"R233,682"}]
[null,"7. Kimberly"]
[null,"Hardware, Software, Peripheral equipment Including printers, Scanners/Faxes, Video Conference equipment, Audio visual system & accessories - As per assets register",{"v":22429.276109589042,"d":"R22,429"}]
[null,"8. Mahikeng"]
[null,"Hardware, Software, Peripheral equipment Including printers, Scanners/Faxes. Video Conference equipment. Audio visual system & accessories - As per assets reg[ster",{"$f":"1032871.38680548-C159","v":{"v":445777.5441271238,"d":"R445,778"}}]
[null,"Servers",{"v":587093.8426783562,"d":"R587,094"}]
[null,"9. Mthatha"]
[null,"Hardware, Software, Peripheral equipment Including printers, Scanners/Faxes video Conference equipment Audio visual system & accessories - As per assets register",{"v":13525.439391780821,"d":"R13,525"}]
[null,"Servers"]
[null,"10. Cape Town "]
[null,"Hardware, Software, Peripheral equipment Including printers, Scanners/Faxes video Conference equipment Audio visual system & accessories - As per assets register",{"$f":"1111303.90577534-C165","v":{"v":629464.6349797236,"d":"R629,465"}}]
[null,"Servers",{"v":481839.27079561644,"d":"R481,839"}]
[null,"Total Sum Insured",{"$f":"SUM(C136:C165)","v":{"v":59800255.845127665,"d":"R59,800,256"}},{"$f":"SUM(D136:D162)","v":{"v":0,"d":"R0"}},{"v":0,"d":"R0"},{"v":0,"d":"R0"},{"v":0,"d":"R0"},{"v":0,"d":"R0"}]
[null,null,{"$f":"C109+C133+C166","v":{"v":131553408.20625648,"d":"R131,553,408"}}]
[null,"NOTE THAT THESE ARE ONLY INDICATIVE FIGURES FOR TENDER EVALUATIONS PURPOSES. FINAL INSURED VALUE WILL BE DETERMINED AT THE DATE OF CONTRACTING."]
[]
[null,"Name of the Bidder: "]
[null,"CSD Number:"]
[null,"Bidder's representative (full names):"]
[null,"Bidder's representative-Occupation:"]
[null,"Signature:"]