I am trying to forecast a very typical sales data. I have tried Arima, ETS, Holtwinters and even neural networks but I can't get a model with more than 40% accuracy [Absolute sum of(forecast-Actual)/Sum of Actual]. Can anyone suggest me how to proceed?

Here is the data https://drive.google.com/open?id=1uugpk53hMyF8ncl30vkkwhuJeVYFEUql

  • $\begingroup$ You've got a number of variables listed. Are you trying to predict all of them? $\endgroup$ – TheEnvironmentalist Oct 1 '19 at 5:04
  • 1
    $\begingroup$ Just from eyeballing your data, you seem to have many intermittent series. These are typically very hard to forecast more accurately. If all you care about is minimizing the wMAPE, consider forecasting a flat zero for all highly intermittent series (Kolassa, IJF, 2019). $\endgroup$ – Stephan Kolassa Oct 1 '19 at 6:23
  • 1
    $\begingroup$ @TheEnvironmentalist: I would presume each line to be one stock-keeping unit (SKU), and each column to be a month, so yes, each line would need to be forecasted separately. This is a very common setup in sales forecasting. There may be hierarchies involved that might make forecasting easier, but we don't know. $\endgroup$ – Stephan Kolassa Oct 1 '19 at 6:25
  • $\begingroup$ Yes, each line is one stock-keeping unit (SKU) and each column is a month. $\endgroup$ – Nish7416 Oct 1 '19 at 11:36
  • $\begingroup$ @StephanKolassa Sure I will try that. Thanks. Can you give me code in R programming for forecasting this data? $\endgroup$ – Nish7416 Oct 1 '19 at 11:45

Browse other questions tagged or ask your own question.