We need to build a forecast in excel from prior sales data. We can give all the old data in excel format ; however the new data will need to be pulled from our sql database.
The sales data will be sorted category wise and forecasts will need to be:
- based on branch
- we need to account for the outliers (some months in the past we had low stock thats why our sales were low).
- Account for the ratio between margin and sales forecast . We would like to set a minimum margin we need to achieve then correlate it with sales forecast targets.
This sales forecast will be linked to:
- inventory (we can only sell what we have).
- ordering (majority of our goods will have a 3.5 month lead time)
About the recuiterMember since Sep 7, 2017 Pedro Pereira
from Parana, Brazil