I am working in the Demand Planning field for a company that produces pasta.
Our business is based on two models:
- Make to Order: We have a lead time of 4 weeks from the order receiving date
- Make to Stock: from the order we have to deliver the orders within 4-7 days.
The challenge is the Make to Stock business, where we have to be ready to ship product, but also to not have an infinite inventory.
I am kind of new to R, but what I'd like to do is a R code that every Friday I can run and generate the requirements for the next months.
My sales history file would be based on Dates (day), SKU and Q.ty, and I'd like to generate the forecast for the next 4 weeks.
Could you please help me or give me an hint on how to go ahead?