{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,5]],"flags":["formulas_cached_only"]}
["Calculating Actual Cost of Chargeable Time"]
[]
[null,null,1,"Days in a normal year",365]
[null,null,2,"Week days in a normal year",260.7142857142857]
[]
[null,null,"Holidays & Sick/Special Leave"]
[null,null,3,"Annual Leave (days)",20]
[null,null,4,"Statutory Holidays",11]
[null,null,5,"Sick/Special Leave entitlement",10]
[null,null,6,"Total Leave entitlement",41]
[]
[null,null,"Training Courses, Conferences, etc."]
[null,null,7,"Training courses & other unavailable days",5]
[null,null,8,"Total Unavailable days",46]
[]
[null,null,9,"Normal working days in a year",214.71428571428572]
[]
[null,null,10,"Adjustment factor on working days to cover leave & unavailable",0.21423819028609437]
[]
[null,null,"Productivity Considerations"]
[null,null,11,"Average overhead (non-charged) component of workload",0.2]
[null,null,12,"Average productive (charged) component of workload",0.8]
[]
[null,null,13,"Adjustment factor on chargeable time to cover unavailable & non-charged time",0.26779773785761796]
[]
[null,null,"Example"]
[null,null,14,"Annual Salary",40000]
[null,null,15,"Divided by average number of \"Week days in a normal year\" (2)",153.42465753424656]
[null,null,16,"Number of hours in a normal working day",8]
[null,null,17,"Salary equated to an hourly rate",19.17808219178082]
[null,null,18,"Adjusted to cover leave and unavailable time (no productivity considerations)",23.28675981370592,0.2142381902860945]
[null,null,19,"Adjusted to also cover non-charged time (i.e. productivity adjustment)",23.972602739726025,0.24999999999999994]
[]
["Notes and Suggestions:"]
[null,"Productivity considerations can be a bit arbitary, and vary between staff"]
[null,"But they give a good indication of the real cost of chargeable time"]
[null,"Also, this does mean that total costs are \"double-counted\" if reports include unavailable & overhead time"]
[null,"The above does not take into account administrative, supervision, and other direct costs of personnel"]
[null,"It also does not include any allowance for office space and other general overheads"]
[null,"These can be included, but require a number of fairly arbitary assumptions in apportioning them to individual staff"]
[null,"It is therefore probably better to manage to a minimum gross margin for all jobs, that ensures overheads are covered"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}