Human Resource Management metrics

profiletiptoe1
Case1Scorecarddata1.xlsx

Sheet1

Job Posted 1st Interview Offer Accepted # Days Salary Offered Accepted Ratio Performance Referrals Last pay raise
1 Secretary 1/23/18 2/12/18 -20 $ 35,000 1 1 100% 4 1 3% Questions
2 Legal Secretary 1/23/18 2/15/18 -23 $ 47,000 2 1 50% 4.5 3% 1
3 Office Clerk 1/27/18 2/21/18 -25 $ 28,000 1 1 100% 3 2% 3
4 Legal Assistant 2/2/18 2/12/18 -10 $ 52,000 1 1 100% 4.5 3% 4
5 Maintenance Technician 2/3/18 2/23/18 -20 $ 45,000 3 1 33% 3 1 2% 5
6 Assistant Librarian 2/5/18 3/13/18 -36 $ 40,000 2 1 50% 3 2% 7
7 Marketing Manager 2/11/18 2/26/18 -15 $ 78,000 1 1 100% 4.6 3%
8 Vice President of Sales 2/15/18 3/28/18 -41 $ 125,000 1 1 100% 5 4%
9 Project Manager 2/15/18 3/31/18 -44 $ 75,000 1 1 100% 4.7 3%
10 Sales Associate 3/1/18 3/19/18 -18 $ 68,000 1 1 100% 3.6 1 3%
11 Account Manager 3/2/18 4/2/18 -31 $ 95,000 2 1 50% 3.4 3%
12 Web Developer 3/11/18 3/26/18 -15 $ 50,000 1 1 100% 4 3%
13 Website Designer 3/15/18 3/31/18 -16 $ 50,000 1 1 100% 4 3%
14 Accounting Clerk 3/22/18 4/1/18 -10 $ 45,000 1 1 100% 2.8 1%
15 Payroll Clerk 3/25/18 4/2/18 -8 $ 40,000 1 1 100% 4 3%
16 Packaging Assistant 3/31/18 4/12/18 -12 $ 28,000 1 1 100% 3 2 2%
17 Sales Representative II 4/2/18 4/16/18 -14 $ 65,000 2 1 50% 3 2%
18 Marketing Coordinator 4/2/18 4/20/18 -18 $ 38,000 2 1 50% 4 3%
19 Event Planner 4/6/18 5/3/18 -27 $ 46,000 3 1 33% 4.5 3%
20 Assistant Buyer 4/18/18 4/30/18 -12 $ 45,000 1 1 100% 4.2 3%
21 Secretary 4/23/18 5/2/18 -9 $ 35,000 1 1 100% 3.8 2 2%
22 Operations research analyst 4/18/18 5/12/18 -24 $ 75,000 2 1 50% 4 3%
23 Financial Analyst 5/6/18 6/1/18 -26 $ 76,000 2 1 50% 4 3%
24 Brand Marketing Assistant 5/12/18 6/2/18 -21 $ 78,000 2 1 50% 4.3 3%
25 Marketing Assistant 5/23/18 6/2/18 -10 $ 40,000 1 1 100% 4.3 3%
26 Editor 6/4/18 6/15/18 -11 $ 95,000 1 1 100% 4.5 3%
27 Office Coordinator 6/14/18 7/12/18 -28 $ 40,000 3 1 33% 5 4%
28 Office Associate 6/30/18 7/15/18 -15 $ 36,000 1 1 100% 4 3%
29 Manager 7/7/18 8/5/18 -29 $ 65,000 3 1 33% 4.5 3%
30 Secretary 7/23/18 8/6/18 -14 $ 37,000 1 1 100% 3.5 2%
31 Receptionist 8/15/18 9/1/18 -17 $ 28,000 1 1 100% 3.4 2%
32 Sales Associate 8/24/18 9/3/18 -10 $ 68,000 1 1 100% 3.7 2%
33 Department Assistant 9/1/18 9/17/18 -16 $ 38,000 1 1 100% 3.6 1 2%
34 Department Clerk 9/12/18 9/30/18 -18 $ 29,000 2 1 50% 3.5 2%
35 Maintenance Technician I 9/19/18 10/1/18 -12 $ 55,000 1 1 100% 3.9 2%
MK IT Manager 9/23/18 10/3/18 -10 $ 110,000 1 1 100% 4.4 3%
37 Social Media Sales Clerk 10/1/18 10/15/18 -14 $ 35,000 1 1 100% 3 2%
38 Social Media Customer Service 10/3/18 10/16/18 -13 $ 35,000 1 1 100% 3.8 2%
39 Customer Service Clerk 11/3/18 11/20/18 -17 $ 35,000 2 1 50% 4 3%
40 Customer Service Manager 11/15/18 11/30/18 -15 $ 55,000 2 1 50% 5 4%
41 Finance Clerk 11/19/18 12/1/18 -12 $ 35,000 1 1 100% 3.4 2%
42 Secretary 12/1/18 12/20/18 -19 $ 38,000 2 1 50% 3.9 2%
43 Electrician 12/12/18 1/2/19 -21 $ 65,000 2 1 50% 4.5 2 3%
44 IT Help Desk Specialist 12/12/18 12/24/18 -12 $ 50,000 1 1 100% 4.6 3%
45 HR Generalist 12/17/18 1/3/19 -17 $ 65,000 1 1 100% 4.5 3%
46 Mail Room Clerk 12/29/18 1/17/19 -19 $ 28,000 1 1 100% 2.4 1 2%
-844 67 46 69% 180.3 11 122%
averages -18 3.9 2.7%