forecasting higher profits umbrella in the rain


Forecasting: The road to higher profits


One of the hardest challenges for retailers is achieving a balance between estimated sales and actual sales.  Getting it right will generate more profit, while getting it wrong can drive any business to the edge.

Overestimating your sales forecasts creates a raft of potential issues that are a drain on your bottom line:

  • Having to clear excess stock through discounting
  • Throwing away unsold stock that is past its use-by date
  • The costs of overproduction (materials, wages, etc.), compounded by wastage if stock is perishable
  • The extra cost, time and effort involved in storing excess stock
  • Funding costs for buying the stock or producing goods
  • The costs of extra sales staff you thought you needed, but didn’t
  • Additional promotional costs (sales advertising, etc)

Overestimating sales forecasts is one of the biggest contributors to wastage, and nowhere is this more apparent than in the food industry.  Recent research (Food and Agriculture Organization of the United Nations report) estimates that over one third of food produced for human consumption is wasted per year.

The flipside of overestimating is also true.  Underestimating your sales forecasts can mean lost opportunities:

  • Loss of profits because you don’t have enough stock to sell
  • Extra pressure on staff because you don’t have the numbers to deal with the unforeseen demand
  • Brand damage and loss of customers who are dissatisfied with the poor service and lack of stock.

Retail ExampleRetail revenue, costs and profit graph

The example in Figure 1 shows how over or underestimating sales forecasts can have a wide ranging effect on a retail business.  In this case, let’s say our fixed costs are $10,000 per week.  We buy each item for $20 and sell it for $50.  And let’s assume the actual demand is for 600 per week - we would never know this in advance, but it helps demonstrate our point.

The number of items we stock will determine our profit.  If we stock 400 items, our profit will be $6,000 for the week.

The optimal profit is made when our supply matches demand perfectly (as if that ever happens!).  In this case it would be $14,000.

But if we have too much stock, our profits will decline.  If we stock 800 items, our profit would reduce to $10,000, assuming the extra items were unsold or wasted.

The table below shows the difference between optimal profit and actual profit, depending on what your stock levels are to meet demand.


 supply and demand table example


This is a simplified example, but it shows how being more accurate in your forecasting of sales demand and stocking requirements enables you to increase profits.

In a perfect world, demand would remain constant every week.  Unfortunately it’s not that simple.  If you think back to elementary economics, this is what supply and demand curves are all about.  The demand curve is constantly changing.  If it starts to rain, a retail store can expect a downward shift in demand and a drop in sales (unless you’re a home delivery pizza business).  Likewise, the demand curve on a Tuesday is different to a Friday, and a sunny Tuesday is different to a windy Friday.

Demand can be affected in all sorts of ways:

  • Day of week, time of day
  • Seasonal variation: summer vs winter
  • Weather on the day
  • What competitors are up to
  • Pricing: your pricing versus your competitors
  • Changing tastes
  • Staffing (the ability of staff to make sales and create demand)
  • Changes to your product range or availability
  • Promotional offers


Practical Steps to Forecasting

Making a perfect prediction of sales volumes is virtually impossible.  But you can certainly ramp up your forecasting and gain a clearer picture of how much stock you’ll need if you have a better understanding of the factors that influence demand.

Here’s how to go about it:

  1. Determine the factors you think could influence sales demand (e.g. day of week, weather, season) and decide which ones to monitor and record.  Be selective and don’t try to record everything
  2. Decide how frequently you are going to record information about each factor.  Thisunits sold graph visual will probably be determined by the type of business you’re in and how often you produce or order stock.  For a restaurant, this might be daily; for a fashion retail business it might be weekly or monthly
  3. Record and track the information.  Do whatever it takes to capture it.  Microsoft Excel or Google Sheets are a good start.  A friendly geek with database skills is even better!
  4. The amount of data you collect for analysis on each factor will depend on the degree of accuracy you need, the amount of variability in your sales figures needing investigation, and the number of factors and levels within them (e.g. weather: sunny, windy, rainy)
  5. When you have enough information, it’s time to make sense of it all:

i. Calculate or plot the mean levels of your factor.  See Figure 2

ii. Identify any factors in which you see any clear differences, contrasts or anomalies.  In Figure 2 there is clear differentiation for day of the week, so you would want to include day of week in your estimates

iii. Once you have completed the exercise, you’ll have a better idea of what is influencing demand and where you need to focus your attention

There are limitations to this forecasting methodology, and you should not treat your findings as gospel, because:

  1. It has been built only on the factors chosen by you
  2. You are only looking at one or two variables at a time
  3. You are not fully taking into account the interactions between all the variables
  4. Your base data may not be as accurate as you think


Where to next?

The example above is a simple case of examining one influencing factor at a time, but we have seen businesses lift the accuracy of their sales demand forecasting by 5-10% using this technique.  We recommend it as a way of dipping your toe in the water to see the difference even a small forecasting improvement can make to your bottom line. 

Another potential way to begin experimenting with data-driven forecasting is to have a play around with our free Excel forecasting tool - it's designed to take your data and provide you with charts and tables showing how different variables have historically impacted your sales and/or changed over time.

Of course it’s unlikely you’ll be selling just one product as per our example.  The situation becomes vastly more complex (and the value of forecasting more apparent) if we now stock 600 items, spread over 20 product lines, in different sizes.  And imagine what it’s like when you’re dealing with multiple stores!

Looking at combinations of factors influencing sales demand in this type of scenario is a different challenge altogether that calls for more sophisticated analytical skills and forecasting methods (e.g. statistical modelling or machine learning).  With this more complex analysis, you can expect more accurate and robust predictions.

Our focus in this article has been on retail, but the same kinds of issues occur across the board in other business sectors.

We’ll talk about more complex forecasting next time.  Meanwhile, here are three questions to give you a steer when thinking about forecasting in your business:

  1. On a scale of 1-10, how good are you at estimating what your demand is going to be for a given time period?
  2. What factors do you intuitively (or analytically) use to work out the likely demand?
  3. How much does getting your forecasts right keep you awake at night?


New call-to-action