HRM 360 Assignment 1

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

360

Subject

Business

Date

Apr 3, 2024

Type

docx

Pages

5

Uploaded by MinisterHummingbird3292

Report
Thomas McCulloch Southern New Hampshire University HRM-360 People Analytics March 5, 2024
Calculations: After reviewing the data sheet of employees and terminations we can determine the total turnover rate for each year. First, the formula used to calculate this number is total terminations divided by total headcount for the beginning of the specified period. Below are specific numbers and illustrations for each year. Visualization: Rationale: To ensure that we had the proper turnover rate we must use the total headcount from the beginning of the period we wish to analyze. With the turnover rate we are only concerned about
who is leaving the company compared to the amount we started with. As shown in the table below there was a turnover rate of almost 14% in 2019, it jumped to 32% in 2020 and fell back down to 10% in 2021. The visual I have created above will help illustrate the significance of this spike in turnovers. Year January Headcount Total Turnover Formula Turnover Rate 2019 101 14 14/101 = 13.86% 13.86% 2020 100 32 32/100 = 32% 32.00% 2021 90 9 9/90 = 10% 10.00% I decided to use this clustered column graph because it made the data easy to understand. We wanted to show the difference between each year and see how 2020 was an outlier within the given data. The bars are in place to show where the headcount started and where it ended between each given year and the number of terminations in relation to each year and to the headcount. We can see the significance of the terminations on the turnover rate by the line graph in the chart. My first instinct as to why there was an increase in turnover in the year 2020 was the pandemic. Most of the terminations were in March of that year and that is when most companies began shifting to remote work. This correlates with the data very well. The effect that this had on the workers was monumental. Navigating a new world where remote work is essential showed many trials and tribulations. Not only using new technology and the lack of sociability, but through the potential of losing your job due economic strife. Morale was likely low causing many employees to want to leave if they could afford to. However, another explanation is that the company was overstaffed. As we can see in the next year, terminations diminished but the total headcount remained lower than in previous years, showing a potential correlation to a desire to have a smaller staff count.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help