{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Internal Audit pricing ECGBB"],"not_rendered":{"images":1,"defined_names":25},"read":"whole","date_system":"1900"}

{"sheet":"Internal Audit pricing ECGBB","index":0,"n_rows":43,"n_cols":6,"rows_kept":43,"merged":[[5,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[12,0,12,5],[22,0,22,3],[22,4,22,5],[24,0,24,5],[40,0,40,3],[40,4,40,5],[42,0,42,5]]}
["INSTRUCTIONS:"]
["Only the green cells need to be completed by the bidder"]
["Detailed pricing schedules may be attached but must reconcile to the below. "]
["The total cost per assignment and per level of staffing should reconcile to each other and will be the basis for price evaluation"]
[]
[null,null,"ANNEXURE A: PRICING SCHEDULE"]
[]
[]
[null,"RFP NO: ","ECGB-23/24-BID 02"]
[null,"RFP NAME: ","APPOINTMENT OF A SERVICE PROVIDER TO OFFCER INTERNAL AUDIT SERVICES TO ECGB FOR A MINIMUM PERIOD OF THREE YEARS"]
[null,"BIDDER NAME"]
[]
["Table A1: Indicative Audit hours per annual audit plan"]
["Item","Focus Area","Estimated hours","Average Hourly rate (excl VAT)","Average Hourly rate\n(incl VAT)","TOTAL Price\n(incl VAT)"]
[1,"Management of Internal Audit Function",316,null,{"$f":"D15*1.15","v":0},{"$f":"E15*C15","v":0}]
[2,"Governance and compliance",300,null,{"$f":"D16*1.15","v":0},{"$f":"E16*C16","v":0}]
[3,"Risk based, Operational, Financial, and Control Reviews",1410,null,0,0]
[4,"Performance Information",1050,null,0,0]
[5,"Information Technology reviews",790,null,0,0]
[6,"Follow up reviews",480,null,0,0]
[7,"Ad-hoc reviews",150,null,0,0]
[null,"Total",{"$f":"SUM(C15:C21)","v":4496},null,{"$f":"F22/C22","v":0},{"$f":"SUM(F15:F21)","v":0}]
["PRICE THAT WILL BE USED FOR EVALUATION PURPOSES",{"$nulls":3},{"$f":"F22","v":0}]
[]
["Table A2: Actual hourly rates for contracting purposes, based on the hours above"]
["Item","Description","Estimated hours","Actual Hourly rate (excl VAT)","Hourly rate \n(incl VAT)","TOTAL Price\n(incl VAT)"]
[1,"Engagement Director",null,null,{"$f":"D27*1.15","v":0},{"$f":"E27*C27","v":0}]
[2,"ICT Director",null,null,0,{"$f":"E28*C28","v":0}]
[3,"Manager",null,null,0,0]
[4,"ICT Specialist",null,null,0,0]
[5,"Assistant manager",null,null,0,0]
[6,"Supervisor",null,null,0,{"$f":"E32*C32","v":0}]
[7,"Internal Auditor",null,null,0,{"$f":"E33*C33","v":0}]
[8,"Junior Auditor",null,null,0,{"$f":"E34*C34","v":0}]
[9,"Other Specialists",null,null,0,{"$f":"E35*C35","v":0}]
[10,{"$nulls":3},0,{"$f":"E36*C36","v":0}]
[11,{"$nulls":3},0,0]
[12,{"$nulls":3},0,0]
[null,"Total",{"$f":"SUM(C27:C38)","v":0},null,{"$f":"F39/C39","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F27:F38)","v":0}]
[null,null,{"$f":"IF(C39=C22,\"\",\"ERROR\")","v":"ERROR"},null,null,{"$f":"IF(F39=F22,\"\",\"ERROR\")","v":""}]
["PRICE THAT WILL BE USED FOR EVALUATION PURPOSES (Hours and Average rate must agree to table A1 above.)",{"$nulls":3},{"$f":"F39","v":0}]
[]
["Note: Due to the nature of the assignment, Subsistence and Travel expenses will be limited to 5% of the professional fees to be billed and do not need to be included separately above."]