Publications-Books & Chapters in Books

TitleA Study of Models for Forecasting E-Commerce Sales During a Price War in the Medical Product Industry
Creator謝佩璇
Hsieh, P. H.
Contributor資科系
Key WordsE-commerce  ; Price war  ; Sales forecasting ;  Inventory plan 
Date2019-06
Date Issued25-May-2020 10:15:00 (UTC+8)
SummaryWhen faced with a price war, the accuracy of forecasting sales in e-commerce greatly influences an enterprise’s or a retailer’s merchandise inventory strategies. When faced with a price war, an enterprise might obtain certain consumption patterns by analyzing previous sales data. This case study research was conducted in collaboration with a medical product company to explore which of the various forecasting models can better inform a company’s inventory plan. The study used the company’s data from Amazon.com regarding sales volume, number of views, company ranking, etc. between February 7 2016 and March 28 of 2018. Three potential methods of data mining were selected from the literature: the exponential smoothing method, the linear trend method, and the seasonal variation method. Of these, the most suitable was identified for price war situations to forecast the sales volume for April 2018 and to provide concrete information for the company’s inventory plan. The results showed that the seasonal variation method is more suitable than the other two sales forecasting methods. To obtain a more accurate sales forecast during a price war, the seasonal variation method is recommended to be used in the following approaches: Adjust the seasonal index by using a simple moving average. Remove the seasonal index from the sales volume, and conduct a regression analysis using the data within the last month. The resulting predicted value (with the seasonal index removed) should be multiplied by each period’s corresponding weighted moving average to obtain a more accurate sales forecast during a price war.
RelationHCI in Business, Government and Organizations. eCommerce and Consumer Behavior, Springer, pp.3-21
Type專書篇章
dc.contributor 資科系
dc.creator (作者) 謝佩璇
dc.creator (作者) Hsieh, P. H.
dc.date (日期) 2019-06
dc.date.accessioned 25-May-2020 10:15:00 (UTC+8)-
dc.date.available 25-May-2020 10:15:00 (UTC+8)-
dc.date.issued (上傳時間) 25-May-2020 10:15:00 (UTC+8)-
dc.identifier.uri (URI) http://nccur.lib.nccu.edu.tw/handle/140.119/129727-
dc.description.abstract (摘要) When faced with a price war, the accuracy of forecasting sales in e-commerce greatly influences an enterprise’s or a retailer’s merchandise inventory strategies. When faced with a price war, an enterprise might obtain certain consumption patterns by analyzing previous sales data. This case study research was conducted in collaboration with a medical product company to explore which of the various forecasting models can better inform a company’s inventory plan. The study used the company’s data from Amazon.com regarding sales volume, number of views, company ranking, etc. between February 7 2016 and March 28 of 2018. Three potential methods of data mining were selected from the literature: the exponential smoothing method, the linear trend method, and the seasonal variation method. Of these, the most suitable was identified for price war situations to forecast the sales volume for April 2018 and to provide concrete information for the company’s inventory plan. The results showed that the seasonal variation method is more suitable than the other two sales forecasting methods. To obtain a more accurate sales forecast during a price war, the seasonal variation method is recommended to be used in the following approaches: Adjust the seasonal index by using a simple moving average. Remove the seasonal index from the sales volume, and conduct a regression analysis using the data within the last month. The resulting predicted value (with the seasonal index removed) should be multiplied by each period’s corresponding weighted moving average to obtain a more accurate sales forecast during a price war.
dc.format.extent 605665 bytes-
dc.format.mimetype application/pdf-
dc.relation (關聯) HCI in Business, Government and Organizations. eCommerce and Consumer Behavior, Springer, pp.3-21
dc.subject (關鍵詞) E-commerce  ; Price war  ; Sales forecasting ;  Inventory plan 
dc.title (題名) A Study of Models for Forecasting E-Commerce Sales During a Price War in the Medical Product Industry
dc.type (資料類型) 專書篇章
dc.identifier.doi (DOI) 10.1007/978-3-030-22335-9_1
dc.identifier.doi (DOI) https://doi.org/10.1007/978-3-030-22335-9_1