This explains based on data observed in previous quarters, moving averages method can be used alongwith removing seasonality and irregularity to predict the sales for the future.https://quicforce.ibsindia.org/pluginfile.php/1641/mod_forum/post/3008/sales%20forecasting%20example.xlsx
Sales forecasting example solved in MS excel
This discussion has been locked so you can no longer reply to it.