In MaidCentral, there are two reports for Turnover, "Employee Turnover" and "Employee Turnover by Week". These reports are a great way to monitor your turnover rates, 3-month and 12-month moving averages, and more to monitor your turnover best
Please Note* - Only Employees who are tagged as "Scheduled" in their employee profile will count towards these reports.
Turnover By Month - Employee Turnover
Employee Turnover by Month breaks down a year's worth of data monthly. You can select the year by clicking the Green Calendar in the top right of the report and selecting a year.
% Quit -
30 days - Is calculated by the "30 Days quit" / "Total Hired"
90 days - is calculated by the "90 Days quit" / "Total Hired"
Total - is calculated by the "Quit total" / "Total Hired"
Turnover By Week
Employee turnover by week is sorted by week (Sunday -> Saturday) for each populated week. At the top right of the report, you can select a date range to populate to see the "Annual % Turnover" and the Employees at the start, how many were hired, terminated, and how many you had at the end of the week.
3/12 MMA -
MMA stands for - Monthly Moving Average
MMA is calculated by adding up all the data points during a specific period and dividing the sum by the number of periods. Below is the exact calculation for 3MMA and 12MMA
A moving average is a technique to get an idea of trends that are happening and predict where those trends are headed and what is the cause of those trends
Formula:
[(The sum of the Term from the current date to the last 12 weeks) x (4)] / {[(Sum of the Start # from current -> last 12 weeks)+(Sum of the End from current ->last 12 weeks)/2]/13}
Below is the calculation as seen in an excel spreadsheet
3MMA = =SUM(E3:E15)*4/((SUM(C3:C15)+SUM(F3:F15))/2/13)
