Question: Exhibit -5 Exhibit - 4 STARTECH.COM (Case questions) 1. What are the optimal inventory levels for the 5 warehouses (use exhibit 4 and 5) 2.

Exhibit -5Exhibit -5 Exhibit - 4 STARTECH.COM (Case

Exhibit -5 Exhibit - 4 STARTECH.COM (CaseExhibit - 4

STARTECH.COM (Case questions)

1. What are the optimal inventory levels for the 5 warehouses (use exhibit 4 and 5)

2. As Jeff Brodie, what alternatives would you consider? What are the probable advantages and disadvantages of this option?

3. As Jeff Brodie, what recommendations would you make to Paul seed and why? Note: Explicitly, state your assumption if you are taking for your analysis.

AG 9 CO u8 80 no 88 3 8 2 : 3 00 an ng Warehouse 101 Warehouse 201Warehouse 301 Warehouse 401 Warehouse 70 SKU | 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 CBL150 6.38 CBL151 8.1/ 2 CBL152 12.02 4 17 CBL153 0.88 160 . CBL154 0.28 107 217 CDT15 1.72 14 CBL157 13 110 CBL158S 15 CBL200 9 61 8 CBL260 3.30 3 - CBL261 2.60 CBL275 2.15 3 CBL290 600 CBL 291 100 20 7.84 CB1292 CBL293 CBL294 91.48 CBL295 154.92 CBL296 CBL300 31 24 118 BLSO ci CBI 203 CBL304 CBL305 S CBL306 S CBL 307 S 3.91 CBL 308 S 3.32 CBL500 S 125.59 CBL 501 $129.95 CBL600 S 1 To 9 * oriri Noriririririririri Ooo www.Dos Sawo nen Uadu Na Jouw N 29 Om AO U GOU ao na aloia SONO UGO U C G 8 14 11 Oha SON 0 SKU A 2 - CBL 150 CBL151 CBL152 CBL153 CBL 154 CBL 155 CBL156 CBL 157 CBL 158 CBL 200 CBL260 CBL 261 CBL275 CBL 290 CBL291 CBL 292 CBL293 CBL 294 CBL295 CBL296 CBL300 CBL 301 CBL 302 CBL 303 CBL 304 CBL305 CBL306 CBL 307 CBL308 CBL500 CBL 501 CBL600 CBL601 CBL602 Average Selling Price $ 6.38 8.17 12.02 5.88 S 6.28 S 4.45 S 4.44 $ 6.66 $ 6.69 $ 9.61 $ 3.30 $ 2.60 $ 2.15 $ 6.00 S 7.84 $ 10.00 S 6.22 $ 91.48 $ 154.92 $ 2.90 $ 2.61 S 2.61 S 2.61 $ 2.61 S 2.61 $ 2.61 $ 2.61 $ 3.91 $ 3.32 $ 125.59 S 129.95 S 1.15 S 0.90 S 2.39 B A B B B B B Y Y B A B B B B B B A - SKU Case Category Quantity S 100 S 30 S 25 80 60 80 80 40 50 60 120 120 800 200 120 25 C 150 3 6 500 C 80 80 80 80 C 80 80 C 80 60 60 1 2 150 500 200 Average Inventory at Warehouse Warehouse Warehouse Warehouse 20 30 40 68 37 100 141 73 41 37 15 65 125 114 248 275 206 25 36 36 47 41 134 135 350 17 46 17 20 13 18 12 9 24 37 93 258 37 81 524 157 44 31 16 37 31 6 26 39 10 10 7 2 6 37 12 54 129 106 11 OUUUUUUUUUUUUUUUUUUUUUUUUU Warehouse 10 34 101 136 235 272 53 86 302 364 28 12 24 298 307 118 39 36 12 17 121 105 119 21 88 7 21 9 15 21 10 11 21 175 280 Warehouse 70 37 73 15 114 206 36 41 350 17 18 24 37 37 157 31 31 39 7 6 12 106 11 13 8 10 23 73 18 31 4 3 11 129 383 - 6 7 32 22 15 12 70 20 9 2 5 39 141 229 23 73 18 31 4 3 11 129 383 - 8 116 42 AG 9 CO u8 80 no 88 3 8 2 : 3 00 an ng Warehouse 101 Warehouse 201Warehouse 301 Warehouse 401 Warehouse 70 SKU | 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 CBL150 6.38 CBL151 8.1/ 2 CBL152 12.02 4 17 CBL153 0.88 160 . CBL154 0.28 107 217 CDT15 1.72 14 CBL157 13 110 CBL158S 15 CBL200 9 61 8 CBL260 3.30 3 - CBL261 2.60 CBL275 2.15 3 CBL290 600 CBL 291 100 20 7.84 CB1292 CBL293 CBL294 91.48 CBL295 154.92 CBL296 CBL300 31 24 118 BLSO ci CBI 203 CBL304 CBL305 S CBL306 S CBL 307 S 3.91 CBL 308 S 3.32 CBL500 S 125.59 CBL 501 $129.95 CBL600 S 1 To 9 * oriri Noriririririririri Ooo www.Dos Sawo nen Uadu Na Jouw N 29 Om AO U GOU ao na aloia SONO UGO U C G 8 14 11 Oha SON 0 SKU A 2 - CBL 150 CBL151 CBL152 CBL153 CBL 154 CBL 155 CBL156 CBL 157 CBL 158 CBL 200 CBL260 CBL 261 CBL275 CBL 290 CBL291 CBL 292 CBL293 CBL 294 CBL295 CBL296 CBL300 CBL 301 CBL 302 CBL 303 CBL 304 CBL305 CBL306 CBL 307 CBL308 CBL500 CBL 501 CBL600 CBL601 CBL602 Average Selling Price $ 6.38 8.17 12.02 5.88 S 6.28 S 4.45 S 4.44 $ 6.66 $ 6.69 $ 9.61 $ 3.30 $ 2.60 $ 2.15 $ 6.00 S 7.84 $ 10.00 S 6.22 $ 91.48 $ 154.92 $ 2.90 $ 2.61 S 2.61 S 2.61 $ 2.61 S 2.61 $ 2.61 $ 2.61 $ 3.91 $ 3.32 $ 125.59 S 129.95 S 1.15 S 0.90 S 2.39 B A B B B B B Y Y B A B B B B B B A - SKU Case Category Quantity S 100 S 30 S 25 80 60 80 80 40 50 60 120 120 800 200 120 25 C 150 3 6 500 C 80 80 80 80 C 80 80 C 80 60 60 1 2 150 500 200 Average Inventory at Warehouse Warehouse Warehouse Warehouse 20 30 40 68 37 100 141 73 41 37 15 65 125 114 248 275 206 25 36 36 47 41 134 135 350 17 46 17 20 13 18 12 9 24 37 93 258 37 81 524 157 44 31 16 37 31 6 26 39 10 10 7 2 6 37 12 54 129 106 11 OUUUUUUUUUUUUUUUUUUUUUUUUU Warehouse 10 34 101 136 235 272 53 86 302 364 28 12 24 298 307 118 39 36 12 17 121 105 119 21 88 7 21 9 15 21 10 11 21 175 280 Warehouse 70 37 73 15 114 206 36 41 350 17 18 24 37 37 157 31 31 39 7 6 12 106 11 13 8 10 23 73 18 31 4 3 11 129 383 - 6 7 32 22 15 12 70 20 9 2 5 39 141 229 23 73 18 31 4 3 11 129 383 - 8 116 42

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!