Northwest Bakery produces seven types of loaf bread and distributes the bread to
ID: 3440675 • Letter: N
Question
Northwest Bakery produces seven types of loaf bread and distributes the bread to local grocery stores each day of the week. Juanita Gomez is the marketing manager for Northwest Bakery and she is trying to figure out how to improve sales. She may want to discontinue some types of bread or add new types. She asked the production department to record the production levels of the seven types of bread and Bob McGeorge, the production manager, put these data in a file named Northwest Bakery. The file is attached.
Juanita has just asked you, who has just been hired in the marketing department, to do some analysis on the data. She would like:
1. (5 pts) A chart showing percentages of each type of bread produced.
2. (7 pts) A table showing the average amount of each type of bread produced per day and the variability of the production of each type of bread.
3. (8 pts) She also mentioned that Bob would like to see a chart of average daily production so he can better manage workloads of the production staff.
4. Produce the appropriate charts, graphs and tables in Excel
5. (5 pts) Compile a brief report in a Word document explaining what you did and include the charts, graphs and/or tables in the document.
Day of Week White Wheat Multigrain Dark Rye Cinnamon Raisin Sour Dough Light Oat Sunday 496 490 403 251 114 108 228 Monday 786 611 570 373 165 148 304 Tuesday 547 474 424 265 144 104 256 Wednesday 513 443 380 312 100 92 180 Thursday 817 669 622 375 181 152 308 Friday 375 390 299 206 124 88 172 Saturday 700 678 564 366 173 136 248 Sunday 597 502 457 276 140 144 312 Monday 536 530 428 261 135 112 356 Tuesday 675 703 605 289 201 188 356 Wednesday 421 433 336 212 100 104 224 Thursday 867 576 541 298 152 144 304 Friday 506 461 406 254 135 116 264 Saturday 470 352 377 208 84 92 172 Sunday 748 643 599 341 153 148 316 Monday 376 367 310 199 128 104 208 Tuesday 632 646 586 340 174 160 264 Wednesday 591 504 408 238 140 120 276 Thursday 656 497 415 221 107 120 212 Friday 817 673 644 249 200 180 348 Saturday 653 571 557 316 129 140 224Explanation / Answer
Day of Week
White
Wheat
Multigrain
Dark Rye
Cinnamon Raisin
Sour Dough
Light Oat
Sunday
496
490
403
251
114
108
228
Monday
786
611
570
373
165
148
304
Tuesday
547
474
424
265
144
104
256
Wednesday
513
443
380
312
100
92
180
Thursday
817
669
622
375
181
152
308
Friday
375
390
299
206
124
88
172
Saturday
700
678
564
366
173
136
248
Sunday
597
502
457
276
140
144
312
Monday
536
530
428
261
135
112
356
Tuesday
675
703
605
289
201
188
356
Wednesday
421
433
336
212
100
104
224
Thursday
867
576
541
298
152
144
304
Friday
506
461
406
254
135
116
264
Saturday
470
352
377
208
84
92
172
Sunday
748
643
599
341
153
148
316
Monday
376
367
310
199
128
104
208
Tuesday
632
646
586
340
174
160
264
Wednesday
591
504
408
238
140
120
276
Thursday
656
497
415
221
107
120
212
Friday
817
673
644
249
200
180
348
Saturday
653
571
557
316
129
140
224
Total
12779
11213
9931
5850
2979
2700
5532
Percentage
25.06
21.99
19.48
11.5
5.84
5.3
10.9
Day of Week
White
Wheat
Multigrain
Dark Rye
Cinnamon Raisin
Sour Dough
Light Oat
Average
Sunday
496
490
403
251
114
108
228
298.57
Monday
786
611
570
373
165
148
304
422.43
Tuesday
547
474
424
265
144
104
256
316.29
Wednesday
513
443
380
312
100
92
180
288.57
Thursday
817
669
622
375
181
152
308
446.29
Friday
375
390
299
206
124
88
172
236.29
Saturday
700
678
564
366
173
136
248
409.29
Sunday
597
502
457
276
140
144
312
346.86
Monday
536
530
428
261
135
112
356
336.86
Tuesday
675
703
605
289
201
188
356
431.00
Wednesday
421
433
336
212
100
104
224
261.43
Thursday
867
576
541
298
152
144
304
411.71
Friday
506
461
406
254
135
116
264
306.00
Saturday
470
352
377
208
84
92
172
250.71
Sunday
748
643
599
341
153
148
316
421.14
Monday
376
367
310
199
128
104
208
241.71
Tuesday
632
646
586
340
174
160
264
400.29
Wednesday
591
504
408
238
140
120
276
325.29
Thursday
656
497
415
221
107
120
212
318.29
Friday
817
673
644
249
200
180
348
444.43
Saturday
653
571
557
316
129
140
224
370.00
Variability
21349.6619
11736.7476
12100.9905
3262.15714
1040.02857
813.257143
3445.25714
4937.32371
After this i made the column chart for the average daily production, but was not able to upload the char as image is not getting uploaded in the answer space.
Day of Week
White
Wheat
Multigrain
Dark Rye
Cinnamon Raisin
Sour Dough
Light Oat
Sunday
496
490
403
251
114
108
228
Monday
786
611
570
373
165
148
304
Tuesday
547
474
424
265
144
104
256
Wednesday
513
443
380
312
100
92
180
Thursday
817
669
622
375
181
152
308
Friday
375
390
299
206
124
88
172
Saturday
700
678
564
366
173
136
248
Sunday
597
502
457
276
140
144
312
Monday
536
530
428
261
135
112
356
Tuesday
675
703
605
289
201
188
356
Wednesday
421
433
336
212
100
104
224
Thursday
867
576
541
298
152
144
304
Friday
506
461
406
254
135
116
264
Saturday
470
352
377
208
84
92
172
Sunday
748
643
599
341
153
148
316
Monday
376
367
310
199
128
104
208
Tuesday
632
646
586
340
174
160
264
Wednesday
591
504
408
238
140
120
276
Thursday
656
497
415
221
107
120
212
Friday
817
673
644
249
200
180
348
Saturday
653
571
557
316
129
140
224
Total
12779
11213
9931
5850
2979
2700
5532
Percentage
25.06
21.99
19.48
11.5
5.84
5.3
10.9
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.