Final project report for Methods engineering course

profileBahl93
cycletimestudycleansheetprojectpart4.xlsx

Time study for AutoZone

Time study worksheet
Operation description: Replace the battery at AutoZone
Part description
Element # Element Description Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings Readings total average % normal time
cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle cycle 30 time rating
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 cycles 10%
1 Grabe the battery that the customer just chose 9.43 10.45 12.09 11.12 10.34 9.98 11.43 11.45 10.4 9.78 12.3 13.1 12.44 13.43 12.43 13.54 14.45 12.33 12.33 11.33 12.49 10.32 11.23 12.11 13.43 14.65 11.32 10.34 11.34 9.23 350.61 11.687 1.1687 12.8557
2 Bring the tools to install the battery for the customer 8.76 9.03 8.98 7.78 9.12 8.45 7.93 8.96 9.12 8.43 8.12 7.99 8.44 9.32 8.92 7.96 8.12 9.11 8.11 9.34 7.12 8.34 8.32 9.23 8.23 7.99 8.23 9.14 8.24 8.33 255.16 8.5053333333 0.8505333333 9.3558666667
3 Go outside to lacate the car 12.98 13.54 14.76 11.32 14.43 11.34 13.23 11.44 11.87 12.45 11.56 13.56 11.23 12.34 11.45 13.23 12.45 13.56 13.65 12.33 13.45 11.45 12.33 4.32 12.77 14.11 13.21 11.45 12.45 13.33 371.59 12.3863333333 1.2386333333 13.6249666667
4 Unlock the car 1.01 0.97 1.32 0.99 1.29 1.11 1.23 1.43 0.89 1.22 1.98 1.002 1.04 1.43 1.36 1.58 1.45 1.76 1.34 1.45 1.04 1.34 1.54 1.04 1.33 1.4 1.43 1.73 1.93 0.99 39.622 1.3207333333 0.1320733333 1.4528066667
5 Open the hood of the car 3.06 2.09 2.31 2.93 2.98 2.34 3.1 2.43 2.68 3.04 2.43 3.15 2.15 2.19 2.68 2.45 3.02 2.9 2.1 2.7 2.56 2.18 2.34 2.15 3.21 3.11 2.01 2.34 3.11 2.19 77.93 2.5976666667 0.2597666667 2.8574333333
6 Replace the battery 40.86 48.91 47.01 48.01 41.09 44.43 44.19 45.32 46.32 45.32 44.37 48.32 48.33 45.33 44.32 44.57 44.39 44.34 48.32 46.43 46.32 45.34 47.43 49.2 44.32 47.43 49.32 44.32 44.54 47.32 1375.72 45.8573333333 4.5857333333 50.4430666667
7 Reconnect the positve terminal 34.98 40.12 41.2 32.12 34.54 36.43 37.43 33.45 40.32 40.23 38.23 38.11 37.91 36.54 38.11 39.1 40.21 40.22 39.32 38.87 35.76 36.43 36.43 38.21 40.34 40.21 39.43 40.11 38.21 39.07 1141.64 38.0546666667 3.8054666667 41.8601333333
8 Reconnect the negative terminal 34.99 40.12 41.3 32.13 38.1 38.43 34.55 35.66 40.21 39.65 38.43 39.32 38.11 39.21 35.54 37.33 39.32 41.32 40.23 39.43 38.33 38.43 38.33 34.56 38.93 39.43 40.32 41.33 35.43 33.47 1141.94 38.0646666667 3.8064666667 41.8711333333
9 Apply the battery lithium grease 45.09 44.9 46.1 44.23 45.43 44.32 46.32 44.32 47.43 47.54 43.45 44.36 45.33 46.43 47.43 44.43 45.54 46.84 46.54 45.34 44.54 48.43 47.32 44.55 46.73 46.48 45.22 47.43 46.43 46.32 1374.82 45.8273333333 4.5827333333 50.4100666667
10 Close the hood 3.04 2.01 1.02 2.11 2.43 1.49 2.34 1.99 3.01 3.04 2.29 2.97 2.78 2.98 3.01 2.99 2.59 3.02 2.43 2.55 2.98 2.48 2.96 2.85 2.57 2.97 3.03 3.04 2.89 2.77 78.63 2.621 0.2621 2.8831
total normal time 227.6142733333
standard time = normal time+5% allowances
227.6642733333
normal time=ave+0.10(ave)