BOOK US

With over 25 years of frontline experience Tom Shay is America's leading small business management expert. He's a "Must Have" for your next event.

(If you like this article and wish to pass it along to someone else, please use our on-line form)

Creating an Open to Buy

Spending Wiser with Inventory Control

Perhaps you are starting to think about getting ready to go to the show in Denver, Atlanta, or Billings early next year. Has this situation ever happened to you? You are going to look for merchandise for the spring season. As with many businesses, the spring months can be some of the busiest days of your year, especially if you are selling to a lot of folks that are farmers or working outside. Likewise, these months should be the time of year when you receive a larger amount of inventory as compared to the amount of inventory you are likely to need for later in the summer when sales are traditionally slow.

However, here in the fall, you are concerned as you are examining the material that the merchandise mart and various vendors are sending to you. As you look about your store, you can see that your shelves are already getting full for the holiday season. And then you are probably going to go into a part of the year with lesser sales for January through March. Taking a quick calculation of what your sales should be for the next 90 to 120 days, you see that if you receive absolutely no inventory in that time, you will still have a substantial amount of inventory on April 1.

If you take a look at your checking account balance, and do the math for sales and expenses for these same 90 to 120 days, you find that you are not going to have enough money available to spend when you do go to market.

There are a couple of options available to you. The first is to go to the bank and borrow the necessary money so that you can order and pay for the incoming spring inventory. The second option is to go to the mart and ask, maybe beg, for extended terms. Unfortunately as the extended terms is a requirement of your spring purchasing this year, you may find yourself walking away from vendors that you would want to order from. You may also find yourself placing orders with lines that are your second choice as they are the only ones who would give extended dating.

The third option is to hastily create a clearance sale to free up as much money and shelf space as possible in early January so that you will have the money and room for the spring inventory that will arrive as a result of your trip to the market.

If you have ever found yourself in this situation, you have probably asked if there isn't a better way of solving it. Unfortunately, the only better way is to develop a way of not getting into this position in the first place. And the best way of preventing this situation from reoccurring is to learn how to create, buy from, and manage your inventory from an "open to buy".

If you already understand and utilize an "open to buy", read on as we will have several new ideas to share with you in an effort to help you have your open to buy become a better management tool. However, if you have heard the phrase, but have never known how or why to have an "open to buy", then we can go a long way today towards making sure you never have to experience the situation we described at the beginning of this article.

We will make the assumption that your business receives monthly financial statements in a timely manner. In this context, as an example we mean you have completed financials for November so early in December that you are able to use the information to make decisions affecting December's financials. When you are looking at the December financials you are probably making a point to look at the line which indicates the amount of inventory you have on hand. As we would expect you to have December as one of your best sales months, your inventory for November 30 will probably be the largest amount of inventory you will have for the last day of business in any month in the year.

But what if your business follows the model which shows you January and February sales to be the two slowest selling months of the year? Then the inventory you would want to have on hand for December 31, and for January 31, would stand to reason to be the lowest two end of the month inventories you should have. And yet, we will want to build up inventory again in March for the better months of April and May.

The logic is that higher sales require additional inventory levels. And if you can get by with lesser inventory, as with our two example months, you will want to make sure you are getting your money out of your inventory and into your checking account during the higher sales of December. Unfortunately, if you do not utilize an open to buy plan, the ending inventory for each month will be a surprise to you as you first look at your financials. And without a plan, as you go to market to buy the next season of merchandise, you will find the necessary money might not be in your checking account but is sitting on the shelves in the form of winter inventory.

How do you create an open to buy? You begin by establishing goals for your total sales for each of the next twelve months. If you track your sales by departments and fine lines you will want to establish a goal for each department for each of the twelve months.

Let's take a quick moment to define each of these. Within your store, you sell many types of products. As an example, you sell men's and women's clothing and accessories which could each be a department of your business. Within the department of men's clothing, you probably sell shirts, pants, boots, hats and accessories. Some businesses will track their inventory and sales of each of these groups of products within the men's department. These groups are called fine line categories. With the more defined information, you gain more knowledge about the inventory and sales within your business.

The second step is to know the maintained gross margin for your store overall. And again, if you are tracking sales by departments and fine lines, you will want to know the maintained gross margin for each of them. Taking each month's sales goal and multiplying it by the margin, the answer will tell you how much inventory at cost you are expecting to sell for that particular month.

For example, if you sell pants and for the months of November and December you expect to sell $3,000 and $5,000 respectively, in pants with a maintained margin of 45%, you will be selling $1,650 at cost in November, and $2,750 at cost in December. Now perform this same task for each department and fine line for each month.

With this number in hand for our example, we are going to pretend you will have $5,000 in inventory on October 31. As November and December are your best months for selling pants, you will not want the same amount of inventory on hand on December 31.

You need some inventory for those who are making purchases with their "Christmas cash" in January, but you know that you want less inventory. Again in our example, you have decided you need $2,000 in inventory at year end. Here is the math:

10/31 inventory $5,000 (at cost)

less November sales $1,650 (at cost)

less December sales $2,750 (at cost)

balance $ 600 (at cost)

With these figures, for you to have the desired $2,000 in inventory for December 31, you need to have $1,400 in inventory, at cost, to arrive in November or early December. If you fail to have this much inventory arrive, you will have a very poor selection for those after Christmas shoppers, and if you have too much inventory, your cash to pay year end bills will be sitting on the shelf in the form of inventory and you will be struggling to figure out what to do.

What if sales are not what you expected them to be? Then you will have to decrease your open to buy for the following month. If sales are greater than anticipated, you have additional open to buy and you will be calling the vendor to get an order placed for immediate delivery.

If sales are less than expected, you will be starting the new year with more inventory than you want. You will then take your open to buy for the first part of the next year and decrease it by a like amount.

There are a couple of questions that probably still remain. How often should you calculate open to buy? While monthly is the traditional time frame, you may find that this is too overwhelming and want to use bi-monthly or quarterly.

How should you calculate an open to buy? You can get buy with something as simple as a columnar pad, pencil, and calculator to create a chart as we have just described. If you are comfortable working on your computer with a software program such as Microsoft Excel, you can create an open to buy chart which is updated with the pressing of a couple of digits and the 'enter' key.

We have created an "open to buy" calculator and put it on our website at www.profitsplus.org where you are welcome to download it for free.

Should an open to buy be such an important part of your business? Consider the statistic that indicates 54% of the businesses that fail, do so with a financial statement that shows they are making a profit. Their problem is that they have no cash available to pay bills. The answer is yes! You need an open to buy if you want to be open for business.

If you would like to send this article to someone you know, please use this form to forward this page:

Your Name: E-Mail:
Friend's Name: E-Mail:
Security Code:

 

This article is copyrighted by Tom Shay and Profits Plus Solutions, who can be reached at: PO Box 128, Dardanelle, AR. 72834. Phone 727-823-7205. It may be printed for an individual to read, but not duplicated or distributed without expressed written consent of the copyright owner.

 

APRIL 2024
Have the Small Business Conversations, Advisories and News sent to your inbox. Subscribe HERE

Small Business

AdvisorieS

"What's your score"? is the name of the April Small Business Advisory. This provides an introduction to our return on investment calculator. It is a great way to understand how well the investment you have in your small business is working for you.

Small Business

News

Top Story

We believe Thursday, April 25 is an important annual celebration for small businesses. While the name of the celebration has varied over the years, the focus is for us to take kids to work with us.

 

This is important for the kids to see what it is we do. They definitely are not going to learn about it in school. Reading the April Small Business News you will see an example from community pharmacists that emphasizes it is up to us as small business owners to introduce kids to what we do.


Article of the Month

While titled, "If not price", the April Article of the Month is asking the question about the focus of your small business in attracting and keeping customers.

 

If there is not something very special about your business, then the only attraction to your businessis that of a low price.


Book of the Month

"The plan as you go business plan" is the April book of the month. The author is Tim Berry who has also created software on the same topic.

 

I do not agree with the concept of "fill in the blank" or "create the plan as you need it" because my experience has been that you do not have as strong as a connection and understanding to your business plan unless you do it yourself and you dedicate the time to create it.

BOOK US

With over 25 years of frontline experience Tom Shay is America's leading Small Business Management Expert. He's a "Must Have" for your next event.

Small Business

Advisories

"What's your score"? is the name of the April Small Business Advisory. This provides an introduction to our return on investment calculator. It is a great way to understand how well the investment you have in your small business is working for you.

Small Business

News

 

Top Story

We believe Thursday, April 25 is an important annual celebration for small businesses. While the name of the celebration has varied over the years, the focus is for us to take kids to work with us.

 

This is important for the kids to see what it is we do. They definitely are not going to learn about it in school. Reading the April Small Business News you will see an example from community pharmacists that emphasizes it is up to us as small business owners to introduce kids to what we do.


Article of the Month

While titled, "If not price", the April Article of the Month is asking the question about the focus of your small business in attracting and keeping customers.

 

If there is not something very special about your business, then the only attraction to your businessis that of a low price.


Book of the Month

"The plan as you go business plan" is the April book of the month. The author is Tim Berry who has also created software on the same topic.

 

I do not agree with the concept of "fill in the blank" or "create the plan as you need it" because my experience has been that you do not have as strong as a connection and understanding to your business plan unless you do it yourself and you dedicate the time to create it.