Product Number: 7B17D007

Title: StarTech.com: Supply Chain Strategy - Student Spreadsheet

This spreadsheet supports the product 9B17E013.

Prepared by: P. Fraser Johnson

Last Revised: 24-Oct-17

No part of this file may be reproduced, stored in a retrieval system, posted to the Internet, or transmitted in
any form or by any means without the permission of Richard Ivey School of Business Foundation. To order
copies or request permission to reproduce materials, contact Ivey Publishing, Ivey Business School, Western
University, London, Ontario, Canada, N6G 0N1; (t) 519.661.3208; (e) [email protected]; www.iveycases.com.

© 2017 Richard Ivey School of Business Foundation

 Average Inventory at Wareho
Average SKU Case
SKU Rank Warehouse 10 Warehouse 20
Selling Price Category Quantity
CBL150 $ 6.38 B S 100 34 -
CBL151 $ 8.17 A S 30 101 100
CBL152 $ 12.02 B S 25 136 41
CBL153 $ 5.88 B C 80 235 65
CBL154 $ 6.28 A C 60 272 248
CBL155 $ 4.45 B S 80 53 -
CBL156 $ 4.44 B C 80 86 36
CBL157 $ 6.66 A C 40 302 134
CBL158 $ 6.69 A S 50 364 17
CBL200 $ 9.61 B S 60 28 20
CBL260 $ 3.30 Y C 120 12 12
CBL261 $ 2.60 Y C 120 24 -
CBL275 $ 2.15 B S 800 298 93
CBL290 $ 6.00 A C 200 307 81
CBL291 $ 7.84 B C 120 118 -
CBL292 $ 10.00 B C 25 39 16
CBL293 $ 6.22 B C 150 36 6
CBL294 $ 91.48 B S 3 12 10
CBL295 $ 154.92 B S 6 17 -
CBL296 $ 2.90 B C 500 121 -
CBL300 $ 2.61 A C 80 105 54
CBL301 $ 2.61 C C 80 119 -
CBL302 $ 2.61 C C 80 21 -
CBL303 $ 2.61 C C 80 88 -
CBL304 $ 2.61 C C 80 7 -
CBL305 $ 2.61 C C 80 21 6
CBL306 $ 2.61 C C 80 9 7
CBL307 $ 3.91 C C 60 15 -
CBL308 $ 3.32 B C 60 21 32
CBL500 $ 125.59 B C 1 10 -
CBL501 $ 129.95 C C 2 11 -
CBL600 $ 1.15 C C 150 21 8
CBL601 $ 0.90 A C 500 175 116
CBL602 $ 2.39 A C 200 280 42
Average Inventory at Warehouse
Warehouse 30 Warehouse 40 Warehouse 70
68 37 37
141 73 73
37 15 15
125 114 114
275 206 206
25 36 36
47 41 41
135 350 350
46 17 17
13 18 18
9 24 24
- 37 37
258 37 37
524 157 157
44 31 31
37 31 31
26 39 39
10 7 7
2 6 6
37 12 12
129 106 106
- 11 11
- - 13
22 - 8
15 - 10
12 23 23
70 73 73
20 18 18
9 31 31
2 4 4
5 3 3
39 11 11
141 129 129
229 383 383
 Warehouse 10 Warehouse 20
Average Average Standard Average Standard
SKU
Selling Price Monthly Sales Deviation Monthly Sales Deviation
CBL150 $ 6.38 14 21 - -
CBL151 $ 8.17 24 21 27 50
CBL152 $ 12.02 7 15 14 18
CBL153 $ 5.88 6 8 9 17
CBL154 $ 6.28 158 185 99 60
CBL155 $ 4.45 18 45 - -
CBL156 $ 4.44 44 36 12 17
CBL157 $ 6.66 140 125 41 26
CBL158 $ 6.69 13 19 7 2
CBL200 $ 9.61 5 8 5 9
CBL260 $ 3.30 2 5 - -
CBL261 $ 2.60 3 10 - -
CBL275 $ 2.15 3 5 2 3
CBL290 $ 6.00 182 407 49 17
CBL291 $ 7.84 58 44 - -
CBL292 $ 10.00 14 10 4 6
CBL293 $ 6.22 22 41 2 3
CBL294 $ 91.48 6 8 3 2
CBL295 $ 154.92 2 4 - -
CBL296 $ 2.90 36 62 - -
CBL300 $ 2.61 39 79 31 24
CBL301 $ 2.61 5 16 - -
CBL302 $ 2.61 8 7 - -
CBL303 $ 2.61 10 19 - -
CBL304 $ 2.61 4 9 - -
CBL305 $ 2.61 3 9 2 4
CBL306 $ 2.61 3 3 1 2
CBL307 $ 3.91 10 15 - -
CBL308 $ 3.32 12 11 18 44
CBL500 $ 125.59 1 2 - -
CBL501 $ 129.95 3 4 - -
CBL600 $ 1.15 8 8 2 2
CBL601 $ 0.90 61 41 41 45
CBL602 $ 2.39 62 82 15 26
 Warehouse 30 Warehouse 40 Warehouse 70 Total
Average Standard Average Standard Average Standard Average
Monthly Sales Deviation Monthly Sales Deviation Monthly Sales Deviation Monthly Sales
24 75 17 39 3 4 58
66 92 38 17 57 67 212
5 9 4 4 17 27 47
42 56 31 65 10 15 98
107 56 124 100 217 145 705
7 23 2 4 14 26 41
25 37 9 9 41 45 131
87 34 133 110 176 125 577
83 230 8 5 15 20 126
4 5 2 3 6 9 22
- - 8 15 6 12 16
- - 11 25 1 2 26
5 6 8 15 8 12 26
79 60 170 457 133 115 613
13 7 9 12 28 18 108
18 35 14 10 10 7 60
12 12 18 19 7 12 61
6 3 3 3 5 4 23
1 1 3 3 3 2 9
13 20 5 3 7 4 61
73 41 49 69 118 94 310
- - 2 3 16 20 23
- - - - 4 9 12
3 7 - - 8 13 21
8 7 - - 3 5 15
3 6 10 29 8 14 26
10 25 3 6 13 29 30
5 9 4 6 9 10 28
4 6 17 33 12 16 63
- - 1 2 2 2 4
1 1 1 1 1 1 6
17 27 6 7 19 33 52
73 41 45 60 31 19 251
78 104 107 194 72 127 334
Total
Standard
Deviation
81
174
31
101
407
70
60
243
222
21
23
37
28
648
55
43
43
15
6
61
141
36
14
22
13
34
41
16
49
4
4
54
93
316