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




Pedro Pereira Brazil


OpenDec 2, 2018
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

Skills & Expertise Required

Budgeting & Forecasting Financial Forecasting Statistics Supply Chain Management 

Offer to work on this project closes in 69 days!

Submit A Proposal

Share this project with your friends

Freelancers You May Hire

Here are our top professional picks for you to hire

Similar Projects

Analyze historical financial data a...

We are looking for an mid-level intelligent data analyst/extractor, who can look at the financial performance of different asset classes, calculate returns for these asset classes over several more

Fixed, $100.00

Live 1 hr Math Tutor

We will both be online at a predetermined time and you will answer questions I have regarding functions, linear functions, quadratic equations, etc. I will need ongoing help, so I will rehire if more

Hourly, $28.00

Need a calculator for a statistical...

I am looking for someone to develop a calculator that will know the probability of a card being generated next in a total of 6 decks containing 52 cards each. I will need this calculator to be more

Fixed, $100.00

Personality assessment open source

I am looking for someone to find the top 5-6 open sourced personality assessment tools.
Put them in a google doc and tell me what the pros and cons are.

This would be used as a Pre more

Fixed, $50.00

5 Year Profit Project- Online Servi...

I am looking for someone who can help develop a five year forecast for an online startup product in the home service market. Business revenue includes Service, Retail, Adverising, and Lead sales. more

Fixed, $500.00