Remote Data Mining And Management Job In Data Science And Analytics

Forecasting of supply chain in excel from SQL database

Find more Data Mining And Management remote jobs posted recently Worldwide

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 Nov 11, 2022
Divyaprakash
from Pas-de-Calais, France

Skills & Expertise Required

Budgeting & Forecasting Financial Forecasting Statistics Supply Chain Management 
Candidate shortlisted and hiredHiring open till - Jan 6, 2023

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$239.72

Cost

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

Other jobs by this client

Windows 7 patch needed to reconnect a mapped network drive if it disconnects - Hourly
Texture designer needed for Arma 3 community. - Fixed
Azure - Docker Specialist Needed - Hourly
Integrate a 5" display into our housing using SolidWorks - Fixed
SDK for Video Calls - Fixed
Front End Dev - Wordpress - Elementor - Woocommerce - Hourly
Salesforce Lightning - Consultant - Hourly
Book Keeper - Hourly
Glitchcraft Key West cassette tape - Fixed
Outstanding High level C# .NET MVC Expert remote role - Hourly
Software engineer needed to do my project on C++ - Fixed
Design Inventory and Order Management System for Amazon Seller - Fixed
Need a Web Developer to clone a website - Fixed
Need help setting up email marketing campaigns for my store - Hourly

Similar Projects

I need an excel equation For statistics

I just need an excel equation that provides statistics of numbers that comes after certain number in a table

Research to find formula for lunar calculator

Looking for the formula for a specific lunar calculation to apply toward a user friendly calculator

I need to calculate the statistical significance of a sequence of events of human behaviour

My problem is that I have an ex-partner who has presented a significant number of stories in court and in her affidavit that I can mostly prove are lies. When answered one by one in court, she can come up with a fanciful excuse. Although these ex...read more

Sourcing Agent

Hi,
we are a native company which want to sell mask to protect people from the coronavirus. So were looking for a sourcing agent who can find us mask with a very great quality and a good price, join to it a packaging with our brand Hatake and...read more

Statistician for Small Area Estimation Project

We are looking for an experienced statistician to help with a small area estimation project. We need to take national-level government data and calculate county-level and census tract-level estimates of this data.

We are looking for someone...read more