Sales forecasting and demand planning spreadsheet for Excel
Permanent License for:  

Approx. 49 EUR / 62 USD per user

Purchasing implies agreement of the User License

Includes 1 years email support + 30 day money back guarantee

On completion click Return to Merchant to download spreadsheet

Sales Controller

Sales forecasting and demand planning is an essential part of a company's marketing plan, helping managers to analyse new market opportunities, plan where to concentrated their resources and control their company’s performance efficiently and effectively. Our sales forecasting software for Microsoft Excel, Sales Controller, analyses your past sales statistics in an attempt to spot trends that can then be projected into the future.

Forecasting anything is difficult to do accurately and sales forecasting and demand planning is no exception. The further into the future you try to plan demand the less accurate sales forecasting becomes, but an educated estimate is better than none at all. And, even though trends based on historical sales data provide no guarantees for the future, Sales Controller does give you the basis on which you can add your own insight and judgement.

Our statistics software for sales forecasting  and demand planning is the ideal tool for developing marketing plans and sales forecasts. It is designed to complement our budgeting and business plan software, Budget Controller, allowing you to quickly add you sales forecast as the basis of your business plan or corporate budget.

Monthly sales forecasts can be projected over a period of six years and up to ten products lines or sales items can be forecast in each file. You can create as many Sales Controller files as is needed, so the number of sales items that can be forecast is limitless.

If you have a large number of sales items or product lines to forecast, the Sales Controller will save you time by being able to produce forecasts in batches of ten items per file. In addition, the automatic curve fitting function is another time saving feature.

Sales Controller analyses your past sales history for patterns in the data that can be projected into the future. Sales Controller extracts four components from your sales history: the trend, seasonal, cyclical and erratic events components. The trend, seasonal and cyclical components are used to build the forecast. Erratic events such as strikes, storms, machinery breakdowns, etc. cannot be forecast accurately using statistics software but nevertheless shouldn't be overlooked.

Sales forecasting and demand planning using any form of statistics software, simply provides a sound basis on which to add your own experience and judgement of what might happen in the future. So, for accurate sales forecasting and demand planning, Sales Controller, like all statistics software, should be used in conjunction with expert opinion.

Product Features

  • Familiar and intuitive Excel interface.
  • Context sensitive help text.
  • Simple menu navigation.
  • Comprehensive users guide.
  • Up to six years of sales history can be entered.
  • Forecast can start in any month.
  • Maximum of 6 years can be forecast in one file. No limit if multiple files are used.
  • Maximum of 10 user defined revenue streams can be forecast in one file.
  • Trend line equation calculated for each revenue stream.
  • Fitting the business cycle can be optimised automatically.
  • Seasonal index calculated for each revenue stream.
  • Forecast graphs and tables for each revenue stream.
  • Graphs and tables display actual data compared to predicted data to determine forecast accuracy.
  • Link Sales Controller to other spreadsheets or to Budget Controller for automatic updates.
  • Multi-lingual support.

Spreadsheet Screen Shots

Based on Microsoft Excel our forecasting software is easy to use

Familiar Excel Interface

Familiar and intuitive Excel interface with simple menu driven navigation for easy access

Forecasts can start in any month based on up to six years of sales history

Forecast Based on Sales History

Forecasts can start in any month based on up to six years of sales history. We recommend using at least 3 years of sales history to improve the chances of Sales Controller finding the trends, especially when your sales are seasonal in nature.

Sales Controller has context sensitive help text

On Screen Help Text

Context sensitive help text complements the User Manual.

Our sales forecasting software is multi-lingual

Multi-Lingual

Multi-lingual support. Currently in English and Portuguese but the Language Dictionary permits users to enter a second language of their choice. The Language Dictionary can also be used to change text labels to descriptions that are more appropriate to your own organisation.

Forecast up to 10 products in each Excel spreadsheet

Forecast Ten Products per File

Enter or copy / paste up to six years sales history for a maximum of 10 products per file. There is no limit to the number of products that can be forecast in multiple files.

Forecast the trend component in your sales

The Sales Trend is Automatically Calculated

Regardless of other fluctuations, there is generally an overall sales trend. The trend is basically a straight-line calculated automatically using linear regression. The trend equation is incorporated into your final forecast. It is displayed here for information purposes only.

Forecasting the business cycle

Forecasting the Business Cycle

Sales are often effected by swings in general economic activity as consumers have more or less disposable income available. These fluctuations normally follow a wave-like pattern being at a crest when the economy is booming and a trough in times of recession.

Forecasting the business cycle is semi-automatic

Excel's Solver Fits the Business Cycle

Fitting the Business Cycle is semi-automatic. Once you have fitted the curve roughly by eye, Sales Controller can optimize the fit automatically.

Forecasting the seasonal component in your sales

Forecasting the Seasonal Component

There is normally a distinguishable seasonal pattern to sales during the year caused by such things as the weather, holidays, local customs and general consumer behaviour. Sales Controller calculates this automatically and incorporates it into your forecast.

Compare the sales forecast with your sales history

Compare Forecast Model with Sales History

Sales Controller now compares its forecast model with your sales history to show you how successful its been in finding and forecasting the trends in your data.

The final forecast combines the trend, business cycle and seasonal component

Review Your Forecast

Having established past trends, Sales Controller simply combines and projects them into the future to form the basis of your forecast. You can now copy / paste your forecast into Budget Controller or your own spreadsheet for further discussion and review. Learn more about the the principles of sales forecasting...

Top of Page