Point of Sale Software

Here are some Articles from the Blog Subject - stock control -

Find your actual margins

POS SOFTWARE

Often a supplier will tell you the gross margin on their products. Do not believe it? Do you think you should check?

After all, this is a key indicator  in your shop

One big problem here is that in the real world often, this margin they give varies. The other problem is that this margin depends on you getting their price.  Maybe in your area, you cannot get this price. Perhaps because you have too much stock you, you need to discount to get rid of some of it? I am sure you can add many reasons why the theoretical margin is not what you get, and it is easy to find out what is the actual margin you are getting.

 

Go to the menu

 

Now in sales select  the "Discounted Item Sales Summary."

Pick a period, I suggest the last 12 months and now check, I would recommend as a first attempt by the department

Now you will get a detailed report of where you are discounting both by quantity and price.

Knowing which products lines are your most profitable in your shop can lead you to actionable advice.

 

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

Evaluating a stock item

POS SOFTWARE

What happens is that when you go to your point of sale software and check your selling report to see how things are selling. You will find items that are selling well but are making little profit. The question often raised here, is even accepting that the item is not making much, is it drawing people into your shop who buy other products?

Well, we can help you somewhat. The reason I say somewhat will be explained here.  

Go to Register reports.

 

 

Now select "Top N Stock Sales for a Given Period"

 

 

Now put in say a year of sales and ask for the top 100 by quantity. 

Outcomes a report with the top sellers for that year. 

Top sale item by qty

I have not got the heading here, but I will explain. Look at the envelope 

45 is the stock ranking. It is the 45th best selling item in the shop. The 300 is the quantity sold. The next roll is profit, which is $77.45. In comparison, the item on top of it at 44 made the store $1159 profit. Now for many retailers would say to themselves is $77.45 profit enough to justify having this item? Is it enough to even pay the rent, much less the labour and other charges?

Now another issue that most retailers will ask here is, as it does sells well does it bring people into my shop who buy other products? That is very hard to measure, but we can give you an idea.

Go to reports > Sales register > Stock Sales companion sales by period 

Now in options put in say last financial year and put in the product ENVELOPE TUDOR....

Stock companion report

 

Now out pops up a report which will give you a listing of all the items that were sold with this item.

Then at the end will be a total.

Stock companion total

The last number is the profit of $265.01, which is the total profit of all the items sold with this item. 

Now the question is how much of that profit of $265.01 would you have made anyway with or without that profit. That is something you have to decide. 

An analyst like me, as a first-level approximation in the absence of any other information, would probably say

A third would have brought something else in the shop to replace the envelope 

A third would have left and gone elsewhere

A third would not have brought the envelope but everything else.

So I would say the loss involved in dropping the product is 

2/3 x (the actual product $77.45) + 1/3 x ( companion sale of $265.01) = a loss of about $140.

If you can do a better estimate let me know.

 

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

Gross Margin Return on investment (GMRI)

POS SOFTWARE

This is said to be the most important KPI in stock control.

What it measures is how much did you actually make on an item? It is a difficult question to know by gut feel particularly when you have thousands of items that you handle. 

 

This is what the chart looks like in theory.

 

In practice, it is more complex because this chart assumes that you are conscious of what category an item is in. Too often a Low Margin/Low volume item should not be in the shop and is an accident. Also, it is very hard to assess which item is better a High Margin/Low volume item or a Low Margin/High volume item. Also as stock comes and goes, prices and margins change all the time it is very hard to determine by gut feel what is working and what is not.

This is what Gross Margin Return (GMROI) is designed to help you determine. What it does is measure your actual stock items and gives you a financial return figure on your stock? Generally, it is measured in a department or by supplier although I have seen it used for every item in the shop. What it does is tell you where you should look in your shop to get the best return on your orders.

Here is how it is calculated manually which will give you a feel of what it does.

Step #1: Gross Margin in Dollars= Sales x Margin%

So say you sold $1000 last year of an item, your margin was 30%, so your profit is $300.

Step #2: Average stock holding = ((Stock at start of the year) + (Stock at the end of the year))/2

You started the year with $1600 of stock and ended the year with $100 so your Average stock holding = (1600+100)/2 = $850.

Step #3: GMROI = (Gross Margin in Dollars )/(Average stock holding)

GMROI = ($300)/($850) = 0.35

What it tells you is that for every dollar you have invested in stock, you are getting a dollar back to pay all your expenses and buy new stock.

What it tells you is that for every dollar, you invested in that item, you made 35 cents. Of course, no one can maintain a business at that level; I just made a simple example to explain the concept.

If you notice, the calculation itself is almost manually impossible to do for each item. Here are some immediate problem points, items often do not have a steady margin; the 30% is often an ideal that a supplier provides and my stock holding obviously, here varied a lot during the year. Say, for example, my Margin was closer to 25%, so I made $250 and my average stock holding over the year was $100,

My GMROI = ($250)/($100) = 2.5, so I made for every dollar on that item $2.5 

The computer can overcome these problems with GMROI 

Go to register reports

 

 

Select GMROI marked in green

 

 

Now select the date you require. I suggest looking at last year, mainly as it is now the time we are looking back. 

I selected in this shop confectionery.

Out pops a report that looks like this among other items.

 

Now in green, the On-Hand figure is zero; the stock ran out, that would be definitely one to look at what happened there and the one marked in red; it has a negative result; this is almost certainly due to data errors which I will discuss in another post.

As these two items show, to get any use from GMROI you need to export the data into excel or OpenOffice (OpenOffice is free and well worth getting if you do not have excel) where you can edit and remove if necessary bad data.

So on the top left-hand side, click export (where the green arrow is), and click excel where it's marked in purple.

 

 

Now you have a list to review and edit. That is why it must in my view be in excel otherwise you cannot really do GMROI.

High turnover, high GM% and low stock holding are perfect while low turnover, low GM% and high stock holding are terrible.

However high number does not necessarily indicate that all is good, it often means you are under ordering and do not have enough stock, although sometimes it means that the item does really well only very few people come into your shop to get it. So you are not going to sell much more if you bring in more stock. Maybe look at add on sales for that item instead. Low numbers tend to indicate that you are over-ordering.

Only you know the retail dynamics of your shop and it can help and a detailed system of stock control like ours can keep the customer satisfied and you in business.

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

Now take a minute to do a check on your stock levels

POS SOFTWARE

It is currently the last chance you have to check your stock levels 

However, running out of stock now can have a dramatic impact on your business.

We have a unique report which is super fast to run and gives you an immediate snapshot of your stock levels.

In Cash register report, call up the GMROI (see the selection highlighted) in your point of sale software in the reports here.

You can select the list of options you want, and I suggest you go over these options later when you have time.

I recommend doing this by departments or supplier, whatever makes more sense for you. 

Now you get a report like this.

As you can see the items are all listed.

Let’s look at it in detail:

What we are looking for is items with low stock on hand figures, decent sales, and reasonable ROI% figures, ROI% is the return on investment, it is one of the best ways to determine how valuable your stock items are to your business. It is calculated by the (unit sold) x (Profit)/ (Average stock cost) and you need about 3.2 in industry, but as you can see here, there are many items above and below it.

Now it is up to you

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

A quick way to check if you have the right stock for today

POS SOFTWARE

The method we suggest is mirror marketing which is a proven method to make a check on your existing stock lines for the coming day, a week etc.

Here is a step by step method for doing it.

Go to Register Reports marked in green.
 

Now select in stock, "Stock Sold During Period(a) Not Sold in Period(b)"

What the report tells us what was sold in a previous period (a) last year but has not been sold now, so we examine the past year's figures and compare it to what we have currently.

Now, this is a bit confusing but bear with me. What we want to do is compare the week coming in last year with this week which we have figures.

So today is the 19/11/19

So we put in (a) the dates 19/11/18 to 25/11/18 <- note the year. This is last year when we have figures.

 

Now we put in the dates for the coming week starting with 19/11/19 to the 25/11/19 which is what we need to estimate.

In then put in the dates for (a) as of 12/11/19 to 18/11/19 <-last week.

You will also see a lot of different options here, which can help with ordering and giving specific department information. We will talk about these later.

Now what you investigate in the report where you get what was sold last year, but you are not selling now in your current period. The odds are you are out of stock.

 

Primarily with the holiday trends are already starting to appear, you need actual history to make decisions as it is not the same as last week.
 

This is a compelling report for stock control, and it is worth having a look at it in detail.

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

Start looking at Christmas ordering

POS SOFTWARE

Managing stock orders is trouble even in the best of times. Christmas season makes its harder.

So let us now use your Point of Sales Software to see what worked well and what did not last year. You 

This is a step by step method for doing this.

Go to register reports and select the top stock report as marked with the red arrow here

 

You get this screen

 

 

Now I suggest you work by the department as it makes it easier to think about similar products.

Now, look at the red arrows as these items need to be changed to the coming Christmas, the dates for 2018. and you also need to put in say 100 items. After 100, it is rarely worth worrying about.

Then I got this report

 

Now you need to examine this list to see what did sell. You may find many items that did not sell, you may want to examine these too.

What I find useful is doing exactly the same analysis for the year before in this case 2017. It will give you an extra comparison.

 

 

 

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

Narrow your focus

POS SOFTWARE

Every item on your shelf takes up room. Generally, a good seller takes just as much place as a poor seller. It also takes just as much time and effort in looking after it and possibly even more time in dusting, and it earns less.

Here is a picture of a pen rack

I can guarantee you that only a few pen types here are making most of the sales. When I reported on the pen sales on one brand in a shop over three years, I found that they had sold over 450 different types of pens and something like 80% of the profit was in the top 10% of pens. 

 

Towards the end of this list, sales were like one sale in three years, and there were pages of these items. Consider how much profit they are making on these slower-moving items.

What is also particularly interesting is that the most profitable pen was not mainly a high seller. Looking at this list, it is clear the most popular one is a black pen. I bet people came into the store, with one thought about the pen, I need a simple black pen. It is quite possible the range did not sell much of these pens but the convenience. 

The reality is that we cannot be all things to all people. Maybe fewer products would be better than more. Perhaps some of your space could be used instead of having many mediocre items and replacing them with a new category of things that are outstanding sellers. Could that shelf space be devoted to quicker-moving, more marketable items? 

Want to investigate your stock, here is a step by step method for doing this.

Go to register reports and select the top stock report as marked with the red arrow here.

 

You get this screen

 

In this case, here I used the category of Artline pens, I put in 99 million in to make sure I get everything, and as I like to get a long term view, I selected three years.

Then I got the above report

Once you get this right, if you want to increase your stock range in this category, well you can expand your business later.

 

 

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

AI for selling more

POS SOFTWARE

I was invited today to go to the AI FOR BUSINESS SUMMIT  

We have been into AI for many years.

A while ago, I worked out that almost half the out of stock problem in a typical client of ours can be avoided by the use of our AI ordering system in your POS Software.

This can avoid much of the harmful problem in a business such as people coming and walking out because you do not have the product they wanted. What is even worse is if they get frustrated with you not having the stock they want and going elsewhere.

It does not look good either. What do you think of this shop shelf?

What does it say about the business to its clients?

The problem is that 

To be successful today, it is essential that retailers keep in tune with their shop's unique preferences and behaviour. However, there are too many stock items and marketing seasons to do it accurately manually. The best way to do it is with AI. These tools are generally too expensive for small to medium-size retailers unless they have our point-of-sale system because we have embedded it into our software and give it out included in. Others I notice charge for AI or do not have it.

I think it's great system (maybe because I designed it), but I assure you we made it so that it is both simple and reasonably intuitive to use. It does not require much training either to handle. It is less work than manual stock ordering.

An example

Let say you have a basket for tape. You cannot order limitless quantities of tapes.

This is how the tape is set up

Now what happens is the computer tracks the stock on hand, estimates the stock level required for these goods in the period, if it thinks that the stock on hand is too low it can send an order to a supplier with the speed and accuracy that no-one can match.

It is easy to set up, and use for details click here.

With our AI software, you can control your stock with relative ease.

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

Get your stock turns now!

POS SOFTWARE

Stock turns ( often called the Inventory Turnover) is one of the most commonly used measures used in stock control. What it measures is how many times you turn over your stock.

Now that you have done a stocktake, it is the perfect time to do a full review of your stock turns.

Traditionally it is calculated as 

Stockturn = (Cost of Goods Sold) / (Average Inventory cost)

So say you keep a constant stock of 10 items which is your average inventory, and you sold 50 over the year. You would have a stock turn score of 5.

A score that many retailers often look at here is twelve because they tend to pay monthly, if they sell out monthly then effectively they are not paying for the stock anything under twelve they are paying to keep.  

As a general rule, the higher the score of your stock turns the better. This, however, is not always true, too high a stock turn often shows that you are understocked. Say for example you have an item you could sell one a day, but you order one a week. So every week, you have sold one, so at the end of the year you have a score of 50, which is a great score but you have lost 250 sales that you could have had because you could have sold one a day and all you have sold is one a week.  

How to get your stock turn scores.

Main Menu > Cash Register > Register Reports > expand Stock > select/double click the report “Show Stock Turn by Dissection and Item

 

Now here is the sample I produced that shows the stock turns by department.

What to do now

Take time to analyse what these scores are telling you. This will help you to identify the actions required to improve profitability and return on investment.

Now you need to analyse your stock, check each department see what is working and what is not. A score signals bad sales and that you are more stock than you realistically need at any given time. Maybe you have a pricing or quality issue. What you may have in that department a lot of obsolete stock. If so move the obsolete stock to a different department as it is not going to give you fair figures here.

A high score indicates greater profitability and good return on investment, although as I stated, it may also mean that you are not ordering enough.

Remember every figure has a story.

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

Slow-moving stock

POS SOFTWARE

Stock planning in retail is tricky. What you do not want is a shop full of slow-moving stock, you need stuff that sells! Besides the problem that this stock is taking up space and capital, it is also not bringing in customers.

There are several ways to identify what is your slow-moving stock, but as a rule, a stock item that sells under $100/year is slow-moving. The first point before you can do something is to identify all these items.

So go to Register reports > Stock > Slow moving Stock lines

Now I put in a year of sales, and I say anything that I have stock in and have sales of less than $100. 

 

I find it best to work by department separately, so in this shop, I was looking at the stationery department.

Now we got a report of 81 pages of detailed information of all the items that we considered slow-moving. It totalled almost $80,000 worth of worthless stock. 

So we have someplace to start.

Such stock analysis can provide you with insights to improve your decision making that can help you reduce costs and improve sales.

Give it a try.

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

A tip, try a BuyBack to get rid of excess stock

POS SOFTWARE

A lot of you now, preparing or having done a stocktake are looking at a lot of stock that you no longer want. One solution often recommended is to discount it heavily and clear it out. It usually works, but it costs.

Here is another alternative to try out.

Have a word to your supplier of this stock, you are buying off them, and they want to be in your good books. This stock may be useful to them even though it is not to you.

I had a client that made a big order and the supplier agreed to credit most but not all of these unwanted items. So yes the rest went into a clearance bin, but the bulk was replaced with sellable stock. They did not even get charged a restocking fee. My client stated to me it was to them, it was like this money they found in the street.

Food for thought?

 

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

ABC Analysis and 80/20 Rule

POS SOFTWARE

You have probably come across the ABC inventory analysis called often the 80/20 rule or sometimes the Pareto Principle.

What it is, is that no matter what you measure, website hits, advertising expenditure, pilot kills in war, shop sales, political influence, etc. It all seems to come down to something like this that somewhere about 20% of the total gives about 80% of the results.

So everyone wants to find the 20% because that is giving almost all the results.

* 20% of your customers will bring you 80% of your business

* 20% of your products will bring you 80% of your business 

* 20% of your staff give you 80%

* 20%  of your advertising gives you 80% of the results.

* 20% of the shop fittings give you 80% of your business 

And so.

Now in inventory control, the ABC method identifies this and divide all your stock into three groups.

The first we call the category A-lines. They are the most valuable stock items you have. These are 20% of your lines that give you your 80% sales and profits.

 We then have the category B lines. They do pay for themselves but not a lot.  As a rule, they are about 30% of your lines and account for about 20% of your sales and profit.

Finally, we have the category C lines, which typically are about 50% of your stock lines and give about 5% of your sales and profit. They also usually take up most of the shop's funds.

Now the idea of the ABC stock control method is to identify your A, B and C items and then 

* A lines should be monitored all the time. You do not want any out of stock situations with them. 

* Your C-lines should be pruned if possible if they must be kept then, reduce the stock holding on them

* Your B-lines do pay their way, but you would not go out and order a lot.

Now if you go to stock reports > select stock N sales for a given period, choose now as a number of items 30,000 as we want every item.

Now run this report with a decent period. I would suggest running the report by profit, but this may depend on your business philosophy as some may prefer a number of units sold.

Now the first two pages of the report will be your A-lines, on those you need to concentrate. 

The last 80% of the pages, you should ask yourself, do I need these lines?

I did some reports recently for one of our clients a lottery agency, and I used excel to produce some graphs that will show you I think quite dramatically how it works as it makes interesting reading. They had in the shop 21,000 stock lines.

 

The number of sales ranked in order of top selling lines here.

50% of the sales came from 45 stock lines about 0.21% of the stock lines 

80% of the sales came from 4615 lines approximately 21.76% of the stock lines 

 

Here is the profit percentage by stock lines

 

20% of the profit was from 135 about 0.64% of the stock lines 

50% of the profits came from 1,873 about 9.35% of the stock lines 

80% of the profits came from 7,374 approximately 34.78% of the stock lines 

See how you go and as always let me know if you find something interesting.

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

Your duplicate supplier costs

POS SOFTWARE

In a survey in the last Global Retail Theft Barometer is released, which is the most significant and authoritarian report in the world on shop theft and supplier losses in retail businesses, it came up with a percentage breakdown in Australia by type.

  • Dishonest employees will be about 25%
  • External - shoplifting (39%)
  • Administrative (accounting mistakes, pricing errors and process failures) about 23%
  • Supplier fraud (no delivering what they said) 13%

The last two, in particular here, what it shows is that in those surveyed about 36% of the total losses are in the supply chain. This shows the importance of a good computer system in retail for stock control. 

Now the first item which I will discuss today on this is the problem of duplicate supplier codes. One problem is that you order and the process by supplier codes. The problem is that many suppliers have for various reasons what you consider different products with the same supplier code. As such you could easily order in the wrong product. 

Now go to reports

Duplicate supplier code menu

 

Select duplicate supplier codes by supplier.

Now select the basic report, we can discuss the extras later.

Now out will appear this report

Duplicate supplier code report

In it, you will have a listing of items by supplier code for you to investigate and hopefully fix.

Best get started with it.

 

 

 

 

Comments

One of best functions in pos browser is that it links the stock into your accounts payable section. Because you do that well you have a check so reducing both with we used to do with overpayments and paying twice. Can you please discuss this section more?

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

Safety Stock

POS SOFTWARE

Safety stock is an additional quantity of an item held in the inventory to reduce the risk that the item will be out of stock. It acts as a buffer stock in case sales are greater than planned and/or the supplier is unable to deliver the additional units at the expected time.

Safety stock

According to Wikipedia, safety stock is:

Generally, it is a small, surplus stock that you maintain on hand, to protect from variability in market demand and your supplier lead time. You carry it because you do not want to run out of stock which might both severely impact your bottom line and also do untold damage to your customers’ view on you.

The theoretical formula used to calculate safety stock:

Safety Stock = (Max Daily Sales x Max Lead Time in Days) – (Average Daily Sales x Average Lead Time in Days) 

You can calculate this using our software, click here.

The other point I recommend is running this report which will give you a feel of what the actual problem you are facing here.

Go to reports > stock > Sold Out or Selling Out Stock Lines

In theory, this report only shows items that are selling well in the nominated period, but that you are running out of, so you need to check on them ASAP. This can help you make sure you have adequate stock.

However, it does much more, what it also alerts you is whether items are not properly entered into your system as the stock on hand figure is negative as you can see by the example below.

 

 

I would recommend running this report regularly as it will alert you to both out of stock situations and errors in invoicing.

 

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

ROI for a point of sale software

POS SOFTWARE

Return_on_investment.jpg

Here is a list of some advantages that a retailer would have using a point of sale software.

These figures I quote is based on industry figures, and I am assuming a shop with sales of about $500,000 EX GST/year with a 30% margin

Sell more

There is a lot more information available to the retailer which allows them to target short-term trends better and measure results faster. As you will get a full history of your customers, you will be able to track their purchases and so develop better long-term relationships. 

Generally, you can expect an improvement of about a 1 to 2%, so we are looking here at about $5,000 to $10,000 sales increase so about $2,250/year

Buy better

By giving more control and information to the retailer, they can buy better, take better advantage of special offers.

Also, the retailer is getting better information on what is selling and what is not selling so avoid buying the rubbish so generally about 1% better so $500,000 x 70% x 1% = $3,500

Shrinkage

Better controls and better monitoring helps a lot.  The major causes of shrinkage are 

1) Customer theft - The five finger discount

Your stocktake reports will tell you better than manual the location and type of items that are disappearing. 

2) Damage - it happens goods get dropped in the shop, too much sunlight on an item ruins a book, etc. Much can happen between you get the item and the customer taking it.

Generally, there is little a POS system can do here to help. 

3) Supplier fraud - This happens all too often, for example, a typical example is that a supplier bills you for goods shipped, but for some reason, you did not get all these goods. Even large suppliers do this.

Point of sale systems is very good at helping here. With some people, just the saving here has paid for the system. 

4) Staff theft - This is a big problem in some shops in others it is nearly zero.

At least with a POS system, you can monitor much of it better. In one site recently we were able to by tracking the shifts, tell the owner the likely person that was taking money from the till.

I would expect overall at least a 1% improvement in shrinkage. A $500,000 business, at 70% margin saving 1% a year we are looking at $3,500

Bottom line:

Increased profit on improved sales of $2,250/year

Better buying and more accuracy in buying $3,500

A decrease in shrinkage of $3,500

Overall saving about $9,250 a year on $500,000 turnover.

And another thing

There are extras that I have not qualified such as 

Time-saving

I would expect on an average about an hour a day of time saved. So say 5 hours of work a week.

Reduced stocktake costs

Many of our clients used to hire professional stock-takers, well there is no reason too with a POS system as you can do it yourself 

VIP marketing

Most retailers today big and small do some VIP market and do this effectively you do need a computer

In addition to that

You have improved control in the business

A retailer with a point of sale system is much more in control, even if nothing else it makes most people feel much better.

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

Point Of Sale Stock Control

POS SOFTWARE

Retail stock control

Fact is

It does not matter how many products you sell, our Point of Sale Software can keep you informed of your stock levels just to help you make sure that you do not run out of the relevant stock on an item. 

According to one study, I read the main cause of these out of stock situations, was 72% of the time the retailer fault?

This is what your stock levels should look like

With our demand automatic ordering, this can be automatically implemented with very little work for you. It can generate profitable reports virtually instantly. If you get a run on a certain item, it will be picked up immediately by the AI ordering system and can issue an order with almost zero work to you.

And the best part?

  • Reduced holding costs - as you are not holding that much in stock.
  • Lower ordering costs - as you are buying only what you need.
  • Improved throughput rates - as you are ordering only what you need.
  • Decreased stock out occurrences - as the computer is checking continuously
  • Overstock wastes - this is often caused by people overestimating what they require.
  • Improved stock accuracy - you have a continuous check on your stock.
  • Higher customer satisfaction - you have the stock you require.

Can you really afford not to do it?

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

Stock that is not performing

POS SOFTWARE

Do you have some slow-moving stock items?

Maybe you can cut back on their space to make more room for your profitable products?

I suggest that we do this in two stages. 

To begin with

Firstly let us find the items that are the slow movers

Go to Register reports > Stock > Slow moving Stock lines

 

Now call it up here

As you can see I am looking at the stationery department over a twelve month period for anything that I have sold less than $100 and am now stocking something.

Now out pops a report in this case of 81 pages of detailed information of all the items that match this condition in this case, we have almost $80,000 worth of worthless stock.

Now check them out, pull out what you do not want to keep and put in your sales area.

Once you’ve got this done

I suggest that you do a report of your top selling stock items and at those items that are selling well. A rule of thumb in retail is double the space of an item increases its sales by 50%. So the idea here is we are going to replace the marginal items with those that sell well.

Go to Register reports

Now select "Top N Stock Sales for a Given Period."

Now the following comes up.

Now put an appropriate period the default here of a day is not enough for this but I just wanted a quick report for illustration.

Out comes a report with the top sellers

Now, these products need to be checked that you have the right display for each of these products.

Note anything, not on this list you also need to look at as they are marginal..

The bottom line is this

You do not want to pay to a landlord for the space to stock items that do not sell.

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

EACH STOCK ITEM HAS ITS OWN TREND

If you are seeing that you need to discount a lot to sell stock you are overstocked, it is a sure sign that you need to do something. As a punt what is happening is that you are overordering on some items and probably underordering on others. What often we see in retail is that our memory is by definition the past and the memory remembers old top sellers but what we need is the top sellers today. Here is how to identify what is selling well now to check that you have enough stock for tomorrow and it is very easy in our point of sale system.

Go to Register reports

Register reports POINT OF SALE

Select the "Top N Stock Sales for a Given Period"

Top Stock Items Point of sale

 

Now out pops the following.

 

Now select a day, as it is an old database I put in an old date. Usually, you would put in yesterday or today, just make sure you get close to a full day of trading.

 

Top Stock Items reporting

 

Now you get a report with the top sellers now

 

Keep track of top selling items

 

 

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions. Image CAPTCHA
Enter the characters shown in the image.

Christmas preparations 2017

POS SOFTWARE

There is less than 10 weeks to go to Christmas, so I suggest you start looking at whether you have enough stock.

A good way of starting your investigations is here on your POS system.

Go into cash register reports

 

Now pick "Select Top N Stock sales for a given period" shown with a green arrow.

Now select initially the period from 18/Oct/16 to the 16/Jan/17

I am going to ask for a report sorted by profit.

 

This gave me a list of the most profitable items.

Checking

Now look through the list to see what you sold during this period last year and check with the stock on hand (SOH) to see if you think you have sufficient Make notes

Review

These are the items that worked for you last year. The odds are that most of them will work again. For many, you need to check with your suppliers the status of stock ordering and receiving from them over this period after all buying a big order is the last resort.

Also what you need to check if they are a excellent seasonal seller are they in a good position? Do you have proper displays?

Is there any wiggle margin perhaps you can increase your prices slightly on these items?

Furthermore, I do suggest running this report again sorted by numbers as this shows what people are actually coming in to buy, remember a buy in retail is often called a vote.