Putting Your Customers' Needs First

Sample SKU Item Analysis Profile Table

Product Categories

Percentage of Annual Sales Dollars

Primary Product Lines

25%

50%

75%

90%

100%

Product Line A Product Line B Product Line C Product Line D Product Line E Product Line F Product Line G Product Line H Product Line I Product Line J Product Line K Product Line L Product Line M Product Line N

15

50

137

290

1,082

2 5 6 2 2 6 3 7

5

12 59 74 18 39 79 18 57

27

96

18 23

157 156

1,289

632 889

6

69

26

104

335

753 110 195 119 744 233 654 220 42

2,993

11 25

606

1,339

7

376 461

23

34

125

346 107 314 110

2,904 1,052 2,162

7

34

29 14

108

44

889

Subtotal

158

583

1,705

3,769

16,830

Supporting Product Lines Product Line O

6 5

21 24 34 33 20 30 14 6

58 67 88 79 12 55 70 29 20 34

133 125 164 146

545 337 491 379 359 357 319 155 298 30

Product Line P Product Line Q Product Line R Product Line S Product Line T Product Line U Product Line V Product Line W Product Line X

11 11

2 8

19

107 129

10

5 3 6

65 43 68

8

14

Subtotal

67

204

512

999

3,270

Specialty Product Lines Product Line ABC

23 16

98 66 37 16

322 209 142

735 412 345 228

2,578

Product Line DEF Product Line GHI Product Line JKL

931

5 3

1,279 1,713 6,501

76

Subtotal

47

217

749

1,720 6,488

GRAND TOTALS

272

1,004

2,966

26,601

Now, whether you are deciding on which items to carry in stock versus MTO or trying to decide on where to spend your time on web catalog development, competitive cross reference, product selector guides, installation instructions, data sheets, sales drawings, etc., you can quickly see that an analysis like this can help you greatly to optimize your time and effort and help you to make sure you are working on those things of greatest value to your customer base. In addition, by highlighting these KEY catalog items in your catalogs and web content, you can assist your users in selecting those items that are most popular among your customer base.