This publication contains a set of tools to perform employee analysis and communicate key statistics in a concise, efficient, and smart way. It can be used for an in-house HR analysis or as part of a due diligence review. The findings are illustrated by professionally designed magazine-quality charts you can use in your reports and presentations.
The analysis covers:
● Employee headcount and salary (costs) per head by the department. This part of the analysis makes use of a jitter-scatter chart, a great visual tool you can use in many other situations.
● Employee turnover and retention. Includes the calculation of average service period and other relevant statistics
● Employee headcount changes by years and departments, turnover analysis. Demonstrates total headcount, new joiners, and leavers on an elegant vertical waterfall chart. Also has other charts showing the headcount by years and departments, turnover by years and others.
● Employee service period by department. Splits the headcount in each department by the length of the service period. This is somewhat similar to aging analysis (of accounts receivable or inventory) where we split every product type by the period the items have been on our books.
● Employee churn analysis. A more granular way of looking at employee turnover and retention. The methods and techniques explained in this section are also applicable to customer churn analysis.
The publication includes a detailed text guide.
You will get:
- 1 Excel Model Template (.xlsx)
- 1 Detailed Text Guide (.pdf)
Similar Products
Other customers were also interested in...
Due Diligence Tools and Methods
A suite of best practices to perform financial and commercial due diligence. Use it if you are consi... Read more
Top 16 Google Sheet Templates
This is a bundle of all the most useful and efficient google sheet templates I have built over the y... Read more
Digital Hiring (Talent) Marketplace – 5 Year Fin...
Financial Model providing an advanced 5-year financial plan for an online, two-sided hiring platform... Read more
Human Resources Company – Dynamic 10 Year Financ...
Financial Model providing a dynamic up to 10-year financial forecast for a startup or existing Human... Read more
Recruitment Agency Financial Model Excel Template
Shop Recruitment Agency Financial Model Template. Fortunately, you can solve Cash Flow shortfalls wi... Read more
Staffing Agency Financial Model
This excel financial projection model is for forecast of revenue, expenses and cash flows for a staf... Read more
Complete Three-Statement Monthly Budget with Scena...
This is a comprehensive set of templates that will help you build your budget. The templates are bui... Read more
Complete Three-Statement Monthly Budget
This is a comprehensive set of templates that will help you build your budget. The templates are bui... Read more
Complete Three-Statement Quarterly Budget with Sce...
This is a comprehensive set of templates that will help you build your budget. The templates are bui... Read more
Complete Three-Statement Quarterly Budget
This is a comprehensive set of templates that will help you build your budget. The templates are bui... Read more
You must log in to submit a review.