supply chain management on excel
nawaf89
prime_line_conversion.xlsxEmployees
| Name | Hourly pay | Overtime* |
| Samantha | $ 9.75 | $ 14.70 |
| Gissel | $ 10.25 | $ 15.40 |
| Anne | $ 10.50 | $ 15.80 |
| Demi | $ 9.50 | $ 14.30 |
| Alison | $ 9.25 | $ 13.90 |
| Jessica | $ 10.50 | $ 15.80 |
| *overtime is more than 8 hours a day |
Kits
| Velcro strap | Hinge | Screw #8 1/2" | Screw #8 1" | Screw #8 2" | Washer | |
| Kit1 | 1 | 6 | ||||
| Kit2 | 1 | 2 | 2 | 2 | ||
| Kit3 | 2 | 4 | 2 | 2 |
Daily Output
| Hours worked | Completed kits | Mistakes | ||||||||||
| Date | Samantha | Gissel | Anne | Demi | Alison | Jessica | Kit 1 | Kit 2 | Kit 3 | Kit 1 | Kit 2 | Kit 3 |
| 5-Sep | 8 | 7 | 7 | 8 | 4 | 7 | 2419 | 2050 | 8 | 11 | - 0 | |
| 6-Sep | 7 | 7 | 7 | 7 | 4 | 4 | 1836 | 1548 | - 0 | 10 | 8 | |
| 7-Sep | 8 | 8 | 8 | 8 | 4 | 8 | 2684 | 2200 | 9 | 11 | - 0 | |
| 8-Sep | 7 | 8 | 8 | 8 | 4 | 4 | 2340 | 1638 | 8 | - 0 | 8 | |
| 9-Sep | 0 | 8 | 8 | 8 | 4 | 8 | 2088 | 1476 | 7 | - 0 | 7 | |
| 12-Sep | 8 | 6 | 8 | 8 | 8 | 8 | 2760 | 1932 | 9 | - 0 | 10 | |
| 13-Sep | 8 | 6 | 8 | 8 | 4 | 8 | 2562 | 2058 | 8 | 11 | - 0 | |
| 14-Sep | 8 | 8 | 8 | 8 | 4 | 4 | 2040 | 1720 | - 0 | 11 | 8 | |
| 15-Sep | 8 | 8 | 4 | 8 | 4 | 8 | 2000 | 1680 | - 0 | 10 | 8 | |
| 16-Sep | 10 | 8 | 8 | 11 | 6 | 10 | 1484 | 1272 | 2067 | 5 | 7 | 10 |
| 19-Sep | 4 | 7 | 6 | 8 | 8 | 4 | 2220 | 1591 | 7 | - 0 | 8 | |
| 20-Sep | 8 | 6 | 6 | 8 | 8 | 4 | 2360 | 2080 | 8 | 11 | - 0 | |
| 21-Sep | 8 | 8 | 8 | 8 | 4 | 8 | 2508 | 2244 | 8 | 12 | - 0 | |
| 22-Sep | 8 | 8 | 8 | 4 | 4 | 8 | 1920 | 1680 | - 0 | 10 | 8 | |
| 23-Sep | 9 | 0 | 10 | 8 | 9 | 6 | 2488 | 988 | 851 | 8 | 5 | 5 |
| 26-Sep | 8 | 8 | 7 | 8 | 4 | 6 | 2337 | 2050 | 8 | 11 | - 0 | |
| 27-Sep | 8 | 8 | 6 | 8 | 4 | 6 | 2360 | 1680 | 8 | - 0 | 8 | |
| 28-Sep | 8 | 8 | 8 | 8 | 4 | 6 | 2058 | 1743 | - 0 | 11 | 9 | |
| 29-Sep | 8 | 8 | 8 | 8 | 4 | 6 | 2100 | 1764 | - 0 | 11 | 9 | |
| 30-Sep | 6 | 8 | 8 | 4 | 8 | 8 | 1744.68 | 1491.42 | 1219.68 | 6 | 8 | 6 |
