Abstract:
This research aims 1) To study the forecast product demand in a case study of skincare companies and 2) To present an appropriate forecasting method for the purchase planning of skincare products case study. The purposive sampling method was used in this independent study. The sales data of the company's product list, a case study of skin care products in the past 1 year records, from January 2021 to December 2021 are used. The researchers selected only the top five best-selling skincare products of the company which accounted for more than 80% of the company's total sales. This research applied the data obtained to the analytical process in the forecasting model using 4 methods as follows; 1) moving average method 2) weighted average method 3) exponential smoothing method and 4) trend forecasting method. Then, the forecast results were compared to find the least error by MAD, MSE, and MAPE methods for finding the least forecast error. The most suitable forecasting method is used in purchasing planning. The research results of the analysis revealed that skincare products are unique products in distribution. Therefore, each product type has a specific forecasting model that is suitable for different skincare products as follows; 1) SOQU Aloe Vera gel, a jar of 100 milligrams is suitable for the moving average method. 2) The Aloe Vera sheet mask is suitable for the weighted average method. 3) The tomatoes sheet mask is suitable for the exponential smoothing method. 4) BARONESS Aloe Vera soothing gel Sachet size of 100 milligrams is suitable for the trend forecasting method and 5) Aloe Vera gel, a jar of 300 milligrams is suitable for the weighted average method.