Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Warehouse 10 Warehouse 20 Warehouse 30 Warehouse 40 Warehouse 70 Total SKU Average Selling Price Rank SKU Category Quantity per case Average Monthly Sales Standard
Warehouse 10 | Warehouse 20 | Warehouse 30 | Warehouse 40 | Warehouse 70 | Total | |||||||||||
SKU | Average Selling Price | Rank | SKU Category | Quantity per case | Average Monthly Sales | Standard Deviation | Average Monthly Sales | Standard Deviation | Average Monthly Sales | Standard Deviation | Average Monthly Sales | Standard Deviation | Average Monthly Sales | Standard Deviation | Average Monthly Sales | Standard Deviation |
CBL150 | $ 6.38 | B | S | 100 | 14 | 25 | 6 | 10 | 24 | 75 | 17 | 39 | 3 | 10 | ||
CBL151 | $ 4.55 | A | S | 30 | 24 | 35 | 27 | 50 | 66 | 180 | 38 | 75 | 57 | 120 | ||
CBL152 | $ 10.05 | B | S | 25 | 7 | 15 | 14 | 30 | 5 | 9 | 4 | 12 | 17 | 27 | ||
CBL153 | $ 8.50 | B | C | 80 | 6 | 8 | 9 | 17 | 42 | 56 | 31 | 65 | 10 | 15 | ||
CBL154 | $ 12.12 | A | C | 60 | 158 | 80 | 99 | 60 | 107 | 56 | 124 | 60 | 217 | 85 | ||
CBL155 | $ 5.25 | B | S | 80 | 18 | 45 | 5 | 8 | 7 | 20 | 2 | 4 | 14 | 25 | ||
CBL156 | $ 5.60 | B | C | 80 | 44 | 36 | 12 | 17 | 25 | 37 | 9 | 9 | 41 | 45 | ||
CBL157 | $ 6.85 | A | C | 20 | 140 | 65 | 41 | 15 | 87 | 34 | 133 | 55 | 176 | 65 | ||
CBL158 | $ 6.69 | A | S | 50 | 13 | 19 | 7 | 12 | 83 | 180 | 8 | 20 | 15 | 32 | ||
CBL200 | $ 9.61 | B | S | 60 | 5 | 8 | 5 | 9 | 4 | 11 | 2 | 5 | 6 | 15 | ||
CBL260 | $ 3.30 | Y | C | 120 | 2 | 6 | 3 | 7 | 1 | 2 | 6 | 15 | 5 | 12 | ||
CBL261 | $ 2.60 | Y | C | 120 | 3 | 10 | 2 | 5 | 1 | 2 | 7 | 25 | 1 | 2 | ||
CBL275 | $ 5.25 | B | S | 500 | 3 | 5 | 2 | 4 | 5 | 7 | 8 | 15 | 8 | 12 | ||
CBL290 | $ 5.85 | A | C | 200 | 182 | 60 | 49 | 17 | 79 | 33 | 170 | 50 | 133 | 115 | ||
CBL291 | $ 5.25 | B | C | 100 | 58 | 44 | - | - | 13 | 7 | 9 | 12 | 28 | 18 | ||
CBL292 | $ 10.00 | B | C | 25 | 14 | 10 | 4 | 6 | 18 | 35 | 14 | 10 | 10 | 7 | ||
CBL293 | $ 7.26 | B | C | 150 | 22 | 10 | 2 | 3 | 12 | 12 | 18 | 19 | 7 | 12 | ||
CBL294 | $ 45.00 | B | S | 30 | 6 | 12 | 3 | 6 | 5 | 7 | 3 | 5 | 5 | 10 | ||
CBL295 | $ 50.25 | B | S | 50 | 2 | 4 | - | - | 1 | 2 | 3 | 6 | 3 | 5 | ||
CBL296 | $ 4.95 | B | C | 500 | 36 | 25 | - | - | 13 | 20 | 5 | 3 | 7 | 4 | ||
CBL300 | $ 2.25 | A | C | 50 | 39 | 37 | 31 | 30 | 73 | 70 | 49 | 69 | 118 | 110 | ||
CBL301 | $ 2.61 | C | C | 50 | 5 | 16 | - | - | - | - | 2 | 3 | 16 | 20 | ||
CBL302 | $ 2.61 | C | C | 80 | 8 | 7 | - | - | - | - | - | - | 4 | 9 | ||
CBL303 | $ 2.61 | C | C | 80 | 10 | 5 | - | - | 3 | 7 | - | - | 8 | 13 | ||
CBL304 | $ 2.61 | C | C | 80 | 4 | 9 | - | - | 8 | 7 | - | - | 3 | 5 | ||
CBL305 | $ 2.61 | C | C | 80 | 3 | 9 | 2 | 4 | 3 | 6 | 10 | 29 | 8 | 14 | ||
CBL306 | $ 2.61 | C | C | 80 | 3 | 3 | 1 | 2 | 10 | 25 | 3 | 6 | 13 | 29 | ||
CBL307 | $ 3.91 | C | C | 60 | 10 | 15 | - | - | 5 | 9 | 4 | 6 | 9 | 10 | ||
CBL308 | $ 10.55 | B | C | 60 | 12 | 11 | 18 | 44 | 4 | 6 | 17 | 10 | 12 | 16 | ||
CBL500 | $ 63.45 | B | C | 50 | 1 | 2 | - | - | - | - | 1 | 2 | 2 | 2 | ||
CBL501 | $ 39.55 | C | C | 20 | 3 | 4 | - | - | 1 | 1 | 1 | 1 | 1 | 1 | ||
CBL600 | $ 1.15 | C | C | 150 | 8 | 8 | 2 | 2 | 17 | 27 | 6 | 7 | 19 | 33 | ||
CBL601 | $ 2.90 | A | C | 300 | 61 | 24 | 41 | 22 | 73 | 41 | 45 | 16 | 31 | 19 | ||
CBL602 | $ 4.85 | A | C | 100 | 62 | 18 | 30 | 14 | 78 | 34 | 107 | 50 | 72 | 22 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started