Determination of Optimum Smoothing Constant of Single Exponential Smoothing Method: A Case Study
- سال انتشار: 1396
- محل انتشار: فصلنامه بین المللی تحقیقات در مهندسی صنایع، دوره: 6، شماره: 3
- کد COI اختصاصی: JR_RIEJ-6-3_001
- زبان مقاله: انگلیسی
- تعداد مشاهده: 206
نویسندگان
Department of Industrial and Production Engineering, Jessore University of Science and Technology, Jessore-۷۴۰۸, Bangladesh
چکیده
Exponential smoothing is a sophisticated forecasting method that works based on previous forecast plus a percentage of the forecast error. A key issue of this technique is the proper choice of exponential smoothing constant. In order to minimize forecasting errors, choosing an appropriate value of smoothing constant is very crucial. In this study, a framework is developed for the selection of optimal value of smoothing constant that minimizes a measure of forecast errors like mean square error (MSE) and mean absolute deviation (MAD). Both “trial & error” and Excel based non-linear optimizer (“Excel Solver”) are used for this purpose. To validate the proposed model, necessary demand data of Ruchi Jhal Muri from years ۲۰۱۰-۲۰۱۶ from Square Food & Beverage Ltd. in Mohakhali, Dhaka were collected. The optimum values of smoothing constant under trial & error method are ۰.۳۱ and ۰.۱۴ for minimum MAD and MSE respectively whereas for excel solver, values are ۰.۳۱۴ and ۰.۱۴۳ with respect to minimum MAD and MSE. Although both methods provide approximately the same results but excel solver is much easier & requires less time for deriving optimum solution. This study will provide an outline for the forecast planners as well as manufacturers to improve the accuracy of exponential forecasting through using Excel Solver for determining the optimum value of smoothing constant.کلیدواژه ها
Smoothing Constant, Forecast Error, Trial and error method, Excel Solverاطلاعات بیشتر در مورد COI
COI مخفف عبارت CIVILICA Object Identifier به معنی شناسه سیویلیکا برای اسناد است. COI کدی است که مطابق محل انتشار، به مقالات کنفرانسها و ژورنالهای داخل کشور به هنگام نمایه سازی بر روی پایگاه استنادی سیویلیکا اختصاص می یابد.
کد COI به مفهوم کد ملی اسناد نمایه شده در سیویلیکا است و کدی یکتا و ثابت است و به همین دلیل همواره قابلیت استناد و پیگیری دارد.