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 Mar 14, 2020
Ajay Beriwal
from Wanica, Suriname

---

---

Offer to work on this project closes in 50 days!
Are you interested in this Opportunity?

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