Employee Turnover By Week/Month

In MaidCentral there are 2 reports for Turnover, "Employee Turnover" and "Employee Turnover by week". These reports are a great way to monitor your turnover rates, 3 and 12-month moving averages, and more to best monitor your turnover

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 week that is populated. At the top right of the report, you can select a date range to populate to see the "Annual % Turnover" as well as 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 time periods. Below is the exact calculation for 3 and 12 MMA
• 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)