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.