Operations Management for Production and Service - Case Study

profileeesenli
Casestudy1.xlsx
Home>Engineering homework help>Operations Management for Production and Service - Case Study

Sheet1

RANGE RANGE RANGE
TIME AVERAGE WEIGHT (POUNDS) SMALLEST LARGEST TIME AVERAGE WEIGHT (POUNDS) SMALLEST LARGEST TIME AVERAGE WEIGHT (POUNDS) SMALLEST LARGEST
Monday Day Shift Tuesday Day Shift Wednesday Day Shift
6:00 am 49.6 48.7 50.7 6:00 am 48.6 47.4 52.0 6:00 am 48.4 45.0 49.0
7:00 50.2 49.1 51.2 7:00 50.0 49.2 52.2 7:00 48.8 44.8 49.7
8:00 50.6 49.6 51.4 8:00 49.8 49.0 52.4 8:00 49.6 48.0 51.8
9:00 50.8 50.2 51.8 9:00 50.3 49.4 51.7 9:00 50.0 48.1 52.7
10:00 49.9 49.2 52.3 10:00 50.2 49.6 51.8 10:00 51.0 48.1 55.2
11:00 50.3 48.6 51.7 11:00 50.0 49.0 52.3 11:00 50.4 49.5 54.1
12:00 pm 48.6 46.2 50.4 12:00 pm 50.0 48.8 52.4 12:00 pm 50.0 48.7 50.9
1:00 49.0 46.4 50.0 1:00 50.1 49.4 53.6 1:00 48.9 47.6 51.2
Evening shift Evening shift Evening shift
2:00 pm 49.0 46.0 50.6 2:00 pm 49.7 48.6 51.0 2:00 pm 49.8 48.4 51.0
3:00 49.8 48.2 50.8 3:00 48.4 47.2 51.7 3:00 49.8 48.8 50.8
4:00 50.3 49.2 52.7 4:00 47.2 45.3 50.9 4:00 50.0 49.1 50.6
5:00 51.4 50.0 55.3 5:00 46.8 44.1 49.0 5:00 47.8 45.2 51.2
6:00 51.6 49.2 54.7 6:00 46.8 41.0 51.2 6:00 46.4 44.0 49.7
7:00 51.8 50.0 55.6 7:00 50.0 46.2 51.7 7:00 46.4 44.4 50.0
8:00 51.0 48.6 53.2 8:00 47.4 44.0 48.7 8:00 47.2 46.6 48.9
9:00 50.5 49.4 52.4 9:00 47.0 44.2 48.9 9:00 48.4 47.2 49.5
Night shift Night shift Night shift
10:00 pm 49.2 46.1 50.7 10:00 pm 47.2 46.6 50.2 10:00 pm 49.2 48.1 50.7
11:00 49.0 46.3 50.8 11:00 48.6 47.0 50.0 11:00 48.4 47.0 50.8
12:00 am 48.4 45.4 50.2 12:00 am 49.8 48.2 50.4 12:00 am 47.2 46.4 49.2
1:00 47.6 44.3 49.7 1:00 49.6 48.4 51.7 1:00 47.4 46.8 49.0
2:00 47.4 44.1 49.6 2:00 50.0 49.0 52.2 2:00 48.8 47.2 51.4
3:00 48.2 45.2 49.0 3:00 50.0 49.2 50.0 3:00 49.6 49.0 50.6
4:00 48.0 45.5 49.1 4:00 47.2 46.3 50.5 4:00 51.0 50.5 51.5
5:00 48.4 47.1 49.6 5:00 47.0 44.1 49.7 5:00 50.5 50.0 51.9

Sheet2

Sheet3