{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["RFB542"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"RFB542","index":0,"n_rows":36,"n_cols":22,"rows_kept":36,"merged":[[1,0,3,12],[5,2,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[5,18,5,19],[5,20,5,21],[18,0,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[23,2,23,4],[27,0,27,5],[28,0,28,5],[31,2,31,4],[32,1,32,5],[33,1,33,5],[34,1,34,5],[35,0,36,0],[35,1,35,5],[36,1,36,5]]}
[]
["                             APPOINTMENT OF THE FINANCIAL ADVISOR/BROKER FOR PENSION FUND AND GROUP RISK LIFE BS/2026/RFB553"]
[]
[]
[]
[null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 6",null,"Year 7",null,"Year 8",null,"Year 9",null,"Year 10"]
["Description","Months","Admin Fee","TOTAL ","PRICE ","TOTAL ","PRICE ","TOTAL ","PRICE ","TOTAL ","PRICE ","TOTAL ","Admin Fee","TOTAL ","PRICE ","TOTAL ","PRICE ","TOTAL ","PRICE ","TOTAL ","PRICE ","TOTAL "]
["Admin Fee (Group Life) ",12,null,{"$f":"B8*C8","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"$f":"D8*E8","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"$f":"F8*G8","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"$f":"H8*I8","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"$f":"J8*K8","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"$f":"L8*M8","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"$f":"N8*O8","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"$f":"P8*Q8","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"$f":"R8*S8","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"$f":"T8*U8","v":{"v":0,"d":"R0.00"}}]
["Admin Fee (Pension Fund) ",12,null,{"$f":"B9*C9","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Other Additional cost",null,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
[{"$nulls":3},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
[{"$nulls":3},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
[{"$nulls":3},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"}]
[]
[null,null,"TOTAL EXCL VAT",{"$f":"D8+D9+D10+D11+D12+D13+D14","v":{"v":0,"d":"R0.00"}},"TOTAL EXCL VAT",{"$f":"F8+F9+F10+F11+F12+F13+F14","v":{"v":0,"d":"R0.00"}},"TOTAL EXCL VAT",{"$f":"H8+H9+H10+H11+H12+H13+H14","v":{"v":0,"d":"R0.00"}},"TOTAL EXCL VAT",{"$f":"J8+J9+J10+J11+J12+J13+J14","v":{"v":0,"d":"R0.00"}},"TOTAL EXCL VAT",{"$f":"L8+L9+L10+L11+L12+L13+L14","v":{"v":0,"d":"R0.00"}},"TOTAL EXCL VAT",{"$f":"N8+N9+N10+N11+N12+N13+N14","v":{"v":0,"d":"R0.00"}},"TOTAL EXCL VAT",{"$f":"P8+P9+P10+P11+P12+P13+P14","v":{"v":0,"d":"R0.00"}},"TOTAL EXCL VAT",{"$f":"R8+R9+R10+R11+R12+R13+R14","v":{"v":0,"d":"R0.00"}},"TOTAL EXCL VAT",{"$f":"T8+T9+T10+T11+T12+T13+T14","v":{"v":0,"d":"R0.00"}},"TOTAL EXCL VAT",{"$f":"V8+V9+V10+V11+V12+V13+V14","v":{"v":0,"d":"R0.00"}}]
[null,null,"VAT if applicable)",{"$f":"D14+D15*15/100","v":{"v":0,"d":"R 0.00"}},"VAT if applicable)",{"$f":"F14+F15*15/100","v":{"v":0,"d":"R 0.00"}},"VAT if applicable)",{"$f":"H14+H15*15/100","v":{"v":0,"d":"R 0.00"}},"VAT if applicable)",{"$f":"J14+J15*15/100","v":{"v":0,"d":"R 0.00"}},"VAT if applicable)",{"$f":"L14+L15*15/100","v":{"v":0,"d":"R 0.00"}},"VAT if applicable)",{"$f":"N14+N15*15/100","v":{"v":0,"d":"R 0.00"}},"VAT if applicable)",{"$f":"P14+P15*15/100","v":{"v":0,"d":"R 0.00"}},"VAT if applicable)",{"$f":"R14+R15*15/100","v":{"v":0,"d":"R 0.00"}},"VAT if applicable)",{"$f":"T14+T15*15/100","v":{"v":0,"d":"R 0.00"}},"VAT if applicable)",{"$f":"V14+V15*15/100","v":{"v":0,"d":"R 0.00"}}]
[null,null,"TOTAL INCL VAT",{"$f":"D15*1.15","v":{"v":0,"d":"R 0.00"}},"TOTAL INCL VAT",{"$f":"F15*1.15","v":{"v":0,"d":"R 0.00"}},"TOTAL INCL VAT",{"$f":"H15*1.15","v":{"v":0,"d":"R 0.00"}},"TOTAL INCL VAT",{"$f":"J15*1.15","v":{"v":0,"d":"R 0.00"}},"TOTAL INCL VAT",{"$f":"L15*1.15","v":{"v":0,"d":"R 0.00"}},"TOTAL INCL VAT",{"$f":"N15*1.15","v":{"v":0,"d":"R 0.00"}},"TOTAL INCL VAT",{"$f":"P15*1.15","v":{"v":0,"d":"R 0.00"}},"TOTAL INCL VAT",{"$f":"R15*1.15","v":{"v":0,"d":"R 0.00"}},"TOTAL INCL VAT",{"$f":"T15*1.15","v":{"v":0,"d":"R 0.00"}},"TOTAL INCL VAT",{"$f":"V15*1.15","v":{"v":0,"d":"R 0.00"}}]
[{"$nulls":5},{"$f":"F16*1.15","v":{"v":0,"d":"R 0.00"}}]
["GRAND TOTAL"]
["Total VAT Excl",{"$f":"D15+F15+H15+J15+L15+N15+P15+R15+T15+V15","v":{"v":0,"d":"R0.00"}}]
["VAT ",{"$f":"B20*0.15","v":{"v":0,"d":"R0.00"}}]
["Total VAT Incl",{"$f":"B20+B21","v":{"v":0,"d":"R0.00"}}]
[]
["Notes:"]
["Pricing must cover all items detailed in the Terms of Reference"]
["The BANKSETA requires the brokage services for pension fund and group risk life brokage and the bidders must quote for both"]
["Pricing quoted by the bidder must remain firm for each year "]
["Total pricing must include Value Added Tax (VAT) where ever applicable. VAT should be "]
["shown separately each year and for full 10 years as indicated."]
["Service provider to check the total bid price for all the years for accuracy and completeness."]
["Service provider must complete blocks in yellow. Total values in this spreadsheet are automatically "]
[" calculated and filled in."]
["Date:"]
["Service Provider Name"]
["Name of Person Signing"]
["Signature"]