{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Rates Estimation","Proposed Pricing","Sheet2"],"not_rendered":{"images":3,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Rates Estimation","index":0,"n_rows":39,"n_cols":5,"rows_kept":39,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,2,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[22,1,23,1]]}
[]
[null,"APPOINTMENT OF EXTERNAL ASSURANCE PROVIDER : OTHER AUDIT RELATED SERVICES"]
[null,"PROPOSED BUDGET "]
[]
[]
[]
[null,"1. RATES ESTIMATION"]
[]
[null,"Based on National Treasury  Instruction Note 3 of 2017-18 on cost containment measures, the appointment of an external assurance provider would constitute the engagement of professional service providers (consultants) and as such, paragraph 4.3 and 4.6 are applicable:"]
{"$rows_empty":10}
[null,"In order to determine a fair and reasonable remuneration framework for this appointment , the Circular 01/2023/24 \"Guideline on fees for audits done on behalf of the Auditor General of South Africa (AGSA)\" is to be used as a basis and guidance for the determination of rates per professional level of the assurance providers team."]
[null,"These rates are then to be adjusted to reflect the time period of the appointment"]
[]
[null,"ENTER RATE PER HOUR PER PROFESSIONAL LEVEL:","Year 1","Year 2","Year 3"]
[null,null,"2023 - 2024","2024 - 2025","2025 - 2026"]
[null,"Professional Level:","Rate per Hour (Excl VAT)","Rate per Hour (Excl VAT)","Rate per Hour (Excl VAT)"]
[null,"Engagement Partner CA  (SA)/LLB/ACFE/ ICFP or other relevant qualifications",null,{"$f":"+C26*1.05","v":0},0]
[null,"Senior Manager/Specialist CA  (SA)/LLB/ACFE/  ICFP or other relevant qualifications",null,0,0]
[null,"Audit Manager CA  (SA)/LLB/ACFE/ ICFP or other relevant qualifications",null,0,0]
[null,"Assistant Manager /Audit Senior / Supervisor (APC (QE2) RGA FQE (Final qualifying exam) ACCA P1 + P7)",null,0,0]
[null,"Trainees (Bcom degree, Honours, CTA, ITC (QE1) or RGA FQE(Mid Rate )",null,0,0]
[]
[null,"Assumptions Used :"]
[null,"Regulatory Audit Charge (RA) Rates - 3 year Training Programme"]
[null,"Professional Level of composition"]
[null,"Travel and Subsistence Disbursements shall be capped at approximately 7.5% of audit service costs incurred"]
[]
[null,"Assumed learning rate of 90% in year 2"]
[null,"Inflationary increases aligned to Rand Water's 5 Year Budget Plan"]
[null,"Assumed at 5% to be adjusted - In line with  the below 3 year CPI projections."]

{"sheet":"Proposed Pricing","index":1,"n_rows":51,"n_cols":13,"rows_kept":51,"merged":[[0,0,0,12],[1,0,1,12],[2,2,2,4],[2,5,2,7],[2,8,2,10],[2,11,3,11],[2,12,3,12],[4,5,13,7],[11,12,13,12],[15,0,15,12],[16,2,16,4],[16,5,16,7],[16,8,16,10],[16,11,17,11],[16,12,17,12],[25,12,27,12],[29,0,29,12],[30,2,30,4],[30,5,30,7],[30,8,30,10],[30,11,31,11],[30,12,31,12],[39,12,41,12]]}
["PRICING STRUCTURE : APPOINTMENT OF EXTERNAL ASSURANCE PROVIDER : OTHER AUDIT RELATED SERVICES"]
["PRICING STRUCTURE FOR SUSTAINABILITY REPORTING REVIEW"]
[null,null,"Year 1 (2023-2024)",null,null,"Year 2 (2024-2025)",null,null,"Year 3 (2025-2026)",null,null,"TOTAL PROPOSED COSTING","COMMENTS"]
["AUDIT TEAM COMPOSITION","PAX","EST HOURS","EST RATE","TOTAL","EST HOURS","EST RATE","TOTAL","EST HOURS","EST RATE","TOTAL"]
["Engagement Partner",{"$f":"+'[1]Cost Estimates'!D27","v":1},6,{"$f":"+'Rates Estimation'!$C$26","v":0},{"$f":"C5*D5","v":0},{"$nulls":3},{"$f":"+C5","v":6},{"$f":"+'Rates Estimation'!$E$26","v":0},{"$f":"I5*J5","v":0},{"$f":"E5+H5+K5","v":0}]
["Senior  Manager",{"$f":"+'[1]Cost Estimates'!D28","v":1},8,{"$f":"+'Rates Estimation'!$C$27","v":0},{"$f":"C6*D6","v":0},{"$nulls":3},{"$f":"+C6","v":8},{"$f":"+'Rates Estimation'!$E$27","v":0},{"$f":"I6*J6","v":0},{"$f":"E6+H6+K6","v":0}]
["Audit Manager",{"$f":"+'[1]Cost Estimates'!D29","v":1},10,{"$f":"+'Rates Estimation'!$C$28","v":0},{"$f":"C7*D7","v":0},{"$nulls":3},10,{"$f":"+'Rates Estimation'!$E$28","v":0},0,0]
["Assistant Manager",1,12,{"$f":"+'Rates Estimation'!$C$29","v":0},{"$f":"C8*D8","v":0},{"$nulls":3},12,{"$f":"+'Rates Estimation'!$E$29","v":0},0,0]
["Trainees ",3,45,{"$f":"+'Rates Estimation'!$C$30","v":0},{"$f":"C9*D9","v":0},{"$nulls":3},45,{"$f":"+'Rates Estimation'!$E$30","v":0},0,0]
["SUBTOTAL (EXCL VAT)",null,{"$f":"SUM(C5:C9)","v":81},null,{"$f":"SUM(E5:E9)","v":0},{"$nulls":3},{"$f":"SUM(I5:I9)","v":81},null,{"$f":"SUM(K5:K9)","v":0},{"$f":"SUM(L5:L9)","v":0}]
["Travel and Subsistence Disbursements",{"v":0.075,"d":"7.5%"},null,null,{"$f":"E10*B11","v":0},{"$nulls":5},{"$f":"K10*B11","v":0},{"$f":"E11+H11+K11","v":0}]
["PRICING STRUCTURE (EXCL VAT)",{"$nulls":3},{"$f":"SUM(E10:E11)","v":0},{"$nulls":5},{"$f":"SUM(K10:K11)","v":0},{"$f":"SUM(L10:L11)","v":0},"*Place these amounts on RFQ - section 3.3"]
["VAT",{"$nulls":3},{"$f":"E12*15%","v":0},{"$nulls":5},{"$f":"K12*15%","v":0},{"$f":"L12*15%","v":0}]
["TOTAL PRICING STRUCTURE (INCL VAT)",{"$nulls":3},{"$f":"E12+E13","v":0},{"$nulls":5},{"$f":"SUM(K12:K13)","v":0},{"$f":"L12+L13","v":0}]
[]
["PRICING STRUCTURE FOR CONSOLIDATED INTERIM  FINANCIAL STATEMENTS REVIEW"]
[null,null,"Year 1 (2023-2024)",null,null,"Year 2 (2024-2025)",null,null,"Year 3 (2025-2026)",null,null,"TOTAL PROPOSED COSTING","COMMENTS"]
["AUDIT TEAM COMPOSITION","PAX","EST HOURS","EST RATE","TOTAL","EST HOURS","EST RATE","TOTAL","EST HOURS","EST RATE","TOTAL"]
["Engagement Partner",{"$f":"+'[1]Cost Estimates'!D5","v":1},10,{"$f":"+'Rates Estimation'!$C$26","v":0},{"$f":"C19*D19*B19","v":0},{"$f":"+C19*90%","v":9},{"$f":"+'Rates Estimation'!$D$26","v":0},{"$f":"F19*G19","v":0},{"$f":"+F19","v":9},{"$f":"+'Rates Estimation'!$E$26","v":0},{"$f":"I19*J19","v":0},{"$f":"E19+H19+K19","v":0}]
["Senior  Manager",{"$f":"+'[1]Cost Estimates'!D6","v":1},12,{"$f":"+'Rates Estimation'!$C$27","v":0},{"$f":"C20*D20","v":0},{"$f":"+C20*90%","v":{"v":10.8,"d":"11"}},{"$f":"+'Rates Estimation'!$D$27","v":0},{"$f":"F20*G20","v":0},{"$f":"+F20","v":{"v":10.8,"d":"11"}},{"$f":"+'Rates Estimation'!$E$27","v":0},{"$f":"I20*J20","v":0},{"$f":"E20+H20+K20","v":0}]
["Audit Manager",{"$f":"+'[1]Cost Estimates'!D7","v":1},28,{"$f":"+'Rates Estimation'!$C$28","v":0},{"$f":"C21*D21","v":0},{"v":25.2,"d":"25"},{"$f":"+'Rates Estimation'!$D$28","v":0},0,{"$f":"+F21","v":{"v":25.2,"d":"25"}},{"$f":"+'Rates Estimation'!$E$28","v":0},0,0]
["Assistant Manager",{"$f":"+'[1]Cost Estimates'!D8","v":2},140,{"$f":"+'Rates Estimation'!$C$29","v":0},0,126,{"$f":"+'Rates Estimation'!$D$29","v":0},0,{"$f":"+F22","v":126},{"$f":"+'Rates Estimation'!$E$29","v":0},0,0]
["Trainees ",{"$f":"+'[1]Cost Estimates'!D9","v":4},520,{"$f":"+'Rates Estimation'!$C$30","v":0},0,468,{"$f":"+'Rates Estimation'!$D$30","v":0},0,{"$f":"+F23","v":468},{"$f":"+'Rates Estimation'!$E$30","v":0},0,0]
["SUBTOTAL (EXCL VAT)",null,{"$f":"SUM(C19:C23)","v":710},null,{"$f":"SUM(E19:E23)","v":0},{"$f":"SUM(F19:F23)","v":639},null,{"$f":"SUM(H19:H23)","v":0},{"$f":"SUM(I19:I23)","v":639},null,{"$f":"SUM(K19:K23)","v":0},{"$f":"SUM(L19:L23)","v":0}]
["Travel and Subsistence Disbursements",{"v":0.075,"d":"7.5%"},null,null,{"$f":"E24*B25","v":0},null,null,{"$f":"H24*B25","v":0},null,null,{"$f":"K24*B25","v":0},{"$f":"E25+H25+K25","v":0}]
["PRICING STRUCTURE (EXCL VAT)",{"$nulls":3},{"$f":"SUM(E24:E25)","v":0},null,null,{"$f":"SUM(H24:H25)","v":0},null,null,{"$f":"SUM(K24:K25)","v":0},{"$f":"SUM(L24:L25)","v":0},"*Place these amounts on RFQ - section 3.3"]
["VAT",{"$nulls":3},{"$f":"E26*15%","v":0},null,null,{"$f":"H26*15%","v":0},null,null,{"$f":"K26*15%","v":0},{"$f":"L26*15%","v":0}]
["TOTAL PRICING STRUCTURE (INCL VAT)",{"$nulls":3},{"$f":"E26+E27","v":0},null,null,{"$f":"SUM(H26:H27)","v":0},null,null,{"$f":"SUM(K26:K27)","v":0},{"$f":"L26+L27","v":0}]
[]
["PRICING STRUCTURE FOR OTHER AUDIT RELATED SERVICES"]
[null,null,"Year 1 (2023-2024)",null,null,"Year 2 (2024-2025)",null,null,"Year 3 (2025-2026)",null,null,"TOTAL PROPOSED COSTING","COMMENTS"]
["AUDIT TEAM COMPOSITION","PAX","EST HOURS","EST RATE","TOTAL","EST HOURS","EST RATE","TOTAL","EST HOURS","EST RATE","TOTAL"]
["Engagement Partner",{"$f":"+'[1]Cost Estimates'!D38","v":1},5,{"$f":"+'Rates Estimation'!$C$26","v":0},{"$f":"C33*D33","v":0},{"$f":"+C33*90%","v":{"v":4.5,"d":"5"}},{"$f":"+'Rates Estimation'!$D$26","v":0},{"$f":"F33*G33","v":0},{"$f":"+F33","v":{"v":4.5,"d":"5"}},{"$f":"+'Rates Estimation'!$E$26","v":0},{"$f":"I33*J33","v":0},{"$f":"E33+H33+K33","v":0}]
["Senior  Manager",{"$f":"+'[1]Cost Estimates'!D39","v":1},6,{"$f":"+'Rates Estimation'!$C$27","v":0},0,{"$f":"+C34*90%","v":{"v":5.4,"d":"5"}},{"$f":"+'Rates Estimation'!$D$27","v":0},{"$f":"F34*G34","v":0},{"$f":"+F34","v":{"v":5.4,"d":"5"}},{"$f":"+'Rates Estimation'!$E$27","v":0},{"$f":"I34*J34","v":0},{"$f":"E34+H34+K34","v":0}]
["Audit Manager",{"$f":"+'[1]Cost Estimates'!D40","v":1},8,{"$f":"+'Rates Estimation'!$C$28","v":0},0,{"v":7.2,"d":"7"},{"$f":"+'Rates Estimation'!$D$28","v":0},0,{"$f":"+F35","v":{"v":7.2,"d":"7"}},{"$f":"+'Rates Estimation'!$E$28","v":0},0,0]
["Assistant Manager",0,0,{"$f":"+'Rates Estimation'!$C$29","v":0},0,0,{"$f":"+'Rates Estimation'!$D$29","v":0},{"$f":"F36*G36","v":0},{"$f":"+F36","v":0},{"$f":"+'Rates Estimation'!$E$29","v":0},0,0]
["Trainees ",2,10,{"$f":"+'Rates Estimation'!$C$30","v":0},0,9,{"$f":"+'Rates Estimation'!$D$30","v":0},0,{"$f":"+F37","v":9},{"$f":"+'Rates Estimation'!$E$30","v":0},0,0]
["SUBTOTAL (EXCL VAT)",null,{"$f":"SUM(C33:C37)","v":29},null,{"$f":"SUM(E33:E37)","v":0},{"$f":"SUM(F33:F37)","v":{"v":26.1,"d":"26"}},null,{"$f":"SUM(H33:H37)","v":0},{"$f":"SUM(I33:I37)","v":{"v":26.1,"d":"26"}},null,{"$f":"SUM(K33:K37)","v":0},{"$f":"SUM(L33:L37)","v":0}]
["Travel and Subsistence Disbursements",{"v":0.075,"d":"7.5%"},null,null,{"$f":"E38*B39","v":0},null,null,{"$f":"H38*B39","v":0},null,null,{"$f":"K38*B39","v":0},{"$f":"E39+H39+K39","v":0}]
["PRICING STRUCTURE (EXCL VAT)",{"$nulls":3},{"$f":"SUM(E38:E39)","v":0},null,null,{"$f":"SUM(H38:H39)","v":0},null,null,{"$f":"SUM(K38:K39)","v":0},{"$f":"SUM(L38:L39)","v":0},"*Place these amounts on RFQ - section 3.3"]
["VAT",{"$nulls":3},{"$f":"E40*15%","v":0},null,null,{"$f":"H40*15%","v":0},null,null,{"$f":"K40*15%","v":0},{"$f":"L40*15%","v":0}]
["TOTAL PRICING STRUCTURE (INCL VAT)",{"$nulls":3},{"$f":"E40+E41","v":0},null,null,{"$f":"SUM(H40:H41)","v":0},null,null,{"$f":"SUM(K40:K41)","v":0},{"$f":"L40+L41","v":0}]
[]
[]
["Annual Cost EXCL VAT",{"$nulls":3},{"$f":"+E26+E40+E12","v":0},null,null,{"$f":"+H26+H40+H12","v":0},null,null,{"$f":"+K26+K40+K12","v":0}]
["Annual Cost INCL VAT",{"$nulls":3},{"$f":"+E28+E42+E14","v":0},null,null,{"$f":"+H28+H42+H14","v":0},null,null,{"$f":"+K28+K42+K14","v":0}]
[]
[]
[{"$nulls":11},"PRICING GRAND TOTAL"]
[{"$nulls":7},"EXCL VAT",{"$nulls":3},{"$f":"+L26+L40+L12","v":0}]
[{"$nulls":7},"INCL VAT",{"$nulls":3},{"$f":"+L28+L42+L14","v":0}]

{"sheet":"Sheet2","index":2,"n_rows":8,"n_cols":8,"rows_kept":8,"hidden":true}
[]
[null,"Cost Per Item PA",1,2,3,4,5,"TOTAL"]
[null,"STI AUP",{"v":250000,"d":"250,000.00"},{"v":250000,"d":"250,000.00"},{"v":250000,"d":"250,000.00"},{"v":250000,"d":"250,000.00"},{"v":250000,"d":"250,000.00"},{"$f":"SUM(C3:G3)","v":{"v":1250000,"d":"1,250,000.00"}}]
[null,"CIFS Review",{"v":350000,"d":"350,000.00"},{"v":350000,"d":"350,000.00"},{"v":350000,"d":"350,000.00"},{"v":350000,"d":"350,000.00"},{"v":350000,"d":"350,000.00"},{"$f":"SUM(C4:G4)","v":{"v":1750000,"d":"1,750,000.00"}}]
[null,"Other",null,{"v":300000,"d":"300,000.00"},{"v":300000,"d":"300,000.00"},{"v":300000,"d":"300,000.00"},{"v":300000,"d":"300,000.00"},{"$f":"SUM(C5:G5)","v":{"v":1200000,"d":"1,200,000.00"}}]
[{"$nulls":6},"TOTAL EXCL VAT",{"$f":"SUM(H3:H5)","v":{"v":4200000,"d":"4,200,000.00"}}]
[{"$nulls":6},"VAT",{"$f":"H6*15%","v":{"v":630000,"d":"630,000.00"}}]
[{"$nulls":6},"TOTAL INCL VAT",{"$f":"SUM(H6:H7)","v":{"v":4830000,"d":"4,830,000.00"}}]