博文

18/6/2025

 16/6/2025 Today, I successfully completed the analysis task assigned by the Executive. The main content was to count the Out of Stock (OOS) of all products within a specified time range and calculate how many days each SKU was in the OOS state. In the afternoon, I attended a meeting on MinMax and Replenishment output.

17/6/2025

 17/6/2025 Today, I will continue to learn more about the structure and logic of the MinMax output file, and further understand the actual role of each field in inventory management and replenishment strategy. At the same time, I will also start to study and analyze the content of the Replenishment file, and try to understand how the entire replenishment script works.

16/6/2025

 16/6/2025 Today's main task is to understand the content of the MinMax output file and its business meaning, so that the data can be analyzed and applied more effectively in the future. Read and parse each column of data in the MinMax file one by one, and understand the name, unit and calculation logic of each field.

13/6/2025

 13/6/2025 Today we continued to complete the work of integrating holiday factors into the sales forecasting model, and used the new model that included holiday information to predict sales, and then compared and analyzed the prediction results with the original prediction results that did not include holiday factors.

12/6/2025

 12/6/2025 Today we are focusing on finding ways to further improve the accuracy of sales forecasts, especially considering incorporating holiday effects into the model to more closely match real sales fluctuations.

11/6/2025

 11/6/2025 Today, we will continue to study the parameter adjustment method of the SARIMA model in depth, focusing on finding the parameter combination that best suits the current sales data. By systematically testing different (p, d, q)(P, D, Q, s) configurations and combining the actual sales cycle and seasonal characteristics, we will gradually select several model versions with good performance. After each parameter setting, we will find the model with the smallest MAPE to ensure that the model has higher reliability in practical applications.

10/6/2025

 10/6/2025 Today, we successfully completed the construction of the SARIMA model and began to apply it to the prediction of actual sales data. After model training, we generated sales forecasts for the next few days and compared them with the actual data to evaluate the accuracy of the model.