Question: according to excel data below please help with those questions.thanks 1.what is the average age for the entire company? 2. what percentage of the entire

according to excel data below please help with those questions.thanks according to excel data below please help with
1.what is the average age for the entire company?
2. what percentage of the entire company is unionized?
3.what is the benefits costs per employee for 2016?
4.what is the range of years of services for the whole company?
5.how many employees in the company identify their gender as non-specified
6.how many employees in canada
7.average age of canadian employees?
8. percentage of female employees in canada?
9.range of the years of service from lowest to highest in canada?
10.how many employees in usa?
B D F 2014 170 Total Employee Count (As off December 31, 2018) 2015 2016 2017 210 190 180 2018 200 2014 5 #of Employees that Left 2015 2016 10 2 2018 2017 5 6 2014 8,500,000 Benefits Costs Per Year 2015 2016 11,700,000 10,850,000 2017 10,520,000 2018 11,855,000 2014 12.3 Total Recordable Incident Frequency Rate (TRIFR) 2015 2016 2017 13.6 14 14.8 2018 to be calculated There were 8 recordable injuries in Canada in 2018 (industry ave for 2018 was 11.8) Total cost of training in 2017 was: direct costs: 2,395,000 indirect costs: 483,099 Value of the benefits gained: 3,887,209 What was the ROI on training in 2017 B D F 2014 170 Total Employee Count (As off December 31, 2018) 2015 2016 2017 210 190 180 2018 200 2014 5 #of Employees that Left 2015 2016 10 2 2018 2017 5 6 2014 8,500,000 Benefits Costs Per Year 2015 2016 11,700,000 10,850,000 2017 10,520,000 2018 11,855,000 2014 12.3 Total Recordable Incident Frequency Rate (TRIFR) 2015 2016 2017 13.6 14 14.8 2018 to be calculated There were 8 recordable injuries in Canada in 2018 (industry ave for 2018 was 11.8) Total cost of training in 2017 was: direct costs: 2,395,000 indirect costs: 483,099 Value of the benefits gained: 3,887,209 What was the ROI on training in 2017

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!