Question: 1. For the total demand, which SKU has the highest variation in demand, and which has the lowest? What are the sales rank and product

1. For the total demand, which SKU has the

1. For the total demand, which SKU has the highest variation in demand, and which has the lowest? What are the sales rank and product category for these SKUs? [2 points] SKU s document is authorized for use only by Joseph Serr in Spring 2021 MBA 6220-070 taught by Shah, University of Minnesota from Jan 2021 to Jul Source: Company files. standard deviation values at the individual warehouses), Note: The standard deviation in the total column is based on the total average monthly demand (i.e., it is not the sum of CBLISO CBL151 CBLIS2 CBL153 CBL154 CBL155 CBL 156 CBLIS7 CBL158 CBL200 CBL260 CBL261 CBL275 CBL290 CBL.291 CBL292 CBL293 CBL 294 CBL295 CBL296 CBL300 CBL300 CBL.301 CBL302 CBL.303 CBL304 C CBL305 CBL306 CBL 307 CBL.308 CBL500 CBL 501 CBL600 CBL601 CBL602 Warehouse 10 Warehouse 20 Warehouse 30 Warehouse 40 Warehouse 70 Total Average Average Standard Average Standard Average Standard Average Standard Average Standard Average Standard Selling Price Monthly Sales Deviation Monthly Sales Deviation Monthly Sales Deviation Monthly Sales Deviation Monthly Sales Deviation Monthly Sales Deviation $ 6.38 14 21 - 24 75 17 39 3 4 4 58 81 $ 8.17 24 21 27 50 66 92 38 17 57 67 212 174 1 S 12.02 1 15 14 S 18 5 9 4 4 4 4 17 27 47 31 S 5.88 6 8 9 17 56 42 56 31 65 10 15 98 101 S 195 6.28 158 09 185 99 60 107 56 124 100 217 205 705 407 S 4.45 18 45 7 23 2 4 14 26 41 70 S 4.44 44 36 12 17 25 37 . 9 9 45 131 60 S 6.66 140 125 41 26 87 34 133 110 176 125 577 243 S 6.69 13 19 7 2 83 230 8 5 15 20 126 222 S 9.61 5 8 5 9 4 5 2 3 6 9 22 21 S 3.30 2 5 8 15 6 12 16 23 S 2.60 3 10 11 25 1 2 26 37 S 2.15 3 5 2 3 5 6 8 15 8 12 26 28 S 6.00 182 407 49 17 79 60 170 457 133 US 613 648 S 7.84 58 44 13 7 9 12 28 18 108 55 S 10.00 14 10 4 6 18 35 14 10 10 7 1 60 43 S 6.22 22 41 2 3 12 12 18 1 19 7 12 61 43 S 91.48 6 8 3 2 6 3 3 3 S 4 4 23 15 S 154.92 2 4 1 1 3 3 3 2 9 6 * S 2.90 36 62 13 20 5 3 7 4 4 61 61 S 2.61 39 79 31 24 73 41 49 69 118 94 310 141 S 2.61 5 16 2 3 3 16 20 23 36 S 2.61 8 7 7 4 11 9 12 14 S S 2.61 10 10 19 - 3 7 8 13 21 22 S 2.61 4 9 - 8 7 3 s 5 15 12 13 2 S 2.61 3 9 2 4 3 0 6 10 29 8 14 26 34 S 2.61 3 3 1 2 2 2 10 25 3 6 13 29 30 41 S 3.91 10 15 5 9 4 6 9 10 28 16 S S 3.32 . 12 11 18 44 4 6 17 33 12 16 63 49 S 125.59 1 2 1 2 2 2 4 4 S 129,95 3 4 1 1 1 1 1 1 6 4 S 1.15 8 8 2 2 17 27 6 7 7 19 33 S2 54 S S 0.90 61 41 41 45 73 41 45 60 31 19 251 93 S 2.39 82 15 26 78 104 107 194 72 127 334 316 EXHIBIT 5: MONTHLY DEMAND * *

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!