This free template provides a 12-month sales forecast and sales history for previous years, but you can customize it to display six months, 14 months, 36 months, 48 months, five years, or any other length of time that matches a project or initiative. Forecasting database in Microsoft Access for sales in Dallas, Fort Worth, Plano, Texas. Sales Forecasting Application. Standardizes, consolidates and evaluates regional forecasts of manufactured goods (in this case soft drink sales) at corporate level.
If you have historical time-based data, you can use it to create a forecast. When you create a forecast, Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. A forecast can help you predict things like future sales, inventory requirements, or consumer trends. Information about how the forecast is calculated and options you can change can be found at the bottom of this article. Create a forecast![]()
Customize your forecastIf you want to change any advanced settings for your forecast, click Options. You'll find information about each of the options in the following table.
Formulas used in forecasting dataWhen you use a formula to create a forecast, it returns a table with the historical and predicted data, and a chart. The forecast predicts future values using your existing time-based data and the AAA version of the Exponential Smoothing (ETS) algorithm. The table can contain the following columns, three of which are calculated columns:
Download a sample workbookNeed more help?You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice. Free Sales Forecast TemplateRelated TopicsComments are closed.
|