Question
Calculate metrics for the organizational information provided. Calculate the metrics for Month end report, August 2019 and September 2019. Please show your work (ie/ if
Calculate metrics for the organizational information provided. Calculate the metrics for Month end report, August 2019 and September 2019. Please show your work (ie/ if youre calculating turnover, list the steps in how you got there or show formulas in excel) and explain your reasoning if necessary.
Employee Name | Hire Date | Termination Date | Salary | Gender Identity |
Janson Lee | 2018-05-04 |
| $59,750.00 | Male |
Susan Gale | 2015-02-11 |
| $58,000.00 | Female |
Mary Nguyen | 2012-03-14 | 2019-09-02 | $80,250.00 | Female |
Rohan Akano | 2019-05-21 |
| $35,750.00 | Male |
Sandeep Nur | 2014-06-03 |
| $55,700.00 | Male |
Mohamed Saeed | 2018-07-03 | 2019-08-09 | $50,000.00 | Male |
David Robb | 2019-08-12 |
| $70,000.00 | Male |
Lars Caldas | 2019-09-02 |
| $45,000.00 | Male |
Miriam Ansari | 2018-10-02 |
| $72,500.00 | Female |
Ethan Lin | 2019-04-09 |
| $48,600.00 | Male |
Nayab Srimohanarajah | 2017-06-14 | 2019-08-13 | $55,250.00 | Female |
Betty Sherwin | 2018-04-30 |
| $35,500.00 | Female |
Aaron Sanchez | 2019-02-25 |
| $115,000.00 | Male |
Puneet Sharma | 2017-04-03 | 2019-04-17 | $95,000.00 | Male |
Kirusha Sabahat | 2018-08-27 |
| $56,000.00 | Female |
Rachel Dominguez | 2017-03-13 | 2019-02-22 | $87,500.00 | Female |
Megan Lall | 2013-02-04 |
| $85,000.00 | Female |
Metrics required:
- Headcount as of August 31, 2019 (1)
- Headcount as of September 30, 2019 (1)
- Turnover rate for August 31, 2019 (1)
- Turnover rate for September 2019 (1)
- What is the average tenure of all active employees as of August 31, 2019 (1)
- What is the average tenure of all active employees as of September 30, 2019 (1)
- What is the average salary of all active employees as of September 30, 2019 (1)
- Is there currently a wage gap between those employees who identify as female and those employees who identify as male? (Please supplement your yes/no answer with financial data of salary averages for each gender identity as of September 30, 2019) (3)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started