Use the charts below
- What are some key themes you can gather by the data provided?
- What are some noticeable trends?
- What actions are needed to increase performance?
- What are some data-collecting methods for measuring performance and which one would you recommend?
Absenteeism Analysis 2016 Q116 Q216 0316 Q416 Year End 198 Sunnyvale 19 192 192 Spartanburg 19 194 190 21 215 220 220 220 Gilbert 25 Total Available Work Days Sunnyvale 10962 12159 12474 13266 48861 11194 12222 11970 12864 48250 Gilbert 13860 14740 Workdays Lost - Unplanned Absences Sunnyvale 210 175 300 423 1108 342 402 412 386 1542 321 Gilbert 293 284 1287 Sunnyvale 1.92% 1.44% 2.41% 3.19% 2.27% 3.06% 3.29% 3.44% 3.00% 3.20% 2.34% 2.16% 2 32% 2.61% 2.36% 2.6% Industry 2017 Q117 Q217 Q317 Q417 228 236 233 233 Spartanburg 197 197 202 211 265 285 285 Gilbert Work Days 250 Days in Total Available Work Days Sunnyvale 12996 14805 14868 1561 58280 11229 12411 12726 14137 50503 12825 15624 16695 19095 Gilber 64239 Workdays Lost - Unplanned Absences 123 150 260 287 820 370 390 538 1725 300 422 493 1465 1.41% Sunnyvale 0.95% 1.01% 1.75% 1.84% 3.80% 2.98% 3.06% 3.81% 3.42 % 1.95% 1.92% 2.53% 2.58% 2.28% Gilbert 2.7% Industry 2018 Q118 0218 Q318 2418 Year End Sunnyvale 245 242 242 242 Spartanburg 217 231 246 263 263 378 399 399 Gilbert 283 332 63 251 Quarter Total Available Work Days 15435 15246 16456 60247 14553 15498 Gilber 16131 20916 23814 27132 87993 Workdays Lost - Unplanned Absences Sunnyvale 154 18 163 278 783 502 185 575 2150 475 512 624 566 2177 Gilbert Absenteeism Rate Sunnyvale 1.17% 1.22% 1,07% 1.69% 1.30% Spartanburg 3.35% 3.57% Gilbert 2.94% 2.45% 2.62% 2.09% 2.45% Industry 2019 Q119 Q219 Q319 Q419 Year End 213 168 172 169 169 285 280 Spartanburg 278 283 280 235 327 337 Gilbert 25 Days in Quarter Total Available Work Days Sunnyvale 12780 10752 10836 10816 45184 Spartanburg 18112 17955 17920 70667 23760 22528 21105 21568 88961 Gilber Workdays Lost - Unplanned Absences 253 20 197 245 901 $20 2567 782 567 598 713 731 659 2745 Gilber 1.98% 1.92% 1.82% 2.27% 1.99% 3.63% Gilbert 3.00% 2.85% 3.46% 3.06% 3.09% 2.6% IndustryAnnual Attrition: Spartanburg Plant 2016 21 Q2 23 Q4 Year End Total 193 194 190 192 197 Employees (last day measure period) New Hires 10 28 Retired 2 Resigned 3 3 0 Involuntarily 6 3 2 13 Terminated Total Attrition 3 10 8 3 24 Rate 2% 5% 4% 29% 12% Less than 5 3 w N Years with Capra Tek 5 or More Years with Capra Tek 2017 Q1 Q2 Q3 Q4 ear End Total 197 197 202 211 217 Employees (last day measured period) New Hires 10 17 12 13 52 Retired 2 0 1 o w Resigned 5 7 2 0 14 nvoluntarily 5 7 15 Terminated Total Attrition 10 12 3 7 32 Rate 5% 6% 1% 3% 15% Less than 5 2 17 Years with Capra Tek 5 or More 15 Years with Capra Tek 2018 Q1 Q2 23 Q4 ear End Total 217 231 246 263 278 Employees (last day measured period) New Hires 25 30 26 23 104 Retired IN Resigned 5 2 19 Involuntarily A 5 22 Terminated Total Attrition 11 9 8 43 Rate 5% 6% 15%% Less than 5 6 7 w 25 Years with Capra Tek 5 or More 2 18 Years with Capra Tek 2019 Q1 23 24 Year End Total 278 283 285 280 278 Employees (last day measured period) New Hires 20 12 8 8 48 Retired 2 4 Resigned Involuntarily a w 21 5 5 23 Terminated Total Attrition 15 13 10 48 Rate 59% 46 5% 46 17% Less than 5 20 Years with Capra Tek 5 or More 10 7 5 28 Years with Capra Tek 2020 21 22 23 Q4 Year End Total 278 280 272 260 254 Employees (last day measured eriod) New Hires 12 10 36 Retired Resigned Involuntarily Terminated w a o w IN 12 36 5 18 Total Attrition 10 18 19 13 60 Rate 6% 7% 24% Less than 5 Co 21 Years with Capra Tek 5 or More 11 12 5 29 Years with Capra TekSalary Competitive Analysis Manufacturing Technician Spartanburg. Gilbert, Benchmark Benchmark Base Salary - 2020 26,163 25.938 29,063 28 43 31,250 Base Salary - 2017 23,667 28,750 24 438 23,863 28,750 Base Salary - 2016 24 374 28.005 22.024 22.296 Benefits Medica Life Insura Disability Insuran Paid Holida Paid Time Of Tuition Assistance 401 (1) Prof Sharing/Retirement Plan Flexible Medical Childcare Plan Other Team Lead Spartanburg. Gilbert Benchmark Benchmark Industr Base Salary - 2020 34,890 37.924 Base Salary - 2017 32.483 Base Salary - 2016 32 507 37.348 Benefits Medical Vision Life Insurance Disability Insurance Paid Holidays Paid Time Of Tuition Assistance 401() Profi Sharing/Retirement Plan Flexible Medical Childcare Plan Other Production Supervisor Spartanburg. Sybert. Benchmark Benchmark Ang Base Salary - 2020 43,890 43,513 48,755 47,707 $2,425 Base Salary - 2017 39,703 48.230 Base Salary - 2016 46.978 Benefits Medical Life Insur Disability Insurance Paid Holidays Paid Time Off Tuition Assistance 401 () Profit Flexible Medical/ Childcare Plan Other Production Manager Spartanburg. Gilbert. Benchmark Benchmark Inc Ang Base Salary - 2020 57,097 Base Salary - 2017 51.652 62.745 Base Salary - 2016 53 194 61.115 48.061 48.655 Benefits Medical Dental Life Insurance Disability Insurance Paid Holidays Paid Time Off Tuition Assistance 401(K) Profi Sharing/Retirement Plan Flexible Medical Childcare Plan Product Line Manager Spartanburg. Gilbert, AZ Benchmark Benchmark Base Salary - 2020 63.50 62,956 69.024 Base Salary - 2017 2 443 59.780 59 313 57 917 Base Salary - 201 67.980 Benefits Dental Disability Insurance Paid Holida Paid Time Off Sharing/Retirement Plan Flexible Medical Childcare Plan Other Shift Manager Spartanburg. SC Gilbert. Benchmark Benchmark Industr Base Salary - 2020 77.49 76.825 84,23 92.560 Base Salary - 2017 70,100 85,155 72,382 70,679 Base Salary - 2016 29 191 32.941 65.225 66.031 Benefits Medica Life Insura Disability Insuran Paid Holida Paid Time Of Tuition Assistance 401 () Prof Sharing/Retirement Plan Flexible Medical/ Childcare Plan Other Plant Manager partanburg. Gilbert Benchmark Benchmark Indust Base Salary - 2020 110.653 122.918 Base Salary - 2017 109.101 Base Salary - 2016 93 277 18 656 $3.312 Benefits Medical Dental Vision Life Insurance Disability Insurance Paid Holidays Paid Time Of Tuition Assistance 401() Profi Sharing/Retirement Plan Flexible Medical Childcare Plan Other
