I want to forecast the inventory using R. I am having variables Date. product id and number of units

i want to forecast it using R . Any suggestion or realtime example is highly appreciated

I want to forecast the inventory using R. I am having variables Date. product id and number of units

i want to forecast it using R . Any suggestion or realtime example is highly appreciated

Hi there,seems to me like what you need is a classic regression ,since time is not of essence.

Is this a school or work project?

If it is work then have you tried using the R package called prophet?

https://cran.r-project.org/web/packages/prophet/index.html

If it is school what is the requirements for the class? What methods have you used thus far?

Test for regression assumption before you decide seasonality and cyclic variations. Time series is your other alternative.

Since you have different variables available in addition to time and quantity data, you can try ARIMA with external regressor. However, Iâ€™d suggest you to go with simple time series modelling using ARIMA, Prophet (facebookâ€™s) and NeuralNet, and look at your forecasting accuracy. If that doesnâ€™t workout, then only use the same techniques with external regressors. If you still see that your accuracy isnâ€™t improving, you can consider tuning the ordering of your time series.

There are more advance techniques available as well such as BSTS (googleâ€™s) or LSTM (Neural net), but would suggest you to take a look at them once youâ€™ve tried and tested the basics one.

As you pointed out correctly that seasonality, stationarity and cyclicity will be of essence and thus should be incorporated in the model, regular regression can not be used.

Let me know in case you need links to read more about these techniques.

Peace!

I suggest you tell your company youâ€™re struggling with the requirements and need some help. Itâ€™s weird, I take on side projects as a Data Scientist and have always researched ways to help me. If youâ€™re a Data Scientist or something similar and represent your company, why is that you need help with a simple forecasting algorithm with simplified variables? Iâ€™ll keep fighting for my chance to one day be a fully employed Data Scientist.

brother thats the dark side of being a data scientist . you dont have much help or resource available within your organisation.

I may be completely wrong but just check this stackexchange post if it helpsâ€¦

https://stats.stackexchange.com/questions/149191/dealing-with-spikes-in-data

I think what you should do first is to define the problem precisely.

Whatâ€™s you companyâ€™s product strategy and competitive pressures ?

Is the Inventory too much?

Is the demand plan always terrible? have impact on supply chain?

You want to only reduce inventory fare ?

After reduction, it can still satisfy customersâ€™ requirements ?

meet rate orders increased frequency ?

Or your goal is only to reduce the inventory capacity shortages ?

â€¦

You should pick one as an optimization problem under some constraints.

**What you want to solve is more important than making technology choices**

After definition, Combined with actual business requirements,

you can use any modeling software,even only Excel , to model \ test the algorithm.

**Sometimes simple rule or model is better than complex algorithm**

especially for some cold-start problems or lack of good data.

**Last but not least:
Rome was not built in a day
so be able to do just-in-time development, rapid iterations and run multiple experiments**

Some tips:

Many related contests are related with inventory,both in AV and Kaggle:

Practice Problem: Black Friday

Practice Problem: Big Mart Sales III

Practice Problem: Time Series

walmart-recruiting-store-sales-forecasting

grupo-bimbo-inventory-demand