This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
As with most of the predictive tools here, they're very easy to get working, you just need to be wary of the: way your data looks; ways in which you're configuring the tools; you're interpreting the results.
There's not a huge amount of data here (do you have more?), and in my experience these work better when looking at a week/month/quarter level, but I've included a short example against your data (with a few years already added) attached here. The key is to ensure your years are in rows, and you tell the model that you're working in years:
For further info, I'd recommend going into your Designer and clicking Help -> Sample Workflows -> Predictive Tool Samples -> Predictive analytics -> 15 Time Series which has some great examples of all those tools
Hope that helps and gives you a start point at least!
Yes you can do ARIMA all you need is 2 records. Also, there is no point in my opinion of forecasting COGs or Profit because they are directly correlated to Revenue. Just Revenue would suffice and then proportionate the expenses based on history from that predicted value.