4.3 Sales Forecasting

(HL ONLY)

What is Sales Forecasting?

A quantitative method to predict a businesses' level of sales by using past figures and data to extrapolate the current trends or possible sales in the present. It can be inaccurate or outdated due to the historical aspect.

Advantages:

  • Better Cash flow

    • Stock control

    • Productive efficiency

    • Budget

    • Borrowing

Disadvantages:

  • Limited Data

  • Inaccuracy - Due to prediction

  • Relevancy - Due to history

  • External Influences

Types of Sales Forecasting

Created by: A. Winter ('19)

Factors That Forecasting Methods Depend On

Created by: A. Winter ('19)

Advantages & Disadvantages of Sales Forecasting

Created by: A. Winter ('19)

Example: Acosta Adventures

Moving Averages:

A more accurate method of identifying trends so they are a more useful tool for sales forecasting.

  • Used to establish underlying trends by smoothing out the variations of data caused by seasonal, cyclical and random variations.

How to do a 3 point moving average:

  • Work out the mean of the first 3 data sets

  • Repeat this for the next 3 data items

How to do a 4 point moving average:

  1. Mean of the first 4 months

  2. Mean of the next 4 months

  3. Add these 2 means together and divide it by 2

Explanation:

  • The green line represents the 3-point moving average which is essentially the sales forecast

  • The red line represents the real sales which as you can see fluctuates due to the seasonal factor of this business

Next Steps:

  • Apply a line of best fit to produce the 4th quarter sales forecast and add 0.8 or the variation integer