John Bruno owns a factory producing electric cords. John observes that recently the number of cords with defects has increased. He monitors the 3 processing machines for 30 days for 100 cords per observation per machine. The results of John Brunos observations are presented in the table below. What can he do to make sure that the number of cords with defects to go down? Please click on the link below to see the data:

You need to find the number of each defect per machine, then based on your results give your recommendations. You need to show your work and spreadsheet if excel is used.

10:18 PM Sun May 31 60% Number of Rejects by Cause.pdf Number of Rejects by Cause Number of Bad Date observations Machine Wind Twisted Broken cord Leads Abraded Broken Wrong cord cord wire Failed Electrical Test 1 100 1 0 1 3 1 O o 1 100 2 2 1 0 0 2 5 O 100 3 o o o 5 o o 3 2 100 1 1 o 4 o O o o 100 2 3 1 O o 1 3 o 100 3 o o 1 6 o O o 3 100 1 1 o 0 2 0 o o 100 2 o o o 0 o 3 o 100 3 0 o 1 4 0 o 3 4 100 1 0 o 3 o o o o 100 2 0 O O O 0 2 O 100 3 0 0 0 3 1 o 3 5 100 1 0 1 5 0 O o o 100 2 0 o O O o 2 1 100 3 0 O 0 3 0 o 2 8 100 1 0 0 2 O 0 0 0 100 2 0 0 O 0 0 1 0 100 3 0 0 O 3 O O 3 9 100 1 0 1 2 0 0 0 O 100 2 o o O o 0 1 o Dashboard 90 Calendar To Do Notifications Inbox 10:18 PM Sun May 31 60% Number of Rejects by Cause.pdf 100 3 o o o 3 O o 4 10 100 1 0 O 5 o O o o 100 2 1 o o O 1 0 O 100 3 O o 0 5 o 0 4 11 100 1 o o 4 o 0 o o 100 2 0 O 0 o 0 o o 100 3 0 o O 4 o o 4 12 100 1 o o 3 o 1 o o 100 2 1 o 1 0 o o O 100 3 o 0 0 5 O o 4 15 100 1 0 0 2 O 0 1 O 100 2 0 0 0 o O 1 0 100 0 o O 3 o o 3 16 100 1 0 0 6 O 0 0 0 100 2 0 0 O O 0 0 O 100 0 o o 3 O O 3 17 100 1 0 1 1 0 0 0 o 100 2 0 o O O 0 o 1 100 3 o o O 3 o 0 3 18 100 1 1 o 2 0 o o o 100 2 0 O 0 o 0 1 o 100 3 0 0 0 4 0 0 1 19 100 1 o 0 2 o o o o Dashboard 90 Calendar To Do Notifications Inbox 10:18 PM Sun May 31 60% Number of Rejects by Cause.pdf 100 2 0 o o O O 0 o 100 3 o 0 o 3 o o 1 22 100 1 0 1 4 o 0 0 o 100 2 0 0 0 O 0 o O 100 3 o o o 3 o 1 2 23 100 1 0 o 4 0 O o o 100 2 0 o o o O o 1 100 3 o o o 4 o O 3 24 100 1 o o 2 0 o 1 O 100 2 o 1 o o o o o 100 3 0 0 0 4 O o 3 25 100 1 0 O 3 O 0 0 O 100 2 o o O 1 0 0 O 100 3 o o o 2 o o 4 26 100 1 0 o 1 o 0 o o 100 2 0 1 O 1 0 o 0 100 3 o o o 2 o o 3 29 100 1 o o 2 o o o 0 100 2 0 0 1 o o o o 100 3 0 o o 2 o o 3 30 100 1 0 O 2 0 0 0 o 100 2 0 0 0 O 1 0 O 100 3 0 O O 2 o O 3 Dashboard 90 Calendar To Do Notifications Inbox 10:18 PM Sun May 31 60% Number of Rejects by Cause.pdf Number of Rejects by Cause Number of Bad Date observations Machine Wind Twisted Broken cord Leads Abraded Broken Wrong cord cord wire Failed Electrical Test 1 100 1 0 1 3 1 O o 1 100 2 2 1 0 0 2 5 O 100 3 o o o 5 o o 3 2 100 1 1 o 4 o O o o 100 2 3 1 O o 1 3 o 100 3 o o 1 6 o O o 3 100 1 1 o 0 2 0 o o 100 2 o o o 0 o 3 o 100 3 0 o 1 4 0 o 3 4 100 1 0 o 3 o o o o 100 2 0 O O O 0 2 O 100 3 0 0 0 3 1 o 3 5 100 1 0 1 5 0 O o o 100 2 0 o O O o 2 1 100 3 0 O 0 3 0 o 2 8 100 1 0 0 2 O 0 0 0 100 2 0 0 O 0 0 1 0 100 3 0 0 O 3 O O 3 9 100 1 0 1 2 0 0 0 O 100 2 o o O o 0 1 o Dashboard 90 Calendar To Do Notifications Inbox 10:18 PM Sun May 31 60% Number of Rejects by Cause.pdf 100 3 o o o 3 O o 4 10 100 1 0 O 5 o O o o 100 2 1 o o O 1 0 O 100 3 O o 0 5 o 0 4 11 100 1 o o 4 o 0 o o 100 2 0 O 0 o 0 o o 100 3 0 o O 4 o o 4 12 100 1 o o 3 o 1 o o 100 2 1 o 1 0 o o O 100 3 o 0 0 5 O o 4 15 100 1 0 0 2 O 0 1 O 100 2 0 0 0 o O 1 0 100 0 o O 3 o o 3 16 100 1 0 0 6 O 0 0 0 100 2 0 0 O O 0 0 O 100 0 o o 3 O O 3 17 100 1 0 1 1 0 0 0 o 100 2 0 o O O 0 o 1 100 3 o o O 3 o 0 3 18 100 1 1 o 2 0 o o o 100 2 0 O 0 o 0 1 o 100 3 0 0 0 4 0 0 1 19 100 1 o 0 2 o o o o Dashboard 90 Calendar To Do Notifications Inbox 10:18 PM Sun May 31 60% Number of Rejects by Cause.pdf 100 2 0 o o O O 0 o 100 3 o 0 o 3 o o 1 22 100 1 0 1 4 o 0 0 o 100 2 0 0 0 O 0 o O 100 3 o o o 3 o 1 2 23 100 1 0 o 4 0 O o o 100 2 0 o o o O o 1 100 3 o o o 4 o O 3 24 100 1 o o 2 0 o 1 O 100 2 o 1 o o o o o 100 3 0 0 0 4 O o 3 25 100 1 0 O 3 O 0 0 O 100 2 o o O 1 0 0 O 100 3 o o o 2 o o 4 26 100 1 0 o 1 o 0 o o 100 2 0 1 O 1 0 o 0 100 3 o o o 2 o o 3 29 100 1 o o 2 o o o 0 100 2 0 0 1 o o o o 100 3 0 o o 2 o o 3 30 100 1 0 O 2 0 0 0 o 100 2 0 0 0 O 1 0 O 100 3 0 O O 2 o O 3 Dashboard 90 Calendar To Do Notifications Inbox