Reference no: EM13962714
|
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?
|
Total cost for each aggregate plan using these unit costs
: Calculate the total cost for each aggregate plan using these unit costs. Regular cost per unit = $40. Overtime cost per unit = $50. Subcontract cost per unit = $10. Carrying cost per unit per month = $10 and is assessed on average inventory. We have ..
|
|
Define appropriate decision variables
: The Sweet Smell Fertilizer Company markets bags of manure labeled "not less than 60 lb dry weight." The packaged manure is a combination of compost and sewage wastes. Define appropriate decision variables. Define the objective function. List the func..
|
|
How long does it take for em waves to pass through the axon
: How many cycles of EM waves occur during the above passage, using 1.50 x 10 to the 23rd power Hz.
|
|
Examine how they track the various products
: Contact a waste management company. Examine how they track the various products that they pick up from corporate customers, not just individual or home customers. Examine why that company for that region or location or some group of customers does no..
|
|
Which bread type has the highest average demand
: Which bread type has the highest average demand? Develop a fequency distribution for each bread type. Develop a histogram for each bread type. Which bread type has the highest standard deviation in demand?
|
|
Minimize the total busing miles traveled
: The school board wants to determine the number of students to bus from each district to each school to minimize the total busing miles traveled:
|
|
Prepare a report showing gelato supremo revenue
: Prepare a report showing Gelato Supremo revenue and spending variances for July.
|
|
Use the graphical goal programming procedure
: The RMC Corporation blends three raw materials to produce two products: a fuel additive and a solvent base. Each ton of fuel additive is a mixture of 2/5 ton of material 1 and 3/5 ton of material 3. Treating the amounts of each material available as..
|
|
Quantitative forecasting methods-qualitative forecasting
: Briefly describe how simulation could be used to assist decision makers in regards to new product development? Give an example of how Decision analysis could be used to determine an optimal strategy? Briefly describe several decision alternatives a ..
|