business

profilestrenth1000
227384-hrmt-3105-metrics-assign-part-1-v1-fall18.xlsx
Home>Business & Finance homework help>Accounting homework help>business

EXERCISE METRIC Req

For this exercise you are to complete the metric calculations for each metric in the green shaded area. You will also need to calcuate additional variations as listed in the variations column - i.e. 2 = 2 additional variations plus the base calculation. I am requiring you to do analysis across the 3 reporting periods. The reporting periods will be annual. For the analysis discuss what is happening year over year. Are there any trends that you can see, what are the potential implications of the trends etc. Finally you will need to develop an effective presentation or reporting package of the metrics for senior management. PLEASE SAVE YOUR FILE with this convention: Last Name_First Name Initatial_Metric Exercise. Tip: to get started I would calculate the FTE and Headcount for each reporting period . Remember FTE is different than Headcount. Full Time Equivalent = 1 full year of service. So if some one only works 3 months what would the FTE =? FTE=3/12 = .25 Headcount is the number of employees employed at the end of the reporting period. Tip: remember your accounting principles: while you have the salaries of each employee that might not be their total cost for the reporting period as if they were only employed for 3 months or .25FTE then what is the payroll cost. Also remember any changes you make to the raw data should be recorded.
DATA SET Requirements SCORING WORTH - Out Of % of Assigment Score SCORE
Calculate the Following Variations # of reporting Periods Analysis Required Assignment Notes Is this metric a: Doable, Deliverable, Performance Enhancer or Enabler - or a combination. Please determine this for each metric
Total FTE 3 (2015, 2016, 2017) Yes 5 3%
Total Headcount 3 (2015, 2016, 2017) Yes 5 3%
Functional Staffing Breakdown 2 3 (2015, 2016, 2017) Yes 11 8%
Total First Year Resignations 2 3 (2015, 2016, 2017) Yes 11 8%
Turnover 2 3 (2015, 2016, 2017) Yes 11 8%
Expense per FTE 3 3 (2015, 2016, 2017) Yes 14 10%
Revenue per FTE 3 3 (2015, 2016, 2017) Yes 14 10%
HR Expense per FTE 3 3 (2015, 2016, 2017) Yes 14 10%
Average annual salary per FTE 3 3 (2015, 2016, 2017) Yes 14 10%
Retention Rate 3 3 (2015, 2016, 2017) Yes 14 10%
OVERALL PRESENTATION SCORE How the metrics package is presented, ie formating, style, any research that might be brought in on the analysis sections. Presented as a report 30 21%
TOTAL ASSIGNMENT SCORE 143 100% 0%

Employee Data

Hire Date Termination Date Gender Commute Distance Education Field 2017 Position 2015 Department 2016 Department 2017 Department 2015 Monthly Income 2015 Salary 2016 Salary 2017 Salary Num Companies Worked 2015 Performance Score out of 10 2016 Performance Score out of 10 2017 Performance Score out of 10 Over Time Business Travel Environment Satisfaction Score out of 5 Job Satisfaction Score out of 5 Training Time Last Year (# days) Age Benefits (Ind/Fam)
Jan-97 Aug-00 Male <10 KM Accounting Controller Finance Finance Finance 2693 32,316.00 33,931.80 38,342.93 1 7 7 7 No Travel_Rarely 4 3 2 60 Single
Feb-98 Nov-01 Male <10 KM Accounting Accounts Payable Finance Finance Finance 2911 34,932.00 36,678.60 41,446.82 1 8 8 8 No Travel_Rarely 1 3 1 49 Single
Dec-00 Female <10 KM Tech Machine Operator Manufacturing Manufacturing Manufacturing 2532 30,384.00 31,903.20 36,050.62 6 No Travel_Rarely 1 4 5 64 Family
Aug-02 Mar-07 Female <10 KM Customer Service Representative Sales Sales Sales 4197 50,364.00 52,882.20 59,756.89 1 6 1 6 No Travel_Rarely 2 3 2 43 Single
Jul-03 Female <10 KM Life Sciences Reception Admin Admin Admin 2341 28,092.00 29,496.60 33,331.16 1 1 2 3 No Travel_Rarely 4 1 6 32 Single
Jul-03 Female <10 KM Life Sciences Sales Executive Sales Sales Sales 5993 71,916.00 75,511.80 85,328.33 1 7 7 7 No Travel_Rarely 1 3 2 28 Single
Sep-03 Male <10 KM Business COO Executive Executive Executive 16823 201,876.00 211,969.80 239,525.87 2 5 7 7 No Travel_Rarely 1 1 3 24 Family
Sep-03 Male <10 KM Customer Service Representative Sales Sales Sales 17174 206,088.00 216,392.40 244,523.41 3 6 3 6 No Travel_Frequently 4 4 3 23 Single
Feb-04 Female <10 KM Finance Business Analytics Director Finance Finance Finance 4444 53,328.00 55,994.40 63,273.67 4 5 6 6 No Travel_Frequently 3 2 2 65 Single
Feb-04 Male <10 KM Life Sciences VP Marketing Marketing Marketing Marketing 19190 230,280.00 241,794.00 273,227.22 1 5 7 7 No Travel_Rarely 3 1 4 19 Family
Mar-05 Female <10 KM Tech Assembler/Fabricator Manufacturing Manufacturing Manufacturing 2372 28,464.00 29,887.20 33,772.54 1 6 6 6 No Travel_Rarely 1 3 3 49 Family
May-07 Female <10 KM Tech Assembler/Fabricator Manufacturing Manufacturing Manufacturing 3544 42,528.00 44,654.40 50,459.47 9 6 6 6 No Non-Travel 3 3 0 33 Family
Jul-07 Male <10 KM Medical Privacy Officer Legal Legal Legal 19419 233,028.00 244,679.40 276,487.72 2 8 8 7 No Travel_Frequently 1 3 2 31 Family
Apr-12 Female <10 KM Management Manufacturing Director Research & Development Research & Development Research & Development 4450 53,400.00 56,070.00 63,359.10 1 6 7 6 No Travel_Rarely 4 1 3 30 Family
May-13 Male <10 KM Medical Research Scientist Research & Development Research & Development Research & Development 2089 25,068.00 26,321.40 29,743.18 4 8 8 6 No Non-Travel 4 4 3 21 Single
May-13 Male <10 KM Medical Tester Research & Development Research & Development Research & Development 5265 63,180.00 66,339.00 74,963.07 2 6 6 5 No Non-Travel 3 3 5 20 Family
Jul-13 Jan-17 Male <10 KM Customer Service Representative Sales Sales Sales 2008 24,096.00 25,300.80 28,589.90 1 8 1 8 No Non-Travel 2 3 2 65 Family
Jun-14 Male <10 KM Medical Research Scientist Research & Development Research & Development Research & Development 9396 112,752.00 118,389.60 133,780.25 7 6 7 7 No Travel_Rarely 4 1 3 54 Single
Aug-16 Female <10 KM Life Sciences Research Scientist Research & Development Research & Development Research & Development 3072 36,864.00 38,707.20 43,739.14 2 8 8 6 No Travel_Rarely 3 1 2 35 Single
Aug-16 Female <10 KM Technical Degree Tester Research & Development Research & Development Research & Development 3319 39,828.00 41,819.40 47,255.92 1 6 6 5 No Travel_Rarely 1 4 3 34 Family
Dec-16 Male <10 KM Technical Degree Director Marketing Marketing Marketing 5762 69,144.00 72,601.20 82,039.36 2 7 7 7 No Non-Travel 2 4 6 28 Single
Nov-17 Male <10 KM 3rd Party Sales Sales Sales 6306 75,672.00 79,455.60 89,784.83 1 6 1 6 No Non-Travel 3 3 2 58 Single
Nov-17 Female <10 KM Customer Service Representative Sales Sales Sales 5131 61,572.00 64,650.60 73,055.18 7 8 7 8 No Travel_Frequently 4 2 3 59 Family
Apr-98 Feb-08 Male <10 KM Business COO Executive Executive Executive 10854 130,248.00 136,760.40 154,539.25 4 7 7 7 Yes Travel_Rarely 4 1 3 47 Family
Nov-01 May-05 Female <10 KM Marketing Privacy Officer Legal Legal Legal 5220 62,640.00 65,772.00 74,322.36 0 7 7 7 Yes Travel_Rarely 2 4 3 49 Family
Jan-03 Female <10 KM Medical Purchasing Assistant Manufacturing Manufacturing Manufacturing 13577 162,924.00 171,070.20 193,309.33 1 7 6 6 Yes Non-Travel 4 2 3 38 Family
Jul-03 Female <10 KM Medical Retail Sales Sales Sales 18740 224,880.00 236,124.00 266,820.12 5 7 7 7 Yes Travel_Rarely 2 3 2 27 Single
Jul-03 Male <10 KM Marketing Sales Executive Sales Sales Sales 5454 65,448.00 68,720.40 77,654.05 5 6 5 6 Yes Travel_Rarely 2 1 2 25 Single
Aug-04 Male <10 KM Director Human Resources Human Resources Human Resources 5021 60,252.00 63,264.60 71,489.00 8 1 2 3 Yes Travel_Rarely 2 2 2 56 Single
Mar-05 Male <10 KM Finance Business Analytics Assitant Finance Finance Finance 17123 205,476.00 215,749.80 243,797.27 6 Yes Travel_Rarely 3 2 4 50 Single
Mar-05 Male <10 KM Finance Business Analytics Coordinator Finance Finance Finance 3339 40,068.00 42,071.40 47,540.68 3 5 5 5 Yes Travel_Rarely 2 3 2 51 Single
Sep-05 Female <10 KM Human Resources Recruiter Human Resources Human Resources Human Resources 2073 24,876.00 26,119.80 29,515.37 4 4 5 6 Yes Travel_Rarely 3 1 3 45 Single
Jun-14 Male <10 KM Arts Assistant Research & Development Research & Development Research & Development 3815 45,780.00 48,069.00 54,317.97 1 6 6 5 Yes Travel_Frequently 4 3 4 56 Single
Jun-14 Female <10 KM Life Sciences Coordinator Research & Development Research & Development Research & Development 2328 27,936.00 29,332.80 33,146.06 1 8 6 6 Yes Travel_Rarely 4 2 2 55 Family
Jun-14 Male <10 KM Engineering Manager Research & Development Research & Development Research & Development 6804 81,648.00 85,730.40 96,875.35 1 8 8 6 Yes Non-Travel 4 4 0 57 Family
May-97 Female 10-20 KM Technical Degree Quality Control Inspector Manufacturing Manufacturing Manufacturing 2296 27,552.00 28,929.60 32,690.45 0 No Travel_Rarely 3 1 3 58 Family
May-97 Male 10-20 KM Technical Degree Quality Control Inspector Manufacturing Manufacturing Manufacturing 7441 89,292.00 93,756.60 105,944.96 1 6 6 No Travel_Rarely 1 2 4 56 Single
Nov-01 Jun-06 Female 10-20 KM Business CEO Executive Executive Executive 10502 126,024.00 132,325.20 149,527.48 7 7 7 7 No Travel_Frequently 4 3 2 53 Single
Jun-06 Male 10-20 KM Science Laboratory Technician Manufacturing Manufacturing Manufacturing 2270 27,240.00 28,602.00 32,320.26 3 8 6 No Travel_Rarely 4 4 2 40 Family
Nov-07 Male 10-20 KM Business Assistant Marketing Marketing Marketing 2613 31,356.00 32,923.80 37,203.89 1 7 8 9 No Travel_Frequently 1 3 2 24 Single
Nov-07 Jun-16 Female 10-20 KM Life Sciences Print & Advertisement Marketing Marketing Marketing 2835 34,020.00 35,721.00 40,364.73 5 4 5 6 No Travel_Rarely 1 4 2 25 Family
Nov-07 Male 10-20 KM Life Sciences Public Relations Marketing Marketing Marketing 4505 54,060.00 56,763.00 64,142.19 6 1 2 3 No Travel_Rarely 3 2 3 26 Family
Jan-09 Female 10-20 KM Medical VP R&D Research & Development Research & Development Research & Development 4941 59,292.00 62,256.60 70,349.96 6 10 1 2 No Travel_Rarely 2 2 0 61 Family
Apr-10 Female 10-20 KM Technical Degree Direct Consumer Sales Sales Sales 2367 28,404.00 29,824.20 33,701.35 5 7 5 7 No Travel_Rarely 3 4 2 48 Family
Jun-10 Female 10-20 KM Human Resources Executive Assistant Admin Human Resources Human Resources 2180 26,160.00 27,468.00 31,038.84 6 7 7 7 No Travel_Frequently 3 4 0 47 Single
May-11 Female 10-20 KM Arts Assistant Human Resources Research & Development Research & Development 5968 71,616.00 75,196.80 84,972.38 1 7 1 7 No Travel_Frequently 4 3 2 36 Single
Aug-12 Female 10-20 KM Customer Service Representative Sales Sales Sales 3055 36,660.00 38,493.00 43,497.09 5 6 6 6 No Non-Travel 4 2 2 28 Family
Aug-12 Feb-16 Female 10-20 KM Life Sciences Customer Service Representative Sales Sales Sales 2289 27,468.00 28,841.40 32,590.78 1 7 7 7 No Travel_Rarely 3 1 2 27 Family
Feb-16 Female 10-20 KM Life Sciences Recruiter Human Resources Human Resources Human Resources 2064 24,768.00 26,006.40 29,387.23 0 5 7 7 No Travel_Rarely 3 3 3 39 Single
Aug-16 Male 10-20 KM Management Manufacturing Director Research & Development Research & Development Research & Development 2232 26,784.00 28,123.20 31,779.22 7 6 6 6 No Travel_Rarely 3 3 1 36 Family
Feb-17 Dec-17 Male 10-20 KM Medical Quality Control Inspector Manufacturing Manufacturing Manufacturing 16032 192,384.00 202,003.20 228,263.62 3 6 6 No Travel_Frequently 2 4 2 25 Single
Sep-17 Female 10-20 KM Accounting Accounts Payable Finance Finance Finance 6397 76,764.00 80,602.20 91,080.49 1 8 8 6 No Travel_Frequently 3 2 6 19 Family
Sep-17 Male 10-20 KM Accounting Accounts Receivalbe Finance Finance Finance 19144 229,728.00 241,214.40 272,572.27 3 6 6 5 No Travel_Rarely 1 2 4 65 Family
Sep-17 Male 10-20 KM Accounting Controller Finance Finance Finance 11996 143,952.00 151,149.60 170,799.05 7 7 7 7 No Travel_Rarely 2 2 6 20 Family
May-97 Female 10-20 KM Life Sciences Quality Control Inspector Manufacturing Manufacturing Manufacturing 4069 48,828.00 51,269.40 57,934.42 3 6 6 Yes Non-Travel 4 4 2 57 Single
Jun-98 Apr-06 Male 10-20 KM Accounting CFO Executive Executive Executive 2074 24,888.00 26,132.40 29,529.61 1 8 8 7 Yes Travel_Rarely 1 1 2 46 Single
Feb-02 Jun-04 Male 10-20 KM Technical Degree Healthcare Representative Manufacturing Manufacturing Manufacturing 10552 126,624.00 132,955.20 150,239.38 2 7 8 7 Yes Travel_Rarely 3 2 3 47 Single
Apr-04 Sep-17 Male 10-20 KM Medical Research Scientist Manufacturing Manufacturing Manufacturing 3617 43,404.00 45,574.20 51,498.85 8 5 5 5 Yes Travel_Frequently 4 2 2 64 Single
Feb-06 Male 10-20 KM Life Sciences Recruiter Human Resources Human Resources Human Resources 3195 38,340.00 40,257.00 45,490.41 4 7 7 7 Yes Travel_Rarely 3 4 2 42 Single
Jun-06 Female 10-20 KM Management Manufacturing Director Manufacturing Manufacturing Manufacturing 5067 60,804.00 63,844.20 72,143.95 1 6 6 7 Yes Travel_Frequently 3 3 3 41 Family
May-07 Male 10-20 KM Business Assistant Human Resources Human Resources Human Resources 14026 168,312.00 176,727.60 199,702.19 1 8 8 7 Yes Travel_Rarely 3 2 2 34 Single
May-11 Jan-17 Male 10-20 KM Customer Service Representative Sales Sales Sales 1129 13,548.00 14,225.40 16,074.70 1 7 1 7 Yes Travel_Rarely 4 4 4 35 Family
Jul-13 Female 10-20 KM Other Customer Service Representative Sales Sales Sales 3977 47,724.00 50,110.20 56,624.53 6 8 6 8 Yes Travel_Rarely 4 3 2 19 Family
Jun-14 Male 10-20 KM Other Lab Technicican Research & Development Research & Development Research & Development 12185 146,220.00 153,531.00 173,490.03 1 6 6 6 Yes Travel_Frequently 2 4 1 53 Family
Oct-14 Male 10-20 KM Customer Service Representative Sales Sales Sales 19328 231,936.00 243,532.80 275,192.06 7 6 6 6 Yes Travel_Rarely 3 4 3 51 Family
Oct-14 Female 10-20 KM Customer Service Representative Sales Sales Sales 2342 28,104.00 29,509.20 33,345.40 1 7 7 7 Yes Travel_Frequently 3 2 2 50 Family
Sep-17 Male 10-20 KM Accounting CFO Executive Executive Executive 13603 163,236.00 171,397.80 193,679.51 2 5 5 5 Yes Non-Travel 1 4 2 21 Single
Feb-96 Jan-17 Male 20-30 KM Accounting Accounts Receivalbe Finance Finance Finance 4448 53,376.00 56,044.80 63,330.62 2 7 7 7 No Travel_Rarely 2 1 3 64 Family
Oct-96 Jul-03 Male 20-30 KM Coordinator Customer Service Customer Service Customer Service 9613 115,356.00 121,123.80 136,869.89 0 5 5 6 No Travel_Rarely 3 4 5 61 Family
Nov-97 Jun-16 Male 20-30 KM Coordinator Customer Service Customer Service Customer Service 5210 62,520.00 65,646.00 74,179.98 1 6 6 7 No Travel_Frequently 1 1 2 51 Family
May-99 Male 20-30 KM Assistant Finance Finance Finance 8578 102,936.00 108,082.80 122,133.56 3 6 8 6 No Travel_Rarely 4 4 4 32 Single
May-99 Jan-17 Male 20-30 KM Customer Service Representative Sales Sales Sales 6384 76,608.00 80,438.40 90,895.39 8 6 9 6 No Travel_Rarely 4 3 3 30 Single
Jul-01 Female 20-30 KM Customer Service Representative Sales Sales Sales 3902 46,824.00 49,165.20 55,556.68 8 6 10 6 No Travel_Rarely 4 4 2 56 Single
Nov-03 Apr-06 Female 20-30 KM Engineering Chemical Plant Operator Manufacturing Manufacturing Manufacturing 5206 62,472.00 65,595.60 74,123.03 1 5 5 5 No Travel_Frequently 4 3 6 22 Single
May-07 Female 20-30 KM Tech Assembler/Fabricator Manufacturing Manufacturing Manufacturing 8500 102,000.00 107,100.00 121,023.00 0 7 8 7 No Travel_Rarely 4 4 0 32 Family
Jan-09 Female 20-30 KM Technical Degree Director Research & Development Research & Development Research & Development 3204 38,448.00 40,370.40 45,618.55 5 5 6 8 No Travel_Rarely 4 1 3 60 Single
Jan-09 Male 20-30 KM Science Manager Research & Development Research & Development Research & Development 17181 206,172.00 216,480.60 244,623.08 4 7 7 7 No Travel_Frequently 4 1 2 59 Family
Jul-09 Female 20-30 KM Tech Assembler/Fabricator Manufacturing Manufacturing Manufacturing 2029 24,348.00 25,565.40 28,888.90 1 7 7 7 No Non-Travel 1 3 2 56 Family
Jul-09 Female 20-30 KM Assembler/Fabricator Manufacturing Manufacturing Manufacturing 6377 76,524.00 80,350.20 90,795.73 5 7 7 7 No Travel_Rarely 2 3 0 55 Family
Feb-10 Female 20-30 KM Assistant Research & Development Research & Development Research & Development 5605 67,260.00 70,623.00 79,803.99 1 7 7 7 No Travel_Frequently 2 2 2 52 Single
Feb-10 Male 20-30 KM Science Coordinator Research & Development Research & Development Research & Development 2348 28,176.00 29,584.80 33,430.82 8 8 8 7 No Travel_Rarely 2 2 2 51 Family
Jan-17 Male 20-30 KM Accounting Controller Finance Finance Finance 6513 78,156.00 82,063.80 92,732.09 4 7 7 7 No Travel_Rarely 3 4 3 27 Family
Sep-17 Male 20-30 KM Life Sciences Coordinator Customer Service Customer Service Customer Service 5745 68,940.00 72,387.00 81,797.31 9 7.9 4.5 5 No Travel_Rarely 4 4 2 62 Family
Sep-17 Male 20-30 KM Coordinator Customer Service Customer Service Customer Service 5482 65,784.00 69,073.20 78,052.72 5 8.7 2.9 4.2 No Travel_Rarely 4 2 3 60 Family
Feb-96 Male 20-30 KM Business Accounts Payable Finance Finance Finance 10333 123,996.00 130,195.80 147,121.25 8 6 6 6 Yes Travel_Rarely 3 2 4 65 Single
Apr-14 Male 20-30 KM Medical Supervisor Manufacturing Manufacturing Manufacturing 5485 65,820.00 69,111.00 78,095.43 9 6 6 6 Yes Travel_Rarely 4 1 4 59 Family
Sep-17 Male 20-30 KM Arts Assistant Finance Finance Finance 3161 37,932.00 39,828.60 45,006.32 3 7.5 5 6 Yes Travel_Frequently 4 3 0 64 Single
Sep-17 Male 20-30 KM Coordinator Customer Service Customer Service Customer Service 2373 28,476.00 29,899.80 33,786.77 2 8.3 3.7 4.6 Yes Travel_Rarely 1 2 2 61 Family
Jun-96 Sep-09 Male 30-40 KM Life Sciences Security IT IT IT 3291 39,492.00 41,466.60 46,857.26 0 No Travel_Frequently 4 2 2 63 Single
Jul-97 Male 30-40 KM Maintainance Supervisor Manufacturing Manufacturing Manufacturing 5731 68,772.00 72,210.60 81,597.98 7 6 6 No Travel_Rarely 3 4 2 55 Single
Sep-97 Male 30-40 KM Life Sciences Sales Executive Sales Sales Sales 3761 45,132.00 47,388.60 53,549.12 9 7 7 7 No Travel_Frequently 2 4 3 53 Single
Jun-98 Male 30-40 KM Life Sciences Quality Control Inspector Manufacturing Manufacturing Manufacturing 8853 106,236.00 111,547.80 126,049.01 1 6 6 No Travel_Frequently 1 4 0 45 Single
Aug-98 Male 30-40 KM Maintainence Technician Manufacturing Manufacturing Manufacturing 10274 123,288.00 129,452.40 146,281.21 2 6 6 6 No Travel_Rarely 3 2 2 44 Single
Oct-98 Female 30-40 KM Engineering Direct Consumer Sales Sales Sales 2314 27,768.00 29,156.40 32,946.73 0 6 6 6 No Non-Travel 4 4 2 42 Family
Dec-98 Female 30-40 KM Business Director Call Center Customer Service Customer Service Customer Service 6347 76,164.00 79,972.20 90,368.59 7 7 7 7 No Travel_Rarely 4 4 2 40 Single
Jan-99 Male 30-40 KM Assitant Customer Service Customer Service Customer Service 2904 34,848.00 36,590.40 41,347.15 1 6 6 5 No Travel_Rarely 3 4 2 37 Single
Jul-99 Male 30-40 KM Business 3rd Party Sales Sales Sales 4876 58,512.00 61,437.60 69,424.49 5 No Travel_Rarely 4 2 0 29 Family
Sep-99 Male 30-40 KM Maintainence Technician Manufacturing Manufacturing Manufacturing 19943 239,316.00 251,281.80 283,948.43 4 6 7 6 No Travel_Rarely 4 1 2 27 Single
Nov-99 Female 30-40 KM Tech Machine Operator Manufacturing Manufacturing Manufacturing 17924 215,088.00 225,842.40 255,201.91 1 5 6 5 No Non-Travel 1 1 3 26 Family
Aug-00 Male 30-40 KM Other Direct Consumer Sales Sales Sales 4066 48,792.00 51,231.60 57,891.71 1 6 6 6 No Travel_Rarely 4 1 3 23 Family
Aug-00 Male 30-40 KM Life Sciences Retail Sales Sales Sales 4724 56,688.00 59,522.40 67,260.31 1 7 7 7 No Travel_Frequently 3 4 3 24 Single
Oct-00 Female 30-40 KM Engineering Maintainence Technician Manufacturing Manufacturing Manufacturing 18606 223,272.00 234,435.60 264,912.23 3 No Travel_Rarely 4 3 6 21 Single
Mar-01 Female 30-40 KM Arts Coordinator Customer Service Customer Service Customer Service 3816 45,792.00 48,081.60 54,332.21 1 6 6 6 No Travel_Rarely 4 2 2 59 Family
Sep-01 Male 30-40 KM Tech Assistant Plant Manager Manufacturing Manufacturing Manufacturing 4877 58,524.00 61,450.20 69,438.73 0 6 6 6 No Travel_Rarely 2 1 5 55 Single
Sep-01 Sep-09 Female 30-40 KM Management Plant Manager Manufacturing Manufacturing Manufacturing 3069 36,828.00 38,669.40 43,696.42 0 7 7 7 No Travel_Rarely 3 3 3 54 Family
Apr-02 Jul-03 Male 30-40 KM Coordinator Customer Service Customer Service Customer Service 3034 36,408.00 38,228.40 43,198.09 1 7 7 7 No Travel_Rarely 4 1 2 46 Family
Apr-02 Male 30-40 KM Coordinator Customer Service Customer Service Customer Service 2576 30,912.00 32,457.60 36,677.09 3 8 8 6 No Travel_Rarely 2 1 5 45 Family
Oct-02 Male 30-40 KM Management Plant Manager Manufacturing Manufacturing Manufacturing 5770 69,240.00 72,702.00 82,153.26 1 6 6 6 No Travel_Rarely 4 4 3 42 Family
Nov-03 Male 30-40 KM Engineering Chemical Plant Operator Manufacturing Manufacturing Manufacturing 13269 159,228.00 167,189.40 188,924.02 5 4 4 4 No Travel_Rarely 4 1 3 21 Single
Nov-03 Male 30-40 KM Tech Electrician Manufacturing Manufacturing Manufacturing 5433 65,196.00 68,455.80 77,355.05 1 8 8 8 No Travel_Rarely 4 2 2 20 Single
Dec-04 Male 30-40 KM Tech Electrician Manufacturing Manufacturing Manufacturing 6842 82,104.00 86,209.20 97,416.40 6 8 8 8 No Travel_Rarely 4 1 3 54 Single
Jan-05 Male 30-40 KM Tech Electrician Manufacturing Manufacturing Manufacturing 5470 65,640.00 68,922.00 77,881.86 0 7 7 7 No Travel_Rarely 4 2 4 53 Single
Jul-05 Male 30-40 KM Tech Machine Operator Manufacturing Manufacturing Manufacturing 4262 51,144.00 53,701.20 60,682.36 4 7 8 7 No Travel_Rarely 4 4 2 47 Family
Jul-05 Male 30-40 KM Machine Operator Manufacturing Manufacturing Manufacturing 16184 194,208.00 203,918.40 230,427.79 4 7 7 7 No Travel_Rarely 1 3 2 46 Family
Mar-07 Male 30-40 KM Customer Service Representative Sales Sales Sales 3537 42,444.00 44,566.20 50,359.81 5 7 7 7 No Travel_Rarely 1 2 1 36 Single
Mar-07 Female 30-40 KM Business Customer Service Representative Sales Sales Sales 10883 130,596.00 137,125.80 154,952.15 3 6 6 6 No Travel_Rarely 3 4 2 35 Family
Jul-07 Sep-17 Female 30-40 KM Medical Research Director Manufacturing Manufacturing Manufacturing 17399 208,788.00 219,227.40 247,726.96 9 5 6 6 No Travel_Rarely 4 4 1 30 Single
Sep-07 Male 30-40 KM Machine Operator Manufacturing Manufacturing Manufacturing 2187 26,244.00 27,556.20 31,138.51 0 6 6 6 No Travel_Rarely 1 3 5 29 Family
Apr-08 Female 30-40 KM Customer Service Representative Sales Sales Sales 3907 46,884.00 49,228.20 55,627.87 1 6 6 6 No Travel_Rarely 2 1 2 22 Family
Aug-08 Female 30-40 KM Management Manufacturing Director Manufacturing Manufacturing Manufacturing 10845 130,140.00 136,647.00 154,411.11 6 5 5 5 No Travel_Rarely 4 3 3 21 Family
Aug-08 Male 30-40 KM Management Manufacturing Director Manufacturing Manufacturing Manufacturing 4377 52,524.00 55,150.20 62,319.73 1 6 5 6 No Travel_Rarely 4 3 6 20 Family
Oct-08 Sep-17 Female 30-40 KM Medical Supervisor Manufacturing Manufacturing Manufacturing 2083 24,996.00 26,245.80 29,657.75 1 6 6 6 No Travel_Frequently 3 3 2 64 Single
Jul-09 Male 30-40 KM Assembler/Fabricator Manufacturing Manufacturing Manufacturing 2610 31,320.00 32,886.00 37,161.18 1 7 6 No Travel_Frequently 4 3 2 54 Family
Oct-10 Male 30-40 KM Other Quality Tester Manufacturing Manufacturing Manufacturing 3917 47,004.00 49,354.20 55,770.25 1 6 6 5 No Travel_Rarely 2 4 4 45 Single
Oct-10 Male 30-40 KM Life Sciences Quality Tester Manufacturing Manufacturing Manufacturing 19973 239,676.00 251,659.80 284,375.57 1 5 6 6 No Non-Travel 2 3 3 44 Single
Sep-11 Female 30-40 KM Other Machinist Manufacturing Manufacturing Manufacturing 14732 176,784.00 185,623.20 209,754.22 2 6 6 6 No Travel_Rarely 2 4 4 33 Single
Oct-12 Female 30-40 KM Other Machinist Manufacturing Manufacturing Manufacturing 2996 35,952.00 37,749.60 42,657.05 5 7 7 7 No Travel_Frequently 4 1 2 26 Single
Dec-12 Female 30-40 KM Other Quality Tester Manufacturing Manufacturing Manufacturing 4834 58,008.00 60,908.40 68,826.49 7 4 No Travel_Rarely 1 3 3 25 Single
Nov-13 Male 30-40 KM Other Machinist Manufacturing Manufacturing Manufacturing 3975 47,700.00 50,085.00 56,596.05 3 5 5 No Non-Travel 3 3 2 64 Single
Dec-14 Female 30-40 KM Machinist Manufacturing Manufacturing Manufacturing 13757 165,084.00 173,338.20 195,872.17 2 No Non-Travel 4 2 5 49 Single
Dec-14 Male 30-40 KM Medical Welder Manufacturing Manufacturing Manufacturing 2345 28,140.00 29,547.00 33,388.11 2 6 7 No Travel_Rarely 3 3 3 48 Family
May-15 Female 30-40 KM Machine Operator Manufacturing Manufacturing Manufacturing 18430 221,160.00 232,218.00 262,406.34 1 No Travel_Frequently 2 4 4 42 Single
May-15 Jun-15 Female 30-40 KM Machine Operator Manufacturing Manufacturing Manufacturing 2694 32,328.00 33,944.40 38,357.17 1 6 6 6 No Non-Travel 3 2 4 41 Single
Apr-16 Male 30-40 KM Medical Quality Tester Manufacturing Manufacturing Manufacturing 7655 91,860.00 96,453.00 108,991.89 0 6 6 6 No Travel_Rarely 4 2 3 37 Single
Feb-17 Female 30-40 KM IT Developer IT IT IT 12169 146,028.00 153,329.40 173,262.22 7 7 6 7 No Travel_Frequently 1 4 4 24 Family
Jun-96 Male 30-40 KM Engineering Maintaince Manager Manufacturing Manufacturing Manufacturing 2703 32,436.00 34,057.80 38,485.31 1 5 7 7 Yes Travel_Frequently 3 3 2 62 Single
Nov-97 Male 30-40 KM Coordinator Customer Service Customer Service Customer Service 2695 32,340.00 33,957.00 38,371.41 0 6 6 7 Yes Travel_Rarely 3 4 2 50 Family
Oct-98 Female 30-40 KM Life Sciences Retail Sales Sales Sales 2022 24,264.00 25,477.20 28,789.24 1 6 7 7 Yes Travel_Frequently 4 2 3 43 Single
Dec-98 Male 30-40 KM Life Sciences Manager Customer Service Customer Service Customer Service 11510 138,120.00 145,026.00 163,879.38 0 8 8 6 Yes Travel_Rarely 3 4 3 39 Family
Jan-99 Female 30-40 KM Coordinator Customer Service Customer Service Customer Service 5974 71,688.00 75,272.40 85,057.81 4 6 66 6 Yes Travel_Rarely 3 1 2 36 Family
Jul-99 Male 30-40 KM Medical Sales Executive Sales Sales Sales 19049 228,588.00 240,017.40 271,219.66 0 Yes Travel_Rarely 2 4 4 28 Single
Jan-05 Female 30-40 KM Arts Customer Service Representative Sales Sales Sales 2587 31,044.00 32,596.20 36,833.71 4 7 7 7 Yes Travel_Rarely 4 1 2 52 Single
Aug-06 Female 30-40 KM Machine Operator Manufacturing Manufacturing Manufacturing 5577 66,924.00 70,270.20 79,405.33 3 8 8 6 Yes Travel_Rarely 4 1 3 39 Family
Aug-06 Female 30-40 KM Machine Operator Manufacturing Manufacturing Manufacturing 19502 234,024.00 245,725.20 277,669.48 1 6 6 5 Yes Travel_Rarely 4 3 5 38 Family
Sep-07 Female 30-40 KM Machine Operator Manufacturing Manufacturing Manufacturing 16627 199,524.00 209,500.20 236,735.23 4 6 7 7 Yes Travel_Rarely 2 4 3 28 Family
Sep-07 Male 30-40 KM Machine Operator Manufacturing Manufacturing Manufacturing 5679 68,148.00 71,555.40 80,857.60 3 6 6 6 Yes Travel_Frequently 4 3 3 27 Family
Aug-08 Female 30-40 KM Other Quality Leader Manufacturing Manufacturing Manufacturing 3743 44,916.00 47,161.80 53,292.83 1 5 6 6 Yes Travel_Rarely 3 2 2 19 Single
Aug-08 Male 30-40 KM Medical Quality Technician Manufacturing Manufacturing Manufacturing 10388 124,656.00 130,888.80 147,904.34 1 4 Yes Travel_Rarely 3 3 3 65 Single
Aug-10 Female 30-40 KM Tech Machinist Manufacturing Manufacturing Manufacturing 5467 65,604.00 68,884.20 77,839.15 3 6 6 6 Yes Travel_Frequently 4 4 4 46 Single
Nov-13 Male 30-40 KM Tech Machinist Manufacturing Manufacturing Manufacturing 10851 130,212.00 136,722.60 154,496.54 2 5 5 5 Yes Travel_Rarely 2 1 2 63 Single
Apr-14 Male 30-40 KM Life Sciences Supervisor Manufacturing Manufacturing Manufacturing 2782 33,384.00 35,053.20 39,610.12 0 6 6 Yes Travel_Rarely 4 1 3 58 Family
Mar-17 Male 30-40 KM 3rd Party Sales Sales Sales 12808 153,696.00 161,380.80 182,360.30 1 6 7 7 Yes Travel_Rarely 3 4 3 22 Single
Dec-98 Sep-17 Male 40-50 KM Life Sciences VP IT IT IT IT 5257 63,084.00 66,238.20 74,849.17 1 4 5 6 No Travel_Frequently 3 3 3 41 Family
May-99 Male 40-50 KM Coordinator Human Resources Human Resources Human Resources 2706 32,472.00 34,095.60 38,528.03 1 1 2 3 No Non-Travel 3 4 2 31 Family
Oct-00 Male 40-50 KM Tech Maintainence Technician Manufacturing Manufacturing Manufacturing 2107 25,284.00 26,548.20 29,999.47 6 5 8 8 No Non-Travel 1 1 2 20 Single
Oct-00 Female 40-50 KM Tech Maintainence Technician Manufacturing Manufacturing Manufacturing 3491 41,892.00 43,986.60 49,704.86 1 6 8 6 No Travel_Rarely 3 3 4 19 Single
Nov-01 Male 40-50 KM Accounting Accounts Receivalbe Finance Finance Finance 3760 45,120.00 47,376.00 53,534.88 1 6 6 No Travel_Rarely 1 4 5 50 Family
Nov-01 Female 40-50 KM Accounting Controller Finance Finance Finance 7379 88,548.00 92,975.40 105,062.20 2 6 6 No Travel_Rarely 4 4 3 52 Single
Dec-02 Female 40-50 KM Assistant Finance Finance Finance 2517 30,204.00 31,714.20 35,837.05 1 No Travel_Rarely 1 3 2 41 Single
Dec-02 Male 40-50 KM Life Sciences Purchasing Manager Manufacturing Manufacturing Manufacturing 16124 193,488.00 203,162.40 229,573.51 3 6 7 6 No Travel_Rarely 4 4 2 39 Family
May-03 Male 40-50 KM Coordinator Customer Service Customer Service Customer Service 14336 172,032.00 180,633.60 204,115.97 1 6 6 5 No Travel_Rarely 1 2 3 35 Family
May-03 Female 40-50 KM IT Developer IT IT IT 4558 54,696.00 57,430.80 64,896.80 1 10 1 2 No Travel_Rarely 3 1 2 36 Family
May-03 Male 40-50 KM Life Sciences VP Manufacturing Manufacturing Manufacturing Manufacturing 4556 54,672.00 57,405.60 64,868.33 2 6 6 7 No Travel_Frequently 1 3 3 33 Family
Jun-04 42979 Female 40-50 KM Operations Director Manufacturing Manufacturing Manufacturing 4810 57,720.00 60,606.00 68,484.78 2 7 7 7 No Travel_Rarely 3 3 5 61 Single
Jun-04 Female 40-50 KM Other Director Manufacturing Manufacturing Manufacturing 5070 60,840.00 63,882.00 72,186.66 5 8 8 6 No Travel_Rarely 1 4 2 60 Single
Jun-04 Female 40-50 KM Tech Machine Operator Manufacturing Manufacturing Manufacturing 10648 127,776.00 134,164.80 151,606.22 1 6 7 6 No Travel_Rarely 3 2 6 58 Family
Jun-04 Female 40-50 KM Tech Machine Operator Manufacturing Manufacturing Manufacturing 3408 40,896.00 42,940.80 48,523.10 7 5 8 8 No Travel_Rarely 1 4 2 57 Family
Jun-04 Male 40-50 KM Science Manager Manufacturing Manufacturing Manufacturing 2768 33,216.00 34,876.80 39,410.78 3 6 6 5 No Travel_Rarely 4 3 3 59 Family
Oct-08 Male 40-50 KM Life Sciences Supervisor Manufacturing Manufacturing Manufacturing 7725 92,700.00 97,335.00 109,988.55 3 No Travel_Frequently 3 4 2 63 Single
Nov-09 Sep-17 Female 40-50 KM Life Sciences Supervisor Manufacturing Manufacturing Manufacturing 2720 32,640.00 34,272.00 38,727.36 1 8 No Travel_Frequently 2 4 5 53 Family
Feb-10 Male 40-50 KM Medical Research Scientist Research & Development Research & Development Research & Development 2024 24,288.00 25,502.40 28,817.71 6 5 7 7 No Non-Travel 4 2 1 50 Single
Dec-10 Female 40-50 KM Life Sciences Supervisor Manufacturing Manufacturing Manufacturing 8793 105,516.00 110,791.80 125,194.73 1 6 6 7 No Travel_Frequently 4 1 4 42 Family
Mar-11 Female 40-50 KM Accounting Accounts Payable Finance Finance Finance 2451 29,412.00 30,882.60 34,897.34 4 6 5 5 No Travel_Rarely 1 3 2 39 Single
Mar-11 Jun-16 Female 40-50 KM Accounting Accounts Receivalbe Finance Finance Finance 3072 36,864.00 38,707.20 43,739.14 1 8 8 6 No Non-Travel 3 1 4 38 Family
Feb-12 Male 40-50 KM Life Sciences Supervisor Manufacturing Manufacturing Manufacturing 5093 61,116.00 64,171.80 72,514.13 2 6 7 6 No Non-Travel 4 1 2 32 Family
Feb-12 Male 40-50 KM Life Sciences Supervisor Manufacturing Manufacturing Manufacturing 5121 61,452.00 64,524.60 72,912.80 3 7 7 8 No Travel_Rarely 2 1 3 31 Family
Dec-12 Female 40-50 KM Medical Quality Tester Manufacturing Manufacturing Manufacturing 2007 24,084.00 25,288.20 28,575.67 1 6 6 6 No Travel_Frequently 1 3 5 24 Single
Dec-12 Male 40-50 KM Medical Quality Tester Manufacturing Manufacturing Manufacturing 19627 235,524.00 247,300.20 279,449.23 9 6 6 5 No Travel_Rarely 4 4 0 23 Single
Feb-14 Male 40-50 KM Life Sciences Quality Technician Manufacturing Manufacturing Manufacturing 7119 85,428.00 89,699.40 101,360.32 4 4 No Travel_Rarely 4 4 2 62 Single
Feb-14 Female 40-50 KM Life Sciences Quality Tester Manufacturing Manufacturing Manufacturing 2207 26,484.00 27,808.20 31,423.27 1 5 7 7 No Travel_Rarely 1 3 5 61 Single
Apr-14 Female 40-50 KM Life Sciences Supervisor Manufacturing Manufacturing Manufacturing 4364 52,368.00 54,986.40 62,134.63 3 8 7 No Travel_Frequently 1 4 2 60 Family
Mar-15 Male 40-50 KM Medical Quality Tester Manufacturing Manufacturing Manufacturing 2377 28,524.00 29,950.20 33,843.73 1 6 6 6 No Travel_Rarely 1 3 0 44 Single
Mar-15 Male 40-50 KM Medical Quality Tester Manufacturing Manufacturing Manufacturing 2596 31,152.00 32,709.60 36,961.85 1 7 No Travel_Frequently 1 2 2 43 Single
Nov-15 Male 40-50 KM Other Manager Human Resources Human Resources Human Resources 4071 48,852.00 51,294.60 57,962.90 2 8 8 8 No Travel_Rarely 3 2 4 40 Family
Apr-16 Female 40-50 KM Life Sciences Quality Tester Manufacturing Manufacturing Manufacturing 2514 30,168.00 31,676.40 35,794.33 4 6 6 5 No Travel_Rarely 3 4 1 38 Single
Dec-16 Female 40-50 KM Human Resources Manager Human Resources Human Resources Human Resources 2592 31,104.00 32,659.20 36,904.90 5 7 6 6 No Non-Travel 1 2 3 29 Family
Mar-97 Male 40-50 KM Human Resources Security IT IT IT 2335 28,020.00 29,421.00 33,245.73 4 5 6 8 Yes Travel_Rarely 1 1 3 59 Single
Nov-97 Female 40-50 KM Law In House Council Legal Legal Legal 5660 67,920.00 71,316.00 80,587.08 2 7 7 7 Yes Non-Travel 4 3 2 52 Single
Nov-01 Male 40-50 KM Accounting Accounts Payable Finance Finance Finance 10252 123,024.00 129,175.20 145,967.98 2 6 6 6 Yes Travel_Rarely 3 1 2 51 Single
Dec-02 Male 40-50 KM Life Sciences Purchasing Director Manufacturing Manufacturing Manufacturing 6623 79,476.00 83,449.80 94,298.27 1 6 7 6 Yes Travel_Rarely 3 4 2 40 Family
May-03 Male 40-50 KM Other Coordinator Customer Service Customer Service Customer Service 4522 54,264.00 56,977.20 64,384.24 4 5 5 7 Yes Travel_Rarely 3 3 3 34 Family
May-03 Female 40-50 KM Life Sciences VP IT IT IT IT 19197 230,364.00 241,882.20 273,326.89 1 7 8 9 Yes Travel_Frequently 2 3 3 37 Family
Oct-08 Female 40-50 KM Medical Supervisor Manufacturing Manufacturing Manufacturing 8847 106,164.00 111,472.20 125,963.59 2 Yes Travel_Rarely 2 2 2 62 Single
Feb-10 Male 40-50 KM Science Lab Technicican Research & Development Research & Development Research & Development 9439 113,268.00 118,931.40 134,392.48 3 7 7 7 Yes Travel_Rarely 3 4 2 49 Single
Jan-11 Male 40-50 KM Medical Supervisor Manufacturing Manufacturing Manufacturing 2759 33,108.00 34,763.40 39,282.64 6 6 6 7 Yes Travel_Frequently 3 3 2 41 Family
Mar-11 Female 40-50 KM Assistant Finance Finance Finance 4257 51,084.00 53,638.20 60,611.17 4 6 6 5 Yes Travel_Rarely 3 1 3 37 Single
Mar-11 Female 40-50 KM Accounting Controller Finance Finance Finance 2566 30,792.00 32,331.60 36,534.71 1 8 9 6 Yes Non-Travel 3 3 2 40 Single
Jan-13 Male 40-50 KM Life Sciences Quality Leader Manufacturing Manufacturing Manufacturing 4615 55,380.00 58,149.00 65,708.37 8 6 5 5 Yes Travel_Rarely 4 1 2 22 Single
Sep-97 Female 60-70 KM Human Resources Manager Human Resources Human Resources Human Resources 4936 59,232.00 62,193.60 70,278.77 1 7 7 7 No Travel_Rarely 2 4 6 54 Family
Oct-00 Nov-01 Male 60-70 KM Life Sciences Executive Assistant Admin Admin Admin 2741 32,892.00 34,536.60 39,026.36 1 7 8 9 No Travel_Rarely 3 3 4 22 Single
Jan-01 Female 60-70 KM Tech Machine Operator Manufacturing Manufacturing Manufacturing 4765 57,180.00 60,039.00 67,844.07 4 No Travel_Rarely 1 2 2 62 Family
Jan-01 Sep-17 Male 60-70 KM Tech Machine Operator Manufacturing Manufacturing Manufacturing 2377 28,524.00 29,950.20 33,843.73 5 5 6 6 No Travel_Rarely 3 3 2 60 Family
Feb-02 Female 60-70 KM Tech Machine Operator Manufacturing Manufacturing Manufacturing 2008 24,096.00 25,300.80 28,589.90 1 6 6 6 No Travel_Rarely 2 2 3 48 Family
Jul-03 Male 60-70 KM Business Coordinator Marketing Marketing Marketing 9724 116,688.00 122,522.40 138,450.31 2 6 6 6 No Travel_Rarely 2 1 2 30 Family
Jul-03 Male 60-70 KM Technical Degree Direct Consumer Sales Sales Sales 10096 121,152.00 127,209.60 143,746.85 1 6 6 6 No Travel_Rarely 3 3 2 26 Family
Jun-04 Male 60-70 KM Business CEO Executive Executive Executive 2886 34,632.00 36,363.60 41,090.87 1 7 7 7 No Travel_Rarely 1 4 3 62 Single
Sep-05 Male 60-70 KM Business Communications Marketing Marketing Marketing 5163 61,956.00 65,053.80 73,510.79 5 8 7 7 No Non-Travel 3 4 2 44 Single
Nov-05 Female 60-70 KM Customer Service Representative Sales Sales Sales 3978 47,736.00 50,122.80 56,638.76 8 7 8 7 No Travel_Rarely 1 3 0 43 Single
Feb-08 Male 60-70 KM Arts 3rd Party Sales Sales Sales 4771 57,252.00 60,114.60 67,929.50 2 6 2 6 No Travel_Rarely 2 4 0 23 Single
Mar-09 Male 60-70 KM Medical Retail Sales Sales Sales 6667 80,004.00 84,004.20 94,924.75 5 7 5 7 No Non-Travel 3 4 6 57 Single
Dec-10 Male 60-70 KM Human Resources Manager Human Resources Human Resources Human Resources 19141 229,692.00 241,176.60 272,529.56 3 5 6 8 No Travel_Rarely 2 4 2 43 Family
Jul-11 Female 60-70 KM Customer Service Representative Sales Sales Sales 2109 25,308.00 26,573.40 30,027.94 1 6 6 6 No Travel_Rarely 4 1 2 34 Family
Aug-12 Nov-15 Male 60-70 KM Tech Customer Service Representative Sales Sales Sales 2766 33,192.00 34,851.60 39,382.31 8 6 6 6 No Travel_Rarely 2 2 6 29 Family
Jan-15 Female 60-70 KM Technical Degree Welder Manufacturing Manufacturing Manufacturing 1274 15,288.00 16,052.40 18,139.21 1 7 6 No Non-Travel 3 3 2 47 Family
Jan-15 Male 60-70 KM Life Sciences Welder Manufacturing Manufacturing Manufacturing 10466 125,592.00 131,871.60 149,014.91 3 7 7 No Travel_Rarely 3 2 3 46 Family
Jan-15 Male 60-70 KM Medical Welder Manufacturing Manufacturing Manufacturing 17007 204,084.00 214,288.20 242,145.67 7 6 6 No Travel_Frequently 2 1 3 45 Family
Aug-16 Male 60-70 KM Engineering Manager Customer Service Customer Service Customer Service 19436 233,232.00 244,893.60 276,729.77 0 7 7 7 No Travel_Rarely 1 3 5 30 Family
Aug-16 Male 60-70 KM Medical VP Client services Customer Service Customer Service Customer Service 13675 164,100.00 172,305.00 194,704.65 9 7 7 7 No Travel_Frequently 2 3 3 33 Family
Aug-16 16-Nov Male 60-70 KM Medical VP Client services Customer Service Customer Service Customer Service 10048 120,576.00 126,604.80 143,063.42 6 8 8 6 No Travel_Frequently 1 3 5 32 Family
Feb-17 Male 60-70 KM Life Sciences Welder Manufacturing Manufacturing Manufacturing 1563 18,756.00 19,693.80 22,253.99 1 6 6 No Travel_Rarely 1 3 2 26 Family
Mar-17 Sep-17 Male 60-70 KM Arts Assistant Admin Admin Admin 6288 75,456.00 79,228.80 89,528.54 2 4 5 6 No Travel_Frequently 1 1 3 23 Single
Sep-17 Male 60-70 KM Assitant Customer Service Customer Service Customer Service 4000 48,000.00 50,400.00 56,952.00 1 4 5 6 No Non-Travel 2 1 2 63 Single
Jan-99 Jul-03 Male 60-70 KM Technical Degree Recruiter Human Resources Human Resources Human Resources 2696 32,352.00 33,969.60 38,385.65 0 7 8 9 Yes Travel_Rarely 3 3 5 38 Single
Dec-00 Male 60-70 KM Coordinator Human Resources Human Resources Human Resources 2277 27,324.00 28,690.20 32,419.93 3 7 7 7 Yes Travel_Rarely 4 2 4 65 Family
Dec-00 Male 60-70 KM Tech Machine Operator Manufacturing Manufacturing Manufacturing 2380 28,560.00 29,988.00 33,886.44 9 7 Yes Travel_Frequently 4 4 3 63 Family
Jan-01 Male 60-70 KM Tech Machine Operator Manufacturing Manufacturing Manufacturing 2778 33,336.00 35,002.80 39,553.16 4 5 5 7 Yes Travel_Rarely 2 4 1 61 Family
Jul-03 Male 60-70 KM Assistant Marketing Marketing Marketing 14756 177,072.00 185,925.60 210,095.93 2 7 7 7 Yes Travel_Rarely 4 3 2 31 Single
Jun-04 Male 60-70 KM Business Assistant Admin Admin Human Resources 9950 119,400.00 125,370.00 141,668.10 9 10 1 2 Yes Travel_Frequently 2 1 2 63 Single
Aug-04 Male 60-70 KM Marketing Manager Marketing Marketing Marketing 5329 63,948.00 67,145.40 75,874.30 7 7 7 7 Yes Non-Travel 2 4 3 55 Family
Jul-05 Male 60-70 KM Life Sciences VP HR Human Resources Executive Executive 2741 32,892.00 34,536.60 39,026.36 0 5 6 8 Yes Travel_Frequently 2 3 2 48 Family
Jan-07 Mar-07 Male 60-70 KM Customer Service Representative Sales Sales Sales 2133 25,596.00 26,875.80 30,369.65 1 6 1 6 Yes Travel_Frequently 4 2 3 37 Single
Mar-09 Female 60-70 KM Medical Sales Executive Sales Sales Sales 3065 36,780.00 38,619.00 43,639.47 1 1 6 Yes Non-Travel 3 1 3 58 Single
Aug-14 Female 60-70 KM Life Sciences Reception Admin Admin Admin 5410 64,920.00 68,166.00 77,027.58 6 10 1 2 Yes Travel_Rarely 4 1 3 52 Single
Aug-16 Male 60-70 KM Management Director Call Center Customer Service Customer Service Customer Service 2593 31,116.00 32,671.80 36,919.13 0 6 6 5 Yes Travel_Rarely 4 1 4 31 Single
Feb-98 Female 70-80 KM Accounting Accounts Receivalbe Finance Finance Finance 2661 31,932.00 33,528.60 37,887.32 0 1 2 3 No Travel_Rarely 2 4 2 48 Family
Mar-99 Apr-10 Male 70-80 KM Business Assistant Finance Finance Finance 9980 119,760.00 125,748.00 142,095.24 1 4 5 6 No Travel_Rarely 2 1 1 35 Single
Apr-00 Feb-08 Female 70-80 KM Other Manager Marketing Marketing Marketing 4011 48,132.00 50,538.60 57,108.62 0 5 6 8 No Non-Travel 1 3 5 25 Family
May-01 Male 70-80 KM Arts Communications Marketing Marketing Marketing 19094 229,128.00 240,584.40 271,860.37 4 7 7 7 No Travel_Rarely 3 3 3 58 Single
May-01 Dec-16 Female 70-80 KM Medical Public Relations Marketing Marketing Marketing 2645 31,740.00 33,327.00 37,659.51 1 7 7 7 No Travel_Rarely 4 3 3 57 Family
Jun-02 Jul-03 Male 70-80 KM Other Print & Advertisement Marketing Marketing Marketing 1951 23,412.00 24,582.60 27,778.34 1 8 8 7 No Travel_Rarely 3 4 3 44 Family
Jul-03 Male 70-80 KM Lifes 3rd Party Sales Sales Sales 5915 70,980.00 74,529.00 84,217.77 3 5 7 7 No Travel_Rarely 4 4 3 29 Single
Mar-99 Female 70-80 KM Marketing Director Marketing Marketing Marketing 3298 39,576.00 41,554.80 46,956.92 0 7 8 9 Yes Travel_Rarely 1 2 5 34 Family
Mar-99 Female 70-80 KM Medical Website Marketing Marketing Marketing 2935 35,220.00 36,981.00 41,788.53 1 10 1 2 Yes Non-Travel 4 4 2 33 Family

Financial Information

$ 2,015 $ 2,016 $ 2,017
Revenue $ 193,478,920 $ 189,478,157 $ 239,128,147
Operating Costs
Product Expense $ 48,329,811 $ 32,434,339 $ 28,493,320
Equipment & Technology Expense $ 10,709,993 $ 1,204,738 $ 903,872
Research Expense $ 1,928,290 $ 1,592,890 $ 2,988,290
Overhead Costs
Marketing Expense $ 1,679,827 $ 2,042,578 $ 1,397,280
Genaral Admin Expense $ 4,432,009 $ 5,432,009 $ 6,432,009
Health and Safety Expense $ 674,820 $ 753,679 $ 852,500
HR Expense $ 834,678 $ 672,971 $ 767,999
Salaries
Analysis Breakout Cost - included in the operating and overhead costs
Benefits Expenses $ 5,203,937 $ 5,001,228 $ 5,729,073
Learning and Development $ 431,452 $ 606,875 $ 745,319

Recruitment Information

Year University Career Fairs Corporate Web Site Monster.ca Direct Recruitment Referrals Employee Referrals LinkedIn
Number of Applications
2015 7 50 28 7 4 129
2016 13 34 54 6 0 147
Number of Interviews
2015 7 10 22 22 12 34
2016 13 18 78 50 8 26
Offers
2015 4 1 2 4 1 4
2016 5 4 4 6 3 6
Hired
2015 2 0 2 3 1 2
2016 5 1 4 5 3 3
Recruitment costs Costs
2015 $ 34,289.00
2016 $ 121,787.00