Forecasting of supply chain (sales/ordring/cashflow)in excel from sql database

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)
- cashflow
About the recuiter
Member since Sep 7, 2017
Pedro Pereira
from Parana, Brazil

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions