Intern(Chow Jun Hoe)

 31/3/2025 Public Holiday

28/3/2025 Learn and explore different methods to apply Weighted Moving Average (WMA) for sales forecasting. This time, the focus is on how to adjust weights according to different time dimensions (such as weekdays/weekends and quarters). Finally, further combine the average sales of each weekday to make forecasts, calculate the sales share of different weeks, and adjust the WMA weights to ensure that the forecast data is closer to the actual sales pattern.

 27/3/2025 Continue to study sales forecasting methods, focusing on learning and applying weighted moving average (WMA) for data analysis. In addition, analyze the sales during the same festival period (such as Hari Raya, Spring Festival, etc.) in historical data, compare the sales patterns of the same festival in different years, and identify the impact of festivals on sales. By calculating the sales share during the festival period, establish a forecasting model based on festival sales weights to more accurately estimate the sales of the upcoming holidays.

 26/3/2025 Learn how to calculate the High-Level Average to get a more accurate view of overall sales trends. By analyzing sales data over the past period of time (two years), calculate the overall average sales volume to obtain a more representative benchmark sales level. On this basis, further analyze the weekly sales share and calculate the ratio of weekly sales to the high-level average to identify sales patterns in different time periods.

 25/3/2025 Go online to conduct in-depth research and compare various sales forecasting methods to find the best solution for the current business scenario. This includes using the compound annual growth rate (CAGR) to predict long-term sales trends to measure the average annual growth rate of sales and help formulate more accurate sales plans. At the same time, study the impact of promotional activities and holidays on sales, analyze the sales share during promotional periods or specific holidays (such as Hari Raya) in historical data, calculate the sales contribution rate of these special periods, and build a forecasting model based on this.

24/1/2025 Attend the meeting to understand the current delivery and inventory status of goods, confirm whether the promotional goods have been delivered to the designated outlets, and ensure that all promotional goods are in sufficient stock before Hari Raya to meet market demand. During the meeting, focus on the goods that have not yet arrived, coordinate logistics arrangements, ensure the smooth operation of the supply chain, and avoid sales performance affected by delayed delivery or out-of-stock. Then, submit a report on the sales forecast research last week to the Supply Chain Manager, detailing the research process, methods used (such as time series analysis, machine learning, etc.), the accuracy of the forecast results, and possible improvement directions. Have an in-depth discussion with the manager, listen to feedback, and adjust the forecast strategy according to business needs. Next, combine the manager's suggestions and the latest data to further explore and test other ...

 21/3/2025 Continue to explore and test various sales forecasting methods, including using different time periods for forecasting, to find the most accurate forecasting method. Attend meetings in the afternoon to discuss inventory status during the promotion period with relevant teams (such as managers and executives), focusing on products that have already started or are about to start promotions, especially products that are at risk of being out of stock (OOS), and develop corresponding response strategies to ensure the smooth progress of promotions.

20/3/2025 Extract the sales quantity data of the past two years from Qlik Sense and conduct in-depth analysis. At the same time, based on the historical data of the past two years, predict the sales quantity in the next three days. Then communicate and discuss with the executive.

19/3/2025 Data related to Soh (Stock on hand), Sales (Sales data) and Warehouse Stock (Warehouse Stock) from January 2, 2025 to March 19, 2025 are extracted from Qlik Sense, and the data integrity is checked and initially cleaned. Subsequently, the stock level and warehouse stock allocation are analyzed by building visualization charts such as line charts and bar charts. Finally, the analysis results are discussed and corrected with the Supply Chain Forecast and Promotion Executive.

 18/3/2025 Public Holiday

17/3/2025 Extract Soh (Stock on Hand), Sales (sales data) and Warehouse Stock (warehouse stock) related data from Qlik Sense and conduct in-depth analysis to identify the relationship between inventory and sales trends, and build visualization charts such as line charts and bar charts to more intuitively present data patterns. 

 Restday