Blog

HR3140: Absenteeism Case Study

Instructions

Read the case and do an analysis on the data set provided

Create a report based on your analysis that covers

• Describe the analysis that was done
• Present results of the analysis
• Interpret the results
• Make recommendations based on your interpretations

Hand in report and excel with analysis in it.

All graphs and data used in the report must be present in the excel sheet.

ABSENTEEISM CASE

The CEO, Khalid, of a food chain Jim Flortins has walked in your office and asked if we have an issue with employee absenteeism.  Khalid has just returned from an industry conference and the cost of employee absenteeism was highlighted in one of the seminars he attended.  He realized he was not sure what Jim Flortins employee absenteeism rate was and if it was a concern.  The industry statistics showed that absenteeism impacted customer satisfaction, revenue, and employee productivity.

You pulled together some reports from the HRIS system and now need to answer the following questions and then present the findings back to Khalid.

Here is how you intend to go through it.

USING THE IMPACT FRAMEWORK

Identify the Questions

• What is its rate of absenteeism?
• Does anyone have excessive absenteeism?
• Is it the same across the organization?
• Does it vary by gender?
• Does it vary by length of service or age?
• Where should we focus to reduce our absenteeism?
• What should be looked at to determine the impact of absenteeism?

Master the Data

• What data is going to be looked at?
• Are there any data missing that is needed, i.e. are there any calculations needed?
• To calculate absenteeism rate use 35 hours a week and 50 weeks in year to calculate work hours in a year.

Analysis:

• Understand the magnitude of each category
• Are there any averages, means, min or max?
• Should we group the data?
• What correlations should be looked at?
• Do any categories correlate with Absenteeism?

Provide Meaning

• Articulate the results of the analysis using visuals to demonstrate your conclusions
• Identify the limitations of the analysis that may impact your conclusions

Recommendations on next steps

• What are your recommendations on next steps as a result of your analysis
  1. More Analysis?
  2. Actions to track more data?
  3. Interventions?
  4. Predictions?