80.2K

Verified Solution

Link Copied!

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)

Answer & Explanation Solved by verified expert

See Answer