Conduct Quantitative Analysis
QR Questions and Answers
Apply Quantitative Reasoning Now that you have completed your analysis, think about the patterns you have seen in the workforce. In this final section, you will answer five questions and write a short essay. 1. From the created histogram, it appears that a large share of employees have a salary between $71,00-$90,000 and another small peak at $160,000 .this may indicate a reasonable promotion rate for employees.is this distribution unimodal or bimodal? please explain Answer Two peaks are recognized in the histogram at $71,000 - $90,000, and another small peak is identified at $160,000. This distribution with two visible peaks, also known as modes separated by a small gap in between, is defined as bimodal. A bimodal distribution is a collection of data with the two highest frequencies at least as far apart as the sum of the standard deviation. 2. The line chart, as detailed in your "Graph Charts" Excel spreadsheet, shows sales generally increasing over the years, although sales in the first three years were notably slower. Assuming that the sales are linear, please use the Forecast tool to find projected sales for 2020 thru 2024. Hint: An easy way to do this is to highlight the sales from the data page and apply the Forecast tool to this data or use the forecast function in excel. You will generate a chart on a new sheet (tab) with projected sales; rename this sheet "Projected Sales". Answer in the Excel sheet 3. The standard deviation provides insight into the distribution of values around the mean. If the standard deviation is small, in general, the more narrow the range between the lowest and highest value. That is, values will cluster close to the mean. From your descriptive statistics, describe the standard deviations of Salary, Hrly Rate, Yrs Worked, Education, and Age. What does this tell you about the variables? Answer The standard deviation (SD) for salary is $32,853, which is low since the mean is $99,672 and the minimum salary is $32,367. This means the data is clustered around the mean. This data shows that 68% of the salaries are $99,672 plus or minus $32,853 (1 standard deviation away from the mean), 95% of the salaries are $99,672 plus or minus $65,706 (2 standard deviations away from the mean), and 99.7% of the salaries are $99,672 plus or minus $98,559 (3 standard deviations from the mean). The hourly rate is correlated to the salary since the salary is calculated with the hourly rate. This means the SD for the hourly rate is $15.79, which is low, and the data is clustered to the mean. This data shows that 68% of the salaries are $47.92 plus or minus $15.79 (1 standard deviation away from the mean), 95% of the salaries are $47.92 plus or minus $31.58 (2 standard deviations away from the mean), and 99.7% of the salaries are $47.92 plus or minus $47.37 (3 standard deviations from the mean). The same goes for years of service, education, and age. 4. The company has a keen interest in the educational, race, and gender makeup of its workforce. Its emphasis is on a diverse, dynamic workforce. From your "Graph Charts" spreadsheet, describe your pie chart findings for these characteristics of the workforce. Describe how you would determine if the company was meeting expectations on these characteristics. Answer Gender is distributed by 79% males and 21% females since males are 4+ times more than females, the company was not meeting expectations for diversity. Education level is distributed by 55% of bachelor’s degree, 23% associate degree, 17% master’s degree, and 5% high school diploma. I would say it was meeting expectations since the company has a variety in education, which means a dynamic workforce. There was no racial diversity since 216 employees were Caucasian, 98 were African American, 33 were Hispanics, and 25 were Asians. 5. The company is conducting an analysis on how many positions to create to keep up with demand. Specifically, it wants to know an estimate of the number of positions per job title. From your Excel chart, identify the mode of the job title distribution. Describe your findings. Answer The highest number in roles is Machine with 159 out of 372 employees. This means this role is most of the workforce of the company’s production. Therefore, the company needs to create different levels of the Machine’s position with higher salaries depending on the level, perhaps like apprentice Machine, journeyman Machine, and supervisor Machine to influence faster production and growth. As the company grows, it should implement an internship program to fill the gaps between levels and target individuals with higher education levels. In conclusion, the company needs further review in areas such as race and gender. A company must hire people from all backgrounds since different races bring distinctly ideas and other skills that they can offer to help to enhance the company. Diversity brings many benefits to an organization, such as innovation and faster growth. Another improvement could be a better promotion since the histogram showed a high peak between $71,000 - $90,000, but a slight rise at $160,000, meaning the promotion rate for employees is not high enough and could be improved. The company is doing excellent financially as the projected sales generally increase over the years, and it is forecast to grow even more. This forecast data can mean growth for the company, creating more positions. This can be a perfect opportunity to increase diversification in race and gender. Overall, the company is doing well, but some areas need improvement. It will be beneficial to collect data on employee satisfaction and desires to understand its health.
Data Set
| Workforce Profile Analysis | |||||||||||||||
| Section 1: Complete all Columns in Data Set | |||||||||||||||
| Format for: |
Windows User: Format cells in column according to indicated format. |
||||||||||||||
| Number | Date | Text | Currency | Currency | General | Number | Number | General | Number | Number | Number | Text | General | ||
| mm/dd/yy | |||||||||||||||
| Year Ending | Vested Yr | ||||||||||||||
| 12/31/19 | 10 | ||||||||||||||
| Emp # | Hire Date | Role | Salary | Hrly Rate | Yrs of Svc | Ed | Age | Vested | Race | Gender | Status | State | Region | ||
| 1001 | 04/23/15 | CEO | $239,315 | $115.06 | 5 | 19 | 58 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1596 | 07/13/02 | CFO | $186,925 | $89.87 | 17 | 16 | 39 | Yes | 1 | 1 | 1 | IL | Midwest | ||
| 1744 | 11/25/18 | Eng Mgr | $186,670 | $89.75 | 1 | 16 | 60 | No | 1 | 1 | 2 | PA | Northeast | ||
| 1357 | 01/26/10 | COO | $179,195 | $86.15 | 10 | 19 | 50 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1796 | 12/29/11 | Sales Mgr | $178,456 | $85.80 | 8 | 16 | 34 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1272 | 10/02/11 | IT Mgr | $175,916 | $84.58 | 8 | 14 | 44 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1055 | 01/01/12 | Controller | $172,291 | $82.83 | 8 | 16 | 57 | No | 1 | 1 | 1 | IL | Midwest | ||
| 1357 | 05/09/11 | Advertg | $172,291 | $82.83 | 9 | 16 | 52 | No | 3 | 1 | 1 | NE | C-Plains | levels | |
| 1672 | 05/27/04 | Sr Flr Mgr | $170,954 | $82.19 | 16 | 12 | 49 | Yes | 3 | 1 | 2 | PA | Northeast | ||
| 1693 | 02/06/14 | Engineering | $164,033 | $78.86 | 6 | 16 | 54 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1756 | 12/12/14 | Sr Flr Mgr | $164,033 | $78.86 | 5 | 14 | 30 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1793 | 08/19/06 | Sr Sales Mgr | $163,045 | $78.39 | 13 | 16 | 33 | Yes | 1 | 1 | 1 | IL | Midwest | ||
| 1102 | 06/05/11 | IT Staff | $163,045 | $78.39 | 9 | 16 | 50 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1308 | 07/10/11 | IT Staff | $162,731 | $78.24 | 8 | 16 | 53 | No | 1 | 1 | 2 | IL | Midwest | ||
| 1506 | 10/20/13 | IT Staff | $162,731 | $78.24 | 6 | 16 | 54 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1049 | 05/21/06 | IT Staff | $162,731 | $78.24 | 14 | 16 | 32 | Yes | 1 | 1 | 1 | PA | Northeast | ||
| 1014 | 09/13/13 | IT Staff | $162,030 | $77.90 | 6 | 14 | 38 | No | 2 | 1 | 2 | NE | C-Plains | ||
| 1814 | 04/14/12 | Sr Sales Mgr | $162,030 | $77.90 | 8 | 12 | 31 | No | 4 | 1 | 2 | IL | Midwest | ||
| 1071 | 05/30/13 | Engineering | $161,867 | $77.82 | 7 | 16 | 26 | No | 3 | 1 | 2 | IL | Midwest | ||
| 1770 | 12/03/15 | Engineering | $159,215 | $76.55 | 4 | 19 | 40 | No | 1 | 1 | 1 | IL | Midwest | ||
| 1785 | 06/07/16 | Engineering | $158,066 | $75.99 | 4 | 16 | 28 | No | 4 | 1 | 1 | IL | Midwest | ||
| 1616 | 09/04/06 | Engineering | $156,750 | $75.36 | 13 | 16 | 38 | Yes | 4 | 1 | 1 | PA | Northeast | ||
| 1215 | 06/17/18 | Engineering | $156,750 | $75.36 | 2 | 16 | 51 | No | 3 | 1 | 2 | NE | C-Plains | ||
| 1071 | 02/01/12 | Engineering | $156,750 | $75.36 | 8 | 16 | 61 | No | 1 | 1 | 2 | NE | C-Plains | ||
| 1667 | 02/28/12 | Engineering | $154,933 | $74.49 | 8 | 16 | 34 | No | 3 | 1 | 2 | PA | Northeast | ||
| 1265 | 01/18/16 | Engineering | $154,933 | $74.49 | 4 | 16 | 24 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1084 | 10/29/12 | Sales | $154,933 | $74.49 | 7 | 19 | 43 | No | 3 | 1 | 2 | IL | Midwest | ||
| 1257 | 07/15/03 | Engineering | $154,933 | $74.49 | 16 | 16 | 31 | Yes | 1 | 1 | 1 | NE | C-Plains | ||
| 1299 | 04/04/17 | Shp Mgr | $154,122 | $74.10 | 3 | 14 | 35 | No | 3 | 1 | 2 | PA | Northeast | ||
| 1202 | 10/02/16 | Acctg/Fin | $154,122 | $74.10 | 3 | 19 | 33 | No | 1 | 1 | 2 | IL | Midwest | ||
| 1424 | 07/15/09 | Sr Mach | $154,122 | $74.10 | 10 | 12 | 49 | Yes | 3 | 2 | 2 | PA | Northeast | ||
| 1356 | 07/02/15 | Sr Sales Mgr | $152,446 | $73.29 | 4 | 14 | 36 | No | 4 | 1 | 2 | IL | Midwest | ||
| 1088 | 09/18/07 | Sr Flr Mgr | $152,446 | $73.29 | 12 | 16 | 54 | Yes | 3 | 1 | 1 | NE | C-Plains | ||
| 1325 | 07/18/17 | Sr Mach | $152,446 | $73.29 | 2 | 16 | 37 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1220 | 10/16/16 | Sr Mach | $152,030 | $73.09 | 3 | 16 | 25 | No | 3 | 2 | 1 | NE | C-Plains | ||
| 1188 | 11/15/15 | Engineering | $151,523 | $72.85 | 4 | 16 | 41 | No | 1 | 1 | 1 | NE | C-Plains | ||
| 1749 | 07/07/08 | Sr Mach | $151,523 | $72.85 | 11 | 16 | 56 | Yes | 1 | 1 | 1 | IL | Midwest | ||
| 1246 | 08/25/10 | Sr Mach | $151,523 | $72.85 | 9 | 16 | 34 | No | 3 | 1 | 2 | PA | Northeast | ||
| 1113 | 12/31/04 | Sr Mach | $151,174 | $72.68 | 15 | 16 | 38 | Yes | 3 | 1 | 1 | PA | Northeast | ||
| 1822 | 02/26/07 | Engineering | $151,174 | $72.68 | 13 | 16 | 38 | Yes | 3 | 1 | 1 | NE | C-Plains | ||
| 1116 | 07/21/08 | Quality | $151,174 | $72.68 | 11 | 16 | 40 | Yes | 3 | 2 | 1 | PA | Northeast | ||
| 1803 | 05/07/17 | Mrktg | $150,868 | $72.53 | 3 | 16 | 53 | No | 2 | 1 | 1 | NE | C-Plains | ||
| 1444 | 11/05/13 | Mrktg | $150,263 | $72.24 | 6 | 16 | 57 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1379 | 08/13/17 | Mrktg | $150,263 | $72.24 | 2 | 12 | 53 | No | 2 | 1 | 1 | NE | C-Plains | ||
| 1726 | 08/31/16 | Design | $149,466 | $71.86 | 3 | 16 | 31 | No | 4 | 1 | 1 | IL | Midwest | ||
| 1793 | 08/30/13 | Design | $149,466 | $71.86 | 6 | 16 | 42 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1848 | 08/31/11 | Design | $149,466 | $71.86 | 8 | 19 | 30 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1300 | 08/04/14 | Engineering | $148,111 | $71.21 | 5 | 16 | 36 | No | 2 | 1 | 1 | NE | C-Plains | ||
| 1400 | 12/24/16 | Design | $148,111 | $71.21 | 3 | 14 | 33 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1846 | 05/16/03 | Design | $148,111 | $71.21 | 17 | 16 | 39 | Yes | 3 | 1 | 1 | NE | C-Plains | ||
| 1069 | 05/29/12 | Engineering | $145,776 | $70.08 | 8 | 16 | 59 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1841 | 06/30/17 | Design | $145,776 | $70.08 | 3 | 19 | 30 | No | 3 | 2 | 2 | IL | Midwest | ||
| 1002 | 02/24/16 | Design | $144,571 | $69.51 | 4 | 16 | 36 | No | 4 | 1 | 2 | PA | Northeast | ||
| 1654 | 01/14/09 | Engineering | $144,571 | $69.51 | 11 | 16 | 39 | Yes | 3 | 1 | 1 | IL | Midwest | ||
| 1640 | 02/20/14 | Design | $143,063 | $68.78 | 6 | 14 | 36 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1269 | 12/04/17 | Design | $143,063 | $68.78 | 2 | 16 | 31 | No | 1 | 1 | 2 | NE | C-Plains | ||
| 1737 | 12/04/11 | Invent | $143,005 | $68.75 | 8 | 19 | 36 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1424 | 09/30/17 | Flr Supr | $143,005 | $68.75 | 2 | 14 | 25 | No | 4 | 2 | 2 | IL | Midwest | ||
| 1608 | 09/06/17 | Flr Supr | $141,110 | $67.84 | 2 | 16 | 37 | No | 1 | 2 | 1 | IL | Midwest | ||
| 1308 | 07/19/12 | Engineering | $141,110 | $67.84 | 7 | 16 | 36 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1128 | 07/16/01 | Flr Supr | $140,865 | $67.72 | 18 | 19 | 49 | Yes | 1 | 1 | 2 | NE | C-Plains | ||
| 1133 | 09/11/14 | Sales | $140,865 | $67.72 | 5 | 14 | 30 | No | 3 | 1 | 2 | NE | C-Plains | ||
| 1608 | 08/26/05 | Sales | $139,515 | $67.07 | 14 | 16 | 52 | Yes | 1 | 2 | 1 | NE | C-Plains | ||
| 1062 | 03/14/14 | Flr Supr | $139,377 | $67.01 | 6 | 16 | 27 | No | 3 | 1 | 2 | IL | Midwest | ||
| 1381 | 11/29/11 | Sales | $135,533 | $65.16 | 8 | 14 | 28 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1403 | 11/23/17 | Sales | $134,847 | $64.83 | 2 | 16 | 55 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1432 | 03/26/12 | Design | $133,678 | $64.27 | 8 | 16 | 52 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1224 | 07/15/03 | Engineering | $133,138 | $64.01 | 16 | 16 | 33 | Yes | 3 | 2 | 1 | IL | Midwest | ||
| 1288 | 10/29/14 | Sales | $132,230 | $63.57 | 5 | 19 | 31 | No | 1 | 1 | 1 | IL | Midwest | ||
| 1189 | 03/09/18 | Sales | $132,142 | $63.53 | 2 | 14 | 53 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1754 | 04/24/11 | Sr Mach | $131,698 | $63.32 | 9 | 14 | 63 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1597 | 07/11/04 | Flr Supr | $131,580 | $63.26 | 15 | 14 | 41 | Yes | 3 | 1 | 1 | PA | Northeast | ||
| 1258 | 10/27/15 | Sr Mach | $128,943 | $61.99 | 4 | 14 | 49 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1797 | 06/05/17 | Sr Mach | $128,901 | $61.97 | 3 | 14 | 26 | No | 3 | 1 | 2 | NE | C-Plains | ||
| 1456 | 07/16/12 | Sr Mach | $128,825 | $61.94 | 7 | 16 | 25 | No | 3 | 1 | 2 | PA | Northeast | ||
| 1297 | 12/14/13 | Sr Mach | $128,384 | $61.72 | 6 | 16 | 28 | No | 1 | 2 | 2 | NE | C-Plains | ||
| 1443 | 11/26/14 | Sr Mach | $127,890 | $61.49 | 5 | 12 | 47 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1541 | 06/22/14 | Sr Mach | $127,190 | $61.15 | 6 | 16 | 34 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1417 | 02/15/16 | Sr Mach | $126,426 | $60.78 | 4 | 14 | 56 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1315 | 04/04/19 | Sr Mach | $125,367 | $60.27 | 1 | 16 | 35 | No | 3 | 1 | 2 | IL | Midwest | ||
| 1317 | 05/09/13 | Sr Mach | $125,156 | $60.17 | 7 | 19 | 31 | No | 1 | 1 | 1 | IL | Midwest | ||
| 1774 | 11/30/06 | Flr Supr | $125,004 | $60.10 | 13 | 16 | 32 | Yes | 1 | 2 | 1 | PA | Northeast | ||
| 1748 | 09/17/06 | Mrktg | $124,996 | $60.09 | 13 | 16 | 49 | Yes | 2 | 1 | 2 | PA | Northeast | ||
| 1550 | 07/10/11 | Sr Mach | $123,391 | $59.32 | 8 | 12 | 59 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1261 | 08/01/04 | Sr Mach | $122,391 | $58.84 | 15 | 16 | 48 | Yes | 4 | 1 | 2 | IL | Midwest | ||
| 1568 | 04/09/13 | Sr Mach | $122,352 | $58.82 | 7 | 16 | 28 | No | 3 | 2 | 2 | IL | Midwest | ||
| 1429 | 11/02/14 | Sr Mach | $121,455 | $58.39 | 5 | 16 | 40 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1346 | 06/24/18 | Sr Mach | $120,986 | $58.17 | 2 | 19 | 29 | No | 4 | 1 | 1 | IL | Midwest | ||
| 1673 | 01/06/17 | Mrktg | $119,537 | $57.47 | 3 | 19 | 47 | No | 4 | 1 | 2 | PA | Northeast | ||
| 1320 | 11/23/19 | Sr Mach | $119,285 | $57.35 | 0 | 16 | 28 | No | 3 | 1 | 2 | NE | C-Plains | ||
| 1153 | 08/17/07 | Sr Mach | $119,165 | $57.29 | 12 | 16 | 31 | Yes | 4 | 1 | 1 | PA | Northeast | ||
| 1003 | 03/23/16 | Sr Mach | $119,156 | $57.29 | 4 | 16 | 41 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1787 | 11/18/13 | Acctg/Fin | $118,997 | $57.21 | 6 | 14 | 25 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1515 | 07/11/03 | Acctg/Fin | $117,692 | $56.58 | 16 | 14 | 43 | Yes | 1 | 1 | 2 | IL | Midwest | ||
| 1679 | 01/24/13 | Acctg/Fin | $117,214 | $56.35 | 7 | 16 | 54 | No | 2 | 1 | 1 | PA | Northeast | ||
| 1831 | 09/04/04 | Sr Mach | $117,062 | $56.28 | 15 | 16 | 27 | Yes | 3 | 1 | 1 | PA | Northeast | ||
| 1733 | 09/19/15 | Flr Supr | $116,208 | $55.87 | 4 | 16 | 32 | No | 1 | 1 | 1 | NE | C-Plains | ||
| 1835 | 06/24/13 | Sr Mach | $116,075 | $55.81 | 7 | 19 | 37 | No | 1 | 1 | 2 | IL | Midwest | ||
| 1276 | 08/05/11 | IT Staff | $115,974 | $55.76 | 8 | 16 | 54 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1038 | 07/18/14 | IT Staff | $115,966 | $55.75 | 5 | 16 | 42 | No | 3 | 2 | 1 | PA | Northeast | ||
| 1498 | 12/08/14 | Sr Mach | $115,580 | $55.57 | 5 | 16 | 54 | No | 1 | 1 | 1 | IL | Midwest | ||
| 1227 | 09/06/10 | Invent | $115,283 | $55.42 | 9 | 14 | 37 | No | 1 | 1 | 1 | IL | Midwest | ||
| 1841 | 11/03/17 | Sr Mach | $114,854 | $55.22 | 2 | 14 | 26 | No | 3 | 1 | 2 | PA | Northeast | ||
| 1668 | 12/16/10 | Advertg | $114,721 | $55.15 | 9 | 14 | 51 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1616 | 03/30/11 | Advertg | $114,251 | $54.93 | 9 | 14 | 44 | No | 2 | 2 | 1 | PA | Northeast | ||
| 1804 | 02/05/14 | Quality | $113,246 | $54.45 | 6 | 19 | 34 | No | 2 | 1 | 1 | PA | Northeast | ||
| 1218 | 12/25/15 | Design | $113,056 | $54.35 | 4 | 19 | 56 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1637 | 12/09/07 | Sales | $113,023 | $54.34 | 12 | 16 | 28 | Yes | 3 | 1 | 2 | IL | Midwest | ||
| 1444 | 08/28/07 | Sales | $112,994 | $54.32 | 12 | 16 | 38 | Yes | 3 | 1 | 1 | PA | Northeast | ||
| 1466 | 06/01/11 | Sales | $112,402 | $54.04 | 9 | 14 | 41 | No | 2 | 1 | 1 | IL | Midwest | ||
| 1623 | 07/10/18 | Engineering | $112,223 | $53.95 | 1 | 16 | 44 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1447 | 11/07/13 | Sales | $111,801 | $53.75 | 6 | 16 | 60 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1477 | 03/08/17 | Purch | $111,794 | $53.75 | 3 | 19 | 45 | No | 1 | 1 | 2 | NE | C-Plains | ||
| 1519 | 01/19/18 | Design | $111,536 | $53.62 | 2 | 16 | 51 | No | 1 | 1 | 1 | NE | C-Plains | ||
| 1517 | 06/01/06 | Engineering | $111,424 | $53.57 | 14 | 16 | 35 | Yes | 3 | 1 | 1 | NE | C-Plains | ||
| 1554 | 07/27/16 | Engineering | $111,196 | $53.46 | 3 | 16 | 36 | No | 4 | 1 | 1 | NE | C-Plains | ||
| 1531 | 08/27/07 | Design | $110,877 | $53.31 | 12 | 19 | 50 | Yes | 3 | 1 | 1 | PA | Northeast | ||
| 1098 | 01/21/11 | Engineering | $110,708 | $53.23 | 9 | 16 | 55 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1669 | 12/13/15 | Design | $109,128 | $52.47 | 4 | 16 | 48 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1776 | 11/11/10 | Design | $108,866 | $52.34 | 9 | 16 | 27 | No | 1 | 2 | 1 | PA | Northeast | ||
| 1411 | 12/28/05 | Design | $108,604 | $52.21 | 14 | 19 | 47 | Yes | 3 | 2 | 1 | PA | Northeast | ||
| 1773 | 10/07/17 | Purch | $108,342 | $52.09 | 2 | 16 | 34 | No | 3 | 2 | 1 | IL | Midwest | ||
| 1760 | 12/03/13 | Design | $108,326 | $52.08 | 6 | 19 | 41 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1625 | 06/04/11 | Purch | $108,058 | $51.95 | 9 | 16 | 37 | No | 4 | 1 | 2 | IL | Midwest | ||
| 1846 | 05/03/12 | Engineering | $107,530 | $51.70 | 8 | 14 | 42 | No | 3 | 2 | 2 | NE | C-Plains | ||
| 1794 | 01/29/12 | Engineering | $107,496 | $51.68 | 8 | 16 | 43 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1584 | 06/21/10 | Machine | $107,153 | $51.52 | 10 | 16 | 51 | No | 3 | 2 | 1 | NE | C-Plains | ||
| 1776 | 10/14/15 | Machine | $106,640 | $51.27 | 4 | 14 | 40 | No | 4 | 2 | 1 | IL | Midwest | ||
| 1527 | 09/28/04 | Machine | $106,600 | $51.25 | 15 | 16 | 60 | Yes | 3 | 1 | 1 | PA | Northeast | ||
| 1800 | 12/28/10 | Machine | $106,267 | $51.09 | 9 | 16 | 40 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1130 | 10/11/15 | Machine | $105,637 | $50.79 | 4 | 19 | 44 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1552 | 7/13/11 | Machine | $105,069 | $50.51 | 8 | 16 | 21 | No | 1 | 1 | 2 | IL | Midwest | ||
| 1190 | 12/29/17 | Machine | $104,961 | $50.46 | 2 | 16 | 41 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1830 | 7/4/13 | Machine | $104,793 | $50.38 | 6 | 14 | 25 | No | 3 | 2 | 1 | NE | C-Plains | ||
| 1840 | 9/4/06 | Machine | $104,220 | $50.11 | 13 | 19 | 51 | Yes | 3 | 2 | 1 | PA | Northeast | ||
| 1083 | 7/4/16 | Machine | $103,736 | $49.87 | 3 | 19 | 56 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1308 | 7/17/02 | Machine | $103,721 | $49.87 | 17 | 14 | 46 | Yes | 3 | 1 | 1 | NE | C-Plains | ||
| 1394 | 04/01/07 | Machine | $103,349 | $49.69 | 13 | 14 | 56 | Yes | 3 | 1 | 2 | PA | Northeast | ||
| 1850 | 11/26/06 | Invent | $102,913 | $49.48 | 13 | 16 | 25 | Yes | 1 | 2 | 2 | IL | Midwest | ||
| 1036 | 06/10/11 | Machine | $102,641 | $49.35 | 9 | 14 | 29 | No | 1 | 1 | 1 | NE | C-Plains | ||
| 1393 | 2/24/18 | Machine | $102,238 | $49.15 | 2 | 16 | 45 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1764 | 8/31/05 | Machine | $101,709 | $48.90 | 14 | 16 | 24 | Yes | 4 | 1 | 1 | NE | C-Plains | ||
| 1055 | 2/12/08 | Machine | $101,386 | $48.74 | 12 | 16 | 27 | Yes | 1 | 1 | 2 | PA | Northeast | ||
| 1809 | 7/1/17 | Machine | $101,360 | $48.73 | 3 | 16 | 40 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1756 | 12/29/11 | Machine | $101,341 | $48.72 | 8 | 14 | 39 | No | 3 | 2 | 2 | PA | Northeast | ||
| 1292 | 04/29/12 | Machine | $101,016 | $48.57 | 8 | 16 | 35 | No | 4 | 1 | 2 | PA | Northeast | ||
| 1055 | 12/16/09 | Machine | $100,632 | $48.38 | 10 | 16 | 47 | Yes | 3 | 1 | 1 | NE | C-Plains | ||
| 1468 | 9/25/08 | Machine | $100,571 | $48.35 | 11 | 16 | 42 | Yes | 2 | 2 | 1 | NE | C-Plains | ||
| 1101 | 07/19/08 | Invent | $100,520 | $48.33 | 11 | 19 | 44 | Yes | 3 | 1 | 1 | IL | Midwest | ||
| 1492 | 8/20/15 | Machine | $100,314 | $48.23 | 4 | 16 | 51 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1757 | 10/16/14 | Machine | $100,198 | $48.17 | 5 | 16 | 34 | No | 1 | 2 | 1 | IL | Midwest | ||
| 1106 | 9/2/15 | Machine | $99,821 | $47.99 | 4 | 12 | 36 | No | 3 | 2 | 2 | IL | Midwest | ||
| 1190 | 5/6/18 | Machine | $99,786 | $47.97 | 2 | 14 | 31 | No | 1 | 2 | 2 | PA | Northeast | ||
| 1588 | 1/4/18 | Machine | $99,135 | $47.66 | 2 | 14 | 35 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1424 | 12/10/12 | Sales | $99,130 | $47.66 | 7 | 14 | 50 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1569 | 05/20/13 | Quality | $98,943 | $47.57 | 7 | 16 | 36 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1550 | 08/25/03 | IT Staff | $98,771 | $47.49 | 16 | 19 | 59 | Yes | 1 | 1 | 1 | IL | Midwest | ||
| 1175 | 12/07/18 | Machine | $98,634 | $47.42 | 1 | 16 | 52 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1220 | 09/27/12 | Machine | $98,234 | $47.23 | 7 | 16 | 58 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1513 | 06/10/13 | Machine | $98,007 | $47.12 | 7 | 19 | 28 | No | 1 | 1 | 2 | PA | Northeast | ||
| 1481 | 11/20/08 | Machine | $97,885 | $47.06 | 11 | 16 | 28 | Yes | 1 | 1 | 1 | PA | Northeast | ||
| 1418 | 05/01/12 | Quality | $97,323 | $46.79 | 8 | 14 | 34 | No | 1 | 2 | 1 | PA | Northeast | ||
| 1813 | 06/20/15 | Machine | $96,582 | $46.43 | 5 | 19 | 40 | No | 1 | 1 | 1 | NE | C-Plains | ||
| 1782 | 09/25/14 | Machine | $96,566 | $46.43 | 5 | 19 | 46 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1687 | 12/21/16 | Machine | $96,338 | $46.32 | 3 | 16 | 42 | No | 3 | 2 | 1 | PA | Northeast | ||
| 1557 | 07/11/04 | Machine | $96,327 | $46.31 | 15 | 16 | 40 | Yes | 4 | 1 | 1 | NE | C-Plains | ||
| 1296 | 12/17/06 | Quality | $96,062 | $46.18 | 13 | 16 | 31 | Yes | 4 | 2 | 1 | IL | Midwest | ||
| 1846 | 02/12/15 | Machine | $95,985 | $46.15 | 5 | 14 | 43 | No | 1 | 1 | 1 | NE | C-Plains | ||
| 1145 | 06/20/15 | Machine | $95,957 | $46.13 | 5 | 16 | 41 | No | 3 | 2 | 1 | IL | Midwest | ||
| 1461 | 02/23/16 | Advertg | $95,662 | $45.99 | 4 | 14 | 31 | No | 1 | 2 | 1 | PA | Northeast | ||
| 1285 | 02/06/10 | Advertg | $95,622 | $45.97 | 10 | 19 | 36 | No | 2 | 1 | 1 | PA | Northeast | ||
| 1558 | 01/28/10 | Machine | $95,220 | $45.78 | 10 | 19 | 31 | No | 2 | 1 | 1 | IL | Midwest | ||
| 1296 | 06/17/17 | Invent | $95,128 | $45.73 | 3 | 19 | 42 | No | 3 | 2 | 1 | IL | Midwest | ||
| 1216 | 10/05/04 | Shipping | $94,876 | $45.61 | 15 | 16 | 48 | Yes | 3 | 1 | 1 | PA | Northeast | ||
| 1579 | 11/18/09 | Machine | $94,700 | $45.53 | 10 | 14 | 35 | Yes | 1 | 1 | 2 | NE | C-Plains | ||
| 1422 | 02/02/04 | Sales | $94,038 | $45.21 | 16 | 16 | 30 | Yes | 1 | 1 | 2 | NE | C-Plains | ||
| 1180 | 07/21/14 | Machine | $93,936 | $45.16 | 5 | 19 | 47 | No | 3 | 1 | 2 | NE | C-Plains | ||
| 1104 | 08/05/12 | Machine | $93,518 | $44.96 | 7 | 14 | 39 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1661 | 11/10/11 | Sales | $92,931 | $44.68 | 8 | 16 | 51 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1323 | 01/12/06 | Machine | $92,847 | $44.64 | 14 | 16 | 31 | Yes | 3 | 1 | 1 | IL | Midwest | ||
| 1504 | 10/17/08 | Machine | $92,267 | $44.36 | 11 | 19 | 35 | Yes | 3 | 1 | 1 | IL | Midwest | ||
| 1771 | 08/13/17 | Machine | $92,079 | $44.27 | 2 | 19 | 40 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1667 | 12/15/06 | Machine | $92,076 | $44.27 | 13 | 14 | 47 | Yes | 2 | 1 | 1 | IL | Midwest | ||
| 1079 | 05/22/09 | Invent | $91,771 | $44.12 | 11 | 16 | 30 | Yes | 3 | 1 | 2 | PA | Northeast | ||
| 1364 | 11/28/18 | Machine | $91,748 | $44.11 | 1 | 16 | 36 | No | 3 | 1 | 2 | NE | C-Plains | ||
| 1767 | 11/16/05 | Machine | $91,507 | $43.99 | 14 | 19 | 53 | Yes | 3 | 1 | 1 | PA | Northeast | ||
| 1589 | 10/13/13 | Design | $91,444 | $43.96 | 6 | 19 | 61 | No | 4 | 1 | 1 | PA | Northeast | ||
| 1680 | 06/02/07 | Design | $91,205 | $43.85 | 13 | 14 | 37 | Yes | 3 | 1 | 1 | NE | C-Plains | ||
| 1779 | 08/11/14 | Machine | $91,131 | $43.81 | 5 | 19 | 30 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1387 | 01/10/17 | Machine | $90,930 | $43.72 | 3 | 19 | 45 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1793 | 05/17/15 | Shipping | $90,794 | $43.65 | 5 | 16 | 39 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1523 | 05/15/18 | Acctg/Fin | $90,688 | $43.60 | 2 | 16 | 23 | No | 1 | 2 | 2 | PA | Northeast | ||
| 1186 | 02/15/11 | Machine | $90,599 | $43.56 | 9 | 16 | 50 | No | 1 | 1 | 1 | IL | Midwest | ||
| 1097 | 09/26/13 | Machine | $90,153 | $43.34 | 6 | 14 | 40 | No | 4 | 1 | 1 | NE | C-Plains | ||
| 1709 | 12/12/12 | Machine | $89,522 | $43.04 | 7 | 19 | 68 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1096 | 03/16/11 | Machine | $89,197 | $42.88 | 9 | 14 | 21 | No | 3 | 1 | 2 | NE | C-Plains | ||
| 1227 | 01/04/14 | Machine | $89,165 | $42.87 | 6 | 19 | 49 | No | 3 | 2 | 1 | PA | Northeast | ||
| 1006 | 07/20/01 | Machine | $88,743 | $42.66 | 18 | 14 | 27 | Yes | 3 | 1 | 2 | IL | Midwest | ||
| 1836 | 04/18/18 | Machine | $88,743 | $42.66 | 2 | 19 | 33 | No | 2 | 2 | 2 | IL | Midwest | ||
| 1210 | 03/28/14 | Machine | $88,639 | $42.61 | 6 | 16 | 34 | No | 3 | 1 | 2 | NE | C-Plains | ||
| 1821 | 03/11/13 | Machine | $87,943 | $42.28 | 7 | 12 | 29 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1554 | 10/28/12 | Machine | $87,641 | $42.14 | 7 | 14 | 33 | No | 4 | 1 | 2 | IL | Midwest | ||
| 1289 | 12/04/11 | Machine | $87,601 | $42.12 | 8 | 16 | 30 | No | 4 | 1 | 1 | IL | Midwest | ||
| 1659 | 12/05/13 | Machine | $87,583 | $42.11 | 6 | 14 | 39 | No | 2 | 1 | 2 | IL | Midwest | ||
| 1452 | 08/11/16 | Machine | $87,519 | $42.08 | 3 | 16 | 37 | No | 3 | 2 | 1 | IL | Midwest | ||
| 1434 | 02/19/12 | Machine | $87,517 | $42.08 | 8 | 14 | 57 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1315 | 06/13/09 | Machine | $87,480 | $42.06 | 11 | 16 | 26 | Yes | 1 | 1 | 1 | NE | C-Plains | ||
| 1109 | 07/27/08 | Machine | $87,409 | $42.02 | 11 | 14 | 58 | Yes | 4 | 1 | 1 | IL | Midwest | ||
| 1829 | 05/29/18 | Machine | $87,407 | $42.02 | 2 | 14 | 51 | No | 1 | 1 | 1 | NE | C-Plains | ||
| 1565 | 04/11/04 | Machine | $87,092 | $41.87 | 16 | 16 | 30 | Yes | 3 | 1 | 1 | NE | C-Plains | ||
| 1476 | 12/10/15 | Purch | $87,056 | $41.85 | 4 | 16 | 41 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1019 | 05/01/17 | Machine | $87,054 | $41.85 | 3 | 14 | 34 | No | 2 | 1 | 1 | IL | Midwest | ||
| 1056 | 02/10/16 | Machine | $87,047 | $41.85 | 4 | 14 | 25 | No | 3 | 2 | 2 | PA | Northeast | ||
| 1593 | 06/14/06 | Shipping | $86,787 | $41.72 | 14 | 16 | 34 | Yes | 1 | 2 | 1 | IL | Midwest | ||
| 1630 | 12/02/09 | Shipping | $86,666 | $41.67 | 10 | 12 | 27 | Yes | 1 | 1 | 2 | PA | Northeast | ||
| 1373 | 10/20/12 | Machine | $86,597 | $41.63 | 7 | 14 | 44 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1456 | 08/15/18 | Machine | $86,384 | $41.53 | 1 | 16 | 26 | No | 3 | 1 | 2 | IL | Midwest | ||
| 1237 | 01/22/18 | Machine | $86,377 | $41.53 | 2 | 14 | 40 | No | 1 | 1 | 2 | IL | Midwest | ||
| 1638 | 01/31/11 | Machine | $86,199 | $41.44 | 9 | 16 | 27 | No | 4 | 2 | 2 | IL | Midwest | ||
| 1059 | 03/16/16 | Acctg/Fin | $86,147 | $41.42 | 4 | 16 | 39 | No | 2 | 1 | 1 | IL | Midwest | ||
| 1611 | 11/23/12 | Machine | $85,442 | $41.08 | 7 | 19 | 38 | No | 1 | 2 | 1 | IL | Midwest | ||
| 1553 | 06/13/04 | Machine | $85,256 | $40.99 | 16 | 16 | 41 | Yes | 3 | 1 | 1 | PA | Northeast | ||
| 1279 | 09/28/01 | Machine | $84,713 | $40.73 | 18 | 16 | 39 | Yes | 4 | 1 | 1 | PA | Northeast | ||
| 1426 | 11/06/07 | Machine | $84,679 | $40.71 | 12 | 19 | 35 | Yes | 3 | 1 | 1 | PA | Northeast | ||
| 1295 | 07/12/11 | Purch | $84,275 | $40.52 | 8 | 16 | 41 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1619 | 10/6/10 | Machine | $84,270 | $40.51 | 9 | 16 | 30 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1484 | 10/30/10 | Shipping | $84,175 | $40.47 | 9 | 16 | 37 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1723 | 7/16/01 | Machine | $84,076 | $40.42 | 18 | 19 | 36 | Yes | 3 | 2 | 1 | IL | Midwest | ||
| 1744 | 6/24/08 | Machine | $83,911 | $40.34 | 12 | 16 | 48 | Yes | 3 | 1 | 1 | NE | C-Plains | ||
| 1533 | 07/11/03 | Machine | $83,851 | $40.31 | 16 | 16 | 51 | Yes | 1 | 1 | 1 | PA | Northeast | ||
| 1387 | 01/04/16 | Machine | $83,430 | $40.11 | 4 | 16 | 38 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1343 | 10/06/09 | Machine | $83,424 | $40.11 | 10 | 16 | 44 | Yes | 3 | 2 | 1 | IL | Midwest | ||
| 1314 | 1/20/12 | Machine | $83,367 | $40.08 | 8 | 16 | 37 | No | 1 | 1 | 2 | PA | Northeast | ||
| 1267 | 5/3/14 | Machine | $83,294 | $40.05 | 6 | 16 | 49 | No | 3 | 1 | 2 | PA | Northeast | ||
| 1364 | 11/29/09 | Machine | $83,075 | $39.94 | 10 | 16 | 38 | Yes | 3 | 1 | 2 | NE | C-Plains | ||
| 1820 | 12/17/15 | Shipping | $82,601 | $39.71 | 4 | 19 | 41 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1138 | 7/20/01 | Machine | $82,515 | $39.67 | 18 | 16 | 39 | Yes | 1 | 1 | 2 | PA | Northeast | ||
| 1802 | 11/10/11 | Machine | $82,471 | $39.65 | 8 | 16 | 39 | No | 3 | 1 | 2 | PA | Northeast | ||
| 1591 | 7/17/02 | Machine | $82,411 | $39.62 | 17 | 16 | 37 | Yes | 3 | 1 | 1 | IL | Midwest | ||
| 1201 | 03/17/16 | Machine | $82,319 | $39.58 | 4 | 19 | 40 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1018 | 09/20/06 | Acctg/Fin | $82,016 | $39.43 | 13 | 16 | 44 | Yes | 3 | 1 | 1 | IL | Midwest | ||
| 1789 | 06/13/11 | Machine | $81,779 | $39.32 | 9 | 16 | 51 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1016 | 09/30/12 | Machine | $81,730 | $39.29 | 7 | 16 | 27 | No | 3 | 2 | 1 | IL | Midwest | ||
| 1005 | 04/29/11 | Machine | $81,287 | $39.08 | 9 | 16 | 65 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1785 | 12/01/18 | Shipping | $81,276 | $39.08 | 1 | 14 | 44 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1116 | 08/19/14 | Machine | $81,050 | $38.97 | 5 | 16 | 36 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1169 | 10/13/07 | Machine | $81,042 | $38.96 | 12 | 16 | 30 | Yes | 3 | 1 | 2 | NE | C-Plains | ||
| 1450 | 07/07/04 | Machine | $80,909 | $38.90 | 15 | 16 | 40 | Yes | 1 | 1 | 1 | IL | Midwest | ||
| 1575 | 03/12/13 | Machine | $80,666 | $38.78 | 7 | 16 | 44 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1061 | 07/07/17 | Machine | $80,198 | $38.56 | 2 | 16 | 37 | No | 1 | 1 | 1 | IL | Midwest | ||
| 1254 | 09/13/12 | Machine | $80,191 | $38.55 | 7 | 16 | 28 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1466 | 12/29/17 | Machine | $80,045 | $38.48 | 2 | 14 | 43 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1474 | 09/09/12 | Machine | $79,591 | $38.26 | 7 | 12 | 47 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1741 | 08/29/15 | Machine | $79,584 | $38.26 | 4 | 14 | 55 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1736 | 08/16/13 | Machine | $79,542 | $38.24 | 6 | 16 | 50 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1373 | 05/21/13 | Machine | $79,063 | $38.01 | 7 | 14 | 40 | No | 3 | 2 | 1 | IL | Midwest | ||
| 1504 | 01/13/15 | Shipping | $78,985 | $37.97 | 5 | 16 | 33 | No | 3 | 1 | 2 | IL | Midwest | ||
| 1553 | 08/10/13 | Machine | $78,900 | $37.93 | 6 | 12 | 26 | No | 3 | 1 | 2 | PA | Northeast | ||
| 1571 | 11/11/14 | Machine | $78,873 | $37.92 | 5 | 12 | 36 | No | 1 | 2 | 2 | PA | Northeast | ||
| 1185 | 06/18/09 | Machine | $78,869 | $37.92 | 11 | 16 | 39 | Yes | 3 | 1 | 1 | PA | Northeast | ||
| 1612 | 05/06/11 | Shipping | $78,529 | $37.75 | 9 | 16 | 44 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1232 | 08/25/18 | Shipping | $78,475 | $37.73 | 1 | 16 | 40 | No | 3 | 1 | 2 | PA | Northeast | ||
| 1816 | 06/27/12 | Machine | $78,334 | $37.66 | 8 | 19 | 34 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1391 | 10/02/15 | Machine | $78,015 | $37.51 | 4 | 16 | 31 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1422 | 11/16/15 | Machine | $77,495 | $37.26 | 4 | 16 | 45 | No | 3 | 2 | 2 | IL | Midwest | ||
| 1800 | 01/31/15 | Machine | $77,443 | $37.23 | 5 | 16 | 33 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1142 | 08/26/17 | Machine | $77,247 | $37.14 | 2 | 14 | 48 | No | 4 | 2 | 1 | IL | Midwest | ||
| 1300 | 10/08/10 | Machine | $76,956 | $37.00 | 9 | 16 | 26 | No | 3 | 1 | 2 | NE | C-Plains | ||
| 1332 | 10/07/14 | Shipping | $76,864 | $36.95 | 5 | 19 | 53 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1471 | 08/21/13 | Machine | $76,702 | $36.88 | 6 | 14 | 48 | No | 3 | 2 | 1 | NE | C-Plains | ||
| 1140 | 10/04/12 | Machine | $76,499 | $36.78 | 7 | 14 | 46 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1132 | 02/25/14 | Machine | $76,305 | $36.69 | 6 | 16 | 55 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1668 | 02/13/14 | Machine | $76,158 | $36.61 | 6 | 16 | 38 | No | 4 | 1 | 1 | NE | C-Plains | ||
| 1629 | 08/24/15 | Shipping | $76,031 | $36.55 | 4 | 19 | 42 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1750 | 12/19/09 | Machine | $75,969 | $36.52 | 10 | 14 | 37 | Yes | 3 | 1 | 2 | IL | Midwest | ||
| 1070 | 09/01/06 | Machine | $75,920 | $36.50 | 13 | 14 | 30 | Yes | 3 | 2 | 1 | PA | Northeast | ||
| 1083 | 10/08/11 | Machine | $75,612 | $36.35 | 8 | 16 | 31 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1196 | 03/08/15 | Machine | $75,415 | $36.26 | 5 | 12 | 48 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1053 | 01/04/05 | Machine | $75,293 | $36.20 | 15 | 16 | 57 | Yes | 3 | 2 | 1 | PA | Northeast | ||
| 1543 | 09/07/12 | Machine | $75,270 | $36.19 | 7 | 19 | 35 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1819 | 08/31/04 | Machine | $75,261 | $36.18 | 15 | 12 | 43 | Yes | 3 | 1 | 1 | IL | Midwest | ||
| 1145 | 10/12/12 | Machine | $75,179 | $36.14 | 7 | 14 | 49 | No | 1 | 2 | 2 | PA | Northeast | ||
| 1424 | 08/09/12 | Machine | $75,144 | $36.13 | 7 | 16 | 28 | No | 1 | 2 | 2 | NE | C-Plains | ||
| 1661 | 10/21/16 | Shipping | $75,074 | $36.09 | 3 | 19 | 58 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1660 | 11/01/16 | Machine | $75,053 | $36.08 | 3 | 14 | 25 | No | 3 | 1 | 2 | IL | Midwest | ||
| 1075 | 04/21/08 | Machine | $74,814 | $35.97 | 12 | 19 | 42 | Yes | 2 | 1 | 1 | IL | Midwest | ||
| 1257 | 03/14/17 | Machine | $74,512 | $35.82 | 3 | 14 | 24 | No | 1 | 2 | 1 | NE | C-Plains | ||
| 1745 | 10/04/12 | Machine | $74,419 | $35.78 | 7 | 14 | 38 | No | 1 | 1 | 1 | IL | Midwest | ||
| 1378 | 10/19/12 | Machine | $74,381 | $35.76 | 7 | 16 | 46 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1445 | 10/15/14 | Machine | $74,039 | $35.60 | 5 | 19 | 49 | No | 3 | 1 | 2 | IL | Midwest | ||
| 1779 | 10/11/13 | Machine | $74,000 | $35.58 | 6 | 19 | 40 | No | 3 | 2 | 2 | IL | Midwest | ||
| 1505 | 01/17/15 | Machine | $73,807 | $35.48 | 5 | 16 | 46 | No | 3 | 1 | 2 | IL | Midwest | ||
| 1498 | 09/23/15 | Machine | $73,650 | $35.41 | 4 | 19 | 42 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1156 | 05/03/13 | Machine | $73,640 | $35.40 | 7 | 16 | 45 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1609 | 09/15/14 | Machine | $73,447 | $35.31 | 5 | 14 | 27 | No | 3 | 1 | 2 | IL | Midwest | ||
| 1815 | 12/01/13 | Machine | $73,005 | $35.10 | 6 | 14 | 43 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1477 | 06/24/13 | Shipping | $72,946 | $35.07 | 7 | 14 | 24 | No | 1 | 2 | 2 | PA | Northeast | ||
| 1622 | 08/02/02 | Shipping | $72,536 | $34.87 | 17 | 14 | 39 | Yes | 1 | 2 | 1 | IL | Midwest | ||
| 1024 | 04/06/19 | Machine | $72,352 | $34.78 | 1 | 16 | 29 | No | 4 | 1 | 2 | PA | Northeast | ||
| 1568 | 05/12/12 | Shipping | $72,213 | $34.72 | 8 | 16 | 41 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1402 | 08/06/11 | Machine | $72,005 | $34.62 | 8 | 19 | 61 | No | 1 | 2 | 1 | PA | Northeast | ||
| 1529 | 06/11/13 | Machine | $71,914 | $34.57 | 7 | 16 | 51 | No | 1 | 1 | 1 | NE | C-Plains | ||
| 1167 | 07/11/03 | Machine | $71,851 | $34.54 | 16 | 14 | 25 | Yes | 4 | 1 | 2 | IL | Midwest | ||
| 1105 | 05/03/13 | Invent | $71,747 | $34.49 | 7 | 16 | 46 | No | 2 | 1 | 1 | PA | Northeast | ||
| 1136 | 09/22/13 | Machine | $71,727 | $34.48 | 6 | 19 | 50 | No | 3 | 2 | 1 | IL | Midwest | ||
| 1613 | 10/29/11 | Machine | $71,697 | $34.47 | 8 | 14 | 32 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1658 | 05/04/11 | Admin | $71,690 | $34.47 | 9 | 16 | 51 | No | 3 | 2 | 1 | PA | Northeast | ||
| 1062 | 11/06/10 | Acctg/Fin | $71,671 | $34.46 | 9 | 16 | 31 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1018 | 04/22/10 | Machine | $71,311 | $34.28 | 10 | 14 | 37 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1113 | 06/20/08 | Machine | $71,026 | $34.15 | 12 | 16 | 49 | Yes | 3 | 1 | 2 | NE | C-Plains | ||
| 1339 | 07/04/17 | Machine | $70,358 | $33.83 | 2 | 14 | 55 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1004 | 12/29/16 | Machine | $70,237 | $33.77 | 3 | 16 | 57 | No | 2 | 1 | 1 | PA | Northeast | ||
| 1671 | 12/14/13 | Machine | $69,935 | $33.62 | 6 | 16 | 22 | No | 1 | 1 | 2 | NE | C-Plains | ||
| 1048 | 08/14/03 | Shipping | $69,777 | $33.55 | 16 | 19 | 43 | Yes | 3 | 1 | 1 | NE | C-Plains | ||
| 1639 | 05/17/10 | Machine | $69,665 | $33.49 | 10 | 16 | 24 | No | 2 | 2 | 1 | PA | Northeast | ||
| 1117 | 09/05/16 | Machine | $69,656 | $33.49 | 3 | 16 | 57 | No | 1 | 1 | 1 | NE | C-Plains | ||
| 1015 | 01/07/12 | Invent | $69,529 | $33.43 | 8 | 16 | 53 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1320 | 08/03/17 | Machine | $68,762 | $33.06 | 2 | 16 | 43 | No | 4 | 2 | 1 | IL | Midwest | ||
| 1760 | 11/23/08 | Machine | $68,647 | $33.00 | 11 | 14 | 50 | Yes | 3 | 1 | 1 | NE | C-Plains | ||
| 1496 | 04/24/19 | Shipping | $68,375 | $32.87 | 1 | 16 | 40 | No | 1 | 1 | 2 | NE | C-Plains | ||
| 1150 | 02/06/14 | Machine | $68,226 | $32.80 | 6 | 16 | 54 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1233 | 02/01/14 | Machine | $68,222 | $32.80 | 6 | 19 | 29 | No | 3 | 1 | 2 | PA | Northeast | ||
| 1053 | 01/08/13 | Machine | $68,056 | $32.72 | 7 | 14 | 62 | No | 1 | 1 | 1 | NE | C-Plains | ||
| 1261 | 07/11/04 | Machine | $68,012 | $32.70 | 15 | 16 | 36 | Yes | 4 | 2 | 1 | PA | Northeast | ||
| 1824 | 06/23/16 | Machine | $67,987 | $32.69 | 4 | 16 | 34 | No | 3 | 2 | 1 | PA | Northeast | ||
| 1519 | 05/23/11 | Machine | $67,866 | $32.63 | 9 | 14 | 25 | No | 3 | 1 | 2 | PA | Northeast | ||
| 1598 | 10/10/13 | Machine | $67,624 | $32.51 | 6 | 16 | 37 | No | 3 | 2 | 1 | NE | C-Plains | ||
| 1265 | 11/08/14 | Acctg/Fin | $66,938 | $32.18 | 5 | 16 | 39 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1280 | 04/02/15 | Acctg/Fin | $66,528 | $31.98 | 5 | 16 | 35 | No | 1 | 2 | 1 | NE | C-Plains | ||
| 1296 | 09/02/14 | Gen Shop | $65,955 | $31.71 | 5 | 14 | 39 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1405 | 05/05/06 | Gen Shop | $65,126 | $31.31 | 14 | 16 | 38 | Yes | 1 | 1 | 1 | NE | C-Plains | ||
| 1744 | 01/26/18 | Gen Shop | $65,100 | $31.30 | 2 | 14 | 40 | No | 3 | 2 | 1 | PA | Northeast | ||
| 1848 | 01/19/12 | Gen Shop | $64,797 | $31.15 | 8 | 14 | 45 | No | 3 | 2 | 1 | PA | Northeast | ||
| 1341 | 01/11/17 | Gen Shop | $64,580 | $31.05 | 3 | 16 | 40 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1812 | 07/13/02 | Gen Shop | $64,458 | $30.99 | 17 | 16 | 29 | Yes | 2 | 2 | 2 | PA | Northeast | ||
| 1525 | 09/13/11 | Gen Shop | $64,201 | $30.87 | 8 | 16 | 34 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1446 | 03/30/11 | Gen Shop | $64,200 | $30.87 | 9 | 16 | 53 | No | 1 | 1 | 1 | IL | Midwest | ||
| 1687 | 07/31/11 | Gen Shop | $63,946 | $30.74 | 8 | 19 | 42 | No | 3 | 2 | 1 | PA | Northeast | ||
| 1226 | 08/25/02 | Gen Shop | $63,933 | $30.74 | 17 | 19 | 34 | Yes | 3 | 1 | 2 | IL | Midwest | ||
| 1108 | 10/24/07 | Gen Shop | $63,777 | $30.66 | 12 | 14 | 35 | Yes | 3 | 1 | 2 | PA | Northeast | ||
| 1736 | 06/12/11 | Gen Shop | $63,125 | $30.35 | 9 | 16 | 54 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1255 | 09/05/11 | Gen Shop | $62,836 | $30.21 | 8 | 16 | 42 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1556 | 12/19/13 | Gen Shop | $62,747 | $30.17 | 6 | 19 | 52 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1117 | 05/12/18 | Gen Shop | $62,319 | $29.96 | 2 | 16 | 28 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1320 | 11/20/10 | Gen Shop | $61,902 | $29.76 | 9 | 16 | 52 | No | 3 | 1 | 2 | NE | C-Plains | ||
| 1043 | 02/06/19 | Gen Shop | $61,779 | $29.70 | 1 | 16 | 34 | No | 1 | 1 | 1 | IL | Midwest | ||
| 1387 | 05/29/06 | Gen Shop | $61,383 | $29.51 | 14 | 14 | 26 | Yes | 3 | 1 | 1 | IL | Midwest | ||
| 1248 | 06/13/17 | Gen Shop | $61,212 | $29.43 | 3 | 14 | 43 | No | 1 | 1 | 1 | IL | Midwest | ||
| 1785 | 10/25/11 | Gen Shop | $61,121 | $29.39 | 8 | 16 | 44 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1329 | 05/15/11 | Gen Shop | $61,068 | $29.36 | 9 | 16 | 37 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1141 | 01/29/13 | Gen Shop | $60,802 | $29.23 | 7 | 16 | 59 | No | 3 | 1 | 1 | PA | Northeast | ||
| 1636 | 09/01/16 | Gen Shop | $60,641 | $29.15 | 3 | 16 | 34 | No | 4 | 1 | 1 | NE | C-Plains | ||
| 1448 | 02/02/14 | Admin | $59,219 | $28.47 | 6 | 14 | 35 | No | 3 | 1 | 2 | NE | C-Plains | ||
| 1145 | 12/05/17 | Gen Shop | $58,540 | $28.14 | 2 | 14 | 44 | No | 1 | 1 | 1 | IL | Midwest | ||
| 1850 | 06/17/17 | Gen Shop | $58,294 | $28.03 | 3 | 19 | 40 | No | 4 | 1 | 1 | NE | C-Plains | ||
| 1138 | 10/13/05 | Gen Shop | $57,727 | $27.75 | 14 | 16 | 51 | Yes | 3 | 1 | 1 | IL | Midwest | ||
| 1447 | 02/21/15 | Gen Shop | $55,720 | $26.79 | 5 | 16 | 34 | No | 3 | 1 | 2 | IL | Midwest | ||
| 1198 | 06/21/13 | Gen Shop | $55,542 | $26.70 | 7 | 14 | 30 | No | 2 | 2 | 1 | IL | Midwest | ||
| 1580 | 10/18/17 | Gen Shop | $54,080 | $26.00 | 2 | 19 | 44 | No | 2 | 1 | 2 | NE | C-Plains | ||
| 1442 | 01/05/16 | Admin | $54,060 | $25.99 | 4 | 16 | 32 | No | 3 | 2 | 2 | IL | Midwest | ||
| 1343 | 03/02/09 | Gen Shop | $53,669 | $25.80 | 11 | 14 | 42 | Yes | 1 | 2 | 1 | PA | Northeast | ||
| 1750 | 07/17/13 | Gen Shop | $52,064 | $25.03 | 6 | 14 | 34 | No | 3 | 1 | 1 | NE | C-Plains | ||
| 1350 | 04/10/13 | Admin | $50,421 | $24.24 | 7 | 16 | 26 | No | 3 | 2 | 2 | NE | C-Plains | ||
| 1723 | 01/25/05 | Gen Shop | $50,377 | $24.22 | 15 | 12 | 31 | Yes | 2 | 1 | 1 | PA | Northeast | ||
| 1626 | 10/21/10 | Gen Shop | $43,962 | $21.14 | 9 | 12 | 22 | No | 3 | 2 | 2 | IL | Midwest | ||
| 1560 | 02/27/12 | Gen Shop | $43,367 | $20.85 | 8 | 16 | 38 | No | 3 | 2 | 1 | PA | Northeast | ||
| 1539 | 01/24/04 | Gen Shop | $43,367 | $20.85 | 16 | 16 | 34 | Yes | 3 | 1 | 1 | IL | Midwest | ||
| 1404 | 07/27/07 | Gen Shop | $43,367 | $20.85 | 12 | 16 | 29 | Yes | 3 | 1 | 2 | NE | C-Plains | ||
| 1289 | 02/02/10 | Gen Shop | $43,367 | $20.85 | 10 | 16 | 33 | No | 3 | 1 | 1 | IL | Midwest | ||
| 1644 | 01/19/18 | Gen Shop | $39,808 | $19.14 | 2 | 16 | 46 | No | 1 | 1 | 1 | PA | Northeast | ||
| 1620 | 04/20/15 | Gen Shop | $33,367 | $16.04 | 5 | 12 | 22 | No | 1 | 1 | 1 | IL | Midwest | ||
| 1507 | 09/25/10 | Gen Shop | $32,367 | $15.56 | 9 | 12 | 25 | No | 3 | 2 | 2 | NE | C-Plains | ||
| Section 2: Complete Summary Tables for Graphing | |||||||||||||||
| Sales Summary (Provided) | |||||||||||||||
| Roles | Race | # | % | Yr | Sales | ||||||||||
| Key Emp | # | 1 | African-Am | 98 | 26 | 2003 | $1,656,872 | ||||||||
| CEO | 1 | 2 | Asian | 25 | 7 | 2004 | $47,830,245 | ||||||||
| CFO | 1 | 3 | Caucasian | 216 | 58 | 2005 | $84,088,009 | ||||||||
| Eng Mgr | 1 | 4 | Hispanic | 33 | 9 | 2006 | $130,427,572 | ||||||||
| COO | 1 | 372 | 100 | 2007 | $146,938,882 | ||||||||||
| Sales Mgr | 1 | 2008 | $139,117,818 | ||||||||||||
| IT Mgr | 1 | 2009 | $143,547,199 | ||||||||||||
| Controller | 1 | Gender | # | % | 2010 | $144,834,875 | |||||||||
| Advertg | 5 | 1 | Male | 295 | 79 | 2011 | $149,578,842 | ||||||||
| Sr Flr Mgr | 3 | 2 | Female | 77 | 21 | 2012 | $155,740,613 | ||||||||
| Engineering | 23 | 372 | 100 | 2013 | $144,759,828 | ||||||||||
| Sr Sales Mgr | 3 | 2014 | $156,714,301 | ||||||||||||
| IT Staff | 8 | 2015 | $150,201,379 | ||||||||||||
| Sales | 14 | Education Level | # | % | 2016 | $154,750,829 | |||||||||
| Shp Mgr | 1 | 12 | HS | 18 | 5 | 2017 | $158,253,462 | ||||||||
| Acctg/Fin | 10 | 14 | AA | 87 | 23 | 2018 | $156,494,223 | ||||||||
| Sr Mach | 28 | 16 | BA/BS | 203 | 55 | 2019 | $165,800,498 | ||||||||
| Quality | 5 | 19 | Masters | 64 | 17 | 2020 | |||||||||
| Mrktg | 5 | 372 | 100 | 2021 | |||||||||||
| Design | 19 | 2022 | |||||||||||||
| Invent | 8 | 2023 | |||||||||||||
| Flr Supr | 7 | Marital Status | # | % | 2024 | ||||||||||
| Purch | 5 | 1 | Married | 268 | 72 | ||||||||||
| Machine | 159 | 2 | Single | 104 | 28 | ||||||||||
| Shipping | 18 | 372 | 100 | ||||||||||||
| Admin | 4 | ||||||||||||||
| Gen Shop | 40 | ||||||||||||||
| 372 | Region Key | ||||||||||||||
| State | Region | # | % | ||||||||||||
| PA | Northeast | 149 | 40 | ||||||||||||
| IL | Midwest | 125 | 34 | ||||||||||||
| NE | C-Plains | 98 | 26 | ||||||||||||
| 372 | 100 | ||||||||||||||
| Section 3: Complete Descriptive Statistics | |||||||||||||||
| Be sure to include the correct units where applicable for the summary statistics below | |||||||||||||||
| Descriptive Statistics | Salary | Hrly Rate | Yrs of Svc | Ed | Age | Frequency Table by Salary Ranges | |||||||||
| Mean | 99,672.23 | 47.92 | 7.63 | 15.85 | 40.05 | Bin Range / Upper Limit | Label | ||||||||
| Median | 91,475.50 | 43.98 | 7.08 | 16.00 | 39.00 | 20000 | Up to 20 | Graph into histogram | |||||||
| Mode | 154,933.00 | 74.49 | 15.47 | 16.00 | 34.00 | 30000 | 21-30 | ||||||||
| Std Deviation | 32,852.73 | 15.79 | 4.34 | 1.80 | 9.94 | 40000 | 31-40 | ||||||||
| Variance | 1,079,302,174.37 | 249.47 | 18.83 | 3.25 | 98.72 | 50000 | 41-50 | ||||||||
| Kurtosis | 0.27 | 0.27 | -0.35 | -0.09 | -0.65 | 60000 | 51-60 | ||||||||
| Skewness | 0.77 | 0.77 | 0.61 | 0.19 | 0.31 | 70000 | 61-70 | ||||||||
| Max - | 239,315.00 | 115.06 | 18.46 | 19.00 | 68.00 | 80000 | 71-80 | ||||||||
| Min = | 32,367.00 | 15.56 | 0.11 | 12.00 | 21.00 | 90000 | 81-90 | ||||||||
| Range | 206,948.00 | 99.49 | 18.35 | 7.00 | 47.00 | 100000 | 91-100 | ||||||||
| Sum | 37,078,070.00 | 17,826.00 | 2839.83 | 5898.00 | 14899.00 | 110000 | 101-110 | ||||||||
| Count | 372.00 | 372.00 | 372.00 | 372.00 | 372.00 | 120000 | 111-120 | ||||||||
| 130000 | 121-130 | ||||||||||||||
| 140000 | 131-140 | ||||||||||||||
| 150000 | 141-150 | ||||||||||||||
| 160000 | 151-160 | ||||||||||||||
| 170000 | 161-170 | ||||||||||||||
| 180000 | 171-180 | ||||||||||||||
| 190000 | 181-190 | ||||||||||||||
| 200000 | 191-200 | ||||||||||||||
| 200+ |
LUIS E. CASAL &D &P
Statistical Data
| Descriptive Statistics | Salary | Hrly Rate | Yrs of Svc | Ed | Age |
| Mean | 99672.23 | 47.92 | 7.63 | 15.85 | 40.05 |
| Standard Error | 1703.33 | 0.82 | 0.22 | 0.09 | 0.52 |
| Median | 91475.50 | 43.98 | 7.08 | 16.00 | 39.00 |
| Mode | 154933.00 | 74.49 | 15.47 | 16.00 | 34.00 |
| Standard Deviation | 32852.73 | 15.79 | 4.34 | 1.80 | 9.94 |
| Sample Variance | 1079302174.37 | 249.47 | 18.83 | 3.25 | 98.72 |
| Kurtosis | 0.27 | 0.27 | -0.35 | -0.09 | -0.65 |
| Skewness | 0.77 | 0.77 | 0.61 | 0.19 | 0.31 |
| Range | 206948.00 | 99.49 | 18.35 | 7.00 | 47.00 |
| Minimum | 32367.00 | 15.56 | 0.11 | 12.00 | 21.00 |
| Maximum | 239315.00 | 115.06 | 18.46 | 19.00 | 68.00 |
| Sum | 37078070.00 | 17826.00 | 2839.83 | 5898.00 | 14899.00 |
| Count | 372.00 | 372.00 | 372.00 | 372.00 | 372.00 |
Charts
Gender
Male Female 79.3010752688172 20.698924731182796
Education Level
HS AA BA/BS Masters 4.838709677419355 23.387096774193548 54.569892473118273 17.20430107526882
Marital Status
Married Single 72.043010752688176 27.956989247311824
Number of employees by race
African-Am Asian Caucasian Hispanic 98 25 216 33
Number of employees per state
PA IL NE 149 125 98
Sales summary
2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 1656871.8930150992 47830244.546799615 84088009.193400696 130427572.07159656 146938882.11983776 139117817.9909192 143547199.3314777 144834874.89356914 149578841.81593996 155740613.19537732 144759828.34312081 156714300.52984941 150201379.20405364 154750828.73739058 158253462.20716339 156494222.6692971 165800497.95999998
Histogram
| Bin | Frequency |
| 20000 | 0 |
| 30000 | 0 |
| 40000 | 3 |
| 50000 | 5 |
| 60000 | 12 |
| 70000 | 40 |
| 80000 | 60 |
| 90000 | 58 |
| 100000 | 43 |
| 110000 | 33 |
| 120000 | 30 |
| 130000 | 16 |
| 140000 | 10 |
| 150000 | 18 |
| 160000 | 25 |
| 170000 | 10 |
| 180000 | 6 |
| 190000 | 2 |
| 200000 | 0 |
| More | 1 |
| 372 |
Histogram
Frequency 20000 30000 40000 50000 60000 70000 80000 90000 100000 110000 120000 130000 140000 150000 160000 170000 180000 190000 200000 More 0 0 3 5 12 40 60 58 43 33 30 16 10 18 25 10 6 2 0 1Bin
Frequency
Sorted Data
| Workforce Profile Analysis | |||||||||||||
| Section 1: Complete all Columns in Data Set | |||||||||||||
| Format for: |
Windows User: Format cells in column according to indicated format. |
||||||||||||
| Number | Date | Text | Currency | Currency | General | Number | Number | General | Number | Number | Number | Text | General |
| mm/dd/yy | |||||||||||||
| Year Ending | Vested Yr | ||||||||||||
| 12/31/19 | 10 | ||||||||||||
| Emp # | Hire Date | Role | Salary | Hrly Rate | Yrs of Svc | Ed | Age | Vested | Race | Gender | Status | State | Region |
| 1507 | 09/25/10 | Gen Shop | $32,367 | $15.56 | 9 | 12 | 25 | No | 3 | 2 | 2 | NE | C-Plains |
| 1404 | 07/27/07 | Gen Shop | $43,367 | $20.85 | 12 | 16 | 29 | Yes | 3 | 1 | 2 | NE | C-Plains |
| 1350 | 04/10/13 | Admin | $50,421 | $24.24 | 7 | 16 | 26 | No | 3 | 2 | 2 | NE | C-Plains |
| 1750 | 07/17/13 | Gen Shop | $52,064 | $25.03 | 6 | 14 | 34 | No | 3 | 1 | 1 | NE | C-Plains |
| 1580 | 10/18/17 | Gen Shop | $54,080 | $26.00 | 2 | 19 | 44 | No | 2 | 1 | 2 | NE | C-Plains |
| 1850 | 06/17/17 | Gen Shop | $58,294 | $28.03 | 3 | 19 | 40 | No | 4 | 1 | 1 | NE | C-Plains |
| 1448 | 02/02/14 | Admin | $59,219 | $28.47 | 6 | 14 | 35 | No | 3 | 1 | 2 | NE | C-Plains |
| 1636 | 09/01/16 | Gen Shop | $60,641 | $29.15 | 3 | 16 | 34 | No | 4 | 1 | 1 | NE | C-Plains |
| 1329 | 05/15/11 | Gen Shop | $61,068 | $29.36 | 9 | 16 | 37 | No | 3 | 1 | 1 | NE | C-Plains |
| 1785 | 10/25/11 | Gen Shop | $61,121 | $29.39 | 8 | 16 | 44 | No | 3 | 1 | 1 | NE | C-Plains |
| 1320 | 11/20/10 | Gen Shop | $61,902 | $29.76 | 9 | 16 | 52 | No | 3 | 1 | 2 | NE | C-Plains |
| 1255 | 09/05/11 | Gen Shop | $62,836 | $30.21 | 8 | 16 | 42 | No | 3 | 1 | 1 | NE | C-Plains |
| 1405 | 05/05/06 | Gen Shop | $65,126 | $31.31 | 14 | 16 | 38 | Yes | 1 | 1 | 1 | NE | C-Plains |
| 1296 | 09/02/14 | Gen Shop | $65,955 | $31.71 | 5 | 14 | 39 | No | 3 | 1 | 1 | NE | C-Plains |
| 1280 | 04/02/15 | Acctg/Fin | $66,528 | $31.98 | 5 | 16 | 35 | No | 1 | 2 | 1 | NE | C-Plains |
| 1598 | 10/10/13 | Machine | $67,624 | $32.51 | 6 | 16 | 37 | No | 3 | 2 | 1 | NE | C-Plains |
| 1053 | 01/08/13 | Machine | $68,056 | $32.72 | 7 | 14 | 62 | No | 1 | 1 | 1 | NE | C-Plains |
| 1496 | 04/24/19 | Shipping | $68,375 | $32.87 | 1 | 16 | 40 | No | 1 | 1 | 2 | NE | C-Plains |
| 1760 | 11/23/08 | Machine | $68,647 | $33.00 | 11 | 14 | 50 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1117 | 09/05/16 | Machine | $69,656 | $33.49 | 3 | 16 | 57 | No | 1 | 1 | 1 | NE | C-Plains |
| 1048 | 08/14/03 | Shipping | $69,777 | $33.55 | 16 | 19 | 43 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1671 | 12/14/13 | Machine | $69,935 | $33.62 | 6 | 16 | 22 | No | 1 | 1 | 2 | NE | C-Plains |
| 1113 | 06/20/08 | Machine | $71,026 | $34.15 | 12 | 16 | 49 | Yes | 3 | 1 | 2 | NE | C-Plains |
| 1018 | 04/22/10 | Machine | $71,311 | $34.28 | 10 | 14 | 37 | No | 3 | 1 | 1 | NE | C-Plains |
| 1529 | 06/11/13 | Machine | $71,914 | $34.57 | 7 | 16 | 51 | No | 1 | 1 | 1 | NE | C-Plains |
| 1378 | 10/19/12 | Machine | $74,381 | $35.76 | 7 | 16 | 46 | No | 3 | 1 | 1 | NE | C-Plains |
| 1257 | 03/14/17 | Machine | $74,512 | $35.82 | 3 | 14 | 24 | No | 1 | 2 | 1 | NE | C-Plains |
| 1424 | 08/09/12 | Machine | $75,144 | $36.13 | 7 | 16 | 28 | No | 1 | 2 | 2 | NE | C-Plains |
| 1196 | 03/08/15 | Machine | $75,415 | $36.26 | 5 | 12 | 48 | No | 3 | 1 | 1 | NE | C-Plains |
| 1629 | 08/24/15 | Shipping | $76,031 | $36.55 | 4 | 19 | 42 | No | 3 | 1 | 1 | NE | C-Plains |
| 1668 | 02/13/14 | Machine | $76,158 | $36.61 | 6 | 16 | 38 | No | 4 | 1 | 1 | NE | C-Plains |
| 1471 | 08/21/13 | Machine | $76,702 | $36.88 | 6 | 14 | 48 | No | 3 | 2 | 1 | NE | C-Plains |
| 1332 | 10/07/14 | Shipping | $76,864 | $36.95 | 5 | 19 | 53 | No | 3 | 1 | 1 | NE | C-Plains |
| 1300 | 10/08/10 | Machine | $76,956 | $37.00 | 9 | 16 | 26 | No | 3 | 1 | 2 | NE | C-Plains |
| 1800 | 01/31/15 | Machine | $77,443 | $37.23 | 5 | 16 | 33 | No | 3 | 1 | 1 | NE | C-Plains |
| 1736 | 08/16/13 | Machine | $79,542 | $38.24 | 6 | 16 | 50 | No | 3 | 1 | 1 | NE | C-Plains |
| 1169 | 10/13/07 | Machine | $81,042 | $38.96 | 12 | 16 | 30 | Yes | 3 | 1 | 2 | NE | C-Plains |
| 1789 | 06/13/11 | Machine | $81,779 | $39.32 | 9 | 16 | 51 | No | 3 | 1 | 1 | NE | C-Plains |
| 1201 | 03/17/16 | Machine | $82,319 | $39.58 | 4 | 19 | 40 | No | 3 | 1 | 1 | NE | C-Plains |
| 1364 | 11/29/09 | Machine | $83,075 | $39.94 | 10 | 16 | 38 | Yes | 3 | 1 | 2 | NE | C-Plains |
| 1744 | 6/24/08 | Machine | $83,911 | $40.34 | 12 | 16 | 48 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1565 | 04/11/04 | Machine | $87,092 | $41.87 | 16 | 16 | 30 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1829 | 05/29/18 | Machine | $87,407 | $42.02 | 2 | 14 | 51 | No | 1 | 1 | 1 | NE | C-Plains |
| 1315 | 06/13/09 | Machine | $87,480 | $42.06 | 11 | 16 | 26 | Yes | 1 | 1 | 1 | NE | C-Plains |
| 1210 | 03/28/14 | Machine | $88,639 | $42.61 | 6 | 16 | 34 | No | 3 | 1 | 2 | NE | C-Plains |
| 1096 | 03/16/11 | Machine | $89,197 | $42.88 | 9 | 14 | 21 | No | 3 | 1 | 2 | NE | C-Plains |
| 1709 | 12/12/12 | Machine | $89,522 | $43.04 | 7 | 19 | 68 | No | 3 | 1 | 1 | NE | C-Plains |
| 1097 | 09/26/13 | Machine | $90,153 | $43.34 | 6 | 14 | 40 | No | 4 | 1 | 1 | NE | C-Plains |
| 1793 | 05/17/15 | Shipping | $90,794 | $43.65 | 5 | 16 | 39 | No | 3 | 1 | 1 | NE | C-Plains |
| 1680 | 06/02/07 | Design | $91,205 | $43.85 | 13 | 14 | 37 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1364 | 11/28/18 | Machine | $91,748 | $44.11 | 1 | 16 | 36 | No | 3 | 1 | 2 | NE | C-Plains |
| 1771 | 08/13/17 | Machine | $92,079 | $44.27 | 2 | 19 | 40 | No | 3 | 1 | 1 | NE | C-Plains |
| 1180 | 07/21/14 | Machine | $93,936 | $45.16 | 5 | 19 | 47 | No | 3 | 1 | 2 | NE | C-Plains |
| 1422 | 02/02/04 | Sales | $94,038 | $45.21 | 16 | 16 | 30 | Yes | 1 | 1 | 2 | NE | C-Plains |
| 1579 | 11/18/09 | Machine | $94,700 | $45.53 | 10 | 14 | 35 | Yes | 1 | 1 | 2 | NE | C-Plains |
| 1846 | 02/12/15 | Machine | $95,985 | $46.15 | 5 | 14 | 43 | No | 1 | 1 | 1 | NE | C-Plains |
| 1557 | 07/11/04 | Machine | $96,327 | $46.31 | 15 | 16 | 40 | Yes | 4 | 1 | 1 | NE | C-Plains |
| 1813 | 06/20/15 | Machine | $96,582 | $46.43 | 5 | 19 | 40 | No | 1 | 1 | 1 | NE | C-Plains |
| 1175 | 12/07/18 | Machine | $98,634 | $47.42 | 1 | 16 | 52 | No | 3 | 1 | 1 | NE | C-Plains |
| 1492 | 8/20/15 | Machine | $100,314 | $48.23 | 4 | 16 | 51 | No | 3 | 1 | 1 | NE | C-Plains |
| 1468 | 9/25/08 | Machine | $100,571 | $48.35 | 11 | 16 | 42 | Yes | 2 | 2 | 1 | NE | C-Plains |
| 1055 | 12/16/09 | Machine | $100,632 | $48.38 | 10 | 16 | 47 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1764 | 8/31/05 | Machine | $101,709 | $48.90 | 14 | 16 | 24 | Yes | 4 | 1 | 1 | NE | C-Plains |
| 1036 | 06/10/11 | Machine | $102,641 | $49.35 | 9 | 14 | 29 | No | 1 | 1 | 1 | NE | C-Plains |
| 1308 | 7/17/02 | Machine | $103,721 | $49.87 | 17 | 14 | 46 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1830 | 7/4/13 | Machine | $104,793 | $50.38 | 6 | 14 | 25 | No | 3 | 2 | 1 | NE | C-Plains |
| 1584 | 06/21/10 | Machine | $107,153 | $51.52 | 10 | 16 | 51 | No | 3 | 2 | 1 | NE | C-Plains |
| 1846 | 05/03/12 | Engineering | $107,530 | $51.70 | 8 | 14 | 42 | No | 3 | 2 | 2 | NE | C-Plains |
| 1554 | 07/27/16 | Engineering | $111,196 | $53.46 | 3 | 16 | 36 | No | 4 | 1 | 1 | NE | C-Plains |
| 1517 | 06/01/06 | Engineering | $111,424 | $53.57 | 14 | 16 | 35 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1519 | 01/19/18 | Design | $111,536 | $53.62 | 2 | 16 | 51 | No | 1 | 1 | 1 | NE | C-Plains |
| 1477 | 03/08/17 | Purch | $111,794 | $53.75 | 3 | 19 | 45 | No | 1 | 1 | 2 | NE | C-Plains |
| 1733 | 09/19/15 | Flr Supr | $116,208 | $55.87 | 4 | 16 | 32 | No | 1 | 1 | 1 | NE | C-Plains |
| 1320 | 11/23/19 | Sr Mach | $119,285 | $57.35 | 0 | 16 | 28 | No | 3 | 1 | 2 | NE | C-Plains |
| 1297 | 12/14/13 | Sr Mach | $128,384 | $61.72 | 6 | 16 | 28 | No | 1 | 2 | 2 | NE | C-Plains |
| 1797 | 06/05/17 | Sr Mach | $128,901 | $61.97 | 3 | 14 | 26 | No | 3 | 1 | 2 | NE | C-Plains |
| 1189 | 03/09/18 | Sales | $132,142 | $63.53 | 2 | 14 | 53 | No | 3 | 1 | 1 | NE | C-Plains |
| 1608 | 08/26/05 | Sales | $139,515 | $67.07 | 14 | 16 | 52 | Yes | 1 | 2 | 1 | NE | C-Plains |
| 1128 | 07/16/01 | Flr Supr | $140,865 | $67.72 | 18 | 19 | 49 | Yes | 1 | 1 | 2 | NE | C-Plains |
| 1133 | 09/11/14 | Sales | $140,865 | $67.72 | 5 | 14 | 30 | No | 3 | 1 | 2 | NE | C-Plains |
| 1269 | 12/04/17 | Design | $143,063 | $68.78 | 2 | 16 | 31 | No | 1 | 1 | 2 | NE | C-Plains |
| 1846 | 05/16/03 | Design | $148,111 | $71.21 | 17 | 16 | 39 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1300 | 08/04/14 | Engineering | $148,111 | $71.21 | 5 | 16 | 36 | No | 2 | 1 | 1 | NE | C-Plains |
| 1379 | 08/13/17 | Mrktg | $150,263 | $72.24 | 2 | 12 | 53 | No | 2 | 1 | 1 | NE | C-Plains |
| 1803 | 05/07/17 | Mrktg | $150,868 | $72.53 | 3 | 16 | 53 | No | 2 | 1 | 1 | NE | C-Plains |
| 1822 | 02/26/07 | Engineering | $151,174 | $72.68 | 13 | 16 | 38 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1188 | 11/15/15 | Engineering | $151,523 | $72.85 | 4 | 16 | 41 | No | 1 | 1 | 1 | NE | C-Plains |
| 1220 | 10/16/16 | Sr Mach | $152,030 | $73.09 | 3 | 16 | 25 | No | 3 | 2 | 1 | NE | C-Plains |
| 1088 | 09/18/07 | Sr Flr Mgr | $152,446 | $73.29 | 12 | 16 | 54 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1257 | 07/15/03 | Engineering | $154,933 | $74.49 | 16 | 16 | 31 | Yes | 1 | 1 | 1 | NE | C-Plains |
| 1071 | 02/01/12 | Engineering | $156,750 | $75.36 | 8 | 16 | 61 | No | 1 | 1 | 2 | NE | C-Plains |
| 1215 | 06/17/18 | Engineering | $156,750 | $75.36 | 2 | 16 | 51 | No | 3 | 1 | 2 | NE | C-Plains |
| 1014 | 09/13/13 | IT Staff | $162,030 | $77.90 | 6 | 14 | 38 | No | 2 | 1 | 2 | NE | C-Plains |
| 1506 | 10/20/13 | IT Staff | $162,731 | $78.24 | 6 | 16 | 54 | No | 3 | 1 | 1 | NE | C-Plains |
| 1357 | 05/09/11 | Advertg | $172,291 | $82.83 | 9 | 16 | 52 | No | 3 | 1 | 1 | NE | C-Plains |
| 1272 | 10/02/11 | IT Mgr | $175,916 | $84.58 | 8 | 14 | 44 | No | 3 | 1 | 1 | NE | C-Plains |
| 1796 | 12/29/11 | Sales Mgr | $178,456 | $85.80 | 8 | 16 | 34 | No | 3 | 1 | 1 | NE | C-Plains |
| 1357 | 01/26/10 | COO | $179,195 | $86.15 | 10 | 19 | 50 | No | 3 | 1 | 1 | NE | C-Plains |
| C-Plains Count | 98 | ||||||||||||
| 1620 | 04/20/15 | Gen Shop | $33,367 | $16.04 | 5 | 12 | 22 | No | 1 | 1 | 1 | IL | Midwest |
| 1539 | 01/24/04 | Gen Shop | $43,367 | $20.85 | 16 | 16 | 34 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1289 | 02/02/10 | Gen Shop | $43,367 | $20.85 | 10 | 16 | 33 | No | 3 | 1 | 1 | IL | Midwest |
| 1626 | 10/21/10 | Gen Shop | $43,962 | $21.14 | 9 | 12 | 22 | No | 3 | 2 | 2 | IL | Midwest |
| 1442 | 01/05/16 | Admin | $54,060 | $25.99 | 4 | 16 | 32 | No | 3 | 2 | 2 | IL | Midwest |
| 1198 | 06/21/13 | Gen Shop | $55,542 | $26.70 | 7 | 14 | 30 | No | 2 | 2 | 1 | IL | Midwest |
| 1447 | 02/21/15 | Gen Shop | $55,720 | $26.79 | 5 | 16 | 34 | No | 3 | 1 | 2 | IL | Midwest |
| 1138 | 10/13/05 | Gen Shop | $57,727 | $27.75 | 14 | 16 | 51 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1145 | 12/05/17 | Gen Shop | $58,540 | $28.14 | 2 | 14 | 44 | No | 1 | 1 | 1 | IL | Midwest |
| 1248 | 06/13/17 | Gen Shop | $61,212 | $29.43 | 3 | 14 | 43 | No | 1 | 1 | 1 | IL | Midwest |
| 1387 | 05/29/06 | Gen Shop | $61,383 | $29.51 | 14 | 14 | 26 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1043 | 02/06/19 | Gen Shop | $61,779 | $29.70 | 1 | 16 | 34 | No | 1 | 1 | 1 | IL | Midwest |
| 1556 | 12/19/13 | Gen Shop | $62,747 | $30.17 | 6 | 19 | 52 | No | 3 | 1 | 1 | IL | Midwest |
| 1226 | 08/25/02 | Gen Shop | $63,933 | $30.74 | 17 | 19 | 34 | Yes | 3 | 1 | 2 | IL | Midwest |
| 1446 | 03/30/11 | Gen Shop | $64,200 | $30.87 | 9 | 16 | 53 | No | 1 | 1 | 1 | IL | Midwest |
| 1525 | 09/13/11 | Gen Shop | $64,201 | $30.87 | 8 | 16 | 34 | No | 3 | 1 | 1 | IL | Midwest |
| 1265 | 11/08/14 | Acctg/Fin | $66,938 | $32.18 | 5 | 16 | 39 | No | 3 | 1 | 1 | IL | Midwest |
| 1320 | 08/03/17 | Machine | $68,762 | $33.06 | 2 | 16 | 43 | No | 4 | 2 | 1 | IL | Midwest |
| 1136 | 09/22/13 | Machine | $71,727 | $34.48 | 6 | 19 | 50 | No | 3 | 2 | 1 | IL | Midwest |
| 1167 | 07/11/03 | Machine | $71,851 | $34.54 | 16 | 14 | 25 | Yes | 4 | 1 | 2 | IL | Midwest |
| 1622 | 08/02/02 | Shipping | $72,536 | $34.87 | 17 | 14 | 39 | Yes | 1 | 2 | 1 | IL | Midwest |
| 1609 | 09/15/14 | Machine | $73,447 | $35.31 | 5 | 14 | 27 | No | 3 | 1 | 2 | IL | Midwest |
| 1498 | 09/23/15 | Machine | $73,650 | $35.41 | 4 | 19 | 42 | No | 3 | 1 | 1 | IL | Midwest |
| 1505 | 01/17/15 | Machine | $73,807 | $35.48 | 5 | 16 | 46 | No | 3 | 1 | 2 | IL | Midwest |
| 1779 | 10/11/13 | Machine | $74,000 | $35.58 | 6 | 19 | 40 | No | 3 | 2 | 2 | IL | Midwest |
| 1445 | 10/15/14 | Machine | $74,039 | $35.60 | 5 | 19 | 49 | No | 3 | 1 | 2 | IL | Midwest |
| 1745 | 10/04/12 | Machine | $74,419 | $35.78 | 7 | 14 | 38 | No | 1 | 1 | 1 | IL | Midwest |
| 1075 | 04/21/08 | Machine | $74,814 | $35.97 | 12 | 19 | 42 | Yes | 2 | 1 | 1 | IL | Midwest |
| 1660 | 11/01/16 | Machine | $75,053 | $36.08 | 3 | 14 | 25 | No | 3 | 1 | 2 | IL | Midwest |
| 1819 | 08/31/04 | Machine | $75,261 | $36.18 | 15 | 12 | 43 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1750 | 12/19/09 | Machine | $75,969 | $36.52 | 10 | 14 | 37 | Yes | 3 | 1 | 2 | IL | Midwest |
| 1142 | 08/26/17 | Machine | $77,247 | $37.14 | 2 | 14 | 48 | No | 4 | 2 | 1 | IL | Midwest |
| 1422 | 11/16/15 | Machine | $77,495 | $37.26 | 4 | 16 | 45 | No | 3 | 2 | 2 | IL | Midwest |
| 1504 | 01/13/15 | Shipping | $78,985 | $37.97 | 5 | 16 | 33 | No | 3 | 1 | 2 | IL | Midwest |
| 1373 | 05/21/13 | Machine | $79,063 | $38.01 | 7 | 14 | 40 | No | 3 | 2 | 1 | IL | Midwest |
| 1741 | 08/29/15 | Machine | $79,584 | $38.26 | 4 | 14 | 55 | No | 3 | 1 | 1 | IL | Midwest |
| 1061 | 07/07/17 | Machine | $80,198 | $38.56 | 2 | 16 | 37 | No | 1 | 1 | 1 | IL | Midwest |
| 1450 | 07/07/04 | Machine | $80,909 | $38.90 | 15 | 16 | 40 | Yes | 1 | 1 | 1 | IL | Midwest |
| 1785 | 12/01/18 | Shipping | $81,276 | $39.08 | 1 | 14 | 44 | No | 3 | 1 | 1 | IL | Midwest |
| 1016 | 09/30/12 | Machine | $81,730 | $39.29 | 7 | 16 | 27 | No | 3 | 2 | 1 | IL | Midwest |
| 1018 | 09/20/06 | Acctg/Fin | $82,016 | $39.43 | 13 | 16 | 44 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1591 | 7/17/02 | Machine | $82,411 | $39.62 | 17 | 16 | 37 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1343 | 10/06/09 | Machine | $83,424 | $40.11 | 10 | 16 | 44 | Yes | 3 | 2 | 1 | IL | Midwest |
| 1723 | 7/16/01 | Machine | $84,076 | $40.42 | 18 | 19 | 36 | Yes | 3 | 2 | 1 | IL | Midwest |
| 1611 | 11/23/12 | Machine | $85,442 | $41.08 | 7 | 19 | 38 | No | 1 | 2 | 1 | IL | Midwest |
| 1059 | 03/16/16 | Acctg/Fin | $86,147 | $41.42 | 4 | 16 | 39 | No | 2 | 1 | 1 | IL | Midwest |
| 1638 | 01/31/11 | Machine | $86,199 | $41.44 | 9 | 16 | 27 | No | 4 | 2 | 2 | IL | Midwest |
| 1237 | 01/22/18 | Machine | $86,377 | $41.53 | 2 | 14 | 40 | No | 1 | 1 | 2 | IL | Midwest |
| 1456 | 08/15/18 | Machine | $86,384 | $41.53 | 1 | 16 | 26 | No | 3 | 1 | 2 | IL | Midwest |
| 1593 | 06/14/06 | Shipping | $86,787 | $41.72 | 14 | 16 | 34 | Yes | 1 | 2 | 1 | IL | Midwest |
| 1019 | 05/01/17 | Machine | $87,054 | $41.85 | 3 | 14 | 34 | No | 2 | 1 | 1 | IL | Midwest |
| 1476 | 12/10/15 | Purch | $87,056 | $41.85 | 4 | 16 | 41 | No | 3 | 1 | 1 | IL | Midwest |
| 1109 | 07/27/08 | Machine | $87,409 | $42.02 | 11 | 14 | 58 | Yes | s | 1 | 1 | IL | Midwest |
| 1434 | 02/19/12 | Machine | $87,517 | $42.08 | 8 | 14 | 57 | No | 3 | 1 | 1 | IL | Midwest |
| 1452 | 08/11/16 | Machine | $87,519 | $42.08 | 3 | 16 | 37 | No | 3 | 2 | 1 | IL | Midwest |
| 1659 | 12/05/13 | Machine | $87,583 | $42.11 | 6 | 14 | 39 | No | 2 | 1 | 2 | IL | Midwest |
| 1289 | 12/04/11 | Machine | $87,601 | $42.12 | 8 | 16 | 30 | No | 4 | 1 | 1 | IL | Midwest |
| 1554 | 10/28/12 | Machine | $87,641 | $42.14 | 7 | 14 | 33 | No | 4 | 1 | 2 | IL | Midwest |
| 1006 | 07/20/01 | Machine | $88,743 | $42.66 | 18 | 14 | 27 | Yes | 3 | 1 | 2 | IL | Midwest |
| 1836 | 04/18/18 | Machine | $88,743 | $42.66 | 2 | 19 | 33 | No | 2 | 2 | 2 | IL | Midwest |
| 1186 | 02/15/11 | Machine | $90,599 | $43.56 | 9 | 16 | 50 | No | 1 | 1 | 1 | IL | Midwest |
| 1779 | 08/11/14 | Machine | $91,131 | $43.81 | 5 | 19 | 30 | No | 3 | 1 | 1 | IL | Midwest |
| 1667 | 12/15/06 | Machine | $92,076 | $44.27 | 13 | 14 | 47 | Yes | 2 | 1 | 1 | IL | Midwest |
| 1504 | 10/17/08 | Machine | $92,267 | $44.36 | 11 | 19 | 35 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1323 | 01/12/06 | Machine | $92,847 | $44.64 | 14 | 16 | 31 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1661 | 11/10/11 | Sales | $92,931 | $44.68 | 8 | 16 | 51 | No | 3 | 1 | 1 | IL | Midwest |
| 1296 | 06/17/17 | Invent | $95,128 | $45.73 | 3 | 19 | 42 | No | 3 | 2 | 1 | IL | Midwest |
| 1558 | 01/28/10 | Machine | $95,220 | $45.78 | 10 | 19 | 31 | No | 2 | 1 | 1 | IL | Midwest |
| 1145 | 06/20/15 | Machine | $95,957 | $46.13 | 5 | 16 | 41 | No | 3 | 2 | 1 | IL | Midwest |
| 1296 | 12/17/06 | Quality | $96,062 | $46.18 | 13 | 16 | 31 | Yes | 4 | 2 | 1 | IL | Midwest |
| 1550 | 08/25/03 | IT Staff | $98,771 | $47.49 | 16 | 19 | 59 | Yes | 1 | 1 | 1 | IL | Midwest |
| 1424 | 12/10/12 | Sales | $99,130 | $47.66 | 7 | 14 | 50 | No | 3 | 1 | 1 | IL | Midwest |
| 1588 | 1/4/18 | Machine | $99,135 | $47.66 | 2 | 14 | 35 | No | 3 | 1 | 1 | IL | Midwest |
| 1106 | 9/2/15 | Machine | $99,821 | $47.99 | 4 | 12 | 36 | No | 3 | 2 | 2 | IL | Midwest |
| 1757 | 10/16/14 | Machine | $100,198 | $48.17 | 5 | 16 | 34 | No | 1 | 2 | 1 | IL | Midwest |
| 1101 | 07/19/08 | Invent | $100,520 | $48.33 | 11 | 19 | 44 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1809 | 7/1/17 | Machine | $101,360 | $48.73 | 3 | 16 | 40 | No | 3 | 1 | 1 | IL | Midwest |
| 1850 | 11/26/06 | Invent | $102,913 | $49.48 | 13 | 16 | 25 | Yes | 1 | 2 | 2 | IL | Midwest |
| 1552 | 7/13/11 | Machine | $105,069 | $50.51 | 8 | 16 | 21 | No | 1 | 1 | 2 | IL | Midwest |
| 1776 | 10/14/15 | Machine | $106,640 | $51.27 | 4 | 14 | 40 | No | 4 | 2 | 1 | IL | Midwest |
| 1625 | 06/04/11 | Purch | $108,058 | $51.95 | 9 | 16 | 37 | No | 4 | 1 | 2 | IL | Midwest |
| 1773 | 10/07/17 | Purch | $108,342 | $52.09 | 2 | 16 | 34 | No | 3 | 2 | 1 | IL | Midwest |
| 1669 | 12/13/15 | Design | $109,128 | $52.47 | 4 | 16 | 48 | No | 3 | 1 | 1 | IL | Midwest |
| 1098 | 01/21/11 | Engineering | $110,708 | $53.23 | 9 | 16 | 55 | No | 3 | 1 | 1 | IL | Midwest |
| 1447 | 11/07/13 | Sales | $111,801 | $53.75 | 6 | 16 | 60 | No | 3 | 1 | 1 | IL | Midwest |
| 1623 | 07/10/18 | Engineering | $112,223 | $53.95 | 1 | 16 | 44 | No | 3 | 1 | 1 | IL | Midwest |
| 1466 | 06/01/11 | Sales | $112,402 | $54.04 | 9 | 14 | 41 | No | 2 | 1 | 1 | IL | Midwest |
| 1637 | 12/09/07 | Sales | $113,023 | $54.34 | 12 | 16 | 28 | Yes | 3 | 1 | 2 | IL | Midwest |
| 1227 | 09/06/10 | Invent | $115,283 | $55.42 | 9 | 14 | 37 | No | 1 | 1 | 1 | IL | Midwest |
| 1498 | 12/08/14 | Sr Mach | $115,580 | $55.57 | 5 | 16 | 54 | No | 1 | 1 | 1 | IL | Midwest |
| 1835 | 06/24/13 | Sr Mach | $116,075 | $55.81 | 7 | 19 | 37 | No | 1 | 1 | 2 | IL | Midwest |
| 1515 | 07/11/03 | Acctg/Fin | $117,692 | $56.58 | 16 | 14 | 43 | Yes | 1 | 1 | 2 | IL | Midwest |
| 1346 | 06/24/18 | Sr Mach | $120,986 | $58.17 | 2 | 19 | 29 | No | 4 | 1 | 1 | IL | Midwest |
| 1568 | 04/09/13 | Sr Mach | $122,352 | $58.82 | 7 | 16 | 28 | No | 3 | 2 | 2 | IL | Midwest |
| 1261 | 08/01/04 | Sr Mach | $122,391 | $58.84 | 15 | 16 | 48 | Yes | 4 | 1 | 2 | IL | Midwest |
| 1550 | 07/10/11 | Sr Mach | $123,391 | $59.32 | 8 | 12 | 59 | No | 3 | 1 | 1 | IL | Midwest |
| 1317 | 05/09/13 | Sr Mach | $125,156 | $60.17 | 7 | 19 | 31 | No | 1 | 1 | 1 | IL | Midwest |
| 1315 | 04/04/19 | Sr Mach | $125,367 | $60.27 | 1 | 16 | 35 | No | 3 | 1 | 2 | IL | Midwest |
| 1541 | 06/22/14 | Sr Mach | $127,190 | $61.15 | 6 | 16 | 34 | No | 3 | 1 | 1 | IL | Midwest |
| 1288 | 10/29/14 | Sales | $132,230 | $63.57 | 5 | 19 | 31 | No | 1 | 1 | 1 | IL | Midwest |
| 1224 | 07/15/03 | Engineering | $133,138 | $64.01 | 16 | 16 | 33 | Yes | 3 | 2 | 1 | IL | Midwest |
| 1381 | 11/29/11 | Sales | $135,533 | $65.16 | 8 | 14 | 28 | No | 3 | 1 | 1 | IL | Midwest |
| 1062 | 03/14/14 | Flr Supr | $139,377 | $67.01 | 6 | 16 | 27 | No | 3 | 1 | 2 | IL | Midwest |
| 1308 | 07/19/12 | Engineering | $141,110 | $67.84 | 7 | 16 | 36 | No | 3 | 1 | 1 | IL | Midwest |
| 1608 | 09/06/17 | Flr Supr | $141,110 | $67.84 | 2 | 16 | 37 | No | 1 | 2 | 1 | IL | Midwest |
| 1424 | 09/30/17 | Flr Supr | $143,005 | $68.75 | 2 | 14 | 25 | No | 4 | 2 | 2 | IL | Midwest |
| 1654 | 01/14/09 | Engineering | $144,571 | $69.51 | 11 | 16 | 39 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1841 | 06/30/17 | Design | $145,776 | $70.08 | 3 | 19 | 30 | No | 3 | 2 | 2 | IL | Midwest |
| 1069 | 05/29/12 | Engineering | $145,776 | $70.08 | 8 | 16 | 59 | No | 3 | 1 | 1 | IL | Midwest |
| 1726 | 08/31/16 | Design | $149,466 | $71.86 | 3 | 16 | 31 | No | 4 | 1 | 1 | IL | Midwest |
| 1444 | 11/05/13 | Mrktg | $150,263 | $72.24 | 6 | 16 | 57 | No | 3 | 1 | 1 | IL | Midwest |
| 1749 | 07/07/08 | Sr Mach | $151,523 | $72.85 | 11 | 16 | 56 | Yes | 1 | 1 | 1 | IL | Midwest |
| 1356 | 07/02/15 | Sr Sales Mgr | $152,446 | $73.29 | 4 | 14 | 36 | No | 4 | 1 | 2 | IL | Midwest |
| 1202 | 10/02/16 | Acctg/Fin | $154,122 | $74.10 | 3 | 19 | 33 | No | 1 | 1 | 2 | IL | Midwest |
| 1265 | 01/18/16 | Engineering | $154,933 | $74.49 | 4 | 16 | 24 | No | 3 | 1 | 1 | IL | Midwest |
| 1084 | 10/29/12 | Sales | $154,933 | $74.49 | 7 | 19 | 43 | No | 3 | 1 | 2 | IL | Midwest |
| 1785 | 06/07/16 | Engineering | $158,066 | $75.99 | 4 | 16 | 28 | No | 4 | 1 | 1 | IL | Midwest |
| 1770 | 12/03/15 | Engineering | $159,215 | $76.55 | 4 | 19 | 40 | No | 1 | 1 | 1 | IL | Midwest |
| 1071 | 05/30/13 | Engineering | $161,867 | $77.82 | 7 | 16 | 26 | No | 3 | 1 | 2 | IL | Midwest |
| 1814 | 04/14/12 | Sr Sales Mgr | $162,030 | $77.90 | 8 | 12 | 31 | No | 4 | 1 | 2 | IL | Midwest |
| 1308 | 07/10/11 | IT Staff | $162,731 | $78.24 | 8 | 16 | 53 | No | 1 | 1 | 2 | IL | Midwest |
| 1793 | 08/19/06 | Sr Sales Mgr | $163,045 | $78.39 | 13 | 16 | 33 | Yes | 1 | 1 | 1 | IL | Midwest |
| 1756 | 12/12/14 | Sr Flr Mgr | $164,033 | $78.86 | 5 | 14 | 30 | No | 3 | 1 | 1 | IL | Midwest |
| 1055 | 01/01/12 | Controller | $172,291 | $82.83 | 8 | 16 | 57 | No | 1 | 1 | 1 | IL | Midwest |
| 1596 | 07/13/02 | CFO | $186,925 | $89.87 | 17 | 16 | 39 | Yes | 1 | 1 | 1 | IL | Midwest |
| Midwest Count | 125 | ||||||||||||
| 1644 | 01/19/18 | Gen Shop | $39,808 | $19.14 | 2 | 16 | 46 | No | 1 | 1 | 1 | PA | Northeast |
| 1560 | 02/27/12 | Gen Shop | $43,367 | $20.85 | 8 | 16 | 38 | No | 3 | 2 | 1 | PA | Northeast |
| 1723 | 01/25/05 | Gen Shop | $50,377 | $24.22 | 15 | 12 | 31 | Yes | 2 | 1 | 1 | PA | Northeast |
| 1343 | 03/02/09 | Gen Shop | $53,669 | $25.80 | 11 | 14 | 42 | Yes | 1 | 2 | 1 | PA | Northeast |
| 1141 | 01/29/13 | Gen Shop | $60,802 | $29.23 | 7 | 16 | 59 | No | 3 | 1 | 1 | PA | Northeast |
| 1117 | 05/12/18 | Gen Shop | $62,319 | $29.96 | 2 | 16 | 28 | No | 3 | 1 | 1 | PA | Northeast |
| 1736 | 06/12/11 | Gen Shop | $63,125 | $30.35 | 9 | 16 | 54 | No | 3 | 1 | 1 | PA | Northeast |
| 1108 | 10/24/07 | Gen Shop | $63,777 | $30.66 | 12 | 14 | 35 | Yes | 3 | 1 | 2 | PA | Northeast |
| 1687 | 07/31/11 | Gen Shop | $63,946 | $30.74 | 8 | 19 | 42 | No | 3 | 2 | 1 | PA | Northeast |
| 1812 | 07/13/02 | Gen Shop | $64,458 | $30.99 | 17 | 16 | 29 | Yes | 2 | 2 | 2 | PA | Northeast |
| 1341 | 01/11/17 | Gen Shop | $64,580 | $31.05 | 3 | 16 | 40 | No | 1 | 1 | 1 | PA | Northeast |
| 1848 | 01/19/12 | Gen Shop | $64,797 | $31.15 | 8 | 14 | 45 | No | 3 | 2 | 1 | PA | Northeast |
| 1744 | 01/26/18 | Gen Shop | $65,100 | $31.30 | 2 | 14 | 40 | No | 3 | 2 | 1 | PA | Northeast |
| 1519 | 05/23/11 | Machine | $67,866 | $32.63 | 9 | 14 | 25 | No | 3 | 1 | 2 | PA | Northeast |
| 1824 | 06/23/16 | Machine | $67,987 | $32.69 | 4 | 16 | 34 | No | 3 | 2 | 1 | PA | Northeast |
| 1261 | 07/11/04 | Machine | $68,012 | $32.70 | 15 | 16 | 36 | Yes | 4 | 2 | 1 | PA | Northeast |
| 1233 | 02/01/14 | Machine | $68,222 | $32.80 | 6 | 19 | 29 | No | 3 | 1 | 2 | PA | Northeast |
| 1150 | 02/06/14 | Machine | $68,226 | $32.80 | 6 | 16 | 54 | No | 3 | 1 | 1 | PA | Northeast |
| 1015 | 01/07/12 | Invent | $69,529 | $33.43 | 8 | 16 | 53 | No | 3 | 1 | 1 | PA | Northeast |
| 1639 | 05/17/10 | Machine | $69,665 | $33.49 | 10 | 16 | 24 | No | 2 | 2 | 1 | PA | Northeast |
| 1004 | 12/29/16 | Machine | $70,237 | $33.77 | 3 | 16 | 57 | No | 2 | 1 | 1 | PA | Northeast |
| 1339 | 07/04/17 | Machine | $70,358 | $33.83 | 2 | 14 | 55 | No | 3 | 1 | 1 | PA | Northeast |
| 1062 | 11/06/10 | Acctg/Fin | $71,671 | $34.46 | 9 | 16 | 31 | No | 1 | 1 | 1 | PA | Northeast |
| 1658 | 05/04/11 | Admin | $71,690 | $34.47 | 9 | 16 | 51 | No | 3 | 2 | 1 | PA | Northeast |
| 1613 | 10/29/11 | Machine | $71,697 | $34.47 | 8 | 14 | 32 | No | 3 | 1 | 1 | PA | Northeast |
| 1105 | 05/03/13 | Invent | $71,747 | $34.49 | 7 | 16 | 46 | No | 2 | 1 | 1 | PA | Northeast |
| 1402 | 08/06/11 | Machine | $72,005 | $34.62 | 8 | 19 | 61 | No | 1 | 2 | 1 | PA | Northeast |
| 1568 | 05/12/12 | Shipping | $72,213 | $34.72 | 8 | 16 | 41 | No | 3 | 1 | 1 | PA | Northeast |
| 1024 | 04/06/19 | Machine | $72,352 | $34.78 | 1 | 16 | 29 | No | 4 | 1 | 2 | PA | Northeast |
| 1477 | 06/24/13 | Shipping | $72,946 | $35.07 | 7 | 14 | 24 | No | 1 | 2 | 2 | PA | Northeast |
| 1815 | 12/01/13 | Machine | $73,005 | $35.10 | 6 | 14 | 43 | No | 3 | 1 | 1 | PA | Northeast |
| 1156 | 05/03/13 | Machine | $73,640 | $35.40 | 7 | 16 | 45 | No | 3 | 1 | 1 | PA | Northeast |
| 1661 | 10/21/16 | Shipping | $75,074 | $36.09 | 3 | 19 | 58 | No | 1 | 1 | 1 | PA | Northeast |
| 1145 | 10/12/12 | Machine | $75,179 | $36.14 | 7 | 14 | 49 | No | 1 | 2 | 2 | PA | Northeast |
| 1543 | 09/07/12 | Machine | $75,270 | $36.19 | 7 | 19 | 35 | No | 3 | 1 | 1 | PA | Northeast |
| 1053 | 01/04/05 | Machine | $75,293 | $36.20 | 15 | 16 | 57 | Yes | 3 | 2 | 1 | PA | Northeast |
| 1083 | 10/08/11 | Machine | $75,612 | $36.35 | 8 | 16 | 31 | No | 3 | 1 | 1 | PA | Northeast |
| 1070 | 09/01/06 | Machine | $75,920 | $36.50 | 13 | 14 | 30 | Yes | 3 | 2 | 1 | PA | Northeast |
| 1132 | 02/25/14 | Machine | $76,305 | $36.69 | 6 | 16 | 55 | No | 1 | 1 | 1 | PA | Northeast |
| 1140 | 10/04/12 | Machine | $76,499 | $36.78 | 7 | 14 | 46 | No | 1 | 1 | 1 | PA | Northeast |
| 1391 | 10/02/15 | Machine | $78,015 | $37.51 | 4 | 16 | 31 | No | 3 | 1 | 1 | PA | Northeast |
| 1816 | 06/27/12 | Machine | $78,334 | $37.66 | 8 | 19 | 34 | No | 3 | 1 | 1 | PA | Northeast |
| 1232 | 08/25/18 | Shipping | $78,475 | $37.73 | 1 | 16 | 40 | No | 3 | 1 | 2 | PA | Northeast |
| 1612 | 05/06/11 | Shipping | $78,529 | $37.75 | 9 | 16 | 44 | No | 1 | 1 | 1 | PA | Northeast |
| 1185 | 06/18/09 | Machine | $78,869 | $37.92 | 11 | 16 | 39 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1571 | 11/11/14 | Machine | $78,873 | $37.92 | 5 | 12 | 36 | No | 1 | 2 | 2 | PA | Northeast |
| 1553 | 08/10/13 | Machine | $78,900 | $37.93 | 6 | 12 | 26 | No | 3 | 1 | 2 | PA | Northeast |
| 1474 | 09/09/12 | Machine | $79,591 | $38.26 | 7 | 12 | 47 | No | 3 | 1 | 1 | PA | Northeast |
| 1466 | 12/29/17 | Machine | $80,045 | $38.48 | 2 | 14 | 43 | No | 1 | 1 | 1 | PA | Northeast |
| 1254 | 09/13/12 | Machine | $80,191 | $38.55 | 7 | 16 | 28 | No | 1 | 1 | 1 | PA | Northeast |
| 1575 | 03/12/13 | Machine | $80,666 | $38.78 | 7 | 16 | 44 | No | 3 | 1 | 1 | PA | Northeast |
| 1116 | 08/19/14 | Machine | $81,050 | $38.97 | 5 | 16 | 36 | No | 3 | 1 | 1 | PA | Northeast |
| 1005 | 04/29/11 | Machine | $81,287 | $39.08 | 9 | 16 | 65 | No | 3 | 1 | 1 | PA | Northeast |
| 1802 | 11/10/11 | Machine | $82,471 | $39.65 | 8 | 16 | 39 | No | 3 | 1 | 2 | PA | Northeast |
| 1138 | 7/20/01 | Machine | $82,515 | $39.67 | 18 | 16 | 39 | Yes | 1 | 1 | 2 | PA | Northeast |
| 1820 | 12/17/15 | Shipping | $82,601 | $39.71 | 4 | 19 | 41 | No | 1 | 1 | 1 | PA | Northeast |
| 1267 | 5/3/14 | Machine | $83,294 | $40.05 | 6 | 16 | 49 | No | 3 | 1 | 2 | PA | Northeast |
| 1314 | 1/20/12 | Machine | $83,367 | $40.08 | 8 | 16 | 37 | No | 1 | 1 | 2 | PA | Northeast |
| 1387 | 01/04/16 | Machine | $83,430 | $40.11 | 4 | 16 | 38 | No | 3 | 1 | 1 | PA | Northeast |
| 1533 | 07/11/03 | Machine | $83,851 | $40.31 | 16 | 16 | 51 | Yes | 1 | 1 | 1 | PA | Northeast |
| 1484 | 10/30/10 | Shipping | $84,175 | $40.47 | 9 | 16 | 37 | No | 3 | 1 | 1 | PA | Northeast |
| 1619 | 10/6/10 | Machine | $84,270 | $40.51 | 9 | 16 | 30 | No | 3 | 1 | 1 | PA | Northeast |
| 1295 | 07/12/11 | Purch | $84,275 | $40.52 | 8 | 16 | 41 | No | 3 | 1 | 1 | PA | Northeast |
| 1426 | 11/06/07 | Machine | $84,679 | $40.71 | 12 | 19 | 35 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1279 | 09/28/01 | Machine | $84,713 | $40.73 | 18 | 16 | 39 | Yes | 4 | 1 | 1 | PA | Northeast |
| 1553 | 06/13/04 | Machine | $85,256 | $40.99 | 16 | 16 | 41 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1373 | 10/20/12 | Machine | $86,597 | $41.63 | 7 | 14 | 44 | No | 1 | 1 | 1 | PA | Northeast |
| 1630 | 12/02/09 | Shipping | $86,666 | $41.67 | 10 | 12 | 27 | Yes | 1 | 1 | 2 | PA | Northeast |
| 1056 | 02/10/16 | Machine | $87,047 | $41.85 | 4 | 14 | 25 | No | 3 | 2 | 2 | PA | Northeast |
| 1821 | 03/11/13 | Machine | $87,943 | $42.28 | 7 | 12 | 29 | No | 1 | 1 | 1 | PA | Northeast |
| 1227 | 01/04/14 | Machine | $89,165 | $42.87 | 6 | 19 | 49 | No | 3 | 2 | 1 | PA | Northeast |
| 1523 | 05/15/18 | Acctg/Fin | $90,688 | $43.60 | 2 | 16 | 23 | No | 1 | 2 | 2 | PA | Northeast |
| 1387 | 01/10/17 | Machine | $90,930 | $43.72 | 3 | 19 | 45 | No | 3 | 1 | 1 | PA | Northeast |
| 1589 | 10/13/13 | Design | $91,444 | $43.96 | 6 | 19 | 61 | No | 4 | 1 | 1 | PA | Northeast |
| 1767 | 11/16/05 | Machine | $91,507 | $43.99 | 14 | 19 | 53 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1079 | 05/22/09 | Invent | $91,771 | $44.12 | 11 | 16 | 30 | Yes | 3 | 1 | 2 | PA | Northeast |
| 1104 | 08/05/12 | Machine | $93,518 | $44.96 | 7 | 14 | 39 | No | 1 | 1 | 1 | PA | Northeast |
| 1216 | 10/05/04 | Shipping | $94,876 | $45.61 | 15 | 16 | 48 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1285 | 02/06/10 | Advertg | $95,622 | $45.97 | 10 | 19 | 36 | No | 2 | 1 | 1 | PA | Northeast |
| 1461 | 02/23/16 | Advertg | $95,662 | $45.99 | 4 | 14 | 31 | No | 1 | 2 | 1 | PA | Northeast |
| 1687 | 12/21/16 | Machine | $96,338 | $46.32 | 3 | 16 | 42 | No | 3 | 2 | 1 | PA | Northeast |
| 1782 | 09/25/14 | Machine | $96,566 | $46.43 | 5 | 19 | 46 | No | 3 | 1 | 1 | PA | Northeast |
| 1418 | 05/01/12 | Quality | $97,323 | $46.79 | 8 | 14 | 34 | No | 1 | 2 | 1 | PA | Northeast |
| 1481 | 11/20/08 | Machine | $97,885 | $47.06 | 11 | 16 | 28 | Yes | 1 | 1 | 1 | PA | Northeast |
| 1513 | 06/10/13 | Machine | $98,007 | $47.12 | 7 | 19 | 28 | No | 1 | 1 | 2 | PA | Northeast |
| 1220 | 09/27/12 | Machine | $98,234 | $47.23 | 7 | 16 | 58 | No | 3 | 1 | 1 | PA | Northeast |
| 1569 | 05/20/13 | Quality | $98,943 | $47.57 | 7 | 16 | 36 | No | 3 | 1 | 1 | PA | Northeast |
| 1190 | 5/6/18 | Machine | $99,786 | $47.97 | 2 | 14 | 31 | No | 1 | 2 | 2 | PA | Northeast |
| 1292 | 04/29/12 | Machine | $101,016 | $48.57 | 8 | 16 | 35 | No | 4 | 1 | 2 | PA | Northeast |
| 1756 | 12/29/11 | Machine | $101,341 | $48.72 | 8 | 14 | 39 | No | 3 | 2 | 2 | PA | Northeast |
| 1055 | 2/12/08 | Machine | $101,386 | $48.74 | 12 | 16 | 27 | Yes | 1 | 1 | 2 | PA | Northeast |
| 1393 | 2/24/18 | Machine | $102,238 | $49.15 | 2 | 16 | 45 | No | 3 | 1 | 1 | PA | Northeast |
| 1394 | 04/01/07 | Machine | $103,349 | $49.69 | 13 | 14 | 56 | Yes | 3 | 1 | 2 | PA | Northeast |
| 1083 | 7/4/16 | Machine | $103,736 | $49.87 | 3 | 19 | 56 | No | 3 | 1 | 1 | PA | Northeast |
| 1840 | 9/4/06 | Machine | $104,220 | $50.11 | 13 | 19 | 51 | Yes | 3 | 2 | 1 | PA | Northeast |
| 1190 | 12/29/17 | Machine | $104,961 | $50.46 | 2 | 16 | 41 | No | 1 | 1 | 1 | PA | Northeast |
| 1130 | 10/11/15 | Machine | $105,637 | $50.79 | 4 | 19 | 44 | No | 3 | 1 | 1 | PA | Northeast |
| 1800 | 12/28/10 | Machine | $106,267 | $51.09 | 9 | 16 | 40 | No | 3 | 1 | 1 | PA | Northeast |
| 1527 | 09/28/04 | Machine | $106,600 | $51.25 | 15 | 16 | 60 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1794 | 01/29/12 | Engineering | $107,496 | $51.68 | 8 | 16 | 43 | No | 1 | 1 | 1 | PA | Northeast |
| 1760 | 12/03/13 | Design | $108,326 | $52.08 | 6 | 19 | 41 | No | 3 | 1 | 1 | PA | Northeast |
| 1411 | 12/28/05 | Design | $108,604 | $52.21 | 14 | 19 | 47 | Yes | 3 | 2 | 1 | PA | Northeast |
| 1776 | 11/11/10 | Design | $108,866 | $52.34 | 9 | 16 | 27 | No | 1 | 2 | 1 | PA | Northeast |
| 1531 | 08/27/07 | Design | $110,877 | $53.31 | 12 | 19 | 50 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1444 | 08/28/07 | Sales | $112,994 | $54.32 | 12 | 16 | 38 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1218 | 12/25/15 | Design | $113,056 | $54.35 | 4 | 19 | 56 | No | 3 | 1 | 1 | PA | Northeast |
| 1804 | 02/05/14 | Quality | $113,246 | $54.45 | 6 | 19 | 34 | No | 2 | 1 | 1 | PA | Northeast |
| 1616 | 03/30/11 | Advertg | $114,251 | $54.93 | 9 | 14 | 44 | No | 2 | 2 | 1 | PA | Northeast |
| 1668 | 12/16/10 | Advertg | $114,721 | $55.15 | 9 | 14 | 51 | No | 3 | 1 | 1 | PA | Northeast |
| 1841 | 11/03/17 | Sr Mach | $114,854 | $55.22 | 2 | 14 | 26 | No | 3 | 1 | 2 | PA | Northeast |
| 1038 | 07/18/14 | IT Staff | $115,966 | $55.75 | 5 | 16 | 42 | No | 3 | 2 | 1 | PA | Northeast |
| 1276 | 08/05/11 | IT Staff | $115,974 | $55.76 | 8 | 16 | 54 | No | 1 | 1 | 1 | PA | Northeast |
| 1831 | 09/04/04 | Sr Mach | $117,062 | $56.28 | 15 | 16 | 27 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1679 | 01/24/13 | Acctg/Fin | $117,214 | $56.35 | 7 | 16 | 54 | No | 2 | 1 | 1 | PA | Northeast |
| 1787 | 11/18/13 | Acctg/Fin | $118,997 | $57.21 | 6 | 14 | 25 | No | 1 | 1 | 1 | PA | Northeast |
| 1003 | 03/23/16 | Sr Mach | $119,156 | $57.29 | 4 | 16 | 41 | No | 3 | 1 | 1 | PA | Northeast |
| 1153 | 08/17/07 | Sr Mach | $119,165 | $57.29 | 12 | 16 | 31 | Yes | 4 | 1 | 1 | PA | Northeast |
| 1673 | 01/06/17 | Mrktg | $119,537 | $57.47 | 3 | 19 | 47 | No | 4 | 1 | 2 | PA | Northeast |
| 1429 | 11/02/14 | Sr Mach | $121,455 | $58.39 | 5 | 16 | 40 | No | 1 | 1 | 1 | PA | Northeast |
| 1748 | 09/17/06 | Mrktg | $124,996 | $60.09 | 13 | 16 | 49 | Yes | 2 | 1 | 2 | PA | Northeast |
| 1774 | 11/30/06 | Flr Supr | $125,004 | $60.10 | 13 | 16 | 32 | Yes | 1 | 2 | 1 | PA | Northeast |
| 1417 | 02/15/16 | Sr Mach | $126,426 | $60.78 | 4 | 14 | 56 | No | 3 | 1 | 1 | PA | Northeast |
| 1443 | 11/26/14 | Sr Mach | $127,890 | $61.49 | 5 | 12 | 47 | No | 3 | 1 | 1 | PA | Northeast |
| 1456 | 07/16/12 | Sr Mach | $128,825 | $61.94 | 7 | 16 | 25 | No | 3 | 1 | 2 | PA | Northeast |
| 1258 | 10/27/15 | Sr Mach | $128,943 | $61.99 | 4 | 14 | 49 | No | 3 | 1 | 1 | PA | Northeast |
| 1597 | 07/11/04 | Flr Supr | $131,580 | $63.26 | 15 | 14 | 41 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1754 | 04/24/11 | Sr Mach | $131,698 | $63.32 | 9 | 14 | 63 | No | 3 | 1 | 1 | PA | Northeast |
| 1432 | 03/26/12 | Design | $133,678 | $64.27 | 8 | 16 | 52 | No | 3 | 1 | 1 | PA | Northeast |
| 1403 | 11/23/17 | Sales | $134,847 | $64.83 | 2 | 16 | 55 | No | 1 | 1 | 1 | PA | Northeast |
| 1737 | 12/04/11 | Invent | $143,005 | $68.75 | 8 | 19 | 36 | No | 3 | 1 | 1 | PA | Northeast |
| 1640 | 02/20/14 | Design | $143,063 | $68.78 | 6 | 14 | 36 | No | 1 | 1 | 1 | PA | Northeast |
| 1002 | 02/24/16 | Design | $144,571 | $69.51 | 4 | 16 | 36 | No | 4 | 1 | 2 | PA | Northeast |
| 1400 | 12/24/16 | Design | $148,111 | $71.21 | 3 | 14 | 33 | No | 3 | 1 | 1 | PA | Northeast |
| 1848 | 08/31/11 | Design | $149,466 | $71.86 | 8 | 19 | 30 | No | 3 | 1 | 1 | PA | Northeast |
| 1793 | 08/30/13 | Design | $149,466 | $71.86 | 6 | 16 | 42 | No | 3 | 1 | 1 | PA | Northeast |
| 1116 | 07/21/08 | Quality | $151,174 | $72.68 | 11 | 16 | 40 | Yes | 3 | 2 | 1 | PA | Northeast |
| 1113 | 12/31/04 | Sr Mach | $151,174 | $72.68 | 15 | 16 | 38 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1246 | 08/25/10 | Sr Mach | $151,523 | $72.85 | 9 | 16 | 34 | No | 3 | 1 | 2 | PA | Northeast |
| 1325 | 07/18/17 | Sr Mach | $152,446 | $73.29 | 2 | 16 | 37 | No | 3 | 1 | 1 | PA | Northeast |
| 1299 | 04/04/17 | Shp Mgr | $154,122 | $74.10 | 3 | 14 | 35 | No | 3 | 1 | 2 | PA | Northeast |
| 1424 | 07/15/09 | Sr Mach | $154,122 | $74.10 | 10 | 12 | 49 | Yes | 3 | 2 | 2 | PA | Northeast |
| 1667 | 02/28/12 | Engineering | $154,933 | $74.49 | 8 | 16 | 34 | No | 3 | 1 | 2 | PA | Northeast |
| 1616 | 09/04/06 | Engineering | $156,750 | $75.36 | 13 | 16 | 38 | Yes | 4 | 1 | 1 | PA | Northeast |
| 1049 | 05/21/06 | IT Staff | $162,731 | $78.24 | 14 | 16 | 32 | Yes | 1 | 1 | 1 | PA | Northeast |
| 1102 | 06/05/11 | IT Staff | $163,045 | $78.39 | 9 | 16 | 50 | No | 1 | 1 | 1 | PA | Northeast |
| 1693 | 02/06/14 | Engineering | $164,033 | $78.86 | 6 | 16 | 54 | No | 3 | 1 | 1 | PA | Northeast |
| 1672 | 05/27/04 | Sr Flr Mgr | $170,954 | $82.19 | 16 | 12 | 49 | Yes | 3 | 1 | 2 | PA | Northeast |
| 1744 | 11/25/18 | Eng Mgr | $186,670 | $89.75 | 1 | 16 | 60 | No | 1 | 1 | 2 | PA | Northeast |
| 1001 | 04/23/15 | CEO | $239,315 | $115.06 | 5 | 19 | 58 | No | 3 | 1 | 1 | PA | Northeast |
| Northeast Count | 149 | ||||||||||||
| $37,078,070 | Grand Count | 372 | |||||||||||
| Region Key | |||||||||||||
| State | Region | ||||||||||||
| PA | Northeast | ||||||||||||
| IL | Midwest | ||||||||||||
| NE | C-Plains | ||||||||||||
LUIS E. CASAL &D &P
Projected Sales
| Sales Summary (Provided) | |||
| Yr | Sales | ||
| 2003 | $1,656,872 | ||
| 2004 | $47,830,245 | ||
| 2005 | $84,088,009 | ||
| 2006 | $130,427,572 | ||
| 2007 | $146,938,882 | ||
| 2008 | $139,117,818 | ||
| 2009 | $143,547,199 | ||
| 2010 | $144,834,875 | ||
| 2011 | $149,578,842 | ||
| 2012 | $155,740,613 | ||
| 2013 | $144,759,828 | ||
| 2014 | $156,714,301 | ||
| 2015 | $150,201,379 | ||
| 2016 | $154,750,829 | ||
| 2017 | $158,253,462 | ||
| 2018 | $156,494,223 | ||
| 2019 | $165,800,498 | ||
| 2020 | $191,210,386 | ||
| 2021 | $197,876,014 | ||
| 2022 | $204,541,642 | ||
| 2023 | $211,207,270 | ||
| 2024 | $217,872,898 |