skip to Main Content

Sales Forecasting Template

4.2 (5 reviews)

Sales Forecasting Excel Template will provide a projection of what your business sales are going to be in the future!

$49.95

Learn more about License Types


Someka refunds icon

30-Days
Return

Someka one time payment icon

One-Time
Payment

Someka direct download icon

Instant
Download

TEMPLATE DESCRIPTION

Big companies in FMCG industries invest a lot of money in ERP systems and training to get their employs capable about how to use those systems. This demand planning excel tool has the advantage to work as the same way as Forecasting module, it has the versatility to add new SKU’s (Stock Keeping Unit) with their own automatic code number created and calculate Sales Forecast according to Holt-Winter’s Exponential Smoothing Method.

We have built this Sales Forecasting Template to help you to calculate and release your sales according to the corrected historical data monthly, in the same way, ERP systems works.

With this tool, you have the chance to calculate and release your sales forecasting. Here is what you can do:

  • You can add or create new products in a simple Sales History Data Worksheet with an automatic code number for each SKU.
  • For mature products, you can also upload your corrected sales history data in related Worksheet.
  • In Set Forecast Worksheet, you can calculate your sales forecast by changing the statistical constants: Level, Trend, and Seasonality according to your knowledge as demand planner to reduce MAPE (Mean Average Percentage Error).
  • You can adjust your final forecast on a quarterly basis watching changes in the dynamic

SALES FORECASTING TEMPLATE FEATURES:

Basically, this Excel template consists of 3 main parts:

Sales-Forecasting-Template-Someka-S00-1

Now, let’s check the three main sections of our Sales Forecasting Template:

  1. Sales History

In this sheet, you can add or create new products by filling the blank fields. In this case, new products must be forecasted under expected sales assumptions according to Min. Expected Sales and Max. Expected Sales which represents our sales history basis.

Sales-Forecasting-Template-Someka-S02

This section works as a simple Master Data setting up an automatic code when you save your new product. As Master Data, statistical constants for Level, Trend, and Seasonality will take 0.3 as default value. You will be able to change these values when you execute sales forecast on each new product. Other constants for quarter adjustments on final forecast are going to be set up on 100% as the default value; you can also change these values on forecast execution.

In case you have Mature Products as data coming from another system, you can also import this data by pressing the UNLOCK DATA button and fields will be unlocked to paste your own Sales History Data.

Sales-Forecasting-Template-Someka-S03

We recommend at least 4 years of corrected history for an accurate forecast. In case you don’t have enough sales history, we recommend you complete missing values with moving average.

Warning!: Do not input zero values as sales history; in that case, complete the sales history with moving average. Save your input data by pressing the SAVE CHANGES button.

Finally, for uploaded mature products, you should set up the values of the statistical: Level, Trend, and Seasonality and Quarter Adjustments on 100% in Final Forecast worksheet.

  1. Set Forecast (Winter’s Exponential Smoothing)

In this section, you are going to be able to run and calculate your Sales Forecast. The only thing you have to do is select any product from object list.

Sales-Forecasting-Template-Someka-S04

After that the default constant values will appear on Current Constant(s) fields; now you are able to change statistical constant values: Level, Trend, and Seasonality at the right side scrolling at the object list with values between 0,001 and 1,000.

Sales-Forecasting-Template-Someka-S05

Dynamic Chart will change automatically. We recommend lower values to cover corrected history as much as possible and get more accurate forecast reducing MAPE (Mean Average Percentage Error).

**Take into account the constant values close to 1,000 which will set your calculation as Naive Forecast.

Furthermore, as a Demand Planner, you may know special promotions lead by marketing colleagues or  some fluctuations on market share; in this case, you are able to adjust your calculated forecast on the quarterly basis with final sales forecast at the right side on “Error Indicators & Adjustments”

Error Indicators-Adjustments-Someka-S06

Finally, do not forget to save your sales forecast pressing the “SAVE FORECAST” button.

Sales-Forecasting-Template-Someka-S07

  1. Final Forecast (Last Estimated Forecast)

In the last section of the Sales Forecasting Template you will see your forecast values after saving your executed forecast. Your new forecast is now 48 months sales forecast in the planning horizon and you will able to change it anytime you want, just get back Navigation Menu and press the “Set Forecast” button.

Last-Estimated-Forecast-Someka-S08

Finally, do not forget to update your real sales according to section “SALES HISTORY DATA” at the beginning of each month. Updating your real sales history will be your basis to run the next Sales Forecast with your new Sales Forecasting tool.

SALES FORECASTING TEMPLATE FEATURES SUMMARY

  • Unique Excel template to perform Sales Forecast by SKU
  • Works on Windows
  • Ready-to-use Sales Forecasting
  • No installations needed
  • Dynamic Charts
  • Compatible with Excel 2010 and later versions

This Sales Forecasting Template is ready-to-use and provided as is. If you need customization on your reports or need more complex templates, please refer to our custom services.

PRODUCT VIDEO

Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

5 reviews for Sales Forecasting Template

  1. Selin

    Hello,
    I would like to purchase the Excel sales forecasting template. However, my organization’s business (e-commerce sales) grew after 2019. We only have two years of solid sales history, that would be most indicative of the sales going forward. Would this template still work with 2 years of sales history?
    Thank you in advance for your time and help!

    • Someka

      Hi Selin,

      First of all, thanks a lot for your interest!

      We recommend our customers filling the previous year’s input with the mean value of the data that you already have. This way, these cells are not left blank and they also do not affect the calculation.

      In addition, the recommended values used for Level Shift and Trend should be between 0,030 – 0,500 and Seasonality values between 0,350 – 0,700 to get accurate predictions.

      We also have a product video that we showed the features of the template. Did you have a look at it also?

      Hope our explanation helps you. For further questions, please do not hesitate to contact us.

      Kindly regards,

    • Selin

      Hi!
      Thank you so much for your response! So is there no way no to build the model off of 2 years of history? The years inputted into the template cannot be deleted, correct?

    • Someka

      Hi Selin,

      The template is created to input the optimal amount of data to get more accurate results. So it would be better to fill all the cells to get more certain results in the existing template.

      However, if you need totally different or customized Sales Forecasting Template which is just to calculate the most accurate results with 2 years of data, our development team can create a customized template for you as well.

      For further questions please do not hesitate to contact us anytime. Thank you!

    • Selin

      Thanks a lot for your response and your time! I will contact them.

  2. Joe Levy

    Hi! I bought the Sales Forecasting template. How do I add more than 200 items? We have like 400.

    I unlocked and tried it, but the set forecast section only recognizes first 200.

    thank you!

    • Someka

      Hi Joe,

      Thanks a lot for your interest!

      For the Sales Forecasting template, we have already left spaces to enter 200 items. If you need to add more, you can also save the file as a different name and reuse it for the other 200 items. However, you can also have a look at our customization process to enlarge row numbers up to 400. Because you won’t be able to use the rows you have added manually without using further formulas and arrangements behind the template.

      Hope that helps!

      Best regards,

  3. stuartsherifson

    Great job! I was looking for something to calculate the future amount of quantity of products that I’ll sell. That works perfectly for me.

  4. Luigi Robin

    Perché non supporti l’italiano? Trasformare il modello in italiano richiede un lavoro manuale letterale!

    • Someka

      Hello Luigi! Thank you for your feedback. Unfortunately, we give support in English at this moment. But our templates are easy-to-customize so everything written in English in the template can be written in Italian either!

  5. claudianowak

    Perfect! can you suggest me something about forcasting models that what model will be better for seasionally forcasting of product on attribute level ?

Leave a customer review

Your email address will not be published. Required fields are marked *

RELATED EXCEL TEMPLATES