Taking stock of your stock management

Stock needs to be available for sale when your customer is ready to buy. But because it sucks up cash to have it waiting to be sold, it is good stock management to keep stock on the shelf for the shortest possible time.

Think of stock as fifty dollar bills piled up in your stock room. This is a good incentive to manage stock at every stage. Vital to this objective is knowing the sales cycle of your products, that is, how long it takes from when goods arrive until they are sold. The time goods are sitting in stock is called stock days. One way to calculate stock days using your financial reports is as follows:

Stock on hand ÷ Cost of goods x Time period = Stock days

Stock on hand means the dollar value of stock in store at a given date. Cost of goods means the direct cost of getting the goods ready for sale including purchasing, freight and store costs but not fixed overheads like administration, wages or advertising. Time period is the reporting period upon which you are basing the other two numbers.

Here’s an example. A business with $150,000 in stock at 30 June and cost of goods for the year of $400,000 has stock days of 137.

$150,000 ÷ $400,000 x 365 = 137

So on average, stock in this business takes 137 days from when it arrives until it is sold. Once you know this number you are then in a position to improve your stock management and work on shortening the cycle.

Know your stock

You may think this is a no-brainer and that all you have to do is sell stock quicker. If selling was that easy everyone would be doing it. The trick to shortening stock days is to carefully manage when the stock is coming in, as well as knowing when it is going out.

If you have a model supplier who knows your sales cycle and only supplies when you need it, that’s great. If not, you need to create your own system.

You need to know:

what is selling;
what isn’t selling;
which items are slow moving;
which items are obsolete;
what the trends/seasons are;
what your margins on items are; and
what it is costing to store stock.

Buy stock when it suits you, not the supplier

Many businesses buy when the sales representative calls in or if they are offered a discount. You should buy stock when it suits you and your needs, not those of your supplier. Discounts can be a big trap. Ask yourself why they are discounting. Do they know something you don’t? Is there a new product coming up that will supersede the sale item? You need to measure the cost of having that stock sitting around against the discount being offered. If it’s going to cause cashflow problems, perhaps it’s not worth it.

Invest in a stock management system

Stocktaking is a necessary evil. You need to check stock levels regularly, not only for tax purposes, but to know your profit levels.

There are literally thousands of stock management systems available which can reduce the need for manual stocktaking. These systems report on stock searching, stock receiving, bar-coding, special pricing, sales orders, picking and packing, dispatch register, order fulfillment, product specifications, stock usage and reordering requirements.

Obsolete stock can be a real hiding place for cash. It can be heartbreaking to have to sell items at a loss, but if they are going to sit there forever, you may as well turn them into working capital to spend on better selling items.

If you have good records you are also more likely to know just how much you are purchasing from suppliers. This puts you in a better bargaining position when it’s time to renegotiate.

Watch top performers

Finally, keep an eye on industry benchmarks. Good benchmarks should include stock days for the low, average and top performers in your industry. You will find the stock days of top performers are fewer than those of the others.

In a nutshell, shortening the length of time stock sits in your store room will free up working capital to spend on other things like advertising, salaries and expansion.

Has your business reaped the rewards of better stock management? What worked for you?

Sue Hirst is the founder of CAD partners (also known as ‘CFO On-Call’), a team of Financial Controllers who can help business owners grow their business safely.

4 comments | Add your own

Exonet has worked for us. It is like an enhanced MYOB that can easily handle stock items that are manufactured from other stock items.
Regards
Tim
http://www.nuganics.com.au Tim Lester from Marcoola
Hi Sue - I agree totally that management of stock is crucial - too many business owners manage their stock based on what has sold in the last few days and rob themselves of cash flow and space utilisation opportunities! Grant Hyman from Sydney | Read my articles
Hi Sue, it's a great article. Just a tip! You can sell your unwanted stock on eBay, of course it depends on the type of stock and your computer knowledge.
www.theofficewitch.com.au Judit Nagy from Sydney
Very good points.
One of the big problems is finding good suppliers. Many suppliers deliver too early, sucking up cash or too late resulting in stock outs or delayed production. Poor suppliers lead to reactive purchasing, keeping buffer stock and other cash draining practices. Ge rid of them and find new ones, even if they are a bit more expensive.
Another problem for manufacturers is Work In Progress. You really need to keep this low, just like any other form of stock. Keeping bits & pieces to fix 'when you get a spare minuite' really add up, and are often not worth it. Bite the bullet and scrap it if it's going to sit round for any length of time. Warwick Carter from Brisbane

4 comments | Add your own

Add Your comments

Preview comment

Name

Website *

Town / city and country

Email (never sold, displayed or given away)

* This will link your name to your site. So please avoid self promotion elsewhere! We delete spam, disrespectful or off-topic comments.