3.3.1-Quantitative Sales Forecasting Flashcards
What’s is Quantitative Sales Forecasting (QSF)
QSF is a statistical technique which uses historical data to make predictions about the future
What a business used QSF info for?
• Organise production
• Organise resources in the business e.g. employees, premises, raw materials
• Organise marketing to back up the sales predictions
QSF Formula
Step 1) Take the first 3 months data and calculate an average
Step 2) Now leave out the first year and calculate the average for the next three years
Step 3) Now add all your calculated averages to the table
4 Quarter Moving Average
• As a business manager or owner you may need to look at your sales data in terms of the 4 seasons in the year
• As your sales may fluctuate widely but you still need to schedule your production on a month by month basis you would use this technique
4 Quarter Moving Average Formula
Calculate average of the 4 quarters in a year