0% found this document useful (0 votes)
23 views9 pages

New Laundry Productivity Sheet

The document contains a detailed log of hamper processing data over a period of time, including daily totals, crew hours, and productivity metrics for each shift. It highlights the number of hampers processed, crew quantities, and productivity rates, with some days showing zero activity. The average productivity and other key metrics are also summarized at the end of the document.

Uploaded by

ingelias007
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
23 views9 pages

New Laundry Productivity Sheet

The document contains a detailed log of hamper processing data over a period of time, including daily totals, crew hours, and productivity metrics for each shift. It highlights the number of hampers processed, crew quantities, and productivity rates, with some days showing zero activity. The average productivity and other key metrics are also summarized at the end of the document.

Uploaded by

ingelias007
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Hamper per

Hours Total Man Hampers


Beginning of Crew Qty hour
processing Hours processed
the day productivity
Day Hampers
1st Shift
1-Feb 120 5.5 0 15 0.00
2-Feb 0 0.00
3-Feb 0.00
4-Feb 85 5.5 24 0.00
5-Feb 61 5.5 25 0.00
6-Feb 36 5.1 10 0.00
7-Feb 26 5.5 13
8-Feb 13 4.5 14
9-Feb 1 4 11
10-Feb
11-Feb 5.5 10.2 56.1 11 0.20
12-Feb 5 10.2 51 11 0.22
13-Feb 6 12 72 22 0.31
14-Feb 5 12 60 9 0.15
15-Feb 116 6 12 72 23 0.32
16-Feb 93 6.5 8 52 11 0.21
17-Feb 82 5.5 7 38.5 17 0.44

18-Feb 86 6 12 72 15 0.21
19-Feb 92 6.5 13.8 89.7 27 0.30
20-Feb 71 6.5 10.4 67.6 30 0.44
21-Feb 69 6.5 7.1 46.15 20 0.43
22-Feb 80 6.5 8 52 18 0.35
23-Feb
24-Feb
25-Feb 105 5.5 8.18 44.99 16 0.36
26-Feb 87 7 8.34 58.38 17 0.29
27-Feb 85 6.5 9.6 62.4 21 0.34
28-Feb 79 7 8.1 56.7 19 0.34
Average 73 5.7869565217 9.8075 52.86222 17.3478261 0.22231701
Hamper per
Hours Total Man Hampers hour Hours Total Man Hampers
processing Crew Qty Hours processed productivity processing Crew Qty Hours processed
2nd Shift 3rd Shift
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0

0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
#DIV/0! #DIV/0! 0 #DIV/0! 0 #DIV/0! #DIV/0! 0 #DIV/0!
Hamper per Daily Daily total Daily Hamper End of
hour hours Daily Crew Daily man hampers per hour Day
productivity total Qty. total hour total processed productivity Hampers
Total
0.00 5.5 0 0 15 ERROR 105
0.00 0 0 0 0 ERROR
0.00 0 0 0 0 ERROR
0.00 5.5 0 0 24 ERROR
0.00 5.5 0 0 25 ERROR
0.00 5.1 0 0 10 ERROR
0.00 5.5 0 0 13 ERROR
0.00 4.5 0 0 14 ERROR
0.00 4 0 0 11 ERROR
0.00 0 0 0 0 ERROR
0.00 5.5 10.2 56.1 11 0.20
0.00 5 10.2 51 11 0.22
0.00 6 12 72 22 0.31
0.00 5 12 60 9 0.15
0.00 6 12 72 23 0.32
0.00 6.5 8 52 11 0.21
0.00 5.5 7 38.5 17 0.44

0.00 6 12 72 15 0.21
0.00 6.5 13.8 89.7 27 0.30
0.00 6.5 10.4 67.6 30 0.44
0.00 6.5 7.1 46.15 20 0.43
0.00 6.5 8 52 18 0.35
0.00 0 0 0 0 ERROR
0.00 0 0 0 0 ERROR
0.00 5.5 8.18 44.99 16 0.36
0.00 7 8.34 58.38 17 0.29
0.00 6.5 9.6 62.4 21 0.34
0.00 7 8.1 56.7 19 0.34
0 4.753571 5.60428571 33.9828571 14.25 0.3056858891 105
Hamper per
Hours Total Man Hampers
Beginning of Crew Qty hour
processing Hours processed
the day productivity
Day Hampers
1st Shift
1-Mar 69 6.5 7.97 51.805 17 0.33
2-Mar 0
3-Mar 0
4-Mar 92 5 7.7 38.5 12 0.31
5-Mar 80 6.5 7.5 48.75 16 0.33
6-Mar 68 6.5 8.2 53.3 17 0.32
7-Mar 73 6.5 10.5 68.25 25 0.37
8-Mar 62 6.5 9.1 59.15 20 0.34
9-Mar 0
10-Mar 0
11-Mar 80 6 11 66 25 0.38
12-Mar 59 6.5 11.2 72.8 23 0.32
13-Mar 41 6.5 10 65 24 0.37
14-Mar 40 6 8.8 52.8 24 0.45
15-Mar 32 6.5 8.2 53.3 24 0.45
16-Mar 0 0.00
17-Mar 0 0.00
18-Mar 45 6 9.4 56.4 23 0.41
19-Mar 30 6.5 11.3 73.45 25 0.34
20-Mar 26 6.5 7.1 46.15 21 0.46
21-Mar 21 6.5 6.8 44.2 21 0.48
22-Mar 17 6.5 5.9 38.35 18 0.47
23-Mar 0
24-Mar 0
25-Mar 27 6.5 6.7 43.55 23 0.53
26-Mar 29 6.5 7.5 48.75 22 0.45
27-Mar 22 6.5 7.5 48.75 18 0.37
28-Mar 7 6.5 5 32.5 11 0.34
29-Mar 7 6.5 6 39 14 0.36
30-Mar 0
31-Mar 0
Average 44.14285714 6.3571428571 8.2557143 35.508226 20.1428571 0.354519927
Hamper per
Hours Total Man Hampers hour Hours Total Man Hampers
processing Crew Qty Hours processed productivity processing Crew Qty Hours processed
2nd Shift 3rd Shift
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0
0 0.00 0

0 0.00 0

0 0.00 0
#DIV/0! #DIV/0! 0 #DIV/0! 0 #DIV/0! #DIV/0! 0 #DIV/0!
Hamper per Daily Daily total Daily Hamper End of
hour hours Daily Crew Daily man hampers per hour Day
productivity total Qty. total hour total processed productivity Hampers
Total
0.00 6.5 7.97 51.805 17 0.33 105
0.00 0 0 0 0 ERROR
0.00 0 0 0 0 ERROR
0.00 5 7.7 38.5 12 0.31
0.00 6.5 7.5 48.75 16 0.33
0.00 6.5 8.2 53.3 17 0.32
0.00 6.5 10.5 68.25 25 0.37
0.00 6.5 9.1 59.15 20 0.34
0.00 0 0 0 0 ERROR
0.00 0 0 0 0 ERROR
0.00 6 11 66 25 0.38
0.00 6.5 11.2 72.8 23 0.32
0.00 6.5 10 65 24 0.37
0.00 6 8.8 52.8 24 0.45
0.00 6.5 8.2 53.3 24 0.45
0.00 0 0 0 0 ERROR
0.00 0 0 0 0 ERROR
0.00 6 9.4 56.4 23 0.41
0.00 6.5 11.3 73.45 25 0.34
0.00 6.5 7.1 46.15 21 0.46
0.00 6.5 6.8 44.2 21 0.48
0.00 6.5 5.9 38.35 18 0.47
0.00 0 0 0 0 ERROR
0.00 0 0 0 0 ERROR
0.00 6.5 6.7 43.55 23 0.53
0.00 6.5 7.5 48.75 22 0.45
0.00 6.5 7.5 48.75 18 0.37

0.00 6.5 6 39 14 0.36

0.00 0 0 0 0 ERROR
0 4.3793103 5.80586207 36.8363793 14.206897 0.3907748392 105
Hamper per
Hours Total Man Hampers
Beginning of Crew Qty hour Hamper per Hamper per Daily Daily total Daily Hamper End of
processing Hours processed
the day productivity Hours Total Man Hampers hour Hours Total Man Hampers hour hours Daily Crew Daily man hampers per hour Day
Day Hampers processing Crew Qty Hours processed productivity processing Crew Qty Hours processed productivity total Qty. total hour total processed productivity Hampers
1st Shift 2nd Shift 3rd Shift Total
1-Apr 25 6 6.5 39 19 0.49 0 0.00 0 0.00 6 6.5 39 19 0.49 105
2-Apr 22 6.5 4.1 26.65 13 0.49 0 0.00 0 0.00 6.5 4.1 26.65 13 0.49
3-Apr 40 5.2 5.4 28.08 14 0.50 0 0.00 0 0.00 5.2 5.4 28.08 14 0.50
4-Apr 28 6.5 5.5 35.75 14 0.39 0 0.00 0 0.00 6.5 5.5 35.75 14 0.39
5-Apr 30 5.5 5.5 30.25 8 0.26 0 0.00 0 0.00 5.5 5.5 30.25 8 0.26
6-Apr 0 0 0.00 0 0.00 0 0 0 0 ERROR
7-Apr 0 0 0.00 0 0.00 0 0 0 0 ERROR
8-Apr 61 6 7.3 43.8 24 0.55 0 0.00 0 0.00 6 7.3 43.8 24 0.55
9-Apr 49 6 8.2 49.2 24 0.49 0 0.00 0 0.00 6 8.2 49.2 24 0.49
10-Apr 81 6 8.7 52.2 25 0.48 0 0.00 0 0.00 6 8.7 52.2 25 0.48
11-Apr 61 6 8.6 51.6 24 0.47 0 0.00 0 0.00 6 8.6 51.6 24 0.47
12-Apr 148 5.5 9.6 52.8 24 0.45 0 0.00 0 0.00 5.5 9.6 52.8 24 0.45
13-Apr 126 7 6 42 15 0.36 0 0.00 0 0.00 7 6 42 15 0.36
14-Apr 109 7 6 42 18 0.43 0 0.00 0 0.00 7 6 42 18 0.43
15-Apr 131 5.5 8.5 46.75 24 0.51 0 0.00 0 0.00 5.5 8.5 46.75 24 0.51
16-Apr 108 6 10.5 63 25 0.40 0 0.00 0 0.00 6 10.5 63 25 0.40
17-Apr 94 6 10.7 64.2 29 0.45 0 0.00 0 0.00 6 10.7 64.2 29 0.45
18-Apr 92 6 9.7 58.2 25 0.43 0 0.00 0 0.00 6 9.7 58.2 25 0.43
19-Apr 79 6 8.5 51 21 0.41 0 0.00 0 0.00 6 8.5 51 21 0.41
20-Apr 58 7 6 42 15 0.36 0 0.00 0 0.00 7 6 42 15 0.36
21-Apr 0 0 0.00 0 0.00 0 0 0 0 ERROR
22-Apr 120 6.5 7.5 48.75 20 0.41 7 7 49 23 0.47 0 0.00 13.5 14.5 97.75 43 0.44
23-Apr 88 6.5 7.7 50.05 25 0.50 7 8 56 18 0.32 0 0.00 13.5 15.7 106.05 43 0.41
24-Apr 60 6.5 8.7 56.55 24 0.42 7 8 56 24 0.43 0 0.00 13.5 16.7 112.55 48 0.43
25-Apr 32 6.5 10.5 68.25 27 0.40 0 0.00 0 0.00 6.5 10.5 68.25 27 0.40
26-Apr 18 6.5 8.5 55.25 22 0.40 0 0.00 0 0.00 6.5 8.5 55.25 22 0.40
27-Apr 20 7 2 14 9 0.64 0 0.00 0 0.00 7 2 14 9 0.64
28-Apr 0
29-Apr 40 6 7.5 45 17 0.38 7 4 28 10 0.36 0 0.00 13 11.5 73 27 0.37
30-Apr 37 6.5 7.5 48.75 21 0.43 7 8 56 23 0.41
0 0.00 0 0.00 0 0.00 0 0 0 0 ERROR
Average 67.576923077 6.2192307692 7.5076923 38.873548 20.2307692 0.425533765 7 7 8.1666667 19.6 0.066241497 #DIV/0! #DIV/0! 0 #DIV/0! 0 6.3172414 7.40344828 46.3906897 20 0.4395364604 105
Hamper per
Hours Total Man Hampers
Beginning of Crew Qty hour Hamper per Hamper per Daily Daily total Daily Hamper End of
processing Hours processed
the day productivity Hours Total Man Hampers hour Hours Total Man Hampers hour hours Daily Crew Daily man hampers per hour Day
Day Hampers processing Crew Qty Hours processed productivity processing Crew Qty Hours processed productivity total Qty. total hour total processed productivity Hampers
1st Shift 2nd Shift 3rd Shift Total
1-May 14 6.5 8.5 55.25 23 0.42 7 8 56 33 0.59 0 0.00 13.5 16.5 111.25 56 0.50 105
2-May 20 6 8.5 51 20 0.39 7 8 56 10 0.18 0 0.00 13 16.5 107 30 0.28
3-May 21 5.5 7.8 42.9 19 0.44 7 7 49 20 0.41 0 0.00 12.5 14.8 91.9 39 0.42
4-May 15 7 6 42 17 0.40 0 0.00 0 0.00 7 6 42 17 0.40
5-May 8 7 5 35 15 0.43 0 0.00 0 0.00 7 5 35 15 0.43
6-May 45 6 7 42 18 0.43 7 8 56 16 0.29 0 0.00 13 15 98 34 0.35
7-May 23 6.5 7.5 48.75 23 0.47 7 8 56 16 0.29 0 0.00 13.5 15.5 104.75 39 0.37
8-May 25 5 7.5 37.5 13 0.35 7 4 28 13 0.46 0 0.00 12 11.5 65.5 26 0.40
9-May 21 6 7.5 45 14 0.31 7 4 28 15 0.54 0 0.00 13 11.5 73 29 0.40
10-May 20 6 7.5 45 11 0.24 7 4 28 6 0.21 0 0.00 13 11.5 73 17 0.23
11-May 15 7 5 35 10 0.29 0 0.00 0 0.00 7 5 35 10 0.29
12-May 14 7 4 28 5 0.18 0 0.00 0 0.00 7 4 28 5 0.18
13-May 18 6.5 7 45.5 12 0.26 7 5 35 16 0.46 0 0.00 13.5 12 80.5 28 0.35
14-May 45 6 8.5 51 18 0.35 7 6 42 15 0.36 0 0.00 13 14.5 93 33 0.35
15-May 50 6 8.3 49.8 20 0.40 7 7 49 5 0.10 0 0.00 13 15.3 98.8 25 0.25
16-May 75 6 9 54 11 0.20 7 8 56 20 0.36 0 0.00 13 17 110 31 0.28
17-May 140 6 8.3 49.8 15 0.30 7 8 56 20 0.36 0 0.00 13 16.3 105.8 35 0.33
18-May 165 7 7 49 12 0.24 0 0.00 0 0.00 7 7 49 12 0.24
19-May 195 7 7 49 10 0.20 0 0.00 0 0.00 7 7 49 10 0.20
20-May 185 6 8.5 51 24 0.47 7 8 56 26 0.46 0 0.00 13 16.5 107 50 0.47
21-May 160 6 7.9 47.4 20 0.42 7 8 56 24 0.43 0 0.00 13 15.9 103.4 44 0.43
22-May 151 6 8.5 51 19 0.37 7 9 63 23 0.37 0 0.00 13 17.5 114 42 0.37
23-May 128 6 8.5 51 31 0.61 7 9 63 28 0.44 0 0.00 13 17.5 114 59 0.52
24-May 71 6 7.5 45 18 0.40 7 9 63 19 0.30 0 0.00 13 16.5 108 37 0.34
25-May 0 0.00 0 0.00 0 0.00 0 0 0 0 ERROR
26-May 0 0.00 0 0.00 0 0.00 0 0 0 0 ERROR
27-May 0 0.00 0 0.00 0 0.00 0 0 0 0 ERROR
28-May 120 6 8.5 51 25 0.49 7 8 56 23 0.41
29-May 82 6 8.5 51 23 0.45 7 8 56 21 0.38 0 0.00 13 16.5 107 44 0.41
30-May 61 6 8.5 51 24 0.47 7 9 63 13 0.21
31-May 66 6 7.2 43.2 15 0.35 7 8 56 14 0.25 0 0.00 13 15.2 99.2 29 0.29
Average 69.75 6.2142857143 7.5178571 41.841935 17.3214286 0.33405241 7 7.318182 36.354839 18 0.252850925 #DIV/0! #DIV/0! 0 #DIV/0! 0 10.413793 11.637931 75.9689655 27.4482759 0.3497815389 105
Hamper per
Hours Total Man Hampers
Beginning of Crew Qty hour Hamper per Hamper per Daily Daily total Daily Hamper End of
processing Hours processed
the day productivity Hours Total Man Hampers hour Hours Total Man Hampers hour hours Daily Crew Daily man hampers per hour Day
Day Hampers processing Crew Qty Hours processed productivity processing Crew Qty Hours processed productivity total Qty. total hour total processed productivity Hampers
1st Shift 2nd Shift 3rd Shift Total
3-Jun 61 6 8.5 51 21 0.41 8 6 48 19 0.40 0 0.00 14 14.5 99 40 0.40 105
4-Jun 58 6 7 42 21 0.50 8 6 48 18 0.38 0 0.00 14 13 90 39 0.43
5-Jun 48 6 6.8 40.8 18 0.44 8 6 48 22 0.46 0 0.00 14 12.8 88.8 40 0.45
6-Jun 43 6 7.3 43.8 19 0.43 8 6 48 18 0.38 0 0.00 14 13.3 91.8 37 0.40
7-Jun 30 6 7.3 43.8 18 0.41 8 6 48 21 0.44 0 0.00 14 13.3 91.8 39 0.42
8-Jun 0 0.00 0 0.00 0 0.00 0 0 0 0 ERROR
9-Jun 0 0.00 0 0.00 0 0.00 0 0 0 0 ERROR
10-Jun 32 6 8 48 19 0.40 8 6 48 18 0.38 0 0.00 14 14 96 37 0.39
11-Jun 52 6.5 8 52 21 0.40 8 6 48 18 0.38 0 0.00 14.5 14 100 39 0.39
12-Jun 54 6 8.5 51 21 0.41 8 6 48 23 0.48 0 0.00 14 14.5 99 44 0.44
13-Jun 49 6 8.5 51 25 0.49 8 6 48 24 0.50 0 0.00 14 14.5 99 49 0.49
14-Jun 41 6 8.5 51 21 0.41 8 6 48 17 0.35 0 0.00 14 14.5 99 38 0.38
15-Jun 0 0.00 0 0.00 0 0.00 0 0 0 0 ERROR
16-Jun 0 0.00 0 0.00 0 0.00 0 0 0 0 ERROR
17-Jun 44 6.5 11.5 74.75 27 0.36 0 0.00 0 0.00 6.5 11.5 74.75 27 0.36
18-Jun 27 6.5 11.5 74.75 32 0.43 0 0.00 0 0.00 6.5 11.5 74.75 32 0.43
19-Jun 31 6.5 9.5 61.75 20 0.32 0 0.00 0 0.00 6.5 9.5 61.75 20 0.32
20-Jun 30 6.5 10.5 68.25 14 0.21 0 0.00 0 0.00 6.5 10.5 68.25 14 0.21
21-Jun 40 6.5 9.5 61.75 25 0.40 0 0.00 0 0.00 6.5 9.5 61.75 25 0.40
22-Jun 0 0.00 0 0.00 0 0.00 0 0 0 0 ERROR
23-Jun 0 0.00 0 0.00 0 0.00 0 0 0 0 ERROR
24-Jun 49 6.5 7 45.5 18 0.40 0 0.00 0 0.00 6.5 7 45.5 18 0.40
25-Jun 47 6.5 7 45.5 14 0.31 0 0.00 0 0.00 6.5 7 45.5 14 0.31
26-Jun 31 6.5 9 58.5 28 0.48 0 0.00 0 0.00 6.5 9 58.5 28 0.48
27-Jun 38 0 0.00 0 0.00 0 0.00 0 0 0 0 ERROR
28-Jun 0 0.00 0 0.00 0 0.00 0 0 0 0 ERROR
29-Jun 0 0.00 0 0.00 0 0.00 0 0 0 0 ERROR
30-Jun 0 0.00 0 0.00
0 0.00 0 0.00 0 0.00 0 0 0 0 ERROR
0 0.00 0 0.00
0 0.00 0 0.00 0 0.00 0 0 0 0 ERROR
Average 42.368421053 6.25 8.55 31.133871 21.2222222 0.232780484 8 6 15.483871 19.8 0.133064516 #DIV/0! #DIV/0! 0 #DIV/0! 0 6.637931 7.37586207 49.8327586 20 0.3955255485 105

You might also like