Quantitative Sales Forecasting (3.3.1) Flashcards
What are Moving Averages?
The Moving average is calculated by using the average of several periods of time up to the present. It is a simple, technical analysis tool used to identify the trend direction of a stock
How do moving averages improve Sales Forecasting?
-Raw Sales Data can be erratic and vary month to month
-Moving Averages help level this out and identify trends
What is Extrapolation?
Extrapolation in business is a powerful analytical tool that enables professionals to project trends, forecast outcomes, and make informed decisions based on historical data. It involves extending known patterns into the future, allowing businesses to anticipate changes, plan strategies, and adapt to evolving environments.
How does Extrapolation improve Sales Forecasting?
It makes the Sales sold be for an extended period of time before it goes out of trend.
What are Scatter Graphs?
Chart type that is normally used to observe and visually display the relationship between variables.
How do Scatter Graphs improve Sales Forecasting?
Scatter plot is useful for understanding if two different data points may be related. For example, a coffee shop could track sales of iced coffee vs. the temperature outside to see if there is any relationship between sales and temperature. If there is a trend, they could use this data to better plan for future high-volume sales days.
What are the characteristics of Moving Averages?
-Relies on past sales data
-Doesn’t include external factors
-Doesn’t account for seasonality
-Doesn’t account for dynamic markets
What are the characteristics of Extrapolation?
-Relies on past sales data
-Doesn’t include external factors
-Doesn’t account for seasonality
-Doesn’t account for dynamic markets
What are the characteristics of Scatter Graphs?
-Can give false correlations
-Tunnel vision
-Invest Money in the wrong places
-May miss accurate correlations
What is the acronym for external factors that can affect Quantitative Sales Forecasting?
PESTLE
Political
Economic
Social
Technological
Legal
Environmental
Why is it bad if someone has never done a sales forecast before?
They have a lack of experience and so don’t have and understanding about trends, tastes and competitors and so will limit their ability to accurately forecast.
How do you work out a 3 point moving average?
Get the 3 bits of data so e.g. monthly sales and add the first three and then divide by 3 and put it in the middle of the 3 values. Then move down one and get the next 3 values.
What is Quantitative Sales Forecasting?
Data-based mathematical process that sales teams use to understand performance and predict future revenue based on historical data and patterns. Forecasting results give businesses the ability to make informed decisions on strategies and processes to ensure continuous success.
What are the benefits of Sales Forecasting?
Helps to:
-Employ appropriate amount of staff
-Accurately predict cash flow
-Accurately predict profit
-Effectively plan procurement and capacity utilization
