skip to main content
10.1145/3306500.3306517acmotherconferencesArticle/Chapter ViewAbstractPublication Pagesic4eConference Proceedingsconference-collections
research-article

Demand forecasting for online market stock: case study cleanroom apparel

Published: 10 January 2019 Publication History

Abstract

This research aims to study and develop a forecasting framework for an appropriate production planning demand as well as to analyze the trend of future sales in order to plan the production in line with an increased demand by exploring time series forecasting. This paper studies data characteristics of past volumes of goods sales namely Product A B C E and L, so that an appropriate forecasting technique can be chosen. By comparing 4 forecasting methods including Moving Average, Single Exponential Smoothing, Double Exponential Smoothing, and Regression Analysis Method. Test results show that the forecasting method giving the least errors for Product A is Regression Analysis Method, with the equation Y=403.4-0.62x which gave the lowest MAPE value equals to 22.03. The economic order quantity (EOQ) of Product is 172 units with the total cost of 27,345.51 Baht. Whereas, the forecasting method for Product B is Single Exponential Smoothing Method with α value equals to 0.056, which gave the lowest MAPE value at 72.20. The EOQ of Product B is 150 units with the total cost of 23,280.66 Baht. The forecasting method for Product C is Regression Analysis Method, with the equation Y=417.4-0.82x which gave the lowest MAPE value equals to 28.1. The EOQ of Product C is 193 units with the total cost of 24,953.52 Baht. The forecasting method for Product E is Moving Average N=3, which gave the lowest MAPE value equals to 31.5. The EOQ of Product E is 336 units with the total cost of 14,109.57 Baht. Lastly, the most appropriate forecasting method for Product E is Regression Analysis Method, with the equation Y=1092-3.88x which gave the lowest MAPE value equals to 47. The EOQ of Product E is 1844 units with the total cost of 6,639.97 Baht.

References

[1]
KASIKORN Research. 2018. K SME Analysis. 2018. KASIKORN Research Center Company Limited: KResearch.
[2]
Packianathera, M. S., Daviesa, A., Harradena, S., Somanb, S., and White, J. 2016. Data mining techniques applied to a manufacturing SME. In Proceedings of the 10th CIRP Conference on Intelligent Computation in Manufacturing Engineering (The Ischia, The Italy, July 20--22, 2016)
[3]
O'Connell, R. T. and Koehler, A. B. 2005. Forecasting, Time Series, and Regression: An Applied Approach. University of California.
[4]
Vhatkara, S. and Diasb, J. 2016. Oral-Care Goods Sales Forecasting Using Artificial Neural Network Model. In Proceedings of the 7th International Conference Communication, Computing and Virtualization (The Mumbai, The India, Feb 26--27, 2016)
[5]
Boulaksil, Y. 2016. Safety stock placement in supply chains with demand forecast updates. Operations Research Perspectives, 27--31
[6]
Xuan, Z. Zhubing, F. Liequan, L. Junwei, Y. and Dongmei, P. 2017. Comparison of four algorithms based on machine learning for cooling load forecasting of large-scale shopping mall. In Proceedings of the 9th International Conference on Applied Energy (The Cradiff, The United Kingdom, Aug 21--24, 2017)
[7]
Sutheebanjard, P. and Premchaiswadi, W. Forecasting the Thailand Stock Market Using Evolution Strategies, Asian Academy of Management Journal of Accounting and Finance AAMJAF, Vol. 6, No. 2, 85--114, 2010
[8]
Kandananond, K. Forecasting Electricity Demand in Thailand with an Artificial Neural Network Approach, Energies 2011, 4, 1246--1257
[9]
Aungkulanon, P. and Luangpaiboon, P. Evolutionary Computation Role in Improving an Accuracy of Forecasting Mortality Data. Int. J. Advance Soft Compu. Appl, Vol. 10, No. 2, July 2018
[10]
Boenkost, Wolfram & Schmidt, Wolfgang. (2005). Cross Currency Swap Valuation. SSRN Electronic Journal.

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences
IC4E '19: Proceedings of the 10th International Conference on E-Education, E-Business, E-Management and E-Learning
January 2019
469 pages
ISBN:9781450366021
DOI:10.1145/3306500
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 10 January 2019

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. economic order quantity
  2. forecasting method

Qualifiers

  • Research-article

Conference

IC4E 2019

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • 0
    Total Citations
  • 182
    Total Downloads
  • Downloads (Last 12 months)13
  • Downloads (Last 6 weeks)2
Reflects downloads up to 03 Mar 2025

Other Metrics

Citations

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media