How to calculate sales forecast with statistics for 2.5 years?

Question

excel

There is an online pizza restaurant. Sales statistics for 2.5 years.
I’m starting to pump it in all respects (SEO, contextual advertising optimization).
You need to see how much sales have grown in the course of my work. Compare with respect to the "leave everything as is" option.
How to build a sales schedule for the next six months?

Answer 1

The simplest is to extrapolate data for the past two years. For example, if sales increased by 15% in the second year, then you need to add 15% to the value of the previous year.

Answer 2

For a forecast with at least some certainty, it is advised to have a stat for 10 years, including the crisis 08-09
Just build a graph with smoothing in excel - it will show you more

Answer 3

Make an approximation in excel

Answer 4

It's hard to give advice without seeing your data. But you can build a linear regression. Building is easy and fast. And according to the model, you can make a forecast

Answer 5

Here with xls files everything is step by step www.4analytics.ru/modeli-prognozirovaniya.html