fbpx

Take stock of your stock. Work out what is your useful stock and what is obsolete, excess or dead stock. In other words, what sells and what doesn’t? Rank each of your warehouse products based on the past year’s sales or the number of “hits” (a figure that includes sales orders, transfers, or other use of the product).

Item (1)

Description (2)

Rank (3)

Hits (4)

Accum Hits (5)

Accum Hits % (6)

11932

Extra Premium Rolling Machine

A

48

48

9.28%

SUBF-91

Open Worm Drive Handpiece (W)

A

47

95

18.38%

1171

Premium Adjustable Rolling Machine

A

35

130

25.15%

120165

Hard Wearing Drive – 68pin

A

35

165

31.91%

59125

Industrial Tool Kit – 90 Piece

A

35

200

38.68%

1089-J

Open Worm Drive Handpiece (N)

A

30

230

44.49%

1140008

Double Comb Power Break Switch

A

30

260

50.29%

1172

Engine Oil 4 Ltr

A

28

288

55.71%

11912

Engine Oil 6 Ltr

A

25

313

60.54%

575029

Rust Paint Epoxy Yellow Gloss – 20 Litre

A

23

336

64.99%

575037

Rust Paint Epoxy Red Gloss – 20 Litre

A

22

358

69.25%

575052F

Rust Paint Epoxy Mission Br Flat – 4 Litre

A

22

380

73.50%

59112

Industrial Tool Kit – 132 Piece

A

21

401

77.56%

401

59113

Industrial Tool Kit – 193 Piece

B

15

416

80.46%

59114

Industrial Tool Kit – 200 Piece

B

15

431

83.37%

6026

Cordless Screwdriver Drill ½”

B

15

446

86.27%

9133401

Cordless Screwdriver Drill ¾”

B

11

457

88.39%

SC1068

Industrial Spanner 12mm

B

10

467

90.33%

SS-BC

Industrial Spanner 16mm

B

10

477

92.26%

SS-Screw14

Screwdriver Set 14 piece

B

9

486

94.00%

85

SS Drive

Screwdriver Sq Drive 9 piece

C

9

495

95.74%

SURS-171

Screwdriver Sq Drive 7 piece

C

9

504

97.49%

18

SUTP-713

Sausage – Spicy Spanish

D

8

512

100.00%

8

SUTS-83

Chicken – Water Trough

X

0

512

100.00%

1140006

Cable – Power Break

X

0

512

100.00%

1170

Engine Oil SAE 97 50 Ltr

X

0

512

100.00%

120173

CD Install Instructions Water Trough

X

0

512

100.00%

12615

Multimedia Kit for Chicken Trough

X

0

512

100.00%

12621

Fowl house Corner Piece

X

0

512

100.00%

12623

Chicken Feed Bin 20 kg

X

0

512

100.00%

12715

Chicken Feed Bin 50 kg

X

0

512

100.00%

0

Total Hits

512

The above example shows a report listing products in order of frequency of hits.  It includes the product part number and the number of times the product has been “hit” in the past year.

Column 5 adds up the number of times that the part and all parts listed above it have been “hit” during the year, while column 6 turns that accumulated “hits” figure into a percentage of the warehouse’s overall product demand.

The 3rd column uses the accumulated demand figure to divide all stock into one of five different tiers.

The top tier – or “A” class products – account for 80% of overall hits.

The “B” tier includes the next 15% of hits.

“C” products account for the next 4%, while

“D” is assigned to the final 1% of hits.

Any remaining products (i.e. those with no hits) for the past year are classed as “X”.

Armed with this information you can start to understand what you have in your inventory plus patterns in demand. Now is also the time to ask why you hold certain items.  Look at any “D” or “X” ranked products and consider whether you really need to continue to stock them.  Are they repair or demonstration stock?  Do they serve a purpose or are they remnants from a previous business strategy?

Step 2: Get rid of your unnecessary stock

Once you have analysed your stock in the light of an A-to-X hits report, you will most likely see that some stock needs to go. Following are some hints to help you get rid of your space-wasting obsolete, excess and dead stock.

  • Ship it to other warehouses, perhaps even other states, where there is a demand for that item.  Refer to your stock sales/usage records to see if you have situations where this might work.
  • Send the problem stock back to your supplier (and remember that the best time to talk about returns is when you are placing that next big order).
  • Reduce prices to clear.  This strategy will not only help free up your warehouse; it may also prove to be a popular promotion with your customers.
  • Give your sales team additional incentives to move the stock.
  • Consider liquidating the stock via disposal stores, Internet sites or online auctions.
  • Try to up-sell customers by offering them the higher-rated older models, rather than lower-rated newer models. After all, obtaining some money is better than having the stock sitting in your warehouse for the next three years.
  • Donate the items to a charity or suitable tax-deductible cause.
  • If all else fails, dispose of the items that you can’t move. Keeping unnecessary, unwanted stock in your warehouse costs your business money.

Once you have identified and removed unnecessary stock, you need to make sure that it is not re-ordered. This requires changing purchasing re-order methods to ensure that no automatic or accidental re-ordering is possible.  You don’t want to have to go through the whole process again in 12 months time.

Step 3: Organise your warehouse into zones to minimise time and cost of fulfilment

The faster employees can locate a product, the faster it is packed and can be despatched.  It’s the basic formula for an efficiently operating warehouse.

If 80% of your hits come from “A” ranked stock items, this is where your employees are going to be spending most of their time. Therefore it makes sense that “A” ranked products should be located together in the zone closest to shipping, staging and receiving. “B” ranked products move slightly less frequently but should be the next most accessible group of items.  Then comes “C” and “D”. By organising stock into ranks and establishing zones within the warehouse based on distance from the packing benches, you will minimise the time and cost of filling each delivery.

Step 4: Determine how much stock you need to hold in each warehouse zone

Accessibility isn’t the only concern when allocating warehouse space to stock.  There’s also the issue of what to do with bulky stock items.

If one of your A ranked products is especially large and eats up an excessive amount of your primary warehouse space, it doesn’t make sense to store the entire stock of that item in your optimal picking zone. The same goes for B ranked products.

Inventory management expert, Jon Schreibfeder, president of Effective Inventory Management, Inc., recommends that the greatest efficiencies come from maintaining a limited supply – such as 7 to 14 days worth of stock – in the optimal zone and placing the remainder in a bulk storage area. Slower-moving C, D and X stock items are unlikely to require bulk storage as low turnover rates should dictate reduced stock quantities.

It’s an approach that ensures fast and efficient day-to-day picking, packing and despatch and which also accommodates the need for bulk purchase and storage of high-turnover products.

Conclusion

Clearly, a system that provides up to date inventory numbers and status will go a long way to putting you back in control.  Running a logistics business without visibility of stock cost, stock turns and stock procurement planning is a recipe for pain.
Good inventory management is not rocket science but it is the critical basis for a sound logistics or distribution business.  It is also the natural result once organisation and knowledge are applied to inventory practices.

Technology Partners
Microsoft Certified
Crystal Reports
QlikView
Infragistics