1. What is the problem at Poisson's?
2. What is (are) the causes of the problem(s)?
3. What do the data suggest about which of the possible causes are the most likely to be responsible for the problem?
A word to the wise: you will need to use the data in the spreadsheet if you hope to say anything intelligent about the case.
Data 2 Price charged 15.00 3 Cost 6.00 Amount ordered 420 5 6 Results Average Daily Wastage 43.80 8 Average Daily Profit $ 3,123.00 9 10 Day Sales Wastage Profit 11 380 40 $ 3, 180.00 12 394 26 $ 3,390.00 W N - 13 388 32 $ 3,300.00 14 4 288 132 $ 1,800.00 15 5 420 0 $ 3,780.00 16 6 376 44 $ 3,120.00 17 420 0 $ 3,780.00 18 178 242 $ 150.00 19 9 261 159 $ 1,395.00 20 10 411 9 $ 3,645.00 21 11 296 124 $ 1,920.00 22 12 420 0 $ 3,780.00 23 13 420 0 $ 3,780.00 14 333 87 $ 2,475.00 15 342 78 $ 2,610.00 16 420 0 $ 3,780.00 17 420 0 $ 3,780.00 18 420 0 $ 3,780.00 29 19 258 162 $ 1,350.00 30 20 367 53 $ 2,985.00 31 21 363 57 $ 2,925.00 32 22 419 1 $ 3,765.00 33 23 420 0 $ 3,780.00 34 24 420 0 $ 3,780.00 35 25 420 0 $ 3,780.00 36 26 420 0 $ 3,780.00 37 27 420 0 $ 3,780.00 38 28 420 0 $ 3,780.00 39 29 330 90 $ 2,430.00 40 30 420 0 $ 3,780.00 41 31 420 0 $ 3,780.00 42 32 409 11 $ 3,615.00 43 33 407 13 $ 3,585.00 44 34 411 9 $ 3,645.00 45 35 254 166 $ 1,290.00 46 36 420 0 $ 3,780.00 47 37 391 29 $ 3,345.00 48 38 328 92 $ 2,400.00 49 39 420 0 $ 3,780.00 50 40 330 90 $ 2,430.00 51 41 420 0 $ 3,780.00 52 42 391 29 $ 3,345.00 53 43 347 73 $ 2,685.00 54 44 388 32 $ 3,300.00 55 45 311 109 $ 2,145.00 56 46 420 0 $ 3,780.00 57 47 420 0 $ 3,780.00 58 48 399 21 $ 3,465.00 59 49 420 0 $ 3 780 00 Low-waste Restaurant High-waste RestaurantA B E Data 2 Price charged 15.00 3 Cost 6.00 4 Amount ordered 400 6 Results Average Daily Wastage 14.82 8 Average Daily Profit $ 3,377.67 9 10 Day Sales Wastage Profit 11 400 0 $ 3,600.00 12 W N - 400 0 $ 3,600.00 13 364 36 $ 3,060.00 14 4 348 52 $ 2,820.00 15 400 0 $ 3,600.00 16 400 0 $ 3,600.00 17 7 400 0 $ 3,600.00 18 8 400 0 $ 3,600.00 19 9 400 0 $ 3,600.00 20 10 362 38 $ 3,030.00 21 11 400 0 $ 3,600.00 22 12 394 6 $ 3,510.00 23 13 330 70 $ 2,550.00 24 14 400 0 $ 3,600.00 25 15 326 74 $ 2,490.00 26 16 400 0 $ 3,600.00 27 17 390 10 $ 3,450.00 28 18 392 8 $ 3,480.00 29 19 400 0 $ 3,600.00 30 20 400 0 $ 3,600.00 21 392 8 $ 3,480.00 32 22 400 0 $ 3,600.00 33 23 400 0 $ 3,600.00 34 24 398 2 $ 3,570.00 35 25 369 31 $ 3,135.00 36 26 400 0 $ 3,600.00 37 27 400 0 $ 3,600.00 38 28 400 0 $ 3,600.00 39 29 340 60 $ 2,700.00 40 30 366 34 $ 3,090.00 41 31 373 27 $ 3, 195.00 42 32 400 0 $ 3,600.00 43 33 400 0 $ 3,600.00 44 34 400 0 $ 3,600.00 45 35 400 0 $ 3,600.00 46 36 382 18 $ 3,330.00 37 400 0 $ 3,600.00 48 38 400 0 $ 3,600.00 49 39 325 75 $ 2,475.00 50 40 400 0 $ 3,600.00 51 41 400 0 $ 3,600.00 52 42 400 0 $ 3,600.00 53 43 400 0 $ 3,600.00 64 44 400 0 $ 3,600.00 55 45 381 19 $ 3,315.00 56 46 400 0 $ 3,600.00 57 47 400 0 $ 3,600.00 58 48 400 0 $ 3,600.00 59 49 361 39 $ 3 015 00 Low-waste Restaurant High-waste Restauran