How to Deal with a Drop in Sales
January 30, 2012 – 2:23 pm | No Comment

It’s going to happen sometime. Your sales are going to drop. Maybe it will be a short time period or maybe a longer one. How do you cope?
This was a tough winter for those of …

Read the full story »
Inventory Planning

Keep your cash flowing by planning the sales, inventory levels and delivery times for each department.

Staffing

Labor costs can be huge for a small business. Plan what you can afford to pay people, then train them to do their job.

Cash Planning

The details of where the cash is going and how to make the best use of it.

Customer Service

It is, of course, people who buy things from us.

Featured
Home » Featured, Inventory Planning

The Open to Buy Book: A Power Tool in the Small Business Tool Box

Submitted by on January 20, 2011 – 5:00 pmNo Comment

The Open to Buy Book: A Power Tool in the Small Business Tool Box

Are you looking to unlock the power of turn over and gross margin?

If you are, then you are like the majority of us small business owners. When you are buying and selling merchandise, turn over and gross margins are the way to effectively utilize and generate cash. While both numbers can be indicators of what has happened in your business, they are the method that brings cash into the business.

Turn over is a subject that I have written about in a number of other posts. For the purpose of talking about using an Open-to-Buy book, I will talk some about turn over again. I am sure that you know basically that “turn over” is an annual number that indicates how much money you have invested in inventory on average over the year compared to your sales. You figure this by dividing your sales for the year by the average inventory amount for the same year. This gives you a historical look at how well you used your money. Turn over figures vary greatly from industry to industry. To find out how you are doing compared to others in similar businesses find a “cost of doing business report” for your industry, it should have a section on what the average turn over is for similar businesses.

So, now you can figure your turn over for a year ago. But, what can be done to plan that turn over amount for this year and take actions to make that happen? That’s where an Open-to-Buy book comes into play. Check out a copy of an OTB book here.

Let’s say you want to have a turn over of 3 turns a year. In order to do that you will first have to decide what your sales goals are for that year. Once that is done you can start to plan out the inventory levels. You can do this for your entire business or break it down by merchandise groupings or departments. In our OTB example, we are using a department breakdown.

Looking at the example, our sales budget or sales goal was $13,300 for the year. We have a sales goal for each month. A simple way to plan inventory for each month for 3 turns a year is to divide 3 into 12 which gives you 4. This means that you need to have 4 months worth of inventory on hand at the end of any given month. To get that number you add the together the sales of the next 4 months. If your sales plan indicates that your next 4 months of sales are: $2,000, 1,800, 1,300 and 1,100, then your inventory needs are $6,200 at retail. In the example under April you will see that the “Planned End Of Month Stock” is $6,200. That is the total of May, June, July and August. To work up how much inventory you need to meet your sales and hit a turn over of 3 is as simple as adding up the next 4 months of sales after any given month. You can see this for each month on the OTB sheet on the Planned EOM Stock row.

Are you with me so far?

This method allows you to plan for months with more sales and those with less. You can take charge of your turn over goals by paying close attention to the amount of inventory

you have and how much you need to order to hit those goals. Having a little less inventory at any given time will increase your turn over, as long as you are hitting your sales goals. Having too little however may result in a loss of sales. Too much inventory means that you have your money tied up in stock and not available for other uses. More turn over means less inventory on hand at any given time and less money invested at any given time.

Ok, we’ve looked at turn over and using an OTB book for planning. In the next post we will look at gross margin and then how to combine them to enhance each other.

Till then, happy sales to you.

Popularity: 3% [?]

Leave a comment!

Add your comment below, or trackback from your own site. You can also subscribe to these comments via RSS.

Be nice. Keep it clean. Stay on topic. No spam.

You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

This is a Gravatar-enabled weblog. To get your own globally-recognized-avatar, please register at Gravatar.