HR PLANNING NOTEBOOK 5.1 RATIO ANALYSIS: PUSLINCH POTTERY OPERATIONAL INDEX NUMBER OF YEAR SALES (S THOUSANDS) EMPLOYEES 2014 2,800 155 2015 3,050 171 2016 3,195 166 2017 3,300 177 2018 3,500 1880 2019 3,600" 1930 2020 3,850 2070 EMPLOYEE REQUIREMENT RATIO (SALES PER EMPLOYEE) 18.06 17.83 19.25 18.64 18.640 18.640 18.640 The initial forecast is developed based on 2017 actual data. We are forecasting labour demand for 2018, 2019, and 2020, and therefore sales figures for those years are future estimates Employee numbers are historical, except for the figures for 2018, 2019, and 2020, which are our future HR demand forecasts. The index used to calculate future demand number of employees can be the most recent figure, or an average of the up-to-date period (e. the past four years, for which the average ls 18.44). In this trend analysis, the most recent ratio (18.84) for the year 2017 was used for forecasting, 4. CALCULATE THE AVERAGE RATIO OF THE OPERATIONAL INDEX TO THE WORKFORCE SIZE Obtain the employee requirement ratio by dividing the level of sales for each year of HR PLANNING NOTEBOOK 5.1 RATIO ANALYSIS: PUSLINCH POTTERY OPERATIONAL INDEX NUMBER OF YEAR SALES (S THOUSANDS) EMPLOYEES 2014 2,800 155 2015 3,050 171 2016 3,195 166 2017 3,300 177 2018 3,500 1880 2019 3,600" 1930 2020 3,850 2070 EMPLOYEE REQUIREMENT RATIO (SALES PER EMPLOYEE) 18.06 17.83 19.25 18.64 18.640 18.640 18.640 The initial forecast is developed based on 2017 actual data. We are forecasting labour demand for 2018, 2019, and 2020, and therefore sales figures for those years are future estimates Employee numbers are historical, except for the figures for 2018, 2019, and 2020, which are our future HR demand forecasts. The index used to calculate future demand number of employees can be the most recent figure, or an average of the up-to-date period (e. the past four years, for which the average ls 18.44). In this trend analysis, the most recent ratio (18.84) for the year 2017 was used for forecasting, 4. CALCULATE THE AVERAGE RATIO OF THE OPERATIONAL INDEX TO THE WORKFORCE SIZE Obtain the employee requirement ratio by dividing the level of sales for each year of