Sales Forecasting Models in Excel

Description
During many consulting projects, you may be asked to forecast the sales of the firm or check sales forecast models done by the customer. Sales forecasting requires a specific approach to data and also a lot of creative, out-of-box thinking, to address the issue of insufficient data and changing environment. In this presentation, I will show you how to do fast and efficiently basic sales forecast models in Excel. We will create a relatively simple sales forecast. Nevertheless, they will significantly help your customer define strategy and decide whether he should open a new factory, enter a new field, buy a business. We will NOT get into complicated models, forecasts as in most cases you will have neither time nor data to do them. It would also require a wider knowledge of mathematics, statistics, econometrics, and usage of more advanced tools than Excel. We have prepared 6 examples, case studies of sales forecast models from consulting projects. We will look at sales forecasting in consumer goods, commodities, retail, and services.
On top of that, we have added a presentation that will show you methods that will be sufficient in 70% of the cases and can be done with the knowledge of basic Math. Such basic sales forecasts are especially important during Strategy projects, M&A projects, and business development projects. In such projects, you want to get fast rough sales forecasts using simple methods. A similar approach as we will show in this presentation can be used as the starting point for budgeting models