EMP ID
11001
11002
11003
11004
11005
11006
11007
11008
11009
11010
11011
11012
11013
11014
11015
11016
11017
11018
11019
11020
11021
11022
11023
11024
11025
11026
11027
11028
11029
11030
11031
11032
11033
11034
11035
11036
11037
11038
11039
11040
11041
11042
11043
11044
11045
11046
11047
11048
11049
11050
11051
GENDER YEARS SENIORITY
1
5
1
13
1
11
1
26
0
5
1
1
0
1
0
4
1
2
0
1
1
1
1
9
1
10
0
0
1
2
0
5
0
1
0
0
0
3
1
12
1
6
1
1
1
4
1
11
1
2
1
2
1
2
0
3
0
4
1
3
1
3
0
1
1
6
1
0
0
12
1
4
0
1
1
1
0
2
1
6
1
0
1
5
1
4
0
6
0
0
0
6
1
0
0
5
1
4
1
0
1
9
Base Salary
$21,059.04
$26,073.00
$24,854.42
$38,296.80
$20,348.10
$17,511.06
$17,617.00
$20,304.01
$19,356.08
$17,767.65
$18,154.03
$22,895.49
$23,775.44
$17,095.89
$20,314.42
$20,648.15
$17,819.08
$18,584.52
$19,199.32
$26,134.84
$21,057.21
$18,329.78
$19,581.43
$26,195.47
$17,717.43
$19,624.30
$18,876.61
$18,677.60
$20,611.41
$18,932.96
$19,384.87
$17,281.44
$21,221.32
$17,910.93
$27,110.32
$20,935.96
$18,899.89
$17,512.90
$19,678.19
$21,751.62
$16,837.47
$20,240.94
$19,231.78
$21,055.99
$18,108.11
$22,379.28
$17,895.01
$20,225.63
$19,821.47
$16,693.58
$22,754.04
Commission
$27,402.41
$104,683.28
$59,113.15
$215,905.69
$32,036.09
$19,491.42
$22,434.39
$28,212.55
$18,844.77
$13,664.26
$17,502.49
$74,395.67
$90,762.04
$10,531.46
$15,078.80
$36,094.16
$16,597.44
$11,251.59
$25,395.12
$117,998.31
$53,584.82
$12,825.34
$38,541.13
$82,855.33
$22,937.13
$20,015.59
$22,160.06
$30,688.91
$27,041.12
$30,829.76
$20,195.62
$15,474.38
$53,022.07
$9,638.65
$118,241.41
$31,330.05
$13,765.29
$16,083.06
$26,083.41
$58,155.43
$13,565.67
$41,365.91
$39,975.26
$50,032.56
$9,059.36
$40,598.03
$11,457.95
$30,401.72
$32,954.02
$11,533.27
$90,168.67
Total Compensation
$48,461.45
$130,756.28
$83,967.57
$254,202.49
$52,384.19
$37,002.48
$40,051.39
$48,516.57
$38,200.86
$31,431.91
$35,656.52
$97,291.15
$114,537.49
$27,627.36
$35,393.22
$56,742.31
$34,416.51
$29,836.11
$44,594.45
$144,133.14
$74,642.03
$31,155.12
$58,122.56
$109,050.80
$40,654.56
$39,639.89
$41,036.67
$49,366.52
$47,652.53
$49,762.71
$39,580.49
$32,755.81
$74,243.39
$27,549.58
$145,351.73
$52,266.01
$32,665.18
$33,595.96
$45,761.60
$79,907.05
$30,403.14
$61,606.85
$59,207.04
$71,088.55
$27,167.48
$62,977.30
$29,352.96
$50,627.35
$52,775.49
$28,226.85
$112,922.71
Region
3
4
3
6
3
2
5
3
5
3
3
1
5
5
2
6
5
2
5
6
5
1
2
3
3
3
2
4
4
5
3
3
6
2
4
2
2
5
2
3
1
5
5
4
3
5
2
5
6
2
5
11052
11053
11054
11055
11056
11057
11058
11059
11060
11061
11062
11063
11064
11065
11066
11067
11068
11069
11070
11071
11072
11073
11074
11075
11076
11077
11078
11079
11080
11081
11082
11083
11084
11085
11086
11087
11088
11089
11090
11091
11092
11093
11094
11095
11096
11097
11098
11099
11100
11101
11102
11103
0
1
1
1
1
0
1
1
0
1
1
1
1
1
0
1
1
0
1
0
1
1
1
1
1
0
0
0
0
1
0
1
1
1
1
0
1
0
1
0
1
0
0
0
1
1
1
0
1
1
1
0
3
6
3
9
4
5
0
1
5
1
19
3
17
1
6
0
2
12
2
3
3
1
1
2
16
4
5
6
6
2
1
0
11
12
7
0
11
0
2
0
2
5
1
1
9
13
6
0
0
3
7
3
$19,180.95
$21,190.09
$19,255.05
$23,569.69
$20,601.61
$21,358.48
$18,783.54
$18,855.19
$20,834.31
$19,508.57
$30,585.43
$19,967.83
$29,481.97
$17,892.56
$22,163.73
$18,324.89
$19,074.40
$25,434.92
$19,555.10
$19,716.77
$20,011.30
$19,031.54
$17,969.72
$19,629.20
$29,456.25
$19,316.90
$19,608.98
$22,059.02
$21,412.37
$18,423.47
$18,831.30
$18,979.49
$24,780.93
$25,717.83
$21,937.78
$17,522.71
$24,169.80
$17,202.43
$19,994.16
$16,485.98
$18,739.44
$21,643.85
$18,788.43
$18,165.06
$23,806.68
$26,347.33
$22,416.02
$20,332.18
$17,148.55
$20,686.73
$21,733.25
$19,711.25
$33,900.10
$48,546.98
$28,596.50
$54,831.57
$26,075.44
$39,764.61
$7,733.01
$13,139.47
$39,429.04
$13,906.75
$231,130.01
$27,895.98
$206,312.56
$17,500.65
$54,210.65
$12,619.59
$19,409.98
$78,274.92
$17,914.00
$19,739.43
$31,527.84
$17,211.01
$17,339.00
$17,563.72
$177,006.57
$28,663.86
$41,049.34
$48,229.79
$47,816.45
$19,876.58
$18,147.91
$10,134.04
$90,608.34
$116,496.82
$78,759.30
$10,615.96
$97,090.71
$10,957.66
$18,139.95
$11,947.22
$18,226.91
$54,807.08
$14,372.76
$14,265.59
$73,148.92
$114,320.51
$40,599.25
$29,199.68
$11,610.43
$29,200.29
$62,474.98
$32,546.18
$53,081.05
$69,737.07
$47,851.55
$78,401.26
$46,677.05
$61,123.09
$26,516.55
$31,994.66
$60,263.35
$33,415.32
$261,715.44
$47,863.81
$235,794.53
$35,393.21
$76,374.38
$30,944.48
$38,484.38
$103,709.84
$37,469.10
$39,456.20
$51,539.14
$36,242.55
$35,308.73
$37,192.93
$206,462.82
$47,980.76
$60,658.32
$70,288.81
$69,228.82
$38,300.05
$36,979.21
$29,113.53
$115,389.27
$142,214.65
$100,697.07
$28,138.67
$121,260.51
$28,160.09
$38,134.12
$28,433.20
$36,966.36
$76,450.92
$33,161.19
$32,430.65
$96,955.59
$140,667.84
$63,015.27
$49,531.85
$28,758.98
$49,887.02
$84,208.22
$52,257.43
5
1
3
4
4
4
6
2
4
5
5
5
2
3
2
2
5
5
4
2
3
4
2
2
4
5
3
1
3
4
6
6
1
6
3
2
5
1
5
6
5
6
3
6
5
5
6
6
6
5
6
6
11104
11105
11106
11107
11108
11109
11110
11111
11112
11113
11114
11115
11116
11117
11118
11119
11120
11121
11122
11123
11124
11125
11126
11127
11128
11129
11130
11131
11132
11133
11134
11135
11136
11137
11138
11139
11140
11141
11142
11143
11144
11145
11146
11147
11148
11149
11150
11151
11152
11153
11154
11155
1
0
0
1
1
1
0
1
1
1
0
0
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
0
1
0
1
1
0
1
1
0
0
1
1
1
1
1
1
0
0
0
1
1
0
0
1
1
0
2
0
3
2
1
0
4
14
12
1
0
7
3
0
1
4
10
2
4
1
2
2
4
1
16
8
2
15
2
1
16
0
13
12
3
0
4
3
6
7
0
22
2
1
5
2
4
0
1
6
1
$16,637.23
$20,024.17
$17,207.95
$20,970.86
$17,916.45
$17,475.55
$17,171.21
$19,206.06
$27,439.15
$26,480.21
$18,506.14
$18,031.56
$22,243.95
$18,317.53
$18,114.24
$17,729.67
$20,107.44
$25,219.38
$19,196.87
$20,594.27
$18,234.26
$17,484.73
$17,936.04
$20,815.32
$18,315.70
$28,623.45
$22,570.34
$18,258.13
$27,906.38
$18,748.02
$16,664.80
$28,472.19
$17,323.69
$25,883.17
$25,949.30
$19,705.74
$17,490.24
$20,192.57
$19,929.26
$22,114.13
$21,673.23
$17,276.53
$33,922.14
$20,494.46
$19,233.01
$20,639.59
$19,255.67
$18,870.49
$18,983.16
$17,456.57
$21,773.04
$19,258.11
$12,460.38
$15,123.50
$9,151.83
$25,268.98
$19,593.07
$16,923.20
$9,311.65
$28,204.59
$146,556.70
$119,027.06
$14,075.16
$10,947.25
$48,988.50
$26,541.44
$10,119.35
$14,960.00
$34,999.28
$61,375.79
$19,860.05
$33,740.89
$15,565.61
$23,158.20
$21,643.85
$29,172.11
$15,384.36
$185,159.99
$49,601.47
$15,771.38
$167,009.31
$19,762.07
$16,085.51
$178,218.95
$11,250.97
$106,146.81
$68,341.94
$26,358.35
$9,168.97
$26,168.52
$26,772.92
$59,225.83
$72,365.10
$13,159.68
$208,758.28
$15,244.75
$13,781.23
$40,941.55
$16,430.87
$35,990.68
$8,157.37
$12,747.57
$47,500.48
$12,938.62
$29,097.61
$35,147.67
$26,359.79
$46,239.84
$37,509.51
$34,398.76
$26,482.86
$47,410.66
$173,995.85
$145,507.27
$32,581.30
$28,978.81
$71,232.45
$44,858.98
$28,233.59
$32,689.67
$55,106.72
$86,595.17
$39,056.92
$54,335.16
$33,799.87
$40,642.93
$39,579.89
$49,987.43
$33,700.06
$213,783.44
$72,171.80
$34,029.51
$194,915.69
$38,510.09
$32,750.31
$206,691.15
$28,574.66
$132,029.98
$94,291.24
$46,064.10
$26,659.21
$46,361.09
$46,702.18
$81,339.96
$94,038.34
$30,436.21
$242,680.42
$35,739.21
$33,014.23
$61,581.14
$35,686.54
$54,861.17
$27,140.53
$30,204.13
$69,273.52
$32,196.72
5
2
4
4
5
1
3
3
3
1
3
5
3
2
5
6
6
4
2
2
4
3
2
1
4
6
2
1
4
2
5
4
6
4
2
3
5
2
4
2
6
6
5
1
2
5
5
6
2
5
2
2
11156
11157
11158
11159
11160
11161
11162
11163
11164
11165
11166
11167
11168
11169
11170
11171
11172
11173
11174
11175
11176
11177
11178
11179
11180
11181
11182
11183
11184
11185
11186
11187
11188
11189
11190
11191
11192
11193
11194
11195
11196
11197
11198
11199
11200
11201
11202
11203
11204
11205
11206
11207
1
1
0
1
1
0
1
1
1
1
0
0
1
0
1
1
1
1
0
1
0
1
1
0
1
1
1
0
1
0
1
1
1
0
1
1
1
1
1
1
1
0
1
1
1
0
0
1
0
0
1
1
6
0
1
18
8
8
1
2
3
14
11
6
5
0
8
5
8
10
6
9
1
6
5
0
6
1
0
1
9
0
3
7
4
6
0
2
1
0
9
5
3
10
3
5
10
0
3
1
4
0
6
4
$22,619.33
$18,149.75
$18,838.03
$30,845.67
$23,341.90
$22,552.57
$18,140.57
$17,741.31
$19,893.74
$27,611.23
$23,855.05
$21,594.24
$21,055.99
$18,490.23
$22,861.20
$20,835.54
$23,810.96
$23,696.45
$21,496.27
$24,282.48
$18,323.04
$21,297.24
$21,172.94
$17,453.50
$21,411.15
$18,213.43
$17,962.99
$17,723.55
$23,897.31
$17,405.13
$19,514.08
$22,378.67
$19,511.62
$22,299.07
$17,500.65
$18,967.86
$17,046.91
$17,379.41
$23,393.33
$20,912.69
$19,631.64
$25,117.73
$19,245.86
$21,292.35
$23,899.14
$18,483.49
$18,702.70
$17,986.86
$20,841.66
$17,855.21
$21,578.93
$20,682.45
$44,908.38
$10,988.89
$16,189.00
$150,645.91
$57,318.34
$62,199.42
$16,191.45
$20,676.33
$20,983.72
$106,208.04
$73,571.44
$57,391.82
$47,281.86
$11,876.19
$69,924.25
$37,614.64
$62,325.56
$73,572.66
$39,297.39
$66,016.83
$21,505.45
$46,073.08
$42,246.48
$12,756.14
$53,243.13
$16,770.12
$9,367.38
$17,471.27
$79,414.51
$10,126.08
$25,672.52
$55,074.68
$37,015.14
$41,189.56
$12,066.02
$22,208.43
$15,783.01
$12,439.55
$60,656.29
$30,466.02
$26,100.55
$86,258.18
$26,096.26
$37,468.29
$87,819.06
$9,051.40
$31,151.85
$13,148.05
$30,136.58
$8,783.80
$47,928.51
$30,285.99
$67,527.71
$29,138.64
$35,027.03
$181,491.59
$80,660.24
$84,751.99
$34,332.01
$38,417.63
$40,877.46
$133,819.27
$97,426.49
$78,986.07
$68,337.85
$30,366.41
$92,785.45
$58,450.18
$86,136.52
$97,269.11
$60,793.65
$90,299.31
$39,828.49
$67,370.32
$63,419.42
$30,209.64
$74,654.29
$34,983.55
$27,330.36
$35,194.82
$103,311.82
$27,531.20
$45,186.59
$77,453.35
$56,526.77
$63,488.63
$29,566.67
$41,176.29
$32,829.91
$29,818.97
$84,049.62
$51,378.71
$45,732.19
$111,375.91
$45,342.12
$58,760.64
$111,718.21
$27,534.89
$49,854.55
$31,134.91
$50,978.24
$26,639.02
$69,507.43
$50,968.45
5
6
4
1
6
5
3
6
2
1
1
1
3
1
5
6
3
2
6
5
5
1
6
3
5
5
6
4
1
6
4
5
2
1
3
2
6
1
5
3
6
1
6
2
3
6
6
3
4
3
2
1
11208
11209
11210
11211
11212
11213
11214
11215
11216
11217
11218
11219
11220
11221
11222
11223
11224
11225
11226
11227
11228
11229
11230
11231
11232
11233
11234
11235
11236
11237
11238
11239
11240
11241
11242
11243
11244
11245
11246
11247
11248
11249
11250
11251
11252
11253
11254
11255
11256
11257
11258
11259
0
1
1
0
1
1
1
0
0
1
0
1
1
1
1
1
1
1
1
1
1
0
0
1
1
1
1
1
1
1
1
0
1
0
0
1
0
1
1
1
1
1
0
1
0
1
1
0
1
1
1
1
7
5
1
0
5
1
1
1
0
1
2
0
7
2
1
19
0
2
1
0
7
0
0
9
2
0
10
3
1
2
0
4
3
4
1
3
4
3
9
4
0
4
1
6
0
11
9
0
13
7
1
11
$22,417.85
$20,484.65
$17,520.25
$18,018.71
$20,213.38
$17,330.43
$18,291.20
$18,767.62
$18,245.89
$18,631.07
$18,786.59
$17,271.64
$22,632.79
$18,985.00
$17,299.81
$31,447.63
$18,520.84
$18,173.64
$18,424.09
$16,857.68
$22,435.62
$18,238.54
$18,087.29
$23,755.85
$18,801.91
$17,141.82
$24,301.46
$18,043.81
$19,009.49
$19,777.39
$17,466.98
$19,343.23
$19,323.63
$20,969.64
$18,435.72
$20,509.14
$20,323.00
$19,494.49
$22,300.29
$20,810.43
$17,931.75
$20,057.23
$18,619.42
$20,623.66
$16,263.70
$25,188.76
$23,056.54
$17,171.82
$26,313.04
$23,017.36
$18,866.82
$24,728.26
$58,392.41
$50,470.39
$15,209.23
$9,837.67
$36,959.42
$16,067.74
$13,495.26
$16,190.22
$10,663.11
$17,405.13
$20,692.85
$10,413.28
$63,383.09
$23,188.81
$20,393.41
$216,183.65
$11,649.00
$17,522.09
$14,719.96
$11,792.30
$49,331.41
$8,900.15
$7,863.44
$76,577.48
$20,970.26
$11,638.59
$74,311.16
$23,714.21
$17,530.05
$20,542.83
$12,296.26
$36,507.51
$24,212.66
$27,967.61
$15,202.49
$22,863.03
$33,965.62
$24,565.99
$82,457.30
$34,140.14
$10,405.92
$34,828.43
$15,929.97
$43,728.99
$11,072.17
$97,336.27
$65,300.38
$8,453.75
$109,555.18
$49,115.25
$18,007.07
$89,133.79
$80,810.26
$70,955.04
$32,729.48
$27,856.38
$57,172.80
$33,398.17
$31,786.46
$34,957.84
$28,909.00
$36,036.19
$39,479.45
$27,684.92
$86,015.89
$42,173.81
$37,693.22
$247,631.28
$30,169.85
$35,695.73
$33,144.05
$28,649.98
$71,767.03
$27,138.69
$25,950.73
$100,333.33
$39,772.17
$28,780.41
$98,612.62
$41,758.02
$36,539.54
$40,320.22
$29,763.24
$55,850.74
$43,536.29
$48,937.25
$33,638.21
$43,372.18
$54,288.62
$44,060.48
$104,757.58
$54,950.57
$28,337.68
$54,885.66
$34,549.39
$64,352.65
$27,335.87
$122,525.03
$88,356.91
$25,625.57
$135,868.22
$72,132.61
$36,873.89
$113,862.05
5
5
2
2
6
2
1
2
2
4
2
2
5
2
2
1
5
5
5
2
1
1
6
3
1
5
3
4
1
5
1
5
4
6
1
5
5
6
1
1
6
2
1
3
2
2
2
3
5
2
1
2
11260
11261
11262
11263
11264
11265
11266
11267
11268
11269
11270
11271
11272
11273
11274
11275
11276
11277
11278
11279
11280
11281
11282
11283
11284
11285
11286
11287
11288
11289
11290
11291
11292
11293
11294
11295
11296
11297
11298
11299
11300
11301
11302
11303
11304
11305
11306
11307
11308
11309
11310
11311
1
0
0
1
0
1
0
0
0
0
0
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
0
1
0
1
0
1
0
0
1
1
1
0
1
0
1
1
1
1
1
1
0
1
1
1
2
3
0
5
1
3
1
0
6
3
3
13
7
6
10
9
0
4
16
0
12
3
1
16
16
11
3
1
6
4
5
2
2
6
1
1
6
4
0
1
5
5
23
7
2
5
1
2
8
2
13
6
$19,716.15
$19,602.26
$17,582.71
$20,355.45
$16,946.48
$19,025.41
$18,023.60
$17,508.01
$20,741.84
$19,868.02
$19,465.70
$25,929.09
$21,560.56
$21,427.68
$24,554.36
$22,844.66
$16,658.06
$21,361.55
$30,413.97
$16,534.97
$26,314.87
$19,016.23
$18,490.83
$29,144.56
$27,981.09
$26,190.57
$20,016.21
$17,955.63
$21,506.68
$20,409.95
$20,793.28
$16,899.33
$18,141.18
$21,616.90
$18,740.06
$17,883.38
$22,458.28
$19,553.27
$17,282.04
$18,534.93
$20,504.87
$20,652.44
$35,935.57
$22,152.10
$19,637.77
$22,146.58
$18,873.56
$19,827.60
$22,540.32
$19,472.43
$26,549.40
$22,475.42
$17,355.52
$23,045.52
$11,350.79
$41,515.33
$17,640.89
$29,445.23
$13,304.81
$10,928.26
$57,389.99
$25,405.53
$24,253.08
$98,958.39
$52,536.48
$49,461.23
$69,929.77
$74,973.73
$11,873.12
$28,963.91
$175,888.44
$13,307.86
$121,644.88
$32,845.63
$17,957.48
$137,259.27
$130,484.20
$78,668.06
$24,948.71
$18,144.86
$56,302.45
$35,977.82
$42,766.37
$25,895.42
$19,715.54
$39,350.05
$12,351.37
$18,008.91
$52,071.09
$34,732.90
$9,565.16
$17,293.68
$33,771.51
$32,698.67
$217,796.10
$59,857.16
$20,183.38
$44,647.52
$13,274.81
$21,318.68
$61,467.04
$23,494.99
$141,759.51
$42,634.72
$37,071.68
$42,647.78
$28,933.49
$61,870.78
$34,587.37
$48,470.65
$31,328.41
$28,436.27
$78,131.83
$45,273.56
$43,718.78
$124,887.48
$74,097.03
$70,888.90
$94,484.13
$97,818.39
$28,531.18
$50,325.46
$206,302.41
$29,842.83
$147,959.75
$51,861.87
$36,448.31
$166,403.83
$158,465.29
$104,858.63
$44,964.91
$36,100.49
$77,809.13
$56,387.76
$63,559.64
$42,794.74
$37,856.72
$60,966.95
$31,091.43
$35,892.28
$74,529.36
$54,286.17
$26,847.20
$35,828.61
$54,276.37
$53,351.10
$253,731.67
$82,009.26
$39,821.14
$66,794.10
$32,148.36
$41,146.28
$84,007.37
$42,967.42
$168,308.92
$65,110.13
3
1
2
3
6
5
4
4
3
1
6
2
2
5
5
6
3
3
6
6
1
2
3
3
2
1
5
4
2
6
5
3
2
2
3
2
1
3
3
5
6
4
4
2
2
2
5
2
3
2
3
1
11312
11313
11314
11315
11316
11317
11318
11319
11320
11321
11322
11323
11324
11325
11326
11327
11328
11329
11330
11331
11332
11333
11334
11335
11336
11337
11338
11339
11340
11341
11342
11343
11344
11345
11346
11347
11348
11349
11350
11351
11352
11353
11354
11355
11356
11357
11358
11359
11360
11361
11362
11363
1
0
1
0
1
1
0
1
1
0
0
1
1
1
1
1
1
0
1
1
1
0
1
0
1
1
0
0
0
0
1
1
1
0
1
1
1
0
1
0
1
0
1
0
1
1
0
1
0
1
1
1
2
0
5
3
0
6
5
4
4
4
0
11
3
6
11
7
4
0
3
2
2
0
1
7
5
0
1
0
0
8
6
10
0
3
3
7
0
3
2
5
9
3
2
1
3
3
4
0
6
7
2
1
$19,539.19
$16,749.29
$20,349.33
$19,299.75
$18,091.58
$21,370.73
$19,899.24
$19,555.10
$20,102.55
$21,157.64
$17,181.62
$24,122.03
$19,666.55
$21,937.16
$24,497.42
$22,509.71
$21,550.76
$17,702.12
$20,258.08
$19,204.23
$18,646.37
$18,422.25
$18,507.36
$23,090.22
$21,153.96
$16,948.93
$18,767.62
$16,901.16
$18,512.87
$23,249.43
$22,457.05
$24,857.47
$18,130.16
$19,338.95
$19,922.52
$22,229.86
$17,492.09
$20,417.29
$19,128.91
$20,552.63
$24,067.54
$19,125.23
$18,913.35
$18,177.93
$19,711.25
$19,085.43
$20,752.25
$16,622.55
$21,497.49
$22,513.39
$18,190.78
$18,945.20
$24,547.01
$14,075.16
$37,069.04
$22,992.86
$9,222.25
$45,452.76
$36,075.18
$33,907.44
$31,562.74
$27,747.17
$12,170.74
$77,549.89
$23,604.60
$49,008.09
$63,780.51
$55,268.79
$22,773.63
$13,808.78
$24,213.88
$20,245.23
$19,720.44
$10,482.47
$14,518.49
$50,120.13
$32,183.67
$10,756.80
$15,375.78
$12,129.09
$10,384.50
$55,091.83
$50,526.72
$82,308.50
$10,711.49
$22,762.00
$22,825.69
$47,558.04
$11,740.86
$23,373.74
$18,403.26
$41,692.91
$51,466.69
$29,880.00
$20,788.39
$20,270.33
$26,796.18
$22,324.16
$27,376.70
$11,477.54
$45,440.52
$58,882.30
$26,550.64
$14,248.45
$44,086.19
$30,824.45
$57,418.37
$42,292.61
$27,313.83
$66,823.49
$55,974.42
$53,462.55
$51,665.30
$48,904.80
$29,352.36
$101,671.92
$43,271.15
$70,945.25
$88,277.92
$77,778.50
$44,324.40
$31,510.90
$44,471.96
$39,449.46
$38,366.81
$28,904.73
$33,025.85
$73,210.35
$53,337.64
$27,705.73
$34,143.41
$29,030.25
$28,897.37
$78,341.26
$72,983.77
$107,165.97
$28,841.64
$42,100.95
$42,748.21
$69,787.90
$29,232.94
$43,791.03
$37,532.17
$62,245.54
$75,534.23
$49,005.23
$39,701.74
$38,448.25
$46,507.43
$41,409.59
$48,128.95
$28,100.09
$66,938.00
$81,395.68
$44,741.41
$33,193.65
3
2
6
1
6
6
5
2
6
5
4
4
6
6
1
6
4
2
2
5
4
2
3
2
6
1
1
4
2
5
2
1
2
4
2
1
6
3
2
2
1
6
2
1
1
1
6
5
2
4
6
4
11364
11365
11366
11367
11368
11369
11370
11371
11372
11373
11374
11375
11376
11377
11378
11379
11380
11381
11382
11383
11384
11385
11386
11387
11388
11389
11390
11391
11392
11393
11394
11395
11396
11397
11398
11399
11400
11401
11402
11403
11404
11405
11406
11407
11408
1
1
1
1
0
1
0
1
1
0
1
0
1
0
1
1
1
1
1
1
0
1
0
1
1
1
0
1
1
0
1
1
1
0
1
1
1
0
0
1
1
1
1
1
1
0
10
6
8
6
19
0
21
0
1
4
0
3
0
13
0
2
14
11
4
1
13
1
3
4
16
3
12
1
3
11
1
12
2
4
0
1
0
3
3
10
14
10
4
6
$18,051.77
$23,970.79
$23,066.34
$22,634.01
$20,796.95
$30,808.33
$17,498.82
$33,219.77
$17,495.14
$17,781.73
$20,274.61
$16,744.40
$20,067.65
$16,868.71
$27,094.40
$19,757.80
$19,432.02
$27,098.07
$25,676.81
$20,014.99
$18,832.53
$27,990.27
$17,912.76
$19,443.05
$20,532.42
$29,023.31
$19,583.27
$25,801.73
$18,150.36
$19,589.39
$25,087.71
$18,602.28
$25,384.10
$17,874.80
$19,833.12
$18,049.93
$18,019.93
$17,008.93
$18,455.32
$19,390.99
$24,647.44
$26,483.28
$24,183.27
$21,357.26
$22,006.36
$9,645.39
$79,070.98
$43,344.43
$42,972.13
$57,656.97
$177,469.47
$10,489.82
$168,079.63
$10,428.58
$14,246.00
$36,125.40
$10,867.03
$24,971.37
$10,775.17
$87,860.71
$19,422.84
$20,104.39
$140,377.34
$88,078.10
$31,261.47
$14,767.72
$124,627.66
$21,473.61
$19,560.00
$35,879.84
$200,119.29
$28,483.22
$121,647.93
$17,452.28
$26,015.44
$101,194.10
$15,847.30
$82,344.02
$24,835.43
$35,652.65
$8,584.78
$13,569.34
$11,664.32
$32,829.10
$23,109.81
$71,918.09
$123,777.14
$93,851.36
$26,586.76
$48,708.03
$27,697.16
$103,041.77
$66,410.77
$65,606.14
$78,453.92
$208,277.80
$27,988.63
$201,299.41
$27,923.73
$32,027.73
$56,400.01
$27,611.43
$45,039.01
$27,643.88
$114,955.11
$39,180.64
$39,536.41
$167,475.41
$113,754.91
$51,276.46
$33,600.25
$152,617.93
$39,386.37
$39,003.04
$56,412.26
$229,142.60
$48,066.49
$147,449.66
$35,602.64
$45,604.83
$126,281.81
$34,449.58
$107,728.11
$42,710.23
$55,485.77
$26,634.72
$31,589.27
$28,673.25
$51,284.42
$42,500.80
$96,565.52
$150,260.41
$118,034.63
$47,944.02
$70,714.39
1
1
3
5
5
4
5
1
1
1
3
2
2
1
1
4
6
6
2
5
5
5
2
4
6
2
2
6
1
4
1
4
5
2
3
2
6
5
6
4
2
4
5
2
5
Contracts written
131
460
322
467
71
1
0
223
5
3
140
402
170
34
156
8
213
36
2
100
217
1
334
160
3
10
132
59
148
85
114
160
264
45
228
78
8
291
200
17
42
80
27
267
38
253
64
124
20
29
176
Q1
2
1
4
4
4
5
5
4
5
5
1
5
2
3
5
4
4
3
5
5
3
4
4
5
1
5
2
4
4
3
4
5
4
2
4
3
1
3
2
4
5
2
4
3
3
4
5
4
4
5
1
Q2
3
3
5
3
5
5
4
5
1
5
3
4
1
3
4
4
3
3
2
5
2
5
4
5
5
5
3
3
3
2
5
4
3
5
2
5
5
5
5
1
5
2
4
4
5
3
4
4
1
4
5
Q3
4
1
5
5
1
2
1
4
5
1
2
4
5
2
1
1
1
5
2
2
2
2
5
1
5
2
4
4
2
4
4
1
4
5
4
5
3
5
4
1
1
1
5
5
1
4
4
5
1
4
4
Q4
5
2
3
5
2
2
5
5
5
4
2
5
5
5
5
2
5
5
1
3
4
3
3
5
2
2
1
2
3
4
5
5
5
3
1
4
2
3
2
5
3
5
5
2
5
2
4
2
5
5
5
Q5
2
5
1
1
1
1
1
1
2
1
1
1
1
3
1
1
2
2
1
4
1
2
2
3
1
1
3
3
5
1
5
3
2
1
5
2
3
1
2
2
2
3
3
1
1
3
1
3
1
2
2
Q6
6
4
9
7
7
4
10
6
5
8
3
4
5
10
9
8
8
8
8
3
7
6
6
7
9
7
7
2
2
8
8
4
4
7
4
9
6
5
4
3
5
10
9
1
6
9
5
5
8
10
3
4
110
106
445
60
340
20
0
137
28
332
334
360
149
6
43
113
390
8
110
182
44
0
0
279
2
204
184
91
87
58
35
152
297
315
42
369
48
14
40
0
79
3
0
360
169
204
9
95
131
221
74
3
3
5
4
1
3
5
5
3
5
5
4
3
5
3
3
5
1
5
5
1
4
1
4
1
3
5
4
4
3
5
5
2
5
2
3
3
2
3
5
5
5
5
2
3
5
5
5
4
4
5
1
4
5
5
1
4
4
5
5
2
3
2
3
4
5
3
5
3
5
2
5
5
3
5
5
3
4
5
3
5
2
3
3
5
1
5
3
1
3
3
3
2
3
4
4
2
4
2
2
3
3
3
5
1
1
5
2
4
4
5
1
5
1
1
1
4
1
2
5
2
2
4
5
5
1
1
1
1
4
5
1
1
5
5
1
1
5
1
5
4
1
3
2
5
2
4
5
1
1
5
5
4
2
5
1
5
5
2
2
5
1
4
3
5
4
3
4
5
4
2
5
3
3
4
2
5
4
3
4
3
1
5
4
2
5
2
2
5
3
4
5
5
3
4
5
4
2
4
5
3
3
3
3
5
1
5
2
1
1
1
2
2
3
1
1
5
2
2
1
1
2
1
3
2
1
4
1
2
4
1
2
3
2
2
2
3
1
2
3
4
2
1
1
1
4
3
1
1
2
2
3
1
2
2
2
2
1
1
2
7
5
10
4
2
0
8
7
3
5
4
6
8
9
6
6
8
4
2
7
9
1
8
7
3
7
5
6
10
2
7
8
7
4
7
7
6
6
10
9
4
9
7
6
6
6
8
6
8
6
6
6
84
8
23
113
22
0
26
58
369
297
256
54
8
56
37
98
39
200
109
11
8
311
0
38
30
378
26
254
158
7
200
489
34
277
170
293
28
78
171
437
15
55
375
16
47
118
134
87
15
169
48
0
5
3
2
3
4
3
5
4
4
4
5
4
5
3
4
5
5
3
3
5
4
5
3
4
2
1
5
5
1
5
4
5
5
1
5
4
5
2
4
5
5
5
3
4
5
3
1
5
2
5
5
5
3
5
3
1
3
5
3
5
5
1
1
2
5
5
2
3
3
3
2
1
3
1
5
1
3
4
5
5
3
3
3
3
2
1
5
3
3
3
3
4
3
3
4
5
5
3
5
4
5
2
2
3
4
5
5
3
5
5
1
5
5
1
1
3
5
5
3
1
1
2
4
3
1
4
5
5
2
4
3
2
3
2
5
2
5
1
5
5
5
1
4
3
1
2
2
5
2
4
2
3
1
2
1
1
5
3
4
2
3
5
5
3
5
4
5
5
5
3
5
5
4
2
5
3
5
1
5
3
4
5
5
2
4
1
4
4
3
3
3
2
5
3
4
5
5
5
5
2
4
5
4
3
1
5
5
3
2
5
3
5
1
1
2
3
2
2
3
3
5
1
2
3
3
4
2
3
4
2
1
3
1
2
3
3
5
1
1
5
2
3
2
2
1
2
5
3
1
3
1
2
3
1
1
2
2
1
2
4
5
7
3
4
9
6
6
9
8
9
5
9
7
7
9
7
4
3
8
3
2
6
6
6
3
10
7
7
3
8
9
0
7
3
4
10
5
6
3
8
10
6
6
9
10
9
5
8
9
5
4
7
198
51
354
237
68
412
159
16
27
303
244
115
148
37
155
79
325
234
349
264
0
193
203
40
219
0
29
0
189
34
276
133
119
72
63
95
401
42
199
29
132
94
114
259
317
23
147
67
270
36
49
42
3
4
3
5
4
5
3
2
5
1
5
2
3
2
4
5
3
4
4
5
3
5
4
1
5
5
4
5
4
5
5
5
4
3
3
5
3
1
2
4
2
2
5
5
5
1
5
5
4
2
2
4
1
4
1
4
2
2
5
1
4
4
1
5
5
1
2
4
4
5
3
4
4
4
3
5
2
4
4
3
2
1
3
4
4
5
5
1
1
4
2
2
3
4
3
5
1
1
3
4
2
2
5
3
5
1
1
1
1
4
3
1
2
1
5
1
1
3
4
1
1
1
5
3
2
4
5
1
1
1
5
4
5
5
4
2
5
1
2
1
1
2
2
4
5
4
5
5
5
2
1
1
1
5
1
4
4
5
4
4
3
2
3
3
5
4
2
3
1
5
4
4
2
4
3
5
4
2
5
5
1
5
5
4
5
5
5
4
4
3
4
2
5
4
3
5
5
5
3
4
5
4
5
3
4
5
5
5
2
2
1
2
1
1
1
3
2
2
1
1
3
1
5
4
1
2
1
4
1
3
1
1
2
1
2
1
3
1
3
2
1
1
3
4
2
1
1
1
3
2
1
2
3
2
1
2
5
2
1
1
4
8
4
10
3
10
6
5
6
7
8
5
8
5
9
5
5
7
9
9
7
7
9
4
5
7
7
2
5
6
3
10
2
8
5
5
8
10
7
9
6
7
10
1
4
9
10
4
3
7
3
8
479
101
195
50
0
151
45
98
33
0
44
34
297
158
83
434
40
126
0
68
316
113
36
441
1
50
233
8
0
0
50
73
72
225
101
291
272
38
408
75
60
112
219
274
82
209
269
22
314
386
0
248
5
4
5
5
5
3
2
1
3
4
1
4
3
4
5
4
5
5
5
5
5
5
5
4
5
5
4
4
2
5
5
5
5
2
4
5
4
5
1
3
1
2
5
3
3
2
4
5
2
5
5
3
1
3
3
5
2
3
5
4
1
3
5
5
1
3
4
1
3
1
2
2
5
4
1
4
4
2
5
3
5
5
5
3
3
3
5
3
3
2
2
4
5
5
5
1
1
3
5
5
2
5
5
4
5
1
5
1
4
5
5
1
5
5
5
5
4
2
4
5
1
5
1
2
4
5
5
5
5
1
5
4
1
1
5
1
2
5
4
2
4
1
4
4
1
5
4
2
5
1
1
2
1
1
2
1
2
2
4
4
5
4
4
5
5
3
1
1
5
1
4
5
4
2
5
5
4
5
5
5
4
5
3
2
5
2
5
2
4
2
5
5
2
5
3
1
2
3
5
5
5
5
5
5
5
4
5
5
2
3
2
3
3
1
2
3
3
3
2
3
1
1
3
3
1
1
2
4
2
3
1
1
1
4
1
5
4
1
4
1
3
1
2
5
2
1
2
1
1
2
2
3
1
2
2
2
1
2
2
2
7
9
8
6
5
7
8
5
5
3
7
7
9
9
8
5
8
10
6
7
7
3
9
9
7
9
7
2
9
8
8
9
1
5
8
4
9
2
8
4
4
8
8
9
9
6
8
8
7
9
1
8
4
194
50
398
11
129
182
56
234
82
97
233
352
159
324
286
93
25
321
68
251
42
3
139
463
334
216
2
176
308
68
267
34
286
0
0
314
21
24
119
94
231
308
164
34
166
3
26
380
8
188
14
5
5
4
4
5
5
2
3
3
4
4
5
5
5
4
5
1
5
4
5
5
5
5
5
2
5
5
3
3
4
3
4
5
1
1
1
5
5
5
5
5
4
5
4
5
4
5
5
4
4
2
4
5
5
3
5
2
3
3
1
5
5
4
5
2
3
3
1
4
5
1
3
4
5
5
5
5
4
5
3
5
3
3
4
4
3
4
5
5
2
5
3
3
1
2
5
4
5
3
5
5
2
5
5
3
4
5
2
3
2
5
3
5
3
2
4
2
5
1
3
4
5
2
1
2
5
5
4
1
4
1
2
2
4
4
5
1
1
2
4
2
1
2
4
2
5
5
5
5
5
5
1
1
4
4
4
5
1
5
5
4
4
2
5
3
3
2
2
2
3
5
5
1
3
5
5
3
4
4
4
4
3
5
4
3
4
3
2
3
2
5
5
4
4
5
5
5
3
3
4
4
5
4
5
3
1
5
3
1
4
2
2
1
2
1
2
1
3
1
3
1
3
1
2
3
1
1
1
1
1
2
2
2
3
4
2
3
2
1
1
1
1
1
3
2
3
5
2
1
5
3
1
2
1
2
2
2
4
1
2
7
7
5
9
8
3
4
2
5
7
6
5
4
6
8
10
4
4
6
6
4
5
8
9
7
5
5
4
6
7
8
9
8
7
9
8
5
8
7
8
9
0
3
9
4
8
5
8
8
10
8
7
3
51
180
67
47
185
291
244
149
63
36
344
44
99
160
114
10
66
107
83
31
19
30
112
77
39
99
61
73
74
251
184
58
327
182
150
56
156
364
22
190
344
47
6
29
103
140
72
120
295
44
3
2
4
1
5
3
3
2
3
4
5
5
4
5
3
5
4
4
3
2
3
5
4
5
2
5
1
1
3
5
1
4
4
5
5
4
2
4
5
2
4
4
4
5
4
4
4
5
3
3
1
5
4
5
5
4
4
2
3
3
5
4
3
4
3
3
1
5
1
2
5
2
3
3
5
5
2
3
5
4
3
5
1
5
5
5
4
5
1
4
5
5
1
5
4
1
5
3
5
4
3
4
3
4
2
4
5
1
4
1
4
1
1
1
1
5
4
5
4
1
1
5
4
4
3
5
4
5
5
3
1
1
1
5
4
4
5
2
1
2
5
4
2
5
1
1
5
1
1
3
2
4
1
2
4
4
4
5
5
4
1
2
5
3
2
2
2
4
5
5
5
5
4
4
4
3
4
3
5
5
2
5
5
5
5
5
2
3
5
3
3
5
2
4
2
5
3
5
2
5
3
3
5
2
4
3
4
5
5
3
1
1
3
2
3
4
4
3
2
4
2
2
1
2
4
5
1
3
1
2
3
2
1
3
2
1
4
3
3
1
4
3
4
3
2
3
2
2
1
3
3
1
2
4
1
1
1
4
5
2
5
9
5
4
8
4
7
6
9
9
4
3
0
10
2
8
4
1
8
8
8
1
9
3
7
5
5
7
0
2
4
7
7
7
5
5
8
4
9
3
7
4
4
4
8
0
5
7
4
9
3
5
0
45
211
429
176
181
280
28
224
45
367
58
55
120
38
266
370
32
271
375
283
22
467
129
155
103
140
332
214
0
223
127
4
346
8
210
26
0
130
291
278
248
225
263
19
15
5
4
5
3
4
5
5
4
4
5
4
2
5
5
5
4
4
5
3
4
5
4
5
5
4
4
2
5
5
2
5
5
4
5
4
5
5
5
2
2
5
5
4
5
4
5
3
4
3
2
3
5
3
5
1
5
5
5
4
5
4
3
3
1
4
5
5
5
4
4
5
1
4
2
5
4
3
3
5
1
5
3
2
4
4
4
3
2
5
1
1
1
4
1
1
1
5
5
5
2
5
4
1
1
5
5
5
5
4
5
4
1
1
2
2
5
5
5
5
5
4
5
5
1
2
2
1
4
5
4
3
5
5
4
2
4
3
4
4
3
3
4
5
4
5
5
5
5
5
5
5
5
4
3
4
5
1
4
3
4
4
2
5
4
1
2
3
5
3
5
5
3
5
2
5
5
4
5
1
4
2
1
2
4
2
5
3
3
3
1
3
2
2
2
2
5
3
1
4
2
1
2
3
5
1
2
1
3
1
5
1
4
1
2
3
1
1
2
2
5
1
5
2
3
2
5
3
5
8
7
0
7
6
9
5
7
7
4
9
4
1
8
8
4
2
9
9
10
2
7
9
4
5
7
3
8
2
9
7
8
9
8
8
8
1
8
2
8
4
7
Aegis Home Inspections Inc.
Dr. Mark DAntonio of Northern Virginia Community College provided this case and
associated data. The company and data were totally fabricated. Any resemblance to any
organization is coincidental. Please use Microsoft Excel to do this assignment.
Note: The original questions/data are modified by me.
Background
Aegis Inc. is a home inspection firm based in the Northern Virginia area. The President of
the company, Ms. Rose Wilson, is concerned about the morale of the sales team. Ms. Wilson had
contracted a local firm to survey the employees of Aegis Inc. and the results were delivered to her
in an EXCEL file Aegis_Home_inspections_data_Modified.xlsx. She has tasked her Vice
President of Human Resources, Mark Wolfe, to analyse the results of the survey and to report the
results to her. Ms. Wilson told Mark that she was concerned about the attitudes of the sales force.
In addition to the questions that were asked some additional data were recorded: the most recent
base annual salary, commission and total pay, the years of seniority, the sales region of the
individual, the gender (0=male, 1=female) and the number of contracts written in the pay period.
The survey instructions indicated that the first 5 questions were measured using a 5-point scale
using the following key: 1 = strongly disagree, 2 = disagree, 3 = neither agree nor disagree, 4 =
agree, 5 = strongly agree. The questions were as follows:
Q1:
Q2:
Q3:
Q4:
Q5:
Aegis Inc. has a good mentoring program
Aegis Inc. is committed to delivering good value to customers
Aegis Inc. has very traditional and conservative values
Aegis Inc. company practices favor men
Aegis Inc. has a lot of internal power politics.
The final question used a 1-10 scale:
Q6:
On a numeric scale, where 0 means totally autocratic and 10 means totally democratic,
how would you rate the management style at Aegis Inc.?
There are only 2 divisional managers for Aegis Inc. The geographic regions of the sales team are
as follows:
Region
Number
1
2
3
4
5
6
Divisional
Manager
A
A
A
B
B
B
Area
South East
North East
Midwest
South West
Mountain States
West Coast
Total
Size of Sales
Force
60
93
59
49
80
67
408
Region 4 was only established eight months ago. Prior to that time, the branches were part of
Regions 1, 5 and 6.
BUS 224 Case Study
1
INSTRUCTIONS (This project is worth 75 points 0lease FULLY answer all questions in detail)
For this assignment, submit one Excel file. Name the file as Group Case Study_your group name.
Answer the following questions
The file Aegis_Home_inspections_data_Modified.xlsx contains data from a survey of 408
employees of Aegis Inc. regarding the morale of the sales team. For this assignment, consider
this data set as the population frame.
1) Create a copy of this population frame. Paste the population frame to a new sheet. Rename
this new sheet to Part 1. Use Part 1 sheet to answer the following parts (a), (b), (c), and (d):
a. Recode the data into a new data set, making one transformation: change GENDER
to list ale/r ¥maleàUsing this newly recoded GENDER variable, create a pie
chart to show percentage of male and female. Is higher percentage of the employees
female? Use an appropriate title for your chart.
b. Is Q1 (Aegis Inc. has a good mentoring program) variable nominal or ordinal? For Q1
variable, create a column chart (so-called bar) of counts. Use an appropriate title for
your chart. Do majority of the employees agree or strongly agree Aegis has good
mentoring program?
c. For Q2 (Aegis Inc. is committed to delivering good value to customers) variable,
create a column chart (so-called bar) of counts. Use an appropriate title for your
chart. Accroding to the opinion of the employees, is the company committed to
deliver good value to the customers?
d. For Q5 (Aegis Inc. has a lot of internal power politics) variable, create a column chart
(so-called bar) of counts. Use an appropriate title for your chart. Do majority of the
employees agree or strongly agree Aegis has a lot of internal power politics?
See screen shot below:
BUS 224 Case Study
2
2) Create a copy of