Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Japolli Bakery makes a variety of bread types that it sells to supermarket chains in the area. One of the problems is that the number

Japolli Bakery makes a variety of bread types that it sells to supermarket chains in the area. One of the problems is that the number of loaves of each type of bread sold each day by the chain stores varies considerably, making it difficult to know how many loaves to bake. A sample of daily demand data is contained in the file,Japolli Bakery.

  1. Develop a frequency distribution for each bread type using& appropriate intervals.
  2. Select which bread type has the greatest and lowest relative variability.
  3. Assuming that these sample data are representative of demand during the year, determine how many loaves of each type of bread should be made such that demand would be met on at least 75% of the days during the year.

Japolli Bakery File

image text in transcribed
A25 X ( fx A C D E F G H 1 Day of Week White Wheat Multigrain Black Cinnamon R Sour Dough I Light Oat 2 Friday 436 456 417 311 95 96 224 3 Saturday 653 571 557 416 129 140 224 4 Sunday 496 490 403 351 114 108 228 5 Monday 786 611 570 473 165 148 304 6 Tuesday 547 474 424 365 144 104 256 7 Wednesday 513 443 380 317 100 92 180 B Thursday 817 669 622 518 181 152 308 9 Friday 375 390 299 256 124 88 172 10 Saturday 700 678 564 463 173 136 248 11 Sunday 597 502 457 383 140 144 312 12 Monday 536 530 478 360 135 112 356 13 Tuesday 875 703 605 549 201 188 356 14 Wednesday 421 433 336 312 100 104 224 15 Thursday 667 576 541 438 152 144 304 16 Friday 506 461 406 342 135 116 264 17 Saturday 470 352 377 266 84 92 172 18 Sunday 748 643 599 425 153 148 316 19 Monday 376 367 310 279 128 104 208 20 Tuesday 704 646 586 426 174 160 264 21 Wednesday 591 504 408 349 140 120 276 22 Thursday 564 497 415 348 107 120 212 23 Friday 817 673 644 492 200 180 348 24

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Statistics Using Excel

Authors: Glyn Davis, Branko Pecar

2nd Edition

0199659516, 9780199659517

Students also viewed these Mathematics questions