Demand Forecasting and Ordering Policy of Fast-Moving Consumer Goods with Promotional Sales in a Small Trading Firm

Authors

  • Kanjanataj Chaowai Chulalongkorn University
  • Parames Chutima Chulalongkorn University

DOI:

https://doi.org/10.4186/ej.2024.28.4.21

Keywords:

luxury products, niche fast-moving consumer goods (FMCGs), demand forecasting, hybrid ordering policy, promotional sales

Abstract

This research focuses on enhancing inventory management for fast-moving consumer goods (FMCGs) with promotional sales in a small trading company, particularly high-end items with fluctuating demand patterns. The analysis revealed that promotional campaigns led to an average demand increase of 60.44% for WM 85ML, and 161.76% for SW 85ML, highlighting the importance of including these variables in demand forecasting models. The research aims to determine an effective forecasting method for the company and develop an improved purchasing strategy. The methodology encompasses a comprehensive review of the existing system, problem investigation, solution proposal, and result analysis. Quantitative time-series forecasting methodologies specifically tailored to such luxury FMCGs were introduced including Exponential Smoothing and Holt-Winters’s Additive and Multiplicative forecasting. The application of these methods has led to a significant enhancement in forecast accuracy, with an approximate 90% improvement. The research's pivotal contribution is the development of a hybrid order policy named “Periodic Review with Safety Stocks and Reorder Point,” which merges a fixed-order quantity model with a fixed-time period model. This hybrid approach has practical implications for maintaining efficient inventory levels, enabling continuous promotional activities, and potentially reducing the company's inventory costs by approximately 30%.

Downloads

Download data is not yet available.

Author Biographies

Kanjanataj Chaowai

Regional Centre for Manufacturing Systems Engineering, Chulalongkorn University, Thailand

Parames Chutima

Regional Centre for Manufacturing Systems Engineering, Chulalongkorn University, Thailand

Department of Industrial Engineering, Faculty of Engineering, Chulalongkorn University, Thailand

The Academy of Science, The Royal Society of Thailand, Thailand

Downloads

Published In
Vol 28 No 4, Apr 30, 2024
How to Cite
[1]
K. Chaowai and P. Chutima, “Demand Forecasting and Ordering Policy of Fast-Moving Consumer Goods with Promotional Sales in a Small Trading Firm”, Eng. J., vol. 28, no. 4, pp. 21-40, Apr. 2024.