I have AR data for various past months, basis which I need to forecast next month's AR.
Please help with below questions:
Is excel forecast formula of ETS and normal forecast good and reliable? I am getting high variance from actual.
What is the best way to do this forecast? Use ML?
Is excel unable to predict well because I am feeding data month wise and trying to find only on basis of 6 months?