GSC

1. Prepare GSC overall, manual and non-manual, and location absence rates and compare these with relevant CIPD survey findings. Hint – 2: The GSC data does not have a specific category for Manual/Non manual for each employee; the nearest field would be the Pay Type (Hourly or Salaried). Use this and note it as an assumption. You may need to make other such assumptions in other parts of the assignment. When you have prepared the information as suggested above, analyse it and comment on what this shows that is of ‌‌‌‌‍‌‍‌‍‌‌‌‍‌‍‌‍‍‌ interest to GSC. 2. Create information (in a table or another format of your choice) that shows the proportion of short term, medium term and long term absences in GSC. Include relevant benchmark data where possible (e.g. from CIPD), or explain why you are not using any. Comment on what analysing this information shows that is of interest to GSC. 3. Select a particular employee group of concern based on the analysis above or your own further investigation and analyse further to highlight key issues. Your analysis should include using Excel to investigate the relevant data. As above, you need to comment on what is of interest to GSC. 4. Write an Executive Summary in a one page Word document, showing your key findings from the 3 tasks above and making appropriate recommendations. This 1 page document should clearly state your key findings from your three-part analysis (no new information), your conclusions and recommendations. It should be written for senior management. You may refer to your Excel spreadshe ‌‌‌‌‍‌‍‌‍‌‌‌‍‌‍‌‍‍‌ ets                                                                

Sample Solution