Analysing Trends

In the previous section we highlighted some forecasting trends, in this section we will look at some simple forecast calculations.

Month Sales
Jan 10
Feb 12
Mar 15
Apr 20
May 25
Jun 30
Jul 35
Aug 40
Sep 30
Oct 20
Nov 10
Dec 30
Total Sales 277

Table 16: Sales Trends example

In order to predict the Sales for the following January we add all the months sales which gives us a total sales of 277, then divide the total of 277 by 12 (this the history we have) which gives us a forecasted sale of 23 for January the following year:

Total Sales Number of Periods
277 12
23.08

Table 17: Average Sales example

2020-03-05T14:56:26+00:00