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 Mar 14, 2020
Lionel Gough
from England, United Kingdom

Skills & Expertise Required

Budgeting & Forecasting Financial Forecasting Statistics Supply Chain Management 
Candidate shortlisted and hired
Hiring open till - Feb 14, 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

Script writer needed - Fixed
Developer Needed for WordPress Product Page Enhancements - Avada Theme - Hourly
Developer needed for creating Object Detection and Machine Learning App - Fixed
Need someone to install stereo equipment at our studio. - Hourly
I need WordPress edits for my website. - Hourly
AWS Site Reliability and DevOps Engineer needed - Fixed
Direct Mail Software Expert - Hourly
shopify website changes, and set up - Hourly
Create a 10-second video intro - Fixed
Digital Matte Painting - Street-Level 1980s Detroit with a Twist! - Fixed
Install SSL in a Wordpress server - Fixed
NEED Android app - confession & free writing - Fixed
360 Degree Drone Photo Stitch - Hourly
Workflow for Business Central with MS Flow - Fixed
Video Editing - Fixed

Similar Projects

Run a Principal Component Analysis in R (preferred) or PRIMER

Run a PRINCIPAL component analysis (PCA) in R Studio / R Cloud or PRIMER.

The question is;
Can these factors (age, sex, distance, treatment) explain X% of the variation in participants responses.

Data has been prepared for you....read more

Data Scientist

Hello, I am a student doing my final year project and I require a data scientist to write an algorithm for me. The whole system doesnt need to be elaborate because I only need it to run simple beta testing to show that it works.

I would lik...read more

•IBP S&OP, Inventory Optimization and Supply Chain Control Tower

- Certification in SAP IBP, APICS-CSCP, APICS-CPIM will be preferred.
- Preferred knowledge in Analyzing the CPI-DS Job Trace, Error & Monitor logs.
- Knowledge in recognized Quality testing tools.
- Experience in SAP APO - DP, SNP and PP...read more

SAS data project help

I have a SAS data project and I need help with it.
Below is the details of the project. Let me know if you know how to solve it:

Estimate the determinants of the change in total population in US counties over 2010-2017. Your sample cons...read more

Ecommerce Customer Service and Product Management

We are looking for someone to assist us in our new multivendor marketplace platform. Someone with good customer service skills to handle all the customer and seller communication, also someone with an ecommerce background that will be able to manage...read more