Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Inside Private Equity

Authors: James M. Kocis, James C. Bachman IV, Austin M. Long III, Craig J. Nickels

1st Edition

0470421894, 978-0470421895

More Books

Students also viewed these Finance questions

Question

=+26.14. 1 Show that y has no point masses if 2(t) is integrable.

Answered: 1 week ago

Question

What are the challenges associated with tunneling in urban areas?

Answered: 1 week ago

Question

What are the main differences between rigid and flexible pavements?

Answered: 1 week ago

Question

What is the purpose of a retaining wall, and how is it designed?

Answered: 1 week ago

Question

How do you determine the load-bearing capacity of a soil?

Answered: 1 week ago

Question

what is Edward Lemieux effect / Anomeric effect ?

Answered: 1 week ago