|
Zepolle's Bakery - Bread Sales to Supermarkets
|
|
|
File: Bakery.xlsx
|
|
Column A
|
Day of the week
|
|
|
1-Sunday
|
|
|
2-Monday
|
|
|
3-Tuesday
|
|
|
4-Wednesday
|
|
|
5-Thursday
|
|
|
6-Friday
|
|
|
7-Saturday
|
|
Column B
|
Quantity of white bread manufactured
|
|
Column C
|
Quantity of wheat bread manufactured
|
|
Column D
|
Quantity of multigrain bread manufactured
|
|
Column E
|
Quantity of black bread manufactured
|
|
Column F
|
Quantity of cinnamon raisin walnut bread manufactured
|
|
Column G
|
Quantity of sour dough french bread manufactured
|
|
Column H
|
Quantity of light oat bread manufactured
|
|
Day of Week
|
White
|
Wheat
|
Multigrain
|
Black
|
Cinnamon Raisin
|
Sour Dough French
|
Light Oat
|
|
5
|
436
|
456
|
417
|
311
|
95
|
96
|
224
|
|
6
|
653
|
571
|
557
|
416
|
129
|
140
|
224
|
|
1
|
496
|
490
|
403
|
351
|
114
|
108
|
228
|
|
2
|
786
|
611
|
570
|
473
|
165
|
148
|
304
|
|
4
|
547
|
474
|
424
|
365
|
144
|
104
|
256
|
|
5
|
513
|
443
|
380
|
317
|
100
|
92
|
180
|
|
6
|
817
|
669
|
622
|
518
|
181
|
152
|
308
|
|
1
|
375
|
390
|
299
|
256
|
124
|
88
|
172
|
|
2
|
700
|
678
|
564
|
463
|
173
|
136
|
248
|
|
4
|
597
|
502
|
457
|
383
|
140
|
144
|
312
|
|
5
|
536
|
530
|
428
|
360
|
135
|
112
|
356
|
|
6
|
875
|
703
|
605
|
549
|
201
|
188
|
356
|
|
1
|
421
|
433
|
336
|
312
|
100
|
104
|
224
|
|
2
|
667
|
576
|
541
|
438
|
152
|
144
|
304
|
|
4
|
506
|
461
|
406
|
342
|
135
|
116
|
264
|
|
5
|
470
|
352
|
377
|
266
|
84
|
92
|
172
|
|
6
|
748
|
643
|
599
|
425
|
153
|
148
|
316
|
|
7
|
376
|
367
|
310
|
279
|
128
|
104
|
208
|
|
1
|
704
|
646
|
586
|
426
|
174
|
160
|
264
|
|
3
|
591
|
504
|
408
|
349
|
140
|
120
|
276
|
|
4
|
564
|
497
|
415
|
348
|
107
|
120
|
212
|
|
5
|
817
|
673
|
644
|
492
|
200
|
180
|
348
|
Zepolle's Bakery makes a variety of bread types that it sells to supermarket chains in the area. One of Zepolle's problems is the number of loaves of each type of bread each day by the chain stores varies considerably, making it difficult to know how many loves to make. A sample file of daily demand data is contained in the file called Bakery.
A) Which bread type has the highest average demand?
B) Develop a fequency distribution for each bread type.
C) Develop a histogram for each bread type
D) Which bread type has the highest standard deviation in demand?
E) Which bread type has the greatest relative variability, and which has the lowest?
F) Assuming that these sample data are representative of demand during the year, determine how many loves of each type of bread should be made so that demand would be met on at least 75% of the days during the year?
G) Create a new variable called "Total Loaves Sold" On which day of the week is the average for total loaves sold the highest?