I’m managing the procurement of passenger car backorders from European Logistic Centers to warehouse in İstanbul. Also I find solutions or alternatives for backorders in bottleneck situation. I’m responsible for the backorder amounts. So faster procurement is essential. Besides, it is even more critical if a vehicle is off the road. Moreover, I’m the information channel for retailers.
The delivery date of a backorder is given from me manually. First, I check the Daimler program for the delivery date. Then I give that information to retailer with another program. Both programs are capable to import/export data with txt formats. So, there can be a software that take the data from Daimler program and put into retailer program after some mathematical procedures.
R has the tools to do text mining:
+ Basic Text Mining in R, Philip Murphy. https://rpubs.com/pjmurphy/265713
One of the main problem of my department is high stock values. That is mainly because of the human nature acts for aiming high service level degrees. Those acts are called “safe harbor” and “panic” as a term in reasons of bullwhip effect. So, to reduce the human effect and stock value, there can be an autonomous mathematical model for order quantities. Data is available for last three years. After the define the parameters and analyze the data, various model can be simulated. As a result, it seems possible to establish a system that can reduce the stock values with same service degree.
These are the tutorials for forecasting methods in R:
+ Forecasting Using R, DataCamp. https://www.datacamp.com/courses/forecasting-using-r
+ Forecasting Time Series Using R, Prof. Rob J Hyndman. https://robjhyndman.com/talks/MelbourneRUG.pdf
We present KPI reports every month. Those KPI data is taken from several excel reports manually in every time. The excel sheets are always changing, there for linkage between excel and PowerPoint isn’t working. So, if there is a software that connected those excels to PowerPoint the KPI reports become available, not just a strict period, live.
It is possible to link the Excel sheeets to PowerPoint:
+ Create and Update PowerPoint Reports using R, Tim Bock. https://www.r-bloggers.com/create-and-update-powerpoint-reports-using-r/
+ Create and format PowerPoint documents from R software, STHDA. http://www.sthda.com/english/wiki/create-and-format-powerpoint-documents-from-r-software