หน้าแรก / วารสารวิชาการ / The Sales Forecasting and Development of a Statist...
The Sales Forecasting and Development of a Statistical Website for P.E. Paper Co., Ltd.
อ.รุ่งทิพย์ โคบาล  |  Sales Forecasting   Association Rules   Time Series Analysis  
จำนวนผู้เข้าชม
20
CC BY-NC-ND Creative Commons License
The Sales Forecasting and Development of a Statistical Website for P.E. Paper Co., Ltd. is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 Thailand License.
เปิดลิงก์เอกสาร
DOI Link EndNote OpenURL
Collection RMUTK Research Repository (RMUTK IR)
วารสารวิชาการ — e-Journal Articles
ID RMUTK Digital RMUTK000112
Title The Sales Forecasting and Development of a Statistical Website for P.E. Paper Co., Ltd.
Alternative title The Sales Forecasting and Development of a Statistical Website for P.E. Paper Co., Ltd.
Authors ผศ.ดร.นิกร กรรณิกากลาง Corresponding
อ.รุ่งทิพย์ โคบาล ผู้แต่งหลัก
ผศ.สุภษี ดวงใส
Faculty คณะบริหารธุรกิจ
Journal Title International Journal of Social Sciences and Business Research (IJSSBR)
ISSN 3088-3717
Volume / Issue / Pages Vol.1 | No.1 | pp.30-42
Published 2025-02-18
Year 2568
Level ระดับนานาชาติ (อื่นๆ)
DOI https://so20.tci-thaijo.org/index.php/ijssbr/article/view/572
Funding Source มทร.กรุงเทพ
Abstract This research presents a comprehensive approach to developing and implementing a sales forecasting system alongside a statistical website for P.E. Paper Co., Ltd. The study has three main objectives: first, to generate accurate forecasts of monthly and yearly sales; second, to identify product co-purchase patterns using association rule mining; and third, to develop a dedicated online platform for displaying the forecasting and analysis results. Adopting the Cross-Industry Standard Process for Data Mining (CRISP-DM), the methodology involves time series analysis for sales forecasting and the Apriori algorithm to uncover items that customers frequently purchase together. Drawing from a dataset of 5,622 sales records collected between 2017 and 2021, the study projects total sales of 21,402,008 THB in 2022 and 21,402,192 THB in 2023, indicating a consistent upward trend. Additionally, the most significant product association demonstrates that customers who buy brown paper (rolls) commonly also purchase perforated paper (rolls), reflecting a 60.54% confidence level. Expert assessments of the system revealed high efficiency (mean = 3.96, SD = 0.84) in both data analysis and website design. Furthermore, a user-satisfaction survey involving 30 participants rated the platform at the highest satisfaction level (mean = 4.52, SD = 0.50). The findings underscore the feasibility and advantages of an integrated forecasting and analytics website in optimizing inventory management and strategic decision-making.
Abstract (EN) This research presents a comprehensive approach to developing and implementing a sales forecasting system alongside a statistical website for P.E. Paper Co., Ltd. The study has three main objectives: first, to generate accurate forecasts of monthly and yearly sales; second, to identify product co-purchase patterns using association rule mining; and third, to develop a dedicated online platform for displaying the forecasting and analysis results. Adopting the Cross-Industry Standard Process for Data Mining (CRISP-DM), the methodology involves time series analysis for sales forecasting and the Apriori algorithm to uncover items that customers frequently purchase together. Drawing from a dataset of 5,622 sales records collected between 2017 and 2021, the study projects total sales of 21,402,008 THB in 2022 and 21,402,192 THB in 2023, indicating a consistent upward trend. Additionally, the most significant product association demonstrates that customers who buy brown paper (rolls) commonly also purchase perforated paper (rolls), reflecting a 60.54% confidence level. Expert assessments of the system revealed high efficiency (mean = 3.96, SD = 0.84) in both data analysis and website design. Furthermore, a user-satisfaction survey involving 30 participants rated the platform at the highest satisfaction level (mean = 4.52, SD = 0.50). The findings underscore the feasibility and advantages of an integrated forecasting and analytics website in optimizing inventory management and strategic decision-making.
Keywords (TH) Sales ForecastingAssociation RulesTime Series AnalysisWebsite DevelopmentCRISP-DM
Keywords (EN) Sales ForecastingAssociation RulesTime Series AnalysisWebsite DevelopmentCRISP-DM
Access Level Open Access (เปิดสาธารณะ)
ลิงก์แหล่งเผยแพร่
เอกสารฉบับเต็ม (ลิงก์ภายนอก)
https://so20.tci-thaijo.org/index.php/ijssbr/article/view/572
เปิดลิงก์