I was just wondering if someone could help me out. I am looking at introducing cash flow statements and sales forecasting into the company I work for, but am struggling to work out future sales. Now I know a sales forecast is just a predicition and will never be 100% bang on, but I still want the numbers coming up to be realistic. I work in the construction industry so the business doesn't sell products, we sell a service, which varies from job to job. Now I was just wondering what would be the best way to produce this sales forecast? - I have the last 3 years sales data and this years current sales. I am looking at putting this all together on Excel and have tried using their forecast functions, but they are bringing up really low numbers, like half of what we have ever done, which doesn't make sense. Now I know that with the pandemic our sales were hit dramatically in April and May but June was a very decent month and this month looks to be the same. What calculations do I need to do to work this out? I think simplicity is key so I literally just need it to forecast sales for this year and bring up relatively realistic numbers.
Any help on this would be greatly appreciated, thanks!