Babies R'Us Case Study You have been hired as a strategic consultant by the hugely successful retailer \"Babies R'Us\". The company sells many products, although one product in particular, a highly innovative car seat, is being test marketed in various domestic and international markets. \"Babies R'Us\" has hired you to help them better understand the test market data they have compiled from 400 retailers worldwide (found in the excel file called \"CarSeats.xls\"). The variables in the data set include: Unit Sales = the number of units sold (in thousands), Competitor's Price = the price for a similar product being sold by a competitor (in dollars), Income Level = average household income in the region (in thousands of dollars), Advertising = amount spent on advertising the product (in thousands of dollars), Price = the price being charged by your company (in dollars), Population = number of people (in thousands) living in the region, Average Age = average age of the population in the region (in years), Average Education = average educational level in region, Shelving location = quality of the shelf location for your product (good, medium, or bad), Urban or Rural = description of the region as urban or rural, and finally, US = a categorical variable indicating whether the sales region is in the US or an international market. I. Run a multiple regression model with Unit Sales as the dependent variable against all of the available predictor variables, and use that model to answer ALL of the questions below. NOTE: DON'T TRY TO ADD ANY OTHER VARIABLES JUST YET, USE ONLY THOSE AVAILABLE IN THE ORIGINAL DATA SET: a. Which independent variables appear to be important predictors of sales? b. Which are not? Any surprises? Explain! c. Do you think collinearity is a problem for this data set? Explain! d. Are there outliers? Which one(s)? e. Based upon the results for the variables in the model, what \"profile\" should the company target for sales of the car seat in the future? Explain! f. If it costs $80 to produce each car seat, and advertising dollars spent represents the only additional variable cost associated with producing this product, what would be the effect of increasing the price you charge for each seat at retail, by $10? Explain! g. Some of the international managers feel that the product is not viewed favorably outside the US, what should you tell those managers? Explain! h. Babies & Toys can negotiate free shelving space if they can accept a \"bad\" location. Should they do this? Explain! i. Is there evidence that advertising dollars are being well spent for this product? Explain! j. Now, determine, on your own, the \"BEST POSSIBLE MODEL\" for predicting sales (NOTE: This final model might involve new terms that you create based on a careful reflection on the possible need for higher order terms, interaction terms, indicator variables, etc...). Once you have found what you consider to be the \"BEST\" model, go back and modify your answers to the above questions, IF NECESSARY! m UNIT SALES 9.5 11.22 10.06 7.4 4.15 10.81 6.63 11.85 6.54 4.69 9.01 11.96 3.98 10.96 11.17 8.71 7.58 12.29 13.91 8.73 6.41 12.13 5.08 5.87 10.14 14.9 8.33 5.27 2.99 7.81 13.55 8.25 6.2 8.77 2.67 11.07 8.89 4.95 6.59 3.24 2.07 7.96 10.43 4.12 4.16 4.56 12.44 4.38 3.91 10.61 1.42 4.42 7.91 COMPETITION PRICE INCOME LEVEL 138 111 113 117 141 124 115 136 132 132 121 117 122 115 107 149 118 147 110 129 125 134 128 121 145 139 107 98 103 104 125 136 107 114 115 131 122 121 109 130 119 157 77 123 85 141 127 126 116 157 99 121 153 73 48 35 100 64 113 105 81 110 113 78 94 35 28 117 95 32 74 110 76 90 29 46 31 119 32 115 118 74 99 94 58 32 38 54 84 76 41 73 60 98 53 69 42 79 63 90 98 52 93 32 90 40 Page 1 ADVERTISING 11 16 10 4 3 13 0 15 0 0 9 4 2 11 11 5 0 13 0 16 2 12 6 0 16 0 11 0 0 15 0 16 12 13 0 11 0 5 0 0 0 0 0 11 6 0 14 0 0 0 18 0 3 POPULATION 276 260 269 466 340 501 45 425 108 131 150 503 393 29 148 400 284 251 408 58 367 239 497 292 294 176 496 19 359 226 447 241 236 317 406 29 270 412 454 144 18 403 25 16 325 168 16 173 349 51 341 150 112 m 6.92 4.9 6.85 11.91 0.91 5.42 5.21 8.32 7.32 1.82 8.47 7.8 4.9 8.85 9.01 13.39 7.99 9.46 6.5 5.52 12.61 6.2 8.55 10.64 7.7 4.43 9.14 8.01 7.52 11.62 4.42 2.23 8.47 8.7 11.7 6.56 7.95 5.33 4.81 4.53 8.86 8.39 5.58 9.48 7.45 12.49 4.88 4.11 6.2 5.3 5.07 4.62 5.55 0.16 109 134 143 133 93 103 118 122 105 139 119 100 122 127 126 149 127 89 148 115 118 150 88 102 118 134 134 113 116 151 109 111 125 150 131 117 128 115 97 114 145 115 134 147 161 122 121 113 128 113 123 121 104 102 64 103 81 82 91 93 71 102 32 45 88 67 26 92 61 69 59 81 51 45 90 68 111 87 71 48 67 100 72 83 36 25 103 84 67 42 66 22 46 113 30 97 25 42 82 77 47 69 93 22 91 96 100 33 Page 2 13 13 5 0 0 15 4 19 0 0 10 12 0 0 14 20 0 15 16 0 10 5 23 10 12 1 0 16 0 4 7 0 0 9 7 7 3 0 11 0 0 5 10 10 5 24 3 11 0 0 0 0 8 0 39 25 60 54 22 188 148 469 358 146 170 184 197 508 152 366 339 237 148 432 54 125 480 346 44 139 286 353 237 325 468 52 304 432 272 144 493 491 267 97 67 134 237 407 287 382 220 94 89 57 334 472 398 217 m 8.55 3.47 8.98 9 6.62 6.67 6.01 9.31 8.54 5.08 8.8 7.57 7.37 6.87 11.67 6.88 8.19 8.87 9.34 11.27 6.52 4.96 4.47 8.41 6.5 9.54 7.62 3.67 6.44 5.17 6.52 10.27 12.3 6.03 6.53 7.44 0.53 9.09 8.77 3.9 10.51 7.56 11.48 10.49 10.77 7.64 5.93 6.89 7.71 7.49 10.21 12.53 9.32 4.67 134 107 115 128 132 116 131 122 139 135 145 112 130 128 125 119 127 131 89 153 125 133 143 94 108 125 132 132 96 131 128 125 146 133 140 124 122 132 144 114 140 110 121 122 111 128 150 129 98 146 121 142 119 111 107 79 65 62 118 99 29 87 35 75 53 88 94 105 89 100 103 113 78 68 48 100 120 84 69 87 98 31 94 75 42 103 62 60 42 84 88 68 63 83 54 119 120 84 58 78 36 69 72 34 58 90 60 28 Page 3 0 2 0 7 12 5 11 9 0 0 0 2 8 11 10 5 0 0 0 2 3 3 7 13 3 9 2 0 14 0 0 12 10 10 0 0 7 0 11 0 9 0 13 8 17 0 7 10 0 0 8 1 0 0 104 488 217 125 272 298 335 17 95 202 507 243 137 249 380 45 125 181 181 60 192 350 279 497 208 232 265 327 384 10 436 371 310 277 331 300 36 264 27 412 402 384 140 176 407 341 488 289 59 220 249 189 372 486 m 2.93 3.63 5.68 8.22 0.37 6.71 6.71 7.3 11.48 8.01 12.49 9.03 6.38 15 7.54 5.61 10.48 10.66 7.78 4.94 7.43 4.74 5.32 9.95 10.07 8.68 6.03 8.07 12.11 8.79 6.67 7.56 13.28 7.23 4.19 4.1 2.52 3.62 6.42 5.56 5.94 4.1 2.05 8.74 5.68 4.97 8.19 7.78 3.02 4.36 9.39 12.04 8.23 4.83 143 122 130 148 147 119 106 129 104 128 93 104 135 139 115 138 138 104 144 137 121 137 118 132 130 120 117 116 118 130 156 108 139 112 117 130 124 112 122 144 138 121 131 155 113 162 111 86 98 125 117 145 149 115 21 74 64 64 58 67 73 89 41 39 106 102 91 5 89 107 72 71 25 112 83 60 74 33 100 51 32 37 117 37 42 26 70 98 93 28 61 80 88 92 83 78 82 80 22 67 105 54 21 41 118 69 84 115 Page 4 5 0 0 0 7 17 0 0 15 12 12 13 5 0 0 9 0 14 3 15 0 4 6 7 11 0 0 0 18 13 13 0 7 18 4 6 0 5 5 0 0 4 0 0 1 0 0 0 11 2 14 19 5 3 81 424 40 58 100 151 216 425 492 356 416 123 207 358 38 480 148 89 70 434 79 230 426 35 449 93 142 426 509 297 170 408 71 481 420 410 333 500 335 349 139 413 132 237 317 27 466 497 326 357 445 501 220 48 m 2.34 5.73 4.34 9.7 10.62 10.59 6.43 7.49 3.45 4.1 6.68 7.8 8.69 5.4 11.19 5.16 8.09 13.14 8.65 9.43 5.53 9.32 9.62 7.36 3.89 10.31 12.01 4.68 7.82 8.78 10 6.9 5.04 5.36 5.05 9.16 3.72 8.31 5.64 9.58 7.71 4.2 8.67 3.47 5.12 7.67 5.71 6.37 7.77 6.95 5.31 27.3 5.83 6.53 116 141 106 138 116 131 124 136 110 134 107 119 113 149 98 115 132 137 123 115 126 141 151 121 123 159 136 124 124 130 114 120 123 111 125 137 139 133 124 108 123 147 125 108 123 129 121 120 116 128 130 128 134 123 83 33 44 61 79 120 44 119 45 82 25 33 64 73 104 60 69 80 76 62 32 34 28 24 105 80 63 46 25 30 43 56 114 52 67 105 111 97 24 104 81 40 62 38 36 117 42 77 26 29 35 93 82 57 Page 5 15 0 0 12 19 15 0 6 9 0 0 0 10 13 0 0 0 10 18 11 8 16 8 0 0 0 0 0 13 0 0 20 0 0 0 10 5 0 5 23 8 0 14 0 10 8 4 15 6 5 10 12 7 0 170 243 481 156 359 262 125 178 276 464 412 245 68 381 404 119 123 24 218 289 95 361 499 200 149 362 160 199 87 391 199 266 298 12 86 435 310 70 288 353 198 277 477 251 467 400 188 86 434 324 402 343 473 66 m 5.01 11.99 4.55 12.98 10.04 7.22 6.67 6.93 7.8 7.22 3.42 2.86 11.19 7.74 5.36 6.97 7.6 7.53 6.88 6.98 8.75 9.49 6.64 11.82 11.28 12.66 4.21 8.21 3.07 10.98 9.4 8.57 7.41 5.28 10.01 11.93 8.03 4.78 5.9 9.24 11.18 9.53 6.15 6.8 9.33 7.72 6.39 15.63 6.41 10.08 6.97 5.86 7.52 9.16 159 119 111 113 116 135 107 135 136 114 141 121 122 150 135 106 146 117 95 116 143 107 118 113 123 148 118 127 118 148 135 116 99 108 133 123 115 131 138 126 131 175 146 137 103 133 131 122 142 116 127 136 123 140 69 26 56 33 106 93 119 69 48 113 57 86 69 96 110 46 26 118 44 40 77 111 70 66 84 76 35 44 83 63 40 78 93 77 52 98 29 32 92 80 111 65 68 117 81 33 21 36 30 72 45 70 39 50 Page 6 0 0 0 0 8 2 11 14 12 2 13 10 7 0 0 11 11 11 4 0 25 14 0 16 0 3 14 13 13 0 17 1 0 13 16 12 26 1 0 19 13 29 12 5 3 10 8 5 0 10 19 12 5 10 438 284 504 14 244 67 210 296 326 129 376 496 303 80 112 414 261 429 208 74 448 400 106 322 74 126 502 160 276 312 497 158 198 388 290 408 394 85 13 436 33 419 328 337 491 333 220 369 472 456 459 171 499 300 m 10.36 2.66 11.7 4.69 6.23 3.15 11.27 4.99 10.1 5.74 5.87 7.63 6.18 5.17 8.61 5.97 11.54 7.5 7.38 7.81 5.99 8.43 4.81 8.97 6.88 12.57 9.32 8.64 10.44 13.44 9.45 5.3 7.02 3.58 13.36 4.17 3.13 8.77 8.68 5.25 10.26 10.5 6.53 5.98 14.37 10.71 10.26 7.68 9.08 7.8 5.58 9.44 7.9 16.27 107 136 144 133 112 117 100 122 135 106 136 93 120 138 130 112 134 140 98 137 117 138 121 132 96 132 134 111 124 133 107 133 130 142 103 123 130 118 131 131 111 122 154 124 95 109 135 126 152 121 137 131 132 141 105 65 69 30 38 66 54 59 63 33 60 117 70 35 38 24 44 29 120 102 42 80 68 107 39 102 27 101 115 103 67 31 100 109 73 96 62 86 25 55 75 21 30 56 106 22 100 41 81 50 71 47 46 60 Page 7 18 4 11 0 17 1 9 0 15 20 7 9 15 6 0 0 4 0 0 13 10 0 0 0 0 20 18 17 16 14 12 1 0 0 3 10 11 7 10 0 1 16 0 11 0 10 22 22 0 0 0 7 4 19 428 133 131 152 316 65 433 501 213 354 303 489 464 60 283 164 219 105 268 422 371 108 279 144 161 459 467 266 458 288 430 80 306 111 276 71 396 265 183 26 377 488 122 447 256 348 463 403 191 508 402 90 206 319 m 6.81 6.11 5.81 9.64 3.9 4.95 9.35 12.85 5.87 5.32 8.67 8.14 8.44 5.47 6.1 4.53 5.57 5.35 12.57 6.14 7.41 5.94 9.71 132 133 125 106 124 121 98 123 131 152 142 135 128 108 153 129 109 130 138 139 162 100 134 61 88 111 64 65 28 117 37 73 116 73 89 42 75 63 42 51 58 108 23 26 79 37 Page 8 0 3 0 10 21 19 0 15 13 0 14 11 8 9 0 13 10 19 17 3 12 7 0 263 105 404 17 496 315 76 348 455 170 238 245 328 61 49 315 26 366 203 37 368 284 27 m PRICE Shelf 120 83 80 97 128 72 108 120 124 124 100 94 136 86 118 144 110 131 68 121 131 109 138 109 113 82 131 107 97 102 89 131 137 128 128 96 100 110 102 138 126 124 24 134 95 135 70 108 98 149 108 108 129 AVERAGE AGE 1 3 2 2 1 1 2 3 2 2 1 3 2 3 3 2 3 3 3 2 2 3 2 2 1 3 3 2 1 1 3 2 3 3 2 2 3 2 2 1 1 1 2 2 2 1 2 1 1 3 1 1 1 AVERAGE YRS EDUCATION 42 65 59 55 38 78 71 67 76 76 26 50 62 53 52 76 63 52 46 69 35 62 42 79 42 54 50 64 55 58 30 44 64 50 42 44 60 54 65 38 73 58 50 59 69 44 48 55 69 32 80 75 39 17 10 12 14 13 16 15 10 10 17 10 13 18 18 18 18 13 10 17 12 18 18 13 10 12 11 11 17 11 17 12 18 10 16 17 17 18 10 15 10 17 16 18 13 13 12 15 16 18 17 16 16 18 Page 9 m 119 144 154 84 117 103 114 123 107 133 101 104 128 91 115 134 99 99 150 116 104 136 92 70 89 145 90 79 128 139 94 121 112 134 126 111 119 103 107 125 104 84 148 132 129 127 107 106 118 97 96 138 97 139 2 2 2 2 1 1 2 1 2 1 2 2 2 2 2 3 2 3 2 2 3 2 1 2 2 2 1 1 3 3 1 1 2 2 3 2 2 2 2 2 2 1 2 3 1 3 1 2 2 2 1 2 2 2 61 76 61 50 75 74 80 29 26 77 61 32 55 56 47 60 65 74 58 25 31 64 36 64 67 65 41 68 70 28 56 43 49 64 54 62 45 64 80 29 55 55 59 73 33 36 56 76 34 65 78 51 61 70 17 17 18 17 11 16 13 13 13 17 13 16 13 18 16 13 12 12 17 15 11 13 16 15 18 12 13 11 13 17 11 18 13 15 16 10 16 11 15 12 17 11 13 16 16 16 16 12 18 16 17 12 11 18 Page 10 m 108 103 90 116 151 125 127 106 129 128 119 99 128 131 87 108 155 120 49 133 116 126 147 77 94 136 97 131 120 120 118 109 94 129 131 104 159 123 117 131 119 97 87 114 103 128 150 110 69 157 90 112 70 111 2 1 2 2 2 3 1 2 2 2 2 2 2 2 1 2 3 3 2 3 2 1 1 2 2 3 1 2 2 1 2 2 2 2 1 2 1 3 2 1 3 2 2 3 3 3 2 2 2 3 2 3 1 2 60 65 60 43 43 62 33 65 42 80 41 62 64 63 28 75 29 63 43 59 51 55 40 51 77 72 62 76 36 31 80 44 30 45 28 77 28 34 47 39 41 72 56 57 75 45 25 50 65 51 48 39 30 29 12 16 17 14 14 12 12 13 13 10 12 11 12 13 10 10 15 14 15 16 14 13 10 12 16 10 12 16 18 18 11 10 13 18 15 15 17 11 17 14 16 14 11 10 17 13 17 16 16 16 13 10 18 12 Page 11 m 160 149 106 141 191 137 93 117 77 118 55 110 128 185 122 154 94 81 116 149 91 140 102 97 107 86 96 90 104 101 173 93 96 128 112 133 138 128 126 146 134 130 157 124 132 160 97 64 90 123 120 105 139 107 2 2 1 2 1 2 2 2 3 2 2 3 2 2 2 2 2 2 2 1 2 1 2 2 2 2 1 2 2 2 3 2 3 2 1 1 2 2 2 2 2 1 1 2 2 2 1 1 1 1 2 2 2 2 67 51 39 27 27 55 60 45 73 71 75 35 66 79 25 47 27 25 77 66 68 25 80 60 64 46 62 76 26 37 74 56 61 45 66 72 76 69 64 62 54 46 25 37 28 77 61 33 76 47 32 45 33 73 12 13 17 13 15 11 13 10 18 10 15 16 18 15 12 11 17 14 18 13 11 13 18 11 10 17 17 15 15 13 14 14 10 11 11 16 16 10 14 12 18 10 14 14 12 17 10 12 11 14 15 11 10 18 Page 12 m 144 144 111 120 116 124 107 145 125 141 82 122 101 163 72 114 122 105 120 129 132 108 135 133 118 121 94 135 110 100 88 90 151 101 117 156 132 117 122 129 81 144 112 81 100 101 118 132 115 159 129 112 112 105 1 2 2 2 3 2 2 2 2 2 1 3 2 1 2 1 2 3 2 3 2 2 2 3 1 2 2 2 2 2 3 1 1 2 1 3 1 2 2 3 1 2 2 1 1 1 2 2 2 3 1 3 1 2 71 34 70 25 58 30 80 35 62 48 36 56 57 26 27 38 27 61 29 56 50 69 48 73 62 26 38 52 57 26 57 78 34 61 65 72 62 32 57 37 80 73 80 72 74 36 54 48 25 31 39 73 51 39 11 17 14 14 17 10 11 13 14 13 14 14 16 11 18 14 11 15 14 16 17 10 10 13 16 18 12 14 10 18 10 18 16 11 11 14 13 16 12 17 15 10 13 14 11 10 15 18 17 15 17 17 12 11 Page 13 m 166 89 110 63 86 119 132 130 125 151 158 145 105 154 117 96 131 113 72 97 156 103 89 74 89 99 137 123 104 130 96 99 87 110 99 134 132 133 120 126 80 166 132 135 54 129 171 72 136 130 129 152 98 139 2 3 2 3 2 2 2 2 2 3 2 1 3 3 2 1 2 2 1 2 2 2 1 3 3 3 2 3 1 3 2 2 2 1 2 3 2 2 1 2 1 2 1 1 2 3 3 3 3 3 2 2 2 3 46 26 62 38 58 34 53 73 36 40 64 51 45 61 80 79 39 67 44 76 43 41 39 76 59 60 79 63 75 63 54 45 57 74 43 29 33 48 61 52 68 53 51 38 66 71 29 35 80 41 57 44 34 60 17 10 16 12 12 11 11 15 16 15 18 10 16 11 16 17 10 18 17 15 17 11 17 15 10 11 10 18 10 15 17 11 16 14 11 10 13 12 12 10 18 12 14 10 13 14 14 10 15 14 11 18 15 15 Page 14 m 103 150 104 122 104 111 89 112 134 104 147 83 110 143 102 101 126 91 93 118 121 126 149 125 112 107 96 91 105 122 92 145 146 164 72 118 130 114 104 110 108 131 162 134 53 79 122 119 126 98 116 118 124 92 2 1 2 2 2 1 3 1 2 2 2 1 2 1 2 2 3 1 2 2 1 3 3 2 3 3 2 2 2 3 2 2 3 3 2 1 1 3 2 1 3 3 2 2 3 3 2 1 2 2 2 2 2 3 34 53 47 53 80 55 45 32 32 61 41 42 72 28 80 45 44 43 72 71 26 70 79 33 27 49 49 63 62 61 35 42 42 72 34 69 66 52 56 79 25 30 57 53 52 74 36 42 54 65 78 47 73 44 12 13 11 17 16 11 12 14 10 12 10 13 15 18 15 11 15 16 10 10 14 13 12 13 14 11 14 17 16 17 12 18 11 12 15 11 14 15 15 12 12 14 17 12 17 14 14 12 16 11 17 12 11 11 Page 15 m 125 119 107 89 151 121 68 112 132 160 115 78 107 111 124 130 120 139 128 120 159 95 120 2 2 1 2 1 2 2 3 2 2 2 1 2 2 1 1 2 1 3 2 2 1 3 41 79 54 68 77 66 63 28 62 39 73 79 35 67 56 34 30 33 33 55 40 50 49 12 12 15 17 13 14 10 12 17 16 14 16 12 12 16 13 17 16 14 11 18 12 16 Page 16 m UrbanDummy USDummy 1 1 1 1 1 0 1 1 0 0 0 1 1 1 1 0 1 1 0 1 1 0 1 1 1 0 0 1 1 1 1 1 0 1 1 0 0 1 1 0 0 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 0 1 0 1 0 1 1 1 0 1 1 0 0 1 1 1 1 1 0 0 1 0 1 0 1 1 0 1 1 1 1 1 0 1 0 0 0 0 0 1 1 1 1 0 0 0 1 0 1 Page 17 URBAN? Yes Yes Yes Yes Yes No Yes Yes No No No Yes Yes Yes Yes No Yes Yes No Yes Yes No Yes Yes Yes No No Yes Yes Yes Yes Yes No Yes Yes No No Yes Yes No No Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes US? Yes Yes Yes Yes No Yes No Yes No Yes Yes Yes No Yes Yes No No Yes Yes Yes Yes Yes No No Yes No Yes No Yes Yes No Yes Yes Yes Yes Yes No Yes No No No No No Yes Yes Yes Yes No No No Yes No Yes m 1 0 1 1 1 1 1 1 0 1 1 0 0 1 1 1 1 1 0 1 0 0 0 1 0 1 1 1 1 1 1 0 0 1 0 1 0 0 1 1 1 1 1 0 1 0 0 0 1 0 1 1 1 0 1 1 1 0 0 1 0 1 0 1 1 1 0 0 1 1 0 1 1 0 1 1 1 1 1 1 0 1 0 1 1 0 0 0 1 1 0 0 1 0 0 1 1 1 1 1 1 1 0 0 1 0 1 0 Page 18 Yes No Yes Yes Yes Yes Yes Yes No Yes Yes No No Yes Yes Yes Yes Yes No Yes No No No Yes No Yes Yes Yes Yes Yes Yes No No Yes No Yes No No Yes Yes Yes Yes Yes No Yes No No No Yes No Yes Yes Yes No Yes Yes Yes No No Yes No Yes No Yes Yes Yes No No Yes Yes No Yes Yes No Yes Yes Yes Yes Yes Yes No Yes No Yes Yes No No No Yes Yes No No Yes No No Yes Yes Yes Yes Yes Yes Yes No No Yes No Yes No m 1 1 0 1 1 1 1 1 1 0 1 1 1 1 1 1 0 1 0 1 1 1 0 1 1 1 1 1 0 0 1 1 0 1 1 1 1 0 1 1 0 0 1 0 0 0 0 0 1 1 0 0 0 0 0 0 0 1 1 1 1 1 0 0 0 1 1 1 1 1 1 0 0 1 1 1 1 1 0 1 1 0 1 0 0 1 1 1 0 0 1 0 1 0 1 1 1 1 1 0 1 1 0 0 1 1 0 0 Page 19 Yes Yes No Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes No Yes No Yes Yes Yes No Yes Yes Yes Yes Yes No No Yes Yes No Yes Yes Yes Yes No Yes Yes No No Yes No No No No No Yes Yes No No No No No No No Yes Yes Yes Yes Yes No No No Yes Yes Yes Yes Yes Yes No No Yes Yes Yes Yes Yes No Yes Yes No Yes No No Yes Yes Yes No No Yes No Yes No Yes Yes Yes Yes Yes No Yes Yes No No Yes Yes No No m 0 1 0 0 1 1 1 1 1 1 1 1 1 0 1 0 1 0 1 1 1 1 1 0 1 0 1 1 0 0 1 0 1 1 1 1 1 1 1 0 1 0 1 1 1 1 0 1 0 0 1 1 1 1 1 0 0 1 1 1 0 0 1 1 1 1 1 0 0 1 1 1 1 1 0 0 1 1 1 0 0 0 1 1 1 0 1 1 1 1 0 1 1 0 0 1 0 0 0 1 0 0 1 1 1 1 1 1 Page 20 No Yes No No Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes No Yes No Yes Yes Yes Yes Yes No Yes No Yes Yes No No Yes No Yes Yes Yes Yes Yes Yes Yes No Yes No Yes Yes Yes Yes No Yes No No Yes Yes Yes Yes Yes No No Yes Yes Yes No No Yes Yes Yes Yes Yes No No Yes Yes Yes Yes Yes No No Yes Yes Yes No No No Yes Yes Yes No Yes Yes Yes Yes No Yes Yes No No Yes No No No Yes No No Yes Yes Yes Yes Yes Yes m 1 1 0 1 1 1 1 1 1 0 1 1 1 0 0 0 0 1 0 0 1 1 1 1 1 1 1 0 1 1 0 1 1 1 1 1 1 1 0 1 1 1 1 0 0 1 1 1 1 1 1 0 0 1 1 0 0 1 1 1 0 1 1 0 0 0 1 1 0 0 0 1 1 1 1 1 1 0 1 0 0 0 1 0 1 1 0 1 0 1 1 0 1 1 1 0 1 0 1 1 1 1 1 1 1 1 1 0 Page 21 Yes Yes No Yes Yes Yes Yes Yes Yes No Yes Yes Yes No No No No Yes No No Yes Yes Yes Yes Yes Yes Yes No Yes Yes No Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes No No Yes Yes Yes Yes Yes Yes No No Yes Yes No No Yes Yes Yes No Yes Yes No No No Yes Yes No No No Yes Yes Yes Yes Yes Yes No Yes No No No Yes No Yes Yes No Yes No Yes Yes No Yes Yes Yes No Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes No m 1 1 1 1 1 1 1 1 1 0 1 1 0 1 0 0 1 0 1 0 1 0 1 1 1 1 0 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 1 1 1 0 0 0 0 1 1 1 1 1 1 1 1 1 0 0 0 1 1 1 0 1 1 0 1 0 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 1 1 1 0 1 1 1 0 1 1 1 0 1 Page 22 Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes No Yes No No Yes No Yes No Yes No Yes Yes Yes Yes No Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No Yes Yes Yes No No No No Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No Yes Yes Yes No Yes Yes No Yes No Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes No Yes Yes Yes No Yes Yes Yes No Yes m 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 0 0 1 0 1 0 0 1 0 0 0 1 0 1 1 1 1 1 1 0 0 1 1 1 0 0 1 0 1 1 1 0 1 1 1 1 1 1 1 0 1 1 1 0 1 1 1 1 1 0 0 0 1 0 0 1 1 1 0 0 0 1 1 1 1 1 1 1 0 0 1 1 1 1 1 1 0 1 0 1 0 1 1 1 0 0 0 1 0 1 Page 23 Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No Yes No Yes No No Yes No No No Yes No Yes Yes Yes Yes Yes Yes No No Yes Yes Yes No No Yes No Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes No Yes Yes Yes Yes Yes No No No Yes No No Yes Yes Yes No No No Yes Yes Yes Yes Yes Yes Yes No No Yes Yes Yes Yes Yes Yes No Yes No Yes No Yes Yes Yes No No No Yes No Yes m 0 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 0 1 1 0 1 1 1 0 1 0 1 1 1 0 1 1 0 1 1 1 1 0 1 1 1 1 1 1 1 1 Page 24 No Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes No Yes Yes No Yes Yes Yes No Yes No Yes Yes Yes No Yes Yes No Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes m SHELVING LOCATION Bad Good Medium Medium Bad Bad Medium Good Medium Medium Bad Good Medium Good Good Medium Good Good Good Medium Medium Good Medium Medium Bad Good Good Medium Bad Bad Good Medium Good Good Medium Medium Good Medium Medium Bad Bad Bad Medium Medium Medium Bad Medium Bad Bad Good Bad Bad Bad Page 25 m Medium Medium Medium Medium Bad Bad Medium Bad Medium Bad Medium Medium Medium Medium Medium Good Medium Good Medium Medium Good Medium Bad Medium Medium Medium Bad Bad Good Good Bad Bad Medium Medium Good Medium Medium Medium Medium Medium Medium Bad Medium Good Bad Good Bad Medium Medium Medium Bad Medium Medium Medium Page 26 m Medium Bad Medium Medium Medium Good Bad Medium Medium Medium Medium Medium Medium Medium Bad Medium Good Good Medium Good Medium Bad Bad Medium Medium Good Bad Medium Medium Bad Medium Medium Medium Medium Bad Medium Bad Good Medium Bad Good Medium Medium Good Good Good Medium Medium Medium Good Medium Good Bad Medium Page 27 m Medium Medium Bad Medium Bad Medium Medium Medium Good Medium Medium Good Medium Medium Medium Medium Medium Medium Medium Bad Medium Bad Medium Medium Medium Medium Bad Medium Medium Medium Good Medium Good Medium Bad Bad Medium Medium Medium Medium Medium Bad Bad Medium Medium Medium Bad Bad Bad Bad Medium Medium Medium Medium Page 28 m Bad Medium Medium Medium Good Medium Medium Medium Medium Medium Bad Good Medium Bad Medium Bad Medium Good Medium Good Medium Medium Medium Good Bad Medium Medium Medium Medium Medium Good Bad Bad Medium Bad Good Bad Medium Medium Good Bad Medium Medium Bad Bad Bad Medium Medium Medium Good Bad Good Bad Medium Page 29 m Medium Good Medium Good Medium Medium Medium Medium Medium Good Medium Bad Good Good Medium Bad Medium Medium Bad Medium Medium Medium Bad Good Good Good Medium Good Bad Good Medium Medium Medium Bad Medium Good Medium Medium Bad Medium Bad Medium Bad Bad Medium Good Good Good Good Good Medium Medium Medium Good Page 30 m Medium Bad Medium Medium Medium Bad Good Bad Medium Medium Medium Bad Medium Bad Medium Medium Good Bad Medium Medium Bad Good Good Medium Good Good Medium Medium Medium Good Medium Medium Good Good Medium Bad Bad Good Medium Bad Good Good Medium Medium Good Good Medium Bad Medium Medium Medium Medium Medium Good Page 31 m Medium Medium Bad Medium Bad Medium Medium Good Medium Medium Medium Bad Medium Medium Bad Bad Medium Bad Good Medium Medium Bad Good Page 32