{"text_format":"3","workbook":"xls","n_sheets":11,"sheets":["CMS BoQ","Labels & Signage List","End User Cost Estimate","End User Estimates","Supervisor","CM Technician","Senior Coding Specialist","Coding Technician","Draughtsman","Senior Draughtsman","Doc Controler "],"not_rendered":{"external_links":21,"defined_names":1071,"comments":3},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"CMS BoQ","index":0,"n_rows":34,"n_cols":9,"rows_kept":34,"merged":[[2,2,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[6,10,7,10],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,10,14,10],[15,2,15,3],[16,2,16,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[32,2,32,3]],"flags":["formulas_cached_only"]}
[]
[null,"PROJECT: PROVISION OF CONFIGURATION MANAGEMENT SERVICES CONTRACT AT KUSILE POWER STATION FOR A PERIOD OF FIVE (5) YEARS"]
[]
[null,"Item No.","Description",null,"Unit","Qty","Duration","Rate","Amount"]
[null,null,"PRELIMINARIES AND GENERAL"]
[null,1,"Fixed"]
[null,1.1,"Medicals - Entry",null,"Per Year",11,5]
[null,1.2,"Medicals - Exit",null,"Per Year",11,1]
[null,1.3,"Safety File",null,"Once Off",1]
[null,1.4,"PPE",null,"Per Year",11,5]
[null,1.5,"Security Clearance Certification (Obtained from SAPS, MIE or Accredited Institution) ",null,"Per Year",11,5]
[]
[null,2,"Time Related"]
[null,"2.1","Home-Work-Home (14 Seater Bus) - x 1No",null,"Monthly",1,60]
[null,"2.2","Light Driven Vehicle - x 1No",null,"Monthly",1,60]
[]
[]
[{"$nulls":3},"Sub-total P&Gs:"]
[]
[null,"Item No. ","Description",null,"Unit","Qty","Total Productive Hours for 5 Years","Hourly Rate","Amount"]
[]
[null,3,"NORMAL HOURS"]
[null,"3.1","CM Technician",null,"Hours/Duration",6,9760]
[null,"3.2","Senior Draughtsperson",null,"Hours/Duration",1,9760]
[null,"3.3","Coding Technician",null,"Hours/Duration",2,9760]
[null,3.4,"Documents Controller",null,"Hours/Duration",2,9760]
[null,null,"Sub-total Normal Hours:"]
[]
[null,"Item No.","Description",null,"Unit","Qty",null,"Rate","Amount"]
[null,4,"SIGNAGE AND LABELLING"]
[null,4.1,"Supply and Delivery of Labels and Signge (Refer to the attached Labels and Signage List)",null,"Sum",1]
[]
[]
[{"$nulls":7},"TOTAL AMOUNT EXCL VAT"]

{"sheet":"Labels & Signage List","index":1,"n_rows":97,"n_cols":7,"rows_kept":97,"merged":[[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,6,3],[4,4,6,4],[4,5,5,5],[4,6,6,6]],"flags":["formulas_cached_only"]}
[null,"LABELS & SIGNAGE LIST"]
[]
[null,"PROJECT: PROVISION OF CONFIGURATION MANAGEMENT SERVICES CONTRACT AT KUSILE POWER STATION FOR A PERIOD OF FIVE (5) YEARS"]
[]
[null,"Description","Size","Material Type","Estimated Quantity","Unit Price\nEach (ZAR)","Total Price ZAR"]
[]
[1,"LABELS","L x H in mm",null,null,"Price per each"]
[null,"Label Type GA","160mm x 40mm","Anodised Aluminium",{"v":5000,"d":"5,000"}]
[{"$nulls":3},"Stainless Steel",{"v":5000,"d":"5,000"}]
[null,"Backplate",null,"Anodised Aluminium",{"v":10000,"d":"10,000"}]
[]
[null,"Label Type GB","120mm x 25mm","Anodised Aluminium",{"v":1000,"d":"1,000"}]
[{"$nulls":3},"Stainless Steel",{"v":3000,"d":"3,000"}]
[null,"Backplate",null,"Anodised Aluminium",{"v":4000,"d":"4,000"}]
[]
[null,"Label Type GC","95mm x 50mm","Anodised Aluminium",1000]
[{"$nulls":3},"Stainless Steel",1000]
[null,"Backplate",null,"Anodised Aluminium",2000]
[]
[null,"Label Type GD","120mm x 50mm","Anodised Aluminium",2000]
[{"$nulls":3},"Stainless Steel",2000]
[null,"Backplate",null,"Anodised Aluminium",4000]
[]
[null,"Label Type GE","95mm x 20mm","Anodised Aluminium",1000]
[{"$nulls":3},"Stainless Steel",1000]
[null,"Backplate",null,"Anodised Aluminium",2000]
[]
[null,"Label Type GH","100mm x 50mm","Anodised Aluminium",1000]
[{"$nulls":3},"Stainless Steel",1000]
[null,"Backplate",null,"Anodised Aluminium",2000]
[]
[null,"Label Type EA ","150 + 400mm x 40mm","Plastic"]
[{"$nulls":3},"White Graflux",800]
[{"$nulls":3},"Traffolyte",800]
[]
[null,"Label Type EB","400mm x 25mm","Plastic"]
[{"$nulls":3},"White Graflux",400]
[{"$nulls":3},"Traffolyte",400]
[]
[null,"Label Type EC","75 + 160mm x 35mm","Plastic"]
[{"$nulls":3},"White Graflux",200]
[{"$nulls":3},"Traffolyte",200]
[]
[null,"Label Type ED","150mm x 40mm","Plastic"]
[{"$nulls":3},"White Graflux",200]
[{"$nulls":3},"Traffolyte",200]
[]
[null,"Label Type EE","20 + 80mm x 21mm","Plastic"]
[{"$nulls":3},"White Graflux",200]
[{"$nulls":3},"Traffolyte",200]
[]
[null,"Label Type EF","220mm x 35mm","Plastic"]
[{"$nulls":3},"White Graflux",200]
[{"$nulls":3},"Traffolyte",200]
[]
[null,"Label Type EG","45mm x 25mm","Plastic"]
[{"$nulls":3},"White Graflux",200]
[{"$nulls":3},"Traffolyte",200]
[]
[null,"Label Type EH","120mm x 50mm","Plastic"]
[{"$nulls":3},"White Graflux",200]
[{"$nulls":3},"Traffolyte",200]
[]
[null,"Label Type EI","20 + 75mm x 20mm","Plastic"]
[{"$nulls":3},"White Graflux",200]
[{"$nulls":3},"Traffolyte",200]
[]
[null,"Label Type EJ","20mm x 10mm","White Graflux",200]
[null,"Label Type EK","20mm x 10mm","White Graflux",200]
[null,"Label Type EL","20mm x 10mm","White Graflux",400]
[]
[null,"Label Type EM","1100mm x 230mm","Chromadek",800]
[]
[null,"Label Type EM.1","400mm x 250mm","Chromadek",800]
[]
[null,"Label Type EM.2","300mm x 200mm","Chromadek",800]
[]
[null,"Label Type EM.3","300mm x 200mm","Chromadek",800]
[]
[null,"Label Type EN","\"K Type\" flexible markers on 10 digit carrier strips","PVC",800]
[]
[null,"Label Type EP","This shall be used for all exterior cables to be labelled with stainless steel","Stainless Steel",800]
[]
[null,"Stencil ","20 Characters. Font to be determined (Pipe diameter or plant area)","(Heat resistant)",0]
[]
[null,"Mimic Panels",null,"Chromadek",600]
[]
[2,"KKS LABELS FITTING CONSUMABLES"]
[]
[null,"Silicon based adhesive guaranteed effectiveness for 20 years (Sikaflex 252 per 600 ml tube) ",null,null,400]
[null,"3.2mm Pop Rivets/pack of 100",null,null,100]
[null,"Stainless Steel Cable Tie (per pack of 100)",null,null,200]
[null,"Stainless Steel Cable Strap (per roll)",null,null,400]
[null,"Hose clamps (per packet of 10)","14 – 32 mm",null,1000]
[null,"Hose clamps (per packet of 10)","19 – 44 mm",null,1000]
[]
[{"$nulls":5},"This amount (Excl Vat) must be transferred to the Rate Column on the BoQ/Price List (#4.1)"]

{"sheet":"End User Cost Estimate","index":2,"n_rows":27,"n_cols":13,"rows_kept":27,"hidden":true,"merged":[[1,0,1,5],[12,0,12,6],[13,0,13,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,14,5],[13,6,14,6],[19,1,19,5],[21,0,21,2],[23,0,23,1]],"flags":["formulas_cached_only"]}
[null,"Back to Index Page"]
["COST ESTIMATION FOR BUDGET PROVISION"]
["Cost excl Vat","2024/25 FY","2025/26 FY","2026/27 FY","2027/28 FY","2028/29 FY",null,null,"Initial Budget (Excl VAT)"]
["Budget Breakdown FY",{"v":5000000,"d":"R5,000,000.00"},{"v":5000000,"d":"R5,000,000.00"},{"v":5000000,"d":"R5,000,000.00"},{"v":5000000,"d":"R5,000,000.00"},{"v":5000000,"d":"R5,000,000.00"},null,null,{"v":30000000,"d":"R30,000,000.00"},{"v":40000000,"d":"R40,000,000.00"}]
["Maintenance",{"v":750000,"d":"R750,000.00"},{"v":750000,"d":"R750,000.00"},{"v":750000,"d":"R750,000.00"},{"v":750000,"d":"R750,000.00"},{"v":750000,"d":"R750,000.00"},null,null,"Short Fall Amount"]
["Contigency",{"v":250000,"d":"R250,000.00"},{"v":250000,"d":"R250,000.00"},{"v":250000,"d":"R250,000.00"},{"v":250000,"d":"R250,000.00"},{"v":250000,"d":"R250,000.00"},null,null,{"v":28210629.555336736,"d":"R28,210,629.56"},{"v":6348600.851730607,"d":"R6,348,600.85"}]
["Total Value (excl VAT)",{"v":6000000,"d":"R6,000,000.00"},{"v":6000000,"d":"R6,000,000.00"},{"v":6000000,"d":"R6,000,000.00"},{"v":6000000,"d":"R6,000,000.00"},{"v":6000000,"d":"R6,000,000.00"},null,"Labour",{"v":42064248.93533674,"d":"R42,064,248.94"},{"v":33651399.14826939,"d":"R33,651,399.15"}]
["GL Account",{"$nulls":4},{"v":30000000,"d":"R30,000,000.00"},null,"Premilinary and General ",{"v":13065250,"d":"R13,065,250.00"}]
[{"$nulls":7},"Maintenance",{"v":3081130.62,"d":"R3,081,130.62"}]
[{"$nulls":7},"Total Contract Cost",{"v":58210629.555336736,"d":"R58,210,629.56"}]
[{"$nulls":7},"Term (Years)",5]
[]
["TIME BASED SERVICE COST BREAKDOWN"]
["Resource Type",null,"Total hr/resource/month","Total months","QTY","Base rate/hr","Total"]
["Contract Title","Operations Title"]
["CM Technician",null,{"v":173.6,"d":"174"},60,6,{"v":418.0675270293256,"d":"R418.07"},{"v":26127548.169224735,"d":"R26,127,548.17"},"Value per year",{"v":6000000,"d":"R6,000,000.00"},{"v":83.61350540586513,"d":"R83.61"},{"v":0.2,"d":"20%"},{"v":334.4540216234605,"d":"R334.45"},{"v":20902038.53537979,"d":"R20,902,038.54"}]
["Senior Draughtsman",null,{"v":173.6,"d":"174"},60,1,{"v":418.8243414872225,"d":"R418.82"},{"v":4362474.34093091,"d":"R4,362,474.34"},"Total Budget",{"v":58210629.555336736,"d":"R58,210,629.56"},{"v":83.76486829744451,"d":"R83.76"},{"v":0.2,"d":"20%"},{"v":335.05947318977803,"d":"R335.06"},{"v":3489979.472744728,"d":"R3,489,979.47"}]
["Doc Controler",null,{"v":173.6,"d":"174"},60,2,{"v":232.5191653623796,"d":"R232.52"},{"v":4843839.252829092,"d":"R4,843,839.25"},"Budget per year",{"v":5000000,"d":"R5,000,000.00"},{"v":46.50383307247592,"d":"R46.50"},{"v":0.2,"d":"20%"},{"v":186.01533228990368,"d":"R186.02"},{"v":3875071.4022632735,"d":"R3,875,071.40"}]
["Coding Technician",null,{"v":173.6,"d":"174"},60,2,{"v":323.0792613456221,"d":"R323.08"},{"v":6730387.172352,"d":"R6,730,387.17"},"Contrigency per FY",{"v":250000,"d":"R250,000.00"},{"v":64.61585226912443,"d":"R64.62"},{"v":0.2,"d":"20%"},{"v":258.46340907649767,"d":"R258.46"},{"v":5384309.737881599,"d":"R5,384,309.74"}]
[{"$nulls":6},{"v":42064248.93533674,"d":"R42,064,248.94"},{"$nulls":5},{"v":33651399.14826939,"d":"R33,651,399.15"}]
[]
["NB: Rates might change based on the Quantitive Surveyor's cost estimates"]
[]
["Resources/Week/Month "]
["Working hrs/per week",40]
["Weeks per month ",4.34]
["Working hrs/month ",{"v":173.6,"d":"174"}]

{"sheet":"End User Estimates","index":3,"n_rows":18,"n_cols":10,"rows_kept":18,"hidden":true,"merged":[[17,0,17,6]],"flags":["formulas_cached_only"]}
[]
["Item","Description","UoM","Number ","Months","QTY","Rate","Total"]
[1,"CM Technician","hour",6,60,{"v":173.6,"d":"174"},{"v":272.3356138787879,"d":"R 272.34"},{"v":17019886.52496873,"d":"R 17,019,886.52"},{"v":206.64947407272726,"d":"206.65"},{"v":12914765.531649163,"d":"R 12,914,765.53"}]
[2,"Senior Draughtsman","hour",1,60,{"v":173.6,"d":"174"},{"v":143.2874647636363,"d":"R 143.29"},{"v":1492482.2329780357,"d":"R 1,492,482.23"},{"v":215.43725781818182,"d":"215.44"},{"v":2243994.4774341816,"d":"R 2,243,994.48"}]
[3,"Doc Controler","hour",2,60,{"v":173.6,"d":"174"},{"v":215.43725781818182,"d":"R 215.44"},{"v":4487988.954868363,"d":"R 4,487,988.95"},{"v":326.80273665454547,"d":"326.80"},{"v":6807954.609987491,"d":"R 6,807,954.61"}]
[4,"Coding Technician ","hour",2,60,{"v":173.6,"d":"174"},{"v":206.64947407272726,"d":"R 206.65"},{"v":4304921.843883054,"d":"R 4,304,921.84"},{"v":301.4515067636363,"d":"301.45"},{"v":6279837.788900072,"d":"R 6,279,837.79"}]
[{"$nulls":7},{"v":27305279.55669818,"d":"R 27,305,279.56"},null,{"v":28246552.407970905,"d":"R 28,246,552.41"}]
[null,"Preliminaries and General"]
[6,"Safety File","sum",null,null,1,{"v":20000,"d":"R 20,000.00"},{"v":20000,"d":"R 20,000.00"}]
[7,"PPE (every year)","ea",5,null,10,{"v":1800,"d":"R 1,800.00"},{"v":90000,"d":"R 90,000.00"}]
[8,"Medicals (annual and exit)","ea",5,null,11,{"v":950,"d":"R 950.00"},{"v":52250,"d":"R 52,250.00"}]
[9,"Accommodation (allowance per person)","ea",null,60,11,{"v":3000,"d":"R 3,000.00"},{"v":1980000,"d":"R 1,980,000.00"}]
[10,"Transportation (10 seater)","ea",null,60,11,{"v":15000,"d":"R 15,000.00"},{"v":9900000,"d":"R 9,900,000.00"}]
[11,"Travelling","km",31,60,100,{"v":5.5,"d":"R 5.50"},{"v":1023000,"d":"R 1,023,000.00"}]
[{"$nulls":7},{"v":13065250,"d":"R 13,065,250.00"},null,{"v":13065250,"d":"R 13,065,250.00"}]
[{"$nulls":7},{"v":40370529.55669818,"d":"R 40,370,529.56"},null,{"v":41311802.407970905,"d":"R 41,311,802.41"}]
[]
["Note that no allowance has been included for hardware/equipment required."]

{"sheet":"Supervisor","index":4,"n_rows":42,"n_cols":11,"rows_kept":42,"hidden":true,"flags":["formulas_cached_only"]}
[]
[]
[null,null,"\"Maintenance Supervisor\"",{"$nulls":6},"2025-05-28"]
[]
[]
[null,1,"Notes:"]
[null,null,"o","Based on human resources median (50%)"]
[{"$nulls":3},"R 203.42 / hr. for say 40 hr. per week at 4.34 weeks per mth."]
[null,null,"o","Some items valued as \"reasonable assessment\" of the requirements"]
[{"$nulls":3},"and are not the exact legal minimum."]
[]
[null,2,"Minimum cost to company benefits",{"$nulls":6},"per month"]
[]
[null,null,2.1,"Minimum monthly nett (basic):"]
[{"$nulls":4},"(40 hrs worked per week @  R 118.22  /h)"]
[{"$nulls":4},"Hrs per mth = 40 x 4.34 = 172 hrs x R 203.42",{"$nulls":4},{"v":35313.712,"d":"R 35,313.71"}]
[null,null,2.2,"Leave:  (21 days per year)"]
[{"$nulls":4},"21/(12 x 22) x R 35 313.71",{"$nulls":4},{"v":2809.0452727272727,"d":"2,809.05"}]
[null,null,2.3,"Sick pay:  (say 1 day per mth)"]
[{"$nulls":4},"1/22 x R 35 313.71",{"$nulls":4},{"v":1605.1687272727272,"d":"1,605.17"}]
[null,null,2.4,"Family responsibility:  (say 4 days per year)"]
[{"$nulls":4},"4/(12 x 22) x R 35 313.71",{"$nulls":4},{"v":535.0562424242424,"d":"535.06"}]
[null,null,2.5,"Provident fund:"]
[{"$nulls":4},"5.25 % x R 35 313.71",{"$nulls":4},{"v":1853.9698799999999,"d":"1,853.97"}]
[null,null,2.6,"Bonus:  (extra salary)"]
[{"$nulls":4},"1/12 x R 35 313.71",{"$nulls":4},{"v":2942.809333333333,"d":"2,942.81"}]
[null,null,2.7,"UIF:"]
[{"$nulls":4},"1.0 % x R 35 313.71",{"$nulls":4},{"v":353.13712,"d":"353.14"}]
[null,null,2.8,"COID / WCA:"]
[{"$nulls":4},"4.28 % x R 35 313.71",{"$nulls":4},{"v":1511.4268736,"d":"1,511.43"}]
[null,null,2.9,"SDL :"]
[{"$nulls":4},"1.0 % x R 35 313.71",{"$nulls":4},{"v":353.13712,"d":"353.14"}]
[{"$nulls":9},{"v":47277.46256935757,"d":"47,277.46"}]
[]
[null,null,{"v":2.1,"d":"2.10"},"Convert to rate per hr  ( / 40 hrs / 4.34 wks)",{"$nulls":4},"R",{"v":272.3356138787879,"d":"272.34"},"/hr"]
[]
[null,3,"Allow for 20 % Overheads and Profit - SAY"]
[{"$nulls":4},"x 1.20",{"$nulls":3},"R",{"v":326.80273665454547,"d":"326.80"},"/hr"]
[]
[{"$nulls":8},"Normal Over time",{"v":366.156,"d":"R 366.16"}]
[]
[{"$nulls":8},"Sunday and Public Holiday Overtime",{"v":488.20799999999997,"d":"R 488.21"}]

{"sheet":"CM Technician","index":5,"n_rows":42,"n_cols":15,"rows_kept":42,"hidden":true,"flags":["formulas_cached_only"]}
[]
[]
[null,null,"\"CM Technician\"",{"$nulls":6},"2025-05-28"]
[]
[]
[null,1,"Notes:"]
[null,null,"o","Based on human resources median (50%)"]
[{"$nulls":3},"R 128.63/ hr. for say 40 hr. per week at 4.34 weeks per mth."]
[null,null,"o","Some items valued as \"reasonable assessment\" of the requirements"]
[{"$nulls":3},"and are not the exact legal minimum."]
[]
[null,2,"Minimum cost to company benefits",{"$nulls":6},"per month"]
[]
[null,null,2.1,"Minimum monthly nett (basic):"]
[{"$nulls":4},"(40 hrs worked per week @  R 128.63 /h)",{"$nulls":7},{"v":259.63,"d":"R259.63"}]
[{"$nulls":4},"Hrs per mth = 40 x 4.34 = 173.6 hrs x R 128.63",{"$nulls":4},{"v":22330.167999999998,"d":"R 22,330.17"},174,{"v":259.63,"d":"R259.63"},{"v":45175.62,"d":"R45,175.62"}]
[null,null,2.2,"Leave:  (21 days per year)"]
[{"$nulls":4},"21/(12 x 22) x R 22 330.17",{"$nulls":4},{"v":1776.2633636363635,"d":"1,776.26"},null,null,{"v":3593.5152272727273,"d":"R3,593.52"}]
[null,null,2.3,"Sick pay:  (say 1 day per mth)"]
[{"$nulls":4},"1/22 x R 22 330.17",{"$nulls":4},{"v":1015.0076363636363,"d":"1,015.01"},null,null,{"v":2053.437272727273,"d":"R2,053.44"}]
[null,null,2.4,"Family responsibility:  (say 4 days per year)"]
[{"$nulls":4},"4/(12 x 22) x R 22 330.17",{"$nulls":4},{"v":338.33587878787876,"d":"338.34"},null,null,{"v":684.4790909090909,"d":"R684.48"}]
[null,null,2.5,"Provident fund:"]
[{"$nulls":4},"5.25 % x R 22 330.17",{"$nulls":4},{"v":1172.3338199999998,"d":"1,172.33"},null,null,{"v":2371.72005,"d":"R2,371.72"}]
[null,null,2.6,"Bonus:  (extra salary)"]
[{"$nulls":4},"1/12 x R 22 330.17",{"$nulls":4},{"v":1860.8473333333332,"d":"1,860.85"},null,null,{"v":3764.635,"d":"R3,764.64"}]
[null,null,2.7,"UIF:"]
[{"$nulls":4},"1.0 % x R 22 330.17",{"$nulls":4},{"v":223.30167999999998,"d":"223.30"},null,null,{"v":451.75620000000004,"d":"R451.76"}]
[null,null,2.8,"COID / WCA:"]
[{"$nulls":4},"4.28 % x R 22 330.17",{"$nulls":4},{"v":955.7311903999998,"d":"955.73"},null,null,{"v":1933.5165360000003,"d":"R1,933.52"}]
[null,null,2.9,"SDL :"]
[{"$nulls":4},"1.0 % x R 22 330.17",{"$nulls":4},{"v":223.30167999999998,"d":"223.30"},null,null,{"v":451.75620000000004,"d":"R451.76"}]
[{"$nulls":9},{"v":29895.29058252121,"d":"29,895.29"},null,null,{"v":60480.435576909105,"d":"R60,480.44"}]
[]
[null,null,{"v":2.1,"d":"2.10"},"Convert to rate per hr  ( / 40 hrs / 4.34 wks)",{"$nulls":4},"R",{"v":172.20789506060606,"d":"172.21"},"/hr",null,{"v":348.38960585777136,"d":"348.39"}]
[]
[null,3,"Allow for 20 % Overheads and Profit - SAY"]
[{"$nulls":4},"x 1.20",{"$nulls":3},"R",{"v":206.64947407272726,"d":"206.65"},"/hr",null,418.0675270293256,{"v":418.5,"d":"R418.50"},{"v":334.5,"d":"R334.50"}]
[]
[{"$nulls":8},"Normal Over time",{"v":231.534,"d":"R 231.53"},null,null,{"v":467.33399999999995,"d":"R467.33"}]
[]
[{"$nulls":8},"Sunday and Public Holiday Overtime",{"v":308.712,"d":"R 308.71"},null,null,{"v":623.112,"d":"R623.11"}]

{"sheet":"Senior Coding Specialist","index":6,"n_rows":42,"n_cols":11,"rows_kept":42,"hidden":true,"flags":["formulas_cached_only"]}
[]
[]
[null,null,"\"Senior Coding Specialist\"",{"$nulls":6},"2025-05-28"]
[]
[]
[null,1,"Notes:"]
[null,null,"o","Based on human resources median (50%)"]
[{"$nulls":3},"R 187.64/ hr. for say 40 hr. per week at 4.34 weeks per mth."]
[null,null,"o","Some items valued as \"reasonable assessment\" of the requirements"]
[{"$nulls":3},"and are not the exact legal minimum."]
[]
[null,2,"Minimum cost to company benefits",{"$nulls":6},"per month"]
[]
[null,null,2.1,"Minimum monthly nett (basic):"]
[{"$nulls":4},"(40 hrs worked per week @  R 187.64 /h)"]
[{"$nulls":4},"Hrs per mth = 40 x 4.34 = 173.6 hrs x R 187.64",{"$nulls":4},{"v":32574.303999999996,"d":"R 32,574.30"}]
[null,null,2.2,"Leave:  (21 days per year)"]
[{"$nulls":4},"21/(12 x 22) x R 32 574.30",{"$nulls":4},{"v":2591.1378181818177,"d":"2,591.14"}]
[null,null,2.3,"Sick pay:  (say 1 day per mth)"]
[{"$nulls":4},"1/22 x R 32 574.30",{"$nulls":4},{"v":1480.6501818181816,"d":"1,480.65"}]
[null,null,2.4,"Family responsibility:  (say 4 days per year)"]
[{"$nulls":4},"4/(12 x 22) x R 32 574.30",{"$nulls":4},{"v":493.5500606060606,"d":"493.55"}]
[null,null,2.5,"Provident fund:"]
[{"$nulls":4},"5.25 % x R 32 574.30",{"$nulls":4},{"v":1710.1509599999997,"d":"1,710.15"}]
[null,null,2.6,"Bonus:  (extra salary)"]
[{"$nulls":4},"1/12 x R 32 574.30",{"$nulls":4},{"v":2714.525333333333,"d":"2,714.53"}]
[null,null,2.7,"UIF:"]
[{"$nulls":4},"1.0 % x R 32 574.30",{"$nulls":4},{"v":325.74303999999995,"d":"325.74"}]
[null,null,2.8,"COID / WCA:"]
[{"$nulls":4},"4.28 % x R 32 574.30",{"$nulls":4},{"v":1394.1802111999998,"d":"1,394.18"}]
[null,null,2.9,"SDL :"]
[{"$nulls":4},"1.0 % x R 32 574.30",{"$nulls":4},{"v":325.74303999999995,"d":"325.74"}]
[{"$nulls":9},{"v":43609.98464513938,"d":"43,609.98"}]
[]
[null,null,{"v":2.1,"d":"2.10"},"Convert to rate per hr  ( / 40 hrs / 4.34 wks)",{"$nulls":4},"R",{"v":251.2095889696969,"d":"251.21"},"/hr"]
[]
[null,3,"Allow for 20 % Overheads and Profit - SAY"]
[{"$nulls":4},"x 1.20",{"$nulls":3},"R",{"v":301.4515067636363,"d":"301.45"},"/hr"]
[]
[{"$nulls":8},"Normal Over time",{"v":337.75199999999995,"d":"R 337.75"}]
[]
[{"$nulls":8},"Sunday and Public Holiday Overtime",{"v":450.33599999999996,"d":"R 450.34"}]

{"sheet":"Coding Technician","index":7,"n_rows":42,"n_cols":14,"rows_kept":42,"hidden":true,"flags":["formulas_cached_only"]}
[]
[]
[null,null,"\"Coding Technician\"",{"$nulls":6},"2025-05-28"]
[]
[]
[null,1,"Notes:"]
[null,null,"o","Based on human resources median (50%)"]
[{"$nulls":3},"R 187.64/ hr. for say 40 hr. per week at 4.34 weeks per mth."]
[null,null,"o","Some items valued as \"reasonable assessment\" of the requirements"]
[{"$nulls":3},"and are not the exact legal minimum."]
[]
[null,2,"Minimum cost to company benefits",{"$nulls":6},"per month"]
[]
[null,null,2.1,"Minimum monthly nett (basic):"]
[{"$nulls":4},"(40 hrs worked per week @  R 187.64 /h)",{"$nulls":7},{"v":200.64,"d":"R200.64"}]
[{"$nulls":4},"Hrs per mth = 40 x 4.34 = 173.6 hrs x R 187.64",{"$nulls":4},{"v":32574.303999999996,"d":"R 32,574.30"},174,null,{"v":34911.36,"d":"R34,911.36"}]
[null,null,2.2,"Leave:  (21 days per year)"]
[{"$nulls":4},"21/(12 x 22) x R 32 574.30",{"$nulls":4},{"v":2591.1378181818177,"d":"2,591.14"},null,null,{"v":2777.04,"d":"R2,777.04"}]
[null,null,2.3,"Sick pay:  (say 1 day per mth)"]
[{"$nulls":4},"1/22 x R 32 574.30",{"$nulls":4},{"v":1480.6501818181816,"d":"1,480.65"},null,null,{"v":1586.88,"d":"R1,586.88"}]
[null,null,2.4,"Family responsibility:  (say 4 days per year)"]
[{"$nulls":4},"4/(12 x 22) x R 32 574.30",{"$nulls":4},{"v":493.5500606060606,"d":"493.55"},null,null,{"v":528.96,"d":"R528.96"}]
[null,null,2.5,"Provident fund:"]
[{"$nulls":4},"5.25 % x R 32 574.30",{"$nulls":4},{"v":1710.1509599999997,"d":"1,710.15"},null,null,{"v":1832.8464,"d":"R1,832.85"}]
[null,null,2.6,"Bonus:  (extra salary)"]
[{"$nulls":4},"1/12 x R 32 574.30",{"$nulls":4},{"v":2714.525333333333,"d":"2,714.53"},null,null,{"v":2909.2799999999997,"d":"R2,909.28"}]
[null,null,2.7,"UIF:"]
[{"$nulls":4},"1.0 % x R 32 574.30",{"$nulls":4},{"v":325.74303999999995,"d":"325.74"},null,null,{"v":349.1136,"d":"R349.11"}]
[null,null,2.8,"COID / WCA:"]
[{"$nulls":4},"4.28 % x R 32 574.30",{"$nulls":4},{"v":1394.1802111999998,"d":"1,394.18"},null,null,{"v":1494.2062080000003,"d":"R1,494.21"}]
[null,null,2.9,"SDL :"]
[{"$nulls":4},"1.0 % x R 32 574.30",{"$nulls":4},{"v":325.74303999999995,"d":"325.74"},null,null,{"v":349.1136,"d":"R349.11"}]
[{"$nulls":9},{"v":43609.98464513938,"d":"43,609.98"},null,null,{"v":46738.799807999996,"d":"R46,738.80"}]
[]
[null,null,{"v":2.1,"d":"2.10"},"Convert to rate per hr  ( / 40 hrs / 4.34 wks)",{"$nulls":4},"R",{"v":251.2095889696969,"d":"251.21"},"/hr",null,{"v":269.2327177880184,"d":"269.23"}]
[]
[null,3,"Allow for 20 % Overheads and Profit - SAY"]
[{"$nulls":4},"x 1.20",{"$nulls":3},"R",{"v":301.4515067636363,"d":"301.45"},"/hr",null,{"v":323.0792613456221,"d":"R323.08"},{"v":446.4,"d":"R446.40"}]
[]
[{"$nulls":8},"Normal Over time",{"v":337.75199999999995,"d":"R 337.75"},null,null,{"v":361.152,"d":"R361.15"}]
[]
[{"$nulls":8},"Sunday and Public Holiday Overtime",{"v":450.33599999999996,"d":"R 450.34"},null,null,{"v":481.53599999999994,"d":"R481.54"}]

{"sheet":"Draughtsman","index":8,"n_rows":42,"n_cols":11,"rows_kept":42,"hidden":true,"flags":["formulas_cached_only"]}
[]
[]
[null,null,"\"Draughtsman\"",{"$nulls":6},"2025-05-28"]
[]
[]
[null,1,"Notes:"]
[null,null,"o","Based on human resources median (50%)"]
[{"$nulls":3},"R 89.19/ hr. for say 40 hr. per week at 4.34 weeks per mth."]
[null,null,"o","Some items valued as \"reasonable assessment\" of the requirements"]
[{"$nulls":3},"and are not the exact legal minimum."]
[]
[null,2,"Minimum cost to company benefits",{"$nulls":6},"per month"]
[]
[null,null,2.1,"Minimum monthly nett (basic):"]
[{"$nulls":4},"(40 hrs worked per week @  R 89.19 /h)"]
[{"$nulls":4},"Hrs per mth = 40 x 4.34 = 173.6 hrs x R 89.19",{"$nulls":4},{"v":15483.383999999998,"d":"R 15,483.38"}]
[null,null,2.2,"Leave:  (21 days per year)"]
[{"$nulls":4},"21/(12 x 22) x R 15 483.38",{"$nulls":4},{"v":1231.632818181818,"d":"1,231.63"}]
[null,null,2.3,"Sick pay:  (say 1 day per mth)"]
[{"$nulls":4},"1/22 x R 15 483.38",{"$nulls":4},{"v":703.7901818181817,"d":"703.79"}]
[null,null,2.4,"Family responsibility:  (say 4 days per year)"]
[{"$nulls":4},"4/(12 x 22) x R 15 483.38",{"$nulls":4},{"v":234.59672727272726,"d":"234.60"}]
[null,null,2.5,"Provident fund:"]
[{"$nulls":4},"5.25 % x R 15 483.38",{"$nulls":4},{"v":812.8776599999999,"d":"812.88"}]
[null,null,2.6,"Bonus:  (extra salary)"]
[{"$nulls":4},"1/12 x R 15 483.38",{"$nulls":4},{"v":1290.282,"d":"1,290.28"}]
[null,null,2.7,"UIF:"]
[{"$nulls":4},"1.0 % x R 15 483.38",{"$nulls":4},{"v":154.83383999999998,"d":"154.83"}]
[null,null,2.8,"COID / WCA:"]
[{"$nulls":4},"4.28 % x R 15 483.38",{"$nulls":4},{"v":662.6888351999999,"d":"662.69"}]
[null,null,2.9,"SDL :"]
[{"$nulls":4},"1.0 % x R 15 483.38",{"$nulls":4},{"v":154.83383999999998,"d":"154.83"}]
[{"$nulls":9},{"v":20728.91990247272,"d":"20,728.92"}]
[]
[null,null,{"v":2.1,"d":"2.10"},"Convert to rate per hr  ( / 40 hrs / 4.34 wks)",{"$nulls":4},"R",{"v":119.4062206363636,"d":"119.41"},"/hr"]
[]
[null,3,"Allow for 20 % Overheads and Profit - SAY"]
[{"$nulls":4},"x 1.20",{"$nulls":3},"R",{"v":143.2874647636363,"d":"143.29"},"/hr"]
[]
[{"$nulls":8},"Normal Over time",{"v":160.542,"d":"R 160.54"}]
[]
[{"$nulls":8},"Sunday and Public Holiday Overtime",{"v":214.05599999999998,"d":"R 214.06"}]

{"sheet":"Senior Draughtsman","index":9,"n_rows":42,"n_cols":13,"rows_kept":42,"hidden":true,"flags":["formulas_cached_only"]}
[]
[]
[null,null,"\"Senior Draughtsman\"",{"$nulls":6},"2025-05-28"]
[]
[]
[null,1,"Notes:"]
[null,null,"o","Based on human resources median (50%)"]
[{"$nulls":3},"R 134.10/ hr. for say 40 hr. per week at 4.34 weeks per mth."]
[null,null,"o","Some items valued as \"reasonable assessment\" of the requirements"]
[{"$nulls":3},"and are not the exact legal minimum."]
[]
[null,2,"Minimum cost to company benefits",{"$nulls":6},"per month"]
[]
[null,null,2.1,"Minimum monthly nett (basic):"]
[{"$nulls":4},"(40 hrs worked per week @  R 134.10 /h)",{"$nulls":7},{"v":260.1,"d":"R260.10"}]
[{"$nulls":4},"Hrs per mth = 40 x 4.34 = 173.6 hrs x R 134.10",{"$nulls":4},{"v":23279.76,"d":"R 23,279.76"},null,null,{"v":45257.4,"d":"R45,257.40"}]
[null,null,2.2,"Leave:  (21 days per year)"]
[{"$nulls":4},"21/(12 x 22) x R 23 279.76",{"$nulls":4},{"v":1851.7990909090909,"d":"1,851.80"},null,null,{"v":3600.0204545454544,"d":"R3,600.02"}]
[null,null,2.3,"Sick pay:  (say 1 day per mth)"]
[{"$nulls":4},"1/22 x R 23 279.76",{"$nulls":4},{"v":1058.170909090909,"d":"1,058.17"},null,null,{"v":2057.1545454545458,"d":"R2,057.15"}]
[null,null,2.4,"Family responsibility:  (say 4 days per year)"]
[{"$nulls":4},"4/(12 x 22) x R 23 279.76",{"$nulls":4},{"v":352.72363636363633,"d":"352.72"},null,null,{"v":685.7181818181818,"d":"R685.72"}]
[null,null,2.5,"Provident fund:"]
[{"$nulls":4},"5.25 % x R 23 279.76",{"$nulls":4},{"v":1222.1873999999998,"d":"1,222.19"},null,null,{"v":2376.0135,"d":"R2,376.01"}]
[null,null,2.6,"Bonus:  (extra salary)"]
[{"$nulls":4},"1/12 x R 23 279.76",{"$nulls":4},{"v":1939.9799999999998,"d":"1,939.98"},null,null,{"v":3771.45,"d":"R3,771.45"}]
[null,null,2.7,"UIF:"]
[{"$nulls":4},"1.0 % x R 23 279.76",{"$nulls":4},{"v":232.7976,"d":"232.80"},null,null,{"v":452.574,"d":"R452.57"}]
[null,null,2.8,"COID / WCA:"]
[{"$nulls":4},"4.28 % x R 23 279.76",{"$nulls":4},{"v":996.3737279999999,"d":"996.37"},null,null,{"v":1937.0167200000003,"d":"R1,937.02"}]
[null,null,2.9,"SDL :"]
[{"$nulls":4},"1.0 % x R 23 279.76",{"$nulls":4},{"v":232.7976,"d":"232.80"},null,null,{"v":452.574,"d":"R452.57"}]
[{"$nulls":9},{"v":31166.589964363637,"d":"31,166.59"},null,null,{"v":60589.92140181819,"d":"R60,589.92"}]
[]
[null,null,{"v":2.1,"d":"2.10"},"Convert to rate per hr  ( / 40 hrs / 4.34 wks)",{"$nulls":4},"R",{"v":179.5310481818182,"d":"179.53"},"/hr",null,{"v":349.02028457268545,"d":"349.02"}]
[]
[null,3,"Allow for 20 % Overheads and Profit - SAY"]
[{"$nulls":4},"x 1.20",{"$nulls":3},"R",{"v":215.43725781818182,"d":"215.44"},"/hr",null,{"v":418.8243414872225,"d":"R418.82"}]
[]
[{"$nulls":8},"Normal Over time",{"v":241.37999999999997,"d":"R 241.38"},null,null,{"v":468.18,"d":"R468.18"}]
[]
[{"$nulls":8},"Sunday and Public Holiday Overtime",{"v":321.84,"d":"R 321.84"},null,null,{"v":624.24,"d":"R624.24"}]

{"sheet":"Doc Controler ","index":10,"n_rows":42,"n_cols":14,"rows_kept":42,"hidden":true,"flags":["formulas_cached_only"]}
[]
[]
[null,null,"\"Doc Controler\"",{"$nulls":6},"2025-05-28"]
[]
[]
[null,1,"Notes:"]
[null,null,"o","Based on human resources median (50%)"]
[{"$nulls":3},"R 203.42 / hr. for say 40 hr. per week at 4.34 weeks per mth."]
[null,null,"o","Some items valued as \"reasonable assessment\" of the requirements"]
[{"$nulls":3},"and are not the exact legal minimum."]
[]
[null,2,"Minimum cost to company benefits",{"$nulls":6},"per month"]
[{"$nulls":12},"Estimates ("]
[null,null,2.1,"Minimum monthly nett (basic):"]
[{"$nulls":4},"(40 hrs worked per week @  R 118.22  /h)",{"$nulls":7},{"v":144.4,"d":"R144.40"}]
[{"$nulls":4},"Hrs per mth = 40 x 4.34 = 172 hrs x R 203.42",{"$nulls":4},{"v":35313.712,"d":"R 35,313.71"},174,null,{"v":25125.600000000002,"d":"R25,125.60"}]
[null,null,2.2,"Leave:  (21 days per year)"]
[{"$nulls":4},"21/(12 x 22) x R 35 313.71",{"$nulls":4},{"v":2809.0452727272727,"d":"2,809.05"},null,null,{"v":1998.6272727272728,"d":"R1,998.63"}]
[null,null,2.3,"Sick pay:  (say 1 day per mth)"]
[{"$nulls":4},"1/22 x R 35 313.71",{"$nulls":4},{"v":1605.1687272727272,"d":"1,605.17"},null,null,{"v":1142.0727272727274,"d":"R1,142.07"}]
[null,null,2.4,"Family responsibility:  (say 4 days per year)"]
[{"$nulls":4},"4/(12 x 22) x R 35 313.71",{"$nulls":4},{"v":535.0562424242424,"d":"535.06"},null,null,{"v":380.69090909090914,"d":"R380.69"}]
[null,null,2.5,"Provident fund:"]
[{"$nulls":4},"5.25 % x R 35 313.71",{"$nulls":4},{"v":1853.9698799999999,"d":"1,853.97"},null,null,{"v":1319.094,"d":"R1,319.09"}]
[null,null,2.6,"Bonus:  (extra salary)"]
[{"$nulls":4},"1/12 x R 35 313.71",{"$nulls":4},{"v":2942.809333333333,"d":"2,942.81"},null,null,{"v":2093.8,"d":"R2,093.80"}]
[null,null,2.7,"UIF:"]
[{"$nulls":4},"1.0 % x R 35 313.71",{"$nulls":4},{"v":353.13712,"d":"353.14"},null,null,{"v":251.25600000000003,"d":"R251.26"}]
[null,null,2.8,"COID / WCA:"]
[{"$nulls":4},"4.28 % x R 35 313.71",{"$nulls":4},{"v":1511.4268736,"d":"1,511.43"},null,null,{"v":1075.37568,"d":"R1,075.38"}]
[null,null,2.9,"SDL :"]
[{"$nulls":4},"1.0 % x R 35 313.71",{"$nulls":4},{"v":353.13712,"d":"353.14"},null,null,{"v":251.25600000000003,"d":"R251.26"}]
[{"$nulls":9},{"v":47277.46256935757,"d":"47,277.46"},null,null,{"v":33637.77258909091,"d":"R33,637.77"}]
[]
[null,null,{"v":2.1,"d":"2.10"},"Convert to rate per hr  ( / 40 hrs / 4.34 wks)",{"$nulls":4},"R",{"v":272.3356138787879,"d":"272.34"},"/hr",null,{"v":193.76597113531633,"d":"193.77"}]
[]
[null,3,"Allow for 20 % Overheads and Profit - SAY"]
[{"$nulls":4},"x 1.20",{"$nulls":3},"R",{"v":326.80273665454547,"d":"326.80"},"/hr",null,{"v":232.5191653623796,"d":"R232.52"},{"v":232.5,"d":"R232.50"}]
[]
[{"$nulls":8},"Normal Over time",{"v":366.156,"d":"R 366.16"},null,null,{"v":259.92,"d":"R259.92"}]
[]
[{"$nulls":8},"Sunday and Public Holiday Overtime",{"v":488.20799999999997,"d":"R 488.21"},null,null,{"v":346.56,"d":"R346.56"}]