Company bdc is implementing a new employee bonus system

Question

Company BDC is implementing a new employee bonus system. While normal pay raises for personnel will be granted as in the past, the new system will choose the top employees for an additional $1,000 bonus. The exact number of bonus recipients was as yet undecided, but could be as many as 20% of the 151 employees. Senior Management was divided on the issue. One of the managers said he'd seen incentive plans like this one before, and that they never seem to be fairly administered. He said: "People never seem to get what they think they deserve, and it just causes bad feelings all around." Despite the complaints, management was determined and the bonus plan was set up for the following year. A new committee was struck to oversee the awarding of bonuses that would be awarded based on supervisor ratings of employee performance. These ratings already existed in Company BDC, although they currently had no current influence on employee compensation. (Mostly, the ratings were used as a track record for justifying employee dismissal.) Ratings were done on a 10-point scale, so each employee received a score from 1 to 10. Training sessions were held to help supervisors establish standards, but there was still a wide variation among supervisors in the scores they assigned. This variation didn't matter so much in the past since the scores were generally only used for employee termination. This year, however, the ratings would be used to determine bonus-worthiness. Suppose you are a member of the bonus committee. Use the data in excel file to determine your list of bonus winners, and defend your list. Is your allocation fair and free from bias?

ID	Sex (1=F)	Race (1=min)	Age (yrs)	Dept No.	Perf. Rating
1	2	2	35	1	5
2	2	2	60	1	5
3	2	1	61	2	4
4	1	1	36	2	5
5	1	2	40	5	8
6	1	2	59	3	6
7	1	1	35	4	5
8	2	1	26	4	4
9	1	2	41	6	5
10	1	2	50	6	4
11	1	2	22	7	8
12	1	2	62	7	4
13	1	2	23	7	4
14	1	1	43	7	5
15	2	1	35	7	7
16	1	2	42	4	7
17	1	2	25	4	6
18	2	2	29	5	7
19	1	2	43	2	6
20	2	1	55	5	8
21	2	1	20	2	5
22	1	2	43	1	6
23	1	2	48	3	8
24	1	1	44	2	5
25	2	2	24	2	5
26	2	2	60	5	7
27	1	2	44	3	8
28	1	2	20	7	5
29	1	2	41	7	5
30	1	1	55	6	5
31	2	2	30	6	7
32	2	2	27	1	5
33	1	2	43	3	6
34	1	2	39	5	8
35	1	2	31	5	8
36	1	2	46	1	5
37	2	2	32	2	5
38	1	2	61	2	5
39	1	2	36	3	6
40	1	1	45	4	6
41	2	2	30	4	6
42	2	2	58	5	8
43	1	2	32	3	6
44	1	2	57	6	9
45	1	1	24	1	6
46	2	2	42	7	6
47	2	2	35	2	5
48	2	2	36	2	5
49	1	2	45	5	7
50	1	1	23	5	10
51	2	2	47	1	5
52	2	1	50	3	7
53	1	2	50	3	7
54	1	1	36	2	5
55	1	1	36	2	6
56	2	2	57	7	8
57	2	2	39	7	6
58	2	2	55	6	7
59	1	2	42	7	5
60	1	1	39	5	7
61	2	2	27	5	8
62	2	2	30	1	5
63	2	2	60	2	4
64	1	1	33	2	7
65	2	1	21	3	7
66	1	2	25	5	7
67	1	2	36	4	6
68	1	2	39	5	7
69	2	2	23	5	7
70	1	2	42	7	6
71	2	2	31	1	5
72	1	1	26	6	4
73	1	1	45	6	7
74	1	2	57	7	6
75	2	2	50	7	5
76	1	2	55	7	5
77	2	2	19	1	4
78	2	1	44	2	7
79	1	2	57	3	5
80	1	2	52	4	4
81	1	2	31	5	8
82	2	2	48	5	10
83	2	1	47	5	7
84	1	1	62	6	7
85	1	2	48	7	4
86	2	2	54	1	5
87	1	2	60	2	7
88	2	2	20	3	6
89	2	1	38	4	6
90	2	1	35	5	7
91	2	2	28	6	5
92	1	2	44	1	4
93	1	2	50	1	5
94	2	2	40	2	7
95	2	2	45	3	7
96	1	2	26	2	5
97	2	2	38	4	5
98	1	1	27	5	8
99	1	2	47	1	5
100	2	2	59	2	4
101	2	2	36	5	9
102	1	2	58	2	4
103	1	2	56	2	4
104	1	2	40	3	6
105	2	2	31	4	9
106	2	2	50	6	6
107	1	2	38	1	5
108	1	2	46	5	9
109	1	2	20	1	4
110	2	2	32	5	9
111	1	2	46	1	5
112	1	1	24	3	9
113	1	1	52	5	7
114	2	2	56	3	7
115	2	2	47	3	7
116	2	2	23	3	8
117	2	2	33	6	7
118	1	2	40	3	5
119	2	2	28	3	8
120	1	2	53	2	5
121	1	2	40	4	5
122	2	2	28	1	4
123	1	2	52	1	6
124	1	2	54	7	6
125	1	2	32	3	7
126	1	2	26	4	5
127	1	2	28	2	6
128	2	2	45	3	5
129	1	1	51	3	8
130	2	1	37	1	4
131	2	2	41	5	8
132	1	2	52	6	6
133	1	2	45	4	9
134	1	1	34	4	8
135	1	2	31	4	7
136	2	2	49	1	6
137	1	2	45	3	8
138	1	2	22	3	8
139	2	2	59	4	6
140	2	1	55	5	9
141	2	1	24	1	4
142	1	2	43	6	8
143	2	2	21	1	5
144	2	2	36	3	8
145	1	2	38	3	7
146	1	2	29	6	6
147	2	2	59	2	6
148	1	2	24	2	8
149	1	2	58	6	4
150	2	2	20	7	4
151	2	2	42	6	4
152	1	2	34	6	7
153	1	2	38	1	6
154	1	2	38	6	5
155	2	1	42	1	3