Required Budgeting & Forecasting,Financial Forecasting,Statistics,Supply Chain Management freelancer for Forecasting of supply chain in excel from SQL database job

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 that's 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

Skills & Expertise Required

Budgeting & Forecasting Financial Forecasting Statistics Supply Chain Management