Filetype Excel XLSX | Posted on 07 Jul 2022 | 4 years ago
Authentication
digital resources
369x Filetype XLSX File size 0.39 MB Source: www.medway.gov.uk
Sheet 1: 1. What are my costs
| Healthy Workplaces Business Case Tool | |||||||||||||
| Welcome | |||||||||||||
| This tool is designed to help you calculate the cost of absence to your business. | |||||||||||||
| What are my costs? | |||||||||||||
| Employee information | |||||||||||||
| 1 | Total number of employees in your business | ||||||||||||
| 2 | Average gross annual wage including on-costs (usually 20%) | ||||||||||||
| 3 | Annual number of working days per employee | 232 | |||||||||||
| If full time, the figure is 232 working days | |||||||||||||
| Cost of sickness absence | |||||||||||||
| 4 | Total No. of working days lost due to absence in past 12 months | ||||||||||||
| 5 | Cost of replacement staff | ||||||||||||
| Cost of absenteeism to your business per annum | £0.00 | ||||||||||||
| Cost of labour turnover | |||||||||||||
| 6 | Percentage of employees that leave each year | ||||||||||||
| Cost of labour turnover to your business per annum | £0.00 | ||||||||||||
| Cost of accidents/injuries | |||||||||||||
| 7 | No. of claims due to accident/injury in last 12 months | ||||||||||||
| 8 | Average cost per claim | 0 | |||||||||||
| Include the cost of time processing the claim by administrators and line managers | |||||||||||||
| Cost of accidents/injuries to your business per annum | £0.00 | ||||||||||||
| Cost of smoking breaks | |||||||||||||
| 9 | No. of employees who smoke | ||||||||||||
| Cost of smoking breaks to your business per annum | £0.00 | ||||||||||||
| Other costs associated with poor health and wellbeing | |||||||||||||
| 10 | Description | ||||||||||||
| 11 | Number of instances per year | ||||||||||||
| 12 | Cost per incidence | ||||||||||||
| This could include, for example, occupationahl health checks or return to work interviews | |||||||||||||
| Cost of | 0 | £0.00 | |||||||||||
| Employee information | |||||||||||||
| Total hours for business | 0 | ||||||||||||
| Salary cost for business | 0 | ||||||||||||
| Daily cost per employee | 0 | ||||||||||||
| Hourly cost per employee | 0 | ||||||||||||
| Summary: What is the cost of poor health and wellbeing to my business? | ||||||||||
| Summary chart | ||||||||||
| Summary table | ||||||||||
| Absence | 0.00 | #DIV/0! | % | |||||||
| Labour turnover | 0.00 | #DIV/0! | % | |||||||
| Accidents / injuries | 0.00 | #DIV/0! | % | |||||||
| Smoking breaks | 0.00 | #DIV/0! | % | |||||||
| Other | 0.00 | #DIV/0! | % | |||||||
| Total cost | 0.00 | |||||||||
no reviews yet
Please Login to review.
