Northwest Bakery produces seven types of loaf bread and dist

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	224

Solution

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